4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del CD Lakua Arriaga
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 7
Equipo PJ GF GC Puntos
1 Ariznabarra Ariznabarra 22 69 26 48
2 San Ignacio B Ignacio 22 37 22 42
3 Alegría Alegría 22 38 20 39
4 Abetxuko Abetxuko 22 49 37 37
5 CD Lakua Arriaga Lakua 22 43 29 36
6 Zaramaga Zaramaga 22 43 30 35
7 CD Lantarón Lantarón 22 32 40 32
8 Mercedarias KE Mercedarias 22 40 35 28
9 Vitoria B Vitoria B 22 30 39 26
10 Aranbizkarra Aranbizkarra 22 22 40 21
11 Rioja Alavesa Luzerna Rioja 22 32 55 20
12 Hauskaitz KK Hauskaitz 22 12 74 4
TEMPORADA 2020/2021
DIVISIÓN HONOR PAÍS VASCO GRUPO 1
Equipo PJ GF GC Puntos
1 Amurrio Amurrio 9 46 7 25
2 Laudio Laudio 9 14 9 20
3 Ansares Ansares 9 22 13 18
4 El Pilar Marianistas Pilar 9 20 13 18
5 CD Lakua Arriaga Lakua 9 15 13 15
6 Mercedarias KE Mercedarias 9 15 12 11
7 Zaramaga Zaramaga 9 10 23 8
8 Hauskaitz KK Hauskaitz 9 10 24 7
9 Aranbizkarra Aranbizkarra 9 8 27 4
10 San Ignacio B Ignacio 9 7 26 4
TEMPORADA 2019/2020
DIVISIÓN HONOR PAÍS VASCO GRUPO 3
Equipo PJ GF GC Puntos
1 Urgatzi KK Urgatzi KK 25 67 19 67
2 Amurrio Amurrio 25 91 24 63
3 CD Aurrera Vitoria Aurrera 25 72 23 53
4 SD Iru-Bat Santa Lucía Iru-Bat 25 63 24 53
5 Laudio Laudio 25 45 30 42
6 Mercedarias KE Mercedarias 25 41 37 36
7 San Prudencio Prudencio 25 44 43 36
8 San Viator San Viator 25 50 38 35
9 El Pilar Marianistas Pilar 25 43 48 34
10 Ansares Ansares 25 39 55 34
11 Zuia de Fútbol Zuia Fútbol 25 25 33 30
12 Salvatierra Salvatierra 25 35 42 29
13 Zaramaga Zaramaga 25 42 60 26
14 CD Lakua Arriaga Lakua 25 30 60 23
15 Vitoria B Vitoria B 25 29 63 21
16 Alegría Alegría 25 29 80 16
17 CDF Lakua CDF Lakua 25 23 54 15
18 Hauskaitz KK Hauskaitz 25 38 73 15
TEMPORADA 2011/2012
DIVISIÓN HONOR PAÍS VASCO GRUPO 2
Equipo PJ GF GC Puntos
1 CD Aurrera Vitoria Aurrera 306 255 117 255
2 Abetxuko Abetxuko 306 255 255 255
3 Amurrio Amurrio 306 255 255 255
4 Ariznabarra Ariznabarra 306 255 255 255
5 CD Lantarón Lantarón 306 255 255 255
6 CD Laudio FSR B Laudio 306 255 255 255
7 CDF Lakua CDF Lakua 306 255 255 255
8 CDF San Martín Martín 306 255 255 255
9 Club San Ignacio Club Ignacio 306 255 255 255
10 Condado De Treviño Condado 306 255 255 255
11 El Pilar Marianistas Pilar 306 255 255 255
12 Salvatierra Salvatierra 306 255 255 255
13 SD Iru-Bat Santa Lucía Iru-Bat 306 255 255 255
14 Zaramaga Zaramaga 306 255 255 255
15 Nanclares Nanclares 306 255 255 239
16 CD Campezo FR Campezo 306 255 255 200
17 CDF Gasteiz El Retorno Gasteiz 306 255 255 169
18 CD Lakua Arriaga Lakua 306 201 255 134

  USO DE MEMORIA  
5,334,024 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0012
Controller Execution Time ( Home / Category )  4.0861
Total Execution Time  4.0873
  CADENA URL  
/historico/Cd-Lakua-Arriaga-Senior
  GET DATOS  
$_GET['/historico/Cd-Lakua-Arriaga-Senior']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (19)  
0.0167  SELECT c.*, l.*, cou.name as namec, ct.table_sufix FROM (leagues l INNER JOIN categories c ON c.id = l.categoryId INNER JOIN categories_types ct ON c.ctype=ct.id LEFT JOIN country cou ON cou.Code2 = c.CountryCode) WHERE l.id = 73548
0.0017  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=9475 AND type_rel = 2
0.0017  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=74 AND type_rel = 3
0.2565  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 3 AND rel.typeId = 74 AND rel.ln = 'es' AND rel.status=1 ORDER BY rel.creation_date desc,rel.cover_points DESC LIMIT 5
0.1598  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 (1179918,760947,544162,543859,380875) ORDER BY n.cover_points DESC, update_date DESC
0.0815  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 = '9475' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0170  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 = 73548 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.1032  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=9475 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0018  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.0764  SELECT count(id) as num_players from rel_players WHERE league_id = 73548 AND teamId = 9475
0.1622  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 = 73548 AND t.round = 26 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0558  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 = 9475 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.2953  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.1991  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.1397  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 = 63863 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.0867  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 = 66306 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.0448  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 = 60093 AND t.round = 9 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.1769  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 = 57098 AND t.round = 25 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.1512  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 `tables2012` 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 = 1457 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC