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=2228) WHERE (`e`.`entity_id` IN('21873', '21881', '29035', '29040', '29043', '29045', '29046', '29047', '41263', '41264', '41265', '41266', '41267', '41268', '41269', '41270', '41271', '41272', '41273', '41274', '41275', '41276', '41277', '41278', '41279', '41280', '41281', '41282', '41283', '41284', '41289', '41290', '41291', '41292', '41293', '41294', '41295', '41296', '41297', '41298', '41299', '41300', '41301', '41302', '41303', '41304', '41305', '41306', '41307', '41308', '41309', '41310', '41311', '41312', '41313', '41314', '41315', '41316', '41317', '41318', '41319', '41320', '41321', '41322', '41323', '41324', '41325', '41326', '41327', '41328', '41329', '41330', '41331', '41332', '41333', '41334', '41335', '41336', '41337', '41338', '41339', '41340', '41341', '41342', '41343', '41344', '41345', '41346', '41347', '41348', '41349', '41350', '41351', '41352', '41353', '41354', '41355', '41356', '41357', '41358', '41359', '41360', '41361', '41362', '41363', '41364', '41365', '41366', '41367', '41368', '41369', '41370')) ORDER BY `at_position`.`position` DESC LIMIT 24
