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, 600669, 577783, 577782, 564283, 564282, 558567, 77990, 77995, 84791, 84792, 84794, 84795, 84797, 84798, 84799, 90764, 113833, 113836, 113837, 113839, 113840, 158106, 158108, 158109, 158110, 158111, 158112, 158113, 158115)) 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,600669,577783,577782,564283,564282,558567,77990,77995,84791,84792,84794,84795,84797,84798,84799,90764,113833,113836,113837,113839,113840,158106,158108,158109,158110,158111,158112,158113,158115)
-
SKU: THI-00793
Model: 720200
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-00471
Model: 471
Condition: New-In-Box
-
SKU: THI-00553
Model: 730553
Condition: New-In-Box
-
SKU: THI-00656
Model: 656
Condition: New-In-Box
-
SKU: THI-00657
Model: 657
Condition: New-In-Box
-
SKU: THI-00666
Model: 666
Condition: New-In-Box
-
SKU: THI-00667
Model: 667
Condition: New-In-Box
-
SKU: THI-00672
Model: 672
Condition: New-In-Box
-
SKU: THI-00673
Model: 673
Condition: New-In-Box
-
SKU: THI-00674
Model: 674
Condition: New-In-Box
-
SKU: THI-00563
Model: TT563
Condition: New-In-Box
-
SKU: THI-00456
Model: 456
Condition: New-In-Box
-
SKU: THI-00462
Model: 462
Condition: New-In-Box
-
SKU: THI-00466
Model: 710466
Condition: New-In-Box
-
SKU: THI-00475
Model: 475
Condition: New-In-Box
-
SKU: THI-00476
Model: 476
Condition: New-In-Box
-
SKU: THI-00053
Model: 053
Condition: New-In-Box
-
SKU: THI-00055
Model: 055
Condition: New-In-Box
-
SKU: THI-00056
Model: 056
Condition: New-In-Box
-
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