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 (446444, 446451, 446457, 446463, 446471, 459479, 459494, 459501, 459511, 459512, 467040, 467046, 481721, 481727, 481731, 481734, 481737, 481739, 485673, 486216, 486217, 486218, 490224, 490227, 490229, 490230, 490231, 490232, 494815, 498526)) 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,446444,446451,446457,446463,446471,459479,459494,459501,459511,459512,467040,467046,481721,481727,481731,481734,481737,481739,485673,486216,486217,486218,490224,490227,490229,490230,490231,490232,494815,498526)
-
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
-
SKU: DJI-03204
Model: CP.FP.00000072.01
Condition: New-In-Box
-
SKU: DJI-03205
Model: CP.FP.00000073.01
Condition: New-In-Box
-
SKU: DJI-03206
Model: CP.FP.00000074.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