4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del Resmon
TEMPORADA 2023/2024
TERCERA GALICIA GRUPO 6
Equipo PJ GF GC Puntos
1 Amio CF Amio CF 24 73 20 60
2 EDS Santa Marta Santa Marta 24 79 25 56
3 Racing San Lorenzo Racing 24 69 19 53
4 Atlético Fátima Atlético 24 64 36 48
5 Milladoiro SD Milladoiro 24 55 29 45
6 Deixebre Deixebre 24 54 34 43
7 Brion SD Brion SD 24 39 40 30
8 Biduido Biduido 24 44 53 27
9 Burgo Das Nacions Burgo 24 41 54 25
10 Santa Cruz de Montaos Santa Cruz. 24 29 47 25
11 Atletico Orosino Atletico 24 32 59 19
12 Resmon Resmon 24 32 63 13
13 Trazo CF B Trazo CF B 24 9 141 0
TEMPORADA 2022/2023
TERCERA GALICIA GRUPO 7
Equipo PJ GF GC Puntos
1 Tordoia B Tordoia B 28 56 20 63
2 EDS Santa Marta Santa Marta 28 84 35 61
3 Amio CF Amio CF 27 65 24 59
4 Victoria CF Victoria CF 28 91 44 57
5 Deixebre Deixebre 28 68 35 52
6 Racing San Lorenzo Racing 28 68 49 47
7 Resmon Resmon 28 59 47 46
8 Brion SD Brion SD 27 60 41 45
9 Atletico Orosino Atletico 28 33 52 36
10 Atlético Fátima Atlético 27 54 49 35
11 La Salle La Salle 28 41 55 30
12 Vista Alegre B Vista Alegre 28 65 80 29
13 Santiso UD Santiso UD 28 51 86 19
14 Biduido Biduido 28 34 86 16
15 CS Galeras CS Galeras 27 13 139 0
TEMPORADA 2021/2022
TERCERA GALICIA GRUPO 7
Equipo PJ GF GC Puntos
1 Milladoiro SD Milladoiro 21 71 16 55
2 Victoria CF Victoria CF 22 62 32 46
3 Sar Extramundi Extramundi 22 72 29 44
4 Tordoia B Tordoia B 22 43 30 37
5 Biduido Biduido 22 54 47 33
6 Resmon Resmon 22 38 45 32
7 Brion SD Brion SD 22 33 32 28
8 Campo da Angustia Campo 22 40 44 28
9 La Salle La Salle 21 33 42 28
10 Vista Alegre B Vista Alegre 21 34 43 24
11 Portomouro Portomouro 21 15 69 7
12 Atletico Orosino Atletico 22 10 76 7
TEMPORADA 2019/2020
TERCERA GALICIA GRUPO 7
Equipo PJ GF GC Puntos
1 Rois Rois 19 51 9 47
2 Carcacía Carcacía 18 47 13 42
3 Val Do Ulla B Ulla 19 32 23 36
4 Milladoiro SD Milladoiro 19 48 35 32
5 Camporrapado Camporrapado 19 26 20 32
6 Viduido CF Viduido CF 18 31 25 26
7 Portomouro Portomouro 18 29 30 24
8 Brion SD Brion SD 18 29 34 23
9 Guimarei Guimarei 19 22 31 22
10 Resmon Resmon 19 34 39 21
11 AD Estudiantil Estudiantil 19 29 37 20
12 EF Boqueixon Boqueixon 19 37 52 18
13 Raris CF Raris CF 19 29 49 14
14 Calo Sr B Calo Sr B 19 22 69 12
TEMPORADA 2018/2019
TERCERA GALICIA GRUPO 7
Equipo PJ GF GC Puntos
1 Vea CF Vea CF 24 86 31 61
2 Nicrariense Nicrariense 24 69 35 53
3 Val Do Ulla B Ulla 24 57 20 50
4 Rois Rois 24 53 23 49
5 Dubra B Dubra B 24 43 37 38
6 Viduido CF Viduido CF 24 49 41 37
7 Portomouro Portomouro 24 39 35 36
8 Resmon Resmon 24 35 50 33
9 San Mamed B San Mamed B 24 32 57 18
10 EF Boqueixon Boqueixon 23 29 67 18
11 Guimarei Guimarei 24 38 56 17
12 Trazo CF B Trazo CF B 24 27 64 15
13 Raris CF Raris CF 23 22 63 10
TEMPORADA 2017/2018
TERCERA GALICIA GRUPO 7
Equipo PJ GF GC Puntos
1 Estradense B Estradense 27 83 27 68
2 Brion SD Brion SD 28 74 38 63
3 Vea CF Vea CF 28 51 26 58
4 Milladoiro SD Milladoiro 28 96 46 55
5 Viduido CF Viduido CF 28 76 45 50
6 Dubra B Dubra B 28 61 43 47
7 Escola D Val Do Ulla Ribadu Escola Ulla 28 50 47 44
8 Resmon Resmon 28 43 46 43
9 Portomouro Portomouro 28 49 60 37
10 San Mamed B San Mamed B 28 38 51 29
11 Guimarei Guimarei 28 36 54 29
12 Tordoia B Tordoia B 28 39 69 27
13 Calo Sr B Calo Sr B 28 36 73 19
14 Trazo CF B Trazo CF B 28 34 81 13
15 Raris CF Raris CF 27 26 86 10
TEMPORADA 2016/2017
TERCERA GALICIA GRUPO 6
Equipo PJ GF GC Puntos
1 Atlético Fátima Atlético 32 98 45 70
2 Deixebre Deixebre 32 81 36 70
3 Santa Cruz de Montaos Santa Cruz. 30 82 31 69
4 Peña Bodegon Arzua Peña 32 91 45 69
5 Calo SR Calo SR 32 85 39 69
6 Viduido CF Viduido CF 32 95 46 65
7 Sporting Santiago Sporting 32 64 64 42
8 Racing San Lorenzo Racing 31 62 53 41
9 Dubra B Dubra B 31 67 71 41
10 Milladoiro SD Milladoiro 32 65 75 40
11 Belvis B Belvis B 32 56 76 38
12 Resmon Resmon 32 60 60 37
13 Portomouro Portomouro 32 52 70 33
14 Burgo Das Nacions Burgo 30 65 114 26
15 Trazo CF B Trazo CF B 32 59 121 20
16 CF Vista Alegre Vista Alegre 32 38 122 14
17 Tordoia B Tordoia B 32 31 83 12
TEMPORADA 2015/2016
TERCERA GALICIA GRUPO 8
Equipo PJ GF GC Puntos
1 Zona Vella CF Zona Vella 21 53 24 45
2 Peña Bodegon Arzua Peña 21 57 28 43
3 La Salle La Salle 21 58 36 38
4 Atlético Fátima Atlético 21 40 31 36
5 Santa Cruz de Montaos Santa Cruz. 21 41 27 36
6 Resmon Resmon 21 44 33 35
7 Vila de Ordes Vila Ordes 21 39 44 30
8 Portomouro Portomouro 21 37 44 26
9 Belvis B Belvis B 21 21 47 18
10 Tordoia B Tordoia B 21 31 55 17
11 Dubra B Dubra B 21 24 48 17
12 Rial CF Rial CF 11 12 40 1
TEMPORADA 2014/2015
SEGUNDA GALICIA GRUPO 6
Equipo PJ GF GC Puntos
1 Val do Ulla Val do Ulla 34 83 26 80
2 Tordoia Tordoia 34 74 22 80
3 Chaián Chaián 34 72 28 79
4 San Mamed San Mamed 34 72 40 66
5 Laro Laro 34 82 34 63
6 Lamela Lamela 34 64 36 60
7 Belvís Belvís 34 50 41 49
8 Dptvo. San Marcos Dptvo. 34 68 71 46
9 CF Vista Alegre Vista Alegre 34 44 55 45
10 Sigueiro B Sigueiro B 34 54 61 41
11 Sporting Estrada Sporting 34 34 53 41
12 Trazo C.F. Trazo C.F. 34 47 60 38
13 Deixebre Deixebre 34 43 67 31
14 Vilatuxe F.C. Vilatuxe 34 39 68 29
15 Bandeira Bandeira 34 43 76 29
16 Resmon Resmon 34 44 73 28
17 Guimarei Guimarei 34 36 93 26
18 Portomouro Portomouro 34 46 91 22

  USO DE MEMORIA  
5,564,576 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0012
Controller Execution Time ( Home / Category )  0.4909
Total Execution Time  0.4921
  CADENA URL  
/historico/Resmon
  GET DATOS  
$_GET['/historico/Resmon']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (29)  
0.0139  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 = 'Resmon' 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.0128  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=20124 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0132  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=20124 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0260  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 = 73759
0.0126  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=20124 AND type_rel = 2
0.0130  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 = '20124' AND l.year = 2024 ORDER BY l.year DESC,cat.coefficient DESC
0.0130  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 = '20124' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0131  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 = 73759 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0140  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=20124 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0131  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 (73759) 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.0132  SELECT count(id) as num_players from rel_players WHERE league_id = 73759 AND teamId = 20124
0.0137  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 = 73759 AND t.round = 26 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0128  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 = '20124' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0125  SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '20124' and rp.type = 4
0.0130  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 = '20124' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0129  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 = 73759 WHERE rp.league_id = 73759 AND rp.teamId = 20124 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.0128  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 = 73759 WHERE rp.league_id = 73759 AND rp.teamId = 20124 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0129  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 = 73759 WHERE rp.league_id = 73759 AND rp.teamId = 20124 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0139  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 = 20124 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.0137  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 = 73759 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.0137  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 = 69307 AND t.round = 30 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0137  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 = 65422 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.0137  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 = 51556 AND t.round = 19 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0140  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 = 45275 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0137  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 = 39857 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0132  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 = 34654 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0128  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 = 16876 AND t.round = 22 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0132  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 = 4349 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0128  SELECT dt.nameShow, dt.basealias, t.id, dt.id as dt_id FROM `teams` as t INNER JOIN `datateams` as dt ON dt.id = t.teamId WHERE league_id = 73759 ORDER BY nameShow LIMIT 100