4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del Juliana 31
TEMPORADA 2023/2024
HOOFDKLASSE ZONDAG GRUPO 1
Equipo PJ GF GC Puntos
1 Achilles Veen Achilles 0 0 0 0
2 Dongen Dongen 0 0 0 0
3 EVV EVV 0 0 0 0
4 GOES GOES 0 0 0 0
5 Halsteren Halsteren 0 0 0 0
6 HVCH HVCH 0 0 0 0
7 Juliana 31 Juliana 31 0 0 0 0
8 Kruisland Kruisland 0 0 0 0
9 Nemelaer Nemelaer 0 0 0 0
10 RKSV Nuenen RKSV Nuenen 0 0 0 0
11 RKVV Best Vooruit RKVV Best V. 0 0 0 0
12 SV Orion SV Orion 0 0 0 0
13 UDI '19 UDI '19 0 0 0 0
14 Unitas 30 Unitas 30 0 0 0 0
15 Venray Venray 0 0 0 0
16 Wittenhorst Wittenhorst 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 2
Equipo PJ GF GC Puntos
1 Meerssen Meerssen 6 11 5 14
2 Baronie Baronie 5 20 0 13
3 AWC AWC 5 9 10 10
4 Halsteren Halsteren 5 10 6 9
5 SV Orion SV Orion 4 7 5 9
6 OJC Rosmalen Rosmalen 5 9 8 8
7 EHC Hoensbroek Hoensbroek 6 8 15 8
8 IFC IFC 5 9 6 7
9 Moerse Boys Moerse Boys 6 9 12 7
10 UDI '19 UDI '19 5 7 10 6
11 TOGB TOGB 5 7 11 5
12 VOC VOC 6 7 12 4
13 Juliana 31 Juliana 31 2 4 3 3
14 RKSV Minor RKSV Minor 6 9 16 2
15 RKSV Nuenen RKSV Nuenen 5 6 13 1
16 Leonidas Leonidas 0 0 0 0
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 3
Equipo PJ GF GC Puntos
1 Juliana 31 Juliana 31 26 64 30 57
2 TOP Oss Amateurs Amateurs 26 59 33 53
3 Nemelaer Nemelaer 26 61 43 45
4 Leones Leones 26 49 39 41
5 Alverna Alverna 26 51 44 38
6 Woezik Woezik 26 46 45 38
7 RKSV Rhode RKSV Rhode 26 38 43 37
8 t Zand t Zand 26 41 50 33
9 RKVV Best Vooruit RKVV Best V. 26 49 52 32
10 HVCH HVCH 26 36 43 31
11 Brabantia Brabantia 26 36 47 30
12 Oirschot Vooruit Oirschot 26 37 49 25
13 Tilburg Tilburg 26 39 59 23
14 Prinses Irene Prinses 26 24 53 18
TEMPORADA 2017/2018
HOOFDKLASSE ZONDAG GRUPO 2
Equipo PJ GF GC Puntos
1 OSS '20 OSS '20 30 72 30 64
2 GOES GOES 30 66 41 58
3 Halsteren Halsteren 30 48 31 55
4 Den Bosch II Bosch 30 63 44 49
5 UDI '19 UDI '19 30 60 50 47
6 Gemert Gemert 30 63 49 45
7 Meerssen Meerssen 30 56 46 45
8 IFC IFC 30 45 53 42
9 RKSV Nuenen RKSV Nuenen 30 49 62 41
10 Vlissingen Vlissingen 30 44 39 39
11 Groene Ster Groene Ster 30 45 51 39
12 Baronie Baronie 30 42 41 36
13 Juliana 31 Juliana 31 30 39 61 33
14 BVC '12 Beek Beek 30 43 62 30
15 EHC Hoensbroek Hoensbroek 30 41 72 29
16 Woezik Woezik 30 37 81 23
TEMPORADA 2016/2017
DERDE DIVISIE GRUPO 2
Equipo PJ GF GC Puntos
1 De Dijk De Dijk 34 91 42 83
2 Westlandia Westlandia 34 101 47 75
3 Dongen Dongen 34 65 46 66
4 USV Hercules Hercules 34 64 48 61
5 Quick '20 Quick '20 34 67 57 55
6 Be Quick 1887 Quick 1887 34 74 61 54
7 EVV EVV 34 57 49 48
8 HSC 21 HSC 21 34 73 69 48
9 HBS HBS 34 55 62 47
10 OFC Oostzaan Oostzaan 34 53 62 44
11 JVC Cuijk JVC Cuijk 34 48 58 44
12 OJC Rosmalen Rosmalen 34 47 69 41
13 Magreb 90 Magreb 90 34 53 78 39
14 De Graafschap Sub 21 Graafschap 34 66 79 36
15 Juliana 31 Juliana 31 34 56 68 35
16 UDI '19 UDI '19 34 45 80 31
17 Den Bosch II Bosch 34 45 61 30
18 Achilles '29 Sub 21 Achilles 34 58 82 28
TEMPORADA 2015/2016
HOOFDKLASSE ZONDAG GRUPO 3
Equipo PJ GF GC Puntos
1 Juliana 31 Juliana 31 26 67 30 65
2 Be Quick 1887 Quick 1887 26 69 26 55
3 Quick '20 Quick '20 26 68 29 54
4 Silvolde Silvolde 26 43 30 48
5 De Bataven De Bataven 26 55 44 46
6 Dieze West Dieze West 26 41 51 36
7 MSC MSC 26 50 52 34
8 Hollandia Hollandia 26 38 32 33
9 Alverna Alverna 26 35 31 33
10 RKHVV RKHVV 26 45 53 33
11 ROHDA Raalte ROHDA Raalte 26 44 54 32
12 Achilles 1894 Achilles 26 39 73 21
13 Rigtersbleek Rigtersbleek 26 26 74 13
14 Alcides Alcides 26 27 68 10
TEMPORADA 2014/2015
HOOFDKLASSE ZONDAG GRUPO 3
Equipo PJ GF GC Puntos
1 SWZ SWZ 26 82 29 57
2 MSC MSC 26 54 26 49
3 ROHDA Raalte ROHDA Raalte 26 58 40 47
4 Quick '20 Quick '20 26 62 37 45
5 RKHVV RKHVV 26 38 40 42
6 Juliana 31 Juliana 31 26 35 29 41
7 Be Quick 1887 Quick 1887 26 43 46 37
8 Alcides Alcides 26 41 41 33
9 De Bataven De Bataven 26 50 62 33
10 Achilles 1894 Achilles 26 41 50 31
11 SC NEC SC NEC 26 37 46 28
12 AFC Arhem AFC Arhem 26 44 65 25
13 Germania Germania 26 34 59 24
14 FVC FVC 26 26 75 13
TEMPORADA 2013/2014
DERDE DIVISIE GRUPO 2
Equipo PJ GF GC Puntos
1 Amsterdamsche FC Amsterdamsch 30 73 41 62
2 UNA UNA 30 74 39 57
3 VVSB VVSB 30 54 31 57
4 JVC Cuijk JVC Cuijk 30 68 42 54
5 EVV EVV 30 49 32 52
6 HBS HBS 30 64 43 51
7 RKSV Leonidas RKSV 30 47 53 44
8 ADO 20 ADO 20 30 49 52 38
9 HSC 21 HSC 21 30 61 66 38
10 Lienden Lienden 30 41 56 38
11 De Treffers De Treffers 30 46 47 37
12 WKE Emmen WKE Emmen 30 56 51 36
13 Haaglandia Haaglandia 30 56 66 33
14 Be Quick 1887 Quick 1887 30 45 64 27
15 Juliana 31 Juliana 31 30 31 83 20
16 Chabab Chabab 30 38 86 19
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
HOOFDKLASSE ZONDAG GRUPO 2
Equipo PJ GF GC Puntos
1 UNA UNA 26 55 24 54
2 EHC Hoensbroek Hoensbroek 26 53 49 42
3 Dongen Dongen 26 53 40 41
4 UDI '19 UDI '19 26 51 42 37
5 De Valk De Valk 26 43 47 37
6 Venray Venray 26 53 40 36
7 OJC Rosmalen Rosmalen 26 46 59 36
8 DESK DESK 26 37 52 36
9 Meerssen Meerssen 26 43 44 35
10 Blauw Geel '38 Blauw Geel 26 42 43 35
11 Juliana 31 Juliana 31 26 47 44 34
12 Deurne Deurne 26 37 45 33
13 Papendrecht Papendrecht 26 25 33 32
14 Schijndel Schijndel 26 32 55 17
TEMPORADA 2009/2010
HOOFDKLASSE ZONDAG GRUPO 3
Equipo PJ GF GC Puntos
1 De Treffers De Treffers 26 55 15 55
2 Lienden Lienden 26 48 24 52
3 Quick '20 Quick '20 26 55 26 48
4 Achilles 29 Achilles 29 26 53 34 48
5 WKE Emmen WKE Emmen 26 43 33 42
6 Be Quick 1887 Quick 1887 26 52 34 41
7 Juliana 31 Juliana 31 26 50 40 39
8 ROHDA Raalte ROHDA Raalte 26 35 40 36
9 HSC 21 HSC 21 26 40 30 35
10 Alcides Alcides 26 33 45 32
11 SWZ SWZ 26 32 48 28
12 Babberich Babberich 26 33 53 20
13 Nieuw Buinen Nieuw Buinen 26 33 66 18
14 Joure Joure 26 14 88 6
TEMPORADA 2008/2009
EERSTE KLASSE ZONDAG GRUPO 5
Equipo PJ GF GC Puntos
1 Juliana 31 Juliana 31 22 60 22 54
2 ROHDA Raalte ROHDA Raalte 22 51 13 46
3 SC NEC SC NEC 23 39 28 40
4 SC Enschede SC Enschede 22 38 26 35
5 Rigtersbleek Rigtersbleek 21 41 31 29
6 Rheden Rheden 22 23 25 28
7 Jonge Kracht Jonge Kracht 23 29 34 28
8 RKHVV RKHVV 21 25 31 28
9 Koninklijke UD Koninklijke 22 37 39 27
10 AWC AWC 22 37 49 27
11 Avanti Wilskracht Avanti 22 21 53 12
12 ATC 65 ATC 65 22 23 73 12

  USO DE MEMORIA  
6,522,288 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0012
Controller Execution Time ( Home / Category )  0.5814
Total Execution Time  0.5826
  CADENA URL  
/historico/Juliana-31
  GET DATOS  
$_GET['/historico/Juliana-31']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (35)  
0.0259  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 = 72973
0.0125  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=7230 AND type_rel = 2
0.0125  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=227 AND type_rel = 3
0.0126  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.0126  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.0129  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 = '7230' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0126  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 = 72973 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0129  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=7230 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0125  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 (72973,71882) 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.0125  SELECT count(id) as num_players from rel_players WHERE league_id = 72973 AND teamId = 7230
0.0130  SELECT count(id) as num_players from rel_players WHERE league_id = 71882 AND teamId = 7230
0.0132  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 = 72973 AND t.round = 27 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0130  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 = '7230' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0126  SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '7230' and rp.type = 4
0.0131  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 = '7230' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0136  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 = 72973 WHERE rp.league_id = 72973 AND rp.teamId = 7230 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.0136  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 = 72973 WHERE rp.league_id = 72973 AND rp.teamId = 7230 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0140  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 = 72973 WHERE rp.league_id = 72973 AND rp.teamId = 7230 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0131  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 = 7230 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.0131  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 = 72973 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.0133  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.0134  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.0137  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 = 58337 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.0146  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.0146  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 = 45037 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0145  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 = 39751 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0147  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 = 33935 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0143  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 = 15941 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0143  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 = 9391 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0140  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 = 2462 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0131  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.0131  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.0128  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 = 20401 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0128  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 `tables2010` 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 = 20405 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0130  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 `tables2009` 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 = 20476 AND t.round = 22 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC