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 (16027, 17028, 17227, 17228, 17229, 17230, 17231, 17232, 17376, 17377, 17415, 17425, 17460, 85042, 85043, 21377, 22340, 31043, 45723, 45724, 122341, 122343, 123287, 130692, 130694, 130695, 110786, 110787, 116996, 116997)) 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,16027,17028,17227,17228,17229,17230,17231,17232,17376,17377,17415,17425,17460,85042,85043,21377,22340,31043,45723,45724,122341,122343,123287,130692,130694,130695,110786,110787,116996,116997)
-
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
-
SKU: NIK-12183
Model: 2216
Condition: New-In-Box
Mount Type: Nikon F (DX)
-
SKU: NIK-12870F
Model: 4168
Condition: New-In-Box
-
SKU: NIK-12341
Model: 20063
Condition: New-In-Box
Mount Type: Nikon F (FX)
-
SKU: NIK-12869
Model: 4130
Condition: New-In-Box
-
SKU: NIK-21688A
Model: 27148
Condition: New-In-Box
-
SKU: NIK-12495
Model: 20058
Condition: New-In-Box
Mount Type: Nikon F (FX)
-
SKU: NIK-13095
Model: 4815
Condition: New-In-Box
-
SKU: NIK-23355
Model: 27161
Condition: New-In-Box
-
SKU: NIK-12870A
Model: 4160
Condition: New-In-Box
-
SKU: NIK-21423
Model: 4158
Condition: New-In-Box
-
SKU: NIK-12870K
Model: 4178
Condition: New-In-Box
-
SKU: NIK-10196
Model: 1585
Condition: New-In-Box
Mount Type: Nikon F (FX)
-
SKU: NIK-21564G
Model: 27188
Condition: New-In-Box
-
SKU: NIK-27192
Model: 27192
Condition: New-In-Box
-
SKU: NIK-10259
Model: 1581
Condition: New-In-Box
Mount Type: Nikon F (DX)
-
SKU: NIK-10260
Model: 1582
Condition: New-In-Box
Mount Type: Nikon F (DX)
-
SKU: NIK-12870H
Model: 4175
Condition: New-In-Box
-
SKU: NIK-12870J
Model: 4176
Condition: New-In-Box