4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del Eichstätt
TEMPORADA 2023/2024
OBERLIGA GRUPO 1
Equipo PJ GF GC Puntos
1 Hankofen-Hailing Hankofen-Hai 33 71 43 64
2 Eichstätt Eichstätt 32 67 39 58
3 Eltersdorf Eltersdorf 31 53 33 58
4 TSV Abtswind Abtswind 32 52 38 53
5 Bayern Hof Bayern Hof 31 53 43 53
6 Ingolstadt 04 II Ingolstadt 31 64 48 51
7 Neudrossenfeld Neudrossenfe 31 46 47 49
8 ASV Neumarkt Neumarkt 31 61 49 48
9 ASV Cham ASV Cham 31 57 42 47
10 Jahn Regensburg II Jahn 33 60 58 46
11 DJK Gebenbach Gebenbach 32 64 53 45
12 ATSV Erlangen ATSV 31 41 45 45
13 Ammerthal Ammerthal 31 54 52 44
14 TSV Kornburg Kornburg 32 58 44 40
15 Fortuna Regensburg Fortuna 32 57 68 39
16 FC Coburg FC Coburg 31 53 78 39
17 Würzburger FV Würzburger 32 41 69 24
18 SV Donaustauf Donaustauf 31 33 72 22
19 Feucht SC Feucht SC 32 31 95 16
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
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
OBERLIGA GRUPO 1
Equipo PJ GF GC Puntos
1 Eichstätt Eichstätt 34 83 34 73
2 Viktoria Aschaffenburg Viktoria 34 83 34 69
3 Aubstadt Aubstadt 34 69 30 68
4 Grossbardorf Grossbardorf 34 59 29 64
5 ASV Neumarkt Neumarkt 34 53 30 64
6 Würzburger Kickers II Würzburger 34 49 37 54
7 Eltersdorf Eltersdorf 34 58 56 49
8 Ammerthal Ammerthal 34 54 54 48
9 1. FC Sand 1. FC Sand 34 50 48 46
10 Amberg Amberg 34 55 51 44
11 DJK Bamberg DJK Bamberg 34 43 48 43
12 Würzburger FV Würzburger 34 43 58 43
13 SpVgg Ansbach SpVgg 34 61 64 42
14 Weiden Weiden 34 36 58 41
15 Feucht SC Feucht SC 34 35 49 37
16 Erlenbach Erlenbach 34 29 79 28
17 Alemannia Haibach Alemannia 34 43 70 25
18 VfL Frohnlach Frohnlach 34 23 97 13
TEMPORADA 2015/2016
OBERLIGA GRUPO 1
Equipo PJ GF GC Puntos
1 Seligenporten Seligenporte 34 72 42 69
2 Eichstätt Eichstätt 34 70 44 68
3 Weiden Weiden 34 64 26 67
4 Grossbardorf Grossbardorf 34 57 23 67
5 Bayern Hof Bayern Hof 34 68 40 67
6 Alemannia Haibach Alemannia 34 58 49 58
7 Eltersdorf Eltersdorf 34 55 55 48
8 Aubstadt Aubstadt 34 48 49 47
9 1. FC Sand 1. FC Sand 34 50 57 46
10 Feucht SC Feucht SC 34 57 61 40
11 DJK Bamberg DJK Bamberg 34 55 75 39
12 Jahn Regensburg II Jahn 34 47 49 38
13 Würzburger FV Würzburger 34 43 55 38
14 Erlenbach Erlenbach 34 39 51 35
15 ASV Burglengenfeld Burglengenfe 34 32 51 33
16 Jahn Forchheim Jahn 34 38 74 31
17 VfL Frohnlach Frohnlach 34 41 66 30
18 Eintracht Bamberg Eintracht 34 52 79 29
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
TEMPORADA 2012/2013
OBERLIGA GRUPO 1
Equipo PJ GF GC Puntos
1 Schalding-Heining Schalding-He 36 58 26 78
2 SV Wacker Burghausen II Wacker 36 65 35 67
3 Aichach Aichach 36 71 40 60
4 Landshut Landshut 36 60 54 57
5 Jahn Regensburg II Jahn 36 56 46 54
6 Unterhaching II Unterhaching 36 55 60 54
7 Unterföhring Unterföhrin 36 57 50 53
8 Sonthofen Sonthofen 36 53 53 51
9 Eichstätt Eichstätt 36 40 40 50
10 Hankofen-Hailing Hankofen-Hai 36 46 54 49
11 Affing Affing 36 62 65 48
12 DJK Rosenheim Rosenheim 36 50 48 47
13 Wolfratshausen Wolfratshaus 36 50 50 46
14 Schwabmünchen Schwabmünch 36 37 39 46
15 TSV Aindling Aindling 36 42 63 41
16 Deggendorf Deggendorf 36 39 55 39
17 Gersthofen Gersthofen 36 43 72 38
18 Kottern Kottern 36 46 61 36
19 Fürstenfeldbruck Fürstenfeld 36 36 55 35

  USO DE MEMORIA  
6,535,464 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0012
Controller Execution Time ( Home / Category )  0.4629
Total Execution Time  0.4642
  CADENA URL  
/historico/Eichstatt
  GET DATOS  
$_GET['/historico/Eichstatt']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (28)  
0.0041  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 = 72393
0.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=61551 AND type_rel = 2
0.0020  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 2 AND rel.typeId = 61551 AND rel.ln = 'es' ORDER BY rel.cover_points DESC LIMIT 5
0.0019  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 (688234) ORDER BY n.cover_points DESC, update_date DESC
0.0023  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 = '61551' 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 = 72393 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0026  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=61551 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0022  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 (72393,71850,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.3193  SELECT count(id) as num_players from rel_players WHERE league_id = 68045 AND teamId = 61551
0.0061  SELECT count(id) as num_players from rel_players WHERE league_id = 72393 AND teamId = 61551
0.0040  SELECT count(id) as num_players from rel_players WHERE league_id = 71850 AND teamId = 61551
0.0032  SELECT count(id) as num_players from rel_players WHERE league_id = 71432 AND teamId = 61551
0.0047  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 = 72393 AND t.round = 34 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0055  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 = 72393 WHERE rp.league_id = 72393 AND rp.teamId = 61551 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.0072  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 = 72393 WHERE rp.league_id = 72393 AND rp.teamId = 61551 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0045  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 = 72393 WHERE rp.league_id = 72393 AND rp.teamId = 61551 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0043  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 = 61551 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.0044  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 = 72393 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.0041  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.0037  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.0031  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.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 `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.0027  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.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 `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 = 33323 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0033  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 = 15533 AND t.round = 34 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 `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.0028  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.0027  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 = 19806 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC