4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del Cabeza Del Buey
TEMPORADA 2023/2024
1ª REGIONAL EXTREMADURA GRUPO 3
Equipo PJ GF GC Puntos
1 Santa Amalia Santa Amalia 22 48 21 45
2 Campanario Campanario 22 38 23 44
3 CD Quintana CD Quintana 22 42 24 38
4 Hernán Cortés Hernán 22 30 20 38
5 Gimnástico Don Benito Gimnástico 22 37 31 36
6 Cabeza Del Buey Cabeza Buey 22 36 38 31
7 Racing Merida City Racing 22 26 37 30
8 Guareña Guareña 22 27 37 26
9 CD Nueva Ciudad Nueva Ciudad 22 19 32 23
10 Olympic Peleño Olympic 22 22 40 20
11 CD San Serván Serván 22 20 37 20
12 Monterrubio CD Monterrubio 22 28 33 19
TEMPORADA 2022/2023
1ª REGIONAL EXTREMADURA GRUPO 3
Equipo PJ GF GC Puntos
1 Santa Amalia Santa Amalia 22 55 14 51
2 Castuera Castuera 22 58 20 48
3 Campanario Campanario 22 34 22 47
4 CD Quintana CD Quintana 22 45 32 40
5 Hernán Cortés Hernán 22 60 34 39
6 Racing Merida City Racing 22 42 32 34
7 Guareña Guareña 22 30 31 28
8 Monterrubio CD Monterrubio 22 25 34 26
9 Gimnástico Don Benito Gimnástico 22 22 42 23
10 Valdehornillo Valdehornill 22 22 60 15
11 Cabeza Del Buey Cabeza Buey 22 21 50 14
12 Ilipense-Zalamea S. Ilipense-Zal 22 23 66 10
TEMPORADA 2021/2022
1ª REGIONAL EXTREMADURA GRUPO 3
Equipo PJ GF GC Puntos
1 Campanario Campanario 22 41 18 50
2 CD Nueva Ciudad Nueva Ciudad 22 35 14 43
3 Hernán Cortés Hernán 22 47 27 40
4 Gimnástico Don Benito Gimnástico 22 46 32 39
5 Santa Amalia Santa Amalia 22 34 19 37
6 Castuera Castuera 22 35 28 33
7 Guareña Guareña 22 30 26 31
8 Cabeza Del Buey Cabeza Buey 22 25 33 27
9 Ilipense-Zalamea S. Ilipense-Zal 22 25 33 25
10 Monterrubio CD Monterrubio 22 32 41 19
11 Calamonte UD Calamonte 22 24 53 16
12 CP Valdivia CP Valdivia 22 14 64 9
TEMPORADA 2020/2021
1ª REGIONAL EXTREMADURA GRUPO 10
Equipo PJ GF GC Puntos
1 CP Cheles CP Cheles 5 8 7 8
2 Montehermoso Montehermoso 5 4 3 8
3 Santa Marta Santa Marta 5 10 6 7
4 Cabeza Del Buey Cabeza Buey 5 7 8 7
5 CD Zarceño CD Zarceño 5 7 10 7
6 Las Hurdes CF Hurdes 5 6 8 4
TEMPORADA 2019/2020
2ª REGIONAL EXTREMADURA GRUPO 2
Equipo PJ GF GC Puntos
1 Monterrubio CD Monterrubio 24 88 23 61
2 Cabeza Del Buey Cabeza Buey 24 70 17 54
3 Cd Talarrubias Talarrubias 24 70 29 51
4 CD Quintana CD Quintana 24 58 29 49
5 Fuenlabrada de los Montes Fuenlabrada 24 63 47 49
6 Athletic Valle A Athletic 23 66 38 46
7 Sporting Malpartida A Sporting 24 73 51 37
8 San Bartolome A Bartolome 24 44 40 35
9 Orellana Costa Dulce A Orellana 24 42 34 34
10 Sp Herrera Sp Herrera 24 53 38 33
11 Esparragosa de Lares A Esparragosa 24 51 62 29
12 Puebla De Alcocer Puebla 24 45 79 19
13 Siruela A Siruela A 24 21 47 17
14 Pedrusco de Garbayuela Pedrusco 24 28 72 14
15 Logrosán Cf Logrosán 24 23 101 5
16 Valdecaballeros A Valdecaballe 23 8 96 3
TEMPORADA 2018/2019
2ª REGIONAL EXTREMADURA GRUPO 2
Equipo PJ GF GC Puntos
1 Sp Herrera Sp Herrera 29 64 41 62
2 CD Quintana CD Quintana 30 80 29 58
3 Esparragosa de Lares A Esparragosa 30 71 47 57
4 Cabeza Del Buey Cabeza Buey 30 92 43 56
5 Monterrubio CD Monterrubio 30 77 49 55
6 Sporting Malpartida A Sporting 30 68 42 54
7 Cd Talarrubias Talarrubias 30 72 40 53
8 Siruela A Siruela A 30 52 41 49
9 Castuera Subastacar B Castuera 29 56 42 47
10 Fuenlabrada de los Montes Fuenlabrada 30 93 64 43
11 San Bartolome A Bartolome 29 50 68 31
12 Puebla De Alcocer Puebla 30 72 85 29
13 Pedrusco de Garbayuela Pedrusco 29 45 72 28
14 Valdecaballeros A Valdecaballe 30 36 100 18
15 Casas De Don Pedro A Casas Pedro 28 19 116 13
16 Castilblanco A Castilblanco 30 14 82 10
TEMPORADA 2017/2018
2ª REGIONAL EXTREMADURA GRUPO 2
Equipo PJ GF GC Puntos
1 San Bartolome A Bartolome 25 57 24 61
2 Fuenlabrada de los Montes Fuenlabrada 26 82 34 60
3 Castuera Subastacar B Castuera 26 77 46 47
4 Sp Herrera Sp Herrera 26 64 36 47
5 Cabeza Del Buey Cabeza Buey 26 56 37 43
6 Sporting Malpartida A Sporting 26 60 51 42
7 Valdecaballeros A Valdecaballe 26 37 55 37
8 Siruela A Siruela A 26 51 51 35
9 Cd Talarrubias Talarrubias 25 51 52 34
10 Esparragosa de Lares A Esparragosa 26 49 59 33
11 Puebla De Alcocer Puebla 26 37 57 28
12 Pedrusco de Garbayuela Pedrusco 26 44 66 27
13 Casas De Don Pedro A Casas Pedro 26 28 74 14
14 Castilblanco A Castilblanco 26 28 79 11
TEMPORADA 2016/2017
2ª REGIONAL EXTREMADURA GRUPO 1
Equipo PJ GF GC Puntos
1 UD Frexnense Frexnense 26 63 33 59
2 Atlético Torremejía Atlético 26 67 34 55
3 CD Zarceño CD Zarceño 26 47 33 48
4 Bienvenida A Bienvenida 26 70 37 47
5 Monesterio Monesterio 25 59 34 45
6 Sporting Malpartida A Sporting 26 70 47 45
7 Castuera Subastacar B Castuera 25 45 38 44
8 Monterrubio CD Monterrubio 26 46 53 35
9 Higuera CF Higuera CF 26 44 47 32
10 Segureña A Segureña A 26 29 57 31
11 Solana UD Solana UD 26 41 51 25
12 Athletic Valle A Athletic 26 30 57 21
13 Cabeza Del Buey Cabeza Buey 26 28 73 15
14 S. Marcos Almendralejo A Marcos 26 39 84 12
TEMPORADA 2015/2016
1ª REGIONAL EXTREMADURA GRUPO 3
Equipo PJ GF GC Puntos
1 Plus Ultra A Plus Ultra 22 67 13 56
2 Esparragosa de Lares A Esparragosa 21 53 19 51
3 Siruela A Siruela A 22 51 29 45
4 Orellana Costa Dulce A Orellana 22 42 22 44
5 Fuenlabrada de los Montes Fuenlabrada 22 45 24 40
6 Cabeza Del Buey Cabeza Buey 22 40 27 38
7 Logrosán Cf Logrosán 22 51 38 32
8 Pedrusco de Garbayuela Pedrusco 22 25 64 19
9 Valdecaballeros A Valdecaballe 22 26 51 18
10 Casas De Don Pedro A Casas Pedro 22 21 58 15
11 Castilblanco A Castilblanco 21 11 45 11
12 Puebla De Alcocer Puebla 22 17 59 10

  USO DE MEMORIA  
5,562,856 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0013
Controller Execution Time ( Home / Category )  0.4488
Total Execution Time  0.4502
  CADENA URL  
/historico/Cabeza-Del-Buey-Senior
  GET DATOS  
$_GET['/historico/Cabeza-Del-Buey-Senior']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (27)  
0.0133  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 = 'Cabeza-Del-Buey-Senior' 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.0125  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=66174 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0125  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=66174 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0125  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=66174 AND type_rel = 2
0.0129  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 = '66174' ORDER BY l.year DESC,cat.coefficient DESC
0.0127  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 = '66174' AND l.year = 2024 ORDER BY l.year DESC,cat.coefficient DESC
0.0127  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 = '66174' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0127  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=66174 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0125  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 (73532) 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.0129  SELECT count(id) as num_players from rel_players WHERE league_id = 73532 AND teamId = 66174
0.0126  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 = '66174' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0125  SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '66174' and rp.type = 4
0.0126  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 = '66174' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0135  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 = 73532 WHERE rp.league_id = 73532 AND rp.teamId = 66174 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.0132  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 = 73532 WHERE rp.league_id = 73532 AND rp.teamId = 66174 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0131  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 = 73532 WHERE rp.league_id = 73532 AND rp.teamId = 66174 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0129  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 = 66174 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.0129  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 = 73532 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.0131  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 = 68802 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.0131  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` 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 = 63718 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.0128  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` 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 = 59503 AND t.round = 18 ORDER BY team.conference ASC,t.position 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 `tables2021` 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 = 62272 AND t.round = 5 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0129  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` 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 = 51342 AND t.round = 24 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0132  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` 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 = 45373 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0132  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` 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 = 39813 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0134  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` 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 = 37076 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0143  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` 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 = 16783 AND t.round = 22 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC