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, 'Snute' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Snute' NOT IN ( SELECT nick FROM players );
13 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
14 (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
16 (SELECT player FROM players WHERE nick='Snute'),
18 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Stream' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Stream' NOT IN ( SELECT nick FROM players );
19 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
20 (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
22 (SELECT player FROM players WHERE nick='Stream'),
24 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'DufF' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'DufF' NOT IN ( SELECT nick FROM players );
25 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
26 (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
28 (SELECT player FROM players WHERE nick='DufF'),
30 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Olemann' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Olemann' NOT IN ( SELECT nick FROM players );
31 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
32 (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
34 (SELECT player FROM players WHERE nick='Olemann'),
36 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Ylini' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Ylini' NOT IN ( SELECT nick FROM players );
37 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
38 (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
40 (SELECT player FROM players WHERE nick='Ylini'),
42 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Matsi' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Matsi' NOT IN ( SELECT nick FROM players );
43 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
44 (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
46 (SELECT player FROM players WHERE nick='Matsi'),
48 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Magnar' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Magnar' NOT IN ( SELECT nick FROM players );
49 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
50 (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
52 (SELECT player FROM players WHERE nick='Magnar'),
54 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Advena' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Advena' NOT IN ( SELECT nick FROM players );
55 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
56 (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
58 (SELECT player FROM players WHERE nick='Advena'),
60 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Gollum' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Gollum' NOT IN ( SELECT nick FROM players );
61 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
62 (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
64 (SELECT player FROM players WHERE nick='Gollum'),
66 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Sparks' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Sparks' NOT IN ( SELECT nick FROM players );
67 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
68 (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
70 (SELECT player FROM players WHERE nick='Sparks'),
72 INSERT INTO rounds (tournament, round, randomsongs, chosensongs)
74 (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
77 INSERT INTO groups (tournament, round, parallel) VALUES (
78 (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
80 UPDATE rounds SET randomsongs=0 WHERE
81 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )) AND
83 UPDATE rounds SET chosensongs=1 WHERE
84 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )) AND
86 UPDATE rounds SET chosensongs=1 WHERE
87 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )) AND
89 UPDATE rounds SET chosensongs=1 WHERE
90 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )) AND
92 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
93 (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
95 (SELECT player FROM players WHERE nick='Magnar'),
98 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
99 (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
101 (SELECT player FROM players WHERE nick='Magnar'),
103 (SELECT song FROM songs WHERE lower(title)=lower('I Want You To Want Me')),
106 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
107 (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
109 (SELECT player FROM players WHERE nick='Magnar'),
111 (SELECT song FROM songs WHERE lower(title)=lower('5, 6, 7, 8')),
114 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
115 (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
117 (SELECT player FROM players WHERE nick='Magnar'),
119 (SELECT song FROM songs WHERE lower(title)=lower('That was then, This is now')),
122 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
123 (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
125 (SELECT player FROM players WHERE nick='Advena'),
128 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
129 (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
131 (SELECT player FROM players WHERE nick='Advena'),
133 (SELECT song FROM songs WHERE lower(title)=lower('5, 6, 7, 8')),
136 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
137 (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
139 (SELECT player FROM players WHERE nick='Advena'),
141 (SELECT song FROM songs WHERE lower(title)=lower('I Want You To Want Me')),
144 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
145 (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
147 (SELECT player FROM players WHERE nick='Advena'),
149 (SELECT song FROM songs WHERE lower(title)=lower('That was then, This is now')),
152 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
153 (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
155 (SELECT player FROM players WHERE nick='Snute'),
158 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
159 (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
161 (SELECT player FROM players WHERE nick='Snute'),
163 (SELECT song FROM songs WHERE lower(title)=lower('5, 6, 7, 8')),
166 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
167 (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
169 (SELECT player FROM players WHERE nick='Snute'),
171 (SELECT song FROM songs WHERE lower(title)=lower('That was then, This is now')),
174 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
175 (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
177 (SELECT player FROM players WHERE nick='Snute'),
179 (SELECT song FROM songs WHERE lower(title)=lower('I Want You To Want Me')),
182 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
183 (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
185 (SELECT player FROM players WHERE nick='Gollum'),
188 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
189 (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
191 (SELECT player FROM players WHERE nick='Gollum'),
193 (SELECT song FROM songs WHERE lower(title)=lower('5, 6, 7, 8')),
196 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
197 (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
199 (SELECT player FROM players WHERE nick='Gollum'),
201 (SELECT song FROM songs WHERE lower(title)=lower('Keep On Movin\'')),
204 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
205 (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
207 (SELECT player FROM players WHERE nick='Gollum'),
209 (SELECT song FROM songs WHERE lower(title)=lower('I Want You To Want Me')),
212 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
213 (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
215 (SELECT player FROM players WHERE nick='Olemann'),
218 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
219 (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
221 (SELECT player FROM players WHERE nick='Olemann'),
223 (SELECT song FROM songs WHERE lower(title)=lower('5, 6, 7, 8')),
226 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
227 (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
229 (SELECT player FROM players WHERE nick='Olemann'),
231 (SELECT song FROM songs WHERE lower(title)=lower('Keep On Movin\'')),
234 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
235 (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
237 (SELECT player FROM players WHERE nick='Olemann'),
239 (SELECT song FROM songs WHERE lower(title)=lower('I Want You To Want Me')),
242 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
243 (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
245 (SELECT player FROM players WHERE nick='Ylini'),
248 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
249 (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
251 (SELECT player FROM players WHERE nick='Ylini'),
253 (SELECT song FROM songs WHERE lower(title)=lower('5, 6, 7, 8')),
256 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
257 (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
259 (SELECT player FROM players WHERE nick='Ylini'),
261 (SELECT song FROM songs WHERE lower(title)=lower('I Want You To Want Me')),
264 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
265 (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
267 (SELECT player FROM players WHERE nick='Ylini'),
269 (SELECT song FROM songs WHERE lower(title)=lower('Keep On Movin\'')),
272 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
273 (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
275 (SELECT player FROM players WHERE nick='Sparks'),
278 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
279 (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
281 (SELECT player FROM players WHERE nick='Sparks'),
283 (SELECT song FROM songs WHERE lower(title)=lower('5, 6, 7, 8')),
286 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
287 (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
289 (SELECT player FROM players WHERE nick='Sparks'),
291 (SELECT song FROM songs WHERE lower(title)=lower('I Want You To Want Me')),
294 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
295 (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
297 (SELECT player FROM players WHERE nick='Sparks'),
299 (SELECT song FROM songs WHERE lower(title)=lower('That was then, This is now')),
302 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
303 (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
305 (SELECT player FROM players WHERE nick='DufF'),
308 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
309 (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
311 (SELECT player FROM players WHERE nick='DufF'),
313 (SELECT song FROM songs WHERE lower(title)=lower('5, 6, 7, 8')),
316 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
317 (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
319 (SELECT player FROM players WHERE nick='DufF'),
321 (SELECT song FROM songs WHERE lower(title)=lower('I Want You To Want Me')),
324 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
325 (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
327 (SELECT player FROM players WHERE nick='DufF'),
329 (SELECT song FROM songs WHERE lower(title)=lower('That was then, This is now')),
332 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
333 (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
335 (SELECT player FROM players WHERE nick='Matsi'),
338 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
339 (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
341 (SELECT player FROM players WHERE nick='Matsi'),
343 (SELECT song FROM songs WHERE lower(title)=lower('That was then, This is now')),
346 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
347 (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
349 (SELECT player FROM players WHERE nick='Matsi'),
351 (SELECT song FROM songs WHERE lower(title)=lower('5, 6, 7, 8')),
354 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
355 (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
357 (SELECT player FROM players WHERE nick='Matsi'),
359 (SELECT song FROM songs WHERE lower(title)=lower('I Want You To Want Me')),
362 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
363 (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
365 (SELECT player FROM players WHERE nick='Stream'),
368 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
369 (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
371 (SELECT player FROM players WHERE nick='Stream'),
373 (SELECT song FROM songs WHERE lower(title)=lower('5, 6, 7, 8')),
376 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
377 (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
379 (SELECT player FROM players WHERE nick='Stream'),
381 (SELECT song FROM songs WHERE lower(title)=lower('That was then, This is now')),
384 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
385 (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
387 (SELECT player FROM players WHERE nick='Stream'),
389 (SELECT song FROM songs WHERE lower(title)=lower('I Want You To Want Me')),
392 INSERT INTO rounds (tournament, round, randomsongs, chosensongs)
394 (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
397 INSERT INTO groups (tournament, round, parallel) VALUES (
398 (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
400 UPDATE rounds SET randomsongs=0 WHERE
401 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )) AND
403 UPDATE rounds SET chosensongs=1 WHERE
404 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )) AND
406 UPDATE rounds SET chosensongs=1 WHERE
407 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )) AND
409 UPDATE rounds SET chosensongs=1 WHERE
410 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )) AND
412 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
413 (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
415 (SELECT player FROM players WHERE nick='Matsi'),
418 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
419 (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
421 (SELECT player FROM players WHERE nick='Matsi'),
423 (SELECT song FROM songs WHERE lower(title)=lower('Never Gonna Make (Factory Team Mix)')),
426 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
427 (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
429 (SELECT player FROM players WHERE nick='Matsi'),
431 (SELECT song FROM songs WHERE lower(title)=lower('Burnin\' the Floor')),
434 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
435 (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
437 (SELECT player FROM players WHERE nick='Matsi'),
439 (SELECT song FROM songs WHERE lower(title)=lower('Cotton-Eye Joe')),
442 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
443 (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
445 (SELECT player FROM players WHERE nick='Advena'),
448 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
449 (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
451 (SELECT player FROM players WHERE nick='Advena'),
453 (SELECT song FROM songs WHERE lower(title)=lower('D2R')),
456 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
457 (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
459 (SELECT player FROM players WHERE nick='Advena'),
461 (SELECT song FROM songs WHERE lower(title)=lower('Burnin\' the Floor')),
464 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
465 (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
467 (SELECT player FROM players WHERE nick='Advena'),
469 (SELECT song FROM songs WHERE lower(title)=lower('Cotton-Eye Joe')),
472 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
473 (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
475 (SELECT player FROM players WHERE nick='Magnar'),
478 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
479 (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
481 (SELECT player FROM players WHERE nick='Magnar'),
483 (SELECT song FROM songs WHERE lower(title)=lower('D2R')),
486 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
487 (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
489 (SELECT player FROM players WHERE nick='Magnar'),
491 (SELECT song FROM songs WHERE lower(title)=lower('Burnin\' the Floor')),
494 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
495 (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
497 (SELECT player FROM players WHERE nick='Magnar'),
499 (SELECT song FROM songs WHERE lower(title)=lower('Cotton-Eye Joe')),
502 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
503 (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
505 (SELECT player FROM players WHERE nick='Ylini'),
508 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
509 (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
511 (SELECT player FROM players WHERE nick='Ylini'),
513 (SELECT song FROM songs WHERE lower(title)=lower('Never Gonna Make (Factory Team Mix)')),
516 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
517 (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
519 (SELECT player FROM players WHERE nick='Ylini'),
521 (SELECT song FROM songs WHERE lower(title)=lower('Never Let You Down')),
524 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
525 (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
527 (SELECT player FROM players WHERE nick='Ylini'),
529 (SELECT song FROM songs WHERE lower(title)=lower('20th November')),
532 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
533 (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
535 (SELECT player FROM players WHERE nick='Olemann'),
538 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
539 (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
541 (SELECT player FROM players WHERE nick='Olemann'),
543 (SELECT song FROM songs WHERE lower(title)=lower('Never Gonna Make (Factory Team Mix)')),
546 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
547 (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
549 (SELECT player FROM players WHERE nick='Olemann'),
551 (SELECT song FROM songs WHERE lower(title)=lower('Never Let You Down')),
554 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
555 (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
557 (SELECT player FROM players WHERE nick='Olemann'),
559 (SELECT song FROM songs WHERE lower(title)=lower('20th November')),
562 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
563 (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
565 (SELECT player FROM players WHERE nick='Stream'),
568 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
569 (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
571 (SELECT player FROM players WHERE nick='Stream'),
573 (SELECT song FROM songs WHERE lower(title)=lower('Never Gonna Make (Factory Team Mix)')),
576 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
577 (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
579 (SELECT player FROM players WHERE nick='Stream'),
581 (SELECT song FROM songs WHERE lower(title)=lower('Never Let You Down')),
584 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
585 (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
587 (SELECT player FROM players WHERE nick='Stream'),
589 (SELECT song FROM songs WHERE lower(title)=lower('Cotton-Eye Joe')),
592 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
593 (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
595 (SELECT player FROM players WHERE nick='DufF'),
598 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
599 (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
601 (SELECT player FROM players WHERE nick='DufF'),
603 (SELECT song FROM songs WHERE lower(title)=lower('Never Gonna Make (Factory Team Mix)')),
606 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
607 (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
609 (SELECT player FROM players WHERE nick='DufF'),
611 (SELECT song FROM songs WHERE lower(title)=lower('Burnin\' the Floor')),
614 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
615 (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
617 (SELECT player FROM players WHERE nick='DufF'),
619 (SELECT song FROM songs WHERE lower(title)=lower('Never Let You Down')),
622 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
623 (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
625 (SELECT player FROM players WHERE nick='Snute'),
628 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
629 (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
631 (SELECT player FROM players WHERE nick='Snute'),
633 (SELECT song FROM songs WHERE lower(title)=lower('Never Let You Down')),
636 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
637 (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
639 (SELECT player FROM players WHERE nick='Snute'),
641 (SELECT song FROM songs WHERE lower(title)=lower('Never Gonna Make (Factory Team Mix)')),
644 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
645 (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
647 (SELECT player FROM players WHERE nick='Snute'),
649 (SELECT song FROM songs WHERE lower(title)=lower('20th November')),
652 INSERT INTO rounds (tournament, round, randomsongs, chosensongs)
654 (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
657 INSERT INTO groups (tournament, round, parallel) VALUES (
658 (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
660 UPDATE rounds SET randomsongs=0 WHERE
661 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )) AND
663 UPDATE rounds SET chosensongs=1 WHERE
664 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )) AND
666 UPDATE rounds SET chosensongs=1 WHERE
667 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )) AND
669 UPDATE rounds SET chosensongs=1 WHERE
670 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )) AND
672 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
673 (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
675 (SELECT player FROM players WHERE nick='Advena'),
678 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
679 (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
681 (SELECT player FROM players WHERE nick='Advena'),
683 (SELECT song FROM songs WHERE lower(title)=lower('Ecstasy')),
686 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
687 (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
689 (SELECT player FROM players WHERE nick='Advena'),
691 (SELECT song FROM songs WHERE lower(title)=lower('B4U (B4 Za Beat Mix)')),
694 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
695 (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
697 (SELECT player FROM players WHERE nick='Advena'),
699 (SELECT song FROM songs WHERE lower(title)=lower('Living in America')),
702 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
703 (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
705 (SELECT player FROM players WHERE nick='Ylini'),
708 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
709 (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
711 (SELECT player FROM players WHERE nick='Ylini'),
713 (SELECT song FROM songs WHERE lower(title)=lower('Groove 2001')),
716 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
717 (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
719 (SELECT player FROM players WHERE nick='Ylini'),
721 (SELECT song FROM songs WHERE lower(title)=lower('B4U (B4 Za Beat Mix)')),
724 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
725 (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
727 (SELECT player FROM players WHERE nick='Ylini'),
729 (SELECT song FROM songs WHERE lower(title)=lower('Love You Like A Fool')),
732 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
733 (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
735 (SELECT player FROM players WHERE nick='Stream'),
738 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
739 (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
741 (SELECT player FROM players WHERE nick='Stream'),
743 (SELECT song FROM songs WHERE lower(title)=lower('Groove 2001')),
746 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
747 (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
749 (SELECT player FROM players WHERE nick='Stream'),
751 (SELECT song FROM songs WHERE lower(title)=lower('B4U (B4 Za Beat Mix)')),
754 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
755 (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
757 (SELECT player FROM players WHERE nick='Stream'),
759 (SELECT song FROM songs WHERE lower(title)=lower('Living in America')),
762 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
763 (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
765 (SELECT player FROM players WHERE nick='Olemann'),
768 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
769 (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
771 (SELECT player FROM players WHERE nick='Olemann'),
773 (SELECT song FROM songs WHERE lower(title)=lower('Groove 2001')),
776 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
777 (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
779 (SELECT player FROM players WHERE nick='Olemann'),
781 (SELECT song FROM songs WHERE lower(title)=lower('B4U (B4 Za Beat Mix)')),
784 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
785 (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
787 (SELECT player FROM players WHERE nick='Olemann'),
789 (SELECT song FROM songs WHERE lower(title)=lower('Love You Like A Fool')),
792 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
793 (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
795 (SELECT player FROM players WHERE nick='DufF'),
798 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
799 (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
801 (SELECT player FROM players WHERE nick='DufF'),
803 (SELECT song FROM songs WHERE lower(title)=lower('Ecstasy')),
806 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
807 (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
809 (SELECT player FROM players WHERE nick='DufF'),
811 (SELECT song FROM songs WHERE lower(title)=lower('Groove 2001')),
814 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
815 (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
817 (SELECT player FROM players WHERE nick='DufF'),
819 (SELECT song FROM songs WHERE lower(title)=lower('Love You Like A Fool')),
822 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
823 (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
825 (SELECT player FROM players WHERE nick='Snute'),
828 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
829 (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
831 (SELECT player FROM players WHERE nick='Snute'),
833 (SELECT song FROM songs WHERE lower(title)=lower('Ecstasy')),
836 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
837 (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
839 (SELECT player FROM players WHERE nick='Snute'),
841 (SELECT song FROM songs WHERE lower(title)=lower('Destiny')),
844 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
845 (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
847 (SELECT player FROM players WHERE nick='Snute'),
849 (SELECT song FROM songs WHERE lower(title)=lower('Groove 2001')),
852 INSERT INTO rounds (tournament, round, randomsongs, chosensongs)
854 (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
857 INSERT INTO groups (tournament, round, parallel) VALUES (
858 (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
860 UPDATE rounds SET randomsongs=0 WHERE
861 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )) AND
863 UPDATE rounds SET chosensongs=1 WHERE
864 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )) AND
866 UPDATE rounds SET chosensongs=1 WHERE
867 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )) AND
869 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
870 (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
872 (SELECT player FROM players WHERE nick='Ylini'),
875 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
876 (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
878 (SELECT player FROM players WHERE nick='Ylini'),
880 (SELECT song FROM songs WHERE lower(title)=lower('')),
883 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
884 (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
886 (SELECT player FROM players WHERE nick='Ylini'),
888 (SELECT song FROM songs WHERE lower(title)=lower('Test My Best')),
891 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
892 (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
894 (SELECT player FROM players WHERE nick='Ylini'),
896 (SELECT song FROM songs WHERE lower(title)=lower('Nori Nori Nori')),
899 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
900 (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
902 (SELECT player FROM players WHERE nick='Olemann'),
905 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
906 (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
908 (SELECT player FROM players WHERE nick='Olemann'),
910 (SELECT song FROM songs WHERE lower(title)=lower('')),
913 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
914 (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
916 (SELECT player FROM players WHERE nick='Olemann'),
918 (SELECT song FROM songs WHERE lower(title)=lower('Test My Best')),
921 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
922 (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
924 (SELECT player FROM players WHERE nick='Olemann'),
926 (SELECT song FROM songs WHERE lower(title)=lower('Nori Nori Nori')),
929 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
930 (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
932 (SELECT player FROM players WHERE nick='Stream'),
935 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
936 (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
938 (SELECT player FROM players WHERE nick='Stream'),
940 (SELECT song FROM songs WHERE lower(title)=lower('')),
943 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
944 (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
946 (SELECT player FROM players WHERE nick='Stream'),
948 (SELECT song FROM songs WHERE lower(title)=lower('Nori Nori Nori')),
951 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
952 (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
954 (SELECT player FROM players WHERE nick='Stream'),
956 (SELECT song FROM songs WHERE lower(title)=lower('Test My Best')),
959 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
960 (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
962 (SELECT player FROM players WHERE nick='Snute'),
965 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
966 (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
968 (SELECT player FROM players WHERE nick='Snute'),
970 (SELECT song FROM songs WHERE lower(title)=lower('')),
973 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
974 (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
976 (SELECT player FROM players WHERE nick='Snute'),
978 (SELECT song FROM songs WHERE lower(title)=lower('Secret Rendez-vous')),
981 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
982 (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
984 (SELECT player FROM players WHERE nick='Snute'),
986 (SELECT song FROM songs WHERE lower(title)=lower('Test My Best')),
989 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
990 (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
992 (SELECT player FROM players WHERE nick='DufF'),
995 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
996 (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
998 (SELECT player FROM players WHERE nick='DufF'),
1000 (SELECT song FROM songs WHERE lower(title)=lower('')),
1003 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1004 (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
1006 (SELECT player FROM players WHERE nick='DufF'),
1008 (SELECT song FROM songs WHERE lower(title)=lower('Nori Nori Nori')),
1011 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1012 (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
1014 (SELECT player FROM players WHERE nick='DufF'),
1016 (SELECT song FROM songs WHERE lower(title)=lower('Test My Best')),
1019 INSERT INTO rounds (tournament, round, randomsongs, chosensongs)
1021 (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
1024 INSERT INTO groups (tournament, round, parallel) VALUES (
1025 (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
1027 UPDATE rounds SET randomsongs=0 WHERE
1028 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )) AND
1030 UPDATE rounds SET chosensongs=1 WHERE
1031 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )) AND
1033 UPDATE rounds SET chosensongs=1 WHERE
1034 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )) AND
1036 UPDATE rounds SET chosensongs=1 WHERE
1037 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )) AND
1039 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1040 (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
1042 (SELECT player FROM players WHERE nick='Olemann'),
1045 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1046 (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
1048 (SELECT player FROM players WHERE nick='Olemann'),
1050 (SELECT song FROM songs WHERE lower(title)=lower('era (nostalmix)')),
1053 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1054 (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
1056 (SELECT player FROM players WHERE nick='Olemann'),
1058 (SELECT song FROM songs WHERE lower(title)=lower('B4U')),
1061 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1062 (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
1064 (SELECT player FROM players WHERE nick='Olemann'),
1066 (SELECT song FROM songs WHERE lower(title)=lower('Trip Machine (Luv Mix)')),
1069 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1070 (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
1072 (SELECT player FROM players WHERE nick='Stream'),
1075 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1076 (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
1078 (SELECT player FROM players WHERE nick='Stream'),
1080 (SELECT song FROM songs WHERE lower(title)=lower('era (nostalmix)')),
1083 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1084 (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
1086 (SELECT player FROM players WHERE nick='Stream'),
1088 (SELECT song FROM songs WHERE lower(title)=lower('B4U')),
1091 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1092 (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
1094 (SELECT player FROM players WHERE nick='Stream'),
1096 (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love')),
1099 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1100 (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
1102 (SELECT player FROM players WHERE nick='DufF'),
1105 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1106 (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
1108 (SELECT player FROM players WHERE nick='DufF'),
1110 (SELECT song FROM songs WHERE lower(title)=lower('era (nostalmix)')),
1113 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1114 (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
1116 (SELECT player FROM players WHERE nick='DufF'),
1118 (SELECT song FROM songs WHERE lower(title)=lower('Jam Jam Reggae (AM Swing Mix)')),
1121 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1122 (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
1124 (SELECT player FROM players WHERE nick='DufF'),
1126 (SELECT song FROM songs WHERE lower(title)=lower('Trip Machine (Luv Mix)')),
1129 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1130 (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
1132 (SELECT player FROM players WHERE nick='Snute'),
1135 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1136 (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
1138 (SELECT player FROM players WHERE nick='Snute'),
1140 (SELECT song FROM songs WHERE lower(title)=lower('B4U')),
1143 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1144 (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
1146 (SELECT player FROM players WHERE nick='Snute'),
1148 (SELECT song FROM songs WHERE lower(title)=lower('Jam Jam Reggae (AM Swing Mix)')),
1151 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1152 (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
1154 (SELECT player FROM players WHERE nick='Snute'),
1156 (SELECT song FROM songs WHERE lower(title)=lower('Aaron\'s Party (Come Get It)')),
1159 INSERT INTO rounds (tournament, round, randomsongs, chosensongs)
1161 (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
1164 INSERT INTO groups (tournament, round, parallel) VALUES (
1165 (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
1167 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
1168 (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
1170 (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)'))
1172 UPDATE rounds SET randomsongs=1 WHERE
1173 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )) AND
1175 UPDATE rounds SET chosensongs=1 WHERE
1176 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )) AND
1178 UPDATE rounds SET chosensongs=1 WHERE
1179 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )) AND
1181 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1182 (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
1184 (SELECT player FROM players WHERE nick='DufF'),
1187 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1188 (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
1190 (SELECT player FROM players WHERE nick='DufF'),
1192 (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
1195 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1196 (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
1198 (SELECT player FROM players WHERE nick='DufF'),
1200 (SELECT song FROM songs WHERE lower(title)=lower('Dead End')),
1203 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1204 (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
1206 (SELECT player FROM players WHERE nick='DufF'),
1208 (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)')),
1211 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1212 (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
1214 (SELECT player FROM players WHERE nick='Stream'),
1217 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1218 (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
1220 (SELECT player FROM players WHERE nick='Stream'),
1222 (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
1225 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1226 (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
1228 (SELECT player FROM players WHERE nick='Stream'),
1230 (SELECT song FROM songs WHERE lower(title)=lower('Dead End')),
1233 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1234 (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
1236 (SELECT player FROM players WHERE nick='Stream'),
1238 (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)')),
1241 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1242 (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
1244 (SELECT player FROM players WHERE nick='Snute'),
1247 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1248 (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
1250 (SELECT player FROM players WHERE nick='Snute'),
1252 (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
1255 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1256 (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
1258 (SELECT player FROM players WHERE nick='Snute'),
1260 (SELECT song FROM songs WHERE lower(title)=lower('My Summer Love')),
1263 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1264 (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
1266 (SELECT player FROM players WHERE nick='Snute'),
1268 (SELECT song FROM songs WHERE lower(title)=lower('Crash!')),
1271 INSERT INTO rounds (tournament, round, randomsongs, chosensongs)
1273 (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
1276 INSERT INTO groups (tournament, round, parallel) VALUES (
1277 (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
1279 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
1280 (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
1282 (SELECT song FROM songs WHERE lower(title)=lower('Healing Vision (Angelic Mix)'))
1284 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
1285 (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
1287 (SELECT song FROM songs WHERE lower(title)=lower('Afronova'))
1289 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
1290 (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
1292 (SELECT song FROM songs WHERE lower(title)=lower('Max 300'))
1294 UPDATE rounds SET randomsongs=3 WHERE
1295 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )) AND
1297 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1298 (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
1300 (SELECT player FROM players WHERE nick='Stream'),
1303 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1304 (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
1306 (SELECT player FROM players WHERE nick='Stream'),
1308 (SELECT song FROM songs WHERE lower(title)=lower('Healing Vision (Angelic Mix)')),
1311 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1312 (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
1314 (SELECT player FROM players WHERE nick='Stream'),
1316 (SELECT song FROM songs WHERE lower(title)=lower('Afronova')),
1319 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1320 (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
1322 (SELECT player FROM players WHERE nick='Stream'),
1324 (SELECT song FROM songs WHERE lower(title)=lower('Max 300')),
1327 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1328 (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
1330 (SELECT player FROM players WHERE nick='Snute'),
1333 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1334 (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
1336 (SELECT player FROM players WHERE nick='Snute'),
1338 (SELECT song FROM songs WHERE lower(title)=lower('Healing Vision (Angelic Mix)')),
1341 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1342 (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
1344 (SELECT player FROM players WHERE nick='Snute'),
1346 (SELECT song FROM songs WHERE lower(title)=lower('Afronova')),
1349 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1350 (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
1352 (SELECT player FROM players WHERE nick='Snute'),
1354 (SELECT song FROM songs WHERE lower(title)=lower('Max 300')),