4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del Ural Español CF B
TEMPORADA 2023/2024
LIGA GALLEGA JUVENIL GRUPO 1
Equipo PJ GF GC Puntos
1 Atletico Arteixo Atletico 10 30 15 28
2 Bertamirans FC Bertamirans 10 25 10 25
3 Viveiro CF Viveiro CF 10 24 9 22
4 Racing Club Villalbés Racing Club 11 20 11 22
5 Imperator OAR Imperator 10 26 13 19
6 Racing Club Ferrol SAD B Racing Club 10 24 17 18
7 Galicia de Caranza Galicia 10 28 24 16
8 Ural Español CF B Ural 9 21 14 15
9 SD Compostela B Compostela 10 20 20 14
10 San Tirso SD Tirso 10 12 12 13
11 CD Calasanz CD Calasanz 10 22 25 11
12 Xuventude Oroso Xuventude 10 22 25 11
13 Olimpico CF Olimpico CF 10 13 23 10
14 SD Sarriana SD Sarriana 10 11 17 8
15 SD Residencia Residencia 11 15 25 8
16 CD Conxo Santiago B Conxo 9 9 22 8
17 Bergantiños CF B Bergantiños 11 10 32 7
18 Escola Estrada Fútbol Base Escola 9 11 29 4
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

  USO DE MEMORIA  
4,867,832 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0011
Controller Execution Time ( Home / Category )  0.3289
Total Execution Time  0.3300
  CADENA URL  
/historico/Ural-Sub-19-B
  GET DATOS  
$_GET['/historico/Ural-Sub-19-B']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (17)  
0.0259  SELECT c.*, l.*, cou.name as namec, ct.table_sufix FROM (leagues l INNER JOIN categories c ON c.id = l.categoryId INNER JOIN categories_types ct ON c.ctype=ct.id LEFT JOIN country cou ON cou.Code2 = c.CountryCode) WHERE l.id = 74569
0.0128  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=143682 AND type_rel = 2
0.0127  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=788 AND type_rel = 3
0.0135  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 = '143682' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0130  SELECT t.id,t.teamId,t.total_players,dt.nameShow,dt.basealias FROM teams t INNER JOIN datateams dt ON t.teamId = dt.id WHERE t.league_id = 74569 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0128  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=143682 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0126  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 (74569,68406) 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.0126  SELECT count(id) as num_players from rel_players_base WHERE league_id = 74569 AND teamId = 143682
0.0127  SELECT count(id) as num_players from rel_players_base WHERE league_id = 68406 AND teamId = 143682
0.0133  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff 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 = 74569 AND t.round = 32 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0137  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 = '143682' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0131  SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '143682' and rp.type = 4
0.0139  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 = '143682' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0139  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 = 143682 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.0153  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_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 = 74569 AND t.round = 32 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0132  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.0132  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