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 (560538, 13493, 13494, 13495, 13496, 13498, 13499, 13500, 13501, 13502, 13503, 13504, 13514, 13517, 13526, 13899, 16218, 371671, 378512, 378514, 378515, 378516, 381939, 393203, 396510, 396511, 396977, 399261, 399272, 327216)) 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,560538,13493,13494,13495,13496,13498,13499,13500,13501,13502,13503,13504,13514,13517,13526,13899,16218,371671,378512,378514,378515,378516,381939,393203,396510,396511,396977,399261,399272,327216)
-
SKU: KUPO-KG092311
Model: KG092311
Condition: New-In-Box
-
SKU: KUPO-KG000812
Model: KG000812
Condition: New-In-Box
-
SKU: KUPO-KG001712
Model: KG001712
Condition: New-In-Box
-
SKU: KUPO-KG002612
Model: KG002612
Condition: New-In-Box
-
SKU: KUPO-KG003912
Model: KG003912
Condition: New-In-Box
-
SKU: KUPO-KG005512
Model: KG005512
Condition: New-In-Box
-
SKU: KUPO-KG005712
Model: KG005712
Condition: New-In-Box
-
SKU: KUPO-KG005912
Model: KG005912
Condition: New-In-Box
-
SKU: KUPO-KG006411
Model: KG006411
Condition: New-In-Box
-
SKU: KUPO-KG100211
Model: KG100211
Condition: New-In-Box
-
SKU: KUPO-KG200912
Model: KG200912
Condition: New-In-Box
-
SKU: KUPO-KG202011
Model: KG202011
Condition: New-In-Box
-
SKU: KUPO-KG302011
Model: KG302011
Condition: New-In-Box
-
SKU: KUPO-KG601612
Model: KG601612
Condition: New-In-Box
-
SKU: KUPO-KG900712
Model: KG900712
Condition: New-In-Box
-
SKU: KUPO-KG002212
Model: KG002212
Condition: New-In-Box
-
SKU: KUPO-KG600412
Model: KG600412
Condition: New-In-Box
-
SKU: KUPO-KS101412
Model: KS101412
Condition: New-In-Box
-
SKU: KUPO-KG604012
Model: KG604012
Condition: New-In-Box
-
SKU: KUPO-KG008512
Model: KG008512
Condition: New-In-Box
-
SKU: KUPO-KG400512
Model: KG400512
Condition: New-In-Box
-
SKU: KUPO-KG070412
Model: KG070412
Condition: New-In-Box
-
SKU: KUPO-KS704811
Model: KS704811
Condition: New-In-Box
-
[Black, Silver]
SKU: 26550
Model: KG203012, KG203111
Condition: New-In-Box
-
SKU: KUPO-KS500412
Model: KS500412
Condition: New-In-Box
-
SKU: KUPO-KG601711
Model: KG601711
Condition: New-In-Box
-
SKU: KUPO-KS600212
Model: KS600212
Condition: New-In-Box
-
SKU: KUPO-KG603511
Model: KG603511
Condition: New-In-Box
-
SKU: KUPO-KS940712
Model: KS940712
Condition: New-In-Box
-
SKU: KUPO-KG088811
Model: KG088811
Condition: New-In-Box