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