4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del Pabellón Ourense Sub 19 B
TEMPORADA 2023/2024
LIGA NACIONAL GRUPO 1
Equipo PJ GF GC Puntos
1 RC Deportivo Sub 19 B Deportivo 30 113 19 78
2 RC Celta Sub 19 B Celta 30 91 23 75
3 Coruña Montañeros Sub 19 Coruña 30 64 38 61
4 Racing Ferrol Sub 19 Racing 30 59 39 50
5 Ural CF Sub 19 Ural 30 56 50 50
6 Pontevedra Sub 19 Pontevedra 30 52 39 49
7 CD Conxo Sub 19 Conxo 30 61 46 48
8 Coruxo B Sub 19 Coruxo 30 53 62 40
9 AJ Lerez Sub 19 Lerez 30 43 54 39
10 Alondras Sub 19 Alondras 30 35 36 35
11 Lugo Sub 19 B Lugo 30 42 53 35
12 UD Ourense Sub 19 Ourense 30 44 65 35
13 Victoria CF Sub 19 Victoria 30 51 67 32
14 Pabellón Ourense Sub 19 B Pabellón 30 31 44 31
15 Porriño Industrial Sub 19 Porriño 30 36 62 30
16 Bergantiños Sub 19 Bergantiños 30 38 63 27
17 Valladares Sub 19 Valladares 30 36 67 22
18 CD Boiro Sub 19 Boiro 30 22 100 15
TEMPORADA 2022/2023
LIGA NACIONAL GRUPO 1
Equipo PJ GF GC Puntos
1 RC Deportivo Sub 19 B Deportivo 34 94 27 78
2 RC Celta Sub 19 B Celta 34 77 29 76
3 ED Val Miñor Sub 19 Miñor 34 66 32 70
4 Choco Sub 19 Choco 34 79 44 69
5 Pontevedra Sub 19 Pontevedra 34 73 43 68
6 Pabellón Ourense Sub 19 B Pabellón 34 70 52 58
7 Valladares Sub 19 Valladares 34 60 49 51
8 Coruña Montañeros Sub 19 Coruña 34 49 41 49
9 UD Ourense Sub 19 Ourense 34 42 47 44
10 Bergantiños Sub 19 Bergantiños 34 41 57 44
11 Lugo Sub 19 B Lugo 34 37 55 43
12 Racing Ferrol Sub 19 Racing 34 50 62 41
13 Alondras Sub 19 Alondras 34 42 72 40
14 CD Conxo Sub 19 Conxo 34 36 65 36
15 Porriño Industrial Sub 19 Porriño 34 44 50 35
16 Xuventude Oroso Xuventude 34 42 64 30
17 Ural Español CF B Ural 34 36 72 25
18 CD Calasanz CD Calasanz 34 27 104 9
TEMPORADA 2021/2022
LIGA NACIONAL GRUPO 1
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
TEMPORADA 2014/2015
LIGA NACIONAL GRUPO 1
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

  USO DE MEMORIA  
5,280,368 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0012
Controller Execution Time ( Home / Category )  0.0698
Total Execution Time  0.0710
  CADENA URL  
/historico/Ourense-Juvenil
  GET DATOS  
$_GET['/historico/Ourense-Juvenil']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (16)  
0.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=12090 AND type_rel = 2
0.0021  SELECT SQL_NO_CACHE res.id as id, res.group_code, res.total_group, res.logo, res.alias FROM (SELECT ct.active_year, ct.id as id, l.year, l.end,l.group_code, l.total_group, ct.logo, ct.alias FROM categories AS ct INNER JOIN leagues AS l ON ct.id=l.categoryId AND ct.active_year=l.year INNER JOIN teams AS t ON l.id=t.league_id WHERE t.teamId = '12090' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0023  SELECT t.id as team_id, ct.id, l.id as idLeague, l.year, ct.name, l.start_date, l.end_date FROM categories AS ct INNER JOIN leagues AS l ON ct.id=l.categoryId INNER JOIN teams AS t ON l.id=t.league_id WHERE t.teamId=12090 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0018  SELECT ct.id, ct.alias, ct.name AS name, ct.active_year, ct.coefficient AS coefficient, l.id AS league_id, l.year, l.total_group FROM categories AS ct INNER JOIN leagues AS l ON ct.id=l.categoryId WHERE l.id IN (73378) ORDER BY ct.ctype != 12 DESC, ct.troncal DESC, ct.coefficient DESC, l.end_date >= NOW() DESC, l.start_date <= NOW() DESC, l.year DESC, ct.coefficient DESC, l.group_code ASC
0.0021  SELECT count(id) as num_players from rel_players WHERE league_id = 73378 AND teamId = 12090
0.0020  SELECT p.* FROM `rel_pictures` as rp INNER JOIN `pictures` as p ON p.id = rp.id_picture INNER JOIN fa_user u ON u.id = p.author_id WHERE rp.id_content = '12090' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0018  SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '12090' and rp.type = 4
0.0021  SELECT p.* FROM `rel_videos` as rp INNER JOIN `videos` as p ON p.id = rp.id_video INNER JOIN fa_user u ON u.id = p.author_id WHERE rp.id_content = '12090' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0032  SELECT e.action,rp.player_id, count(e.action) as total, p.nick,p.name,p.last_name,p.alias,rp.team_id 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 = 73378 WHERE rp.league_id = 73378 AND rp.teamId = 12090 AND (e.action = 1 or e.action = 2 or e.action = 11 or e.action = 12 or e.action = 13) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0035  SELECT e.action,rp.player_id, count(e.action) as total, p.nick,p.name,p.last_name,p.alias,rp.team_id 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 = 73378 WHERE rp.league_id = 73378 AND rp.teamId = 12090 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0035  SELECT e.action,rp.player_id, count(e.action) as total, p.nick,p.name,p.last_name,p.alias,rp.team_id 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 = 73378 WHERE rp.league_id = 73378 AND rp.teamId = 12090 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0025  SELECT l.id,t.league_id,l.legend,l.year,c.name,l.total_teams,c.alias,l.group_code,l.total_group,l.current_round, l.table_suffix FROM teams t INNER JOIN leagues l ON t.league_id = l.id INNER JOIN categories c ON c.id = l.categoryId WHERE c.troncal = 1 AND t.teamId = 12090 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.0048  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 = 73378 AND t.round = 30 ORDER BY team.conference ASC,t.position 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 `tables2023` 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 = 68406 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.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 `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.0039  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