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 (12635, 12636, 12637, 12644, 12645, 12648, 12649, 12651, 12652, 12654, 12656, 12657, 12658, 12659, 12661, 12662, 12663, 12664, 12665, 12668, 12669, 12670, 12672, 12673, 12675, 12676, 12677, 12685, 12686, 12687)) 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,12635,12636,12637,12644,12645,12648,12649,12651,12652,12654,12656,12657,12658,12659,12661,12662,12663,12664,12665,12668,12669,12670,12672,12673,12675,12676,12677,12685,12686,12687)
-
SKU: MAN-00498
Model: 320
Condition: New-In-Box
-
SKU: MAN-00464
Model: 297BBASE
Condition: New-In-Box
-
SKU: MAN-00630
Model: 449SC2
Condition: New-In-Box
-
SKU: MAN-00689A
Model: 492LCD
Condition: New-In-Box
-
SKU: MAN-00722
Model: 501PLONG
Condition: New-In-Box
-
SKU: MAN-00742
Model: 503LV
Condition: New-In-Box
-
SKU: MAN-00746
Model: 504HD,546BK
Condition: New-In-Box
-
SKU: MAN-00762
Model: 519LV
Condition: New-In-Box
-
SKU: MAN-00778
Model: 526,536K
Condition: New-In-Box
-
SKU: MAN-00864
Model: 627
Condition: New-In-Box
-
SKU: MAN-00977E
Model: 755CX3-M8Q5
Condition: New-In-Box
-
SKU: MAN-01014
Model: 785PL
Condition: New-In-Box
-
SKU: MAN-03425
Model: R700,32
Condition: New-In-Box
-
SKU: MAN-03409E
Model: R501,225
Condition: New-In-Box
-
SKU: MAN-02412
Model: MICC4
Condition: New-In-Box
-
SKU: MAN-02040
Model: AW GS207
Condition: New-In-Box
-
SKU: MAN-02020
Model: AW 3280BLK
Condition: New-In-Box
-
SKU: MAN-02019
Model: AW 3279BLK
Condition: New-In-Box
-
SKU: MAN-01300
Model: 5001B
Condition: New-In-Box
-
SKU: MAN-00052
Model: 030-14
Condition: New-In-Box
-
SKU: MAN-00072
Model: 033BSET
Condition: New-In-Box
-
SKU: MAN-00084
Model: 035BN (2893)
Condition: New-In-Box
-
SKU: MAN-00104
Model: 044
Condition: New-In-Box
-
SKU: MAN-00108
Model: 045-6
Condition: New-In-Box
-
SKU: MAN-00168
Model: 062-2
Condition: New-In-Box
-
SKU: MAN-00183
Model: 085BS
Condition: New-In-Box
-
SKU: MAN-00184
Model: 085BSL
Condition: New-In-Box
-
SKU: MAN-00204
Model: 110G
Condition: New-In-Box
-
SKU: MAN-00210
Model: 114MV (3198)
Condition: New-In-Box
-
SKU: MAN-00218
Model: 122B
Condition: New-In-Box