4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del Racing Fem
TEMPORADA 2023/2024
SEGUNDA FEDERACIÓN FEMENINA GRUPO 1
Equipo PJ GF GC Puntos
1 Real Madrid B Fem Real Madrid 29 51 16 70
2 Atlético Baleares Fem Atlético 29 51 27 61
3 Viajes Interrías Fem Viajes 28 45 28 57
4 Real Oviedo Fem Real Oviedo 29 39 25 54
5 Zaragoza CFF Fem Zaragoza 29 40 32 43
6 Racing Fem Racing Fem 29 37 31 43
7 R. Sociedad B Fem Sociedad 29 44 39 43
8 Pradejon Fem Pradejon 29 35 30 40
9 Huesca Fem Huesca Fem 29 33 37 35
10 Real Sporting Fem Real 29 37 48 33
11 Rayo Vallecano Fem Rayo 29 28 38 33
12 Atlético C Fem Atlético 29 28 36 32
13 Osasuna B Fem Osasuna 29 36 55 26
14 Athletic Club C Fem Athletic 28 30 52 25
15 Espanyol B Fem Espanyol 29 37 65 22
16 Club Bizkerre Fem Club 29 27 39 21
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 3
Equipo PJ GF GC Puntos
1 Deportivo Alavés Fem Deportivo 24 50 21 55
2 Osasuna Fem Osasuna Fem 24 60 27 54
3 Real Oviedo Fem Real Oviedo 22 34 26 40
4 Barcelona B Fem Barcelona 24 47 26 41
5 AEM Fem AEM Fem 24 38 21 39
6 Atlético B Fem Atlético 22 30 29 30
7 Racing Fem Racing Fem 22 29 33 29
8 Madrid CF B Fem Madrid 22 22 39 22
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 1
Equipo PJ GF GC Puntos
1 Deportivo Abanca Fem Deportivo 26 150 13 76
2 Real Oviedo Fem Real Oviedo 26 106 25 66
3 PM Friol Fem Friol 26 76 29 53
4 Racing Fem Racing Fem 26 87 31 51
5 Atlantida Matama Atlantida 26 60 42 47
6 Real Sporting Fem Real 26 67 47 43
7 Victoria CF Fem Victoria 26 41 47 38
8 Victoria FC Fem Victoria 26 33 48 35
9 Monte Fem Monte Fem 26 41 52 32
10 Valladares Valladares 26 29 66 23
11 Gijón Fem Gijón Fem 26 27 85 19
12 Sárdoma Fem Sárdoma 26 32 86 15
13 Atlético Arousana Fem Atlético 26 28 124 9
14 Oceja-Gimnastica Fem Oceja-Gimnas 26 26 108 9
TEMPORADA 2017/2018
TERCERA FEDERACIÓN FEMENINA GRUPO 1
Equipo PJ GF GC Puntos
1 Real Oviedo Fem Real Oviedo 26 114 7 75
2 Deportivo Abanca Fem Deportivo 26 155 11 73
3 Monte Fem Monte Fem 26 65 34 54
4 Atlantida Matama Atlantida 26 56 29 49
5 Racing Fem Racing Fem 26 84 42 46
6 Sárdoma Fem Sárdoma 26 55 35 42
7 Victoria CF Fem Victoria 26 54 47 41
8 PM Friol Fem Friol 26 53 54 37
9 Real Sporting Fem Real 26 55 53 32
10 Victoria FC Fem Victoria 26 32 52 31
11 Gijón Fem Gijón Fem 26 32 74 23
12 Llanera Fem Llanera Fem 26 29 106 19
13 Femiastur Femiastur 26 24 117 10
14 Vimenor Vimenor 26 6 153 0
TEMPORADA 2016/2017
TERCERA FEDERACIÓN FEMENINA GRUPO 1
Equipo PJ GF GC Puntos
1 Real Oviedo Fem Real Oviedo 26 108 9 70
2 Deportivo Abanca Fem Deportivo 26 120 19 65
3 Real Sporting Fem Real 26 75 36 53
4 Atlantida Matama Atlantida 26 62 29 52
5 PM Friol Fem Friol 26 67 42 51
6 Racing Fem Racing Fem 26 90 57 47
7 Sárdoma Fem Sárdoma 26 49 36 38
8 Victoria CF Fem Victoria 26 51 55 34
9 Femiastur Femiastur 26 55 67 26
10 Gijón Fem Gijón Fem 26 35 84 25
11 El Olivo Fem Olivo 26 33 85 22
12 Monte Fem Monte Fem 26 41 72 21
13 Atlético Arousana Fem Atlético 26 28 120 11
14 Tordoia Tordoia 26 23 126 8
TEMPORADA 2015/2016
TERCERA FEDERACIÓN FEMENINA GRUPO 1
Equipo PJ GF GC Puntos
1 El Olivo Fem Olivo 24 113 18 65
2 PM Friol Fem Friol 24 99 35 58
3 Sárdoma Fem Sárdoma 24 50 28 46
4 Atlético Arousana Fem Atlético 24 74 63 42
5 EF Mareo Femenino Mareo 24 56 49 40
6 Racing Fem Racing Fem 24 55 49 38
7 Victoria CF Fem Victoria 24 67 54 34
8 Deportivo Abanca Fem Deportivo 24 42 32 33
9 Femiastur Femiastur 24 35 39 29
10 CD Zamora Amigos del Duero Zamora 24 36 46 27
11 Tordoia Tordoia 24 27 84 19
12 Milagrosa Milagrosa 24 25 54 15
13 Erizana CF Femenino Erizana 24 10 138 0

  USO DE MEMORIA  
5,920,312 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0020
Controller Execution Time ( Home / Category )  0.5454
Total Execution Time  0.5474
  CADENA URL  
/historico/Ave-Fenix-Racing-Femenino
  GET DATOS  
$_GET['/historico/Ave-Fenix-Racing-Femenino']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (33)  
0.0157  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 = 'Ave-Fenix-Racing-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.0129  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=66081 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0161  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=66081 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0126  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=66081 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0128  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=66081 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0136  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=66081 AND type_rel = 2
0.0127  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 2 AND rel.typeId = 66081 AND rel.ln = 'es' ORDER BY rel.cover_points DESC LIMIT 5
0.0129  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 (409023,680636,686911,707905,1052088) ORDER BY n.cover_points DESC, update_date DESC
0.0128  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 = '66081' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0127  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 = 73459 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0131  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=66081 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0129  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 (74006,73659,73459) 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.0130  SELECT count(id) as num_players from rel_players WHERE league_id = 73459 AND teamId = 66081
0.0133  SELECT count(id) as num_players from rel_players WHERE league_id = 74006 AND teamId = 66081
0.0132  SELECT count(id) as num_players from rel_players WHERE league_id = 73659 AND teamId = 66081
0.0125  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 = 74006 AND t.round = 7 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0126  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 = '66081' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0126  SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '66081' and rp.type = 4
0.0126  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 = '66081' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0127  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 = 66081 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.0126  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 = 66081 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0128  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 = 66081 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0128  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 = 66081 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.0130  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 = 73459 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.0128  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.0129  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.0129  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.0130  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 = 61714 AND t.round = 8 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0128  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.0128  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 = 44728 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0128  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 = 39302 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0128  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 = 35128 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0129  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 = 16651 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC