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 Groningen Sub 19 Groningen 13 33 12 29
2 PSV Sub 19 PSV Sub 19 13 28 14 27
3 Utrecht Sub 19 Utrecht 13 24 13 23
4 Ajax Sub 19 Ajax Sub 19 13 29 22 23
5 AZ Alkmaar Sub 19 Alkmaar 13 34 20 22
6 Heerenveen Sub 19 Heerenveen 13 22 28 18
7 Twente Sub 19 Twente 13 24 28 17
8 Feyenoord Sub 19 Feyenoord 13 23 28 17
9 NAC Breda Sub 19 Breda 13 24 25 16
10 NEC OSS Sub 19 13 16 17 16
11 ADO Den Haag Sub 19 Haag 13 18 23 14
12 Vitesse Sub 19 Vitesse 13 17 32 14
13 Sparta Rotterdam Sub 19 Sparta 13 18 28 11
14 Almere City Sub 19 Almere City 13 18 38 8
Ver
TEMPORADA 2018/2019
Equipo PJ GF GC Puntos
1 Ajax Sub 19 Ajax Sub 19 13 38 18 29
2 Sparta Rotterdam Sub 19 Sparta 13 29 21 25
3 Feyenoord Sub 19 Feyenoord 13 35 19 24
4 PSV Sub 19 PSV Sub 19 13 29 14 23
5 Vitesse Sub 19 Vitesse 13 26 23 23
6 NEC OSS Sub 19 13 26 27 21
7 AZ Alkmaar Sub 19 Alkmaar 13 17 12 20
8 NAC Breda Sub 19 Breda 13 24 22 19
9 ADO Den Haag Sub 19 Haag 13 30 32 18
10 Groningen Sub 19 Groningen 13 24 20 17
11 Utrecht Sub 19 Utrecht 13 15 21 15
12 Heerenveen Sub 19 Heerenveen 13 10 26 9
13 Volendam Sub 19 Volendam 13 11 34 5
14 Willem II Sub 19 Willem 13 7 32 5
Ver
TEMPORADA 2017/2018
Equipo PJ GF GC Puntos
1 Ajax Sub 19 Ajax Sub 19 13 49 14 35
2 PSV Sub 19 PSV Sub 19 13 38 12 25
3 Feyenoord Sub 19 Feyenoord 13 24 16 25
4 NEC OSS Sub 19 12 24 17 22
5 ADO Den Haag Sub 19 Haag 13 28 20 21
6 AZ Alkmaar Sub 19 Alkmaar 13 23 16 21
7 Utrecht Sub 19 Utrecht 12 19 17 21
8 Vitesse Sub 19 Vitesse 13 25 26 21
9 Heerenveen Sub 19 Heerenveen 13 21 33 18
10 Sparta Rotterdam Sub 19 Sparta 13 19 25 15
11 Groningen Sub 19 Groningen 13 12 31 12
12 Volendam Sub 19 Volendam 13 14 37 12
13 Willem II Sub 19 Willem 13 15 31 8
14 De Graafschap Sub 19 Graafschap 13 14 30 6
Ver
TEMPORADA 2016/2017
Equipo PJ GF GC Puntos
1 Ajax Sub 19 Ajax Sub 19 13 43 8 35
2 PSV Sub 19 PSV Sub 19 13 25 16 22
3 Willem II Sub 19 Willem 13 25 19 22
4 Sparta Rotterdam Sub 19 Sparta 13 26 21 22
5 NEC OSS Sub 19 13 13 10 22
6 Feyenoord Sub 19 Feyenoord 13 27 14 21
7 Utrecht Sub 19 Utrecht 13 21 21 21
8 AZ Alkmaar Sub 19 Alkmaar 13 25 18 20
9 Heerenveen Sub 19 Heerenveen 13 21 25 15
10 Vitesse Sub 19 Vitesse 13 17 26 14
11 Volendam Sub 19 Volendam 13 17 26 14
12 PEC Zwolle Sub 19 Zwolle 13 18 29 13
13 ADO Den Haag Sub 19 Haag 13 13 27 13
14 Roda JC Sub 19 Roda 13 14 45 3
Ver
TEMPORADA 2015/2016
Equipo PJ GF GC Puntos
1 Ajax Sub 19 Ajax Sub 19 13 44 13 33
2 Feyenoord Sub 19 Feyenoord 13 29 17 29
3 Utrecht Sub 19 Utrecht 13 28 17 25
4 PSV Sub 19 PSV Sub 19 13 28 15 23
5 Vitesse Sub 19 Vitesse 13 31 23 22
6 NEC OSS Sub 19 13 24 20 21
7 AZ Alkmaar Sub 19 Alkmaar 13 26 23 20
8 Willem II Sub 19 Willem 13 20 29 17
9 ADO Den Haag Sub 19 Haag 13 20 16 16
10 Groningen Sub 19 Groningen 13 17 29 15
11 Twente Sub 19 Twente 13 20 31 11
12 PEC Zwolle Sub 19 Zwolle 13 14 31 10
13 Volendam Sub 19 Volendam 13 19 35 8
14 Heerenveen Sub 19 Heerenveen 13 9 30 7
Ver
TEMPORADA 2014/2015
Equipo PJ GF GC Puntos
1 Ajax Sub 19 Ajax Sub 19 13 36 21 29
2 Twente Sub 19 Twente 13 31 18 26
3 AZ Alkmaar Sub 19 Alkmaar 13 35 19 25
4 Heerenveen Sub 19 Heerenveen 13 28 19 23
5 PSV Sub 19 PSV Sub 19 13 27 19 21
6 NEC OSS Sub 19 13 25 20 21
7 ADO Den Haag Sub 19 Haag 13 23 19 21
8 Feyenoord Sub 19 Feyenoord 13 25 22 21
9 Utrecht Sub 19 Utrecht 13 21 32 16
10 Groningen Sub 19 Groningen 13 21 22 15
11 Brabant United Sub 19 Brabant 13 23 32 15
12 Roda JC Sub 19 Roda 13 12 25 11
13 Vitesse Sub 19 Vitesse 13 22 38 10
14 Sparta Rotterdam Sub 19 Sparta 13 15 38 5
Ver
TEMPORADA 2013/2014
Equipo PJ GF GC Puntos
1 Ajax Sub 19 Ajax Sub 19 26 72 21 57
2 PSV Sub 19 PSV Sub 19 26 64 25 57
3 Utrecht Sub 19 Utrecht 26 66 41 52
4 AZ Alkmaar Sub 19 Alkmaar 26 42 27 48
5 Feyenoord Sub 19 Feyenoord 26 55 30 47
6 Heerenveen Sub 19 Heerenveen 26 65 48 44
7 Groningen Sub 19 Groningen 26 36 41 39
8 Twente Sub 19 Twente 26 41 43 36
9 Sparta Rotterdam Sub 19 Sparta 26 49 47 34
10 ADO Den Haag Sub 19 Haag 26 41 52 31
11 Vitesse Sub 19 Vitesse 26 44 60 27
12 Roda JC Sub 19 Roda 26 24 71 19
13 Willem II Sub 19 Willem 26 23 61 18
14 De Graafschap Sub 19 Graafschap 26 20 75 7
Ver
TEMPORADA 2012/2013
Equipo PJ GF GC Puntos
1 Feyenoord Sub 19 Feyenoord 26 60 31 55
2 PSV Sub 19 PSV Sub 19 26 51 24 53
3 Groningen Sub 19 Groningen 26 57 31 51
4 Vitesse / AGOVV Sub 19 Vitesse 26 52 41 46
5 Utrecht Sub 19 Utrecht 26 46 36 44
6 Heerenveen Sub 19 Heerenveen 26 49 35 42
7 Twente Sub 19 Twente 26 51 39 36
8 Ajax Sub 19 Ajax Sub 19 26 37 45 34
9 AZ Alkmaar Sub 19 Alkmaar 26 38 34 33
10 ADO Den Haag Sub 19 Haag 26 34 50 29
11 Sparta Rotterdam Sub 19 Sparta 26 33 36 27
12 Willem II Sub 19 Willem 26 36 60 22
13 De Graafschap Sub 19 Graafschap 26 26 71 16
14 NAC Breda Sub 19 Breda 26 33 70 13

  USO DE MEMORIA  
5,749,408 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0020
Controller Execution Time ( Home / Category )  0.4625
Total Execution Time  0.4645
  CADENA URL  
/liga_holandesa_sub_192020/grupo1/historico
  GET DATOS  
$_GET['/liga_holandesa_sub_192020/grupo1/historico']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (25)  
0.0128  SELECT type FROM routes WHERE alias = 'liga_holandesa_sub_192020'
0.0261  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'liga_holandesa_sub_19' AND (l.group_code = 1 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=1 DESC LIMIT 1
0.0131  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=1631 AND type_rel = 3
0.0139  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 3 AND rel.typeId = 1631 AND rel.ln = 'es' AND rel.status=1 ORDER BY rel.creation_date desc,rel.cover_points DESC LIMIT 5
0.0142  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 (1248875,949316,887373,812288,640972) ORDER BY n.cover_points DESC, update_date DESC
0.0130  SELECT id,name,alias,stepParent FROM categories WHERE parentId=1631 ORDER BY order_id ASC
0.0138  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 = 51570 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0137  SELECT id,year,current_round,total_teams,legend FROM leagues WHERE categoryId = 1631 AND group_code = 1 and tables = 1 AND year <= 2020 AND total_num_tablesR >= 1 ORDER BY year DESC LIMIT 22
0.0150  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 = 51570 AND t.round = 13 ORDER BY team.conference ASC,t.position 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 `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 = 48439 AND t.round = 13 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 = 43413 AND t.round = 13 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 `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 = 37196 AND t.round = 13 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 `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 = 16021 AND t.round = 13 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 = 44153 AND t.round = 13 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 `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 = 25167 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0136  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 = 25168 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 url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-05-05 02:50:38' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0130  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=2 AND last_update > '2024-05-05 02:50:38' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0129  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=4 AND last_update > '2024-05-05 02:50:38' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0130  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=3 AND last_update > '2024-05-05 02:50:38' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0145  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'liga_holandesa_sub_19' 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.0247  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 = 51570 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 51570 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.0180  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 = 51570 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 51570 AND (e.action = 4 or e.action = 5) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0133  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 = 51570 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 51570 AND (e.action = 3 or e.action = 4) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0137  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 = 51570 AND t.round = 13 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC