4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Werder Bremen - Hoffenheim
Jornada 7
FINALIZADO
50
40
1446 Pts. Elo
48%
14º

1958 Pts. Elo
51%
5º

2-3
Sábado, 07 Octubre 2023, 18:30
0 - 1
 8' M. Beier
Romano Schmid 17'
1 - 1
1 - 2
 29' Grischa Prömel
Jens Stage 91'
2 - 2
2 - 3
 92' Marius Bülter

Werder Bremen

Alineación Inicial
Suplentes

Hoffenheim

Alineación Inicial
Suplentes

Eventos del partido

Goles

minuto 8'Gol de M. Beier
Gol de
Romano Schmid
minuto 17'
minuto 29'Gol de Grischa Prömel
Gol de
Jens Stage
minuto 91'
minuto 92'Gol de Marius Bülter

Tarjetas

T. Amarilla
Naby Keïta
minuto 32'
T. Amarilla
M. Ducksch
minuto 46'
T. Amarilla
Mitchell Weiser
minuto 56'
T. Amarilla
N. Rapp
minuto 58'
minuto 69'T. Amarilla Grischa Prömel
minuto 72'T. Amarilla K. Akpoguma
minuto 90'T. Amarilla O. Baumann
T. Amarilla
Anthony Jung
minuto 93'
minuto 95'T. Amarilla Kevin Vogt

Ocasiones

Gol anulado
J. Njinmah
minuto 52'

Cambios

Entra en el partido
Santos Borré
minuto 59'
Sale del partido
Naby Keïta
minuto 59'
Sale del partido
J. Njinmah
minuto 59'
Entra en el partido
Jens Stage
minuto 59'
minuto 60'Sale del partido Robert Skov
minuto 60'Entra en el partido Marius Bülter
minuto 66'Sale del partido Ozan Kabak
minuto 66'Entra en el partido K. Akpoguma
Sale del partido
Senne Lynen
minuto 72'
Sale del partido
N. Rapp
minuto 72'
Entra en el partido
N. Woltemade
minuto 72'
Entra en el partido
C. Groß
minuto 72'
minuto 81'Sale del partido M. Beier
minuto 81'Entra en el partido Ihlas Bebou
minuto 81'Sale del partido F. Grillitsch
minuto 81'Entra en el partido Finn Becker
Sale del partido
M. Friedl
minuto 83'
Entra en el partido
L. Bittencourt
minuto 83'

Otros

minuto 8'Asistencia Grischa Prömel
Asistencia
M. Ducksch
minuto 17'
minuto 29'Asistencia Robert Skov
minuto 65'Lesionado Ozan Kabak
Asistencia
C. Groß
minuto 91'

Estadísticas del partido

Werder Bremen Werder Hoffenheim Hoffenheim
48%
Posesión del balón
 51%
2
Goles
 3
3
Tiros a puerta
 4
7
Tiros fuera
 6
13
Total tiros
 10
2
Paradas del portero
 1
4
Saques de esquina
 4
2
Fueras de juego
 4
0
Tarjetas Rojas
 0
2
Asistencias
 2
0
Lesiones
 1
3
Sustituciones
 3
15
Faltas
 7
0 Comentarios

No hay comentarios



  USO DE MEMORIA  
6,943,416 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0009
Controller Execution Time ( Match / Index )  0.3044
Total Execution Time  0.3054
  CADENA URL  
/partido/Werder-Bremen/Tsg-1899-Hoffenheim/2024
  GET DATOS  
$_GET['/partido/Werder-Bremen/Tsg-1899-Hoffenheim/2024']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (11)  
0.0041  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 = 72031
0.0018  SELECT data1 FROM stats2024 t WHERE league_id = 72031 AND teamId = 6582161 and type = 33
0.0018  SELECT data1 FROM stats2024 t WHERE league_id = 72031 AND teamId = 6582165 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 = '75195' and rp.type = 2024 and p.revised = 1 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0019  SELECT iframe, title FROM futbol.match_videos WHERE matchId = 75195 AND year = 2024 AND channel = 'Footters' LIMIT 1
0.0018  SELECT iframe, title FROM futbol.match_videos WHERE matchId = 75195 AND year = 2024 AND channel = 'Footters' LIMIT 1
0.0026  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables2024` as t INNER JOIN teams as team ON team.id = t.team INNER JOIN datateams as dt ON team.teamId = dt.id WHERE t.league_id = 72031 AND t.round = 31 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0018  SELECT `id`, `text` FROM `matchs_news_keys` WHERE `match_id`='75195' AND `active` = 1 AND year = 2024
0.0117  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='72031' AND relp.team_id=6582161 WHERE relp.in_squad=1 and mp.`match_id` = '75195' AND mp.year='2024' ORDER BY mp.`team` ASC, p.`role` ASC
0.0115  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='72031' AND relp.team_id=6582165 WHERE relp.in_squad=1 and mp.`match_id` = '75195' AND mp.year='2024' ORDER BY mp.`team` ASC, p.`role` ASC
0.0018  SELECT * FROM futbol.calendars_lineups WHERE id = 75195 AND league_id = 72031 AND year = 2024