4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del LONGA '30
TEMPORADA 2023/2024
HOOFDKLASSE ZONDAG GRUPO 2
Equipo PJ GF GC Puntos
1 AZSV AZSV 0 0 0 0
2 Be Quick 1887 Quick 1887 0 0 0 0
3 Berkum Berkum 0 0 0 0
4 Buitenpost Buitenpost 0 0 0 0
5 DETO Twenterand DETO 0 0 0 0
6 Excelsior .31 Excelsior 0 0 0 0
7 Heino Heino 0 0 0 0
8 LONGA '30 LONGA '30 0 0 0 0
9 MASV MASV 0 0 0 0
10 Pelikaan Pelikaan 0 0 0 0
11 Quick '20 Quick '20 0 0 0 0
12 ROHDA Raalte ROHDA Raalte 0 0 0 0
13 SDV Barneveld Barneveld 0 0 0 0
14 TVC '28 TVC '28 0 0 0 0
15 VV Scherpenzeel Scherpenzeel 0 0 0 0
16 VVOG VVOG 0 0 0 0
TEMPORADA 2022/2023
HOOFDKLASSE ZONDAG GRUPO 2
Equipo PJ GF GC Puntos
1 Meerssen Meerssen 30 61 26 69
2 Kampong Kampong 30 56 27 54
3 Juliana 31 Juliana 31 30 64 44 50
4 Hoogland Hoogland 30 55 49 48
5 LONGA '30 LONGA '30 30 49 35 47
6 Venray Venray 30 64 58 46
7 Halsteren Halsteren 30 50 40 45
8 RKSV Nuenen RKSV Nuenen 30 40 36 45
9 HVCH HVCH 30 47 50 44
10 AWC AWC 29 51 55 44
11 SV Orion SV Orion 29 49 52 43
12 Unitas 30 Unitas 30 30 50 57 39
13 EVV EVV 30 38 40 37
14 Silvolde Silvolde 30 31 50 26
15 Moerse Boys Moerse Boys 30 47 72 24
16 RKZVC RKZVC 30 24 85 10
TEMPORADA 2021/2022
HOOFDKLASSE ZONDAG GRUPO 2
Equipo PJ GF GC Puntos
1 Baronie Baronie 26 53 21 60
2 OJC Rosmalen Rosmalen 26 60 33 54
3 UDI '19 UDI '19 26 41 29 49
4 SV Orion SV Orion 26 51 35 47
5 Halsteren Halsteren 26 48 39 44
6 Juliana 31 Juliana 31 26 45 38 41
7 RKSV Nuenen RKSV Nuenen 26 36 31 37
8 AWC AWC 26 49 50 33
9 Meerssen Meerssen 26 40 45 33
10 Silvolde Silvolde 26 38 30 32
11 RKZVC RKZVC 26 25 44 27
12 Moerse Boys Moerse Boys 26 29 53 22
13 LONGA '30 LONGA '30 26 33 59 19
14 RKSV Minor RKSV Minor 26 27 68 14
15 EHC Hoensbroek Hoensbroek 0 0 0 0
TEMPORADA 2020/2021
HOOFDKLASSE ZONDAG GRUPO 1
Equipo PJ GF GC Puntos
1 RKVV Velsen RKVV Velsen 6 11 3 11
2 Hoogeveen Hoogeveen 6 12 7 10
3 SJC Noordwijk Noordwijk 6 11 7 10
4 RKZVC RKZVC 6 11 12 10
5 De Zouaven De Zouaven 6 10 11 10
6 Alphense Boys Alphense 5 10 7 8
7 HBS HBS 6 10 7 8
8 LONGA '30 LONGA '30 5 7 11 8
9 Silvolde Silvolde 5 11 9 7
10 Be Quick 1887 Quick 1887 5 8 7 7
11 Alcides Alcides 5 6 9 6
12 TAC'90 TAC'90 5 9 12 5
13 SDO Bussum SDO Bussum 6 9 13 5
14 Purmersteijn Purmersteijn 4 4 7 4
15 RKAVV RKAVV 3 4 6 3
16 VV Emmen VV Emmen 5 8 13 3
TEMPORADA 2019/2020
HOOFDKLASSE ZONDAG GRUPO 2
Equipo PJ GF GC Puntos
1 GVV Unitas GVV Unitas 20 35 12 47
2 Halsteren Halsteren 20 42 18 41
3 IFC IFC 20 46 25 35
4 Baronie Baronie 20 38 19 35
5 RKZVC RKZVC 20 40 25 34
6 Juliana 31 Juliana 31 20 48 33 31
7 OJC Rosmalen Rosmalen 20 36 33 30
8 UDI '19 UDI '19 19 28 22 29
9 AWC AWC 19 21 32 25
10 LONGA '30 LONGA '30 19 32 35 24
11 Meerssen Meerssen 19 20 29 22
12 Silvolde Silvolde 19 19 28 20
13 RKSV Minor RKSV Minor 19 21 46 19
14 Moerse Boys Moerse Boys 20 29 38 18
15 EHC Hoensbroek Hoensbroek 20 23 49 16
16 RKSV Nuenen RKSV Nuenen 20 10 44 10
TEMPORADA 2018/2019
EERSTE KLASSE ZONDAG GRUPO 5
Equipo PJ GF GC Puntos
1 LONGA '30 LONGA '30 26 54 30 59
2 Bemmel Bemmel 26 79 46 51
3 ROHDA Raalte ROHDA Raalte 26 65 30 48
4 BVC '12 Beek Beek 26 59 49 43
5 Stevo Stevo 26 51 40 42
6 SC NEC SC NEC 26 44 43 39
7 Winterswijk Winterswijk 26 50 43 35
8 Heino Heino 26 41 45 31
9 Rigtersbleek Rigtersbleek 26 43 50 31
10 TVC '28 TVC '28 26 45 61 31
11 Tubantia Tubantia 26 29 46 29
12 WAVV WAVV 26 46 67 27
13 De Zweef De Zweef 26 34 52 23
14 BWO BWO 26 28 66 22
TEMPORADA 2017/2018
EERSTE KLASSE ZONDAG GRUPO 5
Equipo PJ GF GC Puntos
1 RKZVC RKZVC 26 51 25 55
2 LONGA '30 LONGA '30 26 52 34 48
3 ROHDA Raalte ROHDA Raalte 26 53 28 45
4 SC NEC SC NEC 26 37 33 38
5 De Zweef De Zweef 26 35 38 35
6 BWO BWO 26 37 52 35
7 Heino Heino 26 36 37 33
8 Rigtersbleek Rigtersbleek 26 37 40 33
9 Tubantia Tubantia 26 32 32 32
10 Stevo Stevo 26 44 54 32
11 Winterswijk Winterswijk 26 38 45 30
12 Bemmel Bemmel 26 24 39 29
13 Schalkhaar Schalkhaar 26 35 44 26
14 Quick 1888 Quick 1888 26 40 50 26
TEMPORADA 2016/2017
EERSTE KLASSE ZONDAG GRUPO 5
Equipo PJ GF GC Puntos
1 BVC '12 Beek Beek 26 48 28 55
2 Quick 1888 Quick 1888 26 71 36 49
3 Bemmel Bemmel 26 38 27 44
4 Alcides Alcides 26 35 28 43
5 ROHDA Raalte ROHDA Raalte 26 55 29 42
6 Tubantia Tubantia 26 34 43 39
7 Rigtersbleek Rigtersbleek 26 35 34 34
8 LONGA '30 LONGA '30 26 41 41 34
9 Heino Heino 26 36 38 32
10 De Zweef De Zweef 26 23 36 32
11 Stevo Stevo 26 34 45 27
12 TVC '28 TVC '28 26 34 54 27
13 SV Orion SV Orion 26 29 52 24
14 Germania Germania 26 39 61 22
TEMPORADA 2015/2016
EERSTE KLASSE ZONDAG GRUPO 5
Equipo PJ GF GC Puntos
1 Woezik Woezik 24 65 25 61
2 SV Orion SV Orion 24 40 28 46
3 LONGA '30 LONGA '30 24 60 42 44
4 Tubantia Tubantia 24 37 26 40
5 Bemmel Bemmel 24 45 31 39
6 De Zweef De Zweef 24 29 31 32
7 AWC AWC 24 39 52 31
8 Heino Heino 24 46 44 30
9 Germania Germania 24 34 38 30
10 SC NEC SC NEC 24 31 40 28
11 TVC '28 TVC '28 24 41 48 24
12 Rood Wit Groesbeek Rood 24 32 58 20
13 WSV WSV 24 23 59 17
TEMPORADA 2014/2015
EERSTE KLASSE ZONDAG GRUPO 5
Equipo PJ GF GC Puntos
1 Alverna Alverna 26 63 20 59
2 Hoogland Hoogland 26 49 21 56
3 Silvolde Silvolde 26 47 23 45
4 Rigtersbleek Rigtersbleek 26 49 37 45
5 LONGA '30 LONGA '30 26 60 46 43
6 TVC '28 TVC '28 26 40 34 38
7 Bemmel Bemmel 26 50 56 38
8 Heino Heino 26 36 40 34
9 De Zweef De Zweef 26 42 49 34
10 Rood Wit Groesbeek Rood 26 33 53 29
11 Concordia Wehl Concordia 26 43 59 26
12 Grol Grol 26 32 44 24
13 Rheden Rheden 26 44 61 18
14 Luctor Et Emergo Luctor 26 21 66 12
TEMPORADA 2013/2014
HOOFDKLASSE ZONDAG GRUPO 3
Equipo PJ GF GC Puntos
1 USV Hercules Hercules 26 69 35 56
2 Quick '20 Quick '20 26 60 29 54
3 MSC MSC 26 64 33 51
4 SWZ SWZ 26 59 46 45
5 Alcides Alcides 26 55 43 42
6 ROHDA Raalte ROHDA Raalte 26 53 41 38
7 De Bataven De Bataven 26 47 50 35
8 SC NEC SC NEC 26 47 61 35
9 RKHVV RKHVV 26 56 58 34
10 FVC FVC 26 51 66 33
11 Alverna Alverna 26 39 42 31
12 Hoogeveen Hoogeveen 26 46 54 30
13 LONGA '30 LONGA '30 26 40 69 20
14 Joure Joure 26 31 90 10
TEMPORADA 2012/2013
HOOFDKLASSE ZONDAG GRUPO 3
Equipo PJ GF GC Puntos
1 MSC MSC 26 62 33 51
2 Be Quick 1887 Quick 1887 26 53 29 51
3 ROHDA Raalte ROHDA Raalte 26 42 27 47
4 De Bataven De Bataven 26 49 40 44
5 Alcides Alcides 26 54 36 43
6 OJC Rosmalen Rosmalen 26 49 36 43
7 Juliana 31 Juliana 31 26 41 36 41
8 Quick '20 Quick '20 26 48 35 40
9 SC NEC SC NEC 26 40 45 38
10 RKHVV RKHVV 26 49 57 33
11 LONGA '30 LONGA '30 26 34 52 24
12 Hoogeveen Hoogeveen 26 39 63 24
13 Rigtersbleek Rigtersbleek 26 42 68 23
14 Nieuw Buinen Nieuw Buinen 26 28 73 7
TEMPORADA 2011/2012
HOOFDKLASSE ZONDAG GRUPO 3
Equipo PJ GF GC Puntos
1 SWZ SWZ 22 49 24 46
2 Be Quick 1887 Quick 1887 21 42 14 44
3 Alcides Alcides 21 43 26 43
4 ROHDA Raalte ROHDA Raalte 22 34 25 36
5 UDI '19 UDI '19 22 32 36 36
6 MSC MSC 22 37 36 33
7 LONGA '30 LONGA '30 23 38 43 31
8 Rigtersbleek Rigtersbleek 23 36 47 27
9 SC NEC SC NEC 22 38 33 24
10 RKHVV RKHVV 22 43 54 23
11 Juliana 31 Juliana 31 22 33 45 23
12 Hoogeveen Hoogeveen 22 35 48 20
13 Babberich Babberich 22 18 47 10
TEMPORADA 2010/2011
EERSTE KLASSE ZONDAG GRUPO 5
Equipo PJ GF GC Puntos
1 LONGA '30 LONGA '30 26 65 30 60
2 Germania Germania 26 72 41 51
3 De Bataven De Bataven 26 50 37 45
4 Voorwaarts Twello Voorwaarts 26 50 41 41
5 SC Enschede SC Enschede 26 50 46 41
6 Jonge Kracht Jonge Kracht 26 40 38 39
7 SDOUC SDOUC 26 41 46 39
8 PH Almelo PH Almelo 26 55 51 37
9 Achilles '12 Achilles 26 38 42 33
10 AWC AWC 26 46 57 33
11 SV Epe SV Epe 26 48 50 31
12 Tubantia Tubantia 26 29 51 22
13 Albatross Albatross 26 33 58 22
14 WSV WSV 26 32 61 19

  USO DE MEMORIA  
6,292,568 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0011
Controller Execution Time ( Home / Category )  0.1188
Total Execution Time  0.1200
  CADENA URL  
/historico/Longa-30
  GET DATOS  
$_GET['/historico/Longa-30']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (39)  
0.0035  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 = 'Longa-30' 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.0019  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=7226 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0019  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=7226 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0019  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=7226 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
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 = 72974
0.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=7226 AND type_rel = 2
0.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=227 AND type_rel = 3
0.0021  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 3 AND rel.typeId = 227 AND rel.ln = 'es' AND rel.status=1 ORDER BY rel.creation_date desc,rel.cover_points DESC LIMIT 5
0.0019  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 (711277) ORDER BY n.cover_points DESC, update_date 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 = '7226' ORDER BY l.year DESC,cat.coefficient DESC
0.0021  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 = '7226' AND l.year = 2024 ORDER BY l.year DESC,cat.coefficient DESC
0.0020  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 = '7226' 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 = 72974 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0021  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=7226 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 (72974,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 = 72974 AND teamId = 7226
0.0018  SELECT count(id) as num_players from rel_players WHERE league_id = 71432 AND teamId = 7226
0.0021  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 = 72974 AND t.round = 27 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 = '7226' 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 = '7226' and rp.type = 4
0.0019  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 = '7226' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
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 = 72974 WHERE rp.league_id = 72974 AND rp.teamId = 7226 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 = 72974 WHERE rp.league_id = 72974 AND rp.teamId = 7226 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 = 72974 WHERE rp.league_id = 72974 AND rp.teamId = 7226 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0022  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 = 7226 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 = 72974 AND t.round = 27 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 `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 = 70057 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.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 = 63265 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.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 `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 = 58336 AND t.round = 6 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 `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 = 50985 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.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 = 45039 AND t.round = 26 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 `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 = 39761 AND t.round = 26 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 `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 = 33992 AND t.round = 26 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 = 16019 AND t.round = 26 ORDER BY team.conference 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 `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 = 9403 AND t.round = 26 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 `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 = 9398 AND t.round = 26 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 `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 = 2188 AND t.round = 26 ORDER BY team.conference 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 `tables2012` 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 = 1718 AND t.round = 26 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 `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 = 20464 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC