4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del Mesia CD
TEMPORADA 2019/2020
TERCERA GALICIA GRUPO 3
Equipo PJ GF GC Puntos
1 Mesia CD Mesia CD 19 46 20 44
2 Teixeiro Teixeiro 17 47 21 39
3 X Aranga X Aranga 19 56 31 37
4 Sporting Meicende B Sporting 18 50 28 30
5 Curtis CCD Curtis CCD 18 35 35 29
6 Ponte Carreira Ponte 17 32 21 28
7 Vila de Ordes Vila Ordes 17 38 27 27
8 Sobrado Xuventude Sobrado 18 31 39 22
9 Ordenes B Ordenes B 18 21 33 20
10 SD Vilasantar Vilasantar 17 15 17 19
11 Abella B Abella B 17 27 44 16
12 Vizoño B Vizoño B 18 35 57 12
13 Visantoña CF. B Visantoña 17 15 75 3
TEMPORADA 2018/2019
TERCERA GALICIA GRUPO 2
Equipo PJ GF GC Puntos
1 Xuventude de Crendes Xuventude 24 87 24 59
2 Mesia CD Mesia CD 24 66 27 53
3 Curtis CCD Curtis CCD 24 78 34 52
4 Ordenes B Ordenes B 24 47 38 46
5 X Aranga X Aranga 24 60 39 42
6 Ponte Carreira Ponte 24 49 45 40
7 Sobrado Xuventude Sobrado 24 45 59 35
8 Teixeiro Teixeiro 24 43 40 29
9 Vila de Ordes Vila Ordes 24 50 51 29
10 Sporting Meicende B Sporting 24 36 55 25
11 Visantoña CF. B Visantoña 24 22 74 17
12 Mercurio Mercurio 24 30 68 15
13 Abella B Abella B 24 24 83 8
TEMPORADA 2017/2018
SEGUNDA GALICIA GRUPO 1
Equipo PJ GF GC Puntos
1 Sporting Ciudad AC y D Sporting 34 88 35 77
2 Imperator OAR Imperator 33 73 52 72
3 Vizoño Vizoño 33 76 36 65
4 Club do Mar de Caion Club Caion 34 68 41 63
5 Torre SD Torre SD 33 67 47 62
6 Visantoña Visantoña 34 53 43 51
7 Sporting Meicende Sporting 34 49 56 47
8 Marino CF Marino CF 34 61 48 45
9 Sporting Coruñés Sporting 34 67 66 45
10 Relámpago S.D. Relámpago 33 46 45 45
11 Santa Cruz C.F. Santa Cruz. 33 76 78 45
12 C.D. Larín C.D. Larín 33 59 60 42
13 Carnoedo Carnoedo 34 57 63 42
14 Culleredo Culleredo 33 50 60 42
15 Mesia CD Mesia CD 33 52 74 35
16 Tambre FC Tambre FC 26 36 56 28
17 Sin Querer Sin Querer 34 33 83 22
18 SCD Ciudad Jardín Ciudad 34 37 105 8
TEMPORADA 2016/2017
SEGUNDA GALICIA GRUPO 1
Equipo PJ GF GC Puntos
1 Orillamar SD Orillamar 34 105 29 81
2 Atletico San Pedro Atletico 34 79 34 76
3 Sporting Cambre Sporting 34 67 27 70
4 Vizoño Vizoño 34 80 54 60
5 Torre SD Torre SD 34 59 54 52
6 Santa Cruz C.F. Santa Cruz. 34 66 62 52
7 Carnoedo Carnoedo 34 56 54 50
8 Sporting Coruñés Sporting 34 56 69 50
9 SCD Ciudad Jardín Ciudad 34 62 49 49
10 Visantoña Visantoña 34 64 55 47
11 Imperator OAR Imperator 34 52 50 44
12 Mesia CD Mesia CD 34 47 56 41
13 Sin Querer Sin Querer 34 48 64 41
14 Sporting Burgo Sporting 34 50 78 37
15 San Martiño Martiño 34 38 51 35
16 Xuventude Dorneda Xuventude 34 50 83 33
17 Maravillas S.D. Maravillas 34 41 83 26
18 Vioño CF Vioño CF 34 47 115 11
TEMPORADA 2015/2016
SEGUNDA GALICIA GRUPO 2
Equipo PJ GF GC Puntos
1 Queixas Queixas 33 89 27 69
2 Cire Melide Cire Melide 33 72 34 69
3 Portazgo S.D. Portazgo 34 75 34 67
4 Visantoña Visantoña 34 68 41 63
5 Carnoedo Carnoedo 34 66 51 60
6 Vizoño Vizoño 33 60 48 56
7 Sporting Cambre Sporting 34 63 42 55
8 Atletico San Pedro Atletico 34 58 46 54
9 Santa Cruz C.F. Santa Cruz. 32 57 44 52
10 San Martiño Martiño 34 55 55 48
11 Mesia CD Mesia CD 33 49 49 44
12 CD Obrero CD Obrero 34 57 64 43
13 Suevos CF Suevos CF 34 55 63 41
14 Once Caballeros Once 34 43 82 30
15 Sporting Meicende Sporting 33 56 85 30
16 C.D. Larín C.D. Larín 34 46 82 28
17 Bribes CF Bribes CF 33 40 97 26
18 Ozacesuras Ozacesuras 34 36 101 10
TEMPORADA 2014/2015
TERCERA GALICIA GRUPO 3
Equipo PJ GF GC Puntos
1 Mesia CD Mesia CD 30 87 32 74
2 Bribes CF Bribes CF 30 66 36 59
3 Mesón Do Bento Mesón Bento 30 59 44 56
4 Tambre FC Tambre FC 30 72 41 55
5 Abella B Abella B 30 65 50 51
6 Curtis CCD Curtis CCD 30 60 48 47
7 Once Caballeros B Once 30 54 78 32
8 Encrobas CF Encrobas CF 30 35 53 29
9 Ponte Carreira Ponte 30 45 70 26
10 Sobrado Xuventude Sobrado 30 41 66 26
11 Vizoño B Vizoño B 30 29 95 11
12 Toques CF Toques CF 0 0 0 0

  USO DE MEMORIA  
5,275,080 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0012
Controller Execution Time ( Home / Category )  0.1023
Total Execution Time  0.1035
  CADENA URL  
/historico/Mesia-Cd/2020
  GET DATOS  
$_GET['/historico/Mesia-Cd/2020']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (29)  
0.0059  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 = 'Mesia-Cd' AND l.year = 2020 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.0023  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=27507 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0021  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=27507 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0053  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 = 51551
0.0019  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=27507 AND type_rel = 2
0.0019  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=715 AND type_rel = 3
0.0023  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 3 AND rel.typeId = 715 AND rel.ln = 'es' AND rel.status=1 ORDER BY rel.creation_date desc,rel.cover_points DESC LIMIT 5
0.0027  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 (792499,697535,370510,219172,57995) ORDER BY n.cover_points DESC, update_date DESC
0.0027  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 = '27507' AND l.year = 2020 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 = '27507' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0024  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 = 51551 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0024  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=27507 AND l.year in (2019,2020,2021) 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 (51551) 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.0020  SELECT count(id) as num_players from rel_players WHERE league_id = 51551 AND teamId = 27507
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 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 = 51551 AND t.round = 20 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0020  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 = '27507' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0019  SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '27507' and rp.type = 4
0.0020  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 = '27507' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0019  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 events2020 e ON e.player_id = p.id AND e.league_id = 51551 WHERE rp.league_id = 51551 AND rp.teamId = 27507 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.0019  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 events2020 e ON e.player_id = p.id AND e.league_id = 51551 WHERE rp.league_id = 51551 AND rp.teamId = 27507 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0019  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 events2020 e ON e.player_id = p.id AND e.league_id = 51551 WHERE rp.league_id = 51551 AND rp.teamId = 27507 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0021  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 = 27507 AND l.year <= 2020 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
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 `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 = 51551 AND t.round = 20 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 `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 = 45270 AND t.round = 26 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 `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 = 39821 AND t.round = 34 ORDER BY team.conference 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 `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 = 34932 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 `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 = 16817 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 `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 = 5007 AND t.round = 33 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0019  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 = 51551 ORDER BY nameShow LIMIT 100