Has elegido rechazar las cookies basadas en consentimiento que utilizamos principalmente para gestionar la publicidad y las recomendaciones de contenido.

En adelante, para aceder a nuestra web tienes que elegir alguna de las siguientes opciones.

Has cambiado de idea y quieres
NAVEGAR GRATIS Y CON PUBLICIDAD...

Navega por besoccer.com y resultados-futbol.com con publicidad personalizada, seguimiento y cookies de forma gratuita.

Optar por esta opción te permitirá mantener tu experiencia de navegación como hasta ahora. Al aceptar las cookies y tecnologías similares, estás dando tu consentimiento para que recopilemos y utilicemos tu información de navegación con el propósito de adaptar la publicidad y la personalización según tus intereses. La presencia de esta publicidad es crucial para continuar proporcionando contenido de calidad, sevicios eficientes a los usuarios y mejorar la experiencia general de uso.

Nosotros y nuestros socios hacemos el siguiente tratamiento de datos: almacenamiento y acceso a información de geolocalización con propósitos de publicidad dirigida, almacenamiento y acceso a información de geolocalización para realizar estudios de mercado, almacenar o acceder a información en un dispositivo, analizar activamente las características del dispositivo para su identificación, compartir tus análisis de navegación y grupos de interés con terceros, crear un perfil para la personalización de contenidos, crear un perfil publicitario personalizado, desarrollar y mejorar productos, enriquecer el perfil con información de terceros, medir el rendimiento de los anuncios, medir el rendimiento del contenido, seleccionar anuncios básicos, seleccionar anuncios personalizados, seleccionar contenido personalizado, utilizar datos de localización geográfica precisa, utilizar estudios de mercado a fin de generar información sobre el público.

Aceptar y continuar gratis

...O sigues prefiriendo rechazar las cookies y entonces
CONTINÚA REGISTRÁNDOTE Y SUSCRIBIÉNDOTE

Navega por besoccer.com y resultados-futbol.com sin publicidad ni seguimiento suscribiéndote a nuestra web por 0,50 € al día.

Además de abonar la suscripción, es necesario realizar un registro previo para acceder. El mismo perfil de usuario es compartido entre los sitios besoccer.com y resultados-futbol.com

Accede por 0,50 € al día

Para saber más, consulta nuestra Política de Cookies.

Sitios
- Twitter
Notificaciones 0
Amigos 0
Actividad

No hay actividad de la comunidad para mostrarte.

4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias

Resultados de Fútbol

Real Sociedad

Entrenador: Imanol Alguacil

Presidente: Jokin Aperribay

Temporada 1948/1949

TEMPORADA 1948/1949

SEGUNDA DIVISIÓN
Equipo		PJ	GF	GC	Puntos
1	Real	26	80	41	35
2	CD Málaga	26	73	33	35
3	Granada	26	50	37	35
4	Hércules	26	64	53	32
5	Barakaldo	26	48	37	29
6	Real	26	56	44	29
7	Real Murcia	26	51	71	26
8	Castellón	26	47	61	24
9	Levante	26	48	53	22
10	Girona	26	45	53	22
11	Racing	26	50	67	21
12	Valencia	26	43	50	20
13	Badalona	26	40	63	19
14	Racing	26	39	71	15

TEMPORADA 1947/1948

PRIMERA DIVISIÓN
Equipo		PJ	GF	GC	Puntos
1	Barcelona	26	65	31	37
2	Valencia	26	59	34	34
3	Atlético	26	73	45	33
4	Celta	26	59	48	31
5	Sevilla	26	50	40	29
6	Athletic	26	56	44	28
7	Gimnàstic	26	49	55	24
8	Espanyol	26	39	47	24
9	Real Oviedo	26	49	57	23
10	Alcoyano	26	40	52	22
11	Real Madrid	26	41	56	21
12	CE Sabadell	26	41	62	21
13	Real	26	38	56	19
14	Real	26	37	69	18

TEMPORADA 1946/1947

SEGUNDA DIVISIÓN
Equipo		PJ	GF	GC	Puntos
1	Alcoyano	26	65	36	38
2	Gimnàstic	26	67	42	35
3	Real	26	55	37	32
4	Hércules	26	48	44	30
5	Mallorca	26	47	48	26
6	Levante	26	62	54	26
7	Granada	26	36	51	25
8	Córdoba	26	38	41	24
9	CD Málaga	26	38	44	23
10	Racing	26	48	62	22
11	Barakaldo	26	58	59	21
12	Racing	26	38	54	21
13	Real	26	42	47	21
14	Real Betis	26	37	60	20

TEMPORADA 1945/1946

SEGUNDA DIVISIÓN
Equipo		PJ	GF	GC	Puntos
1	CE Sabadell	26	50	29	35
2	Deportivo	26	38	28	33
3	Gimnàstic	26	50	46	29
4	Granada	26	49	35	29
5	Córdoba	26	36	34	29
6	Real	26	46	33	27
7	Racing	26	39	52	25
8	Mallorca	26	37	39	25
9	Racing	26	56	51	24
10	Real	26	44	53	24
11	Real Betis	26	41	40	24
12	Jerez FC	26	43	59	22
13	Salamanca	26	41	48	20
14	SD Ceuta	26	35	58	18

TEMPORADA 1944/1945

SEGUNDA DIVISIÓN
Equipo		PJ	GF	GC	Puntos
1	Alcoyano	26	57	35	34
2	Hércules	26	55	39	33
3	Celta	26	65	40	32
4	Real	26	56	34	31
5	Jerez FC	26	52	50	29
6	Racing	26	69	57	26
7	Real Betis	26	45	47	26
8	Real	26	50	53	26
9	SD Ceuta	26	40	49	24
10	Racing	26	44	68	24
11	Mallorca	26	44	55	22
12	Constància	26	42	53	22
13	Cultural	26	41	49	22
14	Barakaldo	26	31	62	13

TEMPORADA 1943/1944

PRIMERA DIVISIÓN
Equipo		PJ	GF	GC	Puntos
1	Valencia	26	73	32	40
2	Atlético	26	66	49	34
3	Sevilla	26	60	46	32
4	Real Oviedo	26	71	47	29
5	Castellón	26	42	36	29
6	Barcelona	26	59	46	28
7	Real Madrid	26	48	38	28
8	Granada	26	41	46	26
9	CE Sabadell	26	53	60	25
10	Athletic	26	47	51	25
11	Espanyol	26	42	50	23
12	Deportivo	26	35	64	19
13	Real	26	34	54	17
14	Celta	26	23	75	9

TEMPORADA 1942/1943

SEGUNDA DIVISIÓN GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	Real	14	46	16	23
2	CE Sabadell	14	26	20	18
3	Constància	14	24	11	18
4	Osasuna	14	23	27	15
5	Terrassa FC	14	25	32	12
6	Girona	14	22	24	11
7	Ferroviaria	14	19	31	10
8	Deportivo	14	9	33	5

TEMPORADA 1941/1942

PRIMERA DIVISIÓN
Equipo		PJ	GF	GC	Puntos
1	Valencia	26	85	39	40
2	Real Madrid	26	65	43	33
3	Atlético	26	50	44	33
4	Deportivo	26	36	37	28
5	Celta	26	53	58	28
6	Sevilla	26	58	45	27
7	Athletic	26	55	41	27
8	Castellón	26	54	63	26
9	Espanyol	26	49	42	26
10	Granada	26	64	52	25
11	Real Oviedo	26	42	63	23
12	Barcelona	26	57	66	19
13	Hércules	26	42	71	17
14	Real	26	31	77	12

TEMPORADA 1940/1941

SEGUNDA DIVISIÓN GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	Real	22	81	40	34
2	Deportivo	22	75	26	33
3	Real	22	54	40	29
4	Racing	22	49	38	26
5	Osasuna	22	44	45	24
6	Racing	22	42	40	22
7	Salamanca	22	38	48	18
8	Arenas Getxo	22	28	47	18
9	Real Unión	22	37	58	17
10	Real	22	40	62	16
11	Barakaldo	22	40	57	16
12	Real Avilés	22	27	54	11

TEMPORADA 1939/1940

SEGUNDA DIVISIÓN GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	Real	14	53	11	25
2	Osasuna	14	33	11	21
3	Real Unión	14	24	33	14
4	Sestao Sport	14	27	31	13
5	Barakaldo	14	19	25	12
6	SD Erandio	14	24	30	11
7	Arenas Getxo	14	25	44	9
8	Deportivo	14	16	36	7

TEMPORADA 1935/1936

SEGUNDA DIVISIÓN GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	Girona	14	33	13	21
2	Arenas Getxo	14	33	28	20
3	Barakaldo	14	32	24	17
4	Badalona	14	25	29	12
5	CE Sabadell	14	25	26	12
6	Real	14	24	34	12
7	Júpiter	14	23	35	10
8	Real Unión	14	22	28	8

TEMPORADA 1934/1935

PRIMERA DIVISIÓN
Equipo		PJ	GF	GC	Puntos
1	Real Betis	22	43	19	34
2	Real Madrid	22	61	34	33
3	Real Oviedo	22	60	47	26
4	Athletic	22	60	37	25
5	Sevilla	22	53	38	24
6	Barcelona	22	55	44	24
7	Atlético	22	40	45	21
8	Espanyol	22	47	59	20
9	Valencia	22	40	49	20
10	Racing	22	37	46	17
11	Real	22	28	67	11
12	Arenas Getxo	22	17	56	9

TEMPORADA 1933/1934

PRIMERA DIVISIÓN
Equipo		PJ	GF	GC	Puntos
1	Athletic	18	61	27	24
2	Real Madrid	18	41	29	22
3	Racing	18	38	39	19
4	Real Betis	18	29	36	19
5	Real	18	29	33	18
6	Real Oviedo	18	51	45	18
7	Valencia	18	28	38	17
8	Espanyol	18	41	42	17
9	Barcelona	18	42	40	16
10	Arenas Getxo	18	18	49	10

TEMPORADA 1932/1933

PRIMERA DIVISIÓN
Equipo		PJ	GF	GC	Puntos
1	Real Madrid	18	49	17	28
2	Athletic	18	63	30	26
3	Espanyol	18	33	30	22
4	Barcelona	18	42	34	19
5	Real Betis	18	31	45	17
6	Real	18	41	47	15
7	Arenas Getxo	18	39	44	14
8	Racing	18	47	58	14
9	Valencia	18	34	53	13
10	Deportivo	18	21	42	12

TEMPORADA 1931/1932

PRIMERA DIVISIÓN
Equipo		PJ	GF	GC	Puntos
1	Real Madrid	18	37	15	28
2	Athletic	18	47	23	25
3	Barcelona	18	40	26	24
4	Racing	18	36	35	20
5	Arenas Getxo	18	35	42	17
6	Espanyol	18	34	39	15
7	Valencia	18	38	47	15
8	Real	18	38	35	14
9	Deportivo	18	22	44	11
10	Real Unión	18	24	45	11

TEMPORADA 1930/1931

PRIMERA DIVISIÓN
Equipo		PJ	GF	GC	Puntos
1	Athletic	18	73	33	22
2	Racing	18	49	37	22
3	Real	18	42	39	22
4	Barcelona	18	40	43	21
5	Arenas Getxo	18	35	38	18
6	Real Madrid	18	24	27	18
7	Real Unión	18	41	45	16
8	Deportivo	18	25	39	14
9	Espanyol	18	32	45	14
10	CE Europa	18	23	38	13

TEMPORADA 1929/1930

PRIMERA DIVISIÓN
Equipo		PJ	GF	GC	Puntos
1	Athletic	18	63	28	30
2	Barcelona	18	46	36	23
3	Arenas Getxo	18	51	40	20
4	Espanyol	18	40	33	20
5	Real Madrid	18	45	42	17
6	Real Unión	18	48	52	17
7	Real	18	34	37	14
8	Racing	18	32	58	14
9	CE Europa	18	29	44	13
10	Atlético	18	32	50	12

TEMPORADA 1928/1929

PRIMERA DIVISIÓN
Equipo		PJ	GF	GC	Puntos
1	Barcelona	18	37	23	25
2	Real Madrid	18	40	27	23
3	Athletic	18	43	33	20
4	Real	18	46	41	20
5	Arenas Getxo	18	32	39	19
6	Atlético	18	43	41	18
7	Espanyol	18	32	38	18
8	CE Europa	18	45	49	16
9	Real Unión	18	40	42	12
10	Racing	18	25	50	9

Competiciones que juega

Grupo 4

Segunda División

Pos	Equipos		Pts
1		Real Sociedad	35
2		CD Málaga	35
3		Granada	35
4		Hércules	32
5		Barakaldo	29
6		Real Sporting	29
7		Real Murcia	26
8		CD Castellón	24
9		Levante	22
10		Girona	22
11		Racing	21
12		Valencia Mestalla	20
13		Badalona	19
14		Racing Ferrol	15

RIVALES EN Copa del Rey

RIVALES EN Segunda División

USO DE MEMORIA

6,958,568 bytes

BENCHMARKS

Loading Time Base Classes	0.0014
Controller Execution Time ( Home / Category )	0.1313
Total Execution Time	0.1328

CADENA URL

/historico/Real-Sociedad/1949

GET DATOS

$_GET['/historico/Real-Sociedad/1949']

POST DATOS

No hay datos POST existentes

CONSULTAS (35)

0.0046	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 = 'Real-Sociedad' AND l.year = 1949 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=2120 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0018	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=2120 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=2120 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0040	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 = 10376
0.0039	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 = '2120' AND l.year = 1949 ORDER BY l.year DESC,cat.coefficient DESC
0.0050	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 = '2120' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0020	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 = 10376 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0032	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=2120 AND l.year in (1948,1949,1950) ORDER BY l.id DESC, l.year DESC ;
0.0018	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 (22154,10376,5375) 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 = 5375 AND teamId = 2120
0.0028	SELECT count(id) as num_players from rel_players WHERE league_id = 10376 AND teamId = 2120
0.0028	SELECT count(id) as num_players from rel_players WHERE league_id = 22154 AND teamId = 2120
0.0024	SELECT t.,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff FROM* `tables1949` 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 = 10376 AND t.round = 26 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
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 events1949 e ON e.player_id = p.id AND e.league_id = 10376 WHERE rp.league_id = 10376 AND rp.teamId = 2120 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 events1949 e ON e.player_id = p.id AND e.league_id = 10376 WHERE rp.league_id = 10376 AND rp.teamId = 2120 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 events1949 e ON e.player_id = p.id AND e.league_id = 10376 WHERE rp.league_id = 10376 AND rp.teamId = 2120 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0037	SELECT l.id,t.league_id,l.legend,l.year,c.name,l.total_teams,c.alias,l.group_code,l.total_group,l.current_round, l.table_suffix FROM teams t INNER JOIN leagues l ON t.league_id = l.id INNER JOIN categories c ON c.id = l.categoryId WHERE c.troncal = 1 AND t.teamId = 2120 AND l.year <= 1949 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.0022	SELECT t.,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM* `tables1948` 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 = 5373 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0022	SELECT t.,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM* `tables1947` 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 = 10378 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0031	SELECT t.,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM* `tables1946` 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 = 10381 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0023	SELECT t.,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM* `tables1945` 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 = 10380 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0023	SELECT t.,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM* `tables1944` 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 = 5369 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0022	SELECT t.,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM* `tables1943` 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 = 21318 AND t.round = 14 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0022	SELECT t.,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM* `tables1942` 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 = 5367 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0023	SELECT t.,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM* `tables1941` 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 = 20932 AND t.round = 22 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0022	SELECT t.,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM* `tables1940` 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 = 21261 AND t.round = 14 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0021	SELECT t.,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM* `tables1936` 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 = 21257 AND t.round = 14 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0024	SELECT t.,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM* `tables1935` 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 = 5360 AND t.round = 22 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0022	SELECT t.,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM* `tables1934` 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 = 5359 AND t.round = 18 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0021	SELECT t.,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM* `tables1933` 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 = 5358 AND t.round = 18 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0021	SELECT t.,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM* `tables1932` 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 = 5357 AND t.round = 18 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0029	SELECT t.,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM* `tables1931` 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 = 5356 AND t.round = 18 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0023	SELECT t.,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM* `tables1930` 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 = 5355 AND t.round = 18 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0021	SELECT t.,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM* `tables1929` 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 = 5354 AND t.round = 18 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC


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

Resultados de Fútbol

Real Sociedad

Real Sociedad

Selecciona un equipo

Competiciones que juega

Segunda División

RIVALES EN Copa del Rey

RIVALES EN Segunda División