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=1747) WHERE (`e`.`entity_id` IN('204', '8748', '15639', '15648', '21726', '21727', '21728', '21729', '21730', '21732', '21733', '21734', '21735', '21738', '21739', '21740', '21741', '21742', '21743', '21744', '21745', '21746', '21747', '21748', '21749', '21750', '21751', '21752', '21753', '21754', '21755', '21756', '21757', '21758', '21759', '21760', '21762', '21764', '21765', '21766', '21767', '21769', '21770', '21771', '21772', '21774', '21776', '21777', '21778', '21779', '21780', '21781', '21784', '21786', '21787', '21788', '21789', '21790', '21791', '21792', '21793', '21794', '21795', '21796', '21798', '21799', '21800', '21801', '21802', '21803', '21804', '21805', '21806', '21807', '21808', '21809', '21810', '21812', '21813', '21814', '21815', '21817', '21818', '21820', '21821', '21822', '21823', '21824', '21825', '21826', '21827', '21828', '21829', '21830', '21832', '21833', '21834', '21835', '21836', '21837', '21838', '21839', '21840', '21841', '24165', '24281', '24334', '24438', '24462', '24463', '24484', '24580', '24612', '24652', '24659', '24696', '24772', '24790', '24802', '24857', '24862', '24866', '24879', '24899', '24944', '24947', '24957', '24964', '24966', '24979', '24993', '25001', '25065', '25084', '25140', '25188', '25202', '25274', '25285', '25634', '25635', '29286', '29287', '41670', '41671', '41672', '41673', '41674', '41675', '41676', '41678', '41679', '41680', '41681', '41682', '41684', '41685', '41686', '41687', '41688', '41689', '41690', '41691', '41692', '41693', '41694', '41695', '41696', '41700', '41701', '41702', '41703', '41704', '41705', '41706', '41707', '41708', '41709', '41710', '41711', '41712', '41713', '41714', '41715', '41716', '41717', '41718', '41719', '41720', '41721', '41722', '41723', '41724', '41725', '41726', '41727', '41728', '41729', '41730', '41731', '41732')) ORDER BY `at_position`.`position` DESC LIMIT 24
