+INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+ (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'),
+ 6, 0,
+ (SELECT player FROM players WHERE nick='Snofox'),
+ (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love (SPEED MIX)')),
+ 't',
+ 8658);