4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del Atletico Leones Castilla
TEMPORADA 2022/2023
2ª MADRID JUVENIL GRUPO 1
Equipo PJ GF GC Puntos
1 Cerceda Cerceda 28 110 35 78
2 San Agustin Los Negrales Agustin 28 155 39 74
3 Union Collado Villalba B Union 28 135 35 72
4 Atletico Leones Castilla Atletico 28 99 51 58
5 Moralzarzal CF Moralzarzal 28 81 60 53
6 Collado Villalba B Collado 28 82 58 47
7 Alberto Cogorro Alberto 28 78 63 43
8 Becerril de La Sierra Becerril 28 69 80 35
9 Electrocor Las Rozas C Electrocor 28 66 74 32
10 Torrelodones CF B Torrelodones 28 71 92 30
11 Atletico Cercedilla Atletico 28 72 101 30
12 CD Galapagar D Galapagar 28 70 112 30
13 FC Villanueva Del Pardillo Villanueva 28 47 117 13
14 Gimnastica Colmenarejo B Gimnastica 28 49 140 12
15 UD San Lorenzo B Lorenzo 28 28 155 4
TEMPORADA 2021/2022
2ª MADRID JUVENIL GRUPO 1
Equipo PJ GF GC Puntos
1 Gimnastica Colmenarejo Gimnastica 28 85 28 71
2 Alpedrete C Alpedrete C 28 114 37 65
3 Alberto Cogorro Alberto 28 107 34 61
4 San Agustin Los Negrales Agustin 28 102 71 55
5 Deporte y Punto Deporte 28 69 43 55
6 Union Collado Villalba B Union 28 73 50 46
7 Atletico Leones Castilla Atletico 28 68 49 39
8 Moralzarzal CF Moralzarzal 27 68 49 39
9 ADC Castilla Castilla 28 58 72 38
10 Atletico Villalba Atletico 28 56 66 31
11 Torrelodones CF B Torrelodones 28 58 79 29
12 Atletico Cercedilla Atletico 28 51 103 22
13 Becerril de La Sierra Becerril 28 48 99 17
14 CD El Escorial B Escorial 27 34 125 11
15 CD Galapagar D Galapagar 28 43 129 8
TEMPORADA 2020/2021
2ª MADRID JUVENIL GRUPO 1
Equipo PJ GF GC Puntos
1 Alpedrete B Alpedrete B 15 64 27 36
2 CD El Escorial Escorial 15 59 25 36
3 Alberto Cogorro Alberto 15 58 18 34
4 AD Collado Mediano Collado 15 47 22 33
5 San Agustin Los Negrales Agustin 15 52 39 31
6 Atletico Leones Castilla Atletico 15 35 24 26
7 Gimnastica Colmenarejo Gimnastica 15 37 28 25
8 ADC Castilla Castilla 15 31 41 24
9 Union Collado Villalba B Union 15 21 29 19
10 Atletico Cercedilla Atletico 15 37 43 18
11 Moralzarzal CF Moralzarzal 15 35 34 16
12 Deporte Y Punto Bcm A Deporte 15 29 33 16
13 Torrelodones CF B Torrelodones 15 15 40 11
14 Atletico Villalba Atletico 15 17 66 8
15 CD Galapagar D Galapagar 15 23 53 7
16 Club Union Collado Villalba Club Union. 15 29 67 5
TEMPORADA 2018/2019
2ª MADRID JUVENIL GRUPO 1
Equipo PJ GF GC Puntos
1 Galapagar B Galapagar B 31 137 26 80
2 Atletico Cercedilla Atletico 32 119 47 72
3 Alpedrete Alpedrete 31 118 47 71
4 Collado Villalba B Collado 32 119 36 65
5 EFMO Boadilla C EFMO 32 104 58 58
6 Atletico Leones Castilla Atletico 31 88 47 58
7 UD Tres Cantos B Tres Cantos 32 102 54 57
8 Nuevo Boadilla C Nuevo 32 87 66 52
9 Moralzarzal Moralzarzal 32 84 72 50
10 Becerril de La Sierra Becerril 32 96 89 46
11 San Agustin Los Negrales Agustin 33 81 110 40
12 Pinosierra Pinosierra 33 73 74 39
13 Siete Picos Colmenar C Siete Picos 32 77 84 36
14 Union Collado Villalba C Union 32 50 113 25
15 Collado Mediano Collado 31 36 115 16
16 Gimnastica Colmenarejo B Gimnastica 32 34 158 10
17 Futbol Base 3 Cantos Futbol Base 28 18 227 4
TEMPORADA 2017/2018
2ª MADRID JUVENIL GRUPO 1
Equipo PJ GF GC Puntos
1 Deporte y Punto Deporte 32 102 48 81
2 Sek El Castillo - UCJC Castillo 32 140 48 77
3 Hoyo de Manzanares Hoyo 31 126 40 76
4 San Lorenzo San Lorenzo 32 122 49 71
5 Alpedrete Alpedrete 32 128 57 69
6 Villanueva del Pardillo B Villanueva 32 97 54 64
7 Atletico Leones Castilla Atletico 32 112 59 63
8 Galapagar C Galapagar C 32 67 95 40
9 Union Collado Villalba C Union 32 76 84 38
10 Moralzarzal Moralzarzal 32 91 122 36
11 El Escorial El Escorial 32 65 107 31
12 Atletico Cercedilla Atletico 32 54 116 30
13 Villanueva de La Cañada B Villanueva 32 65 88 29
14 Atletico Villalba B Atletico 32 45 120 25
15 Torrelodones B Torrelodones 32 38 87 19
16 San Agustin Los Negrales Agustin 31 71 138 18
17 Collado Villalba B Collado 32 46 133 6
TEMPORADA 2016/2017
2ª MADRID JUVENIL GRUPO 1
Equipo PJ GF GC Puntos
1 CF Pozuelo D Pozuelo 30 110 41 75
2 Collado Villalba B Collado 30 108 54 64
3 Deporte y Punto Deporte 30 90 48 61
4 Hoyo de Manzanares Hoyo 30 108 51 57
5 Electrocor C Electrocor 30 96 66 57
6 Atletico Leones Castilla Atletico 30 74 49 54
7 San Lorenzo San Lorenzo 30 105 74 52
8 Villanueva del Pardillo B Villanueva 30 65 66 42
9 Alpedrete Alpedrete 30 52 59 38
10 Galapagar C Galapagar C 30 65 95 37
11 Villanueva de La Cañada B Villanueva 30 62 76 31
12 Gimnastica Colmenarejo Gimnastica 29 54 90 29
13 Collado Mediano Collado 29 49 97 27
14 Union Collado Villalba C Union 30 44 75 25
15 Atletico Cercedilla Atletico 30 40 121 19
16 Las Rozas Las Rozas 30 37 97 16
TEMPORADA 2015/2016
2ª MADRID JUVENIL GRUPO 1
Equipo PJ GF GC Puntos
1 El Escorial El Escorial 34 95 33 76
2 Torrelodones B Torrelodones 33 96 35 74
3 Collado Villalba Collado 33 118 53 72
4 Villanueva del Pardillo B Villanueva 34 127 59 68
5 Collado Mediano Collado 34 106 62 66
6 Hoyo de Manzanares Hoyo 34 104 52 65
7 K-2 K-2 33 86 49 64
8 Las Rozas E Las Rozas E 34 72 66 59
9 Puerta Madrid Puerta 34 77 74 52
10 Atletico Villalba B Atletico 34 71 84 45
11 Deporte y Punto Deporte 34 69 95 42
12 Villanueva de La Cañada B Villanueva 34 67 89 37
13 Atletico Cercedilla Atletico 34 67 96 36
14 Los Negrales Negrales 33 67 103 32
15 Atletico Leones Castilla Atletico 34 54 98 29
16 Electrocor Electrocor 34 61 137 25
17 Galapagar C Galapagar C 34 38 107 15
18 Union Collado Villalba C Union 34 43 126 14
TEMPORADA 2014/2015
2ª MADRID JUVENIL GRUPO 1
Equipo PJ GF GC Puntos
1 Hoyo de Manzanares Hoyo 34 118 48 80
2 Union Collado Villalba C Union 34 90 43 79
3 Atletico Villalba Atletico 33 99 44 78
4 CD Villanueva De La Cañada Villanueva 33 102 41 77
5 K-2 K-2 33 119 52 73
6 Villanueva del Pardillo B Villanueva 33 91 66 58
7 Collado Mediano Collado 33 74 74 54
8 El Escorial El Escorial 34 84 69 53
9 Electrocor Electrocor 33 70 75 50
10 Atletico Leones Castilla Atletico 33 56 55 45
11 Los Negrales Negrales 33 75 85 42
12 Las Rozas E Las Rozas E 33 64 82 39
13 Puerta Madrid Puerta 33 53 66 33
14 Colmenarejo A Colmenarejo 34 46 78 28
15 Deporte y Punto Deporte 33 54 108 25
16 Galapagar C Galapagar C 33 26 84 18
17 Collado Villalba Collado 33 35 122 7
18 Atletico Cercedilla Atletico 21 23 87 3

  USO DE MEMORIA  
5,558,840 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0016
Controller Execution Time ( Home / Category )  0.2753
Total Execution Time  0.2769
  CADENA URL  
/historico/Atletico-Leones-Castilla-Juvenil
  GET DATOS  
$_GET['/historico/Atletico-Leones-Castilla-Juvenil']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (15)  
0.0240  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 = 69892
0.0107  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=22284 AND type_rel = 2
0.0110  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 = '22284' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0107  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 = 69892 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0108  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=22284 AND l.year in (2022,2023,2024) ORDER BY l.id DESC, l.year DESC ;
0.0106  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 (69892) 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.0105  SELECT count(id) as num_players from rel_players_base WHERE league_id = 69892 AND teamId = 22284
0.0107  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 = 22284 AND l.year <= 2023 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.0110  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 = 69892 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.0110  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 = 64239 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.0128  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 = 45724 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0126  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 = 39378 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0142  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 = 34156 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0127  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 = 16986 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0137  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 = 4618 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC