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 (121466, 121467, 121468, 122534, 128463, 128464, 128465, 128786, 26527, 26528, 14820, 14821, 14822, 14825, 14827, 14828, 14915, 15200, 15203, 15334, 15606, 15607, 13840, 13845, 13847, 13854, 12329, 12331, 6549, 6559)) 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,121466,121467,121468,122534,128463,128464,128465,128786,26527,26528,14820,14821,14822,14825,14827,14828,14915,15200,15203,15334,15606,15607,13840,13845,13847,13854,12329,12331,6549,6559)
-
SKU: THI-00520
Model: TT520
Condition: New-In-Box
-
SKU: THI-00525
Model: TT525
Condition: New-In-Box
-
SKU: THI-00526
Model: TT526
Condition: New-In-Box
-
SKU: THI-00499
Model: 499
Condition: New-In-Box
-
SKU: THI-00692
Model: 692
Condition: New-In-Box
-
SKU: THI-00694
Model: 694
Condition: New-In-Box
-
SKU: THI-00697
Model: 697
Condition: New-In-Box
-
SKU: THI-00971
Model: 971
Condition: New-In-Box
-
SKU: THI-00417
Model: TT417
Condition: New-In-Box
-
SKU: THI-00419
Model: TT419
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-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