4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
24 jugadores
RC Celta Sub 19 RC Celta Sub 19
Nacho Nacho 24 años POR
Ruly Ruly 24 años 188cm 83kg POR
Guimera Guimera 22 años DEF
Iván Revuelta Iván Revuelta 23 años DEF
Sergio Barcia Sergio Barcia 23 años 186cm 82kg DEF
Javier Hermelo Javier Hermelo 23 años DEF
J. Fontán J. Fontán 24 años 182cm DEF
Sergio Carreira Sergio Carreira 23 años 170cm 65kg DEF
Álvaro Ramón Álvaro Ramón 24 años 170cm DEF
M. García M. García 24 años DEF
José Fontán José Fontán 24 años 182cm 76kg DEF
Miguel Miguel 24 años MED
Martín Crespo Martín Crespo 23 años MED
Aldán Aldán 23 años MED
Álvarez Álvarez 23 años MED
Tiago Rodríguez Tiago Rodríguez 23 años 180cm 72kg MED
Santi Santi 23 años MED
Willy Willy 24 años 179cm MED
Alberto Alberto 23 años MED
Iker Losada Iker Losada 22 años 175cm 70kg DEL
Martín Diz Martín Diz 23 años 178cm DEL
Óscar Gil Óscar Gil 23 años DEL
Lautaro De León Lautaro De León 23 años 185cm 80kg DEL
Z. Labyad Z. Labyad 24 años 180cm 74kg DEL

Clasificación

Equipo PJ GF GC Puntos
1 RC Celta Sub 19 Celta 30 78 24 80
2 Real Sporting Sub 19 Real 30 92 22 72
3 Racing Sub 19 Racing 30 75 29 65
4 Ural CF Sub 19 Ural 30 57 50 54
5 Deportivo Sub 19 Deportivo 30 63 34 53
6 CD Lugo Sub 19 Lugo 30 52 37 50
7 Real Oviedo Sub 19 Real Oviedo 30 45 26 49
8 Bansander Sub 19 Bansander 30 45 58 37
9 Atlético Perines Sub 19 Atlético 30 46 59 36
10 Racing Ferrol Sub 19 Racing 30 40 55 35
11 ED Val Miñor Sub 19 Miñor 30 36 46 33
12 Deportivo Roces Sub 19 Deportivo 30 44 66 33
13 Pontevedra Sub 19 Pontevedra 30 35 62 29
14 CD Covadonga Sub 19 Covadonga 30 30 62 23
15 CD Colindres Sub 19 Colindres 30 23 75 18
16 Alondras Sub 19 Alondras 30 20 76 13

  USO DE MEMORIA  
4,918,984 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0034
Controller Execution Time ( Home / Category )  0.2883
Total Execution Time  0.2917
  CADENA URL  
/division_honor_juvenil2019/grupo1/jugadores
  GET DATOS  
$_GET['/division_honor_juvenil2019/grupo1/jugadores']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (14)  
0.0126  SELECT type FROM routes WHERE alias = 'division_honor_juvenil2019'
0.0265  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 = 2019 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=1 DESC LIMIT 1
0.0136  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 = 44576 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0135  SELECT dt.id FROM teams t INNER JOIN datateams dt ON t.teamId = dt.id WHERE t.league_id = 44576 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 36
0.0150  SELECT dp.nick,dp.alias,dp.role,p.id,p.teamId,dp.height,dp.weight,p.team_id,p.player_id,p.squadNumber,dp.CountryCode,dp.age FROM rel_players p INNER JOIN dataplayers dp ON dp.id = p.player_id INNER JOIN datateams dt ON dt.id = p.teamId WHERE p.league_id = 44576 AND dt.id IN (3265,4836,3495,4826,4960,4954,4831,4825,4932,4828,4943,4830,4829,4938,12269,12107) ORDER BY dt.relations DESC,dp.role ASC
0.0127  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-05-01 13:04:48' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0126  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=2 AND last_update > '2024-05-01 13:04:48' 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-05-01 13:04:48' 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-05-01 13:04:48' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0130  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 = 2019 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=0 DESC LIMIT 1
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 events2019 e ON e.player_id = p.id AND e.league_id = 44576 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 44576 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.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 events2019 e ON e.player_id = p.id AND e.league_id = 44576 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 44576 AND (e.action = 4 or e.action = 5) 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 events2019 e ON e.player_id = p.id AND e.league_id = 44576 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 44576 AND (e.action = 3 or e.action = 4) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0140  SELECT *,(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 = 44576 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC