4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Publicidad 600x120.gif
Primera División Cuba 2000
1999/2000

Primera División Cuba 2000

Información Histórica
						

Championship will played in 4 groups; 8 teams will reach the final
round (Octogonal).  The championship final will be played January 2000.

Points system: after draws a penalty shootout follows for an extra point
(so 3-2-1-0).

Tables:

Grupo A
 1.Ciudad La Habana       14  11  1/ 1  1 32- 6 36   [CHA]  Qualified
 2.Pinar del Río          14   6  3/ 0  5 16-14 24   [PRI]  Qualified
 - - - - - - - - - - - - - - - - - - - - - - - - -
 3.Provincia La Habana    14   4  2/ 1  7 17-22 17   [LHA]
 4.Isla de la Juventud    14   0  1/ 2 11  8-47  4   [IJU]
  
Grupo B
 1.Villa Clara            14   9  1/ 1  3 36-12 30   [VCL]  Qualified
 2.Matanzas               14   6  1/ 1  6 18-18 21   [MTZ]  Qualified
 - - - - - - - - - - - - - - - - - - - - - - - - -
 3.Cienfuegos             14   4  2/ 3  5 15-21 19   [CFG]
 4.Industriales La Habana 14   4  1/ 3  6 10-12 17   [IND]

Grupo C
 1.Camagüey               13   7  3/ 2  1 16- 8 29   [CMG]  Qualified 
 2.Ciego de Avila         14   8  1/ 1  4 25-10 27   [CAV]  Qualified 
 - - - - - - - - - - - - - - - - - - - - - - - - -
 3.Sancti Spíritus        14   6  3/ 1  4 17-15 25   [SSP]
 4.Las Tunas              14   5  1/ 1  7 19-23 18   [LTU]         

Grupo D
 1.Santiago de Cuba       13   5  1/ 2  5 12- 9 19   [SCU]  Qualified
 2.Holguín                14   5  1/ 2  6 18-20 19   [HOL]  Qualified
 - - - - - - - - - - - - - - - - - - - - - - - - -
 3.Granma                 14   4  2/ 1  7 10-17 17   [GRM]     
 4.Guantánamo             14   3  0/ 2  9 10-25 11   [GTM]       

NB: Camagüey vs Santiago de Cuba not played.

NB: apart from Industriales all teams are provincial selections; e.g.,
    Provincia La Habana consists of players from Bauta and Batabanó.

Round 1 [Aug 15]
Grupo A
Ciudad          1-0     Pinar del Río
Provincia       2-0     Isla de la Juventud
Grupo B  
Industriales    0-0     Matanzas        [3-1 on pen]
Cienfuegos      1-1     Villa Clara     [4-2 on pen]
Grupo C
Sancti Spíritus 3-2     Las Tunas
Ciego de Avila  2-0     Camagüey
Grupo D
Holguín         0-0     Santiago        [3-2 on pen]
Granma          0-0     Guantánamo      [5-3 on pen]

Round 2 [Aug 19,20]
Grupo A
Ciudad          1-0     Provincia
Pinar del Río   3-1     Isla de la Juventud
Grupo B
Villa Clara     2-1     Matanzas
Industriales    1-1     Cienfuegos      [4-5 on pen]
Grupo C
Ciego de Avila  3-0     Las Tunas
Sancti Spiritus 0-0     Camagüey        [4-3 on pen]
Grupo D
Santiago de Cba 3-0     Guantánamo
Holguín         1-1     Granma          [3-4 on pen]

Round 3 [Aug 22]
Grupo A 
Ciudad          8-0     Isla de la Juventud
Pinar del Río   1-1     Provincia       [5-3 on pen]
Grupo B 
Villa Clara     4-0     Industriales
Matanzas        1-1     Cienfuegos      [3-1 on pen]
Grupo C
Sancti Spiritus 1-0     Ciego de Avila
Camaguey        2-1     Las Tunas  
Grupo D
Guantánamo      4-2     Holguín
Santiago        2-1     Granma

Round 4  [Aug 25]
[Grupo A vs Grupo B]
Ciudad          2-0     Industriales
Villa Clara     5-1     Provincia
Pinar del Río   0-0     Cienfuegos      [3-2 on pen]
Matanzas        2-0     Isla de la Juventud
[Grupo C vs Grupo D]
Sancti Spiritus 1-2     Granma
Ciego de Avila  6-2     Holguín
Camaguey        2-1     Santiago
Las Tunas       1-0     Guantánamo

Round 5 [Aug 29]
[Grupo A vs Grupo B]
Pinar del Río   1-0     Cienfuegos 
Ciudad          0-0     Industriales    [3-2 on pen]
Matanzas        5-2     Isla de la Juventud
Villa Clara     3-1     Provincia
[Grupo C vs Grupo D]
Camaguey        n/p     Santiago
Granma          1-3     Sancti Spiritus
Las Tunas       4-1     Guantánamo
Holguín         3-1     Ciego de Avila

Round 6 [Sep 5]        
[Grupo A vs Grupo B]
Cienfuegos      1-0     Ciudad
Villa Clara     2-1     Pinar del Río
Provincia       2-0     Matanzas   
Industriales    2-0     Isla de la Juventud
[Grupo C vs Grupo D]
Camaguey        1-0     Guantánamo
Santiago        2-1     Las Tunas
Sancti Spiritus 1-0     Holguín  
Ciego de Avila  2-0     Granma  

Round 7 [Sep 8]
[Grupo A vs Grupo B]
Ciudad          2-1     Cienfuegos
Matanzas        2-1     Provincia
Industriales    2-0     Isla de la Juventud
Villa Clara     3-1     Pinar del Río
[Grupo C vs Grupo D]
Camaguey        2-0     Guantánamo
Holguín         2-1     Sancti Spiritus
Las Tunas       0-0     Santiago        [5-6 on pen]
Granma          1-0     Ciego de Avila

Round 8 [Sep 15]
[Grupo A vs Grupo B]
Provincia       2-0     Cienfuegos  
Pinar del Río   1-0     Industriales
Villa Clara     5-0     Isla de la Juventud
Ciudad          2-1     Matanzas
[Grupo C vs Grupo D]
Ciego de Avila  1-0     Santiago de Cuba
Granma          3-1     Las Tunas
Sancti Spíritus 1-1     Guantánamo      [4-3 on pen]   
Camaguey        0-0     Holguín         [3-1 on pen]

Round 9 [Sep 19]
[Grupo A vs Grupo B]
Provincia       4-2     Cienfuegos
Pinar del Río   2-0     Industriales
Ciudad          2-0     Matanzas 
Villa Clara     7-0     Isla de la Juventud
[Grupo C vs Grupo D]
Las Tunas       1-0     Granma
Ciego de Avila  1-0     Santiago de Cuba
Sancti Spíritus 2-0     Guantánamo   
Camagüey        1-0     Holguín  

Round 10 [Sep 26]
[Grupo A vs Grupo B]
Industriales    3-0     Provincia                      [Campo Armada field]
Cienfuegos      3-2     Isla de la Juventud            [Pérez Lozano field]
Ciudad          1-1     Villa Clara     [2-4 on pen]   [Zulueta field]
Matanzas        0-4     Pinar del Río                  [Jagüey field]
[Grupo C vs Grupo D]
Santiago        1-1     Sancti Spíritus [4-2 on pen]   [Los Reinaldos field]
Granma          2-0     Camagüey                       [Jiguaní field]
Las Tunas       1-4     Holguín                        [Feliú Leyva field]
Ciego de Avila  2-3     Guantánamo                     [Rogelio Palacio field]

Round 11 [ca. Sep 30]
[Grupo A vs Grupo B]
Provincia       0-0     Industriales    [3-1 on pen]
Isla Juventud   1-1     Cienfuegos      [5-4 on pen]
Villa Clara     0-1     Ciudad   
Pinar del Río   0-1     Matanzas   
[Grupo C vs Grupo D]
Sancti Spíritus 1-0     Santiago    
Camagüey        1-1     Granma          [4-3 on pen]      
Las Tunas       1-0     Holguín     
Ciego de Avila  5-0     Guantánamo       

Round 12 [Oct 3]
Grupo A
Ciudad          4-0     Pinar del Río
Provincia       1-1     Isla de la Juv. [3-5 on pen]
Grupo B
Industriales    2-0     Matanzas  
Cienfuegos      3-2     Villa Clara   
Grupo C
Sancti Spíritus 1-3     Las Tunas
Ciego de Avila  0-0     Camagüey        [3-2 on pen]
Grupo D
Holguín         0-2     Santiago  
Granma          1-0     Guantánamo

Round 13 [Oct 6]
Grupo A
Ciudad          3-2     Provincia
Pinar del Río   1-1     Isla de la Juv. [3-2 on pen]
Grupo B
Villa Clara     0-1     Matanzas
Industriales    0-1     Cienfuegos  
Grupo C
Ciego de Avila  0-0     Las Tunas       [3-5 on pen]
Sancti Spiritus 1-1     Camagüey        [4-5 on pen] 
Grupo D
Santiago de Cba 1-0     Guantánamo
Holguín         3-0     Granma    

Round 14 [Oct 13] 
Grupo A
Ciudad          5-0     Isla de la Juventud
Pinar del Río   1-0     Provincia   
Grupo B
Villa Clara     1-0     Industriales
Matanzas        4-0     Cienfuegos   
Grupo C
Sancti Spiritus 0-2     Ciego de Avila
Camaguey        2-2     Las Tunas       [3-1 on pen]
Grupo D
Guantánamo      0-1     Holguín
Santiago        1-0     Granma

Tables: 

Grupo A
 1.Ciudad La Habana       14  11  1/ 1  1 32- 6 36   [CHA]  Qualified
 2.Pinar del Río          14   6  3/ 0  5 16-14 24   [PRI]  Qualified
 - - - - - - - - - - - - - - - - - - - - - - - - -
 3.Provincia La Habana    14   4  2/ 1  7 17-22 17   [LHA]
 4.Isla de la Juventud    14   0  1/ 2 11  8-47  4   [IJU]
 
Grupo B
 1.Villa Clara            14   9  1/ 1  3 36-12 30   [VCL]  Qualified
 2.Matanzas               14   6  1/ 1  6 18-18 21   [MTZ]  Qualified
 - - - - - - - - - - - - - - - - - - - - - - - - -
 3.Cienfuegos             14   4  2/ 3  5 15-21 19   [CFG]
 4.Industriales La Habana 14   4  1/ 3  6 10-12 17   [IND]

Grupo C
 1.Camagüey               13   7  3/ 2  1 16- 8 29   [CMG]  Qualified 
 2.Ciego de Avila         14   8  1/ 1  4 25-10 27   [CAV]  Qualified  
 - - - - - - - - - - - - - - - - - - - - - - - - -
 3.Sancti Spíritus        14   6  3/ 1  4 17-15 25   [SSP]
 4.Las Tunas              14   5  1/ 1  7 19-23 18   [LTU]

Grupo D
 1.Santiago de Cuba       13   5  1/ 2  5 12- 9 19   [SCU]  Qualified
 2.Holguín                14   5  1/ 2  6 18-20 19   [HOL]  Qualified
 - - - - - - - - - - - - - - - - - - - - - - - - -
 3.Granma                 14   4  2/ 1  7 10-17 17   [GRM]      
 4.Guantánamo             14   3  0/ 2  9 10-25 11   [GTM]        

NB: Camagüey vs Santiago de Cuba not played.

NB: apart from Industriales all teams are provincial selections; e.g.,
    Provincia La Habana consists of players from Bauta and Batabanó.


Octogonal (Cuartos de Finales)

Table:

 1.Ciudad La Habana       14  10  1/ 2  1 29-13 34  ['Los Magníficos']
 2.Camagüey               14   4  5/ 3  2  8-10 25  
 3.Pinar del Río          14   6  2/ 2  4 15- 9 24  
 4.Holguín                14   5  3/ 3  3 12- 9 24 
 - - - - - - - - - - - - - - - - - - - - - - - - -
 5.Villa Clara            14   7  0/ 2  5 22- 9 23  ['El Expreso del Centro'] 
 6.Ciego de Avila         14   3  5/ 0  6 20-16 19  
 7.Santiago de Cuba       14   4  0/ 2  8 14-24 14  
 8.Matanzas               14   1  0/ 2 11  5-35  5  

Round 1 [Oct 20]
Santiago        1-3     Ciudad   
Holguín         0-1     Pinar del Río  
Villa Clara     0-0     Camagüey          [Camagüey on pen]     
Ciego de Avila  5-0     Matanzas   

Round 2 [?]
Holguín         0-2     Ciudad La Habana
Santiago        awd     Pinar del Río     [awarded 0-5 due to bad pitch Santiago]
Ciego de Avila  0-1     Villa Clara
Camagüey        1-0     Matanzas

Round 3 [Oct 27]
Ciudad          0-0     Camagüey          [4-3 pen]
Pinar del Río   1-0     Ciego de Avila
  [Carlos Torres]
Villa Clara     2-0     Santiago de Cuba
  [Rudy Lay 23', Ariel Alvarez 49']
Matanzas        0-2     Holguín
  [Oliver Matos 31', Alexander Cruzata 80']

Round 4 [Oct 31]
Ciudad          2-0     Ciego de Avila
Pinar del Río   0-0     Camagüey          [Camagüey on pen]
Villa Clara     1-2     Holguín
Matanzas        0-1     Santiago de Cuba

Round 5
Santiago        0-1     Camagüey       
  [Armando Cruz 41']
Holguín         0-0     Ciego de Avila    [4-5 pen]
Ciudad          2-5     Villa Clara
Matanzas        awd     Pinar del Río     [awarded 0-3 as Matanzas didn't provide
                                           transportation to the venue for Pinar
                                           in time]
Round 6 [Nov 11]
Matanzas        1-2     Ciudad La Habana
  [Yordani Tierbe 75'; Gustavo Rivero 23' and 70']
Villa Clara     1-2     Pinar del Río 
  [Serguei Prado; Osmay Delgado 21' and 44']
Ciego de Avila  3-3     Santiago de Cuba  [4-3 pen]
  [Raúl Herrera, Liván Pérez, Tobio Mora; Luis Martén (2), Roberto Castellanos]
Camagüey        0-0     Holguín           [Holguín on pen]

Round 7
Ciudad          2-0     Pinar del Río 
  [Alberto Delgado 65', Andrés Roldán 80']
Ciego de Avila  4-1     Camagüey
  [Luis Hildalgo, Eugenio Aragón, Lester Moré (2); Joel Iznaga]
Holguín         2-2     Santiago de Cuba  [6-5 pen]
  [Alexander Cruzata, Alexander Driggs; Luis Martén (2)]
[Dec 19]
Matanzas        0-7     Villa Clara    

Round 8
Ciudad          2-0     Santiago    
Pinar del Río   0-0     Holguín           [Pinar on pen]
Camagüey        0-0     Villa Clara       [Camagüey on pen]
Matanzas        1-0     Ciego de Avila

Round 9 [Nov 24]
Ciudad          3-1     Holguín     
  [Alberto Delgado, Andrés Roldán (2); Héctor Ramírez]
Pinar del Río   2-1     Santiago
  [Rodobaldo Hernández 7', Osmay Delgado 72'; Vladimir Sánchez 14']
Villa Clara     1-0     Ciego de Avila
  [Serguei Prado]
Matanzas        1-1     Camagüey          [1-3 pen]
  [Frank Orché; Nicolás Piñero]

Round 10 [Dec 1]
Camagüey        0-0     Ciudad            [4-3 pen]       [in Florida]
Ciego de Avila  0-0     Pinar del Río     [4-3 (?) pen]   [in Morón]
Santiago        1-0     Villa Clara                       [in Palma Saviano]
  [Luis Martén 27']
Holguín         2-0     Matanzas                          [in Banes]
  [Héctor Ramírez, Raúl Sánchez]

Round 11 [Dec 8] [Dec 5?]
Camagüey        1-0     Pinar del Río   
  [Rolando Poedo]
Ciego de Avila  3-3     Ciudad            [4-3 pen]    
  [Luis Fidalgo, Lester Moré, Jorge Luis Pérez; José Gramenci, Lázaro Molina,
   Léster Menéndez]
Santiago        4-1     Matanzas    
[Dec 26]
Holguín         1-0     Villa Clara  
  [Juan Carlos Quintana; att: 15,000]

Round 12
Ciudad          1-0     Villa Clara
  [Andrés Roldán 34]
Santiago        0-1     Camagüey       
  [José Antonio Raga 8']
Pinar del Río   0-0     Matanzas          [5-4 pen]
Holguín         0-0     Ciego de Avila    [Ciego on pen]

Round 13
Matanzas        1-4     Ciudad La Habana
Villa Clara     1-0     Pinar del Río
Camagüey        0-0     Holguín           [Holguín on pen]
Ciego de Avila  0-1     Santiago de Cuba  

Round 14 [Dec 23]
Ciudad          3-1     Pinar del Río
  [Andrés Roldán, Alberto Delgado, Carlos Zayas; Juan Carlos Salgado]
Villa Clara     3-0     Matanzas      
  [Mario Cuesta 2, Yenier Márquez]
Camagüey        2-5     Ciego de Avila
Santiago        0-2     Holguín
  [Raúl Rodríguez, Oliver Matos]

Table:

 1.Ciudad La Habana       14  10  1/ 2  1 29-13 34  ['Los Magníficos']
 2.Camagüey               14   4  5/ 3  2  8-10 25  
 3.Pinar del Río          14   6  2/ 2  4 15- 9 24  
 4.Holguín                14   5  3/ 3  3 12- 9 24 
 - - - - - - - - - - - - - - - - - - - - - - - - -
 5.Villa Clara            14   7  0/ 2  5 22- 9 23  ['El Expreso del Centro'] 
 6.Ciego de Avila         14   3  5/ 0  6 20-16 19  
 7.Santiago de Cuba       14   4  0/ 2  8 14-24 14  
 8.Matanzas               14   1  0/ 2 11  5-35  5  

Total season record semifinalists:

 1.Ciudad La Habana       28  21  2/ 3  2 61-19 70  ['Los Magníficos']
 2.Camagüey               27  10  8/ 4  4 24-18 50  [11 10/ 1 3 54??]
 3.Pinar del Río          28  12  5/ 2  9 31-23 48
 4.Holguín                28  10  4/ 5  9 30-29 43  

Semifinals

First Leg [Jan 9]
Holguín         0-1     Ciudad La Habana
Pinar del Río   1-0     Camagüey  

Second Leg [Jan 16]
Ciudad          2-0     Holguín    
  [Roldán 41, 80]
Camagüey        0-0     Pinar del Río  

Topscorers: Léster Moré (Ciego de Avila) 12
            Roldán (Ciudad)              12

Third Place Matches

First Leg [Jan 23]
Holguín         0-1     Camagüey
  [Alfredo Martínez (og) 25]

Second Leg [Feb 6]
Camagüey        0-1     Holguín                 [3-1 pen]
  [Héctor Ramírez 70]

Final

First Leg [Jan 23]
Pinar del Río   0-1     Ciudad La Habana
  [Pedro Mantilla]

Second Leg [Feb 6]
Ciudad          1-2     Pinar del Río
  [Manuel Bobadilla 69; Yomber Aguado 21, Carlos Torres 89]
  [kick-off by Diego Maradona]

Pinar del Río champions on away goals.

Topscorers:

13 Léster Moré (CAV)
12 Andrés Roldán (CHA)
11 Serguei Prado (VCL)
   Héctor Ramírez (HOL)
10 Oliver Matos (HOL)
 9 Armando Cruz (CAM) 
   Osmay Delgado (PRI)
 8 Mario Cuesta (VCL)
   Jorge Stevens (CHA)

Author: Hans Schöggl
(hans.schoeggl@sbg.ac.at)

Last updated: 18 Oct 2000

(C) Copyright Hans Schöggl and RSSSF 1999/2000
						


  USO DE MEMORIA  
4,307,120 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0019
Controller Execution Time ( Home / Category )  0.6767
Total Execution Time  0.6786
  CADENA URL  
/primera_division_cuba2000
  GET DATOS  
$_GET['/primera_division_cuba2000']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (38)  
0.0146  SELECT type FROM routes WHERE alias = 'primera_division_cuba2000'
0.0293  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'primera_division_cuba' AND (l.group_code = 1 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 2000 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=1 DESC LIMIT 1
0.0147  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=1713 AND type_rel = 3
0.0155  SELECT text_es as historical_text FROM leagues_text WHERE id=251
0.0151  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 = 28568 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0146  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='2000' WHERE c.parentId=1713 GROUP BY c.id ORDER BY c.order_id ASC
0.0145  SELECT type,rule FROM rules WHERE categoryId = 1713 ORDER BY type = 'tables_draw' DESC,type != 'extra' DESC, `order` ASC
0.0145  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-04-27 23:42:45' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0145  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=2 AND last_update > '2024-04-27 23:42:45' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0145  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=4 AND last_update > '2024-04-27 23:42:45' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0145  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=3 AND last_update > '2024-04-27 23:42:45' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0150  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'primera_division_cuba' AND (l.group_code = 0 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 2000 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=0 DESC LIMIT 1
0.0145  SELECT e.action, count(e.action) as total, e.player_id FROM events2000 e WHERE e.league_id IN (28568) 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.0146  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 (28568) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN () ORDER BY rp.in_squad = 1 DESC
0.0145  SELECT e.action, count(e.action) as total, e.player_id FROM events2000 e WHERE e.league_id IN (28568) AND (e.action IN (4,5) ) GROUP BY e.player_id ORDER BY total DESC, e.player_id ASC LIMIT 20
0.0145  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 (28568) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN () ORDER BY rp.in_squad = 1 DESC
0.0145  SELECT e.action, count(e.action) as total, e.player_id FROM events2000 e WHERE e.league_id IN (28568) AND (e.action IN (3,4) ) GROUP BY e.player_id ORDER BY total DESC, e.player_id ASC LIMIT 20
0.0145  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 (28568) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN () ORDER BY rp.in_squad = 1 DESC
0.0145  SELECT e.action, count(e.action) as total, e.player_id FROM events2000 e WHERE e.league_id IN (28568) AND (e.action IN (22) ) GROUP BY e.player_id ORDER BY total DESC, e.player_id ASC LIMIT 20
0.0146  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 (28568) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN () ORDER BY rp.in_squad = 1 DESC
0.0146  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 = 28568 AND rp.lineup > 0 ORDER BY rp.lineup DESC,p.pod DESC LIMIT 20
0.0145  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 = 28568 AND rp.events > 0 ORDER BY rp.events DESC,p.pod DESC LIMIT 20
0.0145  SELECT max(l.year) as max_year, min(l.year) as min_year FROM leagues l WHERE categoryID = 1713 GROUP BY l.categoryId
0.0145  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=1713 GROUP BY l.year ORDER BY l.year DESC
0.0151  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=28568 AND rel.round=14
0.0149  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 = 28568 AND esl.points > 0 ORDER BY esl.points DESC LIMIT 3
0.0150  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 = 28568 AND esl.points > 0
0.0150  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` = 28568 ORDER BY creation_date DESC LIMIT 0, 10
0.0159  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` = 28568
0.0150  SELECT c.isVideo, c.id,c.team1, c.team2,c.extra,c.datateam1,c.datateam2,c.type, c.shedule, c.r1, c.r2, c.round, c.comments as total_comentarios, dt1.nameShow as team1_name, dt2.nameShow as team2_name, dt1.basealias as basealias1, dt2.basealias as basealias2,c.betId,c.betId_wh,c.betId_bwin,c.betId_marca,c.betId_888, c.betId_sportium, c.betId_marathon, c.finished, c.penaltis1, c.penaltis2, c.prorroga, c.status, c.minute, dt1.stadium as stadium_name FROM `calendars2000` as c INNER JOIN teams t1 ON t1.id = c.team1 AND t1.league_id = c.league_id INNER JOIN teams t2 ON t2.id = c.team2 AND t2.league_id = c.league_id INNER JOIN datateams as dt1 ON dt1.id = t1.teamId INNER JOIN datateams as dt2 ON dt2.id = t2.teamId WHERE c.`league_id` = 28568 AND c.`round` = 14 ORDER BY shedule ASC LIMIT 200
0.0146  SELECT (dt1.qod+dt2.qod+dt1.relations+dt2.relations) as total,c.r1,c.r2,e.action,ev.showName as eventName,ev.largeName,ev.main_action,ev.keyname,ev.classf,e.real_date,e.minute, dp.nick,dp.CountryCode,dp.alias,c.datateam1,c.datateam2,dt1.nameShow as nameShow1,dt2.nameShow as nameShow2,dt1.basealias as basealias1,dt2.basealias as basealias2,e.player_id,e.match_id FROM `events2000` e INNER JOIN calendars2000 c ON c.id = e.match_id INNER JOIN events ev ON ev.id = e.action INNER JOIN dataplayers dp ON dp.id = e.player_id INNER JOIN datateams dt1 ON dt1.id = c.datateam1 INNER JOIN datateams dt2 ON dt2.id = c.datateam2 WHERE ev.main_action = 1 AND c.round = 14 AND e.real_date IS NOT NULL AND e.league_id = 28568 ORDER BY total DESC LIMIT 40
0.0155  SELECT c.r1,c.r2,e.action,ev.showName as eventName,ev.largeName,ev.main_action,ev.keyname,ev.classf,e.real_date,e.minute, dp.nick,dp.CountryCode,dp.alias,c.datateam1,c.datateam2,dt1.nameShow as nameShow1,dt2.nameShow as nameShow2,dt1.basealias as basealias1,dt2.basealias as basealias2,e.player_id,e.match_id FROM `events2000` e INNER JOIN calendars2000 c ON c.id = e.match_id INNER JOIN events ev ON ev.id = e.action INNER JOIN dataplayers dp ON dp.id = e.player_id INNER JOIN datateams dt1 ON dt1.id = c.datateam1 INNER JOIN datateams dt2 ON dt2.id = c.datateam2 WHERE ev.show_on = 1 AND e.real_date IS NOT NULL AND e.league_id = 28568 AND e.real_date > NOW() - INTERVAL 1 MONTH ORDER BY e.real_date DESC LIMIT 30
0.0152  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables2000` as t INNER JOIN teams as team ON team.id = t.team INNER JOIN datateams as dt ON team.teamId = dt.id WHERE t.league_id = 28568 AND t.round = 12 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0152  SELECT *,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables2000` as t INNER JOIN teams as team ON team.id = t.team INNER JOIN datateams as dt ON team.teamId = dt.id WHERE t.league_id = 28568 AND t.round = 14 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0152  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 = 28568 ORDER BY c.shedule ASC, fcoef DESC LIMIT 5
0.0152  SELECT data1, data2 FROM services_tags WHERE categoryId=1713
0.0152  SELECT l.year,l.group_code FROM leagues_besoccer l WHERE l.categoryId = 1713 AND l.year = 2000 ORDER BY l.group_code ASC
0.0152  SELECT group_code, extraName from `leagues` WHERE categoryId=1713 AND year=2000