4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Publicidad 600x120.gif
Liga Nacional
2023/2024

Liga Nacional

  • UB Conquense Sub 19
  • CD Toledo Sub 19
  • CD Alameda MESA Sub 19
  • CD Azuqueca Sub 19
  • AD Illescas Sub 19
  • Albacete Balompié Sub 19 B
  • Atlético Puertollano Sub 19
  • Almansa Sub 19
  • EFUD Albacer Sub 19
  • Arges Sub 19
  • Torrijos CD Sub 19
  • Odelot Toletum Sub 19
  • CD Cazalegas Sub 19
  • Talavera de la Reina Sub 19
  • Guadalajara Sub 19
  • EFFB Ciudad Real Sub 19
  • Jesus de La Ossa Sub 19
  • CD Miguelturreño Sub 19
 
22 Sep 23
20:00 Finalizado
Talavera de la Reina Sub 19 Talavera Reina 1-1 CD Cazalegas Sub 19 CD Cazalegas Sub 19 más información Jugadas destacadas ...
0-1 62' J. Tesoro
90' J. Fernandez 1-1
 
23 Sep 23
16:00 Finalizado
Guadalajara Sub 19 Guadalajara Sub 19 0-1 Albacete Balompié Sub 19 B Albacete Balompié más información Jugadas destacadas ...
0-1 26' A. Morientes
 
23 Sep 23
16:00 Finalizado
Almansa Sub 19 Almansa Sub 19 5-0 Arges Sub 19 Arges Sub 19 más información Jugadas destacadas ...
50' J. Gorreta 1-0
61' S. Sanchez 2-0
70' J. Gorreta 3-0
73' J. Gorreta 4-0
83' I. Tomas 5-0
 
23 Sep 23
16:00 Finalizado
Jesus de La Ossa Sub 19 Jesus de La Ossa Sub 19 0-2 CD Toledo Sub 19 CD Toledo Sub 19 más información Jugadas destacadas ...
0-1 38' Alberto Dono
0-2 82' I. Garcia
 
23 Sep 23
16:00 Finalizado
CD Alameda MESA Sub 19 CD Alameda MESA Sub 19 1-0 AD Illescas Sub 19 AD Illescas Sub 19 más información Jugadas destacadas ...
63' Marcos Alonso 1-0
 
23 Sep 23
16:00 Finalizado
EFUD Albacer Sub 19 EFUD Albacer Sub 19 4-0 CD Miguelturreño Sub 19 Miguelturreño más información Jugadas destacadas ...
3' A. Garcia
24' J. Corcoles 2-0
87' Mohamed Jallouli
89' Iván Lorenzo 3-0
90' Gabriel González 4-0
 
23 Sep 23
16:30 Finalizado
EFFB Ciudad Real Sub 19 EFFB Ciudad Real Sub 19 1-2 UB Conquense Sub 19 UB Conquense Sub 19 más información Jugadas destacadas ...
13' P. Cayuela 1-0
1-1 34' Mark Motilla Ferrer
1-2 39' M. Cuevas
60' A. Gonzalez
 
23 Sep 23
17:00 Finalizado
Torrijos CD Sub 19 Torrijos CD Sub 19 2-0 CD Azuqueca Sub 19 CD Azuqueca Sub 19 más información Jugadas destacadas ...
16' A. Hammoudi 1-0
55' D. Belmar 2-0
65' D. Fernandez
 
24 Sep 23
12:00 Finalizado
Odelot Toletum Sub 19 Odelot Toletum Sub 19 1-2 Atlético Puertollano Sub 19 Atlético Puertollano más información Jugadas destacadas ...
0-1 42' R. Larrondo
58' R. Ballesteros
0-2 64' J. Duque
85' C. Zapero 1-2
Equipos Puntos J. G. E. P. F. C. Forma
1 UB Conquense Sub 19 Conquense 10 4 3 1 0 10 3
  • VICTORIA
  • UB Conquense Sub 1. 1
  • CD Alameda MESA Su. 0
  • EMPATE
  • Albacete Balompié. 1
  • UB Conquense Sub 1. 1
  • VICTORIA
  • UB Conquense Sub 1. 6
  • EFUD Albacer Sub 1. 1
  • VICTORIA
  • EFFB Ciudad Real S. 1
  • UB Conquense Sub 1. 2
2 CD Toledo Sub 19 Toledo 10 4 3 1 0 7 1
  • VICTORIA
  • Talavera de la Rei. 0
  • CD Toledo Sub 19 2
  • VICTORIA
  • CD Toledo Sub 19 2
  • Odelot Toletum Sub. 0
  • EMPATE
  • CD Toledo Sub 19 1
  • Torrijos CD Sub 19 1
  • VICTORIA
  • Jesus de La Ossa S. 0
  • CD Toledo Sub 19 2
3 CD Alameda MESA Sub 19 Alameda MESA 9 4 3 0 1 9 3
  • DERROTA
  • UB Conquense Sub 1. 1
  • CD Alameda MESA Su. 0
  • VICTORIA
  • CD Alameda MESA Su. 5
  • EFUD Albacer Sub 1. 2
  • VICTORIA
  • CD Miguelturreño S. 0
  • CD Alameda MESA Su. 3
  • VICTORIA
  • CD Alameda MESA Su. 1
  • AD Illescas Sub 19 0
4 CD Azuqueca Sub 19 Azuqueca 9 4 3 0 1 7 4
  • VICTORIA
  • CD Azuqueca Sub 19 3
  • EFFB Ciudad Real S. 2
  • VICTORIA
  • Guadalajara Sub 19 0
  • CD Azuqueca Sub 19 1
  • VICTORIA
  • CD Azuqueca Sub 19 3
  • Almansa Sub 19 0
  • DERROTA
  • Torrijos CD Sub 19 2
  • CD Azuqueca Sub 19 0
5 AD Illescas Sub 19 Illescas 7 4 2 1 1 7 3
  • VICTORIA
  • AD Illescas Sub 19 4
  • Talavera de la Rei. 0
  • EMPATE
  • Odelot Toletum Sub. 0
  • AD Illescas Sub 19 0
  • VICTORIA
  • AD Illescas Sub 19 3
  • Jesus de La Ossa S. 2
  • DERROTA
  • CD Alameda MESA Su. 1
  • AD Illescas Sub 19 0
6 Albacete Balompié Sub 19 B Albacete 7 4 2 1 1 6 4
  • DERROTA
  • Arges Sub 19 2
  • Albacete Balompié. 1
  • EMPATE
  • Albacete Balompié. 1
  • UB Conquense Sub 1. 1
  • VICTORIA
  • Albacete Balompié. 3
  • EFFB Ciudad Real S. 1
  • VICTORIA
  • Guadalajara Sub 19 0
  • Albacete Balompié. 1
7 Atlético Puertollano Sub 19 Atlético 7 4 2 1 1 5 4
  • VICTORIA
  • Atlético Puertolla. 2
  • Almansa Sub 19 1
  • EMPATE
  • Torrijos CD Sub 19 0
  • Atlético Puertolla. 0
  • DERROTA
  • Atlético Puertolla. 1
  • Talavera de la Rei. 2
  • VICTORIA
  • Odelot Toletum Sub. 1
  • Atlético Puertolla. 2
8 Almansa Sub 19 Almansa Sub 19 6 4 2 0 2 8 5
  • DERROTA
  • Atlético Puertolla. 2
  • Almansa Sub 19 1
  • VICTORIA
  • Almansa Sub 19 2
  • CD Cazalegas Sub 1. 0
  • DERROTA
  • CD Azuqueca Sub 19 3
  • Almansa Sub 19 0
  • VICTORIA
  • Almansa Sub 19 5
  • Arges Sub 19 0
9 EFUD Albacer Sub 19 EFUD Albacer 6 4 2 0 2 11 12
  • VICTORIA
  • EFUD Albacer Sub 1. 4
  • Jesus de La Ossa S. 1
  • DERROTA
  • CD Alameda MESA Su. 5
  • EFUD Albacer Sub 1. 2
  • DERROTA
  • UB Conquense Sub 1. 6
  • EFUD Albacer Sub 1. 1
  • VICTORIA
  • EFUD Albacer Sub 1. 4
  • CD Miguelturreño S. 0
10 Arges Sub 19 Arges Sub 19 6 4 2 0 2 5 9
  • VICTORIA
  • Arges Sub 19 2
  • Albacete Balompié. 1
  • DERROTA
  • EFFB Ciudad Real S. 2
  • Arges Sub 19 1
  • VICTORIA
  • Arges Sub 19 2
  • Guadalajara Sub 19 1
  • DERROTA
  • Almansa Sub 19 5
  • Arges Sub 19 0
11 Torrijos CD Sub 19 Torrijos 5 4 1 2 1 4 3
  • EMPATE
  • Torrijos CD Sub 19 0
  • Atlético Puertolla. 0
  • DERROTA
  • CD Cazalegas Sub 1. 2
  • Torrijos CD Sub 19 1
  • EMPATE
  • CD Toledo Sub 19 1
  • Torrijos CD Sub 19 1
  • VICTORIA
  • Torrijos CD Sub 19 2
  • CD Azuqueca Sub 19 0
12 Odelot Toletum Sub 19 Odelot Toletum 4 4 1 1 2 5 7
  • VICTORIA
  • CD Miguelturreño S. 3
  • Odelot Toletum Sub. 4
  • EMPATE
  • Odelot Toletum Sub. 0
  • AD Illescas Sub 19 0
  • DERROTA
  • CD Toledo Sub 19 2
  • Odelot Toletum Sub. 0
  • DERROTA
  • Odelot Toletum Sub. 1
  • Atlético Puertolla. 2
13 CD Cazalegas Sub 19 Cazalegas 4 4 1 1 2 3 6
  • DERROTA
  • CD Cazalegas Sub 1. 0
  • Guadalajara Sub 19 2
  • DERROTA
  • Almansa Sub 19 2
  • CD Cazalegas Sub 1. 0
  • VICTORIA
  • CD Cazalegas Sub 1. 2
  • Torrijos CD Sub 19 1
  • EMPATE
  • Talavera de la Rei. 1
  • CD Cazalegas Sub 1. 1
14 Talavera de la Reina Sub 19 Talavera Reina 4 4 1 1 2 3 8
  • DERROTA
  • AD Illescas Sub 19 4
  • Talavera de la Rei. 0
  • DERROTA
  • Talavera de la Rei. 0
  • CD Toledo Sub 19 2
  • VICTORIA
  • Atlético Puertolla. 1
  • Talavera de la Rei. 2
  • EMPATE
  • Talavera de la Rei. 1
  • CD Cazalegas Sub 1. 1
15 Guadalajara Sub 19 Guadalajara 3 4 1 0 3 3 4
  • VICTORIA
  • CD Cazalegas Sub 1. 0
  • Guadalajara Sub 19 2
  • DERROTA
  • Guadalajara Sub 19 0
  • CD Azuqueca Sub 19 1
  • DERROTA
  • Arges Sub 19 2
  • Guadalajara Sub 19 1
  • DERROTA
  • Guadalajara Sub 19 0
  • Albacete Balompié. 1
16 EFFB Ciudad Real Sub 19 EFFB Ciudad Real 3 4 1 0 3 6 9
  • DERROTA
  • CD Azuqueca Sub 19 3
  • EFFB Ciudad Real S. 2
  • VICTORIA
  • EFFB Ciudad Real S. 2
  • Arges Sub 19 1
  • DERROTA
  • Albacete Balompié. 3
  • EFFB Ciudad Real S. 1
  • DERROTA
  • EFFB Ciudad Real S. 1
  • UB Conquense Sub 1. 2
17 Jesus de La Ossa Sub 19 Jesus Ossa 0 3 0 0 3 3 9
  • DERROTA
  • EFUD Albacer Sub 1. 4
  • Jesus de La Ossa S. 1
  • DERROTA
  • AD Illescas Sub 19 3
  • Jesus de La Ossa S. 2
  • DERROTA
  • Jesus de La Ossa S. 0
  • CD Toledo Sub 19 2
18 CD Miguelturreño Sub 19 Miguelturreño 0 3 0 0 3 3 11
  • DERROTA
  • CD Miguelturreño S. 3
  • Odelot Toletum Sub. 4
  • DERROTA
  • CD Miguelturreño S. 0
  • CD Alameda MESA Su. 3
  • DERROTA
  • EFUD Albacer Sub 1. 4
  • CD Miguelturreño S. 0
Ascenso : Conquense
Descenso : EFFB Ciudad Real, Jesus Ossa, Miguelturreño

INFORMACIÓN

La Liga Nacional Juvenil es la segunda categoría del fútbol juvenil español, tras la División de Honor. Consta de 17 grupos de un número variable entre 16 y 18 equipos, según la autonomía correspondiente.



Las Islas Canarias no tienen grupo de Liga Nacional, sino que en su lugar disputan la Preferente de Canarias, desde donde ascienden los equipos canarios a División de Honor.

  USO DE MEMORIA  
5,781,160 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0024
Controller Execution Time ( Home / Category )  0.0684
Total Execution Time  0.0709
  CADENA URL  
/nacional_juvenil/grupo15/jornada4
  GET DATOS  
$_GET['/nacional_juvenil/grupo15/jornada4']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (13)  
0.0019  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-04-27 20:18:12' 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-27 20:18:12' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0019  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=4 AND last_update > '2024-04-27 20:18:12' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0019  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=3 AND last_update > '2024-04-27 20:18:12' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0019  SELECT rel.media_id, rel.team1, rel.team2, m.name, m.type, m.lang, m.location, rel.id AS rel_id, m.url FROM rel_media_match AS rel INNER JOIN media AS m ON m.id=rel.media_id WHERE (m.lang='es' OR m.language='spanish') AND rel.active=1 AND rel.league_id=73391 AND rel.round=4
0.0023  SELECT c.isVideo, c.id,c.team1, c.team2,c.extra,c.datateam1,c.datateam2,c.type, c.shedule, c.r1, c.r2, c.round, c.comments as total_comentarios, dt1.nameShow as team1_name, dt2.nameShow as team2_name, dt1.basealias as basealias1, dt2.basealias as basealias2,c.betId,c.betId_wh,c.betId_bwin,c.betId_marca,c.betId_888, c.betId_sportium, c.betId_marathon, c.finished, c.penaltis1, c.penaltis2, c.prorroga, c.status, c.minute, dt1.stadium as stadium_name FROM `calendars2024` as c INNER JOIN teams t1 ON t1.id = c.team1 AND t1.league_id = c.league_id INNER JOIN teams t2 ON t2.id = c.team2 AND t2.league_id = c.league_id INNER JOIN datateams as dt1 ON dt1.id = t1.teamId INNER JOIN datateams as dt2 ON dt2.id = t2.teamId WHERE c.`league_id` = 73391 AND c.`round` = 4 ORDER BY shedule ASC LIMIT 200
0.0029  SELECT ev.match_id,dp.alias,ev.minute,ev.action,ev.player_id,e.name,e.classf,dp.nick,rel.squadNumber,rel.player_id as playerId,rel.team_id,rel.teamId FROM events2024 ev INNER JOIN events e ON e.id = ev.action INNER JOIN calendars2024 c ON c.id = ev.match_id INNER JOIN rel_players rel ON rel.player_id = ev.player_id AND rel.league_id = 73391 AND (ev.team1id=rel.team_id OR ev.team2id=rel.team_id) INNER JOIN dataplayers dp ON dp.id = rel.player_id WHERE ev.match_id IN (498326,498323,498324,498328,498329,498330,498322,498325,498327) AND ev.action in (1,2,3,4,6,11,12,13,15) ORDER BY ev.minute ASC
0.0039  SELECT (dt1.qod+dt2.qod+dt1.relations+dt2.relations) as total,c.r1,c.r2,e.action,ev.showName as eventName,ev.largeName,ev.main_action,ev.keyname,ev.classf,e.real_date,e.minute, dp.nick,dp.CountryCode,dp.alias,c.datateam1,c.datateam2,dt1.nameShow as nameShow1,dt2.nameShow as nameShow2,dt1.basealias as basealias1,dt2.basealias as basealias2,e.player_id,e.match_id FROM `events2024` e INNER JOIN calendars2024 c ON c.id = e.match_id INNER JOIN events ev ON ev.id = e.action INNER JOIN dataplayers dp ON dp.id = e.player_id INNER JOIN datateams dt1 ON dt1.id = c.datateam1 INNER JOIN datateams dt2 ON dt2.id = c.datateam2 WHERE ev.main_action = 1 AND c.round = 4 AND e.real_date IS NOT NULL AND e.league_id = 73391 ORDER BY total DESC LIMIT 40
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 `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 = 73391 AND t.round = 3 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0030  SELECT *,(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 = 73391 AND t.round = 4 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0022  SELECT distinct(shedule), round FROM `calendars2024` as c WHERE c.`league_id` = 73391 AND shedule >= '2023/09/01' AND shedule < '2023/10/01' ORDER BY shedule ASC
0.0018  SELECT data1, data2 FROM services_tags WHERE categoryId=112
0.0024  SELECT group_code, extraName from `leagues` WHERE categoryId=112 AND year=2024