res. record opponent method event date round time location notes
res .
record
opponent
method
event
date
round
time
location
notes
result
number number1 number2
first second
number parsed year month day
number
number min sec
address
score score text text(text) text date number time address text
loss 5-3 alistair overeem tko (kick to the body & punches) ufc 141 december 30, 2011 1 2:26 las vegas, united states announced retirement after fight
which event comes before dynamite !! usa ?
WDT NN VBZ IN NN NN NNP .
UFC 81
select c5 from w where id = ( select id from w where c5 = 'dynamite!! usa' ) - 1