4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del Rijnvogels
TEMPORADA 2023/2024
DERDE DIVISIE GRUPO 1
Equipo PJ GF GC Puntos
1 RKAV Volendam RKAV 30 80 48 57
2 Genemuiden Genemuiden 30 64 33 55
3 IJsselmeervogels IJsselmeervo 30 61 38 54
4 Sparta Nijkerk Sparta 30 74 54 53
5 USV Hercules Hercules 30 54 39 51
6 Harkemase Boys Harkemase 30 56 43 47
7 DOVO DOVO 30 52 37 46
8 HSC 21 HSC 21 30 53 47 45
9 Rijnvogels Rijnvogels 30 53 55 44
10 Eemdijk Eemdijk 30 47 51 42
11 Urk Urk 30 51 58 42
12 RKVV DEM RKVV DEM 30 43 51 40
13 DVS'33 DVS'33 30 46 39 38
14 VVSB VVSB 30 54 61 38
15 Staphorst Staphorst 30 49 61 36
16 Hoogeveen Hoogeveen 30 40 75 33
17 Kampong Kampong 30 40 59 21
18 ODIN '59 ODIN '59 30 25 93 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
HOOFDKLASSE ZATERDAG GRUPO 1
Equipo PJ GF GC Puntos
1 Rijnvogels Rijnvogels 30 78 36 64
2 SC Feyenoord Feyenoord 30 66 36 59
3 Capelle Capelle 30 55 27 59
4 ARC Alphense Alphense 30 66 34 56
5 Achilles Veen Achilles 30 62 38 50
6 S Gravenzande SV Gravenzande 30 63 53 49
7 Smitshoek Smitshoek 30 46 51 46
8 Poortugaal Poortugaal 30 52 50 43
9 Zwaluwen Zwaluwen 30 55 45 41
10 Jodan Boys Jodan Boys 30 44 42 39
11 DHSC DHSC 30 36 47 36
12 Spijkenisse Spijkenisse 30 38 53 36
13 VV Scherpenzeel Scherpenzeel 30 58 61 35
14 DUNO DUNO 30 42 49 35
15 Achilles 29 Achilles 29 30 33 89 17
16 Rijsoord Rijsoord 30 28 111 12
TEMPORADA 2020/2021
HOOFDKLASSE ZATERDAG GRUPO 1
Equipo PJ GF GC Puntos
1 Achilles Veen Achilles 6 19 10 16
2 S Gravenzande SV Gravenzande 6 16 5 13
3 ARC Alphense Alphense 6 12 9 13
4 Jodan Boys Jodan Boys 6 12 4 12
5 Rijnvogels Rijnvogels 5 12 8 12
6 SC Feyenoord Feyenoord 5 18 7 11
7 DHSC DHSC 5 16 13 9
8 Spijkenisse Spijkenisse 5 11 9 6
9 DUNO DUNO 5 5 3 6
10 Poortugaal Poortugaal 4 10 12 5
11 Smitshoek Smitshoek 6 8 19 4
12 Capelle Capelle 4 8 9 3
13 VV Scherpenzeel Scherpenzeel 4 4 11 3
14 Zwaluwen Zwaluwen 4 8 16 0
15 Achilles 29 Achilles 29 5 2 11 0
16 Rijsoord Rijsoord 4 1 16 0
TEMPORADA 2019/2020
HOOFDKLASSE ZATERDAG GRUPO 1
Equipo PJ GF GC Puntos
1 Sportlust 46 Sportlust 21 46 21 42
2 DHSC DHSC 21 44 26 41
3 SC Feyenoord Feyenoord 21 55 29 38
4 Achilles Veen Achilles 21 49 25 36
5 AZSV AZSV 20 32 23 34
6 Smitshoek Smitshoek 21 31 33 33
7 Rijnvogels Rijnvogels 21 32 29 30
8 ARC Alphense Alphense 21 29 28 30
9 Jodan Boys Jodan Boys 21 28 29 30
10 Capelle Capelle 21 35 30 29
11 Spijkenisse Spijkenisse 21 34 33 28
12 Zwaluwen Zwaluwen 20 31 35 26
13 DUNO DUNO 20 30 33 25
14 Rijsoord Rijsoord 21 22 46 22
15 S Gravenzande SV Gravenzande 21 24 37 19
16 Achilles 29 Achilles 29 20 12 77 1
TEMPORADA 2018/2019
HOOFDKLASSE ZATERDAG GRUPO 1
Equipo PJ GF GC Puntos
1 Ter Leede Ter Leede 30 62 31 67
2 RKAV Volendam RKAV 30 84 46 61
3 SC Feyenoord Feyenoord 30 72 55 54
4 Zwaluwen Zwaluwen 30 50 39 50
5 Den Bosch II Bosch 30 65 46 47
6 Rijnvogels Rijnvogels 30 53 44 46
7 Jodan Boys Jodan Boys 30 52 46 46
8 S Gravenzande SV Gravenzande 30 57 54 44
9 Smitshoek Smitshoek 30 46 48 41
10 Swift Swift 30 58 52 39
11 Achilles Veen Achilles 30 50 45 39
12 Capelle Capelle 30 47 57 39
13 Spijkenisse Spijkenisse 30 50 58 37
14 Door Fusie Sterk Door Fusie. 30 38 70 24
15 Nootdorp Nootdorp 30 32 65 23
16 Xerxes DZB Xerxes DZB 30 32 92 13
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
HOOFDKLASSE ZATERDAG GRUPO 2
Equipo PJ GF GC Puntos
1 Quick Boys Quick Boys 26 58 16 64
2 VV Noordwijk Noordwijk 26 63 19 62
3 ASWH ASWH 26 53 25 48
4 Rijnvogels Rijnvogels 26 41 32 45
5 Spijkenisse Spijkenisse 26 48 41 45
6 Jodan Boys Jodan Boys 26 40 28 42
7 Ter Leede Ter Leede 26 36 40 40
8 Hoek Hoek 26 29 37 34
9 Zwaluwen Zwaluwen 26 37 51 30
10 Haaglandia Zaterdag Haaglandia 26 35 49 30
11 Xerxes DZB Xerxes DZB 26 32 43 24
12 Heinenoord Heinenoord 26 21 52 20
13 Sportlust 46 Sportlust 26 27 56 18
14 Deltasport Deltasport 26 29 60 14
TEMPORADA 2014/2015
HOOFDKLASSE ZATERDAG GRUPO 2
Equipo PJ GF GC Puntos
1 Katwijk Katwijk 26 69 26 64
2 Quick Boys Quick Boys 26 49 28 48
3 RVVH RVVH 26 40 30 43
4 ASWH ASWH 26 53 31 41
5 Zwaluwen Zwaluwen 26 42 41 41
6 Spijkenisse Spijkenisse 26 43 36 40
7 VV Noordwijk Noordwijk 26 42 39 38
8 Rijnvogels Rijnvogels 26 47 47 36
9 Ter Leede Ter Leede 26 41 42 35
10 Xerxes Xerxes 26 41 56 29
11 Smitshoek Smitshoek 26 37 52 28
12 Kloetinge Kloetinge 26 34 50 28
13 SHO SHO 26 37 70 23
14 S Gravenzande SV Gravenzande 26 29 56 16
TEMPORADA 2013/2014
EERSTE KLASSE ZATERDAG GRUPO 2
Equipo PJ GF GC Puntos
1 Rijnvogels Rijnvogels 26 67 24 62
2 Swift Swift 26 49 20 54
3 Zwaluwen .30 Zwaluwen 26 50 35 50
4 DSO DSO 26 59 44 39
5 Alexandria .66 Alexandria 26 47 48 36
6 Haaglandia Zaterdag Haaglandia 26 47 48 34
7 Nootdorp Nootdorp 26 40 42 33
8 Forum Sport Forum Sport 26 53 59 33
9 GHC GHC 26 39 48 33
10 Voorschoten .97 Voorschoten 26 41 50 32
11 WV-HEDW WV-HEDW 26 37 43 29
12 RCL RCL 26 37 45 29
13 BVCB BVCB 26 29 46 26
14 Aalsmeer Aalsmeer 26 28 71 16
TEMPORADA 2012/2013
EERSTE KLASSE ZATERDAG GRUPO 2
Equipo PJ GF GC Puntos
1 Deltasport Deltasport 26 75 27 60
2 Rijnvogels Rijnvogels 26 66 31 56
3 Spijkenisse Spijkenisse 26 56 19 52
4 S Gravenzande SV Gravenzande 26 49 38 49
5 SHO SHO 26 62 49 38
6 Voorschoten .97 Voorschoten 26 44 35 38
7 BVCB BVCB 26 41 47 38
8 Nootdorp Nootdorp 26 37 39 35
9 GHC GHC 26 34 43 34
10 RCL RCL 26 36 49 30
11 SV Geinoord SV Geinoord 26 28 43 26
12 Vitesse Delft Vitesse 26 28 49 26
13 DSVP DSVP 26 23 65 22
14 Benschop Benschop 26 25 70 12
TEMPORADA 2011/2012
EERSTE KLASSE ZATERDAG GRUPO 2
Equipo PJ GF GC Puntos
1 Smitshoek Smitshoek 26 66 44 51
2 Deltasport Deltasport 26 32 31 46
3 Rijnvogels Rijnvogels 26 55 46 42
4 BVCB BVCB 26 41 31 41
5 Nootdorp Nootdorp 26 55 55 38
6 RCL RCL 26 34 37 38
7 Alexandria .66 Alexandria 26 44 42 36
8 GHC GHC 26 39 33 35
9 Vitesse Delft Vitesse 26 40 34 34
10 S Gravenzande SV Gravenzande 26 41 42 34
11 Spijkenisse Spijkenisse 26 57 59 33
12 Breukelen Breukelen 26 39 45 31
13 DSO DSO 26 41 51 29
14 Leonidas (Zat) Leonidas 26 42 76 13
TEMPORADA 2010/2011
EERSTE KLASSE ZATERDAG GRUPO 2
Equipo PJ GF GC Puntos
1 Sportlust 46 Sportlust 26 57 34 51
2 Smitshoek Smitshoek 26 66 42 50
3 Deltasport Deltasport 26 48 30 48
4 DSO DSO 26 71 49 47
5 S Gravenzande SV Gravenzande 26 49 35 44
6 Alexandria .66 Alexandria 26 42 34 41
7 Rijnvogels Rijnvogels 26 50 50 35
8 Spijkenisse Spijkenisse 26 53 50 34
9 Nootdorp Nootdorp 26 26 33 32
10 BVCB BVCB 26 31 42 30
11 TOGR TOGR 26 27 36 29
12 Heinenoord Heinenoord 26 41 56 29
13 Strijen Strijen 26 42 49 28
14 DOTO DOTO 26 26 89 16
TEMPORADA 2009/2010
EERSTE KLASSE ZATERDAG GRUPO 2
Equipo PJ GF GC Puntos
1 Voorschoten .97 Voorschoten 22 44 17 45
2 Vitesse Delft Vitesse 22 44 30 36
3 Zwaluwen Zwaluwen 22 35 32 35
4 Xerxes DZB Xerxes DZB 22 42 31 32
5 Spijkenisse Spijkenisse 22 46 38 32
6 Alblasserdam Alblasserdam 22 30 33 31
7 Smitshoek Smitshoek 22 28 34 31
8 Excelsior Maassluis Excelsior 22 29 36 28
9 Rijnvogels Rijnvogels 22 38 42 25
10 S Gravenzande SV Gravenzande 22 35 43 24
11 SHO SHO 22 32 45 23
12 DUNO DUNO 22 23 45 19
TEMPORADA 2008/2009
EERSTE KLASSE ZATERDAG GRUPO 1
Equipo PJ GF GC Puntos
1 Young Boys Young Boys 22 52 11 53
2 ODIN '59 ODIN '59 21 43 16 51
3 Sportlust 46 Sportlust 23 62 32 50
4 Rijnvogels Rijnvogels 23 54 24 45
5 Zuidvogels Zuidvogels 23 42 43 36
6 Huizen Huizen 22 40 30 34
7 De Beursbengels Beursbengels 21 29 38 24
8 Roda'46 Roda'46 22 28 36 21
9 De Merino.s De Merino.s 22 23 40 21
10 Montfoort Montfoort 21 24 39 20
11 Gouda Gouda 21 25 59 9
12 Voorland Voorland 23 23 77 6

  USO DE MEMORIA  
7,018,224 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0011
Controller Execution Time ( Home / Category )  0.1317
Total Execution Time  0.1328
  CADENA URL  
/historico/Rijnvogels
  GET DATOS  
$_GET['/historico/Rijnvogels']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (37)  
0.0030  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 = 'Rijnvogels' 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=7245 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
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=7245 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=7245 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=7245 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=7245 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 = '7245' ORDER BY l.year DESC,cat.coefficient DESC
0.0023  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 = '7245' AND l.year = 2024 ORDER BY l.year DESC,cat.coefficient DESC
0.0022  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 = '7245' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0023  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=7245 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0020  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 (72699,72637,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.0028  SELECT count(id) as num_players from rel_players WHERE league_id = 72699 AND teamId = 7245
0.0027  SELECT count(id) as num_players from rel_players WHERE league_id = 72637 AND teamId = 7245
0.0019  SELECT count(id) as num_players from rel_players WHERE league_id = 71432 AND teamId = 7245
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 = '7245' 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 = '7245' 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 = '7245' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0036  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 = 72699 WHERE rp.league_id = 72699 AND rp.teamId = 7245 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.0033  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 = 72699 WHERE rp.league_id = 72699 AND rp.teamId = 7245 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0030  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 = 72699 WHERE rp.league_id = 72699 AND rp.teamId = 7245 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 = 7245 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
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 `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 = 72699 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.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 `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.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 `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 = 63262 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.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 `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 = 58334 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.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 `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 = 50986 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.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 `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 = 44704 AND t.round = 30 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 `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.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 `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.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 = 15936 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0035  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 = 9388 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 = 9406 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
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,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 = 2226 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 = 1720 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 = 20430 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
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,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 = 20435 AND t.round = 22 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 `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 = 20439 AND t.round = 22 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC