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, 582162, 580330, 580327, 580326, 558341, 552077, 546380, 546068, 7470, 385306, 337218, 337219, 341532, 341554, 341559, 404533, 415338, 415683, 415690, 251773, 259145, 265881, 282803, 291363, 325016, 325017, 325018)) 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,582162,580330,580327,580326,558341,552077,546380,546068,7470,385306,337218,337219,341532,341554,341559,404533,415338,415683,415690,251773,259145,265881,282803,291363,325016,325017,325018)
-
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-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-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-12080
Model: 2163
Condition: New-In-Box
Mount Type: Nikon F (FX)
-
SKU: NIK-71024
Model: 20100
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-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-71004
Model: 20105
Condition: New-In-Box
Mount Type: Nikon Z
-
SKU: NIK-71085
Model: 20090
Condition: New-In-Box
Mount Type: Nikon Z
-
SKU: NIK-70990
Model: 20080
Condition: New-In-Box
Mount Type: Nikon Z
-
SKU: NIK-70104
Model: 1632
Condition: New-In-Box
Mount Type: Nikon Z
-
SKU: NIK-71060
Model: 20091
Condition: New-In-Box
Mount Type: Nikon Z
-
SKU: NIK-70980
Model: 20093
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