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 (624224, 558341, 558320, 17460, 7451, 7470, 31043, 75083, 75084, 337218, 411652, 415683, 415690, 424706, 539995, 487989, 265884, 265885, 282803, 291364, 325019, 224915, 15398, 15506, 16667, 17130, 7474, 5254, 5257, 2955)) 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,624224,558341,558320,17460,7451,7470,31043,75083,75084,337218,411652,415683,415690,424706,539995,487989,265884,265885,282803,291364,325019,224915,15398,15506,16667,17130,7474,5254,5257,2955)
-
SKU: PRE-NIK-20125
Model: 20125
Condition: Preorder
Mount Type: Nikon Z
-
SKU: NIK-71009
Model: 20117
Condition: New-In-Box
Mount Type: Nikon Z
-
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-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-12495
Model: 20058
Condition: New-In-Box
Mount Type: Nikon F (FX)
-
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-70952
Model: 20097
Condition: New-In-Box
Mount Type: Nikon Z
-
SKU: NIK-70961
Model: 20104
Condition: New-In-Box
Mount Type: Nikon Z
-
SKU: NIK-71007
Model: 20106
Condition: New-In-Box
Mount Type: Nikon Z
-
SKU: NIK-71004
Model: 20105
Condition: New-In-Box
Mount Type: Nikon Z
-
SKU: NIK-71089
Model: 20107
Condition: New-In-Box
Mount Type: Nikon Z
-
SKU: NIK-20118
Model: 20118
Condition: New-In-Box
Mount Type: Nikon Z
-
SKU: NIK-70982
Model: 20115
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-71060
Model: 20091
Condition: New-In-Box
Mount Type: Nikon Z
-
SKU: NIK-71006
Model: 20092
Condition: New-In-Box
Mount Type: Nikon Z
-
SKU: NIK-70995
Model: 20096
Condition: New-In-Box
Mount Type: Nikon Z
-
SKU: NIK-70948
Model: 20089
Condition: New-In-Box
Mount Type: Nikon Z
-
SKU: NIK-12116
Model: 2207
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-12156
Model: 2213
Condition: New-In-Box
Mount Type: Nikon F (DX)
-
SKU: NIK-12131
Model: 2211
Condition: New-In-Box
Mount Type: Nikon F (DX)
-
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-12095
Model: 2178
Condition: New-In-Box
Mount Type: Nikon F (DX)
-
SKU: NIK-12490
Model: 2187
Condition: New-In-Box
Mount Types: Nikon F (DX), Nikon F (FX)