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 = 'PIXEL'
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 = 'PIXEL'
)
GROUP BY p.cor_produto;
PIXEL
USA COLLECTIONS
Sizes
Colors
ALL PRODUCTS
PIXEL
Pixel features a white surface that serves as a base for artistic gold applications. Small dots in a subtle relief spread across the piece, bringing a sophisticated look.
