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 Numancia Numancia 33 51 34 60
2 Gimnástica Segoviana Gimnástica 33 45 27 58
3 UD Sanse UD Sanse 33 59 26 58
4 Getafe B Getafe B 33 39 30 56
5 CD Atlético Paso Atlético 33 26 21 53
6 Unión Adarve Unión 33 44 42 48
7 CP Cacereño Cacereño 33 38 37 46
8 CF Talavera CF Talavera 33 31 26 46
9 Villanovense Villanovense 33 35 34 44
10 CD Illescas CD Illescas 33 34 31 44
11 CDA Navalcarnero Navalcarnero 33 33 35 43
12 CD Guadalajara Guadalajara 33 40 51 43
13 CD Ursaria CD Ursaria 33 33 39 41
14 AD Llerenense Llerenense 33 28 34 41
15 CD Badajoz CD Badajoz 33 33 36 37
16 UD San Fernando Fernando 33 29 41 37
17 CD Mensajero Mensajero 33 26 52 25
18 UD Montijo UD Montijo 33 28 56 23
Ver
TEMPORADA 2022/2023
Equipo PJ GF GC Puntos
1 UD Melilla UD Melilla 34 41 15 66
2 Atlético B Atlético B 34 60 33 65
3 CDA Navalcarnero Navalcarnero 34 46 28 62
4 CP Cacereño Cacereño 34 35 23 55
5 Gimnástica Segoviana Gimnástica 34 48 44 52
6 Villanovense Villanovense 34 29 25 50
7 CD Guadalajara Guadalajara 34 49 35 48
8 CD Estepona CD Estepona 34 35 26 47
9 Unión Adarve Unión 34 43 43 46
10 Cerdanyola FC Cerdanyola 34 28 45 41
11 CD Atlético Paso Atlético 34 38 39 41
12 UD Montijo UD Montijo 34 33 47 39
13 CD Coria CD Coria 34 31 43 39
14 Leganés B Leganés B 34 31 39 37
15 Alcorcón B Alcorcón B 34 34 42 35
16 CD Diocesano Diocesano 34 33 43 34
17 UD Yugo Socuéllamos Yugo 34 25 41 33
18 CD Don Benito Benito 34 19 47 32
Ver
TEMPORADA 2021/2022
Equipo PJ GF GC Puntos
1 CF Intercity Intercity 34 46 16 66
2 CF La Nucía Nucía 34 41 18 64
3 Real Murcia Real Murcia 34 42 27 58
4 Eldense Eldense 34 47 37 56
5 Hércules Hércules 34 41 31 56
6 Racing Cartagena Mar Menor Racing 34 34 29 55
7 UD Alzira UD Alzira 34 42 36 51
8 Recreativo Granada Recreativo 34 34 32 46
9 UD Melilla UD Melilla 34 36 39 45
10 Mancha Real Mancha Real 34 32 36 43
11 Pvo. El Ejido Pvo. Ejido 34 30 35 43
12 UD Yugo Socuéllamos Yugo 34 29 34 43
13 Águilas FC Águilas FC 34 32 36 41
14 At. Levante At. Levante 34 33 33 38
15 At. Pulpileño Pulpileño 34 23 48 34
16 CD Marchamalo Marchamalo 34 33 59 32
17 CS Puertollano Puertollano 34 38 50 29
18 CD Toledo CD Toledo 34 27 44 28

  USO DE MEMORIA  
5,506,416 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0019
Controller Execution Time ( Home / Category )  0.3732
Total Execution Time  0.3751
  CADENA URL  
/segunda_division_rfef2024/grupo5/historico
  GET DATOS  
$_GET['/segunda_division_rfef2024/grupo5/historico']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (14)  
0.0144  SELECT type FROM routes WHERE alias = 'segunda_division_rfef2024'
0.0144  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=2469 AND type_rel = 3
0.0146  SELECT id,year,current_round,total_teams,legend FROM leagues WHERE categoryId = 2469 AND group_code = 5 and tables = 1 AND year <= 2024 AND total_num_tablesR >= 1 ORDER BY year DESC LIMIT 22
0.0292  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 = 72366 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.0151  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 = 67969 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.0152  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 = 62384 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.0145  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-05-03 13:19:59' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0145  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=2 AND last_update > '2024-05-03 13:19:59' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0146  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=4 AND last_update > '2024-05-03 13:19:59' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0151  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=3 AND last_update > '2024-05-03 13:19:59' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0319  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 = 72366 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 72366 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.0365  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 = 72366 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 72366 AND (e.action = 4 or e.action = 5) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0158  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 = 72366 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 72366 AND (e.action = 3 or e.action = 4) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0160  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 = 72366 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