4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Ver
TEMPORADA 2014/2015
Equipo PJ GF GC Puntos
1 RC Celta Sub 19 Celta 30 88 19 73
2 Deportivo Sub 19 Deportivo 30 76 37 64
3 Racing Sub 19 Racing 30 71 36 58
4 Real Oviedo Sub 19 Real Oviedo 30 66 52 54
5 ED Val Miñor Sub 19 Miñor 30 44 43 44
6 Real Sporting Sub 19 Real 30 63 44 43
7 Pabellón Ourense Sub 19 Pabellón 30 40 42 43
8 Tropezón Juvenil Tropezón 30 37 40 42
9 SD Llano 2000 Llano 2000 30 28 40 39
10 Atlético Perines Sub 19 Atlético 30 38 45 38
11 CD Lugo Sub 19 Lugo 30 35 50 36
12 Alondras Sub 19 Alondras 30 42 66 36
13 Porriño Industrial Sub 19 Porriño 30 45 59 35
14 Pontevedra Sub 19 Pontevedra 30 48 69 31
15 Veriña C.F. Veriña C.F. 30 36 67 22
16 Astur CF Sub 19 Astur 30 28 76 15
Ver
TEMPORADA 2013/2014
Equipo PJ GF GC Puntos
1 Racing Sub 19 Racing 30 76 26 70
2 RC Celta Sub 19 Celta 30 85 29 65
3 Deportivo Sub 19 Deportivo 30 59 35 53
4 Pabellón Ourense Sub 19 Pabellón 30 37 37 44
5 Real Sporting Sub 19 Real 30 56 50 41
6 SD Llano 2000 Llano 2000 30 44 40 41
7 Real Oviedo Sub 19 Real Oviedo 30 49 49 39
8 Porriño Industrial Sub 19 Porriño 30 45 49 39
9 CD Lugo Sub 19 Lugo 30 48 50 37
10 Atlético Perines Sub 19 Atlético 30 51 55 35
11 Bansander Sub 19 Bansander 30 62 70 35
12 Pontevedra Sub 19 Pontevedra 30 57 72 35
13 Veriña CF Sub 19 Veriña 30 32 49 35
14 Deportivo Roces Sub 19 Deportivo 30 30 56 32
15 CD Areosa CD Areosa 30 46 72 30
16 Cervantes Cervantes 30 40 78 28
Ver
TEMPORADA 2012/2013
Equipo PJ GF GC Puntos
1 RC Celta Sub 19 Celta 30 101 28 79
2 Real Sporting Sub 19 Real 30 71 30 61
3 Deportivo Sub 19 Deportivo 30 62 26 61
4 Real Oviedo Sub 19 Real Oviedo 30 61 47 49
5 Pabellón Ourense Sub 19 Pabellón 30 42 40 45
6 Racing Sub 19 Racing 30 54 53 45
7 CD Lugo Sub 19 Lugo 30 44 53 39
8 Atlético Perines Sub 19 Atlético 30 56 63 38
9 Veriña CF Sub 19 Veriña 30 43 57 38
10 Deportivo Roces Sub 19 Deportivo 30 37 40 36
11 RS Gimnástica Sub 19 Gimnástica 30 31 42 36
12 Pontevedra Sub 19 Pontevedra 30 44 56 36
13 CD Laredo Sub 19 Laredo 30 30 57 30
14 Montañeros Cf Juvenil Montañeros 30 24 44 26
15 Rayo Cantabria Juvenil Rayo 30 34 65 26
16 Santiago de Compostela Santiago 30 42 75 25
Ver
TEMPORADA 2011/2012
Equipo PJ GF GC Puntos
1 Real Sporting Sub 19 Real 30 92 22 69
2 RC Celta Sub 19 Celta 30 66 24 63
3 Racing Sub 19 Racing 30 74 29 62
4 Pontevedra Sub 19 Pontevedra 30 56 48 59
5 Deportivo Sub 19 Deportivo 30 65 35 53
6 Pabellón Ourense Sub 19 Pabellón 30 52 44 48
7 Atlético Perines Sub 19 Atlético 30 48 46 47
8 CD Lugo Sub 19 Lugo 30 39 53 42
9 Real Oviedo Sub 19 Real Oviedo 30 53 45 40
10 RS Gimnástica Sub 19 Gimnástica 30 35 38 38
11 Deportivo Roces Sub 19 Deportivo 30 41 52 38
12 Rayo Cantabria Juvenil Rayo 30 32 50 37
13 Puente Castro FC Sub 19 Puente 30 40 60 32
14 Bansander Sub 19 Bansander 30 31 62 19
15 Conxo Conxo 30 24 70 18
16 Racing Ferrol Sub 19 Racing 30 28 98 10
Ver
TEMPORADA 2010/2011
Equipo PJ GF GC Puntos
1 Racing Sub 19 Racing 30 64 20 70
2 RC Celta Sub 19 Celta 30 71 31 67
3 Deportivo Sub 19 Deportivo 30 75 30 64
4 Real Sporting Sub 19 Real 30 52 30 61
5 Deportivo Roces Sub 19 Deportivo 30 59 41 57
6 Atlético Perines Sub 19 Atlético 30 58 66 42
7 Pontevedra Sub 19 Pontevedra 30 33 45 38
8 Puente Castro FC Sub 19 Puente 30 45 51 36
9 Conxo Conxo 30 39 58 36
10 Bansander Sub 19 Bansander 30 37 46 33
11 Racing Ferrol Sub 19 Racing 30 46 56 33
12 RS Gimnástica Sub 19 Gimnástica 30 36 54 32
13 Montañeros Cf Juvenil Montañeros 30 33 46 30
14 CP Calasancio Calasancio 30 36 55 30
15 Rápido De Bouzas A Rápido 30 29 56 24
16 Club Alcázar Sub 19 Club 30 28 56 20

  USO DE MEMORIA  
5,428,464 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0021
Controller Execution Time ( Home / Category )  0.3431
Total Execution Time  0.3452
  CADENA URL  
/division_honor_juvenil2015/grupo1/historico
  GET DATOS  
$_GET['/division_honor_juvenil2015/grupo1/historico']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (18)  
0.0127  SELECT type FROM routes WHERE alias = 'division_honor_juvenil2015'
0.0262  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'division_honor_juvenil' AND (l.group_code = 1 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 2015 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=1 DESC LIMIT 1
0.0129  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 = 4199 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0130  SELECT id,year,current_round,total_teams,legend FROM leagues WHERE categoryId = 156 AND group_code = 1 and tables = 1 AND year <= 2015 AND total_num_tablesR >= 1 ORDER BY year DESC LIMIT 22
0.0131  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 = 4199 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0130  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 = 2709 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0128  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 = 2066 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0130  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 = 1487 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0129  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 = 1161 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0126  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-04-27 17:46:41' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0125  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=2 AND last_update > '2024-04-27 17:46:41' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0125  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=4 AND last_update > '2024-04-27 17:46:41' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0125  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=3 AND last_update > '2024-04-27 17:46:41' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0129  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'division_honor_juvenil' AND (l.group_code = 0 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 2015 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=0 DESC LIMIT 1
0.0129  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 events2015 e ON e.player_id = p.id AND e.league_id = 4199 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 4199 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.0127  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 events2015 e ON e.player_id = p.id AND e.league_id = 4199 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 4199 AND (e.action = 4 or e.action = 5) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0126  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 events2015 e ON e.player_id = p.id AND e.league_id = 4199 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 4199 AND (e.action = 3 or e.action = 4) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0137  SELECT *,(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 = 4199 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC