4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Ver
TEMPORADA 2023/2024
Equipo PJ GF GC Puntos
1 SD Colloto B Colloto 27 86 26 66
2 La Corredoria Corredoria 27 115 27 65
3 Versalles CF Versalles 27 85 31 62
4 Guillen Lafuerza Guillen 27 96 30 60
5 Los Campos Los Campos 27 106 47 53
6 Celtic de Puerto Celtic 27 60 40 42
7 San Juan La Carisa Juan Carisa 27 63 38 41
8 San Ignacio San Ignacio 27 66 61 37
9 Oviedo City FC Oviedo City 27 62 52 36
10 Club Atletico de La Florida Club 27 49 63 33
11 Centro Asturiano Oviedo Centro 27 59 58 32
12 CD Raices CD Raices 27 51 56 25
13 Miranda C.F. Miranda C.F. 27 50 69 19
14 Salesianos Masaveu Salesianos 27 31 152 6
15 Grisu CF Grisu CF 28 14 243 3
Ver
TEMPORADA 2022/2023
Equipo PJ GF GC Puntos
1 Rosal FC Rosal FC 26 77 30 55
2 Santa Marina de Mieres Santa Marina 26 66 31 54
3 Riosa Riosa 26 75 26 52
4 CD La Manjoya Manjoya 26 58 23 52
5 La Corredoria Corredoria 26 91 34 51
6 SCD Campomanes Campomanes 25 55 31 46
7 Real Avilés B Real Avilés 26 79 40 42
8 Guillen Lafuerza Guillen 25 62 47 39
9 Oviedo City FC Oviedo City 26 63 53 33
10 CD Ujo CD Ujo 26 78 72 33
11 SD Colloto B Colloto 26 45 59 29
12 Centro Asturiano Oviedo Centro 26 40 77 19
13 Club Atletico de La Florida Club 26 30 105 13
14 Grisu CF Grisu CF 26 15 206 3
Ver
TEMPORADA 2021/2022
Equipo PJ GF GC Puntos
1 La Fresneda Fresneda 22 94 15 61
2 Juventud Estadio Juventud 22 79 15 53
3 Rosal FC Rosal FC 22 76 23 53
4 E.F. Real Oviedo E.F. Real O. 22 71 49 40
5 Riosa Riosa 22 60 47 37
6 At. de Lugones B Lugones 22 51 46 37
7 SD Colloto B Colloto 22 35 50 26
8 Oviedo City FC Oviedo City 22 25 42 24
9 Grisu CF Grisu CF 22 37 77 19
10 San Juan La Carisa Juan Carisa 22 38 69 16
11 Club Atletico de La Florida Club 22 18 101 11
12 Centro Asturiano Oviedo Centro 22 37 87 8
Ver
TEMPORADA 2020/2021
Equipo PJ GF GC Puntos
1 Candas CF B Candas CF B 8 13 4 20
2 Triple A Gijón Triple 8 19 7 17
3 CD Montevil Montevil 8 16 17 6
4 CD Aboño CD Aboño 8 10 18 5
5 Quintueles CF B Quintueles 8 12 24 5
Ver
TEMPORADA 2019/2020
Equipo PJ GF GC Puntos
1 Llanera B Llanera B 22 84 33 53
2 Juventud Estadio Juventud 22 65 21 53
3 At. de Lugones B Lugones 22 66 27 50
4 La Corredoria Corredoria 22 64 27 48
5 Grujoan Grujoan 22 69 35 42
6 Santa Marina de Mieres Santa Marina 22 63 37 41
7 L'Entregu B L'Entregu B 22 54 31 41
8 Lenense Proinastur B Lenense 22 62 45 39
9 Rosal FC Rosal FC 22 59 40 38
10 C Santiago de Aller Santiago 22 54 40 30
11 Riosa Riosa 22 37 56 21
12 San Juan La Carisa Juan Carisa 22 29 74 19
13 Colegio Riaño CF Colegio 22 40 98 14
14 CD Turon B CD Turon B 22 44 77 13
15 Stiaua d'Asturies Stiaua 22 12 68 4
16 Grisu CF Grisu CF 22 20 113 4
Ver
TEMPORADA 2018/2019
Equipo PJ GF GC Puntos
1 Covadonga B Covadonga B 28 105 27 67
2 Marino de Cudillero Marino 28 70 13 67
3 Juventud Estadio Juventud 28 60 26 58
4 Rosal FC Rosal FC 28 70 42 58
5 Grujoan Grujoan 28 81 34 56
6 Boal CF Boal CF 28 67 22 56
7 La Corredoria Corredoria 28 68 50 52
8 Racing de Pravia Racing 28 50 35 46
9 Navia CF Navia CF 28 53 61 35
10 Soto del Barco Soto Barco 28 62 69 30
11 Stiaua d'Asturies Stiaua 28 31 69 26
12 San Esteban de Pravia Esteban 28 21 103 16
13 Minas Oviedo Minas Oviedo 28 44 87 14
14 San Juan La Carisa Juan Carisa 28 32 85 11
15 Grisu CF Grisu CF 28 30 121 6
Ver
TEMPORADA 2017/2018
Equipo PJ GF GC Puntos
1 Celtic de Puerto Celtic 26 84 23 65
2 CD La Manjoya Manjoya 26 85 22 58
3 Juventud Estadio Juventud 26 62 25 57
4 Grujoan Grujoan 25 91 24 51
5 La Corredoria Corredoria 26 55 34 49
6 CD Pillarno CD Pillarno 25 61 35 48
7 Minas Oviedo Minas Oviedo 26 68 52 41
8 Rayo Villalegre Rayo 25 43 51 32
9 Grisu CF Grisu CF 25 46 59 30
10 Versalles CF Versalles 26 39 67 25
11 Colegio Riaño CF Colegio 26 39 97 21
12 San Juan La Carisa Juan Carisa 26 31 59 20
13 Salesianos Masaveu Salesianos 26 23 89 10
14 Stiaua d'Asturies Stiaua 26 23 113 7
Ver
TEMPORADA 2016/2017
Equipo PJ GF GC Puntos
1 Langreo Eulalia Langreo 15 47 13 39
2 Rosal FC Rosal FC 15 43 21 36
3 La Corredoria Corredoria 15 45 18 32
4 San Juan La Carisa Juan Carisa 14 36 18 32
5 CD Ujo CD Ujo 15 32 18 31
6 Celtic de Puerto Celtic 15 36 16 30
7 C Santiago de Aller Santiago 14 24 25 19
8 Minas Oviedo Minas Oviedo 15 27 20 18
9 CD La Manjoya Manjoya 15 26 26 17
10 Colegio Riaño CF Colegio 15 21 36 16
11 Rayo Las Caldas Rayo Caldas 15 20 36 14
12 Grisu CF Grisu CF 15 21 48 13
13 Grujoan Grujoan 15 24 47 9
14 CD Tineo B CD Tineo B 15 16 41 7
15 Stiaua d'Asturies Stiaua 14 16 51 6
Ver
TEMPORADA 2015/2016
Equipo PJ GF GC Puntos
1 Avilés Stadium Avilés 32 118 9 84
2 UD San Claudio B Claudio 32 89 25 73
3 GD Bosco GD Bosco 32 90 26 73
4 Rosal FC Rosal FC 32 114 43 71
5 La Corredoria Corredoria 32 81 23 68
6 Minas Oviedo Minas Oviedo 32 89 42 63
7 Celtic de Puerto Celtic 32 75 36 59
8 San Juan La Carisa Juan Carisa 32 65 44 51
9 Oviedo 06 Oviedo 06 32 80 58 51
10 Pumarin B Pumarin B 32 49 70 32
11 Rayo Villalegre Rayo 32 47 103 30
12 Stiaua d'Asturies Stiaua 32 36 90 26
13 Versalles CF Versalles 32 24 89 25
14 Rayo Las Caldas Rayo Caldas 32 33 118 17
15 CD La Manjoya Manjoya 32 27 91 12
16 Centro Asturiano Centro 32 39 137 11
Ver
TEMPORADA 2014/2015
Equipo PJ GF GC Puntos
1 CD Salas CD Salas 29 119 22 74
2 La Corredoria Corredoria 29 79 22 64
3 Guillén Lafuerza Guillén 29 86 32 64
4 Rosal FC Rosal FC 29 85 36 64
5 CD Ujo CD Ujo 30 74 47 55
6 Minas Oviedo Minas Oviedo 30 68 52 51
7 Pumarin B Pumarin B 29 84 45 50
8 UD San Claudio B Claudio 29 56 42 49
9 CD Tineo B CD Tineo B 29 56 54 49
10 Stiaua d'Asturies Stiaua 29 39 62 31
11 Oviedo 06 Oviedo 06 29 42 68 31
12 Cubia FC Cubia FC 29 47 75 26
13 CD La Manjoya Manjoya 29 37 56 22
14 San Juan La Carisa Juan Carisa 29 42 111 18
15 Grisu CF Grisu CF 29 32 117 13
16 Centro Asturiano Centro 29 23 128 7

  USO DE MEMORIA  
5,838,320 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0031
Controller Execution Time ( Home / Category )  0.3046
Total Execution Time  0.3077
  CADENA URL  
/segunda_regional_asturias2024/grupo2/historico
  GET DATOS  
$_GET['/segunda_regional_asturias2024/grupo2/historico']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (20)  
0.0108  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 3 AND rel.typeId = 710 AND rel.ln = 'es' AND rel.status=1 ORDER BY rel.creation_date desc,rel.cover_points DESC LIMIT 5
0.0109  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 (510396,510516) ORDER BY n.cover_points DESC, update_date DESC
0.0106  SELECT id,name,alias,stepParent FROM categories WHERE parentId=710 ORDER BY order_id ASC
0.0107  SELECT id,year,current_round,total_teams,legend FROM leagues WHERE categoryId = 710 AND group_code = 2 and tables = 1 AND year <= 2024 AND total_num_tablesR >= 1 ORDER BY year DESC LIMIT 22
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 `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 = 73713 AND t.round = 29 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 = 63769 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.0112  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 = 59357 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.0110  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 = 51425 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.0110  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 = 45246 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0113  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 = 39810 AND t.round = 26 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 `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 = 34362 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0113  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 = 16935 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0117  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 = 4317 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0110  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-05-01 15:34:29' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0110  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=2 AND last_update > '2024-05-01 15:34:29' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0111  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=4 AND last_update > '2024-05-01 15:34:29' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0110  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=3 AND last_update > '2024-05-01 15:34:29' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0119  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 events2024 e ON e.player_id = p.id AND e.league_id = 73713 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 73713 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.0115  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 events2024 e ON e.player_id = p.id AND e.league_id = 73713 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 73713 AND (e.action = 4 or e.action = 5) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0116  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 events2024 e ON e.player_id = p.id AND e.league_id = 73713 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 73713 AND (e.action = 3 or e.action = 4) GROUP BY e.player_id ORDER BY total DESC LIMIT 10