30 Abr 61	Finalizado	CD Basconia	2 - 0	CE Sabadell
23 Abr 61	Finalizado	CE Sabadell	0 - 1	Osasuna
09 Abr 61	Finalizado	Cultural Leonesa	1 - 1	CE Sabadell
26 Mar 61	Finalizado	CE Sabadell	1 - 1	Pontevedra
19 Mar 61	Finalizado	CD Ourense	4 - 1	CE Sabadell
12 Mar 61	Finalizado	CE Sabadell	2 - 0	Terrassa FC
04 Mar 61	Finalizado	Condal CD	1 - 2	CE Sabadell
26 Feb 61	Finalizado	CE Sabadell	1 - 0	SD Indautxu
19 Feb 61	Finalizado	Barakaldo	0 - 1	CE Sabadell
12 Feb 61	Finalizado	CE Sabadell	1 - 0	Real Sociedad B
05 Feb 61	Finalizado	Sestao Sport Club	2 - 0	CE Sabadell
29 Ene 61	Finalizado	CE Sabadell	0 - 1	Celta
22 Ene 61	Finalizado	RC Deportivo	4 - 1	CE Sabadell
15 Ene 61	Finalizado	Real Sporting	1 - 1	CE Sabadell
08 Ene 61	Finalizado	CE Sabadell	0 - 0	UD Salamanca
01 Ene 61	Finalizado	CE Sabadell	2 - 1	CD Basconia
18 Dic 60	Finalizado	Osasuna	6 - 0	CE Sabadell
11 Dic 60	Finalizado	CE Sabadell	0 - 0	Cultural Leonesa
04 Dic 60	Finalizado	Pontevedra	0 - 0	CE Sabadell
27 Nov 60	Finalizado	CE Sabadell	1 - 0	CD Ourense
20 Nov 60	Finalizado	Terrassa FC	0 - 0	CE Sabadell
13 Nov 60	Finalizado	CE Sabadell	1 - 1	Condal CD
06 Nov 60	Finalizado	SD Indautxu	3 - 1	CE Sabadell
23 Oct 60	Finalizado	CE Sabadell	2 - 1	Barakaldo
16 Oct 60	Finalizado	Real Sociedad B	0 - 1	CE Sabadell
09 Oct 60	Finalizado	CE Sabadell	4 - 2	Sestao Sport Club
02 Oct 60	Finalizado	Celta	2 - 0	CE Sabadell
25 Sep 60	Finalizado	CE Sabadell	1 - 1	RC Deportivo
18 Sep 60	Finalizado	CE Sabadell	3 - 1	Real Sporting
11 Sep 60	Finalizado	UD Salamanca	4 - 2	CE Sabadell

Copa del Rey »

	30 Oct 60	Finalizado	Real Murcia	2 - 0	CE Sabadell			0
	12 Oct 60	Finalizado	CE Sabadell	1 - 0	Real Murcia			0

Estadísticas

GOLEADORES

Plantilla del CE Sabadell Temporada 1960/1961

		Edad	Altura	Peso
Portero
	Carracedo	89	-	-	-	-	-
	Ginesta	87	-	-	-	-	-
Defensa
	Datzira	87	176	74	-	-	-
	Roca	96	-	-	2	-	-
	Roselló	-	-	-	1	-	-
	Rovira	96	-	-	-	-	-
	Totorica	90	-	-	-	-	-
	Vilar	90	-	-	1	-	-
Centrocampista
	Aloy	94	-	-	3	-	-
	Irazoqui	96	-	-	-	-	-
	Izaola	87	-	-	-	-	-
	Masferrer	-	-	-	-	-	-
Delantero
	Arana	80	-	-	2	-	-
	Manel	-	-	-	2	-	-
	Massey	90	-	-	3	-	-
	Navarro	87	-	-	2	-	-
	Parés	89	176	74	7	-	-
	Polo	-	-	-	-	-	-
	Sanmiguel	-	-	-	1	-	-
	Vives	87	-	-	5	-	-

Noticias del CE Sabadell

Ver últimas noticias

Primera jornada del Grupo 3 de la Segunda B

Sergio Álvarez - Jueves, 16 Julio 2015

0 2.480

El Hércules, que se quedó a las puertas del ascenso, comienza la Liga en casa ante el filial del Levante. El recién descendido Sabadell visita al Eldense.

Collantes vestirá los colores del Alcorcón

BeSoccer - Miércoles, 15 Julio 2015

0 246

El centrocampista Juan José Collantes se ha convertido en el séptimo fichaje del club alfarero en este mercado veraniego.

Manu Lanzarote deja el Espanyol

BeSoccer - Jueves, 02 Julio 2015

0 409

El centrocampista Manu Lanzarote, cedido al Alavés la pasada temporada, y el Espanyol han rescindido de mutuo acuerdo el contrato que les unía para una temporada más, según ha informado la entidad catalana mediante un comunicado.

Sakamoto vende sus acciones del Sabadell

BeSoccer - Jueves, 02 Julio 2015

0 323

Las acciones pasarán a ser propiedad de una empresa española del sector de la obra civil.

Craviotto, nuevo guardameta del CE Sabadell

BeSoccer - Viernes, 26 Junio 2015

0 745

El portero Carles Craviotto, procedente del Hospitalet, se ha convertido este jueves en nuevo jugador del Sabadell para las dos próximas temporadas, en sustitución de De Navas.

Ver más noticias del equipo»

Competiciones que juega

Segunda División Grupo 1

Pos	Equipos		Pts
1		Osasuna	46
2		Celta	40
3		RC Deportivo	36
4		CD Ourense	36
5		Pontevedra	31
6		CE Sabadell	31
7		Cultural Leonesa	30
8		CD Basconia	29
9		Real Sociedad B	29
10		UD Salamanca	29
11		SD Indautxu	27
12		Condal CD	26
13		Real Sporting	25
14		Sestao Sport Club	24
15		Barakaldo	22
16		Terrassa FC	19

	Ascenso : Osasuna
	Playoff Ascenso : Celta
	Playoff Descenso : Real Sporting, Sestao Sport Club
	Descenso : Barakaldo, Terrassa FC

RIVALES EN Copa del Rey

RIVALES EN Segunda División

USO DE MEMORIA

5,803,848 bytes

BENCHMARKS

Loading Time Base Classes	0.0020
Controller Execution Time ( Home / Category )	0.1788
Total Execution Time	0.1808

CADENA URL

/Sabadell/1961

GET DATOS

$_GET['/Sabadell/1961']

POST DATOS

No hay datos POST existentes

CONSULTAS (24)

0.0088	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 = 'Sabadell' AND l.year = 1961 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=2198 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=2198 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=2198 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0055	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 = '2198' AND l.year = 1961 ORDER BY l.year DESC,cat.coefficient DESC
0.0057	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 = '2198' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0063	(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 calendars1961 as c ON c.league_id = l.id WHERE (c.datateam1 = 2198 or c.datateam2 = 2198) AND l.year = 1961 GROUP BY cat.id) ORDER BY coefficient DESC,group_code ASC
0.0090	(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 calendars1961 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 = 2198 or c.datateam2 = 2198) AND l.year = 1961 GROUP BY c.id) ORDER BY shedule DESC LIMIT 120
0.0079	(SELECT c.id, rel.team_id FROM leagues l INNER JOIN calendars1961 as c ON c.league_id = l.id INNER JOIN events1961 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 = 2198 or c.datateam2 = 2198) AND l.year = 1961)
0.0058	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=2198 AND l.year in (1960,1961,1962) 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 (22142,5458) 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.0037	SELECT count(id) as num_players from rel_players WHERE league_id = 5458 AND teamId = 2198
0.0032	SELECT count(id) as num_players from rel_players WHERE league_id = 22142 AND teamId = 2198
0.0042	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 events1961 e ON e.player_id = p.id AND e.league_id = 5457 WHERE rp.league_id = 5457 AND rp.teamId = 2198 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.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 events1961 e ON e.player_id = p.id AND e.league_id = 5457 WHERE rp.league_id = 5457 AND rp.teamId = 2198 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 events1961 e ON e.player_id = p.id AND e.league_id = 5457 WHERE rp.league_id = 5457 AND rp.teamId = 2198 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0042	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 = 2198 AND rp.league_id = 5457 AND l.year= 1961 GROUP BY rp.team_id ORDER BY l.end_date DESC LIMIT 1
0.0040	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=95256 GROUP BY dp.id ORDER BY dp.role>0 DESC, dp.role ASC, dp.nick ASC, dp.id
0.0021	SELECT rp.player_id, rp.pj, rp.lineup FROM rel_players AS rp WHERE rp.team_id=95256
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 events1961 e ON rp.league_id = e.league_id AND rp.player_id = e.player_id WHERE rp.team_id=95256 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 events1961 e ON rp.league_id = e.league_id AND rp.player_id = e.player_id WHERE rp.team_id=95256 and (e.action = 4 or e.action = 5) GROUP BY dp.id ORDER BY cuenta DESC
0.0034	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 events1961 e ON rp.league_id = e.league_id AND rp.player_id = e.player_id WHERE rp.team_id=95256 and (e.action = 3 or e.action = 4) 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 events1961 e ON rp.league_id = e.league_id AND rp.player_id = e.player_id WHERE rp.team_id=95256 AND (e.action = 22) 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 events1961 e ON rp.league_id = e.league_id AND rp.player_id = e.player_id WHERE rp.team_id=95256 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

CE Sabadell

Información sobre CE Sabadell

Información

Otros Datos

Internet

Opciones de envio

Datos del equipo

Información sobre el estadio

Histórico de participación

Partidos del CE Sabadell