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 (555228, 553782, 544932, 4833, 4838, 4841, 6599, 426109, 454328, 454481, 459273, 4821, 4826, 4827, 4828, 4832, 4836, 4839, 4840, 4842, 9097, 244004, 200389, 109903, 109904, 109905, 14723, 17573, 6586, 6587)) 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,555228,553782,544932,4833,4838,4841,6599,426109,454328,454481,459273,4821,4826,4827,4828,4832,4836,4839,4840,4842,9097,244004,200389,109903,109904,109905,14723,17573,6586,6587)
-
SKU: TIF-17741
Model: 77ND6
Condition: New-In-Box
-
SKU: TIF-18238
Model: 82ND6
Condition: New-In-Box
-
SKU: TIF-22100
Model: 82GG1
Condition: New-In-Box
-
SKU: TIF-16742
Model: 67UVP
Condition: New-In-Box
-
SKU: TIF-17262
Model: 72UVP
Condition: New-In-Box
-
SKU: TIF-17730
Model: 77UVP
Condition: New-In-Box
-
SKU: TIF-18230
Model: 82UVP
Condition: New-In-Box
-
SKU: TIF-15840
Model: 49UVP
Condition: New-In-Box
-
Sizes: 49mm, 58mm, 67mm, 72mm, 77mm, 82mm
SKU: TIF-1-8-BLACKMIST
Model: 49BPM18, 58BPM18, 67BPM18, 72BPM18, 77BPM18, 82BPM18
Condition: New-In-Box
-
Sizes: 49mm, 58mm, 67mm, 72mm, 77mm, 82mm
SKU: TIF-1-4-BLACKMIST
Model: 49BPM14, 58BPM14, 67BPM14, 72BPM14, 77BPM14, 82BPM14
Condition: New-In-Box
-
SKU: TIF-50056
Model: EXPLORERV
Condition: New-In-Box
-
SKU: TIF-14964
Model: 49UC3
Condition: New-In-Box
-
SKU: TIF-15846
Model: 58UVP
Condition: New-In-Box
-
SKU: TIF-16218
Model: 62CP
Condition: New-In-Box
-
SKU: TIF-16226
Model: W62DIGULTCLR
Condition: New-In-Box
-
SKU: TIF-16718
Model: W67DIGULTCLR
Condition: New-In-Box
-
SKU: TIF-17230
Model: 72CGND6
Condition: New-In-Box
-
SKU: TIF-17718
Model: 77CGND6
Condition: New-In-Box
-
SKU: TIF-17726
Model: 77SFX3
Condition: New-In-Box
-
SKU: TIF-18614
Model: 86C UVP
Condition: New-In-Box
-
SKU: TIF-17740
Model: 77VND
Condition: New-In-Box
-
SKU: TIF-40030
Model: 82SFX1
Condition: New-In-Box
-
SKU: TIF-18240
Model: 82VND
Condition: New-In-Box
-
SKU: TIF-16231
Model: 6247
Condition: New-In-Box
-
SKU: TIF-16232
Model: 6258
Condition: New-In-Box
-
SKU: TIF-16233
Model: 62R25
Condition: New-In-Box
-
SKU: TIF-17710
Model: 77812
Condition: New-In-Box
-
SKU: TIF-15267
Model: 52OR21
Condition: New-In-Box
-
SKU: TIF-14936
Model: 49PM2
Condition: New-In-Box
-
SKU: TIF-15818
Model: W58DIGULTCLR
Condition: New-In-Box