4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Segunda División Futsal 2024
2023/2024

segunda division de futbol sala de españa, segunda liga nacional de futbol sala, segunda española de futbol sala,

Segunda División Futsal 2024

  • Sala 10 Zaragoza
  • CD UMA Antequera
  • Burela FS
  • Union África Ceutí
  • Full Energía Zaragoza
  • Inagroup El Ejido
  • O Parrulo Ferrol
  • Sala 5 Martorell
  • Levante UD FS
  • Ibiza Gasifred
  • Melistar Futsal
  • Barça Atlétic
  • CD Leganes FS
  • Real Betis Futsal B
  • Atlético Mengíbar FS
  • Bisontes Castellón FS

Cruce de partidos Segunda División Futsal - Todos los partidos de la temporada

IdaVuelta
CD UMA Antequera Burela FS Sala 10 Zaragoza Levante UD FS O Parrulo Ferrol Atlético Mengíbar FS Full Energía Zaragoza Sala 5 Martorell Union África Ceutí CD Leganes FS Inagroup El Ejido Bisontes Castellón FS Melistar Futsal Barça Atlétic Ibiza Gasifred Real Betis Futsal B
CD UMA Antequera CD UMA Antequera
Burela FS Burela FS
Sala 10 Zaragoza Sala 10 Zaragoza
Levante UD FS Levante UD FS
O Parrulo Ferrol O Parrulo Ferrol
Atlético Mengíbar FS Atlético Mengíbar FS
Full Energía Zaragoza Full Energía Zaragoza
Sala 5 Martorell Sala 5 Martorell
Union África Ceutí Union África Ceutí
CD Leganes FS CD Leganes FS
Inagroup El Ejido Inagroup El Ejido
Bisontes Castellón FS Bisontes Castellón FS
Melistar Futsal Melistar Futsal
Barça Atlétic Barça Atlétic
Ibiza Gasifred Ibiza Gasifred
Real Betis Futsal B Real Betis Futsal B

  USO DE MEMORIA  
6,112,368 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0032
Controller Execution Time ( Home / Category )  0.2716
Total Execution Time  0.2748
  CADENA URL  
/segunda_division_futsal2024/grupo1/cruces
  GET DATOS  
$_GET['/segunda_division_futsal2024/grupo1/cruces']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (11)  
0.0108  SELECT id,name,alias,stepParent FROM categories WHERE parentId=109 ORDER BY order_id ASC
0.0113  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 = 73235 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0229  SELECT c.id, c.team1, c.team2, c.datateam1, c.datateam2, c.extra, c.shedule, c.r1, c.r2, c.status FROM calendars2024 AS c WHERE c.league_id='73235' ORDER BY c.id ASC
0.0114  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-04-27 19:12:12' 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-04-27 19:12:12' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0106  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=4 AND last_update > '2024-04-27 19:12:12' 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=3 AND last_update > '2024-04-27 19:12:12' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0111  SELECT e.action, count(e.action) as total,p.name, p.last_name, p.nick,p.CountryCode,p.alias,rp.team_id,dt.nameShow,dt.short_name,dt.basealias,rp.player_id,rp.teamId FROM `rel_players` rp INNER JOIN dataplayers p ON p.id = rp.player_id INNER JOIN events2024 e ON e.player_id = p.id AND e.league_id = 73235 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 73235 AND (e.action = 1 or e.action = 2 or e.action = 11 or e.action = 12 or e.action = 13) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0110  SELECT e.action, count(e.action) as total,p.name, p.last_name, p.nick,p.CountryCode,p.alias,rp.team_id,dt.nameShow,dt.short_name,dt.basealias,rp.player_id,rp.teamId FROM `rel_players` rp INNER JOIN dataplayers p ON p.id = rp.player_id INNER JOIN events2024 e ON e.player_id = p.id AND e.league_id = 73235 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 73235 AND (e.action = 4 or e.action = 5) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0116  SELECT e.action, count(e.action) as total,p.name, p.last_name, p.nick,p.CountryCode,p.alias,rp.team_id,dt.nameShow,dt.short_name,dt.basealias,rp.player_id,rp.teamId FROM `rel_players` rp INNER JOIN dataplayers p ON p.id = rp.player_id INNER JOIN events2024 e ON e.player_id = p.id AND e.league_id = 73235 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 73235 AND (e.action = 3 or e.action = 4) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0134  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 = 73235 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