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=1962) WHERE (`e`.`entity_id` IN('14835', '16936', '22212', '22214', '22215', '22216', '22217', '22218', '22219', '22221', '22222', '22223', '22225', '22226', '22227', '24894', '25027', '25097', '25273', '25299', '25306', '25342', '25431', '25432', '25593', '25604', '25614', '25615', '25616', '25624', '25625', '25627', '25639', '25647', '25651', '25659', '25664', '25682', '25704', '25717', '25718', '25727', '25729', '25730', '25731', '25737', '25739', '25744', '25747', '25748', '25749', '25750', '25751', '26144', '26149', '26150', '26151', '26165', '26406', '29685', '29686', '29687', '29688', '29689', '29690', '29691', '29693', '29694', '29695', '29696', '29697', '29698', '29699', '29700', '29701', '29702', '29705', '29706', '29707', '29708', '29709', '29710', '29711', '29714', '29715', '29716', '29717', '29718', '29719', '29720', '29721', '34868', '34869', '34871', '34872', '34873', '34874', '34875', '34876', '34877', '34880', '34882', '34883', '34886', '34889', '35725', '35726', '35728', '35729', '35732', '35733', '35735', '35736', '35737', '35799', '35930', '35952', '36014', '36066', '36073', '36118', '36224', '36253', '42321', '42322', '42323', '42324', '42325', '42326', '42328', '42329', '42330', '42331', '42333', '42334', '42335', '42336', '42337', '42338', '42339', '42340', '42341', '42343', '42344', '42345', '42346', '42347', '42348', '42349', '42350', '44912', '44923', '45129')) ORDER BY `at_position`.`position` DESC LIMIT 24
