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 Alfajarin CF Alfajarin 29 71 33 65
2 Escalerillas AT Escalerillas 29 81 40 56
3 Villamayor Villamayor 29 66 38 56
4 Union La Jota Vadorrey Union Jota. 29 74 47 55
5 Montañana CD Montañana 29 58 51 50
6 Submarino Submarino 28 78 54 47
7 Monzalbarba Monzalbarba 29 50 55 45
8 Atlético Mozarrifar CD Atlético 29 54 47 42
9 Casetas Casetas 29 51 53 41
10 Atlético Miralbueno Atlético 29 54 56 36
11 Santa Isabel R.S.D Santa Isabel 28 44 50 36
12 Garrapinillos CD Garrapinillo 29 64 61 35
13 Cd Movera Cd Movera 29 61 62 34
14 Zuera CD Zuera CD 29 44 56 32
15 Villanueva CF B Villanueva 29 43 66 32
16 Delicias CD B Delicias 29 43 72 23
17 Actur Pablo Iglesias B Actur Pablo 29 36 76 20
18 El Burgo de Ebro Burgo Ebro 29 50 105 15
Ver
TEMPORADA 2022/2023
Equipo PJ GF GC Puntos
1 Huracan Huracan 33 107 32 80
2 San Mateo CD Mateo 34 88 32 77
3 Inmortalem CF Inmortalem 34 113 59 68
4 Escalerillas AT Escalerillas 34 83 61 63
5 Miralbueno CD Miralbueno 34 65 69 50
6 Casetas Casetas 34 68 61 49
7 Submarino Submarino 34 85 83 49
8 Zuera CD Zuera CD 33 74 60 48
9 Villamayor Villamayor 34 69 65 48
10 El Burgo de Ebro Burgo Ebro 34 78 78 47
11 Montañana CD Montañana 34 63 66 47
12 La Cartuja La Cartuja 34 64 65 45
13 Seulcar San Fernando Seulcar 34 65 77 43
14 Camping Bohalar Camping 34 79 108 42
15 Perdiguera CD Perdiguera 34 50 91 35
16 San Andres AF Andres 34 38 93 29
17 El Salvador SD Salvador 34 51 78 27
18 Los Molinos UD Molinos 34 56 118 22
Ver
TEMPORADA 2021/2022
Equipo PJ GF GC Puntos
1 Pina CD Pina CD 33 85 34 73
2 Cd Movera Cd Movera 34 82 47 68
3 Utebo CF B Utebo CF B 34 70 38 68
4 Casetas Casetas 34 89 47 67
5 Huracan Huracan 34 85 36 65
6 Miralbueno CD Miralbueno 34 82 61 62
7 La Cartuja La Cartuja 34 58 51 48
8 Camping Bohalar Camping 34 69 94 46
9 Escalerillas AT Escalerillas 34 76 89 45
10 Perdiguera CD Perdiguera 34 63 70 42
11 Los Molinos UD Molinos 34 83 74 41
12 Montañana CD Montañana 34 62 76 41
13 Alfinden Alfinden 34 67 76 40
14 Zuera B Zuera B 34 55 75 40
15 El Salvador SD Salvador 33 46 79 33
16 El Gancho El Gancho 34 51 68 32
17 Peñaflor Peñaflor 34 39 74 30
18 Ranillas At. B Ranillas 32 55 128 14
Ver
TEMPORADA 2020/2021
Equipo PJ GF GC Puntos
1 Alfajarin CF Alfajarin 10 18 5 21
2 Huracan CD Huracan CD 10 31 15 19
3 Casetas Casetas 10 13 19 16
4 Pina CD Pina CD 10 14 14 13
5 Utebo CF B Utebo CF B 10 10 18 10
6 El Gancho El Gancho 10 15 30 7
Ver
TEMPORADA 2019/2020
Equipo PJ GF GC Puntos
Ver
TEMPORADA 2018/2019
Equipo PJ GF GC Puntos
1 San Andres AF Andres 34 90 43 79
2 San Agustin CD Agustin 34 100 43 73
3 Oliver Oliver 33 89 49 72
4 Ajax de Juslibol Ajax 34 92 51 70
5 El Burgo de Ebro Burgo Ebro 34 81 54 63
6 Los Bancos Los Bancos 34 87 65 61
7 Ranillas At. B Ranillas 34 86 86 55
8 Utebo CF B Utebo CF B 34 66 56 49
9 Camping Bohalar Camping 34 69 79 46
10 Miralbueno CD Miralbueno 34 74 76 42
11 Alfajarin CF Alfajarin 34 66 72 42
12 Montañana CD Montañana 34 73 93 42
13 Escalerillas AT Escalerillas 34 61 71 38
14 La Cartuja La Cartuja 34 69 82 36
15 Valdefierro CD Valdefierro 34 71 100 34
16 Rsd Santa Isabel B Santa Isabel 33 60 105 33
17 Peñaflor Peñaflor 34 36 83 20
18 Olivar Olivar 34 43 105 12
Ver
TEMPORADA 2017/2018
Equipo PJ GF GC Puntos
1 Monzalbarba Monzalbarba 32 74 35 70
2 Fleta CD Fleta CD 32 84 50 69
3 Huracan CD Huracan CD 32 98 52 63
4 CD Cuarte B CD Cuarte B 32 75 57 61
5 Utebo CF B Utebo CF B 32 60 38 55
6 San Agustin CD Agustin 32 70 55 52
7 Ranillas At. B Ranillas 32 71 69 51
8 San Andres AF Andres 32 65 51 50
9 Olivar Olivar 32 58 65 41
10 Los Bancos Los Bancos 32 58 72 39
11 Oliver Oliver 32 51 66 36
12 Ajax de Juslibol Ajax 32 64 82 36
13 Montañana CD Montañana 31 64 81 35
14 La Cartuja La Cartuja 31 63 77 31
15 Peñaflor Peñaflor 32 59 90 31
16 Perdiguera CD Perdiguera 32 40 76 23
17 San Fernando Amesa Puesta Fernando 32 51 89 22
Ver
TEMPORADA 2016/2017
Equipo PJ GF GC Puntos
1 Villamayor Villamayor 33 90 49 69
2 Valdefierro CD Valdefierro 34 78 43 68
3 Actur Pablo Iglesias B Actur Pablo 34 64 49 63
4 Garrapinillos CD Garrapinillo 33 95 59 59
5 Alfajarin CF Alfajarin 34 65 56 55
6 Montañana CD Montañana 34 69 56 54
7 San Agustin CD Agustin 34 83 76 51
8 Huracan CD Huracan CD 34 90 73 49
9 San Andres AF Andres 33 70 62 49
10 Perdiguera CD Perdiguera 34 59 53 49
11 Olivar Olivar 34 59 60 47
12 Utebo CF B Utebo CF B 33 62 66 47
13 La Cartuja La Cartuja 34 63 78 45
14 Peñaflor Peñaflor 34 67 76 40
15 Zaragoza Asociados Zaragoza 33 58 70 39
16 Delicias UD Delicias UD 34 53 100 30
17 Hispanidad CD Hispanidad 34 54 80 26
18 Pina CD Pina CD 33 22 95 12
Ver
TEMPORADA 2015/2016
Equipo PJ GF GC Puntos
1 Miralbueno CD Miralbueno 33 96 48 76
2 Ajax de Juslibol Ajax 34 109 61 70
3 Cd Movera Cd Movera 33 79 39 67
4 Perdiguera CD Perdiguera 34 79 48 66
5 Villamayor Villamayor 32 86 52 64
6 Peñaflor Peñaflor 34 94 60 63
7 Zaragoza Asociados Zaragoza 33 85 62 61
8 San Agustin CD Agustin 34 90 65 50
9 Pina CD Pina CD 33 56 60 45
10 Alfajarin CF Alfajarin 34 64 68 44
11 Garrapinillos CD Garrapinillo 34 84 72 44
12 Valdefierro CD Valdefierro 34 66 62 42
13 Hispanidad CD Hispanidad 34 48 80 38
14 Montañana CD Montañana 34 65 82 34
15 Delicias UD Delicias UD 34 52 81 28
16 Arenas de Zaragoza Arenas 33 53 117 24
17 Villanueva CF B Villanueva 34 45 88 22
18 San Andres AF Andres 31 42 148 11
Ver
TEMPORADA 2014/2015
Equipo PJ GF GC Puntos
1 CD Delicias CD Delicias 34 90 34 73
2 Union La Jota Vadorrey Union Jota. 34 77 38 66
3 El Burgo de Ebro Burgo Ebro 34 86 49 63
4 Miralbueno CD Miralbueno 34 72 44 62
5 Garrapinillos CD Garrapinillo 34 85 60 58
6 San Andres AF Andres 34 70 58 53
7 Montañana CD Montañana 34 79 86 51
8 Racing Delicias Racing 34 78 75 50
9 Ajax de Juslibol Ajax 34 92 72 49
10 Zaragoza Asociados Zaragoza 34 72 57 48
11 Alfajarin CF Alfajarin 34 59 57 47
12 Hispanidad CD Hispanidad 34 59 71 44
13 San Agustin CD Agustin 34 83 77 43
14 Pina CD Pina CD 34 59 77 40
15 Fleta CD Fleta CD 34 48 75 40
16 Arenas de Zaragoza Arenas 34 56 103 40
17 San Mateo CD Mateo 34 43 80 20
18 Camping Bohalar Camping 34 28 123 11

  USO DE MEMORIA  
6,045,944 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0018
Controller Execution Time ( Home / Category )  0.1153
Total Execution Time  0.1171
  CADENA URL  
/segunda_regional_aragon2024/grupo1/historico
  GET DATOS  
$_GET['/segunda_regional_aragon2024/grupo1/historico']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (24)  
0.0021  SELECT type FROM routes WHERE alias = 'segunda_regional_aragon2024'
0.0022  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=701 AND type_rel = 3
0.0028  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 3 AND rel.typeId = 701 AND rel.ln = 'es' AND rel.status=1 ORDER BY rel.creation_date desc,rel.cover_points DESC LIMIT 5
0.0024  SELECT /*53 bs_news_model*/ n.id, n.author_id, n.headline, n.external_headline, n.live_headline, n.creation_date, n.update_date, n.pub_date, n.alias, n.subheadline, n.teaser, n.media, n.tags, n.views, n.screens, n.clicks, n.relations, n.comments, n.power_cover, n.cover_points, u.name as user_name FROM bs_news n INNER JOIN bs_editors u ON u.id = n.author_id AND u.ln = 'es' WHERE n.status = 1 AND n.ln = 'es' AND n.id IN (93111) ORDER BY n.cover_points DESC, update_date DESC
0.0022  SELECT id,name,alias,stepParent FROM categories WHERE parentId=701 ORDER BY order_id ASC
0.0033  SELECT id,year,current_round,total_teams,legend FROM leagues WHERE categoryId = 701 AND group_code = 1 and tables = 1 AND year <= 2024 AND total_num_tablesR >= 1 ORDER BY year DESC LIMIT 22
0.0057  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 = 73813 AND t.round = 31 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0048  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 = 69434 AND t.round = 34 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0044  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 = 64405 AND t.round = 34 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0034  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 = 59825 AND t.round = 10 ORDER BY team.conference ASC,t.position 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 `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 = 51409 AND t.round = 34 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0048  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 = 45263 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0037  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 = 39803 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0042  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 = 34374 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0042  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 = 16810 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0039  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 = 5124 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0023  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-05-02 16:09:43' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0023  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=2 AND last_update > '2024-05-02 16:09:43' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0023  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=4 AND last_update > '2024-05-02 16:09:43' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0025  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=3 AND last_update > '2024-05-02 16:09:43' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0030  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 = 73813 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 73813 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.0028  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 = 73813 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 73813 AND (e.action = 4 or e.action = 5) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0028  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 = 73813 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 73813 AND (e.action = 3 or e.action = 4) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0046  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 = 73813 AND t.round = 31 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC