4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Mirandés - Alcorcón
Jornada 1
FINALIZADO
10
10
841 Pts. Elo
38%
1º

869 Pts. Elo
61%
21º

4-0
Lunes, 14 Agosto 2023, 19:00
  • Estadio: Estadio Municipal de Anduva
Sergio Barcia 16'
1 - 0
Carlos Martín 37'
2 - 0
Gabri 59'
3 - 0
Carlos Martín 73'
4 - 0

Mirandés

4-5-1
Alineación Inicial
Suplentes

Alcorcón

4-4-2
Alineación Inicial
Suplentes

Eventos del partido

Goles

Gol de penalti
Sergio Barcia
minuto 16'
Gol de
Carlos Martín
minuto 37'
Gol de
Gabri
minuto 59'
Gol de
Carlos Martín
minuto 73'

Tarjetas

minuto 47'T. Amarilla Álex López
T. Amarilla
Pablo Ramón
minuto 92'

Cambios

minuto 46'Sale del partido Álvaro Bustos
minuto 46'Entra en el partido E. Addai
minuto 62'Sale del partido Álex López
Sale del partido
N. Iosifov
minuto 62'
minuto 62'Sale del partido Koldo Obieta
minuto 62'Entra en el partido Juan Artola
Entra en el partido
Jonathan Gómez
minuto 62'
minuto 62'Entra en el partido J. Garrido
minuto 62'Sale del partido Jacobo
minuto 62'Entra en el partido Chiki
Sale del partido
Álvaro Sanz
minuto 75'
Entra en el partido
Pablo Ramón
minuto 75'
Entra en el partido
Ilyas Chaira
minuto 75'
Sale del partido
Carlos Martín
minuto 75'
minuto 81'Sale del partido Javi Lara
minuto 81'Entra en el partido Iago López
Sale del partido
Juan María
minuto 93'
Entra en el partido
Ekhiotz
minuto 93'
Entra en el partido
Diego Rosales
minuto 93'
Sale del partido
Alan Godoy
minuto 93'

Otros

Asistencia
Álvaro Sanz
minuto 59'
Asistencia
Gabri
minuto 73'
minuto 15'Penalti cometido Víctor García

Estadísticas del partido

Mirandés Mirandés Alcorcón Alcorcón
38%
Posesión del balón
 61%
4
Goles
 0
6
Tiros a puerta
 6
7
Tiros fuera
 6
17
Total tiros
 18
6
Paradas del portero
 2
2
Saques de esquina
 5
0
Fueras de juego
 6
0
Tarjetas Rojas
 0
2
Asistencias
 0
3
Sustituciones
 3
14
Faltas
 6
0
Penalti cometido
 1
1 Comentarios + 2 respuestas
  • rojillo_viejo
    Hace 8 meses rojillo_viejo dice: Vamos Rojillos!

Partido televisado en...
Canal Medio Idioma País
LaLiga TV Hypermotion TV Castellano
Amazon Prime Video TV Castellano
M+ LaLiga TV 3 TV Castellano
DSports TV -
DGO TV -
DGO TV Latino
DSports TV Latino
DGO TV Latino
DGO TV -
DGO TV -
DGO TV Latino
DSports TV Latino

  USO DE MEMORIA  
7,193,136 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0011
Controller Execution Time ( Match / Index )  0.5223
Total Execution Time  0.5234
  CADENA URL  
/partido/Mirandes/Ad-Alcorcon/alineacion
  GET DATOS  
$_GET['/partido/Mirandes/Ad-Alcorcon/alineacion']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (11)  
0.0023   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` = '72177' AND c.`match_id` = '60527' AND c.comment_id IN (53069675) GROUP BY c.comment_id
0.0107  SELECT data1 FROM stats2024 t WHERE league_id = 72177 AND teamId = 6584343 and type = 33
0.0107  SELECT data1 FROM stats2024 t WHERE league_id = 72177 AND teamId = 6586744 and type = 33
0.0114  SELECT p.* FROM `videos` as p INNER JOIN `rel_videos` as rp ON p.id = rp.id_video WHERE rp.id_content = '60527' and rp.type = 2024 and p.revised = 1 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0109  SELECT iframe, title FROM futbol.match_videos WHERE matchId = 60527 AND year = 2024 AND channel = 'Footters' LIMIT 1
0.0109  SELECT iframe, title FROM futbol.match_videos WHERE matchId = 60527 AND year = 2024 AND channel = 'Footters' LIMIT 1
0.0107   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 = '53069675' AND c.lang = '1' ORDER BY creation_date DESC LIMIT 20
0.0110  SELECT `id`, `text` FROM `matchs_news_keys` WHERE `match_id`='60527' AND `active` = 1 AND year = 2024
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='72177' AND relp.team_id=6584343 WHERE relp.in_squad=1 and mp.`match_id` = '60527' AND mp.year='2024' ORDER BY mp.`team` ASC, p.`role` ASC
0.0375  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='72177' AND relp.team_id=6586744 WHERE relp.in_squad=1 and mp.`match_id` = '60527' AND mp.year='2024' ORDER BY mp.`team` ASC, p.`role` ASC
0.0108  SELECT * FROM futbol.calendars_lineups WHERE id = 60527 AND league_id = 72177 AND year = 2024