4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del San Luis
TEMPORADA 2021/2022
3ª ANDALUZA CÁDIZ PREBENJAMIN GRUPO 1
Equipo PJ GF GC Puntos
1 Burreños Asociación Burreños 26 195 19 74
2 Lagunense Lagunense 26 191 43 68
3 CD Colegio Guadalete Colegio 26 124 53 60
4 Trasmallo FC CD A Trasmallo 26 132 55 58
5 CD Los Frailes Frailes 26 95 45 56
6 Portuense Rvo Club Futbol Portuense 26 104 65 45
7 CD La Salle B Salle 26 96 87 31
8 Futbol Vejer Futbol Vejer 26 68 106 31
9 Trasmallo B Trasmallo B 26 54 122 26
10 San Marcos San Marcos 26 47 113 23
11 Tiempo Libre Tiempo Libre 26 40 113 23
12 San Luis San Luis 26 64 128 22
13 Racing Club Portuense Racing Club 26 40 147 9
14 La Salle A La Salle A 26 18 172 4
TEMPORADA 2019/2020
2ª ANDALUZA CÁDIZ PREBENJAMIN GRUPO 3
Equipo PJ GF GC Puntos
1 CD S. Puertorrealeña A Puertorreale 16 90 24 42
2 La Salle La Salle 16 83 26 38
3 Trasmallo FC CD Trasmallo 16 67 38 37
4 Portuense Rvo Club Futbol Portuense 16 90 23 35
5 Nextstars Nextstars 16 67 42 33
6 San Marcos San Marcos 16 51 47 26
7 Estrella Portuense Estrella 15 51 52 21
8 Ronda de Valencia Ronda 16 35 50 18
9 CD Los Frailes Frailes 15 42 86 9
10 El Juncal Atletico Juncal 16 29 68 6
11 CD Colegio Guadalete Colegio 15 41 117 4
12 San Luis San Luis 13 15 88 3
TEMPORADA 2018/2019
2ª ANDALUZA CÁDIZ PREBENJAMIN GRUPO 3
Equipo PJ GF GC Puntos
1 Recreativo Club Portuense F Recreativo 24 145 34 61
2 Nextstars Nextstars 24 116 33 60
3 Barriada de La Playa Barriada 24 108 49 56
4 Trasmallo FC CD Trasmallo 24 143 54 51
5 Los Frailes Caldevilla Hoga Frailes 24 95 63 46
6 CD S. Puertorrealeña A Puertorreale 24 104 64 43
7 Estrella Portuense Estrella 24 81 68 34
8 La Salle La Salle 24 86 80 34
9 San Luis San Luis 24 49 106 20
10 San Marcos San Marcos 24 44 109 19
11 El Juncal Atletico Juncal 24 45 111 15
12 Atletico Los Puertos Atletico 24 33 175 10
13 Ronda de Valencia Ronda 24 32 135 6

  USO DE MEMORIA  
4,723,824 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0014
Controller Execution Time ( Home / Category )  0.0500
Total Execution Time  0.0514
  CADENA URL  
/historico/Cd-Safa-San-Luis-Prebenjamin
  GET DATOS  
$_GET['/historico/Cd-Safa-San-Luis-Prebenjamin']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (10)  
0.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=118037 AND type_rel = 2
0.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=959 AND type_rel = 3
0.0037  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 = '118037' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0021  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=118037 AND l.year in (2021,2022,2023) ORDER BY l.id DESC, l.year DESC ;
0.0018  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 (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.0018  SELECT count(id) as num_players from rel_players_base WHERE league_id = 64986 AND teamId = 118037
0.0020  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 = 118037 AND l.year <= 2022 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
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 `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.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 `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 = 53403 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.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 `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 = 47900 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC