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 Maldonado

Entrenador: Joaquín Boghossian

Temporada 2023/2024

TEMPORADA 2023/2024

APERTURA URUGUAY
Equipo		PJ	GF	GC	Puntos
1	Peñarol	11	24	6	29
2	Nacional	11	24	11	25
3	Progreso	11	23	16	24
4	Defensor	11	21	13	19
5	Cerro Largo	11	13	10	18
6	Boston River	11	15	13	18
7	Racing	11	17	16	15
8	Danubio	11	12	14	13
9	Liverpool	11	17	17	12
10	River Plate	11	15	17	12
11	Montevideo	11	12	16	12
12	Deportivo	11	12	15	11
13	Rampla	11	10	23	9
14	Cerro CA	11	11	21	8
15	Miramar	11	15	23	7
16	Fénix	11	5	15	4

TEMPORADA 2022/2023

TORNEO INTERMEDIO URUGUAY GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	Liverpool	7	15	8	16
2	Cerro CA	7	6	4	12
3	Nacional	7	12	8	11
4	Racing	7	12	12	10
5	Fénix	7	7	5	9
6	Cerro Largo	7	8	9	8
7	Deportivo	7	7	13	5
8	Plaza	7	9	17	4

TEMPORADA 2021/2022

CLAUSURA URUGUAY
Equipo		PJ	GF	GC	Puntos
1	Nacional	15	26	9	34
2	River Plate	15	29	12	30
3	Deportivo	15	19	11	30
4	Liverpool	15	23	12	28
5	Danubio	15	19	10	25
6	Defensor	15	18	12	25
7	Boston River	15	21	15	22
8	Peñarol	15	20	16	22
9	Cerro Largo	15	11	18	19
10	Fénix	15	13	15	17
11	Montevideo	15	12	19	16
12	Albion FC	15	11	19	16
13	Plaza	15	11	20	14
14	Montevideo	15	12	24	13
15	Rentistas	15	16	31	10
16	Cerrito	15	10	28	9

TEMPORADA 2020/2021

CLAUSURA URUGUAY
Equipo		PJ	GF	GC	Puntos
1	Peñarol	15	27	11	32
2	Nacional	15	23	15	30
3	Montevideo	15	23	18	27
4	Cerro Largo	15	24	11	26
5	Montevideo	15	26	19	25
6	Progreso	15	12	7	25
7	Boston River	15	24	25	22
8	Cerrito	15	20	22	21
9	Plaza	15	20	18	20
10	Fénix	15	18	18	19
11	Deportivo	15	13	18	17
12	River Plate	15	18	22	16
13	Liverpool	15	15	19	15
14	Rentistas	15	18	24	14
15	América	15	14	26	13
16	CSyD Villa.	15	12	34	6

TEMPORADA 2019/2020

TORNEO INTERMEDIO URUGUAY
Equipo		PJ	GF	GC	Puntos
1	Montevideo	7	13	8	14
2	Liverpool	7	14	12	12
3	Montevideo	7	13	10	10
4	Cerro Largo	7	8	5	10
5	Rentistas	7	7	6	9
6	Progreso	7	7	10	7
7	Plaza	7	8	11	6
8	Cerro CA	7	5	13	5
9	Nacional	7	11	6	15
10	River Plate	7	14	8	13
11	Peñarol	7	15	9	12
12	Fénix	7	7	6	10
13	Danubio	7	5	9	9
14	Deportivo	7	10	15	8
15	Defensor	7	5	10	6
16	Boston River	7	6	10	5

TEMPORADA 2018/2019

SEGUNDA DIVISIÓN URUGUAY
Equipo		PJ	GF	GC	Puntos
1	Montevideo	22	28	14	43
2	Deportivo	22	30	20	40
3	Rentistas	22	28	19	39
4	CSyD Villa.	22	30	25	36
5	Cerrito	22	26	23	30
6	América	22	16	17	30
7	Atenas	22	30	27	29
8	Villa Teresa	22	24	27	28
9	Albion FC	22	21	28	27
10	Central	22	18	25	24
11	Bella Vista	22	23	40	20
12	Tacuarembó	22	19	28	19

TEMPORADA 2017/2018

SEGUNDA DIVISIÓN URUGUAY
Equipo		PJ	GF	GC	Puntos
1	Cerro Largo	26	33	16	51
2	Juventud	26	46	24	50
3	Plaza	26	35	28	44
4	Cerrito	26	30	37	37
5	Villa Teresa	26	39	31	36
6	Tacuarembó	26	33	32	35
7	Deportivo	26	32	27	35
8	América	26	32	30	35
9	Central	26	30	31	32
10	CSyD Villa.	26	32	40	29
11	Rentistas	26	31	43	28
12	Albion FC	26	27	36	27
13	Miramar	26	26	41	26
14	Oriental	26	29	39	24

TEMPORADA 2016/2017

SEGUNDA DIVISIÓN URUGUAY
Equipo		PJ	GF	GC	Puntos
1	Montevideo	28	48	23	56
2	Atenas	28	40	26	47
3	Progreso	28	39	27	42
4	Cerro Largo	28	30	27	42
5	Cerrito	28	26	35	42
6	Deportivo	28	29	31	39
7	Central	28	32	38	39
8	Rentistas	28	43	38	36
9	Villa Teresa	28	40	36	36
10	CSyD Villa.	28	26	27	35
11	Tacuarembó	28	33	34	34
12	Miramar	28	25	31	31
13	Huracán FC	28	33	43	30
14	Canadian	28	29	36	28
15	Oriental	28	31	52	28

TEMPORADA 2015/2016

SEGUNDA DIVISIÓN URUGUAY FORMATO ANTIGUO GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	Rampla	14	22	14	31
2	CSyD Villa.	14	23	14	29
3	Boston River	14	21	13	26
4	Montevideo	14	26	20	23
5	Progreso	14	21	16	23
6	Atenas	14	25	19	22
7	Miramar	14	18	17	19
8	Tacuarembó	14	22	23	17
9	Cerro Largo	14	16	18	17
10	Central	14	17	20	17
11	Rocha FC	14	12	15	17
12	Deportivo	14	12	18	14
13	Oriental	14	12	20	14
14	Huracán FC	14	10	23	13
15	Canadian	14	16	23	12

TEMPORADA 2014/2015

SEGUNDA DIVISIÓN URUGUAY FORMATO ANTIGUO
Equipo		PJ	GF	GC	Puntos
1	Liverpool	28	69	28	58
2	Plaza	28	44	37	53
3	Villa Teresa	28	43	32	47
4	Boston River	28	45	41	44
5	Canadian	28	40	37	43
6	Central	28	39	37	43
7	CSyD Villa.	28	51	36	42
8	Huracán FC	28	54	48	41
9	Miramar	28	35	30	37
10	Montevideo	28	39	49	35
11	Cerro Largo	28	27	30	32
12	Deportivo	28	27	43	31
13	Progreso	28	27	42	25
14	Rocha FC	28	26	53	25
15	Cerrito	28	31	54	20

TEMPORADA 2013/2014

SEGUNDA DIVISIÓN URUGUAY FORMATO ANTIGUO
Equipo		PJ	GF	GC	Puntos
1	Tacuarembó	26	41	25	48
2	Atenas	26	43	34	46
3	Deportivo	26	30	28	41
4	Huracán FC	26	33	26	40
5	Boston River	26	39	31	39
6	Rocha FC	26	34	26	39
7	Rampla	26	36	33	36
8	Villa Teresa	26	34	31	36
9	Plaza	26	27	24	36
10	Central	26	33	40	36
11	Canadian	26	26	30	34
12	Progreso	26	27	38	27
13	Cerrito	26	24	41	23
14	Montevideo	26	27	47	15

Competiciones que juega

Grupo 2

Apertura Uruguay

Pos	Equipos		Pts
1		Peñarol	29
2		Nacional	25
3		Progreso	24
4		Defensor Sporting	19
5		Cerro Largo	18
6		Boston River	18
7		Racing Montevideo	15
8		Danubio	13
9		Liverpool Montevideo	12
10		River Plate Montevideo	12
11		Montevideo Wanderers	12
12		Deportivo Maldonado	11
13		Rampla Juniors	9
14		Cerro CA	8
15		Miramar Misiones	7
16		Fénix	4

	Campeón : Peñarol

RIVALES EN Apertura Uruguay

RIVALES EN Copa Uruguay

USO DE MEMORIA

6,518,824 bytes

BENCHMARKS

Loading Time Base Classes	0.0012
Controller Execution Time ( Home / Category )	0.1393
Total Execution Time	0.1406

CADENA URL

/historico/Deportivo-Mald

GET DATOS

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

POST DATOS

No hay datos POST existentes

CONSULTAS (47)

0.0038	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-Mald' 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=5951 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=5951 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=5951 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=5951 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=5951 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0017	SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=5951 AND type_rel = 2
0.0020	SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 2 AND rel.typeId = 5951 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 (1553,30955,47264,78243,82837) ORDER BY n.cover_points DESC, update_date DESC
0.0029	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 = '5951' ORDER BY l.year DESC,cat.coefficient DESC
0.0025	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 = '5951' AND l.year = 2024 ORDER BY l.year DESC,cat.coefficient DESC
0.0026	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 = '5951' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0024	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=5951 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0019	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 (75100,75068,73584,71733,71432,70793,70770) 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.0022	SELECT count(id) as num_players from rel_players WHERE league_id = 75068 AND teamId = 5951
0.0022	SELECT count(id) as num_players from rel_players WHERE league_id = 70793 AND teamId = 5951
0.0022	SELECT count(id) as num_players from rel_players WHERE league_id = 71733 AND teamId = 5951
0.0022	SELECT count(id) as num_players from rel_players WHERE league_id = 70770 AND teamId = 5951
0.0025	SELECT count(id) as num_players from rel_players WHERE league_id = 73584 AND teamId = 5951
0.0022	SELECT count(id) as num_players from rel_players WHERE league_id = 71432 AND teamId = 5951
0.0020	SELECT count(id) as num_players from rel_players WHERE league_id = 75100 AND teamId = 5951
0.0025	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 = '5951' 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 = '5951' 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 = '5951' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
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 events2024 e ON e.player_id = p.id AND e.league_id = 75068 WHERE rp.league_id = 75068 AND rp.teamId = 5951 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.0027	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 = 75068 WHERE rp.league_id = 75068 AND rp.teamId = 5951 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0024	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 = 75068 WHERE rp.league_id = 75068 AND rp.teamId = 5951 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0025	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 = 5951 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.0021	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 = 75068 AND t.round = 11 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0021	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 = 70792 AND t.round = 15 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0021	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 = 70793 AND t.round = 15 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0021	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 = 71733 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.0021	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 = 66322 AND t.round = 15 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0020	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 = 67806 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.0021	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 = 68424 AND t.round = 15 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0021	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 = 62425 AND t.round = 15 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0021	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 = 64096 AND t.round = 15 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* `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 = 53553 AND t.round = 15 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0021	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 = 59648 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.0021	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 = 49071 AND t.round = 22 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0020	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 = 42967 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0020	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 = 35302 AND t.round = 13 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0021	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 = 38209 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0020	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 = 15508 AND t.round = 7 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0020	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 = 20258 AND t.round = 15 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0021	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 = 4850 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0021	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 = 3761 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC

Deportivo Maldonado

Deportivo Maldonado

Selecciona un equipo

Competiciones que juega

Apertura Uruguay

RIVALES EN Apertura Uruguay

RIVALES EN Copa Uruguay