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, 558320, 552077, 13702, 2956, 10476, 8522, 7451, 7470, 385302, 337218, 337219, 404533, 415690, 419851, 424706, 251773, 259145, 291363, 325019, 194667, 194668, 75084, 130692, 500689, 520460, 12899, 2943, 2944, 2949)) 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,558320,552077,13702,2956,10476,8522,7451,7470,385302,337218,337219,404533,415690,419851,424706,251773,259145,291363,325019,194667,194668,75084,130692,500689,520460,12899,2943,2944,2949)
-
SKU: NIK-71742
Model: 20123
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-12228
Model: 2203
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-12274
Model: 2199
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-12080
Model: 2163
Condition: New-In-Box
Mount Type: Nikon F (FX)
-
SKU: NIK-71023
Model: 20103
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-71012
Model: 20102
Condition: New-In-Box
Mount Type: Nikon Z
-
SKU: NIK-71004
Model: 20105
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-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-70980
Model: 20093
Condition: New-In-Box
Mount Type: Nikon Z
-
SKU: NIK-70995
Model: 20096
Condition: New-In-Box
Mount Type: Nikon Z
-
SKU: NIK-71010
Model: 20081
Condition: New-In-Box
Mount Type: Nikon Z
-
SKU: NIK-71020
Model: 20083
Condition: New-In-Box
Mount Type: Nikon Z
-
SKU: NIK-12132A
Model: 20060
Condition: New-In-Box
Mount Type: Nikon F (DX)
-
SKU: NIK-10196
Model: 1585
Condition: New-In-Box
Mount Type: Nikon F (FX)
-
SKU: NIK-20121
Model: 20121
Condition: New-In-Box
Mount Type: Nikon Z
-
SKU: NIK-71090
Model: 20114
Condition: New-In-Box
Mount Type: Nikon Z
-
SKU: NIK-12404
Model: 2201
Condition: New-In-Box
Mount Types: Nikon F (DX), Nikon F (FX)
-
SKU: NIK-12065
Model: 2148
Condition: New-In-Box
Mount Type: Nikon F (DX)
-
SKU: NIK-12075
Model: 1925
Condition: New-In-Box
Mount Types: Nikon F (DX), Nikon F (FX)
-
SKU: NIK-12185
Model: 1913
Condition: New-In-Box
Mount Types: Nikon F (DX), Nikon F (FX)