4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del CD Miajadas Sub 19
TEMPORADA 2022/2023
LIGA NACIONAL GRUPO 11
Equipo PJ GF GC Puntos
1 Mérida AD Sub 19 Mérida 34 89 36 76
2 UP Plasencia Sub 19 Plasencia 34 68 50 64
3 CD Diocesano Sub 19 B Diocesano 34 70 40 63
4 Cacereño Sub 19 Cacereño 34 71 43 58
5 CD Castuera Sub 19 Castuera 34 60 51 55
6 Flecha Negra Sub 19 Flecha Negra 34 61 53 55
7 Don Benito Sub 19 Benito 34 64 46 54
8 Cruz Villanovense Sub 19 B Cruz 34 72 62 52
9 Don Bosco Sub 19 Bosco 34 70 64 50
10 Emérita Augusta Sub 19 Emérita 34 62 61 49
11 CD Badajoz B Badajoz 34 45 53 48
12 Moralo CP Sub 19 Moralo 34 68 69 47
13 Villafranca Sub 19 Villafranca 34 56 63 46
14 CD Miajadas Sub 19 Miajadas 34 42 58 37
15 Montijo Sub 19 Montijo 34 34 57 32
16 CD Coria Sub 19 Coria 34 52 78 28
17 Puente San Francisco Sub 19 Puente 34 36 82 24
18 Jerez CF Jerez CF 34 56 110 23
TEMPORADA 2021/2022
1ª EXTREMADURA AUTO. JUVENIL GRUPO 1
Equipo PJ GF GC Puntos
1 CD Miajadas Sub 19 Miajadas 24 68 17 67
2 Cd Diocesano B Diocesano 24 84 20 55
3 Don Alvaro Don Alvaro 24 62 41 41
4 Academia Extremadura Sub 19 Academia 24 60 40 41
5 Puente San Francisco Sub 19 Puente 24 56 37 41
6 Vedruna Cáceres A Vedruna 24 51 47 40
7 AD Ciudad De Plasencia CF A Ciudad 24 37 36 30
8 CF Jaraiz A CF Jaraiz A 24 48 71 30
9 CP Montehermoso A Montehermoso 24 43 47 29
10 AD Merida B AD Merida B 24 32 66 27
11 Imperio de Mérida Imperio 24 39 64 21
12 Ed Casareña Casareña 24 27 55 16
13 Morala A Morala A 24 23 89 4
TEMPORADA 2020/2021
1ª EXTREMADURA AUTO. JUVENIL GRUPO 1
Equipo PJ GF GC Puntos
1 Montijo Sub 19 Montijo 22 72 22 56
2 CD Miajadas Sub 19 Miajadas 22 50 29 48
3 Cd Diocesano B Diocesano 22 68 23 46
4 Puente San Francisco Sub 19 Puente 22 52 30 43
5 Extremadura B Extremadura 22 40 43 36
6 Merida B Merida B 22 46 40 29
7 Montehermoso A Montehermoso 22 32 35 27
8 Polideportivo Guareña A Polideportiv 22 44 42 24
9 ED Casareña Casareña 22 25 60 21
10 Jaraiz A Jaraiz A 22 47 72 19
11 Verato A Verato A 22 27 63 18
12 EF Talayuela A Talayuela 22 33 77 10
TEMPORADA 2019/2020
1ª EXTREMADURA AUTO. JUVENIL
Equipo PJ GF GC Puntos
1 CP Flecha Negra Sub 19 Flecha Negra 24 73 27 59
2 CD Coria Sub 19 Coria 24 71 29 57
3 AD Ciudad De Plasencia CF A Ciudad 24 47 16 54
4 Olivenza FC B Olivenza 24 60 25 52
5 Jerez CF A Jerez CF A 24 76 26 51
6 CP Cacereño Sad A Cacereño 24 41 46 35
7 CD Badajoz B Badajoz 24 59 55 34
8 Cd Diocesano B Diocesano 24 54 49 33
9 CP Cabezuela A Cabezuela 24 50 65 33
10 ED Casareña Casareña 24 39 37 32
11 CP Montehermoso A Montehermoso 24 42 41 27
12 Racing CPvo. Valverdeño A Racing CPvo. 24 30 54 23
13 CPvo. Gran Maestre A CPvo. Gran. 23 37 49 22
14 EF Talayuela A Talayuela 24 39 81 22
15 CD Miajadas Sub 19 Miajadas 24 22 69 6
16 CP Almendralejo B Almendralejo 23 18 89 4

  USO DE MEMORIA  
5,159,336 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0016
Controller Execution Time ( Home / Category )  0.4065
Total Execution Time  0.4081
  CADENA URL  
/historico/Cd-Miajadas-A-Juvenil
  GET DATOS  
$_GET['/historico/Cd-Miajadas-A-Juvenil']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (28)  
0.0111  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 = 'Cd-Miajadas-A-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.0121  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 = 'Cd-Miajadas-A-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.0106  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=137154 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0106  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=137154 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0106  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=137154 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0106  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=137154 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0106  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=137154 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0213  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 = 68416
0.0105  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=137154 AND type_rel = 2
0.0105  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=112 AND type_rel = 3
0.0107  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 = '137154' AND l.year = 2023 ORDER BY l.year DESC,cat.coefficient DESC
0.0106  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 = '137154' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0107  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 = '137154' 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 = 68416 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=137154 AND l.year in (2022,2023,2024) ORDER BY l.id DESC, l.year DESC ;
0.0108  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 (68416,66168) 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 WHERE league_id = 66168 AND teamId = 137154
0.0106  SELECT count(id) as num_players from rel_players WHERE league_id = 68416 AND teamId = 137154
0.0106  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 = '137154' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0106  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 = '137154' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0138  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 events2023 e ON e.player_id = p.id AND e.league_id = 68416 WHERE rp.league_id = 68416 AND rp.teamId = 137154 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.0115  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 events2023 e ON e.player_id = p.id AND e.league_id = 68416 WHERE rp.league_id = 68416 AND rp.teamId = 137154 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0117  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 events2023 e ON e.player_id = p.id AND e.league_id = 68416 WHERE rp.league_id = 68416 AND rp.teamId = 137154 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0111  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 = 137154 AND l.year <= 2023 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.0112  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 = 68416 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.0113  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 = 66168 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.0113  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 = 59833 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.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 `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 = 52679 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