4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Alcorcón - FC Cartagena
1/32 Final
FINALIZADO
50
20
838 Pts. Elo

790 Pts. Elo

0(4-5)0
Miércoles, 06 Diciembre 2023, 12:00

Alcorcón

4-5-1
Alineación Inicial
Suplentes

FC Cartagena

4-3-3
Alineación Inicial
Suplentes

Eventos del partido

Tarjetas

T. Amarilla
Javi Lara
minuto 30'
T. Amarilla
Álvaro Bustos
minuto 45'
minuto 56'T. Amarilla Tomás Alarcón
T. Amarilla
Álex López
minuto 56'
T. Amarilla
Jacobo
minuto 65'
minuto 76'T. Amarilla José Fontán
T. Amarilla
Chema Rodríguez
minuto 104'

Cambios

minuto 58'Sale del partido Umaro Embaló
minuto 58'Sale del partido Mikel Rico
minuto 58'Entra en el partido Luis Muñoz
minuto 58'Sale del partido Lautaro De León
minuto 58'Entra en el partido Juan Carlos
minuto 58'Entra en el partido Hector Hevel
minuto 58'Sale del partido David Ferreiro
minuto 58'Entra en el partido Alfredo Ortuño
Sale del partido
Álvaro Bustos
minuto 61'
Sale del partido
Álex López
minuto 61'
Entra en el partido
Xavi Quintillà
minuto 61'
Entra en el partido
Pedro Mosquera
minuto 61'
Entra en el partido
Jacobo
minuto 61'
Sale del partido
David Morillas
minuto 61'
Sale del partido
Óscar Rivas
minuto 71'
Entra en el partido
Chema Rodríguez
minuto 71'
minuto 72'Sale del partido Jony Álamo
minuto 72'Entra en el partido Iván Calero
Sale del partido
Yan Eteki
minuto 78'
Entra en el partido
Javi Pérez
minuto 78'
minuto 91'Sale del partido Pedro Alcalá
minuto 91'Entra en el partido Damián Musto
Entra en el partido
Dyego Sousa
minuto 93'
Sale del partido
Koldo Obieta
minuto 93'

Tanda de penaltis

Array
Dyego Sousa
 1 Array
Alfredo Ortuño
 Array
Xavi Quintillà
 2 Array
Hector Hevel
 Array
Javi Lara
 3 Array
Luis Muñoz
 Array
Jacobo
 4 Array
José Fontán
 Array
Pedro Mosquera
 5 Array
Juan Carlos
 Array
Javi Pérez
 6 Array
Tomás Alarcón
 Array
Víctor García
 7 Array
Iván Calero

Estadísticas del partido

Alcorcón Alcorcón FC Cartagena Cartagena
0
Goles
 0
0
Tarjetas Rojas
 0
3
Sustituciones
 3
1 Comentarios + 1 respuestas
  • anima_modestos
    Hace 5 meses anima_modestos dice: 3-2 (Prórroga)


  USO DE MEMORIA  
7,119,216 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0009
Controller Execution Time ( Match / Index )  0.6553
Total Execution Time  0.6563
  CADENA URL  
/partido_71759/Ad-Alcorcon/Cartagena
  GET DATOS  
$_GET['/partido_71759/Ad-Alcorcon/Cartagena']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (15)  
0.0007   SELECT c.comment_id, 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` = '71759' AND c.`match_id` = '614693' AND c.comment_id IN (60174319) GROUP BY c.comment_id
0.0127  SELECT data1 FROM stats2024 t WHERE league_id = 71759 AND teamId = 6577296 and type = 33
0.0132  SELECT data1 FROM stats2024 t WHERE league_id = 71759 AND teamId = 6577272 and type = 33
0.0135  SELECT p.* FROM `videos` as p INNER JOIN `rel_videos` as rp ON p.id = rp.id_video WHERE rp.id_content = '614693' and rp.type = 2024 and p.revised = 1 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0129  SELECT iframe, title FROM futbol.match_videos WHERE matchId = 614693 AND year = 2024 AND channel = 'Footters' LIMIT 1
0.0130  SELECT iframe, title FROM futbol.match_videos WHERE matchId = 614693 AND year = 2024 AND channel = 'Footters' LIMIT 1
0.0136   SELECT c.id, c.author_name, c.comment, c.comment_id, c.author_id, c.creation_date, c.votes_up, c.device, fau.user_name, fau.adm AS user_adm, fau.role AS user_role, fau.adm_type AS user_adm_type, template, NOW() AS difference_time FROM comments AS c LEFT JOIN fa_user_mini AS fau ON fau.id = c.author_id WHERE c.`active`=1 AND c.to_review=0 AND c.device = 'web' AND c.comment_id = '60174319' AND c.lang = '1' ORDER BY creation_date DESC LIMIT 20
0.0130  SELECT `id`, `text` FROM `matchs_news_keys` WHERE `match_id`='614693' AND `active` = 1 AND year = 2024
0.0283  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='71759' AND relp.team_id=6577296 WHERE relp.in_squad=1 and mp.`match_id` = '614693' AND mp.year='2024' ORDER BY mp.`team` ASC, p.`role` ASC
0.0238  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='71759' AND relp.team_id=6577272 WHERE relp.in_squad=1 and mp.`match_id` = '614693' AND mp.year='2024' ORDER BY mp.`team` ASC, p.`role` ASC
0.0125  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=614693 AND extraId = 71759 AND type_rel = 4
0.0131  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 = 614693 AND rel.extraId = 71759 WHERE n.status = 1 AND n.ln='es' AND n.creation_date>'2023-10-07 13:00:00' AND n.creation_date<'2024-02-04 12:00:00' GROUP BY n.id ORDER BY n.cover_points DESC,n.creation_date DESC LIMIT 5
0.0125  SELECT position FROM tables2024 WHERE team=6577296 AND league_id=71759 AND round=3
0.0125  SELECT position FROM tables2024 WHERE team=6577272 AND league_id=71759 AND round=3
0.0125  SELECT * FROM futbol.calendars_lineups WHERE id = 614693 AND league_id = 71759 AND year = 2024