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 (38994, 205905, 206230, 206252, 87399, 87400, 87401, 87402, 87403, 87404, 87405, 87406, 87407, 87408, 96587, 224487, 105814, 105816, 135780, 135781, 135790, 173034, 182276, 182277, 182278, 182279, 182280, 182281, 182282, 182283)) 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,38994,205905,206230,206252,87399,87400,87401,87402,87403,87404,87405,87406,87407,87408,96587,224487,105814,105816,135780,135781,135790,173034,182276,182277,182278,182279,182280,182281,182282,182283)
-
SKU: VAN-00829
Model: QS-29
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-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-02038
Model: VANGUARD UP-RISE II 33 MESS BAG
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
-
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