4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del La Corredoria
TEMPORADA 2023/2024
TERCERA RFFPA GRUPO 2
Equipo PJ GF GC Puntos
1 SD Colloto B Colloto 27 86 26 66
2 La Corredoria Corredoria 27 115 27 65
3 Versalles CF Versalles 27 85 31 62
4 Guillen Lafuerza Guillen 27 96 30 60
5 Los Campos Los Campos 27 106 47 53
6 Celtic de Puerto Celtic 28 61 40 45
7 San Juan La Carisa Juan Carisa 27 63 38 41
8 San Ignacio San Ignacio 27 66 61 37
9 Oviedo City FC Oviedo City 27 62 52 36
10 Club Atletico de La Florida Club 27 49 63 33
11 Centro Asturiano Oviedo Centro 28 59 59 32
12 CD Raices CD Raices 27 51 56 25
13 Miranda C.F. Miranda C.F. 27 50 69 19
14 Salesianos Masaveu Salesianos 27 31 152 6
15 Grisu CF Grisu CF 28 14 243 3
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
SEGUNDA RFFPA GRUPO 2
Equipo PJ GF GC Puntos
1 Universidad Oviedo Universidad 24 64 27 54
2 Real Juvencia Real 24 58 28 50
3 CD Turón CD Turón 24 50 29 49
4 Pumarín CF Pumarín CF 24 50 26 45
5 Grujoan Grujoan 24 49 31 43
6 Covadonga B Covadonga B 24 40 42 36
7 CD La Manjoya Manjoya 24 41 38 33
8 Celtic de Puerto Celtic 24 36 47 33
9 La Corredoria Corredoria 24 40 57 24
10 SCD Campomanes Campomanes 24 33 57 23
11 Guillen Lafuerza Guillen 24 33 56 19
12 UD San Claudio B Claudio 24 34 65 19
13 Condal Club B Condal Club 24 38 63 16
TEMPORADA 2020/2021
SEGUNDA RFFPA GRUPO 3
Equipo PJ GF GC Puntos
1 Real Juvencia Real 8 21 12 16
2 La Corredoria Corredoria 8 14 20 11
3 UD San Claudio B Claudio 8 15 15 10
4 Pumarín CF Pumarín CF 8 14 16 10
5 Juventud Estadio Juventud 8 11 12 9
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 2
Equipo PJ GF GC Puntos
1 Covadonga B Covadonga B 28 105 27 67
2 Marino de Cudillero Marino 28 70 13 67
3 Juventud Estadio Juventud 28 60 26 58
4 Rosal FC Rosal FC 28 70 42 58
5 Grujoan Grujoan 28 81 34 56
6 Boal CF Boal CF 28 67 22 56
7 La Corredoria Corredoria 28 68 50 52
8 Racing de Pravia Racing 28 50 35 46
9 Navia CF Navia CF 28 53 61 35
10 Soto del Barco Soto Barco 28 62 69 30
11 Stiaua d'Asturies Stiaua 28 31 69 26
12 San Esteban de Pravia Esteban 28 21 103 16
13 Minas Oviedo Minas Oviedo 28 44 87 14
14 San Juan La Carisa Juan Carisa 28 32 85 11
15 Grisu CF Grisu CF 28 30 121 6
TEMPORADA 2017/2018
TERCERA RFFPA GRUPO 2
Equipo PJ GF GC Puntos
1 Celtic de Puerto Celtic 26 84 23 65
2 CD La Manjoya Manjoya 26 85 22 58
3 Juventud Estadio Juventud 26 62 25 57
4 Grujoan Grujoan 25 91 24 51
5 La Corredoria Corredoria 26 55 34 49
6 CD Pillarno CD Pillarno 25 61 35 48
7 Minas Oviedo Minas Oviedo 26 68 52 41
8 Rayo Villalegre Rayo 25 43 51 32
9 Grisu CF Grisu CF 25 46 59 30
10 Versalles CF Versalles 26 39 67 25
11 Colegio Riaño CF Colegio 26 39 97 21
12 San Juan La Carisa Juan Carisa 26 31 59 20
13 Salesianos Masaveu Salesianos 26 23 89 10
14 Stiaua d'Asturies Stiaua 26 23 113 7
TEMPORADA 2016/2017
TERCERA RFFPA GRUPO 2
Equipo PJ GF GC Puntos
1 Langreo Eulalia Langreo 15 47 13 39
2 Rosal FC Rosal FC 15 43 21 36
3 La Corredoria Corredoria 15 45 18 32
4 San Juan La Carisa Juan Carisa 14 36 18 32
5 CD Ujo CD Ujo 15 32 18 31
6 Celtic de Puerto Celtic 15 36 16 30
7 C Santiago de Aller Santiago 14 24 25 19
8 Minas Oviedo Minas Oviedo 15 27 20 18
9 CD La Manjoya Manjoya 15 26 26 17
10 Colegio Riaño CF Colegio 15 21 36 16
11 Rayo Las Caldas Rayo Caldas 15 20 36 14
12 Grisu CF Grisu CF 15 21 48 13
13 Grujoan Grujoan 15 24 47 9
14 CD Tineo B CD Tineo B 15 16 41 7
15 Stiaua d'Asturies Stiaua 14 16 51 6
TEMPORADA 2015/2016
TERCERA RFFPA GRUPO 2
Equipo PJ GF GC Puntos
1 Avilés Stadium Avilés 32 118 9 84
2 UD San Claudio B Claudio 32 89 25 73
3 GD Bosco GD Bosco 32 90 26 73
4 Rosal FC Rosal FC 32 114 43 71
5 La Corredoria Corredoria 32 81 23 68
6 Minas Oviedo Minas Oviedo 32 89 42 63
7 Celtic de Puerto Celtic 32 75 36 59
8 San Juan La Carisa Juan Carisa 32 65 44 51
9 Oviedo 06 Oviedo 06 32 80 58 51
10 Pumarin B Pumarin B 32 49 70 32
11 Rayo Villalegre Rayo 32 47 103 30
12 Stiaua d'Asturies Stiaua 32 36 90 26
13 Versalles CF Versalles 32 24 89 25
14 Rayo Las Caldas Rayo Caldas 32 33 118 17
15 CD La Manjoya Manjoya 32 27 91 12
16 Centro Asturiano Centro 32 39 137 11
TEMPORADA 2014/2015
TERCERA RFFPA GRUPO 2
Equipo PJ GF GC Puntos
1 CD Salas CD Salas 29 119 22 74
2 La Corredoria Corredoria 29 79 22 64
3 Guillén Lafuerza Guillén 29 86 32 64
4 Rosal FC Rosal FC 29 85 36 64
5 CD Ujo CD Ujo 30 74 47 55
6 Minas Oviedo Minas Oviedo 30 68 52 51
7 Pumarin B Pumarin B 29 84 45 50
8 UD San Claudio B Claudio 29 56 42 49
9 CD Tineo B CD Tineo B 29 56 54 49
10 Stiaua d'Asturies Stiaua 29 39 62 31
11 Oviedo 06 Oviedo 06 29 42 68 31
12 Cubia FC Cubia FC 29 47 75 26
13 CD La Manjoya Manjoya 29 37 56 22
14 San Juan La Carisa Juan Carisa 29 42 111 18
15 Grisu CF Grisu CF 29 32 117 13
16 Centro Asturiano Centro 29 23 128 7

  USO DE MEMORIA  
5,757,344 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0012
Controller Execution Time ( Home / Category )  0.1460
Total Execution Time  0.1472
  CADENA URL  
/historico/La-Corredoria
  GET DATOS  
$_GET['/historico/La-Corredoria']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (33)  
0.0064  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 = 'La-Corredoria' 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.0022  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=20077 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0022  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=20077 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0062  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 = 73713
0.0021  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=20077 AND type_rel = 2
0.0023  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=710 AND type_rel = 3
0.0028  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 3 AND rel.typeId = 710 AND rel.ln = 'es' AND rel.status=1 ORDER BY rel.creation_date desc,rel.cover_points DESC LIMIT 5
0.0030  SELECT /*53 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 (510396,510516) ORDER BY n.cover_points DESC, update_date DESC
0.0038  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 = '20077' ORDER BY l.year DESC,cat.coefficient DESC
0.0044  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 = '20077' AND l.year = 2024 ORDER BY l.year DESC,cat.coefficient DESC
0.0039  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 = '20077' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0031  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 = 73713 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0072  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=20077 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0023  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 (73713) 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.0022  SELECT count(id) as num_players from rel_players WHERE league_id = 73713 AND teamId = 20077
0.0036  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 = 73713 AND t.round = 30 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0037  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 = '20077' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0024  SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '20077' and rp.type = 4
0.0032  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 = '20077' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0030  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 = 73713 WHERE rp.league_id = 73713 AND rp.teamId = 20077 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.0028  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 = 73713 WHERE rp.league_id = 73713 AND rp.teamId = 20077 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0036  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 = 73713 WHERE rp.league_id = 73713 AND rp.teamId = 20077 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0032  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 = 20077 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.0043  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 = 73713 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.0028  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.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 `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 = 63766 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.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 = 59036 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.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 `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.0028  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 = 45246 AND t.round = 30 ORDER BY team.conference 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 `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 = 39810 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0032  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 = 34362 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0027  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 = 16935 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0027  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` 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 = 4317 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC