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

Utebo

Entrenador: Juan Carlos Beltrán

Temporada 1992/1993

TEMPORADA 1992/1993

TERCERA DIVISIÓN GRUPO 16
Equipo		PJ	GF	GC	Puntos
1	Huesca	38	84	32	60
2	Utebo	38	62	15	54
3	Barbastro	38	74	34	54
4	Casetas	38	59	35	52
5	Hernán	38	63	41	48
6	CD Teruel	38	50	29	47
7	CD Binéfar	38	48	32	47
8	Fraga	38	53	42	40
9	CD Ebro	38	48	53	37
10	Sabiñánigo	38	49	56	36
11	Tamarite	38	49	55	35
12	Almunia	38	43	61	34
13	Caspe	38	35	47	32
14	Sariñena	38	41	55	32
15	Atlético	38	35	49	30
16	Monzalbarba	38	42	71	30
17	Alcañiz	38	33	46	30
18	Alcolea CF	38	38	51	27
19	Ejea	38	28	71	21
20	Mallén	38	31	90	14

TEMPORADA 1991/1992

TERCERA DIVISIÓN GRUPO 17
Equipo		PJ	GF	GC	Puntos
1	Andorra	38	96	22	60
2	Barbastro	38	73	28	55
3	Utebo	38	64	25	55
4	Hernán	38	80	32	53
5	Atlético	38	61	35	50
6	Ejea	38	50	38	43
7	CD Teruel	38	48	45	43
8	Sabiñánigo	38	62	40	43
9	Monzalbarba	38	53	39	42
10	CD Ebro	38	52	53	41
11	Sariñena	38	46	53	38
12	Alcolea	38	41	59	35
13	Caspe	38	54	67	34
14	Mallén	38	36	54	33
15	Sta. Isabel	38	36	57	29
16	Peralta	38	35	75	25
17	Tauste CD	38	40	78	23
18	Alcorisa	38	36	66	22
19	Calatayud	38	34	69	22
20	CD Utrillas	38	30	92	14

TEMPORADA 1990/1991

TERCERA DIVISIÓN GRUPO 17
Equipo		PJ	GF	GC	Puntos
1	Fraga	38	95	29	65
2	Barbastro	38	71	22	55
3	Sabiñánigo	38	52	32	48
4	Calatayud	38	48	38	47
5	Atlético	38	49	34	46
6	Ejea	38	51	35	45
7	Alcorisa	38	52	53	43
8	Caspe	38	53	37	42
9	CD Utrillas	38	46	39	41
10	Monzalbarba	38	39	52	36
11	Utebo	38	47	53	34
12	CD Ebro	38	45	56	34
13	Tauste CD	38	32	46	34
14	Mallén	38	35	41	33
15	Peralta	38	43	53	33
16	Sariñena	38	36	56	31
17	Alcañiz	38	41	49	30
18	SD Tarazona	38	26	46	28
19	Almudévar	38	36	58	24
20	Biescas	38	19	87	11

TEMPORADA 1969/1970

TERCERA DIVISIÓN GRUPO 3
Equipo		PJ	GF	GC	Puntos
1	Logroñés	38	122	27	62
2	Eibar	38	109	34	58
3	Real	38	96	28	54
4	Txantrea	38	66	34	51
5	Huesca	38	74	39	49
6	Real Unión	38	64	38	48
7	Tudelano	38	86	39	47
8	Andorra	37	54	48	43
9	Deportivo	38	61	68	40
10	CD Iruña	38	71	66	37
11	Tolosa CF	38	58	55	36
12	Numancia	38	60	74	33
13	Barbastro	38	37	64	33
14	Oberena	38	62	71	32
15	Calahorra	38	57	70	32
16	Mutriku FT	38	48	74	27
17	Atlético	38	43	90	27
18	CD Binéfar	38	42	108	21
19	CD Teruel	38	42	96	20
20	Utebo	37	17	146	8

TEMPORADA 1967/1968

TERCERA DIVISIÓN GRUPO 5
Equipo		PJ	GF	GC	Puntos
1	Huesca	30	79	19	49
2	Deportivo	30	83	21	46
3	Barbastro	30	54	31	39
4	Andorra	30	75	38	38
5	CD Teruel	29	66	33	37
6	Numancia	30	62	40	36
7	Atlético	30	55	38	33
8	CD Binéfar	30	49	43	32
9	Mequinenza	30	55	60	30
10	Arenas	30	36	44	29
11	Calvo Sotelo	30	44	75	25
12	Ejea	30	60	67	24
13	Jacetano	30	40	80	19
14	Utebo	30	31	67	16
15	Caspe	29	30	90	14
16	CF Epila	30	33	106	11

TEMPORADA 1966/1967

TERCERA DIVISIÓN GRUPO 5
Equipo		PJ	GF	GC	Puntos
1	Huesca	30	71	16	52
2	Deportivo	30	105	20	48
3	Andorra	30	57	27	40
4	Ejea	30	33	42	35
5	Calvo Sotelo	30	63	46	34
6	Barbastro	30	43	33	34
7	Arenas	30	34	53	30
8	CD Teruel	30	50	46	29
9	Mequinenza	30	64	60	29
10	Caspe	30	39	59	27
11	Jacetano	30	39	57	27
12	Utebo	30	34	62	22
13	CD Binéfar	30	41	51	21
14	Atlético	30	42	64	21
15	Numancia	30	28	68	19
16	Renfe	30	30	69	12

TEMPORADA 1965/1966

TERCERA DIVISIÓN GRUPO 5
Equipo		PJ	GF	GC	Puntos
1	Numancia	28	84	21	45
2	Andorra	28	70	21	43
3	Huesca	28	73	22	39
4	CD Teruel	28	47	31	37
5	Barbastro	28	47	42	34
6	Atlético	28	52	41	32
7	Calvo Sotelo	28	40	41	32
8	Utebo	28	36	50	24
9	Arenas	28	35	48	23
10	Jacetano	28	46	60	23
11	Ejea	28	43	53	23
12	Mequinenza	28	50	64	22
13	Endesa	28	30	69	18
14	Caspe	28	27	67	16
15	Deportivo	28	21	71	9
16	Alcañiz	0	0	0	0

TEMPORADA 1958/1959

TERCERA DIVISIÓN GRUPO 5
Equipo		PJ	GF	GC	Puntos
1	U.D. Amistad	30	88	34	45
2	Arenas	30	77	30	41
3	Calatayud	30	69	41	41
4	Fraga	30	61	37	40
5	Ejea	30	66	36	39
6	Atlético	30	56	54	32
7	Numancia	30	51	52	30
8	CD Teruel	30	55	45	27
9	Mequinenza	30	54	64	27
10	Andorra	30	52	61	26
11	Gallur CD	30	53	68	25
12	CD Binéfar	30	39	74	25
13	Utebo	30	36	69	25
14	Barbastro	30	45	67	22
15	Triasu	30	33	78	18
16	Tauste CD	30	33	58	17

TEMPORADA 1957/1958

TERCERA DIVISIÓN GRUPO 5
Equipo		PJ	GF	GC	Puntos
1	Ejea	34	94	38	48
2	U.D. Amistad	33	79	33	44
3	Numancia	34	86	56	43
4	Arenas	34	65	34	43
5	Fraga	34	71	51	43
6	Barbastro	34	69	54	40
7	CD Binéfar	33	63	56	33
8	Triasu	34	64	67	32
9	Tauste CD	34	59	60	32
10	Calatayud	34	55	68	32
11	Mequinenza	34	53	61	31
12	Atlético	34	68	69	31
13	CD Teruel	34	52	60	30
14	Gallur CD	34	49	59	29
15	Utebo	34	42	91	27
16	Sabiñánigo	34	43	68	26
17	Caspe	34	41	80	24
18	Jacetano	34	38	86	19
19	Cariñena	0	0	0	0

TEMPORADA 1956/1957

TERCERA DIVISIÓN GRUPO 5
Equipo		PJ	GF	GC	Puntos
1	Arenas	34	99	42	50
2	CD Binéfar	34	104	39	49
3	Tauste CD	34	78	47	43
4	CD Teruel	34	67	45	41
5	Calatayud	34	79	59	41
6	U.D. Amistad	34	67	51	39
7	Barbastro	34	66	60	37
8	Fraga	34	57	48	35
9	Triasu	34	70	101	33
10	Numancia	34	55	67	33
11	CD Mojácar	34	60	84	31
12	Gallur CD	34	59	65	30
13	Ejea	34	54	71	30
14	Atlético	34	55	73	28
15	Caspe	34	44	81	25
16	Mequinenza	34	67	75	24
17	Utebo	34	44	75	22
18	Cariñena	34	49	91	21

TEMPORADA 1955/1956

TERCERA DIVISIÓN GRUPO 5
Equipo		PJ	GF	GC	Puntos
1	Arenas	18	30	16	23
2	Calatayud	18	32	23	23
3	U.D. Amistad	18	28	20	22
4	Numancia	18	36	36	19
5	Tauste CD	18	33	32	19
6	CD Binéfar	18	35	31	18
7	UD Huesca	18	31	31	17
8	Montañanesa	18	25	34	15
9	Gallur CD	18	25	31	14
10	Utebo	18	19	40	10

TEMPORADA 1954/1955

TERCERA DIVISIÓN GRUPO 5
Equipo		PJ	GF	GC	Puntos
1	Arenas	17	32	14	25
2	CD Binéfar	18	40	25	23
3	Numancia	18	33	26	20
4	Calatayud	18	31	27	20
5	Utebo	18	27	28	19
6	Montañanesa	18	31	31	18
7	U.D. Amistad	18	35	38	15
8	Gallur CD	18	25	41	13
9	UD Huesca	17	24	30	12
10	Celta	18	23	41	12

Comparar equipos

Utebo

Selecciona un equipo

Competiciones que juega

RIVALES EN Copa del Rey

RIVALES EN Tercera División

USO DE MEMORIA

6,694,480 bytes

BENCHMARKS

Loading Time Base Classes	0.0012
Controller Execution Time ( Home / Category )	0.5938
Total Execution Time	0.5950

CADENA URL

/historico/Utebo/1993

GET DATOS

$_GET['/historico/Utebo/1993']

POST DATOS

No hay datos POST existentes

CONSULTAS (35)

0.0139	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 = 'Utebo' AND l.year = 1993 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.0125	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=2637 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0126	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=2637 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0125	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=2637 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0253	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 = 21895
0.0129	SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=2637 AND type_rel = 2
0.0135	SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 2 AND rel.typeId = 2637 AND rel.ln = 'es' ORDER BY rel.cover_points DESC LIMIT 5
0.0140	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 (225942,754593,822157,886617,1036071) ORDER BY n.cover_points DESC, update_date DESC
0.0160	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 = '2637' AND l.year = 1993 ORDER BY l.year DESC,cat.coefficient DESC
0.0185	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 = '2637' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0131	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 = 21895 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0144	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=2637 AND l.year in (1992,1993,1994) ORDER BY l.id DESC, l.year DESC ;
0.0131	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 (22256,21895,21773) 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.0139	SELECT count(id) as num_players from rel_players WHERE league_id = 22256 AND teamId = 2637
0.0133	SELECT count(id) as num_players from rel_players WHERE league_id = 21895 AND teamId = 2637
0.0177	SELECT count(id) as num_players from rel_players WHERE league_id = 21773 AND teamId = 2637
0.0128	SELECT t.,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff FROM* `tables1993` 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 = 21773 AND t.round = 9 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0132	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 = '2637' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0125	SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '2637' and rp.type = 4
0.0127	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 = '2637' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0144	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 events1993 e ON e.player_id = p.id AND e.league_id = 21773 WHERE rp.league_id = 21773 AND rp.teamId = 2637 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.0145	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 events1993 e ON e.player_id = p.id AND e.league_id = 21773 WHERE rp.league_id = 21773 AND rp.teamId = 2637 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0140	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 events1993 e ON e.player_id = p.id AND e.league_id = 21773 WHERE rp.league_id = 21773 AND rp.teamId = 2637 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0130	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 = 2637 AND l.year <= 1993 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.0131	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* `tables1993` 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 = 21895 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0130	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* `tables1992` 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 = 21874 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0130	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* `tables1991` 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 = 21851 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0132	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* `tables1970` 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 = 21621 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0129	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 = 21603 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0130	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 = 22200 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0129	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 = 21590 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0129	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 = 21497 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0131	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 = 21481 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0129	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 = 21463 AND t.round = 18 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0131	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 = 21420 AND t.round = 18 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC