-- phpMyAdmin SQL Dump
-- version 2.11.8.1deb5
-- http://www.phpmyadmin.net
--
-- Host: localhost
-- Erstellungszeit: 07. Juni 2009 um 15:08
-- Server Version: 5.1.34
-- PHP-Version: 5.2.9-0.dotdeb.2

SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";


/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;

--
-- Datenbank: `WM2006`
--

-- --------------------------------------------------------

--
-- Tabellenstruktur für Tabelle `leitet`
--

CREATE TABLE IF NOT EXISTS `leitet` (
  `SpielID` int(11) NOT NULL DEFAULT '0',
  `SID` int(11) NOT NULL DEFAULT '0',
  `Funktion` varchar(20) DEFAULT NULL,
  PRIMARY KEY (`SpielID`,`SID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Daten für Tabelle `leitet`
--

INSERT INTO `leitet` (`SpielID`, `SID`, `Funktion`) VALUES
(1, 1166, 'Asst. Ref. 2'),
(1, 1808, 'Fifth Official'),
(1, 38922, 'Referee'),
(1, 41417, 'Asst. Ref. 1'),
(1, 179950, 'Fourth Official'),
(2, 38366, 'Fourth Official'),
(2, 38753, 'Asst. Ref. 1'),
(2, 173532, 'Referee'),
(2, 173582, 'Asst. Ref. 2'),
(2, 196337, 'Fifth Official'),
(3, 1603, 'Referee'),
(3, 38639, 'Fourth Official'),
(3, 42856, 'Fifth Official'),
(3, 179866, 'Asst. Ref. 2'),
(3, 220525, 'Asst. Ref. 1'),
(4, 39989, 'Fourth Official'),
(4, 40190, 'Asst. Ref. 1'),
(4, 41323, 'Referee'),
(4, 180116, 'Fifth Official'),
(4, 187502, 'Asst. Ref. 2'),
(5, 1535, 'Fourth Official'),
(5, 1745, 'Fifth Official'),
(5, 173269, 'Referee'),
(5, 195786, 'Asst. Ref. 1'),
(5, 221380, 'Asst. Ref. 2'),
(6, 34920, 'Referee'),
(6, 39668, 'Fifth Official'),
(6, 42745, 'Fourth Official'),
(6, 173449, 'Asst. Ref. 1'),
(6, 175911, 'Asst. Ref. 2'),
(7, 176433, 'Fourth Official'),
(7, 176435, 'Fifth Official'),
(7, 187122, 'Referee'),
(7, 196240, 'Asst. Ref. 2'),
(7, 207013, 'Asst. Ref. 1'),
(8, 1814, 'Asst. Ref. 1'),
(8, 40229, 'Fourth Official'),
(8, 173372, 'Referee'),
(8, 180137, 'Asst. Ref. 2'),
(8, 187348, 'Fifth Official'),
(9, 1140, 'Referee'),
(9, 1168, 'Asst. Ref. 1'),
(9, 42786, 'Asst. Ref. 2'),
(9, 43113, 'Fifth Official'),
(9, 196839, 'Fourth Official'),
(10, 1812, 'Asst. Ref. 2'),
(10, 42681, 'Fifth Official'),
(10, 42758, 'Referee'),
(10, 179950, 'Fourth Official'),
(10, 179958, 'Asst. Ref. 1'),
(11, 1866, 'Asst. Ref. 1'),
(11, 37427, 'Asst. Ref. 2'),
(11, 37556, 'Referee'),
(11, 39668, 'Fifth Official'),
(11, 42745, 'Fourth Official'),
(12, 1535, 'Fourth Official'),
(12, 1745, 'Fifth Official'),
(12, 1883, 'Asst. Ref. 2'),
(12, 37682, 'Asst. Ref. 1'),
(12, 71992, 'Referee'),
(13, 37294, 'Referee'),
(13, 39972, 'Asst. Ref. 2'),
(13, 40210, 'Fifth Official'),
(13, 40229, 'Fourth Official'),
(13, 196358, 'Asst. Ref. 1'),
(14, 38978, 'Fifth Official'),
(14, 40880, 'Referee'),
(14, 43053, 'Asst. Ref. 1'),
(14, 176433, 'Fourth Official'),
(14, 187084, 'Asst. Ref. 2'),
(15, 1135, 'Referee'),
(15, 176000, 'Asst. Ref. 2'),
(15, 180595, 'Asst. Ref. 1'),
(15, 187122, 'Fourth Official'),
(15, 207013, 'Fifth Official'),
(16, 1566, 'Referee'),
(16, 1808, 'Fifth Official'),
(16, 176406, 'Asst. Ref. 2'),
(16, 179950, 'Fourth Official'),
(16, 181134, 'Asst. Ref. 1'),
(17, 38769, 'Fifth Official'),
(17, 39996, 'Asst. Ref. 1'),
(17, 180591, 'Asst. Ref. 2'),
(17, 187224, 'Referee'),
(17, 196839, 'Fourth Official'),
(18, 35265, 'Asst. Ref. 2'),
(18, 38639, 'Referee'),
(18, 39668, 'Fifth Official'),
(18, 42745, 'Fourth Official'),
(18, 42856, 'Asst. Ref. 1'),
(19, 38753, 'Asst. Ref. 1'),
(19, 40229, 'Fourth Official'),
(19, 173532, 'Referee'),
(19, 173582, 'Asst. Ref. 2'),
(19, 187348, 'Fifth Official'),
(20, 38366, 'Referee'),
(20, 173356, 'Asst. Ref. 2'),
(20, 176433, 'Fourth Official'),
(20, 176435, 'Fifth Official'),
(20, 196337, 'Asst. Ref. 1'),
(21, 37682, 'Fifth Official'),
(21, 71992, 'Fourth Official'),
(21, 187122, 'Referee'),
(21, 196240, 'Asst. Ref. 2'),
(21, 207013, 'Asst. Ref. 1'),
(22, 1603, 'Fourth Official'),
(22, 39989, 'Referee'),
(22, 180116, 'Asst. Ref. 1'),
(22, 205965, 'Asst. Ref. 2'),
(22, 220525, 'Fifth Official'),
(23, 40190, 'Asst. Ref. 1'),
(23, 41323, 'Referee'),
(23, 42681, 'Fifth Official'),
(23, 179950, 'Fourth Official'),
(23, 187502, 'Asst. Ref. 2'),
(24, 1535, 'Referee'),
(24, 1745, 'Asst. Ref. 2'),
(24, 39668, 'Fifth Official'),
(24, 42745, 'Fourth Official'),
(24, 43064, 'Asst. Ref. 1'),
(25, 1814, 'Asst. Ref. 1'),
(25, 43113, 'Fifth Official'),
(25, 173372, 'Referee'),
(25, 180137, 'Asst. Ref. 2'),
(25, 196839, 'Fourth Official'),
(26, 1166, 'Asst. Ref. 2'),
(26, 38922, 'Referee'),
(26, 41417, 'Asst. Ref. 1'),
(26, 176433, 'Fourth Official'),
(26, 176435, 'Fifth Official'),
(27, 1603, 'Fourth Official'),
(27, 34920, 'Referee'),
(27, 173449, 'Asst. Ref. 1'),
(27, 175911, 'Asst. Ref. 2'),
(27, 179866, 'Fifth Official'),
(28, 40210, 'Fifth Official'),
(28, 40229, 'Fourth Official'),
(28, 173269, 'Referee'),
(28, 195786, 'Asst. Ref. 1'),
(28, 221380, 'Asst. Ref. 2'),
(29, 1866, 'Asst. Ref. 1'),
(29, 1883, 'Fifth Official'),
(29, 37427, 'Asst. Ref. 2'),
(29, 37556, 'Referee'),
(29, 71992, 'Fourth Official'),
(30, 1812, 'Asst. Ref. 2'),
(30, 39668, 'Fifth Official'),
(30, 42745, 'Fourth Official'),
(30, 42758, 'Referee'),
(30, 179958, 'Asst. Ref. 1'),
(31, 1140, 'Referee'),
(31, 1168, 'Asst. Ref. 1'),
(31, 1808, 'Fifth Official'),
(31, 42786, 'Asst. Ref. 2'),
(31, 179950, 'Fourth Official'),
(32, 38753, 'Fifth Official'),
(32, 40880, 'Referee'),
(32, 43053, 'Asst. Ref. 1'),
(32, 173532, 'Fourth Official'),
(32, 187084, 'Asst. Ref. 2'),
(33, 37294, 'Referee'),
(33, 39972, 'Asst. Ref. 2'),
(33, 40229, 'Fourth Official'),
(33, 187348, 'Fifth Official'),
(33, 196358, 'Asst. Ref. 1'),
(34, 38978, 'Fifth Official'),
(34, 40190, 'Asst. Ref. 1'),
(34, 41323, 'Referee'),
(34, 176433, 'Fourth Official'),
(34, 187502, 'Asst. Ref. 2'),
(35, 1135, 'Referee'),
(35, 38769, 'Fifth Official'),
(35, 176000, 'Asst. Ref. 2'),
(35, 180595, 'Asst. Ref. 1'),
(35, 196839, 'Fourth Official'),
(36, 173269, 'Fourth Official'),
(36, 187122, 'Referee'),
(36, 195786, 'Fifth Official'),
(36, 196240, 'Asst. Ref. 2'),
(36, 207013, 'Asst. Ref. 1'),
(37, 39996, 'Asst. Ref. 1'),
(37, 42681, 'Fifth Official'),
(37, 179950, 'Fourth Official'),
(37, 180591, 'Asst. Ref. 2'),
(37, 187224, 'Referee'),
(38, 1603, 'Referee'),
(38, 39668, 'Fifth Official'),
(38, 42745, 'Fourth Official'),
(38, 179866, 'Asst. Ref. 2'),
(38, 220525, 'Asst. Ref. 1'),
(39, 1883, 'Fifth Official'),
(39, 38366, 'Referee'),
(39, 71992, 'Fourth Official'),
(39, 173356, 'Asst. Ref. 2'),
(39, 196337, 'Asst. Ref. 1'),
(40, 1140, 'Fourth Official'),
(40, 1168, 'Fifth Official'),
(40, 1566, 'Referee'),
(40, 176406, 'Asst. Ref. 2'),
(40, 181134, 'Asst. Ref. 1'),
(41, 1866, 'Asst. Ref. 1'),
(41, 37427, 'Asst. Ref. 2'),
(41, 37556, 'Referee'),
(41, 39989, 'Fourth Official'),
(41, 205965, 'Fifth Official'),
(42, 34920, 'Referee'),
(42, 38753, 'Fifth Official'),
(42, 173449, 'Asst. Ref. 1'),
(42, 173532, 'Fourth Official'),
(42, 175911, 'Asst. Ref. 2'),
(43, 1535, 'Referee'),
(43, 1745, 'Asst. Ref. 2'),
(43, 43064, 'Asst. Ref. 1'),
(43, 176433, 'Fourth Official'),
(43, 176435, 'Fifth Official'),
(44, 40210, 'Fifth Official'),
(44, 40229, 'Fourth Official'),
(44, 40880, 'Referee'),
(44, 43053, 'Asst. Ref. 1'),
(44, 187084, 'Asst. Ref. 2'),
(45, 1814, 'Asst. Ref. 1'),
(45, 42681, 'Fifth Official'),
(45, 173372, 'Referee'),
(45, 179950, 'Fourth Official'),
(45, 180137, 'Asst. Ref. 2'),
(46, 1166, 'Asst. Ref. 2'),
(46, 37682, 'Fifth Official'),
(46, 38922, 'Referee'),
(46, 41417, 'Asst. Ref. 1'),
(46, 71992, 'Fourth Official'),
(47, 35265, 'Asst. Ref. 2'),
(47, 38639, 'Referee'),
(47, 39668, 'Fifth Official'),
(47, 42745, 'Fourth Official'),
(47, 42856, 'Asst. Ref. 1'),
(48, 1603, 'Fourth Official'),
(48, 1812, 'Asst. Ref. 2'),
(48, 42758, 'Referee'),
(48, 43113, 'Fifth Official'),
(48, 179958, 'Asst. Ref. 1'),
(49, 1140, 'Referee'),
(49, 1168, 'Asst. Ref. 1'),
(49, 40190, 'Fifth Official'),
(49, 41323, 'Fourth Official'),
(49, 42786, 'Asst. Ref. 2'),
(50, 1135, 'Referee'),
(50, 38769, 'Fifth Official'),
(50, 176000, 'Asst. Ref. 2'),
(50, 180595, 'Asst. Ref. 1'),
(50, 196839, 'Fourth Official'),
(51, 39989, 'Fourth Official'),
(51, 173269, 'Referee'),
(51, 195786, 'Asst. Ref. 1'),
(51, 205965, 'Fifth Official'),
(51, 221380, 'Asst. Ref. 2'),
(52, 1603, 'Fourth Official'),
(52, 37294, 'Referee'),
(52, 39972, 'Asst. Ref. 2'),
(52, 196358, 'Asst. Ref. 1'),
(52, 220525, 'Fifth Official'),
(53, 1535, 'Fourth Official'),
(53, 39996, 'Asst. Ref. 1'),
(53, 43064, 'Fifth Official'),
(53, 180591, 'Asst. Ref. 2'),
(53, 187224, 'Referee'),
(54, 1866, 'Asst. Ref. 1'),
(54, 37427, 'Asst. Ref. 2'),
(54, 37556, 'Referee'),
(54, 38978, 'Fifth Official'),
(54, 176433, 'Fourth Official'),
(55, 1566, 'Fourth Official'),
(55, 38366, 'Referee'),
(55, 173356, 'Asst. Ref. 2'),
(55, 181134, 'Fifth Official'),
(55, 196337, 'Asst. Ref. 1'),
(56, 34920, 'Fourth Official'),
(56, 173449, 'Fifth Official'),
(56, 187122, 'Referee'),
(56, 196240, 'Asst. Ref. 2'),
(56, 207013, 'Asst. Ref. 1'),
(57, 1135, 'Fourth Official'),
(57, 38366, 'Referee'),
(57, 173356, 'Asst. Ref. 2'),
(57, 180595, 'Fifth Official'),
(57, 196337, 'Asst. Ref. 1'),
(58, 38753, 'Fifth Official'),
(58, 173269, 'Referee'),
(58, 173532, 'Fourth Official'),
(58, 195786, 'Asst. Ref. 1'),
(58, 221380, 'Asst. Ref. 2'),
(59, 1166, 'Asst. Ref. 2'),
(59, 35265, 'Fifth Official'),
(59, 38639, 'Fourth Official'),
(59, 38922, 'Referee'),
(59, 41417, 'Asst. Ref. 1'),
(60, 1566, 'Fourth Official'),
(60, 39996, 'Asst. Ref. 1'),
(60, 176406, 'Fifth Official'),
(60, 180591, 'Asst. Ref. 2'),
(60, 187224, 'Referee'),
(61, 1866, 'Asst. Ref. 1'),
(61, 37427, 'Asst. Ref. 2'),
(61, 37556, 'Referee'),
(61, 38753, 'Fifth Official'),
(61, 173532, 'Fourth Official'),
(62, 1566, 'Fourth Official'),
(62, 1814, 'Asst. Ref. 1'),
(62, 173372, 'Referee'),
(62, 180137, 'Asst. Ref. 2'),
(62, 181134, 'Fifth Official'),
(63, 38639, 'Fourth Official'),
(63, 38753, 'Asst. Ref. 1'),
(63, 42856, 'Fifth Official'),
(63, 173532, 'Referee'),
(63, 173582, 'Asst. Ref. 2'),
(64, 1166, 'Asst. Ref. 2'),
(64, 38922, 'Referee'),
(64, 39996, 'Fifth Official'),
(64, 41417, 'Asst. Ref. 1'),
(64, 187224, 'Fourth Official');

-- --------------------------------------------------------

--
-- Tabellenstruktur für Tabelle `Mannschaften`
--

CREATE TABLE IF NOT EXISTS `Mannschaften` (
  `Land` varchar(40) NOT NULL,
  `Code` char(3) DEFAULT NULL,
  `Trainer` varchar(30) DEFAULT NULL,
  `Kontinent` varchar(40) DEFAULT NULL,
  `Gruppe` varchar(1) DEFAULT NULL,
  PRIMARY KEY (`Land`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Daten für Tabelle `Mannschaften`
--

INSERT INTO `Mannschaften` (`Land`, `Code`, `Trainer`, `Kontinent`, `Gruppe`) VALUES
('Angola', 'ang', 'DE OLIVEIRA GONCALVES Luis', 'Africa', 'D'),
('Argentina', 'arg', 'PEKERMAN Jose', 'South America', 'C'),
('Australia', 'aus', 'HIDDINK Guus', 'Oceania', 'F'),
('Brazil', 'bra', 'PARREIRA Carlos Alberto', 'South America', 'F'),
('Costa Rica', 'crc', 'GUIMARAES Alexandre', 'North, Central America and the Caribbean', 'A'),
('Cote d Ivoire', 'civ', 'MICHEL Henri', 'Africa', 'C'),
('Croatia', 'cro', 'KRANJCAR Zlatko', 'Europe', 'F'),
('Czech Republic', 'cze', 'BRUCKNER Karel', 'Europe', 'E'),
('Ecuador', 'ecu', 'SUAREZ Luis', 'South America', 'A'),
('England', 'eng', 'ERIKSSON Sven Goran', 'Europe', 'B'),
('France', 'fra', 'DOMENECH Raymond', 'Europe', 'G'),
('Germany', 'ger', 'KLINSMANN Juergen', 'Europe', 'A'),
('Ghana', 'gha', 'DUJKOVIC Ratomir', 'Africa', 'E'),
('Iran', 'irn', 'IVANKOVIC Branko', 'Asia', 'D'),
('Italy', 'ita', 'LIPPI Marcello', 'Europe', 'E'),
('Japan', 'jpn', 'ZICO', 'Asia', 'F'),
('Korea Republic', 'kor', 'ADVOCAAT Dick', 'Asia', 'G'),
('Mexico', 'mex', 'LA VOLPE Ricardo', 'North, Central America and the Caribbean', 'D'),
('Netherlands', 'ned', 'VAN BASTEN Marco', 'Europe', 'C'),
('Paraguay', 'par', 'RUIZ Anibal', 'South America', 'B'),
('Poland', 'pol', 'JANAS Pawel', 'Europe', 'A'),
('Portugal', 'por', 'SCOLARI Luiz Felipe', 'Europe', 'D'),
('Saudi Arabia', 'ksa', 'PAQUETA', 'Asia', 'H'),
('Serbia and Montenegro', 'scg', 'PETKOVIC Ilija', 'Europe', 'C'),
('Spain', 'esp', 'ARAGONES Luis', 'Europe', 'H'),
('Sweden', 'swe', 'LAGERBACK Lars', 'Europe', 'B'),
('Switzerland', 'sui', 'KUHN Koebi', 'Europe', 'G'),
('Togo', 'tog', 'PFISTER Otto', 'Africa', 'G'),
('Trinidad and Tobago', 'tri', 'BEENHAKKER Leo', 'North, Central America and the Caribbean', 'B'),
('Tunisia', 'tun', 'LEMERRE Roger', 'Africa', 'H'),
('Ukraine', 'ukr', 'BLOKHIN Oleg', 'Europe', 'H'),
('USA', 'usa', 'ARENA Bruce', 'North, Central America and the Caribbean', 'E');

-- --------------------------------------------------------

--
-- Tabellenstruktur für Tabelle `Schiedsrichter`
--

CREATE TABLE IF NOT EXISTS `Schiedsrichter` (
  `Funktion` varchar(30) DEFAULT NULL,
  `Name` varchar(30) DEFAULT NULL,
  `Nationalität` char(3) DEFAULT NULL,
  `SID` int(11) NOT NULL,
  PRIMARY KEY (`SID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Daten für Tabelle `Schiedsrichter`
--

INSERT INTO `Schiedsrichter` (`Funktion`, `Name`, `Nationalität`, `SID`) VALUES
('Referee', 'BUSACCA Massimo', 'SUI', 1135),
('Referee', 'SIMON Carlos', 'BRA', 1140),
('Assistant Referee', 'OTERO Rodolfo', 'ARG', 1166),
('Assistant Referee', 'TAVARES Aristeu', 'BRA', 1168),
('Referee', 'POULAT Eric', 'FRA', 1535),
('Referee', 'SHIELD Mark', 'AUS', 1566),
('Referee', 'RODRIGUEZ Marco', 'MEX', 1603),
('Assistant Referee', 'TEXIER Vincent', 'FRA', 1745),
('Assistant Referee', 'JULIO Cristian', 'CHI', 1808),
('Assistant Referee', 'BERNAL Manuel', 'PAR', 1812),
('Assistant Referee', 'RIAL Walter', 'URU', 1814),
('Assistant Referee', 'RAMIREZ Jose', 'MEX', 1866),
('Assistant Referee', 'NDOYE Mamadou', 'SEN', 1883),
('Referee', 'MERK Markus', 'GER', 34920),
('Assistant Referee', 'ADERODJOU Aboudou', 'BEN', 35265),
('Referee', 'IVANOV Valentin', 'RUS', 37294),
('Assistant Referee', 'VERGARA Hector', 'CAN', 37427),
('Referee', 'ARCHUNDIA Benito', 'MEX', 37556),
('Assistant Referee', 'DANTE Dramane', 'MLI', 37682),
('Referee', 'MICHEL Lubos', 'SVK', 38366),
('Referee', 'CODJIA Coffi', 'BEN', 38639),
('Assistant Referee', 'HIROSHIMA Yoshikazu', 'JPN', 38753),
('Assistant Referee', 'ARABATI Fathi', 'JOR', 38769),
('Referee', 'ELIZONDO Horacio', 'ARG', 38922),
('Assistant Referee', 'YEBOAH Justice', 'GHA', 38978),
('Assistant Referee', 'DJEZZAR Brahim', 'ALG', 39668),
('Assistant Referee', 'VOLNIN Evgueni', 'RUS', 39972),
('Referee', 'RUIZ Oscar', 'COL', 39989),
('Assistant Referee', 'GIRALDEZ CARRASCO Victoriano', 'ESP', 39996),
('Assistant Referee', 'PERMPANICH Prachya', 'THA', 40190),
('Assistant Referee', 'BARKEY Gregory', 'USA', 40210),
('Referee', 'STOTT Kevin', 'USA', 40229),
('Referee', 'POLL Graham', 'ENG', 40880),
('Assistant Referee', 'ENDENG ZOGO Jean Marie', 'CMR', 41088),
('Referee', 'MAIDIN Shamsul', 'SIN', 41323),
('Assistant Referee', 'GARCIA Dario', 'ARG', 41417),
('Assistant Referee', 'GONZALEZ Rodrigo', 'CHI', 42681),
('Referee', 'GUEZZAZ Mohamed', 'MAR', 42745),
('Referee', 'AMARILLA Carlos', 'PAR', 42758),
('Assistant Referee', 'CORONA Ednilson', 'BRA', 42786),
('Assistant Referee', 'NTAGUNGIRA Celestin', 'RWA', 42856),
('Assistant Referee', 'SHARP Philip', 'ENG', 43053),
('Assistant Referee', 'DAGORNE Lionel', 'FRA', 43064),
('Assistant Referee', 'AL KADRI Hamdi', 'SYR', 43113),
('Referee', 'ABD EL FATAH Essam', 'EGY', 71992),
('Referee', 'DE BLEECKERE Frank', 'BEL', 173269),
('Assistant Referee', 'BALKO Martin', 'SVK', 173356),
('Referee', 'LARRIONDA Jorge', 'URU', 173372),
('Assistant Referee', 'SCHRAER Christian', 'GER', 173449),
('Referee', 'KAMIKAWA Toru', 'JPN', 173532),
('Assistant Referee', 'KIM Dae Young', 'KOR', 173582),
('Assistant Referee', 'SALVER Jan-Hendrik', 'GER', 175911),
('Assistant Referee', 'ARNET Matthias', 'SUI', 176000),
('Assistant Referee', 'WILSON Ben', 'AUS', 176406),
('Referee', 'DAMON Jerome', 'RSA', 176433),
('Assistant Referee', 'MOLEFE Enock', 'RSA', 176435),
('Assistant Referee', 'LEAL Leonel', 'CRC', 179866),
('Referee', 'CHANDIA Carlos', 'CHI', 179950),
('Assistant Referee', 'ANDINO Amelio', 'PAR', 179958),
('Assistant Referee', 'TAMAYO Fernando', 'ECU', 180116),
('Assistant Referee', 'FANDINO Pablo', 'URU', 180137),
('Assistant Referee', 'MEDINA HERNANDEZ Pedro', 'ESP', 180591),
('Assistant Referee', 'BURAGINA Francesco', 'SUI', 180595),
('Assistant Referee', 'GIBSON Nathan', 'AUS', 181134),
('Assistant Referee', 'TURNER Glenn', 'ENG', 187084),
('Referee', 'ROSETTI Roberto', 'ITA', 187122),
('Referee', 'MEDINA CANTALEJO Luis', 'ESP', 187224),
('Assistant Referee', 'STRICKLAND Chris', 'USA', 187348),
('Assistant Referee', 'GHULOUM Eisa', 'UAE', 187502),
('Assistant Referee', 'HERMANS Peter', 'BEL', 195786),
('Assistant Referee', 'STAGNOLI Alessandro', 'ITA', 196240),
('Assistant Referee', 'SLYSKO Roman', 'SVK', 196337),
('Assistant Referee', 'GOLUBEV Nikolay', 'RUS', 196358),
('Referee', 'AL GHAMDI Khalil', 'KSA', 196839),
('Assistant Referee', 'NAVIA Jose', 'COL', 205965),
('Assistant Referee', 'COPELLI Cristiano', 'ITA', 207013),
('Assistant Referee', 'CAMARGO Jose Luis', 'MEX', 220525),
('Assistant Referee', 'VROMANS Walter', 'BEL', 221380);

-- --------------------------------------------------------

--
-- Tabellenstruktur für Tabelle `Spiele`
--

CREATE TABLE IF NOT EXISTS `Spiele` (
  `SpielID` int(11) NOT NULL,
  `Runde` varchar(20) DEFAULT NULL,
  `Tag` datetime DEFAULT NULL,
  `Mannschaft1` varchar(40) DEFAULT NULL,
  `Mannschaft2` varchar(40) DEFAULT NULL,
  `Stadion` varchar(20) DEFAULT NULL,
  `Zuschauer` int(11) DEFAULT NULL,
  PRIMARY KEY (`SpielID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Daten für Tabelle `Spiele`
--

INSERT INTO `Spiele` (`SpielID`, `Runde`, `Tag`, `Mannschaft1`, `Mannschaft2`, `Stadion`, `Zuschauer`) VALUES
(1, 'Group A', '2006-06-09 18:00:00', 'Germany', 'Costa Rica', 'Munich', 66000),
(2, 'Group A', '2006-06-09 21:00:00', 'Poland', 'Ecuador', 'Gelsenkirchen', 52000),
(3, 'Group B', '2006-06-10 15:00:00', 'England', 'Paraguay', 'Frankfurt', 48000),
(4, 'Group B', '2006-06-10 18:00:00', 'Trinidad and Tobago', 'Sweden', 'Dortmund', 62959),
(5, 'Group C', '2006-06-10 21:00:00', 'Argentina', 'Cote d Ivoire', 'Hamburg', 49480),
(6, 'Group C', '2006-06-11 15:00:00', 'Serbia and Montenegro', 'Netherlands', 'Leipzig', 37216),
(7, 'Group D', '2006-06-11 18:00:00', 'Mexico', 'Iran', 'Nuremberg', 41000),
(8, 'Group D', '2006-06-11 21:00:00', 'Angola', 'Portugal', 'Cologne', 45000),
(9, 'Group E', '2006-06-12 21:00:00', 'Italy', 'Ghana', 'Hanover', 43000),
(10, 'Group E', '2006-06-12 18:00:00', 'USA', 'Czech Republic', 'Gelsenkirchen', 52000),
(11, 'Group F', '2006-06-13 21:00:00', 'Brazil', 'Croatia', 'Berlin', 72000),
(12, 'Group F', '2006-06-12 15:00:00', 'Australia', 'Japan', 'Kaiserslautern', 46000),
(13, 'Group G', '2006-06-13 18:00:00', 'France', 'Switzerland', 'Stuttgart', 52000),
(14, 'Group G', '2006-06-13 15:00:00', 'Korea Republic', 'Togo', 'Frankfurt', 48000),
(15, 'Group H', '2006-06-14 15:00:00', 'Spain', 'Ukraine', 'Leipzig', 43000),
(16, 'Group H', '2006-06-14 18:00:00', 'Tunisia', 'Saudi Arabia', 'Munich', 66000),
(17, 'Group A', '2006-06-14 21:00:00', 'Germany', 'Poland', 'Dortmund', 65000),
(18, 'Group A', '2006-06-15 15:00:00', 'Ecuador', 'Costa Rica', 'Hamburg', 50000),
(19, 'Group B', '2006-06-15 18:00:00', 'England', 'Trinidad and Tobago', 'Nuremberg', 41000),
(20, 'Group B', '2006-06-15 21:00:00', 'Sweden', 'Paraguay', 'Berlin', 72000),
(21, 'Group C', '2006-06-16 15:00:00', 'Argentina', 'Serbia and Montenegro', 'Gelsenkirchen', 52000),
(22, 'Group C', '2006-06-16 18:00:00', 'Netherlands', 'Cote d Ivoire', 'Stuttgart', 52000),
(23, 'Group D', '2006-06-16 21:00:00', 'Mexico', 'Angola', 'Hanover', 43000),
(24, 'Group D', '2006-06-17 15:00:00', 'Portugal', 'Iran', 'Frankfurt', 48000),
(25, 'Group E', '2006-06-17 21:00:00', 'Italy', 'USA', 'Kaiserslautern', 46000),
(26, 'Group E', '2006-06-17 18:00:00', 'Czech Republic', 'Ghana', 'Cologne', 45000),
(27, 'Group F', '2006-06-18 18:00:00', 'Brazil', 'Australia', 'Munich', 66000),
(28, 'Group F', '2006-06-18 15:00:00', 'Japan', 'Croatia', 'Nuremberg', 41000),
(29, 'Group G', '2006-06-18 21:00:00', 'France', 'Korea Republic', 'Leipzig', 43000),
(30, 'Group G', '2006-06-19 15:00:00', 'Togo', 'Switzerland', 'Dortmund', 65000),
(31, 'Group H', '2006-06-19 21:00:00', 'Spain', 'Tunisia', 'Stuttgart', 52000),
(32, 'Group H', '2006-06-19 18:00:00', 'Saudi Arabia', 'Ukraine', 'Hamburg', 50000),
(33, 'Group A', '2006-06-20 16:00:00', 'Ecuador', 'Germany', 'Berlin', 72000),
(34, 'Group A', '2006-06-20 16:00:00', 'Costa Rica', 'Poland', 'Hanover', 43000),
(35, 'Group B', '2006-06-20 21:00:00', 'Sweden', 'England', 'Cologne', 45000),
(36, 'Group B', '2006-06-20 21:00:00', 'Paraguay', 'Trinidad and Tobago', 'Kaiserslautern', 46000),
(37, 'Group C', '2006-06-21 21:00:00', 'Netherlands', 'Argentina', 'Frankfurt', 48000),
(38, 'Group C', '2006-06-21 21:00:00', 'Cote d Ivoire', 'Serbia and Montenegro', 'Munich', 66000),
(39, 'Group D', '2006-06-21 16:00:00', 'Portugal', 'Mexico', 'Gelsenkirchen', 52000),
(40, 'Group D', '2006-06-21 16:00:00', 'Iran', 'Angola', 'Leipzig', 38000),
(41, 'Group E', '2006-06-22 16:00:00', 'Czech Republic', 'Italy', 'Hamburg', 50000),
(42, 'Group E', '2006-06-22 16:00:00', 'Ghana', 'USA', 'Nuremberg', 41000),
(43, 'Group F', '2006-06-22 21:00:00', 'Japan', 'Brazil', 'Dortmund', 65000),
(44, 'Group F', '2006-06-22 21:00:00', 'Croatia', 'Australia', 'Stuttgart', 52000),
(45, 'Group G', '2006-06-23 21:00:00', 'Togo', 'France', 'Cologne', 45000),
(46, 'Group G', '2006-06-23 21:00:00', 'Switzerland', 'Korea Republic', 'Hanover', 43000),
(47, 'Group H', '2006-06-23 16:00:00', 'Saudi Arabia', 'Spain', 'Kaiserslautern', 46000),
(48, 'Group H', '2006-06-23 16:00:00', 'Ukraine', 'Tunisia', 'Berlin', 72000),
(49, 'Round of 16', '2006-06-24 17:00:00', 'Germany', 'Sweden', 'Munich', 66000),
(50, 'Round of 16', '2006-06-24 21:00:00', 'Argentina', 'Mexico', 'Leipzig', 43000),
(51, 'Round of 16', '2006-06-25 17:00:00', 'England', 'Ecuador', 'Stuttgart', 52000),
(52, 'Round of 16', '2006-06-25 21:00:00', 'Portugal', 'Netherlands', 'Nuremberg', 41000),
(53, 'Round of 16', '2006-06-26 17:00:00', 'Italy', 'Australia', 'Kaiserslautern', 46000),
(54, 'Round of 16', '2006-06-26 21:00:00', 'Switzerland', 'Ukraine', 'Cologne', 45000),
(55, 'Round of 16', '2006-06-27 17:00:00', 'Brazil', 'Ghana', 'Dortmund', 65000),
(56, 'Round of 16', '2006-06-27 21:00:00', 'Spain', 'France', 'Hanover', 43000),
(57, 'Quarter-finals', '2006-06-30 17:00:00', 'Germany', 'Argentina', 'Berlin', 72000),
(58, 'Quarter-finals', '2006-06-30 21:00:00', 'Italy', 'Ukraine', 'Hamburg', 50000),
(59, 'Quarter-finals', '2006-07-01 17:00:00', 'England', 'Portugal', 'Gelsenkirchen', 52000),
(60, 'Quarter-finals', '2006-07-01 21:00:00', 'Brazil', 'France', 'Frankfurt', 48000),
(61, 'Semi-Finals', '2006-07-04 21:00:00', 'Germany', 'Italy', 'Dortmund', 65000),
(62, 'Semi-Finals', '2006-07-05 21:00:00', 'Portugal', 'France', 'Munich', 66000),
(63, 'Third Place', '2006-07-08 21:00:00', 'Germany', 'Portugal', 'Stuttgart', 52000),
(64, 'Final', '2006-07-09 20:00:00', 'Italy', 'France', 'Berlin', 69000);

-- --------------------------------------------------------

--
-- Tabellenstruktur für Tabelle `Spieler`
--

CREATE TABLE IF NOT EXISTS `Spieler` (
  `SpielerNr` int(11) NOT NULL,
  `Name` varchar(40) DEFAULT NULL,
  `Land` varchar(40) DEFAULT NULL,
  `Geburtsdatum` date DEFAULT NULL,
  `Position` varchar(20) DEFAULT NULL,
  PRIMARY KEY (`SpielerNr`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Daten für Tabelle `Spieler`
--

INSERT INTO `Spieler` (`SpielerNr`, `Name`, `Land`, `Geburtsdatum`, `Position`) VALUES
(3243, 'RONALDINHO', 'Brazil', '1980-03-21', 'Midfielder'),
(3251, 'RICARDINHO', 'Brazil', '1976-05-23', 'Midfielder'),
(3347, 'DOMORAUD Cyrille', 'Cote d Ivoire', '1971-07-22', 'Defender'),
(3351, 'KOUASSI Blaise', 'Cote d Ivoire', '1975-02-02', 'Defender'),
(3356, 'TIZIE Jean-Jacques', 'Cote d Ivoire', '1972-09-07', 'Goalkeeper'),
(3497, 'AYOVI Marlon', 'Ecuador', '1971-09-27', 'Midfielder'),
(3508, 'KAVIEDES Ivan', 'Ecuador', '1977-10-24', 'Forward'),
(4039, 'SANTA CRUZ Roque', 'Paraguay', '1981-08-16', 'Forward'),
(4299, 'AGASSA Kossi', 'Togo', '1978-07-02', 'Goalkeeper'),
(4309, 'SALIFOU Moustapha', 'Togo', '1983-06-01', 'Forward'),
(4317, 'EDWARDS Carlos', 'Trinidad and Tobago', '1978-10-24', 'Midfielder'),
(4320, 'INCE Clayton', 'Trinidad and Tobago', '1972-07-13', 'Goalkeeper'),
(4326, 'LAWRENCE Dennis', 'Trinidad and Tobago', '1974-08-01', 'Defender'),
(4332, 'SANCHO Brent', 'Trinidad and Tobago', '1977-03-13', 'Defender'),
(48549, 'DIDA', 'Brazil', '1973-10-07', 'Goalkeeper'),
(52785, 'LATAPY Russell', 'Trinidad and Tobago', '1968-08-02', 'Forward'),
(56193, 'PETKOVIC Dusan', 'Serbia and Montenegro', '1974-06-13', 'Defender'),
(60183, 'YORKE Dwight', 'Trinidad and Tobago', '1971-11-03', 'Forward'),
(62210, 'JAMES David', 'England', '1970-08-01', 'Goalkeeper'),
(70092, 'NOOR Mohammed', 'Saudi Arabia', '1978-02-26', 'Midfielder'),
(70096, 'GARCIA Rafael', 'Mexico', '1974-08-14', 'Midfielder'),
(70097, 'TORRADO Gerardo', 'Mexico', '1979-04-30', 'Midfielder'),
(76824, 'CAFU', 'Brazil', '1970-06-07', 'Defender'),
(77299, 'SUAREZ Claudio', 'Mexico', '1968-12-17', 'Defender'),
(77503, 'AL JABER Sami', 'Saudi Arabia', '1972-12-11', 'Forward'),
(77937, 'LEE Woon Jae', 'Korea Republic', '1973-04-26', 'Goalkeeper'),
(77995, 'LARSSON Henrik', 'Sweden', '1971-09-20', 'Forward'),
(78091, 'KAHN Oliver', 'Germany', '1969-06-15', 'Goalkeeper'),
(83431, 'CANIZARES Santiago', 'Spain', '1969-12-18', 'Goalkeeper'),
(84703, 'REYNA Claudio', 'USA', '1973-07-20', 'Midfielder'),
(92699, 'RONALDO', 'Brazil', '1976-09-22', 'Forward'),
(92722, 'AL DEAYEA Mohammed', 'Saudi Arabia', '1972-08-02', 'Goalkeeper'),
(93299, 'ABALO Jean-Paul', 'Togo', '1975-06-26', 'Defender'),
(93581, 'BOUMNIJEL Ali', 'Tunisia', '1966-04-13', 'Goalkeeper'),
(94090, 'DAEI Ali', 'Iran', '1969-03-21', 'Forward'),
(94497, 'SCHWARZER Mark', 'Australia', '1972-10-06', 'Goalkeeper'),
(94522, 'LAZARIDIS Stan', 'Australia', '1972-08-16', 'Midfielder'),
(94915, 'GAMARRA Carlos', 'Paraguay', '1971-02-17', 'Defender'),
(95557, 'BAK Jacek', 'Poland', '1973-03-24', 'Defender'),
(95673, 'ALEXANDERSSON Niclas', 'Sweden', '1971-12-29', 'Midfielder'),
(96075, 'BARTHEZ Fabien', 'France', '1971-06-28', 'Goalkeeper'),
(113570, 'VAN DER SAR Edwin', 'Netherlands', '1970-10-29', 'Goalkeeper'),
(153929, 'ABBONDANZIERI Roberto', 'Argentina', '1972-08-19', 'Goalkeeper'),
(153933, 'AYALA Roberto', 'Argentina', '1973-04-14', 'Defender'),
(153954, 'CRUZ Julio', 'Argentina', '1974-10-10', 'Forward'),
(153977, 'SORIN Juan', 'Argentina', '1976-05-05', 'Defender'),
(154050, 'ALOISI John', 'Australia', '1976-02-05', 'Forward'),
(154059, 'KALAC Zeljko', 'Australia', '1972-12-16', 'Goalkeeper'),
(154061, 'MOORE Craig', 'Australia', '1975-12-12', 'Defender'),
(154065, 'POPOVIC Tony', 'Australia', '1973-07-04', 'Defender'),
(154066, 'SKOKO Josip', 'Australia', '1975-12-10', 'Midfielder'),
(154762, 'DRUMMOND Jervis', 'Costa Rica', '1976-09-08', 'Defender'),
(154793, 'SOLIS Mauricio', 'Costa Rica', '1972-12-13', 'Midfielder'),
(154798, 'WALLACE Harold', 'Costa Rica', '1975-09-07', 'Defender'),
(154799, 'WANCHOPE Paulo', 'Costa Rica', '1976-07-31', 'Forward'),
(154901, 'LOKVENC Vratislav', 'Czech Republic', '1973-09-27', 'Forward'),
(154903, 'NEDVED Pavel', 'Czech Republic', '1972-08-30', 'Midfielder'),
(154906, 'POBORSKY Karel', 'Czech Republic', '1972-03-30', 'Midfielder'),
(155010, 'DE LA CRUZ Ulises', 'Ecuador', '1974-02-08', 'Defender'),
(155011, 'DELGADO Agustin', 'Ecuador', '1974-12-23', 'Forward'),
(155148, 'RAUL', 'Spain', '1977-06-27', 'Forward'),
(155357, 'NOWOTNY Jens', 'Germany', '1974-01-11', 'Defender'),
(155382, 'APPIAH Stephen', 'Ghana', '1980-12-24', 'Midfielder'),
(155401, 'KUFFOUR Samuel', 'Ghana', '1976-09-03', 'Defender'),
(155673, 'OOIJER Andre', 'Netherlands', '1974-07-11', 'Defender'),
(155679, 'VAN BRONCKHORST Giovanni', 'Netherlands', '1975-02-05', 'Defender'),
(155696, 'KOVAC Niko', 'Croatia', '1971-10-15', 'Midfielder'),
(155707, 'SIMIC Dario', 'Croatia', '1975-11-12', 'Defender'),
(155712, 'TUDOR Igor', 'Croatia', '1978-04-16', 'Defender'),
(155851, 'GOLMOHAMMADI Yahya', 'Iran', '1971-03-19', 'Defender'),
(155853, 'MAHDAVIKIA Mehdi', 'Iran', '1977-07-24', 'Midfielder'),
(155957, 'CANNAVARO Fabio', 'Italy', '1973-09-13', 'Defender'),
(155963, 'DEL PIERO Alessandro', 'Italy', '1974-11-09', 'Forward'),
(155969, 'INZAGHI Filippo', 'Italy', '1973-08-09', 'Forward'),
(155971, 'NESTA Alessandro', 'Italy', '1976-03-19', 'Defender'),
(155974, 'PERUZZI Angelo', 'Italy', '1970-02-16', 'Goalkeeper'),
(156047, 'KAWAGUCHI Yoshikatsu', 'Japan', '1975-08-15', 'Goalkeeper'),
(156055, 'NAKATA Hidetoshi', 'Japan', '1977-01-22', 'Midfielder'),
(156216, 'AHN Jung Hwan', 'Korea Republic', '1976-01-27', 'Forward'),
(156614, 'PARDO Pavel', 'Mexico', '1976-07-26', 'Midfielder'),
(156624, 'SANCHEZ Oswaldo', 'Mexico', '1973-09-21', 'Goalkeeper'),
(157138, 'ACUNA Roberto', 'Paraguay', '1972-03-25', 'Midfielder'),
(157838, 'VOGEL Johann', 'Switzerland', '1977-03-08', 'Midfielder'),
(157840, 'WICKY Raphael', 'Switzerland', '1977-04-26', 'Midfielder'),
(157843, 'ZUBERBUEHLER Pascal', 'Switzerland', '1971-01-08', 'Goalkeeper'),
(158045, 'AZIAWONOU Yao', 'Togo', '1979-11-30', 'Midfielder'),
(158048, 'MOHAMED KADER', 'Togo', '1979-04-08', 'Forward'),
(158074, 'TCHANGAI Massamasso', 'Togo', '1978-08-08', 'Defender'),
(158208, 'ANDREWS Marvin', 'Trinidad and Tobago', '1975-12-22', 'Defender'),
(158221, 'JOHN Avery', 'Trinidad and Tobago', '1975-06-18', 'Defender'),
(158222, 'JOHN Stern', 'Trinidad and Tobago', '1976-10-30', 'Forward'),
(158241, 'WISE Evans', 'Trinidad and Tobago', '1973-11-23', 'Forward'),
(158261, 'GHODHBANE Kaies', 'Tunisia', '1976-01-07', 'Midfielder'),
(158268, 'JAIDI Radhi', 'Tunisia', '1975-08-30', 'Defender'),
(158368, 'GUSIN Andriy', 'Ukraine', '1972-12-11', 'Midfielder'),
(158385, 'REBROV Serhiy', 'Ukraine', '1974-06-03', 'Midfielder'),
(158386, 'SHEVCHENKO Andriy', 'Ukraine', '1976-09-29', 'Forward'),
(158389, 'SHOVKOVSKYI Oleksandr', 'Ukraine', '1975-01-02', 'Goalkeeper'),
(158471, 'MC BRIDE Brian', 'USA', '1972-06-19', 'Forward'),
(158473, 'POPE Eddie', 'USA', '1973-12-24', 'Defender'),
(158773, 'MILOSEVIC Savo', 'Serbia and Montenegro', '1973-09-02', 'Forward'),
(158775, 'NADJ Albert', 'Serbia and Montenegro', '1974-10-29', 'Midfielder'),
(159069, 'KEWELL Harry', 'Australia', '1978-09-22', 'Forward'),
(159257, 'DOKHI Ahmed', 'Saudi Arabia', '1976-10-25', 'Defender'),
(159277, 'ANDERSSON Daniel', 'Sweden', '1977-08-28', 'Midfielder'),
(159284, 'BAKHTIARIZADEH Sohrab', 'Iran', '1977-09-11', 'Defender'),
(159304, 'BUFFON Gianluigi', 'Italy', '1978-01-28', 'Goalkeeper'),
(159323, 'CHOI Jin Cheul', 'Korea Republic', '1971-03-26', 'Defender'),
(159481, 'NARAZAKI Seigo', 'Japan', '1976-04-15', 'Goalkeeper'),
(159597, 'VIDUKA Mark', 'Australia', '1975-10-09', 'Forward'),
(160130, 'LUIS FIGO', 'Portugal', '1972-11-04', 'Forward'),
(160968, 'BLAZEK Jaromir', 'Czech Republic', '1972-12-29', 'Goalkeeper'),
(161077, 'COCU Phillip', 'Netherlands', '1970-10-29', 'Midfielder'),
(161454, 'BECKHAM David', 'England', '1975-05-02', 'Midfielder'),
(161455, 'CAMPBELL Sol', 'England', '1974-09-18', 'Defender'),
(162670, 'ARELLANO Jesus', 'Mexico', '1973-05-08', 'Forward'),
(162680, 'CRESPO Hernan', 'Argentina', '1975-07-05', 'Forward'),
(162685, 'JOAO RICARDO', 'Angola', '1970-01-07', 'Goalkeeper'),
(162763, 'CANIZA Denis', 'Paraguay', '1974-08-29', 'Defender'),
(163331, 'ZIDANE Zinedine', 'France', '1972-06-23', 'Midfielder'),
(163350, 'PAULO SANTOS', 'Portugal', '1972-12-11', 'Goalkeeper'),
(163666, 'THURAM Lilian', 'France', '1972-01-01', 'Defender'),
(164548, 'SCHNEIDER Bernd', 'Germany', '1973-11-17', 'Midfielder'),
(164950, 'PRSO Dado', 'Croatia', '1974-11-05', 'Forward'),
(165247, 'TOTTI Francesco', 'Italy', '1976-09-27', 'Midfielder'),
(165260, 'NUNO GOMES', 'Portugal', '1976-07-05', 'Forward'),
(165876, 'SIONKO Libor', 'Czech Republic', '1977-02-01', 'Forward'),
(165987, 'SZYMKOWIAK Miroslav', 'Poland', '1976-11-12', 'Midfielder'),
(166297, 'VASHCHUK Vladyslav', 'Ukraine', '1975-01-02', 'Defender'),
(166375, 'PAULETA', 'Portugal', '1973-04-28', 'Forward'),
(166380, 'RIQUELME Juan', 'Argentina', '1978-06-24', 'Midfielder'),
(166921, 'LEHMANN Jens', 'Germany', '1969-11-10', 'Goalkeeper'),
(168639, 'NEVILLE Gary', 'England', '1975-02-18', 'Defender'),
(168775, 'GALASEK Tomas', 'Czech Republic', '1973-01-15', 'Midfielder'),
(169238, 'HURTADO Ivan', 'Ecuador', '1974-08-16', 'Defender'),
(169551, 'LJUNGBERG Fredrik', 'Sweden', '1977-04-16', 'Midfielder'),
(169675, 'MUELLER Patrick', 'Switzerland', '1976-12-17', 'Defender'),
(170066, 'AKWA', 'Angola', '1977-05-30', 'Forward'),
(170167, 'GOMEZ Ronald', 'Costa Rica', '1975-01-24', 'Forward'),
(170171, 'MARIN Luis', 'Costa Rica', '1974-08-10', 'Defender'),
(170232, 'KINGSON Richard', 'Ghana', '1978-06-13', 'Goalkeeper'),
(170674, 'PAREDES Carlos', 'Paraguay', '1976-07-16', 'Midfielder'),
(170681, 'ONO Shinji', 'Japan', '1979-09-27', 'Midfielder'),
(170687, 'ZE ROBERTO', 'Brazil', '1974-07-06', 'Midfielder'),
(170688, 'ROBERTO CARLOS', 'Brazil', '1973-04-10', 'Defender'),
(170707, 'VIEIRA Patrick', 'France', '1976-06-23', 'Midfielder'),
(170709, 'TREZEGUET David', 'France', '1977-10-15', 'Forward'),
(170711, 'HENRY Thierry', 'France', '1977-08-17', 'Forward'),
(170721, 'FERDINAND Rio', 'England', '1978-11-07', 'Defender'),
(170722, 'OWEN Michael', 'England', '1979-12-14', 'Forward'),
(170748, 'JEVRIC Dragoslav', 'Serbia and Montenegro', '1974-07-08', 'Goalkeeper'),
(170750, 'STANKOVIC Dejan', 'Serbia and Montenegro', '1978-09-11', 'Midfielder'),
(170753, 'TOMAS Stjepan', 'Croatia', '1976-03-06', 'Defender'),
(170754, 'SERIC Anthony', 'Croatia', '1979-01-15', 'Midfielder'),
(170770, 'TRABELSI Hatem', 'Tunisia', '1977-01-25', 'Defender'),
(170787, 'AL TEMYAT Nawaf', 'Saudi Arabia', '1976-06-28', 'Midfielder'),
(171149, 'EMERSON', 'Brazil', '1976-04-04', 'Midfielder'),
(174656, 'KELLER Kasey', 'USA', '1969-11-29', 'Goalkeeper'),
(175350, 'KUSZCZAK Tomasz', 'Poland', '1982-03-20', 'Goalkeeper'),
(175357, 'MILA Sebastian', 'Poland', '1982-07-10', 'Midfielder'),
(175413, 'REINA Jose Manuel', 'Spain', '1982-08-31', 'Goalkeeper'),
(175498, 'BEASLEY DaMarcus', 'USA', '1982-05-24', 'Midfielder'),
(175507, 'DONOVAN Landon', 'USA', '1982-03-04', 'Midfielder'),
(175508, 'CONVEY Bobby', 'USA', '1983-05-27', 'Midfielder'),
(175511, 'ONYEWU Oguchi', 'USA', '1982-05-13', 'Defender'),
(175524, 'ESSIEN Michael', 'Ghana', '1982-12-03', 'Midfielder'),
(175683, 'ADRIANO', 'Brazil', '1982-02-17', 'Forward'),
(176530, 'JUNINHO PERNAMBUCANO', 'Brazil', '1975-01-30', 'Midfielder'),
(176534, 'GILBERTO', 'Brazil', '1976-04-25', 'Defender'),
(176549, 'PEREZ Luis', 'Mexico', '1981-01-12', 'Midfielder'),
(176611, 'MARCOS SENNA', 'Spain', '1976-07-17', 'Midfielder'),
(176639, 'SALGADO Michel', 'Spain', '1975-10-22', 'Defender'),
(176644, 'CASILLAS Iker', 'Spain', '1981-05-20', 'Goalkeeper'),
(176953, 'JAZIRI Zied', 'Tunisia', '1978-07-12', 'Forward'),
(176961, 'YAPI YAPO Gilles', 'Cote d Ivoire', '1982-01-30', 'Midfielder'),
(176971, 'ZOKORA Didier', 'Cote d Ivoire', '1980-12-14', 'Midfielder'),
(176983, 'NAFTI Mehdi', 'Tunisia', '1978-11-28', 'Midfielder'),
(176984, 'DINDANE Aruna', 'Cote d Ivoire', '1980-11-26', 'Forward'),
(176991, 'FLAVIO', 'Angola', '1979-12-30', 'Forward'),
(176992, 'DELGADO', 'Angola', '1979-11-01', 'Defender'),
(177219, 'GAVILAN Diego', 'Paraguay', '1980-03-01', 'Midfielder'),
(177220, 'TENORIO Edwin', 'Ecuador', '1976-06-16', 'Midfielder'),
(177559, 'TOLEDO Delio', 'Paraguay', '1976-02-10', 'Defender'),
(177615, 'KALOU Bonaventure', 'Cote d Ivoire', '1978-01-12', 'Forward'),
(177655, 'ZAMBROTTA Gianluca', 'Italy', '1977-02-19', 'Defender'),
(177657, 'COSTINHA', 'Portugal', '1974-12-01', 'Midfielder'),
(177660, 'QUIM', 'Portugal', '1975-11-13', 'Goalkeeper'),
(177667, 'BALLACK Michael', 'Germany', '1976-09-26', 'Midfielder'),
(177690, 'MELLBERG Olof', 'Sweden', '1977-09-03', 'Defender'),
(177703, 'ALLBACK Marcus', 'Sweden', '1973-07-05', 'Forward'),
(177709, 'KEZMAN Mateja', 'Serbia and Montenegro', '1979-04-12', 'Forward'),
(177712, 'KOLLER Jan', 'Czech Republic', '1973-03-30', 'Forward'),
(177714, 'JANKULOVSKI Marek', 'Czech Republic', '1977-05-09', 'Defender'),
(177719, 'WILTORD Sylvain', 'France', '1974-05-10', 'Forward'),
(177760, 'MIYAMOTO Tsuneyasu', 'Japan', '1977-02-07', 'Defender'),
(177763, 'KIM Yong Dae', 'Korea Republic', '1979-10-11', 'Goalkeeper'),
(177765, 'NAKAZAWA Yuji', 'Japan', '1978-02-25', 'Defender'),
(177766, 'NAKATA Koji', 'Japan', '1979-07-09', 'Defender'),
(177768, 'ENDO Yasuhito', 'Japan', '1980-01-28', 'Midfielder'),
(177771, 'INAMOTO Junichi', 'Japan', '1979-09-18', 'Midfielder'),
(177773, 'NAKAMURA Shunsuke', 'Japan', '1978-06-24', 'Midfielder'),
(177778, 'TAKAHARA Naohiro', 'Japan', '1979-06-04', 'Forward'),
(177784, 'OGASAWARA Mitsuo', 'Japan', '1979-04-05', 'Midfielder'),
(177785, 'LEE Young Pyo', 'Korea Republic', '1977-04-23', 'Defender'),
(177788, 'PARK Ji Sung', 'Korea Republic', '1981-02-25', 'Midfielder'),
(177806, 'SEOL Ki Hyeon', 'Korea Republic', '1979-01-08', 'Forward'),
(177816, 'YANAGISAWA Atsushi', 'Japan', '1977-05-27', 'Forward'),
(177823, 'ROSICKY Tomas', 'Czech Republic', '1980-10-04', 'Midfielder'),
(177845, 'GATTUSO Gennaro', 'Italy', '1978-01-09', 'Midfielder'),
(177846, 'MARCHENA Carlos', 'Spain', '1979-07-31', 'Defender'),
(177855, 'XAVI', 'Spain', '1980-01-25', 'Midfielder'),
(177876, 'PIRLO Andrea', 'Italy', '1979-05-19', 'Midfielder'),
(177877, 'PERROTTA Simone', 'Italy', '1977-09-17', 'Midfielder'),
(177891, 'GRYGERA Zdenek', 'Czech Republic', '1980-05-14', 'Defender'),
(177894, 'UJFALUSI Tomas', 'Czech Republic', '1978-03-24', 'Defender'),
(177896, 'BAROS Milan', 'Czech Republic', '1981-10-28', 'Forward'),
(177897, 'POLAK Jan', 'Czech Republic', '1981-03-14', 'Midfielder'),
(177900, 'JAROLIM David', 'Czech Republic', '1979-05-17', 'Midfielder'),
(177905, 'HEINZ Marek', 'Czech Republic', '1977-08-04', 'Forward'),
(177914, 'PUYOL Carlos', 'Spain', '1978-04-13', 'Defender'),
(177917, 'ALBELDA David', 'Spain', '1977-09-01', 'Midfielder'),
(177963, 'KOVAC Radoslav', 'Czech Republic', '1979-11-27', 'Midfielder'),
(178002, 'MESEN Alvaro', 'Costa Rica', '1972-12-24', 'Goalkeeper'),
(178004, 'CENTENO Walter', 'Costa Rica', '1974-10-06', 'Midfielder'),
(178051, 'BOBADILLA Aldo', 'Paraguay', '1976-04-20', 'Goalkeeper'),
(178101, 'LEWIS Eddie', 'USA', '1974-05-17', 'Defender'),
(178119, 'MARQUEZ Rafael', 'Mexico', '1979-02-13', 'Defender'),
(178142, 'AIMAR Pablo', 'Argentina', '1979-11-03', 'Midfielder'),
(178146, 'ESPINOZA Giovanny', 'Ecuador', '1977-04-12', 'Defender'),
(178167, 'BERHALTER Gregg', 'USA', '1973-08-01', 'Defender'),
(178264, 'ADDO Otto', 'Ghana', '1975-06-09', 'Midfielder'),
(178278, 'DA SILVA Paulo', 'Paraguay', '1980-02-01', 'Defender'),
(178299, 'BRESCIANO Marco', 'Australia', '1980-02-11', 'Midfielder'),
(178303, 'CULINA Jason', 'Australia', '1980-08-05', 'Midfielder'),
(178305, 'DIDULICA Joe', 'Croatia', '1977-10-14', 'Goalkeeper'),
(178306, 'EMERTON Brett', 'Australia', '1979-02-22', 'Midfielder'),
(178312, 'NEILL Lucas', 'Australia', '1978-03-09', 'Defender'),
(178317, 'STERJOVSKI Mile', 'Australia', '1979-05-27', 'Midfielder'),
(178324, 'GRELLA Vince', 'Australia', '1979-10-05', 'Midfielder'),
(178359, 'CRIS', 'Brazil', '1977-06-03', 'Defender'),
(178406, 'CECH Petr', 'Czech Republic', '1982-05-20', 'Goalkeeper'),
(178412, 'O BRIEN John', 'USA', '1977-08-29', 'Midfielder'),
(178414, 'OLSEN Ben', 'USA', '1977-05-03', 'Midfielder'),
(178416, 'ALBRIGHT Chris', 'USA', '1979-01-14', 'Defender'),
(178418, 'WOLFF Josh', 'USA', '1977-02-25', 'Forward'),
(178420, 'HOWARD Tim', 'USA', '1979-03-06', 'Goalkeeper'),
(178467, 'KIM Sang Sik', 'Korea Republic', '1976-12-17', 'Defender'),
(178469, 'LEE Chun Soo', 'Korea Republic', '1981-07-09', 'Forward'),
(178520, 'LUCIO', 'Brazil', '1978-05-08', 'Defender'),
(178594, 'ADEBAYOR Emmanuel', 'Togo', '1984-02-26', 'Forward'),
(178780, 'MENDONCA', 'Angola', '1982-10-09', 'Midfielder'),
(178788, 'ROGERIO CENI', 'Brazil', '1973-01-22', 'Goalkeeper'),
(178789, 'MAGNIN Ludovic', 'Switzerland', '1979-04-20', 'Defender'),
(178790, 'CABANAS Ricardo', 'Switzerland', '1979-01-17', 'Midfielder'),
(178791, 'YAKIN Hakan', 'Switzerland', '1977-02-22', 'Midfielder'),
(178837, 'SAVIOLA Javier', 'Argentina', '1981-12-11', 'Forward'),
(178841, 'REASCO Neicer', 'Ecuador', '1977-07-23', 'Defender'),
(178842, 'MENDEZ Edison', 'Ecuador', '1979-03-16', 'Midfielder'),
(178945, 'NESMACHNYI Andriy', 'Ukraine', '1979-02-28', 'Defender'),
(178953, 'TYMOSCHUK Anatoliy', 'Ukraine', '1979-03-30', 'Midfielder'),
(178957, 'VOROBEY Andriy', 'Ukraine', '1978-11-29', 'Forward'),
(178958, 'BARRY Boubacar', 'Cote d Ivoire', '1979-12-30', 'Goalkeeper'),
(178963, 'TOURE Kolo', 'Cote d Ivoire', '1981-03-19', 'Defender'),
(178964, 'KEITA Kader', 'Cote d Ivoire', '1981-08-06', 'Midfielder'),
(178967, 'ZEWLAKOW Michal', 'Poland', '1976-04-22', 'Defender'),
(178969, 'KRZYNOWEK Jacek', 'Poland', '1976-05-15', 'Midfielder'),
(178986, 'THOMPSON Archie', 'Australia', '1978-10-23', 'Forward'),
(179023, 'SVENSSON Anders', 'Sweden', '1976-07-17', 'Midfielder'),
(179025, 'SONG Chong Gug', 'Korea Republic', '1979-02-20', 'Defender'),
(179038, 'JULIO CESAR', 'Brazil', '1979-09-03', 'Goalkeeper'),
(179048, 'PLETIKOSA Stipe', 'Croatia', '1979-01-08', 'Goalkeeper'),
(179049, 'KOVAC Robert', 'Croatia', '1974-04-06', 'Defender'),
(179051, 'BALABAN Bosko', 'Croatia', '1978-10-15', 'Forward'),
(179058, 'VRANJES Jurica', 'Croatia', '1980-01-31', 'Midfielder'),
(179098, 'VENNEGOOR OF HESSELINK Jan', 'Netherlands', '1978-11-07', 'Forward'),
(179159, 'SIMAO SABROSA', 'Portugal', '1979-10-31', 'Forward'),
(179162, 'FERNANDO MEIRA', 'Portugal', '1978-06-05', 'Defender'),
(179170, 'DJORDJEVIC Predrag', 'Serbia and Montenegro', '1972-08-04', 'Midfielder'),
(179174, 'ILIC Sasa', 'Serbia and Montenegro', '1977-12-30', 'Midfielder'),
(179558, 'NEUVILLE Oliver', 'Germany', '1973-05-01', 'Forward'),
(179568, 'VAN BOMMEL Mark', 'Netherlands', '1977-04-22', 'Midfielder'),
(179662, 'COLE Joe', 'England', '1981-11-08', 'Midfielder'),
(179814, 'ADJEI Sammy', 'Ghana', '1980-09-01', 'Goalkeeper'),
(179882, 'NIBOMBE Dare', 'Togo', '1980-06-16', 'Defender'),
(180400, 'HASHEMIAN Vahid', 'Iran', '1976-07-21', 'Forward'),
(180402, 'KARIMI Ali', 'Iran', '1978-11-08', 'Midfielder'),
(180484, 'MELLITI Sofiane', 'Tunisia', '1978-08-18', 'Midfielder'),
(180543, 'MINEIRO', 'Brazil', '1975-08-02', 'Midfielder'),
(180648, 'HISLOP Shaka', 'Trinidad and Tobago', '1969-02-22', 'Goalkeeper'),
(180650, 'SCOTLAND Jason', 'Trinidad and Tobago', '1979-02-18', 'Forward'),
(180653, 'WHITLEY Aurtis', 'Trinidad and Tobago', '1977-05-01', 'Midfielder'),
(180735, 'GIVET Gael', 'France', '1981-10-09', 'Defender'),
(180811, 'VAN DER VAART Rafael', 'Netherlands', '1983-02-11', 'Midfielder'),
(180849, 'BELIK Oleksiy', 'Ukraine', '1981-02-15', 'Forward'),
(180928, 'KOMANO Yuichi', 'Japan', '1981-07-25', 'Defender'),
(181017, 'KAZEMEIAN Javad', 'Iran', '1981-04-23', 'Forward'),
(181292, 'SAGNOL Willy', 'France', '1977-03-18', 'Defender'),
(181293, 'MAKELELE Claude', 'France', '1973-02-18', 'Midfielder'),
(181314, 'MARTINEZ Gilberto', 'Costa Rica', '1979-10-01', 'Defender'),
(181333, 'SILVESTRE Mikael', 'France', '1977-08-09', 'Defender'),
(181441, 'BURDISSO Nicolas', 'Argentina', '1981-04-12', 'Defender'),
(181445, 'COLOCCINI Fabricio', 'Argentina', '1982-01-22', 'Defender'),
(181474, 'WILKSHIRE Luke', 'Australia', '1981-10-02', 'Midfielder'),
(181565, 'MANTORRAS', 'Angola', '1982-03-18', 'Forward'),
(181569, 'LOVE', 'Angola', '1979-03-14', 'Forward'),
(181616, 'AKOTO Eric', 'Togo', '1980-07-20', 'Defender'),
(181618, 'ATSOU Franck', 'Togo', '1978-08-01', 'Midfielder'),
(181711, 'SARPEI Hans', 'Ghana', '1976-06-28', 'Defender'),
(181838, 'DHORASOO Vikash', 'France', '1973-10-10', 'Midfielder'),
(181865, 'AL SHLHOUB Mohammad', 'Saudi Arabia', '1980-12-08', 'Midfielder'),
(181929, 'PERLAZA Jose', 'Ecuador', '1981-10-06', 'Defender'),
(181930, 'GUAGUA Jorge', 'Ecuador', '1981-09-28', 'Defender'),
(182002, 'CHIPPERFIELD Scott', 'Australia', '1975-12-30', 'Defender'),
(182021, 'LANDREAU Mickael', 'France', '1979-05-14', 'Goalkeeper'),
(182050, 'HARGREAVES Owen', 'England', '1981-01-20', 'Midfielder'),
(182194, 'RICARDO', 'Portugal', '1976-02-11', 'Goalkeeper'),
(182197, 'PETIT', 'Portugal', '1976-09-25', 'Midfielder'),
(182206, 'KLOSE Miroslav', 'Germany', '1978-06-09', 'Forward'),
(182207, 'FRINGS Torsten', 'Germany', '1976-11-22', 'Midfielder'),
(182211, 'COX Ian', 'Trinidad and Tobago', '1971-03-25', 'Defender'),
(182226, 'BOUMSONG Jean-Alain', 'France', '1979-12-14', 'Defender'),
(182236, 'GOVOU Sidney', 'France', '1979-07-27', 'Forward'),
(182372, 'MASCHERANO Javier', 'Argentina', '1984-06-08', 'Midfielder'),
(182373, 'TEVEZ Carlos', 'Argentina', '1984-02-05', 'Forward'),
(182425, 'QUAYE Daniel', 'Ghana', '1980-12-25', 'Defender'),
(182537, 'JOHNSON Eddie', 'USA', '1984-03-31', 'Forward'),
(182567, 'RODRIGUEZ Michael', 'Costa Rica', '1981-12-30', 'Defender'),
(182587, 'HERNANDEZ Carlos', 'Costa Rica', '1982-04-09', 'Midfielder'),
(182624, 'BARRETO Edgar', 'Paraguay', '1984-07-15', 'Midfielder'),
(182640, 'COUPET Gregory', 'France', '1972-12-31', 'Goalkeeper'),
(182647, 'FREI Alexander', 'Switzerland', '1979-07-15', 'Forward'),
(182648, 'LINDEROTH Tobias', 'Sweden', '1979-04-21', 'Midfielder'),
(182667, 'DULJAJ Igor', 'Serbia and Montenegro', '1979-10-29', 'Midfielder'),
(182757, 'KRSTAJIC Mladen', 'Serbia and Montenegro', '1974-03-04', 'Defender'),
(182759, 'GRAY Cyd', 'Trinidad and Tobago', '1976-11-21', 'Defender'),
(182783, 'CUEVAS Nelson', 'Paraguay', '1980-01-10', 'Forward'),
(182786, 'COLE Ashley', 'England', '1980-12-20', 'Defender'),
(182787, 'CARRAGHER Jamie', 'England', '1978-01-28', 'Defender'),
(182797, 'CHERUNDOLO Steve', 'USA', '1979-02-19', 'Defender'),
(182901, 'KAABI Hossein', 'Iran', '1985-09-23', 'Defender'),
(183000, 'MUNTARI Sulley', 'Ghana', '1984-08-27', 'Midfielder'),
(183004, 'PAPPOE Emmanuel', 'Ghana', '1981-03-03', 'Defender'),
(183007, 'PIMPONG Razak', 'Ghana', '1982-12-30', 'Forward'),
(183008, 'BOATENG Derek', 'Ghana', '1983-05-02', 'Midfielder'),
(183012, 'OWU George', 'Ghana', '1982-07-07', 'Goalkeeper'),
(183238, 'LAMA', 'Angola', '1981-02-01', 'Goalkeeper'),
(183380, 'SCALONI Lionel', 'Argentina', '1978-05-16', 'Defender'),
(183574, 'CAMBIASSO Esteban', 'Argentina', '1980-08-18', 'Midfielder'),
(183576, 'VAN NISTELROOIJ Ruud', 'Netherlands', '1976-07-01', 'Forward'),
(183788, 'BADILLA Gabriel', 'Costa Rica', '1984-06-30', 'Defender'),
(183794, 'AZOFEIFA Randall', 'Costa Rica', '1984-12-30', 'Midfielder'),
(183796, 'BOLANOS Cristian', 'Costa Rica', '1984-05-17', 'Midfielder'),
(183823, 'KRANJCAR Niko', 'Croatia', '1984-08-13', 'Midfielder'),
(183857, 'INIESTA', 'Spain', '1984-05-11', 'Midfielder'),
(183864, 'TORRES Fernando', 'Spain', '1984-03-20', 'Forward'),
(183884, 'BEN SAADA Chaouki', 'Tunisia', '1984-07-01', 'Forward'),
(183937, 'FUKUNISHI Takashi', 'Japan', '1976-09-01', 'Midfielder'),
(184086, 'MADANCHI Mehrzad', 'Iran', '1985-01-10', 'Midfielder'),
(184257, 'DIARRA Alou', 'France', '1981-07-15', 'Midfielder'),
(184291, 'RODRIGUEZ Maxi', 'Argentina', '1981-01-02', 'Midfielder'),
(184312, 'KAKA', 'Brazil', '1982-04-22', 'Midfielder'),
(184316, 'LUISAO', 'Brazil', '1981-02-13', 'Defender'),
(184367, 'MONIWA Teruyuki', 'Japan', '1981-09-08', 'Defender'),
(184402, 'ASAMOAH Gerald', 'Germany', '1978-10-03', 'Forward'),
(184403, 'KEHL Sebastian', 'Germany', '1980-02-13', 'Midfielder'),
(184419, 'BUTINA Tomislav', 'Croatia', '1974-03-30', 'Goalkeeper'),
(184428, 'LANDZAAT Denny', 'Netherlands', '1976-05-06', 'Midfielder'),
(184451, 'MATERAZZI Marco', 'Italy', '1973-08-19', 'Defender'),
(184454, 'BOA MORTE', 'Portugal', '1977-08-04', 'Forward'),
(184545, 'CASTILLO Segundo', 'Ecuador', '1982-05-15', 'Midfielder'),
(184547, 'BORJA Felix', 'Ecuador', '1983-04-02', 'Forward'),
(184557, 'PANTSIL John', 'Ghana', '1981-06-15', 'Defender'),
(184560, 'MENSAH John', 'Ghana', '1982-11-29', 'Defender'),
(184564, 'AMOAH Matthew', 'Ghana', '1980-10-24', 'Forward'),
(184599, 'STEKELENBURG Maarten', 'Netherlands', '1982-09-22', 'Goalkeeper'),
(184607, 'HEITINGA John', 'Netherlands', '1983-11-15', 'Defender'),
(184616, 'ROBBEN Arjen', 'Netherlands', '1984-01-23', 'Forward'),
(185038, 'BORGETTI Jared', 'Mexico', '1973-08-14', 'Forward'),
(185260, 'TCHAGNIROU Ouro-Nimini', 'Togo', '1977-12-31', 'Goalkeeper'),
(185324, 'JUAN', 'Brazil', '1979-02-01', 'Defender'),
(185325, 'MORALES Ramon', 'Mexico', '1975-10-10', 'Forward'),
(185338, 'VILLAR Justo', 'Paraguay', '1977-06-30', 'Goalkeeper'),
(185384, 'CARRICK Michael', 'England', '1981-07-28', 'Midfielder'),
(185385, 'LAMPARD Frank', 'England', '1978-06-20', 'Midfielder'),
(185434, 'METZELDER Christoph', 'Germany', '1980-11-05', 'Defender'),
(185506, 'JONSON Mattias', 'Sweden', '1974-01-16', 'Forward'),
(185507, 'LUCIC Teddy', 'Sweden', '1973-04-15', 'Defender'),
(185639, 'MIRZAPOUR Ebrahim', 'Iran', '1978-09-16', 'Goalkeeper'),
(185641, 'NEKOUNAM Javad', 'Iran', '1980-09-07', 'Midfielder'),
(185642, 'REZAEI Rahman', 'Iran', '1975-02-20', 'Defender'),
(185669, 'JONES Kenwyne', 'Trinidad and Tobago', '1984-10-05', 'Forward'),
(186048, 'BASZCZYNSKI Marcin', 'Poland', '1977-06-07', 'Defender'),
(186155, 'EDMAN Erik', 'Sweden', '1978-11-11', 'Defender'),
(186159, 'HANSSON Petter', 'Sweden', '1976-12-14', 'Defender'),
(186162, 'IBRAHIMOVIC Zlatan', 'Sweden', '1981-10-03', 'Forward'),
(186167, 'KALLSTROM Kim', 'Sweden', '1982-08-24', 'Midfielder'),
(186179, 'WILHELMSSON Christian', 'Sweden', '1979-12-08', 'Midfielder'),
(186196, 'ZURAWSKI Maciej', 'Poland', '1976-09-12', 'Forward'),
(186287, 'ISAKSSON Andreas', 'Sweden', '1981-10-03', 'Goalkeeper'),
(186297, 'ELMANDER Johan', 'Sweden', '1981-05-27', 'Forward'),
(186330, 'LEWANDOWSKI Mariusz', 'Poland', '1979-05-18', 'Defender'),
(186383, 'RASIAK Grzegorz', 'Poland', '1979-01-12', 'Forward'),
(186443, 'BRIDGE Wayne', 'England', '1980-08-05', 'Defender'),
(186591, 'JACK Kelvin', 'Trinidad and Tobago', '1976-04-29', 'Goalkeeper'),
(186619, 'JOAQUIN', 'Spain', '1981-07-21', 'Midfielder'),
(186744, 'AL QADI Naif', 'Saudi Arabia', '1979-04-03', 'Defender'),
(187160, 'BOCANEGRA Carlos', 'USA', '1979-05-25', 'Defender'),
(187191, 'CANEIRA', 'Portugal', '1979-02-09', 'Defender'),
(187197, 'PAULO FERREIRA', 'Portugal', '1979-01-18', 'Defender'),
(187199, 'TIAGO', 'Portugal', '1981-05-02', 'Midfielder'),
(187203, 'HELDER POSTIGA', 'Portugal', '1982-08-02', 'Forward'),
(187204, 'MIGUEL', 'Portugal', '1980-01-04', 'Defender'),
(187258, 'OLIC Ivica', 'Croatia', '1979-09-14', 'Forward'),
(187266, 'TOKIC Mario', 'Croatia', '1975-07-23', 'Defender'),
(187267, 'GILBERTO SILVA', 'Brazil', '1976-10-07', 'Midfielder'),
(187349, 'SANTOS Alessandro', 'Japan', '1977-07-20', 'Defender'),
(187434, 'TENORIO Carlos', 'Ecuador', '1979-05-14', 'Forward'),
(187756, 'GALLAS William', 'France', '1977-08-17', 'Defender'),
(187757, 'HAHNEMANN Marcus', 'USA', '1972-06-15', 'Goalkeeper'),
(188293, 'MASTROENI Pablo', 'USA', '1976-08-29', 'Defender'),
(188386, 'KIM Nam Il', 'Korea Republic', '1977-03-14', 'Midfielder'),
(188511, 'SIMUNIC Josip', 'Croatia', '1978-02-18', 'Defender'),
(188516, 'SMOLAREK Ebi', 'Poland', '1981-01-09', 'Midfielder'),
(189201, 'KOSOWSKI Kamil', 'Poland', '1977-08-30', 'Midfielder'),
(189334, 'CACERES Julio Cesar', 'Paraguay', '1979-10-05', 'Defender'),
(189432, 'HUGO VIANA', 'Portugal', '1983-01-15', 'Midfielder'),
(189433, 'BOSNJAK Ivan', 'Croatia', '1979-02-06', 'Forward'),
(189436, 'BONET Carlos', 'Paraguay', '1977-10-02', 'Midfielder'),
(189571, 'LEE Eul Yong', 'Korea Republic', '1975-09-08', 'Midfielder'),
(189752, 'LEKO Jerko', 'Croatia', '1980-04-09', 'Midfielder'),
(189768, 'BABIC Marko', 'Croatia', '1981-01-28', 'Midfielder'),
(189998, 'TUKAR Redha', 'Saudi Arabia', '1975-11-29', 'Defender'),
(189999, 'KHATHRAN Abdulaziz', 'Saudi Arabia', '1973-07-31', 'Defender'),
(190000, 'ZAID Mabrouk', 'Saudi Arabia', '1979-02-11', 'Goalkeeper'),
(191172, 'HILDEBRAND Timo', 'Germany', '1979-04-05', 'Goalkeeper'),
(191178, 'FRIEDRICH Arne', 'Germany', '1979-05-29', 'Defender'),
(191193, 'BOROWSKI Tim', 'Germany', '1980-05-02', 'Midfielder'),
(193859, 'SEQUEIRA Douglas', 'Costa Rica', '1977-08-23', 'Midfielder'),
(193885, 'AGBOH Kuami', 'Togo', '1977-12-28', 'Midfielder'),
(193984, 'CUFRE Leandro', 'Argentina', '1978-05-09', 'Defender'),
(193986, 'FRANCO Leonardo', 'Argentina', '1977-05-20', 'Goalkeeper'),
(194072, 'MENDEZ Mario', 'Mexico', '1979-06-01', 'Defender'),
(194080, 'CABANAS Salvador', 'Paraguay', '1980-08-05', 'Midfielder'),
(194104, 'AL BAHRI Ahmed', 'Saudi Arabia', '1980-09-18', 'Defender'),
(194139, 'MILITO Gabriel', 'Argentina', '1980-09-07', 'Defender'),
(194152, 'FONSECA Danny', 'Costa Rica', '1979-11-07', 'Midfielder'),
(194176, 'CROUCH Peter', 'England', '1981-01-30', 'Forward'),
(194226, 'KAJI Akira', 'Japan', '1980-01-13', 'Defender'),
(194815, 'ROBINHO', 'Brazil', '1984-01-25', 'Forward'),
(195105, 'RADOMSKI Arkadiusz', 'Poland', '1977-06-27', 'Midfielder'),
(195231, 'CORONA Jose', 'Mexico', '1981-01-26', 'Goalkeeper'),
(195417, 'VILLAFUERTE Edwin', 'Ecuador', '1979-03-12', 'Goalkeeper'),
(195809, 'PORRAS Jose', 'Costa Rica', '1970-11-08', 'Goalkeeper'),
(196633, 'BENAGLIO Diego', 'Switzerland', '1983-09-08', 'Goalkeeper'),
(196667, 'DEGEN Philipp', 'Switzerland', '1983-02-15', 'Defender'),
(196689, 'DEGEN David', 'Switzerland', '1983-02-15', 'Forward'),
(196690, 'MARGAIRAZ Xavier', 'Switzerland', '1984-01-07', 'Midfielder'),
(196745, 'HANKE Mike', 'Germany', '1983-11-05', 'Forward'),
(196748, 'LAHM Philipp', 'Germany', '1983-11-11', 'Defender'),
(196752, 'SCHWEINSTEIGER Bastian', 'Germany', '1984-08-01', 'Midfielder'),
(196757, 'ODONKOR David', 'Germany', '1984-02-21', 'Midfielder'),
(196789, 'PODOLSKI Lukas', 'Germany', '1985-06-04', 'Forward'),
(196791, 'JANSEN Marcell', 'Germany', '1985-11-04', 'Defender'),
(196842, 'ROONEY Wayne', 'England', '1985-10-24', 'Forward'),
(197411, 'MILLIGAN Mark', 'Australia', '1985-08-04', 'Defender'),
(197463, 'JENAS Jermaine', 'England', '1983-02-18', 'Midfielder'),
(197690, 'REYES Jose Antonio', 'Spain', '1983-09-01', 'Midfielder'),
(197716, 'DOWNING Stewart', 'England', '1984-07-22', 'Midfielder'),
(197753, 'CARSON Scott', 'England', '1985-09-03', 'Goalkeeper'),
(197964, 'KIM Young Kwang', 'Korea Republic', '1983-06-28', 'Goalkeeper'),
(197972, 'CHO Won Hee', 'Korea Republic', '1983-04-17', 'Defender'),
(197995, 'MASSAD Mohammed', 'Saudi Arabia', '1983-02-17', 'Midfielder'),
(198051, 'EBOUE Emmanuel', 'Cote d Ivoire', '1983-06-04', 'Defender'),
(198106, 'TOURE Yaya', 'Cote d Ivoire', '1983-05-13', 'Midfielder'),
(198111, 'ROMARIC', 'Cote d Ivoire', '1983-06-04', 'Midfielder'),
(198281, 'LOPEZ Dante', 'Paraguay', '1983-08-16', 'Forward'),
(198282, 'DOS SANTOS Julio', 'Paraguay', '1983-05-07', 'Midfielder'),
(198446, 'JUANITO', 'Spain', '1976-07-23', 'Defender'),
(198487, 'ZORO Marc', 'Cote d Ivoire', '1983-12-27', 'Defender'),
(198489, 'BOKA Arthur', 'Cote d Ivoire', '1983-04-02', 'Defender'),
(198494, 'KONE Arouna', 'Cote d Ivoire', '1983-11-11', 'Forward'),
(198547, 'KIM Jin Kyu', 'Korea Republic', '1985-02-16', 'Defender'),
(198554, 'BAEK Ji Hoon', 'Korea Republic', '1985-02-28', 'Midfielder'),
(198556, 'KIM Young Chul', 'Korea Republic', '1976-06-30', 'Defender'),
(198972, 'TSUBOI Keisuke', 'Japan', '1979-09-16', 'Defender'),
(199026, 'DECO', 'Portugal', '1977-08-27', 'Midfielder'),
(199035, 'SULIMANI Hussein', 'Saudi Arabia', '1977-01-21', 'Defender'),
(199916, 'CHING Brian', 'USA', '1978-05-24', 'Forward'),
(200129, 'USTARI Oscar', 'Argentina', '1986-07-03', 'Goalkeeper'),
(200179, 'FABREGAS Cesc', 'Spain', '1987-05-04', 'Midfielder'),
(200313, 'DOI Yoichi', 'Japan', '1973-07-25', 'Goalkeeper'),
(200706, 'ISSAH Ahmed', 'Ghana', '1982-05-24', 'Defender'),
(200738, 'GONZALEZ Leonardo', 'Costa Rica', '1980-11-21', 'Defender'),
(200739, 'SABORIO Alvaro', 'Costa Rica', '1982-03-25', 'Forward'),
(201200, 'CRISTIANO RONALDO', 'Portugal', '1985-02-05', 'Forward'),
(201964, 'HEINZE Gabriel', 'Argentina', '1978-04-19', 'Defender'),
(201965, 'GONZALEZ Luis', 'Argentina', '1981-01-19', 'Midfielder'),
(202280, 'SARITAMA Luis', 'Ecuador', '1983-10-20', 'Midfielder'),
(202541, 'LARA Christian', 'Ecuador', '1980-04-27', 'Midfielder'),
(202543, 'AMBROSI Paul', 'Ecuador', '1980-10-14', 'Defender'),
(202544, 'VALENCIA Luis', 'Ecuador', '1985-08-04', 'Midfielder'),
(203808, 'KIM Do Heon', 'Korea Republic', '1982-07-14', 'Midfielder'),
(205054, 'KALI', 'Angola', '1978-10-11', 'Defender'),
(205055, 'FIGUEIREDO', 'Angola', '1972-11-28', 'Midfielder'),
(205056, 'ANDRE', 'Angola', '1978-05-14', 'Midfielder'),
(206415, 'ERASSA Affo', 'Togo', '1983-02-19', 'Midfielder'),
(207528, 'XABI ALONSO', 'Spain', '1981-11-25', 'Midfielder'),
(207707, 'VALDEZ Nelson', 'Paraguay', '1983-11-28', 'Forward'),
(207761, 'PARK Chu Young', 'Korea Republic', '1985-07-10', 'Forward'),
(207763, 'LEE Ho', 'Korea Republic', '1984-10-22', 'Midfielder'),
(207851, 'DEMPSEY Clint', 'USA', '1983-03-09', 'Midfielder'),
(207861, 'HUTH Robert', 'Germany', '1984-08-18', 'Defender'),
(207888, 'MERTESACKER Per', 'Germany', '1984-09-29', 'Defender'),
(208120, 'UMANA Michael', 'Costa Rica', '1982-07-16', 'Defender'),
(208353, 'GYAN Asamoah', 'Ghana', '1985-11-22', 'Forward'),
(209119, 'DE ROSSI Daniele', 'Italy', '1983-07-24', 'Midfielder'),
(209148, 'GUEMAMDIA Haykel', 'Tunisia', '1981-12-22', 'Forward'),
(209161, 'SHILLA Illiasu', 'Ghana', '1982-10-26', 'Defender'),
(209201, 'LOCO', 'Angola', '1984-12-25', 'Defender'),
(209503, 'MANZUR Julio', 'Paraguay', '1981-01-22', 'Defender'),
(209790, 'STRELLER Marco', 'Switzerland', '1981-06-18', 'Forward'),
(209791, 'SAHA Louis', 'France', '1978-08-08', 'Forward'),
(209897, 'CHUNG Kyung Ho', 'Korea Republic', '1980-05-22', 'Forward'),
(209900, 'KIM Dong Jin', 'Korea Republic', '1982-01-29', 'Defender'),
(209902, 'CHO Jae Jin', 'Korea Republic', '1981-07-09', 'Forward'),
(209955, 'PINEDA Gonzalo', 'Mexico', '1982-10-19', 'Defender'),
(209960, 'RODRIGUEZ Francisco', 'Mexico', '1981-10-20', 'Defender'),
(209979, 'BARNETTA Tranquillo', 'Switzerland', '1985-05-22', 'Midfielder'),
(209983, 'GYGAX Daniel', 'Switzerland', '1981-08-28', 'Forward'),
(209989, 'SENDEROS Philippe', 'Switzerland', '1985-02-14', 'Defender'),
(210003, 'BEAUCHAMP Michael', 'Australia', '1981-03-08', 'Defender'),
(210045, 'ALVBAGE John', 'Sweden', '1982-08-10', 'Goalkeeper'),
(210053, 'STENMAN Fredrik', 'Sweden', '1983-06-02', 'Defender'),
(210074, 'SANTOS', 'Tunisia', '1979-03-20', 'Forward'),
(210096, 'ROSENBERG Markus', 'Sweden', '1982-09-27', 'Forward'),
(210125, 'VIDIC Nemanja', 'Serbia and Montenegro', '1981-10-21', 'Defender'),
(210142, 'ERGIC Ivan', 'Serbia and Montenegro', '1981-01-21', 'Midfielder'),
(210179, 'AMELIA Marco', 'Italy', '1982-04-02', 'Goalkeeper'),
(210192, 'ZACCARDO Cristian', 'Italy', '1981-12-21', 'Defender'),
(210205, 'GILARDINO Alberto', 'Italy', '1982-07-05', 'Forward'),
(210212, 'RICARDO COSTA', 'Portugal', '1981-05-16', 'Defender'),
(210434, 'AL MONTASHARI Hamad', 'Saudi Arabia', '1982-06-22', 'Defender'),
(210439, 'AL KAHTANI Yasser', 'Saudi Arabia', '1982-10-10', 'Forward'),
(210441, 'KARIRI Saud', 'Saudi Arabia', '1980-07-08', 'Midfielder'),
(210454, 'ENAYATI Reza', 'Iran', '1976-09-23', 'Forward'),
(210455, 'ROUDBARIAN Hassan', 'Iran', '1978-07-06', 'Goalkeeper'),
(210456, 'NAVIDKIA Moharram', 'Iran', '1982-11-01', 'Midfielder'),
(210460, 'NOSRATI Mohammad', 'Iran', '1982-01-11', 'Defender'),
(210462, 'BORHANI Arash', 'Iran', '1983-09-14', 'Forward'),
(210564, 'HAGGUI Karim', 'Tunisia', '1984-01-20', 'Defender'),
(210566, 'SAIDI Karim', 'Tunisia', '1983-03-24', 'Defender'),
(210704, 'SRNA Darijo', 'Croatia', '1982-05-01', 'Midfielder'),
(211352, 'KONE Bakary', 'Cote d Ivoire', '1981-09-17', 'Forward'),
(211976, 'TAMADA Keiji', 'Japan', '1980-04-11', 'Forward'),
(212306, 'DROGBA Didier', 'Cote d Ivoire', '1978-03-11', 'Forward'),
(212418, 'KASRAOUI Hamdi', 'Tunisia', '1983-01-18', 'Goalkeeper'),
(212421, 'YAHIA Alaeddine', 'Tunisia', '1981-09-26', 'Defender'),
(213001, 'CAHILL Tim', 'Australia', '1979-12-06', 'Midfielder'),
(213090, 'TACHIE-MENSAH Alex', 'Ghana', '1977-02-15', 'Forward'),
(213109, 'ZANDI Ferydoon', 'Iran', '1979-04-26', 'Midfielder'),
(213124, 'SADEQI Amir Hossein', 'Iran', '1981-09-06', 'Defender'),
(213170, 'SHOJAEI Masoud', 'Iran', '1984-06-09', 'Midfielder'),
(213172, 'TALEBLOO Vahid', 'Iran', '1982-05-26', 'Goalkeeper'),
(213369, 'MNARI Jaouhar', 'Tunisia', '1976-11-08', 'Midfielder'),
(213370, 'BOUAZIZI Riadh', 'Tunisia', '1973-04-08', 'Midfielder'),
(213371, 'CHEDLI Adel', 'Tunisia', '1976-09-16', 'Midfielder'),
(213375, 'AYARI Anis', 'Tunisia', '1982-02-16', 'Defender'),
(213483, 'AL GHAMDI Omar', 'Saudi Arabia', '1979-04-11', 'Midfielder'),
(213623, 'AZIZ Khaled', 'Saudi Arabia', '1981-07-14', 'Midfielder'),
(213904, 'GNANHOUAN Gerard', 'Cote d Ivoire', '1979-02-12', 'Goalkeeper'),
(213907, 'MEITE Abdoulaye', 'Cote d Ivoire', '1980-10-06', 'Defender'),
(213909, 'AKALE Kanga', 'Cote d Ivoire', '1981-03-07', 'Midfielder'),
(213910, 'DEMEL Guy', 'Cote d Ivoire', '1981-06-13', 'Midfielder'),
(213995, 'OSORIO Ricardo', 'Mexico', '1980-03-30', 'Defender'),
(214007, 'BRAVO Omar', 'Mexico', '1980-03-04', 'Forward'),
(214012, 'FONSECA Jose', 'Mexico', '1979-10-02', 'Forward'),
(214015, 'CASTRO Jose Antonio', 'Mexico', '1980-08-11', 'Defender'),
(214021, 'ODDO Massimo', 'Italy', '1976-06-14', 'Defender'),
(214022, 'CAMORANESI Mauro', 'Italy', '1976-10-04', 'Midfielder'),
(214131, 'THEOBALD Densill', 'Trinidad and Tobago', '1982-06-27', 'Midfielder'),
(214133, 'GLEN Cornell', 'Trinidad and Tobago', '1980-10-21', 'Forward'),
(214308, 'OBILALE Kodjovi', 'Togo', '1984-10-08', 'Goalkeeper'),
(214311, 'SENAYA Yao Junior', 'Togo', '1984-04-19', 'Forward'),
(214332, 'ASSEMOASSA Ludovic', 'Togo', '1980-09-18', 'Defender'),
(214377, 'BARZAGLI Andrea', 'Italy', '1981-05-08', 'Defender'),
(214386, 'STOJKOVIC Vladimir', 'Serbia and Montenegro', '1983-07-28', 'Goalkeeper'),
(214425, 'ALFARO Wardy', 'Costa Rica', '1977-12-31', 'Goalkeeper'),
(214427, 'BERNARD Kurt', 'Costa Rica', '1977-12-08', 'Forward'),
(214456, 'MAMAM Cherif Toure', 'Togo', '1983-01-13', 'Midfielder'),
(214460, 'DOSSEVI Thomas', 'Togo', '1979-03-06', 'Midfielder'),
(214461, 'MALM Robert', 'Togo', '1973-08-21', 'Forward'),
(214474, 'GRICHTING Stephane', 'Switzerland', '1979-03-30', 'Defender'),
(214476, 'SPYCHER Christoph', 'Switzerland', '1978-03-30', 'Defender'),
(214613, 'AMEEN Mohammed', 'Saudi Arabia', '1980-04-29', 'Midfielder'),
(214617, 'ZE KALANGA', 'Angola', '1983-10-12', 'Midfielder'),
(214671, 'SVENSSON Karl', 'Sweden', '1984-03-21', 'Defender'),
(214780, 'ESSEDIRI Karim', 'Tunisia', '1979-07-29', 'Forward'),
(214931, 'KLASNIC Ivan', 'Croatia', '1980-01-29', 'Forward'),
(214938, 'MARES Pavel', 'Czech Republic', '1976-01-18', 'Defender'),
(214941, 'JIRANEK Martin', 'Czech Republic', '1979-05-25', 'Defender'),
(214944, 'ROZEHNAL David', 'Czech Republic', '1980-07-05', 'Defender'),
(214945, 'PLASIL Jaroslav', 'Czech Republic', '1982-01-05', 'Midfielder'),
(214946, 'KINSKY Antonin', 'Czech Republic', '1975-05-31', 'Goalkeeper'),
(214957, 'RICARDO CARVALHO', 'Portugal', '1978-05-18', 'Defender'),
(214961, 'GERRARD Steven', 'England', '1980-05-30', 'Midfielder'),
(214962, 'TERRY John', 'England', '1980-12-07', 'Defender'),
(214963, 'ROBINSON Paul', 'England', '1979-10-15', 'Goalkeeper'),
(214964, 'MANICHE', 'Portugal', '1977-11-11', 'Midfielder'),
(214967, 'NUNO VALENTE', 'Portugal', '1974-09-12', 'Defender'),
(214996, 'NILSSON Mikael', 'Sweden', '1978-06-24', 'Defender'),
(215002, 'SNEIJDER Wesley', 'Netherlands', '1984-06-09', 'Midfielder'),
(215285, 'OCHOA Guillermo', 'Mexico', '1985-07-13', 'Goalkeeper'),
(215624, 'BARONE Simone', 'Italy', '1978-04-30', 'Midfielder'),
(216129, 'BORUC Artur', 'Poland', '1980-02-20', 'Goalkeeper'),
(216135, 'BOSACKI Bartosz', 'Poland', '1975-12-20', 'Defender'),
(216220, 'GUSEV Oleg', 'Ukraine', '1983-04-25', 'Midfielder'),
(216223, 'RUSOL Andriy', 'Ukraine', '1983-01-16', 'Defender'),
(216224, 'YEZERSKYI Vladimir', 'Ukraine', '1976-11-15', 'Defender'),
(216226, 'KALINICHENKO Maksym', 'Ukraine', '1979-01-26', 'Midfielder'),
(216228, 'NAZARENKO Serhiy', 'Ukraine', '1980-02-16', 'Midfielder'),
(216232, 'ROTAN Ruslan', 'Ukraine', '1981-10-29', 'Midfielder'),
(216233, 'SHELAYEV Oleg', 'Ukraine', '1976-11-05', 'Midfielder'),
(216237, 'VORONIN Andriy', 'Ukraine', '1979-07-21', 'Forward'),
(216566, 'LANZA Damian', 'Ecuador', '1982-04-10', 'Goalkeeper'),
(216627, 'BEHRAMI Valon', 'Switzerland', '1985-04-19', 'Midfielder'),
(216645, 'DJOUROU Johan', 'Switzerland', '1987-01-18', 'Defender'),
(216646, 'DZEMAILI Blerim', 'Switzerland', '1986-04-12', 'Midfielder'),
(216714, 'SHUST Bohdan', 'Ukraine', '1986-03-04', 'Goalkeeper'),
(216720, 'MADURO Hedwiges', 'Netherlands', '1985-02-13', 'Midfielder'),
(216722, 'CHIGRYNSKYI Dmytro', 'Ukraine', '1986-11-07', 'Defender'),
(216733, 'BABEL Ryan', 'Netherlands', '1986-12-19', 'Forward'),
(216753, 'MILEVSKIY Artem', 'Ukraine', '1985-01-12', 'Forward'),
(216814, 'RAMOS Sergio', 'Spain', '1986-03-30', 'Defender'),
(216915, 'DJORDJEVIC Nenad', 'Serbia and Montenegro', '1979-08-07', 'Defender'),
(216916, 'DUDIC Milan', 'Serbia and Montenegro', '1979-11-01', 'Defender'),
(216917, 'GAVRANCIC Goran', 'Serbia and Montenegro', '1978-08-02', 'Defender'),
(216921, 'DRAGUTINOVIC Ivica', 'Serbia and Montenegro', '1975-11-13', 'Defender'),
(216925, 'VUKIC Zvonimir', 'Serbia and Montenegro', '1979-07-19', 'Midfielder'),
(216927, 'LJUBOJA Danijel', 'Serbia and Montenegro', '1978-09-04', 'Forward'),
(216929, 'ZIGIC Nikola', 'Serbia and Montenegro', '1980-09-25', 'Forward'),
(216931, 'FABIANSKI Lukasz', 'Poland', '1985-04-18', 'Goalkeeper'),
(217014, 'KOVACEVIC Oliver', 'Serbia and Montenegro', '1974-10-29', 'Goalkeeper'),
(217015, 'KOROMAN Ognjen', 'Serbia and Montenegro', '1978-09-19', 'Midfielder'),
(217227, 'LEKO Ivan', 'Croatia', '1978-02-07', 'Midfielder'),
(217257, 'DUDKA Dariusz', 'Poland', '1983-12-09', 'Defender'),
(217260, 'SOBOLEWSKI Radoslaw', 'Poland', '1976-12-13', 'Midfielder'),
(217264, 'JELEN Ireneusz', 'Poland', '1981-04-09', 'Forward'),
(217301, 'JALIENS Kew', 'Netherlands', '1978-09-15', 'Defender'),
(217303, 'KROMKAMP Jan', 'Netherlands', '1980-08-17', 'Defender'),
(217313, 'KUYT Dirk', 'Netherlands', '1980-07-22', 'Forward'),
(217315, 'VAN PERSIE Robin', 'Netherlands', '1983-08-06', 'Forward'),
(217409, 'STAJNER Jiri', 'Czech Republic', '1976-05-27', 'Midfielder'),
(217821, 'LEBO LEBO', 'Angola', '1977-05-29', 'Defender'),
(217844, 'PABLO', 'Spain', '1981-08-03', 'Defender'),
(217847, 'LOPEZ Antonio', 'Spain', '1981-09-13', 'Defender'),
(217850, 'GARCIA Luis', 'Spain', '1978-06-24', 'Forward'),
(217882, 'TONI Luca', 'Italy', '1977-05-26', 'Forward'),
(217974, 'ABIDAL Eric', 'France', '1979-09-11', 'Defender'),
(217999, 'OLUFADE Adekanmi', 'Togo', '1980-01-07', 'Forward'),
(218246, 'BOULAHROUZ Khalid', 'Netherlands', '1981-12-28', 'Defender'),
(218252, 'ZINHA', 'Mexico', '1976-05-23', 'Midfielder'),
(218253, 'SALCIDO Carlos', 'Mexico', '1980-04-02', 'Defender'),
(225204, 'MALOUDA Florent', 'France', '1980-06-13', 'Midfielder'),
(225492, 'AL HARTHI Saad', 'Saudi Arabia', '1984-02-03', 'Forward'),
(228268, 'KHATIBI Rasoul', 'Iran', '1978-09-22', 'Forward'),
(228273, 'KHOJAH Mohammad', 'Saudi Arabia', '1982-03-15', 'Goalkeeper'),
(228281, 'MATHIJSEN Joris', 'Netherlands', '1980-04-05', 'Defender'),
(228384, 'URRUTIA Patricio', 'Ecuador', '1977-10-15', 'Midfielder'),
(228519, 'MONTIEL Jose', 'Paraguay', '1988-03-19', 'Midfielder'),
(228682, 'NAMOUCHI Hamed', 'Tunisia', '1984-02-14', 'Midfielder'),
(229397, 'MESSI Lionel', 'Argentina', '1987-06-24', 'Forward'),
(229816, 'OGURO Masashi', 'Japan', '1980-05-04', 'Forward'),
(229823, 'CONRAD Jimmy', 'USA', '1977-02-12', 'Defender'),
(229846, 'SVIDERSKYI Vyacheslav', 'Ukraine', '1979-01-01', 'Defender'),
(229884, 'VILLA David', 'Spain', '1981-12-03', 'Forward'),
(229887, 'CHARLES Atiba', 'Trinidad and Tobago', '1977-09-29', 'Defender'),
(230525, 'GIZA Piotr', 'Poland', '1980-02-28', 'Midfielder'),
(230739, 'PALACIO Rodrigo', 'Argentina', '1982-02-05', 'Forward'),
(230740, 'TIMMER Henk', 'Netherlands', '1971-12-03', 'Goalkeeper'),
(230756, 'GROSSO Fabio', 'Italy', '1977-11-28', 'Defender'),
(230774, 'COLTORTI Fabio', 'Switzerland', '1980-12-03', 'Goalkeeper'),
(231192, 'BASTA Dusan', 'Serbia and Montenegro', '1984-08-18', 'Defender'),
(233263, 'IATSENKO Oleksandr', 'Ukraine', '1985-02-24', 'Defender'),
(233781, 'CHIKHAOUI Yassine', 'Tunisia', '1986-09-22', 'Forward'),
(233951, 'CICINHO', 'Brazil', '1980-06-24', 'Defender'),
(233952, 'FRED', 'Brazil', '1983-10-03', 'Forward'),
(234927, 'IAQUINTA Vincenzo', 'Italy', '1979-11-21', 'Forward'),
(235063, 'BIRCHALL Christopher', 'Trinidad and Tobago', '1984-05-05', 'Midfielder'),
(235065, 'WOLFE Anthony', 'Trinidad and Tobago', '1983-12-23', 'Midfielder'),
(235273, 'MORA Cristian', 'Ecuador', '1979-08-26', 'Goalkeeper'),
(235367, 'DRAMAN Haminu', 'Ghana', '1986-04-01', 'Midfielder'),
(235880, 'MILOY', 'Angola', '1981-05-27', 'Midfielder'),
(237089, 'SAMUEL Collin', 'Trinidad and Tobago', '1981-08-27', 'Forward'),
(237781, 'MAKI Seiichiro', 'Japan', '1980-08-07', 'Forward'),
(237782, 'LUSTRINELLI Mauro', 'Switzerland', '1976-02-26', 'Forward'),
(237949, 'TEYMOURIAN Andranik', 'Iran', '1983-03-06', 'Midfielder'),
(238003, 'DE CLER Tim', 'Netherlands', '1978-11-08', 'Defender'),
(238284, 'MARCO ABREU', 'Angola', '1974-12-08', 'Defender'),
(238294, 'JOP Mariusz', 'Poland', '1978-08-03', 'Defender'),
(238645, 'GOMEZ Derlis', 'Paraguay', '1972-11-02', 'Goalkeeper'),
(238679, 'ROMAO Alaixys', 'Togo', '1984-01-18', 'Midfielder'),
(238731, 'RUI MARQUES', 'Angola', '1977-09-03', 'Defender'),
(241559, 'MODRIC Luka', 'Croatia', '1985-09-09', 'Midfielder'),
(241632, 'FRANCO Guillermo', 'Mexico', '1976-11-03', 'Forward'),
(242938, 'BROZEK Pawel', 'Poland', '1983-04-21', 'Forward'),
(243130, 'MARCOS AIROSA', 'Angola', '1984-08-06', 'Defender'),
(245417, 'FAE Emerse', 'Cote d Ivoire', '1984-01-24', 'Midfielder'),
(245617, 'NUNEZ Jorge', 'Paraguay', '1978-01-22', 'Defender'),
(247077, 'EDSON', 'Angola', '1980-03-02', 'Midfielder'),
(248373, 'RIBERY Frank', 'France', '1983-04-07', 'Midfielder'),
(248772, 'FORSON Richmond', 'Togo', '1980-05-23', 'Forward'),
(249300, 'ANDRE TITI BUENGO', 'Angola', '1980-02-11', 'Forward'),
(251352, 'GUARDADO Andres', 'Mexico', '1986-09-28', 'Defender'),
(251565, 'GANCARCZYK Seweryn', 'Poland', '1981-11-22', 'Defender'),
(252186, 'AL HAWSAWI Malek', 'Saudi Arabia', '1981-08-10', 'Forward'),
(252193, 'COVIC Ante', 'Australia', '1975-06-13', 'Goalkeeper'),
(252195, 'KENNEDY Joshua', 'Australia', '1982-08-20', 'Forward'),
(252592, 'NUNEZ Victor', 'Costa Rica', '1980-04-15', 'Forward'),
(252756, 'MATEUS', 'Angola', '1984-06-18', 'Midfielder'),
(252897, 'WALCOTT Theo', 'England', '1989-03-16', 'Forward'),
(252997, 'LENNON Aaron', 'England', '1987-04-16', 'Midfielder'),
(253192, 'BENITEZ Cristian', 'Ecuador', '1986-05-01', 'Forward'),
(253195, 'SHAABAN Rami', 'Sweden', '1975-06-30', 'Goalkeeper'),
(253358, 'ADDO Eric', 'Ghana', '1978-11-12', 'Midfielder'),
(253359, 'MOHAMED Habib', 'Ghana', '1983-12-10', 'Defender'),
(253390, 'PYATOV Andriy', 'Ukraine', '1984-06-28', 'Goalkeeper'),
(253460, 'RIVEROS Cristian', 'Paraguay', '1982-10-16', 'Midfielder'),
(253509, 'AL BISHI Mohamed', 'Saudi Arabia', '1987-05-03', 'Defender'),
(253515, 'MARIO', 'Angola', '1985-06-01', 'Goalkeeper'),
(253583, 'TOURE Assimiou', 'Togo', '1988-01-01', 'Defender'),
(253585, 'CHIMBONDA Pascal', 'France', '1979-02-21', 'Defender'),
(253600, 'JAMBA', 'Angola', '1977-07-10', 'Defender'),
(253614, 'NEFZI Adel', 'Tunisia', '1974-03-16', 'Goalkeeper'),
(253620, 'JEMMALI David', 'Tunisia', '1974-12-13', 'Defender'),
(254052, 'PERNIA Mariano', 'Spain', '1977-05-04', 'Defender'),
(100000003, 'HITZLSPERGER Thomas', 'Germany', '1982-04-05', 'Midfielder');

-- --------------------------------------------------------

--
-- Tabellenstruktur für Tabelle `Stadien`
--

CREATE TABLE IF NOT EXISTS `Stadien` (
  `Stadt` varchar(20) NOT NULL,
  `AnzPlätze` int(11) DEFAULT NULL,
  PRIMARY KEY (`Stadt`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Daten für Tabelle `Stadien`
--

INSERT INTO `Stadien` (`Stadt`, `AnzPlätze`) VALUES
('Berlin', 72000),
('Cologne', 45000),
('Dortmund', 65000),
('Frankfurt', 48000),
('Gelsenkirchen', 52000),
('Hamburg', 50000),
('Hanover', 43000),
('Kaiserslautern', 46000),
('Leipzig', 43000),
('Munich', 66000),
('Nuremberg', 41000),
('Stuttgart', 52000);

-- --------------------------------------------------------

--
-- Tabellenstruktur für Tabelle `Tore`
--

CREATE TABLE IF NOT EXISTS `Tore` (
  `SpielerNr` int(11) NOT NULL DEFAULT '0',
  `SpielID` int(11) NOT NULL DEFAULT '0',
  `Minute` int(11) NOT NULL DEFAULT '0',
  `Spielsituation` varchar(20) DEFAULT NULL,
  PRIMARY KEY (`SpielerNr`,`SpielID`,`Minute`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Daten für Tabelle `Tore`
--

INSERT INTO `Tore` (`SpielerNr`, `SpielID`, `Minute`, `Spielsituation`) VALUES
(3508, 18, 92, '--'),
(4332, 36, 25, 'own goal'),
(77503, 16, 84, '--'),
(77995, 35, 90, '--'),
(92699, 43, 46, '--'),
(92699, 43, 81, '--'),
(92699, 55, 5, '--'),
(94915, 3, 3, 'own goal'),
(153933, 57, 49, '--'),
(154050, 12, 92, '--'),
(154061, 44, 38, 'penalty goal'),
(154799, 1, 12, '--'),
(154799, 1, 73, '--'),
(155011, 2, 80, '--'),
(155011, 18, 54, '--'),
(155148, 31, 71, '--'),
(155382, 42, 47, 'penalty goal'),
(155696, 44, 56, '--'),
(155851, 7, 36, '--'),
(155963, 61, 121, '--'),
(155969, 41, 87, '--'),
(156216, 14, 72, '--'),
(158048, 14, 31, '--'),
(158268, 16, 92, '--'),
(158385, 32, 36, '--'),
(158386, 32, 46, '--'),
(158386, 48, 70, 'penalty goal'),
(159069, 44, 79, '--'),
(159284, 40, 75, '--'),
(161454, 51, 60, '--'),
(162680, 5, 24, '--'),
(162680, 21, 78, '--'),
(162680, 50, 10, '--'),
(163331, 56, 92, '--'),
(163331, 62, 33, 'penalty goal'),
(163331, 64, 7, 'penalty goal'),
(165247, 53, 95, 'penalty goal'),
(165260, 63, 88, '--'),
(166375, 8, 4, '--'),
(169551, 20, 89, '--'),
(170167, 34, 25, '--'),
(170687, 55, 84, '--'),
(170707, 45, 55, '--'),
(170707, 56, 83, '--'),
(170711, 29, 9, '--'),
(170711, 45, 61, '--'),
(170711, 60, 57, '--'),
(175683, 27, 49, '--'),
(175683, 55, 46, '--'),
(176530, 43, 53, '--'),
(176534, 43, 59, '--'),
(176953, 16, 23, '--'),
(176984, 38, 37, 'penalty goal'),
(176984, 38, 67, '--'),
(176991, 40, 60, '--'),
(177615, 38, 86, 'penalty goal'),
(177655, 58, 6, '--'),
(177703, 35, 51, '--'),
(177712, 10, 5, '--'),
(177773, 12, 26, '--'),
(177788, 29, 81, '--'),
(177823, 10, 36, '--'),
(177823, 10, 76, '--'),
(177876, 9, 40, '--'),
(178119, 50, 6, '--'),
(178469, 14, 54, '--'),
(178837, 5, 38, '--'),
(179159, 39, 24, 'penalty goal'),
(179174, 38, 20, '--'),
(179558, 17, 91, '--'),
(179662, 35, 34, '--'),
(182197, 63, 60, 'own goal'),
(182206, 1, 17, '--'),
(182206, 1, 61, '--'),
(182206, 33, 4, '--'),
(182206, 33, 44, '--'),
(182206, 57, 80, '--'),
(182207, 1, 87, '--'),
(182373, 21, 84, '--'),
(182647, 30, 16, '--'),
(182647, 46, 77, '--'),
(182783, 36, 86, '--'),
(183000, 26, 82, '--'),
(183574, 21, 31, '--'),
(183576, 22, 27, '--'),
(183864, 15, 81, '--'),
(183864, 31, 76, '--'),
(183864, 31, 91, 'penalty goal'),
(184291, 21, 6, '--'),
(184291, 21, 41, '--'),
(184291, 50, 98, '--'),
(184312, 11, 44, '--'),
(184451, 41, 26, '--'),
(184451, 64, 19, '--'),
(184616, 6, 18, '--'),
(187434, 2, 24, '--'),
(187434, 18, 8, '--'),
(194176, 19, 83, '--'),
(196748, 1, 6, '--'),
(196752, 63, 56, '--'),
(196752, 63, 78, '--'),
(196789, 33, 57, '--'),
(196789, 49, 4, '--'),
(196789, 49, 12, '--'),
(198446, 47, 36, '--'),
(199026, 24, 63, '--'),
(201200, 24, 80, 'penalty goal'),
(207528, 15, 13, '--'),
(207851, 42, 43, '--'),
(208353, 26, 3, '--'),
(209979, 30, 88, '--'),
(209989, 46, 23, '--'),
(210192, 25, 27, 'own goal'),
(210205, 25, 22, '--'),
(210439, 16, 57, '--'),
(210704, 44, 2, '--'),
(211352, 22, 38, '--'),
(211976, 43, 34, '--'),
(212306, 5, 82, '--'),
(213001, 12, 84, '--'),
(213001, 12, 89, '--'),
(213369, 31, 8, '--'),
(214007, 7, 28, '--'),
(214007, 7, 76, '--'),
(214012, 39, 29, '--'),
(214961, 19, 91, '--'),
(214961, 35, 85, '--'),
(214964, 39, 6, '--'),
(214964, 52, 23, '--'),
(216135, 34, 33, '--'),
(216135, 34, 66, '--'),
(216223, 32, 4, '--'),
(216226, 32, 84, '--'),
(216929, 38, 10, '--'),
(217315, 22, 23, '--'),
(217882, 58, 59, '--'),
(217882, 58, 69, '--'),
(218252, 7, 79, '--'),
(229397, 21, 88, '--'),
(229884, 15, 17, '--'),
(229884, 15, 48, 'penalty goal'),
(229884, 56, 28, 'penalty goal'),
(230756, 61, 119, '--'),
(233952, 27, 90, '--'),
(234927, 9, 83, '--'),
(235367, 42, 22, '--'),
(248373, 56, 41, '--');

-- --------------------------------------------------------

--
-- Tabellenstruktur für Tabelle `Verwarnungen`
--

CREATE TABLE IF NOT EXISTS `Verwarnungen` (
  `VID` int(11) NOT NULL,
  `Karte` varchar(20) DEFAULT NULL,
  `Minute` int(11) DEFAULT NULL,
  `SpielID` int(11) DEFAULT NULL,
  `SpielerNr` int(11) DEFAULT NULL,
  PRIMARY KEY (`VID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Daten für Tabelle `Verwarnungen`
--

INSERT INTO `Verwarnungen` (`VID`, `Karte`, `Minute`, `SpielID`, `SpielerNr`) VALUES
(148, 'yellow', 5, 10, 175511),
(149, 'yellow', 16, 10, 214944),
(150, 'yellow', 59, 10, 154901),
(151, 'yellow', 60, 10, 84703),
(152, 'yellow', 81, 10, 177823),
(153, 'yellow', 88, 10, 177891),
(154, 'yellow', 32, 11, 155696),
(155, 'yellow', 42, 11, 171149),
(156, 'yellow', 67, 11, 179049),
(157, 'yellow', 90, 11, 155712),
(158, 'yellow', 31, 12, 177760),
(159, 'yellow', 33, 12, 178324),
(160, 'yellow', 40, 12, 177778),
(161, 'yellow', 58, 12, 154061),
(162, 'yellow', 68, 12, 184367),
(163, 'yellow', 69, 12, 213001),
(164, 'yellow', 78, 12, 154050),
(165, 'yellow', 42, 13, 178789),
(166, 'yellow', 45, 13, 209790),
(167, 'yellow', 56, 13, 196667),
(168, 'yellow', 64, 13, 217974),
(169, 'yellow', 72, 13, 178790),
(170, 'yellow', 72, 13, 163331),
(171, 'yellow', 93, 13, 181292),
(172, 'yellow', 93, 13, 182647),
(173, 'yellow', 23, 14, 93299),
(174, 'yellow', 24, 14, 238679),
(175, 'yellow', 41, 14, 198556),
(176, 'yellow', 51, 14, 178469),
(178, 'yellow', 92, 14, 158074),
(179, 'yellow', 17, 15, 216223),
(180, 'yellow', 53, 15, 216224),
(181, 'yellow', 35, 16, 210564),
(182, 'yellow', 36, 16, 213370),
(183, 'yellow', 65, 16, 213371),
(184, 'yellow', 79, 16, 233781),
(185, 'yellow', 3, 17, 178969),
(186, 'yellow', 28, 17, 217260),
(187, 'yellow', 58, 17, 177667),
(188, 'yellow', 68, 17, 196757),
(189, 'yellow', 70, 17, 185434),
(191, 'yellow', 89, 17, 216129),
(192, 'yellow', 10, 18, 170171),
(193, 'yellow', 28, 18, 154793),
(194, 'yellow', 44, 18, 184545),
(195, 'yellow', 54, 18, 155010),
(196, 'yellow', 60, 18, 235273),
(197, 'yellow', 18, 19, 214131),
(198, 'yellow', 19, 19, 180653),
(199, 'yellow', 46, 19, 185669),
(200, 'yellow', 47, 19, 180648),
(201, 'yellow', 56, 19, 182759),
(202, 'yellow', 64, 19, 185385),
(203, 'yellow', 30, 1, 194152),
(204, 'yellow', 3, 20, 162763),
(205, 'yellow', 14, 20, 182648),
(206, 'yellow', 48, 20, 185507),
(207, 'yellow', 51, 20, 157138),
(208, 'yellow', 54, 20, 245617),
(209, 'yellow', 60, 20, 177703),
(210, 'yellow', 74, 20, 170674),
(211, 'yellow', 85, 20, 182624),
(212, 'yellow', 7, 21, 217015),
(213, 'yellow', 27, 21, 158775),
(214, 'yellow', 36, 21, 162680),
(215, 'yellow', 42, 21, 182757),
(216, 'yellow', 25, 22, 176971),
(217, 'yellow', 34, 22, 184616),
(218, 'yellow', 35, 22, 228281),
(219, 'yellow', 41, 22, 212306),
(220, 'yellow', 58, 22, 179568),
(221, 'yellow', 66, 22, 198489),
(222, 'yellow', 94, 22, 218246),
(223, 'yellow', 13, 23, 176992),
(224, 'yellow', 44, 23, 205056),
(225, 'yellow', 50, 23, 214617),
(226, 'yellow', 59, 23, 209955),
(228, 'yellow', 86, 23, 162685),
(229, 'yellow', 20, 24, 185641),
(230, 'yellow', 32, 24, 184086),
(231, 'yellow', 46, 24, 166375),
(232, 'yellow', 48, 24, 199026),
(233, 'yellow', 61, 24, 177657),
(234, 'yellow', 73, 24, 182901),
(235, 'yellow', 88, 24, 155851),
(236, 'yellow', 5, 25, 165247),
(237, 'yellow', 21, 25, 158473),
(239, 'yellow', 70, 25, 177655),
(240, 'yellow', 18, 26, 178264),
(241, 'yellow', 37, 26, 175524),
(242, 'yellow', 49, 26, 154901),
(243, 'yellow', 66, 26, 208353),
(244, 'yellow', 75, 26, 183008),
(245, 'yellow', 84, 26, 183000),
(246, 'yellow', 93, 26, 253359),
(247, 'yellow', 13, 27, 178306),
(248, 'yellow', 29, 27, 76824),
(249, 'yellow', 31, 27, 92699),
(250, 'yellow', 39, 27, 178303),
(251, 'yellow', 83, 27, 194815),
(252, 'yellow', 21, 28, 177760),
(253, 'yellow', 32, 28, 179049),
(254, 'yellow', 42, 28, 156047),
(255, 'yellow', 69, 28, 210704),
(256, 'yellow', 72, 28, 187349),
(257, 'yellow', 11, 29, 207763),
(258, 'yellow', 29, 29, 209900),
(259, 'yellow', 79, 29, 217974),
(260, 'yellow', 85, 29, 163331),
(261, 'yellow', 31, 2, 169238),
(262, 'yellow', 37, 2, 188516),
(263, 'yellow', 70, 2, 178842),
(264, 'yellow', 45, 30, 4309),
(265, 'yellow', 47, 30, 178594),
(266, 'yellow', 53, 30, 238679),
(267, 'yellow', 92, 30, 157838),
(268, 'yellow', 30, 31, 177914),
(269, 'yellow', 32, 31, 213375),
(270, 'yellow', 40, 31, 170770),
(271, 'yellow', 70, 31, 158268),
(272, 'yellow', 81, 31, 209148),
(273, 'yellow', 85, 31, 176953),
(274, 'yellow', 89, 31, 200179),
(275, 'yellow', 93, 31, 213369),
(276, 'yellow', 22, 32, 178945),
(277, 'yellow', 41, 32, 159257),
(278, 'yellow', 57, 32, 213483),
(279, 'yellow', 73, 32, 210441),
(280, 'yellow', 77, 32, 216226),
(281, 'yellow', 89, 32, 229846),
(282, 'yellow', 52, 33, 202544),
(283, 'yellow', 75, 33, 191193),
(284, 'yellow', 17, 34, 208120),
(285, 'yellow', 18, 34, 195105),
(286, 'yellow', 24, 34, 95557),
(287, 'yellow', 29, 34, 178967),
(288, 'yellow', 47, 34, 170171),
(289, 'yellow', 47, 34, 170167),
(290, 'yellow', 56, 34, 183788),
(291, 'yellow', 60, 34, 186048),
(292, 'yellow', 76, 34, 200738),
(293, 'yellow', 91, 34, 216129),
(294, 'yellow', 76, 35, 182050),
(295, 'yellow', 83, 35, 95673),
(296, 'yellow', 87, 35, 169551),
(297, 'yellow', 30, 36, 170674),
(298, 'yellow', 45, 36, 4332),
(299, 'yellow', 48, 36, 180653),
(300, 'yellow', 54, 36, 198282),
(301, 'yellow', 28, 37, 217313),
(302, 'yellow', 42, 37, 155673),
(303, 'yellow', 48, 37, 238003),
(304, 'yellow', 57, 37, 183574),
(305, 'yellow', 90, 37, 182372),
(306, 'yellow', 17, 38, 158775),
(307, 'yellow', 33, 38, 178964),
(308, 'yellow', 35, 38, 216916),
(309, 'yellow', 37, 38, 182667),
(310, 'yellow', 41, 38, 3347),
(311, 'yellow', 43, 38, 176984),
(313, 'yellow', 57, 38, 216917),
(315, 'yellow', 22, 39, 209960),
(316, 'yellow', 26, 39, 187204),
(317, 'yellow', 27, 39, 176549),
(319, 'yellow', 65, 39, 178119),
(320, 'yellow', 69, 39, 214964),
(321, 'yellow', 87, 39, 218252),
(322, 'yellow', 88, 39, 184454),
(323, 'yellow', 91, 39, 165260),
(324, 'yellow', 19, 3, 214961),
(325, 'yellow', 22, 3, 207707),
(326, 'yellow', 63, 3, 194176),
(327, 'yellow', 22, 40, 209201),
(328, 'yellow', 37, 40, 184086),
(329, 'yellow', 46, 40, 178780),
(330, 'yellow', 55, 40, 237949),
(331, 'yellow', 67, 40, 214617),
(332, 'yellow', 91, 40, 213109),
(333, 'yellow', 31, 41, 177845),
(334, 'yellow', 35, 41, 177897),
(336, 'yellow', 5, 42, 175524),
(337, 'yellow', 7, 42, 178101),
(338, 'yellow', 32, 42, 209161),
(339, 'yellow', 81, 42, 184560),
(340, 'yellow', 91, 42, 155382),
(341, 'yellow', 40, 43, 194226),
(342, 'yellow', 44, 43, 176534),
(343, 'yellow', 32, 44, 155707),
(344, 'yellow', 38, 44, 155712),
(345, 'yellow', 61, 44, 188511),
(346, 'yellow', 70, 44, 179048),
(347, 'yellow', 81, 44, 178306),
(351, 'yellow', 30, 45, 181293),
(352, 'yellow', 38, 45, 158045),
(353, 'yellow', 44, 45, 214456),
(354, 'yellow', 88, 45, 4309),
(355, 'yellow', 23, 46, 207761),
(356, 'yellow', 37, 46, 198547),
(357, 'yellow', 43, 46, 209989),
(358, 'yellow', 55, 46, 178791),
(359, 'yellow', 69, 46, 157840),
(360, 'yellow', 78, 46, 159323),
(361, 'yellow', 78, 46, 156216),
(362, 'yellow', 80, 46, 178469),
(363, 'yellow', 82, 46, 214476),
(364, 'yellow', 90, 46, 216645),
(365, 'yellow', 27, 47, 77503),
(366, 'yellow', 30, 47, 177917),
(367, 'yellow', 35, 47, 197690),
(368, 'yellow', 75, 47, 177846),
(369, 'yellow', 77, 47, 170787),
(370, 'yellow', 9, 48, 176953),
(371, 'yellow', 18, 48, 229846),
(372, 'yellow', 43, 48, 213370),
(374, 'yellow', 47, 48, 216233),
(375, 'yellow', 61, 48, 178953),
(376, 'yellow', 65, 48, 216223),
(377, 'yellow', 90, 48, 158268),
(378, 'yellow', 27, 49, 182207),
(379, 'yellow', 28, 49, 185507),
(381, 'yellow', 48, 49, 185506),
(382, 'yellow', 78, 49, 177703),
(383, 'yellow', 15, 4, 158221),
(385, 'yellow', 74, 4, 60183),
(386, 'yellow', 90, 4, 77995),
(387, 'yellow', 46, 50, 201964),
(388, 'yellow', 70, 50, 178119),
(389, 'yellow', 82, 50, 214015),
(390, 'yellow', 112, 50, 153977),
(391, 'yellow', 118, 50, 70097),
(392, 'yellow', 119, 50, 214012),
(393, 'yellow', 18, 51, 214962),
(394, 'yellow', 24, 51, 202544),
(395, 'yellow', 37, 51, 187434),
(396, 'yellow', 67, 51, 155010),
(397, 'yellow', 78, 51, 214963),
(398, 'yellow', 82, 51, 182787),
(399, 'yellow', 2, 52, 179568),
(400, 'yellow', 7, 52, 218246),
(401, 'yellow', 20, 52, 214964),
(402, 'yellow', 31, 52, 177657),
(404, 'yellow', 50, 52, 182197),
(405, 'yellow', 59, 52, 155679),
(406, 'yellow', 60, 52, 160130),
(408, 'yellow', 73, 52, 199026),
(409, 'yellow', 73, 52, 215002),
(410, 'yellow', 74, 52, 180811),
(411, 'yellow', 76, 52, 182194),
(412, 'yellow', 76, 52, 214967),
(415, 'yellow', 23, 53, 178324),
(416, 'yellow', 29, 53, 230756),
(417, 'yellow', 49, 53, 213001),
(418, 'yellow', 61, 53, 181474),
(419, 'yellow', 89, 53, 177845),
(420, 'yellow', 91, 53, 177655),
(421, 'yellow', 59, 54, 209979),
(422, 'yellow', 7, 55, 155382),
(423, 'yellow', 11, 55, 183000),
(424, 'yellow', 13, 55, 175683),
(425, 'yellow', 29, 55, 184557),
(426, 'yellow', 38, 55, 253358),
(427, 'yellow', 44, 55, 185324),
(428, 'yellow', 48, 55, 208353),
(430, 'yellow', 68, 56, 170707),
(431, 'yellow', 82, 56, 177914),
(432, 'yellow', 87, 56, 248373),
(433, 'yellow', 91, 56, 163331),
(434, 'yellow', 3, 57, 196789),
(435, 'yellow', 46, 57, 153977),
(436, 'yellow', 60, 57, 182372),
(437, 'yellow', 88, 57, 184291),
(438, 'yellow', 94, 57, 196757),
(439, 'yellow', 95, 57, 153954),
(440, 'yellow', 114, 57, 191178),
(441, 'yellow', 16, 58, 229846),
(442, 'yellow', 21, 58, 216226),
(443, 'yellow', 67, 58, 216753),
(444, 'yellow', 30, 59, 214962),
(445, 'yellow', 44, 59, 182197),
(446, 'yellow', 107, 59, 182050),
(447, 'yellow', 111, 59, 214957),
(448, 'yellow', 41, 5, 178837),
(449, 'yellow', 48, 5, 201964),
(450, 'yellow', 62, 5, 198051),
(451, 'yellow', 81, 5, 201965),
(452, 'yellow', 91, 5, 212306),
(453, 'yellow', 25, 60, 76824),
(454, 'yellow', 45, 60, 185324),
(455, 'yellow', 47, 60, 92699),
(456, 'yellow', 74, 60, 181292),
(457, 'yellow', 75, 60, 178520),
(458, 'yellow', 87, 60, 209791),
(459, 'yellow', 88, 60, 163666),
(460, 'yellow', 40, 61, 191193),
(461, 'yellow', 56, 61, 185434),
(462, 'yellow', 90, 61, 214022),
(463, 'yellow', 83, 62, 214957),
(464, 'yellow', 87, 62, 209791),
(465, 'yellow', 7, 63, 182207),
(466, 'yellow', 24, 63, 210212),
(467, 'yellow', 33, 63, 177657),
(468, 'yellow', 60, 63, 187197),
(469, 'yellow', 78, 63, 196752),
(470, 'yellow', 5, 64, 177655),
(471, 'yellow', 12, 64, 181292),
(472, 'yellow', 76, 64, 181293),
(473, 'yellow', 111, 64, 225204),
(474, 'yellow', 34, 6, 170750),
(475, 'yellow', 56, 6, 155679),
(476, 'yellow', 64, 6, 217015),
(477, 'yellow', 81, 6, 216921),
(478, 'yellow', 85, 6, 184607),
(479, 'yellow', 90, 6, 216917),
(480, 'yellow', 18, 7, 70097),
(481, 'yellow', 55, 7, 185641),
(482, 'yellow', 91, 7, 218253),
(483, 'yellow', 26, 8, 201200),
(484, 'yellow', 28, 8, 253600),
(485, 'yellow', 48, 8, 209201),
(486, 'yellow', 52, 8, 205056),
(487, 'yellow', 79, 8, 214967),
(488, 'yellow', 10, 9, 209119),
(489, 'yellow', 41, 9, 183000),
(490, 'yellow', 62, 9, 214022),
(491, 'yellow', 65, 9, 208353),
(492, 'yellow', 88, 9, 234927),
(493, 'yellow-red', 53, 14, 93299),
(494, 'red', 47, 15, 166297),
(495, 'yellow-red', 75, 17, 217260),
(496, 'red', 65, 21, 177709),
(497, 'yellow-red', 79, 23, 205056),
(498, 'red', 28, 25, 209119),
(499, 'red', 45, 25, 188293),
(500, 'yellow-red', 47, 25, 158473),
(501, 'red', 65, 26, 177894),
(502, 'yellow-red', 46, 38, 158775),
(503, 'yellow-red', 92, 38, 3347),
(504, 'yellow-red', 61, 39, 176549),
(505, 'yellow-red', 47, 41, 177897),
(506, 'yellow-red', 85, 44, 155707),
(507, 'yellow-red', 87, 44, 178306),
(508, 'yellow-red', 93, 44, 188511),
(509, 'yellow-red', 46, 48, 176953),
(510, 'yellow-red', 35, 49, 185507),
(511, 'yellow-red', 46, 4, 158221),
(512, 'yellow-red', 46, 52, 177657),
(513, 'yellow-red', 63, 52, 218246),
(514, 'yellow-red', 78, 52, 199026),
(515, 'yellow-red', 95, 52, 155679),
(516, 'red', 50, 53, 184451),
(517, 'yellow-red', 81, 55, 208353),
(518, 'red', 120, 57, 193984),
(519, 'red', 62, 59, 196842),
(520, 'red', 110, 64, 163331);