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=237) WHERE (`e`.`entity_id` IN('222', '223', '280', '281', '282', '283', '284', '285', '286', '287', '309', '312', '313', '349', '351', '352', '353', '354', '373', '374', '422', '424', '426', '427', '451', '480', '502', '522', '540', '541', '542', '543', '544', '545', '546', '547', '568', '569', '570', '571', '572', '573', '574', '631', '633', '635', '636', '682', '698', '1040', '1041', '9987', '9988', '10313', '10314', '10359', '10360', '10367', '10393', '10396', '11016', '11027', '11088', '11116', '12154', '12185', '12288', '12329', '12343', '12365', '12383', '12409', '12411', '12414', '12416', '12417', '12418', '12419', '12481', '12504', '12517', '12526', '12642', '12673', '12682', '12683', '12684', '12685', '12755', '12756', '12780', '13512', '13605', '13606', '13634', '14121', '14123', '14124', '14125', '14230', '14323', '14663', '14789', '14842', '15022', '16458', '16470', '16480', '16493', '16500', '16503', '16505', '16506', '16507', '16508', '16509', '16523', '16524', '16525', '16527', '16530', '16531', '16536', '16537', '16538', '16539', '16545', '16546', '16547', '16548', '16567', '16577', '16583', '16588', '16605', '16612', '16613', '16614', '17099', '17243', '17286', '17497', '18825', '18826', '18827', '18909', '18955', '18956', '18957', '18962', '19052', '19053', '19054', '19055', '19056', '19057', '19058', '19059', '19060', '19061', '19062', '19063', '19064', '19108', '19030', '19473', '19474', '19480', '19481', '19484', '19485', '19486', '19487', '19488', '19489', '19490', '19491', '19094', '19095', '30043', '30032', '30033', '30034', '30035', '30037', '30038', '30042', '30044', '30045', '30047', '30048', '30049', '30999', '32388', '32548', '32576', '32593', '32666', '32690', '32817', '32857', '32895', '33024', '33053', '33099', '33100', '33240', '31040', '31299', '31268', '31391', '31157', '31416', '31170', '31025', '31099', '31149', '31029', '31440', '31247', '31030', '31080', '31350', '31295', '31351', '31296', '31442', '31297', '31352', '31298', '31443', '31353', '31444', '31114', '31101', '31017', '31018', '31015', '33889', '33890', '33893', '33894', '33895', '33897', '33898', '33921', '33922', '33923', '34117', '34118', '34383', '34462', '35307', '35768', '36346', '36358', '36477', '36480', '36562', '36568', '44258', '44268', '44272', '44358', '44408', '44409', '44411', '44412', '44429', '44430', '44431', '44883', '45133', '45689', '45691', '45692', '46069', '54341', '54342', '54362', '54363')) ORDER BY `at_position`.`position` DESC LIMIT 24
