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 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
20 Jun 09  Finalizado Huesca Huesca
3 - 1
Girona GironaTarjeta Roja 2
13 Jun 09  Finalizado Girona Girona
0 - 1
Tenerife Tenerife 18
07 Jun 09  Finalizado Eibar Eibar
2 - 2
Girona Girona 5
30 May 09  Finalizado Girona Girona
2 - 1
Gimnàstic Tarragona Gimnàstic Tarragona 0
24 May 09  Finalizado CD Castellón CD Castellón
1 - 2
Girona GironaTarjeta Roja 7
16 May 09  Finalizado Elche Elche
2 - 1
Girona Girona 2
10 May 09  Finalizado Girona Girona
0 - 2
Xerez CD Xerez CD 0
03 May 09  Finalizado Sevilla At. Sevilla At.
2 - 1
Girona Girona 2
25 Abr 09  Finalizado Girona Tarjeta RojaGirona
0 - 1
Deportivo Alavés Deportivo AlavésTarjeta RojaTarjeta Roja 2
19 Abr 09  Finalizado Hércules Hércules
3 - 0
Girona Girona 8
11 Abr 09  Finalizado Girona Tarjeta RojaGirona
1 - 0
Real Murcia Real Murcia 2
04 Abr 09  Finalizado Real Zaragoza Real Zaragoza
1 - 0
Girona GironaTarjeta Roja 3
28 Mar 09  Finalizado Girona Girona
2 - 2
Las Palmas Las Palmas 0
22 Mar 09  Finalizado Real Sociedad Real Sociedad
2 - 0
Girona Girona 7
15 Mar 09  Finalizado Girona Tarjeta RojaGirona
0 - 0
Levante Levante 0
07 Mar 09  Finalizado Rayo Vallecano Rayo Vallecano
1 - 1
Girona Girona 3
28 Feb 09  Finalizado Girona Girona
1 - 1
Córdoba CF Córdoba CF 11
22 Feb 09  Finalizado UD Salamanca UD Salamanca
2 - 2
Girona GironaTarjeta Roja 1
14 Feb 09  Finalizado Girona Girona
3 - 3
Albacete Albacete 1
08 Feb 09  Finalizado Alicante Alicante
1 - 1
Girona Girona 2
31 Ene 09  Finalizado Girona Girona
2 - 2
Celta CeltaTarjeta Roja 1
24 Ene 09  Finalizado Girona Tarjeta RojaGirona
2 - 0
Huesca Huesca 0
18 Ene 09  Finalizado Tenerife Tenerife
4 - 1
Girona Girona 1
11 Ene 09  Finalizado Girona Girona
2 - 0
Eibar Eibar 1
03 Ene 09  Finalizado Gimnàstic Tarragona Tarjeta RojaGimnàstic Tarragona
3 - 0
Girona Girona 0
20 Dic 08  Finalizado Girona Girona
1 - 0
CD Castellón CD Castellón 3
14 Dic 08  Finalizado Girona Girona
1 - 1
Elche Elche 14
06 Dic 08  Finalizado Xerez CD Tarjeta RojaXerez CD
2 - 2
Girona GironaTarjeta Roja 0
29 Nov 08  Finalizado Girona Girona
1 - 0
Sevilla At. Sevilla At. 1
23 Nov 08  Finalizado Deportivo Alavés Deportivo Alavés
1 - 0
Girona Girona 1
16 Nov 08  Finalizado Girona Girona
1 - 0
Hércules Hércules 2
08 Nov 08  Finalizado Real Murcia Real Murcia
2 - 0
Girona Girona 2
01 Nov 08  Finalizado Girona Girona
1 - 0
Real Zaragoza Real ZaragozaTarjeta Roja 2
25 Oct 08  Finalizado Las Palmas Las Palmas
2 - 2
Girona Girona 0
18 Oct 08  Finalizado Girona Girona
0 - 0
Real Sociedad Real SociedadTarjeta Roja 0
12 Oct 08  Finalizado Levante Tarjeta RojaTarjeta RojaLevante
1 - 1
Girona Girona 1
04 Oct 08  Finalizado Girona Girona
1 - 1
Rayo Vallecano Rayo Vallecano 1
27 Sep 08  Finalizado Córdoba CF Córdoba CF
2 - 0
Girona GironaTarjeta Roja 0
21 Sep 08  Finalizado Girona Girona
0 - 1
UD Salamanca UD Salamanca 0
14 Sep 08  Finalizado Albacete Albacete
1 - 1
Girona Girona 1
07 Sep 08  Finalizado Girona Girona
3 - 0
Alicante AlicanteTarjeta Roja 0
30 Ago 08  Finalizado Celta Celta
0 - 1
Girona Girona 0
08 Oct 08  Finalizado Hércules Tarjeta RojaHércules
1 - 0
Girona Girona 0
03 Sep 08  Finalizado Gimnàstic Tarragona Gimnàstic Tarragona
0 - 2
Girona Girona 0

Plantilla del Girona Temporada 2008/2009

Jugador Edad Origen Altura Peso Goles Tarjetas rojas Tarjetas amarillas
Portero
13 44 es 187 81 - - 1
1 45 ve 182 80 - - 5
Defensa
15 44 es 179 75 - - 3
19 45 es 171 71 - - 2
2 40 es 175 71 - 1 16
16 47 ad 170 69 - - 4
22 44 es 185 80 - - 5
46 es 182 77 1 - 1
4 45 es 183 79 - - 7
3 45 es 187 80 4 3 9
Centrocampista
8 41 es 182 77 - 2 7
43 es 179 68 3 - 4
23 45 es 186 74 3 1 12
20 45 es 180 70 4 - 2
40 es 168 67 - - 1
33 es 167 64 - - -
5 47 es 182 73 1 - 11
44 es 179 75 2 - 1
Delantero
24 43 es 174 72 3 - -
14 42 es 175 72 4 - 3
25 42 es 164 66 6 1 5
7 38 es 174 76 3 - 7
33 jp 196 82 - - -
12 44 br 190 86 3 1 2
18 40 es - - 1 - 1
9 44 es 186 84 3 - 1
21 42 es 178 70 1 1 7
17 38 es 177 73 1 - 5

Noticias del Girona

Ver últimas noticias

Así va la lucha por la Liga

Únicamente 3 equipos tienen opciones matemáticas de conseguir el título de Liga cuando quedan cinco jornadas para el final. Eso sí, el Real Madrid puede conseguirlo esta misma jornada.

Bastón podría llegar a la ida contra el Zaragoza

El goleador del Real Zaragoza, Borja Bastón, se ha entrenado hoy con normalidad y podría estar disponible para ser convocado para el partido de ida de la segunda eliminatoria de la fase de ascenso a Primera que se jugará el próximo miércoles en el estadio de La Romareda contra la Unión Deportiva Las Palmas.

Jonás Ramalho es operado con éxito de su grave lesión de rodilla

El futbolista del Athletic Club Jonás Ramalho ha sido operado con éxito de la rotura de ligamento cruzado anterior en la rodilla izquierda que se produjo el pasado 20 de mayo en el partido entre el Deportivo Alavés y el Girona, club en el que ha jugado como cedido las dos últimas temporadas.

1-4. Un épico Zaragoza ahonda la depresión del Girona y jugará por el ascenso

Contra todo pronóstico, el Real Zaragoza ha conseguido una remontada histórica a domicilio y se ha impuesto por 1-4 al Girona, que no ha hecho valer el 0-3 en la ida, por lo que se jugará ante la UD Las Palmas el ascenso a Primera División.

0-3. El Girona, a un paso de la siguiente eliminatoria

El Girona dejó prácticamente resuelta la primera eliminatoria de la promoción de ascenso contra el Real Zaragoza en el encuentro de ida, en el que se impuso por 0-3 gracias a su gran efectividad en el remate en la primera mitad.




  USO DE MEMORIA  
6,183,472 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0019
Controller Execution Time ( Home / Category )  0.1997
Total Execution Time  0.2016
  CADENA URL  
/girona-fc/2009
  GET DATOS  
$_GET['/girona-fc/2009']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (28)  
0.0018  SELECT type FROM routes WHERE alias = 'girona-fc'
0.0062  SELECT dt.*,c.active_year,l.year,l.table_suffix, c.ctype, l.id as league_id,t.id as id,t.manager,t.name as nameOriginal,dt.id as teamId,cou.Name as cou_name,cou.Continent,cou.Region FROM `leagues_webci` as l INNER JOIN `teams` as t ON l.id = t.league_id INNER JOIN `datateams` as dt ON dt.id = t.teamId INNER JOIN `categories_webci` as c ON c.id = l.categoryId LEFT JOIN country cou ON LOWER(cou.Code2) = dt.CountryCode WHERE dt.basealias = 'girona-fc' AND l.year = 2009 ORDER BY c.top DESC, c.ctype != 12 DESC, c.troncal DESC, l.end_date >= NOW() DESC, l.start_date <= NOW() DESC, l.year DESC, c.coefficient DESC, l.id ASC
0.0019  SELECT dp.nick, dp.fullname,rp.date_ini, rp.date_end FROM futbol.rel_people rp INNER JOIN futbol.datapeople dp on dp.id=rp.people_id WHERE rp.teamId=1236 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0019  SELECT dp.nick, dp.fullname,rp.date_ini, rp.date_end FROM futbol.rel_people rp INNER JOIN futbol.datapeople dp on dp.id=rp.people_id WHERE rp.teamId=1236 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0019  SELECT dp.nick, dp.fullname,rp.date_ini, rp.date_end FROM futbol.rel_people rp INNER JOIN futbol.datapeople dp on dp.id=rp.people_id WHERE rp.teamId=1236 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0040  SELECT c.*, l.*, cou.name as namec, ct.table_sufix FROM (leagues l INNER JOIN categories c ON c.id = l.categoryId INNER JOIN categories_types ct ON c.ctype=ct.id LEFT JOIN country cou ON cou.Code2 = c.CountryCode) WHERE l.id = 105
0.0024  SELECT c.*, l.*, cou.name as namec, ct.table_sufix FROM (leagues l INNER JOIN categories c ON c.id = l.categoryId INNER JOIN categories_types ct ON c.ctype=ct.id LEFT JOIN country cou ON cou.Code2 = c.CountryCode) WHERE l.id = 805
0.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=1236 AND type_rel = 2
0.0098  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.0024  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 (1313219,79,198,245,349) ORDER BY n.cover_points DESC, update_date DESC
0.0065  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.0024  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 = 805 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
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 = 105 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0027  (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 calendars2009 as c ON c.league_id = l.id WHERE (c.datateam1 = 1236 or c.datateam2 = 1236) AND l.year = 2009 GROUP BY cat.id) ORDER BY coefficient DESC,group_code ASC
0.0054  (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 calendars2009 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 l.year = 2009 GROUP BY c.id) ORDER BY shedule DESC LIMIT 120
0.0058  (SELECT c.id, rel.team_id FROM leagues l INNER JOIN calendars2009 as c ON c.league_id = l.id INNER JOIN events2009 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 l.year = 2009)
0.0037  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.0019  SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '1236' and rp.type = 4
0.0044  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.0021  SELECT count(id_content) as cuenta FROM `rel_videos` as rp WHERE rp.id_content = '1236' and rp.type = 4
0.0046  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 = 105 AND l.year= 2009 GROUP BY rp.team_id ORDER BY l.end_date DESC LIMIT 1
0.0041  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=9610 GROUP BY dp.id ORDER BY dp.role>0 DESC, dp.role ASC, dp.nick ASC, dp.id
0.0025  SELECT rp.player_id, rp.pj, rp.lineup FROM rel_players AS rp WHERE rp.team_id=9610
0.0064  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 events2009 e ON rp.league_id = e.league_id AND rp.player_id = e.player_id WHERE rp.team_id=9610 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.0069  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 events2009 e ON rp.league_id = e.league_id AND rp.player_id = e.player_id WHERE rp.team_id=9610 and (e.action = 4 or e.action = 5) GROUP BY dp.id ORDER BY cuenta DESC
0.0097  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 events2009 e ON rp.league_id = e.league_id AND rp.player_id = e.player_id WHERE rp.team_id=9610 and (e.action = 3 or e.action = 4) GROUP BY dp.id ORDER BY cuenta DESC
0.0079   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 events2009 e ON rp.league_id = e.league_id AND rp.player_id = e.player_id WHERE rp.team_id=9610 AND (e.action = 22) GROUP BY dp.id ORDER BY cuenta DESC
0.0089  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 events2009 e ON rp.league_id = e.league_id AND rp.player_id = e.player_id WHERE rp.team_id=9610 and (e.action = 19) GROUP BY dp.id ORDER BY cuenta DESC