4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Ver jornada
Jornada 1
08 Sep 13 FC Zürich Sub 17Zürich 3 - 0 Team Bejune Sub 17Team Bejune ...
08 Sep 13 Luzern Sub 17Luzern 1 - 3 Fc Basel 1893 Sub 17Basel 1893 ...
07 Sep 13 Team Vaud Sub 17Team Vaud 1 - 3 FC Thun Sub 17Thun ...
07 Sep 13 Rapperswil-Jona Sub 17Rapperswil- 2 - 0 Servette FC Sub 17Servette ...
07 Sep 13 FC St. Gallen 1879 Sub 17Gallen 1879 3 - 3 BSC Young Boys Sub 17Young Boys ...
07 Sep 13 FC Vaduz Sub 18Vaduz 2 - 6 Team Ticino Sub 17Team Ticino ...
Ver jornada
Jornada 2
21 Sep 13 FC Thun Sub 17Thun 4 - 1 Fc Basel 1893 Sub 17Basel 1893 ...
21 Sep 13 Servette FC Sub 17Servette 3 - 3 Luzern Sub 17Luzern ...
21 Sep 13 Team Vaud Sub 17Team Vaud 1 - 0 FC Vaduz Sub 18Vaduz ...
21 Sep 13 Team Bejune Sub 17Team Bejune 1 - 4 Rapperswil-Jona Sub 17Rapperswil- ...
21 Sep 13 BSC Young Boys Sub 17Young Boys 4 - 0 FC Zürich Sub 17Zürich ...
22 Sep 13 Team Ticino Sub 17Team Ticino 0 - 1 FC St. Gallen 1879 Sub 17Gallen 1879 ...
Ver jornada
Jornada 3
29 Sep 13 Luzern Sub 17Luzern 3 - 2 Team Bejune Sub 17Team Bejune ...
28 Sep 13 Fc Basel 1893 Sub 17Basel 1893 3 - 2 Servette FC Sub 17Servette ...
29 Sep 13 FC Zürich Sub 17Zürich 4 - 0 Team Ticino Sub 17Team Ticino ...
28 Sep 13 FC Vaduz Sub 18Vaduz 4 - 1 FC Thun Sub 17Thun ...
28 Sep 13 Rapperswil-Jona Sub 17Rapperswil- 3 - 2 BSC Young Boys Sub 17Young Boys ...
28 Sep 13 FC St. Gallen 1879 Sub 17Gallen 1879 2 - 3 Team Vaud Sub 17Team Vaud ...
Ver jornada
Jornada 4
18 Sep 13 FC Vaduz Sub 18Vaduz 1 - 1 FC St. Gallen 1879 Sub 17Gallen 1879 ...
05 Oct 13 Team Bejune Sub 17Team Bejune 1 - 3 Fc Basel 1893 Sub 17Basel 1893 ...
05 Oct 13 BSC Young Boys Sub 17Young Boys 2 - 0 Luzern Sub 17Luzern ...
05 Oct 13 Team Vaud Sub 17Team Vaud 0 - 1 FC Zürich Sub 17Zürich ...
05 Oct 13 FC Thun Sub 17Thun 3 - 1 Servette FC Sub 17Servette ...
06 Oct 13 Team Ticino Sub 17Team Ticino 1 - 1 Rapperswil-Jona Sub 17Rapperswil- ...
Ver jornada
Jornada 5
12 Oct 13 FC St. Gallen 1879 Sub 17Gallen 1879 2 - 2 FC Thun Sub 17Thun ...
12 Oct 13 Servette FC Sub 17Servette 2 - 3 Team Bejune Sub 17Team Bejune ...
12 Oct 13 Fc Basel 1893 Sub 17Basel 1893 1 - 1 BSC Young Boys Sub 17Young Boys ...
13 Oct 13 Luzern Sub 17Luzern 0 - 2 Team Ticino Sub 17Team Ticino ...
13 Oct 13 Rapperswil-Jona Sub 17Rapperswil- 5 - 1 Team Vaud Sub 17Team Vaud ...
20 Nov 13 FC Zürich Sub 17Zürich 2 - 3 FC Vaduz Sub 18Vaduz ...
Ver jornada
Jornada 6
19 Oct 13 FC Vaduz Sub 18Vaduz 2 - 2 Rapperswil-Jona Sub 17Rapperswil- ...
19 Oct 13 BSC Young Boys Sub 17Young Boys 3 - 1 Servette FC Sub 17Servette ...
19 Oct 13 Team Vaud Sub 17Team Vaud 3 - 1 Luzern Sub 17Luzern ...
19 Oct 13 Team Ticino Sub 17Team Ticino 2 - 4 Fc Basel 1893 Sub 17Basel 1893 ...
20 Oct 13 FC St. Gallen 1879 Sub 17Gallen 1879 3 - 5 FC Zürich Sub 17Zürich ...
20 Oct 13 FC Thun Sub 17Thun 2 - 0 Team Bejune Sub 17Team Bejune ...
Ver jornada
Jornada 7
26 Oct 13 Rapperswil-Jona Sub 17Rapperswil- 0 - 3 FC St. Gallen 1879 Sub 17Gallen 1879 ...
26 Oct 13 Luzern Sub 17Luzern 4 - 2 FC Vaduz Sub 18Vaduz ...
26 Oct 13 Team Bejune Sub 17Team Bejune 1 - 2 BSC Young Boys Sub 17Young Boys ...
26 Oct 13 Servette FC Sub 17Servette 1 - 2 Team Ticino Sub 17Team Ticino ...
26 Oct 13 Fc Basel 1893 Sub 17Basel 1893 5 - 0 Team Vaud Sub 17Team Vaud ...
27 Oct 13 FC Zürich Sub 17Zürich 3 - 1 FC Thun Sub 17Thun ...
Ver jornada
Jornada 8
30 Oct 13 Team Vaud Sub 17Team Vaud 1 - 1 Servette FC Sub 17Servette ...
02 Nov 13 FC Vaduz Sub 18Vaduz 1 - 3 Fc Basel 1893 Sub 17Basel 1893 ...
02 Nov 13 FC St. Gallen 1879 Sub 17Gallen 1879 2 - 2 Luzern Sub 17Luzern ...
02 Nov 13 FC Thun Sub 17Thun 2 - 2 BSC Young Boys Sub 17Young Boys ...
02 Nov 13 Team Ticino Sub 17Team Ticino 2 - 3 Team Bejune Sub 17Team Bejune ...
03 Nov 13 FC Zürich Sub 17Zürich 1 - 1 Rapperswil-Jona Sub 17Rapperswil- ...
Ver jornada
Jornada 9
09 Nov 13 Rapperswil-Jona Sub 17Rapperswil- 1 - 3 FC Thun Sub 17Thun ...
09 Nov 13 Luzern Sub 17Luzern 0 - 2 FC Zürich Sub 17Zürich ...
09 Nov 13 Servette FC Sub 17Servette 4 - 2 FC Vaduz Sub 18Vaduz ...
09 Nov 13 Team Bejune Sub 17Team Bejune 2 - 3 Team Vaud Sub 17Team Vaud ...
09 Nov 13 BSC Young Boys Sub 17Young Boys 3 - 2 Team Ticino Sub 17Team Ticino ...
09 Nov 13 Fc Basel 1893 Sub 17Basel 1893 1 - 0 FC St. Gallen 1879 Sub 17Gallen 1879 ...
Ver jornada
Jornada 10
16 Nov 13 FC Thun Sub 17Thun 3 - 0 Team Ticino Sub 17Team Ticino ...
16 Nov 13 FC Vaduz Sub 18Vaduz 2 - 2 Team Bejune Sub 17Team Bejune ...
16 Nov 13 FC St. Gallen 1879 Sub 17Gallen 1879 2 - 2 Servette FC Sub 17Servette ...
16 Nov 13 Team Vaud Sub 17Team Vaud 0 - 3 BSC Young Boys Sub 17Young Boys ...
17 Nov 13 FC Zürich Sub 17Zürich 1 - 5 Fc Basel 1893 Sub 17Basel 1893 ...
17 Nov 13 Rapperswil-Jona Sub 17Rapperswil- 2 - 1 Luzern Sub 17Luzern ...
Ver jornada
Jornada 11
30 Oct 13 FC Thun Sub 17Thun 1 - 1 Luzern Sub 17Luzern ...
23 Nov 13 Team Bejune Sub 17Team Bejune 2 - 1 FC St. Gallen 1879 Sub 17Gallen 1879 ...
23 Nov 13 BSC Young Boys Sub 17Young Boys 4 - 1 FC Vaduz Sub 18Vaduz ...
23 Nov 13 Team Ticino Sub 17Team Ticino 1 - 2 Team Vaud Sub 17Team Vaud ...
23 Nov 13 Servette FC Sub 17Servette 2 - 3 FC Zürich Sub 17Zürich ...
23 Nov 13 Fc Basel 1893 Sub 17Basel 1893 2 - 3 Rapperswil-Jona Sub 17Rapperswil- ...
Ver jornada
Jornada 12
15 Mar 14 Team Ticino Sub 17Team Ticino 3 - 1 FC Vaduz Sub 18Vaduz ...
15 Mar 14 Team Bejune Sub 17Team Bejune 0 - 3 FC Zürich Sub 17Zürich ...
15 Mar 14 BSC Young Boys Sub 17Young Boys 6 - 0 FC St. Gallen 1879 Sub 17Gallen 1879 ...
15 Mar 14 Servette FC Sub 17Servette 1 - 4 Rapperswil-Jona Sub 17Rapperswil- ...
16 Mar 14 Fc Basel 1893 Sub 17Basel 1893 2 - 0 Luzern Sub 17Luzern ...
16 Mar 14 FC Thun Sub 17Thun 2 - 2 Team Vaud Sub 17Team Vaud ...
Ver jornada
Jornada 13
22 Mar 14 Fc Basel 1893 Sub 17Basel 1893 2 - 2 FC Thun Sub 17Thun ...
22 Mar 14 Luzern Sub 17Luzern 2 - 1 Servette FC Sub 17Servette ...
22 Mar 14 FC Vaduz Sub 18Vaduz 3 - 2 Team Vaud Sub 17Team Vaud ...
22 Mar 14 FC Zürich Sub 17Zürich 0 - 2 BSC Young Boys Sub 17Young Boys ...
22 Mar 14 FC St. Gallen 1879 Sub 17Gallen 1879 1 - 2 Team Ticino Sub 17Team Ticino ...
23 Mar 14 Rapperswil-Jona Sub 17Rapperswil- 2 - 0 Team Bejune Sub 17Team Bejune ...
Ver jornada
Jornada 14
29 Mar 14 Team Bejune Sub 17Team Bejune 1 - 3 Luzern Sub 17Luzern ...
29 Mar 14 Servette FC Sub 17Servette 1 - 3 Fc Basel 1893 Sub 17Basel 1893 ...
29 Mar 14 FC Thun Sub 17Thun 5 - 1 FC Vaduz Sub 18Vaduz ...
29 Mar 14 Team Vaud Sub 17Team Vaud 2 - 5 FC St. Gallen 1879 Sub 17Gallen 1879 ...
29 Mar 14 BSC Young Boys Sub 17Young Boys 1 - 0 Rapperswil-Jona Sub 17Rapperswil- ...
30 Mar 14 Team Ticino Sub 17Team Ticino 0 - 3 FC Zürich Sub 17Zürich ...
Ver jornada
Jornada 15
05 Abr 14 FC St. Gallen 1879 Sub 17Gallen 1879 5 - 2 FC Vaduz Sub 18Vaduz ...
05 Abr 14 Servette FC Sub 17Servette 1 - 1 FC Thun Sub 17Thun ...
05 Abr 14 Fc Basel 1893 Sub 17Basel 1893 3 - 1 Team Bejune Sub 17Team Bejune ...
06 Abr 14 Luzern Sub 17Luzern 1 - 4 BSC Young Boys Sub 17Young Boys ...
06 Abr 14 FC Zürich Sub 17Zürich 2 - 1 Team Vaud Sub 17Team Vaud ...
06 Abr 14 Rapperswil-Jona Sub 17Rapperswil- 3 - 3 Team Ticino Sub 17Team Ticino ...
Ver jornada
Jornada 16
12 Abr 14 Team Bejune Sub 17Team Bejune 0 - 3 Servette FC Sub 17Servette ...
12 Abr 14 FC Vaduz Sub 18Vaduz 1 - 1 FC Zürich Sub 17Zürich ...
12 Abr 14 Team Vaud Sub 17Team Vaud 2 - 1 Rapperswil-Jona Sub 17Rapperswil- ...
13 Abr 14 Team Ticino Sub 17Team Ticino 0 - 1 Luzern Sub 17Luzern ...
13 Abr 14 FC Thun Sub 17Thun 4 - 2 FC St. Gallen 1879 Sub 17Gallen 1879 ...
14 May 14 BSC Young Boys Sub 17Young Boys 2 - 0 Fc Basel 1893 Sub 17Basel 1893 ...
Ver jornada
Jornada 17
26 Abr 14 Luzern Sub 17Luzern 3 - 1 Team Vaud Sub 17Team Vaud ...
26 Abr 14 Team Bejune Sub 17Team Bejune 2 - 8 FC Thun Sub 17Thun ...
26 Abr 14 Servette FC Sub 17Servette 1 - 4 BSC Young Boys Sub 17Young Boys ...
27 Abr 14 Fc Basel 1893 Sub 17Basel 1893 3 - 3 Team Ticino Sub 17Team Ticino ...
27 Abr 14 Rapperswil-Jona Sub 17Rapperswil- 4 - 1 FC Vaduz Sub 18Vaduz ...
27 Abr 14 FC Zürich Sub 17Zürich 2 - 1 FC St. Gallen 1879 Sub 17Gallen 1879 ...
Ver jornada
Jornada 18
03 May 14 FC Vaduz Sub 18Vaduz 1 - 2 Luzern Sub 17Luzern ...
03 May 14 FC St. Gallen 1879 Sub 17Gallen 1879 2 - 2 Rapperswil-Jona Sub 17Rapperswil- ...
03 May 14 Team Vaud Sub 17Team Vaud 2 - 5 Fc Basel 1893 Sub 17Basel 1893 ...
04 May 14 BSC Young Boys Sub 17Young Boys 4 - 1 Team Bejune Sub 17Team Bejune ...
04 May 14 Team Ticino Sub 17Team Ticino 2 - 0 Servette FC Sub 17Servette ...
04 May 14 FC Thun Sub 17Thun 4 - 1 FC Zürich Sub 17Zürich ...
Ver jornada
Jornada 19
30 Abr 14 Rapperswil-Jona Sub 17Rapperswil- 2 - 4 FC Zürich Sub 17Zürich ...
10 May 14 Servette FC Sub 17Servette 3 - 1 Team Vaud Sub 17Team Vaud ...
10 May 14 BSC Young Boys Sub 17Young Boys 4 - 2 FC Thun Sub 17Thun ...
10 May 14 Team Bejune Sub 17Team Bejune 1 - 2 Team Ticino Sub 17Team Ticino ...
10 May 14 Fc Basel 1893 Sub 17Basel 1893 3 - 1 FC Vaduz Sub 18Vaduz ...
11 May 14 Luzern Sub 17Luzern 1 - 4 FC St. Gallen 1879 Sub 17Gallen 1879 ...
Ver jornada
Jornada 20
17 May 14 Team Vaud Sub 17Team Vaud 2 - 1 Team Bejune Sub 17Team Bejune ...
17 May 14 FC Vaduz Sub 18Vaduz 0 - 3 Servette FC Sub 17Servette ...
17 May 14 FC Thun Sub 17Thun 2 - 3 Rapperswil-Jona Sub 17Rapperswil- ...
17 May 14 Team Ticino Sub 17Team Ticino 1 - 3 BSC Young Boys Sub 17Young Boys ...
18 May 14 FC Zürich Sub 17Zürich 6 - 3 Luzern Sub 17Luzern ...
21 May 14 FC St. Gallen 1879 Sub 17Gallen 1879 0 - 6 Fc Basel 1893 Sub 17Basel 1893 ...
Ver jornada
Jornada 21
24 May 14 Luzern Sub 17Luzern 1 - 1 Rapperswil-Jona Sub 17Rapperswil- ...
24 May 14 Team Bejune Sub 17Team Bejune 0 - 5 FC Vaduz Sub 18Vaduz ...
24 May 14 Fc Basel 1893 Sub 17Basel 1893 2 - 3 FC Zürich Sub 17Zürich ...
24 May 14 Team Ticino Sub 17Team Ticino 1 - 6 FC Thun Sub 17Thun ...
25 May 14 Servette FC Sub 17Servette 3 - 2 FC St. Gallen 1879 Sub 17Gallen 1879 ...
04 Jun 14 BSC Young Boys Sub 17Young Boys 3 - 2 Team Vaud Sub 17Team Vaud ...
Ver jornada
Jornada 22
28 May 14 FC Vaduz Sub 18Vaduz 1 - 3 BSC Young Boys Sub 17Young Boys ...
29 May 14 FC St. Gallen 1879 Sub 17Gallen 1879 1 - 3 Team Bejune Sub 17Team Bejune ...
31 May 14 Rapperswil-Jona Sub 17Rapperswil- 1 - 2 Fc Basel 1893 Sub 17Basel 1893 ...
31 May 14 Team Vaud Sub 17Team Vaud 2 - 1 Team Ticino Sub 17Team Ticino ...
31 May 14 Luzern Sub 17Luzern 0 - 7 FC Thun Sub 17Thun ...
01 Jun 14 FC Zürich Sub 17Zürich 2 - 3 Servette FC Sub 17Servette ...

Clasificación

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  
5,762,688 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0022
Controller Execution Time ( Home / Category )  0.1068
Total Execution Time  0.1090
  CADENA URL  
/liga_suiza_sub172014/grupo1/calendario
  GET DATOS  
$_GET['/liga_suiza_sub172014/grupo1/calendario']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (15)  
0.0018  SELECT type FROM routes WHERE alias = 'liga_suiza_sub172014'
0.0039  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'liga_suiza_sub17' AND (l.group_code = 1 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 2014 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=1 DESC LIMIT 1
0.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=2116 AND type_rel = 3
0.0018  SELECT id,name,alias,stepParent FROM categories WHERE parentId=2116 ORDER BY order_id ASC
0.0019  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.0028  SELECT c.team1, c.team2,c.extra,c.datateam1,c.datateam2,c.type, c.shedule, c.r1, c.r2, c.round, c.comments as total_comentarios, dt1.nameShow as team1_name, dt2.nameShow as team2_name, dt1.basealias as basealias1, dt2.basealias as basealias2, dt1.stadium as stadium_name FROM calendars2014 c INNER JOIN datateams dt1 ON dt1.id = c.datateam1 INNER JOIN datateams dt2 ON dt2.id = c.datateam2 WHERE c.league_id = 63141 ORDER BY round ASC
0.0018  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-04-28 04:55:25' 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-04-28 04:55:25' 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-04-28 04:55:25' 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-04-28 04:55:25' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0023  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'liga_suiza_sub17' AND (l.group_code = 0 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 2014 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=0 DESC LIMIT 1
0.0081  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.0078  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.0027  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.0028  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