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 (385953, 480044, 443832, 490490, 508739, 6573, 8850, 4771, 4814, 4818, 364215, 364218, 246660, 246665, 246666, 255243, 267304, 267305, 204660, 209441, 211861, 113833, 113836, 113837, 113840, 158106, 158108, 158109, 158110, 158111)) 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,385953,480044,443832,490490,508739,6573,8850,4771,4814,4818,364215,364218,246660,246665,246666,255243,267304,267305,204660,209441,211861,113833,113836,113837,113840,158106,158108,158109,158110,158111)
-
[Graphite, Dark Olive]
SKU: THI-VISION13
Model: 710684, 710685
Condition: New-In-Box
-
SKU: THI-00638G
Model: 740646
Condition: New-In-Box
-
SKU: THI-00640
Model: 874530006432
Condition: New-In-Box
-
SKU: THI-710630
Model: 710630
Condition: New-In-Box
-
SKU: THI-00634
Model: 740647
Condition: New-In-Box
-
SKU: THI-00639
Model: 639
Condition: New-In-Box
-
SKU: THI-00984
Model: 984
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-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-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-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