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 (558320, 17460, 13702, 7451, 8522, 2956, 10476, 75083, 75084, 31043, 385302, 390105, 411652, 419851, 424706, 265884, 265885, 282804, 291364, 16667, 17099, 17130, 15506, 12899, 7474, 5254, 5256, 5257, 5262, 5263)) 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,558320,17460,13702,7451,8522,2956,10476,75083,75084,31043,385302,390105,411652,419851,424706,265884,265885,282804,291364,16667,17099,17130,15506,12899,7474,5254,5256,5257,5262,5263)
-
SKU: NIK-71052
Model: 20120
Condition: New-In-Box
Mount Type: Nikon Z
-
SKU: NIK-12183
Model: 2216
Condition: New-In-Box
Mount Type: Nikon F (DX)
-
SKU: NIK-12228
Model: 2203
Condition: New-In-Box
Mount Types: Nikon F (DX), Nikon F (FX)
-
SKU: NIK-12060
Model: 2181
Condition: New-In-Box
Mount Type: Nikon F (DX)
-
SKU: NIK-12274
Model: 2199
Condition: New-In-Box
Mount Types: Nikon F (DX), Nikon F (FX)
-
SKU: NIK-12245
Model: 2183
Condition: New-In-Box
Mount Type: Nikon F (DX)
-
SKU: NIK-12253
Model: 2200
Condition: New-In-Box
Mount Type: Nikon F (DX)
-
SKU: NIK-12132
Model: 20059
Condition: New-In-Box
Mount Type: Nikon F (DX)
-
SKU: NIK-12132A
Model: 20060
Condition: New-In-Box
Mount Type: Nikon F (DX)
-
SKU: NIK-12495
Model: 20058
Condition: New-In-Box
Mount Type: Nikon F (FX)
-
SKU: NIK-71023
Model: 20103
Condition: New-In-Box
Mount Type: Nikon Z
-
SKU: NIK-71086
Model: 20109
Condition: New-In-Box
Mount Type: Nikon Z
-
SKU: NIK-70961
Model: 20104
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-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-11081VN50
Model: 26532
Condition: New-In-Box
-
SKU: NIK-71006
Model: 20092
Condition: New-In-Box
Mount Type: Nikon Z
-
SKU: NIK-12156
Model: 2213
Condition: New-In-Box
Mount Type: Nikon F (DX)
-
SKU: NIK-12246
Model: 2215
Condition: New-In-Box
Mount Type: Nikon F (FX)
-
SKU: NIK-12131
Model: 2211
Condition: New-In-Box
Mount Type: Nikon F (DX)
-
SKU: NIK-12371
Model: 2208
Condition: New-In-Box
Mount Type: Nikon F (FX)
-
SKU: NIK-12404
Model: 2201
Condition: New-In-Box
Mount Types: Nikon F (DX), Nikon F (FX)
-
SKU: NIK-12225
Model: 2193
Condition: New-In-Box
Mount Type: Nikon F (FX)
-
SKU: NIK-12070
Model: 2144
Condition: New-In-Box
Mount Type: Nikon F (DX)
-
SKU: NIK-12085
Model: 1910
Condition: New-In-Box
Mount Types: Nikon F (DX), Nikon F (FX)
-
SKU: NIK-12095
Model: 2178
Condition: New-In-Box
Mount Type: Nikon F (DX)
-
SKU: NIK-12200
Model: 1919
Condition: New-In-Box
Mount Types: Nikon F (DX), Nikon F (FX)
-
SKU: NIK-12630
Model: 2168
Condition: New-In-Box
Mount Types: Nikon F (DX), Nikon F (FX)
