From d2bf21e6f3f51a40b8901d570ac02e8a2061dc5f Mon Sep 17 00:00:00 2001 From: "Steinar H. Gunderson" Date: Mon, 4 Apr 2005 13:37:23 +0000 Subject: [PATCH] Sync from --pgweb. Patches applied: * sgunderson@bigfoot.com--2005-private/ccbs--pgweb--1.0--patch-17 Add a script for exporting tournaments from the database. * sgunderson@bigfoot.com--2005-private/ccbs--pgweb--1.0--patch-18 Add example SQL for PG EC2. --- parse/store-ccbs-tournament.pl | 124 + sql/ec2.sql | 5985 ++++++++++++++++++++++++++++++++ 2 files changed, 6109 insertions(+) create mode 100644 parse/store-ccbs-tournament.pl create mode 100644 sql/ec2.sql diff --git a/parse/store-ccbs-tournament.pl b/parse/store-ccbs-tournament.pl new file mode 100644 index 0000000..77647e8 --- /dev/null +++ b/parse/store-ccbs-tournament.pl @@ -0,0 +1,124 @@ +#! /usr/bin/perl +use strict; +use warnings; +use Date::Manip; +require "../html/ccbs.pm"; + +$SIG{__DIE__} = sub { + print STDERR shift; + exit; +}; + +# +# Not really a parser, but lets us export entire tournaments from one CCBS +# database to another in a simple way without having to worry about the +# numerical details. +# + +my $tno = shift; +die "Missing tournament number (give on command line)." if (!defined($tno)); + +print "begin;\n"; + +my $dbh = ccbs::db_connect(); + +# The tournament itself +my $tournament = $dbh->selectrow_hashref('SELECT * FROM tournaments NATURAL JOIN countries NATURAL JOIN seasons NATURAL JOIN machines NATURAL JOIN scoringsystems WHERE tournament=?', undef, $tno); + +print "INSERT INTO tournaments \n"; +print " (season, tournamentname, country, location, \"date\", machine, scoringsystem) VALUES (\n"; +print " (SELECT season FROM seasons WHERE seasonname='$tournament->{'seasonname'}' ),\n"; +print " '$tournament->{'tournamentname'}',\n"; +print " (SELECT country FROM countries WHERE countryname='$tournament->{'countryname'}'),\n"; +print " '$tournament->{'location'}',\n"; +print " '$tournament->{'date'}',\n"; +print " (SELECT machine FROM machines WHERE machinename='$tournament->{'machinename'}'),\n"; +print " (SELECT scoringsystem FROM scoringsystems WHERE scoringsystemname='$tournament->{'scoringsystemname'}')\n"; +print ");\n"; + +# useful +my $tsql = "(SELECT tournament FROM tournaments WHERE tournamentname='$tournament->{'tournamentname'}' AND season=( SELECT season FROM seasons WHERE seasonname='$tournament->{'seasonname'}' ))"; + +# Rankings, and players (FIXME: do clubs as well) +my $rankings = ccbs::db_fetch_all($dbh, 'SELECT * FROM tournamentrankings NATURAL JOIN players NATURAL JOIN countries WHERE tournament=?', $tno); +for my $rank (@$rankings) { + printf "INSERT INTO players SELECT nextval('players_player_seq') AS player, '%s' AS nick, ( SELECT country FROM countries WHERE countryname='%s' ) AS country WHERE '%s' NOT IN ( SELECT nick FROM players );\n", $rank->{'nick'}, $rank->{'countryname'}, $rank->{'nick'}; + + my $p = $rank->{'points'}; + $p = 'NULL' if (!defined($p)); + + print "INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (\n"; + print " $tsql,"; + print " $rank->{'ranking'},\n"; + print " (SELECT player FROM players WHERE nick='$rank->{'nick'}'),\n"; + print " $p);\n"; +} + +# Skip tournamentparticipation, it is not needed except during the tournament. + +# Rounds +my $rounds = ccbs::db_fetch_all($dbh, 'SELECT * FROM rounds WHERE tournament=?', $tno); +for my $round (@$rounds) { + print "INSERT INTO rounds ( tournament, round, randomsongs, chosensongs, numqualifying ) VALUES (\n"; + print " $tsql,\n"; + print " $round->{'round'},\n"; + print " $round->{'randomsongs'},\n"; + print " $round->{'chosensongs'},\n"; + print " $round->{'numqualifying'});\n"; +} + +# Groups +my $groups = ccbs::db_fetch_all($dbh, 'SELECT * FROM groups WHERE tournament=?', $tno); +for my $group (@$groups) { + print "INSERT INTO groups ( tournament, round, parallel ) VALUES (\n"; + print " $tsql,\n"; + print " $group->{'round'},\n"; + print " $group->{'parallel'});\n"; +} + +# Round random songs +my $rrs = ccbs::db_fetch_all($dbh, 'SELECT * FROM roundrandomsongs NATURAL JOIN songs WHERE tournament=?', $tno); +for my $rr (@$rrs) { + (my $title = $rr->{'title'}) =~ s/'/\\'/g; + + print "INSERT INTO roundrandomsongs ( tournament, round, parallel, song ) VALUES (\n"; + print " $tsql,\n"; + print " $rr->{'round'},\n"; + print " $rr->{'parallel'},\n"; + print " ( SELECT song FROM songs WHERE lower(title)=lower('$title') ));\n"; +} + +# Round participation +my $rps = ccbs::db_fetch_all($dbh, 'SELECT * FROM roundparticipation NATURAL JOIN players WHERE tournament=?', $tno); +for my $rp (@$rps) { + print "INSERT INTO roundparticipation ( tournament, round, parallel, player, position ) VALUES (\n"; + print " $tsql,\n"; + print " $rp->{'round'},\n"; + print " $rp->{'parallel'},\n"; + print " ( SELECT player FROM players WHERE nick='$rp->{'nick'}' ),\n"; + print " $rp->{'position'});\n"; +} + +# And finally, scores +my $scores = ccbs::db_fetch_all($dbh, 'SELECT * FROM scores NATURAL JOIN songs NATURAL JOIN players WHERE tournament=?', $tno); +for my $score (@$scores) { + my $chosen = $score->{'chosen'} ? 't' : 'f'; + (my $title = $score->{'title'}) =~ s/'/\\'/g; + + print "INSERT INTO scores ( tournament, round, parallel, player, songnumber, song, playmode, difficulty, chosen, score ) VALUES (\n"; + print " $tsql,\n"; + print " $score->{'round'},\n"; + print " $score->{'parallel'},\n"; + print " ( SELECT player FROM players WHERE nick='$score->{'nick'}' ),\n"; + print " $score->{'songnumber'},\n"; + print " ( SELECT song FROM songs WHERE lower(title)=lower('$title') ),\n"; + print " '$score->{'playmode'}',\n"; + print " '$score->{'difficulty'}',\n"; + print " '$chosen',\n"; + print " $score->{'score'});\n"; +} + +print "commit;\n"; + +$dbh->disconnect; + diff --git a/sql/ec2.sql b/sql/ec2.sql new file mode 100644 index 0000000..a018679 --- /dev/null +++ b/sql/ec2.sql @@ -0,0 +1,5985 @@ +begin; +INSERT INTO tournaments + (season, tournamentname, country, location, "date", machine, scoringsystem) VALUES ( + (SELECT season FROM seasons WHERE seasonname='European Cup' ), + 'European PG Cup 2', + (SELECT country FROM countries WHERE countryname='Europe'), + 'The Gathering, Norway', + '2005-03-26', + (SELECT machine FROM machines WHERE machinename='Dancing Stage EuroMix 2'), + (SELECT scoringsystem FROM scoringsystems WHERE scoringsystemname='10K Machine score') +); +INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Eric' AS nick, ( SELECT country FROM countries WHERE countryname='Belgium' ) AS country WHERE 'Eric' NOT IN ( SELECT nick FROM players ); +INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European PG Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )), 10, + (SELECT player FROM players WHERE nick='Eric'), + 55); +INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Tsung' AS nick, ( SELECT country FROM countries WHERE countryname='Czech Republic' ) AS country WHERE 'Tsung' NOT IN ( SELECT nick FROM players ); +INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European PG Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )), 54, + (SELECT player FROM players WHERE nick='Tsung'), + 11); +INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Elias' AS nick, ( SELECT country FROM countries WHERE countryname='Spain' ) AS country WHERE 'Elias' NOT IN ( SELECT nick FROM players ); +INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European PG Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )), 20, + (SELECT player FROM players WHERE nick='Elias'), + 45); +INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Kasuya' AS nick, ( SELECT country FROM countries WHERE countryname='Spain' ) AS country WHERE 'Kasuya' NOT IN ( SELECT nick FROM players ); +INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European PG Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )), 40, + (SELECT player FROM players WHERE nick='Kasuya'), + 25); +INSERT INTO players SELECT nextval('players_player_seq') AS player, 'stuf' AS nick, ( SELECT country FROM countries WHERE countryname='Finland' ) AS country WHERE 'stuf' NOT IN ( SELECT nick FROM players ); +INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European PG Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )), 36, + (SELECT player FROM players WHERE nick='stuf'), + 29); +INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Smooth' AS nick, ( SELECT country FROM countries WHERE countryname='Finland' ) AS country WHERE 'Smooth' NOT IN ( SELECT nick FROM players ); +INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European PG Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )), 14, + (SELECT player FROM players WHERE nick='Smooth'), + 51); +INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Jukeboksi' AS nick, ( SELECT country FROM countries WHERE countryname='Finland' ) AS country WHERE 'Jukeboksi' NOT IN ( SELECT nick FROM players ); +INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European PG Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )), 37, + (SELECT player FROM players WHERE nick='Jukeboksi'), + 28); +INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Jka' AS nick, ( SELECT country FROM countries WHERE countryname='Finland' ) AS country WHERE 'Jka' NOT IN ( SELECT nick FROM players ); +INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European PG Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )), 15, + (SELECT player FROM players WHERE nick='Jka'), + 50); +INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Ai' AS nick, ( SELECT country FROM countries WHERE countryname='France' ) AS country WHERE 'Ai' NOT IN ( SELECT nick FROM players ); +INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European PG Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )), 45, + (SELECT player FROM players WHERE nick='Ai'), + 20); +INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Stelisevil' AS nick, ( SELECT country FROM countries WHERE countryname='Great Britain' ) AS country WHERE 'Stelisevil' NOT IN ( SELECT nick FROM players ); +INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European PG Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )), 3, + (SELECT player FROM players WHERE nick='Stelisevil'), + 83); +INSERT INTO players SELECT nextval('players_player_seq') AS player, 'K-Dogg' AS nick, ( SELECT country FROM countries WHERE countryname='Great Britain' ) AS country WHERE 'K-Dogg' NOT IN ( SELECT nick FROM players ); +INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European PG Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )), 2, + (SELECT player FROM players WHERE nick='K-Dogg'), + 91); +INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Amegon' AS nick, ( SELECT country FROM countries WHERE countryname='Germany' ) AS country WHERE 'Amegon' NOT IN ( SELECT nick FROM players ); +INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European PG Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )), 47, + (SELECT player FROM players WHERE nick='Amegon'), + 18); +INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Skazi' AS nick, ( SELECT country FROM countries WHERE countryname='Israel' ) AS country WHERE 'Skazi' NOT IN ( SELECT nick FROM players ); +INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European PG Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )), 23, + (SELECT player FROM players WHERE nick='Skazi'), + 42); +INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Drummer' AS nick, ( SELECT country FROM countries WHERE countryname='Italy' ) AS country WHERE 'Drummer' NOT IN ( SELECT nick FROM players ); +INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European PG Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )), 7, + (SELECT player FROM players WHERE nick='Drummer'), + 61); +INSERT INTO players SELECT nextval('players_player_seq') AS player, 'T_Bone_X_Zeo' AS nick, ( SELECT country FROM countries WHERE countryname='Netherlands' ) AS country WHERE 'T_Bone_X_Zeo' NOT IN ( SELECT nick FROM players ); +INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European PG Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )), 5, + (SELECT player FROM players WHERE nick='T_Bone_X_Zeo'), + 70); +INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Kabbefett' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Kabbefett' NOT IN ( SELECT nick FROM players ); +INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European PG Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )), 46, + (SELECT player FROM players WHERE nick='Kabbefett'), + 19); +INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Yukinon' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Yukinon' NOT IN ( SELECT nick FROM players ); +INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European PG Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )), 53, + (SELECT player FROM players WHERE nick='Yukinon'), + 12); +INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Al' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Al' NOT IN ( SELECT nick FROM players ); +INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European PG Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )), 24, + (SELECT player FROM players WHERE nick='Al'), + 41); +INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Infernuz' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Infernuz' NOT IN ( SELECT nick FROM players ); +INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European PG Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )), 57, + (SELECT player FROM players WHERE nick='Infernuz'), + 8); +INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Camry' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Camry' NOT IN ( SELECT nick FROM players ); +INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European PG Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )), 50, + (SELECT player FROM players WHERE nick='Camry'), + 15); +INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Kenny' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Kenny' NOT IN ( SELECT nick FROM players ); +INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European PG Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )), 42, + (SELECT player FROM players WHERE nick='Kenny'), + 23); +INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Bazze' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Bazze' NOT IN ( SELECT nick FROM players ); +INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European PG Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )), 55, + (SELECT player FROM players WHERE nick='Bazze'), + 10); +INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Lord Glenn' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Lord Glenn' NOT IN ( SELECT nick FROM players ); +INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European PG Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )), 18, + (SELECT player FROM players WHERE nick='Lord Glenn'), + 47); +INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Oliyzia' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Oliyzia' NOT IN ( SELECT nick FROM players ); +INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European PG Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )), 33, + (SELECT player FROM players WHERE nick='Oliyzia'), + 32); +INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Sesse' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Sesse' NOT IN ( SELECT nick FROM players ); +INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European PG Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )), 28, + (SELECT player FROM players WHERE nick='Sesse'), + 37); +INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Nuust' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Nuust' NOT IN ( SELECT nick FROM players ); +INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European PG Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )), 19, + (SELECT player FROM players WHERE nick='Nuust'), + 46); +INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Zredna' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Zredna' NOT IN ( SELECT nick FROM players ); +INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European PG Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )), 29, + (SELECT player FROM players WHERE nick='Zredna'), + 36); +INSERT INTO players SELECT nextval('players_player_seq') AS player, 'uSimen' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'uSimen' NOT IN ( SELECT nick FROM players ); +INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European PG Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )), 49, + (SELECT player FROM players WHERE nick='uSimen'), + 16); +INSERT INTO players SELECT nextval('players_player_seq') AS player, 'JonAnders' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'JonAnders' NOT IN ( SELECT nick FROM players ); +INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European PG Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )), 43, + (SELECT player FROM players WHERE nick='JonAnders'), + 22); +INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Pyro' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Pyro' NOT IN ( SELECT nick FROM players ); +INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European PG Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )), 17, + (SELECT player FROM players WHERE nick='Pyro'), + 48); +INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Electron' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Electron' NOT IN ( SELECT nick FROM players ); +INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European PG Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )), 25, + (SELECT player FROM players WHERE nick='Electron'), + 40); +INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Maxion' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Maxion' NOT IN ( SELECT nick FROM players ); +INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European PG Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )), 48, + (SELECT player FROM players WHERE nick='Maxion'), + 17); +INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Ngan' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Ngan' NOT IN ( SELECT nick FROM players ); +INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European PG Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )), 52, + (SELECT player FROM players WHERE nick='Ngan'), + 13); +INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Andeplane' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Andeplane' NOT IN ( SELECT nick FROM players ); +INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European PG Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )), 16, + (SELECT player FROM players WHERE nick='Andeplane'), + 49); +INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Cehtna' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Cehtna' NOT IN ( SELECT nick FROM players ); +INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European PG Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )), 38, + (SELECT player FROM players WHERE nick='Cehtna'), + 27); +INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Felz' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Felz' NOT IN ( SELECT nick FROM players ); +INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European PG Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )), 35, + (SELECT player FROM players WHERE nick='Felz'), + 30); +INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Cuivien' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Cuivien' NOT IN ( SELECT nick FROM players ); +INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European PG Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )), 12, + (SELECT player FROM players WHERE nick='Cuivien'), + 53); +INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Hyper' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Hyper' NOT IN ( SELECT nick FROM players ); +INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European PG Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )), 39, + (SELECT player FROM players WHERE nick='Hyper'), + 26); +INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Mync' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Mync' NOT IN ( SELECT nick FROM players ); +INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European PG Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )), 56, + (SELECT player FROM players WHERE nick='Mync'), + 9); +INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Gogo' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Gogo' NOT IN ( SELECT nick FROM players ); +INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European PG Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )), 11, + (SELECT player FROM players WHERE nick='Gogo'), + 54); +INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Eruanna' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Eruanna' NOT IN ( SELECT nick FROM players ); +INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European PG Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )), 51, + (SELECT player FROM players WHERE nick='Eruanna'), + 14); +INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Bonzo' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Bonzo' NOT IN ( SELECT nick FROM players ); +INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European PG Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )), 8, + (SELECT player FROM players WHERE nick='Bonzo'), + 58); +INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Nameless' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Nameless' NOT IN ( SELECT nick FROM players ); +INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European PG Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )), 26, + (SELECT player FROM players WHERE nick='Nameless'), + 39); +INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Ylini' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Ylini' NOT IN ( SELECT nick FROM players ); +INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European PG Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )), 31, + (SELECT player FROM players WHERE nick='Ylini'), + 34); +INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Duckling' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Duckling' NOT IN ( SELECT nick FROM players ); +INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European PG Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )), 22, + (SELECT player FROM players WHERE nick='Duckling'), + 43); +INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Olemann' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Olemann' NOT IN ( SELECT nick FROM players ); +INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European PG Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )), 41, + (SELECT player FROM players WHERE nick='Olemann'), + 24); +INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Smiph' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Smiph' NOT IN ( SELECT nick FROM players ); +INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European PG Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )), 32, + (SELECT player FROM players WHERE nick='Smiph'), + 33); +INSERT INTO players SELECT nextval('players_player_seq') AS player, 'T|na' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'T|na' NOT IN ( SELECT nick FROM players ); +INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European PG Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )), 30, + (SELECT player FROM players WHERE nick='T|na'), + 35); +INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Daniil' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Daniil' NOT IN ( SELECT nick FROM players ); +INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European PG Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )), 34, + (SELECT player FROM players WHERE nick='Daniil'), + 31); +INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Haggar' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Haggar' NOT IN ( SELECT nick FROM players ); +INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European PG Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )), 6, + (SELECT player FROM players WHERE nick='Haggar'), + 65); +INSERT INTO players SELECT nextval('players_player_seq') AS player, 'RiChY' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'RiChY' NOT IN ( SELECT nick FROM players ); +INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European PG Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )), 13, + (SELECT player FROM players WHERE nick='RiChY'), + 52); +INSERT INTO players SELECT nextval('players_player_seq') AS player, 'OJK' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'OJK' NOT IN ( SELECT nick FROM players ); +INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European PG Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )), 9, + (SELECT player FROM players WHERE nick='OJK'), + 56); +INSERT INTO players SELECT nextval('players_player_seq') AS player, 'DufF' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'DufF' NOT IN ( SELECT nick FROM players ); +INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European PG Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )), 27, + (SELECT player FROM players WHERE nick='DufF'), + 38); +INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Snute' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Snute' NOT IN ( SELECT nick FROM players ); +INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European PG Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )), 4, + (SELECT player FROM players WHERE nick='Snute'), + 76); +INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Ryouko' AS nick, ( SELECT country FROM countries WHERE countryname='Poland' ) AS country WHERE 'Ryouko' NOT IN ( SELECT nick FROM players ); +INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European PG Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )), 44, + (SELECT player FROM players WHERE nick='Ryouko'), + 21); +INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Milk' AS nick, ( SELECT country FROM countries WHERE countryname='Sweden' ) AS country WHERE 'Milk' NOT IN ( SELECT nick FROM players ); +INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European PG Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )), 21, + (SELECT player FROM players WHERE nick='Milk'), + 44); +INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Kasu' AS nick, ( SELECT country FROM countries WHERE countryname='Sweden' ) AS country WHERE 'Kasu' NOT IN ( SELECT nick FROM players ); +INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European PG Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )), 1, + (SELECT player FROM players WHERE nick='Kasu'), + 100); +INSERT INTO rounds ( tournament, round, randomsongs, chosensongs, numqualifying ) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European PG Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )), + 1, + 1, + 0, + 57); +INSERT INTO rounds ( tournament, round, randomsongs, chosensongs, numqualifying ) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European PG Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )), + 2, + 2, + 1, + 2); +INSERT INTO rounds ( tournament, round, randomsongs, chosensongs, numqualifying ) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European PG Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )), + 4, + 1, + 1, + 9); +INSERT INTO rounds ( tournament, round, randomsongs, chosensongs, numqualifying ) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European PG Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )), + 3, + 2, + 1, + 2); +INSERT INTO rounds ( tournament, round, randomsongs, chosensongs, numqualifying ) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European PG Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )), + 5, + 1, + 1, + 7); +INSERT INTO rounds ( tournament, round, randomsongs, chosensongs, numqualifying ) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European PG Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )), + 6, + 1, + 1, + 5); +INSERT INTO rounds ( tournament, round, randomsongs, chosensongs, numqualifying ) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European PG Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )), + 7, + 1, + 1, + 4); +INSERT INTO rounds ( tournament, round, randomsongs, chosensongs, numqualifying ) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European PG Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )), + 8, + 1, + 1, + 3); +INSERT INTO rounds ( tournament, round, randomsongs, chosensongs, numqualifying ) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European PG Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )), + 9, + 1, + 1, + 2); +INSERT INTO rounds ( tournament, round, randomsongs, chosensongs, numqualifying ) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European PG Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )), + 10, + 1, + 1, + 1); +INSERT INTO groups ( tournament, round, parallel ) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European PG Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )), + 1, + 0); +INSERT INTO groups ( tournament, round, parallel ) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European PG Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )), + 2, + 1); +INSERT INTO groups ( tournament, round, parallel ) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European PG Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )), + 2, + 2); +INSERT INTO groups ( tournament, round, parallel ) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European PG Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )), + 2, + 3); +INSERT INTO groups ( tournament, round, parallel ) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European PG Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )), + 2, + 4); +INSERT INTO groups ( tournament, round, parallel ) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European PG Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )), + 2, + 5); +INSERT INTO groups ( tournament, round, parallel ) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European PG Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )), + 2, + 6); +INSERT INTO groups ( tournament, round, parallel ) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European PG Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )), + 2, + 7); +INSERT INTO groups ( tournament, round, parallel ) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European PG Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )), + 2, + 8); +INSERT INTO groups ( tournament, round, parallel ) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European PG Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )), + 2, + 9); +INSERT INTO groups ( tournament, round, parallel ) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European PG Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )), + 2, + 10); +INSERT INTO groups ( tournament, round, parallel ) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European PG Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )), + 2, + 11); +INSERT INTO groups ( tournament, round, parallel ) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European PG Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )), + 2, + 12); +INSERT INTO groups ( tournament, round, parallel ) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European PG Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )), + 4, + 0); +INSERT INTO groups ( tournament, round, parallel ) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European PG Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )), + 5, + 0); +INSERT INTO groups ( tournament, round, parallel ) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European PG Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )), + 6, + 0); +INSERT INTO groups ( tournament, round, parallel ) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European PG Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )), + 7, + 0); +INSERT INTO groups ( tournament, round, parallel ) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European PG Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )), + 8, + 0); +INSERT INTO groups ( tournament, round, parallel ) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European PG Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )), + 9, + 0); +INSERT INTO groups ( tournament, round, parallel ) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European PG Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )), + 3, + 1); +INSERT INTO groups ( tournament, round, parallel ) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European PG Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )), + 3, + 2); +INSERT INTO groups ( tournament, round, parallel ) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European PG Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )), + 3, + 3); +INSERT INTO groups ( tournament, round, parallel ) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European PG Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )), + 3, + 4); +INSERT INTO groups ( tournament, round, parallel ) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European PG Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )), + 3, + 5); +INSERT INTO groups ( tournament, round, parallel ) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European PG Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )), + 3, + 6); +INSERT INTO groups ( tournament, round, parallel ) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European PG Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )), + 10, + 0); +INSERT INTO roundrandomsongs ( tournament, round, parallel, song ) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European PG Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )), + 3, + 4, + ( SELECT song FROM songs WHERE lower(title)=lower('I Want You to Want Me') )); +INSERT INTO roundrandomsongs ( tournament, round, parallel, song ) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European PG Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )), + 3, + 2, + ( SELECT song FROM songs WHERE lower(title)=lower('That was Then, This is Now') )); +INSERT INTO roundrandomsongs ( tournament, round, parallel, song ) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European PG Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )), + 3, + 3, + ( SELECT song FROM songs WHERE lower(title)=lower('Caribbean Queen') )); +INSERT INTO roundrandomsongs ( tournament, round, parallel, song ) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European PG Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )), + 2, + 7, + ( SELECT song FROM songs WHERE lower(title)=lower('Stomp') )); +INSERT INTO roundrandomsongs ( tournament, round, parallel, song ) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European PG Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )), + 7, + 0, + ( SELECT song FROM songs WHERE lower(title)=lower('The Centre of the Heart (Stonebridge Club Mix)') )); +INSERT INTO roundrandomsongs ( tournament, round, parallel, song ) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European PG Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )), + 2, + 5, + ( SELECT song FROM songs WHERE lower(title)=lower('The Centre of the Heart (Stonebridge Club Mix)') )); +INSERT INTO roundrandomsongs ( tournament, round, parallel, song ) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European PG Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )), + 2, + 5, + ( SELECT song FROM songs WHERE lower(title)=lower('The Reflex') )); +INSERT INTO roundrandomsongs ( tournament, round, parallel, song ) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European PG Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )), + 2, + 2, + ( SELECT song FROM songs WHERE lower(title)=lower('Love You Like A Fool') )); +INSERT INTO roundrandomsongs ( tournament, round, parallel, song ) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European PG Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )), + 5, + 0, + ( SELECT song FROM songs WHERE lower(title)=lower('Nori Nori Nori') )); +INSERT INTO roundrandomsongs ( tournament, round, parallel, song ) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European PG Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )), + 2, + 4, + ( SELECT song FROM songs WHERE lower(title)=lower('Don\'t Try to Stop It') )); +INSERT INTO roundrandomsongs ( tournament, round, parallel, song ) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European PG Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )), + 2, + 12, + ( SELECT song FROM songs WHERE lower(title)=lower('Never Ending Story') )); +INSERT INTO roundrandomsongs ( tournament, round, parallel, song ) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European PG Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )), + 4, + 0, + ( SELECT song FROM songs WHERE lower(title)=lower('Remember You') )); +INSERT INTO roundrandomsongs ( tournament, round, parallel, song ) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European PG Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )), + 2, + 9, + ( SELECT song FROM songs WHERE lower(title)=lower('Remember You') )); +INSERT INTO roundrandomsongs ( tournament, round, parallel, song ) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European PG Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )), + 3, + 2, + ( SELECT song FROM songs WHERE lower(title)=lower('Spin the Disc') )); +INSERT INTO roundrandomsongs ( tournament, round, parallel, song ) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European PG Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )), + 2, + 10, + ( SELECT song FROM songs WHERE lower(title)=lower('Spin the Disc') )); +INSERT INTO roundrandomsongs ( tournament, round, parallel, song ) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European PG Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )), + 2, + 1, + ( SELECT song FROM songs WHERE lower(title)=lower('Let the Beat Hit \'em!') )); +INSERT INTO roundrandomsongs ( tournament, round, parallel, song ) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European PG Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )), + 2, + 6, + ( SELECT song FROM songs WHERE lower(title)=lower('Look to the Sky') )); +INSERT INTO roundrandomsongs ( tournament, round, parallel, song ) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European PG Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )), + 2, + 3, + ( SELECT song FROM songs WHERE lower(title)=lower('Rain of Sorrow') )); +INSERT INTO roundrandomsongs ( tournament, round, parallel, song ) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European PG Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )), + 2, + 10, + ( SELECT song FROM songs WHERE lower(title)=lower('D2R') )); +INSERT INTO roundrandomsongs ( tournament, round, parallel, song ) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European PG Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )), + 9, + 0, + ( SELECT song FROM songs WHERE lower(title)=lower('My Summer Love') )); +INSERT INTO roundrandomsongs ( tournament, round, parallel, song ) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European PG Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )), + 3, + 4, + ( SELECT song FROM songs WHERE lower(title)=lower('My Summer Love') )); +INSERT INTO roundrandomsongs ( tournament, round, parallel, song ) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European PG Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )), + 2, + 12, + ( SELECT song FROM songs WHERE lower(title)=lower('Groove 2001') )); +INSERT INTO roundrandomsongs ( tournament, round, parallel, song ) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European PG Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )), + 3, + 3, + ( SELECT song FROM songs WHERE lower(title)=lower('B4U') )); +INSERT INTO roundrandomsongs ( tournament, round, parallel, song ) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European PG Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )), + 1, + 0, + ( SELECT song FROM songs WHERE lower(title)=lower('era (nostalmix)') )); +INSERT INTO roundrandomsongs ( tournament, round, parallel, song ) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European PG Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )), + 2, + 7, + ( SELECT song FROM songs WHERE lower(title)=lower('Burnin\' the Floor') )); +INSERT INTO roundrandomsongs ( tournament, round, parallel, song ) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European PG Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )), + 2, + 8, + ( SELECT song FROM songs WHERE lower(title)=lower('Crash!') )); +INSERT INTO roundrandomsongs ( tournament, round, parallel, song ) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European PG Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )), + 3, + 6, + ( SELECT song FROM songs WHERE lower(title)=lower('DXY!') )); +INSERT INTO roundrandomsongs ( tournament, round, parallel, song ) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European PG Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )), + 2, + 3, + ( SELECT song FROM songs WHERE lower(title)=lower('Afronova Primeval') )); +INSERT INTO roundrandomsongs ( tournament, round, parallel, song ) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European PG Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )), + 2, + 9, + ( SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love (SPEED MIX)') )); +INSERT INTO roundrandomsongs ( tournament, round, parallel, song ) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European PG Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )), + 2, + 4, + ( SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)') )); +INSERT INTO roundrandomsongs ( tournament, round, parallel, song ) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European PG Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )), + 6, + 0, + ( SELECT song FROM songs WHERE lower(title)=lower('Healing Vision (Angelic Mix)') )); +INSERT INTO roundrandomsongs ( tournament, round, parallel, song ) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European PG Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )), + 2, + 11, + ( SELECT song FROM songs WHERE lower(title)=lower('20th November') )); +INSERT INTO roundrandomsongs ( tournament, round, parallel, song ) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European PG Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )), + 2, + 6, + ( SELECT song FROM songs WHERE lower(title)=lower('Let Them Move') )); +INSERT INTO roundrandomsongs ( tournament, round, parallel, song ) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European PG Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )), + 3, + 6, + ( SELECT song FROM songs WHERE lower(title)=lower('Silent Hill') )); +INSERT INTO roundrandomsongs ( tournament, round, parallel, song ) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European PG Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )), + 8, + 0, + ( SELECT song FROM songs WHERE lower(title)=lower('Make A Jam!') )); +INSERT INTO roundrandomsongs ( tournament, round, parallel, song ) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European PG Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )), + 2, + 8, + ( SELECT song FROM songs WHERE lower(title)=lower('Make A Jam!') )); +INSERT INTO roundrandomsongs ( tournament, round, parallel, song ) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European PG Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )), + 3, + 1, + ( SELECT song FROM songs WHERE lower(title)=lower('Luv to Me (AMD Mix)') )); +INSERT INTO roundrandomsongs ( tournament, round, parallel, song ) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European PG Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )), + 3, + 1, + ( SELECT song FROM songs WHERE lower(title)=lower('Love This Feelin\'') )); +INSERT INTO roundrandomsongs ( tournament, round, parallel, song ) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European PG Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )), + 3, + 5, + ( SELECT song FROM songs WHERE lower(title)=lower('Dynamite Rave') )); +INSERT INTO roundrandomsongs ( tournament, round, parallel, song ) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European PG Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )), + 2, + 1, + ( SELECT song FROM songs WHERE lower(title)=lower('Dynamite Rave') )); +INSERT INTO roundrandomsongs ( tournament, round, parallel, song ) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European PG Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )), + 3, + 5, + ( SELECT song FROM songs WHERE lower(title)=lower('Dead End') )); +INSERT INTO roundrandomsongs ( tournament, round, parallel, song ) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European PG Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )), + 10, + 0, + ( SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)') )); +INSERT INTO roundrandomsongs ( tournament, round, parallel, song ) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European PG Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )), + 2, + 11, + ( SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)') )); +INSERT INTO roundrandomsongs ( tournament, round, parallel, song ) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European PG Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )), + 2, + 2, + ( SELECT song FROM songs WHERE lower(title)=lower('Afronova') )); +INSERT INTO roundparticipation ( tournament, round, parallel, player, position ) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European PG Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )), + 8, + 0, + ( SELECT player FROM players WHERE nick='Snute' ), + 1); +INSERT INTO roundparticipation ( tournament, round, parallel, player, position ) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European PG Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )), + 7, + 0, + ( SELECT player FROM players WHERE nick='Snute' ), + 4); +INSERT INTO roundparticipation ( tournament, round, parallel, player, position ) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European PG Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )), + 6, + 0, + ( SELECT player FROM players WHERE nick='Snute' ), + 2); +INSERT INTO roundparticipation ( tournament, round, parallel, player, position ) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European PG Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )), + 5, + 0, + ( SELECT player FROM players WHERE nick='Snute' ), + 3); +INSERT INTO roundparticipation ( tournament, round, parallel, player, position ) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European PG Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )), + 4, + 0, + ( SELECT player FROM players WHERE nick='Snute' ), + 8); +INSERT INTO roundparticipation ( tournament, round, parallel, player, position ) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European PG Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )), + 3, + 4, + ( SELECT player FROM players WHERE nick='Snute' ), + 4); +INSERT INTO roundparticipation ( tournament, round, parallel, player, position ) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European PG Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )), + 2, + 8, + ( SELECT player FROM players WHERE nick='Snute' ), + 5); +INSERT INTO roundparticipation ( tournament, round, parallel, player, position ) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European PG Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )), + 1, + 0, + ( SELECT player FROM players WHERE nick='Snute' ), + 48); +INSERT INTO roundparticipation ( tournament, round, parallel, player, position ) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European PG Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )), + 2, + 11, + ( SELECT player FROM players WHERE nick='DufF' ), + 1); +INSERT INTO roundparticipation ( tournament, round, parallel, player, position ) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European PG Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )), + 1, + 0, + ( SELECT player FROM players WHERE nick='DufF' ), + 13); +INSERT INTO roundparticipation ( tournament, round, parallel, player, position ) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European PG Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )), + 5, + 0, + ( SELECT player FROM players WHERE nick='OJK' ), + 4); +INSERT INTO roundparticipation ( tournament, round, parallel, player, position ) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European PG Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )), + 4, + 0, + ( SELECT player FROM players WHERE nick='OJK' ), + 6); +INSERT INTO roundparticipation ( tournament, round, parallel, player, position ) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European PG Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )), + 3, + 5, + ( SELECT player FROM players WHERE nick='OJK' ), + 2); +INSERT INTO roundparticipation ( tournament, round, parallel, player, position ) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European PG Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )), + 2, + 10, + ( SELECT player FROM players WHERE nick='OJK' ), + 3); +INSERT INTO roundparticipation ( tournament, round, parallel, player, position ) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European PG Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )), + 1, + 0, + ( SELECT player FROM players WHERE nick='OJK' ), + 38); +INSERT INTO roundparticipation ( tournament, round, parallel, player, position ) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European PG Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )), + 3, + 5, + ( SELECT player FROM players WHERE nick='RiChY' ), + 3); +INSERT INTO roundparticipation ( tournament, round, parallel, player, position ) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European PG Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )), + 2, + 9, + ( SELECT player FROM players WHERE nick='RiChY' ), + 5); +INSERT INTO roundparticipation ( tournament, round, parallel, player, position ) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European PG Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )), + 1, + 0, + ( SELECT player FROM players WHERE nick='RiChY' ), + 42); +INSERT INTO roundparticipation ( tournament, round, parallel, player, position ) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European PG Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )), + 6, + 0, + ( SELECT player FROM players WHERE nick='Haggar' ), + 7); +INSERT INTO roundparticipation ( tournament, round, parallel, player, position ) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European PG Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )), + 5, + 0, + ( SELECT player FROM players WHERE nick='Haggar' ), + 5); +INSERT INTO roundparticipation ( tournament, round, parallel, player, position ) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European PG Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )), + 4, + 0, + ( SELECT player FROM players WHERE nick='Haggar' ), + 7); +INSERT INTO roundparticipation ( tournament, round, parallel, player, position ) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European PG Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )), + 3, + 1, + ( SELECT player FROM players WHERE nick='Haggar' ), + 4); +INSERT INTO roundparticipation ( tournament, round, parallel, player, position ) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European PG Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )), + 2, + 11, + ( SELECT player FROM players WHERE nick='Haggar' ), + 4); +INSERT INTO roundparticipation ( tournament, round, parallel, player, position ) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European PG Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )), + 1, + 0, + ( SELECT player FROM players WHERE nick='Haggar' ), + 20); +INSERT INTO roundparticipation ( tournament, round, parallel, player, position ) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European PG Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )), + 2, + 3, + ( SELECT player FROM players WHERE nick='Daniil' ), + 4); +INSERT INTO roundparticipation ( tournament, round, parallel, player, position ) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European PG Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )), + 1, + 0, + ( SELECT player FROM players WHERE nick='Daniil' ), + 10); +INSERT INTO roundparticipation ( tournament, round, parallel, player, position ) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European PG Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )), + 2, + 12, + ( SELECT player FROM players WHERE nick='T|na' ), + 2); +INSERT INTO roundparticipation ( tournament, round, parallel, player, position ) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European PG Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )), + 1, + 0, + ( SELECT player FROM players WHERE nick='T|na' ), + 53); +INSERT INTO roundparticipation ( tournament, round, parallel, player, position ) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European PG Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )), + 2, + 4, + ( SELECT player FROM players WHERE nick='Smiph' ), + 2); +INSERT INTO roundparticipation ( tournament, round, parallel, player, position ) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European PG Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )), + 1, + 0, + ( SELECT player FROM players WHERE nick='Smiph' ), + 46); +INSERT INTO roundparticipation ( tournament, round, parallel, player, position ) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European PG Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )), + 2, + 5, + ( SELECT player FROM players WHERE nick='Olemann' ), + 3); +INSERT INTO roundparticipation ( tournament, round, parallel, player, position ) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European PG Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )), + 1, + 0, + ( SELECT player FROM players WHERE nick='Olemann' ), + 39); +INSERT INTO roundparticipation ( tournament, round, parallel, player, position ) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European PG Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )), + 3, + 4, + ( SELECT player FROM players WHERE nick='Duckling' ), + 2); +INSERT INTO roundparticipation ( tournament, round, parallel, player, position ) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European PG Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )), + 2, + 8, + ( SELECT player FROM players WHERE nick='Duckling' ), + 3); +INSERT INTO roundparticipation ( tournament, round, parallel, player, position ) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European PG Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )), + 1, + 0, + ( SELECT player FROM players WHERE nick='Duckling' ), + 12); +INSERT INTO roundparticipation ( tournament, round, parallel, player, position ) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European PG Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )), + 2, + 5, + ( SELECT player FROM players WHERE nick='Ylini' ), + 4); +INSERT INTO roundparticipation ( tournament, round, parallel, player, position ) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European PG Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )), + 1, + 0, + ( SELECT player FROM players WHERE nick='Ylini' ), + 55); +INSERT INTO roundparticipation ( tournament, round, parallel, player, position ) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European PG Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )), + 2, + 2, + ( SELECT player FROM players WHERE nick='Nameless' ), + 4); +INSERT INTO roundparticipation ( tournament, round, parallel, player, position ) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European PG Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )), + 1, + 0, + ( SELECT player FROM players WHERE nick='Nameless' ), + 35); +INSERT INTO roundparticipation ( tournament, round, parallel, player, position ) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European PG Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )), + 5, + 0, + ( SELECT player FROM players WHERE nick='Bonzo' ), + 9); +INSERT INTO roundparticipation ( tournament, round, parallel, player, position ) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European PG Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )), + 4, + 0, + ( SELECT player FROM players WHERE nick='Bonzo' ), + 2); +INSERT INTO roundparticipation ( tournament, round, parallel, player, position ) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European PG Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )), + 3, + 3, + ( SELECT player FROM players WHERE nick='Bonzo' ), + 3); +INSERT INTO roundparticipation ( tournament, round, parallel, player, position ) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European PG Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )), + 2, + 4, + ( SELECT player FROM players WHERE nick='Bonzo' ), + 5); +INSERT INTO roundparticipation ( tournament, round, parallel, player, position ) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European PG Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )), + 1, + 0, + ( SELECT player FROM players WHERE nick='Bonzo' ), + 6); +INSERT INTO roundparticipation ( tournament, round, parallel, player, position ) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European PG Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )), + 2, + 1, + ( SELECT player FROM players WHERE nick='Eruanna' ), + 2); +INSERT INTO roundparticipation ( tournament, round, parallel, player, position ) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European PG Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )), + 1, + 0, + ( SELECT player FROM players WHERE nick='Eruanna' ), + 17); +INSERT INTO roundparticipation ( tournament, round, parallel, player, position ) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European PG Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )), + 4, + 0, + ( SELECT player FROM players WHERE nick='Gogo' ), + 3); +INSERT INTO roundparticipation ( tournament, round, parallel, player, position ) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European PG Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )), + 3, + 2, + ( SELECT player FROM players WHERE nick='Gogo' ), + 3); +INSERT INTO roundparticipation ( tournament, round, parallel, player, position ) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European PG Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )), + 2, + 12, + ( SELECT player FROM players WHERE nick='Gogo' ), + 4); +INSERT INTO roundparticipation ( tournament, round, parallel, player, position ) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European PG Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )), + 1, + 0, + ( SELECT player FROM players WHERE nick='Gogo' ), + 19); +INSERT INTO roundparticipation ( tournament, round, parallel, player, position ) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European PG Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )), + 2, + 6, + ( SELECT player FROM players WHERE nick='Mync' ), + 2); +INSERT INTO roundparticipation ( tournament, round, parallel, player, position ) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European PG Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )), + 1, + 0, + ( SELECT player FROM players WHERE nick='Mync' ), + 34); +INSERT INTO roundparticipation ( tournament, round, parallel, player, position ) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European PG Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )), + 2, + 12, + ( SELECT player FROM players WHERE nick='Hyper' ), + 1); +INSERT INTO roundparticipation ( tournament, round, parallel, player, position ) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European PG Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )), + 1, + 0, + ( SELECT player FROM players WHERE nick='Hyper' ), + 21); +INSERT INTO roundparticipation ( tournament, round, parallel, player, position ) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European PG Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )), + 4, + 0, + ( SELECT player FROM players WHERE nick='Cuivien' ), + 4); +INSERT INTO roundparticipation ( tournament, round, parallel, player, position ) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European PG Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )), + 3, + 4, + ( SELECT player FROM players WHERE nick='Cuivien' ), + 1); +INSERT INTO roundparticipation ( tournament, round, parallel, player, position ) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European PG Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )), + 2, + 9, + ( SELECT player FROM players WHERE nick='Cuivien' ), + 4); +INSERT INTO roundparticipation ( tournament, round, parallel, player, position ) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European PG Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )), + 1, + 0, + ( SELECT player FROM players WHERE nick='Cuivien' ), + 9); +INSERT INTO roundparticipation ( tournament, round, parallel, player, position ) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European PG Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )), + 2, + 7, + ( SELECT player FROM players WHERE nick='Felz' ), + 2); +INSERT INTO roundparticipation ( tournament, round, parallel, player, position ) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European PG Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )), + 1, + 0, + ( SELECT player FROM players WHERE nick='Felz' ), + 18); +INSERT INTO roundparticipation ( tournament, round, parallel, player, position ) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European PG Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )), + 2, + 4, + ( SELECT player FROM players WHERE nick='Cehtna' ), + 4); +INSERT INTO roundparticipation ( tournament, round, parallel, player, position ) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European PG Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )), + 1, + 0, + ( SELECT player FROM players WHERE nick='Cehtna' ), + 8); +INSERT INTO roundparticipation ( tournament, round, parallel, player, position ) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European PG Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )), + 3, + 3, + ( SELECT player FROM players WHERE nick='Andeplane' ), + 2); +INSERT INTO roundparticipation ( tournament, round, parallel, player, position ) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European PG Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )), + 2, + 3, + ( SELECT player FROM players WHERE nick='Andeplane' ), + 3); +INSERT INTO roundparticipation ( tournament, round, parallel, player, position ) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European PG Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )), + 1, + 0, + ( SELECT player FROM players WHERE nick='Andeplane' ), + 4); +INSERT INTO roundparticipation ( tournament, round, parallel, player, position ) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European PG Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )), + 2, + 5, + ( SELECT player FROM players WHERE nick='Ngan' ), + 1); +INSERT INTO roundparticipation ( tournament, round, parallel, player, position ) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European PG Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )), + 1, + 0, + ( SELECT player FROM players WHERE nick='Ngan' ), + 36); +INSERT INTO roundparticipation ( tournament, round, parallel, player, position ) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European PG Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )), + 2, + 6, + ( SELECT player FROM players WHERE nick='Maxion' ), + 1); +INSERT INTO roundparticipation ( tournament, round, parallel, player, position ) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European PG Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )), + 1, + 0, + ( SELECT player FROM players WHERE nick='Maxion' ), + 32); +INSERT INTO roundparticipation ( tournament, round, parallel, player, position ) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European PG Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )), + 2, + 6, + ( SELECT player FROM players WHERE nick='Electron' ), + 4); +INSERT INTO roundparticipation ( tournament, round, parallel, player, position ) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European PG Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )), + 1, + 0, + ( SELECT player FROM players WHERE nick='Electron' ), + 14); +INSERT INTO roundparticipation ( tournament, round, parallel, player, position ) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European PG Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )), + 3, + 1, + ( SELECT player FROM players WHERE nick='Pyro' ), + 2); +INSERT INTO roundparticipation ( tournament, round, parallel, player, position ) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European PG Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )), + 2, + 2, + ( SELECT player FROM players WHERE nick='Pyro' ), + 3); +INSERT INTO roundparticipation ( tournament, round, parallel, player, position ) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European PG Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )), + 1, + 0, + ( SELECT player FROM players WHERE nick='Pyro' ), + 41); +INSERT INTO roundparticipation ( tournament, round, parallel, player, position ) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European PG Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )), + 2, + 3, + ( SELECT player FROM players WHERE nick='JonAnders' ), + 1); +INSERT INTO roundparticipation ( tournament, round, parallel, player, position ) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European PG Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )), + 1, + 0, + ( SELECT player FROM players WHERE nick='JonAnders' ), + 24); +INSERT INTO roundparticipation ( tournament, round, parallel, player, position ) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European PG Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )), + 2, + 7, + ( SELECT player FROM players WHERE nick='uSimen' ), + 1); +INSERT INTO roundparticipation ( tournament, round, parallel, player, position ) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European PG Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )), + 1, + 0, + ( SELECT player FROM players WHERE nick='uSimen' ), + 54); +INSERT INTO roundparticipation ( tournament, round, parallel, player, position ) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European PG Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )), + 2, + 9, + ( SELECT player FROM players WHERE nick='Zredna' ), + 2); +INSERT INTO roundparticipation ( tournament, round, parallel, player, position ) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European PG Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )), + 1, + 0, + ( SELECT player FROM players WHERE nick='Zredna' ), + 57); +INSERT INTO roundparticipation ( tournament, round, parallel, player, position ) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European PG Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )), + 3, + 5, + ( SELECT player FROM players WHERE nick='Nuust' ), + 1); +INSERT INTO roundparticipation ( tournament, round, parallel, player, position ) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European PG Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )), + 2, + 4, + ( SELECT player FROM players WHERE nick='Nuust' ), + 3); +INSERT INTO roundparticipation ( tournament, round, parallel, player, position ) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European PG Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )), + 1, + 0, + ( SELECT player FROM players WHERE nick='Nuust' ), + 37); +INSERT INTO roundparticipation ( tournament, round, parallel, player, position ) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European PG Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )), + 2, + 8, + ( SELECT player FROM players WHERE nick='Sesse' ), + 4); +INSERT INTO roundparticipation ( tournament, round, parallel, player, position ) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European PG Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )), + 1, + 0, + ( SELECT player FROM players WHERE nick='Sesse' ), + 44); +INSERT INTO roundparticipation ( tournament, round, parallel, player, position ) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European PG Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )), + 2, + 1, + ( SELECT player FROM players WHERE nick='Oliyzia' ), + 3); +INSERT INTO roundparticipation ( tournament, round, parallel, player, position ) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European PG Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )), + 1, + 0, + ( SELECT player FROM players WHERE nick='Oliyzia' ), + 40); +INSERT INTO roundparticipation ( tournament, round, parallel, player, position ) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European PG Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )), + 3, + 6, + ( SELECT player FROM players WHERE nick='Lord Glenn' ), + 3); +INSERT INTO roundparticipation ( tournament, round, parallel, player, position ) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European PG Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )), + 2, + 3, + ( SELECT player FROM players WHERE nick='Lord Glenn' ), + 5); +INSERT INTO roundparticipation ( tournament, round, parallel, player, position ) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European PG Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )), + 1, + 0, + ( SELECT player FROM players WHERE nick='Lord Glenn' ), + 31); +INSERT INTO roundparticipation ( tournament, round, parallel, player, position ) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European PG Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )), + 2, + 3, + ( SELECT player FROM players WHERE nick='Bazze' ), + 2); +INSERT INTO roundparticipation ( tournament, round, parallel, player, position ) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European PG Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )), + 1, + 0, + ( SELECT player FROM players WHERE nick='Bazze' ), + 5); +INSERT INTO roundparticipation ( tournament, round, parallel, player, position ) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European PG Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )), + 2, + 8, + ( SELECT player FROM players WHERE nick='Kenny' ), + 2); +INSERT INTO roundparticipation ( tournament, round, parallel, player, position ) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European PG Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )), + 1, + 0, + ( SELECT player FROM players WHERE nick='Kenny' ), + 30); +INSERT INTO roundparticipation ( tournament, round, parallel, player, position ) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European PG Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )), + 2, + 4, + ( SELECT player FROM players WHERE nick='Camry' ), + 1); +INSERT INTO roundparticipation ( tournament, round, parallel, player, position ) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European PG Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )), + 1, + 0, + ( SELECT player FROM players WHERE nick='Camry' ), + 7); +INSERT INTO roundparticipation ( tournament, round, parallel, player, position ) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European PG Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )), + 2, + 9, + ( SELECT player FROM players WHERE nick='Infernuz' ), + 1); +INSERT INTO roundparticipation ( tournament, round, parallel, player, position ) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European PG Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )), + 1, + 0, + ( SELECT player FROM players WHERE nick='Infernuz' ), + 22); +INSERT INTO roundparticipation ( tournament, round, parallel, player, position ) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European PG Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )), + 3, + 1, + ( SELECT player FROM players WHERE nick='Al' ), + 1); +INSERT INTO roundparticipation ( tournament, round, parallel, player, position ) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European PG Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )), + 2, + 5, + ( SELECT player FROM players WHERE nick='Al' ), + 2); +INSERT INTO roundparticipation ( tournament, round, parallel, player, position ) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European PG Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )), + 1, + 0, + ( SELECT player FROM players WHERE nick='Al' ), + 2); +INSERT INTO roundparticipation ( tournament, round, parallel, player, position ) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European PG Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )), + 2, + 8, + ( SELECT player FROM players WHERE nick='Yukinon' ), + 1); +INSERT INTO roundparticipation ( tournament, round, parallel, player, position ) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European PG Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )), + 1, + 0, + ( SELECT player FROM players WHERE nick='Yukinon' ), + 56); +INSERT INTO roundparticipation ( tournament, round, parallel, player, position ) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European PG Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )), + 2, + 9, + ( SELECT player FROM players WHERE nick='Kabbefett' ), + 3); +INSERT INTO roundparticipation ( tournament, round, parallel, player, position ) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European PG Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )), + 1, + 0, + ( SELECT player FROM players WHERE nick='Kabbefett' ), + 27); +INSERT INTO roundparticipation ( tournament, round, parallel, player, position ) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European PG Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )), + 10, + 0, + ( SELECT player FROM players WHERE nick='Kasu' ), + 1); +INSERT INTO roundparticipation ( tournament, round, parallel, player, position ) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European PG Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )), + 9, + 0, + ( SELECT player FROM players WHERE nick='Kasu' ), + 2); +INSERT INTO roundparticipation ( tournament, round, parallel, player, position ) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European PG Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )), + 8, + 0, + ( SELECT player FROM players WHERE nick='Kasu' ), + 3); +INSERT INTO roundparticipation ( tournament, round, parallel, player, position ) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European PG Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )), + 7, + 0, + ( SELECT player FROM players WHERE nick='Kasu' ), + 1); +INSERT INTO roundparticipation ( tournament, round, parallel, player, position ) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European PG Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )), + 6, + 0, + ( SELECT player FROM players WHERE nick='Kasu' ), + 5); +INSERT INTO roundparticipation ( tournament, round, parallel, player, position ) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European PG Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )), + 5, + 0, + ( SELECT player FROM players WHERE nick='Kasu' ), + 6); +INSERT INTO roundparticipation ( tournament, round, parallel, player, position ) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European PG Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )), + 4, + 0, + ( SELECT player FROM players WHERE nick='Kasu' ), + 11); +INSERT INTO roundparticipation ( tournament, round, parallel, player, position ) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European PG Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )), + 3, + 5, + ( SELECT player FROM players WHERE nick='Kasu' ), + 4); +INSERT INTO roundparticipation ( tournament, round, parallel, player, position ) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European PG Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )), + 2, + 10, + ( SELECT player FROM players WHERE nick='Kasu' ), + 4); +INSERT INTO roundparticipation ( tournament, round, parallel, player, position ) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European PG Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )), + 1, + 0, + ( SELECT player FROM players WHERE nick='Kasu' ), + 28); +INSERT INTO roundparticipation ( tournament, round, parallel, player, position ) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European PG Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )), + 6, + 0, + ( SELECT player FROM players WHERE nick='Drummer' ), + 4); +INSERT INTO roundparticipation ( tournament, round, parallel, player, position ) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European PG Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )), + 5, + 0, + ( SELECT player FROM players WHERE nick='Drummer' ), + 8); +INSERT INTO roundparticipation ( tournament, round, parallel, player, position ) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European PG Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )), + 4, + 0, + ( SELECT player FROM players WHERE nick='Drummer' ), + 10); +INSERT INTO roundparticipation ( tournament, round, parallel, player, position ) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European PG Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )), + 3, + 2, + ( SELECT player FROM players WHERE nick='Drummer' ), + 4); +INSERT INTO roundparticipation ( tournament, round, parallel, player, position ) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European PG Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )), + 2, + 2, + ( SELECT player FROM players WHERE nick='Drummer' ), + 5); +INSERT INTO roundparticipation ( tournament, round, parallel, player, position ) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European PG Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )), + 1, + 0, + ( SELECT player FROM players WHERE nick='Drummer' ), + 11); +INSERT INTO roundparticipation ( tournament, round, parallel, player, position ) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European PG Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )), + 2, + 7, + ( SELECT player FROM players WHERE nick='Kasuya' ), + 3); +INSERT INTO roundparticipation ( tournament, round, parallel, player, position ) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European PG Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )), + 1, + 0, + ( SELECT player FROM players WHERE nick='Kasuya' ), + 29); +INSERT INTO roundparticipation ( tournament, round, parallel, player, position ) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European PG Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )), + 10, + 0, + ( SELECT player FROM players WHERE nick='K-Dogg' ), + 2); +INSERT INTO roundparticipation ( tournament, round, parallel, player, position ) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European PG Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )), + 9, + 0, + ( SELECT player FROM players WHERE nick='K-Dogg' ), + 3); +INSERT INTO roundparticipation ( tournament, round, parallel, player, position ) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European PG Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )), + 8, + 0, + ( SELECT player FROM players WHERE nick='K-Dogg' ), + 4); +INSERT INTO roundparticipation ( tournament, round, parallel, player, position ) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European PG Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )), + 7, + 0, + ( SELECT player FROM players WHERE nick='K-Dogg' ), + 5); +INSERT INTO roundparticipation ( tournament, round, parallel, player, position ) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European PG Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )), + 6, + 0, + ( SELECT player FROM players WHERE nick='K-Dogg' ), + 6); +INSERT INTO roundparticipation ( tournament, round, parallel, player, position ) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European PG Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )), + 5, + 0, + ( SELECT player FROM players WHERE nick='K-Dogg' ), + 7); +INSERT INTO roundparticipation ( tournament, round, parallel, player, position ) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European PG Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )), + 4, + 0, + ( SELECT player FROM players WHERE nick='K-Dogg' ), + 12); +INSERT INTO roundparticipation ( tournament, round, parallel, player, position ) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European PG Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )), + 3, + 3, + ( SELECT player FROM players WHERE nick='K-Dogg' ), + 4); +INSERT INTO roundparticipation ( tournament, round, parallel, player, position ) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European PG Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )), + 2, + 1, + ( SELECT player FROM players WHERE nick='K-Dogg' ), + 5); +INSERT INTO roundparticipation ( tournament, round, parallel, player, position ) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European PG Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )), + 1, + 0, + ( SELECT player FROM players WHERE nick='K-Dogg' ), + 26); +INSERT INTO roundparticipation ( tournament, round, parallel, player, position ) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European PG Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )), + 2, + 2, + ( SELECT player FROM players WHERE nick='Amegon' ), + 1); +INSERT INTO roundparticipation ( tournament, round, parallel, player, position ) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European PG Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )), + 1, + 0, + ( SELECT player FROM players WHERE nick='Amegon' ), + 3); +INSERT INTO roundparticipation ( tournament, round, parallel, player, position ) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European PG Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )), + 2, + 10, + ( SELECT player FROM players WHERE nick='Ai' ), + 1); +INSERT INTO roundparticipation ( tournament, round, parallel, player, position ) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European PG Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )), + 1, + 0, + ( SELECT player FROM players WHERE nick='Ai' ), + 1); +INSERT INTO roundparticipation ( tournament, round, parallel, player, position ) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European PG Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )), + 4, + 0, + ( SELECT player FROM players WHERE nick='Eric' ), + 5); +INSERT INTO roundparticipation ( tournament, round, parallel, player, position ) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European PG Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )), + 3, + 6, + ( SELECT player FROM players WHERE nick='Eric' ), + 2); +INSERT INTO roundparticipation ( tournament, round, parallel, player, position ) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European PG Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )), + 2, + 7, + ( SELECT player FROM players WHERE nick='Eric' ), + 5); +INSERT INTO roundparticipation ( tournament, round, parallel, player, position ) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European PG Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )), + 1, + 0, + ( SELECT player FROM players WHERE nick='Eric' ), + 16); +INSERT INTO roundparticipation ( tournament, round, parallel, player, position ) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European PG Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )), + 3, + 4, + ( SELECT player FROM players WHERE nick='Jka' ), + 3); +INSERT INTO roundparticipation ( tournament, round, parallel, player, position ) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European PG Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )), + 2, + 7, + ( SELECT player FROM players WHERE nick='Jka' ), + 4); +INSERT INTO roundparticipation ( tournament, round, parallel, player, position ) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European PG Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )), + 1, + 0, + ( SELECT player FROM players WHERE nick='Jka' ), + 23); +INSERT INTO roundparticipation ( tournament, round, parallel, player, position ) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European PG Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )), + 2, + 1, + ( SELECT player FROM players WHERE nick='Ryouko' ), + 1); +INSERT INTO roundparticipation ( tournament, round, parallel, player, position ) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European PG Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )), + 1, + 0, + ( SELECT player FROM players WHERE nick='Ryouko' ), + 43); +INSERT INTO roundparticipation ( tournament, round, parallel, player, position ) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European PG Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )), + 2, + 2, + ( SELECT player FROM players WHERE nick='Tsung' ), + 2); +INSERT INTO roundparticipation ( tournament, round, parallel, player, position ) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European PG Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )), + 1, + 0, + ( SELECT player FROM players WHERE nick='Tsung' ), + 52); +INSERT INTO roundparticipation ( tournament, round, parallel, player, position ) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European PG Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )), + 3, + 2, + ( SELECT player FROM players WHERE nick='Skazi' ), + 2); +INSERT INTO roundparticipation ( tournament, round, parallel, player, position ) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European PG Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )), + 2, + 11, + ( SELECT player FROM players WHERE nick='Skazi' ), + 3); +INSERT INTO roundparticipation ( tournament, round, parallel, player, position ) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European PG Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )), + 1, + 0, + ( SELECT player FROM players WHERE nick='Skazi' ), + 45); +INSERT INTO roundparticipation ( tournament, round, parallel, player, position ) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European PG Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )), + 2, + 11, + ( SELECT player FROM players WHERE nick='Jukeboksi' ), + 2); +INSERT INTO roundparticipation ( tournament, round, parallel, player, position ) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European PG Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )), + 1, + 0, + ( SELECT player FROM players WHERE nick='Jukeboksi' ), + 25); +INSERT INTO roundparticipation ( tournament, round, parallel, player, position ) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European PG Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )), + 9, + 0, + ( SELECT player FROM players WHERE nick='Stelisevil' ), + 1); +INSERT INTO roundparticipation ( tournament, round, parallel, player, position ) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European PG Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )), + 8, + 0, + ( SELECT player FROM players WHERE nick='Stelisevil' ), + 2); +INSERT INTO roundparticipation ( tournament, round, parallel, player, position ) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European PG Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )), + 7, + 0, + ( SELECT player FROM players WHERE nick='Stelisevil' ), + 2); +INSERT INTO roundparticipation ( tournament, round, parallel, player, position ) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European PG Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )), + 6, + 0, + ( SELECT player FROM players WHERE nick='Stelisevil' ), + 3); +INSERT INTO roundparticipation ( tournament, round, parallel, player, position ) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European PG Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )), + 5, + 0, + ( SELECT player FROM players WHERE nick='Stelisevil' ), + 2); +INSERT INTO roundparticipation ( tournament, round, parallel, player, position ) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European PG Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )), + 4, + 0, + ( SELECT player FROM players WHERE nick='Stelisevil' ), + 1); +INSERT INTO roundparticipation ( tournament, round, parallel, player, position ) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European PG Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )), + 3, + 1, + ( SELECT player FROM players WHERE nick='Stelisevil' ), + 3); +INSERT INTO roundparticipation ( tournament, round, parallel, player, position ) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European PG Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )), + 2, + 5, + ( SELECT player FROM players WHERE nick='Stelisevil' ), + 5); +INSERT INTO roundparticipation ( tournament, round, parallel, player, position ) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European PG Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )), + 1, + 0, + ( SELECT player FROM players WHERE nick='Stelisevil' ), + 49); +INSERT INTO roundparticipation ( tournament, round, parallel, player, position ) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European PG Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )), + 3, + 3, + ( SELECT player FROM players WHERE nick='Elias' ), + 1); +INSERT INTO roundparticipation ( tournament, round, parallel, player, position ) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European PG Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )), + 2, + 1, + ( SELECT player FROM players WHERE nick='Elias' ), + 4); +INSERT INTO roundparticipation ( tournament, round, parallel, player, position ) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European PG Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )), + 1, + 0, + ( SELECT player FROM players WHERE nick='Elias' ), + 15); +INSERT INTO roundparticipation ( tournament, round, parallel, player, position ) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European PG Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )), + 3, + 6, + ( SELECT player FROM players WHERE nick='Milk' ), + 1); +INSERT INTO roundparticipation ( tournament, round, parallel, player, position ) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European PG Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )), + 2, + 6, + ( SELECT player FROM players WHERE nick='Milk' ), + 3); +INSERT INTO roundparticipation ( tournament, round, parallel, player, position ) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European PG Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )), + 1, + 0, + ( SELECT player FROM players WHERE nick='Milk' ), + 33); +INSERT INTO roundparticipation ( tournament, round, parallel, player, position ) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European PG Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )), + 7, + 0, + ( SELECT player FROM players WHERE nick='T_Bone_X_Zeo' ), + 3); +INSERT INTO roundparticipation ( tournament, round, parallel, player, position ) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European PG Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )), + 6, + 0, + ( SELECT player FROM players WHERE nick='T_Bone_X_Zeo' ), + 1); +INSERT INTO roundparticipation ( tournament, round, parallel, player, position ) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European PG Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )), + 5, + 0, + ( SELECT player FROM players WHERE nick='T_Bone_X_Zeo' ), + 1); +INSERT INTO roundparticipation ( tournament, round, parallel, player, position ) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European PG Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )), + 4, + 0, + ( SELECT player FROM players WHERE nick='T_Bone_X_Zeo' ), + 9); +INSERT INTO roundparticipation ( tournament, round, parallel, player, position ) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European PG Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )), + 3, + 6, + ( SELECT player FROM players WHERE nick='T_Bone_X_Zeo' ), + 4); +INSERT INTO roundparticipation ( tournament, round, parallel, player, position ) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European PG Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )), + 2, + 6, + ( SELECT player FROM players WHERE nick='T_Bone_X_Zeo' ), + 5); +INSERT INTO roundparticipation ( tournament, round, parallel, player, position ) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European PG Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )), + 1, + 0, + ( SELECT player FROM players WHERE nick='T_Bone_X_Zeo' ), + 51); +INSERT INTO roundparticipation ( tournament, round, parallel, player, position ) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European PG Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )), + 3, + 2, + ( SELECT player FROM players WHERE nick='Smooth' ), + 1); +INSERT INTO roundparticipation ( tournament, round, parallel, player, position ) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European PG Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )), + 2, + 12, + ( SELECT player FROM players WHERE nick='Smooth' ), + 3); +INSERT INTO roundparticipation ( tournament, round, parallel, player, position ) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European PG Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )), + 1, + 0, + ( SELECT player FROM players WHERE nick='Smooth' ), + 47); +INSERT INTO roundparticipation ( tournament, round, parallel, player, position ) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European PG Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )), + 2, + 10, + ( SELECT player FROM players WHERE nick='stuf' ), + 2); +INSERT INTO roundparticipation ( tournament, round, parallel, player, position ) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European PG Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )), + 1, + 0, + ( SELECT player FROM players WHERE nick='stuf' ), + 50); +INSERT INTO scores ( tournament, round, parallel, player, songnumber, song, playmode, difficulty, chosen, score ) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European PG Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )), + 5, + 0, + ( SELECT player FROM players WHERE nick='Snute' ), + 2, + ( SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)') ), + 'single', + 'expert', + 't', + 8964); +INSERT INTO scores ( tournament, round, parallel, player, songnumber, song, playmode, difficulty, chosen, score ) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European PG Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )), + 3, + 4, + ( SELECT player FROM players WHERE nick='Snute' ), + 3, + ( SELECT song FROM songs WHERE lower(title)=lower('Dead End') ), + 'single', + 'expert', + 't', + 8763); +INSERT INTO scores ( tournament, round, parallel, player, songnumber, song, playmode, difficulty, chosen, score ) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European PG Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )), + 2, + 8, + ( SELECT player FROM players WHERE nick='Snute' ), + 3, + ( SELECT song FROM songs WHERE lower(title)=lower('Dynamite Rave') ), + 'single', + 'expert', + 't', + 8853); +INSERT INTO scores ( tournament, round, parallel, player, songnumber, song, playmode, difficulty, chosen, score ) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European PG Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )), + 2, + 8, + ( SELECT player FROM players WHERE nick='Snute' ), + 2, + ( SELECT song FROM songs WHERE lower(title)=lower('Make A Jam!') ), + 'single', + 'expert', + 'f', + 6709); +INSERT INTO scores ( tournament, round, parallel, player, songnumber, song, playmode, difficulty, chosen, score ) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European PG Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )), + 8, + 0, + ( SELECT player FROM players WHERE nick='Snute' ), + 1, + ( SELECT song FROM songs WHERE lower(title)=lower('Make A Jam!') ), + 'single', + 'expert', + 'f', + 6943); +INSERT INTO scores ( tournament, round, parallel, player, songnumber, song, playmode, difficulty, chosen, score ) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European PG Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )), + 6, + 0, + ( SELECT player FROM players WHERE nick='Snute' ), + 1, + ( SELECT song FROM songs WHERE lower(title)=lower('Healing Vision (Angelic Mix)') ), + 'single', + 'expert', + 'f', + 8847); +INSERT INTO scores ( tournament, round, parallel, player, songnumber, song, playmode, difficulty, chosen, score ) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European PG Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )), + 6, + 0, + ( SELECT player FROM players WHERE nick='Snute' ), + 2, + ( SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)') ), + 'single', + 'expert', + 't', + 8859); +INSERT INTO scores ( tournament, round, parallel, player, songnumber, song, playmode, difficulty, chosen, score ) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European PG Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )), + 4, + 0, + ( SELECT player FROM players WHERE nick='Snute' ), + 2, + ( SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love (SPEED MIX)') ), + 'single', + 'expert', + 't', + 8855); +INSERT INTO scores ( tournament, round, parallel, player, songnumber, song, playmode, difficulty, chosen, score ) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European PG Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )), + 7, + 0, + ( SELECT player FROM players WHERE nick='Snute' ), + 2, + ( SELECT song FROM songs WHERE lower(title)=lower('Exotic Ethnic') ), + 'single', + 'expert', + 't', + 8802); +INSERT INTO scores ( tournament, round, parallel, player, songnumber, song, playmode, difficulty, chosen, score ) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European PG Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )), + 2, + 8, + ( SELECT player FROM players WHERE nick='Snute' ), + 1, + ( SELECT song FROM songs WHERE lower(title)=lower('Crash!') ), + 'single', + 'expert', + 'f', + 8910); +INSERT INTO scores ( tournament, round, parallel, player, songnumber, song, playmode, difficulty, chosen, score ) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European PG Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )), + 8, + 0, + ( SELECT player FROM players WHERE nick='Snute' ), + 2, + ( SELECT song FROM songs WHERE lower(title)=lower('Crash!') ), + 'single', + 'expert', + 't', + 8879); +INSERT INTO scores ( tournament, round, parallel, player, songnumber, song, playmode, difficulty, chosen, score ) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European PG Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )), + 1, + 0, + ( SELECT player FROM players WHERE nick='Snute' ), + 1, + ( SELECT song FROM songs WHERE lower(title)=lower('era (nostalmix)') ), + 'single', + 'expert', + 'f', + 7679); +INSERT INTO scores ( tournament, round, parallel, player, songnumber, song, playmode, difficulty, chosen, score ) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European PG Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )), + 3, + 4, + ( SELECT player FROM players WHERE nick='Snute' ), + 2, + ( SELECT song FROM songs WHERE lower(title)=lower('My Summer Love') ), + 'single', + 'expert', + 'f', + 8691); +INSERT INTO scores ( tournament, round, parallel, player, songnumber, song, playmode, difficulty, chosen, score ) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European PG Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )), + 4, + 0, + ( SELECT player FROM players WHERE nick='Snute' ), + 1, + ( SELECT song FROM songs WHERE lower(title)=lower('Remember You') ), + 'single', + 'expert', + 'f', + 4726); +INSERT INTO scores ( tournament, round, parallel, player, songnumber, song, playmode, difficulty, chosen, score ) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European PG Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )), + 5, + 0, + ( SELECT player FROM players WHERE nick='Snute' ), + 1, + ( SELECT song FROM songs WHERE lower(title)=lower('Nori Nori Nori') ), + 'single', + 'expert', + 'f', + 6698); +INSERT INTO scores ( tournament, round, parallel, player, songnumber, song, playmode, difficulty, chosen, score ) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European PG Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )), + 7, + 0, + ( SELECT player FROM players WHERE nick='Snute' ), + 1, + ( SELECT song FROM songs WHERE lower(title)=lower('The Centre of the Heart (Stonebridge Club Mix)') ), + 'single', + 'expert', + 'f', + 6904); +INSERT INTO scores ( tournament, round, parallel, player, songnumber, song, playmode, difficulty, chosen, score ) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European PG Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )), + 3, + 4, + ( SELECT player FROM players WHERE nick='Snute' ), + 1, + ( SELECT song FROM songs WHERE lower(title)=lower('I Want You to Want Me') ), + 'single', + 'expert', + 'f', + 5694); +INSERT INTO scores ( tournament, round, parallel, player, songnumber, song, playmode, difficulty, chosen, score ) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European PG Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )), + 2, + 11, + ( SELECT player FROM players WHERE nick='DufF' ), + 2, + ( SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)') ), + 'single', + 'expert', + 'f', + 8646); +INSERT INTO scores ( tournament, round, parallel, player, songnumber, song, playmode, difficulty, chosen, score ) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European PG Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )), + 2, + 11, + ( SELECT player FROM players WHERE nick='DufF' ), + 1, + ( SELECT song FROM songs WHERE lower(title)=lower('20th November') ), + 'single', + 'expert', + 'f', + 6788); +INSERT INTO scores ( tournament, round, parallel, player, songnumber, song, playmode, difficulty, chosen, score ) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European PG Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )), + 2, + 11, + ( SELECT player FROM players WHERE nick='DufF' ), + 3, + ( SELECT song FROM songs WHERE lower(title)=lower('Max 300') ), + 'single', + 'expert', + 't', + 8796); +INSERT INTO scores ( tournament, round, parallel, player, songnumber, song, playmode, difficulty, chosen, score ) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European PG Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )), + 1, + 0, + ( SELECT player FROM players WHERE nick='DufF' ), + 1, + ( SELECT song FROM songs WHERE lower(title)=lower('era (nostalmix)') ), + 'single', + 'expert', + 'f', + 7047); +INSERT INTO scores ( tournament, round, parallel, player, songnumber, song, playmode, difficulty, chosen, score ) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European PG Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )), + 5, + 0, + ( SELECT player FROM players WHERE nick='OJK' ), + 2, + ( SELECT song FROM songs WHERE lower(title)=lower('PARANOiA Rebirth') ), + 'single', + 'expert', + 't', + 8647); +INSERT INTO scores ( tournament, round, parallel, player, songnumber, song, playmode, difficulty, chosen, score ) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European PG Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )), + 4, + 0, + ( SELECT player FROM players WHERE nick='OJK' ), + 2, + ( SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)') ), + 'single', + 'expert', + 't', + 8914); +INSERT INTO scores ( tournament, round, parallel, player, songnumber, song, playmode, difficulty, chosen, score ) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European PG Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )), + 2, + 10, + ( SELECT player FROM players WHERE nick='OJK' ), + 3, + ( SELECT song FROM songs WHERE lower(title)=lower('Dead End') ), + 'single', + 'expert', + 't', + 8824); +INSERT INTO scores ( tournament, round, parallel, player, songnumber, song, playmode, difficulty, chosen, score ) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European PG Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )), + 3, + 5, + ( SELECT player FROM players WHERE nick='OJK' ), + 1, + ( SELECT song FROM songs WHERE lower(title)=lower('Dead End') ), + 'single', + 'expert', + 'f', + 8778); +INSERT INTO scores ( tournament, round, parallel, player, songnumber, song, playmode, difficulty, chosen, score ) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European PG Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )), + 3, + 5, + ( SELECT player FROM players WHERE nick='OJK' ), + 2, + ( SELECT song FROM songs WHERE lower(title)=lower('Dynamite Rave') ), + 'single', + 'expert', + 'f', + 8516); +INSERT INTO scores ( tournament, round, parallel, player, songnumber, song, playmode, difficulty, chosen, score ) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European PG Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )), + 3, + 5, + ( SELECT player FROM players WHERE nick='OJK' ), + 3, + ( SELECT song FROM songs WHERE lower(title)=lower('Max 300') ), + 'single', + 'expert', + 't', + 9259); +INSERT INTO scores ( tournament, round, parallel, player, songnumber, song, playmode, difficulty, chosen, score ) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European PG Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )), + 1, + 0, + ( SELECT player FROM players WHERE nick='OJK' ), + 1, + ( SELECT song FROM songs WHERE lower(title)=lower('era (nostalmix)') ), + 'single', + 'expert', + 'f', + 7592); +INSERT INTO scores ( tournament, round, parallel, player, songnumber, song, playmode, difficulty, chosen, score ) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European PG Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )), + 2, + 10, + ( SELECT player FROM players WHERE nick='OJK' ), + 1, + ( SELECT song FROM songs WHERE lower(title)=lower('D2R') ), + 'single', + 'expert', + 'f', + 6490); +INSERT INTO scores ( tournament, round, parallel, player, songnumber, song, playmode, difficulty, chosen, score ) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European PG Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )), + 2, + 10, + ( SELECT player FROM players WHERE nick='OJK' ), + 2, + ( SELECT song FROM songs WHERE lower(title)=lower('Spin the Disc') ), + 'single', + 'expert', + 'f', + 7601); +INSERT INTO scores ( tournament, round, parallel, player, songnumber, song, playmode, difficulty, chosen, score ) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European PG Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )), + 4, + 0, + ( SELECT player FROM players WHERE nick='OJK' ), + 1, + ( SELECT song FROM songs WHERE lower(title)=lower('Remember You') ), + 'single', + 'expert', + 'f', + 4712); +INSERT INTO scores ( tournament, round, parallel, player, songnumber, song, playmode, difficulty, chosen, score ) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European PG Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )), + 5, + 0, + ( SELECT player FROM players WHERE nick='OJK' ), + 1, + ( SELECT song FROM songs WHERE lower(title)=lower('Nori Nori Nori') ), + 'single', + 'expert', + 'f', + 6778); +INSERT INTO scores ( tournament, round, parallel, player, songnumber, song, playmode, difficulty, chosen, score ) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European PG Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )), + 2, + 9, + ( SELECT player FROM players WHERE nick='RiChY' ), + 3, + ( SELECT song FROM songs WHERE lower(title)=lower('Dead End') ), + 'single', + 'expert', + 't', + 8645); +INSERT INTO scores ( tournament, round, parallel, player, songnumber, song, playmode, difficulty, chosen, score ) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European PG Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )), + 3, + 5, + ( SELECT player FROM players WHERE nick='RiChY' ), + 1, + ( SELECT song FROM songs WHERE lower(title)=lower('Dead End') ), + 'single', + 'expert', + 'f', + 8505); +INSERT INTO scores ( tournament, round, parallel, player, songnumber, song, playmode, difficulty, chosen, score ) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European PG Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )), + 3, + 5, + ( SELECT player FROM players WHERE nick='RiChY' ), + 2, + ( SELECT song FROM songs WHERE lower(title)=lower('Dynamite Rave') ), + 'single', + 'expert', + 'f', + 8731); +INSERT INTO scores ( tournament, round, parallel, player, songnumber, song, playmode, difficulty, chosen, score ) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European PG Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )), + 3, + 5, + ( SELECT player FROM players WHERE nick='RiChY' ), + 3, + ( SELECT song FROM songs WHERE lower(title)=lower('Max 300') ), + 'single', + 'expert', + 't', + 9076); +INSERT INTO scores ( tournament, round, parallel, player, songnumber, song, playmode, difficulty, chosen, score ) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European PG Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )), + 2, + 9, + ( SELECT player FROM players WHERE nick='RiChY' ), + 2, + ( SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love (SPEED MIX)') ), + 'single', + 'expert', + 'f', + 8716); +INSERT INTO scores ( tournament, round, parallel, player, songnumber, song, playmode, difficulty, chosen, score ) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European PG Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )), + 1, + 0, + ( SELECT player FROM players WHERE nick='RiChY' ), + 1, + ( SELECT song FROM songs WHERE lower(title)=lower('era (nostalmix)') ), + 'single', + 'expert', + 'f', + 7670); +INSERT INTO scores ( tournament, round, parallel, player, songnumber, song, playmode, difficulty, chosen, score ) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European PG Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )), + 2, + 9, + ( SELECT player FROM players WHERE nick='RiChY' ), + 1, + ( SELECT song FROM songs WHERE lower(title)=lower('Remember You') ), + 'single', + 'expert', + 'f', + 4647); +INSERT INTO scores ( tournament, round, parallel, player, songnumber, song, playmode, difficulty, chosen, score ) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European PG Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )), + 5, + 0, + ( SELECT player FROM players WHERE nick='Haggar' ), + 2, + ( SELECT song FROM songs WHERE lower(title)=lower('PARANOiA Rebirth') ), + 'single', + 'expert', + 't', + 8914); +INSERT INTO scores ( tournament, round, parallel, player, songnumber, song, playmode, difficulty, chosen, score ) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European PG Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )), + 2, + 11, + ( SELECT player FROM players WHERE nick='Haggar' ), + 2, + ( SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)') ), + 'single', + 'expert', + 'f', + 8781); +INSERT INTO scores ( tournament, round, parallel, player, songnumber, song, playmode, difficulty, chosen, score ) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European PG Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )), + 6, + 0, + ( SELECT player FROM players WHERE nick='Haggar' ), + 2, + ( SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)') ), + 'single', + 'expert', + 't', + 8930); +INSERT INTO scores ( tournament, round, parallel, player, songnumber, song, playmode, difficulty, chosen, score ) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European PG Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )), + 3, + 1, + ( SELECT player FROM players WHERE nick='Haggar' ), + 2, + ( SELECT song FROM songs WHERE lower(title)=lower('Love This Feelin\'') ), + 'single', + 'expert', + 'f', + 7847); +INSERT INTO scores ( tournament, round, parallel, player, songnumber, song, playmode, difficulty, chosen, score ) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European PG Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )), + 3, + 1, + ( SELECT player FROM players WHERE nick='Haggar' ), + 1, + ( SELECT song FROM songs WHERE lower(title)=lower('Luv to Me (AMD Mix)') ), + 'single', + 'expert', + 'f', + 7469); +INSERT INTO scores ( tournament, round, parallel, player, songnumber, song, playmode, difficulty, chosen, score ) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European PG Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )), + 2, + 11, + ( SELECT player FROM players WHERE nick='Haggar' ), + 1, + ( SELECT song FROM songs WHERE lower(title)=lower('20th November') ), + 'single', + 'expert', + 'f', + 6710); +INSERT INTO scores ( tournament, round, parallel, player, songnumber, song, playmode, difficulty, chosen, score ) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European PG Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )), + 2, + 11, + ( SELECT player FROM players WHERE nick='Haggar' ), + 3, + ( SELECT song FROM songs WHERE lower(title)=lower('Max 300') ), + 'single', + 'expert', + 't', + 9513); +INSERT INTO scores ( tournament, round, parallel, player, songnumber, song, playmode, difficulty, chosen, score ) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European PG Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )), + 6, + 0, + ( SELECT player FROM players WHERE nick='Haggar' ), + 1, + ( SELECT song FROM songs WHERE lower(title)=lower('Healing Vision (Angelic Mix)') ), + 'single', + 'expert', + 'f', + 8392); +INSERT INTO scores ( tournament, round, parallel, player, songnumber, song, playmode, difficulty, chosen, score ) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European PG Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )), + 3, + 1, + ( SELECT player FROM players WHERE nick='Haggar' ), + 3, + ( SELECT song FROM songs WHERE lower(title)=lower('Tsugaru') ), + 'single', + 'expert', + 't', + 8640); +INSERT INTO scores ( tournament, round, parallel, player, songnumber, song, playmode, difficulty, chosen, score ) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European PG Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )), + 4, + 0, + ( SELECT player FROM players WHERE nick='Haggar' ), + 2, + ( SELECT song FROM songs WHERE lower(title)=lower('Exotic Ethnic') ), + 'single', + 'expert', + 't', + 8890); +INSERT INTO scores ( tournament, round, parallel, player, songnumber, song, playmode, difficulty, chosen, score ) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European PG Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )), + 1, + 0, + ( SELECT player FROM players WHERE nick='Haggar' ), + 1, + ( SELECT song FROM songs WHERE lower(title)=lower('era (nostalmix)') ), + 'single', + 'expert', + 'f', + 7659); +INSERT INTO scores ( tournament, round, parallel, player, songnumber, song, playmode, difficulty, chosen, score ) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European PG Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )), + 4, + 0, + ( SELECT player FROM players WHERE nick='Haggar' ), + 1, + ( SELECT song FROM songs WHERE lower(title)=lower('Remember You') ), + 'single', + 'expert', + 'f', + 4835); +INSERT INTO scores ( tournament, round, parallel, player, songnumber, song, playmode, difficulty, chosen, score ) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European PG Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )), + 5, + 0, + ( SELECT player FROM players WHERE nick='Haggar' ), + 1, + ( SELECT song FROM songs WHERE lower(title)=lower('Nori Nori Nori') ), + 'single', + 'expert', + 'f', + 6930); +INSERT INTO scores ( tournament, round, parallel, player, songnumber, song, playmode, difficulty, chosen, score ) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European PG Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )), + 2, + 3, + ( SELECT player FROM players WHERE nick='Daniil' ), + 2, + ( SELECT song FROM songs WHERE lower(title)=lower('Afronova Primeval') ), + 'single', + 'expert', + 'f', + 7600); +INSERT INTO scores ( tournament, round, parallel, player, songnumber, song, playmode, difficulty, chosen, score ) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European PG Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )), + 2, + 3, + ( SELECT player FROM players WHERE nick='Daniil' ), + 3, + ( SELECT song FROM songs WHERE lower(title)=lower('Crash!') ), + 'single', + 'expert', + 't', + 8333); +INSERT INTO scores ( tournament, round, parallel, player, songnumber, song, playmode, difficulty, chosen, score ) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European PG Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )), + 1, + 0, + ( SELECT player FROM players WHERE nick='Daniil' ), + 1, + ( SELECT song FROM songs WHERE lower(title)=lower('era (nostalmix)') ), + 'single', + 'expert', + 'f', + 7470); +INSERT INTO scores ( tournament, round, parallel, player, songnumber, song, playmode, difficulty, chosen, score ) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European PG Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )), + 2, + 3, + ( SELECT player FROM players WHERE nick='Daniil' ), + 1, + ( SELECT song FROM songs WHERE lower(title)=lower('Rain of Sorrow') ), + 'single', + 'expert', + 'f', + 7359); +INSERT INTO scores ( tournament, round, parallel, player, songnumber, song, playmode, difficulty, chosen, score ) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European PG Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )), + 2, + 12, + ( SELECT player FROM players WHERE nick='T|na' ), + 3, + ( SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)') ), + 'single', + 'expert', + 't', + 8614); +INSERT INTO scores ( tournament, round, parallel, player, songnumber, song, playmode, difficulty, chosen, score ) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European PG Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )), + 1, + 0, + ( SELECT player FROM players WHERE nick='T|na' ), + 1, + ( SELECT song FROM songs WHERE lower(title)=lower('era (nostalmix)') ), + 'single', + 'expert', + 'f', + 7114); +INSERT INTO scores ( tournament, round, parallel, player, songnumber, song, playmode, difficulty, chosen, score ) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European PG Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )), + 2, + 12, + ( SELECT player FROM players WHERE nick='T|na' ), + 1, + ( SELECT song FROM songs WHERE lower(title)=lower('Groove 2001') ), + 'single', + 'expert', + 'f', + 6298); +INSERT INTO scores ( tournament, round, parallel, player, songnumber, song, playmode, difficulty, chosen, score ) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European PG Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )), + 2, + 12, + ( SELECT player FROM players WHERE nick='T|na' ), + 2, + ( SELECT song FROM songs WHERE lower(title)=lower('Never Ending Story') ), + 'single', + 'expert', + 'f', + 6028); +INSERT INTO scores ( tournament, round, parallel, player, songnumber, song, playmode, difficulty, chosen, score ) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European PG Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )), + 2, + 4, + ( SELECT player FROM players WHERE nick='Smiph' ), + 2, + ( SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)') ), + 'single', + 'expert', + 'f', + 8318); +INSERT INTO scores ( tournament, round, parallel, player, songnumber, song, playmode, difficulty, chosen, score ) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European PG Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )), + 2, + 4, + ( SELECT player FROM players WHERE nick='Smiph' ), + 3, + ( SELECT song FROM songs WHERE lower(title)=lower('Crash!') ), + 'single', + 'expert', + 't', + 8459); +INSERT INTO scores ( tournament, round, parallel, player, songnumber, song, playmode, difficulty, chosen, score ) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European PG Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )), + 1, + 0, + ( SELECT player FROM players WHERE nick='Smiph' ), + 1, + ( SELECT song FROM songs WHERE lower(title)=lower('era (nostalmix)') ), + 'single', + 'expert', + 'f', + 6540); +INSERT INTO scores ( tournament, round, parallel, player, songnumber, song, playmode, difficulty, chosen, score ) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European PG Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )), + 2, + 4, + ( SELECT player FROM players WHERE nick='Smiph' ), + 1, + ( SELECT song FROM songs WHERE lower(title)=lower('Don\'t Try to Stop It') ), + 'single', + 'expert', + 'f', + 6832); +INSERT INTO scores ( tournament, round, parallel, player, songnumber, song, playmode, difficulty, chosen, score ) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European PG Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )), + 2, + 5, + ( SELECT player FROM players WHERE nick='Olemann' ), + 3, + ( SELECT song FROM songs WHERE lower(title)=lower('Exotic Ethnic') ), + 'single', + 'expert', + 't', + 8307); +INSERT INTO scores ( tournament, round, parallel, player, songnumber, song, playmode, difficulty, chosen, score ) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European PG Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )), + 1, + 0, + ( SELECT player FROM players WHERE nick='Olemann' ), + 1, + ( SELECT song FROM songs WHERE lower(title)=lower('era (nostalmix)') ), + 'single', + 'expert', + 'f', + 7261); +INSERT INTO scores ( tournament, round, parallel, player, songnumber, song, playmode, difficulty, chosen, score ) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European PG Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )), + 2, + 5, + ( SELECT player FROM players WHERE nick='Olemann' ), + 1, + ( SELECT song FROM songs WHERE lower(title)=lower('The Reflex') ), + 'single', + 'expert', + 'f', + 6414); +INSERT INTO scores ( tournament, round, parallel, player, songnumber, song, playmode, difficulty, chosen, score ) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European PG Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )), + 2, + 5, + ( SELECT player FROM players WHERE nick='Olemann' ), + 2, + ( SELECT song FROM songs WHERE lower(title)=lower('The Centre of the Heart (Stonebridge Club Mix)') ), + 'single', + 'expert', + 'f', + 6301); +INSERT INTO scores ( tournament, round, parallel, player, songnumber, song, playmode, difficulty, chosen, score ) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European PG Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )), + 2, + 8, + ( SELECT player FROM players WHERE nick='Duckling' ), + 3, + ( SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)') ), + 'single', + 'expert', + 't', + 8853); +INSERT INTO scores ( tournament, round, parallel, player, songnumber, song, playmode, difficulty, chosen, score ) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European PG Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )), + 2, + 8, + ( SELECT player FROM players WHERE nick='Duckling' ), + 2, + ( SELECT song FROM songs WHERE lower(title)=lower('Make A Jam!') ), + 'single', + 'expert', + 'f', + 6665); +INSERT INTO scores ( tournament, round, parallel, player, songnumber, song, playmode, difficulty, chosen, score ) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European PG Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )), + 3, + 4, + ( SELECT player FROM players WHERE nick='Duckling' ), + 3, + ( SELECT song FROM songs WHERE lower(title)=lower('Max 300') ), + 'single', + 'expert', + 't', + 8180); +INSERT INTO scores ( tournament, round, parallel, player, songnumber, song, playmode, difficulty, chosen, score ) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European PG Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )), + 2, + 8, + ( SELECT player FROM players WHERE nick='Duckling' ), + 1, + ( SELECT song FROM songs WHERE lower(title)=lower('Crash!') ), + 'single', + 'expert', + 'f', + 8610); +INSERT INTO scores ( tournament, round, parallel, player, songnumber, song, playmode, difficulty, chosen, score ) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European PG Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )), + 1, + 0, + ( SELECT player FROM players WHERE nick='Duckling' ), + 1, + ( SELECT song FROM songs WHERE lower(title)=lower('era (nostalmix)') ), + 'single', + 'expert', + 'f', + 7177); +INSERT INTO scores ( tournament, round, parallel, player, songnumber, song, playmode, difficulty, chosen, score ) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European PG Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )), + 3, + 4, + ( SELECT player FROM players WHERE nick='Duckling' ), + 2, + ( SELECT song FROM songs WHERE lower(title)=lower('My Summer Love') ), + 'single', + 'expert', + 'f', + 8171); +INSERT INTO scores ( tournament, round, parallel, player, songnumber, song, playmode, difficulty, chosen, score ) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European PG Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )), + 3, + 4, + ( SELECT player FROM players WHERE nick='Duckling' ), + 1, + ( SELECT song FROM songs WHERE lower(title)=lower('I Want You to Want Me') ), + 'single', + 'expert', + 'f', + 5027); +INSERT INTO scores ( tournament, round, parallel, player, songnumber, song, playmode, difficulty, chosen, score ) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European PG Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )), + 2, + 5, + ( SELECT player FROM players WHERE nick='Ylini' ), + 3, + ( SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)') ), + 'single', + 'expert', + 't', + 8524); +INSERT INTO scores ( tournament, round, parallel, player, songnumber, song, playmode, difficulty, chosen, score ) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European PG Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )), + 1, + 0, + ( SELECT player FROM players WHERE nick='Ylini' ), + 1, + ( SELECT song FROM songs WHERE lower(title)=lower('era (nostalmix)') ), + 'single', + 'expert', + 'f', + 7507); +INSERT INTO scores ( tournament, round, parallel, player, songnumber, song, playmode, difficulty, chosen, score ) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European PG Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )), + 2, + 5, + ( SELECT player FROM players WHERE nick='Ylini' ), + 1, + ( SELECT song FROM songs WHERE lower(title)=lower('The Reflex') ), + 'single', + 'expert', + 'f', + 6747); +INSERT INTO scores ( tournament, round, parallel, player, songnumber, song, playmode, difficulty, chosen, score ) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European PG Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )), + 2, + 5, + ( SELECT player FROM players WHERE nick='Ylini' ), + 2, + ( SELECT song FROM songs WHERE lower(title)=lower('The Centre of the Heart (Stonebridge Club Mix)') ), + 'single', + 'expert', + 'f', + 6089); +INSERT INTO scores ( tournament, round, parallel, player, songnumber, song, playmode, difficulty, chosen, score ) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European PG Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )), + 2, + 2, + ( SELECT player FROM players WHERE nick='Nameless' ), + 2, + ( SELECT song FROM songs WHERE lower(title)=lower('Afronova') ), + 'single', + 'expert', + 'f', + 8542); +INSERT INTO scores ( tournament, round, parallel, player, songnumber, song, playmode, difficulty, chosen, score ) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European PG Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )), + 2, + 2, + ( SELECT player FROM players WHERE nick='Nameless' ), + 3, + ( SELECT song FROM songs WHERE lower(title)=lower('Max 300') ), + 'single', + 'expert', + 't', + 8850); +INSERT INTO scores ( tournament, round, parallel, player, songnumber, song, playmode, difficulty, chosen, score ) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European PG Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )), + 1, + 0, + ( SELECT player FROM players WHERE nick='Nameless' ), + 1, + ( SELECT song FROM songs WHERE lower(title)=lower('era (nostalmix)') ), + 'single', + 'expert', + 'f', + 7419); +INSERT INTO scores ( tournament, round, parallel, player, songnumber, song, playmode, difficulty, chosen, score ) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European PG Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )), + 2, + 2, + ( SELECT player FROM players WHERE nick='Nameless' ), + 1, + ( SELECT song FROM songs WHERE lower(title)=lower('Love You Like A Fool') ), + 'single', + 'expert', + 'f', + 6532); +INSERT INTO scores ( tournament, round, parallel, player, songnumber, song, playmode, difficulty, chosen, score ) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European PG Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )), + 3, + 3, + ( SELECT player FROM players WHERE nick='Bonzo' ), + 3, + ( SELECT song FROM songs WHERE lower(title)=lower('Dead End') ), + 'single', + 'expert', + 't', + 8535); +INSERT INTO scores ( tournament, round, parallel, player, songnumber, song, playmode, difficulty, chosen, score ) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European PG Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )), + 4, + 0, + ( SELECT player FROM players WHERE nick='Bonzo' ), + 2, + ( SELECT song FROM songs WHERE lower(title)=lower('Max 300') ), + 'single', + 'expert', + 't', + 9269); +INSERT INTO scores ( tournament, round, parallel, player, songnumber, song, playmode, difficulty, chosen, score ) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European PG Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )), + 2, + 4, + ( SELECT player FROM players WHERE nick='Bonzo' ), + 2, + ( SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)') ), + 'single', + 'expert', + 'f', + 8647); +INSERT INTO scores ( tournament, round, parallel, player, songnumber, song, playmode, difficulty, chosen, score ) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European PG Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )), + 5, + 0, + ( SELECT player FROM players WHERE nick='Bonzo' ), + 2, + ( SELECT song FROM songs WHERE lower(title)=lower('Crash!') ), + 'single', + 'expert', + 't', + 8780); +INSERT INTO scores ( tournament, round, parallel, player, songnumber, song, playmode, difficulty, chosen, score ) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European PG Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )), + 1, + 0, + ( SELECT player FROM players WHERE nick='Bonzo' ), + 1, + ( SELECT song FROM songs WHERE lower(title)=lower('era (nostalmix)') ), + 'single', + 'expert', + 'f', + 7774); +INSERT INTO scores ( tournament, round, parallel, player, songnumber, song, playmode, difficulty, chosen, score ) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European PG Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )), + 3, + 3, + ( SELECT player FROM players WHERE nick='Bonzo' ), + 1, + ( SELECT song FROM songs WHERE lower(title)=lower('B4U') ), + 'single', + 'expert', + 'f', + 7475); +INSERT INTO scores ( tournament, round, parallel, player, songnumber, song, playmode, difficulty, chosen, score ) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European PG Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )), + 4, + 0, + ( SELECT player FROM players WHERE nick='Bonzo' ), + 1, + ( SELECT song FROM songs WHERE lower(title)=lower('Remember You') ), + 'single', + 'expert', + 'f', + 4621); +INSERT INTO scores ( tournament, round, parallel, player, songnumber, song, playmode, difficulty, chosen, score ) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European PG Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )), + 2, + 4, + ( SELECT player FROM players WHERE nick='Bonzo' ), + 3, + ( SELECT song FROM songs WHERE lower(title)=lower('So Deep (Perfect Sphere Mix)') ), + 'single', + 'expert', + 't', + 8512); +INSERT INTO scores ( tournament, round, parallel, player, songnumber, song, playmode, difficulty, chosen, score ) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European PG Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )), + 2, + 4, + ( SELECT player FROM players WHERE nick='Bonzo' ), + 1, + ( SELECT song FROM songs WHERE lower(title)=lower('Don\'t Try to Stop It') ), + 'single', + 'expert', + 'f', + 7134); +INSERT INTO scores ( tournament, round, parallel, player, songnumber, song, playmode, difficulty, chosen, score ) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European PG Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )), + 5, + 0, + ( SELECT player FROM players WHERE nick='Bonzo' ), + 1, + ( SELECT song FROM songs WHERE lower(title)=lower('Nori Nori Nori') ), + 'single', + 'expert', + 'f', + 6730); +INSERT INTO scores ( tournament, round, parallel, player, songnumber, song, playmode, difficulty, chosen, score ) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European PG Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )), + 3, + 3, + ( SELECT player FROM players WHERE nick='Bonzo' ), + 2, + ( SELECT song FROM songs WHERE lower(title)=lower('Caribbean Queen') ), + 'single', + 'expert', + 'f', + 6543); +INSERT INTO scores ( tournament, round, parallel, player, songnumber, song, playmode, difficulty, chosen, score ) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European PG Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )), + 2, + 1, + ( SELECT player FROM players WHERE nick='Eruanna' ), + 3, + ( SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)') ), + 'single', + 'expert', + 't', + 7854); +INSERT INTO scores ( tournament, round, parallel, player, songnumber, song, playmode, difficulty, chosen, score ) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European PG Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )), + 2, + 1, + ( SELECT player FROM players WHERE nick='Eruanna' ), + 2, + ( SELECT song FROM songs WHERE lower(title)=lower('Dynamite Rave') ), + 'single', + 'expert', + 'f', + 6951); +INSERT INTO scores ( tournament, round, parallel, player, songnumber, song, playmode, difficulty, chosen, score ) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European PG Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )), + 1, + 0, + ( SELECT player FROM players WHERE nick='Eruanna' ), + 1, + ( SELECT song FROM songs WHERE lower(title)=lower('era (nostalmix)') ), + 'single', + 'expert', + 'f', + 6358); +INSERT INTO scores ( tournament, round, parallel, player, songnumber, song, playmode, difficulty, chosen, score ) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European PG Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )), + 2, + 1, + ( SELECT player FROM players WHERE nick='Eruanna' ), + 1, + ( SELECT song FROM songs WHERE lower(title)=lower('Let the Beat Hit \'em!') ), + 'single', + 'expert', + 'f', + 5641); +INSERT INTO scores ( tournament, round, parallel, player, songnumber, song, playmode, difficulty, chosen, score ) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European PG Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )), + 2, + 12, + ( SELECT player FROM players WHERE nick='Gogo' ), + 3, + ( SELECT song FROM songs WHERE lower(title)=lower('Afronova') ), + 'single', + 'expert', + 't', + 8340); +INSERT INTO scores ( tournament, round, parallel, player, songnumber, song, playmode, difficulty, chosen, score ) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European PG Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )), + 4, + 0, + ( SELECT player FROM players WHERE nick='Gogo' ), + 2, + ( SELECT song FROM songs WHERE lower(title)=lower('Max 300') ), + 'single', + 'expert', + 't', + 8575); +INSERT INTO scores ( tournament, round, parallel, player, songnumber, song, playmode, difficulty, chosen, score ) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European PG Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )), + 1, + 0, + ( SELECT player FROM players WHERE nick='Gogo' ), + 1, + ( SELECT song FROM songs WHERE lower(title)=lower('era (nostalmix)') ), + 'single', + 'expert', + 'f', + 7650); +INSERT INTO scores ( tournament, round, parallel, player, songnumber, song, playmode, difficulty, chosen, score ) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European PG Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )), + 2, + 12, + ( SELECT player FROM players WHERE nick='Gogo' ), + 1, + ( SELECT song FROM songs WHERE lower(title)=lower('Groove 2001') ), + 'single', + 'expert', + 'f', + 6926); +INSERT INTO scores ( tournament, round, parallel, player, songnumber, song, playmode, difficulty, chosen, score ) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European PG Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )), + 3, + 2, + ( SELECT player FROM players WHERE nick='Gogo' ), + 1, + ( SELECT song FROM songs WHERE lower(title)=lower('Spin the Disc') ), + 'single', + 'expert', + 'f', + 7953); +INSERT INTO scores ( tournament, round, parallel, player, songnumber, song, playmode, difficulty, chosen, score ) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European PG Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )), + 4, + 0, + ( SELECT player FROM players WHERE nick='Gogo' ), + 1, + ( SELECT song FROM songs WHERE lower(title)=lower('Remember You') ), + 'single', + 'expert', + 'f', + 4685); +INSERT INTO scores ( tournament, round, parallel, player, songnumber, song, playmode, difficulty, chosen, score ) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European PG Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )), + 3, + 2, + ( SELECT player FROM players WHERE nick='Gogo' ), + 3, + ( SELECT song FROM songs WHERE lower(title)=lower('So Deep (Perfect Sphere Mix)') ), + 'single', + 'expert', + 't', + 8751); +INSERT INTO scores ( tournament, round, parallel, player, songnumber, song, playmode, difficulty, chosen, score ) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European PG Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )), + 2, + 12, + ( SELECT player FROM players WHERE nick='Gogo' ), + 2, + ( SELECT song FROM songs WHERE lower(title)=lower('Never Ending Story') ), + 'single', + 'expert', + 'f', + 6547); +INSERT INTO scores ( tournament, round, parallel, player, songnumber, song, playmode, difficulty, chosen, score ) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European PG Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )), + 3, + 2, + ( SELECT player FROM players WHERE nick='Gogo' ), + 2, + ( SELECT song FROM songs WHERE lower(title)=lower('That was Then, This is Now') ), + 'single', + 'expert', + 'f', + 5654); +INSERT INTO scores ( tournament, round, parallel, player, songnumber, song, playmode, difficulty, chosen, score ) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European PG Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )), + 2, + 6, + ( SELECT player FROM players WHERE nick='Mync' ), + 1, + ( SELECT song FROM songs WHERE lower(title)=lower('Let Them Move') ), + 'single', + 'expert', + 'f', + 5590); +INSERT INTO scores ( tournament, round, parallel, player, songnumber, song, playmode, difficulty, chosen, score ) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European PG Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )), + 2, + 6, + ( SELECT player FROM players WHERE nick='Mync' ), + 3, + ( SELECT song FROM songs WHERE lower(title)=lower('Exotic Ethnic') ), + 'single', + 'expert', + 't', + 0); +INSERT INTO scores ( tournament, round, parallel, player, songnumber, song, playmode, difficulty, chosen, score ) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European PG Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )), + 1, + 0, + ( SELECT player FROM players WHERE nick='Mync' ), + 1, + ( SELECT song FROM songs WHERE lower(title)=lower('era (nostalmix)') ), + 'single', + 'expert', + 'f', + 6734); +INSERT INTO scores ( tournament, round, parallel, player, songnumber, song, playmode, difficulty, chosen, score ) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European PG Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )), + 2, + 6, + ( SELECT player FROM players WHERE nick='Mync' ), + 2, + ( SELECT song FROM songs WHERE lower(title)=lower('Look to the Sky') ), + 'single', + 'expert', + 'f', + 5709); +INSERT INTO scores ( tournament, round, parallel, player, songnumber, song, playmode, difficulty, chosen, score ) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European PG Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )), + 2, + 12, + ( SELECT player FROM players WHERE nick='Hyper' ), + 3, + ( SELECT song FROM songs WHERE lower(title)=lower('Crash!') ), + 'single', + 'expert', + 't', + 8391); +INSERT INTO scores ( tournament, round, parallel, player, songnumber, song, playmode, difficulty, chosen, score ) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European PG Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )), + 1, + 0, + ( SELECT player FROM players WHERE nick='Hyper' ), + 1, + ( SELECT song FROM songs WHERE lower(title)=lower('era (nostalmix)') ), + 'single', + 'expert', + 'f', + 7091); +INSERT INTO scores ( tournament, round, parallel, player, songnumber, song, playmode, difficulty, chosen, score ) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European PG Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )), + 2, + 12, + ( SELECT player FROM players WHERE nick='Hyper' ), + 1, + ( SELECT song FROM songs WHERE lower(title)=lower('Groove 2001') ), + 'single', + 'expert', + 'f', + 6204); +INSERT INTO scores ( tournament, round, parallel, player, songnumber, song, playmode, difficulty, chosen, score ) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European PG Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )), + 2, + 12, + ( SELECT player FROM players WHERE nick='Hyper' ), + 2, + ( SELECT song FROM songs WHERE lower(title)=lower('Never Ending Story') ), + 'single', + 'expert', + 'f', + 5783); +INSERT INTO scores ( tournament, round, parallel, player, songnumber, song, playmode, difficulty, chosen, score ) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European PG Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )), + 3, + 4, + ( SELECT player FROM players WHERE nick='Cuivien' ), + 3, + ( SELECT song FROM songs WHERE lower(title)=lower('PARANOiA Rebirth') ), + 'single', + 'expert', + 't', + 8806); +INSERT INTO scores ( tournament, round, parallel, player, songnumber, song, playmode, difficulty, chosen, score ) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European PG Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )), + 2, + 9, + ( SELECT player FROM players WHERE nick='Cuivien' ), + 2, + ( SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love (SPEED MIX)') ), + 'single', + 'expert', + 'f', + 8569); +INSERT INTO scores ( tournament, round, parallel, player, songnumber, song, playmode, difficulty, chosen, score ) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European PG Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )), + 4, + 0, + ( SELECT player FROM players WHERE nick='Cuivien' ), + 2, + ( SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love (SPEED MIX)') ), + 'single', + 'expert', + 't', + 8518); +INSERT INTO scores ( tournament, round, parallel, player, songnumber, song, playmode, difficulty, chosen, score ) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European PG Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )), + 2, + 9, + ( SELECT player FROM players WHERE nick='Cuivien' ), + 3, + ( SELECT song FROM songs WHERE lower(title)=lower('Crash!') ), + 'single', + 'expert', + 't', + 8745); +INSERT INTO scores ( tournament, round, parallel, player, songnumber, song, playmode, difficulty, chosen, score ) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European PG Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )), + 1, + 0, + ( SELECT player FROM players WHERE nick='Cuivien' ), + 1, + ( SELECT song FROM songs WHERE lower(title)=lower('era (nostalmix)') ), + 'single', + 'expert', + 'f', + 7591); +INSERT INTO scores ( tournament, round, parallel, player, songnumber, song, playmode, difficulty, chosen, score ) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European PG Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )), + 3, + 4, + ( SELECT player FROM players WHERE nick='Cuivien' ), + 2, + ( SELECT song FROM songs WHERE lower(title)=lower('My Summer Love') ), + 'single', + 'expert', + 'f', + 8531); +INSERT INTO scores ( tournament, round, parallel, player, songnumber, song, playmode, difficulty, chosen, score ) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European PG Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )), + 2, + 9, + ( SELECT player FROM players WHERE nick='Cuivien' ), + 1, + ( SELECT song FROM songs WHERE lower(title)=lower('Remember You') ), + 'single', + 'expert', + 'f', + 4516); +INSERT INTO scores ( tournament, round, parallel, player, songnumber, song, playmode, difficulty, chosen, score ) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European PG Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )), + 4, + 0, + ( SELECT player FROM players WHERE nick='Cuivien' ), + 1, + ( SELECT song FROM songs WHERE lower(title)=lower('Remember You') ), + 'single', + 'expert', + 'f', + 4601); +INSERT INTO scores ( tournament, round, parallel, player, songnumber, song, playmode, difficulty, chosen, score ) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European PG Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )), + 3, + 4, + ( SELECT player FROM players WHERE nick='Cuivien' ), + 1, + ( SELECT song FROM songs WHERE lower(title)=lower('I Want You to Want Me') ), + 'single', + 'expert', + 'f', + 5458); +INSERT INTO scores ( tournament, round, parallel, player, songnumber, song, playmode, difficulty, chosen, score ) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European PG Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )), + 2, + 7, + ( SELECT player FROM players WHERE nick='Felz' ), + 3, + ( SELECT song FROM songs WHERE lower(title)=lower('Exotic Ethnic') ), + 'single', + 'expert', + 't', + 8156); +INSERT INTO scores ( tournament, round, parallel, player, songnumber, song, playmode, difficulty, chosen, score ) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European PG Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )), + 2, + 7, + ( SELECT player FROM players WHERE nick='Felz' ), + 1, + ( SELECT song FROM songs WHERE lower(title)=lower('Burnin\' the Floor') ), + 'single', + 'expert', + 'f', + 6392); +INSERT INTO scores ( tournament, round, parallel, player, songnumber, song, playmode, difficulty, chosen, score ) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European PG Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )), + 1, + 0, + ( SELECT player FROM players WHERE nick='Felz' ), + 1, + ( SELECT song FROM songs WHERE lower(title)=lower('era (nostalmix)') ), + 'single', + 'expert', + 'f', + 6755); +INSERT INTO scores ( tournament, round, parallel, player, songnumber, song, playmode, difficulty, chosen, score ) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European PG Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )), + 2, + 7, + ( SELECT player FROM players WHERE nick='Felz' ), + 2, + ( SELECT song FROM songs WHERE lower(title)=lower('Stomp') ), + 'single', + 'expert', + 'f', + 6090); +INSERT INTO scores ( tournament, round, parallel, player, songnumber, song, playmode, difficulty, chosen, score ) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European PG Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )), + 2, + 4, + ( SELECT player FROM players WHERE nick='Cehtna' ), + 3, + ( SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)') ), + 'single', + 'expert', + 't', + 8451); +INSERT INTO scores ( tournament, round, parallel, player, songnumber, song, playmode, difficulty, chosen, score ) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European PG Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )), + 2, + 4, + ( SELECT player FROM players WHERE nick='Cehtna' ), + 2, + ( SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)') ), + 'single', + 'expert', + 'f', + 8017); +INSERT INTO scores ( tournament, round, parallel, player, songnumber, song, playmode, difficulty, chosen, score ) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European PG Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )), + 1, + 0, + ( SELECT player FROM players WHERE nick='Cehtna' ), + 1, + ( SELECT song FROM songs WHERE lower(title)=lower('era (nostalmix)') ), + 'single', + 'expert', + 'f', + 7472); +INSERT INTO scores ( tournament, round, parallel, player, songnumber, song, playmode, difficulty, chosen, score ) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European PG Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )), + 2, + 4, + ( SELECT player FROM players WHERE nick='Cehtna' ), + 1, + ( SELECT song FROM songs WHERE lower(title)=lower('Don\'t Try to Stop It') ), + 'single', + 'expert', + 'f', + 6593); +INSERT INTO scores ( tournament, round, parallel, player, songnumber, song, playmode, difficulty, chosen, score ) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European PG Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )), + 2, + 3, + ( SELECT player FROM players WHERE nick='Andeplane' ), + 3, + ( SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)') ), + 'single', + 'expert', + 't', + 8876); +INSERT INTO scores ( tournament, round, parallel, player, songnumber, song, playmode, difficulty, chosen, score ) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European PG Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )), + 2, + 3, + ( SELECT player FROM players WHERE nick='Andeplane' ), + 2, + ( SELECT song FROM songs WHERE lower(title)=lower('Afronova Primeval') ), + 'single', + 'expert', + 'f', + 7496); +INSERT INTO scores ( tournament, round, parallel, player, songnumber, song, playmode, difficulty, chosen, score ) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European PG Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )), + 3, + 3, + ( SELECT player FROM players WHERE nick='Andeplane' ), + 3, + ( SELECT song FROM songs WHERE lower(title)=lower('Exotic Ethnic') ), + 'single', + 'expert', + 't', + 8667); +INSERT INTO scores ( tournament, round, parallel, player, songnumber, song, playmode, difficulty, chosen, score ) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European PG Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )), + 1, + 0, + ( SELECT player FROM players WHERE nick='Andeplane' ), + 1, + ( SELECT song FROM songs WHERE lower(title)=lower('era (nostalmix)') ), + 'single', + 'expert', + 'f', + 7355); +INSERT INTO scores ( tournament, round, parallel, player, songnumber, song, playmode, difficulty, chosen, score ) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European PG Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )), + 3, + 3, + ( SELECT player FROM players WHERE nick='Andeplane' ), + 1, + ( SELECT song FROM songs WHERE lower(title)=lower('B4U') ), + 'single', + 'expert', + 'f', + 7776); +INSERT INTO scores ( tournament, round, parallel, player, songnumber, song, playmode, difficulty, chosen, score ) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European PG Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )), + 2, + 3, + ( SELECT player FROM players WHERE nick='Andeplane' ), + 1, + ( SELECT song FROM songs WHERE lower(title)=lower('Rain of Sorrow') ), + 'single', + 'expert', + 'f', + 7869); +INSERT INTO scores ( tournament, round, parallel, player, songnumber, song, playmode, difficulty, chosen, score ) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European PG Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )), + 3, + 3, + ( SELECT player FROM players WHERE nick='Andeplane' ), + 2, + ( SELECT song FROM songs WHERE lower(title)=lower('Caribbean Queen') ), + 'single', + 'expert', + 'f', + 5987); +INSERT INTO scores ( tournament, round, parallel, player, songnumber, song, playmode, difficulty, chosen, score ) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European PG Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )), + 2, + 5, + ( SELECT player FROM players WHERE nick='Ngan' ), + 3, + ( SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)') ), + 'single', + 'expert', + 't', + 7823); +INSERT INTO scores ( tournament, round, parallel, player, songnumber, song, playmode, difficulty, chosen, score ) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European PG Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )), + 1, + 0, + ( SELECT player FROM players WHERE nick='Ngan' ), + 1, + ( SELECT song FROM songs WHERE lower(title)=lower('era (nostalmix)') ), + 'single', + 'expert', + 'f', + 5831); +INSERT INTO scores ( tournament, round, parallel, player, songnumber, song, playmode, difficulty, chosen, score ) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European PG Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )), + 2, + 5, + ( SELECT player FROM players WHERE nick='Ngan' ), + 1, + ( SELECT song FROM songs WHERE lower(title)=lower('The Reflex') ), + 'single', + 'expert', + 'f', + 5779); +INSERT INTO scores ( tournament, round, parallel, player, songnumber, song, playmode, difficulty, chosen, score ) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European PG Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )), + 2, + 5, + ( SELECT player FROM players WHERE nick='Ngan' ), + 2, + ( SELECT song FROM songs WHERE lower(title)=lower('The Centre of the Heart (Stonebridge Club Mix)') ), + 'single', + 'expert', + 'f', + 5800); +INSERT INTO scores ( tournament, round, parallel, player, songnumber, song, playmode, difficulty, chosen, score ) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European PG Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )), + 2, + 6, + ( SELECT player FROM players WHERE nick='Maxion' ), + 1, + ( SELECT song FROM songs WHERE lower(title)=lower('Let Them Move') ), + 'single', + 'expert', + 'f', + 5005); +INSERT INTO scores ( tournament, round, parallel, player, songnumber, song, playmode, difficulty, chosen, score ) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European PG Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )), + 1, + 0, + ( SELECT player FROM players WHERE nick='Maxion' ), + 1, + ( SELECT song FROM songs WHERE lower(title)=lower('era (nostalmix)') ), + 'single', + 'expert', + 'f', + 5674); +INSERT INTO scores ( tournament, round, parallel, player, songnumber, song, playmode, difficulty, chosen, score ) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European PG Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )), + 2, + 6, + ( SELECT player FROM players WHERE nick='Maxion' ), + 2, + ( SELECT song FROM songs WHERE lower(title)=lower('Look to the Sky') ), + 'single', + 'expert', + 'f', + 4491); +INSERT INTO scores ( tournament, round, parallel, player, songnumber, song, playmode, difficulty, chosen, score ) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European PG Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )), + 2, + 6, + ( SELECT player FROM players WHERE nick='Maxion' ), + 3, + ( SELECT song FROM songs WHERE lower(title)=lower('Spin the Disc') ), + 'single', + 'expert', + 't', + 6461); +INSERT INTO scores ( tournament, round, parallel, player, songnumber, song, playmode, difficulty, chosen, score ) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European PG Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )), + 2, + 6, + ( SELECT player FROM players WHERE nick='Electron' ), + 1, + ( SELECT song FROM songs WHERE lower(title)=lower('Let Them Move') ), + 'single', + 'expert', + 'f', + 6537); +INSERT INTO scores ( tournament, round, parallel, player, songnumber, song, playmode, difficulty, chosen, score ) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European PG Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )), + 2, + 6, + ( SELECT player FROM players WHERE nick='Electron' ), + 3, + ( SELECT song FROM songs WHERE lower(title)=lower('Max 300') ), + 'single', + 'expert', + 't', + 9179); +INSERT INTO scores ( tournament, round, parallel, player, songnumber, song, playmode, difficulty, chosen, score ) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European PG Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )), + 1, + 0, + ( SELECT player FROM players WHERE nick='Electron' ), + 1, + ( SELECT song FROM songs WHERE lower(title)=lower('era (nostalmix)') ), + 'single', + 'expert', + 'f', + 7519); +INSERT INTO scores ( tournament, round, parallel, player, songnumber, song, playmode, difficulty, chosen, score ) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European PG Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )), + 2, + 6, + ( SELECT player FROM players WHERE nick='Electron' ), + 2, + ( SELECT song FROM songs WHERE lower(title)=lower('Look to the Sky') ), + 'single', + 'expert', + 'f', + 6023); +INSERT INTO scores ( tournament, round, parallel, player, songnumber, song, playmode, difficulty, chosen, score ) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European PG Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )), + 2, + 2, + ( SELECT player FROM players WHERE nick='Pyro' ), + 2, + ( SELECT song FROM songs WHERE lower(title)=lower('Afronova') ), + 'single', + 'expert', + 'f', + 8613); +INSERT INTO scores ( tournament, round, parallel, player, songnumber, song, playmode, difficulty, chosen, score ) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European PG Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )), + 3, + 1, + ( SELECT player FROM players WHERE nick='Pyro' ), + 3, + ( SELECT song FROM songs WHERE lower(title)=lower('End of the Century') ), + 'single', + 'expert', + 't', + 8607); +INSERT INTO scores ( tournament, round, parallel, player, songnumber, song, playmode, difficulty, chosen, score ) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European PG Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )), + 3, + 1, + ( SELECT player FROM players WHERE nick='Pyro' ), + 2, + ( SELECT song FROM songs WHERE lower(title)=lower('Love This Feelin\'') ), + 'single', + 'expert', + 'f', + 6761); +INSERT INTO scores ( tournament, round, parallel, player, songnumber, song, playmode, difficulty, chosen, score ) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European PG Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )), + 3, + 1, + ( SELECT player FROM players WHERE nick='Pyro' ), + 1, + ( SELECT song FROM songs WHERE lower(title)=lower('Luv to Me (AMD Mix)') ), + 'single', + 'expert', + 'f', + 7354); +INSERT INTO scores ( tournament, round, parallel, player, songnumber, song, playmode, difficulty, chosen, score ) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European PG Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )), + 2, + 2, + ( SELECT player FROM players WHERE nick='Pyro' ), + 3, + ( SELECT song FROM songs WHERE lower(title)=lower('Max 300') ), + 'single', + 'expert', + 't', + 9021); +INSERT INTO scores ( tournament, round, parallel, player, songnumber, song, playmode, difficulty, chosen, score ) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European PG Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )), + 1, + 0, + ( SELECT player FROM players WHERE nick='Pyro' ), + 1, + ( SELECT song FROM songs WHERE lower(title)=lower('era (nostalmix)') ), + 'single', + 'expert', + 'f', + 7361); +INSERT INTO scores ( tournament, round, parallel, player, songnumber, song, playmode, difficulty, chosen, score ) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European PG Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )), + 2, + 2, + ( SELECT player FROM players WHERE nick='Pyro' ), + 1, + ( SELECT song FROM songs WHERE lower(title)=lower('Love You Like A Fool') ), + 'single', + 'expert', + 'f', + 6565); +INSERT INTO scores ( tournament, round, parallel, player, songnumber, song, playmode, difficulty, chosen, score ) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European PG Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )), + 2, + 3, + ( SELECT player FROM players WHERE nick='JonAnders' ), + 2, + ( SELECT song FROM songs WHERE lower(title)=lower('Afronova Primeval') ), + 'single', + 'expert', + 'f', + 6845); +INSERT INTO scores ( tournament, round, parallel, player, songnumber, song, playmode, difficulty, chosen, score ) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European PG Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )), + 2, + 3, + ( SELECT player FROM players WHERE nick='JonAnders' ), + 3, + ( SELECT song FROM songs WHERE lower(title)=lower('Crash!') ), + 'single', + 'expert', + 't', + 8109); +INSERT INTO scores ( tournament, round, parallel, player, songnumber, song, playmode, difficulty, chosen, score ) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European PG Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )), + 1, + 0, + ( SELECT player FROM players WHERE nick='JonAnders' ), + 1, + ( SELECT song FROM songs WHERE lower(title)=lower('era (nostalmix)') ), + 'single', + 'expert', + 'f', + 6036); +INSERT INTO scores ( tournament, round, parallel, player, songnumber, song, playmode, difficulty, chosen, score ) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European PG Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )), + 2, + 3, + ( SELECT player FROM players WHERE nick='JonAnders' ), + 1, + ( SELECT song FROM songs WHERE lower(title)=lower('Rain of Sorrow') ), + 'single', + 'expert', + 'f', + 6599); +INSERT INTO scores ( tournament, round, parallel, player, songnumber, song, playmode, difficulty, chosen, score ) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European PG Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )), + 2, + 7, + ( SELECT player FROM players WHERE nick='uSimen' ), + 3, + ( SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)') ), + 'single', + 'expert', + 't', + 8081); +INSERT INTO scores ( tournament, round, parallel, player, songnumber, song, playmode, difficulty, chosen, score ) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European PG Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )), + 2, + 7, + ( SELECT player FROM players WHERE nick='uSimen' ), + 1, + ( SELECT song FROM songs WHERE lower(title)=lower('Burnin\' the Floor') ), + 'single', + 'expert', + 'f', + 6091); +INSERT INTO scores ( tournament, round, parallel, player, songnumber, song, playmode, difficulty, chosen, score ) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European PG Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )), + 1, + 0, + ( SELECT player FROM players WHERE nick='uSimen' ), + 1, + ( SELECT song FROM songs WHERE lower(title)=lower('era (nostalmix)') ), + 'single', + 'expert', + 'f', + 5130); +INSERT INTO scores ( tournament, round, parallel, player, songnumber, song, playmode, difficulty, chosen, score ) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European PG Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )), + 2, + 7, + ( SELECT player FROM players WHERE nick='uSimen' ), + 2, + ( SELECT song FROM songs WHERE lower(title)=lower('Stomp') ), + 'single', + 'expert', + 'f', + 5166); +INSERT INTO scores ( tournament, round, parallel, player, songnumber, song, playmode, difficulty, chosen, score ) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European PG Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )), + 2, + 9, + ( SELECT player FROM players WHERE nick='Zredna' ), + 2, + ( SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love (SPEED MIX)') ), + 'single', + 'expert', + 'f', + 8250); +INSERT INTO scores ( tournament, round, parallel, player, songnumber, song, playmode, difficulty, chosen, score ) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European PG Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )), + 2, + 9, + ( SELECT player FROM players WHERE nick='Zredna' ), + 3, + ( SELECT song FROM songs WHERE lower(title)=lower('Crash!') ), + 'single', + 'expert', + 't', + 8667); +INSERT INTO scores ( tournament, round, parallel, player, songnumber, song, playmode, difficulty, chosen, score ) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European PG Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )), + 1, + 0, + ( SELECT player FROM players WHERE nick='Zredna' ), + 1, + ( SELECT song FROM songs WHERE lower(title)=lower('era (nostalmix)') ), + 'single', + 'expert', + 'f', + 6908); +INSERT INTO scores ( tournament, round, parallel, player, songnumber, song, playmode, difficulty, chosen, score ) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European PG Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )), + 2, + 9, + ( SELECT player FROM players WHERE nick='Zredna' ), + 1, + ( SELECT song FROM songs WHERE lower(title)=lower('Remember You') ), + 'single', + 'expert', + 'f', + 4680); +INSERT INTO scores ( tournament, round, parallel, player, songnumber, song, playmode, difficulty, chosen, score ) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European PG Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )), + 3, + 5, + ( SELECT player FROM players WHERE nick='Nuust' ), + 1, + ( SELECT song FROM songs WHERE lower(title)=lower('Dead End') ), + 'single', + 'expert', + 'f', + 8346); +INSERT INTO scores ( tournament, round, parallel, player, songnumber, song, playmode, difficulty, chosen, score ) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European PG Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )), + 3, + 5, + ( SELECT player FROM players WHERE nick='Nuust' ), + 2, + ( SELECT song FROM songs WHERE lower(title)=lower('Dynamite Rave') ), + 'single', + 'expert', + 'f', + 8344); +INSERT INTO scores ( tournament, round, parallel, player, songnumber, song, playmode, difficulty, chosen, score ) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European PG Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )), + 3, + 5, + ( SELECT player FROM players WHERE nick='Nuust' ), + 3, + ( SELECT song FROM songs WHERE lower(title)=lower('Max 300') ), + 'single', + 'expert', + 't', + 8960); +INSERT INTO scores ( tournament, round, parallel, player, songnumber, song, playmode, difficulty, chosen, score ) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European PG Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )), + 2, + 4, + ( SELECT player FROM players WHERE nick='Nuust' ), + 2, + ( SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)') ), + 'single', + 'expert', + 'f', + 8523); +INSERT INTO scores ( tournament, round, parallel, player, songnumber, song, playmode, difficulty, chosen, score ) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European PG Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )), + 2, + 4, + ( SELECT player FROM players WHERE nick='Nuust' ), + 3, + ( SELECT song FROM songs WHERE lower(title)=lower('Exotic Ethnic') ), + 'single', + 'expert', + 't', + 8746); +INSERT INTO scores ( tournament, round, parallel, player, songnumber, song, playmode, difficulty, chosen, score ) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European PG Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )), + 1, + 0, + ( SELECT player FROM players WHERE nick='Nuust' ), + 1, + ( SELECT song FROM songs WHERE lower(title)=lower('era (nostalmix)') ), + 'single', + 'expert', + 'f', + 7266); +INSERT INTO scores ( tournament, round, parallel, player, songnumber, song, playmode, difficulty, chosen, score ) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European PG Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )), + 2, + 4, + ( SELECT player FROM players WHERE nick='Nuust' ), + 1, + ( SELECT song FROM songs WHERE lower(title)=lower('Don\'t Try to Stop It') ), + 'single', + 'expert', + 'f', + 6972); +INSERT INTO scores ( tournament, round, parallel, player, songnumber, song, playmode, difficulty, chosen, score ) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European PG Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )), + 2, + 8, + ( SELECT player FROM players WHERE nick='Sesse' ), + 3, + ( SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)') ), + 'single', + 'expert', + 't', + 8770); +INSERT INTO scores ( tournament, round, parallel, player, songnumber, song, playmode, difficulty, chosen, score ) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European PG Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )), + 2, + 8, + ( SELECT player FROM players WHERE nick='Sesse' ), + 2, + ( SELECT song FROM songs WHERE lower(title)=lower('Make A Jam!') ), + 'single', + 'expert', + 'f', + 6683); +INSERT INTO scores ( tournament, round, parallel, player, songnumber, song, playmode, difficulty, chosen, score ) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European PG Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )), + 2, + 8, + ( SELECT player FROM players WHERE nick='Sesse' ), + 1, + ( SELECT song FROM songs WHERE lower(title)=lower('Crash!') ), + 'single', + 'expert', + 'f', + 8536); +INSERT INTO scores ( tournament, round, parallel, player, songnumber, song, playmode, difficulty, chosen, score ) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European PG Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )), + 1, + 0, + ( SELECT player FROM players WHERE nick='Sesse' ), + 1, + ( SELECT song FROM songs WHERE lower(title)=lower('era (nostalmix)') ), + 'single', + 'expert', + 'f', + 7563); +INSERT INTO scores ( tournament, round, parallel, player, songnumber, song, playmode, difficulty, chosen, score ) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European PG Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )), + 2, + 1, + ( SELECT player FROM players WHERE nick='Oliyzia' ), + 3, + ( SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)') ), + 'single', + 'expert', + 't', + 8450); +INSERT INTO scores ( tournament, round, parallel, player, songnumber, song, playmode, difficulty, chosen, score ) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European PG Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )), + 2, + 1, + ( SELECT player FROM players WHERE nick='Oliyzia' ), + 2, + ( SELECT song FROM songs WHERE lower(title)=lower('Dynamite Rave') ), + 'single', + 'expert', + 'f', + 7945); +INSERT INTO scores ( tournament, round, parallel, player, songnumber, song, playmode, difficulty, chosen, score ) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European PG Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )), + 1, + 0, + ( SELECT player FROM players WHERE nick='Oliyzia' ), + 1, + ( SELECT song FROM songs WHERE lower(title)=lower('era (nostalmix)') ), + 'single', + 'expert', + 'f', + 7401); +INSERT INTO scores ( tournament, round, parallel, player, songnumber, song, playmode, difficulty, chosen, score ) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European PG Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )), + 2, + 1, + ( SELECT player FROM players WHERE nick='Oliyzia' ), + 1, + ( SELECT song FROM songs WHERE lower(title)=lower('Let the Beat Hit \'em!') ), + 'single', + 'expert', + 'f', + 6649); +INSERT INTO scores ( tournament, round, parallel, player, songnumber, song, playmode, difficulty, chosen, score ) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European PG Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )), + 3, + 6, + ( SELECT player FROM players WHERE nick='Lord Glenn' ), + 3, + ( SELECT song FROM songs WHERE lower(title)=lower('PARANOiA Rebirth') ), + 'single', + 'expert', + 't', + 8410); +INSERT INTO scores ( tournament, round, parallel, player, songnumber, song, playmode, difficulty, chosen, score ) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European PG Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )), + 3, + 6, + ( SELECT player FROM players WHERE nick='Lord Glenn' ), + 1, + ( SELECT song FROM songs WHERE lower(title)=lower('Silent Hill') ), + 'single', + 'expert', + 'f', + 6701); +INSERT INTO scores ( tournament, round, parallel, player, songnumber, song, playmode, difficulty, chosen, score ) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European PG Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )), + 2, + 3, + ( SELECT player FROM players WHERE nick='Lord Glenn' ), + 2, + ( SELECT song FROM songs WHERE lower(title)=lower('Afronova Primeval') ), + 'single', + 'expert', + 'f', + 8798); +INSERT INTO scores ( tournament, round, parallel, player, songnumber, song, playmode, difficulty, chosen, score ) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European PG Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )), + 3, + 6, + ( SELECT player FROM players WHERE nick='Lord Glenn' ), + 2, + ( SELECT song FROM songs WHERE lower(title)=lower('DXY!') ), + 'single', + 'expert', + 'f', + 7703); +INSERT INTO scores ( tournament, round, parallel, player, songnumber, song, playmode, difficulty, chosen, score ) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European PG Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )), + 2, + 3, + ( SELECT player FROM players WHERE nick='Lord Glenn' ), + 3, + ( SELECT song FROM songs WHERE lower(title)=lower('Candy☆') ), + 'single', + 'expert', + 't', + 7836); +INSERT INTO scores ( tournament, round, parallel, player, songnumber, song, playmode, difficulty, chosen, score ) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European PG Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )), + 1, + 0, + ( SELECT player FROM players WHERE nick='Lord Glenn' ), + 1, + ( SELECT song FROM songs WHERE lower(title)=lower('era (nostalmix)') ), + 'single', + 'expert', + 'f', + 7803); +INSERT INTO scores ( tournament, round, parallel, player, songnumber, song, playmode, difficulty, chosen, score ) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European PG Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )), + 2, + 3, + ( SELECT player FROM players WHERE nick='Lord Glenn' ), + 1, + ( SELECT song FROM songs WHERE lower(title)=lower('Rain of Sorrow') ), + 'single', + 'expert', + 'f', + 8511); +INSERT INTO scores ( tournament, round, parallel, player, songnumber, song, playmode, difficulty, chosen, score ) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European PG Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )), + 2, + 3, + ( SELECT player FROM players WHERE nick='Bazze' ), + 3, + ( SELECT song FROM songs WHERE lower(title)=lower('Healing Vision (Angelic Mix)') ), + 'single', + 'expert', + 't', + 6563); +INSERT INTO scores ( tournament, round, parallel, player, songnumber, song, playmode, difficulty, chosen, score ) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European PG Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )), + 2, + 3, + ( SELECT player FROM players WHERE nick='Bazze' ), + 2, + ( SELECT song FROM songs WHERE lower(title)=lower('Afronova Primeval') ), + 'single', + 'expert', + 'f', + 6359); +INSERT INTO scores ( tournament, round, parallel, player, songnumber, song, playmode, difficulty, chosen, score ) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European PG Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )), + 1, + 0, + ( SELECT player FROM players WHERE nick='Bazze' ), + 1, + ( SELECT song FROM songs WHERE lower(title)=lower('era (nostalmix)') ), + 'single', + 'expert', + 'f', + 6409); +INSERT INTO scores ( tournament, round, parallel, player, songnumber, song, playmode, difficulty, chosen, score ) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European PG Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )), + 2, + 3, + ( SELECT player FROM players WHERE nick='Bazze' ), + 1, + ( SELECT song FROM songs WHERE lower(title)=lower('Rain of Sorrow') ), + 'single', + 'expert', + 'f', + 6174); +INSERT INTO scores ( tournament, round, parallel, player, songnumber, song, playmode, difficulty, chosen, score ) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European PG Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )), + 2, + 8, + ( SELECT player FROM players WHERE nick='Kenny' ), + 3, + ( SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)') ), + 'single', + 'expert', + 't', + 8155); +INSERT INTO scores ( tournament, round, parallel, player, songnumber, song, playmode, difficulty, chosen, score ) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European PG Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )), + 2, + 8, + ( SELECT player FROM players WHERE nick='Kenny' ), + 2, + ( SELECT song FROM songs WHERE lower(title)=lower('Make A Jam!') ), + 'single', + 'expert', + 'f', + 5993); +INSERT INTO scores ( tournament, round, parallel, player, songnumber, song, playmode, difficulty, chosen, score ) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European PG Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )), + 2, + 8, + ( SELECT player FROM players WHERE nick='Kenny' ), + 1, + ( SELECT song FROM songs WHERE lower(title)=lower('Crash!') ), + 'single', + 'expert', + 'f', + 7941); +INSERT INTO scores ( tournament, round, parallel, player, songnumber, song, playmode, difficulty, chosen, score ) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European PG Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )), + 1, + 0, + ( SELECT player FROM players WHERE nick='Kenny' ), + 1, + ( SELECT song FROM songs WHERE lower(title)=lower('era (nostalmix)') ), + 'single', + 'expert', + 'f', + 6903); +INSERT INTO scores ( tournament, round, parallel, player, songnumber, song, playmode, difficulty, chosen, score ) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European PG Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )), + 2, + 4, + ( SELECT player FROM players WHERE nick='Camry' ), + 3, + ( SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)') ), + 'single', + 'expert', + 't', + 7920); +INSERT INTO scores ( tournament, round, parallel, player, songnumber, song, playmode, difficulty, chosen, score ) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European PG Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )), + 2, + 4, + ( SELECT player FROM players WHERE nick='Camry' ), + 2, + ( SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)') ), + 'single', + 'expert', + 'f', + 7418); +INSERT INTO scores ( tournament, round, parallel, player, songnumber, song, playmode, difficulty, chosen, score ) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European PG Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )), + 1, + 0, + ( SELECT player FROM players WHERE nick='Camry' ), + 1, + ( SELECT song FROM songs WHERE lower(title)=lower('era (nostalmix)') ), + 'single', + 'expert', + 'f', + 5948); +INSERT INTO scores ( tournament, round, parallel, player, songnumber, song, playmode, difficulty, chosen, score ) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European PG Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )), + 2, + 4, + ( SELECT player FROM players WHERE nick='Camry' ), + 1, + ( SELECT song FROM songs WHERE lower(title)=lower('Don\'t Try to Stop It') ), + 'single', + 'expert', + 'f', + 6620); +INSERT INTO scores ( tournament, round, parallel, player, songnumber, song, playmode, difficulty, chosen, score ) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European PG Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )), + 2, + 9, + ( SELECT player FROM players WHERE nick='Infernuz' ), + 2, + ( SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love (SPEED MIX)') ), + 'single', + 'expert', + 'f', + 0); +INSERT INTO scores ( tournament, round, parallel, player, songnumber, song, playmode, difficulty, chosen, score ) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European PG Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )), + 1, + 0, + ( SELECT player FROM players WHERE nick='Infernuz' ), + 1, + ( SELECT song FROM songs WHERE lower(title)=lower('era (nostalmix)') ), + 'single', + 'expert', + 'f', + 0); +INSERT INTO scores ( tournament, round, parallel, player, songnumber, song, playmode, difficulty, chosen, score ) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European PG Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )), + 2, + 9, + ( SELECT player FROM players WHERE nick='Infernuz' ), + 1, + ( SELECT song FROM songs WHERE lower(title)=lower('Remember You') ), + 'single', + 'expert', + 'f', + 0); +INSERT INTO scores ( tournament, round, parallel, player, songnumber, song, playmode, difficulty, chosen, score ) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European PG Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )), + 2, + 9, + ( SELECT player FROM players WHERE nick='Infernuz' ), + 3, + ( SELECT song FROM songs WHERE lower(title)=lower('5, 6, 7, 8') ), + 'single', + 'expert', + 't', + 0); +INSERT INTO scores ( tournament, round, parallel, player, songnumber, song, playmode, difficulty, chosen, score ) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European PG Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )), + 3, + 1, + ( SELECT player FROM players WHERE nick='Al' ), + 2, + ( SELECT song FROM songs WHERE lower(title)=lower('Love This Feelin\'') ), + 'single', + 'expert', + 'f', + 6485); +INSERT INTO scores ( tournament, round, parallel, player, songnumber, song, playmode, difficulty, chosen, score ) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European PG Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )), + 3, + 1, + ( SELECT player FROM players WHERE nick='Al' ), + 1, + ( SELECT song FROM songs WHERE lower(title)=lower('Luv to Me (AMD Mix)') ), + 'single', + 'expert', + 'f', + 6722); +INSERT INTO scores ( tournament, round, parallel, player, songnumber, song, playmode, difficulty, chosen, score ) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European PG Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )), + 3, + 1, + ( SELECT player FROM players WHERE nick='Al' ), + 3, + ( SELECT song FROM songs WHERE lower(title)=lower('Afronova Primeval') ), + 'single', + 'expert', + 't', + 7989); +INSERT INTO scores ( tournament, round, parallel, player, songnumber, song, playmode, difficulty, chosen, score ) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European PG Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )), + 2, + 5, + ( SELECT player FROM players WHERE nick='Al' ), + 3, + ( SELECT song FROM songs WHERE lower(title)=lower('Exotic Ethnic') ), + 'single', + 'expert', + 't', + 8371); +INSERT INTO scores ( tournament, round, parallel, player, songnumber, song, playmode, difficulty, chosen, score ) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European PG Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )), + 1, + 0, + ( SELECT player FROM players WHERE nick='Al' ), + 1, + ( SELECT song FROM songs WHERE lower(title)=lower('era (nostalmix)') ), + 'single', + 'expert', + 'f', + 6623); +INSERT INTO scores ( tournament, round, parallel, player, songnumber, song, playmode, difficulty, chosen, score ) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European PG Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )), + 2, + 5, + ( SELECT player FROM players WHERE nick='Al' ), + 1, + ( SELECT song FROM songs WHERE lower(title)=lower('The Reflex') ), + 'single', + 'expert', + 'f', + 7069); +INSERT INTO scores ( tournament, round, parallel, player, songnumber, song, playmode, difficulty, chosen, score ) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European PG Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )), + 2, + 5, + ( SELECT player FROM players WHERE nick='Al' ), + 2, + ( SELECT song FROM songs WHERE lower(title)=lower('The Centre of the Heart (Stonebridge Club Mix)') ), + 'single', + 'expert', + 'f', + 6055); +INSERT INTO scores ( tournament, round, parallel, player, songnumber, song, playmode, difficulty, chosen, score ) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European PG Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )), + 2, + 8, + ( SELECT player FROM players WHERE nick='Yukinon' ), + 3, + ( SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)') ), + 'single', + 'expert', + 't', + 7517); +INSERT INTO scores ( tournament, round, parallel, player, songnumber, song, playmode, difficulty, chosen, score ) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European PG Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )), + 2, + 8, + ( SELECT player FROM players WHERE nick='Yukinon' ), + 2, + ( SELECT song FROM songs WHERE lower(title)=lower('Make A Jam!') ), + 'single', + 'expert', + 'f', + 5505); +INSERT INTO scores ( tournament, round, parallel, player, songnumber, song, playmode, difficulty, chosen, score ) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European PG Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )), + 2, + 8, + ( SELECT player FROM players WHERE nick='Yukinon' ), + 1, + ( SELECT song FROM songs WHERE lower(title)=lower('Crash!') ), + 'single', + 'expert', + 'f', + 6713); +INSERT INTO scores ( tournament, round, parallel, player, songnumber, song, playmode, difficulty, chosen, score ) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European PG Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )), + 1, + 0, + ( SELECT player FROM players WHERE nick='Yukinon' ), + 1, + ( SELECT song FROM songs WHERE lower(title)=lower('era (nostalmix)') ), + 'single', + 'expert', + 'f', + 4881); +INSERT INTO scores ( tournament, round, parallel, player, songnumber, song, playmode, difficulty, chosen, score ) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European PG Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )), + 2, + 9, + ( SELECT player FROM players WHERE nick='Kabbefett' ), + 2, + ( SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love (SPEED MIX)') ), + 'single', + 'expert', + 'f', + 7448); +INSERT INTO scores ( tournament, round, parallel, player, songnumber, song, playmode, difficulty, chosen, score ) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European PG Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )), + 2, + 9, + ( SELECT player FROM players WHERE nick='Kabbefett' ), + 3, + ( SELECT song FROM songs WHERE lower(title)=lower('Crash!') ), + 'single', + 'expert', + 't', + 7472); +INSERT INTO scores ( tournament, round, parallel, player, songnumber, song, playmode, difficulty, chosen, score ) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European PG Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )), + 1, + 0, + ( SELECT player FROM players WHERE nick='Kabbefett' ), + 1, + ( SELECT song FROM songs WHERE lower(title)=lower('era (nostalmix)') ), + 'single', + 'expert', + 'f', + 7175); +INSERT INTO scores ( tournament, round, parallel, player, songnumber, song, playmode, difficulty, chosen, score ) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European PG Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )), + 2, + 9, + ( SELECT player FROM players WHERE nick='Kabbefett' ), + 1, + ( SELECT song FROM songs WHERE lower(title)=lower('Remember You') ), + 'single', + 'expert', + 'f', + 4475); +INSERT INTO scores ( tournament, round, parallel, player, songnumber, song, playmode, difficulty, chosen, score ) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European PG Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )), + 7, + 0, + ( SELECT player FROM players WHERE nick='Kasu' ), + 2, + ( SELECT song FROM songs WHERE lower(title)=lower('Afronova') ), + 'single', + 'expert', + 't', + 8855); +INSERT INTO scores ( tournament, round, parallel, player, songnumber, song, playmode, difficulty, chosen, score ) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European PG Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )), + 9, + 0, + ( SELECT player FROM players WHERE nick='Kasu' ), + 2, + ( SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)') ), + 'single', + 'expert', + 't', + 8955); +INSERT INTO scores ( tournament, round, parallel, player, songnumber, song, playmode, difficulty, chosen, score ) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European PG Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )), + 10, + 0, + ( SELECT player FROM players WHERE nick='Kasu' ), + 1, + ( SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)') ), + 'single', + 'expert', + 'f', + 8923); +INSERT INTO scores ( tournament, round, parallel, player, songnumber, song, playmode, difficulty, chosen, score ) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European PG Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )), + 3, + 5, + ( SELECT player FROM players WHERE nick='Kasu' ), + 1, + ( SELECT song FROM songs WHERE lower(title)=lower('Dead End') ), + 'single', + 'expert', + 'f', + 8768); +INSERT INTO scores ( tournament, round, parallel, player, songnumber, song, playmode, difficulty, chosen, score ) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European PG Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )), + 3, + 5, + ( SELECT player FROM players WHERE nick='Kasu' ), + 2, + ( SELECT song FROM songs WHERE lower(title)=lower('Dynamite Rave') ), + 'single', + 'expert', + 'f', + 8894); +INSERT INTO scores ( tournament, round, parallel, player, songnumber, song, playmode, difficulty, chosen, score ) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European PG Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )), + 6, + 0, + ( SELECT player FROM players WHERE nick='Kasu' ), + 2, + ( SELECT song FROM songs WHERE lower(title)=lower('Dynamite Rave') ), + 'single', + 'expert', + 't', + 8801); +INSERT INTO scores ( tournament, round, parallel, player, songnumber, song, playmode, difficulty, chosen, score ) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European PG Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )), + 8, + 0, + ( SELECT player FROM players WHERE nick='Kasu' ), + 1, + ( SELECT song FROM songs WHERE lower(title)=lower('Make A Jam!') ), + 'single', + 'expert', + 'f', + 6928); +INSERT INTO scores ( tournament, round, parallel, player, songnumber, song, playmode, difficulty, chosen, score ) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European PG Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )), + 8, + 0, + ( SELECT player FROM players WHERE nick='Kasu' ), + 2, + ( SELECT song FROM songs WHERE lower(title)=lower('Max 300') ), + 'single', + 'expert', + 't', + 9130); +INSERT INTO scores ( tournament, round, parallel, player, songnumber, song, playmode, difficulty, chosen, score ) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European PG Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )), + 6, + 0, + ( SELECT player FROM players WHERE nick='Kasu' ), + 1, + ( SELECT song FROM songs WHERE lower(title)=lower('Healing Vision (Angelic Mix)') ), + 'single', + 'expert', + 'f', + 8648); +INSERT INTO scores ( tournament, round, parallel, player, songnumber, song, playmode, difficulty, chosen, score ) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European PG Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )), + 3, + 5, + ( SELECT player FROM players WHERE nick='Kasu' ), + 3, + ( SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love (SPEED MIX)') ), + 'single', + 'expert', + 't', + 8963); +INSERT INTO scores ( tournament, round, parallel, player, songnumber, song, playmode, difficulty, chosen, score ) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European PG Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )), + 2, + 10, + ( SELECT player FROM players WHERE nick='Kasu' ), + 3, + ( SELECT song FROM songs WHERE lower(title)=lower('Afronova Primeval') ), + 'single', + 'expert', + 't', + 8852); +INSERT INTO scores ( tournament, round, parallel, player, songnumber, song, playmode, difficulty, chosen, score ) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European PG Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )), + 4, + 0, + ( SELECT player FROM players WHERE nick='Kasu' ), + 2, + ( SELECT song FROM songs WHERE lower(title)=lower('Exotic Ethnic') ), + 'single', + 'expert', + 't', + 8943); +INSERT INTO scores ( tournament, round, parallel, player, songnumber, song, playmode, difficulty, chosen, score ) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European PG Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )), + 5, + 0, + ( SELECT player FROM players WHERE nick='Kasu' ), + 2, + ( SELECT song FROM songs WHERE lower(title)=lower('Crash!') ), + 'single', + 'expert', + 't', + 8865); +INSERT INTO scores ( tournament, round, parallel, player, songnumber, song, playmode, difficulty, chosen, score ) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European PG Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )), + 1, + 0, + ( SELECT player FROM players WHERE nick='Kasu' ), + 1, + ( SELECT song FROM songs WHERE lower(title)=lower('era (nostalmix)') ), + 'single', + 'expert', + 'f', + 7659); +INSERT INTO scores ( tournament, round, parallel, player, songnumber, song, playmode, difficulty, chosen, score ) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European PG Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )), + 9, + 0, + ( SELECT player FROM players WHERE nick='Kasu' ), + 1, + ( SELECT song FROM songs WHERE lower(title)=lower('My Summer Love') ), + 'single', + 'expert', + 'f', + 8364); +INSERT INTO scores ( tournament, round, parallel, player, songnumber, song, playmode, difficulty, chosen, score ) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European PG Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )), + 2, + 10, + ( SELECT player FROM players WHERE nick='Kasu' ), + 1, + ( SELECT song FROM songs WHERE lower(title)=lower('D2R') ), + 'single', + 'expert', + 'f', + 6791); +INSERT INTO scores ( tournament, round, parallel, player, songnumber, song, playmode, difficulty, chosen, score ) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European PG Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )), + 2, + 10, + ( SELECT player FROM players WHERE nick='Kasu' ), + 2, + ( SELECT song FROM songs WHERE lower(title)=lower('Spin the Disc') ), + 'single', + 'expert', + 'f', + 7896); +INSERT INTO scores ( tournament, round, parallel, player, songnumber, song, playmode, difficulty, chosen, score ) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European PG Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )), + 4, + 0, + ( SELECT player FROM players WHERE nick='Kasu' ), + 1, + ( SELECT song FROM songs WHERE lower(title)=lower('Remember You') ), + 'single', + 'expert', + 'f', + 4798); +INSERT INTO scores ( tournament, round, parallel, player, songnumber, song, playmode, difficulty, chosen, score ) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European PG Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )), + 10, + 0, + ( SELECT player FROM players WHERE nick='Kasu' ), + 2, + ( SELECT song FROM songs WHERE lower(title)=lower('So Deep (Perfect Sphere Mix)') ), + 'single', + 'expert', + 't', + 8842); +INSERT INTO scores ( tournament, round, parallel, player, songnumber, song, playmode, difficulty, chosen, score ) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European PG Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )), + 5, + 0, + ( SELECT player FROM players WHERE nick='Kasu' ), + 1, + ( SELECT song FROM songs WHERE lower(title)=lower('Nori Nori Nori') ), + 'single', + 'expert', + 'f', + 6939); +INSERT INTO scores ( tournament, round, parallel, player, songnumber, song, playmode, difficulty, chosen, score ) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European PG Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )), + 7, + 0, + ( SELECT player FROM players WHERE nick='Kasu' ), + 1, + ( SELECT song FROM songs WHERE lower(title)=lower('The Centre of the Heart (Stonebridge Club Mix)') ), + 'single', + 'expert', + 'f', + 6961); +INSERT INTO scores ( tournament, round, parallel, player, songnumber, song, playmode, difficulty, chosen, score ) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European PG Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )), + 2, + 2, + ( SELECT player FROM players WHERE nick='Drummer' ), + 2, + ( SELECT song FROM songs WHERE lower(title)=lower('Afronova') ), + 'single', + 'expert', + 'f', + 8573); +INSERT INTO scores ( tournament, round, parallel, player, songnumber, song, playmode, difficulty, chosen, score ) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European PG Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )), + 4, + 0, + ( SELECT player FROM players WHERE nick='Drummer' ), + 2, + ( SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)') ), + 'single', + 'expert', + 't', + 8924); +INSERT INTO scores ( tournament, round, parallel, player, songnumber, song, playmode, difficulty, chosen, score ) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European PG Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )), + 2, + 2, + ( SELECT player FROM players WHERE nick='Drummer' ), + 3, + ( SELECT song FROM songs WHERE lower(title)=lower('Max 300') ), + 'single', + 'expert', + 't', + 9402); +INSERT INTO scores ( tournament, round, parallel, player, songnumber, song, playmode, difficulty, chosen, score ) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European PG Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )), + 6, + 0, + ( SELECT player FROM players WHERE nick='Drummer' ), + 1, + ( SELECT song FROM songs WHERE lower(title)=lower('Healing Vision (Angelic Mix)') ), + 'single', + 'expert', + 'f', + 8504); +INSERT INTO scores ( tournament, round, parallel, player, songnumber, song, playmode, difficulty, chosen, score ) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European PG Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )), + 3, + 2, + ( SELECT player FROM players WHERE nick='Drummer' ), + 3, + ( SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love (SPEED MIX)') ), + 'single', + 'expert', + 't', + 8919); +INSERT INTO scores ( tournament, round, parallel, player, songnumber, song, playmode, difficulty, chosen, score ) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European PG Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )), + 5, + 0, + ( SELECT player FROM players WHERE nick='Drummer' ), + 2, + ( SELECT song FROM songs WHERE lower(title)=lower('Crash!') ), + 'single', + 'expert', + 't', + 8889); +INSERT INTO scores ( tournament, round, parallel, player, songnumber, song, playmode, difficulty, chosen, score ) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European PG Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )), + 1, + 0, + ( SELECT player FROM players WHERE nick='Drummer' ), + 1, + ( SELECT song FROM songs WHERE lower(title)=lower('era (nostalmix)') ), + 'single', + 'expert', + 'f', + 7833); +INSERT INTO scores ( tournament, round, parallel, player, songnumber, song, playmode, difficulty, chosen, score ) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European PG Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )), + 6, + 0, + ( SELECT player FROM players WHERE nick='Drummer' ), + 2, + ( SELECT song FROM songs WHERE lower(title)=lower('Vanity Angel') ), + 'single', + 'expert', + 't', + 8797); +INSERT INTO scores ( tournament, round, parallel, player, songnumber, song, playmode, difficulty, chosen, score ) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European PG Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )), + 3, + 2, + ( SELECT player FROM players WHERE nick='Drummer' ), + 1, + ( SELECT song FROM songs WHERE lower(title)=lower('Spin the Disc') ), + 'single', + 'expert', + 'f', + 7858); +INSERT INTO scores ( tournament, round, parallel, player, songnumber, song, playmode, difficulty, chosen, score ) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European PG Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )), + 4, + 0, + ( SELECT player FROM players WHERE nick='Drummer' ), + 1, + ( SELECT song FROM songs WHERE lower(title)=lower('Remember You') ), + 'single', + 'expert', + 'f', + 4934); +INSERT INTO scores ( tournament, round, parallel, player, songnumber, song, playmode, difficulty, chosen, score ) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European PG Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )), + 5, + 0, + ( SELECT player FROM players WHERE nick='Drummer' ), + 1, + ( SELECT song FROM songs WHERE lower(title)=lower('Nori Nori Nori') ), + 'single', + 'expert', + 'f', + 6890); +INSERT INTO scores ( tournament, round, parallel, player, songnumber, song, playmode, difficulty, chosen, score ) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European PG Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )), + 2, + 2, + ( SELECT player FROM players WHERE nick='Drummer' ), + 1, + ( SELECT song FROM songs WHERE lower(title)=lower('Love You Like A Fool') ), + 'single', + 'expert', + 'f', + 6740); +INSERT INTO scores ( tournament, round, parallel, player, songnumber, song, playmode, difficulty, chosen, score ) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European PG Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )), + 3, + 2, + ( SELECT player FROM players WHERE nick='Drummer' ), + 2, + ( SELECT song FROM songs WHERE lower(title)=lower('That was Then, This is Now') ), + 'single', + 'expert', + 'f', + 5774); +INSERT INTO scores ( tournament, round, parallel, player, songnumber, song, playmode, difficulty, chosen, score ) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European PG Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )), + 2, + 7, + ( SELECT player FROM players WHERE nick='Kasuya' ), + 3, + ( SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)') ), + 'single', + 'expert', + 't', + 8356); +INSERT INTO scores ( tournament, round, parallel, player, songnumber, song, playmode, difficulty, chosen, score ) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European PG Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )), + 2, + 7, + ( SELECT player FROM players WHERE nick='Kasuya' ), + 1, + ( SELECT song FROM songs WHERE lower(title)=lower('Burnin\' the Floor') ), + 'single', + 'expert', + 'f', + 6389); +INSERT INTO scores ( tournament, round, parallel, player, songnumber, song, playmode, difficulty, chosen, score ) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European PG Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )), + 1, + 0, + ( SELECT player FROM players WHERE nick='Kasuya' ), + 1, + ( SELECT song FROM songs WHERE lower(title)=lower('era (nostalmix)') ), + 'single', + 'expert', + 'f', + 7218); +INSERT INTO scores ( tournament, round, parallel, player, songnumber, song, playmode, difficulty, chosen, score ) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European PG Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )), + 2, + 7, + ( SELECT player FROM players WHERE nick='Kasuya' ), + 2, + ( SELECT song FROM songs WHERE lower(title)=lower('Stomp') ), + 'single', + 'expert', + 'f', + 5867); +INSERT INTO scores ( tournament, round, parallel, player, songnumber, song, playmode, difficulty, chosen, score ) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European PG Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )), + 3, + 3, + ( SELECT player FROM players WHERE nick='K-Dogg' ), + 3, + ( SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)') ), + 'single', + 'expert', + 't', + 8971); +INSERT INTO scores ( tournament, round, parallel, player, songnumber, song, playmode, difficulty, chosen, score ) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European PG Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )), + 10, + 0, + ( SELECT player FROM players WHERE nick='K-Dogg' ), + 1, + ( SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)') ), + 'single', + 'expert', + 'f', + 8761); +INSERT INTO scores ( tournament, round, parallel, player, songnumber, song, playmode, difficulty, chosen, score ) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European PG Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )), + 2, + 1, + ( SELECT player FROM players WHERE nick='K-Dogg' ), + 2, + ( SELECT song FROM songs WHERE lower(title)=lower('Dynamite Rave') ), + 'single', + 'expert', + 'f', + 8964); +INSERT INTO scores ( tournament, round, parallel, player, songnumber, song, playmode, difficulty, chosen, score ) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European PG Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )), + 8, + 0, + ( SELECT player FROM players WHERE nick='K-Dogg' ), + 1, + ( SELECT song FROM songs WHERE lower(title)=lower('Make A Jam!') ), + 'single', + 'expert', + 'f', + 6907); +INSERT INTO scores ( tournament, round, parallel, player, songnumber, song, playmode, difficulty, chosen, score ) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European PG Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )), + 8, + 0, + ( SELECT player FROM players WHERE nick='K-Dogg' ), + 2, + ( SELECT song FROM songs WHERE lower(title)=lower('Max 300') ), + 'single', + 'expert', + 't', + 9695); +INSERT INTO scores ( tournament, round, parallel, player, songnumber, song, playmode, difficulty, chosen, score ) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European PG Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )), + 4, + 0, + ( SELECT player FROM players WHERE nick='K-Dogg' ), + 2, + ( SELECT song FROM songs WHERE lower(title)=lower('Trip Machine Climax') ), + 'single', + 'expert', + 't', + 8886); +INSERT INTO scores ( tournament, round, parallel, player, songnumber, song, playmode, difficulty, chosen, score ) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European PG Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )), + 6, + 0, + ( SELECT player FROM players WHERE nick='K-Dogg' ), + 1, + ( SELECT song FROM songs WHERE lower(title)=lower('Healing Vision (Angelic Mix)') ), + 'single', + 'expert', + 'f', + 8946); +INSERT INTO scores ( tournament, round, parallel, player, songnumber, song, playmode, difficulty, chosen, score ) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European PG Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )), + 9, + 0, + ( SELECT player FROM players WHERE nick='K-Dogg' ), + 2, + ( SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love (SPEED MIX)') ), + 'single', + 'expert', + 't', + 8882); +INSERT INTO scores ( tournament, round, parallel, player, songnumber, song, playmode, difficulty, chosen, score ) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European PG Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )), + 10, + 0, + ( SELECT player FROM players WHERE nick='K-Dogg' ), + 2, + ( SELECT song FROM songs WHERE lower(title)=lower('Exotic Ethnic') ), + 'single', + 'expert', + 't', + 8762); +INSERT INTO scores ( tournament, round, parallel, player, songnumber, song, playmode, difficulty, chosen, score ) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European PG Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )), + 2, + 1, + ( SELECT player FROM players WHERE nick='K-Dogg' ), + 3, + ( SELECT song FROM songs WHERE lower(title)=lower('DXY!') ), + 'single', + 'expert', + 't', + 7944); +INSERT INTO scores ( tournament, round, parallel, player, songnumber, song, playmode, difficulty, chosen, score ) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European PG Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )), + 7, + 0, + ( SELECT player FROM players WHERE nick='K-Dogg' ), + 2, + ( SELECT song FROM songs WHERE lower(title)=lower('Crash!') ), + 'single', + 'expert', + 't', + 8949); +INSERT INTO scores ( tournament, round, parallel, player, songnumber, song, playmode, difficulty, chosen, score ) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European PG Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )), + 1, + 0, + ( SELECT player FROM players WHERE nick='K-Dogg' ), + 1, + ( SELECT song FROM songs WHERE lower(title)=lower('era (nostalmix)') ), + 'single', + 'expert', + 'f', + 7848); +INSERT INTO scores ( tournament, round, parallel, player, songnumber, song, playmode, difficulty, chosen, score ) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European PG Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )), + 3, + 3, + ( SELECT player FROM players WHERE nick='K-Dogg' ), + 1, + ( SELECT song FROM songs WHERE lower(title)=lower('B4U') ), + 'single', + 'expert', + 'f', + 7938); +INSERT INTO scores ( tournament, round, parallel, player, songnumber, song, playmode, difficulty, chosen, score ) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European PG Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )), + 5, + 0, + ( SELECT player FROM players WHERE nick='K-Dogg' ), + 2, + ( SELECT song FROM songs WHERE lower(title)=lower('Vanity Angel') ), + 'single', + 'expert', + 't', + 8920); +INSERT INTO scores ( tournament, round, parallel, player, songnumber, song, playmode, difficulty, chosen, score ) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European PG Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )), + 9, + 0, + ( SELECT player FROM players WHERE nick='K-Dogg' ), + 1, + ( SELECT song FROM songs WHERE lower(title)=lower('My Summer Love') ), + 'single', + 'expert', + 'f', + 8667); +INSERT INTO scores ( tournament, round, parallel, player, songnumber, song, playmode, difficulty, chosen, score ) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European PG Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )), + 6, + 0, + ( SELECT player FROM players WHERE nick='K-Dogg' ), + 2, + ( SELECT song FROM songs WHERE lower(title)=lower('Rain of Sorrow') ), + 'single', + 'expert', + 't', + 8937); +INSERT INTO scores ( tournament, round, parallel, player, songnumber, song, playmode, difficulty, chosen, score ) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European PG Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )), + 2, + 1, + ( SELECT player FROM players WHERE nick='K-Dogg' ), + 1, + ( SELECT song FROM songs WHERE lower(title)=lower('Let the Beat Hit \'em!') ), + 'single', + 'expert', + 'f', + 6873); +INSERT INTO scores ( tournament, round, parallel, player, songnumber, song, playmode, difficulty, chosen, score ) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European PG Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )), + 4, + 0, + ( SELECT player FROM players WHERE nick='K-Dogg' ), + 1, + ( SELECT song FROM songs WHERE lower(title)=lower('Remember You') ), + 'single', + 'expert', + 'f', + 4927); +INSERT INTO scores ( tournament, round, parallel, player, songnumber, song, playmode, difficulty, chosen, score ) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European PG Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )), + 5, + 0, + ( SELECT player FROM players WHERE nick='K-Dogg' ), + 1, + ( SELECT song FROM songs WHERE lower(title)=lower('Nori Nori Nori') ), + 'single', + 'expert', + 'f', + 6918); +INSERT INTO scores ( tournament, round, parallel, player, songnumber, song, playmode, difficulty, chosen, score ) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European PG Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )), + 7, + 0, + ( SELECT player FROM players WHERE nick='K-Dogg' ), + 1, + ( SELECT song FROM songs WHERE lower(title)=lower('The Centre of the Heart (Stonebridge Club Mix)') ), + 'single', + 'expert', + 'f', + 6939); +INSERT INTO scores ( tournament, round, parallel, player, songnumber, song, playmode, difficulty, chosen, score ) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European PG Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )), + 3, + 3, + ( SELECT player FROM players WHERE nick='K-Dogg' ), + 2, + ( SELECT song FROM songs WHERE lower(title)=lower('Caribbean Queen') ), + 'single', + 'expert', + 'f', + 6742); +INSERT INTO scores ( tournament, round, parallel, player, songnumber, song, playmode, difficulty, chosen, score ) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European PG Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )), + 2, + 2, + ( SELECT player FROM players WHERE nick='Amegon' ), + 2, + ( SELECT song FROM songs WHERE lower(title)=lower('Afronova') ), + 'single', + 'expert', + 'f', + 6893); +INSERT INTO scores ( tournament, round, parallel, player, songnumber, song, playmode, difficulty, chosen, score ) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European PG Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )), + 2, + 2, + ( SELECT player FROM players WHERE nick='Amegon' ), + 3, + ( SELECT song FROM songs WHERE lower(title)=lower('Max 300') ), + 'single', + 'expert', + 't', + 7178); +INSERT INTO scores ( tournament, round, parallel, player, songnumber, song, playmode, difficulty, chosen, score ) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European PG Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )), + 1, + 0, + ( SELECT player FROM players WHERE nick='Amegon' ), + 1, + ( SELECT song FROM songs WHERE lower(title)=lower('era (nostalmix)') ), + 'single', + 'expert', + 'f', + 6185); +INSERT INTO scores ( tournament, round, parallel, player, songnumber, song, playmode, difficulty, chosen, score ) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European PG Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )), + 2, + 2, + ( SELECT player FROM players WHERE nick='Amegon' ), + 1, + ( SELECT song FROM songs WHERE lower(title)=lower('Love You Like A Fool') ), + 'single', + 'expert', + 'f', + 6458); +INSERT INTO scores ( tournament, round, parallel, player, songnumber, song, playmode, difficulty, chosen, score ) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European PG Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )), + 2, + 10, + ( SELECT player FROM players WHERE nick='Ai' ), + 3, + ( SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love (SPEED MIX)') ), + 'single', + 'expert', + 't', + 7498); +INSERT INTO scores ( tournament, round, parallel, player, songnumber, song, playmode, difficulty, chosen, score ) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European PG Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )), + 1, + 0, + ( SELECT player FROM players WHERE nick='Ai' ), + 1, + ( SELECT song FROM songs WHERE lower(title)=lower('era (nostalmix)') ), + 'single', + 'expert', + 'f', + 7013); +INSERT INTO scores ( tournament, round, parallel, player, songnumber, song, playmode, difficulty, chosen, score ) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European PG Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )), + 2, + 10, + ( SELECT player FROM players WHERE nick='Ai' ), + 1, + ( SELECT song FROM songs WHERE lower(title)=lower('D2R') ), + 'single', + 'expert', + 'f', + 5218); +INSERT INTO scores ( tournament, round, parallel, player, songnumber, song, playmode, difficulty, chosen, score ) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European PG Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )), + 2, + 10, + ( SELECT player FROM players WHERE nick='Ai' ), + 2, + ( SELECT song FROM songs WHERE lower(title)=lower('Spin the Disc') ), + 'single', + 'expert', + 'f', + 6652); +INSERT INTO scores ( tournament, round, parallel, player, songnumber, song, playmode, difficulty, chosen, score ) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European PG Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )), + 4, + 0, + ( SELECT player FROM players WHERE nick='Eric' ), + 2, + ( SELECT song FROM songs WHERE lower(title)=lower('PARANOiA Rebirth') ), + 'single', + 'expert', + 't', + 8598); +INSERT INTO scores ( tournament, round, parallel, player, songnumber, song, playmode, difficulty, chosen, score ) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European PG Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )), + 3, + 6, + ( SELECT player FROM players WHERE nick='Eric' ), + 1, + ( SELECT song FROM songs WHERE lower(title)=lower('Silent Hill') ), + 'single', + 'expert', + 'f', + 6418); +INSERT INTO scores ( tournament, round, parallel, player, songnumber, song, playmode, difficulty, chosen, score ) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European PG Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )), + 3, + 6, + ( SELECT player FROM players WHERE nick='Eric' ), + 3, + ( SELECT song FROM songs WHERE lower(title)=lower('Max 300') ), + 'single', + 'expert', + 't', + 8941); +INSERT INTO scores ( tournament, round, parallel, player, songnumber, song, playmode, difficulty, chosen, score ) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European PG Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )), + 2, + 7, + ( SELECT player FROM players WHERE nick='Eric' ), + 3, + ( SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love (SPEED MIX)') ), + 'single', + 'expert', + 't', + 8803); +INSERT INTO scores ( tournament, round, parallel, player, songnumber, song, playmode, difficulty, chosen, score ) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European PG Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )), + 3, + 6, + ( SELECT player FROM players WHERE nick='Eric' ), + 2, + ( SELECT song FROM songs WHERE lower(title)=lower('DXY!') ), + 'single', + 'expert', + 'f', + 7590); +INSERT INTO scores ( tournament, round, parallel, player, songnumber, song, playmode, difficulty, chosen, score ) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European PG Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )), + 2, + 7, + ( SELECT player FROM players WHERE nick='Eric' ), + 1, + ( SELECT song FROM songs WHERE lower(title)=lower('Burnin\' the Floor') ), + 'single', + 'expert', + 'f', + 6706); +INSERT INTO scores ( tournament, round, parallel, player, songnumber, song, playmode, difficulty, chosen, score ) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European PG Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )), + 1, + 0, + ( SELECT player FROM players WHERE nick='Eric' ), + 1, + ( SELECT song FROM songs WHERE lower(title)=lower('era (nostalmix)') ), + 'single', + 'expert', + 'f', + 7687); +INSERT INTO scores ( tournament, round, parallel, player, songnumber, song, playmode, difficulty, chosen, score ) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European PG Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )), + 4, + 0, + ( SELECT player FROM players WHERE nick='Eric' ), + 1, + ( SELECT song FROM songs WHERE lower(title)=lower('Remember You') ), + 'single', + 'expert', + 'f', + 4726); +INSERT INTO scores ( tournament, round, parallel, player, songnumber, song, playmode, difficulty, chosen, score ) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European PG Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )), + 2, + 7, + ( SELECT player FROM players WHERE nick='Eric' ), + 2, + ( SELECT song FROM songs WHERE lower(title)=lower('Stomp') ), + 'single', + 'expert', + 'f', + 6183); +INSERT INTO scores ( tournament, round, parallel, player, songnumber, song, playmode, difficulty, chosen, score ) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European PG Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )), + 3, + 4, + ( SELECT player FROM players WHERE nick='Jka' ), + 3, + ( SELECT song FROM songs WHERE lower(title)=lower('Max 300') ), + 'single', + 'expert', + 't', + 8868); +INSERT INTO scores ( tournament, round, parallel, player, songnumber, song, playmode, difficulty, chosen, score ) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European PG Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )), + 2, + 7, + ( SELECT player FROM players WHERE nick='Jka' ), + 3, + ( SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love (SPEED MIX)') ), + 'single', + 'expert', + 't', + 8701); +INSERT INTO scores ( tournament, round, parallel, player, songnumber, song, playmode, difficulty, chosen, score ) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European PG Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )), + 2, + 7, + ( SELECT player FROM players WHERE nick='Jka' ), + 1, + ( SELECT song FROM songs WHERE lower(title)=lower('Burnin\' the Floor') ), + 'single', + 'expert', + 'f', + 6836); +INSERT INTO scores ( tournament, round, parallel, player, songnumber, song, playmode, difficulty, chosen, score ) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European PG Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )), + 1, + 0, + ( SELECT player FROM players WHERE nick='Jka' ), + 1, + ( SELECT song FROM songs WHERE lower(title)=lower('era (nostalmix)') ), + 'single', + 'expert', + 'f', + 7536); +INSERT INTO scores ( tournament, round, parallel, player, songnumber, song, playmode, difficulty, chosen, score ) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European PG Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )), + 3, + 4, + ( SELECT player FROM players WHERE nick='Jka' ), + 2, + ( SELECT song FROM songs WHERE lower(title)=lower('My Summer Love') ), + 'single', + 'expert', + 'f', + 8036); +INSERT INTO scores ( tournament, round, parallel, player, songnumber, song, playmode, difficulty, chosen, score ) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European PG Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )), + 2, + 7, + ( SELECT player FROM players WHERE nick='Jka' ), + 2, + ( SELECT song FROM songs WHERE lower(title)=lower('Stomp') ), + 'single', + 'expert', + 'f', + 6173); +INSERT INTO scores ( tournament, round, parallel, player, songnumber, song, playmode, difficulty, chosen, score ) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European PG Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )), + 3, + 4, + ( SELECT player FROM players WHERE nick='Jka' ), + 1, + ( SELECT song FROM songs WHERE lower(title)=lower('I Want You to Want Me') ), + 'single', + 'expert', + 'f', + 5767); +INSERT INTO scores ( tournament, round, parallel, player, songnumber, song, playmode, difficulty, chosen, score ) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European PG Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )), + 2, + 1, + ( SELECT player FROM players WHERE nick='Ryouko' ), + 3, + ( SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)') ), + 'single', + 'expert', + 't', + 7611); +INSERT INTO scores ( tournament, round, parallel, player, songnumber, song, playmode, difficulty, chosen, score ) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European PG Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )), + 2, + 1, + ( SELECT player FROM players WHERE nick='Ryouko' ), + 2, + ( SELECT song FROM songs WHERE lower(title)=lower('Dynamite Rave') ), + 'single', + 'expert', + 'f', + 7042); +INSERT INTO scores ( tournament, round, parallel, player, songnumber, song, playmode, difficulty, chosen, score ) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European PG Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )), + 1, + 0, + ( SELECT player FROM players WHERE nick='Ryouko' ), + 1, + ( SELECT song FROM songs WHERE lower(title)=lower('era (nostalmix)') ), + 'single', + 'expert', + 'f', + 6244); +INSERT INTO scores ( tournament, round, parallel, player, songnumber, song, playmode, difficulty, chosen, score ) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European PG Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )), + 2, + 1, + ( SELECT player FROM players WHERE nick='Ryouko' ), + 1, + ( SELECT song FROM songs WHERE lower(title)=lower('Let the Beat Hit \'em!') ), + 'single', + 'expert', + 'f', + 6051); +INSERT INTO scores ( tournament, round, parallel, player, songnumber, song, playmode, difficulty, chosen, score ) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European PG Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )), + 2, + 2, + ( SELECT player FROM players WHERE nick='Tsung' ), + 2, + ( SELECT song FROM songs WHERE lower(title)=lower('Afronova') ), + 'single', + 'expert', + 'f', + 6186); +INSERT INTO scores ( tournament, round, parallel, player, songnumber, song, playmode, difficulty, chosen, score ) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European PG Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )), + 2, + 2, + ( SELECT player FROM players WHERE nick='Tsung' ), + 3, + ( SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)') ), + 'single', + 'expert', + 't', + 6781); +INSERT INTO scores ( tournament, round, parallel, player, songnumber, song, playmode, difficulty, chosen, score ) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European PG Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )), + 1, + 0, + ( SELECT player FROM players WHERE nick='Tsung' ), + 1, + ( SELECT song FROM songs WHERE lower(title)=lower('era (nostalmix)') ), + 'single', + 'expert', + 'f', + 6360); +INSERT INTO scores ( tournament, round, parallel, player, songnumber, song, playmode, difficulty, chosen, score ) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European PG Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )), + 2, + 2, + ( SELECT player FROM players WHERE nick='Tsung' ), + 1, + ( SELECT song FROM songs WHERE lower(title)=lower('Love You Like A Fool') ), + 'single', + 'expert', + 'f', + 5893); +INSERT INTO scores ( tournament, round, parallel, player, songnumber, song, playmode, difficulty, chosen, score ) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European PG Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )), + 2, + 11, + ( SELECT player FROM players WHERE nick='Skazi' ), + 2, + ( SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)') ), + 'single', + 'expert', + 'f', + 8760); +INSERT INTO scores ( tournament, round, parallel, player, songnumber, song, playmode, difficulty, chosen, score ) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European PG Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )), + 2, + 11, + ( SELECT player FROM players WHERE nick='Skazi' ), + 1, + ( SELECT song FROM songs WHERE lower(title)=lower('20th November') ), + 'single', + 'expert', + 'f', + 6706); +INSERT INTO scores ( tournament, round, parallel, player, songnumber, song, playmode, difficulty, chosen, score ) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European PG Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )), + 3, + 2, + ( SELECT player FROM players WHERE nick='Skazi' ), + 3, + ( SELECT song FROM songs WHERE lower(title)=lower('Max 300') ), + 'single', + 'expert', + 't', + 8124); +INSERT INTO scores ( tournament, round, parallel, player, songnumber, song, playmode, difficulty, chosen, score ) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European PG Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )), + 2, + 11, + ( SELECT player FROM players WHERE nick='Skazi' ), + 3, + ( SELECT song FROM songs WHERE lower(title)=lower('Crash!') ), + 'single', + 'expert', + 't', + 8887); +INSERT INTO scores ( tournament, round, parallel, player, songnumber, song, playmode, difficulty, chosen, score ) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European PG Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )), + 1, + 0, + ( SELECT player FROM players WHERE nick='Skazi' ), + 1, + ( SELECT song FROM songs WHERE lower(title)=lower('era (nostalmix)') ), + 'single', + 'expert', + 'f', + 7620); +INSERT INTO scores ( tournament, round, parallel, player, songnumber, song, playmode, difficulty, chosen, score ) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European PG Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )), + 3, + 2, + ( SELECT player FROM players WHERE nick='Skazi' ), + 1, + ( SELECT song FROM songs WHERE lower(title)=lower('Spin the Disc') ), + 'single', + 'expert', + 'f', + 7792); +INSERT INTO scores ( tournament, round, parallel, player, songnumber, song, playmode, difficulty, chosen, score ) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European PG Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )), + 3, + 2, + ( SELECT player FROM players WHERE nick='Skazi' ), + 2, + ( SELECT song FROM songs WHERE lower(title)=lower('That was Then, This is Now') ), + 'single', + 'expert', + 'f', + 5672); +INSERT INTO scores ( tournament, round, parallel, player, songnumber, song, playmode, difficulty, chosen, score ) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European PG Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )), + 2, + 11, + ( SELECT player FROM players WHERE nick='Jukeboksi' ), + 2, + ( SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)') ), + 'single', + 'expert', + 'f', + 8655); +INSERT INTO scores ( tournament, round, parallel, player, songnumber, song, playmode, difficulty, chosen, score ) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European PG Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )), + 2, + 11, + ( SELECT player FROM players WHERE nick='Jukeboksi' ), + 1, + ( SELECT song FROM songs WHERE lower(title)=lower('20th November') ), + 'single', + 'expert', + 'f', + 6751); +INSERT INTO scores ( tournament, round, parallel, player, songnumber, song, playmode, difficulty, chosen, score ) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European PG Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )), + 2, + 11, + ( SELECT player FROM players WHERE nick='Jukeboksi' ), + 3, + ( SELECT song FROM songs WHERE lower(title)=lower('Max 300') ), + 'single', + 'expert', + 't', + 8181); +INSERT INTO scores ( tournament, round, parallel, player, songnumber, song, playmode, difficulty, chosen, score ) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European PG Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )), + 1, + 0, + ( SELECT player FROM players WHERE nick='Jukeboksi' ), + 1, + ( SELECT song FROM songs WHERE lower(title)=lower('era (nostalmix)') ), + 'single', + 'expert', + 'f', + 7138); +INSERT INTO scores ( tournament, round, parallel, player, songnumber, song, playmode, difficulty, chosen, score ) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European PG Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )), + 5, + 0, + ( SELECT player FROM players WHERE nick='Stelisevil' ), + 2, + ( SELECT song FROM songs WHERE lower(title)=lower('PARANOiA Rebirth') ), + 'single', + 'expert', + 't', + 8881); +INSERT INTO scores ( tournament, round, parallel, player, songnumber, song, playmode, difficulty, chosen, score ) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European PG Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )), + 3, + 1, + ( SELECT player FROM players WHERE nick='Stelisevil' ), + 2, + ( SELECT song FROM songs WHERE lower(title)=lower('Love This Feelin\'') ), + 'single', + 'expert', + 'f', + 7705); +INSERT INTO scores ( tournament, round, parallel, player, songnumber, song, playmode, difficulty, chosen, score ) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European PG Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )), + 3, + 1, + ( SELECT player FROM players WHERE nick='Stelisevil' ), + 1, + ( SELECT song FROM songs WHERE lower(title)=lower('Luv to Me (AMD Mix)') ), + 'single', + 'expert', + 'f', + 7869); +INSERT INTO scores ( tournament, round, parallel, player, songnumber, song, playmode, difficulty, chosen, score ) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European PG Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )), + 8, + 0, + ( SELECT player FROM players WHERE nick='Stelisevil' ), + 1, + ( SELECT song FROM songs WHERE lower(title)=lower('Make A Jam!') ), + 'single', + 'expert', + 'f', + 6850); +INSERT INTO scores ( tournament, round, parallel, player, songnumber, song, playmode, difficulty, chosen, score ) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European PG Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )), + 8, + 0, + ( SELECT player FROM players WHERE nick='Stelisevil' ), + 2, + ( SELECT song FROM songs WHERE lower(title)=lower('Max 300') ), + 'single', + 'expert', + 't', + 9140); +INSERT INTO scores ( tournament, round, parallel, player, songnumber, song, playmode, difficulty, chosen, score ) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European PG Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )), + 6, + 0, + ( SELECT player FROM players WHERE nick='Stelisevil' ), + 1, + ( SELECT song FROM songs WHERE lower(title)=lower('Healing Vision (Angelic Mix)') ), + 'single', + 'expert', + 'f', + 8724); +INSERT INTO scores ( tournament, round, parallel, player, songnumber, song, playmode, difficulty, chosen, score ) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European PG Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )), + 6, + 0, + ( SELECT player FROM players WHERE nick='Stelisevil' ), + 2, + ( SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)') ), + 'single', + 'expert', + 't', + 8771); +INSERT INTO scores ( tournament, round, parallel, player, songnumber, song, playmode, difficulty, chosen, score ) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European PG Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )), + 4, + 0, + ( SELECT player FROM players WHERE nick='Stelisevil' ), + 2, + ( SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love (SPEED MIX)') ), + 'single', + 'expert', + 't', + 8852); +INSERT INTO scores ( tournament, round, parallel, player, songnumber, song, playmode, difficulty, chosen, score ) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European PG Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )), + 9, + 0, + ( SELECT player FROM players WHERE nick='Stelisevil' ), + 2, + ( SELECT song FROM songs WHERE lower(title)=lower('Exotic Ethnic') ), + 'single', + 'expert', + 't', + 8903); +INSERT INTO scores ( tournament, round, parallel, player, songnumber, song, playmode, difficulty, chosen, score ) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European PG Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )), + 7, + 0, + ( SELECT player FROM players WHERE nick='Stelisevil' ), + 2, + ( SELECT song FROM songs WHERE lower(title)=lower('Crash!') ), + 'single', + 'expert', + 't', + 8852); +INSERT INTO scores ( tournament, round, parallel, player, songnumber, song, playmode, difficulty, chosen, score ) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European PG Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )), + 3, + 1, + ( SELECT player FROM players WHERE nick='Stelisevil' ), + 3, + ( SELECT song FROM songs WHERE lower(title)=lower('Candy☆') ), + 'single', + 'expert', + 't', + 7912); +INSERT INTO scores ( tournament, round, parallel, player, songnumber, song, playmode, difficulty, chosen, score ) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European PG Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )), + 1, + 0, + ( SELECT player FROM players WHERE nick='Stelisevil' ), + 1, + ( SELECT song FROM songs WHERE lower(title)=lower('era (nostalmix)') ), + 'single', + 'expert', + 'f', + 7726); +INSERT INTO scores ( tournament, round, parallel, player, songnumber, song, playmode, difficulty, chosen, score ) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European PG Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )), + 9, + 0, + ( SELECT player FROM players WHERE nick='Stelisevil' ), + 1, + ( SELECT song FROM songs WHERE lower(title)=lower('My Summer Love') ), + 'single', + 'expert', + 'f', + 8025); +INSERT INTO scores ( tournament, round, parallel, player, songnumber, song, playmode, difficulty, chosen, score ) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European PG Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )), + 2, + 5, + ( SELECT player FROM players WHERE nick='Stelisevil' ), + 3, + ( SELECT song FROM songs WHERE lower(title)=lower('Spin the Disc') ), + 'single', + 'expert', + 't', + 7910); +INSERT INTO scores ( tournament, round, parallel, player, songnumber, song, playmode, difficulty, chosen, score ) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European PG Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )), + 4, + 0, + ( SELECT player FROM players WHERE nick='Stelisevil' ), + 1, + ( SELECT song FROM songs WHERE lower(title)=lower('Remember You') ), + 'single', + 'expert', + 'f', + 4719); +INSERT INTO scores ( tournament, round, parallel, player, songnumber, song, playmode, difficulty, chosen, score ) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European PG Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )), + 5, + 0, + ( SELECT player FROM players WHERE nick='Stelisevil' ), + 1, + ( SELECT song FROM songs WHERE lower(title)=lower('Nori Nori Nori') ), + 'single', + 'expert', + 'f', + 6784); +INSERT INTO scores ( tournament, round, parallel, player, songnumber, song, playmode, difficulty, chosen, score ) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European PG Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )), + 2, + 5, + ( SELECT player FROM players WHERE nick='Stelisevil' ), + 1, + ( SELECT song FROM songs WHERE lower(title)=lower('The Reflex') ), + 'single', + 'expert', + 'f', + 7522); +INSERT INTO scores ( tournament, round, parallel, player, songnumber, song, playmode, difficulty, chosen, score ) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European PG Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )), + 2, + 5, + ( SELECT player FROM players WHERE nick='Stelisevil' ), + 2, + ( SELECT song FROM songs WHERE lower(title)=lower('The Centre of the Heart (Stonebridge Club Mix)') ), + 'single', + 'expert', + 'f', + 6790); +INSERT INTO scores ( tournament, round, parallel, player, songnumber, song, playmode, difficulty, chosen, score ) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European PG Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )), + 7, + 0, + ( SELECT player FROM players WHERE nick='Stelisevil' ), + 1, + ( SELECT song FROM songs WHERE lower(title)=lower('The Centre of the Heart (Stonebridge Club Mix)') ), + 'single', + 'expert', + 'f', + 6872); +INSERT INTO scores ( tournament, round, parallel, player, songnumber, song, playmode, difficulty, chosen, score ) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European PG Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )), + 2, + 1, + ( SELECT player FROM players WHERE nick='Elias' ), + 2, + ( SELECT song FROM songs WHERE lower(title)=lower('Dynamite Rave') ), + 'single', + 'expert', + 'f', + 8055); +INSERT INTO scores ( tournament, round, parallel, player, songnumber, song, playmode, difficulty, chosen, score ) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European PG Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )), + 3, + 3, + ( SELECT player FROM players WHERE nick='Elias' ), + 3, + ( SELECT song FROM songs WHERE lower(title)=lower('Max 300') ), + 'single', + 'expert', + 't', + 8444); +INSERT INTO scores ( tournament, round, parallel, player, songnumber, song, playmode, difficulty, chosen, score ) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European PG Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )), + 2, + 1, + ( SELECT player FROM players WHERE nick='Elias' ), + 3, + ( SELECT song FROM songs WHERE lower(title)=lower('Crash!') ), + 'single', + 'expert', + 't', + 8632); +INSERT INTO scores ( tournament, round, parallel, player, songnumber, song, playmode, difficulty, chosen, score ) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European PG Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )), + 1, + 0, + ( SELECT player FROM players WHERE nick='Elias' ), + 1, + ( SELECT song FROM songs WHERE lower(title)=lower('era (nostalmix)') ), + 'single', + 'expert', + 'f', + 7417); +INSERT INTO scores ( tournament, round, parallel, player, songnumber, song, playmode, difficulty, chosen, score ) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European PG Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )), + 3, + 3, + ( SELECT player FROM players WHERE nick='Elias' ), + 1, + ( SELECT song FROM songs WHERE lower(title)=lower('B4U') ), + 'single', + 'expert', + 'f', + 7607); +INSERT INTO scores ( tournament, round, parallel, player, songnumber, song, playmode, difficulty, chosen, score ) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European PG Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )), + 2, + 1, + ( SELECT player FROM players WHERE nick='Elias' ), + 1, + ( SELECT song FROM songs WHERE lower(title)=lower('Let the Beat Hit \'em!') ), + 'single', + 'expert', + 'f', + 6780); +INSERT INTO scores ( tournament, round, parallel, player, songnumber, song, playmode, difficulty, chosen, score ) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European PG Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )), + 3, + 3, + ( SELECT player FROM players WHERE nick='Elias' ), + 2, + ( SELECT song FROM songs WHERE lower(title)=lower('Caribbean Queen') ), + 'single', + 'expert', + 'f', + 6350); +INSERT INTO scores ( tournament, round, parallel, player, songnumber, song, playmode, difficulty, chosen, score ) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European PG Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )), + 3, + 6, + ( SELECT player FROM players WHERE nick='Milk' ), + 1, + ( SELECT song FROM songs WHERE lower(title)=lower('Silent Hill') ), + 'single', + 'expert', + 'f', + 6715); +INSERT INTO scores ( tournament, round, parallel, player, songnumber, song, playmode, difficulty, chosen, score ) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European PG Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )), + 2, + 6, + ( SELECT player FROM players WHERE nick='Milk' ), + 1, + ( SELECT song FROM songs WHERE lower(title)=lower('Let Them Move') ), + 'single', + 'expert', + 'f', + 6574); +INSERT INTO scores ( tournament, round, parallel, player, songnumber, song, playmode, difficulty, chosen, score ) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European PG Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )), + 3, + 6, + ( SELECT player FROM players WHERE nick='Milk' ), + 3, + ( SELECT song FROM songs WHERE lower(title)=lower('Tsugaru') ), + 'single', + 'expert', + 't', + 8423); +INSERT INTO scores ( tournament, round, parallel, player, songnumber, song, playmode, difficulty, chosen, score ) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European PG Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )), + 3, + 6, + ( SELECT player FROM players WHERE nick='Milk' ), + 2, + ( SELECT song FROM songs WHERE lower(title)=lower('DXY!') ), + 'single', + 'expert', + 'f', + 6972); +INSERT INTO scores ( tournament, round, parallel, player, songnumber, song, playmode, difficulty, chosen, score ) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European PG Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )), + 2, + 6, + ( SELECT player FROM players WHERE nick='Milk' ), + 3, + ( SELECT song FROM songs WHERE lower(title)=lower('Crash!') ), + 'single', + 'expert', + 't', + 8747); +INSERT INTO scores ( tournament, round, parallel, player, songnumber, song, playmode, difficulty, chosen, score ) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European PG Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )), + 1, + 0, + ( SELECT player FROM players WHERE nick='Milk' ), + 1, + ( SELECT song FROM songs WHERE lower(title)=lower('era (nostalmix)') ), + 'single', + 'expert', + 'f', + 7236); +INSERT INTO scores ( tournament, round, parallel, player, songnumber, song, playmode, difficulty, chosen, score ) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European PG Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )), + 2, + 6, + ( SELECT player FROM players WHERE nick='Milk' ), + 2, + ( SELECT song FROM songs WHERE lower(title)=lower('Look to the Sky') ), + 'single', + 'expert', + 'f', + 6587); +INSERT INTO scores ( tournament, round, parallel, player, songnumber, song, playmode, difficulty, chosen, score ) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European PG Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )), + 3, + 6, + ( SELECT player FROM players WHERE nick='T_Bone_X_Zeo' ), + 3, + ( SELECT song FROM songs WHERE lower(title)=lower('PARANOiA Rebirth') ), + 'single', + 'expert', + 't', + 8794); +INSERT INTO scores ( tournament, round, parallel, player, songnumber, song, playmode, difficulty, chosen, score ) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European PG Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )), + 5, + 0, + ( SELECT player FROM players WHERE nick='T_Bone_X_Zeo' ), + 2, + ( SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)') ), + 'single', + 'expert', + 't', + 8801); +INSERT INTO scores ( tournament, round, parallel, player, songnumber, song, playmode, difficulty, chosen, score ) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European PG Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )), + 2, + 6, + ( SELECT player FROM players WHERE nick='T_Bone_X_Zeo' ), + 3, + ( SELECT song FROM songs WHERE lower(title)=lower('Dynamite Rave') ), + 'single', + 'expert', + 't', + 8822); +INSERT INTO scores ( tournament, round, parallel, player, songnumber, song, playmode, difficulty, chosen, score ) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European PG Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )), + 3, + 6, + ( SELECT player FROM players WHERE nick='T_Bone_X_Zeo' ), + 1, + ( SELECT song FROM songs WHERE lower(title)=lower('Silent Hill') ), + 'single', + 'expert', + 'f', + 6839); +INSERT INTO scores ( tournament, round, parallel, player, songnumber, song, playmode, difficulty, chosen, score ) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European PG Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )), + 2, + 6, + ( SELECT player FROM players WHERE nick='T_Bone_X_Zeo' ), + 1, + ( SELECT song FROM songs WHERE lower(title)=lower('Let Them Move') ), + 'single', + 'expert', + 'f', + 6793); +INSERT INTO scores ( tournament, round, parallel, player, songnumber, song, playmode, difficulty, chosen, score ) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European PG Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )), + 7, + 0, + ( SELECT player FROM players WHERE nick='T_Bone_X_Zeo' ), + 2, + ( SELECT song FROM songs WHERE lower(title)=lower('Max 300') ), + 'single', + 'expert', + 't', + 8591); +INSERT INTO scores ( tournament, round, parallel, player, songnumber, song, playmode, difficulty, chosen, score ) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European PG Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )), + 6, + 0, + ( SELECT player FROM players WHERE nick='T_Bone_X_Zeo' ), + 1, + ( SELECT song FROM songs WHERE lower(title)=lower('Healing Vision (Angelic Mix)') ), + 'single', + 'expert', + 'f', + 8913); +INSERT INTO scores ( tournament, round, parallel, player, songnumber, song, playmode, difficulty, chosen, score ) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European PG Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )), + 4, + 0, + ( SELECT player FROM players WHERE nick='T_Bone_X_Zeo' ), + 2, + ( SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love (SPEED MIX)') ), + 'single', + 'expert', + 't', + 8903); +INSERT INTO scores ( tournament, round, parallel, player, songnumber, song, playmode, difficulty, chosen, score ) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European PG Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )), + 3, + 6, + ( SELECT player FROM players WHERE nick='T_Bone_X_Zeo' ), + 2, + ( SELECT song FROM songs WHERE lower(title)=lower('DXY!') ), + 'single', + 'expert', + 'f', + 7706); +INSERT INTO scores ( tournament, round, parallel, player, songnumber, song, playmode, difficulty, chosen, score ) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European PG Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )), + 6, + 0, + ( SELECT player FROM players WHERE nick='T_Bone_X_Zeo' ), + 2, + ( SELECT song FROM songs WHERE lower(title)=lower('Crash!') ), + 'single', + 'expert', + 't', + 8731); +INSERT INTO scores ( tournament, round, parallel, player, songnumber, song, playmode, difficulty, chosen, score ) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European PG Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )), + 1, + 0, + ( SELECT player FROM players WHERE nick='T_Bone_X_Zeo' ), + 1, + ( SELECT song FROM songs WHERE lower(title)=lower('era (nostalmix)') ), + 'single', + 'expert', + 'f', + 7707); +INSERT INTO scores ( tournament, round, parallel, player, songnumber, song, playmode, difficulty, chosen, score ) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European PG Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )), + 2, + 6, + ( SELECT player FROM players WHERE nick='T_Bone_X_Zeo' ), + 2, + ( SELECT song FROM songs WHERE lower(title)=lower('Look to the Sky') ), + 'single', + 'expert', + 'f', + 6754); +INSERT INTO scores ( tournament, round, parallel, player, songnumber, song, playmode, difficulty, chosen, score ) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European PG Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )), + 4, + 0, + ( SELECT player FROM players WHERE nick='T_Bone_X_Zeo' ), + 1, + ( SELECT song FROM songs WHERE lower(title)=lower('Remember You') ), + 'single', + 'expert', + 'f', + 4621); +INSERT INTO scores ( tournament, round, parallel, player, songnumber, song, playmode, difficulty, chosen, score ) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European PG Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )), + 5, + 0, + ( SELECT player FROM players WHERE nick='T_Bone_X_Zeo' ), + 1, + ( SELECT song FROM songs WHERE lower(title)=lower('Nori Nori Nori') ), + 'single', + 'expert', + 'f', + 6734); +INSERT INTO scores ( tournament, round, parallel, player, songnumber, song, playmode, difficulty, chosen, score ) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European PG Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )), + 7, + 0, + ( SELECT player FROM players WHERE nick='T_Bone_X_Zeo' ), + 1, + ( SELECT song FROM songs WHERE lower(title)=lower('The Centre of the Heart (Stonebridge Club Mix)') ), + 'single', + 'expert', + 'f', + 6730); +INSERT INTO scores ( tournament, round, parallel, player, songnumber, song, playmode, difficulty, chosen, score ) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European PG Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )), + 2, + 12, + ( SELECT player FROM players WHERE nick='Smooth' ), + 3, + ( SELECT song FROM songs WHERE lower(title)=lower('PARANOiA Rebirth') ), + 'single', + 'expert', + 't', + 8613); +INSERT INTO scores ( tournament, round, parallel, player, songnumber, song, playmode, difficulty, chosen, score ) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European PG Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )), + 3, + 2, + ( SELECT player FROM players WHERE nick='Smooth' ), + 3, + ( SELECT song FROM songs WHERE lower(title)=lower('Max 300') ), + 'single', + 'expert', + 't', + 8873); +INSERT INTO scores ( tournament, round, parallel, player, songnumber, song, playmode, difficulty, chosen, score ) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European PG Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )), + 1, + 0, + ( SELECT player FROM players WHERE nick='Smooth' ), + 1, + ( SELECT song FROM songs WHERE lower(title)=lower('era (nostalmix)') ), + 'single', + 'expert', + 'f', + 7642); +INSERT INTO scores ( tournament, round, parallel, player, songnumber, song, playmode, difficulty, chosen, score ) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European PG Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )), + 2, + 12, + ( SELECT player FROM players WHERE nick='Smooth' ), + 1, + ( SELECT song FROM songs WHERE lower(title)=lower('Groove 2001') ), + 'single', + 'expert', + 'f', + 6414); +INSERT INTO scores ( tournament, round, parallel, player, songnumber, song, playmode, difficulty, chosen, score ) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European PG Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )), + 3, + 2, + ( SELECT player FROM players WHERE nick='Smooth' ), + 1, + ( SELECT song FROM songs WHERE lower(title)=lower('Spin the Disc') ), + 'single', + 'expert', + 'f', + 7831); +INSERT INTO scores ( tournament, round, parallel, player, songnumber, song, playmode, difficulty, chosen, score ) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European PG Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )), + 2, + 12, + ( SELECT player FROM players WHERE nick='Smooth' ), + 2, + ( SELECT song FROM songs WHERE lower(title)=lower('Never Ending Story') ), + 'single', + 'expert', + 'f', + 6435); +INSERT INTO scores ( tournament, round, parallel, player, songnumber, song, playmode, difficulty, chosen, score ) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European PG Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )), + 3, + 2, + ( SELECT player FROM players WHERE nick='Smooth' ), + 2, + ( SELECT song FROM songs WHERE lower(title)=lower('That was Then, This is Now') ), + 'single', + 'expert', + 'f', + 5615); +INSERT INTO scores ( tournament, round, parallel, player, songnumber, song, playmode, difficulty, chosen, score ) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European PG Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )), + 2, + 10, + ( SELECT player FROM players WHERE nick='stuf' ), + 3, + ( SELECT song FROM songs WHERE lower(title)=lower('Afronova Primeval') ), + 'single', + 'expert', + 't', + 7764); +INSERT INTO scores ( tournament, round, parallel, player, songnumber, song, playmode, difficulty, chosen, score ) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European PG Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )), + 1, + 0, + ( SELECT player FROM players WHERE nick='stuf' ), + 1, + ( SELECT song FROM songs WHERE lower(title)=lower('era (nostalmix)') ), + 'single', + 'expert', + 'f', + 7159); +INSERT INTO scores ( tournament, round, parallel, player, songnumber, song, playmode, difficulty, chosen, score ) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European PG Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )), + 2, + 10, + ( SELECT player FROM players WHERE nick='stuf' ), + 1, + ( SELECT song FROM songs WHERE lower(title)=lower('D2R') ), + 'single', + 'expert', + 'f', + 5822); +INSERT INTO scores ( tournament, round, parallel, player, songnumber, song, playmode, difficulty, chosen, score ) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European PG Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )), + 2, + 10, + ( SELECT player FROM players WHERE nick='stuf' ), + 2, + ( SELECT song FROM songs WHERE lower(title)=lower('Spin the Disc') ), + 'single', + 'expert', + 'f', + 7295); +commit; -- 2.39.2