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 (367601, 415618, 417123, 417124, 417203, 417205, 417206, 417208, 438369, 438370, 531382, 533955, 533957, 533959, 533960, 485673, 486216, 486217, 486218, 490224, 490227, 490229, 490230, 490231, 490232, 494815, 498526, 498528, 498531, 498551)) 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,367601,415618,417123,417124,417203,417205,417206,417208,438369,438370,531382,533955,533957,533959,533960,485673,486216,486217,486218,490224,490227,490229,490230,490231,490232,494815,498526,498528,498531,498551)
-
SKU: DJI-01205
Model: CP.FP.00000021.01
Condition: New-In-Box
-
SKU: DJI-01704
Model: CP.OS.00000183.01
Condition: New-In-Box
-
SKU: DJI-00446
Model: CP.MA.00000440.01
Condition: New-In-Box
-
SKU: DJI-00445
Model: CP.MA.00000439.01
Condition: New-In-Box
-
SKU: DJI-00500
Model: CP.MA.00000406.01
Condition: New-In-Box
-
SKU: DJI-00503
Model: CP.MA.00000429.01
Condition: New-In-Box
-
SKU: DJI-00502
Model: CP.MA.00000433.01
Condition: New-In-Box
-
SKU: DJI-00504
Model: CP.MA.00000430.01
Condition: New-In-Box
-
SKU: DJI-02230
Model: CP.IN.00000014.01
Condition: New-In-Box
-
SKU: DJI-02231
Model: CP.BX.00000013.01
Condition: New-In-Box
-
SKU: DJI-00904
Model: CP.EN.00000379.01
Condition: New-In-Box
-
SKU: DJI-03201A
Model: CP.FP.00000129.01
Condition: New-In-Box
-
SKU: DJI-01227
Model: CP.RC.00000007.01
Condition: New-In-Box
-
SKU: DJI-03208
Model: CP.FP.00000130.01
Condition: New-In-Box
-
SKU: DJI-01226
Model: CP.FP.00000113.01
Condition: New-In-Box
-
SKU: DJI-01149
Model: CP.MA.00000326.01
Condition: New-In-Box
-
SKU: DJI-01800
Model: CP.OS.00000220.01
Condition: New-In-Box
-
SKU: DJI-01801
Model: CP.OS.00000221.01
Condition: New-In-Box
-
SKU: DJI-01810
Model: CP.OS.00000229.01
Condition: New-In-Box
-
SKU: DJI-600300
Model: CP.EN.00000421.01
Condition: New-In-Box
-
SKU: DJI-600301
Model: CP.EN.00000422.01
Condition: New-In-Box
-
SKU: DJI-600302
Model: CP.EN.00000424.01
Condition: New-In-Box
-
SKU: DJI-600303
Model: CP.EN.00000417.01
Condition: New-In-Box
-
SKU: DJI-600304
Model: CP.EN.00000418.01
Condition: New-In-Box
-
SKU: DJI-600305
Model: CP.EN.00000430.01
Condition: New-In-Box
-
SKU: DJI-00460
Model: CP.RN.00000209.01
Condition: New-In-Box
-
SKU: DJI-00454
Model: CP.MA.00000561.01
Condition: New-In-Box
-
SKU: DJI-00455
Model: CP.EN.00000422.01
Condition: New-In-Box
-
SKU: DJI-00456
Model: CP.MA.00000562.01
Condition: New-In-Box
-
SKU: DJI-00450
Model: CP.MA.00000596.01
Condition: New-In-Box