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 (75083, 75084, 110786, 110787, 17460, 7451, 8522, 2956, 2959, 10476, 13702, 75085, 75087, 18444, 15398, 116955, 31042, 16667, 17130, 5254, 5256, 5257, 5262, 5263, 5265, 5269, 5276, 5305, 2943, 2944)) 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,75083,75084,110786,110787,17460,7451,8522,2956,2959,10476,13702,75085,75087,18444,15398,116955,31042,16667,17130,5254,5256,5257,5262,5263,5265,5269,5276,5305,2943,2944)
-
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-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-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-12274
Model: 2199
Condition: New-In-Box
Mount Types: Nikon F (DX), Nikon F (FX)
-
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-12253
Model: 2200
Condition: New-In-Box
Mount Type: Nikon F (DX)
-
SKU: NIK-12228
Model: 2203
Condition: New-In-Box
Mount Types: Nikon F (DX), Nikon F (FX)
-
SKU: NIK-12351A
Model: 20062
Condition: New-In-Box
Mount Type: Nikon F (DX)
-
SKU: NIK-12351
Model: 20061
Condition: New-In-Box
Mount Type: Nikon F (DX)
-
SKU: NIK-12184
Model: 20051
Condition: New-In-Box
Mount Types: Nikon F (DX), Nikon F (FX)
-
SKU: NIK-12116
Model: 2207
Condition: New-In-Box
Mount Type: Nikon F (DX)
-
SKU: NIK-12057
Model: 20067
Condition: New-In-Box
Mount Type: Nikon F (DX)
-
SKU: NIK-12211
Model: 20052
Condition: New-In-Box
Mount Types: Nikon F (DX), 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-12070
Model: 2144
Condition: New-In-Box
Mount Type: Nikon F (DX)
-
SKU: NIK-12085
Model: 1910
Condition: New-In-Box
Mount Types: Nikon F (DX), Nikon F (FX)
-
SKU: NIK-12095
Model: 2178
Condition: New-In-Box
Mount Type: Nikon F (DX)
-
SKU: NIK-12200
Model: 1919
Condition: New-In-Box
Mount Types: Nikon F (DX), Nikon F (FX)
-
SKU: NIK-12630
Model: 2168
Condition: New-In-Box
Mount Types: Nikon F (DX), Nikon F (FX)
-
SKU: NIK-12510
Model: 2186
Condition: New-In-Box
Mount Types: Nikon F (DX), Nikon F (FX)
-
SKU: NIK-12640
Model: 2174
Condition: New-In-Box
Mount Types: Nikon F (DX), Nikon F (FX)
-
SKU: NIK-12650
Model: 2175
Condition: New-In-Box
Mount Types: Nikon F (DX), Nikon F (FX)
-
SKU: NIK-12240
Model: 2198
Condition: New-In-Box
Mount Types: Nikon F (DX), Nikon F (FX)
-
SKU: NIK-12065
Model: 2148
Condition: New-In-Box
Mount Type: Nikon F (DX)
-
SKU: NIK-12075
Model: 1925
Condition: New-In-Box
Mount Types: Nikon F (DX), Nikon F (FX)