4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Ver
TEMPORADA 2016/2017
Equipo PJ GF GC Puntos
1 San Gregorio Arrabal Gregorio 34 79 42 72
2 Alfindén A.D Alfindén 34 80 39 67
3 AD San Juan AD San Juan 34 68 46 64
4 CD Delicias CD Delicias 33 73 49 59
5 San Fernando Fernando 33 72 65 57
6 El Salvador SD Salvador 34 77 56 56
7 Ranillas At. Ranillas 34 78 61 53
8 El Gancho CF Gancho 33 60 46 53
9 La Cartuja FC Cartuja 33 54 40 50
10 Miralbueno CD Miralbueno 34 74 62 50
11 Zuera Zuera 34 52 61 42
12 Union La Jota Vadorrey Union Jota. 34 62 76 39
13 Cd Movera Cd Movera 34 56 78 38
14 Anento Anento 34 48 60 37
15 El Burgo de Ebro Burgo Ebro 34 46 72 35
16 Ajax de Juslibol Ajax 34 62 95 35
17 CD Cuarte B CD Cuarte B 34 46 73 31
18 Villanueva B Villanueva 32 32 98 22
Ver
TEMPORADA 2015/2016
Equipo PJ GF GC Puntos
1 Valdefierro Valdefierro 33 86 28 83
2 Zaragoza 2014 Zaragoza 32 79 34 80
3 Alfindén A.D Alfindén 33 71 57 56
4 El Salvador SD Salvador 33 71 52 54
5 AD San Juan AD San Juan 33 67 60 52
6 Zuera Zuera 33 54 55 51
7 La Cartuja FC Cartuja 33 61 54 50
8 CD Delicias CD Delicias 33 66 64 46
9 El Gancho CF Gancho 32 64 67 43
10 San Fernando Fernando 32 47 53 40
11 Anento Anento 33 52 76 39
12 El Burgo de Ebro Burgo Ebro 33 57 65 39
13 CD Cuarte B CD Cuarte B 33 51 59 38
14 Union La Jota Vadorrey Union Jota. 33 61 72 37
15 Ranillas At. Ranillas 33 48 73 36
16 Huracan CD Huracan CD 17 30 35 26
17 Utebo CF B Utebo CF B 33 47 68 26
18 San Andres AF Andres 32 37 77 17
Ver
TEMPORADA 2014/2015
Equipo PJ GF GC Puntos
1 San Gregorio Arrabal Gregorio 34 89 41 73
2 Hernán Cortés Junquera Hernán 34 94 39 70
3 Zaragoza 2014 Zaragoza 34 76 39 68
4 Alfindén A.D Alfindén 34 69 35 67
5 El Salvador SD Salvador 34 76 62 54
6 San Andres AF Andres 34 51 59 48
7 AD San Juan AD San Juan 34 58 64 47
8 CD Cuarte B CD Cuarte B 34 52 54 45
9 Huracan CD Huracan CD 34 67 64 44
10 La Cartuja FC Cartuja 34 66 65 44
11 San Fernando Fernando 34 53 59 44
12 El Gancho CF Gancho 34 60 88 44
13 Utebo CF B Utebo CF B 34 64 73 43
14 Anento Anento 34 53 59 42
15 Ranillas At. Ranillas 34 48 60 39
16 Cd Movera Cd Movera 34 46 76 37
17 Valdefierro CD Valdefierro 34 49 78 27
18 Perdiguera CD Perdiguera 34 33 89 19

  USO DE MEMORIA  
5,273,672 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0019
Controller Execution Time ( Home / Category )  0.3593
Total Execution Time  0.3613
  CADENA URL  
/primera_regional_aragon2017/grupo1/historico
  GET DATOS  
$_GET['/primera_regional_aragon2017/grupo1/historico']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (16)  
0.0150  SELECT type FROM routes WHERE alias = 'primera_regional_aragon2017'
0.0303  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'primera_regional_aragon' AND (l.group_code = 1 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 2017 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=1 DESC LIMIT 1
0.0145  SELECT id,name,alias,stepParent FROM categories WHERE parentId=700 ORDER BY order_id ASC
0.0146  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 = 34097 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0150  SELECT id,year,current_round,total_teams,legend FROM leagues WHERE categoryId = 700 AND group_code = 1 and tables = 1 AND year <= 2017 AND total_num_tablesR >= 1 ORDER BY year DESC LIMIT 22
0.0156  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 = 34097 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0158  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 = 5120 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0151  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-05-08 14:57:41' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0145  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=2 AND last_update > '2024-05-08 14:57:41' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0144  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=4 AND last_update > '2024-05-08 14:57:41' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0144  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=3 AND last_update > '2024-05-08 14:57:41' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0151  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'primera_regional_aragon' AND (l.group_code = 0 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 2017 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=0 DESC LIMIT 1
0.0147  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 events2017 e ON e.player_id = p.id AND e.league_id = 34097 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 34097 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.0146  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 events2017 e ON e.player_id = p.id AND e.league_id = 34097 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 34097 AND (e.action = 4 or e.action = 5) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0146  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 events2017 e ON e.player_id = p.id AND e.league_id = 34097 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 34097 AND (e.action = 3 or e.action = 4) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0156  SELECT *,(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 = 34097 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC