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

XIV - Extremadura

Tercera División 2020 G 14

  • Villanovense
  • CD Coria
  • CP Cacereño
  • Extremadura B
  • Moralo
  • Jerez
  • Trujillo
  • Arroyo
  • EMD Aceuchal
  • CD Diocesano
  • CD Azuaga
  • Olivenza
  • Plasencia
  • Calamonte
  • UD Montijo
  • Miajadas
  • UD Fuente de Cantos
  • AD Llerenense
  • Racing Valverdeño
  • CP Valdivia
  • Tercera División:

Clasificación

Equipo PJ GF GC Puntos
1 Villanovense Villanovense 28 56 19 66
2 CD Coria CD Coria 28 54 23 65
3 CP Cacereño Cacereño 27 63 20 62
4 Extremadura B Extremadura 28 42 27 52
5 Moralo Moralo 28 53 32 52
6 Jerez Jerez 28 35 26 44
7 Trujillo Trujillo 28 39 41 43
8 Arroyo Arroyo 28 33 33 42
9 EMD Aceuchal Aceuchal 27 41 37 41
10 CD Diocesano Diocesano 28 48 34 40
11 CD Azuaga CD Azuaga 28 36 35 39
12 Olivenza Olivenza 28 39 52 37
13 Plasencia Plasencia 28 29 38 35
14 Calamonte Calamonte 28 36 44 34
15 UD Montijo UD Montijo 28 34 40 31
16 Miajadas Miajadas 28 27 46 30
17 UD Fuente de Cantos Fuente 28 29 47 29
18 AD Llerenense Llerenense 28 22 38 23
19 Racing Valverdeño Racing 28 19 56 15
20 CP Valdivia CP Valdivia 28 18 65 7

  USO DE MEMORIA  
5,488,152 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0021
Controller Execution Time ( Home / Category )  0.3506
Total Execution Time  0.3527
  CADENA URL  
/tercera2020/grupo14/resumen/26
  GET DATOS  
$_GET['/tercera2020/grupo14/resumen/26']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (13)  
0.0265  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 = 2020 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=14 DESC LIMIT 1
0.0132  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 = 50282 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0133  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 `calendars2020` 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` = 50282 AND c.`round` = 26 ORDER BY shedule ASC LIMIT 200
0.0177  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 `events2020` e INNER JOIN calendars2020 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 = 28 AND e.real_date IS NOT NULL AND e.league_id = 50282 ORDER BY total DESC LIMIT 100
0.0126  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-05-02 21:36:29' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0125  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=2 AND last_update > '2024-05-02 21:36:29' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0125  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=4 AND last_update > '2024-05-02 21:36:29' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0125  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=3 AND last_update > '2024-05-02 21:36:29' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0228  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 events2020 e ON e.player_id = p.id AND e.league_id = 50282 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 50282 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.0357  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 events2020 e ON e.player_id = p.id AND e.league_id = 50282 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 50282 AND (e.action = 4 or e.action = 5) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0144  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 events2020 e ON e.player_id = p.id AND e.league_id = 50282 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 50282 AND (e.action = 3 or e.action = 4) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0260  SELECT *,(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 = 50282 AND t.round = 28 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0140  SELECT * FROM tables_coeff WHERE `league_id` = '50282' AND `round` = '28'