UPDATE players SET country=( SELECT country FROM countries WHERE countrycode='ITA' ) WHERE nick IN
	('Dex', 'Lion');
UPDATE players SET country=( SELECT country FROM countries WHERE countrycode='GBR' ) WHERE nick IN
	('Stelisevil', 'Ryosuke', 'Healingvizion');
UPDATE players SET country=( SELECT country FROM countries WHERE countrycode='ESP' ) WHERE nick IN
	('Elias');
UPDATE players SET country=( SELECT country FROM countries WHERE countrycode='SWE' ) WHERE nick IN
	('Milk', 'Yuna-chan', 'Cyberg', 'Puck', 'Kogepan', 'Steel');
UPDATE players SET country=( SELECT country FROM countries WHERE countrycode='FRA' ) WHERE nick IN
	('sd-koala', 'William');
UPDATE players SET country=( SELECT country FROM countries WHERE countrycode='NED' ) WHERE nick IN
	('T_Bone_X_Zeo', 'Lurisoft', 'LF');
UPDATE players SET country=( SELECT country FROM countries WHERE countrycode='FIN' ) WHERE nick IN
	('Smooth', 'stuf', 'Tazze');
UPDATE players SET country=( SELECT country FROM countries WHERE countrycode='GER' ) WHERE nick IN
	('Tiger Yoshiki');
UPDATE players SET country=( SELECT country FROM countries WHERE countrycode='BEL' ) WHERE nick IN
	('Lu');

