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

Sportivo Estudiantes

Temporada 2023/2024

TEMPORADA 2023/2024

TORNEO FEDERAL A TRANSICIÓN GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	Ciudad	6	10	2	16
2	Martín	6	5	2	11
3	Juventud	6	4	2	9
4	Argentino	6	6	5	9
5	Huracán	6	5	6	9
6	Gutiérrez	6	5	6	7
7	Camioneros	6	5	5	6
8	Sportivo	6	6	9	6
9	CSyB Atenas	6	5	8	5
10	Ferro	6	3	9	4

TEMPORADA 2022/2023

TORNEO FEDERAL A TRANSICIÓN GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	Ciudad	32	45	25	59
2	Argentino	32	53	27	58
3	Juventud	32	33	23	51
4	CSyB Atenas	32	43	42	44
5	Huracán	32	29	39	43
6	Martín	32	29	34	39
7	Ferro	32	31	38	37
8	Sportivo	32	33	41	35
9	Sportivo	32	30	57	25

TEMPORADA 2021/2022

TORNEO FEDERAL A TRANSICIÓN GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	Olimpo	32	53	19	73
2	Villa Mitre	32	42	25	57
3	Ciudad	32	30	28	49
4	Independient	32	33	22	47
5	CSYD Mayo	32	32	26	46
6	Sportivo	32	34	29	46
7	Juventud	32	28	25	45
8	Sansinena	32	44	42	42
9	Argentino	32	29	34	40
10	Cipolletti	32	26	35	38
11	Sportivo	32	31	42	37
12	Circulo	32	31	40	36
13	CA Liniers	32	34	44	36
14	Huracán	32	23	26	35
15	Ferro	32	28	32	35
16	Sportivo	32	24	36	34
17	Camioneros	32	27	44	31

TEMPORADA 2020/2021

TORNEO FEDERAL A TRANSICIÓN GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	Deportivo	30	39	23	56
2	CSYD Mayo	30	32	24	50
3	Cipolletti	30	41	26	49
4	Olimpo	30	42	32	49
5	Sportivo	30	44	38	49
6	Independient	30	30	21	48
7	Juventud	30	28	18	47
8	Villa Mitre	30	35	28	45
9	Ferro	30	39	38	43
10	Sportivo	30	29	37	43
11	Sansinena	30	38	37	40
12	Ciudad	30	30	28	38
13	Huracán	30	38	40	35
14	Deportivo	30	25	34	29
15	Sportivo	30	18	48	15
16	Circulo	30	18	54	13

TEMPORADA 2019/2020

TORNEO FEDERAL A TRANSICIÓN GRUPO 4
Equipo		PJ	GF	GC	Puntos
1	Sportivo	4	8	3	10
2	Gualeguaychu	4	10	8	5
3	Boca Unidos	4	6	6	5
4	Unión	4	5	5	4
5	Defensores	4	2	9	1
6	Deportivo	6	5	0	14
7	Sportivo	6	4	2	9
8	Sportivo	6	5	5	8
9	CSYD Mayo	6	4	7	8
10	Sportivo	6	6	5	7
11	Cipolletti	6	3	3	7
12	Circulo	6	0	5	2

TEMPORADA 2018/2019

TORNEO FEDERAL A TRANSICIÓN GRUPO 6
Equipo		PJ	GF	GC	Puntos
1	Deportivo	8	12	5	16
2	Cipolletti	8	11	5	12
3	Ferro	8	12	7	11
4	Independient	8	7	16	7
5	Dep. Roca	8	5	14	6
6	Sportivo	8	12	8	14
7	Def.	8	11	7	14
8	Douglas Haig	8	11	7	13
9	Atlético	8	9	15	6
10	Gualeguaychu	8	7	13	6
11	Sportivo	8	10	7	15
12	Sportivo	8	15	11	13
13	Racing	8	13	10	11
14	Juventud	8	8	12	10
15	Lorenzo Alem	8	11	17	3
16	Martín	8	14	6	17
17	Juventud	8	8	8	11
18	Crucero	8	5	6	10
19	Altos Hornos	8	5	6	9
20	Gimnasia	8	4	10	8

TEMPORADA 2017/2018

PRIMERA NACIONAL GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	Almagro	24	31	16	41
2	Aldosivi	24	30	22	41
3	Martín	24	29	21	39
4	Brown	24	27	20	37
5	Sarmiento	24	31	27	37
6	Instituto	24	22	19	37
7	Atletico	24	34	22	36
8	Villa	24	24	17	36
9	Argentino	24	30	28	35
10	Gimnasia	24	18	11	34
11	Deportivo	24	22	23	33
12	Quilmes	24	24	23	32
13	Atlético	24	21	22	32
14	Indep.	24	20	19	31
15	Gualeguaychu	24	20	29	30
16	Guillermo	24	25	27	28
17	Los Andes	24	17	22	27
18	Ferro Carril	24	21	31	26
19	Dep. Riestra	24	29	24	25
20	Sportivo	24	13	19	25
21	Boca Unidos	24	23	31	25
22	All Boys	24	24	33	25
23	Nueva	24	20	31	25
24	Flandria	24	28	36	24
25	Dep.	24	20	30	24

TEMPORADA 2016/2017

PRIMERA NACIONAL
Equipo		PJ	GF	GC	Puntos
1	Argentinos	44	61	24	88
2	Chacarita	44	57	40	77
3	Guillermo	44	53	30	75
4	Indep.	44	48	44	67
5	Brown	44	57	50	65
6	Instituto	44	58	51	63
7	All Boys	44	43	45	62
8	Dep.	44	45	43	61
9	Martín	44	62	54	61
10	Almagro	44	35	34	60
11	Ferro Carril	44	51	44	60
12	Nueva	44	53	47	60
13	Los Andes	44	47	50	59
14	Central	44	57	49	58
15	Flandria	44	39	40	56
16	Gualeguaychu	44	50	66	55
17	Sportivo	44	40	58	54
18	Gimnasia	44	36	45	52
19	Douglas Haig	44	36	49	50
20	Boca Unidos	44	42	54	47
21	Villa	44	45	60	47
22	Atlético	44	34	58	38
23	Crucero	44	36	50	37

TEMPORADA 2015/2016

PRIMERA NACIONAL
Equipo		PJ	GF	GC	Puntos
1	Talleres	21	31	11	49
2	Chacarita	21	30	12	43
3	Gimnasia	21	26	16	38
4	Boca Unidos	21	28	19	38
5	Villa	21	35	28	33
6	Crucero	21	26	25	32
7	Nueva	21	32	27	30
8	Guillermo	21	31	29	30
9	Los Andes	21	21	22	30
10	Brown	21	27	26	28
11	Gualeguaychu	21	25	26	28
12	Almagro	21	23	25	28
13	Dep.	21	16	19	27
14	All Boys	21	30	28	26
15	Ferro Carril	21	21	27	26
16	Sportivo	21	17	25	24
17	Juventud	21	20	23	22
18	Central	21	23	27	21
19	Douglas Haig	21	20	24	20
20	Indep.	21	14	26	20
21	Atlético	21	16	32	19
22	Instituto	21	18	33	16

TEMPORADA 2014/2015

PRIMERA NACIONAL
Equipo		PJ	GF	GC	Puntos
1	Atl.	42	69	31	85
2	Patronato	42	60	24	82
3	Ferro Carril	42	44	37	67
4	Dep.	42	54	40	66
5	Instituto	42	48	38	62
6	Villa	42	44	42	60
7	Atlético	42	50	46	58
8	Douglas Haig	42	45	46	58
9	Sportivo	42	47	44	56
10	Gimnasia	42	35	43	55
11	Los Andes	42	46	49	54
12	Gualeguaychu	42	43	47	54
13	Boca Unidos	42	37	42	54
14	All Boys	42	38	37	53
15	Central	42	37	44	51
16	Indep.	42	38	46	51
17	Guaraní	42	38	43	50
18	Chacarita	42	49	62	50
19	Guillermo	42	43	50	48
20	Gimnasia	42	37	53	48
21	Sportivo	42	36	50	40
22	Unión Plata	42	36	60	37

TEMPORADA 2013/2014

ARGENTINO A
Equipo		PJ	GF	GC	Puntos
1	Tiro Federal	22	30	20	35
2	Guaraní	22	19	20	35
3	Martín	22	21	16	34
4	Gualeguaychu	22	22	19	34
5	Central	22	23	23	31
6	Jorge	22	22	23	31
7	Juventud	22	21	17	30
8	Libertad	22	22	19	30
9	Central	22	26	27	26
10	Gimnasia	22	25	36	25
11	Gimnasia	22	26	30	21
12	Chaco Ever	22	24	31	21
13	Dep.	22	33	21	45
14	Juventud	22	35	20	38
15	Defensores	22	34	23	37
16	Guillermo	22	31	24	33
17	CAI	22	37	33	33
18	Cipolletti	22	29	25	32
19	Dep. Maipú	22	24	32	29
20	Unión Plata	22	26	27	28
21	Alvarado	22	13	16	27
22	Sportivo	22	28	32	27
23	Racing	22	22	37	18
24	Rivadavia	22	18	40	15

Competiciones que juega

Grupo 2

Torneo Federal A Transición Grupo 2

Pos	Equipos		Pts
1		Ciudad De Bolívar	16
2		San Martín Mendoza	11
3		Juventud Universitario	9
4		Argentino Monte Maíz	9
5		Huracán Las Heras	9
6		Gutiérrez	7
7		Camioneros Bs As	6
8		Sportivo Estudiantes	6
9		CSyB Atenas	5
10		Ferro General Pico	4

	Playoff Ascenso : Ciudad De Bolívar, San Martín Mendoza, Juventud Universitario, Argentino Monte Maíz, Huracán Las Heras
	Playoff Descenso : Gutiérrez, Camioneros Bs As, Sportivo Estudiantes, CSyB Atenas, Ferro General Pico

RIVALES EN Torneo Federal A.

USO DE MEMORIA

6,217,992 bytes

BENCHMARKS

Loading Time Base Classes	0.0016
Controller Execution Time ( Home / Category )	0.6141
Total Execution Time	0.6157

CADENA URL

/historico/Estudiantes-De-San-Luis

GET DATOS

$_GET['/historico/Estudiantes-De-San-Luis']

POST DATOS

No hay datos POST existentes

CONSULTAS (32)

0.0294	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 = 75541
0.0145	SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=11962 AND type_rel = 2
0.0147	SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 2 AND rel.typeId = 11962 AND rel.ln = 'es' ORDER BY rel.cover_points DESC LIMIT 5
0.0148	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 (40668,46803,67872,68205,69281) ORDER BY n.cover_points DESC, update_date DESC
0.0149	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 = '11962' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0148	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 = 75541 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0157	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=11962 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0149	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 (75541) 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.0158	SELECT count(id) as num_players from rel_players WHERE league_id = 75541 AND teamId = 11962
0.0149	SELECT t.,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff FROM* `tables2024` 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 = 75541 AND t.round = 7 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0148	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 = '11962' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0145	SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '11962' and rp.type = 4
0.0146	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 = '11962' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0153	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 events2024 e ON e.player_id = p.id AND e.league_id = 75541 WHERE rp.league_id = 75541 AND rp.teamId = 11962 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.0152	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 events2024 e ON e.player_id = p.id AND e.league_id = 75541 WHERE rp.league_id = 75541 AND rp.teamId = 11962 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0147	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 events2024 e ON e.player_id = p.id AND e.league_id = 75541 WHERE rp.league_id = 75541 AND rp.teamId = 11962 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0150	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 = 11962 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.0149	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* `tables2024` 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 = 75541 AND t.round = 7 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0149	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* `tables2023` 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 = 71106 AND t.round = 36 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0151	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* `tables2022` 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 = 66958 AND t.round = 34 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0149	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* `tables2021` 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 = 61892 AND t.round = 30 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0152	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* `tables2020` 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 = 51043 AND t.round = 23 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0151	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* `tables2020` 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 = 60172 AND t.round = 7 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0150	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* `tables2019` 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 = 45043 AND t.round = 18 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0149	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* `tables2019` 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 = 48455 AND t.round = 10 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0153	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* `tables2018` 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 = 39647 AND t.round = 25 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0151	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* `tables2017` 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 = 33440 AND t.round = 46 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0150	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* `tables2016` 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 = 20209 AND t.round = 21 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0149	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* `tables2015` 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 = 3988 AND t.round = 14 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0152	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* `tables2015` 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 = 9170 AND t.round = 42 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0150	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* `tables2014` 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 = 2548 AND t.round = 22 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0146	SELECT dt.nameShow, dt.basealias, t.id, dt.id as dt_id FROM `teams` as t INNER JOIN `datateams` as dt ON dt.id = t.teamId WHERE league_id = 75541 ORDER BY nameShow LIMIT 100

Sportivo Estudiantes

Sportivo Estudiantes

Selecciona un equipo

Competiciones que juega

Torneo Federal A Transición Grupo 2

RIVALES EN Torneo Federal A.