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

Eibar

Entrenador: Joseba Etxeberria

Temporada 1961/1962

TEMPORADA 1961/1962

TERCERA DIVISIÓN GRUPO 4
Equipo		PJ	GF	GC	Puntos
1	Eibar	32	80	26	49
2	Logroñés	32	73	38	46
3	Bergara KE	32	73	58	38
4	Real Unión	32	70	41	37
5	Beasain KE	32	57	57	37
6	Mirandés	32	65	56	36
7	CD Alfaro	32	53	43	35
8	CD Iruña	32	60	61	33
9	Villafranca	32	58	76	31
10	Euskalduna	32	65	52	30
11	Tolosa CF	32	48	58	29
12	CD Touring	32	61	56	28
13	Azkoyen	32	44	61	27
14	CD Vitoria	32	40	66	25
15	Calahorra	32	38	71	22
16	Recreacion	32	37	69	21
17	CD Elgoibar	32	40	73	20

TEMPORADA 1960/1961

TERCERA DIVISIÓN GRUPO 4
Equipo		PJ	GF	GC	Puntos
1	Deportivo	30	87	25	45
2	Aurrera	30	75	43	42
3	Eibar	30	82	51	38
4	CD Touring	30	60	35	38
5	Real Unión	30	58	41	34
6	Logroñés	30	50	50	33
7	CD Iruña	30	54	62	31
8	Mirandés	30	52	58	29
9	Bergara KE	30	50	56	29
10	Villafranca	30	51	47	28
11	CD Elgoibar	30	44	57	28
12	CD Alfaro	30	49	46	27
13	Tolosa CF	30	51	62	27
14	Recreacion	30	40	82	17
15	Beasain KE	30	46	79	17
16	Izarra	30	31	86	14

TEMPORADA 1959/1960

TERCERA DIVISIÓN GRUPO 4
Equipo		PJ	GF	GC	Puntos
1	Real	30	103	26	51
2	Real Unión	30	57	29	41
3	Bergara KE	30	76	72	36
4	Logroñés	30	56	43	34
5	Mirandés	30	58	55	32
6	CD Elgoibar	30	59	56	31
7	Eibar	30	66	63	31
8	Tolosa CF	30	60	47	31
9	Villafranca	30	44	56	30
10	Beasain KE	30	67	55	30
11	Aurrera	30	46	59	27
12	CD Iruña	30	35	46	26
13	CD Alfaro	30	50	63	26
14	Tudelano	30	43	65	23
15	Anaitasuna	30	43	76	18
16	Azkoyen	30	27	79	13

TEMPORADA 1958/1959

TERCERA DIVISIÓN GRUPO 4
Equipo		PJ	GF	GC	Puntos
1	Logroñés	30	65	32	46
2	Eibar	30	78	27	43
3	Real	30	65	43	35
4	Bergara KE	30	43	33	34
5	Mirandés	30	60	48	31
6	Tolosa CF	30	55	53	30
7	Beasain KE	30	51	53	30
8	Villafranca	30	58	65	29
9	CD Iruña	30	36	39	28
10	Tudelano	30	52	54	28
11	Azkoyen	30	39	51	26
12	CD Elgoibar	30	42	53	26
13	CD Hernani	30	40	60	26
14	Anaitasuna	30	49	59	26
15	Recreacion	30	38	69	21
16	Oberena	30	45	77	21

TEMPORADA 1957/1958

SEGUNDA DIVISIÓN GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	Real Oviedo	34	73	22	50
2	CE Sabadell	34	61	28	50
3	Racing	34	58	46	40
4	SD Indautxu	34	64	41	39
5	Condal CD	34	56	40	37
6	Rayo	34	44	43	34
7	Deportivo	34	47	44	33
8	Girona	34	42	57	33
9	CD Basconia	34	39	56	33
10	Deportivo	34	52	52	32
11	Sestao Sport	34	40	48	32
12	Racing	34	45	58	32
13	Real Avilés	34	52	70	32
14	Terrassa FC	34	57	61	30
15	Caudal	34	34	40	29
16	Cultural	34	38	48	28
17	Eibar	34	39	55	25
18	Circulo	34	38	70	23

TEMPORADA 1956/1957

SEGUNDA DIVISIÓN GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	Real	38	107	26	62
2	CE Sabadell	38	92	39	54
3	SD Indautxu	38	72	45	48
4	Real Oviedo	38	77	60	46
5	Deportivo	38	61	52	43
6	Cultural	38	63	61	41
7	Real Avilés	38	75	60	39
8	Girona	38	54	53	37
9	Racing	38	60	62	37
10	Eibar	38	63	79	36
11	Rayo	38	45	45	35
12	Caudal	38	66	72	35
13	Terrassa FC	38	57	60	34
14	Sestao Sport	38	60	67	34
15	Circulo	38	46	62	34
16	Racing	38	51	72	33
17	Logroñés	38	44	70	32
18	Barakaldo	38	50	83	31
19	Burgos	38	46	65	30
20	Lleida	38	37	93	19

TEMPORADA 1955/1956

SEGUNDA DIVISIÓN GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	Osasuna	30	76	33	42
2	Real Oviedo	30	78	33	41
3	Real	30	57	27	40
4	Caudal	30	49	37	34
5	CE Sabadell	30	50	44	33
6	Real	30	51	46	32
7	Racing	30	44	47	32
8	SD Indautxu	30	53	50	30
9	Racing	30	47	47	28
10	Barakaldo	30	45	54	28
11	Terrassa FC	30	46	59	28
12	Lleida	30	53	63	26
13	Circulo	30	35	57	26
14	Eibar	30	40	56	25
15	Sestao Sport	30	25	57	19
16	Logroñés	30	37	76	16

TEMPORADA 1954/1955

SEGUNDA DIVISIÓN GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	Cultural	30	68	38	40
2	Real	30	69	41	39
3	Real Oviedo	30	61	33	39
4	Real	30	50	34	38
5	Logroñés	30	52	43	36
6	Barakaldo	30	47	42	33
7	Circulo	30	41	45	30
8	Eibar	30	54	51	29
9	Osasuna	30	56	57	29
10	Lleida	30	41	56	27
11	Condal CD	30	46	45	26
12	Racing	30	35	59	24
13	Caudal	30	49	59	24
14	Sestao Sport	30	45	56	23
15	Real Avilés	30	50	60	23
16	CD Juvenil	30	40	85	20

TEMPORADA 1953/1954

SEGUNDA DIVISIÓN GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	Deportivo	30	65	42	41
2	Barakaldo	30	56	36	38
3	Lleida	30	62	44	38
4	Cultural	30	63	46	34
5	Condal CD	30	62	48	33
6	CE Sabadell	30	52	53	32
7	Eibar	30	56	54	29
8	Racing	30	44	58	29
9	Real	30	76	59	29
10	Logroñés	30	65	55	28
11	Real Avilés	30	45	61	28
12	Caudal	30	38	46	28
13	Circulo	30	49	63	25
14	Gimnástica	30	35	64	25
15	Salamanca	30	44	56	22
16	Escoriaza	30	42	69	21

TEMPORADA 1952/1953

TERCERA DIVISIÓN GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	Eibar	34	93	40	52
2	Sestao Sport	34	62	33	43
3	Mirandés	34	73	48	42
4	CD Getxo	34	67	45	42
5	Mondragón	34	69	51	40
6	Numancia	34	60	61	37
7	CD Basconia	34	65	62	37
8	Izarra	34	68	60	36
9	SD Indautxu	34	54	51	34
10	Arenas Getxo	34	46	67	30
11	Portugalete	34	43	52	30
12	Garellano	34	57	72	29
13	Azkoyen	34	48	80	29
14	Calatayud	34	40	68	28
15	Deportivo	33	54	61	27
16	SD Erandio	34	58	61	26
17	Recreacion	33	43	60	25
18	Calahorra	34	51	79	23

TEMPORADA 1951/1952

TERCERA DIVISIÓN GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	Burgos	30	75	42	40
2	Eibar	30	68	38	39
3	Recreacion	30	59	57	34
4	Deportivo	30	48	39	34
5	CD Getxo	30	52	37	33
6	Arenas	29	50	50	32
7	Mirandés	30	57	48	32
8	Portugalete	30	54	55	30
9	CD Basconia	30	43	49	29
10	Sestao Sport	30	54	55	29
11	Izarra	30	51	70	28
12	SD Erandio	30	29	53	26
13	Numancia	29	64	55	26
14	Calahorra	30	42	67	24
15	SD Indautxu	30	50	59	22
16	Arenas Getxo	30	42	64	20

TEMPORADA 1950/1951

TERCERA DIVISIÓN GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	Eibar	34	84	45	52
2	Deportivo	34	75	31	47
3	Burgos	34	71	42	47
4	CD Getxo	34	70	38	45
5	SD Indautxu	34	68	63	38
6	Mirandés	34	63	53	38
7	Izarra	34	75	78	34
8	Calahorra	34	54	63	33
9	Sestao Sport	34	58	63	33
10	Arenas Getxo	34	70	59	32
11	CD Naval	34	66	66	30
12	SD Erandio	34	59	63	30
13	CD Basconia	34	52	52	30
14	Recreacion	34	62	71	30
15	Juventud	34	57	76	28
16	Rayo	34	59	74	24
17	Real Unión	34	49	91	22
18	Tudelano	34	43	107	19

Competiciones que juega

Tercera División Grupo 4

Pos	Equipos		Pts
1		Eibar	49
2		CD Logroñés	46
3		Bergara KE	38
4		Real Unión Club	37
5		Beasain KE	37
6		Mirandés	36
7		CD Alfaro	35
8		CD Iruña	33
9		Villafranca	31
10		Euskalduna	30
11		Tolosa CF	29
12		CD Touring	28
13		Azkoyen	27
14		CD Vitoria	25
15		CD Calahorra	22
16		Recreacion de Logroño	21
17		CD Elgoibar	20

RIVALES EN Tercera División

USO DE MEMORIA

6,651,888 bytes

BENCHMARKS

Loading Time Base Classes	0.0012
Controller Execution Time ( Home / Category )	0.1207
Total Execution Time	0.1219

CADENA URL

/historico/Eibar/1962

GET DATOS

$_GET['/historico/Eibar/1962']

POST DATOS

No hay datos POST existentes

CONSULTAS (28)

0.0035	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 = 'Eibar' AND l.year = 1962 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.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=957 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=957 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0018	SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=957 AND type_rel = 2
0.0074	SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 2 AND rel.typeId = 957 AND rel.ln = 'es' ORDER BY rel.cover_points DESC LIMIT 5
0.0021	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 (213,435,497,548,583) ORDER BY n.cover_points DESC, update_date DESC
0.0036	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 = '957' AND l.year = 1962 ORDER BY l.year DESC,cat.coefficient DESC
0.0052	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 = '957' 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 = 21535 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0036	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=957 AND l.year in (1961,1962,1963) 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 (21550) 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.0048	SELECT count(id) as num_players from rel_players WHERE league_id = 21550 AND teamId = 957
0.0025	SELECT t.,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff FROM* `tables1962` 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 = 21535 AND t.round = 34 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0020	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 events1962 e ON e.player_id = p.id AND e.league_id = 21535 WHERE rp.league_id = 21535 AND rp.teamId = 957 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.0019	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 events1962 e ON e.player_id = p.id AND e.league_id = 21535 WHERE rp.league_id = 21535 AND rp.teamId = 957 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0019	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 events1962 e ON e.player_id = p.id AND e.league_id = 21535 WHERE rp.league_id = 21535 AND rp.teamId = 957 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0029	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 = 957 AND l.year <= 1962 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
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* `tables1961` 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 = 21522 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0025	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* `tables1960` 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 = 21509 AND t.round = 30 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* `tables1959` 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 = 21496 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0026	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* `tables1958` 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 = 20966 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0026	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* `tables1957` 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 = 20965 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0025	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* `tables1956` 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 = 20964 AND t.round = 30 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* `tables1955` 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 = 21055 AND t.round = 30 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* `tables1954` 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 = 20963 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0025	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* `tables1953` 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 = 21397 AND t.round = 34 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* `tables1952` 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 = 21391 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0025	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* `tables1951` 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 = 21385 AND t.round = 34 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

Eibar

Eibar

Selecciona un equipo

Competiciones que juega

Tercera División Grupo 4

RIVALES EN Tercera División