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

Serie A

First Stage (Torneo Apertura)

Table:

 1.Olmedo                 18  8  6  4 18-14 30  Qualified
 2.Aucas                  18  8  5  5 20-17 29  Qualified
 3.El Nacional            18  7  6  5 34-26 27  Qualified
 - - - - - - - - - - - - - - - - - - - - - - -
 4.LDU Quito              18  7  6  5 30-23 27
 5.Macará                 18  6  7  5 25-25 25
 6.Emelec                 18  7  3  8 23-22 24
 7.Espoli                 18  6  6  6 19-20 24
 8.Deportivo (Quito)      18  4  8  6 24-24 20
 9.Barcelona              18  4  7  7 19-27 19
10.Técnico Universitario  18  3  6  9 21-35 15

Top-3 qualify for Hexagonal Final

Round 1 
[Feb 12]
Emelec        2-1 Macara        [in Portoviejo]
LDU Quito     4-1 El Nacional
[Feb 13]
Aucas         1-0 Barcelona
Tecnico Univ. 2-2 Dep. Quito      
Olmedo        2-0 Espoli
  
Round 2
[Feb 18]
Barcelona     0-0 LDU
[Feb 19]
Espoli        3-1 Técnico Univ.
[Feb 20]
Macará        1-2 Aucas
Dep. Quito    1-1 Emelec
El Nacional   1-0 Olmedo

Round 3
[Feb 26] 
Emelec        3-0 Aucas  
[Feb 27] 
LDU           2-2 Macará 
Dep. Quito    1-2 Espoli 
Técnico Univ. 2-2 El Nacional
Olmedo        1-0 Barcelona
  
Round 4 
[Mar 4]
Macará        1-1 Olmedo
[Mar 5]
Espoli        1-0 Emelec
El Nacional   0-0 Dep. Quito
Barcelona     3-1 Técnico Univ.
[Mar 7]
Aucas         0-1 LDU Quito

Round 5 [Mar 12] 
Dep. Quito    1-1 Barcelona
Espoli        2-2 El Nacional
Emelec        2-0 LDU
Técnico Univ. 0-0 Macará
Olmedo        0-1 Aucas

Round 6
[Mar 18]
El Nacional   2-0 Emelec
Macará        2-1 Deportivo
[Mar 19]
LDU           1-1 Olmedo
Aucas         1-0 Técnico Universitario
Barcelona     0-1 Espoli

Round 7
[Mar 31]
Deportivo     1-1 Aucas
Emelec        3-1 Olmedo
[Apr 1]
Técnico Univ. 4-4 LDU
[Apr 2]
Espoli        2-1 Macará
El Nacional   7-0 Barcelona

Round 8
[Apr 8]
LDU           2-1 Deportivo
Aucas         0-0 Espoli
[Apr 9]
Barcelona     0-0 Emelec
Macará        0-0 El Nacional
Olmedo        1-0 Técnico Universitario

Round 9
[Apr 15]
Deportivo     0-0 Olmedo
Espoli        0-0 LDU
[Apr 16]
El Nacional   2-3 Aucas
Emelec        1-0 Técnico Universitario
Macará        3-2 Barcelona

Round 10 
[Apr 28] 
Barcelona     2-2 Macará 
[Apr 29] 
Aucas         0-0 El Nacional 
[Apr 30] 
Olmedo        2-0 Deportivo 
LDU           3-3 Espoli 
Técnico Univ. 2-0 Emelec 

Round 11 
[May 6] 
El Nacional   3-2 Macará   
[May 7] 
Deportivo     2-1 LDU   
Espoli        0-1 Aucas 
Emelec        1-2 Barcelona 
Técnico Univ. 2-2 Olmedo 

Round 12 
[May 12] 
LDU           3-1 Técnico Universitario 
[May 13] 
Macará        1-0 Espoli  
Barcelona     1-1 El Nacional 
Olmedo        1-0 Emelec 
[May 14] 
Aucas         3-1 Deportivo  

Round 13 [May 20]
Olmedo        1-0 LDU   
Técnico Univ. 1-0 Aucas 
Emelec        4-0 El Nacional  
Espoli        0-0 Barcelona    
Deportivo     5-0 Macará 

Round 14 
[May 26] 
LDU           4-1 Emelec   
[May 27] 
El Nacional   4-2 Espoli 
Aucas         1-1 Olmedo 
[May 28] 
Barcelona     2-2 Deportivo 
Macará        4-2 Técnico Universitario 

Round 15
[Jun 9]
Emelec        1-1 Espoli 
[Jun 10]
Deportivo     2-0 El Nacional
[Jun 11]
LDU           2-0 Aucas 
Técnico Univ. 1-0 Barcelona
Olmedo        0-0 Macará 

Round 16 [Jun 14]
Macará        2-0 LDU                   
Espoli        0-2 Deportivo   
Aucas         3-0 Emelec   
El Nacional   6-1 Técnico Universitario
Barcelona     3-1 Olmedo  

Round 17
[Jun 17]
Emelec        4-1 Deportivo  
[Jun 18]
LDU           2-0 Barcelona
Técnico Univ. 0-2 Espoli   
Aucas         1-1 Macará 
Olmedo        2-1 El Nacional 

Round 18 [Jun 21] 
Macará        2-0 Emelec 
El Nacional   2-1 LDU 
Barcelona     3-2 Aucas 
Espoli        0-1 Olmedo 
Deportivo     1-1 Técnico Universitario 

Table:

 1.Olmedo                 18  8  6  4 18-14 30  Qualified
 2.Aucas                  18  8  5  5 20-17 29  Qualified
 3.El Nacional            18  7  6  5 34-26 27  Qualified
 - - - - - - - - - - - - - - - - - - - - - - -
 4.LDU Quito              18  7  6  5 30-23 27
 5.Macará                 18  6  7  5 25-25 25
 6.Emelec                 18  7  3  8 23-22 24
 7.Espoli                 18  6  6  6 19-20 24
 8.Deportivo (Quito)      18  4  8  6 24-24 20
 9.Barcelona              18  4  7  7 19-27 19
10.Técnico Universitario  18  3  6  9 21-35 15

Top-3 qualify for Hexagonal Final


Second Stage (Torneo Clausura)

Table:

 1.Emelec                 18 10  2  6 36-25 32  Qualified
 2.El Nacional            18 10  3  5 34-24 30  Qualified  [*]
 3.Barcelona              18  8  5  5 25-17 29  Qualified
 - - - - - - - - - - - - - - - - - - - - - - -
 4.Espoli                 18  8  4  6 24-16 28
 5.Deportivo (Quito)      18  8  4  6 28-25 28
 6.Macará                 18  8  2  8 25-25 26
 7.Aucas                  18  6  5  7 22-26 23
 8.Olmedo                 18  6  4  8 15-21 22
 9.LDU Quito              18  5  5  8 20-24 20 
10.Técnico Universitario  18  3  2 13 21-47 11

[*] 3 points deducted due to ineligible player round 16 clausura

Top-3 qualify for Hexagonal Final

Round 1
[Jul 1]
El Nacional   3-1 Emelec
[Jul 2]
Olmedo        2-0 LDU
Aucas         1-0 Deportivo
Tecnico Univ. 0-3 Espoli 
Barcelona     2-1 Macara 

Round 2 [Jul 5] 
Emelec        4-0 Aucas 
Espoli        2-0 Barcelona 
Macará        3-2 El Nacional 
LDU           2-1 Técnico Universitario   
Deportivo     2-0 Olmedo   

Round 3 [Jul 9] 
Aucas         1-1 Macará 
Técnico Univ. 4-3 Deportivo 
Olmedo        1-0 Emelec 
Barcelona     2-1 El Nacional 
Espoli        0-0 LDU   
  
Round 4 
[Jul 11] 
Emelec        2-0 Técnico Universitario 
[Jul 12] 
El Nacional   3-1 Aucas   
LDU           2-1 Barcelona 
Macará        1-2 Olmedo  
Deportivo     1-0 Espoli   
  
Round 5 
[Jul 29] 
Olmedo        2-1 El Nacional 
[Jul 30] 
Barcelona     1-0 Aucas 
Espoli        2-1 Emelec 
Técnico Univ. 1-3 Macará 
LDU           0-1 Deportivo   

Round 6 
[Aug 5] 
Deportivo     2-2 Barcelona   
[Aug 6] 
Aucas         3-1 Olmedo   
Emelec        2-0 LDU 
El Nacional   1-0 Técnico Universitario  
Macará        1-0 Espoli  

Round 7 [Aug 20] 
Espoli        0-2 El Nacional    
Barcelona     1-0 Olmedo 
LDU           2-0 Macará 
Técnico Univ. 2-2 Aucas   
Deportivo     2-1 Emelec    

Round 8 [Aug 27] 
Aucas         0-0 Espoli   
Emelec        1-0 Barcelona 
El Nacional   2-2 LDU 
Macará        2-0 Deportivo 
Olmedo        1-0 Técnico Universitario  

Round 9 [Sep 10]     
Barcelona     7-0 Técnico Universitario 
Espoli        0-0 Olmedo 
Macará        2-2 Emelec   
LDU           0-2 Aucas    
Deportivo     2-2 El Nacional    

Round 10 
[Sep 16] 
El Nacional   2-1 Deportivo 
[Sep 17] 
Emelec        4-2 Macará 
Técnico Univ. 1-1 Barcelona 
Olmedo        0-3 Espoli 
Aucas         1-1 LDU   

Round 11 [Sep 24] 
Barcelona     1-1 Emelec 
Espoli        4-1 Aucas   
LDU           2-4 El Nacional 
Técnico Univ. 2-1 Olmedo  
Deportivo     0-1 Macará   

Round 12 
[Sep 29] 
El Nacional   2-3 Espoli 
[Sep 30] 
Macará        0-1 LDU 
[Oct 1] 
Emelec        4-3 Deportivo 
Olmedo        0-0 Barcelona 
Aucas         5-1 Técnico Universitario 

Round 13 
[Oct 13] 
Técnico Univ. 1-2 El Nacional 
[Oct 15]   
LDU           3-0 Emelec   
Barcelona     2-2 Deportivo 
Espoli        2-1 Macará 
Olmedo        2-0 Aucas 

Round 14 [Oct 22] 
Aucas         1-0 Barcelona    
Emelec        2-1 Espoli 
El Nacional   1-0 Olmedo 
Macará        4-3 Técnico Universitario   
Deportivo     2-1 LDU    

Round 15 [Oct 25] 
Espoli        0-1 Deportivo 
Técnico Univ. 1-4 Emelec 
Olmedo        0-1 Macará 
Barcelona     1-0 LDU 
Aucas         0-0 El Nacional   

Round 16 [Oct 29]
Emelec        3-0 Olmedo
El Nacional   3-1 Barcelona           [El Nacional 3 points deducted for ineligible player]
LDU           1-1 Espoli       
Macará        2-1 Aucas
Deportivo     3-2 Técnico Univ. 

Round 17 [Nov 1]
Barcelona     2-0 Espoli
El Nacional   1-0 Macará
Aucas         2-1 Emelec
Olmedo        0-0 Deportivo
Técnico Univ. 1-0 LDU

Round 18 [Nov 5]
Emelec        3-2 El Nacional
Espoli        3-1 Técnico Univ.
LDU           3-3 Olmedo
Macará        0-1 Barcelona
Deportivo     3-1 Aucas

Table:

 1.Emelec                 18 10  2  6 36-25 32  Qualified
 2.El Nacional            18 10  3  5 34-24 30  Qualified  [*]
 3.Barcelona              18  8  5  5 25-17 29  Qualified
 - - - - - - - - - - - - - - - - - - - - - - -
 4.Espoli                 18  8  4  6 24-16 28
 5.Deportivo (Quito)      18  8  4  6 28-25 28
 6.Macará                 18  8  2  8 25-25 26
 7.Aucas                  18  6  5  7 22-26 23
 8.Olmedo                 18  6  4  8 15-21 22
 9.LDU Quito              18  5  5  8 20-24 20 
10.Técnico Universitario  18  3  2 13 21-47 11

[*] 3 points deducted due to ineligible player round 16 clausura

Top-3 qualify for Hexagonal Final


Aggregate Table (Apertura+Clausura):

 1.El Nacional            36 17  9 10 68-50 57  [*]  A1  C2
 2.Emelec                 36 17  5 14 59-47 56  C3
 3.Espoli                 36 14 10 12 43-36 52
 4.Aucas                  36 14 10 12 42-43 52  A2
 5.Olmedo                 36 14 10 12 33-35 52  A3 
 6.Macará                 36 14  9 13 50-50 51
 7.Deportivo (Quito)      36 12 12 12 52-49 48
 8.Barcelona              36 12 12 12 44-45 48  C1
----------------------------------------------
 9.LDU Quito              36 12 11 13 50-47 47  Relegated
10.Técnico Universitario  36  6  8 22 42-82 26  Relegated

A3 = qualified for hexagonal with 3 bonus points from Apertura
A2 = qualified for hexagonal with 2 bonus points from Apertura
A1 = qualified for hexagonal with 1 bonus point from Apertura
C3 = qualified for hexagonal with 3 bonus points from Clausura
C2 = qualified for hexagonal with 2 bonus points from Clausura
C1 = qualified for hexagonal with 1 bonus point from Clausura

Promoted: LDU (Portoviejo) and Delfín

Hexagonal Final:

top-3 of Apertura and of Clausura qualify, with 3, 2, 1 bonus point.

If one or more clubs qualify twice, best teams in aggregate table take
place (but not bonus points) - so Espoli took El Nacional's '2nd place'.

Table:

 1.Olmedo                 10  6  2  2 15- 9 23  [ 3]  Champions
 2.El Nacional            10  5  2  3 15-11 20  [ 3]  Copa Libertadores
 3.Emelec                 10  5  2  3 13-13 20  [ 3]  Copa Libertadores
 4.Aucas                  10  2  5  3 10-13 13  [ 2]
 5.Barcelona              10  3  2  5 14-13 12  [ 1]
 6.Espoli                 10  1  3  6  6-14  6  [ 0] 

Round 1 [Nov 19]
Aucas         1-0 Espoli
Olmedo        3-0 Emelec
Barcelona     4-2 El Nacional

Round 2 [Nov 22] 
Espoli        2-1 Barcelona 
El Nacional   0-2 Olmedo   
Emelec        1-0 Aucas 

Round 3 [Nov 26]       
Emelec        3-1 Barcelona 
El Nacional   2-0 Espoli 
Olmedo        1-0 Aucas 

Round 4 [Nov 29] 
Barcelona     1-1 Olmedo 
Aucas         1-1 El Nacional  
Espoli        0-0 Emelec  

Round 5 [Dec 3]
Emelec        2-1 El Nacional
Aucas         2-0 Barcelona
Olmedo        2-0 Espoli

Round 6
[Dec 9] 
Barcelona     4-0 Aucas 
[Dec 10] 
El Nacional   3-0 Emelec  
Espoli        1-2 Olmedo  

Round 7 [Dec 13] 
Emelec        1-0 Espoli 
El Nacional   1-1 Aucas 
Olmedo        1-0 Barcelona 

Round 8 [Dec 17] 
Barcelona     2-0 Emelec 
Aucas         1-1 Olmedo   
Espoli        0-2 El Nacional  

Round 9 [Dec 20]       
Barcelona     1-1 Espoli 
Aucas         2-2 Emelec 
Olmedo        1-2 El Nacional 

Round 10 [Dec 23]
Emelec        4-1 Olmedo
El Nacional   1-0 Barcelona
Espoli        2-2 Aucas

Table:

 1.Olmedo                 10  6  2  2 15- 9 23  [ 3]  Champions
 2.El Nacional            10  5  2  3 15-11 20  [ 3]  Copa Libertadores
 3.Emelec                 10  5  2  3 13-13 20  [ 3]  Copa Libertadores
 4.Aucas                  10  2  5  3 10-13 13  [ 2]
 5.Barcelona              10  3  2  5 14-13 12  [ 1]
 6.Espoli                 10  1  3  6  6-14  6  [ 0] 


Author: Arvids Stashans
(sauleskalns@yahoo.com)

Last updated: 23 Feb 2001

(C) Copyright Arvids Stashans and RSSSF 1999/2001

INFORMACIÓN

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


  USO DE MEMORIA  
4,343,968 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0022
Controller Execution Time ( Home / Category )  0.0705
Total Execution Time  0.0728
  CADENA URL  
/ecuador2000
  GET DATOS  
$_GET['/ecuador2000']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (23)  
0.0018  SELECT type FROM routes WHERE alias = 'ecuador2000'
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 = 1 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 2000 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=1 DESC LIMIT 1
0.0019  SELECT text_es as historical_text FROM leagues_text WHERE id=382
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 = 28704 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0020  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.0018  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-04-26 07:23:11' 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-04-26 07:23:11' 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-04-26 07:23:11' 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-04-26 07:23:11' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0022  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 = 2000 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=0 DESC LIMIT 1
0.0022  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=28704 AND rel.round=18
0.0018  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 = 28704 AND esl.points > 0 ORDER BY esl.points DESC LIMIT 3
0.0018  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 = 28704 AND esl.points > 0
0.0017  SELECT fau.user_name, c.*, NOW() as difference_time,creation_date FROM (leagues as l) INNER JOIN comments as c ON c.league_id = l.id LEFT JOIN fa_user fau ON fau.id = c.author_id WHERE c.creation_date > "2024-03-27" AND c.`active`= 1 and c.comment_id is null and c.lang = 1 AND l.`id` = 28704 ORDER BY creation_date DESC LIMIT 0, 10
0.0022  SELECT count(c.id) as cuenta FROM (leagues as l) INNER JOIN comments as c ON c.league_id = l.id WHERE c.creation_date > "2024-03-27" AND c.`active`= 1 and comment_id is null and c.lang = 1 AND l.`id` = 28704
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 `calendars2000` 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` = 28704 AND c.`round` = 18 ORDER BY shedule ASC LIMIT 200
0.0021  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 `events2000` e INNER JOIN calendars2000 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 = 28704 ORDER BY total DESC LIMIT 40
0.0019  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 `events2000` e INNER JOIN calendars2000 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 = 28704 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 `tables2000` 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 = 28704 AND t.round = 16 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0020  SELECT *,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables2000` 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 = 28704 AND t.round = 18 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0018  SELECT c.id, 2024 AS year, IF(l.tables = 1 AND t1.points>0,((t1.points / (l.current_round * 3)) + (t2.points / (l.current_round * 3)))/2 * ct.coefficient,0.7 * ct.coefficient) as fcoef FROM `calendars2024` AS c INNER JOIN `leagues` AS l ON c.`league_id` = l.`id` INNER JOIN `categories` AS ct ON ct.`id` = l.`categoryId` LEFT JOIN tables2024 AS t1 ON t1.team = c.team1 AND t1.round = l.current_round LEFT JOIN tables2024 AS t2 ON t2.team = c.team2 AND t2.round = l.current_round WHERE c.`shedule` > '2024-04-26 00:00:00' AND c.`shedule` < '2024-04-30 23:59:59' AND l.id = 28704 ORDER BY c.shedule ASC, fcoef DESC LIMIT 5
0.0021  SELECT data1, data2 FROM services_tags WHERE categoryId=43
0.0021  SELECT group_code, extraName from `leagues` WHERE categoryId=43 AND year=2000