CREATE DATABASE IF NOT EXISTS `mundial18` /*!40100 DEFAULT CHARACTER SET latin1 */; USE `mundial18`; -- MySQL dump 10.13 Distrib 8.0.25, for Linux (x86_64) -- -- Host: 192.168.2.195 Database: mundial18 -- ------------------------------------------------------ -- Server version 5.5.68-MariaDB /*!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 */; /*!50503 SET NAMES utf8 */; /*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */; /*!40103 SET TIME_ZONE='+00:00' */; /*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */; /*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */; /*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */; /*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */; -- -- Table structure for table `estadio` -- DROP TABLE IF EXISTS `estadio`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `estadio` ( `idest` int(2) unsigned NOT NULL, `nombre` varchar(26) NOT NULL, `ciudad` varchar(16) NOT NULL, `capacidad` int(11) NOT NULL, PRIMARY KEY (`idest`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `estadio` -- LOCK TABLES `estadio` WRITE; /*!40000 ALTER TABLE `estadio` DISABLE KEYS */; INSERT INTO `estadio` VALUES (1,'Ekaterinburg Arena','Ekaterimburgo',33061),(2,'Estadio de San Petersburgo','San Petersburgo',64468),(3,'Fisht Stadium','Sochi',44287),(4,'Kaliningrad Stadium','Kaliningrado',33973),(5,'Kazan Arena','Kazan',42873),(6,'Luzhniki Stadium','Moscu',44190),(7,'Mordovia Arena','Saransk',41685),(8,'Nizhny Novgorod Stadium','Nizhni Novgorod',43319),(9,'Rostov Arena','Rostov del Don',43472),(10,'Samara Arena','Samara',41970),(11,'Spartak Stadium','Moscu',78011),(12,'Volgograd Arena','Volgogrado',43713); /*!40000 ALTER TABLE `estadio` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `gol` -- DROP TABLE IF EXISTS `gol`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `gol` ( `idgol` int(3) unsigned NOT NULL, `idpartido` int(2) unsigned NOT NULL, `minuto` int(3) unsigned NOT NULL, `idsel` int(2) unsigned NOT NULL, `numero` int(2) unsigned NOT NULL, `tipo` enum('penal','encontra','comun') DEFAULT NULL, PRIMARY KEY (`idgol`), KEY `fk_gol_p` (`idpartido`), KEY `fk_gol_j` (`idsel`,`numero`), CONSTRAINT `fk_gol_j` FOREIGN KEY (`idsel`, `numero`) REFERENCES `jugador` (`idsel`, `numero`), CONSTRAINT `fk_gol_p` FOREIGN KEY (`idpartido`) REFERENCES `partido` (`idpartido`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `gol` -- LOCK TABLES `gol` WRITE; /*!40000 ALTER TABLE `gol` DISABLE KEYS */; INSERT INTO `gol` VALUES (1,3,95,5,20,'encontra'),(2,5,81,11,16,'encontra'),(3,8,32,16,8,'encontra'),(4,16,37,30,4,'encontra'),(5,17,47,2,7,'encontra'),(6,33,23,1,6,'encontra'),(7,42,74,20,21,'encontra'),(8,44,93,23,1,'encontra'),(9,47,33,26,4,'encontra'),(10,51,12,1,4,'encontra'),(11,58,13,21,17,'encontra'),(12,64,18,14,17,'encontra'),(13,4,4,6,7,'penal'),(14,5,58,9,7,'penal'),(15,5,62,11,15,'penal'),(16,8,71,14,10,'penal'),(17,12,65,22,4,'penal'),(18,14,35,26,13,'penal'),(19,15,6,31,10,'penal'),(20,17,73,2,10,'penal'),(21,21,38,11,15,'penal'),(22,27,6,25,10,'penal'),(23,28,26,20,11,'penal'),(24,30,22,28,9,'penal'),(25,30,45,28,9,'penal'),(26,34,45,3,7,'penal'),(27,36,93,7,10,'penal'),(28,39,51,16,11,'penal'),(29,40,76,12,10,'penal'),(30,42,62,22,4,'penal'),(31,49,13,9,7,'penal'),(32,51,41,1,22,'penal'),(33,56,57,28,9,'penal'),(34,64,38,9,7,'penal'),(35,1,12,1,8,'comun'),(36,1,43,1,6,'comun'),(37,1,71,1,22,'comun'),(38,1,91,1,6,'comun'),(39,1,94,1,17,'comun'),(40,2,89,4,2,'comun'),(41,4,44,6,7,'comun'),(42,4,88,6,7,'comun'),(43,4,24,8,19,'comun'),(44,4,55,8,19,'comun'),(45,4,58,8,4,'comun'),(46,6,19,10,19,'comun'),(47,6,23,12,11,'comun'),(48,7,59,15,20,'comun'),(49,9,56,19,11,'comun'),(50,10,35,20,22,'comun'),(51,11,20,21,11,'comun'),(52,11,50,23,14,'comun'),(53,13,47,25,14,'comun'),(54,13,69,25,9,'comun'),(55,13,75,25,9,'comun'),(56,14,11,28,9,'comun'),(57,14,91,28,9,'comun'),(58,15,39,29,20,'comun'),(59,15,73,31,15,'comun'),(60,16,86,30,10,'comun'),(61,16,60,32,19,'comun'),(62,17,59,1,6,'comun'),(63,17,62,1,22,'comun'),(64,18,4,6,7,'comun'),(65,19,23,4,9,'comun'),(66,20,54,8,19,'comun'),(67,21,7,15,10,'comun'),(68,22,34,9,10,'comun'),(69,23,53,14,18,'comun'),(70,23,80,14,10,'comun'),(71,23,91,14,7,'comun'),(72,24,91,21,11,'comun'),(73,24,97,21,10,'comun'),(74,25,49,16,7,'comun'),(75,25,75,16,7,'comun'),(76,26,5,19,9,'comun'),(77,26,52,23,10,'comun'),(78,26,90,23,23,'comun'),(79,27,16,25,9,'comun'),(80,27,45,25,9,'comun'),(81,27,51,25,10,'comun'),(82,27,90,25,21,'comun'),(83,27,18,26,11,'comun'),(84,27,93,26,10,'comun'),(85,28,93,24,7,'comun'),(86,28,66,20,14,'comun'),(87,29,48,18,11,'comun'),(88,29,95,18,8,'comun'),(89,29,32,22,20,'comun'),(90,30,8,28,5,'comun'),(91,30,36,28,7,'comun'),(92,30,40,28,5,'comun'),(93,30,62,28,9,'comun'),(94,30,78,27,23,'comun'),(95,31,34,31,14,'comun'),(96,31,78,31,4,'comun'),(97,31,11,32,10,'comun'),(98,31,71,32,22,'comun'),(99,32,40,29,13,'comun'),(100,32,70,29,9,'comun'),(101,32,75,29,11,'comun'),(102,33,10,4,9,'comun'),(103,33,90,4,21,'comun'),(104,34,95,3,18,'comun'),(105,34,22,2,10,'comun'),(106,35,19,8,22,'comun'),(107,35,91,8,17,'comun'),(108,35,14,5,13,'comun'),(109,35,81,5,19,'comun'),(110,36,45,6,20,'comun'),(111,37,18,13,18,'comun'),(112,37,50,13,9,'comun'),(113,39,14,10,10,'comun'),(114,39,86,10,16,'comun'),(115,40,53,14,19,'comun'),(116,40,90,14,4,'comun'),(117,41,93,24,19,'comun'),(118,41,96,24,7,'comun'),(119,42,50,22,6,'comun'),(120,43,36,21,15,'comun'),(121,43,68,21,2,'comun'),(122,44,31,23,15,'comun'),(123,44,88,23,19,'comun'),(124,44,56,17,19,'comun'),(125,45,59,30,5,'comun'),(126,46,74,29,13,'comun'),(127,47,51,26,8,'comun'),(128,47,66,26,10,'comun'),(129,48,51,25,18,'comun'),(130,49,57,9,22,'comun'),(131,49,64,9,10,'comun'),(132,49,68,9,10,'comun'),(133,49,41,10,11,'comun'),(134,49,48,10,2,'comun'),(135,49,93,10,19,'comun'),(136,50,7,4,21,'comun'),(137,50,62,4,21,'comun'),(138,50,55,6,3,'comun'),(139,52,4,14,17,'comun'),(140,52,1,15,13,'comun'),(141,53,51,21,10,'comun'),(142,53,88,21,20,'comun'),(143,54,69,25,5,'comun'),(144,54,74,25,8,'comun'),(145,54,94,25,22,'comun'),(146,54,48,31,8,'comun'),(147,54,52,31,14,'comun'),(148,55,66,22,10,'comun'),(149,56,93,29,13,'comun'),(150,57,40,9,4,'comun'),(151,57,61,9,7,'comun'),(152,58,76,21,8,'comun'),(153,58,31,25,7,'comun'),(154,59,30,28,6,'comun'),(155,59,59,28,20,'comun'),(156,60,31,1,6,'comun'),(157,60,115,6,4,'comun'),(158,60,39,14,9,'comun'),(159,60,101,14,21,'comun'),(160,61,51,9,5,'comun'),(161,62,68,14,4,'comun'),(162,62,109,14,17,'comun'),(163,62,5,28,12,'comun'),(164,63,4,25,15,'comun'),(165,63,82,25,10,'comun'),(166,64,59,9,6,'comun'),(167,64,65,9,10,'comun'),(168,64,28,14,4,'comun'),(169,64,69,14,17,'comun'); /*!40000 ALTER TABLE `gol` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `jugador` -- DROP TABLE IF EXISTS `jugador`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `jugador` ( `idsel` int(3) unsigned NOT NULL, `numero` int(2) unsigned NOT NULL, `popular` varchar(23) NOT NULL, `fnac` date NOT NULL, `posicion` varchar(11) NOT NULL, `club` varchar(38) NOT NULL, `altura` smallint(6) NOT NULL, `peso` smallint(6) NOT NULL, `camiseta` varchar(16) NOT NULL, PRIMARY KEY (`idsel`,`numero`), CONSTRAINT `fk_seleccion_jugador` FOREIGN KEY (`idsel`) REFERENCES `seleccion` (`idsel`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `jugador` -- LOCK TABLES `jugador` WRITE; /*!40000 ALTER TABLE `jugador` DISABLE KEYS */; INSERT INTO `jugador` VALUES (1,1,'Igor Akinfeev','1986-04-08','arquero','CSKA Moscow (RUS)',185,83,'AKINFEEV'),(1,2,'Mario Fernandes','1990-09-19','defensa','CSKA Moscow (RUS)',187,79,'FERNANDES'),(1,3,'Ilya Kutepov','1993-07-29','defensa','FC Spartak Moscow (RUS)',190,82,'KUTEPOV'),(1,4,'Sergey Ignashevich','1979-07-14','defensa','CSKA Moscow (RUS)',186,84,'IGNASHEVICH'),(1,5,'Andrey Semenov','1989-03-24','defensa','FC Akhmat Grozny (RUS)',191,87,'SEMENOV'),(1,6,'Denis Cheryshev','1990-12-26','volante','Villarreal CF (ESP)',173,68,'CHERYSHEV'),(1,7,'Daler Kuziaev','1993-01-15','volante','FC Zenit St. Petersburg (RUS)',182,74,'KUZIAEV'),(1,8,'Iury Gazinsky','1989-07-20','volante','FC Krasnodar (RUS)',180,75,'GAZINSKII'),(1,9,'Alan Dzagoev','1990-06-17','volante','CSKA Moscow (RUS)',178,73,'DZAGOEV'),(1,10,'Fedor Smolov','1990-02-09','atacante','FC Krasnodar (RUS)',185,79,'SMOLOV'),(1,11,'Roman Zobnin','1994-02-11','volante','FC Spartak Moscow (RUS)',185,77,'ZOBNIN'),(1,12,'Andrei Lunev','1991-11-13','arquero','FC Zenit St. Petersburg (RUS)',189,80,'LUNEV'),(1,13,'Fedor Kudriashov','1987-04-05','defensa','FC Rubin Kazan (RUS)',187,78,'KUDRIASHOV'),(1,14,'Vladimir Granat','1987-05-22','defensa','FC Rubin Kazan (RUS)',184,80,'GRANAT'),(1,15,'Alexey Miranchuk','1995-10-17','volante','FC Lokomotiv Moscow (RUS)',185,77,'MIRANCHUK AL.'),(1,16,'Anton Miranchuk','1995-10-17','volante','FC Lokomotiv Moscow (RUS)',182,67,'MIRANCHUK AN.'),(1,17,'Aleksandr Golovin','1996-05-30','volante','CSKA Moscow (RUS)',178,70,'GOLOVIN'),(1,18,'Yury Zhirkov','1983-08-20','volante','FC Zenit St. Petersburg (RUS)',180,76,'ZHIRKOV'),(1,19,'Alexander Samedov','1984-07-19','volante','FC Spartak Moscow (RUS)',178,74,'SAMEDOV'),(1,20,'Vladimir Gabulov','1983-10-19','arquero','Club Brugge KV (BEL)',190,81,'GABULOV'),(1,21,'Aleksandr Erokhin','1989-10-13','volante','FC Zenit St. Petersburg (RUS)',191,79,'EROKHIN'),(1,22,'Artem Dzyuba','1988-08-22','atacante','FC Arsenal Tula (RUS)',196,90,'DZYUBA'),(1,23,'Igor Smolnikov','1988-08-08','defensa','FC Zenit St. Petersburg (RUS)',179,72,'SMOLNIKOV'),(2,1,'El Hadary Essam','1973-01-15','arquero','Al Taawoun FC (KSA)',190,90,'ELHADARY'),(2,2,'Gabr Ali','1989-01-01','defensa','West Bromwich Albion FC (ENG)',191,88,'ALI GABR'),(2,3,'Elmohamady Ahmed','1987-09-09','defensa','Aston Villa FC (ENG)',183,76,'ELMOHAMADY'),(2,4,'Omar Gaber','1992-01-30','volante','Los Angeles FC (USA)',175,71,'O. GABER'),(2,5,'Sam Morsy','1991-09-10','volante','Wigan Athletic FC (ENG)',173,75,'MORSY'),(2,6,'Ahmed Hegazy','1991-01-25','defensa','West Bromwich Albion FC (ENG)',194,95,'A. HEGAZY'),(2,7,'Ahmed Fathi','1984-11-10','defensa','Al Ahly SC (EGY)',176,76,'A. FATHI'),(2,8,'Tarek Hamed','1988-10-24','volante','Zamalek (EGY)',169,67,'TAREK HAMED'),(2,9,'Marwan Mohsen','1989-02-26','atacante','Al Ahly SC (EGY)',185,81,'MARWAN'),(2,10,'Mohamed Salah','1992-06-15','atacante','Liverpool FC (ENG)',175,71,'M SALAH'),(2,11,' Kahraba','1994-04-13','atacante','Al-Ittihad FC (KSA)',182,76,'M. KAHRABA'),(2,12,'Ayman Ashraf','1991-04-09','defensa','Al Ahly SC (EGY)',176,73,'A. ASHRAF'),(2,13,'Mohamed Abdelshafy','1985-07-01','defensa','Al Fateh FC (KSA)',171,72,'ABDELSHAFY'),(2,14,'Ramadan Sobhy','1997-01-23','atacante','Stoke City FC (ENG)',183,77,'RAMADAN'),(2,15,'Mahmoud Hamdy','1995-06-01','defensa','Zamalek (EGY)',173,72,'M. HAMDY'),(2,16,'Sherif Ekramy','1983-07-10','arquero','Al Ahly SC (EGY)',193,93,'EKRAMY'),(2,17,'Mohamed Elneny','1992-07-11','volante','Arsenal FC (ENG)',181,74,'M. ELNENY'),(2,18,' Shikabala','1986-03-05','atacante','Al Raed SC (KSA)',183,80,'SHIKABALA'),(2,19,'Said Abdalla','1985-07-13','volante','Kuopion PS (FIN)',176,75,'ABDALLA'),(2,20,'Saad Samir','1989-04-01','defensa','Al Ahly SC (EGY)',183,82,'S. SAMIR'),(2,21,' Trezeguet','1994-10-01','volante','Kasimpasa SK (TUR)',181,77,'M. TREZEGUET'),(2,22,'Amr Warda','1993-09-17','atacante','Atromitos FC (GRE)',179,77,'WARDA'),(2,23,'Mohamed Elshenawy','1988-12-18','arquero','Al Ahly SC (EGY)',191,86,'M. ELSHENAWY'),(3,1,'Abdullah Almuaiouf','1987-01-23','arquero','Al Hilal SFC (KSA)',178,98,'ABDULLAH'),(3,2,'Mansour Alharbi','1987-10-19','defensa','Al Ahli SC (KSA)',173,68,'MANSOUR'),(3,3,'Osama Hawsawi','1984-03-31','defensa','Al Hilal SFC (KSA)',188,83,'OSAMA'),(3,4,'Ali Albulayhi','1989-11-21','defensa','Al Hilal SFC (KSA)',182,83,'ALI'),(3,5,'Omar Othman','1985-09-27','defensa','Al Nassr FC (KSA)',185,76,'OMAR'),(3,6,'Mohammed Alburayk','1992-09-15','defensa','Al Hilal SFC (KSA)',173,61,'ALBURAYK'),(3,7,'Salman Alfaraj','1989-08-01','volante','Al Hilal SFC (KSA)',179,63,'SALMAN'),(3,8,'Yahia Alshehri','1990-06-26','volante','CD LeganEs (ESP)',165,63,'YAHIA'),(3,9,'Hatan Bahbir','1992-07-16','volante','Al Shabab FC (KSA)',170,66,'HATAN'),(3,10,'Mohammed Alsahlawi','1987-01-10','atacante','Al Nassr FC (KSA)',179,75,'ALSAHLAWI'),(3,11,'Abdulmalek Alkhaibri','1986-03-13','volante','Al Hilal SFC (KSA)',177,73,'ABDULMALEK'),(3,12,'Mohamed Kanno','1994-09-22','volante','Al Hilal SFC (KSA)',192,73,'KANNO'),(3,13,'Yasir Alshahrani','1992-05-25','defensa','Al Hilal SFC (KSA)',170,63,'YASIR'),(3,14,'Abdullah Otayf','1992-08-03','volante','Al Hilal SFC (KSA)',177,66,'OTAYF'),(3,15,'Abdullah Alkhaibari','1996-08-16','volante','Al Shabab FC (KSA)',175,66,'ALKHAIBARI'),(3,16,'Hussain Almoqahwi','1988-03-24','volante','Al Ahli SC (KSA)',174,76,'HUSSAIN'),(3,17,'Taiseer Aljassam','1984-07-25','volante','Al Ahli SC (KSA)',169,69,'TAISEER'),(3,18,'Salem Aldawsari','1991-08-19','volante','Villarreal CF (ESP)',174,68,'SALEM'),(3,19,'Fahad Almuwallad','1994-09-14','atacante','Levante UD (ESP)',168,65,'FAHAD'),(3,20,'Muhannad Asiri','1986-10-14','atacante','Al Ahli SC (KSA)',185,79,'MUHANNAD'),(3,21,'Yasser Almosailem','1984-02-27','arquero','Al Ahli SC (KSA)',186,88,'ALMOSAILEM'),(3,22,'Mohammed Alowais','1991-10-10','arquero','Al Ahli SC (KSA)',187,79,'ALOWAIS'),(3,23,'Motaz Hawsawi','1992-02-17','defensa','Al Ahli SC (KSA)',180,79,'MOTAZ'),(4,1,'Fernando Muslera','1986-06-16','arquero','Galatasaray SK (TUR)',190,74,'F. MUSLERA'),(4,2,'Jose Gimenez','1995-01-20','defensa','Atletico Madrid (ESP)',185,77,'J.M. GIMENEZ'),(4,3,'Diego Godin','1986-02-16','defensa','Atletico Madrid (ESP)',185,73,'D. GODIN'),(4,4,'Guillermo Varela','1993-03-24','defensa','CA Penarol (URU)',173,70,'G. VARELA'),(4,5,'Carlos Sanchez','1984-12-02','volante','CF Monterrey (MEX)',171,74,'C. SANCHEZ'),(4,6,'Rodrigo Bentancur','1997-06-25','volante','Juventus FC (ITA)',187,73,'R. BENTANCUR'),(4,7,'Cristian Rodriguez','1985-09-30','volante','CA Penarol (URU)',178,79,'C. RODRIGUEZ'),(4,8,'Nahitan Nandez','1995-12-28','volante','CA Boca Juniors (ARG)',171,61,'N. NANDEZ'),(4,9,'Luis Suarez','1987-01-24','atacante','FC Barcelona (ESP)',182,85,'L. SUAREZ'),(4,10,'Giorgian De Arrascaeta','1994-06-01','atacante','Cruzeiro EC (BRA)',172,64,'G. DE ARRASCAETA'),(4,11,'Cristhian Stuani','1986-10-12','atacante','Girona FC (ESP)',186,78,'C. STUANI'),(4,12,'Martin Campana','1989-05-29','arquero','CA Independiente (ARG)',184,79,'M. CAMPANA'),(4,13,'Gaston Silva','1994-03-05','defensa','CA Independiente (ARG)',185,74,'G. SILVA'),(4,14,'Lucas Torreira','1996-02-11','volante','UC Sampdoria (ITA)',168,61,'L. TORREIRA'),(4,15,'Matias Vecino','1991-08-24','volante','FC Internazionale (ITA)',189,80,'M. VECINO'),(4,16,'Maximiliano Pereira','1984-06-08','defensa','FC Porto (POR)',173,73,'M. PEREIRA'),(4,17,'Diego Laxalt','1993-02-07','volante','Genoa CFC (ITA)',178,66,'D. LAXALT'),(4,18,'Maximiliano Gomez','1996-08-14','atacante','Celta Vigo (ESP)',186,85,'M. GOMEZ'),(4,19,'Sebastian Coates','1990-10-07','defensa','Sporting CP (POR)',196,89,'S. COATES'),(4,20,'Jonathan Urretaviscaya','1990-03-19','atacante','CF Monterrey (MEX)',172,66,'J. URRETAVISCAYA'),(4,21,'Edinson Cavani','1987-02-14','atacante','Paris Saint-Germain FC (FRA)',188,78,'E. CAVANI'),(4,22,'Martin Caceres','1987-04-07','defensa','SS Lazio (ITA)',178,75,'M. CACERES'),(4,23,'Martin Silva','1983-03-25','arquero','CR Vasco da Gama (BRA)',187,82,'M. SILVA'),(5,1,'Yassine Bounou','1991-04-05','arquero','Girona FC (ESP)',190,77,'BOUNOU'),(5,2,'Achraf Hakimi','1998-11-04','defensa','Real Madrid CF (ESP)',179,65,'HAKIMI'),(5,3,'Hamza Mendyl','1997-10-21','defensa','Lille OSC (FRA)',179,70,'MENDYL'),(5,4,'Manuel Da Costa','1986-05-06','defensa','Istanbul Ba?ak?ehir FK (TUR)',187,78,'DA COSTA'),(5,5,'Mehdi Benatia','1987-04-17','defensa','Juventus FC (ITA)',188,88,'BENATIA'),(5,6,'Romain Saiss','1990-03-26','defensa','Wolverhampton Wanderers FC (ENG)',190,76,'SAISS'),(5,7,'Hakim Ziyach','1993-03-19','volante','AFC Ajax (NED)',180,70,'ZIYACH'),(5,8,'Karim El Ahmadi','1985-01-27','volante','Feyenoord Rotterdam (NED)',179,78,'EL AHMADI'),(5,9,'Ayoub El Kaabi','1993-06-25','atacante','RS Berkane (MAR)',182,72,'EL KAABI'),(5,10,'Younes Belhanda','1990-02-25','volante','Galatasaray SK (TUR)',174,75,'BELHANDA'),(5,11,'Faycal Fajr','1988-08-01','volante','Getafe CF (ESP)',178,72,'FAJR'),(5,12,'Monir El Kajoui','1989-05-10','arquero','CD Numancia (ESP)',190,88,'EL KAJOUI'),(5,13,'Khalid Boutaib','1987-04-24','atacante','Yeni Malatyaspor (TUR)',190,80,'BOUTAIB'),(5,14,'Mbark Boussoufa','1984-08-15','volante','Al Jazira (UAE)',167,59,'BOUSSOUFA'),(5,15,'Youssef Ait Bennasser','1996-07-07','volante','SM Caen (FRA)',184,75,'AIT BENNASSER'),(5,16,'Noureddine Amrabat','1987-03-31','volante','CD LeganEs (ESP)',178,77,'N. AMRABAT'),(5,17,'Nabil Dirar','1986-02-25','defensa','Fenerbahce SK (TUR)',187,82,'DIRAR'),(5,18,'Amine Harit','1997-06-18','volante','FC Schalke 04 (GER)',179,66,'HARIT'),(5,19,'Nesyri Youssef En','1997-06-01','atacante','Malaga CF (ESP)',188,75,'EN-NESYRI'),(5,20,'Aziz Bouhaddouz','1987-03-30','atacante','FC St. Pauli (GER)',188,80,'BOUHADDOUZ'),(5,21,'Sofyan Amrabat','1996-08-21','volante','Feyenoord Rotterdam (NED)',183,77,'S. AMRABAT'),(5,22,'Ahmed Tagnaouti','1996-04-05','arquero','IRT Tanger (MAR)',186,70,'TAGNAOUTI'),(5,23,'Mehdi Carcela','1989-07-01','volante','Standard Liège (BEL)',176,67,'CARCELA'),(6,1,'Rui Patricio ','1988-02-15','arquero','Sporting CP (POR)',189,84,'RUI PATRICIO'),(6,2,'Bruno Alves','1981-11-27','defensa','Rangers FC (SCO)',187,83,'B. ALVES'),(6,3,'Pepe ','1983-02-26','defensa','Besiktas JK (TUR)',188,81,'PEPE'),(6,4,'Manuel Fernandes','1986-02-05','volante','FC Lokomotiv Moscow (RUS)',174,69,'M. FERNANDES'),(6,5,'Raphael Guerreiro','1993-12-22','defensa','Borussia Dortmund (GER)',170,64,'RAPHAEL'),(6,6,'Jose Fonte','1983-12-22','defensa','Dalian Yifang FC (CHN)',191,84,'FONTE'),(6,7,'Cristiano Ronaldo ','1985-02-05','atacante','Real Madrid CF (ESP)',185,80,'RONALDO'),(6,8,'Joao Moutinho','1986-09-08','volante','AS Monaco (FRA)',170,61,'J. MOUTINHO'),(6,9,'Andre Silva ','1995-11-06','atacante','AC Milan (ITA)',184,78,'ANDRE SILVA'),(6,10,'Joao Mario ','1993-01-19','volante','West Ham United FC (ENG)',179,73,'J. MARIO'),(6,11,'Bernardo Silva','1994-08-10','volante','Manchester City FC (ENG)',173,65,'BERNARDO'),(6,12,'Anthony Lopes','1990-10-01','arquero','Olympique Lyon (FRA)',184,81,'LOPES'),(6,13,'Ruben Dias','1997-05-14','defensa','SL Benfica (POR)',187,83,'RUBEN DIAS'),(6,14,'William ','1992-04-07','volante','Sporting CP (POR)',190,80,'WILLIAM'),(6,15,'Ricardo ','1993-10-06','defensa','FC Porto (POR)',174,70,'RICARDO'),(6,16,'Bruno Fernandes','1994-09-08','volante','Sporting CP (POR)',183,64,'B. FERNANDES'),(6,17,'Goncalo Guedes','1996-11-29','atacante','Valencia CF (ESP)',179,72,'G. GUEDES'),(6,18,'Gelson Martins','1995-05-11','atacante','Sporting CP (POR)',173,63,'GELSON'),(6,19,'Mario Rui','1991-05-27','defensa','SSC Napoli (ITA)',168,67,'MARIO RUI'),(6,20,'Ricardo Quaresma','1983-09-26','atacante','Besiktas JK (TUR)',175,73,'QUARESMA'),(6,21,'Cedric ','1991-08-31','defensa','Southampton FC (ENG)',172,67,'CEDRIC'),(6,22,'Beto ','1982-05-01','arquero','Goztepe SK (TUR)',183,79,'BETO'),(6,23,'Adrien Silva','1989-03-15','volante','Leicester City FC (ENG)',176,72,'ADRIEN'),(7,1,'Ali Beiranvand','1992-09-21','arquero','Persepolis FC (IRN)',194,85,'A. BEIRANVAND'),(7,2,'Mehdi Torabi','1994-09-10','volante','Saipa Alborz FC (IRN)',185,71,'M. TORABI'),(7,3,'Ehsan Haji Safi ','1990-02-25','defensa','Olympiacos Piraeus FC (GRE)',178,75,'HAJI SAFI'),(7,4,'Roozbeh Cheshmi','1993-07-24','defensa','Esteghlal Tehran FC (IRN)',192,80,'R. CHESHMI'),(7,5,'Milad Mohammadi','1993-09-29','defensa','FC Akhmat Grozny (RUS)',178,69,'M. MOHAMMADI'),(7,6,'Saeid Ezatolahi','1996-10-01','volante','FK Amkar Perm (RUS)',190,82,'S. EZATOLAHI'),(7,7,'Masoud Shojaei','1984-06-09','volante','AEK Athens (GRE)',187,79,'SHOJAEI M.'),(7,8,'Morteza Pouraliganji','1992-04-19','defensa','Al Sadd SC (QAT)',187,83,'M. POURALIGANJI'),(7,9,'Omid Ebrahimi','1987-09-16','volante','Esteghlal Tehran FC (IRN)',178,75,'OMID'),(7,10,'Karim Ansarifard','1990-04-03','atacante','Olympiacos Piraeus FC (GRE)',187,80,'KARIM'),(7,11,'Vahid Amiri','1988-04-02','volante','Persepolis FC (IRN)',179,71,'V. AMIRI'),(7,12,'Rashid Mazaheri','1989-05-18','arquero','Zob Ahan Isfahan FC (IRN)',192,84,'RASHID'),(7,13,'Mohammad Reza Khanzadeh','1991-05-11','defensa','Padideh FC (IRN)',186,80,'M.R. KHANZADEH'),(7,14,'Saman Ghoddos','1993-09-06','atacante','IFK ostersund FK (SWE)',177,79,'GHODDOS'),(7,15,'Pejman Montazeri','1983-09-06','defensa','Esteghlal Tehran FC (IRN)',185,77,'P. MONTAZERI'),(7,16,'Reza Ghoochannejhad','1987-09-20','atacante','SC Heerenveen (NED)',180,79,'REZA'),(7,17,'Mehdi Taremi','1992-07-18','atacante','Al Gharafa SC (QAT)',187,80,'MEHDI'),(7,18,'Alireza Jahanbakhsh','1993-08-11','atacante','AZ Alkmaar (NED)',180,77,'A. JAHANBAKHSH'),(7,19,'Majid Hosseini','1996-06-20','defensa','Esteghlal Tehran FC (IRN)',183,78,'M. HOSSEINI'),(7,20,'Sardar Azmoun','1995-01-01','atacante','FC Rubin Kazan (RUS)',186,80,'SARDAR'),(7,21,'Ashkan Dejagah','1986-07-05','atacante','Nottingham Forest FC (ENG)',181,78,'DEJAGAH'),(7,22,'Amir Abedzadeh','1993-04-26','arquero','CS Maritimo (POR)',186,80,'ABEDZADEH'),(7,23,'Ramin Rezaeian','1990-03-21','defensa','KV Oostende (BEL)',185,75,'RAMIN'),(8,1,'David De Gea','1990-11-07','arquero','Manchester United FC (ENG)',190,71,'DE GEA'),(8,2,'Dani Carvajal','1992-01-11','defensa','Real Madrid CF (ESP)',173,73,'CARVAJAL'),(8,3,'Gerard Pique','1987-02-02','defensa','FC Barcelona (ESP)',194,85,'PIQUE'),(8,4,'Nacho ','1990-01-18','defensa','Real Madrid CF (ESP)',179,77,'NACHO'),(8,5,'Sergio Busquets','1988-07-16','volante','FC Barcelona (ESP)',189,78,'SERGIO'),(8,6,'Andres Iniesta','1984-05-11','volante','FC Barcelona (ESP)',171,68,'A. INIESTA'),(8,7,'Saul ','1994-11-21','volante','Atletico Madrid (ESP)',183,76,'SAUL'),(8,8,'Koke ','1992-01-08','volante','Atletico Madrid (ESP)',176,73,'KOKE'),(8,9,'Rodrigo ','1991-03-06','atacante','Valencia CF (ESP)',182,72,'RODRIGO M.'),(8,10,'Thiago ','1991-04-11','volante','FC Bayern Munchen (GER)',174,70,'THIAGO'),(8,11,'Lucas Vazquez','1991-07-01','atacante','Real Madrid CF (ESP)',173,70,'LUCAS V.'),(8,12,'Alvaro Odriozola','1995-12-14','defensa','Real Sociedad (ESP)',178,67,'ODRIOZOLA'),(8,13,'Kepa Arrizabalaga','1994-10-03','arquero','Athletic Bilbao (ESP)',189,84,'ARRIZABALAGA'),(8,14,'Cesar Azpilicueta','1989-08-28','defensa','Chelsea FC (ENG)',178,78,'AZPILICUETA'),(8,15,'Sergio Ramos','1986-03-30','defensa','Real Madrid CF (ESP)',183,75,'RAMOS'),(8,16,'Nacho Monreal','1986-02-26','defensa','Arsenal FC (ENG)',179,72,'MONREAL'),(8,17,'Iago Aspas','1987-08-01','atacante','Celta Vigo (ESP)',176,67,'IAGO ASPAS'),(8,18,'Jordi Alba','1989-03-21','defensa','FC Barcelona (ESP)',170,68,'JORDI ALBA'),(8,19,'Diego Costa','1988-10-07','atacante','Atletico Madrid (ESP)',185,86,'DIEGO COSTA'),(8,20,'Marco Asensio','1996-01-21','volante','Real Madrid CF (ESP)',182,76,'ASENSIO'),(8,21,'David Silva','1986-01-08','atacante','Manchester City FC (ENG)',170,67,'SILVA'),(8,22,' Isco','1992-04-21','volante','Real Madrid CF (ESP)',176,74,'ISCO'),(8,23,'Pepe Reina','1982-08-31','arquero','SSC Napoli (ITA)',188,92,'REINA'),(9,1,'Hugo Lloris','1986-12-26','arquero','Tottenham Hotspur FC (ENG)',188,82,'LLORIS'),(9,2,'Benjamin Pavard','1996-03-28','defensa','VfB Stuttgart (GER)',186,76,'PAVARD'),(9,3,'Presnel Kimpembe','1995-08-13','defensa','Paris Saint-Germain FC (FRA)',182,78,'KIMPEMBE'),(9,4,'Raphael Varane','1993-04-25','defensa','Real Madrid CF (ESP)',191,79,'VARANE'),(9,5,'Samuel Umtiti','1993-11-14','defensa','FC Barcelona (ESP)',183,84,'UMTITI'),(9,6,'Paul Pogba','1993-03-15','volante','Manchester United FC (ENG)',191,86,'POGBA'),(9,7,'Antoine Griezmann','1991-03-21','atacante','Atletico Madrid (ESP)',174,72,'GRIEZMANN'),(9,8,'Thomas Lemar','1995-11-12','atacante','AS Monaco (FRA)',172,65,'LEMAR'),(9,9,'Olivier Giroud','1986-09-30','atacante','Chelsea FC (ENG)',193,91,'GIROUD'),(9,10,'Kylian Mbappe','1998-12-20','atacante','Paris Saint-Germain FC (FRA)',178,78,'MBAPPE'),(9,11,'Ousmane Dembele','1997-05-15','atacante','FC Barcelona (ESP)',178,70,'DEMBELE'),(9,12,'Corentin Tolisso','1994-08-03','volante','FC Bayern Munchen (GER)',180,82,'TOLISSO'),(9,13,'Ngolo Kante','1991-03-29','volante','Chelsea FC (ENG)',168,70,'KANTE'),(9,14,'Blaise Matuidi','1987-04-09','volante','Juventus FC (ITA)',180,74,'MATUIDI'),(9,15,'Steven Nzonzi','1988-12-15','volante','Sevilla FC (ESP)',197,87,'NZONZI'),(9,16,'Steve Mandanda','1985-03-28','arquero','Olympique Marseille (FRA)',187,88,'MANDANDA'),(9,17,'Adil Rami','1985-12-27','defensa','Olympique Marseille (FRA)',190,90,'RAMI'),(9,18,'Nabil Fekir','1993-07-18','atacante','Olympique Lyon (FRA)',173,76,'FEKIR'),(9,19,'Djibril Sidibe','1992-07-29','defensa','AS Monaco (FRA)',184,81,'SIDIBE'),(9,20,'Florian Thauvin','1993-01-26','atacante','Olympique Marseille (FRA)',180,76,'THAUVIN'),(9,21,'Lucas Hernandez','1996-02-14','defensa','Atletico Madrid (ESP)',183,76,'HERNANDEZ'),(9,22,'Benjamin Mendy','1994-07-17','defensa','Manchester City FC (ENG)',183,84,'MENDY'),(9,23,'Alphonse Areola','1993-02-27','arquero','Paris Saint-Germain FC (FRA)',195,95,'AREOLA'),(10,1,'Nahuel Guzman','1986-02-10','arquero','Tigres UANL (MEX)',192,90,'GUZMAN'),(10,2,'Gabriel Mercado','1987-03-18','defensa','Sevilla FC (ESP)',181,81,'MERCADO'),(10,3,'Nicolas Tagliafico','1992-08-31','defensa','AFC Ajax (NED)',169,65,'TAGLIAFICO'),(10,4,'Cristian Ansaldi','1986-09-20','defensa','Torino FC (ITA)',181,73,'ANSALDI'),(10,5,'Lucas Biglia','1986-01-30','volante','AC Milan (ITA)',175,73,'BIGLIA'),(10,6,'Federico Fazio','1987-03-17','defensa','AS Roma (ITA)',199,85,'FAZIO'),(10,7,'Ever Banega','1988-06-29','volante','Sevilla FC (ESP)',175,73,'BANEGA'),(10,8,'Marcos Acuna','1991-10-28','defensa','Sporting CP (POR)',172,77,'ACUNA'),(10,9,'Gonzalo Higuain','1987-12-10','atacante','Juventus FC (ITA)',184,75,'HIGUAiN'),(10,10,'Lionel Messi','1987-06-24','atacante','FC Barcelona (ESP)',170,72,'MESSI'),(10,11,'Angel Di Maria','1988-02-14','volante','Paris Saint-Germain FC (FRA)',178,75,'DI MARiA'),(10,12,'Franco Armani','1986-10-16','arquero','CA River Plate (ARG)',189,85,'ARMANI'),(10,13,'Maximiliano Meza','1992-12-15','volante','CA Independiente (ARG)',180,76,'MEZA'),(10,14,'Javier Mascherano','1984-06-08','defensa','Hebei China Fortune FC (CHN)',174,73,'MASCHERANO'),(10,15,'Manuel Lanzini','1993-02-15','volante','West Ham United FC (ENG)',167,66,'LANZINI'),(10,16,'Marcos Rojo','1990-03-20','defensa','Manchester United FC (ENG)',189,82,'ROJO'),(10,17,'Nicolas Otamendi','1988-02-12','defensa','Manchester City FC (ENG)',181,81,'OTAMENDI'),(10,18,'Eduardo Salvio','1990-07-13','defensa','SL Benfica (POR)',167,69,'SALVIO'),(10,19,'Sergio Aguero','1988-06-02','atacante','Manchester City FC (ENG)',172,74,'AGuERO'),(10,20,'Giovani Lo Celso','1996-04-09','volante','Paris Saint-Germain FC (FRA)',177,75,'LO CELSO'),(10,21,'Paulo Dybala','1993-11-15','atacante','Juventus FC (ITA)',177,73,'DYBALA'),(10,22,'Cristian Pavon','1996-01-21','volante','CA Boca Juniors (ARG)',169,65,'PAVON'),(10,23,'Wilfredo Caballero','1981-09-28','arquero','Chelsea FC (ENG)',186,80,'CABALLERO'),(11,1,'Mathew Ryan','1992-04-08','arquero','Brighton & Hove Albion FC (ENG)',184,82,'RYAN'),(11,2,'Milos Degenek','1994-04-28','defensa','Yokohama F-Marinos (JPN)',187,85,'DEGENEK'),(11,3,'James Meredith','1988-04-05','defensa','Millwall FC (ENG)',179,71,'MEREDITH'),(11,4,'Tim Cahill','1979-12-06','atacante','Millwall FC (ENG)',180,76,'CAHILL'),(11,5,'Mark Milligan','1985-08-04','defensa','Al Ahli SC (KSA)',178,78,'MILLIGAN'),(11,6,'Matthew Jurman','1989-12-08','defensa','Suwon Samsung Bluewings FC (KOR)',190,83,'JURMAN'),(11,7,'Mathew Leckie','1991-02-04','atacante','Hertha BSC (GER)',181,84,'LECKIE'),(11,8,'Massimo Luongo','1992-09-25','volante','Queens Park Rangers FC (ENG)',176,76,'LUONGO'),(11,9,'Tomi Juric','1991-07-22','atacante','FC Luzern (SUI)',190,80,'JURIC'),(11,10,'Robbie Kruse','1988-10-05','atacante','VfL Bochum (GER)',180,66,'KRUSE'),(11,11,'Andrew Nabbout','1992-12-17','atacante','Urawa Reds (JPN)',178,85,'NABBOUT'),(11,12,'Brad Jones','1982-03-19','arquero','Feyenoord Rotterdam (NED)',193,87,'JONES'),(11,13,'Aaron Mooy','1990-09-15','volante','Huddersfield Town FC (ENG)',173,72,'MOOY'),(11,14,'Jamie Maclaren','1993-07-29','atacante','Hibernian FC (SCO)',178,72,'MACLAREN'),(11,15,'Mile Jedinak','1984-08-03','volante','Aston Villa FC (ENG)',188,78,'JEDINAK'),(11,16,'Aziz Behich','1990-12-16','defensa','Bursaspor (TUR)',170,63,'BEHICH'),(11,17,'Daniel Arzani','1999-01-04','atacante','Melbourne City FC (AUS)',171,73,'ARZANI'),(11,18,'Danny Vukovic','1985-03-27','arquero','KRC Genk (BEL)',187,94,'VUKOVIC'),(11,19,'Joshua Risdon','1992-07-27','defensa','WS Wanderers FC (AUS)',169,70,'RISDON'),(11,20,'Trent Sainsbury','1992-01-05','defensa','Grasshopper Club (SUI)',183,76,'SAINSBURY'),(11,21,'Dimitrios Petratos','1992-11-10','atacante','Newcastle United Jets FC (AUS)',176,72,'PETRATOS'),(11,22,'Jackson Irvine','1993-03-07','volante','Hull City FC (ENG)',180,77,'IRVINE'),(11,23,'Tom Rogic','1992-12-16','volante','Celtic FC (SCO)',189,88,'ROGIC'),(12,1,'Hannes Halldorsson','1984-04-27','arquero','Randers FC (DEN)',193,88,'HALLDORSSON'),(12,2,'Birkir Saevarsson','1984-11-11','defensa','Valur Reykjavik (ISL)',186,75,'SAEVARSSON'),(12,3,'Samuel Fridjonsson','1996-02-22','volante','Valerenga IF (NOR)',185,78,'FRIDJONSSON'),(12,4,'Albert Gudmundsson','1997-06-15','volante','PSV Eindhoven (NED)',177,80,'A. GUDMUNDSSON'),(12,5,'Sverrir Ingason','1993-08-05','defensa','FC Rostov (RUS)',188,80,'INGASON'),(12,6,'Ragnar Sigurdsson','1986-06-19','defensa','FC Rostov (RUS)',187,86,'R. SIGURDSSON'),(12,7,'Johann Gudmundsson','1990-10-27','volante','Burnley FC (ENG)',179,77,'J. GUDMUNDSSON'),(12,8,'Birkir Bjarnason','1988-05-27','volante','Aston Villa FC (ENG)',183,77,'B. BJARNASON'),(12,9,'Bjorn Sigurdarson','1991-02-26','atacante','FC Rostov (RUS)',187,85,'SIGURDARSON'),(12,10,'Gylfi Sigurdsson','1989-09-08','volante','Everton FC (ENG)',186,82,'G. SIGURDSSON'),(12,11,'Alfred Finnbogason','1989-02-01','atacante','FC Augsburg (GER)',185,79,'FINNBOGASON'),(12,12,'Frederik Schram','1995-01-19','arquero','Roskilde BK (DEN)',198,92,'SCHRAM'),(12,13,'Runar Runarsson','1995-02-18','arquero','FC Nordsjaelland (DEN)',186,76,'RUNARSSON'),(12,14,'Kari Arnason','1982-10-13','defensa','Aberdeen FC (SCO)',191,82,'ARNASON'),(12,15,'Holmar Eyjolfsson','1990-08-06','defensa','Levski Sofia (BUL)',188,81,'EYJOLFSSON'),(12,16,'Olafur Skulason','1983-04-01','volante','Karabukspor (TUR)',184,79,'O. SKULASON'),(12,17,'Aron Gunnarsson','1989-04-22','volante','Cardiff City FC (WAL)',181,86,'GUNNARSSON'),(12,18,'Hordur Magnusson','1993-02-11','defensa','Bristol City FC (ENG)',191,85,'MAGNUSSON'),(12,19,'Rurik Gislason','1988-02-25','volante','SV Sandhausen (GER)',184,78,'GISLASON'),(12,20,'Emil Hallfredsson','1984-06-29','volante','Udinese Calcio (ITA)',186,86,'HALLFREDSSON'),(12,21,'Arnor Traustason','1993-04-30','volante','Malmo FF (SWE)',183,73,'TRAUSTASON'),(12,22,'Jon Bodvarsson','1992-05-25','atacante','Reading FC (ENG)',189,89,'BoDVARSSON'),(12,23,'Ari Skulason','1987-05-14','defensa','KSC Lokeren (BEL)',170,63,'A. SKULASON'),(13,1,'Pedro Gallese','1990-02-23','arquero','CD Tiburones Rojos de Veracruz (MEX)',189,79,'GALLESE'),(13,2,'Alberto Rodriguez','1984-03-31','defensa','Atletico Junior (COL)',179,78,'RODRIGUEZ'),(13,3,'Aldo Corzo','1989-05-20','defensa','Universitario Lima (PER)',172,75,'CORZO'),(13,4,'Anderson Santamaria','1992-01-10','defensa','Puebla FC (MEX)',183,84,'SANTAMARIA'),(13,5,'Miguel Araujo','1994-10-24','defensa','Alianza Lima (PER)',178,77,'ARAUJO'),(13,6,'Miguel Trauco','1992-08-25','defensa','CR Flamengo (BRA)',169,74,'TRAUCO'),(13,7,'Paolo Hurtado','1990-07-27','volante','Vitoria Guimaraes (POR)',174,66,'HURTADO'),(13,8,'Christian Cueva','1991-11-23','volante','Sao Paulo FC (BRA)',169,69,'CUEVA'),(13,9,'Paolo Guerrero','1984-01-01','atacante','CR Flamengo (BRA)',185,88,'GUERRERO'),(13,10,'Jefferson Farfan','1984-10-26','atacante','FC Lokomotiv Moscow (RUS)',177,85,'FARFAN'),(13,11,'Raul Ruidiaz','1990-07-25','atacante','CA Monarcas Morelia (MEX)',169,67,'RUIDIAZ'),(13,12,'Carlos Caceda','1991-09-27','arquero','Deportivo Municipal (PER)',184,78,'CACEDA'),(13,13,'Renato Tapia','1995-07-28','volante','Feyenoord Rotterdam (NED)',185,85,'TAPIA'),(13,14,'Andy Polo','1994-09-29','volante','Portland Timbers (USA)',174,71,'POLO'),(13,15,'Christian Ramos','1988-11-04','defensa','CD Tiburones Rojos de Veracruz (MEX)',182,72,'RAMOS'),(13,16,'Wilder Cartagena','1994-09-23','volante','CD Tiburones Rojos de Veracruz (MEX)',179,76,'CARTAGENA'),(13,17,'Luis Advincula','1990-03-02','defensa','Lobos BUAP (MEX)',178,80,'ADVINCULA'),(13,18,'Andre Carrillo','1991-06-14','atacante','Watford FC (ENG)',182,77,'CARRILLO'),(13,19,'Yoshimar Yotun','1990-04-07','volante','Orlando City SC (USA)',172,69,'YOTUN'),(13,20,'Edison Flores','1994-05-14','atacante','Aalborg BK (DEN)',170,72,'FLORES'),(13,21,'Jose Carvallo','1986-03-01','arquero','Universidad TEcnica de Cajamarca (PER',182,84,'CARVALLO'),(13,22,'Nilson Loyola','1994-10-26','defensa','FBC Melgar (PER)',179,68,'LOYOLA'),(13,23,'Pedro Aquino','1995-04-13','volante','Lobos BUAP (MEX)',174,71,'AQUINO'),(14,1,'Dominik Livakovic','1995-01-09','arquero','GNK Dinamo Zagreb (CRO)',188,82,'LIVAKOVIC'),(14,2,'Sime Vrsaljko','1992-01-10','defensa','Atletico Madrid (ESP)',181,76,'VRSALJKO'),(14,3,'Ivan Strinic','1987-07-17','defensa','UC Sampdoria (ITA)',186,78,'STRINIC'),(14,4,'Ivan Perisic','1989-02-02','atacante','FC Internazionale (ITA)',186,81,'PERISIC'),(14,5,'Vedran Corluka','1986-02-05','defensa','FC Lokomotiv Moscow (RUS)',192,84,'CORLUKA'),(14,6,'Dejan Lovren','1989-07-05','defensa','Liverpool FC (ENG)',188,84,'LOVREN'),(14,7,'Ivan Rakitic','1988-03-10','volante','FC Barcelona (ESP)',184,78,'RAKITIC'),(14,8,'Mateo Kovacic','1994-05-06','volante','Real Madrid CF (ESP)',178,78,'KOVACIC'),(14,9,'Andrej Kramaric','1991-06-19','atacante','TSG 1899 Hoffenheim (GER)',177,73,'KRAMARIC'),(14,10,'Luka Modric','1985-09-09','volante','Real Madrid CF (ESP)',172,66,'MODRIC'),(14,11,'Marcelo Brozovic','1992-11-16','volante','FC Internazionale (ITA)',181,68,'BROZOVIC'),(14,12,'Lovre Kalinic','1990-04-03','arquero','KAA Gent (BEL)',201,96,'L. KALINIC'),(14,13,'Tin Jedvaj','1995-11-28','defensa','Bayer 04 Leverkusen (GER)',184,81,'JEDVAJ'),(14,14,'Filip Bradaric','1992-01-11','volante','HNK Rijeka (CRO)',186,78,'BRADARIC'),(14,15,'Duje Caleta-Car','1996-09-17','defensa','FC Red Bull Salzburg (AUT)',192,89,'CALETA-CAR'),(14,16,'Nikola Kalinic','1988-01-05','atacante','AC Milan (ITA)',187,81,'N. KALINIC'),(14,17,'Mario Mandzukic','1986-05-21','atacante','Juventus FC (ITA)',190,85,'MANDZUKIC'),(14,18,'Ante Rebic','1993-09-21','atacante','Eintracht Frankfurt (GER)',185,78,'REBIC'),(14,19,'Milan Badelj','1989-02-25','volante','ACF Fiorentina (ITA)',186,76,'BADELJ'),(14,20,'Marko Pjaca','1995-05-06','atacante','FC Schalke 04 (GER)',186,83,'PJACA'),(14,21,'Domagoj Vida','1989-04-29','defensa','Besiktas JK (TUR)',184,76,'VIDA'),(14,22,'Josip Pivaric','1989-01-30','defensa','FC Dynamo Kyiv (UKR)',176,69,'PIVARIC'),(14,23,'Danijel Subasic','1984-10-27','arquero','AS Monaco (FRA)',191,84,'SUBASIC'),(15,1,'Kasper Schmeichel','1986-11-05','arquero','Leicester City FC (ENG)',190,92,'SCHMEICHEL'),(15,2,'Michael Krohn-Dehli','1983-06-06','volante','Deportivo La CoruNa (ESP)',171,69,'KROHN-DEHLI'),(15,3,'Jannik Vestergaard','1992-08-03','defensa','VfL Borussia Monchengladbach (GER)',200,98,'VESTERGAARD'),(15,4,'Simon Kjaer','1989-03-26','defensa','Sevilla FC (ESP)',191,84,'KJAER'),(15,5,'Jonas Knudsen','1992-09-16','defensa','Ipswich Town FC (ENG)',187,82,'KNUDSEN'),(15,6,'Andreas Christensen','1996-04-10','defensa','Chelsea FC (ENG)',192,85,'CHRISTENSEN'),(15,7,'William Kvist','1985-02-24','volante','FC Kobenhavn (DEN)',185,80,'KVIST'),(15,8,'Thomas Delaney','1991-09-03','volante','SV Werder Bremen (GER)',180,78,'DELANEY'),(15,9,'Nicolai Jorgensen','1991-01-15','atacante','Feyenoord Rotterdam (NED)',194,86,'N. JORGENSEN'),(15,10,'Christian Eriksen','1992-02-14','volante','Tottenham Hotspur FC (ENG)',181,76,'ERIKSEN'),(15,11,'Martin Braithwaite','1991-06-05','atacante','FC Girondins Bordeaux (FRA)',180,73,'BRAITHWAITE'),(15,12,'Kasper Dolberg','1997-10-06','atacante','AFC Ajax (NED)',187,85,'DOLBERG'),(15,13,'Mathias Jorgensen','1990-04-23','defensa','Huddersfield Town FC (ENG)',191,85,'M. JORGENSEN'),(15,14,'Henrik Dalsgaard','1989-07-27','defensa','Brentford FC (ENG)',190,81,'DALSGAARD'),(15,15,'Viktor Fischer','1994-06-09','atacante','FC Kobenhavn (DEN)',181,80,'FISCHER'),(15,16,'Jonas Lossl','1989-02-01','arquero','Huddersfield Town FC (ENG)',195,90,'LoSSL'),(15,17,'Jens Stryger Larsen ','1991-02-21','defensa','Udinese Calcio (ITA)',182,82,'STRYGER'),(15,18,'Lukas Lerager','1993-07-12','volante','FC Girondins Bordeaux (FRA)',186,85,'LERAGER'),(15,19,'Lasse Schone','1986-05-27','volante','AFC Ajax (NED)',178,80,'SCHoNE'),(15,20,'Yussuf Yurary Poulsen','1994-06-15','atacante','RB Leipzig (GER)',193,84,'YURARY'),(15,21,'Andreas Cornelius','1993-03-16','atacante','Atalanta Bergamo (ITA)',195,91,'CORNELIUS'),(15,22,'Frederik Ronnow','1992-08-04','arquero','Brondby IF (DEN)',190,85,'RONNOW'),(15,23,'Pione Sisto','1995-02-04','atacante','Celta Vigo (ESP)',173,69,'SISTO'),(16,1,'Ikechukwu Ezenwa','1988-10-16','arquero','Enyimba FC (NGA)',181,80,'EZENWA'),(16,2,'Bryan Idowu','1992-05-18','defensa','FK Amkar Perm (RUS)',179,75,'IDOWU'),(16,3,'Elderson Echiejile','1988-01-20','defensa','Cercle Brugge (BEL)',185,82,'ECHIEJILE'),(16,4,'Onyinye Ndidi','1996-12-16','volante','Leicester City FC (ENG)',184,73,'NDIDI'),(16,5,'William Ekong','1993-09-01','defensa','Bursaspor (TUR)',191,85,'EKONG'),(16,6,'Leon Balogun','1988-06-28','defensa','FSV Mainz 05 (GER)',190,89,'BALOGUN'),(16,7,'Ahmed Musa','1992-10-14','atacante','CSKA Moscow (RUS)',173,65,'MUSA'),(16,8,'Oghenekaro Etebo','1995-11-09','volante','UD Las Palmas (ESP)',174,74,'ETEBO'),(16,9,'Odion Ighalo','1989-06-16','atacante','Changchun Yatai (CHN)',188,83,'IGHALO'),(16,10,'John Obi Mikel','1987-04-22','volante','Tianjin Teda (CHN)',188,82,'MIKEL'),(16,11,'Victor Moses','1990-12-12','atacante','Chelsea FC (ENG)',177,75,'MOSES'),(16,12,'Abdullahi Shehu','1993-03-12','defensa','Bursaspor (TUR)',182,75,'SHEHU'),(16,13,'Simeon Nwankwo','1992-05-07','atacante','FC Crotone (ITA)',197,89,'NWANKWO'),(16,14,'Kelechi Iheanacho','1996-03-10','atacante','Leicester City FC (ENG)',183,80,'IHEANACHO'),(16,15,'Joel Obi','1991-05-22','volante','Torino FC (ITA)',177,77,'OBI'),(16,16,'Daniel Akpeyi','1986-03-08','arquero','Chippa United FC (RSA)',187,94,'AKPEYI'),(16,17,'Ogenyi Onazi','1992-12-25','volante','Trabzonspor (TUR)',172,74,'ONAZI'),(16,18,'Alex Iwobi','1996-05-03','atacante','Arsenal FC (ENG)',185,86,'IWOBI'),(16,19,'John Ogu','1988-04-20','volante','Hapoel Be\'er Sheva FC (ISR)',191,90,'OGU'),(16,20,'Chidozie Awaziem','1997-01-01','defensa','FC Nantes (FRA)',192,76,'AWAZIEM'),(16,21,'Tyronne Ebuehi','1995-12-16','defensa','ADO Den Haag (NED)',187,74,'EBUEHI'),(16,22,'Kenneth Omeruo','1993-10-17','defensa','Kasimpasa SK (TUR)',185,82,'OMERUO'),(16,23,'Francis Uzoho','1998-10-28','arquero','Deportivo La CoruNa (ESP)',196,91,'UZOHO'),(17,1,'Keylor Navas','1986-12-15','arquero','Real Madrid CF (ESP)',185,80,'K. NAVAS'),(17,2,'Johnny Acosta','1983-07-21','defensa','Rionegro Aguilas (COL)',176,75,'J. ACOSTA'),(17,3,'Giancarlo Gonzalez','1988-02-08','defensa','Bologna FC (ITA)',186,78,'G. GONZALEZ'),(17,4,'Ian Smith','1998-03-06','defensa','IFK Norrkoping FK (SWE)',177,68,'I. SMITH'),(17,5,'Celso Borges','1988-05-27','volante','Deportivo La CoruNa (ESP)',187,79,'C. BORGES'),(17,6,'Oscar Duarte','1989-06-03','defensa','RCD Espanyol (ESP)',186,81,'O. DUARTE'),(17,7,'Christian Bolanos','1984-05-17','volante','Deportivo Saprissa (CRC)',178,67,'C. BOLANOS'),(17,8,'Bryan Oviedo','1990-02-18','defensa','Sunderland AFC (ENG)',172,70,'B. OVIEDO'),(17,9,'Daniel Colindres','1985-01-10','volante','Deportivo Saprissa (CRC)',180,75,'D. COLINDRES'),(17,10,'Bryan Ruiz','1985-08-18','volante','Sporting CP (POR)',187,73,'BRYAN'),(17,11,'Johan Venegas','1988-11-27','atacante','Deportivo Saprissa (CRC)',183,76,'J. VENEGAS'),(17,12,'Joel Campbell','1992-06-26','atacante','Real Betis (ESP)',178,71,'J. CAMPBELL'),(17,13,'Rodney Wallace','1988-06-17','volante','New York City FC (USA)',180,70,'R. WALLACE'),(17,14,'Randall Azofeifa','1984-12-30','volante','CS Herediano (CRC)',182,83,'R. AZOFEIFA'),(17,15,'Francisco Calvo','1992-07-08','defensa','Minnesota United FC (USA)',180,78,'F. CALVO'),(17,16,'Cristian Gamboa','1989-10-24','defensa','Celtic FC (SCO)',175,67,'C. GAMBOA'),(17,17,'Yeltsin Tejeda','1992-03-17','volante','FC Lausanne-Sport (SUI)',179,67,'Y. TEJEDA'),(17,18,'Patrick Pemberton','1982-04-24','arquero','LD Alajuelense (CRC)',178,72,'P. PEMBERTON'),(17,19,'Kendall Waston','1988-01-01','defensa','Vancouver Whitecaps FC (CAN)',196,87,'K. WASTON'),(17,20,'David Guzman','1990-02-18','volante','Portland Timbers (USA)',176,78,'D. GUZMAN'),(17,21,'Marcos Urena','1990-03-05','atacante','Los Angeles FC (USA)',181,70,'M. URENA'),(17,22,'Ronald Matarrita','1994-07-09','defensa','New York City FC (USA)',175,70,'R. MATARRITA'),(17,23,'Leonel Moreira','1990-04-02','arquero','CS Herediano (CRC)',179,70,'L. MOREIRA'),(18,1,'Manuel Neuer','1986-03-27','arquero','FC Bayern Munchen (GER)',193,93,'NEUER'),(18,2,'Marvin Plattenhardt','1992-01-26','defensa','Hertha BSC (GER)',181,76,'PLATTENHARDT'),(18,3,'Jonas Hector','1990-05-27','defensa','1. FC Koln (GER)',185,75,'HECTOR'),(18,4,'Matthias Ginter','1994-01-19','defensa','VfL Borussia Monchengladbach (GER)',189,85,'GINTER'),(18,5,'Mats Hummels','1988-12-16','defensa','FC Bayern Munchen (GER)',192,90,'HUMMELS'),(18,6,'Sami Khedira','1987-04-04','volante','Juventus FC (ITA)',189,81,'KHEDIRA'),(18,7,'Julian Draxler','1993-09-20','volante','Paris Saint-Germain FC (FRA)',185,74,'DRAXLER'),(18,8,'Toni Kroos','1990-01-04','volante','Real Madrid CF (ESP)',182,78,'KROOS'),(18,9,'Timo Werner','1996-03-06','atacante','RB Leipzig (GER)',181,75,'WERNER'),(18,10,'Mesut Oezil','1988-10-15','volante','Arsenal FC (ENG)',180,70,'oZIL'),(18,11,'Marco Reus','1989-05-31','atacante','Borussia Dortmund (GER)',180,67,'REUS'),(18,12,'Kevin Trapp','1990-07-08','arquero','Paris Saint-Germain FC (FRA)',189,88,'TRAPP'),(18,13,'Thomas Mueller','1989-09-13','volante','FC Bayern Munchen (GER)',186,75,'MuLLER'),(18,14,'Leon Goretzka','1995-02-06','volante','FC Schalke 04 (GER)',189,76,'GORETZKA'),(18,15,'Niklas Suele','1995-09-03','defensa','FC Bayern Munchen (GER)',195,89,'SuLE'),(18,16,'Antonio Ruediger','1993-03-03','defensa','Chelsea FC (ENG)',191,85,'RuDIGER'),(18,17,'Jerome Boateng','1988-09-03','defensa','FC Bayern Munchen (GER)',192,90,'BOATENG'),(18,18,'Joshua Kimmich','1995-02-08','defensa','FC Bayern Munchen (GER)',176,72,'KIMMICH'),(18,19,'Sebastian Rudy','1990-02-28','volante','FC Bayern Munchen (GER)',179,74,'RUDY'),(18,20,'Julian Brandt','1996-05-02','volante','Bayer 04 Leverkusen (GER)',183,82,'BRANDT'),(18,21,'Ilkay Guendogan','1990-10-24','volante','Manchester City FC (ENG)',180,79,'GuNDOGAN'),(18,22,'Marc-Andre Ter Stegen','1992-04-30','arquero','FC Barcelona (ESP)',187,85,'TER STEGEN'),(18,23,'Mario Gomez','1985-07-10','atacante','VfB Stuttgart (GER)',189,82,'GOMEZ'),(19,1,'Vladimir Stojkovic','1983-07-28','arquero','FK Partizan (SRB)',195,92,'STOJKOVIC'),(19,2,'Antonio Rukavina','1984-01-26','defensa','Villarreal CF (ESP)',177,71,'RUKAVINA'),(19,3,'Dusko Tosic','1985-01-19','defensa','Besiktas JK (TUR)',185,79,'TOSIC'),(19,4,'Luka Milivojevic','1991-04-07','volante','Crystal Palace FC (ENG)',186,80,'MILIVOJEVIC'),(19,5,'Uros Spajic','1993-02-13','defensa','RSC Anderlecht (BEL)',188,82,'SPAJIC'),(19,6,'Branislav Ivanovic','1984-02-22','defensa','FC Zenit St. Petersburg (RUS)',185,89,'IVANOVIC'),(19,7,'Andrija Zivkovic','1996-07-11','volante','SL Benfica (POR)',169,68,'ZIVKOVIC'),(19,8,'Aleksandar Prijovic','1990-04-21','atacante','PAOK FC (GRE)',191,88,'PRIJOVIC'),(19,9,'Aleksandar Mitrovic','1994-09-16','atacante','Fulham FC (ENG)',189,82,'MITROVIC'),(19,10,'Dusan Tadic','1988-11-20','volante','Southampton FC (ENG)',181,76,'TADIC'),(19,11,'Aleksandar Kolarov','1985-11-10','defensa','AS Roma (ITA)',187,83,'KOLAROV'),(19,12,'Predrag Rajkovic','1995-10-31','arquero','Maccabi Tel-Aviv FC (ISR)',191,85,'RAJKOVIC'),(19,13,'Milos Veljkovic','1995-09-26','defensa','SV Werder Bremen (GER)',188,77,'VELJKOVIC'),(19,14,'Milan Rodic','1991-04-02','defensa','FK Crvena Zvezda (SRB)',185,69,'RODIC'),(19,15,'Nikola Milenkovic','1997-10-12','defensa','ACF Fiorentina (ITA)',195,90,'MILENKOVIC'),(19,16,'Marko Grujic','1996-04-13','volante','Cardiff City FC (WAL)',190,82,'GRUJIC'),(19,17,'Filip Kostic','1992-11-01','volante','Hamburger SV (GER)',184,82,'KOSTIC'),(19,18,'Nemanja Radonjic','1996-02-15','atacante','FK Crvena Zvezda (SRB)',185,76,'RADONJIC'),(19,19,'Luka Jovic','1997-12-23','atacante','Eintracht Frankfurt (GER)',181,75,'JOVIC'),(19,20,'Sergej Milinkovic-Savic','1995-02-27','volante','SS Lazio (ITA)',192,76,'SERGEJ'),(19,21,'Nemanja Matic','1988-08-01','volante','Manchester United FC (ENG)',194,86,'MATIC'),(19,22,'Adem Ljajic','1991-09-29','volante','Torino FC (ITA)',182,74,'LJAJIC'),(19,23,'Marko Dmitrovic','1992-01-24','arquero','SD Eibar (ESP)',194,90,'DMITROVIC'),(20,1,'Jose Corona','1981-01-26','arquero','Cruz Azul (MEX)',182,80,'J. CORONA'),(20,2,'Hugo Ayala','1987-03-31','defensa','Tigres UANL (MEX)',188,82,'H. AYALA'),(20,3,'Carlos Salcedo','1993-09-29','defensa','Eintracht Frankfurt (GER)',189,83,'C. SALCEDO'),(20,4,'Rafael Marquez','1979-02-13','defensa','CF Atlas (MEX)',184,77,'R. MARQUEZ'),(20,5,'Diego Reyes','1992-09-19','defensa','FC Porto (POR)',190,77,'D. REYES'),(20,6,'Jonathan Dos Santos','1990-04-26','volante','LA Galaxy (USA)',173,69,'J. DOS SANTOS'),(20,7,'Miguel Layun','1988-06-25','volante','Sevilla FC (ESP)',180,72,'M. LAYUN'),(20,8,'Marco Fabian','1989-07-21','atacante','Eintracht Frankfurt (GER)',171,70,'M. FABIAN'),(20,9,'Raul Jimenez','1991-05-05','atacante','SL Benfica (POR)',188,79,'RAUL'),(20,10,'Giovani Dos Santos','1989-05-11','volante','LA Galaxy (USA)',178,70,'G. DOS SANTOS'),(20,11,'Carlos Vela','1989-03-01','atacante','Los Angeles FC (USA)',178,78,'CARLOS V'),(20,12,'Alfredo Talavera','1982-09-18','arquero','Deportivo Toluca FC (MEX)',188,84,'A. TALAVERA'),(20,13,'Guillermo Ochoa','1985-07-13','arquero','Standard Liège (BEL)',185,76,'G. OCHOA'),(20,14,'Javier Hernandez','1988-06-01','atacante','West Ham United FC (ENG)',175,71,'J. HERNANDEZ'),(20,15,'Hector Moreno','1988-01-17','defensa','Real Sociedad (ESP)',182,82,'H. MORENO'),(20,16,'Hector Herrera','1990-04-19','defensa','FC Porto (POR)',180,79,'H. HERRERA'),(20,17,'Jesus Corona','1993-01-06','volante','FC Porto (POR)',174,69,'JESUS C.'),(20,18,'Andres Guardado','1986-09-28','volante','Real Betis (ESP)',167,63,'A. GUARDADO'),(20,19,'Oribe Peralta','1984-01-12','atacante','Club AmErica (MEX)',178,72,'O. PERALTA'),(20,20,'Javier Aquino','1990-02-11','volante','Tigres UANL (MEX)',166,59,'J. AQUINO'),(20,21,'Edson Alvarez','1997-10-24','defensa','Club AmErica (MEX)',186,72,'E. ALVAREZ'),(20,22,'Hirving Lozano','1995-07-30','atacante','PSV Eindhoven (NED)',176,66,'H. LOZANO'),(20,23,'Jesus Gallardo','1994-08-15','volante','Pumas UNAM (MEX)',177,74,'J. GALLARDO'),(21,1,'Alisson ','1992-10-02','arquero','AS Roma (ITA)',193,91,'A. BECKER'),(21,2,'Thiago Silva','1984-09-22','defensa','Paris Saint-Germain FC (FRA)',183,79,'T. SILVA'),(21,3,'Miranda ','1984-09-07','defensa','FC Internazionale (ITA)',186,78,'MIRANDA'),(21,4,'Pedro Geromel','1985-09-21','defensa','Grêmio FBPA (BRA)',190,84,'GEROMEL'),(21,5,'Casemiro','1992-02-23','volante','Real Madrid CF (ESP)',185,84,'CASEMIRO'),(21,6,'Luis Filipe ','1985-08-09','defensa','Atletico Madrid (ESP)',182,73,'FILIPE LUIS'),(21,7,'Douglas Costa','1990-09-14','atacante','Juventus FC (ITA)',182,70,'D. COSTA'),(21,8,'Renato Augusto ','1988-02-08','volante','Beijing Guoan (CHN)',186,86,'R. AUGUSTO'),(21,9,'Gabriel Jesus ','1997-04-03','atacante','Manchester City FC (ENG)',175,73,'G. JESUS'),(21,10,'Neymar ','1992-02-05','atacante','Paris Saint-Germain FC (FRA)',175,68,'NEYMAR JR'),(21,11,'Philippe Coutinho','1992-06-12','volante','FC Barcelona (ESP)',172,68,'P. COUTINHO'),(21,12,'Marcelo ','1988-05-12','defensa','Real Madrid CF (ESP)',174,80,'MARCELO'),(21,13,'Marquinhos ','1994-05-14','defensa','Paris Saint-Germain FC (FRA)',183,75,'MARQUINHOS'),(21,14,'Danilo ','1991-07-15','defensa','Manchester City FC (ENG)',184,78,'DANILO'),(21,15,'Paulinho ','1988-07-25','volante','FC Barcelona (ESP)',181,81,'PAULINHO'),(21,16,'Cassio ','1987-06-06','arquero','SC Corinthians (BRA)',195,92,'CASSIO'),(21,17,'Fernandinho ','1985-05-04','volante','Manchester City FC (ENG)',179,67,'FERNANDINHO'),(21,18,'Fred ','1993-03-05','volante','FC Shakhtar Donetsk (UKR)',169,64,'FRED'),(21,19,'Willian ','1988-08-09','volante','Chelsea FC (ENG)',175,77,'WILLIAN'),(21,20,'Roberto Firmino','1991-10-02','atacante','Liverpool FC (ENG)',181,76,'FIRMINO'),(21,21,'Taison ','1988-01-13','atacante','FC Shakhtar Donetsk (UKR)',172,64,'TAISON'),(21,22,'Fagner ','1989-06-11','defensa','SC Corinthians (BRA)',168,67,'FAGNER'),(21,23,'Ederson ','1993-08-17','arquero','Manchester City FC (ENG)',188,86,'EDERSON'),(22,1,'Robin Olsen','1990-01-08','arquero','FC Kobenhavn (DEN)',198,89,'OLSEN'),(22,2,'Mikael Lustig','1986-12-13','defensa','Celtic FC (SCO)',189,77,'LUSTIG'),(22,3,'Victor Lindelof','1994-07-17','defensa','Manchester United FC (ENG)',187,81,'LINDELoF'),(22,4,'Andreas Granqvist','1985-04-16','defensa','FC Krasnodar (RUS)',192,84,'GRANQVIST'),(22,5,'Martin Olsson','1988-05-17','defensa','Swansea City AFC (WAL)',177,81,'OLSSON'),(22,6,'Ludwig Augustinsson','1994-04-21','defensa','SV Werder Bremen (GER)',181,76,'AUGUSTINSSON'),(22,7,'Sebastian Larsson','1985-06-06','volante','Hull City FC (ENG)',178,70,'LARSSON'),(22,8,'Albin Ekdal','1989-07-28','volante','Hamburger SV (GER)',186,75,'EKDAL'),(22,9,'Marcus Berg','1986-08-17','atacante','Al Ain FC (UAE)',183,76,'BERG'),(22,10,'Emil Forsberg','1991-10-23','volante','RB Leipzig (GER)',179,78,'FORSBERG'),(22,11,'John Guidetti','1992-04-15','atacante','Deportivo AlavEs (ESP)',185,79,'GUIDETTI'),(22,12,'Karl-Johan Johnsson','1990-01-28','arquero','EA Guingamp (FRA)',187,83,'JOHNSSON'),(22,13,'Gustav Svensson','1987-02-07','volante','Seattle Sounders FC (USA)',183,77,'SVENSSON'),(22,14,'Filip Helander','1993-04-22','defensa','Bologna FC (ITA)',192,83,'HELANDER'),(22,15,'Oscar Hiljemark','1992-06-28','volante','Genoa CFC (ITA)',184,73,'HILJEMARK'),(22,16,'Emil Krafth','1994-08-02','defensa','Bologna FC (ITA)',181,72,'KRAFTH'),(22,17,'Viktor Claesson','1992-01-02','volante','FC Krasnodar (RUS)',183,79,'CLAESSON'),(22,18,'Pontus Jansson','1991-02-13','defensa','Leeds United FC (ENG)',194,89,'JANSSON'),(22,19,'Marcus Rohden','1991-05-11','volante','FC Crotone (ITA)',182,76,'ROHDEN'),(22,20,'Ola Toivonen','1986-07-03','atacante','Toulouse FC (FRA)',192,78,'TOIVONEN'),(22,21,'Jimmy Durmaz','1989-03-22','volante','Toulouse FC (FRA)',180,69,'DURMAZ'),(22,22,'Isaac Kiese Thelin','1992-06-24','atacante','KV Waasland-Beveren (BEL)',189,83,'KIESE THELIN'),(22,23,'Kristoffer Nordfeldt','1989-06-23','arquero','Swansea City AFC (WAL)',190,85,'NORDFELDT'),(23,1,'Yann Sommer','1988-12-17','arquero','VfL Borussia Monchengladbach (GER)',183,81,'SOMMER'),(23,2,'Stephan Lichtsteiner','1984-01-16','defensa','Juventus FC (ITA)',181,77,'LICHTSTEINER'),(23,3,'Francois Moubandje','1990-06-21','defensa','Toulouse FC (FRA)',180,76,'MOUBANDJE'),(23,4,'Nico Elvedi','1996-09-30','defensa','VfL Borussia Monchengladbach (GER)',187,77,'ELVEDI'),(23,5,'Manuel Akanji','1995-07-19','defensa','Borussia Dortmund (GER)',186,85,'AKANJI'),(23,6,'Michael Lang','1991-02-08','defensa','FC Basel (SUI)',185,78,'LANG'),(23,7,'Breel Embolo','1997-02-14','atacante','FC Schalke 04 (GER)',184,86,'EMBOLO'),(23,8,'Remo Freuler','1992-04-15','volante','Atalanta Bergamo (ITA)',181,75,'FREULER'),(23,9,'Haris Seferovic','1992-02-22','atacante','SL Benfica (POR)',186,88,'SEFEROVIC'),(23,10,'Granit Xhaka','1992-09-27','volante','Arsenal FC (ENG)',183,82,'XHAKA'),(23,11,'Valon Behrami','1985-04-19','volante','Udinese Calcio (ITA)',184,78,'BEHRAMI'),(23,12,'Yvon Mvogo','1994-06-06','arquero','RB Leipzig (GER)',186,84,'MVOGO'),(23,13,'Ricardo Rodriguez','1992-08-25','defensa','AC Milan (ITA)',180,79,'RODRIGUEZ'),(23,14,'Steven Zuber','1991-08-17','volante','TSG 1899 Hoffenheim (GER)',182,79,'ZUBER'),(23,15,'Blerim Dzemaili','1986-04-12','volante','Bologna FC (ITA)',180,77,'DZEMAILI'),(23,16,'Gelson Fernandes','1986-09-02','volante','Eintracht Frankfurt (GER)',180,72,'G. FERNANDES'),(23,17,'Denis Zakaria','1996-11-20','volante','VfL Borussia Monchengladbach (GER)',189,77,'ZAKARIA'),(23,18,'Mario Gavranovic','1989-11-24','atacante','GNK Dinamo Zagreb (CRO)',175,75,'GAVRANOVIC'),(23,19,'Josip Drmic','1992-08-08','atacante','VfL Borussia Monchengladbach (GER)',184,78,'DRMIC'),(23,20,'Johan Djourou','1987-01-18','defensa','Antalyaspor AS (TUR)',192,90,'DJOUROU'),(23,21,'Roman Buerki','1990-11-14','arquero','Borussia Dortmund (GER)',188,83,'BuRKI'),(23,22,'Fabian Schaer','1991-12-20','defensa','Deportivo La CoruNa (ESP)',186,83,'SCHAR'),(23,23,'Xherdan Shaqiri','1991-10-10','volante','Stoke City FC (ENG)',165,78,'SHAQIRI'),(24,1,'Seunggyu Kim','1990-09-30','arquero','Vissel Kobe (JPN)',187,80,'S G KIM'),(24,2,'Yong Lee','1986-12-24','defensa','Jeonbuk Hyundai (KOR)',180,74,'Y LEE'),(24,3,'Seunghyun Jung','1994-04-03','defensa','Sagan Tosu FC (JPN)',188,74,'S H JUNG'),(24,4,'Bansuk Oh','1988-05-20','defensa','Jeju United (KOR)',189,79,'B S OH'),(24,5,'Youngsun Yun','1988-10-04','defensa','Seongnam FC (KOR)',185,78,'Y S YUN'),(24,6,'Jooho Park','1987-01-16','defensa','Ulsan Hyundai FC (KOR)',174,71,'J H PARK'),(24,7,'Heungmin Son','1992-07-08','atacante','Tottenham Hotspur FC (ENG)',183,76,'H M SON'),(24,8,'Sejong Ju','1990-10-30','volante','Asan Mugunghwa FC (KOR)',176,70,'S J JU'),(24,9,'Shinwook Kim','1988-04-14','atacante','Jeonbuk Hyundai (KOR)',197,97,'S W KIM'),(24,10,'Seungwoo Lee','1998-01-06','volante','Hellas Verona FC (ITA)',170,63,'S W LEE'),(24,11,'Heechan Hwang','1996-01-26','atacante','FC Red Bull Salzburg (AUT)',177,77,'H C HWANG'),(24,12,'Minwoo Kim','1990-02-25','defensa','Sangju Sangmu FC (KOR)',172,69,'M W KIM'),(24,13,'Jacheol Koo','1989-02-27','volante','FC Augsburg (GER)',182,73,'J C KOO'),(24,14,'Chul Hong','1990-09-17','defensa','Sangju Sangmu FC (KOR)',176,67,'C HONG'),(24,15,'Wooyoung Jung','1989-12-14','volante','Vissel Kobe (JPN)',186,78,'W Y JUNG'),(24,16,'Sungyueng Ki','1989-01-24','volante','Swansea City AFC (WAL)',186,75,'S Y KI'),(24,17,'Jaesung Lee','1992-08-10','volante','Jeonbuk Hyundai (KOR)',180,70,'J S LEE'),(24,18,'Seonmin Moon','1992-06-09','volante','Incheon United FC (KOR)',172,68,'S M MOON'),(24,19,'Younggwon Kim','1990-02-27','defensa','Guangzhou Evergrande FC (CHN)',184,74,'Y G KIM'),(24,20,'Hyunsoo Jang','1991-09-28','defensa','FC Tokyo (JPN)',187,77,'H S JANG'),(24,21,'Jinhyeon Kim','1987-07-06','arquero','Cerezo Osaka (JPN)',193,82,'J H KIM'),(24,22,'Yohan Go','1988-03-10','defensa','FC Seoul (KOR)',170,65,'Y H GO'),(24,23,'Hyeonwoo Jo','1991-09-25','arquero','Daegu FC (KOR)',189,75,'H W JO'),(25,1,'Thibaut Courtois','1992-05-11','arquero','Chelsea FC (ENG)',199,91,'COURTOIS'),(25,2,'Toby Alderweireld','1989-03-02','defensa','Tottenham Hotspur FC (ENG)',186,81,'ALDERWEIRELD'),(25,3,'Thomas Vermaelen','1985-11-14','defensa','FC Barcelona (ESP)',183,80,'VERMAELEN'),(25,4,'Vincent Kompany','1986-04-10','defensa','Manchester City FC (ENG)',190,85,'KOMPANY'),(25,5,'Jan Vertonghen','1987-04-24','defensa','Tottenham Hotspur FC (ENG)',189,86,'VERTONGHEN'),(25,6,'Axel Witsel','1989-01-12','volante','Tianjin Quanjian FC (CHN)',186,73,'WITSEL'),(25,7,'Kevin De Bruyne','1991-06-28','volante','Manchester City FC (ENG)',181,70,'DE BRUYNE'),(25,8,'Marouane Fellaini','1987-11-22','volante','Manchester United FC (ENG)',194,85,'FELLAINI'),(25,9,'Romelu Lukaku','1993-05-13','atacante','Manchester United FC (ENG)',190,94,'R. LUKAKU'),(25,10,'Eden Hazard','1991-01-07','atacante','Chelsea FC (ENG)',173,74,'E. HAZARD'),(25,11,'Yannick Carrasco','1993-09-04','volante','Dalian Yifang FC (CHN)',180,67,'CARRASCO'),(25,12,'Simon Mignolet','1988-03-06','arquero','Liverpool FC (ENG)',193,87,'MIGNOLET'),(25,13,'Koen Casteels','1992-06-25','arquero','VfL Wolfsburg (GER)',197,86,'CASTEELS'),(25,14,'Dries Mertens','1987-05-06','atacante','SSC Napoli (ITA)',169,61,'MERTENS'),(25,15,'Thomas Meunier','1991-09-12','defensa','Paris Saint-Germain FC (FRA)',190,88,'MEUNIER'),(25,16,'Thorgan Hazard','1993-03-29','volante','VfL Borussia Monchengladbach (GER)',174,70,'T. HAZARD'),(25,17,'Youri Tielemans','1997-05-07','volante','AS Monaco (FRA)',176,72,'TIELEMANS'),(25,18,'Adnan Januzaj','1995-02-05','atacante','Real Sociedad (ESP)',180,75,'JANUZAJ'),(25,19,'Moussa Dembele','1987-07-16','volante','Tottenham Hotspur FC (ENG)',185,82,'DEMBELE'),(25,20,'Dedryck Boyata','1990-11-28','defensa','Celtic FC (SCO)',188,84,'BOYATA'),(25,21,'Michy Batshuayi','1993-10-02','atacante','Borussia Dortmund (GER)',185,78,'BATSHUAYI'),(25,22,'Nacer Chadli','1989-08-02','volante','West Bromwich Albion FC (ENG)',187,85,'CHADLI'),(25,23,'Leander Dendoncker','1995-04-15','defensa','RSC Anderlecht (BEL)',188,76,'DENDONCKER'),(26,1,'Farouk Ben Mustapha','1989-07-01','arquero','Al Shabab FC (KSA)',192,85,'BEN MUSTAPHA'),(26,2,'Syam Ben Youssef','1989-03-31','defensa','Kasimpasa SK (TUR)',189,87,'BEN YOUSSEF .S'),(26,3,'Yohan Ben Alouane','1987-03-28','defensa','Leicester City FC (ENG)',185,75,'BEN ALOUANE'),(26,4,'Yassine Meriah','1993-07-02','defensa','CS Sfaxien (TUN)',183,70,'MERIAH'),(26,5,'Oussama Haddadi','1992-01-28','defensa','Dijon FCO (FRA)',185,76,'HADDADI'),(26,6,'Rami Bedoui','1990-01-19','defensa','Etoile du Sahel (TUN)',187,77,'BEDOUI'),(26,7,'Saifeddine Khaoui','1995-04-27','atacante','ES Troyes (FRA)',180,76,'KHAOUI'),(26,8,'Fakhreddine Ben Youssef','1991-06-23','atacante','Al Ittifaq FC (KSA)',189,80,'BEN YOUSSEF .F'),(26,9,'Anice Badri','1990-09-18','volante','ES Tunis (TUN)',178,70,'BADRI'),(26,10,'Wahbi Khazri','1991-02-08','atacante','Stade Rennais FC (FRA)',182,76,'KHAZRI'),(26,11,'Dylan Bronn','1995-06-19','defensa','KAA Gent (BEL)',186,75,'BRONN'),(26,12,'Ali Maaloul','1990-01-01','defensa','Al Ahly SC (EGY)',170,72,'MAALOUL'),(26,13,'Ferjani Sassi','1992-03-18','volante','Al Nassr FC (KSA)',186,80,'SASSI'),(26,14,'Mohamed Ben Amor ','1992-05-03','volante','Al Ahli SC (KSA)',180,75,'BEN AMOR'),(26,15,'Ahmed Khalil','1994-12-21','atacante','Club Africain (TUN)',187,75,'KHALIL'),(26,16,'Aymen Mathlouthi','1984-09-14','arquero','Al Batin FC (KSA)',182,84,'MATHLOUTHI .A'),(26,17,'Ellyes Skhiri','1995-05-10','volante','Montpellier HSC (FRA)',185,69,'SKHIRI JORIS'),(26,18,'Bassem Srarfi','1997-06-25','atacante','OGC Nice (FRA)',176,71,'SRARFI'),(26,19,'Saber Khalifa','1986-10-14','atacante','Club Africain (TUN)',185,72,'KHALIFA'),(26,20,'Ghaylen Chaaleli','1994-02-28','atacante','ES Tunis (TUN)',179,70,'CHAALELI'),(26,21,'Hamdi Naguez','1992-10-28','defensa','Zamalek (EGY)',186,75,'NAGUEZ'),(26,22,'Mouez Hassen','1995-03-05','arquero','LB Chateauroux (FRA)',186,70,'HASSEN'),(26,23,'Naim Sliti','1992-07-27','atacante','Dijon FCO (FRA)',173,65,'SLITI'),(27,1,'Jaime Penedo','1981-09-26','arquero','Dinamo Bucharest (ROU)',183,70,'PENEDO'),(27,2,'Michael Murillo','1996-02-11','defensa','New York Red Bulls (USA)',183,78,'MURILLO'),(27,3,'Harold Cummings','1992-03-01','defensa','San Jose Earthquakes (USA)',183,92,'CUMMINGS'),(27,4,'Fidel Escobar','1995-01-09','defensa','New York Red Bulls (USA)',182,82,'ESCOBAR'),(27,5,'Roman Torres','1986-03-20','defensa','Seattle Sounders FC (USA)',188,99,'R. TORRES'),(27,6,'Gabriel Gomez','1984-05-29','volante','AtlEtico Bucaramanga (COL)',183,82,'GOMEZ'),(27,7,'Blas Perez','1981-03-13','atacante','CSD Municipal (GUA)',187,83,'PEREZ'),(27,8,'Edgar Barcenas','1993-10-23','volante','Cafetaleros de Tapachula (MEX)',175,72,'BARCENAS'),(27,9,'Gabriel Torres','1988-10-31','atacante','CD Huachipato (CHI)',180,77,'G. TORRES'),(27,10,'Ismael Diaz','1997-05-12','atacante','Deportivo La CoruNa (ESP)',181,72,'DIAZ'),(27,11,'Armando Cooper','1987-11-26','volante','Club Universidad de Chile (CHI)',173,72,'COOPER'),(27,12,'Jose Calderon','1985-08-14','arquero','Chorrillo FC (PAN)',187,87,'CALDERON'),(27,13,'Adolfo Machado','1985-02-14','defensa','Houston Dynamo (USA)',182,78,'MACHADO'),(27,14,'Valentin Pimentel','1991-05-30','volante','Plaza Amador (PAN)',189,80,'PIMENTEL'),(27,15,'Eric Davis','1991-03-31','defensa','DAC Dunajska Streda (SVK)',180,81,'DAVIS'),(27,16,'Abdiel Arroyo','1993-12-13','atacante','LD Alajuelense (CRC)',183,82,'ARROYO'),(27,17,'Luis Ovalle','1988-09-07','defensa','CD Olimpia (HON)',178,75,'OVALLE'),(27,18,'Luis Tejada','1982-03-28','atacante','Sport Boys (PER)',183,87,'TEJADA'),(27,19,'Alberto Quintero','1987-12-18','volante','Universitario Lima (PER)',165,62,'QUINTERO'),(27,20,'Anibal Godoy','1990-02-10','volante','San Jose Earthquakes (USA)',183,82,'GODOY'),(27,21,'Jose Luis Rodriguez','1998-06-19','volante','KAA Gent (BEL)',180,77,'J. RODRIGUEZ'),(27,22,'Alex Rodriguez','1990-08-05','arquero','San Francisco FC (PAN)',197,83,'RODRIGUEZ'),(27,23,'Felipe Baloy','1981-02-24','defensa','CSD Municipal (GUA)',185,87,'BALOY'),(28,1,'Jordan Pickford','1994-03-07','arquero','Everton FC (ENG)',185,72,'PICKFORD'),(28,2,'Kyle Walker','1990-05-28','defensa','Manchester City FC (ENG)',178,83,'WALKER'),(28,3,'Danny Rose','1990-07-02','defensa','Tottenham Hotspur FC (ENG)',173,76,'ROSE'),(28,4,'Eric Dier','1994-01-15','volante','Tottenham Hotspur FC (ENG)',188,90,'DIER'),(28,5,'John Stones','1994-05-28','defensa','Manchester City FC (ENG)',188,72,'STONES'),(28,6,'Harry Maguire','1993-03-05','defensa','Leicester City FC (ENG)',193,98,'MAGUIRE'),(28,7,'Jesse Lingard','1992-12-15','volante','Manchester United FC (ENG)',175,60,'LINGARD'),(28,8,'Jordan Henderson','1990-06-17','volante','Liverpool FC (ENG)',183,82,'HENDERSON'),(28,9,'Harry Kane','1993-07-28','atacante','Tottenham Hotspur FC (ENG)',188,98,'KANE'),(28,10,'Raheem Sterling','1994-12-08','atacante','Manchester City FC (ENG)',170,70,'STERLING'),(28,11,'Jamie Vardy','1987-01-11','atacante','Leicester City FC (ENG)',178,80,'VARDY'),(28,12,'Kieran Trippier','1990-09-19','defensa','Tottenham Hotspur FC (ENG)',178,72,'TRIPPIER'),(28,13,'Jack Butland','1993-03-10','arquero','Stoke City FC (ENG)',196,96,'BUTLAND'),(28,14,'Danny Welbeck','1990-11-26','atacante','Arsenal FC (ENG)',184,78,'WELBECK'),(28,15,'Gary Cahill','1985-12-19','defensa','Chelsea FC (ENG)',191,85,'CAHILL'),(28,16,'Phil Jones','1992-02-21','defensa','Manchester United FC (ENG)',182,72,'JONES'),(28,17,'Fabian Delph','1989-11-21','defensa','Manchester City FC (ENG)',174,78,'DELPH'),(28,18,'Ashley Young','1985-07-09','defensa','Manchester United FC (ENG)',175,78,'YOUNG'),(28,19,'Marcus Rashford','1997-10-31','atacante','Manchester United FC (ENG)',180,78,'RASHFORD'),(28,20,'Dele Alli','1996-04-11','volante','Tottenham Hotspur FC (ENG)',188,76,'DELE'),(28,21,'Ruben Loftus-Cheek','1996-01-23','volante','Chelsea FC (ENG)',190,73,'LOFTUS-CHEEK'),(28,22,'Trent Alexander-Arnold','1998-10-07','defensa','Liverpool FC (ENG)',175,70,'ALEXANDER-ARNOLD'),(28,23,'Nick Pope','1992-04-19','arquero','Burnley FC (ENG)',191,76,'POPE'),(29,1,'David Ospina','1988-08-31','arquero','Arsenal FC (ENG)',183,80,'OSPINA'),(29,2,'Cristian Zapata','1986-09-30','defensa','AC Milan (ITA)',187,82,'C. ZAPATA'),(29,3,'Oscar Murillo','1988-04-18','defensa','CF Pachuca (MEX)',184,80,'O. MURILLO'),(29,4,'Santiago Arias','1992-01-13','defensa','PSV Eindhoven (NED)',177,71,'ARIAS'),(29,5,'Wilmar Barrios','1993-10-16','volante','CA Boca Juniors (ARG)',178,74,'BARRIOS'),(29,6,'Carlos Sanchez','1986-02-06','volante','RCD Espanyol (ESP)',182,82,'C. SANCHEZ'),(29,7,'Carlos Bacca','1986-09-08','atacante','Villarreal CF (ESP)',181,77,'BACCA'),(29,8,'Abel Aguilar','1985-01-06','volante','AC Deportivo Cali (COL)',185,82,'AGUILAR T.'),(29,9,'Radamel Falcao','1986-02-10','atacante','AS Monaco (FRA)',177,72,'FALCAO'),(29,10,'James Rodriguez','1991-07-12','volante','FC Bayern Munchen (GER)',180,75,'JAMES'),(29,11,'Juan Cuadrado','1988-05-26','volante','Juventus FC (ITA)',179,72,'CUADRADO'),(29,12,'Camilo Vargas','1989-03-09','arquero','AC Deportivo Cali (COL)',185,80,'C. VARGAS'),(29,13,'Yerry Mina','1994-09-23','defensa','FC Barcelona (ESP)',194,95,'Y. MINA'),(29,14,'Luis Muriel','1991-04-16','atacante','Sevilla FC (ESP)',178,79,'L. MURIEL'),(29,15,'Mateus Uribe','1991-03-21','volante','Club AmErica (MEX)',182,71,'M. URIBE'),(29,16,'Jefferson Lerma','1994-10-25','volante','Levante UD (ESP)',179,70,'J. LERMA'),(29,17,'Johan Mojica','1992-08-21','defensa','Girona FC (ESP)',185,66,'J. MOJICA'),(29,18,'Frank Fabra','1991-02-22','defensa','CA Boca Juniors (ARG)',172,72,'FABRA'),(29,19,'Miguel Borja','1993-01-26','atacante','SE Palmeiras (BRA)',183,74,'M. BORJA'),(29,20,'Juan Quintero','1993-01-18','volante','CA River Plate (ARG)',169,64,'J. QUINTERO'),(29,21,'Jose Izquierdo','1992-07-07','atacante','Brighton & Hove Albion FC (ENG)',171,73,'IZQUIERDO'),(29,22,'Jose Cuadrado','1985-06-01','arquero','CD Once Caldas (COL)',180,80,'J.F. CUADRADO'),(29,23,'Davinson Sanchez','1996-06-12','defensa','Tottenham Hotspur FC (ENG)',187,81,'D. SANCHEZ'),(30,1,'Wojciech Szczesny','1990-04-18','arquero','Juventus FC (ITA)',195,84,'SZCZESNY'),(30,2,'Michal Pazdan','1987-09-21','defensa','Legia Warsaw (POL)',181,78,'PAZDAN'),(30,3,'Artur Jedrzejczyk','1987-11-04','defensa','Legia Warsaw (POL)',189,78,'JEDRZEJCZYK'),(30,4,'Thiago Cionek','1986-04-21','defensa','SPAL Ferrara (ITA)',184,81,'CIONEK'),(30,5,'Jan Bednarek','1996-04-12','defensa','Southampton FC (ENG)',189,77,'BEDNAREK'),(30,6,'Jacek Goralski','1992-09-21','volante','PFC Ludogorets Razgrad (BUL)',172,66,'GORALSKI'),(30,7,'Arkadiusz Milik','1994-02-28','atacante','SSC Napoli (ITA)',186,81,'MILIK'),(30,8,'Karol Linetty','1995-02-02','volante','UC Sampdoria (ITA)',176,73,'LINETTY'),(30,9,'Robert Lewandowski','1988-08-21','atacante','FC Bayern Munchen (GER)',185,79,'LEWANDOWSKI'),(30,10,'Grzegorz Krychowiak','1990-01-29','volante','West Bromwich Albion FC (ENG)',186,83,'KRYCHOWIAK'),(30,11,'Kamil Grosicki','1988-06-08','volante','Hull City FC (ENG)',180,78,'GROSICKI'),(30,12,'Bartosz Bialkowski','1987-07-06','arquero','Ipswich Town FC (ENG)',194,83,'BIALKOWSKI'),(30,13,'Maciej Rybus','1989-08-19','volante','FC Lokomotiv Moscow (RUS)',173,75,'RYBUS'),(30,14,'Lukasz Teodorczyk','1991-06-03','atacante','RSC Anderlecht (BEL)',185,78,'TEODORCZYK'),(30,15,'Kamil Glik','1988-02-03','defensa','AS Monaco (FRA)',190,80,'GLIK'),(30,16,'Jakub Blaszczykowski','1985-12-14','volante','VfL Wolfsburg (GER)',175,71,'BLASZCZYKOWSKI'),(30,17,'Slawomir Peszko','1985-02-19','volante','Lechia Gdansk (POL)',173,68,'PESZKO'),(30,18,'Bartosz Bereszynski','1992-07-12','defensa','UC Sampdoria (ITA)',182,72,'BERESZYNSKI'),(30,19,'Piotr Zielinski','1994-05-20','volante','SSC Napoli (ITA)',177,64,'ZIELINSKI'),(30,20,'Lukasz Piszczek','1985-06-03','defensa','Borussia Dortmund (GER)',184,79,'PISZCZEK'),(30,21,'Rafal Kurzawa','1993-01-29','volante','Gornik Zabrze (POL)',182,73,'KURZAWA'),(30,22,'Lukasz Fabianski','1985-04-18','arquero','Swansea City AFC (WAL)',190,83,'FABIANSKI'),(30,23,'Dawid Kownacki','1997-03-14','atacante','UC Sampdoria (ITA)',185,75,'KOWNACKI'),(31,1,'Eiji Kawashima','1983-03-20','arquero','FC Metz (FRA)',185,74,'KAWASHIMA'),(31,2,'Naomichi Ueda','1994-10-24','defensa','Kashima Antlers (JPN)',186,79,'UEDA'),(31,3,'Gen Shoji','1992-12-11','defensa','Kashima Antlers (JPN)',182,74,'SHOJI'),(31,4,'Keisuke Honda','1986-06-13','volante','CF Pachuca (MEX)',182,74,'HONDA'),(31,5,'Yuto Nagatomo','1986-09-12','defensa','Galatasaray SK (TUR)',170,68,'NAGATOMO'),(31,6,'Wataru Endo','1993-02-09','defensa','Urawa Reds (JPN)',178,75,'ENDO'),(31,7,'Gaku Shibasaki','1992-05-28','volante','Getafe CF (ESP)',175,64,'SHIBASAKI'),(31,8,'Genki Haraguchi','1991-05-09','volante','Fortuna Dusseldorf (GER)',178,68,'HARAGUCHI'),(31,9,'Shinji Okazaki','1986-04-16','atacante','Leicester City FC (ENG)',174,70,'OKAZAKI'),(31,10,'Shinji Kagawa','1989-03-17','volante','Borussia Dortmund (GER)',175,68,'KAGAWA'),(31,11,'Takashi Usami','1992-05-06','volante','Fortuna Dusseldorf (GER)',178,72,'USAMI'),(31,12,'Masaaki Higashiguchi','1986-05-12','arquero','Gamba Osaka (JPN)',184,78,'HIGASHIGUCHI'),(31,13,'Yoshinori Muto','1992-07-15','atacante','FSV Mainz 05 (GER)',179,72,'MUTO'),(31,14,'Takashi Inui','1988-06-02','volante','SD Eibar (ESP)',169,59,'INUI'),(31,15,'Yuya Osako','1990-05-18','atacante','1. FC Koln (GER)',182,71,'OSAKO'),(31,16,'Hotaru Yamaguchi','1990-10-06','volante','Cerezo Osaka (JPN)',173,72,'YAMAGUCHI'),(31,17,'Makoto Hasebe','1984-01-18','volante','Eintracht Frankfurt (GER)',180,72,'HASEBE'),(31,18,'Ryota Oshima','1993-01-23','volante','Kawasaki Frontale (JPN)',168,64,'OHSHIMA'),(31,19,'Hiroki Sakai','1990-04-12','defensa','Olympique Marseille (FRA)',183,70,'H. SAKAI'),(31,20,'Tomoaki Makino','1987-05-11','defensa','Urawa Reds (JPN)',182,77,'MAKINO'),(31,21,'Gotoku Sakai','1991-03-14','defensa','Hamburger SV (GER)',176,74,'G. SAKAI'),(31,22,'Maya Yoshida','1988-08-24','defensa','Southampton FC (ENG)',189,78,'YOSHIDA'),(31,23,'Kosuke Nakamura','1995-02-27','arquero','Kashiwa Reysol (JPN)',184,72,'NAKAMURA'),(32,1,'Abdoulaye Diallo','1992-03-30','arquero','Stade Rennais FC (FRA)',189,79,'DIALLO'),(32,2,'Saliou Ciss','1989-06-15','defensa','Valenciennes FC (FRA)',173,69,'CISS'),(32,3,'Kalidou Koulibaly','1991-06-20','defensa','SSC Napoli (ITA)',195,89,'KOULIBALY'),(32,4,'Kara Mbodji','1989-11-22','defensa','RSC Anderlecht (BEL)',192,85,'KARA'),(32,5,'Idrissa Gana Gueye','1989-09-26','volante','Everton FC (ENG)',174,64,'GANA'),(32,6,'Salif Sane','1990-08-25','volante','Hannover 96 (GER)',196,84,'S. SANE'),(32,7,'Moussa Sow','1986-01-19','atacante','Bursaspor (TUR)',180,75,'SOW'),(32,8,'Cheikhou Kouyate','1989-12-21','volante','West Ham United FC (ENG)',189,75,'C. KOUYATE'),(32,9,'Mame Diouf','1987-12-16','atacante','Stoke City FC (ENG)',185,81,'M. DIOUF'),(32,10,'Sadio Mane','1992-04-10','atacante','Liverpool FC (ENG)',175,69,'MANE'),(32,11,'Cheikh Ndoye','1986-03-29','volante','Birmingham City FC (ENG)',192,90,'CH. NDOYE'),(32,12,'Youssouf Sabaly','1993-03-05','defensa','FC Girondins Bordeaux (FRA)',174,71,'SABALY'),(32,13,'Alfred Ndiaye','1990-03-06','volante','Wolverhampton Wanderers FC (ENG)',186,80,'A. NDIAYE'),(32,14,'Moussa Konate','1993-04-03','atacante','Amiens SC (FRA)',180,78,'KONATE'),(32,15,'Diafra Sakho','1989-12-24','atacante','Stade Rennais FC (FRA)',184,79,'SAKHO'),(32,16,'Khadim Ndiaye','1985-04-05','arquero','Horoya AC (GUI)',185,80,'KH. NDIAYE'),(32,17,'Pape Alioune Ndiaye','1990-10-27','volante','Stoke City FC (ENG)',181,74,'P.A. NDIAYE'),(32,18,'Ismaila Sarr','1998-02-25','atacante','Stade Rennais FC (FRA)',175,70,'ISMAILA'),(32,19,'Mbaye Niang','1994-12-19','atacante','Torino FC (ITA)',184,74,'NIANG'),(32,20,'Keita Balde','1995-03-08','atacante','AS Monaco (FRA)',181,77,'KEITA BALDE'),(32,21,'Lamine Gassama','1989-10-20','defensa','Adanaspor (TUR)',181,74,'GASSAMA'),(32,22,'Moussa Wague','1998-10-04','defensa','KAS Eupen (BEL)',177,70,'M. WAGUE'),(32,23,'Alfred Gomis','1993-09-05','arquero','SPAL Ferrara (ITA)',196,80,'GOMIS'); /*!40000 ALTER TABLE `jugador` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `partido` -- DROP TABLE IF EXISTS `partido`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `partido` ( `idpartido` int(2) unsigned NOT NULL, `fecha` datetime NOT NULL, `idest` int(2) unsigned DEFAULT NULL, `local` int(2) unsigned DEFAULT NULL, `visita` int(2) unsigned DEFAULT NULL, `gol_local` int(2) unsigned zerofill DEFAULT NULL, `gol_visita` int(2) unsigned zerofill DEFAULT NULL, `tipo` enum('grupo','octavos','cuartos','semifinal','tercer puesto','final') DEFAULT NULL, PRIMARY KEY (`idpartido`), KEY `fk_local` (`local`), KEY `fk_visita` (`visita`), CONSTRAINT `fk_visita` FOREIGN KEY (`visita`) REFERENCES `seleccion` (`idsel`), CONSTRAINT `fk_local` FOREIGN KEY (`local`) REFERENCES `seleccion` (`idsel`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `partido` -- LOCK TABLES `partido` WRITE; /*!40000 ALTER TABLE `partido` DISABLE KEYS */; INSERT INTO `partido` VALUES (1,'2018-06-14 18:00:00',6,1,3,05,00,'grupo'),(2,'2018-06-15 17:00:00',1,2,4,00,01,'grupo'),(3,'2018-06-15 18:00:00',2,5,7,00,01,'grupo'),(4,'2018-06-15 21:00:00',3,6,8,03,03,'grupo'),(5,'2018-06-16 13:00:00',5,9,11,02,01,'grupo'),(6,'2018-06-16 16:00:00',11,10,12,01,01,'grupo'),(7,'2018-06-16 19:00:00',7,13,15,00,01,'grupo'),(8,'2018-06-16 21:00:00',4,14,16,02,00,'grupo'),(9,'2018-06-17 16:00:00',10,17,19,00,01,'grupo'),(10,'2018-06-17 18:00:00',6,18,20,00,01,'grupo'),(11,'2018-06-17 21:00:00',9,21,23,01,01,'grupo'),(12,'2018-06-18 15:00:00',8,22,24,01,00,'grupo'),(13,'2018-06-18 18:00:00',3,25,27,03,00,'grupo'),(14,'2018-06-18 21:00:00',12,26,28,01,02,'grupo'),(15,'2018-06-19 15:00:00',7,29,31,01,02,'grupo'),(16,'2018-06-19 18:00:00',11,30,32,01,02,'grupo'),(17,'2018-06-19 21:00:00',2,1,2,03,01,'grupo'),(18,'2018-06-20 15:00:00',6,6,5,01,00,'grupo'),(19,'2018-06-20 18:00:00',9,4,3,01,00,'grupo'),(20,'2018-06-20 21:00:00',5,7,8,00,01,'grupo'),(21,'2018-06-21 16:00:00',10,15,11,01,01,'grupo'),(22,'2018-06-21 20:00:00',1,9,13,01,00,'grupo'),(23,'2018-06-21 21:00:00',8,10,14,00,03,'grupo'),(24,'2018-06-22 15:00:00',2,21,17,02,00,'grupo'),(25,'2018-06-22 18:00:00',12,16,12,02,00,'grupo'),(26,'2018-06-22 20:00:00',4,19,23,01,02,'grupo'),(27,'2018-06-23 15:00:00',11,25,26,05,02,'grupo'),(28,'2018-06-23 18:00:00',9,24,20,01,02,'grupo'),(29,'2018-06-23 21:00:00',3,18,22,02,01,'grupo'),(30,'2018-06-24 15:00:00',8,28,27,06,01,'grupo'),(31,'2018-06-24 20:00:00',1,31,32,02,02,'grupo'),(32,'2018-06-24 21:00:00',5,30,29,00,03,'grupo'),(33,'2018-06-25 17:00:00',12,3,2,03,00,'grupo'),(34,'2018-06-25 18:00:00',10,4,1,02,01,'grupo'),(35,'2018-06-25 20:00:00',4,8,5,02,02,'grupo'),(36,'2018-06-25 21:00:00',7,7,6,01,01,'grupo'),(37,'2018-06-26 17:00:00',3,11,13,00,02,'grupo'),(38,'2018-06-26 17:00:00',6,15,9,00,00,'grupo'),(39,'2018-06-26 21:00:00',2,16,10,01,02,'grupo'),(40,'2018-06-26 21:00:00',9,12,14,01,02,'grupo'),(41,'2018-06-27 17:00:00',5,24,18,02,00,'grupo'),(42,'2018-06-27 19:00:00',1,20,22,00,03,'grupo'),(43,'2018-06-27 21:00:00',11,19,21,00,02,'grupo'),(44,'2018-06-27 21:00:00',8,23,17,02,02,'grupo'),(45,'2018-06-28 17:00:00',12,31,30,00,01,'grupo'),(46,'2018-06-28 18:00:00',10,32,29,00,01,'grupo'),(47,'2018-06-28 20:00:00',4,28,25,01,02,'grupo'),(48,'2018-06-28 21:00:00',7,27,26,00,01,'grupo'),(49,'2018-06-30 17:00:00',5,9,10,04,03,'octavos'),(50,'2018-06-30 21:00:00',3,4,6,02,01,'octavos'),(51,'2018-07-01 17:00:00',6,8,1,01,01,'octavos'),(52,'2018-07-01 21:00:00',8,14,15,01,01,'octavos'),(53,'2018-07-02 18:00:00',10,21,20,02,00,'octavos'),(54,'2018-07-02 21:00:00',9,25,31,03,02,'octavos'),(55,'2018-07-03 17:00:00',2,22,23,01,00,'octavos'),(56,'2018-07-03 21:00:00',11,29,28,01,01,'octavos'),(57,'2018-07-06 17:00:00',8,4,9,00,02,'cuartos'),(58,'2018-07-06 21:00:00',5,21,25,01,02,'cuartos'),(59,'2018-07-07 18:00:00',10,22,28,00,02,'cuartos'),(60,'2018-07-07 21:00:00',3,1,14,02,02,'cuartos'),(61,'2018-07-10 21:00:00',2,9,25,01,00,'semifinal'),(62,'2018-07-11 21:00:00',6,14,28,02,01,'semifinal'),(63,'2018-07-14 17:00:00',2,25,28,02,00,'tercer puesto'),(64,'2018-07-15 18:00:00',6,9,14,04,02,'final'); /*!40000 ALTER TABLE `partido` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `seleccion` -- DROP TABLE IF EXISTS `seleccion`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `seleccion` ( `idsel` int(2) unsigned NOT NULL DEFAULT '0', `nombre` varchar(14) NOT NULL, `grupo` enum('A','B','C','D','E','F','G','H') NOT NULL, `confederacion` char(8) NOT NULL, `dt` varchar(20) NOT NULL, PRIMARY KEY (`idsel`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `seleccion` -- LOCK TABLES `seleccion` WRITE; /*!40000 ALTER TABLE `seleccion` DISABLE KEYS */; INSERT INTO `seleccion` VALUES (1,'Rusia','A','UEFA','Stanislav Cherchesov'),(2,'Egipto','A','CAF','Hector Cuper'),(3,'Arabia Saudita','A','AFC','Juan Antonio Pizzi'),(4,'Uruguay','A','CONMEBOL','Oscar Tabarez'),(5,'Marruecos','B','CAF','Herve Renard'),(6,'Portugal','B','UEFA','Fernando Santos'),(7,'Iran','B','AFC','Carlos Queiroz'),(8,'España','B','UEFA','Fernando Hierro'),(9,'Francia','C','UEFA','Didier Deschamps'),(10,'Argentina','C','CONMEBOL','Jorge Sampaoli'),(11,'Australia','C','AFC','Bert Van Marwijk'),(12,'Islandia','C','UEFA','Heimir Hallgrimsson'),(13,'Peru','D','CONMEBOL','Ricardo Gareca'),(14,'Croacia','D','UEFA','Zlatko DaliC'),(15,'Dinamarca','D','UEFA','Age Hareide'),(16,'Nigeria','D','CAF','Gernot Rohr'),(17,'Costa Rica','E','CONCACAF','Oscar Ramirez'),(18,'Alemania','E','UEFA','Joachim Low'),(19,'Serbia','E','UEFA','Mladen Krstavic'),(20,'Mexico','E','CONCACAF','Juan Carlos Osorio'),(21,'Brasil','F','CONMEBOL','Tite'),(22,'Suecia','F','UEFA','Janne Andersson'),(23,'Suiza','F','UEFA','Vladimir Petkovic'),(24,'Corea','F','AFC','Shin Taeyong'),(25,'Belgica','G','UEFA','Roberto Martinez'),(26,'Tunez','G','CAF','Nabil Maaloul'),(27,'Panama','G','CONCACAF','Hernan Gomez'),(28,'Inglaterra','G','UEFA','Gareth Southgate'),(29,'Colombia','H','CONMEBOL','Jose Perkerman'),(30,'Polonia','H','UEFA','Adam Nawalka'),(31,'Japon','H','AFC','Akira Nishino'),(32,'Senegal','H','CAF','Aliou Cisse'); /*!40000 ALTER TABLE `seleccion` ENABLE KEYS */; UNLOCK TABLES; /*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */; /*!40101 SET SQL_MODE=@OLD_SQL_MODE */; /*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */; /*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */; /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */; /*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */; /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */; /*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */; -- Dump completed on 2021-09-13 19:02:55