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=1166) WHERE (`e`.`entity_id` IN('1146', '4534', '4556', '4603', '4604', '4625', '4695', '4706', '8484', '10486', '10608', '13124', '13125', '13126', '13127', '13129', '13130', '13132', '13133', '13134', '13135', '13136', '13139', '13140', '13144', '13148', '13150', '13151', '13156', '13160', '13161', '13163', '13164', '13169', '13170', '13171', '13172', '13173', '13175', '13178', '13181', '13184', '13187', '13188', '13193', '13194', '13196', '13201', '13202', '13204', '13205', '13211', '13212', '13217', '13220', '13223', '13224', '13229', '13232', '13238', '13239', '13240', '13241', '13243', '13244', '13245', '13247', '13250', '13253', '13257', '13261', '13263', '13265', '13266', '13267', '13268', '13269', '13270', '13272', '13274', '13312', '13314', '13320', '13321', '13323', '13326', '13327', '13329', '13330', '13331', '13332', '13334', '13336', '13337', '13350', '13351', '13352', '13353', '13367', '13376', '13378', '13381', '13382', '13383', '13394', '13400', '13402', '13404', '13406', '13407', '13409', '13410', '13412', '13414', '13422', '13428', '13429', '13430', '13431', '13432', '13433', '13435', '17051', '18850', '31656', '31659', '31662', '31719', '31727', '31892', '31931', '31939', '31952', '31966', '32131', '32181', '32183', '32195', '32197', '32199', '32201', '32205', '32210', '32211', '32213', '32214', '32215', '32216', '32321', '34899', '35816', '35937', '35975', '36069', '36085', '36106', '38879', '38880', '38881', '38882', '38883', '38884', '38885', '38886', '38887', '38888', '38889', '38890', '38891', '38892', '38893', '38894', '38896', '38897', '38898', '38899', '38900', '38901', '38902', '38904', '38905', '38906', '38907', '38908', '38909', '38910', '38911', '38912')) ORDER BY `at_position`.`position` DESC LIMIT 24
