4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del La Salle A
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 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 2
Equipo PJ GF GC Puntos
1 Aguila Aguila 18 136 26 51
2 Escuela Bahia San Fernando Escuela 18 120 35 46
3 Puertorrealeña Puertorreale 18 87 33 40
4 San Fernando Atletico Fernando 18 103 18 38
5 Isla de Leon Futbol Base Isla Leon F. 18 76 75 28
6 Sporting de Puerto Real A Sporting 18 75 51 26
7 La Salle A La Salle A 18 49 78 17
8 Pastora 1966 Pastora 1966 18 36 101 13
9 UD Río San Pedro Río Pedro 18 23 129 6
10 Junior Junior 0 0 0 0
11 Sanix La Isla Sanix Isla 0 0 0 0
12 Cañorrera Cañorrera 18 8 167 0

  USO DE MEMORIA  
5,053,408 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0013
Controller Execution Time ( Home / Category )  0.3263
Total Execution Time  0.3276
  CADENA URL  
/historico/Cd-La-Salle-A-Prebenjamin
  GET DATOS  
$_GET['/historico/Cd-La-Salle-A-Prebenjamin']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (17)  
0.0255  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 = 64986
0.0132  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.0126  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=32846 AND type_rel = 2
0.0125  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=959 AND type_rel = 3
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 = '32846' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0126  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.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 = 64986 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0128  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=32846 AND l.year in (2021,2022,2023) ORDER BY l.id DESC, l.year DESC ;
0.0127  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,64986) 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 = 64986 AND teamId = 32846
0.0125  SELECT count(id) as num_players from rel_players_base WHERE league_id = 64991 AND teamId = 32846
0.0129  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 = 32846 AND l.year <= 2022 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.0133  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 = 64986 AND t.round = 26 ORDER BY team.conference ASC,t.position 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 `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.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 `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.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 `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.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 `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 = 6133 AND t.round = 22 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC