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

Clasificación

Equipo PJ GF GC Puntos
1 St. Gallen St. Gallen 30 78 22 78
2 FC Lugano FC Lugano 30 72 30 70
3 FC Wil FC Wil 30 41 25 51
4 Yverdon Yverdon 30 52 41 51
5 Biel-Bienne Biel-Bienne 30 58 53 47
6 Wohlen Wohlen 30 43 47 45
7 Lausanne Sports Lausanne 30 41 43 41
8 Concordia Basel Concordia 30 48 51 40
9 Thun Thun 30 54 65 38
10 Winterthur Winterthur 30 45 46 36
11 Schaffhausen Schaffhausen 30 40 45 34
12 La Chaux-de-Fonds Chaux-de-Fon 30 39 46 33
13 Servette Servette 30 31 46 31
14 Stade Nyonnais Stade 30 26 56 28
15 Locarno Locarno 30 46 56 26
16 FC Gossau FC Gossau 30 27 69 19

  USO DE MEMORIA  
6,705,576 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0019
Controller Execution Time ( Home / Category )  0.1621
Total Execution Time  0.1640
  CADENA URL  
/segunda_suiza2009/grupo1/calendario
  GET DATOS  
$_GET['/segunda_suiza2009/grupo1/calendario']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (11)  
0.0018  SELECT id,name,alias,stepParent FROM categories WHERE parentId=355 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 = 10180 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0047  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 calendars2009 c INNER JOIN datateams dt1 ON dt1.id = c.datateam1 INNER JOIN datateams dt2 ON dt2.id = c.datateam2 WHERE c.league_id = 10180 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 18:44:56' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0019  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=2 AND last_update > '2024-04-28 18:44:56' 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 18:44:56' 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 18:44:56' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0113  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 events2009 e ON e.player_id = p.id AND e.league_id = 10180 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 10180 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.0108  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 events2009 e ON e.player_id = p.id AND e.league_id = 10180 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 10180 AND (e.action = 4 or e.action = 5) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0071  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 events2009 e ON e.player_id = p.id AND e.league_id = 10180 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 10180 AND (e.action = 3 or e.action = 4) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0045  SELECT *,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables2009` 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 = 10180 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC