4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
TEMPORADA 2012/2013
SEGUNDA SUIZA
Equipo PJ GF GC Puntos
1 Aarau Aarau 36 76 40 78
2 AC Bellinzona Bellinzona 36 62 37 71
3 Winterthur Winterthur 36 61 43 62
4 FC Wil FC Wil 36 59 65 51
5 Biel-Bienne Biel-Bienne 36 59 59 47
6 Chiasso Chiasso 36 42 51 47
7 FC Lugano FC Lugano 36 52 50 44
8 Wohlen Wohlen 36 39 58 39
9 FC Vaduz FC Vaduz 36 41 52 37
10 Locarno Locarno 36 32 68 24
TEMPORADA 2011/2012
SEGUNDA SUIZA
Equipo PJ GF GC Puntos
1 St. Gallen St. Gallen 30 67 31 64
2 Aarau Aarau 30 64 34 59
3 AC Bellinzona Bellinzona 30 48 21 59
4 Winterthur Winterthur 30 44 29 53
5 FC Lugano FC Lugano 30 44 38 49
6 FC Wil FC Wil 30 59 41 46
7 Chiasso Chiasso 30 34 23 45
8 FC Vaduz FC Vaduz 30 54 45 45
9 Locarno Locarno 30 47 44 45
10 Biel-Bienne Biel-Bienne 30 55 54 43
11 Wohlen Wohlen 30 39 44 36
12 Stade Nyonnais Stade 30 41 49 34
13 Etoile Carouge Etoile 30 25 56 30
14 Delemont Delemont 30 24 60 20
15 Kriens Kriens 30 37 66 17
16 SC Bruhl SC Bruhl 30 30 77 16
TEMPORADA 2010/2011
SEGUNDA SUIZA
Equipo PJ GF GC Puntos
1 Lausanne Sports Lausanne 30 67 28 65
2 Servette Servette 30 75 27 62
3 FC Lugano FC Lugano 30 56 35 62
4 FC Vaduz FC Vaduz 30 59 41 60
5 FC Wil FC Wil 30 45 42 46
6 Stade Nyonnais Stade 30 48 51 46
7 Chiasso Chiasso 30 34 37 41
8 Delemont Delemont 30 47 60 40
9 Biel-Bienne Biel-Bienne 30 57 57 39
10 Wohlen Wohlen 30 45 44 37
11 Aarau Aarau 30 39 51 36
12 Kriens Kriens 30 26 50 33
13 Winterthur Winterthur 30 42 51 32
14 Locarno Locarno 30 40 52 31
15 Schaffhausen Schaffhausen 30 36 53 26
16 Yverdon Yverdon 30 27 64 20
TEMPORADA 2009/2010
SEGUNDA SUIZA
Equipo PJ GF GC Puntos
1 Thun Thun 30 70 36 60
2 FC Lugano FC Lugano 30 65 29 59
3 Winterthur Winterthur 30 69 46 56
4 Servette Servette 30 49 37 52
5 Kriens Kriens 30 50 41 46
6 FC Wil FC Wil 30 44 37 45
7 Biel-Bienne Biel-Bienne 30 54 39 42
8 FC Vaduz FC Vaduz 30 44 43 41
9 Yverdon Yverdon 30 50 38 39
10 Lausanne Sports Lausanne 30 40 43 39
11 Schaffhausen Schaffhausen 30 42 51 39
12 Wohlen Wohlen 30 44 55 31
13 Locarno Locarno 30 46 65 31
14 Stade Nyonnais Stade 30 36 64 31
15 Le Mont LS Le Mont LS 30 30 56 27
16 FC Gossau FC Gossau 30 27 80 13
TEMPORADA 2008/2009
SEGUNDA SUIZA
Equipo PJ GF GC Puntos
1 St. Gallen St. Gallen 30 78 22 78
2 FC Lugano FC Lugano 30 72 30 70
3 FC Wil FC Wil 30 41 25 51
4 Yverdon Yverdon 30 52 41 51
5 Biel-Bienne Biel-Bienne 30 58 53 47
6 Wohlen Wohlen 30 43 47 45
7 Lausanne Sports Lausanne 30 41 43 41
8 Concordia Basel Concordia 30 48 51 40
9 Thun Thun 30 54 65 38
10 Winterthur Winterthur 30 45 46 36
11 Schaffhausen Schaffhausen 30 40 45 34
12 La Chaux-de-Fonds Chaux-de-Fon 30 39 46 33
13 Servette Servette 30 31 46 31
14 Stade Nyonnais Stade 30 26 56 28
15 Locarno Locarno 30 46 56 26
16 FC Gossau FC Gossau 30 27 69 19
TEMPORADA 2007/2008
SEGUNDA SUIZA
Equipo PJ GF GC Puntos
1 FC Vaduz FC Vaduz 34 75 40 70
2 AC Bellinzona Bellinzona 34 74 39 69
3 FC Wil FC Wil 34 63 35 68
4 Wohlen Wohlen 34 65 46 56
5 Winterthur Winterthur 34 59 56 51
6 Schaffhausen Schaffhausen 34 53 40 49
7 Concordia Basel Concordia 34 55 54 49
8 Servette Servette 34 55 46 46
9 FC Lugano FC Lugano 34 61 63 46
10 Yverdon Yverdon 34 39 35 43
11 FC Gossau FC Gossau 34 50 54 43
12 La Chaux-de-Fonds Chaux-de-Fon 34 53 63 43
13 Lausanne Sports Lausanne 34 46 47 42
14 Locarno Locarno 34 37 61 41
15 Kriens Kriens 34 43 54 38
16 Delemont Delemont 34 42 58 37
17 Chiasso Chiasso 34 43 68 33
18 SC Cham SC Cham 34 31 85 16
TEMPORADA 2006/2007
SEGUNDA SUIZA
Equipo PJ GF GC Puntos
1 Neuchâtel Xamax Neuchâtel 34 73 28 76
2 AC Bellinzona Bellinzona 34 58 26 70
3 Kriens Kriens 34 65 36 67
4 Chiasso Chiasso 34 55 39 58
5 Concordia Basel Concordia 34 59 49 57
6 Winterthur Winterthur 34 60 47 55
7 Servette Servette 34 63 51 53
8 FC Wil FC Wil 34 56 50 46
9 FC Vaduz FC Vaduz 34 57 52 46
10 La Chaux-de-Fonds Chaux-de-Fon 34 51 47 46
11 Yverdon Yverdon 34 45 60 42
12 FC Lugano FC Lugano 34 42 46 41
13 Lausanne Sports Lausanne 34 44 51 39
14 Locarno Locarno 34 42 60 39
15 Delemont Delemont 34 39 63 33
16 Wohlen Wohlen 34 39 64 31
17 FC Baulmes FC Baulmes 34 30 63 30
18 YF Juventus YF Juventus 34 29 75 19
TEMPORADA 2005/2006
SEGUNDA SUIZA
Equipo PJ GF GC Puntos
1 Luzern Luzern 34 69 33 79
2 Sion Sion 34 61 24 72
3 Lausanne Sports Lausanne 34 64 42 68
4 Chiasso Chiasso 34 51 31 59
5 La Chaux-de-Fonds Chaux-de-Fon 34 60 44 58
6 Wohlen Wohlen 34 50 40 52
7 FC Wil FC Wil 34 61 55 51
8 FC Vaduz FC Vaduz 34 57 54 46
9 AC Bellinzona Bellinzona 34 43 45 46
10 FC Lugano FC Lugano 34 41 52 41
11 FC Baulmes FC Baulmes 34 36 45 40
12 Concordia Basel Concordia 34 44 57 39
13 Kriens Kriens 34 42 56 39
14 YF Juventus YF Juventus 34 39 53 38
15 Winterthur Winterthur 34 62 53 37
16 Locarno Locarno 34 35 60 28
17 Baden Baden 34 30 59 27
18 Meyrin Meyrin 34 26 68 14
TEMPORADA 2004/2005
SEGUNDA SUIZA
Equipo PJ GF GC Puntos
1 Yverdon Yverdon 34 59 26 70
2 FC Vaduz FC Vaduz 34 58 28 69
3 Sion Sion 34 63 33 68
4 Chiasso Chiasso 34 60 37 65
5 Luzern Luzern 34 73 53 59
6 AC Bellinzona Bellinzona 34 58 46 57
7 Concordia Basel Concordia 34 52 40 51
8 FC Lugano FC Lugano 34 49 46 50
9 Kriens Kriens 34 46 37 48
10 La Chaux-de-Fonds Chaux-de-Fon 34 57 56 43
11 Winterthur Winterthur 34 46 53 41
12 FC Baulmes FC Baulmes 34 31 54 41
13 FC Wil FC Wil 34 45 54 40
14 Meyrin Meyrin 34 39 61 35
15 Wohlen Wohlen 34 38 63 31
16 YF Juventus YF Juventus 34 43 71 29
17 Baden Baden 34 39 62 28
18 Bulle Bulle 34 43 79 24
TEMPORADA 2002/2003
LIGA SUIZA GRUPO 3
Equipo PJ GF GC Puntos
1 Aarau Aarau 12 30 13 28
2 St. Gallen St. Gallen 12 25 9 24
3 Luzern Luzern 12 24 22 16
4 FC Vaduz FC Vaduz 12 17 23 13
5 Sion Sion 12 14 18 12
6 Delemont Delemont 12 13 24 12
7 Kriens Kriens 12 14 28 11
TEMPORADA 2001/2002
LIGA SUIZA GRUPO 2
Equipo PJ GF GC Puntos
1 Basel Basel 14 36 16 55
2 Grasshopper Grasshopper 14 28 17 45
3 FC Lugano FC Lugano 14 23 19 42
4 Servette Servette 14 25 23 38
5 Zurich Zurich 14 14 17 35
6 St. Gallen St. Gallen 14 18 20 34
7 Young Boys Young Boys 14 18 25 31
8 Sion Sion 14 10 35 21
TEMPORADA 2000/2001
LIGA SUIZA GRUPO 2
Equipo PJ GF GC Puntos
1 Grasshopper Grasshopper 14 29 14 46
2 FC Lugano FC Lugano 14 24 19 41
3 St. Gallen St. Gallen 14 23 28 40
4 Basel Basel 14 18 16 37
5 Servette Servette 14 26 19 37
6 Lausanne Sports Lausanne 14 15 27 33
7 Sion Sion 14 16 22 32
8 Zurich Zurich 14 12 18 28
TEMPORADA 1999/2000
LIGA SUIZA GRUPO 1
Equipo PJ GF GC Puntos
1 St. Gallen St. Gallen 22 42 25 45
2 Basel Basel 22 31 21 37
3 Lausanne Sports Lausanne 22 35 25 36
4 Grasshopper Grasshopper 22 40 25 34
5 Yverdon Yverdon 22 28 25 30
6 Luzern Luzern 22 28 29 28
7 Servette Servette 22 32 36 28
8 Zurich Zurich 22 22 27 27
9 Neuchâtel Xamax Neuchâtel 22 32 34 26
10 Aarau Aarau 22 30 42 26
11 FC Lugano FC Lugano 22 27 34 21
12 Delemont Delemont 22 24 48 17
TEMPORADA 1998/1999
LIGA SUIZA GRUPO 1
Equipo PJ GF GC Puntos
1 Servette Servette 22 38 24 44
2 Grasshopper Grasshopper 22 37 25 38
3 Zurich Zurich 22 33 21 38
4 Lausanne Sports Lausanne 22 36 33 38
5 Neuchâtel Xamax Neuchâtel 22 30 23 32
6 Basel Basel 22 21 34 28
7 St. Gallen St. Gallen 22 31 31 27
8 Luzern Luzern 22 24 26 25
9 FC Lugano FC Lugano 22 36 41 23
10 Sion Sion 22 22 36 23
11 Young Boys Young Boys 22 33 34 19
12 Aarau Aarau 22 28 41 16
TEMPORADA 1997/1998
LIGA SUIZA GRUPO 3
Equipo PJ GF GC Puntos
1 Neuchâtel Xamax Neuchâtel 14 35 22 26
2 FC Lugano FC Lugano 14 15 12 23
3 Basel Basel 14 27 22 22
4 Young Boys Young Boys 14 20 23 22
5 Solothurn Solothurn 14 17 15 21
6 Kriens Kriens 14 19 25 16
7 Baden Baden 14 15 23 12
8 Etoile Carouge Etoile 14 13 19 11

  USO DE MEMORIA  
6,636,440 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0012
Controller Execution Time ( Home / Category )  0.7508
Total Execution Time  0.7520
  CADENA URL  
/historico/Lugano/2013
  GET DATOS  
$_GET['/historico/Lugano/2013']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (47)  
0.0146  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 = 'Lugano' AND l.year = 2013 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.0126  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=3036 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0127  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=3036 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0126  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=3036 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0255  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 = 10176
0.0133  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 = 20655
0.0128  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=3036 AND type_rel = 2
0.0130  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 2 AND rel.typeId = 3036 AND rel.ln = 'es' ORDER BY rel.cover_points DESC LIMIT 5
0.0128  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 (48623,75119,94242,158150,192936) ORDER BY n.cover_points DESC, update_date DESC
0.0138  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 = '3036' ORDER BY l.year DESC,cat.coefficient DESC
0.0131  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 = '3036' AND l.year = 2013 ORDER BY l.year DESC,cat.coefficient DESC
0.0132  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 = '3036' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0129  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 = 20655 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0133  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 = 10176 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0161  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=3036 AND l.year in (2012,2013,2014) ORDER BY l.id DESC, l.year DESC ;
0.0133  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 (20656,10177) 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.0153  SELECT count(id) as num_players from rel_players WHERE league_id = 10177 AND teamId = 3036
0.0154  SELECT count(id) as num_players from rel_players WHERE league_id = 20656 AND teamId = 3036
0.0141  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff 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 = 10176 AND t.round = 36 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0133  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 = '3036' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0126  SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '3036' and rp.type = 4
0.0127  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 = '3036' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0149  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 events2013 e ON e.player_id = p.id AND e.league_id = 10176 WHERE rp.league_id = 10176 AND rp.teamId = 3036 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.0146  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 events2013 e ON e.player_id = p.id AND e.league_id = 10176 WHERE rp.league_id = 10176 AND rp.teamId = 3036 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0140  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 events2013 e ON e.player_id = p.id AND e.league_id = 10176 WHERE rp.league_id = 10176 AND rp.teamId = 3036 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0133  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 = 3036 AND l.year <= 2013 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.0128  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 = 10176 AND t.round = 36 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0129  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 = 10177 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0130  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 = 10178 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0129  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 = 10179 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0130  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 = 10180 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0131  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 = 10181 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0130  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 `tables2007` 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 = 10182 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0129  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 `tables2006` 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 = 10183 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0131  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 `tables2005` 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 = 10185 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0133  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 = 13528 AND t.round = 22 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0130  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 = 10081 AND t.round = 14 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0131  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 = 681 AND t.round = 36 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0131  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 = 10073 AND t.round = 14 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0133  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 `tables2001` 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 = 682 AND t.round = 22 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0139  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 `tables2001` 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 = 10072 AND t.round = 14 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0139  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 `tables2000` 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 = 10078 AND t.round = 14 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0140  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 `tables2000` 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 = 683 AND t.round = 22 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0143  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 `tables1999` 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 = 10077 AND t.round = 14 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0143  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 `tables1999` 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 = 684 AND t.round = 22 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0141  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 `tables1998` 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 = 10086 AND t.round = 14 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0129  SELECT dt.nameShow, dt.basealias, t.id, dt.id as dt_id FROM `teams` as t INNER JOIN `datateams` as dt ON dt.id = t.teamId WHERE league_id = 10176 ORDER BY nameShow LIMIT 100