Supermicro 2U Hyper SuperServer (AS-2126HS-TN)
Systems, Hyper
SELECT `t_d`.`attribute_id`, `e`.`entity_id`, `t_d`.`value` AS `default_value`, `t_s`.`value` AS `store_value`, IF(t_s.value_id IS NULL, t_d.value, t_s.value) AS `value` FROM `catalog_product_entity_varchar` AS `t_d`
INNER JOIN `catalog_product_entity` AS `e` ON e.entity_id = t_d.entity_id
LEFT JOIN `catalog_product_entity_varchar` AS `t_s` ON t_s.attribute_id = t_d.attribute_id AND t_s.entity_id = t_d.entity_id AND t_s.store_id = 1 WHERE (e.entity_id IN (5250, 5251, 4636, 5046, 4637, 4879, 4638, 4639, 4640, 4642, 4643, 4893, 4645, 4646, 4648, 4649, 5252, 6934, 6935, 6833, 6947, 6948, 6936, 6834, 6937, 6949, 6938, 6950, 6835, 6836, 6837, 6838, 6951, 6839, 6952, 7075, 7076, 7078, 7079, 7077)) AND (t_d.attribute_id IN (71, 86, 87, 97, 112, 113, 114, 119, 263, 268, 269, 270, 271, 272, 275, 421)) AND (t_d.store_id = IFNULL(t_s.store_id, 0)) UNION ALL SELECT `t_d`.`attribute_id`, `e`.`entity_id`, `t_d`.`value` AS `default_value`, `t_s`.`value` AS `store_value`, IF(t_s.value_id IS NULL, t_d.value, t_s.value) AS `value` FROM `catalog_product_entity_text` AS `t_d`
INNER JOIN `catalog_product_entity` AS `e` ON e.entity_id = t_d.entity_id
LEFT JOIN `catalog_product_entity_text` AS `t_s` ON t_s.attribute_id = t_d.attribute_id AND t_s.entity_id = t_d.entity_id AND t_s.store_id = 1 WHERE (e.entity_id IN (5250, 5251, 4636, 5046, 4637, 4879, 4638, 4639, 4640, 4642, 4643, 4893, 4645, 4646, 4648, 4649, 5252, 6934, 6935, 6833, 6947, 6948, 6936, 6834, 6937, 6949, 6938, 6950, 6835, 6836, 6837, 6838, 6951, 6839, 6952, 7075, 7076, 7078, 7079, 7077)) AND (t_d.attribute_id IN (73, 382, 518)) AND (t_d.store_id = IFNULL(t_s.store_id, 0)) UNION ALL SELECT `t_d`.`attribute_id`, `e`.`entity_id`, `t_d`.`value` AS `default_value`, `t_s`.`value` AS `store_value`, IF(t_s.value_id IS NULL, t_d.value, t_s.value) AS `value` FROM `catalog_product_entity_decimal` AS `t_d`
INNER JOIN `catalog_product_entity` AS `e` ON e.entity_id = t_d.entity_id
LEFT JOIN `catalog_product_entity_decimal` AS `t_s` ON t_s.attribute_id = t_d.attribute_id AND t_s.entity_id = t_d.entity_id AND t_s.store_id = 0 WHERE (e.entity_id IN (5250, 5251, 4636, 5046, 4637, 4879, 4638, 4639, 4640, 4642, 4643, 4893, 4645, 4646, 4648, 4649, 5252, 6934, 6935, 6833, 6947, 6948, 6936, 6834, 6937, 6949, 6938, 6950, 6835, 6836, 6837, 6838, 6951, 6839, 6952, 7075, 7076, 7078, 7079, 7077)) AND (t_d.attribute_id IN (75, 76, 120, 520)) AND (t_d.store_id = IFNULL(t_s.store_id, 0)) UNION ALL SELECT `t_d`.`attribute_id`, `e`.`entity_id`, `t_d`.`value` AS `default_value`, `t_s`.`value` AS `store_value`, IF(t_s.value_id IS NULL, t_d.value, t_s.value) AS `value` FROM `catalog_product_entity_datetime` AS `t_d`
INNER JOIN `catalog_product_entity` AS `e` ON e.entity_id = t_d.entity_id
LEFT JOIN `catalog_product_entity_datetime` AS `t_s` ON t_s.attribute_id = t_d.attribute_id AND t_s.entity_id = t_d.entity_id AND t_s.store_id = 1 WHERE (e.entity_id IN (5250, 5251, 4636, 5046, 4637, 4879, 4638, 4639, 4640, 4642, 4643, 4893, 4645, 4646, 4648, 4649, 5252, 6934, 6935, 6833, 6947, 6948, 6936, 6834, 6937, 6949, 6938, 6950, 6835, 6836, 6837, 6838, 6951, 6839, 6952, 7075, 7076, 7078, 7079, 7077)) AND (t_d.attribute_id IN (77, 78, 93, 94)) AND (t_d.store_id = IFNULL(t_s.store_id, 0)) UNION ALL SELECT `t_d`.`attribute_id`, `e`.`entity_id`, `t_d`.`value` AS `default_value`, `t_s`.`value` AS `store_value`, IF(t_s.value_id IS NULL, t_d.value, t_s.value) AS `value` FROM `catalog_product_entity_int` AS `t_d`
INNER JOIN `catalog_product_entity` AS `e` ON e.entity_id = t_d.entity_id
LEFT JOIN `catalog_product_entity_int` AS `t_s` ON t_s.attribute_id = t_d.attribute_id AND t_s.entity_id = t_d.entity_id AND t_s.store_id = 1 WHERE (e.entity_id IN (5250, 5251, 4636, 5046, 4637, 4879, 4638, 4639, 4640, 4642, 4643, 4893, 4645, 4646, 4648, 4649, 5252, 6934, 6935, 6833, 6947, 6948, 6936, 6834, 6937, 6949, 6938, 6950, 6835, 6836, 6837, 6838, 6951, 6839, 6952, 7075, 7076, 7078, 7079, 7077)) AND (t_d.attribute_id IN (96, 121, 123, 125, 126, 127, 128, 131, 246, 264, 265, 266, 267, 277, 278, 279, 289, 295, 296, 297, 300, 395, 396, 429, 475, 517)) AND (t_d.store_id = IFNULL(t_s.store_id, 0))Price not available
Orders Over $200 
Duties & Taxes Due to Shipping Provider Prior to Delivery
