4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del CD Cabanillas
TEMPORADA 2023/2024
REGIONAL PREFERENTE NAVARRA GRUPO 2
Equipo PJ GF GC Puntos
1 CD San Adrian Adrian 30 68 26 69
2 Lourdes Lourdes 30 67 32 64
3 Milagres Milagres 31 77 34 59
4 Zarramonza Zarramonza 30 58 34 58
5 Cd Larrate Cd Larrate 30 59 33 53
6 River Ega River Ega 30 59 57 47
7 CD Cabanillas Cabanillas 30 60 52 46
8 CA Huracán CA Huracán 31 67 58 46
9 CD Cadreita CD Cadreita 30 46 51 43
10 Valtierrano Valtierrano 30 43 55 42
11 CD San Andrés Andrés 31 46 45 42
12 CD Muskaria CD Muskaria 31 43 44 41
13 CD Funes CD Funes 30 41 62 38
14 Lodosa Lodosa 31 38 54 35
15 CA Cirbonero B Cirbonero 30 43 61 30
16 CD Sesma CD Sesma 31 40 51 27
17 Ribaforada Ribaforada 30 30 63 23
18 CD Calatrava Calatrava 30 13 86 4
TEMPORADA 2022/2023
REGIONAL PREFERENTE NAVARRA GRUPO 2
Equipo PJ GF GC Puntos
1 CD Ondalán CD Ondalán 32 76 30 78
2 CD Zirauki CD Zirauki 32 88 36 68
3 Aluvión Aluvión 32 75 48 60
4 CD San Andrés Andrés 32 55 44 53
5 Milagres Milagres 32 52 48 51
6 CA Cirbonero B Cirbonero 32 52 47 49
7 CD Sesma CD Sesma 32 56 52 48
8 CD Muskaria CD Muskaria 32 46 43 45
9 CD Cabanillas Cabanillas 32 60 62 41
10 CD Funes CD Funes 32 57 62 41
11 CD Cadreita CD Cadreita 32 68 67 40
12 Cd Larrate Cd Larrate 32 46 55 40
13 Lodosa Lodosa 32 56 72 40
14 CD Falcesino Falcesino 32 62 58 35
15 CD Buñuel CD Buñuel 32 41 62 35
16 CD Mendavies Mendavies 32 44 73 28
17 CD Fontellas Fontellas 32 26 101 8
TEMPORADA 2021/2022
REGIONAL PREFERENTE NAVARRA GRUPO 2
Equipo PJ GF GC Puntos
1 CD San Adrian Adrian 32 94 31 77
2 Valtierrano Valtierrano 32 64 36 61
3 Lodosa Lodosa 32 66 29 59
4 Cd Larrate Cd Larrate 32 69 46 57
5 CD Buñuel CD Buñuel 32 58 44 50
6 CD Sesma CD Sesma 32 59 56 50
7 CD Falcesino Falcesino 32 62 61 49
8 CD Funes CD Funes 32 48 42 47
9 CA Cirbonero B Cirbonero 32 63 59 47
10 CD Cadreita CD Cadreita 32 51 58 47
11 CD Cabanillas Cabanillas 32 52 54 44
12 CD Mendavies Mendavies 32 40 55 44
13 CA Marcilla Aurora Marcilla 32 43 60 37
14 CD La Peña CD La Peña 32 43 60 34
15 CA Santacara Santacara 32 35 62 27
16 CD Ablitense Ablitense 32 36 76 22
17 CD Azkarrena Azkarrena 32 33 87 14
TEMPORADA 2016/2017
AUTONÓMICA NAVARRA
Equipo PJ GF GC Puntos
1 Beti Kozkor Beti Kozkor 34 55 37 70
2 Gares Gares 34 49 28 60
3 Peña Azagresa Peña 34 68 46 59
4 Baztan Baztan 34 56 38 57
5 Avance Ezcabarte Avance 34 39 38 53
6 Aoiz Aoiz 34 53 61 51
7 Beti Onak Beti Onak 34 52 54 47
8 CD Ilumberri Ilumberri 34 55 47 46
9 AD San Juan B Juan 34 52 50 46
10 Aluvión Aluvión 34 47 46 46
11 CD Ablitense Ablitense 34 44 50 46
12 CD Alesves CD Alesves 34 55 53 45
13 Mendi Mendi 34 45 44 43
14 CD Zirauki CD Zirauki 34 43 62 42
15 Infanzones Infanzones 34 62 60 41
16 Azkoyen Azkoyen 34 32 46 36
17 Lagunak Lagunak 34 39 57 36
18 CD Cabanillas Cabanillas 34 30 59 27
TEMPORADA 2012/2013
AUTONÓMICA NAVARRA GRUPO 2
Equipo PJ GF GC Puntos
1 Corellano Corellano 30 62 22 64
2 Cd Azkoyen Cd Azkoyen 30 51 24 63
3 Cd Larrate Cd Larrate 30 55 39 51
4 Lourdes Lourdes 30 44 30 51
5 CD Tudela 1999 Tudela 1999 30 61 40 49
6 CD Ondalán CD Ondalán 30 45 40 45
7 Aluvión Aluvión 30 41 50 44
8 Cd River Ega River 30 34 35 42
9 Cd Fútbol Peña Fútbol 30 45 45 41
10 Cd Buñuel Cd Buñuel 30 45 46 40
11 Zarramonza Zarramonza 30 32 34 39
12 CF Beti Casedano Beti 30 53 57 38
13 CD Cabanillas Cabanillas 30 36 41 37
14 CD Azkarrena Azkarrena 30 38 59 29
15 CA Cirbonero B Cirbonero 30 39 73 19
16 Cd Lerinés Cd Lerinés 30 33 79 17

  USO DE MEMORIA  
5,449,144 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0012
Controller Execution Time ( Home / Category )  0.0913
Total Execution Time  0.0926
  CADENA URL  
/historico/Cd-Cabanillas-Senior
  GET DATOS  
$_GET['/historico/Cd-Cabanillas-Senior']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (25)  
0.0026  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 = 'Cd-Cabanillas-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.0018  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=10597 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0018  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=10597 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0043  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 = 73369
0.0019  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=10597 AND type_rel = 2
0.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=2519 AND type_rel = 3
0.0021  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 = '10597' ORDER BY l.year DESC,cat.coefficient DESC
0.0022  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 = '10597' AND l.year = 2024 ORDER BY l.year DESC,cat.coefficient DESC
0.0020  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 = '10597' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0021  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 = 73369 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0020  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=10597 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 (73369) 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.0020  SELECT count(id) as num_players from rel_players WHERE league_id = 73369 AND teamId = 10597
0.0020  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 = '10597' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0018  SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '10597' and rp.type = 4
0.0020  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 = '10597' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0030  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 = 73369 WHERE rp.league_id = 73369 AND rp.teamId = 10597 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.0027  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 = 73369 WHERE rp.league_id = 73369 AND rp.teamId = 10597 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0025  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 = 73369 WHERE rp.league_id = 73369 AND rp.teamId = 10597 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0022  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 = 10597 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.0023  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 = 73369 AND t.round = 31 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0025  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 = 69361 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.0026  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 = 65897 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.0029  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 = 34178 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0029  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 = 2078 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC