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

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

diff --git a/sql/cc04/cc6-04.sql b/sql/cc04/cc6-04.sql
index c1823f7363e75e21b8fd15cd4b4441e2b97f0295..d2faed57e7aa003a4adb38b2fad807caeeb26d3a 100644 (file)
--- a/sql/cc04/cc6-04.sql
+++ b/sql/cc04/cc6-04.sql
@@ -40,24 +40,27 @@ INSERT INTO roundparticipation (tournament, round, parallel, player, position) V
    (SELECT player FROM players WHERE nick='Pyro'),
    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 6'),
    1, 1,
    (SELECT player FROM players WHERE nick='Pyro'),
+   0,
    (SELECT song FROM songs WHERE lower(title)=lower('Love This Feelin\'')),
    'f',
    5540);
-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 6'),
    1, 1,
    (SELECT player FROM players WHERE nick='Pyro'),
+   1,
    (SELECT song FROM songs WHERE lower(title)=lower('Make A Jam!')),
    'f',
    5501);
-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 6'),
    1, 1,
    (SELECT player FROM players WHERE nick='Pyro'),
+   2,
    (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
    't',
    7419);
@@ -68,24 +71,27 @@ INSERT INTO roundparticipation (tournament, round, parallel, player, position) V
    (SELECT player FROM players WHERE nick='Th0rny'),
    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 6'),
    1, 1,
    (SELECT player FROM players WHERE nick='Th0rny'),
+   0,
    (SELECT song FROM songs WHERE lower(title)=lower('Love This Feelin\'')),
    'f',
    6512);
-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 6'),
    1, 1,
    (SELECT player FROM players WHERE nick='Th0rny'),
+   1,
    (SELECT song FROM songs WHERE lower(title)=lower('Make A Jam!')),
    'f',
    6227);
-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 6'),
    1, 1,
    (SELECT player FROM players WHERE nick='Th0rny'),
+   2,
    (SELECT song FROM songs WHERE lower(title)=lower('Dead End')),
    't',
    8128);
@@ -96,24 +102,27 @@ INSERT INTO roundparticipation (tournament, round, parallel, player, position) V
    (SELECT player FROM players WHERE nick='Glukko'),
    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 6'),
    1, 1,
    (SELECT player FROM players WHERE nick='Glukko'),
+   0,
    (SELECT song FROM songs WHERE lower(title)=lower('Love This Feelin\'')),
    'f',
    4245);
-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 6'),
    1, 1,
    (SELECT player FROM players WHERE nick='Glukko'),
+   1,
    (SELECT song FROM songs WHERE lower(title)=lower('Make A Jam!')),
    'f',
    5710);
-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 6'),
    1, 1,
    (SELECT player FROM players WHERE nick='Glukko'),
+   2,
    (SELECT song FROM songs WHERE lower(title)=lower('Never Let You Down')),
    't',
    6217);
@@ -124,24 +133,27 @@ INSERT INTO roundparticipation (tournament, round, parallel, player, position) V
    (SELECT player FROM players WHERE nick='Daniil'),
    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 6'),
    1, 1,
    (SELECT player FROM players WHERE nick='Daniil'),
+   0,
    (SELECT song FROM songs WHERE lower(title)=lower('Love This Feelin\'')),
    'f',
    6454);
-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 6'),
    1, 1,
    (SELECT player FROM players WHERE nick='Daniil'),
+   1,
    (SELECT song FROM songs WHERE lower(title)=lower('Make A Jam!')),
    'f',
    6776);
-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 6'),
    1, 1,
    (SELECT player FROM players WHERE nick='Daniil'),
+   2,
    (SELECT song FROM songs WHERE lower(title)=lower('Tsugaru')),
    't',
    7682);
@@ -152,24 +164,27 @@ INSERT INTO roundparticipation (tournament, round, parallel, player, position) V
    (SELECT player FROM players WHERE nick='Snofox'),
    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 6'),
    1, 1,
    (SELECT player FROM players WHERE nick='Snofox'),
+   0,
    (SELECT song FROM songs WHERE lower(title)=lower('Love This Feelin\'')),
    'f',
    6948);
-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 6'),
    1, 1,
    (SELECT player FROM players WHERE nick='Snofox'),
+   1,
    (SELECT song FROM songs WHERE lower(title)=lower('Make A Jam!')),
    'f',
    6685);
-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 6'),
    1, 1,
    (SELECT player FROM players WHERE nick='Snofox'),
+   2,
    (SELECT song FROM songs WHERE lower(title)=lower('Dynamite Rave')),
    't',
    7879);
@@ -180,24 +195,27 @@ 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 6'),
    1, 1,
    (SELECT player FROM players WHERE nick='Snute'),
+   0,
    (SELECT song FROM songs WHERE lower(title)=lower('Love This Feelin\'')),
    'f',
    7506);
-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 6'),
    1, 1,
    (SELECT player FROM players WHERE nick='Snute'),
+   1,
    (SELECT song FROM songs WHERE lower(title)=lower('Make A Jam!')),
    'f',
    7370);
-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 6'),
    1, 1,
    (SELECT player FROM players WHERE nick='Snute'),
+   2,
    (SELECT song FROM songs WHERE lower(title)=lower('era (nostalmix)')),
    't',
    7850);
@@ -227,24 +245,27 @@ INSERT INTO roundparticipation (tournament, round, parallel, player, position) V
    (SELECT player FROM players WHERE nick='Glock'),
    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 6'),
    1, 2,
    (SELECT player FROM players WHERE nick='Glock'),
+   0,
    (SELECT song FROM songs WHERE lower(title)=lower('Higher')),
    'f',
    4122);
-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 6'),
    1, 2,
    (SELECT player FROM players WHERE nick='Glock'),
+   1,
    (SELECT song FROM songs WHERE lower(title)=lower('Groove 2001')),
    'f',
    4862);
-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 6'),
    1, 2,
    (SELECT player FROM players WHERE nick='Glock'),
+   2,
    (SELECT song FROM songs WHERE lower(title)=lower('My Summer Love')),
    't',
    6209);
@@ -255,24 +276,27 @@ INSERT INTO roundparticipation (tournament, round, parallel, player, position) V
    (SELECT player FROM players WHERE nick='Athena'),
    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 6'),
    1, 2,
    (SELECT player FROM players WHERE nick='Athena'),
+   0,
    (SELECT song FROM songs WHERE lower(title)=lower('Higher')),
    'f',
    4533);
-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 6'),
    1, 2,
    (SELECT player FROM players WHERE nick='Athena'),
+   1,
    (SELECT song FROM songs WHERE lower(title)=lower('Groove 2001')),
    'f',
    4915);
-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 6'),
    1, 2,
    (SELECT player FROM players WHERE nick='Athena'),
+   2,
    (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
    't',
    6770);
@@ -283,24 +307,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 6'),
    1, 2,
    (SELECT player FROM players WHERE nick='Matsi'),
+   0,
    (SELECT song FROM songs WHERE lower(title)=lower('Higher')),
    'f',
    5130);
-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 6'),
    1, 2,
    (SELECT player FROM players WHERE nick='Matsi'),
+   1,
    (SELECT song FROM songs WHERE lower(title)=lower('Groove 2001')),
    'f',
    6092);
-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 6'),
    1, 2,
    (SELECT player FROM players WHERE nick='Matsi'),
+   2,
    (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
    't',
    8000);
@@ -311,24 +338,27 @@ INSERT INTO roundparticipation (tournament, round, parallel, player, position) V
    (SELECT player FROM players WHERE nick='Bonzo'),
    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 6'),
    1, 2,
    (SELECT player FROM players WHERE nick='Bonzo'),
+   0,
    (SELECT song FROM songs WHERE lower(title)=lower('Higher')),
    'f',
    6490);
-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 6'),
    1, 2,
    (SELECT player FROM players WHERE nick='Bonzo'),
+   1,
    (SELECT song FROM songs WHERE lower(title)=lower('Groove 2001')),
    'f',
    6430);
-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 6'),
    1, 2,
    (SELECT player FROM players WHERE nick='Bonzo'),
+   2,
    (SELECT song FROM songs WHERE lower(title)=lower('Dynamite Rave')),
    't',
    8087);
@@ -339,24 +369,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 6'),
    1, 2,
    (SELECT player FROM players WHERE nick='Smiph'),
+   0,
    (SELECT song FROM songs WHERE lower(title)=lower('Higher')),
    'f',
    5325);
-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 6'),
    1, 2,
    (SELECT player FROM players WHERE nick='Smiph'),
+   1,
    (SELECT song FROM songs WHERE lower(title)=lower('Groove 2001')),
    'f',
    5959);
-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 6'),
    1, 2,
    (SELECT player FROM players WHERE nick='Smiph'),
+   2,
    (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)')),
    't',
    8164);
@@ -367,24 +400,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 6'),
    1, 2,
    (SELECT player FROM players WHERE nick='DufF'),
+   0,
    (SELECT song FROM songs WHERE lower(title)=lower('Higher')),
    'f',
    6723);
-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 6'),
    1, 2,
    (SELECT player FROM players WHERE nick='DufF'),
+   1,
    (SELECT song FROM songs WHERE lower(title)=lower('Groove 2001')),
    'f',
    6834);
-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 6'),
    1, 2,
    (SELECT player FROM players WHERE nick='DufF'),
+   2,
    (SELECT song FROM songs WHERE lower(title)=lower('Spin the disc')),
    't',
    7948);
@@ -414,24 +450,27 @@ INSERT INTO roundparticipation (tournament, round, parallel, player, position) V
    (SELECT player FROM players WHERE nick='Ifrit'),
    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 6'),
    1, 3,
    (SELECT player FROM players WHERE nick='Ifrit'),
+   0,
    (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
    'f',
    3057);
-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 6'),
    1, 3,
    (SELECT player FROM players WHERE nick='Ifrit'),
+   1,
    (SELECT song FROM songs WHERE lower(title)=lower('DXY!')),
    'f',
    4486);
-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 6'),
    1, 3,
    (SELECT player FROM players WHERE nick='Ifrit'),
+   2,
    (SELECT song FROM songs WHERE lower(title)=lower('Jam Jam Reggae (AM Swing Mix)')),
    't',
    6459);
@@ -442,24 +481,27 @@ INSERT INTO roundparticipation (tournament, round, parallel, player, position) V
    (SELECT player FROM players WHERE nick='ViD'),
    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 6'),
    1, 3,
    (SELECT player FROM players WHERE nick='ViD'),
+   0,
    (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
    'f',
    8517);
-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 6'),
    1, 3,
    (SELECT player FROM players WHERE nick='ViD'),
+   1,
    (SELECT song FROM songs WHERE lower(title)=lower('DXY!')),
    'f',
    6820);
-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 6'),
    1, 3,
    (SELECT player FROM players WHERE nick='ViD'),
+   2,
    (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)')),
    't',
    8600);
@@ -470,24 +512,27 @@ INSERT INTO roundparticipation (tournament, round, parallel, player, position) V
    (SELECT player FROM players WHERE nick='Hyper'),
    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 6'),
    1, 3,
    (SELECT player FROM players WHERE nick='Hyper'),
+   0,
    (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
    'f',
    7935);
-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 6'),
    1, 3,
    (SELECT player FROM players WHERE nick='Hyper'),
+   1,
    (SELECT song FROM songs WHERE lower(title)=lower('DXY!')),
    'f',
    5109);
-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 6'),
    1, 3,
    (SELECT player FROM players WHERE nick='Hyper'),
+   2,
    (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)')),
    't',
    7931);
@@ -498,24 +543,27 @@ INSERT INTO roundparticipation (tournament, round, parallel, player, position) V
    (SELECT player FROM players WHERE nick='Andeplane'),
    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 6'),
    1, 3,
    (SELECT player FROM players WHERE nick='Andeplane'),
+   0,
    (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
    'f',
    7938);
-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 6'),
    1, 3,
    (SELECT player FROM players WHERE nick='Andeplane'),
+   1,
    (SELECT song FROM songs WHERE lower(title)=lower('DXY!')),
    'f',
    5713);
-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 6'),
    1, 3,
    (SELECT player FROM players WHERE nick='Andeplane'),
+   2,
    (SELECT song FROM songs WHERE lower(title)=lower('Exotic Ethnic')),
    't',
    8175);
@@ -526,24 +574,27 @@ INSERT INTO roundparticipation (tournament, round, parallel, player, position) V
    (SELECT player FROM players WHERE nick='Gogo'),
    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 6'),
    1, 3,
    (SELECT player FROM players WHERE nick='Gogo'),
+   0,
    (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
    'f',
    8841);
-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 6'),
    1, 3,
    (SELECT player FROM players WHERE nick='Gogo'),
+   1,
    (SELECT song FROM songs WHERE lower(title)=lower('DXY!')),
    '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 6'),
    1, 3,
    (SELECT player FROM players WHERE nick='Gogo'),
+   2,
    (SELECT song FROM songs WHERE lower(title)=lower('Spin the disc')),
    't',
    7759);
@@ -554,24 +605,27 @@ INSERT INTO roundparticipation (tournament, round, parallel, player, position) V
    (SELECT player FROM players WHERE nick='Duckling'),
    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 6'),
    1, 3,
    (SELECT player FROM players WHERE nick='Duckling'),
+   0,
    (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
    'f',
    8650);
-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 6'),
    1, 3,
    (SELECT player FROM players WHERE nick='Duckling'),
+   1,
    (SELECT song FROM songs WHERE lower(title)=lower('DXY!')),
    'f',
    6988);
-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 6'),
    1, 3,
    (SELECT player FROM players WHERE nick='Duckling'),
+   2,
    (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love (SPEED MIX)')),
    't',
    7904);
@@ -582,24 +636,27 @@ INSERT INTO roundparticipation (tournament, round, parallel, player, position) V
    (SELECT player FROM players WHERE nick='OJK'),
    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 6'),
    1, 3,
    (SELECT player FROM players WHERE nick='OJK'),
+   0,
    (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
    'f',
    8893);
-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 6'),
    1, 3,
    (SELECT player FROM players WHERE nick='OJK'),
+   1,
    (SELECT song FROM songs WHERE lower(title)=lower('DXY!')),
    'f',
    7599);
-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 6'),
    1, 3,
    (SELECT player FROM players WHERE nick='OJK'),
+   2,
    (SELECT song FROM songs WHERE lower(title)=lower('La Senorita')),
    't',
    7661);
@@ -629,24 +686,27 @@ INSERT INTO roundparticipation (tournament, round, parallel, player, position) V
    (SELECT player FROM players WHERE nick='Electron'),
    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 6'),
    1, 4,
    (SELECT player FROM players WHERE nick='Electron'),
+   0,
    (SELECT song FROM songs WHERE lower(title)=lower('Luv to Me (AMD Mix)')),
    'f',
    5545);
-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 6'),
    1, 4,
    (SELECT player FROM players WHERE nick='Electron'),
+   1,
    (SELECT song FROM songs WHERE lower(title)=lower('Nori Nori Nori')),
    'f',
    5420);
-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 6'),
    1, 4,
    (SELECT player FROM players WHERE nick='Electron'),
+   2,
    (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love (SPEED MIX)')),
    't',
    7443);
@@ -657,24 +717,27 @@ INSERT INTO roundparticipation (tournament, round, parallel, player, position) V
    (SELECT player FROM players WHERE nick='Guru'),
    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 6'),
    1, 4,
    (SELECT player FROM players WHERE nick='Guru'),
+   0,
    (SELECT song FROM songs WHERE lower(title)=lower('Luv to Me (AMD Mix)')),
    'f',
    5318);
-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 6'),
    1, 4,
    (SELECT player FROM players WHERE nick='Guru'),
+   1,
    (SELECT song FROM songs WHERE lower(title)=lower('Nori Nori Nori')),
    'f',
    4598);
-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 6'),
    1, 4,
    (SELECT player FROM players WHERE nick='Guru'),
+   2,
    (SELECT song FROM songs WHERE lower(title)=lower('Crash!')),
    't',
    4905);
@@ -685,24 +748,27 @@ INSERT INTO roundparticipation (tournament, round, parallel, player, position) V
    (SELECT player FROM players WHERE nick='Annkakri'),
    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 6'),
    1, 4,
    (SELECT player FROM players WHERE nick='Annkakri'),
+   0,
    (SELECT song FROM songs WHERE lower(title)=lower('Luv to Me (AMD Mix)')),
    'f',
    4415);
-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 6'),
    1, 4,
    (SELECT player FROM players WHERE nick='Annkakri'),
+   1,
    (SELECT song FROM songs WHERE lower(title)=lower('Nori Nori Nori')),
    'f',
    4341);
-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 6'),
    1, 4,
    (SELECT player FROM players WHERE nick='Annkakri'),
+   2,
    (SELECT song FROM songs WHERE lower(title)=lower('Jam Jam Reggae (AM Swing Mix)')),
    't',
    6245);
@@ -713,24 +779,27 @@ INSERT INTO roundparticipation (tournament, round, parallel, player, position) V
    (SELECT player FROM players WHERE nick='Felz'),
    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 6'),
    1, 4,
    (SELECT player FROM players WHERE nick='Felz'),
+   0,
    (SELECT song FROM songs WHERE lower(title)=lower('Luv to Me (AMD Mix)')),
    'f',
    6274);
-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 6'),
    1, 4,
    (SELECT player FROM players WHERE nick='Felz'),
+   1,
    (SELECT song FROM songs WHERE lower(title)=lower('Nori Nori Nori')),
    'f',
    5600);
-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 6'),
    1, 4,
    (SELECT player FROM players WHERE nick='Felz'),
+   2,
    (SELECT song FROM songs WHERE lower(title)=lower('Exotic Ethnic')),
    't',
    8080);
@@ -741,24 +810,27 @@ INSERT INTO roundparticipation (tournament, round, parallel, player, position) V
    (SELECT player FROM players WHERE nick='Draconia'),
    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 6'),
    1, 4,
    (SELECT player FROM players WHERE nick='Draconia'),
+   0,
    (SELECT song FROM songs WHERE lower(title)=lower('Luv to Me (AMD Mix)')),
    'f',
    5075);
-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 6'),
    1, 4,
    (SELECT player FROM players WHERE nick='Draconia'),
+   1,
    (SELECT song FROM songs WHERE lower(title)=lower('Nori Nori Nori')),
    'f',
    6218);
-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 6'),
    1, 4,
    (SELECT player FROM players WHERE nick='Draconia'),
+   2,
    (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)')),
    't',
    7977);
@@ -769,24 +841,27 @@ INSERT INTO roundparticipation (tournament, round, parallel, player, position) V
    (SELECT player FROM players WHERE nick='Ylini'),
    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 6'),
    1, 4,
    (SELECT player FROM players WHERE nick='Ylini'),
+   0,
    (SELECT song FROM songs WHERE lower(title)=lower('Luv to Me (AMD Mix)')),
    'f',
    6801);
-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 6'),
    1, 4,
    (SELECT player FROM players WHERE nick='Ylini'),
+   1,
    (SELECT song FROM songs WHERE lower(title)=lower('Nori Nori Nori')),
    'f',
    5958);
-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 6'),
    1, 4,
    (SELECT player FROM players WHERE nick='Ylini'),
+   2,
    (SELECT song FROM songs WHERE lower(title)=lower('Jam Jam Reggae (AM Swing Mix)')),
    't',
    7425);
@@ -797,24 +872,27 @@ INSERT INTO roundparticipation (tournament, round, parallel, player, position) V
    (SELECT player FROM players WHERE nick='Haggar'),
    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 6'),
    1, 4,
    (SELECT player FROM players WHERE nick='Haggar'),
+   0,
    (SELECT song FROM songs WHERE lower(title)=lower('Luv to Me (AMD Mix)')),
    'f',
    7178);
-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 6'),
    1, 4,
    (SELECT player FROM players WHERE nick='Haggar'),
+   1,
    (SELECT song FROM songs WHERE lower(title)=lower('Nori Nori Nori')),
    'f',
    6748);
-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 6'),
    1, 4,
    (SELECT player FROM players WHERE nick='Haggar'),
+   2,
    (SELECT song FROM songs WHERE lower(title)=lower('Trip Machine (Luv Mix)')),
    't',
    7973);
@@ -844,24 +922,27 @@ INSERT INTO roundparticipation (tournament, round, parallel, player, position) V
    (SELECT player FROM players WHERE nick='Goku'),
    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 6'),
    1, 5,
    (SELECT player FROM players WHERE nick='Goku'),
+   0,
    (SELECT song FROM songs WHERE lower(title)=lower('Let the Beat Hit \'em!')),
    '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 6'),
    1, 5,
    (SELECT player FROM players WHERE nick='Goku'),
+   1,
    (SELECT song FROM songs WHERE lower(title)=lower('Living in America')),
    'f',
    5900);
-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 6'),
    1, 5,
    (SELECT player FROM players WHERE nick='Goku'),
+   2,
    (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love (SPEED MIX)')),
    't',
    8359);
@@ -872,24 +953,27 @@ INSERT INTO roundparticipation (tournament, round, parallel, player, position) V
    (SELECT player FROM players WHERE nick='Montana'),
    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 6'),
    1, 5,
    (SELECT player FROM players WHERE nick='Montana'),
+   0,
    (SELECT song FROM songs WHERE lower(title)=lower('Let the Beat Hit \'em!')),
    'f',
    5411);
-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 6'),
    1, 5,
    (SELECT player FROM players WHERE nick='Montana'),
+   1,
    (SELECT song FROM songs WHERE lower(title)=lower('Living in America')),
    'f',
    4624);
-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 6'),
    1, 5,
    (SELECT player FROM players WHERE nick='Montana'),
+   2,
    (SELECT song FROM songs WHERE lower(title)=lower('Spin the disc')),
    't',
    6637);
@@ -900,24 +984,27 @@ INSERT INTO roundparticipation (tournament, round, parallel, player, position) V
    (SELECT player FROM players WHERE nick='JonAnders'),
    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 6'),
    1, 5,
    (SELECT player FROM players WHERE nick='JonAnders'),
+   0,
    (SELECT song FROM songs WHERE lower(title)=lower('Let the Beat Hit \'em!')),
    'f',
    4643);
-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 6'),
    1, 5,
    (SELECT player FROM players WHERE nick='JonAnders'),
+   1,
    (SELECT song FROM songs WHERE lower(title)=lower('Living in America')),
    'f',
    4202);
-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 6'),
    1, 5,
    (SELECT player FROM players WHERE nick='JonAnders'),
+   2,
    (SELECT song FROM songs WHERE lower(title)=lower('Don\'t Try to Stop It')),
    't',
    5502);
@@ -928,24 +1015,27 @@ INSERT INTO roundparticipation (tournament, round, parallel, player, position) V
    (SELECT player FROM players WHERE nick='Alexxz'),
    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 6'),
    1, 5,
    (SELECT player FROM players WHERE nick='Alexxz'),
+   0,
    (SELECT song FROM songs WHERE lower(title)=lower('Let the Beat Hit \'em!')),
    'f',
    6074);
-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 6'),
    1, 5,
    (SELECT player FROM players WHERE nick='Alexxz'),
+   1,
    (SELECT song FROM songs WHERE lower(title)=lower('Living in America')),
    'f',
    6053);
-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 6'),
    1, 5,
    (SELECT player FROM players WHERE nick='Alexxz'),
+   2,
    (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
    't',
    7984);
@@ -956,24 +1046,27 @@ INSERT INTO roundparticipation (tournament, round, parallel, player, position) V
    (SELECT player FROM players WHERE nick='Pingo'),
    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 6'),
    1, 5,
    (SELECT player FROM players WHERE nick='Pingo'),
+   0,
    (SELECT song FROM songs WHERE lower(title)=lower('Let the Beat Hit \'em!')),
    'f',
    6413);
-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 6'),
    1, 5,
    (SELECT player FROM players WHERE nick='Pingo'),
+   1,
    (SELECT song FROM songs WHERE lower(title)=lower('Living in America')),
    'f',
    6100);
-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 6'),
    1, 5,
    (SELECT player FROM players WHERE nick='Pingo'),
+   2,
    (SELECT song FROM songs WHERE lower(title)=lower('PARANOiA Rebirth')),
    't',
    8393);
@@ -984,24 +1077,27 @@ INSERT INTO roundparticipation (tournament, round, parallel, player, position) V
    (SELECT player FROM players WHERE nick='Nameless'),
    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 6'),
    1, 5,
    (SELECT player FROM players WHERE nick='Nameless'),
+   0,
    (SELECT song FROM songs WHERE lower(title)=lower('Let the Beat Hit \'em!')),
    'f',
    6518);
-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 6'),
    1, 5,
    (SELECT player FROM players WHERE nick='Nameless'),
+   1,
    (SELECT song FROM songs WHERE lower(title)=lower('Living in America')),
    'f',
    6543);
-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 6'),
    1, 5,
    (SELECT player FROM players WHERE nick='Nameless'),
+   2,
    (SELECT song FROM songs WHERE lower(title)=lower('Healing Vision (Angelic Mix)')),
    't',
    8218);
@@ -1012,24 +1108,27 @@ INSERT INTO roundparticipation (tournament, round, parallel, player, position) V
    (SELECT player FROM players WHERE nick='RiChY'),
    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 6'),
    1, 5,
    (SELECT player FROM players WHERE nick='RiChY'),
+   0,
    (SELECT song FROM songs WHERE lower(title)=lower('Let the Beat Hit \'em!')),
    'f',
    5975);
-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 6'),
    1, 5,
    (SELECT player FROM players WHERE nick='RiChY'),
+   1,
    (SELECT song FROM songs WHERE lower(title)=lower('Living in America')),
    'f',
    5993);
-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 6'),
    1, 5,
    (SELECT player FROM players WHERE nick='RiChY'),
+   2,
    (SELECT song FROM songs WHERE lower(title)=lower('PARANOiA Rebirth')),
    't',
    8380);
@@ -1059,24 +1158,27 @@ INSERT INTO roundparticipation (tournament, round, parallel, player, position) V
    (SELECT player FROM players WHERE nick='Matti'),
    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 6'),
    1, 6,
    (SELECT player FROM players WHERE nick='Matti'),
+   0,
    (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love')),
    'f',
    6024);
-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 6'),
    1, 6,
    (SELECT player FROM players WHERE nick='Matti'),
+   1,
    (SELECT song FROM songs WHERE lower(title)=lower('20th November')),
    'f',
    5382);
-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 6'),
    1, 6,
    (SELECT player FROM players WHERE nick='Matti'),
+   2,
    (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
    't',
    6848);
@@ -1087,24 +1189,27 @@ INSERT INTO roundparticipation (tournament, round, parallel, player, position) V
    (SELECT player FROM players WHERE nick='v|per'),
    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 6'),
    1, 6,
    (SELECT player FROM players WHERE nick='v|per'),
+   0,
    (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love')),
    'f',
    5783);
-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 6'),
    1, 6,
    (SELECT player FROM players WHERE nick='v|per'),
+   1,
    (SELECT song FROM songs WHERE lower(title)=lower('20th November')),
    'f',
    5011);
-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 6'),
    1, 6,
    (SELECT player FROM players WHERE nick='v|per'),
+   2,
    (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)')),
    't',
    6587);
@@ -1115,24 +1220,27 @@ INSERT INTO roundparticipation (tournament, round, parallel, player, position) V
    (SELECT player FROM players WHERE nick='Zackie'),
    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 6'),
    1, 6,
    (SELECT player FROM players WHERE nick='Zackie'),
+   0,
    (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love')),
    'f',
    5507);
-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 6'),
    1, 6,
    (SELECT player FROM players WHERE nick='Zackie'),
+   1,
    (SELECT song FROM songs WHERE lower(title)=lower('20th November')),
    'f',
    4324);
-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 6'),
    1, 6,
    (SELECT player FROM players WHERE nick='Zackie'),
+   2,
    (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
    't',
    7930);
@@ -1143,24 +1251,27 @@ INSERT INTO roundparticipation (tournament, round, parallel, player, position) V
    (SELECT player FROM players WHERE nick='Mync'),
    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 6'),
    1, 6,
    (SELECT player FROM players WHERE nick='Mync'),
+   0,
    (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love')),
    'f',
    6750);
-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 6'),
    1, 6,
    (SELECT player FROM players WHERE nick='Mync'),
+   1,
    (SELECT song FROM songs WHERE lower(title)=lower('20th November')),
    'f',
    5565);
-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 6'),
    1, 6,
    (SELECT player FROM players WHERE nick='Mync'),
+   2,
    (SELECT song FROM songs WHERE lower(title)=lower('Exotic Ethnic')),
    't',
    8405);
@@ -1171,24 +1282,27 @@ INSERT INTO roundparticipation (tournament, round, parallel, player, position) V
    (SELECT player FROM players WHERE nick='Ozon'),
    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 6'),
    1, 6,
    (SELECT player FROM players WHERE nick='Ozon'),
+   0,
    (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love')),
    'f',
    7482);
-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 6'),
    1, 6,
    (SELECT player FROM players WHERE nick='Ozon'),
+   1,
    (SELECT song FROM songs WHERE lower(title)=lower('20th November')),
    'f',
    5751);
-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 6'),
    1, 6,
    (SELECT player FROM players WHERE nick='Ozon'),
+   2,
    (SELECT song FROM songs WHERE lower(title)=lower('Crash!')),
    't',
    7400);
@@ -1199,24 +1313,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 6'),
    1, 6,
    (SELECT player FROM players WHERE nick='T|na'),
+   0,
    (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love')),
    'f',
    7036);
-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 6'),
    1, 6,
    (SELECT player FROM players WHERE nick='T|na'),
+   1,
    (SELECT song FROM songs WHERE lower(title)=lower('20th November')),
    'f',
    6416);
-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 6'),
    1, 6,
    (SELECT player FROM players WHERE nick='T|na'),
+   2,
    (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)')),
    't',
    8174);
@@ -1227,24 +1344,27 @@ INSERT INTO roundparticipation (tournament, round, parallel, player, position) V
    (SELECT player FROM players WHERE nick='Oliyzia'),
    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 6'),
    1, 6,
    (SELECT player FROM players WHERE nick='Oliyzia'),
+   0,
    (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love')),
    'f',
    7381);
-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 6'),
    1, 6,
    (SELECT player FROM players WHERE nick='Oliyzia'),
+   1,
    (SELECT song FROM songs WHERE lower(title)=lower('20th November')),
    'f',
    6500);
-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 6'),
    1, 6,
    (SELECT player FROM players WHERE nick='Oliyzia'),
+   2,
    (SELECT song FROM songs WHERE lower(title)=lower('Crash!')),
    't',
    8217);
@@ -1279,24 +1399,27 @@ INSERT INTO roundparticipation (tournament, round, parallel, player, position) V
    (SELECT player FROM players WHERE nick='Daniil'),
    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 6'),
    2, 1,
    (SELECT player FROM players WHERE nick='Daniil'),
+   0,
    (SELECT song FROM songs WHERE lower(title)=lower('Hysteria 2001')),
    'f',
    6540);
-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 6'),
    2, 1,
    (SELECT player FROM players WHERE nick='Daniil'),
+   1,
    (SELECT song FROM songs WHERE lower(title)=lower('Rain of Sorrow')),
    'f',
    7085);
-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 6'),
    2, 1,
    (SELECT player FROM players WHERE nick='Daniil'),
+   2,
    (SELECT song FROM songs WHERE lower(title)=lower('Crash!')),
    't',
    8642);
@@ -1307,24 +1430,27 @@ INSERT INTO roundparticipation (tournament, round, parallel, player, position) V
    (SELECT player FROM players WHERE nick='ViD'),
    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 6'),
    2, 1,
    (SELECT player FROM players WHERE nick='ViD'),
+   0,
    (SELECT song FROM songs WHERE lower(title)=lower('Hysteria 2001')),
    '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 6'),
    2, 1,
    (SELECT player FROM players WHERE nick='ViD'),
+   1,
    (SELECT song FROM songs WHERE lower(title)=lower('Rain of Sorrow')),
    'f',
    7492);
-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 6'),
    2, 1,
    (SELECT player FROM players WHERE nick='ViD'),
+   2,
    (SELECT song FROM songs WHERE lower(title)=lower('Crash!')),
    't',
    8193);
@@ -1335,24 +1461,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 6'),
    2, 1,
    (SELECT player FROM players WHERE nick='Ylini'),
+   0,
    (SELECT song FROM songs WHERE lower(title)=lower('Hysteria 2001')),
    'f',
    6534);
-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 6'),
    2, 1,
    (SELECT player FROM players WHERE nick='Ylini'),
+   1,
    (SELECT song FROM songs WHERE lower(title)=lower('Rain of Sorrow')),
    'f',
    7877);
-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 6'),
    2, 1,
    (SELECT player FROM players WHERE nick='Ylini'),
+   2,
    (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)')),
    't',
    8246);
@@ -1363,24 +1492,27 @@ INSERT INTO roundparticipation (tournament, round, parallel, player, position) V
    (SELECT player FROM players WHERE nick='Bonzo'),
    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 6'),
    2, 1,
    (SELECT player FROM players WHERE nick='Bonzo'),
+   0,
    (SELECT song FROM songs WHERE lower(title)=lower('Hysteria 2001')),
    'f',
    6464);
-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 6'),
    2, 1,
    (SELECT player FROM players WHERE nick='Bonzo'),
+   1,
    (SELECT song FROM songs WHERE lower(title)=lower('Rain of Sorrow')),
    'f',
    7370);
-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 6'),
    2, 1,
    (SELECT player FROM players WHERE nick='Bonzo'),
+   2,
    (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
    't',
    8578);
@@ -1391,24 +1523,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 6'),
    2, 1,
    (SELECT player FROM players WHERE nick='Snute'),
+   0,
    (SELECT song FROM songs WHERE lower(title)=lower('Hysteria 2001')),
    'f',
    6899);
-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 6'),
    2, 1,
    (SELECT player FROM players WHERE nick='Snute'),
+   1,
    (SELECT song FROM songs WHERE lower(title)=lower('Rain of Sorrow')),
    'f',
    8498);
-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 6'),
    2, 1,
    (SELECT player FROM players WHERE nick='Snute'),
+   2,
    (SELECT song FROM songs WHERE lower(title)=lower('Spin the disc')),
    't',
    7791);
@@ -1419,24 +1554,27 @@ INSERT INTO roundparticipation (tournament, round, parallel, player, position) V
    (SELECT player FROM players WHERE nick='Gogo'),
    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 6'),
    2, 1,
    (SELECT player FROM players WHERE nick='Gogo'),
+   0,
    (SELECT song FROM songs WHERE lower(title)=lower('Hysteria 2001')),
    'f',
    6182);
-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 6'),
    2, 1,
    (SELECT player FROM players WHERE nick='Gogo'),
+   1,
    (SELECT song FROM songs WHERE lower(title)=lower('Rain of Sorrow')),
    'f',
    6574);
-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 6'),
    2, 1,
    (SELECT player FROM players WHERE nick='Gogo'),
+   2,
    (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)')),
    't',
    8746);
@@ -1466,24 +1604,27 @@ INSERT INTO roundparticipation (tournament, round, parallel, player, position) V
    (SELECT player FROM players WHERE nick='Felz'),
    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 6'),
    2, 2,
    (SELECT player FROM players WHERE nick='Felz'),
+   0,
    (SELECT song FROM songs WHERE lower(title)=lower('Memories')),
    'f',
    5421);
-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 6'),
    2, 2,
    (SELECT player FROM players WHERE nick='Felz'),
+   1,
    (SELECT song FROM songs WHERE lower(title)=lower('Keep On Movin\'')),
    'f',
    5171);
-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 6'),
    2, 2,
    (SELECT player FROM players WHERE nick='Felz'),
+   2,
    (SELECT song FROM songs WHERE lower(title)=lower('PARANOiA Rebirth')),
    't',
    7990);
@@ -1494,24 +1635,27 @@ INSERT INTO roundparticipation (tournament, round, parallel, player, position) V
    (SELECT player FROM players WHERE nick='Mync'),
    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 6'),
    2, 2,
    (SELECT player FROM players WHERE nick='Mync'),
+   0,
    (SELECT song FROM songs WHERE lower(title)=lower('Memories')),
    'f',
    5685);
-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 6'),
    2, 2,
    (SELECT player FROM players WHERE nick='Mync'),
+   1,
    (SELECT song FROM songs WHERE lower(title)=lower('Keep On Movin\'')),
    'f',
    4738);
-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 6'),
    2, 2,
    (SELECT player FROM players WHERE nick='Mync'),
+   2,
    (SELECT song FROM songs WHERE lower(title)=lower('Afronova')),
    't',
    7743);
@@ -1522,24 +1666,27 @@ INSERT INTO roundparticipation (tournament, round, parallel, player, position) V
    (SELECT player FROM players WHERE nick='OJK'),
    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 6'),
    2, 2,
    (SELECT player FROM players WHERE nick='OJK'),
+   0,
    (SELECT song FROM songs WHERE lower(title)=lower('Memories')),
    'f',
    6952);
-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 6'),
    2, 2,
    (SELECT player FROM players WHERE nick='OJK'),
+   1,
    (SELECT song FROM songs WHERE lower(title)=lower('Keep On Movin\'')),
    'f',
    6567);
-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 6'),
    2, 2,
    (SELECT player FROM players WHERE nick='OJK'),
+   2,
    (SELECT song FROM songs WHERE lower(title)=lower('Trip Machine (Luv Mix)')),
    't',
    8418);
@@ -1550,24 +1697,27 @@ INSERT INTO roundparticipation (tournament, round, parallel, player, position) V
    (SELECT player FROM players WHERE nick='T|na'),
    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 6'),
    2, 2,
    (SELECT player FROM players WHERE nick='T|na'),
+   0,
    (SELECT song FROM songs WHERE lower(title)=lower('Memories')),
    'f',
    6339);
-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 6'),
    2, 2,
    (SELECT player FROM players WHERE nick='T|na'),
+   1,
    (SELECT song FROM songs WHERE lower(title)=lower('Keep On Movin\'')),
    'f',
    5690);
-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 6'),
    2, 2,
    (SELECT player FROM players WHERE nick='T|na'),
+   2,
    (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
    't',
    8644);
@@ -1578,24 +1728,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 6'),
    2, 2,
    (SELECT player FROM players WHERE nick='DufF'),
+   0,
    (SELECT song FROM songs WHERE lower(title)=lower('Memories')),
    'f',
    7547);
-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 6'),
    2, 2,
    (SELECT player FROM players WHERE nick='DufF'),
+   1,
    (SELECT song FROM songs WHERE lower(title)=lower('Keep On Movin\'')),
    'f',
    6182);
-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 6'),
    2, 2,
    (SELECT player FROM players WHERE nick='DufF'),
+   2,
    (SELECT song FROM songs WHERE lower(title)=lower('Trip Machine (Luv Mix)')),
    't',
    8377);
@@ -1606,24 +1759,27 @@ INSERT INTO roundparticipation (tournament, round, parallel, player, position) V
    (SELECT player FROM players WHERE nick='Nameless'),
    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 6'),
    2, 2,
    (SELECT player FROM players WHERE nick='Nameless'),
+   0,
    (SELECT song FROM songs WHERE lower(title)=lower('Memories')),
    'f',
    7228);
-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 6'),
    2, 2,
    (SELECT player FROM players WHERE nick='Nameless'),
+   1,
    (SELECT song FROM songs WHERE lower(title)=lower('Keep On Movin\'')),
    'f',
    5429);
-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 6'),
    2, 2,
    (SELECT player FROM players WHERE nick='Nameless'),
+   2,
    (SELECT song FROM songs WHERE lower(title)=lower('Dead End')),
    't',
    8230);
@@ -1653,24 +1809,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 6'),
    2, 3,
    (SELECT player FROM players WHERE nick='Smiph'),
+   0,
    (SELECT song FROM songs WHERE lower(title)=lower('End of the Century')),
    'f',
    6286);
-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 6'),
    2, 3,
    (SELECT player FROM players WHERE nick='Smiph'),
+   1,
    (SELECT song FROM songs WHERE lower(title)=lower('PARANOiA Rebirth')),
    'f',
    7291);
-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 6'),
    2, 3,
    (SELECT player FROM players WHERE nick='Smiph'),
+   2,
    (SELECT song FROM songs WHERE lower(title)=lower('Crash!')),
    't',
    8168);
@@ -1681,24 +1840,27 @@ 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 6'),
    2, 3,
    (SELECT player FROM players WHERE nick='RiChY'),
+   0,
    (SELECT song FROM songs WHERE lower(title)=lower('End of the Century')),
    'f',
    7500);
-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 6'),
    2, 3,
    (SELECT player FROM players WHERE nick='RiChY'),
+   1,
    (SELECT song FROM songs WHERE lower(title)=lower('PARANOiA Rebirth')),
    'f',
    8560);
-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 6'),
    2, 3,
    (SELECT player FROM players WHERE nick='RiChY'),
+   2,
    (SELECT song FROM songs WHERE lower(title)=lower('Max 300')),
    't',
    7971);
@@ -1709,24 +1871,27 @@ INSERT INTO roundparticipation (tournament, round, parallel, player, position) V
    (SELECT player FROM players WHERE nick='Snofox'),
    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 6'),
    2, 3,
    (SELECT player FROM players WHERE nick='Snofox'),
+   0,
    (SELECT song FROM songs WHERE lower(title)=lower('End of the Century')),
    'f',
    8198);
-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 6'),
    2, 3,
    (SELECT player FROM players WHERE nick='Snofox'),
+   1,
    (SELECT song FROM songs WHERE lower(title)=lower('PARANOiA Rebirth')),
    'f',
    8719);
-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 6'),
    2, 3,
    (SELECT player FROM players WHERE nick='Snofox'),
+   2,
    (SELECT song FROM songs WHERE lower(title)=lower('Tsugaru')),
    't',
    8686);
@@ -1737,24 +1902,27 @@ INSERT INTO roundparticipation (tournament, round, parallel, player, position) V
    (SELECT player FROM players WHERE nick='Pingo'),
    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 6'),
    2, 3,
    (SELECT player FROM players WHERE nick='Pingo'),
+   0,
    (SELECT song FROM songs WHERE lower(title)=lower('End of the Century')),
    'f',
    7920);
-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 6'),
    2, 3,
    (SELECT player FROM players WHERE nick='Pingo'),
+   1,
    (SELECT song FROM songs WHERE lower(title)=lower('PARANOiA Rebirth')),
    'f',
    8333);
-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 6'),
    2, 3,
    (SELECT player FROM players WHERE nick='Pingo'),
+   2,
    (SELECT song FROM songs WHERE lower(title)=lower('Crash!')),
    't',
    8544);
@@ -1765,24 +1933,27 @@ INSERT INTO roundparticipation (tournament, round, parallel, player, position) V
    (SELECT player FROM players WHERE nick='Haggar'),
    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 6'),
    2, 3,
    (SELECT player FROM players WHERE nick='Haggar'),
+   0,
    (SELECT song FROM songs WHERE lower(title)=lower('End of the Century')),
    'f',
    8713);
-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 6'),
    2, 3,
    (SELECT player FROM players WHERE nick='Haggar'),
+   1,
    (SELECT song FROM songs WHERE lower(title)=lower('PARANOiA Rebirth')),
    'f',
    8720);
-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 6'),
    2, 3,
    (SELECT player FROM players WHERE nick='Haggar'),
+   2,
    (SELECT song FROM songs WHERE lower(title)=lower('So Deep (Perfect Sphere Mix)')),
    't',
    8793);
@@ -1793,24 +1964,27 @@ INSERT INTO roundparticipation (tournament, round, parallel, player, position) V
    (SELECT player FROM players WHERE nick='Oliyzia'),
    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 6'),
    2, 3,
    (SELECT player FROM players WHERE nick='Oliyzia'),
+   0,
    (SELECT song FROM songs WHERE lower(title)=lower('End of the Century')),
    'f',
    8307);
-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 6'),
    2, 3,
    (SELECT player FROM players WHERE nick='Oliyzia'),
+   1,
    (SELECT song FROM songs WHERE lower(title)=lower('PARANOiA Rebirth')),
    'f',
    8545);
-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 6'),
    2, 3,
    (SELECT player FROM players WHERE nick='Oliyzia'),
+   2,
    (SELECT song FROM songs WHERE lower(title)=lower('Tsugaru')),
    't',
    8190);
@@ -1840,17 +2014,19 @@ INSERT INTO roundparticipation (tournament, round, parallel, player, position) V
    (SELECT player FROM players WHERE nick='Nameless'),
    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 6'),
    3, 0,
    (SELECT player FROM players WHERE nick='Nameless'),
+   0,
    (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love (SPEED MIX)')),
    'f',
    8064);
-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 6'),
    3, 0,
    (SELECT player FROM players WHERE nick='Nameless'),
+   1,
    (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
    't',
    8627);
@@ -1861,17 +2037,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 6'),
    3, 0,
    (SELECT player FROM players WHERE nick='Oliyzia'),
+   0,
    (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love (SPEED MIX)')),
    'f',
    8296);
-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 6'),
    3, 0,
    (SELECT player FROM players WHERE nick='Oliyzia'),
+   1,
    (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
    't',
    8550);
@@ -1882,17 +2060,19 @@ INSERT INTO roundparticipation (tournament, round, parallel, player, position) V
    (SELECT player FROM players WHERE nick='Bonzo'),
    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 6'),
    3, 0,
    (SELECT player FROM players WHERE nick='Bonzo'),
+   0,
    (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love (SPEED MIX)')),
    'f',
    8207);
-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 6'),
    3, 0,
    (SELECT player FROM players WHERE nick='Bonzo'),
+   1,
    (SELECT song FROM songs WHERE lower(title)=lower('Max 300')),
    't',
    8133);
@@ -1903,17 +2083,19 @@ 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 6'),
    3, 0,
    (SELECT player FROM players WHERE nick='Ylini'),
+   0,
    (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love (SPEED MIX)')),
    'f',
    8015);
-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 6'),
    3, 0,
    (SELECT player FROM players WHERE nick='Ylini'),
+   1,
    (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
    't',
    8414);
@@ -1924,17 +2106,19 @@ 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 6'),
    3, 0,
    (SELECT player FROM players WHERE nick='OJK'),
+   0,
    (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love (SPEED MIX)')),
    'f',
    8704);
-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 6'),
    3, 0,
    (SELECT player FROM players WHERE nick='OJK'),
+   1,
    (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)')),
    't',
    8635);
@@ -1945,17 +2129,19 @@ INSERT INTO roundparticipation (tournament, round, parallel, player, position) V
    (SELECT player FROM players WHERE nick='Snofox'),
    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 6'),
    3, 0,
    (SELECT player FROM players WHERE nick='Snofox'),
+   0,
    (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love (SPEED MIX)')),
    'f',
    8494);
-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 6'),
    3, 0,
    (SELECT player FROM players WHERE nick='Snofox'),
+   1,
    (SELECT song FROM songs WHERE lower(title)=lower('PARANOiA Rebirth')),
    't',
    8459);
@@ -1966,17 +2152,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 6'),
    3, 0,
    (SELECT player FROM players WHERE nick='DufF'),
+   0,
    (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love (SPEED MIX)')),
    'f',
    8755);
-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 6'),
    3, 0,
    (SELECT player FROM players WHERE nick='DufF'),
+   1,
    (SELECT song FROM songs WHERE lower(title)=lower('Trip Machine Climax')),
    't',
    8367);
@@ -1987,17 +2175,19 @@ INSERT INTO roundparticipation (tournament, round, parallel, player, position) V
    (SELECT player FROM players WHERE nick='Snute'),
    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 6'),
    3, 0,
    (SELECT player FROM players WHERE nick='Snute'),
+   0,
    (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love (SPEED MIX)')),
    'f',
    8769);
-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 6'),
    3, 0,
    (SELECT player FROM players WHERE nick='Snute'),
+   1,
    (SELECT song FROM songs WHERE lower(title)=lower('End of the Century')),
    't',
    8743);
@@ -2008,17 +2198,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 6'),
    3, 0,
    (SELECT player FROM players WHERE nick='Haggar'),
+   0,
    (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love (SPEED MIX)')),
    'f',
    8631);
-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 6'),
    3, 0,
    (SELECT player FROM players WHERE nick='Haggar'),
+   1,
    (SELECT song FROM songs WHERE lower(title)=lower('Trip Machine Climax')),
    't',
    8251);
@@ -2048,17 +2240,19 @@ INSERT INTO roundparticipation (tournament, round, parallel, player, position) V
    (SELECT player FROM players WHERE nick='Nameless'),
    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 6'),
    4, 0,
    (SELECT player FROM players WHERE nick='Nameless'),
+   0,
    (SELECT song FROM songs WHERE lower(title)=lower('Burnin\' the Floor')),
    'f',
    6585);
-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 6'),
    4, 0,
    (SELECT player FROM players WHERE nick='Nameless'),
+   1,
    (SELECT song FROM songs WHERE lower(title)=lower('Exotic Ethnic')),
    't',
    8675);
@@ -2069,17 +2263,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 6'),
    4, 0,
    (SELECT player FROM players WHERE nick='Oliyzia'),
+   0,
    (SELECT song FROM songs WHERE lower(title)=lower('Burnin\' the Floor')),
    'f',
    7296);
-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 6'),
    4, 0,
    (SELECT player FROM players WHERE nick='Oliyzia'),
+   1,
    (SELECT song FROM songs WHERE lower(title)=lower('PARANOiA Rebirth')),
    't',
    8557);
@@ -2090,17 +2286,19 @@ 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 6'),
    4, 0,
    (SELECT player FROM players WHERE nick='Haggar'),
+   0,
    (SELECT song FROM songs WHERE lower(title)=lower('Burnin\' the Floor')),
    'f',
    6862);
-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 6'),
    4, 0,
    (SELECT player FROM players WHERE nick='Haggar'),
+   1,
    (SELECT song FROM songs WHERE lower(title)=lower('Exotic Ethnic')),
    't',
    8753);
@@ -2111,17 +2309,19 @@ INSERT INTO roundparticipation (tournament, round, parallel, player, position) V
    (SELECT player FROM players WHERE nick='Snofox'),
    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 6'),
    4, 0,
    (SELECT player FROM players WHERE nick='Snofox'),
+   0,
    (SELECT song FROM songs WHERE lower(title)=lower('Burnin\' the Floor')),
    'f',
    6871);
-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 6'),
    4, 0,
    (SELECT player FROM players WHERE nick='Snofox'),
+   1,
    (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)')),
    't',
    8802);
@@ -2132,17 +2332,19 @@ 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 6'),
    4, 0,
    (SELECT player FROM players WHERE nick='DufF'),
+   0,
    (SELECT song FROM songs WHERE lower(title)=lower('Burnin\' the Floor')),
    'f',
    6848);
-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 6'),
    4, 0,
    (SELECT player FROM players WHERE nick='DufF'),
+   1,
    (SELECT song FROM songs WHERE lower(title)=lower('Exotic Ethnic')),
    't',
    8826);
@@ -2153,17 +2355,19 @@ INSERT INTO roundparticipation (tournament, round, parallel, player, position) V
    (SELECT player FROM players WHERE nick='OJK'),
    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 6'),
    4, 0,
    (SELECT player FROM players WHERE nick='OJK'),
+   0,
    (SELECT song FROM songs WHERE lower(title)=lower('Burnin\' the Floor')),
    'f',
    7316);
-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 6'),
    4, 0,
    (SELECT player FROM players WHERE nick='OJK'),
+   1,
    (SELECT song FROM songs WHERE lower(title)=lower('Tsugaru')),
    't',
    8493);
@@ -2174,17 +2378,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 6'),
    4, 0,
    (SELECT player FROM players WHERE nick='Snute'),
+   0,
    (SELECT song FROM songs WHERE lower(title)=lower('Burnin\' the Floor')),
    'f',
    7651);
-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 6'),
    4, 0,
    (SELECT player FROM players WHERE nick='Snute'),
+   1,
    (SELECT song FROM songs WHERE lower(title)=lower('So Deep (Perfect Sphere Mix)')),
    't',
    8673);
@@ -2214,17 +2420,19 @@ INSERT INTO roundparticipation (tournament, round, parallel, player, position) V
    (SELECT player FROM players WHERE nick='Snofox'),
    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 6'),
    5, 0,
    (SELECT player FROM players WHERE nick='Snofox'),
+   0,
    (SELECT song FROM songs WHERE lower(title)=lower('The Centre of the Heart (Stonebridge Club Mix)')),
    'f',
    6649);
-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 6'),
    5, 0,
    (SELECT player FROM players WHERE nick='Snofox'),
+   1,
    (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
    't',
    8825);
@@ -2235,17 +2443,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 6'),
    5, 0,
    (SELECT player FROM players WHERE nick='DufF'),
+   0,
    (SELECT song FROM songs WHERE lower(title)=lower('The Centre of the Heart (Stonebridge Club Mix)')),
    'f',
    6860);
-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 6'),
    5, 0,
    (SELECT player FROM players WHERE nick='DufF'),
+   1,
    (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)')),
    't',
    8636);
@@ -2256,17 +2466,19 @@ INSERT INTO roundparticipation (tournament, round, parallel, player, position) V
    (SELECT player FROM players WHERE nick='OJK'),
    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 6'),
    5, 0,
    (SELECT player FROM players WHERE nick='OJK'),
+   0,
    (SELECT song FROM songs WHERE lower(title)=lower('The Centre of the Heart (Stonebridge Club Mix)')),
    'f',
    6603);
-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 6'),
    5, 0,
    (SELECT player FROM players WHERE nick='OJK'),
+   1,
    (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
    't',
    8868);
@@ -2277,17 +2489,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 6'),
    5, 0,
    (SELECT player FROM players WHERE nick='Oliyzia'),
+   0,
    (SELECT song FROM songs WHERE lower(title)=lower('The Centre of the Heart (Stonebridge Club Mix)')),
    'f',
    6652);
-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 6'),
    5, 0,
    (SELECT player FROM players WHERE nick='Oliyzia'),
+   1,
    (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)')),
    't',
    8169);
@@ -2298,17 +2512,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 6'),
    5, 0,
    (SELECT player FROM players WHERE nick='Snute'),
+   0,
    (SELECT song FROM songs WHERE lower(title)=lower('The Centre of the Heart (Stonebridge Club Mix)')),
    'f',
    6675);
-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 6'),
    5, 0,
    (SELECT player FROM players WHERE nick='Snute'),
+   1,
    (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
    't',
    8939);
@@ -2338,17 +2554,19 @@ INSERT INTO roundparticipation (tournament, round, parallel, player, position) V
    (SELECT player FROM players WHERE nick='OJK'),
    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 6'),
    6, 0,
    (SELECT player FROM players WHERE nick='OJK'),
+   0,
    (SELECT song FROM songs WHERE lower(title)=lower('Secret Rendez-vous')),
    'f',
    5446);
-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 6'),
    6, 0,
    (SELECT player FROM players WHERE nick='OJK'),
+   1,
    (SELECT song FROM songs WHERE lower(title)=lower('Max 300')),
    't',
    8499);
@@ -2359,17 +2577,19 @@ INSERT INTO roundparticipation (tournament, round, parallel, player, position) V
    (SELECT player FROM players WHERE nick='Snofox'),
    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 6'),
    6, 0,
    (SELECT player FROM players WHERE nick='Snofox'),
+   0,
    (SELECT song FROM songs WHERE lower(title)=lower('Secret Rendez-vous')),
    'f',
    5477);
-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 6'),
    6, 0,
    (SELECT player FROM players WHERE nick='Snofox'),
+   1,
    (SELECT song FROM songs WHERE lower(title)=lower('Crash!')),
    't',
    8241);
@@ -2380,17 +2600,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 6'),
    6, 0,
    (SELECT player FROM players WHERE nick='DufF'),
+   0,
    (SELECT song FROM songs WHERE lower(title)=lower('Secret Rendez-vous')),
    'f',
    6489);
-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 6'),
    6, 0,
    (SELECT player FROM players WHERE nick='DufF'),
+   1,
    (SELECT song FROM songs WHERE lower(title)=lower('Healing Vision (Angelic Mix)')),
    't',
    8776);
@@ -2401,17 +2623,19 @@ INSERT INTO roundparticipation (tournament, round, parallel, player, position) V
    (SELECT player FROM players WHERE nick='Snute'),
    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 6'),
    6, 0,
    (SELECT player FROM players WHERE nick='Snute'),
+   0,
    (SELECT song FROM songs WHERE lower(title)=lower('Secret Rendez-vous')),
    '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 6'),
    6, 0,
    (SELECT player FROM players WHERE nick='Snute'),
+   1,
    (SELECT song FROM songs WHERE lower(title)=lower('Dynamite Rave')),
    't',
    8849);
@@ -2441,17 +2665,19 @@ INSERT INTO roundparticipation (tournament, round, parallel, player, position) V
    (SELECT player FROM players WHERE nick='OJK'),
    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 6'),
    7, 0,
    (SELECT player FROM players WHERE nick='OJK'),
+   0,
    (SELECT song FROM songs WHERE lower(title)=lower('Memories')),
    '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 6'),
    7, 0,
    (SELECT player FROM players WHERE nick='OJK'),
+   1,
    (SELECT song FROM songs WHERE lower(title)=lower('Candy')),
    't',
    8841);
@@ -2462,17 +2688,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 6'),
    7, 0,
    (SELECT player FROM players WHERE nick='DufF'),
+   0,
    (SELECT song FROM songs WHERE lower(title)=lower('Memories')),
    'f',
    7327);
-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 6'),
    7, 0,
    (SELECT player FROM players WHERE nick='DufF'),
+   1,
    (SELECT song FROM songs WHERE lower(title)=lower('Crash!')),
    't',
    8803);
@@ -2483,17 +2711,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 6'),
    7, 0,
    (SELECT player FROM players WHERE nick='Snute'),
+   0,
    (SELECT song FROM songs WHERE lower(title)=lower('Memories')),
    'f',
    7717);
-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 6'),
    7, 0,
    (SELECT player FROM players WHERE nick='Snute'),
+   1,
    (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)')),
    't',
    8717);
@@ -2525,17 +2755,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 6'),
    8, 0,
    (SELECT player FROM players WHERE nick='DufF'),
+   0,
    (SELECT song FROM songs WHERE lower(title)=lower('Destiny')),
    'f',
    5834);
-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 6'),
    8, 0,
    (SELECT player FROM players WHERE nick='DufF'),
+   1,
    (SELECT song FROM songs WHERE lower(title)=lower('Max 300')),
    'f',
    9140);
@@ -2546,17 +2778,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 6'),
    8, 0,
    (SELECT player FROM players WHERE nick='Snute'),
+   0,
    (SELECT song FROM songs WHERE lower(title)=lower('Destiny')),
    'f',
    6579);
-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 6'),
    8, 0,
    (SELECT player FROM players WHERE nick='Snute'),
+   1,
    (SELECT song FROM songs WHERE lower(title)=lower('Max 300')),
    'f',
    9681);