4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del CD Parquesol Fem
TEMPORADA 2023/2024
TERCERA FEDERACIÓN FEMENINA GRUPO 2
Equipo PJ GF GC Puntos
1 Eibar B Fem Eibar B Fem 27 86 23 68
2 Burgos CF Fem Burgos 27 48 20 59
3 Añorga KKE Fem Añorga 27 62 28 55
4 Oiartzun KE Fem Oiartzun 27 56 28 53
5 Mulier FCN Fem Mulier 27 47 29 51
6 CD Arratia Fem Arratia 27 48 29 46
7 CD Parquesol Fem Parquesol 27 31 32 41
8 Osasuna C Fem Osasuna 27 41 47 39
9 UD Logroñés Fem Logroñés 27 43 37 39
10 Tolosa CF Fem Tolosa 27 46 33 37
11 Bizkerre Club B Fem Bizkerre 27 50 49 33
12 CD Salamanca Fem Salamanca 27 36 51 33
13 SD San Ignacio Fem Ignacio 27 35 58 26
14 Berriozar Fem Berriozar 27 33 64 22
15 UD Mutilvera Fem Mutilvera 27 24 68 10
16 Monte Fem Monte Fem 27 14 104 1
TEMPORADA 2022/2023
SEGUNDA FEDERACIÓN FEMENINA GRUPO 1
Equipo PJ GF GC Puntos
1 Atlético B Fem Atlético 30 58 21 67
2 CE Europa Fem Europa 30 72 31 66
3 Real Madrid B Fem Real Madrid 30 64 23 63
4 Getafe Fem Getafe Fem 30 39 23 56
5 Pradejon Fem Pradejon 30 52 33 52
6 Racing Fem Racing Fem 30 47 32 49
7 Zaragoza CFF Fem Zaragoza 30 58 47 43
8 Espanyol B Fem Espanyol 30 48 49 42
9 Osasuna B Fem Osasuna 30 42 48 40
10 Club Bizkerre Fem Club 30 26 33 40
11 Viajes Interrías Fem Viajes 30 35 40 36
12 Athletic Club C Fem Athletic 30 25 48 34
13 CD Parquesol Fem Parquesol 30 29 58 30
14 Sárdoma Fem Sárdoma 30 28 60 26
15 PM Friol Fem Friol 30 34 72 17
16 Torrelodones CF Fem Torrelodones 30 26 65 15
TEMPORADA 2021/2022
PRIMERA DIVISIÓN B FEMENINA GRUPO 1
Equipo PJ GF GC Puntos
1 Levante Las Planas Fem Levante 30 64 37 62
2 Espanyol Fem Espanyol 30 50 34 58
3 Osasuna Fem Osasuna Fem 30 56 33 57
4 DUX Logroño Fem Logroño 30 48 33 53
5 Barcelona B Fem Barcelona 30 52 32 51
6 Deportivo Abanca Fem Deportivo 30 49 29 51
7 AEM Fem AEM Fem 30 46 39 50
8 Real Oviedo Fem Real Oviedo 30 38 36 46
9 Zaragoza CFF Fem Zaragoza 30 45 45 43
10 Athletic Club B Fem Athletic 30 44 41 39
11 CD Parquesol Fem Parquesol 30 41 51 38
12 Racing Fem Racing Fem 30 37 43 38
13 Pradejon Fem Pradejon 30 32 53 30
14 Atlético B Fem Atlético 30 34 60 30
15 Real Sporting Fem Real 30 33 53 23
16 Seagull Fem Seagull Fem 30 23 73 9
TEMPORADA 2020/2021
PRIMERA DIVISIÓN B FEMENINA GRUPO 4
Equipo PJ GF GC Puntos
1 Seagull Fem Seagull Fem 24 43 34 43
2 Zaragoza CFF Fem Zaragoza 24 34 23 41
3 Athletic Club B Fem Athletic 24 41 29 37
4 CD Parquesol Fem Parquesol 24 31 41 26
5 Real Sporting Fem Real 24 43 48 25
6 Espanyol B Fem Espanyol 24 27 60 24
7 CF Pozuelo Fem Pozuelo 24 22 42 21
8 Collerense Fem Collerense 24 35 60 18
9 PM Friol Fem Friol 24 25 52 15
TEMPORADA 2019/2020
PRIMERA DIVISIÓN B FEMENINA GRUPO 1
Equipo PJ GF GC Puntos
1 Athletic Club B Fem Athletic 22 43 17 48
2 Eibar Fem Eibar Fem 22 37 13 46
3 Barcelona B Fem Barcelona 22 61 28 45
4 Osasuna Fem Osasuna Fem 22 41 24 41
5 Deportivo Alavés Fem Deportivo 22 38 26 41
6 Seagull Fem Seagull Fem 22 38 27 35
7 AEM Fem AEM Fem 22 29 28 35
8 Zaragoza CFF Fem Zaragoza 22 43 46 32
9 Real Oviedo Fem Real Oviedo 22 37 37 31
10 CD Parquesol Fem Parquesol 22 33 31 28
11 Madrid CF B Fem Madrid 22 27 40 26
12 Atlético B Fem Atlético 22 32 34 26
13 Racing Fem Racing Fem 22 37 35 25
14 PM Friol Fem Friol 22 25 55 19
15 CF Pozuelo Fem Pozuelo 22 12 40 13
16 Real Sporting Fem Real 22 12 64 8
TEMPORADA 2018/2019
TERCERA FEDERACIÓN FEMENINA GRUPO 5
Equipo PJ GF GC Puntos
1 Real Madrid Fem Real Madrid 26 74 4 70
2 CD Parquesol Fem Parquesol 26 56 26 56
3 Atlético B Fem Atlético 26 69 27 55
4 CF Pozuelo Fem Pozuelo 26 51 18 49
5 Madrid CF B Fem Madrid 26 59 25 47
6 AD Alhóndiga Alhóndiga 26 39 34 43
7 Rayo Vallecano B Fem Rayo 26 37 33 42
8 Torrelodones CF Fem Torrelodones 26 31 31 39
9 Dinamo Guadalajara Fem Dinamo 26 38 35 37
10 La Solana Fem Solana 26 37 51 25
11 Olímpico de Madrid Fem Olímpico 26 40 56 23
12 CD Salamanca Fem Salamanca 26 29 63 20
13 León Ff León Ff 26 29 79 15
14 Burgos CF Fem Burgos 26 10 117 0
TEMPORADA 2017/2018
TERCERA FEDERACIÓN FEMENINA GRUPO 5
Equipo PJ GF GC Puntos
1 Real Madrid Fem Real Madrid 26 107 9 71
2 Atlético B Fem Atlético 26 72 12 65
3 CD Parquesol Fem Parquesol 26 51 31 47
4 Rayo Vallecano B Fem Rayo 26 48 27 46
5 Madrid CF B Fem Madrid 26 49 43 44
6 CF Pozuelo Fem Pozuelo 26 47 37 43
7 AD Alhóndiga Alhóndiga 26 41 33 39
8 Dinamo Guadalajara Fem Dinamo 26 44 36 33
9 León Ff León Ff 26 39 58 33
10 Olímpico de Madrid Fem Olímpico 26 39 50 30
11 Burgos CF Fem Burgos 26 25 51 25
12 Fuensalida Fuensalida 26 29 88 16
13 Vallecas Vallecas 26 27 85 13
14 CD Zamora Amigos del Duero Zamora 26 30 88 7
TEMPORADA 2016/2017
TERCERA FEDERACIÓN FEMENINA GRUPO 5
Equipo PJ GF GC Puntos
1 Madrid CFF Fem Madrid 26 140 18 73
2 Real Madrid Fem Real Madrid 26 95 18 66
3 Atlético B Fem Atlético 26 69 20 63
4 CD Parquesol Fem Parquesol 26 37 42 39
5 Dinamo Guadalajara Fem Dinamo 26 40 51 35
6 Olímpico de Madrid Fem Olímpico 26 36 56 32
7 Rayo Vallecano B Fem Rayo 26 24 29 31
8 Vallecas Vallecas 26 48 76 31
9 CD Zamora Amigos del Duero Zamora 26 36 48 28
10 AD Alhóndiga Alhóndiga 26 35 54 28
11 CF Pozuelo Fem Pozuelo 26 30 57 27
12 San Pío X San Pío X 26 36 65 25
13 Torrelodones CF Fem Torrelodones 26 24 51 21
14 Guadamur Femenino Guadamur 26 25 90 14
TEMPORADA 2015/2016
TERCERA FEDERACIÓN FEMENINA GRUPO 5
Equipo PJ GF GC Puntos
1 Atlético B Fem Atlético 26 66 16 65
2 Madrid CFF Fem Madrid 26 82 24 60
3 Real Madrid Fem Real Madrid 26 44 27 51
4 Dinamo Guadalajara Fem Dinamo 26 49 35 50
5 La Solana Fem Solana 26 43 29 49
6 AD Alhóndiga Alhóndiga 26 53 32 42
7 Rayo Vallecano B Fem Rayo 26 31 43 33
8 Torrelodones CF Fem Torrelodones 26 32 45 32
9 CD Parquesol Fem Parquesol 26 38 40 31
10 Olímpico de Madrid Fem Olímpico 26 36 36 30
11 CF Pozuelo Fem Pozuelo 26 39 49 29
12 Casa Social Católica Fem Casa Social 26 30 55 28
13 Cff Sur Getafe Getafe 26 25 84 13
14 CD Salamanca Fem Salamanca 26 24 77 8
TEMPORADA 2014/2015
TERCERA FEDERACIÓN FEMENINA GRUPO 5
Equipo PJ GF GC Puntos
1 Madrid CFF Fem Madrid 26 117 16 69
2 Real Madrid Fem Real Madrid 26 58 27 59
3 Atlético B Fem Atlético 26 59 23 52
4 AD Alhóndiga Alhóndiga 26 66 43 48
5 CF Pozuelo Fem Pozuelo 26 54 33 47
6 La Solana Fem Solana 26 47 37 45
7 Dinamo Guadalajara Fem Dinamo 26 44 37 43
8 Rayo Vallecano B Fem Rayo 26 40 51 30
9 CD Parquesol Fem Parquesol 26 37 45 29
10 Casa Social Católica Fem Casa Social 26 40 64 27
11 Torrelodones CF Fem Torrelodones 26 22 45 25
12 Cde Tnt Daimiel Femenino Daimiel 26 23 65 20
13 UD Tres Cantos Fem Tres Cantos 26 31 55 18
14 Independiente Alcazar Independient 26 16 113 2
TEMPORADA 2013/2014
TERCERA FEDERACIÓN FEMENINA GRUPO 1
Equipo PJ GF GC Puntos
1 El Olivo Fem Olivo 26 104 24 71
2 PM Friol Fem Friol 26 69 31 56
3 CD Parquesol Fem Parquesol 26 56 29 46
4 CD Salamanca Fem Salamanca 26 61 49 46
5 Victoria CF Fem Victoria 26 48 31 43
6 EF Mareo Femenino Mareo 26 45 42 38
7 CF Bértola Femenino Bértola 26 40 46 36
8 Sárdoma Fem Sárdoma 26 43 53 33
9 Gijón Ff Gijón Ff 26 42 55 33
10 Erizana CF Femenino Erizana 26 35 53 31
11 UD Barbadás Femenino Barbadás 26 32 47 30
12 Atlético Arousana Fem Atlético 26 47 66 28
13 CD Ponferrada Femenino Ponferrada 26 37 60 22
14 SD Compostela Femenino Compostela 26 14 87 5

  USO DE MEMORIA  
6,096,176 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0012
Controller Execution Time ( Home / Category )  0.0969
Total Execution Time  0.0981
  CADENA URL  
/historico/Cd-Parquesol-Femenino
  GET DATOS  
$_GET['/historico/Cd-Parquesol-Femenino']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (28)  
0.0040  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 = 74014
0.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=12295 AND type_rel = 2
0.0023  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 = '12295' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0023  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 = 74014 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0024  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=12295 AND l.year in (2023,2024,2025) 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 (74014,74006,68578) 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.0018  SELECT count(id) as num_players from rel_players WHERE league_id = 68578 AND teamId = 12295
0.0018  SELECT count(id) as num_players from rel_players WHERE league_id = 74014 AND teamId = 12295
0.0019  SELECT count(id) as num_players from rel_players WHERE league_id = 74006 AND teamId = 12295
0.0020  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 = '12295' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0018  SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '12295' and rp.type = 4
0.0020  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 = '12295' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
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 events2024 e ON e.player_id = p.id AND e.league_id = 74006 WHERE rp.league_id = 74006 AND rp.teamId = 12295 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.0019  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 = 74006 WHERE rp.league_id = 74006 AND rp.teamId = 12295 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 events2024 e ON e.player_id = p.id AND e.league_id = 74006 WHERE rp.league_id = 74006 AND rp.teamId = 12295 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 = 12295 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
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 `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 = 74014 AND t.round = 29 ORDER BY team.conference ASC,t.position 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 `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 = 68578 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.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 `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 = 63312 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.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 = 58765 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 `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 = 61715 AND t.round = 10 ORDER BY team.conference ASC,t.position 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 `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 = 49900 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.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 = 44733 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 `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 = 35132 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 `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 = 16656 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 = 4406 AND t.round = 26 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 `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 = 2754 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0026  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 = 74006 ORDER BY nameShow LIMIT 100