+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+ (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
+ 1, 1,
+ (SELECT player FROM players WHERE nick='Ted Kristian'),
+ 2,
+ (SELECT song FROM songs WHERE lower(title)=lower('Crash!')),
+ 't',
+ 7032);
+INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Pål Andre' AS nick WHERE 'Pål Andre' NOT IN ( SELECT nick FROM players );