4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del Salerm Cosmetics Puente Gen
TEMPORADA 2022/2023
3ª ANDALUZA CORDOBA CADETE
Equipo PJ GF GC Puntos
1 Calvario Priego CF Calvario 26 103 21 76
2 Séneca CF Sub 16 Séneca 26 78 28 65
3 La Rambla de Futbol Base Rambla 26 66 46 50
4 Palomera Naranjo Cultural Palomera 26 65 45 44
5 Don Bosco CF Sub 16 Bosco 26 65 47 44
6 Futbol Base Egabrense Futbol Base 26 57 52 43
7 Bujalance Futbol Base AD Bujalance 26 51 58 35
8 Figueroa CD Figueroa CD 26 54 57 31
9 CD AD Miralbaida Miralbaida 26 41 74 30
10 CD Posadas CF Posadas 26 53 59 28
11 Salerm Cosmetics Puente Gen Salerm 26 47 62 27
12 Montalbeño Montalbeño 26 41 65 26
13 Ciudad Jardin CD Ciudad 26 34 83 14
14 Atlético Villanueva FB Atlético 26 27 85 6
15 Alcázar Alcázar 0 0 0 0
16 Fundacion Lucena Fundacion 0 0 0 0
TEMPORADA 2021/2022
2ª ANDALUZA CÓRDOBA CADETE
Equipo PJ GF GC Puntos
1 Juanin Y Diego Sub 16 Juanin Diego 28 86 23 67
2 Fundacion Lucena Fundacion 28 100 42 59
3 Figueroa CD Figueroa CD 28 71 36 56
4 CD Los Califas Balompie Califas 28 75 58 55
5 Atlético Seneca Atlético 28 88 37 53
6 CD Apedem A CD Apedem A 28 69 40 53
7 Don Bosco CF Sub 16 Bosco 28 45 40 47
8 A.D. Apademar A A.D. 28 61 69 39
9 Salerm Cosmetics Puente Gen Salerm 28 63 56 37
10 Pozoblanco Pozoblanco 28 59 75 32
11 C.D. Stadium C.D. Stadium 28 50 95 23
12 Salvador Allende Salvador 28 43 62 22
13 Futbol Base Egabrense Futbol Base 28 58 101 21
14 Palomera Naranjo Cultural Palomera 28 39 81 20
15 CD AD Miralbaida Miralbaida 28 27 119 11
16 Alcazar CD Alcazar CD 0 0 0 0
TEMPORADA 2020/2021
2ª ANDALUZA CÓRDOBA CADETE GRUPO 2
Equipo PJ GF GC Puntos
1 Don Bosco CF Sub 16 Bosco 9 23 7 20
2 A.D. Apademar A A.D. 10 23 14 19
3 Atlético Seneca Atlético 8 16 9 19
4 Futbol Base Egabrense Futbol Base 9 15 22 11
5 Atletico Menciano Atletico 5 10 10 7
6 Salerm Cosmetics Puente Gen Salerm 9 11 14 7
7 Alcazar CD Alcazar CD 9 7 15 6
8 C.D. Stadium C.D. Stadium 9 11 25 6
TEMPORADA 2019/2020
2ª ANDALUZA CÓRDOBA CADETE
Equipo PJ GF GC Puntos
1 CD Apedem A CD Apedem A 22 86 18 55
2 Don Bosco CF Sub 16 Bosco 23 66 19 54
3 Pozoblanco Pozoblanco 22 74 24 50
4 Atlético Seneca Atlético 22 85 27 49
5 Juanin Y Diego Sub 16 Juanin Diego 23 63 31 47
6 A.D. Apademar A A.D. 22 61 24 40
7 Futbol Base Egabrense Futbol Base 23 54 43 37
8 Salerm Cosmetics Puente Gen Salerm 23 52 40 33
9 Rud La Carlota A Carlota 22 45 51 31
10 C.D. Stadium C.D. Stadium 22 53 52 29
11 Villa del Rio Servicio Depo Villa 23 44 54 25
12 Figueroa CD Figueroa CD 20 33 44 19
13 Deportivo Córdoba CF Deportivo 21 52 66 19
14 Alcazar CD Alcazar CD 23 24 95 10
15 Baenense Atletico Baenense 23 16 169 3
16 La Rambla de Futbol Base Rambla 16 13 64 1
TEMPORADA 2018/2019
1ª ANDALUZA CADETE GRUPO 1
Equipo PJ GF GC Puntos
1 Sevilla FC Sub 16 B Sevilla 30 108 21 85
2 Real Betis Sub 16 B Real Betis 30 74 16 64
3 Peloteros Sierra Sur Sub 16 Peloteros 30 54 30 59
4 San Fernando Isleño A Fernando 30 66 37 58
5 Recreativo de Huelva Sub 16 Recreativo 30 56 40 56
6 CD Antonio Puerta Sub 16 Antonio 30 65 41 46
7 Wea Sierra de Cadiz Sierra Cadiz 30 38 33 43
8 UD Tomares UD Tomares 30 56 42 41
9 Córdoba CF B Córdoba 30 47 46 37
10 CD Siempre Alegres Siempre 30 40 55 37
11 CD Utrera Sub 16 Utrera 30 33 53 35
12 Algeciras CF Sub 16 Algeciras 30 38 49 34
13 Pozoblanco Pozoblanco 30 41 50 33
14 Salerm Cosmetics Puente Gen Salerm 30 32 58 30
15 Cartaya A Cartaya A 30 16 107 9
16 CD Alcala Sub 16 Alcala 30 15 101 6
TEMPORADA 2017/2018
1ª ANDALUZA CADETE GRUPO 1
Equipo PJ GF GC Puntos
1 Sevilla FC Sub 16 B Sevilla 30 92 27 75
2 Real Betis Sub 16 B Real Betis 30 79 21 69
3 Séneca CF Sub 16 Séneca 30 78 30 66
4 Atlético Sanluqueño Sub 16 Atlético 30 59 29 60
5 San Fernando Isleño A Fernando 30 63 28 56
6 Recreativo de Huelva Sub 16 Recreativo 30 59 40 55
7 Wea Sierra de Cadiz Sierra Cadiz 30 51 36 49
8 UD Tomares UD Tomares 30 58 37 47
9 Salerm Cosmetics Puente Gen Salerm 30 43 49 38
10 Córdoba CF B Córdoba 30 39 50 33
11 CD Utrera Sub 16 Utrera 30 42 69 32
12 Cartaya A Cartaya A 30 46 69 30
13 CD Deportivo Cordoba CF Deportivo 30 25 69 25
14 Don Bosco CF Sub 16 Bosco 30 34 66 21
15 Atlético Seneca Atlético 30 32 64 20
16 Ad Taraguilla Taraguilla 30 16 132 4
TEMPORADA 2016/2017
2ª ANDALUZA CÓRDOBA CADETE
Equipo PJ GF GC Puntos
1 Salerm Cosmetics Puente Gen Salerm 30 147 25 80
2 Futbol Base Egabrense Futbol Base 30 85 35 67
3 Pozoblanco Pozoblanco 30 91 42 63
4 Salvador Allende Salvador 30 107 33 61
5 Don Bosco CF B Bosco 30 67 50 57
6 CD Apedem A CD Apedem A 30 67 53 46
7 Rud La Carlota A Carlota 30 77 69 46
8 Palma del Rio Atlético Palma 30 59 59 46
9 CD Los Califas Balompie Califas 30 66 56 44
10 Montalbeño Montalbeño 30 67 77 42
11 A.D. Apademar A A.D. 30 73 92 30
12 Palomera Naranjo Cultural Palomera 30 53 98 29
13 CD Colonia de Fuente Palmer Colonia 30 51 100 24
14 Sporting de Benameji Sporting 30 46 104 18
15 Villafranca Villafranca 30 45 129 17
16 Atletico Aguilarense Atletico 30 34 113 12
TEMPORADA 2015/2016
2ª ANDALUZA CÓRDOBA CADETE
Equipo PJ GF GC Puntos
1 Córdoba CF B Córdoba 30 126 28 77
2 CD Deportivo Cordoba CF Deportivo 30 86 23 75
3 CD Apedem A CD Apedem A 30 69 31 70
4 Futbol Base Egabrense Futbol Base 30 112 55 63
5 Pozoblanco Pozoblanco 30 80 43 62
6 Lucena Lucena 30 109 57 57
7 CD Los Califas Balompie Califas 30 77 46 55
8 Salerm Cosmetics Puente Gen Salerm 30 68 74 36
9 Palma del Rio Atlético Palma 30 51 65 36
10 Don Bosco CF B Bosco 30 42 71 33
11 Salvador Allende Salvador 30 45 88 31
12 Montalbeño Montalbeño 30 44 87 29
13 Sporting de Benameji Sporting 30 52 105 23
14 Palomera Naranjo Cultural Palomera 30 36 98 17
15 Atlético Villanueva FB Atlético 30 34 86 16
16 Parque Cruz Conde Parque Cruz 30 42 116 12
TEMPORADA 2014/2015
2ª ANDALUZA CÓRDOBA CADETE
Equipo PJ GF GC Puntos
1 Córdoba CF Sub 16 Córdoba 28 114 25 78
2 Atlético Seneca Atlético 28 89 30 68
3 Los Califas Balompie Califas 28 94 39 64
4 Salvador Allende Salvador 28 67 51 49
5 Egabrense FB Egabrense 28 61 47 44
6 Lucena Lucena 28 68 56 41
7 Montalbeño Montalbeño 28 40 48 38
8 Deportivo Córdoba CF Deportivo 28 54 43 37
9 Pozoblanco Pozoblanco 28 55 44 36
10 Palma del Rio Atlético Palma 28 46 55 36
11 Atlético Villanueva FB Atlético 28 50 76 32
12 Salerm Cosmetics Puente Gen Salerm 28 38 79 25
13 Palomera-Naranjo Palomera-Nar 28 46 99 17
14 A.D. Apademar A A.D. 28 45 98 14
15 Peñarroya Pueblonuevo Peñarroya 28 25 102 11
16 Figueroa CD Figueroa CD 0 0 0 0
TEMPORADA 2012/2013
1ª ANDALUZA CADETE GRUPO 1
Equipo PJ GF GC Puntos
1 Sevilla FC Sub 16 Sevilla 30 98 13 78
2 Real Betis Sub 16 Real Betis 30 115 25 74
3 CD Altair Sub 16 Altair 30 84 37 65
4 Xerez Cd Xerez Cd 30 72 43 54
5 Ad Taraguilla Taraguilla 30 57 40 52
6 Cádiz CF Sub 16 Cádiz 30 66 43 50
7 Séneca CF Sub 16 Séneca 30 49 60 45
8 Recreativo de Huelva Sub 16 Recreativo 30 60 56 43
9 Cdad. Córdoba Cdad. 30 62 54 42
10 CD Utrera Sub 16 Utrera 30 44 51 36
11 Atco. Sanluqueño Atco. 30 49 58 33
12 CD Apedem A CD Apedem A 30 37 66 33
13 Huelva Atlético Huelva 30 29 59 31
14 Chiclana Ind. Chiclana 30 45 68 30
15 Salerm Cosmetics Puente Gen Salerm 30 22 96 9
16 Cf Olímpica Valverdeña Olímpica 30 15 135 4

  USO DE MEMORIA  
5,882,424 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0013
Controller Execution Time ( Home / Category )  0.5361
Total Execution Time  0.5374
  CADENA URL  
/historico/Salerm-Cosmetics-San-Fermin-Cadete
  GET DATOS  
$_GET['/historico/Salerm-Cosmetics-San-Fermin-Cadete']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (27)  
0.0293  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 = 70162
0.0294  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 = 70185
0.0145  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=25264 AND type_rel = 2
0.0145  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=759 AND type_rel = 3
0.0146  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 = '25264' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0146  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 = 70162 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0146  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 = 70185 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0147  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=25264 AND l.year in (2022,2023,2024) ORDER BY l.id DESC, l.year DESC ;
0.0145  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 (70185,70162) 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.0144  SELECT count(id) as num_players from rel_players_base WHERE league_id = 70162 AND teamId = 25264
0.0144  SELECT count(id) as num_players from rel_players_base WHERE league_id = 70185 AND teamId = 25264
0.0146  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 = 70162 AND t.round = 30 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0146  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 = '25264' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0144  SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '25264' and rp.type = 4
0.0146  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 = '25264' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0147  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 = 25264 AND l.year <= 2023 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.0148  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 = 70162 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.0148  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 = 70185 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.0148  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 = 66040 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.0147  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 = 60386 AND t.round = 14 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0151  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 = 52410 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.0149  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 = 44970 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0149  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 = 40112 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0148  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 = 34341 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0156  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 = 17366 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0153  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 = 4866 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0150  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 `tables2013_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 = 2660 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC