Publicidad 600x120.gif
Primera División Femenino Futsal
2023/2024

Primera División Femenino Futsal

  • LBTL Alcantarilla
  • MSC Torreblanca FS
  • FSF Móstoles
  • Roldán FSF
  • Burela FS
  • AD Alcorcón
  • FSF Castro
  • Ourense CF
  • AE Les Corts
  • Viaxes Amarelle
  • Futsi Atlético
  • Rayo Majadahonda FS
  • Marín Fútsal
  • Poio FS
  • Nueces de Ronda Atl. Torcal
  • CD Leganés
 
16 Sep 23
16:00 Finalizado
MSC Torreblanca FS MSC Torreblanca FS 6-0 CD Leganés CD Leganés más información ...
 
16 Sep 23
16:30 Finalizado
AE Les Corts AE Les Corts 2-2 Viaxes Amarelle Viaxes Amarelle más información ...
 
16 Sep 23
17:00 Finalizado
Marín Fútsal Marín Fútsal 1-3 Roldán FSF Roldán FSF más información ...
 
16 Sep 23
18:00 Finalizado
LBTL Alcantarilla LBTL Alcantarilla 7-1 Nueces de Ronda Atl. Torcal Nueces Ronda Atl. Torcal más información ...
 
16 Sep 23
18:30 Finalizado
Burela FS Burela FS 2-0 Poio FS Poio FS más información ...
 
16 Sep 23
19:30 Finalizado
AD Alcorcón AD Alcorcón 5-4 Futsi Atlético Futsi Atlético más información ...
 
16 Sep 23
20:00 Finalizado
FSF Castro FSF Castro 3-3 Ourense CF Ourense CF más información ...
 
16 Sep 23
20:45 Finalizado
FSF Móstoles FSF Móstoles 4-2 Rayo Majadahonda FS Rayo Majadahonda FS más información ...
Equipos Puntos J. G. E. P. F. C. Forma
1 LBTL Alcantarilla LBTL 3 1 1 0 0 7 1
  • VICTORIA
  • LBTL Alcantarilla 7
  • Nueces de Ronda At. 1
2 MSC Torreblanca FS Torreblanca 3 1 1 0 0 6 0
  • VICTORIA
  • MSC Torreblanca FS 6
  • CD Leganés 0
3 FSF Móstoles FSF Móstoles 3 1 1 0 0 4 2
  • VICTORIA
  • FSF Móstoles 4
  • Rayo Majadahonda F. 2
4 Roldán FSF Roldán FSF 3 1 1 0 0 3 1
  • VICTORIA
  • Marín Fútsal 1
  • Roldán FSF 3
5 Burela FS Burela FS 3 1 1 0 0 2 0
  • VICTORIA
  • Burela FS 2
  • Poio FS 0
6 AD Alcorcón AD Alcorcón 3 1 1 0 0 5 4
  • VICTORIA
  • AD Alcorcón 5
  • Futsi Atlético 4
7 FSF Castro FSF Castro 1 1 0 1 0 3 3
  • EMPATE
  • FSF Castro 3
  • Ourense CF 3
8 Ourense CF Ourense CF 1 1 0 1 0 3 3
  • EMPATE
  • FSF Castro 3
  • Ourense CF 3
9 AE Les Corts AE Les Corts 1 1 0 1 0 2 2
  • EMPATE
  • AE Les Corts 2
  • Viaxes Amarelle 2
10 Viaxes Amarelle Viaxes Amarelle 1 1 0 1 0 2 2
  • EMPATE
  • AE Les Corts 2
  • Viaxes Amarelle 2
11 Futsi Atlético Futsi Atlético 0 1 0 0 1 4 5
  • DERROTA
  • AD Alcorcón 5
  • Futsi Atlético 4
12 Rayo Majadahonda FS Rayo Majadahonda 0 1 0 0 1 2 4
  • DERROTA
  • FSF Móstoles 4
  • Rayo Majadahonda F. 2
13 Marín Fútsal Marín Fútsal 0 1 0 0 1 1 3
  • DERROTA
  • Marín Fútsal 1
  • Roldán FSF 3
14 Poio FS Poio FS 0 1 0 0 1 0 2
  • DERROTA
  • Burela FS 2
  • Poio FS 0
15 Nueces de Ronda Atl. Torcal Nueces Ronda At. 0 1 0 0 1 1 7
  • DERROTA
  • LBTL Alcantarilla 7
  • Nueces de Ronda At. 1
16 CD Leganés CD Leganés 0 1 0 0 1 0 6
  • DERROTA
  • MSC Torreblanca FS 6
  • CD Leganés 0
Playoff Título : LBTL, Torreblanca, FSF Móstoles, Roldán FSF
Descenso : Poio FS, Nueces Ronda At., CD Leganés

INFORMACIÓN
La Primera División de fútbol sala (desde 1989 hasta 2011 denominada División de Honor de fútbol sala), conocida por razones de patrocinio como Liga Marca de Fútbol Sala, es la máxima categoría de fútbol sala en España, organizada por la Liga Nacional de Fútbol Sala. Se encuentra por encima de la Segunda División, y se disputa desde 1989.
Uso de cookies: Utilizamos "cookies" propias y de terceros para mejorar nuestros servicios, elaborar información estadística, analizar sus hábitos de navegación e inferir grupos de interés. Esto nos permite personalizar el contenido que ofrecemos y mostrarle publicidad relacionada con sus preferencias. Adicionalmente, compartimos los análisis de navegación y los grupos de interés inferidos con terceros. Si continúa navegando acepta su uso. Más información y cambio de configuración. Aceptar

  USO DE MEMORIA  
5,073,288 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0032
Controller Execution Time ( Home / Category )  0.2942
Total Execution Time  0.2975
  CADENA URL  
/primera_division_femenino_futsal/grupo1/jornada1
  GET DATOS  
$_GET['/primera_division_femenino_futsal/grupo1/jornada1']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (17)  
0.0106  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=157 AND type_rel = 3
0.0119  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 3 AND rel.typeId = 157 AND rel.ln = 'es' AND rel.status=1 ORDER BY rel.creation_date desc,rel.cover_points DESC LIMIT 5
0.0109  SELECT /*53 bs_news_model*/ n.id, n.author_id, n.headline, n.external_headline, n.live_headline, n.creation_date, n.update_date, n.pub_date, n.alias, n.subheadline, n.teaser, n.media, n.tags, n.views, n.screens, n.clicks, n.relations, n.comments, n.power_cover, n.cover_points, u.name as user_name FROM bs_news n INNER JOIN bs_editors u ON u.id = n.author_id AND u.ln = 'es' WHERE n.status = 1 AND n.ln = 'es' AND n.id IN (1114910,1060072,931766,909409,867439) ORDER BY n.cover_points DESC, update_date DESC
0.0106  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-03-28 12:01:39' 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-03-28 12:01:39' 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-03-28 12:01:39' 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=3 AND last_update > '2024-03-28 12:01:39' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0107  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=73236 AND rel.round=1
0.0118  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` = 73236 AND c.`round` = 1 ORDER BY shedule ASC LIMIT 200
0.0107  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 = 73236 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 (437646,437641,437644,437645,437642,437647,437643,437640) AND ev.action in (1,2,3,4,6,11,12,13,15) ORDER BY ev.minute ASC
0.0107  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 = 1 AND e.real_date IS NOT NULL AND e.league_id = 73236 ORDER BY total DESC LIMIT 40
0.0127  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 = 73236 AND t.round = 0 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0218  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 = 73236 AND t.round = 1 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0108  SELECT distinct(shedule), round FROM `calendars2024` as c WHERE c.`league_id` = 73236 AND shedule >= '2023/09/01' AND shedule < '2023/10/01' ORDER BY shedule ASC
0.0108  SELECT c.id, 2024 AS year, IF(l.tables = 1 AND t1.points>0,((t1.points / (l.current_round * 3)) + (t2.points / (l.current_round * 3)))/2 * ct.coefficient,0.7 * ct.coefficient) as fcoef FROM `calendars2024` AS c INNER JOIN `leagues` AS l ON c.`league_id` = l.`id` INNER JOIN `categories` AS ct ON ct.`id` = l.`categoryId` LEFT JOIN tables2024 AS t1 ON t1.team = c.team1 AND t1.round = l.current_round LEFT JOIN tables2024 AS t2 ON t2.team = c.team2 AND t2.round = l.current_round WHERE c.`shedule` > '2024-03-28 00:00:00' AND c.`shedule` < '2024-04-01 23:59:59' AND l.id = 73236 ORDER BY c.shedule ASC, fcoef DESC LIMIT 5
0.0105  SELECT data1, data2 FROM services_tags WHERE categoryId=157
0.0106  SELECT group_code, extraName from `leagues` WHERE categoryId=157 AND year=2024