4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del Milladoiro SD
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
SEGUNDA GALICIA GRUPO 5
Equipo PJ GF GC Puntos
1 Praiña Praiña 34 67 26 82
2 Bertamiráns FC Bertamiráns 34 83 24 78
3 Valiño Cabo de Cruz Valiño Cabo 34 81 38 71
4 Urdilde Urdilde 34 66 31 68
5 Taragoña Taragoña 34 78 42 65
6 Bastavales Bastavales 34 70 60 57
7 Nicrariense Nicrariense 34 45 49 45
8 Sporting Lampón Sporting 34 51 56 45
9 Luaña SD Luaña SD 34 53 52 44
10 Dodro Dodro 34 52 53 44
11 Agron CF Agron CF 34 67 76 43
12 Lesende CFC Lousame Lesende 34 49 62 40
13 Esclavitud Esclavitud 34 40 55 39
14 Queiruga Queiruga 34 44 68 34
15 Atlético Oleiros Atlético 34 36 63 34
16 Galicia-Bealo Galicia-Beal 34 48 93 31
17 Carcacía Carcacía 34 41 81 27
18 Milladoiro SD Milladoiro 34 44 86 18
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
SEGUNDA GALICIA GRUPO 5
Equipo PJ GF GC Puntos
1 Cidade de Ribeira CF Cidade 34 91 43 75
2 Cacheiras Cacheiras 34 88 41 75
3 Lesende CFC Lousame Lesende 34 77 51 65
4 Valiño Cabo de Cruz Valiño Cabo 33 84 58 59
5 Abanqueiro SD Abanqueiro 34 80 75 59
6 Ccd Taragoña Taragoña 34 66 51 55
7 Calo SR Calo SR 34 76 77 51
8 Sálvora Sálvora 34 65 71 50
9 Urdilde Urdilde 34 61 50 49
10 Udqueiruga Udqueiruga 34 80 84 47
11 Recesende Recesende 34 53 59 43
12 Luaña SD Luaña SD 34 55 65 41
13 Agron CF Agron CF 34 53 64 40
14 Milladoiro SD Milladoiro 34 55 60 39
15 Carcacia Carcacia 34 56 71 39
16 Baroña CF Baroña CF 33 46 69 33
17 Sar Extramundi Extramundi 34 56 72 28
18 Brion SD Brion SD 34 41 122 12
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

  USO DE MEMORIA  
5,382,904 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0014
Controller Execution Time ( Home / Category )  0.4557
Total Execution Time  0.4572
  CADENA URL  
/historico/Milladoiro-Sd-Senior
  GET DATOS  
$_GET['/historico/Milladoiro-Sd-Senior']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (27)  
0.0133  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 = 'Milladoiro-Sd-Senior' 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.0125  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=92362 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0127  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=92362 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0253  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.0124  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=92362 AND type_rel = 2
0.0127  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 = '92362' AND l.year = 2024 ORDER BY l.year DESC,cat.coefficient DESC
0.0126  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 = '92362' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0126  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.0127  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=92362 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0126  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,69287) 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.0125  SELECT count(id) as num_players from rel_players WHERE league_id = 69287 AND teamId = 92362
0.0125  SELECT count(id) as num_players from rel_players WHERE league_id = 73759 AND teamId = 92362
0.0130  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.0126  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 = '92362' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0127  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 = '92362' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
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 = 92362 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 = 92362 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0126  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 = 92362 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0130  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 = 92362 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.0131  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.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 `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 = 69287 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.0130  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.0131  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.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 `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 = 45178 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0129  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.0130  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 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