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 (600669, 577783, 577782, 564283, 564282, 558567, 15199, 15201, 15202, 77990, 77995, 84791, 84792, 84794, 84795, 84797, 84798, 84799, 90764, 158106, 158108, 158109, 158110, 158111, 158112, 158113, 158115, 158117, 158120, 113833)) 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,600669,577783,577782,564283,564282,558567,15199,15201,15202,77990,77995,84791,84792,84794,84795,84797,84798,84799,90764,158106,158108,158109,158110,158111,158112,158113,158115,158117,158120,113833)
-
[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-00241
Model: 241
Condition: New-In-Box
-
SKU: THI-00247
Model: 247
Condition: New-In-Box
-
SKU: THI-00976
Model: 976
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-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
-
SKU: THI-00067
Model: TT067
Condition: New-In-Box
-
SKU: THI-00064
Model: 700064
Condition: New-In-Box
-
SKU: THI-00456
Model: 456
Condition: New-In-Box