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 (452330, 452335, 416249, 416254, 416257, 416260, 416265, 416266, 419047, 205905, 206230, 206252, 224487, 38994, 87399, 87400, 87401, 87402, 87403, 87404, 87405, 87406, 87407, 87408, 96587, 105814, 105816, 173034, 135780, 135781)) 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,452330,452335,416249,416254,416257,416260,416265,416266,419047,205905,206230,206252,224487,38994,87399,87400,87401,87402,87403,87404,87405,87406,87407,87408,96587,105814,105816,173034,135780,135781)
-
SKU: VAN-30020
Model: VEOHD80A
Condition: New-In-Box
-
SKU: VAN-30021
Model: VESTA 203AGH
Condition: New-In-Box
-
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-00829
Model: QS-29
Condition: New-In-Box
-
SKU: VAN-00200
Model: ALTA PRO 263AP
Condition: New-In-Box
-
SKU: VAN-00300
Model: ALTA CA 203AGH
Condition: New-In-Box
-
SKU: VAN-00400
Model: ALTA CA 203AP
Condition: New-In-Box
-
SKU: VAN-00410
Model: VEO 204AB
Condition: New-In-Box
-
SKU: VAN-00412
Model: VEO 235AB
Condition: New-In-Box
-
SKU: VAN-00414
Model: VEO 235AP
Condition: New-In-Box
-
SKU: VAN-30001
Model: HAVANA 38
Condition: New-In-Box
-
SKU: VAN-30002
Model: HAVANA 41
Condition: New-In-Box
-
SKU: VAN-31001
Model: ADAPTOR 45
Condition: New-In-Box
-
SKU: VAN-31002
Model: ADAPTOR 46
Condition: New-In-Box
-
SKU: VAN-00901
Model: QS-60S
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-00301
Model: GH-300T
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