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 (33099, 124267, 14991, 15236, 4059, 4061, 4062, 4063, 6076, 6077, 6078, 6079, 6080, 16183, 21232, 26059, 26060, 26061, 26062, 26063, 33101, 33104, 77944, 77945, 78532, 83790, 124257, 125073, 125074, 181982)) 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,33099,124267,14991,15236,4059,4061,4062,4063,6076,6077,6078,6079,6080,16183,21232,26059,26060,26061,26062,26063,33101,33104,77944,77945,78532,83790,124257,125073,125074,181982)
-
SKU: SEN-00017
Model: MZW2-EW
Condition: New-In-Box
-
SKU: SEN-00016
Model: 004839
Condition: New-In-Box
-
SKU: SEN-00012
Model: ME66/K6 COMBO
Condition: New-In-Box
-
SKU: SEN-00080
Model: 505453
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-00044
Model: 503300
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
-
SKU: SEN-00042V
Model: 503107
Condition: New-In-Box
-
SKU: SEN-00062
Model: 083387
Condition: New-In-Box
-
SKU: SEN-00134
Model: 503126
Condition: New-In-Box
-
SKU: SEN-00136
Model: 503538
Condition: New-In-Box
-
SKU: SEN-00063
Model: 506258
Condition: New-In-Box
-
SKU: SEN-00140
Model: SKP100G3-B
Condition: New-In-Box
-
SKU: SEN-00121
Model: MKH50-P48
Condition: New-In-Box
-
SKU: SEN-505861
Model: 505861
Condition: New-In-Box
-
SKU: SEN-506725
Model: 506725
Condition: New-In-Box
-
SKU: SEN-00064
Model: MKH 416-P48U3
Condition: New-In-Box