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=1852) WHERE (`e`.`entity_id` IN('34', '209', '231', '232', '530', '1166', '10322', '10323', '10345', '10346', '12103', '12104', '12431', '12657', '12658', '12708', '13560', '13561', '13692', '13693', '13828', '13829', '13882', '13903', '13996', '14001', '14036', '14385', '14493', '14506', '17146', '17228', '17247', '18240', '18434', '18722', '19323', '27438', '27441', '27443', '29358', '29360', '29361', '32668', '32691', '32694', '33090', '33982', '33983', '34452', '34453', '34528', '34530', '34531', '34532', '34767', '34771', '34772', '34773', '35306', '35667', '36290', '36292', '36293', '36294', '36298', '36299', '36300', '36301', '36302', '36303', '36304', '36306', '36308', '36309', '36310', '36313', '36314', '36315', '36316', '36319', '36321', '36322', '36323', '36324', '36325', '36326', '36327', '36795', '36796', '36797', '36798', '36803', '36804', '36805', '36806', '36807', '36808', '36812', '44047', '44048', '44049', '44073', '44074', '44075', '44078', '44112', '44581', '44586', '44625', '44627', '44675', '44696', '44793', '44835', '44876', '44920', '45055')) ORDER BY `at_position`.`position` DESC LIMIT 24
