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.

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

CD Praviano

Entrenador: Lucho Varela

Temporada 1991/1992

TEMPORADA 1991/1992

TERCERA DIVISIÓN GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	Lealtad	38	67	34	52
2	Caudal	38	53	23	51
3	Langreo	38	58	28	51
4	Club Hispano	38	41	20	49
5	Marino	38	51	25	49
6	Real	38	51	29	48
7	Navia CF	38	57	46	43
8	Gijón	38	32	36	39
9	CD Turón	38	39	49	38
10	Santiago	38	39	39	36
11	Candás CF	38	26	37	36
12	Ribadesella	38	32	35	35
13	Club Siero	38	31	37	32
14	Pumarín CF	38	38	46	32
15	Universidad	38	44	56	31
16	Astur	38	25	38	31
17	CD Tuilla	38	39	57	29
18	Lada Langreo	38	31	58	28
19	CD Praviano	38	32	55	27
20	San Martín	38	32	70	23

TEMPORADA 1990/1991

TERCERA DIVISIÓN GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	Caudal	38	62	24	55
2	Club Hispano	38	56	26	55
3	Mosconia	38	61	33	52
4	Pumarín CF	38	50	33	46
5	CD Praviano	38	45	38	45
6	Marino	38	54	45	42
7	Santiago	38	42	35	42
8	CD Turón	38	48	39	39
9	Real	38	51	45	39
10	Lealtad	38	39	42	36
11	Navia CF	38	43	48	36
12	Gijón	38	48	49	35
13	Universidad	38	36	53	34
14	Candás CF	38	41	43	34
15	Ribadesella	38	37	47	33
16	Club Siero	38	32	45	33
17	Deportiva	38	47	55	33
18	Europa Nava	38	39	46	32
19	Asturias	38	28	60	24
20	Luarca CF	38	21	74	15

TEMPORADA 1989/1990

TERCERA DIVISIÓN GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	Real Oviedo	38	78	28	56
2	Club Hispano	38	77	29	55
3	Mosconia	38	65	43	50
4	Caudal	38	54	23	48
5	CD Praviano	38	37	34	42
6	Club Siero	38	30	31	41
7	Asturias	38	38	34	40
8	Ribadesella	38	28	39	39
9	Pumarín CF	38	43	47	38
10	CD Turón	38	50	56	36
11	Marino	38	37	42	36
12	Deportiva	38	50	46	35
13	Europa Nava	38	55	60	34
14	Real	38	41	46	34
15	Luarca CF	38	29	38	34
16	Santiago	38	36	57	33
17	Navia CF	38	32	49	31
18	Lenense	38	37	64	31
19	Lugones	38	28	58	24
20	Ribadedeva	38	25	46	23

TEMPORADA 1988/1989

TERCERA DIVISIÓN GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	Sporting	38	89	22	62
2	CD Turón	38	51	39	50
3	Caudal	38	52	30	50
4	CD Praviano	38	37	27	44
5	Mosconia	38	49	37	43
6	Real	38	51	40	43
7	Club Hispano	38	61	42	42
8	Asturias	38	30	24	42
9	Ribadesella	38	45	33	40
10	Marino	38	42	40	40
11	Deportiva	38	36	48	39
12	Lugones	38	45	49	37
13	Pumarín CF	38	44	54	36
14	Luarca CF	38	40	51	36
15	Lenense	38	40	50	32
16	Europa Nava	38	40	55	31
17	Club Siero	38	30	45	30
18	San Martín	38	29	49	29
19	Atlético	38	44	60	24
20	L´Entregu	38	24	84	10

TEMPORADA 1969/1970

TERCERA DIVISIÓN GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	Langreo	38	70	21	59
2	CD Lugo	38	64	25	53
3	Ensidesa	38	69	43	47
4	Caudal	38	41	36	45
5	Real Avilés	38	58	36	44
6	Candás CF	38	68	61	43
7	Martinenc	38	54	41	43
8	Real Oviedo	38	49	37	43
9	CD Turón	38	44	37	42
10	Compostela	38	63	39	41
11	Gijón	38	38	42	38
12	Deportivo	38	55	47	38
13	Celta	38	44	62	33
14	Celta Gran.	38	40	57	31
15	Ourense	38	32	56	30
16	Pontevedra	38	43	64	29
17	Alondras CF	38	44	69	27
18	L´Entregu	38	35	77	26
19	CD Praviano	38	31	59	24
20	Sporting	38	38	71	24

TEMPORADA 1968/1969

TERCERA DIVISIÓN GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	CD Ourense	38	85	14	63
2	Langreo	38	86	36	55
3	Compostela	38	88	27	54
4	Ensidesa	38	93	36	53
5	CD Lugo	38	59	42	44
6	Pontevedra	38	38	37	39
7	Martin	38	37	47	38
8	Candás CF	38	39	43	36
9	Deportivo	38	38	45	36
10	Celta Gran.	38	41	55	35
11	Real Oviedo	38	37	46	33
12	Sporting	38	38	63	33
13	Alondras CF	38	48	65	33
14	L´Entregu	38	53	76	32
15	CD Turón	38	45	80	32
16	CD Praviano	38	47	66	31
17	Club Lemos	38	39	59	30
18	Ourense	38	33	60	29
19	Caudal	38	32	43	27
20	Arosa	38	23	59	27

TEMPORADA 1967/1968

TERCERA DIVISIÓN GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	Real Avilés	30	92	19	49
2	Ensidesa	30	70	27	48
3	Candás CF	30	58	34	41
4	Gijón	30	50	33	38
5	Caudal	30	60	44	37
6	Real Oviedo	30	54	34	36
7	L´Entregu	30	48	40	33
8	Marino	30	34	37	30
9	San Martín	30	53	60	30
10	CD Praviano	30	42	36	29
11	CD Turón	30	33	35	29
12	Club Siero	30	28	56	24
13	Real	30	28	48	21
14	Carbayedo	30	33	58	18
15	Club Calzada	30	19	76	11
16	Santa	30	27	92	6

TEMPORADA 1966/1967

TERCERA DIVISIÓN GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	Real Avilés	30	84	20	47
2	Caudal	30	54	20	45
3	Candás CF	30	44	21	41
4	CD Praviano	30	61	31	39
5	Atlético	30	56	36	39
6	Ensidesa	30	64	31	38
7	Real Oviedo	30	54	48	33
8	San Martín	30	57	60	28
9	Club Calzada	30	42	47	26
10	Real	30	44	54	26
11	CD Turón	30	33	62	23
12	Luarca CF	30	30	57	23
13	L´Entregu	30	35	45	23
14	Santa	30	35	59	22
15	Club Siero	30	27	54	18
16	Pelayo CF	30	21	96	9

TEMPORADA 1965/1966

TERCERA DIVISIÓN GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	CD Praviano	30	64	26	50
2	Real Avilés	30	79	23	46
3	Caudal	30	62	34	43
4	Candás CF	30	47	27	39
5	Ensidesa	30	47	31	35
6	Atlético	30	57	37	35
7	Real Oviedo	30	74	45	34
8	San Martín	30	50	53	31
9	Luarca CF	30	32	50	27
10	Pelayo CF	30	37	50	25
11	Club Calzada	30	46	55	24
12	Club Siero	30	31	54	23
13	Santa	30	29	55	22
14	CD Turón	30	35	65	19
15	CD Lieres	30	38	76	15
16	UC Ceares	30	35	82	12

TEMPORADA 1964/1965

TERCERA DIVISIÓN GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	Real Avilés	30	72	17	50
2	CD Praviano	30	57	33	43
3	Caudal	30	59	31	41
4	Atlético	30	60	45	36
5	Martin	31	47	32	35
6	Llaranes CF	30	53	42	32
7	Real Oviedo	30	57	43	31
8	CD Turón	30	50	48	30
9	Candás CF	30	33	44	28
10	Luarca CF	30	34	46	26
11	CD Lieres	30	57	75	25
12	Pelayo CF	30	41	57	24
13	Santa Marina	29	39	62	23
14	Club Siero	30	38	53	23
15	Santiago	30	38	61	22
16	Esteban	30	30	76	11

TEMPORADA 1963/1964

TERCERA DIVISIÓN GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	Caudal	30	90	32	49
2	Real Avilés	30	75	21	48
3	Atlético	30	61	34	41
4	Llaranes CF	30	60	44	34
5	CD Turón	30	67	56	32
6	Club Siero	30	51	53	31
7	CD Praviano	30	50	47	30
8	Candás CF	30	42	40	29
9	Martinenc	30	44	51	29
10	Luarca CF	30	34	42	29
11	Pelayo CF	30	43	50	27
12	Santiago	30	34	57	26
13	Real Oviedo	30	38	57	26
14	Santa	30	35	57	21
15	Valdelacalza	30	29	72	16
16	Somió	30	41	81	12

TEMPORADA 1960/1961

TERCERA DIVISIÓN GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	Real Avilés	30	86	30	49
2	Circulo	30	61	25	47
3	Racing Sama	30	67	50	37
4	Caudal	30	52	40	33
5	L´Entregu	30	56	48	33
6	Club Siero	30	59	52	32
7	Lenense	30	42	62	29
8	CD Turón	30	49	53	28
9	Santiago	30	59	58	27
10	Luarca CF	30	53	52	27
11	Valdelacalza	30	50	53	26
12	San Martín	30	58	61	26
13	Pelayo CF	30	48	62	25
14	Marino	30	39	72	22
15	Real	30	47	84	21
16	CD Praviano	30	42	66	18

TEMPORADA 1959/1960

TERCERA DIVISIÓN GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	Caudal	30	85	20	50
2	Circulo	30	95	31	47
3	L´Entregu	30	80	44	38
4	CD Turón	30	52	46	35
5	Racing Sama	30	61	38	35
6	Santiago	30	57	42	34
7	San Martín	30	70	52	33
8	Luarca CF	30	62	55	32
9	Valdelacalza	30	52	52	29
10	CD Praviano	30	52	57	28
11	Club Siero	30	51	62	27
12	Real	30	51	64	25
13	Marino	30	41	71	22
14	Pelayo CF	30	41	67	21
15	Club Hispano	30	49	91	18
16	Rayo	30	22	129	6

TEMPORADA 1958/1959

TERCERA DIVISIÓN GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	Circulo	30	87	27	51
2	Caudal	30	85	23	51
3	Racing Sama	30	66	44	37
4	CD Turón	30	52	46	36
5	Santiago	30	50	47	32
6	Luarca CF	30	51	52	32
7	L´Entregu	30	48	43	31
8	Club Calzada	30	65	59	29
9	Club Hispano	30	50	53	28
10	Real	30	49	57	28
11	San Martín	30	36	46	25
12	Club Siero	30	46	60	24
13	CD Praviano	30	45	51	23
14	Marino	30	46	69	22
15	Rayo	30	30	81	16
16	Condal	30	31	79	15

Comparar equipos

CD Praviano

Selecciona un equipo

Competiciones que juega

RIVALES EN Copa del Rey

RIVALES EN Tercera División

USO DE MEMORIA

7,112,672 bytes

BENCHMARKS

Loading Time Base Classes	0.0012
Controller Execution Time ( Home / Category )	0.1379
Total Execution Time	0.1391

CADENA URL

/historico/Praviano/1992

GET DATOS

$_GET['/historico/Praviano/1992']

POST DATOS

No hay datos POST existentes

CONSULTAS (36)

0.0036	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 = 'Praviano' AND l.year = 1992 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=2013 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=2013 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=2013 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 = 21858
0.0020	SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=2013 AND type_rel = 2
0.0021	SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 2 AND rel.typeId = 2013 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 (532738,533325,822157,886617,1150986) ORDER BY n.cover_points DESC, update_date DESC
0.0027	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 = '2013' AND l.year = 1992 ORDER BY l.year DESC,cat.coefficient DESC
0.0024	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 = '2013' 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 = 21858 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0023	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=2013 AND l.year in (1991,1992,1993) ORDER BY l.id DESC, l.year DESC ;
0.0022	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 (21858,21853) 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 = 21858 AND teamId = 2013
0.0027	SELECT count(id) as num_players from rel_players WHERE league_id = 21853 AND teamId = 2013
0.0027	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 = '2013' 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 = '2013' and rp.type = 4
0.0020	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 = '2013' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0036	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 events1992 e ON e.player_id = p.id AND e.league_id = 21832 WHERE rp.league_id = 21832 AND rp.teamId = 2013 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.0031	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 events1992 e ON e.player_id = p.id AND e.league_id = 21832 WHERE rp.league_id = 21832 AND rp.teamId = 2013 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0037	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 events1992 e ON e.player_id = p.id AND e.league_id = 21832 WHERE rp.league_id = 21832 AND rp.teamId = 2013 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0035	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 = 2013 AND l.year <= 1992 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
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* `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 = 21858 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0027	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 = 21836 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0027	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* `tables1990` 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 = 21815 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* `tables1989` 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 = 21796 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
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* `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 = 20960 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* `tables1969` 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 = 20959 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 = 21600 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* `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 = 22197 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 = 21587 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* `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 = 21574 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* `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 = 21561 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* `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 = 21520 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* `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 = 21507 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* `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 = 21494 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC