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 Desamparados

Temporada 2023/2024

TEMPORADA 2023/2024

TORNEO REGIONAL FEDERAL AMATEUR GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	Argentino	6	9	3	12
2	Porvenir	6	9	7	10
3	Deportivo	6	4	6	7
4	Andes FC	6	3	9	4
5	Huracán	6	12	2	14
6	Pacífico	6	10	4	13
7	Pedal	6	5	10	3
8	Vialidad	6	3	14	2
9	Deportivo	6	11	4	16
10	La Libertad	6	10	6	11
11	Unión Vista	6	6	13	4
12	Carlos	6	4	8	2
13	Gutiérrez	6	14	6	14
14	Argentino	6	11	10	10
15	Deportivo	6	9	13	6
16	Atlético	6	10	15	4
17	FADEP	6	14	3	15
18	Luján Sport	6	5	7	8
19	Academia	6	3	6	5
20	Andes	6	2	8	5
21	Andes Tudcum	4	9	8	7
22	Arbol Verde	4	5	4	7
23	Martín	4	6	8	2
24	Atlético	6	19	7	14
25	Miguel Juan	6	14	5	14
26	Villa Arturo	6	5	18	4
27	Defensores	6	4	12	1
28	Mayo Santa.	6	7	3	13
29	Sol de Mayo	6	9	8	8
30	Sportivo	6	9	8	6
31	Sportivo	6	5	11	5
32	Sportivo	6	8	6	10
33	Sportivo	6	6	4	8
34	Lorenzo	6	7	11	7
35	Atlético	6	7	7	6
36	Juventud	6	13	9	12
37	Unión Villa	6	13	7	11
38	Trinidad	6	9	8	9
39	Independient	6	5	16	1
40	Juventud	4	7	3	9
41	Sportivo	4	7	9	6
42	Atlético	4	4	6	3
43	Jorge	4	8	3	10
44	Huracán	4	6	6	4
45	Naschel	4	4	9	3
46	Sarmiento	4	7	1	10
47	Aviador	4	4	1	5
48	Totora	4	1	10	1
49	Ranqueles	4	5	1	9
50	Deportivo	4	8	4	7
51	Colegiales	4	2	10	1

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 5
Equipo		PJ	GF	GC	Puntos
1	Alvarado	7	10	6	12
2	Defensores	7	9	7	12
3	Gimnasia	7	10	7	11
4	Sansinena	7	7	4	11
5	Villa Mitre	7	8	5	10
6	Unión	7	9	12	8
7	Deportivo	7	10	17	4
8	CSYD Mayo	7	7	12	3
9	Estudiantes	7	16	8	15
10	Sarm.	7	9	5	12
11	Jorge	7	16	11	11
12	Chaco Ever	7	13	12	11
13	Huracán	7	6	10	9
14	Sportivo	7	4	8	8
15	Dep. Maipú	7	9	14	6
16	Boca Unidos	7	5	10	5

TEMPORADA 2017/2018

TORNEO FEDERAL A TRANSICIÓN GRUPO 5
Equipo		PJ	GF	GC	Puntos
1	Estudiantes	7	13	6	15
2	Gimnasia	7	11	6	14
3	Juventud	7	9	7	13
4	Alvarado	7	8	8	10
5	Dep. Roca	7	12	14	9
6	Sportivo	7	4	6	8
7	Villa Mitre	7	6	10	5
8	Ferro	7	5	11	5
9	Central	7	10	5	14
10	Defensores	7	11	5	13
11	Unión	7	9	8	10
12	Sportivo	7	8	7	10
13	Crucero	7	7	6	10
14	Sarm.	7	5	9	9
15	Chaco Ever	7	5	8	6
16	Gimnasia	7	7	14	6

TEMPORADA 2016/2017

TORNEO FEDERAL A TRANSICIÓN GRUPO 3
Equipo		PJ	GF	GC	Puntos
1	Dep. Maipú	10	10	8	17
2	Rivadavia	10	11	9	16
3	Independient	10	9	7	16
4	Dep. Roca	10	11	11	13
5	Belgrano	10	12	13	10
6	Ferro	10	10	15	10
7	Gutiérrez	10	14	15	16
8	Lorenzo Alem	10	14	9	15
9	Juventud	10	11	13	14
10	Jorge	10	13	9	13
11	Sportivo	10	10	12	11
12	Concepción	10	11	15	8
13	Sportivo	10	16	15	16
14	Guaraní	10	15	15	14
15	Def.	10	14	12	13
16	Libertad	10	12	10	13
17	Gimnasia	10	17	18	11
18	América	10	11	15	10

TEMPORADA 2015/2016

TORNEO REGIONAL FEDERAL AMATEUR GRUPO 7
Equipo		PJ	GF	GC	Puntos
1	Sportivo	10	11	8	17
2	Sportivo	10	12	12	16
3	Atlético	10	11	10	15
4	Juventud	10	11	9	14
5	Trinidad	10	15	11	13
6	Luján Cuyo	10	10	20	11

TEMPORADA 2014/2015

TORNEO REGIONAL FEDERAL AMATEUR GRUPO 9
Equipo		PJ	GF	GC	Puntos
1	Juventud	20	19	14	31
2	Sportivo	20	27	24	30
3	Sportivo	20	24	22	30
4	Trinidad	20	17	15	30
5	Luján Cuyo	20	25	23	28
6	Independient	20	25	20	27
7	Martín	20	20	21	27
8	Centro	20	15	19	27
9	Atlético	20	23	23	26
10	Sportivo	20	28	32	21
11	Atenas	20	17	27	19

TEMPORADA 2013/2014

ARGENTINO B GRUPO 4
Equipo		PJ	GF	GC	Puntos

TEMPORADA 2012/2013

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

TEMPORADA 2011/2012

PRIMERA NACIONAL
Equipo		PJ	GF	GC	Puntos
1	River Plate	38	66	28	73
2	Quilmes	38	62	21	72
3	Instituto	38	56	28	70
4	Rosario	38	49	33	69
5	Boca Unidos	38	55	48	57
6	Patronato	38	41	38	56
7	Ferro Carril	38	29	28	56
8	Almirante	38	36	30	55
9	Gimnasia	38	38	33	54
10	Defensa	38	50	50	54
11	Aldosivi	38	50	47	53
12	CA Huracán	38	43	50	46
13	Indep.	38	35	50	45
14	Deportivo	38	28	38	43
15	Atl.	38	33	49	42
16	Guillermo	38	46	63	38
17	Sportivo	38	34	55	37
18	Gimnasia	38	32	50	34
19	Atlanta	38	28	50	34
20	Chacarita	38	24	46	32

TEMPORADA 2010/2011

ARGENTINO A GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	Guillermo	8	16	5	19
2	Central	8	12	10	16
3	Libertad	8	13	12	11
4	Unión Plata	8	12	11	11
5	Sportivo	8	8	8	11
6	Unión	8	12	11	10
7	Sportivo	8	7	10	9
8	Talleres	8	10	13	8
9	Huracán	8	6	16	4

Competiciones que juega

Grupo 2

Torneo Regional Federal Amateur Grupo 2

Pos	Equipos		Pts
1		Deportivo la Dormida	16
2		FADEP	15
3		Atlético Peñaflor	14
4		Huracán San Rafael	14
5		San Miguel San Juan	14
6		Gutiérrez	14
7		Pacífico Gral. Alvear	13
8		25 de Mayo Santa Rosa	13
9		Argentino General Alvear	12
10		Juventud Alianza	12
11		Unión Villa Krause	11
12		La Libertad	11
13		Sarmiento Juventud Unida	10
14		Jorge Newbery VM	10
15		El Porvenir Mendoza	10
16		Sportivo Rivadavia	10
17		Argentino Mendoza	10
18		Juventud Zondina	9
19		Los Ranqueles Galia	9
20		Trinidad San Juan	9
21		Sportivo Desamparados	8
22		Sol de Mayo	8
23		Luján Sport	8
24		Deportivo la Punta	7
25		Los Andes Tudcum	7
26		Arbol Verde Jachal	7
27		Deportivo Malargüe	7
28		San Lorenzo Ullum	7
29		Sportivo Divisadero	6
30		Atlético Colon Junior	6
31		Sportivo del Bono	6
32		Deportivo Rivadavia	6
33		Aviador Origone	5
34		Academia Chacras	5
35		Sportivo del Carril	5
36		Andes Talleres	5
37		Huracán San Luis	4
38		Atlético Palmira	4
39		Andes FC	4
40		Unión Vista Flores	4
41		Villa Don Arturo	4
42		Atlético Marquesado	3
43		Pedal	3
44		Naschel Unidos	3
45		San Martín Rodeo	2
46		SC San Carlos	2
47		Vialidad Nacional	2
48		Defensores Los Berros	1
49		Colegiales V Mercedes	1
50		La Totora Candelaria	1
51		Independiente Villa Obrera	1

	Siguiente Ronda : Deportivo la Dormida
	Posible siguiente ronda : FADEP

RIVALES EN Torneo Regional.

USO DE MEMORIA

6,850,448 bytes

BENCHMARKS

Loading Time Base Classes	0.0013
Controller Execution Time ( Home / Category )	0.7056
Total Execution Time	0.7070

CADENA URL

/historico/Cs-Desamparados

GET DATOS

$_GET['/historico/Cs-Desamparados']

POST DATOS

No hay datos POST existentes

CONSULTAS (44)

0.0137	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 = 'Cs-Desamparados' AND l.year = 2024 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.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=5900 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=5900 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 = 74426
0.0125	SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=5900 AND type_rel = 2
0.0127	SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 2 AND rel.typeId = 5900 AND rel.ln = 'es' ORDER BY rel.cover_points DESC LIMIT 5
0.0128	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 (199594,578764,594567,792663) ORDER BY n.cover_points DESC, update_date DESC
0.0132	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 = '5900' ORDER BY l.year DESC,cat.coefficient DESC
0.0129	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 = '5900' AND l.year = 2024 ORDER BY l.year DESC,cat.coefficient DESC
0.0129	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 = '5900' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0130	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 = 74426 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0131	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=5900 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0126	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 (74426) 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.0125	SELECT count(id) as num_players from rel_players WHERE league_id = 74426 AND teamId = 5900
0.0135	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 = 74426 AND t.round = 6 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0127	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 = '5900' 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 = '5900' and rp.type = 4
0.0128	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 = '5900' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0125	SELECT count(id_content) as cuenta FROM `rel_videos` as rp WHERE rp.id_content = '5900' and rp.type = 4
0.0127	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 = 74426 WHERE rp.league_id = 74426 AND rp.teamId = 5900 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.0127	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 = 74426 WHERE rp.league_id = 74426 AND rp.teamId = 5900 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0126	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 = 74426 WHERE rp.league_id = 74426 AND rp.teamId = 5900 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0134	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 = 5900 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.0133	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 = 74426 AND t.round = 6 ORDER BY team.conference ASC,t.position 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* `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.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* `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.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* `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.0127	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.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* `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.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* `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 = 48454 AND t.round = 7 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* `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 = 40143 AND t.round = 18 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
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,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 = 41924 AND t.round = 7 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* `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 = 34104 AND t.round = 20 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
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,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 = 37688 AND t.round = 10 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* `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 = 20292 AND t.round = 10 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0139	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 = 19805 AND t.round = 7 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
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,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 = 4489 AND t.round = 14 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* `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 = 15591 AND t.round = 22 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0126	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 = 3503 AND t.round = 19 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* `tables2013` 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 = 2003 AND t.round = 26 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* `tables2012` 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 = 1387 AND t.round = 38 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* `tables2011` 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 = 16541 AND t.round = 28 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* `tables2011` 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 = 16543 AND t.round = 9 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0130	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 = 74426 ORDER BY nameShow LIMIT 100

Sportivo Desamparados

Sportivo Desamparados

Selecciona un equipo

Competiciones que juega

Torneo Regional Federal Amateur Grupo 2

RIVALES EN Torneo Regional.