root@db1115.eqiad.wmnet[zarcillo]> select name, `group`, section FROM instances LEFT JOIN section_instances on instances.name = section_instances.instance; +---------------------+-------------+-----------------+ | name | group | section | +---------------------+-------------+-----------------+ | db1074 | core | s2 | | db1075 | core | s3 | | db1076 | core | s2 | | db1077 | test | test-s4 | | db1078 | core | s3 | | db1079 | core | s7 | | db1080 | core | s1 | | db1081 | core | s4 | | db1082 | core | s5 | | db1083 | core | s1 | | db1084 | core | s4 | | db1085 | core | s6 | | db1086 | core | s7 | | db1087 | core | s8 | | db1088 | core | s6 | | db1089 | core | s1 | | db1090:3312 | core | s2 | | db1090:3317 | core | s7 | | db1091 | core | s4 | | db1092 | core | s8 | | db1093 | core | s6 | | db1094 | core | s7 | | db1095:3313 | dbstore | s3 | | db1096:3315 | core | s5 | | db1096:3316 | core | s6 | | db1097:3314 | core | s4 | | db1097:3315 | core | s5 | | db1098:3316 | core | s6 | | db1098:3317 | core | s7 | | db1099:3311 | core | s1 | | db1099:3318 | core | s8 | | db1100 | core | s5 | | db1101:3317 | core | s7 | | db1101:3318 | core | s8 | | db1102:3314 | dbstore | s4 | | db1102:3315 | dbstore | s5 | | db1103:3312 | core | s2 | | db1103:3314 | core | s4 | | db1104 | core | s8 | | db1105:3311 | core | s1 | | db1105:3312 | core | s2 | | db1106 | core | s1 | | db1107 | core | s1 | | db1108 | misc | m4 | | db1109 | core | s8 | | db1110 | core | s5 | | db1111 | core | s8 | | db1112 | core | s3 | | db1113:3315 | core | s5 | | db1113:3316 | core | s6 | | db1114 | test | test-s1 | | db1115 | misc | tendril | | db1116:3317 | dbstore | s7 | | db1116:3318 | dbstore | s8 | | db1117:3321 | misc | m1 | | db1117:3322 | misc | m2 | | db1117:3323 | misc | m3 | | db1117:3325 | misc | m5 | | db1118 | core | s1 | | db1119 | core | s1 | | db1120 | core | x1 | | db1121 | core | s4 | | db1122 | core | s2 | | db1123 | core | s3 | | db1124:3311 | labsdb | s1 | | db1124:3313 | labsdb | s3 | | db1124:3315 | labsdb | s5 | | db1124:3318 | labsdb | s8 | | db1125:3312 | labsdb | s2 | | db1125:3314 | labsdb | s4 | | db1125:3316 | labsdb | s6 | | db1125:3317 | labsdb | s7 | | db1126 | core | s8 | | db1127 | core | x1 | | db1128 | misc | m3 | | db1129 | core | s2 | | db1130 | core | s5 | | db1131 | core | s6 | | db1132 | misc | m2 | | db1133 | misc | m5 | | db1134 | core | s1 | | db1135 | misc | m1 | | db1136 | core | s7 | | db1137 | core | x1 | | db1138 | core | s4 | | db1139:3311 | dbstore | s1 | | db1139:3316 | dbstore | s6 | | db1140:3312 | dbstore | s2 | | db1140:3320 | dbstore | x1 | | db2071 | core | s1 | | db2072 | core | s1 | | db2073 | core | s4 | | db2074 | core | s3 | | db2075 | core | s5 | | db2076 | core | s6 | | db2077 | core | s7 | | db2078:3321 | misc | m1 | | db2078:3322 | misc | m2 | | db2078:3323 | misc | m3 | | db2078:3325 | misc | m5 | | db2079 | core | s8 | | db2080 | core | s8 | | db2081 | core | s8 | | db2082 | core | s8 | | db2083 | core | s8 | | db2084:3314 | core | s4 | | db2084:3315 | core | s5 | | db2085:3311 | core | s1 | | db2085:3318 | core | s8 | | db2086:3317 | core | s7 | | db2086:3318 | core | s8 | | db2087:3316 | core | s6 | | db2087:3317 | core | s7 | | db2088:3311 | core | s1 | | db2088:3312 | core | s2 | | db2089:3315 | core | s5 | | db2089:3316 | core | s6 | | db2090 | core | s4 | | db2091:3312 | core | s2 | | db2091:3314 | core | s4 | | db2092 | core | s1 | | db2093 | misc | tendril | | db2094:3311 | labsdb | s1 | | db2094:3313 | labsdb | s3 | | db2094:3315 | labsdb | s5 | | db2094:3318 | labsdb | s8 | | db2095:3312 | labsdb | s2 | | db2095:3314 | labsdb | s4 | | db2095:3316 | labsdb | s6 | | db2095:3317 | labsdb | s7 | | db2096 | core | x1 | | db2097:3311 | dbstore | s1 | | db2097:3316 | dbstore | s6 | | db2098:3312 | dbstore | s2 | | db2098:3313 | dbstore | s3 | | db2099:3314 | dbstore | s4 | | db2099:3315 | dbstore | s5 | | db2100:3317 | dbstore | s7 | | db2100:3318 | dbstore | s8 | | db2101:3320 | dbstore | x1 | | db2102 | test | test-s1 | | db2103 | core | s1 | | db2104 | core | s2 | | db2105 | core | s3 | | db2106 | core | s4 | | db2107 | core | s2 | | db2108 | core | s2 | | db2109 | core | s3 | | db2110 | core | s4 | | db2111 | core | s5 | | db2112 | core | s1 | | db2113 | core | s5 | | db2114 | core | s6 | | db2115 | core | x1 | | db2116 | core | s1 | | db2117 | core | s6 | | db2118 | core | s7 | | db2119 | core | s4 | | db2120 | core | s7 | | db2121 | core | s7 | | db2122 | core | s7 | | db2123 | core | s5 | | db2124 | core | s6 | | db2125 | core | s2 | | db2126 | core | s2 | | db2127 | core | s3 | | db2128 | core | s5 | | db2129 | core | s6 | | db2130 | core | s1 | | db2131 | core | x1 | | db2132 | core | m1 | | db2133 | core | m2 | | db2134 | core | m3 | | db2135 | core | m5 | | dbstore1003:3311 | dbstore | s1 | | dbstore1003:3315 | dbstore | s5 | | dbstore1003:3317 | dbstore | s7 | | dbstore1004:3312 | dbstore | s2 | | dbstore1004:3313 | dbstore | s3 | | dbstore1004:3314 | dbstore | s4 | | dbstore1005:3316 | dbstore | s6 | | dbstore1005:3318 | dbstore | s8 | | dbstore1005:3320 | dbstore | x1 | | dbstore1005:3350 | dbstore | staging | | es1011 | core | es2 | | es1012 | core | es1 | | es1013 | core | es2 | | es1014 | core | es3 | | es1015 | core | es2 | | es1016 | core | es1 | | es1017 | core | es3 | | es1018 | core | es1 | | es1019 | core | es3 | | es1020 | core | es4 | | es1021 | core | es4 | | es1022 | core | es4 | | es1023 | core | es5 | | es1024 | core | es5 | | es1025 | core | es5 | | es2011 | core | es1 | | es2012 | core | es1 | | es2013 | core | es1 | | es2014 | core | es2 | | es2015 | core | es2 | | es2016 | core | es2 | | es2017 | core | es3 | | es2018 | core | es3 | | es2019 | core | es3 | | es2020 | core | es4 | | es2021 | core | es4 | | es2022 | core | es4 | | es2023 | core | es5 | | es2024 | core | es5 | | es2025 | core | es5 | | labsdb1009 | labsdb | s1 | | labsdb1009 | labsdb | s2 | | labsdb1009 | labsdb | s3 | | labsdb1009 | labsdb | s4 | | labsdb1009 | labsdb | s5 | | labsdb1009 | labsdb | s6 | | labsdb1009 | labsdb | s7 | | labsdb1009 | labsdb | s8 | | labsdb1010 | labsdb | s1 | | labsdb1010 | labsdb | s2 | | labsdb1010 | labsdb | s3 | | labsdb1010 | labsdb | s4 | | labsdb1010 | labsdb | s5 | | labsdb1010 | labsdb | s6 | | labsdb1010 | labsdb | s7 | | labsdb1010 | labsdb | s8 | | labsdb1011 | labsdb | s1 | | labsdb1011 | labsdb | s2 | | labsdb1011 | labsdb | s3 | | labsdb1011 | labsdb | s4 | | labsdb1011 | labsdb | s5 | | labsdb1011 | labsdb | s6 | | labsdb1011 | labsdb | s7 | | labsdb1011 | labsdb | s8 | | labsdb1012 | labsdb | s1 | | labsdb1012 | labsdb | s2 | | labsdb1012 | labsdb | s3 | | labsdb1012 | labsdb | s4 | | labsdb1012 | labsdb | s5 | | labsdb1012 | labsdb | s6 | | labsdb1012 | labsdb | s7 | | labsdb1012 | labsdb | s8 | | labservices1001 | labsdb | labservices | | labservices1002 | labsdb | labservices | | labtestservices2001 | labsdb | labtestservices | | pc1007 | parsercache | pc1 | | pc1008 | parsercache | pc2 | | pc1009 | parsercache | pc3 | | pc1010 | parsercache | pc1 | | pc2007 | parsercache | pc1 | | pc2008 | parsercache | pc2 | | pc2009 | parsercache | pc3 | | pc2010 | parsercache | pc1 | +---------------------+-------------+-----------------+ 257 rows in set (0.00 sec)