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 (61899, 77862, 18364, 20587, 16223, 16699, 16700, 17571, 93109, 111342, 111343, 111344, 151723, 21133, 21134, 21135, 21171, 21291, 15035, 15036, 8863, 8864, 8865, 8866, 8867, 8868, 11125, 194965, 195045, 195046)) 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,61899,77862,18364,20587,16223,16699,16700,17571,93109,111342,111343,111344,151723,21133,21134,21135,21171,21291,15035,15036,8863,8864,8865,8866,8867,8868,11125,194965,195045,195046)
-
SKU: MAT-159015
Model: 159015
Condition: New-In-Box
-
SKU: MAT-259531
Model: 259531
Condition: New-In-Box
-
SKU: MAT-387030
Model: 387030
Condition: New-In-Box
-
SKU: MAT-339758
Model: 339758
Condition: New-In-Box
-
Matthews Studio Equipment
Mini-Boom
USD $170.00
SKU: MAT-427802
Model: 427802
Condition: New-In-Box
-
SKU: MAT-209644
Model: 209644
Condition: New-In-Box
-
SKU: MAT-429492
Model: 429492
Condition: New-In-Box
-
SKU: MAT-06348
Model: 6348-1/100
Condition: New-In-Box
-
SKU: MAT-339574
Model: B339574
Condition: New-In-Box
-
SKU: MAT-429041
Model: 429041
Condition: New-In-Box
-
SKU: MAT-429065
Model: 429065
Condition: New-In-Box
-
SKU: MAT-429085
Model: 429085
Condition: New-In-Box
-
SKU: MAT-169028
Model: 169028T
Condition: New-In-Box
-
SKU: MAT-219710
Model: 219710
Condition: New-In-Box
-
SKU: MAT-219910
Model: 219910
Condition: New-In-Box
-
SKU: MAT-229732
Model: 229732
Condition: New-In-Box
-
SKU: MAT-259535
Model: 259535
Condition: New-In-Box
-
SKU: MAT-119726
Model: 119726
Condition: New-In-Box
-
SKU: MAT-B756040
Model: B756040
Condition: New-In-Box
-
SKU: MAT-B427802
Model: B427802
Condition: New-In-Box
-
SKU: MAT-299888
Model: 299888
Condition: New-In-Box
-
SKU: MAT-350595
Model: 350595
Condition: New-In-Box
-
SKU: MAT-350598
Model: 350598
Condition: New-In-Box
-
SKU: MAT-429599
Model: 429599
Condition: New-In-Box
-
SKU: MAT-429779
Model: 429779
Condition: New-In-Box
-
SKU: MAT-B429722
Model: B429722
Condition: New-In-Box
-
SKU: MAT-429039
Model: 429039
Condition: New-In-Box
-
SKU: MAT-339763
Model: 339763
Condition: New-In-Box
-
SKU: MAT-149061
Model: 149061
Condition: New-In-Box
-
SKU: MAT-149066
Model: 149066
Condition: New-In-Box