4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del EF Zona 5
TEMPORADA 2015/2016
PREFERENTE C. LA MANCHA GRUPO 1
Equipo PJ GF GC Puntos
1 Anro-Atco Tomelloso Anro-Atco 34 97 26 84
2 UD Carrión UD Carrión 34 71 25 72
3 CF La Solana Solana 34 71 33 65
4 UD Tobarra UD Tobarra 34 56 28 64
5 Atletico Puertollano Atletico 34 51 46 53
6 Valdepeñas Valdepeñas 34 49 46 50
7 Cd Miguelturreño Miguelturre 34 46 35 49
8 Daimiel Daimiel 34 56 56 49
9 C.D.B.F. Cervantes C.D.B.F. 34 39 45 48
10 Atco. Pedro Muñoz Atco. Pedro 34 55 55 47
11 C.D. Caudetano C.D. 34 41 59 45
12 Motilla CF Motilla CF 34 53 54 43
13 U.D. Alpera U.D. Alpera 34 58 87 40
14 Huracan de Balazote Huracan 34 52 54 39
15 Al-Basit Al-Basit 34 47 56 39
16 Hellin Deportivo Hellin 34 42 55 38
17 U.B. Conquense B U.B. 34 25 91 18
18 EF Zona 5 EF Zona 5 34 14 72 8
TEMPORADA 2014/2015
PREFERENTE C. LA MANCHA GRUPO 1
Equipo PJ GF GC Puntos
1 San Jose Obrero Jose Obrero 33 79 40 71
2 Munera Munera 33 73 27 70
3 CF La Solana Solana 33 78 38 70
4 Atlético Tomelloso Atlético 34 86 35 65
5 U.B. Conquense B U.B. 33 52 40 57
6 UD Tobarra UD Tobarra 33 49 34 54
7 Motilla CF Motilla CF 33 54 40 53
8 UD Carrión UD Carrión 33 46 34 51
9 CD Quintanar de la Orden Quintanar 33 50 48 45
10 Cd Miguelturreño Miguelturre 33 39 51 39
11 U.D. Alpera U.D. Alpera 33 50 61 37
12 C.D.B.F. Cervantes C.D.B.F. 33 38 54 35
13 C.F. Almodovar C.F. 33 41 62 35
14 C.D. Caudetano C.D. 33 36 66 35
15 EF Zona 5 EF Zona 5 33 31 64 35
16 CD Mota Del Cuervo Mota Cuervo 32 28 63 20
17 Cd Piedrabuena Piedrabuena 32 27 77 19
18 Tomelloso Tomelloso 18 21 44 12
TEMPORADA 2013/2014
TERCERA DIVISIÓN GRUPO 18
Equipo PJ GF GC Puntos
1 Puertollano Puertollano 38 88 18 98
2 UD Yugo Socuéllamos Yugo 38 72 26 83
3 CP Villarrobledo Villarrobled 38 80 32 76
4 UD Almansa UD Almansa 38 53 36 72
5 CF Talavera CF Talavera 38 72 34 72
6 Villarrubia CF Villarrubia 38 48 56 58
7 CD Pedroñeras Pedroñeras 38 42 50 54
8 La Gineta La Gineta 38 51 55 48
9 Atlético Ibañés Atlético 38 44 50 47
10 Quintanar del Rey Quintanar 38 44 56 47
11 Manzanares CF Manzanares 38 41 46 45
12 Atlético Albacete Atlético 38 45 58 43
13 CD Manchego Ciudad Real Manchego 38 43 54 43
14 Hellin Deportivo Hellin 38 35 40 43
15 Gimnástico de Alcázar Gimnástico 38 46 56 41
16 Mora CF Mora CF 38 37 63 40
17 CD Madridejos Madridejos 38 30 41 38
18 CD Illescas CD Illescas 38 39 59 36
19 CD Azuqueca CD Azuqueca 38 36 53 36
20 EF Zona 5 EF Zona 5 38 34 97 15
TEMPORADA 2012/2013
PREFERENTE C. LA MANCHA GRUPO 1
Equipo PJ GF GC Puntos
1 La Gineta La Gineta 34 89 29 86
2 EF Zona 5 EF Zona 5 34 67 28 76
3 Atlético Ibañés Atlético 34 72 31 74
4 EMD Solana EMD Solana 34 54 33 66
5 Daimiel Daimiel 34 51 25 64
6 Almagro CF Almagro CF 34 54 43 56
7 Munera Munera 34 49 43 55
8 Tomelloso Tomelloso 34 64 48 53
9 Cd Piedrabuena Piedrabuena 34 55 52 49
10 Isso CF Isso CF 34 45 54 42
11 Madrigueras UD Madrigueras 34 42 53 41
12 Cd Miguelturreño Miguelturre 34 46 56 40
13 CDB Herencia Herencia 34 37 63 40
14 UD Carrión UD Carrión 34 44 54 32
15 Atlético Teresiano Atlético 34 42 54 32
16 Valdepeñas Valdepeñas 34 48 52 29
17 Piedrabuena Dintel Piedrabuena 34 31 100 21
18 Puertollano B Puertollano 34 24 96 10
TEMPORADA 2011/2012
PREFERENTE C. LA MANCHA GRUPO 1
Equipo PJ GF GC Puntos
1 CD Manchego Ciudad Real Manchego 34 77 33 71
2 Daimiel Daimiel 34 65 33 64
3 Almagro CF Almagro CF 34 57 31 64
4 CF La Solana Solana 34 62 47 57
5 CD Pedroñeras Pedroñeras 34 46 33 55
6 Piedrabuena Piedrabuena 34 58 45 54
7 CD Mota Del Cuervo Mota Cuervo 34 56 47 51
8 Atlético Teresiano Atlético 34 51 51 50
9 Motilla Cf Motilla Cf 34 52 60 49
10 EF Zona 5 EF Zona 5 34 67 47 48
11 Cdb Herencia Herencia 34 57 61 47
12 Munera Munera 34 44 53 46
13 Ud Carrión Ud Carrión 34 42 51 44
14 Miguelturreño Miguelturre 34 42 51 42
15 Villamalea Villamalea 34 45 63 37
16 Unión Criptanense Unión 34 52 66 35
17 Efud Albacer Efud Albacer 34 27 65 24
18 Deportivo Barrax Deportivo 34 35 98 23

  USO DE MEMORIA  
5,351,040 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0017
Controller Execution Time ( Home / Category )  0.5376
Total Execution Time  0.5393
  CADENA URL  
/historico/Cdeef-Zona-5
  GET DATOS  
$_GET['/historico/Cdeef-Zona-5']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (33)  
0.0145  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 = 'Cdeef-Zona-5' 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.0180  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 = 'Cdeef-Zona-5' 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.0131  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=6165 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0129  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=6165 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0130  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=6165 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0130  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=6165 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0130  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=6165 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0128  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=6165 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0136  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 = 16708
0.0125  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=6165 AND type_rel = 2
0.0125  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=86 AND type_rel = 3
0.0127  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 3 AND rel.typeId = 86 AND rel.ln = 'es' AND rel.status=1 ORDER BY rel.creation_date desc,rel.cover_points DESC LIMIT 5
0.0131  SELECT /*53 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 (1304399,1199941,1184917,1070918,701719) ORDER BY n.cover_points DESC, update_date DESC
0.0136  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 = '6165' ORDER BY l.year DESC,cat.coefficient DESC
0.0140  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 = '6165' AND l.year = 2016 ORDER BY l.year DESC,cat.coefficient DESC
0.0137  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 = '6165' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0137  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 = '6165' AND ct.ctype=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0133  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 = 16708 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0136  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=6165 AND l.year in (2015,2016,2017) ORDER BY l.id DESC, l.year DESC ;
0.0128  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 (16708) 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.0129  SELECT count(id) as num_players from rel_players WHERE league_id = 16708 AND teamId = 6165
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 `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 = 16708 AND t.round = 34 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0128  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 = '6165' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0125  SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '6165' and rp.type = 4
0.0126  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 = '6165' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0128  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 events2016 e ON e.player_id = p.id AND e.league_id = 16708 WHERE rp.league_id = 16708 AND rp.teamId = 6165 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.0127  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 events2016 e ON e.player_id = p.id AND e.league_id = 16708 WHERE rp.league_id = 16708 AND rp.teamId = 6165 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0129  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 events2016 e ON e.player_id = p.id AND e.league_id = 16708 WHERE rp.league_id = 16708 AND rp.teamId = 6165 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0129  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 = 6165 AND l.year <= 2016 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.0137  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 = 16708 AND t.round = 34 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` 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 = 4077 AND t.round = 34 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 `tables2013` 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 = 2255 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0133  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 `tables2012` 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 = 1479 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC