4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
« Temporada Anterior
Temporada 2014
Temporada Siguiente »
Tercera División 2014 G 14
2013/2014

Extremadura

Tercera División 2014 G 14

  • Villanovense
  • AD Mérida
  • Jerez
  • Deportivo Pacense
  • CD Coria
  • Extremadura
  • CD Don Benito
  • Diter Zafra
  • Pueblonuevo
  • Plasencia
  • CD Azuaga
  • Atl San José Promesas
  • Olivenza
  • Hernán Cortés
  • Santa Amalia
  • Castuera
  • UD Fuente de Cantos
  • CP Cacereño B
  • Miajadas
  • RCP Valverdeño
  • Ciudad de Plasencia
  • Tercera División:

Clasificación

Equipo PJ GF GC Puntos
1 Villanovense Villanovense 40 77 17 100
2 AD Mérida AD Mérida 40 88 27 94
3 Jerez Jerez 40 77 21 94
4 Deportivo Pacense Deportivo 40 84 17 94
5 CD Coria CD Coria 40 81 35 87
6 Extremadura Extremadura 40 78 36 74
7 CD Don Benito Benito 40 52 35 59
8 Diter Zafra Diter Zafra 40 68 60 53
9 Pueblonuevo Pueblonuevo 40 66 54 53
10 Plasencia Plasencia 40 66 63 52
11 CD Azuaga CD Azuaga 40 68 78 52
12 Atl San José Promesas José 40 48 49 52
13 Olivenza Olivenza 40 38 49 46
14 Hernán Cortés Hernán 40 28 49 46
15 Santa Amalia Santa Amalia 40 43 69 45
16 Castuera Castuera 40 51 68 45
17 UD Fuente de Cantos Fuente 40 48 61 41
18 CP Cacereño B Cacereño 40 32 81 31
19 Miajadas Miajadas 40 42 110 24
20 RCP Valverdeño Valverdeño 40 48 103 20
21 Ciudad de Plasencia Ciudad 40 27 128 9

  USO DE MEMORIA  
5,564,936 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0020
Controller Execution Time ( Home / Category )  0.2970
Total Execution Time  0.2990
  CADENA URL  
/tercera2014/grupo14/resumen/42
  GET DATOS  
$_GET['/tercera2014/grupo14/resumen/42']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (14)  
0.0107  SELECT type FROM routes WHERE alias = 'tercera2014'
0.0216  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'tercera' AND (l.group_code = 14 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 2014 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=14 DESC LIMIT 1
0.0117  SELECT dt.nameShow,dt.basealias,t.id,t.teamId FROM teams t INNER JOIN datateams dt ON t.teamId = dt.id WHERE t.league_id = 2563 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0126  SELECT c.team1, c.team2,c.extra,c.datateam1,c.datateam2,c.type, c.shedule, c.r1, c.r2, c.round, c.comments as total_comentarios, dt1.nameShow as team1_name, dt2.nameShow as team2_name, dt1.basealias as basealias1, dt2.basealias as basealias2 FROM `calendars2014` as c INNER JOIN teams t1 ON t1.id = c.team1 AND t1.league_id = c.league_id INNER JOIN teams t2 ON t2.id = c.team2 AND t2.league_id = c.league_id INNER JOIN datateams as dt1 ON dt1.id = t1.teamId INNER JOIN datateams as dt2 ON dt2.id = t2.teamId WHERE c.`league_id` = 2563 AND c.`round` = 42 ORDER BY shedule ASC LIMIT 200
0.0183  SELECT (dt1.qod+dt2.qod+dt1.relations+dt2.relations) as total,c.r1,c.r2,e.action,ev.showName as eventName,ev.largeName,ev.main_action,ev.keyname,ev.classf,e.real_date,e.minute, dp.nick,dp.CountryCode,dp.alias,c.datateam1,c.datateam2,dt1.nameShow as nameShow1,dt2.nameShow as nameShow2,dt1.basealias as basealias1,dt2.basealias as basealias2,e.player_id,e.match_id FROM `events2014` e INNER JOIN calendars2014 c ON c.id = e.match_id INNER JOIN events ev ON ev.id = e.action INNER JOIN dataplayers dp ON dp.id = e.player_id INNER JOIN datateams dt1 ON dt1.id = c.datateam1 INNER JOIN datateams dt2 ON dt2.id = c.datateam2 WHERE ev.main_action = 1 AND c.round = 42 AND e.real_date IS NOT NULL AND e.league_id = 2563 ORDER BY total DESC LIMIT 100
0.0110  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-05-09 18:34:24' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0106  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=2 AND last_update > '2024-05-09 18:34:24' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0106  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=4 AND last_update > '2024-05-09 18:34:24' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0107  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=3 AND last_update > '2024-05-09 18:34:24' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0116  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'tercera' AND (l.group_code = 0 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 2014 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=0 DESC LIMIT 1
0.0399  SELECT e.action, count(e.action) as total,p.name, p.last_name, p.nick,p.CountryCode,p.alias,rp.team_id,dt.nameShow,dt.short_name,dt.basealias,rp.player_id,rp.teamId FROM `rel_players` rp INNER JOIN dataplayers p ON p.id = rp.player_id INNER JOIN events2014 e ON e.player_id = p.id AND e.league_id = 2563 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 2563 AND (e.action = 1 or e.action = 2 or e.action = 11 or e.action = 12 or e.action = 13) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0126  SELECT e.action, count(e.action) as total,p.name, p.last_name, p.nick,p.CountryCode,p.alias,rp.team_id,dt.nameShow,dt.short_name,dt.basealias,rp.player_id,rp.teamId FROM `rel_players` rp INNER JOIN dataplayers p ON p.id = rp.player_id INNER JOIN events2014 e ON e.player_id = p.id AND e.league_id = 2563 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 2563 AND (e.action = 4 or e.action = 5) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0108  SELECT e.action, count(e.action) as total,p.name, p.last_name, p.nick,p.CountryCode,p.alias,rp.team_id,dt.nameShow,dt.short_name,dt.basealias,rp.player_id,rp.teamId FROM `rel_players` rp INNER JOIN dataplayers p ON p.id = rp.player_id INNER JOIN events2014 e ON e.player_id = p.id AND e.league_id = 2563 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 2563 AND (e.action = 3 or e.action = 4) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0120  SELECT *,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables2014` 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 = 2563 AND t.round = 42 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC