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=210) WHERE (`e`.`entity_id` IN('107', '217', '218', '219', '276', '277', '278', '307', '347', '381', '420', '477', '478', '520', '621', '622', '678', '679', '680', '696', '1185', '1186', '1187', '4996', '10097', '10761', '11085', '11115', '12379', '12671', '12758', '13581', '13756', '13788', '14072', '14073', '14077', '14078', '14220', '14227', '14228', '14450', '14451', '14497', '14502', '14566', '14576', '14591', '14609', '14655', '14659', '14708', '14726', '14736', '14770', '14791', '14798', '14848', '16430', '16431', '16433', '16434', '16454', '16455', '16456', '16457', '16495', '16501', '16502', '16513', '16559', '16560', '16561', '16562', '16568', '16569', '16571', '16572', '16573', '16574', '16576', '16578', '16579', '16582', '16584', '16585', '16586', '16589', '16593', '16597', '16606', '16607', '16608', '16610', '16611', '16615', '17137', '17143', '17158', '17160', '17161', '17841', '17889', '17899', '17963', '18046', '18820', '18821', '18822', '18880', '18910', '19370', '19371', '19964', '19966', '19967', '19983', '19984', '19985', '22339', '22341', '22343', '26420', '26425', '26426', '26436', '26437', '26438', '26439', '26440', '26443', '26445', '26446', '26447', '26448', '26449', '26450', '26451', '26454', '26457', '26473', '26500', '26501', '26502', '26514', '26516', '26535', '26562', '26575', '26576', '26585', '26602', '26604', '26619', '26626', '26631', '26635', '26636', '26638', '26642', '26645', '26652', '26653', '26654', '26655', '26656', '26657', '26658', '26675', '26676', '26677', '26682', '26684', '26687', '26688', '26691', '26693', '26697', '26700', '26705', '26706', '26707', '26712', '26713', '26714', '26715', '26716', '26717', '26785', '29559', '29561', '29562', '29563', '29564', '29565', '29566', '29567', '29568', '29569', '29570', '29571', '29572', '29573', '29574', '29575', '29576', '29577', '29578', '29580', '29581', '29582', '29583', '29584', '29585', '29586', '31378', '31093', '31396', '32298', '32302', '32361', '32426', '32602', '32773', '32800', '32801', '33012', '33182', '33183', '33205', '31059', '31194', '31145', '31265', '31228', '33910', '33914', '34115', '34234', '34238', '34341', '34430', '34431', '34432', '34481', '34649', '34650', '34651', '34652', '35467', '35856', '35857', '35858', '35859', '35860', '35861', '35862', '35863', '36115', '36334', '36345', '36404', '36408', '36415', '36444', '36445', '36451', '36492', '36501', '36507', '36508', '36509', '42051', '42052', '42053', '42054', '42055', '42056', '42057', '42058', '43954', '43955', '44199', '44274', '44288', '44289', '44290', '44291', '44357', '44877', '45072', '45135', '45147', '45707', '45708', '45709', '54344', '54454')) ORDER BY `at_position`.`position` DESC LIMIT 24
