4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del SP Guardes
TEMPORADA 2023/2024
SEGUNDA GALICIA GRUPO 13
Equipo PJ GF GC Puntos
1 SP Guardes SP Guardes 31 64 30 68
2 Erizana Erizana 31 75 50 59
3 Gondomar Cf Gondomar Cf 31 55 34 59
4 U.D. Mos U.D. Mos 31 71 48 58
5 A D Vila Do Corpus Vila Corpus 31 58 47 52
6 Progresista Progresista 31 51 46 50
7 Goian FC Goian FC 31 59 55 50
8 Tomiño Tomiño 31 58 41 47
9 Caselas Caselas 31 51 43 45
10 Caldelas Caldelas 31 57 52 43
11 UVCD Candean UVCD Candean 31 59 57 39
12 Mondariz CF Mondariz CF 31 50 51 38
13 Ribera Ribera 31 49 53 36
14 San Miguel C.F. Miguel C.F. 31 54 70 36
15 Colegio Hogar Colegio 31 50 75 33
16 Juvenil de Ponteareas B Juvenil 31 47 66 31
17 UD Louro Tameiga Louro 31 36 71 28
18 Nieves CF Nieves CF 31 22 77 7
TEMPORADA 2022/2023
PRIMERA GALICIA GRUPO 5
Equipo PJ GF GC Puntos
1 CD Moaña CD Moaña 34 64 32 65
2 CP Alertanavia Alertanavia 34 68 39 65
3 SCD Ponte Caldelas Ponte 34 76 54 58
4 Atlantida Matama Atlantida 34 59 48 56
5 Arcade Arcade 34 46 35 55
6 Campo Lameiro CD Campo 34 41 35 51
7 San Martín Villajuan Martín 34 47 45 48
8 ED Val Miñor Miñor 34 66 59 47
9 Atlético Cuntis Atlético 34 53 59 46
10 San Adrián San Adrián 34 36 47 43
11 Sanxenxo Sanxenxo 34 57 51 42
12 Unión Dena CF Unión Dena 34 48 54 42
13 Mondariz CF Mondariz CF 34 49 58 41
14 Goian FC Goian FC 34 58 61 40
15 Caldelas Caldelas 34 54 68 40
16 A Lama SD A Lama SD 34 38 57 38
17 SP Guardes SP Guardes 34 49 70 35
18 Caselas Caselas 34 44 81 28
TEMPORADA 2021/2022
PREFERENTE GALICIA GRUPO 12
Equipo PJ GF GC Puntos
1 CD Valladares Valladares 8 15 9 22
2 Céltiga FC Céltiga FC 8 15 7 17
3 SP Guardes SP Guardes 8 16 12 16
4 CD Velle CD Velle 8 12 12 16
5 Poligono San Ciprian Poligono 8 5 23 1
TEMPORADA 2019/2020
PRIMERA GALICIA GRUPO 5
Equipo PJ GF GC Puntos
1 Umia Umia 25 60 35 57
2 Caselas Caselas 25 50 27 51
3 SP Guardes SP Guardes 25 48 27 41
4 CP Alertanavia Alertanavia 25 27 23 41
5 Marcón Atletico Marcón 25 35 30 37
6 Atlético Cuntis Atlético 25 34 36 37
7 La Guia La Guia 25 31 27 35
8 Unión Dena CF Unión Dena 25 44 44 35
9 Arcade Arcade 25 31 34 35
10 Campo Lameiro CD Campo 25 28 24 34
11 Moraña Moraña 25 36 41 33
12 Santa Mariña Santa 25 30 31 31
13 Amanecer Amanecer 25 37 47 31
14 Tyde F.C. Tyde F.C. 25 28 32 30
15 UVCD Candean UVCD Candean 25 35 41 30
16 Racing Castrelos Racing 25 46 41 29
17 Zacande Zacande 25 22 46 19
18 USD O Grove USD O Grove 25 22 58 12
TEMPORADA 2018/2019
PRIMERA GALICIA GRUPO 5
Equipo PJ GF GC Puntos
1 Portonovo Portonovo 34 58 24 69
2 Pontevedra B Pontevedra 34 75 44 66
3 Umia Umia 34 69 44 62
4 Arcade Arcade 34 74 44 60
5 Racing Castrelos Racing 34 63 46 55
6 SP Guardes SP Guardes 34 62 43 54
7 Celta C – Gran Peña Celta Gran. 33 55 41 54
8 Campo Lameiro CD Campo 34 45 41 50
9 La Guia La Guia 34 47 49 46
10 Atlético Cuntis Atlético 34 54 58 46
11 Unión Dena CF Unión Dena 34 50 56 45
12 San Martín Villajuan Martín 33 44 56 44
13 Caselas Caselas 34 38 44 43
14 Erizana Erizana 34 59 84 41
15 U.D. Mos U.D. Mos 34 38 50 38
16 Gondomar Cf Gondomar Cf 34 33 55 23
17 Salvatierra SD Salvatierra 34 31 66 23
18 Domaio FC Domaio FC 34 32 82 23
TEMPORADA 2017/2018
PRIMERA GALICIA GRUPO 5
Equipo PJ GF GC Puntos
1 Amanecer Amanecer 34 76 31 70
2 Cambados Cambados 34 75 33 68
3 Juvenil Ponteareas Juvenil 34 63 44 65
4 Portonovo Portonovo 34 67 41 64
5 SP Guardes SP Guardes 34 57 39 61
6 Celta C – Gran Peña Celta Gran. 34 51 43 54
7 Unión Dena CF Unión Dena 34 54 49 53
8 San Martín Villajuan Martín 34 54 46 51
9 Umia Umia 34 57 50 50
10 Domaio FC Domaio FC 34 65 60 45
11 Pontevedra B Pontevedra 34 60 53 43
12 U.D. Mos U.D. Mos 34 54 57 43
13 Santa Mariña Santa 34 46 50 43
14 CCD Chain CCD Chain 34 39 68 39
15 UVCD Candean UVCD Candean 33 48 58 34
16 Zacande Zacande 34 41 67 32
17 Rápido Bahía Rápido 33 33 92 22
18 Racing Vilariño Racing 34 37 96 21
TEMPORADA 2016/2017
PRIMERA GALICIA GRUPO 5
Equipo PJ GF GC Puntos
1 Campo Lameiro CD Campo 34 68 43 65
2 CD Beluso CD Beluso 34 60 35 65
3 Amanecer Amanecer 34 58 35 65
4 Marcón Atletico Marcón 34 60 38 65
5 Umia Umia 34 65 41 57
6 SP Guardes SP Guardes 34 62 48 52
7 Cambados Cambados 34 46 38 52
8 CCD Chain CCD Chain 34 52 55 48
9 Celta C – Gran Peña Celta Gran. 34 51 50 46
10 UVCD Candean UVCD Candean 34 49 55 46
11 U.D. Mos U.D. Mos 34 48 43 44
12 Juvenil Ponteareas Juvenil 34 40 45 44
13 Pontevedra B Pontevedra 34 36 37 42
14 Domaio FC Domaio FC 34 57 66 40
15 San Martín Villajuan Martín 34 46 57 38
16 SDR San Esteban Esteban 34 49 67 35
17 San Miguel C.F. Miguel C.F. 34 34 72 26
18 Atlético Cuntis Atlético 34 34 90 17
TEMPORADA 2015/2016
PRIMERA GALICIA GRUPO 5
Equipo PJ GF GC Puntos
1 Erizana Erizana 34 84 44 76
2 Pontellas Pontellas 34 75 35 69
3 CD Moaña CD Moaña 33 68 28 68
4 UVCD Candean UVCD Candean 34 49 32 61
5 Juvenil Ponteareas Juvenil 33 55 42 57
6 Amanecer Amanecer 34 51 43 55
7 Celta C – Gran Peña Celta Gran. 34 54 51 53
8 SP Guardes SP Guardes 34 55 41 51
9 San Martín Villajuan Martín 34 44 42 51
10 SDR San Esteban Esteban 34 36 49 43
11 Campo Lameiro CD Campo 33 41 48 42
12 Umia Umia 34 39 59 40
13 Pontevedra B Pontevedra 34 47 46 39
14 CD Beluso CD Beluso 32 43 46 37
15 Unión Dena CF Unión Dena 33 38 67 30
16 Caldas CF Caldas CF 34 40 71 29
17 Rápido Bahía Rápido 34 39 76 28
18 Nigrán Cf Nigrán Cf 34 38 76 24
TEMPORADA 2014/2015
PRIMERA GALICIA GRUPO 5
Equipo PJ GF GC Puntos
1 USD O Grove USD O Grove 34 52 30 69
2 Domaio FC Domaio FC 34 76 45 68
3 Caselas Caselas 34 66 38 65
4 CD Beluso CD Beluso 34 55 35 58
5 CD Moaña CD Moaña 34 50 45 57
6 SDR San Esteban Esteban 34 49 42 49
7 SP Guardes SP Guardes 34 50 43 48
8 Caldas CF Caldas CF 34 53 52 48
9 UVCD Candean UVCD Candean 34 49 48 48
10 Campo Lameiro CD Campo 34 46 39 46
11 Unión Dena CF Unión Dena 34 57 53 46
12 Celta C – Gran Peña Celta Gran. 34 45 41 46
13 Salvatierra SD Salvatierra 34 47 52 42
14 CCD Chain CCD Chain 34 55 55 40
15 Cambados Cambados 34 40 55 37
16 Cruceiro Do Hío Cruceiro 34 35 76 30
17 Marín CF Marín CF 34 29 62 28
18 UD Louro Tameiga Louro 34 30 73 22
TEMPORADA 2003/2004
TERCERA DIVISIÓN GRUPO 1
Equipo PJ GF GC Puntos
1 CCD Cerceda CCD Cerceda 38 65 31 76
2 At. Arteixo At. Arteixo 38 70 35 73
3 Deportivo Fabril Deportivo 38 65 37 71
4 Verín Verín 38 56 37 68
5 Lalín Lalín 38 49 34 65
6 CD Lugo CD Lugo 38 60 41 64
7 Compostela - Zona Vella B Compostela 38 39 37 57
8 Porriño Industrial Porriño 38 48 40 56
9 Coruxo Coruxo 38 44 50 50
10 Bergantiños FC Bergantiños 38 47 48 48
11 Negreira Negreira 38 34 42 47
12 Betanzos CF Betanzos CF 38 41 43 46
13 CD Grove CD Grove 38 53 56 45
14 Rápido de Bouzas Rápido 38 43 47 44
15 Portonovo Portonovo 38 34 48 44
16 Arosa Arosa 38 41 56 41
17 Narón BP Narón BP 38 44 68 37
18 Ponte Ourense Ponte 38 42 72 36
19 SP Guardes SP Guardes 38 34 59 35
20 UD Xove Lago Xove Lago 38 33 61 30
TEMPORADA 2002/2003
TERCERA DIVISIÓN GRUPO 1
Equipo PJ GF GC Puntos
1 Deportivo Fabril Deportivo 38 68 39 78
2 CCD Cerceda CCD Cerceda 38 76 35 72
3 Rápido de Bouzas Rápido 38 64 39 69
4 At. Arteixo At. Arteixo 38 54 34 67
5 Lalín Lalín 38 56 37 66
6 Compostela - Zona Vella B Compostela 38 55 51 54
7 UD Xove Lago Xove Lago 38 42 43 51
8 Ponte Ourense Ponte 38 42 51 50
9 Verín Verín 38 40 44 49
10 CD Grove CD Grove 38 47 55 48
11 Portonovo Portonovo 38 44 57 46
12 Arosa Arosa 38 45 61 46
13 Negreira Negreira 38 41 46 44
14 Betanzos CF Betanzos CF 38 45 52 44
15 Bergantiños FC Bergantiños 38 31 39 44
16 SP Guardes SP Guardes 38 37 55 42
17 Rácing Vilalbés Rácing 38 34 37 42
18 Alondras CF Alondras CF 38 41 52 42
19 Viveiro Viveiro 38 47 61 39
20 Club Lemos Club Lemos 38 36 57 30

  USO DE MEMORIA  
6,218,584 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0012
Controller Execution Time ( Home / Category )  0.5281
Total Execution Time  0.5294
  CADENA URL  
/historico/Sp-Guardes
  GET DATOS  
$_GET['/historico/Sp-Guardes']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (26)  
0.0148  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=18946 AND type_rel = 2
0.0153  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 = '18946' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0151  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 = 73753 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0162  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=18946 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0153  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 (73753,68967) 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.0147  SELECT count(id) as num_players from rel_players WHERE league_id = 68967 AND teamId = 18946
0.0145  SELECT count(id) as num_players from rel_players WHERE league_id = 73753 AND teamId = 18946
0.0147  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 = '18946' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0145  SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '18946' and rp.type = 4
0.0151  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 = '18946' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0156  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 = 73753 WHERE rp.league_id = 73753 AND rp.teamId = 18946 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.0156  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 = 73753 WHERE rp.league_id = 73753 AND rp.teamId = 18946 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0155  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 = 73753 WHERE rp.league_id = 73753 AND rp.teamId = 18946 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0159  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 = 18946 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.0295  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 = 73753 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.0151  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 = 68967 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.0148  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 = 64091 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.0149  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 = 67016 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.0149  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 = 51298 AND t.round = 25 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0149  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 = 45151 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0151  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 = 39708 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0151  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 = 34039 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0151  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 = 16769 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0149  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 = 4055 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0150  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 `tables2004` 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 = 21000 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0151  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 `tables2003` 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 = 20999 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC