begin;
INSERT INTO tournaments
(season, tournamentname, country, location, "date", machine, scoringsystem) VALUES (
begin;
INSERT INTO tournaments
(season, tournamentname, country, location, "date", machine, scoringsystem) VALUES (
'Tønsberg Turnering',
(SELECT country FROM countries WHERE countryname='Norway'),
'Tønsberg - Sjøsenteret bowling',
'Tønsberg Turnering',
(SELECT country FROM countries WHERE countryname='Norway'),
'Tønsberg - Sjøsenteret bowling',
);
INSERT INTO players SELECT nextval('players_player_seq') AS player, 'OJK' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'OJK' NOT IN ( SELECT nick FROM players );
INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
);
INSERT INTO players SELECT nextval('players_player_seq') AS player, 'OJK' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'OJK' NOT IN ( SELECT nick FROM players );
INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
1,
(SELECT player FROM players WHERE nick='OJK'),
NULL);
INSERT INTO players SELECT nextval('players_player_seq') AS player, 'T|na' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'T|na' NOT IN ( SELECT nick FROM players );
INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
1,
(SELECT player FROM players WHERE nick='OJK'),
NULL);
INSERT INTO players SELECT nextval('players_player_seq') AS player, 'T|na' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'T|na' NOT IN ( SELECT nick FROM players );
INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
2,
(SELECT player FROM players WHERE nick='T|na'),
NULL);
INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Pfxp' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Pfxp' NOT IN ( SELECT nick FROM players );
INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
2,
(SELECT player FROM players WHERE nick='T|na'),
NULL);
INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Pfxp' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Pfxp' NOT IN ( SELECT nick FROM players );
INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
3,
(SELECT player FROM players WHERE nick='Pfxp'),
NULL);
INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Jallaman' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Jallaman' NOT IN ( SELECT nick FROM players );
INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
3,
(SELECT player FROM players WHERE nick='Pfxp'),
NULL);
INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Jallaman' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Jallaman' NOT IN ( SELECT nick FROM players );
INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
4,
(SELECT player FROM players WHERE nick='Jallaman'),
NULL);
INSERT INTO players SELECT nextval('players_player_seq') AS player, 'erikTman' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'erikTman' NOT IN ( SELECT nick FROM players );
INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
4,
(SELECT player FROM players WHERE nick='Jallaman'),
NULL);
INSERT INTO players SELECT nextval('players_player_seq') AS player, 'erikTman' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'erikTman' NOT IN ( SELECT nick FROM players );
INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
5,
(SELECT player FROM players WHERE nick='erikTman'),
NULL);
INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Benny' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Benny' NOT IN ( SELECT nick FROM players );
INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
5,
(SELECT player FROM players WHERE nick='erikTman'),
NULL);
INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Benny' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Benny' NOT IN ( SELECT nick FROM players );
INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
6,
(SELECT player FROM players WHERE nick='Benny'),
NULL);
INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Nypd' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Nypd' NOT IN ( SELECT nick FROM players );
INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
6,
(SELECT player FROM players WHERE nick='Benny'),
NULL);
INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Nypd' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Nypd' NOT IN ( SELECT nick FROM players );
INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
7,
(SELECT player FROM players WHERE nick='Nypd'),
NULL);
INSERT INTO players SELECT nextval('players_player_seq') AS player, 'msichana' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'msichana' NOT IN ( SELECT nick FROM players );
INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
7,
(SELECT player FROM players WHERE nick='Nypd'),
NULL);
INSERT INTO players SELECT nextval('players_player_seq') AS player, 'msichana' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'msichana' NOT IN ( SELECT nick FROM players );
INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
8,
(SELECT player FROM players WHERE nick='msichana'),
NULL);
INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Nelly' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Nelly' NOT IN ( SELECT nick FROM players );
INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
8,
(SELECT player FROM players WHERE nick='msichana'),
NULL);
INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Nelly' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Nelly' NOT IN ( SELECT nick FROM players );
INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
9,
(SELECT player FROM players WHERE nick='Nelly'),
NULL);
INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Tomi' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Tomi' NOT IN ( SELECT nick FROM players );
INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
9,
(SELECT player FROM players WHERE nick='Nelly'),
NULL);
INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Tomi' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Tomi' NOT IN ( SELECT nick FROM players );
INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
10,
(SELECT player FROM players WHERE nick='Tomi'),
NULL);
INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Annkakris' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Annkakris' NOT IN ( SELECT nick FROM players );
INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
10,
(SELECT player FROM players WHERE nick='Tomi'),
NULL);
INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Annkakris' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Annkakris' NOT IN ( SELECT nick FROM players );
INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
11,
(SELECT player FROM players WHERE nick='Annkakris'),
NULL);
INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Henrik' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Henrik' NOT IN ( SELECT nick FROM players );
INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
11,
(SELECT player FROM players WHERE nick='Annkakris'),
NULL);
INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Henrik' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Henrik' NOT IN ( SELECT nick FROM players );
INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
12,
(SELECT player FROM players WHERE nick='Henrik'),
NULL);
INSERT INTO rounds (tournament, round, randomsongs, chosensongs)
VALUES (
12,
(SELECT player FROM players WHERE nick='Henrik'),
NULL);
INSERT INTO rounds (tournament, round, randomsongs, chosensongs)
VALUES (
1, 1);
INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
1, 1);
INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
1, 1,
(SELECT song FROM songs WHERE lower(title)=lower('Luv to Me (AMD Mix)'))
);
INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
1, 1,
(SELECT song FROM songs WHERE lower(title)=lower('Luv to Me (AMD Mix)'))
);
INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
1, 1,
(SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love'))
);
UPDATE rounds SET randomsongs=2 WHERE
1, 1,
(SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love'))
);
UPDATE rounds SET randomsongs=2 WHERE
round=1;
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
round=1;
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1, 1,
(SELECT player FROM players WHERE nick='Nelly'),
1
);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1, 1,
(SELECT player FROM players WHERE nick='Nelly'),
1
);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
'f',
4480);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
'f',
4480);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
'f',
4082);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
'f',
4082);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
't',
4531);
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
't',
4531);
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1, 1,
(SELECT player FROM players WHERE nick='Henrik'),
2
);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1, 1,
(SELECT player FROM players WHERE nick='Henrik'),
2
);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
'f',
3432);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
'f',
3432);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
'f',
3025);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
'f',
3025);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
't',
3475);
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
't',
3475);
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1, 1,
(SELECT player FROM players WHERE nick='Jallaman'),
3
);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1, 1,
(SELECT player FROM players WHERE nick='Jallaman'),
3
);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
'f',
5121);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
'f',
5121);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
'f',
5287);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
'f',
5287);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
't',
5431);
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
't',
5431);
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1, 1,
(SELECT player FROM players WHERE nick='msichana'),
4
);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1, 1,
(SELECT player FROM players WHERE nick='msichana'),
4
);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
'f',
3897);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
'f',
3897);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
'f',
3679);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
'f',
3679);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1, 2);
INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
1, 2);
INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
1, 2,
(SELECT song FROM songs WHERE lower(title)=lower('I Want You To Want Me'))
);
INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
1, 2,
(SELECT song FROM songs WHERE lower(title)=lower('I Want You To Want Me'))
);
INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
1, 2,
(SELECT song FROM songs WHERE lower(title)=lower('Stomp'))
);
INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
1, 2,
(SELECT song FROM songs WHERE lower(title)=lower('Stomp'))
);
INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
1, 2,
(SELECT song FROM songs WHERE lower(title)=lower('5, 6, 7, 8'))
);
UPDATE rounds SET randomsongs=3 WHERE
1, 2,
(SELECT song FROM songs WHERE lower(title)=lower('5, 6, 7, 8'))
);
UPDATE rounds SET randomsongs=3 WHERE
round=1;
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
round=1;
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1, 2,
(SELECT player FROM players WHERE nick='Pfxp'),
1
);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1, 2,
(SELECT player FROM players WHERE nick='Pfxp'),
1
);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
'f',
4988);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
'f',
4988);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
'f',
5000);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
'f',
5000);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
'f',
5449);
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
'f',
5449);
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1, 2,
(SELECT player FROM players WHERE nick='Annkakris'),
2
);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1, 2,
(SELECT player FROM players WHERE nick='Annkakris'),
2
);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
'f',
1434);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
'f',
1434);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
'f',
2284);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
'f',
2284);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
'f',
3831);
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
'f',
3831);
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1, 2,
(SELECT player FROM players WHERE nick='erikTman'),
3
);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1, 2,
(SELECT player FROM players WHERE nick='erikTman'),
3
);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
'f',
4517);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
'f',
4517);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
'f',
4216);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
'f',
4216);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
'f',
5081);
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
'f',
5081);
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1, 2,
(SELECT player FROM players WHERE nick='T|na'),
4
);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1, 2,
(SELECT player FROM players WHERE nick='T|na'),
4
);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
'f',
4890);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
'f',
4890);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
'f',
5204);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
'f',
5204);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1, 3);
INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
1, 3);
INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
1, 3,
(SELECT song FROM songs WHERE lower(title)=lower('Burnin\' the Floor'))
);
INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
1, 3,
(SELECT song FROM songs WHERE lower(title)=lower('Burnin\' the Floor'))
);
INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
1, 3,
(SELECT song FROM songs WHERE lower(title)=lower('Look to the sky'))
);
UPDATE rounds SET randomsongs=2 WHERE
1, 3,
(SELECT song FROM songs WHERE lower(title)=lower('Look to the sky'))
);
UPDATE rounds SET randomsongs=2 WHERE
round=1;
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
round=1;
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1, 3,
(SELECT player FROM players WHERE nick='Tomi'),
1
);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1, 3,
(SELECT player FROM players WHERE nick='Tomi'),
1
);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
'f',
2986);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
'f',
2986);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
'f',
2194);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
'f',
2194);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
't',
4096);
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
't',
4096);
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1, 3,
(SELECT player FROM players WHERE nick='OJK'),
2
);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1, 3,
(SELECT player FROM players WHERE nick='OJK'),
2
);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
'f',
5846);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
'f',
5846);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
'f',
5402);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
'f',
5402);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
't',
7146);
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
't',
7146);
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1, 3,
(SELECT player FROM players WHERE nick='Nypd'),
3
);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1, 3,
(SELECT player FROM players WHERE nick='Nypd'),
3
);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
'f',
4828);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
'f',
4828);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
'f',
3743);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
'f',
3743);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
't',
4814);
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
't',
4814);
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1, 3,
(SELECT player FROM players WHERE nick='Benny'),
4
);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1, 3,
(SELECT player FROM players WHERE nick='Benny'),
4
);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
'f',
4753);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
'f',
4753);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
'f',
3736);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
'f',
3736);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
4314);
INSERT INTO rounds (tournament, round, randomsongs, chosensongs)
VALUES (
4314);
INSERT INTO rounds (tournament, round, randomsongs, chosensongs)
VALUES (
2, 1);
INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
2, 1);
INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
2, 1,
(SELECT song FROM songs WHERE lower(title)=lower('Trip Machine Climax'))
);
INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
2, 1,
(SELECT song FROM songs WHERE lower(title)=lower('Trip Machine Climax'))
);
INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
2, 1,
(SELECT song FROM songs WHERE lower(title)=lower('Secret Rendez-vous'))
);
UPDATE rounds SET randomsongs=2 WHERE
2, 1,
(SELECT song FROM songs WHERE lower(title)=lower('Secret Rendez-vous'))
);
UPDATE rounds SET randomsongs=2 WHERE
round=2;
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
round=2;
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
2, 1,
(SELECT player FROM players WHERE nick='Benny'),
1
);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2, 1,
(SELECT player FROM players WHERE nick='Benny'),
1
);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
'f',
3915);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
'f',
3915);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
'f',
3800);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
'f',
3800);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
't',
4177);
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
't',
4177);
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
2, 1,
(SELECT player FROM players WHERE nick='T|na'),
2
);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2, 1,
(SELECT player FROM players WHERE nick='T|na'),
2
);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
'f',
6197);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
'f',
6197);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
'f',
4031);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
'f',
4031);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
't',
7295);
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
't',
7295);
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
2, 1,
(SELECT player FROM players WHERE nick='msichana'),
3
);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2, 1,
(SELECT player FROM players WHERE nick='msichana'),
3
);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
'f',
3530);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
'f',
3530);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
'f',
3310);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
'f',
3310);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
't',
3487);
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
't',
3487);
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
2, 1,
(SELECT player FROM players WHERE nick='OJK'),
4
);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2, 1,
(SELECT player FROM players WHERE nick='OJK'),
4
);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
'f',
7707);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
'f',
7707);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
'f',
5566);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
'f',
5566);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2, 2);
INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
2, 2);
INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
2, 2,
(SELECT song FROM songs WHERE lower(title)=lower('www.blonde girl (MOMO Mix)'))
);
INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
2, 2,
(SELECT song FROM songs WHERE lower(title)=lower('www.blonde girl (MOMO Mix)'))
);
INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
2, 2,
(SELECT song FROM songs WHERE lower(title)=lower('Keep On Movin\''))
);
UPDATE rounds SET randomsongs=2 WHERE
2, 2,
(SELECT song FROM songs WHERE lower(title)=lower('Keep On Movin\''))
);
UPDATE rounds SET randomsongs=2 WHERE
round=2;
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
round=2;
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
2, 2,
(SELECT player FROM players WHERE nick='Nypd'),
1
);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2, 2,
(SELECT player FROM players WHERE nick='Nypd'),
1
);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
'f',
3784);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
'f',
3784);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
'f',
3985);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
'f',
3985);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
't',
4564);
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
't',
4564);
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
2, 2,
(SELECT player FROM players WHERE nick='Jallaman'),
2
);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2, 2,
(SELECT player FROM players WHERE nick='Jallaman'),
2
);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
'f',
5230);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
'f',
5230);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
'f',
4926);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
'f',
4926);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
't',
6343);
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
't',
6343);
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
2, 2,
(SELECT player FROM players WHERE nick='erikTman'),
3
);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2, 2,
(SELECT player FROM players WHERE nick='erikTman'),
3
);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
'f',
4994);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
'f',
4994);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
'f',
4855);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
'f',
4855);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
't',
5706);
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
't',
5706);
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
2, 2,
(SELECT player FROM players WHERE nick='Pfxp'),
4
);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2, 2,
(SELECT player FROM players WHERE nick='Pfxp'),
4
);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
'f',
6112);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
'f',
6112);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
'f',
5491);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
'f',
5491);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
7514);
INSERT INTO rounds (tournament, round, randomsongs, chosensongs)
VALUES (
7514);
INSERT INTO rounds (tournament, round, randomsongs, chosensongs)
VALUES (
3, 0);
INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
3, 0);
INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
round=3;
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
round=3;
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
3, 0,
(SELECT player FROM players WHERE nick='Benny'),
1
);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
3, 0,
(SELECT player FROM players WHERE nick='Benny'),
1
);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
'f',
4019);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
'f',
4019);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
't',
5033);
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
't',
5033);
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
3, 0,
(SELECT player FROM players WHERE nick='erikTman'),
2
);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
3, 0,
(SELECT player FROM players WHERE nick='erikTman'),
2
);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
'f',
4328);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
'f',
4328);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
't',
5675);
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
't',
5675);
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
3, 0,
(SELECT player FROM players WHERE nick='Jallaman'),
3
);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
3, 0,
(SELECT player FROM players WHERE nick='Jallaman'),
3
);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
'f',
4245);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
'f',
4245);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
't',
5627);
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
't',
5627);
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
3, 0,
(SELECT player FROM players WHERE nick='T|na'),
4
);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
3, 0,
(SELECT player FROM players WHERE nick='T|na'),
4
);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
'f',
6864);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
'f',
6864);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
't',
6612);
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
't',
6612);
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
3, 0,
(SELECT player FROM players WHERE nick='Pfxp'),
5
);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
3, 0,
(SELECT player FROM players WHERE nick='Pfxp'),
5
);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
'f',
7522);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
'f',
7522);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
't',
6396);
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
't',
6396);
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
3, 0,
(SELECT player FROM players WHERE nick='OJK'),
6
);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
3, 0,
(SELECT player FROM players WHERE nick='OJK'),
6
);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
'f',
8025);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
'f',
8025);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
7269);
INSERT INTO rounds (tournament, round, randomsongs, chosensongs)
VALUES (
7269);
INSERT INTO rounds (tournament, round, randomsongs, chosensongs)
VALUES (
4, 0);
INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
4, 0);
INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
4, 0,
(SELECT song FROM songs WHERE lower(title)=lower('Never Ending Story'))
);
UPDATE rounds SET randomsongs=1 WHERE
4, 0,
(SELECT song FROM songs WHERE lower(title)=lower('Never Ending Story'))
);
UPDATE rounds SET randomsongs=1 WHERE
round=4;
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
round=4;
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
4, 0,
(SELECT player FROM players WHERE nick='Jallaman'),
1
);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
4, 0,
(SELECT player FROM players WHERE nick='Jallaman'),
1
);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
'f',
4999);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
'f',
4999);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
't',
6648);
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
't',
6648);
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
4, 0,
(SELECT player FROM players WHERE nick='erikTman'),
2
);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
4, 0,
(SELECT player FROM players WHERE nick='erikTman'),
2
);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
'f',
4896);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
'f',
4896);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
't',
6707);
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
't',
6707);
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
4, 0,
(SELECT player FROM players WHERE nick='T|na'),
3
);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
4, 0,
(SELECT player FROM players WHERE nick='T|na'),
3
);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
'f',
5649);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
'f',
5649);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
't',
6626);
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
't',
6626);
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
4, 0,
(SELECT player FROM players WHERE nick='Pfxp'),
4
);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
4, 0,
(SELECT player FROM players WHERE nick='Pfxp'),
4
);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
'f',
5833);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
'f',
5833);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
't',
7494);
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
't',
7494);
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
4, 0,
(SELECT player FROM players WHERE nick='OJK'),
5
);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
4, 0,
(SELECT player FROM players WHERE nick='OJK'),
5
);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
'f',
6316);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
'f',
6316);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
8081);
INSERT INTO rounds (tournament, round, randomsongs, chosensongs)
VALUES (
8081);
INSERT INTO rounds (tournament, round, randomsongs, chosensongs)
VALUES (
5, 0);
INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
5, 0);
INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
round=5;
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
round=5;
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
5, 0,
(SELECT player FROM players WHERE nick='Jallaman'),
1
);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
5, 0,
(SELECT player FROM players WHERE nick='Jallaman'),
1
);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
'f',
5777);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
'f',
5777);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
't',
6185);
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
't',
6185);
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
5, 0,
(SELECT player FROM players WHERE nick='T|na'),
2
);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
5, 0,
(SELECT player FROM players WHERE nick='T|na'),
2
);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
'f',
6312);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
'f',
6312);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
't',
7196);
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
't',
7196);
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
5, 0,
(SELECT player FROM players WHERE nick='Pfxp'),
3
);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
5, 0,
(SELECT player FROM players WHERE nick='Pfxp'),
3
);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
'f',
6483);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
'f',
6483);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
't',
7855);
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
't',
7855);
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
5, 0,
(SELECT player FROM players WHERE nick='OJK'),
4
);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
5, 0,
(SELECT player FROM players WHERE nick='OJK'),
4
);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
'f',
6946);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
'f',
6946);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
7845);
INSERT INTO rounds (tournament, round, randomsongs, chosensongs)
VALUES (
7845);
INSERT INTO rounds (tournament, round, randomsongs, chosensongs)
VALUES (
6, 0);
INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
6, 0);
INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
6, 0,
(SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)'))
);
UPDATE rounds SET randomsongs=1 WHERE
6, 0,
(SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)'))
);
UPDATE rounds SET randomsongs=1 WHERE
round=6;
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
round=6;
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
6, 0,
(SELECT player FROM players WHERE nick='T|na'),
1
);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
6, 0,
(SELECT player FROM players WHERE nick='T|na'),
1
);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
'f',
8397);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
'f',
8397);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
't',
8429);
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
't',
8429);
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
6, 0,
(SELECT player FROM players WHERE nick='Pfxp'),
2
);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
6, 0,
(SELECT player FROM players WHERE nick='Pfxp'),
2
);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
'f',
8097);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
'f',
8097);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
't',
0);
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
't',
0);
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
6, 0,
(SELECT player FROM players WHERE nick='OJK'),
3
);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
6, 0,
(SELECT player FROM players WHERE nick='OJK'),
3
);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
'f',
8452);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
'f',
8452);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
6982);
INSERT INTO rounds (tournament, round, randomsongs, chosensongs)
VALUES (
6982);
INSERT INTO rounds (tournament, round, randomsongs, chosensongs)
VALUES (
7, 0);
INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
7, 0);
INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
7, 0,
(SELECT song FROM songs WHERE lower(title)=lower('Caribbean Queen'))
);
UPDATE rounds SET randomsongs=1 WHERE
7, 0,
(SELECT song FROM songs WHERE lower(title)=lower('Caribbean Queen'))
);
UPDATE rounds SET randomsongs=1 WHERE
round=7;
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
round=7;
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
7, 0,
(SELECT player FROM players WHERE nick='OJK'),
1
);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
7, 0,
(SELECT player FROM players WHERE nick='OJK'),
1
);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
'f',
6077);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
'f',
6077);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
't',
8364);
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
't',
8364);
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
7, 0,
(SELECT player FROM players WHERE nick='T|na'),
2
);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
7, 0,
(SELECT player FROM players WHERE nick='T|na'),
2
);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
'f',
6015);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
'f',
6015);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (