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 (629527, 629517, 629514, 629513, 629512, 629511, 629507, 629503, 629501, 629502, 629500, 629498, 629495, 629485, 629126, 567221, 556106, 545040, 403379, 218903, 484856, 493935, 493936, 493938, 493942, 380937, 403380, 439042, 218904, 232151)) 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,629527,629517,629514,629513,629512,629511,629507,629503,629501,629502,629500,629498,629495,629485,629126,567221,556106,545040,403379,218903,484856,493935,493936,493938,493942,380937,403380,439042,218904,232151)
-
SKU: I360-01133
Model: CINSBBMH
Condition: New-In-Box
-
SKU: I360-01132
Model: CINSBBMG
Condition: New-In-Box
-
SKU: I360-01130
Model: CINSBBMK
Condition: New-In-Box
-
SKU: I360-01129
Model: CINSBBML
Condition: New-In-Box
-
SKU: I360-01128
Model: CINSBBMC
Condition: New-In-Box
-
SKU: I360-01127
Model: CINSBBMB
Condition: New-In-Box
-
SKU: I360-01126
Model: CINSBBMJ
Condition: New-In-Box
-
SKU: I360-01125
Model: CINSBBMN
Condition: New-In-Box
-
SKU: I360-01124
Model: CINSBBMF
Condition: New-In-Box
-
SKU: I360-01123
Model: CINSBBME
Condition: New-In-Box
-
SKU: I360-01122
Model: CINSBBMS
Condition: New-In-Box
-
SKU: I360-01121
Model: CINSBBMD
Condition: New-In-Box
-
SKU: I360-01120
Model: CINSBBMR
Condition: New-In-Box
-
SKU: I360-01112G
Model: CINSBBMA
Condition: New-In-Box
-
SKU: I360-01102
Model: CINSABMA
Condition: New-In-Box
-
SKU: I360-00105
Model: DINEESS/A
Condition: New-In-Box
-
SKU: I360-00113
Model: CINSBAQG
Condition: New-In-Box
-
SKU: I360-01117
Model: CINAKDS/A
Condition: New-In-Box
-
SKU: I360-01110
Model: CINX2CB/A
Condition: New-In-Box
-
SKU: I360-00100
Model: 6970357850402
Condition: New-In-Box
-
SKU: I360-01101
Model: 266832
Condition: New-In-Box
-
SKU: I360-00201
Model: CINSBAQB
Condition: New-In-Box
-
SKU: I360-01112
Model: CINAQBT/A
Condition: New-In-Box
-
SKU: I360-01113
Model: CINSAAQ/A
Condition: New-In-Box
-
SKU: I360-00111
Model: CINSBAQC
Condition: New-In-Box
-
SKU: I360-01100
Model: CINOSXX/A
Condition: New-In-Box
-
SKU: I360-01111
Model: CINOSBT/C
Condition: New-In-Box
-
SKU: I360-00200
Model: CINX2CB/F
Condition: New-In-Box
-
SKU: I360-01000
Model: 842126100475
Condition: New-In-Box
-
SKU: I360-00110
Model: CINOXWH/A
Condition: New-In-Box