4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del Colegiales
TEMPORADA 2023/2024
PRIMERA B
Equipo PJ GF GC Puntos
1 Arg. Quilmes Arg. Quilmes 12 17 6 25
2 Excursionistas Excursionist 14 21 12 25
3 Los Andes Los Andes 13 15 10 25
4 Dep. Armenio Dep. Armenio 14 18 11 23
5 Colegiales Colegiales 13 21 11 22
6 Dock Sud Dock Sud 14 16 15 21
7 Cañuelas Cañuelas 14 14 19 21
8 Flandria Flandria 13 13 13 19
9 Acassuso Acassuso 13 10 11 19
10 San Martín Burzaco Martín 14 9 11 19
11 Comunicaciones Comunicacion 13 17 10 18
12 Fénix Bs As Fénix 14 15 12 18
13 Midland Midland 13 12 14 18
14 Deportivo Merlo Deportivo 14 12 13 17
15 Laferrere Laferrere 13 16 18 16
16 UAI Urquiza UAI Urquiza 14 12 14 15
17 Argentino Merlo Argentino 14 11 14 14
18 Sportivo Italiano Sportivo 14 13 18 14
19 Sacachispas Sacachispas 13 9 22 14
20 Liniers Liniers 14 7 10 12
21 Villa San Carlos Villa Carlos 13 11 16 9
22 Villa Dálmine Villa 13 7 16 9
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 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 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 B
Equipo PJ GF GC Puntos
1 Brown Adrogue Brown 42 60 30 81
2 CA Estudiantes Estudiantes 42 56 32 80
3 Def. Belgrano Def. 42 44 24 79
4 Atlanta Atlanta 42 67 41 73
5 Barracas Central Barracas 42 50 43 64
6 Deportivo Morón Deportivo 42 46 41 62
7 Almagro Almagro 42 38 32 60
8 Tristán Suárez Tristán 42 47 45 58
9 Platense Platense 42 41 43 57
10 Colegiales Colegiales 42 48 46 56
11 Flandria Flandria 42 31 33 54
12 Fénix Bs As Fénix 42 35 33 53
13 Comunicaciones Comunicacion 42 39 43 51
14 Dep. Riestra Dep. Riestra 42 52 63 51
15 Acassuso Acassuso 42 22 34 47
16 Dep. Armenio Dep. Armenio 42 27 40 46
17 UAI Urquiza UAI Urquiza 42 32 40 45
18 Dep. Español Dep. 42 36 47 44
19 Sportivo Italiano Sportivo 42 38 52 44
20 Almirante Brown Almirante 42 47 63 43
21 Villa San Carlos Villa Carlos 42 34 45 42
22 Deportivo Merlo Deportivo 42 36 56 37
TEMPORADA 2013/2014
PRIMERA B
Equipo PJ GF GC Puntos
1 Nueva Chicago Nueva 40 42 23 73
2 Temperley Temperley 40 52 41 66
3 Atlanta Atlanta 40 40 25 65
4 Platense Platense 40 53 38 64
5 Def. Belgrano Def. 40 33 24 61
6 Fénix Bs As Fénix 40 53 47 60
7 Los Andes Los Andes 40 40 33 58
8 Barracas Central Barracas 40 39 34 58
9 Deportivo Morón Deportivo 40 43 38 56
10 Chacarita Juniors Chacarita 40 41 43 54
11 Deportivo Merlo Deportivo 40 40 35 53
12 Almagro Almagro 40 31 36 53
13 Tristán Suárez Tristán 40 36 40 51
14 CA Estudiantes Estudiantes 40 34 34 48
15 Dep. Armenio Dep. Armenio 40 38 39 47
16 Acassuso Acassuso 40 36 39 47
17 UAI Urquiza UAI Urquiza 40 37 52 47
18 Comunicaciones Comunicacion 40 31 38 44
19 Villa Dálmine Villa 40 34 42 44
20 Flandria Flandria 40 31 55 35
21 Colegiales Colegiales 40 22 50 30
TEMPORADA 2012/2013
PRIMERA B
Equipo PJ GF GC Puntos
1 Villa San Carlos Villa Carlos 40 41 26 72
2 Platense Platense 40 39 30 70
3 Atlanta Atlanta 40 48 39 65
4 Almagro Almagro 40 49 36 64
5 Brown Adrogue Brown 40 56 37 63
6 CA Estudiantes Estudiantes 40 46 31 63
7 Chacarita Juniors Chacarita 40 47 39 60
8 Dep. Armenio Dep. Armenio 40 52 41 58
9 Barracas Central Barracas 40 45 44 56
10 Temperley Temperley 40 38 35 55
11 Comunicaciones Comunicacion 40 41 41 54
12 Tristán Suárez Tristán 40 40 44 50
13 Los Andes Los Andes 40 31 39 48
14 Villa Dálmine Villa 40 41 51 48
15 Flandria Flandria 40 40 54 48
16 Acassuso Acassuso 40 32 51 48
17 Deportivo Morón Deportivo 40 46 52 47
18 Colegiales Colegiales 40 38 35 44
19 San Telmo San Telmo 40 35 51 37
20 Def. Belgrano Def. 40 33 47 35
21 Central Córdoba Rosario Central 40 35 50 34
TEMPORADA 2011/2012
PRIMERA B
Equipo PJ GF GC Puntos
1 Sarmiento Sarmiento 40 52 24 80
2 Colegiales Colegiales 40 54 33 73
3 CA Estudiantes Estudiantes 40 49 29 72
4 Nueva Chicago Nueva 40 56 36 70
5 Brown Adrogue Brown 40 64 34 69
6 Platense Platense 40 44 32 61
7 Los Andes Los Andes 40 44 38 61
8 Comunicaciones Comunicacion 40 42 38 60
9 Acassuso Acassuso 40 43 47 55
10 Almagro Almagro 40 43 39 54
11 Villa San Carlos Villa Carlos 40 32 41 54
12 Dep. Armenio Dep. Armenio 40 45 50 50
13 Flandria Flandria 40 36 44 50
14 San Telmo San Telmo 40 29 37 47
15 Temperley Temperley 40 40 45 46
16 Sportivo Italiano Sportivo 40 33 42 46
17 Tristán Suárez Tristán 40 48 57 45
18 Def. Belgrano Def. 40 31 43 41
19 Barracas Central Barracas 40 36 51 40
20 Deportivo Morón Deportivo 40 39 60 35
21 General Lamadrid General 40 27 67 31
TEMPORADA 2010/2011
PRIMERA B
Equipo PJ GF GC Puntos
1 Atlanta Atlanta 42 68 37 86
2 CA Estudiantes Estudiantes 42 54 43 73
3 Def. Belgrano Def. 42 48 28 71
4 Nueva Chicago Nueva 42 43 35 71
5 Brown Adrogue Brown 42 54 36 70
6 Dep. Armenio Dep. Armenio 42 43 31 65
7 Barracas Central Barracas 42 50 29 64
8 Deportivo Morón Deportivo 42 44 37 61
9 Villa San Carlos Villa Carlos 42 45 43 60
10 Comunicaciones Comunicacion 42 41 41 60
11 Almagro Almagro 42 52 51 58
12 Acassuso Acassuso 42 46 43 56
13 Flandria Flandria 42 37 31 54
14 Colegiales Colegiales 42 34 36 53
15 Platense Platense 42 31 34 53
16 Sportivo Italiano Sportivo 42 27 40 47
17 Tristán Suárez Tristán 42 40 54 46
18 Temperley Temperley 42 38 57 44
19 San Telmo San Telmo 42 35 52 42
20 Sarmiento Sarmiento 42 27 51 37
21 Dep. Español Dep. 42 26 55 35
22 Los Andes Los Andes 42 40 59 34

  USO DE MEMORIA  
7,035,488 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0012
Controller Execution Time ( Home / Category )  0.5587
Total Execution Time  0.5599
  CADENA URL  
/historico/Colegiales
  GET DATOS  
$_GET['/historico/Colegiales']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (40)  
0.0116  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 = 'Colegiales' 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.0106  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=6552 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0106  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=6552 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0105  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=6552 AND type_rel = 2
0.0108  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 2 AND rel.typeId = 6552 AND rel.ln = 'es' ORDER BY rel.cover_points DESC LIMIT 5
0.0109  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 (78303,101814,101997,135060,213451) ORDER BY n.cover_points DESC, update_date DESC
0.0123  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 = '6552' ORDER BY l.year DESC,cat.coefficient DESC
0.0112  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 = '6552' AND l.year = 2024 ORDER BY l.year DESC,cat.coefficient DESC
0.0114  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 = '6552' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0115  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=6552 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0106  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 (75059,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.0110  SELECT count(id) as num_players from rel_players WHERE league_id = 75059 AND teamId = 6552
0.0115  SELECT count(id) as num_players from rel_players WHERE league_id = 70412 AND teamId = 6552
0.0107  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 = '6552' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0105  SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '6552' and rp.type = 4
0.0107  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 = '6552' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0115  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 = 75059 WHERE rp.league_id = 75059 AND rp.teamId = 6552 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.0115  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 = 75059 WHERE rp.league_id = 75059 AND rp.teamId = 6552 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0113  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 = 75059 WHERE rp.league_id = 75059 AND rp.teamId = 6552 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0116  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 = 6552 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.0113  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 = 75059 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.0122  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.0112  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.0121  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.0120  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.0116  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.0110  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.0110  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.0110  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.0108  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.0126  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.0121  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.0115  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.0112  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.0110  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 = 3900 AND t.round = 22 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0114  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 = 9193 AND t.round = 42 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0113  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 = 2515 AND t.round = 42 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0111  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 = 2000 AND t.round = 42 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0111  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 = 1657 AND t.round = 42 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0113  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 = 13429 AND t.round = 42 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC