Información Histórica
						

Nationalliga B - Qualifying Phase East
  
1  FC Luzern                   	22   13   7   2   41  12   33
2  FC Winterthur            	22   13   6   3   46  21   32
3  FC Locarno                 	22   10  10   2   38  22   30
4  FC Schaffhausen          	22   11   7   4   38  23   29
5  FC Wil 1900              	22    9   8   5   32  19   26
6  SC Kriens                	22    9   7   6   39  26   25
7  FC Baden                 	22    7   9   6   27  28   23
8  AC Bellinzona           	22    3   8  11   28  44   14
-------------------------------------------------------------
9  FC Chur                  	22    3   8  11   23  44   14
10 FC Wettingen            	22    5   3  14   18  39   13
11 FC Emmenbrücke            	22    4   5  13   20  42   13
12 FC Brüttisellen           	22    5   2  15   23  53   12


1st round 
[July 18]
Bellinzona	1-1 Baden
Brüttisellen	2-4 Schaffhausen
Emmenbrücke	2-1 Chur
Kriens		1-1 Locarno
Winterthur	0-2 Luzern
Wettingen	0-0 Wil

2nd round 
[July 22]
Baden		0-0 Brüttisellen
Chur		3-2 Bellinzona
Locarno		2-1 Emmenbrücke
Kriens		0-3 Luzern
Schaffhausen	3-0 Wettingen
Wil		1-2 Winterthur

3rd round
[July 25]
Brüttisellen	1-5 Locarno
Wettingen	0-1 Chur
Emmenbrücke	0-2 Wil
Kriens		1-0 Schaffhausen
Bellinzona	1-3 Luzern
Winterthur	0-0 Baden

4th round
[July 31-Aug 1st]
Baden		2-2 Emmenbrücke
Chur		1-3 Kriens
Locarno		1-1 Winterthur
Luzern		3-0 Wettingen
Schaffhausen	3-2 Bellinzona
Wil		4-0 Brüttisellen

5th round
[Aug 8]
Bellinzona	2-2 Wil
Brüttisellen	1-0 Luzern
Emmenbrücke	1-2 Schaffhausen
Kriens		3-1 Baden
Wettingen	0-1 Locarno
Winterthur	2-2 Chur

6th round
[Aug 11-12]
Baden		2-0 Wettingen
Chur		2-1 Brüttisellen
Locarno		1-0 Bellinzona
Luzern		1-1 Emmenbrücke
Schaffhausen	0-0 Winterthur
Wil		2-2 Kriens

7th round
[Aug 15]
Wil		0-0 Luzern
[Aug 18]
Baden		0-5 Schaffhausen
Brüttisellen	5-5 Bellinzona
Emmenbrücke	0-4 Kriens
Locarno		3-0 Chur
Winterthur	4-0 Wettingen

8th round
[Aug 25-26]
Bellinzona	2-2 Emmenbrücke
Wettingen	3-1 Brüttisellen
Chur		0-4 Baden
Kriens		1-3 Winterthur
Luzern		1-1 Locarno
Schaffhausen	1-1 Wil

9th round
[Aug 29]
Brüttisellen	1-4 Kriens
Luzern		1-1 Schaffhausen
Wettingen	4-1 Bellinzona
Wil		2-0 Chur
Winterthur	4-1 Emmenbrücke
[Sep 5]
Locarno		0-0 Baden

10th round
[Sep 1st-2]
Baden		0-3 Wil
Bellinzona	1-2 Winterthur
Chur		0-3 Luzern
Emmenbrücke	0-2 Brüttisellen
Kriens		0-0 Wettingen
Schaffhausen	2-2 Locarno

11th round
[Sep 12]
Bellinzona	1-1 Kriens
Chur		1-0 Schaffhausen
Luzern		3-0 Baden
Wettingen	3-2 Emmenbrücke
Wil		0-2 Locarno
Winterthur	3-1 Brüttisellen

12th round
[Sep 19]
Baden		1-0 Bellinzona
Chur		1-1 Emmenbrücke
Locarno		2-2 Kriens
Luzern		1-0 Winterthur
Schaffhausen	4-2 Brüttisellen
Wil		0-2 Wettingen

13th round
[Sep 26]
Bellinzona	1-1 Chur
Brüttisellen	0-4 Baden
Emmenbrücke	1-1 Locarno
Luzern		1-0 Kriens
Wettingen	0-1 Schaffhausen
Winterthur	3-0 Wil

14th round
[Oct 6-7]
Baden		0-2 Winterthur
Chur		4-1 Wettingen
Locarno		1-0 Brüttisellen
Luzern		2-1 Bellinzona
Schaffhausen	2-1 Kriens
Wil		3-0 Emmenbrücke

15th round
[Oct 10]
Baden		1-1 Luzern
Brüttisellen	0-3 Winterthur
Emmenbrücke	2-0 Wettingen
Kriens		4-0 Bellinzona
Locarno		1-1 Wil
Schaffhausen	1-0 Chur

16th round
[Oct 16-17]
Kriens		2-0 Chur
Bellinzona	1-1 Schaffhausen
Brüttisellen	0-2 Wil
Wettingen	1-3 Luzern
Winterthur	0-3 Locarno
[Oct 27]
Emmenbrücke	1-3 Baden

17th round
[Oct 24]
Baden		1-1 Kriens
Chur		2-2 Winterthur
Locarno		4-2 Wettingen
Luzern		1-2 Brüttisellen
Schaffhausen	0-1 Emmenbrücke
Wil		3-0 Bellinzona

18th round
[Oct 31-Nov 1st]
Bellinzona	2-0 Locarno
Brüttisellen	2-1 Chur
Emmenbrücke	0-4 Luzern
Wettingen	0-1 Baden
Winterthur	1-1 Schaffhausen
[Nov 11]
Kriens		1-1 Wil

19th round
[Nov 8]
Bellinzona	1-0 Brüttisellen
Chur		1-3 Locarno
Kriens		2-0 Emmenbrücke
Luzern		0-0 Wil
Schaffhausen	1-1 Baden
Wettingen	0-3 Winterthur

20th round
[Nov 14]
Baden		3-1 Chur
Brüttisellen	2-0 Wettingen
Emmenbrücke	0-1 Bellinzona
Locarno		1-1 Luzern
Wil		1-2 Schaffhausen
Winterthur	4-0 Kriens

21th round
[Nov 22]
Baden		2-2 Locarno
Bellinzona	0-0 Wettingen
Chur		1-2 Wil
Emmenbrücke	1-2 Winterthur
Kriens		5-0 Brüttisellen
Schaffhausen	1-3 Luzern

22th round
[Nov 29]
Brüttisellen	0-1 Emmenbrücke
Locarno		1-3 Schaffhausen
Luzern		4-0 Chur
Wettingen	2-1 Kriens
Wil		2-0 Baden
Winterthur	5-3 Bellinzona


Nationalliga B - Qualifying Phase East

Final table :
  
1  FC Luzern                   	22   13   7   2   41  12   33
2  FC Winterthur            	22   13   6   3   46  21   32
3  FC Locarno                 	22   10  10   2   38  22   30
4  FC Schaffhausen          	22   11   7   4   38  23   29
5  FC Wil 1900              	22    9   8   5   32  19   26
6  SC Kriens                	22    9   7   6   39  26   25
7  FC Baden                 	22    7   9   6   27  28   23
8  AC Bellinzona           	22    3   8  11   28  44   14
-------------------------------------------------------------
9  FC Chur                  	22    3   8  11   23  44   14
10 FC Wettingen            	22    5   3  14   18  39   13
11 FC Emmenbrücke            	22    4   5  13   20  42   13
12 FC Brüttisellen           	22    5   2  15   23  53   12

Topscorers :

1. Vukic Miroslav (YUG)		12  SC Kriens
2. Triebold Frank		11  SC Kriens
   Allenspach Adrian		11  FC Schaffhausen
4. Moreira Marcio (BRA)		10  FC Locarno
   Engesser Joachim (GER)	10  FC Schaffhausen
   Müller Sascha		10  FC Winterthur
7. Ljubisavljevic Sasa (YUG)	 8  Brüttisellen
   Urs Güntensperger		 8  FC Luzern
   Löw Joachim (GER)		 8  FC Winterthur
   Thoma Axel (GER)		 8  FC Winterthur


Nationalliga B - Qualifying Phase West

1  Yverdon-Sport          	22   17   3   2   60  24   37
2  FC Basel                 	22   16   4   2   54  10   36
3  FC Etoile Carouge       	22   14   0   8   48  32   28
4  CS Chênois               	22   12   2   8   37  39   26
5  FC Grenchen              	22   11   3   8   40  25   25
6  SR Delémont              	22    8   5   9   31  33   21
7  Urania-Genève-Sport      	22    7   4  11   33  43   18
8  BSC Old Boys Basel       	22    5   7  10   27  39   17
-------------------------------------------------------------
9  FC Fribourg               	22    7   3  12   29  42   17
10 SC Bümpliz 78              	22    5   5  12   26  52   15
11 FC Châtel-St-Denis         	22    2   8  12   25  47   12
12 FC La Chaux-de-Fonds       	22    4   4  14   25  49   12


1st round 
[July 18]
Etoile Carouge	4-1 Bümpliz
Grenchen	1-0 Basel
La Chaux-de-F.	1-1 Châtel
Chênois		4-2 Fribourg
Old Boys	1-2 Delémont
Yverdon		4-0 UGS

2nd round 
[July 21-22]
Basel		2-0 Etoile Carouge
Bümpliz		2-2 Old Boys
Châtel		1-2 Yverdon
Delémont	1-1 Chênois
Fribourg	2-0 La Chaux-de-F.
UGS		1-0 Grenchen

3rd round
[July 25]
Etoile Carouge	3-0 Châtel
Chênois		2-2 Basel
Grenchen	1-0 Fribourg
La Chaux-de-F.	0-0 Bümpliz
Old Boys	3-2 UGS
Yverdon		2-1 Delémont

4th round
[July 31-Aug 1st]
Basel		0-0 Yverdon
Bümpliz		5-1 Grenchen
Châtel		2-4 Chênois
Delémont	1-0 Etoile Carouge
Fribourg	0-0 Old Boys
UGS		3-1 La Chaux-de-F.

5th round
[Aug 8]
Etoile Carouge	4-1 Fribourg
Chênois		1-2 UGS
Grenchen	4-2 Delémont
La Chaux-de-F.	0-3 Basel
Old Boys	2-1 Châtel
Yverdon		1-0 Bümpliz

6th round
[Aug 11-12]
Basel		3-0 Old Boys
Bümpliz		0-1 Chênois
UGS		0-2 Etoile Carouge
Châtel		1-1 Grenchen
Delémont	4-2 La Chaux-de-F.
Fribourg	3-3 Yverdon

7th round
[Aug 18-19]
Basel		7-0 Bümpliz
Etoile Carouge	0-1 Grenchen
Châtel		1-1 UGS
Chênois		2-1 Old Boys
Delémont	3-0 Fribourg
Yverdon		5-0 La Chaux-de-F.

8th round
[Aug 25-26]
Bümpliz		1-3 Delémont
Fribourg	2-2 Châtel
Grenchen	1-2 Yverdon
La Chaux-de-F.	0-1 Chênois
Old Boys	1-3 Etoile Carouge
UGS		3-5 Basel

9th round
[Aug 29]
Châtel		1-1 Basel
Chênois		2-3 Yverdon
Etoile Carouge	1-3 La Chaux-de-F.
Delémont	1-0 UGS
Fribourg	1-2 Bümpliz
Old Boys	0-2 Grenchen

10th round
[Sep 1st-2]
Basel		1-0 Delémont
Bümpliz		1-2 Châtel
Grenchen	0-1 Chênois
La Chaux-de-F.	2-2 Old Boys
UGS		4-2 Fribourg
Yverdon		2-3 Etoile Carouge

11th round
[Sep 12]
Chênois		1-3 Etoile Carouge
Delémont	3-3 Châtel
Fribourg	0-3 Basel
Grenchen	4-0 La Chaux-de-F.
Old Boys	1-1 Yverdon
UGS		7-2 Bümpliz

12th round
[Sep 19]
Basel		2-0 Grenchen
Bümpliz		0-2 Etoile Carouge
Châtel		3-1 La Chaux-de-F.
Delémont	1-1 Old Boys
Fribourg	1-0 Chênois
UGS		0-2 Yverdon

13th round
[Sep 26]
Chênois		2-1 Delémont
Etoile Carouge	0-1 Basel
Grenchen	0-0 UGS
La Chaux-de-F.	3-1 Fribourg
Old Boys	1-1 Bümpliz
Yverdon		4-2 Châtel

14th round
[Oct 6-7]
Basel		3-0 Chênois
Bümpliz		3-1 La Chaux-de-F.
Châtel		1-3 Etoile Carouge
Delémont	2-3 Yverdon
Fribourg	0-2 Grenchen
UGS		1-3 Old Boys

15th round
[Oct 10-11]
Basel		3-0 Fribourg
Bümpliz		2-1 UGS
Châtel		0-0 Delémont
Etoile Carouge	4-1 Chênois
La Chaux-de-F.	2-1 Grenchen
Yverdon		3-0 Old Boys

16th round
[Oct 16-17-18]
Chênois		2-1 Châtel
Etoile Carouge	5-2 Delémont
Old Boys	0-5 Fribourg
Grenchen	8-1 Bümpliz
Yverdon		3-1 Basel
[Oct 28]
La Chaux-de-F.	1-1 UGS

17th round
[Oct 24]
Basel		2-0 La Chaux-de-F.
Châtel		0-4 Old Boys
Delémont	1-4 Grenchen
Fribourg	2-3 Etoile Carouge
UGS		2-1 Chênois
[Nov 4]
Bümpliz		2-4 Yverdon

18th round
[Oct 31]
Etoile Carouge	2-2 UGS			[awd : 0-3 forfeit]*
* Plus de 6 joueurs non-Suisses ont joués pour Carouge
Chênois		3-0 Bümpliz
Grenchen	4-1 Châtel
La Chaux-de-F.	0-1 Delémont
Old Boys	0-3 Basel
Yverdon		5-2 Fribourg

19th round
[Nov 8]
Bümpliz		0-0 Basel
Fribourg	1-0 Delémont
Grenchen	2-3 Etoile Carouge
La Chaux-de-F.	1-3 Yverdon
Old Boys	1-2 Chênois
UGS		1-1 Châtel

20th round
[Nov 14]
Basel		8-0 UGS
Châtel		0-1 Fribourg
Chênois		3-2 La Chaux-de-F.
Etoile Carouge	2-1 Old Boys
Delémont	0-0 Bümpliz
Yverdon		0-1 Grenchen

21th round
[Nov 22]
Basel		3-0 Châtel
Bümpliz		0-2 Fribourg
La Chaux-de-F.	4-2 Etoile Carouge
UGS		1-2 Delémont
Yverdon		6-0 Chênois
[Nov 25]
Grenchen	0-0 Old Boys

22th round
[Nov 29]
Châtel		1-3 Bümpliz
Chênois		3-2 Grenchen
Etoile Carouge	1-2 Yverdon
Delémont	0-1 Basel
Fribourg	1-0 UGS
Old Boys	3-1 La Chaux-de-F.


Nationalliga B - Qualifying Phase West

Final table :

1  Yverdon-Sport          	22   17   3   2   60  24   37
2  FC Basel                 	22   16   4   2   54  10   36
3  FC Etoile Carouge       	22   14   0   8   48  32   28
4  CS Chênois               	22   12   2   8   37  39   26
5  FC Grenchen              	22   11   3   8   40  25   25
6  SR Delémont              	22    8   5   9   31  33   21
7  Urania-Genève-Sport      	22    7   4  11   33  43   18
8  BSC Old Boys Basel       	22    5   7  10   27  39   17
-------------------------------------------------------------
9  FC Fribourg               	22    7   3  12   29  42   17
10 SC Bümpliz 78              	22    5   5  12   26  52   15
11 FC Châtel-St-Denis         	22    2   8  12   25  47   12
12 FC La Chaux-de-Fonds       	22    4   4  14   25  49   12


Topscorers :

1. Sitek André (NED)		20  FC Basel
2. Comisetti Alexandre		17  Yverdon-Sport
3. Oranci Jean-Emilio		14  Urania-Genève-Sport
4. Stevic Miroslav (YUG)	12  FC La Chaux-de-Fonds
5. Wenger Andreas		11  FC Grenchen
6. Rahmen Patrick		10  FC Basel
   Maiano Michel		10  SC Bümpliz
   Urosevic Mile (YUG)		10  Yverdon-Sport
9. Taddeo Christian		 8  CS Chênois
   Castella Gilbert 		 8  Etoile Carouge



Nationalliga B - Relegation Group A                            (*)

1  AC Bellinzona               	10    6   3   1   20   9   15   5  20
2  FC Fribourg                	10    5   3   2   16  13   13   4  17
---------------------------------------------------------------------
3  Urania-Genève-Sport      	10    4   3   3   15  17   11   6  17 (1)
---------------------------------------------------------------------
4  FC Wettingen                	10    6   0   4   20  13   12   3  15 Relegated
5  FC Châtel-St-Denis         	10    2   1   7   14  24    5   2   7 Relegated
6  FC Brüttisellen             	10    0   4   6    8  17    4   1   5 Relegated

(*) bonus points from qualifying groups (7th place 6 pts; 8th place 5 pts; etc)


1st round
[March 14]
Wettingen	3-1 Châtel
Bellinzona	1-0 Brüttisellen
UGS		3-0 Fribourg

2nd round
[March 28]
Wettingen	5-0 UGS
Fribourg	0-0 Bellinzona
Châtel		2-0 Brüttisellen

3rd round
[April 3-4]
Brüttisellen	1-2 Fribourg
Bellinzona	2-0 Wettingen
UGS		2-1 Châtel

4th round
[April 10]
Wettingen	1-0 Brüttisellen
UGS		4-4 Bellinzona
Châtel		1-1 Fribourg

5th round
[April 17]
Brüttisellen	2-2 UGS
Bellinzona	4-1 Châtel
Fribourg	2-1 Wettingen

6th round
[April 24-25]
Wettingen	0-2 Fribourg
Châtel		0-3 Bellinzona
UGS		1-1 Brüttisellen

7th round
[May 8]
Brüttisellen 	1-2 Wettingen
Bellinzona	0-1 UGS
Fribourg	4-2 Châtel

8th round
[May 15]
Châtel		0-2 UGS
Fribourg	2-2 Brüttisellen
Wettingen	1-2 Bellinzona

9th round
[May 22]
Bellinzona	3-1 Fribourg
Brüttisellen	0-3 Châtel
UGS		0-2 Wettingen

10th round
[May 29]
Brüttisellen	1-1 Bellinzona
Châtel		3-5 Wettingen
Fribourg	2-0 UGS


Nationalliga B - Relegation Group A                            

Final table :
                                                               (*)

1  AC Bellinzona               	10    6   3   1   20   9   15   5  20
2  FC Fribourg                	10    5   3   2   16  13   13   4  17
---------------------------------------------------------------------
3  Urania-Genève-Sport      	10    4   3   3   15  17   11   6  17 (1)
---------------------------------------------------------------------
4  FC Wettingen                	10    6   0   4   20  13   12   3  15 Relegated
5  FC Châtel-St-Denis         	10    2   1   7   14  24    5   2   7 Relegated
6  FC Brüttisellen             	10    0   4   6    8  17    4   1   5 Relegated

(*) bonus points from qualifying groups (7th place 6 pts; 8th place 5 pts; etc)


Nationalliga B - Relegation Group B                            (*)

1  BSC Old Boys Basel           10    8   0   2   32  15   16   5  21 
2  FC Baden                  	10    4   3   3   23  26   11   6  17
---------------------------------------------------------------------
3  SC Bümpliz                	10    4   2   4   14  14   10   3  13 Relegated (1)
---------------------------------------------------------------------
4  FC Emmenbrücke             	10    4   1   5   17  18    9   2  11 Relegated
5  FC Chur                     	10    2   2   6   14  21    6   4  10 Relegated
6  FC La Chaux-de-Fonds        	10    2   4   4    7  13    8   1   9 Relegated

(*) bonus points from qualifying groups (7th place 6 pts; 8th place 5 pts; etc)


1st round
[March 14]
Emmenbrücke	2-1 Bümpliz
Chaux-de-Fonds	0-3 Baden
Chur 		3-4 Old Boys

2nd round
[March 28]
Emmenbrücke	1-2 Chur
Old Boys	4-0 Chaux-de-Fonds
Bümpliz		2-2 Baden

3rd round
[April 3]
Baden		2-1 Old Boys
Chur 		0-1 Bümpliz
[April 13]
Chaux-de-Fonds	0-0 Emmenbrücke

4th round
[April 10]
Emmenbrücke	3-1 Baden
Chur 		0-0 Chaux-de-Fonds
Bümpliz		0-3 Old Boys

5th round
[April 17]
Baden		1-0 Chur
Chaux-de-Fonds	0-1 Bümpliz 
Old Boys	2-1 Emmenbrücke

6th round
[April 24]
Emmenbrücke	2-4 Old Boys
Chur 		4-4 Baden
Bümpliz		0-0 Chaux-de-Fonds

7th round
[May 8]
Baden		0-3 Emmenbrücke
Chaux-de-Fonds	2-0 Chur 
Old Boys	2-0 Bümpliz

8th round
[May 15]
Bümpliz		3-0 Chur
Emmenbrücke	3-1 Chaux-de-Fonds
Old Boys	9-3 Baden

9th round
[May 22]
Baden		5-2 Bümpliz 
Chaux-de-Fonds	2-0 Old Boys
Chur		3-2 Emmenbrücke

10th round
[May 29]
Baden		2-2 Chaux-de-Fonds
Bümpliz		4-0 Emmenbrücke
Old Boys	3-2 Chur 


Nationalliga B - Relegation Group B

Final table :
                                                               (*)

1  BSC Old Boys Basel           10    8   0   2   32  15   16   5  21 
2  FC Baden                  	10    4   3   3   23  26   11   6  17
---------------------------------------------------------------------
3  SC Bümpliz                	10    4   2   4   14  14   10   3  13 Relegated (1)
---------------------------------------------------------------------
4  FC Emmenbrücke             	10    4   1   5   17  18    9   2  11 Relegated
5  FC Chur                     	10    2   2   6   14  21    6   4  10 Relegated
6  FC La Chaux-de-Fonds        	10    2   4   4    7  13    8   1   9 Relegated

(*) bonus points from qualifying groups (7th place 6 pts; 8th place 5 pts; etc)


(1) Nationalliga B - Relegation : Playoff 3rd-placed teams 
[June 5 and 12]   
Urania-Geneve-Sport	2-0 4-1 Bümpliz

FC Wettingen restart at 5th level due to liquidity problems



Author:
Erik Garin
(garinerik@hispeed.ch)

Last updated: 26 Oct 2006

(C) Copyright Erik Garin and RSSSF 1999/2006
						

Uso de cookies: Utilizamos "cookies" propias y de terceros para mejorar nuestros servicios, elaborar información estadística, analizar sus hábitos de navegación e inferir grupos de interés. Esto nos permite personalizar el contenido que ofrecemos y mostrarle publicidad relacionada con sus preferencias. Adicionalmente, compartimos los análisis de navegación y los grupos de interés inferidos con terceros. Si continúa navegando acepta su uso. Más información y cambio de configuración. Aceptar

  USO DE MEMORIA  
4,364,888 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0018
Controller Execution Time ( Home / Category )  0.1720
Total Execution Time  0.1738
  CADENA URL  
/segunda_suiza1993
  GET DATOS  
$_GET['/segunda_suiza1993']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (38)  
0.0034  SELECT type FROM routes WHERE alias = 'segunda_suiza1993'
0.0070  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 = 1993 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=1 DESC LIMIT 1
0.0034  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=355 AND type_rel = 3
0.0039  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.0038  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.0040  SELECT text_es as historical_text FROM leagues_text WHERE id=1605
0.0035  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 = 29877 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0036  SELECT c.id, c.name, c.alias, c.stepParent, l.year FROM categories AS c INNER JOIN leagues AS l ON c.id=l.categoryId AND l.year='1993' WHERE c.parentId=355 GROUP BY c.id ORDER BY c.order_id ASC
0.0034  SELECT type,rule FROM rules WHERE categoryId = 355 ORDER BY type = 'tables_draw' DESC,type != 'extra' DESC, `order` ASC
0.0034  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-03-28 23:39:00' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0034  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=2 AND last_update > '2024-03-28 23:39:00' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0034  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=4 AND last_update > '2024-03-28 23:39:00' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0034  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=3 AND last_update > '2024-03-28 23:39:00' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0038  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 = 1993 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=0 DESC LIMIT 1
0.0035  SELECT e.action, count(e.action) as total, e.player_id FROM events1993 e WHERE e.league_id IN (29877) AND (e.action IN (1,2,11,12,13) ) GROUP BY e.player_id ORDER BY total DESC, e.player_id ASC LIMIT 20
0.0034  SELECT dp.name, dp.last_name, dp.nick,dp.CountryCode,dp.alias,rp.team_id,dt.nameShow,dt.short_name,dt.basealias,rp.player_id,rp.teamId,dp.role FROM dataplayers AS dp INNER JOIN rel_players AS rp ON rp.player_id=dp.id AND rp.league_id IN (29877) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN () ORDER BY rp.in_squad = 1 DESC
0.0035  SELECT e.action, count(e.action) as total, e.player_id FROM events1993 e WHERE e.league_id IN (29877) AND (e.action IN (4,5) ) GROUP BY e.player_id ORDER BY total DESC, e.player_id ASC LIMIT 20
0.0034  SELECT dp.name, dp.last_name, dp.nick,dp.CountryCode,dp.alias,rp.team_id,dt.nameShow,dt.short_name,dt.basealias,rp.player_id,rp.teamId,dp.role FROM dataplayers AS dp INNER JOIN rel_players AS rp ON rp.player_id=dp.id AND rp.league_id IN (29877) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN () ORDER BY rp.in_squad = 1 DESC
0.0037  SELECT e.action, count(e.action) as total, e.player_id FROM events1993 e WHERE e.league_id IN (29877) AND (e.action IN (3,4) ) GROUP BY e.player_id ORDER BY total DESC, e.player_id ASC LIMIT 20
0.0034  SELECT dp.name, dp.last_name, dp.nick,dp.CountryCode,dp.alias,rp.team_id,dt.nameShow,dt.short_name,dt.basealias,rp.player_id,rp.teamId,dp.role FROM dataplayers AS dp INNER JOIN rel_players AS rp ON rp.player_id=dp.id AND rp.league_id IN (29877) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN () ORDER BY rp.in_squad = 1 DESC
0.0037  SELECT e.action, count(e.action) as total, e.player_id FROM events1993 e WHERE e.league_id IN (29877) AND (e.action IN (22) ) GROUP BY e.player_id ORDER BY total DESC, e.player_id ASC LIMIT 20
0.0035  SELECT dp.name, dp.last_name, dp.nick,dp.CountryCode,dp.alias,rp.team_id,dt.nameShow,dt.short_name,dt.basealias,rp.player_id,rp.teamId,dp.role FROM dataplayers AS dp INNER JOIN rel_players AS rp ON rp.player_id=dp.id AND rp.league_id IN (29877) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN () ORDER BY rp.in_squad = 1 DESC
0.0034  SELECT rp.lineup 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,p.role FROM `rel_players` rp INNER JOIN dataplayers p ON p.id = rp.player_id INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 29877 AND rp.lineup > 0 ORDER BY rp.lineup DESC,p.pod DESC LIMIT 20
0.0034  SELECT rp.events 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,p.role FROM `rel_players` rp INNER JOIN dataplayers p ON p.id = rp.player_id INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 29877 AND rp.events > 0 ORDER BY rp.events DESC,p.pod DESC LIMIT 20
0.0040  SELECT rel.media_id, rel.team1, rel.team2, m.name, m.type, m.lang, m.location, rel.id AS rel_id, m.url FROM rel_media_match AS rel INNER JOIN media AS m ON m.id=rel.media_id WHERE (m.lang='es' OR m.language='spanish') AND rel.active=1 AND rel.league_id=29877 AND rel.round=22
0.0037  SELECT u.id,u.user_name, esl.points,up.name,up.surname,up.nick,u.changeA FROM editor_stats_leagues esl INNER JOIN fa_user u ON u.id = esl.user_id INNER JOIN fa_user_profile up ON up.id = esl.user_id WHERE esl.league_id = 29877 AND esl.points > 0 ORDER BY esl.points DESC LIMIT 3
0.0036  SELECT count(esl.user_id) as cuenta FROM editor_stats_leagues esl INNER JOIN fa_user u ON u.id = esl.user_id INNER JOIN fa_user_profile up ON up.id = esl.user_id WHERE esl.league_id = 29877 AND esl.points > 0
0.0037  SELECT fau.user_name, c.*, NOW() as difference_time,creation_date FROM (leagues as l) INNER JOIN comments as c ON c.league_id = l.id LEFT JOIN fa_user fau ON fau.id = c.author_id WHERE c.creation_date > "2024-02-28" AND c.`active`= 1 and c.comment_id is null and c.lang = 1 AND l.`id` = 29877 ORDER BY creation_date DESC LIMIT 0, 10
0.0041  SELECT count(c.id) as cuenta FROM (leagues as l) INNER JOIN comments as c ON c.league_id = l.id WHERE c.creation_date > "2024-02-28" AND c.`active`= 1 and comment_id is null and c.lang = 1 AND l.`id` = 29877
0.0036  SELECT c.isVideo, c.id,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,c.betId,c.betId_wh,c.betId_bwin,c.betId_marca,c.betId_888, c.betId_sportium, c.betId_marathon, c.finished, c.penaltis1, c.penaltis2, c.prorroga, c.status, c.minute, dt1.stadium as stadium_name FROM `calendars1993` as c INNER JOIN teams t1 ON t1.id = c.team1 AND t1.league_id = c.league_id INNER JOIN teams t2 ON t2.id = c.team2 AND t2.league_id = c.league_id INNER JOIN datateams as dt1 ON dt1.id = t1.teamId INNER JOIN datateams as dt2 ON dt2.id = t2.teamId WHERE c.`league_id` = 29877 AND c.`round` = 22 ORDER BY shedule ASC LIMIT 200
0.0034  SELECT (dt1.qod+dt2.qod+dt1.relations+dt2.relations) as total,c.r1,c.r2,e.action,ev.showName as eventName,ev.largeName,ev.main_action,ev.keyname,ev.classf,e.real_date,e.minute, dp.nick,dp.CountryCode,dp.alias,c.datateam1,c.datateam2,dt1.nameShow as nameShow1,dt2.nameShow as nameShow2,dt1.basealias as basealias1,dt2.basealias as basealias2,e.player_id,e.match_id FROM `events1993` e INNER JOIN calendars1993 c ON c.id = e.match_id INNER JOIN events ev ON ev.id = e.action INNER JOIN dataplayers dp ON dp.id = e.player_id INNER JOIN datateams dt1 ON dt1.id = c.datateam1 INNER JOIN datateams dt2 ON dt2.id = c.datateam2 WHERE ev.main_action = 1 AND c.round = 22 AND e.real_date IS NOT NULL AND e.league_id = 29877 ORDER BY total DESC LIMIT 40
0.0036  SELECT c.r1,c.r2,e.action,ev.showName as eventName,ev.largeName,ev.main_action,ev.keyname,ev.classf,e.real_date,e.minute, dp.nick,dp.CountryCode,dp.alias,c.datateam1,c.datateam2,dt1.nameShow as nameShow1,dt2.nameShow as nameShow2,dt1.basealias as basealias1,dt2.basealias as basealias2,e.player_id,e.match_id FROM `events1993` e INNER JOIN calendars1993 c ON c.id = e.match_id INNER JOIN events ev ON ev.id = e.action INNER JOIN dataplayers dp ON dp.id = e.player_id INNER JOIN datateams dt1 ON dt1.id = c.datateam1 INNER JOIN datateams dt2 ON dt2.id = c.datateam2 WHERE ev.show_on = 1 AND e.real_date IS NOT NULL AND e.league_id = 29877 AND e.real_date > NOW() - INTERVAL 1 MONTH ORDER BY e.real_date DESC LIMIT 30
0.0038  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 `tables1993` 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 = 29877 AND t.round = 20 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0038  SELECT *,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables1993` 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 = 29877 AND t.round = 22 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0038  SELECT c.id, 2024 AS year, IF(l.tables = 1 AND t1.points>0,((t1.points / (l.current_round * 3)) + (t2.points / (l.current_round * 3)))/2 * ct.coefficient,0.7 * ct.coefficient) as fcoef FROM `calendars2024` AS c INNER JOIN `leagues` AS l ON c.`league_id` = l.`id` INNER JOIN `categories` AS ct ON ct.`id` = l.`categoryId` LEFT JOIN tables2024 AS t1 ON t1.team = c.team1 AND t1.round = l.current_round LEFT JOIN tables2024 AS t2 ON t2.team = c.team2 AND t2.round = l.current_round WHERE c.`shedule` > '2024-03-29 00:00:00' AND c.`shedule` < '2024-04-02 23:59:59' AND l.id = 29877 ORDER BY c.shedule ASC, fcoef DESC LIMIT 5
0.0038  SELECT data1, data2 FROM services_tags WHERE categoryId=355
0.0038  SELECT l.year,l.group_code FROM leagues_besoccer l WHERE l.categoryId = 355 AND l.year = 1993 ORDER BY l.group_code ASC
0.0038  SELECT group_code, extraName from `leagues` WHERE categoryId=355 AND year=1993