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`, IFNULL(review_summary.reviews_count, 0) AS `reviews_count`, IFNULL(review_summary.rating_summary, 0) AS `rating_summary`, `stock_status_index`.`is_salable` 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.customer_group_id = 0 AND price_index.website_id = '1'
LEFT JOIN `mst_sorting_index` AS `mst_sorting_index_1` ON mst_sorting_index_1.product_id = e.entity_id AND mst_sorting_index_1.store_id = 1
LEFT JOIN `mst_sorting_index` AS `mst_sorting_index_0` ON mst_sorting_index_0.product_id = e.entity_id AND mst_sorting_index_0.store_id = 0
LEFT JOIN `review_entity_summary` AS `review_summary` ON e.entity_id = review_summary.entity_pk_value AND review_summary.store_id = 1 AND review_summary.entity_type = (SELECT `review_entity`.`entity_id` FROM `review_entity` WHERE (entity_code = 'product'))
INNER JOIN `catalog_product_entity` AS `product` ON product.entity_id = e.entity_id
LEFT JOIN `inventory_stock_2` AS `stock_status_index` ON product.sku = stock_status_index.sku WHERE (e.entity_id IN (21297, 21440, 206945, 206946, 206947, 206948, 206949, 206950, 206951, 77904, 232156, 14141, 14142, 14143, 14144, 14145, 14146, 15037, 15731, 15732, 15733, 15734, 8811, 8813, 5567, 5568, 5569, 5576, 5579, 5580)) ORDER BY IFNULL(mst_sorting_index_1.factor_2_score, IFNULL(mst_sorting_index_0.factor_2_score, 0)) * 50 desc, FIELD(e.entity_id,21297,21440,206945,206946,206947,206948,206949,206950,206951,77904,232156,14141,14142,14143,14144,14145,14146,15037,15731,15732,15733,15734,8811,8813,5567,5568,5569,5576,5579,5580)
-
SKU: PHG-905215
Model: 905215
Condition: New-In-Box
-
SKU: PHG-907635
Model: 907635
Condition: New-In-Box
-
SKU: PHG-907809
Model: 907809
Condition: New-In-Box
-
SKU: PHG-900095
Model: 900095
Condition: New-In-Box
-
SKU: PHG-900125
Model: 900125
Condition: New-In-Box
-
SKU: PHG-907001
Model: 907001
Condition: New-In-Box
-
SKU: PHG-907005
Model: 907005
Condition: New-In-Box
-
SKU: PHG-907693
Model: 907693
Condition: New-In-Box
-
SKU: PHG-907838
Model: 907838
Condition: New-In-Box
-
SKU: PHG-922140
Model: 922140
Condition: New-In-Box
-
SKU: PHG-956063
Model: 956063
Condition: New-In-Box
-
SKU: PHG-956123
Model: 956123
Condition: New-In-Box
-
SKU: PHG-956135
Model: 956135
Condition: New-In-Box
-
SKU: PHG-905808
Model: 905808
Condition: New-In-Box
-
SKU: PHG-905634
Model: 905634
Condition: New-In-Box
-
SKU: PHG-905779
Model: 905779
Condition: New-In-Box
-
SKU: PHG-956073
Model: 956073
Condition: New-In-Box
-
SKU: PHG-900140
Model: 900140
Condition: New-In-Box
-
SKU: PHG-956055
Model: 956055
Condition: New-In-Box
-
SKU: PHG-956059
Model: BAT2188
Condition: New-In-Box
-
SKU: PHG-956062
Model: 956062
Condition: New-In-Box
-
SKU: PHG-956065
Model: 956065
Condition: New-In-Box
-
SKU: PHG-915867
Model: 915864
Condition: New-In-Box
-
SKU: PHG-915853
Model: 915836
Condition: New-In-Box
-
SKU: PHG-932284
Model: 932284
Condition: New-In-Box
-
SKU: PHG-906910
Model: AK320
Condition: New-In-Box
-
SKU: PHG-906939
Model: AK320B
Condition: New-In-Box
-
SKU: PHG-911898
Model: 911898
Condition: New-In-Box
-
SKU: PHG-915755
Model: PL1250C
Condition: New-In-Box
-
SKU: PHG-915871
Model: 915871
Condition: New-In-Box