0
. From the following tables, write a SQL query to find the substitute players who came into the field in the first half of play within normal play schedule. Return match_no, country_name, player_name, jersey_no and time_in_out.
Sample table: player_in_out
match_no | team_id | player_id | in_out | time_in_out | play_schedule | play_half
----------+---------+-----------+--------+-------------+---------------+-----------
1 | 1207 | 160151 | I | 66 | NT | 2
1 | 1207 | 160160 | O | 66 | NT | 2
1 | 1207 | 160161 | I | 77 | NT | 2
1 | 1207 | 160161 | O | 77 | NT | 2
1 | 1207 | 160157 | I | 2 | ST | 2
1 | 1207 | 160154 | O | 2 | ST | 2
1 | 1216 | 160365 | I | 61 | NT | 2
1 | 1216 | 160366 | O | 61 | NT | 2
1 | 1216 | 160357 | I | 72 | NT | 2
1 | 1216 | 160363 | O | 72 | NT | 2
1 | 1216 | 160364 | I | 82 | NT | 2
1 | 1216 | 160360 | O | 82 | NT | 2
2 | 1201 | 160014 | I | 62 | NT | 2
2 | 1201 | 160019 | O | 62 | NT | 2
2 | 1201 | 160021 | I | 74 | NT | 2
2 | 1201 | 160018 | O | 74 | NT | 2
2 | 1201 | 160022 | I | 82 | NT | 2
2 | 1201 | 160023 | O | 82 | NT | 2
2 | 1221 | 160480 | I | 62 | NT | 2
2 | 1221 | 160481 | O | 62 | NT | 2
2 | 1221 | 160475 | I | 76 | NT | 2
2 | 1221 | 160473 | O | 76 | NT | 2
2 | 1221 | 160474 | I | 88 | NT | 2
2 | 1221 | 160476 | O | 88 | NT | 2
3 | 1218 | 160413 | I | 59 | NT | 2
3 | 1218 | 160412 | O | 59 | NT | 2
3 | 1218 | 160403 | I | 60 | NT | 2
3 | 1218 | 160406 | O | 60 | NT | 2
3 | 1218 | 160410 | I | 83 | NT | 2
3 | 1218 | 160411 | O | 83 | NT | 2
3 | 1224 | 160543 | I | 69 | NT | 2
3 | 1224 | 160541 | O | 69 | NT | 2
3 | 1224 | 160550 | I | 71 | NT | 2
3 | 1224 | 160546 | O | 71 | NT | 2
3 | 1224 | 160537 | I | 88 | NT | 2
3 | 1224 | 160544 | O | 88 | NT | 2
4 | 1206 | 160133 | I | 78 | NT | 2
4 | 1206 | 160136 | O | 78 | NT | 2
4 | 1206 | 160131 | I | 87 | NT | 2
4 | 1206 | 160132 | O | 87 | NT | 2
4 | 1217 | 160386 | I | 77 | NT | 2
4 | 1217 | 160381 | O | 77 | NT | 2
4 | 1217 | 160380 | I | 80 | NT | 2
4 | 1217 | 160376 | O | 80 | NT | 2
4 | 1217 | 160383 | I | 85 | NT | 2
4 | 1217 | 160391 | O | 85 | NT | 2
5 | 1204 | 160090 | I | 87 | NT | 2
5 | 1204 | 160085 | O | 87 | NT | 2
5 | 1204 | 160075 | I | 90 | NT | 2
5 | 1204 | 160086 | O | 90 | NT | 2
5 | 1204 | 160092 | I | 3 | ST | 2
5 | 1204 | 160091 | O | 3 | ST | 2
5 | 1222 | 160502 | I | 46 | NT | 2
5 | 1222 | 160498 | O | 46 | NT | 2
5 | 1222 | 160504 | I | 65 | NT | 2
5 | 1222 | 160494 | O | 65 | NT | 2
5 | 1222 | 160506 | I | 69 | NT | 2
5 | 1222 | 160505 | O | 69 | NT | 2
6 | 1212 | 160266 | I | 46 | NT | 2
6 | 1212 | 160265 | O | 46 | NT | 2
6 | 1212 | 160276 | I | 66 | NT | 2
6 | 1212 | 160269 | O | 66 | NT | 2
6 | 1212 | 160272 | I | 76 | NT | 2
6 | 1212 | 160257 | O | 76 | NT | 2
6 | 1213 | 160289 | I | 78 | NT | 2
6 | 1213 | 160293 | O | 78 | NT | 2
6 | 1213 | 160288 | I | 80 | NT | 2
6 | 1213 | 160287 | O | 80 | NT | 2
6 | 1213 | 160294 | I | 88 | NT | 2
6 | 1213 | 160290 | O | 88 | NT | 2
7 | 1208 | 160179 | I | 78 | NT | 2
7 | 1208 | 160173 | O | 78 | NT | 2
7 | 1208 | 160180 | I | 90 | NT | 2
7 | 1208 | 160174 | O | 90 | NT | 2
7 | 1223 | 160528 | I | 66 | NT | 2
7 | 1223 | 160529 | O | 66 | NT | 2
7 | 1223 | 160526 | I | 73 | NT | 2
7 | 1223 | 160519 | O | 73 | NT | 2
8 | 1205 | 160113 | I | 75 | NT | 2
8 | 1205 | 160114 | O | 75 | NT | 2
8 | 1205 | 160112 | I | 86 | NT | 2
8 | 1205 | 160096 | O | 86 | NT | 2
8 | 1205 | 160107 | I | 88 | NT | 2
8 | 1205 | 160110 | O | 88 | NT | 2
8 | 1219 | 160433 | I | 62 | NT | 2
8 | 1219 | 160435 | O | 62 | NT | 2
8 | 1219 | 160432 | I | 70 | NT | 2
8 | 1219 | 160428 | O | 70 | NT | 2
8 | 1219 | 160437 | I | 82 | NT | 2
8 | 1219 | 160436 | O | 82 | NT | 2
9 | 1215 | 160337 | I | 64 | NT | 2
9 | 1215 | 160345 | O | 64 | NT | 2
9 | 1215 | 160342 | I | 78 | NT | 2
9 | 1215 | 160335 | O | 78 | NT | 2
9 | 1215 | 160338 | I | 85 | NT | 2
9 | 1215 | 160336 | O | 85 | NT | 2
9 | 1220 | 160444 | I | 45 | NT | 1
9 | 1220 | 160446 | O | 45 | NT | 1
9 | 1220 | 160458 | I | 59 | NT | 2
9 | 1220 | 160457 | O | 59 | NT | 2
9 | 1220 | 160449 | I | 86 | NT | 2
9 | 1220 | 160455 | O | 86 | NT | 2
10 | 1203 | 160068 | I | 62 | NT | 2
10 | 1203 | 160063 | O | 62 | NT | 2
10 | 1203 | 160069 | I | 73 | NT | 2
10 | 1203 | 160067 | O | 73 | NT | 2
10 | 1203 | 160058 | I | 76 | NT | 2
10 | 1203 | 160051 | O | 76 | NT | 2
10 | 1211 | 160238 | I | 58 | NT | 2
10 | 1211 | 160237 | O | 58 | NT | 2
10 | 1211 | 160250 | I | 75 | NT | 2
10 | 1211 | 160248 | O | 75 | NT | 2
10 | 1211 | 160245 | I | 78 | NT | 2
10 | 1211 | 160242 | O | 78 | NT | 2
11 | 1202 | 160041 | I | 59 | NT | 2
11 | 1202 | 160040 | O | 59 | NT | 2
11 | 1202 | 160046 | I | 65 | NT | 2
11 | 1202 | 160045 | O | 65 | NT | 2
11 | 1202 | 160042 | I | 77 | NT | 2
11 | 1202 | 160037 | O | 77 | NT | 2
11 | 1209 | 160206 | I | 69 | NT | 2
11 | 1209 | 160207 | O | 69 | NT | 2
11 | 1209 | 160200 | I | 79 | NT | 2
11 | 1209 | 160197 | O | 79 | NT | 2
11 | 1209 | 160195 | I | 89 | NT | 2
11 | 1209 | 160204 | O | 89 | NT | 2
12 | 1210 | 160227 | I | 81 | NT | 2
12 | 1210 | 160230 | O | 81 | NT | 2
12 | 1210 | 160211 | I | 90 | NT | 2
12 | 1210 | 160229 | O | 90 | NT | 2
12 | 1214 | 160316 | I | 71 | NT | 2
12 | 1214 | 160314 | O | 71 | NT | 2
12 | 1214 | 160321 | I | 76 | NT | 2
12 | 1214 | 160313 | O | 76 | NT | 2
12 | 1214 | 160319 | I | 84 | NT | 2
12 | 1214 | 160311 | O | 84 | NT | 2
13 | 1217 | 160380 | I | 46 | NT | 2
13 | 1217 | 160383 | I | 46 | NT | 2
13 | 1217 | 160376 | O | 46 | NT | 2
13 | 1217 | 160381 | O | 46 | NT | 2
13 | 1217 | 160386 | I | 75 | NT | 2
13 | 1217 | 160390 | O | 75 | NT | 2
13 | 1218 | 160413 | I | 67 | NT | 2
13 | 1218 | 160403 | O | 67 | NT | 2
13 | 1218 | 160402 | I | 72 | NT | 2
13 | 1218 | 160411 | O | 72 | NT | 2
13 | 1218 | 160412 | I | 80 | NT | 2
13 | 1218 | 160408 | O | 80 | NT | 2
14 | 1216 | 160358 | I | 46 | NT | 2
14 | 1216 | 160359 | O | 46 | NT | 2
14 | 1216 | 160350 | I | 62 | NT | 2
14 | 1216 | 160355 | O | 62 | NT | 2
14 | 1216 | 160366 | I | 84 | NT | 2
14 | 1216 | 160368 | O | 84 | NT | 2
14 | 1221 | 160480 | I | 63 | NT | 2
14 | 1221 | 160482 | O | 63 | NT | 2
14 | 1221 | 160466 | I | 83 | NT | 2
14 | 1221 | 160473 | O | 83 | NT | 2
14 | 1221 | 160483 | I | 90 | NT | 2
14 | 1221 | 160476 | O | 90 | NT | 2
15 | 1201 | 160018 | I | 71 | NT | 2
15 | 1201 | 160008 | O | 71 | NT | 2
15 | 1201 | 160019 | I | 74 | NT | 2
15 | 1201 | 160015 | O | 74 | NT | 2
15 | 1201 | 160010 | I | 85 | NT | 2
15 | 1201 | 160005 | O | 85 | NT | 2
15 | 1207 | 160155 | I | 46 | NT | 2
15 | 1207 | 160161 | O | 46 | NT | 2
15 | 1207 | 160160 | I | 68 | NT | 2
15 | 1207 | 160151 | O | 68 | NT | 2
15 | 1207 | 160158 | I | 77 | NT | 2
15 | 1207 | 160159 | O | 77 | NT | 2
16 | 1206 | 160138 | I | 46 | NT | 2
16 | 1206 | 160137 | I | 46 | NT | 2
16 | 1206 | 160134 | O | 46 | NT | 2
16 | 1206 | 160132 | O | 46 | NT | 2
16 | 1206 | 160135 | I | 73 | NT | 2
16 | 1206 | 160130 | O | 73 | NT | 2
16 | 1224 | 160541 | I | 67 | NT | 2
16 | 1224 | 160543 | O | 67 | NT | 2
16 | 1224 | 160546 | I | 72 | NT | 2
16 | 1224 | 160550 | O | 72 | NT | 2
17 | 1212 | 160275 | I | 69 | NT | 2
17 | 1212 | 160272 | O | 69 | NT | 2
17 | 1212 | 160270 | I | 84 | NT | 2
17 | 1212 | 160276 | O | 84 | NT | 2
17 | 1212 | 160265 | I | 87 | NT | 2
17 | 1212 | 160268 | O | 87 | NT | 2
17 | 1223 | 160529 | I | 71 | NT | 2
17 | 1223 | 160528 | O | 71 | NT | 2
17 | 1223 | 160516 | I | 76 | NT | 2
17 | 1223 | 160523 | O | 76 | NT | 2
17 | 1223 | 160526 | I | 83 | NT | 2
17 | 1223 | 160519 | O | 83 | NT | 2
18 | 1208 | 160179 | I | 66 | NT | 2
18 | 1208 | 160174 | O | 66 | NT | 2
18 | 1208 | 160182 | I | 71 | NT | 2
18 | 1208 | 160173 | O | 71 | NT | 2
18 | 1213 | 160289 | I | 76 | NT | 2
18 | 1213 | 160293 | O | 76 | NT | 2
18 | 1213 | 160290 | I | 80 | NT | 2
18 | 1213 | 160287 | O | 80 | NT | 2
18 | 1213 | 160294 | I | 87 | NT | 2
18 | 1213 | 160288 | O | 87 | NT | 2
19 | 1211 | 160253 | I | 60 | NT | 2
19 | 1211 | 160252 | O | 60 | NT | 2
19 | 1211 | 160245 | I | 74 | NT | 2
19 | 1211 | 160242 | O | 74 | NT | 2
19 | 1211 | 160247 | I | 85 | NT | 2
19 | 1211 | 160243 | O | 85 | NT | 2
19 | 1220 | 160455 | I | 79 | NT | 2
19 | 1220 | 160448 | I | 79 | NT | 2
19 | 1220 | 160449 | O | 79 | NT | 2
19 | 1220 | 160451 | O | 79 | NT | 2
19 | 1220 | 160457 | I | 85 | NT | 2
19 | 1220 | 160458 | O | 85 | NT | 2
20 | 1204 | 160083 | I | 62 | NT | 2
20 | 1204 | 160084 | O | 62 | NT | 2
20 | 1204 | 160075 | I | 90 | NT | 2
20 | 1204 | 160086 | O | 90 | NT | 2
20 | 1204 | 160079 | I | 2 | ST | 2
20 | 1204 | 160077 | O | 2 | ST | 2
20 | 1205 | 160115 | I | 67 | NT | 2
20 | 1205 | 160112 | I | 67 | NT | 2
20 | 1205 | 160113 | O | 67 | NT | 2
20 | 1205 | 160111 | O | 67 | NT | 2
20 | 1205 | 160114 | I | 86 | NT | 2
20 | 1205 | 160108 | O | 86 | NT | 2
21 | 1219 | 160426 | I | 64 | NT | 2
21 | 1219 | 160431 | O | 64 | NT | 2
21 | 1219 | 160430 | I | 71 | NT | 2
21 | 1219 | 160428 | O | 71 | NT | 2
21 | 1219 | 160418 | I | 81 | NT | 2
21 | 1219 | 160421 | O | 81 | NT | 2
21 | 1222 | 160497 | I | 46 | NT | 2
21 | 1222 | 160495 | O | 46 | NT | 2
21 | 1222 | 160499 | I | 62 | NT | 2
21 | 1222 | 160498 | O | 62 | NT | 2
21 | 1222 | 160503 | I | 70 | NT | 2
21 | 1222 | 160501 | O | 70 | NT | 2
22 | 1203 | 160063 | I | 57 | NT | 2
22 | 1203 | 160060 | O | 57 | NT | 2
22 | 1203 | 160068 | I | 64 | NT | 2
22 | 1203 | 160058 | O | 64 | NT | 2
22 | 1203 | 160066 | I | 83 | NT | 2
22 | 1203 | 160067 | O | 83 | NT | 2
22 | 1215 | 160337 | I | 62 | NT | 2
22 | 1215 | 160336 | O | 62 | NT | 2
22 | 1215 | 160338 | I | 71 | NT | 2
22 | 1215 | 160335 | O | 71 | NT | 2
22 | 1215 | 160342 | I | 79 | NT | 2
22 | 1215 | 160343 | O | 79 | NT | 2
23 | 1209 | 160201 | I | 66 | NT | 2
23 | 1209 | 160205 | I | 66 | NT | 2
23 | 1209 | 160206 | O | 66 | NT | 2
23 | 1209 | 160200 | O | 66 | NT | 2
23 | 1209 | 160207 | I | 84 | NT | 2
23 | 1209 | 160191 | O | 84 | NT | 2
23 | 1210 | 160223 | I | 65 | NT | 2
23 | 1210 | 160222 | O | 65 | NT | 2
23 | 1210 | 160227 | I | 69 | NT | 2
23 | 1210 | 160226 | O | 69 | NT | 2
23 | 1210 | 160228 | I | 84 | NT | 2
23 | 1210 | 160230 | O | 84 | NT | 2
24 | 1202 | 160042 | I | 65 | NT | 2
24 | 1202 | 160034 | O | 65 | NT | 2
24 | 1202 | 160044 | I | 85 | NT | 2
24 | 1202 | 160041 | O | 85 | NT | 2
24 | 1202 | 160033 | I | 87 | NT | 2
24 | 1202 | 160038 | O | 87 | NT | 2
24 | 1214 | 160313 | I | 71 | NT | 2
24 | 1214 | 160321 | O | 71 | NT | 2
24 | 1214 | 160319 | I | 83 | NT | 2
24 | 1214 | 160311 | O | 83 | NT | 2
24 | 1214 | 160315 | I | 89 | NT | 2
24 | 1214 | 160320 | O | 89 | NT | 2
25 | 1201 | 160020 | I | 59 | NT | 2
25 | 1201 | 160023 | O | 59 | NT | 2
25 | 1201 | 160018 | I | 77 | NT | 2
25 | 1201 | 160016 | O | 77 | NT | 2
25 | 1201 | 160013 | I | 83 | NT | 2
25 | 1201 | 160012 | O | 83 | NT | 2
25 | 1216 | 160362 | I | 46 | NT | 2
25 | 1216 | 160361 | O | 46 | NT | 2
25 | 1216 | 160364 | I | 57 | NT | 2
25 | 1216 | 160365 | O | 57 | NT | 2
25 | 1216 | 160366 | I | 68 | NT | 2
25 | 1216 | 160360 | O | 68 | NT | 2
26 | 1207 | 160154 | I | 63 | NT | 2
26 | 1207 | 160151 | O | 63 | NT | 2
26 | 1207 | 160153 | I | 77 | NT | 2
26 | 1207 | 160160 | O | 77 | NT | 2
26 | 1221 | 160482 | I | 74 | NT | 2
26 | 1221 | 160480 | O | 74 | NT | 2
26 | 1221 | 160474 | I | 79 | NT | 2
26 | 1221 | 160476 | O | 79 | NT | 2
26 | 1221 | 160466 | I | 86 | NT | 2
26 | 1221 | 160481 | O | 86 | NT | 2
27 | 1217 | 160372 | I | 46 | NT | 2
27 | 1217 | 160373 | O | 46 | NT | 2
27 | 1217 | 160381 | I | 52 | NT | 2
27 | 1217 | 160386 | O | 52 | NT | 2
27 | 1217 | 160384 | I | 70 | NT | 2
27 | 1217 | 160391 | O | 70 | NT | 2
27 | 1224 | 160541 | I | 74 | NT | 2
27 | 1224 | 160540 | O | 74 | NT | 2
27 | 1224 | 160542 | I | 76 | NT | 2
27 | 1224 | 160543 | O | 76 | NT | 2
27 | 1224 | 160548 | I | 83 | NT | 2
27 | 1224 | 160547 | O | 83 | NT | 2
28 | 1206 | 160136 | I | 56 | NT | 2
28 | 1206 | 160133 | O | 56 | NT | 2
28 | 1206 | 160126 | I | 61 | NT | 2
28 | 1206 | 160130 | O | 61 | NT | 2
28 | 1206 | 160134 | I | 76 | NT | 2
28 | 1206 | 160137 | O | 76 | NT | 2
28 | 1218 | 160402 | I | 57 | NT | 2
28 | 1218 | 160403 | O | 57 | NT | 2
28 | 1218 | 160396 | I | 67 | NT | 2
28 | 1218 | 160409 | O | 67 | NT | 2
28 | 1218 | 160400 | I | 78 | NT | 2
28 | 1218 | 160411 | O | 78 | NT | 2
29 | 1213 | 160287 | I | 46 | NT | 2
29 | 1213 | 160296 | O | 46 | NT | 2
29 | 1213 | 160288 | I | 71 | NT | 2
29 | 1213 | 160290 | O | 71 | NT | 2
29 | 1213 | 160295 | I | 3 | ST | 2
29 | 1213 | 160298 | O | 3 | ST | 2
29 | 1223 | 160519 | I | 73 | NT | 2
29 | 1223 | 160526 | O | 73 | NT | 2
29 | 1223 | 160524 | I | 1 | ST | 2
29 | 1223 | 160529 | O | 1 | ST | 2
30 | 1208 | 160179 | I | 55 | NT | 2
30 | 1208 | 160174 | O | 55 | NT | 2
30 | 1208 | 160180 | I | 69 | NT | 2
30 | 1208 | 160175 | O | 69 | NT | 2
30 | 1208 | 160167 | I | 76 | NT | 2
30 | 1208 | 160165 | O | 76 | NT | 2
30 | 1212 | 160274 | I | 59 | NT | 2
30 | 1212 | 160276 | O | 59 | NT | 2
30 | 1212 | 160270 | I | 70 | NT | 2
30 | 1212 | 160272 | O | 70 | NT | 2
30 | 1212 | 160275 | I | 84 | NT | 2
30 | 1212 | 160268 | O | 84 | NT | 2
31 | 1205 | 160115 | I | 57 | NT | 2
31 | 1205 | 160107 | O | 57 | NT | 2
31 | 1205 | 160112 | I | 71 | NT | 2
31 | 1205 | 160104 | O | 71 | NT | 2
31 | 1205 | 160105 | I | 90 | NT | 2
31 | 1205 | 160108 | O | 90 | NT | 2
31 | 1222 | 160498 | I | 61 | NT | 2
31 | 1222 | 160502 | O | 61 | NT | 2
31 | 1222 | 160499 | I | 69 | NT | 2
31 | 1222 | 160506 | O | 69 | NT | 2
31 | 1222 | 160505 | I | 90 | NT | 2
31 | 1222 | 160504 | O | 90 | NT | 2
32 | 1204 | 160083 | I | 82 | NT | 2
32 | 1204 | 160087 | O | 82 | NT | 2
32 | 1204 | 160088 | I | 90 | NT | 2
32 | 1204 | 160092 | O | 90 | NT | 2
32 | 1204 | 160090 | I | 2 | ST | 2
32 | 1204 | 160085 | O | 2 | ST | 2
32 | 1219 | 160426 | I | 60 | NT | 2
32 | 1219 | 160436 | O | 60 | NT | 2
32 | 1219 | 160433 | I | 67 | NT | 2
32 | 1219 | 160435 | O | 67 | NT | 2
32 | 1219 | 160432 | I | 84 | NT | 2
32 | 1219 | 160428 | O | 84 | NT | 2
33 | 1202 | 160042 | I | 46 | NT | 2
33 | 1202 | 160045 | I | 46 | NT | 2
33 | 1202 | 160031 | O | 46 | NT | 2
33 | 1202 | 160038 | O | 46 | NT | 2
33 | 1202 | 160039 | I | 78 | NT | 2
33 | 1202 | 160041 | O | 78 | NT | 2
33 | 1210 | 160211 | I | 71 | NT | 2
33 | 1210 | 160226 | O | 71 | NT | 2
33 | 1210 | 160219 | I | 80 | NT | 2
33 | 1210 | 160230 | O | 80 | NT | 2
33 | 1210 | 160214 | I | 86 | NT | 2
33 | 1210 | 160229 | O | 86 | NT | 2
34 | 1209 | 160188 | I | 46 | NT | 2
34 | 1209 | 160203 | O | 46 | NT | 2
34 | 1209 | 160204 | I | 71 | NT | 2
34 | 1209 | 160207 | O | 71 | NT | 2
34 | 1209 | 160200 | I | 83 | NT | 2
34 | 1209 | 160198 | O | 83 | NT | 2
34 | 1214 | 160316 | I | 46 | NT | 2
34 | 1214 | 160314 | O | 46 | NT | 2
34 | 1214 | 160321 | I | 61 | NT | 2
34 | 1214 | 160311 | O | 61 | NT | 2
34 | 1214 | 160313 | I | 81 | NT | 2
34 | 1214 | 160320 | O | 81 | NT | 2
35 | 1211 | 160237 | I | 60 | NT | 2
35 | 1211 | 160240 | O | 60 | NT | 2
35 | 1211 | 160251 | I | 74 | NT | 2
35 | 1211 | 160250 | O | 74 | NT | 2
35 | 1211 | 160249 | I | 81 | NT | 2
35 | 1211 | 160238 | O | 81 | NT | 2
35 | 1215 | 160338 | I | 70 | NT | 2
35 | 1215 | 160344 | O | 70 | NT | 2
35 | 1215 | 160335 | I | 77 | NT | 2
35 | 1215 | 160336 | O | 77 | NT | 2
35 | 1215 | 160340 | I | 90 | NT | 2
35 | 1215 | 160343 | O | 90 | NT | 2
36 | 1203 | 160068 | I | 71 | NT | 2
36 | 1203 | 160058 | O | 71 | NT | 2
36 | 1203 | 160066 | I | 87 | NT | 2
36 | 1203 | 160067 | O | 87 | NT | 2
36 | 1203 | 160069 | I | 2 | ST | 2
36 | 1203 | 160062 | O | 2 | ST | 2
36 | 1220 | 160458 | I | 63 | NT | 2
36 | 1220 | 160457 | O | 63 | NT | 2
36 | 1220 | 160448 | I | 70 | NT | 2
36 | 1220 | 160454 | O | 70 | NT | 2
36 | 1220 | 160450 | I | 82 | NT | 2
36 | 1220 | 160451 | O | 82 | NT | 2
37 | 1213 | 160289 | I | 101 | ET | 1
37 | 1213 | 160293 | O | 101 | ET | 1
37 | 1213 | 160294 | I | 104 | ET | 1
37 | 1213 | 160288 | O | 104 | ET | 1
37 | 1221 | 160480 | I | 58 | NT | 2
37 | 1221 | 160473 | O | 58 | NT | 2
37 | 1221 | 160479 | I | 70 | NT | 2
37 | 1221 | 160481 | O | 70 | NT | 2
37 | 1221 | 160474 | I | 77 | NT | 2
37 | 1221 | 160472 | O | 77 | NT | 2
38 | 1212 | 160276 | I | 69 | NT | 2
38 | 1212 | 160272 | O | 69 | NT | 2
38 | 1212 | 160275 | I | 79 | NT | 2
38 | 1212 | 160271 | O | 79 | NT | 2
38 | 1212 | 160270 | I | 84 | NT | 2
38 | 1212 | 160262 | O | 84 | NT | 2
38 | 1224 | 160550 | I | 55 | NT | 2
38 | 1224 | 160551 | O | 55 | NT | 2
38 | 1224 | 160546 | I | 63 | NT | 2
38 | 1224 | 160543 | O | 63 | NT | 2
39 | 1204 | 160092 | I | 110 | ET | 2
39 | 1204 | 160086 | O | 110 | ET | 2
39 | 1204 | 160090 | I | 120 | ET | 2
39 | 1204 | 160073 | O | 120 | ET | 2
39 | 1204 | 160089 | I | 88 | NT | 2
39 | 1204 | 160091 | O | 88 | NT | 2
39 | 1214 | 160313 | I | 117 | ET | 2
39 | 1214 | 160310 | O | 117 | ET | 2
39 | 1214 | 160316 | I | 50 | NT | 2
39 | 1214 | 160311 | O | 50 | NT | 2
39 | 1214 | 160321 | I | 87 | NT | 2
39 | 1214 | 160313 | O | 87 | NT | 2
40 | 1207 | 160151 | I | 46 | NT | 2
40 | 1207 | 160152 | O | 46 | NT | 2
40 | 1207 | 160158 | I | 73 | NT | 2
40 | 1207 | 160159 | O | 73 | NT | 2
40 | 1207 | 160157 | I | 2 | ST | 2
40 | 1207 | 160151 | O | 2 | ST | 2
40 | 1215 | 160345 | I | 65 | NT | 2
40 | 1215 | 160344 | O | 65 | NT | 2
40 | 1215 | 160331 | I | 68 | NT | 2
40 | 1215 | 160337 | O | 68 | NT | 2
40 | 1215 | 160335 | I | 71 | NT | 2
40 | 1215 | 160336 | O | 71 | NT | 2
41 | 1208 | 160167 | I | 72 | NT | 2
41 | 1208 | 160184 | I | 72 | NT | 2
41 | 1208 | 160165 | O | 72 | NT | 2
41 | 1208 | 160173 | O | 72 | NT | 2
41 | 1208 | 160180 | I | 76 | NT | 2
41 | 1208 | 160175 | O | 76 | NT | 2
41 | 1218 | 160404 | I | 46 | NT | 2
41 | 1218 | 160411 | O | 46 | NT | 2
41 | 1218 | 160414 | I | 64 | NT | 2
41 | 1218 | 160412 | O | 64 | NT | 2
41 | 1218 | 160399 | I | 84 | NT | 2
41 | 1218 | 160396 | O | 84 | NT | 2
42 | 1203 | 160058 | I | 70 | NT | 2
42 | 1203 | 160068 | O | 70 | NT | 2
42 | 1203 | 160065 | I | 76 | NT | 2
42 | 1203 | 160067 | O | 76 | NT | 2
42 | 1203 | 160061 | I | 81 | NT | 2
42 | 1203 | 160062 | O | 81 | NT | 2
42 | 1209 | 160196 | I | 46 | NT | 2
42 | 1209 | 160203 | O | 46 | NT | 2
42 | 1209 | 160205 | I | 75 | NT | 2
42 | 1209 | 160195 | O | 75 | NT | 2
42 | 1209 | 160201 | I | 79 | NT | 2
42 | 1209 | 160191 | O | 79 | NT | 2
43 | 1211 | 160245 | I | 54 | NT | 2
43 | 1211 | 160242 | O | 54 | NT | 2
43 | 1211 | 160251 | I | 82 | NT | 2
43 | 1211 | 160248 | O | 82 | NT | 2
43 | 1211 | 160237 | I | 84 | NT | 2
43 | 1211 | 160243 | O | 84 | NT | 2
43 | 1219 | 160433 | I | 46 | NT | 2
43 | 1219 | 160436 | O | 46 | NT | 2
43 | 1219 | 160434 | I | 70 | NT | 2
43 | 1219 | 160435 | O | 70 | NT | 2
43 | 1219 | 160437 | I | 81 | NT | 2
43 | 1219 | 160433 | O | 81 | NT | 2
44 | 1206 | 160133 | I | 46 | NT | 2
44 | 1206 | 160128 | O | 46 | NT | 2
44 | 1206 | 160138 | I | 60 | NT | 2
44 | 1206 | 160132 | O | 60 | NT | 2
44 | 1206 | 160135 | I | 87 | NT | 2
44 | 1206 | 160136 | O | 87 | NT | 2
44 | 1210 | 160211 | I | 76 | NT | 2
44 | 1210 | 160230 | O | 76 | NT | 2
44 | 1210 | 160219 | I | 89 | NT | 2
44 | 1210 | 160226 | O | 89 | NT | 2
45 | 1213 | 160289 | I | 98 | ET | 1
45 | 1213 | 160293 | O | 98 | ET | 1
45 | 1213 | 160290 | I | 82 | NT | 2
45 | 1213 | 160288 | O | 82 | NT | 2
45 | 1214 | 160313 | I | 96 | ET | 1
45 | 1214 | 160318 | O | 96 | ET | 1
45 | 1214 | 160314 | I | 70 | NT | 2
45 | 1214 | 160310 | O | 70 | NT | 2
45 | 1214 | 160321 | I | 80 | NT | 2
45 | 1214 | 160313 | O | 80 | NT | 2
46 | 1203 | 160061 | I | 46 | NT | 2
46 | 1203 | 160058 | O | 46 | NT | 2
46 | 1203 | 160068 | I | 75 | NT | 2
46 | 1203 | 160054 | O | 75 | NT | 2
46 | 1203 | 160065 | I | 83 | NT | 2
46 | 1203 | 160067 | O | 83 | NT | 2
46 | 1224 | 160542 | I | 78 | NT | 2
46 | 1224 | 160543 | O | 78 | NT | 2
46 | 1224 | 160551 | I | 80 | NT | 2
46 | 1224 | 160550 | O | 80 | NT | 2
46 | 1224 | 160534 | I | 90 | NT | 2
46 | 1224 | 160544 | O | 90 | NT | 2
47 | 1208 | 160180 | I | 16 | NT | 1
47 | 1208 | 160175 | O | 16 | NT | 1
47 | 1208 | 160173 | I | 72 | NT | 2
47 | 1208 | 160182 | O | 72 | NT | 2
47 | 1211 | 160253 | I | 120 | ET | 2
47 | 1211 | 160236 | O | 120 | ET | 2
47 | 1211 | 160237 | I | 86 | NT | 2
47 | 1211 | 160243 | O | 86 | NT | 2
47 | 1211 | 160251 | I | 108 | NT | 2
47 | 1211 | 160248 | O | 108 | NT | 2
48 | 1207 | 160158 | I | 60 | NT | 2
48 | 1207 | 160159 | O | 60 | NT | 2
48 | 1207 | 160146 | I | 72 | NT | 2
48 | 1207 | 160145 | O | 72 | NT | 2
48 | 1207 | 160151 | I | 80 | NT | 2
48 | 1207 | 160154 | O | 80 | NT | 2
48 | 1210 | 160214 | I | 46 | NT | 2
48 | 1210 | 160227 | I | 46 | NT | 2
48 | 1210 | 160220 | O | 46 | NT | 2
48 | 1210 | 160226 | O | 46 | NT | 2
48 | 1210 | 160228 | I | 83 | NT | 2
48 | 1210 | 160230 | O | 83 | NT | 2
49 | 1214 | 160311 | I | 74 | NT | 2
49 | 1214 | 160316 | O | 74 | NT | 2
49 | 1214 | 160314 | I | 79 | NT | 2
49 | 1214 | 160310 | O | 79 | NT | 2
49 | 1214 | 160321 | I | 86 | NT | 2
49 | 1214 | 160320 | O | 86 | NT | 2
49 | 1224 | 160551 | I | 58 | NT | 2
49 | 1224 | 160543 | O | 58 | NT | 2
49 | 1224 | 160548 | I | 63 | NT | 2
49 | 1224 | 160550 | O | 63 | NT | 2
49 | 1224 | 160546 | I | 66 | NT | 2
49 | 1224 | 160534 | O | 66 | NT | 2
50 | 1207 | 160152 | I | 71 | NT | 2
50 | 1207 | 160154 | O | 71 | NT | 2
50 | 1207 | 160158 | I | 78 | NT | 2
50 | 1207 | 160159 | O | 78 | NT | 2
50 | 1207 | 160150 | I | 2 | ST | 2
50 | 1207 | 160160 | O | 2 | ST | 2
50 | 1208 | 160170 | I | 61 | NT | 2
50 | 1208 | 160165 | O | 61 | NT | 2
50 | 1208 | 160174 | I | 67 | NT | 2
50 | 1208 | 160172 | O | 67 | NT | 2
50 | 1208 | 160178 | I | 79 | NT | 2
50 | 1208 | 160180 | O | 79 | NT | 2
51 | 1207 | 160161 | I | 110 | ET | 2
51 | 1207 | 160154 | O | 110 | ET | 2
51 | 1207 | 160151 | I | 58 | NT | 2
51 | 1207 | 160154 | O | 58 | NT | 2
51 | 1207 | 160158 | I | 78 | NT | 2
51 | 1207 | 160159 | O | 78 | NT | 2
51 | 1214 | 160321 | I | 25 | NT | 1
51 | 1214 | 160322 | O | 25 | NT | 1
51 | 1214 | 160314 | I | 66 | NT | 2
51 | 1214 | 160310 | O | 66 | NT | 2
51 | 1214 | 160319 | I | 79 | NT | 2
51 | 1214 | 160316 | O | 79 | NT | 2
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

Sql programming
match_no | country_name | player_name | jersey_no | time_in_out ----------+--------------+-------------------------+-----------+------------- 9 | Sweden | Erik Johansson | 3 | 45 47 | Germany | Bastian Schweinsteiger | 7 | 16 51 | Portugal | Ricardo Quaresma | 20 | 25 (3 rows)need an explanation for this answer? contact us directly to get an explanation for this answer