4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del Den Bosch Sub 21
TEMPORADA 2022/2023
SEGUNDA PAÍSES BAJOS SUB 21 GRUPO 1
Equipo PJ GF GC Puntos
1 Twente / Heracles Sub 21 Twente 14 32 8 35
2 NAC Breda Sub 21 Breda 14 31 24 26
3 NEC Nijmegen Sub 21 Nijmegen 14 26 24 20
4 Vitesse Sub 21 Vitesse 14 20 19 20
5 Go Ahead Eagles Sub 21 Ahead Eagles 14 19 27 16
6 Roda JC Sub 21 Roda 14 23 29 14
7 VVV-Venlo Sub 21 VVV-Venlo 14 19 31 13
8 Den Bosch Sub 21 Bosch 14 15 23 12
TEMPORADA 2021/2022
LIGA PAÍSES BAJOS SUB 21 GRUPO 4
Equipo PJ GF GC Puntos
1 FC Emmen Sub 21 Emmen 7 18 10 16
2 De Graafschap Sub 21 Graafschap 7 14 6 16
3 Go Ahead Eagles Sub 21 Ahead Eagles 7 8 6 13
4 Vitesse Sub 21 Vitesse 7 15 8 10
5 Twente / Heracles Sub 21 Twente 7 13 11 10
6 Den Bosch Sub 21 Bosch 7 12 16 7
7 Excelsior Sub 21 Excelsior 7 7 18 6
8 Heerenveen Sub 21 Heerenveen 7 8 20 3
TEMPORADA 2019/2020
BELOFTEN EREDIVISIE GRUPO 1
Equipo PJ GF GC Puntos
1 Go Ahead Eagles Sub 21 Ahead Eagles 5 8 5 9
2 Feyenoord Sub 21 Feyenoord 4 9 4 8
3 Vitesse Sub 21 Vitesse 3 10 4 7
4 Heerenveen Sub 21 Heerenveen 4 14 10 7
5 Groningen Sub 21 Groningen 4 8 7 7
6 PEC Zwolle Sub 21 Zwolle 4 9 7 6
7 FC Emmen Sub 21 Emmen 5 8 9 5
8 Cambuur Sub 21 Cambuur 4 7 13 3
9 De Graafschap Sub 21 Graafschap 3 3 10 3
10 Heracles Sub 21 Heracles 3 2 4 1
11 Twente Sub 21 Twente 3 1 6 1
12 RKC Waalwijk Sub 21 Waalwijk 4 17 2 12
13 NAC Breda Sub 21 Breda 3 4 0 9
14 NEC Nijmegen Sub 21 Nijmegen 4 10 7 7
15 VVV-Venlo Sub 21 VVV-Venlo 4 11 7 6
16 Willem II Sub 21 Willem 3 5 5 6
17 Roda JC Sub 21 Roda 4 6 6 4
18 Den Bosch Sub 21 Bosch 4 6 9 4
19 Dordrecht Sub 21 Dordrecht 4 7 8 3
20 Fortuna Sittard Sub 21 Fortuna 3 5 6 3
21 FC Eindhoven Sub 21 Eindhoven 4 3 12 3
22 Excelsior Sub 21 Excelsior 3 2 14 0
TEMPORADA 2013/2014
BELOFTEN EREDIVISIE
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
TEMPORADA 2012/2013
BELOFTEN EREDIVISIE GRUPO 2
Equipo PJ GF GC Puntos
1 Jong AZ Jong AZ 22 75 31 52
2 Jong Volendam Jong 22 53 50 39
3 Jong Sparta Jong Sparta 22 47 30 37
4 VVV-Venlo Sub 21 VVV-Venlo 22 41 33 34
5 De Graafschap Sub 21 Graafschap 22 43 48 33
6 PEC Zwolle Sub 21 Zwolle 22 42 34 32
7 Roda JC Sub 21 Roda 22 36 38 31
8 ADO Den Haag Sub 21 Haag 22 41 38 28
9 Willem II Sub 21 Willem 22 27 38 27
10 Fortuna Sittard Sub 21 Fortuna 22 39 48 23
11 Den Bosch Sub 21 Bosch 22 31 46 23
12 PSV Sub 21 PSV Sub 21 13 28 26 20
13 Dordrecht Sub 21 Dordrecht 22 27 68 14
14 Groningen Sub 21 Groningen 2 2 0 4
15 Heerenveen Sub 21 Heerenveen 2 7 6 4
16 Feyenoord Sub 21 Feyenoord 2 7 5 3
17 Twente Sub 21 Twente 1 6 4 3
18 Heracles Sub 21 Heracles 1 1 0 3
19 Jong Ajax Jong Ajax 2 1 2 3
20 Utrecht Sub 21 Utrecht 1 3 4 0
21 Vitesse Sub 21 Vitesse 1 1 2 0
22 NAC Breda Sub 21 Breda 1 0 3 0
23 NEC Nijmegen Sub 21 Nijmegen 2 0 4 0
TEMPORADA 2011/2012
BELOFTEN EREDIVISIE GRUPO 2
Equipo PJ GF GC Puntos
1 NAC Breda Sub 21 Breda 21 49 28 37
2 Den Bosch Sub 21 Bosch 18 37 22 34
3 Willem II Sub 21 Willem 19 29 23 34
4 Jong Volendam Jong 25 39 48 26
5 VVV-Venlo Sub 21 VVV-Venlo 17 27 38 21
6 Dordrecht Sub 21 Dordrecht 18 22 44 12

  USO DE MEMORIA  
5,233,272 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0017
Controller Execution Time ( Home / Category )  0.3634
Total Execution Time  0.3651
  CADENA URL  
/historico/Fc-Den-Bosch-Sub-21
  GET DATOS  
$_GET['/historico/Fc-Den-Bosch-Sub-21']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (25)  
0.0212  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 = 68772
0.0105  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=120946 AND type_rel = 2
0.0105  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=2673 AND type_rel = 3
0.0107  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 = '120946' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0107  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 = '120946' AND ct.ctype=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0106  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 = 68772 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0107  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=120946 AND l.year in (2022,2023,2024) ORDER BY l.id DESC, l.year DESC ;
0.0107  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 (68772,67133) 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.0109  SELECT count(id) as num_players from rel_players WHERE league_id = 67133 AND teamId = 120946
0.0106  SELECT count(id) as num_players from rel_players WHERE league_id = 68772 AND teamId = 120946
0.0108  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff 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 = 68772 AND t.round = 14 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0107  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 = '120946' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0105  SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '120946' and rp.type = 4
0.0107  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 = '120946' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0112  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 events2023 e ON e.player_id = p.id AND e.league_id = 68772 WHERE rp.league_id = 68772 AND rp.teamId = 120946 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.0110  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 events2023 e ON e.player_id = p.id AND e.league_id = 68772 WHERE rp.league_id = 68772 AND rp.teamId = 120946 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0107  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 events2023 e ON e.player_id = p.id AND e.league_id = 68772 WHERE rp.league_id = 68772 AND rp.teamId = 120946 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0108  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 = 120946 AND l.year <= 2023 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.0108  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 = 68772 AND t.round = 14 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0108  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 = 67133 AND t.round = 7 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0109  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 = 51476 AND t.round = 11 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0112  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.0112  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.0115  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 = 49670 AND t.round = 22 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0108  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 = 49672 AND t.round = 25 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC