--v1.0.0
--d2018-06-25 10:17:00
--
--

TRUNCATE TABLE `{prefix}spieler`;

-- 1 Russland = ID 40
REPLACE INTO `{prefix}spieler` (`id`, `team`, `position`, `nummer`, `name`, `firstname`, `nickname`, `caps`, `goals`, `birthdate`, `club`, `clubcountry`) VALUES
(4001, 40, 'T', 1, 'Akinfeev', 'Igor', '', 105, 0, '1986-04-08', 'ZSKA Moskau', 'Russland'),
(4002, 40, 'T', 12, 'Lunev', 'Andrey', '', 3, 0, '1991-11-13', 'Zenit St. Petersburg', 'Russland'),
(4004, 40, 'T', 20, 'Gabulov', 'Vladimir', '', 10, 0, '1983-10-19', 'FC Brügge', 'Belgien'),
(4005, 40, 'V', 5, 'Semenov', 'Andrey', '', 6, 0, '1989-03-24', 'Akhmat Grozny', 'Russland'),
(4007, 40, 'V', 3, 'Kutepov', 'Ilya', '', 6, 0, '1993-07-29', 'Spartak Moskau', 'Russland'),
(4008, 40, 'V', 14, 'Granat', 'Vladimir', '', 12, 1, '1987-05-22', 'Rubin Kazan', 'Russland'),
(4009, 40, 'V', 4, 'Ignashevich', 'Sergey', '', 121, 8, '1979-07-14', 'ZSKA Moskau', 'Russland'),
(4010, 40, 'V', 13, 'Kudryashov', 'Fedor', '', 18, 0, '1987-04-05', 'Rubin Kazan', 'Russland'),
(4012, 40, 'V', 2, 'Fernandes', 'Mário', '', 4, 0, '1990-09-19', 'ZSKA Moskau', 'Russland'),
(4013, 40, 'V', 23, 'Smolnikov', 'Igor', '', 26, 0, '1988-08-08', 'Zenit St. Petersburg', 'Russland'),
(4014, 40, 'M', 9, 'Dzagoev', 'Alan', '', 56, 9, '1990-06-17', 'ZSKA Moskau', 'Russland'),
(4015, 40, 'M', 17, 'Golovin', 'Aleksandr', '', 18, 2, '1996-05-30', 'ZSKA Moskau', 'Russland'),
(4016, 40, 'M', 11, 'Zobnin', 'Roman', '', 11, 0, '1994-02-11', 'Spartak Moskau', 'Russland'),
(4017, 40, 'M', 7, 'Kuzyaev', 'Daler', '', 5, 0, '1993-01-15', 'Zenit St. Petersburg', 'Russland'),
(4018, 40, 'M', 8, 'Gazinskiy', 'Yuri', '', 5, 0, '1989-07-20', 'FK Krasnodar', 'Russland'),
(4019, 40, 'M', 16, 'Miranchuk', 'Anton', '', 5, 0, '1995-10-17', 'Lokomotiv Moskau', 'Russland'),
(4021, 40, 'M', 18, 'Zhirkov', 'Yuri', '', 83, 2, '1983-08-20', 'Zenit St. Petersburg', 'Russland'),
(4022, 40, 'M', 15, 'Miranchuk', 'Aleksey', '', 17, 4, '1995-10-17', 'Lokomotiv Moskau', 'Russland'),
(4023, 40, 'M', 21, 'Erokhin', 'Aleksandr', '', 17, 0, '1989-10-13', 'Zenit St. Petersburg', 'Russland'),
(4024, 40, 'A', 6, 'Cheryshev', 'Denis', '', 11, 0, '1990-12-26', 'FC Villareal', 'Spanien'),
(4025, 40, 'A', 19, 'Samedov', 'Aleksandr', '', 47, 6, '1984-07-19', 'Spartak Moskau', 'Russland'),
(4026, 40, 'A', 10, 'Smolov', 'Fedor', '', 31, 12, '1990-02-09', 'FK Krasnodar', 'Russland'),
(4027, 40, 'A', 22, 'Dzyuba', 'Artem', '', 23, 11, '1988-08-22', 'Arsenal Tula', 'Russland');

-- 2 Saudi-Arabien = ID 72
REPLACE INTO `{prefix}spieler` (`id`, `team`, `position`, `nummer`, `name`, `firstname`, `nickname`, `caps`, `goals`, `birthdate`, `club`, `clubcountry`) VALUES
(7200, 72, 'T', 1, 'Almuaiouf', 'Abdullah', '', 9, 0, '1987-01-23', 'Al Hilal SFC', 'Saudi-Arabien'),
(7201, 72, 'V', 2, 'Alharbi', 'Mansour', '', 37, 1, '1987-10-19', 'Al Ahli SC', 'Saudi-Arabien'),
(7202, 72, 'V', 3, 'Hawsawi', 'Osama', '', 133, 7, '1984-03-31', 'Al Hilal SFC', 'Saudi-Arabien'),
(7203, 72, 'V', 4, 'Albulayhi', 'Ali', '', 1, 0, '1989-11-21', 'Al Hilal SFC', 'Saudi-Arabien'),
(7204, 72, 'V', 5, 'Othman', 'Omar', '', 40, 3, '1985-09-27', 'Al Nassr FC', 'Saudi-Arabien'),
(7205, 72, 'V', 6, 'Alburayk', 'Mohammed', '', 9, 1, '1992-09-15', 'Al Hilal SFC', 'Saudi-Arabien'),
(7206, 72, 'M', 7, 'Alfaraj', 'Salman', '', 40, 3, '1989-08-01', 'Al Hilal SFC', 'Saudi-Arabien'),
(7207, 72, 'M', 8, 'Alshehri', 'Yahia', '', 55, 7, '1990-06-26', 'CD Leganés', 'Spanien'),
(7208, 72, 'M', 9, 'Bahbir', 'Hatan', '', 3, 0, '1992-07-16', 'Al Shabab FC', 'Saudi-Arabien'),
(7209, 72, 'A', 10, 'Alsahlawi', 'Mohammed', '', 38, 28, '1987-01-10', 'Al Nassr FC', 'Saudi-Arabien'),
(7210, 72, 'M', 11, 'Alkhaibri', 'Abdulmalek', '', 35, 0, '1986-03-13', 'Al Hilal SFC', 'Saudi-Arabien'),
(7211, 72, 'M', 12, 'Kanno', 'Mohamed', '', 5, 1, '1994-09-22', 'Al Hilal SFC', 'Saudi-Arabien'),
(7212, 72, 'V', 13, 'Alshahrani', 'Yasir', '', 34, 0, '1992-05-25', 'Al Hilal SFC', 'Saudi-Arabien'),
(7213, 72, 'M', 14, 'Otayf', 'Abdullah', '', 14, 1, '1992-08-03', 'Al Hilal SFC', 'Saudi-Arabien'),
(7214, 72, 'M', 15, 'Alkhaibari', 'Abdullah', '', 3, 0, '1996-08-16', 'Al Shabab FC', 'Saudi-Arabien'),
(7215, 72, 'M', 16, 'Almoqahwi', 'Hussain', '', 15, 1, '1988-03-24', 'Al Ahli SC', 'Saudi-Arabien'),
(7216, 72, 'M', 17, 'Aljassam', 'Taiseer', '', 129, 18, '1984-07-25', 'Al Ahli SC', 'Saudi-Arabien'),
(7217, 72, 'M', 18, 'Aldawsari', 'Salem', '', 30, 4, '1991-08-19', 'Villarreal CF', 'Spanien'),
(7218, 72, 'A', 19, 'Almuwallad', 'Fahad', '', 42, 10, '1994-09-14', 'Levante UD', 'Spanien'),
(7219, 72, 'A', 20, 'Asiri', 'Muhannad', '', 17, 4, '1986-10-14', 'Al Ahli SC', 'Saudi-Arabien'),
(7220, 72, 'T', 21, 'Almosailem', 'Yasser', '', 32, 0, '1984-02-27', 'Al Ahli SC', 'Saudi-Arabien'),
(7221, 72, 'T', 22, 'Alowais', 'Mohammed', '', 5, 0, '1991-10-10', 'Al Ahli SC', 'Saudi-Arabien'),
(7222, 72, 'V', 23, 'Hawsawi', 'Motaz', '', 15, 0, '1992-02-17', 'Al Ahli SC', 'Saudi-Arabien');

-- 3 Ägypten = ID 49
REPLACE INTO `{prefix}spieler` (`id`, `team`, `position`, `nummer`, `name`, `firstname`, `nickname`, `caps`, `goals`, `birthdate`, `club`, `clubcountry`) VALUES
(4900, 49, 'T', 23, 'El Shenawy', 'Mohamed', '', 2, 0, '1988-12-18', 'El Ahly Kairo', 'Ägypten'),
(4901, 49, 'T', 16, 'Ekramy', 'Sherif', '', 24, 0, '1983-07-10', 'El Ahly Kairo', 'Ägypten'),
(4902, 49, 'T', 1, 'El Hadary', 'Essam', '', 157, 0, '1973-01-15', 'Al-Taawon', 'Saudi-Arabien'),
(4903, 49, 'V', 6, 'Hegazy', 'Ahmed', '', 44, 1, '1991-01-25', 'West Bromwich Albion', 'England'),
(4904, 49, 'V', 2, 'Gabr', 'Ali', '', 22, 1, '1989-01-10', 'West Bromwich Albion', 'England'),
(4905, 49, 'V', 20, 'Samir', 'Saad', '', 11, 0, '1989-04-01', 'El Ahly Kairo', 'Ägypten'),
(4906, 49, 'V', 12, 'Ashraf', 'Ayman', '', 4, 1, '1991-04-09', 'El Ahly Kairo', 'Ägypten'),
(4907, 49, 'V', 15, 'Hamdi', 'Mahmoud', '', 1, 0, '1995-06-01', 'Zamalek SC', 'Ägypten'),
(4908, 49, 'V', 13, 'Abdel-Shafi', 'Mohamed', '', 50, 1, '1985-07-01', 'Al-Fateh', 'Saudi-Arabien'),
(4909, 49, 'V', 3, 'Elmohamady', 'Ahmed', '', 81, 2, '1987-09-09', 'Aston Villa', 'England'),
(4910, 49, 'V', 7, 'Fathi', 'Ahmed', '', 125, 3, '1984-11-10', 'El Ahly Kairo', 'Ägypten'),
(4911, 49, 'V', 4, 'Gaber', 'Omar', '', 21, 0, '1992-01-30', 'Los Angeles FC', 'USA'),
(4912, 49, 'M', 17, 'Elneny', 'Mohamed', '', 60, 5, '1992-07-11', 'FC Arsenal', 'England'),
(4913, 49, 'M', 8, 'Hamed', 'Tarek', '', 24, 0, '1988-10-24', 'Zamalek SC', 'Ägypten'),
(4914, 49, 'M', 5, 'Morsy', 'Sam', '', 4, 0, '1991-09-10', 'Wigan Athletic', 'England'),
(4915, 49, 'M', 19, 'Said', 'Abdallah', '', 36, 6, '1985-07-13', 'Kuopion Palloseura', 'Finnland'),
(4916, 49, 'A', 14, 'Sobhi', 'Ramadan', '', 25, 1, '1997-01-23', 'Stoke City', 'England'),
(4917, 49, 'A', 21, 'Ibrahim Hassan', 'Mahmoud Ahmed', 'Trezeguet', 25, 2, '1994-10-01', 'Kasimpasa', 'Türkei'),
(4918, 49, 'A', 22, 'Warda', 'Amr', '', 17, 0, '1993-09-17', 'Atromitos Athen', 'Griechenland'),
(4919, 49, 'A', 11, 'Soliman', 'Mahmoud Abdelmonem', 'Kahraba', 21, 3, '1994-04-13', 'Al-Ittihad Dschidda', 'Saudi-Arabien'),
(4920, 49, 'A', 10, 'Salah', 'Mohamed', '', 57, 33, '1992-06-15', 'FC Liverpool', 'England'),
(4921, 49, 'A', 18, 'Fadlallah', 'Mahmoud Abdelrazak', 'Shikabala', 32, 2, '1986-03-05', 'Al-Raed', 'Saudi-Arabien'),
(4922, 49, 'A', 9, 'Mohsen', 'Marwan', '', 22, 4, '1989-02-26', 'El Ahly Kairo', 'Ägypten');

-- 4 Uruguay = ID 16
REPLACE INTO `{prefix}spieler` (`id`, `team`, `position`, `nummer`, `name`, `firstname`, `nickname`, `caps`, `goals`, `birthdate`, `club`, `clubcountry`) VALUES
(1600, 16, 'T', 1, 'Muslera', 'Fernando', '', 96, 0, '1986-06-16', 'Galatasaray Istanbul', 'Türkei'),
(1601, 16, 'T', 12, 'Campaña', 'Martín', '', 1, 0, '1989-05-29', 'Club Atlético Independiente', 'Argentinien'),
(1602, 16, 'T', 23, 'Silva', 'Martín', '', 11, 0, '1983-03-25', 'Vasco da Gama Rio de Janeiro', 'Brasilien'),
(1603, 16, 'V', 2, 'Giménez', 'José', '', 41, 4, '1995-01-20', 'Atlético Madrid', 'Spanien'),
(1604, 16, 'V', 3, 'Godín', 'Diego', '', 115, 8, '1986-02-16', 'Atlético Madrid', 'Spanien'),
(1605, 16, 'V', 19, 'Coates', 'Sebastián', '', 30, 1, '1990-10-07', 'Sporting Lissabon', 'Portugal'),
(1606, 16, 'V', 13, 'Silva', 'Gastón', '', 17, 0, '1994-03-05', 'Club Atlético Independiente', 'Argentinien'),
(1607, 16, 'V', 22, 'Cáceres', 'Martín', '', 75, 4, '1987-04-07', 'Lazio Rom', 'Italien'),
(1608, 16, 'V', 4, 'Varela', 'Guillermo', '', 3, 0, '1993-03-24', 'CA Peñarol', 'Uruguay'),
(1609, 16, 'V', 16, 'Pereira', 'Maxi', '', 124, 3, '1984-06-08', 'FC Porto', 'Portugal'),
(1610, 16, 'M', 14, 'Torreira', 'Lucas', '', 2, 0, '1996-02-11', 'Sampdoria Genua', 'Italien'),
(1611, 16, 'M', 15, 'Vecino', 'Matías', '', 21, 1, '1991-08-24', 'Inter Mailand', 'Italien'),
(1612, 16, 'M', 6, 'Bentancur', 'Rodrigo', '', 6, 0, '1997-06-25', 'Juventus Turin', 'Italien'),
(1614, 16, 'M', 8, 'Nández', 'Nahitan', '', 11, 0, '1995-12-28', 'Club Atlético Boca Juniors', 'Argentinien'),
(1615, 16, 'M', 5, 'Sánchez', 'Carlos', '', 34, 1, '1984-12-02', 'CF Monterrey', 'Mexiko'),
(1616, 16, 'M', 17, 'Laxalt', 'Diego', '', 5, 0, '1993-02-07', 'FC Genua 1893', 'Italien'),
(1617, 16, 'M', 7, 'Rodríguez', 'Cristian', '', 104, 11, '1985-09-30', 'CA Peñarol', 'Uruguay'),
(1619, 16, 'M', 10, 'de Arrascaeta', 'Giorgian', '', 13, 1, '1994-06-01', 'EC Cruzeiro Belo Horizonte', 'Brasilien'),
(1621, 16, 'A', 20, 'Urretaviscaya', 'Jonathan', 'Urreta', 4, 0, '1990-03-19', 'CF Monterrey', 'Mexiko'),
(1622, 16, 'A', 9, 'Suárez', 'Luis', '', 97, 50, '1987-01-24', 'FC Barcelona', 'Spanien'),
(1623, 16, 'A', 21, 'Cavani', 'Edinson', '', 100, 42, '1987-02-14', 'Paris St. Germain', 'Frankreich'),
(1624, 16, 'A', 18, 'Gómez', 'Maximiliano', '', 4, 0, '1996-08-14', 'Celta Vigo', 'Spanien'),
(1625, 16, 'A', 11, 'Stuani', 'Cristhian', '', 40, 5, '1986-10-12', 'FC Girona', 'Spanien');

-- 5 Portugal = ID 14
REPLACE INTO `{prefix}spieler` (`id`, `team`, `position`, `nummer`, `name`, `firstname`, `nickname`, `caps`, `goals`, `birthdate`, `club`, `clubcountry`) VALUES
(1400, 14, 'T', 12, 'Lopes', 'Anthony', '', 7, 0, '1990-10-01', 'Olympique Lyon', 'Frankreich'),
(1401, 14, 'T', 1, 'Patrício', 'Rui', '', 68, 0, '1988-02-15', 'Sporting Lissabon', 'Portugal'),
(1402, 14, 'T', 22, '', '', 'Beto', 13, 0, '1982-05-01', 'Göztepe', 'Türkei'),
(1403, 14, 'V', 13, 'Dias', 'Rúben', '', 1, 0, '1997-05-14', 'Benfica Lissabon', 'Portugal'),
(1404, 14, 'V', 6, 'Fonte', 'José', '', 29, 0, '1983-12-22', 'Dalian Yifang', 'China'),
(1405, 14, 'V', 3, '', '', 'Pepe', 93, 5, '1983-02-26', 'Bestiktas Istanbus', 'Türkei'),
(1406, 14, 'V', 2, 'Alves', 'Bruno', '', 95, 11, '1981-11-27', 'Glasgow Rangers', 'Schottland'),
(1407, 14, 'V', 5, 'Guerreiro', 'Raphaël', '', 22, 2, '1993-12-22', 'Borussia Dortmund', 'Deutschland'),
(1408, 14, 'V', 19, 'Rui', 'Mário', '', 2, 0, '1991-05-27', 'SSC Neapel', 'Italien'),
(1409, 14, 'V', 21, 'Soares', 'Cédric', '', 27, 1, '1991-08-31', 'FC Southhampton', 'England'),
(1410, 14, 'V', 15, 'Pereira', 'Ricardo', '', 4, 0, '1993-10-06', 'FC Porto', 'Portugal'),
(1411, 14, 'M', 14, 'Carvalho', 'William', '', 41, 2, '1992-04-07', 'Sporting Lissabon', 'Portugal'),
(1412, 14, 'M', 23, 'Silva', 'Adrien', '', 22, 1, '1989-03-15', 'Leicester City', 'England'),
(1413, 14, 'M', 8, 'Moutinho', 'João', '', 108, 7, '1986-09-08', 'AS Monaco', 'Frankreich'),
(1414, 14, 'M', 4, 'Fernandes', 'Manuel', '', 13, 3, '1986-02-05', 'Lokomotiv Moskau', 'Russland'),
(1415, 14, 'M', 10, 'Mário', 'João', '', 34, 2, '1993-01-19', 'West Ham United', 'England'),
(1416, 14, 'M', 16, 'Fernandes', 'Bruno', '', 4, 0, '1994-09-08', 'Sporting Lissabon', 'Portugal'),
(1417, 14, 'A', 17, 'Guedes', 'Gonçalo', '', 8, 1, '1996-11-29', 'FC Valencia', 'Spanien'),
(1418, 14, 'A', 11, 'Silva', 'Bernardo', '', 23, 2, '1994-08-10', 'Manchester City', 'England'),
(1419, 14, 'A', 18, 'Martins', 'Gelson', '', 17, 0, '1995-05-11', 'Sporting Lissabon', 'Portugal'),
(1420, 14, 'A', 20, 'Quaresma', 'Ricardo', '', 75, 9, '1983-09-26', 'Bestiktas Istanbus', 'Türkei'),
(1421, 14, 'A', 7, 'Ronaldo', 'Cristiano', '', 149, 81, '1985-02-05', 'Real Madrid', 'Spanien'),
(1422, 14, 'A', 9, 'Silva', 'André', '', 21, 12, '1995-11-06', 'AC Mailand', 'Italien');

-- 6 Spanien = ID 4
REPLACE INTO `{prefix}spieler` (`id`, `team`, `position`, `nummer`, `name`, `firstname`, `nickname`, `caps`, `goals`, `birthdate`, `club`, `clubcountry`) VALUES
(400, 4, 'T', 1, 'de Gea', 'David', '', 27, 0, '1990-11-07', 'Manchester United', 'England') ,
(401, 4, 'T', 13, 'Arrizabalaga', 'Kepa', '', 1, 0, '1994-10-03', 'Athletic Bilbao', 'Spanien') ,
(402, 4, 'T', 23, 'Reina', 'Pepe', '', 38, 0, '1982-08-31', 'SSC Neapel', 'Italien') ,
(403, 4, 'V', 3, 'Piqué', 'Gerard', '', 96, 5, '1987-02-02', 'FC Barcelona', 'Spanien') ,
(404, 4, 'V', 15, 'Ramos', 'Sergio', '', 155, 13, '1986-03-30', 'Real Madrid', 'Spanien') ,
(405, 4, 'V', 14, 'Azpilicueta', 'César', '', 21, 0, '1989-08-28', 'FC Chelsea', 'England') ,
(406, 4, 'V', 4, 'Fernández', 'Nacho', '', 15, 0, '1990-01-18', 'Real Madrid', 'Spanien') ,
(407, 4, 'V', 18, 'Alba', 'Jordi', '', 60, 8, '1989-03-21', 'FC Barcelona', 'Spanien') ,
(408, 4, 'V', 16, 'Monreal', 'Nacho', '', 21, 1, '1986-02-26', 'FC Arsenal', 'England') ,
(409, 4, 'V', 2, 'Carvajal', 'Daniel', '', 15, 0, '1992-01-11', 'Real Madrid', 'Spanien') ,
(410, 4, 'V', 12, 'Odriozola', 'Álvaro', '', 2, 0, '1995-12-14', 'Real Sociedad San Sebastián', 'Spanien') ,
(411, 4, 'M', 5, 'Busquets', 'Sergio', '', 102, 2, '1988-07-16', 'FC Barcelona', 'Spanien') ,
(412, 4, 'M', 7, 'Ñíguez', 'Saúl', '', 9, 0, '1994-11-21', 'Atlético Madrid', 'Spanien') ,
(413, 4, 'M', 8, '', '', 'Koke', 38, 0, '1992-01-08', 'Atlético Madrid', 'Spanien') ,
(414, 4, 'M', 10, '', '', 'Thiago', 27, 2, '1991-04-11', 'FC Bayern München', 'Deutschland') ,
(415, 4, 'M', 6, 'Iniesta', 'Andrés', '', 129, 13, '1984-05-11', 'FC Barcelona', 'Spanien') ,
(416, 4, 'M', 22, '', '', 'Isco', 27, 10, '1992-04-21', 'Real Madrid', 'Spanien') ,
(417, 4, 'M', 21, 'Silva', 'David', '', 122, 35, '1986-01-08', 'Manchester City', 'England') ,
(418, 4, 'A', 20, 'Asensio', 'Marco', '', 10, 0, '1996-01-21', 'Real Madrid', 'Spanien') ,
(419, 4, 'A', 11, 'Vázquez', 'Lucas', '', 5, 0, '1991-07-01', 'Real Madrid', 'Spanien') ,
(420, 4, 'A', 17, 'Aspas', 'Iago', '', 8, 4, '1987-08-01', 'Celta Vigo', 'Spanien') ,
(421, 4, 'A', 19, 'Costa', 'Diego', '', 18, 7, '1988-10-07', 'Atlético Madrid', 'Spanien') ,
(422, 4, 'A', 9, '', '', 'Rodrigo', 4, 2, '1991-03-06', 'FC Valencia', 'Spanien');

-- 7 Marokko = ID 61
REPLACE INTO `{prefix}spieler` (`id`, `team`, `position`, `nummer`, `name`, `firstname`, `nickname`, `caps`, `goals`, `birthdate`, `club`, `clubcountry`) VALUES
(6100, 61, 'T', 1, 'Bounou', 'Yassine', 'Bono', 10, 0, '1991-04-05', 'FC Girona', 'Spanien'),
(6101, 61, 'T', 22, 'Tagnaouti', 'Ahmed Reda', '', 1, 0, '1996-04-05', 'Ittihad Tanger', 'Marokko'),
(6102, 61, 'T', 12, 'Mohamed', 'Munir Mohand', 'Munir', 24, 0, '1989-05-10', 'CD Numancia', 'Spanien'),
(6103, 61, 'V', 5, 'Benatia', 'Medhi', '', 54, 2, '1987-04-17', 'Juventus Turin', 'Italien'),
(6104, 61, 'V', 4, 'da Costa', 'Manuel', '', 24, 0, '1986-05-06', 'Basaksehir', 'Türkei'),
(6105, 61, 'V', 3, 'Mendyl', 'Hamza', '', 11, 0, '1997-10-21', 'LOSC Lille', 'Frankreich'),
(6106, 61, 'V', 2, 'Hakimi', 'Achraf', '', 6, 1, '1998-11-04', 'Real Madrid', 'Spanien'),
(6107, 61, 'M', 6, 'Saïss', 'Romain', '', 20, 1, '1990-03-26', 'Wolverhampton Wanderers', 'England'),
(6108, 61, 'M', 15, 'Aït Bennasser', 'Youssef', '', 11, 0, '1996-07-07', 'SM Caen', 'Frankreich'),
(6109, 61, 'M', 21, 'Amrabat', 'Sofyan', '', 2, 0, '1996-08-21', 'Feyenoord Rotterdam', 'Niederlande'),
(6110, 61, 'M', 8, 'El Ahmadi', 'Karim', '', 48, 1, '1985-01-27', 'Feyenoord Rotterdam', 'Niederlande'),
(6111, 61, 'M', 17, 'Dirar', 'Nabil', '', 34, 3, '1986-02-25', 'Fenerbahce Istanbul', 'Türkei'),
(6112, 61, 'M', 18, 'Harit', 'Amine', '', 2, 0, '1997-06-18', 'FC Schalke 04', 'Deutschland'),
(6113, 61, 'M', 7, 'Ziyech', 'Hakim', '', 15, 8, '1993-03-19', 'Ajax Amsterdam', 'Niederlande'),
(6114, 61, 'M', 10, 'Belhanda', 'Younès', '', 44, 3, '1990-02-25', 'Galatasaray Istanbu', 'Türkei'),
(6115, 61, 'M', 11, 'Fajr', 'Fayçal', '', 20, 2, '1988-08-01', 'FC Getafe', 'Spanien'),
(6116, 61, 'M', 14, 'Boussoufa', 'Moubarak', '', 56, 7, '1984-08-15', 'Al-Jazira', 'Vereinigte Arabische Emirate'),
(6117, 61, 'A', 23, 'Carcela-González', 'Mehdi', '', 19, 1, '1989-07-01', 'Standard Lüttich', 'Belgien'),
(6118, 61, 'A', 16, 'Amrabat', 'Nordin', '', 41, 4, '1987-03-31', 'CD Leganés', 'Spanien'),
(6119, 61, 'A', 19, 'En-Nesyri', 'Youssef', '', 15, 1, '1997-06-01', 'FC Málaga', 'Spanien'),
(6120, 61, 'A', 13, 'Boutaïb', 'Khalid', '', 15, 7, '1987-04-24', 'Yeni Malatyaspor', 'Türkei'),
(6121, 61, 'A', 9, 'El Kaabi', 'Ayoub', '', 8, 10, '1993-06-26', 'Renaissance de Berkane', 'Marokko'),
(6122, 61, 'A', 20, 'Bouhaddouz', 'Aziz', '', 14, 3, '1987-03-30', 'FC St. Pauli', 'Deutschland');

-- 8 Iran = ID 37
REPLACE INTO `{prefix}spieler` (`id`, `team`, `position`, `nummer`, `name`, `firstname`, `nickname`, `caps`, `goals`, `birthdate`, `club`, `clubcountry`) VALUES
(3700, 37, 'T', 1, 'Beiranvand', 'Ali', '', 20, 0, '1992-09-21', 'Persepolis FC', 'Iran'),
(3701, 37, 'A', 2, 'Torabi', 'Mehdi', '', 15, 4, '1994-09-10', 'Saipa Alborz FC', 'Iran'),
(3702, 37, 'V', 3, 'Haji', 'Safi Ehsan', '', 93, 6, '1990-02-25', 'Olympiacos Piraeus FC', 'Griechenland'),
(3703, 37, 'M', 4, 'Cheshmi', 'Roozbeh', '', 8, 1, '1993-07-24', 'Esteghlal Tehran FC', 'Iran'),
(3704, 37, 'V', 5, 'Mohammadi', 'Milad', '', 17, 0, '1993-09-29', 'FC Akhmat Grozny', 'Russland'),
(3705, 37, 'M', 6, 'Ezatolahi', 'Saeid', '', 25, 1, '1996-10-01', 'FK Amkar Perm', 'Russland'),
(3706, 37, 'M', 7, 'Shojaei', 'Masoud', '', 72, 8, '1984-06-09', 'AEK Athens', 'Griechenland'),
(3707, 37, 'V', 8, 'Pouraliganji', 'Morteza', '', 25, 2, '1992-04-19', 'Al Sadd SC', 'Katar'),
(3708, 37, 'M', 9, 'Ebrahimi', 'Omid', '', 28, 0, '1987-09-16', 'Esteghlal Tehran FC', 'Iran'),
(3709, 37, 'A', 10, 'Ansarifard', 'Karim', '', 62, 16, '1990-04-03', 'Olympiacos Piraeus FC', 'Griechenland'),
(3710, 37, 'A', 11, 'Amiri', 'Vahid', '', 34, 1, '1988-04-02', 'Persepolis FC', 'Iran'),
(3711, 37, 'V', 12, 'Mazaheri', 'Rashid', '', 3, 0, '1989-05-18', 'Zob Ahan Isfahan FC', 'Iran'),
(3712, 37, 'V', 13, 'Khanzadeh', 'Mohammad Reza', '', 11, 1, '1991-05-11', 'Padideh FC', 'Iran'),
(3713, 37, 'A', 14, 'Ghoddos', 'Saman', '', 7, 1, '1993-09-06', 'IFK Östersund FK', 'Schweden'),
(3714, 37, 'V', 15, 'Montazeri', 'Pejman', '', 46, 1, '1983-09-06', 'Esteghlal Tehran FC', 'Iran'),
(3715, 37, 'A', 16, 'Ghoochannejhad', 'Reza', '', 40, 17, '1987-09-20', 'SC Heerenveen', 'Niederlande'),
(3716, 37, 'A', 17, 'Taremi', 'Mehdi', '', 24, 11, '1992-07-18', 'Al Gharafa SC', 'Katar'),
(3717, 37, 'A', 18, 'Jahanbakhsh', 'Alireza', '', 36, 4, '1993-08-11', 'AZ Alkmaar', 'Niederlande'),
(3718, 37, 'V', 19, 'Hosseini', 'Majid', '', 1, 0, '1996-06-20', 'Esteghlal Tehran FC', 'Iran'),
(3719, 37, 'A', 20, 'Azmoun', 'Sardar', '', 32, 23, '1995-01-01', 'FC Rubin Kazan', 'Russland'),
(3720, 37, 'A', 21, 'Dejagah', 'Ashkan', '', 44, 8, '1986-07-05', 'Nottingham Forest FC', 'England'),
(3721, 37, 'T', 22, 'Abedzadeh', 'Amir', '', 1, 0, '1993-04-26', 'CS Maritimo', 'Portugal'),
(3722, 37, 'V', 23, 'Rezaeian', 'Ramin', '', 26, 2, '1990-03-21', 'KV Oostende', 'Belgien');

-- 9 Frankreich = ID 15
REPLACE INTO `{prefix}spieler` (`id`, `team`, `position`, `nummer`, `name`, `firstname`, `nickname`, `caps`, `goals`, `birthdate`, `club`, `clubcountry`) VALUES
(1500, 15, 'T', 23, 'Areola', 'Alphonse', '', 0, 0, '1993-02-27', 'Paris St. Germain', 'Frankreich'),
(1501, 15, 'T', 1, 'Lloris', 'Hugo', '', 97, 0, '1986-12-26', 'Tottenham Hotspur', 'England'),
(1502, 15, 'T', 16, 'Mandanda', 'Steve', '', 27, 0, '1985-03-28', 'Olympique Marseille', 'Frankreich'),
(1503, 15, 'V', 3, 'Kimpembe', 'Presnel', '', 2, 0, '1995-08-13', 'Paris St. Germain', 'Frankreich'),
(1504, 15, 'V', 21, 'Bernard Hernandez', 'Lucas Francois', '', 4, 0, '1996-02-14', 'Atletico Madrid', 'Spanien'),
(1505, 15, 'V', 22, 'Mendy', 'Benjamin', '', 6, 0, '1994-07-17', '     Manchester City', 'England'),
(1506, 15, 'V', 2, 'Pavard', 'Benjamin', '', 5, 0, '1996-03-28', 'VfB Stuttgart', 'Deutschland'),
(1507, 15, 'V', 17, 'Rami', 'Adil', '', 35, 1, '1985-12-27', 'Olympique Marseille', 'Frankreich'),
(1508, 15, 'V', 19, 'Sidibé', 'Djibril', '', 16, 1, '1992-07-29', 'AS Monaco', 'Frankreich'),
(1509, 15, 'V', 5, 'Umtiti', 'Samuel', '', 18, 1, '1993-11-14', 'FC Barcelona', 'Spanien'),
(1510, 15, 'V', 4, 'Varane', 'Raphael', '', 41, 2, '1993-04-25', 'Real Madrid', 'Spanien'),
(1511, 15, 'M', 18, 'Fekir', 'Nabil', '', 11, 2, '1993-07-18', 'Olympique Lyon', 'Frankreich'),
(1512, 15, 'M', 13, 'Kanté', 'N\'golo', '', 23, 1, '1991-03-29', 'FC Chelsea', 'England'),
(1513, 15, 'M', 8, 'Lemar', 'Thomas', '', 11, 3, '1995-11-12', 'AS Monaco', 'Frankreich'),
(1514, 15, 'M', 14, 'Matuidi', 'Blaise', '', 66, 1, '1987-04-29', 'Juventus Turin', 'Italien'),
(1515, 15, 'M', 15, 'N\'Zonzi', 'Steven', '', 4, 0, '1988-12-15', 'FC Sevilla', 'Spanien'),
(1516, 15, 'M', 6, 'Pogba', 'Paul', '', 52, 9, '1993-05-15', 'Manchester United', 'England'),
(1517, 15, 'M', 20, 'Thauvin', 'Florian', '', 4, 0, '1993-01-26', 'Olympique Marseille', 'Frankreich'),
(1518, 15, 'M', 12, 'Tolisso', 'Corentin', '', 8, 0, '1994-08-03', 'FC Bayern München', 'Deutschland'),
(1519, 15, 'A', 11, 'Dembelé', 'Ousmane', '', 11, 1, '1997-05-15', 'FC Barcelona', 'Spanien'),
(1520, 15, 'A', 9, 'Giroud', 'Olivier', '', 73, 31, '1986-09-30', 'FC Chelsea', 'England'),
(1521, 15, 'A', 7, 'Griezmann', 'Antoine', '', 53, 19, '1991-03-21', 'Atletico Madrid', 'Spanien'),
(1522, 15, 'A', 10, 'Mbappé', 'Kylian', '', 14, 3, '1989-12-20', 'Paris St. Germain', 'Frankreich');

-- 10 Australien = ID 18
REPLACE INTO `{prefix}spieler` (`id`, `team`, `position`, `nummer`, `name`, `firstname`, `nickname`, `caps`, `goals`, `birthdate`, `club`, `clubcountry`) VALUES
(1800, 18, 'T', 1, 'Ryan', 'Mathew', '', 43, 0, '1992-04-08', 'Brighton & Hove Albion', 'England'),
(1801, 18, 'T', 12, 'Jones', 'Bradley', '', 5, 0, '1982-03-19', 'Feyenoord', 'Niederlande'),
(1802, 18, 'T', 18, 'Vuković', 'Daniel', '', 1, 0, '1985-03-27', 'KRC Genk', 'Belgien'),
(1803, 18, 'V', 16, 'Behich', 'Aziz', '', 22, 2, '1990-12-16', 'Bursaspor', 'Türkei'),
(1804, 18, 'V', 2, 'Degenek', 'Miloš', '', 18, 0, '1994-04-28', 'Yokohama F. Marinos', 'Japan'),
(1805, 18, 'V', 6, 'Jurman', 'Matthew', '', 4, 0, '1989-12-08', 'Suwon Bluewings', 'Südkorea '),
(1806, 18, 'A', 14, 'Maclaren', 'Jamie', '', 6, 0, '1993-07-29', 'Hibernian FC', 'Schottland'),
(1807, 18, 'V', 3, 'Meredith', 'James', '', 2, 0, '1995-09-03', 'Millwall FC', 'England'),
(1808, 18, 'V', 5, 'Milligan', 'Mark', '', 69, 6, '1985-08-04', 'Al Ahli SFC', 'Saudi-Arabien '),
(1809, 18, 'V', 19, 'Risdon', 'Joshua', '', 7, 0, '1992-07-27', 'Western Sydney Wanderers', 'Australien'),
(1810, 18, 'V', 20, 'Sainsbury', 'Trent Lucas', '', 34, 3, '1990-05-18', 'Grasshopper Club Zürich', 'Schweiz'),
(1811, 18, 'A', 21, 'Petratos', 'Dimitrios', '', 2, 0, '1992-11-10', 'Newcastle United Jets', 'Australien'),
(1812, 18, 'M', 4, 'Cahill', 'Tim', '', 106, 51, '1979-12-06', 'Millwall FC', 'England'),
(1813, 18, 'M', 22, 'Irvine', 'Jackson', '', 18, 2, '1993-03-07', 'Hull City', 'England'),
(1814, 18, 'M', 15, 'Jedinak', 'Michael John', '', 75, 13, '1984-08-03', 'Aston Villa', 'England'),
(1815, 18, 'M', 10, 'Kruse', 'Robbie', '', 63, 5, '1988-10-05', 'VfL Bochum', 'Deutschland'),
(1816, 18, 'M', 7, 'Leckie', 'Mathew Allan', '', 52, 8, '1991-02-04', 'Hertha BSC', 'Deutschland'),
(1817, 18, 'M', 8, 'Luongo', 'Massimo', '', 6, 2, '1992-09-25', 'Queens Park Rangers', 'England'),
(1818, 18, 'M', 13, 'Mooy', 'Aaron', '', 33, 5, '1989-09-15', 'Huddersfield Town', 'England'),
(1819, 18, 'M', 11, 'Nabbout', 'Andrew', '', 3, 1, '1992-12-17', 'Urawa Red Diamonds', 'Japan'),
(1820, 18, 'M', 23, 'Rogić', 'Tomas Petar', '', 36, 7, '1992-12-16', 'Celtic FC', 'Schottland'),
(1822, 18, 'A', 17, 'Arzani', 'Daniel', '', 1, 0, '1999-01-04', 'Melbourne City FC', 'Australien'),
(1823, 18, 'A', 9, 'Jurić', 'Tomi', '', 34, 8, '1991-07-22', 'FC Luzern', 'Schweiz');

-- 11 Peru = ID 45
REPLACE INTO `{prefix}spieler` (`id`, `team`, `position`, `nummer`, `name`, `firstname`, `nickname`, `caps`, `goals`, `birthdate`, `club`, `clubcountry`) VALUES
(4500, 45, 'T', 1, 'Gallese', 'Pedro', '', 37, 0, '1990-04-23', 'Tiburones Rojos de Veracruz', 'Mexiko'),
(4501, 45, 'T', 12, 'Cáceda', 'Carlos', '', 6, 0, '1991-09-27', 'Deportivo Municipal', 'Peru'),
(4502, 45, 'T', 21, 'Carvallo', 'José', '', 5, 0, '1986-03-01', 'Club UTC', 'Peru'),
(4503, 45, 'V', 15, 'Ramos', 'Christian', '', 67, 3, '1988-11-04', 'Tiburones Rojos', 'Mexiko'),
(4504, 45, 'V', 4, 'Santamaría', 'Anderson', '', 4, 0, '1992-01-10', 'Puebla FC', 'Mexiko'),
(4505, 45, 'V', 5, 'Araujo', 'Miguel', '', 7, 0, '1994-10-24', 'Alianza Lima', 'Peru'),
(4506, 45, 'V', 2, 'Rodríguez', 'Alberto', '', 73, 0, '1984-03-31', 'Junior FC', 'Kolumbien'),
(4507, 45, 'V', 6, 'Trauco', 'Miguel', '', 24, 0, '1992-07-03', 'Flamengo Rio de Janeiro', 'Brasilien'),
(4508, 45, 'V', 22, 'Loyola', 'Nilson', '', 3, 0, '1994-10-26', 'FBC Melgar', 'Peru'),
(4509, 45, 'V', 17, 'Advíncula', 'Luis', '', 64, 0, '1990-03-02', 'Lobos BUAP', 'Mexiko'),
(4510, 45, 'V', 3, 'Corzo', 'Aldo', '', 24, 0, '1989-05-20', 'Universitario de Deportes', 'Peru'),
(4511, 45, 'M', 23, 'Aquino', 'Pedro', '', 11, 0, '1995-04-13', 'Lobos BUAP', 'Mexiko'),
(4512, 45, 'M', 16, 'Cartagena', 'Wilder', '', 2, 0, '1994-09-23', 'Tiburones Rojos de Veracruz', 'Mexiko'),
(4513, 45, 'M', 13, 'Tapia', 'Renato', '', 29, 3, '1995-07-28', 'Feyenoord Rotterdam', 'Niederlande'),
(4514, 45, 'M', 19, 'Yotún', 'Yoshimar', '', 70, 2, '1990-04-07', 'Orlando City SC', 'USA'),
(4515, 45, 'M', 7, 'Hurtado', 'Paolo', '', 31, 3, '1990-07-27', 'Vitória Guimarães SC', 'Portugal'),
(4516, 45, 'M', 8, 'Cueva', 'Christian', '', 43, 7, '1991-11-23', 'FC São Paulo', 'Brasilien'),
(4518, 45, 'A', 20, 'Flores', 'Édison', '', 27, 9, '1994-05-14', 'Aalborg BK', 'Dänemark'),
(4519, 45, 'A', 18, 'Carrillo', 'André', '', 44, 4, '1991-06-14', 'FC Watford', 'England'),
(4520, 45, 'A', 10, 'Farfán', 'Jefferson', '', 81, 24, '1984-10-26', 'Lokomotiv Moskau', 'Russland'),
(4521, 45, 'A', 14, 'Polo', 'Andy', '', 15, 1, '1994-09-29', 'Portland Timbers', 'USA'),
(4522, 45, 'A', 11, 'Ruidíaz', 'Raúl', '', 29, 4, '1990-07-25', 'Monarcas Morelia', 'Mexiko'),
(4523, 45, 'A', 9, 'Guerrero', 'Paolo', '', 87, 33, '1984-01-01', 'Flamengo Rio de Janeiro', 'Brasilien');

-- 12 Dänemark = ID 29
REPLACE INTO `{prefix}spieler` (`id`, `team`, `position`, `nummer`, `name`, `firstname`, `nickname`, `caps`, `goals`, `birthdate`, `club`, `clubcountry`) VALUES
(2900, 29, 'T', 1, 'Schmeichel', 'Kasper', '', 34, 0, '1986-11-05', 'Leicester City', 'England'),
(2901, 29, 'T', 16, 'Lössl', 'Jonas', '', 1, 0, '1989-02-01', 'Huddersfield Town', 'England'),
(2902, 29, 'T', 22, 'Rönnow', 'Frederik', '', 7, 0, '1992-08-04', 'Bröndby IF', 'Dänemark'),
(2903, 29, 'V', 6, 'Christensen', 'Andreas', '', 15, 1, '1996-04-10', 'FC Chelsea', 'England'),
(2904, 29, 'V', 3, 'Vestergaard', 'Jannik', '', 16, 1, '1992-08-03', 'Borussia Mönchengladbach', 'Deutschland'),
(2905, 29, 'V', 4, 'Kjær', 'Simon', '', 77, 3, '1989-03-26', 'FC Sevilla', 'Spanien'),
(2906, 29, 'V', 13, 'Jorgensen', 'Mathias', '', 12, 0, '1990-04-23', 'Huddersfield Town', 'England'),
(2907, 29, 'V', 5, 'Knudsen', 'Jonas', '', 3, 0, '1992-09-16', 'Ipswich Town', 'England'),
(2908, 29, 'V', 14, 'Dalsgaard', 'Henrik', '', 10, 0, '1989-07-27', 'FC Brentford', 'England'),
(2909, 29, 'V', 17, 'Stryger Larsen', 'Jens', '', 12, 1, '1991-02-21', 'Udinese Calcio', 'Italien'),
(2910, 29, 'M', 19, 'Schöne', 'Lasse', '', 35, 3, '1986-05-27', 'Ajax Amsterdam', 'Niederlande'),
(2911, 29, 'M', 7, 'Kvist', 'William', '', 79, 2, '1985-02-24', 'FC Kopenhagen', 'Dänemark'),
(2912, 29, 'M', 8, 'Delaney', 'Thomas', '', 26, 4, '1991-09-03', 'SV Werder Bremen', 'Deutschland'),
(2913, 29, 'M', 18, 'Lerager', 'Lukas', '', 3, 0, '1993-07-12', 'FC Girondins Bordeaux', 'Frankreich'),
(2914, 29, 'M', 2, 'Krohn-Dehli', 'Michael', '', 57, 5, '1983-06-06', 'Deportivo La Coruna', 'Spanien'),
(2915, 29, 'M', 10, 'Eriksen', 'Christian', '', 77, 21, '1992-02-14', 'Tottenham Hotspur', 'England'),
(2916, 29, 'A', 23, 'Sisto', 'Pione', '', 13, 1, '1995-02-04', 'Celta Vigo', 'Spanien'),
(2917, 29, 'A', 15, 'Fischer', 'Viktor', '', 18, 3, '1994-06-09', 'FC Kopenhagen', 'Dänemark'),
(2918, 29, 'A', 9, 'Jörgensen', 'Nicolai', '', 30, 8, '1991-01-15', 'Feyenoord Rotterdam', 'Niederlande'),
(2919, 29, 'A', 12, 'Dolberg', 'Kasper', '', 5, 1, '1997-10-06', 'Ajax Amsterdam', 'Niederlande'),
(2920, 29, 'A', 20, 'Poulsen', 'Yussuf', '', 27, 3, '1994-06-15', 'RasenBallsport Leipzig', 'Deutschland'),
(2921, 29, 'A', 11, 'Braithwaite', 'Martin', '', 19, 1, '1991-06-05', 'FC Girondins Bordeaux', 'Frankreich'),
(2922, 29, 'A', 21, 'Cornelius', 'Andreas', '', 18, 4, '1993-03-16', 'Atalanta Bergamo', 'Italien');

-- 13 Argentinien = ID 8
REPLACE INTO `{prefix}spieler` (`id`, `team`, `position`, `nummer`, `name`, `firstname`, `nickname`, `caps`, `goals`, `birthdate`, `club`, `clubcountry`) VALUES
(800, 8, 'T', 12, 'Armani', 'Franco', '', 0, 0, '1986-10-16', 'CA River Plate', 'Argentinien'),
(801, 8, 'T', 23, 'Caballero', 'Wilfredo', '', 3, 0, '1981-09-28', 'FC Chelsea', 'England'),
(802, 8, 'T', 1, 'Guzman', 'Nahuel', '', 1, 0, '1986-02-10', 'UANL Tigres', 'Mexico'),
(804, 8, 'V', 6, 'Fazio', 'Federico', '', 5, 0, '1987-03-17', 'AS Rom', 'Italien'),
(806, 8, 'V', 14, 'Mascherano', 'Javier', '', 86, 2, '1984-06-08', 'FC Barcelona', 'Spanien'),
(807, 8, 'V', 2, 'Mercado', 'Gabriel', '', 11, 1, '1987-03-18', 'FC Sevilla', 'Spanien'),
(808, 8, 'V', 17, 'Otamendi', 'Nicolas', '', 16, 2, '1988-02-12', 'Manchester City', 'England'),
(809, 8, 'V', 16, 'Rojo', 'Marcos', '', 32, 2, '1990-03-20', 'Manchester United', 'England'),
(810, 8, 'V', 3, 'Tagliafico', 'Nicolas', '', 3, 0, '1992-08-31', 'Ajax Amsterdam', 'Niederlande'),
(811, 8, 'M', 8, 'Acuna', 'Marcos', '', 8, 0, '1991-10-28', 'Sporting Lissabon', 'Portugal'),
(812, 8, 'M', 7, 'Banega', 'Ever', '', 31, 4, '1988-06-29', 'FC Sevilla', 'Spanien'),
(813, 8, 'M', 5, 'Biglia', 'Lucas', '', 33, 0, '1986-01-30', 'AC Mailand', 'Italien'),
(815, 8, 'M', 20, 'Lo Celso', 'Giovani', '', 8, 0, '1996-04-09', 'Paris St. Germain', 'Frankreich'),
(816, 8, 'M', 13, 'Meza', 'Maximiliano', '', 2, 0, '1992-01-15', 'CA Independiente', 'Argentinien'),
(820, 8, 'M', 18, 'Salvio', 'Eduardo', '', 4, 0, '1990-07-13', 'Benfica Lissabon', 'Portugal'),
(821, 8, 'A', 19, 'Aguero', 'Sergio', '', 48, 20, '1988-06-02', 'Manchester City', 'England'),
(822, 8, 'A', 11, 'Di Maria', 'Angel', '', 53, 11, '1988-05-14', 'Paris St.Germain', 'Frankreich'),
(823, 8, 'A', 9, 'Higuain', 'Gonzalo', '', 43, 23, '1987-12-10', 'Juventus Turin', 'Italien'),
(825, 8, 'A', 10, 'Messi', 'Lionel', '', 80, 35, '1987-06-24', 'FC Barcelona', 'Spanien'),
(826, 8, 'A', 22, 'Pavon', 'Cristian David', '', 8, 0, '1996-01-21', 'Boca Juniors', 'Argentinien'),
(828, 8, 'V', 4, 'Ansaldi', 'Cristian', '', 5, 1, '1986-09-20', 'FC Turin', 'Italien'),
(829, 8, 'A', 21, 'Dybala', 'Paulo', '', 12, 0, '1993-11-15', 'Juventus Turin', 'Italien'),
(830, 8, 'M', 15, 'Pérez', 'Enzo', '', 23, 1, '1986-02-22', 'CA River Plate', 'Argentinien');

-- 14 Island = ID 80
REPLACE INTO `{prefix}spieler` (`id`, `team`, `position`, `nummer`, `name`, `firstname`, `nickname`, `caps`, `goals`, `birthdate`, `club`, `clubcountry`) VALUES
(8000, 80, 'T', 1, 'Halldorsson', 'Hannes', '', 14, 0, '1984-04-27', 'Randers FC', 'Dänemark'),
(8001, 80, 'T', 13, 'Runarsson', 'Runar', '', 2, 0, '1995-02-18', 'FC Nordsjælland', 'Dänemark'),
(8002, 80, 'T', 12, 'Schram', 'Frederik Agust', '', 0, 0, '1995-01-19', 'FC Vestsjælland', 'Dänemark'),
(8003, 80, 'V', 14, 'Arnason', 'Kari', '', 47, 4, '1982-10-13', 'FC Aberdeen', 'Schottland'),
(8004, 80, 'V', 15, 'Eyjolfsson', 'Holmar Orn', '', 2, 0, '1990-08-06', 'Levski Sofia', 'Bulgarien'),
(8005, 80, 'V', 3, 'Fridjonsson', 'Samuel Kari', '', 1, 0, '1996-02-22', 'Valerenga IF', 'Norwegen'),
(8006, 80, 'V', 5, 'Ingason', 'Sverrir', '', 11, 0, '1993-08-05', 'FK Rostow', 'Russland'),
(8007, 80, 'V', 18, 'Magnusson', 'Hordur', '', 10, 2, '1993-02-11', 'Bristol City', 'USA'),
(8008, 80, 'V', 2, 'Saevarsson', 'Birkir Mar', '', 18, 0, '1984-11-11', 'Valur Reykjavik', 'Island'),
(8009, 80, 'V', 6, 'Sigurdsson', 'Ragnar', '', 46, 2, '1986-06-19', 'FK Rostow', 'Russland'),
(8010, 80, 'V', 23, 'Skulason', 'Ari', '', 36, 0, '1987-05-14', 'SC Lokeren', 'Belgien'),
(8011, 80, 'M', 8, 'Bjarnason', 'Birkir', '', 45, 8, '1988-05-27', 'Aston Villa', 'England'),
(8012, 80, 'M', 19, 'Gislason', 'Rurik', '', 28, 1, '1988-02-25', 'SV Sandhausen', 'Deutschland'),
(8013, 80, 'M', 4, 'Gudmundsson', 'Albert', '', 1, 0, '1997-06-15', 'PSV Eindhoven', 'Niederlande'),
(8014, 80, 'M', 7, 'Gudmundsson', 'Johann', '', 42, 5, '1990-10-27', 'FC Burnley', 'England'),
(8015, 80, 'M', 17, 'Gunnarsson', 'Aron', '', 17, 0, '1989-04-22', 'Cardiff City', 'Wales'),
(8016, 80, 'M', 20, 'Hallfredsson', 'Emil', '', 38, 1, '1984-06-29', 'Udinese Calcio', 'Italien'),
(8017, 80, 'M', 10, 'Sigurdsson', 'Gylfi', '', 41, 16, '1989-09-08', 'FC Everton', 'England'),
(8018, 80, 'M', 16, 'Skulason', 'Olafur', '', 16, 0, '1983-04-01', 'Karabükspor', 'Türkei'),
(8019, 80, 'M', 21, 'Traustason', 'Arnor', '', 8, 1, '1993-04-30', 'Malmö FF', 'Schweden'),
(8020, 80, 'A', 22, 'Bodvarsson', 'Jon', '', 14, 1, '1992-05-25', 'FC Reading', 'England'),
(8021, 80, 'A', 11, 'Finnbogason', 'Alfred', '', 30, 5, '1989-02-01', 'FC Augsburg', 'Deutschland'),
(8022, 80, 'A', 9, 'Sigurdarson', 'Bjorn', '', 8, 1, '1991-02-26', 'FK Rostow', 'Russland');

-- 15 Kroatien = ID 38
REPLACE INTO `{prefix}spieler` (`id`, `team`, `position`, `nummer`, `name`, `firstname`, `nickname`, `caps`, `goals`, `birthdate`, `club`, `clubcountry`) VALUES
(3800, 38, 'T', 1, 'Livakovic', 'Dominik', '', 1, 0, '1995-01-09', 'GNK Dinamo Zagreb', 'Kroatien'),
(3801, 38, 'V', 2, 'Vrsaljko', 'Sime', '', 35, 0, '1992-01-10', 'Atletico Madrid', 'Spanien'),
(3802, 38, 'V', 3, 'Strinic', 'Ivan', '', 42, 0, '1987-07-17', 'UC Sampdoria', 'Italien'),
(3803, 38, 'A', 4, 'Perisic', 'Ivan', '', 65, 17, '1989-02-02', 'FC Internazionale', 'Italien'),
(3804, 38, 'V', 5, 'Corluka', 'Vedran', '', 98, 4, '1986-02-05', 'FC Lokomotiv Moscow', 'Russland'),
(3805, 38, 'V', 6, 'Lovren', 'Dejan', '', 38, 2, '1989-07-05', 'Liverpool FC', 'England'),
(3806, 38, 'M', 7, 'Rakitic', 'Ivan', '', 91, 14, '1988-03-10', 'FC Barcelona', 'Spanien'),
(3807, 38, 'M', 8, 'Kovacic', 'Mateo', '', 40, 1, '1994-05-06', 'Real Madrid CF', 'Spanien'),
(3808, 38, 'A', 9, 'Kramaric', 'Andrej', '', 30, 8, '1991-06-19', 'TSG 1899 Hoffenheim', 'Deutschland'),
(3809, 38, 'M', 10, 'Modric', 'Luka', '', 105, 12, '1985-09-09', 'Real Madrid CF', 'Spanien'),
(3810, 38, 'M', 11, 'Brozovic', 'Marcelo', '', 34, 6, '1992-11-16', 'FC Internazionale', 'Italien'),
(3811, 38, 'T', 12, 'Kalinic', 'Lovre', '', 10, 0, '1990-04-03', 'KAA Gent', 'Belgien'),
(3812, 38, 'V', 13, 'Jedvaj', 'Tin', '', 11, 0, '1995-11-28', 'Bayer 04 Leverkusen', 'Deutschland'),
(3813, 38, 'M', 14, 'Bradaric', 'Filip', '', 4, 0, '1992-01-11', 'HNK Rijeka', 'Kroatien'),
(3814, 38, 'V', 15, 'Caleta-Car', 'Duje', '', 1, 0, '1996-09-17', 'FC Red Bull Salzburg', 'Österreich'),
(3815, 38, 'A', 16, 'Kalinic', 'Nikola', '', 41, 15, '1988-01-05', 'AC Milan', 'Italien'),
(3816, 38, 'A', 17, 'Mandzukic', 'Mario', '', 82, 30, '1986-05-21', 'Juventus FC', 'Italien'),
(3817, 38, 'A', 18, 'Rebic', 'Ante', '', 15, 1, '1993-09-21', 'Eintracht Frankfurt', 'Deutschland'),
(3818, 38, 'M', 19, 'Badelj', 'Milan', '', 37, 1, '1989-02-25', 'ACF Fiorentina', 'Italien'),
(3819, 38, 'A', 20, 'Pjaca', 'Marko', '', 16, 1, '1995-05-06', 'FC Schalke 04', 'Deutschland'),
(3820, 38, 'V', 21, 'Vida', 'Domagoj', '', 58, 2, '1989-04-29', 'Besiktas JK', 'Türkei'),
(3821, 38, 'V', 22, 'Pivaric', 'Josip', '', 19, 0, '1989-01-30', 'FC Dynamo Kyiv', 'Ukraine'),
(3822, 38, 'T', 23, 'Subasic', 'Danijel', '', 37, 0, '1984-10-27', 'AS Monaco', 'Frankreich');

-- 16 Nigeria = ID 2
REPLACE INTO `{prefix}spieler` (`id`, `team`, `position`, `nummer`, `name`, `firstname`, `nickname`, `caps`, `goals`, `birthdate`, `club`, `clubcountry`) VALUES
(200, 2, 'T', 16, 'Akpeyi', 'Daniel', '', 7, 0, '1986-08-03', 'Chippa United', 'Südafrika'),
(201, 2, 'T', 23, 'Uzoho', 'Francis', '', 3, 0, '1998-10-28', 'Deportivo de La Coruña B', 'Spanien'),
(202, 2, 'T', 1, 'Ezenwa', 'Ikechukwu', '', 24, 0, '1988-10-16', 'Enyimba Aba', 'Nigeria'),
(204, 2, 'V', 20, 'Awaziem', 'Chidozie', '', 4, 0, '1997-01-01', 'FC Nantes', 'Frankreich'),
(205, 2, 'V', 6, 'Balogun', 'Leon', '', 16, 0, '1988-06-28', '1.FSV Mainz 05', 'Deutschland'),
(206, 2, 'V', 22, 'Omeruo', 'Kenneth', '', 37, 0, '1993-10-17', 'Kasimpasa', 'Türkei'),
(207, 2, 'V', 5, 'Troost-Ekong', 'William', '', 19, 0, '1993-09-01', 'Bursaspor', 'Türkei'),
(209, 2, 'V', 3, 'Echiéjilé', 'Uwa Elderson', 'Elderson', 60, 3, '1988-01-20', 'Cercle Brügge', 'Belgien'),
(210, 2, 'V', 21, 'Ebuehi', 'Tyronne', '', 4, 0, '1995-12-16', 'ADO Den Haag', 'Niederlande'),
(212, 2, 'V', 2, 'Idowu', 'Bryan', '', 3, 1, '1992-05-18', 'Amkar Perm', 'Russland'),
(213, 2, 'M', 4, 'Ndidi', 'Onyinye', '', 16, 0, '1996-12-16', 'Leicester City', 'England'),
(214, 2, 'M', 10, 'Obi', 'John Mikel', '', 83, 6, '1987-04-22', 'Tianjin Teda', 'China'),
(215, 2, 'M', 17, 'Onazi', 'Ogenyi', '', 50, 1, '1992-12-25', 'Trabzonspor', 'Türkei'),
(218, 2, 'M', 12, 'Shehu', 'Abdullahi', '', 22, 0, '1993-03-12', 'Bursaspor', 'Türkei'),
(219, 2, 'M', 15, 'Obi', 'Joel', '', 15, 0, '1991-05-22', 'FC Turin', 'Italien'),
(220, 2, 'M', 19, 'Ogu', 'John', '', 18, 2, '1988-04-20', 'Hapoel Beer Sheva', 'Israel'),
(221, 2, 'M', 11, 'Moses', 'Victor', '', 32, 11, '1990-12-12', 'FC Chelsea', 'England'),
(222, 2, 'M', 8, 'Etebo', 'Oghenekaro', '', 12, 1, '1995-11-09', 'UD Las Palmas', 'Spanien'),
(223, 2, 'A', 18, 'Iwobi', 'Alex', '', 16, 1, '1996-05-03', 'FC Arsenal', 'England'),
(225, 2, 'A', 7, 'Musa', 'Ahmed', '', 69, 13, '1992-10-14', 'ZSKA Moskau', 'Russland'),
(226, 2, 'A', 14, 'Iheanacho', 'Kelechi', '', 15, 8, '1996-10-03', 'Leicester City', 'England'),
(227, 2, 'A', 9, 'Ighalo', 'Odion', '', 17, 4, '1989-06-16', 'Changchun Yatai', 'China'),
(228, 2, 'A', 13, 'Nwankwo', 'Simeon Tochukwu', 'Simy', 0, 0, '1992-05-07', 'FC Crotone', 'Italien');

-- 17 Brasilien = ID 22
REPLACE INTO `{prefix}spieler` (`id`, `team`, `position`, `nummer`, `name`, `firstname`, `nickname`, `caps`, `goals`, `birthdate`, `club`, `clubcountry`) VALUES
(2200, 22, 'T', 23, 'Santana de Moraes', 'Ederson', 'Ederson', 1, 0, '1993-08-17', 'Manchester City', 'England'),
(2201, 22, 'T', 1, 'Ramses Becker', 'Alisson', 'Alisson', 24, 0, '1992-10-02', 'AS Rom', 'Italien'),
(2202, 22, 'T', 16, 'Ramos', 'Cássio', 'Cássio', 1, 0, '1987-06-06', 'Corinthians Sao Paulo', 'Brasilien'),
(2203, 22, 'V', 13, 'Aoás Corrêa', 'Marcos', 'Marquinhos', 24, 0, '1994-05-14', 'FC Paris Saint-Germain', 'Frankreich'),
(2204, 22, 'V', 2, 'Silva', 'Thiago', '', 68, 5, '1984-09-22', 'FC Paris Saint-Germain', 'Frankreich'),
(2205, 22, 'V', 3, 'de Souza Filho', 'João Miranda', 'Miranda', 44, 2, '1984-09-07', 'Inter Mailand', 'Italien'),
(2206, 22, 'V', 4, 'Geromel', 'Pedro', '', 2, 0, '1985-09-21', 'Grêmio Porto Alegre', 'Brasilien'),
(2207, 22, 'V', 12, 'da Silva Júnior', 'Marcelo Vieira', 'Marcelo', 51, 5, '1988-05-12', 'Real Madrid', 'Spanien'),
(2208, 22, 'V', 6, 'Luís', 'Filipe', '', 31, 2, '1985-08-09', 'Atletico Madrid', 'Spanien'),
(2209, 22, 'V', 14, 'Luiz da Silva', 'Danilo', 'Danilo', 16, 1, '1991-07-15', 'Manchester City', 'England'),
(2210, 22, 'V', 22, 'Conserva Lemos', 'Fágner', 'Fágner', 4, 0, '1989-06-11', 'Corinthians Sao Paulo', 'Brasilien'),
(2211, 22, 'M', 5, 'Casemiro', 'Carlos Henrique', 'Casimero', 22, 0, '1992-02-23', 'Real Madrid', 'Spanien'),
(2212, 22, 'M', 17, 'Luis Roza', 'Fernando', 'Fernandinho', 41, 2, '1985-05-04', 'Manchester City', 'England'),
(2213, 22, 'M', 15, 'Bezerra Maciel Júnior', 'José Paulo', 'Paulinho', 47, 12, '1988-07-25', 'FC Barcelona', 'Spanien'),
(2214, 22, 'M', 18, 'de Paula Santos', 'Frederico Rodrigues', 'Fred', 7, 0, '1993-03-05', 'Shakhtar Donetsk', 'Ukraine'),
(2215, 22, 'M', 8, 'Augusto', 'Renato', '', 28, 5, '1988-02-08', 'Beijing Sinobo Guoan', 'China'),
(2216, 22, 'A', 10, 'da Silva Santos Júnior', 'Neymar', 'Neymar', 83, 53, '1992-02-05', 'FC Paris Saint-Germain', 'Frankreich'),
(2217, 22, 'A', 11, 'Coutinho', 'Philippe', '', 35, 9, '1992-06-12', 'FC Barcelona', 'Spanien'),
(2218, 22, 'A', 21, 'Barcellos Freda', 'Taison', 'Taison', 6, 1, '1988-01-13', 'Shakhtar Donetsk', 'Ukraine'),
(2219, 22, 'A', 7, 'de Souza', 'Douglas Costa', 'Douglas Costa', 24, 3, '1990-09-14', 'Juventus Turin', 'Italien'),
(2220, 22, 'A', 19, 'da Silva', 'Willian Borges', 'Willian', 54, 8, '1988-08-09', 'FC Chelsea', 'England'),
(2221, 22, 'A', 20, 'Firmino', 'Roberto', '', 18, 5, '1991-10-02', 'FC Liverpool', 'England'),
(2222, 22, 'A', 9, 'de Jesus', 'Gabriel Fernando', 'Gabriel Jesus', 15, 9, '1997-04-03', 'Manchester City', 'England');

-- 18 Schweiz = ID 6
REPLACE INTO `{prefix}spieler` (`id`, `team`, `position`, `nummer`, `name`, `firstname`, `nickname`, `caps`, `goals`, `birthdate`, `club`, `clubcountry`) VALUES
(600, 6, 'T', 1, 'Sommer', 'Yann', '', 34, 0, '1988-12-17', 'Borussia Mönchengladbach', 'Deutschland'),
(601, 6, 'T', 21, 'Bürki', 'Roman', '', 8, 0, '1990-11-14', 'Borussia Dortmund', 'Deutschland'),
(603, 6, 'V', 13, 'Rodriguez', 'Ricardo', '', 51, 3, '1992-08-25', 'AC Milan', 'Italien'),
(604, 6, 'V', 2, 'Lichtsteiner', 'Stephan', '', 98, 8, '1986-01-16', 'Juventus Turin', 'Italien'),
(605, 6, 'V', 3, 'Moubandje', 'Francois', '', 16, 0, '1990-05-21', 'FC Toulouse', 'Frankreich'),
(607, 6, 'V', 20, 'Djourou', 'Johan', '', 73, 2, '1987-01-18', 'Antalyaspor', 'Türkei'),
(608, 6, 'V', 22, 'Schär', 'Fabian', '', 37, 7, '1991-12-20', 'Deportiva La Coruna', 'Spanien'),
(609, 6, 'V', 5, 'Akanji', 'Manuel', '', 5, 0, '1995-07-19', 'Borussia Dortmund', 'Deutschland'),
(610, 6, 'V', 4, 'Elvedi', 'Nico', '', 5, 0, '1996-09-30', 'Borussia Mönchengladbach', 'Deutschland'),
(612, 6, 'V', 6, 'Lang', 'Michael', '', 23, 2, '1991-02-08', 'FC Basel 1893', 'Schweiz'),
(613, 6, 'M', 15, 'Dzemaili', 'Blerim', '', 63, 10, '1986-04-12', 'FC Bologna', 'Italien'),
(614, 6, 'M', 14, 'Zuber', 'Steven', '', 10, 3, '1991-08-17', 'TSG 1899 Hoffenheim', 'Deutschland'),
(615, 6, 'M', 23, 'Shaqiri', 'Xherdan', '', 68, 20, '1991-10-10', 'Stoke City', 'England'),
(616, 6, 'M', 10, 'Xhaka', 'Granit', '', 61, 9, '1992-09-27', 'Arsenal FC', 'England'),
(617, 6, 'M', 11, 'Behrami', 'Valon', '', 77, 2, '1985-04-19', 'Udinese Calcio', 'Italien'),
(618, 6, 'M', 8, 'Freuler', 'Remo', '', 9, 0, '1992-04-15', 'Atalanta Bergamo', 'Italien'),
(620, 6, 'M', 17, 'Zakaria', 'Denis', '', 9, 0, '1996-11-20', 'Borussia Mönchengladbach', 'Deutschland'),
(621, 6, 'M', 16, 'Fernandes', 'Gelson', '', 66, 2, '1986-09-02', 'Eintracht Frankfurt', 'Deutschland'),
(623, 6, 'A', 7, 'Embolo', 'Breel', '', 23, 3, '1997-02-14', 'Schalke 04', 'Deutschland'),
(624, 6, 'A', 9, 'Seferovic', 'Haris', '', 49, 11, '1992-02-22', 'Benfica Lissabon', 'Portugal'),
(625, 6, 'A', 19, 'Drmic', 'Josip', '', 27, 9, '1992-08-08', 'Borussia Mönchengladbach', 'Deutschland'),
(626, 6, 'A', 18, 'Gavranovic', 'Mario', '', 13, 5, '1989-11-24', 'Dinamo Zagreb', 'Kroatien'),
(627, 6, 'T', 12, 'Mvogo', 'Yvon', '', 0, 0, '1994-06-06', 'RasenBallsport Leipzig', 'Deutschland');

-- 19 Costa Rica = ID 34
REPLACE INTO `{prefix}spieler` (`id`, `team`, `position`, `nummer`, `name`, `firstname`, `nickname`, `caps`, `goals`, `birthdate`, `club`, `clubcountry`) VALUES
(3400, 34, 'T', 1, 'Keylor', 'Navas', '', 78, 0, '1986-12-12', 'Real Madrid', 'Spanien'),
(3401, 34, 'T', 23, 'Moreira', 'Leonel', '', 7, 0, '1990-04-02', 'CS Herediano', 'Costa Rica'),
(3402, 34, 'T', 18, 'Pemberton', 'Patrick', '', 38, 0, '1982-04-24', 'LD Alajuelense', 'Costa Rica'),
(3403, 34, 'V', 3, 'González', 'Giancarlo', '', 66, 2, '1988-02-08', 'FC Bologna', 'Italien'),
(3404, 34, 'V', 6, 'Duarte', 'Óscar', '', 36, 2, '1989-06-03', 'Espanyol Barcelona', 'Spanien'),
(3405, 34, 'V', 19, 'Waston', 'Kendall', '', 24, 2, '1988-01-01', 'Vancouver Whitecaps', 'Kanada'),
(3406, 34, 'V', 15, 'Calvo', 'Francisco', '', 35, 3, '1992-07-08', 'Minnesota United FC', 'USA'),
(3407, 34, 'V', 22, 'Gutiérrez', 'Kenner', '', 9, 0, '1989-06-09', 'LD Alajuelense', 'Costa Rica'),
(3408, 34, 'V', 2, 'Acosta', 'Jhonny', '', 66, 2, '1983-07-21', 'Rionegro Águilas', 'Kolumbien'),
(3409, 34, 'V', 8, 'Oviedo', 'Bryan', '', 41, 1, '1990-02-18', 'AFC Sunderland', 'England'),
(3411, 34, 'V', 16, 'Gamboa', 'Cristian', '', 64, 3, '1989-10-24', 'Celtic Glasgow', 'Schottland'),
(3412, 34, 'V', 4, 'Smith', 'Ian', '', 1, 0, '1998-03-06', 'IFK Norrköping', 'Schweden'),
(3413, 34, 'M', 20, 'Guzmán', 'David', '', 43, 0, '1990-02-18', 'Portland Timbers', 'USA'),
(3414, 34, 'M', 17, 'Tejeda', 'Yeltsin', '', 47, 0, '1992-03-17', 'FC Lausanne-Sport', 'Schweiz'),
(3415, 34, 'M', 14, 'Azofeifa', 'Randall', '', 58, 3, '1984-12-30', 'CS Herediano', 'Costa Rica'),
(3416, 34, 'M', 5, 'Borges', 'Celso', '', 109, 18, '1988-05-27', 'Deportivo La Coruna', 'Spanien'),
(3418, 34, 'M', 11, 'Venegas', 'Johan', '', 44, 9, '1988-11-27', 'Deportivo Saprissa', 'Costa Rica'),
(3419, 34, 'M', 10, 'Ruíz', 'Bryan', '', 109, 23, '1985-08-18', 'Sporting Lissabon', 'Portugal'),
(3420, 34, 'M', 13, 'Wallace', 'Rodney', '', 29, 4, '1988-06-17', 'New York City FC', 'USA'),
(3421, 34, 'A', 9, 'Colindres', 'Daniel', '', 12, 0, '1985-01-10', 'Deportivo Saprissa', 'Costa Rica'),
(3422, 34, 'A', 12, 'Campbell', 'Joel', '', 74, 14, '1992-06-26', 'Real Betis Sevilla', 'Spanien'),
(3423, 34, 'A', 7, 'Bolaños', 'Christian', '', 80, 7, '1984-05-17', 'Deportivo Saprissa', 'Costa Rica'),
(3424, 34, 'A', 21, 'Ureña', 'Marcos', '', 7, 3, '1990-03-05', 'Los Angeles FC', 'USA');

-- 20 Serbien = ID 30
REPLACE INTO `{prefix}spieler` (`id`, `team`, `position`, `nummer`, `name`, `firstname`, `nickname`, `caps`, `goals`, `birthdate`, `club`, `clubcountry`) VALUES
(3000, 30, 'T', 23, 'Dmitrovic', 'Marko', '', 2, 0, '1992-01-24', 'SD Eibar', 'Spanien'),
(3001, 30, 'T', 12, 'Rajkovic', 'Predrag', '', 7, 0, '1995-10-31', 'Maccabi Tel Aviv', 'Israel'),
(3002, 30, 'T', 1, 'Stojkovic', 'Vladimir', '', 79, 0, '1983-07-28', 'FK Partizan Belgrad ', 'Serbien'),
(3003, 30, 'V', 5, 'Spajic', 'Uros', '', 5, 0, '1993-02-13', 'RSC Anderlecht', 'Belgien'),
(3004, 30, 'V', 13, 'Veljkovic', 'Milos', '', 2, 0, '1995-09-26', 'SV Werder Bremen', 'Deutschland'),
(3005, 30, 'V', 15, 'Milenkovic', 'Nikola', '', 1, 0, '1997-10-12', 'AC Florenz', 'Italien'),
(3006, 30, 'V', 6, 'Ivanovic', 'Branislav', '', 102, 12, '1984-02-22', 'Zenit St. Petersburg', 'Russland'),
(3007, 30, 'V', 3, 'Tosic', 'Dusko', '', 22, 1, '1985-01-19', 'Besiktas Istanbul', 'Türkei'),
(3008, 30, 'V', 11, 'Kolarov', 'Aleksandar', '', 74, 10, '1985-11-10', 'AS Rom', 'Italien'),
(3009, 30, 'V', 14, 'Rodic', 'Milan', '', 0, 0, '1991-04-02',  'Roter Stern Belgrad', 'Serbien'), 
(3010, 30, 'V', 2, 'Rukavina', 'Antonio', '', 45, 0, '1984-01-26', 'FC Villarreal', 'Spanien'),
(3011, 30, 'M', 21, 'Matic', 'Nemanja', '', 38, 2, '1988-08-01', 'Manchester United', 'England'),
(3012, 30, 'M', 4, 'Milivojevic', 'Luka', '', 26, 1, '1991-04-07', 'Crystal Palace', 'England'),
(3013, 30, 'M', 20, 'Milinkovic-Savic', 'Sergej', '', 2, 0, '1995-02-27', 'Lazio Rom', 'Italien'),
(3014, 30, 'M', 16, 'Grujic', 'Marko', '', 6, 0, '1996-04-13', 'FC Liverpool', 'England'),
(3015, 30, 'M', 10, 'Tadic', 'Dusan', '', 51, 13, '1988-11-20', 'FC Southampton', 'England'),
(3016, 30, 'M', 22, 'Ljajic', 'Adem', '', 27, 5, '1991-09-29', 'FC Turin', 'Italien'),
(3017, 30, 'M', 7, 'Zivkovic', 'Andrija', '', 9, 0, '1996-07-11', 'Benfica Lissabon', 'Portugal'),
(3018, 30, 'A', 17, 'Kostic', 'Filip', '', 21, 2, '1992-11-01', 'Hamburger SV', 'Deutschland'),
(3019, 30, 'A', 18, 'Radonjic', 'Nemanja', '', 1, 0, '1996-02-15', 'Roter Stern Belgrad', 'Serbien'),
(3020, 30, 'A', 9, 'Mitrovic', 'Aleksandar', '', 35, 13, '1994-09-16', 'Newcastle United', 'England'),
(3021, 30, 'A', 8, 'Prijovic', 'Aleksandar', '', 8, 1, '1990-04-21', 'PAOK Thessaloniki', 'Griechenland'),
(3022, 30, 'A', 19, 'Jovic', 'Luka', '', 0, 0, '1997-12-23', 'Eintracht Frankfurt', 'Deutschland');

-- 21 Deutschland = ID 27
REPLACE INTO `{prefix}spieler` (`id`, `team`, `position`, `nummer`, `name`, `firstname`, `nickname`, `caps`, `goals`, `birthdate`, `club`, `clubcountry`) VALUES
(2700, 27, 'T', 1, 'Neuer', 'Manuel', '', 74, 0, '1986-03-27', 'FC Bayern München', 'Deutschland'),
(2701, 27, 'T', 22, 'ter Stegen', 'Marc-André', '', 19, 0, '1992-04-30', 'FC Barcelona', 'Spanien'),
(2703, 27, 'T', 12, 'Trapp', 'Kevin', '', 3, 0, '1990-07-08', 'Paris St. Germain', 'Frankreich'),
(2704, 27, 'V', 5, 'Hummels', 'Mats', '', 63, 5, '1988-12-16', 'FC Bayern München', 'Deutschland'),
(2705, 27, 'V', 17, 'Boateng', 'Jerôme', '', 37, 0, '1988-09-03', 'FC Bayern München', 'Deutschland'),
(2706, 27, 'V', 16, 'Rüdiger', 'Antonio', '', 23, 1, '1993-03-03', 'FC Chelsea', 'England'),
(2707, 27, 'V', 15, 'Süle', 'Niklas', '', 9, 0, '1995-09-03', 'FC Bayern München', 'Deutschland'),
(2709, 27, 'V', 4, 'Ginter', 'Matthias', '', 17, 0, '1994-01-19', 'Bor. Mönchengladbach', 'Deutschland'),
(2710, 27, 'V', 3, 'Hector', 'Jonas', '', 36, 3, '1990-05-27', '1.FC Köln', 'Deutschland'),
(2711, 27, 'V', 2, 'Plattenhardt', 'Marvin', '', 6, 0, '1992-01-26', 'Hertha BSC', 'Deutschland'),
(2712, 27, 'V', 18, 'Kimmich', 'Joshua', '', 27, 3, '1995-02-08', 'FC Bayern München', 'Deutschland'),
(2713, 27, 'M', 19, 'Rudy', 'Sebastian', '', 24, 1, '1990-02-28', 'FC Bayern München', 'Deutschland'),
(2714, 27, 'M', 8, 'Kroos', 'Toni', '', 82, 12, '1990-01-04', 'Real Madrid', 'Spanien'),
(2715, 27, 'M', 14, 'Goretzka', 'Leon', '', 14, 6, '1995-02-06', 'FC Schalke 04', 'Deutschland'),
(2716, 27, 'M', 21, 'Gündogan', 'Ilkay', '', 24, 4, '1990-10-24', 'Manchester City', 'England'),
(2717, 27, 'M', 6, 'Khedira', 'Sami', '', 73, 7, '1987-04-04', 'Juventus Turin', 'Italien'),
(2718, 27, 'M', 10, 'Özil', 'Mesut', '', 89, 22, '1988-10-15', 'FC Arsenal', 'England'),
(2720, 27, 'A', 7, 'Draxler', 'Julian', '', 42, 6, '1993-09-20', 'Paris St. Germain', 'Frankreich'),
(2721, 27, 'A', 11, 'Reus', 'Marco', '', 29, 9, '1989-05-31', 'Borussia Dortmund', 'Deutschland'),
(2722, 27, 'A', 20, 'Brandt', 'Julian', '', 14, 1, '1996-05-02', 'Bayer 04 Leverkusen', 'Deutschland'),
(2723, 27, 'A', 13, 'Müller', 'Thomas', '', 90, 38, '1989-09-13', 'FC Bayern München', 'Deutschland'),
(2724, 27, 'A', 9, 'Werner', 'Timo', '', 12, 7, '1996-03-06', 'RB Leipzig', 'Deutschland'),
(2726, 27, 'A', 23, 'Gómez', 'Mario', '', 73, 31, '1985-07-10', 'VfB Stuttgart', 'Deutschland');

-- 22 Mexiko = ID 32
REPLACE INTO `{prefix}spieler` (`id`, `team`, `position`, `nummer`, `name`, `firstname`, `nickname`, `caps`, `goals`, `birthdate`, `club`, `clubcountry`) VALUES
(3200, 32, 'T', 13, 'Ochoa', 'Guillermo', '', 90, 0, '1985-07-13', 'Standard Lüttich', 'Belgien'),
(3201, 32, 'T', 12, 'Talavera', 'Alfredo', '', 27, 0, '1982-09-18', 'Deportivo Toluca', 'Mexiko'),
(3202, 32, 'T', 1, 'Corona', 'Jesús', '', 51, 0, '1981-01-26', 'CD Cruz Azul', 'Mexiko'),
(3203, 32, 'V', 3, 'Salcedo', 'Carlos', '', 18, 0, '1993-09-29', 'Eintracht Frankfurt', 'Deutschland'),
(3205, 32, 'V', 15, 'Moreno', 'Héctor', '', 89, 3, '1988-01-17', 'Real Sociedad San Sebastián', 'Spanien'),
(3207, 32, 'V', 2, 'Ayala', 'Hugo', '', 38, 1, '1987-03-31', 'Tigres UANL', 'Mexiko'),
(3209, 32, 'V', 21, 'Álvarez', 'Edson', '', 9, 1, '1997-10-24', 'CF América', 'Mexiko'),
(3210, 32, 'V', 4, 'Márquez', 'Rafael', '', 141, 17, '1979-02-13', 'Atlas Guadalajara', 'Mexiko'),
(3211, 32, 'V', 7, 'Layún', 'Miguel', '', 60, 4, '1988-06-25', 'FC Sevilla', 'Spanien'),
(3213, 32, 'M', 16, 'Herrera', 'Héctor', '', 63, 5, '1990-04-19', 'FC Porto', 'Portugal'),
(3214, 32 ,'M', 5 , 'Gutiérrez', 'Érick', '', 8, 0, '1995-06-15', 'CF Pachuca', 'Mexiko'),
(3215, 32, 'M', 18, 'Guardado', 'Andrés', '', 144, 25, '1986-09-28', 'Real Betis Sevilla', 'Spanien'),
(3216, 32, 'M', 6, 'dos Santos', 'Jonathan', '', 32, 0, '1990-04-26', 'Los Angeles Galaxy', 'USA'),
(3217, 32, 'M', 8, 'Fabián', 'Marco', '', 36, 9, '1989-07-21', 'Eintracht Frankfurt', 'Deutschland'),
(3218, 32, 'A', 22, 'Lozano', 'Hirving', '', 26, 7, '1995-07-30', 'PSV Eindhoven', 'Niederlande'),
(3219, 32, 'A', 20, 'Aquino', 'Javier', '', 50, 0, '1990-02-11', 'Tigres UANL', 'Mexiko'),
(3220, 32, 'A', 23, 'Gallardo', 'Jesús', '', 18, 0, '1994-08-15', 'UNAM Pumas', 'Mexiko'),
(3221, 32, 'A', 17, 'Corona', 'Jesús', '', 32, 7, '1993-01-06', 'FC Porto', 'Portugal'),
(3222, 32, 'A', 11, 'Vela', 'Carlos', '', 64, 18, '1989-03-01', 'Los Angeles FC', 'USA'),
(3224, 32, 'A', 10, 'dos Santos', 'Giovani', '', 101, 18, '1989-05-11', 'Los Angeles Galaxy', 'USA'),
(3225, 32, 'A', 14, 'Hernandez', 'Javier', 'Chicharito', 100, 49, '1988-06-01', 'West Ham United', 'England'),
(3226, 32, 'A', 9, 'Jiménez', 'Raúl', '', 61, 13, '1991-05-05', 'Benfica Lissabon', 'Portugal'),
(3227, 32, 'A', 19, 'Peralta', 'Oribe', '', 63, 25, '1984-01-12', 'CF América', 'Mexiko');

-- 23 Schweden = ID 48
REPLACE INTO `{prefix}spieler` (`id`, `team`, `position`, `nummer`, `name`, `firstname`, `nickname`, `caps`, `goals`, `birthdate`, `club`, `clubcountry`) VALUES
(4800, 48, 'T', 1, 'Olsen', 'Robin', '', 17, 0, '1990-01-08', 'FC Kopenhagen', 'Dänemark'),
(4801, 48, 'V', 2, 'Lustig', 'Mikael', '', 64, 6, '1986-12-13', 'Celtic Glasgow', 'Schottland'),
(4802, 48, 'V', 3, 'Lindelof', 'Victor', '', 20, 1, '1994-07-17', 'Manchester United', 'England'),
(4803, 48, 'V', 4, 'Granqvist', 'Andreas', '', 71, 6, '1985-04-16', 'FC Krasnodar', 'Russland'),
(4804, 48, 'V', 5, 'Olsson', 'Martin', '', 43, 5, '1988-05-17', 'Swansea City', 'Wales'),
(4805, 48, 'V', 6, 'Augustinsson', 'Ludwig', '', 14, 0, '1994-04-21', 'SV Werder Bremen', 'Deutschland'),
(4806, 48, 'M', 7, 'Larsson', 'Sebastian', '', 98, 6, '1985-06-06', 'Hull City FC', 'England'),
(4807, 48, 'M', 8, 'Ekdal', 'Albin', '', 33, 0, '1989-07-28', 'Hamburger SV', 'Deutschland'),
(4808, 48, 'A', 9, 'Berg', 'Marcus', '', 55, 18, '1986-08-17', 'Al Ain FC', 'VAE'),
(4809, 48, 'A', 10, 'Forsberg', 'Emil', '', 35, 6, '1991-10-23', 'RB Leipzig', 'Deutschland'),
(4810, 48, 'A', 11, 'Guidetti', 'John', '', 20, 1, '1992-04-15', 'Deportivo Alavés', 'Spanien'),
(4811, 48, 'T', 12, 'Johnsson', 'Karl-Johan', '', 5, 0, '1990-01-28', 'EA Guingamp', 'Frankreich'),
(4812, 48, 'M', 13, 'Svensson', 'Gustav', '', 12, 0, '1987-02-07', 'Seattle Sounders FC', 'USA'),
(4813, 48, 'V', 14, 'Helander', 'Filip', '', 4, 0, '1993-04-22', 'Bologna FC', 'Italien'),
(4814, 48, 'M', 15, 'Hiljemark', 'Oscar', '', 21, 2, '1992-06-28', 'Genoa CFC', 'Italien'),
(4815, 48, 'V', 16, 'Krafth', 'Emil', '', 12, 0, '1994-08-02', 'Bologna FC', 'Italien'),
(4816, 48, 'M', 17, 'Claesson', 'Viktor', '', 20, 3, '1992-01-02', 'FC Krasnodar', 'Russland'),
(4817, 48, 'V', 18, 'Jansson', 'Pontus', '', 15, 0, '1991-02-13', 'Leeds United FC', 'England'),
(4818, 48, 'M', 19, 'Rohden', 'Marcus', '', 10, 1, '1991-05-11', 'FC Crotone', 'Italien'),
(4819, 48, 'A', 20, 'Toivonen', 'Ola', '', 57, 13, '1986-07-03', 'Toulouse FC', 'Frankreich'),
(4820, 48, 'A', 21, 'Durmaz', 'Jimmy', '', 45, 3, '1989-03-22', 'Toulouse FC', 'Frankreich'),
(4821, 48, 'A', 22, 'Thelin', 'Isaac Kiese', '', 19, 2, '1992-06-24', 'KV Waasland-Beveren', 'Belgien'),
(4822, 48, 'T', 23, 'Nordfeldt', 'Kristoffer', '', 8, 0, '1989-06-23', 'Swansea City', 'Wales');

-- 24 Südkorea = ID 20
REPLACE INTO `{prefix}spieler` (`id`, `team`, `position`, `nummer`, `name`, `firstname`, `nickname`, `caps`, `goals`, `birthdate`, `club`, `clubcountry`) VALUES
(2000, 20, 'T', 1, 'Kim', 'Seunggyu', '', 31, 0, '1990-09-30', 'Vissel Kobe', 'Japan'),
(2001, 20, 'V', 2, 'Lee', 'Yong', '', 25, 0, '1986-12-24', 'Jeonbuk Hyundai', 'Korea'),
(2002, 20, 'V', 3, 'Jung', 'Seunghyun', '', 5, 0, '1994-04-03', 'Sagan Tosu FC', 'Japan'),
(2003, 20, 'V', 4, 'Oh', 'Bansuk', '', 1, 0, '1988-05-20', 'Jeju United', 'Korea'),
(2004, 20, 'V', 5, 'Yun', 'Youngsun', '', 4, 0, '1988-10-04', 'Seongnam FC', 'Korea'),
(2005, 20, 'V', 6, 'Park', 'Jooho', '', 35, 0, '1987-01-16', 'Ulsan Hyundai FC', 'Korea'),
(2006, 20, 'A', 7, 'Son', 'Heungmin', '', 64, 21, '1992-07-08', 'Tottenham Hotspur FC', 'England'),
(2007, 20, 'M', 8, 'Ju', 'Sejong', '', 9, 1, '1990-10-30', 'Asan Mugunghwa FC', 'Korea'),
(2008, 20, 'A', 9, 'Kim', 'Shinwook', '', 47, 10, '1988-04-14', 'Jeonbuk Hyundai', 'Korea'),
(2009, 20, 'A', 10, 'Lee', 'Seungwoo', '', 1, 0, '1998-01-06', 'Hellas Verona FC', 'Italien'),
(2010, 20, 'A', 11, 'Hwang', 'Heechan', '', 12, 2, '1996-01-26', 'FC Red Bull Salzburg', 'Österreich'),
(2011, 20, 'M', 12, 'Kim', 'Minwoo', '', 17, 1, '1990-02-25', 'Sangju Sangmu FC', 'Korea'),
(2012, 20, 'M', 13, 'Koo', 'Jacheol', '', 65, 19, '1989-02-27', 'FC Augsburg', 'Deutschland'),
(2013, 20, 'V', 14, 'Hong', 'Chul', '', 14, 0, '1990-09-17', 'Sangju Sangmu FC', 'Korea'),
(2014, 20, 'M', 15, 'Jung', 'Wooyoung', '', 27, 1, '1989-12-14', 'Vissel Kobe', 'Japan'),
(2015, 20, 'M', 16, 'Ki', 'Sungyueng', '', 99, 10, '1989-01-24', 'Swansea City AFC', 'Wales'),
(2016, 20, 'M', 17, 'Lee', 'Jaesung', '', 32, 5, '1992-08-10', 'Jeonbuk Hyundai', 'Korea'),
(2017, 20, 'M', 18, 'Moon', 'Seonmin', '', 1, 1, '1992-06-09', 'Incheon United FC', 'Korea'),
(2018, 20, 'V', 19, 'Kim', 'Younggwon', '', 51, 2, '1990-02-27', 'Guangzhou Evergrande FC', 'China'),
(2019, 20, 'V', 20, 'Jang', 'Hyunsoo', '', 49, 3, '1991-09-28', 'FC Tokyo', 'Japan'),
(2020, 20, 'T', 21, 'Kim', 'Jinhyeon', '', 14, 0, '1987-07-06', 'Cerezo Osaka', 'Japan'),
(2021, 20, 'M', 22, 'Go', 'Yohan', '', 19, 0, '1988-03-10', 'FC Seoul', 'Korea'),
(2022, 20, 'T', 23, 'Jo', 'Hyeonwoo', '', 5, 0, '1991-09-25', 'Daegu FC', 'Korea');

-- 25 Belgien = ID 39
REPLACE INTO `{prefix}spieler` (`id`, `team`, `position`, `nummer`, `name`, `firstname`, `nickname`, `caps`, `goals`, `birthdate`, `club`, `clubcountry`) VALUES
(3900, 39, 'T', 1, 'Courtois', 'Thibaut', '', 56, 0, '1992-05-11', 'FC Chelsea', 'England'),
(3901, 39, 'T', 12, 'Mignolet', 'Simon', '', 21, 0, '1988-03-06', 'FC Liverpool', 'England'),
(3902, 39, 'T', 13, 'Casteels', 'Koen', '', 0, 0, '1992-05-25', 'VfL Wolfsburg', 'Deutschland'),
(3904, 39, 'V', 2, 'Alderweireld', 'Toby', '', 75, 3, '1989-03-02', 'Tottenham Hotspur', 'England'),
(3905, 39, 'V', 5, 'Vertonghen', 'Jan', '', 100, 8, '1987-04-24', 'Tottenham Hotspur', 'England'),
(3906, 39, 'V', 4, 'Kompany', 'Vincent', '', 77, 4, '1986-04-10', 'Manchester City', 'England'),
(3908, 39, 'V', 3, 'Vermaelen', 'Thomas', '', 66, 1, '1985-11-14', 'FC Barcelona', 'Spanien'),
(3909, 39, 'V', 20, 'Boyata', 'Dedryck', '', 5, 0, '1990-11-28', 'Celtic Glasgow', 'Schottland'),
(3912, 39, 'V', 15, 'Meunier', 'Thomas', '', 23, 5, '1991-09-12', 'FC Paris Saint-Germain', 'Frankreich'),
(3913, 39, 'M', 23, 'Dendoncker', 'Leander', '', 4, 0, '1995-04-15', 'RSC Anderlecht', 'Belgien'),
(3914, 39, 'M', 17, 'Tielemans', 'Youri', '', 8, 0, '1997-05-07', 'AS Monaco', 'Frankreich'),
(3915, 39, 'M', 19, 'Dembélé', 'Mousa', '', 75, 5, '1987-07-16', 'Tottenham Hotspur', 'England'),
(3916, 39, 'M', 6, 'Witsel', 'Axel', '', 88, 9, '1989-01-12', 'Tianjin Quanjian', 'China'),
(3917, 39, 'M', 8, 'Fellaini', 'Marouane', '', 81, 16, '1987-11-22', 'Manchester United', 'England'),
(3918, 39, 'M', 7, 'De Bruyne', 'Kevin', '', 60, 14, '1991-06-28', 'Manchester City', 'England'),
(3919, 39, 'A', 10, 'Hazard', 'Eden', '', 84, 21, '1991-07-01', 'FC Chelsea', 'England'),
(3920, 39, 'A', 11, 'Carrasco', 'Yannick', '', 24, 5, '1993-09-04', 'Dalian Yifang', 'China'),
(3921, 39, 'A', 16, 'Hazard', 'Thorgan', '', 9, 1, '1993-03-29', 'Bor. Mönchengladbach', 'Deutschland'),
(3922, 39, 'A', 22, 'Chadli', 'Nacer', '', 43, 5, '1989-08-02', 'West Bromwich Albion', 'England'),
(3923, 39, 'A', 18, 'Januzaj', 'Adnan', '', 7, 0, '1995-02-05', 'Real Sociedad San Sebastián', 'Spanien'),
(3924, 39, 'A', 9, 'Lukaku', 'Romelu', '', 67, 33, '1993-05-13', 'Manchester United', 'England'),
(3925, 39, 'A', 21, 'Batshuayi', 'Michy', '', 14, 6, '1993-02-10', 'Borussia Dortmund', 'Deutschland'),
(3926, 39, 'A', 14, 'Mertens', 'Dries', '', 67, 13, '1987-05-06', 'SSC Neapel', 'Italien');

-- 26 Panama = ID 81
REPLACE INTO `{prefix}spieler` (`id`, `team`, `position`, `nummer`, `name`, `firstname`, `nickname`, `caps`, `goals`, `birthdate`, `club`, `clubcountry`) VALUES
(8100, 81, 'T', 1, 'Penedo', 'Jaime', '', 130, 0, '1981-09-26', 'Dinamo Bukarest', 'Rumänien'),
(8101, 81, 'T', 12, 'Calderón', 'José', '', 31, 0, '1985-08-14', 'UD Universitario', 'Panama'),
(8102, 81, 'T', 22, 'Rodríguez', 'Álex', '', 6, 0, '1990-08-05', 'San Francisco FC', 'Panama'),
(8103, 81, 'V', 23, 'Baloy', 'Felipe', '', 99, 3, '1981-02-24', 'CSD Municipal', 'Guatemala'),
(8104, 81, 'V', 5, 'Torres', 'Román', '', 106, 10, '1986-03-20', 'Seattle Sounders FC', 'Vereinigte Staaten'),
(8105, 81, 'V', 13, 'Machado', 'Adolfo', '', 74, 1, '1985-02-14', 'Houston Dynamo', 'Vereinigte Staaten'),
(8106, 81, 'V', 3, 'Cummings', 'Hárold', '', 51, 0, '1992-03-01', 'San Jose Earthquakes', 'Vereinigte Staaten'),
(8107, 81, 'V', 4, 'Escobar', 'Fidel', '', 21, 1, '1995-01-09', 'New York Red Bulls', 'Vereinigte Staaten'),
(8108, 81, 'V', 17, 'Ovalle', 'Luis', '', 24, 0, '1988-09-07', 'CD Olimpia', 'Honduras'),
(8109, 81, 'V', 15, 'Davis', 'Éric', '', 37, 0, '1991-03-31', 'DAC Dunajska Streda', 'Tschechoslowakische Republik'),
(8110, 81, 'V', 2, 'Murillo', 'Michael', '', 21, 2, '1996-02-11', 'New York Red Bulls', 'Vereinigte Staaten'),
(8111, 81, 'M', 20, 'Godoy', 'Aníbal', '', 86, 1, '1990-02-10', 'San Jose Earthquakes', 'Vereinigte Staaten'),
(8112, 81, 'M', 6, 'Gómez', 'Gabriel', '', 141, 12, '1984-05-29', 'Atlético Bucaramanga', 'Kolumbien'),
(8113, 81, 'M', 11, 'Cooper', 'Armando', '', 98, 7, '1987-11-26', 'Club Universidad de Chile', 'Chile'),
(8115, 81, 'M', 21, 'Rodríguez', 'José Luis', '', 0, 0, '1998-06-19', 'KAA Gent Reserve', 'Belgien'),
(8116, 81, 'M', 8, 'Bárcenas', 'Edgar', '', 27, 0, '1993-10-23', 'Cafetaleros de Tapachula', 'Mexiko'),
(8117, 81, 'A', 10, 'Díaz', 'Ismael', '', 10, 2, '1997-05-12', 'Deportivo de La Coruña B', 'Spanien'),
(8118, 81, 'A', 14, 'Pimentel', 'Valentin', '', 21, 1, '1991-05-30', 'CD Plaza Amador', 'Panama'),
(8119, 81, 'A', 7, 'Pérez', 'Blas', '', 115, 40, '1981-03-13', 'CSD Municipal', 'Guatemala'),
(8120, 81, 'A', 9, 'Torres', 'Gabriel', '', 71, 15, '1988-10-31', 'Huachipato FC', 'Chile'),
(8121, 81, 'A', 16, 'Arroyo', 'Abdiel', '', 33, 5, '1993-12-13', 'LD Alajuelens', 'Costa Rica'),
(8122, 81, 'A', 18, 'Tejada', 'Luis', '', 104, 42, '1982-03-28', 'Sport Boys Callao', 'Peru'),
(8123, 81, 'M', 19, 'Ávila', 'Ricardo', '', 5, 0, '1997-02-04', 'KAA Gent Reserve', 'Belgien');

-- 27 Tunesien = ID 66
REPLACE INTO `{prefix}spieler` (`id`, `team`, `position`, `nummer`, `name`, `firstname`, `nickname`, `caps`, `goals`, `birthdate`, `club`, `clubcountry`) VALUES
(6600, 66, 'T', 22, 'Hassen', 'Mouez', '', 3, 0, '1995-03-05', 'LB Châteauroux', 'Frankreich'),
(6601, 66, 'T', 1, 'Ben Mustapha', 'Farouk', '', 14, 0, '1989-07-01', 'Al-Shabab Riad', 'Saudi-Arabien'),
(6602, 66, 'T', 16, 'Mathlouthi', 'Aymen', 'Balbouli', 70, 0, '1984-09-14', 'Al-Batin', 'Saudi-Arabien'),
(6603, 66, 'V', 11, 'Bronn', 'Dylan', '', 4, 0, '1995-06-19', 'KAA Gent', 'Belgien'),
(6604, 66, 'V', 3, 'Benalouane', 'Yohan', '', 3, 0, '1987-03-28', 'Leicester City', 'England'),
(6605, 66, 'V', 4, 'Meriah', 'Yassine', '', 16, 1, '1993-07-02', 'Club Sportif Sfaxien', 'Tunesien'),
(6606, 66, 'V', 2, 'Ben Youssef', 'Syam', '', 43, 1, '1989-03-31', 'Kasimpasa', 'Türkei'),
(6607, 66, 'V', 6, 'Bedoui', 'Rami', '', 10, 0, '1990-01-19', 'Etoile Sportive du Sahel', 'Tunesien'),
(6608, 66, 'V', 5, 'Haddadi', 'Oussama', '', 8, 0, '1992-01-28', 'FCO Dijon', 'Frankreich'),
(6609, 66, 'V', 12, 'Maâloul', 'Ali', '', 48, 0, '1990-01-01', 'El Ahly Kairo', 'Ägypten'),
(6610, 66, 'V', 21, 'Nagguez', 'Hamdi', '', 17, 0, '1992-10-28', 'Zamalek SC', 'Ägypten'),
(6611, 66, 'M', 17, 'Skhiri', 'Ellyes', '', 4, 0, '1995-05-10', 'HSC Montpellier', 'Frankreich'),
(6612, 66, 'M', 14, 'Ben Amor', 'Mohamed Amine', '', 26, 2, '1992-05-03', 'Al-Ahli Dschidda', 'Saudi-Arabien'),
(6613, 66, 'M', 15, 'Khalil', 'Ahmed', '', 2, 0, '1994-12-21', 'Club Africain Tunis', 'Tunesien'),
(6614, 66, 'M', 13, 'Sassi', 'Ferjani', '', 40, 3, '1992-03-18', 'Al-Nasr Riad', 'Saudi-Arabien'),
(6615, 66, 'M', 20, 'Chaalali', 'Ghaylène', '', 7, 1, '1994-02-28', 'Esperance Tunis', 'Tunesien'),
(6616, 66, 'M', 10, 'Khazri', 'Wahbi', '', 37, 12, '1991-02-08', 'FC Stade Rennes', 'Frankreich'),
(6617, 66, 'M', 7, 'Khaoui', 'Saîf-Eddine', '', 4, 0, '1995-04-27', 'ES Troyes AC', 'Frankreich'),
(6618, 66, 'A', 23, 'Sliti', 'Naïm', '', 19, 3, '1992-07-27', 'FCO Dijon', 'Frankreich'),
(6619, 66, 'A', 18, 'Srarfi', 'Bassem', '', 4, 0, '1997-06-25', 'OGC Nizza', 'Frankreich'),
(6620, 66, 'A', 8, 'Ben Youssef', 'Fakhreddine', '', 38, 5, '1991-06-23', 'Al-Ettifaq', 'Saudi-Arabien'),
(6621, 66, 'A', 9, 'Badri', 'Anice', '', 9, 3, '1990-09-18', 'Esperance Tunis', 'Tunesien'),
(6622, 66, 'A', 19, 'Khalifa', 'Saber', '', 44, 7, '1986-10-14', 'Club Africain Tunis', 'Tunesien');

-- 28 England = ID 24
REPLACE INTO `{prefix}spieler` (`id`, `team`, `position`, `nummer`, `name`, `firstname`, `nickname`, `caps`, `goals`, `birthdate`, `club`, `clubcountry`) VALUES
(2400, 24, 'T', 1, 'Pickford', 'Jordan', '', 3, 0, '1994-03-07', 'FC Everton', 'England'),
(2401, 24, 'T', 13, 'Butland', 'Jack', '', 7, 0, '1993-03-10', 'Stoke City', 'England'),
(2402, 24, 'T', 23, 'Pope', 'Nick', '', 0, 0, '1992-04-19', 'FC Burnley', 'England'),
(2403, 24, 'V', 5, 'Stones', 'John', '', 25, 0, '1994-05-28', 'Manchester City', 'England'),
(2404, 24, 'V', 6, 'Maguire', 'Harry', '', 4, 0, '1993-03-05', 'Leicester City', 'England'),
(2405, 24, 'V', 16, 'Jones', 'Phil', '', 24, 0, '1992-02-21', 'Manchester United', 'England'),
(2406, 24, 'V', 15, 'Cahill', 'Gary', '', 59, 5, '1985-12-19', 'FC Chelsea', 'England'),
(2407, 24, 'V', 3, 'Rose', 'Danny', '', 17, 0, '1990-07-02', 'Tottenham Hotspur', 'England'),
(2408, 24, 'V', 2, 'Walker', 'Kyle', '', 35, 0, '1990-05-28', 'Manchester City', 'England'),
(2409, 24, 'V', 22, 'Alexander-Arnold', 'Trent', '', 0, 0, '1998-10-07', 'FC Liverpool', 'England'),
(2410, 24, 'V', 12, 'Trippier', 'Kieran', '', 6, 0, '1990-09-19', 'Tottenham Hotspur', 'England'),
(2411, 24, 'M', 4, 'Dier', 'Eric', '', 26, 3, '1994-01-15', 'Tottenham Hotspur', 'England'),
(2412, 24, 'M', 8, 'Henderson', 'Jordan', '', 38, 0, '1990-06-17', 'FC Liverpool', 'England'),
(2413, 24, 'M', 17, 'Delph', 'Fabian', '', 10, 0, '1989-11-21', 'Manchester City', 'England'),
(2414, 24, 'M', 21, 'Loftus-Cheek', 'Ruben', '', 3, 0, '1996-01-23', 'FC Chelsea', 'England'),
(2415, 24, 'M', 18, 'Young', 'Ashley', '', 34, 7, '1985-07-09', 'Manchester United', 'England'),
(2416, 24, 'M', 20, 'Alli', 'Dele', '', 24, 2, '1996-04-11', 'Tottenham Hotspur', 'England'),
(2417, 24, 'A', 7, 'Lingard', 'Jesse', '', 11, 1, '1992-12-15', 'Manchester United', 'England'),
(2418, 24, 'A', 10, 'Sterling', 'Raheem', '', 38, 2, '1994-12-08', 'Manchester City', 'England'),
(2419, 24, 'A', 9, 'Kane', 'Harry', '', 24, 13, '1993-07-28', 'Tottenham Hotspur', 'England'),
(2420, 24, 'A', 19, 'Rashford', 'Marcus', '', 18, 2, '1997-10-31', 'Manchester United', 'England'),
(2421, 24, 'A', 11, 'Vardy', 'Jamie', '', 21, 7, '1987-01-11', 'Leicester City', 'England'),
(2422, 24, 'A', 14, 'Welbeck', 'Danny', '', 38, 15, '1990-11-26', 'FC Arsenal', 'England');

-- 29 Polen = ID 51
REPLACE INTO `{prefix}spieler` (`id`, `team`, `position`, `nummer`, `name`, `firstname`, `nickname`, `caps`, `goals`, `birthdate`, `club`, `clubcountry`) VALUES
(5100, 51, 'T', 1, 'Szczesny', 'Wojciech', '', 33, 0, '1990-04-18', 'Juventus Turin', 'Italien'),
(5102, 51, 'T', 22, 'Fabianski', 'Lukasz', '', 43, 0, '1985-04-18', 'Swansea City', 'England'),
(5103, 51, 'T', 12, 'Bialkowski', 'Bartosz', '', 1, 0, '1987-07-06', 'Ipswich Town', 'England'),
(5105, 51, 'V', 5, 'Bednarek', 'Jan', '', 1, 0, '1996-04-12', 'FC Southampton', 'England'),
(5106, 51, 'V', 2, 'Pazdan', 'Michal', '', 31, 0, '1987-09-21', 'Legia Warschau', 'Polen'),
(5109, 51, 'V', 4, 'Cionek', 'Thiago', '', 17, 0, '1986-04-21', 'SPAL 2013', 'Italien'),
(5110, 51, 'V', 18, 'Bereszynski', 'Bartosz', '', 6, 0, '1992-07-12', 'UC Sampdoria', 'Italien'),
(5111, 51, 'V', 20, 'Piszczek', 'Lukasz', '', 61, 3, '1985-06-03', 'Borussia Dortmund', 'Deutschland'),
(5112, 51, 'V', 3, 'Jedrzejczyk', 'Artur', '', 35, 3, '1987-11-04', 'Legia Warschau', 'Polen'),
(5114, 51, 'M', 10, 'Krychowiak', 'Grzegorz', '', 49, 2, '1990-01-29', 'West Bromwich Albion', 'England'),
(5115, 51, 'M', 6, 'Goralski', 'Jacek', '', 3, 0, '1992-09-21', 'PFK Ludogorets Razgrad', 'Bulgarien'),
(5116, 51, 'M', 19, 'Zielinski', 'Piotr', '', 31, 4, '1994-05-20', 'SSC Neapel', 'Italien'),
(5117, 51, 'M', 8, 'Linetty', 'Karol', '', 19, 1, '1995-02-02', 'Sampdoria Genua', 'Italien'),
(5121, 51, 'M', 16, 'Blaszczykowski', 'Jakub', '', 97, 19, '1985-12-14', 'VfL Wolfsburg', 'Deutschland'),
(5122, 51, 'M', 13, 'Rybus', 'Maciej', '', 49, 2, '1989-08-19', 'Lokomotiv Moskau', 'Russland'),
(5123, 51, 'A', 21, 'Kurzawa', 'Rafal', '', 3, 0, '1993-01-29', 'Górnik Zabrze', 'Polen'),
(5124, 51, 'A', 17, 'Peszko', 'Slawomir', '', 43, 2, '1985-02-19', 'Lechia Gdansk', 'Polen'),
(5125, 51, 'A', 11, 'Grosicki', 'Kamil', '', 56, 12, '1988-06-08', 'Hull City', 'England'),
(5127, 51, 'A', 9, 'Lewandowski', 'Robert', '', 93, 52, '1988-08-21', 'FC Bayern München', 'Deutschland'),
(5128, 51, 'A', 7, 'Milik', 'Arkadiusz', '', 38, 12, '1994-02-28', 'SSC Neapel', 'Italien'),
(5129, 51, 'A', 14, 'Teodorczyk', 'Lukasz', '', 15, 4, '1991-06-03', 'RSC Anderlecht', 'Belgien'),
(5130, 51, 'A', 23, 'Kownacki', 'Dawid', '', 1, 0, '1997-03-14', 'Sampdoria Genua', 'Italien'),
(5132, 51, 'V', 15, 'Glik', 'Kamil', '', 15, 0, '1992-01-15', 'AS Monaco', 'Frankreich');

-- 30 Senegal = ID 75
REPLACE INTO `{prefix}spieler` (`id`, `team`, `position`, `nummer`, `name`, `firstname`, `nickname`, `caps`, `goals`, `birthdate`, `club`, `clubcountry`) VALUES
(7500, 75, 'T', 23, 'Gomis', 'Alfred', '', 1, 0, '1993-09-05', 'SPAL 2013', 'Italien'),
(7501, 75, 'T', 1, 'Diallo', 'Abdoulaye', '', 16, 0, '1992-03-30', 'FC Stade Rennes', 'Frankreich'),
(7502, 75, 'T', 16, 'N\'Diaye', 'Khadim', '', 24, 0, '1985-04-05', 'Horoya AC', 'Guinea'),
(7503, 75, 'V', 3, 'Koulibaly', 'Kalidou', '', 23, 0, '1991-06-20', 'SSC Neapel', 'Italien'),
(7504, 75, 'V', 6, 'Sané', 'Salif', '', 19, 0, '1990-08-25', 'Hannover 96', 'Deutschland'),
(7505, 75, 'V', 4, 'Kara Mbodj', 'Serigne Modou', 'Kara', 51, 5, '1989-11-22', 'RSC Anderlecht', 'Belgien'),
(7506, 75, 'V', 2, 'Ciss', 'Saliou', '', 17, 0, '1989-09-15', 'Valenciennes FC', 'Frankreich'),
(7507, 75, 'V', 12, 'Sabaly', 'Youssouf', '', 3, 0, '1993-03-05', 'FC Girondins Bordeaux', 'Frankreich'),
(7508, 75, 'V', 21, 'Gassama', 'Lamine', '', 34, 0, '1989-10-20', 'Alanyaspor', 'Türkei'),
(7509, 75, 'V', 22, 'Wagué', 'Moussa', '', 8, 0, '1998-10-04', 'KAS Eupen', 'Belgien'),
(7510, 75, 'M', 8, 'Kouyaté', 'Cheikhou', '', 46, 2, '1989-12-21', 'West Ham United', 'England'),
(7511, 75, 'M', 13, 'N\'Diaye', 'Alfred', '', 18, 1, '1990-03-06', 'Wolverhampton Wanderers', 'England'),
(7512, 75, 'M', 5, 'Gueye', 'Idrissa', '', 58, 1, '1989-09-26', 'FC Everton', 'England'),
(7513, 75, 'M', 17, 'Ndiaye', 'Pape Alioune', '', 17, 1, '1990-10-27', 'Stoke City', 'England'),
(7514, 75, 'M', 11, 'N\'Doye', 'Cheikh', '', 23, 3, '1986-03-29', 'Birmingham City', 'England'),
(7515, 75, 'A', 10, 'Mané', 'Sadio', '', 51, 14, '1992-04-10', 'FC Liverpool', 'England'),
(7516, 75, 'A', 20, 'Baldé', 'Keita', '', 16, 3, '1995-03-08', 'AS Monaco', 'Frankreich'),
(7517, 75, 'A', 18, 'Sarr', 'Ismaïla', '', 13, 2, '1998-02-25', 'FC Stade Rennes', 'Frankreich'),
(7518, 75, 'A', 19, 'Niang', 'M\'Baye', '', 4, 0, '1994-12-19', 'FC Turin', 'Italien'),
(7519, 75, 'A', 15, 'Sakho', 'Diafra', '', 9, 3, '1989-12-24', 'FC Stade Rennes', 'Frankreich'),
(7520, 75, 'A', 9, 'Diouf', 'Mame', '', 46, 10, '1987-12-16', 'Stoke City', 'England'),
(7521, 75, 'A', 14, 'Konaté', 'Moussa', '', 26, 9, '1993-04-03', 'SC Amiens', 'Frankreich'),
(7522, 75, 'A', 7, 'Sow', 'Moussa', '', 50, 18, '1986-01-19', 'Bursaspor', 'Türkei');

-- 31 Kolumbien = ID 33
REPLACE INTO `{prefix}spieler` (`id`, `team`, `position`, `nummer`, `name`, `firstname`, `nickname`, `caps`, `goals`, `birthdate`, `club`, `clubcountry`) VALUES
(3300, 33, 'T', 1, 'Ospina', 'David', '', 83, 0, '1988-08-31', 'FC Arsenal', 'England'),
(3302, 33, 'T', 12, 'Vargas', 'Camilo', '', 5, 0, '1989-03-09', 'Deportivo Cali', 'Kolumbien'),
(3303, 33, 'T', 22, 'Cuadrado', 'José', '', 1, 0, '1985-06-01', 'Once Caldas', 'Kolumbien'),
(3304, 33, 'V', 23, 'Sánchez', 'Davinson', '', 7, 0, '1996-06-12', 'Tottenham Hotspur', 'England'),
(3305, 33, 'V', 13, 'Mina', 'Yerry', '', 10, 3, '1994-09-23', 'FC Barcelona', 'Spanien'),
(3307, 33, 'V', 3, 'Murillo', 'Óscar', '', 11, 0, '1988-04-18', 'CF Pachuca', 'Mexiko'),
(3308, 33, 'V', 2, 'Zapata', 'Cristián', '', 54, 2, '1986-09-30', 'AC Mailand', 'Italien'),
(3311, 33, 'V', 17, 'Mojica', 'Johan', '', 2, 1, '1992-08-12', 'FC Girona', 'Spanien'),
(3313, 33, 'V', 4, 'Arias', 'Santiago', '', 38, 0, '1992-01-13', 'PSV Eindhoven', 'Niederlande'),
(3315, 33, 'M', 5, 'Barrios', 'Wilmar', '', 8, 0, '1993-10-16', 'Club Atlético Boca Juniors', 'Argentinien'),
(3317, 33, 'M', 6, 'Sánchez', 'Carlos', '', 83, 0, '1986-02-06', 'Espanyol Barcelona', 'Spanien'),
(3318, 33, 'M', 16, 'Lerma', 'Jefferson', '', 2, 0, '1994-10-25', 'UD Levante', 'Spanien'),
(3319, 33, 'M', 8, 'Aguilar', 'Abel', '', 68, 7, '1985-01-06', 'Deportivo Cali', 'Kolumbien'),
(3321, 33, 'M', 15, 'Uribe', 'Mateus', '', 5, 0, '1991-03-21', 'CF América', 'Mexiko'),
(3322, 33, 'M', 10, 'Rodríguez', 'James', '', 61, 21, '1991-07-12', 'FC Bayern München', 'Deutschland'),
(3324, 33, 'M', 20, 'Quintero', 'Juan', '', 13, 1, '1993-01-18', 'Club Atlético River Plate', 'Argentinien'),
(3325, 33, 'A', 21, 'Izquierdo', 'José', '', 2, 1, '1992-07-07', 'Brighton & Hove Albion', 'England'),
(3327, 33, 'A', 11, 'Cuadrado', 'Juan', '', 69, 7, '1988-05-26', 'Juventus Turin', 'Italien'),
(3331, 33, 'A', 9, 'García Zárate', 'Radamel Falcao', 'Falcao', 70, 28, '1986-02-10', 'AS Monaco', 'Frankreich'),
(3332, 33, 'A', 14, 'Muriel', 'Luis', '', 17, 1, '1991-04-16', 'FC Sevilla', 'Spanien'),
(3333, 33, 'A', 7, 'Bacca', 'Carlos', '', 43, 14, '1986-09-08', 'FC Villarreal', 'Spanien'),
(3334, 33, 'A', 19, 'Borja', 'Miguel', '', 5, 2, '1993-01-26', 'SE Palmeiras São Paulo', 'Brasilien'),
(3335, 33, 'V', 18, 'Díaz', 'Farid', '', 13, 0, '1983-07-20', 'Olimpia Asunción', 'Paraguay');

-- 32 Japan = ID 19
REPLACE INTO `{prefix}spieler` (`id`, `team`, `position`, `nummer`, `name`, `firstname`, `nickname`, `caps`, `goals`, `birthdate`, `club`, `clubcountry`) VALUES
(1900, 19, 'T', 23, 'Nakamura', 'Kosuke', '', 3, 0, '1995-02-27', 'Kashiwa Reysol', 'Japan'),
(1901, 19, 'T', 12, 'Higashiguchi', 'Masaaki', '', 4, 0, '1986-05-12', 'Gamba Osaka', 'Japan'),
(1902, 19, 'T', 1, 'Kawashima', 'Eiji', '', 83, 0, '1983-03-20', 'FC Metz', 'Frankreich'),
(1903, 19, 'V', 22, 'Yoshida', 'Maya', '', 81, 10, '1988-08-24', 'FC Southampton', 'England'),
(1904, 19, 'V', 3, 'Shoji', 'Gen', '', 11, 1, '1992-12-11', 'Kashima Antlers', 'Japan'),
(1905, 19, 'V', 20, 'Makino', 'Tomoaki', '', 31, 4, '1987-05-11', 'Urawa Red Diamonds', 'Japan'),
(1906, 19, 'V', 6, 'Endo', 'Wataru', '', 11, 0, '1993-02-09', 'Urawa Red Diamonds', 'Japan'),
(1907, 19, 'V', 2, 'Ueda', 'Naomichi', '', 3, 0, '1994-10-24', 'Kashima Antlers', 'Japan'),
(1908, 19, 'V', 5, 'Nagatomo', 'Yuto', '', 104, 3, '1986-09-12', 'Galatasaray Istanbul', 'Türkei'),
(1909, 19, 'V', 19, 'Sakai', 'Hiroki', '', 41, 0, '1990-04-12', 'Olympique Marseille', 'Frankreich'),
(1910, 19, 'V', 21, 'Sakai', 'Gotoku', '', 39, 0, '1991-03-14', 'Hamburger SV', 'Deutschland'),
(1911, 19, 'M', 16, 'Yamaguchi', 'Hotaru', '', 41, 2, '1990-10-06', 'Cerezo Osaka', 'Japan'),
(1912, 19, 'M', 17, 'Hasebe', 'Makoto', '', 109, 2, '1984-01-18', 'Eintracht Frankfurt', 'Deutschland'),
(1913, 19, 'M', 7, 'Shibasaki', 'Gaku', '', 16, 3, '1992-05-28', 'FC Getafe', 'Spanien'),
(1914, 19, 'M', 18, 'Oshima', 'Ryota', '', 4, 0, '1993-01-23', 'Kawasaki Frontale', 'Japan'),
(1915, 19, 'M', 10, 'Kagawa', 'Shinji', '', 90, 29, '1989-03-17', 'Borussia Dortmund', 'Deutschland'),
(1916, 19, 'A', 14, 'Inui', 'Takashi', '', 25, 2, '1988-06-02', 'SD Eibar', 'Spanien'),
(1917, 19, 'A', 8, 'Haraguchi', 'Genki', '', 31, 6, '1991-05-09', 'Fortuna Düsseldorf', 'Deutschland'),
(1918, 19, 'A', 11, 'Usami', 'Takashi', '', 22, 3, '1992-05-06', 'Fortuna Düsseldorf', 'Deutschland'),
(1919, 19, 'A', 4, 'Honda', 'Keisuke', '', 94, 36, '1986-06-13', 'CF Pachuca', 'Mexiko'),
(1920, 19, 'A', 15, 'Osako', 'Yuya', '', 27, 7, '1990-05-18', '1.FC Köln', 'Deutschland'),
(1921, 19, 'A', 9, 'Okazaki', 'Shinji', '', 112, 50, '1986-04-16', 'Leicester City', 'England'),
(1922, 19, 'A', 13, 'Muto', 'Yoshinori', '', 22, 2, '1992-07-15', '1.FSV Mainz 05', 'Deutschland');