4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del Club Asturias de Blimea
TEMPORADA 2023/2024
PRIMERA RFFPA
Equipo PJ GF GC Puntos
1 Real Sporting C Real 32 57 15 72
2 EI San Martín Martín 32 46 16 68
3 Mosconia Mosconia 33 62 26 66
4 Astur Astur 32 46 23 58
5 TSK Roces TSK Roces 32 54 43 54
6 Club Siero Club Siero 32 53 35 52
7 Vallobin CD Vallobin CD 33 45 36 50
8 Navarro Navarro 33 38 37 46
9 Llaranes CF Llaranes CF 33 37 36 43
10 Andés Andés 33 33 42 43
11 U.Comercial U.Comercial 33 46 48 41
12 Muros Balompié Muros 32 36 41 41
13 Universidad Oviedo Universidad 32 37 42 39
14 La Fresneda Fresneda 33 27 44 38
15 Candás CF Candás CF 33 38 52 36
16 Valdesoto Valdesoto 32 28 39 34
17 Atlético de Lugones Atlético 32 40 60 29
18 Berrón Berrón 32 25 45 28
19 Club Asturias de Blimea Club 32 31 64 27
20 Colloto Colloto 32 22 57 18
TEMPORADA 2022/2023
SEGUNDA RFFPA GRUPO 2
Equipo PJ GF GC Puntos
1 Club Siero Club Siero 34 69 28 77
2 Club Asturias de Blimea Club 34 69 23 71
3 Unión Comercial Unión 34 76 45 68
4 Nalón CF Nalón CF 34 66 39 67
5 UD San Claudio Claudio 34 63 36 66
6 CD Turón CD Turón 34 68 42 60
7 Grujoan Grujoan 34 53 51 58
8 Real Juvencia Real 34 55 45 52
9 Pumarín CF Pumarín CF 34 53 52 52
10 Madalena Madalena 34 69 64 51
11 Ribadesella Ribadesella 34 56 61 44
12 Ribadedeva Ribadedeva 34 46 66 42
13 Europa de Nava Europa Nava 34 51 57 40
14 Juventud Estadio Juventud 34 45 62 29
15 Urraca CF B Urraca CF B 34 35 58 23
16 Canicas AC Canicas AC 34 37 87 21
17 Atlético Siero Atlético 34 42 93 21
18 Celtic de Puerto Celtic 34 35 79 19
TEMPORADA 2021/2022
PRIMERA RFFPA GRUPO 1
Equipo PJ GF GC Puntos
1 Avilés Stadium Avilés 22 35 16 47
2 Atlético de Lugones Atlético 22 29 12 44
3 Barcia CF Barcia CF 22 34 23 38
4 Tineo Tineo 22 25 15 37
5 Andés Andés 22 26 14 37
6 Candás CF Candás CF 22 28 18 36
7 UD San Claudio Claudio 22 27 27 33
8 Real Tapia CF Real Tapia 22 24 34 27
9 Club Asturias de Blimea Club 22 31 35 24
10 Podes CF Podes CF 22 33 39 21
11 Gozón Gozón 22 24 44 14
12 La Guía Norte Astur Guía Norte 22 23 62 7
TEMPORADA 2020/2021
PRIMERA RFFPA GRUPO 2
Equipo PJ GF GC Puntos
1 UP Langreo B Langreo 10 15 7 19
2 Candás CF Candás CF 10 11 5 16
3 Atlético de Lugones Atlético 10 12 10 15
4 Club Asturias de Blimea Club 10 7 9 12
5 UD San Claudio Claudio 10 9 13 11
6 Universidad Oviedo Universidad 10 3 13 5
TEMPORADA 2019/2020
PRIMERA RFFPA
Equipo PJ GF GC Puntos
1 Real Titánico Real 28 55 20 69
2 Avilés Stadium Avilés 28 28 12 53
3 Valdesoto Valdesoto 28 39 24 51
4 TSK Roces TSK Roces 28 50 26 50
5 UD San Claudio Claudio 28 44 28 49
6 Podes CF Podes CF 28 41 34 49
7 Astur Astur 28 34 21 44
8 Atlético de Lugones Atlético 28 40 31 41
9 Candás CF Candás CF 28 30 32 36
10 Club Asturias de Blimea Club 28 43 35 34
11 Unión Comercial Unión 28 35 37 34
12 Berrón Berrón 28 28 45 34
13 Colloto Colloto 28 33 41 33
14 Universidad Oviedo Universidad 28 34 34 32
15 La Guía Norte Astur Guía Norte 28 34 41 30
16 Llaranes CF Llaranes CF 28 33 48 29
17 Tineo Tineo 28 22 36 26
18 Nalón CF Nalón CF 28 28 48 26
19 CD Turón CD Turón 28 30 53 26
20 Madalena Madalena 28 28 63 18
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 1
Equipo PJ GF GC Puntos
1 Real Titánico Real 32 63 25 67
2 CD Manuel Rubio Manuel Rubio 31 68 35 60
3 Llaranes CF Llaranes CF 32 53 20 60
4 Club Asturias de Blimea Club 32 56 32 60
5 Avilés Stadium Avilés 31 57 34 56
6 Real Avilés Cf B Real Avilés 33 51 38 52
7 Podes CF Podes CF 33 68 58 50
8 Club Hispano Club Hispano 32 56 39 48
9 La Guía Norte Astur Guía Norte 33 50 49 46
10 C.D. Valsa C.D. Valsa 32 44 39 44
11 Arguero Arguero 32 44 52 36
12 Arenesco Arenesco 33 47 83 36
13 Arenas del Sella Arenas Sella 32 35 65 35
14 GD Bosco GD Bosco 32 40 51 34
15 Gozón Gozón 33 36 51 33
16 Atlético Camocha Atlético 32 40 59 27
17 Llanes B Llanes B 33 27 90 14
18 Glamour Team Glamour Team 14 18 33 13
TEMPORADA 2015/2016
SEGUNDA RFFPA GRUPO 2
Equipo PJ GF GC Puntos
1 Ribadesella Ribadesella 34 76 19 82
2 Ribadedeva Ribadedeva 34 74 32 71
3 Pumarín Cf Pumarín Cf 34 66 40 64
4 Vallobín Vallobín 34 72 31 64
5 Real Titánico Real 34 66 38 58
6 Real Juvencia Real 34 58 41 57
7 Club Asturias de Blimea Club 34 59 42 55
8 Sd Colloto Sd Colloto 34 55 51 54
9 Arguero Arguero 34 65 63 53
10 Guillen Lafuerza Guillen 34 67 70 51
11 Juventud Estadio Juventud 34 40 48 39
12 Ei Futbol Villaviciosa Futbol 34 61 72 36
13 Atletico de Siero Atletico 34 41 68 36
14 Llanes B Llanes B 34 39 58 33
15 Beredi Beredi 34 43 85 30
16 Deportiva Piloñesa Deportiva 34 45 66 28
17 Grujoan Grujoan 34 34 80 22
18 C Santiago de Aller Santiago 34 32 89 14

  USO DE MEMORIA  
6,041,568 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0012
Controller Execution Time ( Home / Category )  0.1239
Total Execution Time  0.1251
  CADENA URL  
/historico/C-Asturias-De-Blimea-Senior
  GET DATOS  
$_GET['/historico/C-Asturias-De-Blimea-Senior']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (30)  
0.0028  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 = 'C-Asturias-De-Blimea-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=81139 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=81139 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=81139 AND type_rel = 2
0.0025  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 = '81139' ORDER BY l.year DESC,cat.coefficient DESC
0.0024  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 = '81139' AND l.year = 2024 ORDER BY l.year DESC,cat.coefficient DESC
0.0022  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 = '81139' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0021  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 = 73524 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0028  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=81139 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0019  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,68983) 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.0029  SELECT count(id) as num_players from rel_players WHERE league_id = 73524 AND teamId = 81139
0.0021  SELECT count(id) as num_players from rel_players WHERE league_id = 68983 AND teamId = 81139
0.0046  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 = 73524 AND t.round = 33 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0025  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 = '81139' 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 = '81139' 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 = '81139' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0049  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 = 81139 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.0050  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 = 81139 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0040  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 = 81139 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0025  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 = 81139 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.0029  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 = 33 ORDER BY team.conference ASC,t.position 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 `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 = 68983 AND t.round = 34 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 `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 = 63715 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 = 61955 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.0042  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 = 51182 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.0038  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.0033  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 = 39192 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0039  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 = 34043 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0037  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 = 16777 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0021  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 = 73524 ORDER BY nameShow LIMIT 100