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 (624224, 585495, 582162, 580330, 580327, 580326, 558341, 558320, 552077, 546380, 546068, 385302, 385306, 390105, 450621, 470684, 337218, 337219, 341532, 341554, 341559, 404533, 411652, 415338, 415683, 415685, 415690, 419851, 424706, 433014)) 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,624224,585495,582162,580330,580327,580326,558341,558320,552077,546380,546068,385302,385306,390105,450621,470684,337218,337219,341532,341554,341559,404533,411652,415338,415683,415685,415690,419851,424706,433014)
-
SKU: PRE-NIK-20125
Model: 20125
Condition: Preorder
Mount Type: Nikon Z
-
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-70022
Model: 1772
Condition: New-In-Box
Mount Type: Nikon Z
-
SKU: NIK-70021
Model: 1763
Condition: New-In-Box
Mount Type: Nikon Z
-
SKU: NIK-70020
Model: 1761
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-20119
Model: 20119
Condition: New-In-Box
Mount Type: Nikon Z
-
SKU: NIK-70016
Model: 1695
Condition: New-In-Box
Mount Type: Nikon Z
-
Nikon
Z 8 (Body Only)
Special Price
USD $3,696.95
After USD $300.00 Savings
SKU: NIK-70015
Model: 1695
Condition: New-In-Box
Mount Type: Nikon Z
-
SKU: NIK-71023
Model: 20103
Condition: New-In-Box
Mount Type: Nikon Z
-
SKU: NIK-71024
Model: 20100
Condition: New-In-Box
Mount Type: Nikon Z
-
SKU: NIK-71086
Model: 20109
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-70952
Model: 20097
Condition: New-In-Box
Mount Type: Nikon Z
-
SKU: NIK-71022
Model: 20095
Condition: New-In-Box
Mount Type: Nikon Z
-
SKU: NIK-70004
Model: 1659
Condition: New-In-Box
Mount Type: Nikon Z
-
SKU: NIK-70006
Model: 1653
Condition: New-In-Box
Mount Type: Nikon Z
-
SKU: NIK-70007
Model: 1656
Condition: New-In-Box
Mount Type: Nikon Z
-
SKU: NIK-71012
Model: 20102
Condition: New-In-Box
Mount Type: Nikon Z
-
SKU: NIK-70961
Model: 20104
Condition: New-In-Box
Mount Type: Nikon Z
-
SKU: NIK-70008
Model: 1669
Condition: New-In-Box
Mount Type: Nikon Z
-
SKU: NIK-71007
Model: 20106
Condition: New-In-Box
Mount Type: Nikon Z
-
SKU: NIK-73005
Model: 4264
Condition: New-In-Box
Mount Type: Nikon Z
-
SKU: NIK-71004
Model: 20105
Condition: New-In-Box
Mount Type: Nikon Z
-
SKU: NIK-71088
Model: 20101
Condition: New-In-Box
Mount Type: Nikon Z
-
SKU: NIK-71089
Model: 20107
Condition: New-In-Box
Mount Type: Nikon Z
-
SKU: NIK-71095
Model: 20111
Condition: New-In-Box
Mount Type: Nikon Z