4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del Deporte y Punto
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 2018/2019
1ª MADRID JUVENIL GRUPO 1
Equipo PJ GF GC Puntos
1 Electrocor Electrocor 34 115 39 81
2 Siete Picos Colmenar B Siete Picos 34 127 51 76
3 Union de Aravaca A Union 34 114 55 68
4 Hoyo de Manzanares Hoyo 34 107 72 65
5 Torrelodones A Torrelodones 34 65 44 63
6 Boadilla B Boadilla B 34 82 54 53
7 Escuela Europea Escuela 34 78 77 52
8 Las Rozas C Las Rozas C 34 82 56 49
9 K-2 K-2 34 73 89 45
10 Union Collado Villalba B Union 34 82 101 44
11 Calasanz Pozuelo A Calasanz 34 59 89 44
12 Nuevo Boadilla B Nuevo 34 72 70 41
13 CF Pozuelo C Pozuelo 34 80 104 39
14 CD Villanueva De La Cañada Villanueva 34 57 81 37
15 Colmenar Viejo B Colmenar 34 62 106 33
16 San Fernando Escolapios Fernando 34 73 120 30
17 Aravaca D Aravaca D 34 45 99 27
18 Deporte y Punto Deporte 34 49 115 19
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,303,136 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0023
Controller Execution Time ( Home / Category )  0.6112
Total Execution Time  0.6135
  CADENA URL  
/historico/Deporte-Y-Punto-Juvenil
  GET DATOS  
$_GET['/historico/Deporte-Y-Punto-Juvenil']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (33)  
0.0170  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 = 'Deporte-Y-Punto-Juvenil' 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.0172  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 = 'Deporte-Y-Punto-Juvenil' 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.0147  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=22298 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0145  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=22298 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0149  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=22298 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0147  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=22298 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0146  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=22298 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0152  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=22298 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0146  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=22298 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0157  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 = 64239
0.0146  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=22298 AND type_rel = 2
0.0147  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=732 AND type_rel = 3
0.0148  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 3 AND rel.typeId = 732 AND rel.ln = 'es' AND rel.status=1 ORDER BY rel.creation_date desc,rel.cover_points DESC LIMIT 5
0.0156  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 (747111,747806,747417,378152,377538) ORDER BY n.cover_points DESC, update_date DESC
0.0154  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 = '22298' AND l.year = 2022 ORDER BY l.year DESC,cat.coefficient DESC
0.0152  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 = '22298' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0151  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 = '22298' AND ct.ctype=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0149  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 = 64239 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0148  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=22298 AND l.year in (2021,2022,2023) ORDER BY l.id DESC, l.year DESC ;
0.0145  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 (64239) 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.0145  SELECT count(id) as num_players from rel_players_base WHERE league_id = 64239 AND teamId = 22298
0.0146  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff 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 = 64239 AND t.round = 30 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0146  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 = '22298' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0145  SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '22298' and rp.type = 4
0.0146  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 = '22298' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0147  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 = 22298 AND l.year <= 2022 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.0151  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.0151  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 = 45683 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0148  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.0159  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.0160  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.0162  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
0.0154  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 = 64239 ORDER BY nameShow LIMIT 100