14 May 23	Finalizado	Ibiza I. Pitiusas	0 - 1	Hércules	44
07 May 23	Finalizado	Hércules	2 - 1	At. Saguntino	119
30 Abr 23	Finalizado	Hércules	0 - 1	UD Alzira	94
23 Abr 23	Finalizado	Deportivo Aragón	1 - 1	Hércules	60
16 Abr 23	Finalizado	Hércules	0 - 2	Olot	80
09 Abr 23	Finalizado	Lleida Esportiu	0 - 1	Hércules	57
02 Abr 23	Finalizado	Hércules	2 - 2	Terrassa FC	115
26 Mar 23	Finalizado	CE Manresa	0 - 0	Hércules	45
19 Mar 23	Finalizado	Hércules	1 - 0	SD Formentera	58
12 Mar 23	Finalizado	Peña Deportiva	2 - 0	Hércules	43
05 Mar 23	Finalizado	Hércules	0 - 1	Valencia Mestalla	40
26 Feb 23	Finalizado	CD Ebro	0 - 1	Hércules	50
19 Feb 23	Finalizado	Hércules	0 - 2	CD Teruel	216
11 Feb 23	Finalizado	Espanyol B	1 - 0	Hércules	73
05 Feb 23	Finalizado	Hércules	1 - 0	AE Prat	81
29 Ene 23	Finalizado	CF Badalona Futur	0 - 1	Hércules	120
22 Ene 23	Finalizado	Hércules	2 - 2	Mallorca B	83
15 Ene 23	Finalizado	Hércules	2 - 1	Ibiza I. Pitiusas	174
08 Ene 23	Finalizado	At. Saguntino	2 - 3	Hércules	167
17 Dic 22	Finalizado	UD Alzira	0 - 0	Hércules	57
11 Dic 22	Finalizado	Hércules	3 - 1	Deportivo Aragón	98
04 Dic 22	Finalizado	Olot	1 - 1	Hércules	98
27 Nov 22	Finalizado	Hércules	0 - 4	Lleida Esportiu	163
20 Nov 22	Finalizado	Terrassa FC	3 - 1	Hércules	179
06 Nov 22	Finalizado	Hércules	1 - 1	CE Manresa	100
30 Oct 22	Finalizado	SD Formentera	2 - 1	Hércules	116
23 Oct 22	Finalizado	Hércules	2 - 1	Peña Deportiva	101
16 Oct 22	Finalizado	Valencia Mestalla	3 - 1	Hércules	105
08 Oct 22	Finalizado	Hércules	0 - 0	CD Ebro	56
02 Oct 22	Finalizado	CD Teruel	1 - 0	Hércules	112
24 Sep 22	Finalizado	Hércules	2 - 1	Espanyol B	49
18 Sep 22	Finalizado	AE Prat	0 - 2	Hércules	75
10 Sep 22	Finalizado	Hércules	1 - 1	CF Badalona Futur	92
04 Sep 22	Finalizado	Mallorca B	0 - 0	Hércules	115

Partidos Amistosos »

28 Ago 22	Finalizado	UCAM Murcia	3 - 1	Hércules	17
24 Ago 22	Finalizado	Orihuela CF	3 - 0	Hércules	40
17 Ago 22	Finalizado	FC Cartagena B	1 - 1	Hércules	13
12 Ago 22	Finalizado	Alcoyano	1 - 1	Hércules	55
09 Ago 22	Finalizado	Hércules	1 - 0	CD Castellón	37
02 Ago 22	Finalizado	Hércules	1 - 0	Al-Wehda	3
~~27 Jul 22~~	Aplazado	Eldense	-	Hércules	11

Estadísticas

GOLEADORES

AMARILLAS

ROJAS

Plantilla del Hércules Temporada 2022/2023

		Edad	Altura	Peso
Portero
1	Carlos Abad	28	193	87	-	-	3
13	Iván Martínez	22	182	70	-	-	-
Defensa
12	D. Jiménez	32	183	70	-	-	1
30	D. Marin	23	-	-	-	-	2
3	F. Chacartegui	26	179	70	1	-	10
36	Jorge Galvañ	20	-	-	-	-	-
17	M. Djaló	30	192	81	-	-	-
8	Mario Gómez	29	190	82	-	-	4
32	Nicolás Ortiz	22	184	74	-	-	-
16	Retu	22	186	70	-	-	5
2	Roger Riera	29	186	75	5	2	12
4	Sergi Molina	23	189	-	-	-	-
19	Víctor Eimil	25	173	66	1	-	3
Centrocampista
22	C. Cedrés	28	172	64	-	1	4
14	César Moreno	23	183	71	1	-	8
17	José Artiles	30	169	56	1	-	3
24	M. Navarro	23	-	-	-	-	-
5	Maxi Ribero	26	165	68	-	1	7
21	Míchel	35	182	69	6	-	7
10	Sandro Toscano	28	177	76	2	-	2
20	Sergio Marcos	32	176	69	-	-	2
Delantero
15	A. Luque Jr	21	-	-	-	1	3
6	Alvarito	26	170	-	6	-	8
18	Ander Vitoria	34	184	78	-	-	1
9	Jack Harper	28	187	78	2	-	1
27	Jean Paul	23	188	-	3	2	5
11	Nico	23	175	-	-	-	-
7	Raúl Ruiz	34	178	70	1	-	9
28	Salah	22	-	-	-	-	1

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»

Pos	Equipos	Pts
1		CD Teruel	66
2		Peña Deportiva	61
3		Valencia Mestalla	58
4		CE Manresa	54
5		Espanyol B	53
6		Terrassa FC	49
7		Hércules	49
8		CF Badalona Futur	47
9		Lleida Esportiu	47
10		At. Saguntino	46
11		SD Formentera	45
12		UD Alzira	45
13		Deportivo Aragón	43
14		AE Prat	41
15		Olot	32
16		Ibiza I. Pitiusas	29
17		Mallorca B	29
18		CD Ebro	24

Pos

Equipos

Pts

	Ascenso : CD Teruel
	Playoff Ascenso : Peña Deportiva, Valencia Mestalla, CE Manresa, Espanyol B
	Playoff Descenso : Deportivo Aragón
	Descenso : AE Prat, Olot, Ibiza I. Pitiusas, Mallorca B, CD Ebro

Ascenso : CD Teruel

Playoff Ascenso : Peña Deportiva, Valencia Mestalla, CE Manresa, Espanyol B

Playoff Descenso : Deportivo Aragón

Descenso : AE Prat, Olot, Ibiza I. Pitiusas, Mallorca B, CD Ebro

USO DE MEMORIA

6,264,000 bytes

BENCHMARKS

Loading Time Base Classes	0.0029
Controller Execution Time ( Home / Category )	0.1949
Total Execution Time	0.1979

CADENA URL

/hercules/2023

GET DATOS

$_GET['/hercules/2023']

POST DATOS

No hay datos POST existentes

CONSULTAS (30)

0.0070	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 = 2023 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=1311 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=1311 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=1311 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=1311 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0019	SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=1311 AND type_rel = 2
0.0050	SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 2 AND rel.typeId = 1311 AND rel.ln = 'es' ORDER BY rel.cover_points DESC LIMIT 5
0.0027	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 (782,1090,1211,1283,1712) ORDER BY n.cover_points DESC, update_date DESC
0.0045	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.0026	(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 calendars2023 as c ON c.league_id = l.id WHERE (c.datateam1 = 1311 or c.datateam2 = 1311) AND l.year = 2023 GROUP BY cat.id) ORDER BY coefficient DESC,group_code ASC
0.0034	(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 calendars2023 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 = 2023 GROUP BY c.id) ORDER BY shedule DESC LIMIT 120
0.0025	(SELECT c.id, rel.team_id FROM leagues l INNER JOIN calendars2023 as c ON c.league_id = l.id INNER JOIN events2023 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 = 2023)
0.0038	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 (2022,2023,2024) 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 (72364,71759,71432,67507,64587) 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.0031	SELECT count(id) as num_players from rel_players WHERE league_id = 72364 AND teamId = 1311
0.0030	SELECT count(id) as num_players from rel_players WHERE league_id = 71759 AND teamId = 1311
0.0026	SELECT count(id) as num_players from rel_players WHERE league_id = 67507 AND teamId = 1311
0.0027	SELECT count(id) as num_players from rel_players WHERE league_id = 64587 AND teamId = 1311
0.0111	SELECT count(id) as num_players from rel_players WHERE league_id = 71432 AND teamId = 1311
0.0046	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 events2023 e ON e.player_id = p.id AND e.league_id = 67967 WHERE rp.league_id = 67967 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.0040	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 events2023 e ON e.player_id = p.id AND e.league_id = 67967 WHERE rp.league_id = 67967 AND rp.teamId = 1311 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0041	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 events2023 e ON e.player_id = p.id AND e.league_id = 67967 WHERE rp.league_id = 67967 AND rp.teamId = 1311 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0028	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 = 67967 AND l.year= 2023 GROUP BY rp.team_id ORDER BY l.end_date DESC LIMIT 1
0.0031	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=6519390 GROUP BY dp.id ORDER BY dp.role>0 DESC, dp.role ASC, dp.nick ASC, dp.id
0.0019	SELECT rp.player_id, rp.pj, rp.lineup FROM rel_players AS rp WHERE rp.team_id=6519390
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 events2023 e ON rp.league_id = e.league_id AND rp.player_id = e.player_id WHERE rp.team_id=6519390 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.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 events2023 e ON rp.league_id = e.league_id AND rp.player_id = e.player_id WHERE rp.team_id=6519390 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 events2023 e ON rp.league_id = e.league_id AND rp.player_id = e.player_id WHERE rp.team_id=6519390 and (e.action = 3 or e.action = 4) 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 events2023 e ON rp.league_id = e.league_id AND rp.player_id = e.player_id WHERE rp.team_id=6519390 AND (e.action = 22) GROUP BY dp.id ORDER BY cuenta DESC
0.0038	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 events2023 e ON rp.league_id = e.league_id AND rp.player_id = e.player_id WHERE rp.team_id=6519390 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

Partidos del Hércules

Estadísticas

Plantilla del Hércules Temporada 2022/2023

Noticias del Hércules

Hércules

Selecciona un equipo

Competiciones que juega

RIVALES EN Copa del Rey

RIVALES EN Segunda Federaci.