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

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

diff --git a/sql/cc04/cc4-04.sql b/sql/cc04/cc4-04.sql
index d16503db24ef7fb4f5ff3a0751f32cb278b8777c..e44caaa0d00520ff76af5ef6d707e1a3d1a2c9c6 100644 (file)
--- a/sql/cc04/cc4-04.sql
+++ b/sql/cc04/cc4-04.sql
@@ -40,24 +40,27 @@ INSERT INTO roundparticipation (tournament, round, parallel, player, position) V
    (SELECT player FROM players WHERE nick='Pål Andre'),
    1
 );
    (SELECT player FROM players WHERE nick='Pål Andre'),
    1
 );

-INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (

    (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
    1, 1,
    (SELECT player FROM players WHERE nick='Pål Andre'),
    (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
    1, 1,
    (SELECT player FROM players WHERE nick='Pål Andre'),

+   0,

    (SELECT song FROM songs WHERE lower(title)=lower('Nori Nori Nori')),
    'f',
    5755);
    (SELECT song FROM songs WHERE lower(title)=lower('Nori Nori Nori')),
    'f',
    5755);

-INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (

    (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
    1, 1,
    (SELECT player FROM players WHERE nick='Pål Andre'),
    (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
    1, 1,
    (SELECT player FROM players WHERE nick='Pål Andre'),

+   1,

    (SELECT song FROM songs WHERE lower(title)=lower('PARANOiA Rebirth')),
    'f',
    7439);
    (SELECT song FROM songs WHERE lower(title)=lower('PARANOiA Rebirth')),
    'f',
    7439);

-INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (

    (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
    1, 1,
    (SELECT player FROM players WHERE nick='Pål Andre'),
    (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
    1, 1,
    (SELECT player FROM players WHERE nick='Pål Andre'),

+   2,

    (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
    't',
    7946);
    (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
    't',
    7946);


@@ -68,24 +71,27 @@ INSERT INTO roundparticipation (tournament, round, parallel, player, position) V
    (SELECT player FROM players WHERE nick='Tassen'),
    2
 );
    (SELECT player FROM players WHERE nick='Tassen'),
    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 4'),
    1, 1,
    (SELECT player FROM players WHERE nick='Tassen'),
    (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
    1, 1,
    (SELECT player FROM players WHERE nick='Tassen'),

+   0,

    (SELECT song FROM songs WHERE lower(title)=lower('Nori Nori Nori')),
    'f',
    5862);
    (SELECT song FROM songs WHERE lower(title)=lower('Nori Nori Nori')),
    'f',
    5862);

-INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (

    (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
    1, 1,
    (SELECT player FROM players WHERE nick='Tassen'),
    (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
    1, 1,
    (SELECT player FROM players WHERE nick='Tassen'),

+   1,

    (SELECT song FROM songs WHERE lower(title)=lower('PARANOiA Rebirth')),
    'f',
    7465);
    (SELECT song FROM songs WHERE lower(title)=lower('PARANOiA Rebirth')),
    'f',
    7465);

-INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (

    (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
    1, 1,
    (SELECT player FROM players WHERE nick='Tassen'),
    (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
    1, 1,
    (SELECT player FROM players WHERE nick='Tassen'),

+   2,

    (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
    't',
    8018);
    (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
    't',
    8018);


@@ -96,24 +102,27 @@ INSERT INTO roundparticipation (tournament, round, parallel, player, position) V
    (SELECT player FROM players WHERE nick='Haggar'),
    3
 );
    (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 4'),
    1, 1,
    (SELECT player FROM players WHERE nick='Haggar'),
    (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
    1, 1,
    (SELECT player FROM players WHERE nick='Haggar'),

+   0,

    (SELECT song FROM songs WHERE lower(title)=lower('Nori Nori Nori')),
    'f',
    6303);
    (SELECT song FROM songs WHERE lower(title)=lower('Nori Nori Nori')),
    'f',
    6303);

-INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (

    (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
    1, 1,
    (SELECT player FROM players WHERE nick='Haggar'),
    (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
    1, 1,
    (SELECT player FROM players WHERE nick='Haggar'),

+   1,

    (SELECT song FROM songs WHERE lower(title)=lower('PARANOiA Rebirth')),
    'f',
    8631);
    (SELECT song FROM songs WHERE lower(title)=lower('PARANOiA Rebirth')),
    '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 4'),
    1, 1,
    (SELECT player FROM players WHERE nick='Haggar'),
    (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
    1, 1,
    (SELECT player FROM players WHERE nick='Haggar'),

+   2,

    (SELECT song FROM songs WHERE lower(title)=lower('Rain of Sorrow')),
    't',
    8233);
    (SELECT song FROM songs WHERE lower(title)=lower('Rain of Sorrow')),
    't',
    8233);


@@ -124,24 +133,27 @@ INSERT INTO roundparticipation (tournament, round, parallel, player, position) V
    (SELECT player FROM players WHERE nick='Draconia'),
    4
 );
    (SELECT player FROM players WHERE nick='Draconia'),
    4
 );

-INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (

    (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
    1, 1,
    (SELECT player FROM players WHERE nick='Draconia'),
    (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
    1, 1,
    (SELECT player FROM players WHERE nick='Draconia'),

+   0,

    (SELECT song FROM songs WHERE lower(title)=lower('Nori Nori Nori')),
    'f',
    5607);
    (SELECT song FROM songs WHERE lower(title)=lower('Nori Nori Nori')),
    'f',
    5607);

-INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (

    (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
    1, 1,
    (SELECT player FROM players WHERE nick='Draconia'),
    (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
    1, 1,
    (SELECT player FROM players WHERE nick='Draconia'),

+   1,

    (SELECT song FROM songs WHERE lower(title)=lower('PARANOiA Rebirth')),
    'f',
    5191);
    (SELECT song FROM songs WHERE lower(title)=lower('PARANOiA Rebirth')),
    'f',
    5191);

-INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (

    (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
    1, 1,
    (SELECT player FROM players WHERE nick='Draconia'),
    (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
    1, 1,
    (SELECT player FROM players WHERE nick='Draconia'),

+   2,

    (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)')),
    't',
    8169);
    (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)')),
    't',
    8169);


@@ -152,24 +164,27 @@ INSERT INTO roundparticipation (tournament, round, parallel, player, position) V
    (SELECT player FROM players WHERE nick='Snute'),
    5
 );
    (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 4'),
    1, 1,
    (SELECT player FROM players WHERE nick='Snute'),
    (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
    1, 1,
    (SELECT player FROM players WHERE nick='Snute'),

+   0,

    (SELECT song FROM songs WHERE lower(title)=lower('Nori Nori Nori')),
    'f',
    6749);
    (SELECT song FROM songs WHERE lower(title)=lower('Nori Nori Nori')),
    'f',
    6749);

-INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (

    (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
    1, 1,
    (SELECT player FROM players WHERE nick='Snute'),
    (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
    1, 1,
    (SELECT player FROM players WHERE nick='Snute'),

+   1,

    (SELECT song FROM songs WHERE lower(title)=lower('PARANOiA Rebirth')),
    'f',
    8741);
    (SELECT song FROM songs WHERE lower(title)=lower('PARANOiA Rebirth')),
    'f',
    8741);

-INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (

    (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
    1, 1,
    (SELECT player FROM players WHERE nick='Snute'),
    (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
    1, 1,
    (SELECT player FROM players WHERE nick='Snute'),

+   2,

    (SELECT song FROM songs WHERE lower(title)=lower('End of the Century')),
    't',
    8874);
    (SELECT song FROM songs WHERE lower(title)=lower('End of the Century')),
    't',
    8874);


@@ -199,24 +214,27 @@ INSERT INTO roundparticipation (tournament, round, parallel, player, position) V
    (SELECT player FROM players WHERE nick='Mync'),
    1
 );
    (SELECT player FROM players WHERE nick='Mync'),
    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 4'),
    1, 2,
    (SELECT player FROM players WHERE nick='Mync'),
    (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
    1, 2,
    (SELECT player FROM players WHERE nick='Mync'),

+   0,

    (SELECT song FROM songs WHERE lower(title)=lower('Cotton-Eye Joe')),
    'f',
    5430);
    (SELECT song FROM songs WHERE lower(title)=lower('Cotton-Eye Joe')),
    'f',
    5430);

-INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (

    (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
    1, 2,
    (SELECT player FROM players WHERE nick='Mync'),
    (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
    1, 2,
    (SELECT player FROM players WHERE nick='Mync'),

+   1,

    (SELECT song FROM songs WHERE lower(title)=lower('Stomp')),
    'f',
    5492);
    (SELECT song FROM songs WHERE lower(title)=lower('Stomp')),
    'f',
    5492);

-INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (

    (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
    1, 2,
    (SELECT player FROM players WHERE nick='Mync'),
    (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
    1, 2,
    (SELECT player FROM players WHERE nick='Mync'),

+   2,

    (SELECT song FROM songs WHERE lower(title)=lower('Exotic Ethnic')),
    't',
    8444);
    (SELECT song FROM songs WHERE lower(title)=lower('Exotic Ethnic')),
    't',
    8444);


@@ -227,24 +245,27 @@ INSERT INTO roundparticipation (tournament, round, parallel, player, position) V
    (SELECT player FROM players WHERE nick='Glukko'),
    2
 );
    (SELECT player FROM players WHERE nick='Glukko'),
    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 4'),
    1, 2,
    (SELECT player FROM players WHERE nick='Glukko'),
    (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
    1, 2,
    (SELECT player FROM players WHERE nick='Glukko'),

+   0,

    (SELECT song FROM songs WHERE lower(title)=lower('Cotton-Eye Joe')),
    'f',
    2894);
    (SELECT song FROM songs WHERE lower(title)=lower('Cotton-Eye Joe')),
    'f',
    2894);

-INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (

    (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
    1, 2,
    (SELECT player FROM players WHERE nick='Glukko'),
    (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
    1, 2,
    (SELECT player FROM players WHERE nick='Glukko'),

+   1,

    (SELECT song FROM songs WHERE lower(title)=lower('Stomp')),
    'f',
    3223);
    (SELECT song FROM songs WHERE lower(title)=lower('Stomp')),
    'f',
    3223);

-INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (

    (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
    1, 2,
    (SELECT player FROM players WHERE nick='Glukko'),
    (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
    1, 2,
    (SELECT player FROM players WHERE nick='Glukko'),

+   2,

    (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
    't',
    5806);
    (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
    't',
    5806);


@@ -255,24 +276,27 @@ INSERT INTO roundparticipation (tournament, round, parallel, player, position) V
    (SELECT player FROM players WHERE nick='Mulefisk'),
    3
 );
    (SELECT player FROM players WHERE nick='Mulefisk'),
    3
 );

-INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (

    (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
    1, 2,
    (SELECT player FROM players WHERE nick='Mulefisk'),
    (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
    1, 2,
    (SELECT player FROM players WHERE nick='Mulefisk'),

+   0,

    (SELECT song FROM songs WHERE lower(title)=lower('Cotton-Eye Joe')),
    'f',
    6127);
    (SELECT song FROM songs WHERE lower(title)=lower('Cotton-Eye Joe')),
    'f',
    6127);

-INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (

    (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
    1, 2,
    (SELECT player FROM players WHERE nick='Mulefisk'),
    (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
    1, 2,
    (SELECT player FROM players WHERE nick='Mulefisk'),

+   1,

    (SELECT song FROM songs WHERE lower(title)=lower('Stomp')),
    'f',
    6043);
    (SELECT song FROM songs WHERE lower(title)=lower('Stomp')),
    'f',
    6043);

-INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (

    (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
    1, 2,
    (SELECT player FROM players WHERE nick='Mulefisk'),
    (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
    1, 2,
    (SELECT player FROM players WHERE nick='Mulefisk'),

+   2,

    (SELECT song FROM songs WHERE lower(title)=lower('PARANOiA Rebirth')),
    't',
    8149);
    (SELECT song FROM songs WHERE lower(title)=lower('PARANOiA Rebirth')),
    't',
    8149);


@@ -283,24 +307,27 @@ INSERT INTO roundparticipation (tournament, round, parallel, player, position) V
    (SELECT player FROM players WHERE nick='Ylini'),
    4
 );
    (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 4'),
    1, 2,
    (SELECT player FROM players WHERE nick='Ylini'),
    (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
    1, 2,
    (SELECT player FROM players WHERE nick='Ylini'),

+   0,

    (SELECT song FROM songs WHERE lower(title)=lower('Cotton-Eye Joe')),
    'f',
    6012);
    (SELECT song FROM songs WHERE lower(title)=lower('Cotton-Eye Joe')),
    'f',
    6012);

-INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (

    (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
    1, 2,
    (SELECT player FROM players WHERE nick='Ylini'),
    (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
    1, 2,
    (SELECT player FROM players WHERE nick='Ylini'),

+   1,

    (SELECT song FROM songs WHERE lower(title)=lower('Stomp')),
    'f',
    5709);
    (SELECT song FROM songs WHERE lower(title)=lower('Stomp')),
    'f',
    5709);

-INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (

    (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
    1, 2,
    (SELECT player FROM players WHERE nick='Ylini'),
    (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
    1, 2,
    (SELECT player FROM players WHERE nick='Ylini'),

+   2,

    (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)')),
    't',
    8211);
    (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)')),
    't',
    8211);


@@ -311,24 +338,27 @@ INSERT INTO roundparticipation (tournament, round, parallel, player, position) V
    (SELECT player FROM players WHERE nick='DufF'),
    5
 );
    (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 4'),
    1, 2,
    (SELECT player FROM players WHERE nick='DufF'),
    (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
    1, 2,
    (SELECT player FROM players WHERE nick='DufF'),

+   0,

    (SELECT song FROM songs WHERE lower(title)=lower('Cotton-Eye Joe')),
    'f',
    6811);
    (SELECT song FROM songs WHERE lower(title)=lower('Cotton-Eye Joe')),
    'f',
    6811);

-INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (

    (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
    1, 2,
    (SELECT player FROM players WHERE nick='DufF'),
    (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
    1, 2,
    (SELECT player FROM players WHERE nick='DufF'),

+   1,

    (SELECT song FROM songs WHERE lower(title)=lower('Stomp')),
    'f',
    6585);
    (SELECT song FROM songs WHERE lower(title)=lower('Stomp')),
    '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 4'),
    1, 2,
    (SELECT player FROM players WHERE nick='DufF'),
    (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
    1, 2,
    (SELECT player FROM players WHERE nick='DufF'),

+   2,

    (SELECT song FROM songs WHERE lower(title)=lower('Afronova Primeval')),
    't',
    8457);
    (SELECT song FROM songs WHERE lower(title)=lower('Afronova Primeval')),
    't',
    8457);


@@ -358,24 +388,27 @@ INSERT INTO roundparticipation (tournament, round, parallel, player, position) V
    (SELECT player FROM players WHERE nick='Pingo'),
    1
 );
    (SELECT player FROM players WHERE nick='Pingo'),
    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 4'),
    1, 3,
    (SELECT player FROM players WHERE nick='Pingo'),
    (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
    1, 3,
    (SELECT player FROM players WHERE nick='Pingo'),

+   0,

    (SELECT song FROM songs WHERE lower(title)=lower('My Summer Love')),
    'f',
    7866);
    (SELECT song FROM songs WHERE lower(title)=lower('My Summer Love')),
    'f',
    7866);

-INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (

    (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
    1, 3,
    (SELECT player FROM players WHERE nick='Pingo'),
    (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
    1, 3,
    (SELECT player FROM players WHERE nick='Pingo'),

+   1,

    (SELECT song FROM songs WHERE lower(title)=lower('Exotic Ethnic')),
    'f',
    7709);
    (SELECT song FROM songs WHERE lower(title)=lower('Exotic Ethnic')),
    'f',
    7709);

-INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (

    (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
    1, 3,
    (SELECT player FROM players WHERE nick='Pingo'),
    (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
    1, 3,
    (SELECT player FROM players WHERE nick='Pingo'),

+   2,

    (SELECT song FROM songs WHERE lower(title)=lower('Don\'t Try to Stop It')),
    't',
    7000);
    (SELECT song FROM songs WHERE lower(title)=lower('Don\'t Try to Stop It')),
    't',
    7000);


@@ -386,24 +419,27 @@ INSERT INTO roundparticipation (tournament, round, parallel, player, position) V
    (SELECT player FROM players WHERE nick='Jim Andre'),
    2
 );
    (SELECT player FROM players WHERE nick='Jim Andre'),
    2
 );

-INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (

    (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
    1, 3,
    (SELECT player FROM players WHERE nick='Jim Andre'),
    (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
    1, 3,
    (SELECT player FROM players WHERE nick='Jim Andre'),

+   0,

    (SELECT song FROM songs WHERE lower(title)=lower('My Summer Love')),
    'f',
    4750);
    (SELECT song FROM songs WHERE lower(title)=lower('My Summer Love')),
    'f',
    4750);

-INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (

    (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
    1, 3,
    (SELECT player FROM players WHERE nick='Jim Andre'),
    (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
    1, 3,
    (SELECT player FROM players WHERE nick='Jim Andre'),

+   1,

    (SELECT song FROM songs WHERE lower(title)=lower('Exotic Ethnic')),
    'f',
    6116);
    (SELECT song FROM songs WHERE lower(title)=lower('Exotic Ethnic')),
    'f',
    6116);

-INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (

    (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
    1, 3,
    (SELECT player FROM players WHERE nick='Jim Andre'),
    (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
    1, 3,
    (SELECT player FROM players WHERE nick='Jim Andre'),

+   2,

    (SELECT song FROM songs WHERE lower(title)=lower('I Want You To Want Me')),
    't',
    732);
    (SELECT song FROM songs WHERE lower(title)=lower('I Want You To Want Me')),
    't',
    732);


@@ -414,24 +450,27 @@ INSERT INTO roundparticipation (tournament, round, parallel, player, position) V
    (SELECT player FROM players WHERE nick='Dabi'),
    3
 );
    (SELECT player FROM players WHERE nick='Dabi'),
    3
 );

-INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (

    (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
    1, 3,
    (SELECT player FROM players WHERE nick='Dabi'),
    (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
    1, 3,
    (SELECT player FROM players WHERE nick='Dabi'),

+   0,

    (SELECT song FROM songs WHERE lower(title)=lower('My Summer Love')),
    'f',
    4556);
    (SELECT song FROM songs WHERE lower(title)=lower('My Summer Love')),
    'f',
    4556);

-INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (

    (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
    1, 3,
    (SELECT player FROM players WHERE nick='Dabi'),
    (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
    1, 3,
    (SELECT player FROM players WHERE nick='Dabi'),

+   1,

    (SELECT song FROM songs WHERE lower(title)=lower('Exotic Ethnic')),
    'f',
    4005);
    (SELECT song FROM songs WHERE lower(title)=lower('Exotic Ethnic')),
    'f',
    4005);

-INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (

    (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
    1, 3,
    (SELECT player FROM players WHERE nick='Dabi'),
    (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
    1, 3,
    (SELECT player FROM players WHERE nick='Dabi'),

+   2,

    (SELECT song FROM songs WHERE lower(title)=lower('Crash!')),
    't',
    4005);
    (SELECT song FROM songs WHERE lower(title)=lower('Crash!')),
    't',
    4005);


@@ -442,24 +481,27 @@ INSERT INTO roundparticipation (tournament, round, parallel, player, position) V
    (SELECT player FROM players WHERE nick='Olemann'),
    4
 );
    (SELECT player FROM players WHERE nick='Olemann'),
    4
 );

-INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (

    (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
    1, 3,
    (SELECT player FROM players WHERE nick='Olemann'),
    (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
    1, 3,
    (SELECT player FROM players WHERE nick='Olemann'),

+   0,

    (SELECT song FROM songs WHERE lower(title)=lower('My Summer Love')),
    'f',
    7080);
    (SELECT song FROM songs WHERE lower(title)=lower('My Summer Love')),
    'f',
    7080);

-INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (

    (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
    1, 3,
    (SELECT player FROM players WHERE nick='Olemann'),
    (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
    1, 3,
    (SELECT player FROM players WHERE nick='Olemann'),

+   1,

    (SELECT song FROM songs WHERE lower(title)=lower('Exotic Ethnic')),
    'f',
    7509);
    (SELECT song FROM songs WHERE lower(title)=lower('Exotic Ethnic')),
    'f',
    7509);

-INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (

    (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
    1, 3,
    (SELECT player FROM players WHERE nick='Olemann'),
    (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
    1, 3,
    (SELECT player FROM players WHERE nick='Olemann'),

+   2,

    (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)')),
    't',
    7509);
    (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)')),
    't',
    7509);


@@ -470,24 +512,27 @@ INSERT INTO roundparticipation (tournament, round, parallel, player, position) V
    (SELECT player FROM players WHERE nick='OJK'),
    5
 );
    (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 4'),
    1, 3,
    (SELECT player FROM players WHERE nick='OJK'),
    (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
    1, 3,
    (SELECT player FROM players WHERE nick='OJK'),

+   0,

    (SELECT song FROM songs WHERE lower(title)=lower('My Summer Love')),
    'f',
    8480);
    (SELECT song FROM songs WHERE lower(title)=lower('My Summer Love')),
    'f',
    8480);

-INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (

    (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
    1, 3,
    (SELECT player FROM players WHERE nick='OJK'),
    (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
    1, 3,
    (SELECT player FROM players WHERE nick='OJK'),

+   1,

    (SELECT song FROM songs WHERE lower(title)=lower('Exotic Ethnic')),
    'f',
    8664);
    (SELECT song FROM songs WHERE lower(title)=lower('Exotic Ethnic')),
    'f',
    8664);

-INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (

    (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
    1, 3,
    (SELECT player FROM players WHERE nick='OJK'),
    (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
    1, 3,
    (SELECT player FROM players WHERE nick='OJK'),

+   2,

    (SELECT song FROM songs WHERE lower(title)=lower('Trip Machine (Luv Mix)')),
    't',
    8664);
    (SELECT song FROM songs WHERE lower(title)=lower('Trip Machine (Luv Mix)')),
    't',
    8664);


@@ -517,24 +562,27 @@ INSERT INTO roundparticipation (tournament, round, parallel, player, position) V
    (SELECT player FROM players WHERE nick='Mario'),
    1
 );
    (SELECT player FROM players WHERE nick='Mario'),
    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 4'),
    1, 4,
    (SELECT player FROM players WHERE nick='Mario'),
    (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
    1, 4,
    (SELECT player FROM players WHERE nick='Mario'),

+   0,

    (SELECT song FROM songs WHERE lower(title)=lower('Max 300')),
    'f',
    5758);
    (SELECT song FROM songs WHERE lower(title)=lower('Max 300')),
    'f',
    5758);

-INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (

    (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
    1, 4,
    (SELECT player FROM players WHERE nick='Mario'),
    (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
    1, 4,
    (SELECT player FROM players WHERE nick='Mario'),

+   1,

    (SELECT song FROM songs WHERE lower(title)=lower('Spin the disc')),
    'f',
    6465);
    (SELECT song FROM songs WHERE lower(title)=lower('Spin the disc')),
    'f',
    6465);

-INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (

    (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
    1, 4,
    (SELECT player FROM players WHERE nick='Mario'),
    (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
    1, 4,
    (SELECT player FROM players WHERE nick='Mario'),

+   2,

    (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love (SPEED MIX)')),
    't',
    0);
    (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love (SPEED MIX)')),
    't',
    0);


@@ -545,24 +593,27 @@ INSERT INTO roundparticipation (tournament, round, parallel, player, position) V
    (SELECT player FROM players WHERE nick='Gogo'),
    2
 );
    (SELECT player FROM players WHERE nick='Gogo'),
    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 4'),
    1, 4,
    (SELECT player FROM players WHERE nick='Gogo'),
    (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
    1, 4,
    (SELECT player FROM players WHERE nick='Gogo'),

+   0,

    (SELECT song FROM songs WHERE lower(title)=lower('Max 300')),
    'f',
    6758);
    (SELECT song FROM songs WHERE lower(title)=lower('Max 300')),
    'f',
    6758);

-INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (

    (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
    1, 4,
    (SELECT player FROM players WHERE nick='Gogo'),
    (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
    1, 4,
    (SELECT player FROM players WHERE nick='Gogo'),

+   1,

    (SELECT song FROM songs WHERE lower(title)=lower('Spin the disc')),
    'f',
    7512);
    (SELECT song FROM songs WHERE lower(title)=lower('Spin the disc')),
    'f',
    7512);

-INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (

    (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
    1, 4,
    (SELECT player FROM players WHERE nick='Gogo'),
    (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
    1, 4,
    (SELECT player FROM players WHERE nick='Gogo'),

+   2,

    (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
    't',
    8708);
    (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
    't',
    8708);


@@ -573,24 +624,27 @@ INSERT INTO roundparticipation (tournament, round, parallel, player, position) V
    (SELECT player FROM players WHERE nick='Ted Kristian'),
    3
 );
    (SELECT player FROM players WHERE nick='Ted Kristian'),
    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 4'),
    1, 4,
    (SELECT player FROM players WHERE nick='Ted Kristian'),
    (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
    1, 4,
    (SELECT player FROM players WHERE nick='Ted Kristian'),

+   0,

    (SELECT song FROM songs WHERE lower(title)=lower('Max 300')),
    'f',
    5911);
    (SELECT song FROM songs WHERE lower(title)=lower('Max 300')),
    'f',
    5911);

-INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (

    (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
    1, 4,
    (SELECT player FROM players WHERE nick='Ted Kristian'),
    (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
    1, 4,
    (SELECT player FROM players WHERE nick='Ted Kristian'),

+   1,

    (SELECT song FROM songs WHERE lower(title)=lower('Spin the disc')),
    'f',
    6985);
    (SELECT song FROM songs WHERE lower(title)=lower('Spin the disc')),
    'f',
    6985);

-INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (

    (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
    1, 4,
    (SELECT player FROM players WHERE nick='Ted Kristian'),
    (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
    1, 4,
    (SELECT player FROM players WHERE nick='Ted Kristian'),

+   2,

    (SELECT song FROM songs WHERE lower(title)=lower('Dead End')),
    't',
    7493);
    (SELECT song FROM songs WHERE lower(title)=lower('Dead End')),
    't',
    7493);


@@ -601,24 +655,27 @@ INSERT INTO roundparticipation (tournament, round, parallel, player, position) V
    (SELECT player FROM players WHERE nick='Duckling'),
    4
 );
    (SELECT player FROM players WHERE nick='Duckling'),
    4
 );

-INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (

    (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
    1, 4,
    (SELECT player FROM players WHERE nick='Duckling'),
    (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
    1, 4,
    (SELECT player FROM players WHERE nick='Duckling'),

+   0,

    (SELECT song FROM songs WHERE lower(title)=lower('Max 300')),
    'f',
    7250);
    (SELECT song FROM songs WHERE lower(title)=lower('Max 300')),
    'f',
    7250);

-INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (

    (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
    1, 4,
    (SELECT player FROM players WHERE nick='Duckling'),
    (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
    1, 4,
    (SELECT player FROM players WHERE nick='Duckling'),

+   1,

    (SELECT song FROM songs WHERE lower(title)=lower('Spin the disc')),
    'f',
    6600);
    (SELECT song FROM songs WHERE lower(title)=lower('Spin the disc')),
    'f',
    6600);

-INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (

    (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
    1, 4,
    (SELECT player FROM players WHERE nick='Duckling'),
    (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
    1, 4,
    (SELECT player FROM players WHERE nick='Duckling'),

+   2,

    (SELECT song FROM songs WHERE lower(title)=lower('Tsugaru')),
    't',
    7872);
    (SELECT song FROM songs WHERE lower(title)=lower('Tsugaru')),
    't',
    7872);


@@ -629,24 +686,27 @@ INSERT INTO roundparticipation (tournament, round, parallel, player, position) V
    (SELECT player FROM players WHERE nick='Smiph'),
    5
 );
    (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 4'),
    1, 4,
    (SELECT player FROM players WHERE nick='Smiph'),
    (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
    1, 4,
    (SELECT player FROM players WHERE nick='Smiph'),

+   0,

    (SELECT song FROM songs WHERE lower(title)=lower('Max 300')),
    'f',
    6036);
    (SELECT song FROM songs WHERE lower(title)=lower('Max 300')),
    'f',
    6036);

-INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (

    (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
    1, 4,
    (SELECT player FROM players WHERE nick='Smiph'),
    (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
    1, 4,
    (SELECT player FROM players WHERE nick='Smiph'),

+   1,

    (SELECT song FROM songs WHERE lower(title)=lower('Spin the disc')),
    'f',
    6297);
    (SELECT song FROM songs WHERE lower(title)=lower('Spin the disc')),
    'f',
    6297);

-INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (

    (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
    1, 4,
    (SELECT player FROM players WHERE nick='Smiph'),
    (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
    1, 4,
    (SELECT player FROM players WHERE nick='Smiph'),

+   2,

    (SELECT song FROM songs WHERE lower(title)=lower('Look to the sky')),
    't',
    4416);
    (SELECT song FROM songs WHERE lower(title)=lower('Look to the sky')),
    't',
    4416);


@@ -657,24 +717,27 @@ INSERT INTO roundparticipation (tournament, round, parallel, player, position) V
    (SELECT player FROM players WHERE nick='RiChY'),
    6
 );
    (SELECT player FROM players WHERE nick='RiChY'),
    6
 );

-INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (

    (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
    1, 4,
    (SELECT player FROM players WHERE nick='RiChY'),
    (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
    1, 4,
    (SELECT player FROM players WHERE nick='RiChY'),

+   0,

    (SELECT song FROM songs WHERE lower(title)=lower('Max 300')),
    'f',
    8446);
    (SELECT song FROM songs WHERE lower(title)=lower('Max 300')),
    'f',
    8446);

-INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (

    (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
    1, 4,
    (SELECT player FROM players WHERE nick='RiChY'),
    (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
    1, 4,
    (SELECT player FROM players WHERE nick='RiChY'),

+   1,

    (SELECT song FROM songs WHERE lower(title)=lower('Spin the disc')),
    'f',
    7602);
    (SELECT song FROM songs WHERE lower(title)=lower('Spin the disc')),
    'f',
    7602);

-INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (

    (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
    1, 4,
    (SELECT player FROM players WHERE nick='RiChY'),
    (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
    1, 4,
    (SELECT player FROM players WHERE nick='RiChY'),

+   2,

    (SELECT song FROM songs WHERE lower(title)=lower('Rain of Sorrow')),
    't',
    7739);
    (SELECT song FROM songs WHERE lower(title)=lower('Rain of Sorrow')),
    't',
    7739);


@@ -704,24 +767,27 @@ INSERT INTO roundparticipation (tournament, round, parallel, player, position) V
    (SELECT player FROM players WHERE nick='Alexxz'),
    1
 );
    (SELECT player FROM players WHERE nick='Alexxz'),
    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 4'),
    1, 5,
    (SELECT player FROM players WHERE nick='Alexxz'),
    (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
    1, 5,
    (SELECT player FROM players WHERE nick='Alexxz'),

+   0,

    (SELECT song FROM songs WHERE lower(title)=lower('Make A Jam!')),
    'f',
    4861);
    (SELECT song FROM songs WHERE lower(title)=lower('Make A Jam!')),
    'f',
    4861);

-INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (

    (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
    1, 5,
    (SELECT player FROM players WHERE nick='Alexxz'),
    (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
    1, 5,
    (SELECT player FROM players WHERE nick='Alexxz'),

+   1,

    (SELECT song FROM songs WHERE lower(title)=lower('Living in America')),
    'f',
    4170);
    (SELECT song FROM songs WHERE lower(title)=lower('Living in America')),
    'f',
    4170);

-INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (

    (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
    1, 5,
    (SELECT player FROM players WHERE nick='Alexxz'),
    (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
    1, 5,
    (SELECT player FROM players WHERE nick='Alexxz'),

+   2,

    (SELECT song FROM songs WHERE lower(title)=lower('My Summer Love')),
    't',
    7512);
    (SELECT song FROM songs WHERE lower(title)=lower('My Summer Love')),
    't',
    7512);


@@ -732,24 +798,27 @@ INSERT INTO roundparticipation (tournament, round, parallel, player, position) V
    (SELECT player FROM players WHERE nick='Zeek'),
    2
 );
    (SELECT player FROM players WHERE nick='Zeek'),
    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 4'),
    1, 5,
    (SELECT player FROM players WHERE nick='Zeek'),
    (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
    1, 5,
    (SELECT player FROM players WHERE nick='Zeek'),

+   0,

    (SELECT song FROM songs WHERE lower(title)=lower('Make A Jam!')),
    'f',
    3749);
    (SELECT song FROM songs WHERE lower(title)=lower('Make A Jam!')),
    'f',
    3749);

-INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (

    (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
    1, 5,
    (SELECT player FROM players WHERE nick='Zeek'),
    (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
    1, 5,
    (SELECT player FROM players WHERE nick='Zeek'),

+   1,

    (SELECT song FROM songs WHERE lower(title)=lower('Living in America')),
    'f',
    3734);
    (SELECT song FROM songs WHERE lower(title)=lower('Living in America')),
    'f',
    3734);

-INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (

    (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
    1, 5,
    (SELECT player FROM players WHERE nick='Zeek'),
    (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
    1, 5,
    (SELECT player FROM players WHERE nick='Zeek'),

+   2,

    (SELECT song FROM songs WHERE lower(title)=lower('Jam Jam Reggae (AM Swing Mix)')),
    't',
    5129);
    (SELECT song FROM songs WHERE lower(title)=lower('Jam Jam Reggae (AM Swing Mix)')),
    't',
    5129);


@@ -760,24 +829,27 @@ INSERT INTO roundparticipation (tournament, round, parallel, player, position) V
    (SELECT player FROM players WHERE nick='Bonzo'),
    3
 );
    (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 4'),
    1, 5,
    (SELECT player FROM players WHERE nick='Bonzo'),
    (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
    1, 5,
    (SELECT player FROM players WHERE nick='Bonzo'),

+   0,

    (SELECT song FROM songs WHERE lower(title)=lower('Make A Jam!')),
    'f',
    6065);
    (SELECT song FROM songs WHERE lower(title)=lower('Make A Jam!')),
    'f',
    6065);

-INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (

    (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
    1, 5,
    (SELECT player FROM players WHERE nick='Bonzo'),
    (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
    1, 5,
    (SELECT player FROM players WHERE nick='Bonzo'),

+   1,

    (SELECT song FROM songs WHERE lower(title)=lower('Living in America')),
    'f',
    6185);
    (SELECT song FROM songs WHERE lower(title)=lower('Living in America')),
    'f',
    6185);

-INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (

    (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
    1, 5,
    (SELECT player FROM players WHERE nick='Bonzo'),
    (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
    1, 5,
    (SELECT player FROM players WHERE nick='Bonzo'),

+   2,

    (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
    't',
    8490);
    (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
    't',
    8490);


@@ -788,24 +860,27 @@ INSERT INTO roundparticipation (tournament, round, parallel, player, position) V
    (SELECT player FROM players WHERE nick='Tom'),
    4
 );
    (SELECT player FROM players WHERE nick='Tom'),
    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 4'),
    1, 5,
    (SELECT player FROM players WHERE nick='Tom'),
    (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
    1, 5,
    (SELECT player FROM players WHERE nick='Tom'),

+   0,

    (SELECT song FROM songs WHERE lower(title)=lower('Make A Jam!')),
    'f',
    7240);
    (SELECT song FROM songs WHERE lower(title)=lower('Make A Jam!')),
    'f',
    7240);

-INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (

    (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
    1, 5,
    (SELECT player FROM players WHERE nick='Tom'),
    (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
    1, 5,
    (SELECT player FROM players WHERE nick='Tom'),

+   1,

    (SELECT song FROM songs WHERE lower(title)=lower('Living in America')),
    'f',
    7260);
    (SELECT song FROM songs WHERE lower(title)=lower('Living in America')),
    'f',
    7260);

-INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (

    (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
    1, 5,
    (SELECT player FROM players WHERE nick='Tom'),
    (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
    1, 5,
    (SELECT player FROM players WHERE nick='Tom'),

+   2,

    (SELECT song FROM songs WHERE lower(title)=lower('Jam Jam Reggae (AM Swing Mix)')),
    't',
    7512);
    (SELECT song FROM songs WHERE lower(title)=lower('Jam Jam Reggae (AM Swing Mix)')),
    't',
    7512);


@@ -816,24 +891,27 @@ INSERT INTO roundparticipation (tournament, round, parallel, player, position) V
    (SELECT player FROM players WHERE nick='Snofox'),
    5
 );
    (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 4'),
    1, 5,
    (SELECT player FROM players WHERE nick='Snofox'),
    (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
    1, 5,
    (SELECT player FROM players WHERE nick='Snofox'),

+   0,

    (SELECT song FROM songs WHERE lower(title)=lower('Make A Jam!')),
    'f',
    6529);
    (SELECT song FROM songs WHERE lower(title)=lower('Make A Jam!')),
    'f',
    6529);

-INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (

    (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
    1, 5,
    (SELECT player FROM players WHERE nick='Snofox'),
    (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
    1, 5,
    (SELECT player FROM players WHERE nick='Snofox'),

+   1,

    (SELECT song FROM songs WHERE lower(title)=lower('Living in America')),
    'f',
    6174);
    (SELECT song FROM songs WHERE lower(title)=lower('Living in America')),
    'f',
    6174);

-INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (

    (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
    1, 5,
    (SELECT player FROM players WHERE nick='Snofox'),
    (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
    1, 5,
    (SELECT player FROM players WHERE nick='Snofox'),

+   2,

    (SELECT song FROM songs WHERE lower(title)=lower('Dead End')),
    't',
    8424);
    (SELECT song FROM songs WHERE lower(title)=lower('Dead End')),
    't',
    8424);


@@ -844,24 +922,27 @@ INSERT INTO roundparticipation (tournament, round, parallel, player, position) V
    (SELECT player FROM players WHERE nick='T|na'),
    6
 );
    (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 4'),
    1, 5,
    (SELECT player FROM players WHERE nick='T|na'),
    (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
    1, 5,
    (SELECT player FROM players WHERE nick='T|na'),

+   0,

    (SELECT song FROM songs WHERE lower(title)=lower('Make A Jam!')),
    'f',
    6633);
    (SELECT song FROM songs WHERE lower(title)=lower('Make A Jam!')),
    'f',
    6633);

-INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (

    (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
    1, 5,
    (SELECT player FROM players WHERE nick='T|na'),
    (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
    1, 5,
    (SELECT player FROM players WHERE nick='T|na'),

+   1,

    (SELECT song FROM songs WHERE lower(title)=lower('Living in America')),
    'f',
    5652);
    (SELECT song FROM songs WHERE lower(title)=lower('Living in America')),
    'f',
    5652);

-INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (

    (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
    1, 5,
    (SELECT player FROM players WHERE nick='T|na'),
    (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
    1, 5,
    (SELECT player FROM players WHERE nick='T|na'),

+   2,

    (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
    't',
    8612);
    (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
    't',
    8612);


@@ -891,24 +972,27 @@ INSERT INTO roundparticipation (tournament, round, parallel, player, position) V
    (SELECT player FROM players WHERE nick='Ozon'),
    1
 );
    (SELECT player FROM players WHERE nick='Ozon'),
    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 4'),
    1, 6,
    (SELECT player FROM players WHERE nick='Ozon'),
    (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
    1, 6,
    (SELECT player FROM players WHERE nick='Ozon'),

+   0,

    (SELECT song FROM songs WHERE lower(title)=lower('The Centre of the Heart (Stonebridge Club Mix)')),
    'f',
    5641);
    (SELECT song FROM songs WHERE lower(title)=lower('The Centre of the Heart (Stonebridge Club Mix)')),
    'f',
    5641);

-INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (

    (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
    1, 6,
    (SELECT player FROM players WHERE nick='Ozon'),
    (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
    1, 6,
    (SELECT player FROM players WHERE nick='Ozon'),

+   1,

    (SELECT song FROM songs WHERE lower(title)=lower('I Want You To Want Me')),
    'f',
    5089);
    (SELECT song FROM songs WHERE lower(title)=lower('I Want You To Want Me')),
    'f',
    5089);

-INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (

    (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
    1, 6,
    (SELECT player FROM players WHERE nick='Ozon'),
    (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
    1, 6,
    (SELECT player FROM players WHERE nick='Ozon'),

+   2,

    (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
    't',
    8048);
    (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
    't',
    8048);


@@ -919,24 +1003,27 @@ INSERT INTO roundparticipation (tournament, round, parallel, player, position) V
    (SELECT player FROM players WHERE nick='Hyper'),
    2
 );
    (SELECT player FROM players WHERE nick='Hyper'),
    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 4'),
    1, 6,
    (SELECT player FROM players WHERE nick='Hyper'),
    (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
    1, 6,
    (SELECT player FROM players WHERE nick='Hyper'),

+   0,

    (SELECT song FROM songs WHERE lower(title)=lower('The Centre of the Heart (Stonebridge Club Mix)')),
    'f',
    4410);
    (SELECT song FROM songs WHERE lower(title)=lower('The Centre of the Heart (Stonebridge Club Mix)')),
    'f',
    4410);

-INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (

    (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
    1, 6,
    (SELECT player FROM players WHERE nick='Hyper'),
    (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
    1, 6,
    (SELECT player FROM players WHERE nick='Hyper'),

+   1,

    (SELECT song FROM songs WHERE lower(title)=lower('I Want You To Want Me')),
    'f',
    2831);
    (SELECT song FROM songs WHERE lower(title)=lower('I Want You To Want Me')),
    'f',
    2831);

-INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (

    (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
    1, 6,
    (SELECT player FROM players WHERE nick='Hyper'),
    (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
    1, 6,
    (SELECT player FROM players WHERE nick='Hyper'),

+   2,

    (SELECT song FROM songs WHERE lower(title)=lower('Jam Jam Reggae (AM Swing Mix)')),
    't',
    7408);
    (SELECT song FROM songs WHERE lower(title)=lower('Jam Jam Reggae (AM Swing Mix)')),
    't',
    7408);


@@ -947,24 +1034,27 @@ INSERT INTO roundparticipation (tournament, round, parallel, player, position) V
    (SELECT player FROM players WHERE nick='Nameless'),
    3
 );
    (SELECT player FROM players WHERE nick='Nameless'),
    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 4'),
    1, 6,
    (SELECT player FROM players WHERE nick='Nameless'),
    (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
    1, 6,
    (SELECT player FROM players WHERE nick='Nameless'),

+   0,

    (SELECT song FROM songs WHERE lower(title)=lower('The Centre of the Heart (Stonebridge Club Mix)')),
    'f',
    6327);
    (SELECT song FROM songs WHERE lower(title)=lower('The Centre of the Heart (Stonebridge Club Mix)')),
    'f',
    6327);

-INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (

    (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
    1, 6,
    (SELECT player FROM players WHERE nick='Nameless'),
    (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
    1, 6,
    (SELECT player FROM players WHERE nick='Nameless'),

+   1,

    (SELECT song FROM songs WHERE lower(title)=lower('I Want You To Want Me')),
    'f',
    5632);
    (SELECT song FROM songs WHERE lower(title)=lower('I Want You To Want Me')),
    'f',
    5632);

-INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (

    (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
    1, 6,
    (SELECT player FROM players WHERE nick='Nameless'),
    (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
    1, 6,
    (SELECT player FROM players WHERE nick='Nameless'),

+   2,

    (SELECT song FROM songs WHERE lower(title)=lower('Healing Vision (Angelic Mix)')),
    't',
    8276);
    (SELECT song FROM songs WHERE lower(title)=lower('Healing Vision (Angelic Mix)')),
    't',
    8276);


@@ -975,24 +1065,27 @@ INSERT INTO roundparticipation (tournament, round, parallel, player, position) V
    (SELECT player FROM players WHERE nick='Daniil'),
    4
 );
    (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 4'),
    1, 6,
    (SELECT player FROM players WHERE nick='Daniil'),
    (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
    1, 6,
    (SELECT player FROM players WHERE nick='Daniil'),

+   0,

    (SELECT song FROM songs WHERE lower(title)=lower('The Centre of the Heart (Stonebridge Club Mix)')),
    'f',
    6294);
    (SELECT song FROM songs WHERE lower(title)=lower('The Centre of the Heart (Stonebridge Club Mix)')),
    'f',
    6294);

-INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (

    (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
    1, 6,
    (SELECT player FROM players WHERE nick='Daniil'),
    (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
    1, 6,
    (SELECT player FROM players WHERE nick='Daniil'),

+   1,

    (SELECT song FROM songs WHERE lower(title)=lower('I Want You To Want Me')),
    'f',
    5286);
    (SELECT song FROM songs WHERE lower(title)=lower('I Want You To Want Me')),
    'f',
    5286);

-INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (

    (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
    1, 6,
    (SELECT player FROM players WHERE nick='Daniil'),
    (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
    1, 6,
    (SELECT player FROM players WHERE nick='Daniil'),

+   2,

    (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love (SPEED MIX)')),
    't',
    8341);
    (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love (SPEED MIX)')),
    't',
    8341);


@@ -1003,24 +1096,27 @@ INSERT INTO roundparticipation (tournament, round, parallel, player, position) V
    (SELECT player FROM players WHERE nick='Oliyzia'),
    5
 );
    (SELECT player FROM players WHERE nick='Oliyzia'),
    5
 );

-INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (

    (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
    1, 6,
    (SELECT player FROM players WHERE nick='Oliyzia'),
    (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
    1, 6,
    (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',
    6371);
    (SELECT song FROM songs WHERE lower(title)=lower('The Centre of the Heart (Stonebridge Club Mix)')),
    'f',
    6371);

-INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (

    (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
    1, 6,
    (SELECT player FROM players WHERE nick='Oliyzia'),
    (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
    1, 6,
    (SELECT player FROM players WHERE nick='Oliyzia'),

+   1,

    (SELECT song FROM songs WHERE lower(title)=lower('I Want You To Want Me')),
    'f',
    5369);
    (SELECT song FROM songs WHERE lower(title)=lower('I Want You To Want Me')),
    'f',
    5369);

-INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (

    (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
    1, 6,
    (SELECT player FROM players WHERE nick='Oliyzia'),
    (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
    1, 6,
    (SELECT player FROM players WHERE nick='Oliyzia'),

+   2,

    (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love (SPEED MIX)')),
    't',
    8253);
    (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love (SPEED MIX)')),
    't',
    8253);


@@ -1031,24 +1127,27 @@ INSERT INTO roundparticipation (tournament, round, parallel, player, position) V
    (SELECT player FROM players WHERE nick='Stream'),
    6
 );
    (SELECT player FROM players WHERE nick='Stream'),
    6
 );

-INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (

    (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
    1, 6,
    (SELECT player FROM players WHERE nick='Stream'),
    (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
    1, 6,
    (SELECT player FROM players WHERE nick='Stream'),

+   0,

    (SELECT song FROM songs WHERE lower(title)=lower('The Centre of the Heart (Stonebridge Club Mix)')),
    'f',
    6135);
    (SELECT song FROM songs WHERE lower(title)=lower('The Centre of the Heart (Stonebridge Club Mix)')),
    'f',
    6135);

-INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (

    (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
    1, 6,
    (SELECT player FROM players WHERE nick='Stream'),
    (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
    1, 6,
    (SELECT player FROM players WHERE nick='Stream'),

+   1,

    (SELECT song FROM songs WHERE lower(title)=lower('I Want You To Want Me')),
    'f',
    5013);
    (SELECT song FROM songs WHERE lower(title)=lower('I Want You To Want Me')),
    'f',
    5013);

-INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (

    (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
    1, 6,
    (SELECT player FROM players WHERE nick='Stream'),
    (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
    1, 6,
    (SELECT player FROM players WHERE nick='Stream'),

+   2,

    (SELECT song FROM songs WHERE lower(title)=lower('So Deep (Perfect Sphere Mix)')),
    't',
    7102);
    (SELECT song FROM songs WHERE lower(title)=lower('So Deep (Perfect Sphere Mix)')),
    't',
    7102);


@@ -1083,24 +1182,27 @@ INSERT INTO roundparticipation (tournament, round, parallel, player, position) V
    (SELECT player FROM players WHERE nick='Olemann'),
    1
 );
    (SELECT player FROM players WHERE nick='Olemann'),
    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 4'),
    2, 1,
    (SELECT player FROM players WHERE nick='Olemann'),
    (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
    2, 1,
    (SELECT player FROM players WHERE nick='Olemann'),

+   0,

    (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love')),
    'f',
    6635);
    (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love')),
    'f',
    6635);

-INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (

    (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
    2, 1,
    (SELECT player FROM players WHERE nick='Olemann'),
    (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
    2, 1,
    (SELECT player FROM players WHERE nick='Olemann'),

+   1,

    (SELECT song FROM songs WHERE lower(title)=lower('20th November')),
    'f',
    5971);
    (SELECT song FROM songs WHERE lower(title)=lower('20th November')),
    'f',
    5971);

-INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (

    (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
    2, 1,
    (SELECT player FROM players WHERE nick='Olemann'),
    (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
    2, 1,
    (SELECT player FROM players WHERE nick='Olemann'),

+   2,

    (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love (SPEED MIX)')),
    't',
    8042);
    (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love (SPEED MIX)')),
    't',
    8042);


@@ -1111,24 +1213,27 @@ INSERT INTO roundparticipation (tournament, round, parallel, player, position) V
    (SELECT player FROM players WHERE nick='T|na'),
    2
 );
    (SELECT player FROM players WHERE nick='T|na'),
    2
 );

-INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (

    (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
    2, 1,
    (SELECT player FROM players WHERE nick='T|na'),
    (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
    2, 1,
    (SELECT player FROM players WHERE nick='T|na'),

+   0,

    (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love')),
    'f',
    7402);
    (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love')),
    'f',
    7402);

-INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (

    (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
    2, 1,
    (SELECT player FROM players WHERE nick='T|na'),
    (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
    2, 1,
    (SELECT player FROM players WHERE nick='T|na'),

+   1,

    (SELECT song FROM songs WHERE lower(title)=lower('20th November')),
    'f',
    6375);
    (SELECT song FROM songs WHERE lower(title)=lower('20th November')),
    'f',
    6375);

-INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (

    (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
    2, 1,
    (SELECT player FROM players WHERE nick='T|na'),
    (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
    2, 1,
    (SELECT player FROM players WHERE nick='T|na'),

+   2,

    (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love (SPEED MIX)')),
    't',
    8274);
    (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love (SPEED MIX)')),
    't',
    8274);


@@ -1139,24 +1244,27 @@ INSERT INTO roundparticipation (tournament, round, parallel, player, position) V
    (SELECT player FROM players WHERE nick='Oliyzia'),
    3
 );
    (SELECT player FROM players WHERE nick='Oliyzia'),
    3
 );

-INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (

    (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
    2, 1,
    (SELECT player FROM players WHERE nick='Oliyzia'),
    (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
    2, 1,
    (SELECT player FROM players WHERE nick='Oliyzia'),

+   0,

    (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love')),
    'f',
    7331);
    (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love')),
    'f',
    7331);

-INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (

    (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
    2, 1,
    (SELECT player FROM players WHERE nick='Oliyzia'),
    (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
    2, 1,
    (SELECT player FROM players WHERE nick='Oliyzia'),

+   1,

    (SELECT song FROM songs WHERE lower(title)=lower('20th November')),
    'f',
    6382);
    (SELECT song FROM songs WHERE lower(title)=lower('20th November')),
    'f',
    6382);

-INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (

    (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
    2, 1,
    (SELECT player FROM players WHERE nick='Oliyzia'),
    (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
    2, 1,
    (SELECT player FROM players WHERE nick='Oliyzia'),

+   2,

    (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
    't',
    8693);
    (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
    't',
    8693);


@@ -1167,24 +1275,27 @@ INSERT INTO roundparticipation (tournament, round, parallel, player, position) V
    (SELECT player FROM players WHERE nick='Snofox'),
    4
 );
    (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 4'),
    2, 1,
    (SELECT player FROM players WHERE nick='Snofox'),
    (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
    2, 1,
    (SELECT player FROM players WHERE nick='Snofox'),

+   0,

    (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love')),
    'f',
    7448);
    (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love')),
    'f',
    7448);

-INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (

    (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
    2, 1,
    (SELECT player FROM players WHERE nick='Snofox'),
    (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
    2, 1,
    (SELECT player FROM players WHERE nick='Snofox'),

+   1,

    (SELECT song FROM songs WHERE lower(title)=lower('20th November')),
    'f',
    6233);
    (SELECT song FROM songs WHERE lower(title)=lower('20th November')),
    'f',
    6233);

-INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (

    (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
    2, 1,
    (SELECT player FROM players WHERE nick='Snofox'),
    (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
    2, 1,
    (SELECT player FROM players WHERE nick='Snofox'),

+   2,

    (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)')),
    't',
    8801);
    (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)')),
    't',
    8801);


@@ -1195,24 +1306,27 @@ INSERT INTO roundparticipation (tournament, round, parallel, player, position) V
    (SELECT player FROM players WHERE nick='Tom'),
    5
 );
    (SELECT player FROM players WHERE nick='Tom'),
    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 4'),
    2, 1,
    (SELECT player FROM players WHERE nick='Tom'),
    (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
    2, 1,
    (SELECT player FROM players WHERE nick='Tom'),

+   0,

    (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love')),
    'f',
    7500);
    (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love')),
    '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 4'),
    2, 1,
    (SELECT player FROM players WHERE nick='Tom'),
    (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
    2, 1,
    (SELECT player FROM players WHERE nick='Tom'),

+   1,

    (SELECT song FROM songs WHERE lower(title)=lower('20th November')),
    'f',
    6317);
    (SELECT song FROM songs WHERE lower(title)=lower('20th November')),
    'f',
    6317);

-INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (

    (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
    2, 1,
    (SELECT player FROM players WHERE nick='Tom'),
    (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
    2, 1,
    (SELECT player FROM players WHERE nick='Tom'),

+   2,

    (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love (SPEED MIX)')),
    't',
    8646);
    (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love (SPEED MIX)')),
    't',
    8646);


@@ -1223,24 +1337,27 @@ INSERT INTO roundparticipation (tournament, round, parallel, player, position) V
    (SELECT player FROM players WHERE nick='Snute'),
    6
 );
    (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 4'),
    2, 1,
    (SELECT player FROM players WHERE nick='Snute'),
    (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
    2, 1,
    (SELECT player FROM players WHERE nick='Snute'),

+   0,

    (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love')),
    'f',
    7792);
    (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love')),
    'f',
    7792);

-INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (

    (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
    2, 1,
    (SELECT player FROM players WHERE nick='Snute'),
    (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
    2, 1,
    (SELECT player FROM players WHERE nick='Snute'),

+   1,

    (SELECT song FROM songs WHERE lower(title)=lower('20th November')),
    'f',
    6639);
    (SELECT song FROM songs WHERE lower(title)=lower('20th November')),
    'f',
    6639);

-INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (

    (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
    2, 1,
    (SELECT player FROM players WHERE nick='Snute'),
    (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
    2, 1,
    (SELECT player FROM players WHERE nick='Snute'),

+   2,

    (SELECT song FROM songs WHERE lower(title)=lower('Dynamite Rave')),
    't',
    8630);
    (SELECT song FROM songs WHERE lower(title)=lower('Dynamite Rave')),
    't',
    8630);


@@ -1270,24 +1387,27 @@ INSERT INTO roundparticipation (tournament, round, parallel, player, position) V
    (SELECT player FROM players WHERE nick='Duckling'),
    1
 );
    (SELECT player FROM players WHERE nick='Duckling'),
    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 4'),
    2, 2,
    (SELECT player FROM players WHERE nick='Duckling'),
    (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
    2, 2,
    (SELECT player FROM players WHERE nick='Duckling'),

+   0,

    (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)')),
    'f',
    7990);
    (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)')),
    'f',
    7990);

-INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (

    (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
    2, 2,
    (SELECT player FROM players WHERE nick='Duckling'),
    (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
    2, 2,
    (SELECT player FROM players WHERE nick='Duckling'),

+   1,

    (SELECT song FROM songs WHERE lower(title)=lower('www.blonde girl (MOMO Mix)')),
    'f',
    6324);
    (SELECT song FROM songs WHERE lower(title)=lower('www.blonde girl (MOMO Mix)')),
    'f',
    6324);

-INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (

    (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
    2, 2,
    (SELECT player FROM players WHERE nick='Duckling'),
    (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
    2, 2,
    (SELECT player FROM players WHERE nick='Duckling'),

+   2,

    (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
    't',
    8347);
    (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
    't',
    8347);


@@ -1298,24 +1418,27 @@ INSERT INTO roundparticipation (tournament, round, parallel, player, position) V
    (SELECT player FROM players WHERE nick='Daniil'),
    2
 );
    (SELECT player FROM players WHERE nick='Daniil'),
    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 4'),
    2, 2,
    (SELECT player FROM players WHERE nick='Daniil'),
    (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
    2, 2,
    (SELECT player FROM players WHERE nick='Daniil'),

+   0,

    (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)')),
    'f',
    7982);
    (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)')),
    'f',
    7982);

-INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (

    (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
    2, 2,
    (SELECT player FROM players WHERE nick='Daniil'),
    (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
    2, 2,
    (SELECT player FROM players WHERE nick='Daniil'),

+   1,

    (SELECT song FROM songs WHERE lower(title)=lower('www.blonde girl (MOMO Mix)')),
    'f',
    6286);
    (SELECT song FROM songs WHERE lower(title)=lower('www.blonde girl (MOMO Mix)')),
    '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 4'),
    2, 2,
    (SELECT player FROM players WHERE nick='Daniil'),
    (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
    2, 2,
    (SELECT player FROM players WHERE nick='Daniil'),

+   2,

    (SELECT song FROM songs WHERE lower(title)=lower('Crash!')),
    't',
    8179);
    (SELECT song FROM songs WHERE lower(title)=lower('Crash!')),
    't',
    8179);


@@ -1326,24 +1449,27 @@ INSERT INTO roundparticipation (tournament, round, parallel, player, position) V
    (SELECT player FROM players WHERE nick='Mulefisk'),
    3
 );
    (SELECT player FROM players WHERE nick='Mulefisk'),
    3
 );

-INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (

    (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
    2, 2,
    (SELECT player FROM players WHERE nick='Mulefisk'),
    (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
    2, 2,
    (SELECT player FROM players WHERE nick='Mulefisk'),

+   0,

    (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)')),
    'f',
    8108);
    (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)')),
    'f',
    8108);

-INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (

    (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
    2, 2,
    (SELECT player FROM players WHERE nick='Mulefisk'),
    (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
    2, 2,
    (SELECT player FROM players WHERE nick='Mulefisk'),

+   1,

    (SELECT song FROM songs WHERE lower(title)=lower('www.blonde girl (MOMO Mix)')),
    'f',
    6173);
    (SELECT song FROM songs WHERE lower(title)=lower('www.blonde girl (MOMO Mix)')),
    'f',
    6173);

-INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (

    (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
    2, 2,
    (SELECT player FROM players WHERE nick='Mulefisk'),
    (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
    2, 2,
    (SELECT player FROM players WHERE nick='Mulefisk'),

+   2,

    (SELECT song FROM songs WHERE lower(title)=lower('Exotic Ethnic')),
    't',
    8113);
    (SELECT song FROM songs WHERE lower(title)=lower('Exotic Ethnic')),
    't',
    8113);


@@ -1354,24 +1480,27 @@ INSERT INTO roundparticipation (tournament, round, parallel, player, position) V
    (SELECT player FROM players WHERE nick='Haggar'),
    4
 );
    (SELECT player FROM players WHERE nick='Haggar'),
    4
 );

-INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (

    (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
    2, 2,
    (SELECT player FROM players WHERE nick='Haggar'),
    (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
    2, 2,
    (SELECT player FROM players WHERE nick='Haggar'),

+   0,

    (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)')),
    'f',
    8499);
    (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)')),
    'f',
    8499);

-INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (

    (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
    2, 2,
    (SELECT player FROM players WHERE nick='Haggar'),
    (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
    2, 2,
    (SELECT player FROM players WHERE nick='Haggar'),

+   1,

    (SELECT song FROM songs WHERE lower(title)=lower('www.blonde girl (MOMO Mix)')),
    'f',
    6638);
    (SELECT song FROM songs WHERE lower(title)=lower('www.blonde girl (MOMO Mix)')),
    'f',
    6638);

-INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (

    (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
    2, 2,
    (SELECT player FROM players WHERE nick='Haggar'),
    (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
    2, 2,
    (SELECT player FROM players WHERE nick='Haggar'),

+   2,

    (SELECT song FROM songs WHERE lower(title)=lower('Trip Machine Climax')),
    't',
    8381);
    (SELECT song FROM songs WHERE lower(title)=lower('Trip Machine Climax')),
    't',
    8381);


@@ -1382,24 +1511,27 @@ INSERT INTO roundparticipation (tournament, round, parallel, player, position) V
    (SELECT player FROM players WHERE nick='Nameless'),
    5
 );
    (SELECT player FROM players WHERE nick='Nameless'),
    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 4'),
    2, 2,
    (SELECT player FROM players WHERE nick='Nameless'),
    (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
    2, 2,
    (SELECT player FROM players WHERE nick='Nameless'),

+   0,

    (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)')),
    'f',
    8517);
    (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS 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 4'),
    2, 2,
    (SELECT player FROM players WHERE nick='Nameless'),
    (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
    2, 2,
    (SELECT player FROM players WHERE nick='Nameless'),

+   1,

    (SELECT song FROM songs WHERE lower(title)=lower('www.blonde girl (MOMO Mix)')),
    'f',
    6692);
    (SELECT song FROM songs WHERE lower(title)=lower('www.blonde girl (MOMO Mix)')),
    'f',
    6692);

-INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (

    (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
    2, 2,
    (SELECT player FROM players WHERE nick='Nameless'),
    (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
    2, 2,
    (SELECT player FROM players WHERE nick='Nameless'),

+   2,

    (SELECT song FROM songs WHERE lower(title)=lower('Dead End')),
    't',
    8208);
    (SELECT song FROM songs WHERE lower(title)=lower('Dead End')),
    't',
    8208);


@@ -1410,24 +1542,27 @@ INSERT INTO roundparticipation (tournament, round, parallel, player, position) V
    (SELECT player FROM players WHERE nick='OJK'),
    6
 );
    (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 4'),
    2, 2,
    (SELECT player FROM players WHERE nick='OJK'),
    (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
    2, 2,
    (SELECT player FROM players WHERE nick='OJK'),

+   0,

    (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)')),
    'f',
    8348);
    (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)')),
    'f',
    8348);

-INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (

    (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
    2, 2,
    (SELECT player FROM players WHERE nick='OJK'),
    (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
    2, 2,
    (SELECT player FROM players WHERE nick='OJK'),

+   1,

    (SELECT song FROM songs WHERE lower(title)=lower('www.blonde girl (MOMO Mix)')),
    'f',
    6600);
    (SELECT song FROM songs WHERE lower(title)=lower('www.blonde girl (MOMO Mix)')),
    'f',
    6600);

-INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (

    (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
    2, 2,
    (SELECT player FROM players WHERE nick='OJK'),
    (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
    2, 2,
    (SELECT player FROM players WHERE nick='OJK'),

+   2,

    (SELECT song FROM songs WHERE lower(title)=lower('So Deep (Perfect Sphere Mix)')),
    't',
    8253);
    (SELECT song FROM songs WHERE lower(title)=lower('So Deep (Perfect Sphere Mix)')),
    't',
    8253);


@@ -1457,24 +1592,27 @@ INSERT INTO roundparticipation (tournament, round, parallel, player, position) V
    (SELECT player FROM players WHERE nick='Tassen'),
    1
 );
    (SELECT player FROM players WHERE nick='Tassen'),
    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 4'),
    2, 3,
    (SELECT player FROM players WHERE nick='Tassen'),
    (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
    2, 3,
    (SELECT player FROM players WHERE nick='Tassen'),

+   0,

    (SELECT song FROM songs WHERE lower(title)=lower('Crash!')),
    'f',
    0);
    (SELECT song FROM songs WHERE lower(title)=lower('Crash!')),
    'f',
    0);

-INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (

    (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
    2, 3,
    (SELECT player FROM players WHERE nick='Tassen'),
    (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
    2, 3,
    (SELECT player FROM players WHERE nick='Tassen'),

+   1,

    (SELECT song FROM songs WHERE lower(title)=lower('Tsugaru')),
    'f',
    0);
    (SELECT song FROM songs WHERE lower(title)=lower('Tsugaru')),
    'f',
    0);

-INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (

    (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
    2, 3,
    (SELECT player FROM players WHERE nick='Tassen'),
    (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
    2, 3,
    (SELECT player FROM players WHERE nick='Tassen'),

+   2,

    (SELECT song FROM songs WHERE lower(title)=lower('Aaron\'s Party (Come Get It)')),
    't',
    0);
    (SELECT song FROM songs WHERE lower(title)=lower('Aaron\'s Party (Come Get It)')),
    't',
    0);


@@ -1485,24 +1623,27 @@ INSERT INTO roundparticipation (tournament, round, parallel, player, position) V
    (SELECT player FROM players WHERE nick='Ylini'),
    2
 );
    (SELECT player FROM players WHERE nick='Ylini'),
    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 4'),
    2, 3,
    (SELECT player FROM players WHERE nick='Ylini'),
    (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
    2, 3,
    (SELECT player FROM players WHERE nick='Ylini'),

+   0,

    (SELECT song FROM songs WHERE lower(title)=lower('Crash!')),
    'f',
    7704);
    (SELECT song FROM songs WHERE lower(title)=lower('Crash!')),
    'f',
    7704);

-INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (

    (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
    2, 3,
    (SELECT player FROM players WHERE nick='Ylini'),
    (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
    2, 3,
    (SELECT player FROM players WHERE nick='Ylini'),

+   1,

    (SELECT song FROM songs WHERE lower(title)=lower('Tsugaru')),
    'f',
    8111);
    (SELECT song FROM songs WHERE lower(title)=lower('Tsugaru')),
    'f',
    8111);

-INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (

    (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
    2, 3,
    (SELECT player FROM players WHERE nick='Ylini'),
    (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
    2, 3,
    (SELECT player FROM players WHERE nick='Ylini'),

+   2,

    (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
    't',
    8154);
    (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
    't',
    8154);


@@ -1513,24 +1654,27 @@ INSERT INTO roundparticipation (tournament, round, parallel, player, position) V
    (SELECT player FROM players WHERE nick='Pingo'),
    3
 );
    (SELECT player FROM players WHERE nick='Pingo'),
    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 4'),
    2, 3,
    (SELECT player FROM players WHERE nick='Pingo'),
    (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
    2, 3,
    (SELECT player FROM players WHERE nick='Pingo'),

+   0,

    (SELECT song FROM songs WHERE lower(title)=lower('Crash!')),
    'f',
    8440);
    (SELECT song FROM songs WHERE lower(title)=lower('Crash!')),
    'f',
    8440);

-INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (

    (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
    2, 3,
    (SELECT player FROM players WHERE nick='Pingo'),
    (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
    2, 3,
    (SELECT player FROM players WHERE nick='Pingo'),

+   1,

    (SELECT song FROM songs WHERE lower(title)=lower('Tsugaru')),
    'f',
    8160);
    (SELECT song FROM songs WHERE lower(title)=lower('Tsugaru')),
    'f',
    8160);

-INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (

    (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
    2, 3,
    (SELECT player FROM players WHERE nick='Pingo'),
    (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
    2, 3,
    (SELECT player FROM players WHERE nick='Pingo'),

+   2,

    (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
    't',
    8450);
    (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
    't',
    8450);


@@ -1541,24 +1685,27 @@ INSERT INTO roundparticipation (tournament, round, parallel, player, position) V
    (SELECT player FROM players WHERE nick='Gogo'),
    4
 );
    (SELECT player FROM players WHERE nick='Gogo'),
    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 4'),
    2, 3,
    (SELECT player FROM players WHERE nick='Gogo'),
    (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
    2, 3,
    (SELECT player FROM players WHERE nick='Gogo'),

+   0,

    (SELECT song FROM songs WHERE lower(title)=lower('Crash!')),
    'f',
    7830);
    (SELECT song FROM songs WHERE lower(title)=lower('Crash!')),
    'f',
    7830);

-INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (

    (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
    2, 3,
    (SELECT player FROM players WHERE nick='Gogo'),
    (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
    2, 3,
    (SELECT player FROM players WHERE nick='Gogo'),

+   1,

    (SELECT song FROM songs WHERE lower(title)=lower('Tsugaru')),
    'f',
    8385);
    (SELECT song FROM songs WHERE lower(title)=lower('Tsugaru')),
    'f',
    8385);

-INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (

    (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
    2, 3,
    (SELECT player FROM players WHERE nick='Gogo'),
    (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
    2, 3,
    (SELECT player FROM players WHERE nick='Gogo'),

+   2,

    (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)')),
    't',
    8602);
    (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)')),
    't',
    8602);


@@ -1569,24 +1716,27 @@ INSERT INTO roundparticipation (tournament, round, parallel, player, position) V
    (SELECT player FROM players WHERE nick='RiChY'),
    5
 );
    (SELECT player FROM players WHERE nick='RiChY'),
    5
 );

-INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (

    (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
    2, 3,
    (SELECT player FROM players WHERE nick='RiChY'),
    (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
    2, 3,
    (SELECT player FROM players WHERE nick='RiChY'),

+   0,

    (SELECT song FROM songs WHERE lower(title)=lower('Crash!')),
    'f',
    8488);
    (SELECT song FROM songs WHERE lower(title)=lower('Crash!')),
    'f',
    8488);

-INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (

    (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
    2, 3,
    (SELECT player FROM players WHERE nick='RiChY'),
    (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
    2, 3,
    (SELECT player FROM players WHERE nick='RiChY'),

+   1,

    (SELECT song FROM songs WHERE lower(title)=lower('Tsugaru')),
    'f',
    8481);
    (SELECT song FROM songs WHERE lower(title)=lower('Tsugaru')),
    'f',
    8481);

-INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (

    (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
    2, 3,
    (SELECT player FROM players WHERE nick='RiChY'),
    (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
    2, 3,
    (SELECT player FROM players WHERE nick='RiChY'),

+   2,

    (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
    't',
    8638);
    (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
    't',
    8638);


@@ -1597,24 +1747,27 @@ INSERT INTO roundparticipation (tournament, round, parallel, player, position) V
    (SELECT player FROM players WHERE nick='DufF'),
    6
 );
    (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 4'),
    2, 3,
    (SELECT player FROM players WHERE nick='DufF'),
    (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
    2, 3,
    (SELECT player FROM players WHERE nick='DufF'),

+   0,

    (SELECT song FROM songs WHERE lower(title)=lower('Crash!')),
    'f',
    8747);
    (SELECT song FROM songs WHERE lower(title)=lower('Crash!')),
    'f',
    8747);

-INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (

    (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
    2, 3,
    (SELECT player FROM players WHERE nick='DufF'),
    (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
    2, 3,
    (SELECT player FROM players WHERE nick='DufF'),

+   1,

    (SELECT song FROM songs WHERE lower(title)=lower('Tsugaru')),
    'f',
    8570);
    (SELECT song FROM songs WHERE lower(title)=lower('Tsugaru')),
    'f',
    8570);

-INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (

    (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
    2, 3,
    (SELECT player FROM players WHERE nick='DufF'),
    (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
    2, 3,
    (SELECT player FROM players WHERE nick='DufF'),

+   2,

    (SELECT song FROM songs WHERE lower(title)=lower('Healing Vision (Angelic Mix)')),
    't',
    8621);
    (SELECT song FROM songs WHERE lower(title)=lower('Healing Vision (Angelic Mix)')),
    't',
    8621);


@@ -1644,17 +1797,19 @@ INSERT INTO roundparticipation (tournament, round, parallel, player, position) V
    (SELECT player FROM players WHERE nick='OJK'),
    1
 );
    (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 4'),
    3, 0,
    (SELECT player FROM players WHERE nick='OJK'),
    (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
    3, 0,
    (SELECT player FROM players WHERE nick='OJK'),

+   0,

    (SELECT song FROM songs WHERE lower(title)=lower('Love This Feelin\'')),
    'f',
    7448);
    (SELECT song FROM songs WHERE lower(title)=lower('Love This Feelin\'')),
    'f',
    7448);

-INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (

    (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
    3, 0,
    (SELECT player FROM players WHERE nick='OJK'),
    (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
    3, 0,
    (SELECT player FROM players WHERE nick='OJK'),

+   1,

    (SELECT song FROM songs WHERE lower(title)=lower('Tsugaru')),
    't',
    8790);
    (SELECT song FROM songs WHERE lower(title)=lower('Tsugaru')),
    't',
    8790);


@@ -1665,17 +1820,19 @@ INSERT INTO roundparticipation (tournament, round, parallel, player, position) V
    (SELECT player FROM players WHERE nick='Pingo'),
    2
 );
    (SELECT player FROM players WHERE nick='Pingo'),
    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 4'),
    3, 0,
    (SELECT player FROM players WHERE nick='Pingo'),
    (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
    3, 0,
    (SELECT player FROM players WHERE nick='Pingo'),

+   0,

    (SELECT song FROM songs WHERE lower(title)=lower('Love This Feelin\'')),
    'f',
    6765);
    (SELECT song FROM songs WHERE lower(title)=lower('Love This Feelin\'')),
    'f',
    6765);

-INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (

    (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
    3, 0,
    (SELECT player FROM players WHERE nick='Pingo'),
    (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
    3, 0,
    (SELECT player FROM players WHERE nick='Pingo'),

+   1,

    (SELECT song FROM songs WHERE lower(title)=lower('So Deep (Perfect Sphere Mix)')),
    't',
    7998);
    (SELECT song FROM songs WHERE lower(title)=lower('So Deep (Perfect Sphere Mix)')),
    't',
    7998);


@@ -1686,17 +1843,19 @@ INSERT INTO roundparticipation (tournament, round, parallel, player, position) V
    (SELECT player FROM players WHERE nick='Tom'),
    3
 );
    (SELECT player FROM players WHERE nick='Tom'),
    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 4'),
    3, 0,
    (SELECT player FROM players WHERE nick='Tom'),
    (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
    3, 0,
    (SELECT player FROM players WHERE nick='Tom'),

+   0,

    (SELECT song FROM songs WHERE lower(title)=lower('Love This Feelin\'')),
    'f',
    6668);
    (SELECT song FROM songs WHERE lower(title)=lower('Love This Feelin\'')),
    'f',
    6668);

-INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (

    (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
    3, 0,
    (SELECT player FROM players WHERE nick='Tom'),
    (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
    3, 0,
    (SELECT player FROM players WHERE nick='Tom'),

+   1,

    (SELECT song FROM songs WHERE lower(title)=lower('Max 300')),
    't',
    8185);
    (SELECT song FROM songs WHERE lower(title)=lower('Max 300')),
    't',
    8185);


@@ -1707,17 +1866,19 @@ INSERT INTO roundparticipation (tournament, round, parallel, player, position) V
    (SELECT player FROM players WHERE nick='Nameless'),
    4
 );
    (SELECT player FROM players WHERE nick='Nameless'),
    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 4'),
    3, 0,
    (SELECT player FROM players WHERE nick='Nameless'),
    (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
    3, 0,
    (SELECT player FROM players WHERE nick='Nameless'),

+   0,

    (SELECT song FROM songs WHERE lower(title)=lower('Love This Feelin\'')),
    'f',
    6994);
    (SELECT song FROM songs WHERE lower(title)=lower('Love This Feelin\'')),
    'f',
    6994);

-INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (

    (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
    3, 0,
    (SELECT player FROM players WHERE nick='Nameless'),
    (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
    3, 0,
    (SELECT player FROM players WHERE nick='Nameless'),

+   1,

    (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
    't',
    8791);
    (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
    't',
    8791);


@@ -1728,17 +1889,19 @@ INSERT INTO roundparticipation (tournament, round, parallel, player, position) V
    (SELECT player FROM players WHERE nick='RiChY'),
    5
 );
    (SELECT player FROM players WHERE nick='RiChY'),
    5
 );

-INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (

    (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
    3, 0,
    (SELECT player FROM players WHERE nick='RiChY'),
    (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
    3, 0,
    (SELECT player FROM players WHERE nick='RiChY'),

+   0,

    (SELECT song FROM songs WHERE lower(title)=lower('Love This Feelin\'')),
    'f',
    7143);
    (SELECT song FROM songs WHERE lower(title)=lower('Love This Feelin\'')),
    'f',
    7143);

-INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (

    (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
    3, 0,
    (SELECT player FROM players WHERE nick='RiChY'),
    (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
    3, 0,
    (SELECT player FROM players WHERE nick='RiChY'),

+   1,

    (SELECT song FROM songs WHERE lower(title)=lower('Dead End')),
    't',
    8596);
    (SELECT song FROM songs WHERE lower(title)=lower('Dead End')),
    't',
    8596);


@@ -1749,17 +1912,19 @@ INSERT INTO roundparticipation (tournament, round, parallel, player, position) V
    (SELECT player FROM players WHERE nick='Snofox'),
    6
 );
    (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 4'),
    3, 0,
    (SELECT player FROM players WHERE nick='Snofox'),
    (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
    3, 0,
    (SELECT player FROM players WHERE nick='Snofox'),

+   0,

    (SELECT song FROM songs WHERE lower(title)=lower('Love This Feelin\'')),
    'f',
    7175);
    (SELECT song FROM songs WHERE lower(title)=lower('Love This Feelin\'')),
    'f',
    7175);

-INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (

    (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
    3, 0,
    (SELECT player FROM players WHERE nick='Snofox'),
    (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
    3, 0,
    (SELECT player FROM players WHERE nick='Snofox'),

+   1,

    (SELECT song FROM songs WHERE lower(title)=lower('Crash!')),
    't',
    8451);
    (SELECT song FROM songs WHERE lower(title)=lower('Crash!')),
    't',
    8451);


@@ -1770,17 +1935,19 @@ INSERT INTO roundparticipation (tournament, round, parallel, player, position) V
    (SELECT player FROM players WHERE nick='Haggar'),
    7
 );
    (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 4'),
    3, 0,
    (SELECT player FROM players WHERE nick='Haggar'),
    (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
    3, 0,
    (SELECT player FROM players WHERE nick='Haggar'),

+   0,

    (SELECT song FROM songs WHERE lower(title)=lower('Love This Feelin\'')),
    'f',
    6946);
    (SELECT song FROM songs WHERE lower(title)=lower('Love This Feelin\'')),
    'f',
    6946);

-INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (

    (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
    3, 0,
    (SELECT player FROM players WHERE nick='Haggar'),
    (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
    3, 0,
    (SELECT player FROM players WHERE nick='Haggar'),

+   1,

    (SELECT song FROM songs WHERE lower(title)=lower('PARANOiA Rebirth')),
    't',
    8654);
    (SELECT song FROM songs WHERE lower(title)=lower('PARANOiA Rebirth')),
    't',
    8654);


@@ -1791,17 +1958,19 @@ INSERT INTO roundparticipation (tournament, round, parallel, player, position) V
    (SELECT player FROM players WHERE nick='Snute'),
    8
 );
    (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 4'),
    3, 0,
    (SELECT player FROM players WHERE nick='Snute'),
    (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
    3, 0,
    (SELECT player FROM players WHERE nick='Snute'),

+   0,

    (SELECT song FROM songs WHERE lower(title)=lower('Love This Feelin\'')),
    'f',
    7356);
    (SELECT song FROM songs WHERE lower(title)=lower('Love This Feelin\'')),
    'f',
    7356);

-INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (

    (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
    3, 0,
    (SELECT player FROM players WHERE nick='Snute'),
    (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
    3, 0,
    (SELECT player FROM players WHERE nick='Snute'),

+   1,

    (SELECT song FROM songs WHERE lower(title)=lower('So Deep (Perfect Sphere Mix)')),
    't',
    8639);
    (SELECT song FROM songs WHERE lower(title)=lower('So Deep (Perfect Sphere Mix)')),
    't',
    8639);


@@ -1812,17 +1981,19 @@ INSERT INTO roundparticipation (tournament, round, parallel, player, position) V
    (SELECT player FROM players WHERE nick='DufF'),
    9
 );
    (SELECT player FROM players WHERE nick='DufF'),
    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 4'),
    3, 0,
    (SELECT player FROM players WHERE nick='DufF'),
    (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
    3, 0,
    (SELECT player FROM players WHERE nick='DufF'),

+   0,

    (SELECT song FROM songs WHERE lower(title)=lower('Love This Feelin\'')),
    'f',
    7433);
    (SELECT song FROM songs WHERE lower(title)=lower('Love This Feelin\'')),
    'f',
    7433);

-INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (

    (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
    3, 0,
    (SELECT player FROM players WHERE nick='DufF'),
    (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
    3, 0,
    (SELECT player FROM players WHERE nick='DufF'),

+   1,

    (SELECT song FROM songs WHERE lower(title)=lower('So Deep (Perfect Sphere Mix)')),
    't',
    8573);
    (SELECT song FROM songs WHERE lower(title)=lower('So Deep (Perfect Sphere Mix)')),
    't',
    8573);


@@ -1852,17 +2023,19 @@ INSERT INTO roundparticipation (tournament, round, parallel, player, position) V
    (SELECT player FROM players WHERE nick='Haggar'),
    1
 );
    (SELECT player FROM players WHERE nick='Haggar'),
    1
 );

-INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (

    (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
    4, 0,
    (SELECT player FROM players WHERE nick='Haggar'),
    (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
    4, 0,
    (SELECT player FROM players WHERE nick='Haggar'),

+   0,

    (SELECT song FROM songs WHERE lower(title)=lower('Cotton-Eye Joe')),
    'f',
    6555);
    (SELECT song FROM songs WHERE lower(title)=lower('Cotton-Eye Joe')),
    'f',
    6555);

-INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (

    (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
    4, 0,
    (SELECT player FROM players WHERE nick='Haggar'),
    (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
    4, 0,
    (SELECT player FROM players WHERE nick='Haggar'),

+   1,

    (SELECT song FROM songs WHERE lower(title)=lower('Exotic Ethnic')),
    't',
    8735);
    (SELECT song FROM songs WHERE lower(title)=lower('Exotic Ethnic')),
    't',
    8735);


@@ -1873,17 +2046,19 @@ INSERT INTO roundparticipation (tournament, round, parallel, player, position) V
    (SELECT player FROM players WHERE nick='Snofox'),
    2
 );
    (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 4'),
    4, 0,
    (SELECT player FROM players WHERE nick='Snofox'),
    (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
    4, 0,
    (SELECT player FROM players WHERE nick='Snofox'),

+   0,

    (SELECT song FROM songs WHERE lower(title)=lower('Cotton-Eye Joe')),
    'f',
    6004);
    (SELECT song FROM songs WHERE lower(title)=lower('Cotton-Eye Joe')),
    'f',
    6004);

-INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (

    (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
    4, 0,
    (SELECT player FROM players WHERE nick='Snofox'),
    (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
    4, 0,
    (SELECT player FROM players WHERE nick='Snofox'),

+   1,

    (SELECT song FROM songs WHERE lower(title)=lower('Max 300')),
    't',
    7993);
    (SELECT song FROM songs WHERE lower(title)=lower('Max 300')),
    't',
    7993);


@@ -1894,17 +2069,19 @@ INSERT INTO roundparticipation (tournament, round, parallel, player, position) V
    (SELECT player FROM players WHERE nick='RiChY'),
    3
 );
    (SELECT player FROM players WHERE nick='RiChY'),
    3
 );

-INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (

    (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
    4, 0,
    (SELECT player FROM players WHERE nick='RiChY'),
    (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
    4, 0,
    (SELECT player FROM players WHERE nick='RiChY'),

+   0,

    (SELECT song FROM songs WHERE lower(title)=lower('Cotton-Eye Joe')),
    'f',
    6451);
    (SELECT song FROM songs WHERE lower(title)=lower('Cotton-Eye Joe')),
    'f',
    6451);

-INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (

    (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
    4, 0,
    (SELECT player FROM players WHERE nick='RiChY'),
    (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
    4, 0,
    (SELECT player FROM players WHERE nick='RiChY'),

+   1,

    (SELECT song FROM songs WHERE lower(title)=lower('PARANOiA Rebirth')),
    't',
    8809);
    (SELECT song FROM songs WHERE lower(title)=lower('PARANOiA Rebirth')),
    't',
    8809);


@@ -1915,17 +2092,19 @@ INSERT INTO roundparticipation (tournament, round, parallel, player, position) V
    (SELECT player FROM players WHERE nick='Nameless'),
    4
 );
    (SELECT player FROM players WHERE nick='Nameless'),
    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 4'),
    4, 0,
    (SELECT player FROM players WHERE nick='Nameless'),
    (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
    4, 0,
    (SELECT player FROM players WHERE nick='Nameless'),

+   0,

    (SELECT song FROM songs WHERE lower(title)=lower('Cotton-Eye Joe')),
    'f',
    6422);
    (SELECT song FROM songs WHERE lower(title)=lower('Cotton-Eye Joe')),
    'f',
    6422);

-INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (

    (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
    4, 0,
    (SELECT player FROM players WHERE nick='Nameless'),
    (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
    4, 0,
    (SELECT player FROM players WHERE nick='Nameless'),

+   1,

    (SELECT song FROM songs WHERE lower(title)=lower('Exotic Ethnic')),
    't',
    8568);
    (SELECT song FROM songs WHERE lower(title)=lower('Exotic Ethnic')),
    't',
    8568);


@@ -1936,17 +2115,19 @@ INSERT INTO roundparticipation (tournament, round, parallel, player, position) V
    (SELECT player FROM players WHERE nick='Snute'),
    5
 );
    (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 4'),
    4, 0,
    (SELECT player FROM players WHERE nick='Snute'),
    (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
    4, 0,
    (SELECT player FROM players WHERE nick='Snute'),

+   0,

    (SELECT song FROM songs WHERE lower(title)=lower('Cotton-Eye Joe')),
    'f',
    6579);
    (SELECT song FROM songs WHERE lower(title)=lower('Cotton-Eye Joe')),
    '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 4'),
    4, 0,
    (SELECT player FROM players WHERE nick='Snute'),
    (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
    4, 0,
    (SELECT player FROM players WHERE nick='Snute'),

+   1,

    (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love (SPEED MIX)')),
    't',
    8769);
    (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love (SPEED MIX)')),
    't',
    8769);


@@ -1957,17 +2138,19 @@ INSERT INTO roundparticipation (tournament, round, parallel, player, position) V
    (SELECT player FROM players WHERE nick='DufF'),
    6
 );
    (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 4'),
    4, 0,
    (SELECT player FROM players WHERE nick='DufF'),
    (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
    4, 0,
    (SELECT player FROM players WHERE nick='DufF'),

+   0,

    (SELECT song FROM songs WHERE lower(title)=lower('Cotton-Eye Joe')),
    'f',
    6713);
    (SELECT song FROM songs WHERE lower(title)=lower('Cotton-Eye Joe')),
    'f',
    6713);

-INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (

    (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
    4, 0,
    (SELECT player FROM players WHERE nick='DufF'),
    (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
    4, 0,
    (SELECT player FROM players WHERE nick='DufF'),

+   1,

    (SELECT song FROM songs WHERE lower(title)=lower('PARANOiA Rebirth')),
    't',
    8737);
    (SELECT song FROM songs WHERE lower(title)=lower('PARANOiA Rebirth')),
    't',
    8737);


@@ -1978,17 +2161,19 @@ INSERT INTO roundparticipation (tournament, round, parallel, player, position) V
    (SELECT player FROM players WHERE nick='OJK'),
    7
 );
    (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 4'),
    4, 0,
    (SELECT player FROM players WHERE nick='OJK'),
    (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
    4, 0,
    (SELECT player FROM players WHERE nick='OJK'),

+   0,

    (SELECT song FROM songs WHERE lower(title)=lower('Cotton-Eye Joe')),
    'f',
    6544);
    (SELECT song FROM songs WHERE lower(title)=lower('Cotton-Eye Joe')),
    'f',
    6544);

-INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (

    (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
    4, 0,
    (SELECT player FROM players WHERE nick='OJK'),
    (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
    4, 0,
    (SELECT player FROM players WHERE nick='OJK'),

+   1,

    (SELECT song FROM songs WHERE lower(title)=lower('PARANOiA Rebirth')),
    't',
    8332);
    (SELECT song FROM songs WHERE lower(title)=lower('PARANOiA Rebirth')),
    't',
    8332);


@@ -2018,17 +2203,19 @@ INSERT INTO roundparticipation (tournament, round, parallel, player, position) V
    (SELECT player FROM players WHERE nick='Nameless'),
    1
 );
    (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 4'),
    5, 0,
    (SELECT player FROM players WHERE nick='Nameless'),
    (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
    5, 0,
    (SELECT player FROM players WHERE nick='Nameless'),

+   0,

    (SELECT song FROM songs WHERE lower(title)=lower('Afronova')),
    'f',
    7215);
    (SELECT song FROM songs WHERE lower(title)=lower('Afronova')),
    'f',
    7215);

-INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (

    (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
    5, 0,
    (SELECT player FROM players WHERE nick='Nameless'),
    (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
    5, 0,
    (SELECT player FROM players WHERE nick='Nameless'),

+   1,

    (SELECT song FROM songs WHERE lower(title)=lower('PARANOiA Rebirth')),
    't',
    8271);
    (SELECT song FROM songs WHERE lower(title)=lower('PARANOiA Rebirth')),
    't',
    8271);


@@ -2039,17 +2226,19 @@ INSERT INTO roundparticipation (tournament, round, parallel, player, position) V
    (SELECT player FROM players WHERE nick='RiChY'),
    2
 );
    (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 4'),
    5, 0,
    (SELECT player FROM players WHERE nick='RiChY'),
    (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
    5, 0,
    (SELECT player FROM players WHERE nick='RiChY'),

+   0,

    (SELECT song FROM songs WHERE lower(title)=lower('Afronova')),
    'f',
    8438);
    (SELECT song FROM songs WHERE lower(title)=lower('Afronova')),
    'f',
    8438);

-INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (

    (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
    5, 0,
    (SELECT player FROM players WHERE nick='RiChY'),
    (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
    5, 0,
    (SELECT player FROM players WHERE nick='RiChY'),

+   1,

    (SELECT song FROM songs WHERE lower(title)=lower('Dynamite Rave')),
    't',
    8314);
    (SELECT song FROM songs WHERE lower(title)=lower('Dynamite Rave')),
    't',
    8314);


@@ -2060,17 +2249,19 @@ INSERT INTO roundparticipation (tournament, round, parallel, player, position) V
    (SELECT player FROM players WHERE nick='Haggar'),
    3
 );
    (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 4'),
    5, 0,
    (SELECT player FROM players WHERE nick='Haggar'),
    (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
    5, 0,
    (SELECT player FROM players WHERE nick='Haggar'),

+   0,

    (SELECT song FROM songs WHERE lower(title)=lower('Afronova')),
    'f',
    8547);
    (SELECT song FROM songs WHERE lower(title)=lower('Afronova')),
    'f',
    8547);

-INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (

    (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
    5, 0,
    (SELECT player FROM players WHERE nick='Haggar'),
    (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
    5, 0,
    (SELECT player FROM players WHERE nick='Haggar'),

+   1,

    (SELECT song FROM songs WHERE lower(title)=lower('So Deep (Perfect Sphere Mix)')),
    't',
    8379);
    (SELECT song FROM songs WHERE lower(title)=lower('So Deep (Perfect Sphere Mix)')),
    't',
    8379);


@@ -2081,17 +2272,19 @@ INSERT INTO roundparticipation (tournament, round, parallel, player, position) V
    (SELECT player FROM players WHERE nick='Snute'),
    4
 );
    (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 4'),
    5, 0,
    (SELECT player FROM players WHERE nick='Snute'),
    (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
    5, 0,
    (SELECT player FROM players WHERE nick='Snute'),

+   0,

    (SELECT song FROM songs WHERE lower(title)=lower('Afronova')),
    'f',
    8695);
    (SELECT song FROM songs WHERE lower(title)=lower('Afronova')),
    'f',
    8695);

-INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (

    (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
    5, 0,
    (SELECT player FROM players WHERE nick='Snute'),
    (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
    5, 0,
    (SELECT player FROM players WHERE nick='Snute'),

+   1,

    (SELECT song FROM songs WHERE lower(title)=lower('PARANOiA Rebirth')),
    't',
    8812);
    (SELECT song FROM songs WHERE lower(title)=lower('PARANOiA Rebirth')),
    't',
    8812);


@@ -2102,17 +2295,19 @@ INSERT INTO roundparticipation (tournament, round, parallel, player, position) V
    (SELECT player FROM players WHERE nick='DufF'),
    5
 );
    (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 4'),
    5, 0,
    (SELECT player FROM players WHERE nick='DufF'),
    (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
    5, 0,
    (SELECT player FROM players WHERE nick='DufF'),

+   0,

    (SELECT song FROM songs WHERE lower(title)=lower('Afronova')),
    'f',
    8342);
    (SELECT song FROM songs WHERE lower(title)=lower('Afronova')),
    'f',
    8342);

-INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (

    (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
    5, 0,
    (SELECT player FROM players WHERE nick='DufF'),
    (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
    5, 0,
    (SELECT player FROM players WHERE nick='DufF'),

+   1,

    (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)')),
    't',
    8724);
    (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)')),
    't',
    8724);


@@ -2142,17 +2337,19 @@ INSERT INTO roundparticipation (tournament, round, parallel, player, position) V
    (SELECT player FROM players WHERE nick='RiChY'),
    1
 );
    (SELECT player FROM players WHERE nick='RiChY'),
    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 4'),
    6, 0,
    (SELECT player FROM players WHERE nick='RiChY'),
    (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
    6, 0,
    (SELECT player FROM players WHERE nick='RiChY'),

+   0,

    (SELECT song FROM songs WHERE lower(title)=lower('End of the Century')),
    'f',
    8120);
    (SELECT song FROM songs WHERE lower(title)=lower('End of the Century')),
    'f',
    8120);

-INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (

    (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
    6, 0,
    (SELECT player FROM players WHERE nick='RiChY'),
    (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
    6, 0,
    (SELECT player FROM players WHERE nick='RiChY'),

+   1,

    (SELECT song FROM songs WHERE lower(title)=lower('Crash!')),
    't',
    8701);
    (SELECT song FROM songs WHERE lower(title)=lower('Crash!')),
    't',
    8701);


@@ -2163,17 +2360,19 @@ INSERT INTO roundparticipation (tournament, round, parallel, player, position) V
    (SELECT player FROM players WHERE nick='Haggar'),
    2
 );
    (SELECT player FROM players WHERE nick='Haggar'),
    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 4'),
    6, 0,
    (SELECT player FROM players WHERE nick='Haggar'),
    (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
    6, 0,
    (SELECT player FROM players WHERE nick='Haggar'),

+   0,

    (SELECT song FROM songs WHERE lower(title)=lower('End of the Century')),
    'f',
    8234);
    (SELECT song FROM songs WHERE lower(title)=lower('End of the Century')),
    'f',
    8234);

-INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (

    (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
    6, 0,
    (SELECT player FROM players WHERE nick='Haggar'),
    (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
    6, 0,
    (SELECT player FROM players WHERE nick='Haggar'),

+   1,

    (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
    't',
    8563);
    (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
    't',
    8563);


@@ -2184,17 +2383,19 @@ INSERT INTO roundparticipation (tournament, round, parallel, player, position) V
    (SELECT player FROM players WHERE nick='DufF'),
    3
 );
    (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 4'),
    6, 0,
    (SELECT player FROM players WHERE nick='DufF'),
    (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
    6, 0,
    (SELECT player FROM players WHERE nick='DufF'),

+   0,

    (SELECT song FROM songs WHERE lower(title)=lower('End of the Century')),
    'f',
    8376);
    (SELECT song FROM songs WHERE lower(title)=lower('End of the Century')),
    'f',
    8376);

-INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (

    (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
    6, 0,
    (SELECT player FROM players WHERE nick='DufF'),
    (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
    6, 0,
    (SELECT player FROM players WHERE nick='DufF'),

+   1,

    (SELECT song FROM songs WHERE lower(title)=lower('Crash!')),
    't',
    8901);
    (SELECT song FROM songs WHERE lower(title)=lower('Crash!')),
    't',
    8901);


@@ -2205,17 +2406,19 @@ INSERT INTO roundparticipation (tournament, round, parallel, player, position) V
    (SELECT player FROM players WHERE nick='Snute'),
    4
 );
    (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 4'),
    6, 0,
    (SELECT player FROM players WHERE nick='Snute'),
    (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
    6, 0,
    (SELECT player FROM players WHERE nick='Snute'),

+   0,

    (SELECT song FROM songs WHERE lower(title)=lower('End of the Century')),
    'f',
    8784);
    (SELECT song FROM songs WHERE lower(title)=lower('End of the Century')),
    'f',
    8784);

-INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (

    (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
    6, 0,
    (SELECT player FROM players WHERE nick='Snute'),
    (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
    6, 0,
    (SELECT player FROM players WHERE nick='Snute'),

+   1,

    (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)')),
    't',
    8795);
    (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)')),
    't',
    8795);


@@ -2245,17 +2448,19 @@ INSERT INTO roundparticipation (tournament, round, parallel, player, position) V
    (SELECT player FROM players WHERE nick='RiChY'),
    1
 );
    (SELECT player FROM players WHERE nick='RiChY'),
    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 4'),
    7, 0,
    (SELECT player FROM players WHERE nick='RiChY'),
    (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
    7, 0,
    (SELECT player FROM players WHERE nick='RiChY'),

+   0,

    (SELECT song FROM songs WHERE lower(title)=lower('Living in America')),
    'f',
    6581);
    (SELECT song FROM songs WHERE lower(title)=lower('Living in America')),
    'f',
    6581);

-INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (

    (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
    7, 0,
    (SELECT player FROM players WHERE nick='RiChY'),
    (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
    7, 0,
    (SELECT player FROM players WHERE nick='RiChY'),

+   1,

    (SELECT song FROM songs WHERE lower(title)=lower('Exotic Ethnic')),
    't',
    8498);
    (SELECT song FROM songs WHERE lower(title)=lower('Exotic Ethnic')),
    't',
    8498);


@@ -2266,17 +2471,19 @@ INSERT INTO roundparticipation (tournament, round, parallel, player, position) V
    (SELECT player FROM players WHERE nick='DufF'),
    2
 );
    (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 4'),
    7, 0,
    (SELECT player FROM players WHERE nick='DufF'),
    (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
    7, 0,
    (SELECT player FROM players WHERE nick='DufF'),

+   0,

    (SELECT song FROM songs WHERE lower(title)=lower('Living in America')),
    'f',
    6778);
    (SELECT song FROM songs WHERE lower(title)=lower('Living in America')),
    'f',
    6778);

-INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (

    (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
    7, 0,
    (SELECT player FROM players WHERE nick='DufF'),
    (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
    7, 0,
    (SELECT player FROM players WHERE nick='DufF'),

+   1,

    (SELECT song FROM songs WHERE lower(title)=lower('Max 300')),
    't',
    9057);
    (SELECT song FROM songs WHERE lower(title)=lower('Max 300')),
    't',
    9057);


@@ -2287,17 +2494,19 @@ INSERT INTO roundparticipation (tournament, round, parallel, player, position) V
    (SELECT player FROM players WHERE nick='Snute'),
    3
 );
    (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 4'),
    7, 0,
    (SELECT player FROM players WHERE nick='Snute'),
    (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
    7, 0,
    (SELECT player FROM players WHERE nick='Snute'),

+   0,

    (SELECT song FROM songs WHERE lower(title)=lower('Living in America')),
    'f',
    6776);
    (SELECT song FROM songs WHERE lower(title)=lower('Living in America')),
    '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 4'),
    7, 0,
    (SELECT player FROM players WHERE nick='Snute'),
    (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
    7, 0,
    (SELECT player FROM players WHERE nick='Snute'),

+   1,

    (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
    't',
    8944);
    (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
    't',
    8944);


@@ -2327,17 +2536,19 @@ INSERT INTO roundparticipation (tournament, round, parallel, player, position) V
    (SELECT player FROM players WHERE nick='Snute'),
    1
 );
    (SELECT player FROM players WHERE nick='Snute'),
    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 4'),
    8, 0,
    (SELECT player FROM players WHERE nick='Snute'),
    (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
    8, 0,
    (SELECT player FROM players WHERE nick='Snute'),

+   0,

    (SELECT song FROM songs WHERE lower(title)=lower('www.blonde girl (MOMO Mix)')),
    'f',
    6883);
    (SELECT song FROM songs WHERE lower(title)=lower('www.blonde girl (MOMO Mix)')),
    'f',
    6883);

-INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (

    (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
    8, 0,
    (SELECT player FROM players WHERE nick='Snute'),
    (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
    8, 0,
    (SELECT player FROM players WHERE nick='Snute'),

+   1,

    (SELECT song FROM songs WHERE lower(title)=lower('Max 300')),
    't',
    9510);
    (SELECT song FROM songs WHERE lower(title)=lower('Max 300')),
    't',
    9510);


@@ -2348,17 +2559,19 @@ INSERT INTO roundparticipation (tournament, round, parallel, player, position) V
    (SELECT player FROM players WHERE nick='DufF'),
    2
 );
    (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 4'),
    8, 0,
    (SELECT player FROM players WHERE nick='DufF'),
    (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
    8, 0,
    (SELECT player FROM players WHERE nick='DufF'),

+   0,

    (SELECT song FROM songs WHERE lower(title)=lower('www.blonde girl (MOMO Mix)')),
    'f',
    6436);
    (SELECT song FROM songs WHERE lower(title)=lower('www.blonde girl (MOMO Mix)')),
    'f',
    6436);

-INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (

    (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
    8, 0,
    (SELECT player FROM players WHERE nick='DufF'),
    (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
    8, 0,
    (SELECT player FROM players WHERE nick='DufF'),

+   1,

    (SELECT song FROM songs WHERE lower(title)=lower('Exotic Ethnic')),
    't',
    8898);
    (SELECT song FROM songs WHERE lower(title)=lower('Exotic Ethnic')),
    't',
    8898);