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 (17228, 17229, 17230, 17231, 17232, 17376, 17377, 17415, 17425, 17460, 12760, 12797, 12799, 12926, 12928, 13075, 13121, 13702, 7451, 7470, 8522, 5309, 5311, 5326, 5352, 5371, 2956, 2959, 3038, 3040)) 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,17228,17229,17230,17231,17232,17376,17377,17415,17425,17460,12760,12797,12799,12926,12928,13075,13121,13702,7451,7470,8522,5309,5311,5326,5352,5371,2956,2959,3038,3040)
-
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
-
SKU: NIK-12183
Model: 2216
Condition: New-In-Box
Mount Type: Nikon F (DX)
-
SKU: NIK-20320
Model: 4731
Condition: New-In-Box
-
SKU: NIK-20582
Model: 25324
Condition: New-In-Box
-
SKU: NIK-20578
Model: 4784
Condition: New-In-Box
-
SKU: NIK-20238
Model: 27051
Condition: New-In-Box
-
SKU: NIK-12860
Model: 4976
Condition: New-In-Box
-
SKU: NIK-23028
Model: 25851
Condition: New-In-Box
-
SKU: NIK-20237
Model: 27008
Condition: New-In-Box
-
SKU: NIK-12228
Model: 2203
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-12274
Model: 2199
Condition: New-In-Box
Mount Types: Nikon F (DX), Nikon F (FX)
-
SKU: NIK-12842
Model: 4345
Condition: New-In-Box
-
SKU: NIK-13082
Model: 4808
Condition: New-In-Box
-
SKU: NIK-20610
Model: 25335
Condition: New-In-Box
-
SKU: NIK-21514
Model: 4348
Condition: New-In-Box
-
SKU: NIK-23300
Model: 4945
Condition: New-In-Box
-
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-12833
Model: 4924
Condition: New-In-Box
-
SKU: NIK-12838
Model: 4942
Condition: New-In-Box
