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
2023/2024

Liga Nacional

  • UD Logroñés Sub 19 B
  • Valvanera CD Sub 19
  • CD Villegas Sub 19
  • CD Berceo Sub 19 B
  • CD Alfaro Sub 19
  • La Calzada Sub 19
  • CD Calahorra Sub 19
  • EF Mareo Sub 19
  • SD Logroñés Sub 19
  • CD Pradejón Sub 19
  • SD Oyonesa Sub 19
  • CA River Ebro Sub 19
  • Comillas Sub 19
  • Varea Sub 19
  • Autol Sub 19
  • Arnedo Sub 19
Resultados
« Jornada Anterior
Jornada 30
 
 
12 May 24
Sin comenzar 		Arnedo Sub 19 Arnedo Sub 19 x-x CD Pradejón Sub 19 CD Pradejón Sub 19 más información ...
 
12 May 24
Sin comenzar 		Comillas Sub 19 Comillas Sub 19 x-x UD Logroñés Sub 19 B UD Logroñés Sub 19 B más información ...
 
12 May 24
Sin comenzar 		CD Alfaro Sub 19 CD Alfaro Sub 19 x-x SD Logroñés Sub 19 SD Logroñés Sub 19 más información ...
 
12 May 24
Sin comenzar 		CD Villegas Sub 19 CD Villegas Sub 19 x-x La Calzada Sub 19 La Calzada Sub 19 más información ...
 
12 May 24
Sin comenzar 		CD Calahorra Sub 19 CD Calahorra Sub 19 x-x Valvanera CD Sub 19 Valvanera CD Sub 19 más información ...
 
12 May 24
Sin comenzar 		Varea Sub 19 Varea Sub 19 x-x CA River Ebro Sub 19 CA River Ebro Sub 19 más información ...
 
12 May 24
Sin comenzar 		SD Oyonesa Sub 19 SD Oyonesa Sub 19 x-x EF Mareo Sub 19 EF Mareo Sub 19 más información ...
 
12 May 24
Sin comenzar 		CD Berceo Sub 19 B CD Berceo Sub 19 B x-x Autol Sub 19 Autol Sub 19 más información ...
Clasificación
« Jornada Anterior
Jornada 30
 
Equipos Puntos J. G. E. P. F. C.
1 UD Logroñés Sub 19 B Logroñés 60 27 18 6 3 77 37
  • EMPATE
  • CA River Ebro Sub. 1
  • UD Logroñés Sub 19. 1
  • VICTORIA
  • UD Logroñés Sub 19. 4
  • Valvanera CD Sub 1. 2
  • DERROTA
  • La Calzada Sub 19 2
  • UD Logroñés Sub 19. 1
  • DERROTA
  • UD Logroñés Sub 19. 1
  • SD Logroñés Sub 19 2
  • EMPATE
  • CD Berceo Sub 19 B 1
  • UD Logroñés Sub 19. 1
2 Valvanera CD Sub 19 Valvanera 58 27 19 1 7 65 28
  • VICTORIA
  • Valvanera CD Sub 1. 2
  • SD Logroñés Sub 19 0
  • DERROTA
  • UD Logroñés Sub 19. 4
  • Valvanera CD Sub 1. 2
  • VICTORIA
  • Valvanera CD Sub 1. 4
  • CD Pradejón Sub 19 0
  • VICTORIA
  • Arnedo Sub 19 0
  • Valvanera CD Sub 1. 3
  • VICTORIA
  • Valvanera CD Sub 1. 2
  • Comillas Sub 19 0
3 CD Villegas Sub 19 Villegas 53 27 16 5 6 64 36
  • DERROTA
  • CD Calahorra Sub 1. 3
  • CD Villegas Sub 19 2
  • VICTORIA
  • CD Villegas Sub 19 5
  • Varea Sub 19 2
  • VICTORIA
  • SD Oyonesa Sub 19 1
  • CD Villegas Sub 19 2
  • VICTORIA
  • CD Villegas Sub 19 4
  • Autol Sub 19 1
  • VICTORIA
  • EF Mareo Sub 19 0
  • CD Villegas Sub 19 3
4 CD Berceo Sub 19 B Berceo 48 27 14 6 7 52 36
  • VICTORIA
  • CD Berceo Sub 19 B 1
  • La Calzada Sub 19 0
  • VICTORIA
  • CD Calahorra Sub 1. 0
  • CD Berceo Sub 19 B 4
  • DERROTA
  • CD Berceo Sub 19 B 1
  • SD Logroñés Sub 19 3
  • EMPATE
  • Varea Sub 19 1
  • CD Berceo Sub 19 B 1
  • EMPATE
  • CD Berceo Sub 19 B 1
  • UD Logroñés Sub 19. 1
5 CD Alfaro Sub 19 Alfaro 48 27 15 3 9 44 33
  • VICTORIA
  • Varea Sub 19 1
  • CD Alfaro Sub 19 4
  • VICTORIA
  • CD Alfaro Sub 19 4
  • SD Oyonesa Sub 19 1
  • DERROTA
  • Autol Sub 19 5
  • CD Alfaro Sub 19 2
  • DERROTA
  • CD Alfaro Sub 19 0
  • EF Mareo Sub 19 2
  • VICTORIA
  • CA River Ebro Sub. 1
  • CD Alfaro Sub 19 2
6 La Calzada Sub 19 Calzada 47 27 15 2 10 49 39
  • DERROTA
  • CD Berceo Sub 19 B 1
  • La Calzada Sub 19 0
  • DERROTA
  • SD Logroñés Sub 19 5
  • La Calzada Sub 19 2
  • VICTORIA
  • La Calzada Sub 19 2
  • UD Logroñés Sub 19. 1
  • EMPATE
  • CD Pradejón Sub 19 1
  • La Calzada Sub 19 1
  • VICTORIA
  • La Calzada Sub 19 2
  • Arnedo Sub 19 0
7 CD Calahorra Sub 19 Calahorra 43 27 12 7 8 52 40
  • VICTORIA
  • CD Calahorra Sub 1. 3
  • CD Villegas Sub 19 2
  • DERROTA
  • CD Calahorra Sub 1. 0
  • CD Berceo Sub 19 B 4
  • EMPATE
  • Varea Sub 19 0
  • CD Calahorra Sub 1. 0
  • VICTORIA
  • CD Calahorra Sub 1. 3
  • SD Oyonesa Sub 19 0
  • VICTORIA
  • Autol Sub 19 3
  • CD Calahorra Sub 1. 7
8 EF Mareo Sub 19 EF Mareo Sub 19 41 27 12 5 10 38 34
  • VICTORIA
  • EF Mareo Sub 19 4
  • CD Pradejón Sub 19 2
  • VICTORIA
  • Arnedo Sub 19 0
  • EF Mareo Sub 19 3
  • EMPATE
  • EF Mareo Sub 19 1
  • Comillas Sub 19 1
  • VICTORIA
  • CD Alfaro Sub 19 0
  • EF Mareo Sub 19 2
  • DERROTA
  • EF Mareo Sub 19 0
  • CD Villegas Sub 19 3
9 SD Logroñés Sub 19 Logroñés 40 27 12 4 11 67 55
  • DERROTA
  • Valvanera CD Sub 1. 2
  • SD Logroñés Sub 19 0
  • VICTORIA
  • SD Logroñés Sub 19 5
  • La Calzada Sub 19 2
  • VICTORIA
  • CD Berceo Sub 19 B 1
  • SD Logroñés Sub 19 3
  • VICTORIA
  • UD Logroñés Sub 19. 1
  • SD Logroñés Sub 19 2
  • EMPATE
  • SD Logroñés Sub 19 2
  • CD Pradejón Sub 19 2
10 CD Pradejón Sub 19 Pradejón 38 27 10 8 9 46 46
  • DERROTA
  • EF Mareo Sub 19 4
  • CD Pradejón Sub 19 2
  • VICTORIA
  • CD Pradejón Sub 19 3
  • CA River Ebro Sub. 0
  • DERROTA
  • Valvanera CD Sub 1. 4
  • CD Pradejón Sub 19 0
  • EMPATE
  • CD Pradejón Sub 19 1
  • La Calzada Sub 19 1
  • EMPATE
  • SD Logroñés Sub 19 2
  • CD Pradejón Sub 19 2
11 SD Oyonesa Sub 19 Oyonesa 34 27 10 4 13 52 49
  • DERROTA
  • SD Oyonesa Sub 19 1
  • Comillas Sub 19 3
  • DERROTA
  • CD Alfaro Sub 19 4
  • SD Oyonesa Sub 19 1
  • DERROTA
  • SD Oyonesa Sub 19 1
  • CD Villegas Sub 19 2
  • DERROTA
  • CD Calahorra Sub 1. 3
  • SD Oyonesa Sub 19 0
  • DERROTA
  • SD Oyonesa Sub 19 0
  • Varea Sub 19 1
12 CA River Ebro Sub 19 River Ebro 27 27 7 6 14 37 44
  • EMPATE
  • CA River Ebro Sub. 1
  • UD Logroñés Sub 19. 1
  • DERROTA
  • CD Pradejón Sub 19 3
  • CA River Ebro Sub. 0
  • DERROTA
  • CA River Ebro Sub. 1
  • Arnedo Sub 19 2
  • DERROTA
  • Comillas Sub 19 3
  • CA River Ebro Sub. 2
  • DERROTA
  • CA River Ebro Sub. 1
  • CD Alfaro Sub 19 2
13 Comillas Sub 19 Comillas Sub 19 25 27 6 7 14 37 53
  • VICTORIA
  • SD Oyonesa Sub 19 1
  • Comillas Sub 19 3
  • EMPATE
  • Comillas Sub 19 3
  • Autol Sub 19 3
  • EMPATE
  • EF Mareo Sub 19 1
  • Comillas Sub 19 1
  • VICTORIA
  • Comillas Sub 19 3
  • CA River Ebro Sub. 2
  • DERROTA
  • Valvanera CD Sub 1. 2
  • Comillas Sub 19 0
14 Varea Sub 19 Varea Sub 19 22 27 4 10 13 30 61
  • DERROTA
  • Varea Sub 19 1
  • CD Alfaro Sub 19 4
  • DERROTA
  • CD Villegas Sub 19 5
  • Varea Sub 19 2
  • EMPATE
  • Varea Sub 19 0
  • CD Calahorra Sub 1. 0
  • EMPATE
  • Varea Sub 19 1
  • CD Berceo Sub 19 B 1
  • VICTORIA
  • SD Oyonesa Sub 19 0
  • Varea Sub 19 1
15 Autol Sub 19 Autol Sub 19 13 27 3 4 20 28 87
  • VICTORIA
  • Autol Sub 19 1
  • Arnedo Sub 19 0
  • EMPATE
  • Comillas Sub 19 3
  • Autol Sub 19 3
  • VICTORIA
  • Autol Sub 19 5
  • CD Alfaro Sub 19 2
  • DERROTA
  • CD Villegas Sub 19 4
  • Autol Sub 19 1
  • DERROTA
  • Autol Sub 19 3
  • CD Calahorra Sub 1. 7
16 Arnedo Sub 19 Arnedo Sub 19 11 27 3 2 22 18 78
  • DERROTA
  • Autol Sub 19 1
  • Arnedo Sub 19 0
  • DERROTA
  • Arnedo Sub 19 0
  • EF Mareo Sub 19 3
  • VICTORIA
  • CA River Ebro Sub. 1
  • Arnedo Sub 19 2
  • DERROTA
  • Arnedo Sub 19 0
  • Valvanera CD Sub 1. 3
  • DERROTA
  • La Calzada Sub 19 2
  • Arnedo Sub 19 0
Ascenso : Logroñés
Descenso : Autol Sub 19, Arnedo Sub 19

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.

Liga Nacional

27 Abr 24 17:00
La Molineta
27 Abr 24 18:00
Municipal La Ribera
27 Abr 24 18:15
28 Abr 24 11:30
Complejo Deportivo Municipal La Planilla
28 Abr 24 12:00
Campos De Fútbol Mundial 82

  USO DE MEMORIA  
5,338,720 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0030
Controller Execution Time ( Home / Category )  0.2427
Total Execution Time  0.2457
  CADENA URL  
/nacional_juvenil/grupo5/jornada30
  GET DATOS  
$_GET['/nacional_juvenil/grupo5/jornada30']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (13)  
0.0105  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-04-27 15:51:42' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0105  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=2 AND last_update > '2024-04-27 15:51:42' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0105  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=4 AND last_update > '2024-04-27 15:51:42' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0106  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=3 AND last_update > '2024-04-27 15:51:42' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0106  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=73382 AND rel.round=30
0.0110  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` = 73382 AND c.`round` = 30 ORDER BY shedule ASC LIMIT 200
0.0108  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 = 73382 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 (567604,567605,567606,567607,567608,567609,567610,567611) AND ev.action in (1,2,3,4,6,11,12,13,15) ORDER BY ev.minute ASC
0.0120  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 = 30 AND e.real_date IS NOT NULL AND e.league_id = 73382 ORDER BY total DESC LIMIT 40
0.0111  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 = 73382 AND t.round = 28 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0219  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 = 73382 AND t.round = 30 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0109  SELECT distinct(shedule), round FROM `calendars2024` as c WHERE c.`league_id` = 73382 AND shedule >= '2024/05/01' AND shedule < '2024/06/01' ORDER BY shedule ASC
0.0105  SELECT data1, data2 FROM services_tags WHERE categoryId=112
0.0110  SELECT group_code, extraName from `leagues` WHERE categoryId=112 AND year=2024