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

  • UCAM Murcia Sub 19 B
  • Murcia Promises Sub 19
  • ADM Lorquí Sub 19
  • EF Torre Pacheco Sub 19
  • Real Murcia Sub 19 B
  • CD Cieza Sub 19
  • Cartagena FC Sub 19
  • Pinatar Sub 19
  • Lorca CFB Sub 19
  • CFS El Progreso Sub 19
  • CD Mediterráneo Sub 19
  • Unión Archena Sub 19
  • Unión Molinense Sub 19
  • Fútbol Base Yecla Sub 19
  • Beniaján CF Sub 19
  • Murcia Promesas Sub 19
  • Guadalupe Sub 19
  • Mar Menor CF Sub 19
Resultados
« Jornada Anterior
Jornada 30
Jornada Siguiente »
 
03 May 24
16:30 Sin comenzar 		Mar Menor CF Sub 19 Mar Menor CF Sub 19 50' Cartagena FC Sub 19 Cartagena FC Sub 19 más información ...
 
04 May 24
Sin comenzar 		CD Mediterráneo Sub 19 CD Mediterráneo Sub 19
16:00
 		Lorca CFB Sub 19 Lorca CFB Sub 19 más información ...
 
04 May 24
Sin comenzar 		Murcia Promesas Sub 19 Murcia Promesas Sub 19
18:00
 		Unión Archena Sub 19 Unión Archena Sub 19 más información ...
 
04 May 24
Sin comenzar 		EF Torre Pacheco Sub 19 EF Torre Pacheco Sub 19
18:00
 		CD Cieza Sub 19 CD Cieza Sub 19 más información ...
 
05 May 24
Sin comenzar 		Murcia Promises Sub 19 Murcia Promises Sub 19
10:00
 		Fútbol Base Yecla Sub 19 Fútbol Base Yecla más información ...
 
05 May 24
Sin comenzar 		Beniaján CF Sub 19 Beniaján CF Sub 19
12:15
 		Guadalupe Sub 19 Guadalupe Sub 19 más información ...
 
05 May 24
Sin comenzar 		UCAM Murcia Sub 19 B UCAM Murcia Sub 19 B
12:30
 		Pinatar Sub 19 Pinatar Sub 19 más información ...
 
05 May 24
Sin comenzar 		CFS El Progreso Sub 19 CFS El Progreso Sub 19
16:00
 		Real Murcia Sub 19 B Real Murcia Sub 19 B más información ...
 
05 May 24
Sin comenzar 		Unión Molinense Sub 19 Unión Molinense Sub 19
18:00
 		ADM Lorquí Sub 19 ADM Lorquí Sub 19 más información ...
Clasificación
« Jornada Anterior
Jornada 30
Jornada Siguiente »
Equipos Puntos J. G. E. P. F. C. Forma
1 UCAM Murcia Sub 19 B UCAM Murcia 66 29 21 3 5 78 33
  • VICTORIA
  • Murcia Promesas Su. 2
  • UCAM Murcia Sub 19. 4
  • VICTORIA
  • UCAM Murcia Sub 19. 6
  • Lorca CFB Sub 19 2
  • DERROTA
  • Real Murcia Sub 19. 2
  • UCAM Murcia Sub 19. 0
  • VICTORIA
  • UCAM Murcia Sub 19. 3
  • ADM Lorquí Sub 19 1
  • VICTORIA
  • Guadalupe Sub 19 1
  • UCAM Murcia Sub 19. 6
2 Murcia Promises Sub 19 Murcia Promises 65 29 20 5 4 55 19
  • VICTORIA
  • Lorca CFB Sub 19 0
  • Murcia Promises Su. 4
  • VICTORIA
  • Murcia Promises Su. 3
  • Real Murcia Sub 19. 0
  • VICTORIA
  • ADM Lorquí Sub 19 2
  • Murcia Promises Su. 3
  • VICTORIA
  • Murcia Promises Su. 3
  • Guadalupe Sub 19 1
  • VICTORIA
  • Pinatar Sub 19 0
  • Murcia Promises Su. 2
3 ADM Lorquí Sub 19 Lorquí 59 29 18 5 6 66 25
  • VICTORIA
  • ADM Lorquí Sub 19 1
  • EF Torre Pacheco S. 0
  • VICTORIA
  • Mar Menor CF Sub 1. 0
  • ADM Lorquí Sub 19 6
  • DERROTA
  • ADM Lorquí Sub 19 2
  • Murcia Promises Su. 3
  • DERROTA
  • UCAM Murcia Sub 19. 3
  • ADM Lorquí Sub 19 1
  • EMPATE
  • ADM Lorquí Sub 19 0
  • Beniaján CF Sub 19 0
4 EF Torre Pacheco Sub 19 Torre Pacheco 58 29 17 7 5 69 37
  • DERROTA
  • ADM Lorquí Sub 19 1
  • EF Torre Pacheco S. 0
  • VICTORIA
  • EF Torre Pacheco S. 4
  • Guadalupe Sub 19 2
  • VICTORIA
  • Pinatar Sub 19 3
  • EF Torre Pacheco S. 4
  • VICTORIA
  • EF Torre Pacheco S. 3
  • Fútbol Base Yecla. 0
  • EMPATE
  • Cartagena FC Sub 1. 0
  • EF Torre Pacheco S. 0
5 Real Murcia Sub 19 B Real Murcia 57 29 17 6 6 68 26
  • VICTORIA
  • Real Murcia Sub 19. 11
  • Mar Menor CF Sub 1. 0
  • DERROTA
  • Murcia Promises Su. 3
  • Real Murcia Sub 19. 0
  • VICTORIA
  • Real Murcia Sub 19. 2
  • UCAM Murcia Sub 19. 0
  • VICTORIA
  • Beniaján CF Sub 19 1
  • Real Murcia Sub 19. 2
  • VICTORIA
  • Real Murcia Sub 19. 2
  • Unión Molinense Su. 0
6 CD Cieza Sub 19 CD Cieza Sub 19 49 29 15 4 10 55 42
  • VICTORIA
  • Guadalupe Sub 19 1
  • CD Cieza Sub 19 4
  • DERROTA
  • CD Cieza Sub 19 0
  • Pinatar Sub 19 2
  • DERROTA
  • Fútbol Base Yecla. 2
  • CD Cieza Sub 19 1
  • VICTORIA
  • CD Cieza Sub 19 1
  • Cartagena FC Sub 1. 0
  • VICTORIA
  • Unión Archena Sub. 1
  • CD Cieza Sub 19 3
7 Cartagena FC Sub 19 Cartagena 47 29 14 5 10 61 43
  • DERROTA
  • Pinatar Sub 19 2
  • Cartagena FC Sub 1. 0
  • VICTORIA
  • Cartagena FC Sub 1. 3
  • Fútbol Base Yecla. 1
  • VICTORIA
  • Unión Archena Sub. 1
  • Cartagena FC Sub 1. 2
  • DERROTA
  • CD Cieza Sub 19 1
  • Cartagena FC Sub 1. 0
  • EMPATE
  • Cartagena FC Sub 1. 0
  • EF Torre Pacheco S. 0
8 Pinatar Sub 19 Pinatar Sub 19 45 29 13 6 10 44 44
  • VICTORIA
  • Pinatar Sub 19 2
  • Cartagena FC Sub 1. 0
  • VICTORIA
  • CD Cieza Sub 19 0
  • Pinatar Sub 19 2
  • DERROTA
  • Pinatar Sub 19 3
  • EF Torre Pacheco S. 4
  • VICTORIA
  • Mar Menor CF Sub 1. 0
  • Pinatar Sub 19 3
  • DERROTA
  • Pinatar Sub 19 0
  • Murcia Promises Su. 2
9 Lorca CFB Sub 19 Lorca 45 29 14 3 12 58 59
  • DERROTA
  • Lorca CFB Sub 19 0
  • Murcia Promises Su. 4
  • DERROTA
  • UCAM Murcia Sub 19. 6
  • Lorca CFB Sub 19 2
  • VICTORIA
  • Lorca CFB Sub 19 3
  • Beniaján CF Sub 19 0
  • VICTORIA
  • Unión Molinense Su. 1
  • Lorca CFB Sub 19 3
  • DERROTA
  • Lorca CFB Sub 19 2
  • CFS El Progreso Su. 3
10 CFS El Progreso Sub 19 Progreso 42 29 11 9 9 48 46
  • VICTORIA
  • CFS El Progreso Su. 1
  • Unión Molinense Su. 0
  • VICTORIA
  • CFS El Progreso Su. 1
  • Unión Archena Sub. 0
  • DERROTA
  • CD Mediterráneo Su. 2
  • CFS El Progreso Su. 1
  • EMPATE
  • CFS El Progreso Su. 2
  • Murcia Promesas Su. 2
  • VICTORIA
  • Lorca CFB Sub 19 2
  • CFS El Progreso Su. 3
11 CD Mediterráneo Sub 19 Mediterráneo 40 29 11 7 11 51 50
  • VICTORIA
  • CD Mediterráneo Su. 4
  • Beniaján CF Sub 19 3
  • DERROTA
  • Unión Molinense Su. 4
  • CD Mediterráneo Su. 1
  • VICTORIA
  • CD Mediterráneo Su. 2
  • CFS El Progreso Su. 1
  • EMPATE
  • CD Mediterráneo Su. 2
  • Unión Archena Sub. 2
  • VICTORIA
  • Murcia Promesas Su. 0
  • CD Mediterráneo Su. 4
12 Unión Archena Sub 19 Unión Archena 36 29 9 9 11 56 41
  • VICTORIA
  • Unión Archena Sub. 3
  • Fútbol Base Yecla. 2
  • DERROTA
  • CFS El Progreso Su. 1
  • Unión Archena Sub. 0
  • DERROTA
  • Unión Archena Sub. 1
  • Cartagena FC Sub 1. 2
  • EMPATE
  • CD Mediterráneo Su. 2
  • Unión Archena Sub. 2
  • DERROTA
  • Unión Archena Sub. 1
  • CD Cieza Sub 19 3
13 Unión Molinense Sub 19 Unión Molinense 35 29 10 5 14 49 49
  • DERROTA
  • CFS El Progreso Su. 1
  • Unión Molinense Su. 0
  • VICTORIA
  • Unión Molinense Su. 4
  • CD Mediterráneo Su. 1
  • EMPATE
  • Murcia Promesas Su. 2
  • Unión Molinense Su. 2
  • DERROTA
  • Unión Molinense Su. 1
  • Lorca CFB Sub 19 3
  • DERROTA
  • Real Murcia Sub 19. 2
  • Unión Molinense Su. 0
14 Fútbol Base Yecla Sub 19 Fútbol Base Yec. 31 29 9 4 16 38 54
  • DERROTA
  • Unión Archena Sub. 3
  • Fútbol Base Yecla. 2
  • DERROTA
  • Cartagena FC Sub 1. 3
  • Fútbol Base Yecla. 1
  • VICTORIA
  • Fútbol Base Yecla. 2
  • CD Cieza Sub 19 1
  • DERROTA
  • EF Torre Pacheco S. 3
  • Fútbol Base Yecla. 0
  • VICTORIA
  • Fútbol Base Yecla. 4
  • Mar Menor CF Sub 1. 0
15 Beniaján CF Sub 19 Beniaján 24 29 6 6 17 38 63
  • DERROTA
  • CD Mediterráneo Su. 4
  • Beniaján CF Sub 19 3
  • DERROTA
  • Beniaján CF Sub 19 0
  • Murcia Promesas Su. 3
  • DERROTA
  • Lorca CFB Sub 19 3
  • Beniaján CF Sub 19 0
  • DERROTA
  • Beniaján CF Sub 19 1
  • Real Murcia Sub 19. 2
  • EMPATE
  • ADM Lorquí Sub 19 0
  • Beniaján CF Sub 19 0
16 Murcia Promesas Sub 19 Murcia Promesas 22 29 4 10 15 34 58
  • DERROTA
  • Murcia Promesas Su. 2
  • UCAM Murcia Sub 19. 4
  • VICTORIA
  • Beniaján CF Sub 19 0
  • Murcia Promesas Su. 3
  • EMPATE
  • Murcia Promesas Su. 2
  • Unión Molinense Su. 2
  • EMPATE
  • CFS El Progreso Su. 2
  • Murcia Promesas Su. 2
  • DERROTA
  • Murcia Promesas Su. 0
  • CD Mediterráneo Su. 4
17 Guadalupe Sub 19 Guadalupe 12 29 3 3 23 39 97
  • DERROTA
  • Guadalupe Sub 19 1
  • CD Cieza Sub 19 4
  • DERROTA
  • EF Torre Pacheco S. 4
  • Guadalupe Sub 19 2
  • VICTORIA
  • Guadalupe Sub 19 5
  • Mar Menor CF Sub 1. 1
  • DERROTA
  • Murcia Promises Su. 3
  • Guadalupe Sub 19 1
  • DERROTA
  • Guadalupe Sub 19 1
  • UCAM Murcia Sub 19. 6
18 Mar Menor CF Sub 19 Menor 1 29 0 1 28 21 142
  • DERROTA
  • Real Murcia Sub 19. 11
  • Mar Menor CF Sub 1. 0
  • DERROTA
  • Mar Menor CF Sub 1. 0
  • ADM Lorquí Sub 19 6
  • DERROTA
  • Guadalupe Sub 19 5
  • Mar Menor CF Sub 1. 1
  • DERROTA
  • Mar Menor CF Sub 1. 0
  • Pinatar Sub 19 3
  • DERROTA
  • Fútbol Base Yecla. 4
  • Mar Menor CF Sub 1. 0
Ascenso : UCAM Murcia
Descenso : Murcia Promesas, Guadalupe, Menor

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,420,520 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0018
Controller Execution Time ( Home / Category )  0.0833
Total Execution Time  0.0852
  CADENA URL  
/nacional_juvenil/grupo10
  GET DATOS  
$_GET['/nacional_juvenil/grupo10']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (17)  
0.0041  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 = 10 OR l.group_code = 1 OR l.group_code = 0) ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=10 DESC LIMIT 1
0.0021  SELECT dt.nameShow,dt.basealias,t.id,t.teamId FROM teams t INNER JOIN datateams dt ON t.teamId = dt.id WHERE t.league_id = 73386 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0018  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-05-03 15:35:50' 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 15:35:50' 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 15:35:50' 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 15:35:50' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0025  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.0021  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=73386 AND rel.round=30
0.0018  SELECT fau.user_name, c.*, NOW() as difference_time,creation_date FROM (leagues as l) INNER JOIN comments as c ON c.league_id = l.id LEFT JOIN fa_user fau ON fau.id = c.author_id WHERE c.creation_date > "2024-04-03" AND c.`active`= 1 and c.comment_id is null and c.lang = 1 AND l.`id` = 73386 ORDER BY creation_date DESC LIMIT 0, 10
0.0024  SELECT count(c.id) as cuenta FROM (leagues as l) INNER JOIN comments as c ON c.league_id = l.id WHERE c.creation_date > "2024-04-03" AND c.`active`= 1 and comment_id is null and c.lang = 1 AND l.`id` = 73386
0.0021  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` = 73386 AND c.`round` = 30 ORDER BY shedule ASC LIMIT 200
0.0097  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 = 73386 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 (497950,497947,497948,497949,497944,497945,497951,497946,497952) AND ev.action in (1,2,3,4,6,11,12,13,15) ORDER BY ev.minute ASC
0.0025  SELECT 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.show_on = 1 AND e.real_date IS NOT NULL AND e.league_id = 73386 AND e.real_date > NOW() - INTERVAL 1 MONTH ORDER BY e.real_date DESC LIMIT 30
0.0049  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 = 73386 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.0018  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 = 73386 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.0026  SELECT data1, data2 FROM services_tags WHERE categoryId=112
0.0026  SELECT group_code, extraName from `leagues` WHERE categoryId=112 AND year=2024