From the following tables, write a SQL query to find the player who was selected for the ‘Man of the Match’ award in the finals of EURO cup 2016
- برمجة سي كيو ال sql
- 2021-09-04
- mhanasmh00489829403
From the following tables, write a SQL query to find the player who was selected for the ‘Man of the Match’ award in the finals of EURO cup 2016.Return player name, country name.
Sample table: soccer_country
country_id | country_abbr | country_name ------------+--------------+--------------------- 1201 | ALB | Albania 1202 | AUT | Austria 1203 | BEL | Belgium 1204 | CRO | Croatia 1205 | CZE | Czech Republic 1206 | ENG | England 1207 | FRA | France 1208 | GER | Germany 1209 | HUN | Hungary 1210 | ISL | Iceland 1211 | ITA | Italy 1212 | NIR | Northern Ireland 1213 | POL | Poland 1214 | POR | Portugal 1215 | IRL | Republic of Ireland 1216 | ROU | Romania 1217 | RUS | Russia 1218 | SVK | Slovakia 1219 | ESP | Spain 1220 | SWE | Sweden 1221 | SUI | Switzerland 1222 | TUR | Turkey 1223 | UKR | Ukraine 1224 | WAL | Wales 1225 | SLO | Slovenia 1226 | NED | Netherlands 1227 | SRB | Serbia 1228 | SCO | Scotland 1229 | NOR | Norway
match_no | play_stage | play_date | results | decided_by | goal_score | venue_id | referee_id | audence | plr_of_match | stop1_sec | stop2_sec ----------+------------+------------+---------+------------+------------+----------+------------+---------+--------------+-----------+----------- 1 | G | 2016-06-11 | WIN | N | 2-1 | 20008 | 70007 | 75113 | 160154 | 131 | 242 2 | G | 2016-06-11 | WIN | N | 0-1 | 20002 | 70012 | 33805 | 160476 | 61 | 182 3 | G | 2016-06-11 | WIN | N | 2-1 | 20001 | 70017 | 37831 | 160540 | 64 | 268 4 | G | 2016-06-12 | DRAW | N | 1-1 | 20005 | 70011 | 62343 | 160128 | 0 | 185 5 | G | 2016-06-12 | WIN | N | 0-1 | 20007 | 70006 | 43842 | 160084 | 125 | 325 6 | G | 2016-06-12 | WIN | N | 1-0 | 20006 | 70014 | 33742 | 160291 | 2 | 246 7 | G | 2016-06-13 | WIN | N | 2-0 | 20003 | 70002 | 43035 | 160176 | 89 | 188 8 | G | 2016-06-13 | WIN | N | 1-0 | 20010 | 70009 | 29400 | 160429 | 360 | 182 9 | G | 2016-06-13 | DRAW | N | 1-1 | 20008 | 70010 | 73419 | 160335 | 67 | 194 10 | G | 2016-06-14 | WIN | N | 0-2 | 20004 | 70005 | 55408 | 160244 | 63 | 189 11 | G | 2016-06-14 | WIN | N | 0-2 | 20001 | 70018 | 34424 | 160197 | 61 | 305 12 | G | 2016-06-15 | DRAW | N | 1-1 | 20009 | 70004 | 38742 | 160320 | 15 | 284 13 | G | 2016-06-15 | WIN | N | 1-2 | 20003 | 70001 | 38989 | 160405 | 62 | 189 14 | G | 2016-06-15 | DRAW | N | 1-1 | 20007 | 70015 | 43576 | 160477 | 74 | 206 15 | G | 2016-06-16 | WIN | N | 2-0 | 20005 | 70013 | 63670 | 160154 | 71 | 374 16 | G | 2016-06-16 | WIN | N | 2-1 | 20002 | 70003 | 34033 | 160540 | 62 | 212 17 | G | 2016-06-16 | WIN | N | 0-2 | 20004 | 70016 | 51043 | 160262 | 7 | 411 18 | G | 2016-06-17 | DRAW | N | 0-0 | 20008 | 70008 | 73648 | 160165 | 6 | 208 19 | G | 2016-06-17 | WIN | N | 1-0 | 20010 | 70007 | 29600 | 160248 | 2 | 264 20 | G | 2016-06-17 | DRAW | N | 2-2 | 20009 | 70005 | 38376 | 160086 | 71 | 280 21 | G | 2016-06-18 | WIN | N | 3-0 | 20006 | 70010 | 33409 | 160429 | 84 | 120 22 | G | 2016-06-18 | WIN | N | 3-0 | 20001 | 70004 | 39493 | 160064 | 11 | 180 23 | G | 2016-06-18 | DRAW | N | 1-1 | 20005 | 70015 | 60842 | 160230 | 61 | 280 24 | G | 2016-06-19 | DRAW | N | 0-0 | 20007 | 70011 | 44291 | 160314 | 3 | 200 25 | G | 2016-06-20 | WIN | N | 0-1 | 20004 | 70016 | 49752 | 160005 | 125 | 328 26 | G | 2016-06-20 | DRAW | N | 0-0 | 20003 | 70001 | 45616 | 160463 | 60 | 122 27 | G | 2016-06-21 | WIN | N | 0-3 | 20010 | 70006 | 28840 | 160544 | 62 | 119 28 | G | 2016-06-21 | DRAW | N | 0-0 | 20009 | 70012 | 39051 | 160392 | 62 | 301 29 | G | 2016-06-21 | WIN | N | 0-1 | 20005 | 70017 | 58874 | 160520 | 29 | 244 30 | G | 2016-06-21 | WIN | N | 0-1 | 20007 | 70018 | 44125 | 160177 | 21 | 195 31 | G | 2016-06-22 | WIN | N | 0-2 | 20002 | 70013 | 32836 | 160504 | 60 | 300 32 | G | 2016-06-22 | WIN | N | 2-1 | 20001 | 70008 | 37245 | 160085 | 70 | 282 33 | G | 2016-06-22 | WIN | N | 2-1 | 20008 | 70009 | 68714 | 160220 | 7 | 244 34 | G | 2016-06-22 | DRAW | N | 3-3 | 20004 | 70002 | 55514 | 160322 | 70 | 185 35 | G | 2016-06-23 | WIN | N | 0-1 | 20003 | 70014 | 44268 | 160333 | 79 | 221 36 | G | 2016-06-23 | WIN | N | 0-1 | 20006 | 70003 | 34011 | 160062 | 63 | 195 37 | R | 2016-06-25 | WIN | P | 1-1 | 20009 | 70005 | 38842 | 160476 | 126 | 243 38 | R | 2016-06-25 | WIN | N | 1-0 | 20007 | 70002 | 44342 | 160547 | 5 | 245 39 | R | 2016-06-26 | WIN | N | 0-1 | 20002 | 70012 | 33523 | 160316 | 61 | 198 40 | R | 2016-06-26 | WIN | N | 2-1 | 20004 | 70011 | 56279 | 160160 | 238 | 203 41 | R | 2016-06-26 | WIN | N | 3-0 | 20003 | 70009 | 44312 | 160173 | 62 | 124 42 | R | 2016-06-27 | WIN | N | 0-4 | 20010 | 70010 | 28921 | 160062 | 3 | 133 43 | R | 2016-06-27 | WIN | N | 2-0 | 20008 | 70004 | 76165 | 160235 | 63 | 243 44 | R | 2016-06-28 | WIN | N | 1-2 | 20006 | 70001 | 33901 | 160217 | 5 | 199 45 | Q | 2016-07-01 | WIN | P | 1-1 | 20005 | 70003 | 62940 | 160316 | 58 | 181 46 | Q | 2016-07-02 | WIN | N | 3-1 | 20003 | 70001 | 45936 | 160550 | 14 | 182 47 | Q | 2016-07-03 | WIN | P | 1-1 | 20001 | 70007 | 38764 | 160163 | 63 | 181 48 | Q | 2016-07-04 | WIN | N | 5-2 | 20008 | 70008 | 76833 | 160159 | 16 | 125 49 | S | 2016-07-07 | WIN | N | 2-0 | 20004 | 70006 | 55679 | 160322 | 2 | 181 50 | S | 2016-07-08 | WIN | N | 2-0 | 20005 | 70011 | 64078 | 160160 | 126 | 275 51 | F | 2016-07-11 | WIN | N | 1-0 | 20008 | 70005 | 75868 | 160307 | 161 | 181
player_id | team_id | jersey_no | player_name | posi_to_play | dt_of_bir | age | playing_club -----------+---------+-----------+-------------------------+--------------+------------+-----+--------------------- 160001 | 1201 | 1 | Etrit Berisha | GK | 1989-03-10 | 27 | Lazio 160008 | 1201 | 2 | Andi Lila | DF | 1986-02-12 | 30 | Giannina 160016 | 1201 | 3 | Ermir Lenjani | MF | 1989-08-05 | 26 | Nantes 160007 | 1201 | 4 | Elseid Hysaj | DF | 1994-02-20 | 22 | Napoli 160013 | 1201 | 5 | Lorik Cana | MF | 1983-07-27 | 32 | Nantes 160010 | 1201 | 6 | Frederic Veseli | DF | 1992-11-20 | 23 | Lugano 160004 | 1201 | 7 | Ansi Agolli | DF | 1982-10-11 | 33 | Qarabag 160012 | 1201 | 8 | Migjen Basha | MF | 1987-01-05 | 29 | Como 160017 | 1201 | 9 | Ledian Memushaj | MF | 1986-12-17 | 29 | Pescara 160023 | 1201 | 10 | Armando Sadiku | FD | 1991-05-27 | 25 | Vaduz 160022 | 1201 | 11 | Shkelzen Gashi | FD | 1988-07-15 | 27 | Colorado 160003 | 1201 | 12 | Orges Shehi | GK | 1977-09-25 | 38 | Skenderbeu 160015 | 1201 | 13 | Burim Kukeli | MF | 1984-01-16 | 32 | Zurich 160019 | 1201 | 14 | Taulant Xhaka | MF | 1991-03-28 | 25 | Basel 160009 | 1201 | 15 | Mergim Mavraj | DF | 1986-06-09 | 30 | Koln 160021 | 1201 | 16 | Sokol Cikalleshi | FD | 1990-07-27 | 25 | Istanbul Basaksehir 160006 | 1201 | 17 | Naser Aliji | DF | 1993-12-27 | 22 | Basel 160005 | 1201 | 18 | Arlind Ajeti | DF | 1993-09-25 | 22 | Frosinone 160020 | 1201 | 19 | Bekim Balaj | FD | 1991-01-11 | 25 | Rijeka 160014 | 1201 | 20 | Ergys Kace | MF | 1993-07-08 | 22 | PAOK 160018 | 1201 | 21 | Odise Roshi | MF | 1991-05-22 | 25 | Rijeka 160011 | 1201 | 22 | Amir Abrashi | MF | 1990-03-27 | 26 | Freiburg 160002 | 1201 | 23 | Alban Hoxha | GK | 1987-11-23 | 28 | Partizani 160024 | 1202 | 1 | Robert Almer | GK | 1984-03-20 | 32 | Austria Wien 160036 | 1202 | 2 | Gyorgy Garics | MF | 1984-03-08 | 32 | Darmstadt 160027 | 1202 | 3 | Aleksandar Dragovic | DF | 1991-03-06 | 25 | Dynamo Kyiv 160029 | 1202 | 4 | Martin Hinteregger | DF | 1992-09-07 | 23 | Monchengladbach 160028 | 1202 | 5 | Christian Fuchs | DF | 1986-04-07 | 30 | Leicester 160038 | 1202 | 6 | Stefan Ilsanker | MF | 1989-05-18 | 27 | Leipzig 160043 | 1202 | 7 | Marko Arnautovic | FD | 1989-04-19 | 27 | Stoke 160034 | 1202 | 8 | David Alaba | MF | 1992-06-24 | 23 | Bayern 160046 | 1202 | 9 | Rubin Okotie | FD | 1987-06-06 | 29 | 1860 Munchen 160040 | 1202 | 10 | Zlatko Junuzovic | MF | 1987-09-26 | 28 | Bremen 160037 | 1202 | 11 | Martin Harnik | MF | 1987-06-10 | 29 | Stuttgart 160025 | 1202 | 12 | Heinz Lindner | GK | 1990-07-17 | 25 | Frankfurt 160032 | 1202 | 13 | Markus Suttner | DF | 1987-04-16 | 29 | Ingolstadt 160035 | 1202 | 14 | Julian Baumgartlinger | MF | 1988-01-02 | 28 | Mainz 160031 | 1202 | 15 | Sebastian Prodl | DF | 1987-06-21 | 28 | Watford 160033 | 1202 | 16 | Kevin Wimmer | DF | 1992-11-15 | 23 | Tottenham 160030 | 1202 | 17 | Florian Klein | DF | 1986-11-17 | 29 | Stuttgart 160042 | 1202 | 18 | Alessandro Schopf | MF | 1994-02-07 | 22 | Schalke 160044 | 1202 | 19 | Lukas Hinterseer | FD | 1991-03-28 | 25 | Ingolstadt 160041 | 1202 | 20 | Marcel Sabitzer | MF | 1994-03-17 | 22 | Leipzig 160045 | 1202 | 21 | Marc Janko | FD | 1983-06-25 | 32 | Basel 160039 | 1202 | 22 | Jakob Jantscher | MF | 1989-01-08 | 27 | Luzern 160026 | 1202 | 23 | Ramazan Ozcan | GK | 1984-06-28 | 31 | Ingolstadt 160047 | 1203 | 1 | Thibaut Courtois | GK | 1992-05-11 | 24 | Chelsea 160050 | 1203 | 2 | Toby Alderweireld | DF | 1989-03-02 | 27 | Tottenham 160056 | 1203 | 3 | Thomas Vermaelen | DF | 1985-11-14 | 30 | Barcelona 160063 | 1203 | 4 | Radja Nainggolan | MF | 1988-05-04 | 28 | Roma 160057 | 1203 | 5 | Jan Vertonghen | DF | 1987-04-24 | 29 | Tottenham 160064 | 1203 | 6 | Axel Witsel | MF | 1989-01-12 | 27 | Zenit 160059 | 1203 | 7 | Kevin De Bruyne | MF | 1991-06-28 | 24 | Man. City 160061 | 1203 | 8 | Marouane Fellaini | MF | 1987-11-22 | 28 | Man. United 160067 | 1203 | 9 | Romelu Lukaku | FD | 1993-05-13 | 23 | Everton 160062 | 1203 | 10 | Eden Hazard | MF | 1991-01-07 | 25 | Chelsea 160058 | 1203 | 11 | Yannick Carrasco | MF | 1993-09-04 | 22 | Atletico 160049 | 1203 | 12 | Simon Mignolet | GK | 1988-08-06 | 27 | Liverpool 160048 | 1203 | 13 | Jean-Francois Gillet | GK | 1979-05-31 | 37 | Mechelen 160068 | 1203 | 14 | Dries Mertens | FD | 1987-05-06 | 29 | Napoli 160052 | 1203 | 15 | Jason Denayer | DF | 1995-06-28 | 20 | Galatasaray 160055 | 1203 | 16 | Thomas Meunier | DF | 1991-09-12 | 24 | Club Brugge 160069 | 1203 | 17 | Divock Origi | FD | 1995-04-18 | 21 | Liverpool 160053 | 1203 | 18 | Christian Kabasele | DF | 1991-02-24 | 25 | Genk 160060 | 1203 | 19 | Mousa Dembele | MF | 1987-07-16 | 28 | Tottenham 160066 | 1203 | 20 | Christian Benteke | FD | 1990-12-03 | 25 | Liverpool 160054 | 1203 | 21 | Jordan Lukaku | DF | 1994-07-25 | 21 | Oostende 160065 | 1203 | 22 | Michy Batshuayi | FD | 1993-10-02 | 22 | Marseille 160051 | 1203 | 23 | Laurent Ciman | DF | 1985-08-05 | 30 | Montreal 160072 | 1204 | 1 | Ivan Vargic | GK | 1987-03-15 | 29 | Rijeka 160079 | 1204 | 2 | Sime Vrsaljko | DF | 1992-01-10 | 24 | Sassuolo 160077 | 1204 | 3 | Ivan Strinic | DF | 1987-07-17 | 28 | Napoli 160085 | 1204 | 4 | Ivan PeriSic | MF | 1989-02-02 | 27 | Internazionale 160073 | 1204 | 5 | Vedran Corluka | DF | 1986-02-05 | 30 | Lokomotiv Moskva 160074 | 1204 | 6 | Tin Jedvaj | DF | 1995-11-28 | 20 | Leverkusen 160086 | 1204 | 7 | Ivan Rakitic | MF | 1988-03-10 | 28 | Barcelona 160083 | 1204 | 8 | Mateo Kovacic | MF | 1994-05-06 | 22 | Real Madrid 160090 | 1204 | 9 | Andrej Kramaric | FD | 1991-06-19 | 24 | Hoffenheim 160084 | 1204 | 10 | Luka Modric | MF | 1985-09-09 | 30 | Real Madrid 160076 | 1204 | 11 | Darijo Srna | DF | 1982-05-01 | 34 | Shakhtar Donetsk 160070 | 1204 | 12 | Lovre Kalinic | GK | 1990-04-03 | 26 | Hajduk Split 160075 | 1204 | 13 | Gordon Schildenfeld | DF | 1985-03-18 | 31 | Dinamo Zagreb 160081 | 1204 | 14 | Marcelo Brozovic | MF | 1992-11-16 | 23 | Internazionale 160087 | 1204 | 15 | Marko Rog | MF | 1995-07-19 | 20 | Dinamo Zagreb 160089 | 1204 | 16 | Nikola Kalinic | FD | 1988-01-05 | 28 | Fiorentina 160091 | 1204 | 17 | Mario Mandzukic | FD | 1986-05-21 | 30 | Juventus 160082 | 1204 | 18 | Ante Coric | MF | 1997-04-14 | 19 | Dinamo Zagreb 160080 | 1204 | 19 | Milan Badelj | MF | 1989-02-25 | 27 | Fiorentina 160092 | 1204 | 20 | Marko Pjaca | FD | 1995-05-06 | 21 | Dinamo Zagreb 160078 | 1204 | 21 | Domagoj Vida | DF | 1989-04-29 | 27 | Dynamo Kyiv 160088 | 1204 | 22 | Duje Cop | FD | 1990-02-01 | 26 | Malaga 160071 | 1204 | 23 | Danijel SubaSic | GK | 1984-10-27 | 31 | Monaco 160093 | 1205 | 1 | Petr Cech | GK | 1982-05-20 | 34 | Arsenal 160098 | 1205 | 2 | Pavel Kaderabek | DF | 1992-04-25 | 24 | Hoffenheim 160099 | 1205 | 3 | Michal Kadlec | DF | 1984-12-13 | 31 | Fenerbahce 160096 | 1205 | 4 | Theodor Gebre Selassie | DF | 1986-12-24 | 29 | Bremen 160097 | 1205 | 5 | Roman Hubnik | DF | 1984-06-06 | 32 | Plzen 160101 | 1205 | 6 | TomasSivok | DF | 1983-09-15 | 32 | Bursaspor 160114 | 1205 | 7 | TomasNecid | FD | 1989-08-13 | 26 | Bursaspor 160100 | 1205 | 8 | David Limbersky | DF | 1983-10-06 | 32 | Plzen 160104 | 1205 | 9 | Borek Dockal | MF | 1988-09-30 | 27 | Sparta Praha 160110 | 1205 | 10 | TomasRosicky | MF | 1980-10-04 | 35 | Arsenal 160109 | 1205 | 11 | Daniel Pudil | MF | 1985-09-27 | 30 | Sheff. Wednesday 160115 | 1205 | 12 | Milan Skoda | FD | 1986-01-16 | 30 | Slavia Praha 160108 | 1205 | 13 | Jaroslav PlaSil | MF | 1982-01-05 | 34 | Bordeaux 160105 | 1205 | 14 | Daniel Kolar | MF | 1985-10-27 | 30 | Plzen 160107 | 1205 | 15 | David Pavelka | MF | 1991-05-18 | 25 | Kasimpasa 160095 | 1205 | 16 | TomasVaclik | GK | 1989-03-29 | 27 | Basel 160102 | 1205 | 17 | Marek Suchy | DF | 1988-03-29 | 28 | Basel 160112 | 1205 | 18 | Josef Sural | MF | 1990-05-30 | 26 | Sparta Praha 160106 | 1205 | 19 | Ladislav Krejci | MF | 1992-07-05 | 23 | Sparta Praha 160111 | 1205 | 20 | Jiri Skalak | MF | 1992-03-12 | 24 | Brighton 160113 | 1205 | 21 | David Lafata | FD | 1981-09-18 | 34 | Sparta Praha 160103 | 1205 | 22 | Vladimir Darida | MF | 1990-08-08 | 25 | Hertha 160094 | 1205 | 23 | TomasKoubek | GK | 1992-08-26 | 23 | Liberec 160117 | 1206 | 1 | Joe Hart | GK | 1987-04-19 | 29 | Man. City 160125 | 1206 | 2 | Kyle Walker | DF | 1990-05-28 | 26 | Tottenham 160122 | 1206 | 3 | Danny Rose | DF | 1990-07-02 | 25 | Tottenham 160131 | 1206 | 4 | James Milner | MF | 1986-01-04 | 30 | Liverpool 160120 | 1206 | 5 | Gary Cahill | DF | 1985-12-19 | 30 | Chelsea 160123 | 1206 | 6 | Chris Smalling | DF | 1989-11-22 | 26 | Man. United 160132 | 1206 | 7 | Raheem Sterling | MF | 1994-12-08 | 21 | Man. City 160130 | 1206 | 8 | Adam Lallana | MF | 1988-05-10 | 28 | Liverpool 160134 | 1206 | 9 | Harry Kane | FD | 1993-07-28 | 22 | Tottenham 160136 | 1206 | 10 | Wayne Rooney | FD | 1985-10-24 | 30 | Man. United 160138 | 1206 | 11 | Jamie Vardy | FD | 1987-01-11 | 29 | Leicester 160121 | 1206 | 12 | Nathaniel Clyne | DF | 1991-04-05 | 25 | Liverpool 160116 | 1206 | 13 | Fraser Forster | GK | 1988-03-17 | 28 | Southampton 160129 | 1206 | 14 | Jordan Henderson | MF | 1990-06-17 | 26 | Liverpool 160137 | 1206 | 15 | Daniel Sturridge | FD | 1989-09-01 | 26 | Liverpool 160124 | 1206 | 16 | John Stones | DF | 1994-05-28 | 22 | Everton 160128 | 1206 | 17 | Eric Dier | MF | 1994-01-15 | 22 | Tottenham 160133 | 1206 | 18 | Jack Wilshere | MF | 1992-01-01 | 24 | Arsenal 160127 | 1206 | 19 | Ross Barkley | MF | 1993-12-05 | 22 | Everton 160126 | 1206 | 20 | Dele Alli | MF | 1996-04-11 | 20 | Tottenham 160119 | 1206 | 21 | Ryan Bertrand | DF | 1989-08-05 | 26 | Southampton 160135 | 1206 | 22 | Marcus Rashford | FD | 1997-10-31 | 18 | Man. United 160118 | 1206 | 23 | Tom Heaton | GK | 1986-04-15 | 30 | Burnley 160140 | 1207 | 1 | Hugo Lloris | GK | 1986-12-26 | 29 | Tottenham 160144 | 1207 | 2 | Christophe Jallet | DF | 1983-10-31 | 32 | Lyon 160143 | 1207 | 3 | Patrice Evra | DF | 1981-05-15 | 35 | Juventus 160147 | 1207 | 4 | Adil Rami | DF | 1985-12-27 | 30 | Sevilla 160152 | 1207 | 5 | NGolo Kante | MF | 1991-03-29 | 25 | Leicester 160150 | 1207 | 6 | Yohan Cabaye | MF | 1986-01-14 | 30 | Crystal Palace 160160 | 1207 | 7 | Antoine Griezmann | FD | 1991-03-21 | 25 | Atletico 160154 | 1207 | 8 | Dimitri Payet | MF | 1987-03-29 | 29 | West Ham 160159 | 1207 | 9 | Olivier Giroud | FD | 1986-09-30 | 29 | Arsenal 160158 | 1207 | 10 | Andre-Pierre Gignac | FD | 1985-12-05 | 30 | Tigres 160161 | 1207 | 11 | Anthony Martial | FD | 1995-12-05 | 20 | Man. United 160156 | 1207 | 12 | Morgan Schneiderlin | MF | 1989-11-08 | 26 | Man. United 160146 | 1207 | 13 | Eliaquim Mangala | DF | 1991-02-13 | 25 | Man. City 160153 | 1207 | 14 | Blaise Matuidi | MF | 1987-04-09 | 29 | Paris 160155 | 1207 | 15 | Paul Pogba | MF | 1993-03-15 | 23 | Juventus 160141 | 1207 | 16 | Steve Mandanda | GK | 1985-03-28 | 31 | Marseille 160142 | 1207 | 17 | Lucas Digne | DF | 1993-07-20 | 22 | Roma 160157 | 1207 | 18 | Moussa Sissoko | MF | 1989-08-16 | 26 | Newcastle 160148 | 1207 | 19 | Bacary Sagna | DF | 1983-02-14 | 33 | Man. City 160151 | 1207 | 20 | Kingsley Coman | MF | 1996-06-13 | 20 | Bayern 160145 | 1207 | 21 | Laurent Koscielny | DF | 1985-09-10 | 30 | Arsenal 160149 | 1207 | 22 | Samuel Umtiti | DF | 1993-11-14 | 22 | Lyon 160139 | 1207 | 23 | Benoit Costil | GK | 1987-07-03 | 28 | Rennes 160163 | 1208 | 1 | Manuel Neuer | GK | 1986-03-27 | 30 | Bayern 160170 | 1208 | 2 | Shkodran Mustafi | DF | 1992-04-17 | 24 | Valencia 160166 | 1208 | 3 | Jonas Hector | DF | 1990-05-27 | 26 | Koln 160167 | 1208 | 4 | Benedikt Howedes | DF | 1988-02-29 | 28 | Schalke 160168 | 1208 | 5 | Mats Hummels | DF | 1988-12-16 | 27 | Dortmund 160175 | 1208 | 6 | Sami Khedira | MF | 1987-04-04 | 29 | Juventus 160180 | 1208 | 7 | Bastian Schweinsteiger | MF | 1984-08-01 | 31 | Man. United 160177 | 1208 | 8 | Mesut ozil | MF | 1988-10-15 | 27 | Arsenal 160179 | 1208 | 9 | Andre Schurrle | MF | 1990-11-06 | 25 | Wolfsburg 160184 | 1208 | 10 | Lukas Podolski | FD | 1985-06-04 | 31 | Galatasaray 160173 | 1208 | 11 | Julian Draxler | MF | 1993-09-20 | 22 | Wolfsburg 160162 | 1208 | 12 | Bernd Leno | GK | 1992-03-04 | 24 | Leverkusen 160183 | 1208 | 13 | Thomas Muller | FD | 1989-09-13 | 26 | Bayern 160172 | 1208 | 14 | Emre Can | MF | 1994-01-12 | 22 | Liverpool 160181 | 1208 | 15 | Julian Weigl | MF | 1995-09-08 | 20 | Dortmund 160171 | 1208 | 16 | Jonathan Tah | DF | 1996-02-11 | 20 | Leverkusen 160165 | 1208 | 17 | Jerome Boateng | DF | 1988-09-03 | 27 | Bayern 160176 | 1208 | 18 | Toni Kroos | MF | 1990-01-04 | 26 | Real Madrid 160174 | 1208 | 19 | Mario Gotze | MF | 1992-06-03 | 24 | Bayern 160178 | 1208 | 20 | Leroy Sane | MF | 1996-01-11 | 20 | Schalke 160169 | 1208 | 21 | Joshua Kimmich | DF | 1995-02-08 | 21 | Bayern 160164 | 1208 | 22 | Marc-Andre ter Stegen | GK | 1992-04-30 | 24 | Barcelona 160182 | 1208 | 23 | Mario Gomez | FD | 1985-07-10 | 30 | Besiktas 160187 | 1209 | 1 | Gabor Kiraly | GK | 1976-04-01 | 40 | Haladas 160194 | 1209 | 2 | Adam Lang | DF | 1993-01-17 | 23 | Videoton 160193 | 1209 | 3 | Mihaly Korhut | DF | 1988-12-01 | 27 | Debrecen 160192 | 1209 | 4 | Tamas Kadar | DF | 1990-03-14 | 26 | Lech 160189 | 1209 | 5 | Attila Fiola | DF | 1990-02-17 | 26 | Puskas Akademia 160196 | 1209 | 6 | Akos Elek | MF | 1988-07-21 | 27 | Diosgyor 160202 | 1209 | 7 | Balazs Dzsudzsak | FD | 1986-12-23 | 29 | Bursaspor 160199 | 1209 | 8 | Adam Nagy | MF | 1995-06-17 | 21 | Ferencvaros 160207 | 1209 | 9 | Adam Szalai | FD | 1987-12-09 | 28 | Hannover 160203 | 1209 | 10 | Zoltan Gera | FD | 1979-04-22 | 37 | Ferencvaros 160204 | 1209 | 11 | Krisztian Nemeth | FD | 1989-01-05 | 27 | Al-Gharafa 160185 | 1209 | 12 | Denes Dibusz | GK | 1990-11-16 | 25 | Ferencvaros 160201 | 1209 | 13 | Daniel Bode | FD | 1986-10-24 | 29 | Ferencvaros 160198 | 1209 | 14 | Gergo Lovrencsics | MF | 1988-09-01 | 27 | Lech 160197 | 1209 | 15 | Laszlo Kleinheisler | MF | 1994-04-08 | 22 | Bremen 160195 | 1209 | 16 | adam Pinter | DF | 1988-06-12 | 28 | Ferencvaros 160205 | 1209 | 17 | Nemanja Nikolic | FD | 1987-12-31 | 28 | Legia 160200 | 1209 | 18 | Zoltan Stieber | MF | 1988-10-16 | 27 | Nurnberg 160206 | 1209 | 19 | Tamas Priskin | FD | 1986-09-27 | 29 | Slovan Bratislava 160190 | 1209 | 20 | Richard Guzmics | DF | 1987-04-16 | 29 | Wisla 160188 | 1209 | 21 | Barnabas Bese | DF | 1994-05-06 | 22 | MTK 160186 | 1209 | 22 | Peter Gulacsi | GK | 1990-05-06 | 26 | Leipzig 160191 | 1209 | 23 | Roland Juhasz | DF | 1983-07-01 | 32 | Videoton 160208 | 1210 | 1 | Hannes Halldorsson | GK | 1984-04-27 | 32 | Bodo/Glimt 160216 | 1210 | 2 | Birkir Saevarsson | DF | 1984-11-11 | 31 | Hammarby 160212 | 1210 | 3 | Haukur Heidar Hauksson | DF | 1991-09-01 | 24 | AIK 160213 | 1210 | 4 | Hjortur Hermannsson | DF | 1995-02-08 | 21 | Goteborg 160214 | 1210 | 5 | Sverrir Ingason | DF | 1993-08-05 | 22 | Lokeren 160217 | 1210 | 6 | Ragnar Sigurdsson | DF | 1986-06-19 | 29 | Krasnodar 160229 | 1210 | 7 | Johann Gudmundsson | FD | 1990-10-27 | 25 | Charlton 160221 | 1210 | 8 | Birkir Bjarnason | MF | 1988-05-27 | 28 | Basel 160230 | 1210 | 9 | Kolbeinn Sigthorsson | FD | 1990-03-14 | 26 | Nantes 160224 | 1210 | 10 | Gylfi Sigurdsson | MF | 1989-09-08 | 26 | Swansea 160227 | 1210 | 11 | Alfred Finnbogason | FD | 1989-02-01 | 27 | Augsburg 160210 | 1210 | 12 | Ogmundur Kristinsson | GK | 1989-06-19 | 26 | Hammarby 160209 | 1210 | 13 | Ingvar Jonsson | GK | 1989-10-18 | 26 | Sandefjord 160220 | 1210 | 14 | Kari Arnason | MF | 1982-10-13 | 33 | Malmo 160226 | 1210 | 15 | Jon Dadi Bodvarsson | FD | 1992-05-25 | 24 | Kaiserslautern 160225 | 1210 | 16 | Runar Mar Sigurjonsson | MF | 1990-06-18 | 26 | Sundsvall 160222 | 1210 | 17 | Aron Gunnarsson | MF | 1989-04-22 | 27 | Cardiff 160211 | 1210 | 18 | Elmar Bjarnason | DF | 1987-03-04 | 29 | AGF 160215 | 1210 | 19 | Hordur Magnusson | DF | 1993-02-11 | 23 | Cesena 160223 | 1210 | 20 | Emil Hallfredsson | MF | 1984-06-29 | 31 | Udinese 160219 | 1210 | 21 | Arnor Ingvi Traustason | DF | 1993-04-30 | 23 | Norrkoping 160228 | 1210 | 22 | Eidur Gudjohnsen | FD | 1978-09-15 | 37 | Molde 160218 | 1210 | 23 | Ari Skulason | DF | 1987-05-14 | 29 | OB 160231 | 1211 | 1 | Gianluigi Buffon | GK | 1978-01-28 | 38 | Juventus 160238 | 1211 | 2 | Mattia De Sciglio | DF | 1992-10-20 | 23 | Milan 160236 | 1211 | 3 | Giorgio Chiellini | DF | 1984-08-14 | 31 | Juventus 160237 | 1211 | 4 | Matteo Darmian | DF | 1989-12-02 | 26 | Man. United 160239 | 1211 | 5 | Angelo Ogbonna | DF | 1988-05-23 | 28 | West Ham 160241 | 1211 | 6 | Antonio Candreva | MF | 1987-02-28 | 29 | Lazio 160253 | 1211 | 7 | Simone Zaza | FD | 1991-06-25 | 24 | Juventus 160243 | 1211 | 8 | Alessandro Florenzi | MF | 1991-03-11 | 25 | Roma 160252 | 1211 | 9 | Graziano Pelle | FD | 1985-07-15 | 30 | Southampton 160245 | 1211 | 10 | Thiago Motta | MF | 1982-08-28 | 33 | Paris 160250 | 1211 | 11 | Ciro Immobile | FD | 1990-02-20 | 26 | Torino 160233 | 1211 | 12 | Salvatore Sirigu | GK | 1987-01-12 | 29 | Paris 160232 | 1211 | 13 | Federico Marchetti | GK | 1983-02-07 | 33 | Lazio 160247 | 1211 | 14 | Stefano Sturaro | MF | 1993-03-09 | 23 | Juventus 160234 | 1211 | 15 | Andrea Barzagli | DF | 1981-05-08 | 35 | Juventus 160242 | 1211 | 16 | Daniele De Rossi | MF | 1983-07-24 | 32 | Roma 160248 | 1211 | 17 | Eder | FD | 1986-11-15 | 29 | Internazionale 160246 | 1211 | 18 | Marco Parolo | MF | 1985-01-25 | 31 | Lazio 160235 | 1211 | 19 | Leonardo Bonucci | DF | 1987-05-01 | 29 | Juventus 160251 | 1211 | 20 | Lorenzo Insigne | FD | 1991-06-04 | 25 | Napoli 160240 | 1211 | 21 | Federico Bernardeschi | MF | 1994-02-16 | 22 | Fiorentina 160249 | 1211 | 22 | Stephan El Shaarawy | FD | 1992-10-27 | 23 | Roma 160244 | 1211 | 23 | Emanuele Giaccherini | MF | 1985-05-05 | 31 | Bologna 160256 | 1212 | 1 | Michael McGovern | GK | 1984-07-12 | 31 | Hamilton 160264 | 1212 | 2 | Conor McLaughlin | DF | 1991-07-26 | 24 | Fleetwood 160269 | 1212 | 3 | Shane Ferguson | MF | 1991-07-12 | 24 | Millwall 160262 | 1212 | 4 | Gareth McAuley | DF | 1979-12-05 | 36 | West Brom 160259 | 1212 | 5 | Jonny Evans | DF | 1988-01-03 | 28 | West Brom 160257 | 1212 | 6 | Chris Baird | DF | 1982-02-25 | 34 | Fulham 160275 | 1212 | 7 | Niall McGinn | FD | 1987-07-20 | 28 | Aberdeen 160267 | 1212 | 8 | Steven Davis | MF | 1985-01-01 | 31 | Southampton 160273 | 1212 | 9 | Will Grigg | FD | 1991-07-03 | 24 | Wigan 160274 | 1212 | 10 | Kyle Lafferty | FD | 1987-09-16 | 28 | Birmingham 160276 | 1212 | 11 | Conor Washington | FD | 1992-05-18 | 24 | QPR 160254 | 1212 | 12 | Roy Carroll | GK | 1977-09-30 | 38 | Notts County 160268 | 1212 | 13 | Corry Evans | MF | 1990-07-30 | 25 | Blackburn 160266 | 1212 | 14 | Stuart Dallas | MF | 1991-04-19 | 25 | Leeds 160263 | 1212 | 15 | Luke McCullough | DF | 1994-02-15 | 22 | Doncaster 160271 | 1212 | 16 | Oliver Norwood | MF | 1991-04-12 | 25 | Reading 160265 | 1212 | 17 | Paddy McNair | DF | 1995-04-27 | 21 | Man. United 160261 | 1212 | 18 | Aaron Hughes | DF | 1979-11-08 | 36 | Melbourne City 160272 | 1212 | 19 | Jamie Ward | MF | 1986-05-12 | 30 | Nottm Forest 160258 | 1212 | 20 | Craig Cathcart | DF | 1989-02-06 | 27 | Watford 160270 | 1212 | 21 | Josh Magennis | MF | 1990-08-15 | 25 | Kilmarnock 160260 | 1212 | 22 | Lee Hodson | DF | 1991-10-02 | 24 | MK Dons 160255 | 1212 | 23 | Alan Mannus | GK | 1982-05-19 | 34 | St Johnstone 160279 | 1213 | 1 | Wojciech Szczesny | GK | 1990-04-18 | 26 | Roma 160283 | 1213 | 2 | Michal Pazdan | DF | 1987-09-21 | 28 | Legia 160282 | 1213 | 3 | Artur Jedrzejczyk | DF | 1987-11-04 | 28 | Legia 160280 | 1213 | 4 | Thiago Cionek | DF | 1986-04-21 | 30 | Palermo 160293 | 1213 | 5 | Krzysztof Maczynski | MF | 1987-05-23 | 29 | Wisla 160289 | 1213 | 6 | Tomasz Jodlowiec | MF | 1985-09-08 | 30 | Legia 160298 | 1213 | 7 | Arkadiusz Milik | FD | 1994-02-28 | 22 | Ajax 160292 | 1213 | 8 | Karol Linetty | MF | 1995-02-02 | 21 | Lech 160297 | 1213 | 9 | Robert Lewandowski | FD | 1988-08-21 | 27 | Bayern 160291 | 1213 | 10 | Grzegorz Krychowiak | MF | 1990-01-29 | 26 | Sevilla 160288 | 1213 | 11 | Kamil Grosicki | MF | 1988-06-08 | 28 | Rennes 160277 | 1213 | 12 | Artur Boruc | GK | 1980-02-20 | 36 | Bournemouth 160299 | 1213 | 13 | Mariusz Stepinski | FD | 1995-05-12 | 21 | Ruch 160286 | 1213 | 14 | Jakub Wawrzyniak | DF | 1983-07-07 | 32 | Lechia 160281 | 1213 | 15 | Kamil Glik | DF | 1988-02-03 | 28 | Torino 160287 | 1213 | 16 | Jakub Blaszczykowski | MF | 1985-12-14 | 30 | Fiorentina 160294 | 1213 | 17 | Slawomir Peszko | MF | 1985-02-19 | 31 | Lechia 160285 | 1213 | 18 | Bartosz Salamon | DF | 1991-05-01 | 25 | Cagliari 160296 | 1213 | 19 | Piotr Zielinski | MF | 1994-05-20 | 22 | Empoli 160284 | 1213 | 20 | Lukasz Piszczek | DF | 1985-06-03 | 31 | Dortmund 160290 | 1213 | 21 | Bartosz Kapustka | MF | 1996-12-23 | 19 | 160278 | 1213 | 22 | Lukasz Fabianski | GK | 1985-04-18 | 31 | Swansea 160295 | 1213 | 23 | Filip Starzynski | MF | 1991-05-27 | 25 | Zaglebie 160302 | 1214 | 1 | Rui Patricio | GK | 1988-02-15 | 28 | Sporting CP 160303 | 1214 | 2 | Bruno Alves | DF | 1981-11-27 | 34 | Fenerbahce 160307 | 1214 | 3 | Pepe | DF | 1983-02-26 | 33 | Real Madrid 160306 | 1214 | 4 | Jose Fonte | DF | 1983-12-22 | 32 | Southampton 160308 | 1214 | 5 | Raphael Guerreiro | DF | 1993-12-22 | 22 | Lorient 160309 | 1214 | 6 | Ricardo Carvalho | DF | 1978-05-18 | 38 | Monaco 160322 | 1214 | 7 | Cristiano Ronaldo | FD | 1985-02-05 | 31 | Real Madrid 160314 | 1214 | 8 | Joao Moutinho | MF | 1986-09-08 | 29 | Monaco 160319 | 1214 | 9 | Eder | FD | 1987-12-22 | 28 | LOSC 160313 | 1214 | 10 | Joao Mario | MF | 1993-01-19 | 23 | Sporting CP 160317 | 1214 | 11 | Vieirinha | MF | 1986-01-24 | 30 | Wolfsburg 160301 | 1214 | 12 | Anthony Lopes | GK | 1990-10-01 | 25 | Lyon 160312 | 1214 | 13 | Danilo | MF | 1991-09-09 | 24 | Porto 160318 | 1214 | 14 | William Carvalho | MF | 1992-04-07 | 24 | Sporting CP 160311 | 1214 | 15 | Andre Gomes | MF | 1993-07-30 | 22 | Valencia 160316 | 1214 | 16 | Renato Sanches | MF | 1997-08-18 | 18 | Benfica 160320 | 1214 | 17 | Nani | FD | 1986-11-17 | 29 | Fenerbahce 160315 | 1214 | 18 | Rafa Silva | MF | 1993-05-17 | 23 | Braga 160305 | 1214 | 19 | Eliseu | DF | 1983-10-01 | 32 | Benfica 160321 | 1214 | 20 | Ricardo Quaresma | FD | 1983-09-26 | 32 | Besiktas 160304 | 1214 | 21 | Cedric | DF | 1991-08-31 | 24 | Southampton 160300 | 1214 | 22 | Eduardo | GK | 1982-09-19 | 33 | Dinamo Zagreb 160310 | 1214 | 23 | Adrien Silva | MF | 1989-03-15 | 27 | Sporting CP 160325 | 1215 | 1 | Keiren Westwood | GK | 1984-10-23 | 31 | Sheff. Wednesday 160328 | 1215 | 2 | Seamus Coleman | DF | 1988-10-11 | 27 | Everton 160327 | 1215 | 3 | Ciaran Clark | DF | 1989-09-26 | 26 | Aston Villa 160331 | 1215 | 4 | John OShea | DF | 1981-04-30 | 35 | Sunderland 160330 | 1215 | 5 | Richard Keogh | DF | 1986-08-11 | 29 | Derby 160341 | 1215 | 6 | Glenn Whelan | MF | 1984-01-13 | 32 | Stoke 160338 | 1215 | 7 | Aiden McGeady | MF | 1986-04-04 | 30 | Sheff. Wednesday 160336 | 1215 | 8 | James McCarthy | MF | 1990-11-12 | 25 | Everton 160343 | 1215 | 9 | Shane Long | FD | 1987-01-22 | 29 | Southampton 160342 | 1215 | 10 | Robbie Keane | FD | 1980-07-08 | 35 | LA Galaxy 160337 | 1215 | 11 | James McClean | MF | 1989-04-22 | 27 | West Brom 160329 | 1215 | 12 | Shane Duffy | DF | 1992-01-01 | 24 | Blackburn 160334 | 1215 | 13 | Jeff Hendrick | MF | 1992-01-31 | 24 | Derby 160345 | 1215 | 14 | Jon Walters | FD | 1983-09-20 | 32 | Stoke 160326 | 1215 | 15 | Cyrus Christie | DF | 1992-09-30 | 23 | Derby 160323 | 1215 | 16 | Shay Given | GK | 1976-04-20 | 40 | Stoke 160332 | 1215 | 17 | Stephen Ward | DF | 1985-08-20 | 30 | Burnley 160339 | 1215 | 18 | David Meyler | MF | 1989-05-29 | 27 | Hull 160333 | 1215 | 19 | Robbie Brady | MF | 1992-01-14 | 24 | Norwich 160335 | 1215 | 20 | Wes Hoolahan | MF | 1982-05-20 | 34 | Norwich 160344 | 1215 | 21 | Daryl Murphy | FD | 1983-03-15 | 33 | Ipswich 160340 | 1215 | 22 | Stephen Quinn | MF | 1986-04-01 | 30 | Reading 160324 | 1215 | 23 | Darren Randolph | GK | 1987-05-12 | 29 | West Ham 160347 | 1216 | 1 | Costel Pantilimon | GK | 1987-02-01 | 29 | Watford 160353 | 1216 | 2 | Alexandru Matel | DF | 1989-10-17 | 26 | Dinamo Zagreb 160355 | 1216 | 3 | Razvan Rat | DF | 1981-05-26 | 35 | Rayo Vallecano 160354 | 1216 | 4 | Cosmin Moti | DF | 1984-12-03 | 31 | Ludogorets 160358 | 1216 | 5 | Ovidiu Hoban | MF | 1982-12-27 | 33 | H. Beer-Sheva 160349 | 1216 | 6 | Vlad Chiriches | DF | 1989-11-14 | 26 | Napoli 160357 | 1216 | 7 | Alexandru Chipciu | MF | 1989-05-18 | 27 | Steaua 160359 | 1216 | 8 | Mihai Pintilii | MF | 1984-11-09 | 31 | Steaua 160365 | 1216 | 9 | Denis Alibec | FD | 1991-01-05 | 25 | Astra 160363 | 1216 | 10 | Nicolae Stanciu | MF | 1993-05-07 | 23 | Steaua 160364 | 1216 | 11 | Gabriel Torje | MF | 1989-11-22 | 26 | Osmanlispor 160348 | 1216 | 12 | Ciprian Tatarusanu | GK | 1986-02-09 | 30 | Fiorentina 160367 | 1216 | 13 | Claudiu Keeru | FD | 1986-12-02 | 29 | Ludogorets 160366 | 1216 | 14 | Florin Andone | FD | 1993-04-11 | 23 | Cordoba 160351 | 1216 | 15 | Valerica Gaman | DF | 1989-02-25 | 27 | Astra 160350 | 1216 | 16 | Steliano Filip | DF | 1994-05-15 | 22 | Dinamo Bucuresti 160362 | 1216 | 17 | Lucian Sanmartean | MF | 1980-03-13 | 36 | Al-Ittihad 160361 | 1216 | 18 | Andrei Prepelita | MF | 1985-12-08 | 30 | Ludogorets 160368 | 1216 | 19 | Bogdan Stancu | FD | 1987-06-28 | 28 | Genclerbirligi 160360 | 1216 | 20 | Adrian Popa | MF | 1988-07-24 | 27 | Steaua 160352 | 1216 | 21 | Dragos Grigore | DF | 1986-09-07 | 29 | Al-Sailiya 160356 | 1216 | 22 | Cristian Sapunaru | DF | 1984-04-05 | 32 | Pandurii 160346 | 1216 | 23 | Silviu Lung | GK | 1989-06-04 | 27 | Astra 160369 | 1217 | 1 | Igor Akinfeev | GK | 1986-04-08 | 30 | CSKA Moskva 160378 | 1217 | 2 | Roman Shishkin | DF | 1987-01-27 | 29 | Lokomotiv Moskva 160379 | 1217 | 3 | Igor Smolnikov | DF | 1988-08-08 | 27 | Zenit 160374 | 1217 | 4 | Sergei Ignashevich | DF | 1979-07-14 | 36 | CSKA Moskva 160376 | 1217 | 5 | Roman Neustadter | DF | 1988-02-18 | 28 | Schalke 160372 | 1217 | 6 | Aleksei Berezutski | DF | 1982-06-20 | 33 | CSKA Moskva 160388 | 1217 | 7 | Artur Yusupov | MF | 1989-09-01 | 26 | Zenit 160380 | 1217 | 8 | Denis Glushakov | MF | 1987-01-27 | 29 | Spartak Moskva 160390 | 1217 | 9 | Aleksandr Kokorin | FD | 1991-03-19 | 25 | Zenit 160391 | 1217 | 10 | Fedor Smolov | FD | 1990-02-09 | 26 | Krasnodar 160383 | 1217 | 11 | Pavel Mamaev | MF | 1988-09-17 | 27 | Krasnodar 160371 | 1217 | 12 | Yuri Lodygin | GK | 1990-05-26 | 26 | Zenit 160381 | 1217 | 13 | Aleksandr Golovin | MF | 1996-05-30 | 20 | CSKA Moskva 160373 | 1217 | 14 | Vasili Berezutski | DF | 1982-06-20 | 33 | CSKA Moskva 160386 | 1217 | 15 | Roman Shirokov | MF | 1981-07-06 | 34 | CSKA Moskva 160370 | 1217 | 16 | Guilherme | GK | 1985-12-12 | 30 | Lokomotiv Moskva 160385 | 1217 | 17 | Oleg Shatov | MF | 1990-07-29 | 25 | Zenit 160382 | 1217 | 18 | Oleg Ivanov | MF | 1986-08-04 | 29 | Terek 160384 | 1217 | 19 | Aleksandr Samedov | MF | 1984-07-19 | 31 | Lokomotiv Moskva 160387 | 1217 | 20 | Dmitri Torbinski | MF | 1984-04-28 | 32 | Krasnodar 160377 | 1217 | 21 | Georgi Schennikov | DF | 1991-04-27 | 25 | CSKA Moskva 160389 | 1217 | 22 | Artem Dzyuba | FD | 1988-08-22 | 27 | Zenit 160375 | 1217 | 23 | Dmitri Kombarov | DF | 1987-01-22 | 29 | Spartak Moskva 160393 | 1218 | 1 | Jan Mucha | GK | 1982-12-05 | 33 | Slovan Bratislava 160398 | 1218 | 2 | Peter Pekarik | DF | 1986-10-30 | 29 | Hertha 160401 | 1218 | 3 | Martin Skrtel | DF | 1984-12-15 | 31 | Liverpool 160395 | 1218 | 4 | Jan Durica | DF | 1981-12-10 | 34 | Lokomotiv Moskva 160396 | 1218 | 5 | Norbert Gyomber | DF | 1992-07-03 | 23 | Roma 160404 | 1218 | 6 | Jan Gregus | MF | 1991-01-29 | 25 | Jablonec 160411 | 1218 | 7 | Vladimir Weiss | MF | 1989-11-30 | 26 | Al-Gharafa 160403 | 1218 | 8 | Ondrej Duda | MF | 1994-12-05 | 21 | Legia 160414 | 1218 | 9 | Stanislav Sestak | FD | 1982-12-16 | 33 | Ferencvaros 160410 | 1218 | 10 | Miroslav Stoch | MF | 1989-10-19 | 26 | Bursaspor 160413 | 1218 | 11 | Adam Nemec | FD | 1985-09-02 | 30 | Willem II 160394 | 1218 | 12 | Jan Novota | GK | 1983-11-29 | 32 | Rapid Wien 160406 | 1218 | 13 | Patrik HroSovsky | MF | 1992-04-22 | 24 | Plzen 160400 | 1218 | 14 | Milan Skriniar | DF | 1995-02-11 | 21 | Sampdoria 160397 | 1218 | 15 | TomasHubocan | DF | 1985-09-17 | 30 | Dinamo Moskva 160399 | 1218 | 16 | Kornel Salata | DF | 1985-01-24 | 31 | Slovan Bratislava 160405 | 1218 | 17 | Marek Hamsik | MF | 1987-07-27 | 28 | Napoli 160402 | 1218 | 18 | Dusan Svento | DF | 1985-08-01 | 30 | Koln 160407 | 1218 | 19 | Juraj Kucka | MF | 1987-02-26 | 29 | Milan 160408 | 1218 | 20 | Robert Mak | MF | 1991-03-08 | 25 | PAOK 160412 | 1218 | 21 | Michal Duris | FD | 1988-06-01 | 28 | Plzen 160409 | 1218 | 22 | Viktor Pecovsky | MF | 1983-05-24 | 33 | zilina 160392 | 1218 | 23 | MatusKozacik | GK | 1983-12-27 | 32 | Plzen 160415 | 1219 | 1 | Lker Casillas | GK | 1981-05-20 | 35 | Porto 160418 | 1219 | 2 | Cesar Azpilicueta | DF | 1989-08-28 | 26 | Chelsea 160423 | 1219 | 3 | Gerard Pique | DF | 1987-02-02 | 29 | Barcelona 160419 | 1219 | 4 | Marc Bartra | DF | 1991-01-15 | 25 | Barcelona 160427 | 1219 | 5 | Sergio Busquets | MF | 1988-07-16 | 27 | Barcelona 160429 | 1219 | 6 | Andres Iniesta | MF | 1984-05-11 | 32 | Barcelona 160435 | 1219 | 7 | Alvaro Morata | FD | 1992-10-23 | 23 | Juventus 160430 | 1219 | 8 | Koke | MF | 1992-01-08 | 24 | Atletico 160434 | 1219 | 9 | Lucas Vazquez | FD | 1991-07-01 | 24 | Real Madrid 160428 | 1219 | 10 | Cesc Fabregas | MF | 1987-05-04 | 29 | Chelsea 160437 | 1219 | 11 | Pedro Rodriguez | FD | 1987-07-28 | 28 | Chelsea 160420 | 1219 | 12 | Hector Bellerin | DF | 1995-03-19 | 21 | Arsenal 160416 | 1219 | 13 | David de Gea | GK | 1990-11-07 | 25 | Man. United 160432 | 1219 | 14 | Thiago Alcantara | MF | 1991-04-11 | 25 | Bayern 160424 | 1219 | 15 | Sergio Ramos | DF | 1986-03-30 | 30 | Real Madrid 160422 | 1219 | 16 | Juanfran | DF | 1985-01-09 | 31 | Atletico 160425 | 1219 | 17 | Mikel San Jose | DF | 1989-05-30 | 27 | Athletic 160421 | 1219 | 18 | Jordi Alba | DF | 1989-03-21 | 27 | Barcelona 160426 | 1219 | 19 | Bruno Soriano | MF | 1984-06-12 | 32 | Villarreal 160433 | 1219 | 20 | Aritz Aduriz | FD | 1981-02-11 | 35 | Athletic 160431 | 1219 | 21 | David Silva | MF | 1986-01-08 | 30 | Man. City 160436 | 1219 | 22 | Nolito | FD | 1986-10-15 | 29 | Celta 160417 | 1219 | 23 | Sergio Rico | GK | 1993-09-01 | 22 | Sevilla 160439 | 1220 | 1 | Andreas Isaksson | GK | 1981-10-03 | 34 | Kasimpasa 160446 | 1220 | 2 | Mikael Lustig | DF | 1986-12-13 | 29 | Celtic 160444 | 1220 | 3 | Erik Johansson | DF | 1988-12-30 | 27 | Kobenhavn 160442 | 1220 | 4 | Andreas Granqvist | DF | 1985-04-16 | 31 | Krasnodar 160447 | 1220 | 5 | Martin Olsson | DF | 1988-05-17 | 28 | Norwich 160451 | 1220 | 6 | Emil Forsberg | MF | 1991-10-23 | 24 | Leipzig 160454 | 1220 | 7 | Sebastian Larsson | MF | 1985-06-06 | 31 | Sunderland 160449 | 1220 | 8 | Albin Ekdal | MF | 1989-07-28 | 26 | Hamburg 160453 | 1220 | 9 | Kim Kallstrom | MF | 1982-08-24 | 33 | Grasshoppers 160459 | 1220 | 10 | Zlatan Ibrahimovic | FD | 1981-10-03 | 34 | Paris 160457 | 1220 | 11 | Marcus Berg | FD | 1986-08-17 | 29 | Panathinaikos 160440 | 1220 | 12 | Robin Olsen | GK | 1990-01-08 | 26 | Kobenhavn 160443 | 1220 | 13 | Pontus Jansson | DF | 1991-02-13 | 25 | Torino 160445 | 1220 | 14 | Victor Lindelof | DF | 1994-07-17 | 21 | Benfica 160452 | 1220 | 15 | Oscar Hiljemark | MF | 1992-06-28 | 23 | Palermo 160456 | 1220 | 16 | Pontus Wernbloom | MF | 1986-06-25 | 29 | CSKA Moskva 160441 | 1220 | 17 | Ludwig Augustinsson | DF | 1994-04-21 | 22 | Kobenhavn 160455 | 1220 | 18 | Oscar Lewicki | MF | 1992-07-14 | 23 | Malmo 160460 | 1220 | 19 | Emir Kujovic | FD | 1988-06-22 | 27 | Norrkoping 160458 | 1220 | 20 | John Guidetti | FD | 1992-04-15 | 24 | Celta 160448 | 1220 | 21 | Jimmy Durmaz | MF | 1989-03-22 | 27 | Olympiacos 160450 | 1220 | 22 | Erkan Zengin | MF | 1985-08-05 | 30 | Trabzonspor 160438 | 1220 | 23 | Patrik Carlgren | GK | 1992-01-08 | 24 | AIK 160463 | 1221 | 1 | Yann Sommer | GK | 1988-12-17 | 27 | Monchengladbach 160467 | 1221 | 2 | Stephan Lichtsteiner | DF | 1984-01-16 | 32 | Juventus 160468 | 1221 | 3 | Francois Moubandje | DF | 1990-06-21 | 25 | Toulouse 160465 | 1221 | 4 | Nico Elvedi | DF | 1996-09-30 | 19 | Monchengladbach 160471 | 1221 | 5 | Steve von Bergen | DF | 1983-06-10 | 33 | Young Boys 160466 | 1221 | 6 | Michael Lang | DF | 1991-02-08 | 25 | Basel 160480 | 1221 | 7 | Breel Embolo | FD | 1997-02-14 | 19 | Basel 160475 | 1221 | 8 | Fabian Frei | MF | 1989-01-08 | 27 | Mainz 160482 | 1221 | 9 | Haris Seferovic | FD | 1992-02-22 | 24 | Frankfurt 160477 | 1221 | 10 | Granit Xhaka | MF | 1992-09-27 | 23 | Monchengladbach 160472 | 1221 | 11 | Valon Behrami | MF | 1985-04-19 | 31 | Watford 160462 | 1221 | 12 | Marwin Hitz | GK | 1987-09-18 | 28 | Augsburg 160469 | 1221 | 13 | Ricardo Rodriguez | DF | 1992-08-25 | 23 | Wolfsburg 160478 | 1221 | 14 | Denis Zakaria | MF | 1996-11-20 | 19 | Young Boys 160473 | 1221 | 15 | Blerim Dzemaili | MF | 1986-04-12 | 30 | Genoa 160474 | 1221 | 16 | Gelson Fernandes | MF | 1986-09-02 | 29 | Rennes 160483 | 1221 | 17 | Shani Tarashaj | FD | 1995-02-07 | 21 | Grasshoppers 160481 | 1221 | 18 | Admir Mehmedi | FD | 1991-03-16 | 25 | Leverkusen 160479 | 1221 | 19 | Eren Derdiyok | FD | 1988-06-12 | 28 | Kasimpasa 160464 | 1221 | 20 | Johan Djourou | DF | 1987-01-18 | 29 | Hamburg 160461 | 1221 | 21 | Roman Burki | GK | 1990-11-14 | 25 | Dortmund 160470 | 1221 | 22 | Fabian Schar | DF | 1991-12-20 | 24 | Hoffenheim 160476 | 1221 | 23 | Xherdan Shaqiri | MF | 1991-10-10 | 24 | Stoke 160486 | 1222 | 1 | Volkan Babacan | GK | 1988-08-11 | 27 | Istanbul Basaksehir 160492 | 1222 | 2 | Semih Kaya | DF | 1991-02-24 | 25 | Galatasaray 160490 | 1222 | 3 | Hakan Balta | DF | 1983-03-23 | 33 | Galatasaray 160487 | 1222 | 4 | Ahmet Calik | DF | 1994-02-26 | 22 | Genclerbirligi 160497 | 1222 | 5 | Nuri Sahin | MF | 1988-09-05 | 27 | Dortmund 160495 | 1222 | 6 | Hakan Calhanoglu | MF | 1994-02-08 | 22 | Leverkusen 160489 | 1222 | 7 | Gokhan Gonul | DF | 1985-01-04 | 31 | Fenerbahce 160501 | 1222 | 8 | Selcuk Inan | MF | 1985-02-10 | 31 | Galatasaray 160505 | 1222 | 9 | Cenk Tosun | FD | 1991-06-07 | 25 | Besiktas 160494 | 1222 | 10 | Arda Turan | MF | 1987-01-30 | 29 | Barcelona 160499 | 1222 | 11 | Olcay Sahan | MF | 1987-05-26 | 29 | Besiktas 160485 | 1222 | 12 | Onur Kivrak | GK | 1988-01-01 | 28 | Trabzonspor 160491 | 1222 | 13 | Ismail Koybasi | DF | 1989-07-10 | 26 | Besiktas 160498 | 1222 | 14 | Oguzhan Ozyakup | MF | 1992-09-23 | 23 | Besiktas 160496 | 1222 | 15 | Mehmet Topal | MF | 1986-03-03 | 30 | Fenerbahce 160500 | 1222 | 16 | Ozan Tufan | MF | 1995-03-23 | 21 | Fenerbahce 160504 | 1222 | 17 | Burak Yilmaz | FD | 1985-07-15 | 30 | Beijing Guoan 160488 | 1222 | 18 | Caner Erkin | DF | 1988-10-04 | 27 | Fenerbahce 160503 | 1222 | 19 | Yunus Malli | MF | 1992-02-24 | 24 | Mainz 160502 | 1222 | 20 | Volkan Sen | MF | 1987-07-07 | 28 | Fenerbahce 160506 | 1222 | 21 | Emre Mor | FD | 1997-07-24 | 18 | Nordsj�lland 160493 | 1222 | 22 | Sener Ozbayrakli | DF | 1990-01-23 | 26 | Fenerbahce 160484 | 1222 | 23 | Harun Tekin | GK | 1989-06-17 | 27 | Bursaspor 160507 | 1223 | 1 | Denys Boyko | GK | 1988-01-29 | 28 | Besiktas 160510 | 1223 | 2 | Bohdan Butko | DF | 1991-01-13 | 25 | Amkar 160512 | 1223 | 3 | Yevhen Khacheridi | DF | 1987-07-28 | 28 | Dynamo Kyiv 160524 | 1223 | 4 | Anatoliy Tymoshchuk | MF | 1979-03-30 | 37 | Kairat 160513 | 1223 | 5 | Olexandr Kucher | DF | 1982-10-22 | 33 | Shakhtar Donetsk 160522 | 1223 | 6 | Taras Stepanenko | MF | 1989-08-08 | 26 | Shakhtar Donetsk 160525 | 1223 | 7 | Andriy Yarmolenko | MF | 1989-10-23 | 26 | Dynamo Kyiv 160529 | 1223 | 8 | Roman Zozulya | FD | 1989-11-17 | 26 | Dnipro 160519 | 1223 | 9 | Viktor Kovalenko | MF | 1996-02-14 | 20 | Shakhtar Donetsk 160518 | 1223 | 10 | Yevhen Konoplyanka | MF | 1989-09-29 | 26 | Sevilla 160528 | 1223 | 11 | Yevhen Seleznyov | FD | 1985-07-20 | 30 | Shakhtar Donetsk 160508 | 1223 | 12 | Andriy Pyatov | GK | 1984-06-28 | 31 | Shakhtar Donetsk 160515 | 1223 | 13 | Vyacheslav Shevchuk | DF | 1979-05-13 | 37 | Shakhtar Donetsk 160520 | 1223 | 14 | Ruslan Rotan | MF | 1981-10-29 | 34 | Dnipro 160527 | 1223 | 15 | Pylyp Budkivskiy | FD | 1992-03-10 | 24 | Zorya 160523 | 1223 | 16 | Serhiy Sydorchuk | MF | 1991-05-02 | 25 | Dynamo Kyiv 160511 | 1223 | 17 | Artem Fedetskiy | DF | 1985-04-26 | 31 | Dnipro 160521 | 1223 | 18 | Serhiy Rybalka | MF | 1990-04-01 | 26 | Dynamo Kyiv 160516 | 1223 | 19 | Denys Garmash | MF | 1990-04-19 | 26 | Dynamo Kyiv 160514 | 1223 | 20 | Yaroslav Rakitskiy | DF | 1989-08-03 | 26 | Shakhtar Donetsk 160526 | 1223 | 21 | Olexandr Zinchenko | MF | 1996-12-15 | 19 | Ufa 160517 | 1223 | 22 | Olexandr Karavaev | MF | 1992-06-02 | 24 | Zorya 160509 | 1223 | 23 | Mykyta Shevchenko | GK | 1993-01-26 | 23 | Zorya 160531 | 1224 | 1 | Wayne Hennessey | GK | 1987-01-24 | 29 | Crystal Palace 160536 | 1224 | 2 | Chris Gunter | DF | 1989-07-21 | 26 | Reading 160538 | 1224 | 3 | Neil Taylor | DF | 1989-02-07 | 27 | Swansea 160535 | 1224 | 4 | Ben Davies | DF | 1993-04-24 | 23 | Tottenham 160533 | 1224 | 5 | James Chester | DF | 1989-01-23 | 27 | West Brom 160539 | 1224 | 6 | Ashley Williams | DF | 1984-08-23 | 31 | Swansea 160540 | 1224 | 7 | Joe Allen | MF | 1990-03-14 | 26 | Liverpool 160542 | 1224 | 8 | Andy King | MF | 1988-10-29 | 27 | Leicester 160550 | 1224 | 9 | Hal Robson-Kanu | FD | 1989-05-21 | 27 | Reading 160544 | 1224 | 10 | Aaron Ramsey | MF | 1990-12-26 | 25 | Arsenal 160547 | 1224 | 11 | Gareth Bale | FD | 1989-07-16 | 26 | Real Madrid 160530 | 1224 | 12 | Owain Fon Williams | GK | 1987-03-17 | 29 | Inverness 160552 | 1224 | 13 | George Williams | FD | 1995-09-07 | 20 | Fulham 160541 | 1224 | 14 | David Edwards | MF | 1986-02-03 | 30 | Wolves 160537 | 1224 | 15 | Jazz Richards | DF | 1991-04-12 | 25 | Fulham 160543 | 1224
الأجوبة
SELECT a.player_name, b.country_name
FROM player_mast a
JOIN match_mast c ON c.plr_of_match=a.player_id
AND c.play_stage='F'
JOIN soccer_country b
ON a.team_id=b.country_id;
Sample Output:
player_name | country_name -------------+-------------- Pepe | Portugal (1 row)
success
تم تقديم إجابتك بنجاح
success
تم تعديل الإجابة، سيتم نشرها بعد مراجعة الإدارة
أسئلة مشابهة
القوائم الدراسية التي ينتمي لها السؤال
تنبيهلايوجد قوائم حاليا