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 (582162, 8522, 2959, 390107, 337219, 404533, 419851, 251773, 259145, 265884, 265885, 194667, 13702, 520460, 520461, 2951, 2965, 5305, 291363, 194668, 194669, 71961, 18444, 17099, 31041, 12899, 116956, 500689)) 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,582162,8522,2959,390107,337219,404533,419851,251773,259145,265884,265885,194667,13702,520460,520461,2951,2965,5305,291363,194668,194669,71961,18444,17099,31041,12899,116956,500689)
-
SKU: NIK-71742
Model: 20123
Condition: New-In-Box
Mount Type: Nikon Z
-
SKU: NIK-12274
Model: 2199
Condition: New-In-Box
Mount Types: Nikon F (DX), Nikon F (FX)
-
SKU: NIK-12260
Model: 2180
Condition: New-In-Box
Mount Types: Nikon F (DX), Nikon F (FX)
-
SKU: NIK-71087
Model: 20110
Condition: New-In-Box
Mount Type: Nikon Z
-
SKU: NIK-71022
Model: 20095
Condition: New-In-Box
Mount Type: Nikon Z
-
SKU: NIK-71012
Model: 20102
Condition: New-In-Box
Mount Type: Nikon Z
-
SKU: NIK-71088
Model: 20101
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-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-71010
Model: 20081
Condition: New-In-Box
Mount Type: Nikon Z
-
SKU: NIK-12228
Model: 2203
Condition: New-In-Box
Mount Types: Nikon F (DX), Nikon F (FX)
-
SKU: NIK-71090
Model: 20114
Condition: New-In-Box
Mount Type: Nikon Z
-
SKU: NIK-70996
Model: 20116
Condition: New-In-Box
Mount Type: Nikon Z
-
SKU: NIK-12190
Model: 2184
Condition: New-In-Box
Mount Types: Nikon F (DX), Nikon F (FX)
-
SKU: NIK-12390
Model: 2195
Condition: New-In-Box
Mount Types: Nikon F (DX), Nikon F (FX)
-
SKU: NIK-12240
Model: 2198
Condition: New-In-Box
Mount Types: Nikon F (DX), Nikon F (FX)
-
SKU: NIK-70980
Model: 20093
Condition: New-In-Box
Mount Type: Nikon Z
-
SKU: NIK-71020
Model: 20083
Condition: New-In-Box
Mount Type: Nikon Z
-
SKU: NIK-71030
Model: 20086
Condition: New-In-Box
Mount Type: Nikon Z
-
SKU: NIK-12432A
Model: 20064
Condition: New-In-Box
Mount Type: Nikon F (FX)
-
SKU: NIK-12184
Model: 20051
Condition: New-In-Box
Mount Types: Nikon F (DX), Nikon F (FX)
-
SKU: NIK-12246
Model: 2215
Condition: New-In-Box
Mount Type: Nikon F (FX)
-
SKU: NIK-12194
Model: 20057
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-12227
Model: 20069
Condition: New-In-Box
Mount Type: Nikon F (FX)
-
SKU: NIK-20121
Model: 20121
Condition: New-In-Box
Mount Type: Nikon Z