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=1435) WHERE (`e`.`entity_id` IN('20982', '20983', '20984', '20986', '20987', '20988', '20989', '20990', '20991', '20992', '20993', '20994', '20995', '20996', '20997', '20998', '20999', '21002', '21003', '21004', '21005', '21006', '21010', '21011', '21012', '21013', '21014', '21015', '21018', '21019', '21021', '21022', '21023', '21024', '21025', '21026', '21027', '21032', '21033', '21034', '21036', '21037', '21038', '21039', '21040', '21041', '21042', '21043', '21044', '21045', '21046', '21047', '21048', '21049', '21050', '21051', '21052', '21053', '21054', '21055', '21056', '21057', '21058', '21059', '21060', '21061', '21062', '21063', '21064', '21065', '21066', '21067', '21068', '21069', '21070', '23838', '24336', '24378', '25102', '25103', '28615', '28616', '28617', '28618', '28619', '28620', '28621', '28622', '28623', '28624', '28625', '28626', '28627', '28628', '28629', '28630', '28631', '28632', '34878', '35785', '40334', '40335', '40336', '40337', '40339', '40340', '40341', '40342', '40343', '40344', '40345', '40346', '40348', '40349', '40350', '40351', '40353', '40354', '40355', '40356', '40357', '40358', '40359', '40360', '40361', '40363', '40364', '40365', '40366', '40368', '40370', '40371', '40372', '40373', '40374', '40375', '40376', '40377', '40378', '40379', '40380', '40381', '40382', '40383', '40384', '40386', '40387', '40388', '40389', '40390', '40391', '40392', '40393', '40394', '40395', '40396', '40397', '40398', '40399', '40400', '40401', '40402', '40403', '40404', '40405', '40406', '40408', '40409', '40410', '40411', '40412', '40413', '40414', '40415', '40416', '40417', '40418', '40419', '40420', '40422', '40423', '40425', '40426', '40427', '40428', '40429', '40431', '40432', '40433', '40435', '40436', '40438', '40439', '40440', '40442', '40443', '40444', '40445', '40446', '40447', '40448', '40449', '40450', '40451', '40452', '40453', '40454', '40455', '40456', '40457', '40459', '40461', '40462', '40463', '40464', '40465', '40466', '40467', '40468', '40469', '40470')) ORDER BY `at_position`.`position` DESC LIMIT 24
