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 1987/1988

TEMPORADA 1987/1988

TERCERA DIVISIÓN GRUPO 4
Equipo		PJ	GF	GC	Puntos
1	Barakaldo	38	62	26	53
2	Aurrera KE	38	48	28	51
3	CD Hernani	38	54	39	50
4	Tolosa CF	38	48	25	48
5	Real Unión	38	48	26	47
6	Santurtzi	38	45	29	47
7	CD Mungia	38	48	35	45
8	Deportivo	38	49	35	43
9	Amorebieta	38	55	45	42
10	SD Gernika	38	45	41	40
11	Mondragón	38	48	56	35
12	Anaitasuna	38	38	49	34
13	Arenas Getxo	38	42	50	33
14	Zalla	38	33	42	33
15	Pasajes	38	37	56	33
16	Galdakao	38	33	49	28
17	CD Touring	38	40	54	26
18	Portugalete	38	27	59	25
19	SD Erandio	38	31	55	24
20	Aretxabaleta	38	32	64	23

TEMPORADA 1986/1987

TERCERA DIVISIÓN GRUPO 4
Equipo		PJ	GF	GC	Puntos
1	SCD Durango	38	49	20	51
2	CD Basconia	38	59	26	50
3	Lemona	38	69	36	48
4	Barakaldo	38	58	38	48
5	Amorebieta	38	74	44	48
6	Santurtzi	38	54	33	47
7	Deportivo	38	58	37	47
8	Real Unión	38	39	34	41
9	Aurrera KE	38	33	35	37
10	Aretxabaleta	38	34	50	36
11	Zalla	38	43	56	36
12	Arenas Getxo	38	40	43	35
13	SD Erandio	38	35	44	34
14	Portugalete	38	22	31	32
15	CD Hernani	38	39	54	31
16	Tolosa CF	38	36	53	30
17	Anaitasuna	38	23	43	30
18	Mutriku FT	38	26	52	29
19	SD Gernika	38	34	59	28
20	Santutxu	38	26	63	22

TEMPORADA 1985/1986

TERCERA DIVISIÓN GRUPO 3
Equipo		PJ	GF	GC	Puntos
1	Eibar	38	85	23	58
2	Barakaldo	38	63	22	58
3	Santurtzi	38	51	28	51
4	CD Basconia	38	77	47	50
5	Amorebieta	38	80	40	49
6	SCD Durango	38	60	41	44
7	SD Erandio	38	58	49	41
8	Portugalete	38	38	51	39
9	Zalla	38	42	44	39
10	SD Gernika	38	64	53	39
11	Tolosa CF	38	41	44	36
12	Real Unión	38	52	50	36
13	Arenas Getxo	38	37	51	35
14	Anaitasuna	38	36	49	33
15	Santutxu	38	46	62	33
16	Mutriku FT	38	43	72	31
17	CD Hernani	38	35	59	27
18	CD Elgoibar	38	33	74	22
19	Bergara KE	38	27	68	20
20	Ortuella	38	25	66	19

TEMPORADA 1984/1985

TERCERA DIVISIÓN GRUPO 3
Equipo		PJ	GF	GC	Puntos
1	CD Basconia	38	53	19	56
2	Eibar	38	56	28	53
3	Amorebieta	38	50	26	50
4	Barakaldo	38	58	50	46
5	SCD Durango	38	58	36	45
6	Zalla	38	52	57	39
7	SD Gernika	38	41	39	38
8	Real Unión	38	54	47	37
9	Bergara KE	38	36	45	36
10	CD Hernani	38	46	57	35
11	Arenas Getxo	38	28	34	35
12	Tolosa CF	38	47	45	35
13	Santurtzi	38	38	33	35
14	Mutriku FT	38	36	49	34
15	Anaitasuna	38	45	53	34
16	Santutxu	38	40	46	33
17	Aurrera KE	38	38	48	32
18	Lemona	38	40	68	31
19	CD Getxo	38	46	58	29
20	Deusto	38	36	60	27

TEMPORADA 1983/1984

TERCERA DIVISIÓN GRUPO 3
Equipo		PJ	GF	GC	Puntos
1	Santurtzi	37	61	23	57
2	Eibar	38	55	25	54
3	SCD Durango	38	81	31	54
4	Real Unión	38	74	45	49
5	CD Getxo	37	48	33	46
6	Arenas Getxo	38	47	35	45
7	Aurrera KE	38	56	37	45
8	CD Basconia	38	58	44	43
9	Amorebieta	38	47	45	42
10	Lemona	38	50	45	41
11	Santutxu	38	42	46	41
12	Deusto	38	36	51	32
13	Bergara KE	38	36	48	31
14	SD Gernika	38	25	47	28
15	Anaitasuna	38	38	62	27
16	Tolosa CF	38	33	55	27
17	Aretxabaleta	38	35	61	27
18	SD Ilintxa	38	41	62	27
19	Mondragón	38	47	79	22
20	CD Touring	38	36	72	20

TEMPORADA 1982/1983

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

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

Comparar equipos

SD Amorebieta

Selecciona un equipo

Competiciones que juega

RIVALES EN Copa del Rey

RIVALES EN Tercera División

USO DE MEMORIA

7,170,464 bytes

BENCHMARKS

Loading Time Base Classes	0.0013
Controller Execution Time ( Home / Category )	0.1406
Total Execution Time	0.1419

CADENA URL

/historico/Amorebieta/1988

GET DATOS

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

POST DATOS

No hay datos POST existentes

CONSULTAS (39)

0.0033	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 = 'Amorebieta' AND l.year = 1988 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.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=213 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=213 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=213 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0041	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 = 21876
0.0028	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 = 21779
0.0018	SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=213 AND type_rel = 2
0.0024	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 (1312832,2599,2827,7500,17749) ORDER BY n.cover_points DESC, update_date DESC
0.0032	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' AND l.year = 1988 ORDER BY l.year DESC,cat.coefficient DESC
0.0027	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.0024	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 = 21876 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0019	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 = 21779 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0028	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 (1987,1988,1989) 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 (21877,21798) 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.0018	SELECT count(id) as num_players from rel_players WHERE league_id = 21798 AND teamId = 213
0.0025	SELECT count(id) as num_players from rel_players WHERE league_id = 21877 AND teamId = 213
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 FROM* `tables1988` 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 = 21876 AND t.round = 9 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0025	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.0027	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.0018	SELECT count(id_content) as cuenta FROM `rel_videos` as rp WHERE rp.id_content = '213' and rp.type = 4
0.0029	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 events1988 e ON e.player_id = p.id AND e.league_id = 21876 WHERE rp.league_id = 21876 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.0033	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 events1988 e ON e.player_id = p.id AND e.league_id = 21876 WHERE rp.league_id = 21876 AND rp.teamId = 213 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0025	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 events1988 e ON e.player_id = p.id AND e.league_id = 21876 WHERE rp.league_id = 21876 AND rp.teamId = 213 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0031	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 <= 1988 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
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* `tables1988` 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 = 21779 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* `tables1987` 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 = 21760 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* `tables1986` 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 = 21745 AND t.round = 38 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* `tables1985` 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 = 21731 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* `tables1984` 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 = 21716 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0048	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* `tables1983` 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 = 21703 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* `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.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* `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.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* `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.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* `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.0053	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