4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del Canillas
TEMPORADA 2022/2023
SUPERLIGA MADRID ALEVÍN
Equipo PJ GF GC Puntos
1 Real Madrid Sub 12 Real Madrid 30 161 15 88
2 Atlético Sub 12 Atlético 30 125 15 78
3 Leganés Sub 12 Leganés 30 69 28 65
4 Rayo Vallecano Sub 12 Rayo 30 79 35 63
5 Getafe Sub 12 Getafe 30 68 25 63
6 Unión Adarve Sub 12 Unión 30 39 43 44
7 R. Ciudad Alcobendas Sub 12 Ciudad 30 29 46 39
8 Trival Valderas Sub 12 Trival 30 45 58 36
9 EFMO Boadilla Sub 12 EFMO 30 39 60 36
10 Móstoles URJC Sub 12 Móstoles 30 40 73 31
11 At. Chpr. Alcobendas Sub 12 Chpr. 30 33 67 29
12 Nuevo Boadilla Sub 12 Nuevo 30 41 88 28
13 Colegio Miramadrid Sub 12 Colegio 30 26 51 25
14 Canillas Canillas 30 24 83 21
15 Rayo Majadahonda Rayo 30 30 96 18
16 Seseña Seseña 30 19 84 11
TEMPORADA 2021/2022
DIVISIÓN HONOR MADRID ALEVÍN F11 GRUPO 1
Equipo PJ GF GC Puntos
1 Atlético Sub 12 Atlético 30 174 9 88
2 Real Madrid Sub 12 B Real Madrid 30 172 10 83
3 R. Ciudad Alcobendas Sub 12 Ciudad 30 81 31 64
4 Getafe Sub 12 B Getafe 30 102 28 62
5 Unión Adarve Sub 12 Unión 30 57 61 53
6 At. Chpr. Alcobendas Sub 12 Chpr. 30 45 57 50
7 Fundacion Rayo Vallecano A Fundacion 30 53 62 48
8 Canillas Canillas 30 53 72 39
9 Colegio Miramadrid Colegio 30 33 53 38
10 Las Rozas A Las Rozas A 30 34 55 36
11 Atletico Madrileño Sub 12 Atletico 30 43 82 33
12 Sporting Hortaleza A Sporting 30 46 72 32
13 Villa Rosa A Villa Rosa 30 38 83 28
14 CD Leganés Sub 12 B Leganés 30 29 90 19
15 Complutense Alcala A Complutense 30 29 106 9
16 San Sebastian Reyes A Sebastian 30 27 145 7
TEMPORADA 2020/2021
1ª AUTO. MADRID ALEVÍN F7 GRUPO 1
Equipo PJ GF GC Puntos
1 Atlético Sub 12 Atlético 17 115 4 49
2 Real Madrid Sub 12 B Real Madrid 17 105 2 49
3 Canillas Canillas 17 35 25 36
4 Sporting Hortaleza A Sporting 17 22 19 34
5 Villa Rosa A Villa Rosa 17 43 23 33
6 Unión Adarve Sub 12 Unión 17 35 26 32
7 Electrocor Las Rozas A Electrocor 17 34 23 31
8 Rayo Majadahonda Rayo 17 22 14 30
9 Aravaca A Aravaca A 17 31 35 25
10 Union Zona Norte Sub 12 Union Zona. 17 17 22 21
11 Getafe D Getafe D 17 19 28 21
12 Atletico Villalba A Atletico 17 24 45 17
13 CDE FPA Las Rozas A Rozas 17 19 55 15
14 San Roque A San Roque A 17 13 39 12
15 Torrelodones A Torrelodones 17 14 59 10
16 Club San Agustin A Club Agustin 17 11 47 9
17 Ciudad del Futbol B Ciudad 17 10 52 8
18 Gredos-San Diego Gredos-San 17 0 51 0
TEMPORADA 2019/2020
1ª AUTO. MADRID ALEVÍN F7 GRUPO 1
Equipo PJ GF GC Puntos
1 Real Madrid Sub 12 B Real Madrid 20 100 6 57
2 Atletico Montaura Atletico 20 107 8 55
3 CF Rayo Majadahonda Rayo 19 42 15 42
4 Ciudad de Baza A Ciudad Baza 19 38 30 34
5 AD Villa Rosa Villa Rosa 19 35 32 33
6 Canillas Canillas 19 38 20 32
7 Las Rozas CF-Nuicon-Asuman Rozas 19 32 46 27
8 Sporting Hortaleza A Sporting 19 38 46 26
9 AD Union Adarve Union Adarve 20 29 55 22
10 San Roque A San Roque A 19 22 55 21
11 Union Zona Norte Sub 12 Union Zona. 19 30 64 16
12 Atletico Villalba A Atletico 18 23 51 10
13 Aravaca A Aravaca A 19 13 51 7
14 Torrelodones A Torrelodones 19 7 75 5
TEMPORADA 2018/2019
1ª AUTO. MADRID ALEVÍN F7 GRUPO 1
Equipo PJ GF GC Puntos
1 Real Madrid Sub 12 B Real Madrid 26 196 5 78
2 Ciudad del Futbol Ciudad 26 72 33 67
3 Atlético Sub 12 Atlético 26 105 19 64
4 Unión Adarve Sub 12 Unión 26 53 21 55
5 Union Zona Norte Sub 12 Union Zona. 26 38 49 38
6 Atletico Villalba A Atletico 26 44 45 35
7 Las Rozas A Las Rozas A 26 31 62 34
8 Canillas Canillas 26 40 61 32
9 San Roque A San Roque A 26 35 68 31
10 Aravaca A Aravaca A 26 28 49 30
11 Deportivo Av Santa Ana A Deportivo 26 28 67 21
12 Sporting Hortaleza A Sporting 26 31 89 14
13 CF Pozuelo A Pozuelo 26 18 93 13
14 Getafe D Getafe D 26 14 72 11
TEMPORADA 2017/2018
PREFERENTE MADRID ALEVÍN F11 GRUPO 4
Equipo PJ GF GC Puntos
1 Sporting Hortaleza A Sporting 26 101 22 70
2 Esperanza A Esperanza A 26 66 32 56
3 Canillas Canillas 25 54 23 56
4 Fundación Recuerdo Fundación 26 81 45 51
5 Dosa A Dosa A 26 62 47 46
6 Chamartin Vergara Alcobenda Chamartin 26 56 41 43
7 Club San Agustin A Club Agustin 25 54 43 38
8 Complutense Alcala C Complutense 26 37 43 37
9 Alcala C Alcala C 26 55 56 33
10 Club San Jose del Parque Club Jose P. 26 47 56 33
11 Alameda de Osuna A Alameda 26 43 70 27
12 Colegio Alameda de Osuna A Colegio 26 31 90 12
13 San Blas B San Blas B 26 33 77 11
14 Escuela Futbol Concepcion B Escuela 26 10 85 7
TEMPORADA 2016/2017
PREFERENTE MADRID ALEVÍN F11 GRUPO 3
Equipo PJ GF GC Puntos
1 EF Concepcion Sub 12 Concepcion 26 134 17 69
2 San Roque A San Roque A 26 95 22 59
3 Canillas Canillas 26 89 31 58
4 Club San Agustin A Club Agustin 26 94 26 57
5 Esperanza A Esperanza A 26 79 23 57
6 Chamartin Vergara A Chamartin 26 50 35 40
7 Club Atletico de Madrid G Club 26 60 38 37
8 Colegio Alameda de Osuna A Colegio 26 59 56 34
9 Fundación Recuerdo Fundación 26 56 64 30
10 Celtic Castilla A Celtic 26 58 79 29
11 Villa Rosa A Villa Rosa 26 50 69 28
12 Atletico Madrileño D Atletico 26 38 69 19
13 Periso Periso 26 26 134 9
14 Coslada C Coslada C 26 8 233 0
TEMPORADA 2015/2016
1ª AUTO. MADRID ALEVÍN F7 GRUPO 2
Equipo PJ GF GC Puntos
1 Alcala A Alcala A 26 87 12 70
2 Real Madrid C Real Madrid 26 88 31 62
3 Sporting Hortaleza A Sporting 26 75 30 60
4 Alameda de Osuna A Alameda 26 45 43 44
5 Coslada A Coslada A 26 61 47 42
6 Vicalvaro A Vicalvaro A 26 41 54 37
7 Club Fundacion Rayo Valleca Club 26 38 41 36
8 San Fernando A Fernando 26 39 56 34
9 Complutense Alcala A Complutense 26 35 40 34
10 Club Atletico de Madrid D Club 26 44 35 32
11 Canillas Canillas 26 41 42 31
12 Getafe C Getafe C 26 33 61 22
13 Naya A Naya A 26 26 92 10
14 Chamartin Vergara A Chamartin 26 13 82 3
TEMPORADA 2014/2015
1ª AUTO. MADRID ALEVÍN F7 GRUPO 2
Equipo PJ GF GC Puntos
1 Alcala A Alcala A 26 89 16 61
2 Atlético C Atlético C 26 66 30 55
3 Real Madrid C Real Madrid 26 86 16 54
4 Coslada A Coslada A 26 57 24 47
5 Canillas Canillas 26 71 33 46
6 Getafe C Getafe C 26 65 30 42
7 Sporting Hortaleza A Sporting 26 47 37 42
8 Vicalvaro A Vicalvaro A 26 54 44 40
9 Club Fundacion Rayo Valleca Club 26 44 34 37
10 Complutense Alcala A Complutense 26 61 60 34
11 San Blas A San Blas A 26 36 47 27
12 EF Concepcion Sub 12 Concepcion 26 30 83 12
13 Parque Granada A Parque 26 16 110 7
14 Atletico Torrejon Ardoz A Atletico 26 17 175 4

  USO DE MEMORIA  
5,567,712 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0012
Controller Execution Time ( Home / Category )  0.0800
Total Execution Time  0.0812
  CADENA URL  
/historico/Cd-Canillas-A-Alevin
  GET DATOS  
$_GET['/historico/Cd-Canillas-A-Alevin']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (23)  
0.0042  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 = 70510
0.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=38911 AND type_rel = 2
0.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=2724 AND type_rel = 3
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 = '38911' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0020  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 = '38911' AND ct.ctype=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0020  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 = 70510 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0023  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=38911 AND l.year in (2022,2023,2024) ORDER BY l.id DESC, l.year DESC ;
0.0020  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 (70510,64881) 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.0019  SELECT count(id) as num_players from rel_players_base WHERE league_id = 70510 AND teamId = 38911
0.0019  SELECT count(id) as num_players from rel_players_base WHERE league_id = 64881 AND teamId = 38911
0.0019  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 = 70510 AND t.round = 30 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0019  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 = '38911' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
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 = '38911' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0025  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 = 38911 AND l.year <= 2023 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
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 `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 = 70510 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.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 `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 = 64881 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.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 `tables2021_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 = 61490 AND t.round = 17 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 `tables2020_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 = 52472 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 `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 = 45481 AND t.round = 26 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_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 = 41677 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0027  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 = 34520 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0027  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 = 17996 AND t.round = 26 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 = 6529 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC