4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Información Histórica 
						
First Stage

Table

 1.Barcelona            22 14  5  3 43-21 33 [Guayaquil]  Qualified
 2.El Nacional  	22  9 11  2 37-20 29 [Quito]      Qualified
 3.LDU de Quito         22 10  7  5 45-26 27 [Quito]      Qualified
 4.Valdez SC            22  9  9  4 31-17 27 [Milagro]    Qualified
 - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - 
 5.Emelec               22  7  9  6 30-36 23 [Guayaquil]
 6.Dep. Quito   	22  6  9  7 32-31 21 [Quito]
 7.Técnico Univ. 	22  8  5  9 30-30 21 [Ambato]
 8.Univ. Católica       22  6  7  9 20-24 19 [Quito]
 9.Dep. Cuenca          22  7  5 10 23-28 19 [Cuenca]
10.Juvenil              22  5  8  9 20-39 18 [Esmeraldas]
11.Delfín               22  5  4 13 27-45 14 [Manta]
 - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - 
12.Macara               22  3  7 12 20-41 13 [Ambato]     Relegated

Top-4 qualify for Third Stage.

NB: Barcelona (1 bonus point), El Nacional (1), LDU de Quito (0,5) and Valdez SC (0,5)
    for Third Stage.

Round  1
[Mar  2]
Técnico Univ.        4- 0 Juvenil       
[Mar  3]
LDU de Quito         0- 0 Valdez SC        
Dep. Cuenca          1- 0 Univ. Católica   
Delfín               0- 0 Macara        
Emelec               1- 1 El Nacional   
[Mar 20]
Dep. Quito           2- 2 Barcelona     

Round  2
[Mar  9]
Juvenil              1- 1 Emelec        
Barcelona            2- 1 Dep. Cuenca   
Valdez SC            2- 0 Dep. Quito    
[Mar 10]
El Nacional          7- 1 Delfín        
Univ. Católica       1- 3 Técnico Univ.    
Macara               1- 1 LDU de Quito  

Round  3
[Mar 16]
Técnico Univ.        0- 3 Barcelona     
[Mar 17]
Dep. Quito           3- 0 El Nacional   
Delfín               0- 1 Valdez SC        
Dep. Cuenca          1- 0 Juvenil       
Emelec               1- 1 Macara        
[Apr 10]
LDU de Quito         2- 1 Univ. Católica   

Round  4
[Mar 23]
Valdez SC            1- 2 Técnico Univ.    
[Mar 24]
Univ. Católica       1- 0 Emelec        
El Nacional          4- 2 Dep. Cuenca   
Macara               0- 0 Dep. Quito    
Barcelona            1- 1 Delfín        
[Mar 27]
Juvenil              1- 1 LDU de Quito  

Round  5
[Mar 30]
Delfín               0- 1 Juvenil       
[Mar 31]
Univ. Católica       1- 2 El Nacional   
Técnico Univ.        2- 0 Macara        
Dep. Cuenca          0- 1 Valdez SC        
Emelec               3- 2 Dep. Quito    
[May 15]
LDU de Quito         2- 1 Barcelona     

Round  6
[Apr  6]
Juvenil              1- 1 El Nacional   
Macara               1- 3 Dep. Cuenca   
Valdez SC            1- 1 Univ. Católica   
[Apr  7]
LDU de Quito         5- 0 Delfín        
Dep. Quito           0- 0 Técnico Univ.    
Emelec               2- 2 Barcelona     

Round  7
[Apr 13]
Valdez SC            5- 0 Juvenil       
[Apr 14]
El Nacional          2- 0 Macara        
Univ. Católica       3- 1 Barcelona     
Técnico Univ.        0- 1 Emelec        
Delfín               2- 3 Dep. Quito    
Dep. Cuenca          1- 3 LDU de Quito  

Round  8
[Apr 20]
Juvenil              2- 1 Univ. Católica   
Macara               2- 3 Valdez SC        
[Apr 21]
Dep. Quito           0- 0 Dep. Cuenca   
LDU de Quito         2- 0 Técnico Univ.    
Barcelona            1- 0 El Nacional   
Emelec               4- 2 Delfín        

Round  9
[Apr 27]
Técnico Univ.        1- 1 El Nacional   
Valdez SC            2- 0 Emelec        
[Apr 28]
Univ. Católica       1- 1 Macara        
Delfín               2- 1 Dep. Cuenca   
Barcelona            4- 1 Juvenil       
[Jun 12]
Dep. Quito           1- 3 LDU de Quito  

Round 10
[May  1]
Juvenil              3- 1 Macara        
Técnico Univ.        3- 1 Delfín        
Dep. Quito           0- 0 Univ. Católica   
El Nacional          1- 0 LDU de Quito  
Valdez SC            0- 0 Barcelona     
Dep. Cuenca          0- 1 Emelec        

Round 11
[May  5]
Dep. Quito           3- 0 Juvenil       
El Nacional          3- 3 Valdez SC        
Delfín               0- 0 Univ. Católica   
Macara               1- 3 Barcelona     
Dep. Cuenca          3- 2 Técnico Univ.    
Emelec               4- 1 LDU de Quito  

Round 12
[May 11]
Juvenil              0- 0 Técnico Univ.    
Univ. Católica       1- 0 Dep. Cuenca   
El Nacional          5- 0 Emelec        
Macara               1- 0 Delfín        
Barcelona            2- 0 Dep. Quito    
Valdez SC            1- 1 LDU de Quito  

Round 13
[May 18]
Técnico Univ.        1- 0 Univ. Católica   
[May 19]
LDU de Quito         2- 1 Macara        
Dep. Quito           1- 1 Valdez SC        
Delfín               3- 3 El Nacional   
Dep. Cuenca          0- 2 Barcelona     
Emelec               2- 2 Juvenil       

Round 14
[May 23]
Barcelona            6- 2 Técnico Univ.    
[May 24]
Univ. Católica       1- 1 LDU de Quito  
El Nacional          2- 1 Dep. Quito    
Macara               1- 2 Emelec        
Juvenil              0- 0 Dep. Cuenca   
Valdez SC            2- 1 Delfín        

Round 15
[Jun  2]
Dep. Quito           4- 1 Macara        
LDU de Quito         6- 0 Juvenil       
Técnico Univ.        1- 1 Valdez SC        
Dep. Cuenca          0- 0 El Nacional   
Delfín               2- 3 Barcelona     
Emelec               1- 1 Univ. Católica   

Round 16
[Jun  5]
Barcelona            1- 4 LDU de Quito  
Juvenil              3- 2 Delfín        
Macara               2- 1 Técnico Univ.    
Valdez SC            2- 1 Dep. Cuenca   
[Jun  6]
El Nacional          0- 0 Univ. Católica   
Dep. Quito           2- 2 Emelec        

Round 17
[Jun  9]
Delfín               2- 1 LDU de Quito  
Dep. Cuenca          3- 2 Macara        
Técnico Univ.        1- 1 Dep. Quito    
El Nacional          0- 0 Juvenil       
Univ. Católica       1- 0 Valdez SC        
Barcelona            1- 0 Emelec        

Round 18
[Jun 15]
Juvenil              1- 0 Valdez SC        
Macara               0- 0 El Nacional   
Dep. Quito           1- 3 Delfín        
Barcelona            3- 0 Univ. Católica   
LDU de Quito         0- 0 Dep. Cuenca   
Emelec               2- 1 Técnico Univ.    

Round 19
[Jun 22]
Técnico Univ.        4- 1 LDU de Quito  
Valdez SC            4- 0 Macara        
[Jun 23]
Univ. Católica       1- 0 Juvenil       
El Nacional          0- 0 Barcelona     
Dep. Cuenca          2- 1 Dep. Quito    
Delfín               2- 0 Emelec        

Round 20
[Jun 29]
Juvenil              0- 1 Barcelona     
Macara               2- 1 Univ. Católica   
[Jun 30]
El Nacional          2- 0 Técnico Univ.    
LDU de Quito         2- 2 Dep. Quito    
Dep. Cuenca          2- 0 Delfín        
Emelec               1- 1 Valdez SC        

Round 21
[Jul  6]
Barcelona            1- 0 Valdez SC        
Emelec               2- 2 Dep. Cuenca   
[Jul  7]
Univ. Católica       1- 2 Dep. Quito    
LDU de Quito         2- 3 El Nacional   
Macara               2- 2 Juvenil       
Delfín               2- 0 Técnico Univ.    

Round 22
[Jul 13]
Juvenil              2- 3 Dep. Quito    
Valdez SC            0- 0 El Nacional   
[Jul 14]
Univ. Católica       3- 1 Delfín        
Barcelona            3- 0 Macara        
Técnico Univ.        2- 0 Dep. Cuenca   
LDU de Quito         5- 0 Emelec        

Table

 1.Barcelona            22 14  5  3 43-21 33 [Guayaquil]  Qualified
 2.El Nacional  	22  9 11  2 37-20 29 [Quito]      Qualified
 3.LDU de Quito         22 10  7  5 45-26 27 [Quito]      Qualified
 4.Valdez SC            22  9  9  4 31-17 27 [Milagro]    Qualified
 - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - 
 5.Emelec               22  7  9  6 30-36 23 [Guayaquil]
 6.Dep. Quito   	22  6  9  7 32-31 21 [Quito]
 7.Técnico Univ. 	22  8  5  9 30-30 21 [Ambato]
 8.Univ. Católica       22  6  7  9 20-24 19 [Quito]
 9.Dep. Cuenca          22  7  5 10 23-28 19 [Cuenca]
10.Juvenil              22  5  8  9 20-39 18 [Esmeraldas]
11.Delfín               22  5  4 13 27-45 14 [Manta]
 - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - 
12.Macara               22  3  7 12 20-41 13 [Ambato]     Relegated

Top-4 qualify for Third Stage.

NB: Barcelona (1 bonus point), El Nacional (1), LDU de Quito (0,5) and Valdez SC (0,5)
    for Third Stage.


Second Stage

Nb: Green Cross promoted as winner of First Stage of Serie B

Tables

Group 1

 1.Barcelona            10  5  4  1 20-10 14          Qualified
 2.Emelec       	10  5  3  2 17-10 13          Qualified
 - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - 
 3.Dep. Cuenca          10  4  2  4 13-12 10
 4.Delfín               10  4  2  4 13-15 10
 5.LDU de Quito         10  3  3  4 14-13  9
 6.Univ. Católica  	10  1  2  7 12-29  4

Group 2

 1.Valdez SC     	10  5  3  2 12- 8 13          Qualified
 2.El Nacional          10  5  2  3 21- 9 12          Qualified
 - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - 
 3.Técnico Univ.        10  5  2  3 20-13 12
 4.Green Cross          10  5  0  5 17-19 10 [Manta]
 5.Dep. Quito           10  3  3  4 15-14  9
 6.Juvenil              10  1  2  7 11-33  4

Top-2 of each group qualify for Third Stage.

NB: Barcelona (1 bonus point), Valdez SC (1), Emelec (0,5) and El Nacional (0,5)
    for third stage.
    Univ. Católica(-0,5 penalization points) and Juvenil (-1) for Liguilla de no
    descenso in third stage.

Round 1
[Jul 20]
Técnico Univ.        3- 1 Dep. Quito    
Valdez SC            1- 0 Green Cross   
[Jul 21]
El Nacional          6- 0 Juvenil       
LDU de Quito         0- 2 Dep. Cuenca   
Delfín               3- 1 Barcelona     
Emelec               2- 0 Univ. Católica   

Round 2
[Jul 27]
Juvenil              0- 0 Valdez SC        
LDU de Quito         0- 0 Univ. Católica   
Dep. Quito           0- 0 El Nacional   
[Jul 28]
Dep. Cuenca          1- 1 Delfín        
Green Cross          1- 0 Técnico Univ.    
Barcelona            2- 2 Emelec        

Round 3
[Aug  3]
Técnico Univ.        8- 1 Juvenil       
Valdez SC            4- 1 El Nacional   
[Aug  4]
Dep. Quito           3- 1 Green Cross   
Delfín               0- 1 LDU de Quito  
Univ. Católica       2- 4 Barcelona     
Emelec               2- 1 Dep. Cuenca   

Round 4
[Aug 10]
Juvenil              1- 1 Dep. Quito    
Valdez SC            0- 0 Técnico Univ.    
[Aug 11]
El Nacional          1- 0 Green Cross   
LDU de Quito         1- 2 Emelec        
Dep. Cuenca          0- 0 Barcelona     
Delfín               3- 0 Univ. Católica   

Round 5
[Aug 17]
Técnico Univ.        1- 0 El Nacional   
[Aug 18]
Univ. Católica       1- 2 Dep. Cuenca   
Dep. Quito           3- 0 Valdez SC        
Green Cross          5- 2 Juvenil       
Barcelona            2- 0 LDU de Quito  
Emelec               3- 0 Delfín        

Round 6
[Aug 24]
Juvenil              1- 2 El Nacional   
[Aug 25]
Dep. Quito           0- 1 Técnico Univ.    
Dep. Cuenca          1- 2 LDU de Quito  
Univ. Católica       4- 3 Emelec        
Green Cross          1- 0 Valdez SC        
Barcelona            1- 0 Delfín        

Round 7
[Aug 31]
Técnico Univ.        5- 1 Green Cross   
Valdez SC            2- 1 Juvenil       
[Sep  1]
El Nacional          0- 0 Dep. Quito    
Univ. Católica       2- 2 LDU de Quito  
Delfín               3- 1 Dep. Cuenca   
Emelec               0- 0 Barcelona     

Round 8
[Sep  7]
Juvenil              2- 0 Técnico Univ.    
[Sep  8]
LDU de Quito         6- 0 Delfín        
El Nacional          1- 2 Valdez SC        
Dep. Cuenca          1- 0 Emelec        
Green Cross          5- 1 Dep. Quito    
Barcelona            6- 2 Univ. Católica   

Round 9
[Sep 14]
Barcelona            3- 0 Dep. Cuenca   
Técnico Univ.        1- 1 Valdez SC        
Dep. Quito           6- 1 Juvenil       
Univ. Católica       1- 3 Delfín        
[Sep 15]
Green Cross          0- 4 El Nacional   
Emelec               3- 1 LDU de Quito  

Round 10
[Sep 22]
Valdez SC            2- 0 Dep. Quito    
El Nacional          6- 1 Técnico Univ.    
LDU de Quito         1- 1 Barcelona     
Delfín               0- 0 Emelec        
Dep. Cuenca          4- 0 Univ. Católica   
Juvenil              2- 3 Green Cross   

Tables

Group 1

 1.Barcelona            10  5  4  1 20-10 14          Qualified
 2.Emelec       	10  5  3  2 17-10 13          Qualified
 - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - 
 3.Dep. Cuenca          10  4  2  4 13-12 10
 4.Delfín               10  4  2  4 13-15 10
 5.LDU de Quito         10  3  3  4 14-13  9
 6.Univ. Católica  	10  1  2  7 12-29  4

Group 2

 1.Valdez SC     	10  5  3  2 12- 8 13          Qualified
 2.El Nacional          10  5  2  3 21- 9 12          Qualified
 - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - 
 3.Técnico Univ.        10  5  2  3 20-13 12
 4.Green Cross          10  5  0  5 17-19 10 [Manta]
 5.Dep. Quito           10  3  3  4 15-14  9
 6.Juvenil              10  1  2  7 11-33  4

Top-2 of each group qualify for Third Stage.

NB: Barcelona (1 bonus point), Valdez SC (1), Emelec (0,5) and El Nacional (0,5)
    for third stage.
    Univ. Católica(-0,5 penalization points) and Juvenil (-1) for Liguilla de no
    descenso in third stage.


Third Stage

Tables

Group 1

 1.Valdez SC             6  3  2  1  7- 6  9,5 [1,5]  Qualified
 2.Barcelona    	 6  3  1  2 12- 7  9   [2]    Qualified
 - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - 
 3.Técnico Univ.         6  2  1  3  8-10  5
 4.Green Cross           6  1  2  3  8-12  4

Group 2

 1.El Nacional   	 6  2  2  2  5- 3  7,5 [1,5]  Qualified
 2.Dep. Quito            6  3  1  2  9-11  7          Qualified
 - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - 
 3.LDU de Quito          6  2  2  2  9- 7  6,5 [0,5]
 4.Emelec                6  2  1  3  8-10  5,5 [0,5]

[bonus points between square brackets]

Top-2 of each group qualify for Liguilla Final.

Liguilla de no descenso

 1.Dep. Cuenca           6  4  1  1 12- 5  9
 2.Delfín       	 6  3  1  2 11- 7  7
 3.Univ. Católica        6  2  0  4  8- 9  3,5 [-1]
 - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - 
 4.Juvenil               6  2  0  4  5-15  1   [-0,5] (1) Relegated

Juvenil deduced 2 points.
[penalization points between square brackets]

Round 1
[Sep 29]
El Nacional          3- 0 Dep. Quito    
LDU de Quito         3- 0 Emelec        
Dep. Cuenca          1- 0 Delfín        
Juvenil              1- 0 Univ. Católica   
Green Cross          4- 1 Técnico Univ.    
Valdez SC            2- 1 Barcelona     

Round 2
[Oct  5]
Univ. Católica       2- 4 Dep. Cuenca   
Barcelona            2- 1 Green Cross   
Técnico Univ.        0- 0 Valdez SC        
[Oct  6]
LDU de Quito         2- 3 Dep. Quito    
Delfín               2- 1 Juvenil       
Emelec               1- 0 El Nacional   

Round 3
[Oct  8]
Valdez SC            1- 1 Green Cross   
[Oct  9]
Dep. Quito           3- 2 Emelec        
El Nacional          1- 1 LDU de Quito  
Delfín               1- 0 Univ. Católica   
Técnico Univ.        2- 0 Barcelona     
Dep. Cuenca          3- 0 Juvenil       

Round 4
[Oct 12]
Univ. Católica       2- 0 Delfín        
[Oct 13]
Barcelona            5- 0 Técnico Univ.    
Juvenil              1- 0 Dep. Cuenca   
LDU de Quito         0- 0 El Nacional   
Green Cross          1- 2 Valdez SC        
Emelec               2- 2 Dep. Quito    

Round 5
[Oct 19]
Barcelona            3- 1 Valdez SC        
Univ. Católica       4- 1 Juvenil       
Técnico Univ.        5- 0 Green Cross   
[Oct 20]
Delfín               2- 2 Dep. Cuenca   
Emelec               3- 1 LDU de Quito  
Dep. Quito           1- 0 El Nacional   

Round 6
[Oct 26]
Green Cross          1- 1 Barcelona     
Valdez SC            1- 0 Técnico Univ.    
Dep. Cuenca          2- 0 Univ. Católica   
[Oct 27]
Juvenil              1- 6 Delfín        
Dep. Quito           0- 2 LDU de Quito  
El Nacional          1- 0 Emelec        

Tables

Group 1

 1.Valdez SC             6  3  2  1  7- 6  9,5 [1,5]  Qualified
 2.Barcelona    	 6  3  1  2 12- 7  9   [2]    Qualified
 - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - 
 3.Técnico Univ.         6  2  1  3  8-10  5
 4.Green Cross           6  1  2  3  8-12  4

Group 2

 1.El Nacional   	 6  2  2  2  5- 3  7,5 [1,5]  Qualified
 2.Dep. Quito            6  3  1  2  9-11  7          Qualified
 - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - 
 3.LDU de Quito          6  2  2  2  9- 7  6,5 [0,5]
 4.Emelec                6  2  1  3  8-10  5,5 [0,5]

[bonus points between square brackets]

Top-2 of each group qualify for Liguilla Final.

Liguilla de no descenso

 1.Dep. Cuenca           6  4  1  1 12- 5  9
 2.Delfín       	 6  3  1  2 11- 7  7
 3.Univ. Católica        6  2  0  4  8- 9  3,5 [-1]
 - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - 
 4.Juvenil               6  2  0  4  5-15  1   [-0,5] (1) Relegated

Juvenil deduced 2 points.
[penalization points between square brackets]


Liguilla Final

Table

 1.Barcelona             6  4  2  0 12- 6 10 Champions
 - - - - - - - - - - - - - - - - - - - - - - - - - - - 
 2.El Nacional  	 6  1  3  2  8-12  5
 3.Valdez SC             6  2  1  3  7-11  5
 4.Dep. Quito            6  2  0  4  9- 7  4

Round 1
[Nov  3]
El Nacional          1- 2 Barcelona     
Valdez SC            2- 1 Dep. Quito    

Round 2
[Nov 10]
Dep. Quito           3- 1 El Nacional   
Barcelona            1- 1 Valdez SC        

Round 3
[Nov 16]
Valdez SC            2- 2 El Nacional   
[Nov 17]
Dep. Quito           1- 2 Barcelona     

Round 4
[Nov 19]
El Nacional          2- 0 Valdez SC        
[Nov 20]
Barcelona            1- 0 Dep. Quito    

Round 5
[Nov 24]
El Nacional          1- 0 Dep. Quito    
Valdez SC            1- 1 Barcelona     

Round 6
[Dec  1]
Barcelona            5- 2 El Nacional   
Dep. Quito           4- 0 Valdez SC        

Table

 1.Barcelona             6  4  2  0 12- 6 10 Champions
 - - - - - - - - - - - - - - - - - - - - - - - - - - - 
 2.El Nacional  	 6  1  3  2  8-12  5
 3.Valdez SC             6  2  1  3  7-11  5
 4.Dep. Quito            6  2  0  4  9- 7  4


Second Place Playoff

[Dec  8]
Valdez SC            2- 1 El Nacional   
   [Eduardo Hurtado(61'), Carlos U. Quinteros(89') / Byron Tenorio(11')]

[Dec 11]
El Nacional          0- 0 Valdez SC        

Topscorers

24 Pedro Emir Varela (Delfín)
18 Byron Tenorio (El Nacional)
17 Rubén Darío Inzúa (Barcelona)
15 Carlos Muñóz Martínez (Barcelona)
15 Manuel Uquillas (Barcelona)
14 Octavio F. Maccaione (Dep. Cuenca)
13 Eduardo Hurtado (Valdez SC)
13 Walter Salazar (Técnico Univ.)
13 Carlos Berrueta (LDU de Quito)
12 Miguel A. Tzitzios (Dep. Cuenca)
11 Heber Bueno (Green Cross)
11 José Moreno (El Nacional)
11 Hermen Benítez (Barcelona)
11 Hugo Rivas Mendoza (Técnico Univ.)
10 Geovanny Mera (Dep. Quito)
10 Fernando Barbosa (Dep. Quito)
10 Patricio Hurtado (El Nacional)
10 Hamilton Cuvi Rivera (Valdez SC)
10 Roberth Burbano (Univ. Católica)



Author:
 Fernando Espinoza Añazco
(nanoespinoza@hotmail.com)
Last updated: 3 Sep 2000

(C) Copyright Fernando Espinoza Añazco and RSSSF
2000

INFORMACIÓN

La Serie A de Ecuador que por motivos de patrocinio es llamada desde 2013 con el nombre de Copa Pilsener, es el torneo oficial de fútbol de primera división realizado por la Federación Ecuatoriana de Fútbol.


  USO DE MEMORIA  
4,381,104 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0019
Controller Execution Time ( Home / Category )  0.5307
Total Execution Time  0.5326
  CADENA URL  
/ecuador1991
  GET DATOS  
$_GET['/ecuador1991']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (34)  
0.0125  SELECT type FROM routes WHERE alias = 'ecuador1991'
0.0252  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'ecuador' 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.0130  SELECT text_es as historical_text FROM leagues_text WHERE id=421
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 = 28744 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0127  SELECT c.id, c.name, c.alias, l.id AS league_id, l.year, l.group_code, l.total_group, c.id AS categoryId, c.stepParent FROM categories AS c INNER JOIN leagues AS l ON c.id=l.categoryId AND c.active_year=l.year WHERE c.id=189 ORDER BY l.group_code ASC
0.0125  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-04-25 01:56:54' 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-04-25 01:56:54' 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-04-25 01:56:54' 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-04-25 01:56:54' 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 = 'ecuador' 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.0125  SELECT e.action, count(e.action) as total, e.player_id FROM events1991 e WHERE e.league_id IN (28744) 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.0125  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 (28744) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN () ORDER BY rp.in_squad = 1 DESC
0.0125  SELECT e.action, count(e.action) as total, e.player_id FROM events1991 e WHERE e.league_id IN (28744) AND (e.action IN (4,5) ) GROUP BY e.player_id ORDER BY total DESC, e.player_id ASC LIMIT 20
0.0126  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 (28744) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN () ORDER BY rp.in_squad = 1 DESC
0.0126  SELECT e.action, count(e.action) as total, e.player_id FROM events1991 e WHERE e.league_id IN (28744) AND (e.action IN (3,4) ) GROUP BY e.player_id ORDER BY total DESC, e.player_id ASC LIMIT 20
0.0126  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 (28744) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN () ORDER BY rp.in_squad = 1 DESC
0.0126  SELECT e.action, count(e.action) as total, e.player_id FROM events1991 e WHERE e.league_id IN (28744) AND (e.action IN (22) ) GROUP BY e.player_id ORDER BY total DESC, e.player_id ASC LIMIT 20
0.0125  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 (28744) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN () ORDER BY rp.in_squad = 1 DESC
0.0125  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 = 28744 AND rp.lineup > 0 ORDER BY rp.lineup DESC,p.pod DESC LIMIT 20
0.0125  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 = 28744 AND rp.events > 0 ORDER BY rp.events DESC,p.pod DESC LIMIT 20
0.0128  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=28744 AND rel.round=22
0.0127  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 = 28744 AND esl.points > 0 ORDER BY esl.points DESC LIMIT 3
0.0126  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 = 28744 AND esl.points > 0
0.0126  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-26" AND c.`active`= 1 and c.comment_id is null and c.lang = 1 AND l.`id` = 28744 ORDER BY creation_date DESC LIMIT 0, 10
0.0130  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-26" AND c.`active`= 1 and comment_id is null and c.lang = 1 AND l.`id` = 28744
0.0126  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` = 28744 AND c.`round` = 22 ORDER BY shedule ASC LIMIT 200
0.0125  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 = 28744 ORDER BY total DESC LIMIT 40
0.0127  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 = 28744 AND e.real_date > NOW() - INTERVAL 1 MONTH ORDER BY e.real_date DESC LIMIT 30
0.0127  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 = 28744 AND t.round = 20 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0127  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 = 28744 AND t.round = 22 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0127  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-25 00:00:00' AND c.`shedule` < '2024-04-29 23:59:59' AND l.id = 28744 ORDER BY c.shedule ASC, fcoef DESC LIMIT 5
0.0127  SELECT data1, data2 FROM services_tags WHERE categoryId=43
0.0127  SELECT l.year,l.group_code FROM leagues_besoccer l WHERE l.categoryId = 43 AND l.year = 1991 ORDER BY l.group_code ASC
0.0127  SELECT group_code, extraName from `leagues` WHERE categoryId=43 AND year=1991