4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
CD Tedeón - Haro Deportivo
Jornada 25
FINALIZADO
20
31
61 Pts. Elo
15º

54 Pts. Elo
16º

1-0
Domingo, 17 Marzo 2024, 17:00
Z. Suzuki 86'
1 - 0

CD Tedeón

4-4-2
Alineación Inicial
Suplentes

Haro Deportivo

4-4-2
Alineación Inicial
Suplentes
CD Tedeón
Haro Deportivo
T. Amarilla
Sale del partido
Entra en el partido
T. Amarilla
Entra en el partido
Sale del partido
T. Amarilla
Sale del partido
Entra en el partido
Entra en el partido
Entra en el partido
Sale del partido
Sale del partido
Gol
Sale del partido
Entra en el partido
T. Amarilla
2a Amarilla y Roja
Entra en el partido
Sale del partido

Eventos del partido

Goles

Gol de
Z. Suzuki
minuto 86'

Tarjetas

T. Amarilla
C. Balda
minuto 25'
minuto 67'T. Amarilla J. Vargas
T. Amarilla
Miguel Alvarez
minuto 75'
minuto 87'T. Amarilla Del Campo
minuto 89'2a Amarilla y Roja Del Campo

Cambios

minuto 65'Sale del partido E. Moisés
minuto 65'Entra en el partido Álvaro Holzheier
minuto 73'Entra en el partido J. Pacheco
minuto 73'Sale del partido Gonzalo
minuto 83'Sale del partido Zunzu
Entra en el partido
Z. Suzuki
minuto 83'
Entra en el partido
J. Martinez
minuto 83'
minuto 83'Entra en el partido Xabier Hidalgo
Sale del partido
J. Esneider
minuto 83'
Sale del partido
Bezares
minuto 83'
Sale del partido
A. Jimenez
minuto 87'
Entra en el partido
Sergio González
minuto 87'
Entra en el partido
Raúl Dávila
minuto 89'
Sale del partido
C. Balda
minuto 89'
0 Comentarios

No hay comentarios



  USO DE MEMORIA  
6,911,184 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0014
Controller Execution Time ( Match / Index )  0.3029
Total Execution Time  0.3043
  CADENA URL  
/partido/Tedeon/Haro-Deportivo/2024
  GET DATOS  
$_GET['/partido/Tedeon/Haro-Deportivo/2024']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (15)  
0.0038  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 = 72276
0.0017  SELECT data1 FROM stats2024 t WHERE league_id = 72276 AND teamId = 6586421 and type = 33
0.0018  SELECT data1 FROM stats2024 t WHERE league_id = 72276 AND teamId = 6586415 and type = 33
0.0032  SELECT p.* FROM `videos` as p INNER JOIN `rel_videos` as rp ON p.id = rp.id_video WHERE rp.id_content = '489717' 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 = 489717 AND year = 2024 AND channel = 'Footters' LIMIT 1
0.0017  SELECT iframe, title FROM futbol.match_videos WHERE matchId = 489717 AND year = 2024 AND channel = 'Footters' LIMIT 1
0.0024  SELECT c.team1, c.team2,c.extra,c.datateam1,c.datateam2, c.shedule,c.id, c.r1, c.r2, c.round, dt1.nameShow as team1_name, dt2.nameShow as team2_name, dt1.basealias as basealias1, dt2.basealias as basealias2,c.comments,c.league_id FROM `calendars2024` as c INNER JOIN teams t1 ON t1.id = c.team1 AND t1.league_id = c.league_id INNER JOIN teams t2 ON t2.id = c.team2 AND t2.league_id = c.league_id INNER JOIN datateams as dt1 ON dt1.id = t1.teamId INNER JOIN datateams as dt2 ON dt2.id = t2.teamId WHERE c.`league_id` = 72276 AND c.`round` = 25 ORDER BY shedule ASC LIMIT 12
0.0025  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 = 72276 AND t.round = 25 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0035  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 = 72276 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`='489717' AND `active` = 1 AND year = 2024
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='72276' AND relp.team_id=6586421 WHERE relp.in_squad=1 and mp.`match_id` = '489717' AND mp.year='2024' ORDER BY mp.`team` ASC, p.`role` ASC
0.0032  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='72276' AND relp.team_id=6586415 WHERE relp.in_squad=1 and mp.`match_id` = '489717' 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=489717 AND extraId = 72276 AND type_rel = 4
0.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=2470 AND type_rel = 3
0.0018  SELECT * FROM futbol.calendars_lineups WHERE id = 489717 AND league_id = 72276 AND year = 2024