Información Histórica
						
Torneo Apertura
---------------

Table:

 1.El Nacional            22 12  8  2 34-13 44
 2.Emelec                 22 12  2  8 40-31 38
 3.LDU Quito              22 12  2  8 31-27 38
 4.Barcelona              22 10  5  7 25-24 35
 5.Macará                 22  9  5  8 28-30 32
 6.Olmedo                 22  7 10  5 28-29 31
 7.Espoli                 22  9  3 10 38-29 30
 8.Delfín                 22  8  5  9 28-35 29
 9.Deportivo (Quito)      22  7  6  9 32-29 27
10.Deportivo (Cuenca)     22  7  6  9 25-33 27
11.Aucas                  22  6  4 12 26-32 22
12.Audaz Octubrino        22  4  2 16 15-38 14

Round 1 
[Mar 5]
Emelec                 1-0  Audaz Octubrino
[Mar 6]
Deportivo Cuenca       3-2  Espoli
[Mar 7]
Aucas                  3-1  Olmedo
Macará                 0-0  El Nacional
Deportivo Quito        1-2  LDU
[Mar 8]
Delfín                 1-3  Barcelona

Round 2 
[Mar 14]
El Nacional            2-1  Aucas
Espoli                 2-0  Macará
LDU                    4-0  Delfín
Audaz Octubrino        1-2  Deportivo Quito
Olmedo                 2-0  Emelec
[Mar 15]
Barcelona              1-0  Deportivo Cuenca

Round 3 
[Mar 20]
Emelec                 1-1  El Nacional
[Mar 21]
Aucas                  0-1  Espoli
Deportivo Cuenca       1-0  LDU
Delfín                 3-1  Audaz Octubrino
[Mar 24]
Deportivo Quito        1-2  Olmedo   
[Apr 7]
Macará                 1-0  Barcelona 

Round 4 
[Mar 27]
El Nacional            1-0  Deportivo Cuenca
Espoli                 1-1  Deportivo Quito
Audaz Octubrino        2-1  Macará
Olmedo                 0-0  Delfín
[Mar 28]
Barcelona              2-1  Aucas
LDU                    3-1  Emelec

Round 5 [Mar 31]
Emelec                 3-0  Espoli
Aucas                  4-1  Audaz Octubrino
Deportivo Quito        2-0  Barcelona
Deportivo Cuenca       2-2  Olmedo
Delfín                 0-0  El Nacional
Macará                 1-1  LDU

Round 6 
[Apr 3]
LDU                    2-1  Aucas
Audaz Octubrino        0-2  Deportivo Cuenca
Olmedo                 2-1  Macará
[Apr 4]
Deportivo Quito        2-2  El Nacional
Barcelona              1-1  Emelec
Espoli                 4-1  Delfín

Round 7 
[Apr 9]
Deportivo Cuenca       1-0  Aucas
[Apr 10]
Barcelona              2-0  Espoli
El Nacional            0-0  Olmedo
[Apr 11]
LDU                    2-1  Audaz Octubrino
Delfín                 1-0  Deportivo Quito
Macará                 1-0  Emelec

Round 8 
[Apr 17]
El Nacional            4-0  LDU
[Apr 18]
Emelec                 4-2  Delfín
Deportivo Quito        4-1  Deportivo Cuenca
Aucas                  0-1  Macará
Audaz Octubrino        2-1  Espoli
Olmedo                 1-2  Barcelona

Round 9 [Apr 25]
Barcelona              2-1  Audaz Octubrino
Espoli                 1-2  El Nacional
LDU                    3-0  Olmedo
Deportivo Quito        0-0  Aucas
Deportivo Cuenca       1-4  Emelec
Macará                 2-2  Delfín

Round 10 [Apr 28]
Emelec                 2-1  Deportivo Quito
LDU                    3-2  Barcelona
El Nacional            1-1  Audaz Octubrino
Deportivo Cuenca       1-1  Macará 
Olmedo                 1-1  Espoli
Delfín                 3-0  Aucas  
  
Round 11 [May 2]
Barcelona              0-1  El Nacional
Aucas                  2-1  Emelec 
Espoli                 0-1  LDU 
Audaz Octubrino        0-2  Olmedo 
Delfín                 1-1  Deportivo Cuenca
Macará                 2-0  Deportivo Quito

Round 12 
[May 7]  
Deportivo Cuenca       4-1  Delfín
[May 8]  
LDU                    0-2  Espoli 
El Nacional            4-0  Barcelona 
[May 9]
Emelec                 3-0  Aucas
Olmedo                 1-0  Audaz Octubrino  
Deportivo Quito        1-1  Macará

Round 13 [May 16]
Deportivo Quito        4-2  Emelec
Barcelona              2-2  LDU 
Audaz Octubrino        1-0  El Nacional
Macará                 2-0  Deportivo Cuenca
Espoli                 3-0  Olmedo
Aucas                  0-1  Delfín

Round 14
[May 22]
El Nacional            2-0  Espoli
[May 23]
Audaz Octubrino        0-1  Barcelona
Olmedo                 2-1  LDU
Aucas                  2-2  Deportivo Quito
Emelec                 5-2  Deportivo Cuenca
Delfín                 2-0  Macará

Round 15 
[May 28] 
Deportivo Cuenca       0-1  Deportivo Quito
[May 29] 
Espoli                 4-0  Audaz Octubrino
[May 30] 
Delfín                 2-1  Emelec
Macará                 3-2  Aucas 
LDU                    0-3  El Nacional
Barcelona              0-0  Olmedo  

Round 16 [Jun 6]
Espoli                 1-1  Barcelona
Olmedo                 1-1  El Nacional
Audaz Octubrino        0-1  LDU 
Aucas                  0-2  Deportivo Cuenca
Deportivo Quito        2-1  Delfín
Emelec                 3-1  Macará 
 
Round 17
[Jun 12]
Emelec                 1-0  Barcelona
El Nacional            2-1  Deportivo Quito
[Jun 13]
Delfín                 2-0  Espoli
Aucas                  0-1  LDU
Deportivo Cuenca       2-0  Audaz Octubrino
Macará                 2-4  Olmedo

Round 18 
[Jul 24] 
Espoli                 3-0  Emelec 
[Jul 25] 
Audaz Octubrino        0-0  Aucas  
Barcelona              2-0  Deportivo Quito
Olmedo                 1-1  Deportivo Cuenca
El Nacional            3-1  Delfín
LDU                    1-2  Macará

Round 19 
[Jul 27] 
Emelec                 2-1  LDU 
Deportivo Quito        1-2  Espoli
Macará                 2-1  Audaz Octubrino
[Jul 28] 
Aucas                  3-0  Barcelona
Deportivo Cuenca       0-0  El Nacional
Delfín                 1-1  Olmedo 
  
Round 20 [Aug 1]
El Nacional            2-0  Emelec 
Olmedo                 2-2  Deportivo Quito
Espoli                 2-3  Aucas 
LDU                    1-0  Deportivo Cuenca
Audaz Octubrino        2-0  Delfín 
Barcelona              2-0  Macará
  
Round 21 
[Aug 6]
Deportivo Quito        4-0  Audaz Octubrino
[Aug 7]  
Emelec                 3-1  Olmedo
[Aug 8]  
Aucas                  2-1  El Nacional
Macará                 3-2  Espoli
Delfín                 2-1  LDU 
Deportivo Cuenca       0-0  Barcelona
  
Round 22 [Aug 15]
Audaz Octubrino        1-2  Emelec 
Espoli                 6-1  Deportivo Cuenca
Olmedo                 2-2  Aucas  
El Nacional            2-1  Macará 
LDU                    1-0  Deportivo Quito
Barcelona              2-1  Delfín  

Table:

 1.El Nacional            22 12  8  2 34-13 44
 2.Emelec                 22 12  2  8 40-31 38
 3.LDU Quito              22 12  2  8 31-27 38
 4.Barcelona              22 10  5  7 25-24 35
 5.Macará                 22  9  5  8 28-30 32
 6.Olmedo                 22  7 10  5 28-29 31
 7.Espoli                 22  9  3 10 38-29 30
 8.Delfín                 22  8  5  9 28-35 29
 9.Deportivo (Quito)      22  7  6  9 32-29 27
10.Deportivo (Cuenca)     22  7  6  9 25-33 27
11.Aucas                  22  6  4 12 26-32 22
12.Audaz Octubrino        22  4  2 16 15-38 14

NB: El Nacional (3 bonus ponts), Emelec (2), LDU (1) and 
    Barcelona (0) qualified for Final of the championship.
    Audaz Octubrino (-3), Aucas (-2) and Deportivo Quito (-1) 
    to play in No Descenso unless they win one of the hexagonals
    in the second stage.  This applied to Deportivo Quito; their
    penalty point went to Deportivo Cuenca.


Second Stage

Tables:

Group 1

 1.Deportivo (Quito)      10  6  1  3 19- 9 19
 2.Macará                 10  5  0  5 15-16 15
 3.Audaz Octubrino        10  5  0  5 13-17 15
 4.El Nacional            10  4  2  4 18-15 14
 5.Barcelona              10  4  1  5 13-14 13
 6.Delfín                 10  4  0  6 13-20 12

Group 2

 1.Espoli                 10  7  1  2 15-11 22
 2.LDU Quito              10  5  2  3 12- 8 17
 3.Emelec                 10  5  1  4 17-20 16
 4.Olmedo                 10  3  2  5 11-14 11 
 5.Aucas                  10  2  3  5 11- 9  9
 6.Deportivo (Cuenca)     10  2  3  5  8-12  9

Round 1 [Aug 22]
Deportivo Cuenca       0-0  Aucas
Macará                 3-1  El Nacional
LDU                    1-0  Olmedo 
Emelec                 1-2  Espoli       
Deportivo Quito        4-1  Audaz Octubrino
Delfín                 3-0  Barcelona
 
Round 2
[Aug 27] 
LDU                    4-1  Espoli 
[Aug 28] 
Barcelona              3-1  Deportivo Quito 
El Nacional            4-1  Delfín 
[Aug 29] 
Aucas                  7-0  Emelec 
Olmedo                 2-2  Deportivo Cuenca
Audaz Octubrino        2-0  Macará 
 
Round 3  
[Sep 3]  
Deportivo Cuenca       1-0  LDU 
[Sep 4]
Espoli                 2-1  Aucas  
[Sep 5]  
Emelec                 1-0  Olmedo
El Nacional            1-1  Barcelona
Macará                 2-1  Deportivo Quito
Delfín                 2-1  Audaz Octubrino
 
Round 4  
[Sep 7]
Audaz Octubrino        1-0  El Nacional
[Sep 8]
Barcelona              3-0  Macará
Deportivo Quito        3-0  Delfín 
LDU                    2-1  Emelec 
Deportivo Cuenca       0-2  Espoli
Olmedo                 1-0  Aucas

Round 5 [Sep 12]
Emelec                 4-1  Deportivo Cuenca 
El Nacional            2-2  Deportivo Quito
Aucas                  0-0  LDU 
Espoli                 3-1  Olmedo 
Audaz Octubrino        1-0  Barcelona
Delfín                 2-1  Macará

Round 6  
[Sep 17] 
Deportivo Cuenca       3-0  Emelec  
LDU                    1-0  Aucas 
[Sep 19] 
Deportivo Quito        3-0  El Nacional
Olmedo                 2-0  Espoli
Barcelona              3-0  Audaz Octubrino
Macará                 2-1  Delfín 

Round 7
[Sep 21] 
Emelec                 3-2  LDU 
[Sep 22] 
Macará                 4-1  Barcelona
Delfín                 0-1  Deportivo Quito
Espoli                 1-0  Deportivo Cuenca
El Nacional            4-0  Audaz Octubrino
Aucas                  3-1  Olmedo 
  
Round 8 [Sep 26]
LDU                    1-0  Deportivo Cuenca
Aucas                  0-1  Espoli
Olmedo                 1-2  Emelec
Barcelona              1-2  El Nacional
Deportivo Quito        2-0  Macará
Audaz Octubrino        6-1  Delfín

Round 9
[Oct 1]  
Deportivo Cuenca       1-2  Olmedo
[Oct 3]  
Espoli                 1-0  LDU 
Deportivo Quito        2-0  Barcelona
Delfín                 3-1  El Nacional
Emelec                 3-0  Aucas 
Macará                 3-0  Audaz Octubrino

Round 10 [Oct 9]
Aucas                  0-0  Deportivo Cuenca
El Nacional            3-0  Macará
Olmedo                 1-1  LDU
Espoli                 2-2  Emelec
Audaz Octubrino        1-0  Deportivo Quito
Barcelona              1-0  Delfín

Tables:

Group 1

 1.Deportivo (Quito)      10  6  1  3 19- 9 19
 2.Macará                 10  5  0  5 15-16 15
 3.Audaz Octubrino        10  5  0  5 13-17 15
 4.El Nacional            10  4  2  4 18-15 14
 5.Barcelona              10  4  1  5 13-14 13
 6.Delfín                 10  4  0  6 13-20 12

Group 2

 1.Espoli                 10  7  1  2 15-11 22  
 2.LDU Quito              10  5  2  3 12- 8 17
 3.Emelec                 10  5  1  4 17-20 16
 4.Olmedo                 10  3  2  5 11-14 11 
 5.Aucas                  10  2  3  5 11- 9  9
 6.Deportivo (Cuenca)     10  2  3  5  8-12  9

Group winners (Deportivo Quito and Espoli) qualify for championship final.
Both obtain 2 bonus points.

Delfín and Deportivo (Cuenca) obtain 2 penalty points in the
No Descenso for finishing last.

Championship Final:

Table:

 1.El Nacional            10  4  5  1 14- 8 20  [3]
 2.LDU Quito              10  5  3  2 15-11 19  [1]
 3.Emelec                 10  5  1  4 13- 9 18  [2]
 4.Deportivo (Quito)      10  3  3  4 16-20 14  [2]
 5.Espoli                 10  2  3  5 11-15 11  [2]
 6.Barcelona              10  2  3  5 13-19  9  [0]

[bonus points between square brackets]

Round 1
[Oct 17]
LDU                    0-1  El Nacional
Deportivo Quito        2-2  Emelec
Barcelona              2-1  Espoli

Round 2 [Oct 24]
Emelec                 0-1  LDU
El Nacional            4-1  Barcelona
Deportivo Quito        4-1  Espoli

Round 3 [Oct 31]
Espoli                 0-0  El Nacional
LDU                    3-1  Deportivo Quito
Barcelona              1-3  Emelec

Round 4
[Nov 3]
Deportivo Quito        1-0  Barcelona
LDU                    3-2  Espoli
[Nov 5]
Emelec                 1-0  El Nacional

Round 5 [Nov 7]
Espoli                 2-1  Emelec
El Nacional            1-1  Deportivo Quito
Barcelona              2-2  LDU

Round 6 [Nov 14]
Emelec                 2-0  Espoli
Deportivo Quito        3-3  El Nacional
LDU                    1-1  Barcelona

Round 7
[Nov 17]
Espoli                 0-0  LDU
El Nacional            1-0  Emelec
[Nov 19]
Barcelona              4-1  Deportivo Quito

Round 8 [Nov 21]
El Nacional            1-1  Espoli
Deportivo Quito        2-3  LDU
Emelec                 1-0  Barcelona

Round 9 [Nov 28]
LDU                    2-0  Emelec
Barcelona              1-1  El Nacional
Espoli                 0-1  Deportivo Quito 

Round 10 [Dec 5]
Espoli                 4-1  Barcelona
El Nacional            2-0  LDU   
Emelec                 3-0  Deportivo Quito

Table:

 1.El Nacional            10  4  5  1 14- 8 20  [3]
 2.LDU Quito              10  5  3  2 15-11 19  [1]
 3.Emelec                 10  5  1  4 13- 9 18  [2]
 4.Deportivo (Quito)      10  3  3  4 16-20 14  [2]
 5.Espoli                 10  2  3  5 11-15 11  [2]
 6.Barcelona              10  2  3  5 13-19  9  [0]

[bonus points between square brackets]

El Nacional and LDU Quito qualified for final.


Championship Final

First Leg [Dec 12]
LDU Quito              1-0  El Nacional
  [Eduardo Hurtado]

Second Leg [Dec 19]
El Nacional            1-3  LDU

LDU Quito champions of Ecuador 1999.


No Descenso:

Table:

 1.Aucas                  10  6  3  1 20-12 19  [-2]
 2.Macará                 10  4  4  2 19-15 16  [0]
 3.Olmedo                 10  4  3  3 13- 8 15  [0]
----------------------------------------------
 4.Delfín                 10  5  1  4 23-11 14  [-2]  Relegated
 5.Deportivo (Cuenca)     10  4  2  4 10-14 11  [-3]  Relegated
 6.Audaz Octubrino        10  0  1  9  4-29 -2  [-3]  Relegated

[penalty points between square brackets]

Round 1
[Oct 16]
Deportivo Cuenca       0-1  Olmedo
[Oct 17]
Aucas                  3-0  Delfín
Macará                 4-1  Audaz Octubrino

Round 2 [Oct 24]
Audaz Octubrino        1-2  Aucas
Olmedo                 0-0  Macará
Delfín                 3-0  Deportivo Cuenca

Round 3 [Oct 31]
Aucas                  2-1  Olmedo
Audaz Octubrino        1-1  Delfín
Macará                 4-1  Deportivo Cuenca

Round 4 [Nov 3]
Deportivo Cuenca       0-1  Aucas
Olmedo                 4-0  Audaz Octubrino
Delfín                 5-1  Macará

Round 5 [Nov 7]
Aucas                  4-2  Macará
Audaz Octubrino        0-1  Deportivo Cuenca
Olmedo                 1-0  Delfín

Round 6
[Nov 13]
Macará                 1-1  Aucas
[Nov 14]
Deportivo Cuenca       1-0  Audaz Octubrino
Delfín                 2-1  Olmedo

Round 7 [Nov 17]
Aucas                  3-3  Deportivo Cuenca
Audaz Octubrino        0-2  Olmedo
Macará                 2-1  Delfín

Round 8 [Nov 21]
Olmedo                 1-1  Aucas
Delfín                 9-0  Audaz Octubrino
Deportivo Cuenca       1-1  Macará

Round 9 [Nov 28]
Aucas                  2-1  Audaz Octubrino
Macará                 1-1  Olmedo
Deportivo Cuenca       1-0  Delfín  

Round 10 
[Dec 4]
Olmedo                 1-2  Deportivo Cuenca
[Dec 5]
Delfín                 2-1  Aucas
Audaz Octubrino        0-3  Macará

Table:

 1.Aucas                  10  6  3  1 20-12 19  [-2]
 2.Macará                 10  4  4  2 19-15 16  [0]
 3.Olmedo                 10  4  3  3 13- 8 15  [0]
----------------------------------------------
 4.Delfín                 10  5  1  4 23-11 14  [-2]  Relegated
 5.Deportivo (Cuenca)     10  4  2  4 10-14 11  [-3]  Relegated
 6.Audaz Octubrino        10  0  1  9  4-29 -2  [-3]  Relegated

[penalty points between square brackets]

[NB: Serie A reduced to 10 clubs for 2000.]


Author: Arvids Stashans
(stashans@mail.epn.edu.ec)

Last updated: 11 Feb 2000

(C) Copyright Arvids Stashans and RSSSF 1999/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,384,576 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0024
Controller Execution Time ( Home / Category )  0.1071
Total Execution Time  0.1096
  CADENA URL  
/ecuador1999
  GET DATOS  
$_GET['/ecuador1999']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (36)  
0.0018  SELECT type FROM routes WHERE alias = 'ecuador1999'
0.0038  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 = 1999 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=1 DESC LIMIT 1
0.0021  SELECT text_es as historical_text FROM leagues_text WHERE id=416
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 = 28739 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0021  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.0023  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.0018  SELECT type,rule FROM rules WHERE categoryId = 43 ORDER BY type = 'tables_draw' DESC,type != 'extra' DESC, `order` ASC
0.0018  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-03-29 14:16:02' 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-29 14:16:02' 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-29 14:16:02' 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-03-29 14:16:02' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0023  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 = 1999 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=0 DESC LIMIT 1
0.0018  SELECT e.action, count(e.action) as total, e.player_id FROM events1999 e WHERE e.league_id IN (28739) 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.0019  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 (28739) 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 events1999 e WHERE e.league_id IN (28739) AND (e.action IN (4,5) ) GROUP BY e.player_id ORDER BY total DESC, e.player_id ASC LIMIT 20
0.0019  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 (28739) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN () ORDER BY rp.in_squad = 1 DESC
0.0022  SELECT e.action, count(e.action) as total, e.player_id FROM events1999 e WHERE e.league_id IN (28739) AND (e.action IN (3,4) ) GROUP BY e.player_id ORDER BY total DESC, e.player_id ASC LIMIT 20
0.0020  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 (28739) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN () ORDER BY rp.in_squad = 1 DESC
0.0026  SELECT e.action, count(e.action) as total, e.player_id FROM events1999 e WHERE e.league_id IN (28739) AND (e.action IN (22) ) GROUP BY e.player_id ORDER BY total DESC, e.player_id ASC LIMIT 20
0.0023  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 (28739) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN () ORDER BY rp.in_squad = 1 DESC
0.0020  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 = 28739 AND rp.lineup > 0 ORDER BY rp.lineup DESC,p.pod DESC LIMIT 20
0.0019  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 = 28739 AND rp.events > 0 ORDER BY rp.events DESC,p.pod DESC LIMIT 20
0.0031  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=28739 AND rel.round=22
0.0027  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 = 28739 AND esl.points > 0 ORDER BY esl.points DESC LIMIT 3
0.0030  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 = 28739 AND esl.points > 0
0.0024  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` = 28739 ORDER BY creation_date DESC LIMIT 0, 10
0.0040  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` = 28739
0.0023  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 `calendars1999` 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` = 28739 AND c.`round` = 22 ORDER BY shedule ASC LIMIT 200
0.0019  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 `events1999` e INNER JOIN calendars1999 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 = 22 AND e.real_date IS NOT NULL AND e.league_id = 28739 ORDER BY total DESC LIMIT 40
0.0040  SELECT c.r1,c.r2,e.action,ev.showName as eventName,ev.largeName,ev.main_action,ev.keyname,ev.classf,e.real_date,e.minute, dp.nick,dp.CountryCode,dp.alias,c.datateam1,c.datateam2,dt1.nameShow as nameShow1,dt2.nameShow as nameShow2,dt1.basealias as basealias1,dt2.basealias as basealias2,e.player_id,e.match_id FROM `events1999` e INNER JOIN calendars1999 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 = 28739 AND e.real_date > NOW() - INTERVAL 1 MONTH ORDER BY e.real_date DESC LIMIT 30
0.0032  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 `tables1999` 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 = 28739 AND t.round = 20 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0032  SELECT *,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables1999` 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 = 28739 AND t.round = 22 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0032  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 = 28739 ORDER BY c.shedule ASC, fcoef DESC LIMIT 5
0.0032  SELECT data1, data2 FROM services_tags WHERE categoryId=43
0.0032  SELECT l.year,l.group_code FROM leagues_besoccer l WHERE l.categoryId = 43 AND l.year = 1999 ORDER BY l.group_code ASC
0.0032  SELECT group_code, extraName from `leagues` WHERE categoryId=43 AND year=1999