4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del CF Estudiantes
TEMPORADA 2023/2024
TERCERA RFFPA GRUPO 1
Equipo PJ GF GC Puntos
1 Canicas AC Canicas AC 26 108 18 73
2 Unión Astur CF Unión Astur 26 79 25 58
3 CF Estudiantes Estudiantes 26 83 33 57
4 Asunción A Asunción A 27 75 32 55
5 Rayo Gijonés Rayo 27 56 40 52
6 Deportiva Piloñesa Deportiva 26 50 27 47
7 EF Jin EF Jin 28 66 55 40
8 Camocha B Camocha B 26 44 47 36
9 Fortuna Fortuna 27 47 53 33
10 Arenas del Sella Arenas Sella 26 34 52 28
11 CD Aboño CD Aboño 26 48 65 27
12 CD Montevil Montevil 26 43 69 21
13 CD Gijón Perchera Gijón 26 43 71 19
14 Atlantic Gijón A Atlantic 27 46 93 15
15 EF Viesques EF Viesques 26 17 159 3
TEMPORADA 2022/2023
TERCERA RFFPA GRUPO 1
Equipo PJ GF GC Puntos
1 Triple A Gijón Triple 26 83 18 66
2 GD Bosco GD Bosco 26 84 23 60
3 Arguero CF Arguero CF 26 84 35 59
4 Fabril CD Fabril CD 26 86 33 56
5 Unión Astur CF Unión Astur 26 67 38 49
6 Asunción A Asunción A 26 55 43 46
7 CD Aboño CD Aboño 26 52 42 35
8 CF Estudiantes Estudiantes 26 58 47 31
9 Versalles CF Versalles 26 39 47 28
10 Rayo Gijonés Rayo 26 40 74 23
11 Camocha B Camocha B 26 50 73 20
12 CD Montevil Montevil 26 45 93 20
13 Quintueles CF B Quintueles 26 39 100 16
14 Atlantic Gijón A Atlantic 26 22 138 5
TEMPORADA 2021/2022
SEGUNDA RFFPA GRUPO 1
Equipo PJ GF GC Puntos
1 Lealtad de Villaviciosa B Lealtad 24 49 24 51
2 Ribadesella Ribadesella 24 64 22 48
3 Quintueles CF Quintueles 24 48 29 45
4 Canicas AC Canicas AC 24 64 31 42
5 CD Manuel Rubio Manuel Rubio 24 65 34 42
6 Atlético Camocha Atlético 24 56 31 42
7 Urraca CF B Urraca CF B 24 38 30 37
8 Triple A Gijón Triple 24 50 36 33
9 UD Sariego UD Sariego 24 38 53 29
10 Deportiva Piloñesa Deportiva 24 27 39 23
11 CF Estudiantes Estudiantes 24 32 71 21
12 Independiente CF Independient 24 22 59 13
13 CD Deva CD Deva 24 25 119 6
TEMPORADA 2020/2021
SEGUNDA RFFPA GRUPO 1
Equipo PJ GF GC Puntos
1 CD Manuel Rubio Manuel Rubio 8 22 8 21
2 Atlético Camocha Atlético 8 16 12 13
3 Quintueles CF Quintueles 8 14 12 13
4 CF Estudiantes Estudiantes 8 16 23 7
5 Unión Astur CF Unión Astur 8 10 23 4
TEMPORADA 2019/2020
SEGUNDA RFFPA GRUPO 1
Equipo PJ GF GC Puntos
1 Langreo Eulalia Langreo 28 75 30 60
2 Ribadesella Ribadesella 28 46 26 60
3 Gozón Gozón 28 57 29 58
4 Europa de Nava Europa Nava 28 50 31 58
5 CD Manuel Rubio Manuel Rubio 28 53 33 54
6 Arguero Arguero 28 37 40 39
7 Lealtad Villaviciosa B Lealtad 28 41 42 38
8 La Fresneda Fresneda 28 42 55 36
9 Ribadedeva Ribadedeva 28 30 31 35
10 Deportiva Piloñesa Deportiva 28 25 36 34
11 GD Bosco GD Bosco 28 35 54 33
12 Club Hispano Club Hispano 28 45 47 32
13 Quintueles CF Quintueles 28 27 33 31
14 Atlético Camocha Atlético 28 32 54 30
15 Independiente CF Independient 28 39 46 29
16 CF Estudiantes Estudiantes 28 43 55 29
17 SCD Campomanes Campomanes 28 33 52 22
18 Unión Astur CF Unión Astur 28 36 52 21
TEMPORADA 2018/2019
TERCERA RFFPA GRUPO 1
Equipo PJ GF GC Puntos
1 Quintueles CF Quintueles 26 73 26 59
2 Atlético Camocha Atlético 26 76 24 58
3 CF Estudiantes Estudiantes 26 65 31 54
4 Asunción A Asunción A 26 53 24 51
5 Rayo Villalegre Rayo 26 59 42 45
6 CD Pillarno CD Pillarno 26 52 38 44
7 Versalles CF Versalles 26 45 34 44
8 FCR La Calzada Calzada 26 48 58 36
9 UC Ceares B UC Ceares B 26 42 53 26
10 Codema CF Codema CF 26 41 80 23
11 San Esteban CF A Esteban 26 39 67 22
12 CD Aboño CD Aboño 26 44 71 21
13 Colegio Riaño CF Colegio 26 36 66 19
14 Rayo Gijonés Rayo 26 32 91 12
TEMPORADA 2017/2018
TERCERA RFFPA GRUPO 1
Equipo PJ GF GC Puntos
1 Barcia CF Barcia CF 24 64 16 66
2 Puerto Vega FC Puerto Vega 24 61 18 53
3 UD Castros UD Castros 24 68 26 52
4 Marino de Cudillero Marino 24 45 28 43
5 Navia CF Navia CF 24 45 38 42
6 CD Aboño CD Aboño 24 63 40 38
7 Atlético Camocha Atlético 24 52 38 36
8 Asunción A Asunción A 24 43 53 33
9 FCR La Calzada Calzada 24 42 62 22
10 Rayo Gijonés Rayo 24 36 67 19
11 Codema CF Codema CF 24 33 80 15
12 CF Estudiantes Estudiantes 24 26 76 14
13 San Esteban de Pravia Esteban 24 22 58 11

  USO DE MEMORIA  
5,296,144 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0013
Controller Execution Time ( Home / Category )  0.0841
Total Execution Time  0.0854
  CADENA URL  
/historico/Cf-Estudiantes-Senior
  GET DATOS  
$_GET['/historico/Cf-Estudiantes-Senior']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (26)  
0.0029  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 = 'Cf-Estudiantes-Senior' 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=103032 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=103032 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=103032 AND type_rel = 2
0.0020  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 = '103032' 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 = '103032' AND l.year = 2024 ORDER BY l.year DESC,cat.coefficient DESC
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 = '103032' 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 = 73710 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0023  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=103032 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0018  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 (73710) 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 = 73710 AND teamId = 103032
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 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 = 73710 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 = '103032' 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 = '103032' and rp.type = 4
0.0019  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 = '103032' 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 = 73710 WHERE rp.league_id = 73710 AND rp.teamId = 103032 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 = 73710 WHERE rp.league_id = 73710 AND rp.teamId = 103032 AND (e.action = 4 or e.action = 5) 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 = 73710 WHERE rp.league_id = 73710 AND rp.teamId = 103032 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0021  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 = 103032 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 = 73710 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 = 68984 AND t.round = 26 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 `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 = 63765 AND t.round = 26 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 `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 = 59034 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 = 51304 AND t.round = 28 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 `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 = 45245 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 `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 = 39809 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC