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 (224487, 173034, 182276, 182277, 182278, 182279, 182280, 182281, 182282, 182283, 182284, 182285, 182286, 182287, 182288, 182289, 183984, 183985, 183986, 183987, 190974, 205905, 206230, 206252, 38994, 105814, 105816, 135780, 135781, 135790)) 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,224487,173034,182276,182277,182278,182279,182280,182281,182282,182283,182284,182285,182286,182287,182288,182289,183984,183985,183986,183987,190974,205905,206230,206252,38994,105814,105816,135780,135781,135790)
-
SKU: VAN-02038
Model: VANGUARD UP-RISE II 33 MESS BAG
Condition: New-In-Box
-
SKU: VAN-00301
Model: GH-300T
Condition: New-In-Box
-
SKU: VAN-00422
Model: VEO AM-234
Condition: New-In-Box
-
SKU: VAN-00424
Model: VEO AM-264
Condition: New-In-Box
-
SKU: VAN-00426
Model: VEO AM-264TR
Condition: New-In-Box
-
SKU: VAN-00428
Model: VEO AM-295
Condition: New-In-Box
-
SKU: VAN-00430
Model: VEO AM-324
Condition: New-In-Box
-
SKU: VAN-00500
Model: TBH-40
Condition: New-In-Box
-
SKU: VAN-00600
Model: TBH-100
Condition: New-In-Box
-
SKU: VAN-00700
Model: BBH-100
Condition: New-In-Box
-
SKU: VAN-00800
Model: BBH-200
Condition: New-In-Box
-
SKU: VAN-00839
Model: QS-39
Condition: New-In-Box
-
SKU: VAN-00900
Model: QS-60
Condition: New-In-Box
-
SKU: VAN-01000
Model: ENDEAVOR ED 1042
Condition: New-In-Box
-
SKU: VAN-02037
Model: VEO 37
Condition: New-In-Box
-
SKU: VAN-02042
Model: VEO 42
Condition: New-In-Box
-
SKU: VAN-00211
Model: 263CB100
Condition: New-In-Box
-
SKU: VAN-00440
Model: VEO 2 235CB
Condition: New-In-Box
-
SKU: VAN-01002
Model: FLY 49T
Condition: New-In-Box
-
SKU: VAN-01006
Model: FLY 55T
Condition: New-In-Box
-
SKU: VAN-00432
Model: VEO CM264
Condition: New-In-Box
-
SKU: VAN-00892
Model: QS-52
Condition: New-In-Box
-
SKU: VAN-00205
Model: ALTA PRO 263AB 100
Condition: New-In-Box
-
SKU: VAN-00845
Model: QS-45
Condition: New-In-Box
-
SKU: VAN-00829
Model: QS-29
Condition: New-In-Box
-
SKU: VAN-00416
Model: VEO 265AB
Condition: New-In-Box
-
SKU: VAN-00420
Model: VEO AM-204
Condition: New-In-Box
-
SKU: VAN-00210
Model: ALTA PRO 2+ 263CT
Condition: New-In-Box
-
SKU: VAN-00212
Model: ALTA PRO 2+ 264CT
Condition: New-In-Box
-
SKU: VAN-00950
Model: PH-113V
Condition: New-In-Box