4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del Wea Sierra de Cadiz
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 2020/2021
1ª ANDALUZA CADETE GRUPO 6
Equipo PJ GF GC Puntos
1 Algeciras CF Sub 16 Algeciras 10 22 9 24
2 San Roque Balompie Sub 16 Roque 8 18 10 17
3 Nuevo Molino Sub 16 Nuevo Molino 10 23 17 17
4 CD Utrera Sub 16 Utrera 8 12 11 13
5 Wea Sierra de Cadiz Sierra Cadiz 10 17 18 13
6 Atlético Sanluqueño Sub 16 Atlético 10 22 24 9
7 CD Los Caminantes Caminantes 8 10 13 8
8 CD Apedem A CD Apedem A 8 17 22 7
9 CD Los Califas Balompie Califas 8 11 28 3
TEMPORADA 2019/2020
1ª ANDALUZA CADETE GRUPO 1
Equipo PJ GF GC Puntos
1 Real Betis Sub 16 B Real Betis 23 62 26 52
2 Sevilla FC Sub 16 B Sevilla 23 51 25 48
3 Séneca CF Sub 16 Séneca 23 47 21 47
4 CD Antonio Puerta Sub 16 Antonio 23 43 28 45
5 San Fernando CD Isleño Fernando 23 42 26 41
6 Tomares UD Tomares UD 23 53 38 40
7 Algeciras CF Sub 16 Algeciras 23 57 36 39
8 Atlético Sanluqueño Sub 16 Atlético 23 43 36 36
9 Córdoba CF B Córdoba 23 36 30 36
10 CD Los Califas Balompie Califas 23 44 44 29
11 San Jose Obrero UD Sub 16 Jose Obrero 23 30 35 28
12 CD Los Caminantes Caminantes 23 29 42 22
13 Wea Sierra de Cadiz Sierra Cadiz 23 26 51 22
14 San Roque de Lepe CD Roque Lepe 23 26 64 17
15 CD Utrera Sub 16 Utrera 23 21 63 12
16 CD Siempre Alegres Siempre 23 15 60 7
TEMPORADA 2018/2019
1ª ANDALUZA CADETE GRUPO 1
Equipo PJ GF GC Puntos
1 Sevilla FC Sub 16 B Sevilla 30 108 21 85
2 Real Betis Sub 16 B Real Betis 30 74 16 64
3 Peloteros Sierra Sur Sub 16 Peloteros 30 54 30 59
4 San Fernando Isleño A Fernando 30 66 37 58
5 Recreativo de Huelva Sub 16 Recreativo 30 56 40 56
6 CD Antonio Puerta Sub 16 Antonio 30 65 41 46
7 Wea Sierra de Cadiz Sierra Cadiz 30 38 33 43
8 UD Tomares UD Tomares 30 56 42 41
9 Córdoba CF B Córdoba 30 47 46 37
10 CD Siempre Alegres Siempre 30 40 55 37
11 CD Utrera Sub 16 Utrera 30 33 53 35
12 Algeciras CF Sub 16 Algeciras 30 38 49 34
13 Pozoblanco Pozoblanco 30 41 50 33
14 Salerm Cosmetics Puente Gen Salerm 30 32 58 30
15 Cartaya A Cartaya A 30 16 107 9
16 CD Alcala Sub 16 Alcala 30 15 101 6
TEMPORADA 2017/2018
1ª ANDALUZA CADETE GRUPO 1
Equipo PJ GF GC Puntos
1 Sevilla FC Sub 16 B Sevilla 30 92 27 75
2 Real Betis Sub 16 B Real Betis 30 79 21 69
3 Séneca CF Sub 16 Séneca 30 78 30 66
4 Atlético Sanluqueño Sub 16 Atlético 30 59 29 60
5 San Fernando Isleño A Fernando 30 63 28 56
6 Recreativo de Huelva Sub 16 Recreativo 30 59 40 55
7 Wea Sierra de Cadiz Sierra Cadiz 30 51 36 49
8 UD Tomares UD Tomares 30 58 37 47
9 Salerm Cosmetics Puente Gen Salerm 30 43 49 38
10 Córdoba CF B Córdoba 30 39 50 33
11 CD Utrera Sub 16 Utrera 30 42 69 32
12 Cartaya A Cartaya A 30 46 69 30
13 CD Deportivo Cordoba CF Deportivo 30 25 69 25
14 Don Bosco CF Sub 16 Bosco 30 34 66 21
15 Atlético Seneca Atlético 30 32 64 20
16 Ad Taraguilla Taraguilla 30 16 132 4
TEMPORADA 2016/2017
2ª ANDALUZA CÁDIZ CADETE
Equipo PJ GF GC Puntos
1 Wea Sierra de Cadiz Sierra Cadiz 28 98 30 67
2 Balón De Cádiz CF B Balón 28 86 33 63
3 Algeciras CF Sub 16 Algeciras 28 95 47 58
4 Xerez Deportivo FC Xerez 28 64 35 53
5 Novo Chiclana CD Novo 28 51 55 43
6 La Salle A La Salle A 28 42 51 39
7 Arcos A Arcos A 28 55 57 38
8 San Jose Obrero UD Sub 16 Jose Obrero 28 51 54 38
9 CD Guadalcacín A Guadalcacín 28 43 40 36
10 Sanluqueño Atlético B Sanluqueño 28 50 56 36
11 Atletico Zabal A Atletico 28 40 69 27
12 Santic Petri A Santic Petri 28 33 58 26
13 El Mirador El Mirador 28 30 60 23
14 Pueblo Nuevo La Granja A Pueblo Nuevo 28 34 80 21
15 Taraguilla B Taraguilla 28 51 98 17
TEMPORADA 2015/2016
3ª ANDALUZA CÁDIZ CADETE GRUPO 4
Equipo PJ GF GC Puntos
1 Wea Sierra de Cadiz Sierra Cadiz 20 87 10 57
2 Florida Florida 20 66 27 48
3 Espera CF Espera CF 19 52 52 35
4 Jedula Balompie Jedula 20 62 37 33
5 Bornense Atletico Bornense 20 41 58 25
6 CD UD Villamartín Villamartín 20 42 59 25
7 Ubrique UD Ubrique UD 20 46 70 22
8 CD Olvera CD Olvera 20 52 60 21
9 Atletico San Jose Atletico 20 35 52 20
10 Alcala CD Alcala CD 19 35 65 17
11 Arcos B Arcos B 20 35 63 11
12 Puerto Serrano Atletico Puerto 0 0 0 0
TEMPORADA 2014/2015
3ª ANDALUZA CÁDIZ CADETE GRUPO 7
Equipo PJ GF GC Puntos
1 Wea Sierra de Cadiz Sierra Cadiz 21 104 18 56
2 Florida Florida 21 77 26 49
3 Atletico San Jose Atletico 20 69 34 41
4 Ubrique UD Ubrique UD 22 45 55 31
5 Puerto Serrano Atco. Puerto 21 58 53 30
6 Espera CF Espera CF 21 54 63 29
7 CD UD Villamartín Villamartín 22 45 54 29
8 Alcala del Valle CD Alcala Valle 21 57 61 26
9 Arcos B Arcos B 22 34 60 24
10 CD Olvera CD Olvera 22 58 84 23
11 Algodonales UD Algodonales 18 35 75 15
12 Bornense Bornense 21 28 81 9

  USO DE MEMORIA  
5,400,136 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0021
Controller Execution Time ( Home / Category )  0.1094
Total Execution Time  0.1116
  CADENA URL  
/historico/Wea-Sierra-De-Cadiz-Cadete
  GET DATOS  
$_GET['/historico/Wea-Sierra-De-Cadiz-Cadete']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (33)  
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 = 'Wea-Sierra-De-Cadiz-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.0031  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 = 'Wea-Sierra-De-Cadiz-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=20195 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0021  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=20195 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=20195 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=20195 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=20195 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=20195 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=20195 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=20195 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=20195 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=20195 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=20195 AND type_rel = 2
0.0020  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=447 AND type_rel = 3
0.0023  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 = '20195' 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 = '20195' 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 = '20195' AND ct.ctype=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0038  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=20195 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 (66039,62004) 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 = 62004 AND teamId = 20195
0.0044  SELECT count(id) as num_players from rel_players_base WHERE league_id = 66039 AND teamId = 20195
0.0024  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 = '20195' 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 = '20195' and rp.type = 4
0.0019  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 = '20195' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0022  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 = 20195 AND l.year <= 2022 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.0022  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 = 59847 AND t.round = 14 ORDER BY team.conference ASC,t.position 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 `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 = 62004 AND t.round = 10 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0022  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 = 52405 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.0022  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 = 44970 AND t.round = 30 ORDER BY team.conference 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 `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 = 40112 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0024  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 = 34340 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 `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 = 17259 AND t.round = 22 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0022  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 = 4328 AND t.round = 22 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC