4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del SteDoCo

SteDoCo

Entrenador: R. Adjei

Temporada 2023/2024
TEMPORADA 2023/2024
DERDE DIVISIE GRUPO 2
Equipo PJ GF GC Puntos
1 SteDoCo SteDoCo 30 64 28 61
2 BVV Barendrecht Barendrecht 30 66 32 61
3 SV TEC Tiel SV TEC Tiel 30 60 24 56
4 Blauw Geel '38 Blauw Geel 29 56 33 54
5 Meerssen Meerssen 30 64 47 50
6 Sportlust 46 Sportlust 30 45 33 49
7 Gemert Gemert 30 51 53 49
8 TOGB TOGB 30 45 40 46
9 Kloetinge Kloetinge 30 43 41 46
10 UNA UNA 30 47 41 44
11 HV & CV Quick Quick 30 58 57 43
12 Hoek Hoek 30 67 48 41
13 OSS '20 OSS '20 30 40 58 33
14 OJC Rosmalen Rosmalen 30 44 60 31
15 AWC AWC 29 24 56 29
16 Groene Ster Groene Ster 30 24 65 26
17 GVV Unitas GVV Unitas 30 31 55 23
18 Baronie Baronie 30 21 79 13
TEMPORADA 2022/2023
DERDE DIVISIE GRUPO 1
Equipo PJ GF GC Puntos
1 ACV Assen ACV Assen 34 71 33 75
2 GVVV GVVV 34 77 40 69
3 BVV Barendrecht Barendrecht 34 71 54 59
4 SteDoCo SteDoCo 34 59 42 58
5 Rijnvogels Rijnvogels 34 64 55 56
6 Sportlust 46 Sportlust 34 52 50 53
7 DVS'33 DVS'33 34 54 43 52
8 Sparta Nijkerk Sparta 34 45 45 50
9 Hoek Hoek 34 71 72 50
10 DOVO DOVO 34 51 56 48
11 Staphorst Staphorst 34 38 41 45
12 Urk Urk 34 62 76 42
13 Harkemase Boys Harkemase 34 52 56 38
14 RKAV Volendam RKAV 34 52 72 36
15 VVOG VVOG 34 49 71 35
16 Excelsior .31 Excelsior 34 47 58 33
17 Ter Leede Ter Leede 34 50 65 33
18 ASWH Ido-Ambacht ASWH 34 25 61 27
TEMPORADA 2021/2022
DERDE DIVISIE GRUPO 1
Equipo PJ GF GC Puntos
1 Lisse Lisse 34 70 38 70
2 Sparta Nijkerk Sparta 34 65 38 64
3 Sportlust 46 Sportlust 34 63 40 58
4 DVS'33 DVS'33 34 61 41 58
5 Hoek Hoek 34 53 49 55
6 ACV Assen ACV Assen 34 50 42 51
7 Excelsior .31 Excelsior 34 53 47 51
8 BVV Barendrecht Barendrecht 34 72 57 50
9 SteDoCo SteDoCo 34 49 48 45
10 Staphorst Staphorst 34 54 56 45
11 Ter Leede Ter Leede 34 49 67 44
12 Harkemase Boys Harkemase 34 63 62 42
13 DOVO DOVO 34 43 57 38
14 VVSB VVSB 34 50 66 38
15 ODIN '59 ODIN '59 34 52 68 37
16 VVOG VVOG 34 61 82 37
17 Ajax Amateurs Ajax 34 38 54 36
18 GOES GOES 34 44 78 28
TEMPORADA 2020/2021
DERDE DIVISIE GRUPO 1
Equipo PJ GF GC Puntos
1 SteDoCo SteDoCo 6 13 5 13
2 Lisse Lisse 5 11 7 10
3 Sparta Nijkerk Sparta 5 9 5 10
4 Excelsior .31 Excelsior 5 8 5 10
5 VVSB VVSB 5 10 7 9
6 Sportlust 46 Sportlust 5 6 5 9
7 Hoek Hoek 6 11 9 8
8 BVV Barendrecht Barendrecht 5 7 8 8
9 DOVO DOVO 5 16 8 7
10 Harkemase Boys Harkemase 3 5 2 7
11 ODIN '59 ODIN '59 4 6 6 6
12 Staphorst Staphorst 6 12 14 6
13 Ajax Amateurs Ajax 5 11 21 6
14 DVS'33 DVS'33 5 9 10 4
15 VVOG VVOG 4 1 3 4
16 Ter Leede Ter Leede 5 6 9 4
17 ACV Assen ACV Assen 4 1 8 2
18 GOES GOES 5 2 12 0
TEMPORADA 2019/2020
DERDE DIVISIE GRUPO 1
Equipo PJ GF GC Puntos
1 Sparta Nijkerk Sparta 22 58 27 52
2 ODIN '59 ODIN '59 22 63 30 47
3 Harkemase Boys Harkemase 22 43 34 42
4 DVS'33 DVS'33 23 39 30 42
5 Lisse Lisse 23 44 33 38
6 Hoek Hoek 23 54 42 34
7 BVV Barendrecht Barendrecht 23 37 38 34
8 Ajax Amateurs Ajax 22 31 38 31
9 Excelsior .31 Excelsior 23 50 40 31
10 Jong Almere City Jong Almere 23 54 48 31
11 GOES GOES 23 33 44 31
12 VVSB VVSB 22 47 48 28
13 SteDoCo SteDoCo 22 41 42 28
14 Ter Leede Ter Leede 23 36 53 27
15 DOVO DOVO 23 45 55 22
16 ONS Sneek ONS Sneek 23 32 72 12
17 VVOG VVOG 22 26 59 11
TEMPORADA 2018/2019
DERDE DIVISIE GRUPO 1
Equipo PJ GF GC Puntos
1 VV Noordwijk Noordwijk 34 94 41 80
2 Quick Boys Quick Boys 34 84 41 72
3 DVS'33 DVS'33 34 102 47 68
4 Hoek Hoek 34 82 55 64
5 Groningen Sub 21 Groningen 34 66 39 58
6 Harkemase Boys Harkemase 34 68 59 57
7 ASWH ASWH 34 75 54 55
8 SteDoCo SteDoCo 34 65 56 55
9 ODIN '59 ODIN '59 34 71 66 54
10 Lisse Lisse 34 62 64 51
11 DOVO DOVO 34 76 66 48
12 Ajax Amateurs Ajax 34 52 61 41
13 ONS Sneek ONS Sneek 34 57 58 39
14 VVOG VVOG 34 41 72 35
15 Eemdijk Eemdijk 34 51 87 29
16 SJC Noordwijk Noordwijk 34 50 105 26
17 Achilles 29 Achilles 29 34 44 107 20
18 De Dijk De Dijk 34 49 111 19
TEMPORADA 2017/2018
HOOFDKLASSE ZATERDAG GRUPO 1
Equipo PJ GF GC Puntos
1 VV Noordwijk Noordwijk 30 89 33 69
2 Ter Leede Ter Leede 30 70 43 62
3 SteDoCo SteDoCo 30 61 32 60
4 Hoek Hoek 30 63 41 55
5 Achilles Veen Achilles 30 48 34 54
6 Rijnvogels Rijnvogels 30 47 41 44
7 S Gravenzande SV Gravenzande 30 69 61 43
8 Jodan Boys Jodan Boys 30 53 46 42
9 Zwaluwen Zwaluwen 30 49 54 40
10 Swift Swift 30 40 54 37
11 Smitshoek Smitshoek 30 47 59 34
12 Nootdorp Nootdorp 30 35 67 32
13 AFC II AFC II 30 56 69 30
14 Rijsoord Rijsoord 30 33 57 29
15 RVVH RVVH 30 24 55 24
16 SV Argon SV Argon 30 32 70 17
TEMPORADA 2016/2017
DERDE DIVISIE GRUPO 1
Equipo PJ GF GC Puntos
1 IJsselmeervogels IJsselmeervo 34 74 36 70
2 Lisse Lisse 34 55 38 65
3 Rijnsburgse Boys Rijnsburgse 34 84 62 61
4 ASWH ASWH 34 64 53 58
5 Scheveningen Scheveningen 34 54 48 56
6 Jong Volendam Jong 34 60 56 56
7 DVS'33 DVS'33 34 54 49 48
8 Harkemase Boys Harkemase 34 55 60 46
9 Groningen Sub 21 Groningen 34 48 46 45
10 VVOG VVOG 34 49 55 44
11 Quick Boys Quick Boys 34 47 54 43
12 Capelle Capelle 34 42 52 41
13 ONS Sneek ONS Sneek 34 51 60 40
14 Jong Almere City Jong Almere 34 63 61 38
15 ODIN '59 ODIN '59 34 58 63 36
16 SteDoCo SteDoCo 34 46 69 35
17 Huizen Huizen 34 38 57 33
18 Rijnvogels Rijnvogels 34 55 78 33
TEMPORADA 2015/2016
DERDE DIVISIE GRUPO 1
Equipo PJ GF GC Puntos
1 Excelsior Maassluis Excelsior 30 46 31 59
2 HHC Hardenberg Hardenberg 30 54 38 58
3 Katwijk Katwijk 30 62 36 57
4 Kozakken Boys Kozakken 30 57 39 54
5 BVV Barendrecht Barendrecht 30 68 48 53
6 Spakenburg Spakenburg 30 67 52 47
7 GVVV GVVV 30 51 42 46
8 Rijnsburgse Boys Rijnsburgse 30 51 52 43
9 DVS'33 DVS'33 30 57 53 39
10 ONS Sneek ONS Sneek 30 43 63 34
11 Capelle Capelle 30 36 47 31
12 IJsselmeervogels IJsselmeervo 30 34 50 31
13 Scheveningen Scheveningen 30 42 47 30
14 SteDoCo SteDoCo 30 41 72 30
15 Lisse Lisse 30 43 54 29
16 RVVH RVVH 30 32 60 22
TEMPORADA 2014/2015
HOOFDKLASSE ZATERDAG GRUPO 1
Equipo PJ GF GC Puntos
1 SteDoCo SteDoCo 26 50 30 51
2 ODIN '59 ODIN '59 26 45 38 46
3 DOVO DOVO 26 39 30 40
4 Achilles Veen Achilles 26 43 39 40
5 VVA .71 VVA .71 26 44 33 39
6 Jodan Boys Jodan Boys 26 46 35 35
7 SDC Putten SDC Putten 26 38 39 34
8 NSC NSC 26 44 51 34
9 Breukelen Breukelen 26 47 60 32
10 Bennekom Bennekom 26 32 36 31
11 Huizen Huizen 26 37 32 30
12 Door Fusie Sterk Door Fusie. 26 32 46 29
13 Montfoort Montfoort 26 30 40 24
14 RKAV Volendam RKAV 26 46 64 24
TEMPORADA 2013/2014
HOOFDKLASSE ZATERDAG GRUPO 2
Equipo PJ GF GC Puntos
1 Hoek Hoek 26 49 18 58
2 RVVH RVVH 26 28 13 47
3 SteDoCo SteDoCo 26 54 36 44
4 Zwaluwen Zwaluwen 26 42 33 44
5 Smitshoek Smitshoek 26 36 31 41
6 Achilles Veen Achilles 26 38 40 38
7 ASWH ASWH 26 49 38 37
8 Xerxes Xerxes 26 43 31 36
9 S Gravenzande SV Gravenzande 26 35 44 36
10 Jodan Boys Jodan Boys 26 44 50 34
11 Kloetinge Kloetinge 26 43 40 31
12 Deltasport Deltasport 26 32 46 28
13 Heinenoord Heinenoord 26 39 69 21
14 Oranje Wit Oranje Wit 26 20 63 13
TEMPORADA 2012/2013
HOOFDKLASSE ZATERDAG GRUPO 2
Equipo PJ GF GC Puntos
1 Excelsior Maassluis Excelsior 26 60 30 59
2 ASWH ASWH 26 64 35 55
3 Hoek Hoek 26 55 32 51
4 RVVH RVVH 26 48 29 49
5 Xerxes Xerxes 26 58 37 45
6 Smitshoek Smitshoek 26 47 42 39
7 Kloetinge Kloetinge 26 47 48 35
8 Heinenoord Heinenoord 26 42 48 34
9 Zwaluwen Zwaluwen 26 45 45 32
10 SteDoCo SteDoCo 26 51 55 32
11 Achilles Veen Achilles 26 33 50 32
12 Alexandria .66 Alexandria 26 34 47 23
13 Nivo Sparta Nivo Sparta 26 28 75 15
14 Nieuw Lekkerland Nieuw 26 29 68 12
TEMPORADA 2011/2012
EERSTE KLASSE ZATERDAG GRUPO 3
Equipo PJ GF GC Puntos
1 SteDoCo SteDoCo 26 80 31 63
2 Heinenoord Heinenoord 26 60 31 51
3 VVGZ VVGZ 26 37 23 51
4 Oranje Wit Oranje Wit 25 46 30 44
5 Alblasserdam Alblasserdam 26 46 45 39
6 De Zwerver De Zwerver 26 40 33 38
7 Roda Boys Roda Boys 26 54 65 37
8 Sliedrecht Sliedrecht 26 54 44 36
9 Almkerk Almkerk 26 43 40 30
10 GPC Vlissingen Vlissingen 25 26 39 29
11 Rijsoord Rijsoord 25 47 59 26
12 Zaamslag Zaamslag 25 37 43 25
13 Everstein Everstein 25 33 50 25
14 VVC .68 VVC .68 25 18 88 8
TEMPORADA 2010/2011
EERSTE KLASSE ZATERDAG GRUPO 3
Equipo PJ GF GC Puntos
1 Achilles Veen Achilles 26 77 27 60
2 Oranje Wit Oranje Wit 26 55 32 51
3 Alblasserdam Alblasserdam 26 70 39 46
4 Nivo Sparta Nivo Sparta 26 52 34 45
5 Zaamslag Zaamslag 26 54 59 44
6 VVGZ VVGZ 26 45 35 42
7 SteDoCo SteDoCo 26 57 30 39
8 GPC Vlissingen Vlissingen 26 41 43 36
9 Roda Boys Roda Boys 26 61 80 34
10 De Zwerver De Zwerver 26 50 46 33
11 Schelluinen Schelluinen 26 40 52 30
12 Terneuzense Boys Terneuzense 26 26 49 27
13 Bruse Boys Bruse Boys 26 39 59 21
14 Dauwendaele Dauwendaele 26 20 102 6

  USO DE MEMORIA  
6,815,384 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0012
Controller Execution Time ( Home / Category )  0.1420
Total Execution Time  0.1432
  CADENA URL  
/historico/Stedoco
  GET DATOS  
$_GET['/historico/Stedoco']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (37)  
0.0029  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 = 'Stedoco' 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.0020  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=7267 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=7267 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=7267 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0043  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 = 72637
0.0019  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=7267 AND type_rel = 2
0.0026  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 = '7267' AND l.year = 2024 ORDER BY l.year DESC,cat.coefficient DESC
0.0024  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 = '7267' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0026  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 = 72637 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0024  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 = 72700 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0024  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=7267 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 (72700,72637,71876,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.0022  SELECT count(id) as num_players from rel_players WHERE league_id = 72700 AND teamId = 7267
0.0026  SELECT count(id) as num_players from rel_players WHERE league_id = 72637 AND teamId = 7267
0.0020  SELECT count(id) as num_players from rel_players WHERE league_id = 71876 AND teamId = 7267
0.0023  SELECT count(id) as num_players from rel_players WHERE league_id = 67320 AND teamId = 7267
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 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 = 72700 AND t.round = 31 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0023  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 = '7267' 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 = '7267' and rp.type = 4
0.0023  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 = '7267' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0056  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 = 72700 WHERE rp.league_id = 72700 AND rp.teamId = 7267 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.0050  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 = 72700 WHERE rp.league_id = 72700 AND rp.teamId = 7267 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0034  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 = 72700 WHERE rp.league_id = 72700 AND rp.teamId = 7267 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0027  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 = 7267 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
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 `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 = 68212 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.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 `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 = 63259 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.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 = 57889 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 = 50980 AND t.round = 24 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 = 44605 AND t.round = 34 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 `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 = 39746 AND t.round = 30 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 `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 = 33929 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 `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 = 15931 AND t.round = 30 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 = 9387 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 = 9394 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 `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 = 2190 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 `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 = 1721 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 `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 = 20431 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC