4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Ver
TEMPORADA 2019/2020
Equipo PJ GF GC Puntos
1 Real Betis B Fem Real Betis 19 68 8 51
2 Cádiz Fem Cádiz Fem 19 37 10 43
3 CD Badajoz Fem Badajoz 19 50 12 42
4 Málaga CF B Fem Málaga 19 51 18 42
5 Extremadura Fem Extremadura 19 53 18 38
6 Almería Fem Almería 19 30 14 34
7 La Rambla Fem Rambla 19 35 34 26
8 Santa Teresa B Fem Santa Teresa 19 44 47 23
9 Sporting Huelva B Fem Sporting 19 29 35 20
10 CFF Cáceres Fem Cáceres 19 20 38 20
11 CD Castuera Fem Castuera 19 30 48 18
12 CD Híspalis Fem Híspalis 19 25 56 14
13 San Miguel Fem Miguel 19 18 57 10
14 Peña El Valle Fem Peña Valle 19 5 100 0
Ver
TEMPORADA 2018/2019
Equipo PJ GF GC Puntos
1 Santa Teresa Fem Santa Teresa 26 100 8 72
2 Granada CF Fem Granada 26 129 4 71
3 CP Cacereño Fem Cacereño 26 66 24 56
4 Córdoba CF Fem Córdoba 26 72 26 55
5 Pozoalbense Fem Pozoalbense 26 65 45 44
6 Málaga CF B Fem Málaga 26 64 33 43
7 Sporting Huelva B Fem Sporting 26 65 35 43
8 Extremadura Fem Extremadura 26 46 47 36
9 CD Híspalis Fem Híspalis 26 35 61 29
10 La Rambla Fem Rambla 26 34 77 23
11 San Miguel Fem Miguel 26 24 64 17
12 CD Castuera Fem Castuera 26 23 70 17
13 CD Camoens CD Camoens 26 16 114 8
14 Peña El Valle Fem Peña Valle 26 7 138 4
Ver
TEMPORADA 2017/2018
Equipo PJ GF GC Puntos
1 Málaga CF Fem Málaga 26 129 6 71
2 Granada CF Fem Granada 26 111 12 68
3 Sporting Huelva B Fem Sporting 26 72 30 61
4 Extremadura Fem Extremadura 26 75 35 54
5 CP Cacereño Fem Cacereño 26 55 28 43
6 El Naranjo Fem Naranjo 26 58 46 38
7 Santa Teresa B Fem Santa Teresa 26 46 52 35
8 CD Híspalis Fem Híspalis 26 30 60 26
9 La Rambla Fem Rambla 26 31 62 25
10 Pozoalbense Fem Pozoalbense 26 48 86 24
11 San Miguel Fem Miguel 26 20 56 23
12 Puerto de la Torre Puerto Torre 26 38 73 23
13 Cde Tnt Daimiel Femenino Daimiel 26 24 108 13
14 Club Polillas Atlético Club 26 14 97 9
Ver
TEMPORADA 2016/2017
Equipo PJ GF GC Puntos
1 Sevilla FC Fem Sevilla 26 121 16 73
2 Granada CF Fem Granada 26 126 18 70
3 Málaga CF Fem Málaga 26 101 22 63
4 La Solana Fem Solana 26 61 23 48
5 Extremadura Fem Extremadura 26 74 51 42
6 El Naranjo Fem Naranjo 26 72 49 42
7 CP Cacereño Fem Cacereño 26 56 41 36
8 Santa Teresa B Fem Santa Teresa 26 34 42 34
9 Sporting Huelva B Fem Sporting 26 52 70 34
10 La Rambla Fem Rambla 26 33 88 26
11 CD Híspalis Fem Híspalis 26 28 69 23
12 Monachil 2013 Fem Monachil 26 31 96 17
13 CD Camoens CD Camoens 26 9 103 9
14 Peña El Valle Fem Peña Valle 26 9 119 5
Ver
TEMPORADA 2015/2016
Equipo PJ GF GC Puntos
1 Real Betis Fem Real Betis 26 132 5 72
2 Granada CF Fem Granada 26 116 19 65
3 Sevilla FC Fem Sevilla 26 108 17 63
4 Málaga CF Fem Málaga 26 89 24 58
5 Sporting Huelva B Fem Sporting 26 60 65 45
6 CP Cacereño Fem Cacereño 26 52 53 39
7 El Naranjo Fem Naranjo 26 55 71 34
8 C. Llanos Olivenza Fem Llanos 26 43 50 31
9 Extremadura Fem Extremadura 26 48 48 30
10 CD Híspalis Fem Híspalis 26 41 63 28
11 La Rambla Fem Rambla 26 36 89 21
12 CD Ciconia Negra Fem Ciconia 26 25 95 17
13 CD Algaidas Fem Algaidas 26 19 113 10
14 La Cruz Villanovense Fem Cruz 26 31 143 8
Ver
TEMPORADA 2014/2015
Equipo PJ GF GC Puntos
1 Real Betis Fem Real Betis 26 116 13 71
2 C. Llanos Olivenza Fem Llanos 26 80 21 69
3 Granada CF Fem Granada 26 97 23 62
4 Málaga CF Fem Málaga 26 60 35 43
5 CP Cacereño Fem Cacereño 26 60 46 40
6 Extremadura Fem Extremadura 26 43 48 39
7 La Rambla Fem Rambla 26 52 55 38
8 CD Algaidas Fem Algaidas 26 65 66 34
9 El Naranjo Fem Naranjo 26 62 79 32
10 La Cruz Villanovense Fem Cruz 26 47 73 31
11 CD Híspalis Fem Híspalis 26 42 53 28
12 Monachil 2013 Fem Monachil 26 27 97 13
13 UD Carmelitas Fem Carmelitas 26 23 92 10
14 AD Nervión Fem Nervión 26 30 103 10
Ver
TEMPORADA 2013/2014
Equipo PJ GF GC Puntos
1 Santa Teresa Fem Santa Teresa 26 88 18 71
2 C. Llanos Olivenza Fem Llanos 26 104 17 63
3 Real Betis Fem Real Betis 26 87 25 60
4 CP Cacereño Fem Cacereño 26 64 26 55
5 Málaga CF Fem Málaga 26 54 27 51
6 Extremadura Fem Extremadura 26 48 45 36
7 La Rambla Fem Rambla 25 44 50 33
8 UD Carmelitas Fem Carmelitas 26 21 69 25
9 CD Algaidas Fem Algaidas 26 39 73 25
10 At. Monachil Fem Monachil 26 33 63 23
11 AD Nervión Fem Nervión 26 41 71 23
12 Triana CF Fem Triana 26 31 50 21
13 At. Las Delicias Fem Delicias 25 22 78 13
14 CD Ciconia Negra Fem Ciconia 26 27 91 12
Ver
TEMPORADA 2012/2013
Equipo PJ GF GC Puntos
1 Granada CF Fem Granada 26 91 27 66
2 Sevilla B Fem Sevilla 26 46 27 53
3 Santa Teresa Fem Santa Teresa 26 71 28 53
4 La Rambla Fem Rambla 26 50 26 51
5 Real Betis Fem Real Betis 26 41 33 43
6 Málaga CF Fem Málaga 26 61 51 42
7 CP Cacereño Fem Cacereño 26 46 29 38
8 Extremadura Fem Extremadura 26 45 37 36
9 CD Algaidas Fem Algaidas 26 50 67 33
10 Triana CF Fem Triana 26 29 42 26
11 UD Carmelitas Fem Carmelitas 26 29 44 26
12 El Naranjo Fem Naranjo 26 50 72 25
13 CFF Badajoz Fem Badajoz 26 36 76 25
14 Mezquita CF Fem Mezquita 26 15 101 5
Ver
TEMPORADA 2011/2012
Equipo PJ GF GC Puntos
1 Sevilla FC Fem Sevilla 26 121 12 68
2 CP Cacereño Fem Cacereño 26 92 25 57
3 Granada CF Fem Granada 26 77 27 50
4 Extremadura Fem Extremadura 26 68 41 49
5 La Rambla Fem Rambla 26 52 30 46
6 Santa Teresa Fem Santa Teresa 26 48 41 42
7 UD Carmelitas Fem Carmelitas 26 43 37 39
8 CD Algaidas Fem Algaidas 26 61 45 38
9 Ad Taraguilla Taraguilla 26 54 63 32
10 Triana CF Fem Triana 26 47 54 31
11 Mezquita CF Fem Mezquita 26 38 65 25
12 At. Monachil Fem Monachil 26 27 71 20
13 CD Híspalis Fem Híspalis 26 34 87 16
14 Séneca Cf Séneca Cf 26 5 169 2

  USO DE MEMORIA  
5,701,240 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0021
Controller Execution Time ( Home / Category )  0.0943
Total Execution Time  0.0964
  CADENA URL  
/segunda_division_femenina2020/grupo4/historico
  GET DATOS  
$_GET['/segunda_division_femenina2020/grupo4/historico']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (26)  
0.0018  SELECT type FROM routes WHERE alias = 'segunda_division_femenina2020'
0.0040  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'segunda_division_femenina' AND (l.group_code = 4 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 2020 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=4 DESC LIMIT 1
0.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=283 AND type_rel = 3
0.0024  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 3 AND rel.typeId = 283 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 (1164991,1162584,1162003,1156102,1154142) ORDER BY n.cover_points DESC, update_date DESC
0.0018  SELECT id,name,alias,stepParent FROM categories WHERE parentId=283 ORDER BY order_id ASC
0.0020  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 = 50902 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0022  SELECT id,year,current_round,total_teams,legend FROM leagues WHERE categoryId = 283 AND group_code = 4 and tables = 1 AND year <= 2020 AND total_num_tablesR >= 1 ORDER BY year DESC LIMIT 22
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 = 50902 AND t.round = 19 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 `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 = 44732 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0025  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 = 39301 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0021  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 = 35131 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0021  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 = 16654 AND t.round = 26 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 `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 = 4404 AND t.round = 26 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 `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 = 2752 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 = 2118 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0041  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 = 1851 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-27 22:27:26' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0022  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=2 AND last_update > '2024-04-27 22:27:26' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0032  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=4 AND last_update > '2024-04-27 22:27:26' 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-27 22:27:26' 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_femenina' AND (l.group_code = 0 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 2020 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=0 DESC LIMIT 1
0.0021  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 events2020 e ON e.player_id = p.id AND e.league_id = 50902 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 50902 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.0019  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 events2020 e ON e.player_id = p.id AND e.league_id = 50902 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 50902 AND (e.action = 4 or e.action = 5) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0021  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 events2020 e ON e.player_id = p.id AND e.league_id = 50902 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 50902 AND (e.action = 3 or e.action = 4) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0031  SELECT *,(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 = 50902 AND t.round = 19 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC