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, 31043, 85043, 450621, 470684, 415683, 433014, 498799, 520460, 265885, 282803, 71961, 75085, 75087, 28210, 195884, 123288, 152945, 19424, 15397, 15506, 12899, 5265, 2955, 2965, 3036, 17621)) 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,31043,85043,450621,470684,415683,433014,498799,520460,265885,282803,71961,75085,75087,28210,195884,123288,152945,19424,15397,15506,12899,5265,2955,2965,3036,17621)
-
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-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-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-71095
Model: 20111
Condition: New-In-Box
Mount Type: Nikon Z
-
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-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-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-12552
Model: 20054
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-12352
Model: 20068
Condition: New-In-Box
Mount Type: Nikon F (FX)
-
SKU: NIK-12489
Model: 20071
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)
-
SKU: NIK-12404
Model: 2201
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-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-12532
Model: 2217
Condition: New-In-Box
Mount Type: Nikon F (FX)