UPDATE rounds SET chosensongs=1 WHERE
tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4') AND
round=1;
-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 4'),
1, 1,
- (SELECT player FROM players WHERE nick='Pål Andre'),
+ (SELECT player FROM players WHERE nick='Pål Andre'),
1
);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'),
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('Nori Nori Nori')),
'f',
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'),
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('PARANOiA Rebirth')),
'f',
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'),
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('Paranoia KCET (Clean Mix)')),
't',