03 Dic 80	Finalizado	SD Compostela	1 - 2	Ponferradina
19 Nov 80	Finalizado	Ponferradina	3 - 3	SD Compostela
01 Oct 80	Finalizado	SD Compostela	1 - 0	CD Lugo
17 Sep 80	Finalizado	CD Lugo	1 - 1	SD Compostela

Segunda División B »

24 May 81	Finalizado	SD Compostela	2 - 0	RSD Alcalá
17 May 81	Finalizado	Sestao Sport Club	2 - 0	SD Compostela
10 May 81	Finalizado	SD Compostela	1 - 0	Gimnástica Arandina
03 May 81	Finalizado	Bilbao Ath.	3 - 1	SD Compostela
26 Abr 81	Finalizado	SD Compostela	3 - 0	Tenerife
19 Abr 81	Finalizado	Huesca	3 - 1	SD Compostela
12 Abr 81	Finalizado	SD Compostela	2 - 2	RC Deportivo
05 Abr 81	Finalizado	Zamora	0 - 1	SD Compostela
29 Mar 81	Finalizado	SD Compostela	2 - 1	Langreo
22 Mar 81	Finalizado	AD Torrejón CF	2 - 1	SD Compostela
15 Mar 81	Finalizado	SD Compostela	1 - 0	Pontevedra
08 Mar 81	Finalizado	SD Compostela	1 - 0	Mirandés
01 Mar 81	Finalizado	Real Sociedad B	1 - 1	SD Compostela
22 Feb 81	Finalizado	SD Compostela	2 - 0	Las Palmas At.
15 Feb 81	Finalizado	CD Logroñés	2 - 1	SD Compostela
08 Feb 81	Finalizado	SD Compostela	0 - 1	Celta
01 Feb 81	Finalizado	Racing Ferrol	1 - 0	SD Compostela
25 Ene 81	Finalizado	SD Compostela	2 - 1	Cultural Leonesa
18 Ene 81	Finalizado	Ensidesa	2 - 2	SD Compostela
11 Ene 81	Finalizado	RSD Alcalá	1 - 1	SD Compostela
04 Ene 81	Finalizado	SD Compostela	1 - 0	Sestao Sport Club
28 Dic 80	Finalizado	Gimnástica Arandina	0 - 0	SD Compostela
21 Dic 80	Finalizado	SD Compostela	3 - 0	Bilbao Ath.
14 Dic 80	Finalizado	Tenerife	0 - 0	SD Compostela
07 Dic 80	Finalizado	SD Compostela	0 - 0	Huesca
30 Nov 80	Finalizado	RC Deportivo	1 - 0	SD Compostela
23 Nov 80	Finalizado	SD Compostela	1 - 0	Zamora
16 Nov 80	Finalizado	Langreo	1 - 1	SD Compostela
09 Nov 80	Finalizado	SD Compostela	1 - 0	AD Torrejón CF
02 Nov 80	Finalizado	Pontevedra	1 - 1	SD Compostela
26 Oct 80	Finalizado	Mirandés	1 - 0	SD Compostela
19 Oct 80	Finalizado	SD Compostela	1 - 0	Real Sociedad B
12 Oct 80	Finalizado	Las Palmas At.	2 - 0	SD Compostela
05 Oct 80	Finalizado	SD Compostela	0 - 2	CD Logroñés
28 Sep 80	Finalizado	Celta	4 - 1	SD Compostela
21 Sep 80	Finalizado	SD Compostela	1 - 0	Racing Ferrol
14 Sep 80	Finalizado	Cultural Leonesa	0 - 0	SD Compostela
07 Sep 80	Finalizado	SD Compostela	1 - 0	Ensidesa

Estadísticas

GOLEADORES

AMARILLAS

Plantilla del SD Compostela Temporada 1980/1981

		Edad	Altura	Peso
Portero
	Dosi	74	-	-	-	-	-
	Mallo	64	182	77	-	-	-
Defensa
	Berto	69	-	-	-	-	2
	Castelo	-	-	-	-	-	-
	Castillo	66	-	-	1	-	-
	Marque	68	-	-	-	-	1
	T. Reñones	63	171	70	-	-	-
	Toño	65	-	-	-	-	-
Centrocampista
	Chanel	-	-	-	-	-	-
	Chelis	68	-	-	1	-	-
	Jorge	69	-	-	-	-	-
	Ricoy	-	-	-	-	-	-
	Varela	68	-	-	-	-	-
Delantero
	Cubeiro	-	-	-	-	-	-
	Ino	-	-	-	-	-	-
	Insúa	64	-	-	-	-	-
	Millares	-	-	-	2	-	-
	Prol	64	-	-	2	-	-
	Sanromán	71	168	68	-	-	1

Noticias del SD Compostela

Ver últimas noticias

Compostela, Hércules, Murcia, Racing y Recreativo, eliminados en 1ª ronda

BeSoccer - Miércoles, 02 Septiembre 2015

0 959

Compostela, Hércules, Murcia, Racing y Recreativo han quedado eliminados de la Copa del Rey al caer este miércoles en la primera eliminatoria ante Tudelano (3-2), Lleida (3-1), Cádiz (0-1), Laredo (2-0) y Linense (1-0), respectivamente.

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.

Primera jornada del Grupo 1 de la Segunda B

Sergio Álvarez - Jueves, 16 Julio 2015

0 3.288

La RFEF ha dado a conocer el calendario de la primera jornada de la temporada en Segunda B, en el que destaca el derbi entre el filial del Valladolid B y la Cultural Leonesa.

Así queda el grupo I de Segunda B

Isabel Ruiz - Martes, 14 Julio 2015

3 4.651

Esta mañana, la Asamblea de la Federación Española de Fútbol (RFEF) ha aprobado la propuesta de grupos para la temporada 2015-16 que la semana pasada efectuó la Comisión de Segunda B de la RFEF.

Recuerdas a... Tato Abadía

Manuel Gutiérrez - Miércoles, 01 Julio 2015

0 3.336

De Abadía siempre se destacó el vigor, la fuerza, la valentía y el derroche que demostraba en cada partido. Se convirtió en un ídolo en todos los clubs en los que militó.

Ver más noticias del equipo»

Comparar equipos

SD Compostela

Selecciona un equipo

Competiciones que juega

RIVALES EN Copa del Rey

RIVALES EN Segunda División.

USO DE MEMORIA

5,760,592 bytes

BENCHMARKS

Loading Time Base Classes	0.0020
Controller Execution Time ( Home / Category )	0.1684
Total Execution Time	0.1705

CADENA URL

/Sd-Compostela/1981

GET DATOS

$_GET['/Sd-Compostela/1981']

POST DATOS

No hay datos POST existentes

CONSULTAS (25)

0.0032	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 = 'Sd-Compostela' AND l.year = 1981 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=6206 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=6206 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=6206 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0029	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 = '6206' AND l.year = 1981 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 = '6206' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0087	(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 calendars1981 as c ON c.league_id = l.id WHERE (c.datateam1 = 6206 or c.datateam2 = 6206) AND l.year = 1981 GROUP BY cat.id) ORDER BY coefficient DESC,group_code ASC
0.0119	(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 calendars1981 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 = 6206 or c.datateam2 = 6206) AND l.year = 1981 GROUP BY c.id) ORDER BY shedule DESC LIMIT 120
0.0207	(SELECT c.id, rel.team_id FROM leagues l INNER JOIN calendars1981 as c ON c.league_id = l.id INNER JOIN events1981 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 = 6206 or c.datateam2 = 6206) AND l.year = 1981)
0.0030	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=6206 AND l.year in (1980,1981,1982) 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 (21960,21063,21016) 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.0022	SELECT count(id) as num_players from rel_players WHERE league_id = 21063 AND teamId = 6206
0.0018	SELECT count(id) as num_players from rel_players WHERE league_id = 21016 AND teamId = 6206
0.0027	SELECT count(id) as num_players from rel_players WHERE league_id = 21960 AND teamId = 6206
0.0030	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 events1981 e ON e.player_id = p.id AND e.league_id = 21940 WHERE rp.league_id = 21940 AND rp.teamId = 6206 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.0027	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 events1981 e ON e.player_id = p.id AND e.league_id = 21940 WHERE rp.league_id = 21940 AND rp.teamId = 6206 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0027	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 events1981 e ON e.player_id = p.id AND e.league_id = 21940 WHERE rp.league_id = 21940 AND rp.teamId = 6206 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0025	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 = 6206 AND rp.league_id = 21940 AND l.year= 1981 GROUP BY rp.team_id ORDER BY l.end_date DESC LIMIT 1
0.0025	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=639418 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=639418
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 events1981 e ON rp.league_id = e.league_id AND rp.player_id = e.player_id WHERE rp.team_id=639418 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.0020	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 events1981 e ON rp.league_id = e.league_id AND rp.player_id = e.player_id WHERE rp.team_id=639418 and (e.action = 4 or e.action = 5) GROUP BY dp.id ORDER BY cuenta DESC
0.0020	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 events1981 e ON rp.league_id = e.league_id AND rp.player_id = e.player_id WHERE rp.team_id=639418 and (e.action = 3 or e.action = 4) GROUP BY dp.id ORDER BY cuenta DESC
0.0020	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 events1981 e ON rp.league_id = e.league_id AND rp.player_id = e.player_id WHERE rp.team_id=639418 AND (e.action = 22) GROUP BY dp.id ORDER BY cuenta DESC
0.0020	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 events1981 e ON rp.league_id = e.league_id AND rp.player_id = e.player_id WHERE rp.team_id=639418 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

SD Compostela

Información sobre SD Compostela

Información

Otros Datos

Internet

Opciones de envio

Datos del equipo

Información sobre el estadio

Histórico de participación

Partidos del SD Compostela

Estadísticas

Plantilla del SD Compostela Temporada 1980/1981

Noticias del SD Compostela

SD Compostela

Selecciona un equipo

Competiciones que juega

RIVALES EN Copa del Rey

RIVALES EN Segunda División.