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 (625610, 604434, 566293, 560538, 71078, 71079, 77838, 77839, 77840, 77841, 17726, 17727, 17728, 18666, 18716, 20512, 20980, 20981, 20982, 20983, 20984, 20985, 20986, 20987, 20988, 20989, 20990, 20991, 20992, 20993)) 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,625610,604434,566293,560538,71078,71079,77838,77839,77840,77841,17726,17727,17728,18666,18716,20512,20980,20981,20982,20983,20984,20985,20986,20987,20988,20989,20990,20991,20992,20993)
-
SKU: KUPO-KG101021
Model: KG101021
Condition: New-In-Box
-
SKU: KUPO-KS704611
Model: KS704611
Condition: New-In-Box
-
SKU: KUPO-KG603711
Model: KG603711
Condition: New-In-Box
-
SKU: KUPO-KG092311
Model: KG092311
Condition: New-In-Box
-
SKU: KUPO-KG013411
Model: KG013411
Condition: New-In-Box
-
SKU: KUPO-KG014212
Model: KG014212
Condition: New-In-Box
-
SKU: KUPO-KG083011
Model: KG083011
Condition: New-In-Box
-
SKU: KUPO-KG088111
Model: KG088111
Condition: New-In-Box
-
SKU: KUPO-KG702311
Model: KG702311
Condition: New-In-Box
-
SKU: KUPO-KS704512
Model: KS704512
Condition: New-In-Box
-
SKU: KUPO-KG100911
Model: KG100911
Condition: New-In-Box
-
SKU: KUPO-KG084411
Model: KG084411
Condition: New-In-Box
-
SKU: KUPO-KG084611
Model: KG084611
Condition: New-In-Box
-
SKU: KUPO-KS704312
Model: KS704312
Condition: New-In-Box
-
SKU: KUPO-KS704712
Model: KS704712
Condition: New-In-Box
-
SKU: KUPO-KS704011
Model: KS704011
Condition: New-In-Box
-
SKU: KUPO-KG007412
Model: KG007412
Condition: New-In-Box
-
SKU: KUPO-KG007512
Model: KG007512
Condition: New-In-Box
-
SKU: KUPO-KG007812
Model: KG007812
Condition: New-In-Box
-
SKU: KUPO-KG007912
Model: KG007912
Condition: New-In-Box
-
SKU: KUPO-KG008012
Model: KG008012
Condition: New-In-Box
-
SKU: KUPO-KG008112
Model: KG008112
Condition: New-In-Box
-
SKU: KUPO-KG008212
Model: KG008212
Condition: New-In-Box
-
SKU: KUPO-KG008612
Model: KG008612
Condition: New-In-Box
-
SKU: KUPO-KG008912
Model: KG008912
Condition: New-In-Box
-
SKU: KUPO-KG009112
Model: KG009112
Condition: New-In-Box
-
SKU: KUPO-KG009312
Model: KG009312
Condition: New-In-Box
-
SKU: KUPO-KG009412
Model: KG009412
Condition: New-In-Box
-
SKU: KUPO-KG010011
Model: KG010011
Condition: New-In-Box
-
SKU: KUPO-KG010312
Model: KG010312
Condition: New-In-Box