4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Köln II - Schalke 04 II
Jornada 7
FINALIZADO
30
20
290 Pts. Elo
4º

302 Pts. Elo
11º

2-1
Sábado, 16 Septiembre 2023, 14:00
Justin Diehl 24'
1 - 0
1 - 1
 64' P. Pöpperl
Joâo Pinto 89'
2 - 1

Eventos del partido

Goles

Justin DiehlGol de
Justin Diehl
minuto 24'
minuto 64'P. PöpperlGol de P. Pöpperl
Joâo PintoGol de
Joâo Pinto
minuto 89'

Tarjetas

minuto 19'Ngufor AnubodemT. Amarilla Ngufor Anubodem
O. SchmittT. Amarilla
O. Schmitt
minuto 27'
M. HögerT. Amarilla
M. Höger
minuto 29'
minuto 44'Verthomy BoboyT. Amarilla Verthomy Boboy
Max FinkgräfeT. Amarilla
Max Finkgräfe
minuto 95'

Cambios

Meiko WäschenbachSale del partido
Meiko Wäschenbach
minuto 44'
Jonas SaligerEntra en el partido
Jonas Saliger
minuto 44'
minuto 46'T. AlbutatSale del partido T. Albutat
minuto 46'F. HeiserholtEntra en el partido F. Heiserholt
Joâo PintoEntra en el partido
Joâo Pinto
minuto 54'
Justin DiehlSale del partido
Justin Diehl
minuto 54'
minuto 65'P. LasoggaSale del partido P. Lasogga
minuto 65'Ngufor AnubodemSale del partido Ngufor Anubodem
minuto 65'Kelsey Aninkorah-MeiselEntra en el partido Kelsey Aninkorah-Meisel
minuto 65'G. Bokake BolufeEntra en el partido G. Bokake Bolufe
minuto 75'Verthomy BoboySale del partido Verthomy Boboy
minuto 75'Tim SchmidtEntra en el partido Tim Schmidt
Pierre NadjombeSale del partido
Pierre Nadjombe
minuto 82'
Meiko SponselEntra en el partido
Meiko Sponsel
minuto 82'
M. HögerSale del partido
M. Höger
minuto 82'
G. StrauchSale del partido
G. Strauch
minuto 82'
Emin KujovicEntra en el partido
Emin Kujovic
minuto 82'
Adam LengesEntra en el partido
Adam Lenges
minuto 82'
minuto 87'Yannick TonyeEntra en el partido Yannick Tonye
minuto 87'P. PöpperlSale del partido P. Pöpperl

Alineaciones

Köln II

Köln II

4-4-2
Alineación Inicial
Suplentes
Schalke 04 II

Schalke 04 II

4-4-2
Alineación Inicial
Suplentes



  USO DE MEMORIA  
6,724,336 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0015
Controller Execution Time ( Match / Index )  0.3630
Total Execution Time  0.3646
  CADENA URL  
/partido/Koln-Ii/Schalke-04-Ii/2016?section=legal
  GET DATOS  
$_GET['/partido/Koln-Ii/Schalke-04-Ii/2016']  
$_GET['section']   legal
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (10)  
0.0124  SELECT data1 FROM stats2024 t WHERE league_id = 72582 AND teamId = 6590344 and type = 33
0.0124  SELECT data1 FROM stats2024 t WHERE league_id = 72582 AND teamId = 6590348 and type = 33
0.0127  SELECT p.* FROM `videos` as p INNER JOIN `rel_videos` as rp ON p.id = rp.id_video WHERE rp.id_content = '126475' and rp.type = 2024 and p.revised = 1 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0125  SELECT iframe, title FROM futbol.match_videos WHERE matchId = 126475 AND year = 2024 AND channel = 'Footters' LIMIT 1
0.0125  SELECT iframe, title FROM futbol.match_videos WHERE matchId = 126475 AND year = 2024 AND channel = 'Footters' LIMIT 1
0.0125  SELECT `id`, `text` FROM `matchs_news_keys` WHERE `match_id`='126475' AND `active` = 1 AND year = 2024
0.0157  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='72582' AND relp.team_id=6590344 WHERE relp.in_squad=1 and mp.`match_id` = '126475' AND mp.year='2024' ORDER BY mp.`team` ASC, p.`role` ASC
0.0158  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='72582' AND relp.team_id=6590348 WHERE relp.in_squad=1 and mp.`match_id` = '126475' AND mp.year='2024' ORDER BY mp.`team` ASC, p.`role` ASC
0.0125  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=126475 AND extraId = 72582 AND type_rel = 4
0.0125  SELECT * FROM futbol.calendars_lineups WHERE id = 126475 AND league_id = 72582 AND year = 2024