Arkopharma

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 = '3123' LEFT JOIN `aw_shopbybrand_brand_product` AS `at_position` ON (at_position.`product_id`=e.entity_id) AND (brand_id=20) WHERE (`e`.`entity_id` IN('51', '53', '54', '56', '59', '61', '65', '69', '70', '452', '583', '584', '629', '1157', '4472', '4474', '4493', '4516', '4518', '4588', '4654', '4667', '4691', '4776', '4806', '4807', '4816', '4842', '4869', '4870', '4880', '4905', '4966', '5001', '5002', '5003', '5018', '5145', '5160', '5170', '8276', '8278', '8280', '8281', '8283', '8285', '8286', '8287', '8321', '8322', '8323', '8324', '8352', '8374', '8375', '8376', '8412', '8414', '8416', '8417', '8418', '8419', '8458', '8459', '8460', '8467', '8468', '8476', '8477', '8496', '8497', '8500', '8510', '8511', '8515', '8540', '8541', '8548', '9165', '10018', '10049', '10095', '10096', '10306', '10616', '10772', '12322', '12524', '12525', '12600', '12615', '12674', '13600', '13765', '13780', '13832', '13932', '13934', '13935', '13936', '14021', '14117', '14118', '14181', '14330', '14406', '14715', '15008', '15299', '15868', '16634', '16636', '16908', '17140', '17225', '17508', '17582', '18883', '18888', '18997', '19360', '19539', '19541', '19542', '19543', '19545', '19549', '19550', '19551', '26801', '26814', '26815', '26817', '26819', '26939', '26941', '26942', '26946', '26952', '26954', '26956', '26957', '26958', '26959', '26966', '26967', '31479', '31480', '32382', '32415', '32423', '32755', '32935', '32943', '32960', '32968', '33006', '33030', '33068', '33069', '33070', '33074', '33075', '33092', '33106', '33211', '33271', '33411', '33412', '33414', '33415', '33416', '33420', '33421', '33423', '33424', '33427', '33428', '33429', '33433', '33434', '33435', '34069', '34823', '34913', '34917', '34941', '34956', '35008', '35018', '35076', '35115', '35121', '35123', '35127', '35129', '35134', '35137', '35156', '35182', '35608', '35609', '35611', '35612', '36406', '36424', '36435', '36455', '36457', '36466', '36467', '36472', '36474', '36481', '36497', '36525', '36531', '36613', '36617', '44045', '44283', '44676', '44685', '44705', '44718', '44729', '44739', '44800', '44889', '44890', '44891', '45001', '45002', '45006', '45134', '45045', '45047', '45060', '45106', '45112', '45063', '46039', '46040')) ORDER BY `at_position`.`position` DESC LIMIT 24