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 Real Ávila Real Ávila 31 45 18 69
2 Salamanca UDS Salamanca 31 55 15 64
3 Júpiter Leonés Júpiter 31 49 23 60
4 Atlético Tordesillas Atlético 31 41 21 60
5 Atl. Astorga Atl. Astorga 31 36 23 49
6 Palencia Cristo Atlético Palencia 31 36 24 49
7 Palencia CF Palencia CF 31 27 25 49
8 Becerril Becerril 31 34 37 48
9 UD Santa Marta Santa Marta 31 34 35 43
10 La Virgen del Camino Virgen 31 33 37 39
11 Burgos CF B Burgos CF B 31 27 33 38
12 SD Almazán SD Almazán 31 30 39 37
13 Atl. Bembibre Atl. 31 29 37 34
14 Mirandés B Mirandés B 31 26 34 33
15 CD Villaralbo Villaralbo 31 25 42 26
16 CD Laguna CD Laguna 31 24 53 25
17 DiocesÁvila - UCAV DiocesÁvila 31 13 37 24
18 Ponferradina B Ponferradina 31 20 51 14
Ver
TEMPORADA 2022/2023
Equipo PJ GF GC Puntos
1 Arandina Arandina 30 55 18 68
2 Atl. Astorga Atl. Astorga 30 54 27 61
3 Salamanca UDS Salamanca 30 38 26 53
4 Real Ávila Real Ávila 30 40 26 50
5 Atlético Tordesillas Atlético 30 30 24 50
6 SD Almazán SD Almazán 30 36 32 47
7 La Virgen del Camino Virgen 30 36 33 45
8 Ponferradina B Ponferradina 30 37 32 39
9 Mirandés B Mirandés B 30 41 38 38
10 Atl. Bembibre Atl. 30 35 40 35
11 Becerril Becerril 30 34 46 35
12 Palencia CF Palencia CF 30 42 42 34
13 Júpiter Leonés Júpiter 30 22 33 33
14 UD Santa Marta Santa Marta 30 31 59 28
15 Unami CP Unami CP 30 20 52 24
16 Numancia B Numancia B 30 28 51 20
Ver
TEMPORADA 2021/2022
Equipo PJ GF GC Puntos
1 Guijuelo Guijuelo 32 61 16 75
2 SD Almazán SD Almazán 32 51 28 64
3 Real Ávila Real Ávila 32 45 25 58
4 Mirandés B Mirandés B 32 36 24 55
5 Atlético Tordesillas Atlético 32 37 28 54
6 Júpiter Leonés Júpiter 32 55 37 54
7 Arandina Arandina 32 39 22 53
8 Palencia CF Palencia CF 32 45 36 47
9 Atl. Astorga Atl. Astorga 32 33 37 42
10 Atl. Bembibre Atl. 32 32 40 40
11 La Virgen del Camino Virgen 32 28 34 39
12 Numancia B Numancia B 32 40 48 36
13 UD Santa Marta Santa Marta 32 37 49 35
14 Ribert Ribert 32 34 49 32
15 Salamanca UDS B Salamanca 32 22 51 30
16 Ciudad Rodrigo Ciudad 32 29 65 20
17 DiocesÁvila - UCAV DiocesÁvila 32 21 56 19

  USO DE MEMORIA  
5,512,752 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0019
Controller Execution Time ( Home / Category )  0.2888
Total Execution Time  0.2907
  CADENA URL  
/tercera_division_rfef2024/grupo8/historico
  GET DATOS  
$_GET['/tercera_division_rfef2024/grupo8/historico']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (13)  
0.0105  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=2470 AND type_rel = 3
0.0107  SELECT id,year,current_round,total_teams,legend FROM leagues WHERE categoryId = 2470 AND group_code = 8 and tables = 1 AND year <= 2024 AND total_num_tablesR >= 1 ORDER BY year DESC LIMIT 22
0.0213  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 `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 = 72267 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
0.0112  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 = 67982 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.0110  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 = 62392 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.0106  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-04-28 14:45:05' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0105  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=2 AND last_update > '2024-04-28 14:45:05' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0105  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=4 AND last_update > '2024-04-28 14:45:05' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0105  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=3 AND last_update > '2024-04-28 14:45:05' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0281  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 = 72267 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 72267 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.0381  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 = 72267 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 72267 AND (e.action = 4 or e.action = 5) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0121  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 = 72267 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 72267 AND (e.action = 3 or e.action = 4) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0117  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 = 72267 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