4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del Atlético Zabal
TEMPORADA 2022/2023
3ª ANDALUZA CÁDIZ CADETE GRUPO 8
Equipo PJ GF GC Puntos
1 Guadiaro Guadiaro 24 101 32 60
2 Balon Linense Balon 24 107 34 57
3 Athletic Club Jimena Athletic 24 82 37 51
4 Real Balompedica Linense Real 24 62 47 48
5 CD San Roque Roque 24 104 56 45
6 Atlético Zabal Atlético 24 80 35 39
7 CD San Bernardo Bernardo 24 78 44 36
8 Tesorillo Tesorillo 24 55 48 33
9 Ad Taraguilla Taraguilla 24 65 59 33
10 Puerto de La Linea Puerto Linea 24 59 71 18
11 San Roque Atletico Roque 24 58 102 15
12 Calderon Calderon 24 46 87 12
13 Puente Mayorga Rvo Puente 24 11 255 1
TEMPORADA 2021/2022
2ª ANDALUZA CÁDIZ CADETE
Equipo PJ GF GC Puntos
1 CD San Roque Roque 32 113 62 70
2 Atlético Sanluqueño Sub 16 Atlético 32 98 49 68
3 CD Comarca de Jerez Comarca 32 97 43 64
4 Sporting Chiclana CD Sporting 32 85 35 61
5 Atlético Zabal Atlético 32 86 45 61
6 Wea Sierra de Cadiz Sierra Cadiz 32 68 49 55
7 Algeciras B CF Algeciras 32 70 45 53
8 Conil Conil 32 79 76 49
9 Xerez Deportivo A Xerez 32 64 58 46
10 Tiempo Libre Tiempo Libre 32 61 58 44
11 Sancti Petri A Sancti Petri 32 63 75 41
12 Estrella Portuense Estrella 32 54 71 37
13 Pueblo Nuevo La Granja Pueblo Nuevo 32 49 61 35
14 Loluba A Loluba A 32 46 81 26
15 Ciudad de Algeciras Ciudad 32 40 108 22
16 CD San Fernando Atlético Fernando 32 40 89 18
17 La Salle A La Salle A 32 34 142 9
TEMPORADA 2018/2019
2ª ANDALUZA CÁDIZ CADETE
Equipo PJ GF GC Puntos
1 San Jose Obrero UD Sub 16 Jose Obrero 30 100 22 80
2 Balón De Cádiz CF B Balón 30 89 23 71
3 Atletico Sanluqueño B Atletico 30 78 34 66
4 Estrella Portuense Estrella 30 78 47 59
5 Xerez Deportivo FC Xerez 30 72 38 53
6 Conil Conil 30 47 38 53
7 San Fernando CD Isleño Fernando 30 62 46 52
8 La Salle La Salle 30 54 42 44
9 APA Sancti Petri Sancti Petri 30 51 45 43
10 Atletico Pastores Algeciras Atletico 30 59 63 35
11 CD Guadalcacín A Guadalcacín 30 58 75 32
12 Rvo Portuense Club Futbol B Portuense 30 32 69 26
13 Sanix La Isla Sanix Isla 30 42 74 23
14 Ad Taraguilla Taraguilla 30 39 96 21
15 Atlético Zabal Atlético 30 27 97 16
16 Veteranos Xerez Veteranos 30 28 107 15
TEMPORADA 2014/2015
2ª ANDALUZA CÁDIZ CADETE
Equipo PJ GF GC Puntos
1 Balón De Cádiz CF B Balón 31 105 40 75
2 Xerez Cd Xerez Cd 31 75 25 68
3 Atlético Zabal Atlético 31 87 44 64
4 San Jose Obrero UD Sub 16 Jose Obrero 31 82 45 64
5 Arcos A AD Arcos A AD 32 119 41 61
6 Algeciras CF Sub 16 Algeciras 31 70 51 56
7 Atletico Sanluqueño B Atletico 31 64 45 49
8 Domingo Savio Domingo 31 42 45 39
9 Safa San Luis Safa Luis 31 47 58 36
10 Taraguilla B AD Taraguilla 31 59 81 36
11 La Salle Puerto Real Salle Puerto 31 55 81 35
12 Pueblo Nuevo Pueblo Nuevo 31 43 66 33
13 Chiclana CF A Chiclana 31 50 87 26
14 Conil C.F. Conil C.F. 31 42 100 19
15 CD Rota CD Rota 31 26 109 10
16 Tarifa Tarifa 17 23 93 7
TEMPORADA 2013/2014
3ª ANDALUZA CÁDIZ CADETE GRUPO 4
Equipo PJ GF GC Puntos
1 C.D. Calderón C.D. 24 116 22 61
2 Balona Balompié Balona 24 141 32 60
3 U.D. Los Barrios U.D. Barrios 24 99 25 60
4 C.D.Roquetas C.D.Roquetas 24 105 39 44
5 Atlético Zabal Atlético 24 76 39 44
6 Athletic Jimena Athletic 24 67 54 39
7 San Bernardo Bernardo 24 62 45 38
8 Ad Taraguilla Taraguilla 24 66 51 38
9 Castellar C.F. Castellar 24 54 110 22
10 Peña Mad.Linense Peña 24 46 112 19
11 C.D. Guadiario C.D. 24 42 84 17
12 Balón Linense Balón 24 46 159 10
13 U.D. Tesorillo U.D. 24 33 181 6

  USO DE MEMORIA  
5,206,136 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0014
Controller Execution Time ( Home / Category )  0.5714
Total Execution Time  0.5729
  CADENA URL  
/historico/Atletico-Zabal-447
  GET DATOS  
$_GET['/historico/Atletico-Zabal-447']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (36)  
0.0147  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 = 'Atletico-Zabal-447' 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.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 = 'Atletico-Zabal-447' 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.0130  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=14472 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0128  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=14472 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0127  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=14472 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0126  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=14472 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0126  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=14472 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0126  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=14472 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0127  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=14472 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0127  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=14472 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0136  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 = 68954
0.0132  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 = 70180
0.0125  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=14472 AND type_rel = 2
0.0125  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=447 AND type_rel = 3
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 = '14472' 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 = '14472' AND l.year = 2023 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 = '14472' 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,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 = 68954 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0127  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 = 70180 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
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=14472 AND l.year in (2022,2023,2024) 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 (70180,68954) 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.0126  SELECT count(id) as num_players from rel_players_base WHERE league_id = 68954 AND teamId = 14472
0.0125  SELECT count(id) as num_players from rel_players_base WHERE league_id = 70180 AND teamId = 14472
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 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 = 68954 AND t.round = 30 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0128  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 = '14472' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0127  SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '14472' and rp.type = 4
0.0129  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 = '14472' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0136  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 = 14472 AND l.year <= 2023 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.0142  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 = 68954 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.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 `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 = 70180 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.0136  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 = 66039 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.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_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 = 45903 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0135  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 = 4290 AND t.round = 34 ORDER BY team.conference 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 `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 = 3045 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 `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 = 3052 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0127  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 = 68954 ORDER BY nameShow LIMIT 100