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=131) WHERE (`e`.`entity_id` IN('1081', '1082', '1083', '1084', '1085', '1086', '1087', '1088', '4507', '4508', '4509', '4510', '4511', '4524', '4525', '4560', '4561', '4592', '4593', '4707', '4708', '4709', '4710', '4711', '8499', '8775', '10512', '15043', '15044', '15047', '15051', '15052', '15056', '15065', '15071', '15073', '15080', '15096', '15125', '15181', '15206', '15208', '15209', '15210', '15214', '15215', '15216', '15384', '15421', '15488', '19220', '19221', '19222', '19223', '19224', '19230', '19231', '19233', '19234', '19236', '19237', '19238', '19239', '19240', '19241', '19243', '19244', '19245', '19246', '19247', '19250', '19251', '19252', '19253', '19255', '19256', '19257', '19258', '19259', '19260', '19261', '19262', '19263', '19264', '19265', '19266', '19267', '19268', '19269', '19271', '19272', '19273', '19274', '19275', '19276', '19277', '19278', '19279', '19280', '19281', '19283', '19284', '19285', '19286', '19287', '19288', '19289', '19290', '19291', '19292', '19293', '19294', '19295', '19296', '20167', '20381', '20382', '20383', '20384', '20385', '20386', '20387', '20388', '20389', '20390', '20391', '20392', '20393', '20394', '20395', '20396', '20397', '20398', '20399', '20400', '20401', '20404', '20407', '20408', '24064', '24090', '24346', '24359', '24363', '24393', '24589', '24741', '24912', '25130', '25144', '25318', '25596', '28550', '28551', '28552', '28553', '31668', '31672', '31686', '31703', '31721', '31730', '31743', '31883', '31987', '35756', '35757', '36068', '36256', '40057', '40058', '40059', '40060', '40061', '40062', '40064', '40065', '40066', '40067', '40068', '40069', '40070', '40071', '40072', '40073', '40074', '40075', '40076', '40077', '40081', '40082', '40084', '40085', '40086', '40087', '40088', '40089', '40090', '40091', '40092', '40093', '40096', '40097', '40098', '40099', '40102', '44931', '51341')) ORDER BY `at_position`.`position` DESC LIMIT 24
