4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Ver
TEMPORADA 2022/2023
Equipo PJ GF GC Puntos
1 Deportivo Fabril Deportivo 30 47 18 61
2 Arosa Arosa 30 45 26 58
3 Rápido de Bouzas Rápido 30 39 24 56
4 RC Villalbés Villalbés 30 35 24 46
5 Ourense UD Ourense UD 30 38 30 45
6 Alondras CF Alondras CF 30 36 29 41
7 At. Arteixo At. Arteixo 30 37 42 41
8 Somozas Somozas 30 32 37 40
9 CD Estradense Estradense 30 33 38 39
10 Celta C – Gran Peña Celta Gran. 30 47 37 38
11 UD Paiosaco UD Paiosaco 30 31 42 37
12 Silva SD Silva SD 30 38 46 37
13 Viveiro Viveiro 30 29 37 37
14 CSD Arzua CSD Arzua 30 28 48 31
15 Barco Barco 30 26 38 31
16 Choco Choco 30 27 52 15
Ver
TEMPORADA 2021/2022
Equipo PJ GF GC Puntos
1 CD Lugo B CD Lugo B 32 54 23 68
2 Ourense CF Ourense CF 32 48 21 67
3 Somozas Somozas 32 43 30 63
4 Barco Barco 32 50 37 54
5 Deportivo Fabril Deportivo 32 49 23 53
6 Rápido de Bouzas Rápido 32 39 26 51
7 RC Villalbés Villalbés 32 43 24 50
8 CD Estradense Estradense 32 36 40 44
9 Alondras CF Alondras CF 32 30 29 40
10 Silva SD Silva SD 32 34 41 39
11 CSD Arzua CSD Arzua 32 29 35 38
12 Viveiro Viveiro 32 32 42 36
13 Choco Choco 32 32 43 35
14 Noia Noia 32 30 49 29
15 Juvenil Ponteareas Juvenil 32 25 43 28
16 At. Arnoia At. Arnoia 32 25 54 22
17 SD Sofán SD Sofán 32 29 68 17

  USO DE MEMORIA  
5,287,768 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0019
Controller Execution Time ( Home / Category )  0.3307
Total Execution Time  0.3326
  CADENA URL  
/tercera_division_rfef2023/grupo1/historico
  GET DATOS  
$_GET['/tercera_division_rfef2023/grupo1/historico']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (14)  
0.0266  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'tercera_division_rfef' AND (l.group_code = 1 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 2023 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=1 DESC LIMIT 1
0.0125  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=2470 AND type_rel = 3
0.0127  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 = 67975 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0130  SELECT id,year,current_round,total_teams,legend FROM leagues WHERE categoryId = 2470 AND group_code = 1 and tables = 1 AND year <= 2023 AND total_num_tablesR >= 1 ORDER BY year DESC LIMIT 22
0.0133  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 = 67975 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.0136  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 = 62385 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.0128  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-04-25 04:08:34' 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=2 AND last_update > '2024-04-25 04:08:34' 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-25 04:08:34' 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=3 AND last_update > '2024-04-25 04:08:34' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0229  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 events2023 e ON e.player_id = p.id AND e.league_id = 67975 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 67975 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.0308  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 events2023 e ON e.player_id = p.id AND e.league_id = 67975 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 67975 AND (e.action = 4 or e.action = 5) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0135  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 events2023 e ON e.player_id = p.id AND e.league_id = 67975 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 67975 AND (e.action = 3 or e.action = 4) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0256  SELECT *,(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 = 67975 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