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, 15200, 15203, 15334, 15606, 15607, 13840, 13845, 13847, 13854, 12329, 12331, 6549, 6559, 6564, 6565, 6568, 6572, 6574, 6575, 6576, 6577, 6579, 6580, 7141, 7142, 7143)) 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,15200,15203,15334,15606,15607,13840,13845,13847,13854,12329,12331,6549,6559,6564,6565,6568,6572,6574,6575,6576,6577,6579,6580,7141,7142,7143)
-
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
-
SKU: THI-00244
Model: 244
Condition: New-In-Box
-
SKU: THI-00977
Model: 977
Condition: New-In-Box
-
SKU: THI-00416
Model: 416
Condition: New-In-Box
-
SKU: THI-00967
Model: 967
Condition: New-In-Box
-
SKU: THI-00265
Model: 265
Condition: New-In-Box
-
SKU: THI-00483
Model: 483
Condition: New-In-Box
-
SKU: THI-00747
Model: 747
Condition: New-In-Box
-
SKU: THI-00749
Model: 749
Condition: New-In-Box
-
SKU: THI-00968
Model: 968
Condition: New-In-Box
-
SKU: THI-00258
Model: 258
Condition: New-In-Box
-
SKU: THI-00582
Model: 582
Condition: New-In-Box
-
SKU: THI-00210
Model: 740210
Condition: New-In-Box
-
SKU: THI-00470
Model: 470
Condition: New-In-Box
-
SKU: THI-00551
Model: 551
Condition: New-In-Box
-
SKU: THI-00559
Model: 559
Condition: New-In-Box
-
SKU: THI-00573
Model: 573
Condition: New-In-Box
-
SKU: THI-00623
Model: 623
Condition: New-In-Box
-
SKU: THI-00750
Model: 750
Condition: New-In-Box
-
SKU: THI-00758
Model: 758
Condition: New-In-Box
-
SKU: THI-00766
Model: 766
Condition: New-In-Box
-
SKU: THI-00770
Model: 770
Condition: New-In-Box
-
SKU: THI-00782
Model: 782
Condition: New-In-Box
-
SKU: THI-00792
Model: 792
Condition: New-In-Box
-
SKU: THI-00861
Model: 861
Condition: New-In-Box
-
SKU: THI-00871
Model: 871
Condition: New-In-Box
-
SKU: THI-00876
Model: 876
Condition: New-In-Box