4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del Uritarra CD
TEMPORADA 2023/2024
DIVISIÓN HONOR PAÍS VASCO GRUPO 2
Equipo PJ GF GC Puntos
1 Santurtzi Santurtzi 29 53 27 62
2 Sodupe Sodupe 29 36 33 50
3 Zalla Zalla 29 34 21 50
4 SD Zamudio SD Zamudio 29 40 31 48
5 Club Bermeo Club Bermeo 28 27 21 46
6 Santutxu Santutxu 29 45 30 42
7 Galdakao Galdakao 29 31 31 41
8 CD Getxo CD Getxo 29 26 24 39
9 SD Erandio SD Erandio 29 37 36 38
10 SD San Pedro Pedro 30 44 48 37
11 Uritarra CD Uritarra CD 29 28 25 36
12 Dínamo San Juan Dínamo Juan 29 45 45 35
13 JD Somorrostro Somorrostro 30 37 46 34
14 Iurretako KT Iurretako 29 31 44 33
15 Balmaseda FC Balmaseda 29 29 34 30
16 Arratia CD Arratia CD 29 22 34 29
17 SD Iturrigorri Iturrigorri 29 25 47 28
18 SD Indautxu SD Indautxu 28 25 38 26
TEMPORADA 2022/2023
DIVISIÓN HONOR PAÍS VASCO GRUPO 2
Equipo PJ GF GC Puntos
1 CD Derio CD Derio 38 63 29 79
2 Santurtzi Santurtzi 38 79 40 74
3 SD Erandio SD Erandio 38 54 37 63
4 JD Somorrostro Somorrostro 38 60 50 63
5 Uritarra CD Uritarra CD 38 55 47 61
6 Club Bermeo Club Bermeo 38 39 25 60
7 SD San Pedro Pedro 38 59 55 58
8 Santutxu Santutxu 38 49 32 56
9 Zalla Zalla 38 59 47 55
10 SD Zamudio SD Zamudio 38 49 48 54
11 Balmaseda FC Balmaseda 38 45 44 52
12 Sodupe Sodupe 38 63 60 51
13 SD Indautxu SD Indautxu 38 43 47 50
14 Dínamo San Juan Dínamo Juan 38 50 55 47
15 Galdakao Galdakao 38 48 65 44
16 CD Getxo CD Getxo 38 47 41 43
17 Iurretako KT Iurretako 38 39 47 42
18 Abanto Club Abanto Club 38 43 70 41
19 Abadiño KE Abadiño KE 38 36 67 30
20 CD Elorrio CD Elorrio 38 31 105 10
TEMPORADA 2021/2022
TERCERA FEDERACIÓN GRUPO 4
Equipo PJ GF GC Puntos
1 Deportivo Alavés B Deportivo 38 72 31 76
2 Beasain KE Beasain KE 38 65 36 70
3 Portugalete Portugalete 38 60 33 70
4 Barakaldo Barakaldo 38 64 46 69
5 CD Basconia CD Basconia 38 45 32 65
6 CD Vitoria CD Vitoria 38 55 49 59
7 San Ignacio San Ignacio 38 57 48 58
8 SCD Durango SCD Durango 38 42 29 57
9 Leioa Leioa 38 55 38 56
10 Anaitasuna FT Anaitasuna 38 48 49 52
11 CD Lagun Onak Lagun Onak 38 42 44 51
12 Pasaia KE Pasaia KE 38 36 43 50
13 Deusto Deusto 38 42 40 49
14 Urduliz FT Urduliz FT 38 39 57 45
15 Aurrera KE Aurrera KE 38 36 55 38
16 Santutxu Santutxu 38 42 60 38
17 Uritarra CD Uritarra CD 38 38 52 38
18 Amurrio Amurrio 38 39 45 37
19 Beti Gazte KKE Beti Gazte 38 34 80 26
20 Tolosa CF Tolosa CF 38 43 87 26
TEMPORADA 2020/2021
DIVISIÓN HONOR PAÍS VASCO GRUPO 3
Equipo PJ GF GC Puntos
1 Uritarra CD Uritarra CD 19 33 14 42
2 SD Zamudio SD Zamudio 19 33 14 40
3 Galdakao Galdakao 19 33 19 36
4 Dínamo San Juan Dínamo Juan 19 24 14 35
5 Club Bermeo Club Bermeo 19 33 21 34
6 SD Erandio SD Erandio 19 29 21 31
7 SD Indautxu SD Indautxu 19 19 17 31
8 CD Getxo CD Getxo 19 32 19 29
9 Iurretako KT Iurretako 19 19 18 26
10 CD Elorrio CD Elorrio 19 20 21 24
11 CD Derio CD Derio 19 23 29 24
12 CD Padura CD Padura 19 18 23 23
13 Cd Sondika Cd Sondika 19 24 30 23
14 SD San Pedro Pedro 19 16 20 22
15 Abanto Club Abanto Club 19 22 26 20
16 Gatika KT Gatika KT 19 13 28 20
17 SD Basurto SD Basurto 19 17 33 19
18 Otxarkoaga Otxarkoaga 19 18 27 18
19 Gernika B Gernika B 19 14 33 17
20 Abadiño KE Abadiño KE 19 13 26 14
TEMPORADA 2019/2020
DIVISIÓN HONOR PAÍS VASCO GRUPO 1
Equipo PJ GF GC Puntos
1 Aurrera KE Aurrera KE 24 35 18 46
2 CD Elorrio CD Elorrio 24 29 13 45
3 CD Getxo CD Getxo 24 38 22 44
4 Gernika B Gernika B 24 37 28 41
5 SD San Pedro Pedro 24 34 28 39
6 SD Zamudio SD Zamudio 24 33 34 36
7 Gatika KT Gatika KT 24 21 22 36
8 Uritarra CD Uritarra CD 24 32 23 34
9 CD Padura CD Padura 24 30 23 33
10 CD Derio CD Derio 24 26 30 33
11 Abanto Club Abanto Club 24 35 33 30
12 Club Bermeo Club Bermeo 24 22 27 30
13 Iurretako KT Iurretako 24 29 25 29
14 Dínamo San Juan Dínamo Juan 24 18 27 26
15 SD Indautxu SD Indautxu 24 28 36 24
16 SD Erandio SD Erandio 24 24 36 24
17 Galdakao Galdakao 24 20 38 24
18 Cd Sondika Cd Sondika 24 19 47 14
TEMPORADA 2014/2015
REGIONAL PREFERENTE VIZCAYA
Equipo PJ GF GC Puntos
1 Arratia CD Arratia CD 34 57 33 65
2 Lekeitio FT Lekeitio FT 34 59 36 65
3 Trapagaran CF Trapagaran 34 46 36 61
4 SD San Pedro Pedro 34 58 32 57
5 CD Galea CD Galea 34 54 32 55
6 Uritarra CD Uritarra CD 34 41 22 53
7 Baskonia B Baskonia B 34 48 32 53
8 San Ignacio SD Ignacio 34 56 51 47
9 Ugeraga Ugeraga 34 46 40 46
10 SD Moraza SD Moraza 34 45 45 46
11 Abadiño KE Abadiño KE 34 44 50 45
12 Zaldua KE Zaldua KE 34 44 67 41
13 Begoña SD Begoña SD 34 40 51 40
14 Acero Club Acero Club 34 32 46 39
15 Larramendi CD Larramendi 34 41 64 38
16 Ermua CD Ermua CD 34 50 68 31
17 Aranguren CF Aranguren 34 49 69 29
18 Ortuella Ortuella 34 30 66 28

  USO DE MEMORIA  
5,512,312 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0012
Controller Execution Time ( Home / Category )  0.4849
Total Execution Time  0.4862
  CADENA URL  
/historico/Uritarra-Cd
  GET DATOS  
$_GET['/historico/Uritarra-Cd']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (25)  
0.0156  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 = 'Uritarra-Cd' 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=19952 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
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=19952 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0145  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=19952 AND type_rel = 2
0.0148  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 = '19952' ORDER BY l.year DESC,cat.coefficient DESC
0.0147  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 = '19952' AND l.year = 2024 ORDER BY l.year DESC,cat.coefficient DESC
0.0147  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 = '19952' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0148  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 = 73549 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0147  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=19952 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0145  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 (73549) 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.0145  SELECT count(id) as num_players from rel_players WHERE league_id = 73549 AND teamId = 19952
0.0150  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 = 73549 AND t.round = 32 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0146  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 = '19952' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0145  SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '19952' and rp.type = 4
0.0146  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 = '19952' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0147  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 = 73549 WHERE rp.league_id = 73549 AND rp.teamId = 19952 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.0145  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 = 73549 WHERE rp.league_id = 73549 AND rp.teamId = 19952 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0146  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 = 73549 WHERE rp.league_id = 73549 AND rp.teamId = 19952 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0147  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 = 19952 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.0150  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 = 73549 AND t.round = 32 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0154  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 = 68809 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.0158  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 = 62388 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.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 `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 = 60094 AND t.round = 19 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
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,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 = 51264 AND t.round = 24 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
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 `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 = 4334 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC