SELECT p.*
FROM view_produtos_usa p
WHERE p.mestre IS NULL
AND p.ativo_usa = 'true' AND p.ativo_usa_local = 'true'
AND p.rodape <> 'true'
AND p.nome NOT LIKE '% rs%'
AND p.nome NOT LIKE '% rodape%'
AND p.colecao = 'FILETTO'
AND p.area = (
SELECT MAX(inner_p.area)
FROM view_produtos_usa inner_p
WHERE inner_p.cor_produto = p.cor_produto
AND inner_p.mestre IS NULL
AND inner_p.ativo_usa = 'true' AND inner_p.ativo_usa_local = 'true'
AND inner_p.rodape <> 'true'
AND inner_p.nome NOT LIKE '% rs%'
AND inner_p.nome NOT LIKE '% rodape%'
AND inner_p.colecao = 'FILETTO'
)
GROUP BY p.cor_produto;
With reliefs that reproduce the aesthetics of brises, Filetto Slate is inspired by charred woods. The surface of the tile is contemporary, allowing for sober and elegant combinations.
