4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Ver
TEMPORADA 2019/2020
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
Ver
TEMPORADA 2018/2019
Equipo PJ GF GC Puntos
1 Excelsior .31 Excelsior 30 63 26 64
2 Staphorst Staphorst 30 65 33 63
3 Sparta Nijkerk Sparta 30 51 29 63
4 AZSV AZSV 30 47 30 58
5 ACV Assen ACV Assen 30 49 33 54
6 Urk Urk 30 47 33 53
7 Berkum Berkum 30 46 49 41
8 DUNO DUNO 30 52 52 40
9 SDC Putten SDC Putten 30 47 40 39
10 Flevo Boys Flevo Boys 30 37 43 36
11 Genemuiden Genemuiden 30 42 49 33
12 Buitenpost Buitenpost 30 31 57 29
13 DETO Twenterand DETO 30 35 54 27
14 Apeldoorn CSV Apeldoorn 30 42 66 26
15 WHC WHC 30 44 68 25
16 SVZW SVZW 30 39 75 18
Ver
TEMPORADA 2017/2018
Equipo PJ GF GC Puntos
1 Eemdijk Eemdijk 30 63 33 58
2 Berkum Berkum 30 52 36 56
3 Genemuiden Genemuiden 30 74 45 54
4 Ajax Amateurs Ajax 30 69 45 54
5 Staphorst Staphorst 30 55 44 46
6 Urk Urk 30 47 44 43
7 AZSV AZSV 30 38 39 42
8 Door Fusie Sterk Door Fusie. 30 47 43 41
9 Excelsior .31 Excelsior 30 40 45 41
10 SDC Putten SDC Putten 30 40 50 41
11 Sparta Nijkerk Sparta 30 47 37 40
12 Apeldoorn CSV Apeldoorn 30 51 61 36
13 HZVV HZVV 30 37 54 32
14 Huizen Huizen 30 47 65 26
15 Zuidvogels Zuidvogels 30 40 70 26
16 NSC NSC 30 46 82 26
Ver
TEMPORADA 2016/2017
Equipo PJ GF GC Puntos
1 ACV Assen ACV Assen 30 58 35 65
2 DOVO DOVO 30 62 31 60
3 Staphorst Staphorst 30 68 34 53
4 Apeldoorn CSV Apeldoorn 30 61 48 51
5 Excelsior .31 Excelsior 30 67 56 46
6 Genemuiden Genemuiden 30 60 42 45
7 Sparta Nijkerk Sparta 30 53 48 45
8 SDC Putten SDC Putten 30 43 39 45
9 Eemdijk Eemdijk 30 58 61 42
10 AZSV AZSV 30 41 37 38
11 Urk Urk 30 41 42 38
12 NSC NSC 30 47 56 37
13 Flevo Boys Flevo Boys 30 47 56 35
14 Oranje Nassau Oranje 30 42 69 32
15 SDV Barneveld Barneveld 30 33 57 25
16 ASV Dronten ASV Dronten 30 27 97 11
Ver
TEMPORADA 2015/2016
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
Ver
TEMPORADA 2014/2015
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
Ver
TEMPORADA 2013/2014
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
Ver
TEMPORADA 2012/2013
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
Ver
TEMPORADA 2011/2012
Equipo PJ GF GC Puntos
1 Scheveningen Scheveningen 26 59 30 60
2 Kozakken Boys Kozakken 26 64 33 59
3 ASWH ASWH 26 83 35 58
4 RVVH RVVH 26 53 37 51
5 Excelsior Maassluis Excelsior 26 47 33 46
6 Hoek Hoek 26 39 30 46
7 Xerxes Xerxes 26 74 38 45
8 Kloetinge Kloetinge 26 36 54 31
9 Zwaluwen Zwaluwen 26 56 56 30
10 Nivo Sparta Nivo Sparta 26 40 67 24
11 Achilles Veen Achilles 26 42 61 23
12 Nieuw Lekkerland Nieuw 26 34 56 23
13 LRC LRC 26 23 79 16
14 Heerjansdam Heerjansdam 26 38 79 9
Ver
TEMPORADA 2010/2011
Equipo PJ GF GC Puntos
1 GVVV GVVV 26 77 31 62
2 Xerxes DZB Xerxes DZB 26 70 49 51
3 Montfoort Montfoort 26 40 33 42
4 ASWH ASWH 26 53 32 41
5 Zwaluwen Zwaluwen 26 47 36 38
6 Kozakken Boys Kozakken 26 48 36 36
7 RVVH RVVH 26 36 41 35
8 Heerjansdam Heerjansdam 26 39 48 35
9 Kloetinge Kloetinge 26 31 39 34
10 Nieuw Lekkerland Nieuw 26 36 48 30
11 LRC LRC 26 41 50 29
12 NSC NSC 26 36 56 26
13 Rijsoord Rijsoord 26 37 59 24
14 DTS Ede DTS Ede 26 24 57 17
Ver
TEMPORADA 2009/2010
Equipo PJ GF GC Puntos
1 IJsselmeervogels IJsselmeervo 26 64 18 60
2 Sparta Nijkerk Sparta 26 69 35 58
3 Spakenburg Spakenburg 26 62 36 50
4 Hoek Hoek 26 38 29 45
5 Zwaluwen .30 Zwaluwen 26 50 49 38
6 GVVV GVVV 26 46 43 37
7 SDC Putten SDC Putten 26 43 45 35
8 Kozakken Boys Kozakken 26 46 47 33
9 ODIN '59 ODIN '59 26 46 51 31
10 Jodan Boys Jodan Boys 26 40 54 31
11 LRC LRC 26 43 51 30
12 RKAV Volendam RKAV 26 45 60 26
13 DOVO DOVO 26 33 66 20
14 Bennekom Bennekom 26 32 73 13
Ver
TEMPORADA 2008/2009
Equipo PJ GF GC Puntos
1 IJsselmeervogels IJsselmeervo 26 59 22 54
2 Hoek Hoek 26 47 31 44
3 Spakenburg Spakenburg 26 52 39 42
4 GVVV GVVV 26 45 37 41
5 Bennekom Bennekom 26 37 34 41
6 SDC Putten SDC Putten 26 36 40 38
7 Sparta Nijkerk Sparta 26 40 44 37
8 RKAV Volendam RKAV 26 44 40 36
9 Jodan Boys Jodan Boys 26 47 36 34
10 Zwaluwen .30 Zwaluwen 26 45 43 33
11 Kozakken Boys Kozakken 26 39 40 31
12 DOVO DOVO 26 33 48 31
13 Ajax Amateurs Ajax 26 22 46 22
14 SV Geinoord SV Geinoord 26 35 81 15
Ver
TEMPORADA 2007/2008
Equipo PJ GF GC Puntos
1 Spakenburg Spakenburg 26 73 25 56
2 Sparta Nijkerk Sparta 26 44 16 53
3 GVVV GVVV 25 49 24 47
4 Kozakken Boys Kozakken 26 44 35 44
5 Hoek Hoek 26 35 28 40
6 IJsselmeervogels IJsselmeervo 26 50 48 40
7 DOVO DOVO 26 36 36 38
8 SV Geinoord SV Geinoord 26 28 36 35
9 Bennekom Bennekom 26 33 50 32
10 Ajax Amateurs Ajax 26 29 44 29
11 LRC LRC 26 33 43 26
12 Nunspeet Nunspeet 26 30 44 23
13 Nivo Sparta Nivo Sparta 26 27 51 18
14 Kloetinge Kloetinge 25 14 45 15
Ver
TEMPORADA 2006/2007
Equipo PJ GF GC Puntos
1 IJsselmeervogels IJsselmeervo 26 65 29 59
2 Sparta Nijkerk Sparta 25 59 34 49
3 Quick Boys Quick Boys 25 56 32 48
4 Nunspeet Nunspeet 26 49 37 44
5 Spakenburg Spakenburg 26 47 35 42
6 GVVV GVVV 26 48 35 40
7 Hoek Hoek 26 57 48 39
8 Ajax Amateurs Ajax 26 34 41 31
9 Bennekom Bennekom 26 43 51 30
10 Kloetinge Kloetinge 26 29 42 29
11 SV Geinoord SV Geinoord 26 31 49 29
12 Huizen Huizen 26 26 41 23
13 VVOG VVOG 26 27 50 23
14 GOES GOES 26 21 68 5
Ver
TEMPORADA 2005/2006
Equipo PJ GF GC Puntos
1 IJsselmeervogels IJsselmeervo 26 58 25 57
2 ASWH ASWH 26 45 23 45
3 Sparta Nijkerk Sparta 26 48 37 44
4 GVVV GVVV 26 41 35 43
5 Spakenburg Spakenburg 26 51 42 42
6 Bennekom Bennekom 26 48 41 41
7 VVOG VVOG 26 42 38 37
8 SHO SHO 26 43 54 34
9 Kozakken Boys Kozakken 26 37 38 32
10 SV Geinoord SV Geinoord 25 40 43 32
11 Heerjansdam Heerjansdam 26 32 52 32
12 DOVO DOVO 26 39 46 28
13 Deltasport Deltasport 26 34 57 27
14 SDC Putten SDC Putten 25 27 54 14
Ver
TEMPORADA 2004/2005
Equipo PJ GF GC Puntos
1 IJsselmeervogels IJsselmeervo 26 46 31 52
2 Capelle Capelle 26 45 35 48
3 Quick Boys Quick Boys 26 60 45 47
4 Rijnsburgse Boys Rijnsburgse 26 53 36 42
5 Spakenburg Spakenburg 26 52 42 40
6 SHO SHO 26 39 36 37
7 Sparta Nijkerk Sparta 26 40 41 37
8 Scheveningen Scheveningen 26 41 42 36
9 Excelsior Maassluis Excelsior 26 42 45 32
10 Deltasport Deltasport 26 38 33 31
11 Katwijk Katwijk 26 39 46 31
12 TOGR TOGR 26 34 55 25
13 Huizen Huizen 26 37 48 24
14 Voorschoten .97 Voorschoten 26 25 56 15

  USO DE MEMORIA  
6,664,256 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0018
Controller Execution Time ( Home / Category )  0.5373
Total Execution Time  0.5392
  CADENA URL  
/hoofdklasse_zaterdag_liga_holanda2020/grupo2/historico
  GET DATOS  
$_GET['/hoofdklasse_zaterdag_liga_holanda2020/grupo2/historico']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (33)  
0.0125  SELECT type FROM routes WHERE alias = 'hoofdklasse_zaterdag_liga_holanda2020'
0.0253  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'hoofdklasse_zaterdag_liga_holanda' AND (l.group_code = 2 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 2020 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=2 DESC LIMIT 1
0.0125  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=226 AND type_rel = 3
0.0127  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.0129  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.0125  SELECT id,name,alias,stepParent FROM categories WHERE parentId=226 ORDER BY order_id ASC
0.0126  SELECT dt.nameShow,dt.basealias,t.id,t.teamId FROM teams t INNER JOIN datateams dt ON t.teamId = dt.id WHERE t.league_id = 50987 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0126  SELECT id,year,current_round,total_teams,legend FROM leagues WHERE categoryId = 226 AND group_code = 2 and tables = 1 AND year <= 2020 AND total_num_tablesR >= 1 ORDER BY year DESC LIMIT 22
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 = 44705 AND t.round = 30 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 `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 = 39747 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 `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 = 33959 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 `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.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 `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.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 `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.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 = 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.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 `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 = 1714 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 `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 = 20375 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 `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 = 20379 AND t.round = 26 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 `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 = 20382 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 `tables2008` 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 = 20387 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 `tables2007` 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 = 20390 AND t.round = 26 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 `tables2006` 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 = 20393 AND t.round = 26 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 `tables2005` 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 = 20396 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0125  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-05-07 21:40:54' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0125  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=2 AND last_update > '2024-05-07 21:40:54' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0125  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=4 AND last_update > '2024-05-07 21:40:54' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0125  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=3 AND last_update > '2024-05-07 21:40:54' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0130  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'hoofdklasse_zaterdag_liga_holanda' AND (l.group_code = 0 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 2020 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=0 DESC LIMIT 1
0.0127  SELECT e.action, count(e.action) as total,p.name, p.last_name, p.nick,p.CountryCode,p.alias,rp.team_id,dt.nameShow,dt.short_name,dt.basealias,rp.player_id,rp.teamId FROM `rel_players` rp INNER JOIN dataplayers p ON p.id = rp.player_id INNER JOIN events2020 e ON e.player_id = p.id AND e.league_id = 50987 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 50987 AND (e.action = 1 or e.action = 2 or e.action = 11 or e.action = 12 or e.action = 13) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0127  SELECT e.action, count(e.action) as total,p.name, p.last_name, p.nick,p.CountryCode,p.alias,rp.team_id,dt.nameShow,dt.short_name,dt.basealias,rp.player_id,rp.teamId FROM `rel_players` rp INNER JOIN dataplayers p ON p.id = rp.player_id INNER JOIN events2020 e ON e.player_id = p.id AND e.league_id = 50987 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 50987 AND (e.action = 4 or e.action = 5) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0126  SELECT e.action, count(e.action) as total,p.name, p.last_name, p.nick,p.CountryCode,p.alias,rp.team_id,dt.nameShow,dt.short_name,dt.basealias,rp.player_id,rp.teamId FROM `rel_players` rp INNER JOIN dataplayers p ON p.id = rp.player_id INNER JOIN events2020 e ON e.player_id = p.id AND e.league_id = 50987 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 50987 AND (e.action = 3 or e.action = 4) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0136  SELECT *,(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