SELECT `p`.`product_position`,`p`.`product_colors`,`pc`.`product_id` FROM `product_configuration` AS pc LEFT JOIN `product_category` AS pcat ON `pcat`.`product_id`=`pc`.`product_id` LEFT JOIN `products` AS p ON `pc`.`product_id`=`p`.`product_id` WHERE 1 AND ( `pcat`.`category_id`='4' OR `pcat`.`category_id`='5' OR `pcat`.`category_id`='14' OR `pcat`.`category_id`='15' OR `pcat`.`category_id`='16' OR `pcat`.`category_id`='17' OR `pcat`.`category_id`='18' OR `pcat`.`category_id`='19' ) GROUP BY `pc`.`product_id` ORDER BY `p`.`product_position` ASC