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 (484187, 328012, 365296, 248801, 257622, 257624, 262838, 294825, 294826, 294827, 294828, 294854, 297347, 320593, 200390, 202144, 202494, 202495, 202496, 202584, 202585, 203248, 203249, 203427, 203428, 203429, 18360, 147384, 155404, 170379)) 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,484187,328012,365296,248801,257622,257624,262838,294825,294826,294827,294828,294854,297347,320593,200390,202144,202494,202495,202496,202584,202585,203248,203249,203427,203428,203429,18360,147384,155404,170379)
-
Sizes: 4TB, 8TB, 16TB
SKU: LAC-2BIG RAID
Model: STHJ4000800, STHJ8000800, STHJ16000800
Condition: New-In-Box
-
SKU: LAC-STHA14000800
Model: STHA14000800
Condition: New-In-Box
-
SKU: LAC-STHA8000800
Model: STHA8000800
Condition: New-In-Box
-
SKU: LAC-STHG4000400
Model: STHG4000400
Condition: New-In-Box
-
SKU: LAC-STHK500800
Model: STHK500800
Condition: New-In-Box
-
SKU: LAC-STHT8000800
Model: STHT8000800
Condition: New-In-Box
-
SKU: LAC-STHG5000400
Model: STHG5000400
Condition: New-In-Box
-
SKU: LAC-STHR1000800
Model: STHR1000800
Condition: New-In-Box
-
SKU: LAC-STHR500800
Model: STHR500800
Condition: New-In-Box
-
SKU: LAC-STHZ1000800
Model: STHZ1000800
Condition: New-In-Box
-
SKU: LAC-STHZ2000800
Model: STHZ2000800
Condition: New-In-Box
-
SKU: LAC-STHR2000800
Model: STHR2000800
Condition: New-In-Box
-
SKU: LAC-STHG2000400
Model: STHG2000400
Condition: New-In-Box
-
SKU: LAC-STGB32000400
Model: STGB32000400
Condition: New-In-Box
-
SKU: LAC-STFR1000800
Model: STFR1000800
Condition: New-In-Box
-
SKU: LAC-STGU2000400
Model: STGU2000400
Condition: New-In-Box
-
SKU: LAC-STFR2000403
Model: STFR2000403
Condition: New-In-Box
-
SKU: LAC-STFR5000800
Model: STFR5000800
Condition: New-In-Box
-
SKU: LAC-STGB8000400
Model: STGB8000400
Condition: New-In-Box
-
SKU: LAC-STGB16000400
Model: STGB16000400
Condition: New-In-Box
-
SKU: LAC-STGB20000400
Model: STGB20000400
Condition: New-In-Box
-
SKU: LAC-STHA10000800
Model: STHA10000800
Condition: New-In-Box
-
SKU: LAC-STHA4000800
Model: STHA4000800
Condition: New-In-Box
-
SKU: LAC-STFJ120000400
Model: STFJ120000400
Condition: New-In-Box
-
SKU: LAC-STFJ48000400
Model: STFJ48000400
Condition: New-In-Box
-
SKU: LAC-STFJ72000400
Model: STFJ72000400
Condition: New-In-Box
-
SKU: LAC-9000298-CP
Model: 9000298
Condition: New-In-Box
-
SKU: LAC-STFR4000800
Model: STFR4000800
Condition: New-In-Box
-
SKU: LAC-STFJ96000400
Model: STFJ96000400
Condition: New-In-Box
-
SKU: LAC-STFR2000800
Model: STFR2000800
Condition: New-In-Box