4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del Hertha Wiesbach
TEMPORADA 2023/2024
LANDESLIGA GRUPO 6
Equipo PJ GF GC Puntos
1 Eppelborn Eppelborn 30 82 29 69
2 Hertha Wiesbach Hertha 30 91 26 67
3 FSV Jägersburg Jägersburg 30 70 36 63
4 Borussia Neunkirchen Borussia 30 56 50 52
5 Rot-Weiß Hasborn Rot-Weiß 30 66 49 51
6 TuS Herrensohr Herrensohr 30 60 54 46
7 FC 08 Homburg II Homburg 30 59 51 44
8 DJK Ballweiler-Wecklingen Ballweiler-W 30 55 73 42
9 Köllerbach Köllerbach 30 70 64 39
10 FV Schwalbach Schwalbach 30 48 59 38
11 Saar Saarbrücken Saar 30 54 58 37
12 SV Preußen Merchweiler Preußen 30 46 54 35
13 SC Reisbach SC Reisbach 30 48 86 34
14 SV 07 Elversberg II Elversberg 30 50 63 32
15 SV Bliesmengen-Bolchen Bliesmengen- 30 48 72 29
16 Mettlach Mettlach 30 41 61 27
17 Primstal Primstal 30 42 67 26
18 SG Marpingen-Urexweiler Marpingen-Ur 30 46 80 25
TEMPORADA 2022/2023
OBERLIGA GRUPO 16
Equipo PJ GF GC Puntos
1 Arminia Ludwigshafen Arminia 32 63 62 53
2 Dudenhofen Dudenhofen 32 50 44 45
3 Pfeddersheim Pfeddersheim 32 60 50 45
4 Alemannia Waldalgesheim Alemannia 32 48 59 44
5 Morlautern Morlautern 32 65 60 44
6 Hertha Wiesbach Hertha 32 61 59 43
7 FSV Jägersburg Jägersburg 32 56 67 37
8 Ahrweiler Ahrweiler 32 34 77 25
9 TUS Kirchberg Kirchberg 32 44 89 25
10 Sportfreunde Eisbachtal Sportfreunde 32 50 89 22
11 Mülheim-Kärlich Mülheim-Kä 32 32 78 20
12 SV 07 Elversberg II Elversberg 32 33 90 19
TEMPORADA 2021/2022
OBERLIGA GRUPO 21
Equipo PJ GF GC Puntos
1 Eintracht Trier Eintracht 34 83 28 79
2 Wormatia Worms Wormatia 34 94 26 79
3 Arminia Ludwigshafen Arminia 34 81 59 63
4 Hertha Wiesbach Hertha 34 91 63 62
5 Dudenhofen Dudenhofen 34 80 50 57
6 Engers 07 Engers 07 34 60 49 57
7 Gonsenheim Gonsenheim 34 61 55 51
8 Diefflen Diefflen 34 66 67 50
9 Alemannia Waldalgesheim Alemannia 34 58 58 50
10 Karbach Karbach 34 60 63 46
11 Mechtersheim Mechtersheim 34 61 64 45
12 TuS Koblenz TuS Koblenz 34 49 57 40
TEMPORADA 2020/2021
OBERLIGA GRUPO 5
Equipo PJ GF GC Puntos
1 Eintracht Trier Eintracht 8 21 2 22
2 Kaiserslautern II Kaiserslaute 8 16 9 16
3 Hassia Bingen Hassia 9 19 15 16
4 Alemannia Waldalgesheim Alemannia 8 16 11 13
5 TuS Koblenz TuS Koblenz 9 7 10 13
6 Gonsenheim Gonsenheim 8 12 8 11
7 Engers 07 Engers 07 6 13 8 10
8 Mülheim-Kärlich Mülheim-Kä 6 10 13 9
9 Karbach Karbach 8 8 17 8
10 Salmrohr Salmrohr 9 8 18 6
11 Sportfreunde Eisbachtal Sportfreunde 7 5 12 5
12 Emmelshausen Emmelshausen 8 6 18 5
13 Wormatia Worms Wormatia 9 29 8 24
14 Dudenhofen Dudenhofen 9 17 11 17
15 Diefflen Diefflen 9 17 13 14
16 Arminia Ludwigshafen Arminia 9 14 13 13
17 FSV Jägersburg Jägersburg 9 17 24 13
18 Rochling Volklingen Rochling 9 13 13 11
19 Pfeddersheim Pfeddersheim 9 15 16 11
20 SV 07 Elversberg II Elversberg 9 9 12 11
21 Mechtersheim Mechtersheim 9 8 13 10
22 Hertha Wiesbach Hertha 9 24 22 8
23 FV Speyer FV Speyer 8 13 16 8
24 Eppelborn Eppelborn 8 11 26 4
TEMPORADA 2019/2020
OBERLIGA GRUPO 6
Equipo PJ GF GC Puntos
1 Schott Mainz Schott Mainz 21 49 20 42
2 Kaiserslautern II Kaiserslaute 21 47 25 40
3 SV 07 Elversberg II Elversberg 21 55 37 40
4 TuS Koblenz TuS Koblenz 21 34 24 39
5 Eintracht Trier Eintracht 20 33 20 37
6 Dudenhofen Dudenhofen 21 43 31 35
7 Wormatia Worms Wormatia 20 42 33 33
8 Gonsenheim Gonsenheim 21 44 36 31
9 Diefflen Diefflen 21 36 31 29
10 Pfeddersheim Pfeddersheim 21 45 46 28
11 Engers 07 Engers 07 21 29 30 28
12 Rochling Volklingen Rochling 21 38 45 26
13 Hertha Wiesbach Hertha 21 36 48 25
14 Arminia Ludwigshafen Arminia 21 21 36 24
15 Karbach Karbach 21 32 50 21
16 Mechtersheim Mechtersheim 21 20 34 19
17 Hassia Bingen Hassia 21 22 46 19
18 Sportfreunde Eisbachtal Sportfreunde 21 25 59 14
TEMPORADA 2018/2019
OBERLIGA GRUPO 7
Equipo PJ GF GC Puntos
1 RW Koblenz RW Koblenz 34 68 30 71
2 Rochling Volklingen Rochling 34 67 38 60
3 Pfeddersheim Pfeddersheim 34 73 57 60
4 TuS Koblenz TuS Koblenz 34 54 34 59
5 Engers 07 Engers 07 34 59 48 59
6 Eintracht Trier Eintracht 34 67 41 57
7 Schott Mainz Schott Mainz 34 76 55 57
8 Mechtersheim Mechtersheim 34 57 49 53
9 Kaiserslautern II Kaiserslaute 34 61 42 51
10 Hertha Wiesbach Hertha 34 50 43 50
11 Hassia Bingen Hassia 34 58 58 47
12 Karbach Karbach 34 48 50 45
13 Arminia Ludwigshafen Arminia 34 58 74 43
14 Diefflen Diefflen 34 60 73 42
15 FSV Jägersburg Jägersburg 34 49 65 35
16 Emmelshausen Emmelshausen 34 34 71 35
17 Idar-Oberstein Idar-Oberste 34 47 95 18
18 VfB Dillingen Dillingen 34 34 97 16
TEMPORADA 2017/2018
OBERLIGA GRUPO 11
Equipo PJ GF GC Puntos
1 FC 08 Homburg Homburg 36 112 20 96
2 FK Pirmasens Pirmasens 36 97 31 79
3 Kaiserslautern II Kaiserslaute 36 89 29 77
4 Eintracht Trier Eintracht 36 65 36 71
5 Diefflen Diefflen 36 81 61 63
6 FSV Jägersburg Jägersburg 36 68 60 55
7 RW Koblenz RW Koblenz 36 66 60 52
8 Hertha Wiesbach Hertha 36 62 72 48
9 Mechtersheim Mechtersheim 36 58 73 47
10 Karbach Karbach 36 65 75 44
11 Idar-Oberstein Idar-Oberste 36 53 57 43
12 Pfeddersheim Pfeddersheim 36 48 66 43
13 Engers 07 Engers 07 36 47 69 42
14 Dudenhofen Dudenhofen 36 41 72 40
15 Gonsenheim Gonsenheim 36 57 68 39
16 Morlautern Morlautern 36 46 79 30
17 Salmrohr Salmrohr 36 32 71 28
18 Saar Saarbrücken Saar 36 36 74 27
19 Eppelborn Eppelborn 36 51 101 24
TEMPORADA 2016/2017
OBERLIGA GRUPO 14
Equipo PJ GF GC Puntos
1 Schott Mainz Schott Mainz 34 110 41 74
2 Rochling Volklingen Rochling 34 83 41 70
3 Hertha Wiesbach Hertha 34 95 50 67
4 Mechtersheim Mechtersheim 34 78 52 62
5 RW Koblenz RW Koblenz 34 65 51 57
6 Karbach Karbach 34 82 53 55
7 Saar Saarbrücken Saar 34 67 44 52
8 FK Pirmasens II Pirmasens 34 68 52 52
9 Gonsenheim Gonsenheim 34 71 60 52
10 Diefflen Diefflen 34 87 71 51
11 Pfeddersheim Pfeddersheim 34 75 54 46
12 Morlautern Morlautern 34 57 49 46
13 Hauenstein Hauenstein 34 65 55 41
14 FSV Jägersburg Jägersburg 34 65 74 38
15 Salmrohr Salmrohr 34 57 68 37
16 Arminia Ludwigshafen Arminia 34 52 72 32
17 Borussia Neunkirchen Borussia 34 46 71 31
18 Burgbrohl Burgbrohl 34 9 255 1
TEMPORADA 2015/2016
OBERLIGA GRUPO 8
Equipo PJ GF GC Puntos
1 TuS Koblenz TuS Koblenz 33 73 23 79
2 Hauenstein Hauenstein 33 55 29 65
3 Karbach Karbach 33 53 46 57
4 Borussia Neunkirchen Borussia 33 57 44 54
5 Hertha Wiesbach Hertha 34 65 52 53
6 Pfeddersheim Pfeddersheim 33 53 40 47
7 Rochling Volklingen Rochling 33 45 41 46
8 Burgbrohl Burgbrohl 34 57 62 45
9 FSV Jägersburg Jägersburg 33 52 59 45
10 Salmrohr Salmrohr 33 52 49 44
11 Wirges Wirges 33 42 46 44
12 Gonsenheim Gonsenheim 33 52 60 44
13 Schott Mainz Schott Mainz 33 74 65 42
14 Arminia Ludwigshafen Arminia 33 49 62 41
15 FK Pirmasens II Pirmasens 33 48 47 40
16 SV 07 Elversberg II Elversberg 33 57 70 37
17 Mehring Mehring 33 42 64 31
18 SVN Zweibrücken Zweibrücken 19 7 74 3
TEMPORADA 2014/2015
OBERLIGA GRUPO 11
Equipo PJ GF GC Puntos
1 Saar Saarbrücken Saar 34 56 22 70
2 Hauenstein Hauenstein 34 60 27 68
3 Pfeddersheim Pfeddersheim 34 49 28 65
4 Gonsenheim Gonsenheim 34 63 42 59
5 Rochling Volklingen Rochling 34 62 47 59
6 Schott Mainz Schott Mainz 34 70 59 55
7 Salmrohr Salmrohr 34 58 54 55
8 Wirges Wirges 34 55 32 54
9 SV 07 Elversberg II Elversberg 34 62 52 54
10 Hertha Wiesbach Hertha 34 61 56 46
11 Arminia Ludwigshafen Arminia 34 62 64 46
12 Borussia Neunkirchen Borussia 34 51 47 44
13 Burgbrohl Burgbrohl 34 45 53 41
14 Idar-Oberstein Idar-Oberste 34 47 55 39
15 Mechtersheim Mechtersheim 34 59 62 37
16 Diefflen Diefflen 34 44 83 29
17 Saarbrücken II Saarbrücken 34 40 91 17
18 Betzdorf Betzdorf 34 21 91 16
TEMPORADA 2013/2014
OBERLIGA GRUPO 12
Equipo PJ GF GC Puntos
1 FK Pirmasens Pirmasens 34 62 29 65
2 Salmrohr Salmrohr 34 57 32 60
3 Hauenstein Hauenstein 34 55 41 55
4 Arminia Ludwigshafen Arminia 34 62 47 51
5 SV 07 Elversberg II Elversberg 34 53 51 50
6 Idar-Oberstein Idar-Oberste 34 53 41 48
7 Pfeddersheim Pfeddersheim 34 50 42 48
8 Hertha Wiesbach Hertha 34 62 62 47
9 Gonsenheim Gonsenheim 34 51 61 46
10 Burgbrohl Burgbrohl 34 54 68 43
11 Saarbrücken II Saarbrücken 34 43 53 42
12 Betzdorf Betzdorf 34 45 53 41
13 Mechtersheim Mechtersheim 34 50 49 40
14 Rochling Volklingen Rochling 34 37 56 40
15 Borussia Neunkirchen Borussia 34 36 49 39
16 Mehring Mehring 34 48 68 39
17 Alemannia Waldalgesheim Alemannia 34 50 53 37
18 Roßbach / Verscheid Roßbach 34 43 56 37

  USO DE MEMORIA  
6,199,792 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0012
Controller Execution Time ( Home / Category )  0.1031
Total Execution Time  0.1043
  CADENA URL  
/historico/Hertha-Weisbach
  GET DATOS  
$_GET['/historico/Hertha-Weisbach']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (29)  
0.0017  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=61569 AND type_rel = 2
0.0022  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 = '61569' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0019  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 = 73077 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0022  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=61569 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 (73077,71186,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.0019  SELECT count(id) as num_players from rel_players WHERE league_id = 71186 AND teamId = 61569
0.0018  SELECT count(id) as num_players from rel_players WHERE league_id = 73077 AND teamId = 61569
0.0019  SELECT count(id) as num_players from rel_players WHERE league_id = 67320 AND teamId = 61569
0.0037  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 = 73077 AND t.round = 30 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 = '61569' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0017  SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '61569' 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 = '61569' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0019  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 = 73077 WHERE rp.league_id = 73077 AND rp.teamId = 61569 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.0019  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 = 73077 WHERE rp.league_id = 73077 AND rp.teamId = 61569 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0019  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 = 73077 WHERE rp.league_id = 73077 AND rp.teamId = 61569 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0023  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 = 61569 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
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 `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 = 73077 AND t.round = 30 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 `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 = 68315 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 `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 = 71186 AND t.round = 12 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 = 63289 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.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 `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 = 66977 AND t.round = 12 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 = 57793 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 `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 = 50467 AND t.round = 21 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 `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 = 44338 AND t.round = 34 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 `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 = 39086 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 = 34103 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
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 `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 = 15544 AND t.round = 34 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 `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 = 9464 AND t.round = 34 ORDER BY team.conference 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 `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 = 9574 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC