+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+ (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
+ 1, 5,
+ (SELECT player FROM players WHERE nick='Electus'),
+ 2,
+ (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love (SPEED MIX)')),
+ 't',
+ 7992);