SELECT
              DISTINCT(nomeweb) AS marchio,
              COUNT(DISTINCT(CONCAT_WS(',',pd.articolo,pd.codice_tessuto))) as quantity
            FROM marchi_web_new
            JOIN prodotto_dati as pd ON pd.marchio = marchi_web_new.nome
            JOIN prodotto_quantita as pq ON pq.id_prodotto = pd.id
            WHERE pq.quantita_web > 0
            AND pd.web > 0
            -- AND active = '1'
            GROUP BY nomeweb
            ORDER BY ordinamento,nomeweb