4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del Internacional Huesca
TEMPORADA 2023/2024
PREFERENTE ARAGÓN GRUPO 1
Equipo PJ GF GC Puntos
1 Robres Robres 29 70 38 59
2 Zuera Zuera 29 61 36 58
3 Sadabense CD Sadabense 29 52 30 56
4 Ontiñena Ontiñena 29 43 24 56
5 Internacional Huesca Internaciona 29 49 23 54
6 Santa Anastasia CF Santa 29 49 30 52
7 Sabiñánigo Sabiñánigo 29 52 25 51
8 Sariñena Sariñena 29 40 39 42
9 Jacetano Jacetano 29 32 39 38
10 Los Bancos Los Bancos 29 24 36 35
11 UD Montecarlo Montecarlo 29 39 53 34
12 CD Delicias CD Delicias 29 25 50 33
13 Atletico Binefar Atletico 29 37 51 33
14 Altorricón Altorricón 29 39 61 32
15 Valdefierro Valdefierro 29 30 52 27
16 Alcolea CF Alcolea CF 29 23 39 24
17 AD Tardienta Tardienta 29 39 58 24
18 Gurrea Gurrea 29 28 48 22
TEMPORADA 2022/2023
PREFERENTE ARAGÓN GRUPO 1
Equipo PJ GF GC Puntos
1 Fraga Fraga 26 70 18 63
2 Internacional Huesca Internaciona 26 56 22 60
3 AD Tardienta Tardienta 26 45 21 50
4 Sabiñánigo Sabiñánigo 26 45 27 41
5 Jacetano Jacetano 26 36 38 41
6 Sariñena Sariñena 26 46 32 39
7 Altorricón Altorricón 26 50 39 38
8 Zuera Zuera 26 34 29 35
9 Ontiñena Ontiñena 26 34 46 34
10 Alcolea CF Alcolea CF 26 40 37 33
11 Actur Pablo Iglesias Actur Pablo 26 38 50 29
12 Villanueva CF Villanueva 26 32 61 22
13 Ajax de Juslibol Ajax 26 28 76 9
14 Biescas Biescas 26 24 82 8
TEMPORADA 2021/2022
PREFERENTE ARAGÓN GRUPO 1
Equipo PJ GF GC Puntos
1 CDJ Tamarite Tamarite 32 109 26 83
2 Sariñena Sariñena 32 79 22 78
3 Internacional Huesca Internaciona 32 55 21 67
4 Fraga Fraga 32 70 32 64
5 UD Montecarlo Montecarlo 32 61 47 56
6 Valdefierro Valdefierro 32 60 48 50
7 Sabiñánigo Sabiñánigo 32 57 42 46
8 Atlético Escalerillas Atlético 32 31 30 46
9 Casetas Casetas 32 53 42 45
10 Jacetano Jacetano 32 52 49 42
11 Alcolea CF Alcolea CF 32 42 58 41
12 CD Mequinenza Mequinenza 32 36 58 38
13 Peña Ferranca Peña 32 42 58 33
14 San Lorenzo Flumen Lorenzo 32 46 80 24
15 Almunia San Juan Almunia Juan 32 21 89 19
16 Zaragoza 2014 Zaragoza 32 22 67 17
17 Peñas Oscenses Peñas 32 22 89 16
TEMPORADA 2020/2021
PREFERENTE ARAGÓN GRUPO 1
Equipo PJ GF GC Puntos
1 Biescas Biescas 11 27 6 28
2 San Lorenzo Flumen Lorenzo 12 23 18 22
3 AD Tardienta Tardienta 12 22 13 19
4 Peña Ferranca Peña 12 17 26 15
5 Internacional Huesca Internaciona 11 18 16 14
6 CD Mequinenza Mequinenza 12 10 22 13
7 Peñas Oscenses Peñas 12 11 27 8
TEMPORADA 2019/2020
1ª REGIONAL ARAGÓN GRUPO 2
Equipo PJ GF GC Puntos
1 Internacional Huesca Internaciona 25 58 19 60
2 Gurrea Gurrea 24 74 35 56
3 Jacetano Jacetano 26 62 25 55
4 Alcolea CF Alcolea CF 26 61 29 53
5 Almunia San Juan Almunia Juan 24 47 20 50
6 Graus Graus 24 59 35 50
7 Esplus CD Esplus CD 25 60 31 41
8 Lanaja Lanaja 25 59 31 40
9 Altorricón Altorricón 26 57 42 39
10 San Jorge San Jorge 24 38 34 33
11 Atletico Binefar Atletico 26 43 47 32
12 Peñas Sariñena Peñas 25 36 44 32
13 Estadilla CD Estadilla 24 37 43 30
14 La Fueva La Fueva 26 34 44 30
15 Zaidin CD Zaidin CD 24 30 37 24
16 Bujaraloz CD Bujaraloz 26 45 63 24
17 Belver Belver 23 17 71 6
18 San Esteban UD Esteban 25 19 104 6
19 Grañén Grañén 22 17 99 3
TEMPORADA 2018/2019
1ª REGIONAL ARAGÓN GRUPO 2
Equipo PJ GF GC Puntos
1 Peñas Oscenses Peñas 32 94 22 82
2 Huesca B Huesca B 32 87 24 78
3 Peña Fragatina Peña 32 73 27 70
4 Gurrea Gurrea 32 65 33 66
5 Almunia San Juan Almunia Juan 32 42 43 51
6 Peñas Sariñena Peñas 32 43 40 46
7 Zaidin CD Zaidin CD 32 53 59 45
8 Alcolea CF Alcolea CF 32 44 51 42
9 Lanaja Lanaja 32 49 55 41
10 Estadilla CD Estadilla 32 55 63 39
11 Atletico Binefar Atletico 32 40 58 38
12 Esplus Esplus 31 38 47 36
13 San Esteban UD Esteban 32 42 63 36
14 Belver Belver 32 43 56 34
15 Internacional Huesca Internaciona 32 38 61 25
16 Ainsa Club Deportivo Ainsa Club. 32 27 84 18
17 Ontiñena Ontiñena 31 30 77 17
TEMPORADA 2017/2018
1ª REGIONAL ARAGÓN GRUPO 2
Equipo PJ GF GC Puntos
1 Altorricón Altorricón 33 84 33 76
2 Peña Fragatina Peña 34 77 44 71
3 Bujaraloz CD Bujaraloz 34 79 55 67
4 Jacetano Jacetano 34 71 25 66
5 Gurrea Gurrea 34 95 44 58
6 Pueyo Hinaco Pueyo Hinaco 33 62 53 57
7 Monzón Atlético B Monzón 34 61 41 51
8 UD Benabarre Benabarre 34 66 48 50
9 Lanaja Lanaja 34 66 60 50
10 Internacional Huesca Internaciona 34 65 70 48
11 Atletico Binefar Atletico 34 55 47 46
12 Peñas Sariñena Peñas 34 45 51 45
13 Zaidin CD Zaidin CD 34 54 46 44
14 Estadilla CD Estadilla 34 59 73 43
15 Belver Belver 34 51 67 41
16 La Fueva La Fueva 34 55 58 38
17 Juventud de Huesca Juventud 34 28 141 9
18 Lalueza Lalueza 34 10 127 1
TEMPORADA 2016/2017
1ª REGIONAL ARAGÓN GRUPO 2
Equipo PJ GF GC Puntos
1 AD Tardienta Tardienta 35 90 25 89
2 Biescas Biescas 36 79 32 83
3 Alcolea CF Alcolea CF 36 75 42 78
4 Monzón Atlético B Monzón 36 59 55 59
5 Peña Fragatina Peña 36 67 49 58
6 Jacetano Jacetano 36 59 48 57
7 Lanaja Lanaja 35 60 53 53
8 Gurrea Gurrea 36 70 61 52
9 Belver Belver 36 43 41 50
10 Internacional Huesca Internaciona 36 73 64 49
11 Peñas Sariñena Peñas 36 46 52 45
12 Pueyo Hinaco Pueyo Hinaco 35 54 46 44
13 Alcampell Alcampell 36 55 75 38
14 Zaidin CD Zaidin CD 36 45 67 35
15 Bujaraloz CD Bujaraloz 36 53 81 35
16 Juventud de Huesca Juventud 36 39 76 33
17 Valfonda Valfonda 36 41 66 32
18 Boltaña Boltaña 35 45 76 30
19 Graus Graus 36 37 81 25
TEMPORADA 2015/2016
1ª REGIONAL ARAGÓN GRUPO 2
Equipo PJ GF GC Puntos
1 San Lorenzo Flumen Lorenzo 34 79 24 80
2 Lalueza Lalueza 34 64 24 75
3 Peña Fragatina Peña 34 66 28 75
4 Biescas Biescas 34 49 32 59
5 Internacional Huesca Internaciona 34 67 50 57
6 Alcampell Alcampell 34 69 44 52
7 Monzón Atlético B Monzón 34 53 42 49
8 Valfonda Valfonda 34 47 52 45
9 Zaidin CD Zaidin CD 34 42 55 43
10 Peñas Sariñena Peñas 34 29 40 42
11 Juventud de Huesca Juventud 34 45 49 41
12 Graus Graus 34 46 53 40
13 Bujaraloz CD Bujaraloz 34 56 68 40
14 Pueyo Hinaco Pueyo Hinaco 34 50 74 37
15 Jacetano Jacetano 34 40 79 36
16 Ainsa Ainsa 34 31 58 33
17 Binaced Binaced 34 27 58 29
18 La Fueva La Fueva 34 41 71 28
TEMPORADA 2014/2015
2ª REGIONAL ARAGÓN GRUPO 2
Equipo PJ GF GC Puntos
1 Juventud de Huesca Juventud 28 93 20 73
2 Internacional Huesca Internaciona 28 81 37 57
3 Lanaja Lanaja 28 66 41 55
4 Gurrea Gurrea 28 66 49 50
5 Peñas Oscenses Peñas 28 64 53 47
6 Bolea Bolea 28 63 61 46
7 Ayerbe Ayerbe 28 53 42 45
8 El Temple El Temple 28 59 50 44
9 Almudevar Almudevar 28 46 50 38
10 Montesusin Montesusin 28 46 46 34
11 Alto Cinca Alto Cinca 28 34 68 25
12 San Jorge San Jorge 28 36 50 23
13 Alcala de Gurrea Alcala 28 49 89 19
14 Alto Ara Alto Ara 28 34 81 18
15 Sodeto Sodeto 28 31 84 18

  USO DE MEMORIA  
6,165,544 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0019
Controller Execution Time ( Home / Category )  0.3672
Total Execution Time  0.3691
  CADENA URL  
/historico/Sietamo
  GET DATOS  
$_GET['/historico/Sietamo']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (20)  
0.0129  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=29030 AND type_rel = 2
0.0135  SELECT SQL_NO_CACHE res.id as id, res.group_code, res.total_group, res.logo, res.alias FROM (SELECT ct.active_year, ct.id as id, l.year, l.end,l.group_code, l.total_group, ct.logo, ct.alias FROM categories AS ct INNER JOIN leagues AS l ON ct.id=l.categoryId AND ct.active_year=l.year INNER JOIN teams AS t ON l.id=t.league_id WHERE t.teamId = '29030' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0133  SELECT t.id,t.teamId,t.total_players,dt.nameShow,dt.basealias FROM teams t INNER JOIN datateams dt ON t.teamId = dt.id WHERE t.league_id = 73510 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0137  SELECT p.* FROM `rel_pictures` as rp INNER JOIN `pictures` as p ON p.id = rp.id_picture INNER JOIN fa_user u ON u.id = p.author_id WHERE rp.id_content = '29030' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0129  SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '29030' and rp.type = 4
0.0136  SELECT p.* FROM `rel_videos` as rp INNER JOIN `videos` as p ON p.id = rp.id_video INNER JOIN fa_user u ON u.id = p.author_id WHERE rp.id_content = '29030' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0139  SELECT e.action,rp.player_id, count(e.action) as total, p.nick,p.name,p.last_name,p.alias,rp.team_id 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 = 73510 WHERE rp.league_id = 73510 AND rp.teamId = 29030 AND (e.action = 1 or e.action = 2 or e.action = 11 or e.action = 12 or e.action = 13) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0136  SELECT e.action,rp.player_id, count(e.action) as total, p.nick,p.name,p.last_name,p.alias,rp.team_id 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 = 73510 WHERE rp.league_id = 73510 AND rp.teamId = 29030 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0135  SELECT e.action,rp.player_id, count(e.action) as total, p.nick,p.name,p.last_name,p.alias,rp.team_id 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 = 73510 WHERE rp.league_id = 73510 AND rp.teamId = 29030 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0128  SELECT l.id,t.league_id,l.legend,l.year,c.name,l.total_teams,c.alias,l.group_code,l.total_group,l.current_round, l.table_suffix FROM teams t INNER JOIN leagues l ON t.league_id = l.id INNER JOIN categories c ON c.id = l.categoryId WHERE c.troncal = 1 AND t.teamId = 29030 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
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 `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 = 73510 AND t.round = 30 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 = 68792 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.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 = 63838 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.0127  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 = 59794 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.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 `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 = 51300 AND t.round = 27 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 `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 = 44665 AND t.round = 34 ORDER BY team.conference 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 `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 = 39765 AND t.round = 34 ORDER BY team.conference 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 `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 = 34098 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0133  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 = 16772 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
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 `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 = 5125 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC