4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del CD Priego
TEMPORADA 2023/2024
PRIMERA ANDALUZA GRUPO 8
Equipo PJ GF GC Puntos
1 Villa Del Rio CF Villa 20 61 28 43
2 Palma del Rio Atletico CF Palma 20 42 17 42
3 Egabrense Egabrense 20 40 20 38
4 Peñarroya Pueblonuevo Peñarroya 19 33 19 34
5 Bujalance Futbol Base AD Bujalance 20 28 26 31
6 Ciudad Jardin CD Ciudad 19 31 21 29
7 Villafranca CF Villafranca 19 32 32 28
8 Belmezano Belmezano 19 38 26 27
9 Salerm Puente Genil B Salerm 19 31 29 26
10 CD Montalbeño Montalbeño 19 29 29 26
11 CD Priego CD Priego 19 17 23 21
12 Atco. Villanueva Atco. 19 28 36 20
13 Lucecor Lucecor 20 28 41 19
14 Córdoba CF SAD Córdoba 19 20 36 15
15 Villa De Espejo CD Villa Espejo 19 22 43 11
16 Parque Cruz Conde CF Parque Cruz 10 6 60 1
TEMPORADA 2022/2023
2ª ANDALUZA CÓRDOBA
Equipo PJ GF GC Puntos
1 CD Priego CD Priego 24 53 24 54
2 Villa De Espejo CD Villa Espejo 24 70 40 51
3 Alcolea Los Ángeles Alcolea 24 67 40 46
4 Villafranca CF Villafranca 24 58 38 43
5 Club Deportivo La Descarga Club 24 40 37 38
6 CD Alcazar CD Alcazar 24 44 37 35
7 Montemayor Atlético Montemayor 24 66 68 29
8 Palomera-Naranjo CD Palomera-Nar 24 48 62 29
9 Cordobés Atlético Cordobés 24 34 53 25
10 La Rambla CF Rambla 24 44 47 23
11 CD Colonia Fuente Palmera Colonia 24 37 56 23
12 Santaella 2010 Santaella 24 44 73 18
13 Figueroa Figueroa 24 31 61 18
14 Villaviciosa CF Villaviciosa 0 0 0 0
TEMPORADA 2021/2022
2ª ANDALUZA CÓRDOBA GRUPO 1
Equipo PJ GF GC Puntos
1 Córdoba CF SAD Córdoba 24 63 16 59
2 Salerm Puente Genil B Salerm 23 62 18 52
3 La Rambla CF Rambla 24 64 28 45
4 CD Priego CD Priego 24 66 32 45
5 Villa De Espejo CD Villa Espejo 24 51 26 45
6 Santaella 2010 Santaella 24 54 40 39
7 Montemayor Atlético Montemayor 24 57 59 36
8 Sporting de Benameji Sporting 24 41 40 35
9 Atlético Baenense Atlético 24 55 69 28
10 At. Menciano Menciano 24 41 77 17
11 Monturk de Monturque Monturk 24 26 75 16
12 Almedinilla Atl Almedinilla 23 39 76 15
13 Moriles CF Moriles CF 24 27 90 6
TEMPORADA 2020/2021
PRIMERA ANDALUZA GRUPO 22
Equipo PJ GF GC Puntos
1 Peñarroya Pueblonuevo Peñarroya 24 32 24 37
2 Almodóvar del Río Almodóvar 24 54 39 36
3 CD Montalbeño Montalbeño 24 42 35 34
4 Belmezano Belmezano 24 43 54 33
5 Atco. Villanueva Atco. 24 40 35 32
6 Villa Del Rio CF Villa 24 31 50 31
7 CD Priego CD Priego 24 28 38 25
8 La Rambla CF Rambla 24 36 54 18
9 Salerm Puente Genil B Salerm 24 38 57 18
TEMPORADA 2019/2020
PRIMERA ANDALUZA GRUPO 3
Equipo PJ GF GC Puntos
1 Montilla Montilla 24 58 19 58
2 CD Priego CD Priego 24 46 24 46
3 Almodóvar del Río Almodóvar 24 45 27 46
4 Palma del Rio Atletico CF Palma 24 53 29 43
5 Egabrense Egabrense 24 46 30 39
6 Atco. Villanueva Atco. 24 41 28 38
7 CD Alcazar CD Alcazar 24 35 33 36
8 Lucecor Lucecor 24 44 38 35
9 Villa Del Rio CF Villa 24 27 33 30
10 La Rambla CF Rambla 24 31 32 29
11 Bujalance Futbol Base AD Bujalance 24 33 48 24
12 Los Leones de Pozoblanco Leones 24 32 50 24
13 CD Castro Del Rio-Cajasol Castro 24 29 43 23
14 FC Aguilarense Aguilarense 24 33 71 23
15 Peñarroya Pueblonuevo Peñarroya 24 26 42 22
16 Salerm Puente Genil B Salerm 24 20 52 13
TEMPORADA 2018/2019
PRIMERA ANDALUZA GRUPO 3
Equipo PJ GF GC Puntos
1 Ciudad Jardin CD Ciudad 30 67 30 68
2 Montilla Montilla 30 66 22 67
3 Bujalance Futbol Base AD Bujalance 29 50 35 52
4 La Rambla CF Rambla 30 52 37 51
5 Villa Del Rio CF Villa 30 57 49 47
6 Palma del Rio Atletico CF Palma 30 60 51 46
7 CD Alcazar CD Alcazar 29 47 38 43
8 Salerm Puente Genil B Salerm 29 48 53 42
9 Almodóvar del Río Almodóvar 29 48 46 41
10 CD Priego CD Priego 30 46 46 40
11 Egabrense Egabrense 29 44 44 39
12 Atco. Villanueva Atco. 30 52 58 36
13 FC Aguilarense Aguilarense 29 39 45 34
14 Almedinilla Atl Almedinilla 30 39 56 32
15 UD Belalcazar Belalcazar 29 37 95 17
16 C.D. Stadium C.D. Stadium 25 20 67 12
TEMPORADA 2017/2018
PRIMERA ANDALUZA GRUPO 3
Equipo PJ GF GC Puntos
1 Peñarroya Pueblonuevo Peñarroya 30 61 22 66
2 Almodóvar del Río Almodóvar 30 66 39 55
3 Villa Del Rio CF Villa 30 52 38 51
4 Atco. Villanueva Atco. 30 61 49 49
5 Palma del Rio Atletico CF Palma 30 67 43 49
6 La Rambla CF Rambla 30 49 53 45
7 C.D. Stadium C.D. Stadium 30 46 37 44
8 Egabrense Egabrense 30 58 56 44
9 Bujalance Futbol Base AD Bujalance 30 57 49 44
10 Almedinilla Atl Almedinilla 30 49 35 44
11 CD Alcazar CD Alcazar 30 58 50 43
12 At. Menciano Menciano 30 64 47 42
13 CD Priego CD Priego 30 46 51 40
14 CD Montalbeño Montalbeño 30 40 48 39
15 Pedroche CD Pedroche CD 30 37 82 15
16 CD El Villar Villar 30 17 129 5
TEMPORADA 2016/2017
2ª ANDALUZA CÓRDOBA
Equipo PJ GF GC Puntos
1 Palma del Rio Atletico CF Palma 28 76 29 65
2 At. Menciano Menciano 28 90 41 60
3 Pedroche CD Pedroche CD 28 91 49 58
4 CD Priego CD Priego 28 72 40 56
5 Villafranca CF Villafranca 28 88 49 53
6 Santaella 2010 Santaella 28 64 53 44
7 Cerro Muriano Cf Cerro 28 62 66 38
8 CD Castro Del Rio-Cajasol Castro 28 53 55 36
9 Atlético Baenense Atlético 28 45 53 32
10 FC Aguilarense Aguilarense 28 43 60 32
11 La Victoria C.F. Victoria 28 46 91 28
12 CD Colonia Fuente Palmera Colonia 28 49 72 26
13 C.D. El Villar B C.D. Villar 28 36 71 25
14 Los califas Balompié califas 28 45 80 24
15 Prieguense A.F. Prieguense 28 37 88 22
TEMPORADA 2015/2016
3ª ANDALUZA CÓRDOBA GRUPO 1
Equipo PJ GF GC Puntos
1 La Rambla CF Rambla 27 73 28 62
2 At. Menciano Menciano 28 68 35 57
3 CD El Villar Villar 28 50 32 56
4 C.D. Stadium C.D. Stadium 28 58 27 51
5 Santaella 2010 Santaella 28 70 45 48
6 Villafranca CF Villafranca 27 84 44 46
7 CD Priego CD Priego 27 61 40 46
8 CD Colonia Fuente Palmera Colonia 27 68 39 44
9 Palma del Rio Atletico CF Palma 28 69 40 42
10 CD Castro Del Rio-Cajasol Castro 27 54 51 40
11 La Victoria C.F. Victoria 27 32 66 30
12 FC Aguilarense Aguilarense 28 46 68 22
13 C.D. Atlético Cerro Muriano C.D. 21 29 62 13
14 Atlético Baenense Atlético 27 25 99 10
15 Prieguense A.F. Prieguense 28 32 143 7
16 Posadas Atlético C.D. Posadas 0 0 0 0

  USO DE MEMORIA  
5,726,192 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0033
Controller Execution Time ( Home / Category )  0.1081
Total Execution Time  0.1115
  CADENA URL  
/historico/Priego-Cf-Senior
  GET DATOS  
$_GET['/historico/Priego-Cf-Senior']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (32)  
0.0030  SELECT dt.*,c.active_year,l.year,l.table_suffix, c.ctype, l.id as league_id,t.id as id,t.manager,t.name as nameOriginal,dt.id as teamId,cou.Name as cou_name,cou.Continent,cou.Region FROM `leagues_webci` as l INNER JOIN `teams` as t ON l.id = t.league_id INNER JOIN `datateams` as dt ON dt.id = t.teamId INNER JOIN `categories_webci` as c ON c.id = l.categoryId LEFT JOIN country cou ON LOWER(cou.Code2) = dt.CountryCode WHERE dt.basealias = 'Priego-Cf-Senior' AND l.year = 2024 ORDER BY c.top DESC, c.ctype != 12 DESC, c.troncal DESC, l.end_date >= NOW() DESC, l.start_date <= NOW() DESC, l.year DESC, c.coefficient DESC, l.id ASC
0.0020  SELECT dp.nick, dp.fullname,rp.date_ini, rp.date_end FROM futbol.rel_people rp INNER JOIN futbol.datapeople dp on dp.id=rp.people_id WHERE rp.teamId=66311 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0018  SELECT dp.nick, dp.fullname,rp.date_ini, rp.date_end FROM futbol.rel_people rp INNER JOIN futbol.datapeople dp on dp.id=rp.people_id WHERE rp.teamId=66311 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0056  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 = 73631
0.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=66311 AND type_rel = 2
0.0020  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 2 AND rel.typeId = 66311 AND rel.ln = 'es' ORDER BY rel.cover_points DESC LIMIT 5
0.0019  SELECT /*35 bs_news_model*/ n.id, n.author_id, n.headline, n.external_headline, n.live_headline, n.creation_date, n.update_date, n.pub_date, n.alias, n.subheadline, n.teaser, n.media, n.tags, n.views, n.screens, n.clicks, n.relations, n.comments, n.power_cover, n.cover_points, u.name as user_name FROM bs_news n INNER JOIN bs_editors u ON u.id = n.author_id AND u.ln = 'es' WHERE n.status = 1 AND n.ln = 'es' AND n.id IN (158073) ORDER BY n.cover_points DESC, update_date DESC
0.0022  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 = '66311' ORDER BY l.year DESC,cat.coefficient DESC
0.0021  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 = '66311' AND l.year = 2024 ORDER BY l.year DESC,cat.coefficient DESC
0.0021  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 = '66311' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0020  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 = 73631 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0023  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=66311 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0019  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 (73631,69261) 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.0025  SELECT count(id) as num_players from rel_players WHERE league_id = 73631 AND teamId = 66311
0.0018  SELECT count(id) as num_players from rel_players WHERE league_id = 69261 AND teamId = 66311
0.0020  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 = '66311' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0018  SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '66311' and rp.type = 4
0.0021  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 = '66311' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0028  SELECT e.action,rp.player_id, count(e.action) as total, p.nick,p.name,p.last_name,p.alias,rp.team_id FROM `rel_players` rp INNER JOIN dataplayers p ON p.id = rp.player_id INNER JOIN events2024 e ON e.player_id = p.id AND e.league_id = 73631 WHERE rp.league_id = 73631 AND rp.teamId = 66311 AND (e.action = 1 or e.action = 2 or e.action = 11 or e.action = 12 or e.action = 13) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0026  SELECT e.action,rp.player_id, count(e.action) as total, p.nick,p.name,p.last_name,p.alias,rp.team_id FROM `rel_players` rp INNER JOIN dataplayers p ON p.id = rp.player_id INNER JOIN events2024 e ON e.player_id = p.id AND e.league_id = 73631 WHERE rp.league_id = 73631 AND rp.teamId = 66311 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0026  SELECT e.action,rp.player_id, count(e.action) as total, p.nick,p.name,p.last_name,p.alias,rp.team_id FROM `rel_players` rp INNER JOIN dataplayers p ON p.id = rp.player_id INNER JOIN events2024 e ON e.player_id = p.id AND e.league_id = 73631 WHERE rp.league_id = 73631 AND rp.teamId = 66311 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0022  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 = 66311 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.0023  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 `tables2024` 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 = 73631 AND t.round = 29 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0021  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` 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 = 69261 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.0023  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` 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 = 64159 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.0023  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` 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 = 58856 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.0021  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` 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 = 61894 AND t.round = 10 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0022  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` 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 = 51256 AND t.round = 24 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0022  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` 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 = 44622 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0026  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` 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 = 39326 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0022  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` 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 = 34581 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0024  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` 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 = 16867 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC