4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Ver
TEMPORADA 2020/2021
Equipo PJ GF GC Puntos
1 UD Sanse UD Sanse 18 22 14 35
2 RM Castilla RM Castilla 18 30 21 32
3 Internacional de Madrid Internaciona 18 24 16 30
4 Rayo Majadahonda Rayo 18 17 16 28
5 Atlético Baleares Atlético 18 26 21 24
6 CDA Navalcarnero Navalcarnero 18 16 18 20
7 Las Rozas Las Rozas 18 16 25 20
8 Atlético B Atlético B 18 15 20 19
9 Poblense Poblense 18 16 21 16
10 Getafe B Getafe B 18 11 21 13
11 CD Badajoz CD Badajoz 18 32 9 41
12 Extremadura Extremadura 18 24 16 31
13 CF Talavera CF Talavera 18 23 19 27
14 Villanovense Villanovense 18 15 8 27
15 CD Don Benito Benito 18 16 21 24
16 AD Mérida AD Mérida 18 12 12 23
17 UD Melilla UD Melilla 18 15 19 23
18 Villarrubia CF Villarrubia 18 17 24 20
19 UD Yugo Socuéllamos Yugo 18 13 25 16
20 CP Villarrobledo Villarrobled 18 15 29 10

  USO DE MEMORIA  
5,300,536 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0019
Controller Execution Time ( Home / Category )  0.3108
Total Execution Time  0.3127
  CADENA URL  
/segundab2021/grupo5/historico
  GET DATOS  
$_GET['/segundab2021/grupo5/historico']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (12)  
0.0252  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'segundab' AND (l.group_code = 5 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 2021 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=5 DESC LIMIT 1
0.0126  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 = 58612 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0128  SELECT id,year,current_round,total_teams,legend FROM leagues WHERE categoryId = 3 AND group_code = 5 and tables = 1 AND year <= 2021 AND total_num_tablesR >= 1 ORDER BY year DESC LIMIT 22
0.0129  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 `tables2021` 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 = 58612 AND t.round = 18 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-04-28 13:43:30' 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=2 AND last_update > '2024-04-28 13:43:30' 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-04-28 13:43:30' 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-04-28 13:43:30' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0205  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 events2021 e ON e.player_id = p.id AND e.league_id = 58612 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 58612 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.0372  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 events2021 e ON e.player_id = p.id AND e.league_id = 58612 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 58612 AND (e.action = 4 or e.action = 5) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0139  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 events2021 e ON e.player_id = p.id AND e.league_id = 58612 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 58612 AND (e.action = 3 or e.action = 4) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0261  SELECT *,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables2021` 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 = 58612 AND t.round = 18 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC