4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del FC Pipinsried
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
REGIONALLIGA GRUPO 1
Equipo PJ GF GC Puntos
1 Unterhaching Unterhaching 38 86 33 86
2 Würzburger Kickers Würzburger 38 103 36 80
3 Bayern München II Bayern 38 94 54 71
4 Nürnberg II Nürnberg 38 81 55 61
5 Viktoria Aschaffenburg Viktoria 38 63 47 61
6 Schweinfurt Schweinfurt 38 77 64 59
7 SV Wacker Burghausen Wacker 38 57 45 56
8 Greuther Fürth II Greuther 38 51 53 55
9 Illertissen Illertissen 38 60 65 55
10 FC Augsburg II Augsburg 38 78 69 54
11 Aubstadt Aubstadt 38 65 59 54
12 Buchbach Buchbach 38 62 68 53
13 Vilzing Vilzing 38 52 68 51
14 Türkgücü München Türkgücü 38 48 51 50
15 SpVgg Ansbach SpVgg 38 57 66 50
16 Eichstätt Eichstätt 38 64 70 43
17 Rain / Lech Rain / Lech 38 40 78 36
18 Hankofen-Hailing Hankofen-Hai 38 47 90 36
19 Heimstetten Heimstetten 38 43 94 25
20 FC Pipinsried Pipinsried 38 37 100 25
TEMPORADA 2021/2022
REGIONALLIGA GRUPO 1
Equipo PJ GF GC Puntos
1 Bayreuth SpVgg Bayreuth 38 103 39 93
2 Bayern München II Bayern 38 113 50 86
3 SV Wacker Burghausen Wacker 38 84 54 64
4 Unterhaching Unterhaching 38 73 59 64
5 Schweinfurt Schweinfurt 38 96 56 62
6 Aubstadt Aubstadt 38 74 43 61
7 Illertissen Illertissen 38 57 45 59
8 Viktoria Aschaffenburg Viktoria 38 54 53 51
9 FC Augsburg II Augsburg 38 68 70 50
10 Eichstätt Eichstätt 38 49 62 50
11 Nürnberg II Nürnberg 38 55 56 49
12 Buchbach Buchbach 38 50 46 48
13 FC Pipinsried Pipinsried 38 52 72 48
14 Heimstetten Heimstetten 38 56 68 47
15 Rain / Lech Rain / Lech 38 43 66 45
16 Eltersdorf Eltersdorf 38 55 84 41
17 Greuther Fürth II Greuther 38 50 67 40
18 Memmingen Memmingen 38 44 72 38
19 Schalding-Heining Schalding-He 38 34 85 29
20 Rosenheim Rosenheim 38 39 102 27
TEMPORADA 2019/2020
OBERLIGA GRUPO 2
Equipo PJ GF GC Puntos
1 FC Pipinsried Pipinsried 23 81 20 63
2 TSV Wasserburg Wasserburg 23 40 29 42
3 FC Deisenhofen Deisenhofen 22 51 37 41
4 Ingolstadt 04 II Ingolstadt 23 58 42 39
5 Schwabmünchen Schwabmünch 23 49 36 39
6 Kottern Kottern 22 39 31 38
7 1860 München II 1860 23 40 38 33
8 Kirchanschöring Kirchanschö 23 31 36 31
9 Ismaning Ismaning 23 41 35 30
10 Dachau Dachau 23 30 45 27
11 SV Donaustauf Donaustauf 21 30 39 26
12 Türkspor Augsburg Türkspor 22 37 40 25
13 Landsberg Landsberg 23 35 42 25
14 Hankofen-Hailing Hankofen-Hai 22 27 34 24
15 Jahn Regensburg II Jahn 23 42 55 24
16 Pullach Pullach 23 33 57 23
17 TSV Schwaben Augsburg Schwaben 23 26 48 20
18 TSV Nördlingen Nördlingen 23 25 51 14
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
OBERLIGA GRUPO 2
Equipo PJ GF GC Puntos
1 Pullach Pullach 34 73 32 73
2 Unterföhring Unterföhrin 34 62 42 69
3 FC Pipinsried Pipinsried 34 55 38 63
4 Schwabmünchen Schwabmünch 34 54 43 60
5 Dachau Dachau 34 56 49 60
6 Heimstetten Heimstetten 34 68 52 52
7 Vilzing Vilzing 34 47 48 52
8 Kirchanschöring Kirchanschö 34 40 39 48
9 Sonthofen Sonthofen 34 55 44 47
10 Rain / Lech Rain / Lech 34 64 58 46
11 Ismaning Ismaning 34 52 52 42
12 Kottern Kottern 34 64 72 39
13 Hankofen-Hailing Hankofen-Hai 34 36 57 35
14 Landsberg Landsberg 34 46 65 34
15 Wolfratshausen Wolfratshaus 34 44 66 34
16 Jahn Regensburg II Jahn 34 53 56 33
17 Bogen Bogen 34 34 62 31
18 FC Gundelfingen Gundelfingen 34 39 67 27
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
OBERLIGA GRUPO 10
Equipo PJ GF GC Puntos
1 Rain / Lech Rain / Lech 36 100 29 83
2 Pullach Pullach 36 72 33 75
3 FC Pipinsried Pipinsried 36 81 43 72
4 Bogen Bogen 36 43 35 57
5 Vilzing Vilzing 36 49 55 53
6 Wolfratshausen Wolfratshaus 36 60 57 52
7 Hankofen-Hailing Hankofen-Hai 36 49 51 52
8 Unterföhring Unterföhrin 36 68 41 51
9 Landsberg Landsberg 36 66 56 51
10 Sonthofen Sonthofen 36 47 46 48
11 Rosenheim Rosenheim 36 47 60 48
12 Eichstätt Eichstätt 36 47 50 45
13 Dachau Dachau 36 55 62 45
14 Schwabmünchen Schwabmünch 36 43 51 44
15 Bad Kötzting Kötzting 36 48 65 43
16 Landshut Landshut 36 49 69 40
17 Raisting Raisting 36 41 61 36
18 DJK Rosenheim Rosenheim 36 56 79 35
19 Unterhaching II Unterhaching 36 41 119 17
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,334,312 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0017
Controller Execution Time ( Home / Category )  0.1267
Total Execution Time  0.1285
  CADENA URL  
/historico/Fc-Pipinsried
  GET DATOS  
$_GET['/historico/Fc-Pipinsried']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (34)  
0.0031  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 = 'Fc-Pipinsried' 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.0020  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=18040 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=18040 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=18040 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0040  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.0017  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=18040 AND type_rel = 2
0.0024  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 = '18040' ORDER BY l.year DESC,cat.coefficient DESC
0.0025  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 = '18040' AND l.year = 2024 ORDER BY l.year DESC,cat.coefficient DESC
0.0025  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 = '18040' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0020  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.0027  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=18040 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0018  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,71432,68045) 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.0021  SELECT count(id) as num_players from rel_players WHERE league_id = 68045 AND teamId = 18040
0.0024  SELECT count(id) as num_players from rel_players WHERE league_id = 72394 AND teamId = 18040
0.0022  SELECT count(id) as num_players from rel_players WHERE league_id = 71432 AND teamId = 18040
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 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.0020  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 = '18040' 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 = '18040' and rp.type = 4
0.0020  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 = '18040' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0038  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 = 18040 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.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 = 72394 WHERE rp.league_id = 72394 AND rp.teamId = 18040 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 = 72394 WHERE rp.league_id = 72394 AND rp.teamId = 18040 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0024  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 = 18040 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
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 `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.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 `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 = 68045 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.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 `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 = 63156 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.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 `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 = 50138 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.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 `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 = 43941 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0059  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.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 `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 = 33324 AND t.round = 34 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 `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.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 = 9463 AND t.round = 38 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 `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.0019  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