20 Jun 87	Finalizado	Xerez CD	4 - 1	UE Figueres
13 Jun 87	Finalizado	RM Castilla	3 - 0	Xerez CD
07 Jun 87	Finalizado	Real Oviedo	2 - 1	Xerez CD
31 May 87	Finalizado	Xerez CD	0 - 1	Cartagena F.C. UCAM
24 May 87	Finalizado	Barça Atlètic	2 - 1	Xerez CD
17 May 87	Finalizado	UE Figueres	3 - 1	Xerez CD
09 May 87	Finalizado	Xerez CD	3 - 4	RM Castilla
03 May 87	Finalizado	Xerez CD	1 - 1	Real Oviedo
19 Abr 87	Finalizado	Cartagena F.C. UCAM	2 - 0	Xerez CD
12 Abr 87	Finalizado	Xerez CD	0 - 1	Barça Atlètic
05 Abr 87	Finalizado	Xerez CD	0 - 1	Hércules
25 Mar 87	Finalizado	RC Deportivo	2 - 0	Xerez CD
22 Mar 87	Finalizado	Xerez CD	0 - 0	Real Oviedo
15 Mar 87	Finalizado	Cartagena F.C. UCAM	1 - 1	Xerez CD
08 Mar 87	Finalizado	Xerez CD	1 - 0	CD Castellón
01 Mar 87	Finalizado	Barça Atlètic	4 - 0	Xerez CD
22 Feb 87	Finalizado	Xerez CD	1 - 1	Sestao Sport Club
15 Feb 87	Finalizado	Bilbao Ath.	2 - 0	Xerez CD
08 Feb 87	Finalizado	Xerez CD	0 - 1	Elche
01 Feb 87	Finalizado	Rayo Vallecano	2 - 2	Xerez CD
25 Ene 87	Finalizado	Xerez CD	0 - 0	RM Castilla
18 Ene 87	Finalizado	Xerez CD	1 - 1	Celta
11 Ene 87	Finalizado	Valencia	6 - 0	Xerez CD
04 Ene 87	Finalizado	Xerez CD	1 - 0	UE Figueres
28 Dic 86	Finalizado	CD Málaga	2 - 1	Xerez CD
21 Dic 86	Finalizado	Xerez CD	2 - 1	CD Logroñés
17 Dic 86	Finalizado	Recreativo	2 - 1	Xerez CD
14 Dic 86	Finalizado	Hércules	3 - 1	Xerez CD
07 Dic 86	Finalizado	Xerez CD	1 - 2	RC Deportivo
30 Nov 86	Finalizado	CD Castellón	2 - 1	Xerez CD
23 Nov 86	Finalizado	Real Oviedo	1 - 1	Xerez CD
16 Nov 86	Finalizado	Xerez CD	2 - 2	Cartagena F.C. UCAM
02 Nov 86	Finalizado	Xerez CD	0 - 0	Barça Atlètic
25 Oct 86	Finalizado	Sestao Sport Club	3 - 0	Xerez CD
19 Oct 86	Finalizado	Xerez CD	1 - 1	Bilbao Ath.
12 Oct 86	Finalizado	Elche	5 - 0	Xerez CD
08 Oct 86	Finalizado	Xerez CD	0 - 1	Rayo Vallecano
04 Oct 86	Finalizado	RM Castilla	1 - 0	Xerez CD
28 Sep 86	Finalizado	Celta	4 - 0	Xerez CD
21 Sep 86	Finalizado	Xerez CD	0 - 0	Valencia
14 Sep 86	Finalizado	UE Figueres	3 - 0	Xerez CD
10 Sep 86	Finalizado	Xerez CD	1 - 2	CD Málaga
07 Sep 86	Finalizado	CD Logroñés	2 - 0	Xerez CD
30 Ago 86	Finalizado	Xerez CD	2 - 0	Recreativo

Copa del Rey »

17 Sep 86

Finalizado

RB Linense

1 - 1

Xerez CD

Estadísticas

GOLEADORES

AMARILLAS

Bernal11

ROJAS

Suárez3

Torres2

Merayo1

Moreno1

Flores1

Pozo1

Bernal1

Plantilla del Xerez CD Temporada 1986/1987

		Edad	Altura	Peso
Portero
	Navarro	59	-	-	-	-	1
	Osma	62	-	-	-	-	-
Defensa
	Bernal	57	178	73	-	1	11
	Botubot	68	184	81	3	-	4
	Pablo Gómez	58	-	-	-	-	1
	Perdigones	66	-	-	-	-	2
	Rivas	68	186	79	2	-	4
	Rosado	62	173	68	-	-	5
	Suárez	60	177	72	-	3	5
	Valencia	70	-	-	-	-	3
Centrocampista
	Merayo	63	-	-	-	1	-
	Moreno	60	-	-	1	1	-
	Poyatos	58	182	78	2	-	6
	Pozo	69	178	75	-	1	6
	Queco	59	175	68	-	-	5
	Tomás	61	-	-	1	-	1
	Torres	60	170	67	3	2	4
	Verde	59	179	77	4	-	-
Delantero
	Adolfo	65	168	65	4	-	2
	Boro	63	179	73	7	-	6
	Correa	61	169	66	-	-	2
	Ermen Benítez	62	-	-	1	-	1
	Flores	62	-	-	3	1	7
	Ruiz-Mateos	60	-	-	1	-	-
	Selma	58	-	-	-	-	-
	Taboada	-	-	-	-	-	-

Noticias del Xerez CD

Ver últimas noticias

Radicales del Cádiz y el Xerez, entre los detenidos por la reyerta del domingo

BeSoccer - Viernes, 09 Octubre 2015

0 1.044

La Policía Nacional ha elevado a catorce las personas detenidas e imputadas en relación a los altercados del pasado fin de semana entre el Cádiz B y el Xerez, entre los que se encuentran integrantes de "Brigadas Amarillas" y "Hools XCD", ultras de ambos equipos.

Doce detenidos entre los hinchas de Cádiz y Xerez implicados en la tangana del domingo

BeSoccer - Viernes, 09 Octubre 2015

0 866

Van doce, pero el número podría incrementarse con el paso de las horas. Se trata de los implicados en la multitudinaria pelea entre aficionados del Cádiz y el Xerez ocurrida el pasado domingo 4 de octubre, previa al partido que enfrentó a los jerezanos con el filial cadista.

La Policía identifica a 21 hinchas del Cádiz y el Xerez tras la pelea

BeSoccer - Lunes, 05 Octubre 2015

3 1.521

La Policía Nacional tiene identificadas a veintiuna personas como participantes en los altercados con varios heridos de este domingo entre seguidores radicales del Cádiz B y el Xerez CD antes de un partido de Primera Andaluza.

Una pelea entre los hinchas del Cadiz B y el Xerez deja varios heridos

BeSoccer - Domingo, 04 Octubre 2015

0 2.199

Varios aficionados han resultado heridos este domingo durante una pelea entre seguidores radicales del Cádiz B y del Xerez CD, antes del partido de Primera Andaluza que enfrentó este domingo a ambos equipos en la Ciudad Deportiva de El Rosal, en Puerto Real (Cádiz), han informado a Efe fuentes policiales.

Desestimadas las querellas del Xerez y la directora de la Agencia Tributaria contra Tebas

BeSoccer - Martes, 22 Septiembre 2015

0 709

Las querellas interpuestas por la directora del Departamento de Recaudación de la Agencia Tributaria, Soledad García, y por el Xerez CD contra el presidente de la Liga de Fútbol Profesional (LFP), Javier Tebas, han sido desestimadas y archivadas definitivamente.

Ver más noticias del equipo»

Competiciones que juega

Segunda División

Pos	Equipos		Pts
1		Valencia	57
2		CD Logroñés	54
3		Celta	54
4		Sestao Sport Club	52
5		RC Deportivo	51
6		Recreativo	50
7		Elche	48
8		CD Castellón	44
9		UE Figueres	42
10		Barça Atlètic	42
11		Cartagena F.C. UCAM	42
12		Rayo Vallecano	41
13		Hércules	41
14		Real Oviedo	40
15		CD Málaga	40
16		Bilbao Ath.	39
17		RM Castilla	33
18		Xerez CD	22

RIVALES EN Copa del Rey

RIVALES EN Segunda División

USO DE MEMORIA

6,204,256 bytes

BENCHMARKS

Loading Time Base Classes	0.0022
Controller Execution Time ( Home / Category )	0.4919
Total Execution Time	0.4941

CADENA URL

/Xerez/1987

GET DATOS

$_GET['/Xerez/1987']

POST DATOS

No hay datos POST existentes

CONSULTAS (27)

0.0105	SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=2767 AND type_rel = 2
0.0108	SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 2 AND rel.typeId = 2767 AND rel.ln = 'es' ORDER BY rel.cover_points DESC LIMIT 5
0.0110	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 (13312,15412,15557,16230,16357) ORDER BY n.cover_points DESC, update_date DESC
0.0121	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 = '2767' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0256	(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 calendars1987 as c ON c.league_id = l.id WHERE (c.datateam1 = 2767 or c.datateam2 = 2767) AND l.year = 1987 GROUP BY cat.id) ORDER BY coefficient DESC,group_code ASC
0.0266	(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 calendars1987 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 = 2767 or c.datateam2 = 2767) AND l.year = 1987 GROUP BY c.id) ORDER BY shedule DESC LIMIT 120
0.0349	(SELECT c.id, rel.team_id FROM leagues l INNER JOIN calendars1987 as c ON c.league_id = l.id INNER JOIN events1987 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 = 2767 or c.datateam2 = 2767) AND l.year = 1987)
0.0117	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=2767 AND l.year in (1986,1987,1988) ORDER BY l.id DESC, l.year DESC ;
0.0106	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 (22237,21897,5484) 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.0110	SELECT count(id) as num_players from rel_players WHERE league_id = 5484 AND teamId = 2767
0.0113	SELECT count(id) as num_players from rel_players WHERE league_id = 22237 AND teamId = 2767
0.0120	SELECT count(id) as num_players from rel_players WHERE league_id = 21897 AND teamId = 2767
0.0113	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 = '2767' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0105	SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '2767' and rp.type = 4
0.0118	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 = '2767' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0105	SELECT count(id_content) as cuenta FROM `rel_videos` as rp WHERE rp.id_content = '2767' and rp.type = 4
0.0120	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 events1987 e ON e.player_id = p.id AND e.league_id = 5483 WHERE rp.league_id = 5483 AND rp.teamId = 2767 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.0118	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 events1987 e ON e.player_id = p.id AND e.league_id = 5483 WHERE rp.league_id = 5483 AND rp.teamId = 2767 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0118	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 events1987 e ON e.player_id = p.id AND e.league_id = 5483 WHERE rp.league_id = 5483 AND rp.teamId = 2767 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0110	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 = 2767 AND rp.league_id = 5483 AND l.year= 1987 GROUP BY rp.team_id ORDER BY l.end_date DESC LIMIT 1
0.0113	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=95743 GROUP BY dp.id ORDER BY dp.role>0 DESC, dp.role ASC, dp.nick ASC, dp.id
0.0106	SELECT rp.player_id, rp.pj, rp.lineup FROM rel_players AS rp WHERE rp.team_id=95743
0.0118	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 events1987 e ON rp.league_id = e.league_id AND rp.player_id = e.player_id WHERE rp.team_id=95743 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.0112	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 events1987 e ON rp.league_id = e.league_id AND rp.player_id = e.player_id WHERE rp.team_id=95743 and (e.action = 4 or e.action = 5) GROUP BY dp.id ORDER BY cuenta DESC
0.0115	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 events1987 e ON rp.league_id = e.league_id AND rp.player_id = e.player_id WHERE rp.team_id=95743 and (e.action = 3 or e.action = 4) GROUP BY dp.id ORDER BY cuenta DESC
0.0112	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 events1987 e ON rp.league_id = e.league_id AND rp.player_id = e.player_id WHERE rp.team_id=95743 AND (e.action = 22) GROUP BY dp.id ORDER BY cuenta DESC
0.0112	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 events1987 e ON rp.league_id = e.league_id AND rp.player_id = e.player_id WHERE rp.team_id=95743 and (e.action = 19) GROUP BY dp.id ORDER BY cuenta DESC


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

Xerez CD

Información sobre Xerez CD

Información

Otros Datos

Internet

Opciones de envio

Datos del equipo

Información sobre el estadio

Histórico de participación

Partidos del Xerez CD

Estadísticas

Plantilla del Xerez CD Temporada 1986/1987

Noticias del Xerez CD

Xerez CD

Selecciona un equipo

Competiciones que juega

RIVALES EN Copa del Rey

RIVALES EN Segunda División