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 (158125, 158126, 192759, 192761, 192763, 192765, 192770, 192771, 192773, 192774, 192953, 223131, 211858, 211860, 216929, 14820, 14821, 14822, 14825, 14827, 14828, 14915, 15199, 15200, 15334, 15606, 15607, 26527, 26528, 77991)) 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,158125,158126,192759,192761,192763,192765,192770,192771,192773,192774,192953,223131,211858,211860,216929,14820,14821,14822,14825,14827,14828,14915,15199,15200,15334,15606,15607,26527,26528,77991)
-
SKU: THI-00803
Model: TT803
Condition: New-In-Box
-
SKU: THI-00964
Model: 964
Condition: New-In-Box
-
SKU: THI-00073
Model: 700073
Condition: New-In-Box
-
SKU: THI-00075
Model: 700075
Condition: New-In-Box
-
SKU: THI-00077
Model: 700077
Condition: New-In-Box
-
SKU: THI-00079
Model: 700079
Condition: New-In-Box
-
SKU: THI-00728
Model: 710728
Condition: New-In-Box
-
SKU: THI-00731
Model: 710731
Condition: New-In-Box
-
SKU: THI-00759
Model: 710759
Condition: New-In-Box
-
SKU: THI-00767
Model: 710767
Condition: New-In-Box
-
SKU: THI-00083
Model: 700083
Condition: New-In-Box
-
SKU: THI-00532
Model: 730532
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-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-00417
Model: TT417
Condition: New-In-Box
-
SKU: THI-00419
Model: TT419
Condition: New-In-Box
-
SKU: THI-00472
Model: 472
Condition: New-In-Box