4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del Leon Olimpico
TEMPORADA 2021/2022
3ª ANDALUZA CÁDIZ ALEVÍN GRUPO 1
Equipo PJ GF GC Puntos
1 La Salle La Salle 24 169 37 64
2 CD Lagunense Lagunense 22 133 47 51
3 Ciudad de Cádiz Ciudad 23 119 75 48
4 Gaditana CF CD Gaditana 23 86 51 43
5 Tiempo Libre Tiempo Libre 24 100 84 40
6 Fermin Salvochea Fermin 23 81 86 36
7 Mentidero Cadiz Mentidero 24 84 80 35
8 Leon Olimpico Leon 23 85 95 35
9 Raul Navas Raul Navas 23 118 102 33
10 Panama Panama 24 62 97 23
11 Domingo Savio Domingo 23 43 112 16
12 Santamaria Santamaria 24 57 141 13
13 CD S. Puertorrealeña A Puertorreale 24 33 163 6
TEMPORADA 2019/2020
3ª ANDALUZA CÁDIZ ALEVÍN GRUPO 1
Equipo PJ GF GC Puntos
1 Fundacion cadiz Fundacion 20 123 17 55
2 Fermin Salvochea Fermin 19 79 25 45
3 Ciudad cadiz Ciudad cadiz 18 102 30 44
4 La Salle La Salle 19 112 40 42
5 UD Río San Pedro Río Pedro 19 77 52 36
6 CD Lagunense Lagunense 19 60 39 29
7 Fuerte de San Lorenzo Fuerte 20 71 54 28
8 CD S. Puertorrealeña A Puertorreale 20 74 83 28
9 Tiempo Libre A Tiempo Libre 20 79 73 25
10 Leon Olimpico Leon 20 58 74 20
11 Gaditana CF CD Gaditana 20 55 93 20
12 Mentidero Cadiz A Mentidero 20 37 107 14
13 Santo D. Silos AD Santo Silos 20 45 119 10
14 San Juan Bosco de Futbol Juan Bosco. 20 15 181 1
TEMPORADA 2018/2019
3ª C. LEÓN ALEVÍN GRUPO 15
Equipo PJ GF GC Puntos
1 La Morenica B Morenica 25 199 49 72
2 Cuatrovientos C Cuatroviento 25 177 37 69
3 Santa Marta Santa Marta 25 133 77 52
4 Ponferradina Ponferradina 25 151 96 51
5 Centro Optico Berciano B Centro 25 118 57 44
6 A. Templario B Templario 25 114 71 44
7 F. Cubillos F. Cubillos 25 141 150 37
8 A. Bembibre C Bembibre 25 91 112 30
9 Flores Sil Flores Sil 25 107 138 30
10 San Ignacio B Ignacio 25 114 115 27
11 La Bañeza B Bañeza 25 106 128 25
12 A. Bierzo A. Bierzo 25 95 213 20
13 Leon Olimpico Leon 25 45 204 6
14 Naraya de Halterofilia Naraya 25 47 191 5

  USO DE MEMORIA  
4,698,144 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0012
Controller Execution Time ( Home / Category )  0.1725
Total Execution Time  0.1737
  CADENA URL  
/historico/Cd-Leon-Ff-Olimpico-Alevin
  GET DATOS  
$_GET['/historico/Cd-Leon-Ff-Olimpico-Alevin']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (9)  
0.0105  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=116467 AND type_rel = 2
0.0107  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 = '116467' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0109  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=116467 AND l.year in (2021,2022,2023) ORDER BY l.id DESC, l.year DESC ;
0.0105  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 (65142) 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.0105  SELECT count(id) as num_players from rel_players_base WHERE league_id = 65142 AND teamId = 116467
0.0108  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 = 116467 AND l.year <= 2022 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.0109  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 = 65142 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.0112  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 = 53219 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.0112  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 = 47056 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC