4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del Grupo Empresa Bazan
TEMPORADA 2022/2023
3ª ANDALUZA CÁDIZ CADETE GRUPO 4
Equipo PJ GF GC Puntos
1 Ciudad de Cadiz PCD Ciudad Cadiz 28 157 13 75
2 San Fernando Isleño CD B Su Fernando 27 127 23 75
3 Pastora 1966 Pastora 1966 28 112 37 62
4 CD Cadistas La Isla Cadistas 28 78 45 58
5 CD Olimpico CD Olimpico 28 66 45 47
6 Tiempo Libre A Tiempo Libre 28 55 37 45
7 Lagunense Cadiz Lagunense 28 64 64 42
8 Panama Panama 28 65 66 40
9 Chiclana CF B Chiclana 28 46 61 39
10 Sporting Puertorrealeña Sporting 27 75 79 34
11 Escuela Bahia San Fernando Escuela 28 60 73 32
12 San Fernando Atletico Fernando 28 39 77 26
13 La Salle La Salle 28 40 93 20
14 Domingo Savio Domingo 28 26 135 9
15 Nueva Vida Nueva Vida 28 15 177 2
16 Grupo Empresa Bazan Grupo 0 0 0 0
TEMPORADA 2021/2022
3ª ANDALUZA CÁDIZ CADETE GRUPO 1
Equipo PJ GF GC Puntos
1 San Fernando Isleño Fernando 26 137 17 67
2 CD Cadistas La Isla Cadistas 25 105 25 63
3 Escuela Bahia San Fernando Escuela 26 114 43 59
4 Ciudad de Cadiz PCD Ciudad Cadiz 25 103 22 58
5 Grupo Empresa Bazan Grupo 26 92 38 48
6 Tiempo Libre Tiempo Libre 26 72 29 47
7 CD Olimpico CD Olimpico 26 43 59 36
8 Lagunense Cadiz Lagunense 26 58 54 34
9 San Fernando Atletico Fernando 26 59 105 32
10 Sporting Puertorrealeña Sporting 26 54 94 27
11 Panama Panama 25 40 77 23
12 CD Cañorrera Cañorrera 26 26 119 14
13 La Salle La Salle 26 25 126 8
14 Pastora 1966 Pastora 1966 25 16 136 4
TEMPORADA 2018/2019
3ª ANDALUZA CÁDIZ CADETE GRUPO 2
Equipo PJ GF GC Puntos
1 Sporting Chiclana CD Sporting 26 111 31 66
2 Barbate Barbate 26 98 27 64
3 APA Sancti Petri Sancti Petri 26 86 37 57
4 Novo Chiclana CD Novo 26 75 36 49
5 Futbol Vejer Futbol Vejer 26 66 45 49
6 Fair Play Futbol CD Fair Play F. 26 67 52 43
7 CD Benalup CD Benalup 26 57 45 41
8 Cañorrera Cañorrera 26 69 68 39
9 Sanix La Isla Sanix Isla 26 52 57 35
10 Conil Conil 26 44 66 20
11 Tiempo Libre Tiempo Libre 26 44 70 20
12 Chiclana Ind. CF Chiclana 26 32 63 20
13 Medina Balompié Medina 26 27 79 19
14 Nueva Vida Nueva Vida 26 16 168 3
15 Futbol Sanix Chiclana Futbol Sanix 0 0 0 0
16 Grupo Empresa Bazan Grupo 0 0 0 0
TEMPORADA 2017/2018
3ª ANDALUZA CÁDIZ CADETE GRUPO 1
Equipo PJ GF GC Puntos
1 Sanix La Isla Sanix Isla 31 224 15 91
2 Tiempo Libre A Tiempo Libre 32 184 21 89
3 Escuela Bahia San Fernando Escuela 32 170 25 81
4 Ciudad de Cadiz PCD Ciudad Cadiz 31 91 38 66
5 Sporting de Puerto Real Sporting 32 114 51 63
6 Cañorrera Cañorrera 32 111 71 58
7 Chiclana CF B Chiclana 32 86 72 57
8 UD Río San Pedro Río Pedro 31 89 50 52
9 Olimpico A Olimpico A 32 88 75 51
10 Liceo Sagrado Corazon Liceo 32 69 79 39
11 Raul Navas Raul Navas 32 41 89 29
12 Pastora 1966 Pastora 1966 32 46 101 29
13 Grupo Empresa Bazan Grupo 32 42 139 19
14 Panamá Panamá 31 32 131 18
15 Campo Aviacion Loreto Campo 31 24 136 16
16 Arsenal de Cadiz Arsenal 28 22 167 8
17 Nueva Vida Nueva Vida 31 17 190 6
TEMPORADA 2016/2017
3ª ANDALUZA CÁDIZ CADETE GRUPO 1
Equipo PJ GF GC Puntos
1 Olimpico A Olimpico A 30 147 16 88
2 San Fernando Atletico A Fernando 32 156 35 88
3 Geminis Geminis 31 126 41 69
4 Tiempo Libre Tiempo Libre 31 100 49 65
5 Rvo Portuense Club Futbol B Portuense 31 92 46 62
6 Lagunense Cadiz Lagunense 31 110 54 57
7 Isla de Leon Isla Leon 31 127 77 54
8 Sanix La Isla Sanix Isla 32 108 55 53
9 Palomares Junior Palomares 31 97 67 47
10 UD Río San Pedro Río Pedro 32 89 85 44
11 La Salle B La Salle B 29 73 46 40
12 Santamaria Santamaria 32 39 98 28
13 Grupo Empresa Bazan Grupo 31 63 129 25
14 Puertorrealeña Puertorreale 30 33 143 14
15 Chiclana CF B Chiclana 32 23 100 12
16 Cañorrera Cañorrera 31 29 217 9
17 Raul Navas Raul Navas 31 9 163 8
18 Escuela Bahia San Fernando Escuela 0 0 0 0
TEMPORADA 2015/2016
3ª ANDALUZA CÁDIZ CADETE GRUPO 1
Equipo PJ GF GC Puntos
1 San Fernando Atletico A Fernando 24 104 26 53
2 Isla de Leon Futbol Base A Isla Leon F. 24 89 27 53
3 Geminis Geminis 23 86 28 50
4 La Salle B La Salle B 24 62 35 45
5 UD Río San Pedro Río Pedro 24 78 34 44
6 Tiempo Libre Tiempo Libre 24 73 50 44
7 Olimpico A Olimpico A 24 65 26 43
8 Mentidero Cadiz CD Mentidero 24 71 34 41
9 Escuela Bahia San Fernando Escuela 24 58 62 33
10 Grupo Empresa Bazan Grupo 23 50 92 20
11 Falla Falla 24 20 89 12
12 Lagunense Cadiz Lagunense 24 29 156 4
13 Cañorrera Cañorrera 24 16 142 3
14 Polideportivo Cadiz CDS Polideportiv 0 0 0 0
TEMPORADA 2013/2014
3ª ANDALUZA CÁDIZ CADETE GRUPO 1
Equipo PJ GF GC Puntos
1 Domingo Savio Domingo 26 67 26 58
2 Olímpico Olímpico 26 82 28 57
3 Isla de León Isla León 26 66 36 43
4 Puertorrealeña Puertorreale 26 52 51 42
5 Panamá Panamá 26 73 42 42
6 Atletico San Fernando Atletico 26 73 53 41
7 Junior Junior 26 52 53 39
8 Lagunense Lagunense 26 39 39 35
9 Bahia San Fernando Bahia 26 42 63 24
10 Cañorrera Cañorrera 26 39 66 23
11 Grupo Empresa Bazan Grupo 26 36 66 23
12 Ef Águilas Ef Águilas 26 36 124 11
13 La Salle Pto.Real B Salle 26 19 83 5

  USO DE MEMORIA  
5,315,288 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0012
Controller Execution Time ( Home / Category )  0.1074
Total Execution Time  0.1086
  CADENA URL  
/historico/Grupo-Empresa-Bazan-Cadete
  GET DATOS  
$_GET['/historico/Grupo-Empresa-Bazan-Cadete']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (35)  
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 = 'Grupo-Empresa-Bazan-Cadete' 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.0032  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 = 'Grupo-Empresa-Bazan-Cadete' 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=20141 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=20141 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=20141 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=20141 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=20141 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=20141 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=20141 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=20141 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 = 70173
0.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=20141 AND type_rel = 2
0.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=452 AND type_rel = 3
0.0020  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 3 AND rel.typeId = 452 AND rel.ln = 'es' AND rel.status=1 ORDER BY rel.creation_date desc,rel.cover_points DESC LIMIT 5
0.0024  SELECT /*53 bs_news_model*/ n.id, n.author_id, n.headline, n.external_headline, n.live_headline, n.creation_date, n.update_date, n.pub_date, n.alias, n.subheadline, n.teaser, n.media, n.tags, n.views, n.screens, n.clicks, n.relations, n.comments, n.power_cover, n.cover_points, u.name as user_name FROM bs_news n INNER JOIN bs_editors u ON u.id = n.author_id AND u.ln = 'es' WHERE n.status = 1 AND n.ln = 'es' AND n.id IN (213750,57585) ORDER BY n.cover_points DESC, update_date DESC
0.0022  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 = '20141' ORDER BY l.year DESC,cat.coefficient DESC
0.0022  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 = '20141' AND l.year = 2023 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 = '20141' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0020  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 = 70173 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=20141 AND l.year in (2022,2023,2024) 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 (70173) 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.0019  SELECT count(id) as num_players from rel_players_base WHERE league_id = 70173 AND teamId = 20141
0.0020  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff 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 = 70173 AND t.round = 30 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0021  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 = '20141' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0018  SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '20141' and rp.type = 4
0.0022  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 = '20141' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0025  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 = 20141 AND l.year <= 2023 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
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 `tables2023_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 = 70173 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.0028  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 = 65014 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.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 `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 = 45918 AND t.round = 30 ORDER BY team.conference 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 `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 = 40267 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0032  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 = 34460 AND t.round = 34 ORDER BY team.conference 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 `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 = 17256 AND t.round = 26 ORDER BY team.conference 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 `tables2014_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 = 3049 AND t.round = 26 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 = 70173 ORDER BY nameShow LIMIT 100