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=2248) WHERE (`e`.`entity_id` IN('213', '214', '215', '245', '246', '247', '249', '250', '251', '252', '254', '255', '256', '257', '258', '259', '260', '261', '262', '303', '304', '339', '340', '367', '368', '404', '405', '406', '407', '408', '409', '410', '411', '412', '413', '414', '415', '551', '605', '606', '607', '657', '662', '673', '674', '704', '982', '983', '984', '985', '986', '987', '988', '989', '990', '991', '992', '993', '994', '996', '997', '998', '999', '1000', '1001', '1004', '1005', '1006', '1008', '1009', '9993', '10365', '10369', '10372', '10382', '10390', '10392', '10395', '10991', '10994', '11007', '11008', '11021', '11028', '11034', '11080', '11092', '12047', '12084', '12105', '12163', '12176', '12255', '12325', '12349', '12397', '12427', '12451', '12518', '12595', '12676', '12776', '12814', '12815', '13532', '13571', '13572', '13573', '13640', '13650', '13651', '13885', '13904', '13962', '13967', '13969', '13970', '14076', '14096', '14351', '14421', '14422', '14423', '14424', '14458', '14474', '14541', '14542', '14669', '14672', '14700', '14701', '14702', '14774', '14811', '14812', '14813', '15302', '15335', '15389', '15509', '15513', '15516', '16417', '16418', '16419', '16540', '16550', '16553', '16598', '16600', '16601', '16602', '16604', '17375', '18593', '18907', '18914', '18959', '19368', '248', '19469', '19470', '19472', '19494', '19495', '19496', '19497', '19498', '19499', '19500', '19502', '19503', '19504', '19506', '19507', '19508', '19509', '19510', '20016', '28526', '28527', '28529', '28530', '28531', '28532', '32460', '32757', '32980', '32983', '33093', '33252', '31115', '31028', '31451', '31362', '31049', '34074', '34088', '34095', '34096', '34360', '34361', '34382', '34511', '34571', '34572', '34705', '35312', '35399', '35766', '35767', '36337', '36370', '36452', '36473', '43994', '44079', '44223', '44224', '44386', '44391', '44392', '44634', '44801', '44934', '45154', '45832', '46041', '46042', '46070', '46071')) ORDER BY `at_position`.`position` DESC LIMIT 24
