2 INSERT INTO tournaments
3 (season, tournamentname, country, location, "date", machine, scoringsystem) VALUES (
4 (SELECT season FROM seasons WHERE seasonname='Frittstående' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
6 (SELECT country FROM countries WHERE countryname='Norway'),
9 (SELECT machine FROM machines WHERE machinename='Dancing Stage EuroMix 2'),
10 (SELECT scoringsystem FROM scoringsystems WHERE scoringsystemname='10K Machine score')
12 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Sesse' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Sesse' NOT IN ( SELECT nick FROM players );
13 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
14 (SELECT tournament FROM tournaments WHERE tournamentname='Trondheimsturnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
16 (SELECT player FROM players WHERE nick='Sesse'),
18 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Dashiva' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Dashiva' NOT IN ( SELECT nick FROM players );
19 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
20 (SELECT tournament FROM tournaments WHERE tournamentname='Trondheimsturnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
22 (SELECT player FROM players WHERE nick='Dashiva'),
24 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'wa-ho' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'wa-ho' NOT IN ( SELECT nick FROM players );
25 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
26 (SELECT tournament FROM tournaments WHERE tournamentname='Trondheimsturnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
28 (SELECT player FROM players WHERE nick='wa-ho'),
30 INSERT INTO rounds (tournament, round, randomsongs, chosensongs)
32 (SELECT tournament FROM tournaments WHERE tournamentname='Trondheimsturnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
35 INSERT INTO groups (tournament, round, parallel) VALUES (
36 (SELECT tournament FROM tournaments WHERE tournamentname='Trondheimsturnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
38 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
39 (SELECT tournament FROM tournaments WHERE tournamentname='Trondheimsturnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
41 (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)'))
43 UPDATE rounds SET randomsongs=1 WHERE
44 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Trondheimsturnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )) AND
46 UPDATE rounds SET chosensongs=1 WHERE
47 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Trondheimsturnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )) AND
49 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
50 (SELECT tournament FROM tournaments WHERE tournamentname='Trondheimsturnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
52 (SELECT player FROM players WHERE nick='Sesse'),
55 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
56 (SELECT tournament FROM tournaments WHERE tournamentname='Trondheimsturnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
58 (SELECT player FROM players WHERE nick='Sesse'),
60 (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)')),
63 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
64 (SELECT tournament FROM tournaments WHERE tournamentname='Trondheimsturnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
66 (SELECT player FROM players WHERE nick='Sesse'),
68 (SELECT song FROM songs WHERE lower(title)=lower('Tsugaru')),
71 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
72 (SELECT tournament FROM tournaments WHERE tournamentname='Trondheimsturnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
74 (SELECT player FROM players WHERE nick='wa-ho'),
77 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
78 (SELECT tournament FROM tournaments WHERE tournamentname='Trondheimsturnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
80 (SELECT player FROM players WHERE nick='wa-ho'),
82 (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)')),
85 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
86 (SELECT tournament FROM tournaments WHERE tournamentname='Trondheimsturnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
88 (SELECT player FROM players WHERE nick='wa-ho'),
90 (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
93 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
94 (SELECT tournament FROM tournaments WHERE tournamentname='Trondheimsturnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
96 (SELECT player FROM players WHERE nick='Dashiva'),
99 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
100 (SELECT tournament FROM tournaments WHERE tournamentname='Trondheimsturnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
102 (SELECT player FROM players WHERE nick='Dashiva'),
104 (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)')),
107 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
108 (SELECT tournament FROM tournaments WHERE tournamentname='Trondheimsturnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
110 (SELECT player FROM players WHERE nick='Dashiva'),
112 (SELECT song FROM songs WHERE lower(title)=lower('Crash!')),
115 INSERT INTO rounds (tournament, round, randomsongs, chosensongs)
117 (SELECT tournament FROM tournaments WHERE tournamentname='Trondheimsturnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
120 INSERT INTO groups (tournament, round, parallel) VALUES (
121 (SELECT tournament FROM tournaments WHERE tournamentname='Trondheimsturnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
123 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
124 (SELECT tournament FROM tournaments WHERE tournamentname='Trondheimsturnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
126 (SELECT song FROM songs WHERE lower(title)=lower('Cotton-Eye Joe'))
128 UPDATE rounds SET randomsongs=1 WHERE
129 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Trondheimsturnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )) AND
131 UPDATE rounds SET chosensongs=1 WHERE
132 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Trondheimsturnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )) AND
134 UPDATE rounds SET chosensongs=1 WHERE
135 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Trondheimsturnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )) AND
137 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
138 (SELECT tournament FROM tournaments WHERE tournamentname='Trondheimsturnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
140 (SELECT player FROM players WHERE nick='Dashiva'),
143 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
144 (SELECT tournament FROM tournaments WHERE tournamentname='Trondheimsturnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
146 (SELECT player FROM players WHERE nick='Dashiva'),
148 (SELECT song FROM songs WHERE lower(title)=lower('Cotton-Eye Joe')),
151 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
152 (SELECT tournament FROM tournaments WHERE tournamentname='Trondheimsturnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
154 (SELECT player FROM players WHERE nick='Dashiva'),
156 (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
159 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
160 (SELECT tournament FROM tournaments WHERE tournamentname='Trondheimsturnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
162 (SELECT player FROM players WHERE nick='Dashiva'),
164 (SELECT song FROM songs WHERE lower(title)=lower('Vanity Angel')),
167 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
168 (SELECT tournament FROM tournaments WHERE tournamentname='Trondheimsturnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
170 (SELECT player FROM players WHERE nick='wa-ho'),
173 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
174 (SELECT tournament FROM tournaments WHERE tournamentname='Trondheimsturnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
176 (SELECT player FROM players WHERE nick='wa-ho'),
178 (SELECT song FROM songs WHERE lower(title)=lower('Cotton-Eye Joe')),
181 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
182 (SELECT tournament FROM tournaments WHERE tournamentname='Trondheimsturnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
184 (SELECT player FROM players WHERE nick='wa-ho'),
186 (SELECT song FROM songs WHERE lower(title)=lower('Jam Jam Reggae (AM Swing Mix)')),
189 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
190 (SELECT tournament FROM tournaments WHERE tournamentname='Trondheimsturnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
192 (SELECT player FROM players WHERE nick='wa-ho'),
194 (SELECT song FROM songs WHERE lower(title)=lower('Dead End')),
197 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
198 (SELECT tournament FROM tournaments WHERE tournamentname='Trondheimsturnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
200 (SELECT player FROM players WHERE nick='Sesse'),
203 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
204 (SELECT tournament FROM tournaments WHERE tournamentname='Trondheimsturnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
206 (SELECT player FROM players WHERE nick='Sesse'),
208 (SELECT song FROM songs WHERE lower(title)=lower('Cotton-Eye Joe')),
211 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
212 (SELECT tournament FROM tournaments WHERE tournamentname='Trondheimsturnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
214 (SELECT player FROM players WHERE nick='Sesse'),
216 (SELECT song FROM songs WHERE lower(title)=lower('Dead End')),
219 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
220 (SELECT tournament FROM tournaments WHERE tournamentname='Trondheimsturnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
222 (SELECT player FROM players WHERE nick='Sesse'),
224 (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love (SPEED MIX)')),