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 12 august 1998 asim ferhatovic hase stadium, sarajevo faroe islands 1–0 1–0 uefa euro 2000 qualifying
before the match against germany , who was the previous friendly match against ?
IN DT NN IN NNP , WP VBD-AUX DT JJ JJ NN IN .
Malta
select c4 from w where c7 = 'friendly match' and c2_parsed < ( select c2_parsed from w where c4 = 'germany' ) order by c2_parsed desc limit 1