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 (423484, 423486, 522041, 485054, 485056, 485057, 485060, 485061, 514463, 514464, 5666, 5667, 5668, 5669, 5670, 5672, 5674, 5675, 5676, 5677, 5678, 5680, 5681, 5682, 5685, 5686, 5691, 5696, 5698, 5699)) 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,423484,423486,522041,485054,485056,485057,485060,485061,514463,514464,5666,5667,5668,5669,5670,5672,5674,5675,5676,5677,5678,5680,5681,5682,5685,5686,5691,5696,5698,5699)
-
SKU: PRF-101303
Model: 101303
Condition: New-In-Box
-
SKU: PRF-101304
Model: 101304
Condition: New-In-Box
-
Your Choice Of: Canon, Sony, Nikon, Fuji, Olympus
SKU: Connect
Model: 901310, 901312, 901314, 901316, 901318
Condition: New-In-Box
-
SKU: PRF-101305
Model: 101305
Condition: New-In-Box
-
SKU: PRF-101306
Model: 101306
Condition: New-In-Box
-
SKU: PRF-101307
Model: 101307
Condition: New-In-Box
-
SKU: PRF-101315
Model: 101315
Condition: New-In-Box
-
SKU: PRF-101316
Model: 101316
Condition: New-In-Box
-
SKU: PRF-101321
Model: 101321
Condition: New-In-Box
-
SKU: PRF-101308
Model: 101308
Condition: New-In-Box
-
SKU: PRF-100605
Model: 100605 (505-526)
Condition: New-In-Box
-
SKU: PRF-100614
Model: 100614 (505-604)
Condition: New-In-Box
-
SKU: PRF-100633
Model: 100633 (505-551)
Condition: New-In-Box
-
SKU: PRF-100651
Model: 100651 (505-529)
Condition: New-In-Box
-
SKU: PRF-100654
Model: 100654 (505-501)
Condition: New-In-Box
-
SKU: PRF-100717
Model: 100717 (505-516)
Condition: New-In-Box
-
SKU: PRF-101532
Model: 101532 (701-212)
Condition: New-In-Box
-
SKU: PRF-101534
Model: 101534 (701-261)
Condition: New-In-Box
-
SKU: PRF-102011
Model: 102011 (504-442)
Condition: New-In-Box
-
SKU: PRF-102018
Model: 102018 (504-449)
Condition: New-In-Box
-
SKU: PRF-102509
Model: 102509 (504-311)
Condition: New-In-Box
-
SKU: PRF-103001
Model: 103001 (504-301)
Condition: New-In-Box
-
SKU: PRF-103010
Model: 103010
Condition: New-In-Box
-
SKU: PRF-254518
Model: 254518 (505-412)
Condition: New-In-Box
-
SKU: PRF-331514
Model: 331514 (502-218)
Condition: New-In-Box
-
SKU: PRF-900619
Model: 900619 (501-210)
Condition: New-In-Box
-
SKU: PRF-900765
Model: 900765 (701-248)
Condition: New-In-Box
-
SKU: PRF-901022
Model: 901022
Condition: New-In-Box
-
SKU: PRF-901025
Model: 901025
Condition: New-In-Box
-
SKU: PRF-901032
Model: 901032
Condition: New-In-Box