Información Histórica
						
Serie A


First Stage (Torneo Apertura)

Table:

 1.El Nacional		26 17  2  7 62-25 36 [Quito]     Qualified
 2.9 de Octubre		26 15  3  8 43-34 33 [Milagro]   Qualified
 3.LDU de Portoviejo    26 13  5  8 45-34 31 [Portoviejo]Qualified
 - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
 4.Barcelona		26 13  4  9 34-24 30 [Guayaquil]
 5.Manta Sport 		26 13  3 10 41-39 29 [Manta]
 6.LDU de Quito		26 10  7  9 48-34 27 [Quito]
 7.Técnico Univ.	26 13  1 12 40-36 27 [Ambato]
 8.Emelec		26  9  8  9 30-32 26 [Guayaquil]
 9.Univ. Católica	26  9  7 10 31-31 25 [Quito]
10.Aucas		26  9  6 11 38-44 24 [Quito]
11.Dep. Quito		26  7  8 11 31-48 22 [Quito]
12.Dep. Quevedo		26  7  7 12 22-30 21 [Quevedo]
13.América		26  8  4 14 32-44 20 [Quito]
14.Everest		26  4  5 17 25-67 13 [Guayaquil]

Top-3 qualify for Hexagonal Final 

NB: El Nacional (2 bonus points), 9 de Octubre (1), LDU de Portoviejo (0).

Round  1
[Mar 20]
El Nacional	     4- 1 Emelec        
Técnico Univ.        1- 2 Barcelona     
Aucas                3- 0 Manta Sport         
LDU de Quito         3- 0 Dep. Quito    
Everest              0- 0 Dep. Quevedo  
LDU de Portoviejo    1- 0 América    
9 de Octubre         2- 0 Univ. Católica   

Round  2
[Mar 26]
Manta Sport          2- 1 LDU de Quito  
[Mar 27]
9 de Octubre         1- 1 Emelec        
Dep. Quevedo         2- 1 LDU de Portoviejo  
[Mar 30]
América              6- 0 Everest       
Univ. Católica       0- 1 Técnico Univ.    
[Apr  7]
El Nacional          4- 0 Aucas         
[Apr 27]
Barcelona            2- 0 Dep. Quito    

Round  3
[Apr  3]
América              2- 2 Univ. Católica   
LDU de Quito         4- 2 Dep. Quevedo  
LDU de Portoviejo    2- 1 9 de Octubre  
Emelec               1- 0 Aucas         
Barcelona            2- 0 Everest       
Técnico Univ.        1- 4 El Nacional   
Dep. Quito           1- 2 Manta Sport         

Round  4
[Apr  9]
9 de Octubre         4- 1 América    
Everest              0- 0 LDU de Quito  
[Apr 10]
Dep. Quevedo         1- 1 Emelec        
Manta Sport          3- 1 Técnico Univ.    
Dep. Quito           1- 1 Aucas         
[May 19]
Univ. Católica       4- 1 Barcelona     
El Nacional          2- 1 LDU de Portoviejo  

Round  5
[Apr 17]
América              3- 1 LDU de Quito  
LDU de Portoviejo    4- 0 Univ. Católica   
Emelec               1- 1 Dep. Quito    
Barcelona            1- 0 Manta Sport         
Técnico Univ.        4- 0 Everest       
Aucas                5- 1 9 de Octubre  
[Jun  1]
El Nacional          1- 0 Dep. Quevedo  

Round  6
[Apr 24]
Dep. Quito           2- 1 Everest       
LDU de Quito         3- 1 Aucas         
Dep. Quevedo         1- 0 América    
Manta Sport          0- 2 LDU de Portoviejo  
[May 25]
Barcelona            2- 3 9 de Octubre  
[Jun  1]
Emelec               1- 0 Técnico Univ.    
[Jun  8]
Univ. Católica       1- 0 El Nacional   

Round  7
[Apr 30]
9 de Octubre         1- 0 LDU de Quito  
Técnico Univ.        1- 2 LDU de Portoviejo  
Everest              5- 1 Aucas         
[May  1]
Dep. Quito           4- 1 América    
Manta Sport          2- 0 Emelec        
El Nacional          2- 0 Barcelona     
Univ. Católica       1- 0 Dep. Quevedo  

Round  8
[May  7]
Everest              1- 1 Emelec        
[May  8]
LDU de Portoviejo    2- 1 Aucas         
Dep. Quevedo         2- 1 9 de Octubre  
[May 25]
Univ. Católica       4- 1 Manta Sport         
LDU de Quito         1- 1 Técnico Univ.    
[Jun  1]
Barcelona            5- 0 América    
[Jun 29]
Dep. Quito           2- 6 El Nacional   

Round  9
[May 15]
Emelec               2- 1 Barcelona     
LDU de Quito         0- 0 Univ. Católica   
Técnico Univ.        2- 1 Dep. Quito    
Everest              3- 4 LDU de Portoviejo  
El Nacional          2- 1 9 de Octubre  
Aucas                1- 1 América    
Manta Sport          0- 0 Dep. Quevedo  

Round 10
[May 21]
Everest              0- 0 El Nacional   
9 de Octubre         2- 0 Manta Sport         
[May 22]
Dep. Quevedo         0- 0 Barcelona     
LDU de Portoviejo    2- 1 LDU de Quito  
Aucas                2- 1 Técnico Univ.    
América              0- 3 Emelec        
Univ. Católica       2- 2 Dep. Quito    

Round 11
[May 29]
Univ. Católica       5- 3 Everest       
El Nacional          2- 2 LDU de Quito  
Dep. Quito           1- 0 9 de Octubre  
Técnico Univ.        3- 1 Dep. Quevedo  
Manta Sport          5- 2 América    
Emelec               2- 1 LDU de Portoviejo  
Barcelona            4- 1 Aucas         

Round 12
[Jun  5]
Aucas                1- 1 Univ. Católica   
LDU de Quito         2- 1 Emelec        
Everest              3- 2 Manta Sport         
LDU de Portoviejo    1- 0 Barcelona     
Dep. Quevedo         0- 1 Dep. Quito    
América              1- 2 El Nacional   
9 de Octubre         3- 1 Técnico Univ.    

Round 13
[Jun 12]
Técnico Univ.        2- 1 América    
Manta Sport          1- 0 El Nacional   
Dep. Quito           2- 2 LDU de Portoviejo  
Aucas                1- 0 Dep. Quevedo  
9 de Octubre         2- 1 Everest       
Emelec               1- 1 Univ. Católica   
LDU de Quito         2- 0 Barcelona     

Round 14
[Jun 16]
Barcelona            1- 0 Técnico Univ.    
[Jun 18]
Univ. Católica       0- 1 9 de Octubre  
Dep. Quito           4- 4 LDU de Quito  
América              2- 1 LDU de Portoviejo  
[Jun 19]
Manta Sport          2- 0 Aucas         
Emelec               1- 0 El Nacional   
Dep. Quevedo         4- 1 Everest       

Round 15
[Jun 25]
Técnico Univ.        3- 1 Univ. Católica   
LDU de Quito         0- 0 Manta Sport         
Dep. Quito           0- 0 Barcelona     
Aucas                2- 1 El Nacional   
[Jun 26]
LDU de Portoviejo    2- 3 Dep. Quevedo  
Everest              2- 1 América    
Emelec               1- 3 9 de Octubre  

Round 16
[Jul  2]
Univ. Católica       0- 1 América    
9 de Octubre         3- 3 LDU de Portoviejo  
El Nacional          5- 1 Técnico Univ.    
Aucas                3- 2 Emelec        
[Jul  3]
Manta Sport          4- 0 Dep. Quito    
Dep. Quevedo         2- 1 LDU de Quito  
Everest              1- 0 Barcelona     

Round 17
[Jul  9]
América              0- 1 9 de Octubre  
Técnico Univ.        3- 1 Manta Sport         
LDU de Quito        10- 0 Everest       
Aucas                0- 1 Dep. Quito    
[Jul 10]
LDU de Portoviejo    4- 2 El Nacional   
Emelec               0- 0 Dep. Quevedo  
Barcelona            1- 0 Univ. Católica   

Round 18
[Jul 16]
Univ. Católica       2- 1 LDU de Portoviejo  
Everest              0- 1 Técnico Univ.    
9 de Octubre         3- 2 Aucas         
Dep. Quito           2- 2 Emelec        
LDU de Quito         0- 0 América    
[Jul 17]
Manta Sport          2- 1 Barcelona     
Dep. Quevedo         0- 2 El Nacional   

Round 19
[Jul 23]
América              1- 0 Dep. Quevedo  
El Nacional          1- 0 Univ. Católica   
Aucas                1- 2 LDU de Quito  
[Jul 24]
Técnico Univ.        3- 0 Emelec        
LDU de Portoviejo    1- 1 Manta Sport         
9 de Octubre         2- 0 Barcelona     
Everest              2- 2 Dep. Quito    

Round 20
[Jul 30]
Aucas                3- 0 Everest       
América              3- 1 Dep. Quito    
LDU de Quito         2- 0 9 de Octubre  
[Jul 31]
LDU de Portoviejo    1- 0 Técnico Univ.    
Dep. Quevedo         0- 0 Univ. Católica   
Emelec               1- 2 Manta Sport         
Barcelona            1- 0 El Nacional   

Round 21
[Aug 21]
América              0- 0 Barcelona     
Aucas                1- 1 LDU de Portoviejo  
Técnico Univ.        4- 3 LDU de Quito  
Manta Sport          3- 2 Univ. Católica   
Emelec               2- 1 Everest       
9 de Octubre         1- 1 Dep. Quevedo  
[Aug 31]
El Nacional          4- 0 Dep. Quito    

Round 22
[Aug 27]
América              2- 3 Aucas         
Dep. Quito           2- 0 Técnico Univ.    
Univ. Católica       0- 1 LDU de Quito  
[Aug 28]
Dep. Quevedo         2- 0 Manta Sport         
LDU de Portoviejo    1- 0 Everest       
Barcelona            1- 0 Emelec        
9 de Octubre         3- 2 El Nacional   

Round 23
[Sep 11]
Dep. Quito           0- 2 Univ. Católica   
El Nacional          7- 0 Everest       
LDU de Quito         2- 1 LDU de Portoviejo  
Técnico Univ.        3- 0 Aucas         
Manta Sport          3- 0 9 de Octubre  
Emelec               3- 0 América    
Barcelona            3- 0 Dep. Quevedo  

Round 24
[Sep 17]
América              3- 1 Manta Sport         
9 de Octubre         1- 0 Dep. Quito    
Aucas                1- 1 Barcelona     
LDU de Quito         1- 3 El Nacional   
[Sep 18]
Dep. Quevedo         0- 1 Técnico Univ.    
LDU de Portoviejo    0- 0 Emelec        
Everest              0- 1 Univ. Católica   

Round 25
[Sep 21]
Técnico Univ.        2- 0 9 de Octubre  
Manta Sport          3- 1 Everest       
Dep. Quito           1- 0 Dep. Quevedo  
El Nacional          1- 0 América    
Emelec               2- 1 LDU de Quito  
Univ. Católica       1- 1 Aucas         
Barcelona            3- 1 LDU de Portoviejo  

Round 26
[Sep 24]
América              1- 0 Técnico Univ.    
Univ. Católica       1- 0 Emelec        
El Nacional          5- 1 Manta Sport         
Everest              0- 3 9 de Octubre  
[Sep 25]
Dep. Quevedo         1- 3 Aucas         
LDU de Portoviejo    3- 0 Dep. Quito    
Barcelona            2- 1 LDU de Quito  

Table:

 1.El Nacional		26 17  2  7 62-25 36 [Quito]     Qualified
 2.9 de Octubre		26 15  3  8 43-34 33 [Milagro]   Qualified
 3.LDU de Portoviejo    26 13  5  8 45-34 31 [Portoviejo]Qualified
 - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
 4.Barcelona		26 13  4  9 34-24 30 [Guayaquil]
 5.Manta Sport 		26 13  3 10 41-39 29 [Manta]
 6.LDU de Quito		26 10  7  9 48-34 27 [Quito]
 7.Técnico Univ.	26 13  1 12 40-36 27 [Ambato]
 8.Emelec		26  9  8  9 30-32 26 [Guayaquil]
 9.Univ. Católica	26  9  7 10 31-31 25 [Quito]
10.Aucas		26  9  6 11 38-44 24 [Quito]
11.Dep. Quito		26  7  8 11 31-48 22 [Quito]
12.Dep. Quevedo		26  7  7 12 22-30 21 [Quevedo]
13.América		26  8  4 14 32-44 20 [Quito]
14.Everest		26  4  5 17 25-67 13 [Guayaquil]

Top-3 qualify for Hexagonal Final 

NB: El Nacional (2 bonus points), 9 de Octubre (1), LDU de Portoviejo (0).


Second Stage

Octogonal

Table:

 1.Barcelona  		14  8  2  4 23-11 18 Qualified
 2.El Nacional 		14  7  2  5 17-12 16 Qualified
 3.Técnico Univ.    	14  7  1  6 24-23 15 Qualified
 - - - - - - - - - - - - - - - - - - - - - - - - - - -
 4.Manta Sport		14  5  4  5 19-18 14
 5.LDU de Quito         14  5  4  5 16-17 14
 6.LDU de Portoviejo    14  6  2  6 18-25 14
 7.9 de Octubre  	14  4  4  6 19-23 12
 8.Emelec		14  2  5  7 20-27  9

Top-3 qualify for Hexagonal Final 

NB: Barcelona (2 bonus points), El Nacional (1), Técnico Universitario (0).
    Manta Sport qualify by best team in aggregate table (but not bonus points).

Round 1
[Oct  2]
El Nacional          2- 1 Emelec        
Técnico Univ.        4- 1 Manta Sport         
LDU de Portoviejo    1- 0 Barcelona     
9 de Octubre         1- 1 LDU de Quito  

Round 2
[Oct  5]
Manta Sport          2- 2 9 de Octubre  
Emelec               1- 1 Técnico Univ.    
LDU de Quito         1- 1 LDU de Portoviejo  
Barcelona            2- 0 El Nacional   

Round 3
[Oct  9]
El Nacional          1- 0 Manta Sport         
Técnico Univ.        2- 1 LDU de Quito  
LDU de Portoviejo    2- 1 Emelec        
9 de Octubre         0- 4 Barcelona     

Round 4
[Oct 12]
Manta Sport          2- 1 LDU de Portoviejo  
9 de Octubre         1- 2 Emelec        
LDU de Quito         0- 1 El Nacional   
Barcelona            4- 0 Técnico Univ.    

Round 5
[Oct 16]
El Nacional          0- 2 9 de Octubre  
Técnico Univ.        5- 1 LDU de Portoviejo  
Manta Sport          2- 1 Barcelona     
Emelec               1- 1 LDU de Quito  

Round 6
[Oct 19]
LDU de Portoviejo    1- 0 El Nacional   
9 de Octubre         1- 0 Técnico Univ.    
LDU de Quito         2- 0 Manta Sport         
Barcelona            1- 1 Emelec        

Round 7
[Oct 23]
Técnico Univ.        2- 1 El Nacional   
Manta Sport          1- 1 Emelec        
LDU de Quito         1- 0 Barcelona     
9 de Octubre         4- 0 LDU de Portoviejo  

Round 8
[Oct 30]
Manta Sport          4- 0 Técnico Univ.    
LDU de Quito         2- 2 9 de Octubre  
Emelec               0- 3 El Nacional   
Barcelona            3- 2 LDU de Portoviejo  

Round 9
[Nov  2]
Técnico Univ.        2- 1 Emelec        
LDU de Portoviejo    2- 1 LDU de Quito  
9 de Octubre         0- 0 Manta Sport         
[Nov 16]
El Nacional          0- 0 Barcelona     

Round 10
[Nov  6]
Manta Sport          0- 0 El Nacional   
Emelec               1- 1 LDU de Portoviejo  
Barcelona            1- 0 9 de Octubre  
[Nov 16]
LDU de Quito         2- 1 Técnico Univ.    

Round 11
[Nov  9]
LDU de Portoviejo    0- 2 Manta Sport         
Emelec               3- 4 9 de Octubre  
Técnico Univ.        2- 0 Barcelona     
El Nacional          1- 2 LDU de Quito  

Round 12
[Nov 13]
LDU de Quito         2- 1 Emelec        
LDU de Portoviejo    2- 0 Técnico Univ.    
9 de Octubre         0- 1 El Nacional   
Barcelona            2- 0 Manta Sport         

Round 13
[Nov 20]
Manta Sport          2- 0 LDU de Quito  
El Nacional          4- 1 LDU de Portoviejo  
Técnico Univ.        4- 1 9 de Octubre  
Emelec               2- 3 Barcelona     

Round 14
[Nov 23]
LDU de Portoviejo    3- 1 9 de Octubre  
Emelec               4- 3 Manta Sport         
El Nacional          3- 1 Técnico Univ.    
Barcelona            2- 0 LDU de Quito  

Table:

 1.Barcelona  		14  8  2  4 23-11 18 Qualified
 2.El Nacional 		14  7  2  5 17-12 16 Qualified
 3.Técnico Univ.    	14  7  1  6 24-23 15 Qualified
 - - - - - - - - - - - - - - - - - - - - - - - - - - -
 4.Manta Sport		14  5  4  5 19-18 14
 5.LDU de Quito         14  5  4  5 16-17 14
 6.LDU de Portoviejo    14  6  2  6 18-25 14
 7.9 de Octubre  	14  4  4  6 19-23 12
 8.Emelec		14  2  5  7 20-27  9

Top-3 qualify for Hexagonal Final 

NB: Barcelona (2 bonus points), El Nacional (1), Técnico Universitario (0).
    Manta Sport qualify by best team in aggregate table (but not bonus points).


Hexagonal por el no descenso

Table:

 1.Dep. Quito 		10  5  4  1 14- 8 14
 2.Univ. Católica	10  5  3  2 12- 9 13
 3.Aucas             	10  3  4  3 16-12 10
 4.América    		10  3  3  4 13-13  9
 5.Dep. Quevedo         10  3  1  6 10-16  7
 - - - - - - - - - - - - - - - - - - - - - -
 6.Everest              10  2  3  5  6-13  7 Relegated

Round 1
[Oct  2]
Univ. Católica       2- 1 Everest       
Aucas                5- 0 América    
Dep. Quevedo         0- 1 Dep. Quito    

Round 2
[Oct  5]
América              0- 1 Univ. Católica   
Everest              1- 1 Dep. Quito    
Aucas                2- 0 Dep. Quevedo  

Round 3
[Oct  9]
América              3- 0 Everest       
Dep. Quito           0- 0 Aucas         
Dep. Quevedo         3- 0 Univ. Católica   

Round 4
[Oct 12]
Aucas                1- 2 Univ. Católica   
Everest              1- 0 Dep. Quevedo  
Dep. Quito           3- 2 América    

Round 5
[Oct 16]
Aucas                2- 0 Everest       
Univ. Católica       0- 0 Dep. Quito    
Dep. Quevedo         1- 1 América    

Round 6
[Oct 19]
Dep. Quito           2- 1 Dep. Quevedo  
Everest              0- 0 Univ. Católica   
América              1- 1 Aucas         

Round 7
[Oct 23]
Univ. Católica       0- 0 América    
Dep. Quito           3- 1 Everest       
Dep. Quevedo         3- 1 Aucas         

Round 8
[Oct 30]
Univ. Católica       3- 0 Dep. Quevedo  
Aucas                2- 2 Dep. Quito    
Everest              2- 0 América    

Round 9
[Nov  2]
Dep. Quevedo         2- 0 Everest       
América              1- 0 Dep. Quito    
[Nov  9]
Univ. Católica       4- 2 Aucas         

Round 10
[Nov  6]
Everest              0- 0 Aucas         
[Nov 13]
Dep. Quito           2- 0 Univ. Católica   
América              5- 0 Dep. Quevedo  

Table:

 1.Dep. Quito 		10  5  4  1 14- 8 14
 2.Univ. Católica	10  5  3  2 12- 9 13
 3.Aucas             	10  3  4  3 16-12 10
 4.América    		10  3  3  4 13-13  9
 5.Dep. Quevedo         10  3  1  6 10-16  7
 - - - - - - - - - - - - - - - - - - - - - -
 6.Everest              10  2  3  5  6-13  7 Relegated


Hexagonal Final

 1.El Nacional		10  5  2  3 21-13 15 [3] Champions
 2.9 de Octubre  	10  5  2  3 14-14 13 [1]
 3.Barcelona         	10  4  2  4 18-16 12 [2]
 4.LDU de Portoviejo	10  5  0  5 16-13 10
 5.Técnico Univ.        10  5  0  5 20-23 10
 6.Manta Sport          10  1  4  5 15-25  6

[bonus points between square brackets] 

Round 1
[Nov 27]
Técnico Univ.        3- 2 9 de Octubre  
Manta Sport          1- 1 El Nacional   
Barcelona            2- 1 LDU de Portoviejo  

Round 2
[Nov 30]
El Nacional          3- 0 Barcelona     
LDU de Portoviejo    4- 0 Técnico Univ.    
9 de Octubre         1- 1 Manta Sport         

Round 3
[Dec  4]
Técnico Univ.        6- 0 Manta Sport         
LDU de Portoviejo    2- 1 El Nacional   
Barcelona            1- 1 9 de Octubre  

Round 4
[Dec  7]
Manta Sport          1- 2 LDU de Portoviejo  
El Nacional          2- 1 9 de Octubre  
Barcelona            4- 1 Técnico Univ.    

Round 5
[Dec 11]
Técnico Univ.        1- 5 El Nacional   
Manta Sport          2- 0 Barcelona     
9 de Octubre         2- 1 LDU de Portoviejo  

Round 6
[Dec 18]
LDU de Portoviejo    2- 1 Barcelona     
[Dec 18]
9 de Octubre         1- 0 Técnico Univ.    
El Nacional          3- 3 Manta Sport         

Round 7
[Dec 21]
Manta Sport          0- 1 9 de Octubre  
Técnico Univ.        2- 1 LDU de Portoviejo  
Barcelona            2- 1 El Nacional   

Round 8
[Dec 23]
Manta Sport          3- 5 Técnico Univ.    
El Nacional          1- 0 LDU de Portoviejo  
9 de Octubre         0- 4 Barcelona     

Round 9
[Dec 27]
Técnico Univ.        2- 1 Barcelona     
9 de Octubre         3- 2 El Nacional   
LDU de Portoviejo    3- 1 Manta Sport         

Round 10
[Dec 30]
El Nacional          2- 0 Técnico Univ.    
LDU de Portoviejo    0- 2 9 de Octubre  
Barcelona            3- 3 Manta Sport         

Hexagonal Final

 1.El Nacional		10  5  2  3 21-13 15 [3] Champions
 2.9 de Octubre  	10  5  2  3 14-14 13 [1]
 3.Barcelona         	10  4  2  4 18-16 12 [2]
 4.LDU de Portoviejo	10  5  0  5 16-13 10
 5.Técnico Univ.        10  5  0  5 20-23 10
 6.Manta Sport          10  1  4  5 15-25  6

[bonus points between square brackets] 

Topsorers

29 Paulo César (Barcelona)
23 Alcides de Oliveira (LDU de Quito)
21 Geovanny Mera (Técnico Univ.)
21 Freddy Maneiro (Técnico Univ.)
21 Sergio Antonio Saucedo (Dep. Quito)
19 Roque Valencia (Manta Sport)
17 Fabian Pazymiño (El Nacional)
17 Víctor Bonilla (9 de Octubre)
17 Paulo Damasco (LDU de Portoviejo)
15 Mariano Biondi (LDU de Portoviejo)
15 Eduardo Muñoz (América)
14 José Villafuerte (El Nacional)
14 Hermen Benítez (El Nacional)
14 Jesús Cardenas (Emelec)
14 Osni de Oliveira (9 de Octubre)
13 Roque Parraga (Técnico Univ.)
13 José Moreno (LDU de Quito)
13 Hamilton Cuvi (9 de Octubre)
13 Vinicio Ron (Univ. Católica)
13 Gabriel Cantos (LDU de Portoviejo)
12 Fernando Baldeón (El Nacional)
12 Nestor Barú (Dep. Quito)
12 José Carlos Da Silva (Dep. Quevedo)
12 Ramon Marquez (LDU de Portoviejo)
11 Gorky Revelo (Técnico Univ.)
10 Galo Vásquez (Barcelona)
10 Lupo Quiñónez (Manta sport)
10 Jimmy Sion (Manta sport)



Author:
Fernando Espinoza Añazco (nanoespinoza@hotmail.com) Last updated: 23 Nov 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,388,584 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0018
Controller Execution Time ( Home / Category )  0.1429
Total Execution Time  0.1447
  CADENA URL  
/ecuador1983
  GET DATOS  
$_GET['/ecuador1983']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (28)  
0.0034  SELECT type FROM routes WHERE alias = 'ecuador1983'
0.0072  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 = 1983 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=43 AND type_rel = 3
0.0055  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 3 AND rel.typeId = 43 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 (1297904,1299685,1289627,1269214,1269123) ORDER BY n.cover_points DESC, update_date DESC
0.0037  SELECT text_es as historical_text FROM leagues_text WHERE id=409
0.0037  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 = 28734 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0038  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.0039  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='2024' WHERE c.parentId=189 GROUP BY c.id ORDER BY c.order_id ASC
0.0035  SELECT type,rule FROM rules WHERE categoryId = 43 ORDER BY type = 'tables_draw' DESC,type != 'extra' DESC, `order` ASC
0.0035  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-03-29 09:01:54' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0035  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=2 AND last_update > '2024-03-29 09:01:54' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0035  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=4 AND last_update > '2024-03-29 09:01:54' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0036  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=3 AND last_update > '2024-03-29 09:01:54' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0039  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 = 1983 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=0 DESC LIMIT 1
0.0037  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=28734 AND rel.round=26
0.0038  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 = 28734 AND esl.points > 0 ORDER BY esl.points DESC LIMIT 3
0.0034  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 = 28734 AND esl.points > 0
0.0034  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` = 28734 ORDER BY creation_date DESC LIMIT 0, 10
0.0038  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` = 28734
0.0038  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 `calendars1983` 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` = 28734 AND c.`round` = 26 ORDER BY shedule ASC LIMIT 200
0.0036  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 `events1983` e INNER JOIN calendars1983 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 = 26 AND e.real_date IS NOT NULL AND e.league_id = 28734 ORDER BY total DESC LIMIT 40
0.0040  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 `events1983` e INNER JOIN calendars1983 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 = 28734 AND e.real_date > NOW() - INTERVAL 1 MONTH ORDER BY e.real_date DESC LIMIT 30
0.0043  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 `tables1983` 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 = 28734 AND t.round = 24 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0037  SELECT *,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables1983` 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 = 28734 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0035  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 = 28734 ORDER BY c.shedule ASC, fcoef DESC LIMIT 5
0.0041  SELECT data1, data2 FROM services_tags WHERE categoryId=43
0.0041  SELECT group_code, extraName from `leagues` WHERE categoryId=43 AND year=1983