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 (158110, 158111, 158112, 158113, 158115, 158117, 158120, 490490, 508739, 6549, 6559, 6564, 6565, 6568, 6572, 6574, 6575, 6576, 6577, 6579, 6580, 7141, 7142, 7143, 7144, 8846, 8897, 12329, 12331, 4807)) 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,158110,158111,158112,158113,158115,158117,158120,490490,508739,6549,6559,6564,6565,6568,6572,6574,6575,6576,6577,6579,6580,7141,7142,7143,7144,8846,8897,12329,12331,4807)
-
SKU: THI-00057
Model: TT057
Condition: New-In-Box
-
SKU: THI-00058
Model: TT058
Condition: New-In-Box
-
SKU: THI-00059
Model: TT059
Condition: New-In-Box
-
SKU: THI-00060
Model: TT060
Condition: New-In-Box
-
SKU: THI-00062
Model: 700062
Condition: New-In-Box
-
SKU: THI-00067
Model: TT067
Condition: New-In-Box
-
SKU: THI-00064
Model: 700064
Condition: New-In-Box
-
SKU: THI-710630
Model: 710630
Condition: New-In-Box
-
SKU: THI-00634
Model: 740647
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
-
SKU: THI-00881
Model: 881
Condition: New-In-Box
-
SKU: THI-00970
Model: 970
Condition: New-In-Box
-
SKU: THI-00742
Model: 742
Condition: New-In-Box
-
SKU: THI-00258
Model: 258
Condition: New-In-Box
-
SKU: THI-00582
Model: 582
Condition: New-In-Box
-
SKU: THI-00550
Model: 550
Condition: New-In-Box