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, 592566, 585495, 580330, 580327, 580326, 558341, 546380, 546068, 385306, 390105, 450621, 470668, 470669, 470670, 470684, 341532, 341554, 341559, 411652, 415338, 415683, 265881, 265884, 265885, 282803, 282804, 291364, 325016, 325017)) 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,592566,585495,580330,580327,580326,558341,546380,546068,385306,390105,450621,470668,470669,470670,470684,341532,341554,341559,411652,415338,415683,265881,265884,265885,282803,282804,291364,325016,325017)
-
SKU: PRE-NIK-20125
Model: 20125
Condition: Preorder
Mount Type: Nikon Z
-
SKU: NIK-13602
Model: 13602
Condition: New-In-Box
-
SKU: NIK-20116
Model: 20122
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-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-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-01737
Model: 1737
Condition: New-In-Box
-
SKU: NIK-01749
Model: 1749
Condition: New-In-Box
-
SKU: NIK-01743
Model: 1743
Condition: New-In-Box
-
SKU: NIK-71080
Model: 20112
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-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-70104
Model: 1632
Condition: New-In-Box
Mount Type: Nikon Z
-
SKU: NIK-70960
Model: 20084
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-11081VN50
Model: 26532
Condition: New-In-Box
-
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