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

SD Amorebieta

Entrenador: Jandro

Temporada 1981/1982

TEMPORADA 1981/1982

TERCERA DIVISIÓN GRUPO 3
Equipo		PJ	GF	GC	Puntos
1	Eibar	38	56	25	51
2	Aurrera KE	38	56	30	51
3	CD Basconia	38	62	36	48
4	Deusto	37	58	41	47
5	Amorebieta	38	56	41	46
6	Real Unión	38	60	42	43
7	Lemona	38	49	47	38
8	Deportivo	38	50	55	37
9	SD Gernika	38	44	44	37
10	Lagun Onak	38	54	69	37
11	Santutxu	38	33	35	35
12	Anaitasuna	38	43	54	35
13	Zorroza	38	35	44	35
14	Bergara KE	38	33	39	34
15	CD Touring	38	39	53	33
16	Tolosa CF	38	41	49	33
17	CD Getxo	38	50	61	32
18	Arenas Getxo	37	45	59	29
19	Balmaseda	38	39	61	29
20	CD Mungia	38	42	60	28

TEMPORADA 1967/1968

TERCERA DIVISIÓN GRUPO 3
Equipo		PJ	GF	GC	Puntos
1	SD Indautxu	30	68	28	48
2	Barakaldo	30	66	25	44
3	Bilbao Ath.	30	71	30	43
4	Laudio	30	60	33	40
5	Sestao Sport	30	56	42	34
6	CD Basconia	30	47	48	33
7	Arenas Getxo	30	37	38	29
8	CD Getxo	30	40	38	27
9	Rayo	30	45	48	27
10	SD Erandio	30	35	41	27
11	Santurtzi	30	43	48	26
12	Amorebieta	30	47	62	23
13	Deusto	30	34	62	22
14	Portugalete	30	28	54	21
15	UM Escobedo	30	36	73	21
16	Galdakao	30	23	66	15

TEMPORADA 1966/1967

TERCERA DIVISIÓN GRUPO 3
Equipo		PJ	GF	GC	Puntos
1	Bilbao Ath.	30	85	26	46
2	Sestao Sport	30	61	27	40
3	Barakaldo	30	61	33	39
4	Laudio	30	58	33	38
5	Rayo	30	47	26	36
6	Arenas Getxo	30	48	36	32
7	CD Basconia	30	42	36	32
8	Deusto	30	37	38	31
9	SD Erandio	30	43	49	30
10	Santurtzi	30	34	57	27
11	Galdakao	30	31	38	26
12	Amorebieta	30	34	45	25
13	Santoña CF	30	37	58	25
14	Unión Club	30	20	52	19
15	Barreda	30	28	61	18
16	CD Laredo	30	16	67	16

TEMPORADA 1965/1966

TERCERA DIVISIÓN GRUPO 3
Equipo		PJ	GF	GC	Puntos
1	Gimnástica	30	61	31	44
2	Rayo	30	54	27	42
3	Amorebieta	30	51	33	36
4	Sestao Sport	30	52	37	36
5	CD Basconia	30	57	41	35
6	CD Laredo	30	35	54	29
7	Unión Club	30	29	45	29
8	Galdakao	30	43	48	28
9	Arenas Getxo	30	49	45	28
10	Santurtzi	30	40	38	28
11	Barreda	30	40	43	27
12	SD Erandio	30	38	46	27
13	Portugalete	30	35	33	26
14	CD Getxo	30	43	44	26
15	Jove	30	44	76	21
16	CD Guarnizo	30	41	71	18

TEMPORADA 1964/1965

TERCERA DIVISIÓN GRUPO 3
Equipo		PJ	GF	GC	Puntos
1	Gimnástica	30	87	34	44
2	Sestao Sport	30	53	37	40
3	Unión Club	30	47	38	35
4	Portugalete	30	48	43	33
5	Arenas Getxo	30	47	34	32
6	CD Laredo	30	38	47	32
7	Amorebieta	30	54	44	30
8	Deportivo	30	43	49	29
9	Santurtzi	30	44	45	29
10	CD Basconia	30	46	57	29
11	CD Getxo	30	46	48	29
12	SD Erandio	30	54	60	27
13	Sanvicenteñ	30	47	55	27
14	CD Guarnizo	30	39	60	24
15	Deusto	30	44	63	24
16	Laudio	30	34	57	16

TEMPORADA 1963/1964

TERCERA DIVISIÓN GRUPO 3
Equipo		PJ	GF	GC	Puntos
1	Barakaldo	30	67	30	51
2	Gimnástica	30	69	22	47
3	Arenas Getxo	30	62	24	44
4	Santurtzi	30	44	32	36
5	CD Getxo	30	59	47	34
6	Sestao Sport	30	42	30	33
7	CD Basconia	30	44	44	29
8	SD Erandio	30	40	52	27
9	Rayo	30	43	48	27
10	Amorebieta	30	46	53	27
11	Portugalete	30	27	39	27
12	CD Guarnizo	30	36	49	24
13	Unión Club	30	44	57	23
14	Barreda	30	31	63	20
15	Galdakao	30	47	67	19
16	CD Naval	30	23	67	12

TEMPORADA 1962/1963

TERCERA DIVISIÓN GRUPO 3
Equipo		PJ	GF	GC	Puntos
1	Barakaldo	30	58	26	42
2	Arenas Getxo	30	53	28	39
3	Amorebieta	30	76	42	38
4	Santurtzi	30	64	40	36
5	Sestao Sport	30	68	41	36
6	Galdakao	30	44	33	34
7	Deportivo	30	60	46	34
8	CD Getxo	30	58	58	33
9	Gimnástica	30	50	46	32
10	SD Erandio	30	62	55	29
11	CD Guarnizo	30	46	62	25
12	CD Naval	30	28	55	25
13	CD Laredo	30	37	51	24
14	Deusto	30	49	76	22
15	Santoña CF	30	39	77	18
16	Larramendi	30	28	84	13

Competiciones que juega

Tercera División Grupo 3

Pos	Equipos		Pts
1		Eibar	51
2		Aurrera KE	51
3		CD Basconia	48
4		Deusto	47
5		SD Amorebieta	46
6		Real Unión Club	43
7		Lemona	38
8		Deportivo Alavés B	37
9		SD Gernika	37
10		CD Lagun Onak	37
11		Santutxu	35
12		Anaitasuna FT	35
13		Zorroza	35
14		Bergara KE	34
15		CD Touring	33
16		Tolosa CF	33
17		CD Getxo	32
18		Arenas de Getxo	29
19		Balmaseda FC	29
20		CD Mungia	28

RIVALES EN Tercera División

USO DE MEMORIA

5,883,120 bytes

BENCHMARKS

Loading Time Base Classes	0.0012
Controller Execution Time ( Home / Category )	0.1002
Total Execution Time	0.1014

CADENA URL

/historico/Amorebieta/1982

GET DATOS

$_GET['/historico/Amorebieta/1982']

POST DATOS

No hay datos POST existentes

CONSULTAS (27)

0.0038	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 = 21686
0.0018	SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=213 AND type_rel = 2
0.0025	SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 2 AND rel.typeId = 213 AND rel.ln = 'es' ORDER BY rel.cover_points DESC LIMIT 5
0.0022	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 (2599,2827,7500,17749,42366) ORDER BY n.cover_points DESC, update_date DESC
0.0033	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 = '213' ORDER BY l.year DESC,cat.coefficient DESC
0.0026	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 = '213' 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 = 21686 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0025	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=213 AND l.year in (1981,1982,1983) 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 (21919,21703) 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.0019	SELECT count(id) as num_players from rel_players WHERE league_id = 21703 AND teamId = 213
0.0024	SELECT count(id) as num_players from rel_players WHERE league_id = 21919 AND teamId = 213
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* `tables1982` 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 = 21686 AND t.round = 38 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0030	SELECT p.* FROM `rel_pictures` as rp INNER JOIN `pictures` as p ON p.id = rp.id_picture INNER JOIN fa_user u ON u.id = p.author_id WHERE rp.id_content = '213' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0018	SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '213' and rp.type = 4
0.0028	SELECT p.* FROM `rel_videos` as rp INNER JOIN `videos` as p ON p.id = rp.id_video INNER JOIN fa_user u ON u.id = p.author_id WHERE rp.id_content = '213' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0019	SELECT count(id_content) as cuenta FROM `rel_videos` as rp WHERE rp.id_content = '213' and rp.type = 4
0.0021	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 events1982 e ON e.player_id = p.id AND e.league_id = 21686 WHERE rp.league_id = 21686 AND rp.teamId = 213 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.0023	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 events1982 e ON e.player_id = p.id AND e.league_id = 21686 WHERE rp.league_id = 21686 AND rp.teamId = 213 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 events1982 e ON e.player_id = p.id AND e.league_id = 21686 WHERE rp.league_id = 21686 AND rp.teamId = 213 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0034	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 = 213 AND l.year <= 1982 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.0030	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* `tables1982` 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 = 21686 AND t.round = 38 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* `tables1968` 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 = 21601 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0028	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* `tables1967` 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 = 22198 AND t.round = 30 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* `tables1966` 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 = 21588 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* `tables1965` 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 = 21575 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* `tables1964` 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 = 21562 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* `tables1963` 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 = 21549 AND t.round = 30 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

SD Amorebieta

SD Amorebieta

Selecciona un equipo

Competiciones que juega

Tercera División Grupo 3

RIVALES EN Tercera División