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=216) WHERE (`e`.`entity_id` IN('1128', '1129', '1130', '1131', '1132', '1133', '1134', '1135', '1136', '1137', '1138', '1152', '4513', '4539', '4574', '4575', '4611', '4612', '4724', '8449', '8798', '10513', '14932', '15749', '15750', '15751', '15752', '15753', '15754', '15755', '15758', '15759', '15761', '15762', '15764', '15772', '15773', '15775', '15779', '15781', '15790', '15792', '15794', '15795', '15797', '15798', '16894', '16985', '17049', '17053', '19387', '20072', '20073', '20074', '20075', '20076', '20077', '20078', '20079', '20080', '20081', '20082', '20083', '20084', '20085', '20086', '20087', '20088', '20089', '20090', '20091', '24043', '24048', '24086', '24091', '24103', '24107', '24108', '24118', '24126', '24143', '24152', '24153', '24174', '24176', '24189', '24249', '24322', '24446', '24487', '24584', '24588', '24609', '24621', '24641', '24759', '24785', '24792', '24794', '24868', '24897', '24952', '25131', '25146', '25172', '25184', '25196', '25203', '25212', '25221', '25237', '25546', '25611', '25628', '25677', '25678', '26075', '26076', '26077', '26146', '26561', '26800', '29625', '29626', '29627', '29628', '29629', '29630', '29632', '29633', '29634', '29635', '29636', '29637', '29638', '29639', '29640', '29641', '29642', '29643', '29644', '29645', '29648', '29649', '29650', '29651', '29652', '29653', '29654', '29655', '29656', '29657', '29658', '29659', '27129', '31546', '31609', '31725', '31890', '31994', '32003', '32137', '33901', '34070', '34884', '34891', '35884', '35885', '35886', '35887', '35888', '35889', '35890', '35891', '35892', '35893', '35894', '35895', '35896', '35897', '35898', '35899', '35900', '35901', '35902', '35903', '35904', '35906', '35907', '35909', '35910', '35912', '35932', '35962', '35966', '35968', '35986', '35987', '35988', '36029', '36036', '36056', '36057', '36058', '36074', '36079', '36088', '36104', '36131', '36150', '36166', '36173', '36235', '36265', '36266', '36267', '36268', '36270', '36276', '36412', '36475', '39578', '39579', '39581', '39582', '39583', '39584', '39585', '39586', '39587', '39590', '39591', '39592', '39593', '39594', '39595', '39596', '39599', '39600', '39601', '39602', '39603', '39605', '39606', '39607', '39608', '39610', '39611', '39613', '39614', '39616', '39617', '39618', '39619', '39620', '39622', '39623', '39628', '39629', '39630', '39631', '39632', '44439', '44440', '44441', '44447', '44448', '44449', '44452', '44456', '44457', '44458', '44459', '44460', '44463', '44465', '44471', '44472', '44473', '44476', '44477', '44478', '44479', '44481', '44482', '44483', '44484', '44485', '44486', '44487', '44488', '44489', '44490', '44491', '44492', '44493', '44494', '44495', '44496', '44498', '44499', '44500', '44501', '44503', '44504', '44506', '44507', '44508', '44510', '44511', '44512', '44513', '44514', '44516', '44518', '44519', '44521', '44522', '44523', '44524', '44525', '44526', '44527', '44528', '44529', '44530', '44531', '44532', '44533', '44534', '44535', '44536', '44537', '44538', '44802', '44841', '44899', '44982', '44983', '45122', '54361')) ORDER BY `at_position`.`position` DESC LIMIT 24
