4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Deusto - San Ignacio
Jornada 1
FINALIZADO
21
00
113 Pts. Elo
9º

52 Pts. Elo
11º

1-1
Sábado, 09 Septiembre 2023, 17:30
0 - 1
 44' Pirri
Iñigo Montero 69'
1 - 1

Deusto

4-4-2
Alineación Inicial
Suplentes

San Ignacio

4-4-2
Alineación Inicial
Suplentes

Eventos del partido

Goles

minuto 44'Gol de Pirri
Gol de
Iñigo Montero
minuto 69'

Tarjetas

T. Amarilla
B. Gaubeka
minuto 51'
T. Amarilla
Lele
minuto 59'
Tarjeta Roja a
Andiko
minuto 70'

Cambios

minuto 56'Sale del partido Euken Herrojo
minuto 56'Entra en el partido Joseba Eiguren
Sale del partido
D. Klinger
minuto 60'
Entra en el partido
O. Edozia
minuto 60'
Sale del partido
Lele
minuto 60'
Entra en el partido
Baroja
minuto 60'
Sale del partido
Andiko
minuto 60'
Entra en el partido
Mikel
minuto 60'
minuto 62'Entra en el partido M. Izaguirre
minuto 62'Sale del partido O. Diaz De Mendibil
minuto 62'Sale del partido Beñat Díaz
minuto 62'Entra en el partido Y. Cespedes
Sale del partido
Emilio
minuto 67'
Entra en el partido
I. Alcubilla
minuto 67'
minuto 70'Entra en el partido Iván Sanz
minuto 70'Entra en el partido Aitor
minuto 70'Sale del partido Pirri
minuto 70'Sale del partido M. Asurmendi
Sale del partido
Tejada
minuto 81'
Entra en el partido
Julen
minuto 81'
0 Comentarios

No hay comentarios



  USO DE MEMORIA  
6,781,832 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0010
Controller Execution Time ( Match / Index )  0.3545
Total Execution Time  0.3555
  CADENA URL  
/partido/Deusto/San-Ignacio/2024
  GET DATOS  
$_GET['/partido/Deusto/San-Ignacio/2024']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (11)  
0.0017  SELECT data1 FROM stats2024 t WHERE league_id = 72263 AND teamId = 6586175 and type = 33
0.0017  SELECT data1 FROM stats2024 t WHERE league_id = 72263 AND teamId = 6586181 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 = '437932' 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 = 437932 AND year = 2024 AND channel = 'Footters' LIMIT 1
0.0018  SELECT iframe, title FROM futbol.match_videos WHERE matchId = 437932 AND year = 2024 AND channel = 'Footters' LIMIT 1
0.0018  SELECT `id`, `text` FROM `matchs_news_keys` WHERE `match_id`='437932' AND `active` = 1 AND year = 2024
0.0029  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='72263' AND relp.team_id=6586175 WHERE relp.in_squad=1 and mp.`match_id` = '437932' AND mp.year='2024' ORDER BY mp.`team` ASC, p.`role` ASC
0.0031  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='72263' AND relp.team_id=6586181 WHERE relp.in_squad=1 and mp.`match_id` = '437932' 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=437932 AND extraId = 72263 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 = 437932 AND league_id = 72263 AND year = 2024