select atrybut, wartosc, GROUP_CONCAT(CONVERT(wartosc_id, CHAR( 8 )) SEPARATOR ',') as wartosc_id, sum(ilosc_produktow) as ilosc_produktow from (SELECT DISTINCT a.id as atrybut_id, a.nazwa as atrybut, ai.nazwa as wartosc, ai.id as wartosc_id, count(DISTINCT p.id) as ilosc_produktow FROM atrybuty a INNER JOIN atrybuty_items ai ON a.id = ai.atrybut INNER JOIN atrybuty_products ap ON ap.atrybut_item = ai.id INNER JOIN produkty p ON p.id = ap.produkt INNER JOIN produkty_kategorie pk2 ON pk2.id = p.kategoria INNER JOIN produkty_kategorie pk ON pk.id = pk2.parent_id LEFT JOIN produkty_kategorie_jc AS junc ON junc.produkt_id = p.id INNER JOIN producenci pr ON pr.id = p.producent WHERE 1=1 AND (pk.id=61 OR junc.parent_kat_id=61) AND (pk.id=61 OR junc.parent_kat_id=61) AND p.id IN (SELECT produkt FROM atrybuty_products WHERE atrybut_item IN (1354)) AND pk.`show`=1 AND pk2.`show`=1 AND p.`show`=1 AND pr.`show`=1 AND (pk2.id=159 OR junc.kategoria_id = 159) AND a.`show_drzewko`=1 and ai.`show`=1 GROUP BY a.id, a.nazwa, ai.nazwa, ai.id ORDER BY a.kategoria, a.position, a.nazwa, ai.position) as atrybuty group by atrybut, wartosc