4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del Sigueiro CF
TEMPORADA 2023/2024
PREFERENTE GALICIA GRUPO 1
Equipo PJ GF GC Puntos
1 Noia Noia 31 62 28 63
2 Boiro Boiro 30 51 25 56
3 Sigueiro CF Sigueiro CF 30 54 35 54
4 San Tirso SD Tirso 30 36 28 53
5 CD Lalín CD Lalín 30 49 39 49
6 SD Sofán SD Sofán 30 52 38 48
7 AD Miño AD Miño 30 42 33 46
8 At. Coruña Montañeros Coruña 30 40 26 45
9 Cidade de Ribeira CF Cidade 30 52 52 39
10 Dubra Dubra 31 35 43 39
11 Galicia Mugardos Galicia 30 33 35 38
12 Ribadeo FC Ribadeo FC 30 43 50 36
13 Club Lemos Club Lemos 30 31 40 35
14 CD Castro CD Castro 30 41 50 33
15 Victoria CF Victoria CF 30 30 52 30
16 SDC Residencia Residencia 30 34 56 29
17 As Pontes As Pontes 30 30 42 28
18 Eume Deportivo Eume 30 29 72 18
TEMPORADA 2022/2023
PREFERENTE GALICIA GRUPO 1
Equipo PJ GF GC Puntos
1 SD Sarriana SD Sarriana 38 79 31 83
2 Betanzos CF Betanzos CF 38 83 38 82
3 Boiro Boiro 38 74 25 79
4 Noia Noia 38 70 28 79
5 San Tirso SD Tirso 38 74 43 57
6 Dubra Dubra 38 51 54 56
7 SDC Residencia Residencia 38 51 46 55
8 Galicia Mugardos Galicia 38 53 43 55
9 SD Sofán SD Sofán 38 55 59 54
10 Ribadeo FC Ribadeo FC 38 53 62 53
11 O Pino O Pino 38 66 80 52
12 At. Coruña Montañeros Coruña 38 62 55 51
13 Sigueiro CF Sigueiro CF 38 55 50 51
14 Club Lemos Club Lemos 38 55 57 50
15 Victoria CF Victoria CF 38 53 51 49
16 As Pontes As Pontes 38 47 52 49
17 Club Ordenes SD Club Ordenes 38 49 54 46
18 CD Union CD Union 38 49 71 42
19 SD Fisterra SD Fisterra 38 30 143 15
20 Portomarín Portomarín 38 31 98 9
TEMPORADA 2021/2022
PREFERENTE GALICIA GRUPO 5
Equipo PJ GF GC Puntos
1 At. Arteixo At. Arteixo 10 16 7 29
2 UD Paiosaco UD Paiosaco 10 17 5 28
3 SD Sarriana SD Sarriana 10 15 10 26
4 Sigueiro CF Sigueiro CF 10 7 11 16
5 Betanzos CF Betanzos CF 10 12 12 15
6 Dubra Dubra 10 9 11 13
7 Club Lemos Club Lemos 10 7 10 12
8 SD Fisterra SD Fisterra 10 10 21 12
9 At. Coruña Montañeros Coruña 10 12 16 10
10 Galicia Mugardos Galicia 10 9 11 8
TEMPORADA 2019/2020
PREFERENTE GALICIA GRUPO 1
Equipo PJ GF GC Puntos
1 Viveiro Viveiro 26 57 21 62
2 SD Fisterra SD Fisterra 26 45 29 51
3 Boiro Boiro 26 38 31 47
4 Noia Noia 26 44 26 46
5 Galicia Mugardos Galicia 26 41 29 45
6 Puebla CF Puebla CF 26 28 23 43
7 At. Arteixo At. Arteixo 26 32 24 42
8 SD Sofán SD Sofán 26 44 33 41
9 SD Sarriana SD Sarriana 26 53 33 38
10 Ribadeo FC Ribadeo FC 26 38 35 37
11 Sigueiro CF Sigueiro CF 26 28 26 35
12 San Tirso SD Tirso 26 29 34 35
13 Boimorto CF Boimorto CF 26 41 45 32
14 SDC Residencia Residencia 26 32 39 32
15 Club Lemos Club Lemos 26 31 46 31
16 Dubra Dubra 26 41 48 27
17 At. Coruña Montañeros Coruña 26 26 40 24
18 Xallas FC Xallas FC 26 31 66 20
19 Laracha Laracha 26 27 41 19
20 CD Foz CD Foz 26 24 61 15
TEMPORADA 2018/2019
PRIMERA GALICIA GRUPO 2
Equipo PJ GF GC Puntos
1 Sigueiro CF Sigueiro CF 34 70 17 79
2 SD Fisterra SD Fisterra 34 72 27 79
3 Flavia Flavia 34 78 31 75
4 CD Baio CD Baio 34 62 43 60
5 CF Dumbría CF Dumbría 34 59 51 51
6 CD Union CD Union 34 38 40 49
7 Piloño Piloño 34 52 58 47
8 CD Lalín CD Lalín 34 42 43 45
9 Soneira Sd Soneira Sd 34 46 48 45
10 Esclavitud Esclavitud 34 37 54 44
11 Praiña Praiña 34 42 52 42
12 Tordoia Tordoia 34 52 55 41
13 Val do Ulla Val do Ulla 34 60 67 41
14 Cordeiro CF Cordeiro CF 34 49 53 40
15 Chaian Chaian 34 31 57 35
16 SD Esteirana Esteirana 34 37 54 33
17 Bertamiráns FC Bertamiráns 34 43 89 26
18 Bastavales Bastavales 34 38 69 25
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  
6,043,160 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0014
Controller Execution Time ( Home / Category )  0.1181
Total Execution Time  0.1195
  CADENA URL  
/historico/Sigueiro-Cf
  GET DATOS  
$_GET['/historico/Sigueiro-Cf']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (30)  
0.0028  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 = 'Sigueiro-Cf' 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=18909 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=18909 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 = 73534
0.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=18909 AND type_rel = 2
0.0024  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 = '18909' 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 = '18909' AND l.year = 2024 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 = '18909' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0019  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 = 73534 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0022  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=18909 AND l.year in (2023,2024,2025) 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 (73534) 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.0020  SELECT count(id) as num_players from rel_players WHERE league_id = 73534 AND teamId = 18909
0.0027  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff 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 = 73534 AND t.round = 31 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
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 = '18909' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0020  SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '18909' 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 = '18909' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0031  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 = 73534 WHERE rp.league_id = 73534 AND rp.teamId = 18909 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.0030  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 = 73534 WHERE rp.league_id = 73534 AND rp.teamId = 18909 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0027  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 = 73534 WHERE rp.league_id = 73534 AND rp.teamId = 18909 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
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 = 18909 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.0025  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 = 73534 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.0025  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 = 68756 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.0025  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 = 64088 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.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 `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 = 67009 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.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` 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 = 51173 AND t.round = 26 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0034  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 = 45148 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
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 `tables2018` 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 = 39705 AND t.round = 34 ORDER BY team.conference 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 `tables2017` 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 = 34036 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0027  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` 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 = 16766 AND t.round = 34 ORDER BY team.conference 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 `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 = 4052 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC