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 (614848, 605071, 605069, 605067, 605063, 600669, 577783, 577782, 564283, 564282, 558567, 4771, 4814, 4818, 13841, 13842, 13852, 12332, 364215, 364218, 246660, 246665, 246666, 255243, 267304, 267305, 204660, 209441, 211861, 192767)) 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,614848,605071,605069,605067,605063,600669,577783,577782,564283,564282,558567,4771,4814,4818,13841,13842,13852,12332,364215,364218,246660,246665,246666,255243,267304,267305,204660,209441,211861,192767)
-
SKU: THI-00793
Model: 720200
Condition: New-In-Box
-
SKU: THI-740249
Model: 740249
Condition: New-In-Box
-
SKU: THI-740245
Model: 740245
Condition: New-In-Box
-
SKU: THI-740242
Model: 740242
Condition: New-In-Box
-
SKU: THI-740239
Model: 740239
Condition: New-In-Box
-
[Charcoal, Woodland]
SKU: THI-BACKLIGHT SPRINT
Model: 520368, 520369
Condition: New-In-Box
-
SKU: THI-710470
Model: 710470
Condition: New-In-Box
-
SKU: THI-710472
Model: 710472
Condition: New-In-Box
-
SKU: THI-721261
Model: 721261
Condition: New-In-Box
-
SKU: THI-721260
Model: 721260
Condition: New-In-Box
-
[Blue, Gray]
SKU: 16505
Model: 740253, 740254
Condition: New-In-Box
-
SKU: THI-00209
Model: 740209
Condition: New-In-Box
-
SKU: THI-00701
Model: 701
Condition: New-In-Box
-
SKU: THI-00866
Model: 866
Condition: New-In-Box
-
SKU: THI-00486
Model: 486
Condition: New-In-Box
-
SKU: THI-00489
Model: 489
Condition: New-In-Box
-
SKU: THI-00211
Model: 740211
Condition: New-In-Box
-
SKU: THI-00886
Model: 886
Condition: New-In-Box
-
SKU: THI-730565
Model: 730565
Condition: New-In-Box
-
SKU: THI-730566
Model: 730566
Condition: New-In-Box
-
SKU: THI-00496
Model: 720496
Condition: New-In-Box
-
SKU: THI-00753
Model: 710753
Condition: New-In-Box
-
SKU: THI-00761
Model: 710761
Condition: New-In-Box
-
SKU: THI-00556
Model: 730556
Condition: New-In-Box
-
SKU: THI-00622
Model: 740622
Condition: New-In-Box
-
SKU: THI-00704
Model: 710704
Condition: New-In-Box
-
SKU: THI-00642
Model: 740642
Condition: New-In-Box
-
SKU: THI-00497
Model: 730497
Condition: New-In-Box
-
SKU: THI-00233
Model: 740233
Condition: New-In-Box
-
SKU: THI-00081
Model: 700081
Condition: New-In-Box