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 (624255, 624224, 595206, 593388, 585495, 582166, 582164, 582162, 580330, 580327, 580326, 580314, 558366, 558364, 558341, 558320, 552077, 552036, 551874, 550725, 549229, 546389, 546382, 7451, 7470, 8522, 11617, 5309, 5326, 5352)) 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,624255,624224,595206,593388,585495,582166,582164,582162,580330,580327,580326,580314,558366,558364,558341,558320,552077,552036,551874,550725,549229,546389,546382,7451,7470,8522,11617,5309,5326,5352)
-
SKU: NIK-12945C
Model: 4287
Condition: New-In-Box
-
SKU: PRE-NIK-20125
Model: 20125
Condition: Preorder
Mount Type: Nikon Z
-
SKU: NIK-20215
Model: 4250
Condition: New-In-Box
-
SKU: NIK-27233
Model: 27233
Condition: New-In-Box
-
SKU: NIK-20116
Model: 20122
Condition: New-In-Box
Mount Type: Nikon Z
-
SKU: NIK-12943C
Model: 4290
Condition: New-In-Box
-
SKU: NIK-21278A
Model: 2497
Condition: New-In-Box
-
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-21686N
Model: 27239
Condition: New-In-Box
-
SKU: NIK-12945B
Model: 4284
Condition: New-In-Box
-
SKU: NIK-12943H
Model: 4280
Condition: New-In-Box
-
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-12946
Model: 4292
Condition: New-In-Box
-
SKU: NIK-12945
Model: 4282
Condition: New-In-Box
-
SKU: NIK-215593-1
Model: 27227
Condition: New-In-Box
-
SKU: NIK-21811
Model: 4953
Condition: New-In-Box
-
SKU: NIK-20819
Model: 27234
Condition: New-In-Box
-
SKU: NIK-215593
Model: 27227
Condition: New-In-Box
-
SKU: NIK-12060
Model: 2181
Condition: New-In-Box
Mount Type: Nikon F (DX)
-
SKU: NIK-12080
Model: 2163
Condition: New-In-Box
Mount Type: Nikon F (FX)
-
SKU: NIK-12274
Model: 2199
Condition: New-In-Box
Mount Types: Nikon F (DX), Nikon F (FX)
-
SKU: NIK-12843
Model: 4340
Condition: New-In-Box
-
SKU: NIK-12842
Model: 4345
Condition: New-In-Box
-
SKU: NIK-20610
Model: 25335
Condition: New-In-Box
-
SKU: NIK-21514
Model: 4348
Condition: New-In-Box
