Update the DDR Europe parser to add song ordering information. Update the CC SQL...

[ccbs] / sql / cc04 / cc3-04.sql

diff --git a/sql/cc04/cc3-04.sql b/sql/cc04/cc3-04.sql
index 90eaad17eb70ad897b26176628a208f1b4c03d6c..7f01806926ba11d0f3f79f4130f0cb4e099c5287 100644 (file)
--- a/sql/cc04/cc3-04.sql
+++ b/sql/cc04/cc3-04.sql
@@ -40,24 +40,27 @@ INSERT INTO roundparticipation (tournament, round, parallel, player, position) V
    (SELECT player FROM players WHERE nick='Ted Kristian'),
    1
 );
-INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
    (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
    1, 1,
    (SELECT player FROM players WHERE nick='Ted Kristian'),
+   0,
    (SELECT song FROM songs WHERE lower(title)=lower('B4U (B4 Za Beat Mix)')),
    'f',
    4475);
-INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
    (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
    1, 1,
    (SELECT player FROM players WHERE nick='Ted Kristian'),
+   1,
    (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love')),
    'f',
    5340);
-INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
    (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
    1, 1,
    (SELECT player FROM players WHERE nick='Ted Kristian'),
+   2,
    (SELECT song FROM songs WHERE lower(title)=lower('Crash!')),
    't',
    7032);
@@ -68,24 +71,27 @@ INSERT INTO roundparticipation (tournament, round, parallel, player, position) V
    (SELECT player FROM players WHERE nick='Pål Andre'),
    2
 );
-INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
    (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
    1, 1,
    (SELECT player FROM players WHERE nick='Pål Andre'),
+   0,
    (SELECT song FROM songs WHERE lower(title)=lower('B4U (B4 Za Beat Mix)')),
    'f',
    4760);
-INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
    (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
    1, 1,
    (SELECT player FROM players WHERE nick='Pål Andre'),
+   1,
    (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love')),
    'f',
    5946);
-INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
    (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
    1, 1,
    (SELECT player FROM players WHERE nick='Pål Andre'),
+   2,
    (SELECT song FROM songs WHERE lower(title)=lower('Dead End')),
    't',
    5875);
@@ -96,24 +102,27 @@ INSERT INTO roundparticipation (tournament, round, parallel, player, position) V
    (SELECT player FROM players WHERE nick='Mulefisk'),
    3
 );
-INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
    (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
    1, 1,
    (SELECT player FROM players WHERE nick='Mulefisk'),
+   0,
    (SELECT song FROM songs WHERE lower(title)=lower('B4U (B4 Za Beat Mix)')),
    'f',
    5734);
-INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
    (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
    1, 1,
    (SELECT player FROM players WHERE nick='Mulefisk'),
+   1,
    (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love')),
    'f',
    7095);
-INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
    (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
    1, 1,
    (SELECT player FROM players WHERE nick='Mulefisk'),
+   2,
    (SELECT song FROM songs WHERE lower(title)=lower('PARANOiA Rebirth')),
    't',
    8047);
@@ -124,24 +133,27 @@ INSERT INTO roundparticipation (tournament, round, parallel, player, position) V
    (SELECT player FROM players WHERE nick='Haggar'),
    4
 );
-INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
    (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
    1, 1,
    (SELECT player FROM players WHERE nick='Haggar'),
+   0,
    (SELECT song FROM songs WHERE lower(title)=lower('B4U (B4 Za Beat Mix)')),
    'f',
    6356);
-INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
    (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
    1, 1,
    (SELECT player FROM players WHERE nick='Haggar'),
+   1,
    (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love')),
    'f',
    7560);
-INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
    (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
    1, 1,
    (SELECT player FROM players WHERE nick='Haggar'),
+   2,
    (SELECT song FROM songs WHERE lower(title)=lower('era (nostalmix)')),
    't',
    7720);
@@ -152,24 +164,27 @@ INSERT INTO roundparticipation (tournament, round, parallel, player, position) V
    (SELECT player FROM players WHERE nick='Snute'),
    5
 );
-INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
    (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
    1, 1,
    (SELECT player FROM players WHERE nick='Snute'),
+   0,
    (SELECT song FROM songs WHERE lower(title)=lower('B4U (B4 Za Beat Mix)')),
    'f',
    6480);
-INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
    (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
    1, 1,
    (SELECT player FROM players WHERE nick='Snute'),
+   1,
    (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love')),
    'f',
    7646);
-INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
    (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
    1, 1,
    (SELECT player FROM players WHERE nick='Snute'),
+   2,
    (SELECT song FROM songs WHERE lower(title)=lower('B4U')),
    't',
    7702);
@@ -199,24 +214,27 @@ INSERT INTO roundparticipation (tournament, round, parallel, player, position) V
    (SELECT player FROM players WHERE nick='Jim Andre'),
    1
 );
-INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
    (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
    1, 2,
    (SELECT player FROM players WHERE nick='Jim Andre'),
+   0,
    (SELECT song FROM songs WHERE lower(title)=lower('Don\'t Try to Stop It')),
    'f',
    5809);
-INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
    (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
    1, 2,
    (SELECT player FROM players WHERE nick='Jim Andre'),
+   1,
    (SELECT song FROM songs WHERE lower(title)=lower('Make A Jam!')),
    'f',
    5338);
-INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
    (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
    1, 2,
    (SELECT player FROM players WHERE nick='Jim Andre'),
+   2,
    (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love')),
    't',
    6198);
@@ -227,24 +245,27 @@ INSERT INTO roundparticipation (tournament, round, parallel, player, position) V
    (SELECT player FROM players WHERE nick='Andre'),
    2
 );
-INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
    (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
    1, 2,
    (SELECT player FROM players WHERE nick='Andre'),
+   0,
    (SELECT song FROM songs WHERE lower(title)=lower('Don\'t Try to Stop It')),
    'f',
    4264);
-INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
    (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
    1, 2,
    (SELECT player FROM players WHERE nick='Andre'),
+   1,
    (SELECT song FROM songs WHERE lower(title)=lower('Make A Jam!')),
    'f',
    3773);
-INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
    (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
    1, 2,
    (SELECT player FROM players WHERE nick='Andre'),
+   2,
    (SELECT song FROM songs WHERE lower(title)=lower('Afronova')),
    't',
    5277);
@@ -255,24 +276,27 @@ INSERT INTO roundparticipation (tournament, round, parallel, player, position) V
    (SELECT player FROM players WHERE nick='Dabi'),
    3
 );
-INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
    (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
    1, 2,
    (SELECT player FROM players WHERE nick='Dabi'),
+   0,
    (SELECT song FROM songs WHERE lower(title)=lower('Don\'t Try to Stop It')),
    'f',
    5388);
-INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
    (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
    1, 2,
    (SELECT player FROM players WHERE nick='Dabi'),
+   1,
    (SELECT song FROM songs WHERE lower(title)=lower('Make A Jam!')),
    'f',
    5249);
-INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
    (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
    1, 2,
    (SELECT player FROM players WHERE nick='Dabi'),
+   2,
    (SELECT song FROM songs WHERE lower(title)=lower('Jam Jam Reggae (AM Swing Mix)')),
    't',
    7228);
@@ -283,24 +307,27 @@ INSERT INTO roundparticipation (tournament, round, parallel, player, position) V
    (SELECT player FROM players WHERE nick='Oliyzia'),
    4
 );
-INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
    (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
    1, 2,
    (SELECT player FROM players WHERE nick='Oliyzia'),
+   0,
    (SELECT song FROM songs WHERE lower(title)=lower('Don\'t Try to Stop It')),
    'f',
    6226);
-INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
    (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
    1, 2,
    (SELECT player FROM players WHERE nick='Oliyzia'),
+   1,
    (SELECT song FROM songs WHERE lower(title)=lower('Make A Jam!')),
    'f',
    6708);
-INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
    (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
    1, 2,
    (SELECT player FROM players WHERE nick='Oliyzia'),
+   2,
    (SELECT song FROM songs WHERE lower(title)=lower('Groove 2001')),
    't',
    6445);
@@ -311,24 +338,27 @@ INSERT INTO roundparticipation (tournament, round, parallel, player, position) V
    (SELECT player FROM players WHERE nick='OJK'),
    5
 );
-INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
    (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
    1, 2,
    (SELECT player FROM players WHERE nick='OJK'),
+   0,
    (SELECT song FROM songs WHERE lower(title)=lower('Don\'t Try to Stop It')),
    'f',
    7353);
-INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
    (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
    1, 2,
    (SELECT player FROM players WHERE nick='OJK'),
+   1,
    (SELECT song FROM songs WHERE lower(title)=lower('Make A Jam!')),
    'f',
    7214);
-INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
    (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
    1, 2,
    (SELECT player FROM players WHERE nick='OJK'),
+   2,
    (SELECT song FROM songs WHERE lower(title)=lower('www.blonde girl (MOMO Mix)')),
    't',
    6791);
@@ -358,24 +388,27 @@ INSERT INTO roundparticipation (tournament, round, parallel, player, position) V
    (SELECT player FROM players WHERE nick='Glukko'),
    1
 );
-INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
    (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
    1, 3,
    (SELECT player FROM players WHERE nick='Glukko'),
+   0,
    (SELECT song FROM songs WHERE lower(title)=lower('5, 6, 7, 8')),
    'f',
    4346);
-INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
    (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
    1, 3,
    (SELECT player FROM players WHERE nick='Glukko'),
+   1,
    (SELECT song FROM songs WHERE lower(title)=lower('So Deep (Perfect Sphere Mix)')),
    'f',
    3531);
-INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
    (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
    1, 3,
    (SELECT player FROM players WHERE nick='Glukko'),
+   2,
    (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love (SPEED MIX)')),
    't',
    5270);
@@ -386,17 +419,19 @@ INSERT INTO roundparticipation (tournament, round, parallel, player, position) V
    (SELECT player FROM players WHERE nick='Ole-Christian'),
    2
 );
-INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
    (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
    1, 3,
    (SELECT player FROM players WHERE nick='Ole-Christian'),
+   0,
    (SELECT song FROM songs WHERE lower(title)=lower('5, 6, 7, 8')),
    'f',
    0);
-INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
    (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
    1, 3,
    (SELECT player FROM players WHERE nick='Ole-Christian'),
+   1,
    (SELECT song FROM songs WHERE lower(title)=lower('So Deep (Perfect Sphere Mix)')),
    'f',
    0);
@@ -407,24 +442,27 @@ INSERT INTO roundparticipation (tournament, round, parallel, player, position) V
    (SELECT player FROM players WHERE nick='Zyc'),
    3
 );
-INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
    (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
    1, 3,
    (SELECT player FROM players WHERE nick='Zyc'),
+   0,
    (SELECT song FROM songs WHERE lower(title)=lower('5, 6, 7, 8')),
    'f',
    4898);
-INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
    (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
    1, 3,
    (SELECT player FROM players WHERE nick='Zyc'),
+   1,
    (SELECT song FROM songs WHERE lower(title)=lower('So Deep (Perfect Sphere Mix)')),
    'f',
    3333);
-INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
    (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
    1, 3,
    (SELECT player FROM players WHERE nick='Zyc'),
+   2,
    (SELECT song FROM songs WHERE lower(title)=lower('Jam Jam Reggae (AM Swing Mix)')),
    't',
    5149);
@@ -435,24 +473,27 @@ INSERT INTO roundparticipation (tournament, round, parallel, player, position) V
    (SELECT player FROM players WHERE nick='Ylini'),
    4
 );
-INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
    (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
    1, 3,
    (SELECT player FROM players WHERE nick='Ylini'),
+   0,
    (SELECT song FROM songs WHERE lower(title)=lower('5, 6, 7, 8')),
    'f',
    5189);
-INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
    (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
    1, 3,
    (SELECT player FROM players WHERE nick='Ylini'),
+   1,
    (SELECT song FROM songs WHERE lower(title)=lower('So Deep (Perfect Sphere Mix)')),
    'f',
    4391);
-INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
    (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
    1, 3,
    (SELECT player FROM players WHERE nick='Ylini'),
+   2,
    (SELECT song FROM songs WHERE lower(title)=lower('Jam Jam Reggae (AM Swing Mix)')),
    't',
    7298);
@@ -463,24 +504,27 @@ INSERT INTO roundparticipation (tournament, round, parallel, player, position) V
    (SELECT player FROM players WHERE nick='DufF'),
    5
 );
-INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
    (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
    1, 3,
    (SELECT player FROM players WHERE nick='DufF'),
+   0,
    (SELECT song FROM songs WHERE lower(title)=lower('5, 6, 7, 8')),
    'f',
    5822);
-INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
    (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
    1, 3,
    (SELECT player FROM players WHERE nick='DufF'),
+   1,
    (SELECT song FROM songs WHERE lower(title)=lower('So Deep (Perfect Sphere Mix)')),
    'f',
    8510);
-INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
    (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
    1, 3,
    (SELECT player FROM players WHERE nick='DufF'),
+   2,
    (SELECT song FROM songs WHERE lower(title)=lower('Trip Machine (Luv Mix)')),
    't',
    8504);
@@ -510,24 +554,27 @@ INSERT INTO roundparticipation (tournament, round, parallel, player, position) V
    (SELECT player FROM players WHERE nick='Th0rny'),
    1
 );
-INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
    (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
    1, 4,
    (SELECT player FROM players WHERE nick='Th0rny'),
+   0,
    (SELECT song FROM songs WHERE lower(title)=lower('Look to the sky')),
    'f',
    5789);
-INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
    (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
    1, 4,
    (SELECT player FROM players WHERE nick='Th0rny'),
+   1,
    (SELECT song FROM songs WHERE lower(title)=lower('Burnin\' the Floor')),
    'f',
    6214);
-INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
    (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
    1, 4,
    (SELECT player FROM players WHERE nick='Th0rny'),
+   2,
    (SELECT song FROM songs WHERE lower(title)=lower('Crash!')),
    't',
    8348);
@@ -538,24 +585,27 @@ INSERT INTO roundparticipation (tournament, round, parallel, player, position) V
    (SELECT player FROM players WHERE nick='Nameless'),
    2
 );
-INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
    (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
    1, 4,
    (SELECT player FROM players WHERE nick='Nameless'),
+   0,
    (SELECT song FROM songs WHERE lower(title)=lower('Look to the sky')),
    'f',
    5618);
-INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
    (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
    1, 4,
    (SELECT player FROM players WHERE nick='Nameless'),
+   1,
    (SELECT song FROM songs WHERE lower(title)=lower('Burnin\' the Floor')),
    'f',
    6326);
-INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
    (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
    1, 4,
    (SELECT player FROM players WHERE nick='Nameless'),
+   2,
    (SELECT song FROM songs WHERE lower(title)=lower('PARANOiA Rebirth')),
    't',
    8278);
@@ -566,24 +616,27 @@ INSERT INTO roundparticipation (tournament, round, parallel, player, position) V
    (SELECT player FROM players WHERE nick='Matsi'),
    3
 );
-INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
    (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
    1, 4,
    (SELECT player FROM players WHERE nick='Matsi'),
+   0,
    (SELECT song FROM songs WHERE lower(title)=lower('Look to the sky')),
    'f',
    4525);
-INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
    (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
    1, 4,
    (SELECT player FROM players WHERE nick='Matsi'),
+   1,
    (SELECT song FROM songs WHERE lower(title)=lower('Burnin\' the Floor')),
    'f',
    6008);
-INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
    (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
    1, 4,
    (SELECT player FROM players WHERE nick='Matsi'),
+   2,
    (SELECT song FROM songs WHERE lower(title)=lower('PARANOiA Rebirth')),
    't',
    7040);
@@ -594,24 +647,27 @@ INSERT INTO roundparticipation (tournament, round, parallel, player, position) V
    (SELECT player FROM players WHERE nick='Draconia'),
    4
 );
-INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
    (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
    1, 4,
    (SELECT player FROM players WHERE nick='Draconia'),
+   0,
    (SELECT song FROM songs WHERE lower(title)=lower('Look to the sky')),
    'f',
    5716);
-INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
    (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
    1, 4,
    (SELECT player FROM players WHERE nick='Draconia'),
+   1,
    (SELECT song FROM songs WHERE lower(title)=lower('Burnin\' the Floor')),
    'f',
    6169);
-INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
    (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
    1, 4,
    (SELECT player FROM players WHERE nick='Draconia'),
+   2,
    (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)')),
    't',
    7682);
@@ -622,24 +678,27 @@ INSERT INTO roundparticipation (tournament, round, parallel, player, position) V
    (SELECT player FROM players WHERE nick='RiChY'),
    5
 );
-INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
    (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
    1, 4,
    (SELECT player FROM players WHERE nick='RiChY'),
+   0,
    (SELECT song FROM songs WHERE lower(title)=lower('Look to the sky')),
    'f',
    6023);
-INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
    (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
    1, 4,
    (SELECT player FROM players WHERE nick='RiChY'),
+   1,
    (SELECT song FROM songs WHERE lower(title)=lower('Burnin\' the Floor')),
    'f',
    6628);
-INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
    (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
    1, 4,
    (SELECT player FROM players WHERE nick='RiChY'),
+   2,
    (SELECT song FROM songs WHERE lower(title)=lower('Healing Vision (Angelic Mix)')),
    't',
    8179);
@@ -669,24 +728,27 @@ INSERT INTO roundparticipation (tournament, round, parallel, player, position) V
    (SELECT player FROM players WHERE nick='Eruanna'),
    1
 );
-INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
    (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
    1, 5,
    (SELECT player FROM players WHERE nick='Eruanna'),
+   0,
    (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
    'f',
    5410);
-INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
    (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
    1, 5,
    (SELECT player FROM players WHERE nick='Eruanna'),
+   1,
    (SELECT song FROM songs WHERE lower(title)=lower('Dead End')),
    'f',
    4383);
-INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
    (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
    1, 5,
    (SELECT player FROM players WHERE nick='Eruanna'),
+   2,
    (SELECT song FROM songs WHERE lower(title)=lower('Jam Jam Reggae (AM Swing Mix)')),
    't',
    6040);
@@ -697,24 +759,27 @@ INSERT INTO roundparticipation (tournament, round, parallel, player, position) V
    (SELECT player FROM players WHERE nick='Advena'),
    2
 );
-INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
    (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
    1, 5,
    (SELECT player FROM players WHERE nick='Advena'),
+   0,
    (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
    'f',
    6729);
-INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
    (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
    1, 5,
    (SELECT player FROM players WHERE nick='Advena'),
+   1,
    (SELECT song FROM songs WHERE lower(title)=lower('Dead End')),
    'f',
    7069);
-INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
    (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
    1, 5,
    (SELECT player FROM players WHERE nick='Advena'),
+   2,
    (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)')),
    't',
    7624);
@@ -725,24 +790,27 @@ INSERT INTO roundparticipation (tournament, round, parallel, player, position) V
    (SELECT player FROM players WHERE nick='Tassen'),
    3
 );
-INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
    (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
    1, 5,
    (SELECT player FROM players WHERE nick='Tassen'),
+   0,
    (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
    'f',
    6911);
-INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
    (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
    1, 5,
    (SELECT player FROM players WHERE nick='Tassen'),
+   1,
    (SELECT song FROM songs WHERE lower(title)=lower('Dead End')),
    'f',
    6693);
-INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
    (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
    1, 5,
    (SELECT player FROM players WHERE nick='Tassen'),
+   2,
    (SELECT song FROM songs WHERE lower(title)=lower('Crash!')),
    't',
    7298);
@@ -753,24 +821,27 @@ INSERT INTO roundparticipation (tournament, round, parallel, player, position) V
    (SELECT player FROM players WHERE nick='Duckling'),
    4
 );
-INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
    (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
    1, 5,
    (SELECT player FROM players WHERE nick='Duckling'),
+   0,
    (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
    'f',
    8252);
-INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
    (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
    1, 5,
    (SELECT player FROM players WHERE nick='Duckling'),
+   1,
    (SELECT song FROM songs WHERE lower(title)=lower('Dead End')),
    'f',
    7357);
-INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
    (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
    1, 5,
    (SELECT player FROM players WHERE nick='Duckling'),
+   2,
    (SELECT song FROM songs WHERE lower(title)=lower('Jam Jam Reggae (AM Swing Mix)')),
    't',
    7321);
@@ -781,24 +852,27 @@ INSERT INTO roundparticipation (tournament, round, parallel, player, position) V
    (SELECT player FROM players WHERE nick='Olemann'),
    5
 );
-INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
    (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
    1, 5,
    (SELECT player FROM players WHERE nick='Olemann'),
+   0,
    (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
    'f',
    7471);
-INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
    (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
    1, 5,
    (SELECT player FROM players WHERE nick='Olemann'),
+   1,
    (SELECT song FROM songs WHERE lower(title)=lower('Dead End')),
    'f',
    7919);
-INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
    (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
    1, 5,
    (SELECT player FROM players WHERE nick='Olemann'),
+   2,
    (SELECT song FROM songs WHERE lower(title)=lower('Crash!')),
    't',
    8043);
@@ -809,24 +883,27 @@ INSERT INTO roundparticipation (tournament, round, parallel, player, position) V
    (SELECT player FROM players WHERE nick='T|na'),
    6
 );
-INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
    (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
    1, 5,
    (SELECT player FROM players WHERE nick='T|na'),
+   0,
    (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
    'f',
    8546);
-INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
    (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
    1, 5,
    (SELECT player FROM players WHERE nick='T|na'),
+   1,
    (SELECT song FROM songs WHERE lower(title)=lower('Dead End')),
    'f',
    7881);
-INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
    (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
    1, 5,
    (SELECT player FROM players WHERE nick='T|na'),
+   2,
    (SELECT song FROM songs WHERE lower(title)=lower('Jam Jam Reggae (AM Swing Mix)')),
    't',
    7740);
@@ -856,24 +933,27 @@ INSERT INTO roundparticipation (tournament, round, parallel, player, position) V
    (SELECT player FROM players WHERE nick='Bonzo'),
    1
 );
-INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
    (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
    1, 6,
    (SELECT player FROM players WHERE nick='Bonzo'),
+   0,
    (SELECT song FROM songs WHERE lower(title)=lower('The Reflex')),
    'f',
    4564);
-INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
    (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
    1, 6,
    (SELECT player FROM players WHERE nick='Bonzo'),
+   1,
    (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love (SPEED MIX)')),
    'f',
    6212);
-INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
    (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
    1, 6,
    (SELECT player FROM players WHERE nick='Bonzo'),
+   2,
    (SELECT song FROM songs WHERE lower(title)=lower('Crash!')),
    't',
    7211);
@@ -884,24 +964,27 @@ INSERT INTO roundparticipation (tournament, round, parallel, player, position) V
    (SELECT player FROM players WHERE nick='Gollum'),
    2
 );
-INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
    (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
    1, 6,
    (SELECT player FROM players WHERE nick='Gollum'),
+   0,
    (SELECT song FROM songs WHERE lower(title)=lower('The Reflex')),
    'f',
    3139);
-INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
    (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
    1, 6,
    (SELECT player FROM players WHERE nick='Gollum'),
+   1,
    (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love (SPEED MIX)')),
    'f',
    5655);
-INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
    (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
    1, 6,
    (SELECT player FROM players WHERE nick='Gollum'),
+   2,
    (SELECT song FROM songs WHERE lower(title)=lower('Jam Jam Reggae (AM Swing Mix)')),
    't',
    6369);
@@ -912,24 +995,27 @@ INSERT INTO roundparticipation (tournament, round, parallel, player, position) V
    (SELECT player FROM players WHERE nick='Hugo'),
    3
 );
-INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
    (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
    1, 6,
    (SELECT player FROM players WHERE nick='Hugo'),
+   0,
    (SELECT song FROM songs WHERE lower(title)=lower('The Reflex')),
    'f',
    6888);
-INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
    (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
    1, 6,
    (SELECT player FROM players WHERE nick='Hugo'),
+   1,
    (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love (SPEED MIX)')),
    'f',
    8521);
-INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
    (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
    1, 6,
    (SELECT player FROM players WHERE nick='Hugo'),
+   2,
    (SELECT song FROM songs WHERE lower(title)=lower('era (nostalmix)')),
    't',
    7439);
@@ -940,24 +1026,27 @@ INSERT INTO roundparticipation (tournament, round, parallel, player, position) V
    (SELECT player FROM players WHERE nick='Auran'),
    4
 );
-INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
    (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
    1, 6,
    (SELECT player FROM players WHERE nick='Auran'),
+   0,
    (SELECT song FROM songs WHERE lower(title)=lower('The Reflex')),
    'f',
    3300);
-INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
    (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
    1, 6,
    (SELECT player FROM players WHERE nick='Auran'),
+   1,
    (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love (SPEED MIX)')),
    'f',
    3813);
-INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
    (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
    1, 6,
    (SELECT player FROM players WHERE nick='Auran'),
+   2,
    (SELECT song FROM songs WHERE lower(title)=lower('Silent Hill')),
    't',
    4377);
@@ -968,24 +1057,27 @@ INSERT INTO roundparticipation (tournament, round, parallel, player, position) V
    (SELECT player FROM players WHERE nick='Smiph'),
    5
 );
-INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
    (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
    1, 6,
    (SELECT player FROM players WHERE nick='Smiph'),
+   0,
    (SELECT song FROM songs WHERE lower(title)=lower('The Reflex')),
    'f',
    5696);
-INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
    (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
    1, 6,
    (SELECT player FROM players WHERE nick='Smiph'),
+   1,
    (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love (SPEED MIX)')),
    'f',
    7569);
-INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
    (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
    1, 6,
    (SELECT player FROM players WHERE nick='Smiph'),
+   2,
    (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
    't',
    7703);
@@ -996,24 +1088,27 @@ INSERT INTO roundparticipation (tournament, round, parallel, player, position) V
    (SELECT player FROM players WHERE nick='Stream'),
    6
 );
-INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
    (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
    1, 6,
    (SELECT player FROM players WHERE nick='Stream'),
+   0,
    (SELECT song FROM songs WHERE lower(title)=lower('The Reflex')),
    'f',
    5989);
-INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
    (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
    1, 6,
    (SELECT player FROM players WHERE nick='Stream'),
+   1,
    (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love (SPEED MIX)')),
    'f',
    7689);
-INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
    (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
    1, 6,
    (SELECT player FROM players WHERE nick='Stream'),
+   2,
    (SELECT song FROM songs WHERE lower(title)=lower('Crash!')),
    't',
    8064);
@@ -1048,24 +1143,27 @@ INSERT INTO roundparticipation (tournament, round, parallel, player, position) V
    (SELECT player FROM players WHERE nick='Smiph'),
    1
 );
-INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
    (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
    2, 1,
    (SELECT player FROM players WHERE nick='Smiph'),
+   0,
    (SELECT song FROM songs WHERE lower(title)=lower('Love This Feelin\'')),
    'f',
    5825);
-INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
    (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
    2, 1,
    (SELECT player FROM players WHERE nick='Smiph'),
+   1,
    (SELECT song FROM songs WHERE lower(title)=lower('I Want You To Want Me')),
    'f',
    4790);
-INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
    (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
    2, 1,
    (SELECT player FROM players WHERE nick='Smiph'),
+   2,
    (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)')),
    't',
    7961);
@@ -1076,24 +1174,27 @@ INSERT INTO roundparticipation (tournament, round, parallel, player, position) V
    (SELECT player FROM players WHERE nick='Mulefisk'),
    2
 );
-INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
    (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
    2, 1,
    (SELECT player FROM players WHERE nick='Mulefisk'),
+   0,
    (SELECT song FROM songs WHERE lower(title)=lower('Love This Feelin\'')),
    'f',
    6533);
-INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
    (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
    2, 1,
    (SELECT player FROM players WHERE nick='Mulefisk'),
+   1,
    (SELECT song FROM songs WHERE lower(title)=lower('I Want You To Want Me')),
    'f',
    5504);
-INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
    (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
    2, 1,
    (SELECT player FROM players WHERE nick='Mulefisk'),
+   2,
    (SELECT song FROM songs WHERE lower(title)=lower('Exotic Ethnic')),
    't',
    7989);
@@ -1104,24 +1205,27 @@ INSERT INTO roundparticipation (tournament, round, parallel, player, position) V
    (SELECT player FROM players WHERE nick='Oliyzia'),
    3
 );
-INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
    (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
    2, 1,
    (SELECT player FROM players WHERE nick='Oliyzia'),
+   0,
    (SELECT song FROM songs WHERE lower(title)=lower('Love This Feelin\'')),
    'f',
    7101);
-INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
    (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
    2, 1,
    (SELECT player FROM players WHERE nick='Oliyzia'),
+   1,
    (SELECT song FROM songs WHERE lower(title)=lower('I Want You To Want Me')),
    'f',
    5725);
-INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
    (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
    2, 1,
    (SELECT player FROM players WHERE nick='Oliyzia'),
+   2,
    (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)')),
    't',
    8713);
@@ -1132,24 +1236,27 @@ INSERT INTO roundparticipation (tournament, round, parallel, player, position) V
    (SELECT player FROM players WHERE nick='Th0rny'),
    4
 );
-INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
    (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
    2, 1,
    (SELECT player FROM players WHERE nick='Th0rny'),
+   0,
    (SELECT song FROM songs WHERE lower(title)=lower('Love This Feelin\'')),
    'f',
    6377);
-INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
    (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
    2, 1,
    (SELECT player FROM players WHERE nick='Th0rny'),
+   1,
    (SELECT song FROM songs WHERE lower(title)=lower('I Want You To Want Me')),
    'f',
    4994);
-INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
    (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
    2, 1,
    (SELECT player FROM players WHERE nick='Th0rny'),
+   2,
    (SELECT song FROM songs WHERE lower(title)=lower('Dead End')),
    't',
    8140);
@@ -1160,24 +1267,27 @@ INSERT INTO roundparticipation (tournament, round, parallel, player, position) V
    (SELECT player FROM players WHERE nick='OJK'),
    5
 );
-INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
    (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
    2, 1,
    (SELECT player FROM players WHERE nick='OJK'),
+   0,
    (SELECT song FROM songs WHERE lower(title)=lower('Love This Feelin\'')),
    'f',
    7140);
-INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
    (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
    2, 1,
    (SELECT player FROM players WHERE nick='OJK'),
+   1,
    (SELECT song FROM songs WHERE lower(title)=lower('I Want You To Want Me')),
    'f',
    5515);
-INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
    (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
    2, 1,
    (SELECT player FROM players WHERE nick='OJK'),
+   2,
    (SELECT song FROM songs WHERE lower(title)=lower('Trip Machine (Luv Mix)')),
    't',
    8310);
@@ -1188,24 +1298,27 @@ INSERT INTO roundparticipation (tournament, round, parallel, player, position) V
    (SELECT player FROM players WHERE nick='T|na'),
    6
 );
-INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
    (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
    2, 1,
    (SELECT player FROM players WHERE nick='T|na'),
+   0,
    (SELECT song FROM songs WHERE lower(title)=lower('Love This Feelin\'')),
    'f',
    6447);
-INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
    (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
    2, 1,
    (SELECT player FROM players WHERE nick='T|na'),
+   1,
    (SELECT song FROM songs WHERE lower(title)=lower('I Want You To Want Me')),
    'f',
    5518);
-INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
    (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
    2, 1,
    (SELECT player FROM players WHERE nick='T|na'),
+   2,
    (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)')),
    't',
    8271);
@@ -1235,24 +1348,27 @@ INSERT INTO roundparticipation (tournament, round, parallel, player, position) V
    (SELECT player FROM players WHERE nick='Dabi'),
    1
 );
-INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
    (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
    2, 2,
    (SELECT player FROM players WHERE nick='Dabi'),
+   0,
    (SELECT song FROM songs WHERE lower(title)=lower('La Senorita')),
    'f',
    4394);
-INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
    (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
    2, 2,
    (SELECT player FROM players WHERE nick='Dabi'),
+   1,
    (SELECT song FROM songs WHERE lower(title)=lower('Ecstasy')),
    'f',
    4295);
-INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
    (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
    2, 2,
    (SELECT player FROM players WHERE nick='Dabi'),
+   2,
    (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
    't',
    6188);
@@ -1263,24 +1379,27 @@ INSERT INTO roundparticipation (tournament, round, parallel, player, position) V
    (SELECT player FROM players WHERE nick='Duckling'),
    2
 );
-INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
    (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
    2, 2,
    (SELECT player FROM players WHERE nick='Duckling'),
+   0,
    (SELECT song FROM songs WHERE lower(title)=lower('La Senorita')),
    'f',
    5898);
-INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
    (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
    2, 2,
    (SELECT player FROM players WHERE nick='Duckling'),
+   1,
    (SELECT song FROM songs WHERE lower(title)=lower('Ecstasy')),
    'f',
    5857);
-INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
    (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
    2, 2,
    (SELECT player FROM players WHERE nick='Duckling'),
+   2,
    (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
    't',
    8053);
@@ -1291,24 +1410,27 @@ INSERT INTO roundparticipation (tournament, round, parallel, player, position) V
    (SELECT player FROM players WHERE nick='Ylini'),
    3
 );
-INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
    (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
    2, 2,
    (SELECT player FROM players WHERE nick='Ylini'),
+   0,
    (SELECT song FROM songs WHERE lower(title)=lower('La Senorita')),
    'f',
    5873);
-INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
    (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
    2, 2,
    (SELECT player FROM players WHERE nick='Ylini'),
+   1,
    (SELECT song FROM songs WHERE lower(title)=lower('Ecstasy')),
    'f',
    5881);
-INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
    (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
    2, 2,
    (SELECT player FROM players WHERE nick='Ylini'),
+   2,
    (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)')),
    't',
    8283);
@@ -1319,24 +1441,27 @@ INSERT INTO roundparticipation (tournament, round, parallel, player, position) V
    (SELECT player FROM players WHERE nick='Stream'),
    4
 );
-INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
    (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
    2, 2,
    (SELECT player FROM players WHERE nick='Stream'),
+   0,
    (SELECT song FROM songs WHERE lower(title)=lower('La Senorita')),
    'f',
    5820);
-INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
    (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
    2, 2,
    (SELECT player FROM players WHERE nick='Stream'),
+   1,
    (SELECT song FROM songs WHERE lower(title)=lower('Ecstasy')),
    'f',
    6437);
-INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
    (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
    2, 2,
    (SELECT player FROM players WHERE nick='Stream'),
+   2,
    (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
    't',
    8232);
@@ -1347,24 +1472,27 @@ INSERT INTO roundparticipation (tournament, round, parallel, player, position) V
    (SELECT player FROM players WHERE nick='Snute'),
    5
 );
-INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
    (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
    2, 2,
    (SELECT player FROM players WHERE nick='Snute'),
+   0,
    (SELECT song FROM songs WHERE lower(title)=lower('La Senorita')),
    'f',
    6509);
-INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
    (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
    2, 2,
    (SELECT player FROM players WHERE nick='Snute'),
+   1,
    (SELECT song FROM songs WHERE lower(title)=lower('Ecstasy')),
    'f',
    6858);
-INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
    (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
    2, 2,
    (SELECT player FROM players WHERE nick='Snute'),
+   2,
    (SELECT song FROM songs WHERE lower(title)=lower('Dynamite Rave')),
    't',
    8420);
@@ -1375,24 +1503,27 @@ INSERT INTO roundparticipation (tournament, round, parallel, player, position) V
    (SELECT player FROM players WHERE nick='Hugo'),
    6
 );
-INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
    (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
    2, 2,
    (SELECT player FROM players WHERE nick='Hugo'),
+   0,
    (SELECT song FROM songs WHERE lower(title)=lower('La Senorita')),
    'f',
    6424);
-INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
    (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
    2, 2,
    (SELECT player FROM players WHERE nick='Hugo'),
+   1,
    (SELECT song FROM songs WHERE lower(title)=lower('Ecstasy')),
    'f',
    6499);
-INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
    (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
    2, 2,
    (SELECT player FROM players WHERE nick='Hugo'),
+   2,
    (SELECT song FROM songs WHERE lower(title)=lower('Trip Machine Climax')),
    't',
    8601);
@@ -1422,24 +1553,27 @@ INSERT INTO roundparticipation (tournament, round, parallel, player, position) V
    (SELECT player FROM players WHERE nick='Zyc'),
    1
 );
-INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
    (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
    2, 3,
    (SELECT player FROM players WHERE nick='Zyc'),
+   0,
    (SELECT song FROM songs WHERE lower(title)=lower('Exotic Ethnic')),
    'f',
    3711);
-INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
    (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
    2, 3,
    (SELECT player FROM players WHERE nick='Zyc'),
+   1,
    (SELECT song FROM songs WHERE lower(title)=lower('Stomp')),
    'f',
    3767);
-INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
    (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
    2, 3,
    (SELECT player FROM players WHERE nick='Zyc'),
+   2,
    (SELECT song FROM songs WHERE lower(title)=lower('Max 300')),
    't',
    0);
@@ -1450,24 +1584,27 @@ INSERT INTO roundparticipation (tournament, round, parallel, player, position) V
    (SELECT player FROM players WHERE nick='Nameless'),
    2
 );
-INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
    (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
    2, 3,
    (SELECT player FROM players WHERE nick='Nameless'),
+   0,
    (SELECT song FROM songs WHERE lower(title)=lower('Exotic Ethnic')),
    'f',
    8621);
-INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
    (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
    2, 3,
    (SELECT player FROM players WHERE nick='Nameless'),
+   1,
    (SELECT song FROM songs WHERE lower(title)=lower('Stomp')),
    'f',
    5773);
-INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
    (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
    2, 3,
    (SELECT player FROM players WHERE nick='Nameless'),
+   2,
    (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)')),
    't',
    6811);
@@ -1478,24 +1615,27 @@ INSERT INTO roundparticipation (tournament, round, parallel, player, position) V
    (SELECT player FROM players WHERE nick='Haggar'),
    3
 );
-INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
    (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
    2, 3,
    (SELECT player FROM players WHERE nick='Haggar'),
+   0,
    (SELECT song FROM songs WHERE lower(title)=lower('Exotic Ethnic')),
    'f',
    8853);
-INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
    (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
    2, 3,
    (SELECT player FROM players WHERE nick='Haggar'),
+   1,
    (SELECT song FROM songs WHERE lower(title)=lower('Stomp')),
    'f',
    5898);
-INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
    (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
    2, 3,
    (SELECT player FROM players WHERE nick='Haggar'),
+   2,
    (SELECT song FROM songs WHERE lower(title)=lower('PARANOiA Rebirth')),
    't',
    8750);
@@ -1506,24 +1646,27 @@ INSERT INTO roundparticipation (tournament, round, parallel, player, position) V
    (SELECT player FROM players WHERE nick='Olemann'),
    4
 );
-INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
    (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
    2, 3,
    (SELECT player FROM players WHERE nick='Olemann'),
+   0,
    (SELECT song FROM songs WHERE lower(title)=lower('Exotic Ethnic')),
    'f',
    6836);
-INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
    (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
    2, 3,
    (SELECT player FROM players WHERE nick='Olemann'),
+   1,
    (SELECT song FROM songs WHERE lower(title)=lower('Stomp')),
    'f',
    5513);
-INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
    (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
    2, 3,
    (SELECT player FROM players WHERE nick='Olemann'),
+   2,
    (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love (SPEED MIX)')),
    't',
    7941);
@@ -1534,24 +1677,27 @@ INSERT INTO roundparticipation (tournament, round, parallel, player, position) V
    (SELECT player FROM players WHERE nick='RiChY'),
    5
 );
-INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
    (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
    2, 3,
    (SELECT player FROM players WHERE nick='RiChY'),
+   0,
    (SELECT song FROM songs WHERE lower(title)=lower('Exotic Ethnic')),
    'f',
    8490);
-INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
    (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
    2, 3,
    (SELECT player FROM players WHERE nick='RiChY'),
+   1,
    (SELECT song FROM songs WHERE lower(title)=lower('Stomp')),
    'f',
    6341);
-INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
    (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
    2, 3,
    (SELECT player FROM players WHERE nick='RiChY'),
+   2,
    (SELECT song FROM songs WHERE lower(title)=lower('PARANOiA Rebirth')),
    't',
    8630);
@@ -1562,24 +1708,27 @@ INSERT INTO roundparticipation (tournament, round, parallel, player, position) V
    (SELECT player FROM players WHERE nick='DufF'),
    6
 );
-INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
    (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
    2, 3,
    (SELECT player FROM players WHERE nick='DufF'),
+   0,
    (SELECT song FROM songs WHERE lower(title)=lower('Exotic Ethnic')),
    'f',
    8781);
-INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
    (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
    2, 3,
    (SELECT player FROM players WHERE nick='DufF'),
+   1,
    (SELECT song FROM songs WHERE lower(title)=lower('Stomp')),
    'f',
    6211);
-INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
    (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
    2, 3,
    (SELECT player FROM players WHERE nick='DufF'),
+   2,
    (SELECT song FROM songs WHERE lower(title)=lower('Afronova')),
    't',
    8384);
@@ -1609,17 +1758,19 @@ INSERT INTO roundparticipation (tournament, round, parallel, player, position) V
    (SELECT player FROM players WHERE nick='Stream'),
    1
 );
-INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
    (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
    3, 0,
    (SELECT player FROM players WHERE nick='Stream'),
+   0,
    (SELECT song FROM songs WHERE lower(title)=lower('Memories')),
    'f',
    6565);
-INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
    (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
    3, 0,
    (SELECT player FROM players WHERE nick='Stream'),
+   1,
    (SELECT song FROM songs WHERE lower(title)=lower('Dead End')),
    't',
    7765);
@@ -1630,17 +1781,19 @@ INSERT INTO roundparticipation (tournament, round, parallel, player, position) V
    (SELECT player FROM players WHERE nick='T|na'),
    2
 );
-INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
    (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
    3, 0,
    (SELECT player FROM players WHERE nick='T|na'),
+   0,
    (SELECT song FROM songs WHERE lower(title)=lower('Memories')),
    'f',
    6520);
-INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
    (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
    3, 0,
    (SELECT player FROM players WHERE nick='T|na'),
+   1,
    (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
    't',
    8489);
@@ -1651,17 +1804,19 @@ INSERT INTO roundparticipation (tournament, round, parallel, player, position) V
    (SELECT player FROM players WHERE nick='DufF'),
    3
 );
-INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
    (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
    3, 0,
    (SELECT player FROM players WHERE nick='DufF'),
+   0,
    (SELECT song FROM songs WHERE lower(title)=lower('Memories')),
    'f',
    7553);
-INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
    (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
    3, 0,
    (SELECT player FROM players WHERE nick='DufF'),
+   1,
    (SELECT song FROM songs WHERE lower(title)=lower('Trip Machine Climax')),
    't',
    8621);
@@ -1672,17 +1827,19 @@ INSERT INTO roundparticipation (tournament, round, parallel, player, position) V
    (SELECT player FROM players WHERE nick='OJK'),
    4
 );
-INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
    (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
    3, 0,
    (SELECT player FROM players WHERE nick='OJK'),
+   0,
    (SELECT song FROM songs WHERE lower(title)=lower('Memories')),
    'f',
    7015);
-INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
    (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
    3, 0,
    (SELECT player FROM players WHERE nick='OJK'),
+   1,
    (SELECT song FROM songs WHERE lower(title)=lower('Candy')),
    't',
    8627);
@@ -1693,17 +1850,19 @@ INSERT INTO roundparticipation (tournament, round, parallel, player, position) V
    (SELECT player FROM players WHERE nick='Hugo'),
    5
 );
-INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
    (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
    3, 0,
    (SELECT player FROM players WHERE nick='Hugo'),
+   0,
    (SELECT song FROM songs WHERE lower(title)=lower('Memories')),
    'f',
    7258);
-INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
    (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
    3, 0,
    (SELECT player FROM players WHERE nick='Hugo'),
+   1,
    (SELECT song FROM songs WHERE lower(title)=lower('Tsugaru')),
    't',
    8228);
@@ -1714,17 +1873,19 @@ INSERT INTO roundparticipation (tournament, round, parallel, player, position) V
    (SELECT player FROM players WHERE nick='RiChY'),
    6
 );
-INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
    (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
    3, 0,
    (SELECT player FROM players WHERE nick='RiChY'),
+   0,
    (SELECT song FROM songs WHERE lower(title)=lower('Memories')),
    'f',
    7143);
-INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
    (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
    3, 0,
    (SELECT player FROM players WHERE nick='RiChY'),
+   1,
    (SELECT song FROM songs WHERE lower(title)=lower('Dead End')),
    't',
    8453);
@@ -1735,17 +1896,19 @@ INSERT INTO roundparticipation (tournament, round, parallel, player, position) V
    (SELECT player FROM players WHERE nick='Snute'),
    7
 );
-INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
    (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
    3, 0,
    (SELECT player FROM players WHERE nick='Snute'),
+   0,
    (SELECT song FROM songs WHERE lower(title)=lower('Memories')),
    'f',
    7605);
-INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
    (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
    3, 0,
    (SELECT player FROM players WHERE nick='Snute'),
+   1,
    (SELECT song FROM songs WHERE lower(title)=lower('So Deep (Perfect Sphere Mix)')),
    't',
    8374);
@@ -1756,17 +1919,19 @@ INSERT INTO roundparticipation (tournament, round, parallel, player, position) V
    (SELECT player FROM players WHERE nick='Oliyzia'),
    8
 );
-INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
    (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
    3, 0,
    (SELECT player FROM players WHERE nick='Oliyzia'),
+   0,
    (SELECT song FROM songs WHERE lower(title)=lower('Memories')),
    'f',
    7185);
-INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
    (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
    3, 0,
    (SELECT player FROM players WHERE nick='Oliyzia'),
+   1,
    (SELECT song FROM songs WHERE lower(title)=lower('Tsugaru')),
    't',
    8475);
@@ -1777,17 +1942,19 @@ INSERT INTO roundparticipation (tournament, round, parallel, player, position) V
    (SELECT player FROM players WHERE nick='Haggar'),
    9
 );
-INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
    (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
    3, 0,
    (SELECT player FROM players WHERE nick='Haggar'),
+   0,
    (SELECT song FROM songs WHERE lower(title)=lower('Memories')),
    'f',
    6892);
-INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
    (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
    3, 0,
    (SELECT player FROM players WHERE nick='Haggar'),
+   1,
    (SELECT song FROM songs WHERE lower(title)=lower('Dead End')),
    't',
    8468);
@@ -1817,17 +1984,19 @@ INSERT INTO roundparticipation (tournament, round, parallel, player, position) V
    (SELECT player FROM players WHERE nick='Haggar'),
    1
 );
-INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
    (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
    4, 0,
    (SELECT player FROM players WHERE nick='Haggar'),
+   0,
    (SELECT song FROM songs WHERE lower(title)=lower('era (nostalmix)')),
    'f',
    7528);
-INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
    (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
    4, 0,
    (SELECT player FROM players WHERE nick='Haggar'),
+   1,
    (SELECT song FROM songs WHERE lower(title)=lower('Trip Machine Climax')),
    't',
    8273);
@@ -1838,17 +2007,19 @@ INSERT INTO roundparticipation (tournament, round, parallel, player, position) V
    (SELECT player FROM players WHERE nick='Hugo'),
    2
 );
-INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
    (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
    4, 0,
    (SELECT player FROM players WHERE nick='Hugo'),
+   0,
    (SELECT song FROM songs WHERE lower(title)=lower('era (nostalmix)')),
    'f',
    7376);
-INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
    (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
    4, 0,
    (SELECT player FROM players WHERE nick='Hugo'),
+   1,
    (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
    't',
    8693);
@@ -1859,17 +2030,19 @@ INSERT INTO roundparticipation (tournament, round, parallel, player, position) V
    (SELECT player FROM players WHERE nick='RiChY'),
    3
 );
-INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
    (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
    4, 0,
    (SELECT player FROM players WHERE nick='RiChY'),
+   0,
    (SELECT song FROM songs WHERE lower(title)=lower('era (nostalmix)')),
    'f',
    7371);
-INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
    (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
    4, 0,
    (SELECT player FROM players WHERE nick='RiChY'),
+   1,
    (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
    't',
    8723);
@@ -1880,17 +2053,19 @@ INSERT INTO roundparticipation (tournament, round, parallel, player, position) V
    (SELECT player FROM players WHERE nick='OJK'),
    4
 );
-INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
    (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
    4, 0,
    (SELECT player FROM players WHERE nick='OJK'),
+   0,
    (SELECT song FROM songs WHERE lower(title)=lower('era (nostalmix)')),
    'f',
    7282);
-INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
    (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
    4, 0,
    (SELECT player FROM players WHERE nick='OJK'),
+   1,
    (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
    't',
    8778);
@@ -1901,17 +2076,19 @@ INSERT INTO roundparticipation (tournament, round, parallel, player, position) V
    (SELECT player FROM players WHERE nick='Oliyzia'),
    5
 );
-INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
    (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
    4, 0,
    (SELECT player FROM players WHERE nick='Oliyzia'),
+   0,
    (SELECT song FROM songs WHERE lower(title)=lower('era (nostalmix)')),
    'f',
    7352);
-INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
    (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
    4, 0,
    (SELECT player FROM players WHERE nick='Oliyzia'),
+   1,
    (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
    't',
    8808);
@@ -1922,17 +2099,19 @@ INSERT INTO roundparticipation (tournament, round, parallel, player, position) V
    (SELECT player FROM players WHERE nick='Snute'),
    6
 );
-INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
    (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
    4, 0,
    (SELECT player FROM players WHERE nick='Snute'),
+   0,
    (SELECT song FROM songs WHERE lower(title)=lower('era (nostalmix)')),
    'f',
    7606);
-INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
    (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
    4, 0,
    (SELECT player FROM players WHERE nick='Snute'),
+   1,
    (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love (SPEED MIX)')),
    't',
    8748);
@@ -1943,17 +2122,19 @@ INSERT INTO roundparticipation (tournament, round, parallel, player, position) V
    (SELECT player FROM players WHERE nick='DufF'),
    7
 );
-INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
    (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
    4, 0,
    (SELECT player FROM players WHERE nick='DufF'),
+   0,
    (SELECT song FROM songs WHERE lower(title)=lower('era (nostalmix)')),
    'f',
    7572);
-INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
    (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
    4, 0,
    (SELECT player FROM players WHERE nick='DufF'),
+   1,
    (SELECT song FROM songs WHERE lower(title)=lower('So Deep (Perfect Sphere Mix)')),
    't',
    8555);
@@ -1983,17 +2164,19 @@ INSERT INTO roundparticipation (tournament, round, parallel, player, position) V
    (SELECT player FROM players WHERE nick='Hugo'),
    1
 );
-INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
    (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
    5, 0,
    (SELECT player FROM players WHERE nick='Hugo'),
+   0,
    (SELECT song FROM songs WHERE lower(title)=lower('B4U')),
    'f',
    7573);
-INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
    (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
    5, 0,
    (SELECT player FROM players WHERE nick='Hugo'),
+   1,
    (SELECT song FROM songs WHERE lower(title)=lower('Exotic Ethnic')),
    't',
    8539);
@@ -2004,17 +2187,19 @@ INSERT INTO roundparticipation (tournament, round, parallel, player, position) V
    (SELECT player FROM players WHERE nick='RiChY'),
    2
 );
-INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
    (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
    5, 0,
    (SELECT player FROM players WHERE nick='RiChY'),
+   0,
    (SELECT song FROM songs WHERE lower(title)=lower('B4U')),
    'f',
    7586);
-INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
    (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
    5, 0,
    (SELECT player FROM players WHERE nick='RiChY'),
+   1,
    (SELECT song FROM songs WHERE lower(title)=lower('Max 300')),
    't',
    8349);
@@ -2025,17 +2210,19 @@ INSERT INTO roundparticipation (tournament, round, parallel, player, position) V
    (SELECT player FROM players WHERE nick='DufF'),
    3
 );
-INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
    (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
    5, 0,
    (SELECT player FROM players WHERE nick='DufF'),
+   0,
    (SELECT song FROM songs WHERE lower(title)=lower('B4U')),
    'f',
    7742);
-INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
    (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
    5, 0,
    (SELECT player FROM players WHERE nick='DufF'),
+   1,
    (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)')),
    't',
    8914);
@@ -2046,17 +2233,19 @@ INSERT INTO roundparticipation (tournament, round, parallel, player, position) V
    (SELECT player FROM players WHERE nick='Oliyzia'),
    4
 );
-INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
    (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
    5, 0,
    (SELECT player FROM players WHERE nick='Oliyzia'),
+   0,
    (SELECT song FROM songs WHERE lower(title)=lower('B4U')),
    'f',
    7692);
-INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
    (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
    5, 0,
    (SELECT player FROM players WHERE nick='Oliyzia'),
+   1,
    (SELECT song FROM songs WHERE lower(title)=lower('PARANOiA Rebirth')),
    't',
    8612);
@@ -2067,17 +2256,19 @@ INSERT INTO roundparticipation (tournament, round, parallel, player, position) V
    (SELECT player FROM players WHERE nick='Snute'),
    5
 );
-INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
    (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
    5, 0,
    (SELECT player FROM players WHERE nick='Snute'),
+   0,
    (SELECT song FROM songs WHERE lower(title)=lower('B4U')),
    'f',
    7830);
-INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
    (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
    5, 0,
    (SELECT player FROM players WHERE nick='Snute'),
+   1,
    (SELECT song FROM songs WHERE lower(title)=lower('PARANOiA Rebirth')),
    't',
    8782);
@@ -2107,17 +2298,19 @@ INSERT INTO roundparticipation (tournament, round, parallel, player, position) V
    (SELECT player FROM players WHERE nick='Hugo'),
    1
 );
-INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
    (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
    6, 0,
    (SELECT player FROM players WHERE nick='Hugo'),
+   0,
    (SELECT song FROM songs WHERE lower(title)=lower('B4U (B4 Za Beat Mix)')),
    'f',
    6376);
-INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
    (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
    6, 0,
    (SELECT player FROM players WHERE nick='Hugo'),
+   1,
    (SELECT song FROM songs WHERE lower(title)=lower('PARANOiA Rebirth')),
    't',
    8635);
@@ -2128,17 +2321,19 @@ INSERT INTO roundparticipation (tournament, round, parallel, player, position) V
    (SELECT player FROM players WHERE nick='Oliyzia'),
    2
 );
-INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
    (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
    6, 0,
    (SELECT player FROM players WHERE nick='Oliyzia'),
+   0,
    (SELECT song FROM songs WHERE lower(title)=lower('B4U (B4 Za Beat Mix)')),
    'f',
    6094);
-INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
    (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
    6, 0,
    (SELECT player FROM players WHERE nick='Oliyzia'),
+   1,
    (SELECT song FROM songs WHERE lower(title)=lower('Crash!')),
    't',
    8264);
@@ -2149,17 +2344,19 @@ INSERT INTO roundparticipation (tournament, round, parallel, player, position) V
    (SELECT player FROM players WHERE nick='Snute'),
    3
 );
-INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
    (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
    6, 0,
    (SELECT player FROM players WHERE nick='Snute'),
+   0,
    (SELECT song FROM songs WHERE lower(title)=lower('B4U (B4 Za Beat Mix)')),
    'f',
    6623);
-INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
    (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
    6, 0,
    (SELECT player FROM players WHERE nick='Snute'),
+   1,
    (SELECT song FROM songs WHERE lower(title)=lower('Crash!')),
    't',
    8828);
@@ -2170,17 +2367,19 @@ INSERT INTO roundparticipation (tournament, round, parallel, player, position) V
    (SELECT player FROM players WHERE nick='DufF'),
    4
 );
-INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
    (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
    6, 0,
    (SELECT player FROM players WHERE nick='DufF'),
+   0,
    (SELECT song FROM songs WHERE lower(title)=lower('B4U (B4 Za Beat Mix)')),
    'f',
    6455);
-INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
    (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
    6, 0,
    (SELECT player FROM players WHERE nick='DufF'),
+   1,
    (SELECT song FROM songs WHERE lower(title)=lower('PARANOiA Rebirth')),
    't',
    8728);
@@ -2210,17 +2409,19 @@ INSERT INTO roundparticipation (tournament, round, parallel, player, position) V
    (SELECT player FROM players WHERE nick='Hugo'),
    1
 );
-INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
    (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
    7, 0,
    (SELECT player FROM players WHERE nick='Hugo'),
+   0,
    (SELECT song FROM songs WHERE lower(title)=lower('Tsugaru')),
    'f',
    8273);
-INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
    (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
    7, 0,
    (SELECT player FROM players WHERE nick='Hugo'),
+   1,
    (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love (SPEED MIX)')),
    't',
    8169);
@@ -2231,17 +2432,19 @@ INSERT INTO roundparticipation (tournament, round, parallel, player, position) V
    (SELECT player FROM players WHERE nick='DufF'),
    2
 );
-INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
    (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
    7, 0,
    (SELECT player FROM players WHERE nick='DufF'),
+   0,
    (SELECT song FROM songs WHERE lower(title)=lower('Tsugaru')),
    'f',
    8420);
-INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
    (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
    7, 0,
    (SELECT player FROM players WHERE nick='DufF'),
+   1,
    (SELECT song FROM songs WHERE lower(title)=lower('Healing Vision (Angelic Mix)')),
    't',
    8678);
@@ -2252,17 +2455,19 @@ INSERT INTO roundparticipation (tournament, round, parallel, player, position) V
    (SELECT player FROM players WHERE nick='Snute'),
    3
 );
-INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
    (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
    7, 0,
    (SELECT player FROM players WHERE nick='Snute'),
+   0,
    (SELECT song FROM songs WHERE lower(title)=lower('Tsugaru')),
    'f',
    8604);
-INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
    (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
    7, 0,
    (SELECT player FROM players WHERE nick='Snute'),
+   1,
    (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)')),
    't',
    8794);
@@ -2294,17 +2499,19 @@ INSERT INTO roundparticipation (tournament, round, parallel, player, position) V
    (SELECT player FROM players WHERE nick='DufF'),
    1
 );
-INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
    (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
    8, 0,
    (SELECT player FROM players WHERE nick='DufF'),
+   0,
    (SELECT song FROM songs WHERE lower(title)=lower('I Want You To Want Me')),
    'f',
    5640);
-INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
    (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
    8, 0,
    (SELECT player FROM players WHERE nick='DufF'),
+   1,
    (SELECT song FROM songs WHERE lower(title)=lower('Max 300')),
    'f',
    8906);
@@ -2315,17 +2522,19 @@ INSERT INTO roundparticipation (tournament, round, parallel, player, position) V
    (SELECT player FROM players WHERE nick='Snute'),
    2
 );
-INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
    (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
    8, 0,
    (SELECT player FROM players WHERE nick='Snute'),
+   0,
    (SELECT song FROM songs WHERE lower(title)=lower('I Want You To Want Me')),
    'f',
    5750);
-INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
    (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
    8, 0,
    (SELECT player FROM players WHERE nick='Snute'),
+   1,
    (SELECT song FROM songs WHERE lower(title)=lower('Max 300')),
    'f',
    9496);