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
Primera División Futsal
2023/2024

Primera División Futsal

  • Barça
  • ElPozo Murcia Costa Cálida
  • Jaén FS
  • Inter FS
  • Jimbee Cartagena
  • Palma Futsal
  • Viña Albali Valdepeñas
  • Manzanares FS
  • Industrias Santa Coloma
  • Córdoba Patrimonio
  • Osasuna Magna
  • Peñíscola FS
  • Noia Portus Apostoli
  • Ribera Navarra FS
  • Real Betis Futsal
  • Alzira FS
Resultados
« Jornada Anterior
Jornada 29
Jornada Siguiente »
23 Abr 24
20:30 Finalizado 		Barça Barça 8-6 Jimbee Cartagena Jimbee Cartagena más información ...
24 Abr 24
20:00 Finalizado 		Palma Futsal Palma Futsal 5-5 Peñíscola FS Peñíscola FS más información ...
03 May 24
19:30 Finalizado 		Osasuna Magna Osasuna Magna 3-2 Córdoba Patrimonio Córdoba Patrimonio más información ...
03 May 24
21:00 Finalizado 		ElPozo Murcia Costa Cálida ElPozo Murcia Costa Cál. 8-5 Industrias Santa Coloma Industrias Santa Coloma más información ...
04 May 24
19:00 Finalizado 		Jaén FS Jaén FS 6-3 Ribera Navarra FS Ribera Navarra FS más información ...
04 May 24
19:00 Finalizado 		Alzira FS Alzira FS 4-3 Manzanares FS Manzanares FS más información ...
04 May 24
19:00 Finalizado 		Noia Portus Apostoli Noia Portus Apostoli 4-2 Real Betis Futsal Real Betis Futsal más información 1
04 May 24
21:00 Finalizado 		Viña Albali Valdepeñas Viña Albali Valdepeñas 3-1 Inter FS Inter FS más información ...
Clasificación
« Jornada Anterior
Jornada 29
Jornada Siguiente »
Equipos Puntos J. G. E. P. F. C. Forma
1 Barça Barça 60 29 19 3 7 102 82
  • VICTORIA
  • Barça 6
  • Industrias Santa C. 4
  • EMPATE
  • Manzanares FS 3
  • Barça 3
  • DERROTA
  • Barça 2
  • Real Betis Futsal 4
  • VICTORIA
  • Barça 8
  • Jimbee Cartagena 6
  • VICTORIA
  • Inter FS 2
  • Barça 3
2 ElPozo Murcia Costa Cálida ElPozo Murcia C. 58 29 17 7 5 113 75
  • DERROTA
  • Peñíscola FS 5
  • ElPozo Murcia Cost. 1
  • VICTORIA
  • Jaén FS 2
  • ElPozo Murcia Cost. 3
  • EMPATE
  • ElPozo Murcia Cost. 2
  • Palma Futsal 2
  • VICTORIA
  • Ribera Navarra FS 2
  • ElPozo Murcia Cost. 3
  • VICTORIA
  • ElPozo Murcia Cost. 8
  • Industrias Santa C. 5
3 Jaén FS Jaén FS 54 29 17 3 9 95 69
  • VICTORIA
  • Alzira FS 1
  • Jaén FS 3
  • DERROTA
  • Jaén FS 2
  • ElPozo Murcia Cost. 3
  • EMPATE
  • Peñíscola FS 2
  • Jaén FS 2
  • VICTORIA
  • Palma Futsal 1
  • Jaén FS 2
  • VICTORIA
  • Jaén FS 6
  • Ribera Navarra FS 3
4 Inter FS Inter FS 50 29 15 5 9 106 74
  • VICTORIA
  • Jimbee Cartagena 1
  • Inter FS 8
  • VICTORIA
  • Inter FS 7
  • Córdoba Patrimonio 2
  • VICTORIA
  • Osasuna Magna 3
  • Inter FS 6
  • DERROTA
  • Inter FS 2
  • Barça 3
  • DERROTA
  • Viña Albali Valdep. 3
  • Inter FS 1
5 Jimbee Cartagena Jimbee Cartagena 48 29 13 9 7 94 81
  • DERROTA
  • Jimbee Cartagena 1
  • Inter FS 8
  • EMPATE
  • Jimbee Cartagena 5
  • Peñíscola FS 5
  • EMPATE
  • Córdoba Patrimonio 2
  • Jimbee Cartagena 2
  • DERROTA
  • Barça 8
  • Jimbee Cartagena 6
  • VICTORIA
  • Jimbee Cartagena 7
  • Osasuna Magna 0
6 Palma Futsal Palma Futsal 48 29 15 3 11 106 96
  • DERROTA
  • Noia Portus Aposto. 6
  • Palma Futsal 1
  • VICTORIA
  • Palma Futsal 6
  • Alzira FS 2
  • EMPATE
  • ElPozo Murcia Cost. 2
  • Palma Futsal 2
  • EMPATE
  • Palma Futsal 5
  • Peñíscola FS 5
  • DERROTA
  • Palma Futsal 1
  • Jaén FS 2
7 Viña Albali Valdepeñas Viña Albali Val. 45 29 12 9 8 97 85
  • EMPATE
  • Viña Albali Valdep. 3
  • Ribera Navarra FS 3
  • DERROTA
  • Industrias Santa C. 4
  • Viña Albali Valdep. 3
  • EMPATE
  • Viña Albali Valdep. 1
  • Manzanares FS 1
  • VICTORIA
  • Real Betis Futsal 3
  • Viña Albali Valdep. 5
  • VICTORIA
  • Viña Albali Valdep. 3
  • Inter FS 1
8 Manzanares FS Manzanares FS 45 29 13 6 10 104 99
  • EMPATE
  • Osasuna Magna 2
  • Manzanares FS 2
  • EMPATE
  • Manzanares FS 3
  • Barça 3
  • EMPATE
  • Viña Albali Valdep. 1
  • Manzanares FS 1
  • VICTORIA
  • Manzanares FS 6
  • Noia Portus Aposto. 5
  • DERROTA
  • Alzira FS 4
  • Manzanares FS 3
9 Industrias Santa Coloma Industrias Santa 41 29 12 5 12 101 102
  • DERROTA
  • Barça 6
  • Industrias Santa C. 4
  • VICTORIA
  • Industrias Santa C. 4
  • Viña Albali Valdep. 3
  • DERROTA
  • Noia Portus Aposto. 4
  • Industrias Santa C. 3
  • VICTORIA
  • Industrias Santa C. 3
  • Alzira FS 2
  • DERROTA
  • ElPozo Murcia Cost. 8
  • Industrias Santa C. 5
10 Córdoba Patrimonio Córdoba 34 29 10 4 15 82 96
  • VICTORIA
  • Córdoba Patrimonio 4
  • Real Betis Futsal 1
  • DERROTA
  • Inter FS 7
  • Córdoba Patrimonio 2
  • EMPATE
  • Córdoba Patrimonio 2
  • Jimbee Cartagena 2
  • VICTORIA
  • Córdoba Patrimonio 5
  • Peñíscola FS 4
  • DERROTA
  • Osasuna Magna 3
  • Córdoba Patrimonio 2
11 Osasuna Magna Osasuna Magna 34 29 9 7 13 74 92
  • EMPATE
  • Osasuna Magna 2
  • Manzanares FS 2
  • EMPATE
  • Real Betis Futsal 3
  • Osasuna Magna 3
  • DERROTA
  • Osasuna Magna 3
  • Inter FS 6
  • DERROTA
  • Jimbee Cartagena 7
  • Osasuna Magna 0
  • VICTORIA
  • Osasuna Magna 3
  • Córdoba Patrimonio 2
12 Peñíscola FS Peñíscola FS 33 29 8 9 12 109 105
  • VICTORIA
  • Peñíscola FS 5
  • ElPozo Murcia Cost. 1
  • EMPATE
  • Jimbee Cartagena 5
  • Peñíscola FS 5
  • EMPATE
  • Peñíscola FS 2
  • Jaén FS 2
  • EMPATE
  • Palma Futsal 5
  • Peñíscola FS 5
  • DERROTA
  • Córdoba Patrimonio 5
  • Peñíscola FS 4
13 Noia Portus Apostoli Noia Portus Apo. 30 29 9 3 17 96 108
  • VICTORIA
  • Noia Portus Aposto. 6
  • Palma Futsal 1
  • VICTORIA
  • Ribera Navarra FS 2
  • Noia Portus Aposto. 7
  • VICTORIA
  • Noia Portus Aposto. 4
  • Industrias Santa C. 3
  • DERROTA
  • Manzanares FS 6
  • Noia Portus Aposto. 5
  • VICTORIA
  • Noia Portus Aposto. 4
  • Real Betis Futsal 2
14 Ribera Navarra FS Ribera Navarra 24 29 5 9 15 76 96
  • EMPATE
  • Viña Albali Valdep. 3
  • Ribera Navarra FS 3
  • DERROTA
  • Ribera Navarra FS 2
  • Noia Portus Aposto. 7
  • VICTORIA
  • Alzira FS 2
  • Ribera Navarra FS 4
  • DERROTA
  • Ribera Navarra FS 2
  • ElPozo Murcia Cost. 3
  • DERROTA
  • Jaén FS 6
  • Ribera Navarra FS 3
15 Real Betis Futsal Real Betis Futs. 24 29 7 3 19 75 126
  • DERROTA
  • Córdoba Patrimonio 4
  • Real Betis Futsal 1
  • EMPATE
  • Real Betis Futsal 3
  • Osasuna Magna 3
  • VICTORIA
  • Barça 2
  • Real Betis Futsal 4
  • DERROTA
  • Real Betis Futsal 3
  • Viña Albali Valdep. 5
  • DERROTA
  • Noia Portus Aposto. 4
  • Real Betis Futsal 2
16 Alzira FS Alzira FS 23 29 6 5 18 62 106
  • DERROTA
  • Alzira FS 1
  • Jaén FS 3
  • DERROTA
  • Palma Futsal 6
  • Alzira FS 2
  • DERROTA
  • Alzira FS 2
  • Ribera Navarra FS 4
  • DERROTA
  • Industrias Santa C. 3
  • Alzira FS 2
  • VICTORIA
  • Alzira FS 4
  • Manzanares FS 3
Playoff Título : Barça, ElPozo Murcia C., Jaén FS, Inter FS, Jimbee Cartagena, Palma Futsal, Viña Albali Val., Manzanares FS
Descenso : Real Betis Futs., Alzira FS

INFORMACIÓN

La Liga Nacional de Fútbol Sala es conocida como (LNFS), asociación deportiva española de fútbol sala. Fue fundada en 1989.


En la Liga Nacional de Fútbol Sala se incluye la División de Honor y la División de Plata.


  USO DE MEMORIA  
5,300,968 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0039
Controller Execution Time ( Home / Category )  0.0918
Total Execution Time  0.0957
  CADENA URL  
/primera_division_futsal/grupo1/jornada1?section=legal
  GET DATOS  
$_GET['/primera_division_futsal/grupo1/jornada1']  
$_GET['section']   legal
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (12)  
0.0018  SELECT type FROM routes WHERE alias = 'primera_division_futsal'
0.0050  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'primera_division_futsal' AND (l.group_code = 1 OR l.group_code = 1 OR l.group_code = 0) ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=1 DESC LIMIT 1
0.0028  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-05-05 10:32:20' 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=2 AND last_update > '2024-05-05 10:32:20' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0039  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=4 AND last_update > '2024-05-05 10:32:20' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0026  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=3 AND last_update > '2024-05-05 10:32:20' GROUP BY url ORDER BY page_views DESC LIMIT 5
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` = 73234 AND c.`round` = 29 ORDER BY shedule ASC LIMIT 200
0.0031  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 = 73234 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 (431277,431271,431278,431273,431272,431274,431275,431276) AND ev.action in (1,2,3,4,6,11,12,13,15) ORDER BY ev.minute ASC
0.0068  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 = 73234 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.0045  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 = 73234 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.0018  SELECT data1, data2 FROM services_tags WHERE categoryId=108
0.0021  SELECT group_code, extraName from `leagues` WHERE categoryId=108 AND year=2024