4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del Escuela Futbol Concepcion A
TEMPORADA 2021/2022
DIVISIÓN HONOR MADRID INFANTIL GRUPO 1
Equipo PJ GF GC Puntos
1 Real Madrid Sub 14 B Real Madrid 30 92 23 76
2 Atlético Sub 14 B Atlético 30 87 28 67
3 Chamartín Alcobendas Sub 14 Chamartín 30 85 35 63
4 Periso CF Sub 14 Periso 30 74 30 62
5 Rayo Alcobendas Sub 14 Rayo 29 56 31 56
6 Union Adarve Sub 14 Union Adarve 30 58 34 54
7 Complutense Alcalá Sub 14 Complutense 30 60 49 51
8 Aravaca FC Sub 14 Aravaca 30 63 43 49
9 Canillas Sub 14 Canillas 30 49 47 46
10 Coslada A Coslada A 30 47 45 39
11 CD San Fernando Fernando 30 48 58 36
12 Rayo Majadahonda Sub 14 Rayo 29 44 50 33
13 Atletico Madrileño B Atletico 30 41 104 23
14 Getafe Sub 14 C Getafe 30 23 73 15
15 Torrejon B Torrejon B 30 24 83 12
16 Escuela Futbol Concepcion A Escuela 30 22 140 1
TEMPORADA 2020/2021
1ª AUTO. MADRID INFANTIL GRUPO 2
Equipo PJ GF GC Puntos
1 San Fernando A Fernando 15 42 6 43
2 San Blas A San Blas A 15 48 16 40
3 Escuela Futbol Concepcion A Escuela 15 62 15 39
4 B Paracuellos Antamira A Paracuellos 15 64 16 32
5 Club Atletico de Madrid E Club 15 43 30 30
6 Torrejon B Torrejon B 15 33 21 22
7 Getafe E Getafe E 15 23 20 20
8 Complutense Alcala B Complutense 15 31 33 20
9 San Roque Eff A Roque 15 34 47 18
10 Tajamar A Tajamar A 15 20 27 17
11 Fundacion Rayo Vallecano B Fundacion 15 24 32 16
12 CD Dosa Sub 14 Dosa 15 25 40 15
13 Esperanza A Esperanza A 15 16 46 12
14 RSD Alcala B Alcala 15 19 38 10
15 Club San Agustin A Club Agustin 15 14 62 4
16 Espartales Sur A Espartales 15 10 59 3
TEMPORADA 2019/2020
1ª AUTO. MADRID INFANTIL GRUPO 2
Equipo PJ GF GC Puntos
1 Alcala del Rio Alcala 19 90 13 53
2 Fund. Rayo Vallecano Sub 14 Fund. Rayo. 19 77 16 52
3 Escuela Futbol Concepcion A Escuela 19 48 27 39
4 Paracuellos Sport Paracuellos 19 53 24 38
5 San Blas A San Blas A 19 35 28 34
6 Esperanza A Esperanza A 19 45 25 31
7 Vicalvaro A Vicalvaro A 19 35 23 29
8 Union Deportiva La Poveda A Union 19 49 60 22
9 San Fernando A Fernando 19 17 28 21
10 CD Dosa Sub 14 Dosa 19 27 51 19
11 Escuela Futbol Ciudad de Ge Escuela 19 26 67 15
12 Escuela de Futbol Afe A Escuela 19 20 35 14
13 Espartales Sur A Espartales 19 29 85 8
14 Mun Villarejo Villarejo 19 10 79 4
TEMPORADA 2018/2019
DIVISIÓN HONOR MADRID INFANTIL GRUPO 1
Equipo PJ GF GC Puntos
1 Real Madrid Sub 14 Real Madrid 26 159 14 76
2 Atlético Sub 14 Atlético 26 114 20 62
3 Rayo Vallecano Sub 14 B Rayo 26 101 20 61
4 Getafe Sub 14 B Getafe 26 83 35 53
5 At. Torrejon de Ardoz Torrejon 26 50 38 52
6 Mostoles URJC B Mostoles 26 72 33 51
7 Complutense Alcalá Sub 14 Complutense 26 56 63 33
8 Union Adarve Sub 14 Union Adarve 26 37 47 33
9 Las Rozas CF A Rozas 26 41 60 27
10 Rayo Alcobendas Sub 14 Rayo 26 44 52 26
11 RSD Alcalá Sub 14 Alcalá 26 25 92 15
12 San Fernando A Fernando 26 18 95 15
13 Escuela Futbol Concepcion A Escuela 26 20 103 11
14 Escuela de Futbol Arganda A Escuela 26 17 165 6
TEMPORADA 2017/2018
1ª AUTO. MADRID INFANTIL GRUPO 2
Equipo PJ GF GC Puntos
1 Escuela Futbol Concepcion A Escuela 26 87 23 70
2 At. Torrejon de Ardoz Torrejon 26 96 23 65
3 Avance A Avance A 26 66 40 55
4 San Blas A San Blas A 26 61 42 49
5 Escuela de Futbol Afe A Escuela 26 48 39 45
6 San Sebastian Reyes A Sebastian 26 62 44 43
7 Coslada A Coslada A 26 55 40 37
8 Club Atletico de Madrid E Club 26 47 54 34
9 Juventud Sanse A Juventud 26 63 68 31
10 Alameda de Osuna A Alameda 26 52 79 28
11 Canillas Sub 14 Canillas 26 49 71 26
12 Paracuellos A Paracuellos 26 29 61 19
13 Esperanza A Esperanza A 26 23 73 11
14 RSD Alcala B Alcala 26 22 103 6
TEMPORADA 2016/2017
1ª AUTO. MADRID INFANTIL GRUPO 2
Equipo PJ GF GC Puntos
1 Complutense Alcalá Sub 14 Complutense 26 117 24 68
2 Chamartin Vergara A Chamartin 26 114 22 67
3 Paracuellos A Paracuellos 26 58 27 56
4 Vicalvaro A Vicalvaro A 26 69 25 53
5 Alameda de Osuna A Alameda 26 61 37 47
6 San Blas A San Blas A 26 45 30 44
7 Escuela de Futbol Arganda A Escuela 26 62 37 43
8 Avance A Avance A 26 43 56 30
9 Escuela Futbol Concepcion A Escuela 26 28 51 27
10 RSD Alcala B Alcala 26 58 66 26
11 Atletico Madrileño B Atletico 26 32 59 24
12 At. Torrejon de Ardoz Torrejon 26 54 69 23
13 Naya A Naya A 26 17 126 7
14 Palestra Atenea A Palestra 26 15 144 1
TEMPORADA 2015/2016
PREFERENTE MADRID INFANTIL GRUPO 3
Equipo PJ GF GC Puntos
1 Escuela Futbol Concepcion A Escuela 26 118 17 70
2 Fundacion A Fundacion A 26 70 26 63
3 CD Dosa Sub 14 Dosa 26 75 22 58
4 Villa Rosa A Villa Rosa 26 73 32 54
5 Fund Recuerdo A Fund 26 64 38 50
6 Canillas B Canillas B 26 58 51 36
7 Palestra Atenea A Palestra 26 51 63 31
8 San Roque Eff A Roque 26 32 43 28
9 Valdeluz A Valdeluz A 26 43 59 28
10 Oña Sanchinarro A Oña 26 38 62 28
11 Colegio El Prado Colegio 26 31 57 27
12 Club San Agustin A Club Agustin 26 43 67 26
13 Santa Maria Caridad A Santa Maria 26 28 99 15
14 San Blas C San Blas C 26 10 98 3

  USO DE MEMORIA  
5,293,352 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0012
Controller Execution Time ( Home / Category )  0.0795
Total Execution Time  0.0807
  CADENA URL  
/historico/Escuela-Futbol-Concepcion-A-Infantil
  GET DATOS  
$_GET['/historico/Escuela-Futbol-Concepcion-A-Infantil']  
  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 = 65066
0.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=70118 AND type_rel = 2
0.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=738 AND type_rel = 3
0.0021  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 3 AND rel.typeId = 738 AND rel.ln = 'es' AND rel.status=1 ORDER BY rel.creation_date desc,rel.cover_points DESC LIMIT 5
0.0021  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 (1096475,969181,930948,914706,879368) ORDER BY n.cover_points DESC, update_date DESC
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 = '70118' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
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 = '70118' 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 = 65066 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0021  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=70118 AND l.year in (2021,2022,2023) ORDER BY l.id DESC, l.year DESC ;
0.0019  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 (65066,61301) 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 = 65066 AND teamId = 70118
0.0018  SELECT count(id) as num_players from rel_players_base WHERE league_id = 61301 AND teamId = 70118
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 `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 = 65066 AND t.round = 30 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0020  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 = '70118' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
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 = '70118' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0022  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 = 70118 AND l.year <= 2022 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
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 = 65066 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 `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 = 61301 AND t.round = 15 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_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 = 52288 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 = 45463 AND t.round = 26 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 `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 = 40780 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0033  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 = 34401 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 = 17472 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC