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

  USO DE MEMORIA  
5,840,352 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0012
Controller Execution Time ( Home / Category )  0.4916
Total Execution Time  0.4928
  CADENA URL  
/historico/Zuia
  GET DATOS  
$_GET['/historico/Zuia']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (29)  
0.0134  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 = 'Zuia' 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.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=3927 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=3927 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0253  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.0125  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=3927 AND type_rel = 2
0.0127  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 = '3927' ORDER BY l.year DESC,cat.coefficient DESC
0.0127  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 = '3927' AND l.year = 2024 ORDER BY l.year DESC,cat.coefficient DESC
0.0142  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 = '3927' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0137  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.0136  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=3927 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0126  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.0126  SELECT count(id) as num_players from rel_players WHERE league_id = 73548 AND teamId = 3927
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 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 = 27 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0127  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 = '3927' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0125  SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '3927' and rp.type = 4
0.0127  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 = '3927' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0127  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 = 73548 WHERE rp.league_id = 73548 AND rp.teamId = 3927 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.0126  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 = 73548 WHERE rp.league_id = 73548 AND rp.teamId = 3927 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0130  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 = 73548 WHERE rp.league_id = 73548 AND rp.teamId = 3927 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 = 3927 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 = 73548 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.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 `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.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 = 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.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 = 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.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 `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.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 `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 = 35872 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0147  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.0144  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 `tables2013` 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 = 1981 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC