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=929) WHERE (`e`.`entity_id` IN('15520', '20702', '20703', '20704', '20705', '20706', '20707', '20708', '20709', '20710', '20711', '20712', '20713', '20714', '20715', '20716', '20717', '20718', '20719', '20720', '22958', '24950', '25765', '25774', '25776', '25779', '25781', '25783', '27474', '27476', '33814', '37678', '37679', '37680', '37681', '37682', '37683', '37685', '37686', '37687', '37688', '37689', '37690', '37691', '37692', '37693', '37694', '37695', '37696', '37697', '37698', '37699', '37700', '37702', '37703', '37704', '37705', '37706', '37707', '37708', '37709', '37710', '37711', '37712', '37713', '37714', '37716', '37717', '37718', '37719', '37720', '37721', '37723', '37724', '37725', '37726', '37727', '37728', '37729', '37731', '37732', '37733', '37734', '37735', '37736', '37737', '37738', '37739', '37740', '37741', '37742', '37743', '37744', '37745', '37746', '37747', '37748', '37749', '37750', '37751', '37752', '37753', '37754', '37755', '37757', '37758', '37759', '37760', '37761', '37762', '37763', '37764', '37765', '37766', '37767', '37768', '37769', '37770', '37771', '37772', '37773', '37774', '37775', '37776', '37777', '37778', '37779', '37780', '37781', '37782', '37783', '37784', '37786', '37787', '37788', '37789', '37790', '37791', '37792', '37793', '37794', '37795', '37796', '37797', '37798', '37799', '37800', '37801', '37802', '37803', '37804', '37805', '37806', '37807', '37808', '37809', '37810', '37811', '37812', '37813', '37814', '37815', '37816', '37817', '37818', '37819', '37820', '37821', '37822', '37823', '37824', '37825', '37826', '37827', '37828', '37829', '37830', '37831', '37833', '37834', '37835', '37836', '37837', '37838', '37839', '37840', '37841', '37842', '37843', '37844', '37845', '37846', '37847', '37848', '37849', '37850', '37851', '37852', '37853', '37854', '37855', '37856', '37857', '37858', '37859', '37860', '37861', '37862', '37863', '37864', '37865', '37866', '37867', '37868', '37869', '37870', '37871', '37872', '37873', '37874', '37875', '37876', '37877', '37878', '37879', '37880', '37881', '37882', '37883', '37884', '37885', '37886', '37887', '37888', '37889', '37890', '37891', '37894', '37895', '37896', '37897', '37898', '37899', '37900', '37901', '37902', '37903', '37904', '37905', '37906', '37907', '37908', '37909', '37910', '37911', '37912', '37913', '37914', '37915', '37916', '37917', '37918', '37919', '37920', '37921', '37923', '37924', '37925', '37926', '37928', '37929', '37930', '37931', '37932', '37933', '37934', '37936', '37937', '37938', '37939', '37940', '37941', '37942', '37943', '37944', '37945', '37946', '37947')) ORDER BY `at_position`.`position` DESC LIMIT 24
