4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del Fundacio E Atletic Vilafran
TEMPORADA 2022/2023
1ª CATALANA JUVENIL GRUPO 1
Equipo PJ GF GC Puntos
1 Can Vidalet B B Vidalet 29 114 37 74
2 San Mauro A San Mauro A 29 79 34 68
3 Escola F Gava C B Escola Gava 30 78 41 58
4 Igualada CF B Igualada 30 79 55 57
5 Vinyets Moli-Vell A Vinyets 27 60 42 48
6 Riudebitlles CD A Riudebitlles 30 76 60 48
7 Corbera A Corbera A 29 72 67 40
8 Sitges UE A Sitges UE A 29 52 58 40
9 Levante Las Planas FC A Levante 30 60 72 39
10 Fundacio E Atletic Vilafran Fundacio 29 56 48 38
11 Ribes CD A Ribes CD A 29 59 64 34
12 Vista Alegre A Vista Alegre 30 49 73 25
13 Pª Barc Sant Vicenç Horts A Barc Sant V. 30 39 79 25
14 Base Marc Bartra A Base Marc B. 29 43 89 23
15 Terlenka Barcelonista Club Terlenka 30 41 93 22
16 Castelldefels B Castelldefel 30 43 88 20
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
PREFERENTE CATALANA JUVENIL GRUPO 3
Equipo PJ GF GC Puntos
1 Granollers Sub 19 B Granollers 3 7 2 9
2 Manresa B B Manresa B B 3 11 7 7
3 Cervera A Cervera A 3 6 6 6
4 Gimnastic Manresa Sub 19 B Gimnastic 3 5 4 5
5 Europa Sub 19 B Europa 3 9 6 4
6 Segre A A Segre A A 3 7 5 4
7 Sant Cugat Futbol Club A Sant Cugat. 3 6 4 4
8 Lleida Esportiu Terraferma Lleida 3 7 6 4
9 Sallent A Sallent A 3 5 7 4
10 Escola Ftarrega Sub 19 Escola 3 1 3 4
11 Mollet B Mollet B 3 7 8 3
12 AEM Sub 19 AEM Sub 19 3 4 8 3
13 Bordeta De Lleida Bordeta 3 3 4 2
14 Fundacio E Atletic Vilafran Fundacio 3 5 8 2
15 Mercantil B B Mercantil 3 4 7 2
16 Piera A Piera A 3 6 8 1
TEMPORADA 2019/2020
PREFERENTE CATALANA JUVENIL GRUPO 3
Equipo PJ GF GC Puntos
1 Jabac I Terrassa Sub 19 B Jabac 19 41 21 41
2 Mercantil B B Mercantil 19 51 27 40
3 Gimnastic Manresa Sub 19 B Gimnastic 19 49 24 39
4 Salar Club Futbol Salar Club. 18 38 29 36
5 Granollers Sub 19 B Granollers 19 38 21 35
6 Cervera A Cervera A 19 38 30 31
7 Bordeta De Lleida Bordeta 19 29 34 26
8 Sallent A Sallent A 19 22 30 24
9 Fundacio E Atletic Vilafran Fundacio 19 41 61 24
10 Europa Sub 19 B Europa 19 21 27 23
11 AEM Sub 19 AEM Sub 19 19 26 31 22
12 Escola Ftarrega Sub 19 Escola 19 20 22 19
13 Lleida Esportiu Terraferma Lleida 19 38 44 18
14 Segre A A Segre A A 19 33 42 17
15 Manresa B B Manresa B B 19 16 29 15
16 Piera A Piera A 18 22 51 8

  USO DE MEMORIA  
4,961,552 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0016
Controller Execution Time ( Home / Category )  0.0797
Total Execution Time  0.0813
  CADENA URL  
/historico/Fundacio-E-Atletic-Vilafranca-A-A-Juvenil
  GET DATOS  
$_GET['/historico/Fundacio-E-Atletic-Vilafranca-A-A-Juvenil']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (17)  
0.0049  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 = 69731
0.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=90975 AND type_rel = 2
0.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=721 AND type_rel = 3
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 = '90975' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0020  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 = 69731 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0021  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=90975 AND l.year in (2022,2023,2024) 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 (69731) 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.0018  SELECT count(id) as num_players from rel_players_base WHERE league_id = 69731 AND teamId = 90975
0.0019  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff 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 = 69731 AND t.round = 30 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0019  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 = '90975' 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 = '90975' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0020  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 = 90975 AND l.year <= 2023 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
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 `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 = 69731 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.0029  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.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 `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 = 59228 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.0082  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 = 52270 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.0020  SELECT dt.nameShow, dt.basealias, t.id, dt.id as dt_id FROM `teams` as t INNER JOIN `datateams` as dt ON dt.id = t.teamId WHERE league_id = 69731 ORDER BY nameShow LIMIT 100