4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del VfR Garching
TEMPORADA 2023/2024
OBERLIGA GRUPO 2
Equipo PJ GF GC Puntos
1 TSV Schwaben Augsburg Schwaben 31 71 32 61
2 Landsberg Landsberg 31 78 47 60
3 SV Erlbach SV Erlbach 31 44 25 60
4 Heimstetten Heimstetten 31 54 34 59
5 FC Deisenhofen Deisenhofen 31 60 31 56
6 TSV Nördlingen Nördlingen 31 59 42 55
7 1860 München II 1860 31 56 45 49
8 Kottern Kottern 31 57 48 46
9 Kirchanschöring Kirchanschö 31 36 43 43
10 FC Pipinsried Pipinsried 31 39 36 41
11 Sonthofen Sonthofen 31 48 47 41
12 Rain / Lech Rain / Lech 31 39 49 41
13 Dachau Dachau 31 50 63 37
14 Ismaning Ismaning 31 39 62 36
15 FC Gundelfingen Gundelfingen 31 35 51 32
16 Türkspor Augsburg Türkspor 31 27 42 29
17 VfR Garching Garching 31 30 74 21
18 Kirchheimer SC Kirchheimer 31 37 88 13
TEMPORADA 2022/2023
OBERLIGA GRUPO 2
Equipo PJ GF GC Puntos
1 Schalding-Heining Schalding-He 34 73 36 73
2 Memmingen Memmingen 34 51 36 63
3 Landsberg Landsberg 34 70 45 60
4 Ingolstadt 04 II Ingolstadt 34 64 39 60
5 Kottern Kottern 34 57 44 60
6 Kirchanschöring Kirchanschö 34 56 45 58
7 TSV Schwaben Augsburg Schwaben 34 63 52 54
8 1860 München II 1860 34 56 40 53
9 FC Gundelfingen Gundelfingen 34 50 47 50
10 Ismaning Ismaning 34 47 52 50
11 TSV Nördlingen Nördlingen 34 66 64 46
12 FC Deisenhofen Deisenhofen 34 56 47 44
13 SV Erlbach SV Erlbach 34 42 36 42
14 Dachau Dachau 34 45 61 40
15 VfR Garching Garching 34 35 56 34
16 Türkspor Augsburg Türkspor 34 38 79 23
17 Rosenheim Rosenheim 34 37 83 21
18 VfB Hallbergmoos Hallbergmoos 34 35 79 15
TEMPORADA 2021/2022
OBERLIGA GRUPO 2
Equipo PJ GF GC Puntos
1 Hankofen-Hailing Hankofen-Hai 36 63 36 72
2 SV Donaustauf Donaustauf 36 80 56 66
3 Ingolstadt 04 II Ingolstadt 36 70 40 65
4 Jahn Regensburg II Jahn 36 66 44 64
5 Kirchanschöring Kirchanschö 36 51 42 62
6 1860 München II 1860 36 55 42 51
7 TSV Schwaben Augsburg Schwaben 36 47 42 51
8 Ismaning Ismaning 36 45 41 51
9 Landsberg Landsberg 36 55 41 50
10 FC Deisenhofen Deisenhofen 36 63 50 49
11 VfR Garching Garching 36 46 55 45
12 FC Gundelfingen Gundelfingen 36 41 47 44
13 Kottern Kottern 36 47 52 44
14 Türkspor Augsburg Türkspor 36 47 55 42
15 VfB Hallbergmoos Hallbergmoos 36 43 66 39
16 Pullach Pullach 36 49 65 38
17 Dachau Dachau 36 42 66 38
18 TSV Wasserburg Wasserburg 36 39 58 35
19 Schwabmünchen Schwabmünch 36 27 78 18
TEMPORADA 2019/2020
REGIONALLIGA GRUPO 1
Equipo PJ GF GC Puntos
1 Türkgücü München Türkgücü 23 51 20 54
2 Schweinfurt Schweinfurt 23 49 28 45
3 Nürnberg II Nürnberg 23 51 27 43
4 Bayreuth SpVgg Bayreuth 23 48 27 41
5 Viktoria Aschaffenburg Viktoria 23 45 29 38
6 Eichstätt Eichstätt 23 41 23 37
7 Greuther Fürth II Greuther 23 29 25 35
8 Buchbach Buchbach 23 29 31 34
9 Aubstadt Aubstadt 22 37 34 33
10 FC Augsburg II Augsburg 23 38 34 29
11 SV Wacker Burghausen Wacker 23 28 33 26
12 Illertissen Illertissen 23 33 48 25
13 Rain / Lech Rain / Lech 22 24 40 24
14 Heimstetten Heimstetten 23 37 52 23
15 Schalding-Heining Schalding-He 22 26 47 23
16 Rosenheim Rosenheim 23 29 56 21
17 Memmingen Memmingen 22 22 36 19
18 VfR Garching Garching 21 23 50 16
TEMPORADA 2018/2019
REGIONALLIGA GRUPO 1
Equipo PJ GF GC Puntos
1 Bayern München II Bayern 34 72 30 73
2 Eichstätt Eichstätt 34 69 44 66
3 SV Wacker Burghausen Wacker 34 50 41 56
4 Schweinfurt Schweinfurt 34 55 43 55
5 Nürnberg II Nürnberg 34 50 38 55
6 Memmingen Memmingen 34 55 57 48
7 Illertissen Illertissen 34 58 63 47
8 Buchbach Buchbach 34 52 48 46
9 Ingolstadt 04 II Ingolstadt 34 53 48 45
10 Bayreuth SpVgg Bayreuth 34 51 47 45
11 Viktoria Aschaffenburg Viktoria 34 47 54 41
12 VfR Garching Garching 34 46 53 41
13 Schalding-Heining Schalding-He 34 41 53 41
14 FC Augsburg II Augsburg 34 43 50 39
15 Greuther Fürth II Greuther 34 45 49 38
16 Rosenheim Rosenheim 34 37 58 37
17 Heimstetten Heimstetten 34 48 73 35
18 FC Pipinsried Pipinsried 34 46 69 33
TEMPORADA 2017/2018
REGIONALLIGA GRUPO 1
Equipo PJ GF GC Puntos
1 1860 München 1860 36 87 27 83
2 Bayern München II Bayern 36 84 41 74
3 Schweinfurt Schweinfurt 36 79 52 68
4 VfR Garching Garching 36 67 67 56
5 Nürnberg II Nürnberg 36 70 61 55
6 Ingolstadt 04 II Ingolstadt 36 68 57 53
7 Eichstätt Eichstätt 36 55 56 52
8 FC Augsburg II Augsburg 36 55 44 50
9 SV Wacker Burghausen Wacker 36 53 49 50
10 Illertissen Illertissen 36 50 50 49
11 Schalding-Heining Schalding-He 36 59 72 49
12 Buchbach Buchbach 36 50 56 46
13 Greuther Fürth II Greuther 36 45 51 46
14 FC Pipinsried Pipinsried 36 43 63 44
15 Rosenheim Rosenheim 36 43 55 41
16 Memmingen Memmingen 36 47 58 39
17 Bayreuth SpVgg Bayreuth 36 53 79 38
18 Seligenporten Seligenporte 36 39 58 36
19 Unterföhring Unterföhrin 36 36 87 20
TEMPORADA 2016/2017
REGIONALLIGA GRUPO 1
Equipo PJ GF GC Puntos
1 Unterhaching Unterhaching 34 95 23 83
2 1860 München II 1860 34 45 35 63
3 Bayern München II Bayern 34 62 40 58
4 FC Augsburg II Augsburg 34 71 36 57
5 Memmingen Memmingen 34 62 48 52
6 Illertissen Illertissen 34 46 46 51
7 Nürnberg II Nürnberg 34 72 67 49
8 Ingolstadt 04 II Ingolstadt 34 59 51 48
9 Schweinfurt Schweinfurt 34 57 61 48
10 Rosenheim Rosenheim 34 47 51 48
11 SV Wacker Burghausen Wacker 34 46 54 47
12 VfR Garching Garching 34 56 64 46
13 Bayreuth SpVgg Bayreuth 34 49 59 42
14 Buchbach Buchbach 34 43 62 41
15 Schalding-Heining Schalding-He 34 57 64 40
16 Greuther Fürth II Greuther 34 39 58 31
17 Seligenporten Seligenporte 34 41 76 29
18 Bayern Hof Bayern Hof 34 35 87 12
TEMPORADA 2015/2016
OBERLIGA GRUPO 2
Equipo PJ GF GC Puntos
1 VfR Garching Garching 34 67 29 68
2 Pullach Pullach 34 63 37 65
3 Rosenheim Rosenheim 34 66 39 64
4 Sonthofen Sonthofen 34 62 33 60
5 Unterföhring Unterföhrin 34 55 43 59
6 Heimstetten Heimstetten 34 63 47 58
7 Kirchanschöring Kirchanschö 34 48 45 51
8 Dachau Dachau 34 55 48 45
9 Hankofen-Hailing Hankofen-Hai 34 48 55 44
10 FC Pipinsried Pipinsried 34 50 56 43
11 Kottern Kottern 34 59 58 42
12 Vilzing Vilzing 34 40 47 42
13 Wolfratshausen Wolfratshaus 34 47 64 42
14 Schwabmünchen Schwabmünch 34 43 64 42
15 Landsberg Landsberg 34 51 54 41
16 Bogen Bogen 34 55 66 36
17 SV Erlbach SV Erlbach 34 36 53 33
18 Ruhmannsfelden Ruhmannsfeld 34 22 92 8
TEMPORADA 2014/2015
REGIONALLIGA GRUPO 4
Equipo PJ GF GC Puntos
1 Würzburger Kickers Würzburger 34 67 15 80
2 Bayern München II Bayern 34 60 28 72
3 1860 München II 1860 34 60 34 63
4 Buchbach Buchbach 34 45 41 52
5 Ingolstadt 04 II Ingolstadt 34 47 39 50
6 Bayreuth SpVgg Bayreuth 34 48 47 50
7 Memmingen Memmingen 34 45 51 47
8 Nürnberg II Nürnberg 34 39 39 46
9 Illertissen Illertissen 34 56 55 45
10 FC Augsburg II Augsburg 34 41 47 45
11 SV Wacker Burghausen Wacker 34 36 43 42
12 Schweinfurt Schweinfurt 34 46 53 40
13 Schalding-Heining Schalding-He 34 43 52 40
14 Greuther Fürth II Greuther 34 47 50 38
15 Heimstetten Heimstetten 34 40 58 34
16 VfR Garching Garching 34 42 64 33
17 Seligenporten Seligenporte 34 34 61 28
18 Eintracht Bamberg Eintracht 34 38 57 26
TEMPORADA 2013/2014
OBERLIGA GRUPO 10
Equipo PJ GF GC Puntos
1 Aichach Aichach 34 73 51 71
2 VfR Garching Garching 34 67 31 66
3 FC Pipinsried Pipinsried 34 67 34 64
4 Eichstätt Eichstätt 34 50 34 62
5 Pullach Pullach 34 60 35 59
6 Bogen Bogen 34 62 63 48
7 Hankofen-Hailing Hankofen-Hai 34 46 58 48
8 Schwabmünchen Schwabmünch 34 49 50 45
9 Unterhaching II Unterhaching 34 56 68 45
10 Unterföhring Unterföhrin 34 53 43 43
11 Raisting Raisting 34 42 52 42
12 Sonthofen Sonthofen 34 49 51 41
13 DJK Rosenheim Rosenheim 34 51 65 41
14 SV Wacker Burghausen II Wacker 34 58 60 39
15 Landshut Landshut 34 42 56 38
16 Wolfratshausen Wolfratshaus 34 51 67 36
17 Affing Affing 34 45 78 30
18 Ismaning Ismaning 34 39 64 26

  USO DE MEMORIA  
6,299,312 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0012
Controller Execution Time ( Home / Category )  0.6430
Total Execution Time  0.6442
  CADENA URL  
/historico/Vfr-Garching
  GET DATOS  
$_GET['/historico/Vfr-Garching']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (34)  
0.0155  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 = 'Vfr-Garching' 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.0145  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=18079 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0146  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=18079 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0295  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 = 72394
0.0145  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=18079 AND type_rel = 2
0.0147  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 2 AND rel.typeId = 18079 AND rel.ln = 'es' ORDER BY rel.cover_points DESC LIMIT 5
0.0149  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 (95900,1247431) ORDER BY n.cover_points DESC, update_date DESC
0.0151  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 = '18079' ORDER BY l.year DESC,cat.coefficient DESC
0.0149  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 = '18079' AND l.year = 2024 ORDER BY l.year DESC,cat.coefficient DESC
0.0150  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 = '18079' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0148  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 = 72394 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0150  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=18079 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0147  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 (72394,71851,67320) 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.0150  SELECT count(id) as num_players from rel_players WHERE league_id = 72394 AND teamId = 18079
0.0149  SELECT count(id) as num_players from rel_players WHERE league_id = 71851 AND teamId = 18079
0.0147  SELECT count(id) as num_players from rel_players WHERE league_id = 67320 AND teamId = 18079
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 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 = 72394 AND t.round = 32 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0149  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 = '18079' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0145  SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '18079' and rp.type = 4
0.0146  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 = '18079' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
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 = 72394 WHERE rp.league_id = 72394 AND rp.teamId = 18079 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.0157  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 = 72394 WHERE rp.league_id = 72394 AND rp.teamId = 18079 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0159  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 = 72394 WHERE rp.league_id = 72394 AND rp.teamId = 18079 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0150  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 = 18079 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
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 `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 = 72394 AND t.round = 32 ORDER BY team.conference ASC,t.position 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 `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 = 68055 AND t.round = 34 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 `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 = 63158 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.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 `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 = 50101 AND t.round = 23 ORDER BY team.conference ASC,t.position 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 `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 = 38887 AND t.round = 38 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 `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 = 33371 AND t.round = 34 ORDER BY team.conference 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 `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 = 15534 AND t.round = 34 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 = 3904 AND t.round = 34 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 = 9570 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0146  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 = 72394 ORDER BY nameShow LIMIT 100