SELECT `e`.*, `price_index`.`price`, `price_index`.`tax_class_id`, `price_index`.`final_price`, IF(price_index.tier_price IS NOT NULL, LEAST(price_index.min_price, price_index.tier_price), price_index.min_price) AS `minimal_price`, `price_index`.`min_price`, `price_index`.`max_price`, `price_index`.`tier_price`, `cat_index`.`position` AS `cat_index_position`, `at_position`.`position` FROM `catalog_product_entity` AS `e`
INNER JOIN `catalog_product_index_price` AS `price_index` ON price_index.entity_id = e.entity_id AND price_index.website_id = '2' AND price_index.customer_group_id = 0
INNER JOIN `catalog_category_product_index` AS `cat_index` ON cat_index.product_id=e.entity_id AND cat_index.store_id=2 AND cat_index.visibility IN(2, 4) AND cat_index.category_id = '2'
LEFT JOIN `aw_shopbybrand_brand_product` AS `at_position` ON (at_position.`product_id`=e.entity_id) AND (brand_id=1072) WHERE (`e`.`entity_id` IN('13295', '13300', '13307', '38299', '38300', '38301', '38302', '38303', '38304', '38305', '38306', '38307', '38308', '38309', '38310', '38312', '38313', '38314', '38315', '38316', '38317', '38318', '38319', '38320', '38321', '38322', '38323', '38324', '38325', '38326', '38327', '38328', '38329', '38330', '38331', '38332', '38334', '38335', '38336', '38337', '38338', '38339', '38340', '38341', '38342', '38343', '38344', '38345', '38347', '38348', '38349', '38350', '38351', '38352', '38353', '38354', '38355', '38356', '38357', '38358', '38359', '38360', '38361', '38362', '38363', '38364', '38365', '38366', '38367', '38368', '38369', '38370', '38373', '38374', '38376', '38377', '38378', '38379', '38380', '38381', '38382', '38383', '38384', '38385', '38386', '38387', '38388', '38389', '38390', '38391', '38392', '38393', '38394', '38395', '38396', '38397', '38398', '38399', '38400', '38401', '38402', '38403', '38404', '38405')) ORDER BY `at_position`.`position` DESC LIMIT 24
