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 (585495, 582162, 558341, 558320, 10476, 385306, 450621, 470684, 415683, 265885, 282803, 31043, 85043, 498799, 520460, 2955, 2965, 3036, 5265, 385302, 433014, 282806, 195884, 71961, 75085, 75087, 17621, 19424, 15397, 15506)) 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,585495,582162,558341,558320,10476,385306,450621,470684,415683,265885,282803,31043,85043,498799,520460,2955,2965,3036,5265,385302,433014,282806,195884,71961,75085,75087,17621,19424,15397,15506)
-
SKU: NIK-20116
Model: 20122
Condition: New-In-Box
Mount Type: Nikon Z
-
SKU: NIK-71742
Model: 20123
Condition: New-In-Box
Mount Type: Nikon Z
-
SKU: NIK-71009
Model: 20117
Condition: New-In-Box
Mount Type: Nikon Z
-
SKU: NIK-71052
Model: 20120
Condition: New-In-Box
Mount Type: Nikon Z
-
SKU: NIK-12253
Model: 2200
Condition: New-In-Box
Mount Type: Nikon F (DX)
-
SKU: NIK-71024
Model: 20100
Condition: New-In-Box
Mount Type: Nikon Z
-
SKU: NIK-71740
Model: 20108
Condition: New-In-Box
Mount Type: Nikon Z
-
SKU: NIK-71080
Model: 20112
Condition: New-In-Box
Mount Type: Nikon Z
-
SKU: NIK-71007
Model: 20106
Condition: New-In-Box
Mount Type: Nikon Z
-
SKU: NIK-71026
Model: 20085
Condition: New-In-Box
Mount Type: Nikon Z
-
SKU: NIK-71060
Model: 20091
Condition: New-In-Box
Mount Type: Nikon Z
-
SKU: NIK-12495
Model: 20058
Condition: New-In-Box
Mount Type: Nikon F (FX)
-
SKU: NIK-12341
Model: 20063
Condition: New-In-Box
Mount Type: Nikon F (FX)
-
SKU: NIK-20113
Model: 20113
Condition: New-In-Box
Mount Type: Nikon Z
-
SKU: NIK-71090
Model: 20114
Condition: New-In-Box
Mount Type: Nikon Z
-
SKU: NIK-12490
Model: 2187
Condition: New-In-Box
Mount Types: Nikon F (DX), Nikon F (FX)
-
SKU: NIK-12390
Model: 2195
Condition: New-In-Box
Mount Types: Nikon F (DX), Nikon F (FX)
-
SKU: NIK-12462
Model: 2188
Condition: New-In-Box
Mount Types: Nikon F (DX), Nikon F (FX)
-
SKU: NIK-12510
Model: 2186
Condition: New-In-Box
Mount Types: Nikon F (DX), Nikon F (FX)
-
SKU: NIK-71023
Model: 20103
Condition: New-In-Box
Mount Type: Nikon Z
-
SKU: NIK-71095
Model: 20111
Condition: New-In-Box
Mount Type: Nikon Z
-
SKU: NIK-12438
Model: 20088
Condition: New-In-Box
Mount Type: Nikon F (FX)
-
SKU: NIK-12544
Model: 20082
Condition: New-In-Box
Mount Type: Nikon F (FX)
-
SKU: NIK-12432A
Model: 20064
Condition: New-In-Box
Mount Type: Nikon F (FX)
-
SKU: NIK-12351A
Model: 20062
Condition: New-In-Box
Mount Type: Nikon F (DX)
-
SKU: NIK-12351
Model: 20061
Condition: New-In-Box
Mount Type: Nikon F (DX)
-
SKU: NIK-12532
Model: 2217
Condition: New-In-Box
Mount Type: Nikon F (FX)
-
SKU: NIK-12522
Model: 2223
Condition: New-In-Box
Mount Type: Nikon F (FX)
-
SKU: NIK-12560
Model: 2205
Condition: New-In-Box
Mount Type: Nikon F (FX)
-
SKU: NIK-12371
Model: 2208
Condition: New-In-Box
Mount Type: Nikon F (FX)