4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Betanzos CF - Arosa
Jornada 25
FINALIZADO
40
40
80 Pts. Elo
16º

175 Pts. Elo
3º

1-2
Jueves, 28 Marzo 2024, 17:00
0 - 1
 45' Rubo
0 - 2
 55' Martín Diz
Juan De Dora 84'
1 - 2

Betanzos CF

4-4-2
Alineación Inicial
Suplentes

Arosa

4-4-2
Alineación Inicial
Suplentes
Betanzos CF
Arosa
Sale del partido
Entra en el partido
Gol
Entra en el partido
Entra en el partido
Sale del partido
Sale del partido
Sale del partido
Entra en el partido
Gol
Entra en el partido
Sale del partido
T. Amarilla
Sale del partido
Entra en el partido
Entra en el partido
Sale del partido
T. Amarilla
Entra en el partido
Sale del partido
T. Amarilla
Gol de penalti
Sale del partido
Entra en el partido
T. Amarilla
T. Amarilla
T. Amarilla
T. Amarilla
T. Amarilla

Eventos del partido

Goles

minuto 45'Gol de Rubo
minuto 55'Gol de Martín Diz
Gol de penalti
Juan De Dora
minuto 84'

Tarjetas

T. Amarilla
Rey Díaz
minuto 60'
minuto 80'T. Amarilla Dani Sánchez
minuto 83'T. Amarilla Raúl
minuto 88'T. Amarilla Cotilla
T. Amarilla
Pablo Vigo
minuto 90'
T. Amarilla
Borja Varela
minuto 90'
T. Amarilla
Xusto
minuto 90'
minuto 90'T. Amarilla Santi

Cambios

minuto 45'Sale del partido Marcos Mella
minuto 45'Entra en el partido Iñaki
Entra en el partido
Sito Seoane
minuto 53'
Entra en el partido
D. Pájaro
minuto 53'
Sale del partido
Anthony Gardette
minuto 53'
Sale del partido
Ángel Fernández
minuto 53'
Sale del partido
Berto Fandiño
minuto 53'
Entra en el partido
Alex Del Río
minuto 53'
Entra en el partido
Pablo Vigo
minuto 60'
Sale del partido
Rey Díaz
minuto 60'
Sale del partido
Víctor Guerra
minuto 60'
Entra en el partido
Manu Barbeito
minuto 60'
minuto 73'Entra en el partido I. Leonardo
minuto 73'Sale del partido Rubo
minuto 81'Entra en el partido J. Pereira
minuto 81'Sale del partido Martín Diz
minuto 86'Sale del partido Sylla
minuto 86'Entra en el partido Santi
0 Comentarios

No hay comentarios



  USO DE MEMORIA  
6,993,128 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0011
Controller Execution Time ( Match / Index )  0.2983
Total Execution Time  0.2994
  CADENA URL  
/partido/Betanzos/Arosa
  GET DATOS  
$_GET['/partido/Betanzos/Arosa']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (14)  
0.0017  SELECT data1 FROM stats2024 t WHERE league_id = 72260 AND teamId = 6586122 and type = 33
0.0018  SELECT data1 FROM stats2024 t WHERE league_id = 72260 AND teamId = 6586117 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 = '449290' 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 = 449290 AND year = 2024 AND channel = 'Footters' LIMIT 1
0.0018  SELECT iframe, title FROM futbol.match_videos WHERE matchId = 449290 AND year = 2024 AND channel = 'Footters' LIMIT 1
0.0022  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` = 72260 AND c.`round` = 25 ORDER BY shedule ASC LIMIT 12
0.0023  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 = 72260 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.0024  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 = 72260 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`='449290' AND `active` = 1 AND year = 2024
0.0051  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='72260' AND relp.team_id=6586122 WHERE relp.in_squad=1 and mp.`match_id` = '449290' 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='72260' AND relp.team_id=6586117 WHERE relp.in_squad=1 and mp.`match_id` = '449290' AND mp.year='2024' ORDER BY mp.`team` ASC, p.`role` ASC
0.0019  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=449290 AND extraId = 72260 AND type_rel = 4
0.0017  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 = 449290 AND league_id = 72260 AND year = 2024