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=163) WHERE (`e`.`entity_id` IN('611', '1106', '1107', '1108', '1109', '1110', '1111', '1114', '1115', '1116', '1118', '4481', '4482', '4483', '4484', '4485', '4530', '4531', '4532', '4533', '4562', '4563', '4564', '4565', '4566', '4567', '4585', '4600', '4601', '4602', '4622', '4623', '4624', '4716', '4781', '4783', '4784', '4786', '4787', '4992', '5006', '8296', '8342', '8344', '8443', '8495', '8501', '8744', '8764', '8830', '8910', '10541', '11137', '15046', '15049', '15064', '15089', '15093', '15126', '15138', '15204', '15212', '17141', '18832', '20222', '25640', '30880', '30881', '29024', '31648', '31714', '31744', '31751', '31820', '31884', '31893', '32300', '31365', '31311', '31161', '31341', '35301', '35395', '41200', '41202', '41206', '41207', '41208', '41209', '41210', '41211', '41212', '41213', '41214', '41216', '41217', '41218', '41219', '41220', '41223', '41225', '41226', '41227', '41228', '41229', '41230', '41231', '54402', '54403', '54404', '54405')) ORDER BY `at_position`.`position` DESC LIMIT 24
