4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Ver
TEMPORADA 2013/2014
Equipo PJ GF GC Puntos
1 BSC Young Boys Sub 17 Young Boys 22 65 23 57
2 Fc Basel 1893 Sub 17 Basel 1893 22 62 32 48
3 FC Zürich Sub 17 Zürich 22 52 38 44
4 FC Thun Sub 17 Thun 22 68 35 42
5 Rapperswil-Jona Sub 17 Rapperswil-J 22 47 36 36
6 Team Vaud Sub 17 Team Vaud 22 34 53 26
7 Luzern Sub 17 Luzern 22 33 52 25
8 Team Ticino Sub 17 Team Ticino 22 36 48 24
9 Servette FC Sub 17 Servette 22 39 48 22
10 FC St. Gallen 1879 Sub 17 Gallen 1879 22 43 54 21
11 FC Vaduz Sub 18 Vaduz 22 37 61 16
12 Team Bejune Sub 17 Team Bejune 22 27 63 13

  USO DE MEMORIA  
4,872,672 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0037
Controller Execution Time ( Home / Category )  0.2714
Total Execution Time  0.2751
  CADENA URL  
/liga_suiza_sub172014/grupo1/historico
  GET DATOS  
$_GET['/liga_suiza_sub172014/grupo1/historico']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (15)  
0.0105  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=2116 AND type_rel = 3
0.0106  SELECT id,name,alias,stepParent FROM categories WHERE parentId=2116 ORDER BY order_id ASC
0.0106  SELECT max(l.year) as max_year, min(l.year) as min_year FROM leagues l WHERE categoryID = 2116 GROUP BY l.categoryId
0.0106  SELECT l.year FROM leagues AS l WHERE (l.group_code =0 OR l.total_num_tablesR>=1 OR l.total_teamsR >=1 OR l.text_mode != 0) AND l.categoryId=2116 GROUP BY l.year ORDER BY l.year DESC
0.0107  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 = 63141 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0108  SELECT id,year,current_round,total_teams,legend FROM leagues WHERE categoryId = 2116 AND group_code = 1 and tables = 1 AND year <= 2014 AND total_num_tablesR >= 1 ORDER BY year DESC LIMIT 22
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 `tables2014` 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 = 63141 AND t.round = 22 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0105  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-04-27 17:45:04' 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-27 17:45:04' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0106  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=4 AND last_update > '2024-04-27 17:45:04' 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-27 17:45:04' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0218  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 events2014 e ON e.player_id = p.id AND e.league_id = 63141 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 63141 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.0196  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 events2014 e ON e.player_id = p.id AND e.league_id = 63141 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 63141 AND (e.action = 4 or e.action = 5) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0115  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 events2014 e ON e.player_id = p.id AND e.league_id = 63141 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 63141 AND (e.action = 3 or e.action = 4) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0119  SELECT *,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables2014` 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 = 63141 AND t.round = 22 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC