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 (158120, 192767, 192768, 192772, 192781, 14820, 14821, 14822, 14825, 14827, 14828, 14915, 15199, 15200, 15334, 15606, 15607, 13840, 13845, 13847, 13854, 13855, 6549, 6559, 6564, 6565, 6568, 6572, 6574, 6575)) 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,158120,192767,192768,192772,192781,14820,14821,14822,14825,14827,14828,14915,15199,15200,15334,15606,15607,13840,13845,13847,13854,13855,6549,6559,6564,6565,6568,6572,6574,6575)
-
SKU: THI-00064
Model: 700064
Condition: New-In-Box
-
SKU: THI-00081
Model: 700081
Condition: New-In-Box
-
SKU: THI-00082
Model: 700082
Condition: New-In-Box
-
SKU: THI-00751
Model: 710751
Condition: New-In-Box
-
SKU: THI-00631
Model: 740631
Condition: New-In-Box
-
SKU: THI-00540
Model: 540
Condition: New-In-Box
-
SKU: THI-00670
Model: 670
Condition: New-In-Box
-
SKU: THI-00671
Model: 671
Condition: New-In-Box
-
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-00241
Model: 241
Condition: New-In-Box
-
SKU: THI-00244
Model: 244
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-00969
Model: 969
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