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 (587933, 133524, 133538, 229857, 175144, 247646, 16649, 16650, 16651, 16652, 16654, 16655, 16656, 16657, 21278, 21279, 21281, 82289, 96152, 96153, 20474, 20475, 20529, 20530, 20532, 20533, 20536, 20578, 20581, 20584)) 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,587933,133524,133538,229857,175144,247646,16649,16650,16651,16652,16654,16655,16656,16657,21278,21279,21281,82289,96152,96153,20474,20475,20529,20530,20532,20533,20536,20578,20581,20584)
-
SKU: MIND-00831
Model: 541823
Condition: New-In-Box
-
SKU: MIND-00363
Model: 363
Condition: New-In-Box
-
SKU: MIND-00360
Model: 360
Condition: New-In-Box
-
SKU: MIND-00425
Model: 520425
Condition: New-In-Box
-
SKU: MIND-520355
Model: 520355
Condition: New-In-Box
-
SKU: MIND-00821
Model: 540821
Condition: New-In-Box
-
SKU: MIND-00200
Model: 200
Condition: New-In-Box
-
SKU: MIND-00205
Model: 205
Condition: New-In-Box
-
SKU: MIND-00210
Model: 210
Condition: New-In-Box
-
SKU: MIND-00800
Model: 800
Condition: New-In-Box
-
SKU: MIND-00806
Model: 806
Condition: New-In-Box
-
SKU: MIND-00900
Model: 900
Condition: New-In-Box
-
SKU: MIND-00904
Model: 904
Condition: New-In-Box
-
SKU: MIND-00906
Model: 906
Condition: New-In-Box
-
SKU: MIND-00220
Model: 220
Condition: New-In-Box
-
SKU: MIND-00221
Model: 221
Condition: New-In-Box
-
SKU: MIND-00915
Model: 915
Condition: New-In-Box
-
SKU: MIND-00920
Model: 920
Condition: New-In-Box
-
SKU: MIND-00341
Model: 341
Condition: New-In-Box
-
SKU: MIND-00342
Model: 342
Condition: New-In-Box
-
SKU: MIND-00820
Model: 820
Condition: New-In-Box
-
SKU: MIND-00823
Model: 823
Condition: New-In-Box
-
SKU: MIND-00230
Model: 230
Condition: New-In-Box
-
SKU: MIND-00231
Model: 231
Condition: New-In-Box
-
SKU: MIND-00240
Model: 240
Condition: New-In-Box
-
SKU: MIND-00241
Model: 241
Condition: New-In-Box
-
SKU: MIND-00701
Model: 701
Condition: New-In-Box
-
SKU: MIND-00705
Model: 705
Condition: New-In-Box
-
SKU: MIND-00710
Model: 710
Condition: New-In-Box
-
SKU: MIND-00824
Model: 824
Condition: New-In-Box