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

Girona Fem

Entrenador: Eduardo Sanmartin Lois

Temporada 2023/2024
TEMPORADA 2023/2024
PREF. FEMENINA CATALANA
Equipo PJ GF GC Puntos
1 Levante Las Planas Fem B Levante 26 119 14 74
2 Porqueres Fem Porqueres 27 73 28 66
3 Girona Fem Girona Fem 26 82 26 58
4 EF Mataró Fem Mataró 27 73 38 50
5 Sant Cugat Fem Sant Cugat 27 81 45 47
6 FPFB Reus Fem FPFB Reus 26 54 39 38
7 Cerdanyola del Vallès Fem Cerdanyola 27 54 53 38
8 Pallejà Fem Pallejà 26 52 53 37
9 La Roca Penya Blanc Fem Roca Penya. 26 44 50 36
10 Terrassa Fem Terrassa 27 54 56 35
11 Pontenc Fem Pontenc Fem 27 62 77 32
12 Santa Susanna Fem Santa 27 45 62 29
13 EE Guineueta Fem Guineueta 26 47 50 27
14 Viladecans Fem Viladecans 27 42 51 26
15 Llerona Fem Llerona Fem 26 40 63 26
16 Martinenc Fem Martinenc 26 54 73 20
17 CF Badalona Fem Badalona 28 1 199 0
TEMPORADA 2021/2022
PREF. FEMENINA CATALANA GRUPO 2
Equipo PJ GF GC Puntos
1 Porqueres A Porqueres A 20 42 11 45
2 Palautordera Palautordera 18 57 14 43
3 Terrassa Fem Terrassa 19 54 21 40
4 La Roca Penya Blanc Fem Roca Penya. 19 46 28 34
5 Martinenc Fem Martinenc 20 42 37 27
6 Cerdanyola del Vallès Fem Cerdanyola 20 36 36 27
7 Girona Fem Girona Fem 18 38 22 26
8 Llerona Fem Llerona Fem 20 24 47 19
9 Pontenc Fem Pontenc Fem 17 21 42 16
10 Sabadell CE A Sabadell 19 17 52 13
11 F. Jupiter A Jupiter 20 8 75 4
TEMPORADA 2020/2021
TERCERA FEDERACIÓN FEMENINA GRUPO 5
Equipo PJ GF GC Puntos
1 Levante Las Planas Fem Levante 28 79 25 65
2 Sant Gabriel Fem Sant Gabriel 28 62 23 60
3 Atlético Baleares Fem Atlético 28 52 32 51
4 CE Europa Fem Europa 28 56 42 46
5 Son Sardina Fem Sardina 28 47 39 46
6 Vic Riuprimer Refo Fem Riuprimer 28 45 45 43
7 Riudoms Fem Riudoms Fem 28 58 53 40
8 Pardinyes Fem Pardinyes 28 48 47 40
9 Huesca Fem Huesca Fem 28 42 42 39
10 Zaragoza B Fem Zaragoza 28 32 47 33
11 CF Igualada Fem Igualada 28 53 58 33
12 Girona Fem Girona Fem 28 35 50 30
13 Terrassa Fem Terrassa 28 36 60 28
14 Collerense B Collerense 28 36 68 15
15 Pallejà Fem Pallejà 28 26 76 13
TEMPORADA 2019/2020
1ª CATALANA FEMENINA GRUPO 2
Equipo PJ GF GC Puntos
1 Martinenc Fem Martinenc 21 71 29 53
2 Girona Fem Girona Fem 21 45 24 42
3 Seagull B Seagull B 21 48 20 40
4 Fundacio Unió Esportiva Olo Fundacio 21 55 36 38
5 EF Mataró Fem Mataró 20 64 35 35
6 Pontenc Fem Pontenc Fem 19 41 38 31
7 CF Torelló CF Torelló 21 33 32 31
8 Santa Eugenia A A Santa 21 27 39 29
9 Mon Femeni Sant Adria Femeni Sant 19 29 32 27
10 Sant Quirze Valles A A Sant Quirze 21 26 29 26
11 Base Montcada Club Futbol A Base 20 42 61 22
12 EE Guineueta Fem Guineueta 21 38 50 20
13 Vilassar Mar A Vilassar 21 41 61 20
14 Unificación Santa Perpetua Unificación 21 21 50 16
15 Cabanes A Cabanes A 19 26 47 14
16 Tona A Tona A 21 35 59 14
TEMPORADA 2018/2019
2ª CATALANA FEMENINA GRUPO 4
Equipo PJ GF GC Puntos
1 Cabanes A Cabanes A 26 100 26 71
2 Tona A Tona A 28 78 29 63
3 Girona Fem Girona Fem 25 99 24 61
4 CF Torelló CF Torelló 27 88 38 58
5 Cassa A Cassa A 28 96 53 52
6 Pontenc Club Esportiu B Pontenc Club 26 49 61 33
7 La Pera A La Pera A 24 66 70 32
8 Taradell A Taradell A 26 63 68 31
9 OAR Vic OAR Vic 28 61 75 31
10 Sant Pere Pescador B Sant Pere P. 27 57 73 31
11 Gurb A Gurb A 27 53 73 29
12 Canet A Canet A 24 68 73 27
13 Ripoll Atletic Club Futbol Ripoll 25 40 49 26
14 Moià Moià 28 55 157 19
15 Gerunda Futbol Club B Gerunda 1 1 4 0
16 UE Sant Fost Sant Fost 22 15 116 0
TEMPORADA 2017/2018
2ª CATALANA FEMENINA GRUPO 6
Equipo PJ GF GC Puntos
1 Fundacio Unió Esportiva Olo Fundacio 21 126 15 60
2 Girona Fem Girona Fem 17 116 10 46
3 Pontenc Club Esportiu B Pontenc Club 21 57 31 41
4 La Pera A La Pera A 21 88 54 37
5 Ripoll Atletic Club Futbol Ripoll 20 41 34 34
6 Quart A Quart A 20 62 52 29
7 Vila Sacra A A Vila Sacra 20 29 81 22
8 Vilobi A Vilobi A 23 36 78 20
9 Porqueres B B Porqueres 16 37 52 19
10 La BatllÒria A A BatllÒria 19 20 48 15
11 Fundacio Esportiva Camprodo Fundacio 20 14 66 10
12 Gerunda Futbol Club Gerunda 21 23 115 7
13 FlaÇa A FlaÇa A 3 3 16 1
14 Lloretenc A A Lloretenc 0 0 0 0
TEMPORADA 2015/2016
1ª CATALANA FEMENINA GRUPO 3
Equipo PJ GF GC Puntos
1 CE Pontenc CE Pontenc 30 132 40 80
2 Vic Riuprimer Refo Fem Riuprimer 30 137 38 73
3 CF Vall d'en Bas Vall d'en 30 114 64 64
4 Girona Fem Girona Fem 30 78 43 59
5 UE Cabanes UE Cabanes 30 118 65 58
6 FC Pradenc FC Pradenc 30 95 46 58
7 AEC Manlleu AEC Manlleu 30 67 52 54
8 CF Palautordera Palautordera 30 101 83 49
9 EF Bonaire EF Bonaire 30 82 86 35
10 CF Sant Julià Vilatorta Sant Julià 30 69 106 32
11 Seva Seva 30 49 82 30
12 Llerona Fem Llerona Fem 30 50 84 27
13 UE La Pera UE La Pera 30 64 107 26
14 EF Sant Feliu de Giuxols Sant Feliu. 30 37 106 24
15 CE Sant Esteve d'en Bas Sant Esteve 30 45 103 23
16 Atlètic Club Banyoles Atlètic 30 32 165 3
TEMPORADA 2014/2015
1ª CATALANA FEMENINA GRUPO 3
Equipo PJ GF GC Puntos
1 Porqueres A Porqueres A 26 82 24 67
2 Manlleu A Manlleu A 25 121 41 61
3 Girona Fem Girona Fem 26 76 36 56
4 EF Montcada C A Montcada 26 79 49 56
5 Cabanes A Cabanes A 25 73 48 48
6 La Pera A La Pera A 26 68 50 42
7 Pontenc Fem Pontenc Fem 26 80 72 37
8 Vic Riuprimer Refo Fem Riuprimer 26 65 67 34
9 Palautordera Palautordera 26 50 78 29
10 Atl. Banyoles A Atl. 26 56 68 28
11 La Salle Premia A Salle Premia 25 44 74 28
12 Granollers A Granollers 26 43 90 14
13 S. Julia Vilatorta A Julia 25 39 93 10
14 Portbou A Portbou A 26 23 109 9
15 Sils A Sils A 0 0 0 0
TEMPORADA 2012/2013
TERCERA FEDERACIÓN FEMENINA GRUPO 3
Equipo PJ GF GC Puntos
1 Girona Fem Girona Fem 26 71 27 56
2 Club Gimnàstic Femenino Club 26 49 27 52
3 Espanyol B Fem Espanyol 26 52 28 48
4 Ue Sant Andreu Sant Andreu 26 51 30 46
5 Barcelona B Fem Barcelona 26 59 49 46
6 CF Badalona Fem Badalona 26 46 39 39
7 Cd San Gabriel B Gabriel 26 45 41 39
8 Club Lleida Esportiu Club Lleida 26 49 42 37
9 Cerdanyola Del Vallès Fc Cerdanyola 26 39 40 29
10 Cd Transportes Alcaine B Transportes 26 30 36 29
11 Ue L´estartit L´estartit 26 42 57 27
12 Ue Vic Ue Vic 26 21 40 26
13 Cf Lloret Femenino Lloret 26 58 80 23
14 Ef Bonaire Femenino Bonaire 26 30 106 6
TEMPORADA 2011/2012
TERCERA FEDERACIÓN FEMENINA GRUPO 3
Equipo PJ GF GC Puntos
1 Levante Las Planas Fem Levante 26 63 24 61
2 Girona Fem Girona Fem 26 54 21 49
3 Barcelona B Fem Barcelona 26 51 32 49
4 Ue Vic Ue Vic 26 64 48 45
5 Espanyol B Fem Espanyol 26 42 31 42
6 Club Lleida Esportiu Club Lleida 26 46 42 40
7 Cerdanyola Del Vallès Fc Cerdanyola 26 40 45 34
8 Cd San Gabriel B Gabriel 26 50 49 30
9 Ue Sant Andreu Sant Andreu 26 36 56 29
10 CF Badalona Fem Badalona 26 35 51 28
11 CE Europa Fem Europa 26 39 47 24
12 Fe Atlètic Vilafranca Atlètic 26 32 77 19
13 Cd Peñas Oscenses Peñas 26 18 85 11

  USO DE MEMORIA  
5,790,304 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0014
Controller Execution Time ( Home / Category )  0.6030
Total Execution Time  0.6044
  CADENA URL  
/historico/Girona-Fc-Femenino
  GET DATOS  
$_GET['/historico/Girona-Fc-Femenino']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (32)  
0.0159  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 = 'Girona-Fc-Femenino' AND l.year = 2024 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.0145  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=8896 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0145  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=8896 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0296  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 = 74133
0.0144  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=8896 AND type_rel = 2
0.0145  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=727 AND type_rel = 3
0.0149  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 = '8896' ORDER BY l.year DESC,cat.coefficient DESC
0.0148  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 = '8896' AND l.year = 2024 ORDER BY l.year DESC,cat.coefficient DESC
0.0147  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 = '8896' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0146  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 = 74133 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0147  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=8896 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0145  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 (74133) 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.0145  SELECT count(id) as num_players from rel_players WHERE league_id = 74133 AND teamId = 8896
0.0150  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff 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 = 74133 AND t.round = 30 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0147  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 = '8896' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0145  SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '8896' and rp.type = 4
0.0147  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 = '8896' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0149  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 events2024 e ON e.player_id = p.id AND e.league_id = 74133 WHERE rp.league_id = 74133 AND rp.teamId = 8896 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.0148  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 events2024 e ON e.player_id = p.id AND e.league_id = 74133 WHERE rp.league_id = 74133 AND rp.teamId = 8896 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0146  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 events2024 e ON e.player_id = p.id AND e.league_id = 74133 WHERE rp.league_id = 74133 AND rp.teamId = 8896 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0148  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 = 8896 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
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 `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 = 74133 AND t.round = 30 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0147  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_base` 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 = 64724 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.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 `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 = 59081 AND t.round = 30 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0151  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 = 55299 AND t.round = 21 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
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 `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 = 48165 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0148  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 = 41726 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0150  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 = 19603 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0148  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 = 7263 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
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 `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 = 2117 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0148  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 = 1850 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0146  SELECT dt.nameShow, dt.basealias, t.id, dt.id as dt_id FROM `teams` as t INNER JOIN `datateams` as dt ON dt.id = t.teamId WHERE league_id = 74133 ORDER BY nameShow LIMIT 100