opponent goals wins draws losses +- goals matches qualified eliminated
opponent
goals
wins
draws
losses
+ - goals
matches
qualified
eliminated
number number1 number2
number
number
number
number
number
number
number
text score number number number number number number number
partizani tirane 28-25 13 7 8 + 3 28 9 7
which is before ks tomori
WDT VBD-AUX IN NN NN
KS Skenderbeu Korce
select c1 from w where id = ( select id from w where c1 = 'ks tomori' ) - 1