4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del Real Sporting 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 28 50 24 61
3 Viajes Interrías Fem Viajes 28 45 28 57
4 Real Oviedo Fem Real Oviedo 28 36 24 51
5 Racing Fem Racing Fem 29 37 31 43
6 R. Sociedad B Fem Sociedad 28 41 38 40
7 Pradejon Fem Pradejon 29 35 30 40
8 Zaragoza CFF Fem Zaragoza 28 39 32 40
9 Huesca Fem Huesca Fem 28 33 36 35
10 Rayo Vallecano Fem Rayo 29 28 38 33
11 Atlético C Fem Atlético 28 28 35 32
12 Real Sporting Fem Real 28 35 47 30
13 Osasuna B Fem Osasuna 28 35 52 26
14 Athletic Club C Fem Athletic 28 30 52 25
15 Club Bizkerre Fem Club 28 26 37 21
16 Espanyol B Fem Espanyol 28 36 65 19
TEMPORADA 2022/2023
TERCERA FEDERACIÓN FEMENINA GRUPO 1
Equipo PJ GF GC Puntos
1 Real Sporting Fem Real 30 96 13 78
2 Deportivo Abanca Fem B Deportivo 30 112 11 77
3 Real Avilés Fem Real Avilés 29 77 26 65
4 Olímpico de León Fem Olímpico 30 67 32 56
5 Victoria CF Fem Victoria 30 66 32 55
6 Real Oviedo B Fem Real Oviedo 30 82 35 52
7 Lóstrego CF Fem Lóstrego 30 52 32 52
8 Gijón Fem Gijón Fem 30 53 43 48
9 UD Mos Fem UD Mos Fem 30 58 35 46
10 Victoria FC Fem Victoria 30 57 36 43
11 Umia CF Fem Umia CF Fem 30 50 48 37
12 Oceja-Gimnastica Fem Oceja-Gimnas 30 39 56 29
13 Llanera Fem Llanera Fem 30 48 74 29
14 CD Romanón Fem Romanón 30 35 97 18
15 Parquesol B Fem Parquesol 30 20 139 6
16 CD Tropezón Fem Tropezón 29 2 205 0
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 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

  USO DE MEMORIA  
5,569,768 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0012
Controller Execution Time ( Home / Category )  0.1010
Total Execution Time  0.1022
  CADENA URL  
/historico/Sporting-Gijon-Femenino
  GET DATOS  
$_GET['/historico/Sporting-Gijon-Femenino']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (33)  
0.0028  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 = 'Sporting-Gijon-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.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=93710 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=93710 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0017  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=93710 AND type_rel = 2
0.0019  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 2 AND rel.typeId = 93710 AND rel.ln = 'es' ORDER BY rel.cover_points DESC LIMIT 5
0.0021  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 (614043,620202,735175,865363,1035207) ORDER BY n.cover_points DESC, update_date DESC
0.0026  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 = '93710' ORDER BY l.year DESC,cat.coefficient DESC
0.0021  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 = '93710' AND l.year = 2024 ORDER BY l.year DESC,cat.coefficient DESC
0.0021  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 = '93710' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
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 = 73459 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0020  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=93710 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 (73459,68940,68595) 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 = 73459 AND teamId = 93710
0.0018  SELECT count(id) as num_players from rel_players WHERE league_id = 68595 AND teamId = 93710
0.0018  SELECT count(id) as num_players from rel_players WHERE league_id = 68940 AND teamId = 93710
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 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 t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0019  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 = '93710' 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 = '93710' 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 = '93710' 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 = 73459 WHERE rp.league_id = 73459 AND rp.teamId = 93710 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 = 73459 WHERE rp.league_id = 73459 AND rp.teamId = 93710 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0021  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 = 73459 WHERE rp.league_id = 73459 AND rp.teamId = 93710 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0025  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 = 93710 AND l.year <= 2024 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 `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.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 `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 = 68595 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.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 `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.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 `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.0020  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.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 `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 = 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.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 `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.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 `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.0019  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 = 73459 ORDER BY nameShow LIMIT 100