4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del CD Alipendi
TEMPORADA 2023/2024
DIVISIÓN HONOR PAÍS VASCO GRUPO 1
Equipo PJ GF GC Puntos
1 San Viator San Viator 26 68 21 59
2 CD Aurrera Vitoria Aurrera 26 77 31 58
3 San Prudencio Prudencio 26 56 29 55
4 Ariznabarra Ariznabarra 26 68 34 53
5 SD Iru-Bat Santa Lucía Iru-Bat 26 50 37 42
6 Amurrio Amurrio 26 48 36 39
7 Laudio Laudio 26 46 36 38
8 Mercedarias KE Mercedarias 26 45 40 38
9 CD Lakua Arriaga Lakua 26 46 40 34
10 San Ignacio B Ignacio 26 34 37 31
11 Urgatzi KK Urgatzi KK 26 31 44 29
12 CDF San Martín Martín 26 51 65 27
13 El Pilar Marianistas Pilar 26 42 74 26
14 Abetxuko Abetxuko 26 38 71 24
15 Zuia de Fútbol Zuia Fútbol 26 20 55 22
16 CD Alipendi CD Alipendi 26 19 89 6
TEMPORADA 2022/2023
DIVISIÓN HONOR PAÍS VASCO GRUPO 1
Equipo PJ GF GC Puntos
1 Deportivo Alavés C Deportivo 34 103 24 82
2 San Viator San Viator 34 74 26 77
3 Laudio Laudio 34 73 31 76
4 Ariznabarra Ariznabarra 34 69 39 65
5 Urgatzi KK Urgatzi KK 34 60 52 58
6 SD Iru-Bat Santa Lucía Iru-Bat 34 86 59 53
7 Amurrio Amurrio 34 50 46 50
8 San Prudencio Prudencio 34 53 48 44
9 Abetxuko Abetxuko 34 62 85 43
10 El Pilar Marianistas Pilar 34 60 64 43
11 Zuia de Fútbol Zuia Fútbol 34 47 56 42
12 CD Alipendi CD Alipendi 34 35 70 39
13 San Ignacio B Ignacio 34 49 56 39
14 CD Lakua Arriaga Lakua 34 55 70 39
15 Alegría Alegría 34 44 56 38
16 Salvatierra Salvatierra 34 38 67 32
17 Nanclares Nanclares 34 42 62 27
18 Zaramaga Zaramaga 34 19 108 7
TEMPORADA 2021/2022
DIVISIÓN HONOR PAÍS VASCO GRUPO 6
Equipo PJ GF GC Puntos
1 CD Aurrera Vitoria Aurrera 22 80 11 59
2 San Viator San Viator 22 72 21 57
3 Urgatzi KK Urgatzi KK 22 40 25 43
4 Zuia de Fútbol Zuia Fútbol 22 43 30 38
5 El Pilar Marianistas Pilar 22 37 52 31
6 SD Iru-Bat Santa Lucía Iru-Bat 22 37 40 30
7 Ansares Ansares 22 27 31 27
8 Laudio Laudio 22 40 52 24
9 San Prudencio Prudencio 22 28 40 24
10 Nanclares Nanclares 22 28 43 21
11 Salvatierra Salvatierra 22 15 47 10
12 CD Alipendi CD Alipendi 22 17 72 7
TEMPORADA 2015/2016
REGIONAL PREFERENTE ÁLAVA
Equipo PJ GF GC Puntos
1 Amurrio Amurrio 34 76 18 81
2 El Pilar Marianistas Pilar 34 61 29 74
3 SD Iru-Bat Santa Lucía Iru-Bat 34 75 32 72
4 Ariznabarra Ariznabarra 34 70 34 68
5 Salvatierra Salvatierra 34 77 33 67
6 Laudio Laudio 34 68 33 61
7 San Ignacio San Ignacio 34 61 38 59
8 Zaramaga Zaramaga 34 52 41 51
9 CDF San Martín Martín 34 49 46 45
10 San Prudencio Prudencio 34 47 49 42
11 Zuia de Fútbol Zuia Fútbol 34 42 53 40
12 Condado De Treviño Condado 34 57 72 40
13 Abetxuko Abetxuko 34 39 61 38
14 Vitoria B Vitoria B 34 57 86 37
15 Rioja Alavesa Luzerna Rioja 34 45 71 36
16 Aranbizkarra Aranbizkarra 34 31 74 19
17 CD Alipendi CD Alipendi 34 31 82 15
18 Vulcano Vulcano 34 35 121 13
TEMPORADA 2014/2015
REGIONAL PREFERENTE ÁLAVA
Equipo PJ GF GC Puntos
1 CD Vitoria CD Vitoria 34 74 25 78
2 CD Elgorriaga Elgorriaga 34 81 25 74
3 SD Iru-Bat Santa Lucía Iru-Bat 34 67 30 71
4 CDF San Martín Martín 34 67 44 67
5 Salvatierra Salvatierra 34 66 29 64
6 Laudio Laudio 34 61 23 63
7 San Ignacio San Ignacio 34 61 39 62
8 Ariznabarra Ariznabarra 34 51 41 55
9 Zaramaga Zaramaga 34 38 39 42
10 El Pilar Marianistas Pilar 34 38 42 38
11 Vitoria B Vitoria B 34 50 81 38
12 Abetxuko Abetxuko 34 45 68 37
13 San Prudencio Prudencio 34 32 49 34
14 Zuia de Fútbol Zuia Fútbol 34 32 59 34
15 CD Alipendi CD Alipendi 34 35 74 29
16 Condado De Treviño Condado 34 51 77 27
17 CD Lantarón Lantarón 34 32 84 20
18 Nanclares Nanclares 34 28 80 15
TEMPORADA 2013/2014
DIVISIÓN HONOR PAÍS VASCO GRUPO 2
Equipo PJ GF GC Puntos
1 CD Aurrera Vitoria Aurrera 34 96 25 82
2 Club San Ignacio Club Ignacio 34 90 25 81
3 Salvatierra Salvatierra 34 78 25 77
4 CDF San Martín Martín 34 76 37 73
5 CD Vitoria CD Vitoria 34 69 38 67
6 Ariznabarra Ariznabarra 34 66 40 63
7 Nanclares Nanclares 34 68 59 56
8 SD Iru-Bat Santa Lucía Iru-Bat 34 65 39 52
9 El Pilar Marianistas Pilar 34 65 62 52
10 CD Lantarón Lantarón 34 37 62 37
11 CD Alipendi CD Alipendi 34 44 63 36
12 Zaramaga Zaramaga 34 44 59 34
13 San Prudencio Prudencio 34 47 69 32
14 CD Laudio FSR B Laudio 34 45 63 32
15 Vitoria B Vitoria B 34 41 77 32
16 Abetxuko Abetxuko 34 23 64 29
17 CDF Gasteiz El Retorno Gasteiz 34 36 116 14
18 Rioja Alavesa Luzerna Rioja 34 32 99 12

  USO DE MEMORIA  
5,415,784 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0019
Controller Execution Time ( Home / Category )  0.3385
Total Execution Time  0.3404
  CADENA URL  
/historico/C-D-Alipendi
  GET DATOS  
$_GET['/historico/C-D-Alipendi']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (18)  
0.0139  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 = 'C-D-Alipendi' 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.0126  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=13872 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0125  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=13872 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0124  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=13872 AND type_rel = 2
0.0129  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 = '13872' ORDER BY l.year DESC,cat.coefficient DESC
0.0130  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 = '13872' AND l.year = 2024 ORDER BY l.year DESC,cat.coefficient DESC
0.0131  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 = '13872' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0130  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=13872 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0132  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 (73548) 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.0129  SELECT count(id) as num_players from rel_players WHERE league_id = 73548 AND teamId = 13872
0.0140  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 = 13872 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.0146  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 = 73548 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.0146  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 = 68808 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.0128  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 = 63864 AND t.round = 11 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 `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 = 66305 AND t.round = 22 ORDER BY team.conference ASC,t.position 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 = 16780 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0143  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 = 4338 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 `tables2014` 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 = 2736 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC