4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del Jong AZ

Jong AZ

Entrenador: Lee-Roy Echteld

Información

Partidos del Jong AZ

Ir al LIVESCORE
23 Sep 22  Finalizado Schalke 04 II
2 - 2
Jong AZ 1
23 Jul 22  Finalizado Jong AZ
2 - 3
Amsterdamsche FC 0
19 Jul 22  Finalizado VVV Venlo
2 - 3
Jong AZ 2
16 Jul 22  Finalizado Koninklijke HFC
0 - 3
Jong AZ 0
13 Jul 22  Finalizado TOP Oss
2 - 0
Jong AZ 0
09 Jul 22  Finalizado Katwijk
0 - 5
Jong AZ 0
06 Jul 22  Finalizado Jong AZ
4 - 0
Jong Sparta 1
02 Jul 22  Finalizado Almere City
3 - 1
Jong AZ 1
19 May 23  Finalizado Jong AZ
0 - 2
ADO Den Haag 21
12 May 23  Finalizado Jong Ajax
1 - 2
Jong AZ 37
08 May 23  Finalizado Jong AZ
1 - 1
TOP Oss 80
28 Abr 23  Finalizado Tarjeta RojaMVV Maastricht
1 - 3
Jong AZ 56
21 Abr 23  Finalizado Tarjeta RojaDordrecht
1 - 0
Jong AZ 43
17 Abr 23  Finalizado Jong AZ
4 - 0
Jong UtrechtTarjeta Roja 51
07 Abr 23  Finalizado Almere City
2 - 1
Jong AZ 37
03 Abr 23  Finalizado Jong AZ
0 - 1
De Graafschap 49
17 Mar 23  Finalizado Jong AZ
1 - 1
FC Eindhoven 96
13 Mar 23  Finalizado Roda JC
2 - 0
Jong AZ 34
10 Mar 23  Finalizado Heracles
2 - 0
Jong AZ 229
06 Mar 23  Finalizado Jong AZ
2 - 2
Willem II 23
27 Feb 23  Finalizado Jong PSV
3 - 3
Jong AZ 100
17 Feb 23  Finalizado Jong AZ
3 - 1
Den Bosch 13
10 Feb 23  Finalizado PEC Zwolle
4 - 1
Jong AZ 48
03 Feb 23  Finalizado Jong AZ
4 - 3
VVV Venlo 19
27 Ene 23  Finalizado NAC Breda
5 - 1
Jong AZTarjeta Roja 41
23 Ene 23  Finalizado Jong AZ
1 - 1
Helmond Sport 170
16 Ene 23  Finalizado TOP Oss
1 - 3
Jong AZ 103
13 Ene 23  Finalizado Tarjeta RojaSC Telstar
1 - 0
Jong AZ 74
09 Ene 23  Finalizado Jong Utrecht
0 - 2
Jong AZ 110
06 Ene 23  Finalizado Tarjeta RojaJong AZ
1 - 1
Heracles 279
12 Dic 22  Finalizado Jong AZ
2 - 3
Jong PSV 283
17 Nov 22  Finalizado Jong AZ
1 - 1
Jong Ajax 446
07 Nov 22  Finalizado Jong AZ
2 - 0
Roda JC 84
28 Oct 22  Finalizado VVV Venlo
1 - 2
Jong AZ 14
24 Oct 22  Finalizado Jong AZ
0 - 0
SC Telstar 58
14 Oct 22  Finalizado Den Bosch
3 - 0
Jong AZ 48
07 Oct 22  Finalizado Jong AZ
4 - 0
NAC Breda 45
30 Sep 22  Finalizado De Graafschap
2 - 0
Jong AZ 47
16 Sep 22  Finalizado Willem II
1 - 0
Jong AZ 55
12 Sep 22  Finalizado Jong AZ
2 - 3
PEC Zwolle 48
09 Sep 22  Finalizado Tarjeta RojaADO Den Haag
2 - 2
Jong AZ 24
05 Sep 22  Finalizado Jong AZ
3 - 1
Dordrecht 33
26 Ago 22  Finalizado FC Eindhoven
1 - 0
Jong AZ 25
22 Ago 22  Finalizado Jong AZ
3 - 2
Almere City 21
12 Ago 22  Finalizado Helmond Sport
1 - 3
Jong AZ 5
08 Ago 22  Finalizado Jong AZ
3 - 1
MVV Maastricht 17

Plantilla del Jong AZ Temporada 2022/2023

Jugador Edad Origen Altura Peso Goles Tarjetas rojas Tarjetas amarillas
Portero
16 21 nl 188 72 - - 1
1 19 nl 189 82 - - -
1 21 nl 190 83 - - 1
16 19 nl 191 - - - -
Defensa
5 21 nl 188 70 1 - 5
14 22 nl 181 68 - - -
2 21 nl 180 - 2 - 1
2 21 nl 181 73 - 1 6
4 21 nl 186 - 1 - 4
4 20 nl 191 88 2 - -
5 19 nl 181 73 1 - 4
Centrocampista
15 19 nl 185 - - - 4
10 20 nl 185 74 3 - 2
6 20 nl 193 78 1 - 2
19 21 nl 182 - - - -
18 21 nl 181 - - - 5
8 21 nl 182 65 4 - 2
Delantero
20 20 nl 180 75 4 - 4
22 20 nl 176 70 2 - 1
7 22 nl 170 - 5 - -
20 18 nl 175 - 1 - -
17 22 us 174 64 - - -
9 20 nl 182 - 8 1 1
17 21 nl 178 70 2 - -
11 21 tr 183 66 11 - 2
21 20 nl 173 74 2 - -

Noticias del Jong AZ

Ver últimas noticias

Mexx Meerdink, la nueva perla del AZ Alkmaar

El AZ Alkmaar eliminó al Barcelona de la Youth League con un contundente 0-3. Mexx Meerdink, con un doblete, fue el factor diferencial para la clasificación del conjunto neerlandés.

Gullit, Kluivert, Thuram o Weah ahora se llaman de otro modo

El histórico fútbol de los 90 ya es pasado. Legendarios nombres que marcaron una época son parte del recuerdo, ya están sus hijos en primera línea para que hablemos de Maxim y no de Ruud, de Timhoty y no de George, de Justin y no de Patrick.

El hijo de Gullit debutó con el AZ en el retorno del Twente a la élite

Maxim Gullit, hijo del exfutbolista holandés Ruud Gullit, hizo su debut como futbolista profesional, a los 17 años de edad, con el equipo juvenil del AZ ante el Twente.




  USO DE MEMORIA  
5,669,920 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0019
Controller Execution Time ( Home / Category )  0.1084
Total Execution Time  0.1103
  CADENA URL  
/Az-Alkmaar-Sub23/2023
  GET DATOS  
$_GET['/Az-Alkmaar-Sub23/2023']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (23)  
0.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=61516 AND type_rel = 2
0.0019  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 2 AND rel.typeId = 61516 AND rel.ln = 'es' ORDER BY rel.cover_points DESC LIMIT 5
0.0021  SELECT /*35 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 (621190,621334,1234326) ORDER BY n.cover_points DESC, update_date DESC
0.0025  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 = '61516' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0026  (SELECT cat.id as category_id, cat.logo, l.id,cat.alias,cat.name,l.group_code,l.total_group,cat.CountryCode,max(c.shedule) ult_partido,min(c.shedule) ini_partido,cat.coefficient FROM leagues l INNER JOIN categories as cat ON cat.id = l.categoryId INNER JOIN calendars2023 as c ON c.league_id = l.id WHERE (c.datateam1 = 61516 or c.datateam2 = 61516) AND l.year = 2023 GROUP BY cat.id) ORDER BY coefficient DESC,group_code ASC
0.0029  (SELECT cat.id as category_id, l.year,cat.coefficient,c.extra,c.datateam1,c.datateam2,c.id as mid,c.r1,c.r2,c.shedule,c.team1,c.team2,l.id,dt1.nameShow as nameShow1,dt2.nameShow as nameShow2,dt1.basealias as basealias1,dt2.basealias as basealias2,c.comments as totalcomments FROM leagues l INNER JOIN categories as cat ON cat.id = l.categoryId INNER JOIN calendars2023 as c ON c.league_id = l.id INNER JOIN teams t1 ON t1.id = c.team1 INNER JOIN teams t2 ON t2.id = c.team2 INNER JOIN datateams dt1 ON dt1.id = t1.teamId INNER JOIN datateams dt2 ON dt2.id = t2.teamId WHERE (c.datateam1 = 61516 or c.datateam2 = 61516) AND l.year = 2023 GROUP BY c.id) ORDER BY shedule DESC LIMIT 120
0.0024  (SELECT c.id, rel.team_id FROM leagues l INNER JOIN calendars2023 as c ON c.league_id = l.id INNER JOIN events2023 as e ON e.team1id = c.team1 AND e.team2id = c.team2 AND (e.action = 3 OR e.action = 4) INNER JOIN rel_players rel ON rel.player_id = e.player_id AND rel.in_squad = 1 AND rel.league_id = e.league_id AND rel.in_squad = 1 WHERE (c.datateam1 = 61516 or c.datateam2 = 61516) AND l.year = 2023)
0.0023  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=61516 AND l.year in (2022,2023,2024) ORDER BY l.id DESC, l.year DESC ;
0.0019  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 (72062,71432) 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.0021  SELECT count(id) as num_players from rel_players WHERE league_id = 72062 AND teamId = 61516
0.0023  SELECT count(id) as num_players from rel_players WHERE league_id = 71432 AND teamId = 61516
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 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 = 67927 AND t.round = 38 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0044  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 = 67927 WHERE rp.league_id = 67927 AND rp.teamId = 61516 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.0050  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 = 67927 WHERE rp.league_id = 67927 AND rp.teamId = 61516 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0030  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 = 67927 WHERE rp.league_id = 67927 AND rp.teamId = 61516 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0022  SELECT rp.team_id as teamId FROM rel_players AS rp inner join datateams as dt on rp.teamId=dt.id and rp.in_squad=1 INNER JOIN leagues as l ON l.id = rp.league_id WHERE dt.id = 61516 AND rp.league_id = 67927 AND l.year= 2023 GROUP BY rp.team_id ORDER BY l.end_date DESC LIMIT 1
0.0025  SELECT dp.id, dp.nick, dp.name, dp.last_name, dp.alias, dp.role, dp.height,dp.weight,dp.foot,dp.side,dp.birthdate,IF(dp.birthdate != '0000-00-00 00:00:00', YEAR(CURDATE())-YEAR(dp.birthdate) + IF(DATE_FORMAT(CURDATE(),'%m-%d') > DATE_FORMAT(dp.birthdate,'%m-%d'), 0, -1) , NULL) as age,rp.squadNumber,rp.captain,IF(dp.CountryCode IS NULL,'',dp.CountryCode) AS CountryCode,count(rp.id) as cuenta FROM rel_players as rp inner join dataplayers as dp on rp.player_id=dp.id and rp.in_squad=1 WHERE rp.team_id=6518466 GROUP BY dp.id ORDER BY dp.role>0 DESC, dp.role ASC, dp.nick ASC, dp.id
0.0019  SELECT rp.player_id, rp.pj, rp.lineup FROM rel_players AS rp WHERE rp.team_id=6518466
0.0034  SELECT dp.id,count(rp.id) as cuenta FROM rel_players as rp inner join dataplayers as dp on rp.player_id=dp.id INNER JOIN events2023 e ON rp.league_id = e.league_id AND rp.player_id = e.player_id WHERE rp.team_id=6518466 and (e.action = 1 or e.action = 2 or e.action = 11 or e.action = 12 or e.action = 13) GROUP BY dp.id ORDER BY cuenta DESC
0.0030  SELECT dp.id,count(rp.id) as cuenta FROM rel_players as rp inner join dataplayers as dp on rp.player_id=dp.id INNER JOIN events2023 e ON rp.league_id = e.league_id AND rp.player_id = e.player_id WHERE rp.team_id=6518466 and (e.action = 4 or e.action = 5) GROUP BY dp.id ORDER BY cuenta DESC
0.0026  SELECT dp.id,count(rp.id) as cuenta FROM rel_players as rp inner join dataplayers as dp on rp.player_id=dp.id INNER JOIN events2023 e ON rp.league_id = e.league_id AND rp.player_id = e.player_id WHERE rp.team_id=6518466 and (e.action = 3 or e.action = 4) GROUP BY dp.id ORDER BY cuenta DESC
0.0027   SELECT dp.id,count(rp.id) as cuenta FROM rel_players as rp inner join dataplayers as dp on rp.player_id=dp.id INNER JOIN events2023 e ON rp.league_id = e.league_id AND rp.player_id = e.player_id WHERE rp.team_id=6518466 AND (e.action = 22) GROUP BY dp.id ORDER BY cuenta DESC
0.0044  SELECT dp.id,count(rp.id) as cuenta FROM rel_players as rp inner join dataplayers as dp on rp.player_id=dp.id INNER JOIN events2023 e ON rp.league_id = e.league_id AND rp.player_id = e.player_id WHERE rp.team_id=6518466 and (e.action = 19) GROUP BY dp.id ORDER BY cuenta DESC