Información Histórica
						

Nationalliga B - Qualifying Phase South East

1  FC Locarno         		22   13   6   3   44  23   32
2  FC Baden                   	22   13   5   4   41  19   31
3  FC Schaffhausen          	22   12   4   6   45  29   28
4  FC Basel                	22    9   8   5   40  30   26
5  SC Zug                 	22    8  10   4   29  22   26
6  FC Chiasso              	22   10   5   7   43  26   25
-------------------------------------------------------------
7  AC Bellinzona           	22    7   6   9   34  32   20
8  FC Winterthur          	22    7   6   9   26  35   20
9  FC Chur                 	22    5   7  10   20  25   17
10 FC Glarus               	22    4   6  12   23  58   14
11 FC Emmenbrücke           	22    3   7  12   18  39   13
12 SC Kriens                 	22    4   4  14   22  47   12


1st round
[July 25]
Baden		1-0 Chiasso
Chur		1-1 Emmenbrücke
Kriens		0-3 Basel
Locarno		2-0 Schaffhausen
Winterthur	1-1 Bellinzona
Zug		1-1 Glarus

2nd round
[July 28]
Basel		1-2 Locarno
Bellinzona	1-1 Emmenbrücke
Chiasso		2-0 Winterthur
Chur		1-2 Baden
Glarus		2-0 Kriens
Schaffhausen	0-3 Zug

3th round
[Aug 4]
Baden		3-0 Bellinzona
Emmenbrücke	0-0 Chiasso
Kriens		0-0 Schaffhausen
Locarno		5-0 Glarus
Winterthur	0-2 Chur
Zug		0-2 Basel

4th round
[Aug 8]
Basel		1-1 Winterthur
Bellinzona	4-1 Kriens
Chiasso		4-0 Locarno
Chur		0-1 Zug
Glarus		2-1 Emmenbrücke
Schaffhausen	2-0 Baden

5th round
[Aug 11]
Baden		2-0 Basel
Emmenbrücke	2-1 Schaffhausen
Kriens		1-3 Chiasso
Locarno		2-0 Chur
Winterthur	1-3 Glarus
Zug		2-1 Bellinzona

6th round
[Aug 14]
Basel		2-1 Emmenbrücke
Bellinzona	1-2 Locarno
Chiasso		0-0 Zug
Chur		4-0 Kriens
Glarus		0-2 Baden
Schaffhausen	2-1 Winterthur

7th round
[Aug 25]
Basel		2-2 Chiasso
Glarus		0-1 Chur
Kriens		0-2 Baden
Locarno		0-0 Winterthur
Schaffhausen	5-1 Bellinzona
Zug		3-0 Emmenbrücke

8th round
[Sep 1st]
Baden		1-2 Zug
Bellinzona	0-0 Basel
Chiasso		7-2 Glarus
Chur		0-0 Schaffhausen
Emmenbrücke	0-0 Locarno
Winterthur	2-1 Kriens

9th round
[Sep 5]
Glarus		0-0 Basel
Emmenbrücke	1-1 Baden
[Sep 7]
Zug		4-0 Winterthur
[Sep 8]
Schaffhausen	2-1 Chiasso
Bellinzona	2-0 Chur
Kriens		1-4 Locarno

10th round
[Sep 15]
Basel		0-3 Chur
Locarno		2-2 Zug
Chiasso		2-1 Bellinzona
Winterthur	3-1 Baden
Glarus		0-5 Schaffhausen
Kriens		1-1 Emmenbrücke

11th round
[Sep 22]
Baden		1-1 Locarno
Schaffhausen	3-2 Basel
Zug		1-1 Kriens
Chur		1-1 Chiasso
Glarus		0-0 Bellinzona
Emmenbrücke	3-2 Winterthur

12th round
[Oct 6]
Schaffhausen	2-0 Locarno
Basel		2-1 Kriens
Chiasso		3-5 Baden
Bellinzona	3-4 Winterthur
Emmenbrücke	2-1 Chur
Glarus		3-1 Zug

13th round
[Oct 9]
Baden		1-0 Chur
Locarno		2-3 Basel
[Oct 13]
Zug		1-1 Schaffhausen
Winterthur	0-1 Chiasso
Emmenbrücke	1-2 Bellinzona
Kriens		3-1 Glarus

14th round
[Oct 20]
Schaffhausen	4-2 Kriens
Basel		2-2 Zug
Chiasso		4-0 Emmenbrücke
Bellinzona	0-0 Baden
Chur		1-2 Winterthur
Glarus		2-6 Locarno

15th round
[Oct 27]
Baden		0-0 Schaffhausen
Zug		0-0 Chur
Kriens		3-2 Bellinzona
Winterthur	2-2 Basel
Emmenbrücke	1-1 Glarus
[Oct 28]
Locarno		2-1 Chiasso

16th round
[Nov 4]
Schaffhausen	2-0 Emmenbrücke
Basel		1-3 Baden
Chiasso		2-1 Kriens
Bellinzona	3-0 Zug
Chur		0-2 Locarno
Glarus		1-1 Winterthur

17th round
[Nov 11]
Locarno		2-1 Bellinzona
Baden		6-3 Glarus
Zug		2-1 Chiasso
Winterthur	0-2 Schaffhausen
Emmenbrücke	0-3 Basel
Kriens		2-1 Chur

18th round
[Nov 18]
Baden		3-1 Kriens
Chiasso		2-2 Basel
Bellinzona	3-1 Schaffhausen
Winterthur	1-1 Locarno
Chur		1-1 Glarus
Emmenbrücke	0-2 Zug

19th round
[Nov 25]
Schaffhausen	4-1 Chur
Basel		2-1 Bellinzona
[Nov 29]
Locarno		3-2 Emmenbrücke
[Dec 4]
Kriens		0-1 Winterthur
[Dec 5]
Zug		0-0 Baden
Glarus		1-3 Chiasso


20th round
[Dec 2]
Locarno		4-0 Kriens
Baden		4-0 Emmenbrücke
Basel		3-0 Glarus
Chiasso		4-0 Schaffhausen
Winterthur	3-1 Zug
[Dec 12]
Chur		1-1 Bellinzona

21th round
[Dec 9]
Baden		3-0 Winterthur
Chur		1-1 Basel
Emmenbrücke	1-2 Kriens
Schaffhausen	7-0 Glarus
Zug		1-1 Locarno
[Dec 14]
Bellinzona	2-0 Chiasso

22th round
[Dec 16]
Locarno		1-0 Baden
Chiasso		0-1 Chur
Bellinzona	4-1 Glarus
Kriens		1-1 Zug
[Dec 19]
Winterthur	1-0 Emmenbrücke
[Dec 22]
Basel		6-2 Schaffhausen


Nationalliga B - Qualifying Phase South East

Final table : 

1  FC Locarno         		22   13   6   3   44  23   32
2  FC Baden                   	22   13   5   4   41  19   31
3  FC Schaffhausen          	22   12   4   6   45  29   28
4  FC Basel                	22    9   8   5   40  30   26
5  SC Zug                 	22    8  10   4   29  22   26
6  FC Chiasso              	22   10   5   7   43  26   25
-------------------------------------------------------------
7  AC Bellinzona           	22    7   6   9   34  32   20
8  FC Winterthur          	22    7   6   9   26  35   20
9  FC Chur                 	22    5   7  10   20  25   17
10 FC Glarus               	22    4   6  12   23  58   14
11 FC Emmenbrücke           	22    3   7  12   18  39   13
12 SC Kriens                 	22    4   4  14   22  47   12

Topscorers :
1. Engesser Joachim (GER)	19  FC Schaffhausen
2. Sitek André (NED)		12  FC Baden
3. Grassi Marco			10  FC Chiasso
   Pedrotti Luca		10  FC Locarno
   Lötscher Peter		10  SC Kriens 
   Esposito Lucio (ITA)		10  AC Bellinzona
   Ott Markus (GER)		10  FC Glarus
   Bernaschina Marco		10  FC Chiasso



Nationalliga B - Qualifying Phase West

1  Yverdon-Sport         	22   14   6   2   49  21   34
2  BSC Old Boys Basel        	22   12   6   4   56  38   30
3  Etoile Carouge          	22   11   7   4   38  31   29
4  FC La Chaux-de-Fonds      	22    9   9   4   52  37   27
5  FC Fribourg             	22    8   8   6   54  36   24
6  Urania-Genève-Sport      	22    9   6   7   45  33   24
-------------------------------------------------------------
7  FC Grenchen              	22    9   5   8   42  27   23
8  FC Bulle                 	22    7   6   9   31  35   20
9  ES Malley             	22    3  12   7   22  33   18
10 Montreux-Sports          	22    4   7  11   27  47   15
11 CS Chênois                	22    2   7  13   19  53   11
12 SC Burgdorf              	22    1   7  14    9  53    9


1st round
[July 25]
Old Boys	4-2 Yverdon
Etoile C.	3-3 Montreux
Fribourg	3-0 Bulle
Malley		1-5 Grenchen
Chênois		0-3 UGS
Burgdorf	0-4 Chaux-de-F.

2nd round
[July 28]
Yverdon		3-0 Chênois
Chaux-de-F.	2-2 Malley
UGS		2-2 Old Boys
Grenchen	3-0 Burgdorf
Bulle		0-2 Etoile C.
Montreux	0-0 Fribourg

3th round
[Aug 4]
Old Boys	3-2 Grenchen
Etoile C.	0-0 Chaux-de-F.
Fribourg	2-2 UGS
Malley		1-1 Yverdon
Chênois		0-6 Bulle
Burgdorf	1-1 Montreux

4th round
[Aug 8]
Yverdon		3-0 Burgdorf
Chaux-de-F.	4-2 Fribourg
UGS		0-2 Etoile C.
Grenchen	3-0 Chênois
Bulle		4-2 Old Boys
Montreux	0-1 Malley

5th round
[Aug 11]
Old Boys	2-2 Chaux-de-F.
Etoile C.	1-1 Grenchen
Fribourg	0-3 Yverdon
Malley		1-2 UGS
Chênois		1-1 Montreux
Burgdorf	1-2 Bulle

6th round
[Aug 14]
Yverdon		4-2 Etoile C.
Chaux-de-F.	2-2 Chênois
UGS		4-0 Burgdorf
Grenchen	1-1 Fribourg
Bulle		3-1 Malley
Montreux	0-1 Old Boys

7th round
[Aug 24]
Etoile C.	5-3 Fribourg
[Aug 25]
Yverdon		2-0 Grenchen
Chaux-de-F.	2-0 UGS
Bulle		2-0 Montreux
Malley		2-3 Old Boys
Chênois		0-0 Burgdorf

8th round
[Sep 1st]
Old Boys	1-1 Chênois
Fribourg	0-0 Malley
UGS		0-2 Yverdon
Grenchen	1-2 Bulle
Montreux	2-4 Chaux-de-F.
Burgdorf	1-1 Etoile C.

9th round
[Sep 4]
Malley		0-0 Burgdorf
[Sep 7]
Old Boys	5-2 Fribourg
[Sep 8]
Etoile C.	2-1 Chênois
Chaux-de-F.	0-1 Grenchen
UGS		5-1 Montreux
Bulle		1-1 Yverdon

10th round
[Sep 15]
Yverdon		3-0 Montreux
Etoile C.	1-1 Old Boys
Grenchen	5-1 UGS
Bulle		2-2 Chaux-de-F.
Chênois		0-0 Malley
Burgdorf	2-2 Fribourg

11th round
[Sep 22]
Old Boys	4-0 Burgdorf
Malley		2-3 Etoile C.
Chaux-de-F.	7-2 Yverdon
Fribourg	5-0 Chênois
UGS		5-0 Bulle
Montreux	2-0 Grenchen

12th round
[Oct 6]
Yverdon		4-1 Old Boys
Montreux	1-3 Etoile C.
Chaux-de-F.	5-0 Burgdorf
Bulle		1-1 Fribourg
UGS		2-0 Chênois
Grenchen	1-1 Malley

13th round
[Oct 9]
Malley		3-3 Chaux-de-F.
Chênois		1-4 Yverdon
[Oct 12]
Fribourg	7-0 Montreux
[Oct 13]
Old Boys	4-2 UGS
Etoile C.	1-0 Bulle
[Oct 14]
Burgdorf	0-4 Grenchen

14th round
[Oct 20]
Chaux-de-F.	1-1 Etoile C.
UGS		5-3 Fribourg
Grenchen	2-3 Old Boys
Bulle		4-3 Chênois
Yverdon		0-0 Malley
Montreux	5-1 Burgdorf

15th round
[Oct 27]
Old Boys	4-3 Bulle
Etoile C.	4-2 UGS
Fribourg	1-1 Chaux-de-F.
[Oct 28]
Burgdorf	0-1 Yverdon
Chênois		2-1 Grenchen
Malley		1-4 Montreux

16th round
[Nov 3]
UGS		1-1 Malley
[Nov 4]
Chaux-de-F.	2-6 Old Boys
Yverdon		3-2 Fribourg
Grenchen	4-0 Etoile C.
Bulle		0-1 Burgdorf
Montreux	2-2 Chênois

17th round
[Nov 10]
Etoile C.	1-3 Yverdon
[Nov 11]
Old Boys	5-2 Montreux
Chênois		4-4 Chaux-de-F.
Fribourg	5-2 Grenchen
Burgdorf	0-5 UGS
Malley		0-0 Bulle

18th round
[Nov 17]
UGS		3-1 Chaux-de-F.
[Nov 18]
Old Boys	1-2 Malley
Fribourg	4-1 Etoile C.
Grenchen	1-1 Yverdon
Montreux	0-0 Bulle
Burgdorf	0-1 Chênois

19th round
[Nov 24]
Etoile C.	2-0 Burgdorf
[Nov 25]
Chênois		1-3 Old Boys
Yverdon		0-0 UGS
[Nov 28]
Chaux-de-F.	3-0 Montreux		[in Yverdon]
Malley		1-3 Fribourg
[Dec 5]
Bulle		1-2 Grenchen

20th round
[Dec 2]
Yverdon		3-0 Bulle
Fribourg	0-0 Old Boys
Grenchen	0-1 Chaux-de-F.
Burgdorf	1-1 Malley
Montreux	3-1 UGS
Chênois		0-2 Etoile C.

21th round
[Dec 9]
Montreux	0-0 Yverdon
Old Boys	0-1 Etoile C.
Chaux-de-F.	2-0 Bulle
Fribourg	4-0 Burgdorf
UGS		0-0 Grenchen
Malley		1-0 Chênois

22th round
[Dec 16]
Yverdon		4-0 Chaux-de-F.
Etoile C.	0-0 Malley
Burgdorf	1-1 Old Boys
[Dec 22]
Bulle		0-0 UGS
Chênois		0-4 Fribourg
Grenchen	3-0 Montreux


Nationalliga B - Qualifying Phase West

Final table :

1  Yverdon-Sport         	22   14   6   2   49  21   34
2  BSC Old Boys Basel        	22   12   6   4   56  38   30
3  Etoile Carouge          	22   11   7   4   38  31   29
4  FC La Chaux-de-Fonds      	22    9   9   4   52  37   27
5  FC Fribourg             	22    8   8   6   54  36   24
6  Urania-Genève-Sport      	22    9   6   7   45  33   24
-------------------------------------------------------------
7  FC Grenchen              	22    9   5   8   42  27   23
8  FC Bulle                 	22    7   6   9   31  35   20
9  ES Malley             	22    3  12   7   22  33   18
10 Montreux-Sports          	22    4   7  11   27  47   15
11 CS Chênois                	22    2   7  13   19  53   11
12 SC Burgdorf              	22    1   7  14    9  53    9

Topscorers :
1. Büchli Bruno			20  FC Fribourg
2. Castella Gilbert		17  Etoile Carouge 
3. Przybylo Jan (POL)		13  FC Grenchen
4. Pavoni Gabor (ITA)		12  FC La Chaux-de-Fonds
5. Gross Jean-Daniel		11  FC Fribourg
   Meisel Hans (GER)		11  BSC Old Boys
   Kekesi Reszo (HUN)		11  Yverdon-Sport



Nationalliga B - Relegation Group A                            (*)

1  FC Winterthur             	10    5   4   1   14   6   14   5  19
2  FC Grenchen              	10    5   2   3   16  14   12   6  18
3  SC Kriens                	10    6   1   3   17  13   13   1  14
4  ES Malley                	10    3   2   5    8  10    8   4  12
---------------------------------------------------------------------
5  FC Glarus               	10    2   4   4   13  17    8   3  11 (1)
---------------------------------------------------------------------
6  CS Chênois                 	10    1   3   6   10  18    5   2   7 Relegated

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


1st round
[March 17]
Winterthur	1-1 Chênois
Malley		1-3 Glarus
Grenchen	2-1 Kriens
 
2nd round
[March 28]
Chênois		1-2 Grenchen
Kriens		2-0 Malley 
[March 30]
Glarus		1-1 Winterthur

3rd round
[April 6]
Chênois		0-1 Kriens
Grenchen	3-1 Glarus
Winterthur	1-0 Malley

4th round
[April 13]
Glarus		3-1 Chênois
Malley 		0-2 Grenchen
Kriens		0-1 Winterthur

5th round
[April 20]
Chênois		0-2 Malley
Glarus		2-2 Kriens
Grenchen	2-1 Winterthur

6th round
[April 27]
Kriens		4-1 Glarus
Malley 		3-0 Chênois
Winterthur	2-1 Grenchen

7th round
[May 4]
Chênois		1-1 Glarus
Grenchen	0-0 Malley
Winterthur	4-0 Kriens

8th round
[May 11]
Kriens		2-1 Chênois
Glarus		1-1 Grenchen
Malley 		0-0 Winterthur

9th round
[May 18]
Grenchen	2-4 Chênois
Malley 		1-2 Kriens
Winterthur	2-0 Glarus

10th round
[May 25]
Kriens		3-1 Grenchen
Glarus		0-1 Malley 
Chênois		1-1 Winterthur


Nationalliga B - Relegation Group A 

Final table :                                                  (*)

1  FC Winterthur             	10    5   4   1   14   6   14   5  19
2  FC Grenchen              	10    5   2   3   16  14   12   6  18
3  SC Kriens                	10    6   1   3   17  13   13   1  14
4  ES Malley                	10    3   2   5    8  10    8   4  12
---------------------------------------------------------------------
5  FC Glarus               	10    2   4   4   13  17    8   3  11 (1)
---------------------------------------------------------------------
6  CS Chênois                 	10    1   3   6   10  18    5   2   7 Relegated

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

Topscorers :
1. Tannhäuser Jerzy (GER)	 7  FC Winterthur
2. Opoku Nti Samuel (GHA) 	 6  FC Glarus
   Lötscher Peter		 6  SC Kriens
4. Przybylo Jan (POL)		 5  FC Grenchen


Nationalliga B - Relegation Group B                            (*)

1  FC Bulle                 	10    6   3   1   26   7   15   5  20
2  AC Bellinzona            	10    3   4   3   14  15   10   6  16
3  FC Chur                   	10    3   5   2   10   7   11   4  15
4  FC Emmenbrücke            	10    4   1   5   13  15    9   2  11
---------------------------------------------------------------------
5  Montreux-Sports           	10    1   5   4    4  16    7   3  10 Relegated (1)
---------------------------------------------------------------------
6  SC Burgdorf                	10    1   6   3    8  15    8   1   9 Relegated
        
(*) bonus points from qualifying groups (7th place 6 pts; 8th place 5 pts; etc)


1st round
[March 17]
Bellinzona 	0-0 Burgdorf
Chur		3-0 Emmenbrücke
Montreux	0-6 Bulle

2nd round
[March 28]
Bulle		2-2 Bellinzona
Emmenbrücke	2-1 Burgdorf
Chur		3-1 Montreux

3rd round
[April 6]
Bellinzona 	3-1 Chur
Burgdorf 	0-5 Bulle
Montreux	0-0 Emmenbrücke

4th round
[April 13]
Emmenbrücke	0-2 Bulle
Chur		1-1 Burgdorf 
Montreux	0-0 Bellinzona 

5th round
[April 20]
Bellinzona 	2-4 Emmenbrücke
Bulle		0-0 Chur
[May 1st]
Burgdorf 	0-0 Montreux

6th round
[April 27]
Emmenbrücke	3-0 Bellinzona 
Chur		0-0 Bulle
Montreux	1-1 Burgdorf 

7th round
[May 4]
Bellinzona 	3-0 Montreux
Bulle		3-1 Emmenbrücke
Burgdorf 	0-0 Chur

8th round
[May 11] 
Bulle		4-1 Burgdorf 
Chur		0-1 Bellinzona
Emmenbrücke	2-0 Montreux

9th round
[May 18]
Bellinzona 	1-3 Bulle
Burgdorf 	2-0 Emmenbrücke
Montreux	0-0 Chur

10th round
[May 25]
Burgdorf 	2-2 Bellinzona 
Bulle		1-2 Montreux
Emmenbrücke	1-2 Chur


Nationalliga B - Relegation Group B

Final table :                                                  (*)

1  FC Bulle                 	10    6   3   1   26   7   15   5  20
2  AC Bellinzona            	10    3   4   3   14  15   10   6  16
3  FC Chur                   	10    3   5   2   10   7   11   4  15
4  FC Emmenbrücke            	10    4   1   5   13  15    9   2  11
---------------------------------------------------------------------
5  Montreux-Sports           	10    1   5   4    4  16    7   3  10 Relegated (1)
---------------------------------------------------------------------
6  SC Burgdorf                	10    1   6   3    8  15    8   1   9 Relegated
        
(*) bonus points from qualifying groups (7th place 6 pts; 8th place 5 pts; etc)

Topscorers :
1. Magnin André			 7  FC Bulle
2. Kunz Adrian			 6  FC Bulle
   Eggleling Frank (GER)	 6  FC Emmenbrücke
4. Fernando (BRA)		 5  AC Bellinzona


(1) Playoff 5th-placed teams
FC Glarus 		2-1 1-3 Montreux-Sports
Montreux-Sports had its license revoked; Glarus remained in NL B



Author:
Erik Garin
(garinerik@hispeed.ch)

Last updated: 10 Oct 2006

(C) Copyright Erik Garin and RSSSF 2001/06
						


  USO DE MEMORIA  
4,355,880 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0018
Controller Execution Time ( Home / Category )  0.4559
Total Execution Time  0.4577
  CADENA URL  
/segunda_suiza1991
  GET DATOS  
$_GET['/segunda_suiza1991']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (34)  
0.0106  SELECT type FROM routes WHERE alias = 'segunda_suiza1991'
0.0215  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 = 1991 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=1 DESC LIMIT 1
0.0115  SELECT text_es as historical_text FROM leagues_text WHERE id=1615
0.0110  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 = 29885 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0109  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='1991' WHERE c.parentId=355 GROUP BY c.id ORDER BY c.order_id ASC
0.0106  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-04-19 11:26:30' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0109  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=2 AND last_update > '2024-04-19 11:26:30' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0108  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=4 AND last_update > '2024-04-19 11:26:30' 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=3 AND last_update > '2024-04-19 11:26:30' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0112  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 = 1991 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=0 DESC LIMIT 1
0.0106  SELECT e.action, count(e.action) as total, e.player_id FROM events1991 e WHERE e.league_id IN (29885) 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.0107  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 (29885) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN () ORDER BY rp.in_squad = 1 DESC
0.0110  SELECT e.action, count(e.action) as total, e.player_id FROM events1991 e WHERE e.league_id IN (29885) AND (e.action IN (4,5) ) GROUP BY e.player_id ORDER BY total DESC, e.player_id ASC LIMIT 20
0.0110  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 (29885) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN () ORDER BY rp.in_squad = 1 DESC
0.0113  SELECT e.action, count(e.action) as total, e.player_id FROM events1991 e WHERE e.league_id IN (29885) AND (e.action IN (3,4) ) GROUP BY e.player_id ORDER BY total DESC, e.player_id ASC LIMIT 20
0.0112  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 (29885) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN () ORDER BY rp.in_squad = 1 DESC
0.0115  SELECT e.action, count(e.action) as total, e.player_id FROM events1991 e WHERE e.league_id IN (29885) AND (e.action IN (22) ) GROUP BY e.player_id ORDER BY total DESC, e.player_id ASC LIMIT 20
0.0108  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 (29885) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN () ORDER BY rp.in_squad = 1 DESC
0.0106  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 = 29885 AND rp.lineup > 0 ORDER BY rp.lineup DESC,p.pod DESC LIMIT 20
0.0108  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 = 29885 AND rp.events > 0 ORDER BY rp.events DESC,p.pod DESC LIMIT 20
0.0109  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=29885 AND rel.round=22
0.0106  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 = 29885 AND esl.points > 0 ORDER BY esl.points DESC LIMIT 3
0.0106  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 = 29885 AND esl.points > 0
0.0107  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-03-20" AND c.`active`= 1 and c.comment_id is null and c.lang = 1 AND l.`id` = 29885 ORDER BY creation_date DESC LIMIT 0, 10
0.0109  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-03-20" AND c.`active`= 1 and comment_id is null and c.lang = 1 AND l.`id` = 29885
0.0107  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 `calendars1991` 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` = 29885 AND c.`round` = 22 ORDER BY shedule ASC LIMIT 200
0.0105  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 `events1991` e INNER JOIN calendars1991 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 = 29885 ORDER BY total DESC LIMIT 40
0.0107  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 `events1991` e INNER JOIN calendars1991 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 = 29885 AND e.real_date > NOW() - INTERVAL 1 MONTH ORDER BY e.real_date DESC LIMIT 30
0.0107  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 `tables1991` 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 = 29885 AND t.round = 20 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0107  SELECT *,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables1991` 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 = 29885 AND t.round = 22 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0107  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-04-19 00:00:00' AND c.`shedule` < '2024-04-23 23:59:59' AND l.id = 29885 ORDER BY c.shedule ASC, fcoef DESC LIMIT 5
0.0107  SELECT data1, data2 FROM services_tags WHERE categoryId=355
0.0107  SELECT l.year,l.group_code FROM leagues_besoccer l WHERE l.categoryId = 355 AND l.year = 1991 ORDER BY l.group_code ASC
0.0107  SELECT group_code, extraName from `leagues` WHERE categoryId=355 AND year=1991