Información Histórica
						
Serie A

First Stage

Table

 1.El Nacional          18 13  2  3 36-21 28 [Quito]      Qualified
 2.Emelec         	18  9  5  4 29-24 23 [Guayaquil]  Qualified
 3.Dep. Cuenca          18  8  5  5 34-21 21 [Cuenca]     Qualified
 - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - 
 4.Audaz Octubrino      18  8  5  5 30-27 21 [Machala]
 5.LDU de Quito         18  6  6  6 26-22 18 [Quito]
 6.Barcelona            18  5  6  7 26-20 16 [Guayaquil]
 7.Univ. Católica	18  6  4  8 26-22 16 [Quito]
 8.Aucas                18  6  4  8 18-28 16 [Quito]
 - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - 
 9.América-Q.           18  4  4 10 23-36 12 [Quito]      Relegated
10.9 de Octubre         18  3  3 12 11-38  9 [Guayaquil]  Relegated

Top-3 qualify for Liguilla Final.

NB: El Nacional (3 bonus points), Emelec (2), Dep. Cuenca (1).

Round  1
Emelec               2- 0 Aucas         
Univ. Católica       0- 0 LDU de Quito  
El Nacional          2- 1 9 de Octubre  
Barcelona            3- 1 Dep. Cuenca   
Audaz Octubrino      2- 1 América-Q.    

Round  2
Dep. Cuenca          1- 1 El Nacional   
9 de Octubre         1- 1 Barcelona     
LDU de Quito         0- 1 Aucas         
Univ. Católica       1- 1 Audaz Octubrino  
América-Q.           2- 3 Emelec        

Round  3
América-Q.           1- 1 El Nacional   
Emelec               3- 1 Univ. Católica   
9 de Octubre         1- 1 LDU de Quito  
Aucas                2- 1 Dep. Cuenca   
Audaz Octubrino      1- 0 Barcelona     

Round  4
Univ. Católica       3- 0 El Nacional   
LDU de Quito         2- 1 Barcelona     
Dep. Cuenca          6- 0 América-Q.    
Aucas                0- 0 9 de Octubre  
Emelec               1- 1 Audaz Octubrino  

Round  5
Barcelona            1- 1 Aucas         
Emelec               4- 1 9 de Octubre  
LDU de Quito         2- 2 Dep. Cuenca   
Audaz Octubrino      3- 2 El Nacional   
América-Q.           0- 3 Univ. Católica   

Round  6
El Nacional          2- 1 Emelec        
LDU de Quito         1- 0 América-Q.    
Dep. Cuenca          3- 0 9 de Octubre  
Barcelona            4- 0 Univ. Católica   
Aucas                3- 1 Audaz Octubrino  

Round  7
9 de Octubre         0- 2 América-Q.    
Barcelona            1- 1 Emelec        
Audaz Octubrino      1- 1 LDU de Quito  
Aucas                1- 2 El Nacional   
Univ. Católica       1- 0 Dep. Cuenca   

Round  8
Aucas                2- 6 Univ. Católica   
América-Q.           0- 0 Barcelona     
9 de Octubre         1- 0 Audaz Octubrino  
El Nacional          1- 0 LDU de Quito  
Dep. Cuenca          1- 1 Emelec        

Round  9
Univ. Católica       4- 0 9 de Octubre  
América-Q.           1- 1 Aucas         
Audaz Octubrino      3- 0 Dep. Cuenca   
Emelec               2- 1 LDU de Quito  
Barcelona            1- 2 El Nacional   

Round 10
Aucas                0- 0 Emelec        
9 de Octubre         1- 4 El Nacional   
Dep. Cuenca          2- 2 Barcelona     
LDU de Quito         1- 1 Univ. Católica   
América-Q.           3- 1 Audaz Octubrino  

Round 11
Aucas                1- 0 LDU de Quito  
Audaz Octubrino      2- 1 Univ. Católica   
Emelec               3- 2 América-Q.    
Barcelona            4- 0 9 de Octubre  
El Nacional          1- 0 Dep. Cuenca   

Round 12
Univ. Católica       1- 2 Emelec        
El Nacional          2- 1 América-Q.    
Dep. Cuenca          5- 1 Aucas         
Barcelona            0- 2 Audaz Octubrino  
LDU de Quito         3- 1 9 de Octubre  

Round 13
Barcelona            2- 1 LDU de Quito  
Audaz Octubrino      1- 1 Emelec        
América-Q.           1- 3 Dep. Cuenca   
9 de Octubre         2- 0 Aucas         
El Nacional          1- 0 Univ. Católica   

Round 14
Dep. Cuenca          2- 0 LDU de Quito  
Univ. Católica       3- 2 América-Q.    
9 de Octubre         1- 2 Emelec        
El Nacional          6- 2 Audaz Octubrino  
Aucas                2- 1 Barcelona     

Round 15
Audaz Octubrino      2- 0 Aucas         
Emelec               1- 3 El Nacional   
Univ. Católica       0- 0 Barcelona     
9 de Octubre         0- 2 Dep. Cuenca   
América-Q.           3- 3 LDU de Quito  

Round 16
LDU de Quito         4- 2 Audaz Octubrino  
Emelec               1- 0 Barcelona     
América-Q.           3- 0 9 de Octubre  
El Nacional          2- 1 Aucas         
Dep. Cuenca          1- 0 Univ. Católica   

Round 17
LDU de Quito         2- 1 El Nacional   
Univ. Católica       1- 2 Aucas         
Audaz Octubrino      3- 0 9 de Octubre  
Barcelona            4- 0 América-Q.    
Emelec               1- 2 Dep. Cuenca   

Round 18
LDU de Quito         4- 0 Emelec        
Aucas                0- 1 América-Q.    
9 de Octubre         1- 0 Univ. Católica   
Dep. Cuenca          2- 2 Audaz Octubrino  
El Nacional          3- 1 Barcelona     

Table

 1.El Nacional          18 13  2  3 36-21 28 [Quito]      Qualified
 2.Emelec         	18  9  5  4 29-24 23 [Guayaquil]  Qualified
 3.Dep. Cuenca          18  8  5  5 34-21 21 [Cuenca]     Qualified
 - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - 
 4.Audaz Octubrino      18  8  5  5 30-27 21 [Machala]
 5.LDU de Quito         18  6  6  6 26-22 18 [Quito]
 6.Barcelona            18  5  6  7 26-20 16 [Guayaquil]
 7.Univ. Católica	18  6  4  8 26-22 16 [Quito]
 8.Aucas                18  6  4  8 18-28 16 [Quito]
 - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - 
 9.América-Q.           18  4  4 10 23-36 12 [Quito]      Relegated
10.9 de Octubre         18  3  3 12 11-38  9 [Guayaquil]  Relegated

Top-3 qualify for Liguilla Final.

NB: El Nacional (3 bonus points), Emelec (2), Dep. Cuenca (1).


Second Stage

Nb: Carmen Mora and Dep. Quito promoted as winners of First Stage of Serie B

Table

 1.El Nacional          18 10  3  5 35-19 23              Qualified
 2.LDU de Quito 	18  8  5  5 27-21 21              Qualified
 3.Dep. Cuenca          18  8  4  6 28-20 20              Qualified
 - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - 
 4.Emelec               18  6  7  5 23-19 19
 5.Aucas                18  7  5  6 22-27 19
 6.Barcelona      	18  6  6  6 24-21 18
 7.Carmen Mora   	18  5  7  6 22-27 17 [Machala]
 8.Univ. Católica       18  5  6  7 20-22 16
 - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - 
 9.Dep. Quito           18  5  6  7 18-26 16 [Quito]      Relegated
10.Audaz Octubrino      18  3  5 10 17-34 11              Relegated

Top-3 qualify for Liguilla Final.

NB: El Nacional (3 bonus points), LDU de Quito (2), Dep. Cuenca (1).

Round 1
Barcelona            5- 0 Dep. Quito    
Carmen Mora          4- 3 LDU de Quito  
El Nacional          5- 2 Audaz Octubrino  
Dep. Cuenca          0- 1 Univ. Católica   
Aucas                1- 0 Emelec        

Round 2
Univ. Católica       3- 1 Barcelona     
Emelec               3- 1 Dep. Cuenca   
Audaz Octubrino      0- 1 Aucas         
LDU de Quito         2- 2 El Nacional   
Dep. Quito           1- 0 Carmen Mora   

Round 3
LDU de Quito         3- 1 Univ. Católica   
Aucas                3- 1 Dep. Quito    
Barcelona            2- 1 El Nacional   
Dep. Cuenca          4- 1 Audaz Octubrino  
Carmen Mora          1- 1 Emelec        

Round 4
Aucas                0- 3 Barcelona     
Univ. Católica       1- 1 Carmen Mora   
El Nacional          0- 1 Dep. Cuenca   
Emelec               1- 1 LDU de Quito  
Audaz Octubrino      1- 0 Dep. Quito    

Round 5
Carmen Mora          2- 2 Audaz Octubrino  
Dep. Cuenca          4- 1 Aucas         
Emelec               2- 0 Barcelona     
El Nacional          0- 1 Univ. Católica   
LDU de Quito         1- 1 Dep. Quito    

Round 6
Barcelona            0- 1 LDU de Quito  
Univ. Católica       3- 0 Audaz Octubrino  
Aucas                1- 2 El Nacional   
Dep. Quito           0- 0 Emelec        
Carmen Mora          0- 0 Dep. Cuenca   

Round 7
LDU de Quito         1- 2 Aucas         
Emelec               2- 1 Univ. Católica   
El Nacional          1- 0 Carmen Mora   
Audaz Octubrino      1- 1 Barcelona     
Dep. Cuenca          1- 2 Dep. Quito    

Round 8
Univ. Católica       2- 2 Dep. Quito    
El Nacional          2- 0 Emelec        
LDU de Quito         0- 0 Audaz Octubrino  
Barcelona            3- 2 Dep. Cuenca   
Carmen Mora          3- 2 Aucas         

Round 9
Dep. Cuenca          2- 1 LDU de Quito  
Barcelona            0- 0 Carmen Mora   
El Nacional          2- 1 Dep. Quito    
Univ. Católica       0- 1 Aucas         
Audaz Octubrino      1- 1 Emelec        

Round 10
LDU de Quito         2- 1 Carmen Mora   
Emelec               3- 0 Aucas         
Dep. Quito           1- 1 Barcelona     
Univ. Católica       2- 0 Dep. Cuenca   
Audaz Octubrino      1- 3 El Nacional   

Round 11
Carmen Mora          4- 1 Dep. Quito    
Dep. Cuenca          4- 1 Emelec        
Aucas                2- 0 Audaz Octubrino  
Barcelona            1- 1 Univ. Católica   
El Nacional          3- 1 LDU de Quito  

Round 12
Emelec               4- 1 Carmen Mora   
Dep. Quito           1- 1 Aucas         
El Nacional          5- 2 Barcelona     
Univ. Católica       0- 2 LDU de Quito  
Audaz Octubrino      1- 1 Dep. Cuenca   

Round 13
Dep. Quito           3- 0 Audaz Octubrino  
LDU de Quito         2- 1 Emelec        
Dep. Cuenca          2- 1 El Nacional   
Carmen Mora          2- 1 Univ. Católica   
Barcelona            1- 1 Aucas         

Round 14
Barcelona            0- 0 Emelec        
Dep. Quito           0- 1 LDU de Quito  
Univ. Católica       0- 3 El Nacional   
Aucas                1- 1 Dep. Cuenca   
Audaz Octubrino      1- 2 Carmen Mora   

Round 15
Audaz Octubrino      3- 2 Univ. Católica   
Dep. Cuenca          3- 0 Carmen Mora   
LDU de Quito         2- 0 Barcelona     
El Nacional          3- 0 Aucas         
Emelec               2- 0 Dep. Quito    

Round 16
Dep. Quito           2- 1 Dep. Cuenca   
Carmen Mora          0- 0 El Nacional   
Univ. Católica       0- 0 Emelec        
Aucas                3- 2 LDU de Quito  
Barcelona            1- 0 Audaz Octubrino  

Round 17
Dep. Quito           0- 0 Univ. Católica   
Emelec               1- 1 El Nacional   
Dep. Cuenca          1- 0 Barcelona     
Aucas                1- 1 Carmen Mora   
Audaz Octubrino      0- 2 LDU de Quito  

Round 18
Carmen Mora          0- 3 Barcelona     
LDU de Quito         0- 0 Dep. Cuenca   
Dep. Quito           2- 1 El Nacional   
Emelec               1- 3 Audaz Octubrino  
Aucas                1- 1 Univ. Católica   

Table

 1.El Nacional          18 10  3  5 35-19 23              Qualified
 2.LDU de Quito 	18  8  5  5 27-21 21              Qualified
 3.Dep. Cuenca          18  8  4  6 28-20 20              Qualified
 - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - 
 4.Emelec               18  6  7  5 23-19 19
 5.Aucas                18  7  5  6 22-27 19
 6.Barcelona      	18  6  6  6 24-21 18
 7.Carmen Mora   	18  5  7  6 22-27 17 [Machala]
 8.Univ. Católica       18  5  6  7 20-22 16
 - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - 
 9.Dep. Quito           18  5  6  7 18-26 16 [Quito]      Relegated
10.Audaz Octubrino      18  3  5 10 17-34 11              Relegated

Top-3 qualify for Liguilla Final.

NB: El Nacional (3 bonus points), LDU de Quito (2), Dep. Cuenca (1).


Liguilla Final

Table

 1.El Nacional           6  3  2  1  8- 6 14 [6] Champions
 2.Dep. Cuenca  	 6  3  1  2  5- 4  9 [2]
 3.Emelec                6  3  1  2  6- 8  9 [2]
 4.LDU de Quito          6  1  0  5  6- 7  4 [2]

[Bonus points between square brackets]

Round 1
LDU de Quito         4- 0 Emelec        
Dep. Cuenca          0- 0 El Nacional   

Round 2
LDU de Quito         0- 1 El Nacional   
Emelec               1- 0 Dep. Cuenca   

Round 3
El Nacional          1- 1 Emelec        
Dep. Cuenca          2- 1 LDU de Quito  

Round 4
Emelec               1- 0 LDU de Quito  
El Nacional          2- 1 Dep. Cuenca   

Round 5
Dep. Cuenca          1- 0 Emelec        
El Nacional          2- 1 LDU de Quito  

Round 6
Emelec               3- 2 El Nacional
LDU de Quito         0- 1 Dep. Cuenca

Table

 1.El Nacional           6  3  2  1  8- 6 14 [6] Champions
 2.Dep. Cuenca  	 6  3  1  2  5- 4  9 [2]
 3.Emelec                6  3  1  2  6- 8  9 [2]
 4.LDU de Quito          6  1  0  5  6- 7  4 [2]

[Bonus points between square brackets]


Definition of runners-up

Dep. Cuenca          2- 0 Emelec
     [Angel Liciardi 46',89']

Emelec               0- 0 Dep. Cuenca   

Dep. Cuenca qualify to Copa Libertadores 1977.



Author:
Fernando Espinoza Añazco (nanoespinoza@hotmail.com) Last updated: 24 Jan 2001 (C) Copyright Fernando Espinoza Añazco and RSSSF 2001

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,352,552 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0019
Controller Execution Time ( Home / Category )  0.3578
Total Execution Time  0.3597
  CADENA URL  
/ecuador1976/grupo2
  GET DATOS  
$_GET['/ecuador1976/grupo2']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (25)  
0.0105  SELECT type FROM routes WHERE alias = 'ecuador1976'
0.0212  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 = 1976 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=2 DESC LIMIT 1
0.0105  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=43 AND type_rel = 3
0.0121  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.0108  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.0106  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 = 28726 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0107  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.0105  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-03-28 14:36:06' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0105  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=2 AND last_update > '2024-03-28 14:36:06' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0105  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=4 AND last_update > '2024-03-28 14:36:06' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0105  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=3 AND last_update > '2024-03-28 14:36:07' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0110  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 = 1976 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=0 DESC LIMIT 1
0.0106  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=28726 AND rel.round=18
0.0106  SELECT u.id,u.user_name, esl.points,up.name,up.surname,up.nick,u.changeA FROM editor_stats_leagues esl INNER JOIN fa_user u ON u.id = esl.user_id INNER JOIN fa_user_profile up ON up.id = esl.user_id WHERE esl.league_id = 28726 AND esl.points > 0 ORDER BY esl.points DESC LIMIT 3
0.0106  SELECT count(esl.user_id) as cuenta FROM editor_stats_leagues esl INNER JOIN fa_user u ON u.id = esl.user_id INNER JOIN fa_user_profile up ON up.id = esl.user_id WHERE esl.league_id = 28726 AND esl.points > 0
0.0107  SELECT fau.user_name, c.*, NOW() as difference_time,creation_date FROM (leagues as l) INNER JOIN comments as c ON c.league_id = l.id LEFT JOIN fa_user fau ON fau.id = c.author_id WHERE c.creation_date > "2024-02-27" AND c.`active`= 1 and c.comment_id is null and c.lang = 1 AND l.`id` = 28726 ORDER BY creation_date DESC LIMIT 0, 10
0.0108  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` = 28726
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 `calendars1976` 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` = 28726 AND c.`round` = 18 ORDER BY shedule ASC LIMIT 200
0.0107  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 `events1976` e INNER JOIN calendars1976 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 = 18 AND e.real_date IS NOT NULL AND e.league_id = 28726 ORDER BY total DESC LIMIT 40
0.0106  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 `events1976` e INNER JOIN calendars1976 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 = 28726 AND e.real_date > NOW() - INTERVAL 1 MONTH ORDER BY e.real_date DESC LIMIT 30
0.0110  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 `tables1976` 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 = 28726 AND t.round = 16 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0106  SELECT *,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables1976` 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 = 28726 AND t.round = 18 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0105  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 = 28726 ORDER BY c.shedule ASC, fcoef DESC LIMIT 5
0.0107  SELECT data1, data2 FROM services_tags WHERE categoryId=43
0.0107  SELECT group_code, extraName from `leagues` WHERE categoryId=43 AND year=1976