4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del Fermin Salvochea
TEMPORADA 2021/2022
2ª ANDALUZA CÁDIZ PREBENJAMIN GRUPO 1
Equipo PJ GF GC Puntos
1 La Salle A La Salle A 22 149 17 53
2 Mentidero Cadiz Mentidero 22 136 41 53
3 Lagunense Lagunense 22 145 43 51
4 Ciudad de Cadiz Ciudad Cadiz 22 109 64 44
5 CD S. Puertorrealeña B Puertorreale 22 82 49 41
6 Gaditana Gaditana 22 82 91 32
7 Domingo Savio Domingo 22 81 98 29
8 El Carmen de los Barrios de Carmen 22 61 105 24
9 Fermin Salvochea Fermin 22 70 108 21
10 Tiempo Libre Tiempo Libre 22 55 121 17
11 Regina Pacis SD Regina Pacis 22 43 151 13
12 Olimpico Olimpico 22 29 154 2
TEMPORADA 2020/2021
2ª ANDALUZA CÁDIZ PREBENJAMIN GRUPO 1
Equipo PJ GF GC Puntos
1 Ciudad de Cadiz Ciudad Cadiz 1 11 1 3
2 Lagunense Lagunense 1 10 0 3
3 La Salle La Salle 1 8 0 3
4 CD S. Puertorrealeña A Puertorreale 1 2 0 3
5 Mentidero Cadiz Mentidero 1 5 4 3
6 Domingo Savio Domingo 1 4 5 0
7 Fermin Salvochea Fermin 1 0 2 0
8 El Carmen de los Barrios de Carmen 1 0 8 0
9 Regina Pacis SD Regina Pacis 1 1 11 0
10 Gaditana Gaditana 1 0 10 0
TEMPORADA 2019/2020
2ª ANDALUZA CÁDIZ PREBENJAMIN
Equipo PJ GF GC Puntos
1 Domingo Savio Domingo 16 88 38 40
2 Ciudad de Cadiz Ciudad Cadiz 16 106 39 39
3 Santamaria Santamaria 16 88 38 38
4 Lagunense Lagunense 16 70 42 34
5 Tiempo Libre Tiempo Libre 16 87 40 32
6 UD Río San Pedro Río Pedro 16 73 38 30
7 Olimpico Olimpico 16 72 66 21
8 Gaditana Gaditana 16 42 70 14
9 Mentidero Cadiz Mentidero 16 42 55 13
10 Santo Cristo Santo Cristo 16 42 84 10
11 San Juan Bosco de Futbol Juan Bosco. 16 42 105 9
12 Fermin Salvochea Fermin 16 4 141 0
TEMPORADA 2016/2017
2ª ANDALUZA CÁDIZ PREBENJAMIN GRUPO 1
Equipo PJ GF GC Puntos
1 La Salle A La Salle A 28 184 27 78
2 San Juan Bosco Juan Bosco 28 207 63 73
3 Sporting de Puerto Real A Sporting 28 185 42 73
4 Sporting Playa Club Sporting 28 161 63 64
5 Ciudad de Cadiz Ciudad Cadiz 28 161 59 61
6 Lagunense Cadiz A Lagunense 28 144 96 46
7 Mentidero Cadiz Mentidero 28 131 97 46
8 UD Río San Pedro Río Pedro 28 115 90 45
9 Fermin Salvochea Fermin 28 160 140 38
10 Savia Joven Savia Joven 28 82 129 32
11 Olimpico Olimpico 28 88 151 25
12 Gaditana Gaditana 28 72 174 24
13 Tiempo Libre Tiempo Libre 28 50 191 10
14 Geminis Geminis 28 46 226 6
15 Tranvias Club Deportivo Tranvias 28 17 255 1
TEMPORADA 2015/2016
2ª ANDALUZA CÁDIZ PREBENJAMIN GRUPO 1
Equipo PJ GF GC Puntos
1 Fermin Salvochea Fermin 38 255 48 108
2 Sporting de Puerto Real A Sporting 38 255 47 107
3 Ciudad de Cadiz Ciudad Cadiz 38 229 76 88
4 La Salle A La Salle A 38 197 84 87
5 Tiempo Libre Tiempo Libre 38 239 86 83
6 Olimpico A Olimpico A 38 212 92 79
7 Lagunense Cadiz A Lagunense 38 208 101 79
8 Puertorrealeña Puertorreale 38 197 105 76
9 Domingo Savio Domingo 38 173 113 69
10 UD Río San Pedro Río Pedro 38 186 122 63
11 Fuerte de San Lorenzo Fuerte 38 152 153 61
12 Geminis Geminis 38 120 183 46
13 Mentidero Cadiz Mentidero 38 136 160 44
14 San Juan Bosco Juan Bosco 38 111 209 29
15 Gaditana Gaditana 38 80 192 29
16 Savia Joven Savia Joven 38 81 255 21
17 Falla Falla 38 68 221 18
18 Sporting Playa Club Sporting 38 78 255 13
19 Tranvias Club Deportivo Tranvias 38 73 255 13
20 Raul Navas Raul Navas 38 44 255 7
21 Fundacion Cadiz Fundacion 0 0 0 0
TEMPORADA 2014/2015
2ª ANDALUZA CÁDIZ PREBENJAMIN GRUPO 1
Equipo PJ GF GC Puntos
1 Geminis Geminis 34 247 47 95
2 Sporting Playa Club Sporting 34 255 61 94
3 San Juan Bosco Juan Bosco 34 255 45 91
4 Lagunense Cadiz A Lagunense 34 202 80 78
5 Fermin Salvochea Fermin 34 255 84 77
6 Tiempo Libre Tiempo Libre 34 232 77 77
7 Gaditana Gaditana 34 185 112 69
8 Fundacion Cadiz Fundacion 34 177 166 57
9 Cortadura Bahia Cortadura 34 174 142 55
10 Domingo Savio Domingo 34 111 176 43
11 Savia Joven Savia Joven 34 116 154 41
12 Olimpico Olimpico 34 90 208 29
13 Raul Navas Raul Navas 34 94 215 28
14 Campo Aviacion Loreto Campo 34 78 199 24
15 Mentidero Cadiz Mentidero 34 50 211 14
16 Nuevo Pinto Nuevo Pinto 34 35 227 12
17 Polideportivo Cadiz Polideportiv 34 50 228 11
18 Fuerte de San Lorenzo Fuerte 34 45 255 7

  USO DE MEMORIA  
5,156,160 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0022
Controller Execution Time ( Home / Category )  0.4547
Total Execution Time  0.4570
  CADENA URL  
/historico/Fermin-Salvochea-Cd-Prebenjamin
  GET DATOS  
$_GET['/historico/Fermin-Salvochea-Cd-Prebenjamin']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (28)  
0.0131  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 = 'Fermin-Salvochea-Cd-Prebenjamin' 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.0139  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 = 'Fermin-Salvochea-Cd-Prebenjamin' 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=34120 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=34120 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=34120 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=34120 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=34120 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=34120 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=34120 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0133  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 = 64991
0.0124  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=34120 AND type_rel = 2
0.0125  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=954 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 = '34120' AND l.year = 2022 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 = '34120' 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 = 64991 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0130  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=34120 AND l.year in (2021,2022,2023) 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 (64991) 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.0125  SELECT count(id) as num_players from rel_players_base WHERE league_id = 64991 AND teamId = 34120
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 `tables2022` 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 = 64991 AND t.round = 22 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0126  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 = '34120' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0126  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 = '34120' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0127  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 = 34120 AND l.year <= 2022 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
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 `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 = 64991 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.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 `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 = 60738 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 `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 = 53401 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.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 `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 = 35246 AND t.round = 30 ORDER BY team.conference 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 `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 = 18469 AND t.round = 42 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
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 `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 = 6132 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC