4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del Celta C – Gran Peña

Celta C – Gran Peña

Entrenador: Luis Bonilla

Información
  • Nombre del equipo Celta C – Gran Peña
  • Nombre completo Real Club Celta C - Gran Peña
  • Nombre corto GRA
  • País Iso code - es España
  • Ciudad Vigo
  • Entrenador Luis Bonilla
  • URL del equipo en RF //m.resultados-futbol.com/Gran-Pena
Otros Datos
  • Año de Fundación 1926
  • Presupuesto 10
  • Socios 400
Internet

Información sobre el estadio

  • Nombre del estadio MPAL BARREIRO
  • Capacidad 3
  • Dirección Avda. de ramon nieto, 306
  • Teléfono 986 271842
  • Fax 986 271842
  • Año de construcción 1986
MPAL BARREIRO

Partidos del Celta C – Gran Peña

Ir al LIVESCORE
07 Jun 20  Aplazado Celta C – Gran Peña Celta C – Gran Peña
-
Juvenil Ponteareas Juvenil Ponteareas 0
31 May 20  Aplazado Céltiga FC Céltiga FC
-
Celta C – Gran Peña Celta C – Gran Peña 0
24 May 20  Aplazado Celta C – Gran Peña Celta C – Gran Peña
-
Ribadumia Ribadumia 0
10 May 20  Aplazado Poligono San Ciprian Poligono San Ciprian
-
Celta C – Gran Peña Celta C – Gran Peña 0
03 May 20  Aplazado Celta C – Gran Peña Celta C – Gran Peña
-
Pontevedra B Pontevedra B 0
26 Abr 20  Aplazado Celta C – Gran Peña Celta C – Gran Peña
-
Barbadás Barbadás 0
19 Abr 20  Aplazado CD Valladares CD Valladares
-
Celta C – Gran Peña Celta C – Gran Peña 0
12 Abr 20  Aplazado Celta C – Gran Peña Celta C – Gran Peña
-
Sanxenxo Sanxenxo 0
05 Abr 20  Aplazado CD Moaña CD Moaña
-
Celta C – Gran Peña Celta C – Gran Peña 0
29 Mar 20  Aplazado Celta C – Gran Peña Celta C – Gran Peña
-
Cultural Areas Cultural Areas 0
22 Mar 20  Aplazado Mondariz CF Mondariz CF
-
Celta C – Gran Peña Celta C – Gran Peña 0
15 Mar 20  Aplazado Celta C – Gran Peña Celta C – Gran Peña
-
Cambados Cambados 0
08 Mar 20  Finalizado At. Arnoia At. Arnoia
1 - 0
Celta C – Gran Peña Celta C – Gran Peña 0
01 Mar 20  Finalizado Celta C – Gran Peña Celta C – Gran Peña
4 - 1
CD Beluso CD Beluso 0
16 Feb 20  Finalizado Porriño Industrial Porriño Industrial
0 - 2
Celta C – Gran Peña Celta C – Gran Peña 0
09 Feb 20  Finalizado Celta C – Gran Peña Celta C – Gran Peña
3 - 2
CD Velle CD Velle 0
02 Feb 20  Finalizado Villalonga FC Villalonga FC
0 - 1
Celta C – Gran Peña Celta C – Gran Peña 0
26 Ene 20  Finalizado Celta C – Gran Peña Celta C – Gran Peña
0 - 1
Portonovo Portonovo 0
19 Ene 20  Finalizado UD Atios UD Atios
0 - 0
Celta C – Gran Peña Celta C – Gran Peña 0
12 Ene 20  Finalizado Juvenil Ponteareas Juvenil Ponteareas
4 - 0
Celta C – Gran Peña Celta C – Gran Peña 0
05 Ene 20  Finalizado Celta C – Gran Peña Celta C – Gran Peña
2 - 0
Céltiga FC Céltiga FC 0
22 Dic 19  Finalizado Ribadumia Ribadumia
3 - 0
Celta C – Gran Peña Celta C – Gran Peña 0
15 Dic 19  Finalizado Celta C – Gran Peña Celta C – Gran Peña
1 - 1
Poligono San Ciprian Poligono San Ciprian 0
01 Dic 19  Finalizado Pontevedra B Pontevedra B
0 - 0
Celta C – Gran Peña Celta C – Gran Peña 0
24 Nov 19  Finalizado Barbadás Barbadás
5 - 0
Celta C – Gran Peña Celta C – Gran Peña 0
17 Nov 19  Finalizado Celta C – Gran Peña Celta C – Gran Peña
1 - 1
CD Valladares CD Valladares 0
10 Nov 19  Finalizado Sanxenxo Sanxenxo
1 - 0
Celta C – Gran Peña Celta C – Gran Peña 0
03 Nov 19  Finalizado Celta C – Gran Peña Celta C – Gran Peña
4 - 3
CD Moaña CD Moaña 0
27 Oct 19  Finalizado Cultural Areas Cultural Areas
2 - 1
Celta C – Gran Peña Celta C – Gran Peña 0
20 Oct 19  Finalizado Celta C – Gran Peña Celta C – Gran Peña
1 - 4
Mondariz CF Mondariz CF 0
13 Oct 19  Finalizado Cambados Cambados
2 - 1
Celta C – Gran Peña Celta C – Gran Peña 0
06 Oct 19  Finalizado Celta C – Gran Peña Celta C – Gran Peña
0 - 3
At. Arnoia At. Arnoia 0
29 Sep 19  Finalizado CD Beluso CD Beluso
4 - 1
Celta C – Gran Peña Celta C – Gran Peña 0
22 Sep 19  Finalizado Celta C – Gran Peña Celta C – Gran Peña
0 - 1
Porriño Industrial Porriño Industrial 0
15 Sep 19  Finalizado CD Velle CD Velle
1 - 1
Celta C – Gran Peña Celta C – Gran Peña 0
08 Sep 19  Finalizado Celta C – Gran Peña Celta C – Gran Peña
1 - 2
Villalonga FC Villalonga FC 0
01 Sep 19  Finalizado Portonovo Portonovo
0 - 1
Celta C – Gran Peña Celta C – Gran Peña 0
25 Ago 19  Finalizado Celta C – Gran Peña Celta C – Gran Peña
0 - 4
UD Atios UD Atios 0

Plantilla del Celta C – Gran Peña Temporada 2019/2020

Jugador Edad Origen Altura Peso Goles Tarjetas rojas Tarjetas amarillas
Portero
25 es - - - - -
24 es - - - - -
26 es - - - - -
Defensa
27 es - - - - -
33 es - - - - -
27 es - - - - -
31 es - - - - -
- es - - 1 - -
25 es - - 1 - -
24 es - - 1 - -
- es - - - - -
Centrocampista
26 es - - 1 - -
24 es - - 2 - -
26 es - - 4 - -
25 es - - - - -
25 es - - 4 - -
23 es - - - - -
23 es - - 1 - -
33 es - - 2 - -
26 es - - 1 - -
24 es - - 3 - -
Delantero
29 ch - - - - -
24 es - - 1 - -
27 es - - 1 - -
32 es - - 1 - -
- es - - - - -
- es - - - - -

Noticias de Preferente Galicia

Ver últimas noticias

Hallan muerto al futbolista Mitogo en el río Avia

Según informó 'Europa Press', David García Mitogo, desaparecido desde el pasado 11 de mayo, fue encontrado muerto este martes en el río Avia por los efectivos del grupo de Emerxencias Supramunicipais de Ribadavia.

Mitogo, desparecido: la Guardia Civil inició la búsqueda en el río Miño

David García Mitogo, futbolista del Atlético Arnoia e internacional con Guinea Ecuatorial, se encuentra desaparecido desde este jueves. La Guardia Civil ha iniciado la búsqueda en el río Miño, ya que su teléfono móvil fue encontrado en el puente que une Arnoia con Ribadavia.

La RFEF anunció un minuto de silencio en los partidos de Galicia

La Federación Española de Fútbol informó este viernes que habrá un minuto de silencio en todos los partidos de Galicia en recuerdo del naufragio del Pitanxo.

Sito Miñanco y el sueño efímero del Cambados: viajes, bolsas de dinero, prostitutas...

Sito Miñanco llevó al Cambados, un equipo hasta entonces común de categoría regional, a pugnar por ascender a Segunda División. Soñó con que el club de su pueblo jugase contra el Real Madrid, algo que se llegó a creer.

El narcotraficante gallego que soñaba con jugar contra el Madrid

Sito Miñanco lideró al equipo de fútbol de su pueblo natal, Cambados, hasta casi ascender a Segunda División. Llegó a creer que podrían jugar contra el Real Madrid, pero todo se esfumó en una gran operación contra el narcotráfico en Galicia.




  USO DE MEMORIA  
5,445,272 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0019
Controller Execution Time ( Home / Category )  0.1691
Total Execution Time  0.1710
  CADENA URL  
/Gran-Pena/2020
  GET DATOS  
$_GET['/Gran-Pena/2020']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (30)  
0.0017  SELECT type FROM routes WHERE alias = 'gran-pena'
0.0042  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 = 51174
0.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=1250 AND type_rel = 2
0.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=71 AND type_rel = 3
0.0020  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 3 AND rel.typeId = 71 AND rel.ln = 'es' AND rel.status=1 ORDER BY rel.creation_date desc,rel.cover_points DESC LIMIT 5
0.0021  SELECT /*53 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 (1255742,1252769,1104950,915136,915027) ORDER BY n.cover_points DESC, update_date DESC
0.0026  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 = '1250' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0021  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 = 51174 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 calendars2020 as c ON c.league_id = l.id WHERE (c.datateam1 = 1250 or c.datateam2 = 1250) AND l.year = 2020 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 calendars2020 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 = 1250 or c.datateam2 = 1250) AND l.year = 2020 GROUP BY c.id) ORDER BY shedule DESC LIMIT 120
0.0024  (SELECT c.id, rel.team_id FROM leagues l INNER JOIN calendars2020 as c ON c.league_id = l.id INNER JOIN events2020 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 = 1250 or c.datateam2 = 1250) AND l.year = 2020)
0.0029  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=1250 AND l.year in (2019,2020,2021) ORDER BY l.id DESC, l.year DESC ;
0.0020  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 (62844,45151) 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.0021  SELECT count(id) as num_players from rel_players WHERE league_id = 62844 AND teamId = 1250
0.0019  SELECT count(id) as num_players from rel_players WHERE league_id = 45151 AND teamId = 1250
0.0025  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff FROM `tables2020` 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 = 51174 AND t.round = 26 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0026  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 = '1250' 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 = '1250' and rp.type = 4
0.0022  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 = '1250' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0036  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 events2020 e ON e.player_id = p.id AND e.league_id = 51174 WHERE rp.league_id = 51174 AND rp.teamId = 1250 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.0022  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 events2020 e ON e.player_id = p.id AND e.league_id = 51174 WHERE rp.league_id = 51174 AND rp.teamId = 1250 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0022  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 events2020 e ON e.player_id = p.id AND e.league_id = 51174 WHERE rp.league_id = 51174 AND rp.teamId = 1250 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0025  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 = 1250 AND rp.league_id = 51174 AND l.year= 2020 GROUP BY rp.team_id ORDER BY l.end_date DESC LIMIT 1
0.0027  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=6304624 GROUP BY dp.id ORDER BY dp.role>0 DESC, dp.role ASC, dp.nick ASC, dp.id
0.0021  SELECT rp.player_id, rp.pj, rp.lineup FROM rel_players AS rp WHERE rp.team_id=6304624
0.0034  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 events2020 e ON rp.league_id = e.league_id AND rp.player_id = e.player_id WHERE rp.team_id=6304624 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.0027  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 events2020 e ON rp.league_id = e.league_id AND rp.player_id = e.player_id WHERE rp.team_id=6304624 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 events2020 e ON rp.league_id = e.league_id AND rp.player_id = e.player_id WHERE rp.team_id=6304624 and (e.action = 3 or e.action = 4) 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 events2020 e ON rp.league_id = e.league_id AND rp.player_id = e.player_id WHERE rp.team_id=6304624 AND (e.action = 22) 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 events2020 e ON rp.league_id = e.league_id AND rp.player_id = e.player_id WHERE rp.team_id=6304624 and (e.action = 19) GROUP BY dp.id ORDER BY cuenta DESC