4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del Cire de Melide
TEMPORADA 2022/2023
1ª CADETE AUTO. GALICIA GRUPO 5
Equipo PJ GF GC Puntos
1 Cidade de Ribeira CF Cidade 34 149 20 93
2 Cire de Melide Cire Melide 34 125 35 84
3 Escola Estrada Futbol Base Escola 34 134 36 82
4 Victoria CF Victoria CF 34 125 40 78
5 Bertamirans B Bertamirans 34 119 47 74
6 Efm Concello de Boiro B Concello 34 79 63 60
7 Villestro Villestro 34 90 86 50
8 Escola de Futbol Silleda Escola 34 63 74 46
9 Sociedade Deportiva O Pino Sociedade 34 72 79 45
10 Xuventu Aguiño Xuventu 34 68 77 44
11 Compostela B Compostela 34 71 79 43
12 Noia Noia 34 64 72 41
13 Cacheiras Cacheiras 34 50 88 35
14 Ulla Pontecesures CF Ulla 34 62 124 29
15 Porto do Son Porto 34 47 97 28
16 Conxo Santiago C Conxo 34 37 110 21
17 Bastavales UD Bastavales 34 38 144 18
18 Nicrariense Nicrariense 34 24 146 5
TEMPORADA 2021/2022
1ª CADETE AUTO. GALICIA GRUPO 1
Equipo PJ GF GC Puntos
1 EF Lalín EF Lalín 18 58 22 46
2 Compostela B Compostela 18 47 14 40
3 Villestro Villestro 18 53 32 39
4 Victoria CF Victoria CF 18 62 28 38
5 Escola de Futbol Silleda Escola 18 36 52 20
6 Cire de Melide Cire Melide 18 35 36 17
7 Conxo Santiago C Conxo 18 24 54 17
8 Atletico Fatima Atletico 18 37 58 12
9 Compañia de Maria Compañia 18 24 46 12
10 Club Escolas Deportivas de Club Escolas 18 19 53 11
TEMPORADA 2018/2019
2ª GALICIA CADETE GRUPO 6
Equipo PJ GF GC Puntos
1 Victoria CF B Victoria 28 120 33 74
2 Club Escolas Deportivas de Club Escolas 28 116 32 68
3 Conxo Santiago C Conxo 28 104 39 65
4 Cire de Melide Cire Melide 28 101 55 58
5 Compostela B Compostela 28 82 39 54
6 Escola Futbol Boqueixon Escola 28 83 49 49
7 Dep Arzua Dep Arzua 28 65 69 42
8 Sporting Estrada B Sporting 28 64 53 41
9 Ed Xuventude Oroso C Xuventude 28 56 55 40
10 Escola de Futbol Silleda Escola 28 63 99 25
11 Tordoia CF Tordoia CF 28 25 77 19
12 Touro Touro 28 37 97 19
13 Milladoiro B Milladoiro 28 39 127 18
14 Cruces Cruces 28 36 100 14
15 Amio C Amio C 28 24 91 12
16 Bandeira Bandeira 0 0 0 0
TEMPORADA 2017/2018
2ª GALICIA CADETE GRUPO 6
Equipo PJ GF GC Puntos
1 O Pino O Pino 22 116 33 61
2 Escola de Futbol Silleda Escola 22 89 30 53
3 Cruces Cruces 22 72 41 46
4 Cire de Melide Cire Melide 22 88 40 43
5 Ed Val Do Ulla Ribadul Ulla Ribadul 22 68 49 40
6 SR Calo SR Calo 22 75 72 32
7 Sporting Estrada B Sporting 22 56 60 32
8 Milladoiro B Milladoiro 22 61 57 28
9 Escola Futbol Boqueixon Escola 22 48 55 28
10 Cacheiras Cacheiras 22 34 81 15
11 Touro Touro 22 23 99 8
12 San Mamed San Mamed 22 30 143 0
TEMPORADA 2016/2017
2ª GALICIA CADETE GRUPO 6
Equipo PJ GF GC Puntos
1 Bertamirans C Bertamirans 18 91 21 47
2 Escuela de Futbol Silled Escuela 18 108 13 39
3 Cire de Melide Cire Melide 18 63 14 39
4 Ed Val Do Ulla Ribadul Ulla Ribadul 18 65 26 35
5 Milladoiro B Milladoiro 18 72 30 33
6 Dubra SD Dubra SD 18 48 28 32
7 Praiña Sporting Club Praiña 18 30 73 14
8 Touro Touro 18 25 80 12
9 Escola Futbol Boqueixon Escola 18 13 108 7
10 San Mamed San Mamed 18 15 137 6
11 Sporting Estrada B Sporting 0 0 0 0
TEMPORADA 2015/2016
2ª GALICIA CADETE GRUPO 6
Equipo PJ GF GC Puntos
1 Cruces Cruces 20 92 31 52
2 Touro Touro 20 80 13 50
3 Escuela de Futbol Silled Escuela 20 98 18 49
4 Negreira Negreira 20 52 25 36
5 Cire de Melide Cire Melide 20 50 45 32
6 Bertamirans C Bertamirans 20 36 60 22
7 Sporting Estrada B Sporting 20 22 56 22
8 Milladoiro B Milladoiro 20 38 62 19
9 Callobre B Callobre B 20 24 48 19
10 San Mamed San Mamed 20 21 80 11
11 Praiña Sporting Club Praiña 20 17 92 4
12 Escola Futbol Boqueixon Escola 0 0 0 0
TEMPORADA 2014/2015
2ª GALICIA CADETE GRUPO 6
Equipo PJ GF GC Puntos
1 Amio B Amio B 24 80 22 59
2 Escuela Deportiva Arzua Escuela 24 85 28 56
3 Cruces SD Cruces SD 24 85 31 53
4 Milladoiro B Milladoiro 24 65 40 45
5 Silled EF Silled EF 24 52 33 38
6 Bertamirans C Bertamirans 24 55 37 38
7 Sporting Estrada B Sporting 24 58 55 38
8 Lalin EF C Lalin EF C 24 53 55 37
9 O Pino SD O Pino SD 24 53 54 29
10 Cire de Melide Cire Melide 24 38 91 17
11 Atletico de Melide Atletico 24 19 77 15
12 Boqueixon EF Boqueixon 24 26 84 13
13 San Mamed CD Mamed 24 30 92 13
14 Praiña SC Praiña SC 0 0 0 0

  USO DE MEMORIA  
5,201,032 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0020
Controller Execution Time ( Home / Category )  0.3991
Total Execution Time  0.4011
  CADENA URL  
/historico/Cire-De-Melide-Cadete
  GET DATOS  
$_GET['/historico/Cire-De-Melide-Cadete']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (22)  
0.0261  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 = 70071
0.0129  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=28278 AND type_rel = 2
0.0131  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=792 AND type_rel = 3
0.0135  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 3 AND rel.typeId = 792 AND rel.ln = 'es' AND rel.status=1 ORDER BY rel.creation_date desc,rel.cover_points DESC LIMIT 5
0.0138  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 (64088,63213) ORDER BY n.cover_points DESC, update_date DESC
0.0134  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 = '28278' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0133  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 = 70071 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0135  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=28278 AND l.year in (2022,2023,2024) ORDER BY l.id DESC, l.year DESC ;
0.0129  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 (70071) 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.0128  SELECT count(id) as num_players from rel_players_base WHERE league_id = 70071 AND teamId = 28278
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 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 = 70071 AND t.round = 34 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0134  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 = '28278' 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 = '28278' and rp.type = 4
0.0126  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 = '28278' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0127  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 = 28278 AND l.year <= 2023 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 `tables2023_base` 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 = 70071 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_base` 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 = 65431 AND t.round = 18 ORDER BY team.conference ASC,t.position 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 `tables2019_base` 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 = 46090 AND t.round = 30 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_base` 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 = 40512 AND t.round = 22 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0133  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_base` 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 = 35087 AND t.round = 22 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0134  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_base` 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 = 17249 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 = 5067 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC