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 (557638, 544840, 544837, 544830, 544827, 544822, 544819, 544815, 544811, 544806, 454511, 454520, 408235, 408238, 23871, 113598, 113600, 454505, 454506, 454522, 337284, 337285, 337286, 337287, 337918, 408236, 408240, 408242, 408243, 269259)) 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,557638,544840,544837,544830,544827,544822,544819,544815,544811,544806,454511,454520,408235,408238,23871,113598,113600,454505,454506,454522,337284,337285,337286,337287,337918,408236,408240,408242,408243,269259)
-
SKU: CAC-01609
Model: SRFPK-MDOW
Condition: New-In-Box
-
SKU: CAC-03018
Model: SLR15-MYTL
Condition: New-In-Box
-
SKU: CAC-03017
Model: SRFPK-BRIA
Condition: New-In-Box
-
SKU: CAC-03016
Model: SRFPK-DAND
Condition: New-In-Box
-
SKU: CAC-03015
Model: SRFPK-CITY
Condition: New-In-Box
-
SKU: CAC-03014
Model: SRFPK-BKBY
Condition: New-In-Box
-
SKU: CAC-03013
Model: SRFPK-OJAI
Condition: New-In-Box
-
SKU: CAC-03012
Model: SRFPK-ALOH
Condition: New-In-Box
-
SKU: CAC-03011
Model: SLR20-NEOB
Condition: New-In-Box
-
SKU: CAC-03010
Model: SLR20-NEOB
Condition: New-In-Box
-
SKU: CAC-01956
Model: SRFPK-CNDY
Condition: New-In-Box
-
SKU: CAC-01957
Model: SRFPK-CHEK
Condition: New-In-Box
-
SKU: CAC-02000
Model: SRFPK-ITMN
Condition: New-In-Box
-
SKU: CAC-02003
Model: SRFPK-DENM
Condition: New-In-Box
-
SKU: CAC-01802
Model: SLR20-REAP
Condition: New-In-Box
-
SKU: CAC-00250
Model: SCARF-BKBY
Condition: New-In-Box
-
SKU: CAC-00261
Model: SLR15-BFOW
Condition: New-In-Box
-
SKU: CAC-01953
Model: SRFPK-ANZO
Condition: New-In-Box
-
SKU: CAC-01952
Model: SRFPK-AMLI
Condition: New-In-Box
-
SKU: CAC-01958
Model: SRFPK-USA
Condition: New-In-Box
-
SKU: CAC-01616
Model: SRFPK-BLBL
Condition: New-In-Box
-
SKU: CAC-01618
Model: SRFPK-CALLCHAS
Condition: New-In-Box
-
SKU: CAC-01620
Model: SRFPK-KYLASASH
Condition: New-In-Box
-
SKU: CAC-01622
Model: SRFPK-LEAH
Condition: New-In-Box
-
SKU: CAC-01418
Model: SLR20-MYST
Condition: New-In-Box
-
SKU: CAC-02001
Model: SRFPK-ITRM
Condition: New-In-Box
-
SKU: CAC-02006
Model: SLR15-MESA
Condition: New-In-Box
-
SKU: CAC-02007
Model: SLR15-MOAB
Condition: New-In-Box
-
SKU: CAC-02008
Model: SLR15-TAOS
Condition: New-In-Box
-
SKU: CAC-01908
Model: SLR20-SIBK
Condition: New-In-Box