4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del Gimnastico Don Benito A
TEMPORADA 2021/2022
1ª EXTREMADURA AUTO. JUVENIL GRUPO 2
Equipo PJ GF GC Puntos
1 Gimnastico Don Benito A Gimnastico 24 66 24 56
2 FMD Zafra FMD Zafra 24 52 35 42
3 Talarrubias A Talarrubias 23 45 39 42
4 UD Fuente de Cantos Sub 19 Fuente 24 48 29 40
5 CP Flecha Negra Sub 19 Flecha Negra 24 68 52 40
6 Gevora A Gevora A 23 57 41 40
7 CD Santa Amalia Sub 19 Santa Amalia 24 34 33 36
8 Alburquerque A Alburquerque 24 39 35 32
9 Uc La Estrella A Estrella 24 40 51 31
10 Polideportivo Guareña A Polideportiv 24 55 54 28
11 Guadiana A Guadiana A 24 38 54 23
12 Campanario A Campanario 24 23 85 13
13 Puebla de la Calzada Puebla 24 34 67 12
TEMPORADA 2020/2021
2ª EXTREMADURA JUVENIL GRUPO 7
Equipo PJ GF GC Puntos
1 Talarrubias A Talarrubias 22 83 40 48
2 CD Inicia CD Inicia 22 66 22 47
3 Monterrubio Monterrubio 22 56 40 43
4 Cabeza del Buey A Cabeza Buey 22 49 33 40
5 Escuela de Futbol Vegas Alt Escuela 22 66 31 39
6 Don Benito B Benito 22 51 28 39
7 Ilipense-Zalamea Surocer A Ilipense-Zal 22 47 34 36
8 Olympic Peleño Olympic 22 64 51 29
9 CD Quintana CD Quintana 22 43 50 28
10 Gimnastico Don Benito A Gimnastico 22 32 59 18
11 San Bartolome A Bartolome 22 27 92 6
12 CD Inicia B CD Inicia B 22 22 126 4
TEMPORADA 2019/2020
2ª EXTREMADURA JUVENIL GRUPO 6
Equipo PJ GF GC Puntos
1 Campanario A Campanario 16 63 6 45
2 Don Benito Sub 19 Benito 24 93 45 45
3 CPvo. Guareña CPvo. 16 59 9 40
4 La Cruz Villanovense Cruz 24 60 70 37
5 Gimnastico Don Benito A Gimnastico 18 51 28 34
6 Olympic Peleño Olympic 18 47 37 33
7 Talarrubias A Talarrubias 17 36 40 21
8 Ilipense-Zalamea Surocer A Ilipense-Zal 16 24 36 16
9 La Litera Escuela Dep Litera 17 18 52 13
10 CD Zarceño CD Zarceño 17 19 46 11
11 Cabeza del Buey A Cabeza Buey 18 24 82 9
12 CD Quintana CD Quintana 15 14 57 6
TEMPORADA 2018/2019
2ª EXTREMADURA JUVENIL GRUPO 6
Equipo PJ GF GC Puntos
1 Campanario A Campanario 24 85 18 56
2 Don Benito Sub 19 Benito 24 95 18 55
3 Polideportivo Guareña A Polideportiv 24 58 23 50
4 Gimnastico Don Benito A Gimnastico 24 77 36 48
5 Cruz Villanovense Sub 19 B Cruz 24 49 44 35
6 Ilipense-Zalamea Surocer A Ilipense-Zal 24 40 62 29
7 Don Benito B Benito 24 28 78 20
8 Plus Ultra A Plus Ultra 24 23 68 14
9 Cabeza del Buey A Cabeza Buey 24 19 127 7
TEMPORADA 2017/2018
1ª EXTREMADURA AUTO. JUVENIL GRUPO 2
Equipo PJ GF GC Puntos
1 Don Bosco Sub 19 Bosco 26 105 23 69
2 Olympic Peleño Olympic 26 59 23 55
3 CP Flecha Negra Sub 19 Flecha Negra 26 61 34 49
4 CD Santa Amalia Sub 19 Santa Amalia 25 56 35 49
5 Jerez CF Jerez CF 26 42 27 44
6 Hernando de Soto A Hernando 26 61 56 43
7 Cd Don Benito Benito 26 62 48 41
8 Cruz Villanovense Sub 19 B Cruz 26 49 44 38
9 CD Badajoz B Badajoz 25 43 28 35
10 Extremadura B Extremadura 25 37 65 26
11 Tenis Azuaga A Tenis Azuaga 26 50 78 22
12 Santa Teresa A Santa Teresa 26 42 71 19
13 UC La Estrella Estrella 25 30 94 15
14 Gimnastico Don Benito A Gimnastico 26 23 94 8
TEMPORADA 2016/2017
1ª EXTREMADURA AUTO. JUVENIL GRUPO 2
Equipo PJ GF GC Puntos
1 Don Bosco B Don Bosco B 26 84 32 59
2 Cruz Villanovense Sub 19 B Cruz 26 78 36 52
3 UD Fuente de Cantos Sub 19 Fuente 26 67 44 51
4 Olympic Peleño Olympic 26 56 33 49
5 Cd Don Benito Benito 26 55 37 47
6 CP Flecha Negra Sub 19 Flecha Negra 26 69 47 41
7 Tenis Azuaga A Tenis Azuaga 26 54 40 41
8 CD Santa Amalia Sub 19 Santa Amalia 26 40 32 38
9 CD Badajoz B Badajoz 26 40 48 35
10 UC La Estrella Estrella 26 42 49 32
11 CD Diter Zafra Diter Zafra 26 37 63 25
12 CP Sanvicenteño Sub 19 Sanvicenteñ 26 31 61 20
13 Gimnastico Don Benito A Gimnastico 26 41 76 20
14 Benfica Badajoz A Benfica 26 23 119 10
TEMPORADA 2015/2016
1ª EXTREMADURA AUTO. JUVENIL GRUPO 1
Equipo PJ GF GC Puntos
1 Polideportivo Arroyo A Polideportiv 26 64 30 59
2 CD Coria Sub 19 Coria 26 79 32 53
3 Cruz Villanovense Sub 19 B Cruz 26 53 26 48
4 Emérita Augusta Sub 19 Emérita 26 60 49 46
5 Chinato A Sub 19 Chinato 26 57 51 44
6 Montijo Sub 19 Montijo 26 54 43 42
7 Puebla de la Calzada B Puebla 26 64 48 41
8 EF Peña el Valle Peña Valle 26 42 42 39
9 Club Garrovilla A Club 26 64 50 39
10 Plasencia B Plasencia B 26 70 60 39
11 Talayuela A Talayuela A 26 51 44 34
12 Gimnastico Don Benito A Gimnastico 26 32 74 19
13 Arapiles A Arapiles A 26 39 88 11
14 CF Trujillo CF Trujillo 26 43 135 8
TEMPORADA 2014/2015
2ª EXTREMADURA JUVENIL GRUPO 6
Equipo PJ GF GC Puntos
1 Gimnastico Don Benito A Gimnastico 20 61 23 45
2 Valdivia A Valdivia A 20 63 24 43
3 Miajadas A Miajadas A 20 64 14 42
4 Ilipense-Zalamea Surocer A Ilipense-Zal 20 56 29 39
5 Orellana Costa Dulce A Orellana 20 44 33 38
6 Cabeza del Buey A Cabeza Buey 20 40 30 35
7 Don Benito B Benito 20 34 52 27
8 Campanario A Campanario 20 39 46 20
9 Talarrubias A Talarrubias 20 36 65 13
10 Metelinense A Metelinense 20 10 49 10
11 Quintana A Quintana A 20 13 95 5

  USO DE MEMORIA  
5,245,432 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0012
Controller Execution Time ( Home / Category )  0.1220
Total Execution Time  0.1233
  CADENA URL  
/historico/Gimnastico-Don-Benito-A-Juvenil
  GET DATOS  
$_GET['/historico/Gimnastico-Don-Benito-A-Juvenil']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (37)  
0.0023  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 = 'Gimnastico-Don-Benito-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.0030  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 = 'Gimnastico-Don-Benito-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.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=30164 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0019  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=30164 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=30164 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=30164 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=30164 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=30164 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=30164 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=30164 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=30164 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0027  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 = 66169
0.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=30164 AND type_rel = 2
0.0020  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=836 AND type_rel = 3
0.0030  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 = '30164' ORDER BY l.year DESC,cat.coefficient DESC
0.0026  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 = '30164' AND l.year = 2022 ORDER BY l.year DESC,cat.coefficient 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 = '30164' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
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 = '30164' AND ct.ctype=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0019  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 = 66169 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0022  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=30164 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 (66169,59869) 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.0018  SELECT count(id) as num_players from rel_players_base WHERE league_id = 66169 AND teamId = 30164
0.0018  SELECT count(id) as num_players from rel_players_base WHERE league_id = 59869 AND teamId = 30164
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 = 66169 AND t.round = 26 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 = '30164' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0019  SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '30164' and rp.type = 4
0.0020  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 = '30164' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0023  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 = 30164 AND l.year <= 2022 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.0026  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 = 66169 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.0021  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 = 59869 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.0021  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 = 52685 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.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 `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 = 45843 AND t.round = 27 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 `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 = 39872 AND t.round = 26 ORDER BY team.conference 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 `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 = 36280 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0026  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 = 17003 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0043  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 = 5209 AND t.round = 22 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0020  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 = 66169 ORDER BY nameShow LIMIT 100