4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
AD Ceuta FC - Antequera CF
Jornada 35
FINALIZADO
30
32
793 Pts. Elo
5º

586 Pts. Elo
8º

2-0
Domingo, 05 Mayo 2024, 12:00
Cristian Rodríguez 9'
1 - 0
Aisar 76'
2 - 0

Eventos del partido

Goles

Cristian RodríguezGol de
Cristian Rodríguez
minuto 9'
AisarGol de
Aisar
minuto 76'

Tarjetas

minuto 11'David RodríguezT. Amarilla David Rodríguez
Cristian RodríguezT. Amarilla
Cristian Rodríguez
minuto 13'
Rodri RíosT. Amarilla
Rodri Ríos
minuto 16'
minuto 38'LautaroT. Amarilla Lautaro
minuto 48'David Rodríguez2a Amarilla y Roja David Rodríguez
C. UcheT. Amarilla
C. Uche
minuto 52'
minuto 68'Fermín RuizTarjeta Roja a Fermín Ruiz

Ocasiones

Rodri RíosPenalti fallado
Rodri Ríos
minuto 41'
Rodri RíosTiro al palo
Rodri Ríos
minuto 41'
minuto 90'Luismi RedondoGol anulado Luismi Redondo

Cambios

minuto 52'Txus AlbaEntra en el partido Txus Alba
minuto 52'JeremyEntra en el partido Jeremy
minuto 52'Nacho PaisSale del partido Nacho Pais
minuto 52'Ale GarcíaSale del partido Ale García
SofianeEntra en el partido
Sofiane
minuto 65'
Rodri RíosSale del partido
Rodri Ríos
minuto 65'
minuto 74'Pol PratsEntra en el partido Pol Prats
minuto 74'Luismi GutiérrezSale del partido Luismi Gutiérrez
Julio IglesiasEntra en el partido
Julio Iglesias
minuto 76'
Dani RomeraEntra en el partido
Dani Romera
minuto 76'
C. UcheSale del partido
C. Uche
minuto 76'
AisarSale del partido
Aisar
minuto 76'
minuto 81'Aitor HidalgoEntra en el partido Aitor Hidalgo
minuto 81'César SousaEntra en el partido César Sousa
minuto 81'DestinySale del partido Destiny
minuto 81'Chema NúñezSale del partido Chema Núñez
Ñito GonzálezEntra en el partido
Ñito González
minuto 83'
Pablo GarcíaEntra en el partido
Pablo García
minuto 83'
Cedric TeguiaSale del partido
Cedric Teguia
minuto 83'
Cristian RodríguezSale del partido
Cristian Rodríguez
minuto 83'

Otros

Cristian RodríguezAsistencia
Cristian Rodríguez
minuto 76'
minuto 38'LautaroPenalti cometido Lautaro

Alineaciones

AD Ceuta FC

AD Ceuta FC

4-5-1
Alineación Inicial
Suplentes
Antequera CF

Antequera CF

4-5-1
Alineación Inicial
Suplentes

Estadísticas del partido

A PHP Error was encountered

Severity: Warning

Message: Invalid argument supplied for foreach()

Filename: comment/main_view.php

Line Number: 2065

AD Ceuta FC AD Ceuta FC Antequera CF Antequera
0 Comentarios

No hay comentarios


Partido televisado en...
Canal Medio Idioma País
FEF TVFEF TV TV Castellano es

  USO DE MEMORIA  
7,176,968 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0009
Controller Execution Time ( Match / Index )  0.7596
Total Execution Time  0.7606
  CADENA URL  
/partido/Ad-Ceuta-Fc-Tercera/Antequera
  GET DATOS  
$_GET['/partido/Ad-Ceuta-Fc-Tercera/Antequera']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (29)  
0.0018   SELECT 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` = '72359' AND c.`match_id` = '193320'
0.0172   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 = 'Ad-Ceuta-Fc-Tercera' AND dt2.basealias = 'Antequera'
0.0136  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 = 'Ad-Ceuta-Fc-Tercera' AND dt2.basealias = 'Antequera'
0.0128   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=193320 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.0149   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=72359 WHERE dp.id IN (206949,988177,927739,52105,871598,3358813,337621,276463,879143,869734,365503,3148268,802936,424406,274579,845534,130054,992979,893304,992992,244764,144610,874057,426998) AND (rp.team_id=6587563 OR rp.team_id=6587568)
0.0132   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=193320 ORDER BY ev.minute ASC, ev.real_date ASC, ev.id DESC
0.0152   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=72359 WHERE dp.id IN (206949,927739,52105,871598,3358813,879143,869734,365503,3148268,802936,337621,424406,274579,988177,845534,130054,992979,893304,992992,244764,144610,874057,426998,276463) AND (rp.team_id=6587563 OR rp.team_id=6587568)
0.0127  SELECT data1 FROM stats2024 t WHERE league_id = 72359 AND teamId = 6587563 and type = 33
0.0127  SELECT data1 FROM stats2024 t WHERE league_id = 72359 AND teamId = 6587568 and type = 33
0.0125  SELECT id,team_id,tactica FROM dreamteam_data_real WHERE league_id = 72359 AND id_match = 193320
0.0145  SELECT rel.*,relp.squadNumber as num,dp.alias,dp.role,dp.name,dp.nick,dp.last_name,dp.id as player_id, 0 AS rating FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real drea ON drea.id = rel.team_number INNER JOIN dataplayers dp ON dp.id = rel.player_id INNER JOIN rel_players AS relp ON relp.player_id=dp.id AND relp.league_id='72359' AND relp.team_id = drea.team_id WHERE rel.team_number=5380940 GROUP BY dp.id ORDER BY role ASC, pos ASC
0.0143  SELECT rel.*,relp.squadNumber as num,dp.alias,dp.role,dp.name,dp.nick,dp.last_name,dp.id as player_id, 0 AS rating FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real drea ON drea.id = rel.team_number INNER JOIN dataplayers dp ON dp.id = rel.player_id INNER JOIN rel_players AS relp ON relp.player_id=dp.id AND relp.league_id='72359' AND relp.team_id = drea.team_id WHERE rel.team_number=5381005 GROUP BY dp.id ORDER BY role ASC, pos ASC
0.0214  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='72359' AND relp.team_id=6587563 WHERE mp.`match_id` = '193320' AND mp.year='2024' AND p.id NOT IN (186365,871598,819315,337621,927739,365503,244764,276463,3148268,274579,992992,427194,341567,196928,338593,643333,988177,3358813,416195,206949,426998,52105) ORDER BY mp.`team` ASC, p.`role` ASC
0.0159  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='72359' AND relp.team_id=6587568 WHERE mp.`match_id` = '193320' AND mp.year='2024' AND p.id NOT IN (186365,871598,819315,337621,927739,365503,244764,276463,3148268,274579,992992,427194,341567,196928,338593,643333,988177,3358813,416195,206949,426998,52105) ORDER BY mp.`team` ASC, p.`role` ASC
0.0127  SELECT p.* FROM `pictures` as p INNER JOIN `rel_pictures` as rp ON p.id = rp.id_picture WHERE rp.id_content = '193320' and rp.type = 2024 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0126  SELECT p.* FROM `videos` as p INNER JOIN `rel_videos` as rp ON p.id = rp.id_video WHERE rp.id_content = '193320' and rp.type = 2024 and p.revised = 1 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0125  SELECT iframe, title FROM futbol.match_videos WHERE matchId = 193320 AND year = 2024 AND channel = 'Footters' LIMIT 1
0.0125  SELECT iframe, title FROM futbol.match_videos WHERE matchId = 193320 AND year = 2024 AND channel = 'Footters' LIMIT 1
0.0126  SELECT points,gf,ga,win_h,win_a,draw_h,draw_a,lose_h,lose_a FROM `tables2024` WHERE league_id = 72359 AND round >= 36 AND round <= 36 AND team = 6587563 ORDER BY round ASC
0.0125  SELECT `id`, `text` FROM `matchs_news_keys` WHERE `match_id`='193320' AND `active` = 1 AND year = 2024
0.0192  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='72359' AND relp.team_id=6587563 WHERE relp.in_squad=1 and mp.`match_id` = '193320' AND mp.year='2024' ORDER BY mp.`team` ASC, p.`role` ASC
0.0170  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='72359' AND relp.team_id=6587568 WHERE relp.in_squad=1 and mp.`match_id` = '193320' AND mp.year='2024' ORDER BY mp.`team` ASC, p.`role` ASC
0.0127  SELECT id, team_id FROM dreamteam_data_real WHERE league_id = '72359' AND id_match = '193320'
0.0125   SELECT rel.*, dp.name, dp.nick, dp.last_name, dp.id as player_id, 0 AS rating FROM rel_dreamteam_real rel INNER JOIN dataplayers dp ON dp.id = rel.player_id WHERE rel.team_number = '5380940' ORDER BY rating DESC LIMIT 1
0.0129   SELECT rel.*, dp.name, dp.nick, dp.last_name, dp.id as player_id, 0 AS rating FROM rel_dreamteam_real rel INNER JOIN dataplayers dp ON dp.id = rel.player_id WHERE rel.team_number = '5381005' ORDER BY rating DESC LIMIT 1
0.0126  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=193320 AND extraId = 72359 AND type_rel = 4
0.0126  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=2468 AND type_rel = 3
0.0125  SELECT avg_rating FROM elo_teams WHERE id=665
0.0125  SELECT * FROM futbol.calendars_lineups WHERE id = 193320 AND league_id = 72359 AND year = 2024