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

Deportivo Madryn

Entrenador: Leandro Gracián

Temporada 2023/2024

TEMPORADA 2023/2024

PRIMERA NACIONAL
Equipo		PJ	GF	GC	Puntos
1	Martín	13	14	5	24
2	Quilmes	13	16	6	23
3	Martín Juan	13	12	10	21
4	Estudiantes	13	9	7	21
5	Chacarita	13	14	12	19
6	All Boys	13	9	7	19
7	Gimnasia	13	11	10	18
8	Argentino	13	18	14	17
9	Ferro Carril	13	19	17	17
10	Arsenal	13	10	11	17
11	Racing	13	10	11	17
12	Miguel	12	10	8	16
13	Alvarado	13	9	12	16
14	Guillermo	13	11	14	14
15	Talleres	13	9	14	14
16	Dep. Maipú	13	10	18	14
17	Patronato	12	9	15	12
18	Club	13	8	13	11
19	Tristán	13	13	19	10
20	Colón	13	22	9	28
21	San Telmo	13	19	7	28
22	Def.	13	20	11	23
23	Nueva	13	11	5	21
24	Aldosivi	13	14	9	21
25	Estudiantes	13	13	8	20
26	Gimnasia	13	10	6	20
27	Deportivo	13	15	17	17
28	Gimnasia	13	14	16	17
29	Temperley	13	12	12	16
30	Def. Unidos	13	12	15	16
31	Atlanta	13	11	15	16
32	Chaco Ever	13	13	12	15
33	Deportivo	13	9	11	15
34	Atlético	13	6	8	14
35	Almagro	13	8	17	14
36	Atletico	13	9	15	9
37	Almirante	13	7	14	8
38	Brown	13	7	23	8

TEMPORADA 2022/2023

PRIMERA NACIONAL GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	Indep.	34	51	33	68
2	Chacarita	34	48	23	67
3	Dep. Maipú	34	46	31	63
4	Quilmes	34	44	31	53
5	Atletico	34	38	31	53
6	Atlético	34	38	37	52
7	Dep. Riestra	34	40	34	50
8	Ferro Carril	34	45	37	49
9	Brown	34	34	31	47
10	Gimnasia	34	36	40	44
11	Deportivo	34	28	28	43
12	Racing	34	44	43	41
13	Chaco Ever	34	30	43	40
14	Estudiantes	34	31	40	36
15	Atlanta	34	33	41	35
16	Aldosivi	34	33	44	35
17	Tristán	34	36	53	34
18	Villa	34	21	56	20

TEMPORADA 2021/2022

PRIMERA NACIONAL
Equipo		PJ	GF	GC	Puntos
1	Belgrano	36	48	23	79
2	Instituto	36	48	23	68
3	Martín	36	45	21	66
4	Gimnasia	36	41	20	64
5	All Boys	36	45	33	60
6	Estudiantes	36	39	29	58
7	Estudiantes	36	33	27	57
8	Almagro	36	35	33	57
9	Indep.	36	45	34	56
10	Chaco Ever	36	38	28	55
11	Dep. Riestra	36	34	26	54
12	Def.	36	37	30	54
13	Deportivo	36	31	21	53
14	Martín Juan	36	50	42	51
15	Chacarita	36	48	44	48
16	Ferro Carril	36	32	34	47
17	Deportivo	36	44	42	46
18	Atlanta	36	33	32	46
19	Quilmes	36	42	46	46
20	Dep. Maipú	36	39	32	45
21	Atlético	36	36	37	45
22	Brown	36	39	39	44
23	Gimnasia	36	38	50	44
24	Guillermo	36	30	43	43
25	Almirante	36	38	43	42
26	Temperley	36	34	41	41
27	Club	36	28	35	39
28	San Telmo	36	36	52	39
29	Atletico	36	40	43	38
30	Argentino	36	25	30	38
31	Villa	36	36	48	38
32	Alvarado	36	31	46	37
33	Tristán	36	37	45	35
34	Nueva	36	33	48	32
35	Flandria	36	30	49	31
36	Dep.	36	29	58	29
37	Sacachispas	36	21	41	27

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 3
Equipo		PJ	GF	GC	Puntos
1	Club	6	10	5	15
2	Central	6	7	6	10
3	Chaco Ever	6	8	6	9
4	Douglas Haig	6	5	4	9
5	Sarm.	6	4	5	7
6	Def.	6	5	8	5
7	Sportivo	6	6	11	3
8	Villa Mitre	6	9	5	12
9	Dep. Maipú	6	7	4	10
10	Olimpo	6	6	5	10
11	Juventud	6	8	6	8
12	Huracán	6	4	6	7
13	Deportivo	6	6	10	7
14	Sansinena	6	2	6	3

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

TORNEO FEDERAL A TRANSICIÓN GRUPO 6
Equipo		PJ	GF	GC	Puntos
1	Deportivo	8	10	5	17
2	Sansinena	8	9	7	14
3	Independient	8	7	12	9
4	Rivadavia	8	9	11	8
5	Cipolletti	8	9	9	7
6	Huracán	10	15	7	19
7	Unión Villa	10	9	8	15
8	Dep. Maipú	10	15	14	13
9	Lorenzo Alem	10	10	13	13
10	Unión	10	9	13	10
11	Gutiérrez	10	11	14	8
12	Atlético	10	15	9	18
13	Sportivo	10	13	8	17
14	Def.	10	12	12	13
15	Douglas Haig	10	15	19	12
16	Libertad	10	13	16	10
17	Gimnasia	10	12	16	9
18	Jorge	10	14	9	19
19	Sportivo	10	18	14	14
20	CD Mandiyú	10	10	10	14
21	Juventud	10	12	12	12
22	Altos Hornos	10	8	11	9
23	Guaraní	10	10	16	8

TEMPORADA 2016/2017

TORNEO FEDERAL A TRANSICIÓN GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	Unión	8	17	10	17
2	Gimnasia	8	15	10	15
3	Argentino	8	10	9	15
4	Defensores	8	11	7	14
5	Villa Mitre	8	7	5	11
6	Cipolletti	8	7	8	10
7	Deportivo	8	6	11	7
8	Sportivo	8	5	14	5
9	Alvarado	8	7	11	4
10	Gimnasia	8	15	7	19
11	Atlético	8	12	8	16
12	Sportivo	8	11	11	14
13	Sarm.	8	10	9	13
14	Unión Villa	8	7	5	12
15	Unión	8	10	10	9
16	Juventud	8	3	8	7
17	Chaco Ever	8	7	13	7
18	Altos Hornos	8	5	9	4

TEMPORADA 2015/2016

TORNEO FEDERAL A GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	Deportivo	12	27	17	21
2	Independient	12	17	17	20
3	Cipolletti	12	17	12	17
4	Villa Mitre	12	13	19	12
5	Dep. Roca	12	11	20	12

TEMPORADA 2014/2015

TORNEO FEDERAL A GRUPO 6
Equipo		PJ	GF	GC	Puntos
1	Altos Hornos	12	8	11	16
2	Alvarado	12	23	11	23
3	Sportivo	12	15	10	22
4	Julio	12	15	10	20
5	CAI	12	14	7	19
6	Deportivo	12	15	9	19
7	Dep. Maipú	12	14	11	19
8	Gutiérrez	12	13	8	18
9	Belgrano	12	12	11	17
10	Tiro Federal	12	9	12	15
11	Ferro	12	15	17	14
12	Independient	12	9	13	14
13	Independient	12	4	15	7
14	Alianza	12	7	31	1
15	Unión Villa	12	21	10	21
16	Lorenzo Alem	12	15	7	21
17	Gimnasia	12	21	17	21
18	Libertad	12	18	15	21
19	Concepción	12	19	12	19
20	Sportivo	12	18	16	16
21	Jorge	12	16	15	15
22	Vélez	12	13	16	15
23	Textil	12	15	20	15
24	Sarm.	12	14	15	11
25	Américo	12	19	33	11
26	Andino	12	8	18	9

TEMPORADA 2013/2014

ARGENTINO B GRUPO 15
Equipo		PJ	GF	GC	Puntos
1	Deportivo	15	33	8	36
2	Huracán	15	20	12	25
3	Boca Río Ga.	15	15	12	20
4	Racing	15	23	24	19
5	Germinal	15	19	21	19
6	Petrolero	15	9	42	5

TEMPORADA 2007/2008

TORNEO REGIONAL FEDERAL AMATEUR GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	Central	6	9	4	14
2	Crucero	6	9	6	13
3	Central	6	6	9	4
4	Guaraní	6	3	8	2
5	Patronato	6	13	3	13
6	Douglas Haig	6	9	9	8
7	Atenas	6	6	9	8
8	La Emilia	6	5	12	4
9	Sportivo	6	8	6	11
10	Dep. Maipú	6	6	5	9
11	Linqueño	6	6	4	8
12	Dep. Roca	6	4	9	4
13	Alvarado	6	13	3	13
14	Deportivo	6	9	6	8
15	Racing	6	6	10	7
16	Bella Vista	6	7	16	5

TEMPORADA 2006/2007

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

Competiciones que juega

Primera Nacional

Pos	Equipos		Pts
1		Colón	28
2		San Telmo	28
3		San Martín Tucumán	24
4		Quilmes	23
5		Def. Belgrano	23
6		Nueva Chicago	21
7		Aldosivi	21
8		San Martín San Juan	21
9		CA Estudiantes	21
10		Estudiantes Río Cuarto	20
11		Gimnasia y Tiro	20
12		Chacarita Juniors	19
13		All Boys	19
14		Gimnasia Jujuy	18
15		Argentino Agropecuario	17
16		Ferro Carril Oeste	17
17		Arsenal de Sarandí	17
18		Racing Córdoba	17
19		Deportivo Morón	17
20		Gimnasia Mendoza	17
21		CA San Miguel	16
22		Temperley	16
23		Def. Unidos	16
24		Alvarado	16
25		Atlanta	16
26		Chaco For Ever	15
27		Deportivo Madryn	15
28		Atlético Mitre SdE	14
29		Guillermo Brown	14
30		Talleres R. Escalada	14
31		Dep. Maipú	14
32		Almagro	14
33		Patronato	12
34		Club Atlético Güemes	11
35		Tristán Suárez	10
36		Atletico Rafaela	9
37		Almirante Brown	8
38		Brown Adrogue	8

	Series Finales : Colón
	Playoff Ascenso : San Telmo, San Martín Tucumán, Quilmes, Def. Belgrano, Nueva Chicago, Aldosivi
	Playoff Descenso : Racing Córdoba
	Descenso : Deportivo Morón

RIVALES EN Primera Nacional

USO DE MEMORIA

7,216,744 bytes

BENCHMARKS

Loading Time Base Classes	0.0012
Controller Execution Time ( Home / Category )	0.1646
Total Execution Time	0.1658

CADENA URL

/historico/Deportivo-Madryn

GET DATOS

$_GET['/historico/Deportivo-Madryn']

POST DATOS

No hay datos POST existentes

CONSULTAS (41)

0.0033	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 = 'Deportivo-Madryn' 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.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=16814 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=16814 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0041	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 = 75057
0.0018	SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=16814 AND type_rel = 2
0.0022	SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 2 AND rel.typeId = 16814 AND rel.ln = 'es' ORDER BY rel.cover_points DESC LIMIT 5
0.0019	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 (71343) ORDER BY n.cover_points DESC, update_date DESC
0.0033	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 = '16814' ORDER BY l.year DESC,cat.coefficient 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 = '16814' AND l.year = 2024 ORDER BY l.year DESC,cat.coefficient DESC
0.0030	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 = '16814' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0022	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 = 75057 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0031	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=16814 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0018	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 (75057) 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.0034	SELECT count(id) as num_players from rel_players WHERE league_id = 75057 AND teamId = 16814
0.0020	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 = '16814' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0019	SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '16814' 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 = '16814' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0042	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 = 75057 WHERE rp.league_id = 75057 AND rp.teamId = 16814 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.0049	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 = 75057 WHERE rp.league_id = 75057 AND rp.teamId = 16814 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
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 events2024 e ON e.player_id = p.id AND e.league_id = 75057 WHERE rp.league_id = 75057 AND rp.teamId = 16814 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0030	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 = 16814 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
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* `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 = 75057 AND t.round = 14 ORDER BY team.conference ASC,t.position 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* `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 = 70827 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.0049	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 = 61653 AND t.round = 37 ORDER BY team.conference ASC,t.position 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* `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.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* `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.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* `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 = 60171 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.0022	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 = 45041 AND t.round = 18 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* `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.0023	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 = 40142 AND t.round = 18 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* `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 = 41925 AND t.round = 10 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0031	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.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* `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 = 37687 AND t.round = 9 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* `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 = 20248 AND t.round = 15 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0023	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 = 3987 AND t.round = 14 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* `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 = 10884 AND t.round = 18 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* `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 = 16601 AND t.round = 13 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0023	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 = 3514 AND t.round = 15 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0051	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.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* `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 = 27964 AND t.round = 12 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0034	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

Deportivo Madryn

Deportivo Madryn

Selecciona un equipo

Competiciones que juega

Primera Nacional

RIVALES EN Primera Nacional