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, 247646, 229857, 175144, 133524, 246661, 246662, 247650, 229858, 175145, 20474, 20475, 20529, 20530, 20532, 20533, 20536, 20578, 20581, 20584, 20585, 20586, 16649, 16650, 16651, 16652, 16654, 16655, 16656, 16657)) 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,247646,229857,175144,133524,246661,246662,247650,229858,175145,20474,20475,20529,20530,20532,20533,20536,20578,20581,20584,20585,20586,16649,16650,16651,16652,16654,16655,16656,16657)
-
SKU: MIND-00831
Model: 541823
Condition: New-In-Box
-
SKU: MIND-00821
Model: 540821
Condition: New-In-Box
-
SKU: MIND-00425
Model: 520425
Condition: New-In-Box
-
SKU: MIND-520355
Model: 520355
Condition: New-In-Box
-
SKU: MIND-00363
Model: 363
Condition: New-In-Box
-
SKU: THI-00426
Model: 520426
Condition: New-In-Box
-
SKU: THI-00427
Model: 520427
Condition: New-In-Box
-
SKU: MIND-00101
Model: 510101
Condition: New-In-Box
-
SKU: MIND-00366
Model: 520366
Condition: New-In-Box
-
SKU: MIND-520356
Model: 520356
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
-
SKU: MIND-00825
Model: 825
Condition: New-In-Box
-
SKU: MIND-00917
Model: MIND-00917
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