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 (488591, 521842, 239560, 239561, 306283, 371855, 371977, 376338, 376339, 377363, 377769, 379015, 397525, 446431, 446440, 446444, 446451, 446457, 446463, 446471, 459479, 459494, 459501, 459511, 459512, 467040, 467046, 481721, 481727, 481731)) 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,488591,521842,239560,239561,306283,371855,371977,376338,376339,377363,377769,379015,397525,446431,446440,446444,446451,446457,446463,446471,459479,459494,459501,459511,459512,467040,467046,481721,481727,481731)
-
SKU: DJI-01820
Model: CP.OS.00000213.01
Condition: New-In-Box
-
SKU: DJI-01830
Model: CP.OS.00000214.01
Condition: New-In-Box
-
SKU: DJI-01701
Model: CP.OS.00000025.01
Condition: New-In-Box
-
SKU: DJI-01702
Model: CP.OS.00000027.01
Condition: New-In-Box
-
SKU: DJI-01174
Model: CP.MA.00000228.01
Condition: New-In-Box
-
SKU: DJI-04154
Model: CP.RN.00000102.01
Condition: New-In-Box
-
SKU: DJI-01151A
Model: CP.MA.00000306.01
Condition: New-In-Box
-
SKU: DJI-01180
Model: CP.MA.00000354.01
Condition: New-In-Box
-
SKU: DJI-01181
Model: CP.MA.00000346.01
Condition: New-In-Box
-
SKU: DJI-01223
Model: CP.FP.00000039.01
Condition: New-In-Box
-
SKU: DJI-01224
Model: FPV-CS-SHUTTER
Condition: New-In-Box
-
SKU: DJI-01176
Model: CP.MA.AS000001.01
Condition: New-In-Box
-
SKU: DJI-01154
Model: CP.MA.00000324.01
Condition: New-In-Box
-
SKU: DJI-05002
Model: CP.RN.00000186.01
Condition: New-In-Box
-
SKU: DJI-05003
Model: CP.RN.00000192.01
Condition: New-In-Box
Mount Type: Sony E
-
SKU: DJI-05004
Model: CP.RN.00000189.01
Condition: New-In-Box
-
SKU: DJI-05005
Model: CP.RN.00000190.01
Condition: New-In-Box
-
SKU: DJI-05006
Model: CP.RN.00000185.01
Condition: New-In-Box
-
SKU: DJI-05007
Model: CP.RN.00000205.01
Condition: New-In-Box
-
SKU: DJI-05008
Model: CP.RN.00000193.01
Condition: New-In-Box
-
SKU: DJI-263176
Model: CP.MA.00000495.01
Condition: New-In-Box
-
SKU: DJI-263181
Model: CHX162-30
Condition: New-In-Box
-
SKU: DJI-263185
Model: CP.MA.00000501.01
Condition: New-In-Box
-
SKU: DJI-263187
Model: CP.MA.00000503.01
Condition: New-In-Box
-
SKU: DJI-263188
Model: CP.MA.00000504.01
Condition: New-In-Box
-
SKU: DJI-09503
Model: CP.RN.00000216.01
Condition: New-In-Box
-
SKU: DJI-09506
Model: CP.RN.00000218.01
Condition: New-In-Box
-
SKU: DJI-03200
Model: CP.FP.00000062.01
Condition: New-In-Box
-
SKU: DJI-03202
Model: CP.FP.00000111.01
Condition: New-In-Box
-
SKU: DJI-03203
Model: CP.FP.00000071.01
Condition: New-In-Box