4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Ver
TEMPORADA 2023/2024
Equipo PJ GF GC Puntos
1 Desguace París Algaida FS Desguace 26 109 52 66
2 Guadalcacín Guadalcacín 25 77 36 55
3 CD Camoens CD Camoens 26 84 47 54
4 CD Chiloeches Chiloeches 25 94 52 50
5 Almagro FSF Almagro FSF 26 70 38 50
6 Ceuta AD Ceuta AD 26 77 60 41
7 Martos FS Jaén Paraíso Int. Martos Jaén 26 79 73 41
8 MSC Torreblanca FS B Torreblanca 26 72 63 37
9 Xaloc Alacant Xaloc 25 83 67 35
10 CD Salesianos Salesianos 26 62 62 34
11 CDC San José José 26 56 70 29
12 Mora FS Mora FS 26 54 80 22
13 La Boca Te Lía B Boca Lía 26 56 81 20
14 UDAF Afanion UDAF Afanion 26 65 98 19
15 Villacañas FS Villacañas 25 37 81 16
16 Mabe CD El Ejido Futsal Mabe Ejido. 22 13 128 5
Ver
TEMPORADA 2022/2023
Equipo PJ GF GC Puntos
1 Nueces de Ronda Atl. Torcal Nueces Ronda 26 139 28 66
2 Desguace París Algaida FS Desguace 26 103 54 54
3 Mabe CD El Ejido Futsal Mabe Ejido. 26 90 58 53
4 MSC Torreblanca FS B Torreblanca 26 66 48 48
5 La Boca Te Lía B Boca Lía 26 72 62 41
6 Xaloc Alacant Xaloc 26 72 73 40
7 Roldán B Roldán B 26 68 62 39
8 CD Camoens CD Camoens 26 82 64 37
9 Ceuta AD Ceuta AD 26 83 100 35
10 Martos FS Jaén Paraíso Int. Martos Jaén 26 62 75 34
11 Guadalcacín Guadalcacín 26 58 73 29
12 Deportivo Córdoba Deportivo 26 58 89 22
13 CDT Al Ándalus Ándalus 26 46 72 21
14 Cádiz FSF Cádiz FSF 26 16 157 0
Ver
TEMPORADA 2021/2022
Equipo PJ GF GC Puntos
1 Roldán B Roldán B 24 97 33 57
2 LBTL Alcantarilla LBTL 24 87 25 56
3 MSC Torreblanca FS B Torreblanca 24 71 35 52
4 UD La Cruz UD La Cruz 24 87 55 44
5 Desguace París Algaida FS Desguace 24 76 47 44
6 Mabe CD El Ejido Futsal Mabe Ejido. 24 91 77 39
7 Deportivo Córdoba Deportivo 24 62 61 37
8 Martos FS Jaén Paraíso Int. Martos Jaén 24 73 60 35
9 CD Camoens CD Camoens 24 68 67 30
10 Guadalcacín Guadalcacín 24 49 78 24
11 Xaloc Alacant Xaloc 24 75 77 23
12 Cádiz FSF Cádiz FSF 24 24 108 4
13 UD Alhameña Alhameña 24 44 181 4
Ver
TEMPORADA 2020/2021
Equipo PJ GF GC Puntos
1 LBTL Alcantarilla LBTL 16 76 34 41
2 Desguace París Algaida FS Desguace 16 45 32 31
3 MSC Torreblanca FS B Torreblanca 16 60 42 30
4 Mabe CD El Ejido Futsal Mabe Ejido. 16 61 55 28
5 Roldán B Roldán B 16 37 36 24
6 Martos FS Jaén Paraíso Int. Martos Jaén 16 29 37 16
7 Villa de Fines Villa Fines 16 37 64 13
8 SD Hispania SD Hispania 16 32 53 13
9 Monachil 2013 CF Monachil 16 48 72 12
10 Nueces de Ronda Atl. Torcal Nueces Ronda 16 77 18 42
11 Deportivo Córdoba Deportivo 16 92 17 42
12 UD La Cruz UD La Cruz 16 71 37 35
13 Guadalcacín Guadalcacín 15 59 33 28
14 Cádiz FSF Cádiz FSF 15 43 41 20
15 CD Camoens CD Camoens 14 38 52 15
16 CD Hércules Ceuta Hércules 16 30 77 12
17 Sporting Garrovilla Sporting 16 19 61 11
18 EF Almaraz EF Almaraz 16 15 108 1
Ver
TEMPORADA 2019/2020
Equipo PJ GF GC Puntos
1 LBTL Alcantarilla LBTL 22 119 42 55
2 MSC Torreblanca FS Torreblanca 22 96 29 51
3 UD La Cruz UD La Cruz 22 74 39 48
4 Guadalcacín Guadalcacín 22 86 46 45
5 Deportivo Córdoba Deportivo 22 87 64 42
6 Nueces de Ronda Atl. Torcal Nueces Ronda 21 70 48 41
7 Desguace París Algaida FS Desguace 22 55 58 31
8 Roldán B Roldán B 22 49 50 29
9 Monachil 2013 CF Monachil 22 73 88 28
10 Mabe CD El Ejido Futsal Mabe Ejido. 22 56 78 28
11 Martos FS Jaén Paraíso Int. Martos Jaén 22 62 83 27
12 CD Camoens CD Camoens 22 51 70 24
13 Deportivo Loja Deportivo 22 44 92 15
14 SD Hispania SD Hispania 22 42 75 13
15 Sporting Garrovilla Sporting 21 40 105 12
16 Cádiz FSF Cádiz FSF 22 51 88 10
Ver
TEMPORADA 2018/2019
Equipo PJ GF GC Puntos
1 Roldán B Roldán B 28 89 57 63
2 LBTL Alcantarilla LBTL 28 128 62 62
3 Nueces de Ronda Atl. Torcal Nueces Ronda 28 123 50 61
4 Deportivo Córdoba Deportivo 28 103 69 54
5 UD La Cruz UD La Cruz 28 108 66 50
6 MSC Torreblanca FS Torreblanca 28 122 74 49
7 Mabe CD El Ejido Futsal Mabe Ejido. 28 104 92 45
8 Cádiz FSF Cádiz FSF 28 90 69 42
9 Monachil 2013 CF Monachil 28 117 99 42
10 Deportivo Loja Deportivo 28 74 74 42
11 Desguace París Algaida FS Desguace 28 76 77 34
12 SD Hispania SD Hispania 28 80 93 32
13 Sporting Garrovilla Sporting 28 45 143 12
14 Playas de Málaga Playas 28 50 168 12
15 CD Hércules Ceuta Hércules 28 48 164 7
Ver
TEMPORADA 2017/2018
Equipo PJ GF GC Puntos
1 Almagro FSF Almagro FSF 30 113 53 67
2 Monachil 2013 CF Monachil 30 157 106 61
3 LBTL Alcantarilla LBTL 30 122 74 58
4 Nueces de Ronda Atl. Torcal Nueces Ronda 30 114 68 58
5 MSC Torreblanca FS Torreblanca 30 137 92 56
6 SD Hispania SD Hispania 30 115 80 52
7 Deportivo Loja Deportivo 30 94 77 50
8 UD La Cruz UD La Cruz 30 110 92 49
9 Joventut d'Elx FS Joventut 30 110 67 48
10 Roldán B Roldán B 30 92 91 43
11 Deportivo Córdoba Deportivo 30 83 95 37
12 Mabe CD El Ejido Futsal Mabe Ejido. 30 115 125 34
13 CD Salesianos Salesianos 30 67 82 32
14 Martos FS Jaén Paraíso Int. Martos Jaén 30 66 99 31
15 CD Comarca de Níjar Comarca 30 57 165 16
16 Quijote Futsal Quijote 30 29 215 2
Ver
TEMPORADA 2016/2017
Equipo PJ GF GC Puntos
1 Guadalcacín Guadalcacín 30 151 58 73
2 Cádiz FSF Cádiz FSF 30 94 44 70
3 MSC Torreblanca FS Torreblanca 30 91 85 55
4 Almagro FSF Almagro FSF 30 76 68 50
5 Deportivo Loja Deportivo 30 91 69 48
6 LBTL Alcantarilla LBTL 30 95 79 47
7 Roldán B Roldán B 30 63 72 47
8 Nueces de Ronda Atl. Torcal Nueces Ronda 30 81 67 46
9 CD Salesianos Salesianos 30 69 78 43
10 Deportivo Córdoba Deportivo 30 75 71 41
11 SD Hispania SD Hispania 30 74 77 40
12 CD Vicar CD Vicar 30 76 75 39
13 Monachil 2013 CF Monachil 30 83 94 37
14 CD Estudiantes de Sevilla Estudiantes 30 63 89 27
15 Malagón FSF Malagón 30 51 126 16
16 Sporting Garrovilla Sporting 30 42 123 13
Ver
TEMPORADA 2015/2016
Equipo PJ GF GC Puntos
1 Roldán B Roldán B 26 131 64 68
2 UCAM Murcia FSF UCAM Murcia 26 96 40 63
3 Almagro FSF Almagro FSF 26 82 46 48
4 Deportivo Loja Deportivo 26 112 82 48
5 Guadalcacín Guadalcacín 26 110 101 44
6 SD Hispania SD Hispania 26 89 97 37
7 Cádiz FSF Cádiz FSF 26 66 62 35
8 CD Vicar CD Vicar 26 68 96 35
9 Nueces de Ronda Atl. Torcal Nueces Ronda 26 68 74 33
10 Monachil 2013 CF Monachil 26 112 119 33
11 CD Estudiantes de Sevilla Estudiantes 26 81 107 25
12 MSC Torreblanca FS Torreblanca 26 72 113 22
13 CD Salesianos Salesianos 26 43 82 18
14 UD La Cruz UD La Cruz 26 59 106 18
Ver
TEMPORADA 2014/2015
Equipo PJ GF GC Puntos
1 UCAM Murcia FSF UCAM Murcia 26 155 21 74
2 Almagro FSF Almagro FSF 26 92 45 60
3 Cádiz FSF Cádiz FSF 26 132 53 56
4 Deportivo Loja Deportivo 26 86 52 51
5 CD Vicar CD Vicar 26 98 68 50
6 Nueces de Ronda Atl. Torcal Nueces Ronda 26 84 58 46
7 CD Estudiantes de Sevilla Estudiantes 26 72 77 36
8 MSC Torreblanca FS Torreblanca 26 64 132 20
9 CD Salesianos Salesianos 26 36 89 16
10 UD La Cruz UD La Cruz 26 36 150 9
11 Albolote Futsal CD Albolote 26 34 146 4
Ver
TEMPORADA 2012/2013
Equipo PJ GF GC Puntos
1 UCAM Murcia FSF UCAM Murcia 22 84 31 53
2 Cádiz FSF Cádiz FSF 22 90 49 50
3 CD Vicar CD Vicar 22 61 49 38
4 Almagro FSF Almagro FSF 22 45 51 30
5 Nueces de Ronda Atl. Torcal Nueces Ronda 22 56 53 29
6 CD Estudiantes de Sevilla Estudiantes 22 62 63 27
7 Atletico Monachil Atletico 22 70 92 27
8 Roldán B Roldán B 22 34 38 26
9 C Universidad De Granada Universidad 22 46 67 24
10 Comarca de Nijar Futsal Comarca 22 53 81 24
11 Cd Santa Rosa Santa Rosa 22 71 79 23
12 Brujula Fs Brujula Fs 22 42 61 22
Ver
TEMPORADA 2011/2012
Equipo PJ GF GC Puntos
1 Roldán FSF Roldán FSF 23 101 26 58
2 UCAM Murcia FSF UCAM Murcia 23 83 27 58
3 Nueces de Ronda Atl. Torcal Nueces Ronda 23 63 46 43
4 Pub Nono´s Arjona Ad Nono´s 23 83 55 42
5 C Universidad De Granada Universidad 23 50 49 32
6 Cd Guadalcin Guadalcin 23 69 78 30
7 Ciudad De Jerez Cd Ciudad Jerez 23 49 61 28
8 Cádiz FSF Cádiz FSF 23 47 70 28
9 CD Estudiantes de Sevilla Estudiantes 23 51 62 24
10 Brujula Fs Brujula Fs 23 47 54 23
11 Almagro FSF Almagro FSF 24 47 76 21
12 Comarca de Nijar Futsal Comarca 23 54 90 17
13 CD Salesianos Salesianos 23 38 88 15

  USO DE MEMORIA  
6,215,856 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0020
Controller Execution Time ( Home / Category )  0.1062
Total Execution Time  0.1082
  CADENA URL  
/segunda_division_femenino_futsal2024/grupo3/historico
  GET DATOS  
$_GET['/segunda_division_femenino_futsal2024/grupo3/historico']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (27)  
0.0038  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) AND l.year = 2024 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=3 DESC LIMIT 1
0.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=267 AND type_rel = 3
0.0021  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 3 AND rel.typeId = 267 AND rel.ln = 'es' AND rel.status=1 ORDER BY rel.creation_date desc,rel.cover_points DESC LIMIT 5
0.0021  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 (1060072,867439,850132,838700,805371) ORDER BY n.cover_points DESC, update_date DESC
0.0019  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.0036  SELECT id,year,current_round,total_teams,legend FROM leagues WHERE categoryId = 267 AND group_code = 3 and tables = 1 AND year <= 2024 AND total_num_tablesR >= 1 ORDER BY year DESC LIMIT 22
0.0023  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 = 26 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0022  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 = 68769 AND t.round = 26 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0033  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 `tables2022` 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 = 63709 AND t.round = 26 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0022  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 `tables2021` 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 = 58806 AND t.round = 18 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0022  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 `tables2020` 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 = 50523 AND t.round = 22 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0023  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 `tables2019` 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 = 44449 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0028  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 `tables2018` 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 = 39795 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0023  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 `tables2017` 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 = 35493 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0023  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 `tables2016` 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 = 64966 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
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 `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 = 7598 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
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 `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 = 2248 AND t.round = 22 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
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 `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 = 1821 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0019  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-04-28 16:19:35' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0020  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=2 AND last_update > '2024-04-28 16:19:35' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0020  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=4 AND last_update > '2024-04-28 16:19:35' 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 16:19:35' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0023  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 = 0 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 2024 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=0 DESC LIMIT 1
0.0020  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 = 73409 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 73409 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.0020  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 = 73409 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 73409 AND (e.action = 4 or e.action = 5) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0020  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 = 73409 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 73409 AND (e.action = 3 or e.action = 4) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0047  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 = 26 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC