¿Eres mayor de edad?

SI NO

Confirma si tienes 18 años

Faldón apuestas
4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Mirandés - FC Andorra
Jornada 5
FINALIZADO
10
30
841 Pts. Elo
26%
8º

921 Pts. Elo
73%
12º

4-3
Domingo, 10 Septiembre 2023, 18:30
  • Estadio: Estadio Municipal de Anduva
Gabri 32'
1 - 0
Carlos Martín 43'
2 - 0
2 - 1
 66' Diego Alende
Alan Godoy 87'
3 - 1
3 - 2
 91' Iván Gil
3 - 3
 93' Diego Pampín
Carlos Martín 98'
4 - 3

Eventos del partido

Goles

GabriGol de
Gabri
minuto 32'
Carlos MartínGol de
Carlos Martín
minuto 43'
minuto 66'Diego AlendeGol de Diego Alende
Alan GodoyGol de
Alan Godoy
minuto 87'
minuto 91'Iván GilGol de Iván Gil
minuto 93'Diego PampínGol de Diego Pampín
Carlos MartínGol de
Carlos Martín
minuto 98'

Tarjetas

minuto 38'Migue LealT. Amarilla Migue Leal
TachiT. Amarilla
Tachi
minuto 62'
minuto 68'Jandro OrellanaT. Amarilla Jandro Orellana
minuto 84'Álvaro MartínT. Amarilla Álvaro Martín

Ocasiones

Álvaro SanzTiro al palo
Álvaro Sanz
minuto 60'
Carlos MartínTiro al palo
Carlos Martín
minuto 89'

Cambios

minuto 46'Álvaro MartínEntra en el partido Álvaro Martín
minuto 46'Álex CalvoEntra en el partido Álex Calvo
minuto 46'Rubén BoverSale del partido Rubén Bover
minuto 46'Manu NietoSale del partido Manu Nieto
minuto 46'Julen LobeteSale del partido Julen Lobete
minuto 46'Diego AlendeEntra en el partido Diego Alende
minuto 46'A. ScheidlerEntra en el partido A. Scheidler
minuto 46'A. ArroyoSale del partido A. Arroyo
Rubén SánchezSale del partido
Rubén Sánchez
minuto 56'
Javi MartónSale del partido
Javi Martón
minuto 56'
Diego MorenoEntra en el partido
Diego Moreno
minuto 56'
Alan GodoyEntra en el partido
Alan Godoy
minuto 56'
Ilyas ChairaSale del partido
Ilyas Chaira
minuto 62'
BarbuEntra en el partido
Barbu
minuto 62'
minuto 69'Sergio MolinaSale del partido Sergio Molina
minuto 69'Iván GilEntra en el partido Iván Gil
Álvaro SanzSale del partido
Álvaro Sanz
minuto 81'
TachiSale del partido
Tachi
minuto 81'
Pablo TomeoEntra en el partido
Pablo Tomeo
minuto 81'
A. ReinaEntra en el partido
A. Reina
minuto 81'

Otros

Carlos MartínAsistencia
Carlos Martín
minuto 32'
TachiAsistencia
Tachi
minuto 43'
minuto 66'José MarsàAsistencia José Marsà
minuto 93'Álex CalvoAsistencia Álex Calvo
GabriAsistencia
Gabri
minuto 98'

Alineaciones

Mirandés

Mirandés

4-4-2
Alineación Inicial
Suplentes
FC Andorra

FC Andorra

4-3-3
Alineación Inicial
Suplentes

Estadísticas del partido

Mirandés Mirandés FC Andorra FC Andorra
26%
Posesión del balón
 73%
4
Goles
 3
6
Tiros a puerta
 7
9
Tiros fuera
 10
17
Total tiros
 25
4
Paradas del portero
 2
3
Saques de esquina
 3
2
Fueras de juego
 0
0
Tarjetas Rojas
 0
3
Asistencias
 2
2
Tiros al palo
 0
3
Sustituciones
 3
9
Faltas
 11

Partido televisado en...

Canal Medio Idioma País
LaLiga TV Hypermotion 2LaLiga TV Hypermotion 2 TV Castellano es
LaLiga TV M2LaLiga TV M2 TV Castellano es
Amazon Prime VideoAmazon Prime Video TV Castellano es
Star+Star+ TV Latino ar
Star+Star+ TV Latino bo
Star+Star+ TV Latino cl
Star+Star+ TV Latino co

  USO DE MEMORIA  
7,705,392 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0014
Controller Execution Time ( Match / Index )  0.2257
Total Execution Time  0.2272
  CADENA URL  
/partido/Mirandes/Fc-Andorra-Senior/1991?section=legal
  GET DATOS  
$_GET['/partido/Mirandes/Fc-Andorra-Senior/1991']  
$_GET['section']   legal
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (12)  
0.0025   SELECT c.*, c.stadium as real_stadium, 2025 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 calendars2025 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 = 'Mirandes' AND dt2.basealias = 'Fc-Andorra-Senior'
0.0022   SELECT c.*, c.stadium as real_stadium, 2026 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 calendars2026 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 = 'Mirandes' AND dt2.basealias = 'Fc-Andorra-Senior'
0.0017  SELECT data1 FROM stats2024 t WHERE league_id = 72177 AND teamId = 6584343 and type = 33
0.0017  SELECT data1 FROM stats2024 t WHERE league_id = 72177 AND teamId = 6584333 and type = 33
0.0019  SELECT p.* FROM `videos` as p INNER JOIN `rel_videos` as rp ON p.id = rp.id_video WHERE rp.id_content = '60834' and rp.type = 2024 and p.revised = 1 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0017  SELECT iframe, title FROM futbol.match_videos WHERE matchId = 60834 AND year = 2024 AND channel = 'Footters' LIMIT 1
0.0017  SELECT iframe, title FROM futbol.match_videos WHERE matchId = 60834 AND year = 2024 AND channel = 'Footters' LIMIT 1
0.0040  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables2024` as t INNER JOIN teams as team ON team.id = t.team INNER JOIN datateams as dt ON team.teamId = dt.id WHERE t.league_id = 72177 AND t.round = 42 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0022  SELECT `id`, `text` FROM `matchs_news_keys` WHERE `match_id`='60834' AND `active` = 1 AND year = 2024
0.0113  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` = '60834' AND mp.year='2024' ORDER BY mp.`team` ASC, p.`role` ASC
0.0081  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=6584333 WHERE relp.in_squad=1 and mp.`match_id` = '60834' AND mp.year='2024' ORDER BY mp.`team` ASC, p.`role` ASC
0.0018  SELECT * FROM futbol.calendars_lineups WHERE id = 60834 AND league_id = 72177 AND year = 2024