4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del Twente Sub 21
TEMPORADA 2021/2022
BELOFTEN EREDIVISIE GRUPO 1
Equipo PJ GF GC Puntos
1 Heracles Sub 21 Heracles 4 5 3 9
2 FC Emmen Sub 21 Emmen 4 9 3 7
3 Twente Sub 21 Twente 4 3 4 6
4 Heerenveen Sub 21 Heerenveen 4 6 10 6
5 Almere City Sub 21 Almere City 4 4 7 1
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 2018/2019
BELOFTEN EREDIVISIE GRUPO 2
Equipo PJ GF GC Puntos
1 FC Emmen Sub 21 Emmen 9 21 6 19
2 Twente Sub 21 Twente 9 22 13 19
3 NEC Nijmegen Sub 21 Nijmegen 9 13 6 17
4 PEC Zwolle Sub 21 Zwolle 9 16 11 14
5 Heracles Sub 21 Heracles 9 14 15 12
6 RKC Waalwijk Sub 21 Waalwijk 9 10 13 11
7 Fortuna Sittard Sub 21 Fortuna 9 6 16 10
8 ADO Den Haag Sub 21 Haag 8 11 14 8
9 Willem II Sub 21 Willem 9 8 17 6
10 Feyenoord Sub 21 Feyenoord 8 9 19 5
TEMPORADA 2017/2018
DERDE DIVISIE GRUPO 1
Equipo PJ GF GC Puntos
1 Spakenburg Spakenburg 34 68 32 71
2 Scheveningen Scheveningen 34 68 44 65
3 DVS'33 DVS'33 34 74 37 62
4 Jong Almere City Jong Almere 34 73 54 61
5 Groningen Sub 21 Groningen 34 72 34 58
6 Quick Boys Quick Boys 34 63 45 58
7 Jong Volendam Jong 34 60 48 56
8 ODIN '59 ODIN '59 34 56 51 49
9 DOVO DOVO 34 54 52 49
10 Twente Sub 21 Twente 34 52 45 48
11 ASWH ASWH 34 52 51 47
12 Harkemase Boys Harkemase 34 55 56 46
13 VVOG VVOG 34 36 51 42
14 ONS Sneek ONS Sneek 34 62 88 37
15 Capelle Capelle 34 44 57 35
16 Spijkenisse Spijkenisse 34 56 83 33
17 ACV Assen ACV Assen 34 57 83 32
18 Magreb 90 Magreb 90 34 31 122 10
TEMPORADA 2016/2017
TWEEDE DIVISIE
Equipo PJ GF GC Puntos
1 Jong AZ Jong AZ 34 85 29 76
2 Kozakken Boys Kozakken 34 70 54 57
3 Katwijk Katwijk 34 52 42 55
4 De Treffers De Treffers 34 70 55 54
5 Excelsior Maassluis Excelsior 34 52 43 49
6 Lienden Lienden 34 52 48 48
7 Jong Sparta Jong Sparta 34 74 67 47
8 BVV Barendrecht Barendrecht 34 57 57 47
9 VVSB VVSB 34 62 64 47
10 GVVV GVVV 34 51 63 47
11 Amsterdamsche FC Amsterdamsch 34 59 63 45
12 SV TEC Tiel SV TEC Tiel 34 53 67 45
13 Koninklijke HFC Koninklijke 34 49 50 42
14 HHC Hardenberg Hardenberg 34 41 53 41
15 UNA UNA 34 57 79 41
16 Spakenburg Spakenburg 34 61 66 37
17 Vitesse Sub 23 Vitesse 34 66 79 34
18 Twente Sub 21 Twente 34 32 64 25
TEMPORADA 2015/2016
BELOFTEN EREDIVISIE
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
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

  USO DE MEMORIA  
5,427,944 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0012
Controller Execution Time ( Home / Category )  0.0888
Total Execution Time  0.0900
  CADENA URL  
/historico/Fc-Twente-Sub23
  GET DATOS  
$_GET['/historico/Fc-Twente-Sub23']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (26)  
0.0040  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 = 64660
0.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=82274 AND type_rel = 2
0.0018  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.0021  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 = '82274' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0019  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 = 64660 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0022  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=82274 AND l.year in (2021,2022,2023) ORDER BY l.id DESC, l.year DESC ;
0.0018  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 (64660) 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.0018  SELECT count(id) as num_players from rel_players WHERE league_id = 64660 AND teamId = 82274
0.0020  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff 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 = 64660 AND t.round = 5 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0021  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 = '82274' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0020  SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '82274' and rp.type = 4
0.0021  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 = '82274' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0020  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 events2022 e ON e.player_id = p.id AND e.league_id = 64660 WHERE rp.league_id = 64660 AND rp.teamId = 82274 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.0021  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 events2022 e ON e.player_id = p.id AND e.league_id = 64660 WHERE rp.league_id = 64660 AND rp.teamId = 82274 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0020  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 events2022 e ON e.player_id = p.id AND e.league_id = 64660 WHERE rp.league_id = 64660 AND rp.teamId = 82274 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0023  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 = 82274 AND l.year <= 2022 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.0021  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 = 64660 AND t.round = 5 ORDER BY team.conference ASC,t.position 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 `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.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 `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 = 49578 AND t.round = 11 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 `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 = 49581 AND t.round = 9 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 `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 = 38963 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0029  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 = 33765 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0031  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.0036  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