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 (628878, 573129, 573124, 573116, 573100, 573098, 573095, 573084, 573081, 573080, 573078, 573077, 573075, 573073, 573071, 573066, 95153, 388103, 388104, 388105, 388106, 388504, 388511, 388522, 388523, 209749, 209752, 209753, 209754, 209759)) 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,628878,573129,573124,573116,573100,573098,573095,573084,573081,573080,573078,573077,573075,573073,573071,573066,95153,388103,388104,388105,388106,388504,388511,388522,388523,209749,209752,209753,209754,209759)
-
SKU: MGM-00206
Model: MMBEAM02
Condition: New-In-Box
-
SKU: MGM-00570
Model: MMXPRFMT01
Condition: New-In-Box
-
SKU: MGM-00565
Model: MMXCS01
Condition: New-In-Box
-
SKU: MGM-00560
Model: MMXDCRGEL01
Condition: New-In-Box
-
SKU: MGM-00555
Model: MMXDARGEL01
Condition: New-In-Box
-
SKU: MGM-00550
Model: MMXDCOGEL01
Condition: New-In-Box
-
SKU: MGM-00545
Model: MMXDDIFGEL01
Condition: New-In-Box
-
SKU: MGM-00540
Model: MMXDFULLCTOGEL01
Condition: New-In-Box
-
SKU: MGM-00535
Model: MMXD14CTOGEL01
Condition: New-In-Box
-
SKU: MGM-00530
Model: MMXD12CTOGEL01
Condition: New-In-Box
-
SKU: MGM-00525
Model: MMXGRID2001
Condition: New-In-Box
-
SKU: MGM-00520
Model: MMXGRID4001
Condition: New-In-Box
-
SKU: MGM-00515
Model: MMXSPHERE01
Condition: New-In-Box
-
SKU: MGM-00510
Model: MMXREFL01
Condition: New-In-Box
-
SKU: MGM-00505
Model: MMXPROKIT01
Condition: New-In-Box
-
SKU: MGM-00500
Model: MMXSTRKIT01
Condition: New-In-Box
-
SKU: MGM-00180
Model: STANDARD GEL SET
Condition: New-In-Box
-
SKU: MGM-00217G
Model: PRGRD42SV1
Condition: New-In-Box
-
SKU: MGM-00301G
Model: PRGRD36SV1
Condition: New-In-Box
-
SKU: MGM-00214PG
Model: PRGRD24SV1
Condition: New-In-Box
-
SKU: MGM-00219
Model: PRCLGV1
Condition: New-In-Box
-
SKU: MGM-00217
Model: PRBX42V1
Condition: New-In-Box
-
SKU: MGM-00300
Model: PRBS36V1
Condition: New-In-Box
-
SKU: MGM-00281
Model: MMSHOE02
Condition: New-In-Box
-
SKU: MGM-00214P
Model: PRBS24V1
Condition: New-In-Box
-
SKU: MGM-00218
Model: MMBOXCSM01
Condition: New-In-Box
-
SKU: MGM-00284
Model: MMBOXCOGEL01
Condition: New-In-Box
-
SKU: MGM-00286
Model: MMBOXCRGEL01
Condition: New-In-Box
-
SKU: MGM-00288
Model: MMBOXARGEL01
Condition: New-In-Box
-
SKU: MGM-00296
Model: MMBOXSPDPRF01
Condition: New-In-Box