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=215) WHERE (`e`.`entity_id` IN('1124', '1125', '1126', '1127', '4536', '4537', '4610', '4687', '8304', '8305', '8306', '8446', '8447', '8448', '8494', '8762', '8810', '9042', '11693', '11694', '11695', '11700', '11702', '11704', '11707', '11709', '11711', '11714', '11716', '11718', '11720', '11725', '11731', '11740', '11745', '11747', '11748', '11749', '11750', '11751', '11752', '11753', '11754', '11755', '11758', '11759', '11760', '11762', '11764', '11765', '11766', '11768', '11769', '11771', '11772', '11773', '11775', '11776', '11778', '11780', '11781', '11783', '11784', '11786', '11790', '11792', '11795', '11796', '11797', '11799', '11800', '11801', '11805', '11806', '11808', '11809', '11810', '11811', '11814', '11815', '11817', '11818', '11819', '11820', '11821', '11822', '11823', '11828', '11829', '11830', '11832', '11835', '11837', '11838', '11840', '11841', '11842', '11843', '11844', '11845', '11846', '11847', '11848', '11849', '11850', '11852', '11853', '11854', '11855', '11856', '11857', '11858', '11859', '11860', '11861', '11862', '11863', '11864', '11865', '11866', '11867', '11868', '11870', '11871', '11872', '11873', '11875', '11876', '11877', '11878', '11879', '11880', '11884', '11886', '11888', '11890', '11938', '11940', '11943', '11960', '16958', '20119', '20120', '20121', '25618', '25995', '26799', '29622', '29623', '29624', '31664', '31681', '31715', '31736', '31801', '31807', '31813', '31828', '31829', '31870', '31874', '31915', '32022', '32179', '32233', '32325', '34870', '34894', '34896', '34897', '34898', '35867', '35868', '35869', '35870', '35871', '35872', '35993', '36018', '36121', '36128', '36137', '36140', '36149', '42105', '42107', '42108', '42111', '42112', '42113', '42114', '42115', '42119', '42120', '42121', '42124', '42125', '42126', '42127', '42128', '42129', '42130', '42131', '42132', '42133', '42134', '42135', '42136', '42137', '42138', '42139', '42140', '42141', '42142', '42143', '42144', '42145', '42152', '42156', '42160', '42163', '42164', '42172', '42174', '42177', '42178', '42179', '42180', '42181', '42182', '42183', '42184', '42187', '42188', '42189', '42190', '42191', '45602', '45603', '45604', '45605', '45714', '45716', '45718', '45723', '45726')) ORDER BY `at_position`.`position` DESC LIMIT 24
