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

Liga Nacional 2024

  • SD Solares Sub 19
  • Castro FC Sub 19
  • Atlético Perines Sub 19 B
  • CD Tropezón Sub 19
  • Bansander Sub 19 B
  • Real Racing Club Sub 19 B
  • CF Vimenor Sub 19
  • CD Laredo Sub 19
  • Marina Sport Sub 19
  • CD Monte Sub 19
  • SD Peña Revilla Sub 19
  • CD Amistad Sniace Sub 19
  • Velarde CF Sub 19
  • CD Bezana sub 19
  • RS Gimnástica Sub 19 B
  • CD Colindres Sub 19
  • CD Naval Sub 19
  • SD Nueva Montaña Sub 19
Resultados
« Jornada Anterior
Jornada 31
Jornada Siguiente »
 
04 May 24
Sin comenzar 		Velarde CF Sub 19 Velarde CF Sub 19
16:00
 		RS Gimnástica Sub 19 B RS Gimnástica Sub 19 B más información ...
 
04 May 24
Sin comenzar 		CF Vimenor Sub 19 CF Vimenor Sub 19
16:00
 		SD Peña Revilla Sub 19 SD Peña Revilla Sub 19 más información ...
 
04 May 24
Sin comenzar 		Atlético Perines Sub 19 B Atlético Perines
16:00
 		Real Racing Club Sub 19 B Real Racing Club más información ...
 
04 May 24
Sin comenzar 		Bansander Sub 19 B Bansander Sub 19 B
16:00
 		CD Amistad Sniace Sub 19 Amistad Sniace más información ...
 
04 May 24
Sin comenzar 		CD Laredo Sub 19 CD Laredo Sub 19
18:00
 		CD Naval Sub 19 CD Naval Sub 19 más información ...
 
05 May 24
Sin comenzar 		CD Tropezón Sub 19 CD Tropezón Sub 19
12:00
 		SD Solares Sub 19 SD Solares Sub 19 más información ...
 
05 May 24
Sin comenzar 		Marina Sport Sub 19 Marina Sport Sub 19
12:30
 		CD Monte Sub 19 CD Monte Sub 19 más información ...
 
05 May 24
Sin comenzar 		CD Colindres Sub 19 CD Colindres Sub 19
12:30
 		SD Nueva Montaña Sub 19 Nueva Montaña más información ...
 
05 May 24
Sin comenzar 		CD Bezana sub 19 CD Bezana sub 19
16:00
 		Castro FC Sub 19 Castro FC Sub 19 más información ...
Clasificación
« Jornada Anterior
Jornada 31
Jornada Siguiente »
Equipos Puntos J. G. E. P. F. C.
1 SD Solares Sub 19 Solares 9 3 3 0 0 9 3
  • VICTORIA
  • Real Racing Club S. 1
  • SD Solares Sub 19 2
  • VICTORIA
  • SD Solares Sub 19 5
  • SD Nueva Montaña S. 1
  • VICTORIA
  • CD Amistad Sniace. 1
  • SD Solares Sub 19 2
2 Castro FC Sub 19 Castro 7 3 2 1 0 6 1
  • VICTORIA
  • Castro FC Sub 19 2
  • Marina Sport Sub 1. 0
  • EMPATE
  • CF Vimenor Sub 19 1
  • Castro FC Sub 19 1
  • VICTORIA
  • Castro FC Sub 19 3
  • Velarde CF Sub 19 0
3 Atlético Perines Sub 19 B Atlético 7 3 2 1 0 8 4
  • VICTORIA
  • CD Naval Sub 19 1
  • Atlético Perines S. 4
  • EMPATE
  • Atlético Perines S. 1
  • CD Laredo Sub 19 1
  • VICTORIA
  • CD Bezana sub 19 2
  • Atlético Perines S. 3
4 CD Tropezón Sub 19 Tropezón 7 3 2 1 0 4 1
  • VICTORIA
  • CD Tropezón Sub 19 3
  • SD Peña Revilla Su. 1
  • VICTORIA
  • Bansander Sub 19 B 0
  • CD Tropezón Sub 19 1
  • EMPATE
  • CD Tropezón Sub 19 0
  • CD Monte Sub 19 0
5 Bansander Sub 19 B Bansander 6 3 2 0 1 7 5
  • VICTORIA
  • CD Bezana sub 19 2
  • Bansander Sub 19 B 3
  • DERROTA
  • Bansander Sub 19 B 0
  • CD Tropezón Sub 19 1
  • VICTORIA
  • Bansander Sub 19 B 4
  • CD Colindres Sub 1. 2
6 Real Racing Club Sub 19 B Real Racing Club 6 3 2 0 1 5 3
  • DERROTA
  • Real Racing Club S. 1
  • SD Solares Sub 19 2
  • VICTORIA
  • RS Gimnástica Sub. 1
  • Real Racing Club S. 2
  • VICTORIA
  • Real Racing Club S. 2
  • SD Peña Revilla Su. 0
7 CF Vimenor Sub 19 Vimenor 5 3 1 2 0 5 2
  • VICTORIA
  • CD Amistad Sniace. 0
  • CF Vimenor Sub 19 3
  • EMPATE
  • CF Vimenor Sub 19 1
  • Castro FC Sub 19 1
  • EMPATE
  • CD Naval Sub 19 1
  • CF Vimenor Sub 19 1
8 CD Laredo Sub 19 Laredo 5 3 1 2 0 6 5
  • VICTORIA
  • CD Laredo Sub 19 2
  • CD Colindres Sub 1. 1
  • EMPATE
  • Atlético Perines S. 1
  • CD Laredo Sub 19 1
  • EMPATE
  • CD Laredo Sub 19 3
  • Marina Sport Sub 1. 3
9 Marina Sport Sub 19 Marina Sport 4 3 1 1 1 7 7
  • DERROTA
  • Castro FC Sub 19 2
  • Marina Sport Sub 1. 0
  • VICTORIA
  • Marina Sport Sub 1. 4
  • CD Naval Sub 19 2
  • EMPATE
  • CD Laredo Sub 19 3
  • Marina Sport Sub 1. 3
10 CD Monte Sub 19 CD Monte Sub 19 4 3 1 1 1 3 6
  • VICTORIA
  • CD Monte Sub 19 3
  • RS Gimnástica Sub. 2
  • DERROTA
  • SD Peña Revilla Su. 4
  • CD Monte Sub 19 0
  • EMPATE
  • CD Tropezón Sub 19 0
  • CD Monte Sub 19 0
11 SD Peña Revilla Sub 19 Peña Revilla 3 3 1 0 2 5 5
  • DERROTA
  • CD Tropezón Sub 19 3
  • SD Peña Revilla Su. 1
  • VICTORIA
  • SD Peña Revilla Su. 4
  • CD Monte Sub 19 0
  • DERROTA
  • Real Racing Club S. 2
  • SD Peña Revilla Su. 0
12 CD Amistad Sniace Sub 19 Amistad Sniace 3 3 1 0 2 2 5
  • DERROTA
  • CD Amistad Sniace. 0
  • CF Vimenor Sub 19 3
  • VICTORIA
  • Velarde CF Sub 19 0
  • CD Amistad Sniace. 1
  • DERROTA
  • CD Amistad Sniace. 1
  • SD Solares Sub 19 2
13 Velarde CF Sub 19 Velarde 3 3 1 0 2 2 5
  • VICTORIA
  • SD Nueva Montaña S. 1
  • Velarde CF Sub 19 2
  • DERROTA
  • Velarde CF Sub 19 0
  • CD Amistad Sniace. 1
  • DERROTA
  • Castro FC Sub 19 3
  • Velarde CF Sub 19 0
14 CD Bezana sub 19 Bezana 1 3 0 1 2 6 8
  • DERROTA
  • CD Bezana sub 19 2
  • Bansander Sub 19 B 3
  • EMPATE
  • CD Colindres Sub 1. 2
  • CD Bezana sub 19 2
  • DERROTA
  • CD Bezana sub 19 2
  • Atlético Perines S. 3
15 RS Gimnástica Sub 19 B Gimnástica 1 3 0 1 2 5 7
  • DERROTA
  • CD Monte Sub 19 3
  • RS Gimnástica Sub. 2
  • DERROTA
  • RS Gimnástica Sub. 1
  • Real Racing Club S. 2
  • EMPATE
  • SD Nueva Montaña S. 2
  • RS Gimnástica Sub. 2
16 CD Colindres Sub 19 Colindres 1 3 0 1 2 5 8
  • DERROTA
  • CD Laredo Sub 19 2
  • CD Colindres Sub 1. 1
  • EMPATE
  • CD Colindres Sub 1. 2
  • CD Bezana sub 19 2
  • DERROTA
  • Bansander Sub 19 B 4
  • CD Colindres Sub 1. 2
17 CD Naval Sub 19 CD Naval Sub 19 1 3 0 1 2 4 9
  • DERROTA
  • CD Naval Sub 19 1
  • Atlético Perines S. 4
  • DERROTA
  • Marina Sport Sub 1. 4
  • CD Naval Sub 19 2
  • EMPATE
  • CD Naval Sub 19 1
  • CF Vimenor Sub 19 1
18 SD Nueva Montaña Sub 19 Nueva Montaña 1 3 0 1 2 4 9
  • DERROTA
  • SD Nueva Montaña S. 1
  • Velarde CF Sub 19 2
  • DERROTA
  • SD Solares Sub 19 5
  • SD Nueva Montaña S. 1
  • EMPATE
  • SD Nueva Montaña S. 2
  • RS Gimnástica Sub. 2
Ascenso : Solares
Descenso : CD Naval Sub 19, Nueva Montaña

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,422,568 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0020
Controller Execution Time ( Home / Category )  0.0621
Total Execution Time  0.0641
  CADENA URL  
/nacional_juvenil2024/grupo17
  GET DATOS  
$_GET['/nacional_juvenil2024/grupo17']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (13)  
0.0019  SELECT c.id, c.name, c.alias, c.stepParent, l.year FROM categories AS c INNER JOIN leagues AS l ON c.id=l.categoryId AND l.year='2024' WHERE c.parentId=112 GROUP BY c.id ORDER BY c.order_id ASC
0.0018  SELECT type,rule FROM rules WHERE categoryId = 112 ORDER BY type = 'tables_draw' DESC,type != 'extra' DESC, `order` ASC
0.0018  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-05-03 04:01:48' 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-05-03 04:01:48' 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=4 AND last_update > '2024-05-03 04:01:48' 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=3 AND last_update > '2024-05-03 04:01:48' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0038  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'nacional_juvenil' AND (l.group_code = 0 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 2024 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=0 DESC LIMIT 1
0.0024  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` = 73393 AND c.`round` = 31 ORDER BY shedule ASC LIMIT 200
0.0021  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 = 73393 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 (452767,452768,452770,452772,452774,452766,452769,452771,452773) AND ev.action in (1,2,3,4,6,11,12,13,15) ORDER BY ev.minute ASC
0.0026  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 = 73393 AND t.round = 29 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 = 73393 AND t.round = 31 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0018  SELECT data1, data2 FROM services_tags WHERE categoryId=112
0.0023  SELECT group_code, extraName from `leagues` WHERE categoryId=112 AND year=2024