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 (627656, 627650, 627649, 627593, 627590, 627585, 627582, 627579, 627215, 627209, 627207, 627203, 627174, 627171, 627170, 627167, 627165, 627105, 627100, 610391, 607068, 604503, 602921, 602851, 602849, 602835, 598325, 598323, 588538, 588536)) 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,627656,627650,627649,627593,627590,627585,627582,627579,627215,627209,627207,627203,627174,627171,627170,627167,627165,627105,627100,610391,607068,604503,602921,602851,602849,602835,598325,598323,588538,588536)
-
SKU: DJI-03223
Model: CP.FP.00000151.02
Condition: New-In-Box
-
SKU: PRE-DJI-03222
Model: CP.FP.00000150.02
Condition: Preorder
-
SKU: PRE-DJI-03220
Model: CP.FP.00000149.01
Condition: Preorder
-
SKU: DJI-03229
Model: CP.FP.00000156.01
Condition: New-In-Box
-
SKU: DJI-03228
Model: CP.RC.00000024.01
Condition: New-In-Box
-
SKU: DJI-03227
Model: CP.FP.00000152.01
Condition: New-In-Box
-
SKU: DJI-03226
Model: CP.RC.00000023.01
Condition: New-In-Box
-
SKU: DJI-03225
Model: CP.FP.00000159.01
Condition: New-In-Box
-
SKU: DJI-09532
Model: CP.RN.00000370.01
Condition: New-In-Box
-
SKU: DJI-09530
Model: CP.RN.00000360.01
Condition: New-In-Box
-
SKU: DJI-09529
Model: CP.RN.00000359.01
Condition: New-In-Box
-
SKU: DJI-09528
Model: CP.RN.00000340.01
Condition: New-In-Box
-
SKU: DJI-09527
Model: CP.RN.00000361.01
Condition: New-In-Box
-
SKU: DJI-09526
Model: CP.RN.00000404.01
Condition: New-In-Box
-
SKU: DJI-09525
Model: CP.RN.00000403.01
Condition: New-In-Box
-
SKU: DJI-09521
Model: CP.RN.00000346.01
Condition: New-In-Box
-
SKU: DJI-09519A
Model: CP.RN.00000345.01
Condition: New-In-Box
-
SKU: DJI-09517
Model: CP.RN.00000344.01
Condition: New-In-Box
-
SKU: DJI-09515
Model: CP.RN.00000343.01
Condition: New-In-Box
-
SKU: DJI-04156
Model: CP.RN.00000227.01
Condition: New-In-Box
-
SKU: DJI-01615
Model: CP.OS.00000305.01
Condition: New-In-Box
-
[Black, White]
SKU: DJI-MIC 2 TRANSMITTER ONLY
Model: CP.RN.00000328.02, CP.RN.00000329.01
Condition: New-In-Box
-
SKU: DJI-04905
Model: CP.RN.00000327.02
Condition: New-In-Box
-
SKU: DJI-04909
Model: CP.RN.00000331.01
Condition: New-In-Box
-
SKU: DJI-04908
Model: CP.RN.00000330.01
Condition: New-In-Box
-
SKU: DJI-04904
Model: CP.RN.00000325.02
Condition: New-In-Box
-
SKU: DJI-05015
Model: CP.RN.00000341.01
Condition: New-In-Box
-
SKU: DJI-05014
Model: CP.RN.00000351.01
Condition: New-In-Box
-
SKU: DJI-01611
Model: CP.OS.00000302.01
Condition: New-In-Box
-
SKU: DJI-01610
Model: CP.OS.00000301.01
Condition: New-In-Box