SELECT * FROM `products_to_categories` `pc` LEFT JOIN `products` `pr` ON `pc`.`products_id` = `pr`.`products_id` LEFT JOIN `manufacturers` `mn` ON `pr`.`manufacturers_id` = `mn`.`manufacturers_id` WHERE `pc`.`categories_id` IN (28,26,42,83,60,47,115,57,114,59,98,31,86,50,127,39,44,56,43,116) AND `pr`.`manufacturers_id` != 0 GROUP BY `pr`.`manufacturers_id` ORDER BY `mn`.`manufacturers_name`