4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del Racing Club Villalbés
TEMPORADA 2023/2024
LIGA GALLEGA JUVENIL GRUPO 1
Equipo PJ GF GC Puntos
1 Bertamirans FC Bertamirans 30 72 23 70
2 Imperator OAR Imperator 31 79 46 64
3 Atletico Arteixo Atletico 30 71 46 61
4 Ural Español CF B Ural 31 70 41 57
5 San Tirso SD Tirso 31 60 41 57
6 Racing Club Villalbés Racing Club 31 59 48 50
7 Viveiro CF Viveiro CF 31 55 53 48
8 Racing Club Ferrol SAD B Racing Club 31 58 43 47
9 SD Compostela B Compostela 30 66 54 45
10 Xuventude Oroso Xuventude 31 52 55 45
11 Galicia de Caranza Galicia 31 67 64 43
12 CD Conxo Santiago B Conxo 31 48 58 43
13 CD Calasanz CD Calasanz 31 59 71 39
14 Olimpico CF Olimpico CF 31 49 64 34
15 Escola Estrada Fútbol Base Escola 31 56 79 30
16 SD Residencia Residencia 31 43 70 29
17 Bergantiños CF B Bergantiños 30 21 75 16
18 SD Sarriana SD Sarriana 31 22 76 12
TEMPORADA 2022/2023
LIGA GALLEGA JUVENIL GRUPO 1
Equipo PJ GF GC Puntos
1 Victoria CF Sub 19 Victoria 38 124 20 104
2 CD Boiro Sub 19 Boiro 38 116 43 93
3 Galicia de Caranza Galicia 38 93 48 77
4 Bertamirans FC Bertamirans 38 101 53 67
5 Viveiro CF Viveiro CF 38 95 73 63
6 CD Conxo Santiago B Conxo 38 78 62 60
7 Imperator OAR Imperator 38 68 54 60
8 Escola Estrada Fútbol Base Escola 38 96 62 58
9 Bergantiños CF B Bergantiños 38 61 70 57
10 San Tirso SD Tirso 38 70 68 55
11 Racing Club Villalbés Racing Club 38 62 62 51
12 Racing Club Ferrol SAD B Racing Club 38 69 87 50
13 Olimpico CF Olimpico CF 38 61 54 48
14 SD Residencia Residencia 38 69 82 48
15 Cidade de Ribeira Cidade 38 64 81 46
16 Lalín EF Sub 19 Lalín 38 74 91 42
17 SCD Milagrosa Milagrosa 38 53 77 38
18 Dumbria CF Dumbria CF 38 39 136 21
19 Ribadeo Ribadeo 38 41 124 18
20 SD O Val Sub 19 38 41 128 11
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 2020/2021
LIGA NACIONAL GRUPO 35
Equipo PJ GF GC Puntos
1 RC Deportivo Sub 19 B Deportivo 23 58 12 60
2 RC Celta Sub 19 B Celta 23 61 23 59
3 SD Compostela Sub 19 Compostela 23 68 35 49
4 Pontevedra Sub 19 Pontevedra 23 51 28 42
5 Coruxo FC Sub 19 Coruxo 23 45 32 42
6 Alondras Sub 19 Alondras 23 38 42 36
7 CD Areosa CD Areosa 23 54 51 34
8 ED Val Miñor Nigrán B Miñor 23 46 46 31
9 Arosa SC Sub 19 Arosa 23 40 41 29
10 Racing Club Villalbés Racing Club 23 31 41 27
TEMPORADA 2019/2020
LIGA NACIONAL GRUPO 1
Equipo PJ GF GC Puntos
1 RC Celta Sub 19 B Celta 23 79 16 61
2 RC Deportivo Sub 19 B Deportivo 23 64 29 49
3 Choco Sub 19 Choco 23 45 21 46
4 Pabellón Ourense Sub 19 Pabellón 23 43 27 46
5 CD Areosa CD Areosa 23 51 31 43
6 Rápido De Bouzas A Rápido 23 40 28 40
7 Pontevedra Sub 19 Pontevedra 23 45 41 37
8 Ourense CF Sub 19 Ourense 22 43 31 33
9 Lugo Sub 19 B Lugo 23 32 39 33
10 Alondras Sub 19 Alondras 23 31 36 31
11 Victoria CF Sub 19 Victoria 23 39 39 29
12 Valladares Sub 19 Valladares 24 32 55 25
13 ED Val Miñor Nigrán B Miñor 23 27 45 22
14 UD Ourense Sub 19 Ourense 23 30 49 21
15 Racing Club Villalbés Racing Club 22 31 49 19
16 Lalín EF Sub 19 Lalín 24 23 56 18
17 SD O Val Sub 19 23 25 61 16
18 Porriño Industrial Sub 19 Porriño 23 20 47 12
TEMPORADA 2018/2019
LIGA NACIONAL GRUPO 1
Equipo PJ GF GC Puntos
1 RC Celta Sub 19 B Celta 34 111 30 83
2 CD Calasanz CD Calasanz 34 63 36 71
3 CD Conxo Sub 19 Conxo 34 81 53 68
4 RC Deportivo Sub 19 B Deportivo 34 80 36 64
5 Victoria CF Sub 19 Victoria 34 78 55 60
6 Pabellón Ourense Sub 19 Pabellón 34 64 40 58
7 Porriño Industrial Sub 19 Porriño 34 75 71 56
8 Choco Sub 19 Choco 34 60 47 49
9 CD Areosa CD Areosa 34 51 51 49
10 Rápido De Bouzas A Rápido 34 46 46 46
11 Racing Club Villalbés Racing Club 34 48 56 46
12 Lugo Sub 19 B Lugo 34 66 68 44
13 ED Val Miñor Nigrán B Miñor 34 45 71 36
14 Valladares Sub 19 Valladares 34 50 86 35
15 UD Santa Mariña Santa 34 34 56 34
16 Arosa SC Sub 19 Arosa 34 41 63 30
17 Orillamar SD Orillamar 34 35 106 20
18 Cd Lérez Cd Lérez 34 42 99 16
TEMPORADA 2017/2018
DIVISIÓN DE HONOR GRUPO 1
Equipo PJ GF GC Puntos
1 Real Sporting Sub 19 Real 30 77 27 70
2 Deportivo Sub 19 Deportivo 30 83 22 68
3 RC Celta Sub 19 Celta 30 70 33 65
4 Racing Sub 19 Racing 30 66 37 59
5 Real Oviedo Sub 19 Real Oviedo 30 56 33 54
6 Deportivo Roces Sub 19 Deportivo 30 50 45 46
7 Bansander Sub 19 Bansander 30 59 58 44
8 Pontevedra Sub 19 Pontevedra 30 44 38 44
9 CD Lugo Sub 19 Lugo 30 34 46 40
10 Atlético Perines Sub 19 Atlético 30 32 45 38
11 ED Val Miñor Sub 19 Miñor 30 44 64 30
12 Alondras Sub 19 Alondras 30 38 61 27
13 CD Areosa CD Areosa 30 37 76 25
14 SD Llano 2000 Llano 2000 30 33 59 23
15 Santiago de Compostela Santiago 30 31 65 18
16 Racing Club Villalbés Racing Club 30 29 74 16
TEMPORADA 2015/2016
LIGA GALLEGA JUVENIL GRUPO 1
Equipo PJ GF GC Puntos
1 Conxo Conxo 34 71 26 76
2 Racing Club Villalbés Racing Club 34 78 40 71
3 Dumbria CF Dumbria CF 34 75 47 60
4 CD Boiro Sub 19 Boiro 34 83 63 59
5 Montañeros BG Montañeros 34 69 50 59
6 Victoria B Victoria B 34 66 51 55
7 Orillamar SD Orillamar 34 53 48 52
8 Viveiro CF Viveiro CF 34 82 65 51
9 SD O Val Sub 19 34 61 59 50
10 Lalín EF Sub 19 Lalín 33 51 44 49
11 Xuventude Osoro Xuventude 34 59 71 47
12 Bergantiños Sub 19 Bergantiños 34 57 50 45
13 CD Union CD Union 34 52 71 42
14 Cerceda CCD Cerceda CCD 34 61 56 41
15 SD Residencia Residencia 34 52 70 35
16 Estrada SP Estrada SP 34 42 75 27
17 Imperator OAR Imperator 33 59 121 21
18 Órdenes Sd Órdenes Sd 34 32 96 15
TEMPORADA 2014/2015
LIGA GALLEGA JUVENIL GRUPO 1
Equipo PJ GF GC Puntos
1 Ural CF Sub 19 Ural 34 77 36 69
2 Lugo Sub 19 B Lugo 34 73 30 68
3 Racing Club Villalbés Racing Club 34 66 38 64
4 Lalín EF Sub 19 Lalín 34 55 28 63
5 CD Boiro Sub 19 Boiro 34 77 46 58
6 Victoria CF Juvenil Victoria 34 58 46 58
7 Conxo Conxo 34 62 55 54
8 Xuventude Osoro Xuventude 34 66 57 48
9 Orillamar SD Orillamar 34 46 37 48
10 Estrada SP Estrada SP 34 36 31 48
11 Órdenes Sd Órdenes Sd 34 42 49 46
12 SD O Val Sub 19 34 55 56 45
13 Montañeros Cf Juvenil Montañeros 34 45 57 42
14 Imperator OAR Imperator 34 44 61 40
15 Milagrosa SCD Milagrosa 34 41 50 39
16 Galicia de Caranza B Galicia 34 37 98 23
17 Val do Ulla Ribadul Ulla Ribadul 34 33 75 21
18 Negreira SD Negreira SD 34 36 99 20

  USO DE MEMORIA  
5,785,888 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0012
Controller Execution Time ( Home / Category )  0.5112
Total Execution Time  0.5125
  CADENA URL  
/historico/Villalbes-Rc-Juvenil
  GET DATOS  
$_GET['/historico/Villalbes-Rc-Juvenil']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (26)  
0.0156  SELECT dt.*,c.active_year,l.year,l.table_suffix, c.ctype, l.id as league_id,t.id as id,t.manager,t.name as nameOriginal,dt.id as teamId,cou.Name as cou_name,cou.Continent,cou.Region FROM `leagues_webci` as l INNER JOIN `teams` as t ON l.id = t.league_id INNER JOIN `datateams` as dt ON dt.id = t.teamId INNER JOIN `categories_webci` as c ON c.id = l.categoryId LEFT JOIN country cou ON LOWER(cou.Code2) = dt.CountryCode WHERE dt.basealias = 'Villalbes-Rc-Juvenil' AND l.year = 2024 ORDER BY c.top DESC, c.ctype != 12 DESC, c.troncal DESC, l.end_date >= NOW() DESC, l.start_date <= NOW() DESC, l.year DESC, c.coefficient DESC, l.id ASC
0.0146  SELECT dp.nick, dp.fullname,rp.date_ini, rp.date_end FROM futbol.rel_people rp INNER JOIN futbol.datapeople dp on dp.id=rp.people_id WHERE rp.teamId=27702 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0145  SELECT dp.nick, dp.fullname,rp.date_ini, rp.date_end FROM futbol.rel_people rp INNER JOIN futbol.datapeople dp on dp.id=rp.people_id WHERE rp.teamId=27702 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0295  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.0145  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=27702 AND type_rel = 2
0.0145  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=788 AND type_rel = 3
0.0148  SELECT cat.logo,cat.official,cat.location,dt.nameShow,dt.basealias,t.teamId,l.year,t.qod,cat.coefficient,cat.active_year,cat.name,l.group_code,l.total_group,cat.alias,l.categoryId,l.year,l.id as league_id FROM datateams dt INNER JOIN teams t ON t.teamId = dt.id INNER JOIN leagues l ON l.id = t.league_id INNER JOIN categories cat ON cat.id = l.categoryId WHERE dt.id = '27702' ORDER BY l.year DESC,cat.coefficient DESC
0.0147  SELECT cat.logo,cat.official,cat.location,dt.nameShow,dt.basealias,t.teamId,l.year,t.qod,cat.coefficient,cat.active_year,cat.name,l.group_code,l.total_group,cat.alias,l.categoryId,l.year,l.id as league_id FROM datateams dt INNER JOIN teams t ON t.teamId = dt.id INNER JOIN leagues l ON l.id = t.league_id INNER JOIN categories cat ON cat.id = l.categoryId WHERE dt.id = '27702' AND l.year = 2024 ORDER BY l.year DESC,cat.coefficient DESC
0.0147  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 = '27702' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0146  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.0147  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=27702 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0145  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) 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.0145  SELECT count(id) as num_players from rel_players_base WHERE league_id = 74569 AND teamId = 27702
0.0147  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 = '27702' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0145  SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '27702' and rp.type = 4
0.0146  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 = '27702' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0149  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 = 27702 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.0149  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 = 31 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0152  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_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 = 68971 AND t.round = 38 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0151  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.0148  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.0148  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 = 61830 AND t.round = 5 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0150  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_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 = 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.0150  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_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 = 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.0154  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_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 = 17012 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0155  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 = 5023 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC