4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del Liceo de Monelos
TEMPORADA 2023/2024
TERCERA GALICIA GRUPO 1
Equipo PJ GF GC Puntos
1 C Deportivo Cristal Deportivo 0 0 0 0
2 Cd Calasanz Cd Calasanz 0 0 0 0
3 CD Ciudad CD Ciudad 0 0 0 0
4 Coruña Arboco Club de Fútbo Coruña 0 0 0 0
5 Eiris SD Eiris SD 0 0 0 0
6 Galicia Gaiteira Galicia 0 0 0 0
7 Imperator OAR Imperator 0 0 0 0
8 Liceo de Monelos Liceo 0 0 0 0
9 Maravillas S.D. Maravillas 0 0 0 0
10 S.D. Santa Margarita S.D. Santa. 0 0 0 0
11 Sada Atlético Club Futbol Sada 0 0 0 0
12 SCD Ciudad Jardín Ciudad 0 0 0 0
13 Sin Querer Sin Querer 0 0 0 0
14 Sporting Coruñés Sporting 0 0 0 0
15 Unión Sportiva Unión 0 0 0 0
16 Vioño CF Vioño CF 0 0 0 0
TEMPORADA 2022/2023
TERCERA GALICIA GRUPO 1
Equipo PJ GF GC Puntos
1 Sporting Coruñés Sporting 30 114 22 73
2 Marte CD Marte CD 30 87 29 73
3 Imperator OAR Imperator 30 107 36 65
4 Liceo de Monelos Liceo 30 96 42 63
5 Atletico Arteixo B Atletico 30 94 43 62
6 Maravillas S.D. Maravillas 30 104 47 60
7 Coruña Arboco Club de Fútbo Coruña 30 66 39 58
8 SCD Ciudad Jardín Ciudad 30 85 57 43
9 Sin Querer Sin Querer 29 51 59 36
10 CD Ciudad CD Ciudad 30 56 56 35
11 Eiris SD Eiris SD 30 59 62 35
12 S.D. Santa Margarita S.D. Santa. 30 72 83 33
13 Vioño CF Vioño CF 29 34 96 19
14 Unión Sportiva Unión 30 44 99 17
15 Galicia Gaiteira Galicia 30 25 157 8
16 C Deportivo Cristal Deportivo 30 31 198 6
TEMPORADA 2021/2022
TERCERA GALICIA GRUPO 1
Equipo PJ GF GC Puntos
1 Sin Querer Sin Querer 24 59 31 55
2 Sada Atlético Club Futbol Sada 24 62 41 49
3 CD Ciudad CD Ciudad 24 64 27 47
4 Eiris SD Eiris SD 24 56 27 45
5 Maravillas S.D. Maravillas 24 55 36 42
6 Liceo de Monelos Liceo 24 52 29 41
7 S.D. Santa Margarita S.D. Santa. 24 50 36 40
8 SCD Ciudad Jardín Ciudad 24 43 31 33
9 Coruña Arboco Club de Fútbo Coruña 24 51 54 32
10 Unión Sportiva Unión 24 50 69 26
11 C Deportivo Cristal Deportivo 24 48 68 22
12 Vioño CF Vioño CF 24 28 74 8
13 Galicia Gaiteira Galicia 24 24 119 4
TEMPORADA 2019/2020
TERCERA GALICIA GRUPO 1
Equipo PJ GF GC Puntos
1 Marte CD Marte CD 20 46 15 45
2 Atlético dos Castros Atlético 19 58 31 42
3 Sin Querer Sin Querer 19 62 14 41
4 Cd Calasanz Cd Calasanz 20 44 29 38
5 Unión Sportiva Unión 20 47 36 36
6 Galicia Gaiteira Galicia 20 46 31 32
7 CD Ciudad CD Ciudad 20 51 30 31
8 SCD Ciudad Jardín Ciudad 20 41 44 29
9 Maravillas S.D. Maravillas 20 30 52 23
10 S.D. Santa Margarita S.D. Santa. 20 24 56 21
11 Liceo de Monelos Liceo 19 22 44 16
12 Vioño CF Vioño CF 20 29 52 15
13 Eiris SD Eiris SD 19 22 57 13
14 C Deportivo Cristal Deportivo 20 23 54 11
TEMPORADA 2018/2019
TERCERA GALICIA GRUPO 1
Equipo PJ GF GC Puntos
1 Oza Juvenil S.D. Juvenil S.D. 28 89 23 74
2 Marte CD Marte CD 28 79 30 66
3 Sin Querer Sin Querer 28 94 40 64
4 SCD Ciudad Jardín Ciudad 28 84 40 54
5 Galicia Gaiteira Galicia 28 79 35 54
6 Atlético dos Castros Atlético 28 80 47 50
7 Cd Calasanz Cd Calasanz 28 71 60 42
8 Maravillas S.D. Maravillas 28 58 71 40
9 Liceo de Monelos Liceo 28 54 65 38
10 Unión Sportiva Unión 28 51 65 35
11 Deportivo Orzán Deportivo 28 45 59 31
12 S.D. Santa Margarita S.D. Santa. 28 54 79 26
13 Vioño CF Vioño CF 28 39 91 15
14 Eiris SD Eiris SD 28 40 85 14
15 C Deportivo Cristal Deportivo 28 26 153 3
TEMPORADA 2017/2018
TERCERA GALICIA GRUPO 3
Equipo PJ GF GC Puntos
1 Español SDC Español 30 94 20 76
2 San Martiño Martiño 30 111 24 72
3 Once Caballeros Once 30 88 35 64
4 Olímpico C.F. B Olímpico 30 75 26 61
5 Xuventude de Crendes Xuventude 30 88 47 57
6 Vila de Ordes Vila Ordes 30 64 37 54
7 Sporting Burgo Sporting 30 87 50 49
8 Atlético dos Castros Atlético 30 76 54 48
9 S.D. Santa Margarita S.D. Santa. 30 81 45 45
10 Cd Calasanz Cd Calasanz 30 56 59 35
11 Ponte Carreira Ponte 30 74 82 28
12 Liceo de Monelos Liceo 29 59 73 26
13 Encrobas CF Encrobas CF 30 57 85 23
14 Abella B Abella B 30 35 65 23
15 Vioño CF Vioño CF 30 55 99 20
16 C. Deportivo Cristal Deportivo 29 6 255 0
TEMPORADA 2016/2017
TERCERA GALICIA GRUPO 1
Equipo PJ GF GC Puntos
1 Relámpago S.D. Relámpago 31 144 19 84
2 Español SDC Español 33 104 20 84
3 CD Ciudad CD Ciudad 33 107 36 71
4 Atlético dos Castros Atlético 32 101 55 62
5 C.D. Sarsfield C.D. 32 100 50 60
6 Liceo de Monelos Liceo 32 86 46 56
7 Orzán Sd Orzán Sd 32 82 44 53
8 Marte CD Marte CD 33 71 67 53
9 Cd Calasanz Cd Calasanz 33 81 47 52
10 Galicia Gaiteira Galicia 33 81 58 51
11 Eiris SD Eiris SD 33 87 89 46
12 Oza Juvenil S.D. Juvenil S.D. 33 58 85 30
13 S.D. Santa Margarita S.D. Santa. 32 64 83 28
14 C. Compañía de María Compañía 32 60 127 25
15 Unión Sportiva Unión 33 50 159 21
16 Miguel Rua-Don Bosco Miguel 33 44 93 19
17 Peñarredonda Peñarredond 11 30 26 13
18 C. Deportivo Cristal Deportivo 33 10 255 1
TEMPORADA 2015/2016
SEGUNDA GALICIA GRUPO 1
Equipo PJ GF GC Puntos
1 Universidade Universidade 33 99 15 87
2 Torre SD Torre SD 32 95 36 71
3 Sporting Coruñés Sporting 33 87 43 67
4 SCD Ciudad Jardín Ciudad 33 77 40 67
5 Sin Querer Sin Querer 32 58 43 65
6 CD Ciudad CD Ciudad 33 80 43 62
7 Español SDC Español 33 62 33 61
8 Galicia Gaiteira Galicia 33 73 63 58
9 Relámpago S.D. Relámpago 33 77 56 53
10 Oza Juvenil S.D. Juvenil S.D. 33 55 48 50
11 Atlético dos Castros Atlético 33 68 85 32
12 C.D. Sarsfield C.D. 33 50 97 29
13 Cd Calasanz Cd Calasanz 32 45 79 26
14 Marte CD Marte CD 33 49 90 26
15 Orzán Sd Orzán Sd 32 36 73 25
16 Marola CF Marola CF 33 37 88 22
17 A Cocteleira C.F. Cocteleira 17 24 43 16
18 Liceo de Monelos Liceo 33 20 117 3
TEMPORADA 2014/2015
SEGUNDA GALICIA GRUPO 1
Equipo PJ GF GC Puntos
1 Maravillas S.D. Maravillas 33 85 33 81
2 Sporting Coruñés Sporting 33 86 25 80
3 Español SDC Español 34 96 26 79
4 Cd Calasanz Cd Calasanz 34 88 46 67
5 SCD Ciudad Jardín Ciudad 34 75 44 57
6 San Cristóbal Viñas Cristóbal 34 74 48 54
7 Torre SD Torre SD 34 73 52 54
8 Universidade Universidade 34 58 44 50
9 Galicia Gaiteira Galicia 34 77 65 49
10 Orzán Sd Orzán Sd 34 49 49 44
11 A Cocteleira C.F. Cocteleira 33 77 68 43
12 Relámpago S.D. Relámpago 33 46 60 42
13 Oza Juvenil S.D. Juvenil S.D. 34 49 53 41
14 Atlético dos Castros Atlético 34 47 64 38
15 C.D. Sarsfield C.D. 34 61 95 36
16 Liceo de Monelos Liceo 34 54 92 28
17 Unión Sportiva Unión 33 29 176 8
18 S.D. Santa Margarita S.D. Santa. 33 35 119 7

  USO DE MEMORIA  
5,733,840 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0018
Controller Execution Time ( Home / Category )  0.0947
Total Execution Time  0.0966
  CADENA URL  
/historico/Liceo-De-Monelos
  GET DATOS  
$_GET['/historico/Liceo-De-Monelos']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (28)  
0.0027  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 = 'Liceo-De-Monelos' 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.0019  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=19852 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=19852 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=19852 AND type_rel = 2
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 = '19852' 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 = '19852' AND l.year = 2024 ORDER BY l.year DESC,cat.coefficient DESC
0.0021  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 = '19852' 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=19852 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0018  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 (73754) 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 = 73754 AND teamId = 19852
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 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 = 73754 AND t.round = 27 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
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 = '19852' 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 = '19852' 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 = '19852' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0020  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 = 73754 WHERE rp.league_id = 73754 AND rp.teamId = 19852 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.0020  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 = 73754 WHERE rp.league_id = 73754 AND rp.teamId = 19852 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 events2024 e ON e.player_id = p.id AND e.league_id = 73754 WHERE rp.league_id = 73754 AND rp.teamId = 19852 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0023  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 = 19852 AND l.year <= 2024 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 `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 = 73754 AND t.round = 27 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 `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 = 69299 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.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 `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 = 65415 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.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 = 51549 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 = 45269 AND t.round = 30 ORDER BY team.conference 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 `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 = 39853 AND t.round = 30 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 = 35500 AND t.round = 34 ORDER BY team.conference 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 `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 = 16816 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 `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 = 4343 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0020  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 = 73754 ORDER BY nameShow LIMIT 100