4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del SD Agolada
TEMPORADA 2023/2024
PRIMERA GALICIA GRUPO 2
Equipo PJ GF GC Puntos
TEMPORADA 2022/2023
PRIMERA GALICIA GRUPO 2
Equipo PJ GF GC Puntos
1 Cidade de Ribeira CF Cidade 34 73 23 79
2 SD Negreira SD Negreira 34 70 27 70
3 Flavia Flavia 34 57 35 69
4 CD Lalín CD Lalín 34 84 39 68
5 CF Dumbría CF Dumbría 34 73 29 67
6 SCD Santa Comba Santa Comba 34 63 32 67
7 Cordeiro CF Cordeiro CF 34 60 28 62
8 Puebla Galicia CF Puebla 34 69 49 59
9 Soneira Sd Soneira Sd 34 59 57 49
10 Calo SR Calo SR 34 49 54 39
11 SD Agolada SD Agolada 34 43 62 39
12 Tordoia Tordoia 34 53 61 38
13 Cruces SD Cruces SD 34 33 48 36
14 SD Esteirana Esteirana 34 42 64 34
15 CD Baio CD Baio 34 49 70 32
16 Mazaricos Mazaricos 34 29 92 24
17 CF Silleda CF Silleda 34 28 92 13
18 CF Vista Alegre Vista Alegre 34 29 101 11
TEMPORADA 2021/2022
PRIMERA GALICIA GRUPO 3
Equipo PJ GF GC Puntos
1 CD Union CD Union 20 38 13 40
2 Flavia Flavia 20 33 21 37
3 Lalín Lalín 20 36 21 36
4 Cidade de Ribeira CF Cidade 19 27 17 36
5 Cordeiro CF Cordeiro CF 20 29 18 34
6 Cruces SD Cruces SD 20 25 21 28
7 SD Agolada SD Agolada 20 19 23 25
8 Praiña Praiña 20 30 33 23
9 Val do Ulla Val do Ulla 20 20 38 17
10 Esclavitud Esclavitud 20 12 35 12
11 Taragoña Taragoña 19 16 45 9
TEMPORADA 2019/2020
PRIMERA GALICIA GRUPO 2
Equipo PJ GF GC Puntos
1 O Pino O Pino 25 55 26 46
2 CF Dumbría CF Dumbría 25 47 36 46
3 Soneira Sd Soneira Sd 25 53 44 46
4 CD Lalín CD Lalín 25 41 27 43
5 Tordoia Tordoia 25 44 46 40
6 Flavia Flavia 25 46 36 39
7 Cordeiro CF Cordeiro CF 25 41 29 37
8 Praiña Praiña 25 29 33 34
9 SD Agolada SD Agolada 25 39 39 33
10 Negreira Negreira 25 30 33 33
11 Piloño Piloño 25 27 36 32
12 Esclavitud Esclavitud 25 33 39 31
13 CD Baio CD Baio 25 32 44 31
14 Mazaricos Mazaricos 25 35 43 27
15 Val do Ulla Val do Ulla 25 38 52 27
16 CD Union CD Union 25 34 33 26
17 Volantes de Baño Volantes 25 37 46 26
18 Cidade de Ribeira CF Cidade 25 35 54 25
TEMPORADA 2018/2019
PREFERENTE GALICIA GRUPO 1
Equipo PJ GF GC Puntos
1 As Pontes As Pontes 38 123 40 92
2 CSD Arzua CSD Arzua 38 88 45 81
3 Viveiro Viveiro 38 101 52 79
4 SD Sarriana SD Sarriana 38 71 39 76
5 Noia Noia 38 80 51 76
6 Ribadeo FC Ribadeo FC 38 63 58 67
7 SD Sofán SD Sofán 38 74 59 56
8 Dubra Dubra 38 67 61 56
9 At. Arteixo At. Arteixo 38 61 46 55
10 At. Coruña Montañeros Coruña 38 54 50 52
11 Boimorto CF Boimorto CF 38 65 58 51
12 San Tirso SD Tirso 38 58 61 49
13 Puebla CF Puebla CF 38 48 53 49
14 Xallas FC Xallas FC 38 56 63 49
15 CD Foz CD Foz 38 58 76 48
16 Negreira Negreira 38 45 51 46
17 Club Ordenes SD Club Ordenes 38 53 70 41
18 SD Agolada SD Agolada 38 47 73 26
19 CD Castro CD Castro 38 36 138 10
20 AD Estudiantil Estudiantil 38 28 132 6
TEMPORADA 2017/2018
PRIMERA GALICIA GRUPO 2
Equipo PJ GF GC Puntos
1 SD Agolada SD Agolada 34 60 29 73
2 Puebla Galicia CF Puebla 34 69 28 69
3 SD Piloño SD Piloño 34 61 43 69
4 Flavia Flavia 34 60 30 64
5 CD Union CD Union 34 63 43 62
6 Bastavales Bastavales 34 56 46 57
7 Soneira Sd Soneira Sd 34 60 40 56
8 Lalín Lalín 34 69 48 55
9 Bertamiráns FC Bertamiráns 34 51 53 46
10 CD Baio CD Baio 34 43 43 40
11 Cordeiro CF Cordeiro CF 34 53 59 40
12 Chaián Chaián 34 45 46 39
13 Sigueiro CF Sigueiro CF 34 44 54 39
14 Tordoia Tordoia 34 32 54 37
15 SD Fisterra SD Fisterra 34 39 59 36
16 Cidade de Ribeira CF Cidade 34 43 82 29
17 San Lorenzo Verdillo Lorenzo 34 38 76 25
18 CF Silleda CF Silleda 34 35 88 17
TEMPORADA 2016/2017
PRIMERA GALICIA GRUPO 2
Equipo PJ GF GC Puntos
1 CF Dumbría CF Dumbría 34 69 30 75
2 SD Agolada SD Agolada 34 62 46 65
3 Sigueiro CF Sigueiro CF 34 66 43 56
4 Puebla Galicia CF Puebla 34 49 38 55
5 SD Piloño SD Piloño 34 74 62 53
6 CD Union CD Union 34 52 44 53
7 Cordeiro CF Cordeiro CF 34 72 56 51
8 Flavia Flavia 34 59 46 51
9 Cidade de Ribeira CF Cidade 34 70 55 49
10 Tordoia Tordoia 34 49 44 44
11 SD Fisterra SD Fisterra 33 46 48 44
12 CF Silleda CF Silleda 34 34 52 44
13 Val do Ulla Val do Ulla 34 48 49 43
14 Outes Outes 34 41 65 41
15 Lalín Lalín 33 48 58 40
16 Sporting Zas Sporting 34 43 72 34
17 Esclavitud Esclavitud 34 35 61 27
18 SD Villestro Villestro 34 46 94 22
TEMPORADA 2015/2016
PRIMERA GALICIA GRUPO 2
Equipo PJ GF GC Puntos
1 Soneira Sd Soneira Sd 33 73 36 68
2 SD Sofán SD Sofán 34 67 35 67
3 Flavia Flavia 34 74 43 66
4 Val do Ulla Val do Ulla 34 71 45 65
5 CD Union CD Union 33 69 34 62
6 Cordeiro CF Cordeiro CF 34 75 44 60
7 SD Piloño SD Piloño 34 64 38 57
8 Sigueiro CF Sigueiro CF 34 66 54 51
9 Tordoia Tordoia 34 59 51 50
10 SD Agolada SD Agolada 34 53 40 50
11 Outes Outes 34 62 60 48
12 Lesende CFC Lousame Lesende 33 46 45 47
13 CD Baio CD Baio 34 34 55 37
14 Corme CF Corme CF 34 59 82 35
15 Bertamirans B Bertamirans 34 44 69 33
16 Hijos Palmeira Hijos 33 45 110 24
17 Carcacía Carcacía 34 31 88 18
18 Malpica SDC Malpica SDC 34 42 105 18
TEMPORADA 2014/2015
PRIMERA GALICIA GRUPO 2
Equipo PJ GF GC Puntos
1 SD Villestro Villestro 34 58 34 68
2 Puebla Galicia CF Puebla 34 52 27 66
3 CD Union CD Union 34 49 27 63
4 CD Baio CD Baio 34 52 43 58
5 Bertamirans B Bertamirans 34 55 50 55
6 SD Sofán SD Sofán 34 47 49 53
7 Malpica SDC Malpica SDC 34 42 43 45
8 Corme CF Corme CF 34 47 50 45
9 Cordeiro CF Cordeiro CF 34 37 40 45
10 Sigueiro CF Sigueiro CF 34 52 47 44
11 SD Piloño SD Piloño 34 41 42 44
12 Flavia Flavia 34 34 43 44
13 Soneira Sd Soneira Sd 34 44 42 43
14 Lesende CFC Lousame Lesende 34 43 49 41
15 SD Agolada SD Agolada 34 42 46 39
16 Amio CF Amio CF 34 42 54 37
17 CF Silleda CF Silleda 34 33 57 33
18 SD Esteirana Esteirana 34 36 63 31

  USO DE MEMORIA  
5,708,456 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0011
Controller Execution Time ( Home / Category )  0.0947
Total Execution Time  0.0959
  CADENA URL  
/historico/Sd-Agolada
  GET DATOS  
$_GET['/historico/Sd-Agolada']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (24)  
0.0030  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 = 'Sd-Agolada' 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.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=18904 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=18904 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0043  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 = 73634
0.0019  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=18904 AND type_rel = 2
0.0025  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 = '18904' ORDER BY l.year DESC,cat.coefficient DESC
0.0023  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 = '18904' AND l.year = 2024 ORDER BY l.year DESC,cat.coefficient DESC
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 = '18904' 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 = 73634 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0024  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=18904 AND l.year in (2023,2024,2025) 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 (73634) 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.0023  SELECT count(id) as num_players from rel_players WHERE league_id = 73634 AND teamId = 18904
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 = '18904' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0019  SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '18904' and rp.type = 4
0.0022  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 = '18904' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0044  SELECT e.action,rp.player_id, count(e.action) as total, p.nick,p.name,p.last_name,p.alias,rp.team_id FROM `rel_players` rp INNER JOIN dataplayers p ON p.id = rp.player_id INNER JOIN events2024 e ON e.player_id = p.id AND e.league_id = 73634 WHERE rp.league_id = 73634 AND rp.teamId = 18904 AND (e.action = 1 or e.action = 2 or e.action = 11 or e.action = 12 or e.action = 13) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0035  SELECT e.action,rp.player_id, count(e.action) as total, p.nick,p.name,p.last_name,p.alias,rp.team_id FROM `rel_players` rp INNER JOIN dataplayers p ON p.id = rp.player_id INNER JOIN events2024 e ON e.player_id = p.id AND e.league_id = 73634 WHERE rp.league_id = 73634 AND rp.teamId = 18904 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0029  SELECT e.action,rp.player_id, count(e.action) as total, p.nick,p.name,p.last_name,p.alias,rp.team_id FROM `rel_players` rp INNER JOIN dataplayers p ON p.id = rp.player_id INNER JOIN events2024 e ON e.player_id = p.id AND e.league_id = 73634 WHERE rp.league_id = 73634 AND rp.teamId = 18904 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0025  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 = 18904 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
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,team.teamId 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 = 73634 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.0031  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 = 68964 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.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` 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 = 67199 AND t.round = 10 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0031  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 = 65121 AND t.round = 22 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0031  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` 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 = 44618 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC