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 (291363, 291364, 325016, 325017, 325018, 325019, 325029, 325030, 325037, 325038, 224915, 233930, 45724, 54479, 69861, 70028, 75083, 75084, 77873, 77875, 20345, 16027, 17028, 17227, 17228, 17229, 17230, 17231, 17232, 17376)) 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,291363,291364,325016,325017,325018,325019,325029,325030,325037,325038,224915,233930,45724,54479,69861,70028,75083,75084,77873,77875,20345,16027,17028,17227,17228,17229,17230,17231,17232,17376)
-
SKU: NIK-70980
Model: 20093
Condition: New-In-Box
Mount Type: Nikon Z
-
SKU: NIK-71006
Model: 20092
Condition: New-In-Box
Mount Type: Nikon Z
-
Nikon
Z 5 (Body Only)
Special Price
USD $1,296.95
After USD $100.00 Savings
SKU: NIK-69990
Model: 1649
Condition: New-In-Box
Mount Type: Nikon Z
-
SKU: NIK-69992
Model: 1641
Condition: New-In-Box
Mount Type: Nikon Z
-
SKU: NIK-69994
Model: 1642
Condition: New-In-Box
Mount Type: Nikon Z
-
SKU: NIK-70995
Model: 20096
Condition: New-In-Box
Mount Type: Nikon Z
-
SKU: NIK-20942C
Model: 27213
Condition: New-In-Box
-
SKU: NIK-21422B
Model: 4244
Condition: New-In-Box
-
SKU: NIK-73010
Model: 20098
Condition: New-In-Box
-
SKU: NIK-73020
Model: 20099
Condition: New-In-Box
-
SKU: NIK-70948
Model: 20089
Condition: New-In-Box
Mount Type: Nikon Z
-
SKU: NIK-21486KB
Model: 4196
Condition: New-In-Box
-
SKU: NIK-23355
Model: 27161
Condition: New-In-Box
-
SKU: NIK-12868F
Model: 4148
Condition: New-In-Box
-
SKU: NIK-21486L
Model: 4149
Condition: New-In-Box
-
SKU: NIK-50273R
Model: 16031
Condition: New-In-Box
-
SKU: NIK-12132
Model: 20059
Condition: New-In-Box
Mount Type: Nikon F (DX)
-
SKU: NIK-12132A
Model: 20060
Condition: New-In-Box
Mount Type: Nikon F (DX)
-
SKU: NIK-21486K
Model: 4132
Condition: New-In-Box
-
SKU: NIK-50611
Model: 8177
Condition: New-In-Box
-
SKU: NIK-23031
Model: 27146
Condition: New-In-Box
-
SKU: NIK-12876
Model: 3701
Condition: New-In-Box
-
SKU: NIK-20939
Model: 27126
Condition: New-In-Box
-
SKU: NIK-21422
Model: 4746
Condition: New-In-Box
-
SKU: NIK-21424
Model: 4747
Condition: New-In-Box
-
SKU: NIK-21426
Model: 4748
Condition: New-In-Box
-
SKU: NIK-21428
Model: 4115
Condition: New-In-Box
-
SKU: NIK-21430
Model: 4749
Condition: New-In-Box
-
SKU: NIK-21434
Model: 4750
Condition: New-In-Box
-
SKU: NIK-12867
Model: 4994
Condition: New-In-Box
