4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del La Salle
TEMPORADA 2022/2023
2ª ANDALUZA CÁDIZ ALEVÍN
Equipo PJ GF GC Puntos
1 Sancti-Petri APA AD Sancti-Petri 30 131 54 75
2 San Roque San Roque 30 130 52 71
3 Estrella Portuense Estrella 30 115 68 62
4 Atlético Sanluqueño Atlético 30 118 69 60
5 Taraguilla B Taraguilla 30 117 93 58
6 Cadiz CF B Cadiz CF B 30 122 78 54
7 Arcos Club de Fútbol Academ Arcos Club. 30 85 88 44
8 Monitores Futbol De Algecir Monitores 30 96 85 42
9 Atletico Zabal Atletico 30 98 103 42
10 San Jose Obrero Jose Obrero 30 88 97 38
11 La Salle La Salle 30 74 88 36
12 Trasmallo Trasmallo 30 85 115 33
13 Chipiona CF C Chipiona 30 82 128 27
14 Ciudad de Cádiz Ciudad 30 65 105 23
15 CD AD Pueblo Nuevo La Granj Pueblo Nuevo 30 76 125 23
16 Sporting Chiclana Sporting 30 20 154 3
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 2020/2021
4ª ANDALUZA CÁDIZ ALEVÍN GRUPO 1
Equipo PJ GF GC Puntos
1 La Salle La Salle 8 36 14 19
2 Ciudad de Cádiz Ciudad 9 35 16 19
3 Escuela Bahia San Fernando Escuela 7 39 13 18
4 Mentidero Cadiz Mentidero 8 38 26 13
5 Cadista de la isla Cadista isla 8 21 27 9
6 Trasmallo B Trasmallo B 8 25 28 7
7 Tiempo Libre Tiempo Libre 7 15 24 6
8 Pastora 1966 Pastora 1966 8 6 61 1
9 CD Lagunense Lagunense 1 0 6 0
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ª ANDALUZA CÁDIZ ALEVÍN GRUPO 3
Equipo PJ GF GC Puntos
1 Estrella Portuense Estrella 28 176 42 75
2 Los Frailes Los Frailes 28 199 49 69
3 CD S. Puertorrealeña A Puertorreale 28 151 54 69
4 Trasmallo Trasmallo 28 132 60 63
5 RC Portuense A Portuense 28 136 70 57
6 La Salle La Salle 28 148 90 50
7 El Juncal Atletico Juncal 28 120 92 49
8 Portuense Fútbol Sala Portuense 28 101 96 45
9 Barriada de la Playa Barriada 28 93 115 30
10 Ronda de Valencia Ronda 28 80 116 30
11 CD Colegio Guadalete A Colegio 28 71 141 25
12 La Salle Chiclana Salle 28 71 137 23
13 Rvo Portuense Club Futbol B Portuense 28 56 151 17
14 Nextstars F.C. Nextstars 28 59 169 11
15 San Marcos San Marcos 28 30 241 1
16 Safa San Luis Safa Luis 0 0 0 0
TEMPORADA 2017/2018
1ª C. LEÓN ALEVÍN GRUPO 4
Equipo PJ GF GC Puntos
1 La Amistad La Amistad 22 199 25 62
2 CD Marista de FS Marista 22 175 19 60
3 San Telmo San Telmo 22 125 70 52
4 Atlético Aguilar Atlético 22 99 56 43
5 C.D. Claret C.D. Claret 22 92 53 43
6 San Juanillo Juanillo 22 89 58 37
7 La Salle La Salle 22 80 112 27
8 Herrera P. Herrera P. 22 76 118 20
9 San Antonio San Antonio 22 64 167 17
10 CD Pisuerga V de Baños Pisuerga 22 55 120 16
11 Guardense Guardense 22 38 181 9
12 CD D Base Villamuriel Base 22 48 161 1
TEMPORADA 2016/2017
2ª C. LEÓN ALEVÍN GRUPO 5
Equipo PJ GF GC Puntos
1 Amistad B Amistad B 20 137 39 52
2 A. Aguilar B Aguilar 20 100 50 51
3 Marista de B Marista 20 107 66 40
4 San Juanillo B Juanillo 20 91 52 39
5 Saldaña Saldaña 20 90 60 37
6 Paredes N. Paredes N. 20 66 65 34
7 La Salle La Salle 20 86 100 22
8 Pan Y Guindas Guindas 20 49 102 15
9 San Telmo B San Telmo B 20 50 113 15
10 C.D. Claret C.D. Claret 20 46 111 12
11 Pisuerga B. B Pisuerga 20 45 109 9
12 San Antonio B Antonio 0 0 0 0
TEMPORADA 2015/2016
2ª C. LEÓN ALEVÍN GRUPO 5
Equipo PJ GF GC Puntos
1 Amistad B Amistad B 20 87 30 52
2 San Juanillo B Juanillo 20 124 40 50
3 La Salle La Salle 20 94 36 47
4 Paredes N. Paredes N. 20 114 57 45
5 C.D. Claret C.D. Claret 20 79 74 32
6 Atlético Aguilar Atlético 20 70 82 24
7 Saldaña Saldaña 20 65 70 23
8 San Telmo B San Telmo B 20 74 82 20
9 Pisuerga B. B Pisuerga 20 31 67 14
10 San Antonio B Antonio 20 49 101 9
11 Ave Maria B Ave Maria B 20 25 173 3
TEMPORADA 2014/2015
3ª C. LEÓN ALEVÍN GRUPO 4
Equipo PJ GF GC Puntos
1 La Amistad C Amistad 4 29 4 12
2 Ave Maria B Ave Maria B 4 19 10 8
3 Paredes N. Paredes N. 3 12 8 7
4 San Telmo B San Telmo B 4 18 18 6
5 Ave Maria C Ave Maria C 4 15 22 6
6 B. Dueñas B. Dueñas 4 20 18 6
7 A. Aguilar B Aguilar 3 7 11 6
8 La Salle La Salle 4 16 13 4
9 Pisuerga B. C Pisuerga 3 6 10 3
10 Velilla Velilla 0 0 0 0
11 S. Juanillo C Juanillo 3 5 13 0
12 Saldaña B Saldaña B 4 5 25 0

  USO DE MEMORIA  
5,425,352 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0017
Controller Execution Time ( Home / Category )  0.4557
Total Execution Time  0.4575
  CADENA URL  
/historico/Cd-La-Salle-Alevin
  GET DATOS  
$_GET['/historico/Cd-La-Salle-Alevin']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (26)  
0.0259  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 = 68961
0.0126  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=54546 AND type_rel = 2
0.0125  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=467 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 = '54546' ORDER BY l.year DESC,cat.coefficient DESC
0.0128  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 = '54546' 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 = 68961 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
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=54546 AND l.year in (2022,2023,2024) 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 (68961,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.0125  SELECT count(id) as num_players from rel_players_base WHERE league_id = 68961 AND teamId = 54546
0.0126  SELECT count(id) as num_players from rel_players_base WHERE league_id = 65142 AND teamId = 54546
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 `tables2023` 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 = 68961 AND t.round = 30 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0132  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 = '54546' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0129  SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '54546' and rp.type = 4
0.0138  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 = '54546' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0141  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 = 54546 AND l.year <= 2023 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.0144  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 = 68961 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.0139  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.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 `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 = 60546 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.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 `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 = 60622 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 = 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.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 `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 = 45082 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0140  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 = 46707 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0141  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 = 42115 AND t.round = 22 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0155  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 = 36649 AND t.round = 22 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0140  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 = 17944 AND t.round = 22 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0135  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_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 = 7832 AND t.round = 22 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC