4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del Linx
TEMPORADA 2023/2024
LANDESLIGA GRUPO 25
Equipo PJ GF GC Puntos
1 FC 08 Villingen II Villingen 27 63 20 68
2 FC Auggen FC Auggen 27 55 23 59
3 1.FC Rielasingen-Arlen 1.FC 28 69 38 56
4 FC Teningen FC Teningen 28 74 44 53
5 Lahr Lahr 28 58 34 48
6 Freiburger FC Freiburger 28 49 43 38
7 SV 08 Kuppenheim Kuppenheim 28 40 45 38
8 Linx Linx 27 37 40 37
9 Hausen Hausen 27 42 36 36
10 Pfullendorf Pfullendorf 28 39 38 36
11 SV Bühlertal Bühlertal 29 35 51 34
12 SF Elzach-Yach Elzach-Yach 28 43 59 32
13 FV Lörrach-Brombach Lörrach-Bro 28 38 56 30
14 Stadelhofen Stadelhofen 28 24 48 28
15 DJK Donaueschingen Donauesching 28 31 43 25
16 SC Konstanz-Wollmatingen Konstanz-Wol 29 35 73 23
17 Singen 04 Singen 04 28 25 66 21
TEMPORADA 2021/2022
OBERLIGA GRUPO 3
Equipo PJ GF GC Puntos
1 Freiberg Freiberg 38 116 30 91
2 Stuttgarter Kickers Stuttgarter 38 91 25 91
3 TSG Backnang Backnang 38 89 59 68
4 Villingen Villingen 38 75 47 64
5 CfR Pforzheim Pforzheim 38 68 52 60
6 Göppinger SV Göppinger 38 64 58 60
7 Nottingen Nottingen 38 77 77 57
8 Ravensburg Ravensburg 38 77 70 55
9 Reutlingen Reutlingen 38 60 59 55
10 Bissingen Bissingen 38 73 63 52
11 1.FC Rielasingen-Arlen 1.FC 38 58 62 52
12 Neckarsulmer SU Neckarsulmer 38 51 61 51
13 Oberachern Oberachern 38 65 76 51
14 Freiburger FC Freiburger 38 61 61 47
15 Sportfreunde Dorfmerkingen Sportfreunde 38 53 77 46
16 Astoria Walldorf II Astoria 38 58 81 45
17 Linx Linx 38 57 81 41
18 Bruchsal Bruchsal 38 57 94 37
19 TSV Ilshofen Ilshofen 38 57 96 36
20 FV Lörrach-Brombach Lörrach-Bro 38 28 106 11
TEMPORADA 2020/2021
OBERLIGA GRUPO 3
Equipo PJ GF GC Puntos
1 Freiberg Freiberg 13 42 6 35
2 Stuttgarter Kickers Stuttgarter 13 41 12 30
3 Göppinger SV Göppinger 13 26 14 26
4 Bissingen Bissingen 13 26 21 25
5 Nottingen Nottingen 11 25 16 23
6 1.FC Rielasingen-Arlen 1.FC 12 18 12 22
7 Neckarsulmer SU Neckarsulmer 13 18 14 22
8 Ravensburg Ravensburg 12 22 14 18
9 Sportfreunde Dorfmerkingen Sportfreunde 12 15 11 17
10 Villingen Villingen 12 10 9 17
11 CfR Pforzheim Pforzheim 12 21 17 15
12 TSG Backnang Backnang 12 19 21 15
13 Reutlingen Reutlingen 12 18 29 14
14 Bruchsal Bruchsal 11 16 23 12
15 TSV Ilshofen Ilshofen 12 15 28 11
16 Linx Linx 12 17 33 11
17 Oberachern Oberachern 11 10 21 10
18 FV Lörrach-Brombach Lörrach-Bro 13 16 30 8
19 Astoria Walldorf II Astoria 13 18 34 8
20 Freiburger FC Freiburger 12 12 28 8
21 Sandhausen II Sandhausen 12 18 30 7
TEMPORADA 2019/2020
OBERLIGA GRUPO 11
Equipo PJ GF GC Puntos
1 Stuttgart II Stuttgart 21 62 24 41
2 Göppinger SV Göppinger 22 39 24 41
3 Stuttgarter Kickers Stuttgarter 21 42 23 38
4 Ravensburg Ravensburg 21 42 35 34
5 Oberachern Oberachern 21 36 30 32
6 Villingen Villingen 21 26 24 32
7 Bissingen Bissingen 20 41 38 30
8 Freiburger FC Freiburger 20 27 25 30
9 1.FC Rielasingen-Arlen 1.FC 23 36 45 28
10 Sportfreunde Dorfmerkingen Sportfreunde 20 31 34 27
11 Linx Linx 21 35 43 27
12 Nottingen Nottingen 21 34 44 27
13 Neckarsulmer SU Neckarsulmer 21 20 26 26
14 CfR Pforzheim Pforzheim 20 23 18 25
15 Reutlingen Reutlingen 20 30 32 25
16 Freiberg Freiberg 21 34 54 25
17 TSV Ilshofen Ilshofen 21 29 45 19
18 Sandhausen II Sandhausen 21 19 42 12
TEMPORADA 2018/2019
OBERLIGA GRUPO 12
Equipo PJ GF GC Puntos
1 Bahlinger SC Bahlinger 34 84 34 71
2 Stuttgarter Kickers Stuttgarter 34 62 30 66
3 Bissingen Bissingen 34 66 45 61
4 Nottingen Nottingen 34 70 48 59
5 Göppinger SV Göppinger 34 60 48 57
6 Ravensburg Ravensburg 34 56 40 55
7 Freiberg Freiberg 34 73 53 54
8 Villingen Villingen 34 59 51 53
9 Reutlingen Reutlingen 34 49 51 53
10 Neckarsulmer SU Neckarsulmer 34 45 55 47
11 CfR Pforzheim Pforzheim 34 44 44 45
12 Linx Linx 34 63 79 44
13 TSV Ilshofen Ilshofen 34 34 46 43
14 Oberachern Oberachern 34 64 71 41
15 TSG Backnang Backnang 34 44 52 37
16 Germania Friedrichstal Germania 34 39 88 23
17 Normannia Gmünd Normannia 34 28 61 19
18 Spielberg Spielberg 34 30 74 17
TEMPORADA 2010/2011
OBERLIGA GRUPO 5
Equipo PJ GF GC Puntos
1 Waldhof Mannheim Waldhof 36 71 22 83
2 Nottingen Nottingen 36 80 40 78
3 Villingen Villingen 36 58 40 65
4 SpVgg Neckarelz SpVgg 36 54 50 58
5 Normannia Gmünd Normannia 36 66 56 55
6 Stuttgarter Kickers II Stuttgarter 36 56 45 54
7 Illertissen Illertissen 36 51 39 52
8 Astoria Walldorf Astoria 36 51 40 51
9 Kirchheim/Teck Kirchheim/Te 36 57 51 50
10 TSG Balingen Balingen 36 48 50 50
11 Kehler FV Kehler FV 36 59 54 46
12 Hollenbach Hollenbach 36 51 45 45
13 Bahlinger SC Bahlinger 36 48 52 45
14 Reutlingen Reutlingen 36 55 65 45
15 Freiberg Freiberg 36 45 61 44
16 Weinheim Weinheim 36 44 65 38
17 Neckarrems Neckarrems 36 52 72 35
18 ASV Durlach ASV Durlach 36 34 87 24
19 Linx Linx 36 30 76 18
TEMPORADA 2007/2008
OBERLIGA GRUPO 7
Equipo PJ GF GC Puntos
1 Freiburg II Freiburg II 34 62 36 73
2 Ulm Ulm 34 61 25 71
3 Waldhof Mannheim Waldhof 34 54 22 71
4 Heidenheim Heidenheim 34 69 29 69
5 Hoffenheim II Hoffenheim 34 59 31 67
6 Villingen Villingen 34 71 35 63
7 Crailsheim Crailsheim 33 65 40 58
8 Astoria Walldorf Astoria 33 65 51 54
9 Normannia Gmünd Normannia 34 51 49 48
10 SG Sonnenhof Großaspach Sonnenhof 34 38 40 42
11 Nottingen Nottingen 34 51 54 41
12 Freiberg Freiberg 34 53 56 38
13 Bahlinger SC Bahlinger 34 38 65 31
14 Kirchheim/Teck Kirchheim/Te 34 39 69 28
15 Stuttgarter Kickers II Stuttgarter 34 48 81 28
16 VfR Mannheim Mannheim 34 34 66 24
17 Schwieberdingen 1906 Schwieberdin 34 36 90 24
18 Linx Linx 34 34 89 17
TEMPORADA 2005/2006
OBERLIGA GRUPO 3
Equipo PJ GF GC Puntos
1 Reutlingen Reutlingen 34 68 16 82
2 Heidenheim Heidenheim 34 67 30 78
3 Ulm Ulm 34 89 32 75
4 Freiburg II Freiburg II 34 62 33 64
5 Sandhausen Sandhausen 34 65 34 60
6 Hoffenheim II Hoffenheim 34 58 51 51
7 Freiberg Freiberg 34 52 59 51
8 Waldhof Mannheim Waldhof 34 46 49 46
9 Nottingen Nottingen 34 61 55 45
10 VfR Mannheim Mannheim 34 43 51 43
11 Crailsheim Crailsheim 34 55 53 40
12 Normannia Gmünd Normannia 34 38 57 38
13 Stuttgarter Kickers II Stuttgarter 34 36 57 38
14 SG Sonnenhof Großaspach Sonnenhof 34 38 63 33
15 FC Emmendingen Emmendingen 34 29 54 31
16 ASV Durlach ASV Durlach 34 42 71 29
17 Lauda Lauda 34 27 65 26
18 Linx Linx 34 42 88 24
TEMPORADA 2003/2004
OBERLIGA GRUPO 6
Equipo PJ GF GC Puntos
1 Nottingen Nottingen 34 66 35 67
2 Crailsheim Crailsheim 34 71 38 66
3 Karlsruher SC II Karlsruher 34 69 40 65
4 Waldhof Mannheim Waldhof 34 58 32 65
5 Freiburg II Freiburg II 34 58 35 62
6 Ulm Ulm 34 60 55 55
7 Sandhausen Sandhausen 34 49 39 51
8 Bonlanden Bonlanden 34 51 64 50
9 Reutlingen Reutlingen 34 40 42 44
10 Hoffenheim II Hoffenheim 34 45 49 44
11 SpVgg Ludwigsburg SpVgg 34 52 69 44
12 Stuttgarter Kickers II Stuttgarter 34 36 46 40
13 Lauda Lauda 34 32 38 39
14 Freiberg Freiberg 34 39 46 37
15 Bahlinger SC Bahlinger 34 41 55 37
16 Linx Linx 34 45 64 34
17 SpVgg Au SpVgg Au 34 43 77 29
18 Weinheim Weinheim 34 43 74 21
TEMPORADA 1996/1997
OBERLIGA GRUPO 7
Equipo PJ GF GC Puntos
1 Kirchheim/Teck Kirchheim/Te 30 58 16 66
2 Pforzheim Pforzheim 30 65 20 64
3 Stuttgart II Stuttgart 30 49 17 57
4 Sandhausen Sandhausen 30 58 31 54
5 Bahlinger SC Bahlinger 30 42 48 44
6 Pfullendorf Pfullendorf 30 60 58 42
7 Bonlanden Bonlanden 30 46 39 40
8 TSV Wäldenbronn Wäldenbronn 30 53 52 40
9 FV Biberach FV Biberach 30 44 48 40
10 VfR Aalen VfR Aalen 30 50 43 38
11 FC Bammental Bammental 30 45 73 38
12 SV Böblingen Böblingen 30 40 42 37
13 SGK Heidelberg Heidelberg 30 40 47 34
14 Linx Linx 30 38 57 30
15 ASV Durlach ASV Durlach 30 42 62 27
16 SG Oftersheim Oftersheim 30 27 104 11
TEMPORADA 1995/1996
OBERLIGA GRUPO 4
Equipo PJ GF GC Puntos
1 Karlsruher SC II Karlsruher 30 56 27 62
2 Stuttgart II Stuttgart 30 53 31 60
3 Pforzheim Pforzheim 30 52 31 59
4 VfR Aalen VfR Aalen 30 42 28 52
5 Pfullendorf Pfullendorf 30 33 21 50
6 Linx Linx 30 45 40 41
7 Bonlanden Bonlanden 30 45 38 39
8 TSV Wäldenbronn Wäldenbronn 30 48 46 39
9 Kirchheim/Teck Kirchheim/Te 30 39 43 39
10 FC Bammental Bammental 30 56 64 39
11 FV Biberach FV Biberach 30 42 52 35
12 ASV Durlach ASV Durlach 30 39 52 34
13 FC Wangen FC Wangen 30 43 47 32
14 VfB Gaggenau Gaggenau 30 33 53 29
15 SC Geislingen Geislingen 30 43 64 28
16 Amicitia Viernheim Amicitia 30 38 70 18
TEMPORADA 1994/1995
OBERLIGA GRUPO 4
Equipo PJ GF GC Puntos
1 CfR Pforzheim Pforzheim 64 87 71 101
2 Sandhausen Sandhausen 32 72 30 71
3 SC Geislingen Geislingen 32 51 34 58
4 Karlsruher SC II Karlsruher 32 51 38 52
5 GSV Maichingen Maichingen 32 43 37 45
6 TSV Wäldenbronn Wäldenbronn 32 48 47 45
7 Linx Linx 32 43 44 44
8 Stuttgart II Stuttgart 32 48 48 43
9 FV Biberach FV Biberach 32 38 39 43
10 VfR Aalen VfR Aalen 32 46 34 41
11 Kirchheim/Teck Kirchheim/Te 32 38 44 40
12 VfB Gaggenau Gaggenau 32 42 53 39
13 ASV Durlach ASV Durlach 32 48 55 37
14 Amicitia Viernheim Amicitia 32 39 60 34
15 Villingen Villingen 32 25 54 25
16 Donaueschingen Donauesching 32 30 61 24

  USO DE MEMORIA  
6,475,832 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0012
Controller Execution Time ( Home / Category )  0.1269
Total Execution Time  0.1281
  CADENA URL  
/historico/Sv-Linx
  GET DATOS  
$_GET['/historico/Sv-Linx']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (37)  
0.0027  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 = 'Sv-Linx' 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.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=83267 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=83267 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=83267 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0042  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 = 73069
0.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=83267 AND type_rel = 2
0.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=2090 AND type_rel = 3
0.0019  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 3 AND rel.typeId = 2090 AND rel.ln = 'es' AND rel.status=1 ORDER BY rel.creation_date desc,rel.cover_points DESC LIMIT 5
0.0021  SELECT /*53 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 (184451,1011237,984949) ORDER BY n.cover_points DESC, update_date DESC
0.0030  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 = '83267' ORDER BY l.year DESC,cat.coefficient DESC
0.0022  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 = '83267' AND l.year = 2024 ORDER BY l.year DESC,cat.coefficient DESC
0.0021  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 = '83267' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0021  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 = 73069 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=83267 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 (73069,71432) 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.0018  SELECT count(id) as num_players from rel_players WHERE league_id = 73069 AND teamId = 83267
0.0021  SELECT count(id) as num_players from rel_players WHERE league_id = 71432 AND teamId = 83267
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 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 = 73069 AND t.round = 30 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0022  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 = '83267' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0019  SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '83267' and rp.type = 4
0.0021  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 = '83267' 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 = 73069 WHERE rp.league_id = 73069 AND rp.teamId = 83267 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 = 73069 WHERE rp.league_id = 73069 AND rp.teamId = 83267 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0020  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 = 73069 WHERE rp.league_id = 73069 AND rp.teamId = 83267 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0026  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 = 83267 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 = 73069 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 `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 = 63240 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 `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 = 57318 AND t.round = 13 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 `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 = 50540 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 = 44463 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 `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 = 19835 AND t.round = 38 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 `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 = 19872 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 `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 = 19886 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 `tables2004` 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 = 28295 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0029  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 `tables1997` 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 = 28365 AND t.round = 30 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 `tables1996` 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 = 28372 AND t.round = 30 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 `tables1995` 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 = 28388 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC