4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del Montalegre
TEMPORADA 2023/2024
CAMPEONATO DE PORTUGAL GRUPO 1
Equipo PJ GF GC Puntos
1 Os Limianos Os Limianos 26 35 27 45
2 Pevidém Pevidém 26 31 22 44
3 Tirsense Tirsense 26 37 24 43
4 Camacha Camacha 26 36 30 38
5 Brito SC Brito SC 26 26 26 38
6 Marítimo II Marítimo 26 34 26 35
7 Vila Real Vila Real 26 24 22 35
8 Os Sandinenses Sandinenses 26 31 31 35
9 Dumiense FC Dumiense FC 26 30 32 35
10 Montalegre Montalegre 26 25 31 34
11 Vilar de Perdizes Vilar 26 29 32 31
12 Portosantense Portosantens 26 22 27 27
13 Mirandela Mirandela 26 25 37 24
14 Ribeirão Ribeirão 26 19 37 23
TEMPORADA 2022/2023
LIGA 3 GRUPO 4
Equipo PJ GF GC Puntos
1 Varzim Varzim 6 6 6 16
2 Fafe Fafe 6 9 6 15
3 São João Ver São João 6 6 6 14
4 Montalegre Montalegre 6 5 8 8
5 Canelas 2010 Canelas 2010 6 11 6 21
6 Anadia Anadia 6 10 10 11
7 USC Paredes USC Paredes 6 6 7 11
8 Vitória SC B Vitória 6 4 8 4
9 Sporting CP II Sporting 6 8 8 16
10 Vitória Setúbal Vitória 6 7 6 15
11 Oliveira Hospital Oliveira 6 8 8 15
12 Real Sport Clube Real Sport. 6 6 7 8
13 Académica Académica 6 8 3 18
14 Caldas Caldas 6 9 8 14
15 Fontinhas Fontinhas 6 6 8 11
16 Moncarapachense Moncarapache 6 3 7 6
TEMPORADA 2021/2022
LIGA 3 GRUPO 3
Equipo PJ GF GC Puntos
1 Fafe Fafe 6 8 5 13
2 Anadia Anadia 6 7 4 13
3 Canelas 2010 Canelas 2010 6 3 7 13
4 Lusitania FC Lusitania 6 2 4 12
5 AD Sanjoanense Sanjoanense 6 11 5 18
6 São João Ver São João 6 8 7 15
7 Montalegre Montalegre 6 11 14 9
8 Pevidém Pevidém 6 7 11 6
9 Amora FC Amora FC 6 7 7 15
10 Cova Piedade Cova Piedade 6 7 5 13
11 Caldas Caldas 6 8 10 12
12 União Santarém União 6 9 9 11
13 Oliveira Hospital Oliveira 6 7 3 17
14 Real Sport Clube Real Sport. 6 4 3 16
15 Sporting CP II Sporting 6 6 8 10
16 Oriental Dragon Oriental 6 4 7 4
TEMPORADA 2020/2021
CAMPEONATO DE PORTUGAL GRUPO 1
Equipo PJ GF GC Puntos
1 Sporting Braga II Sporting 22 61 12 55
2 Merelinense Merelinense 22 34 13 48
3 Montalegre Montalegre 22 36 24 38
4 Mirandela Mirandela 22 24 16 35
5 Maria da Fonte Maria Fonte 22 30 29 32
6 Vianense Vianense 22 26 28 32
7 Länk Vilaverdense Länk 22 28 30 28
8 Pedras Salgadas Pedras 22 19 23 26
9 Vidago Vidago 22 27 36 23
10 Braganca Braganca 22 16 25 20
11 Cerveira Cerveira 22 11 27 15
12 Águia FC Vimioso Águia 22 12 61 8
TEMPORADA 2019/2020
CAMPEONATO DE PORTUGAL GRUPO 1
Equipo PJ GF GC Puntos
1 Vizela Vizela 25 64 20 60
2 Fafe Fafe 25 34 18 52
3 Vitória SC B Vitória 25 52 28 48
4 Sporting Braga II Sporting 25 48 25 46
5 AR São Martinho São 24 43 25 43
6 Merelinense Merelinense 25 42 31 43
7 Maria da Fonte Maria Fonte 25 45 29 40
8 Marítimo II Marítimo 25 46 37 39
9 Montalegre Montalegre 25 39 32 37
10 Chaves II Chaves II 25 44 39 31
11 Mirandela Mirandela 25 26 33 30
12 União Madeira União 25 35 52 30
13 Berco Berco 23 34 35 29
14 Pedras Salgadas Pedras 25 25 43 26
15 Cerveira Cerveira 24 24 56 20
16 Braganca Braganca 25 24 36 17
17 Oliveirense Oliveirense 25 21 43 16
18 Câmara de Lobos Câmara 25 15 79 8
TEMPORADA 2018/2019
CAMPEONATO DE PORTUGAL GRUPO 1
Equipo PJ GF GC Puntos
1 Vizela Vizela 34 73 14 76
2 Fafe Fafe 34 62 27 73
3 AR São Martinho São 34 56 24 72
4 Gil Vicente Gil Vicente 34 65 30 70
5 Trofense Trofense 34 64 29 70
6 Felgueiras 1932 Felgueiras 34 57 35 67
7 Mirandela Mirandela 34 51 43 52
8 Chaves II Chaves II 34 57 48 48
9 Merelinense Merelinense 34 38 38 44
10 Montalegre Montalegre 34 41 54 43
11 Maria da Fonte Maria Fonte 34 45 54 40
12 Pedras Salgadas Pedras 34 43 58 39
13 Oliveirense Oliveirense 34 40 58 37
14 Os Limianos Os Limianos 34 31 52 37
15 Torcatense Torcatense 34 30 63 29
16 Desportivo Mirandês Desportivo 34 26 58 21
17 Caçadores das Taipas Caçadores 34 28 67 21
18 Länk Vilaverdense Länk 34 30 85 15
TEMPORADA 2017/2018
CAMPEONATO DE PORTUGAL GRUPO 1
Equipo PJ GF GC Puntos
1 Vizela Vizela 30 53 11 73
2 Länk Vilaverdense Länk 30 65 29 64
3 Fafe Fafe 30 42 19 60
4 Mirandela Mirandela 30 42 26 57
5 Merelinense Merelinense 30 60 29 53
6 AR São Martinho São 30 46 31 49
7 Oliveirense Oliveirense 30 41 27 44
8 Montalegre Montalegre 30 39 38 38
9 Pedras Salgadas Pedras 30 32 35 38
10 Torcatense Torcatense 30 28 36 38
11 Braganca Braganca 30 31 43 33
12 Câmara de Lobos Câmara 30 27 54 30
13 Atlético Arcos Atlético 30 28 55 26
14 Arões Arões 30 25 41 24
15 Mondinense Mondinense 30 27 68 23
16 Minas de Argozelo Minas 30 24 68 11
TEMPORADA 2016/2017
CAMPEONATO DE PORTUGAL GRUPO 1
Equipo PJ GF GC Puntos
1 Merelinense Merelinense 18 39 10 45
2 Länk Vilaverdense Länk 18 38 15 38
3 Oliveirense Oliveirense 18 38 24 38
4 Braganca Braganca 18 38 29 34
5 Montalegre Montalegre 18 23 30 21
6 Torcatense Torcatense 18 18 28 21
7 Mirandela Mirandela 18 17 24 18
8 Pedras Salgadas Pedras 18 19 32 17
9 Os Limianos Os Limianos 18 16 34 11
10 Ponte da Barca Ponte Barca 18 14 34 10
TEMPORADA 2014/2015
AF VILA REAL DIVISÃO HONRA
Equipo PJ GF GC Puntos
1 Mondinense Mondinense 26 89 22 68
2 Montalegre Montalegre 26 101 19 67
3 Regua Regua 26 69 39 52
4 Vila Pouca Vila Pouca 26 54 26 44
5 Valpaços GD Valpaços 26 56 39 42
6 Cerva GD Cerva GD 26 49 37 42
7 Ribeira Pena Ribeira Pena 26 42 41 42
8 Abambres Abambres 26 64 48 40
9 Vilar de Perdizes Vilar 26 37 41 33
10 Noura Noura 26 34 56 24
11 Mesão Frio Mesão Frio 26 36 57 23
12 Atei Atei 26 26 69 23
13 Sabroso Sabroso 26 25 77 14
14 Fontelas FC Fontelas FC 26 12 123 7

  USO DE MEMORIA  
6,114,984 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0019
Controller Execution Time ( Home / Category )  0.6765
Total Execution Time  0.6785
  CADENA URL  
/historico/Montalegre
  GET DATOS  
$_GET['/historico/Montalegre']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (36)  
0.0161  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 = 'Montalegre' 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.0151  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=26824 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0149  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=26824 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0145  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=26824 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0145  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=26824 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0144  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=26824 AND type_rel = 2
0.0144  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=223 AND type_rel = 3
0.0149  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 3 AND rel.typeId = 223 AND rel.ln = 'es' AND rel.status=1 ORDER BY rel.creation_date desc,rel.cover_points DESC LIMIT 5
0.0147  SELECT /*53 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 (766202,1223712,1215282,1200312,1020735) ORDER BY n.cover_points DESC, update_date DESC
0.0149  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 = '26824' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0146  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 = 73484 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0149  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=26824 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0145  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 (73560,73484,71432,71411) 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.0151  SELECT count(id) as num_players from rel_players WHERE league_id = 71411 AND teamId = 26824
0.0148  SELECT count(id) as num_players from rel_players WHERE league_id = 73484 AND teamId = 26824
0.0160  SELECT count(id) as num_players from rel_players WHERE league_id = 73560 AND teamId = 26824
0.0156  SELECT count(id) as num_players from rel_players WHERE league_id = 71432 AND teamId = 26824
0.0152  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 = 73484 AND t.round = 26 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0151  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 = '26824' 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 = '26824' and rp.type = 4
0.0148  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 = '26824' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0196  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 = 73484 WHERE rp.league_id = 73484 AND rp.teamId = 26824 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.0199  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 = 73484 WHERE rp.league_id = 73484 AND rp.teamId = 26824 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0193  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 = 73484 WHERE rp.league_id = 73484 AND rp.teamId = 26824 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0190  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 = 26824 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
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 `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 = 68264 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.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 `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 = 71411 AND t.round = 6 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 = 63379 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.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 = 66939 AND t.round = 6 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 `tables2021` 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 = 62231 AND t.round = 6 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 `tables2021` 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 = 58698 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.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 `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 = 50950 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.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 `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 = 44596 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 `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 = 39611 AND t.round = 30 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 `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 = 34050 AND t.round = 18 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 `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 = 5836 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC