~~17 May 20~~	Aplazado	Ejea	-	Hércules	17
~~10 May 20~~	Aplazado	Hércules	-	Gimnàstic Tarragona	6
~~03 May 20~~	Aplazado	Badalona	-	Hércules	0
~~26 Abr 20~~	Aplazado	Hércules	-	Espanyol B	0
~~19 Abr 20~~	Aplazado	Olot	-	Hércules	1
~~12 Abr 20~~	Aplazado	Hércules	-	CF La Nucía	0
~~05 Abr 20~~	Aplazado	Valencia Mestalla	-	Hércules	0
~~29 Mar 20~~	Aplazado	Hércules	-	CD Castellón	3
~~22 Mar 20~~	Aplazado	Lleida Esportiu	-	Hércules	2
~~15 Mar 20~~	Aplazado	Hércules	-	UE Cornellà	60
08 Mar 20	Finalizado	CD Ebro	0 - 0	Hércules	121
01 Mar 20	Finalizado	Hércules	0 - 0	FC Andorra	115
22 Feb 20	Finalizado	Barça Atlètic	0 - 0	Hércules	126
16 Feb 20	Finalizado	Hércules	0 - 0	CF Badalona Futur	75
09 Feb 20	Finalizado	Orihuela CF	1 - 0	Hércules	105
02 Feb 20	Finalizado	CE Sabadell	1 - 2	Hércules	367
26 Ene 20	Finalizado	Hércules	1 - 3	At. Levante	230
18 Ene 20	Finalizado	Villarreal B	1 - 0	Hércules	98
12 Ene 20	Finalizado	Hércules	2 - 2	AE Prat	70
04 Ene 20	Finalizado	Hércules	2 - 2	Ejea	118
22 Dic 19	Finalizado	Gimnàstic Tarragona	0 - 2	Hércules	199
14 Dic 19	Finalizado	Hércules	1 - 2	Badalona	133
08 Dic 19	Finalizado	Espanyol B	3 - 2	Hércules	182
01 Dic 19	Finalizado	Hércules	0 - 0	Olot	111
24 Nov 19	Finalizado	CF La Nucía	3 - 0	Hércules	215
17 Nov 19	Finalizado	Hércules	1 - 1	Valencia Mestalla	121
10 Nov 19	Finalizado	CD Castellón	1 - 0	Hércules	440
03 Nov 19	Finalizado	Hércules	1 - 1	Lleida Esportiu	249
27 Oct 19	Finalizado	UE Cornellà	0 - 1	Hércules	118
20 Oct 19	Finalizado	Hércules	3 - 0	CD Ebro	287
13 Oct 19	Finalizado	FC Andorra	2 - 1	Hércules	306
06 Oct 19	Finalizado	Hércules	4 - 1	Barça Atlètic	450
28 Sep 19	Finalizado	CF Badalona Futur	2 - 1	Hércules	526
22 Sep 19	Finalizado	Hércules	1 - 3	Orihuela CF	311
15 Sep 19	Finalizado	Hércules	0 - 2	CE Sabadell	254
07 Sep 19	Finalizado	At. Levante	1 - 0	Hércules	184
01 Sep 19	Finalizado	Hércules	1 - 2	Villarreal B	152
24 Ago 19	Finalizado	AE Prat	1 - 1	Hércules	367

Partidos Amistosos »

17 Ago 19	Finalizado	Hércules	0 - 0	UCAM Murcia	31
14 Ago 19	Finalizado	FC Cartagena	1 - 2	Hércules	52
07 Ago 19	Finalizado	Yeclano Deportivo	0 - 0	Hércules	28
31 Jul 19	Finalizado	AC Torrellano	1 - 5	Hércules	31

Estadísticas

AMARILLAS

Plantilla del Hércules Temporada 2019/2020

		Edad	Altura	Peso
Portero
1	I. Falcón	40	182	78	-	-	-
13	Rubén Ualoloca	26	180	72	-	-	-
Defensa
21	Álvaro Pérez	28	183	77	-	-	1
	José Solbes	24	184	-	-	-	-
3	Nani	26	171	60	-	-	-
4	Pablo Iñiguez	30	183	72	-	-	1
	Pipe	31	175	66	-	-	-
18	Rulo	28	168	65	-	-	-
	Samuel Llorca	39	187	83	-	-	-
16	V. Olmedo	25	170	60	-	-	-
Centrocampista
8	Diego Benito	35	176	70	-	-	1
6	Fran Miranda	36	190	84	-	-	1
15	J. Alvarado	24	180	76	-	-	-
	Pedro Torres	25	181	72	-	-	-
19	T. Quintero	25	188	80	-	-	-
12	Yeray	36	181	78	-	-	-
Delantero
20	A. Alfaro	37	173	68	-	-	-
	Benja	36	187	83	-	-	-
22	Borja Martínez	30	177	70	-	-	-
10	Carlos Martínez	37	185	74	-	-	1
28	Ez Abde	22	177	73	-	-	-
	Jesús Alfaro	32	170	64	-	-	-
9	Jona	35	183	80	-	-	-
17	Moha Traoré	29	187	88	-	-	-
	Tarí	27	-	-	-	-	-

Noticias del Hércules

Ver últimas noticias

Futuro incierto de Rafita y David González con el Hércules

BeSoccer - Lunes, 06 Julio 2015

0 237

Ambos han sido jugadores destacados en el Hércules durante la temporada pasada.

Connor deja el filial del Mallorca y se va al Hércules

BeSoccer - Jueves, 02 Julio 2015

0 398

El nuevo jugador del Hércules tendrá que competir por un puesto en el once inicial con Paco Peña, capitán de la plantilla.

Chema renueva con el Hércules por un año con opción a otro

BeSoccer - Miércoles, 01 Julio 2015

0 134

El guardameta ha firmado su renovación con el Hércules por una temporada con opción a una segunda, en caso de ascenso del conjunto alicantino a Segunda División.

El Hércules se hace con Yeray, del Guijuelo

BeSoccer - Martes, 30 Junio 2015

0 291

El club alicantino alcanza un acuerdo con Paco Peña y Carlos Indiano para su renovación y cierra la contratación del mediocentro Yeray González.

El Hércules felicita al Bilbao Athletic por su ascenso

BeSoccer - Domingo, 28 Junio 2015

0 325

Mediante sus cuentas en redes sociales, el conjunto alicantino ha felicitado al vasco

Ver más noticias del equipo»

USO DE MEMORIA

6,117,920 bytes

BENCHMARKS

Loading Time Base Classes	0.0023
Controller Execution Time ( Home / Category )	0.6292
Total Execution Time	0.6315

CADENA URL

/Hercules/2020

GET DATOS

$_GET['/Hercules/2020']

POST DATOS

No hay datos POST existentes

CONSULTAS (30)

0.0176	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 = 'Hercules' AND l.year = 2020 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.0147	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=1311 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0145	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=1311 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0146	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=1311 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0146	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=1311 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0169	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 = '1311' AND l.year = 2020 ORDER BY l.year DESC,cat.coefficient DESC
0.0156	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 = '1311' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0146	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 = 50267 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0150	(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 = 1311 or c.datateam2 = 1311) AND l.year = 2020 GROUP BY cat.id) ORDER BY coefficient DESC,group_code ASC
0.0159	(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 = 1311 or c.datateam2 = 1311) AND l.year = 2020 GROUP BY c.id) ORDER BY shedule DESC LIMIT 120
0.0153	(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 = 1311 or c.datateam2 = 1311) AND l.year = 2020)
0.0199	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=1311 AND l.year in (2019,2020,2021) ORDER BY l.id DESC, l.year DESC ;
0.0149	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 (61739,58610,56547,51355,50251,49760) 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.0153	SELECT count(id) as num_players from rel_players WHERE league_id = 58610 AND teamId = 1311
0.0155	SELECT count(id) as num_players from rel_players WHERE league_id = 51355 AND teamId = 1311
0.0151	SELECT count(id) as num_players from rel_players WHERE league_id = 49760 AND teamId = 1311
0.0151	SELECT count(id) as num_players from rel_players WHERE league_id = 61739 AND teamId = 1311
0.0239	SELECT count(id) as num_players from rel_players WHERE league_id = 56547 AND teamId = 1311
0.0150	SELECT count(id) as num_players from rel_players WHERE league_id = 50251 AND teamId = 1311
0.0162	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 = 51355 WHERE rp.league_id = 51355 AND rp.teamId = 1311 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.0158	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 = 51355 WHERE rp.league_id = 51355 AND rp.teamId = 1311 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0150	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 = 51355 WHERE rp.league_id = 51355 AND rp.teamId = 1311 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0161	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 = 1311 AND rp.league_id = 51355 AND l.year= 2020 GROUP BY rp.team_id ORDER BY l.end_date DESC LIMIT 1
0.0152	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=6313799 GROUP BY dp.id ORDER BY dp.role>0 DESC, dp.role ASC, dp.nick ASC, dp.id
0.0145	SELECT rp.player_id, rp.pj, rp.lineup FROM rel_players AS rp WHERE rp.team_id=6313799
0.0153	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=6313799 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.0162	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=6313799 and (e.action = 4 or e.action = 5) GROUP BY dp.id ORDER BY cuenta DESC
0.0168	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=6313799 and (e.action = 3 or e.action = 4) GROUP BY dp.id ORDER BY cuenta DESC
0.0158	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=6313799 AND (e.action = 22) GROUP BY dp.id ORDER BY cuenta DESC
0.0192	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=6313799 and (e.action = 19) GROUP BY dp.id ORDER BY cuenta DESC

Hércules

Información sobre Hércules

Información

Otros Datos

Internet

Opciones de envio

Datos del equipo

Información sobre el estadio

Histórico de participación

Copa del Rey

Segunda División

Primera División

Segunda División B Grupo 3

Partidos Amistosos

Segunda B - Play Offs Ascenso

Tercera División Grupo 6

Segunda - Play Offs Ascenso

Segunda División - Play Offs Permanencia

Segunda Federación Grupo 3

Copa de la Liga de España

Copa de la Liga de Segunda División

Amistosos Selecciones No Oficiales

Copa Federación

Segunda Federación - Play Offs Ascenso

Segunda B - 2ª Fase Primera División RFEF Grupo 3

Trofeo Naranja

Partidos del Hércules

Estadísticas

Plantilla del Hércules Temporada 2019/2020

Noticias del Hércules

Futuro incierto de Rafita y David González con el Hércules

Connor deja el filial del Mallorca y se va al Hércules

Chema renueva con el Hércules por un año con opción a otro

El Hércules se hace con Yeray, del Guijuelo

El Hércules felicita al Bilbao Athletic por su ascenso

Hércules

Selecciona un equipo

Competiciones que juega

RIVALES EN Copa del Rey

RIVALES EN Segunda División.