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=2217) WHERE (`e`.`entity_id` IN('20261', '20262', '20263', '20264', '20265', '20266', '20267', '20268', '20269', '20270', '20271', '20272', '20274', '20275', '20276', '20277', '20278', '20279', '38572', '38573', '38574', '38575', '38576', '38577', '38578', '38579', '38580', '38581', '38582', '38583', '38584', '38585', '38586', '38587', '38588', '38589', '38590', '38591', '38592', '38593', '38594', '38595', '38596', '38597', '38598', '38599', '38600', '38601', '38602', '38603', '38604', '38605', '38606', '38607', '38608', '38609', '38610', '38611', '38612', '38613', '38614', '38615', '38616', '38617', '38618', '38619', '38620', '38621', '38622', '38623', '38624', '38625', '38626', '38627', '38628', '38629', '38630', '38631', '38632', '38633', '38634', '38635', '38636', '38637', '38638', '38639', '38640', '38641', '38642', '38643', '38644', '38645', '38646', '38647', '38648', '38649', '38650', '38651', '38652', '38653', '38654', '38655', '38656', '38657', '38658', '38659', '38660', '38661', '38662', '38663', '38664', '38666', '38667', '38668', '38669', '38670', '38671', '38672', '38673', '38674', '38675', '38676', '38677', '38678', '38679', '38680', '38682', '38683')) ORDER BY `at_position`.`position` DESC LIMIT 24
