4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del Athlàtic Huialfàs
TEMPORADA 2023/2024
1ª REGIONAL BALEARES GRUPO 1
Equipo PJ GF GC Puntos
1 La Unión CF Unión 24 60 28 52
2 S´Horta S´Horta 23 48 27 45
3 Atlètic Sencelles Atlètic 23 60 53 40
4 Porto Cristo Porto Cristo 24 53 35 39
5 Arta Arta 24 34 25 36
6 CF Pollença Pollença 24 47 39 36
7 Baleares Sin Fronteras Baleares 24 44 37 35
8 Ce Campanet Ce Campanet 24 37 46 34
9 CD Binissalem B Binissalem 23 28 29 33
10 CD Génova CD Génova 24 36 39 29
11 CE Escolar CE Escolar 23 26 39 28
12 S'arraco S'arraco 24 25 51 26
13 Vilafranca Vilafranca 23 32 35 24
14 Col. San Pedro Col. Pedro 24 33 46 24
15 Athlàtic Huialfàs Athlàtic 23 33 52 20
16 Sporting Sant Marçal Sporting 24 39 54 16
TEMPORADA 2022/2023
1ª REGIONAL BALEARES GRUPO 2
Equipo PJ GF GC Puntos
1 Santa Mónica Santa 30 73 20 77
2 Andratx B Andratx B 30 78 28 67
3 Athetic Club Montuiri Athetic Club 30 59 40 54
4 CE Escolar CE Escolar 30 63 43 53
5 Consell Consell 30 54 34 52
6 La Unión CF Unión 30 57 41 52
7 Unió Esportiva Sta Maria Unió 30 50 39 43
8 Athlàtic Huialfàs Athlàtic 30 50 46 42
9 Baleares Sin Fronteras Baleares 30 49 41 40
10 Margaritense AtlÈtic Margaritense 30 52 56 37
11 Port de Soller Port Soller 30 35 46 36
12 Juv Can Picafort Picafort 30 41 58 36
13 Pilares La Soledad Pilares 30 43 64 31
14 CD Binissalem B Binissalem 30 36 73 28
15 San Roque San Roque 30 37 65 18
16 Taujá Taujá 30 18 101 3
TEMPORADA 2021/2022
1ª REGIONAL BALEARES
Equipo PJ GF GC Puntos
1 Algaida Algaida 38 89 33 80
2 UD Arenal UD Arenal 38 63 24 76
3 S´Horta S´Horta 37 80 41 72
4 Portol Portol 38 75 35 69
5 Atletico Rafal Atletico 37 55 34 65
6 Indep. Camp Redó Indep. Camp 38 86 52 62
7 Espanya Espanya 38 54 39 62
8 Cala Millor Cala Millor 38 72 56 61
9 CF Pollença Pollença 38 64 70 58
10 La Unión CF Unión 38 56 48 54
11 Platges de Calvià B Platges 38 65 70 51
12 Athlàtic Huialfàs Athlàtic 38 60 68 50
13 Montaura Montaura 38 54 69 49
14 UEF Santa María Santa María 38 39 57 45
15 Ce Campanet Ce Campanet 38 55 74 45
16 CE Escolar CE Escolar 38 42 68 40
17 A-Llubi A-Llubi 38 44 74 37
18 Constancia B Constancia 38 48 89 33
19 Juv Can Picafort Picafort 38 36 77 28
20 Porto Cristo Porto Cristo 38 39 98 24
TEMPORADA 2020/2021
2ª REGIONAL BALEARES GRUPO 2
Equipo PJ GF GC Puntos
1 Juv Can Picafort Picafort 18 49 19 39
2 Athlàtic Huialfàs Athlàtic 18 47 25 37
3 Porto Cristo Porto Cristo 18 34 24 31
4 Portol Portol 18 43 24 30
5 Santa Ponsa Santa Ponsa 18 36 32 27
6 Athetic Club Montuiri Athetic Club 18 29 29 24
7 Pilares La Soledad Pilares 18 34 41 20
8 UE Lloret UE Lloret 18 33 47 18
9 Cala D'or Cala D'or 18 24 35 17
10 Collerense B Collerense 18 27 80 9
TEMPORADA 2019/2020
3ª REGIONAL BALEARES GRUPO 2
Equipo PJ GF GC Puntos
1 Athlàtic Huialfàs Athlàtic 22 80 16 60
2 Murense B Murense B 22 71 34 51
3 Cala D'or Cala D'or 21 59 25 48
4 Deportivo Marratxi Deportivo 23 57 38 45
5 Santanyi del Atb B Santanyi 24 58 40 44
6 San Roque B San Roque B 24 73 53 43
7 Santa Ponsa B Santa Ponsa 23 53 35 40
8 Independiente C/r B Independient 25 65 59 38
9 Son Sardina B Sardina 24 58 68 34
10 Esporles B Esporles B 22 62 42 31
11 Alaró B Alaró B 21 33 28 27
12 Palmanyola Palmanyola 24 52 65 25
13 La Union B La Union B 23 44 66 23
14 Atlético de Paguera Atlético 24 34 61 23
15 Son Ferrer del PC Ferrer 22 36 65 23
16 Llucmajor B Llucmajor B 24 40 63 15
17 Rtvº Puigpunyent i Galilea Rtvº 22 40 64 14
18 Son Ferrer B Ferrer 24 29 122 4
TEMPORADA 2018/2019
3ª REGIONAL BALEARES GRUPO 2
Equipo PJ GF GC Puntos
1 Collerense B Collerense 30 109 44 72
2 Bunyola Bunyola 30 95 35 70
3 San Cayetano Cayetano 30 88 61 65
4 Taujá Taujá 30 66 38 63
5 Sp. Son Ferrer A Ferrer 30 70 32 62
6 Athlàtic Huialfàs Athlàtic 30 60 44 47
7 Deportivo Marratxi Deportivo 30 67 68 45
8 Esporles B Esporles B 30 74 65 44
9 Son Maciá Son Maciá 29 56 55 38
10 La Real de Lu Real 31 65 91 37
11 Montaura B Montaura B 31 57 84 30
12 Santanyi del Atb B Santanyi 29 44 51 28
13 Rotlet Molinar B Rotlet 30 50 75 24
14 Santa Maria del Uesm Santa Maria 29 41 81 22
15 San Roque San Roque 30 49 99 19
16 Sant Marcal B Sant Marcal 29 31 99 11

  USO DE MEMORIA  
5,466,432 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0017
Controller Execution Time ( Home / Category )  0.4773
Total Execution Time  0.4790
  CADENA URL  
/historico/Athletic-Huialfas-Senior
  GET DATOS  
$_GET['/historico/Athletic-Huialfas-Senior']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (23)  
0.0160  SELECT dt.*,c.active_year,l.year,l.table_suffix, c.ctype, l.id as league_id,t.id as id,t.manager,t.name as nameOriginal,dt.id as teamId,cou.Name as cou_name,cou.Continent,cou.Region FROM `leagues_webci` as l INNER JOIN `teams` as t ON l.id = t.league_id INNER JOIN `datateams` as dt ON dt.id = t.teamId INNER JOIN `categories_webci` as c ON c.id = l.categoryId LEFT JOIN country cou ON LOWER(cou.Code2) = dt.CountryCode WHERE dt.basealias = 'Athletic-Huialfas-Senior' AND l.year = 2024 ORDER BY c.top DESC, c.ctype != 12 DESC, c.troncal DESC, l.end_date >= NOW() DESC, l.start_date <= NOW() DESC, l.year DESC, c.coefficient DESC, l.id ASC
0.0145  SELECT dp.nick, dp.fullname,rp.date_ini, rp.date_end FROM futbol.rel_people rp INNER JOIN futbol.datapeople dp on dp.id=rp.people_id WHERE rp.teamId=112207 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0147  SELECT dp.nick, dp.fullname,rp.date_ini, rp.date_end FROM futbol.rel_people rp INNER JOIN futbol.datapeople dp on dp.id=rp.people_id WHERE rp.teamId=112207 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0146  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=112207 AND type_rel = 2
0.0158  SELECT cat.logo,cat.official,cat.location,dt.nameShow,dt.basealias,t.teamId,l.year,t.qod,cat.coefficient,cat.active_year,cat.name,l.group_code,l.total_group,cat.alias,l.categoryId,l.year,l.id as league_id FROM datateams dt INNER JOIN teams t ON t.teamId = dt.id INNER JOIN leagues l ON l.id = t.league_id INNER JOIN categories cat ON cat.id = l.categoryId WHERE dt.id = '112207' AND l.year = 2024 ORDER BY l.year DESC,cat.coefficient DESC
0.0157  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 = '112207' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0155  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 = 73782 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0158  SELECT t.id as team_id, ct.id, l.id as idLeague, l.year, ct.name, l.start_date, l.end_date FROM categories AS ct INNER JOIN leagues AS l ON ct.id=l.categoryId INNER JOIN teams AS t ON l.id=t.league_id WHERE t.teamId=112207 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0150  SELECT ct.id, ct.alias, ct.name AS name, ct.active_year, ct.coefficient AS coefficient, l.id AS league_id, l.year, l.total_group FROM categories AS ct INNER JOIN leagues AS l ON ct.id=l.categoryId WHERE l.id IN (73782) ORDER BY ct.ctype != 12 DESC, ct.troncal DESC, ct.coefficient DESC, l.end_date >= NOW() DESC, l.start_date <= NOW() DESC, l.year DESC, ct.coefficient DESC, l.group_code ASC
0.0151  SELECT count(id) as num_players from rel_players WHERE league_id = 73782 AND teamId = 112207
0.0163  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff 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 = 73782 AND t.round = 30 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0151  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 = '112207' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0154  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 = '112207' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0186  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 = 73782 WHERE rp.league_id = 73782 AND rp.teamId = 112207 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.0201  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 = 73782 WHERE rp.league_id = 73782 AND rp.teamId = 112207 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0179  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 = 73782 WHERE rp.league_id = 73782 AND rp.teamId = 112207 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0162  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 = 112207 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.0166  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 = 69164 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.0169  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 = 63635 AND t.round = 38 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0159  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 = 59033 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.0162  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 = 51504 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.0164  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 = 44637 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 dt.nameShow, dt.basealias, t.id, dt.id as dt_id FROM `teams` as t INNER JOIN `datateams` as dt ON dt.id = t.teamId WHERE league_id = 73782 ORDER BY nameShow LIMIT 100