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 = 'MEKNES'
    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 = 'MEKNES'
    )
    GROUP BY p.cor_produto;
MEKNES

MEKNES

USA COLLECTIONS

Sizes

  • 15x15 cm | 6”x6”

Colors

ALL PRODUCTS

MEKNES

Meknès takes after the Moroccan ceramics, reinterpreted from a contemporary standpoint. In the 15×15cm format, the series features uneven edges and subtle scaling that emphasize the handmade pieces.

Opening Report...
MEKNES