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

Primera División Femenino Futsal

  • AD Alcorcón
  • Roldán FSF
  • Burela FS
  • AE Les Corts
  • LBTL Alcantarilla
  • Futsi Atlético
  • FSF Móstoles
  • Viaxes Amarelle
  • FSF Castro
  • Marín Fútsal
  • MSC Torreblanca FS
  • Poio FS
  • Nueces de Ronda Atl. Torcal
  • Ourense CF
  • Rayo Majadahonda FS
  • CD Leganés
 
30 Sep 23
16:30 Finalizado
AE Les Corts AE Les Corts 2-0 Ourense CF Ourense CF más información ...
 
30 Sep 23
17:00 Finalizado
Marín Fútsal Marín Fútsal 5-0 CD Leganés CD Leganés más información ...
 
30 Sep 23
18:00 Finalizado
LBTL Alcantarilla LBTL Alcantarilla 2-3 Futsi Atlético Futsi Atlético más información ...
 
30 Sep 23
18:30 Finalizado
Rayo Majadahonda FS Rayo Majadahonda FS 2-6 Viaxes Amarelle Viaxes Amarelle más información ...
 
30 Sep 23
18:30 Finalizado
FSF Móstoles FSF Móstoles 1-3 Poio FS Poio FS más información ...
 
30 Sep 23
18:30 Finalizado
FSF Castro FSF Castro 3-1 Nueces de Ronda Atl. Torcal Nueces Ronda Atl. Torcal más información ...
 
30 Sep 23
18:45 Finalizado
Burela FS Burela FS 2-2 Roldán FSF Roldán FSF más información ...
 
30 Sep 23
19:30 Finalizado
AD Alcorcón AD Alcorcón 4-1 MSC Torreblanca FS MSC Torreblanca FS más información ...
Equipos Puntos J. G. E. P. F. C. Forma
1 AD Alcorcón AD Alcorcón 9 3 3 0 0 16 5
  • VICTORIA
  • AD Alcorcón 5
  • Futsi Atlético 4
  • VICTORIA
  • Rayo Majadahonda F. 0
  • AD Alcorcón 7
  • VICTORIA
  • AD Alcorcón 4
  • MSC Torreblanca FS 1
2 Roldán FSF Roldán FSF 7 3 2 1 0 9 5
  • VICTORIA
  • Marín Fútsal 1
  • Roldán FSF 3
  • VICTORIA
  • Roldán FSF 4
  • FSF Castro 2
  • EMPATE
  • Burela FS 2
  • Roldán FSF 2
3 Burela FS Burela FS 7 3 2 1 0 9 6
  • VICTORIA
  • Burela FS 2
  • Poio FS 0
  • VICTORIA
  • Ourense CF 4
  • Burela FS 5
  • EMPATE
  • Burela FS 2
  • Roldán FSF 2
4 AE Les Corts AE Les Corts 7 3 2 1 0 6 3
  • EMPATE
  • AE Les Corts 2
  • Viaxes Amarelle 2
  • VICTORIA
  • Poio FS 1
  • AE Les Corts 2
  • VICTORIA
  • AE Les Corts 2
  • Ourense CF 0
5 LBTL Alcantarilla LBTL 6 3 2 0 1 15 4
  • VICTORIA
  • LBTL Alcantarilla 7
  • Nueces de Ronda At. 1
  • VICTORIA
  • CD Leganés 0
  • LBTL Alcantarilla 6
  • DERROTA
  • LBTL Alcantarilla 2
  • Futsi Atlético 3
6 Futsi Atlético Futsi Atlético 6 3 2 0 1 12 9
  • DERROTA
  • AD Alcorcón 5
  • Futsi Atlético 4
  • VICTORIA
  • Futsi Atlético 5
  • MSC Torreblanca FS 2
  • VICTORIA
  • LBTL Alcantarilla 2
  • Futsi Atlético 3
7 FSF Móstoles FSF Móstoles 6 3 2 0 1 10 9
  • VICTORIA
  • FSF Móstoles 4
  • Rayo Majadahonda F. 2
  • VICTORIA
  • Viaxes Amarelle 4
  • FSF Móstoles 5
  • DERROTA
  • FSF Móstoles 1
  • Poio FS 3
8 Viaxes Amarelle Viaxes Amarelle 4 3 1 1 1 12 9
  • EMPATE
  • AE Les Corts 2
  • Viaxes Amarelle 2
  • DERROTA
  • Viaxes Amarelle 4
  • FSF Móstoles 5
  • VICTORIA
  • Rayo Majadahonda F. 2
  • Viaxes Amarelle 6
9 FSF Castro FSF Castro 4 3 1 1 1 8 8
  • EMPATE
  • FSF Castro 3
  • Ourense CF 3
  • DERROTA
  • Roldán FSF 4
  • FSF Castro 2
  • VICTORIA
  • FSF Castro 3
  • Nueces de Ronda At. 1
10 Marín Fútsal Marín Fútsal 3 3 1 0 2 7 5
  • DERROTA
  • Marín Fútsal 1
  • Roldán FSF 3
  • DERROTA
  • Nueces de Ronda At. 2
  • Marín Fútsal 1
  • VICTORIA
  • Marín Fútsal 5
  • CD Leganés 0
11 MSC Torreblanca FS Torreblanca 3 3 1 0 2 9 9
  • VICTORIA
  • MSC Torreblanca FS 6
  • CD Leganés 0
  • DERROTA
  • Futsi Atlético 5
  • MSC Torreblanca FS 2
  • DERROTA
  • AD Alcorcón 4
  • MSC Torreblanca FS 1
12 Poio FS Poio FS 3 3 1 0 2 4 5
  • DERROTA
  • Burela FS 2
  • Poio FS 0
  • DERROTA
  • Poio FS 1
  • AE Les Corts 2
  • VICTORIA
  • FSF Móstoles 1
  • Poio FS 3
13 Nueces de Ronda Atl. Torcal Nueces Ronda At. 3 3 1 0 2 4 11
  • DERROTA
  • LBTL Alcantarilla 7
  • Nueces de Ronda At. 1
  • VICTORIA
  • Nueces de Ronda At. 2
  • Marín Fútsal 1
  • DERROTA
  • FSF Castro 3
  • Nueces de Ronda At. 1
14 Ourense CF Ourense CF 1 3 0 1 2 7 10
  • EMPATE
  • FSF Castro 3
  • Ourense CF 3
  • DERROTA
  • Ourense CF 4
  • Burela FS 5
  • DERROTA
  • AE Les Corts 2
  • Ourense CF 0
15 Rayo Majadahonda FS Rayo Majadahonda 0 3 0 0 3 4 17
  • DERROTA
  • FSF Móstoles 4
  • Rayo Majadahonda F. 2
  • DERROTA
  • Rayo Majadahonda F. 0
  • AD Alcorcón 7
  • DERROTA
  • Rayo Majadahonda F. 2
  • Viaxes Amarelle 6
16 CD Leganés CD Leganés 0 3 0 0 3 0 17
  • DERROTA
  • MSC Torreblanca FS 6
  • CD Leganés 0
  • DERROTA
  • CD Leganés 0
  • LBTL Alcantarilla 6
  • DERROTA
  • Marín Fútsal 5
  • CD Leganés 0
Playoff Título : AD Alcorcón, Roldán FSF, Burela FS, AE Les Corts
Descenso : Ourense CF, Rayo Majadahonda, 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,213,120 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0018
Controller Execution Time ( Home / Category )  0.2848
Total Execution Time  0.2867
  CADENA URL  
/primera_division_femenino_futsal/grupo1/jornada3
  GET DATOS  
$_GET['/primera_division_femenino_futsal/grupo1/jornada3']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (17)  
0.0109  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=157 AND type_rel = 3
0.0111  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.0111  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.0108  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-03-29 11:45:38' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0108  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=2 AND last_update > '2024-03-29 11:45:38' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0111  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=4 AND last_update > '2024-03-29 11:45:38' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0111  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=3 AND last_update > '2024-03-29 11:45:38' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0122  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=3
0.0111  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` = 3 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 (437659,437662,437663,437657,437658,437661,437660,437664) AND ev.action in (1,2,3,4,6,11,12,13,15) ORDER BY ev.minute ASC
0.0108  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 = 3 AND e.real_date IS NOT NULL AND e.league_id = 73236 ORDER BY total DESC LIMIT 40
0.0109  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 = 2 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0224  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 = 3 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0112  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.0116  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-29 00:00:00' AND c.`shedule` < '2024-04-02 23:59:59' AND l.id = 73236 ORDER BY c.shedule ASC, fcoef DESC LIMIT 5
0.0108  SELECT data1, data2 FROM services_tags WHERE categoryId=157
0.0114  SELECT group_code, extraName from `leagues` WHERE categoryId=157 AND year=2024