+ (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
+ 30,
+ (SELECT player FROM players WHERE nick='x3mnrj'),
+ 26);
+INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Tha Dragon' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Tha Dragon' NOT IN ( SELECT nick FROM players );