SELECT DISTINCT(pd.macrocategoria) AS macrocategoria
FROM prodotto_dati as pd
INNER JOIN prodotto_quantita ON pd.id = prodotto_quantita.id_prodotto
WHERE 1
    AND pd.macrocategoria != ''
    AND pd.web = 1
    AND pd.quantita_web > 0
    --  AND pd.marchio IN ('CALVIN KLEIN','CALVIN KLEIN JEANS','CK CALVIN KLEIN','CALVIN KLEIN SPORT','CALVIN  KLEIN','CK SPORT','CALVIN KLEIN UNDERWEAR','CALVIN KLEIN LOUNGE','CALVIN KLEIN PERFORMANCE','CALVIN','KLEIN','CK','CALVIN KLEIN COLLECTION','CALVIN KLEIN 205W39NYC','CALVIN KLEIN ACCESSORI')