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

Table:

 1.LD Alajuelense       32 21  5/ 2  4  72-29 75  (A) -> C
 2.Herediano            32 20  5/ 2  5  64-24 72  (A) -> D
 3.CD Saprissa          32 15  6/ 5  6  54-34 62  (B) -> C
 4.Cartaginés           32 16  4/ 6  6  42-29 62  (B) -> D
 5.AD Belén             32 10  5/ 8  9  32-28 48  (A) -> D
 6.Carmelita            32  9  5/ 6 12  31-36 43  (A) -> C
 7.Puntarenas           32  8  5/ 9 10  33-42 43  (B) -> D
 8.ADM Pérez Zeledón    32 10  5/ 2 15  43-46 42  (B) -> C
------------------------------------------------
 9.AD San Carlos        32  6  6/ 6 14  29-54 36  (A)
10.Goicoechea           32  6  5/ 4 17  29-55 32  (B)
11.Ramonense            32  6  4/ 5 17  31-61 31  (B)
12.Turrialba            32  5  5/ 5 17  32-54 30  (A)

Top-8 qualify for championship playoff.

Note: within both groups, each team played the others 4 times, while
      they played those of the other group only 2 times.

Round 1 [Sep 8]
Grupo A           
Carmelita     5-0 San Carlos   
Heredia       4-2 Turrialba  
Alajuela      1-2 Belen      
Grupo B
Perez Zeledon 5-0 Ramonense
Cartagines    1-0 Goicoechea
Saprissa      0-0 Puntarenas (Puntarenas on pen)

Round 2 [Sep 15]
Grupo A
Turrialba     1-2 Carmelita 
Alajuelense   4-0 San Carlos 
Herediano     1-1 Belen (Belen on pen)
Grupo B
Saprissa      1-0 Ramonense  [Sep 18]
Puntarenas    2-0 Cartagines 
Perez Zeledon 3-2 Goicoechea 

Round 3 [Sep 22]
Grupo B v A
Saprissa      1-0 Alajuelense
Puntarenas    1-1 Belen (Puntarenas on pen) [Belen on pen?]
Perez Zeledon 2-1 San Carlos 
Goicoechea    1-3 Herediano 
Cartagines    1-1 Turrialba (Turrialba 1-4 on pen)
Ramonense     0-3 Carmelita 

Round 4 [Sep 29]
Grupo A
Carmelita     1-0 Belen
Alajuelense   3-1 Herediano
San Carlos    2-0 Turrialba
Grupo B
Saprissa      3-0 Cartagines
Perez Zeledon 3-0 Puntarenas
Ramonense     3-1 Goicoechea

Round 5 [Oct 5,6]
Grupo A
Herediano     2-1 Carmelita
Belen         3-0 San Carlos
Alajuelense   6-1 Turrialba
Grupo B
Puntarenas    2-0 Ramonense
Cartagines    1-0 Perez Zeledon
Saprissa      3-1 Goicoechea

Round 6 [Oct 19,20]
Grupo A v B
Belen         1-1 Cartagines (Belen on pen)
San Carlos    1-1 Saprissa (San Carlos on pen)
Carmelita     3-0 Goicoechea
Herediano     7-0 Puntarenas
Alajuelense   7-2 Ramonense
Turrialba     2-0 Perez Zeledon

Round 7 [Oct 26,27]
Grupo A
Carmelita     0-0 Alajuelense (Alajuelense on pen)
San Carlos    0-0 Herediano (Herediano on pen)
Turrialba     2-1 Belen
Grupo B
Ramonense     1-2 Cartagines
Goicoechea    0-0 Puntarenas (Goicoechea on pen)
Perez Zeledon 2-2 Saprissa (Perez Zeledon on pen)

Round 8 [Nov 3,4]
Grupo A v B
Saprissa      2-0 Turrialba
Alajuelense   3-0 Goicoechea
Puntarenas    2-0 Carmelita
Cartagines    3-0 Herediano
Perez Zeledon 1-1 Belen (Perez Zeledon on pen)
Ramonense     1-1 San Carlos (Ramonense on pen)

Round 9 [Nov 10,11]
Grupo A
San Carlos    0-1 Carmelita
Belen         0-1 Alajuelense
Turrialba     1-1 Herediano (Herediano on pen)
Grupo B
Ramonense     2-1 Perez Zeledon
Goicoechea    1-1 Cartagines (Cartagines on pen)
Puntarenas    1-1 Saprissa (Saprissa on pen)

Round 10 [Nov 24,27]
Grupo A
Carmelita     0-0 Turrialba (Turrialba on pen)
Belen         0-1 Herediano 
Alajuelense   2-0 San Carlos
Grupo B
Perez Zeledon 3-4 Goicoechea
Ramonense     4-2 Saprissa      [Nov 29]
Cartagines    1-0 Puntarenas    [Dec 4]

Round 11 [Dec 7,8]
Grupo A v B
Alajuelense   2-0 Puntarenas
Herediano     1-0 Perez Zeledon
Carmelita     0-0 Cartegines (Carmelita 6-5 pen)
Ramonense     2-1 Turrialba
Saprissa      2-2 Belen (Saprissa 4-2 pen)
Goicoechea    3-2 San Carlos

Round 12 [Dec 28,29]
Grupo A
Herediano     3-1 Alajuela
Turrialba     0-0 San Carlos (San Carlos 7-6 pen)
Belen         0-0 Carmelita (Carmelita 5-4 pen)
Grupo B
Cartagines    1-1 Saprissa (Saprissa on pen)
Goicoechea    3-1 Ramonense
Puntarenas    2-1 Perez Zeledon

Round 13 [Jan 3,4]
Grupo A
Carmelita     0-2 Herediano
San Carlos    1-1 Belen (Belen on pen)
Turrialba     1-2 Alajuela [Jan 15]
Grupo B
Perez Zeledon 1-1 Cartagines (Cartagines 6-5 pen)
Ramonense     2-0 Puntarenas
Goicoechea    0-2 Saprissa

Round 14 [Jan 8]
Grupo B v A
Belen         2-1 Ramonense
Goicoechea    0-0 Turrialba (Turrialba 13-12 pen)
Puntarenas    3-1 San Carlos
Perez Zeledon 3-1 Carmelita
Saprissa      3-1 Herediano [Jan 15]
Cartagines    1-1 Alajuela (Alajuela on pen) [Jan 29]

Round 15 [Jan 10,11]
Grupo A
Herediano     5-0 San Carlos
Belen         2-0 Turrialba 
Alajuelense   3-0 Carmelita 
Grupo B
Saprissa      2-2 Perez Zeledon (Perez Zeledon 4-3 pen)
Cartagines    2-1 Ramonense 
Puntarenas    3-1 Goicoechea

Round 16 [Jan 17,18]
Grupo A v B
Carmelita     1-1 Saprissa (Saprissa on pen)
Alajuelense   2-0 Perez Zeledon
Cartagines    2-1 San Carlos
Belen         2-1 Goicoechea
Turrialba     2-1 Puntarenas
Herediano     2-0 Ramonense

Round 17 [Jan 22]
Grupo A
Alajuelense   0-0 Belen (Belen on pen)
Carmelita     2-2 San Carlos (San Carlos 4-3 pen)
Herediano     1-1 Turrialba (Herediano 7-6 pen)
Grupo B
Saprissa      3-1 Puntarenas
Cartagines    0-0 Goicoechea (Cartagines 4-2 pen)
Perez Zeledon 2-1 Ramonense

Round 18 [Jan 24,25]
Grupo A
San Carlos    3-3 Alajuelense (Alajuelense 4-5 pen)
Turrialba     1-2 Carmelita
Belen         1-1 Herediano (Herediano on pen)
Grupo B
Puntarenas    0-0 Cartagines (Cartagines on pen)
Ramonense     0-0 Saprissa (Saprissa on pen)
Goicoechea    1-2 Perez Zeledon

Round 19 [Feb 1,2]
Grupo A v B
Alajuelense   2-1 Saprissa
Herediano     1-0 Goicoechea
Turrialba     0-1 Cartagines
San Carlos    2-0 Perez Zeledon
Belen         1-1 Puntarenas (Puntarenas on pen)
Ramonense     1-0 Carmelita

Round 20 [Feb 8,9]
Grupo A
San Carlos    2-1 Turrialba
Carmelita     1-0 Belen
Alajuelense   2-1 Herediano
Grupo B
Perez Zeledon 1-0 Puntarenas
Ramonense     0-1 Goicoechea
Saprissa      0-2 Cartagines

Round 21 [Feb 12]
Grupo A
Alajuelense   5-1 Turrialba
Herediano     2-0 Carmelita
Belen         2-1 San Carlos
Grupo B
Saprissa      4-0 Goicoechea
Cartagines    1-0 Perez Zeledon
Ramonense     0-0 Puntarenas (Ramonense on pen)

Round 22 [Feb 15,16]
Grupo B v A
Perez Zeledon 3-2 Turrialba
Cartagines    1-0 Belen
Puntarenas    0-2 Herediano
Goicoechea    1-1 Carmelita (Goicoechea on pen)
Ramonense     1-3 Alajuelense
Saprissa      2-1 San Carlos

Round 23 [Feb 22,23]
Grupo A
Carmelita     0-3 Alajuelense
San Carlos    0-0 Herediano (Herediano on pen)
Turrialba     1-2 Belen   [Mar 12]
Grupo B
Perez Zeledon 0-2 Saprissa
Ramonense     1-1 Cartagines (Ramonense on pen)
Goicoechea    1-1 Puntarenas (Goicoechea on pen)

Round 24 [Feb 26,27]
Grupo A v B
Alajuelense   3-1 Goicoechea
Herediano     2-0 Cartagines
San Carlos    1-1 Ramonense (San Carlos 4-3 on pen)
Carmelita     1-1 Puntarenas (Carmelita on pen)
Perez Zeledon 1-0 Belen
Turrialba     2-1 Saprissa

Round 25 [Mar 1,2]
Grupo A
Belen         0-0 Alajuelense (Alajuelense 15-14 on pen)
Turrialba     1-1 Herediano (Turrialba on pen)
San Carlos    2-1 Carmelita
Grupo B
Ramonense     1-1 Perez Zeledon (Perez Zeledon 6-5 on pen)
Puntarenas    2-2 Saprissa (Puntarenas on pen)
Goicoechea    0-3 Cartagines

Round 26 [Mar 5]
Grupo A
Alajuelense   1-1 San Carlos (Alajuelense on pen)
Herediano     3-0 Belen
Carmelita     2-2 Turrialba (Carmelita on pen)
Grupo B
Cartagines    2-3 Puntarenas
Saprissa      2-2 Ramonense (Saprissa on pen)
Perez Zeledon 0-1 Goicoechea (Mar 7)

Round 27 [Mar 26]
Grupo B v A
Puntarenas    2-2 Alajuelense (Puntarenas 10-9 pen)
Perez Zeledon 1-2 Herediano
Cartagines    1-0 Carmelita
Saprissa      2-0 Belen
Turrialba     2-1 Ramonense
Goicoechea    0-1 San Carlos

Round 28 [Mar 30]
Grupo A
Herediano     3-1 Alajuelense
Turrialba     1-1 San Carlos (San Carlos 4-3 pen)
Belen         0-0 Carmelita (Belen 5-4 pen)              [1-1?]
Grupo B
Cartagines    1-2 Saprissa
Goicoechea    1-1 Ramonense (Goicoechea 5-3 pen)
Puntarenas    2-2 Perez Zeledon (Perez Zeledon 8-7 pen)

Round 29 [Apr 1,2]
Grupo A
Carmelita     1-0 Herediano
Turrialba     0-1 Alajuelense
San Carlos    0-0 Belen (San Carlos 3-1 pen)
Grupo B
Goicoechea    1-0 Saprissa
Perez Zeledon 1-2 Cartagines
Ramonense     1-1 Puntarenas (Ramonense 5-4 pen)

Round 30 [Apr 6]
Grupo A v B
Herediano     2-0 Saprissa
Carmelita     1-1 Perez Zeledon (Carmelita 4-3 pen)
Alajuelense   5-3 Cartagines
San Carlos    1-0 Puntarenas
Turrialba     2-2 Goicoechea (Turrialba 3-2 pen)
Ramonense     0-3 Belen

Round 31 [Apr 9]
Grupo A
Alajuelense   2-0 Carmelita
Belen         2-1 Turrialba
Herediano     5-0 San Carlos
Grupo B
Saprissa      3-1 Perez Zeledon
Cartagines    4-0 Ramonense
Puntarenas    1-1 Goicoechea (Goicoechea 7-6 pen)

Round 32 [Apr 13]
Grupo B v A
Saprissa      3-1 Carmelita
Perez Zeledon 0-1 Alajuelense
San Carlos    1-2 Cartagines
Herediano     4-0 Ramonense
Puntarenas    1-0 Turrialba
Goicoechea    0-2 Belen

Table:

 1.LD Alajuelense       32 21  5/ 2  4  72-29 75  (A) -> C
 2.Herediano            32 20  5/ 2  5  64-24 72  (A) -> D
 3.CD Saprissa          32 15  6/ 5  6  54-34 62  (B) -> C
 4.Cartaginés           32 16  4/ 6  6  42-29 62  (B) -> D
 5.AD Belén             32 10  5/ 8  9  32-28 48  (A) -> D
 6.Carmelita            32  9  5/ 6 12  31-36 43  (A) -> C
 7.Puntarenas           32  8  5/ 9 10  33-42 43  (B) -> D
 8.ADM Pérez Zeledón    32 10  5/ 2 15  43-46 42  (B) -> C
------------------------------------------------
 9.AD San Carlos        32  6  6/ 6 14  29-54 36  (A)
10.Goicoechea           32  6  5/ 4 17  29-55 32  (B)
11.Ramonense            32  6  4/ 5 17  31-61 31  (B)
12.Turrialba            32  5  5/ 5 17  32-54 30  (A)

Alajuelense win first stage.
Top-8 qualify for second stage.

Note: within both groups, each team played the others 4 times, while
      they played those of the other group only 2 times.


Second Stage
============

Tables:

Group C
 1.LD Alajuelense        6  4  0/ 0  2   6- 2 12
 2.CD Saprissa           6  3  0/ 1  2   5- 4 10
 3.ADM Pérez Zeledón     6  2  2/ 0  2   6- 5 10
 4.Carmelita             6  1  0/ 1  4   2- 8  4

Group D
 1.Cartaginés            6  3  1/ 1  1   8- 6 12
 2.Herediano             6  3  0/ 1  2   9- 4 10
 3.AD Belén              6  1  2/ 2  1   8- 9  9
 4.Puntarenas            6  1  1/ 0  4   5-11  5

Round 1 [May 14]
Grupo C
Carmelita     1-0 Saprissa
Perez Zeledon 0-1 Alajuelense
Grupo D
Belen         1-1 Cartagines (Belen 3-2 pen)
Puntarenas    1-0 Herediano

Round 2 [May 18]
Grupo C
Saprissa      2-2 Perez Zeledon (Perez Zeledon 7-6 pen)
Alajuelense   3-0 Carmelita
Grupo D
Cartagines    2-0 Puntarenas
Herediano     3-0 Belen

Round 3 [May 21]
Grupo C
Alajuelense   1-0 Saprissa
Perez Zeledon 1-1 Carmelita (Perez Zeledon 4-3 pen)
Grupo D
Herediano     2-0 Cartagines
Puntarenas    1-1 Belen (Puntarenas 4-1 pen)

Round 4 [May 25]
Grupo C
Saprissa      1-0 Alajuelense
Carmelita     0-2 Perez Zeledon
Grupo D
Cartagines    2-1 Herediano
Belen         4-2 Puntarenas

Round 5 [Jun 4]
Grupo C
Perez Zeledon 0-1 Saprissa
Carmelita     0-1 Alajuelense
Grupo D
Belen         1-1 Herediano (Belen 4-3 pen)
Puntarenas    1-2 Cartagines

Round 6 [Jun 9]
Grupo C
Saprissa      1-0 Carmelita
Perez Zeledon 1-0 Alajuelense
Grupo D
Cartagines    1-1 Belen (Cartagines 4-2 on pen)
Herediano     2-0 Puntarenas

Tables:

Group C
 1.LD Alajuelense        6  4  0/ 0  2   6- 2 12
 2.CD Saprissa           6  3  0/ 1  2   5- 4 10
 3.ADM Pérez Zeledón     6  2  2/ 0  2   6- 5 10
 4.Carmelita             6  1  0/ 1  4   2- 8  4

Group D
 1.Cartaginés            6  3  1/ 1  1   8- 6 12
 2.Herediano             6  3  0/ 1  2   9- 4 10
 3.AD Belén              6  1  2/ 2  1   8- 9  9
 4.Puntarenas            6  1  1/ 0  4   5-11  5

Semifinals [after Copa America]:

First Leg [Jun 22]
Cartagines     1-0 Saprissa
  [11' Jewisson Bennett]

Second Leg [Jun 25]
Saprissa       2-0 Cartagines

First Leg [Jun 25]
Herediano      1-1 Alajuelense

Second Leg [Jun 29]
Alajuelense    3-1 Herediano


Final:

First Leg [Jul 2]
Saprissa       3-1 Alajuelense
  [46' Mahia, 57' Mahia, 70' Drummond; 37' Badilla]

Second Leg [Jul 6]
Alajuelense    1-0 Saprissa
  [8' Mullins]

Saprissa win second stage.


Championship Playoff
====================

First Leg [Jul 13]
Saprissa       2-3 Alajuelense
  [2' Mahia, 6' Drummond; 14' Miso, 17' and 27' Mullins]

Second Leg [Jul 16]
Alajuelense    1-1 Saprissa
  [20' Miso; 31' Mahia]

Alajuelense 1996/97 Costa Rica champions.



Author: RSSSF

Last updated: 26 Sep 2002

(C) Copyright RSSSF 1999/2002

INFORMACIÓN

El campeonato de Invierno representa el máximo torneo de clubes en Costa Rica. El campeonato está integrado por 12 equipos. El campeonato comienza en agosto y termina en diciembre, cada equipo en temporada regular juega 16 partidos y los primeros dos lugares de cada grupo avanzan a la siguiente ronda, los primeros dos de cada grupo clasifican mientras que el tercero y cuarto clasificaran conforme estén ubicados en la tabla general.

  USO DE MEMORIA  
4,341,488 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0019
Controller Execution Time ( Home / Category )  0.4506
Total Execution Time  0.4526
  CADENA URL  
/invierno_costa_rica1997
  GET DATOS  
$_GET['/invierno_costa_rica1997']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (34)  
0.0106  SELECT type FROM routes WHERE alias = 'invierno_costa_rica1997'
0.0223  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'invierno_costa_rica' 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.0109  SELECT text_es as historical_text FROM leagues_text WHERE id=325
0.0105  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 = 28639 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0107  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='1997' WHERE c.parentId=147 GROUP BY c.id ORDER BY c.order_id ASC
0.0105  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-04-20 04:25:40' 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-04-20 04:25:40' 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-04-20 04:25:40' 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=3 AND last_update > '2024-04-20 04:25:40' 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 = 'invierno_costa_rica' 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.0105  SELECT e.action, count(e.action) as total, e.player_id FROM events1997 e WHERE e.league_id IN (28639) 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.0105  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 (28639) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN () ORDER BY rp.in_squad = 1 DESC
0.0105  SELECT e.action, count(e.action) as total, e.player_id FROM events1997 e WHERE e.league_id IN (28639) AND (e.action IN (4,5) ) GROUP BY e.player_id ORDER BY total DESC, e.player_id ASC LIMIT 20
0.0105  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 (28639) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN () ORDER BY rp.in_squad = 1 DESC
0.0106  SELECT e.action, count(e.action) as total, e.player_id FROM events1997 e WHERE e.league_id IN (28639) AND (e.action IN (3,4) ) GROUP BY e.player_id ORDER BY total DESC, e.player_id ASC LIMIT 20
0.0105  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 (28639) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN () ORDER BY rp.in_squad = 1 DESC
0.0106  SELECT e.action, count(e.action) as total, e.player_id FROM events1997 e WHERE e.league_id IN (28639) AND (e.action IN (22) ) GROUP BY e.player_id ORDER BY total DESC, e.player_id ASC LIMIT 20
0.0106  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 (28639) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN () ORDER BY rp.in_squad = 1 DESC
0.0105  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 = 28639 AND rp.lineup > 0 ORDER BY rp.lineup DESC,p.pod DESC LIMIT 20
0.0105  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 = 28639 AND rp.events > 0 ORDER BY rp.events DESC,p.pod DESC LIMIT 20
0.0108  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=28639 AND rel.round=32
0.0107  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 = 28639 AND esl.points > 0 ORDER BY esl.points DESC LIMIT 3
0.0106  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 = 28639 AND esl.points > 0
0.0106  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-21" AND c.`active`= 1 and c.comment_id is null and c.lang = 1 AND l.`id` = 28639 ORDER BY creation_date DESC LIMIT 0, 10
0.0110  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-21" AND c.`active`= 1 and comment_id is null and c.lang = 1 AND l.`id` = 28639
0.0107  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` = 28639 AND c.`round` = 32 ORDER BY shedule ASC LIMIT 200
0.0105  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 = 32 AND e.real_date IS NOT NULL AND e.league_id = 28639 ORDER BY total DESC LIMIT 40
0.0107  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 = 28639 AND e.real_date > NOW() - INTERVAL 1 MONTH ORDER BY e.real_date DESC LIMIT 30
0.0107  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 = 28639 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0107  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 = 28639 AND t.round = 32 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0107  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-20 00:00:00' AND c.`shedule` < '2024-04-24 23:59:59' AND l.id = 28639 ORDER BY c.shedule ASC, fcoef DESC LIMIT 5
0.0107  SELECT data1, data2 FROM services_tags WHERE categoryId=147
0.0107  SELECT l.year,l.group_code FROM leagues_besoccer l WHERE l.categoryId = 147 AND l.year = 1997 ORDER BY l.group_code ASC
0.0107  SELECT group_code, extraName from `leagues` WHERE categoryId=147 AND year=1997