4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del Vallobin CD
TEMPORADA 2023/2024
PRIMERA RFFPA
Equipo PJ GF GC Puntos
1 Real Sporting C Real 31 54 14 69
2 EI San Martín Martín 31 45 14 68
3 Mosconia Mosconia 31 57 25 60
4 Astur Astur 31 46 22 58
5 TSK Roces TSK Roces 32 54 43 54
6 Club Siero Club Siero 31 49 34 49
7 Vallobin CD Vallobin CD 31 44 33 49
8 Navarro Navarro 31 35 34 43
9 U.Comercial U.Comercial 32 46 46 41
10 Muros Balompié Muros 31 36 39 41
11 Universidad Oviedo Universidad 31 37 41 39
12 Llaranes CF Llaranes CF 31 32 36 37
13 Andés Andés 31 30 42 37
14 Candás CF Candás CF 31 36 48 35
15 La Fresneda Fresneda 32 24 42 35
16 Valdesoto Valdesoto 32 28 39 34
17 Berrón Berrón 31 24 42 28
18 Club Asturias de Blimea Club 31 30 60 27
19 Atlético de Lugones Atlético 31 38 59 26
20 Colloto Colloto 31 22 54 18
TEMPORADA 2022/2023
PRIMERA RFFPA
Equipo PJ GF GC Puntos
1 Urraca CF Urraca CF 38 61 25 74
2 UD Gijón Industrial Gijón 38 58 27 73
3 SD Lenense Proinastur Lenense 38 53 30 70
4 Barcia CF Barcia CF 38 46 33 62
5 Atlético de Lugones Atlético 38 51 30 62
6 TSK Roces TSK Roces 38 36 28 62
7 Llaranes CF Llaranes CF 38 48 43 61
8 Astur Astur 38 38 35 54
9 Candás CF Candás CF 38 48 49 53
10 Navarro Navarro 38 44 47 52
11 Berrón Berrón 38 43 43 51
12 Andés Andés 38 47 42 48
13 EI San Martín Martín 38 37 40 45
14 Mosconia Mosconia 38 30 36 44
15 Colloto Colloto 38 38 51 44
16 Vallobin CD Vallobin CD 38 41 45 44
17 Universidad Oviedo Universidad 38 45 57 41
18 Tineo Tineo 38 31 48 36
19 UP Langreo B Langreo 38 41 88 30
20 Lealtad Villaviciosa B Lealtad 38 15 54 21
TEMPORADA 2021/2022
PRIMERA RFFPA GRUPO 2
Equipo PJ GF GC Puntos
1 Valdesoto Valdesoto 22 27 11 47
2 Condal Condal 22 31 20 43
3 Berrón Berrón 22 34 21 39
4 Astur Astur 22 31 21 38
5 Vallobin CD Vallobin CD 22 32 21 36
6 Colloto Colloto 22 27 24 33
7 Unión Comercial Unión 22 40 26 33
8 Nalón CF Nalón CF 22 27 32 28
9 Madalena Madalena 22 41 48 23
10 Club Siero Club Siero 22 27 41 20
11 Europa de Nava Europa Nava 22 21 43 16
12 Ribadedeva Ribadedeva 22 15 45 10
TEMPORADA 2020/2021
TERCERA DIVISIÓN GRUPO 2
Equipo PJ GF GC Puntos
1 UC Ceares UC Ceares 20 29 16 44
2 Real Avilés Industrial Real Avilés 20 33 13 40
3 UD Llanera UD Llanera 20 38 28 38
4 Caudal Deportivo Caudal 20 36 18 38
5 UD Gijón Industrial Gijón 20 34 27 27
6 SD Lenense Proinastur Lenense 20 24 27 25
7 CD Praviano CD Praviano 20 23 28 24
8 Navarro Navarro 20 18 26 22
9 Mosconia Mosconia 20 15 28 20
10 Vallobin CD Vallobin CD 20 14 32 17
11 Avilés Stadium Avilés 20 12 33 12
12 L´Entregu CF L´Entregu 18 32 13 40
13 EI San Martín Martín 18 31 21 33
14 Llanes Llanes 18 29 16 32
15 CD Tuilla CD Tuilla 18 25 19 27
16 Real Titánico Real 18 19 25 23
17 Urraca CF Urraca CF 18 9 12 22
18 Condal Condal 18 13 19 22
19 CD Colunga CD Colunga 18 11 17 20
20 Club Siero Club Siero 18 12 23 15
21 Valdesoto Valdesoto 18 10 26 12
TEMPORADA 2019/2020
TERCERA DIVISIÓN GRUPO 2
Equipo PJ GF GC Puntos
1 Lealtad Villaviciosa Lealtad 28 44 12 62
2 UD Llanera UD Llanera 28 48 26 59
3 CD Covadonga Covadonga 28 65 33 57
4 Caudal Deportivo Caudal 28 54 21 56
5 CD Tuilla CD Tuilla 28 42 25 55
6 Llanes Llanes 28 47 30 48
7 Urraca CF Urraca CF 28 34 25 43
8 UD Gijón Industrial Gijón 28 42 36 39
9 L´Entregu CF L´Entregu 28 26 36 34
10 Condal Condal 28 29 37 32
11 CD Praviano CD Praviano 28 37 42 32
12 Mosconia Mosconia 28 29 33 31
13 Navarro Navarro 28 26 35 31
14 SD Lenense Proinastur Lenense 28 28 48 29
15 UC Ceares UC Ceares 28 28 37 27
16 Real Avilés Industrial Real Avilés 28 34 50 25
17 Vallobin CD Vallobin CD 28 19 32 25
18 EI San Martín Martín 28 26 49 24
19 CD Colunga CD Colunga 28 25 53 23
20 Club Siero Club Siero 28 25 48 20
TEMPORADA 2018/2019
PRIMERA RFFPA
Equipo PJ GF GC Puntos
1 Urraca CF Urraca CF 38 58 28 74
2 Vallobin CD Vallobin CD 38 59 33 74
3 Navarro Navarro 38 61 27 73
4 SD Lenense Proinastur Lenense 38 65 36 72
5 Avilés Stadium Avilés 38 52 27 71
6 Real Titánico Real 38 43 28 67
7 Tineo Tineo 38 63 59 56
8 TSK Roces TSK Roces 38 58 46 54
9 Club Asturias de Blimea Club 38 59 61 52
10 Atlético de Lugones Atlético 38 41 43 48
11 Astur Astur 38 45 49 47
12 Candás CF Candás CF 38 47 53 44
13 Colloto Colloto 38 47 59 43
14 Valdesoto Valdesoto 38 47 65 43
15 Berrón Berrón 38 37 59 42
16 CD Turón CD Turón 38 45 65 41
17 Nalón CF Nalón CF 38 46 67 41
18 Andés Andés 38 43 57 39
19 Ribadesella Ribadesella 38 39 62 32
20 Ribadedeva Ribadedeva 38 33 64 31
TEMPORADA 2017/2018
PRIMERA RFFPA
Equipo PJ GF GC Puntos
1 UD San Claudio Claudio 38 70 37 78
2 Madalena Madalena 38 71 38 74
3 Universidad Oviedo Universidad 38 69 32 71
4 Ribadesella Ribadesella 38 67 56 66
5 Vallobin CD Vallobin CD 38 43 27 62
6 SD Lenense Proinastur Lenense 38 51 42 59
7 Astur Astur 38 46 39 57
8 Club Asturias de Blimea Club 37 51 56 50
9 Nalón CF Nalón CF 37 45 51 50
10 Urraca CF Urraca CF 38 36 40 49
11 Andés Andés 38 41 46 48
12 Tineo Tineo 38 42 44 48
13 Navarro Navarro 38 52 51 46
14 Candás CF Candás CF 38 37 41 46
15 Real Titánico Real 37 44 50 46
16 Ribadedeva Ribadedeva 37 48 63 43
17 CD Turón CD Turón 38 43 69 42
18 Unión Comercial Unión 38 48 60 40
19 CD Rayo Carbayín Rayo 38 50 66 38
20 CD Manuel Rubio Manuel Rubio 38 40 86 25
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 2014/2015
SEGUNDA RFFPA GRUPO 2
Equipo PJ GF GC Puntos
1 Nalón CF Nalón CF 34 96 21 81
2 Pumarín CF Pumarín CF 34 80 44 72
3 Vallobin CD Vallobin CD 34 90 41 71
4 Deportiva Piloñesa Deportiva 34 75 45 70
5 Real Juvencia Real 34 77 48 64
6 Ribadesella Ribadesella 34 64 39 63
7 Asturias de Blimea Asturias 34 61 42 61
8 Villaviciosa EIF Villaviciosa 34 69 55 57
9 Real Titánico Real 34 62 46 53
10 Beredi FS Beredi FS 34 64 64 51
11 Arguero CF Arguero CF 34 63 53 47
12 Caudal Deportivo B Caudal 34 53 63 40
13 Juventud Estadio Juventud 34 43 48 33
14 Grujoan CD Grujoan CD 34 43 71 29
15 Santiago De Aller Santiago 34 32 88 27
16 Iberia Bimenes CF Iberia 34 36 84 22
17 Celtic de Puerto Celtic 34 36 78 18
18 Riosa CD Riosa CD 34 26 140 10

  USO DE MEMORIA  
6,183,768 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0012
Controller Execution Time ( Home / Category )  0.5266
Total Execution Time  0.5278
  CADENA URL  
/historico/Vallobin-Cd
  GET DATOS  
$_GET['/historico/Vallobin-Cd']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (27)  
0.0158  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 = 'Vallobin-Cd' 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.0146  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=20074 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0144  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=20074 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0144  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=20074 AND type_rel = 2
0.0144  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=72 AND type_rel = 3
0.0145  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 3 AND rel.typeId = 72 AND rel.ln = 'es' AND rel.status=1 ORDER BY rel.creation_date desc,rel.cover_points DESC LIMIT 5
0.0146  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 (865740,698945,420684,366243,365678) ORDER BY n.cover_points DESC, update_date DESC
0.0148  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 = '20074' ORDER BY l.year DESC,cat.coefficient DESC
0.0151  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 = '20074' AND l.year = 2024 ORDER BY l.year DESC,cat.coefficient DESC
0.0149  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 = '20074' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0147  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=20074 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0145  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 (73524) 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.0147  SELECT count(id) as num_players from rel_players WHERE league_id = 73524 AND teamId = 20074
0.0146  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 = '20074' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0144  SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '20074' and rp.type = 4
0.0147  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 = '20074' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0155  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 = 73524 WHERE rp.league_id = 73524 AND rp.teamId = 20074 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.0155  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 = 73524 WHERE rp.league_id = 73524 AND rp.teamId = 20074 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0153  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 = 73524 WHERE rp.league_id = 73524 AND rp.teamId = 20074 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0147  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 = 20074 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.0294  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 = 73524 AND t.round = 32 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0150  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 = 68760 AND t.round = 38 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0148  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 = 63714 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.0149  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 = 50270 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.0153  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 = 44673 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0151  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.0151  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 = 4311 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC