4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
« Temporada Anterior
Temporada 2013
Temporada Siguiente »
Primera División Femenina 2013
2012/2013

primera division femenina de españa, primera iberdrola, liga femenina de españa, campeonato nacional de femenino de españa, liga iberdrola,iberdrola, liga f

Primera División Femenina 2013

  • Barcelona Fem
  • Athletic Fem
  • Atlético Fem
  • Levante Fem
  • Espanyol Fem
  • Rayo Vallecano Fem
  • Zaragoza CFF Fem
  • Sant Gabriel Fem
  • Sporting Huelva Fem
  • Real Sociedad Fem
  • Levante Las Planas Fem
  • Sevilla FC Fem
  • Valencia Fem
  • Collerense Fem
  • C. Llanos Olivenza Fem
  • SD Lagunak

JUGADORES DESTACADOS

Clasificación

Equipo PJ GF GC Puntos
1 Barcelona Fem Barcelona 30 91 13 76
2 Athletic Fem Athletic 30 84 24 74
3 Atlético Fem Atlético 30 70 21 68
4 Levante Fem Levante Fem 30 52 21 65
5 Espanyol Fem Espanyol 30 47 25 54
6 Rayo Vallecano Fem Rayo 30 81 48 49
7 Zaragoza CFF Fem Zaragoza 30 65 77 45
8 Sant Gabriel Fem Sant Gabriel 30 40 44 40
9 Sporting Huelva Fem Sporting 30 41 52 38
10 Real Sociedad Fem Real 30 41 44 33
11 Levante Las Planas Fem Levante 30 34 47 32
12 Sevilla FC Fem Sevilla 30 37 52 30
13 Valencia Fem Valencia 30 29 51 30
14 Collerense Fem Collerense 30 47 77 29
15 C. Llanos Olivenza Fem Llanos 30 30 74 16
16 SD Lagunak SD Lagunak 30 13 132 1

  USO DE MEMORIA  
4,983,952 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0021
Controller Execution Time ( Home / Category )  0.0847
Total Execution Time  0.0868
  CADENA URL  
/primera_division_femenina2013/grupo1/resumen/30
  GET DATOS  
$_GET['/primera_division_femenina2013/grupo1/resumen/30']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (14)  
0.0019  SELECT type FROM routes WHERE alias = 'primera_division_femenina2013'
0.0039  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'primera_division_femenina' AND (l.group_code = 1 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 2013 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=1 DESC LIMIT 1
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 = 2114 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0023  SELECT 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 FROM `calendars2013` 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` = 2114 AND c.`round` = 30 ORDER BY shedule ASC LIMIT 200
0.0030  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 `events2013` e INNER JOIN calendars2013 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 = 30 AND e.real_date IS NOT NULL AND e.league_id = 2114 ORDER BY total DESC LIMIT 100
0.0019  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-04-27 06:53:25' 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-27 06:53:25' 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-27 06:53:25' 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 06:53:25' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0024  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'primera_division_femenina' AND (l.group_code = 0 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 2013 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=0 DESC LIMIT 1
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 events2013 e ON e.player_id = p.id AND e.league_id = 2114 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 2114 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.0025  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 events2013 e ON e.player_id = p.id AND e.league_id = 2114 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 2114 AND (e.action = 4 or e.action = 5) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0023  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 events2013 e ON e.player_id = p.id AND e.league_id = 2114 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 2114 AND (e.action = 3 or e.action = 4) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0051  SELECT *,(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 = 2114 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC