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 (416249, 416254, 416257, 416260, 416265, 416266, 419047, 205905, 206230, 206252, 224487, 173034, 182276, 182277, 182278, 182279, 182280, 182281, 182282, 182283, 182284, 182285, 182286, 182287, 182288, 182289, 183984, 183985, 183986, 183987)) 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,416249,416254,416257,416260,416265,416266,419047,205905,206230,206252,224487,173034,182276,182277,182278,182279,182280,182281,182282,182283,182284,182285,182286,182287,182288,182289,183984,183985,183986,183987)
-
SKU: VAN-00433
Model: VEO3+263AB
Condition: New-In-Box
-
SKU: VAN-00434
Model: VEO3+263CB
Condition: New-In-Box
-
SKU: VAN-00435
Model: VEO3GO204CB
Condition: New-In-Box
-
SKU: VAN-02000
Model: ALTA RISE 45
Condition: New-In-Box
-
SKU: VAN-02020
Model: ALTA FLY 55T
Condition: New-In-Box
-
SKU: VAN-02030
Model: ALTA SKY 45D
Condition: New-In-Box
-
SKU: VAN-HAVANA 48
Model: HAVANA 48, HAVANA 48BL
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-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