4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Betis Deportivo - Águilas FC
Jornada 32
FINALIZADO
30
30
386 Pts. Elo
4º

314 Pts. Elo
7º

0-0
Domingo, 21 Abril 2024, 11:30
Betis Deportivo

Betis Deportivo

4-5-1
Alineación Inicial
Suplentes
Águilas FC

Águilas FC

4-4-2
Alineación Inicial
Suplentes
Betis Deportivo
Águilas FC
T. Amarilla
T. Amarilla
Lesionado
Entra en el partido
Sale del partido
T. Amarilla
T. Amarilla
Entra en el partido
Sale del partido
T. Amarilla
Entra en el partido
Sale del partido
Entra en el partido
Sale del partido
Entra en el partido
Sale del partido
Entra en el partido
Sale del partido
Entra en el partido
Sale del partido
Entra en el partido
Sale del partido
T. Amarilla

Eventos del partido

Tarjetas

Nobel MendyT. Amarilla
Nobel Mendy
minuto 16'
minuto 21'EbukaT. Amarilla Ebuka
minuto 44'Isi RosT. Amarilla Isi Ros
minuto 61'M. BaezaT. Amarilla M. Baeza
Ginés SorrocheT. Amarilla
Ginés Sorroche
minuto 72'
Assane DiaoT. Amarilla
Assane Diao
minuto 91'

Cambios

minuto 31'GóngoraEntra en el partido Góngora
minuto 31'A. PladevallSale del partido A. Pladevall
Manu MorilloEntra en el partido
Manu Morillo
minuto 62'
J. RodríguezSale del partido
J. Rodríguez
minuto 62'
Berto RosasEntra en el partido
Berto Rosas
minuto 74'
Ginés SorrocheSale del partido
Ginés Sorroche
minuto 74'
Andrés CaroEntra en el partido
Andrés Caro
minuto 74'
Nobel MendySale del partido
Nobel Mendy
minuto 74'
minuto 75'Francis FerrónEntra en el partido Francis Ferrón
minuto 75'M. BaezaSale del partido M. Baeza
minuto 83'Karim AboubakarEntra en el partido Karim Aboubakar
minuto 83'Isi RosSale del partido Isi Ros
Marcos FernándezEntra en el partido
Marcos Fernández
minuto 86'
Yassin FekirSale del partido
Yassin Fekir
minuto 86'
X. PleguezueloEntra en el partido
X. Pleguezuelo
minuto 86'
L. AlcázarSale del partido
L. Alcázar
minuto 86'

Otros

minuto 30'A. PladevallLesionado A. Pladevall
0 Comentarios

No hay comentarios


Partido televisado en...
Canal Medio Idioma País
Betis TV TV Castellano
Real Betis Balompié YouTube TV Castellano

  USO DE MEMORIA  
7,032,760 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0009
Controller Execution Time ( Match / Index )  0.5688
Total Execution Time  0.5697
  CADENA URL  
/partido/Betis-B/Aguilas-Cf
  GET DATOS  
$_GET['/partido/Betis-B/Aguilas-Cf']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (18)  
0.0166   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 = 'Betis-B' AND dt2.basealias = 'Aguilas-Cf'
0.0113  SELECT c.*, 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, dt1.id 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 datastadiums AS s ON s.id = c.stadium WHERE c.extra != 1 AND dt1.basealias = 'Betis-B' AND dt2.basealias = 'Aguilas-Cf'
0.0106   SELECT ev.id AS event_id, ev.player_id, ev.action, ev.minute, ev.teamId AS event_teamId FROM events2024 AS ev WHERE ev.match_id=197773 ORDER BY (ev.action=1 OR ev.action=2 OR ev.action=6 OR ev.action=11 OR ev.action=12 OR ev.action=13) DESC,(ev.action=3 OR ev.action=4 OR ev.action=5) DESC,(ev.action=14 OR ev.action=15 OR ev.action=16 OR ev.action=17 OR ev.action=21) DESC,(ev.action=18 OR ev.action=19) DESC,(ev.action=20 OR ev.action=22) DESC, minute ASC, ev.real_date ASC, ev.id DESC, ev.action DESC
0.0109   SELECT dp.id AS player_id, dp.nick, dp.alias, dp.name, dp.last_name, rp.team_id, rp.teamId, rp.squadNumber AS num FROM dataplayers AS dp INNER JOIN rel_players AS rp ON dp.id=rp.player_id AND league_id=72365 WHERE dp.id IN (3213045,977116,207169,948610,950091,1007369,35419,950853,917850,3197021,814543,1027140,110094,248710,1017791,345743,870966,963957) AND (rp.team_id=6587674 OR rp.team_id=6587673)
0.0105   SELECT ev.id AS event_id, ev.player_id, ev.action, ev.minute, ev.teamId AS event_teamId FROM events2024 AS ev WHERE ev.match_id=197773 ORDER BY ev.minute ASC, ev.real_date ASC, ev.id DESC
0.0110   SELECT dp.id AS player_id, dp.nick, dp.alias, dp.name, dp.last_name, rp.team_id, rp.teamId, rp.squadNumber AS num FROM dataplayers AS dp INNER JOIN rel_players AS rp ON dp.id=rp.player_id AND league_id=72365 WHERE dp.id IN (3213045,977116,950853,35419,207169,948610,917850,3197021,950091,814543,1027140,110094,248710,1017791,345743,870966,963957,1007369) AND (rp.team_id=6587674 OR rp.team_id=6587673)
0.0105  SELECT data1 FROM stats2024 t WHERE league_id = 72365 AND teamId = 6587674 and type = 33
0.0105  SELECT data1 FROM stats2024 t WHERE league_id = 72365 AND teamId = 6587673 and type = 33
0.0108  SELECT p.* FROM `videos` as p INNER JOIN `rel_videos` as rp ON p.id = rp.id_video WHERE rp.id_content = '197773' and rp.type = 2024 and p.revised = 1 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0107  SELECT iframe, title FROM futbol.match_videos WHERE matchId = 197773 AND year = 2024 AND channel = 'Footters' LIMIT 1
0.0108  SELECT iframe, title FROM futbol.match_videos WHERE matchId = 197773 AND year = 2024 AND channel = 'Footters' LIMIT 1
0.0123  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` = 72365 AND c.`round` = 32 ORDER BY shedule ASC LIMIT 12
0.0106  SELECT `id`, `text` FROM `matchs_news_keys` WHERE `match_id`='197773' AND `active` = 1 AND year = 2024
0.0138  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='72365' AND relp.team_id=6587674 WHERE relp.in_squad=1 and mp.`match_id` = '197773' AND mp.year='2024' ORDER BY mp.`team` ASC, p.`role` ASC
0.0171  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='72365' AND relp.team_id=6587673 WHERE relp.in_squad=1 and mp.`match_id` = '197773' 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=197773 AND extraId = 72365 AND type_rel = 4
0.0106  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=2469 AND type_rel = 3
0.0105  SELECT * FROM futbol.calendars_lineups WHERE id = 197773 AND league_id = 72365 AND year = 2024