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`='143' OR `pcat`.`category_id`='159' OR `pcat`.`category_id`='160' OR `pcat`.`category_id`='161' OR `pcat`.`category_id`='162' OR `pcat`.`category_id`='163' OR `pcat`.`category_id`='164' ) GROUP BY `pc`.`product_id` ORDER BY `p`.`product_position` ASC