4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del CF Jerez Industrial 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
2ª ANDALUZA CÁDIZ JUVENIL
Equipo PJ GF GC Puntos
1 La Salle Sub 19 Salle 29 79 37 65
2 At. Zabal Sub 19 Zabal 30 54 27 56
3 CF Chiclana Sub 19 Chiclana 30 56 39 54
4 San Fernando Atl. Sub 19 Fernando 29 67 39 49
5 At. Sanluqueño B Sub 19 Sanluqueño 29 67 46 49
6 San Fernando Isleño CD B Su Fernando 29 64 46 49
7 Sporting Chiclana Sub 19 Sporting 30 70 51 48
8 CF Arcos A Sub 19 Arcos 29 56 47 46
9 CD Guadalcacín A Sub 19 Guadalcacín 30 67 67 43
10 CD Rota Sub 19 Rota 30 50 45 36
11 CF Jerez Industrial Sub 19 Jerez 30 61 64 35
12 CD San Roque Sub 19 Roque 29 65 79 35
13 Estrella Portuense Sub 19 Estrella 30 53 70 34
14 San Jose Obrero UD A Jose Obrero 29 37 54 31
15 Guadiaro Guadiaro 30 47 76 25
16 Castellar Castellar 23 21 127 0
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 2020/2021
4ª ANDALUZA CÁDIZ JUVENIL GRUPO 7
Equipo PJ GF GC Puntos
1 Aficion Xerecista Aficion 12 41 13 34
2 San Benito CF Benito 12 29 30 19
3 Arcos CF Arcos CF 11 26 22 18
4 CD CLVT Prado del Rey CLVT Prado 12 28 33 16
5 CF Jerez Industrial Sub 19 Jerez 12 33 26 15
6 La Jerezana La Jerezana 12 16 25 11
7 Ubrique UD Ubrique UD 11 13 37 7
TEMPORADA 2019/2020
3ª ANDALUZA CÁDIZ JUVENIL GRUPO 2
Equipo PJ GF GC Puntos
1 Fundacion Cadiz CF CD Fundacion 23 56 12 54
2 Chipiona CF A Chipiona 23 67 38 52
3 Xerez Deportivo FC Xerez 23 57 31 52
4 Veteranos Xerez Veteranos 23 69 32 51
5 CF Jerez Industrial Sub 19 Jerez 23 51 31 48
6 Roteña Roteña 23 49 32 34
7 CD Olvera CD Olvera 23 51 47 32
8 Amigos Cruz Roja Jerez Amigos Cruz 23 45 46 31
9 Estrella Portuense Sub 19 Estrella 23 47 51 31
10 Paquete Paquete 23 45 48 30
11 Recreativo Portuense Recreativo 23 41 48 27
12 Divina Pastora Sanluqueña Divina 23 45 64 27
13 UD Río San Pedro Río Pedro 23 38 62 20
14 CD Guadalcacín B Guadalcacín 23 28 60 17
15 Xerez Xerez 23 33 72 9
16 CD UD Villamartín Villamartín 23 23 71 4
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
TEMPORADA 2017/2018
3ª ANDALUZA CÁDIZ JUVENIL GRUPO 2
Equipo PJ GF GC Puntos
1 San Jose Obrero UD A Jose Obrero 29 59 22 67
2 La Salle A La Salle A 30 79 40 58
3 Trasmallo Trasmallo 29 75 40 58
4 Xerez Deportivo B Xerez 29 80 33 56
5 CF Jerez Industrial Sub 19 Jerez 29 70 46 54
6 CD Jédula CD Jédula 29 52 53 50
7 Xerez CD SAD Xerez 29 58 39 45
8 UD Río San Pedro Río Pedro 29 59 54 40
9 Rvo Portuense Club Futbol B Portuense 29 52 48 37
10 Chipiona CF A Chipiona 29 48 57 35
11 CD UD Villamartín Villamartín 29 51 65 35
12 Divina Pastora Sanluqueña A Divina 29 66 89 33
13 Escuela Futbol Paquete A Escuela 29 50 71 29
14 CD Rota Sub 19 Rota 29 60 78 27
15 Liberacion A Liberacion 16 20 54 7
16 Arcos CF B Arcos CF B 29 24 114 4
TEMPORADA 2016/2017
3ª ANDALUZA CÁDIZ JUVENIL GRUPO 2
Equipo PJ GF GC Puntos
1 Roteña Roteña 25 59 23 56
2 Pueblo Nuevo La Granja Pueblo Nuevo 25 63 35 52
3 CD La Salle CD La Salle 25 63 26 51
4 CF Jerez Industrial Sub 19 Jerez 25 70 38 47
5 San Jose Obrero UD B Jose Obrero 25 54 27 44
6 CD Jédula CD Jédula 25 31 24 39
7 Trasmallo Trasmallo 25 48 55 38
8 Liberación Liberación 25 59 55 37
9 CD Rota Sub 19 Rota 25 45 49 33
10 Arcos CF B Arcos CF B 25 31 66 24
11 Divina Pastora B Divina 25 41 71 23
12 CD UD Villamartín Villamartín 25 44 68 19
13 Chipiona CF A Chipiona 25 37 68 19
14 Puerto Serrano Atco. Puerto 13 16 56 5
TEMPORADA 2015/2016
3ª ANDALUZA CÁDIZ JUVENIL GRUPO 2
Equipo PJ GF GC Puntos
1 C.D. Salesianos Algeciras C.D. 28 110 37 65
2 Xerez Deportivo B Xerez 28 85 28 62
3 Medina Balompie Medina 28 88 42 56
4 CF Jerez Industrial Sub 19 Jerez 28 77 44 51
5 CD San Roque Sub 19 Roque 28 72 41 47
6 Pueblo Nuevo La Granja Pueblo Nuevo 28 50 40 47
7 Liberación Liberación 28 71 57 45
8 Villa de los Barrios Villa 28 75 45 43
9 Andalucia C.M. Andalucia 28 48 50 41
10 San García San García 28 61 63 39
11 Athletic Jimena Athletic 28 47 65 31
12 AD Taraguilla B Taraguilla 28 43 67 26
13 Loluba Loluba 28 34 111 17
14 U.D. Tesorillo U.D. 28 36 110 11
15 Xerez Balompie Xerez 28 20 117 6
16 Calderón Calderón 0 0 0 0
TEMPORADA 2014/2015
3ª ANDALUZA CÁDIZ JUVENIL GRUPO 2
Equipo PJ GF GC Puntos
1 Xerez Deportivo FC Sub 19 Xerez 28 128 15 80
2 Tarifa Tarifa 28 88 33 59
3 AD Taraguilla Juvenil Taraguilla 28 66 37 55
4 C.D. Salesianos Algeciras C.D. 28 73 42 44
5 CD San Roque Sub 19 Roque 28 54 48 40
6 CF Jerez Industrial Sub 19 Jerez 28 51 64 39
7 Pueblo Nuevo La Granja Pueblo Nuevo 28 56 56 38
8 U.D. Tesorillo U.D. 28 54 57 38
9 Athletic Jimena Athletic 28 49 56 36
10 Andalucia C.M. Andalucia 28 54 55 34
11 Loluba Loluba 28 58 96 31
12 Calderón Calderón 28 50 83 28
13 Xerez Balompie Xerez 28 37 92 26
14 Los Cortijillos Cortijillos 28 49 76 23
15 San Benito C.F. Benito C.F. 28 45 102 21
16 Federico Mayo C.F. Federico 0 0 0 0
TEMPORADA 2013/2014
4ª ANDALUZA CÁDIZ JUVENIL GRUPO 2
Equipo PJ GF GC Puntos
1 CD Olvera CD Olvera 28 120 53 67
2 Xerez Balompie Xerez 29 108 32 66
3 Ubrique UD Ubrique UD 29 121 34 64
4 Nueva Jarilla A.D Nueva 28 102 59 55
5 Pueblo Nuevo La Granja Pueblo Nuevo 29 78 66 49
6 San José Obrero José Obrero 27 91 75 45
7 Bornense Bornense 27 84 43 44
8 Torrecera Torrecera 29 70 49 44
9 Arcos CF B Arcos CF B 28 66 55 42
10 CF Jerez Industrial Sub 19 Jerez 29 95 79 41
11 Paquete Paquete 29 99 80 37
12 CD Jédula CD Jédula 28 85 97 35
13 Xerez Distrito Norte Xerez 27 44 136 14
14 Federico Mayo C.F. Federico 7 9 36 1
15 Distrito La Granja Distrito 14 12 81 1
16 Altillo Altillo 27 18 225 0

  USO DE MEMORIA  
5,800,672 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0013
Controller Execution Time ( Home / Category )  0.0973
Total Execution Time  0.0987
  CADENA URL  
/historico/Jerez-Industrial
  GET DATOS  
$_GET['/historico/Jerez-Industrial']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (26)  
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 = 'Jerez-Industrial' 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=14328 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=14328 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=14328 AND type_rel = 2
0.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=433 AND type_rel = 3
0.0025  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 = '14328' AND l.year = 2024 ORDER BY l.year DESC,cat.coefficient DESC
0.0022  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 = '14328' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0022  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.0026  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=14328 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) 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 = 14328
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 `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.0023  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 = 14328 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
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 `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.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 `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 = 68952 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.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 = 59549 AND t.round = 22 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 = 59856 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.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 `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 = 52913 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 `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.0033  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 = 39985 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0038  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 = 34221 AND t.round = 30 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 `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 = 17037 AND t.round = 30 ORDER BY team.conference 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 `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 = 4282 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0033  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 = 3030 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0031  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 = 3040 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC