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 (16710, 14774, 12276, 7300, 8900, 9637, 9638, 9640, 200, 202, 18421, 19163, 21179, 21180, 21989, 37638, 72863, 72884, 72885, 72888, 132618, 132630, 119991, 120049, 120050, 120051)) 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,16710,14774,12276,7300,8900,9637,9638,9640,200,202,18421,19163,21179,21180,21989,37638,72863,72884,72885,72888,132618,132630,119991,120049,120050,120051)
-
SKU: AZD-00500
Model: BC-27H
Condition: New-In-Box
-
SKU: AZD-00053
Model: SMX-5
Condition: New-In-Box
-
SKU: AZD-00013C
Model: 330LH
Condition: New-In-Box
-
SKU: AZD-00013E
Model: 330ULT
Condition: New-In-Box
-
SKU: AZD-00030
Model: EX-503
Condition: New-In-Box
-
SKU: AZD-00023
Model: SGM-1X
Condition: New-In-Box
-
SKU: AZD-00040
Model: WMSPRO
Condition: New-In-Box
-
SKU: AZD-00060
Model: SWS-200
Condition: New-In-Box
-
SKU: AZD-00032
Model: 31HT
Condition: New-In-Box
-
SKU: AZD-00055
Model: SMX-10
Condition: New-In-Box
-
SKU: AZD-00004
Model: WLX-PRO+i
Condition: New-In-Box
-
SKU: AZD-00031
Model: EX-503I
Condition: New-In-Box
-
SKU: AZD-00029
Model: SGM-990+I
Condition: New-In-Box
-
SKU: AZD-00080
Model: HX-MI
Condition: New-In-Box
-
SKU: AZD-00068
Model: WMS-PRO+I
Condition: New-In-Box
-
SKU: AZD-00072
Model: WDL-PRO
Condition: New-In-Box
-
SKU: AZD-00021
Model: SGM-250
Condition: New-In-Box
-
SKU: AZD-00057
Model: SMX-15
Condition: New-In-Box
-
SKU: AZD-00058
Model: SMX-30
Condition: New-In-Box
-
SKU: AZD-00078
Model: PRO-XD
Condition: New-In-Box
-
SKU: AZQ-00059
Model: SMX-20
Condition: New-In-Box
-
SKU: AZD-00065
Model: WS-SLR
Condition: New-In-Box
-
SKU: AZD-00059
Model: SWS-100
Condition: New-In-Box
-
SKU: AZD-00001
Model: SWS-30
Condition: New-In-Box
-
SKU: AZD-00005
Model: EX-507XD
Condition: New-In-Box
-
SKU: AZD-00029A
Model: SGM-990
Condition: New-In-Box