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

Torneo Apertura
---------------

Tables:

Grupo A
 1.Barcelona              10  6  2  2  17- 8  20   [Guayaquil]
 2.El Nacional            10  5  3  2  21-11  18   [Quito]
 3.Aucas                  10  6  0  4  16-11  18   [Quito]
 4.Deportivo Cuenca       10  4  4  2  13-13  16   [Cuenca]
 5.Técnico Universitário  10  2  4  4  12-16  10   [Ambato]
 6.Calvi                  10  0  1  9   9-29   1   [Machala]

Grupo B
 1.LDU Quito              10  6  3  1  23-10  21   [Quito]
 2.Olmedo                 10  6  2  2  11- 8  20   [Riobamba]
 3.Emelec                 10  5  3  2  20-11  18   [Guayaquil]
 4.Espoli                 10  2  4  4   9-15  10   [Quito]
 5.Deportivo Quito        10  1  3  6  10-17   6   [Quito]
 6.Deportivo Quevedo      10  0  5  5   6-18   5   [Babahoyo]

[Barcelona and LDU Quito both obtain 1 bonus point for Championship
 playoff]


Round 1 [Mar 8,9]
Grupo A
Barcelona     0-0 Tecnico U
Aucas         2-1 Nacional
Cuenca        1-0 Calvi
Grupo B
LDU           4-1 Emelec      [Apr 16]
Dep Quito     3-0 Quevedo
Olmedo        2-0 Espoli

Round 2 [Mar 15,16]
Grupo A
Nacional      1-1 Cuenca
Tecnico U     2-1 Aucas
Calvi         1-5 Barcelona
Grupo B
LDU           1-1 Espoli
Olmedo        1-0 Quevedo
Emelec        1-0 Dep Quito

Round 3 [Mar 22,23]
Grupo A
Nacional      2-1 Calvi       [Apr 16]   
Aucas         2-1 Barcelona
Cuenca        0-0 Tecnico U
Grupo B
LDU           1-1 Dep Quito
Espoli        1-1 Quevedo
Olmedo        1-1 Emelec

Round 4 [Apr 5,6]
Grupo A
Barcelona     3-0 Cuenca
Aucas         4-0 Calvi
Tecnico U     2-3 Nacional
Grupo B
Dep Quito     0-1 Olmedo
Quevedo       2-4 LDU
Emelec        2-0 Espoli      [May 15]

Round 5 [Apr 12,13]
Grupo A
Cuenca        1-0 Aucas
Calvi         2-2 Tecnico U
Nacional      1-1 Barcelona
Grupo B
Espoli        2-2 Dep Quito
LDU           1-1 Olmedo
Emelec        1-1 Quevedo

Round 6 [Apr 19,20]
Grupo A
Barcelona     1-0 Nacional
Aucas         3-2 Cuenca
Tecnico U     4-2 Calvi
Grupo B
Olmedo        0-2 LDU
Dep Quito     0-1 Espoli
Quevedo       1-1 Emelec

Round 7 [May 3,4]
Grupo A
Cuenca        2-1 Barcelona
Calvi         0-1 Aucas
Nacional      4-1 Tecnico U
Grupo B
Espoli        2-1 Emelec
Olmedo        1-0 Dep Quito
LDU           5-0 Quevedo

Round 8 [May 10,11]
Grupo A
Nacional      5-0 Calvi
Barcelona     2-1 Aucas
Tecnico U     1-1 Cuenca
Grupo B
Emelec        3-0 Olmedo
Quevedo       0-0 Espoli
LDU           2-1 Dep Quito

Round 9 [May 17,18]
Grupo A
Aucas         2-0 Tecnico U
Barcelona     2-1 Calvi
Cuenca        2-2 Nacional
Grupo B
LDU           3-1 Espoli
Dep Quito     2-7 Emelec
Olmedo        1-0 Quevedo

Round 10 [May 24]
Grupo A
Aucas         0-2 Nacional
Barcelona     1-0 Tecnico U
Cuenca        3-2 Calvi
Grupo B
Emelec        2-0 LDU
Espoli        1-3 Olmedo
Quevedo       1-1 Dep Quito

Tables:

Grupo A
 1.Barcelona              10  6  2  2  17- 8  20   [Guayaquil]
 2.El Nacional            10  5  3  2  21-11  18   [Quito]
 3.Aucas                  10  6  0  4  16-11  18   [Quito]
 4.Deportivo Cuenca       10  4  4  2  13-13  16   [Cuenca]
 5.Técnico Universitário  10  2  4  4  12-16  10   [Ambato]
 6.Calvi                  10  0  1  9   9-29   1   [Machala]

Grupo B
 1.LDU Quito              10  6  3  1  23-10  21   [Quito]
 2.Olmedo                 10  6  2  2  11- 8  20   [Riobamba]
 3.Emelec                 10  5  3  2  20-11  18   [Guayaquil]
 4.Espoli                 10  2  4  4   9-15  10   [Quito]
 5.Deportivo Quito        10  1  3  6  10-17   6   [Quito]
 6.Deportivo Quevedo      10  0  5  5   6-18   5   [Babahoyo]

[Barcelona and LDU Quito both obtain 1 bonus point for Championship
 playoff]


Torneo Clausura
---------------

Table:

 1.Barcelona              22 14  5  3  45-20  47   [Guayaquil]
 2.Deportivo Quito        22 11  9  2  38-15  42   [Quito]
 3.LDU Quito              22 12  6  4  39-19  42   [Quito]
 4.Emelec                 22 13  3  6  42-30  42   [Guayaquil]
 5.Deportivo Cuenca       22  9  5  8  30-32  32   [Cuenca]
 6.El Nacional            22  9  4  9  35-26  31   [Quito]
 7.Técnico Universitário  22  8  6  8  26-27  30   [Ambato]
 8.Aucas                  22  9  3 10  29-32  30   [Quito]
 9.Espoli                 22  8  4 10  35-39  28   [Quito]
10.Calvi                  22  7  3 12  35-40  24   [Machala]
11.Olmedo                 22  4  5 13  26-47  17   [Riobamba]
12.Deportivo Quevedo      22  0  3 19   9-62   3   [Babahoyo]

Round 1 [Jul 11-13]
Barcelona     2-0 Quevedo
Espoli        4-1 Calvi
LDU           3-1 Aucas
Dep Quito     2-2 Nacional
Cuenca        2-1 Emelec
Tecnico U     1-0 Olmedo

Round 2 [Jul 24] [inferred except Aucas v Barcelona]
Aucas         0-1 Barcelona
Nacional      0-0 LDU 
Emelec        3-0 Espoli
Calvi         0-1 Dep Quito
Quevedo       0-1 Olmedo
Tecnico U     1-1 Cuenca 

Round 3 [Jul 26,27]
LDU           2-0 Calvi
Olmedo        1-3 Aucas
Dep Quito     3-0 Emelec
Espoli        6-1 Quevedo
Cuenca        3-1 Nacional
Barcelona     2-0 Tecnico U

Round 4 [Aug 3]
Aucas         3-0 Cuenca
Nacional      4-1 Espoli
Emelec        1-1 Barcelona
Calvi         1-0 Olmedo
LDU           2-0 Quevedo
Tecnico U     1-1 Dep Quito

Round 5 [Aug 8,10]
LDU           2-1 Tecnico U
Cuenca        4-1 Olmedo
Nacional      0-1 Aucas
Dep Quito     4-1 Espoli
Calvi         3-3 Barcelona
Emelec        3-2 Quevedo

Round 6 [Aug 22,24]
Calvi         1-1 Emelec
Espoli        2-0 Barcelona
Aucas         1-2 Dep Quito
Olmedo        0-2 LDU
Tecnico U     2-0 Nacional
Quevedo       0-0 Cuenca

Round 7 [Aug 29-31]
Cuenca        1-0 Espoli
LDU           1-1 Emelec
Aucas         1-0 Calvi
Nacional      3-0 Olmedo
Tecnico U     5-0 Quevedo
Barcelona     0-0 Dep Quito

Round 8 [Sep 5-7]
Calvi         4-0 Cuenca
Emelec        1-0 Nacional
Dep Quito     1-1 LDU
Espoli        1-1 Tecnico U
Olmedo        1-2 Barcelona
Quevedo       0-2 Aucas

Round 9 [Sep 12-14]
LDU           4-0 Espoli
Dep Quito     5-0 Quevedo
Aucas         1-1 Tecnico U
Olmedo        3-1 Emelec
Barcelona     3-0 Cuenca
Calvi         2-1 Nacional

Round 10 [Sep 18]
Emelec        2-0 Tecnico U
Aucas         1-0 Espoli
Nacional      0-0 Barcelona
Dep Quito     3-0 Olmedo
Cuenca        0-0 LDU
Quevedo       0-4 Calvi

Round 11 [Sep 21]
LDU           2-0 Cuenca
Espoli        2-1 Aucas
Calvi         1-0 Quevedo
Barcelona     4-1 Nacional
Tecnico U     0-2 Emelec 
Olmedo        1-1 Dep Quito

Round 12 [Sep 24]
Barcelona     2-1 LDU
Espoli        1-1 Olmedo
Nacional      6-0 Quevedo
Cuenca        2-0 Dep Quito
Tecnico U     1-1 Calvi
Aucas         1-2 Emelec

Round 13 [Sep 28]
Tecnico U     3-1 Aucas
Nacional      2-1 Calvi
Espoli        2-2 LDU
Cuenca        3-1 Barcelona
Quevedo       0-0 Dep Quito
Emelec        6-1 Olmedo

Round 14 [Oct 5]
Espoli        3-3 Olmedo
Calvi         1-2 Tecnico U 
LDU           2-0 Barcelona
Dep Quito     2-1 Cuenca
Quevedo       0-1 Nacional
Emelec        3-1 Aucas

Round 15 [Oct 19]
LDU           1-1 Dep Quito
Barcelona     3-0 Olmedo
Nacional      4-1 Emelec
Tecnico U     2-0 Espoli   
Aucas         1-1 Quevedo
Cuenca        4-2 Calvi

Round 16 [Oct 22]
Emelec        1-0 LDU
Calvi         4-1 Aucas
Olmedo        1-1 Nacional
Dep Quito     1-1 Barcelona
Espoli        3-1 Cuenca
Quevedo       0-1 Tecnico U

Round 17 [Oct 26]
LDU           4-1 Olmedo
Dep Quito     0-0 Aucas
Nacional      3-0 Tecnico U
Barcelona     2-0 Espoli
Cuenca        2-0 Quevedo
Emelec        3-2 Calvi

Round 18 [Oct 29]
Espoli        0-2 Dep Quito
Barcelona     4-1 Calvi
Quevedo       2-4 Emelec
Nacional      0-2 Aucas
Tecnico U     1-2 LDU
Olmedo        2-2 Cuenca

Round 19 [Nov 1]
Espoli        2-1 Nacional
LDU           4-1 Quevedo
Dep Quito     4-0 Tecnico U
Barcelona     3-1 Emelec
Olmedo        2-1 Calvi
Cuenca        2-0 Aucas

Round 20 [Nov 5]
Calvi         1-3 LDU
Emelec        1-0 Dep Quito
Nacional      3-1 Cuenca
Tecnico U     1-2 Barcelona
Quevedo       1-4 Espoli
Aucas         3-2 Olmedo

Round 21 [Nov 9]
Barcelona     5-1 Aucas
Espoli        2-1 Emelec
Dep Quito     4-2 Calvi
LDU           1-2 Nacional
Cuenca        0-0 Tecnico U
Olmedo        4-0 Quevedo

Round 22
Calvi         2-1 Espoli
Emelec        3-1 Cuenca
Aucas         3-0 LDU
Nacional      0-1 Dep Quito
Tecnico U     2-1 Olmedo
Quevedo       1-4 Barcelona

Table:

 1.Barcelona              22 14  5  3  45-20  47   [Guayaquil]
 2.Deportivo Quito        22 11  9  2  38-15  42   [Quito]
 3.LDU Quito              22 12  6  4  39-19  42   [Quito]
 4.Emelec                 22 13  3  6  42-30  42   [Guayaquil]
 5.Deportivo Cuenca       22  9  5  8  30-32  32   [Cuenca]
 6.El Nacional            22  9  4  9  35-26  31   [Quito]
 7.Técnico Universitário  22  8  6  8  26-27  30   [Ambato]
 8.Aucas                  22  9  3 10  29-32  30   [Quito]
 9.Espoli                 22  8  4 10  35-39  28   [Quito]
10.Calvi                  22  7  3 12  35-40  24   [Machala]
11.Olmedo                 22  4  5 13  26-47  17   [Riobamba]
12.Deportivo Quevedo      22  0  3 19   9-62   3   [Babahoyo]

Barcelona winners of Torneo Clausura

Barcelona and Deportivo Quito obtain 2 and 1 bonus points for the
Championship Playoff, resp.


Overall Final Table:

 1.Barcelona              32 20  7  5  62-28  67   [Guayaquil]
 2.LDU Quito              32 18  9  5  62-29  63   [Quito]
 3.Emelec                 32 18  6  8  62-41  60   [Guayaquil]
 4.El Nacional            32 14  7 11  56-37  49   [Quito]
 5.Deportivo Quito        32 12 12  8  48-32  48   [Quito]
 6.Aucas                  32 15  3 14  45-43  48   [Quito]
------------------------------------------------
 7.Deportivo Cuenca       32 13  9 10  43-45  48   [Cuenca]
 8.Técnico Universitário  32 10 10 12  38-43  40   [Ambato]
------------------------------------------------
 9.Espoli                 32 10  8 14  44-54  38   [Quito]
10.Olmedo                 32 10  7 15  37-55  37   [Riobamba]
11.Calvi                  32  7  4 21  44-69  25   [Machala]
12.Deportivo Quevedo      32  0  8 24  15-80   8   [Babahoyo]


Championship Playoff

Table [bonus points between square brackets]:

 1.Barcelona              10  4  4  2  21-15  19   [3]
 2.Deportivo Quito        10  5  3  2  16-10  19   [1]
 3.Emelec                 10  4  3  3  18-18  15  
 4.LDU Quito              10  3  4  3  15-17  14   [1]
 5.El Nacional            10  3  2  5  17-17  11   
 6.Aucas                  10  1  4  5   9-19   7 

Barcelona 1997 champions.

Round 1 [Dec 7]
Nacional      1-1 LDU
Emelec        3-0 Aucas
Dep Quito     2-2 Barcelona 

Round 2 [Dec 10]
Aucas         0-0 Dep Quito
LDU           1-1 Emelec
Barcelona     1-2 Nacional

Round 3 [Dec 14]
Dep Quito     2-1 Nacional
LDU           0-1 Aucas   
Emelec        0-2 Barcelona

Round 4 [Dec 21]
Dep Quito     5-1 Emelec
Aucas         2-2 Nacional
Barcelona     2-2 LDU             

Round 5 [Dec 28,29]
Aucas         1-1 Barcelona  
LDU           0-0 Dep Quito
Emelec        2-1 Nacional

Round 6 [Jan 3]
Dep Quito     3-1 LDU
Nacional      2-1 Emelec
Barcelona     3-1 Aucas

Round 7 [Jan 10,11]
Nacional      4-1 Aucas
LDU           3-2 Barcelona
Emelec        1-0 Dep Quito

Round 8 [Jan 18]
Barcelona     2-2 Emelec  
Aucas         1-2 LDU
Nacional      1-2 Dep Quito

Round 9 [Jan 21]
Nacional      2-3 Barcelona
Dep Quito     2-0 Aucas
Emelec        5-3 LDU

Round 10 [Jan 25]
Aucas         2-2 Emelec
LDU           2-1 Nacional
Barcelona     3-0 Dep Quito

Table [bonus points between square brackets]:

 1.Barcelona              10  4  4  2  21-15  19   [3]
 2.Deportivo Quito        10  5  3  2  16-10  19   [1]
 3.Emelec                 10  4  3  3  18-18  15  
 4.LDU Quito              10  3  4  3  15-17  14   [1]
 5.El Nacional            10  3  2  5  17-17  11   
 6.Aucas                  10  1  4  5   9-19   7 

Barcelona 1997 champions.

Playoff Descenso

Table:

 1.Olmedo                  6  4  1  1  12- 5  13
 2.Espoli                  6  3  2  1   9- 5  11
 3.Deportivo Quevedo       5  1  2  2   3- 6   5
 4.Calvi                   5  0  1  4   3-11   1

Round 1
Olmedo        2-0 Espoli
Calvi         1-1 Quevedo

Round 2 [Dec 7]
Quevedo       1-0 Olmedo
Espoli        1-0 Calvi

Round 3 [Dec 10]
Calvi         0-1 Olmedo
Espoli        3-1 Quevedo

Round 4 [Dec 14]
Quevedo       0-0 Espoli
Olmedo        5-2 Calvi

Round 5 [Dec 17]
Olmedo        2-0 Quevedo
Calvi         0-3 Espoli

Round 6 [Dec 21]
Calvi         n/p Quevedo
Espoli        2-2 Olmedo

Table:

 1.Olmedo                  6  4  1  1  12- 5  13
 2.Espoli                  6  3  2  1   9- 5  11
 3.Deportivo Quevedo       5  1  2  2   3- 6   5
 4.Calvi                   5  0  1  4   3-11   1

Deportivo Quevedo and Calvi relegated.
Promoted: Delfín (Manta) and Panamá (Guayaquil).

Topscorers:

A.Graziani (Emelec)     24
V.Soria (Cuenca)        20 


Author:
 Mikael Jönsson
(mikael.joensson@tordata.se)

Last updated: 4 Aug 1999

(C) Copyright Mikael Jönsson and RSSSF 1999

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,352,120 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0019
Controller Execution Time ( Home / Category )  0.1187
Total Execution Time  0.1206
  CADENA URL  
/ecuador1997
  GET DATOS  
$_GET['/ecuador1997']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (37)  
0.0020  SELECT type FROM routes WHERE alias = 'ecuador1997'
0.0047  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 = 1997 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=1 DESC LIMIT 1
0.0021  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=43 AND type_rel = 3
0.0164  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.0039  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.0022  SELECT text_es as historical_text FROM leagues_text WHERE id=427
0.0024  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 = 28750 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0026  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.0020  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-04-26 19:38:05' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0020  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=2 AND last_update > '2024-04-26 19:38:05' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0021  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=4 AND last_update > '2024-04-26 19:38:05' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0019  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=3 AND last_update > '2024-04-26 19:38:05' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0028  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 = 1997 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=0 DESC LIMIT 1
0.0019  SELECT e.action, count(e.action) as total, e.player_id FROM events1997 e WHERE e.league_id IN (28750) AND (e.action IN (1,2,11,12,13) ) GROUP BY e.player_id ORDER BY total DESC, e.player_id ASC LIMIT 20
0.0018  SELECT dp.name, dp.last_name, dp.nick,dp.CountryCode,dp.alias,rp.team_id,dt.nameShow,dt.short_name,dt.basealias,rp.player_id,rp.teamId,dp.role FROM dataplayers AS dp INNER JOIN rel_players AS rp ON rp.player_id=dp.id AND rp.league_id IN (28750) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN () ORDER BY rp.in_squad = 1 DESC
0.0018  SELECT e.action, count(e.action) as total, e.player_id FROM events1997 e WHERE e.league_id IN (28750) 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 (28750) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN () ORDER BY rp.in_squad = 1 DESC
0.0018  SELECT e.action, count(e.action) as total, e.player_id FROM events1997 e WHERE e.league_id IN (28750) AND (e.action IN (3,4) ) 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 (28750) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN () ORDER BY rp.in_squad = 1 DESC
0.0024  SELECT e.action, count(e.action) as total, e.player_id FROM events1997 e WHERE e.league_id IN (28750) AND (e.action IN (22) ) 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 (28750) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN () ORDER BY rp.in_squad = 1 DESC
0.0018  SELECT rp.lineup as total,p.name, p.last_name, p.nick,p.CountryCode,p.alias,rp.team_id,dt.nameShow,dt.short_name,dt.basealias,rp.player_id,rp.teamId,p.role FROM `rel_players` rp INNER JOIN dataplayers p ON p.id = rp.player_id INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 28750 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 = 28750 AND rp.events > 0 ORDER BY rp.events DESC,p.pod DESC LIMIT 20
0.0023  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=28750 AND rel.round=10
0.0020  SELECT u.id,u.user_name, esl.points,up.name,up.surname,up.nick,u.changeA FROM editor_stats_leagues esl INNER JOIN fa_user u ON u.id = esl.user_id INNER JOIN fa_user_profile up ON up.id = esl.user_id WHERE esl.league_id = 28750 AND esl.points > 0 ORDER BY esl.points DESC LIMIT 3
0.0019  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 = 28750 AND esl.points > 0
0.0020  SELECT fau.user_name, c.*, NOW() as difference_time,creation_date FROM (leagues as l) INNER JOIN comments as c ON c.league_id = l.id LEFT JOIN fa_user fau ON fau.id = c.author_id WHERE c.creation_date > "2024-03-27" AND c.`active`= 1 and c.comment_id is null and c.lang = 1 AND l.`id` = 28750 ORDER BY creation_date DESC LIMIT 0, 10
0.0025  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` = 28750
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 `calendars1997` 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` = 28750 AND c.`round` = 10 ORDER BY shedule ASC LIMIT 200
0.0017  SELECT (dt1.qod+dt2.qod+dt1.relations+dt2.relations) as total,c.r1,c.r2,e.action,ev.showName as eventName,ev.largeName,ev.main_action,ev.keyname,ev.classf,e.real_date,e.minute, dp.nick,dp.CountryCode,dp.alias,c.datateam1,c.datateam2,dt1.nameShow as nameShow1,dt2.nameShow as nameShow2,dt1.basealias as basealias1,dt2.basealias as basealias2,e.player_id,e.match_id FROM `events1997` e INNER JOIN calendars1997 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 = 10 AND e.real_date IS NOT NULL AND e.league_id = 28750 ORDER BY total DESC LIMIT 40
0.0020  SELECT c.r1,c.r2,e.action,ev.showName as eventName,ev.largeName,ev.main_action,ev.keyname,ev.classf,e.real_date,e.minute, dp.nick,dp.CountryCode,dp.alias,c.datateam1,c.datateam2,dt1.nameShow as nameShow1,dt2.nameShow as nameShow2,dt1.basealias as basealias1,dt2.basealias as basealias2,e.player_id,e.match_id FROM `events1997` e INNER JOIN calendars1997 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 = 28750 AND e.real_date > NOW() - INTERVAL 1 MONTH ORDER BY e.real_date DESC LIMIT 30
0.0027  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 `tables1997` 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 = 28750 AND t.round = 8 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0027  SELECT *,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables1997` 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 = 28750 AND t.round = 10 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0027  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 = 28750 ORDER BY c.shedule ASC, fcoef DESC LIMIT 5
0.0027  SELECT data1, data2 FROM services_tags WHERE categoryId=43
0.0027  SELECT l.year,l.group_code FROM leagues_besoccer l WHERE l.categoryId = 43 AND l.year = 1997 ORDER BY l.group_code ASC
0.0027  SELECT group_code, extraName from `leagues` WHERE categoryId=43 AND year=1997