4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del Riosa
TEMPORADA 2023/2024
TERCERA RFFPA GRUPO 3
Equipo PJ GF GC Puntos
1 Independiente CF Independient 25 76 33 61
2 UD Sariego UD Sariego 24 50 26 49
3 Lada Langreo Lada Langreo 24 76 43 48
4 Riosa Riosa 24 54 38 44
5 SCD Campomanes Campomanes 24 66 30 44
6 Club Siero B Club Siero 24 57 44 44
7 At. de Lugones B Lugones 24 52 56 36
8 Llanera B Llanera B 24 49 46 34
9 L'Entregu B L'Entregu B 24 49 48 31
10 Colegio Riaño CF Colegio 24 55 50 29
11 Atlético Siero Atlético 24 38 78 20
12 C. Europa B C. Europa B 24 41 60 20
13 Iberia CF Iberia CF 24 35 84 11
14 CD Ujo CD Ujo 25 28 90 7
TEMPORADA 2022/2023
TERCERA RFFPA GRUPO 2
Equipo PJ GF GC Puntos
1 Rosal FC Rosal FC 26 77 30 55
2 Santa Marina de Mieres Santa Marina 26 66 31 54
3 Riosa Riosa 26 75 26 52
4 CD La Manjoya Manjoya 26 58 23 52
5 La Corredoria Corredoria 26 91 34 51
6 SCD Campomanes Campomanes 25 55 31 46
7 Real Avilés B Real Avilés 26 79 40 42
8 Guillen Lafuerza Guillen 25 62 47 39
9 Oviedo City FC Oviedo City 26 63 53 33
10 CD Ujo CD Ujo 26 78 72 33
11 SD Colloto B Colloto 26 45 59 29
12 Centro Asturiano Oviedo Centro 26 40 77 19
13 Club Atletico de La Florida Club 26 30 105 13
14 Grisu CF Grisu CF 26 15 206 3
TEMPORADA 2021/2022
TERCERA RFFPA GRUPO 2
Equipo PJ GF GC Puntos
1 La Fresneda Fresneda 22 94 15 61
2 Juventud Estadio Juventud 22 79 15 53
3 Rosal FC Rosal FC 22 76 23 53
4 E.F. Real Oviedo E.F. Real O. 22 71 49 40
5 Riosa Riosa 22 60 47 37
6 At. de Lugones B Lugones 22 51 46 37
7 SD Colloto B Colloto 22 35 50 26
8 Oviedo City FC Oviedo City 22 25 42 24
9 Grisu CF Grisu CF 22 37 77 19
10 San Juan La Carisa Juan Carisa 22 38 69 16
11 Club Atletico de La Florida Club 22 18 101 11
12 Centro Asturiano Oviedo Centro 22 37 87 8
TEMPORADA 2020/2021
TERCERA RFFPA GRUPO 6
Equipo PJ GF GC Puntos
1 Riosa Riosa 10 24 14 20
2 Santa Marina de Mieres Santa Marina 10 15 10 19
3 Lenense Proinastur B Lenense 10 15 12 17
4 L'Entregu B L'Entregu B 10 17 22 11
5 Colegio Riaño CF Colegio 10 19 23 8
6 C Santiago de Aller Santiago 10 12 21 8
TEMPORADA 2019/2020
TERCERA RFFPA GRUPO 2
Equipo PJ GF GC Puntos
1 Llanera B Llanera B 22 84 33 53
2 Juventud Estadio Juventud 22 65 21 53
3 At. de Lugones B Lugones 22 66 27 50
4 La Corredoria Corredoria 22 64 27 48
5 Grujoan Grujoan 22 69 35 42
6 Santa Marina de Mieres Santa Marina 22 63 37 41
7 L'Entregu B L'Entregu B 22 54 31 41
8 Lenense Proinastur B Lenense 22 62 45 39
9 Rosal FC Rosal FC 22 59 40 38
10 C Santiago de Aller Santiago 22 54 40 30
11 Riosa Riosa 22 37 56 21
12 San Juan La Carisa Juan Carisa 22 29 74 19
13 Colegio Riaño CF Colegio 22 40 98 14
14 CD Turon B CD Turon B 22 44 77 13
15 Stiaua d'Asturies Stiaua 22 12 68 4
16 Grisu CF Grisu CF 22 20 113 4
TEMPORADA 2018/2019
TERCERA RFFPA GRUPO 3
Equipo PJ GF GC Puntos
1 Europa de Nava Europa Nava 26 60 31 59
2 Independiente CF Independient 26 75 30 54
3 Club Siero B Club Siero 26 76 33 53
4 UD Sariego UD Sariego 26 67 24 52
5 CD San Jorge Jorge 26 71 38 51
6 Santa Marina de Mieres Santa Marina 26 64 68 41
7 Condal B Condal B 26 67 56 38
8 C Santiago de Aller Santiago 26 35 47 32
9 Atlético Siero Atlético 26 43 65 30
10 Canicas AC Canicas AC 26 42 62 23
11 Llanera B Llanera B 26 54 83 21
12 CF Berron B CF Berron B 26 29 68 21
13 Riosa Riosa 26 40 88 21
14 Lenense Proinastur B Lenense 26 34 64 19
TEMPORADA 2017/2018
SEGUNDA RFFPA GRUPO 1
Equipo PJ GF GC Puntos
1 Berrón Berrón 34 85 27 82
2 Pumarín Cf Pumarín Cf 34 74 33 75
3 Sd Colloto Sd Colloto 34 62 34 72
4 Real Juvencia Real 34 37 19 61
5 Arguero Arguero 34 82 47 60
6 Gozón Gozón 34 52 43 55
7 La Guía Norte Astur Guía Norte 34 54 47 49
8 UD San Claudio B Claudio 34 62 75 47
9 Arenas del Sella Arenas Sella 34 45 51 46
10 La Fresneda Fresneda 34 63 69 45
11 Langreo Eulalia Langreo 34 47 48 43
12 Unión Astur CF Unión Astur 34 51 59 41
13 Lealtad Villaviciosa B Lealtad 34 48 62 41
14 Beredi Beredi 34 46 62 40
15 Guillen Lafuerza Guillen 34 51 66 37
16 Rosal FC Rosal FC 34 49 72 30
17 CD Ujo CD Ujo 34 53 89 25
18 Riosa Riosa 34 30 88 16
TEMPORADA 2016/2017
SEGUNDA RFFPA GRUPO 2
Equipo PJ GF GC Puntos
1 Vallobin CD Vallobin CD 22 48 26 48
2 Pumarín Cf Pumarín Cf 22 50 20 47
3 Sd Colloto Sd Colloto 22 48 25 43
4 Real Tapia CF Real Tapia 22 42 24 38
5 Guillen Lafuerza Guillen 22 41 31 38
6 CD Salas CD Salas 22 38 28 36
7 Riosa Riosa 22 35 30 34
8 Real Juvencia Real 22 29 26 33
9 UD San Claudio B Claudio 22 34 31 32
10 La Caridad La Caridad 22 30 34 32
11 Boal CF Boal CF 22 36 37 30
12 La Fresneda Fresneda 22 46 46 28
13 Beredi Beredi 22 49 46 27
14 Juventud Estadio Juventud 22 24 38 23
15 Astur Vegadense Astur 22 26 43 18
16 Narcea Narcea 22 22 41 16
17 Atletico de Siero Atletico 22 34 66 12
18 SCD Campomanes Campomanes 22 17 57 11
TEMPORADA 2015/2016
TERCERA RFFPA GRUPO 3
Equipo PJ GF GC Puntos
1 Arenas del Sella Arenas Sella 34 110 38 86
2 Riosa Riosa 34 123 30 86
3 CD Ujo CD Ujo 34 108 42 77
4 Quintueles CF Quintueles 34 97 27 77
5 Langreo Eulalia Langreo 33 94 42 71
6 Europa de Nava Europa Nava 34 99 40 68
7 CD Lealtad B Lealtad 34 86 39 65
8 Colegio Riaño CF Colegio 34 64 100 47
9 UD Siero UD Siero 34 67 60 45
10 CD San Jorge Jorge 34 48 64 43
11 Canicas AC Canicas AC 33 64 75 36
12 Urraca CF B Urraca CF B 33 52 85 36
13 Condal Club B Condal Club 31 39 60 34
14 Iberia Bimenes CF Iberia 34 50 73 32
15 UD Sariego UD Sariego 34 44 81 28
16 CF Berron B CF Berron B 34 33 87 25
17 Aller Deportivo Aller 34 36 147 10
18 UD Corbero UD Corbero 34 31 155 5
TEMPORADA 2014/2015
3ª ASTURIAS INFANTIL GRUPO 6
Equipo PJ GF GC Puntos
1 Lada Langreo Lada Langreo 14 53 11 37
2 Club Alcazar B Club Alcazar 13 59 16 33
3 Aller Deportivo Aller 13 53 16 32
4 SD Lenense Proinastur A Lenense 14 63 25 30
5 L´Entregu L´Entregu 14 60 48 27
6 Riosa Riosa 14 46 54 20
7 Lada Langreo B Lada Langreo 13 29 44 16
8 Caudal Deportivo B Caudal 12 40 33 16
9 Santa Marina de Mieres Santa Marina 14 24 51 13
10 San Esteban San Esteban 14 35 56 11
11 Alcava B Alcava B 13 25 52 8
12 Ujo Ujo 14 19 58 5
13 Colegio Riaño Colegio 14 23 65 5

  USO DE MEMORIA  
5,729,208 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0011
Controller Execution Time ( Home / Category )  0.1010
Total Execution Time  0.1022
  CADENA URL  
/historico/Cd-Riosa-Infantil
  GET DATOS  
$_GET['/historico/Cd-Riosa-Infantil']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (29)  
0.0061  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 = 'Cd-Riosa-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.0020  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=57913 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=57913 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0041  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 = 73715
0.0019  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=57913 AND type_rel = 2
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 = '57913' 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 = '57913' AND l.year = 2024 ORDER BY l.year DESC,cat.coefficient DESC
0.0020  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 = '57913' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0022  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 = 73715 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=57913 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 (73715) 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 = 73715 AND teamId = 57913
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 = '57913' 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 = '57913' 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 = '57913' 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 = 73715 WHERE rp.league_id = 73715 AND rp.teamId = 57913 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.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 = 73715 WHERE rp.league_id = 73715 AND rp.teamId = 57913 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 = 73715 WHERE rp.league_id = 73715 AND rp.teamId = 57913 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 = 57913 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
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 `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 = 73715 AND t.round = 25 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 = 68985 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.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 = 63769 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.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 `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 = 62050 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 = 51425 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.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 `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 = 45247 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 `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 = 39200 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0026  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 = 34042 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0026  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 = 16936 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0026  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 = 8500 AND t.round = 17 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC