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 Atlético Albalate Atlético 17 38 15 39
2 Maella C.D. Maella C.D. 16 53 18 36
3 CD Calanda CD Calanda 17 39 25 36
4 Chiprana Chiprana 17 38 16 35
5 Calaceite Calaceite 16 33 19 30
6 Valderrobres Valderrobres 15 25 19 25
7 Mazaleon Mazaleon 16 26 28 22
8 Atlético Teruel Atlético 14 28 19 18
9 Valdealgorfa Valdealgorfa 16 29 43 15
10 La Salle Pol Salle 14 20 27 14
11 Castelseras Castelseras 17 16 47 11
12 Samper de Calanda Samper 17 10 37 6
13 Torrecilla Torrecilla 14 11 53 2
Ver
TEMPORADA 2018/2019
Equipo PJ GF GC Puntos
1 Atlético Albalate Atlético 28 91 20 66
2 Atlético Teruel Atlético 28 82 22 66
3 Alcorisa Alcorisa 27 83 24 66
4 Maella C.D. Maella C.D. 27 79 40 59
5 CD Calanda CD Calanda 28 59 28 58
6 Chiprana Chiprana 28 54 27 51
7 Teruel Teruel 27 59 39 43
8 Mazaleon Mazaleon 27 41 41 38
9 Valdealgorfa Valdealgorfa 28 61 75 34
10 Calaceite Calaceite 28 34 56 26
11 Castelseras Castelseras 26 28 77 22
12 Sastago SCD Sastago SCD 27 31 70 21
13 Samper de Calanda Samper 28 22 62 20
14 Pena Roja Pena Roja 27 17 84 11
15 Torrecilla Torrecilla 28 24 100 11
Ver
TEMPORADA 2017/2018
Equipo PJ GF GC Puntos
1 Quinto Quinto 32 114 12 85
2 Valderrobres Valderrobres 32 76 25 75
3 Chiprana Chiprana 32 64 27 70
4 Alcorisa Alcorisa 32 83 33 68
5 CD Calanda CD Calanda 32 83 31 67
6 Atlético Albalate Atlético 32 101 32 66
7 Maella C.D. Maella C.D. 32 85 44 64
8 Atlético Teruel Atlético 32 70 48 57
9 Sportin Alcañiz Cf Sportin 32 66 50 49
10 La Puebla De Hijar Puebla Hijar 32 48 77 37
11 Calaceite Calaceite 32 48 54 35
12 Valdealgorfa Valdealgorfa 32 52 90 29
13 Mazaleon Mazaleon 32 29 67 22
14 Sastago SCD Sastago SCD 32 40 94 21
15 Samper de Calanda Samper 32 20 108 15
16 Pena Roja Pena Roja 32 27 101 12
17 Torrecilla Torrecilla 32 21 134 11
Ver
TEMPORADA 2016/2017
Equipo PJ GF GC Puntos
1 Alcañiz Alcañiz 34 143 12 96
2 Teruel Teruel 34 117 41 82
3 Atlético Albalate Atlético 34 87 31 75
4 Sportin Alcañiz Cf Sportin 33 92 33 74
5 Atlético Teruel Atlético 32 84 45 62
6 Chiprana Chiprana 34 65 38 60
7 CD Calanda CD Calanda 34 86 37 59
8 Valderrobres Valderrobres 34 71 57 55
9 Maella C.D. Maella C.D. 34 89 73 54
10 Calaceite Calaceite 33 64 56 49
11 La Puebla De Hijar Puebla Hijar 34 71 91 40
12 Castelseras Castelseras 34 39 72 39
13 Valdealgorfa Valdealgorfa 33 64 104 36
14 Sastago SCD Sastago SCD 33 30 93 30
15 Pena Roja Pena Roja 33 35 95 20
16 Samper de Calanda Samper 34 25 130 15
17 Mazaleon Mazaleon 34 29 105 13
18 Torrecilla Torrecilla 33 28 106 9
Ver
TEMPORADA 2015/2016
Equipo PJ GF GC Puntos
1 Alcorisa Alcorisa 38 116 24 102
2 Fuensport Fuensport 36 111 25 92
3 Maella C.D. Maella C.D. 38 125 51 82
4 CD Calanda CD Calanda 38 105 41 81
5 Chiprana Chiprana 38 78 46 75
6 La Puebla De Hijar Puebla Hijar 38 75 57 67
7 Sportin Alcañiz Cf Sportin 38 85 49 62
8 Calaceite Calaceite 38 69 62 60
9 Atlético Albalate Atlético 38 70 58 57
10 Pena Roja Pena Roja 38 67 67 56
11 CF Lécera 2022 Lécera 2022 38 63 70 49
12 Valdealgorfa Valdealgorfa 38 63 65 46
13 Next Level Teruel-Academia Next Level. 37 67 90 46
14 Castelseras Castelseras 36 59 50 44
15 Atlético Teruel Atlético 38 71 93 44
16 Valderrobres Valderrobres 38 61 77 39
17 Torrecilla Torrecilla 37 38 115 28
18 Mazaleon Mazaleon 38 35 80 24
19 Cretense Cretense 38 34 119 10
20 Samper de Calanda Samper 38 25 178 3
Ver
TEMPORADA 2014/2015
Equipo PJ GF GC Puntos
1 Quinto Quinto 33 109 11 88
2 Sportin Alcañiz Cf Sportin 33 102 25 80
3 Alcorisa Alcorisa 33 109 31 75
4 Teruel Teruel 33 85 34 67
5 CF Lécera 2022 Lécera 2022 33 72 37 67
6 Fuensport Fuensport 33 111 43 63
7 Valderrobres Valderrobres 33 85 49 56
8 Castelseras Castelseras 33 61 38 56
9 Calaceite Calaceite 33 66 52 52
10 Valdealgorfa Valdealgorfa 33 57 57 51
11 Chiprana Chiprana 33 64 45 41
12 Pena Roja Pena Roja 33 64 79 30
13 Cretense Cretense 33 39 80 25
14 Escatron Escatron 33 26 108 22
15 Mazaleon Mazaleon 33 28 109 20
16 Torrecilla Torrecilla 33 34 103 17
17 Hijar Hijar 17 17 48 11
18 Samper de Calanda Samper 33 13 193 2

  USO DE MEMORIA  
5,469,128 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0019
Controller Execution Time ( Home / Category )  0.4432
Total Execution Time  0.4451
  CADENA URL  
/primera_regional_aragon2020/grupo4/historico
  GET DATOS  
$_GET['/primera_regional_aragon2020/grupo4/historico']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (21)  
0.0144  SELECT type FROM routes WHERE alias = 'primera_regional_aragon2020'
0.0297  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 = 4 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=4 DESC LIMIT 1
0.0148  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=700 AND type_rel = 3
0.0148  SELECT id,name,alias,stepParent FROM categories WHERE parentId=700 ORDER BY order_id ASC
0.0153  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 = 51302 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 = 4 and tables = 1 AND year <= 2020 AND total_num_tablesR >= 1 ORDER BY year DESC LIMIT 22
0.0149  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 = 51302 AND t.round = 18 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0151  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 = 44667 AND t.round = 30 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 = 39767 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0150  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 = 35279 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 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 = 16774 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0149  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 = 5123 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0146  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-04-27 12:26:19' 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-04-27 12:26:19' 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-04-27 12:26:19' 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=3 AND last_update > '2024-04-27 12:26:19' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0150  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 = 2020 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=0 DESC LIMIT 1
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 events2020 e ON e.player_id = p.id AND e.league_id = 51302 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 51302 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.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 events2020 e ON e.player_id = p.id AND e.league_id = 51302 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 51302 AND (e.action = 4 or e.action = 5) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
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 events2020 e ON e.player_id = p.id AND e.league_id = 51302 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 51302 AND (e.action = 3 or e.action = 4) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0155  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 = 51302 AND t.round = 18 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC