4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del Central Español FC
TEMPORADA 2021/2022
SEGUNDA DIVISIÓN URUGUAY GRUPO 3
Equipo PJ GF GC Puntos
1 Racing Montevideo Racing 27 40 18 57
2 La Luz FC La Luz FC 27 35 23 51
3 Uruguay Montevideo Uruguay 27 35 29 44
4 Cerro CA Cerro CA 27 31 30 41
5 Miramar Misiones Miramar 27 38 32 40
6 Rampla Juniors Rampla 27 32 31 35
7 Sud América América 27 27 38 33
8 Atenas Atenas 27 24 25 32
9 Progreso Progreso 27 23 27 31
10 Juventud Juventud 27 19 28 27
11 CSyD Villa Española CSyD Villa. 27 27 37 27
12 Central Español FC Central 27 22 35 22
TEMPORADA 2020/2021
SEGUNDA DIVISIÓN URUGUAY GRUPO 1
Equipo PJ GF GC Puntos
1 Albion FC Albion FC 22 31 18 44
2 Danubio Danubio 22 24 14 41
3 Racing Montevideo Racing 22 27 16 38
4 Defensor Sporting Defensor 22 33 21 37
5 Cerro CA Cerro CA 22 26 20 37
6 Central Español FC Central 22 29 29 33
7 Juventud Juventud 22 27 27 29
8 Uruguay Montevideo Uruguay 22 21 27 25
9 Atenas Atenas 22 20 17 24
10 Rampla Juniors Rampla 22 14 32 21
11 Villa Teresa Villa Teresa 22 17 32 18
12 Rocha FC Rocha FC 22 20 36 15
TEMPORADA 2019/2020
SEGUNDA DIVISIÓN URUGUAY GRUPO 1
Equipo PJ GF GC Puntos
1 Cerrito Cerrito 22 38 23 41
2 CSyD Villa Española CSyD Villa. 22 35 24 37
3 Juventud Juventud 22 24 17 32
4 Rampla Juniors Rampla 22 27 23 32
5 Racing Montevideo Racing 22 25 26 30
6 Sud América América 22 30 33 28
7 Central Español FC Central 22 25 25 27
8 Rocha FC Rocha FC 22 20 23 27
9 Villa Teresa Villa Teresa 22 19 29 26
10 Atenas Atenas 22 23 29 24
11 Tacuarembó FC Tacuarembó 22 19 27 23
12 Albion FC Albion FC 22 22 28 22
TEMPORADA 2018/2019
SEGUNDA DIVISIÓN URUGUAY
Equipo PJ GF GC Puntos
1 Montevideo City Torque Montevideo 22 28 14 43
2 Deportivo Maldonado Deportivo 22 30 20 40
3 Rentistas Rentistas 22 28 19 39
4 CSyD Villa Española CSyD Villa. 22 30 25 36
5 Cerrito Cerrito 22 26 23 30
6 Sud América América 22 16 17 30
7 Atenas Atenas 22 30 27 29
8 Villa Teresa Villa Teresa 22 24 27 28
9 Albion FC Albion FC 22 21 28 27
10 Central Español FC Central 22 18 25 24
11 Bella Vista Bella Vista 22 23 40 20
12 Tacuarembó FC Tacuarembó 22 19 28 19
TEMPORADA 2017/2018
SEGUNDA DIVISIÓN URUGUAY
Equipo PJ GF GC Puntos
1 Cerro Largo Cerro Largo 26 33 16 51
2 Juventud Juventud 26 46 24 50
3 Plaza Colonia Plaza 26 35 28 44
4 Cerrito Cerrito 26 30 37 37
5 Villa Teresa Villa Teresa 26 39 31 36
6 Tacuarembó FC Tacuarembó 26 33 32 35
7 Deportivo Maldonado Deportivo 26 32 27 35
8 Sud América América 26 32 30 35
9 Central Español FC Central 26 30 31 32
10 CSyD Villa Española CSyD Villa. 26 32 40 29
11 Rentistas Rentistas 26 31 43 28
12 Albion FC Albion FC 26 27 36 27
13 Miramar Misiones Miramar 26 26 41 26
14 Oriental Oriental 26 29 39 24
TEMPORADA 2016/2017
SEGUNDA DIVISIÓN URUGUAY FORMATO ANTIGUO
Equipo PJ GF GC Puntos
1 El Tanque Sisley Tanque 12 23 9 29
2 Atenas Atenas 12 23 8 28
3 Cerro Largo Cerro Largo 12 17 8 27
4 Rentistas Rentistas 12 17 13 21
5 Deportivo Maldonado Deportivo 12 18 15 18
6 Montevideo City Torque Montevideo 12 13 15 15
7 Central Español FC Central 12 11 11 14
8 Villa Teresa Villa Teresa 12 17 18 13
9 Canadian Canadian 12 17 20 12
10 Miramar Misiones Miramar 12 7 15 12
11 Progreso Progreso 12 7 14 11
12 Tacuarembó FC Tacuarembó 12 7 16 9
13 Cerrito Cerrito 12 7 22 8
TEMPORADA 2015/2016
SEGUNDA DIVISIÓN URUGUAY FORMATO ANTIGUO GRUPO 2
Equipo PJ GF GC Puntos
1 Rampla Juniors Rampla 14 22 14 31
2 CSyD Villa Española CSyD Villa. 14 23 14 29
3 Boston River Boston River 14 21 13 26
4 Montevideo City Torque Montevideo 14 26 20 23
5 Progreso Progreso 14 21 16 23
6 Atenas Atenas 14 25 19 22
7 Miramar Misiones Miramar 14 18 17 19
8 Tacuarembó FC Tacuarembó 14 22 23 17
9 Cerro Largo Cerro Largo 14 16 18 17
10 Central Español FC Central 14 17 20 17
11 Rocha FC Rocha FC 14 12 15 17
12 Deportivo Maldonado Deportivo 14 12 18 14
13 Oriental Oriental 14 12 20 14
14 Huracán FC Huracán FC 14 10 23 13
15 Canadian Canadian 14 16 23 12
TEMPORADA 2014/2015
SEGUNDA DIVISIÓN URUGUAY FORMATO ANTIGUO
Equipo PJ GF GC Puntos
1 Liverpool Montevideo Liverpool 28 69 28 58
2 Plaza Colonia Plaza 28 44 37 53
3 Villa Teresa Villa Teresa 28 43 32 47
4 Boston River Boston River 28 45 41 44
5 Canadian Canadian 28 40 37 43
6 Central Español FC Central 28 39 37 43
7 CSyD Villa Española CSyD Villa. 28 51 36 42
8 Huracán FC Huracán FC 28 54 48 41
9 Miramar Misiones Miramar 28 35 30 37
10 Montevideo City Torque Montevideo 28 39 49 35
11 Cerro Largo Cerro Largo 28 27 30 32
12 Deportivo Maldonado Deportivo 28 27 43 31
13 Progreso Progreso 28 27 42 25
14 Rocha FC Rocha FC 28 26 53 25
15 Cerrito Cerrito 28 31 54 20
TEMPORADA 2013/2014
SEGUNDA DIVISIÓN URUGUAY FORMATO ANTIGUO
Equipo PJ GF GC Puntos
1 Tacuarembó FC Tacuarembó 26 41 25 48
2 Atenas Atenas 26 43 34 46
3 Deportivo Maldonado Deportivo 26 30 28 41
4 Huracán FC Huracán FC 26 33 26 40
5 Boston River Boston River 26 39 31 39
6 Rocha FC Rocha FC 26 34 26 39
7 Rampla Juniors Rampla 26 36 33 36
8 Villa Teresa Villa Teresa 26 34 31 36
9 Plaza Colonia Plaza 26 27 24 36
10 Central Español FC Central 26 33 40 36
11 Canadian Canadian 26 26 30 34
12 Progreso Progreso 26 27 38 27
13 Cerrito Cerrito 26 24 41 23
14 Montevideo City Torque Montevideo 26 27 47 15
TEMPORADA 2012/2013
CLAUSURA URUGUAY
Equipo PJ GF GC Puntos
1 Defensor Sporting Defensor 15 19 9 31
2 Peñarol Peñarol 15 26 8 30
3 River Plate Montevideo River Plate 15 27 14 30
4 Nacional Nacional 15 23 21 26
5 Danubio Danubio 15 18 16 26
6 Racing Montevideo Racing 15 17 13 24
7 Montevideo Wanderers Montevideo 15 19 14 21
8 Juventud Juventud 15 27 32 21
9 Fénix Fénix 15 18 18 19
10 El Tanque Sisley Tanque 15 16 17 18
11 Cerro CA Cerro CA 15 19 24 17
12 Liverpool Montevideo Liverpool 15 19 23 16
13 Cerro Largo Cerro Largo 15 17 20 15
14 Progreso Progreso 15 15 28 13
15 Central Español FC Central 15 13 25 12
16 Bella Vista Bella Vista 15 16 27 10
TEMPORADA 2011/2012
SEGUNDA DIVISIÓN URUGUAY FORMATO ANTIGUO
Equipo PJ GF GC Puntos
1 Central Español FC Central 24 47 18 54
2 Juventud Juventud 24 37 22 43
3 Progreso Progreso 24 36 31 42
4 Tacuarembó FC Tacuarembó 24 29 22 37
5 Huracán FC Huracán FC 24 29 31 35
6 Miramar Misiones Miramar 24 38 31 34
7 Boston River Boston River 24 30 25 33
8 Atenas Atenas 24 29 31 32
9 Sud América América 24 23 24 27
10 Plaza Colonia Plaza 24 28 42 27
11 Deportivo Maldonado Deportivo 24 27 30 26
12 Rocha FC Rocha FC 24 28 51 19
13 Villa Teresa Villa Teresa 24 20 43 12
TEMPORADA 2010/2011
CLAUSURA URUGUAY
Equipo PJ GF GC Puntos
1 Nacional Nacional 15 32 13 34
2 Defensor Sporting Defensor 15 19 12 28
3 Peñarol Peñarol 15 28 20 27
4 Fénix Fénix 15 23 15 27
5 Racing Montevideo Racing 15 26 22 24
6 Central Español FC Central 15 26 17 23
7 Cerro CA Cerro CA 15 19 22 23
8 Montevideo Wanderers Montevideo 15 24 17 20
9 Liverpool Montevideo Liverpool 15 22 20 19
10 Rampla Juniors Rampla 15 18 25 19
11 Tacuarembó FC Tacuarembó 15 17 26 19
12 River Plate Montevideo River Plate 15 29 34 17
13 Bella Vista Bella Vista 15 16 18 15
14 Danubio Danubio 15 17 26 15
15 El Tanque Sisley Tanque 15 19 30 13
16 Miramar Misiones Miramar 15 12 30 9
TEMPORADA 2009/2010
APERTURA URUGUAY
Equipo PJ GF GC Puntos
1 Nacional Nacional 15 36 11 39
2 Liverpool Montevideo Liverpool 15 31 14 29
3 Defensor Sporting Defensor 15 28 16 29
4 Montevideo Wanderers Montevideo 15 24 13 26
5 Peñarol Peñarol 15 28 19 26
6 Rampla Juniors Rampla 15 18 19 24
7 Danubio Danubio 15 26 25 23
8 River Plate Montevideo River Plate 15 24 23 23
9 Racing Montevideo Racing 15 25 22 20
10 Cerrito Cerrito 15 20 21 18
11 Cerro Largo Cerro Largo 15 15 18 16
12 Tacuarembó FC Tacuarembó 15 17 24 16
13 Central Español FC Central 15 13 28 12
14 Cerro CA Cerro CA 15 18 31 11
15 Atenas Atenas 15 9 32 11
16 Fénix Fénix 15 10 26 6
TEMPORADA 2008/2009
APERTURA URUGUAY
Equipo PJ GF GC Puntos
1 Danubio Danubio 15 27 15 32
2 Nacional Nacional 15 23 13 32
3 Defensor Sporting Defensor 15 23 12 30
4 Racing Montevideo Racing 15 24 14 27
5 Liverpool Montevideo Liverpool 15 21 15 27
6 Peñarol Peñarol 15 29 15 25
7 Cerro CA Cerro CA 16 20 12 23
8 River Plate Montevideo River Plate 15 17 17 20
9 Central Español FC Central 15 16 21 20
10 Tacuarembó FC Tacuarembó 15 16 20 17
11 Bella Vista Bella Vista 15 13 22 17
12 Montevideo Wanderers Montevideo 15 17 18 14
13 Rampla Juniors Rampla 15 16 24 14
14 CSyD Villa Española CSyD Villa. 15 11 26 12
15 Cerro Largo Cerro Largo 14 13 25 9
16 Juventud Juventud 15 9 26 8

  USO DE MEMORIA  
6,402,080 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0012
Controller Execution Time ( Home / Category )  0.5940
Total Execution Time  0.5952
  CADENA URL  
/historico/Central-Espanol-Fc
  GET DATOS  
$_GET['/historico/Central-Espanol-Fc']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (31)  
0.0151  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=720 AND type_rel = 2
0.0158  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 2 AND rel.typeId = 720 AND rel.ln = 'es' ORDER BY rel.cover_points DESC LIMIT 5
0.0162  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 (201206,216701,234791,241528,243452) ORDER BY n.cover_points DESC, update_date DESC
0.0179  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 = '720' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0185  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=720 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0150  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 (73658,73584) 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.0162  SELECT count(id) as num_players from rel_players WHERE league_id = 73584 AND teamId = 720
0.0150  SELECT count(id) as num_players from rel_players WHERE league_id = 73658 AND teamId = 720
0.0165  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 = 73584 WHERE rp.league_id = 73584 AND rp.teamId = 720 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.0161  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 = 73584 WHERE rp.league_id = 73584 AND rp.teamId = 720 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0154  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 = 73584 WHERE rp.league_id = 73584 AND rp.teamId = 720 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0157  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 = 720 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.0152  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 = 66698 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.0155  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 = 67421 AND t.round = 22 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0149  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 = 62797 AND t.round = 22 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0163  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 = 55517 AND t.round = 22 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0149  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables2019` as t INNER JOIN teams as team ON team.id = t.team INNER JOIN datateams as dt ON team.teamId = dt.id WHERE t.league_id = 49071 AND t.round = 22 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0150  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables2017` as t INNER JOIN teams as team ON team.id = t.team INNER JOIN datateams as dt ON team.teamId = dt.id WHERE t.league_id = 38209 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0148  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables2017` as t INNER JOIN teams as team ON team.id = t.team INNER JOIN datateams as dt ON team.teamId = dt.id WHERE t.league_id = 35302 AND t.round = 13 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0149  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables2016` as t INNER JOIN teams as team ON team.id = t.team INNER JOIN datateams as dt ON team.teamId = dt.id WHERE t.league_id = 15508 AND t.round = 7 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0152  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables2016` as t INNER JOIN teams as team ON team.id = t.team INNER JOIN datateams as dt ON team.teamId = dt.id WHERE t.league_id = 20258 AND t.round = 15 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0154  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables2015` as t INNER JOIN teams as team ON team.id = t.team INNER JOIN datateams as dt ON team.teamId = dt.id WHERE t.league_id = 4850 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0151  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables2014` as t INNER JOIN teams as team ON team.id = t.team INNER JOIN datateams as dt ON team.teamId = dt.id WHERE t.league_id = 3761 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0150  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 = 2214 AND t.round = 15 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0148  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 = 2308 AND t.round = 15 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0151  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 = 1640 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0151  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 = 1395 AND t.round = 15 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0148  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 = 1299 AND t.round = 15 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0148  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 = 1033 AND t.round = 15 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0148  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 = 1394 AND t.round = 15 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0149  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 `tables2009` 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 = 1032 AND t.round = 15 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC