4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Ver
TEMPORADA 2023/2024
Equipo PJ GF GC Puntos
1 CD Vitoria CD Vitoria 33 63 15 81
2 Beasain KE Beasain KE 33 55 35 63
3 CD Basconia CD Basconia 33 51 30 61
4 Portugalete Portugalete 33 53 31 59
5 Deusto Deusto 33 44 29 58
6 CD Lagun Onak Lagun Onak 33 41 32 54
7 SCD Durango SCD Durango 33 45 44 50
8 San Ignacio San Ignacio 33 46 41 46
9 Leioa Leioa 33 43 48 44
10 Urduliz FT Urduliz FT 33 37 44 42
11 Deportivo Alavés C Deportivo 33 33 41 39
12 CD Derio CD Derio 33 32 33 39
13 CD Padura CD Padura 33 32 45 38
14 CD Touring CD Touring 33 36 47 36
15 Pasaia KE Pasaia KE 33 21 40 33
16 Anaitasuna FT Anaitasuna 33 33 48 32
17 Aurrera KE Aurrera KE 33 23 53 21
18 Añorga Añorga 33 29 61 18
Ver
TEMPORADA 2022/2023
Equipo PJ GF GC Puntos
1 Barakaldo Barakaldo 30 67 11 76
2 CD Vitoria CD Vitoria 30 49 18 58
3 Leioa Leioa 30 49 36 56
4 CD Basconia CD Basconia 30 59 37 54
5 Deusto Deusto 30 38 26 47
6 Portugalete Portugalete 30 32 32 41
7 Pasaia KE Pasaia KE 30 36 53 38
8 SCD Durango SCD Durango 30 40 41 37
9 Aurrera KE Aurrera KE 30 29 37 37
10 Anaitasuna FT Anaitasuna 30 36 36 37
11 Urduliz FT Urduliz FT 30 31 38 33
12 CD Lagun Onak Lagun Onak 30 25 29 33
13 CD Padura CD Padura 30 28 39 32
14 CD Touring CD Touring 30 34 52 32
15 San Ignacio San Ignacio 30 30 53 26
16 CD Aurrera Vitoria Aurrera 30 17 62 12
Ver
TEMPORADA 2021/2022
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

  USO DE MEMORIA  
5,547,104 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0020
Controller Execution Time ( Home / Category )  0.2781
Total Execution Time  0.2801
  CADENA URL  
/tercera_division_rfef2024/grupo4/historico
  GET DATOS  
$_GET['/tercera_division_rfef2024/grupo4/historico']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (11)  
0.0125  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=2470 AND type_rel = 3
0.0127  SELECT id,year,current_round,total_teams,legend FROM leagues WHERE categoryId = 2470 AND group_code = 4 and tables = 1 AND year <= 2024 AND total_num_tablesR >= 1 ORDER BY year DESC LIMIT 22
0.0130  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 = 67978 AND t.round = 30 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0135  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.0125  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-05-06 03:53:07' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0126  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=2 AND last_update > '2024-05-06 03:53:08' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0125  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=4 AND last_update > '2024-05-06 03:53:08' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0125  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=3 AND last_update > '2024-05-06 03:53:08' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0268  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 = 72263 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 72263 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.0417  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 = 72263 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 72263 AND (e.action = 4 or e.action = 5) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0145  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 = 72263 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 72263 AND (e.action = 3 or e.action = 4) GROUP BY e.player_id ORDER BY total DESC LIMIT 10