4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del Talleres R. Escalada

Talleres R. Escalada

Entrenador: Martín Rolón

Temporada 2023/2024
TEMPORADA 2023/2024
PRIMERA NACIONAL
Equipo PJ GF GC Puntos
1 San Martín Tucumán Martín 14 14 5 25
2 San Martín San Juan Martín Juan 14 13 10 24
3 Quilmes Quilmes 13 16 6 23
4 CA Estudiantes Estudiantes 14 9 7 22
5 Ferro Carril Oeste Ferro Carril 14 21 17 20
6 All Boys All Boys 14 9 7 20
7 Arsenal de Sarandí Arsenal 14 11 11 20
8 CA San Miguel Miguel 13 11 8 19
9 Chacarita Juniors Chacarita 14 15 14 19
10 Gimnasia Jujuy Gimnasia 14 11 12 18
11 Argentino Agropecuario Argentino 14 18 15 17
12 Racing Córdoba Racing 13 10 11 17
13 Dep. Maipú Dep. Maipú 14 11 18 17
14 Alvarado Alvarado 13 9 12 16
15 Guillermo Brown Guillermo 14 11 15 14
16 Talleres R. Escalada Talleres 13 9 14 14
17 Tristán Suárez Tristán 14 15 20 13
18 Patronato Patronato 13 9 15 13
19 Club Atlético Güemes Club 14 8 14 11
20 Colón Colón 14 25 9 31
21 San Telmo San Telmo 14 21 9 29
22 Def. Belgrano Def. 14 22 11 26
23 Estudiantes Río Cuarto Estudiantes 14 15 9 23
24 Gimnasia y Tiro Gimnasia 14 12 6 23
25 Aldosivi Aldosivi 14 15 10 22
26 Nueva Chicago Nueva 14 11 7 21
27 Atlanta Atlanta 14 12 15 19
28 Deportivo Morón Deportivo 14 15 17 18
29 Temperley Temperley 14 13 13 17
30 Def. Unidos Def. Unidos 14 14 17 17
31 Gimnasia Mendoza Gimnasia 14 14 17 17
32 Deportivo Madryn Deportivo 14 10 12 16
33 Chaco For Ever Chaco Ever 14 13 13 15
34 Atlético Mitre SdE Atlético 14 6 8 15
35 Almagro Almagro 14 8 20 14
36 Atletico Rafaela Atletico 14 10 16 10
37 Almirante Brown Almirante 14 7 16 8
38 Brown Adrogue Brown 14 8 25 8
TEMPORADA 2022/2023
PRIMERA B GRUPO 2
Equipo PJ GF GC Puntos
1 Talleres R. Escalada Talleres 16 18 4 37
2 CA San Miguel Miguel 16 24 14 30
3 Arg. Quilmes Arg. Quilmes 16 23 15 30
4 Dep. Armenio Dep. Armenio 16 17 10 25
5 Los Andes Los Andes 16 18 13 24
6 Colegiales Colegiales 16 17 16 23
7 Deportivo Merlo Deportivo 16 16 19 22
8 Comunicaciones Comunicacion 16 15 14 21
9 Acassuso Acassuso 16 12 13 20
10 Argentino Merlo Argentino 16 11 14 20
11 UAI Urquiza UAI Urquiza 16 16 18 19
12 Fénix Bs As Fénix 16 13 14 18
13 Cañuelas Cañuelas 16 12 15 16
14 Villa San Carlos Villa Carlos 16 17 25 15
15 Dock Sud Dock Sud 16 13 17 14
16 Sacachispas Sacachispas 16 8 15 13
17 Ituzaingó Ituzaingó 16 5 19 12
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 2
Equipo PJ GF GC Puntos
1 Flandria Flandria 16 34 12 34
2 Colegiales Colegiales 16 23 11 30
3 Sacachispas Sacachispas 16 22 8 29
4 Acassuso Acassuso 16 21 9 28
5 JJ Urquiza JJ Urquiza 16 24 20 27
6 Cañuelas Cañuelas 16 23 17 24
7 Los Andes Los Andes 16 17 13 20
8 Dep. Armenio Dep. Armenio 16 13 18 20
9 UAI Urquiza UAI Urquiza 16 19 23 19
10 Comunicaciones Comunicacion 16 17 22 19
11 Talleres R. Escalada Talleres 16 14 15 18
12 Def. Unidos Def. Unidos 16 13 22 18
13 CA San Miguel Miguel 16 17 25 17
14 Deportivo Merlo Deportivo 16 16 19 16
15 Villa San Carlos Villa Carlos 16 16 26 15
16 Arg. Quilmes Arg. Quilmes 16 16 28 13
17 Fénix Bs As Fénix 16 10 27 10
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 B GRUPO 1
Equipo PJ GF GC Puntos
1 Platense Platense 34 45 21 64
2 CA Estudiantes Estudiantes 34 42 25 64
3 Acassuso Acassuso 34 38 21 54
4 Atlanta Atlanta 34 42 32 52
5 Def. Belgrano Def. 34 38 29 52
6 Barracas Central Barracas 34 45 38 51
7 Tristán Suárez Tristán 34 48 38 50
8 UAI Urquiza UAI Urquiza 34 28 29 49
9 Talleres R. Escalada Talleres 34 32 36 49
10 CA San Miguel Miguel 34 32 40 43
11 San Telmo San Telmo 34 28 36 43
12 Sacachispas Sacachispas 34 35 47 42
13 Comunicaciones Comunicacion 34 38 41 41
14 Fénix Bs As Fénix 34 38 43 39
15 Colegiales Colegiales 34 34 44 39
16 Villa San Carlos Villa Carlos 34 35 48 38
17 Dep. Español Dep. 34 27 40 31
18 Almirante Brown Almirante 34 27 44 29
TEMPORADA 2016/2017
PRIMERA B
Equipo PJ GF GC Puntos
1 Deportivo Morón Deportivo 36 47 22 66
2 Dep. Riestra Dep. Riestra 36 53 37 58
3 Atlanta Atlanta 36 45 33 57
4 Comunicaciones Comunicacion 36 45 33 55
5 Def. Belgrano Def. 36 32 28 54
6 CA Estudiantes Estudiantes 36 42 38 52
7 Barracas Central Barracas 36 50 40 51
8 Dep. Español Dep. 36 38 33 51
9 Platense Platense 36 32 30 51
10 Almirante Brown Almirante 36 30 38 51
11 San Telmo San Telmo 36 42 38 49
12 UAI Urquiza UAI Urquiza 36 33 39 48
13 Fénix Bs As Fénix 36 40 37 46
14 Tristán Suárez Tristán 36 31 47 41
15 Acassuso Acassuso 36 36 35 40
16 Talleres R. Escalada Talleres 36 43 52 40
17 Colegiales Colegiales 36 32 48 37
18 Villa San Carlos Villa Carlos 36 26 41 36
19 Excursionistas Excursionist 36 32 60 31
TEMPORADA 2015/2016
PRIMERA B
Equipo PJ GF GC Puntos
1 Flandria Flandria 19 15 9 37
2 Atlanta Atlanta 19 28 17 35
3 Colegiales Colegiales 19 26 17 32
4 Deportivo Morón Deportivo 19 26 19 32
5 Fénix Bs As Fénix 19 21 14 32
6 Talleres R. Escalada Talleres 19 24 22 28
7 Tristán Suárez Tristán 19 24 27 27
8 Barracas Central Barracas 19 20 17 26
9 San Telmo San Telmo 19 20 18 26
10 Comunicaciones Comunicacion 19 19 18 26
11 Def. Belgrano Def. 19 16 16 23
12 Villa San Carlos Villa Carlos 19 22 24 23
13 UAI Urquiza UAI Urquiza 19 22 23 22
14 Platense Platense 19 19 21 22
15 Almirante Brown Almirante 19 17 20 22
16 Dep. Riestra Dep. Riestra 19 16 21 22
17 Dep. Español Dep. 19 15 20 22
18 Acassuso Acassuso 19 13 22 20
19 CA Estudiantes Estudiantes 19 14 22 18
20 Dep. Armenio Dep. Armenio 19 12 22 16
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

  USO DE MEMORIA  
7,344,072 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0012
Controller Execution Time ( Home / Category )  0.1519
Total Execution Time  0.1531
  CADENA URL  
/historico/Talleres-Remedios
  GET DATOS  
$_GET['/historico/Talleres-Remedios']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (42)  
0.0030  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 = 'Talleres-Remedios' 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=6588 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=6588 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=6588 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0020  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=6588 AND type_rel = 2
0.0020  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 2 AND rel.typeId = 6588 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 (55000,73259,74185,143583,152010) ORDER BY n.cover_points DESC, update_date DESC
0.0032  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 = '6588' ORDER BY l.year DESC,cat.coefficient 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 = '6588' AND l.year = 2024 ORDER BY l.year DESC,cat.coefficient DESC
0.0025  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 = '6588' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0025  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=6588 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,74909,74282) 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 = 6588
0.0020  SELECT count(id) as num_players from rel_players WHERE league_id = 74282 AND teamId = 6588
0.0024  SELECT count(id) as num_players from rel_players WHERE league_id = 74909 AND teamId = 6588
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 = '6588' 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 = '6588' 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 = '6588' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0039  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 = 6588 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.0030  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 = 6588 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 = 6588 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0028  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 = 6588 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
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 `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.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 `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 = 70844 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 `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 = 71853 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 `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.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 = 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.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 `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.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 `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 = 65948 AND t.round = 3 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 = 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.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 `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.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 = 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.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 = 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.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 `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.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 `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 = 39648 AND t.round = 34 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 = 33795 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0028  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 = 20211 AND t.round = 19 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 = 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.0037  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.0035  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.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 `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