17 Jun 06	Finalizado	Real Sporting	1 - 0	Real Murcia	0
10 Jun 06	Finalizado	Elche	0 - 0	Real Sporting	0
03 Jun 06	Finalizado	Real Sporting	3 - 1	Racing Ferrol	0
28 May 06	Finalizado	Poli Ejido	1 - 0	Real Sporting	0
21 May 06	Finalizado	Real Sporting	0 - 2	Levante	0
13 May 06	Finalizado	Lorca Deportiva	1 - 0	Real Sporting	1
06 May 06	Finalizado	Real Sporting	1 - 1	Eibar	0
29 Abr 06	Finalizado	Real Valladolid	1 - 3	Real Sporting	0
23 Abr 06	Finalizado	Real Sporting	2 - 0	Lleida	0
15 Abr 06	Finalizado	Real Sporting	2 - 2	Tenerife	0
08 Abr 06	Finalizado	Ciudad de Murcia	1 - 0	Real Sporting	0
01 Abr 06	Finalizado	Real Sporting	1 - 1	Hércules	0
26 Mar 06	Finalizado	Xerez CD	0 - 0	Real Sporting	0
19 Mar 06	Finalizado	Real Sporting	1 - 0	Numancia	0
11 Mar 06	Finalizado	CD Castellón	1 - 0	Real Sporting	0
04 Mar 06	Finalizado	Real Sporting	1 - 0	Almería	0
25 Feb 06	Finalizado	RM Castilla	1 - 1	Real Sporting	0
18 Feb 06	Finalizado	Real Sporting	0 - 0	At. Malagueño	0
15 Feb 06	Finalizado	Albacete	1 - 0	Real Sporting	0
12 Feb 06	Finalizado	Recreativo	0 - 0	Real Sporting	0
04 Feb 06	Finalizado	Real Sporting	0 - 1	Gimnàstic Tarragona	0
21 Ene 06	Finalizado	Real Murcia	1 - 0	Real Sporting	0
15 Ene 06	Finalizado	Real Sporting	2 - 2	Elche	0
07 Ene 06	Finalizado	Racing Ferrol	0 - 0	Real Sporting	0
21 Dic 05	Finalizado	Real Sporting	1 - 1	Poli Ejido	0
17 Dic 05	Finalizado	Levante	0 - 0	Real Sporting	0
11 Dic 05	Finalizado	Real Sporting	1 - 0	Lorca Deportiva	0
04 Dic 05	Finalizado	Eibar	0 - 1	Real Sporting	0
27 Nov 05	Finalizado	Real Sporting	1 - 1	Real Valladolid	0
19 Nov 05	Finalizado	Lleida	0 - 1	Real Sporting	0
13 Nov 05	Finalizado	Tenerife	1 - 3	Real Sporting	0
06 Nov 05	Finalizado	Real Sporting	2 - 2	Ciudad de Murcia	0
29 Oct 05	Finalizado	Hércules	3 - 2	Real Sporting	0
23 Oct 05	Finalizado	Real Sporting	1 - 1	Xerez CD	0
16 Oct 05	Finalizado	Numancia	1 - 0	Real Sporting	0
09 Oct 05	Finalizado	Real Sporting	2 - 0	CD Castellón	0
02 Oct 05	Finalizado	Almería	3 - 0	Real Sporting	0
25 Sep 05	Finalizado	Real Sporting	1 - 1	RM Castilla	0
17 Sep 05	Finalizado	At. Malagueño	1 - 0	Real Sporting	0
11 Sep 05	Finalizado	Real Sporting	1 - 1	Recreativo	0
04 Sep 05	Finalizado	Gimnàstic Tarragona	0 - 4	Real Sporting	2
27 Ago 05	Finalizado	Real Sporting	2 - 0	Albacete	0

Copa del Rey »

31 Ago 05

Finalizado

Racing Ferrol

2 - 0

Real Sporting

Estadísticas

GOLEADORES

AMARILLAS

Enguix10

Jeffrey10

ROJAS

Míchel1

Plantilla del Real Sporting Temporada 2005/2006

		Edad	Altura	Peso
Portero
	Jandro	40	183	77	-	-	-
	Manu Fernández	37	180	75	-	-	-
	Roberto	45	181	76	-	-	5
Defensa
	Carmena	41	185	76	-	-	3
	Chus Bravo	44	186	75	-	1	3
	Guardado	37	182	75	-	-	-
	J. García	40	185	79	1	-	12
	Javier Dorado	47	180	70	1	1	6
	Jeffrey	39	180	75	-	-	10
	José Ángel	39	182	88	-	-	-
	Juanmi	51	182	78	-	-	4
	Lucena	41	186	84	-	-	-
	Noel Alonso	37	178	74	-	-	-
	Rafael Sastre	48	175	75	-	2	14
	Raúl Cámara	40	171	68	-	-	11
Centrocampista
	Álvaro Varela	44	169	65	-	-	-
	Enguix	46	180	75	-	-	10
	G. Noriega	42	173	67	4	-	6
	Javi Fuego	40	181	74	-	-	4
	Juan Díaz	46	186	82	1	-	15
	Landeira	36	182	76	-	-	2
	Míchel	38	183	72	1	1	4
	Moisés	40	171	68	-	-	-
	Pablo Álvarez	43	175	65	8	-	11
	Pablo De Lucas	37	180	72	-	-	-
	Pablo Lago	49	177	70	-	-	4
	Pedro	40	180	74	-	-	-
Delantero
	Karanka	46	184	75	1	-	-
	L. Biagini	47	183	75	11	-	1
	P. Calandria	42	184	75	12	-	2

Noticias del Real Sporting

Ver últimas noticias

El Sporting encalla ante un sólido Mirandés

BeSoccer - Sábado, 30 Noviembre 2019

0 410

El Sporting de Gijón no pudo pasar del empate (0-0) en su visita a un Mirandés que sigue confirmando su solidez. En un encuentro marcado por la lluvia y la falta de ocasiones claras, los locales pudieron llevarse el triunfo in extremis con una ocasión clamorosa que erró Marcos Andrés.

¡Tres horas duraron las entradas del Oviedo para El Molinón!

BeSoccer - Jueves, 21 Marzo 2019

1 424

Desde que ambos equipos finalizaron sus últimos compromisos de Segunda, tanto Sporting como Oviedo comenzaron a pensar en el derbi. En Asturias se empieza a calentar ya el partido y la afición oviedista lo demostró en unas horas, agotando todas las entradas disponibles para los seguidores visitantes en El Molinón.

El Sporting conmemora los 40 años de su debut europeo

BeSoccer - Miércoles, 05 Septiembre 2018

0 492

El Sporting conmemorará el próximo día 14 de septiembre el 40 aniversario de su debut en la hoy desaparecida Copa de la UEFA, en el que se impuso por un claro 3-0 al Torino, y llevará a cabo una serie de actos abiertos a todos los aficionados.

Del gol mal anulado al Sporting al 1-0 de Osasuna

Carlos Torregrosa - Sábado, 22 Abril 2017

0 514

Estas cosas tiene el fútbol. Estas cosas tiene LaLiga, una competición que aspira a ser la mejor del mundo, pero en la que los errores de bulto siguen siendo igual de desequilibrantes que Messi o Cristiano.

Un esguince de rodilla deja a Cuellar entre algodones

BeSoccer - Lunes, 01 Febrero 2016

0 700

El entrenador del Sporting, Abelardo Fernández, deberá esperar la evolución del esguince leve de rodilla que sufrió ayer en Valencia el guardameta Cuellar para poder saber si podrá contar con su portero titular para el partido que su equipo disputará el sábado contra el Deportivo de la Coruña.

Ver más noticias del equipo»

Competiciones que juega

Segunda División

Pos	Equipos		Pts
1		Recreativo	78
2		Gimnàstic Tarragona	76
3		Levante	74
4		Ciudad de Murcia	72
5		Lorca Deportiva	69
6		Almería	67
7		Xerez CD	67
8		Numancia	63
9		Real Sporting	56
10		Real Valladolid	55
11		RM Castilla	55
12		CD Castellón	54
13		Albacete	54
14		Elche	53
15		Poli Ejido	53
16		Real Murcia	52
17		Hércules	52
18		Tenerife	51
19		Lleida	46
20		Racing Ferrol	37
21		At. Malagueño	36
22		Eibar	35

	Ascenso : Recreativo, Gimnàstic Tarragona, Levante
	Descenso : Lleida, Racing Ferrol, At. Malagueño, Eibar

RIVALES EN Copa del Rey

RIVALES EN Segunda División

USO DE MEMORIA

6,218,480 bytes

BENCHMARKS

Loading Time Base Classes	0.0031
Controller Execution Time ( Home / Category )	0.5900
Total Execution Time	0.5931

CADENA URL

/Sporting-Gijon/2006

GET DATOS

$_GET['/Sporting-Gijon/2006']

POST DATOS

No hay datos POST existentes

CONSULTAS (25)

0.0292	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 = 534
0.0150	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 = 20577
0.0219	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 = '2125' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0151	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 = 20577 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0147	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 = 534 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0148	(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 calendars2006 as c ON c.league_id = l.id WHERE (c.datateam1 = 2125 or c.datateam2 = 2125) AND l.year = 2006 GROUP BY cat.id) ORDER BY coefficient DESC,group_code ASC
0.0154	(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 calendars2006 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 = 2125 or c.datateam2 = 2125) AND l.year = 2006 GROUP BY c.id) ORDER BY shedule DESC LIMIT 120
0.0152	(SELECT c.id, rel.team_id FROM leagues l INNER JOIN calendars2006 as c ON c.league_id = l.id INNER JOIN events2006 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 = 2125 or c.datateam2 = 2125) AND l.year = 2006)
0.0159	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=2125 AND l.year in (2005,2006,2007) ORDER BY l.id DESC, l.year DESC ;
0.0145	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 (20578,535) 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.0149	SELECT count(id) as num_players from rel_players WHERE league_id = 535 AND teamId = 2125
0.0155	SELECT count(id) as num_players from rel_players WHERE league_id = 20578 AND teamId = 2125
0.0176	SELECT t.,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff FROM* `tables2006` 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 = 534 AND t.round = 42 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0220	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 events2006 e ON e.player_id = p.id AND e.league_id = 534 WHERE rp.league_id = 534 AND rp.teamId = 2125 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.0157	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 events2006 e ON e.player_id = p.id AND e.league_id = 534 WHERE rp.league_id = 534 AND rp.teamId = 2125 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0157	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 events2006 e ON e.player_id = p.id AND e.league_id = 534 WHERE rp.league_id = 534 AND rp.teamId = 2125 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0196	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 = 2125 AND rp.league_id = 534 AND l.year= 2006 GROUP BY rp.team_id ORDER BY l.end_date DESC LIMIT 1
0.0174	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=12850 GROUP BY dp.id ORDER BY dp.role>0 DESC, dp.role ASC, dp.nick ASC, dp.id
0.0153	SELECT rp.player_id, rp.pj, rp.lineup FROM rel_players AS rp WHERE rp.team_id=12850
0.0248	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 events2006 e ON rp.league_id = e.league_id AND rp.player_id = e.player_id WHERE rp.team_id=12850 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.0160	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 events2006 e ON rp.league_id = e.league_id AND rp.player_id = e.player_id WHERE rp.team_id=12850 and (e.action = 4 or e.action = 5) GROUP BY dp.id ORDER BY cuenta DESC
0.0186	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 events2006 e ON rp.league_id = e.league_id AND rp.player_id = e.player_id WHERE rp.team_id=12850 and (e.action = 3 or e.action = 4) GROUP BY dp.id ORDER BY cuenta DESC
0.0161	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 events2006 e ON rp.league_id = e.league_id AND rp.player_id = e.player_id WHERE rp.team_id=12850 AND (e.action = 22) GROUP BY dp.id ORDER BY cuenta DESC
0.0165	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 events2006 e ON rp.league_id = e.league_id AND rp.player_id = e.player_id WHERE rp.team_id=12850 and (e.action = 19) GROUP BY dp.id ORDER BY cuenta DESC
0.0147	SELECT dt.nameShow, dt.basealias, t.id, dt.id as dt_id FROM `teams` as t INNER JOIN `datateams` as dt ON dt.id = t.teamId WHERE league_id = 534 ORDER BY nameShow LIMIT 100

Resultados de Fútbol

Real Sporting

Información sobre Real Sporting

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

Partidos Amistosos

Segunda - Play Offs Ascenso

Europa League

Trofeo Teresa Herrera

Copa de la Liga de España

Trofeo Ciutat de Palma

Trofeo Ramón de Carranza

Trofeo Colombino

Partidos del Real Sporting

Estadísticas

Plantilla del Real Sporting Temporada 2005/2006

Noticias del Real Sporting

El Sporting encalla ante un sólido Mirandés

¡Tres horas duraron las entradas del Oviedo para El Molinón!

El Sporting conmemora los 40 años de su debut europeo

Del gol mal anulado al Sporting al 1-0 de Osasuna

Un esguince de rodilla deja a Cuellar entre algodones

Real Sporting

Selecciona un equipo

Competiciones que juega

Segunda División

RIVALES EN Copa del Rey

RIVALES EN Segunda División


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