¿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
FC 08 Homburg - Stuttgart II
Jornada 25
FINALIZADO
10
10
505 Pts. Elo
5º

414 Pts. Elo
3º

1-2
Viernes, 22 Marzo 2024, 19:00
D. Nothnagel 28'
1 - 0
1 - 1
 54' Anrie Chase
1 - 2
 94' Luca Raimund

Eventos del partido

Goles

D. Nothnagel Gol de (p.p)
D. Nothnagel
minuto28'
minuto 54'Anrie ChaseGol de Anrie Chase
minuto 94'Luca RaimundGol de Luca Raimund

Tarjetas

D. SchmidtT. Amarilla
D. Schmidt
minuto 39'
minuto 62'Luan SimnicaT. Amarilla Luan Simnica

Cambios

minuto 63'Luca RaimundEntra en el partido Luca Raimund
minuto 63'L. MünstSale del partido L. Münst
D. SchmidtSale del partido
D. Schmidt
minuto 65'
D. HummelEntra en el partido
D. Hummel
minuto 65'
minuto 69'Luan SimnicaSale del partido Luan Simnica
minuto 69'Jordan MeyerEntra en el partido Jordan Meyer
M. JansenSale del partido
M. Jansen
minuto 74'
M. DombrowkaEntra en el partido
M. Dombrowka
minuto 74'
D. OntuzansSale del partido
D. Ontuzans
minuto 83'
A. StavridisEntra en el partido
A. Stavridis
minuto 83'
minuto 87'Tom BarthEntra en el partido Tom Barth
minuto 87'Leon ReichardtSale del partido Leon Reichardt
minuto 87'Jannis BoziarisSale del partido Jannis Boziaris
minuto 87'Alexandre AzevedoEntra en el partido Alexandre Azevedo
minuto 88'P. KappEntra en el partido P. Kapp
minuto 88'C. DrakasSale del partido C. Drakas

Alineaciones

FC 08 Homburg

FC 08 Homburg

4-4-2
Alineación Inicial
Suplentes
Stuttgart II

Stuttgart II

4-4-2
Alineación Inicial
Suplentes



  USO DE MEMORIA  
6,671,696 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0009
Controller Execution Time ( Match / Index )  0.5727
Total Execution Time  0.5737
  CADENA URL  
/partido/Homburg/Stuttgart-Ii/2022?section=legal
  GET DATOS  
$_GET['/partido/Homburg/Stuttgart-Ii/2022']  
$_GET['section']   legal
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (15)  
0.0274  SELECT c.*, l.*, cou.name as namec, ct.table_sufix FROM (leagues l INNER JOIN categories c ON c.id = l.categoryId INNER JOIN categories_types ct ON c.ctype=ct.id LEFT JOIN country cou ON cou.Code2 = c.CountryCode) WHERE l.id = 72592
0.0126  SELECT data1 FROM stats2024 t WHERE league_id = 72592 AND teamId = 6590502 and type = 33
0.0126  SELECT data1 FROM stats2024 t WHERE league_id = 72592 AND teamId = 6590497 and type = 33
0.0136  SELECT p.* FROM `videos` as p INNER JOIN `rel_videos` as rp ON p.id = rp.id_video WHERE rp.id_content = '131536' and rp.type = 2024 and p.revised = 1 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0129  SELECT iframe, title FROM futbol.match_videos WHERE matchId = 131536 AND year = 2024 AND channel = 'Footters' LIMIT 1
0.0129  SELECT iframe, title FROM futbol.match_videos WHERE matchId = 131536 AND year = 2024 AND channel = 'Footters' LIMIT 1
0.0134  SELECT dt.nameShow,dt.basealias,t.id,t.teamId FROM teams t INNER JOIN datateams dt ON t.teamId = dt.id WHERE t.league_id = 72592 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0128  SELECT `id`, `text` FROM `matchs_news_keys` WHERE `match_id`='131536' AND `active` = 1 AND year = 2024
0.0326  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='72592' AND relp.team_id=6590502 WHERE relp.in_squad=1 and mp.`match_id` = '131536' AND mp.year='2024' ORDER BY mp.`team` ASC, p.`role` ASC
0.0251  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='72592' AND relp.team_id=6590497 WHERE relp.in_squad=1 and mp.`match_id` = '131536' AND mp.year='2024' ORDER BY mp.`team` ASC, p.`role` ASC
0.0127  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=131536 AND extraId = 72592 AND type_rel = 4
0.0129  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=178 AND type_rel = 3
0.0137  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 3 AND rel.typeId = 178 AND rel.ln = 'es' AND rel.status=1 ORDER BY rel.creation_date desc,rel.cover_points DESC LIMIT 5
0.0136  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 (1312550,1292079,1266183,1227043,1201762) ORDER BY n.cover_points DESC, update_date DESC
0.0128  SELECT * FROM futbol.calendars_lineups WHERE id = 131536 AND league_id = 72592 AND year = 2024