4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del Barcelona Fem

Barcelona Fem

Entrenador: Jonatan Giráldez

Presidente: Joan Laporta

TEMPORADA 2012/2013
PRIMERA DIVISIÓN FEMENINA
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
TEMPORADA 2011/2012
PRIMERA DIVISIÓN FEMENINA
Equipo PJ GF GC Puntos
1 Barcelona Fem Barcelona 34 119 19 94
2 Athletic Fem Athletic 34 118 25 91
3 Espanyol Fem Espanyol 34 117 38 76
4 Rayo Vallecano Fem Rayo 34 90 44 70
5 Levante Fem Levante Fem 34 63 27 68
6 Atlético Fem Atlético 34 83 41 65
7 Real Sociedad Fem Real 34 58 35 62
8 Sporting Huelva Fem Sporting 34 51 48 56
9 Zaragoza CFF Fem Zaragoza 34 72 75 47
10 Sant Gabriel Fem Sant Gabriel 34 55 67 37
11 C. Llanos Olivenza Fem Llanos 34 39 65 35
12 Collerense Fem Collerense 34 54 91 33
13 Valencia Fem Valencia 34 37 83 31
14 SD Lagunak SD Lagunak 34 32 70 31
15 Ue L´estartit L´estartit 34 35 74 29
16 Málaga CF Fem Málaga 34 35 91 23
17 El Olivo Fem Olivo 34 43 112 19
18 Sd Reocín Sd Reocín 34 30 126 9
TEMPORADA 2010/2011
PRIMERA DIVISIÓN FEMENINA GRUPO 4
Equipo PJ GF GC Puntos
1 Espanyol Fem Espanyol 14 42 14 32
2 Rayo Vallecano Fem Rayo 14 41 20 30
3 Athletic Fem Athletic 14 32 15 28
4 Barcelona Fem Barcelona 14 13 13 19
5 Atlético Fem Atlético 14 17 24 17
6 Zaragoza CFF Fem Zaragoza 14 20 31 11
7 Real Sociedad Fem Real 14 9 28 10
8 Sant Gabriel Fem Sant Gabriel 14 19 48 10
TEMPORADA 2009/2010
PRIMERA DIVISIÓN FEMENINA GRUPO 4
Equipo PJ GF GC Puntos
1 Espanyol Fem Espanyol 14 43 8 36
2 Rayo Vallecano Fem Rayo 14 40 12 34
3 Athletic Fem Athletic 14 30 22 29
4 Atlético Fem Atlético 14 18 23 18
5 Barcelona Fem Barcelona 14 16 22 17
6 Zaragoza CFF Fem Zaragoza 14 18 29 12
7 Real Sociedad Fem Real 14 13 35 9
8 Levante Fem Levante Fem 14 8 35 5
TEMPORADA 2008/2009
PRIMERA DIVISIÓN FEMENINA
Equipo PJ GF GC Puntos
1 Rayo Vallecano Fem Rayo 30 98 16 81
2 Levante Fem Levante Fem 30 86 17 76
3 Athletic Fem Athletic 30 100 43 65
4 Espanyol Fem Espanyol 30 70 25 60
5 Zaragoza CFF Fem Zaragoza 30 52 33 51
6 Barcelona Fem Barcelona 30 48 32 49
7 Atlético Fem Atlético 29 48 32 47
8 AD Torrejón Femenino Torrejón 30 52 68 38
9 Sporting Huelva Fem Sporting 30 43 48 37
10 Real Sociedad Fem Real 29 26 45 32
11 SD Lagunak SD Lagunak 30 29 59 32
12 Ue L´estartit L´estartit 30 48 72 31
13 Málaga CF Fem Málaga 30 33 84 26
14 Valencia Fem Valencia 30 39 81 25
15 Extremadura Fem Extremadura 30 28 64 20
16 CF Pozuelo Fem Pozuelo 30 32 113 16
TEMPORADA 2006/2007
PRIMERA DIVISIÓN FEMENINA
Equipo PJ GF GC Puntos
1 Athletic Fem Athletic 26 82 27 64
2 Espanyol Fem Espanyol 26 87 29 63
3 Levante Fem Levante Fem 26 76 25 55
4 Rayo Vallecano Fem Rayo 26 61 40 53
5 CD Híspalis Fem Híspalis 25 51 35 42
6 AD Torrejón Femenino Torrejón 26 42 39 37
7 Extremadura Fem Extremadura 26 34 45 35
8 Atlético Fem Atlético 26 31 46 31
9 Real Sociedad Fem Real 26 30 51 27
10 Sporting Huelva Fem Sporting 25 28 50 24
11 Real Oviedo Fem Real Oviedo 26 29 58 22
12 Zaragoza CFF Fem Zaragoza 26 20 50 20
13 Barcelona Fem Barcelona 26 26 58 16
14 SD Lagunak SD Lagunak 26 28 72 16
TEMPORADA 2005/2006
PRIMERA DIVISIÓN FEMENINA
Equipo PJ GF GC Puntos
1 Espanyol Fem Espanyol 24 80 25 60
2 CD Híspalis Fem Híspalis 23 73 35 56
3 Levante Fem Levante Fem 22 55 15 49
4 Rayo Vallecano Fem Rayo 22 49 34 42
5 Athletic Fem Athletic 22 46 41 37
6 Extremadura Fem Extremadura 21 35 44 34
7 Sporting Huelva Fem Sporting 22 44 35 29
8 SD Lagunak SD Lagunak 23 34 46 26
9 Barcelona Fem Barcelona 22 36 48 25
10 AD Torrejón Femenino Torrejón 21 38 47 19
11 Real Oviedo Fem Real Oviedo 22 34 55 19
12 Zaragoza CFF Fem Zaragoza 22 28 59 18
13 Gijón Fem Gijón Fem 22 17 85 1
TEMPORADA 2004/2005
PRIMERA DIVISIÓN FEMENINA
Equipo PJ GF GC Puntos
1 Athletic Fem Athletic 26 77 15 66
2 Levante Fem Levante Fem 26 74 18 63
3 Espanyol Fem Espanyol 26 92 46 57
4 AD Torrejón Femenino Torrejón 26 52 28 55
5 CD Híspalis Fem Híspalis 26 75 33 51
6 Extremadura Fem Extremadura 26 55 37 43
7 Rayo Vallecano Fem Rayo 26 53 54 34
8 Sabadell A Sabadell A 26 59 63 29
9 Barcelona Fem Barcelona 26 42 59 29
10 Real Oviedo Fem Real Oviedo 26 27 57 23
11 SD Lagunak SD Lagunak 26 23 50 22
12 Sporting Huelva Fem Sporting 26 42 64 20
13 CF Pozuelo Fem Pozuelo 26 24 75 16
14 Burgos CF Fem Burgos 26 23 119 10

  USO DE MEMORIA  
6,070,160 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0013
Controller Execution Time ( Home / Category )  0.1218
Total Execution Time  0.1231
  CADENA URL  
/historico/Fc-Barcelona-Femenino/2013
  GET DATOS  
$_GET['/historico/Fc-Barcelona-Femenino/2013']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (37)  
0.0031  SELECT dt.*,c.active_year,l.year,l.table_suffix, c.ctype, l.id as league_id,t.id as id,t.manager,t.name as nameOriginal,dt.id as teamId,cou.Name as cou_name,cou.Continent,cou.Region FROM `leagues_webci` as l INNER JOIN `teams` as t ON l.id = t.league_id INNER JOIN `datateams` as dt ON dt.id = t.teamId INNER JOIN `categories_webci` as c ON c.id = l.categoryId LEFT JOIN country cou ON LOWER(cou.Code2) = dt.CountryCode WHERE dt.basealias = 'Fc-Barcelona-Femenino' AND l.year = 2013 ORDER BY c.top DESC, c.ctype != 12 DESC, c.troncal DESC, l.end_date >= NOW() DESC, l.start_date <= NOW() DESC, l.year DESC, c.coefficient DESC, l.id ASC
0.0019  SELECT dp.nick, dp.fullname,rp.date_ini, rp.date_end FROM futbol.rel_people rp INNER JOIN futbol.datapeople dp on dp.id=rp.people_id WHERE rp.teamId=8852 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0018  SELECT dp.nick, dp.fullname,rp.date_ini, rp.date_end FROM futbol.rel_people rp INNER JOIN futbol.datapeople dp on dp.id=rp.people_id WHERE rp.teamId=8852 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0018  SELECT dp.nick, dp.fullname,rp.date_ini, rp.date_end FROM futbol.rel_people rp INNER JOIN futbol.datapeople dp on dp.id=rp.people_id WHERE rp.teamId=8852 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0018  SELECT dp.nick, dp.fullname,rp.date_ini, rp.date_end FROM futbol.rel_people rp INNER JOIN futbol.datapeople dp on dp.id=rp.people_id WHERE rp.teamId=8852 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0042  SELECT c.*, l.*, cou.name as namec, ct.table_sufix FROM (leagues l INNER JOIN categories c ON c.id = l.categoryId INNER JOIN categories_types ct ON c.ctype=ct.id LEFT JOIN country cou ON cou.Code2 = c.CountryCode) WHERE l.id = 47709
0.0025  SELECT c.*, l.*, cou.name as namec, ct.table_sufix FROM (leagues l INNER JOIN categories c ON c.id = l.categoryId INNER JOIN categories_types ct ON c.ctype=ct.id LEFT JOIN country cou ON cou.Code2 = c.CountryCode) WHERE l.id = 23438
0.0017  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=8852 AND type_rel = 2
0.0061  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 2 AND rel.typeId = 8852 AND rel.ln = 'es' ORDER BY rel.cover_points DESC LIMIT 5
0.0022  SELECT /*35 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 (10314,15983,17147,17936,19412) ORDER BY n.cover_points DESC, update_date DESC
0.0035  SELECT cat.logo,cat.official,cat.location,dt.nameShow,dt.basealias,t.teamId,l.year,t.qod,cat.coefficient,cat.active_year,cat.name,l.group_code,l.total_group,cat.alias,l.categoryId,l.year,l.id as league_id FROM datateams dt INNER JOIN teams t ON t.teamId = dt.id INNER JOIN leagues l ON l.id = t.league_id INNER JOIN categories cat ON cat.id = l.categoryId WHERE dt.id = '8852' AND l.year = 2013 ORDER BY l.year DESC,cat.coefficient DESC
0.0031  SELECT SQL_NO_CACHE res.id as id, res.group_code, res.total_group, res.logo, res.alias FROM (SELECT ct.active_year, ct.id as id, l.year, l.end,l.group_code, l.total_group, ct.logo, ct.alias FROM categories AS ct INNER JOIN leagues AS l ON ct.id=l.categoryId AND ct.active_year=l.year INNER JOIN teams AS t ON l.id=t.league_id WHERE t.teamId = '8852' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0021  SELECT t.id,t.teamId,t.total_players,dt.nameShow,dt.basealias FROM teams t INNER JOIN datateams dt ON t.teamId = dt.id WHERE t.league_id = 47709 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0019  SELECT t.id,t.teamId,t.total_players,dt.nameShow,dt.basealias FROM teams t INNER JOIN datateams dt ON t.teamId = dt.id WHERE t.league_id = 23438 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0026  SELECT t.id as team_id, ct.id, l.id as idLeague, l.year, ct.name, l.start_date, l.end_date FROM categories AS ct INNER JOIN leagues AS l ON ct.id=l.categoryId INNER JOIN teams AS t ON l.id=t.league_id WHERE t.teamId=8852 AND l.year in (2012,2013,2014) ORDER BY l.id DESC, l.year DESC ;
0.0020  SELECT ct.id, ct.alias, ct.name AS name, ct.active_year, ct.coefficient AS coefficient, l.id AS league_id, l.year, l.total_group FROM categories AS ct INNER JOIN leagues AS l ON ct.id=l.categoryId WHERE l.id IN (47709,23439,2747) ORDER BY ct.ctype != 12 DESC, ct.troncal DESC, ct.coefficient DESC, l.end_date >= NOW() DESC, l.start_date <= NOW() DESC, l.year DESC, ct.coefficient DESC, l.group_code ASC
0.0020  SELECT count(id) as num_players from rel_players WHERE league_id = 2747 AND teamId = 8852
0.0018  SELECT count(id) as num_players from rel_players WHERE league_id = 47709 AND teamId = 8852
0.0018  SELECT count(id) as num_players from rel_players WHERE league_id = 23439 AND teamId = 8852
0.0030  SELECT p.* FROM `rel_pictures` as rp INNER JOIN `pictures` as p ON p.id = rp.id_picture INNER JOIN fa_user u ON u.id = p.author_id WHERE rp.id_content = '8852' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0019  SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '8852' and rp.type = 4
0.0024  SELECT p.* FROM `rel_videos` as rp INNER JOIN `videos` as p ON p.id = rp.id_video INNER JOIN fa_user u ON u.id = p.author_id WHERE rp.id_content = '8852' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0018  SELECT count(id_content) as cuenta FROM `rel_videos` as rp WHERE rp.id_content = '8852' and rp.type = 4
0.0028  SELECT e.action,rp.player_id, count(e.action) as total, p.nick,p.name,p.last_name,p.alias,rp.team_id 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 WHERE rp.league_id = 2114 AND rp.teamId = 8852 AND (e.action = 1 or e.action = 2 or e.action = 11 or e.action = 12 or e.action = 13) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0024  SELECT e.action,rp.player_id, count(e.action) as total, p.nick,p.name,p.last_name,p.alias,rp.team_id 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 WHERE rp.league_id = 2114 AND rp.teamId = 8852 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0020  SELECT e.action,rp.player_id, count(e.action) as total, p.nick,p.name,p.last_name,p.alias,rp.team_id 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 WHERE rp.league_id = 2114 AND rp.teamId = 8852 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0028  SELECT l.id,t.league_id,l.legend,l.year,c.name,l.total_teams,c.alias,l.group_code,l.total_group,l.current_round, l.table_suffix FROM teams t INNER JOIN leagues l ON t.league_id = l.id INNER JOIN categories c ON c.id = l.categoryId WHERE c.troncal = 1 AND t.teamId = 8852 AND l.year <= 2013 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
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 `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
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 `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 = 1847 AND t.round = 34 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 `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 = 23924 AND t.round = 14 ORDER BY team.conference 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 `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 = 23926 AND t.round = 14 ORDER BY team.conference 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 `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 = 23930 AND t.round = 12 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 `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 = 23935 AND t.round = 14 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 `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 = 23940 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 `tables2007` 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 = 23942 AND t.round = 26 ORDER BY team.conference 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 `tables2006` 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 = 23944 AND t.round = 24 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 `tables2005` 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 = 23949 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC