4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Ver
TEMPORADA 2019/2020
Equipo PJ GF GC Puntos
1 Pueblonuevo Pueblonuevo 25 51 19 54
2 CP Oliva CP Oliva 25 39 23 52
3 AD Lobón AD Lobón 25 49 24 48
4 CD Badajoz B Badajoz 25 40 19 43
5 CD Gévora CD Gévora 24 37 24 42
6 Sanvicenteño Sanvicenteñ 25 43 36 35
7 Valdelacalzada Valdelacalza 25 38 43 35
8 UD Talavera UD Talavera 24 34 39 35
9 Santa Marta Santa Marta 25 34 29 33
10 Guadiana Guadiana 24 30 29 33
11 Villar del Rey Industrial Villar 24 41 42 33
12 Alburquerque Alburquerque 24 32 38 30
13 CP Cheles CP Cheles 24 34 42 25
14 CF San Jorge Jorge 24 29 41 19
15 La Albuera-Faesal Albuera-Faes 24 24 53 18
16 Codosera CF Codosera CF 25 22 76 9
Ver
TEMPORADA 2018/2019
Equipo PJ GF GC Puntos
1 AD Lobón AD Lobón 30 53 26 62
2 CD San Serván Serván 30 40 18 60
3 Villar del Rey Industrial Villar 30 49 39 54
4 CD Badajoz B Badajoz 30 61 35 53
5 Guadiana Guadiana 30 55 34 53
6 Santa Marta Santa Marta 30 40 37 48
7 Codosera CF Codosera CF 30 39 40 42
8 CP Oliva CP Oliva 30 37 31 41
9 UD Talavera UD Talavera 30 42 41 38
10 Sanvicenteño Sanvicenteñ 30 36 48 36
11 Alburquerque Alburquerque 30 26 39 35
12 CP Cheles CP Cheles 30 26 40 31
13 CD Gévora CD Gévora 30 28 43 29
14 EF Puebla de la Calzada Puebla 30 24 41 26
15 La Albuera-Faesal Albuera-Faes 30 17 34 25
16 Santa Teresa A Santa Teresa 30 33 60 21
Ver
TEMPORADA 2017/2018
Equipo PJ GF GC Puntos
1 AD Lobón AD Lobón 30 68 30 63
2 Racing Valverdeño Racing 30 56 32 62
3 Valdelacalzada Valdelacalza 30 56 29 61
4 Sanvicenteño Sanvicenteñ 30 50 28 60
5 Guadiana Guadiana 30 53 36 55
6 UD Talavera UD Talavera 30 38 31 52
7 CD Gévora CD Gévora 30 41 36 51
8 Villar del Rey Industrial Villar 30 55 29 47
9 EF Puebla de la Calzada Puebla 30 50 34 46
10 CP Cheles CP Cheles 30 39 38 40
11 Santa Teresa A Santa Teresa 30 47 58 30
12 La Albuera-Faesal Albuera-Faes 30 27 52 29
13 CD Badajoz B Badajoz 30 31 47 27
14 CP Oliva CP Oliva 30 22 42 24
15 Alburquerque Alburquerque 30 32 75 17
16 Peña el Valle A Peña Valle 30 18 86 15
Ver
TEMPORADA 2016/2017
Equipo PJ GF GC Puntos
1 UD Talavera UD Talavera 30 55 32 54
2 Alburquerque Alburquerque 30 47 39 53
3 EMD Aceuchal Aceuchal 30 61 35 52
4 Guadiana Guadiana 30 49 36 49
5 Valdelacalzada Valdelacalza 30 54 39 47
6 Sanvicenteño Sanvicenteñ 30 32 20 47
7 Racing Valverdeño Racing 30 44 34 47
8 CD Badajoz B Badajoz 30 41 43 44
9 AD Lobón AD Lobón 30 43 40 41
10 CD Gévora CD Gévora 30 42 49 40
11 CP Oliva CP Oliva 30 31 47 40
12 CP Cheles CP Cheles 30 31 36 39
13 EF Puebla de la Calzada Puebla 30 46 53 35
14 Santa Marta Santa Marta 30 33 56 31
15 Deportivo Pacense Deportivo 30 34 61 26
16 Gran Maestre Gran Maestre 30 40 63 22
Ver
TEMPORADA 2015/2016
Equipo PJ GF GC Puntos
1 Gran Maestre Gran Maestre 21 53 21 46
2 Santa Marta Santa Marta 21 53 28 41
3 Almendralejo A Almendralejo 21 45 37 36
4 UD Frexnense Frexnense 21 39 28 36
5 La Albuera-Faesal Albuera-Faes 21 35 20 34
6 Higuera CF Higuera CF 21 46 47 31
7 Bienvenida A Bienvenida 20 38 41 28
8 Hernando De Soto A Hernando 20 38 38 21
9 Atlético Torremejía Atlético 21 36 51 21
10 Segureña A Segureña A 20 42 45 20
11 Extremadura B Extremadura 10 13 13 17
12 San Jose Promesas B Jose 21 20 89 4
Ver
TEMPORADA 2014/2015
Equipo PJ GF GC Puntos
1 CD Berlanga CD Berlanga 24 87 26 57
2 Usagre Usagre 24 45 25 53
3 Atlético Torremejía Atlético 24 62 39 49
4 CD Don Álvaro Álvaro 24 55 34 42
5 Gran Maestre Gran Maestre 24 40 43 36
6 Azuaga B Azuaga B 24 43 39 35
7 Alfar-Salvatierra A Alfar-Salvat 24 32 55 32
8 UD Frexnense Frexnense 24 42 43 31
9 Saludeño Saludeño 24 45 49 30
10 Higuera CF Higuera CF 24 47 51 28
11 Segureña A Segureña A 24 48 73 23
12 Atletico Romano A Atletico 24 36 45 18
13 Bienvenida A Bienvenida 24 21 81 8

  USO DE MEMORIA  
5,645,112 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0027
Controller Execution Time ( Home / Category )  0.1087
Total Execution Time  0.1115
  CADENA URL  
/primera_regional_extremadura2020/grupo2/historico
  GET DATOS  
$_GET['/primera_regional_extremadura2020/grupo2/historico']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (20)  
0.0017  SELECT type FROM routes WHERE alias = 'primera_regional_extremadura2020'
0.0042  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'primera_regional_extremadura' AND (l.group_code = 2 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=2 DESC LIMIT 1
0.0018  SELECT id,name,alias,stepParent FROM categories WHERE parentId=835 ORDER BY order_id ASC
0.0022  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 = 51307 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0024  SELECT id,year,current_round,total_teams,legend FROM leagues WHERE categoryId = 835 AND group_code = 2 and tables = 1 AND year <= 2020 AND total_num_tablesR >= 1 ORDER BY year DESC LIMIT 22
0.0033  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 = 51307 AND t.round = 25 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0025  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 = 44629 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0024  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 = 39345 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0027  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 = 34428 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0024  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 = 16782 AND t.round = 22 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0026  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 = 5199 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0018  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-04-28 06:47:48' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0018  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=2 AND last_update > '2024-04-28 06:47:48' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0018  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=4 AND last_update > '2024-04-28 06:47:48' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0018  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=3 AND last_update > '2024-04-28 06:47:48' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0023  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'primera_regional_extremadura' AND (l.group_code = 0 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=0 DESC LIMIT 1
0.0140  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 = 51307 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 51307 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.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 events2020 e ON e.player_id = p.id AND e.league_id = 51307 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 51307 AND (e.action = 4 or e.action = 5) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0029  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 = 51307 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 51307 AND (e.action = 3 or e.action = 4) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0048  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 = 51307 AND t.round = 25 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC