A PHP Error was encountered

Severity: Warning

Message: Invalid argument supplied for foreach()

Filename: controllers/match.php

Line Number: 505

A PHP Error was encountered

Severity: Warning

Message: Invalid argument supplied for foreach()

Filename: controllers/match.php

Line Number: 505

Partido Athletic - Real Madrid | Primera División
Athletic - Real Madrid
Jornada 1
FINALIZADO
30
10
2311 Pts. Elo
46%
19º

3682 Pts. Elo
54%
4º

0-2
Sábado, 12 Agosto 2023, 21:30
  • Estadio: San Mamés
0 - 1
 28' Rodrygo
0 - 2
 36' J. Bellingham

Athletic

4-5-1
Alineación Inicial
Suplentes

Real Madrid

4-4-2
Alineación Inicial
Suplentes
Athletic
Real Madrid
T. Amarilla
Gol
Asistencia
Tiro al palo
Gol
Asistencia
Sale del partido
Entra en el partido
Sale del partido
Entra en el partido
Sale del partido
Entra en el partido
Lesionado
Sale del partido
Entra en el partido
Sale del partido
Entra en el partido
T. Amarilla
Sale del partido
Entra en el partido
Entra en el partido
Sale del partido
T. Amarilla
Sale del partido
Sale del partido
Entra en el partido
Entra en el partido
T. Amarilla

Eventos del partido

Goles

minuto 28'Gol de Rodrygo
minuto 36'Gol de J. Bellingham

Tarjetas

T. Amarilla
Iker Muniain
minuto 4'
T. Amarilla
Dani Vivian
minuto 67'
minuto 76'T. Amarilla David Alaba
T. Amarilla
I. Williams
minuto 87'

Ocasiones

minuto 34'Tiro al palo David Alaba

Cambios

Sale del partido
Unai Gómez
minuto 46'
Entra en el partido
Oihan Sancet
minuto 46'
Sale del partido
Nico Williams
minuto 46'
Entra en el partido
Álex Berenguer
minuto 46'
Sale del partido
Iker Muniain
minuto 46'
Entra en el partido
G. Guruzeta
minuto 46'
minuto 50'Sale del partido Éder Militão
minuto 50'Entra en el partido A. Rüdiger
Sale del partido
Mikel Vesga
minuto 64'
Entra en el partido
Ander Herrera
minuto 64'
Sale del partido
Iñigo Lekue
minuto 71'
minuto 71'Entra en el partido Toni Kroos
Entra en el partido
Imanol García
minuto 71'
minuto 71'Sale del partido E. Camavinga
minuto 80'Sale del partido Vinícius Júnior
minuto 80'Sale del partido Rodrygo
minuto 80'Entra en el partido Luka Modrić
minuto 80'Entra en el partido Joselu

Otros

minuto 28'Asistencia Dani Carvajal
minuto 36'Asistencia David Alaba
minuto 49'Lesionado Éder Militão

Estadísticas del partido

Athletic Athletic Real Madrid Real Madrid
46%
Posesión del balón
 54%
0
Goles
 2
1
Tiros a puerta
 8
3
Tiros fuera
 3
7
Total tiros
 14
6
Paradas del portero
 1
7
Saques de esquina
 5
2
Fueras de juego
 2
0
Tarjetas Rojas
 0
0
Asistencias
 2
0
Tiros al palo
 1
0
Lesiones
 1
3
Sustituciones
 3
18
Faltas
 6
3 Comentarios + 1 respuestas
  • gran.book
    Hace 8 meses gran.book dice: Voto al Sr.pepich
  • desatinos_77
    Hace 8 meses desatinos_77 dice: Hola soy desatinos tengo unas cuantas ideas vanguardistas para cambiar el futbol de una vez por todas que quisiera compartir con vosotros, una de las cuales seria: cambiar la duración del partido pasaría de los dos tiempos de 45 minutos a tres tiempos de 30 minutos cada uno con dos descansos de 10 minutos, los jugadores estarían mas frescos y esto haría que el futbol fuese mas fluido y dinámico.
  • desatinos_77
    Hace 8 meses desatinos_77 dice: Hola, soy desatinos t tengo unas cuantas ideas vanguardistas para cambiar el futbol de una vez por todas, que quisiera compartir con vosotros, una de las cuales seria: cada vez que el balón cruce el centro del campo el equipo que tiene la posesion de balon no podra volver con el a campo propio si fuese así el colegiado pitaría campo atrás, con ello evitaríamos las perdidas de tiempo y promoviendo el juego de ataque.

Partido televisado en...
Canal Medio Idioma País
LaLiga TV Bar TV Castellano
M+ LaLiga TV TV Castellano
Movistar Plus+ TV Castellano
M+ Champions Tour TV Castellano
SKY Sports TV -
DSports TV -
SKY Sports TV Latino
SKY Sports TV -
SKY Sports TV -
SKY Sports TV Latino
SKY Sports TV -
SKY Sports TV -
DGO TV Latino
DSports TV Latino
DGO TV Latino
DSports TV Latino
DGO TV Latino
DGO TV -
DGO TV -
DGO TV -
SKY Sports TV -

  USO DE MEMORIA  
7,849,024 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0009
Controller Execution Time ( Match / Index )  1.1274
Total Execution Time  1.1284
  CADENA URL  
/partido/Athletic-Bilbao/Real-Madrid
  GET DATOS  
$_GET['/partido/Athletic-Bilbao/Real-Madrid']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (17)  
0.0009   SELECT c.comment_id, COUNT(DISTINCT c.`id`) AS num FROM comments AS c WHERE c.`active` = 1 AND c.device = 'web' AND c.to_review=0 AND c.comment_id!=0 AND c.lang = '1' AND c.`league_id` = '72116' AND c.`match_id` = '29269' AND c.comment_id IN (52876003,52604682,52572784) GROUP BY c.comment_id
0.0107  SELECT data1 FROM stats2024 t WHERE league_id = 72116 AND teamId = 6583636 and type = 33
0.0107  SELECT data1 FROM stats2024 t WHERE league_id = 72116 AND teamId = 6583647 and type = 33
0.0115  SELECT p.* FROM `videos` as p INNER JOIN `rel_videos` as rp ON p.id = rp.id_video WHERE rp.id_content = '29269' and rp.type = 2024 and p.revised = 1 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0110  SELECT iframe, title FROM futbol.match_videos WHERE matchId = 29269 AND year = 2024 AND channel = 'Footters' LIMIT 1
0.0105  SELECT iframe, title FROM futbol.match_videos WHERE matchId = 29269 AND year = 2024 AND channel = 'Footters' LIMIT 1
0.0126  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` = 72116 AND c.`round` = 1 ORDER BY shedule ASC LIMIT 12
0.0124  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 = 72116 AND t.round = 1 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0115   SELECT c.id, c.author_name, c.comment, c.comment_id, c.author_id, c.creation_date, c.votes_up, c.device, fau.user_name, fau.adm AS user_adm, fau.role AS user_role, fau.adm_type AS user_adm_type, template, NOW() AS difference_time FROM comments AS c LEFT JOIN fa_user_mini AS fau ON fau.id = c.author_id WHERE c.`active`=1 AND c.to_review=0 AND c.device = 'web' AND c.comment_id = '52876003' AND c.lang = '1' ORDER BY creation_date DESC LIMIT 20
0.0116   SELECT c.id, c.author_name, c.comment, c.comment_id, c.author_id, c.creation_date, c.votes_up, c.device, fau.user_name, fau.adm AS user_adm, fau.role AS user_role, fau.adm_type AS user_adm_type, template, NOW() AS difference_time FROM comments AS c LEFT JOIN fa_user_mini AS fau ON fau.id = c.author_id WHERE c.`active`=1 AND c.to_review=0 AND c.device = 'web' AND c.comment_id = '52604682' AND c.lang = '1' ORDER BY creation_date DESC LIMIT 20
0.0111   SELECT c.id, c.author_name, c.comment, c.comment_id, c.author_id, c.creation_date, c.votes_up, c.device, fau.user_name, fau.adm AS user_adm, fau.role AS user_role, fau.adm_type AS user_adm_type, template, NOW() AS difference_time FROM comments AS c LEFT JOIN fa_user_mini AS fau ON fau.id = c.author_id WHERE c.`active`=1 AND c.to_review=0 AND c.device = 'web' AND c.comment_id = '52572784' AND c.lang = '1' ORDER BY creation_date DESC LIMIT 20
0.0107  SELECT `id`, `text` FROM `matchs_news_keys` WHERE `match_id`='29269' AND `active` = 1 AND year = 2024
0.0204  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='72116' AND relp.team_id=6583636 WHERE relp.in_squad=1 and mp.`match_id` = '29269' AND mp.year='2024' ORDER BY mp.`team` ASC, p.`role` ASC
0.0216  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='72116' AND relp.team_id=6583647 WHERE relp.in_squad=1 and mp.`match_id` = '29269' AND mp.year='2024' ORDER BY mp.`team` ASC, p.`role` ASC
0.0105  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=29269 AND extraId = 72116 AND type_rel = 4
0.0119  SELECT /*115 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' INNER JOIN bs_news_rel rel ON rel.newId = n.id AND rel.type_rel = 4 AND rel.typeId = 29269 AND rel.extraId = 72116 WHERE n.status = 1 AND n.ln='es' AND n.creation_date>'2023-06-13 21:30:00' AND n.creation_date<'2023-10-11 21:30:00' GROUP BY n.id ORDER BY n.cover_points DESC,n.creation_date DESC LIMIT 5
0.0105  SELECT * FROM futbol.calendars_lineups WHERE id = 29269 AND league_id = 72116 AND year = 2024