4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Jornada 1
24 Jul 09 LocarnoLocarno 1 - 0 Le Mont LSLe Mont LS ...
25 Jul 09 Stade NyonnaisStade 0 - 0 KriensKriens ...
25 Jul 09 WohlenWohlen 1 - 2 FC WilFC Wil ...
25 Jul 09 Lausanne SportsLausanne 0 - 5 FC LuganoFC Lugano ...
25 Jul 09 ServetteServette 2 - 1 FC GossauFC Gossau ...
26 Jul 09 ThunThun 5 - 3 YverdonYverdon ...
26 Jul 09 FC VaduzFC Vaduz 2 - 0 Biel-BienneBiel-Bienne ...
27 Jul 09 SchaffhausenSchaffhause 0 - 0 WinterthurWinterthur ...
Jornada 2
31 Jul 09 KriensKriens 3 - 0 SchaffhausenSchaffhause ...
31 Jul 09 FC LuganoFC Lugano 1 - 2 ThunThun ...
31 Jul 09 Le Mont LSLe Mont LS 1 - 5 WohlenWohlen ...
31 Jul 09 WinterthurWinterthur 2 - 2 LocarnoLocarno ...
02 Ago 09 FC GossauFC Gossau 1 - 1 Lausanne SportsLausanne ...
02 Ago 09 Biel-BienneBiel-Bienne 3 - 0 Stade NyonnaisStade ...
02 Ago 09 YverdonYverdon 3 - 0 FC VaduzFC Vaduz ...
03 Ago 09 FC WilFC Wil 1 - 1 ServetteServette ...
Jornada 3
07 Ago 09 FC WilFC Wil 1 - 1 LocarnoLocarno ...
08 Ago 09 YverdonYverdon 1 - 1 Lausanne SportsLausanne ...
08 Ago 09 Biel-BienneBiel-Bienne 1 - 1 ThunThun ...
08 Ago 09 Le Mont LSLe Mont LS 3 - 2 SchaffhausenSchaffhause ...
08 Ago 09 FC LuganoFC Lugano 2 - 1 ServetteServette ...
09 Ago 09 FC GossauFC Gossau 1 - 3 WohlenWohlen ...
09 Ago 09 FC VaduzFC Vaduz 1 - 0 Stade NyonnaisStade ...
10 Ago 09 WinterthurWinterthur 1 - 0 KriensKriens ...
Jornada 4
14 Ago 09 LocarnoLocarno 2 - 2 FC GossauFC Gossau ...
15 Ago 09 KriensKriens 3 - 3 Le Mont LSLe Mont LS ...
15 Ago 09 Stade NyonnaisStade 2 - 7 WinterthurWinterthur ...
15 Ago 09 Lausanne SportsLausanne 2 - 0 Biel-BienneBiel-Bienne ...
15 Ago 09 SchaffhausenSchaffhause 3 - 2 FC WilFC Wil ...
15 Ago 09 ServetteServette 3 - 3 YverdonYverdon ...
17 Ago 09 WohlenWohlen 0 - 4 FC LuganoFC Lugano ...
19 Ago 09 ThunThun 1 - 1 FC VaduzFC Vaduz ...
Jornada 5
21 Ago 09 LocarnoLocarno 2 - 6 YverdonYverdon ...
22 Ago 09 Stade NyonnaisStade 2 - 1 Le Mont LSLe Mont LS ...
22 Ago 09 WohlenWohlen 1 - 5 Biel-BienneBiel-Bienne ...
22 Ago 09 WinterthurWinterthur 4 - 1 FC WilFC Wil ...
22 Ago 09 Lausanne SportsLausanne 3 - 1 ThunThun ...
22 Ago 09 SchaffhausenSchaffhause 0 - 5 FC LuganoFC Lugano ...
22 Ago 09 ServetteServette 1 - 1 FC VaduzFC Vaduz ...
24 Ago 09 KriensKriens 1 - 1 FC GossauFC Gossau ...
Jornada 6
28 Ago 09 FC LuganoFC Lugano 2 - 2 LocarnoLocarno ...
29 Ago 09 ThunThun 9 - 0 Stade NyonnaisStade ...
29 Ago 09 FC WilFC Wil 3 - 3 KriensKriens ...
29 Ago 09 YverdonYverdon 2 - 0 WohlenWohlen ...
29 Ago 09 Biel-BienneBiel-Bienne 2 - 2 ServetteServette ...
30 Ago 09 Le Mont LSLe Mont LS 1 - 2 WinterthurWinterthur ...
30 Ago 09 FC GossauFC Gossau 1 - 1 SchaffhausenSchaffhause ...
31 Ago 09 FC VaduzFC Vaduz 0 - 1 Lausanne SportsLausanne ...
Jornada 7
11 Sep 09 KriensKriens 3 - 0 Biel-BienneBiel-Bienne ...
12 Sep 09 Le Mont LSLe Mont LS 0 - 2 FC LuganoFC Lugano ...
12 Sep 09 Stade NyonnaisStade 2 - 0 ServetteServette ...
12 Sep 09 WohlenWohlen 1 - 0 Lausanne SportsLausanne ...
12 Sep 09 WinterthurWinterthur 2 - 2 YverdonYverdon ...
12 Sep 09 LocarnoLocarno 0 - 2 ThunThun ...
12 Sep 09 SchaffhausenSchaffhause 1 - 1 FC VaduzFC Vaduz ...
14 Sep 09 FC WilFC Wil 4 - 0 FC GossauFC Gossau ...
Jornada 8
23 Sep 09 Biel-BienneBiel-Bienne 3 - 3 WinterthurWinterthur ...
23 Sep 09 FC GossauFC Gossau 0 - 3 Stade NyonnaisStade ...
23 Sep 09 Lausanne SportsLausanne 2 - 2 LocarnoLocarno ...
23 Sep 09 FC LuganoFC Lugano 0 - 0 FC WilFC Wil ...
23 Sep 09 ThunThun 1 - 0 SchaffhausenSchaffhause ...
23 Sep 09 FC VaduzFC Vaduz 1 - 1 KriensKriens ...
23 Sep 09 YverdonYverdon 1 - 0 Le Mont LSLe Mont LS ...
23 Sep 09 ServetteServette 2 - 2 WohlenWohlen ...
Jornada 9
26 Sep 09 FC LuganoFC Lugano 7 - 0 FC GossauFC Gossau ...
26 Sep 09 ThunThun 4 - 2 KriensKriens ...
26 Sep 09 WohlenWohlen 1 - 1 Stade NyonnaisStade ...
26 Sep 09 Biel-BienneBiel-Bienne 4 - 0 Le Mont LSLe Mont LS ...
26 Sep 09 Lausanne SportsLausanne 1 - 0 SchaffhausenSchaffhause ...
26 Sep 09 ServetteServette 2 - 3 LocarnoLocarno ...
27 Sep 09 FC VaduzFC Vaduz 3 - 2 WinterthurWinterthur ...
28 Sep 09 YverdonYverdon 0 - 1 FC WilFC Wil ...
Jornada 10
02 Oct 09 Stade NyonnaisStade 1 - 3 FC LuganoFC Lugano ...
03 Oct 09 KriensKriens 3 - 3 Lausanne SportsLausanne ...
03 Oct 09 FC WilFC Wil 1 - 1 Biel-BienneBiel-Bienne ...
03 Oct 09 Le Mont LSLe Mont LS 0 - 3 FC VaduzFC Vaduz ...
03 Oct 09 SchaffhausenSchaffhause 2 - 2 ServetteServette ...
04 Oct 09 LocarnoLocarno 1 - 0 WohlenWohlen ...
04 Oct 09 FC GossauFC Gossau 1 - 0 YverdonYverdon ...
05 Oct 09 WinterthurWinterthur 2 - 1 ThunThun ...
Jornada 11
23 Oct 09 LocarnoLocarno 1 - 2 Stade NyonnaisStade ...
24 Oct 09 WohlenWohlen 2 - 4 SchaffhausenSchaffhause ...
24 Oct 09 YverdonYverdon 1 - 1 FC LuganoFC Lugano ...
24 Oct 09 Lausanne SportsLausanne 3 - 0 WinterthurWinterthur ...
24 Oct 09 ServetteServette 1 - 2 KriensKriens ...
24 Oct 09 ThunThun 1 - 2 Le Mont LSLe Mont LS ...
25 Oct 09 Biel-BienneBiel-Bienne 8 - 0 FC GossauFC Gossau ...
26 Oct 09 FC VaduzFC Vaduz 3 - 2 FC WilFC Wil ...
Jornada 12
31 Oct 09 KriensKriens 3 - 2 WohlenWohlen ...
31 Oct 09 Stade NyonnaisStade 0 - 4 YverdonYverdon ...
01 Nov 09 FC LuganoFC Lugano 1 - 1 Biel-BienneBiel-Bienne ...
01 Nov 09 LocarnoLocarno 2 - 2 SchaffhausenSchaffhause ...
01 Nov 09 WinterthurWinterthur 0 - 0 ServetteServette ...
01 Nov 09 Le Mont LSLe Mont LS 1 - 1 Lausanne SportsLausanne ...
01 Nov 09 FC GossauFC Gossau 1 - 4 FC VaduzFC Vaduz ...
02 Nov 09 FC WilFC Wil 0 - 1 ThunThun ...
Jornada 13
07 Nov 09 YverdonYverdon 1 - 1 SchaffhausenSchaffhause ...
07 Nov 09 Lausanne SportsLausanne 0 - 0 Stade NyonnaisStade ...
08 Nov 09 FC VaduzFC Vaduz 4 - 1 WohlenWohlen ...
08 Nov 09 FC WilFC Wil 1 - 0 Le Mont LSLe Mont LS ...
08 Nov 09 Biel-BienneBiel-Bienne 4 - 2 LocarnoLocarno ...
08 Nov 09 ThunThun 1 - 1 ServetteServette ...
08 Nov 09 FC GossauFC Gossau 1 - 2 WinterthurWinterthur ...
09 Nov 09 FC LuganoFC Lugano 2 - 1 KriensKriens ...
Jornada 14
29 Nov 09 KriensKriens 1 - 1 YverdonYverdon ...
29 Nov 09 LocarnoLocarno 4 - 1 FC VaduzFC Vaduz ...
29 Nov 09 SchaffhausenSchaffhause 3 - 2 Biel-BienneBiel-Bienne ...
29 Nov 09 WinterthurWinterthur 1 - 2 FC LuganoFC Lugano ...
29 Nov 09 Le Mont LSLe Mont LS 3 - 2 FC GossauFC Gossau ...
29 Nov 09 ServetteServette 0 - 0 Lausanne SportsLausanne ...
29 Nov 09 Stade NyonnaisStade 0 - 0 FC WilFC Wil ...
24 Feb 10 WohlenWohlen 0 - 1 ThunThun ...
Jornada 15
05 Dic 09 ThunThun 4 - 0 FC GossauFC Gossau ...
05 Dic 09 WohlenWohlen 4 - 4 WinterthurWinterthur ...
05 Dic 09 Lausanne SportsLausanne 2 - 1 FC WilFC Wil ...
06 Dic 09 ServetteServette 4 - 2 Le Mont LSLe Mont LS ...
06 Dic 09 LocarnoLocarno 0 - 0 KriensKriens ...
06 Dic 09 Biel-BienneBiel-Bienne 2 - 1 YverdonYverdon ...
06 Dic 09 Stade NyonnaisStade 2 - 3 SchaffhausenSchaffhause ...
07 Dic 09 FC VaduzFC Vaduz 1 - 1 FC LuganoFC Lugano ...
Jornada 16
15 Feb 10 FC LuganoFC Lugano 1 - 0 YverdonYverdon ...
10 Mar 10 Stade NyonnaisStade 1 - 1 LocarnoLocarno ...
10 Mar 10 KriensKriens 1 - 0 ServetteServette ...
10 Mar 10 FC WilFC Wil 1 - 1 FC VaduzFC Vaduz ...
17 Mar 10 WinterthurWinterthur 5 - 2 Lausanne SportsLausanne ...
17 Mar 10 Le Mont LSLe Mont LS 2 - 4 ThunThun ...
24 Mar 10 FC GossauFC Gossau 2 - 2 Biel-BienneBiel-Bienne ...
21 Abr 10 SchaffhausenSchaffhause 0 - 2 WohlenWohlen ...
Jornada 17
20 Feb 10 YverdonYverdon 1 - 0 Stade NyonnaisStade ...
20 Feb 10 WohlenWohlen 2 - 1 KriensKriens ...
20 Feb 10 ServetteServette 2 - 1 WinterthurWinterthur ...
21 Feb 10 Lausanne SportsLausanne 1 - 2 Le Mont LSLe Mont LS ...
21 Feb 10 FC VaduzFC Vaduz 2 - 0 FC GossauFC Gossau ...
21 Feb 10 ThunThun 1 - 3 FC WilFC Wil ...
22 Feb 10 SchaffhausenSchaffhause 3 - 1 LocarnoLocarno ...
10 Mar 10 Biel-BienneBiel-Bienne 2 - 1 FC LuganoFC Lugano ...
Jornada 18
28 Feb 10 Le Mont LSLe Mont LS 1 - 0 Biel-BienneBiel-Bienne ...
28 Feb 10 SchaffhausenSchaffhause 1 - 0 Lausanne SportsLausanne ...
28 Feb 10 LocarnoLocarno 3 - 0 ServetteServette ...
28 Feb 10 WinterthurWinterthur 4 - 3 FC VaduzFC Vaduz ...
28 Feb 10 FC WilFC Wil 1 - 2 YverdonYverdon ...
28 Feb 10 FC GossauFC Gossau 0 - 1 FC LuganoFC Lugano ...
28 Feb 10 Stade NyonnaisStade 1 - 3 WohlenWohlen ...
01 Mar 10 KriensKriens 0 - 2 ThunThun ...
Jornada 19
06 Mar 10 YverdonYverdon 0 - 1 FC GossauFC Gossau ...
06 Mar 10 ServetteServette 4 - 0 SchaffhausenSchaffhause ...
07 Mar 10 FC VaduzFC Vaduz 0 - 3 Le Mont LSLe Mont LS ...
07 Mar 10 FC LuganoFC Lugano 2 - 1 Stade NyonnaisStade ...
07 Mar 10 Biel-BienneBiel-Bienne 1 - 2 FC WilFC Wil ...
07 Mar 10 Lausanne SportsLausanne 0 - 0 KriensKriens ...
08 Mar 10 ThunThun 4 - 0 WinterthurWinterthur ...
07 Abr 10 WohlenWohlen 3 - 1 LocarnoLocarno ...
Jornada 20
13 Mar 10 YverdonYverdon 5 - 0 LocarnoLocarno ...
13 Mar 10 Le Mont LSLe Mont LS 1 - 2 Stade NyonnaisStade ...
13 Mar 10 ThunThun 2 - 0 Lausanne SportsLausanne ...
14 Mar 10 FC WilFC Wil 0 - 0 WinterthurWinterthur ...
14 Mar 10 FC LuganoFC Lugano 4 - 2 SchaffhausenSchaffhause ...
14 Mar 10 FC VaduzFC Vaduz 1 - 2 ServetteServette ...
15 Mar 10 Biel-BienneBiel-Bienne 1 - 0 WohlenWohlen ...
18 Mar 10 FC GossauFC Gossau 2 - 3 KriensKriens ...
Jornada 21
19 Mar 10 LocarnoLocarno 3 - 2 FC LuganoFC Lugano ...
20 Mar 10 WohlenWohlen 2 - 4 YverdonYverdon ...
20 Mar 10 Lausanne SportsLausanne 2 - 2 FC VaduzFC Vaduz ...
20 Mar 10 ServetteServette 1 - 0 Biel-BienneBiel-Bienne ...
21 Mar 10 WinterthurWinterthur 3 - 0 Le Mont LSLe Mont LS ...
21 Mar 10 SchaffhausenSchaffhause 3 - 1 FC GossauFC Gossau ...
21 Mar 10 Stade NyonnaisStade 1 - 3 ThunThun ...
22 Mar 10 KriensKriens 0 - 1 FC WilFC Wil ...
Jornada 22
26 Mar 10 Lausanne SportsLausanne 1 - 1 WohlenWohlen ...
27 Mar 10 Biel-BienneBiel-Bienne 4 - 1 KriensKriens ...
27 Mar 10 FC VaduzFC Vaduz 1 - 3 SchaffhausenSchaffhause ...
27 Mar 10 ThunThun 3 - 2 LocarnoLocarno ...
27 Mar 10 ServetteServette 3 - 1 Stade NyonnaisStade ...
28 Mar 10 FC LuganoFC Lugano 3 - 0 Le Mont LSLe Mont LS ...
28 Mar 10 FC GossauFC Gossau 1 - 1 FC WilFC Wil ...
29 Mar 10 YverdonYverdon 1 - 3 WinterthurWinterthur ...
Jornada 23
31 Mar 10 KriensKriens 2 - 0 FC VaduzFC Vaduz ...
31 Mar 10 LocarnoLocarno 0 - 2 Lausanne SportsLausanne ...
01 Abr 10 SchaffhausenSchaffhause 2 - 1 ThunThun ...
01 Abr 10 Le Mont LSLe Mont LS 1 - 0 YverdonYverdon ...
03 Abr 10 Stade NyonnaisStade 1 - 0 FC GossauFC Gossau ...
03 Abr 10 WohlenWohlen 1 - 1 ServetteServette ...
03 Abr 10 WinterthurWinterthur 1 - 1 Biel-BienneBiel-Bienne ...
05 Abr 10 FC WilFC Wil 3 - 3 FC LuganoFC Lugano ...
Jornada 24
07 Abr 10 SchaffhausenSchaffhause 3 - 0 Le Mont LSLe Mont LS ...
10 Abr 10 WohlenWohlen 2 - 0 FC GossauFC Gossau ...
10 Abr 10 Stade NyonnaisStade 1 - 0 FC VaduzFC Vaduz ...
10 Abr 10 KriensKriens 0 - 1 WinterthurWinterthur ...
10 Abr 10 Lausanne SportsLausanne 0 - 0 YverdonYverdon ...
10 Abr 10 LocarnoLocarno 1 - 2 FC WilFC Wil ...
11 Abr 10 ServetteServette 2 - 0 FC LuganoFC Lugano ...
12 Abr 10 ThunThun 2 - 2 Biel-BienneBiel-Bienne ...
Jornada 25
14 Abr 10 FC GossauFC Gossau 3 - 3 LocarnoLocarno ...
14 Abr 10 Le Mont LSLe Mont LS 0 - 1 KriensKriens ...
14 Abr 10 WinterthurWinterthur 5 - 1 Stade NyonnaisStade ...
14 Abr 10 YverdonYverdon 1 - 2 ServetteServette ...
14 Abr 10 FC LuganoFC Lugano 2 - 1 WohlenWohlen ...
15 Abr 10 Biel-BienneBiel-Bienne 2 - 2 Lausanne SportsLausanne ...
15 Abr 10 FC VaduzFC Vaduz 0 - 1 ThunThun ...
05 May 10 FC WilFC Wil 1 - 1 SchaffhausenSchaffhause ...
Jornada 26
17 Abr 10 Le Mont LSLe Mont LS 0 - 1 FC WilFC Wil ...
17 Abr 10 WinterthurWinterthur 3 - 1 FC GossauFC Gossau ...
18 Abr 10 SchaffhausenSchaffhause 0 - 0 YverdonYverdon ...
18 Abr 10 LocarnoLocarno 1 - 1 Biel-BienneBiel-Bienne ...
18 Abr 10 Stade NyonnaisStade 1 - 2 Lausanne SportsLausanne ...
18 Abr 10 ServetteServette 2 - 1 ThunThun ...
18 Abr 10 WohlenWohlen 0 - 2 FC VaduzFC Vaduz ...
19 Abr 10 KriensKriens 1 - 1 FC LuganoFC Lugano ...
Jornada 27
24 Abr 10 YverdonYverdon 0 - 1 KriensKriens ...
24 Abr 10 FC WilFC Wil 3 - 3 Stade NyonnaisStade ...
24 Abr 10 Biel-BienneBiel-Bienne 0 - 0 SchaffhausenSchaffhause ...
24 Abr 10 ThunThun 1 - 1 WohlenWohlen ...
25 Abr 10 Lausanne SportsLausanne 1 - 3 ServetteServette ...
25 Abr 10 FC GossauFC Gossau 1 - 2 Le Mont LSLe Mont LS ...
25 Abr 10 FC VaduzFC Vaduz 2 - 1 LocarnoLocarno ...
26 Abr 10 FC LuganoFC Lugano 2 - 0 WinterthurWinterthur ...
Jornada 28
01 May 10 KriensKriens 5 - 3 Stade NyonnaisStade ...
01 May 10 FC WilFC Wil 1 - 0 WohlenWohlen ...
01 May 10 Biel-BienneBiel-Bienne 1 - 0 FC VaduzFC Vaduz ...
01 May 10 WinterthurWinterthur 3 - 0 SchaffhausenSchaffhause ...
01 May 10 Le Mont LSLe Mont LS 0 - 1 LocarnoLocarno ...
02 May 10 FC LuganoFC Lugano 4 - 1 Lausanne SportsLausanne ...
02 May 10 FC GossauFC Gossau 1 - 2 ServetteServette ...
03 May 10 YverdonYverdon 3 - 3 ThunThun ...
Jornada 29
08 May 10 SchaffhausenSchaffhause 1 - 2 KriensKriens ...
08 May 10 WohlenWohlen 0 - 0 Le Mont LSLe Mont LS ...
08 May 10 LocarnoLocarno 1 - 4 WinterthurWinterthur ...
08 May 10 Stade NyonnaisStade 1 - 1 Biel-BienneBiel-Bienne ...
08 May 10 FC VaduzFC Vaduz 3 - 2 YverdonYverdon ...
08 May 10 ServetteServette 1 - 0 FC WilFC Wil ...
10 May 10 ThunThun 1 - 0 FC LuganoFC Lugano ...
12 May 10 Lausanne SportsLausanne 4 - 0 FC GossauFC Gossau ...
Jornada 30
15 May 10 FC GossauFC Gossau 2 - 6 ThunThun ...
15 May 10 WinterthurWinterthur 4 - 3 WohlenWohlen ...
15 May 10 FC WilFC Wil 4 - 2 Lausanne SportsLausanne ...
15 May 10 Le Mont LSLe Mont LS 1 - 2 ServetteServette ...
15 May 10 KriensKriens 6 - 2 LocarnoLocarno ...
15 May 10 YverdonYverdon 2 - 0 Biel-BienneBiel-Bienne ...
15 May 10 SchaffhausenSchaffhause 1 - 3 Stade NyonnaisStade ...
15 May 10 FC LuganoFC Lugano 1 - 1 FC VaduzFC Vaduz ...

Clasificación

Equipo PJ GF GC Puntos
1 Thun Thun 30 70 36 60
2 FC Lugano FC Lugano 30 65 29 59
3 Winterthur Winterthur 30 69 46 56
4 Servette Servette 30 49 37 52
5 Kriens Kriens 30 50 41 46
6 FC Wil FC Wil 30 44 37 45
7 Biel-Bienne Biel-Bienne 30 54 39 42
8 FC Vaduz FC Vaduz 30 44 43 41
9 Yverdon Yverdon 30 50 38 39
10 Lausanne Sports Lausanne 30 40 43 39
11 Schaffhausen Schaffhausen 30 42 51 39
12 Wohlen Wohlen 30 44 55 31
13 Locarno Locarno 30 46 65 31
14 Stade Nyonnais Stade 30 36 64 31
15 Le Mont LS Le Mont LS 30 30 56 27
16 FC Gossau FC Gossau 30 27 80 13

  USO DE MEMORIA  
6,685,448 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0020
Controller Execution Time ( Home / Category )  0.4194
Total Execution Time  0.4214
  CADENA URL  
/segunda_suiza2010/grupo1/calendario
  GET DATOS  
$_GET['/segunda_suiza2010/grupo1/calendario']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (17)  
0.0125  SELECT type FROM routes WHERE alias = 'segunda_suiza2010'
0.0253  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'segunda_suiza' AND (l.group_code = 1 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 2010 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=1 DESC LIMIT 1
0.0125  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=355 AND type_rel = 3
0.0127  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 3 AND rel.typeId = 355 AND rel.ln = 'es' AND rel.status=1 ORDER BY rel.creation_date desc,rel.cover_points DESC LIMIT 5
0.0127  SELECT /*53 bs_news_model*/ n.id, n.author_id, n.headline, n.external_headline, n.live_headline, n.creation_date, n.update_date, n.pub_date, n.alias, n.subheadline, n.teaser, n.media, n.tags, n.views, n.screens, n.clicks, n.relations, n.comments, n.power_cover, n.cover_points, u.name as user_name FROM bs_news n INNER JOIN bs_editors u ON u.id = n.author_id AND u.ln = 'es' WHERE n.status = 1 AND n.ln = 'es' AND n.id IN (1279364,1236274,1213287,1184062,1122166) ORDER BY n.cover_points DESC, update_date DESC
0.0125  SELECT id,name,alias,stepParent FROM categories WHERE parentId=355 ORDER BY order_id ASC
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 = 10179 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0257  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 calendars2010 c INNER JOIN datateams dt1 ON dt1.id = c.datateam1 INNER JOIN datateams dt2 ON dt2.id = c.datateam2 WHERE c.league_id = 10179 ORDER BY round ASC
0.0125  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-05-09 13:14:55' 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-05-09 13:14:55' 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-05-09 13:14:55' 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-05-09 13:14:55' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0130  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'segunda_suiza' AND (l.group_code = 0 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 2010 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=0 DESC LIMIT 1
0.0211  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 events2010 e ON e.player_id = p.id AND e.league_id = 10179 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 10179 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.0238  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 events2010 e ON e.player_id = p.id AND e.league_id = 10179 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 10179 AND (e.action = 4 or e.action = 5) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0135  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 events2010 e ON e.player_id = p.id AND e.league_id = 10179 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 10179 AND (e.action = 3 or e.action = 4) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0136  SELECT *,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables2010` 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 = 10179 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC