(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 );
+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 );
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
1, 1,
- (SELECT player FROM players WHERE nick='Pål Andre'),
+ (SELECT player FROM players WHERE nick='Pål Andre'),
2
);
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='Pål Andre'),
+ (SELECT player FROM players WHERE nick='Pål Andre'),
0,
(SELECT song FROM songs WHERE lower(title)=lower('B4U (B4 Za Beat Mix)')),
'f',
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='Pål Andre'),
+ (SELECT player FROM players WHERE nick='Pål Andre'),
1,
(SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love')),
'f',
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='Pål Andre'),
+ (SELECT player FROM players WHERE nick='Pål Andre'),
2,
(SELECT song FROM songs WHERE lower(title)=lower('Dead End')),
't',