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=653) WHERE (`e`.`entity_id` IN('267', '268', '269', '270', '272', '273', '346', '418', '419', '1019', '1020', '1021', '1022', '1023', '1024', '1025', '1026', '1028', '1029', '1030', '10327', '10347', '11030', '11994', '12071', '12110', '12180', '12181', '12241', '12242', '12269', '12278', '12380', '12381', '12437', '12438', '12533', '12557', '12558', '12559', '12560', '12583', '12584', '12585', '12586', '12638', '12651', '12677', '12697', '12727', '12748', '12749', '12799', '12800', '13836', '14418', '14419', '14420', '14435', '14605', '14840', '16447', '16449', '16450', '16451', '16459', '16460', '16461', '16462', '16463', '16464', '16465', '16466', '16467', '16472', '16475', '16476', '16481', '16483', '16494', '16496', '16499', '16528', '16529', '16532', '16541', '16563', '16564', '16565', '16566', '16590', '16609', '17164', '17175', '17233', '17316', '17320', '17391', '17673', '17690', '17729', '17746', '17770', '17866', '17961', '17999', '18375', '18388', '19113', '19039', '19038', '19099', '19324', '19335', '19438', '19445', '19457', '19458', '19467', '19521', '19522', '19523', '19525', '19526', '19527', '19528', '19529', '19530', '19532', '19534', '19535', '19536', '19537', '19538', '19868', '27002', '27003', '27004', '27005', '27006', '27008', '32459', '32604', '32962', '33050', '33076', '33193', '33194', '33195', '33997', '34304', '34340', '34352', '34381', '34410', '34820', '34821', '34822', '35308', '35396')) ORDER BY `at_position`.`position` DESC LIMIT 24
