4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del SJC Noordwijk
TEMPORADA 2023/2024
HOOFDKLASSE ZATERDAG GRUPO 1
Equipo PJ GF GC Puntos
1 AFC '34 AFC '34 0 0 0 0
2 Ajax Amateurs Ajax 0 0 0 0
3 Alphense Boys Alphense 0 0 0 0
4 ARC Alphense Alphense 0 0 0 0
5 BOL BOL 0 0 0 0
6 DHSC DHSC 0 0 0 0
7 HBC HBC 0 0 0 0
8 Hollandia Hollandia 0 0 0 0
9 Hoogland Hoogland 0 0 0 0
10 Huizen Huizen 0 0 0 0
11 JOS Watergraafsmeer Watergraafsm 0 0 0 0
12 Purmersteijn Purmersteijn 0 0 0 0
13 SJC Noordwijk Noordwijk 0 0 0 0
14 Swift Swift 0 0 0 0
15 Ter Leede Ter Leede 0 0 0 0
16 WV-HEDW WV-HEDW 0 0 0 0
TEMPORADA 2022/2023
HOOFDKLASSE ZONDAG GRUPO 1
Equipo PJ GF GC Puntos
1 Hoogeveen Hoogeveen 30 75 34 62
2 RKAVV RKAVV 30 48 21 61
3 Purmersteijn Purmersteijn 30 65 35 60
4 HBS HBS 30 66 41 56
5 Be Quick 1887 Quick 1887 30 55 25 55
6 SJC Noordwijk Noordwijk 30 63 59 50
7 ROHDA Raalte ROHDA Raalte 30 61 50 49
8 Westlandia Westlandia 30 57 56 48
9 Hollandia Hollandia 30 62 43 46
10 Heino Heino 30 43 40 37
11 Alphense Boys Alphense 30 49 68 35
12 VOC VOC 30 50 59 33
13 De Zouaven De Zouaven 30 46 71 27
14 RKVV Velsen RKVV Velsen 30 39 71 22
15 Alcides Alcides 30 28 82 15
16 VKW VKW 30 21 73 14
TEMPORADA 2021/2022
HOOFDKLASSE ZONDAG GRUPO 1
Equipo PJ GF GC Puntos
1 TOGB TOGB 28 63 36 62
2 HBS HBS 28 65 25 58
3 Hoogeveen Hoogeveen 28 77 40 56
4 SJC Noordwijk Noordwijk 28 74 47 55
5 Be Quick 1887 Quick 1887 28 66 29 52
6 RKAVV RKAVV 28 49 41 44
7 Purmersteijn Purmersteijn 28 56 51 38
8 Alphense Boys Alphense 28 57 65 38
9 RKVV Velsen RKVV Velsen 28 38 46 34
10 VOC VOC 28 45 53 33
11 Alcides Alcides 28 48 68 29
12 De Zouaven De Zouaven 28 46 63 27
13 TAC'90 TAC'90 28 41 68 26
14 SDO Bussum SDO Bussum 28 29 80 18
15 VV Emmen VV Emmen 28 26 68 17
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 1
Equipo PJ GF GC Puntos
1 Hollandia Hollandia 20 42 20 43
2 JOS Watergraafsmeer Watergraafsm 19 47 24 40
3 RKAVV RKAVV 21 53 33 36
4 SJC Noordwijk Noordwijk 20 45 31 35
5 Alphense Boys Alphense 20 43 28 34
6 Hoogeveen Hoogeveen 19 36 31 33
7 Leonidas Leonidas 19 38 33 30
8 HBS HBS 20 30 26 29
9 Quick '20 Quick '20 20 52 46 28
10 SDO Bussum SDO Bussum 20 45 44 26
11 RKVV Velsen RKVV Velsen 19 28 30 26
12 Be Quick 1887 Quick 1887 21 32 25 25
13 VV Emmen VV Emmen 20 41 55 19
14 Alcides Alcides 20 24 48 14
15 MSC MSC 19 18 67 14
16 VOC VOC 21 25 58 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 ZONDAG GRUPO 1
Equipo PJ GF GC Puntos
1 SJC Noordwijk Noordwijk 30 75 37 62
2 Achilles 1894 Achilles 30 73 34 56
3 Silvolde Silvolde 30 69 35 55
4 Leonidas Leonidas 30 65 53 51
5 Purmersteijn Purmersteijn 30 57 47 48
6 Hollandia Hollandia 30 65 48 47
7 Alphense Boys Alphense 30 54 49 47
8 SDO Bussum SDO Bussum 30 60 50 44
9 RKAVV RKAVV 30 55 51 41
10 MSC MSC 30 60 77 41
11 De Bataven De Bataven 30 42 48 35
12 RKHVV RKHVV 30 50 63 35
13 SWZ SWZ 30 37 49 33
14 DHC Delft DHC Delft 30 47 73 30
15 VV Heerenveen Heerenveen 30 34 72 24
16 Achilles 29 II Achilles 30 45 102 17
TEMPORADA 2016/2017
HOOFDKLASSE ZONDAG GRUPO 1
Equipo PJ GF GC Puntos
1 ADO 20 ADO 20 30 82 41 64
2 Woezik Woezik 30 57 32 55
3 SJC Noordwijk Noordwijk 30 64 39 53
4 Hollandia Hollandia 30 51 33 53
5 Silvolde Silvolde 30 54 51 49
6 De Meern De Meern 30 70 55 45
7 SWZ SWZ 30 65 52 41
8 SDO Bussum SDO Bussum 30 42 45 40
9 VV Heerenveen Heerenveen 30 49 52 38
10 De Bataven De Bataven 30 45 60 38
11 MSC MSC 30 53 55 37
12 RKHVV RKHVV 30 42 52 37
13 Alverna Alverna 30 50 45 36
14 JOS Watergraafsmeer Watergraafsm 30 51 55 36
15 Hoogland Hoogland 30 42 56 33
16 Dieze West Dieze West 30 28 122 6
TEMPORADA 2015/2016
EERSTE KLASSE ZONDAG GRUPO 2
Equipo PJ GF GC Puntos
1 IFC IFC 24 67 20 60
2 FC Boshuizen Boshuizen 24 60 35 57
3 SJC Noordwijk Noordwijk 24 72 26 53
4 VOC VOC 24 47 41 39
5 VELO VELO 24 48 42 38
6 Zwervers Zwervers 24 45 50 31
7 DRL DRL 24 42 45 30
8 Poortugaal Poortugaal 24 49 51 28
9 FC Olympia FC Olympia 24 25 45 26
10 TAC'90 TAC'90 24 39 66 25
11 Wateringse Veld Wateringse 23 29 46 16
12 PFC PFC 24 24 59 16
13 GDA GDA 23 29 50 13
TEMPORADA 2014/2015
EERSTE KLASSE ZONDAG GRUPO 1
Equipo PJ GF GC Puntos
1 De Meern De Meern 26 73 33 60
2 Alphense Boys Alphense 26 72 38 53
3 SDO Bussum SDO Bussum 26 62 36 50
4 Purmersteijn Purmersteijn 26 51 40 41
5 SJC Noordwijk Noordwijk 26 63 62 36
6 VVIJ VVIJ 26 56 52 35
7 SC Woerden SC Woerden 26 48 45 33
8 RKVV DEM RKVV DEM 26 51 57 32
9 SO Soest SO Soest 26 41 53 30
10 Foresters Foresters 26 43 58 29
11 Elinkwijk Elinkwijk 26 49 75 29
12 Nieuw Utrecht Nieuw 26 43 56 27
13 Stormvogels Stormvogels 26 50 74 27
14 De Kennemers Kennemers 26 44 67 18
TEMPORADA 2013/2014
EERSTE KLASSE ZONDAG GRUPO 2
Equipo PJ GF GC Puntos
1 Magreb 90 Magreb 90 26 61 24 55
2 Nieuwerkerk Nieuwerkerk 26 73 44 53
3 VELO VELO 26 54 36 51
4 Alphense Boys Alphense 26 75 34 50
5 SJC Noordwijk Noordwijk 26 72 49 49
6 UVS UVS 26 67 44 45
7 Neptunus-Schiebroek Neptunus-Sch 26 50 41 41
8 Zwervers Zwervers 26 59 65 39
9 Kocatepe Kocatepe 26 53 57 32
10 HMSH HMSH 26 49 63 31
11 TOGB TOGB 26 41 71 22
12 Poortugaal Poortugaal 26 33 62 18
13 Nieuwkoop Nieuwkoop 26 41 89 14
14 PFC PFC 26 28 77 14
TEMPORADA 2012/2013
EERSTE KLASSE ZONDAG GRUPO 2
Equipo PJ GF GC Puntos
1 VOC VOC 26 63 27 56
2 FC Boshuizen Boshuizen 26 51 32 46
3 De Meern De Meern 26 48 33 46
4 UVS UVS 26 43 34 43
5 Neptunus-Schiebroek Neptunus-Sch 26 44 37 43
6 VELO VELO 26 39 40 40
7 SJC Noordwijk Noordwijk 26 54 49 39
8 Magreb 90 Magreb 90 26 49 42 38
9 Nieuwerkerk Nieuwerkerk 26 42 45 36
10 Kocatepe Kocatepe 26 46 44 34
11 ADO Den Haag II Haag 26 43 46 33
12 PFC PFC 26 37 56 25
13 Excelsior .20 Excelsior 26 35 54 23
14 RKDEO RKDEO 26 24 79 10
TEMPORADA 2011/2012
EERSTE KLASSE ZONDAG GRUPO 2
Equipo PJ GF GC Puntos
1 Quick Quick 26 55 33 55
2 FC Boshuizen Boshuizen 26 66 44 54
3 VELO VELO 26 59 44 44
4 ADO Den Haag II Haag 26 52 47 42
5 UVS UVS 25 56 44 41
6 Neptunus-Schiebroek Neptunus-Sch 25 41 34 40
7 Nieuwerkerk Nieuwerkerk 25 39 37 40
8 Pancratius Pancratius 26 60 55 38
9 SJC Noordwijk Noordwijk 25 66 57 35
10 Excelsior .20 Excelsior 26 41 49 35
11 VUC VUC 26 37 42 27
12 HVV HVV 25 30 50 24
13 GDA GDA 26 37 62 24
14 Papendrecht Papendrecht 25 21 62 6
TEMPORADA 2010/2011
EERSTE KLASSE ZONDAG GRUPO 2
Equipo PJ GF GC Puntos
1 RKAVV RKAVV 26 65 26 59
2 SJC Noordwijk Noordwijk 26 69 36 56
3 Excelsior .20 Excelsior 26 42 39 46
4 Neptunus-Schiebroek Neptunus-Sch 26 40 29 45
5 GDA GDA 26 43 60 36
6 VUC VUC 26 44 42 35
7 HVV HVV 26 39 40 35
8 FC Boshuizen Boshuizen 26 53 50 34
9 HV & CV Quick Quick 26 36 38 33
10 FC Blauw Wit Amsterdam Blauw 26 44 47 33
11 SCO 63 SCO 63 26 37 53 28
12 Wilhelmus Wilhelmus 26 48 57 27
13 TOGB TOGB 26 25 44 22
14 WRW WRW 26 29 53 17
TEMPORADA 2009/2010
EERSTE KLASSE ZONDAG GRUPO 2
Equipo PJ GF GC Puntos
1 Nieuwenhoorn Nieuwenhoorn 22 36 19 44
2 Alphense Boys Alphense 22 50 28 42
3 DHC Delft DHC Delft 22 52 36 37
4 SJC Noordwijk Noordwijk 22 40 31 35
5 HV & CV Quick Quick 22 41 35 33
6 Leonidas Leonidas 22 32 32 33
7 VUC VUC 22 27 30 29
8 RKAVV RKAVV 22 32 40 27
9 Neptunus-Schiebroek Neptunus-Sch 22 38 43 25
10 HVV HVV 22 20 46 24
11 TOGB TOGB 22 26 34 22
12 Jai Hind Rotterdam Hind 22 26 46 14
TEMPORADA 2008/2009
EERSTE KLASSE ZONDAG GRUPO 2
Equipo PJ GF GC Puntos
1 SC Feyenoord Feyenoord 22 41 20 46
2 Neptunus-Schiebroek Neptunus-Sch 22 52 28 42
3 DHC Delft DHC Delft 22 41 33 42
4 TONEGIDO TONEGIDO 22 55 30 40
5 SJC Noordwijk Noordwijk 22 45 36 34
6 Nieuwenhoorn Nieuwenhoorn 22 30 49 31
7 Jai Hind Rotterdam Hind 22 38 32 27
8 RKAVV RKAVV 22 22 26 26
9 Leonidas Leonidas 22 23 33 23
10 SC Woerden SC Woerden 22 27 41 20
11 DCV DCV 22 20 43 19
12 FC Boshuizen Boshuizen 22 17 40 15

  USO DE MEMORIA  
6,781,016 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0012
Controller Execution Time ( Home / Category )  0.1253
Total Execution Time  0.1264
  CADENA URL  
/historico/Sjc-Noordwijk
  GET DATOS  
$_GET['/historico/Sjc-Noordwijk']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (39)  
0.0028  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 = 'Sjc-Noordwijk' 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=7328 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=7328 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=7328 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0037  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 = 72976
0.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=7328 AND type_rel = 2
0.0025  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 = '7328' 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 = '7328' 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 = '7328' 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 = 72976 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=7328 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 (72976,72637,70056) 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 = 72976 AND teamId = 7328
0.0018  SELECT count(id) as num_players from rel_players WHERE league_id = 70056 AND teamId = 7328
0.0024  SELECT count(id) as num_players from rel_players WHERE league_id = 72637 AND teamId = 7328
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 = 72976 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 = '7328' 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 = '7328' and rp.type = 4
0.0020  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 = '7328' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0023  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 = 72976 WHERE rp.league_id = 72976 AND rp.teamId = 7328 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.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 = 72976 WHERE rp.league_id = 72976 AND rp.teamId = 7328 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 = 72976 WHERE rp.league_id = 72976 AND rp.teamId = 7328 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0023  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 = 7328 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
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 `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 = 72976 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.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 `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 = 70056 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 = 63264 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.0020  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.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 `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 = 50984 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.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 `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.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 `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 = 39750 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 `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 = 33960 AND t.round = 30 ORDER BY team.conference 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 `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 = 16016 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 = 9399 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 `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 = 9417 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 `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 = 2220 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 = 1725 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0028  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 = 20461 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 `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 = 20467 AND t.round = 22 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 `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 = 20473 AND t.round = 22 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC