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 (194668, 195913, 195973, 195975, 195976, 196202, 196207, 224915, 233930, 45723, 45724, 54479, 69861, 70028, 75083, 75084, 77873, 20345, 16027, 17028, 17227, 17228, 17229, 17230, 17231, 17232, 17376, 17377, 17415, 17425)) 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,194668,195913,195973,195975,195976,196202,196207,224915,233930,45723,45724,54479,69861,70028,75083,75084,77873,20345,16027,17028,17227,17228,17229,17230,17231,17232,17376,17377,17415,17425)
-
SKU: NIK-71020
Model: 20083
Condition: New-In-Box
Mount Type: Nikon Z
-
SKU: NIK-20816
Model: 4217
Condition: New-In-Box
-
SKU: NIK-20220
Model: 4219
Condition: New-In-Box
-
SKU: NIK-23031D
Model: 4216
Condition: New-In-Box
-
SKU: NIK-23031F
Model: 4223
Condition: New-In-Box
-
SKU: NIK-12870P
Model: 4184
Condition: New-In-Box
-
SKU: NIK-21518
Model: 4182
Condition: New-In-Box
-
SKU: NIK-70948
Model: 20089
Condition: New-In-Box
Mount Type: Nikon Z
-
SKU: NIK-21486KB
Model: 4196
Condition: New-In-Box
-
SKU: NIK-13095
Model: 4815
Condition: New-In-Box
-
SKU: NIK-23355
Model: 27161
Condition: New-In-Box
-
SKU: NIK-12868F
Model: 4148
Condition: New-In-Box
-
SKU: NIK-21486L
Model: 4149
Condition: New-In-Box
-
SKU: NIK-50273R
Model: 16031
Condition: New-In-Box
-
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-21486K
Model: 4132
Condition: New-In-Box
-
SKU: NIK-23031
Model: 27146
Condition: New-In-Box
-
SKU: NIK-12876
Model: 3701
Condition: New-In-Box
-
SKU: NIK-20939
Model: 27126
Condition: New-In-Box
-
SKU: NIK-21422
Model: 4746
Condition: New-In-Box
-
SKU: NIK-21424
Model: 4747
Condition: New-In-Box
-
SKU: NIK-21426
Model: 4748
Condition: New-In-Box
-
SKU: NIK-21428
Model: 4115
Condition: New-In-Box
-
SKU: NIK-21430
Model: 4749
Condition: New-In-Box
-
SKU: NIK-21434
Model: 4750
Condition: New-In-Box
-
SKU: NIK-12867
Model: 4994
Condition: New-In-Box
-
SKU: NIK-12868
Model: 4998
Condition: New-In-Box
-
SKU: NIK-20946A
Model: 3767
Condition: New-In-Box
-
SKU: NIK-50299
Model: 8252
Condition: New-In-Box