4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del Urraca CF B
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
SEGUNDA RFFPA GRUPO 1
Equipo PJ GF GC Puntos
1 Lealtad de Villaviciosa B Lealtad 24 49 24 51
2 Ribadesella Ribadesella 24 64 22 48
3 Quintueles CF Quintueles 24 48 29 45
4 Canicas AC Canicas AC 24 64 31 42
5 CD Manuel Rubio Manuel Rubio 24 65 34 42
6 Atlético Camocha Atlético 24 56 31 42
7 Urraca CF B Urraca CF B 24 38 30 37
8 Triple A Gijón Triple 24 50 36 33
9 UD Sariego UD Sariego 24 38 53 29
10 Deportiva Piloñesa Deportiva 24 27 39 23
11 CF Estudiantes Estudiantes 24 32 71 21
12 Independiente CF Independient 24 22 59 13
13 CD Deva CD Deva 24 25 119 6
TEMPORADA 2020/2021
TERCERA RFFPA GRUPO 7
Equipo PJ GF GC Puntos
1 Urraca CF B Urraca CF B 10 16 7 22
2 CD San Jorge Jorge 10 17 18 16
3 Arenas del Sella Arenas Sella 10 18 18 13
4 Atlético Siero Atlético 10 11 13 13
5 Club Siero B Club Siero 10 14 17 12
6 Iberia CF Iberia CF 10 14 17 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
TERCERA RFFPA GRUPO 3
Equipo PJ GF GC Puntos
1 AD Rivadedeva Rivadedeva 17 65 13 47
2 Arenas del Sella Arenas Sella 17 36 18 41
3 CD Llanes B CD Llanes B 17 59 23 38
4 UP Langreo B Langreo 17 30 19 33
5 Condal Club B Condal Club 18 42 38 29
6 Urraca CF B Urraca CF B 17 28 27 27
7 CD San Jorge Jorge 18 37 43 25
8 Europa de Nava Europa Nava 17 29 31 24
9 Independiente CF Independient 17 31 32 22
10 Colegio Riaño CF Colegio 17 27 40 21
11 CD Lealtad B Lealtad 17 27 24 18
12 UD Sariego UD Sariego 17 22 39 17
13 UD Siero UD Siero 17 23 41 16
14 UD Corbero UD Corbero 17 24 54 11
15 Canicas AC Canicas AC 17 28 46 10
16 CF Berron B CF Berron B 17 13 33 9

  USO DE MEMORIA  
5,169,880 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0012
Controller Execution Time ( Home / Category )  0.4434
Total Execution Time  0.4446
  CADENA URL  
/historico/Urraca-Cf-B
  GET DATOS  
$_GET['/historico/Urraca-Cf-B']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (32)  
0.0110  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 = 'Urraca-Cf-B' 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.0114  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 = 'Urraca-Cf-B' 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.0105  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=20114 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0105  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=20114 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0105  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=20114 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0106  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=20114 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0105  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=20114 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0106  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=20114 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0105  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=20114 AND type_rel = 2
0.0105  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=709 AND type_rel = 3
0.0107  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 3 AND rel.typeId = 709 AND rel.ln = 'es' AND rel.status=1 ORDER BY rel.creation_date desc,rel.cover_points DESC LIMIT 5
0.0108  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 (1088975,806083,759289,50689) ORDER BY n.cover_points DESC, update_date DESC
0.0107  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 = '20114' ORDER BY l.year DESC,cat.coefficient DESC
0.0108  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 = '20114' AND l.year = 2023 ORDER BY l.year DESC,cat.coefficient DESC
0.0107  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 = '20114' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0107  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 = '20114' AND ct.ctype=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0109  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=20114 AND l.year in (2022,2023,2024) ORDER BY l.id DESC, l.year DESC ;
0.0106  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 (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.0105  SELECT count(id) as num_players from rel_players WHERE league_id = 68983 AND teamId = 20114
0.0214  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff 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 t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0107  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 = '20114' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0105  SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '20114' and rp.type = 4
0.0107  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 = '20114' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0107  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 events2023 e ON e.player_id = p.id AND e.league_id = 68983 WHERE rp.league_id = 68983 AND rp.teamId = 20114 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.0106  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 events2023 e ON e.player_id = p.id AND e.league_id = 68983 WHERE rp.league_id = 68983 AND rp.teamId = 20114 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0106  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 events2023 e ON e.player_id = p.id AND e.league_id = 68983 WHERE rp.league_id = 68983 AND rp.teamId = 20114 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0107  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 = 20114 AND l.year <= 2023 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.0111  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.0108  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 = 63765 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.0107  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 = 62051 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.0111  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.0109  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 = 4318 AND t.round = 18 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC