# date venue opponent score result competition
#
date
venue
opponent
score
result
competition
number
number parsed year month day
address
number number1 number2
number number1 number2
number date address text score score text
1 10 january 1996 edison international field, anaheim, united states honduras 1-0 3-1 1996 concacaf gold cup
where was the last venue before the opponent colombia ?
WRB VBD-AUX DT JJ NN IN DT NN NNP .
Qualcomm Stadium, San Diego, United States
Keyword Column Keyword Keyword Keyword Column Keyword Keyword Keyword Column Keyword Keyword Keyword Column Keyword Literal.String Keyword Keyword Keyword Column Keyword Keyword Keyword
select c3 from w where c2_parsed < ( select c2_parsed from w where c4 = 'colombia' ) order by c2_parsed desc limit 1
None None Column Column Column Column None Column Literal None
c2_parsed c2_parsed c3 c2_parsed c4