4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
« Temporada Anterior
Temporada 2004
Temporada Siguiente »
Publicidad 600x120.gif
Serie B - Ecuador 2004
2003/2004

Serie B - Ecuador 2004

Información Histórica 
						
Serie B

Torneo Apertura

Round 1
[Feb 20]
Audaz Octubrino       3-1 LDU de Portoviejo
[Feb 21]
Universidad Católica  1-1 LDU de Loja
Santa Rita            1-0 Técnico Universitario
Deportivo Saquisilí   1-1 Manta FC
Delfín                1-3 Deportivo Quevedo

Round 2
[Feb 28]
LDU de Loja           1-1 Santa Rita
[Feb 29]
Técnico Universitario 1-0 Deportivo Saquisilí
Manta FC              2-0 Audaz Octubrino
Deportivo Quevedo     3-1 Universidad Católica
LDU de Portoviejo     1-0 Delfín

Round 3
[Mar 6]
Universidad Católica  3-1 LDU de Portoviejo
Deportivo Saquisilí   5-1 Santa Rita
Delfín                0-1 Manta FC
Audaz Octubrino       1-1 Técnico Universitario
[Mar 7]
Deportivo Quevedo     1-1 LDU de Loja

Round 4
[Mar 13]
LDU de Loja           2-1 Deportivo Saquisilí
Manta FC              2-1 Universidad Católica
Santa Rita            1-1 Audaz Octubrino
LDU de Portoviejo     0-0 Deportivo Quevedo
[Mar 14]
Técnico Universitario 1-1 Delfín

Round 5 [Mar 24]
Deportivo Quevedo     2-1 Manta FC
Universidad Católica  0-1 Técnico Universitario
Delfín                3-3 Santa Rita
LDU de Portoviejo     3-0 LDU de Loja
Audaz Octubrino       2-1 Deportivo Saquisilí

Round 6
[Mar 19]
Técnico Universitario 0-2 Deportivo Quevedo
[Mar 20]
LDU de Loja           1-0 Audaz Octubrino
Santa Rita            1-1 Universidad Católica
Deportivo Saquisilí   2-0 Delfín
[Mar 21]
Manta FC              2-0 LDU de Portoviejo

Round 7 [Mar 28]
Universidad Católica  1-1 Deportivo Saquisilí
Manta FC              2-2 LDU de Loja
Deportivo Quevedo     0-0 Santa Rita
LDU de Portoviejo     1-1 Técnico Universitario
Audaz Octubrino       3-2 Delfín

Round 8
[Apr 3]
Santa Rita            0-0 LDU de Portoviejo
Deportivo Saquisilí   4-0 Deportivo Quevedo
Delfín                0-2 LDU de Loja
Audaz Octubrino       2-0 Universidad Católica
[Apr 4]
Técnico Universitario 1-0 Manta FC

Round 9
[Apr 10]
Universidad Católica  3-2 Delfín
LDU de Loja           1-0 Técnico Universitario
Manta FC              2-1 Santa Rita
[Apr 11]
Deportivo Quevedo     2-2 Audaz Octubrino
LDU de Portoviejo     1-1 Deportivo Saquisilí

Round 10
[Apr 17]
Santa Rita            1-0 Manta FC
Deportivo Saquisilí   1-3 LDU de Portoviejo
Técnico Universitario 2-1 LDU de Loja
Audaz Octubrino       0-1 Deportivo Quevedo
[Apr 18]
Delfín                1-0 Universidad Católica

Round 11
[Apr 24]
Universidad Católica  1-0 Audaz Octubrino
LDU de Loja           3-2 Delfín
LDU de Portoviejo     3-1 Santa Rita
[Apr 25]
Manta FC              1-2 Técnico Universitario
Deportivo Quevedo     1-1 Deportivo Saquisilí

Round 12
[Apr 30]
Delfín                2-1 Audaz Octubrino
Técnico Universitario 3-0 LDU de Portoviejo
[May 1]
LDU de Loja           2-0 Manta FC
Santa Rita            3-3 Deportivo Quevedo
Deportivo Saquisilí   2-1 Universidad Católica

Round 13
[May 8]
Universidad Católica  2-1 Santa Rita
Audaz Octubrino       1-2 LDU de Loja
LDU de Portoviejo     1-0 Manta FC
[May 9]
Deportivo Quevedo     1-0 Técnico Universitario
Delfín                6-3 Deportivo Saquisilí

Round 14 [May 12]
Deportivo Saquisilí   2-0 Audaz Octubrino
Santa Rita            2-0 Delfín
LDU de Loja           2-2 LDU de Portoviejo
Manta FC              2-1 Deportivo Quevedo
Técnico Universitario 1-0 Universidad Católica

Round 15 [May 16]
Universidad Católica  2-4 Manta FC
Delfín                1-0 Técnico Universitario
Deportivo Quevedo     2-0 LDU de Portoviejo
Deportivo Saquisilí   2-2 LDU de Loja
Audaz Octubrino       3-2 Santa Rita

Round 16
[May 21]
Técnico Universitario 1-0 Audaz Octubrino
[May 23]
LDU de Loja           2-3 Deportivo Quevedo
Manta FC              1-2 Delfín
LDU de Portoviejo     1-0 Universidad Católica
Santa Rita            5-1 Deportivo Saquisilí

Round 17 [May 29]
Universidad Católica  1-2 Deportivo Quevedo
Santa Rita            2-2 LDU de Loja
Deportivo Saquisilí   1-3 Técnico Universitario
Audaz Octubrino       0-0 Manta FC
Delfín                2-2 LDU de Portoviejo

Round 18 [Jun 6]
LDU de Portoviejo     3-2 Audaz Octubrino
LDU de Loja           2-0 Universidad Católica
Técnico Universitario 3-0 Santa Rita
Manta FC              2-0 Deportivo Saquisilí
Deportivo Quevedo     3-3 Delfín

Table:

 1. Deportivo Quevedo      18  9  7  2 30-22 34  Qualified
 2. LDU de Loja            18  8  7  3 29-23 31  Qualified
- - - - - - - - - - - - - - - - - - - - - - - -
 3. Técnico Universitario  18 10  3  5 21-12 27  [-6]
 4. Manta FC               18  8  3  7 23-19 27
 5. LDU de Portoviejo      18  7  6  5 23-23 27
 6. Deportivo Saquisilí    18  5  5  8 29-32 20
 7. Santa Rita             18  4  8  6 26-30 20
 8. Audaz Octubrino        18  5  4  9 21-25 19
- - - - - - - - - - - - - - - - - - - - - - - -
 9. Delfín                 18  5  4  9 28-34 19  No Descenso
10. Universidad Católica   18  4  3 11 18-28 15  No Descenso

NB: Técnico Universitario are deducted 6 points for using an ineligible
    played in round 8

Top 2 qualify to Liguilla final with 2, 1 bonus points
Bottom 2 qualify to Liguilla de no descenso with -1, -2 penalty points


Second Stage (Torneo Finalización)

Table:

 1. LDU de Loja            18 11  3  4 35-26 36  Qualified
 2. Técnico Universitario  18 10  5  3 31-14 35  Qualified
- - - - - - - - - - - - - - - - - - - - - - - -
 3. LDU de Portoviejo      18 10  3  5 28-20 33
 4. Deportivo Quevedo      18  9  3  6 30-22 30
 5. Universidad Católica   18  8  4  6 28-20 28
 6. Manta FC               18  6  4  8 20-19 22
 7. Santa Rita             18  5  5  8 15-22 20
 8. Delfín                 18  4  5  9 27-37 17
- - - - - - - - - - - - - - - - - - - - - - - -
 9. Audaz Octubrino        18  4  4 10 28-35 16  No Descenso
10. Deportivo Saquisilí    18  3  4 11 15-42 13  No Descenso

Top 2 qualify to Liguilla final with 2, 1 bonus points
Bottom 2 qualify to Liguilla de no descenso with -1, -2 penalty points

Round 1
[Jun 11]
Delfín                0-1 Deportivo Quevedo
[Jun 12]
Santa Rita            1-1 Audaz Octubrino
Deportivo Saquisilí   0-0 Universidad Católica
LDU de Portoviejo     3-1 LDU de Loja
[Jun 13]
Técnico Universitario 1-0 Manta FC

Round 2
[Jun 18]
Manta FC              3-0 Deportivo Saquisilí
[Jun 19]
Universidad Católica  4-0 Delfín
LDU de Loja           1-0 Santa Rita
Audaz Octubrino       1-1 Técnico Universitario
[Jun 20]
Deportivo Quevedo     0-1 LDU de Portoviejo

Round 3
[Jun 25]
Técnico Universitario 2-0 LDU de Loja
[Jun 26]
Santa Rita            0-1 Deportivo Quevedo
Delfín                6-0 Deportivo Saquisilí
Audaz Octubrino       1-2 Manta FC
LDU de Portoviejo     2-0 Universidad Católica

Round 4 [Jul 3]
Universidad Católica  4-0 Santa Rita
LDU de Loja           2-1 Manta FC
Deportivo Quevedo     2-1 Técnico Universitario
Deportivo Saquisilí   2-0 Audaz Octubrino
Delfín                1-3 LDU de Portoviejo

Round 5 [Jul 7]
Audaz Octubrino       2-3 LDU de Loja
Santa Rita            2-1 Delfín
Técnico Universitario 1-1 Universidad Católica
Manta FC              1-2 Deportivo Quevedo
LDU de Portoviejo     3-1 Deportivo Saquisilí

Round 6 [Jul 10]
Universidad Católica  2-0 Manta FC
Delfín                0-0 Técnico Universitario
Deportivo Quevedo     2-1 Audaz Octubrino
Deportivo Saquisilí   2-2 LDU de Loja
LDU de Portoviejo     1-0 Santa Rita

Round 7
[Jul 16]
Técnico Universitario 1-0 LDU de Portoviejo
[Jul 17]
LDU de Loja           3-0 Deportivo Quevedo
Santa Rita            2-0 Deportivo Saquisilí
Manta FC              1-0 Delfín
Audaz Octubrino       4-0 Universidad Católica

Round 8 [Jul 24]
Universidad Católica  2-1 LDU de Loja
Santa Rita            1-0 Técnico Universitario
Deportivo Saquisilí   1-0 Deportivo Quevedo
Delfín                2-0 Audaz Octubrino
LDU de Portoviejo     1-0 Manta FC

Round 9
[Jul 30]
Técnico Universitario 4-0 Deportivo Saquisilí
LDU de Loja           4-2 Delfín
[Jul 31]
Manta FC              1-0 Santa Rita
Audaz Octubrino       2-1 LDU de Portoviejo
[Aug 1]
Deportivo Quevedo     1-0 Universidad Católica

Round 10
[Aug 6]
Deportivo Saquisilí   0-1 Técnico Universitario
[Aug 7]
Universidad Católica  2-0 Deportivo Quevedo
Santa Rita            1-2 Manta FC
Delfín                3-1 LDU de Loja
LDU de Portoviejo     4-2 Audaz Octubrino

Round 11
[Aug 13]
LDU de Loja           2-0 Universidad Católica
[Aug 14]
Manta FC              0-0 LDU de Portoviejo
Deportivo Quevedo     7-1 Deportivo Saquisilí
Audaz Octubrino       1-1 Delfín
[Aug 15]
Técnico Universitario 3-0 Santa Rita

Round 12 [Aug 20]
Universidad Católica  3-2 Audaz Octubrino
Deportivo Quevedo     3-4 LDU de Loja
Deportivo Saquisilí   1-2 Santa Rita
Delfín                1-1 Manta FC
LDU de Portoviejo     0-0 Técnico Universitario

Round 13
[Aug 28]
LDU de Loja           1-1 Deportivo Saquisilí
Santa Rita            1-0 LDU de Portoviejo
Manta FC              1-1 Universidad Católica
Audaz Octubrino       2-2 Deportivo Quevedo
[Aug 29]
Técnico Universitario 5-0 Delfín

Round 14 [Sep 1]
Universidad Católica  1-2 Técnico Universitario
Deportivo Saquisilí   1-2 LDU de Portoviejo
Deportivo Quevedo     1-0 Manta FC
Delfín                2-2 Santa Rita
LDU de Loja           1-0 Audaz Octubrino

Round 15
[Sep 4]
Técnico Universitario 1-1 Deportivo Quevedo
LDU de Portoviejo     3-3 Delfín
[Sep 5]
Manta FC              0-1 LDU de Loja
Santa Rita            0-0 Universidad Católica
Audaz Octubrino       4-1 Deportivo Saquisilí

Round 16 [Sep 11]
Universidad Católica  3-0 LDU de Portoviejo
LDU de Loja           3-1 Técnico Universitario
Manta FC              5-1 Audaz Octubrino
Deportivo Quevedo     0-0 Santa Rita
Deportivo Saquisilí   2-1 Delfín

Round 17
[Sep 17]
Técnico Universitario 3-2 Audaz Octubrino
[Sep 18]
Santa Rita            2-2 LDU de Loja
Deportivo Saquisilí   0-0 Manta FC
LDU de Portoviejo     2-1 Deportivo Quevedo
[Sep 19]
Delfín                2-1 Universidad Católica

Round 18
[Sep 25]
Audaz Octubrino       2-1 Santa Rita
Universidad Católica  4-2 Deportivo Saquisilí
LDU de Loja           3-2 LDU de Portoviejo
Manta FC              2-4 Técnico Universitario
[Sep 26]
Deportivo Quevedo     6-2 Delfín
 
Table:

 1. LDU de Loja            18 11  3  4 35-26 36  Qualified
 2. Técnico Universitario  18 10  5  3 31-14 35  Qualified
- - - - - - - - - - - - - - - - - - - - - - - -
 3. LDU de Portoviejo      18 10  3  5 28-20 33
 4. Deportivo Quevedo      18  9  3  6 30-22 30
 5. Universidad Católica   18  8  4  6 28-20 28
 6. Manta FC               18  6  4  8 20-19 22
 7. Santa Rita             18  5  5  8 15-22 20
 8. Delfín                 18  4  5  9 27-37 17
- - - - - - - - - - - - - - - - - - - - - - - -
 9. Audaz Octubrino        18  4  4 10 28-35 16  No Descenso
10. Deportivo Saquisilí    18  3  4 11 15-42 13  No Descenso

Top 2 qualify to Liguilla final with 2, 1 bonus points
Bottom 2 qualify to Liguilla de no descenso with -1, -2 penalty points



Liguilla Final

Round 1 [Oct 2]
Técnico Universitario 2-0 Deportivo Quevedo
LDU de Portoviejo     2-2 LDU de Loja

Round 2 [Oct 9]
LDU de Loja           1-1 Técnico Universitario
Deportivo Quevedo     3-1 LDU de Portoviejo

Round 3 [Oct 15]
Deportivo Quevedo     4-1 LDU de Loja
LDU de Portoviejo     1-0 Técnico Universitario

Round 4
[Oct 23]
Técnico Universitario 2-0 LDU de Portoviejo
[Oct 24]
LDU de Loja           4-2 Deportivo Quevedo

Round 5 [Oct 30]
Técnico Universitario 1-1 LDU de Loja
LDU de Portoviejo     0-2 Deportivo Quevedo

Round 6 [Nov 7]
Deportivo Quevedo     0-0 Técnico Universitario
LDU de Loja           4-1 LDU de Portoviejo

Final Table:

 1.Deportivo Quevedo        6  3  1  2 11- 8 12 [2]  Champions
 2.LDU de Loja              6  2  3  1 13-11 12 [3]  Promoted
- - - - - - - - - - - - - - - - - - - - - - - - 
 3.Técnico Universitario    6  2  3  1  6- 3 10 [1]
 4.LDU de Portoviejo        6  1  1  4  5-13  4

[bonus points between square brackets]

Top 2 promoted to Serie A 2005


Liguilla de no descenso

Round 1 [Oct 2]
Universidad Católica  1-0 Delfín
Audaz Octubrino       1-0 Deportivo Saquisilí

Round 2 [Oct 9]
Deportivo Saquisilí   4-1 Universidad Católica
Delfín                3-1 Audaz Octubrino

Round 3 [Oct 15]
Universidad Católica  2-1 Audaz Octubrino
Delfín                3-0 Deportivo Saquisilí

Round 4 [Oct 23]
Audaz Octubrino       0-0 Universidad Católica
Deportivo Saquisilí   0-1 Delfín

Round 5 [Oct 30]
Universidad Católica  3-0 Deportivo Saquisilí
Audaz Octubrino       1-1 Delfín

Round 6 [Nov 6]
Deportivo Saquisilí   awd Audaz Octubrino      [awarded 2-0, Audaz dns]
Delfín                3-2 Universidad Católica

Final Table:

 1.Delfín                   6  4  1  1 11- 5 12 [-1]
 2.Universidad Católica     6  3  1  2  9- 8  8 [-2]
- - - - - - - - - - - - - - - - - - - - - - - - 
 3.Deportivo Saquisilí      6  2  0  4  6- 9  4 [-2]  Relegated
 4.Audaz Octubrino          6  1  2  3  4- 8  4 [-1]  Relegated

[penalty points between square brackets]

Bottom 2 relegated to Second Division 2005



Authors: Fernando Espinoza Añazco
(nanoespinoza@hotmail.com)
and Juan Pablo Andrés
(jpandres@tutopia.com)
Last updated: 16 Feb 2005

(C) Copyright Fernando Espinoza Añazco,
Juan Pablo Andrés and RSSSF
2004/05

INFORMACIÓN

La Primera Catergoría Serie B (Copa Credife Serie B según su nombre comercial) es el torneo oficial de fútbol de segunda división realizado en Ecuador. El campeonato es organizado anualmente por la Federación Ecuatoriana de Fútbol y formado de 2 etapas todos contra todos (ida y vuelta cada una, con 12 equipos), en la cual los 2 equipos con mayor sumatoria de puntos ascienden a la Serie A de 2012

  USO DE MEMORIA  
4,326,336 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0029
Controller Execution Time ( Home / Category )  0.0934
Total Execution Time  0.0963
  CADENA URL  
/segunda_ecuador2004
  GET DATOS  
$_GET['/segunda_ecuador2004']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (35)  
0.0017  SELECT type FROM routes WHERE alias = 'segunda_ecuador2004'
0.0037  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'segunda_ecuador' AND (l.group_code = 1 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 2004 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=2397
0.0019  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 = 30639 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0019  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='2004' WHERE c.parentId=190 GROUP BY c.id ORDER BY c.order_id ASC
0.0018  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-04-27 23:10:36' 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-27 23:10:36' 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-27 23:10:36' 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-27 23:10:36' 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 = 'segunda_ecuador' AND (l.group_code = 0 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 2004 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 events2004 e WHERE e.league_id IN (30639) 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 (30639) 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 events2004 e WHERE e.league_id IN (30639) AND (e.action IN (4,5) ) 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 (30639) 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 events2004 e WHERE e.league_id IN (30639) 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 (30639) 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 events2004 e WHERE e.league_id IN (30639) 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 (30639) 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 = 30639 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 = 30639 AND rp.events > 0 ORDER BY rp.events DESC,p.pod DESC LIMIT 20
0.0018  SELECT max(l.year) as max_year, min(l.year) as min_year FROM leagues l WHERE categoryID = 190 GROUP BY l.categoryId
0.0018  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=190 GROUP BY l.year ORDER BY l.year DESC
0.0021  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=30639 AND rel.round=18
0.0022  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 = 30639 AND esl.points > 0 ORDER BY esl.points DESC LIMIT 3
0.0020  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 = 30639 AND esl.points > 0
0.0019  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-29" AND c.`active`= 1 and c.comment_id is null and c.lang = 1 AND l.`id` = 30639 ORDER BY creation_date DESC LIMIT 0, 10
0.0024  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-29" AND c.`active`= 1 and comment_id is null and c.lang = 1 AND l.`id` = 30639
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 `calendars2004` 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` = 30639 AND c.`round` = 18 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 `events2004` e INNER JOIN calendars2004 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 = 30639 ORDER BY total DESC LIMIT 40
0.0022  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 `events2004` e INNER JOIN calendars2004 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 = 30639 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 `tables2004` 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 = 30639 AND t.round = 16 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0022  SELECT *,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables2004` 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 = 30639 AND t.round = 18 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0022  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-28 00:00:00' AND c.`shedule` < '2024-05-02 23:59:59' AND l.id = 30639 ORDER BY c.shedule ASC, fcoef DESC LIMIT 5
0.0022  SELECT data1, data2 FROM services_tags WHERE categoryId=190
0.0022  SELECT group_code, extraName from `leagues` WHERE categoryId=190 AND year=2004