4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Información
  • Nombre del equipo Girona
  • Nombre completo Girona Fútbol Club SAD
  • Nombre corto GIR
  • País Iso code - es España
  • Presidente Delfí Geli
  • Entrenador Míchel
  • URL del equipo en RF //m.resultados-futbol.com/Girona-Fc
Otros Datos
  • Año de Fundación 1930
  • Patrocinador Gobsi
  • Marca de Ropa Puma
  • Lugar de entrenamiento Camp Municipal de Torres de Palau
  • Socios 6000
Internet

Información sobre el estadio

  • Nombre del estadio Montilivi
  • Capacidad 11056
  • Dirección Avenida Montilivi, 141
  • Teléfono 902 54 84 54
  • Fax 972 214 744
  • Año de construcción 1970
  • Tamaño 105 x 68 metros
Montilivi

Partidos del Girona

Ir al LIVESCORE
25 May 24  en 15 días Girona Girona
21:00
Granada Granada 34
19 May 24  en 9 días Valencia Valencia
19:00
Girona Girona 6
14 May 24  en 4 días Girona Girona
22:00
Villarreal Villarreal 7
10 May 24  en 21 h Deportivo Alavés Deportivo Alavés
21:00
Girona Girona 75
04 May 24  Finalizado Girona Girona
4 - 2
Barcelona Barcelona 3466
27 Abr 24  Finalizado Las Palmas Las Palmas
0 - 2
Girona Girona 561
20 Abr 24  Finalizado Girona Girona
4 - 1
Cádiz Cádiz 406
13 Abr 24  Finalizado Atlético Atlético
3 - 1
Girona Girona 830
31 Mar 24  Finalizado Girona Girona
3 - 2
Real Betis Real Betis 699
16 Mar 24  Finalizado Getafe Getafe
1 - 0
Girona Girona 953
09 Mar 24  Finalizado Girona Girona
2 - 0
Osasuna Osasuna 585
03 Mar 24  Finalizado Mallorca Mallorca
1 - 0
Girona Girona 1294
26 Feb 24  Finalizado Girona Girona
3 - 0
Rayo Vallecano Rayo VallecanoTarjeta Roja 1002
19 Feb 24  Finalizado Athletic Athletic
3 - 2
Girona Girona 1285
10 Feb 24  Finalizado Real Madrid Real Madrid
4 - 0
Girona Girona 1893
03 Feb 24  Finalizado Girona Girona
0 - 0
Real Sociedad Real Sociedad 1751
28 Ene 24  Finalizado Celta Celta
0 - 1
Girona Girona 650
21 Ene 24  Finalizado Girona Girona
5 - 1
Sevilla Sevilla 1162
14 Ene 24  Finalizado Almería Almería
0 - 0
Girona GironaTarjeta Roja 1591
24 Ene 24  Finalizado Mallorca Tarjeta RojaMallorca
3 - 2
Girona Girona 2658
17 Ene 24  Finalizado Girona Girona
3 - 1
Rayo Vallecano Rayo Vallecano 447

Plantilla del Girona Temporada 2023/2024

Jugador Edad Origen Altura Peso Goles Tarjetas rojas Tarjetas amarillas
Portero
1 36 es 187 81 - - 1
13 32 ar 195 90 - - 2
26 23 es 195 83 - - -
Defensa
35 19 hu 193 86 - - -
4 21 es 182 72 - - 4
17 34 nl 180 72 1 - 5
5 34 es 185 80 3 - 3
25 23 es 182 79 3 - 4
15 33 es 190 85 - - 4
3 22 es 180 68 2 - 4
20 21 br 168 62 1 - 8
Centrocampista
14 26 es 173 61 3 1 4
10 33 es 175 73 - - -
23 25 es 178 70 5 - 5
22 19 co 186 69 - - -
18 21 es 173 63 - - 1
36 21 es 181 - - - -
28 19 es 187 79 - - -
21 26 ve 184 78 4 - 8
Delantero
9 26 ua 189 78 20 - 2
7 37 uy 184 78 8 - 6
40 19 es 182 - - - -
30 20 es 178 60 - - -
31 20 pt 180 - - - -
24 31 es 167 70 7 - 3
16 20 br 176 66 8 - 5
19 29 es 172 63 - - -
8 26 ua 178 70 6 - -
11 24 es 182 73 2 - 1

Noticias del Girona

Ver últimas noticias

"El primer partido del Girona en Europa será en Champions, en Montilivi"

Míchel piensa ya en el curso que viene y deja claro que el equipo debe jugar en Montilivi "al 100%" pese a los problemas del aforo del estadio. Además reconoció que terminar en el segundo puesto se ha convertido en "el objetivo" del Girona.

LaLiga EA Sports: lesionados, sancionados y apercibidos de la jornada 35

La actualidad de los jugadores lesionados, sancionados y apercibidos en los equipos de LaLiga EA Sports para la jornada 35 de la Primera División Española.

Posibles alineaciones del Alavés vs Girona

Estos son los onces posibles del Alavés-Girona, duelo de la 35ª jornada de Primera División 2023-24 que se disputará en el Estadio Mendizorroza de la ciudad vasca de Vitoria.

El Barça ata a Guido por un Oriol que volverá al Girona

'Mundo Deportivo' da por hecho que el Barcelona fichará a Guido Rodríguez como agente libre aprovechando que termina su contrato con el Real Betis este verano. En paralelo, también se certificaría la vuelta de Oriol Romeu al Girona, que recibió, en el pasado, 3.8 millones de euros de las arcas de Montjuïc por su traspaso. Míchel Sánchez estaría encantado de contar con él de nuevo, algo que ya ha verbalizado en público.

Horarios unificados confirmados para el desenlace de la Liga

LaLiga dio a conocer este miércoles los horarios unificados de la jornada 38 en Primera División. Sumados a los de la 37ª, el 19 de mayo a las 19:00 y el 25 a las 21:00 serán las fechas a marcar en el calendario con la lucha por Europa y el drama del descenso en juego.




  USO DE MEMORIA  
5,953,200 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0019
Controller Execution Time ( Home / Category )  0.1710
Total Execution Time  0.1729
  CADENA URL  
/Girona-Fc/1937?section=legal
  GET DATOS  
$_GET['/Girona-Fc/1937']  
$_GET['section']   legal
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (29)  
0.0017  SELECT type FROM routes WHERE alias = 'girona-fc'
0.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=1236 AND type_rel = 2
0.0068  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 2 AND rel.typeId = 1236 AND rel.ln = 'es' ORDER BY rel.cover_points DESC LIMIT 5
0.0022  SELECT /*35 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' WHERE n.status = 1 AND n.ln = 'es' AND n.id IN (1314647,1188739,1314287,1314603,1314460) ORDER BY n.cover_points DESC, update_date DESC
0.0043  SELECT SQL_NO_CACHE res.id as id, res.group_code, res.total_group, res.logo, res.alias FROM (SELECT ct.active_year, ct.id as id, l.year, l.end,l.group_code, l.total_group, ct.logo, ct.alias FROM categories AS ct INNER JOIN leagues AS l ON ct.id=l.categoryId AND ct.active_year=l.year INNER JOIN teams AS t ON l.id=t.league_id WHERE t.teamId = '1236' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0020  SELECT t.id,t.teamId,t.total_players,dt.nameShow,dt.basealias FROM teams t INNER JOIN datateams dt ON t.teamId = dt.id WHERE t.league_id = 72116 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0022  (SELECT cat.id as category_id, cat.logo, l.id,cat.alias,cat.name,l.group_code,l.total_group,cat.CountryCode,max(c.shedule) ult_partido,min(c.shedule) ini_partido,cat.coefficient FROM leagues l INNER JOIN categories as cat ON cat.id = l.categoryId INNER JOIN calendars2024 as c ON c.league_id = l.id WHERE (c.datateam1 = 1236 or c.datateam2 = 1236) AND ABS(UNIX_TIMESTAMP(c.shedule)-UNIX_TIMESTAMP())<120*3600*24 AND l.year = 2024 GROUP BY cat.id) ORDER BY coefficient DESC,group_code ASC
0.0030  (SELECT cat.id as category_id, l.year,cat.coefficient,c.extra,c.datateam1,c.datateam2,c.id as mid,c.r1,c.r2,c.shedule,c.team1,c.team2,l.id,dt1.nameShow as nameShow1,dt2.nameShow as nameShow2,dt1.basealias as basealias1,dt2.basealias as basealias2,c.comments as totalcomments FROM leagues l INNER JOIN categories as cat ON cat.id = l.categoryId INNER JOIN calendars2024 as c ON c.league_id = l.id INNER JOIN teams t1 ON t1.id = c.team1 INNER JOIN teams t2 ON t2.id = c.team2 INNER JOIN datateams dt1 ON dt1.id = t1.teamId INNER JOIN datateams dt2 ON dt2.id = t2.teamId WHERE (c.datateam1 = 1236 or c.datateam2 = 1236) AND ABS(UNIX_TIMESTAMP(c.shedule)-UNIX_TIMESTAMP())<120*3600*24 AND l.year = 2024 GROUP BY c.id) ORDER BY shedule DESC LIMIT 120
0.0023  (SELECT c.id, rel.team_id FROM leagues l INNER JOIN calendars2024 as c ON c.league_id = l.id INNER JOIN events2024 as e ON e.team1id = c.team1 AND e.team2id = c.team2 AND (e.action = 3 OR e.action = 4) INNER JOIN rel_players rel ON rel.player_id = e.player_id AND rel.in_squad = 1 AND rel.league_id = e.league_id AND rel.in_squad = 1 WHERE (c.datateam1 = 1236 or c.datateam2 = 1236) AND ABS(UNIX_TIMESTAMP(c.shedule)-UNIX_TIMESTAMP())<120*3600*24 AND l.year = 2024)
0.0031  SELECT t.id as team_id, ct.id, l.id as idLeague, l.year, ct.name, l.start_date, l.end_date FROM categories AS ct INNER JOIN leagues AS l ON ct.id=l.categoryId INNER JOIN teams AS t ON l.id=t.league_id WHERE t.teamId=1236 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0018  SELECT ct.id, ct.alias, ct.name AS name, ct.active_year, ct.coefficient AS coefficient, l.id AS league_id, l.year, l.total_group FROM categories AS ct INNER JOIN leagues AS l ON ct.id=l.categoryId WHERE l.id IN (75879,72116,71432) ORDER BY ct.ctype != 12 DESC, ct.troncal DESC, ct.coefficient DESC, l.end_date >= NOW() DESC, l.start_date <= NOW() DESC, l.year DESC, ct.coefficient DESC, l.group_code ASC
0.0025  SELECT count(id) as num_players from rel_players WHERE league_id = 72116 AND teamId = 1236
0.0018  SELECT count(id) as num_players from rel_players WHERE league_id = 75879 AND teamId = 1236
0.0039  SELECT count(id) as num_players from rel_players WHERE league_id = 71432 AND teamId = 1236
0.0028  SELECT p.* FROM `rel_pictures` as rp INNER JOIN `pictures` as p ON p.id = rp.id_picture INNER JOIN fa_user u ON u.id = p.author_id WHERE rp.id_content = '1236' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0018  SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '1236' and rp.type = 4
0.0030  SELECT p.* FROM `rel_videos` as rp INNER JOIN `videos` as p ON p.id = rp.id_video INNER JOIN fa_user u ON u.id = p.author_id WHERE rp.id_content = '1236' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0018  SELECT count(id_content) as cuenta FROM `rel_videos` as rp WHERE rp.id_content = '1236' and rp.type = 4
0.0055  SELECT e.action,rp.player_id, count(e.action) as total, p.nick,p.name,p.last_name,p.alias,rp.team_id FROM `rel_players` rp INNER JOIN dataplayers p ON p.id = rp.player_id INNER JOIN events2024 e ON e.player_id = p.id AND e.league_id = 72116 WHERE rp.league_id = 72116 AND rp.teamId = 1236 AND (e.action = 1 or e.action = 2 or e.action = 11 or e.action = 12 or e.action = 13) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0037  SELECT e.action,rp.player_id, count(e.action) as total, p.nick,p.name,p.last_name,p.alias,rp.team_id FROM `rel_players` rp INNER JOIN dataplayers p ON p.id = rp.player_id INNER JOIN events2024 e ON e.player_id = p.id AND e.league_id = 72116 WHERE rp.league_id = 72116 AND rp.teamId = 1236 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0030  SELECT e.action,rp.player_id, count(e.action) as total, p.nick,p.name,p.last_name,p.alias,rp.team_id FROM `rel_players` rp INNER JOIN dataplayers p ON p.id = rp.player_id INNER JOIN events2024 e ON e.player_id = p.id AND e.league_id = 72116 WHERE rp.league_id = 72116 AND rp.teamId = 1236 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0024  SELECT rp.team_id as teamId FROM rel_players AS rp inner join datateams as dt on rp.teamId=dt.id and rp.in_squad=1 INNER JOIN leagues as l ON l.id = rp.league_id WHERE dt.id = 1236 AND rp.league_id = 72116 AND l.year= 2024 GROUP BY rp.team_id ORDER BY l.end_date DESC LIMIT 1
0.0028  SELECT dp.id, dp.nick, dp.name, dp.last_name, dp.alias, dp.role, dp.height,dp.weight,dp.foot,dp.side,dp.birthdate,IF(dp.birthdate != '0000-00-00 00:00:00', YEAR(CURDATE())-YEAR(dp.birthdate) + IF(DATE_FORMAT(CURDATE(),'%m-%d') > DATE_FORMAT(dp.birthdate,'%m-%d'), 0, -1) , NULL) as age,rp.squadNumber,rp.captain,IF(dp.CountryCode IS NULL,'',dp.CountryCode) AS CountryCode,count(rp.id) as cuenta FROM rel_players as rp inner join dataplayers as dp on rp.player_id=dp.id and rp.in_squad=1 WHERE rp.team_id=6583640 GROUP BY dp.id ORDER BY dp.role>0 DESC, dp.role ASC, dp.nick ASC, dp.id
0.0018  SELECT rp.player_id, rp.pj, rp.lineup FROM rel_players AS rp WHERE rp.team_id=6583640
0.0037  SELECT dp.id,count(rp.id) as cuenta FROM rel_players as rp inner join dataplayers as dp on rp.player_id=dp.id INNER JOIN events2024 e ON rp.league_id = e.league_id AND rp.player_id = e.player_id WHERE rp.team_id=6583640 and (e.action = 1 or e.action = 2 or e.action = 11 or e.action = 12 or e.action = 13) GROUP BY dp.id ORDER BY cuenta DESC
0.0030  SELECT dp.id,count(rp.id) as cuenta FROM rel_players as rp inner join dataplayers as dp on rp.player_id=dp.id INNER JOIN events2024 e ON rp.league_id = e.league_id AND rp.player_id = e.player_id WHERE rp.team_id=6583640 and (e.action = 4 or e.action = 5) GROUP BY dp.id ORDER BY cuenta DESC
0.0024  SELECT dp.id,count(rp.id) as cuenta FROM rel_players as rp inner join dataplayers as dp on rp.player_id=dp.id INNER JOIN events2024 e ON rp.league_id = e.league_id AND rp.player_id = e.player_id WHERE rp.team_id=6583640 and (e.action = 3 or e.action = 4) GROUP BY dp.id ORDER BY cuenta DESC
0.0026   SELECT dp.id,count(rp.id) as cuenta FROM rel_players as rp inner join dataplayers as dp on rp.player_id=dp.id INNER JOIN events2024 e ON rp.league_id = e.league_id AND rp.player_id = e.player_id WHERE rp.team_id=6583640 AND (e.action = 22) GROUP BY dp.id ORDER BY cuenta DESC
0.0030  SELECT dp.id,count(rp.id) as cuenta FROM rel_players as rp inner join dataplayers as dp on rp.player_id=dp.id INNER JOIN events2024 e ON rp.league_id = e.league_id AND rp.player_id = e.player_id WHERE rp.team_id=6583640 and (e.action = 19) GROUP BY dp.id ORDER BY cuenta DESC