4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del Def. Unidos

Def. Unidos

Entrenador: Santiago Davio

Temporada 2023/2024
TEMPORADA 2023/2024
PRIMERA NACIONAL
Equipo PJ GF GC Puntos
1 San Martín Tucumán Martín 13 14 5 24
2 Quilmes Quilmes 12 16 5 23
3 CA Estudiantes Estudiantes 13 9 7 21
4 Chacarita Juniors Chacarita 12 14 12 18
5 All Boys All Boys 12 9 7 18
6 San Martín San Juan Martín Juan 12 10 9 18
7 Argentino Agropecuario Argentino 13 18 14 17
8 Arsenal de Sarandí Arsenal 12 10 9 17
9 CA San Miguel Miguel 11 10 7 16
10 Gimnasia Jujuy Gimnasia 12 9 10 15
11 Ferro Carril Oeste Ferro Carril 12 16 16 14
12 Racing Córdoba Racing 12 9 11 14
13 Talleres R. Escalada Talleres 13 9 14 14
14 Dep. Maipú Dep. Maipú 12 10 16 14
15 Alvarado Alvarado 12 8 12 13
16 Patronato Patronato 12 9 15 12
17 Club Atlético Güemes Club 12 7 10 11
18 Guillermo Brown Guillermo 12 9 14 11
19 Tristán Suárez Tristán 13 13 19 10
20 San Telmo San Telmo 12 17 6 25
21 Colón Colón 12 18 9 25
22 Aldosivi Aldosivi 12 13 7 21
23 Nueva Chicago Nueva 13 11 5 21
24 Def. Belgrano Def. 12 18 11 20
25 Gimnasia y Tiro Gimnasia 12 10 6 19
26 Estudiantes Río Cuarto Estudiantes 12 12 8 17
27 Temperley Temperley 12 12 11 16
28 Def. Unidos Def. Unidos 12 12 12 16
29 Gimnasia Mendoza Gimnasia 12 14 16 16
30 Atlanta Atlanta 12 11 13 16
31 Deportivo Madryn Deportivo 12 8 9 15
32 Atlético Mitre SdE Atlético 13 6 8 14
33 Deportivo Morón Deportivo 12 13 16 14
34 Almagro Almagro 13 8 17 14
35 Chaco For Ever Chaco Ever 12 10 12 12
36 Atletico Rafaela Atletico 12 8 13 9
37 Almirante Brown Almirante 13 7 14 8
38 Brown Adrogue Brown 12 7 19 8
TEMPORADA 2022/2023
PRIMERA NACIONAL GRUPO 1
Equipo PJ GF GC Puntos
1 Almirante Brown Almirante 36 36 30 61
2 Argentino Agropecuario Argentino 36 46 36 59
3 San Martín Tucumán Martín 36 38 24 56
4 Estudiantes Río Cuarto Estudiantes 36 34 32 55
5 Def. Belgrano Def. 36 44 35 53
6 Gimnasia Mendoza Gimnasia 36 45 37 53
7 San Martín San Juan Martín Juan 36 44 38 53
8 Temperley Temperley 36 42 38 53
9 Club Atlético Güemes Club 36 37 34 53
10 Deportivo Morón Deportivo 36 38 37 53
11 Nueva Chicago Nueva 36 34 25 52
12 Def. Unidos Def. Unidos 36 30 31 47
13 Alvarado Alvarado 36 35 40 44
14 Patronato Patronato 36 39 44 42
15 All Boys All Boys 36 31 40 42
16 Guillermo Brown Guillermo 36 35 42 38
17 Almagro Almagro 36 26 36 37
18 San Telmo San Telmo 36 40 52 37
19 Flandria Flandria 36 33 56 34
TEMPORADA 2021/2022
PRIMERA B GRUPO 2
Equipo PJ GF GC Puntos
1 Dep. Armenio Dep. Armenio 16 18 3 36
2 Colegiales Colegiales 16 26 15 35
3 CA San Miguel Miguel 16 19 14 24
4 Ituzaingó Ituzaingó 16 21 21 24
5 Def. Unidos Def. Unidos 16 20 15 23
6 Villa San Carlos Villa Carlos 16 16 16 23
7 Acassuso Acassuso 16 14 15 22
8 Cañuelas Cañuelas 16 17 20 22
9 Deportivo Merlo Deportivo 16 17 17 21
10 Talleres R. Escalada Talleres 16 15 16 21
11 Comunicaciones Comunicacion 16 20 21 20
12 Los Andes Los Andes 16 15 14 19
13 UAI Urquiza UAI Urquiza 16 11 14 19
14 Dock Sud Dock Sud 16 16 21 18
15 Fénix Bs As Fénix 16 14 18 17
16 Arg. Quilmes Arg. Quilmes 16 16 24 15
17 JJ Urquiza JJ Urquiza 16 7 18 10
TEMPORADA 2020/2021
PRIMERA B GRUPO 1
Equipo PJ GF GC Puntos
1 Colegiales Colegiales 16 28 19 31
2 Los Andes Los Andes 16 18 7 29
3 Deportivo Merlo Deportivo 16 25 18 29
4 Def. Unidos Def. Unidos 16 21 16 28
5 Flandria Flandria 16 21 15 27
6 Sacachispas Sacachispas 16 19 20 27
7 Talleres R. Escalada Talleres 16 25 18 26
8 JJ Urquiza JJ Urquiza 16 22 20 26
9 Comunicaciones Comunicacion 16 21 23 21
10 CA San Miguel Miguel 16 14 16 21
11 Acassuso Acassuso 16 18 21 20
12 Dep. Armenio Dep. Armenio 16 12 17 18
13 Villa San Carlos Villa Carlos 16 18 20 17
14 Arg. Quilmes Arg. Quilmes 16 15 20 16
15 UAI Urquiza UAI Urquiza 16 22 29 16
16 Cañuelas Cañuelas 16 15 23 14
17 Fénix Bs As Fénix 16 17 29 11
TEMPORADA 2019/2020
PRIMERA B GRUPO 4
Equipo PJ GF GC Puntos
1 San Telmo San Telmo 5 9 6 10
2 Talleres R. Escalada Talleres 5 7 6 8
3 CA San Miguel Miguel 5 5 4 7
4 Dep. Armenio Dep. Armenio 5 7 6 6
5 Fénix Bs As Fénix 5 6 7 4
6 Def. Unidos Def. Unidos 5 6 11 3
7 Arg. Quilmes Arg. Quilmes 5 9 6 9
8 Los Andes Los Andes 5 6 4 8
9 Sacachispas Sacachispas 5 6 6 7
10 Flandria Flandria 5 3 2 6
11 UAI Urquiza UAI Urquiza 5 7 8 6
12 Colegiales Colegiales 5 4 9 2
TEMPORADA 2018/2019
PRIMERA B
Equipo PJ GF GC Puntos
1 Barracas Central Barracas 38 59 15 81
2 Atlanta Atlanta 38 64 27 72
3 CA Estudiantes Estudiantes 38 59 32 72
4 Dep. Riestra Dep. Riestra 38 50 34 68
5 Acassuso Acassuso 38 38 23 59
6 San Telmo San Telmo 38 45 33 57
7 Colegiales Colegiales 38 34 32 54
8 All Boys All Boys 38 43 48 54
9 Almirante Brown Almirante 38 37 42 52
10 UAI Urquiza UAI Urquiza 38 26 33 51
11 Flandria Flandria 38 36 32 50
12 Fénix Bs As Fénix 38 31 35 45
13 Def. Unidos Def. Unidos 38 34 41 44
14 Tristán Suárez Tristán 38 33 43 42
15 JJ Urquiza JJ Urquiza 38 34 46 41
16 CA San Miguel Miguel 38 21 28 40
17 Sacachispas Sacachispas 38 28 46 37
18 Comunicaciones Comunicacion 38 22 48 31
19 Dep. Español Dep. 38 23 56 31
20 Talleres R. Escalada Talleres 38 23 46 30
TEMPORADA 2017/2018
PRIMERA C
Equipo PJ GF GC Puntos
1 Def. Unidos Def. Unidos 38 59 32 76
2 Central Córdoba Rosario Central 38 54 31 73
3 Arg. Quilmes Arg. Quilmes 38 58 29 72
4 Luján Luján 38 41 25 64
5 JJ Urquiza JJ Urquiza 38 54 46 60
6 Leandro Nicéforo Alem Leandro 38 51 41 57
7 Midland Midland 38 44 43 53
8 Deportivo Merlo Deportivo 38 41 41 53
9 Cañuelas Cañuelas 38 41 36 52
10 Ituzaingó Ituzaingó 38 41 42 52
11 Laferrere Laferrere 38 41 46 49
12 San Martín Burzaco Martín 38 37 47 48
13 Defensores de Cambaceres Defensores 38 45 50 46
14 Dep. Armenio Dep. Armenio 38 30 30 44
15 El Porvenir El Porvenir 38 36 49 43
16 Dock Sud Dock Sud 38 33 43 40
17 Berazategui Berazategui 38 39 59 40
18 Excursionistas Excursionist 38 39 48 38
19 Sportivo Italiano Sportivo 38 37 60 37
20 Sportivo Barracas Sportivo 38 34 57 32
TEMPORADA 2016/2017
PRIMERA C
Equipo PJ GF GC Puntos
1 Sacachispas Sacachispas 38 72 35 78
2 Def. Unidos Def. Unidos 38 54 29 71
3 Cañuelas Cañuelas 38 58 41 63
4 Sportivo Barracas Sportivo 38 55 39 60
5 Arg. Quilmes Arg. Quilmes 38 42 43 58
6 CA San Miguel Miguel 38 41 31 57
7 Midland Midland 38 35 38 56
8 Deportivo Merlo Deportivo 38 49 49 53
9 Dep. Armenio Dep. Armenio 38 33 25 51
10 El Porvenir El Porvenir 38 41 42 51
11 Luján Luján 38 37 39 50
12 Sportivo Italiano Sportivo 38 43 46 48
13 Defensores de Cambaceres Defensores 38 44 52 48
14 Central Córdoba Rosario Central 38 42 40 47
15 JJ Urquiza JJ Urquiza 38 34 47 44
16 San Martín Burzaco Martín 38 34 45 39
17 Argentino Merlo Argentino 38 27 44 39
18 Laferrere Laferrere 38 41 57 38
19 Dock Sud Dock Sud 38 32 50 38
20 Berazategui Berazategui 38 24 46 34
TEMPORADA 2015/2016
PRIMERA C
Equipo PJ GF GC Puntos
1 Excursionistas Excursionist 19 36 24 41
2 Sportivo Italiano Sportivo 19 24 18 39
3 JJ Urquiza JJ Urquiza 19 28 19 37
4 Berazategui Berazategui 19 29 16 36
5 San Martín Burzaco Martín 19 30 18 35
6 Laferrere Laferrere 19 28 20 33
7 Sacachispas Sacachispas 19 27 20 33
8 Arg. Quilmes Arg. Quilmes 19 22 18 28
9 Deportivo Merlo Deportivo 19 17 15 25
10 Luján Luján 19 20 21 25
11 Sportivo Barracas Sportivo 19 22 24 24
12 Defensores de Cambaceres Defensores 19 20 27 22
13 Cañuelas Cañuelas 19 24 29 19
14 Dock Sud Dock Sud 19 17 22 19
15 Def. Unidos Def. Unidos 19 25 34 19
16 CA San Miguel Miguel 19 17 27 18
17 Midland Midland 19 17 23 17
18 Central Córdoba Rosario Central 19 21 27 16
19 Liniers Liniers 19 17 28 16
20 Argentino Merlo Argentino 19 16 27 13
TEMPORADA 2014/2015
PRIMERA C
Equipo PJ GF GC Puntos
1 San Telmo San Telmo 38 45 28 70
2 Talleres R. Escalada Talleres 38 64 38 65
3 Laferrere Laferrere 38 43 27 63
4 Central Córdoba Rosario Central 38 48 34 60
5 Dock Sud Dock Sud 38 46 41 58
6 Luján Luján 38 46 39 57
7 Berazategui Berazategui 38 38 39 54
8 Arg. Quilmes Arg. Quilmes 38 49 44 53
9 CA San Miguel Miguel 38 54 56 53
10 JJ Urquiza JJ Urquiza 38 40 40 52
11 Argentino Merlo Argentino 38 45 43 50
12 San Martín Burzaco Martín 38 49 46 48
13 Excursionistas Excursionist 38 35 49 48
14 Midland Midland 38 36 34 47
15 Cañuelas Cañuelas 38 41 49 47
16 Def. Unidos Def. Unidos 38 40 44 45
17 Sacachispas Sacachispas 38 36 50 43
18 Juventud Unida Juventud 38 31 46 40
19 General Lamadrid General 38 27 46 36
20 Defensores de Cambaceres Defensores 38 28 48 34
TEMPORADA 2013/2014
PRIMERA C
Equipo PJ GF GC Puntos
1 Sportivo Italiano Sportivo 38 44 34 67
2 Defensores de Cambaceres Defensores 38 40 29 60
3 Dep. Español Dep. 38 43 34 59
4 Laferrere Laferrere 38 46 30 58
5 Arg. Quilmes Arg. Quilmes 38 46 43 57
6 Midland Midland 38 37 36 56
7 Def. Unidos Def. Unidos 38 41 34 55
8 Argentino Merlo Argentino 38 46 40 55
9 Talleres R. Escalada Talleres 38 35 26 55
10 Excursionistas Excursionist 38 32 35 53
11 General Lamadrid General 38 30 27 49
12 San Telmo San Telmo 38 48 39 49
13 Luján Luján 38 29 34 48
14 Sacachispas Sacachispas 38 43 51 47
15 Dock Sud Dock Sud 38 49 50 46
16 Ituzaingó Ituzaingó 38 36 45 44
17 Liniers Liniers 38 44 53 41
18 Central Córdoba Rosario Central 38 24 39 39
19 Berazategui Berazategui 38 29 45 35
20 JJ Urquiza JJ Urquiza 38 25 43 32
TEMPORADA 2012/2013
PRIMERA C
Equipo PJ GF GC Puntos
1 UAI Urquiza UAI Urquiza 38 41 21 77
2 Laferrere Laferrere 38 47 18 67
3 Sacachispas Sacachispas 38 49 36 63
4 Dep. Español Dep. 38 53 36 62
5 Fénix Bs As Fénix 38 40 37 56
6 El Porvenir El Porvenir 38 41 33 54
7 Midland Midland 38 43 47 52
8 Def. Unidos Def. Unidos 37 35 39 51
9 CA San Miguel Miguel 38 32 35 50
10 Sportivo Italiano Sportivo 38 26 30 50
11 Argentino Merlo Argentino 38 31 32 49
12 Defensores de Cambaceres Defensores 38 38 39 48
13 Berazategui Berazategui 37 34 37 48
14 JJ Urquiza JJ Urquiza 38 36 48 46
15 Liniers Liniers 38 36 37 45
16 Dock Sud Dock Sud 38 40 48 44
17 General Lamadrid General 38 33 41 43
18 Luján Luján 38 32 39 42
19 Talleres R. Escalada Talleres 38 34 41 41
20 Excursionistas Excursionist 38 28 55 32
TEMPORADA 2011/2012
PRIMERA C
Equipo PJ GF GC Puntos
1 Villa Dálmine Villa 38 61 30 71
2 UAI Urquiza UAI Urquiza 38 47 33 69
3 Defensores de Cambaceres Defensores 38 40 33 60
4 JJ Urquiza JJ Urquiza 38 45 30 59
5 Laferrere Laferrere 38 43 33 58
6 Central Córdoba Rosario Central 38 51 36 57
7 Dock Sud Dock Sud 38 37 38 54
8 Midland Midland 38 42 39 53
9 Berazategui Berazategui 38 50 47 52
10 Talleres R. Escalada Talleres 38 47 44 50
11 Excursionistas Excursionist 38 41 38 49
12 Leandro Nicéforo Alem Leandro 38 37 40 47
13 CA San Miguel Miguel 38 28 33 44
14 Argentino Merlo Argentino 38 31 45 44
15 Luján Luján 38 28 37 43
16 Dep. Español Dep. 38 31 42 43
17 El Porvenir El Porvenir 38 40 44 42
18 Sacachispas Sacachispas 38 37 54 40
19 Def. Unidos Def. Unidos 38 29 47 40
20 Liniers Liniers 38 28 50 38
TEMPORADA 2010/2011
PRIMERA C
Equipo PJ GF GC Puntos
1 General Lamadrid General 38 57 34 75
2 Argentino Merlo Argentino 38 49 33 71
3 Talleres R. Escalada Talleres 38 58 40 69
4 Central Córdoba Rosario Central 38 51 28 64
5 Laferrere Laferrere 38 51 33 64
6 Liniers Liniers 38 53 43 64
7 UAI Urquiza UAI Urquiza 38 51 35 58
8 Excursionistas Excursionist 38 33 27 56
9 Berazategui Berazategui 38 42 39 55
10 JJ Urquiza JJ Urquiza 38 37 41 50
11 Luján Luján 38 26 37 49
12 Def. Unidos Def. Unidos 38 44 54 48
13 Villa Dálmine Villa 38 48 47 46
14 CA San Miguel Miguel 38 32 40 40
15 Defensores de Cambaceres Defensores 38 23 35 38
16 El Porvenir El Porvenir 38 35 56 37
17 Midland Midland 38 25 38 35
18 Leandro Nicéforo Alem Leandro 38 32 48 32
19 Sacachispas Sacachispas 38 27 47 32
20 Fénix Bs As Fénix 38 27 46 30
TEMPORADA 2009/2010
PRIMERA C
Equipo PJ GF GC Puntos
1 Barracas Central Barracas 38 55 24 73
2 Excursionistas Excursionist 38 57 28 73
3 Def. Unidos Def. Unidos 38 59 43 65
4 Sacachispas Sacachispas 38 52 52 58
5 Talleres R. Escalada Talleres 38 46 40 57
6 JJ Urquiza JJ Urquiza 38 45 41 55
7 Arg. Rosario Arg. Rosario 38 50 42 54
8 El Porvenir El Porvenir 38 39 43 53
9 Midland Midland 38 27 32 53
10 CA San Miguel Miguel 38 36 37 52
11 Laferrere Laferrere 38 41 38 50
12 Berazategui Berazategui 38 34 38 48
13 Defensores de Cambaceres Defensores 38 40 54 48
14 Leandro Nicéforo Alem Leandro 38 38 42 46
15 Fénix Bs As Fénix 38 45 50 46
16 General Lamadrid General 38 41 52 43
17 Argentino Merlo Argentino 38 30 40 42
18 Villa Dálmine Villa 38 27 39 40
19 Luján Luján 38 35 45 37
20 Sportivo Barracas Sportivo 38 27 44 37

  USO DE MEMORIA  
7,531,016 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0013
Controller Execution Time ( Home / Category )  0.1336
Total Execution Time  0.1350
  CADENA URL  
/historico/Defensores-Unidos
  GET DATOS  
$_GET['/historico/Defensores-Unidos']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (36)  
0.0038  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=6596 AND type_rel = 2
0.0019  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 2 AND rel.typeId = 6596 AND rel.ln = 'es' ORDER BY rel.cover_points DESC LIMIT 5
0.0024  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 (41098,219369,219440,263565,267221) ORDER BY n.cover_points DESC, update_date DESC
0.0023  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 = '6596' 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.0023  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=6596 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 (75057,70412) 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 = 75057 AND teamId = 6596
0.0023  SELECT count(id) as num_players from rel_players WHERE league_id = 70412 AND teamId = 6596
0.0021  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 = '6596' 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 = '6596' 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 = '6596' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0034  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 = 6596 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.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 = 75057 WHERE rp.league_id = 75057 AND rp.teamId = 6596 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0025  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 = 6596 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 = 6596 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
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 = 70716 AND t.round = 38 ORDER BY team.conference ASC,t.position 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 `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 = 66543 AND t.round = 17 ORDER BY team.conference ASC,t.position 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 `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 = 67782 AND t.round = 17 ORDER BY team.conference ASC,t.position 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 `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 = 62711 AND t.round = 17 ORDER BY team.conference ASC,t.position 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 `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 = 61660 AND t.round = 17 ORDER BY team.conference ASC,t.position 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 `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 = 50672 AND t.round = 17 ORDER BY team.conference ASC,t.position 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 `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 = 50673 AND t.round = 8 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 = 60160 AND t.round = 5 ORDER BY team.conference ASC,t.position 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 `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 = 44805 AND t.round = 38 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 `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 = 39733 AND t.round = 38 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 `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 = 34589 AND t.round = 38 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 `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 = 20255 AND t.round = 19 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 `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 = 3954 AND t.round = 18 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 = 9531 AND t.round = 38 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 `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 = 2516 AND t.round = 38 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 `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 = 2001 AND t.round = 38 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 `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 = 1658 AND t.round = 38 ORDER BY team.conference 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 `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 = 26830 AND t.round = 38 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 `tables2010` 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 = 26829 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC