4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
« Temporada Anterior
Temporada 2021
 
Tercera División 2021 G 15
2020/2021

XV - Navarra

Tercera División 2021 G 15

  • AD San Juan
  • Beti Kozkor
  • CD Valle de Egüés
  • CD Itaroa Huarte
  • CD Pamplona
  • Burladés
  • Beti Onak
  • Corellano
  • Txantrea
  • Subiza
  • River Ega
  • Peña Sport
  • Cirbonero
  • CF Ardoi
  • Cantolagua
  • CD Cortes
  • Murchante
  • Peña Azagresa
  • Baztan
  • CD Fontellas
  • Lourdes
  • FC Bidezarra
  • Tercera División:

Clasificación

Equipo PJ GF GC Puntos
1 AD San Juan AD San Juan 20 21 9 35
2 Beti Kozkor Beti Kozkor 20 23 18 33
3 CD Valle de Egüés Valle 20 31 23 32
4 CD Itaroa Huarte Itaroa 20 29 23 30
5 CD Pamplona CD Pamplona 20 28 18 30
6 Burladés Burladés 20 22 30 26
7 Beti Onak Beti Onak 20 26 25 24
8 Corellano Corellano 20 24 29 24
9 Txantrea Txantrea 20 23 29 23
10 Subiza Subiza 20 25 28 21
11 River Ega River Ega 20 23 43 14
12 Peña Sport Peña Sport 20 32 14 47
13 Cirbonero Cirbonero 20 35 21 32
14 CF Ardoi CF Ardoi 20 26 15 32
15 Cantolagua Cantolagua 20 28 19 31
16 CD Cortes CD Cortes 20 18 21 28
17 Murchante Murchante 20 19 19 24
18 Peña Azagresa Peña 20 24 33 24
19 Baztan Baztan 20 19 27 20
20 CD Fontellas Fontellas 20 18 37 20
21 Lourdes Lourdes 20 18 26 19
22 FC Bidezarra Bidezarra 20 18 23 19

  USO DE MEMORIA  
5,604,864 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0031
Controller Execution Time ( Home / Category )  0.1736
Total Execution Time  0.1768
  CADENA URL  
/tercera2021/grupo15/resumen/4
  GET DATOS  
$_GET['/tercera2021/grupo15/resumen/4']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (11)  
0.0046  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'tercera' AND (l.group_code = 15 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 2021 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=15 DESC LIMIT 1
0.0035  SELECT c.team1, c.team2,c.extra,c.datateam1,c.datateam2,c.type, c.shedule, c.r1, c.r2, c.round, c.comments as total_comentarios, dt1.nameShow as team1_name, dt2.nameShow as team2_name, dt1.basealias as basealias1, dt2.basealias as basealias2 FROM `calendars2021` as c INNER JOIN teams t1 ON t1.id = c.team1 AND t1.league_id = c.league_id INNER JOIN teams t2 ON t2.id = c.team2 AND t2.league_id = c.league_id INNER JOIN datateams as dt1 ON dt1.id = t1.teamId INNER JOIN datateams as dt2 ON dt2.id = t2.teamId WHERE c.`league_id` = 58594 AND c.`round` = 4 ORDER BY shedule ASC LIMIT 200
0.0045  SELECT (dt1.qod+dt2.qod+dt1.relations+dt2.relations) as total,c.r1,c.r2,e.action,ev.showName as eventName,ev.largeName,ev.main_action,ev.keyname,ev.classf,e.real_date,e.minute, dp.nick,dp.CountryCode,dp.alias,c.datateam1,c.datateam2,dt1.nameShow as nameShow1,dt2.nameShow as nameShow2,dt1.basealias as basealias1,dt2.basealias as basealias2,e.player_id,e.match_id FROM `events2021` e INNER JOIN calendars2021 c ON c.id = e.match_id INNER JOIN events ev ON ev.id = e.action INNER JOIN dataplayers dp ON dp.id = e.player_id INNER JOIN datateams dt1 ON dt1.id = c.datateam1 INNER JOIN datateams dt2 ON dt2.id = c.datateam2 WHERE ev.main_action = 1 AND c.round = 22 AND e.real_date IS NOT NULL AND e.league_id = 58594 ORDER BY total DESC LIMIT 100
0.0020  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-04-27 08:21:18' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0019  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=2 AND last_update > '2024-04-27 08:21:18' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0018  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=4 AND last_update > '2024-04-27 08:21:18' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0023  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=3 AND last_update > '2024-04-27 08:21:18' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0240  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 events2021 e ON e.player_id = p.id AND e.league_id = 58594 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 58594 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.0704  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 events2021 e ON e.player_id = p.id AND e.league_id = 58594 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 58594 AND (e.action = 4 or e.action = 5) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0041  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 events2021 e ON e.player_id = p.id AND e.league_id = 58594 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 58594 AND (e.action = 3 or e.action = 4) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0048  SELECT *,(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 = 58594 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