4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del Vejer Balompie
TEMPORADA 2023/2024
3ª ANDALUZA CÁDIZ JUVENIL GRUPO 1
Equipo PJ GF GC Puntos
1 Arcos CF Arcos CF 26 92 27 65
2 Chiclana Industrial Chiclana 25 86 35 65
3 Cádiz CF B Cádiz CF B 25 87 19 60
4 Juventud Sanluqueña Juventud 25 67 35 56
5 Ciudad de Cadiz Ciudad Cadiz 25 68 29 45
6 Chipiona CF A Chipiona 25 55 30 45
7 Trasmallo Trasmallo 25 52 36 43
8 Racing Portuense Racing 25 52 50 36
9 Ubrique UD Ubrique UD 25 57 58 33
10 Vejer Balompie Vejer 25 35 55 28
11 Divina Pastora Sanluqueña Divina 25 40 56 24
12 CD La Salle CD La Salle 25 40 60 24
13 Tiempo Libre A.D. Tiempo Libre 25 43 66 24
14 Puerto Serrano Atletico Puerto 26 32 77 17
15 Algaida B Algaida B 25 19 90 8
16 CD Guadalcacin Guadalcacin 25 15 117 5
TEMPORADA 2022/2023
3ª ANDALUZA CÁDIZ JUVENIL GRUPO 1
Equipo PJ GF GC Puntos
1 Conil Sub 19 Conil 30 75 35 65
2 Bahia San Fernando Sub 19 Bahia 30 74 34 64
3 Algeciras CF B Juvenil Algeciras 30 67 32 60
4 RB Linense RB Linense 30 52 32 53
5 Loluba Loluba 30 75 55 47
6 Ciudad de Cadiz Ciudad Cadiz 30 72 64 43
7 Vejer Balompie Vejer 30 47 58 41
8 El Mirador El Mirador 30 57 64 40
9 Juventud Palmones Juventud 29 46 54 40
10 Chiclana CF B Chiclana 30 49 55 37
11 CD San Roque Roque 30 49 48 34
12 CD La Salle CD La Salle 30 53 72 33
13 Tiempo Libre A.D. Tiempo Libre 30 44 61 32
14 Sancti-Petri Sancti-Petri 30 31 57 30
15 Tarifa Tarifa 30 39 66 26
16 CD Benalup CD Benalup 29 30 73 18
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
3ª ANDALUZA CÁDIZ JUVENIL GRUPO 3
Equipo PJ GF GC Puntos
1 Vejer Balompie Vejer 15 43 16 33
2 Castellar Castellar 16 40 23 32
3 Guadiaro Guadiaro 16 44 29 30
4 CD Benalup CD Benalup 16 33 26 28
5 CD San Roque Roque 16 24 28 22
6 Villa de los Barrios Villa 15 24 35 17
7 At. Zabal Sub 19 Zabal 16 20 23 16
8 San Garcia San Garcia 16 27 48 12
9 Barbate C.F. Barbate C.F. 16 21 48 8
TEMPORADA 2018/2019
3ª ANDALUZA CÁDIZ JUVENIL GRUPO 1
Equipo PJ GF GC Puntos
1 Athletic Jimena Athletic 14 41 35 26
2 Villa de los Barrios Villa 14 39 19 22
3 San Garcia San Garcia 14 25 19 22
4 Vejer Balompie Vejer 14 25 21 20
5 C.D. Salesianos Algeciras C.D. 14 21 26 19
6 Calderon Calderon 14 32 29 18
7 Barbate C.F. Barbate C.F. 14 21 27 18
8 Castellar Castellar 14 13 41 11
TEMPORADA 2017/2018
3ª ANDALUZA CÁDIZ JUVENIL GRUPO 1
Equipo PJ GF GC Puntos
1 San Bernardo Bernardo 30 82 33 72
2 Algeciras CF B Juvenil Algeciras 28 76 23 68
3 Sancti-Petri Sancti-Petri 29 77 36 58
4 Domingo Savio A.D.J. Domingo 29 61 34 55
5 CD San Fernando Isleño B Fernando 28 48 23 52
6 Chiclana Industrial Chiclana 29 43 34 48
7 Castellar Castellar 30 62 57 45
8 Villa de Los Barrios A Villa 29 62 45 41
9 Vejer Balompie Vejer 30 51 54 35
10 Athletic Jimena Athletic 28 50 49 34
11 San Fernando Atletico B Fernando 30 45 72 27
12 San Garcia San Garcia 29 46 62 26
13 Barbate C.F. Barbate C.F. 29 31 59 25
14 Chiclana CF B Chiclana 28 37 97 22
15 Andalucia C.M. Andalucia 19 29 45 15
16 Tiempo Libre A.D. Tiempo Libre 25 22 99 6
TEMPORADA 2016/2017
4ª ANDALUZA CÁDIZ JUVENIL GRUPO 1
Equipo PJ GF GC Puntos
1 UD Río San Pedro Río Pedro 20 108 27 53
2 San Fernando Atletico B Fernando 20 81 8 53
3 Vejer Balompie Vejer 20 85 18 49
4 Sanix La Isla Sanix Isla 20 57 42 35
5 La Salle Sub 19 Salle 21 33 25 31
6 C.D. Olímpic 'A' C.D. 21 42 34 30
7 Tiempo Libre B AD Tiempo Libre 20 48 54 28
8 Bahia San Fernando Sub 19 Bahia 21 47 70 21
9 Grupo Empresa Bazán Grupo 13 17 27 20
10 Cañorrera Cañorrera 19 38 51 20
11 Burreños Burreños 19 23 68 15
12 Escuela Futbol Paquete B Escuela 20 26 85 12
13 Sporting de Puerto Real Sporting 20 19 115 0
TEMPORADA 2015/2016
4ª ANDALUZA CÁDIZ JUVENIL GRUPO 4
Equipo PJ GF GC Puntos
1 San Bernardo Bernardo 22 90 29 52
2 Algeciras CF B Juvenil Algeciras 22 67 21 50
3 Barbate C.F. Barbate C.F. 21 66 23 49
4 Vejer Balompie Vejer 22 46 30 42
5 Novo Gazul Novo Gazul 22 46 37 37
6 Guadiaro Guadiaro 21 52 50 35
7 Atletico Zabal B Atletico 17 36 37 23
8 Puente Mayorga Puente 21 30 49 22
9 Villa de los Barrios B Villa 21 40 48 20
10 Peña Madridista Linense Peña 22 42 51 18
11 Atletico Pastores Algeciras Atletico 22 24 67 15
12 Cuesta del Rayo Veteranos Cuesta Rayo 21 16 113 3
TEMPORADA 2014/2015
3ª ANDALUZA CÁDIZ JUVENIL GRUPO 1
Equipo PJ GF GC Puntos
1 Divina Pastora Divina 30 92 36 70
2 CD Rota Sub 19 Rota 30 83 40 66
3 Rvo Portuense Club Fútbol B Portuense 30 61 31 60
4 Trasmallo Trasmallo 30 56 30 58
5 CD San Fernando Isleño B Fernando 30 58 34 54
6 San Fernando Atco. Fernando 30 52 51 48
7 Roteña Roteña 30 52 42 47
8 Domingo Savio A.D.J. Domingo 30 57 67 46
9 Grupo Empresa Bazán Grupo 30 54 49 45
10 Chipiona CF A Chipiona 30 39 41 37
11 CD UD Villamartín Villamartín 30 50 63 35
12 Safa San Luis Safa Luis 30 39 54 31
13 Chiclana CF B Chiclana 30 51 64 27
14 Vejer Balompie Vejer 30 27 66 23
15 Ubrique UD Ubrique UD 30 41 75 22
16 CD Olvera CD Olvera 30 39 108 13
TEMPORADA 2013/2014
3ª ANDALUZA CÁDIZ JUVENIL GRUPO 2
Equipo PJ GF GC Puntos
1 Balona Balompié Balona 26 92 37 67
2 Algeciras CF Sub 19 Algeciras 26 79 19 66
3 AD Taraguilla Juvenil Taraguilla 26 70 31 56
4 Andalucia C.M. Andalucia 26 56 44 47
5 Loluba Loluba 26 57 51 38
6 Chiclana CF B Chiclana 26 52 47 37
7 Sidonia Balompie Sidonia 26 50 41 36
8 Calderón Calderón 26 57 55 35
9 Vejer Balompie Vejer 26 47 63 32
10 Los Cortijillos Cortijillos 26 44 55 29
11 Xerez Balompie Xerez 26 42 61 28
12 Athletic Jimena Athletic 26 40 60 22
13 CD San Roque Sub 19 Roque 26 31 80 17
14 Peña Madridista Peña 26 35 108 9
15 Barbate C.F. Barbate C.F. 0 0 0 0

  USO DE MEMORIA  
5,594,616 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0013
Controller Execution Time ( Home / Category )  0.4253
Total Execution Time  0.4267
  CADENA URL  
/historico/Vejer-Balompie
  GET DATOS  
$_GET['/historico/Vejer-Balompie']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (25)  
0.0142  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 = 'Vejer-Balompie' 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.0125  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=14336 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0125  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=14336 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0125  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=14336 AND type_rel = 2
0.0126  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=438 AND type_rel = 3
0.0128  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 = '14336' ORDER BY l.year DESC,cat.coefficient DESC
0.0129  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 = '14336' AND l.year = 2024 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 = '14336' 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 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=14336 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0126  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 (74773) 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 = 74773 AND teamId = 14336
0.0130  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 = '14336' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0126  SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '14336' and rp.type = 4
0.0131  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 = '14336' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0142  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 = 14336 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.0145  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 = 74773 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.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 = 69706 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.0148  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.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 `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 = 59551 AND t.round = 18 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0131  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 = 45795 AND t.round = 14 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 `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 = 39984 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0130  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 = 34202 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0128  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 = 17067 AND t.round = 22 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0134  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 = 4276 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 = 3031 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC