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 4
2020/2021

IV - Euskadi

Tercera División 2021 G 4

  • SD Gernika
  • Real Sociedad C
  • Sestao River
  • Deusto
  • Santutxu
  • Beasain KE
  • Tolosa CF
  • Aurrera KE
  • Balmaseda FC
  • JD Somorrostro
  • Urgatzi KK
  • CD Vitoria
  • Urduliz FT
  • Pasaia KE
  • CD Basconia
  • Anaitasuna FT
  • San Ignacio
  • Santurtzi
  • SCD Durango
  • Sodupe
  • Ariznabarra
  • CD Lagun Onak
  • Tercera División:

Clasificación

Equipo PJ GF GC Puntos
1 SD Gernika SD Gernika 20 39 16 43
2 Real Sociedad C Real 20 48 27 40
3 Sestao River Sestao River 20 40 13 39
4 Deusto Deusto 20 30 24 36
5 Santutxu Santutxu 20 20 23 29
6 Beasain KE Beasain KE 20 20 14 27
7 Tolosa CF Tolosa CF 20 21 26 24
8 Aurrera KE Aurrera KE 20 23 31 20
9 Balmaseda FC Balmaseda 20 22 27 18
10 JD Somorrostro Somorrostro 20 20 31 17
11 Urgatzi KK Urgatzi KK 20 11 62 10
12 CD Vitoria CD Vitoria 20 20 4 35
13 Urduliz FT Urduliz FT 20 28 18 35
14 Pasaia KE Pasaia KE 20 22 14 34
15 CD Basconia CD Basconia 20 24 15 30
16 Anaitasuna FT Anaitasuna 20 20 19 30
17 San Ignacio San Ignacio 20 19 19 29
18 Santurtzi Santurtzi 20 18 27 23
19 SCD Durango SCD Durango 20 17 20 22
20 Sodupe Sodupe 20 21 23 20
21 Ariznabarra Ariznabarra 20 12 28 16
22 CD Lagun Onak Lagun Onak 20 17 31 15

  USO DE MEMORIA  
5,535,816 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0019
Controller Execution Time ( Home / Category )  0.3891
Total Execution Time  0.3911
  CADENA URL  
/tercera2021/grupo4/resumen/22
  GET DATOS  
$_GET['/tercera2021/grupo4/resumen/22']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (12)  
0.0259  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 = 4 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=4 DESC LIMIT 1
0.0130  SELECT dt.nameShow,dt.basealias,t.id,t.teamId FROM teams t INNER JOIN datateams dt ON t.teamId = dt.id WHERE t.league_id = 58582 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0134  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` = 58582 AND c.`round` = 22 ORDER BY shedule ASC LIMIT 200
0.0175  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 = 58582 ORDER BY total DESC LIMIT 100
0.0126  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-04-30 21:10:29' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0127  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=2 AND last_update > '2024-04-30 21:10:29' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0129  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=4 AND last_update > '2024-04-30 21:10:29' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0128  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=3 AND last_update > '2024-04-30 21:10:29' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0432  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 = 58582 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 58582 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.0620  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 = 58582 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 58582 AND (e.action = 4 or e.action = 5) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0147  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 = 58582 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 58582 AND (e.action = 3 or e.action = 4) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0384  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 = 58582 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