4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias

¿Falta algún dato de este equipo?

Si tienes datos del equipo que no se encuentran en la página nos encantaría que los compartas con nosotros. Un editor de la página validará los datos y en el plazo de tiempo más breve posible completarán los datos actuales con los enviados.

Información sobre Granada

Enviar Datos
Información
  • Nombre del equipo Granada
  • Nombre completo Granada Club de Fútbol SAD
  • Nombre corto GRA
  • País España
  • Ciudad Granada
  • Entrenador José Ramón Sandoval
  • URL del equipo en RF //m.resultados-futbol.com/Granada
Otros Datos
  • Año de Fundación 1931
  • Equipo Filial Granada B
  • Marca de Ropa Adidas
  • Lugar de entrenamiento Ciudad Deportiva del Granada CF
  • Socios 13800
Internet

Información sobre el estadio

  • Nombre del estadio Nuevo Los Cármenes
  • Capacidad 19336
  • Dirección Calle Pintor Manuel Maldonado, s/n, 18007, Granada
  • Teléfono 958 253 300
  • Fax 958 253 304
  • Año de construcción 1995
  • Tamaño 105 x 69 metros
Nuevo Los Cármenes

Histórico de participación

Copa del Rey
72 veces
(2025, 2024, 2023, 2022, 2021, 2020, 2019, 2018, 2017, 2016, 2015, 2014, 2013, 2012, 2011, 2009, 2007, 2005, 2002, 2001, 1999, 1997, 1995, 1994, 1993, 1992, 1991, 1989, 1988, 1987, 1986, 1985, 1984, 1983, 1982, 1981, 1980, 1979, 1978, 1977, 1976, 1975, 1974, 1973, 1972, 1971, 1970, 1969, 1968, 1967, 1966, 1965, 1964, 1963, 1962, 1961, 1960, 1959, 1958, 1953, 1950, 1949, 1948, 1947, 1946, 1945, 1944, 1943, 1942, 1941, 1936, 1935)
Segunda División
34 veces
(2023, 2019, 2018, 2011, 1988, 1985, 1984, 1981, 1980, 1979, 1978, 1977, 1968, 1966, 1965, 1964, 1963, 1962, 1957, 1956, 1955, 1954, 1953, 1952, 1951, 1950, 1949, 1948, 1947, 1946, 1941, 1940, 1936, 1935)
Primera División
27 veces
(2024, 2022, 2021, 2020, 2017, 2016, 2015, 2014, 2013, 2012, 1976, 1975, 1974, 1973, 1972, 1971, 1970, 1969, 1967, 1961, 1960, 1959, 1958, 1945, 1944, 1943, 1942)
Segunda División B Grupo 4
22 veces
(2010, 2009, 2008, 2007, 2002, 2001, 2000, 1999, 1998, 1997, 1996, 1995, 1994, 1993, 1992, 1991, 1990, 1989, 1987, 1986, 1983, 1982)
Partidos Amistosos
14 veces
(2024, 2023, 2022, 2021, 2020, 2019, 2018, 2017, 2016, 2015, 2014, 2013, 2012, 2011)
Segunda - Play Offs Ascenso
8 veces
(2011, 1967, 1966, 1959, 1955, 1945, 1943, 1941)
Segunda B - Play Offs Ascenso Grupo 0
5 veces
(2010, 2000, 1998, 1996, 1993)
Tercera División Grupo 9
5 veces
(2006, 2005, 2004, 2003, 1934)
Fase Previa Europa League Grupo 4
3 veces
(2021, 2021, 2021)
Copa Federación
2 veces
(2009, 2007)
Europa League Grupo 0
2 veces
(2021, 2021)
Copa de la Liga de Segunda División
2 veces
(1985, 1984)
Trofeo Ramón de Carranza
1 vez
(2016)
Trofeo Ciutat de Palma
1 vez
(2017)
Copa de la Liga Segunda División B Grupo 2
1 vez
(1983)
Trofeo Costa del Sol
1 vez
(1975)

Partidos del Granada

Ir al LIVESCORE
Primera División Primera División »
01 Jun 13  Finalizado Granada
2 - 0
 Getafe 1410
26 May 13  Finalizado Valencia
1 - 0
 Granada 299
18 May 13  Finalizado Granada
3 - 0
 OsasunaTarjeta Roja 1175
13 May 13  Finalizado Real Sociedad
2 - 2
 Granada 449
04 May 13  Finalizado Granada
1 - 0
 Málaga 463
28 Abr 13  Finalizado Espanyol
0 - 1
 Granada 684
20 Abr 13  Finalizado Granada
1 - 1
 Real Valladolid 407
14 Abr 13  Finalizado Atlético
5 - 0
 Granada 863
05 Abr 13  Finalizado Tarjeta RojaGranada
1 - 5
 Real Betis 757
01 Abr 13  Finalizado Tarjeta RojaAthletic
1 - 0
 Granada 2332
17 Mar 13  Finalizado Granada
1 - 1
 Levante 97
11 Mar 13  Finalizado Real Zaragoza
0 - 0
 Granada 185
03 Mar 13  Finalizado Granada
1 - 2
 Mallorca 227
24 Feb 13  Finalizado Celta
2 - 1
 Granada 427
16 Feb 13  Finalizado Granada
1 - 2
 Barcelona 1040
09 Feb 13  Finalizado Tarjeta RojaRC Deportivo
0 - 3
 Granada 365
02 Feb 13  Finalizado Granada
1 - 0
 Real Madrid 907
28 Ene 13  Finalizado Sevilla
3 - 0
 Granada 348
19 Ene 13  Finalizado Granada
2 - 0
 Rayo Vallecano 344
14 Ene 13  Finalizado Getafe
2 - 2
 Granada 358
05 Ene 13  Finalizado Tarjeta RojaGranada
1 - 2
 Valencia 623
22 Dic 12  Finalizado Osasuna
1 - 2
 Granada 737
15 Dic 12  Finalizado Granada
0 - 0
 Real Sociedad 232
08 Dic 12  Finalizado Málaga
4 - 0
 Granada 645
02 Dic 12  Finalizado Granada
0 - 0
 Espanyol 151
24 Nov 12  Finalizado Real Valladolid
1 - 0
 Granada 103
18 Nov 12  Finalizado Granada
0 - 1
 AtléticoTarjeta Roja 258
09 Nov 12  Finalizado Real Betis
1 - 2
 Granada 702
04 Nov 12  Finalizado Granada
1 - 2
 Athletic 510
28 Oct 12  Finalizado Levante
3 - 1
 Granada 432
21 Oct 12  Finalizado Tarjeta RojaGranada
1 - 2
 Real Zaragoza 622
07 Oct 12  Finalizado Tarjeta RojaMallorca
1 - 2
 GranadaTarjeta Roja 129
30 Sep 12  Finalizado Granada
2 - 1
 Celta 339
22 Sep 12  Finalizado Barcelona
2 - 0
 Granada 1064
16 Sep 12  Finalizado Granada
1 - 1
 RC Deportivo 354
02 Sep 12  Finalizado Real Madrid
3 - 0
 GranadaTarjeta Roja 731
26 Ago 12  Finalizado Granada
1 - 1
 SevillaTarjeta RojaTarjeta Roja 295
20 Ago 12  Finalizado Rayo Vallecano
1 - 0
 Granada 819
Copa del Rey Copa del Rey »
29 Nov 12  Finalizado Granada
2 - 1
 Real ZaragozaTarjeta Roja 80
31 Oct 12  Finalizado Real Zaragoza
1 - 0
 Granada 48
Partidos Amistosos Partidos Amistosos »
04 Ago 12  Finalizado Hércules
1 - 5
 Granada 0

Plantilla del Granada Temporada 2012/2013

Jugador Edad Origen Altura Peso Goles Tarjetas rojas Tarjetas amarillas
Portero
26 31 es 181 74 - - -
13 45 es 181 76 - - 3
1 44 es 182 81 - - 1
Defensa
2 35 cm 189 81 - - 9
16 34 co 175 77 1 - 1
20 35 es 185 81 - 1 5
5 41 es 187 80 1 - 2
6 37 br 184 76 6 1 9
8 41 es 185 74 - - 8
21 42 es 179 70 - - 3
18 41 es 186 84 - - -
23 43 es 185 85 - - 1
15 39 sn 184 78 - - 6
Centrocampista
7 40 it 180 74 1 - 4
12 36 ar 161 56 2 - 4
36 es 178 71 - - -
17 39 dz 187 77 - - -
24 43 br 179 70 - 1 5
14 39 es 178 75 2 1 6
28 33 es 183 79 2 - 6
Delantero
37 32 es 183 77 - - -
7 43 es 186 82 1 - 4
11 37 es 181 69 1 - 3
12 31 ve 171 70 - - -
19 38 cl 169 68 - - 4
22 34 ro 167 63 3 - 6
25 34 ng 181 73 4 - 4
10 33 es 177 77 - - 2
29 33 es 178 72 - - -
10 37 es 175 73 3 - 2
3 34 dz 175 66 - 1 8
9 37 ma 183 84 8 - 4

Noticias del Granada

Ver últimas noticias

Media Andalucía, pendiente del Sevilla

BeSoccer - Lunes, 22 Abril 2024
0 16.155

El Cádiz, el Granada y el Almería necesitan una victoria del Sevilla para mantenerse con vida. Con los dos últimos prácticamente descendidos, son los amarillos los que más intereses tienen en la victoria hispalense.

Resistir para poder optar a soñar

Javi Cubero - Viernes, 19 Abril 2024
2 6.594

Athletic y Granada firmaron las tablas en San Mamés (1-1) en un encuentro que se puso cuesta arriba para los vascos con el tanto en contra en los primeros compases del encuentro. No obstante, los 'leones' fueron los auténticos dueños del partido y firmaron un monólogo ofensivo ante su rival. Pese a ello, los nazaríes se aferran a la permanencia con un punto de vital importancia en sus aspiraciones para seguir en Primera.

Así seguimos el directo del Athletic - Granada

Javi Cubero - Viernes, 19 Abril 2024
0 10.032

Vive con nosotros el minuto a minuto de todo lo que suceda en el Athletic-Granada, encuentro correspondiente a la jornada 32 de Primera División y que se disputará en el estadio de San Mamés a partir de las 21.00 h.

LaLiga denunció insultos contra Samu Omorodion: "Eres una rata"

BeSoccer - Jueves, 18 Abril 2024
7 1.796

La vuelta de Samu Omorodion al Nuevo Los Cármenes fue abrupta. Su ex hinchada le dedicó varias pitadas cada vez que tocaba el balón y profirió varios insultos al atacante. LaLiga lo ha hecho constar en una denuncia dirigida al Comité de Competición.

Samu denuncia al Granada por su cláusula de rescisión

BeSoccer - Domingo, 14 Abril 2024
2 2.197

El 'Ideal' de Granada informa de que Samu Omorodion, ya jugador del Atlético de Madrid cedido en el Alavés, ha denunciado al club nazarí porque considera abusiva la cláusula de rescisión que facilitó su marcha al Cívitas Metropolitano por 6 millones de euros. El delantero llegó a tierras andaluzas en 2021, así que un juez tendrá que determinar si está de acuerdo con que los despachos del Nuevo Los Cármenes se aprovecharon de su situación.

Ver más noticias del equipo»



  USO DE MEMORIA  
6,293,552 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0033
Controller Execution Time ( Home / Category )  0.1877
Total Execution Time  0.1911
  CADENA URL  
/granada/2013
  GET DATOS  
$_GET['/granada/2013']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (34)  
0.0018  SELECT type FROM routes WHERE alias = 'granada'
0.0049  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 = 'granada' AND l.year = 2013 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.0020  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=4235 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=4235 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=4235 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=4235 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=4235 AND type_rel = 2
0.0091  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 2 AND rel.typeId = 4235 AND rel.ln = 'es' ORDER BY rel.cover_points DESC LIMIT 5
0.0021  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 (1312014,1311687,1311665,1311461,1310888) ORDER BY n.cover_points DESC, update_date DESC
0.0033  SELECT cat.logo,cat.official,cat.location,dt.nameShow,dt.basealias,t.teamId,l.year,t.qod,cat.coefficient,cat.active_year,cat.name,l.group_code,l.total_group,cat.alias,l.categoryId,l.year,l.id as league_id FROM datateams dt INNER JOIN teams t ON t.teamId = dt.id INNER JOIN leagues l ON l.id = t.league_id INNER JOIN categories cat ON cat.id = l.categoryId WHERE dt.id = '4235' AND l.year = 2013 ORDER BY l.year DESC,cat.coefficient DESC
0.0038  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 = '4235' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0024  (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 calendars2013 as c ON c.league_id = l.id WHERE (c.datateam1 = 4235 or c.datateam2 = 4235) AND l.year = 2013 GROUP BY cat.id) ORDER BY coefficient DESC,group_code ASC
0.0032  (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 calendars2013 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 = 4235 or c.datateam2 = 4235) AND l.year = 2013 GROUP BY c.id) ORDER BY shedule DESC LIMIT 120
0.0032  (SELECT c.id, rel.team_id FROM leagues l INNER JOIN calendars2013 as c ON c.league_id = l.id INNER JOIN events2013 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 = 4235 or c.datateam2 = 4235) AND l.year = 2013)
0.0037  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=4235 AND l.year in (2012,2013,2014) ORDER BY l.id DESC, l.year DESC ;
0.0019  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 (2735,2401,2399) 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.0024  SELECT count(id) as num_players from rel_players WHERE league_id = 2401 AND teamId = 4235
0.0033  SELECT count(id) as num_players from rel_players WHERE league_id = 2735 AND teamId = 4235
0.0037  SELECT count(id) as num_players from rel_players WHERE league_id = 2399 AND teamId = 4235
0.0032  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 = '4235' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0020  SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '4235' and rp.type = 4
0.0048  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 = '4235' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0019  SELECT count(id_content) as cuenta FROM `rel_videos` as rp WHERE rp.id_content = '4235' and rp.type = 4
0.0034  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 events2013 e ON e.player_id = p.id AND e.league_id = 1907 WHERE rp.league_id = 1907 AND rp.teamId = 4235 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.0033  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 events2013 e ON e.player_id = p.id AND e.league_id = 1907 WHERE rp.league_id = 1907 AND rp.teamId = 4235 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 events2013 e ON e.player_id = p.id AND e.league_id = 1907 WHERE rp.league_id = 1907 AND rp.teamId = 4235 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 = 4235 AND rp.league_id = 1907 AND l.year= 2013 GROUP BY rp.team_id ORDER BY l.end_date DESC LIMIT 1
0.0025  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=39075 GROUP BY dp.id ORDER BY dp.role>0 DESC, dp.role ASC, dp.nick ASC, dp.id
0.0022  SELECT rp.player_id, rp.pj, rp.lineup FROM rel_players AS rp WHERE rp.team_id=39075
0.0028  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 events2013 e ON rp.league_id = e.league_id AND rp.player_id = e.player_id WHERE rp.team_id=39075 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.0032  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 events2013 e ON rp.league_id = e.league_id AND rp.player_id = e.player_id WHERE rp.team_id=39075 and (e.action = 4 or e.action = 5) GROUP BY dp.id ORDER BY cuenta DESC
0.0025  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 events2013 e ON rp.league_id = e.league_id AND rp.player_id = e.player_id WHERE rp.team_id=39075 and (e.action = 3 or e.action = 4) GROUP BY dp.id ORDER BY cuenta DESC
0.0028   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 events2013 e ON rp.league_id = e.league_id AND rp.player_id = e.player_id WHERE rp.team_id=39075 AND (e.action = 22) GROUP BY dp.id ORDER BY cuenta DESC
0.0029  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 events2013 e ON rp.league_id = e.league_id AND rp.player_id = e.player_id WHERE rp.team_id=39075 and (e.action = 19) GROUP BY dp.id ORDER BY cuenta DESC