4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Ver
TEMPORADA 2021/2022
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
Ver
TEMPORADA 2020/2021
Equipo PJ GF GC Puntos
1 CD Manuel Rubio Manuel Rubio 8 22 8 21
2 Atlético Camocha Atlético 8 16 12 13
3 Quintueles CF Quintueles 8 14 12 13
4 CF Estudiantes Estudiantes 8 16 23 7
5 Unión Astur CF Unión Astur 8 10 23 4
Ver
TEMPORADA 2019/2020
Equipo PJ GF GC Puntos
1 Langreo Eulalia Langreo 28 75 30 60
2 Ribadesella Ribadesella 28 46 26 60
3 Gozón Gozón 28 57 29 58
4 Europa de Nava Europa Nava 28 50 31 58
5 CD Manuel Rubio Manuel Rubio 28 53 33 54
6 Arguero Arguero 28 37 40 39
7 Lealtad Villaviciosa B Lealtad 28 41 42 38
8 La Fresneda Fresneda 28 42 55 36
9 Ribadedeva Ribadedeva 28 30 31 35
10 Deportiva Piloñesa Deportiva 28 25 36 34
11 GD Bosco GD Bosco 28 35 54 33
12 Club Hispano Club Hispano 28 45 47 32
13 Quintueles CF Quintueles 28 27 33 31
14 Atlético Camocha Atlético 28 32 54 30
15 Independiente CF Independient 28 39 46 29
16 CF Estudiantes Estudiantes 28 43 55 29
17 SCD Campomanes Campomanes 28 33 52 22
18 Unión Astur CF Unión Astur 28 36 52 21
Ver
TEMPORADA 2018/2019
Equipo PJ GF GC Puntos
1 Unión Comercial Unión 34 89 24 85
2 Langreo Eulalia Langreo 34 79 35 72
3 La Guía Norte Astur Guía Norte 34 69 41 67
4 Arguero Arguero 34 64 42 58
5 Pumarín Cf Pumarín Cf 34 56 41 54
6 Deportiva Piloñesa Deportiva 34 56 43 53
7 Celtic de Puerto Celtic 34 54 36 52
8 SCD Campomanes Campomanes 34 68 58 50
9 CD Manuel Rubio Manuel Rubio 34 60 55 47
10 CD La Manjoya Manjoya 34 40 57 46
11 Unión Astur CF Unión Astur 34 57 59 45
12 Lealtad Villaviciosa B Lealtad 34 47 54 41
13 Real Juvencia Real 34 42 52 39
14 UD San Claudio B Claudio 34 49 63 37
15 Guillen Lafuerza Guillen 34 42 68 37
16 Beredi Beredi 34 61 67 35
17 Arenas del Sella Arenas Sella 34 30 82 18
18 CD Rayo Carbayín Rayo 34 33 119 14
Ver
TEMPORADA 2017/2018
Equipo PJ GF GC Puntos
1 Berrón Berrón 34 85 27 82
2 Pumarín Cf Pumarín Cf 34 74 33 75
3 Sd Colloto Sd Colloto 34 62 34 72
4 Real Juvencia Real 34 37 19 61
5 Arguero Arguero 34 82 47 60
6 Gozón Gozón 34 52 43 55
7 La Guía Norte Astur Guía Norte 34 54 47 49
8 UD San Claudio B Claudio 34 62 75 47
9 Arenas del Sella Arenas Sella 34 45 51 46
10 La Fresneda Fresneda 34 63 69 45
11 Langreo Eulalia Langreo 34 47 48 43
12 Unión Astur CF Unión Astur 34 51 59 41
13 Lealtad Villaviciosa B Lealtad 34 48 62 41
14 Beredi Beredi 34 46 62 40
15 Guillen Lafuerza Guillen 34 51 66 37
16 Rosal FC Rosal FC 34 49 72 30
17 CD Ujo CD Ujo 34 53 89 25
18 Riosa Riosa 34 30 88 16
Ver
TEMPORADA 2016/2017
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
Ver
TEMPORADA 2015/2016
Equipo PJ GF GC Puntos
1 Muros Balompié Muros 34 91 30 84
2 Llaranes CF Llaranes CF 34 77 31 76
3 Real Tapia CF Real Tapia 34 64 40 70
4 Podes CF Podes CF 34 63 53 58
5 C.D. Valsa C.D. Valsa 34 53 41 57
6 CD Salas CD Salas 34 50 46 52
7 Narcea Narcea 34 49 42 51
8 La Guía Norte Astur Guía Norte 34 50 49 50
9 Boal CF Boal CF 34 54 50 50
10 Club Hispano Club Hispano 34 57 59 44
11 CD Manuel Rubio Manuel Rubio 34 61 56 44
12 Gozón Gozón 34 38 48 40
13 La Caridad La Caridad 34 52 64 39
14 Arenesco Arenesco 34 57 72 37
15 Astur Vegadense Astur 34 51 60 34
16 CD Pillarno CD Pillarno 34 33 58 33
17 Miranda C.F. Miranda C.F. 34 39 62 31
18 CD Raíces CD Raíces 34 20 98 10
Ver
TEMPORADA 2014/2015
Equipo PJ GF GC Puntos
1 La Fresneda Fresneda 34 66 26 71
2 Berrón Berrón 34 53 29 65
3 Llaranes CF Llaranes CF 34 54 28 63
4 Colloto Colloto 34 52 34 62
5 Club Hispano Club Hispano 34 58 48 58
6 Narcea Narcea 34 46 39 53
7 C.D. Valsa C.D. Valsa 34 54 42 52
8 Gozón Gozón 34 44 29 51
9 La Guía Norte Astur Guía Norte 34 44 45 51
10 Podes CF Podes CF 34 53 51 49
11 Atlético Siero Atlético 34 43 43 45
12 Miranda C.F. Miranda C.F. 34 54 53 41
13 CD Manuel Rubio Manuel Rubio 34 36 53 39
14 Astur Vegadense Astur 34 30 45 38
15 La Caridad La Caridad 34 36 67 32
16 Barcia CF Barcia CF 34 42 67 29
17 Atlético Camocha Atlético 34 34 56 27
18 Navia CF Navia CF 34 26 70 20

  USO DE MEMORIA  
5,722,976 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0018
Controller Execution Time ( Home / Category )  0.0849
Total Execution Time  0.0868
  CADENA URL  
/primera_regional_asturias2022/grupo1/historico
  GET DATOS  
$_GET['/primera_regional_asturias2022/grupo1/historico']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (24)  
0.0018  SELECT type FROM routes WHERE alias = 'primera_regional_asturias2022'
0.0038  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'primera_regional_asturias' AND (l.group_code = 1 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 2022 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=1 DESC LIMIT 1
0.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=709 AND type_rel = 3
0.0019  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.0021  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.0020  SELECT dt.nameShow,dt.basealias,t.id,t.teamId FROM teams t INNER JOIN datateams dt ON t.teamId = dt.id WHERE t.league_id = 63765 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0020  SELECT id,year,current_round,total_teams,legend FROM leagues WHERE categoryId = 709 AND group_code = 1 and tables = 1 AND year <= 2022 AND total_num_tablesR >= 1 ORDER BY year DESC LIMIT 22
0.0022  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.0022  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 = 59034 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.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 `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 = 51304 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.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 `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 = 45221 AND t.round = 34 ORDER BY team.conference 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 `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 = 39200 AND t.round = 34 ORDER BY team.conference 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 `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.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 `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 = 16776 AND t.round = 34 ORDER BY team.conference 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 `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 = 4309 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0019  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-04-24 14:17:26' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0018  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=2 AND last_update > '2024-04-24 14:17:26' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0018  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=4 AND last_update > '2024-04-24 14:17:26' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0018  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=3 AND last_update > '2024-04-24 14:17:26' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0023  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'primera_regional_asturias' AND (l.group_code = 0 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 2022 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=0 DESC LIMIT 1
0.0020  SELECT e.action, count(e.action) as total,p.name, p.last_name, p.nick,p.CountryCode,p.alias,rp.team_id,dt.nameShow,dt.short_name,dt.basealias,rp.player_id,rp.teamId FROM `rel_players` rp INNER JOIN dataplayers p ON p.id = rp.player_id INNER JOIN events2022 e ON e.player_id = p.id AND e.league_id = 63765 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 63765 AND (e.action = 1 or e.action = 2 or e.action = 11 or e.action = 12 or e.action = 13) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0019  SELECT e.action, count(e.action) as total,p.name, p.last_name, p.nick,p.CountryCode,p.alias,rp.team_id,dt.nameShow,dt.short_name,dt.basealias,rp.player_id,rp.teamId FROM `rel_players` rp INNER JOIN dataplayers p ON p.id = rp.player_id INNER JOIN events2022 e ON e.player_id = p.id AND e.league_id = 63765 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 63765 AND (e.action = 4 or e.action = 5) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0019  SELECT e.action, count(e.action) as total,p.name, p.last_name, p.nick,p.CountryCode,p.alias,rp.team_id,dt.nameShow,dt.short_name,dt.basealias,rp.player_id,rp.teamId FROM `rel_players` rp INNER JOIN dataplayers p ON p.id = rp.player_id INNER JOIN events2022 e ON e.player_id = p.id AND e.league_id = 63765 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 63765 AND (e.action = 3 or e.action = 4) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0030  SELECT *,(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