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
lesnar beat herring in ufc 87 , in what event was his previous win ?
NNP VBD NNP IN NNP CD , IN WP NN VBD-AUX PRP$ JJ VB .
Dynamite!! USA
Keyword Column Keyword Keyword Keyword Column Keyword Literal.String Keyword Column Keyword Keyword Keyword Column Keyword Keyword Keyword Column Keyword Literal.String Keyword Keyword Keyword Column Keyword Keyword Keyword
select c5 from w where c1 = 'win' and c6_parsed < ( select c6_parsed from w where c5 = 'ufc 87' ) order by c6_parsed desc limit 1
None None None None Literal Literal None None None Column None None Column Column None
c5 c6_parsed c1