Hallo,
ich hab mal Tschechien fertig gemacht.
- -- 14 Tschechien = ID 42
- REPLACE INTO `{prefix}spieler` (`id`, `team`, `position`, `nummer`, `name`, `firstname`, `nickname`, `caps`, `goals`, `birthdate`, `club`, `clubcountry`) VALUES
- (4200, 42, 'T', '1', 'Tomáš', 'Vaclík', '', 36, 0, '1989-03-29', 'Sevilla FC', 'Spanien'),
- (4201, 42, 'T', '23', 'Jiří', 'Pavlenka', '', 13, 0, '1992-04-14', 'Werder Bremen', 'Deutschland'),
- (4202, 42, 'T', '16', 'Aleš', 'Mandous', '', 1, 0, '1992-04-21', 'Sigma Olomouc', 'Tschechien'),
- (4203, 42, 'V', '5', 'Vladimír', 'Coufal', '', 14, 1, '1992-08-22', 'West Ham United', 'England'),
- (4204, 42, 'V', '2', 'Pavel', 'Kadeřábek', '', 47, 3, '1992-04-25', '1899 Hoffenheim', 'Deutschland'),
- (4205, 42, 'V', '3', 'Ondřej', 'Čelůstka', '', 24, 2, '1989-06-18', 'Sparta Praha', 'Tschechien'),
- (4206, 42, 'V', '6', 'Tomáš', 'Kalas', '', 22, 2, '1993-05-15', 'Bristol City', 'England'),
- (4207, 42, 'V', '4', 'David', 'Zima', '', 1, 0, '2000-11-08', 'Slavia Praha', 'Tschechien'),
- (4208, 42, 'V', '18', 'Jan', 'Bořil', '', 21, 0, '1991-01-11', 'Slavia Praha', 'Tschechien'),
- (4209, 42, 'V', '17', 'Aleš', 'Matějů', '', 4, 0, '1996-06-03', 'Brescia Calcio', 'Italien'),
- (4210, 42, 'V', '24', 'Jakub', 'Brabec', '', 20, 1, '1996-04-17', 'Viktoria Plzeň', 'Tschechien'),
- (4211, 42, 'M', '12', 'Lukáš', 'Masopust', '', 20, 1, '1993-02-12', 'Slavia Praha', 'Tschechien'),
- (4212, 42, 'M', '8', 'Vladimír', 'Darida', '', 70, 8, '1990-08-08', 'Hertha BSC', 'Deutschland'),
- (4213, 42, 'M', '15', 'Tomáš', 'Souček', '', 33, 7, '1995-02-27', 'West Ham United', 'England'),
- (4214, 42, 'M', '7', 'Antonín', 'Barák', '', 18, 6, '1994-12-03', 'Hellas Verona', 'Italien'),
- (4215, 42, 'M', '21', 'Alex', 'Král', '', 16, 2, '1998-05-19', 'Spartak Moskva', 'Tschechien'),
- (4216, 42, 'M', '19', 'Tomáš', 'Holeš', '', 7, 1, '1993-03-31', 'Slavia Prah', 'Tschechien'),
- (4217, 42, 'M', '13', 'Petr', 'Ševčík', '', 6, 0, '1994-05-04', 'Slavia Prah', 'Tschechien'),
- (4218, 42, 'M', '14', 'Jakub', 'Jankto', '', 33, 4, '1993-04-07', 'Sampdoria', 'Italien'),
- (4219, 42, 'M', '22', 'Adam', 'Hložek', '', 2, 0, '2020-07-25', 'Sparta Praha', 'Tschechien'),
- (4220, 42, 'M', '25', 'Jakub', 'Pešek', '', 1, 1, '1993-06-24', 'Slovan Liberec', 'Tschechien'),
- (4221, 42, 'M', '26', 'Michal', 'Sadílek', '', 14, 0, '1999-05-31', 'Slovan Liberec', 'Tschechien'),
- (4222, 42, 'A', '9', 'Patrik', 'Schick', '', 24, 10, '1996-01-24', 'Bayer Leverkusen', 'Deutschland'),
- (4223, 42, 'A', '11', 'Michael', 'Krmenčík', '', 28, 9, '1993-03-15', 'PAOK Saloniki', 'Griechenland '),
- (4224, 42, 'A', '20', 'Matěj', 'Vydra', '', 38, 6, '1992-05-01', 'Burnley FC', 'England'),
- (4225, 42, 'A', '10', 'Tomáš', 'Pekhart', '', 21, 2, '1989-05-26', 'Legia Warszawa', 'Polen'),
- (4226, 42, 'C', '0', 'Jaroslav', 'Šilhavý', '', 0, 0, '1961-11-03', NULL, NULL);
Alles anzeigen