4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
« Temporada Anterior
Temporada 2024
 
Regional Preferente Navarra 2024 G 1
2023/2024

Grupo 1

Regional Preferente Navarra 2024 G 1

  • Burladés B
  • Gazte Berriak
  • CF Beti Casedano
  • CD Ilumberri
  • Soto-Ibarbaso
  • CD Valle de Egüés B
  • Doneztebe
  • CD Zirauki
  • CD Aibarés
  • CDF Itaroa Huarte B
  • Mendi
  • Universidad de Navarra
  • Alsasua
  • CD Beti Onak B
  • CD Lezkairu
  • Infanzones
  • C.D. Iruntxiki
  • Aurrera De Leitza
Ver
TEMPORADA 2023/2024
Equipo PJ GF GC Puntos
1 Burladés B Burladés B 31 58 24 63
2 Gazte Berriak Gazte 31 59 33 55
3 CF Beti Casedano Beti 30 47 35 54
4 CD Ilumberri Ilumberri 30 52 29 53
5 Soto-Ibarbaso Soto-Ibarbas 31 52 36 52
6 CD Valle de Egüés B Valle 31 50 38 49
7 Doneztebe Doneztebe 30 53 37 47
8 CD Zirauki CD Zirauki 30 46 39 47
9 CD Aibarés CD Aibarés 31 52 58 46
10 CDF Itaroa Huarte B Itaroa 31 49 46 43
11 Mendi Mendi 31 35 41 42
12 Universidad de Navarra Universidad 31 39 49 41
13 Alsasua Alsasua 30 38 37 39
14 CD Beti Onak B Beti Onak 31 40 50 36
15 CD Lezkairu CD Lezkairu 31 31 42 31
16 Infanzones Infanzones 31 38 55 26
17 C.D. Iruntxiki C.D. 30 25 60 22
18 Aurrera De Leitza Aurrera 31 17 72 14
Ver
TEMPORADA 2022/2023
Equipo PJ GF GC Puntos
1 CD Amigó CD Amigó 34 61 27 75
2 Rotxapea CD Rotxapea CD 34 80 38 69
3 Universidad de Navarra Universidad 34 75 36 69
4 CD Aibarés CD Aibarés 34 67 50 69
5 CF Beti Casedano Beti 34 54 43 58
6 Soto-Ibarbaso Soto-Ibarbas 34 67 61 52
7 Burladés B Burladés B 34 60 59 49
8 CDF Itaroa Huarte B Itaroa 34 56 48 44
9 CD Valle de Egüés B Valle 34 62 61 44
10 Doneztebe Doneztebe 34 43 43 44
11 Aurrera De Leitza Aurrera 34 43 61 41
12 Alsasua Alsasua 34 39 46 40
13 CD Lezkairu CD Lezkairu 34 42 49 37
14 CD Ilumberri Ilumberri 34 37 57 34
15 CF Beriain CF Beriain 34 57 77 32
16 CD Etxarri CD Etxarri 34 45 72 32
17 CD Salesianos Salesianos 34 38 67 31
18 Lagun Artea Lagun Artea 34 45 76 26
Ver
TEMPORADA 2021/2022
Equipo PJ GF GC Puntos
1 CD Injerto CD Injerto 34 88 30 79
2 CD San Andrés Andrés 34 74 51 72
3 CD San Miguel Miguel 34 64 21 71
4 CDF Itaroa Huarte B Itaroa 34 87 58 70
5 CD Amigó CD Amigó 34 60 39 60
6 CD Aibarés CD Aibarés 34 51 46 53
7 CD Ondalán CD Ondalán 34 48 39 51
8 Rotxapea CD Rotxapea CD 34 61 50 49
9 CD Ilumberri Ilumberri 34 56 56 49
10 CD Lezkairu CD Lezkairu 34 58 52 40
11 CD Ardoi B CD Ardoi B 34 47 52 40
12 CF Beriain CF Beriain 34 52 63 40
13 CD Etxarri CD Etxarri 34 43 62 40
14 Amaya Amaya 34 47 66 33
15 CD Arenas CD Arenas 34 46 66 33
16 JD San Jorge Jorge 34 59 98 26
17 FC Bidezarra B Bidezarra 34 38 86 22
18 SD Lagunak B Lagunak 34 35 79 21

  USO DE MEMORIA  
5,469,592 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0022
Controller Execution Time ( Home / Category )  0.3965
Total Execution Time  0.3988
  CADENA URL  
/regional-preferente-navarra2024/grupo1/historico
  GET DATOS  
$_GET['/regional-preferente-navarra2024/grupo1/historico']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (16)  
0.0144  SELECT type FROM routes WHERE alias = 'regional-preferente-navarra2024'
0.0291  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'regional-preferente-navarra' AND (l.group_code = 1 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 2024 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=1 DESC LIMIT 1
0.0144  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=2519 AND type_rel = 3
0.0145  SELECT id,name,alias,stepParent FROM categories WHERE parentId=2519 ORDER BY order_id ASC
0.0145  SELECT id,year,current_round,total_teams,legend FROM leagues WHERE categoryId = 2519 AND group_code = 1 and tables = 1 AND year <= 2024 AND total_num_tablesR >= 1 ORDER BY year DESC LIMIT 22
0.0151  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 = 69360 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.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 `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 = 65896 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.0145  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-05-05 02:08:05' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0145  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=2 AND last_update > '2024-05-05 02:08:05' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0145  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=4 AND last_update > '2024-05-05 02:08:05' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0145  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=3 AND last_update > '2024-05-05 02:08:05' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0152  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'regional-preferente-navarra' AND (l.group_code = 0 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 2024 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=0 DESC LIMIT 1
0.0347  SELECT e.action, count(e.action) as total,p.name, p.last_name, p.nick,p.CountryCode,p.alias,rp.team_id,dt.nameShow,dt.short_name,dt.basealias,rp.player_id,rp.teamId 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 = 73368 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 73368 AND (e.action = 1 or e.action = 2 or e.action = 11 or e.action = 12 or e.action = 13) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0317  SELECT e.action, count(e.action) as total,p.name, p.last_name, p.nick,p.CountryCode,p.alias,rp.team_id,dt.nameShow,dt.short_name,dt.basealias,rp.player_id,rp.teamId 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 = 73368 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 73368 AND (e.action = 4 or e.action = 5) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0158  SELECT e.action, count(e.action) as total,p.name, p.last_name, p.nick,p.CountryCode,p.alias,rp.team_id,dt.nameShow,dt.short_name,dt.basealias,rp.player_id,rp.teamId 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 = 73368 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 73368 AND (e.action = 3 or e.action = 4) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0156  SELECT *,(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 = 73368 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