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 (15236, 33099, 124267, 4059, 4061, 4062, 4063, 6076, 6077, 6078, 6079, 6080, 14991, 387615, 445535, 445536, 445539, 249595, 202519, 206484, 206485, 206486, 214292, 216513, 21232, 26059, 26060, 26061, 26062, 26063)) 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,15236,33099,124267,4059,4061,4062,4063,6076,6077,6078,6079,6080,14991,387615,445535,445536,445539,249595,202519,206484,206485,206486,214292,216513,21232,26059,26060,26061,26062,26063)
-
SKU: SEN-00080
Model: 505453
Condition: New-In-Box
-
SKU: SEN-00017
Model: MZW2-EW
Condition: New-In-Box
-
SKU: SEN-00016
Model: 004839
Condition: New-In-Box
-
SKU: SEN-00011N
Model: ME64/K6 Combo
Condition: New-In-Box
-
SKU: SEN-00037
Model: USHMD280-XQ
Condition: New-In-Box
-
SKU: SEN-00045
Model: Unavailable
Condition: New-In-Box
-
SKU: SEN-00060
Model: MKE400
Condition: New-In-Box
-
SKU: SEN-00011G
Model: Unavailable
Condition: New-In-Box
-
SKU: SEN-00015
Model: Unavailable
Condition: New-In-Box
-
SKU: SEN-00024N
Model: 003283
Condition: New-In-Box
-
SKU: SEN-00032
Model: MZW400
Condition: New-In-Box
-
SKU: SEN-00035
Model: HD280Pro
Condition: New-In-Box
-
SKU: SEN-00012
Model: ME66/K6 COMBO
Condition: New-In-Box
-
SKU: SEN-509636
Model: 509636
Condition: New-In-Box
-
SKU: SEN-507953
Model: 509506
Condition: New-In-Box
-
SKU: SEN-508002
Model: 509757
Condition: New-In-Box
-
SKU: SEN-502575
Model: 502575
Condition: New-In-Box
-
SKU: SEN-00028
Model: EW 512P G4-AW+
Condition: New-In-Box
-
SKU: SEN-505862
Model: 505862
Condition: New-In-Box
-
SKU: SEN-00018
Model: 005172
Condition: New-In-Box
-
SKU: SEN-00026
Model: 005213
Condition: New-In-Box
-
SKU: SEN-00026A
Model: ME 2-II
Condition: New-In-Box
-
SKU: SEN-00021
Model: MD421 II
Condition: New-In-Box
-
SKU: SEN-507956
Model: 507956
Condition: New-In-Box
-
SKU: SEN-00008
Model: 005022
Condition: New-In-Box
-
SKU: SEN-00105
Model: 502717
Condition: New-In-Box
-
SKU: SEN-00114
Model: 503140
Condition: New-In-Box
-
SKU: SEN-00124
Model: 504240
Condition: New-In-Box
-
SKU: SEN-00132
Model: 502320
Condition: New-In-Box
-
SKU: SEN-00112
Model: 503125
Condition: New-In-Box