4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del Ajax Sub 18
TEMPORADA 2023/2024
LIGA PAÍSES BAJOS SUB 18 GRUPO 2
Equipo PJ GF GC Puntos
1 Ajax Sub 18 Ajax Sub 18 12 38 17 28
2 Feyenoord Sub 18 Feyenoord 11 19 11 25
3 PSV Sub 18 PSV Sub 18 13 27 19 24
4 Utrecht Sub 18 Utrecht 13 25 16 22
5 AZ Alkmaar Sub 18 Alkmaar 13 25 14 21
6 Vitesse Sub 18 Vitesse 12 25 31 13
7 Willem II Sub 18 Willem 13 11 42 6
8 Groningen Sub 18 Groningen 13 14 34 4
TEMPORADA 2022/2023
LIGA PAÍSES BAJOS SUB 18 GRUPO 2
Equipo PJ GF GC Puntos
1 Ajax Sub 18 Ajax Sub 18 14 41 21 31
2 PSV Sub 18 PSV Sub 18 14 32 17 28
3 AZ Alkmaar Sub 18 Alkmaar 14 30 21 23
4 Utrecht Sub 18 Utrecht 14 35 28 19
5 Sparta Rotterdam Sub 18 Sparta 14 26 39 17
6 Feyenoord Sub 18 Feyenoord 14 17 24 16
7 Twente / Heracles Sub 18 Twente 14 15 29 12
8 PEC Zwolle Sub 18 Zwolle 14 21 38 9
TEMPORADA 2021/2022
LIGA PAÍSES BAJOS SUB 18 GRUPO 6
Equipo PJ GF GC Puntos
1 AZ Alkmaar Sub 18 Alkmaar 7 23 3 21
2 PSV Sub 18 PSV Sub 18 7 23 8 18
3 Ajax Sub 18 Ajax Sub 18 7 18 9 13
4 Feyenoord Sub 18 Feyenoord 7 19 13 10
5 ADO Den Haag Sub 18 Haag 7 13 22 9
6 PEC Zwolle Sub 18 Zwolle 7 9 21 5
7 Heerenveen Sub 18 Heerenveen 7 6 20 3
8 NAC Breda Sub 18 Breda 7 8 23 3
TEMPORADA 2020/2021
LIGA PAÍSES BAJOS SUB 18 GRUPO 1
Equipo PJ GF GC Puntos
1 Ajax Sub 18 Ajax Sub 18 4 11 4 12
2 PSV Sub 18 PSV Sub 18 3 16 3 9
3 Utrecht Sub 18 Utrecht 4 14 12 9
4 AZ Alkmaar Sub 18 Alkmaar 2 11 1 6
5 Feyenoord Sub 18 Feyenoord 3 6 10 3
6 PEC Zwolle Sub 18 Zwolle 2 1 9 0
7 Sparta Rotterdam Sub 18 Sparta 4 4 14 0
8 Heerenveen Sub 18 Heerenveen 4 3 13 0
TEMPORADA 2015/2016
LIGA PAÍSES BAJOS SUB 19 GRUPO 4
Equipo PJ GF GC Puntos
1 ADO Den Haag Sub 19 Haag 18 34 17 40
2 Volendam Sub 19 Volendam 18 44 27 32
3 Roda JC Sub 19 Roda 18 36 37 29
4 Sparta Rotterdam Sub 19 Sparta 18 33 22 28
5 Heerenveen Sub 19 Heerenveen 18 30 35 24
6 Ajax Sub 18 Ajax Sub 18 18 38 38 22
7 PEC Zwolle Sub 19 Zwolle 18 22 26 22
8 Feyenoord Sub 18 Feyenoord 18 35 41 22
9 Groningen Sub 19 Groningen 18 19 33 20
10 Twente Sub 19 Twente 18 25 40 11
TEMPORADA 2014/2015
LIGA PAÍSES BAJOS SUB 19 GRUPO 2
Equipo PJ GF GC Puntos
1 Ajax Sub 18 Ajax Sub 18 11 28 18 24
2 Willem II Sub 19 Willem 11 21 8 23
3 PEC Zwolle Sub 19 Zwolle 11 26 19 23
4 Volendam Sub 19 Volendam 11 29 19 21
5 AFC Amsterdam Sub 19 Amsterdam 11 19 12 21
6 Almere City Sub 19 Almere City 11 25 10 19
7 Feyenoord Sub 18 Feyenoord 11 28 20 15
8 VVV/Helmond Sport Sub 19 VVV/Helmond 11 14 19 12
9 Excelsior Sub 19 Excelsior 11 18 19 10
10 AVV Zeeburgia Sub 19 Zeeburgia 11 14 32 7
11 Hollandia Sub 19 Hollandia 11 9 34 5
12 De Graafschap Sub 19 Graafschap 11 12 33 4
TEMPORADA 2013/2014
LIGA PAÍSES BAJOS SUB 19 GRUPO 2
Equipo PJ GF GC Puntos
1 FC Den Bosch Sub 19 Bosch 22 42 31 38
2 NEC OSS Sub 19 17 37 21 36
3 Ajax Sub 18 Ajax Sub 18 20 44 31 36
4 Almere City Sub 19 Almere City 20 43 36 35
5 Volendam Sub 19 Volendam 16 41 28 28
6 Feyenoord Sub 18 Feyenoord 14 34 20 26
7 Excelsior Sub 19 Excelsior 16 27 27 23
8 NAC Breda Sub 19 Breda 16 30 35 21
9 PEC Zwolle Sub 19 Zwolle 16 28 33 19
10 VVV/Helmond Sport Sub 19 VVV/Helmond 16 23 28 18
11 BVV Barendrecht Sub 19 Barendrecht 22 27 53 16
12 SV Argon Sub 19 Argon 15 8 41 3

  USO DE MEMORIA  
5,373,160 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0020
Controller Execution Time ( Home / Category )  0.5846
Total Execution Time  0.5866
  CADENA URL  
/historico/Ajax-Sub-18
  GET DATOS  
$_GET['/historico/Ajax-Sub-18']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (37)  
0.0140  SELECT dt.*,c.active_year,l.year,l.table_suffix, c.ctype, l.id as league_id,t.id as id,t.manager,t.name as nameOriginal,dt.id as teamId,cou.Name as cou_name,cou.Continent,cou.Region FROM `leagues_webci` as l INNER JOIN `teams` as t ON l.id = t.league_id INNER JOIN `datateams` as dt ON dt.id = t.teamId INNER JOIN `categories_webci` as c ON c.id = l.categoryId LEFT JOIN country cou ON LOWER(cou.Code2) = dt.CountryCode WHERE dt.basealias = 'Ajax-Sub-18' AND l.year = 2024 ORDER BY c.top DESC, c.ctype != 12 DESC, c.troncal DESC, l.end_date >= NOW() DESC, l.start_date <= NOW() DESC, l.year DESC, c.coefficient DESC, l.id ASC
0.0125  SELECT dp.nick, dp.fullname,rp.date_ini, rp.date_end FROM futbol.rel_people rp INNER JOIN futbol.datapeople dp on dp.id=rp.people_id WHERE rp.teamId=111467 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0125  SELECT dp.nick, dp.fullname,rp.date_ini, rp.date_end FROM futbol.rel_people rp INNER JOIN futbol.datapeople dp on dp.id=rp.people_id WHERE rp.teamId=111467 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0125  SELECT dp.nick, dp.fullname,rp.date_ini, rp.date_end FROM futbol.rel_people rp INNER JOIN futbol.datapeople dp on dp.id=rp.people_id WHERE rp.teamId=111467 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0125  SELECT dp.nick, dp.fullname,rp.date_ini, rp.date_end FROM futbol.rel_people rp INNER JOIN futbol.datapeople dp on dp.id=rp.people_id WHERE rp.teamId=111467 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0252  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 = 72957
0.0127  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=111467 AND type_rel = 2
0.0125  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=2377 AND type_rel = 3
0.0129  SELECT cat.logo,cat.official,cat.location,dt.nameShow,dt.basealias,t.teamId,l.year,t.qod,cat.coefficient,cat.active_year,cat.name,l.group_code,l.total_group,cat.alias,l.categoryId,l.year,l.id as league_id FROM datateams dt INNER JOIN teams t ON t.teamId = dt.id INNER JOIN leagues l ON l.id = t.league_id INNER JOIN categories cat ON cat.id = l.categoryId WHERE dt.id = '111467' ORDER BY l.year DESC,cat.coefficient DESC
0.0128  SELECT cat.logo,cat.official,cat.location,dt.nameShow,dt.basealias,t.teamId,l.year,t.qod,cat.coefficient,cat.active_year,cat.name,l.group_code,l.total_group,cat.alias,l.categoryId,l.year,l.id as league_id FROM datateams dt INNER JOIN teams t ON t.teamId = dt.id INNER JOIN leagues l ON l.id = t.league_id INNER JOIN categories cat ON cat.id = l.categoryId WHERE dt.id = '111467' AND l.year = 2024 ORDER BY l.year DESC,cat.coefficient DESC
0.0128  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 = '111467' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0128  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 = 74096 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0126  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 = 72957 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0131  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=111467 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0126  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 (75053,74096) 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.0127  SELECT count(id) as num_players from rel_players WHERE league_id = 75053 AND teamId = 111467
0.0127  SELECT count(id) as num_players from rel_players WHERE league_id = 74096 AND teamId = 111467
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 FROM `tables2024` 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 = 75053 AND t.round = 13 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0126  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 = '111467' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0125  SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '111467' and rp.type = 4
0.0128  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 = '111467' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0135  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 events2024 e ON e.player_id = p.id AND e.league_id = 75053 WHERE rp.league_id = 75053 AND rp.teamId = 111467 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.0132  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 events2024 e ON e.player_id = p.id AND e.league_id = 75053 WHERE rp.league_id = 75053 AND rp.teamId = 111467 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0127  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 events2024 e ON e.player_id = p.id AND e.league_id = 75053 WHERE rp.league_id = 75053 AND rp.teamId = 111467 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0130  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 = 111467 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
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 `tables2024` 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 = 72957 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.0127  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 `tables2024` 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 = 75053 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.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 `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 = 68773 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.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 `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 = 70878 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.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 `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 = 64138 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.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 `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 = 66964 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.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 `tables2021` 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 = 58734 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.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 = 44030 AND t.round = 11 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 = 44031 AND t.round = 18 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 = 44155 AND t.round = 18 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 `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 = 44154 AND t.round = 11 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 = 44156 AND t.round = 22 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC