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=1579) WHERE (`e`.`entity_id` IN('8681', '15312', '15400', '15497', '22000', '22001', '22003', '22004', '22005', '22006', '22007', '22008', '22009', '22010', '22011', '22012', '22013', '22014', '22016', '22018', '22021', '22022', '22023', '22024', '22025', '22026', '22027', '22028', '22029', '22030', '22031', '22032', '22033', '22034', '22035', '22036', '22037', '22038', '22040', '22041', '22042', '22044', '22045', '22046', '22047', '22048', '22049', '22050', '22052', '22053', '22054', '22055', '22056', '22057', '22058', '22060', '22061', '22062', '22063', '22064', '22065', '22066', '22067', '22068', '22069', '22070', '22071', '22072', '22074', '22075', '22076', '22077', '22078', '22079', '22080', '22081', '22082', '22083', '22084', '22085', '22086', '22087', '22088', '22089', '22091', '22093', '22096', '22098', '22101', '24155', '24156', '24173', '24331', '24351', '24379', '24427', '24554', '24564', '24565', '24566', '24596', '24622', '24682', '24752', '24811', '24865', '24937', '25068', '25092', '25093', '25174', '25197', '25207', '25551', '25587', '25613', '25669', '25755', '25994', '28934', '28935', '34879', '35954', '35973', '35998', '36002', '36006', '36135', '36274', '41099', '41100', '41101', '41102', '41103', '41104', '41105', '41106', '41107', '41108', '41109', '41110', '41111', '41112', '41113', '41114', '41115', '41116', '41117', '41118', '41119', '41120', '41121', '41122', '41123', '41124', '41125', '41126', '41127', '41128', '41129', '41130', '41131', '41132', '41133', '41134', '41135', '41136', '41137', '41138', '41139', '41140', '41141', '41142', '41143', '41144', '41145', '41146', '41147', '41148', '41149', '41150', '41151', '41152', '41153', '41154', '41155', '41156', '41157', '41158', '41159', '41160', '41161', '41162', '41163', '41164', '41165', '41166', '41167', '41168', '41169', '41171', '41172', '41173', '41174', '41175', '41176', '41177', '41178', '41179', '41180', '41181', '41182', '41183', '41184', '41185', '41186')) ORDER BY `at_position`.`position` DESC LIMIT 24
