30 May 21	Finalizado	Ponferradina	2 - 2	Mallorca	302
24 May 21	Finalizado	CE Sabadell	2 - 0	Ponferradina	292
18 May 21	Finalizado	Ponferradina	1 - 4	Espanyol	245
15 May 21	Finalizado	CD Castellón	0 - 2	Ponferradina	859
08 May 21	Finalizado	Ponferradina	0 - 1	Albacete	166
02 May 21	Finalizado	Las Palmas	2 - 0	Ponferradina	176
24 Abr 21	Finalizado	Ponferradina	2 - 0	CD Lugo	227
19 Abr 21	Finalizado	Leganés	1 - 1	Ponferradina	203
10 Abr 21	Finalizado	Ponferradina	0 - 0	Fuenlabrada	103
03 Abr 21	Finalizado	Girona	3 - 1	Ponferradina	143
30 Mar 21	Finalizado	Ponferradina	2 - 2	UD Logroñés	293
27 Mar 21	Finalizado	Real Oviedo	1 - 1	Ponferradina	327
21 Mar 21	Finalizado	Ponferradina	2 - 1	Almería	317
12 Mar 21	Finalizado	FC Cartagena	1 - 1	Ponferradina	122
07 Mar 21	Finalizado	Ponferradina	2 - 2	Real Sporting	416
27 Feb 21	Finalizado	Rayo Vallecano	1 - 1	Ponferradina	110
19 Feb 21	Finalizado	Ponferradina	1 - 0	Mirandés	215
13 Feb 21	Finalizado	Tenerife	1 - 0	Ponferradina	181
08 Feb 21	Finalizado	Ponferradina	2 - 0	Alcorcón	140
29 Ene 21	Finalizado	Real Zaragoza	1 - 0	Ponferradina	389
23 Ene 21	Finalizado	Málaga	0 - 2	Ponferradina	84
11 Ene 21	Finalizado	Ponferradina	1 - 1	Girona	142
03 Ene 21	Finalizado	Almería	3 - 1	Ponferradina	192
18 Dic 20	Finalizado	Ponferradina	1 - 0	Real Oviedo	244
11 Dic 20	Finalizado	CD Lugo	1 - 0	Ponferradina	233
05 Dic 20	Finalizado	Ponferradina	0 - 0	Las Palmas	128
02 Dic 20	Finalizado	UD Logroñés	1 - 2	Ponferradina	130
29 Nov 20	Finalizado	Ponferradina	3 - 2	Leganés	151
25 Nov 20	Finalizado	Fuenlabrada	1 - 1	Ponferradina	112
22 Nov 20	Finalizado	Ponferradina	2 - 1	Real Zaragoza	261
15 Nov 20	Finalizado	Ponferradina	1 - 1	Málaga	216
08 Nov 20	Finalizado	Mallorca	3 - 0	Ponferradina	143
05 Nov 20	Finalizado	Alcorcón	0 - 1	Ponferradina	219
01 Nov 20	Finalizado	Ponferradina	0 - 3	CE Sabadell	333
28 Oct 20	Finalizado	Espanyol	2 - 0	Ponferradina	241
25 Oct 20	Finalizado	Real Sporting	2 - 1	Ponferradina	355
21 Oct 20	Finalizado	Ponferradina	1 - 0	Tenerife	108
11 Oct 20	Finalizado	Ponferradina	0 - 2	FC Cartagena	387
03 Oct 20	Finalizado	Mirandés	0 - 1	Ponferradina	187
27 Sep 20	Finalizado	Ponferradina	3 - 0	Rayo Vallecano	188
20 Sep 20	Finalizado	Albacete	0 - 2	Ponferradina	270
12 Sep 20	Finalizado	Ponferradina	1 - 2	CD Castellón	733

Copa del Rey »

15 Dic 20

Finalizado

Portugalete

1 - 0

Ponferradina Tarjeta Roja

251

Partidos Amistosos »

05 Sep 20	Finalizado	Ponferradina	0 - 1	Real Oviedo	32
~~04 Sep 20~~	Aplazado	Real Sporting	-	Ponferradina	4
28 Ago 20	Finalizado	Real Sporting	1 - 0	Ponferradina	28
26 Ago 20	Finalizado	CD Lugo	1 - 2	Ponferradina	12

Estadísticas

GOLEADORES

Yuri11

AMARILLAS

ROJAS

Plantilla del Ponferradina Temporada 2020/2021

		Edad	Altura	Peso
Portero
1	G. Gazzaniga	30	187	85	-	-	-
25	J. A. Caro	29	184	88	-	1	5
13	Manu García	33	192	83	-	-	2
Defensa
17	A. Castellano	29	181	69	-	1	2
28	A. Pașcanu	25	187	73	1	-	1
46	A. Pedraza	23	185	77	-	-	-
40	Edu	23	-	-	-	-	-
2	Iván Rodríguez	28	180	70	1	-	3
3	J. Ríos	33	182	78	-	-	4
40	Jonatan Lopes	24	-	-	-	-	-
5	José Amo	26	182	75	1	-	9
27	Manu Hernando	25	183	76	-	-	4
22	Paris Adot	34	172	70	2	-	5
32	Urbina	24	-	-	-	-	-
15	Yac Diori	26	183	79	-	-	1
Centrocampista
33	A. Viedma	25	172	67	-	-	-
18	Erik Morán	32	187	74	-	-	5
30	Juergen	24	173	72	-	-	2
29	Mario Ordoñez	24	-	-	-	-	-
6	Óscar Sielva	32	180	78	9	-	2
8	Pablo Larrea	30	173	69	-	-	5
23	Saúl Crespo	27	186	79	-	-	2
14	Sergio Aguza	31	176	68	1	-	5
Delantero
31	Aziz Sagna	22	-	-	-	-	-
26	Bolaños	25	184	73	-	-	1
19	Carlos Doncel	27	167	64	1	-	4
16	Curro Sánchez	28	176	71	5	1	4
21	Dani Romera	28	172	66	1	-	-
7	G. Panadero	26	165	60	1	-	1
9	Kaxe	30	183	80	3	-	3
20	Pablo Valcarce	31	172	70	5	-	6
10	Yuri	41	186	78	11	-	3

Noticias del Ponferradina

Ver últimas noticias

Sorteadas la primera y la segunda ronda de la Copa del Rey

Sergio Álvarez - Martes, 21 Julio 2015

22 15.650

En ella toman parte los equipos de Tercera, Segunda División B y Segunda División.

Casado cambia el Betis por la Ponferradina

BeSoccer - Martes, 21 Julio 2015

0 568

El lateral izquierdo Jorge Casado, que había sido liberado por el Real Betis, ha firmado con la Ponferradina, según ha hecho público el club berciano.

Ponferradina: A por otra temporada cómoda en Segunda

Ángela M. Romero - Martes, 14 Julio 2015

0 130

El club empezará una nueva temporada que espera finalizar lejos de los puestos de descenso en El Toralín ante el Elche.

La Ponferradina ata a Dani Suárez

BeSoccer - Viernes, 03 Julio 2015

0 466

La Ponferradina ha fichado a Dani Suárez, central del Real Madrid Castilla que disputó 33 encuentros la pasada campaña. El zaguero firma por dos temporadas según anunció la propia Ponferradina en su web.

El Alavés ficha a Javier Carpio

BeSoccer - Miércoles, 01 Julio 2015

0 350

Tras anunciar 14 salidas, el club ya ha realizado tres nuevos fichajes de cara a la temporada 2015-16.

Ver más noticias del equipo»

Competiciones que juega

Grupo 1

Segunda División

Pos	Equipos		Pts
1		Espanyol	82
2		Mallorca	82
3		Leganés	73
4		Almería	73
5		Girona	71
6		Rayo Vallecano	67
7		Real Sporting	65
8		Ponferradina	57
9		Las Palmas	56
10		Mirandés	54
11		Fuenlabrada	54
12		Málaga	53
13		Real Oviedo	52
14		Tenerife	52
15		Real Zaragoza	50
16		FC Cartagena	49
17		Alcorcón	48
18		CD Lugo	47
19		CE Sabadell	46
20		UD Logroñés	44
21		CD Castellón	41
22		Albacete	38

	Ascenso : Espanyol, Mallorca
	Playoff Ascenso : Leganés, Almería, Girona, Rayo Vallecano
	Descenso : CE Sabadell, UD Logroñés, CD Castellón, Albacete

RIVALES EN Copa del Rey

RIVALES EN Segunda División

USO DE MEMORIA

6,300,776 bytes

BENCHMARKS

Loading Time Base Classes	0.0018
Controller Execution Time ( Home / Category )	0.5759
Total Execution Time	0.5777

CADENA URL

/ponferradina-sd/2021

GET DATOS

$_GET['/ponferradina-sd/2021']

POST DATOS

No hay datos POST existentes

CONSULTAS (34)

0.0126	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 = 'ponferradina-sd' AND l.year = 2021 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.0105	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=3287 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0106	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=3287 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0106	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=3287 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0106	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=3287 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0105	SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=3287 AND type_rel = 2
0.0121	SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 2 AND rel.typeId = 3287 AND rel.ln = 'es' ORDER BY rel.cover_points DESC LIMIT 5
0.0108	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 (1194,1427,2575,3226,3254) ORDER BY n.cover_points DESC, update_date DESC
0.0120	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 = '3287' AND l.year = 2021 ORDER BY l.year DESC,cat.coefficient DESC
0.0127	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 = '3287' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0118	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 = 59872 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0113	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 = 57314 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0120	(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 calendars2021 as c ON c.league_id = l.id WHERE (c.datateam1 = 3287 or c.datateam2 = 3287) AND l.year = 2021 GROUP BY cat.id) ORDER BY coefficient DESC,group_code ASC
0.0167	(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 calendars2021 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 = 3287 or c.datateam2 = 3287) AND l.year = 2021 GROUP BY c.id) ORDER BY shedule DESC LIMIT 120
0.0112	(SELECT c.id, rel.team_id FROM leagues l INNER JOIN calendars2021 as c ON c.league_id = l.id INNER JOIN events2021 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 = 3287 or c.datateam2 = 3287) AND l.year = 2021)
0.0114	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=3287 AND l.year in (2020,2021,2022) ORDER BY l.id DESC, l.year DESC ;
0.0107	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 (72595,65506,62832,62807) 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.0116	SELECT count(id) as num_players from rel_players WHERE league_id = 62832 AND teamId = 3287
0.0124	SELECT count(id) as num_players from rel_players WHERE league_id = 65506 AND teamId = 3287
0.0191	SELECT count(id) as num_players from rel_players WHERE league_id = 62807 AND teamId = 3287
0.0109	SELECT count(id) as num_players from rel_players WHERE league_id = 72595 AND teamId = 3287
0.0219	SELECT t.,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff FROM* `tables2021` 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 = 57314 AND t.round = 42 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0147	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 events2021 e ON e.player_id = p.id AND e.league_id = 57314 WHERE rp.league_id = 57314 AND rp.teamId = 3287 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.0182	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 events2021 e ON e.player_id = p.id AND e.league_id = 57314 WHERE rp.league_id = 57314 AND rp.teamId = 3287 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0182	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 events2021 e ON e.player_id = p.id AND e.league_id = 57314 WHERE rp.league_id = 57314 AND rp.teamId = 3287 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0112	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 = 3287 AND rp.league_id = 57314 AND l.year= 2021 GROUP BY rp.team_id ORDER BY l.end_date DESC LIMIT 1
0.0111	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=6382797 GROUP BY dp.id ORDER BY dp.role>0 DESC, dp.role ASC, dp.nick ASC, dp.id
0.0108	SELECT rp.player_id, rp.pj, rp.lineup FROM rel_players AS rp WHERE rp.team_id=6382797
0.0171	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 events2021 e ON rp.league_id = e.league_id AND rp.player_id = e.player_id WHERE rp.team_id=6382797 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.0154	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 events2021 e ON rp.league_id = e.league_id AND rp.player_id = e.player_id WHERE rp.team_id=6382797 and (e.action = 4 or e.action = 5) GROUP BY dp.id ORDER BY cuenta DESC
0.0148	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 events2021 e ON rp.league_id = e.league_id AND rp.player_id = e.player_id WHERE rp.team_id=6382797 and (e.action = 3 or e.action = 4) GROUP BY dp.id ORDER BY cuenta DESC
0.0179	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 events2021 e ON rp.league_id = e.league_id AND rp.player_id = e.player_id WHERE rp.team_id=6382797 AND (e.action = 22) GROUP BY dp.id ORDER BY cuenta DESC
0.0117	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 events2021 e ON rp.league_id = e.league_id AND rp.player_id = e.player_id WHERE rp.team_id=6382797 and (e.action = 19) GROUP BY dp.id ORDER BY cuenta DESC
0.0107	SELECT dt.nameShow, dt.basealias, t.id, dt.id as dt_id FROM `teams` as t INNER JOIN `datateams` as dt ON dt.id = t.teamId WHERE league_id = 57314 ORDER BY nameShow LIMIT 100

Ponferradina

Información sobre Ponferradina

Información

Otros Datos

Internet

Opciones de envio

Datos del equipo

Información sobre el estadio

Histórico de participación

Tercera División Grupo 8

Copa del Rey

Segunda División B Grupo 1

Partidos Amistosos

Segunda División

Segunda B - Play Offs Ascenso

Regional

Copa Federación

Copa Castilla-León Grupo 2

Primera Federación Grupo 1

Segunda División - Play Offs Permanencia

Trofeo Teresa Herrera

Partidos del Ponferradina

Estadísticas

Plantilla del Ponferradina Temporada 2020/2021

Noticias del Ponferradina

Sorteadas la primera y la segunda ronda de la Copa del Rey

Casado cambia el Betis por la Ponferradina

Ponferradina: A por otra temporada cómoda en Segunda

La Ponferradina ata a Dani Suárez

El Alavés ficha a Javier Carpio

Ponferradina

Selecciona un equipo

Competiciones que juega

Segunda División

RIVALES EN Copa del Rey

RIVALES EN Segunda División