+INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Lawrence' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Lawrence' NOT IN ( SELECT nick FROM players );
+INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
+ (SELECT tournament FROM tournaments WHERE tournamentname='DDRUK vs. DDRNO' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
+ 1,
+ (SELECT player FROM players WHERE nick='Lawrence'),
+ NULL);
+INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Stelisevil' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Stelisevil' NOT IN ( SELECT nick FROM players );
+INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
+ (SELECT tournament FROM tournaments WHERE tournamentname='DDRUK vs. DDRNO' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
+ 1,
+ (SELECT player FROM players WHERE nick='Stelisevil'),
+ NULL);
+INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Usagi' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Usagi' NOT IN ( SELECT nick FROM players );
+INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
+ (SELECT tournament FROM tournaments WHERE tournamentname='DDRUK vs. DDRNO' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
+ 1,
+ (SELECT player FROM players WHERE nick='Usagi'),
+ NULL);
+INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Neomancer' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Neomancer' NOT IN ( SELECT nick FROM players );
+INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
+ (SELECT tournament FROM tournaments WHERE tournamentname='DDRUK vs. DDRNO' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
+ 1,
+ (SELECT player FROM players WHERE nick='Neomancer'),
+ NULL);
+INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Ryosuke' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Ryosuke' NOT IN ( SELECT nick FROM players );
+INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
+ (SELECT tournament FROM tournaments WHERE tournamentname='DDRUK vs. DDRNO' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
+ 1,
+ (SELECT player FROM players WHERE nick='Ryosuke'),
+ NULL);
+INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Afronova' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Afronova' NOT IN ( SELECT nick FROM players );
+INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
+ (SELECT tournament FROM tournaments WHERE tournamentname='DDRUK vs. DDRNO' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
+ 1,
+ (SELECT player FROM players WHERE nick='Afronova'),
+ NULL);
+INSERT INTO players SELECT nextval('players_player_seq') AS player, 'ChocoboGhost' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'ChocoboGhost' NOT IN ( SELECT nick FROM players );
+INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
+ (SELECT tournament FROM tournaments WHERE tournamentname='DDRUK vs. DDRNO' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
+ 1,
+ (SELECT player FROM players WHERE nick='ChocoboGhost'),
+ NULL);
+INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Sensei' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Sensei' NOT IN ( SELECT nick FROM players );
+INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
+ (SELECT tournament FROM tournaments WHERE tournamentname='DDRUK vs. DDRNO' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
+ 1,
+ (SELECT player FROM players WHERE nick='Sensei'),
+ NULL);
+INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Healingvizion' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Healingvizion' NOT IN ( SELECT nick FROM players );
+INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
+ (SELECT tournament FROM tournaments WHERE tournamentname='DDRUK vs. DDRNO' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
+ 1,
+ (SELECT player FROM players WHERE nick='Healingvizion'),
+ NULL);
+INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Nanaki Lioness' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Nanaki Lioness' NOT IN ( SELECT nick FROM players );
+INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
+ (SELECT tournament FROM tournaments WHERE tournamentname='DDRUK vs. DDRNO' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
+ 1,
+ (SELECT player FROM players WHERE nick='Nanaki Lioness'),
+ NULL);