4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del Juv. Estadio
TEMPORADA 2023/2024
1ª ASTURIAS INFANTIL
Equipo PJ GF GC Puntos
1 Real Sporting Real 7 34 7 21
2 Real Oviedo Real Oviedo 7 28 5 21
3 Juv. Estadio Juv. Estadio 7 23 7 16
4 Llano 2000 Llano 2000 7 17 10 16
5 Quirinal Quirinal 7 21 15 16
6 TSK Roces TSK Roces 7 15 11 12
7 Vallobin Vallobin 7 14 16 12
8 Real Sporting B Real 7 23 15 10
9 Covadonga Covadonga 7 10 13 9
10 Los Campos Los Campos 7 16 18 7
11 CD Arenal CD Arenal 7 14 23 4
12 Covadonga Roces Covadonga 7 8 21 4
13 Club Alcazar Club Alcazar 7 4 20 4
14 Escuela de Futbol Jin B Escuela 7 7 24 4
15 Astur CF Astur CF 7 11 18 3
16 Veriña C Veriña C 7 4 26 1
TEMPORADA 2022/2023
1ª ASTURIAS INFANTIL
Equipo PJ GF GC Puntos
1 Real Oviedo Real Oviedo 30 114 16 86
2 Real Sporting Real 30 121 39 70
3 TSK Roces TSK Roces 30 86 46 64
4 Covadonga Covadonga 30 108 63 63
5 Llano 2000 Llano 2000 30 103 59 59
6 Vallobin Vallobin 30 62 57 53
7 Astur CF Astur CF 30 60 36 48
8 Real Sporting B Real 30 83 81 40
9 CD Arenal CD Arenal 30 61 60 40
10 Covadonga Roces Covadonga 30 48 57 40
11 Quirinal Quirinal 30 56 81 38
12 Juv. Estadio Juv. Estadio 30 50 78 30
13 Real Avilés Industrial CF S Real Avilés 30 52 98 24
14 UD Gijon Industrial A Gijon 30 40 88 22
15 CD Llanes A CD Llanes A 30 37 138 10
16 CD Montevil A Montevil 30 20 104 8
TEMPORADA 2019/2020
2ª MADRID INFANTIL GRUPO 31
Equipo PJ GF GC Puntos
1 Adepo Palomeras Adepo 20 107 22 53
2 Cfd Elida Olimpia A Elida 20 118 12 52
3 AD Madrid Sur Madrid 20 62 23 47
4 CD Vallecas CD Vallecas 20 113 33 44
5 Mar Abierto Mar Abierto 20 91 35 39
6 Sporting Valdebernardo A Sporting 20 50 22 38
7 Seccion Deportiva del Pozo Seccion 20 51 23 36
8 CD Union Valdebernardo Union 20 54 46 35
9 Santa Eugenia 1976 Santa 20 37 32 24
10 Gredos San Diego - Vallecas Gredos Diego 20 49 76 22
11 Club Fundacion Rayo Valleca Club 20 34 67 19
12 Villa de Madrid Villa Madrid 20 34 68 16
13 Vallecas A Vallecas A 20 40 105 15
14 La Gavia CF La Gavia CF 20 29 105 12
15 Vallecas A Vallecas A 20 17 95 3
16 Juv. Estadio Juv. Estadio 20 12 134 1
TEMPORADA 2018/2019
1ª ASTURIAS INFANTIL
Equipo PJ GF GC Puntos
1 Real Oviedo Real Oviedo 30 116 25 75
2 Sporting Sporting 30 101 20 74
3 TSK Roces TSK Roces 30 118 34 71
4 Covadonga Roces Covadonga 30 88 38 64
5 Sporting B Sporting B 30 70 36 61
6 Los Campos Los Campos 30 70 56 55
7 Astur Astur 30 59 38 51
8 Covadonga Covadonga 30 66 62 45
9 Juv. Estadio Juv. Estadio 30 57 55 41
10 Llano 2000 Llano 2000 30 71 71 38
11 Club Alcazar Club Alcazar 30 46 72 36
12 CD Manuel Rubio A Manuel Rubio 30 49 69 32
13 Urraca Urraca 30 63 104 26
14 Caudal Deportivo A Caudal 30 27 100 9
15 CD Lealtad de Villaviciosa Lealtad 30 23 129 6
16 Narcea Narcea 30 21 136 5
TEMPORADA 2017/2018
1ª ASTURIAS INFANTIL
Equipo PJ GF GC Puntos
1 Sporting Sporting 30 176 17 87
2 Real Oviedo Real Oviedo 30 158 16 79
3 Covadonga Roces Covadonga 30 78 50 57
4 Llano 2000 Llano 2000 30 90 43 56
5 TSK Roces TSK Roces 30 55 46 52
6 Juv. Estadio Juv. Estadio 30 67 47 51
7 Covadonga Covadonga 30 52 47 47
8 Sporting B Sporting B 30 50 64 41
9 Caudal Deportivo A Caudal 30 35 69 35
10 Club Alcazar Club Alcazar 30 34 68 35
11 Astur Astur 30 60 80 34
12 CD Manuel Rubio A Manuel Rubio 30 43 50 32
13 Real Avilés Industrial CF S Real Avilés 30 41 85 30
14 CD Grujoan A Grujoan 30 39 84 23
15 CD Quirinal B Quirinal 30 37 86 21
16 CD Mosconia A Mosconia 30 17 180 3
TEMPORADA 2016/2017
1ª ASTURIAS INFANTIL
Equipo PJ GF GC Puntos
1 Astur Astur 0 0 0 0
2 Caudal Deportivo A Caudal 0 0 0 0
3 CD Arenal CD Arenal 0 0 0 0
4 CD Grujoan A Grujoan 0 0 0 0
5 CD Manuel Rubio A Manuel Rubio 0 0 0 0
6 CD Quirinal B Quirinal 0 0 0 0
7 Club Alcazar Club Alcazar 0 0 0 0
8 Codema B Codema B 0 0 0 0
9 Colegio de la Inmaculada A Colegio 0 0 0 0
10 Covadonga Covadonga 0 0 0 0
11 Juv. Estadio Juv. Estadio 0 0 0 0
12 La Corredoria Corredoria 0 0 0 0
13 Real Oviedo Real Oviedo 0 0 0 0
14 Sporting Sporting 0 0 0 0
15 Sporting B Sporting B 0 0 0 0
16 TSK Roces TSK Roces 0 0 0 0
TEMPORADA 2015/2016
1ª ASTURIAS INFANTIL
Equipo PJ GF GC Puntos
1 Sporting Sporting 30 133 11 87
2 Real Oviedo Real Oviedo 30 132 18 87
3 TSK Roces TSK Roces 30 86 37 69
4 Covadonga Covadonga 30 88 49 58
5 Club Alcazar Club Alcazar 30 70 65 52
6 CD Quirinal B Quirinal 30 62 55 50
7 Sporting B Sporting B 30 49 56 46
8 CD Arenal CD Arenal 30 62 61 42
9 Codema B Codema B 30 44 61 38
10 Astur Astur 30 45 52 35
11 CD Manuel Rubio A Manuel Rubio 30 39 75 32
12 Juv. Estadio Juv. Estadio 30 52 78 29
13 Real Avilés Industrial CF S Real Avilés 30 30 69 24
14 Aviles Deportivo Aviles 30 35 81 20
15 Llano 2000 Llano 2000 30 39 102 20
16 ACD Alcava A Alcava 30 35 131 7
TEMPORADA 2014/2015
1ª ASTURIAS INFANTIL
Equipo PJ GF GC Puntos
1 Sporting Sporting 19 90 4 57
2 Real Oviedo Real Oviedo 19 74 18 51
3 Astur Astur 19 57 24 40
4 Medicentro Arenal Medicentro 19 40 34 37
5 CD Quirinal B Quirinal 19 36 36 31
6 TSK Roces TSK Roces 19 48 40 29
7 Juv. Estadio Juv. Estadio 19 37 36 28
8 Llano 2000 Llano 2000 19 35 37 27
9 UD Llanera A Llanera 19 40 47 26
10 Covadonga Covadonga 19 40 44 26
11 Sporting B Sporting B 19 34 38 24
12 CD Manuel Rubio A Manuel Rubio 19 26 43 23
13 Real Avilés Industrial CF S Real Avilés 19 35 47 20
14 Covadonga Roces Covadonga 19 17 49 11
15 Condal CF A Condal CF A 19 24 80 9
16 Lealtad Lealtad 19 18 74 4

  USO DE MEMORIA  
5,481,104 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0011
Controller Execution Time ( Home / Category )  0.4525
Total Execution Time  0.4536
  CADENA URL  
/historico/Juventud-Estadio-Cf-Infantil
  GET DATOS  
$_GET['/historico/Juventud-Estadio-Cf-Infantil']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (27)  
0.0134  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 = 'Juventud-Estadio-Cf-Infantil' 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.0125  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=57779 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0125  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=57779 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0255  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 = 74583
0.0125  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=57779 AND type_rel = 2
0.0125  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=1435 AND type_rel = 3
0.0128  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 = '57779' ORDER BY l.year DESC,cat.coefficient DESC
0.0127  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 = '57779' AND l.year = 2024 ORDER BY l.year DESC,cat.coefficient DESC
0.0126  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 = '57779' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0126  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 = 74583 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0127  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=57779 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0125  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 (74583) 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.0125  SELECT count(id) as num_players from rel_players_base WHERE league_id = 74583 AND teamId = 57779
0.0126  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 = 74583 AND t.round = 27 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 = '57779' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0125  SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '57779' and rp.type = 4
0.0127  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 = '57779' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
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 = 57779 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
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 `tables2024_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 = 74583 AND t.round = 27 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 `tables2023_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 = 68993 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.0131  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_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 = 52381 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.0132  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_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 = 46199 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0133  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_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 = 40904 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0131  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_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 = 34389 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0132  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_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 = 18122 AND t.round = 30 ORDER BY team.conference 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 `tables2015_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 = 8492 AND t.round = 19 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0127  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 = 74583 ORDER BY nameShow LIMIT 100