1 UPDATE players SET country=( SELECT country FROM countries WHERE countrycode='ITA' ) WHERE nick IN
3 UPDATE players SET country=( SELECT country FROM countries WHERE countrycode='GBR' ) WHERE nick IN
4 ('Stelisevil', 'Ryosuke', 'Healingvizion', 'Nanaki Lioness', 'Sensei', 'ChocoboGhost', 'Afronova', 'Neomancer', 'Usagi', 'Lawrence');
5 UPDATE players SET country=( SELECT country FROM countries WHERE countrycode='ESP' ) WHERE nick IN
7 UPDATE players SET country=( SELECT country FROM countries WHERE countrycode='SWE' ) WHERE nick IN
8 ('Milk', 'Yuna-chan', 'Cyberg', 'Puck', 'Kogepan', 'Steel');
9 UPDATE players SET country=( SELECT country FROM countries WHERE countrycode='FRA' ) WHERE nick IN
10 ('sd-koala', 'William');
11 UPDATE players SET country=( SELECT country FROM countries WHERE countrycode='NED' ) WHERE nick IN
12 ('T_Bone_X_Zeo', 'Lurisoft', 'LF');
13 UPDATE players SET country=( SELECT country FROM countries WHERE countrycode='FIN' ) WHERE nick IN
14 ('Smooth', 'stuf', 'Tazze');
15 UPDATE players SET country=( SELECT country FROM countries WHERE countrycode='GER' ) WHERE nick IN
17 UPDATE players SET country=( SELECT country FROM countries WHERE countrycode='BEL' ) WHERE nick IN