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 (585495, 582162, 552077, 194667, 13702, 8522, 2956, 2959, 10476, 385302, 385306, 390105, 390107, 450621, 470684, 337219, 404533, 419851, 433014, 520460, 520461, 498799, 500689, 251773, 259145, 71961, 17621, 18444, 19424, 28210)) 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,585495,582162,552077,194667,13702,8522,2956,2959,10476,385302,385306,390105,390107,450621,470684,337219,404533,419851,433014,520460,520461,498799,500689,251773,259145,71961,17621,18444,19424,28210)
-
SKU: NIK-20116
Model: 20122
Condition: New-In-Box
Mount Type: Nikon Z
-
SKU: NIK-71742
Model: 20123
Condition: New-In-Box
Mount Type: Nikon Z
-
SKU: NIK-20119
Model: 20119
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-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-12260
Model: 2180
Condition: New-In-Box
Mount Types: Nikon F (DX), Nikon F (FX)
-
SKU: NIK-12253
Model: 2200
Condition: New-In-Box
Mount Type: Nikon F (DX)
-
SKU: NIK-71023
Model: 20103
Condition: New-In-Box
Mount Type: Nikon Z
-
SKU: NIK-71024
Model: 20100
Condition: New-In-Box
Mount Type: Nikon Z
-
SKU: NIK-71086
Model: 20109
Condition: New-In-Box
Mount Type: Nikon Z
-
SKU: NIK-71087
Model: 20110
Condition: New-In-Box
Mount Type: Nikon Z
-
SKU: NIK-71740
Model: 20108
Condition: New-In-Box
Mount Type: Nikon Z
-
SKU: NIK-71080
Model: 20112
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-71095
Model: 20111
Condition: New-In-Box
Mount Type: Nikon Z
-
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-20113
Model: 20113
Condition: New-In-Box
Mount Type: Nikon Z
-
SKU: NIK-20121
Model: 20121
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-12432A
Model: 20064
Condition: New-In-Box
Mount Type: Nikon F (FX)
-
SKU: NIK-12532
Model: 2217
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-12522
Model: 2223
Condition: New-In-Box
Mount Type: Nikon F (FX)
-
SKU: NIK-12552
Model: 20054
Condition: New-In-Box
Mount Type: Nikon F (FX)