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 (592566, 582464, 546380, 546068, 341554, 341559, 404533, 406868, 406872, 406873, 406874, 406876, 419851, 424706, 265881, 325016, 325017, 325018, 17425, 130692, 110786, 110787, 470668, 470669, 470670, 5383, 341532, 341537, 406867, 406875)) 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,592566,582464,546380,546068,341554,341559,404533,406868,406872,406873,406874,406876,419851,424706,265881,325016,325017,325018,17425,130692,110786,110787,470668,470669,470670,5383,341532,341537,406867,406875)
-
SKU: NIK-13602
Model: 13602
Condition: New-In-Box
-
SKU: NIK-01739
Model: 1781
Condition: New-In-Box
-
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-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-16764
Model: 16764
Condition: New-In-Box
-
SKU: NIK-16766
Model: 16766
Condition: New-In-Box
-
SKU: NIK-16765
Model: 16765
Condition: New-In-Box
-
SKU: NIK-16767
Model: 16767
Condition: New-In-Box
-
SKU: NIK-16768
Model: 16768
Condition: New-In-Box
-
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-70104
Model: 1632
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-50299
Model: 8252
Condition: New-In-Box
-
SKU: NIK-10196
Model: 1585
Condition: New-In-Box
Mount Type: Nikon F (FX)
-
SKU: NIK-10259
Model: 1581
Condition: New-In-Box
Mount Type: Nikon F (DX)
-
SKU: NIK-10260
Model: 1582
Condition: New-In-Box
Mount Type: Nikon F (DX)
-
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-50278
Model: 7245
Condition: New-In-Box
-
SKU: NIK-70004
Model: 1659
Condition: New-In-Box
Mount Type: Nikon Z
-
SKU: NIK-70005
Model: 1663
Condition: New-In-Box
Mount Type: Nikon Z
-
SKU: NIK-16763
Model: 16763
Condition: New-In-Box
-
SKU: NIK-16769
Model: 16769
Condition: New-In-Box
