SQL> select * from history h left join build_state bs on bs.ID = h.BUILD_STATE_ID where h.BUILD_TYPE_ID = 'bt7';

BUILD_ID AGENT_NAME BUILD_TYPE_ID BUILD_START_TIME_SERVER BUILD_START_TIME_AGENT BUILD_FINISH_TIME_SERVER STATUS STATUS_TEXT PIN IS_PERSONAL IS_CANCELED BUILD_NUMBER REQUESTOR QUEUED_TIME REMOVE_FROM_QUEUE_TIME USER_STATUS_TEXT BUILD_STATE_ID ID BUILD_TYPE_ID MODIFICATION_ID IS_PERSONAL IS_CANCELED BUILD_ID
1206 Default agent bt7 1.2489E+12 1.2489E+12 1.2489E+12 4 Failure 0 0 0 webtest.72 ##vcsName='cvs' 1.2489E+12 1.2489E+12   1241 1241 bt7 1092 0 0 1206
1205 Default agent bt7 1.2481E+12 1.2481E+12 1.2481E+12 1 Success 0 0 0 webtest.71 ##userId='1' 1.2481E+12 1.2481E+12   1240 1240 bt7 1078 0 0 1205
1212 Default agent bt7 1.2489E+12 1.2489E+12 1.2489E+12 4 Failure 0 0 0 webtest.73 ##buildTypeId='bt2' 1.2489E+12 1.2489E+12   1247 1247 bt7 1092 0 0 1212
1213 Default agent bt7 1.2495E+12 1.2495E+12 1.2495E+12 1 Success 0 0 0 webtest.74 ##userId='2' 1.2495E+12 1.2495E+12   1248 1248 bt7 1094 0 0 1213
1222 Default agent bt7 1.2502E+12 1.2502E+12 1.2502E+12 1 Success 0 0 0 webtest.76 ##vcsName='cvs' 1.2502E+12 1.2502E+12   1259 1259 bt7 1096 0 0 1222
1232 Default agent bt7 1.2507E+12 1.2507E+12 1.2507E+12 4 Failure 0 0 0 webtest.78 ##vcsName='cvs' 1.2507E+12 1.2507E+12   1269 1269 bt7 1113 0 0 1232
1235 Default agent bt7 1.2507E+12 1.2507E+12 1.2507E+12 1 Success 0 0 0 webtest.79 ##buildTypeId='bt2' 1.2507E+12 1.2507E+12   1272 1272 bt7 1113 0 0 1235
1236 Default agent bt7 1.2507E+12 1.2507E+12 1.2507E+12 1 Success 0 0 0 webtest.80 ##userId='3' 1.2507E+12 1.2507E+12   1273 1273 bt7 1113 0 0 1236
1237 Default agent bt7 1.2507E+12 1.2507E+12 1.2507E+12 1 Success 0 0 0 webtest.81 ##userId='3' 1.2507E+12 1.2507E+12   1274 1274 bt7 1113 0 0 1237
1238 Default agent bt7 1.2508E+12 1.2508E+12 1.2508E+12 1 Success 0 0 0 webtest.82 ##userId='3' 1.2508E+12 1.2508E+12   1275 1275 bt7 1113 0 0 1238
1240 Default agent bt7 1.2518E+12 1.2518E+12 1.2518E+12 1 Success 0 0 0 webtest.83 ##buildTypeId='bt2' 1.2518E+12 1.2518E+12   1277 1277 bt7 1121 0 0 1240
1247 Default agent bt7 1.2518E+12 1.2518E+12 1.2518E+12 1 Success 0 0 0 webtest.84 ##vcsName='cvs' 1.2518E+12 1.2518E+12   1284 1284 bt7 1122 0 0 1247
1251 Default agent bt7 1.2518E+12 1.2518E+12 1.2518E+12 1 Success 0 0 0 webtest.85 ##buildTypeId='bt2' 1.2518E+12 1.2518E+12   1288 1288 bt7 1122 0 0 1251
1201 Default agent bt7 1.2478E+12 1.2478E+12 1.2478E+12 1 Success 0 0 0 webtest.70 ##userId='1' 1.2478E+12 1.2478E+12   1236 1236 bt7 -1 0 0 1201
BUILD_ID AGENT_NAME BUILD_TYPE_ID BUILD_START_TIME_SERVER BUILD_START_TIME_AGENT BUILD_FINISH_TIME_SERVER STATUS STATUS_TEXT PIN IS_PERSONAL IS_CANCELED BUILD_NUMBER REQUESTOR QUEUED_TIME REMOVE_FROM_QUEUE_TIME USER_STATUS_TEXT BUILD_STATE_ID ID BUILD_TYPE_ID MODIFICATION_ID IS_PERSONAL IS_CANCELED BUILD_ID
1221 Default agent bt7 1.2495E+12 1.2495E+12 1.2495E+12 1 Success 0 0 0 webtest.75 ##buildTypeId='bt2' 1.2495E+12 1.2495E+12   1258 1258 bt7 1094 0 0 1221
1228 Default agent bt7 1.2502E+12   1.2502E+12 4 Failure 0 0 0 webtest.77 ##buildTypeId='bt2' 1.2502E+12 1.2502E+12   1265 1265 bt7   0 0 1228
1257 Default agent bt7 1.2519E+12 1.2519E+12 1.2519E+12 1 Success 0 0 0 webtest.86 ##buildTypeId='bt2' 1.2519E+12 1.2519E+12   1295 1295 bt7 1125 0 0 1257
1258 Default agent bt7 1.2519E+12 1.2519E+12 1.2519E+12 1 Success 0 0 0 webtest.87 ##userId='3' 1.2519E+12 1.2519E+12   1296 1296 bt7 1125 0 0 1258
1259 Default agent bt7 1.2519E+12 1.2519E+12 1.2519E+12 1 Success 0 0 0 webtest.88 ##userId='3' 1.2519E+12 1.2519E+12   1297 1297 bt7 1125 0 0 1259
1266 Default agent bt7 1.2519E+12 1.2519E+12 1.2519E+12 1 Success 0 0 0 webtest.90 ##buildTypeId='bt2' 1.2519E+12 1.2519E+12   1304 1304 bt7 1127 0 0 1266
1265 Default agent bt7 1.2519E+12 1.2519E+12 1.2519E+12 1 Success 0 0 0 webtest.89 ##vcsName='cvs' 1.2519E+12 1.2519E+12   1303 1303 bt7 1127 0 0 1265

21 rows selected.