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 (14825, 14827, 14828, 14915, 385950, 385965, 419157, 437978, 246659, 246663, 246664, 246667, 247648, 247649, 255242, 267302, 267303, 267304, 267306, 282273, 282282, 203435, 209442, 209443, 211858, 211860, 216929, 223131, 192759, 192761)) 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,14825,14827,14828,14915,385950,385965,419157,437978,246659,246663,246664,246667,247648,247649,255242,267302,267303,267304,267306,282273,282282,203435,209442,209443,211858,211860,216929,223131,192759,192761)
-
SKU: THI-00681
Model: 681
Condition: New-In-Box
-
SKU: THI-00691
Model: 691
Condition: New-In-Box
-
SKU: THI-00690
Model: 690
Condition: New-In-Box
-
SKU: THI-00192
Model: 192
Condition: New-In-Box
-
[Graphite, Dark Olive]
SKU: THI-VISION10
Model: 710682, 710683
Condition: New-In-Box
-
[Graphite, Dark Olive]
SKU: THI-VISION15
Model: 710686, 710687
Condition: New-In-Box
-
SKU: THI-00487
Model: 730511
Condition: New-In-Box
-
SKU: THI-01000
Model: 720449
Condition: New-In-Box
-
SKU: THI-00495
Model: 720495
Condition: New-In-Box
-
SKU: THI-00729
Model: 710729
Condition: New-In-Box
-
SKU: THI-00732
Model: 710732
Condition: New-In-Box
-
SKU: THI-00769
Model: 710769
Condition: New-In-Box
-
SKU: THI-00638
Model: 740638
Condition: New-In-Box
-
SKU: THI-00883
Model: 710883
Condition: New-In-Box
-
SKU: THI-00555
Model: 730555
Condition: New-In-Box
-
SKU: THI-00468
Model: 710468
Condition: New-In-Box
-
SKU: THI-00469
Model: 710469
Condition: New-In-Box
-
SKU: THI-00622
Model: 740622
Condition: New-In-Box
-
SKU: THI-00705
Model: 710705
Condition: New-In-Box
-
SKU: THI-00479
Model: 720479
Condition: New-In-Box
-
SKU: THI-00481
Model: 720481
Condition: New-In-Box
-
SKU: THI-00554
Model: 730554
Condition: New-In-Box
-
SKU: THI-00521
Model: 730521
Condition: New-In-Box
-
SKU: THI-00739
Model: 710739
Condition: New-In-Box
-
SKU: THI-00217
Model: 740217
Condition: New-In-Box
-
SKU: THI-00219
Model: 740219
Condition: New-In-Box
-
SKU: THI-00232
Model: 740232
Condition: New-In-Box
-
SKU: THI-00532
Model: 730532
Condition: New-In-Box
-
SKU: THI-00073
Model: 700073
Condition: New-In-Box
-
SKU: THI-00075
Model: 700075
Condition: New-In-Box