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=73) WHERE (`e`.`entity_id` IN('138', '8470', '8475', '8870', '17080', '19565', '23467', '31486', '31737', '31846', '35956', '35957', '35958', '36003', '36004', '36005', '36033', '36039', '36040', '36041', '36109', '38414', '38415', '38416', '38417', '38418', '38419', '38421', '38422', '38423', '38424', '38426', '38427', '38428', '38429', '38431', '38432', '38433', '38434', '38435', '38436', '38437', '38438', '38439', '38440', '38441', '38442', '38443', '38444', '38445', '38446', '38447', '38448', '38449', '38450', '38451', '38452', '38453', '38454', '38455', '38456', '38457', '38458', '38459', '38460', '38461', '38462', '38463', '38464', '38465', '38466', '38467', '38468', '38469', '38470', '38471', '38472', '38473', '38474', '38475', '38476', '38477', '38478', '38479', '38480', '38481', '38482', '38483', '38484', '38485', '38486', '38487', '38488', '38489', '38490', '38491', '38492', '38493', '38494', '38495', '38496', '38497', '38498', '38499', '38500', '38501', '38502', '38503', '38504', '38505', '38506', '38507', '38508', '38509')) ORDER BY `at_position`.`position` DESC LIMIT 24
