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

Segunda División Femenino Futsal

  • Desguace París Algaida FS
  • Guadalcacín
  • Almagro FSF
  • CD Camoens
  • CD Chiloeches
  • Ceuta AD
  • Martos FS Jaén Paraíso Int.
  • Xaloc Alacant
  • CD Salesianos
  • MSC Torreblanca FS B
  • CDC San José
  • Mora FS
  • La Boca Te Lía B
  • UDAF Afanion
  • Villacañas FS
  • Mabe CD El Ejido Futsal
 
23 Mar 24
Aplazado
CD Chiloeches CD Chiloeches Apl Mabe CD El Ejido Futsal Mabe CD El Ejido Futsal más información ...
 
23 Mar 24
11:00 Finalizado
UDAF Afanion UDAF Afanion 0-7 Ceuta AD Ceuta AD más información ...
 
23 Mar 24
12:30 Finalizado
CD Camoens CD Camoens 3-1 Mora FS Mora FS más información ...
 
23 Mar 24
17:30 Finalizado
Villacañas FS Villacañas FS 0-5 Almagro FSF Almagro FSF más información ...
 
23 Mar 24
19:45 Finalizado
Xaloc Alacant Xaloc Alacant 2-2 MSC Torreblanca FS B MSC Torreblanca FS B más información ...
 
24 Mar 24
11:00 Finalizado
CDC San José CDC San José 3-2 CD Salesianos CD Salesianos más información ...
 
24 Mar 24
12:00 Finalizado
Guadalcacín Guadalcacín 1-0 Martos FS Jaén Paraíso Int. Martos Jaén Paraíso Int. más información ...
 
24 Mar 24
13:00 Finalizado
La Boca Te Lía B La Boca Te Lía B 0-5 Desguace París Algaida FS Desguace París Algaida más información ...
Equipos Puntos J. G. E. P. F. C. Forma
1 Desguace París Algaida FS Desguace París 60 23 19 3 1 98 47
  • VICTORIA
  • CD Chiloeches 3
  • Desguace París Alg. 4
  • VICTORIA
  • Desguace París Alg. 7
  • Xaloc Alacant 3
  • EMPATE
  • Guadalcacín 3
  • Desguace París Alg. 3
  • VICTORIA
  • Desguace París Alg. 7
  • Villacañas FS 1
  • VICTORIA
  • La Boca Te Lía B 0
  • Desguace París Alg. 5
2 Guadalcacín Guadalcacín 49 23 15 4 4 73 34
  • VICTORIA
  • Guadalcacín 5
  • Ceuta AD 2
  • DERROTA
  • CD Salesianos 3
  • Guadalcacín 1
  • EMPATE
  • Guadalcacín 3
  • Desguace París Alg. 3
  • VICTORIA
  • Almagro FSF 1
  • Guadalcacín 2
  • VICTORIA
  • Guadalcacín 1
  • Martos FS Jaén Par. 0
3 Almagro FSF Almagro FSF 47 23 15 2 6 66 34
  • DERROTA
  • CD Camoens 3
  • Almagro FSF 1
  • VICTORIA
  • Almagro FSF 4
  • CD Chiloeches 1
  • VICTORIA
  • Xaloc Alacant 0
  • Almagro FSF 3
  • DERROTA
  • Almagro FSF 1
  • Guadalcacín 2
  • VICTORIA
  • Villacañas FS 0
  • Almagro FSF 5
4 CD Camoens CD Camoens 45 23 14 3 6 75 45
  • VICTORIA
  • CD Camoens 3
  • Almagro FSF 1
  • VICTORIA
  • Martos FS Jaén Par. 3
  • CD Camoens 4
  • VICTORIA
  • CD Camoens 4
  • MSC Torreblanca FS. 2
  • VICTORIA
  • Mabe CD El Ejido F. 0
  • CD Camoens 6
  • VICTORIA
  • CD Camoens 3
  • Mora FS 1
5 CD Chiloeches CD Chiloeches 44 22 14 2 6 82 47
  • EMPATE
  • CD Salesianos 2
  • CD Chiloeches 2
  • DERROTA
  • CD Chiloeches 3
  • Desguace París Alg. 4
  • DERROTA
  • Almagro FSF 4
  • CD Chiloeches 1
  • VICTORIA
  • CD Chiloeches 3
  • Martos FS Jaén Par. 0
  • EMPATE
  • MSC Torreblanca FS. 1
  • CD Chiloeches 1
6 Ceuta AD Ceuta AD 36 23 10 6 7 69 53
  • DERROTA
  • Guadalcacín 5
  • Ceuta AD 2
  • VICTORIA
  • Ceuta AD 6
  • Villacañas FS 2
  • VICTORIA
  • La Boca Te Lía B 0
  • Ceuta AD 2
  • EMPATE
  • Ceuta AD 1
  • CDC San José 1
  • VICTORIA
  • UDAF Afanion 0
  • Ceuta AD 7
7 Martos FS Jaén Paraíso Int. Martos Jaén Par. 34 23 11 1 11 70 68
  • DERROTA
  • Mora FS 4
  • Martos FS Jaén Par. 2
  • DERROTA
  • Martos FS Jaén Par. 3
  • CD Camoens 4
  • DERROTA
  • CD Chiloeches 3
  • Martos FS Jaén Par. 0
  • VICTORIA
  • Martos FS Jaén Par. 4
  • Xaloc Alacant 3
  • DERROTA
  • Guadalcacín 1
  • Martos FS Jaén Par. 0
8 Xaloc Alacant Xaloc Alacant 32 23 9 5 9 78 62
  • VICTORIA
  • Xaloc Alacant 5
  • CD Salesianos 4
  • DERROTA
  • Desguace París Alg. 7
  • Xaloc Alacant 3
  • DERROTA
  • Xaloc Alacant 0
  • Almagro FSF 3
  • DERROTA
  • Martos FS Jaén Par. 4
  • Xaloc Alacant 3
  • EMPATE
  • Xaloc Alacant 2
  • MSC Torreblanca FS. 2
9 CD Salesianos CD Salesianos 32 23 9 5 9 54 49
  • DERROTA
  • Xaloc Alacant 5
  • CD Salesianos 4
  • VICTORIA
  • CD Salesianos 3
  • Guadalcacín 1
  • VICTORIA
  • Villacañas FS 1
  • CD Salesianos 2
  • DERROTA
  • CD Salesianos 1
  • La Boca Te Lía B 2
  • DERROTA
  • CDC San José 3
  • CD Salesianos 2
10 MSC Torreblanca FS B Torreblanca 31 23 9 4 10 61 58
  • VICTORIA
  • Mabe CD El Ejido F. 0
  • MSC Torreblanca FS. 6
  • VICTORIA
  • MSC Torreblanca FS. 4
  • Mora FS 0
  • DERROTA
  • CD Camoens 4
  • MSC Torreblanca FS. 2
  • EMPATE
  • MSC Torreblanca FS. 1
  • CD Chiloeches 1
  • EMPATE
  • Xaloc Alacant 2
  • MSC Torreblanca FS. 2
11 CDC San José CDC San José 27 23 7 6 10 52 64
  • EMPATE
  • Villacañas FS 1
  • CDC San José 1
  • VICTORIA
  • CDC San José 4
  • La Boca Te Lía B 0
  • VICTORIA
  • UDAF Afanion 2
  • CDC San José 3
  • EMPATE
  • Ceuta AD 1
  • CDC San José 1
  • VICTORIA
  • CDC San José 3
  • CD Salesianos 2
12 Mora FS Mora FS 22 23 6 4 13 51 70
  • VICTORIA
  • Mora FS 4
  • Martos FS Jaén Par. 2
  • DERROTA
  • MSC Torreblanca FS. 4
  • Mora FS 0
  • VICTORIA
  • Mora FS 6
  • Mabe CD El Ejido F. 0
  • VICTORIA
  • Mora FS 7
  • UDAF Afanion 3
  • DERROTA
  • CD Camoens 3
  • Mora FS 1
13 La Boca Te Lía B Boca Lía 19 23 5 4 14 53 70
  • EMPATE
  • UDAF Afanion 4
  • La Boca Te Lía B 4
  • DERROTA
  • CDC San José 4
  • La Boca Te Lía B 0
  • DERROTA
  • La Boca Te Lía B 0
  • Ceuta AD 2
  • VICTORIA
  • CD Salesianos 1
  • La Boca Te Lía B 2
  • DERROTA
  • La Boca Te Lía B 0
  • Desguace París Alg. 5
14 UDAF Afanion UDAF Afanion 18 23 5 3 15 59 84
  • EMPATE
  • UDAF Afanion 4
  • La Boca Te Lía B 4
  • VICTORIA
  • Mabe CD El Ejido F. 0
  • UDAF Afanion 6
  • DERROTA
  • UDAF Afanion 2
  • CDC San José 3
  • DERROTA
  • Mora FS 7
  • UDAF Afanion 3
  • DERROTA
  • UDAF Afanion 0
  • Ceuta AD 7
15 Villacañas FS Villacañas FS 16 23 4 4 15 34 75
  • EMPATE
  • Villacañas FS 1
  • CDC San José 1
  • DERROTA
  • Ceuta AD 6
  • Villacañas FS 2
  • DERROTA
  • Villacañas FS 1
  • CD Salesianos 2
  • DERROTA
  • Desguace París Alg. 7
  • Villacañas FS 1
  • DERROTA
  • Villacañas FS 0
  • Almagro FSF 5
16 Mabe CD El Ejido Futsal Mabe Ejido Futs. * 5 22 2 2 18 13 128
  • DERROTA
  • Martos FS Jaén Par. 6
  • Mabe CD El Ejido F. 0
  • DERROTA
  • Mabe CD El Ejido F. 0
  • MSC Torreblanca FS. 6
  • DERROTA
  • Mabe CD El Ejido F. 0
  • UDAF Afanion 6
  • DERROTA
  • Mora FS 6
  • Mabe CD El Ejido F. 0
  • DERROTA
  • Mabe CD El Ejido F. 0
  • CD Camoens 6

Penalizaciones de la competición

-3 Puntos: Mabe Ejido Futs.

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,240,264 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0024
Controller Execution Time ( Home / Category )  0.3236
Total Execution Time  0.3260
  CADENA URL  
/segunda_division_femenino_futsal/grupo3
  GET DATOS  
$_GET['/segunda_division_femenino_futsal/grupo3']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (21)  
0.0213  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'segunda_division_femenino_futsal' AND (l.group_code = 3 OR l.group_code = 1 OR l.group_code = 0) ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=3 DESC LIMIT 1
0.0107  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 = 73409 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0105  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-03-28 21:24:21' 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 21:24:21' 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 21:24:21' 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 21:24:21' 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=73409 AND rel.round=23
0.0106  SELECT u.id,u.user_name, esl.points,up.name,up.surname,up.nick,u.changeA FROM editor_stats_leagues esl INNER JOIN fa_user u ON u.id = esl.user_id INNER JOIN fa_user_profile up ON up.id = esl.user_id WHERE esl.league_id = 73409 AND esl.points > 0 ORDER BY esl.points DESC LIMIT 3
0.0105  SELECT count(esl.user_id) as cuenta FROM editor_stats_leagues esl INNER JOIN fa_user u ON u.id = esl.user_id INNER JOIN fa_user_profile up ON up.id = esl.user_id WHERE esl.league_id = 73409 AND esl.points > 0
0.0105  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-02-27" AND c.`active`= 1 and c.comment_id is null and c.lang = 1 AND l.`id` = 73409 ORDER BY creation_date DESC LIMIT 0, 10
0.0110  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-02-27" AND c.`active`= 1 and comment_id is null and c.lang = 1 AND l.`id` = 73409
0.0107  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` = 73409 AND c.`round` = 23 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 = 73409 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 (471746,471740,471747,471743,471745,471741,471744,471742) AND ev.action in (1,2,3,4,6,11,12,13,15) ORDER BY ev.minute ASC
0.0106  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 = 23 AND e.real_date IS NOT NULL AND e.league_id = 73409 ORDER BY total DESC LIMIT 40
0.0109  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 = 73409 AND e.real_date > NOW() - INTERVAL 1 MONTH ORDER BY e.real_date DESC LIMIT 30
0.0117  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 = 73409 AND t.round = 21 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0110  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 = 73409 AND t.round = 23 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0111  SELECT distinct(shedule), round FROM `calendars2024` as c WHERE c.`league_id` = 73409 AND shedule >= '2024/03/01' AND shedule < '2024/04/01' ORDER BY shedule ASC
0.0105  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-02 23:59:59' AND l.id = 73409 ORDER BY c.shedule ASC, fcoef DESC LIMIT 5
0.0114  SELECT data1, data2 FROM services_tags WHERE categoryId=267
0.0114  SELECT group_code, extraName from `leagues` WHERE categoryId=267 AND year=2024