¿Eres mayor de edad?

SI NO

Confirma si tienes 18 años

Faldón apuestas
4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Chemnitzer FC Sub 19 - Carl Zeiss Jena Sub 19
Jornada 7
FINALIZADO
00
00
52 Pts. Elo
7º

63 Pts. Elo
3º

0-0
Sábado, 21 Septiembre 2024, 12:00

Eventos del partido

Cambios

minuto 46'Sinan YükselEntra en el partido Sinan Yüksel
minuto 46'Richard SteinhäuserSale del partido Richard Steinhäuser
Noah TänzerSale del partido
Noah Tänzer
minuto 58'
Kiran MauersbergerSale del partido
Kiran Mauersberger
minuto 58'
Ben SchmidtEntra en el partido
Ben Schmidt
minuto 58'
Aaron LampteyEntra en el partido
Aaron Lamptey
minuto 58'
minuto 60'Pit KirchhoffEntra en el partido Pit Kirchhoff
minuto 60'A. JozanovicSale del partido A. Jozanovic
minuto 70'Ron HasaniEntra en el partido Ron Hasani
minuto 70'Kimi MüllerSale del partido Kimi Müller
minuto 74'M. LanzendörferSale del partido M. Lanzendörfer
minuto 74'Constantin HaaseEntra en el partido Constantin Haase
Tilas TaubertSale del partido
Tilas Taubert
minuto 78'
Paul-Joel SauerSale del partido
Paul-Joel Sauer
minuto 78'
Marvin LenzEntra en el partido
Marvin Lenz
minuto 78'
Frederik KunstmannEntra en el partido
Frederik Kunstmann
minuto 78'
Loris BrücknerSale del partido
Loris Brückner
minuto 87'
Jonas UllmannEntra en el partido
Jonas Ullmann
minuto 87'

Alineaciones

Chemnitzer FC Sub 19

Chemnitzer FC Sub 19

4-4-2
Alineación Inicial
Suplentes
Carl Zeiss Jena Sub 19

Carl Zeiss Jena Sub 19

4-4-2
Alineación Inicial
Suplentes



  USO DE MEMORIA  
6,769,448 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0009
Controller Execution Time ( Match / Index )  0.8315
Total Execution Time  0.8325
  CADENA URL  
/partido/Chemnitzer-Sub19/Carl-Zeiss-Jena-Sub19
  GET DATOS  
$_GET['/partido/Chemnitzer-Sub19/Carl-Zeiss-Jena-Sub19']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (14)  
0.0019  SELECT data1 FROM stats2025 t WHERE league_id = 77070 AND teamId = 6656360 and type = 33
0.0021  SELECT data1 FROM stats2025 t WHERE league_id = 77070 AND teamId = 6656358 and type = 33
0.0023  SELECT p.* FROM `videos` as p INNER JOIN `rel_videos` as rp ON p.id = rp.id_video WHERE rp.id_content = '88558' and rp.type = 2025 and p.revised = 1 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0020  SELECT iframe, title FROM futbol.match_videos WHERE matchId = 88558 AND year = 2025 AND channel = 'Footters' LIMIT 1
0.0020  SELECT iframe, title FROM futbol.match_videos WHERE matchId = 88558 AND year = 2025 AND channel = 'Footters' LIMIT 1
0.0018  SELECT `id`, `text` FROM `matchs_news_keys` WHERE `match_id`='88558' AND `active` = 1 AND year = 2025
0.0029  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='77070' AND relp.team_id=6656360 WHERE relp.in_squad=1 and mp.`match_id` = '88558' AND mp.year='2025' ORDER BY mp.`team` ASC, p.`role` ASC
0.0040  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='77070' AND relp.team_id=6656358 WHERE relp.in_squad=1 and mp.`match_id` = '88558' AND mp.year='2025' ORDER BY mp.`team` ASC, p.`role` ASC
0.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=88558 AND extraId = 77070 AND type_rel = 4
0.0017  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=1586 AND type_rel = 3
0.0019  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 3 AND rel.typeId = 1586 AND rel.ln = 'es' AND rel.status=1 ORDER BY rel.creation_date desc,rel.cover_points DESC LIMIT 5
0.0022  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 (1324896,1197781,1187339,1177490,1177454) ORDER BY n.cover_points DESC, update_date DESC
0.0019  SELECT rating1, rating2 FROM calendars_elo WHERE id=88558 AND league_id=77070 AND year=2025
0.0021  SELECT * FROM futbol.calendars_lineups WHERE id = 88558 AND league_id = 77070 AND year = 2025