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, 85043, 224915, 7470, 10476, 385306, 337218, 419851, 424706, 487989, 520461, 282803, 17621, 31042, 5256, 5262, 5265, 5269, 5276, 2943, 2944, 2949, 385302, 390107, 433014, 282806)) 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,85043,224915,7470,10476,385306,337218,419851,424706,487989,520461,282803,17621,31042,5256,5262,5265,5269,5276,2943,2944,2949,385302,390107,433014,282806)
-
SKU: NIK-71052
Model: 20120
Condition: New-In-Box
Mount Type: Nikon Z
-
SKU: NIK-12341
Model: 20063
Condition: New-In-Box
Mount Type: Nikon F (FX)
-
SKU: NIK-70948
Model: 20089
Condition: New-In-Box
Mount Type: Nikon Z
-
SKU: NIK-12080
Model: 2163
Condition: New-In-Box
Mount Type: Nikon F (FX)
-
SKU: NIK-12253
Model: 2200
Condition: New-In-Box
Mount Type: Nikon F (DX)
-
SKU: NIK-71024
Model: 20100
Condition: New-In-Box
Mount Type: Nikon Z
-
SKU: NIK-70952
Model: 20097
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-70982
Model: 20115
Condition: New-In-Box
Mount Type: Nikon Z
-
SKU: NIK-70996
Model: 20116
Condition: New-In-Box
Mount Type: Nikon Z
-
SKU: NIK-71060
Model: 20091
Condition: New-In-Box
Mount Type: Nikon Z
-
SKU: NIK-12532
Model: 2217
Condition: New-In-Box
Mount Type: Nikon F (FX)
-
SKU: NIK-12211
Model: 20052
Condition: New-In-Box
Mount Types: Nikon F (DX), Nikon F (FX)
-
SKU: NIK-12085
Model: 1910
Condition: New-In-Box
Mount Types: Nikon F (DX), Nikon F (FX)
-
SKU: NIK-12200
Model: 1919
Condition: New-In-Box
Mount Types: Nikon F (DX), Nikon F (FX)
-
SKU: NIK-12510
Model: 2186
Condition: New-In-Box
Mount Types: Nikon F (DX), Nikon F (FX)
-
SKU: NIK-12640
Model: 2174
Condition: New-In-Box
Mount Types: Nikon F (DX), Nikon F (FX)
-
SKU: NIK-12650
Model: 2175
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)
-
SKU: NIK-71023
Model: 20103
Condition: New-In-Box
Mount Type: Nikon Z
-
SKU: NIK-71087
Model: 20110
Condition: New-In-Box
Mount Type: Nikon Z
-
SKU: NIK-71095
Model: 20111
Condition: New-In-Box
Mount Type: Nikon Z
-
SKU: NIK-12438
Model: 20088
Condition: New-In-Box
Mount Type: Nikon F (FX)
