4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Ver
TEMPORADA 2023/2024
Equipo PJ GF GC Puntos
1 CD Don Benito Benito 33 62 13 73
2 CD Coria CD Coria 33 58 19 69
3 CD Azuaga CD Azuaga 33 47 31 59
4 Villafranca Villafranca 33 43 26 52
5 Moralo Moralo 33 53 44 50
6 Castuera Castuera 33 46 37 49
7 CD Diocesano Diocesano 33 47 46 46
8 CF Jaraíz CF Jaraíz 33 48 49 45
9 Calamonte Calamonte 33 38 46 42
10 Jerez Jerez 33 41 49 42
11 Pueblonuevo Pueblonuevo 33 33 43 42
12 Olivenza Olivenza 33 32 38 41
13 Arroyo Arroyo 33 33 37 41
14 Trujillo Trujillo 33 30 36 38
15 Montehermoso Montehermoso 33 33 54 32
16 CD Don Álvaro Álvaro 33 28 48 31
17 Racing Valverdeño Racing 33 31 56 29
18 UD Fuente de Cantos Fuente 33 25 56 24
Ver
TEMPORADA 2022/2023
Equipo PJ GF GC Puntos
1 AD Llerenense Llerenense 30 52 22 64
2 CD Azuaga CD Azuaga 30 58 29 62
3 Moralo Moralo 30 52 24 55
4 Olivenza Olivenza 30 46 33 53
5 Jerez Jerez 30 39 25 49
6 Arroyo Arroyo 30 30 31 46
7 Trujillo Trujillo 30 28 28 44
8 Villafranca Villafranca 30 34 33 43
9 Calamonte Calamonte 30 38 33 42
10 UD Fuente de Cantos Fuente 30 23 28 39
11 Pueblonuevo Pueblonuevo 30 36 41 32
12 Montehermoso Montehermoso 30 31 53 31
13 CD Don Álvaro Álvaro 30 27 54 27
14 Miajadas Miajadas 30 23 41 26
15 Plasencia Plasencia 30 31 43 24
16 UC La Estrella Estrella 30 30 60 21
Ver
TEMPORADA 2021/2022
Equipo PJ GF GC Puntos
1 CD Diocesano Diocesano 30 61 30 63
2 Moralo Moralo 30 39 19 52
3 AD Llerenense Llerenense 30 44 32 51
4 Jerez Jerez 30 38 30 49
5 Arroyo Arroyo 30 40 30 48
6 Trujillo Trujillo 30 40 27 48
7 CD Azuaga CD Azuaga 30 41 31 48
8 Calamonte Calamonte 30 35 33 43
9 Plasencia Plasencia 30 24 29 38
10 Villafranca Villafranca 30 27 30 37
11 Olivenza Olivenza 30 31 35 33
12 CD Don Álvaro Álvaro 30 36 44 31
13 Miajadas Miajadas 30 30 48 29
14 EMD Aceuchal Aceuchal 30 24 42 29
15 CD Badajoz B Badajoz 30 24 38 27
16 Extremadura B Extremadura 30 18 54 0

  USO DE MEMORIA  
5,494,800 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0019
Controller Execution Time ( Home / Category )  0.3634
Total Execution Time  0.3653
  CADENA URL  
/tercera_division_rfef2024/grupo14/historico
  GET DATOS  
$_GET['/tercera_division_rfef2024/grupo14/historico']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (13)  
0.0291  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'tercera_division_rfef' AND (l.group_code = 14 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 2024 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=14 DESC LIMIT 1
0.0144  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=2470 AND type_rel = 3
0.0147  SELECT id,year,current_round,total_teams,legend FROM leagues WHERE categoryId = 2470 AND group_code = 14 and tables = 1 AND year <= 2024 AND total_num_tablesR >= 1 ORDER BY year DESC LIMIT 22
0.0148  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 = 67988 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.0152  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 = 62398 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.0148  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-05-07 09:44:25' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0147  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=2 AND last_update > '2024-05-07 09:44:25' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0148  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=4 AND last_update > '2024-05-07 09:44:25' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0148  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=3 AND last_update > '2024-05-07 09:44:25' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0263  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 events2024 e ON e.player_id = p.id AND e.league_id = 72274 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 72274 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 events2024 e ON e.player_id = p.id AND e.league_id = 72274 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 72274 AND (e.action = 4 or e.action = 5) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0162  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 events2024 e ON e.player_id = p.id AND e.league_id = 72274 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 72274 AND (e.action = 3 or e.action = 4) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0305  SELECT *,(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 = 72274 AND t.round = 33 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC