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 (11125, 8863, 8864, 8865, 8866, 8867, 8868, 238826, 238835, 194965, 195045, 195046, 195047, 195048, 195049, 195050, 195054, 195055, 195056, 195057, 195058, 195059, 195060, 195061, 195062, 195063, 195064, 195065, 195067, 195068)) 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,11125,8863,8864,8865,8866,8867,8868,238826,238835,194965,195045,195046,195047,195048,195049,195050,195054,195055,195056,195057,195058,195059,195060,195061,195062,195063,195064,195065,195067,195068)
-
SKU: MAT-429039
Model: 429039
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-H386033
Model: H386033
Condition: New-In-Box
-
SKU: MAT-H386025
Model: H386025
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
-
SKU: MAT-169029
Model: 169029
Condition: New-In-Box
-
SKU: MAT-169030
Model: 169030
Condition: New-In-Box
-
SKU: MAT-169059
Model: 169059
Condition: New-In-Box
-
SKU: MAT-169062
Model: 169062
Condition: New-In-Box
-
SKU: MAT-238126
Model: 238126
Condition: New-In-Box
-
SKU: MAT-238127
Model: 238127
Condition: New-In-Box
-
SKU: MAT-249566
Model: 249566-1
Condition: New-In-Box
-
SKU: MAT-259536
Model: 259536
Condition: New-In-Box
-
SKU: MAT-259537
Model: 259537
Condition: New-In-Box
-
SKU: MAT-259538
Model: 259538
Condition: New-In-Box
-
SKU: MAT-299552
Model: 299552
Condition: New-In-Box
-
SKU: MAT-29955E
Model: 229955E
Condition: New-In-Box
-
SKU: MAT-299700
Model: 299700
Condition: New-In-Box
-
SKU: MAT-299705
Model: 299705
Condition: New-In-Box
-
SKU: MAT-299887
Model: 299887
Condition: New-In-Box
-
SKU: MAT-309212
Model: 309212
Condition: New-In-Box
-
SKU: MAT-339759
Model: 339759
Condition: New-In-Box
-
SKU: MAT-350580
Model: 350580
Condition: New-In-Box