4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del Bujalance Futbol Base AD
TEMPORADA 2020/2021
3ª ANDALUZA CORDOBA CADETE GRUPO 1
Equipo PJ GF GC Puntos
1 Salvador Allende Salvador 8 21 5 20
2 Don Bosco CF B Bosco 9 26 14 19
3 Ciudad Jardin CD Ciudad 8 15 11 14
4 CD AD Miralbaida Miralbaida 7 23 8 13
5 A.D. Apademar A A.D. 10 25 30 11
6 Peñarroya Pueblonuevo CF Peñarroya 7 17 20 10
7 Villa del Rio Servicio Depo Villa 7 15 31 6
8 Bujalance Futbol Base AD Bujalance 7 9 20 2
9 CD Deportivo Cordoba CF Deportivo 5 5 17 1
TEMPORADA 2019/2020
3ª ANDALUZA CORDOBA CADETE
Equipo PJ GF GC Puntos
1 Menciano Atletico Menciano 21 57 27 44
2 Don Bosco CF B Bosco 20 57 25 43
3 CD Colonia de Fuente Palmer Colonia 20 78 51 43
4 Atlético Villanueva FB Atlético 21 71 40 42
5 Palma del Rio Atlético Palma 21 72 35 41
6 Palomera-Naranjo CDCultural Palomera-Nar 21 73 48 39
7 Fundacion Lucena FC A Fundacion 20 70 48 35
8 Ciudad Jardin CD Ciudad 21 58 47 30
9 Bujalance Futbol Base AD Bujalance 20 37 31 30
10 CD Posadas CF Posadas 21 69 73 30
11 Salvador Allende Salvador 20 42 43 24
12 Montemayor Atletico CD Montemayor 20 23 65 14
13 CD Deportivo Cordoba CF Deportivo 21 24 85 11
14 CD Futbol Juanin Y Diego B Futbol 21 26 79 7
15 Salerm Cosmetics Puente Gen Salerm 20 27 87 7
16 Peñarroya Pueblonuevo CF Peñarroya 0 0 0 0
TEMPORADA 2018/2019
3ª ANDALUZA CORDOBA CADETE
Equipo PJ GF GC Puntos
1 Figueroa CD B Figueroa 28 92 21 71
2 CD Futbol Juanin Y Diego B Futbol 28 87 42 65
3 La Rambla de Futbol Base Rambla 28 64 35 58
4 Baenense Atletico Baenense 28 83 47 57
5 Don Bosco CF B Bosco 28 48 34 51
6 Palomera Naranjo Cultural Palomera 28 72 61 49
7 Bujalance Futbol Base AD Bujalance 28 70 61 41
8 CD Posadas CF Posadas 28 74 77 39
9 Montalbeño Montalbeño 28 40 47 34
10 CD Deportivo Cordoba CF Deportivo 28 48 59 32
11 CD Colonia de Fuente Palmer Colonia 28 49 80 30
12 Salerm Cosmetics Puente Gen Salerm 28 44 68 28
13 Ciudad de Cordoba Los Abeto Ciudad 28 40 80 16
14 A.D. Apademar B A.D. 28 47 88 16
15 Santaella 2010 Santaella 28 22 80 12
16 Prieguense Prieguense 0 0 0 0
TEMPORADA 2017/2018
3ª ANDALUZA CORDOBA CADETE
Equipo PJ GF GC Puntos
1 Atlético Villanueva FB Atlético 28 92 34 61
2 Villa del Rio Servicio Depo Villa 28 91 37 60
3 CD Deportivo Cordoba CF Deportivo 28 105 39 59
4 C.D. Stadium C.D. Stadium 28 66 34 57
5 La Rambla de Futbol Base Rambla 28 79 45 47
6 Santaella 2010 Santaella 28 72 41 46
7 CD Posadas CF Posadas 28 72 58 46
8 Salerm Cosmetics Puente Gen Salerm 28 71 47 45
9 Figueroa CD Figueroa CD 28 68 51 44
10 Bujalance Futbol Base AD Bujalance 28 69 60 43
11 Los Califas Balompie B Califas 28 70 46 41
12 Salvador Allende Salvador 28 50 61 34
13 Villafranca Villafranca 28 73 124 23
14 Aguilarense Atletico Aguilarense 28 37 172 6
15 El Higueron El Higueron 28 19 185 0
TEMPORADA 2016/2017
4ª ANDALUZA CÓRDOBA CADETE GRUPO 2
Equipo PJ GF GC Puntos
1 Futbol Base de Bujalance Futbol Base 28 146 18 80
2 Villarrubia Villarrubia 28 98 41 65
3 Ciudad de Cordoba Los Abeto Ciudad 28 83 31 61
4 CD Montoreño Atletico Montoreño 28 127 54 59
5 Vespertina Perra Verde-Horn Vespertina 28 91 54 57
6 CD El Carpio C.F. Carpio C.F. 28 97 62 49
7 UD Sur UD Sur 27 75 86 41
8 Salvador Allende Salvador 28 79 65 37
9 Alcolea Los Angeles Alcolea 28 72 94 33
10 Bujalance Futbol Base AD Bujalance 28 55 77 33
11 Figueroa CD C Figueroa 28 77 96 27
12 Atletico Guadalquivir Atletico 28 53 125 17
13 Las Palmeras Palmeras 28 51 160 16
14 Rud La Carlota B Carlota 27 42 101 15
15 Racing Futbol Club Cordoba Racing 28 55 137 12
16 El Naranjo El Naranjo 0 0 0 0
TEMPORADA 2015/2016
4ª ANDALUZA CÓRDOBA CADETE GRUPO 3
Equipo PJ GF GC Puntos
1 Las Palmeras Palmeras 24 165 37 66
2 Almodóvar del Río C.F. Almodóvar 24 102 28 61
3 Villarrubia Villarrubia 24 135 35 59
4 Juanin Y Diego Sub 16 Juanin Diego 24 102 42 52
5 Bujalance Futbol Base B Bujalance 24 58 48 44
6 Bujalance Futbol Base AD Bujalance 24 65 56 31
7 Granadal La Salle Granadal 24 60 74 31
8 CD Colonia de Fuente Palmer Colonia 24 43 88 27
9 CD Montoreño Atletico Montoreño 24 72 88 22
10 Parque Cruz Conde Parque Cruz 24 38 91 18
11 Palomera Naranjo Cultural Palomera 24 27 125 17
12 Atlético Palma del Rio Atlético 24 50 100 16
13 Los Califas Balompie B Califas 24 48 153 13
14 Vespertina Perra Verde-Horn Vespertina 0 0 0 0

  USO DE MEMORIA  
5,136,872 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0020
Controller Execution Time ( Home / Category )  0.5319
Total Execution Time  0.5339
  CADENA URL  
/historico/Bujalance-Futbol-Base-Ad-Cadete/2021
  GET DATOS  
$_GET['/historico/Bujalance-Futbol-Base-Ad-Cadete/2021']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (27)  
0.0185  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 = 'Bujalance-Futbol-Base-Ad-Cadete' AND l.year = 2021 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.0150  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=128167 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0149  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=128167 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0316  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 = 59535
0.0145  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=128167 AND type_rel = 2
0.0144  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=760 AND type_rel = 3
0.0148  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 = '128167' ORDER BY l.year DESC,cat.coefficient DESC
0.0147  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 = '128167' AND l.year = 2021 ORDER BY l.year DESC,cat.coefficient DESC
0.0147  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 = '128167' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0147  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 = 59535 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0151  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=128167 AND l.year in (2020,2021,2022) ORDER BY l.id DESC, l.year DESC ;
0.0154  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 (66118,59535) 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.0150  SELECT count(id) as num_players from rel_players_base WHERE league_id = 66118 AND teamId = 128167
0.0149  SELECT count(id) as num_players from rel_players_base WHERE league_id = 59535 AND teamId = 128167
0.0146  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff 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 = 59535 AND t.round = 18 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0146  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 = '128167' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0145  SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '128167' and rp.type = 4
0.0147  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 = '128167' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0150  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 = 128167 AND l.year <= 2021 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.0154  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 = 59535 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.0161  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 = 53883 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.0150  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 = 45932 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0148  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 = 40581 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0155  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 = 34358 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0160  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 = 17376 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0151  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 = 59535 ORDER BY nameShow LIMIT 100
0.0151  SELECT l.year,l.group_code FROM leagues_besoccer l WHERE l.categoryId = 760 AND l.year = 2021 ORDER BY l.group_code ASC