4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del Villa De Espejo CD
TEMPORADA 2023/2024
PRIMERA ANDALUZA GRUPO 8
Equipo PJ GF GC Puntos
1 Palma del Rio Atletico CF Palma 24 48 22 49
2 Villa Del Rio CF Villa 23 63 29 48
3 Peñarroya Pueblonuevo Peñarroya 23 47 19 46
4 Egabrense Egabrense 23 42 25 41
5 Ciudad Jardin CD Ciudad 23 38 24 37
6 Belmezano Belmezano 23 47 34 36
7 Bujalance Futbol Base AD Bujalance 23 30 31 34
8 CD Montalbeño Montalbeño 23 39 36 33
9 Villafranca CF Villafranca 23 35 42 31
10 Salerm Puente Genil B Salerm 23 37 37 30
11 Atco. Villanueva Atco. 23 33 43 26
12 CD Priego CD Priego 23 21 30 24
13 Lucecor Lucecor 23 34 46 22
14 Córdoba CF SAD Córdoba 23 26 41 21
15 Villa De Espejo CD Villa Espejo 23 23 50 12
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 2019/2020
2ª ANDALUZA CÓRDOBA GRUPO 1
Equipo PJ GF GC Puntos
1 CD Montalbeño Montalbeño 21 56 13 52
2 CD El Carpio CF Carpio 21 37 20 44
3 Villa De Espejo CD Villa Espejo 21 48 23 42
4 CD Posadas CF Posadas 21 59 34 40
5 CD Colonia Fuente Palmera Colonia 21 45 22 39
6 Montemayor Atlético Montemayor 22 31 34 34
7 Villafranca CF Villafranca 21 35 37 28
8 C.D. Egabrense B C.D. 21 24 35 26
9 CD Priego B CD Priego B 22 26 51 21
10 Almedinilla Atl Almedinilla 21 20 53 16
11 Los Califas Balompie Califas 21 19 54 11
12 La Victoria C.F. Victoria 13 13 37 4
TEMPORADA 2017/2018
2ª ANDALUZA CÓRDOBA GRUPO 1
Equipo PJ GF GC Puntos
1 Salerm Puente Genil B Salerm 16 41 14 36
2 FC Aguilarense Aguilarense 16 37 21 36
3 CD Colonia Fuente Palmera Colonia 16 46 19 31
4 CD Castro Del Rio-Cajasol Castro 16 39 22 26
5 Los Califas Balompie Califas 16 35 27 23
6 La Victoria C.F. Victoria 16 37 36 20
7 Baenense Atletico Baenense 16 31 33 20
8 Villa De Espejo CD Villa Espejo 16 26 40 13
9 Prieguense A.F. Prieguense 16 7 87 1
TEMPORADA 2009/2010
2ª ANDALUZA CÓRDOBA
Equipo PJ GF GC Puntos
1 Atlético Espeleño Atlético 32 68 30 70
2 C.D. El Higuerón - Especolc C.D. 32 73 37 67
3 Rud La Carlota Carlota 32 73 40 63
4 Salerm Pte.Genil Salerm 32 51 24 61
5 C.D. Alcázar B C.D. 32 53 35 60
6 Las Palmeras Ud Palmeras 32 69 48 55
7 Ciudad de Lucena Ciudad 32 67 47 46
8 Palma del Rio Atletico CF Palma 32 46 46 44
9 La Ribera Guadalq. Ribera 32 63 61 43
10 Hinojosa Hinojosa 32 50 54 43
11 Almodóvar del Río Almodóvar 32 54 60 43
12 CD Apedem B CD Apedem B 32 48 48 41
13 Don Bosco CF C Bosco 32 52 63 38
14 Belmezano Belmezano 32 40 53 37
15 Parque Cruz Conde Parque Cruz 32 45 70 27
16 Villa De Espejo CD Villa Espejo 32 32 90 20
17 La Rambla Fem Rambla 32 27 105 6
TEMPORADA 2008/2009
2ª ANDALUZA CÓRDOBA
Equipo PJ GF GC Puntos
1 La Voz La Voz 36 72 43 77
2 Prasa Torrecampo Prasa 36 61 26 73
3 Ciudad Jardín Ciudad 36 75 34 70
4 Rud La Carlota Carlota 36 64 41 68
5 Atlético Espeleño Atlético 36 74 57 57
6 CD Apedem CD Apedem 36 49 49 56
7 Almodóvar del Río Almodóvar 36 58 52 55
8 Salerm Pte.Genil Salerm 36 56 46 53
9 Hinojosa Hinojosa 36 55 58 50
10 Las Palmeras Ud Palmeras 36 51 57 49
11 C.D. El Higuerón - Especolc C.D. 36 48 50 47
12 Palma del Rio Atletico CF Palma 36 43 51 47
13 Dielesur La Rambla Dielesur 36 47 57 46
14 Villa De Espejo CD Villa Espejo 36 43 42 43
15 CD Montalbeño Montalbeño 36 46 58 42
16 Priego Ind. Priego Ind. 36 51 68 39
17 UD Villanueva Rosario Villanueva 36 42 58 34
18 Egabrense Egabrense 36 53 87 31
19 Pozoalbense Pozoalbense 36 36 90 23
TEMPORADA 2007/2008
2ª ANDALUZA CÓRDOBA
Equipo PJ GF GC Puntos
1 Fc Aguilarense Aguilarense 34 82 27 75
2 Las Palmeras Ud Palmeras 34 91 57 69
3 Belmezano Belmezano 34 65 36 69
4 Dielesur La Rambla Dielesur 34 67 43 66
5 Pozoalbense Pozoalbense 34 75 51 58
6 Atlético Espeleño Atlético 33 75 47 56
7 Hinojosa Hinojosa 34 54 48 53
8 CD Apedem CD Apedem 34 63 55 50
9 Prasa Torrecampo Prasa 34 51 52 46
10 Rud La Carlota Carlota 34 52 55 45
11 Villa De Espejo CD Villa Espejo 34 65 62 44
12 UD Villanueva Rosario Villanueva 34 51 49 43
13 Palma del Rio Atletico CF Palma 34 38 54 43
14 Ciudad Jardín Ciudad 34 66 65 42
15 C.D. Alcázar B C.D. 34 52 52 39
16 Sur Sur 33 32 73 29
17 Benamejí Benamejí 33 24 91 14
18 Belalcázar Belalcázar 33 28 114 14
TEMPORADA 2005/2006
2ª ANDALUZA CÓRDOBA
Equipo PJ GF GC Puntos
1 Fc Aguilarense Aguilarense 32 62 22 75
2 Peñarroya Pueblonuevo Peñarroya 32 82 22 69
3 Dielesur La Rambla Dielesur 32 70 32 61
4 Miralbaida Miralbaida 32 61 52 48
5 Hinojosa Hinojosa 32 55 52 47
6 Posadas Bpie. Posadas 32 56 54 47
7 Belmezano Belmezano 32 52 55 47
8 Atlético Espeleño Atlético 32 48 43 46
9 CD Apedem CD Apedem 32 43 40 45
10 Egabrense Egabrense 32 60 39 44
11 Guadalquivir Guadalquivir 32 51 61 39
12 Priego Ind. Priego Ind. 32 39 62 39
13 Victoria Cf Victoria Cf 32 38 74 33
14 Puente Genil Puente Genil 32 54 72 32
15 CD Castro Del Rio-Cajasol Castro 32 47 59 30
16 Villa De Espejo CD Villa Espejo 32 37 65 30
17 Almedinilla Atl Almedinilla 32 36 87 26

  USO DE MEMORIA  
5,842,024 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0012
Controller Execution Time ( Home / Category )  0.0963
Total Execution Time  0.0976
  CADENA URL  
/historico/Villa-Espejo
  GET DATOS  
$_GET['/historico/Villa-Espejo']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (30)  
0.0025  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 = 'Villa-Espejo' 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.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=13967 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0017  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=13967 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0039  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.0017  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=13967 AND type_rel = 2
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 = '13967' ORDER BY l.year DESC,cat.coefficient DESC
0.0020  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 = '13967' AND l.year = 2024 ORDER BY l.year DESC,cat.coefficient DESC
0.0019  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 = '13967' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0022  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.0020  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=13967 AND l.year in (2023,2024,2025) 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 (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.0018  SELECT count(id) as num_players from rel_players WHERE league_id = 73631 AND teamId = 13967
0.0018  SELECT count(id) as num_players from rel_players WHERE league_id = 69261 AND teamId = 13967
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 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 = 30 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
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 = '13967' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0017  SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '13967' and rp.type = 4
0.0020  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 = '13967' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0027  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 = 13967 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.0024  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 = 13967 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0022  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 = 13967 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0021  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 = 13967 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
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 `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 = 30 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 `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 `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 = 51361 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.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 `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 = 39901 AND t.round = 18 ORDER BY team.conference 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 `tables2010` 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 = 2932 AND t.round = 34 ORDER BY team.conference 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 `tables2009` 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 = 2931 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0025  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 `tables2008` 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 = 2930 AND t.round = 34 ORDER BY team.conference 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 `tables2006` 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 = 2928 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC