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 (122343, 123287, 130692, 130694, 130695, 155095, 110786, 110787, 116996, 116997, 116999, 381429, 385302, 385306, 388711, 390105, 395392, 450621, 453638, 466383, 466384, 466386, 466387, 466388, 466392, 466394, 470668, 470669, 470670, 470671)) 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,122343,123287,130692,130694,130695,155095,110786,110787,116996,116997,116999,381429,385302,385306,388711,390105,395392,450621,453638,466383,466384,466386,466387,466388,466392,466394,470668,470669,470670,470671)
-
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-12870B
Model: 4170
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
-
SKU: NIK-21483
Model: 4177
Condition: New-In-Box
-
SKU: NIK-12870V1
Model: 4246
Condition: New-In-Box
-
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-21436
Model: 4231
Condition: New-In-Box
-
SKU: NIK-71086
Model: 20109
Condition: New-In-Box
Mount Type: Nikon Z
-
SKU: NIK-12870G
Model: 4174
Condition: New-In-Box
-
SKU: NIK-71740
Model: 20108
Condition: New-In-Box
Mount Type: Nikon Z
-
SKU: NIK-21429
Model: 4230
Condition: New-In-Box
-
SKU: NIK-16770
Model: 16770
Condition: New-In-Box
-
SKU: NIK-16771
Model: 16771
Condition: New-In-Box
-
SKU: NIK-16773
Model: 16773
Condition: New-In-Box
-
SKU: NIK-16774
Model: 16774
Condition: New-In-Box
-
SKU: NIK-16772
Model: 16772
Condition: New-In-Box
-
SKU: NIK-16776
Model: 16776
Condition: New-In-Box
-
SKU: NIK-16777
Model: 16777
Condition: New-In-Box
-
SKU: NIK-01737
Model: 1737
Condition: New-In-Box
-
SKU: NIK-01749
Model: 1749
Condition: New-In-Box
-
SKU: NIK-01743
Model: 1743
Condition: New-In-Box
-
SKU: NIK-13567
Model: 13567
Condition: New-In-Box