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 (10216, 10217, 10218, 10219, 10220, 10221, 10224, 10226, 10227, 10283, 10284, 10285, 10287, 10289, 10301, 10314, 10324, 10328, 10363, 10366, 10367, 10371, 10377, 10379, 10380, 10382, 10383, 10385, 10386, 10387)) 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,10216,10217,10218,10219,10220,10221,10224,10226,10227,10283,10284,10285,10287,10289,10301,10314,10324,10328,10363,10366,10367,10371,10377,10379,10380,10382,10383,10385,10386,10387)
-
SKU: EIK-00010
Model: BBA
Condition: New-In-Box
-
SKU: EIK-00015
Model: BCA
Condition: New-In-Box
-
SKU: EIK-00020
Model: BLC
Condition: New-In-Box
-
SKU: EIK-00025
Model: BMG/BMH
Condition: New-In-Box
-
SKU: EIK-00030
Model: BRL
Condition: New-In-Box
-
SKU: EIK-00035
Model: BTR
Condition: New-In-Box
-
SKU: EIK-00055
Model: CAS/CAV
Condition: New-In-Box
-
SKU: EIK-00065
Model: CBX/CBS
Condition: New-In-Box
-
SKU: EIK-00070
Model: CDJ
Condition: New-In-Box
-
SKU: EIK-00085
Model: CLX/CMB
Condition: New-In-Box
-
SKU: EIK-00090
Model: CMV/CMT
Condition: New-In-Box
-
SKU: EIK-00095
Model: CXK
Condition: New-In-Box
-
SKU: EIK-00105
Model: CYX
Condition: New-In-Box
-
SKU: EIK-00115
Model: CZX/DAB
Condition: New-In-Box
-
SKU: EIK-00140
Model: DCX
Condition: New-In-Box
-
SKU: EIK-00170
Model: DFN/DFC
Condition: New-In-Box
-
SKU: EIK-00195
Model: DRB/DRC
Condition: New-In-Box
-
SKU: EIK-00207
Model: DWY/FAB
Condition: New-In-Box
-
SKU: EIK-00209
Model: DXW
Condition: New-In-Box
-
SKU: EIK-00210
Model: DYG
Condition: New-In-Box
-
SKU: EIK-00215
Model: DYH
Condition: New-In-Box
-
SKU: EIK-00225
Model: DYR
Condition: New-In-Box
-
SKU: EIK-00240
Model: DZA
Condition: New-In-Box
-
SKU: EIK-00250
Model: EBV
Condition: New-In-Box
-
SKU: EIK-00255
Model: EBW
Condition: New-In-Box
-
SKU: EIK-00265
Model: ECT
Condition: New-In-Box
-
SKU: EIK-00270
Model: EFM
Condition: New-In-Box
-
SKU: EIK-00285
Model: EFR
Condition: New-In-Box
-
SKU: EIK-00290
Model: EGR
Condition: New-In-Box
-
SKU: EIK-00295
Model: EGT
Condition: New-In-Box