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 Cabezuela Cabezuela 24 84 34 60
2 Piornal Piornal 24 80 23 59
3 Nuevo Caceres Nuevo San Fra Nuevo 24 61 22 52
4 UD Aceituna UD Aceituna 24 58 33 48
5 Brocense Brocense 24 64 41 43
6 CP Navaconcejo Navaconcejo 23 48 40 35
7 Las Hurdes CF Hurdes 24 61 49 34
8 CF Jerte CF Jerte 23 49 46 28
9 CD Coria B CD Coria B 24 49 52 26
10 CF Verato CF Verato 24 51 96 21
11 Norte de Extremadura Norte 24 43 80 17
12 Atletico Tietar Atletico 24 30 89 16
13 Cacereño Atlético Veracruz Cacereño 24 25 98 7
Ver
TEMPORADA 2022/2023
Equipo PJ GF GC Puntos
1 Torreorgaz Torreorgaz 21 74 13 52
2 Torrejoncillo Torrejoncill 22 38 28 46
3 Piornal Piornal 22 54 29 44
4 Las Hurdes CF Hurdes 21 47 23 44
5 Cabezuela Cabezuela 22 47 28 40
6 CF Jerte CF Jerte 22 59 45 34
7 CD Coria B CD Coria B 22 40 34 33
8 Brocense Brocense 22 43 45 26
9 UD Aceituna UD Aceituna 22 33 42 19
10 CF Verato CF Verato 21 34 69 10
11 Atletico Tietar Atletico 22 18 66 10
12 Norte de Extremadura Norte 21 20 85 7
Ver
TEMPORADA 2021/2022
Equipo PJ GF GC Puntos
1 CF Casar de Caceres Sotobos Casar 26 86 17 65
2 Moralo B Moralo B 26 80 15 61
3 Torreorgaz Torreorgaz 26 69 24 59
4 Cacereño B Cacereño B 25 71 24 56
5 AD Puente San Francisco Puente 26 66 41 50
6 Las Hurdes CF Hurdes 26 54 37 49
7 Torrejoncillo Torrejoncill 26 58 47 41
8 Brocense Brocense 26 49 66 32
9 Cacereño Atlético Veracruz Cacereño 26 45 64 27
10 Cumbreño Cumbreño 26 50 71 27
11 CF Jerte CF Jerte 26 53 73 24
12 CF Trujillo B Trujillo 26 37 81 17
13 CF Verato CF Verato 26 29 107 8
14 Atletico Tietar Atletico 25 19 99 5
Ver
TEMPORADA 2020/2021
Equipo PJ GF GC Puntos
1 Cabezuela Cabezuela 14 34 17 33
2 CF Casar de Caceres Sotobos Casar 14 32 12 29
3 Navalmoral Navalmoral 14 18 25 22
4 CP Navaconcejo Navaconcejo 13 32 22 21
5 Torrejoncillo Torrejoncill 13 17 13 21
6 AD Puente San Francisco Puente 13 17 31 12
7 Cacereño Atlético Veracruz Cacereño 14 20 27 11
8 Cumbreño Cumbreño 13 11 34 7
Ver
TEMPORADA 2019/2020
Equipo PJ GF GC Puntos
1 CF Caceres CF Caceres 20 43 12 42
2 Cumbreño Cumbreño 20 40 41 39
3 Ciudad De Plasencia Ciudad 20 41 29 34
4 AD San Jorge Jorge 20 48 35 31
5 Cacereño Atlético Veracruz Cacereño 20 38 38 30
6 Navalmoral Navalmoral 20 34 27 28
7 Ad Casar De Cáceres Casar 20 40 37 28
8 CD Almoharín A Almoharín 19 31 28 27
9 Cabezuela Cabezuela 20 40 38 27
10 Brocense Brocense 20 34 39 27
11 Torrejoncillo Torrejoncill 20 19 22 26
12 Hervas A Hervas A 19 28 32 23
13 Atletico Tietar Atletico 20 28 43 19
14 Nuevo Plasencia Nuevo 20 12 55 4
Ver
TEMPORADA 2018/2019
Equipo PJ GF GC Puntos
1 CF Caceres CF Caceres 24 61 23 53
2 CF Jaraíz CF Jaraíz 24 80 21 52
3 Hervas A Hervas A 24 53 29 46
4 Cabezuela Cabezuela 24 52 32 44
5 Atletico Tietar Atletico 24 49 41 40
6 Navalmoral Navalmoral 23 44 35 37
7 Imperio De Alcuescar A Imperio 24 38 50 31
8 Brocense Brocense 24 39 48 28
9 Ad Casar De Cáceres Casar 24 26 37 28
10 Nuevo Plasencia Nuevo 24 45 52 25
11 Cumbreño Cumbreño 23 32 53 24
12 CD Almoharín A Almoharín 24 25 50 20
13 Valencia de Alcantara A Valencia 24 20 93 7
Ver
TEMPORADA 2017/2018
Equipo PJ GF GC Puntos
1 Imperio De Alcuescar A Imperio 21 44 25 41
2 Brocense Brocense 22 39 34 39
3 CF Jaraíz CF Jaraíz 22 34 27 38
4 AD Valdefuentes Valdefuentes 22 47 35 36
5 Nuevo Plasencia Nuevo 22 43 29 35
6 Amanecer B Amanecer B 22 41 35 32
7 Cabezuela Cabezuela 22 40 32 31
8 CD Almoharín A Almoharín 21 30 31 29
9 Cumbreño Cumbreño 22 38 44 25
10 Navalmoral Navalmoral 22 29 52 21
11 Atletico Tietar Atletico 20 23 46 19
12 Hervas A Hervas A 22 29 47 17
Ver
TEMPORADA 2016/2017
Equipo PJ GF GC Puntos
1 UD Frexnense Frexnense 26 63 33 59
2 Atlético Torremejía Atlético 26 67 34 55
3 CD Zarceño CD Zarceño 26 47 33 48
4 Bienvenida A Bienvenida 26 70 37 47
5 Monesterio Monesterio 25 59 34 45
6 Sporting Malpartida A Sporting 26 70 47 45
7 Castuera Subastacar B Castuera 25 45 38 44
8 Monterrubio CD Monterrubio 26 46 53 35
9 Higuera CF Higuera CF 26 44 47 32
10 Segureña A Segureña A 26 29 57 31
11 Solana UD Solana UD 26 41 51 25
12 Athletic Valle A Athletic 26 30 57 21
13 Cabeza Del Buey Cabeza Buey 26 28 73 15
14 S. Marcos Almendralejo A Marcos 26 39 84 12

  USO DE MEMORIA  
5,624,264 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0019
Controller Execution Time ( Home / Category )  0.3760
Total Execution Time  0.3779
  CADENA URL  
/segunda_regional_extremadura2024/grupo1/historico
  GET DATOS  
$_GET['/segunda_regional_extremadura2024/grupo1/historico']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (19)  
0.0252  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'segunda_regional_extremadura' AND (l.group_code = 1 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=1 DESC LIMIT 1
0.0127  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 = 73795 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0126  SELECT id,year,current_round,total_teams,legend FROM leagues WHERE categoryId = 1904 AND group_code = 1 and tables = 1 AND year <= 2024 AND total_num_tablesR >= 1 ORDER BY year DESC LIMIT 22
0.0132  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 = 73795 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.0129  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 = 69354 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.0130  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 = 63833 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.0131  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 `tables2021` 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 = 59815 AND t.round = 14 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0141  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 = 51341 AND t.round = 20 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0143  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 `tables2019` 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 = 45372 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
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 `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 = 39812 AND t.round = 22 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0136  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 `tables2017` 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 = 37076 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0127  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-04-27 23:37:35' 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-04-27 23:37:35' 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-04-27 23:37:35' 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-04-27 23:37:35' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0201  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 = 73795 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 73795 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.0205  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 = 73795 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 73795 AND (e.action = 4 or e.action = 5) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0133  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 = 73795 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 73795 AND (e.action = 3 or e.action = 4) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0135  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 = 73795 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