4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Ver
TEMPORADA 2019/2020
Equipo PJ GF GC Puntos
Ver
TEMPORADA 2018/2019
Equipo PJ GF GC Puntos
Ver
TEMPORADA 2017/2018
Equipo PJ GF GC Puntos
Ver
TEMPORADA 2016/2017
Equipo PJ GF GC Puntos
1 Andés CF A Andés CF A 0 0 0 0
2 Astur CF Sub 19 Astur 0 0 0 0
3 CD Arenal Sub 19 Arenal 0 0 0 0
4 CD Covadonga Sub 19 Covadonga 0 0 0 0
5 CD Llanes Sub 19 Llanes 0 0 0 0
6 CD Quirinal Sub 19 Quirinal 0 0 0 0
7 CD Vallobín Sub 19 Vallobín 0 0 0 0
8 Club Alcázar Sub 19 Club 0 0 0 0
9 Colegio Inmaculada Sub 19 Colegio 0 0 0 0
10 Juventud Estadio Sub 19 Juventud 0 0 0 0
11 La Corredoria Corredoria 0 0 0 0
12 Montevil Montevil 0 0 0 0
13 Real Oviedo Sub 19 B Real Oviedo 0 0 0 0
14 Real Sporting Sub 19 B Real 0 0 0 0
15 SD Llano 2000 Sub 19 Llano 2000 0 0 0 0
16 TSK Roces B TSK Roces B 0 0 0 0
17 Ud San Claudio Claudio 0 0 0 0
18 Veriña CF Sub 19 Veriña 0 0 0 0
Ver
TEMPORADA 2015/2016
Equipo PJ GF GC Puntos
1 Real Oviedo Sub 19 B Real Oviedo 34 84 28 79
2 Real Sporting Sub 19 B Real 34 91 38 72
3 Real Avilés Sub 19 Real Avilés 34 61 36 66
4 Club Alcázar Sub 19 Club 34 69 45 64
5 Veriña CF Sub 19 Veriña 34 58 56 56
6 CD Quirinal Sub 19 Quirinal 34 67 57 52
7 Ud San Claudio Claudio 34 42 48 48
8 Colegio Inmaculada Sub 19 Colegio 34 48 46 47
9 Astur CF Sub 19 Astur 34 61 49 47
10 SD Llano 2000 Sub 19 Llano 2000 34 63 61 43
11 Juventud Estadio Sub 19 Juventud 34 52 57 39
12 CD Llanes Sub 19 Llanes 34 57 64 39
13 CD Arenal Sub 19 Arenal 34 51 69 38
14 CD Vallobín Sub 19 Vallobín 34 37 45 38
15 Alcava Alcava 34 50 79 37
16 Caudal Deportivo A Caudal 34 47 75 35
17 CD Covadonga Sub 19 Covadonga 34 47 55 33
18 CD Raíces Sub 19 Raíces 34 33 110 17
Ver
TEMPORADA 2014/2015
Equipo PJ GF GC Puntos
1 Real Sporting Sub 19 B Real 34 86 30 81
2 Real Oviedo Sub 19 B Real Oviedo 34 86 33 76
3 Deportivo Roces Sub 19 Deportivo 34 75 45 64
4 CD Covadonga Sub 19 Covadonga 34 68 44 58
5 SD Llano 2000 Sub 19 Llano 2000 34 65 50 57
6 CD Quirinal Sub 19 Quirinal 34 62 54 52
7 CD Vallobín Sub 19 Vallobín 34 44 40 50
8 CD Arenal Sub 19 Arenal 34 52 51 46
9 Real Avilés Sub 19 Real Avilés 34 58 67 45
10 Club Alcázar Sub 19 Club 34 46 69 45
11 Caudal Deportivo A Caudal 34 55 45 44
12 Juventud Estadio Sub 19 Juventud 34 45 56 40
13 CD Llanes Sub 19 Llanes 34 44 57 40
14 Colegio Inmaculada Sub 19 Colegio 34 46 66 40
15 Navarro CF A Navarro 34 42 62 35
16 Cd La Braña Braña 34 41 68 35
17 Cc La Fresneda Fresneda 34 38 72 24
18 Andés CF A Andés CF A 34 27 71 17
Ver
TEMPORADA 2013/2014
Equipo PJ GF GC Puntos
1 Real Sporting Sub 19 B Real 34 95 33 79
2 Real Oviedo Sub 19 B Real Oviedo 34 91 41 71
3 Astur CF Sub 19 Astur 34 62 31 66
4 CD Quirinal Sub 19 Quirinal 34 66 50 63
5 Real Avilés Sub 19 Real Avilés 34 75 48 62
6 Caudal Deportivo A Caudal 34 66 46 57
7 CD Arenal Sub 19 Arenal 34 63 42 57
8 Navarro CF A Navarro 34 90 57 52
9 CD Covadonga Sub 19 Covadonga 34 56 57 50
10 Club Alcázar Sub 19 Club 34 39 52 46
11 Ñublense Ñublense 34 54 63 44
12 Cc La Fresneda Fresneda 34 38 46 42
13 Colegio Inmaculada Sub 19 Colegio 34 47 63 39
14 Cd Juventud Cd Juventud 34 48 56 37
15 CD Llanes Sub 19 Llanes 34 43 61 36
16 Ud San Claudio Claudio 34 30 58 33
17 Romanón Sub 19 Romanón 34 36 86 24
18 Estudiantes Estudiantes 34 23 132 2
Ver
TEMPORADA 2012/2013
Equipo PJ GF GC Puntos
1 SD Llano 2000 Llano 2000 34 84 31 79
2 Real Sporting Sub 19 B Real 34 110 44 73
3 Estudiantes Estudiantes 34 68 26 72
4 Astur CF Sub 19 Astur 34 75 56 53
5 Real Oviedo Sub 19 B Real Oviedo 34 56 46 50
6 Cc La Fresneda Fresneda 34 59 66 50
7 Romanón Sub 19 Romanón 34 59 55 48
8 Cd La Braña Braña 34 39 56 44
9 CD Covadonga Sub 19 Covadonga 34 54 60 43
10 Ud San Claudio Claudio 34 50 62 43
11 Club Alcázar Sub 19 Club 34 41 58 43
12 Navarro CF A Navarro 34 58 64 41
13 CD Arenal Sub 19 Arenal 34 49 54 40
14 Real Avilés Sub 19 Real Avilés 34 46 61 39
15 CD Roces B Juvenil Roces 34 52 84 39
16 CD Llanes Sub 19 Llanes 34 44 63 34
17 Andés CF A Andés CF A 33 51 80 33
18 S.D. Narcea Sub 19 S.D. Narcea 33 44 73 32
Ver
TEMPORADA 2011/2012
Equipo PJ GF GC Puntos
1 Veriña CF Sub 19 Veriña 34 63 27 74
2 Real Sporting Sub 19 B Real 34 93 40 62
3 Real Oviedo Sub 19 B Real Oviedo 34 62 42 59
4 Real Avilés Industrial Real Avilés 34 58 44 58
5 CD Llanes Sub 19 Llanes 34 58 56 55
6 CD Roces B Juvenil Roces 34 66 47 54
7 CD Covadonga Sub 19 Covadonga 34 50 42 50
8 Romanón Sub 19 Romanón 34 63 62 47
9 CD Arenal Sub 19 Arenal 34 51 47 42
10 Club Alcázar Sub 19 Club 34 44 48 41
11 Astur CF Sub 19 Astur 34 54 67 41
12 Cd La Braña Braña 34 52 65 38
13 Ud San Claudio Claudio 34 45 58 38
14 Estudiantes Estudiantes 34 45 71 35
15 Caudal Deportivo A Caudal 34 56 82 34
16 UD Llanera Sub 19 Llanera 34 54 110 30
17 CD Raíces Sub 19 Raíces 34 60 113 22
Ver
TEMPORADA 2010/2011
Equipo PJ GF GC Puntos
1 Real Oviedo Sub 19 Real Oviedo 30 91 24 74
2 Real Sporting Sub 19 B Real 30 94 43 69
3 Astur CF Sub 19 Astur 30 51 40 51
4 CD Raíces Sub 19 Raíces 30 56 56 50
5 CD Llanes Sub 19 Llanes 30 62 65 42
6 Caudal Deportivo A Caudal 30 45 51 39
7 CD Covadonga Sub 19 Covadonga 30 50 57 39
8 Real Avilés Industrial Real Avilés 30 57 54 37
9 Cd La Braña Braña 30 35 42 37
10 Veriña CF Sub 19 Veriña 30 39 51 36
11 CD Arenal Sub 19 Arenal 30 53 68 35
12 CD Roces B Juvenil Roces 30 36 50 30
13 Navarro CF A Navarro 30 44 66 28
14 Juventud Estadio Sub 19 Juventud 30 43 74 28
15 Alcava Alcava 30 38 84 21
Ver
TEMPORADA 2009/2010
Equipo PJ GF GC Puntos
1 Los Alcázares Alcázares 30 86 26 73
2 Alcava Alcava 30 54 50 54
3 Real Avilés Sub 19 Real Avilés 30 67 43 53
4 La Braña La Braña 30 63 50 49
5 Real Sporting Sub 19 B Real 30 69 54 48
6 CD Roces B Juvenil Roces 30 45 42 46
7 Real Oviedo Sub 19 B Real Oviedo 30 47 45 43
8 Juventud Estadio Juventud 30 56 55 42
9 CD Llanes Sub 19 Llanes 30 41 41 37
10 CD Covadonga Sub 19 Covadonga 30 56 70 36
11 Navarro CF A Navarro 30 53 65 32
12 Estudiantes Estudiantes 30 46 67 32
13 UD Gijon Industrial A Gijon 30 36 85 22
14 Inmaculada Inmaculada 30 48 93 13
Ver
TEMPORADA 2008/2009
Equipo PJ GF GC Puntos
1 Astur Astur 30 66 43 61
2 Real Sporting Sub 19 B Real 30 50 31 57
3 C.D. Alcázar B C.D. 30 59 33 56
4 La Braña La Braña 30 55 43 47
5 Navarro Navarro 30 50 46 44
6 CD Roces B Juvenil Roces 30 52 46 43
7 Real Oviedo Sub 19 B Real Oviedo 30 47 41 38
8 CD Llanes Sub 19 Llanes 30 39 42 36
9 Estudiantes Estudiantes 30 42 47 35
10 Inmaculada Inmaculada 30 44 55 35
11 Arenas Club Sub 19 Arenas Club 30 38 44 34
12 CD Covadonga Sub 19 Covadonga 30 44 56 34
13 Caudal Deportivo A Caudal 30 33 58 32
14 CD Romanón A Romanón 30 35 82 19

  USO DE MEMORIA  
6,090,992 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0020
Controller Execution Time ( Home / Category )  0.0998
Total Execution Time  0.1018
  CADENA URL  
/nacional_juvenil2020/grupo2/historico
  GET DATOS  
$_GET['/nacional_juvenil2020/grupo2/historico']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (29)  
0.0018  SELECT type FROM routes WHERE alias = 'nacional_juvenil2020'
0.0039  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'nacional_juvenil' AND (l.group_code = 2 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 2020 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=2 DESC LIMIT 1
0.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=112 AND type_rel = 3
0.0021  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 3 AND rel.typeId = 112 AND rel.ln = 'es' AND rel.status=1 ORDER BY rel.creation_date desc,rel.cover_points DESC LIMIT 5
0.0022  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 (1243526,1233227,1223087,1219000,1197928) ORDER BY n.cover_points DESC, update_date DESC
0.0018  SELECT id,name,alias,stepParent FROM categories WHERE parentId=112 ORDER BY order_id ASC
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 = 50781 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0026  SELECT id,year,current_round,total_teams,legend FROM leagues WHERE categoryId = 112 AND group_code = 2 and tables = 1 AND year <= 2020 AND total_num_tablesR >= 1 ORDER BY year DESC LIMIT 22
0.0019  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 = 50781 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.0019  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 = 44712 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 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 = 39218 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 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 = 34228 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 = 16646 AND t.round = 34 ORDER BY team.conference 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 `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 = 4205 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0025  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 `tables2014` 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 = 2730 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0026  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 `tables2013` 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 = 2124 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 `tables2012` 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 = 1509 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 `tables2011` 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 = 1180 AND t.round = 30 ORDER BY team.conference 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 `tables2010` 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 = 922 AND t.round = 30 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 `tables2009` 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 = 748 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0018  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-05-03 09:12:21' 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-05-03 09:12:21' 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-05-03 09:12:21' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0019  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=3 AND last_update > '2024-05-03 09:12:21' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0022  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'nacional_juvenil' AND (l.group_code = 0 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 2020 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 events2020 e ON e.player_id = p.id AND e.league_id = 50781 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 50781 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 events2020 e ON e.player_id = p.id AND e.league_id = 50781 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 50781 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 events2020 e ON e.player_id = p.id AND e.league_id = 50781 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 50781 AND (e.action = 3 or e.action = 4) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0046  SELECT *,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables2020_base` 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 = 50781 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