4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Köln - Holstein Kiel
Final
FINALIZADO
40
30
1958 Pts. Elo
53%

1310 Pts. Elo
47%

0-1
Miércoles, 26 Mayo 2021, 18:30
0 - 1
 59' S. Lorenz

Eventos del partido

Goles

minuto 59'S. LorenzGol de S. Lorenz

Tarjetas

N. KatterbachT. Amarilla
N. Katterbach
minuto 14'
minuto 41'F. BartelsT. Amarilla F. Bartels
minuto 45'Aleksandar IgnjovskiT. Amarilla Aleksandar Ignjovski
minuto 46'J. Van Den BerghT. Amarilla J. Van Den Bergh
Ellyes SkhiriT. Amarilla
Ellyes Skhiri
minuto 51'
Marius WolfT. Amarilla
Marius Wolf
minuto 53'
R. CzichosT. Amarilla
R. Czichos
minuto 90'

Cambios

N. KatterbachSale del partido
N. Katterbach
minuto 46'
D. DrexlerEntra en el partido
D. Drexler
minuto 46'
minuto 59'Aleksandar IgnjovskiSale del partido Aleksandar Ignjovski
minuto 59'S. LorenzEntra en el partido S. Lorenz
S. AnderssonEntra en el partido
S. Andersson
minuto 66'
Marius WolfSale del partido
Marius Wolf
minuto 66'
Salih ÖzcanSale del partido
Salih Özcan
minuto 66'
Jan ThielmannEntra en el partido
Jan Thielmann
minuto 66'
minuto 67'F. PorathSale del partido F. Porath
minuto 67'F. ReeseEntra en el partido F. Reese
minuto 78'J. MeesEntra en el partido J. Mees
minuto 78'F. BartelsSale del partido F. Bartels
minuto 78'B. GirthEntra en el partido B. Girth
minuto 78'J. SerraSale del partido J. Serra

Otros

minuto 59'Jae-Sung LeeAsistencia Jae-Sung Lee

Alineaciones

Köln

Köln

4-5-1
Alineación Inicial
Suplentes
Holstein Kiel

Holstein Kiel

4-5-1
Alineación Inicial
Suplentes

Estadísticas del partido

Köln Köln Holstein Kiel Holstein
53%
Posesión del balón
 47%
0
Goles
 1
3
Tiros a puerta
 3
12
Tiros fuera
 6
15
Total tiros
 9
2
Paradas del portero
 3
9
Saques de esquina
 5
2
Fueras de juego
 0
4
Tarjetas Amarillas
 3
0
Tarjetas Rojas
 0
0
Asistencias
 1
3
Sustituciones
 3
21
Faltas
 20
1 Comentarios + 3 respuestas

Otros partidos

Holstein Kiel 1-5 Köln 198

  USO DE MEMORIA  
6,504,872 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0009
Controller Execution Time ( Match / Index )  1.8308
Total Execution Time  1.8317
  CADENA URL  
/partido/1-Fc-Koln/Holstein-Kiel/2021
  GET DATOS  
$_GET['/partido/1-Fc-Koln/Holstein-Kiel/2021']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (15)  
0.0126   SELECT ev.id AS event_id, ev.player_id, ev.action, ev.minute, ev.teamId AS event_teamId FROM events2021 AS ev WHERE ev.match_id=388058 ORDER BY (ev.action=1 OR ev.action=2 OR ev.action=6 OR ev.action=11 OR ev.action=12 OR ev.action=13) DESC,(ev.action=3 OR ev.action=4 OR ev.action=5) DESC,(ev.action=14 OR ev.action=15 OR ev.action=16 OR ev.action=17 OR ev.action=21) DESC,(ev.action=18 OR ev.action=19) DESC,(ev.action=20 OR ev.action=22) DESC, minute ASC, ev.real_date ASC, ev.id DESC, ev.action DESC
0.0131   SELECT dp.id AS player_id, dp.nick, dp.alias, dp.name, dp.last_name, rp.team_id, rp.teamId, rp.squadNumber AS num FROM dataplayers AS dp INNER JOIN rel_players AS rp ON dp.id=rp.player_id AND league_id=62695 WHERE dp.id IN (719327,477510,2023,56262,46998,226876,241258,200407,109324,212260,295697,622240,313029,290301,283026,292353,289104,495416) AND (rp.team_id=6441756 OR rp.team_id=6441757)
0.0126   SELECT ev.id AS event_id, ev.player_id, ev.action, ev.minute, ev.teamId AS event_teamId FROM events2021 AS ev WHERE ev.match_id=388058 ORDER BY ev.minute ASC, ev.real_date ASC, ev.id DESC
0.0132   SELECT dp.id AS player_id, dp.nick, dp.alias, dp.name, dp.last_name, rp.team_id, rp.teamId, rp.squadNumber AS num FROM dataplayers AS dp INNER JOIN rel_players AS rp ON dp.id=rp.player_id AND league_id=62695 WHERE dp.id IN (477510,2023,56262,109324,46998,226876,241258,495416,719327,212260,295697,622240,313029,290301,283026,292353,289104,200407) AND (rp.team_id=6441756 OR rp.team_id=6441757)
0.0127  SELECT data1 FROM stats2021 t WHERE league_id = 62695 AND teamId = 6441756 and type = 33
0.0125  SELECT data1 FROM stats2021 t WHERE league_id = 62695 AND teamId = 6441757 and type = 33
0.0129  SELECT p.* FROM `videos` as p INNER JOIN `rel_videos` as rp ON p.id = rp.id_video WHERE rp.id_content = '388058' and rp.type = 2021 and p.revised = 1 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0128  SELECT iframe, title FROM futbol.match_videos WHERE matchId = 388058 AND year = 2021 AND channel = 'Footters' LIMIT 1
0.0127  SELECT iframe, title FROM futbol.match_videos WHERE matchId = 388058 AND year = 2021 AND channel = 'Footters' LIMIT 1
0.0126  SELECT `id`, `text` FROM `matchs_news_keys` WHERE `match_id`='388058' AND `active` = 1 AND year = 2021
0.0155  SELECT mp.`player_id`, p.`nick`, p.`name`, p.`last_name`, mp.`team`, p.role, p.alias, relp.squadNumber as num, p.CountryCode FROM `matchs_players_called` AS mp INNER JOIN `dataplayers` AS p ON mp.`player_id` = p.`id` INNER JOIN rel_players AS relp ON relp.player_id=p.id AND relp.league_id='62695' AND relp.team_id=6441756 WHERE relp.in_squad=1 and mp.`match_id` = '388058' AND mp.year='2021' ORDER BY mp.`team` ASC, p.`role` ASC
0.0203  SELECT mp.`player_id`, p.`nick`, p.`name`, p.`last_name`, mp.`team`, p.role, p.alias, relp.squadNumber as num, p.CountryCode FROM `matchs_players_called` AS mp INNER JOIN `dataplayers` AS p ON mp.`player_id` = p.`id` INNER JOIN rel_players AS relp ON relp.player_id=p.id AND relp.league_id='62695' AND relp.team_id=6441757 WHERE relp.in_squad=1 and mp.`match_id` = '388058' AND mp.year='2021' ORDER BY mp.`team` ASC, p.`role` ASC
0.0125  SELECT position FROM tables2021 WHERE team=6441756 AND league_id=62695 AND round=1
0.0124  SELECT position FROM tables2021 WHERE team=6441757 AND league_id=62695 AND round=1
0.0124  SELECT * FROM futbol.calendars_lineups WHERE id = 388058 AND league_id = 62695 AND year = 2021