18 May 14	Finalizado	Sevilla	3 - 1	Elche	292
11 May 14	Finalizado	Elche	0 - 0	Barcelona	888
03 May 14	Finalizado	Málaga	0 - 1	Elche	233
25 Abr 14	Finalizado	Elche	1 - 1	Levante	401
18 Abr 14	Finalizado	Atlético	2 - 0	Elche	875
13 Abr 14	Finalizado	Valencia	2 - 1	Elche	345
06 Abr 14	Finalizado	Elche	1 - 0	Getafe	404
30 Mar 14	Finalizado	Villarreal	1 - 1	Elche	323
25 Mar 14	Finalizado	Elche	0 - 0	Athletic	680
22 Mar 14	Finalizado	Granada	1 - 0	Elche	274
16 Mar 14	Finalizado	Elche	0 - 0	Real Betis	403
09 Mar 14	Finalizado	Espanyol	3 - 1	Elche	137
01 Mar 14	Finalizado	Elche	1 - 0	Celta	183
22 Feb 14	Finalizado	Real Madrid	3 - 0	Elche	942
14 Feb 14	Finalizado	Elche	0 - 0	Osasuna	155
09 Feb 14	Finalizado	Real Valladolid	2 - 2	Elche	334
02 Feb 14	Finalizado	Elche	1 - 0	Almería	169
27 Ene 14	Finalizado	Real Sociedad	4 - 0	Elche	408
18 Ene 14	Finalizado	Elche	2 - 0	Rayo Vallecano	102
11 Ene 14	Finalizado	Elche	1 - 1	Sevilla	306
05 Ene 14	Finalizado	Barcelona	4 - 0	Elche	703
20 Dic 13	Finalizado	Elche	0 - 1	Málaga	161
13 Dic 13	Finalizado	Levante	2 - 1	Elche	100
30 Nov 13	Finalizado	Elche	0 - 2	Atlético	274
24 Nov 13	Finalizado	Elche	2 - 1	Valencia	277
09 Nov 13	Finalizado	Getafe	1 - 1	Elche	69
04 Nov 13	Finalizado	Elche	0 - 1	Villarreal	162
31 Oct 13	Finalizado	Athletic	2 - 2	Elche	325
26 Oct 13	Finalizado	Elche	0 - 1	Granada	423
20 Oct 13	Finalizado	Real Betis	1 - 2	Elche	140
05 Oct 13	Finalizado	Elche	2 - 1	Espanyol	173
29 Sep 13	Finalizado	Celta	0 - 1	Elche	161
25 Sep 13	Finalizado	Elche	1 - 2	Real Madrid	814
20 Sep 13	Finalizado	Osasuna	2 - 1	Elche	259
16 Sep 13	Finalizado	Elche	0 - 0	Real Valladolid	132
30 Ago 13	Finalizado	Almería	2 - 2	Elche	310
24 Ago 13	Finalizado	Elche	1 - 1	Real Sociedad	322
19 Ago 13	Finalizado	Rayo Vallecano	3 - 0	Elche	383

Copa del Rey »

	17 Dic 13	Finalizado	Elche	0 - 1	Villarreal			66
	06 Dic 13	Finalizado	Villarreal	2 - 2	Elche			93

Partidos Amistosos »

10 Ago 13	Finalizado	Real Murcia	0 - 1	Elche	203
03 Ago 13	Finalizado	Hércules	1 - 1	Elche	12
31 Jul 13	Finalizado	Elche	1 - 3	Benfica	21
27 Jul 13	Finalizado	Elche	2 - 1	Real Valladolid	11
21 Jul 13	Finalizado	Elche	4 - 1	Ontinyent CF	14

Estadísticas

GOLEADORES

AMARILLAS

ROJAS

Toño1

Cisma1

Plantilla del Elche Temporada 2013/2014

		Edad	Altura	Peso
Portero
31	Chiri	31	178	68	-	-	-
1	Manu Herrera	42	182	75	-	-	4
	Marc Martínez	34	186	72	-	-	-
13	Toño	44	182	81	-	1	-
Defensa
3	A. Botía	35	188	80	-	1	15
19	C. Sapunaru	40	187	81	1	2	6
	Charlie Dean	30	182	76	-	-	-
23	Cisma	42	184	78	-	1	9
2	Damián Suárez	35	173	68	1	2	13
21	Edu Albacar	44	177	70	3	-	4
31	José Carlos	33	-	-	-	-	-
4	Lombán	36	185	79	1	-	3
	Nacho Porcar	31	182	71	-	-	-
18	Pelegrín	45	184	81	-	-	3
Centrocampista
24	C. Sánchez	38	182	82	-	-	9
15	Carles Gil	31	171	69	1	-	2
10	Javi Flores	38	170	64	-	-	-
17	Javi Márquez	37	174	71	2	-	9
8	Mantecón	43	175	75	-	-	2
5	Rivera	46	170	68	-	-	3
6	Rubén Pérez	35	178	73	-	-	13
30	Samu	30	172	70	-	-	-
Delantero
7	Aarón	35	170	69	1	-	6
	Álvaro Giménez	32	183	80	-	-	-
28	C. Herrera	33	182	85	3	-	2
11	Coro	41	171	65	6	-	8
16	Fidel	34	180	72	2	-	3
25	Garry Rodrigues	33	173	71	1	-	-
1	Manu Del Moral	40	186	77	2	-	3
9	R. Boakye	31	185	80	6	-	2

Noticias del Elche

Ver últimas noticias

"Puado y Braithwaite llevan 30 goles, un 80% de los que llevamos nosotros"

BeSoccer - Viernes, 26 Abril 2024

2 2.245

Sebastián Beccacece admite que el partido contra el Espanyol será duro. "Entre Puado y Braithwaite suman 30 goles, el 80% de los que suma nuestro equipo", comentó. Eso sí, cree que aunque "en goles y en eficacia" no tengan buenos números, "en todo lo demás sí".

El Elche le da al 'on' para el 'play off'

BeSoccer - Sábado, 20 Abril 2024

0 485

El Elche se acordó de cómo se ganaba tras 4 jornadas sin triunfos. Los de Beccacece se impusieron al Sporting por 2-1 en un partido en el que no solo le arrebató los puntos al rival. Los del Martínez Valero se aúpan a la 5ª plaza que tenían los asturianos y se aseguran el 'play off', al menos, durante una semana.

Empate incómodo

BeSoccer - Domingo, 14 Abril 2024

0 1.753

El Real Zaragoza y el Elche firmaron un empate 1-1 que no termina de beneficiar a ninguna de las dos partes. El conjunto local continúa más cerca del descenso de lo que le gustaría y el visitante se queda con las ganas de auparse a la 6ª plaza del campeonato, que es la más baja que da acceso al 'play off' de ascenso a Primera. Los goles fueron de Mario Gaspar e Iván Azón, en este orden.

El asalto al Martínez Valero

BeSoccer - Sábado, 06 Abril 2024

2 2.237

El Oviedo se llevó los tres puntos en su visita al Martínez Valero ante el Elche (0-2). Colombatto abrió la lata en el minuto 14 del partido, mientras que Paulino, en el tiempo añadido, certificó el triunfo para los pupilos de Luis Miguel Carrión.

Ferrol supera el objetivo virtual y empieza a pensar en el sueño real

BeSoccer - Domingo, 31 Marzo 2024

0 1.547

El Racing de Ferrol selló la permanencia virtual en Segunda División al ganar por la mínima al Elche en la jornada 33 de la categoría de plata. Un gol de Nico Serrano a pase de Nacho Sánchez bastó para rendir a los franjiverdes, que conocen así a un nuevo rival en la pugna por el 'play off' de ascenso a Primera e incluso por los dos boletos directos, si bien el del Leganés, líder, es más lejano que el que sostiene, de momento, el Eibar desde la 2ª plaza.

Ver más noticias del equipo»

Competiciones que juega

Primera División

Pos	Equipos		Pts
1		Atlético	90
2		Barcelona	87
3		Real Madrid	87
4		Athletic	70
5		Sevilla	63
6		Villarreal	59
7		Real Sociedad	59
8		Valencia	49
9		Celta	49
10		Levante	48
11		Málaga	45
12		Rayo Vallecano	43
13		Getafe	42
14		Espanyol	42
15		Granada	41
16		Elche	40
17		Almería	40
18		Osasuna	39
19		Real Valladolid	36
20		Real Betis	25

	Champions League : Atlético, Barcelona, Real Madrid
	Previa de Champions : Athletic
	Europa League : Sevilla, Villarreal, Real Sociedad
	Descenso : Osasuna, Real Valladolid, Real Betis

RIVALES EN Copa del Rey

RIVALES EN Primera División

USO DE MEMORIA

6,319,776 bytes

BENCHMARKS

Loading Time Base Classes	0.0020
Controller Execution Time ( Home / Category )	0.3880
Total Execution Time	0.3900

CADENA URL

/Elche/2014

GET DATOS

$_GET['/Elche/2014']

POST DATOS

No hay datos POST existentes

CONSULTAS (33)

0.0036	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 = 'Elche' AND l.year = 2014 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.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=975 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
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=975 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
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=975 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
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=975 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0023	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 = 2401
0.0019	SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=975 AND type_rel = 2
0.0179	SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 2 AND rel.typeId = 975 AND rel.ln = 'es' ORDER BY rel.cover_points DESC LIMIT 5
0.0022	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 (1312694,1311805,1310966,1309597,1308754) ORDER BY n.cover_points DESC, update_date DESC
0.0032	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 = '975' AND l.year = 2014 ORDER BY l.year DESC,cat.coefficient DESC
0.0032	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 = '975' 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 = 2401 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 calendars2014 as c ON c.league_id = l.id WHERE (c.datateam1 = 975 or c.datateam2 = 975) AND l.year = 2014 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 calendars2014 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 = 975 or c.datateam2 = 975) AND l.year = 2014 GROUP BY c.id) ORDER BY shedule DESC LIMIT 120
0.0026	(SELECT c.id, rel.team_id FROM leagues l INNER JOIN calendars2014 as c ON c.league_id = l.id INNER JOIN events2014 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 = 975 or c.datateam2 = 975) AND l.year = 2014)
0.0031	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=975 AND l.year in (2013,2014,2015) 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 (3992,3804,3775,1901) 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.0025	SELECT count(id) as num_players from rel_players WHERE league_id = 3775 AND teamId = 975
0.0023	SELECT count(id) as num_players from rel_players WHERE league_id = 1901 AND teamId = 975
0.0026	SELECT count(id) as num_players from rel_players WHERE league_id = 3992 AND teamId = 975
0.0063	SELECT count(id) as num_players from rel_players WHERE league_id = 3804 AND teamId = 975
0.0028	SELECT t.,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff FROM* `tables2014` 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 = 2401 AND t.round = 38 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
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 events2014 e ON e.player_id = p.id AND e.league_id = 2401 WHERE rp.league_id = 2401 AND rp.teamId = 975 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 events2014 e ON e.player_id = p.id AND e.league_id = 2401 WHERE rp.league_id = 2401 AND rp.teamId = 975 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0028	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 events2014 e ON e.player_id = p.id AND e.league_id = 2401 WHERE rp.league_id = 2401 AND rp.teamId = 975 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0023	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 = 975 AND rp.league_id = 2401 AND l.year= 2014 GROUP BY rp.team_id ORDER BY l.end_date DESC LIMIT 1
0.0024	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=50633 GROUP BY dp.id ORDER BY dp.role>0 DESC, dp.role ASC, dp.nick ASC, dp.id
0.0018	SELECT rp.player_id, rp.pj, rp.lineup FROM rel_players AS rp WHERE rp.team_id=50633
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 events2014 e ON rp.league_id = e.league_id AND rp.player_id = e.player_id WHERE rp.team_id=50633 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.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 events2014 e ON rp.league_id = e.league_id AND rp.player_id = e.player_id WHERE rp.team_id=50633 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 events2014 e ON rp.league_id = e.league_id AND rp.player_id = e.player_id WHERE rp.team_id=50633 and (e.action = 3 or e.action = 4) GROUP BY dp.id ORDER BY cuenta DESC
0.0026	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 events2014 e ON rp.league_id = e.league_id AND rp.player_id = e.player_id WHERE rp.team_id=50633 AND (e.action = 22) GROUP BY dp.id ORDER BY cuenta DESC
0.0031	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 events2014 e ON rp.league_id = e.league_id AND rp.player_id = e.player_id WHERE rp.team_id=50633 and (e.action = 19) GROUP BY dp.id ORDER BY cuenta DESC

Resultados de Fútbol

Elche

Información sobre Elche

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

Tercera División Grupo 10

Partidos Amistosos

Segunda División B Grupo 3

Segunda B - Play Offs Ascenso

Segunda - Play Offs Ascenso

Segunda División - Play Offs Permanencia

Copa de la Liga de Segunda División

Trofeo Joan Gamper

Copa de la Liga de España

Partidos del Elche

Estadísticas

Plantilla del Elche Temporada 2013/2014

Noticias del Elche

"Puado y Braithwaite llevan 30 goles, un 80% de los que llevamos nosotros"

El Elche le da al 'on' para el 'play off'

Empate incómodo

El asalto al Martínez Valero

Ferrol supera el objetivo virtual y empieza a pensar en el sueño real

Elche

Selecciona un equipo

Competiciones que juega

Primera División

RIVALES EN Copa del Rey

RIVALES EN Primera División


	¿Has detectado algún error en la web? x Tipo de incidencia ¿Qué ocurre? Deja tu correo si quieres que te contactemos