4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias

Tercera División Futsal

La temporada finalizó el Domingo, 21 Mayo 2023.
Clasificación
 
Jornada 31
 
Equipos Puntos J. G. E. P. F. C.
1 Avanza Jaén Avanza Jaén 76 29 25 1 3 169 47
  • VICTORIA
  • Poli Ejido 2
  • Avanza Jaén 5
  • VICTORIA
  • Avanza Jaén 9
  • Futsal Montevive A. 3
  • VICTORIA
  • CD Pizarra FS 0
  • Avanza Jaén 4
  • VICTORIA
  • Avanza Jaén 5
  • UMA Los Olivos 1
  • VICTORIA
  • CD Tapia FS 2
  • Avanza Jaén 4
2 Club Torremolinos Club 64 29 21 1 7 158 88
  • VICTORIA
  • Club Torremolinos 7
  • CD Gador 2
  • VICTORIA
  • UD Maracena 2
  • Club Torremolinos 4
  • VICTORIA
  • Club Torremolinos 9
  • At. Minero Bedaren. 5
  • DERROTA
  • Malacitano Futsal 4
  • Club Torremolinos 1
  • VICTORIA
  • Club Torremolinos 5
  • CD Albolote FS 3
3 Bailen 2008 Bailen 2008 63 29 20 3 6 142 96
  • DERROTA
  • Victoria Kent 5
  • Bailen 2008 4
  • VICTORIA
  • Bailen 2008 4
  • Poli Ejido 3
  • VICTORIA
  • Futsal Montevive A. 4
  • Bailen 2008 9
  • VICTORIA
  • Bailen 2008 8
  • CD Pizarra FS 1
  • DERROTA
  • UMA Los Olivos 7
  • Bailen 2008 2
4 Malacitano Futsal Malacitano 63 28 20 3 5 141 77
  • VICTORIA
  • UD Maracena 1
  • Malacitano Futsal 11
  • VICTORIA
  • Malacitano Futsal 8
  • At. Minero Bedaren. 3
  • VICTORIA
  • CD Tapia FS 2
  • Malacitano Futsal 7
  • DERROTA
  • CD Albolote FS 5
  • Malacitano Futsal 4
  • VICTORIA
  • Malacitano Futsal 4
  • Club Torremolinos 1
5 CD Albolote FS CD Albolote FS 58 29 18 4 7 120 86
  • VICTORIA
  • CD Albolote FS 5
  • UD Maracena 3
  • DERROTA
  • At. Minero Bedaren. 4
  • CD Albolote FS 3
  • VICTORIA
  • CD Albolote FS 5
  • Malacitano Futsal 4
  • VICTORIA
  • CD Albolote FS 5
  • CD Tapia FS 0
  • DERROTA
  • Club Torremolinos 5
  • CD Albolote FS 3
6 Victoria Kent Victoria Kent 51 29 16 3 10 141 125
  • VICTORIA
  • Victoria Kent 5
  • Bailen 2008 4
  • VICTORIA
  • UD Playas de Málag. 5
  • Victoria Kent 7
  • VICTORIA
  • Victoria Kent 9
  • CD Gador 4
  • VICTORIA
  • UD Maracena 4
  • Victoria Kent 9
  • VICTORIA
  • Victoria Kent 3
  • At. Minero Bedaren. 1
7 UMA Los Olivos UMA Los Olivos 44 29 13 5 11 109 91
  • DERROTA
  • Futsal Montevive A. 3
  • UMA Los Olivos 2
  • VICTORIA
  • UMA Los Olivos 5
  • CD Pizarra FS 2
  • VICTORIA
  • UMA Los Olivos 4
  • CD Tapia FS 1
  • DERROTA
  • Avanza Jaén 5
  • UMA Los Olivos 1
  • VICTORIA
  • UMA Los Olivos 7
  • Bailen 2008 2
8 Poli Ejido Poli Ejido 42 29 14 0 15 88 84
  • DERROTA
  • Poli Ejido 2
  • Avanza Jaén 5
  • DERROTA
  • Bailen 2008 4
  • Poli Ejido 3
  • VICTORIA
  • Poli Ejido 4
  • UD Playas de Málag. 1
  • DERROTA
  • CD Gador 4
  • Poli Ejido 2
  • DERROTA
  • Poli Ejido 1
  • UD Maracena 2
9 Futsal Montevive Alhendin Futsal Montevive 37 29 12 1 16 117 133
  • VICTORIA
  • Futsal Montevive A. 3
  • UMA Los Olivos 2
  • DERROTA
  • Avanza Jaén 9
  • Futsal Montevive A. 3
  • DERROTA
  • Futsal Montevive A. 4
  • Bailen 2008 9
  • DERROTA
  • UD Playas de Málag. 5
  • Futsal Montevive A. 3
  • VICTORIA
  • Futsal Montevive A. 7
  • CD Gador 4
10 CD Gador CD Gador 35 29 11 2 16 109 134
  • DERROTA
  • CD Gador 3
  • CD Albolote FS 4
  • DERROTA
  • Club Torremolinos 7
  • CD Gador 2
  • DERROTA
  • Victoria Kent 9
  • CD Gador 4
  • VICTORIA
  • CD Gador 4
  • Poli Ejido 2
  • DERROTA
  • Futsal Montevive A. 7
  • CD Gador 4
11 CD Tapia FS CD Tapia FS 34 29 11 1 17 93 133
  • VICTORIA
  • CD Pizarra FS 3
  • CD Tapia FS 4
  • DERROTA
  • CD Tapia FS 2
  • Malacitano Futsal 7
  • DERROTA
  • UMA Los Olivos 4
  • CD Tapia FS 1
  • DERROTA
  • CD Albolote FS 5
  • CD Tapia FS 0
  • DERROTA
  • CD Tapia FS 2
  • Avanza Jaén 4
12 At. Minero Bedarense Minero Bedarense 28 29 9 1 19 104 137
  • DERROTA
  • CD Tapia FS 6
  • At. Minero Bedaren. 4
  • DERROTA
  • Malacitano Futsal 8
  • At. Minero Bedaren. 3
  • VICTORIA
  • At. Minero Bedaren. 4
  • CD Albolote FS 3
  • DERROTA
  • Club Torremolinos 9
  • At. Minero Bedaren. 5
  • DERROTA
  • Victoria Kent 3
  • At. Minero Bedaren. 1
13 UD Maracena UD Maracena 22 29 7 1 21 74 126
  • DERROTA
  • UD Maracena 1
  • Malacitano Futsal 11
  • DERROTA
  • CD Albolote FS 5
  • UD Maracena 3
  • DERROTA
  • UD Maracena 2
  • Club Torremolinos 4
  • DERROTA
  • UD Maracena 4
  • Victoria Kent 9
  • VICTORIA
  • Poli Ejido 1
  • UD Maracena 2
14 UD Playas de Málaga FS Playas Málaga 18 29 5 3 21 84 152
  • DERROTA
  • UD Playas de Málag. 1
  • Club Torremolinos 6
  • DERROTA
  • UD Playas de Málag. 5
  • Victoria Kent 7
  • DERROTA
  • Poli Ejido 4
  • UD Playas de Málag. 1
  • VICTORIA
  • UD Playas de Málag. 5
  • Futsal Montevive A. 3
  • DERROTA
  • CD Pizarra FS 4
  • UD Playas de Málag. 1
15 CD Pizarra FS CD Pizarra FS * 16 29 6 1 22 52 123
  • DERROTA
  • CD Pizarra FS 3
  • CD Tapia FS 4
  • DERROTA
  • UMA Los Olivos 5
  • CD Pizarra FS 2
  • DERROTA
  • CD Pizarra FS 0
  • Avanza Jaén 4
  • DERROTA
  • Bailen 2008 8
  • CD Pizarra FS 1
  • VICTORIA
  • CD Pizarra FS 4
  • UD Playas de Málag. 1
16 Loja Loja 3 14 1 0 13 23 92
  • DERROTA
  • Loja 3
  • Bailen 2008 10
  • VICTORIA
  • UD Playas de Málag. 2
  • Loja 3
  • DERROTA
  • Loja 3
  • CD Gador 5
  • DERROTA
  • UD Maracena 4
  • Loja 1
  • DERROTA
  • Loja 3
  • At. Minero Bedaren. 7

Penalizaciones de la competición

-3 Puntos: CD Pizarra FS

INFORMACIÓN

La Tercera División Nacional (hasta la temporada 2010-2011 se llamaba Primera Nacional "B") es la cuarta división del fútbol sala español. Es la inmediatamente inferior a la Segunda División B. Es una categoría de carácter nacional perteneciente a la Real Federación Española de Fútbol, aunque está gestionada por las federaciones territoriales, por lo que su ámbito geográfico es autonómico y no estatal.

  USO DE MEMORIA  
5,106,840 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0029
Controller Execution Time ( Home / Category )  0.0571
Total Execution Time  0.0601
  CADENA URL  
/tercera_division_futsal/grupo18/jornada31
  GET DATOS  
$_GET['/tercera_division_futsal/grupo18/jornada31']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (11)  
0.0019  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-04-28 10:57:42' 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-04-28 10:57:42' 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-04-28 10:57:42' 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-04-28 10:57:42' GROUP BY url ORDER BY page_views DESC LIMIT 5
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=69443 AND rel.round=31
0.0020  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 `calendars2023` 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` = 69443 AND c.`round` = 31 ORDER BY shedule ASC LIMIT 200
0.0019  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 `events2023` e INNER JOIN calendars2023 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 = 31 AND e.real_date IS NOT NULL AND e.league_id = 69443 ORDER BY total DESC LIMIT 40
0.0024  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 `tables2023` 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 = 69443 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.0047  SELECT *,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables2023` 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 = 69443 AND t.round = 31 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=266
0.0030  SELECT group_code, extraName from `leagues` WHERE categoryId=266 AND year=2023