4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Ver
TEMPORADA 2015/2016
Equipo PJ GF GC Puntos
1 Feyenoord Sub 21 Feyenoord 14 41 19 35
2 ADO Den Haag Sub 21 Haag 14 31 20 27
3 Heerenveen Sub 21 Heerenveen 14 31 16 25
4 Heracles Sub 21 Heracles 14 39 30 22
5 Cambuur Sub 21 Cambuur 14 30 23 22
6 PEC Zwolle Sub 21 Zwolle 14 21 39 13
7 Willem II Sub 21 Willem 14 15 34 8
8 VVV-Venlo Sub 21 VVV-Venlo 14 11 38 5
9 Excelsior Sub 21 Excelsior 12 29 10 28
10 NAC Breda Sub 21 Breda 12 25 20 19
11 Go Ahead Eagles Sub 21 Ahead Eagles 12 19 17 17
12 Roda JC Sub 21 Roda 12 21 22 17
13 NEC Nijmegen Sub 21 Nijmegen 12 19 18 14
14 Fortuna Sittard Sub 21 Fortuna 12 17 33 12
15 Dordrecht Sub 21 Dordrecht 12 16 26 11
16 Utrecht Sub 23 Utrecht 20 43 24 40
17 Vitesse Sub 23 Vitesse 20 55 37 38
18 Jong AZ Jong AZ 20 41 21 36
19 Jong Sparta Jong Sparta 20 45 38 36
20 Groningen Sub 21 Groningen 20 42 30 33
21 Twente Sub 21 Twente 20 31 29 31
22 Jong Almere City Jong Almere 20 49 47 27
23 Jong Volendam Jong 20 43 31 26
24 De Graafschap Sub 21 Graafschap 20 32 44 22
25 Brabant United Sub 23 Brabant 20 25 50 15
26 Achilles '29 Sub 21 Achilles 20 17 72 7
Ver
TEMPORADA 2014/2015
Equipo PJ GF GC Puntos
1 Vitesse Sub 23 Vitesse 10 31 13 28
2 Jong AZ Jong AZ 10 26 21 18
3 Utrecht Sub 23 Utrecht 10 23 23 14
4 Heracles Sub 21 Heracles 10 22 20 13
5 Go Ahead Eagles Sub 21 Ahead Eagles 10 17 21 11
6 Fortuna Sittard Sub 21 Fortuna 10 17 38 3
7 Heerenveen Sub 21 Heerenveen 8 16 8 16
8 Jong Almere City Jong Almere 8 10 10 14
9 Groningen Sub 21 Groningen 8 19 15 12
10 PEC Zwolle Sub 21 Zwolle 8 12 19 9
11 NEC Nijmegen Sub 21 Nijmegen 8 10 15 7
12 Feyenoord Sub 21 Feyenoord 8 27 7 21
13 VVV-Venlo Sub 21 VVV-Venlo 8 12 16 12
14 ADO Den Haag Sub 21 Haag 8 8 8 10
15 Dordrecht Sub 21 Dordrecht 8 11 17 9
16 NAC Breda Sub 21 Breda 8 8 18 7
17 Jong Sparta Jong Sparta 10 23 22 21
18 Willem II Sub 21 Willem 10 23 11 20
19 Jong Volendam Jong 10 18 13 14
20 De Graafschap Sub 21 Graafschap 10 19 24 12
21 Roda JC Sub 21 Roda 10 13 18 12
22 Brabant United Sub 23 Brabant 10 12 20 9
Ver
TEMPORADA 2013/2014
Equipo PJ GF GC Puntos
1 Vitesse Sub 23 Vitesse 20 54 37 39
2 Groningen Sub 21 Groningen 20 43 30 39
3 Heracles Sub 21 Heracles 20 43 35 35
4 Heerenveen Sub 21 Heerenveen 20 60 36 34
5 ADO Den Haag Sub 21 Haag 20 45 34 29
6 NEC Nijmegen Sub 21 Nijmegen 20 37 31 28
7 VVV-Venlo Sub 21 VVV-Venlo 20 36 42 28
8 PEC Zwolle Sub 21 Zwolle 20 41 50 28
9 Fortuna Sittard Sub 21 Fortuna 20 34 51 19
10 Jong Volendam Jong 20 30 47 15
11 Dordrecht Sub 21 Dordrecht 20 32 62 14
12 Feyenoord Sub 21 Feyenoord 20 50 17 44
13 Willem II Sub 21 Willem 20 34 18 39
14 RKC Waalwijk Sub 21 Waalwijk 20 30 34 34
15 De Graafschap Sub 21 Graafschap 20 40 42 31
16 Jong AZ Jong AZ 20 47 34 30
17 Jong Sparta Jong Sparta 20 35 32 29
18 Roda JC Sub 21 Roda 20 27 31 27
19 Utrecht Sub 23 Utrecht 20 29 28 20
20 NAC Breda Sub 21 Breda 20 32 43 20
21 Jong Almere City Jong Almere 20 37 50 17
22 Den Bosch Sub 21 Bosch 20 26 58 13
Ver
TEMPORADA 2012/2013
Equipo PJ GF GC Puntos
1 Heerenveen Sub 21 Heerenveen 7 23 6 17
2 Jong Ajax Jong Ajax 7 20 7 14
3 Groningen Sub 21 Groningen 7 13 5 14
4 NEC Nijmegen Sub 21 Nijmegen 7 15 14 12
5 Jong AZ Jong AZ 7 14 16 6
6 PEC Zwolle Sub 21 Zwolle 7 9 18 6
7 De Graafschap Sub 21 Graafschap 7 9 21 6
8 Jong Volendam Jong 7 7 23 6
9 Feyenoord Sub 21 Feyenoord 7 18 8 16
10 Utrecht Sub 23 Utrecht 7 21 12 13
11 NAC Breda Sub 21 Breda 7 11 12 12
12 RKC Waalwijk Sub 21 Waalwijk 7 9 7 11
13 ADO Den Haag Sub 21 Haag 7 14 15 10
14 Jong Sparta Jong Sparta 7 9 12 8
15 Willem II Sub 21 Willem 7 11 9 7
16 Dordrecht Sub 21 Dordrecht 7 4 22 2
17 PSV Sub 21 PSV Sub 21 7 23 9 15
18 Vitesse Sub 23 Vitesse 7 23 12 15
19 Heracles Sub 21 Heracles 7 17 11 13
20 Twente Sub 21 Twente 7 13 11 10
21 Fortuna Sittard Sub 21 Fortuna 7 13 21 8
22 Roda JC Sub 21 Roda 7 10 19 8
23 Den Bosch Sub 21 Bosch 7 5 14 6
24 VVV-Venlo Sub 21 VVV-Venlo 7 5 12 3
Ver
TEMPORADA 2011/2012
Equipo PJ GF GC Puntos
1 Twente Sub 21 Twente 26 74 36 58
2 Jong Ajax Jong Ajax 26 76 30 48
3 PSV Sub 21 PSV Sub 21 26 66 42 47
4 Heracles Sub 21 Heracles 26 60 45 47
5 Groningen Sub 21 Groningen 26 58 48 44
6 Jong AZ Jong AZ 26 46 41 44
7 Heerenveen Sub 21 Heerenveen 26 57 39 42
8 Feyenoord Sub 21 Feyenoord 26 53 49 40
9 Vitesse Sub 23 Vitesse 26 51 68 33
10 Utrecht Sub 23 Utrecht 26 42 49 28
11 De Graafschap Sub 21 Graafschap 26 35 59 28
12 Jong Sparta Jong Sparta 26 38 71 24
13 ADO Den Haag Sub 21 Haag 26 32 75 21
14 NEC Nijmegen Sub 21 Nijmegen 26 42 78 19

  USO DE MEMORIA  
6,146,016 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0033
Controller Execution Time ( Home / Category )  1.1233
Total Execution Time  1.1267
  CADENA URL  
/liga_holandesa_sub_232016/grupo1/historico
  GET DATOS  
$_GET['/liga_holandesa_sub_232016/grupo1/historico']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (22)  
0.0018  SELECT type FROM routes WHERE alias = 'liga_holandesa_sub_232016'
0.0040  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_23' AND (l.group_code = 1 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 2016 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=1 DESC LIMIT 1
0.0019  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=1626 AND type_rel = 3
0.0020  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 3 AND rel.typeId = 1626 AND rel.ln = 'es' AND rel.status=1 ORDER BY rel.creation_date desc,rel.cover_points DESC LIMIT 5
0.0019  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 (657856) ORDER BY n.cover_points DESC, update_date DESC
0.0018  SELECT id,name,alias,stepParent FROM categories WHERE parentId=1626 ORDER BY order_id ASC
0.0020  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 = 16023 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0020  SELECT id,year,current_round,total_teams,legend FROM leagues WHERE categoryId = 1626 AND group_code = 1 and tables = 1 AND year <= 2016 AND total_num_tablesR >= 1 ORDER BY year DESC LIMIT 22
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 `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 = 16023 AND t.round = 22 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 `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 = 49665 AND t.round = 10 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0032  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 = 49668 AND t.round = 22 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 = 49669 AND t.round = 7 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 `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 = 49671 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0018  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-04-28 08:14:11' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0018  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=2 AND last_update > '2024-04-28 08:14:11' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0018  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=4 AND last_update > '2024-04-28 08:14:11' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0018  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=3 AND last_update > '2024-04-28 08:14:11' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0022  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_23' AND (l.group_code = 0 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 2016 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=0 DESC LIMIT 1
0.0230  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 events2016 e ON e.player_id = p.id AND e.league_id = 16023 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 16023 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.0082  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 events2016 e ON e.player_id = p.id AND e.league_id = 16023 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 16023 AND (e.action = 4 or e.action = 5) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0027  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 events2016 e ON e.player_id = p.id AND e.league_id = 16023 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 16023 AND (e.action = 3 or e.action = 4) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0056  SELECT *,(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 = 16023 AND t.round = 22 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC