4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del Almansa Sub 19
TEMPORADA 2023/2024
LIGA NACIONAL GRUPO 15
Equipo PJ GF GC Puntos
1 UB Conquense Sub 19 Conquense 30 88 25 75
2 Albacete Balompié Sub 19 B Albacete 31 77 23 69
3 CD Cazalegas Sub 19 Cazalegas 30 60 39 58
4 CD Toledo Sub 19 Toledo 31 57 36 57
5 CD Azuqueca Sub 19 Azuqueca 30 64 45 51
6 EFUD Albacer Sub 19 EFUD Albacer 30 52 50 49
7 CD Alameda MESA Sub 19 Alameda MESA 30 49 35 48
8 Guadalajara Sub 19 Guadalajara 30 64 37 48
9 Almansa Sub 19 Almansa 30 63 56 46
10 Atlético Puertollano Sub 19 Atlético 30 47 61 43
11 AD Illescas Sub 19 Illescas 30 46 49 43
12 Arges Sub 19 Arges 30 39 49 38
13 EFFB Ciudad Real Sub 19 EFFB Ciudad 30 48 52 31
14 Talavera de la Reina Sub 19 Talavera 30 41 61 29
15 Jesus de La Ossa Sub 19 Jesus Ossa 30 41 69 28
16 Odelot Toletum Sub 19 Odelot 30 45 72 23
17 Torrijos CD Sub 19 Torrijos 30 25 54 23
18 CD Miguelturreño Sub 19 Miguelturre 30 24 117 8
TEMPORADA 2022/2023
LIGA NACIONAL GRUPO 15
Equipo PJ GF GC Puntos
1 Albacete Balompié Sub 19 B Albacete 33 96 36 69
2 EFB Miguelturra Sub 19 Miguelturra 34 62 37 67
3 Almansa Sub 19 Almansa 34 79 41 65
4 UB Conquense Sub 19 Conquense 34 70 45 61
5 CD Azuqueca Sub 19 Azuqueca 34 65 45 61
6 Elite Talavera Sub 19 Elite 34 65 48 59
7 Torrijos CD Sub 19 Torrijos 34 64 49 56
8 Arges Sub 19 Arges 33 63 49 54
9 Talavera de la Reina Sub 19 Talavera 34 58 59 48
10 AD Illescas Sub 19 Illescas 34 58 57 48
11 EFUD Albacer Sub 19 EFUD Albacer 34 50 60 44
12 Atlético Puertollano Sub 19 Atlético 34 61 66 39
13 Jesus de La Ossa Sub 19 Jesus Ossa 34 45 67 39
14 CD Miguelturreño Sub 19 Miguelturre 34 48 74 37
15 CDEFB Valdepeñas Sub 19 CDEFB 34 45 64 36
16 Atlético Tomelloso Sub 19 Atlético 34 45 64 35
17 Cabanillas Sub 19 Cabanillas 34 33 75 27
18 CD Goalsoccer Sub 19 Goalsoccer 34 28 99 22
TEMPORADA 2021/2022
PREF. JUVENIL CASTILLA-LA MANCHA GRUPO 1
Equipo PJ GF GC Puntos
1 Almansa Sub 19 Almansa 29 106 5 76
2 Efbjesus de La Ossa Efbjesus 30 88 36 64
3 Conquense B Conquense B 30 89 24 63
4 EFB La Roda Sub 19 Roda 30 87 30 61
5 CD Villacañas Villacañas 30 51 65 52
6 Sporting de Alcazar B Sporting 30 60 50 47
7 Hellín CF Sub 19 Hellín 29 56 49 44
8 E Al Basit A Basit 30 51 57 41
9 Cristo de La Vega Cristo Vega 30 55 56 37
10 Olimpico Villarrobledo Olimpico 30 46 66 35
11 EMF Consuegra Consuegra 30 48 70 35
12 CS Puertollano Puertollano 29 48 45 34
13 Bolañego Bolañego 28 36 40 32
14 Manzanares Sub 19 Manzanares 29 26 58 20
15 Quintanar Del Rey Quintanar 29 24 80 15
16 Manchego Ciudad Real B Manchego 29 17 157 1
TEMPORADA 2020/2021
PREF. JUVENIL CASTILLA-LA MANCHA GRUPO 1
Equipo PJ GF GC Puntos
1 Almansa Sub 19 Almansa 15 31 16 35
2 CD Goalsoccer Sub 19 Goalsoccer 13 37 8 34
3 E Al Basit A Basit 14 21 9 27
4 Cristo de La Vega Cristo Vega 15 14 13 26
5 Almaguer Almaguer 12 22 11 22
6 Conquense B Conquense B 13 25 14 21
7 Olimpico Villarrobledo Olimpico 16 21 28 20
8 Efbjesus de La Ossa Efbjesus 17 18 29 14
9 U Criptanense Tierra de Gig Criptanense 16 17 33 10
10 CD Quintanar Del Rey Sub 19 Quintanar 14 15 31 8
11 Atletico Tomelloso B Atletico 13 7 36 2
TEMPORADA 2018/2019
PROV. JUVENIL CASTILLA-LA MANCHA GRUPO 1
Equipo PJ GF GC Puntos
1 Hellín Deportivo Hellín 31 134 17 89
2 Almansa Sub 19 Almansa 31 164 17 78
3 E Al Basit B Basit 31 94 66 58
4 Fundación Albacete Fundación 31 58 27 56
5 Cultural Valdeganga Cultural 31 77 56 55
6 Caudetano Caudetano 30 92 51 51
7 U D Alpera U D Alpera 30 59 79 47
8 Almansa B Almansa B 31 59 60 46
9 CDE Balompedica Albacete Balompedica 32 64 62 45
10 Ud Almansa Ud Almansa 31 46 56 40
11 C D Llanos del Aguila Llanos 31 47 75 38
12 Albacer Yesos Ortega B Albacer 31 54 80 32
13 Munera Munera 32 61 94 28
14 Chinchilla Chinchilla 31 60 119 25
15 E Al Basit A Basit 31 37 82 23
16 Albacer Decoletaje La Preci Albacer 31 25 114 18
17 Federativa Albacete Federativa 18 16 92 4
TEMPORADA 2016/2017
PROV. JUVENIL CASTILLA-LA MANCHA GRUPO 1
Equipo PJ GF GC Puntos
1 Hellín Deportivo Hellín 30 106 34 80
2 E Al Basit B Basit 30 119 28 73
3 E Al Basit A Basit 30 92 30 70
4 Albacer Yesos Ortega B Albacer 30 90 37 64
5 CDE Balompedica Albacete Balompedica 30 100 45 62
6 Caudetano Caudetano 30 92 50 59
7 Almansa B Almansa B 29 63 75 39
8 U D Alpera U D Alpera 30 55 57 36
9 F. Albacete A Albacete 30 67 81 35
10 La Roda Miguelitos Gaymon A Roda 30 41 57 32
11 Sport Five Tobarra Sport Five. 30 50 79 31
12 Huracan de Balazote Huracan 29 50 77 30
13 Atletico Ossa Atletico 30 45 94 25
14 CDE AV Industria Industria 30 36 85 25
15 C D Llanos del Aguila Llanos 30 31 120 13
16 Albacer A+b Mediacion C Albacer 30 29 117 11
TEMPORADA 2015/2016
PROV. JUVENIL CASTILLA-LA MANCHA GRUPO 1
Equipo PJ GF GC Puntos
1 E Zona 5 Albacete Zona 30 78 32 72
2 Almansa Sub 19 Almansa 30 84 35 65
3 E Al Basit A Basit 30 94 45 62
4 Almansa B Almansa B 30 60 37 59
5 Caudetano Caudetano 30 58 39 51
6 CDE Balompedica Albacete Balompedica 30 82 61 51
7 Huracan de Balazote Huracan 30 72 57 47
8 Chinchilla Chinchilla 29 51 48 44
9 E Al Basit B Basit 30 58 60 43
10 Munera Munera 30 61 60 40
11 Albacer Yesos Ortega B Albacer 30 58 63 38
12 Hellín Deportivo Hellín 30 54 72 33
13 U D Alpera U D Alpera 30 51 59 33
14 Federativa Albacete Federativa 30 53 80 26
15 Montealegre Montealegre 28 33 85 14
16 Albacer A+b Mediacion C Albacer 29 31 145 7
TEMPORADA 2014/2015
PROV. JUVENIL CASTILLA-LA MANCHA GRUPO 1
Equipo PJ GF GC Puntos
1 Efud Albacer Efud Albacer 28 84 21 72
2 Huracan de Balazote Huracan 28 80 44 60
3 F. Albacete A Albacete 28 82 27 53
4 Gero Asisa Gero Asisa 28 71 54 47
5 Al-Basit A Al-Basit A 28 69 42 46
6 Industria Popi A Industria 28 96 56 44
7 Almansa B Almansa B 28 51 52 39
8 Montealegre Montealegre 28 66 79 38
9 Almansa Sub 19 Almansa 28 42 33 36
10 Cd Caudetano Caudetano 28 53 51 36
11 Albacer C Albacer C 28 44 59 33
12 Industria Geox B Industria 28 41 109 14
13 Aguas Nuevas Aguas Nuevas 28 29 98 8
14 F. Albacete B Albacete 28 11 167 6

  USO DE MEMORIA  
5,736,016 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0012
Controller Execution Time ( Home / Category )  0.4497
Total Execution Time  0.4509
  CADENA URL  
/historico/Efb-Almansa-Juvenil
  GET DATOS  
$_GET['/historico/Efb-Almansa-Juvenil']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (23)  
0.0027  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 = 'Efb-Almansa-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.0018  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=41807 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0018  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=41807 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=41807 AND type_rel = 2
0.0021  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 = '41807' AND l.year = 2024 ORDER BY l.year DESC,cat.coefficient DESC
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 = '41807' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
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=41807 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0018  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 (73391) 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.0020  SELECT count(id) as num_players from rel_players WHERE league_id = 73391 AND teamId = 41807
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 = '41807' 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 = '41807' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0034  SELECT e.action,rp.player_id, count(e.action) as total, p.nick,p.name,p.last_name,p.alias,rp.team_id FROM `rel_players` rp INNER JOIN dataplayers p ON p.id = rp.player_id INNER JOIN events2024 e ON e.player_id = p.id AND e.league_id = 73391 WHERE rp.league_id = 73391 AND rp.teamId = 41807 AND (e.action = 1 or e.action = 2 or e.action = 11 or e.action = 12 or e.action = 13) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0034  SELECT e.action,rp.player_id, count(e.action) as total, p.nick,p.name,p.last_name,p.alias,rp.team_id FROM `rel_players` rp INNER JOIN dataplayers p ON p.id = rp.player_id INNER JOIN events2024 e ON e.player_id = p.id AND e.league_id = 73391 WHERE rp.league_id = 73391 AND rp.teamId = 41807 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0029  SELECT e.action,rp.player_id, count(e.action) as total, p.nick,p.name,p.last_name,p.alias,rp.team_id FROM `rel_players` rp INNER JOIN dataplayers p ON p.id = rp.player_id INNER JOIN events2024 e ON e.player_id = p.id AND e.league_id = 73391 WHERE rp.league_id = 73391 AND rp.teamId = 41807 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0024  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 = 41807 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.0045  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 `tables2024` 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 = 73391 AND t.round = 31 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0029  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` 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 = 68420 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.0030  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 = 64949 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.3286  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 = 61006 AND t.round = 22 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0048  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 = 45659 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0222  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 = 35325 AND t.round = 30 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 = 17158 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0061  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 = 6692 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC