Caudalie

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 = '3094' LEFT JOIN `aw_shopbybrand_brand_product` AS `at_position` ON (at_position.`product_id`=e.entity_id) AND (brand_id=2231) WHERE (`e`.`entity_id` IN('8623', '9082', '27161', '27163', '27164', '34043', '34044', '34045', '34046', '34158', '34159', '34161', '34162', '34163', '34165', '34166', '34167', '34168', '34169', '34170', '34171', '34172', '34173', '34174', '34175', '34176', '34177', '34178', '34179', '34180', '34181', '34182', '34183', '34184', '34186', '34187', '34188', '34190', '34191', '34192', '34193', '34195', '34196', '34197', '34198', '34199', '34200', '34201', '34203', '34204', '34205', '34207', '34208', '34209', '34210', '34211', '34212', '34213', '34214', '34215', '34216', '34218', '34219', '34220', '34221', '34222', '34223', '34224', '34225', '34226', '34227', '34229', '34230', '34231', '34232', '34233', '35406', '35424', '35438', '35439', '35442', '35443', '35455', '35459', '35462', '35915', '43990', '43991', '43992', '44026', '44027', '44088', '44091', '44093', '44094', '44107', '44108', '44187', '44188', '44190', '44192', '44195', '44220', '44266', '44269', '44270', '44273', '44370', '44371', '44388', '44583', '44584', '44642', '44644', '44646', '44648', '44649', '44650', '44651', '44653', '44654', '44655', '44657', '44694', '44715', '44847', '44884', '44894', '45113', '45516', '45566', '45576', '45595', '45678', '45679', '45680', '45705', '45706', '45771', '45772', '45773', '45774', '45775', '45864', '45865', '45866', '45867', '45868', '45869', '45870', '46054', '46055', '46056', '46057', '46058', '46059', '54360', '54412', '54413', '54414', '54415')) ORDER BY `at_position`.`position` DESC LIMIT 24