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 (7470, 8522, 2959, 13702, 130692, 7474, 2944, 2949, 2951, 2955, 2965, 3036, 5256, 5262, 5263, 5265, 5269, 5276, 5305, 15397, 15506, 282801, 282802, 282806, 289885, 195884, 71961, 17621, 18444, 19424)) 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,7470,8522,2959,13702,130692,7474,2944,2949,2951,2955,2965,3036,5256,5262,5263,5265,5269,5276,5305,15397,15506,282801,282802,282806,289885,195884,71961,17621,18444,19424)
-
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-12260
Model: 2180
Condition: New-In-Box
Mount Types: Nikon F (DX), Nikon F (FX)
-
SKU: NIK-12228
Model: 2203
Condition: New-In-Box
Mount Types: Nikon F (DX), Nikon F (FX)
-
SKU: NIK-10196
Model: 1585
Condition: New-In-Box
Mount Type: Nikon F (FX)
-
SKU: NIK-12225
Model: 2193
Condition: New-In-Box
Mount Type: Nikon F (FX)
-
SKU: NIK-12075
Model: 1925
Condition: New-In-Box
Mount Types: Nikon F (DX), Nikon F (FX)
-
SKU: NIK-12185
Model: 1913
Condition: New-In-Box
Mount Types: Nikon F (DX), Nikon F (FX)
-
SKU: NIK-12190
Model: 2184
Condition: New-In-Box
Mount Types: Nikon F (DX), Nikon F (FX)
-
SKU: NIK-12490
Model: 2187
Condition: New-In-Box
Mount Types: Nikon F (DX), Nikon F (FX)
-
SKU: NIK-12390
Model: 2195
Condition: New-In-Box
Mount Types: Nikon F (DX), Nikon F (FX)
-
SKU: NIK-12462
Model: 2188
Condition: New-In-Box
Mount Types: Nikon F (DX), Nikon F (FX)
-
SKU: NIK-12085
Model: 1910
Condition: New-In-Box
Mount Types: Nikon F (DX), Nikon F (FX)
-
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-12560
Model: 2205
Condition: New-In-Box
Mount Type: Nikon F (FX)
-
SKU: NIK-12371
Model: 2208
Condition: New-In-Box
Mount Type: Nikon F (FX)
-
SKU: NIK-101841
Model: 1618
Condition: New-In-Box
Mount Type: Nikon F (FX)
-
SKU: NIK-10185
Model: 1619
Condition: New-In-Box
Mount Type: Nikon F (FX)
-
SKU: NIK-12438
Model: 20088
Condition: New-In-Box
Mount Type: Nikon F (FX)
-
SKU: NIK-10139
Model: 1624
Condition: New-In-Box
Mount Type: Nikon F (FX)
-
SKU: NIK-12544
Model: 20082
Condition: New-In-Box
Mount Type: Nikon F (FX)
-
SKU: NIK-12432A
Model: 20064
Condition: New-In-Box
Mount Type: Nikon F (FX)
-
SKU: NIK-12532
Model: 2217
Condition: New-In-Box
Mount Type: Nikon F (FX)
-
SKU: NIK-12184
Model: 20051
Condition: New-In-Box
Mount Types: Nikon F (DX), Nikon F (FX)
-
SKU: NIK-12522
Model: 2223
Condition: New-In-Box
Mount Type: Nikon F (FX)