4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del Vilanova Geltru CF A
TEMPORADA 2022/2023
PREFERENTE CATALANA JUVENIL GRUPO 1
Equipo PJ GF GC Puntos
1 F. Base Reus Sub 19 Base Reus 30 66 33 65
2 At. Segre Sub 19 Segre 28 74 35 61
3 Ue Castelldefels Sub 19 Castelldefel 30 69 44 54
4 Cambrils Unió Sub 19 Cambrils 30 71 63 54
5 EFB Calafell Sub 19 Calafell 28 61 42 53
6 Cornella Sub 19 C Cornella 30 62 40 49
7 Nàstic Tarragona Sub 19 B Nàstic 30 54 35 49
8 Santboia Sub 19 Santboia 30 66 62 46
9 Vilanova Geltru CF A Vilanova 28 57 59 40
10 Manresa Sub 19 Manresa 30 55 69 35
11 Blanca Subur Sub 19 Blanca Subur 29 60 72 34
12 La Floresta Sub 19 Floresta 29 44 59 34
13 Marianao Poblet Sub 19 Marianao 29 36 47 33
14 Escuela Fsan Pedro San Pabl Escuela Fsan 29 37 61 22
15 Escola Valls A Escola Valls 30 41 73 18
16 Ulldecona A Ulldecona A 30 29 88 15
TEMPORADA 2021/2022
1ª CATALANA JUVENIL GRUPO 1
Equipo PJ GF GC Puntos
1 Vilanova Geltru CF A Vilanova 30 87 21 77
2 Can Buxeres B Buxeres 30 85 35 66
3 Castelldefels C Castelldefel 30 77 44 62
4 Sitges UE A Sitges UE A 28 68 41 52
5 Escola F Gava C B Escola Gava 27 59 49 48
6 Corbera A Corbera A 29 69 52 44
7 Fundacio E Atletic Vilafran Fundacio 26 62 52 41
8 San Mauro A San Mauro A 29 68 62 41
9 Sant Cugat Sesgarrigues Clu Sant Cugat. 28 61 65 39
10 Sant Vicenç Dels Horts Sant Vicenç 29 50 64 37
11 Base Marc Bartra A Base Marc B. 29 60 90 31
12 Ciudad Cooperativa A A Ciudad 29 61 88 27
13 Ribes A Ribes A 28 40 75 27
14 Sporting Gava 2013 Futbol A Sporting 28 41 59 24
15 Martorell B Martorell B 27 36 69 20
16 Arrabal Calaf Gramanet B Arrabal 27 50 108 14
TEMPORADA 2020/2021
1ª CATALANA JUVENIL GRUPO 1
Equipo PJ GF GC Puntos
1 Blanca Subur Sub 19 Blanca Subur 1 6 1 3
2 Santboia FC A Santboia 1 4 0 3
3 Base Marc Bartra A Base Marc B. 1 4 1 3
4 Corbera A Corbera A 1 3 0 3
5 San Mauro A San Mauro A 1 6 4 3
6 Escola F Gava C B Escola Gava 1 2 0 3
7 Anoia CE A Anoia CE A 1 1 0 3
8 Gelida CF A Gelida CF A 0 0 0 0
9 Igualada Sub 19 Igualada 0 0 0 0
10 Ribes A Ribes A 1 0 1 0
11 Cubelles CF A Cubelles 1 4 6 0
12 Vilanova Geltru CF A Vilanova 1 0 2 0
13 Fundacio E Atletic Vilafran Fundacio 1 1 4 0
14 Sitges UE A Sitges UE A 1 0 3 0
15 Martorell CF B Martorell 1 0 4 0
16 Sant Vicenç Dels Horts Sant Vicenç 1 1 6 0
TEMPORADA 2019/2020
1ª CATALANA JUVENIL GRUPO 1
Equipo PJ GF GC Puntos
1 Marianao Poblet UD A Marianao 17 61 19 49
2 Santboia FC A Santboia 18 38 20 42
3 Escola F Gava C B Escola Gava 17 39 18 34
4 San Mauro A San Mauro A 18 44 35 34
5 Sant Vicenç Dels Horts Sant Vicenç 17 46 44 27
6 Sitges UE A Sitges UE A 15 34 26 26
7 Cubelles CF A Cubelles 17 35 33 23
8 Anoia CE A Anoia CE A 17 36 36 23
9 Vilanova Geltru CF A Vilanova 18 39 46 23
10 Igualada Sub 19 Igualada 18 27 32 22
11 Ribes A Ribes A 17 27 31 20
12 Blanca Subur CF A Blanca Subur 18 22 27 20
13 Base Marc Bartra A Base Marc B. 16 20 26 16
14 Martorell CF B Martorell 17 31 41 16
15 Gelida CF A Gelida CF A 17 21 53 11
16 Fundacio E Atletic Vilafran Fundacio 17 17 50 7

  USO DE MEMORIA  
4,895,384 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0012
Controller Execution Time ( Home / Category )  0.0837
Total Execution Time  0.0850
  CADENA URL  
/historico/Vilanova-Geltru-Cf-A-Juvenil
  GET DATOS  
$_GET['/historico/Vilanova-Geltru-Cf-A-Juvenil']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (28)  
0.0022  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 = 'Vilanova-Geltru-Cf-A-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.0026  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 = 'Vilanova-Geltru-Cf-A-Juvenil' 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.0018  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=130039 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0018  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=130039 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0018  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=130039 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0018  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=130039 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0018  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=130039 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0040  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 = 68620
0.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=130039 AND type_rel = 2
0.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=720 AND type_rel = 3
0.0021  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 3 AND rel.typeId = 720 AND rel.ln = 'es' AND rel.status=1 ORDER BY rel.creation_date desc,rel.cover_points DESC LIMIT 5
0.0021  SELECT /*53 bs_news_model*/ n.id, n.author_id, n.headline, n.external_headline, n.live_headline, n.creation_date, n.update_date, n.pub_date, n.alias, n.subheadline, n.teaser, n.media, n.tags, n.views, n.screens, n.clicks, n.relations, n.comments, n.power_cover, n.cover_points, u.name as user_name FROM bs_news n INNER JOIN bs_editors u ON u.id = n.author_id AND u.ln = 'es' WHERE n.status = 1 AND n.ln = 'es' AND n.id IN (845729,198173) ORDER BY n.cover_points DESC, update_date DESC
0.0021  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 = '130039' ORDER BY l.year DESC,cat.coefficient DESC
0.0021  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 = '130039' AND l.year = 2023 ORDER BY l.year DESC,cat.coefficient DESC
0.0020  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 = '130039' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0020  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 = '130039' AND ct.ctype=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0021  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 = 68620 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
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=130039 AND l.year in (2022,2023,2024) ORDER BY l.id DESC, l.year DESC ;
0.0019  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 (68620,64549) 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.0019  SELECT count(id) as num_players from rel_players_base WHERE league_id = 68620 AND teamId = 130039
0.0018  SELECT count(id) as num_players from rel_players_base WHERE league_id = 64549 AND teamId = 130039
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 = '130039' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0020  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 = '130039' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0022  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 = 130039 AND l.year <= 2023 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.0024  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 = 68620 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.0023  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_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 = 64549 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.0021  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_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 = 59231 AND t.round = 6 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 `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 = 54270 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