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 (6255, 6605, 6922, 6256, 6606, 6923, 6257, 6607, 6924, 6258, 6608, 6925, 4430, 5102, 4778, 4431, 4432, 4433, 5635, 4434, 5445, 4435, 4436, 5103, 4437, 5020, 4438, 5104, 4439, 3793, 6212, 3480, 3798, 5260, 3794, 6142, 3795, 3796, 3797, 6247, 5139, 5137, 5136, 5135, 5486, 5134, 5133, 3519, 3516, 3524, 3517, 3529, 3518, 3174, 3197, 3196, 6871, 6872, 6248, 6259, 6260, 6261, 6262, 5806, 6263, 5807, 5808, 6264, 5812, 5813, 5814, 5815, 5816, 5817, 5818, 5819, 5820, 7106, 3693, 3695, 3696, 3680, 3681, 3682, 3683, 3684, 3685, 5138, 3686, 3687, 3688, 5261, 3689, 3690, 3691, 6865, 3692, 3694, 5262, 3697, 3652, 3653, 3650, 3651, 3609, 3210, 3212, 3213, 3209, 6444, 6445, 6446, 6447, 6448, 6449, 6450, 3201, 6451, 7126, 7268, 7300, 5488, 5489, 5490, 5491, 5492, 5781, 5493, 5782, 5783, 1749, 1750, 1748, 1747, 1973, 1974, 1191, 1192, 1983, 1984, 1194, 4140, 1990, 1760, 1761, 1759, 1758, 1996, 2049, 1195, 4972, 3508, 1941, 1141, 1140, 2354, 1952, 1953, 1189, 1190, 5142, 1144, 1143, 4776, 2356, 1962, 1963, 1147, 1146, 1909, 2359, 2358, 1074, 1073, 1968, 1072, 1089, 1088, 1989, 1090, 7453, 3514, 2339, 2338, 3510, 2331, 2330, 3513, 2367, 2334, 2333, 3512, 2911, 3515, 2336, 2335, 4977, 4978, 4979, 6393, 4980, 4981, 6731, 6727, 4711, 4712, 4713, 4714, 4715, 3530, 4716, 4717, 3528, 4718, 4719, 4720, 4721, 3522, 4722, 6158, 6159, 6160, 7467, 7468, 7469, 7470, 7632, 7633, 6490, 6532, 4447, 4448, 4449, 4450, 6406, 6407, 6408, 6409, 6410, 6411, 6412, 6413, 6414, 6415, 7254, 7278, 7255, 7271, 7272, 7273, 1639, 6285, 7419, 6155, 6156, 7757, 5846, 5847, 5848, 5849, 7930, 5153, 5154, 5155, 5156, 8001, 7420, 6960, 6961, 7894, 8061, 8063, 8064, 8065, 8066, 8067, 8068, 6418, 6419, 6420, 6421, 6422, 6423, 6424, 6425, 6426, 6427, 6428, 6429, 6430, 5770, 6035, 6918, 5771, 6603, 6919, 5772, 6036, 6920, 6222, 6604, 6921, 6431, 6432, 6433, 8023, 8151, 8168, 7858, 7859, 7860, 7861, 7862, 7863, 7864, 7865, 7866)) 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 (6255, 6605, 6922, 6256, 6606, 6923, 6257, 6607, 6924, 6258, 6608, 6925, 4430, 5102, 4778, 4431, 4432, 4433, 5635, 4434, 5445, 4435, 4436, 5103, 4437, 5020, 4438, 5104, 4439, 3793, 6212, 3480, 3798, 5260, 3794, 6142, 3795, 3796, 3797, 6247, 5139, 5137, 5136, 5135, 5486, 5134, 5133, 3519, 3516, 3524, 3517, 3529, 3518, 3174, 3197, 3196, 6871, 6872, 6248, 6259, 6260, 6261, 6262, 5806, 6263, 5807, 5808, 6264, 5812, 5813, 5814, 5815, 5816, 5817, 5818, 5819, 5820, 7106, 3693, 3695, 3696, 3680, 3681, 3682, 3683, 3684, 3685, 5138, 3686, 3687, 3688, 5261, 3689, 3690, 3691, 6865, 3692, 3694, 5262, 3697, 3652, 3653, 3650, 3651, 3609, 3210, 3212, 3213, 3209, 6444, 6445, 6446, 6447, 6448, 6449, 6450, 3201, 6451, 7126, 7268, 7300, 5488, 5489, 5490, 5491, 5492, 5781, 5493, 5782, 5783, 1749, 1750, 1748, 1747, 1973, 1974, 1191, 1192, 1983, 1984, 1194, 4140, 1990, 1760, 1761, 1759, 1758, 1996, 2049, 1195, 4972, 3508, 1941, 1141, 1140, 2354, 1952, 1953, 1189, 1190, 5142, 1144, 1143, 4776, 2356, 1962, 1963, 1147, 1146, 1909, 2359, 2358, 1074, 1073, 1968, 1072, 1089, 1088, 1989, 1090, 7453, 3514, 2339, 2338, 3510, 2331, 2330, 3513, 2367, 2334, 2333, 3512, 2911, 3515, 2336, 2335, 4977, 4978, 4979, 6393, 4980, 4981, 6731, 6727, 4711, 4712, 4713, 4714, 4715, 3530, 4716, 4717, 3528, 4718, 4719, 4720, 4721, 3522, 4722, 6158, 6159, 6160, 7467, 7468, 7469, 7470, 7632, 7633, 6490, 6532, 4447, 4448, 4449, 4450, 6406, 6407, 6408, 6409, 6410, 6411, 6412, 6413, 6414, 6415, 7254, 7278, 7255, 7271, 7272, 7273, 1639, 6285, 7419, 6155, 6156, 7757, 5846, 5847, 5848, 5849, 7930, 5153, 5154, 5155, 5156, 8001, 7420, 6960, 6961, 7894, 8061, 8063, 8064, 8065, 8066, 8067, 8068, 6418, 6419, 6420, 6421, 6422, 6423, 6424, 6425, 6426, 6427, 6428, 6429, 6430, 5770, 6035, 6918, 5771, 6603, 6919, 5772, 6036, 6920, 6222, 6604, 6921, 6431, 6432, 6433, 8023, 8151, 8168, 7858, 7859, 7860, 7861, 7862, 7863, 7864, 7865, 7866)) 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 (6255, 6605, 6922, 6256, 6606, 6923, 6257, 6607, 6924, 6258, 6608, 6925, 4430, 5102, 4778, 4431, 4432, 4433, 5635, 4434, 5445, 4435, 4436, 5103, 4437, 5020, 4438, 5104, 4439, 3793, 6212, 3480, 3798, 5260, 3794, 6142, 3795, 3796, 3797, 6247, 5139, 5137, 5136, 5135, 5486, 5134, 5133, 3519, 3516, 3524, 3517, 3529, 3518, 3174, 3197, 3196, 6871, 6872, 6248, 6259, 6260, 6261, 6262, 5806, 6263, 5807, 5808, 6264, 5812, 5813, 5814, 5815, 5816, 5817, 5818, 5819, 5820, 7106, 3693, 3695, 3696, 3680, 3681, 3682, 3683, 3684, 3685, 5138, 3686, 3687, 3688, 5261, 3689, 3690, 3691, 6865, 3692, 3694, 5262, 3697, 3652, 3653, 3650, 3651, 3609, 3210, 3212, 3213, 3209, 6444, 6445, 6446, 6447, 6448, 6449, 6450, 3201, 6451, 7126, 7268, 7300, 5488, 5489, 5490, 5491, 5492, 5781, 5493, 5782, 5783, 1749, 1750, 1748, 1747, 1973, 1974, 1191, 1192, 1983, 1984, 1194, 4140, 1990, 1760, 1761, 1759, 1758, 1996, 2049, 1195, 4972, 3508, 1941, 1141, 1140, 2354, 1952, 1953, 1189, 1190, 5142, 1144, 1143, 4776, 2356, 1962, 1963, 1147, 1146, 1909, 2359, 2358, 1074, 1073, 1968, 1072, 1089, 1088, 1989, 1090, 7453, 3514, 2339, 2338, 3510, 2331, 2330, 3513, 2367, 2334, 2333, 3512, 2911, 3515, 2336, 2335, 4977, 4978, 4979, 6393, 4980, 4981, 6731, 6727, 4711, 4712, 4713, 4714, 4715, 3530, 4716, 4717, 3528, 4718, 4719, 4720, 4721, 3522, 4722, 6158, 6159, 6160, 7467, 7468, 7469, 7470, 7632, 7633, 6490, 6532, 4447, 4448, 4449, 4450, 6406, 6407, 6408, 6409, 6410, 6411, 6412, 6413, 6414, 6415, 7254, 7278, 7255, 7271, 7272, 7273, 1639, 6285, 7419, 6155, 6156, 7757, 5846, 5847, 5848, 5849, 7930, 5153, 5154, 5155, 5156, 8001, 7420, 6960, 6961, 7894, 8061, 8063, 8064, 8065, 8066, 8067, 8068, 6418, 6419, 6420, 6421, 6422, 6423, 6424, 6425, 6426, 6427, 6428, 6429, 6430, 5770, 6035, 6918, 5771, 6603, 6919, 5772, 6036, 6920, 6222, 6604, 6921, 6431, 6432, 6433, 8023, 8151, 8168, 7858, 7859, 7860, 7861, 7862, 7863, 7864, 7865, 7866)) 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 (6255, 6605, 6922, 6256, 6606, 6923, 6257, 6607, 6924, 6258, 6608, 6925, 4430, 5102, 4778, 4431, 4432, 4433, 5635, 4434, 5445, 4435, 4436, 5103, 4437, 5020, 4438, 5104, 4439, 3793, 6212, 3480, 3798, 5260, 3794, 6142, 3795, 3796, 3797, 6247, 5139, 5137, 5136, 5135, 5486, 5134, 5133, 3519, 3516, 3524, 3517, 3529, 3518, 3174, 3197, 3196, 6871, 6872, 6248, 6259, 6260, 6261, 6262, 5806, 6263, 5807, 5808, 6264, 5812, 5813, 5814, 5815, 5816, 5817, 5818, 5819, 5820, 7106, 3693, 3695, 3696, 3680, 3681, 3682, 3683, 3684, 3685, 5138, 3686, 3687, 3688, 5261, 3689, 3690, 3691, 6865, 3692, 3694, 5262, 3697, 3652, 3653, 3650, 3651, 3609, 3210, 3212, 3213, 3209, 6444, 6445, 6446, 6447, 6448, 6449, 6450, 3201, 6451, 7126, 7268, 7300, 5488, 5489, 5490, 5491, 5492, 5781, 5493, 5782, 5783, 1749, 1750, 1748, 1747, 1973, 1974, 1191, 1192, 1983, 1984, 1194, 4140, 1990, 1760, 1761, 1759, 1758, 1996, 2049, 1195, 4972, 3508, 1941, 1141, 1140, 2354, 1952, 1953, 1189, 1190, 5142, 1144, 1143, 4776, 2356, 1962, 1963, 1147, 1146, 1909, 2359, 2358, 1074, 1073, 1968, 1072, 1089, 1088, 1989, 1090, 7453, 3514, 2339, 2338, 3510, 2331, 2330, 3513, 2367, 2334, 2333, 3512, 2911, 3515, 2336, 2335, 4977, 4978, 4979, 6393, 4980, 4981, 6731, 6727, 4711, 4712, 4713, 4714, 4715, 3530, 4716, 4717, 3528, 4718, 4719, 4720, 4721, 3522, 4722, 6158, 6159, 6160, 7467, 7468, 7469, 7470, 7632, 7633, 6490, 6532, 4447, 4448, 4449, 4450, 6406, 6407, 6408, 6409, 6410, 6411, 6412, 6413, 6414, 6415, 7254, 7278, 7255, 7271, 7272, 7273, 1639, 6285, 7419, 6155, 6156, 7757, 5846, 5847, 5848, 5849, 7930, 5153, 5154, 5155, 5156, 8001, 7420, 6960, 6961, 7894, 8061, 8063, 8064, 8065, 8066, 8067, 8068, 6418, 6419, 6420, 6421, 6422, 6423, 6424, 6425, 6426, 6427, 6428, 6429, 6430, 5770, 6035, 6918, 5771, 6603, 6919, 5772, 6036, 6920, 6222, 6604, 6921, 6431, 6432, 6433, 8023, 8151, 8168, 7858, 7859, 7860, 7861, 7862, 7863, 7864, 7865, 7866)) 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 (6255, 6605, 6922, 6256, 6606, 6923, 6257, 6607, 6924, 6258, 6608, 6925, 4430, 5102, 4778, 4431, 4432, 4433, 5635, 4434, 5445, 4435, 4436, 5103, 4437, 5020, 4438, 5104, 4439, 3793, 6212, 3480, 3798, 5260, 3794, 6142, 3795, 3796, 3797, 6247, 5139, 5137, 5136, 5135, 5486, 5134, 5133, 3519, 3516, 3524, 3517, 3529, 3518, 3174, 3197, 3196, 6871, 6872, 6248, 6259, 6260, 6261, 6262, 5806, 6263, 5807, 5808, 6264, 5812, 5813, 5814, 5815, 5816, 5817, 5818, 5819, 5820, 7106, 3693, 3695, 3696, 3680, 3681, 3682, 3683, 3684, 3685, 5138, 3686, 3687, 3688, 5261, 3689, 3690, 3691, 6865, 3692, 3694, 5262, 3697, 3652, 3653, 3650, 3651, 3609, 3210, 3212, 3213, 3209, 6444, 6445, 6446, 6447, 6448, 6449, 6450, 3201, 6451, 7126, 7268, 7300, 5488, 5489, 5490, 5491, 5492, 5781, 5493, 5782, 5783, 1749, 1750, 1748, 1747, 1973, 1974, 1191, 1192, 1983, 1984, 1194, 4140, 1990, 1760, 1761, 1759, 1758, 1996, 2049, 1195, 4972, 3508, 1941, 1141, 1140, 2354, 1952, 1953, 1189, 1190, 5142, 1144, 1143, 4776, 2356, 1962, 1963, 1147, 1146, 1909, 2359, 2358, 1074, 1073, 1968, 1072, 1089, 1088, 1989, 1090, 7453, 3514, 2339, 2338, 3510, 2331, 2330, 3513, 2367, 2334, 2333, 3512, 2911, 3515, 2336, 2335, 4977, 4978, 4979, 6393, 4980, 4981, 6731, 6727, 4711, 4712, 4713, 4714, 4715, 3530, 4716, 4717, 3528, 4718, 4719, 4720, 4721, 3522, 4722, 6158, 6159, 6160, 7467, 7468, 7469, 7470, 7632, 7633, 6490, 6532, 4447, 4448, 4449, 4450, 6406, 6407, 6408, 6409, 6410, 6411, 6412, 6413, 6414, 6415, 7254, 7278, 7255, 7271, 7272, 7273, 1639, 6285, 7419, 6155, 6156, 7757, 5846, 5847, 5848, 5849, 7930, 5153, 5154, 5155, 5156, 8001, 7420, 6960, 6961, 7894, 8061, 8063, 8064, 8065, 8066, 8067, 8068, 6418, 6419, 6420, 6421, 6422, 6423, 6424, 6425, 6426, 6427, 6428, 6429, 6430, 5770, 6035, 6918, 5771, 6603, 6919, 5772, 6036, 6920, 6222, 6604, 6921, 6431, 6432, 6433, 8023, 8151, 8168, 7858, 7859, 7860, 7861, 7862, 7863, 7864, 7865, 7866)) 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