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 (14032, 14033, 14034, 14035, 14036, 14037, 14038, 14039, 14040, 14041, 14042, 14043, 14044, 14045, 14046, 14047, 14048, 14049, 14050, 14051, 14052, 14053, 14056, 14057, 14061, 15309)) 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,14032,14033,14034,14035,14036,14037,14038,14039,14040,14041,14042,14043,14044,14045,14046,14047,14048,14049,14050,14051,14052,14053,14056,14057,14061,15309)
-
SKU: STA-00110
Model: INS-26S
Condition: New-In-Box
-
SKU: STA-00120
Model: XLR-26S
Condition: New-In-Box
-
SKU: STA-00130
Model: XLR-26D
Condition: New-In-Box
-
SKU: STA-00210
Model: XLR-60S
Condition: New-In-Box
-
SKU: STA-00220
Model: XLR-60D
Condition: New-In-Box
-
SKU: STA-00310
Model: SPK-40SP
Condition: New-In-Box
-
SKU: STA-00320
Model: SPK-40QI
Condition: New-In-Box
-
SKU: STA-00330
Model: SPK-58SP
Condition: New-In-Box
-
SKU: STA-00340
Model: SPK-58QI
Condition: New-In-Box
-
SKU: STA-00410
Model: CAT6-20-S
Condition: New-In-Box
-
SKU: STA-00510
Model: SCW-125
Condition: New-In-Box
-
SKU: STA-00520
Model: GTR-CA-2X
Condition: New-In-Box
-
SKU: STA-00610
Model: MIC-12-CB
Condition: New-In-Box
-
SKU: STA-00620
Model: MIC-12-MB
Condition: New-In-Box
-
SKU: STA-00710
Model: CAM-12-CB
Condition: New-In-Box
-
SKU: STA-00720
Model: CAM-12-MB
Condition: New-In-Box
-
SKU: STA-00810
Model: MIN-9-CB
Condition: New-In-Box
-
SKU: STA-00820
Model: MAG-9-CB
Condition: New-In-Box
-
SKU: STA-00830
Model: MAG-9-MB
Condition: New-In-Box
-
SKU: STA-00910
Model: SSA-KIT
Condition: New-In-Box
-
SKU: STA-01010
Model: MXC-25-12
Condition: New-In-Box
-
SKU: STA-01020
Model: MXC-50-12
Condition: New-In-Box
-
SKU: STA-01110
Model: STX-40-3
Condition: New-In-Box
-
SKU: STA-01120
Model: STX-50-3
Condition: New-In-Box
-
SKU: STA-00920
Model: GNK-12-MIC
Condition: New-In-Box
-
SKU: STA-00420
Model: USB-20-S
Condition: New-In-Box