4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del CSyD Villa Española
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
CLAUSURA URUGUAY
Equipo PJ GF GC Puntos
1 Peñarol Peñarol 15 27 11 32
2 Nacional Nacional 15 23 15 30
3 Montevideo Wanderers Montevideo 15 23 18 27
4 Cerro Largo Cerro Largo 15 24 11 26
5 Montevideo City Torque Montevideo 15 26 19 25
6 Progreso Progreso 15 12 7 25
7 Boston River Boston River 15 24 25 22
8 Cerrito Cerrito 15 20 22 21
9 Plaza Colonia Plaza 15 20 18 20
10 Fénix Fénix 15 18 18 19
11 Deportivo Maldonado Deportivo 15 13 18 17
12 River Plate Montevideo River Plate 15 18 22 16
13 Liverpool Montevideo Liverpool 15 15 19 15
14 Rentistas Rentistas 15 18 24 14
15 Sud América América 15 14 26 13
16 CSyD Villa Española CSyD Villa. 15 12 34 6
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
Equipo PJ GF GC Puntos
1 Montevideo City Torque Montevideo 28 48 23 56
2 Atenas Atenas 28 40 26 47
3 Progreso Progreso 28 39 27 42
4 Cerro Largo Cerro Largo 28 30 27 42
5 Cerrito Cerrito 28 26 35 42
6 Deportivo Maldonado Deportivo 28 29 31 39
7 Central Español FC Central 28 32 38 39
8 Rentistas Rentistas 28 43 38 36
9 Villa Teresa Villa Teresa 28 40 36 36
10 CSyD Villa Española CSyD Villa. 28 26 27 35
11 Tacuarembó FC Tacuarembó 28 33 34 34
12 Miramar Misiones Miramar 28 25 31 31
13 Huracán FC Huracán FC 28 33 43 30
14 Canadian Canadian 28 29 36 28
15 Oriental Oriental 28 31 52 28
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
PRIMERA AMATEUR URUGUAY - CLAUSURA
Equipo PJ GF GC Puntos
1 CSyD Villa Española CSyD Villa. 6 13 6 13
2 Basáñez Basáñez 6 14 7 12
3 Oriental Oriental 6 15 15 6
4 Potencia Potencia 6 10 24 4
TEMPORADA 2008/2009
CLAUSURA URUGUAY
Equipo PJ GF GC Puntos
1 Defensor Sporting Defensor 14 29 15 34
2 River Plate Montevideo River Plate 14 33 19 30
3 Cerro CA Cerro CA 14 30 13 29
4 Liverpool Montevideo Liverpool 14 23 17 25
5 Peñarol Peñarol 14 22 15 23
6 Nacional Nacional 14 27 21 23
7 Racing Montevideo Racing 14 22 17 23
8 Montevideo Wanderers Montevideo 14 25 24 21
9 Cerro Largo Cerro Largo 14 20 20 19
10 Danubio Danubio 14 20 24 15
11 Central Español FC Central 14 16 24 12
12 Tacuarembó FC Tacuarembó 14 16 25 12
13 Bella Vista Bella Vista 14 16 28 10
14 Juventud Juventud 14 15 34 8
15 Rampla Juniors Rampla 14 17 35 5
16 CSyD Villa Española CSyD Villa. 0 0 0 0
TEMPORADA 2007/2008
SEGUNDA URUGUAY - CLAUSURA
Equipo PJ GF GC Puntos
1 Cerrito Cerrito 15 27 13 33
2 Racing Montevideo Racing 15 27 12 28
3 Atenas Atenas 15 26 17 26
4 La Luz FC La Luz FC 15 19 14 25
5 Basáñez Basáñez 15 20 15 22
6 Cerro Largo Cerro Largo 15 21 17 22
7 Rentistas Rentistas 15 21 21 21
8 Durazno FC Durazno FC 15 19 16 20
9 CSyD Villa Española CSyD Villa. 15 24 25 20
10 Plaza Colonia Plaza 15 21 19 19
11 Rocha FC Rocha FC 15 22 28 19
12 El Tanque Sisley Tanque 15 14 20 16
13 Huracán Buceo Huracán 15 13 25 16
14 Sud América América 15 13 23 15
15 Boston River Boston River 15 12 22 12
16 Deportivo Maldonado Deportivo 15 12 24 12
TEMPORADA 2002/2003
CLAUSURA URUGUAY
Equipo PJ GF GC Puntos
1 Peñarol Peñarol 17 30 13 39
2 Liverpool Montevideo Liverpool 17 23 15 31
3 Fénix Fénix 17 21 16 29
4 Defensor Sporting Defensor 17 30 20 28
5 Miramar Misiones Miramar 17 26 21 28
6 Cerro CA Cerro CA 17 22 17 27
7 River Plate Montevideo River Plate 17 26 25 27
8 Danubio Danubio 17 21 21 27
9 Nacional Nacional 17 29 23 26
10 Bella Vista Bella Vista 17 23 22 26
11 Deportivo Maldonado Deportivo 17 16 14 23
12 Deportivo Colonia Deportivo 17 24 23 23
13 Central Español FC Central 17 17 20 22
14 Montevideo Wanderers Montevideo 17 19 24 19
15 Tacuarembó FC Tacuarembó 17 19 23 17
16 Plaza Colonia Plaza 17 16 30 11
17 CSyD Villa Española CSyD Villa. 17 14 29 8
18 Juventud Juventud 17 17 37 8
TEMPORADA 2001/2002
APERTURA URUGUAY GRUPO 1
Equipo PJ GF GC Puntos
1 Peñarol Peñarol 17 41 22 36
2 Nacional Nacional 17 40 24 32
3 Fénix Fénix 17 40 26 32
4 Danubio Danubio 17 37 24 32
5 Plaza Colonia Plaza 17 25 16 32
6 Defensor Sporting Defensor 17 32 16 31
7 Central Español FC Central 17 28 30 31
8 Montevideo Wanderers Montevideo 17 24 26 25
9 Deportivo Maldonado Deportivo 17 31 22 24
10 CSyD Villa Española CSyD Villa. 17 27 29 22
11 Tacuarembó FC Tacuarembó 17 18 20 21
12 River Plate Montevideo River Plate 17 29 34 21
13 Paysandú FC Paysandú 17 17 29 19
14 Cerro CA Cerro CA 17 20 27 18
15 Bella Vista Bella Vista 17 23 30 16
16 Racing Montevideo Racing 17 19 33 16
17 Juventud Juventud 17 19 38 12
18 Progreso Progreso 17 17 41 5

  USO DE MEMORIA  
6,297,464 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0012
Controller Execution Time ( Home / Category )  0.1361
Total Execution Time  0.1373
  CADENA URL  
/historico/Csyd-Villa-Espanola
  GET DATOS  
$_GET['/historico/Csyd-Villa-Espanola']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (39)  
0.0055  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 = 'Csyd-Villa-Espanola' 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=866 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=866 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=866 AND type_rel = 2
0.0029  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 2 AND rel.typeId = 866 AND rel.ln = 'es' ORDER BY rel.cover_points DESC LIMIT 5
0.0026  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 (40906,110243,138878,615199,996833) ORDER BY n.cover_points DESC, update_date DESC
0.0030  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 = '866' ORDER BY l.year DESC,cat.coefficient DESC
0.0027  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 = '866' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0024  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=866 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 (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.0020  SELECT count(id) as num_players from rel_players WHERE league_id = 73584 AND teamId = 866
0.0021  SELECT count(id) as num_players from rel_players WHERE league_id = 73658 AND teamId = 866
0.0028  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 = '866' 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 = '866' and rp.type = 4
0.0024  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 = '866' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
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 = 73584 WHERE rp.league_id = 73584 AND rp.teamId = 866 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.0026  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 = 866 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0024  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 = 866 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0033  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 = 866 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 `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.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 `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.0023  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables2021` as t INNER JOIN teams as team ON team.id = t.team INNER JOIN datateams as dt ON team.teamId = dt.id WHERE t.league_id = 62425 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.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 = 64096 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.0021  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables2020` as t INNER JOIN teams as team ON team.id = t.team INNER JOIN datateams as dt ON team.teamId = dt.id WHERE t.league_id = 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.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 `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.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 `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 = 42967 AND t.round = 26 ORDER BY team.conference 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 `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.0030  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 = 34701 AND t.round = 15 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0029  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.0029  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.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 = 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.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 `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 = 15154 AND t.round = 6 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 `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
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 `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 = 1031 AND t.round = 14 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 `tables2008` 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 = 14399 AND t.round = 17 ORDER BY team.conference 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 `tables2008` 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 = 14400 AND t.round = 15 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 `tables2003` 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 = 13533 AND t.round = 17 ORDER BY team.conference 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 `tables2003` 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 = 13538 AND t.round = 17 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0030  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 `tables2002` 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 = 27665 AND t.round = 17 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC