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=2185) WHERE (`e`.`entity_id` IN('18281', '21124', '21126', '21128', '21129', '21130', '21131', '21133', '21134', '21135', '21136', '21138', '21139', '21140', '21142', '21143', '21145', '21148', '21149', '21151', '21152', '23470', '24284', '24569', '24648', '24706', '24974', '25011', '25336', '25609', '26079', '26080', '26087', '26092', '26095', '26099', '26106', '26108', '26123', '26126', '26128', '26130', '26133', '26135', '26137', '26138', '26141', '26356', '26358', '26359', '26360', '30101', '30078', '30081', '30082', '30084', '30085', '30086', '30087', '30088', '30090', '30091', '30092', '30093', '30095', '30096', '30097', '30098', '30099', '30100', '30102', '30103', '30106', '30107', '30108', '30109', '30113', '30115', '30116', '30117', '30118', '30120', '30122', '30123', '30124', '30126', '30127', '30128', '30129', '30130', '30136', '34563', '43254', '43256', '43257', '43258', '43259', '43260', '43261', '43262', '43263', '43264', '43265', '43266', '43267', '43268', '43269', '43270', '43272', '43277', '43278', '43279', '43280', '43281', '43282', '43283', '43284', '43285', '43286', '43288', '43289', '43290', '43291', '43292', '43293', '43294', '43295', '43296', '43297', '43298', '43299', '43300', '43301', '43302', '43303', '43304', '43306', '43307', '43308', '43309', '43310', '43311', '43312', '43313', '43314', '43315', '43316', '43317', '43318', '43319', '43320', '43321', '43322', '43323', '43324', '43326', '43327', '43328', '43329', '43330', '43331', '43332', '43334', '43335', '43336', '43337', '43338', '43339', '43340', '43341', '43342')) ORDER BY `at_position`.`position` DESC LIMIT 24
