4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Málaga - AD Ceuta FC
Jornada 31
FINALIZADO
30
40
1068 Pts. Elo
4º

743 Pts. Elo
5º

1-1
Domingo, 07 Abril 2024, 12:00
0 - 1
 26' Cedric Teguia
Juande 40'
1 - 1

Eventos del partido

Goles

minuto 26'Cedric TeguiaGol de Cedric Teguia
JuandeGol de
Juande
minuto 40'

Tarjetas

minuto 21'Alain GarcíaT. Amarilla Alain García
minuto 33'Fran RodríguezT. Amarilla Fran Rodríguez
minuto 39'Ale MeléndezT. Amarilla Ale Meléndez
Kevin MedinaT. Amarilla
Kevin Medina
minuto 77'
minuto 77'Cedric TeguiaT. Amarilla Cedric Teguia
Nélson MonteT. Amarilla
Nélson Monte
minuto 88'
Manu MolinaT. Amarilla
Manu Molina
minuto 93'

Cambios

minuto 46'Jota LópezEntra en el partido Jota López
minuto 46'Fran RodríguezSale del partido Fran Rodríguez
minuto 60'Julio IglesiasEntra en el partido Julio Iglesias
minuto 60'Cristian RodríguezSale del partido Cristian Rodríguez
DioniEntra en el partido
Dioni
minuto 64'
Dani LorenzoEntra en el partido
Dani Lorenzo
minuto 64'
David FerreiroSale del partido
David Ferreiro
minuto 64'
Aarón OchoaSale del partido
Aarón Ochoa
minuto 64'
Víctor GarcíaEntra en el partido
Víctor García
minuto 74'
Diego MurilloSale del partido
Diego Murillo
minuto 74'
minuto 81'SofianeEntra en el partido Sofiane
minuto 81'Alain GarcíaEntra en el partido Alain García
minuto 81'CapaEntra en el partido Capa
minuto 81'Rodri RíosSale del partido Rodri Ríos
minuto 81'Cedric TeguiaSale del partido Cedric Teguia
minuto 81'AisarSale del partido Aisar
Moussa DiarraEntra en el partido
Moussa Diarra
minuto 89'
D. LarrubiaEntra en el partido
D. Larrubia
minuto 89'
Kevin MedinaSale del partido
Kevin Medina
minuto 89'
JuandeSale del partido
Juande
minuto 89'

Otros

minuto 26'Fran RodríguezAsistencia Fran Rodríguez

Alineaciones

Málaga

Málaga

4-5-1
Alineación Inicial
Suplentes
AD Ceuta FC

AD Ceuta FC

4-5-1
Alineación Inicial
Suplentes



  USO DE MEMORIA  
7,080,672 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0013
Controller Execution Time ( Match / Index )  0.3256
Total Execution Time  0.3269
  CADENA URL  
/partido/Malaga/Ad-Ceuta-Fc-Tercera/2024?section=legal
  GET DATOS  
$_GET['/partido/Malaga/Ad-Ceuta-Fc-Tercera/2024']  
$_GET['section']   legal
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (11)  
0.0018  SELECT data1 FROM stats2024 t WHERE league_id = 72359 AND teamId = 6587576 and type = 33
0.0018  SELECT data1 FROM stats2024 t WHERE league_id = 72359 AND teamId = 6587563 and type = 33
0.0022  SELECT p.* FROM `videos` as p INNER JOIN `rel_videos` as rp ON p.id = rp.id_video WHERE rp.id_content = '193547' 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 = 193547 AND year = 2024 AND channel = 'Footters' LIMIT 1
0.0018  SELECT iframe, title FROM futbol.match_videos WHERE matchId = 193547 AND year = 2024 AND channel = 'Footters' LIMIT 1
0.0019  SELECT `id`, `text` FROM `matchs_news_keys` WHERE `match_id`='193547' AND `active` = 1 AND year = 2024
0.0108  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=6587576 WHERE relp.in_squad=1 and mp.`match_id` = '193547' AND mp.year='2024' ORDER BY mp.`team` ASC, p.`role` ASC
0.0094  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` = '193547' 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=193547 AND extraId = 72359 AND type_rel = 4
0.0026  SELECT /*115 bs_news_model*/ n.id, n.author_id, n.headline, n.external_headline, n.live_headline, n.creation_date, n.update_date, n.pub_date, n.alias, n.subheadline, n.teaser, n.media, n.tags, n.views, n.screens, n.clicks, n.relations, n.comments, n.power_cover, n.cover_points,u.name as user_name FROM bs_news n INNER JOIN bs_editors u ON u.id = n.author_id AND u.ln = 'es' INNER JOIN bs_news_rel rel ON rel.newId = n.id AND rel.type_rel = 4 AND rel.typeId = 193547 AND rel.extraId = 72359 WHERE n.status = 1 AND n.ln='es' AND n.creation_date>'2024-02-07 11:00:00' AND n.creation_date<'2024-05-22 07:29:39' GROUP BY n.id ORDER BY n.cover_points DESC,n.creation_date DESC LIMIT 5
0.0018  SELECT * FROM futbol.calendars_lineups WHERE id = 193547 AND league_id = 72359 AND year = 2024