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 (12532, 12525, 12526, 12527, 12528, 12529, 12530, 12531, 13859, 11694, 12167, 6265, 6267, 6268, 6269, 6270, 6271, 6272, 6273, 6274, 6275, 4353, 4354, 4355, 4356, 4357, 4358, 4359, 4360, 4361)) 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,12532,12525,12526,12527,12528,12529,12530,12531,13859,11694,12167,6265,6267,6268,6269,6270,6271,6272,6273,6274,6275,4353,4354,4355,4356,4357,4358,4359,4360,4361)
-
SKU: STO-00050
Model: OM-COL
Condition: New-In-Box
-
SKU: STO-00018
Model: OM-4X
Condition: New-In-Box
-
SKU: STO-00029A
Model: OM-EV
Condition: New-In-Box
-
SKU: STO-00035
Model: OM-MZ40
Condition: New-In-Box
-
SKU: STO-00037
Model: OM-MZ80
Condition: New-In-Box
-
SKU: STO-00041
Model: OC-EYSET
Condition: New-In-Box
-
SKU: STO-00042
Model: OM-PZ8
Condition: New-In-Box
-
SKU: STO-00042A
Model: OM-MZ6
Condition: New-In-Box
-
SKU: STO-00029G
Model: OM-ET
Condition: New-In-Box
-
SKU: STO-00028
Model: OM-EU
Condition: New-In-Box
-
SKU: STO-00039
Model: OC-EUGL
Condition: New-In-Box
-
SKU: STO-00001
Model: TW-285
Condition: New-In-Box
-
SKU: STO-00011
Model: OM-CT45
Condition: New-In-Box
-
SKU: STO-00019
Model: SNBK01
Condition: New-In-Box
-
SKU: STO-00021
Model: SNBK02
Condition: New-In-Box
-
SKU: STO-00025
Model: SNBK1
Condition: New-In-Box
-
SKU: STO-00029
Model: SNOMEY
Condition: New-In-Box
-
SKU: STO-00030
Model: OM-400
Condition: New-In-Box
-
SKU: STO-00031
Model: SNM600
Condition: New-In-Box
-
SKU: STO-00033
Model: SNBKOMMZ70
Condition: New-In-Box
-
SKU: STO-00044
Model: OM-HV58
Condition: New-In-Box
-
SKU: STO-00007
Model: OM-522
Condition: New-In-Box
-
SKU: STO-00013
Model: OM-CT60
Condition: New-In-Box
-
SKU: STO-00014
Model: SNBK04
Condition: New-In-Box
-
SKU: STO-00015
Model: TW-B
Condition: New-In-Box
-
SKU: STO-00017
Model: SNBKMZ3
Condition: New-In-Box
-
SKU: STO-00017A
Model: SNBKSB5
Condition: New-In-Box
-
SKU: STO-00026
Model: SNOMEW
Condition: New-In-Box
-
SKU: STO-00027
Model: OM-EX
Condition: New-In-Box
-
SKU: STO-00040
Model: SYNOCEYGL
Condition: New-In-Box