Ver
TEMPORADA 2021/2022
Equipo PJ GF GC Puntos
1 RC Celta Sub 19 B Celta 34 112 30 86
2 RC Deportivo Sub 19 B Deportivo 34 85 38 79
3 Coruxo FC Sub 19 Coruxo 34 74 56 67
4 Lugo Sub 19 B Lugo 34 77 48 66
5 Arosa SC Sub 19 Arosa 34 77 38 64
6 CD Conxo Sub 19 Conxo 34 65 34 64
7 CD Calasanz CD Calasanz 34 43 55 49
8 Choco Sub 19 Choco 34 65 58 47
9 Bergantiños Sub 19 Bergantiños 34 58 59 44
10 Alondras Sub 19 Alondras 34 47 69 42
11 Racing Ferrol Sub 19 Racing 34 48 63 41
12 Pabellón Ourense Sub 19 B Pabellón 34 60 83 39
13 Porriño Industrial Sub 19 Porriño 34 50 60 38
14 Ural Español CF B Ural 34 45 69 32
15 CD Areosa CD Areosa 34 40 63 29
16 ED Val Miñor Nigrán B Miñor 34 51 78 28
17 Colegio Hogar Sub 19 Colegio 34 59 101 28
18 Racing Club Villalbés Racing Club 34 28 82 18
Ver
TEMPORADA 2020/2021
Equipo PJ GF GC Puntos
1 RC Deportivo Sub 19 B Deportivo 18 48 7 52
2 SD Compostela Sub 19 Compostela 18 54 22 40
3 Pontevedra Sub 19 Pontevedra 18 40 20 35
4 Racing Club Villalbés Racing Club 18 26 26 26
5 Arosa SC Sub 19 Arosa 18 30 28 26
6 Lugo Sub 19 B Lugo 18 30 29 26
7 Victoria CF Sub 19 Victoria 18 20 25 21
8 Atlético Coruña M. Sub 19 Atlético 18 22 32 19
9 Lalín EF Sub 19 Lalín 18 8 37 9
10 SD O Val Sub 19 18 17 69 6
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
Ver
TEMPORADA 2015/2016
Equipo PJ GF GC Puntos
1 RC Deportivo Sub 19 B Deportivo 34 101 38 74
2 Santiago de Compostela Santiago 34 70 38 67
3 CD Areosa CD Areosa 34 70 51 62
4 SD Compostela Sub 19 Compostela 34 62 56 60
5 RC Celta Sub 19 B Celta 34 83 51 56
6 Choco Sub 19 Choco 34 58 46 56
7 Arosa SC Sub 19 Arosa 34 53 54 56
8 Racing Ferrol Sub 19 Racing 34 73 61 51
9 Pontevedra Sub 19 Pontevedra 34 53 45 51
10 Porriño Industrial Sub 19 Porriño 34 62 62 47
11 CP Calasancio Calasancio 34 48 61 43
12 Lugo Sub 19 B Lugo 34 51 52 42
13 Coruxo FC Sub 19 Coruxo 34 40 42 41
14 CD Calasanz CD Calasanz 34 45 59 40
15 Ch San Roque Roque 34 50 79 38
16 Ural CF Sub 19 Ural 34 47 75 28
17 Pabellón Cf B Pabellón 34 40 79 28
18 Galicia de Caranza Galicia 34 36 93 23
Ver
TEMPORADA 2014/2015
Equipo PJ GF GC Puntos
1 Victoria CF Sub 19 Victoria 34 70 27 83
2 RC Celta Sub 19 B Celta 34 106 37 79
3 RC Deportivo Sub 19 B Deportivo 34 75 39 64
4 Ourense CF Sub 19 Ourense 34 42 30 61
5 SD Compostela Sub 19 Compostela 34 69 36 60
6 Choco Sub 19 Choco 34 42 41 50
7 Racing Ferrol Sub 19 Racing 34 59 67 47
8 CD Areosa CD Areosa 34 48 57 46
9 Pabellón Ourense Sub 19 B Pabellón 34 45 55 45
10 CD Calasanz CD Calasanz 34 47 61 43
11 Santiago de Compostela Santiago 34 44 51 41
12 Arosa SC Sub 19 Arosa 34 51 52 41
13 Galicia de Caranza Galicia 34 57 81 41
14 Coruxo FC Sub 19 Coruxo 34 59 69 40
15 Sárdoma Cf Sárdoma Cf 34 47 60 39
16 SD Residencia Residencia 34 49 64 31
17 Rápido De Bouzas A Rápido 34 49 90 21
18 Bergantiños Sub 19 Bergantiños 34 31 73 20
Ver
TEMPORADA 2013/2014
Equipo PJ GF GC Puntos
1 RC Celta Sub 19 B Celta 34 90 46 68
2 Alondras Sub 19 Alondras 34 87 39 67
3 ED Val Miñor Sub 19 Miñor 34 58 45 63
4 RC Deportivo Sub 19 B Deportivo 34 61 34 59
5 SD Compostela Sub 19 Compostela 34 42 40 58
6 Racing Ferrol Sub 19 Racing 34 73 64 52
7 Sárdoma Cf Sárdoma Cf 34 56 45 51
8 Arosa SC Sub 19 Arosa 34 51 49 47
9 Rápido De Bouzas A Rápido 34 51 67 47
10 Santiago de Compostela Santiago 34 54 44 47
11 Victoria CF Sub 19 Victoria 34 64 41 46
12 SD Residencia Residencia 34 45 67 43
13 Galicia de Caranza Galicia 34 53 67 41
14 Pabellón Ourense Sub 19 Pabellón 34 41 69 40
15 Choco Sub 19 Choco 34 43 49 39
16 Montañeros Cf Juvenil Montañeros 34 53 71 38
17 Cd Lérez Cd Lérez 34 53 79 30
18 CP Calasancio Calasancio 34 29 88 25
Ver
TEMPORADA 2012/2013
Equipo PJ GF GC Puntos
1 RC Deportivo Sub 19 B Deportivo 34 93 25 82
2 RC Celta Sub 19 B Celta 34 101 38 75
3 CD Areosa CD Areosa 34 88 40 72
4 Porriño Industrial Sub 19 Porriño 34 72 40 69
5 Sárdoma Cf Sárdoma Cf 34 69 34 63
6 Racing Ferrol Sub 19 Racing 34 75 53 58
7 SD Compostela Sub 19 Compostela 34 56 57 53
8 ED Val Miñor Sub 19 Miñor 34 61 71 48
9 Club Rápido De Bouzas Club Rápido 34 63 64 43
10 Pabellón Cf B Pabellón 34 54 70 43
11 CP Calasancio Calasancio 34 50 59 42
12 Arosa SC Sub 19 Arosa 34 60 50 41
13 Victoria CF Sub 19 Victoria 34 39 54 37
14 Cd Lérez Cd Lérez 34 48 74 35
15 Ural CF Sub 19 Ural 34 41 62 32
16 Conxo Conxo 34 30 65 31
17 Órdenes Sd Órdenes Sd 34 28 124 18
18 CD Calasanz CD Calasanz 34 40 88 12
Ver
TEMPORADA 2011/2012
Equipo PJ GF GC Puntos
1 RC Celta Sub 19 B Celta 34 129 29 95
2 Montañeros Cf Juvenil Montañeros 34 75 23 75
3 RC Deportivo Sub 19 B Deportivo 34 69 36 69
4 SD Compostela Sub 19 Compostela 34 78 47 67
5 CD Areosa CD Areosa 34 73 37 63
6 Victoria CF Sub 19 Victoria 34 59 48 63
7 Sárdoma Cf Sárdoma Cf 34 49 41 55
8 CD Calasanz CD Calasanz 34 56 57 46
9 Arosa SC Sub 19 Arosa 34 45 54 43
10 CP Calasancio Calasancio 34 46 74 40
11 ED Val Miñor Sub 19 Miñor 34 44 56 38
12 Ural CF Sub 19 Ural 34 40 59 36
13 Cd Lérez Cd Lérez 34 40 61 36
14 Bergantiños Sub 19 Bergantiños 34 51 69 34
15 Ch San Roque Roque 34 44 88 26
16 Sd Negreira Sd Negreira 34 32 89 26
17 Cd Lalín Cd Lalín 34 19 85 11
Ver
TEMPORADA 2010/2011
Equipo PJ GF GC Puntos
1 RC Celta Sub 19 B Celta 34 102 40 86
2 CD Lugo Sub 19 Lugo 34 96 29 82
3 Pabellón Ourense Sub 19 Pabellón 34 79 31 70
4 Victoria CF Sub 19 Victoria 34 77 44 67
5 Sárdoma Cf Sárdoma Cf 34 70 37 66
6 Arosa SC Sub 19 Arosa 34 57 46 52
7 RC Deportivo Sub 19 B Deportivo 34 62 48 51
8 ED Val Miñor Sub 19 Miñor 34 74 58 50
9 CD Calasanz CD Calasanz 34 60 57 46
10 Ural CF Sub 19 Ural 34 47 41 45
11 Cd Lalín Cd Lalín 34 53 52 42
12 Colegio Hogar SR Colegio 34 45 63 35
13 Bergantiños Sub 19 Bergantiños 34 45 69 35
14 Montañeros B Montañeros 34 53 69 33
15 Cd As Pontes Pontes 34 40 84 30
16 Sd Chantada Sd Chantada 34 43 70 26
17 Cultural Areas Juvenil Cultural 34 35 107 22
18 Alerta Traviesas Alerta 34 45 138 22
Ver
TEMPORADA 2009/2010
Equipo PJ GF GC Puntos
1 RC Deportivo Sub 19 B Deportivo 32 87 31 74
2 RC Celta Sub 19 B Celta 34 91 47 74
3 Conxo Conxo 34 72 43 68
4 CP Calasancio Calasancio 34 59 49 64
5 Sárdoma Cf Sárdoma Cf 34 57 42 58
6 Val Miñor Val Miñor 33 69 43 57
7 Cd Lalín Cd Lalín 34 53 49 53
8 Pabellón Ourense Sub 19 Pabellón 31 67 57 47
9 Bergantiños Sub 19 Bergantiños 34 49 52 44
10 Colegio Hogar Sub 19 Colegio 34 54 63 44
11 Cd As Pontes Pontes 34 61 76 42
12 Calasanz Calasanz 34 69 81 39
13 Cultural Areas Juvenil Cultural 32 42 65 38
14 Montañeros B Montañeros 34 56 65 36
15 Arosa SC Sub 19 Arosa 34 46 58 34
16 Areosa Areosa 34 43 67 34
17 Xuventu Aguiño SD Xuventu 34 52 104 25
18 Choco Sub 19 Choco 34 42 77 24
Ver
TEMPORADA 2008/2009
Equipo PJ GF GC Puntos
1 RC Deportivo Sub 19 B Deportivo 30 79 18 69
2 Racing De Ferrol Racing 30 70 39 62
3 RC Celta Sub 19 B Celta 30 65 39 55
4 Rápido De Bouzas A Rápido 30 65 39 54
5 Choco Sub 19 Choco 30 39 43 46
6 Val Miñor Val Miñor 30 53 40 45
7 Conxo Conxo 30 48 42 44
8 Lalín Lalín 30 44 48 44
9 As Pontes As Pontes 30 47 59 42
10 Areosa Areosa 30 54 59 39
11 Colegio Hogar SR Colegio 30 55 64 39
12 CP Calasancio Calasancio 30 39 51 39
13 Sárdoma Cf Sárdoma Cf 30 47 53 37
14 Montañeros B Montañeros 30 46 61 33
15 Residencia Residencia 30 36 55 33
16 Cd Ourense Cd Ourense 30 44 79 31
17 A Seca A Seca 30 41 68 26
18 Alerta Traviesas Alerta 30 37 52 25
Uso de cookies: Utilizamos "cookies" propias y de terceros para mejorar nuestros servicios, elaborar información estadística, analizar sus hábitos de navegación e inferir grupos de interés. Esto nos permite personalizar el contenido que ofrecemos y mostrarle publicidad relacionada con sus preferencias. Adicionalmente, compartimos los análisis de navegación y los grupos de interés inferidos con terceros. Si continúa navegando acepta su uso. Más información y cambio de configuración. Aceptar

  USO DE MEMORIA  
6,472,424 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0022
Controller Execution Time ( Home / Category )  0.4296
Total Execution Time  0.4318
  CADENA URL  
/nacional_juvenil2022/grupo1/historico
  GET DATOS  
$_GET['/nacional_juvenil2022/grupo1/historico']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (27)  
0.0105  SELECT type FROM routes WHERE alias = 'nacional_juvenil2022'
0.0211  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 = 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.0106  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 = 63614 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0110  SELECT id,year,current_round,total_teams,legend FROM leagues WHERE categoryId = 112 AND group_code = 1 and tables = 1 AND year <= 2022 AND total_num_tablesR >= 1 ORDER BY year DESC LIMIT 22
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 `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 = 63614 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 `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 = 58997 AND t.round = 18 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0106  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 = 50782 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.0106  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 = 45006 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0106  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 = 39217 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0106  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 = 34227 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 `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 = 16645 AND t.round = 34 ORDER BY team.conference 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 `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 = 4204 AND t.round = 34 ORDER BY team.conference 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 `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 = 2729 AND t.round = 34 ORDER BY team.conference 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 `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 = 2123 AND t.round = 34 ORDER BY team.conference 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 `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 = 1508 AND t.round = 34 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 `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 = 1178 AND t.round = 30 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 `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 = 903 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 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 = 747 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0105  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-03-28 22:46:01' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0105  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=2 AND last_update > '2024-03-28 22:46:01' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0105  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=4 AND last_update > '2024-03-28 22:46:01' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0105  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=3 AND last_update > '2024-03-28 22:46:01' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0110  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 = 2022 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=0 DESC LIMIT 1
0.0222  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 = 63614 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 63614 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.0210  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 = 63614 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 63614 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 events2022 e ON e.player_id = p.id AND e.league_id = 63614 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 63614 AND (e.action = 3 or e.action = 4) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0117  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 = 63614 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