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

Juventud Alianza

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 2022/2023

TORNEO REGIONAL FEDERAL AMATEUR GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	Argentino	6	9	6	11
2	Gutiérrez	6	9	6	11
3	FADEP	6	10	4	9
4	Luján Sport	6	4	16	1
5	Martín	3	4	1	7
6	Atlético	4	2	3	4
7	Rodeo Medio	3	2	4	3
8	Pedal	6	10	3	16
9	Argentino	6	10	9	9
10	Pacífico	6	7	12	4
11	Deportiva	6	6	9	3
12	Huracán	6	12	2	16
13	Porvenir	6	9	7	8
14	Deportivo	6	7	7	7
15	Vialidad	6	2	14	2
16	Unión Villa	4	5	0	12
17	Deportivo	4	3	5	4
18	Defensores	4	2	5	1
19	Atlético	4	5	4	9
20	Hipolito	4	5	5	4
21	Independenci	4	6	7	4
22	Miguel Juan	6	15	6	15
23	Lorenzo	6	13	8	13
24	Martín	6	7	13	4
25	Sportivo	6	5	13	3
26	Juventud	6	7	2	12
27	Trinidad	6	6	5	8
28	Sportivo	6	6	9	7
29	Atlético	6	5	8	5
30	Sportivo	6	8	4	13
31	Unión Luis	6	6	5	11
32	Atlético	6	2	4	4
33	Martín	6	2	5	3
34	Jorge	6	9	2	14
35	EFI Juniors	6	11	5	13
36	Atlético	6	4	10	4
37	Sportivo	6	5	12	3

TEMPORADA 2021/2022

TORNEO REGIONAL FEDERAL AMATEUR GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	EFI Juniors	6	10	3	14
2	Jorge	6	13	4	12
3	Alianza	6	4	9	5
4	Sportivo	6	2	13	1
5	Huracán	6	11	6	14
6	Martín	6	6	3	10
7	GEPU	6	8	11	7
8	Naschel	6	7	12	2
9	Martín	6	12	8	12
10	FADEP	6	9	4	11
11	Gutiérrez	6	6	7	9
12	Andes	6	7	15	1
13	Indep. Calle	6	17	6	16
14	Sportivo	6	5	5	10
15	Deportivo	6	8	7	7
16	Vialidad	6	3	15	1
17	Ferro Carril	6	5	5	10
18	Argentino	6	8	7	9
19	Porvenir	6	5	6	8
20	Pacífico	6	4	4	7
21	Juventud	6	10	5	10
22	Atlético	6	8	5	7
23	Martín	6	6	7	7
24	Trinidad	6	5	12	5
25	Atlético	6	14	5	13
26	Angaqueros	6	4	5	8
27	Sportivo	6	5	6	6
28	Hipolito	6	4	11	5

TEMPORADA 2020/2021

TORNEO REGIONAL FEDERAL AMATEUR GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	Alianza	5	9	4	10
2	Defensores	5	10	12	7
3	Sportivo	5	7	9	7
4	Jorge	5	8	9	4
5	Martín	5	8	1	13
6	FADEP	5	7	3	10
7	Quiroga	5	4	6	6
8	Deportiva	5	1	10	0
9	Juventud	5	10	3	15
10	Defensores	5	7	6	7
11	Atlético	5	10	12	5
12	Trinidad	5	2	8	1

TEMPORADA 2019/2020

TORNEO REGIONAL FEDERAL AMATEUR GRUPO 12
Equipo		PJ	GF	GC	Puntos
1	FADEP	1	2	1	3
2	Deportiva	1	2	2	1
3	Quiroga	1	2	2	1
4	Martín	1	1	2	0
5	Trinidad	1	3	0	3
6	Defensores	1	2	0	3
7	Atlético	1	0	2	0
8	Juventud	1	0	3	0
9	Defensores	1	2	1	3
10	Alianza	1	1	0	3
11	Sportivo	1	1	2	0
12	Jorge	1	0	1	0

TEMPORADA 2018/2019

TORNEO REGIONAL FEDERAL AMATEUR GRUPO 8
Equipo		PJ	GF	GC	Puntos
1	Villa Larca	6	9	4	12
2	Luis	6	11	8	11
3	Jorge	6	6	7	8
4	Aviador	6	2	9	1
5	SC Victoria	6	12	7	13
6	Pedernales	6	8	7	8
7	Alianza	6	5	7	7
8	Martin	6	5	9	6
9	Martín	6	7	4	12
10	Atlético	6	6	4	9
11	La Libertad	6	7	9	6
12	Deportivo	6	5	8	4
13	Pacífico	8	9	6	14
14	Pedal	8	11	10	12
15	Pilares	8	10	7	11
16	Deportiva	8	12	15	7
17	Carlos	8	12	16	7
18	Gutiérrez	6	18	3	16
19	Andes	6	7	10	9
20	FADEP	6	12	13	6
21	Centro	6	7	18	2
22	Sportivo	6	11	6	13
23	Atlético	6	7	8	10
24	Juventud	6	11	8	8
25	Sportivo	6	6	13	2
26	Atlético	6	18	5	18
27	Sportivo	6	16	14	9
28	Defensores	6	11	12	9
29	Paso Andes	6	7	21	0

TEMPORADA 2016/2017

TORNEO REGIONAL FEDERAL AMATEUR GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	Sportivo	18	22	13	33
2	Sportivo	18	22	18	33
3	Atlético	18	26	20	31
4	Martín	18	22	18	28
5	Independient	18	23	24	24
6	Atlético	18	21	22	21
7	Defensores	18	20	23	21
8	Juventud	18	15	18	21
9	Lorenzo	18	18	22	18
10	Trinidad	18	15	26	14
11	Huracán	18	30	15	33
12	Deportivo	18	23	17	30
13	Martín	18	18	10	29
14	Pacífico	18	25	20	26
15	Rodeo Medio	18	23	25	22
16	Atlético	18	26	26	21
17	Jorge	18	16	19	20
18	Andes FC	18	19	29	20
19	La Libertad	18	22	30	18
20	Luján Cuyo	18	15	26	18

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 2007/2008

TORNEO REGIONAL FEDERAL AMATEUR GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	Central	21	42	23	36
2	Central	22	37	23	35
3	Famaillá	21	38	41	30
4	Atlético	20	25	22	29
5	General	20	25	24	29
6	Concepción	22	25	40	25
7	Gimnasia	21	28	30	24
8	Ñuñorco	21	21	38	19
9	Patronato	21	32	11	48
10	Guaraní	21	27	24	35
11	Chaco Ever	21	26	28	28
12	Crucero	21	26	26	25
13	Colegiales	21	23	27	25
14	América	21	20	29	24
15	Gualeguaychu	21	16	18	22
16	Textil	21	22	29	21
17	Atenas	22	32	21	44
18	Dep. Maipú	22	27	14	38
19	Martín	21	31	22	30
20	Guaymallén	21	25	27	30
21	Estudiantes	23	27	30	29
22	Argentino	21	27	27	27
23	Trinidad	21	22	32	21
24	Juventud	21	15	33	16
25	Douglas Haig	21	37	29	38
26	Sportivo	22	32	22	35
27	Defensores	22	25	23	34
28	La Emilia	21	33	29	33
29	Julio	21	22	23	31
30	Tiro Federal	22	25	31	25
31	Sportivo	22	21	27	23
32	Gimnasia	21	18	29	19
33	Linqueño	22	44	20	51
34	Alvarado	22	32	22	37
35	Grupo	21	39	33	36
36	Racing	21	37	29	30
37	Defensores	21	25	32	23
38	Sporting	21	19	40	20
39	Tres	21	28	36	19
40	CD Coreano	21	25	37	19
41	Deportivo	21	42	28	40
42	CA Liniers	21	29	21	38
43	Bella Vista	21	36	29	38
44	Dep. Roca	21	25	23	29
45	Independient	21	33	34	29
46	Racing	21	32	36	24
47	Cruz	21	41	46	22
48	Atlético	21	17	38	15

TEMPORADA 2006/2007

TORNEO REGIONAL FEDERAL AMATEUR GRUPO 3
Equipo		PJ	GF	GC	Puntos
1	Cadetes	2	4	4	3
2	Huracán	2	4	4	3
3	Juventud	2	2	2	3
4	Sportivo	2	2	2	3
5	Ñuñorco	2	2	2	2
6	Sarm.	2	2	2	2

TEMPORADA 1984/1985

LIGA PROFESIONAL ARGENTINA GRUPO 10
Equipo		PJ	GF	GC	Puntos
1	Instituto	1	4	0	3
2	Unión Santa	1	3	0	3
3	Boca Juniors	1	3	1	3
4	Dep.	1	2	0	3
5	Temperley	1	1	0	3
6	Huracán	1	3	3	1
7	San Lorenzo	1	3	3	1
8	Central	1	1	1	1
9	Dep.	1	1	1	1
10	Argentinos	1	0	0	1
11	Chacarita	1	0	0	1
12	Estudiantes	1	0	1	0
13	Altos Hornos	1	1	3	0
14	Gimnasia	1	0	2	0
15	Platense	1	0	3	0
16	Talleres	1	0	4	0

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

7,309,888 bytes

BENCHMARKS

Loading Time Base Classes	0.0020
Controller Execution Time ( Home / Category )	0.7825
Total Execution Time	0.7846

CADENA URL

/historico/Juventud-Alianza

GET DATOS

$_GET['/historico/Juventud-Alianza']

POST DATOS

No hay datos POST existentes

CONSULTAS (42)

0.0156	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 = 'Juventud-Alianza' 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.0145	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=16736 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0145	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=16736 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0145	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=16736 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0291	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.0144	SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=16736 AND type_rel = 2
0.0147	SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 2 AND rel.typeId = 16736 AND rel.ln = 'es' ORDER BY rel.cover_points DESC LIMIT 5
0.0145	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 (25467) ORDER BY n.cover_points DESC, update_date DESC
0.0150	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 = '16736' ORDER BY l.year DESC,cat.coefficient DESC
0.0149	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 = '16736' AND l.year = 2024 ORDER BY l.year DESC,cat.coefficient DESC
0.0148	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 = '16736' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0149	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=16736 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0145	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 (74781) 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.0145	SELECT count(id) as num_players from rel_players WHERE league_id = 74781 AND teamId = 16736
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 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.0146	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 = '16736' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0144	SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '16736' 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 = '16736' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0146	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 = 16736 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 events2024 e ON e.player_id = p.id AND e.league_id = 74426 WHERE rp.league_id = 74426 AND rp.teamId = 16736 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0146	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 = 16736 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 = 16736 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
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* `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.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* `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 = 70019 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.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* `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 = 66000 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.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* `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 = 60919 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.0148	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 = 53820 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.0147	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 = 55643 AND t.round = 1 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* `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 = 49520 AND t.round = 10 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* `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 = 34106 AND t.round = 18 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0148	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 = 39146 AND t.round = 18 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 = 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.0161	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.0165	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.0156	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.0193	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* `tables2008` 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 = 27963 AND t.round = 22 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0184	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* `tables2007` 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 = 27943 AND t.round = 14 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0156	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* `tables2007` 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 = 27944 AND t.round = 14 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0148	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* `tables2007` 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 = 27945 AND t.round = 1 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0146	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 = 26413 AND t.round = 6 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0148	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 = 26416 AND t.round = 2 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0164	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 = 26419 AND t.round = 1 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

Resultados de Fútbol

Juventud Alianza

Juventud Alianza

Selecciona un equipo

Competiciones que juega

Torneo Regional Federal Amateur Grupo 2

RIVALES EN Torneo Regional.