Información Histórica
						
Serie A


First Stage

Table:

 1.Filanbanco           30 18  8  8 65-31 44 [Guayaquil]  Qualified 
 2.Barcelona            30 16  9  5 39-20 41 [Guayaquil]  Qualified 
 3.Dep. Quito           30 14  9  7 53-36 37 [Quito]      Qualified
 4.El Nacional          30 14  7  9 70-47 35 [Quito]      Qualified
 5.Univ. Católica       30 12 10  8 46-36 34 [Quito]      Qualified
 6.9 de Octubre         30 12 10  8 38-29 34 [Milagro]    Qualified
 7.LDU de Portoviejo    30 14  6 10 42-45 34 [Portoviejo] Qualified
 8.Esm. Petrolero       30 14  5 11 36-30 33 [Esmeraldas] Qualified
- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
 9.LDU de Quito         30 14  5 11 52-46 33 [Quito]
10.Emelec               30 11  5 14 43-46 27 [Guayaquil]
11.Dep. Quevedo         30  8 11 11 24-34 27 [Quevedo]
12.Dep. Cuenca          30 10  3 17 40-50 23 [Cuenca]
13.Técnico Univ.        30  8  5 17 28-43 21 [Ambato]
14.Audaz Octubrino      30  9  3 18 32-65 21 [Machala]
15.América              30  4 11 15 18-40 19 [Quito]
16.Manta Sport          30  5  7 18 26-54 17 [Manta]      Relegated

Top-8 qualify for Hexagonal Final 

NB: Filanbanco (3 bonus points), Barcelona (2), Dep. Quito (1). El Nacional, Univ.
    Católica, 9 de Octubre, LDU de Portoviejo y Esmeraldas Petrolero qualified for
    Octogonal Final.

Round  1
[Apr 6]
Univ. Católica       3- 1 LDU de Portoviejo  
Técnico Univ.        1- 1 Filanbanco    
Dep. Cuenca          1- 1 Dep. Quito    
Esm. Petrolero       2- 0 LDU de Quito  
9 de Octubre         2- 0 América    
[Apr  7]
El Nacional          3- 2 Dep. Quevedo  
Manta Sport          0- 3 Barcelona     
Emelec               7- 1 Audaz Octubrino  

Round  2
[Apr 13]
Dep. Quevedo         3- 0 Técnico Univ.    
[Apr 14]
LDU de Quito         3- 2 Manta Sport         
América              0- 1 El Nacional   
Dep. Quito           2- 3 Emelec        
LDU de Portoviejo    0- 0 Esm. Petrolero 
Audaz Octubrino      0- 1 9 de Octubre  
Filanbanco           5- 1 Univ. Católica   
Barcelona            1- 0 Dep. Cuenca   

Round  3
[Apr 20]
Esm. Petrolero       0- 1 Dep. Quito    
[Apr 21]
América              1- 3 Dep. Quevedo  
LDU de Quito         0- 1 Univ. Católica   
Dep. Cuenca          2- 2 Filanbanco    
Manta Sport          0- 1 Audaz Octubrino  
Técnico Univ.        0- 5 El Nacional   
9 de Octubre         2- 0 LDU de Portoviejo  
Barcelona            1- 0 Emelec        

Round  4
[Apr 28]
Univ. Católica       3- 1 9 de Octubre  
Dep. Quito           2- 1 Técnico Univ.    
LDU de Portoviejo    1- 0 LDU de Quito  
El Nacional          2- 1 Barcelona     
Audaz Octubrino      2- 0 Esm. Petrolero 
Dep. Quevedo         2- 0 Dep. Cuenca   
Filanbanco           5- 1 Manta Sport         
Emelec               1- 2 América    

Round  5
[May  1]
América              2- 2 Dep. Quito    
El Nacional          2- 2 LDU de Quito  
Esm. Petrolero       1- 0 Dep. Quevedo  
Manta Sport          0- 2 Emelec        
Técnico Univ.        2- 3 Univ. Católica   
Barcelona            3- 2 LDU de Portoviejo  
Dep. Cuenca          4- 1 Audaz Octubrino  
9 de Octubre         2- 3 Filanbanco    

Round  6
[May  5]
Univ. Católica       5- 1 Dep. Cuenca   
América              0- 1 Técnico Univ.    
LDU de Quito         2- 2 Filanbanco    
Audaz Octubrino      0- 1 Barcelona     
LDU de Portoviejo    3- 0 Dep. Quito    
Dep. Quevedo         1- 1 Manta Sport         
9 de Octubre         4- 1 El Nacional   
Emelec               1- 0 Esm. Petrolero 

Round  7
[May 11]
Manta Sport          1- 0 América    
Técnico Univ.        2- 0 LDU de Portoviejo  
Dep. Cuenca          3- 1 Emelec        
Esm. Petrolero       3- 1 9 de Octubre  
[May 12]
LDU de Quito         1- 1 Dep. Quito    
El Nacional          3- 0 Audaz Octubrino  
Filanbanco           5- 0 Dep. Quevedo  
Barcelona            1- 0 Univ. Católica   

Round  8
[May 19]
América              1- 0 Dep. Cuenca   
Dep. Quito           3- 0 Manta Sport         
Univ. Católica       2- 1 Esm. Petrolero 
LDU de Portoviejo    1- 1 Filanbanco    
Audaz Octubrino      1- 1 Técnico Univ.    
Dep. Quevedo         0- 1 LDU de Quito  
Emelec               1- 1 El Nacional   
9 de Octubre         0- 2 Barcelona     

Round  9
[May 25]
Dep. Cuenca          2- 1 LDU de Portoviejo  
Técnico Univ.        2- 1 Emelec        
[May 26]
El Nacional          0- 0 Univ. Católica   
LDU de Quito         5- 2 Audaz Octubrino  
Barcelona            1- 1 Dep. Quevedo  
Manta Sport          0- 0 9 de Octubre  
Filanbanco           3- 0 Dep. Quito    
[May 25]
Esm. Petrolero       1- 0 América    

Round 10
[Jun  2]
Manta Sport          2- 1 Esm. Petrolero 
América              0- 1 LDU de Quito  
El Nacional          5- 2 Dep. Cuenca   
Dep. Quito           1- 0 Barcelona     
Dep. Quevedo         1- 1 LDU de Portoviejo  
Audaz Octubrino      1- 1 Univ. Católica   
9 de Octubre         2- 0 Técnico Univ.    
Emelec               1- 3 Filanbanco    

Round 11
[Jun  5]
Esm. Petrolero       3- 0 El Nacional   
LDU de Portoviejo    2- 1 Emelec        
Técnico Univ.        1- 2 Manta Sport         
Dep. Cuenca          2- 1 9 de Octubre  
Dep. Quito           1- 0 Dep. Quevedo  
Filanbanco           5- 0 Audaz Octubrino  
Univ. Católica       0- 0 América    
Barcelona            1- 0 LDU de Quito  

Round 12
[Jun  8]
Univ. Católica       0- 0 Dep. Quevedo  
LDU de Quito         3- 1 Técnico Univ.    
Dep. Cuenca          3- 0 Esm. Petrolero 
[Jun  9]
El Nacional          0- 1 Dep. Quito    
Manta Sport          1- 2 LDU de Portoviejo  
Audaz Octubrino      3- 1 América    
Emelec               0- 1 9 de Octubre  
Barcelona            1- 0 Filanbanco    

Round 13
[Jun 15]
América              0- 1 Filanbanco    
Técnico Univ.        0- 1 Dep. Cuenca   
Esm. Petrolero       0- 1 Barcelona     
[Jun 16]
Manta Sport          1- 2 Univ. Católica   
El Nacional          6- 2 LDU de Portoviejo  
Dep. Quevedo         3- 2 Audaz Octubrino  
9 de Octubre         2- 4 Dep. Quito    
Emelec               5- 1 LDU de Quito  

Round 14
[Jun 22]
Univ. Católica       0- 3 Dep. Quito    
Técnico Univ.        2- 1 Esm. Petrolero 
Dep. Cuenca          1- 0 Manta Sport         
[Jun 23]
Barcelona            5- 0 América    
LDU de Portoviejo    3- 1 Audaz Octubrino  
Dep. Quevedo         0- 1 Emelec        
[Aug 14]
LDU de Quito         1- 0 9 de Octubre  
Filanbanco           2- 2 El Nacional   

Round 15
[Jun 29]
Esm. Petrolero       4- 0 Filanbanco    
Univ. Católica       3- 1 Emelec        
LDU de Quito         3- 2 Dep. Cuenca   
[Jun 30]
El Nacional          7- 1 Manta Sport         
LDU de Portoviejo    1- 0 América    
Audaz Octubrino      2- 1 Dep. Quito    
Barcelona            3- 1 Técnico Univ.    
9 de Octubre         5- 0 Dep. Quevedo  

Round 16
[Jul  6]
Audaz Octubrino      1- 2 Emelec        
LDU de Portoviejo    1- 0 Univ. Católica   
[Jul  7]
Barcelona            3- 1 Manta Sport         
LDU de Quito         1- 2 Esm. Petrolero 
Filanbanco           2- 0 Técnico Univ.    
Dep. Quito           3- 2 Dep. Cuenca   
[Aug 21]
Dep. Quevedo         1- 0 El Nacional   
América              0- 0 9 de Octubre  

Round 17
[Jul 10]
Esm. Petrolero       3- 1 LDU de Portoviejo  
Manta Sport          1- 0 LDU de Quito  
Técnico Univ.        0- 0 Dep. Quevedo  
Univ. Católica       1- 2 Filanbanco    
Dep. Cuenca          0- 1 Barcelona     
Emelec               3- 2 Dep. Quito    
[Aug 28]
El Nacional          3- 2 América    
[Aug 29]
9 de Octubre         1- 0 Audaz Octubrino  

Round 18
[Jul 20]
Univ. Católica       1- 2 LDU de Quito  
Dep. Quito           0- 1 Esm. Petrolero 
[Jul 21]
Audaz Octubrino      1- 0 Manta Sport         
Dep. Quevedo         0- 1 América    
Filanbanco           3- 0 Dep. Cuenca   
Emelec               0- 0 Barcelona     
[Sep  4]
El Nacional          2- 1 Técnico Univ.    
LDU de Portoviejo    2- 1 9 de Octubre  

Round 19
[Jul 24]
Esm. Petrolero       1- 0 Audaz Octubrino  
Manta Sport          0- 0 Filanbanco    
Técnico Univ.        2- 1 Dep. Quito    
América              0- 0 Emelec        
LDU de Quito         3- 2 LDU de Portoviejo  
Dep. Cuenca          0- 0 Dep. Quevedo  
9 de Octubre         2- 2 Univ. Católica   
[Sep 18]
Barcelona            0- 0 El Nacional   

Round 20
[Jul 27]
Univ. Católica       2- 2 Técnico Univ.    
Dep. Quito           2- 0 América    
[Jul 28]
LDU de Portoviejo    1- 1 Barcelona     
Dep. Quevedo         1- 0 Esm. Petrolero 
Audaz Octubrino      1- 0 Dep. Cuenca   
Emelec               3- 1 Manta Sport         
Filanbanco           0- 0 9 de Octubre  
[Sep 25]
LDU de Quito         5- 3 El Nacional   

Round 21
[Aug 3]
Dep. Cuenca          2- 1 Univ. Católica   
Técnico Univ.        0- 1 América    
Dep. Quito           8- 1 LDU de Portoviejo  
Esm. Petrolero       3- 1 Emelec        
[Aug  4]
Manta Sport          1- 2 Dep. Quevedo  
Filanbanco           3- 2 LDU de Quito  
Barcelona            2- 0 Audaz Octubrino  
[Sep 11]
El Nacional          1- 2 9 de Octubre  

Round 22
[Aug  7]
9 de Octubre         0- 0 Esm. Petrolero 
Audaz Octubrino      3- 1 El Nacional   
Dep. Quevedo         2- 1 Filanbanco    
América              0- 0 Manta Sport         
Univ. Católica       2- 1 Barcelona     
Dep. Quito           3- 2 LDU de Quito  
LDU de Portoviejo    1- 0 Técnico Univ.    
Emelec               2- 1 Dep. Cuenca   

Round 23
[Aug 10]
Dep. Cuenca          3- 0 América    
Técnico Univ.        5- 0 Audaz Octubrino  
LDU de Quito         2- 1 Dep. Quevedo  
El Nacional          6- 2 Emelec        
Esm. Petrolero       0- 0 Univ. Católica   
[Aug 11]
Manta Sport          1- 1 Dep. Quito    
Filanbanco           2- 0 LDU de Portoviejo  
Barcelona            0- 0 9 de Octubre  

Round 24
[Aug 17]
América              1- 1 Esm. Petrolero 
Univ. Católica       1- 3 El Nacional   
Dep. Quito           0- 0 Filanbanco    
[Aug 18]
Dep. Quevedo         0- 0 Barcelona     
LDU de Portoviejo    1- 0 Dep. Cuenca   
Audaz Octubrino      2- 1 LDU de Quito  
9 de Octubre         3- 2 Manta Sport         
Emelec               2- 1 Técnico Univ.    

Round 25
[Aug 24]
Esm. Petrolero       2- 0 Manta Sport         
Técnico Univ.        0- 1 9 de Octubre  
LDU de Quito         1- 1 América    
Univ. Católica       6- 0 Audaz Octubrino  
[Aug 25]
Dep. Cuenca          2- 1 El Nacional   
LDU de Portoviejo    3- 0 Dep. Quevedo  
Filanbanco           1- 0 Emelec        
Barcelona            1- 1 Dep. Quito    

Round 26
[Aug 31]
América              0- 0 Univ. Católica   
El Nacional          6- 1 Esm. Petrolero 
LDU de Quito         4- 1 Barcelona     
[Sep  1]
Audaz Octubrino      2- 3 Filanbanco    
Manta Sport          0- 0 Técnico Univ.    
Dep. Quevedo         0- 0 Dep. Quito    
9 de Octubre         2- 1 Dep. Cuenca   
Emelec               2- 5 LDU de Portoviejo  

Round 27
[Sep  7]
Esm. Petrolero       3- 2 Dep. Cuenca   
Técnico Univ.        1- 0 LDU de Quito  
[Sep  8]
América              1- 1 Audaz Octubrino  
Dep. Quito           2- 1 El Nacional   
Dep. Quevedo         1- 1 Univ. Católica   
LDU de Portoviejo    1- 0 Manta Sport         
9 de Octubre         0- 0 Emelec        
Filanbanco           3- 1 Barcelona     

Round 28
[Sep 15]
Dep. Cuenca          0- 1 Técnico Univ.    
Univ. Católica       3- 1 Manta Sport         
LDU de Quito         2- 0 Emelec        
Dep. Quito           1- 1 9 de Octubre  
Audaz Octubrino      2- 0 Dep. Quevedo  
LDU de Portoviejo    0- 0 El Nacional   
Filanbanco           3- 1 América    
Barcelona            0- 0 Esm. Petrolero 

Round 29
[Sep 21]
Esm. Petrolero       1- 0 Técnico Univ.    
[Sep 22]
El Nacional          3- 2 Filanbanco    
América              1- 1 Barcelona     
Manta Sport          4- 1 Dep. Cuenca   
Dep. Quito           1- 1 Univ. Católica   
Audaz Octubrino      0- 1 LDU de Portoviejo  
Emelec               0- 0 Dep. Quevedo  
9 de Octubre         1- 1 LDU de Quito  

Round 30
[Sep 29]
América              2- 2 LDU de Portoviejo  
Filanbanco           2- 1 Esm. Petrolero 
Dep. Quito           5- 2 Audaz Octubrino  
Emelec               0- 1 Univ. Católica   
Manta Sport          2- 2 El Nacional   
Dep. Cuenca          2- 3 LDU de Quito  
Dep. Quevedo         0- 0 9 de Octubre  
Técnico Univ.        0- 2 Barcelona     

Table:

 1.Filanbanco           30 18  8  8 65-31 44 [Guayaquil]  Qualified 
 2.Barcelona            30 16  9  5 39-20 41 [Guayaquil]  Qualified 
 3.Dep. Quito           30 14  9  7 53-36 37 [Quito]      Qualified
 4.El Nacional          30 14  7  9 70-47 35 [Quito]      Qualified
 5.Univ. Católica       30 12 10  8 46-36 34 [Quito]      Qualified
 6.9 de Octubre         30 12 10  8 38-29 34 [Milagro]    Qualified
 7.LDU de Portoviejo    30 14  6 10 42-45 34 [Portoviejo] Qualified
 8.Esm. Petrolero       30 14  5 11 36-30 33 [Esmeraldas] Qualified
- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
 9.LDU de Quito         30 14  5 11 52-46 33 [Quito]
10.Emelec               30 11  5 14 43-46 27 [Guayaquil]
11.Dep. Quevedo         30  8 11 11 24-34 27 [Quevedo]
12.Dep. Cuenca          30 10  3 17 40-50 23 [Cuenca]
13.Técnico Univ.        30  8  5 17 28-43 21 [Ambato]
14.Audaz Octubrino      30  9  3 18 32-65 21 [Machala]
15.América              30  4 11 15 18-40 19 [Quito]
16.Manta Sport          30  5  7 18 26-54 17 [Manta]      Relegated

Top-8 qualify for Hexagonal Final 

NB: Filanbanco (3 bonus points), Barcelona (2), Dep. Quito (1). El Nacional, Univ.
    Católica, 9 de Octubre, LDU de Portoviejo y Esmeraldas Petrolero qualified for
    Octogonal Final.


Octogonal Final

Table:

 1.Barcelona            14 11  2  1 29- 5 26 [2] Champions
 2.Dep. Quito           14 10  0  4 28-22 21 [1]
 3.Filanbanco           14  8  1  5 32-15 20 [3]
 4.Esm. Petrolero       14  7  2  5 22-20 16
 5.El Nacional          14  4  4  6 21-21 12
 6.Univ. Católica       14  5  2  7 23-24 12
 7.9 de octubre         14  3  2  9 13-26  8
 8.LDU de Portoviejo    14  0  3 11  7-42  3

[bonus points between square brackets] 

Round 1
[Oct  5]
9 de Octubre         3- 1 Dep. Quito    
[Oct  6]
Univ. Católica       3- 0 Esm. Petrolero 
LDU de Portoviejo    0- 2 Barcelona     
[Oct 16]
El Nacional          2- 1 Filanbanco    

Round 2
[Oct 12]
Esm. Petrolero       1- 1 El Nacional   
[Oct 13]
Dep. Quito           1- 0 Univ. Católica   
Filanbanco           4- 0 LDU de Portoviejo  
Barcelona            1- 0 9 de Octubre  

Round 3
[Oct 20]
El Nacional          3- 1 9 de Octubre  
Dep. Quito           4- 3 Filanbanco    
LDU de Portoviejo    1- 3 Univ. Católica   
Barcelona            2- 0 Esm. Petrolero 

Round 4
[Oct 27]
Esm. Petrolero       1- 0 Dep. Quito    
El Nacional          1- 1 Univ. Católica   
9 de Octubre         0- 0 LDU de Portoviejo  
Filanbanco           0- 2 Barcelona     

Round 5
[Oct 30]
LDU de Portoviejo    2- 2 El Nacional   
Univ. Católica       3- 0 9 de Octubre  
Dep. Quito           2- 1 Barcelona     
Filanbanco           3- 1 Esm. Petrolero 

Round 6
[Nov  3]
Esm. Petrolero       6- 0 LDU de Portoviejo  
El Nacional          2- 3 Dep. Quito    
9 de Octubre         0- 2 Filanbanco    
Barcelona            3- 0 Univ. Católica   

Round 7
[Nov  9]
Univ. Católica       3- 1 Filanbanco    
El Nacional          0- 1 Barcelona     
[Nov 10]
LDU de Portoviejo    1- 2 Dep. Quito    
9 de Octubre         1- 2 Esm. Petrolero 

Round 8
[Nov 16]
Esm. Petrolero       3- 1 Univ. Católica   
[Nov 17]
Dep. Quito           2- 0 9 de Octubre  
Filanbanco           1- 0 El Nacional   
Barcelona            5- 1 LDU de Portoviejo  

Round 9
[Nov 20]
LDU de Portoviejo    0- 6 Filanbanco    
El Nacional          3- 0 Esm. Petrolero 
Univ. Católica       2- 4 Dep. Quito    
9 de Octubre         0- 2 Barcelona     

Round 10
[Nov 23]
Esm. Petrolero       0- 0 Barcelona     
Univ. Católica       3- 0 LDU de Portoviejo  
[Nov 24]
Filanbanco           1- 0 Dep. Quito    
9 de Octubre         4- 1 El Nacional   

Round 11
[Nov 30]
Dep. Quito           3- 0 Esm. Petrolero 
Univ. Católica       1- 1 El Nacional   
[Dec  1]
LDU de Portoviejo    1- 1 9 de Octubre  
Barcelona            0- 0 Filanbanco    

Round 12
[Dec  8]
Esm. Petrolero       2- 1 Filanbanco    
El Nacional          3- 0 LDU de Portoviejo  
9 de Octubre         2- 1 Univ. Católica   
Barcelona            6- 1 Dep. Quito    

Round 13
[Dec 14]
Univ. Católica       1- 2 Barcelona     
Dep. Quito           3- 2 El Nacional   
[Dec 15]
LDU de Portoviejo    1- 3 Esm. Petrolero 
Filanbanco           4- 0 9 de Octubre  

Round 14
[Dec 21]
Esm. Petrolero       3- 1 9 de Octubre  
[Dec 22]
Dep. Quito           2- 0 LDU de Portoviejo  
Filanbanco           5- 1 Univ. Católica   
Barcelona            2- 0 El Nacional   

Table:

 1.Barcelona            14 11  2  1 29- 5 26 [2] Champions
 2.Dep. Quito           14 10  0  4 28-22 21 [1]
 3.Filanbanco           14  8  1  5 32-15 20 [3]
 4.Esm. Petrolero       14  7  2  5 22-20 16
 5.El Nacional          14  4  4  6 21-21 12
 6.Univ. Católica       14  5  2  7 23-24 12
 7.9 de octubre         14  3  2  9 13-26  8
 8.LDU de Portoviejo    14  0  3 11  7-42  3

[bonus points between square brackets] 

Topscores

24 Juan Carlos DeLima (Dep. Quito)
24 Alexander DaSilva "Guga" (Esmeraldas Petrolero)
20 Jesús Cardenas (Emelec)
19 José Villafuerte (El Nacional)
18 José Valencia (Filanbanco)
18 Dardo Peréz (Dep. Quito)
18 Eduardo Emilio Vilarete (Dep. Quito)
14 Osni de Oliveira (9 de Octubre)
13 Mario Calero (Univ. Católica)
13 Samuel C. Dos Santos "Noe" (Filanbanco)
13 Hamilton Cuvi (Filanbanco)
13 Eduardo Aparicio (Filanbanco)
12 Manuel A. Rivadeneira (Esmeraldas Petrolero)
12 Roque Valencia (El Nacional)
12 José Carlos Da Silva (Manta Sport)
12 Fabián Burbano (Técnico Univ.)
12 Luis Carlos Macedo (Filanbanco)
11 Mauricio Arguello (Barcelona)
11 Marcelo Hurtado (Filanbanco)
11 Freddy Barreto (Dep. Quito)
10 Pedro M. Muñoz (9 de Octubre)
10 Raúl Macías (LDU de Portoviejo)
10 Arturo Orellana (El Nacional)
10 Geovanny Mera (El Nacional)
10 Hermen Benítez (El Nacional)
10 Enrique A. Peralta (Dep. Cuenca)




Author:
Fernando Espinoza Añazco (nanoespinoza@hotmail.com) Last updated: 11 Aug 2000 (C) Copyright Fernando Espinoza Añazco and RSSSF 2000

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 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,400,088 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0022
Controller Execution Time ( Home / Category )  0.0896
Total Execution Time  0.0919
  CADENA URL  
/ecuador1985
  GET DATOS  
$_GET['/ecuador1985']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (33)  
0.0018  SELECT type FROM routes WHERE alias = 'ecuador1985'
0.0044  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 = 1985 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=1 DESC LIMIT 1
0.0021  SELECT text_es as historical_text FROM leagues_text WHERE id=411
0.0020  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 = 28737 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0025  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.0019  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-03-29 09:02:39' 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=2 AND last_update > '2024-03-29 09:02:39' 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-03-29 09:02:39' 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-03-29 09:02:39' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0023  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 = 1985 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=0 DESC LIMIT 1
0.0018  SELECT e.action, count(e.action) as total, e.player_id FROM events1985 e WHERE e.league_id IN (28737) 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.0018  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 (28737) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN () ORDER BY rp.in_squad = 1 DESC
0.0018  SELECT e.action, count(e.action) as total, e.player_id FROM events1985 e WHERE e.league_id IN (28737) AND (e.action IN (4,5) ) GROUP BY e.player_id ORDER BY total DESC, e.player_id ASC LIMIT 20
0.0018  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 (28737) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN () ORDER BY rp.in_squad = 1 DESC
0.0019  SELECT e.action, count(e.action) as total, e.player_id FROM events1985 e WHERE e.league_id IN (28737) AND (e.action IN (3,4) ) GROUP BY e.player_id ORDER BY total DESC, e.player_id ASC LIMIT 20
0.0018  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 (28737) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN () ORDER BY rp.in_squad = 1 DESC
0.0021  SELECT e.action, count(e.action) as total, e.player_id FROM events1985 e WHERE e.league_id IN (28737) AND (e.action IN (22) ) GROUP BY e.player_id ORDER BY total DESC, e.player_id ASC LIMIT 20
0.0018  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 (28737) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN () ORDER BY rp.in_squad = 1 DESC
0.0018  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 = 28737 AND rp.lineup > 0 ORDER BY rp.lineup DESC,p.pod DESC LIMIT 20
0.0018  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 = 28737 AND rp.events > 0 ORDER BY rp.events DESC,p.pod DESC LIMIT 20
0.0023  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=28737 AND rel.round=30
0.0020  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 = 28737 AND esl.points > 0 ORDER BY esl.points DESC LIMIT 3
0.0020  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 = 28737 AND esl.points > 0
0.0020  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` = 28737 ORDER BY creation_date DESC LIMIT 0, 10
0.0025  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` = 28737
0.0020  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 `calendars1985` 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` = 28737 AND c.`round` = 30 ORDER BY shedule ASC LIMIT 200
0.0017  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 `events1985` e INNER JOIN calendars1985 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 = 30 AND e.real_date IS NOT NULL AND e.league_id = 28737 ORDER BY total DESC LIMIT 40
0.0023  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 `events1985` e INNER JOIN calendars1985 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 = 28737 AND e.real_date > NOW() - INTERVAL 1 MONTH ORDER BY e.real_date DESC LIMIT 30
0.0023  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 `tables1985` 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 = 28737 AND t.round = 28 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0023  SELECT *,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables1985` 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 = 28737 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0023  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 = 28737 ORDER BY c.shedule ASC, fcoef DESC LIMIT 5
0.0023  SELECT data1, data2 FROM services_tags WHERE categoryId=43
0.0023  SELECT group_code, extraName from `leagues` WHERE categoryId=43 AND year=1985