goal date venue opponent score result competition
goal
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 october 1998 tyencastle park, edinburgh estonia 1-1 3-2 ecqg9
what game was played before the one against faroe islands ?
WDT NN VBD-AUX VBN IN DT CD IN NNP NNPS .
Estonia
Keyword Column Keyword Keyword Keyword Column Keyword Keyword Keyword Column Keyword Keyword Keyword Column Keyword Literal.String Keyword Keyword Keyword Column Keyword Keyword Literal.Number
select c4 from w where c2_parsed < ( select c2_parsed from w where c4 = 'faroe islands' ) order by c2_parsed desc limit 1
None None None None Column Column Column Column Literal Literal None
c2_parsed c2_parsed c2_parsed c4