4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del SD Monterroso
TEMPORADA 2023/2024
PRIMERA GALICIA GRUPO 3
Equipo PJ GF GC Puntos
TEMPORADA 2022/2023
PRIMERA GALICIA GRUPO 3
Equipo PJ GF GC Puntos
1 CD Castro CD Castro 34 76 29 80
2 SD Chantada SD Chantada 34 77 25 73
3 Atl. Escairón Atl. 34 61 26 72
4 Outeiro De Rei Outeiro 34 65 37 71
5 SD Pol SD Pol 34 84 35 68
6 Chantada Atlético Chantada 34 89 47 62
7 CD Foz CD Foz 34 66 47 60
8 SD Burela SD Burela 34 50 50 47
9 Taboada CF Taboada CF 34 59 67 47
10 Santaballés Santaballés 34 50 50 46
11 UD Xove Lago Xove Lago 34 60 68 46
12 Lourenzá Lourenzá 34 35 47 41
13 SD Monterroso Monterroso 34 41 60 38
14 Riotorto Riotorto 34 44 57 34
15 Sporting Pontenova Sporting 34 43 104 19
16 S.D. Antas S.D. Antas 34 27 81 18
17 CD San Ciprián Ciprián 34 29 64 15
18 UD Pastoricense Pastoricense 34 27 89 14
TEMPORADA 2021/2022
PRIMERA GALICIA GRUPO 22
Equipo PJ GF GC Puntos
1 SD Monterroso Monterroso 10 14 10 22
2 UD Pastoricense Pastoricense 10 12 12 17
3 Sporting Pontenova Sporting 10 9 12 16
4 Folgueiro UD Folgueiro 10 15 10 15
5 San Lazaro SD Lazaro 10 4 9 13
6 San Roque SDC Roque 10 9 10 10
TEMPORADA 2019/2020
PRIMERA GALICIA GRUPO 3
Equipo PJ GF GC Puntos
1 Atl. Escairón Atl. 25 52 19 61
2 Santaballés Santaballés 25 46 32 50
3 SD Pol SD Pol 25 44 23 49
4 SD Chantada SD Chantada 25 59 34 48
5 SD Monterroso Monterroso 25 38 28 43
6 Riotorto Riotorto 25 39 29 41
7 SD Burela SD Burela 25 41 30 39
8 Outeiro De Rei Outeiro 25 39 28 39
9 Guntín Guntín 25 38 43 35
10 UD Xove Lago Xove Lago 25 30 37 28
11 Taboada CF Taboada CF 25 38 38 27
12 Chantada Atlético Chantada 25 35 42 26
13 CD Castro CD Castro 25 29 36 24
14 Folgueiro UD Folgueiro 25 45 71 24
15 UD Pastoricense Pastoricense 25 24 34 23
16 Friol Friol 25 24 44 18
17 San Roque SDC Roque 25 20 56 18
18 Lourenzá Lourenzá 25 31 48 16
TEMPORADA 2018/2019
PRIMERA GALICIA GRUPO 3
Equipo PJ GF GC Puntos
1 Club Lemos Club Lemos 34 72 20 79
2 SDC Residencia Residencia 34 80 38 69
3 SD Chantada SD Chantada 34 66 34 68
4 Santaballés Santaballés 34 62 37 63
5 Outeiro De Rei Outeiro 33 53 31 56
6 Atl. Escairón Atl. 34 52 41 51
7 Taboada CF Taboada CF 34 51 48 50
8 SD Burela SD Burela 34 54 50 47
9 SD Pol SD Pol 34 58 57 47
10 SD Monterroso Monterroso 34 59 52 45
11 Friol Friol 34 53 70 43
12 UD Xove Lago Xove Lago 33 43 51 42
13 Riotorto Riotorto 34 41 46 40
14 UD Pastoricense Pastoricense 34 41 51 39
15 Chantada Atlético Chantada 33 51 76 35
16 CD San Ciprián Ciprián 34 40 65 30
17 SD O Páramo Páramo 33 40 79 26
18 Sporting Pontenova Sporting 34 29 99 12
TEMPORADA 2017/2018
PRIMERA GALICIA GRUPO 3
Equipo PJ GF GC Puntos
1 SD Sarriana SD Sarriana 34 65 27 76
2 CD Foz CD Foz 34 81 39 75
3 Club Lemos Club Lemos 34 81 50 66
4 SD Chantada SD Chantada 34 63 39 63
5 Riotorto Riotorto 34 46 33 57
6 UD Xove Lago Xove Lago 34 74 48 56
7 SD Monterroso Monterroso 34 68 53 48
8 Santaballés Santaballés 34 49 38 47
9 Taboada CF Taboada CF 34 55 51 47
10 SD O Páramo Páramo 34 57 54 46
11 CD San Ciprián Ciprián 34 65 60 45
12 UD Pastoricense Pastoricense 34 45 43 45
13 ADC Valle del oro Valle 34 45 53 44
14 Sporting Pontenova Sporting 34 50 59 44
15 San Roque SDC Roque 34 35 68 36
16 Ferreira C.F. Ferreira 34 36 86 21
17 Xermade Xermade 34 33 88 21
18 AD Bóveda AD Bóveda 34 35 94 20
TEMPORADA 2016/2017
PRIMERA GALICIA GRUPO 3
Equipo PJ GF GC Puntos
1 SDC Residencia Residencia 34 78 24 81
2 Outeiro De Rei Outeiro 34 59 22 70
3 SD Monterroso Monterroso 34 71 38 63
4 CD Foz CD Foz 34 62 30 63
5 Santaballés Santaballés 34 51 41 56
6 UD Pastoricense Pastoricense 34 51 41 54
7 ADC Valle del oro Valle 34 58 48 50
8 Riotorto Riotorto 34 51 41 50
9 AD Bóveda AD Bóveda 34 39 41 44
10 CD San Ciprián Ciprián 34 52 67 44
11 SD O Páramo Páramo 34 51 61 43
12 Taboada CF Taboada CF 34 47 58 42
13 UD Xove Lago Xove Lago 34 38 53 42
14 SD Burela SD Burela 34 44 50 39
15 Chantada Atlético Chantada 34 45 59 38
16 SCD Milagrosa Milagrosa 34 32 65 25
17 Chantada B Chantada B 34 29 79 23
18 S.D. Antas S.D. Antas 34 35 75 22
TEMPORADA 2015/2016
PRIMERA GALICIA GRUPO 3
Equipo PJ GF GC Puntos
1 Atl. Escairón Atl. 34 76 32 77
2 CD Lugo B CD Lugo B 34 61 26 77
3 SDC Residencia Residencia 34 84 35 76
4 Santaballés Santaballés 34 57 37 58
5 Outeiro De Rei Outeiro 34 59 50 53
6 UD Xove Lago Xove Lago 34 54 41 51
7 SD Burela SD Burela 34 60 50 49
8 SD Monterroso Monterroso 34 62 53 49
9 UD Pastoricense Pastoricense 34 42 42 44
10 ADC Valle del oro Valle 34 44 55 41
11 SD Chantada SD Chantada 34 51 65 38
12 CD San Ciprián Ciprián 34 58 73 37
13 Taboada CF Taboada CF 34 37 61 37
14 S.D. Antas S.D. Antas 34 45 74 37
15 SD O Páramo Páramo 34 42 75 36
16 Lourenzá Lourenzá 34 49 64 35
17 SD Becerrea SD Becerrea 34 59 76 33
18 SD Muimenta SD Muimenta 34 37 68 28
TEMPORADA 2014/2015
PRIMERA GALICIA GRUPO 3
Equipo PJ GF GC Puntos
1 Club Lemos Club Lemos 34 81 27 76
2 SCD Milagrosa Milagrosa 34 86 33 75
3 Outeiro De Rei Outeiro 34 59 34 65
4 SD Burela SD Burela 34 54 43 60
5 SD Becerrea SD Becerrea 34 71 58 53
6 UD Xove Lago Xove Lago 34 62 43 50
7 UD Pastoricense Pastoricense 34 52 60 46
8 CD San Ciprián Ciprián 34 53 50 45
9 Taboada CF Taboada CF 34 45 50 45
10 ADC Valle del oro Valle 34 38 40 44
11 SD O Páramo Páramo 34 48 61 42
12 SD Muimenta SD Muimenta 34 46 60 40
13 CD Lugo B CD Lugo B 34 46 69 39
14 SD Monterroso Monterroso 34 44 58 38
15 ADC Sagrado Corazon Sagrado 34 34 47 37
16 SDC Cabreiros Cabreiros 34 44 66 33
17 AD Bóveda AD Bóveda 34 46 75 30
18 Iberia CF Iberia CF 34 34 69 26

  USO DE MEMORIA  
5,640,992 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0013
Controller Execution Time ( Home / Category )  0.1125
Total Execution Time  0.1138
  CADENA URL  
/historico/Sd-Monterroso
  GET DATOS  
$_GET['/historico/Sd-Monterroso']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (29)  
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-Monterroso' 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=18919 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=18919 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=18919 AND type_rel = 2
0.0020  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 2 AND rel.typeId = 18919 AND rel.ln = 'es' ORDER BY rel.cover_points DESC LIMIT 5
0.0021  SELECT /*35 bs_news_model*/ n.id, n.author_id, n.headline, n.external_headline, n.live_headline, n.creation_date, n.update_date, n.pub_date, n.alias, n.subheadline, n.teaser, n.media, n.tags, n.views, n.screens, n.clicks, n.relations, n.comments, n.power_cover, n.cover_points, u.name as user_name FROM bs_news n INNER JOIN bs_editors u ON u.id = n.author_id AND u.ln = 'es' WHERE n.status = 1 AND n.ln = 'es' AND n.id IN (378554) ORDER BY n.cover_points DESC, update_date DESC
0.0022  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 = '18919' ORDER BY l.year DESC,cat.coefficient DESC
0.0022  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 = '18919' AND l.year = 2024 ORDER BY l.year DESC,cat.coefficient DESC
0.0022  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 = '18919' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
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=18919 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 (73635) 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 WHERE league_id = 73635 AND teamId = 18919
0.0021  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 = '18919' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0018  SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '18919' 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 = '18919' 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 = 73635 WHERE rp.league_id = 73635 AND rp.teamId = 18919 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.0028  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 = 73635 WHERE rp.league_id = 73635 AND rp.teamId = 18919 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0028  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 = 73635 WHERE rp.league_id = 73635 AND rp.teamId = 18919 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 = 18919 AND l.year <= 2024 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 `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 = 73635 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.0039  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 = 68965 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.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 = 65123 AND t.round = 18 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 `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 = 67202 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.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 `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 = 51296 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.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 `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 = 45149 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0033  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 = 39706 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 `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 = 34037 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0030  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 = 16767 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0039  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 = 4053 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC