4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del Purmersteijn
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 ZATERDAG GRUPO 2
Equipo PJ GF GC Puntos
1 Staphorst Staphorst 21 62 19 47
2 ACV Assen ACV Assen 21 46 32 42
3 Eemdijk Eemdijk 21 28 15 41
4 Swift Swift 21 39 26 39
5 HZVV HZVV 21 41 28 38
6 Genemuiden Genemuiden 21 45 25 37
7 Urk Urk 21 34 25 31
8 Berkum Berkum 21 37 31 31
9 NSC NSC 20 39 37 29
10 RKAV Volendam RKAV 21 43 42 29
11 De Dijk De Dijk 21 24 40 21
12 SDC Putten SDC Putten 21 22 40 21
13 Flevo Boys Flevo Boys 21 27 33 20
14 DETO Twenterand DETO 21 27 49 18
15 Purmersteijn Purmersteijn 21 26 56 14
16 Buitenpost Buitenpost 20 17 59 11
TEMPORADA 2018/2019
HOOFDKLASSE ZONDAG GRUPO 1
Equipo PJ GF GC Puntos
1 RKVV DEM RKVV DEM 30 60 31 60
2 Hoogeveen Hoogeveen 30 71 45 57
3 SDO Bussum SDO Bussum 30 69 48 57
4 RKZVC RKZVC 30 59 53 53
5 Hoogland Hoogland 30 53 43 49
6 Alcides Alcides 30 51 51 44
7 Silvolde Silvolde 30 54 46 42
8 Hollandia Hollandia 30 43 49 42
9 Purmersteijn Purmersteijn 30 48 37 41
10 MSC MSC 30 53 58 39
11 AWC AWC 30 52 69 39
12 Be Quick 1887 Quick 1887 30 52 51 37
13 De Bataven De Bataven 30 51 60 37
14 Fortuna Wormerveer Fortuna 30 39 52 31
15 Achilles 1894 Achilles 30 47 59 30
16 RKHVV RKHVV 30 30 80 14
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
EERSTE KLASSE ZONDAG GRUPO 1
Equipo PJ GF GC Puntos
1 Purmersteijn Purmersteijn 26 53 21 57
2 AFC '34 AFC '34 26 61 42 46
3 RKVV Velsen RKVV Velsen 26 47 34 46
4 RKVV DEM RKVV DEM 26 59 43 45
5 EDO HFC EDO HFC 26 40 38 44
6 Hillegom Hillegom 26 62 55 41
7 Legmeervogels Legmeervogel 26 40 33 40
8 Fortuna Wormerveer Fortuna 26 42 38 36
9 Zeeburgia Zeeburgia 26 38 38 35
10 Assendelft Assendelft 26 36 44 29
11 SO Soest SO Soest 26 46 57 27
12 Elinkwijk Elinkwijk 26 39 54 25
13 VSV VSV 26 36 49 23
14 Nieuw Utrecht Nieuw 26 27 80 16
TEMPORADA 2015/2016
EERSTE KLASSE ZONDAG GRUPO 1
Equipo PJ GF GC Puntos
1 Hoogland Hoogland 26 51 27 56
2 Purmersteijn Purmersteijn 26 49 20 55
3 Alphense Boys Alphense 26 53 39 45
4 Fortuna Wormerveer Fortuna 26 63 49 44
5 AFC '34 AFC '34 26 48 41 38
6 RKVV DEM RKVV DEM 26 49 42 37
7 VSV VSV 26 41 40 36
8 SO Soest SO Soest 26 38 42 33
9 Zeeburgia Zeeburgia 26 47 52 33
10 SC Woerden SC Woerden 26 46 59 32
11 VVIJ VVIJ 26 28 43 32
12 De Zouaven De Zouaven 26 37 47 29
13 Quick 1890 Quick 1890 26 38 52 24
14 Foresters Foresters 26 39 74 14
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 2012/2013
EERSTE KLASSE ZONDAG GRUPO 1
Equipo PJ GF GC Puntos
1 De Dijk De Dijk 26 75 24 62
2 Zeeburgia Zeeburgia 26 56 31 58
3 JOS Watergraafsmeer Watergraafsm 26 68 26 53
4 USV Hercules Hercules 26 59 40 49
5 Hoogland Hoogland 26 46 37 41
6 AFC '34 AFC '34 26 57 45 35
7 Stormvogels Stormvogels 26 54 71 34
8 Uitgeest Uitgeest 26 42 53 33
9 Pancratius Pancratius 26 35 43 30
10 RKVV DEM RKVV DEM 26 44 64 28
11 DWV DWV 26 27 42 23
12 VVIJ VVIJ 26 32 64 23
13 Purmersteijn Purmersteijn 26 38 60 22
14 FC Blauw Wit Amsterdam Blauw 26 34 67 20
TEMPORADA 2011/2012
HOOFDKLASSE ZONDAG GRUPO 1
Equipo PJ GF GC Puntos
1 ADO 20 ADO 20 24 62 21 55
2 Leonidas Leonidas 24 47 31 45
3 Alphense Boys Alphense 24 42 31 40
4 SC Feyenoord Feyenoord 24 51 35 39
5 RKAVV RKAVV 24 26 26 37
6 De Zouaven De Zouaven 24 42 33 36
7 Nieuwenhoorn Nieuwenhoorn 24 36 39 36
8 Chabab Chabab 24 42 39 33
9 Elinkwijk Elinkwijk 24 33 36 29
10 DHC DHC 24 40 43 24
11 Koninklijke HFC Koninklijke 24 34 45 24
12 Westlandia Westlandia 24 33 50 23
13 Purmersteijn Purmersteijn 24 26 55 18
14 AFC '34 AFC '34 24 27 57 15
TEMPORADA 2010/2011
EERSTE KLASSE ZONDAG GRUPO 1
Equipo PJ GF GC Puntos
1 Koninklijke HFC Koninklijke 26 42 27 49
2 EDO HFC EDO HFC 26 54 29 47
3 RKVV DEM RKVV DEM 26 54 41 44
4 Pancratius Pancratius 26 45 39 43
5 Roda .46 (Zon) Roda (Zon) 26 59 50 42
6 Stormvogels Stormvogels 26 45 39 40
7 Purmersteijn Purmersteijn 26 41 31 38
8 DWV DWV 26 46 46 38
9 De Meern De Meern 26 48 35 36
10 VVIJ VVIJ 26 44 44 34
11 Almere City Amateurs Almere City 26 38 44 31
12 De Kennemers Kennemers 26 28 51 24
13 NVC NVC 26 28 55 20
14 SVW 27 SVW 27 26 31 72 19
TEMPORADA 2009/2010
EERSTE KLASSE ZONDAG GRUPO 1
Equipo PJ GF GC Puntos
1 De Zouaven De Zouaven 22 43 15 43
2 AFC '34 AFC '34 22 43 20 41
3 JOS Watergraafsmeer Watergraafsm 22 41 25 38
4 De Meern De Meern 22 26 21 37
5 NVC NVC 22 44 34 35
6 Purmersteijn Purmersteijn 22 36 30 30
7 Roda .46 (Zon) Roda (Zon) 22 35 47 29
8 De Kennemers Kennemers 22 21 32 24
9 FC Blauw Wit Amsterdam Blauw 22 20 29 22
10 DWV DWV 22 26 40 22
11 USV Hercules Hercules 22 22 38 18
12 KFC KFC 22 19 45 17

  USO DE MEMORIA  
6,593,576 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0012
Controller Execution Time ( Home / Category )  0.6032
Total Execution Time  0.6044
  CADENA URL  
/historico/Purmersteijn
  GET DATOS  
$_GET['/historico/Purmersteijn']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (39)  
0.0139  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 = 'Purmersteijn' 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.0125  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=7199 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0125  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=7199 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0125  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=7199 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0125  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=7199 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0125  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=7199 AND type_rel = 2
0.0125  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=226 AND type_rel = 3
0.0126  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 3 AND rel.typeId = 226 AND rel.ln = 'es' AND rel.status=1 ORDER BY rel.creation_date desc,rel.cover_points DESC LIMIT 5
0.0127  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 (859778,183993,112119,50354,49516) ORDER BY n.cover_points DESC, update_date DESC
0.0128  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 = '7199' ORDER BY l.year DESC,cat.coefficient DESC
0.0128  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 = '7199' AND l.year = 2024 ORDER BY l.year DESC,cat.coefficient DESC
0.0127  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 = '7199' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0127  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=7199 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0126  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,71432,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.0125  SELECT count(id) as num_players from rel_players WHERE league_id = 72976 AND teamId = 7199
0.0125  SELECT count(id) as num_players from rel_players WHERE league_id = 70056 AND teamId = 7199
0.0126  SELECT count(id) as num_players from rel_players WHERE league_id = 72637 AND teamId = 7199
0.0127  SELECT count(id) as num_players from rel_players WHERE league_id = 71432 AND teamId = 7199
0.0127  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 = '7199' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0125  SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '7199' and rp.type = 4
0.0128  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 = '7199' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0130  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 = 7199 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.0133  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 = 7199 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0135  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 = 7199 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0150  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 = 7199 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
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 `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.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 `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.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 `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.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 `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.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 `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 = 50987 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.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 `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 = 44702 AND t.round = 30 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 `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.0129  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 = 33981 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 `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 = 16015 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 `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.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 `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 = 2219 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
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,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 = 1716 AND t.round = 26 ORDER BY team.conference 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 `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 = 20460 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0135  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 = 20466 AND t.round = 22 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC