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 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  
5,528,280 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0012
Controller Execution Time ( Home / Category )  0.5724
Total Execution Time  0.5736
  CADENA URL  
/historico/Vallobin-Cd/2020
  GET DATOS  
$_GET['/historico/Vallobin-Cd/2020']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (30)  
0.0155  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 = 2020 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.0145  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.0145  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.0291  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 = 50270
0.0145  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=20074 AND type_rel = 2
0.0145  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=4 AND type_rel = 3
0.0188  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 3 AND rel.typeId = 4 AND rel.ln = 'es' AND rel.status=1 ORDER BY rel.creation_date desc,rel.cover_points DESC LIMIT 5
0.0148  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 (1173626,928772,1016417,1012236,810592) ORDER BY n.cover_points DESC, update_date DESC
0.0149  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.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' AND l.year = 2020 ORDER BY l.year DESC,cat.coefficient DESC
0.0147  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.0146  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 = 50270 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0148  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 (2019,2020,2021) ORDER BY l.id DESC, l.year DESC ;
0.0146  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 (61805,58580,44673) 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 = 58580 AND teamId = 20074
0.0146  SELECT count(id) as num_players from rel_players WHERE league_id = 44673 AND teamId = 20074
0.0146  SELECT count(id) as num_players from rel_players WHERE league_id = 61805 AND teamId = 20074
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 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 t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0147  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.0145  SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '20074' and rp.type = 4
0.0146  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 events2020 e ON e.player_id = p.id AND e.league_id = 50270 WHERE rp.league_id = 50270 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 events2020 e ON e.player_id = p.id AND e.league_id = 50270 WHERE rp.league_id = 50270 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 events2020 e ON e.player_id = p.id AND e.league_id = 50270 WHERE rp.league_id = 50270 AND rp.teamId = 20074 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0148  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 <= 2020 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
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 `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.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 `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 `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.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 `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.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 `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