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 33 51 19 75
2 Salamanca UDS Salamanca 33 59 15 70
3 Atlético Tordesillas Atlético 33 44 23 64
4 Júpiter Leonés Júpiter 33 50 26 60
5 Atl. Astorga Atl. Astorga 33 39 24 55
6 Palencia Cristo Atlético Palencia 33 39 26 52
7 Palencia CF Palencia CF 33 31 28 52
8 Becerril Becerril 33 38 41 51
9 UD Santa Marta Santa Marta 33 35 40 43
10 La Virgen del Camino Virgen 33 35 41 40
11 Burgos CF B Burgos CF B 33 30 39 39
12 SD Almazán SD Almazán 33 31 41 38
13 Atl. Bembibre Atl. 33 33 39 38
14 Mirandés B Mirandés B 33 27 37 34
15 CD Villaralbo Villaralbo 33 29 44 32
16 CD Laguna CD Laguna 33 27 55 29
17 DiocesÁvila - UCAV DiocesÁvila 33 14 39 25
18 Ponferradina B Ponferradina 33 21 56 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,507,624 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0018
Controller Execution Time ( Home / Category )  0.1112
Total Execution Time  0.1131
  CADENA URL  
/tercera_division_rfef2024/grupo8/historico
  GET DATOS  
$_GET['/tercera_division_rfef2024/grupo8/historico']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (14)  
0.0020  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=2470 AND type_rel = 3
0.0020  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 = 72267 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0021  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.0039  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 = 33 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0022  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.0023  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.0019  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-05-08 09:47:17' 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=2 AND last_update > '2024-05-08 09:47:17' 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-05-08 09:47:17' 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=3 AND last_update > '2024-05-08 09:47:17' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0175  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.0288  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.0036  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.0053  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 = 33 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC