Aquilea

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' INNER JOIN `catalog_product_index_eav` AS `brand_cat_idx` ON brand_cat_idx.entity_id = e.entity_id AND brand_cat_idx.attribute_id = '300' AND brand_cat_idx.store_id = 2 AND brand_cat_idx.value = '3075' LEFT JOIN `aw_shopbybrand_brand_product` AS `at_position` ON (at_position.`product_id`=e.entity_id) AND (brand_id=2234) WHERE (`e`.`entity_id` IN('49', '50', '1042', '1043', '1044', '1045', '4976', '4977', '5012', '5143', '5144', '5148', '5159', '8408', '8410', '8411', '8455', '8456', '8457', '9163', '10027', '10048', '10075', '10093', '10576', '10615', '10620', '10627', '10638', '11991', '12072', '12073', '12254', '12382', '12388', '12476', '12490', '12494', '12502', '12603', '12664', '13567', '13610', '13635', '14243', '14338', '14795', '18938', '17779', '18930', '18935', '18947', '19297', '19298', '19299', '19300', '19302', '19303', '19304', '19305', '19306', '19307', '19308', '19310', '19311', '19312', '19313', '19314', '19381', '30807', '30808', '30809', '30810', '30811', '32395', '32809', '32965', '33974', '33981', '34271', '34273', '34299', '34954', '35187', '35198', '35407', '35408', '35951', '44017', '44086', '44688', '44738', '44743', '44744', '44745', '44746', '44776', '44795', '45138', '45149', '45150', '45515', '54348', '54397')) ORDER BY `at_position`.`position` DESC LIMIT 24