# 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 27 march 1977 rico perez, alicante, spain hungary 1-1 1-1 friendly
who was the opponent before mexico ?
WP VBD-AUX DT NN IN NNP .
France
select c4 from w where c2_parsed < ( select c2_parsed from w where c4 = 'mexico' ) order by c2_parsed desc limit 1