4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
« Temporada Anterior
Temporada 2015
Temporada Siguiente »
Segunda División Futsal 2015
2014/2015

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

Segunda División Futsal 2015

  • CD UMA Antequera
  • Elche CF Sala
  • Barça Atlétic
  • Brihuega F.S.
  • Viña Albali Valdepeñas
  • C.D. La Escuela
  • Jimbee Cartagena
  • Melilla FS
  • Gran Canaria
  • ElPozo Ciudad de Murcia
  • O Parrulo Ferrol
  • Hércules San Vicente
  • FS Zamora Futsal
  • Sierra de Salinas
Ver
TEMPORADA 2014/2015
Equipo PJ GF GC Puntos
1 CD UMA Antequera Antequera 26 135 84 54
2 Elche CF Sala Elche Sala 26 101 67 53
3 Barça Atlétic Barça 26 112 68 52
4 Brihuega F.S. Brihuega 26 96 72 50
5 Viña Albali Valdepeñas Viña Albali 26 93 75 45
6 C.D. La Escuela C.D. Escuela 26 92 85 41
7 Jimbee Cartagena Jimbee 26 100 81 39
8 Melilla FS Melilla FS 26 88 75 39
9 Gran Canaria Gran Canaria 26 95 91 39
10 ElPozo Ciudad de Murcia ElPozo 26 102 93 37
11 O Parrulo Ferrol Parrulo 26 74 104 25
12 Hércules San Vicente Hércules 26 65 77 23
13 FS Zamora Futsal Zamora 26 45 92 20
14 Sierra de Salinas Sierra 26 37 171 0
Ver
TEMPORADA 2013/2014
Equipo PJ GF GC Puntos
1 Levante UD FS Levante 24 97 61 55
2 Uruguay Tenerife Uruguay 24 121 79 49
3 Elche CF Sala Elche Sala 24 100 65 48
4 FC Barcelona Barcelona 24 94 68 45
5 Jimbee Cartagena Jimbee 24 100 89 39
6 ElPozo Ciudad de Murcia ElPozo 24 86 83 35
7 Brihuega F.S. Brihuega 24 91 79 35
8 Melilla F.S Melilla F.S 24 73 72 33
9 Hospitalet Bellsport Hospitalet 24 79 83 29
10 C.D. La Escuela C.D. Escuela 24 78 91 28
11 CD UMA Antequera Antequera 24 65 86 26
12 Hércules San Vicente Hércules 24 68 83 20
13 O Parrulo Ferrol Parrulo 24 45 158 1
Ver
TEMPORADA 2012/2013
Equipo PJ GF GC Puntos
1 Peñíscola FS Peñíscola 26 115 74 54
2 Jumilla B. Carchelo Jumilla 26 96 63 54
3 Carnicer Torrejón Carnicer 26 117 84 48
4 ElPozo Ciudad de Murcia ElPozo 26 99 81 46
5 Fuconsa Jaén Fuconsa 26 93 69 45
6 Playas de Castellón FS Playas 26 114 99 41
7 Bp Andorra Bp Andorra 26 96 98 40
8 Barça Atlétic Barça 26 120 100 38
9 Cd Dominicos Futsal Dominicos 26 79 80 35
10 Melilla FS Melilla FS 26 81 114 30
11 CD UMA Antequera Antequera 26 71 94 28
12 FS Cartagena Cartagena 26 99 125 24
13 Maristas UPV FS Maristas 26 82 109 24
14 Uruguay Peruanos Futsal Uruguay 26 82 154 12
Ver
TEMPORADA 2011/2012
Equipo PJ GF GC Puntos
1 Oxipharma FS Oxipharma 30 141 91 59
2 Manzanares FS Manzanares 30 111 99 56
3 ElPozo Ciudad de Murcia ElPozo 30 114 98 49
4 Fuconsa Jaén Fuconsa 30 82 85 48
5 C. A Gran Canaria Gran Canaria 30 123 112 47
6 Barça Atlétic Barça 30 118 113 46
7 CD UMA Antequera Antequera 30 104 91 45
8 Sala 5 Martorell Sala 30 130 110 44
9 Burela FS Burela FS 30 94 85 44
10 Union África Ceutí Union 30 118 128 42
11 Bp Andorra Bp Andorra 30 105 103 41
12 Maristas UPV FS Maristas 30 110 112 34
13 Hospitalet Bellsport Hospitalet 30 109 126 31
14 Melilla FS Melilla FS 30 87 108 31
15 Ibiza Gasifred Ibiza 30 105 128 30
16 Playas de Castellón FS Playas 30 91 153 25
Ver
TEMPORADA 2010/2011
Equipo PJ GF GC Puntos
1 FSD Puertollano Puertollano 36 125 58 90
2 Ribera Navarra FS Ribera 36 158 88 81
3 Maristas UPV FS Maristas 36 144 111 65
4 C. A Gran Canaria Gran Canaria 36 130 115 62
5 Burela FS Burela FS 36 108 82 60
6 Arcebansa Chint Zamora Arcebansa 36 111 99 60
7 Bp Andorra Bp Andorra 36 141 116 59
8 Lanzarote Lanzarote 36 152 143 52
9 El Pozo Murcia B Pozo Murcia 36 129 123 51
10 CD UMA Antequera Antequera 36 138 140 50
11 Barça Atlétic Barça 36 102 103 49
12 Ulejos Y Pavimentos Brihueg Ulejos 36 112 115 46
13 Union África Ceutí Union 36 101 107 46
14 Jaén FS Jaén FS 36 88 102 40
15 Ibiza Gasifred Ibiza 36 119 134 37
16 Melilla FS Melilla FS 36 92 144 32
17 Cáceres 2016 Cáceres 36 104 150 31
18 Albacete FS Albacete FS 36 99 143 26
19 Tobarra FS Tobarra FS 36 74 154 18
Ver
TEMPORADA 2009/2010
Equipo PJ GF GC Puntos
1 Gijon El Llano Gijon Llano 28 121 101 51
2 Talavera Talavera 25 98 71 50
3 Bp Andorra Bp Andorra 26 94 71 45
4 RAM León RAM León 26 105 88 43
5 SDM Illescas Illescas 26 96 95 38
6 Cáceres 2016 Cáceres 26 86 106 34
7 Burela FS Burela FS 16 59 40 33
8 Lanzarote Lanzarote 26 90 102 32
9 Delta Badajoz Delta 25 118 107 31
10 Alto Aragón FS Alto Aragón 26 102 124 30
11 El Escorial El Escorial 25 102 100 29
12 Ribera Navarra FS Ribera 26 80 89 29
13 Aviles Oquendo Aviles 26 64 92 29
14 Racing Valverdeno Racing 24 78 115 20
15 C. A Gran Canaria Gran Canaria 9 37 29 16
Ver
TEMPORADA 2008/2009
Equipo PJ GF GC Puntos
1 Arcebansa Zamora Arcebansa 20 74 44 44
2 Sala 10 Zaragoza Sala 20 92 65 44
3 Burela FS Burela FS 20 74 36 42
4 Az Ramos Talavera Ramos 20 75 65 33
5 Sport Sala Villaverde Sport Sala. 20 77 88 29
6 Bp Andorra Bp Andorra 20 78 79 28
7 Forma Cáceres 2016 Forma 20 72 72 22
8 Bilbo Bilbo 20 61 75 20
9 Ocaña Puertas Uniarte Ocaña 20 53 76 18
10 La Rápita La Rápita 20 52 75 18
11 Obras Y Estructuras Obras 20 54 87 13

  USO DE MEMORIA  
5,548,888 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0019
Controller Execution Time ( Home / Category )  0.4360
Total Execution Time  0.4380
  CADENA URL  
/segunda_division_futsal2015/grupo1/historico
  GET DATOS  
$_GET['/segunda_division_futsal2015/grupo1/historico']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (20)  
0.0145  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=109 AND type_rel = 3
0.0161  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 3 AND rel.typeId = 109 AND rel.ln = 'es' AND rel.status=1 ORDER BY rel.creation_date desc,rel.cover_points DESC LIMIT 5
0.0159  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 (1295442,1293501,1291378,1290332,1288350) ORDER BY n.cover_points DESC, update_date DESC
0.0161  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 = 4457 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0146  SELECT id,year,current_round,total_teams,legend FROM leagues WHERE categoryId = 109 AND group_code = 1 and tables = 1 AND year <= 2015 AND total_num_tablesR >= 1 ORDER BY year DESC LIMIT 22
0.0149  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 `tables2015` 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 = 4457 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0154  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 `tables2014` 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 = 3020 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0157  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 `tables2013` 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 = 1936 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0167  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 `tables2012` 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 = 1787 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0164  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 `tables2011` 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 = 1215 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0165  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 `tables2010` 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 = 924 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0164  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 `tables2009` 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 = 735 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0152  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-04-28 01:44:08' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0151  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=2 AND last_update > '2024-04-28 01:44:08' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0146  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=4 AND last_update > '2024-04-28 01:44:08' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0148  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=3 AND last_update > '2024-04-28 01:44:08' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0148  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 events2015 e ON e.player_id = p.id AND e.league_id = 4457 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 4457 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.0148  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 events2015 e ON e.player_id = p.id AND e.league_id = 4457 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 4457 AND (e.action = 4 or e.action = 5) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0150  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 events2015 e ON e.player_id = p.id AND e.league_id = 4457 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 4457 AND (e.action = 3 or e.action = 4) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0329  SELECT *,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables2015` 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 = 4457 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC