4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del Cal Aguido B
TEMPORADA 2022/2023
2ª CATALANA CADETE GRUPO 1
Equipo PJ GF GC Puntos
1 Juventus Lloret Futbol Club Juventus 29 156 22 82
2 Malgrat CD A Malgrat 28 159 13 77
3 Blanc Blava Lloret A Blanc Blava 27 84 30 63
4 Sant Hilari-Font Vella CE A Sant 27 100 49 57
5 Lloret CF B Lloret CF B 30 113 51 53
6 Hostalric At.C A Hostalric 30 89 63 51
7 Atletic Club Lloret A Atletic Club 29 90 66 50
8 Sils La Selva Club Futbol A Sils Selva. 30 87 74 47
9 Breda UE A Breda UE A 29 57 54 46
10 Escola Futbol Arbucienca A Escola 29 80 49 44
11 Cal Aguido B Aguido 27 48 89 30
12 Racing Blanenc A Racing 30 57 99 27
13 Palafolls CD A Palafolls 26 32 108 19
14 Olimpic Malgrat B Olimpic 28 44 119 18
15 Blanes B Blanes B 28 17 133 6
16 Cuatro Vientos A Cuatro 27 11 205 0
TEMPORADA 2021/2022
2ª CATALANA CADETE GRUPO 1
Equipo PJ GF GC Puntos
1 Olimpic Malgrat CE A Olimpic 24 154 19 65
2 Malgrat CD A Malgrat 25 142 22 64
3 Sant Hilari-Font Vella CE A Sant 26 113 45 60
4 Breda UE A Breda UE A 27 88 42 56
5 Cal Aguido B Aguido 25 104 35 54
6 Tossa Unio Esportiva A Tossa Unio. 26 77 42 48
7 Escola Futbol Arbucienca A Escola 26 87 41 46
8 Lloret CF B Lloret CF B 26 72 83 35
9 Palafolls CD A Palafolls 27 56 105 26
10 Farners A Farners A 27 60 77 24
11 Hostalric At.C A Hostalric 25 41 96 23
12 Blanes B Blanes B 25 31 78 20
13 Racing Blanenc B Racing 24 32 77 16
14 Tordera CF B Tordera 25 38 129 10
15 Athletic Club Riells A Athletic 22 12 216 0
TEMPORADA 2019/2020
1ª CATALANA CADETE GRUPO 17
Equipo PJ GF GC Puntos
1 Fundacio UniÒ Esportiva Olo Fundacio 19 102 11 55
2 Peralada Sub 16 Peralada 19 80 21 46
3 L'Escala A L'Escala A 18 82 38 39
4 Figueres A A Figueres 18 47 30 34
5 Llagostera B Llagostera 18 44 36 31
6 Fundacio Privada Esp Begur Fundacio 19 55 34 30
7 Banyoles A A Banyoles 17 47 27 28
8 Sant Gregori A Sant Gregori 18 31 33 26
9 Santjoanenc A A Santjoanenc 19 34 40 22
10 Escola Futbol del Ripolles Escola 18 43 47 21
11 Santa Eugenia Club Futbol Santa 18 38 52 21
12 Bisbalenc A Bisbalenc A 18 36 48 16
13 Escola Bosc de Tosca A Escola Bosc 18 19 43 13
14 Blanes B Blanes B 18 21 87 11
15 Escola Baix Ter A Escola Baix 19 23 66 10
16 Cal Aguido B Aguido 18 22 111 10
TEMPORADA 2018/2019
2ª CATALANA CADETE GRUPO 1
Equipo PJ GF GC Puntos
1 Cal Aguido B Aguido 26 192 21 76
2 Sporting Vidrerenca Cef A Sporting 25 203 23 64
3 Sant Celoni B Sant Celoni 25 129 41 61
4 Tossa Unio Esportiva A Tossa Unio. 25 85 25 55
5 Juve Lloret Futbol Club A Juve Lloret 21 135 30 48
6 Palafolls A Palafolls A 25 69 93 35
7 Breda A Breda A 25 61 108 31
8 Sant Hilari-Font Vella Sant 22 61 114 29
9 Blanes C Blanes C 25 47 100 29
10 Olimpic Malgrat, CE Olimpic 26 46 94 28
11 Blanc Blava Lloret A Blanc Blava 22 43 125 11
12 La Batllòria A Batllòria 22 39 125 11
13 Hostalric A Hostalric A 23 47 136 10
14 Olimpic Malgrat B Olimpic 22 10 132 1
TEMPORADA 2017/2018
2ª CATALANA CADETE GRUPO 1
Equipo PJ GF GC Puntos
1 Escola Futbol Arbucienca A Escola 24 125 18 70
2 Farners A Farners A 22 106 11 56
3 Sporting Vidrerenca Cef A Sporting 25 110 56 51
4 Palafolls A Palafolls A 23 88 39 45
5 Blanes C Blanes C 23 77 35 41
6 Juve Lloret Futbol Club A Juve Lloret 23 92 47 39
7 Cal Aguido B Aguido 23 94 55 37
8 Sant Celoni B Sant Celoni 20 56 61 29
9 Olimpic Malgrat B Olimpic 24 47 70 27
10 Blanc Blava Lloret A Blanc Blava 22 61 93 21
11 Escola Futbol Angles Terbru Escola 22 50 93 19
12 Maçanet Selva A Maçanet 22 26 89 17
13 Sant Hilari-Font Vella Sant 6 12 34 7
14 Lloret B Lloret B 23 29 167 7
15 Tordera B Tordera B 22 27 132 6
TEMPORADA 2016/2017
1ª CATALANA CADETE GRUPO 17
Equipo PJ GF GC Puntos
1 Llagostera B Llagostera 30 123 14 79
2 Fundacio Esportiva Palamos Fundacio 30 88 34 74
3 Figueres B Figueres B 30 82 41 65
4 LlanÇa A A LlanÇa 30 69 24 62
5 Escola Girones-Sabat C Escola 30 82 50 59
6 Tordera B Tordera B 30 68 46 56
7 Peralada Sub 16 Peralada 30 70 43 55
8 Escola Futbol del Ripolles Escola 30 67 50 48
9 Blanes B Blanes B 30 52 57 41
10 Roses A Roses A 30 42 54 32
11 Fundació Olot B Fundació 30 60 78 31
12 Les Preses A Preses 30 48 82 31
13 Escola Bosc de Tosca A Escola Bosc 30 50 86 21
14 L'Escala A L'Escala A 30 34 100 21
15 Base Roses A Base Roses 30 50 100 16
16 Cal Aguido B Aguido 30 18 144 5
TEMPORADA 2015/2016
2ª CATALANA CADETE GRUPO 1
Equipo PJ GF GC Puntos
1 Tordera B Tordera B 29 123 30 74
2 Cal Aguido B Aguido 29 100 30 68
3 Farners A Farners A 30 137 43 68
4 Palafolls A Palafolls A 30 108 33 67
5 Sils A Sils A 30 102 51 60
6 Breda A Breda A 30 101 59 57
7 Riudarenes 2005 A Riudarenes 29 90 61 51
8 Sporting Vidrerenca Cef A Sporting 30 55 52 44
9 Sant Celoni B Sant Celoni 29 77 65 43
10 Lloret B Lloret B 29 79 86 31
11 Escola Futbol Arbucienca A Escola 30 63 91 29
12 Racing Blanenc A Racing 28 59 92 23
13 Olimpic Malgrat B Olimpic 30 56 129 21
14 Maçanet Selva A Maçanet 30 46 108 20
15 Tossa A Tossa A 30 44 139 13
16 Cuatro Vientos A Cuatro 29 39 210 10
TEMPORADA 2014/2015
2ª CATALANA CADETE GRUPO 1
Equipo PJ GF GC Puntos
1 Tordera A Tordera A 26 118 46 63
2 Blanes B Blanes B 26 75 36 56
3 Olimpic Malgrat, CE Olimpic 26 79 53 52
4 Sporting-Vidrerenca A Sporting-Vid 26 84 40 51
5 Farners A Farners A 26 72 43 51
6 Breda A Breda A 26 95 64 50
7 Riudarenes 2005 A Riudarenes 26 84 45 46
8 Lloret B Lloret B 26 53 53 37
9 Cal Aguido B Aguido 26 48 99 25
10 Sant Celoni PB B Sant Celoni 25 35 60 24
11 Blanc Blava Lloret A Blanc Blava 26 50 81 22
12 Cuatro Vientos A Cuatro 26 29 73 18
13 Racing Blanenc A Racing 26 57 124 14
14 Hostalric A Hostalric A 25 36 98 12
15 Maçanet Selva A Maçanet 0 0 0 0

  USO DE MEMORIA  
5,472,624 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0011
Controller Execution Time ( Home / Category )  0.4821
Total Execution Time  0.4833
  CADENA URL  
/historico/Cal-Aguido-B-Cadete
  GET DATOS  
$_GET['/historico/Cal-Aguido-B-Cadete']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (32)  
0.0230  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 = 'Cal-Aguido-B-Cadete' 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.0141  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 = 'Cal-Aguido-B-Cadete' 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=26598 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=26598 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=26598 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=26598 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=26598 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=26598 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=26598 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=26598 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0020  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=26598 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0026  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 = 70284
0.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=26598 AND type_rel = 2
0.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=747 AND type_rel = 3
0.0072  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 = '26598' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0025  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 = 70284 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0085  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=26598 AND l.year in (2022,2023,2024) ORDER BY l.id DESC, l.year DESC ;
0.0049  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 (70284) 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 = 70284 AND teamId = 26598
0.0020  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 = 70284 AND t.round = 30 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0115  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 = '26598' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0042  SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '26598' 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 = '26598' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0191  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 = 26598 AND l.year <= 2023 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.0199  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 = 70284 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.0356  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 = 65711 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.0334  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 = 52345 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.0159  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 = 46035 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0305  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 `tables2018_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 = 40234 AND t.round = 27 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0625  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 `tables2017_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 = 35172 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0358  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 = 18109 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0463  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 = 4964 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC