4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del Xerez Deportivo Sub 19
TEMPORADA 2023/2024
2ª ANDALUZA CÁDIZ JUVENIL
Equipo PJ GF GC Puntos
1 At. Zabal Sub 19 Zabal 27 57 24 59
2 CF Jerez Industrial Sub 19 Jerez 27 50 26 58
3 Sporting Chiclana Sub 19 Sporting 27 56 39 51
4 San Fernando Isleño Sub 19 Fernando 27 44 22 50
5 CD Guadalcacín A Sub 19 Guadalcacín 27 49 34 48
6 Xerez Deportivo Sub 19 Xerez 27 34 20 42
7 Estrella Portuense Sub 19 Estrella 27 33 38 38
8 CF Arcos A Sub 19 Arcos 27 46 40 36
9 Bahia San Fernando Sub 19 Bahia 27 36 39 35
10 CD San Roque Sub 19 Roque 27 32 43 34
11 Conil Sub 19 Conil 27 27 45 32
12 At. Sanluqueño B Sub 19 Sanluqueño 27 31 40 30
13 CD Rota Sub 19 Rota 27 36 48 29
14 CF Sherry Atlético Sub 19 Sherry 27 27 48 25
15 CF Chiclana Sub 19 Chiclana 27 29 54 24
16 San Fernando Atl. Sub 19 Fernando 27 24 51 16
TEMPORADA 2022/2023
3ª ANDALUZA CÁDIZ JUVENIL GRUPO 2
Equipo PJ GF GC Puntos
1 CF Sherry Atlético Sub 19 Sherry 30 71 28 71
2 Xerez Deportivo Sub 19 Xerez 30 57 25 64
3 Puerto Serrano Atletico Puerto 29 64 41 56
4 Veteranos Xerez Veteranos 29 55 42 51
5 Trasmallo Trasmallo 29 63 49 48
6 Liberacion A Liberacion 30 58 41 44
7 Marianistas Marianistas 29 56 46 43
8 CD Guadalcacin Guadalcacin 29 51 43 43
9 Chipiona CF A Chipiona 30 58 45 40
10 Racing Portuense Racing 30 60 66 36
11 Aficion Xerecista Aficion 30 39 48 35
12 Divina Pastora Sanluqueña Divina 29 43 49 30
13 Espera CF Espera CF 23 32 46 30
14 Roteña Roteña 29 41 70 24
15 Escuela Futbol Paquete Escuela 30 39 78 18
16 CD Olvera CD Olvera 30 32 102 16
TEMPORADA 2021/2022
2ª ANDALUZA CÁDIZ JUVENIL
Equipo PJ GF GC Puntos
1 CD Guadalcacín A Sub 19 Guadalcacín 32 95 33 74
2 Xerez Deportivo Sub 19 Xerez 31 86 31 73
3 San Fernando Atl. Sub 19 Fernando 32 84 48 62
4 La Salle Sub 19 Salle 32 80 45 55
5 CF Arcos A Sub 19 Arcos 32 65 57 54
6 Castellar Castellar 31 61 51 52
7 San Fernando Isleño CD B Su Fernando 32 89 51 51
8 CF Chiclana Sub 19 Chiclana 32 55 44 48
9 CF Jerez Industrial Sub 19 Jerez 31 56 46 45
10 CD San Roque Sub 19 Roque 31 70 75 44
11 San Jose Obrero UD A Jose Obrero 29 40 56 41
12 Estrella Portuense Sub 19 Estrella 31 56 58 35
13 Chipiona CF A Chipiona 31 45 73 34
14 Algeciras B Algeciras B 32 42 68 24
15 Tarifa Tarifa 31 35 93 24
16 Vejer Balompie Vejer 32 32 101 20
17 Veteranos Xerez Veteranos 32 36 97 19
18 Wea Sierra de Cadiz Sierra Cadiz 0 0 0 0
TEMPORADA 2018/2019
3ª ANDALUZA CÁDIZ JUVENIL GRUPO 4
Equipo PJ GF GC Puntos
1 Marianistas Marianistas 14 32 9 36
2 Xerez Deportivo Sub 19 Xerez 14 42 11 31
3 CF Jerez Industrial Sub 19 Jerez 14 29 19 23
4 Xerez CD SAD Xerez 14 25 19 21
5 CD Guadalcacín B Guadalcacín 14 18 22 21
6 CD UD Villamartín Villamartín 14 25 33 16
7 CD Jédula CD Jédula 14 15 45 5
8 Pueblo Nuevo La Granja Pueblo Nuevo 14 10 38 4

  USO DE MEMORIA  
4,892,832 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0021
Controller Execution Time ( Home / Category )  0.0795
Total Execution Time  0.0817
  CADENA URL  
/historico/Xerez-Deportivo-Fc-Juvenil
  GET DATOS  
$_GET['/historico/Xerez-Deportivo-Fc-Juvenil']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (23)  
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 = 'Xerez-Deportivo-Fc-Juvenil' 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.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=113882 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=113882 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=113882 AND type_rel = 2
0.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=433 AND type_rel = 3
0.0021  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 = '113882' ORDER BY l.year DESC,cat.coefficient DESC
0.0021  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 = '113882' AND l.year = 2024 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 = '113882' 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 = 73829 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0021  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=113882 AND l.year in (2023,2024,2025) 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 (73829,69711) 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 = 73829 AND teamId = 113882
0.0018  SELECT count(id) as num_players from rel_players_base WHERE league_id = 69711 AND teamId = 113882
0.0019  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff 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 = 73829 AND t.round = 27 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0020  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 = '113882' 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 = '113882' and rp.type = 4
0.0021  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 = '113882' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0021  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 = 113882 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
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 `tables2024_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 = 73829 AND t.round = 27 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 `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 = 69711 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.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 `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 = 65908 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.0025  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 = 45798 AND t.round = 14 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 = 73829 ORDER BY nameShow LIMIT 100