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
						

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,364,352 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0022
Controller Execution Time ( Home / Category )  0.5377
Total Execution Time  0.5399
  CADENA URL  
/ecuador2000/grupo2
  GET DATOS  
$_GET['/ecuador2000/grupo2']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (41)  
0.0105  SELECT type FROM routes WHERE alias = 'ecuador2000'
0.0213  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 = 2000 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.0125  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.0107  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.0108  SELECT text_es as historical_text FROM leagues_text WHERE id=382
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 = 28704 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.0108  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.0105  SELECT type,rule FROM rules WHERE categoryId = 43 ORDER BY type = 'tables_draw' DESC,type != 'extra' DESC, `order` ASC
0.0105  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-03-29 05:18:43' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0106  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=2 AND last_update > '2024-03-29 05:18:43' 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-29 05:18:43' 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-29 05:18:43' 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 = 2000 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=0 DESC LIMIT 1
0.0105  SELECT e.action, count(e.action) as total, e.player_id FROM events2000 e WHERE e.league_id IN (28704) 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.0109  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 (28704) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN () ORDER BY rp.in_squad = 1 DESC
0.0109  SELECT e.action, count(e.action) as total, e.player_id FROM events2000 e WHERE e.league_id IN (28704) AND (e.action IN (4,5) ) GROUP BY e.player_id ORDER BY total DESC, e.player_id ASC LIMIT 20
0.0108  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 (28704) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN () ORDER BY rp.in_squad = 1 DESC
0.0110  SELECT e.action, count(e.action) as total, e.player_id FROM events2000 e WHERE e.league_id IN (28704) AND (e.action IN (3,4) ) GROUP BY e.player_id ORDER BY total DESC, e.player_id ASC LIMIT 20
0.0111  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 (28704) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN () ORDER BY rp.in_squad = 1 DESC
0.0114  SELECT e.action, count(e.action) as total, e.player_id FROM events2000 e WHERE e.league_id IN (28704) AND (e.action IN (22) ) GROUP BY e.player_id ORDER BY total DESC, e.player_id ASC LIMIT 20
0.0119  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 (28704) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN () ORDER BY rp.in_squad = 1 DESC
0.0114  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 = 28704 AND rp.lineup > 0 ORDER BY rp.lineup DESC,p.pod DESC LIMIT 20
0.0114  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 = 28704 AND rp.events > 0 ORDER BY rp.events DESC,p.pod DESC LIMIT 20
0.0113  SELECT max(l.year) as max_year, min(l.year) as min_year FROM leagues l WHERE categoryID = 43 GROUP BY l.categoryId
0.0111  SELECT l.year FROM leagues AS l WHERE (l.group_code =0 OR l.total_num_tablesR>=1 OR l.total_teamsR >=1 OR l.text_mode != 0) AND l.categoryId=43 GROUP BY l.year ORDER BY l.year DESC
0.0107  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.0108  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.0107  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.0110  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` = 28704 ORDER BY creation_date DESC LIMIT 0, 10
0.0118  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` = 28704
0.0115  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.0110  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.0111  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.0112  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.0112  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.0112  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 = 28704 ORDER BY c.shedule ASC, fcoef DESC LIMIT 5
0.0112  SELECT data1, data2 FROM services_tags WHERE categoryId=43
0.0112  SELECT l.year,l.group_code FROM leagues_besoccer l WHERE l.categoryId = 43 AND l.year = 2000 ORDER BY l.group_code ASC
0.0112  SELECT group_code, extraName from `leagues` WHERE categoryId=43 AND year=2000