Información Histórica
						
Serie A


First Stage

Table

 1.LDU de Quito         34 20  9  5 64-36 49 [Quito]      Qualified
 2.Emelec       	34 16 12  6 56-36 44 [Guayaquil]  Qualified
 3.Macará               34 13 15  6 50-32 41 [Ambato]     Qualified
 4.Barcelona            34 13 14  7 50-25 40 [Guayaquil]  Qualified
 5.Dep. Quito  		34 13 13  8 48-43 39 [Quito]      Qualified
 6.Univ. Católica   	34 13 10 11 45-37 36 [Quito]      Qualified
 7.Filanbanco     	34 14  8 12 38-33 36 [Milagro]    Qualified
 8.El Nacional          34 12 11 11 49-41 35 [Quito]      Qualified
 - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - 
 9.Técnico Univ.        34 11 12 11 42-39 34 [Ambato]
10.Aucas        	34 11 12 11 45-49 34 [Quito]
11.Dep. Cuenca   	34  7 19  8 41-45 33 [Cuenca]
12.Esm. Petrolero       34 11 10 13 40-50 32 [Esmeraldas]
13.Audaz Octubrino      34 12  7 15 32-43 31 [Machala]
14.Dep. Quevedo         34 10  8 16 27-44 28 [Quevedo]
15.Juventus             34  7 13 14 31-44 27 [Esmeraldas]
16.LDU de Portoviejo    34  9  9 16 34-50 27 [Portoviejo]
17.River Plate          34  9  7 18 27-53 25 [Riobamba]
 - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - 
18.América              34  5 11 18 29-48 21 [Quito]     Relegated

Top-8 qualify for Second Stage.

NB: LDU de Quito(1 bonus point), Emelec (1) for second stage.

Round  1
[Mar  5]
Esm. Petrolero       1- 0 Dep. Quevedo  
Técnico Univ.        1- 0 Univ. Católica   
[Mar  6]
América              1- 0 Juventus      
LDU de Quito         1- 0 Macara        
Dep. Cuenca          1- 1 Barcelona     
Aucas                4- 1 LDU de Portoviejo  
Audaz Octubrino      1- 0 River Plate
Filanbanco           1- 1 El Nacional   
Emelec               0- 0 Dep. Quito    

Round  2
[Mar 12]
Juventus             1- 1 Dep. Cuenca   
Macara               0- 1 Aucas         
[Mar 13]
Univ. Católica       1- 2 Emelec        
El Nacional          1- 0 Audaz Octubrino  
Dep. Quito           1- 1 América    
River Plate          0- 1 Filanbanco    
Dep. Quevedo         1- 0 Técnico Univ.    
LDU de Portoviejo    2- 1 LDU de Quito  
Barcelona            2- 1 Esm. Petrolero 

Round  3
[Mar 19]
Esm. Petrolero       1- 1 El Nacional   
Filanbanco           1- 0 Univ. Católica   
Técnico Univ.        3- 0 Juventus      
[Mar 20]
Dep. Quito           2- 1 LDU de Portoviejo  
Aucas                2- 0 River Plate
Dep. Cuenca          3- 1 Dep. Quevedo  
América              0- 2 LDU de Quito  
Audaz Octubrino      1- 0 Barcelona     
Emelec               2- 2 Macara        

Round  4
[Mar 23]
Juventus             2- 1 Emelec        
River Plate          0- 2 Técnico Univ.    
LDU de Portoviejo    2- 0 América    
Dep. Quevedo         1- 1 Filanbanco    
Macara               2- 2 Dep. Cuenca   
Univ. Católica       2- 1 Esm. Petrolero 
LDU de Quito         3- 1 Audaz Octubrino  
Aucas                4- 2 El Nacional   
Barcelona            2- 1 Dep. Quito    

Round  5
[Mar 26]
Esm. Petrolero       1- 0 Macara        
El Nacional          5- 2 Dep. Quevedo  
Filanbanco           1- 0 Juventus      
Técnico Univ.        2- 1 Barcelona     
Dep. Quito           3- 5 LDU de Quito  
[Mar 27]
América              1- 3 Univ. Católica   
Dep. Cuenca          2- 1 River Plate
Audaz Octubrino      2- 2 Aucas         
Emelec               2- 1 LDU de Portoviejo  

Round  6
[Apr  2]
Juventus             1- 1 El Nacional   
Univ. Católica       1- 0 Dep. Cuenca   
Dep. Quito           3- 2 Filanbanco    
Aucas                2- 2 Emelec        
[Apr  3]
Macara               1- 1 Audaz Octubrino  
River Plate          3- 2 Esm. Petrolero 
Dep. Quevedo         0- 0 LDU de Quito  
LDU de Portoviejo    0- 1 Técnico Univ.    
Barcelona            0- 0 América    

Round  7
[Apr  9]
Esm. Petrolero       2- 2 Juventus      
Filanbanco           4- 0 Macara        
Dep. Cuenca          3- 0 LDU de Portoviejo  
Técnico Univ.        0- 0 Aucas         
[Apr 10]
LDU de Quito         0- 1 Univ. Católica   
El Nacional          2- 1 Barcelona     
América              3- 2 River Plate
Audaz Octubrino      4- 3 Dep. Quito    
Emelec               2- 1 Dep. Quevedo  

Round  8
[Apr 16]
Juventus             1- 1 Audaz Octubrino  
Dep. Quito           3- 3 Técnico Univ.    
LDU de Quito         3- 1 Dep. Cuenca   
Aucas                4- 1 Esm. Petrolero 
[Apr 17]
Macara               2- 1 El Nacional   
River Plate          1- 0 Univ. Católica   
Dep. Quevedo         0- 0 América    
LDU de Portoviejo    1- 0 Filanbanco    
Barcelona            1- 1 Emelec        

Round  9
[Apr 19]
América              2- 2 Aucas         
[Apr 20]
Esm. Petrolero       2- 2 LDU de Portoviejo  
Filanbanco           1- 2 LDU de Quito  
Técnico Univ.        1- 1 Emelec        
Audaz Octubrino      3- 2 Dep. Quevedo  
El Nacional          4- 1 River Plate
Univ. Católica       2- 1 Juventus      
Dep. Cuenca          1- 1 Dep. Quito    
Barcelona            3- 0 Macara        

Round 10
[Apr 23]
Juventus             0- 0 Barcelona     
River Plate          0- 2 LDU de Quito  
[Apr 24]
Dep. Quito           1- 2 Esm. Petrolero 
América              2- 2 Dep. Cuenca   
Técnico Univ.        1- 1 Macara        
Aucas                3- 1 Filanbanco    
LDU de Portoviejo    2- 0 El Nacional   
Dep. Quevedo         1- 0 Univ. Católica   
Emelec               2- 0 Audaz Octubrino  

Round 11
[Apr 20]
Macara               3- 1 LDU de Portoviejo  
[Apr 30]
Esm. Petrolero       1- 0 Emelec        
Dep. Quito           1- 1 Dep. Quevedo  
LDU de Quito         3- 1 Juventus      
Filanbanco           1- 0 Técnico Univ.    
Univ. Católica       2- 1 El Nacional   
Barcelona            3- 0 River Plate
[May  1]
Dep. Cuenca          2- 0 Aucas         
Audaz Octubrino      1- 0 América    

Round 12
[May  4]
Juventus             1- 0 Dep. Quito    
América              0- 1 Filanbanco    
Técnico Univ.        2- 2 Esm. Petrolero 
LDU de Portoviejo    0- 0 Barcelona     
Dep. Quevedo         0- 2 Macara        
Univ. Católica       2- 0 Audaz Octubrino  
LDU de Quito         1- 0 Aucas         
Dep. Cuenca          1- 1 El Nacional   
Emelec               2- 1 River Plate

Round 13
[May 14]
Esm. Petrolero       1- 1 LDU de Quito  
[May 15]
Aucas                3- 2 Juventus      
El Nacional          2- 3 Emelec        
River Plate          2- 0 LDU de Portoviejo  
Macara               3- 0 América    
Dep. Quito           3- 2 Univ. Católica   
Filanbanco           2- 0 Dep. Cuenca   
Audaz Octubrino      2- 0 Técnico Univ.    
Barcelona            4- 1 Dep. Quevedo  

Round 14
[May 21]
Juventus             0- 0 Macara        
América              1- 1 Esm. Petrolero 
LDU de Quito         3- 1 Barcelona     
Dep. Quito           1- 0 River Plate
Técnico Univ.        1- 3 El Nacional   
[May 22]
Dep. Cuenca          2- 0 Audaz Octubrino  
Dep. Quevedo         3- 0 Aucas         
LDU de Portoviejo    5- 1 Univ. Católica   
Emelec               1- 1 Filanbanco    

Round 15
[May 24]
El Nacional          0- 1 Dep. Quito    
Aucas                0- 4 Barcelona     
[May 25]
Esm. Petrolero       2- 0 Dep. Cuenca   
LDU de Portoviejo    0- 0 Juventus      
Audaz Octubrino      2- 0 Filanbanco    
Técnico Univ.        1- 2 LDU de Quito  
River Plate          1- 0 Dep. Quevedo  
Univ. Católica       1- 1 Macara        
Emelec               1- 0 América    

Round 16
[Jun  4]
Juventus             0- 1 River Plate
América              1- 3 Técnico Univ.    
Aucas                2- 1 Univ. Católica   
LDU de Quito         1- 1 El Nacional   
[Jun  5]
Dep. Cuenca          3- 3 Emelec        
Macara               1- 0 Dep. Quito    
Audaz Octubrino      2- 1 Esm. Petrolero 
Dep. Quevedo         2- 1 LDU de Portoviejo  
Barcelona            0- 0 Filanbanco    

Round 17
[Jun 11]
Esm. Petrolero       0- 1 Filanbanco    
El Nacional          0- 0 América    
Dep. Quito           2- 0 Aucas         
Univ. Católica       2- 2 Barcelona     
[Jun 12]
Técnico Univ.        2- 2 Dep. Cuenca   
River Plate          0- 2 Macara        
Dep. Quevedo         1- 0 Juventus      
LDU de Portoviejo    1- 0 Audaz Octubrino  
Emelec               2- 0 LDU de Quito  

Round 18
[Jun 18]
Juventus             3- 1 América    
Macara               0- 0 LDU de Quito  
Barcelona            1- 1 Dep. Cuenca   
[Jun 19]
Univ. Católica       1- 0 Técnico Univ.    
El Nacional          2- 0 Filanbanco    
River Plate          1- 1 Audaz Octubrino  
Dep. Quito           2- 1 Emelec        
Dep. Quevedo         2- 1 Esm. Petrolero 
LDU de Portoviejo    1- 1 Aucas         

Round 19
[Jun 22]
Esm. Petrolero       0- 3 Barcelona     
Filanbanco           4- 0 River Plate
Audaz Octubrino      2- 0 El Nacional   
Técnico Univ.        2- 0 Dep. Quevedo  
América              0- 1 Dep. Quito    
LDU de Quito         2- 0 LDU de Portoviejo  
Aucas                0- 0 Macara        
Dep. Cuenca          1- 1 Juventus      
Emelec               1- 1 Univ. Católica   

Round 20
[Jun 26]
Univ. Católica       2- 2 Filanbanco    
El Nacional          3- 1 Esm. Petrolero 
Macara               2- 2 Emelec        
River Plate          2- 1 Aucas         
Juventus             1- 0 Técnico Univ.    
LDU de Quito         4- 1 América    
LDU de Portoviejo    0- 0 Dep. Quito    
Dep. Quevedo         2- 2 Dep. Cuenca   
Barcelona            6- 0 Audaz Octubrino  

Round 21
[Jul  2]
América              6- 1 LDU de Portoviejo  
Esm. Petrolero       2- 1 Univ. Católica   
Dep. Quito           1- 0 Barcelona     
El Nacional          0- 0 Aucas         
Filanbanco           2- 1 Dep. Quevedo  
[Jul  3]
Dep. Cuenca          1- 1 Macara        
Técnico Univ.        1- 1 River Plate
Audaz Octubrino      3- 0 LDU de Quito  
Emelec               3- 0 Juventus      

Round 22
[Jul  9]
Juventus             2- 1 Filanbanco    
Aucas                2- 0 Audaz Octubrino  
LDU de Quito         2- 2 Dep. Quito    
Barcelona            3- 0 Técnico Univ.    
[Jul 10]
Univ. Católica       2- 1 América    
Macara               5- 1 Esm. Petrolero 
River Plate          0- 0 Dep. Cuenca   
Dep. Quevedo         0- 1 El Nacional   
LDU de Portoviejo    1- 4 Emelec        

Round 23
[Jul 16]
Esm. Petrolero       1- 0 River Plate
[Jul 17]
El Nacional          2- 0 Juventus      
LDU de Quito         4- 0 Dep. Quevedo  
Técnico Univ.        2- 0 LDU de Portoviejo  
Dep. Cuenca          1- 1 Univ. Católica   
Audaz Octubrino      0- 0 Macara        
Emelec               2- 2 Aucas         
[Aug 31]
Filanbanco           1- 1 Dep. Quito    
América              1- 0 Barcelona     

Round 24
[Jul 23]
Juventus             2- 2 Esm. Petrolero 
Dep. Quito           1- 0 Audaz Octubrino  
Aucas                0- 2 Técnico Univ.    
[Jul 24]
Macara               0- 1 Filanbanco    
River Plate          2- 1 América    
LDU de Portoviejo    2- 0 Dep. Cuenca   
Dep. Quevedo         1- 0 Emelec        
Univ. Católica       1- 2 LDU de Quito  
Barcelona            0- 0 El Nacional   

Round 25
[Jul 30]
América              1- 1 Dep. Quevedo  
Esm. Petrolero       1- 1 Aucas         
Univ. Católica       6- 0 River Plate
El Nacional          3- 4 Macara        
[Jul 31]
Técnico Univ.        2- 2 Dep. Quito    
Dep. Cuenca          1- 3 LDU de Quito  
Audaz Octubrino      3- 1 Juventus      
[Sep  7]
Emelec               0- 0 Barcelona     
[Sep 28]
Filanbanco           1- 4 LDU de Portoviejo  

Round 26
[Aug  6]
Aucas                1- 1 América    
Dep. Quito           1- 1 Dep. Cuenca   
LDU de Quito         2- 1 Filanbanco    
[Aug  7]
Macara               2- 2 Barcelona     
River Plate          1- 1 El Nacional   
Juventus             1- 1 Univ. Católica   
LDU de Portoviejo    0- 1 Esm. Petrolero 
Dep. Quevedo         1- 0 Audaz Octubrino  
Emelec               1- 0 Técnico Univ.    

Round 27
[Aug 13]
Univ. Católica       1- 0 Dep. Quevedo  
Esm. Petrolero       2- 0 Dep. Quito    
El Nacional          5- 1 LDU de Portoviejo  
LDU de Quito         2- 2 River Plate
Filanbanco           0- 0 Aucas         
Dep. Cuenca          1- 0 América    
[Aug 14]
Macara               4- 1 Técnico Univ.    
Audaz Octubrino      0- 1 Emelec        
Barcelona            1- 0 Juventus      

Round 28
[Aug 20]
América              3- 0 Audaz Octubrino  
Juventus             2- 1 LDU de Quito  
El Nacional          0- 1 Univ. Católica   
Aucas                2- 1 Dep. Cuenca   
Técnico Univ.        1- 0 Filanbanco    
[Aug 21]
River Plate          1- 0 Barcelona     
Dep. Quevedo         1- 0 Dep. Quito    
LDU de Portoviejo    0- 0 Macara        
Emelec               3- 1 Esm. Petrolero 

Round 29
[Aug 27]
Esm. Petrolero       2- 2 Técnico Univ.    
Filanbanco           1- 0 América    
Aucas                2- 3 LDU de Quito  
[Aug 28]
Dep. Quito           3- 2 Juventus      
El Nacional          1- 1 Dep. Cuenca   
Macara               3- 0 Dep. Quevedo  
River Plate          1- 1 Emelec        
Audaz Octubrino      0- 0 Univ. Católica   
Barcelona            1- 1 LDU de Portoviejo  

Round 30
[Sep  3]
América              1- 3 Macara        
Juventus             2- 0 Aucas         
Técnico Univ.        3- 0 Audaz Octubrino  
Univ. Católica       0- 0 Dep. Quito    
LDU de Quito         2- 0 Esm. Petrolero 
Emelec               1- 0 El Nacional   
Dep. Cuenca          0- 0 Filanbanco    
[Sep  4]
LDU de Portoviejo    0- 1 River Plate
Dep. Quevedo         0- 0 Barcelona     

Round 31
[Sep 10]
Aucas                2- 0 Dep. Quevedo  
Esm. Petrolero       0- 0 América    
Univ. Católica       1- 1 LDU de Portoviejo  
Filanbanco           2- 0 Emelec        
El Nacional          1- 0 Técnico Univ.    
Barcelona            1- 1 LDU de Quito  
[Sep 11]
Macara               2- 0 Juventus      
River Plate          1- 2 Dep. Quito    
Audaz Octubrino      0- 0 Dep. Cuenca   

Round 32
[Sep 17]
Juventus             1- 1 LDU de Portoviejo  
Filanbanco           2- 1 Audaz Octubrino  
[Sep 18]
América              0- 3 Emelec        
LDU de Quito         1- 1 Técnico Univ.    
Dep. Cuenca          1- 0 Esm. Petrolero 
Macara               0- 0 Univ. Católica   
Dep. Quito           3- 1 El Nacional   
Dep. Quevedo         1- 0 River Plate
Barcelona            3- 0 Aucas         

Round 33
[Sep 24]
Esm. Petrolero       1- 0 Audaz Octubrino  
Técnico Univ.        0- 0 América    
[Sep 25]
Dep. Quito           1- 1 Macara        
El Nacional          2- 2 LDU de Quito  
Univ. Católica       3- 0 Aucas         
River Plate          1- 1 Juventus      
LDU de Portoviejo    1- 0 Dep. Quevedo  
Emelec               5- 1 Dep. Cuenca   
Filanbanco           0- 1 Barcelona     

Round 34
[Oct  1]
Juventus             0- 0 Dep. Quevedo  
Macara               3- 0 River Plate
Barcelona            3- 2 Univ. Católica   
Audaz Octubrino      1- 0 LDU de Portoviejo  
[Oct  2]
Aucas                2- 2 Dep. Quito    
LDU de Quito         3- 1 Emelec        
América              0- 1 El Nacional   
Dep. Cuenca          2- 2 Técnico Univ.    
Filanbanco           1- 2 Esm. Petrolero 

Table

 1.LDU de Quito         34 20  9  5 64-36 49 [Quito]      Qualified
 2.Emelec       	34 16 12  6 56-36 44 [Guayaquil]  Qualified
 3.Macará               34 13 15  6 50-32 41 [Ambato]     Qualified
 4.Barcelona            34 13 14  7 50-25 40 [Guayaquil]  Qualified
 5.Dep. Quito  		34 13 13  8 48-43 39 [Quito]      Qualified
 6.Univ. Católica   	34 13 10 11 45-37 36 [Quito]      Qualified
 7.Filanbanco     	34 14  8 12 38-33 36 [Milagro]    Qualified
 8.El Nacional          34 12 11 11 49-41 35 [Quito]      Qualified
 - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - 
 9.Técnico Univ.        34 11 12 11 42-39 34 [Ambato]
10.Aucas        	34 11 12 11 45-49 34 [Quito]
11.Dep. Cuenca   	34  7 19  8 41-45 33 [Cuenca]
12.Esm. Petrolero       34 11 10 13 40-50 32 [Esmeraldas]
13.Audaz Octubrino      34 12  7 15 32-43 31 [Machala]
14.Dep. Quevedo         34 10  8 16 27-44 28 [Quevedo]
15.Juventus             34  7 13 14 31-44 27 [Esmeraldas]
16.LDU de Portoviejo    34  9  9 16 34-50 27 [Portoviejo]
17.River Plate          34  9  7 18 27-53 25 [Riobamba]
 - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - 
18.América              34  5 11 18 29-48 21 [Quito]     Relegated

Top-8 qualify for Second Stage.

NB: LDU de Quito(1 bonus point), Emelec (1) for second stage.


Second stage

Tables

Group 1

 1.Dep. Quito 		 6  2  4  0  8- 4  8     Qualified
 2.LDU de Quito 	 6  3  1  2 10-11  8 [1]
 3.Macará                6  2  2  2 11- 8  6
 4.Filanbanco            6  1  1  4  5-11  3

Group 2

 1.Emelec         	 6  2  4  0  7- 4  9 [1] Qualified
 2.Barcelona             6  2  3  1  8- 5  7
 3.El Nacional           6  2  2  2  9-10  6
 4.Univ. Católica        6  1  1  4  8-13  3

Winners of each group qualify for Final.
[bonus points between square brackets]

Round 1
[Oct  8]
Emelec               2- 2 El Nacional   
[Oct  9]
Dep. Quito           0- 0 Filanbanco    
Macara               5- 1 LDU de Quito  
Univ. Católica       1- 1 Barcelona     

Round 2
[Oct 16]
LDU de Quito         1- 3 Dep. Quito    
Univ. Católica       3- 4 El Nacional   
Filanbanco           2- 0 Macara        
Barcelona            0- 0 Emelec        

Round 3
[Oct 23]
LDU de Quito         3- 1 Filanbanco    
Univ. Católica       1- 2 Emelec        
Macara               1- 1 Dep. Quito    
Barcelona            3- 0 El Nacional   

Round 4
[Oct 29]
Filanbanco           0- 2 Dep. Quito    
Barcelona            3- 1 Univ. Católica   
[Oct 30]
LDU de Quito         2- 0 Macara        
El Nacional          0- 0 Emelec        

Round 5
[Nov  6]
Dep. Quito           0- 0 LDU de Quito  
El Nacional          1- 2 Univ. Católica   
Macara               3- 0 Filanbanco    
Emelec               1- 1 Barcelona     

Round 6
[Nov 13]
Filanbanco           2- 3 LDU de Quito  
Dep. Quito           2- 2 Macara        
Emelec               2- 0 Univ. Católica   
El Nacional          2- 0 Barcelona     

Tables

Group 1

 1.Dep. Quito 		 6  2  4  0  8- 4  8     Qualified
 2.LDU de Quito 	 6  3  1  2 10-11  8 [1]
 3.Macará                6  2  2  2 11- 8  6
 4.Filanbanco            6  1  1  4  5-11  3

Group 2

 1.Emelec         	 6  2  4  0  7- 4  9 [1] Qualified
 2.Barcelona             6  2  3  1  8- 5  7
 3.El Nacional           6  2  2  2  9-10  6
 4.Univ. Católica        6  1  1  4  8-13  3

Winners of each group qualify for Final.
[bonus points between square brackets]


Final

[Nov 19]
Emelec               3- 0 Dep. Quito    
Rubén Beninca (39), Wilfrido E. Verduga (70), Jesús Cardenas (89)

[Nov 27]
Dep. Quito           1- 1 Emelec        
Wellington Valdez (og)(80) - José Federico Mina (46)

Topscorers

19 Janio Pinto (LDU de Quito)
17 Marcos Rodriguez "Magu" (Univ. Católica)
17 Ruben Beninca (Emelec)
16 Ney Raúl Avilés (Emelec)
16 Aldomario Bittencourt (Univ. Católica)
16 Jesús Cardenas (Emelec)
15 Pedro M. Muñóz (LDU de Quito)
14 Cristobal Nazareno (Esm. Petrolero)
14 Jorge Rodríguez (Dep. Cuenca)
13 Hermen Benítez (El Nacional)
13 Carlos Berrueta (Aucas)
12 Juan M. Caballero (Macará)
12 Byron Tenorio (El Nacional)
12 Miguel A. Tzitzios (LDU de Portoviejo)
11 Jimmy Izquierdo (Barcelona)
11 Alcides de Oliveira (Técnico Univ.)
11 Gorky Revelo (Técnico Univ.)
11 Ned Barbosa (Esm. Perolero)
11 Hugo Benito Vilchez (América)
11 Hamilton Cuvi Rivera (Filanbanco)
10 Romulo Sanchez (Macara)
10 Mauricio Arguello (Barcelona)
10 Cali Delgado (LDU de Portoviejo)





Author:
Fernando Espinoza Añazco (nanoespinoza@hotmail.com) Last updated: 17 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,398,512 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0018
Controller Execution Time ( Home / Category )  0.1045
Total Execution Time  0.1064
  CADENA URL  
/ecuador1988/grupo2
  GET DATOS  
$_GET['/ecuador1988/grupo2']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (37)  
0.0018  SELECT type FROM routes WHERE alias = 'ecuador1988'
0.0040  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 = 2 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 1988 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=2 DESC LIMIT 1
0.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=43 AND type_rel = 3
0.0039  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.0023  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.0021  SELECT text_es as historical_text FROM leagues_text WHERE id=418
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 = 28741 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0023  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-28 11:29:20' 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-28 11:29:20' 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-28 11:29:20' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0020  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=3 AND last_update > '2024-03-28 11:29:20' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0024  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 = 1988 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=0 DESC LIMIT 1
0.0019  SELECT e.action, count(e.action) as total, e.player_id FROM events1988 e WHERE e.league_id IN (28741) 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 (28741) 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 events1988 e WHERE e.league_id IN (28741) 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 (28741) 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 events1988 e WHERE e.league_id IN (28741) 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 (28741) 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 events1988 e WHERE e.league_id IN (28741) 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 (28741) 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 = 28741 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 = 28741 AND rp.events > 0 ORDER BY rp.events DESC,p.pod DESC LIMIT 20
0.0021  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=28741 AND rel.round=34
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 = 28741 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 = 28741 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-27" AND c.`active`= 1 and c.comment_id is null and c.lang = 1 AND l.`id` = 28741 ORDER BY creation_date DESC LIMIT 0, 10
0.0023  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-27" AND c.`active`= 1 and comment_id is null and c.lang = 1 AND l.`id` = 28741
0.0019  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 `calendars1988` 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` = 28741 AND c.`round` = 34 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 `events1988` e INNER JOIN calendars1988 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 = 34 AND e.real_date IS NOT NULL AND e.league_id = 28741 ORDER BY total DESC LIMIT 40
0.0020  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 `events1988` e INNER JOIN calendars1988 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 = 28741 AND e.real_date > NOW() - INTERVAL 1 MONTH ORDER BY e.real_date DESC LIMIT 30
0.0022  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 `tables1988` 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 = 28741 AND t.round = 32 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0022  SELECT *,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables1988` 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 = 28741 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0022  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-28 00:00:00' AND c.`shedule` < '2024-04-01 23:59:59' AND l.id = 28741 ORDER BY c.shedule ASC, fcoef DESC LIMIT 5
0.0022  SELECT data1, data2 FROM services_tags WHERE categoryId=43
0.0022  SELECT l.year,l.group_code FROM leagues_besoccer l WHERE l.categoryId = 43 AND l.year = 1988 ORDER BY l.group_code ASC
0.0022  SELECT group_code, extraName from `leagues` WHERE categoryId=43 AND year=1988