4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Jahn Regensburg II - Hankofen-Hailing
Jornada 9
FINALIZADO
11
10
160 Pts. Elo
10º

129 Pts. Elo
5º

1-3
Sábado, 02 Septiembre 2023, 16:00
0 - 1
 15' Tobias Lermer
0 - 2
 20' T. Beck
0 - 3
 36' T. Beck
Julian Ziegler 71'
1 - 3

Eventos del partido

Goles

minuto 15'Tobias LermerGol de Tobias Lermer
minuto 20'T. BeckGol de T. Beck
minuto 36'T. BeckGol de T. Beck
Julian ZieglerGol de
Julian Ziegler
minuto 71'

Tarjetas

J. BauerT. Amarilla
J. Bauer
minuto 29'
Kelvin OnuigweTarjeta Roja a
Kelvin Onuigwe
minuto 32'
minuto 85'Daniel RabanterT. Amarilla Daniel Rabanter

Cambios

Max MeyerEntra en el partido
Max Meyer
minuto 40'
Ajdin BajricSale del partido
Ajdin Bajric
minuto 40'
Noel EichingerSale del partido
Noel Eichinger
minuto 46'
Leopold WurmSale del partido
Leopold Wurm
minuto 46'
J. GriesbauerEntra en el partido
J. Griesbauer
minuto 46'
Amiro AmadouEntra en el partido
Amiro Amadou
minuto 46'
minuto 58'Tobias RichterSale del partido Tobias Richter
minuto 58'M. LummerEntra en el partido M. Lummer
Volodymyr KharabaraEntra en el partido
Volodymyr Kharabara
minuto 59'
J. BauerSale del partido
J. Bauer
minuto 59'
minuto 66'Tobias LermerSale del partido Tobias Lermer
minuto 66'Daniel RabanterEntra en el partido Daniel Rabanter
minuto 70'V. HarlanderEntra en el partido V. Harlander
minuto 70'David VoglSale del partido David Vogl
Kevin MassingerEntra en el partido
Kevin Massinger
minuto 79'
C. SchmidtSale del partido
C. Schmidt
minuto 79'
minuto 89'J. BlümelEntra en el partido J. Blümel
minuto 89'Brian WagnerSale del partido Brian Wagner

Alineaciones

Jahn Regensburg II

Jahn Regensburg II

4-4-2
Alineación Inicial
Suplentes
Hankofen-Hailing

Hankofen-Hailing

4-4-2
Alineación Inicial
Suplentes



  USO DE MEMORIA  
6,765,704 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0009
Controller Execution Time ( Match / Index )  0.3710
Total Execution Time  0.3720
  CADENA URL  
/partido/Jahn-Regensburg-Ii/Hankofen-Hailing
  GET DATOS  
$_GET['/partido/Jahn-Regensburg-Ii/Hankofen-Hailing']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (13)  
0.0017  SELECT data1 FROM stats2024 t WHERE league_id = 72393 AND teamId = 6588036 and type = 33
0.0017  SELECT data1 FROM stats2024 t WHERE league_id = 72393 AND teamId = 6588038 and type = 33
0.0020  SELECT p.* FROM `videos` as p INNER JOIN `rel_videos` as rp ON p.id = rp.id_video WHERE rp.id_content = '63228' and rp.type = 2024 and p.revised = 1 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0018  SELECT iframe, title FROM futbol.match_videos WHERE matchId = 63228 AND year = 2024 AND channel = 'Footters' LIMIT 1
0.0018  SELECT iframe, title FROM futbol.match_videos WHERE matchId = 63228 AND year = 2024 AND channel = 'Footters' LIMIT 1
0.0018  SELECT `id`, `text` FROM `matchs_news_keys` WHERE `match_id`='63228' AND `active` = 1 AND year = 2024
0.0051  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='72393' AND relp.team_id=6588036 WHERE relp.in_squad=1 and mp.`match_id` = '63228' AND mp.year='2024' ORDER BY mp.`team` ASC, p.`role` ASC
0.0034  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='72393' AND relp.team_id=6588038 WHERE relp.in_squad=1 and mp.`match_id` = '63228' AND mp.year='2024' ORDER BY mp.`team` ASC, p.`role` ASC
0.0017  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=63228 AND extraId = 72393 AND type_rel = 4
0.0017  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=573 AND type_rel = 3
0.0020  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 3 AND rel.typeId = 573 AND rel.ln = 'es' AND rel.status=1 ORDER BY rel.creation_date desc,rel.cover_points DESC LIMIT 5
0.0021  SELECT /*53 bs_news_model*/ n.id, n.author_id, n.headline, n.external_headline, n.live_headline, n.creation_date, n.update_date, n.pub_date, n.alias, n.subheadline, n.teaser, n.media, n.tags, n.views, n.screens, n.clicks, n.relations, n.comments, n.power_cover, n.cover_points, u.name as user_name FROM bs_news n INNER JOIN bs_editors u ON u.id = n.author_id AND u.ln = 'es' WHERE n.status = 1 AND n.ln = 'es' AND n.id IN (1313551,1247431,1040230,935468,822575) ORDER BY n.cover_points DESC, update_date DESC
0.0018  SELECT * FROM futbol.calendars_lineups WHERE id = 63228 AND league_id = 72393 AND year = 2024