4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Arenas de Getxo - AD San Juan
Jornada 34
FINALIZADO
00
10
235 Pts. Elo
12º

243 Pts. Elo
14º

1-1
Domingo, 05 Mayo 2024, 12:00
  • Estadio: Municipal de Gobela
R. Villanueva 9'
1 - 0
1 - 1
 67' E. Ezcurra

Eventos del partido

Goles

R. VillanuevaGol de
R. Villanueva
minuto 9'
minuto 67'E. EzcurraGol de E. Ezcurra

Tarjetas

minuto 85'MorillasT. Amarilla Morillas

Cambios

minuto 46'Iñaki AlbercaSale del partido Iñaki Alberca
minuto 46'Alex GómezEntra en el partido Alex Gómez
R. VillanuevaSale del partido
R. Villanueva
minuto 56'
J. TrincadoSale del partido
J. Trincado
minuto 56'
Diego LamadridSale del partido
Diego Lamadrid
minuto 56'
BaquéEntra en el partido
Baqué
minuto 56'
HueteEntra en el partido
Huete
minuto 56'
Álvaro GarcíaEntra en el partido
Álvaro García
minuto 56'
minuto 61'GaleanoEntra en el partido Galeano
minuto 61'Ander MelerSale del partido Ander Meler
minuto 70'LalindeSale del partido Lalinde
minuto 70'E. EzcurraSale del partido E. Ezcurra
minuto 70'IriguibelEntra en el partido Iriguibel
minuto 70'Aimar MartiarenaEntra en el partido Aimar Martiarena
G. AlfaroSale del partido
G. Alfaro
minuto 72'
GabrielEntra en el partido
Gabriel
minuto 72'
minuto 74'I. BaldaEntra en el partido I. Balda
minuto 74'BichoSale del partido Bicho
I. EstrechaEntra en el partido
I. Estrecha
minuto 81'
Alex ValiñoSale del partido
Alex Valiño
minuto 81'

Otros

Alex ValiñoAsistencia
Alex Valiño
minuto 9'

Alineaciones

Arenas de Getxo

Arenas de Getxo

5-3-2
Alineación Inicial
Suplentes
AD San Juan

AD San Juan

4-4-2
Alineación Inicial
Suplentes



  USO DE MEMORIA  
6,807,992 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0010
Controller Execution Time ( Match / Index )  0.4211
Total Execution Time  0.4221
  CADENA URL  
/partido/Arenas-Club/San-Juan/2024
  GET DATOS  
$_GET['/partido/Arenas-Club/San-Juan/2024']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (12)  
0.0112   SELECT c.*, c.stadium as real_stadium, 2024 AS year, dt1.id AS dteam1_id, dt1.nameShow as team1_name, dt1.basealias AS team1_basealias, dt1.fullName as team1_fullName, dt1.color1 AS team1_color1, dt1.seats, dt1.size, dt1.yearBuilt, dt2.id AS dteam2_id, dt2.nameShow as team2_name, dt2.basealias AS team2_basealias, dt2.fullName as team2_fullName, dt2.color1 AS team2_color1, t1.name as team1_Oname, t2.name as team2_Oname, s.id as stadium_id, rs.teamId as stadium_team_id, s.name AS stadium_name, s.size AS stadium_size, s.seats AS stadium_seats, s.yearBuilt AS stadium_yearBuilt, dt1.managerNow AS manager1, dt2.managerNow AS manager2 FROM calendars2024 AS c INNER JOIN teams AS t1 ON c.team1 = t1.id INNER JOIN datateams AS dt1 ON t1.teamId = dt1.id INNER JOIN teams AS t2 ON c.team2 = t2.id INNER JOIN datateams AS dt2 ON t2.teamId = dt2.id LEFT JOIN futbol.rel_stadiums as rs ON rs.teamId=dt1.id AND rs.active=1 LEFT JOIN datastadiums AS s ON s.id = c.stadium WHERE c.extra != 1 AND dt1.basealias = 'Arenas-Club' AND dt2.basealias = 'San-Juan'
0.0018  SELECT data1 FROM stats2024 t WHERE league_id = 72363 AND teamId = 6587616 and type = 33
0.0018  SELECT data1 FROM stats2024 t WHERE league_id = 72363 AND teamId = 6587612 and type = 33
0.0024  SELECT p.* FROM `videos` as p INNER JOIN `rel_videos` as rp ON p.id = rp.id_video WHERE rp.id_content = '197106' 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 = 197106 AND year = 2024 AND channel = 'Footters' LIMIT 1
0.0019  SELECT iframe, title FROM futbol.match_videos WHERE matchId = 197106 AND year = 2024 AND channel = 'Footters' LIMIT 1
0.0019  SELECT `id`, `text` FROM `matchs_news_keys` WHERE `match_id`='197106' AND `active` = 1 AND year = 2024
0.0075  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='72363' AND relp.team_id=6587616 WHERE relp.in_squad=1 and mp.`match_id` = '197106' AND mp.year='2024' ORDER BY mp.`team` ASC, p.`role` ASC
0.0059  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='72363' AND relp.team_id=6587612 WHERE relp.in_squad=1 and mp.`match_id` = '197106' AND mp.year='2024' ORDER BY mp.`team` ASC, p.`role` ASC
0.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=197106 AND extraId = 72363 AND type_rel = 4
0.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=2469 AND type_rel = 3
0.0018  SELECT * FROM futbol.calendars_lineups WHERE id = 197106 AND league_id = 72363 AND year = 2024