SELECT SQL_CALC_FOUND_ROWS DISTINCT d.cat_nameid, b.cat_id, a.* FROM produkty a JOIN produkty_rel b ON a.produkt_id = b.produkt_id JOIN cat_data d ON b.cat_id = d.cat_id WHERE ((b.cat_id=484)) AND skryt=0 AND a.lang_id = 1 AND d.lang_id = 1 GROUP BY a.produkt_id ORDER BY sorter asc, oblibene desc, novinka desc Obrovské balonky

Obrovské balonky