4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del Leandro Nicéforo Alem
TEMPORADA 2023/2024
PRIMERA C - CLAUSURA
Equipo PJ GF GC Puntos
1 Arg. Rosario Arg. Rosario 0 0 0 0
2 Berazategui Berazategui 0 0 0 0
3 CA Atlas CA Atlas 0 0 0 0
4 CA Lugano CA Lugano 0 0 0 0
5 Central Ballester Central 0 0 0 0
6 Central Córdoba Rosario Central 0 0 0 0
7 Centro Español Centro 0 0 0 0
8 Claypole Claypole 0 0 0 0
9 Defensores de Cambaceres Defensores 0 0 0 0
10 Dep. Español Dep. 0 0 0 0
11 Dep. Muñiz Dep. Muñiz 0 0 0 0
12 Dep. Paraguayo Dep. 0 0 0 0
13 El Porvenir El Porvenir 0 0 0 0
14 General Lamadrid General 0 0 0 0
15 Ituzaingó Ituzaingó 0 0 0 0
16 JJ Urquiza JJ Urquiza 0 0 0 0
17 Juventud Unida Juventud 0 0 0 0
18 Leandro Nicéforo Alem Leandro 0 0 0 0
19 Luján Luján 0 0 0 0
20 Mercedes Mercedes 0 0 0 0
21 Puerto Nuevo Puerto Nuevo 0 0 0 0
22 Real Pilar Real Pilar 0 0 0 0
23 Sportivo Barracas Sportivo 0 0 0 0
24 Victoriano Arenas Victoriano 0 0 0 0
25 Yupanqui Yupanqui 0 0 0 0
TEMPORADA 2022/2023
PRIMERA C GRUPO 1
Equipo PJ GF GC Puntos
1 Excursionistas Excursionist 36 52 32 64
2 San Martín Burzaco Martín 36 55 44 64
3 Laferrere Laferrere 36 39 26 61
4 Liniers Liniers 36 40 30 60
5 Midland Midland 36 52 41 59
6 Sportivo Italiano Sportivo 36 39 32 58
7 JJ Urquiza JJ Urquiza 36 44 31 57
8 Claypole Claypole 36 38 25 56
9 General Lamadrid General 36 44 41 53
10 CA Atlas CA Atlas 36 47 42 50
11 Real Pilar Real Pilar 36 36 36 50
12 Luján Luján 36 31 27 49
13 Dep. Español Dep. 36 40 37 49
14 Berazategui Berazategui 36 38 42 44
15 Central Córdoba Rosario Central 36 28 37 41
16 Leandro Nicéforo Alem Leandro 36 24 40 36
17 Puerto Nuevo Puerto Nuevo 36 29 47 34
18 Victoriano Arenas Victoriano 36 26 53 31
19 Yupanqui Yupanqui 36 23 62 25
TEMPORADA 2021/2022
PRIMERA C GRUPO 2
Equipo PJ GF GC Puntos
1 Argentino Merlo Argentino 18 32 16 39
2 Dep. Español Dep. 18 23 10 38
3 Claypole Claypole 18 27 19 32
4 Real Pilar Real Pilar 18 24 14 31
5 Excursionistas Excursionist 18 26 18 31
6 Puerto Nuevo Puerto Nuevo 18 16 15 29
7 Laferrere Laferrere 18 20 16 28
8 Sportivo Italiano Sportivo 18 19 14 27
9 CA Atlas CA Atlas 18 17 16 27
10 Berazategui Berazategui 18 27 25 26
11 Central Córdoba Rosario Central 18 20 18 25
12 Luján Luján 18 18 23 21
13 Liniers Liniers 18 21 24 20
14 Midland Midland 18 17 22 19
15 San Martín Burzaco Martín 18 12 19 16
16 General Lamadrid General 18 16 24 16
17 Leandro Nicéforo Alem Leandro 18 11 26 14
18 Victoriano Arenas Victoriano 18 13 26 13
19 El Porvenir El Porvenir 18 13 27 12
TEMPORADA 2020/2021
PRIMERA C GRUPO 2
Equipo PJ GF GC Puntos
1 Berazategui Berazategui 18 31 19 37
2 Ituzaingó Ituzaingó 18 23 12 37
3 Dep. Español Dep. 18 21 12 33
4 Sportivo Italiano Sportivo 18 21 11 29
5 Laferrere Laferrere 18 21 21 28
6 Excursionistas Excursionist 18 25 23 27
7 Claypole Claypole 18 19 18 26
8 Central Córdoba Rosario Central 18 15 14 26
9 Argentino Merlo Argentino 18 32 26 25
10 Dock Sud Dock Sud 18 19 21 25
11 Real Pilar Real Pilar 18 16 10 23
12 General Lamadrid General 18 21 23 22
13 San Martín Burzaco Martín 18 17 23 21
14 CA Atlas CA Atlas 18 20 26 20
15 Luján Luján 18 18 20 19
16 Victoriano Arenas Victoriano 18 26 30 18
17 Midland Midland 18 16 22 17
18 Leandro Nicéforo Alem Leandro 18 9 21 16
19 El Porvenir El Porvenir 18 10 28 6
TEMPORADA 2019/2020
PRIMERA C GRUPO 1
Equipo PJ GF GC Puntos
1 Cañuelas Cañuelas 18 25 15 39
2 Laferrere Laferrere 18 23 13 37
3 Dock Sud Dock Sud 18 26 13 33
4 Real Pilar Real Pilar 18 25 16 30
5 Argentino Merlo Argentino 18 29 17 29
6 General Lamadrid General 18 20 15 29
7 Berazategui Berazategui 18 28 20 28
8 Sportivo Italiano Sportivo 18 17 20 25
9 Central Córdoba Rosario Central 18 23 20 24
10 Deportivo Merlo Deportivo 18 14 19 24
11 Dep. Español Dep. 18 17 24 23
12 Midland Midland 18 21 19 22
13 San Martín Burzaco Martín 18 16 18 21
14 Leandro Nicéforo Alem Leandro 18 20 22 20
15 Victoriano Arenas Victoriano 18 15 24 20
16 Luján Luján 18 19 23 17
17 Ituzaingó Ituzaingó 18 12 19 17
18 Excursionistas Excursionist 18 16 28 15
19 El Porvenir El Porvenir 18 8 29 8
TEMPORADA 2018/2019
PRIMERA C
Equipo PJ GF GC Puntos
1 Arg. Quilmes Arg. Quilmes 38 53 32 69
2 Dep. Armenio Dep. Armenio 38 46 27 67
3 Dock Sud Dock Sud 38 41 25 66
4 Laferrere Laferrere 38 57 39 61
5 Excursionistas Excursionist 38 44 40 57
6 Midland Midland 38 45 37 55
7 Villa San Carlos Villa Carlos 38 42 32 54
8 Luján Luján 38 42 37 50
9 Deportivo Merlo Deportivo 38 41 41 50
10 Berazategui Berazategui 38 35 38 50
11 Sportivo Italiano Sportivo 38 41 42 49
12 El Porvenir El Porvenir 38 40 46 48
13 Ituzaingó Ituzaingó 38 29 40 44
14 Victoriano Arenas Victoriano 38 47 53 43
15 Leandro Nicéforo Alem Leandro 38 35 42 43
16 General Lamadrid General 38 38 46 43
17 Central Córdoba Rosario Central 38 34 44 43
18 San Martín Burzaco Martín 38 27 40 38
19 Cañuelas Cañuelas 38 44 58 38
20 Sportivo Barracas Sportivo 38 28 50 32
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 D
Equipo PJ GF GC Puntos
1 Ituzaingó Ituzaingó 30 36 17 66
2 Leandro Nicéforo Alem Leandro 30 43 15 65
3 CA Atlas CA Atlas 30 47 28 55
4 Arg. Rosario Arg. Rosario 30 36 20 55
5 Victoriano Arenas Victoriano 30 36 25 50
6 General Lamadrid General 30 31 24 45
7 Juventud Unida Juventud 30 30 28 40
8 Central Ballester Central 30 27 32 37
9 Claypole Claypole 30 33 27 35
10 Dep. Paraguayo Dep. 30 27 38 35
11 Puerto Nuevo Puerto Nuevo 30 22 39 34
12 Liniers Liniers 30 27 32 33
13 CA Lugano CA Lugano 30 23 36 31
14 Yupanqui Yupanqui 30 20 34 28
15 Dep. Muñiz Dep. Muñiz 30 23 38 28
16 Centro Español Centro 30 25 53 21
TEMPORADA 2015/2016
PRIMERA D
Equipo PJ GF GC Puntos
1 El Porvenir El Porvenir 14 17 7 28
2 Ituzaingó Ituzaingó 14 21 10 27
3 Arg. Rosario Arg. Rosario 14 21 11 27
4 Victoriano Arenas Victoriano 14 15 13 22
5 Juventud Unida Juventud 14 15 14 21
6 Puerto Nuevo Puerto Nuevo 14 17 20 21
7 CA Atlas CA Atlas 14 22 16 20
8 Yupanqui Yupanqui 14 15 17 19
9 Leandro Nicéforo Alem Leandro 14 15 14 17
10 Dep. Muñiz Dep. Muñiz 14 14 16 17
11 CA Lugano CA Lugano 14 13 15 17
12 Dep. Paraguayo Dep. 14 9 15 14
13 Central Ballester Central 14 11 20 14
14 General Lamadrid General 14 5 10 13
15 Claypole Claypole 14 7 19 9
TEMPORADA 2014/2015
PRIMERA D
Equipo PJ GF GC Puntos
1 Sportivo Barracas Sportivo 30 46 25 61
2 CA Atlas CA Atlas 30 48 21 58
3 Liniers Liniers 30 41 27 58
4 El Porvenir El Porvenir 30 42 22 56
5 Central Ballester Central 30 35 29 48
6 Dep. Muñiz Dep. Muñiz 30 33 30 44
7 CA Lugano CA Lugano 30 39 38 44
8 Dep. Paraguayo Dep. 30 28 24 42
9 Ituzaingó Ituzaingó 30 22 21 42
10 Yupanqui Yupanqui 30 31 31 38
11 Leandro Nicéforo Alem Leandro 30 33 35 38
12 Puerto Nuevo Puerto Nuevo 30 41 33 34
13 Arg. Rosario Arg. Rosario 30 19 40 31
14 Claypole Claypole 30 29 43 29
15 Victoriano Arenas Victoriano 30 23 44 21
16 Centro Español Centro 30 10 57 4
TEMPORADA 2013/2014
PRIMERA D
Equipo PJ GF GC Puntos
1 Dep. Riestra Dep. Riestra 34 66 30 75
2 San Martín Burzaco Martín 34 53 29 65
3 Leandro Nicéforo Alem Leandro 34 38 22 60
4 Juventud Unida Juventud 34 44 33 55
5 Yupanqui Yupanqui 34 49 40 54
6 CA San Miguel Miguel 34 38 30 53
7 Victoriano Arenas Victoriano 34 34 35 47
8 Claypole Claypole 34 41 33 46
9 Arg. Rosario Arg. Rosario 34 41 50 45
10 Cañuelas Cañuelas 34 36 31 45
11 Dep. Muñiz Dep. Muñiz 34 33 43 42
12 CA Atlas CA Atlas 34 46 42 42
13 Sportivo Barracas Sportivo 34 40 50 39
14 Central Ballester Central 34 28 49 37
15 El Porvenir El Porvenir 34 25 36 36
16 Centro Español Centro 34 25 43 35
17 CA Lugano CA Lugano 34 18 27 34
18 Dep. Paraguayo Dep. 34 26 58 25
TEMPORADA 2012/2013
PRIMERA D
Equipo PJ GF GC Puntos
1 Arg. Quilmes Arg. Quilmes 34 64 18 83
2 Dep. Riestra Dep. Riestra 34 48 20 69
3 San Martín Burzaco Martín 34 59 33 66
4 Ituzaingó Ituzaingó 34 32 18 57
5 Juventud Unida Juventud 34 35 20 55
6 Leandro Nicéforo Alem Leandro 34 37 30 55
7 Centro Español Centro 34 43 24 54
8 Dep. Muñiz Dep. Muñiz 34 33 30 53
9 Victoriano Arenas Victoriano 34 37 30 48
10 CA Lugano CA Lugano 34 39 38 44
11 CA Atlas CA Atlas 34 34 33 44
12 Claypole Claypole 34 25 47 38
13 Arg. Rosario Arg. Rosario 34 29 43 33
14 Cañuelas Cañuelas 34 21 38 33
15 Central Ballester Central 34 33 55 32
16 Dep. Paraguayo Dep. 34 22 55 27
17 Yupanqui Yupanqui 34 21 46 25
18 Puerto Nuevo Puerto Nuevo 34 19 53 22
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

  USO DE MEMORIA  
7,135,392 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0013
Controller Execution Time ( Home / Category )  0.5641
Total Execution Time  0.5655
  CADENA URL  
/historico/Leandro-Nicefo
  GET DATOS  
$_GET['/historico/Leandro-Nicefo']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (40)  
0.0212  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 = 75216
0.0105  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=6593 AND type_rel = 2
0.0105  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=2941 AND type_rel = 3
0.0113  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 = '6593' ORDER BY l.year DESC,cat.coefficient DESC
0.0110  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 = '6593' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0108  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 = 75216 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0108  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 = 75060 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0110  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=6593 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0107  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 (75216,75060,70845) 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.0108  SELECT count(id) as num_players from rel_players WHERE league_id = 75060 AND teamId = 6593
0.0108  SELECT count(id) as num_players from rel_players WHERE league_id = 75216 AND teamId = 6593
0.0109  SELECT count(id) as num_players from rel_players WHERE league_id = 70845 AND teamId = 6593
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 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 = 75060 AND t.round = 15 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0106  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 = '6593' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0106  SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '6593' 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 = '6593' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0114  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 = 75060 WHERE rp.league_id = 75060 AND rp.teamId = 6593 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.0109  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 = 75060 WHERE rp.league_id = 75060 AND rp.teamId = 6593 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0111  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 = 75060 WHERE rp.league_id = 75060 AND rp.teamId = 6593 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0114  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 = 6593 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 = 75060 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.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 `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 = 75216 AND t.round = 1 ORDER BY team.conference ASC,t.position 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 `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 = 70845 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.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 `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 = 66544 AND t.round = 19 ORDER BY team.conference ASC,t.position 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 `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 = 67783 AND t.round = 19 ORDER BY team.conference ASC,t.position 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 `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 = 61661 AND t.round = 19 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 = 62712 AND t.round = 19 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0109  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 = 50704 AND t.round = 9 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 = 60199 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.0109  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 = 50703 AND t.round = 19 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 `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 = 44825 AND t.round = 38 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 `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.0109  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 = 34594 AND t.round = 30 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 `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 = 20257 AND t.round = 15 ORDER BY team.conference 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 `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 = 3956 AND t.round = 18 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 `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 = 9540 AND t.round = 30 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 `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 = 2550 AND t.round = 34 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 `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 = 2002 AND t.round = 34 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 `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.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 `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