4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
« Temporada Anterior
Temporada 2002
Temporada Siguiente »
Publicidad 600x120.gif
Primera División Cuba 2002
2001/2002

Primera División Cuba 2002

Información Histórica 
						
Elimination Phase

Tables:

Group A

 1.Ciudad La Habana       14 10  2/1  1  49-12  35  [CHA]  Qualified   
 2.Pinar del Río          14  7  0/1  6  19-16  22  [PRI]  Qualified
 3.Provincia de La Habana 14  2  2/2  8   9-24  12  [LHA] 
 4.Isla de la Juventud    14  2  0/0 12   5-30   6  [IJV]  

Group B

 1.Villa Clara            14  8  1/3  2  23- 8  29  [VCL]  Qualified
 2.Industriales La Habana 14  9  0/1  4  19-10  28  [IND]  Qualified
 3.Cienfuegos             14  6  2/0  6  16-24  22  [CFG]  Qualified
 4.Matanzas               14  4  1/0  9  11-27  14  [MTZ] 

Group C

 1.Sancti Spíritus        14  6  4/1  3  21-13  27  [SSP]  Qualified
 2.Ciego de Avila         14  5  2/4  3  13- 8  23  [CAV]  Qualified  
 3.Camagüey               14  4  1/6  3   8- 9  20  [CAM]  
 4.Las Tunas              14  3  3/1  7  13-14  16  [LTU]  

Group D

 1.Santiago de Cuba       14  6  4/2  2  17- 6  28  [SCU]  Qualified 
 2.Granma                 14  8  1/2  3  13- 9  28  [GRM]  Qualified
 3.Holguín                14  4  4/2  4  11- 7  22  [HOL]  Qualified
 4.Guantánamo             14  1  0/1 12   4-34   4  [GTM]  

NB: top-2 of each group and 2 best 3rd placed teams qualify for next stage.
    
Round 1 [within groups]
Ciudad La Habana 5-1 Pinar del Río
Provincia LH     1-0 Isla de la Juventud
Matanzas         drw Industriales           [MTZ on pen]
Cienfuegos       0-0 Villa Clara            [3-1 pen]
Sancti Sp.       2-1 Las Tunas
Ciego de A.      3-0 Camagüey
Holguín          0-0 Santiago de Cuba       [3-0 pen]
Granma           2-0 Guantánamo 

Round 2 [within groups]
Provincia        0-0 Ciudad La Habana       [CHA on pen]
Isla de la Juv.  lt  Pinar del Río    
Cienfuegos       1-0 Industriales
Granma           0-0 Holguín                [HOL on pen]
Villa Clara      2-0 Matanzas
Ciego de Ávila   1-0 Las Tunas
Sancti Spirítus  2-1 Camagüey
Santiago         4-0 Guantánamo

Round 3 [within groups]
Ciudad La Habana 3-0 Isla de la Juventud
Pinar del Río    1-0 Provincia de La Habana
Villa Clara      3-0 Industriales
Camagüey         2-1 Las Tunas
Sancti Spirítus  1-1 Ciego de Ávila         [SSP on pen]
Santiago de Cuba 1-0 Granma
Cienfuegos       awd Matanzas               [awarded 1-0 (?) to CFG]
Holguín          awd Guantánamo             [awarded to HOL (GTM?)]

Round 4 [group A vs B, C vs D] [Sep 12]
Pinar del Río    3-1 Cienfuegos             [abandoned due to rain; replayed Oct]
Ciudad La Habana 2-1 Industriales
Provincia LH     drw Villa Clara            [1-3 pen]
Isla de la Juv.  bt  Matanzas
Ciego de Ávila   drw Holguín                [HOL on pen]
Camagüey         1-0 Santiago de Cuba
Sancti Spirítus  awd Granma                 [awarded to SSP, GRM showed late]
Guantánamo       0-2 Las Tunas             

Round 5 [returns round 4; only 1 match switched venue] [Sep 15]
Pinar del Río    3-0 Cienfuegos             [played in Oct]
Ciudad La Habana lt  Industriales           [0-1?]
Provincia LH     1-3 Villa Clara    
Isla de la Juv.  0-2 Matanzas
Ciego de Ávila   1-0 Holguín                [0-1?]
Camagüey         drw Santiago de Cuba       [SCU on pen]
Sancti Spirítus  drw Granma                 [SSP on pen]           
Las Tunas        4-0 Guantánamo

Round 6 [group A vs B, C vs D] [Sep 19]
Cienfuegos       awd Ciudad La Habana       [abandoned, awarded 0-3]
Villa Clara      0-1 Pinar del Río
Matanzas         2-0 Provincia LH
Industriales     bt  Isla de la Juventud
Granma           1-0 Ciego de Ávila
Santiago de Cuba 1-1 Las Tunas              [SCU on pen]
Guantánamo       0-0 Camagüey               [CAM on pen]
Holguín          0-1 Sancti Spirítus

Round 7 [returns round 6] [Sep 22]
Cienfuegos       lt  Ciudad La Habana       [later]
Matanzas         1-0 Provincia LH
Villa Clara      2-0 Pinar del Río
Industriales     2-0 Isla de la Juventud
Holguín          1-0 Sancti Spirítus
Granma           2-0 Ciego de Ávila
Guantánamo       1-2 Camagüey     
Santiago de Cuba bt  Las Tunas      

Round 8 [group A vs B, C vs D]
[Sep 26]
Matanzas         1-4 Ciudad La Habana 
Industriales     1-0 Pinar del Río
Camagüey         1-0 Holguín
Granma           1-0 Las Tunas
Santiago de Cuba 0-0 Ciego de Avila         [SCU on pen]
Cienfuegos       1-1 Provincia LH           [CFG on pen]
Sancti Spíritus  5-0 Guantánamo
[Sep 27]
Isla Juventud    3-2 Villa Clara

Round 9 [returns round 8] [Sep 29,30]
Ciudad La Hab.  10-2 Matanzas         
Industriales     1-0 Pinar del Río
Camagüey         0-0 Holguín                [HOL on pen]
Granma           2-1 Las Tunas      
Ciego de Ávila   2-1 Santiago de Cuba       [Oct 24]
Provincia LH     awd Cienfuegos             [awarded to CFG, LHA dns]
Sancti Spíritus  bt  Guantánamo
Isla Juventud    lt  Villa Clara

Round 10 [group A vs B, C vs D] [Oct 3]
Cienfuegos       bt  Isla de La Juventud
Ciudad La Habana drw Villa Clara            [CHA on pen]
Industriales     bt  Provincia LH
Pinar del Río    bt  Matanzas               
Ciego de Ávila   lt  Guantánamo             
Granma           bt  Camagüey
Sancti Spíritus  lt  Santiago de Cuba 
Las Tunas        lt  Holguín

Round 11 [returns round 10] [Oct 6,7]
Isla Juventud    awd Cienfuegos             [awarded to CFG; IJV did not organise
                                             transportation]
Villa Clara      1-1 Ciudad La Habana       [CHA on pen]
Industriales     1-0 Provincia LH
Matanzas         1-0 Pinar del Río    
Ciego de Ávila   1-0 Guantánamo
Granma           0-0 Camagüey               [GRM on pen]
Sancti Spíritus  0-0 Santiago de Cuba       [SSP on pen]
Las Tunas        0-0 Holguín                [LTU on pen]

Round 12 [within groups, returns round 1] [Oct 10,11]
Pinar del Río    2-4 Ciudad La Habana  
Isla Juventud    0-1 Provincia LH     
Industriales     2-0 Matanzas         
Villa Clara      2-0 Cienfuegos       
Las Tunas        2-0 Sancti Sp.        
Camagüey         0-0 Ciego de A.            [CAV on pen]    
Santiago de Cuba 0-0 Holguín                [SCU on pen]
Guantánamo       0-1 Granma           

Round 13 [within groups, returns round 2]
Ciudad La Habana 5-0 Provincia LH         
Pinar del Río    3-0 Isla de la Juventud
Industriales     3-0 Cienfuegos       
Granma           2-0 Holguín               
Villa Clara      3-1 Matanzas               [1-0?]
Las Tunas        1-1 Ciego de Ávila         [LTU on pen]    
Sancti Spirítus  1-1 Camagüey               [SSP on pen]
Santiago         1-0 Guantánamo

Round 14 [within groups, returns round 3] [Oct 17]
Ciudad La Habana bt  Isla de la Juventud
Provincia LH     1-1 Pinar del Río          [LHA on pen]
Villa Clara      1-0 Industriales
Camagüey         0-0 Las Tunas              [LTU on pen]
Sancti Spirítus  0-0 Ciego de Ávila         [CAV on pen]     
Santiago de Cuba 2-0 Granma
Cienfuegos       1-0 Matanzas            
Holguín          6-0 Guantánamo         

Tables:

Group A

 1.Ciudad La Habana       14 10  2/1  1  49-12  35  [CHA]  Qualified   
 2.Pinar del Río          14  7  0/1  6  19-16  22  [PRI]  Qualified
 3.Provincia de La Habana 14  2  2/2  8   9-24  12  [LHA] 
 4.Isla de la Juventud    14  2  0/0 12   5-30   6  [IJV]  

Group B

 1.Villa Clara            14  8  1/3  2  23- 8  29  [VCL]  Qualified
 2.Industriales La Habana 14  9  0/1  4  19-10  28  [IND]  Qualified
 3.Cienfuegos             14  6  2/0  6  16-24  22  [CFG]  Qualified
 4.Matanzas               14  4  1/0  9  11-27  14  [MTZ] 

Group C

 1.Sancti Spíritus        14  6  4/1  3  21-13  27  [SSP]  Qualified
 2.Ciego de Avila         14  5  2/4  3  13- 8  23  [CAV]  Qualified  
 3.Camagüey               14  4  1/6  3   8- 9  20  [CAM]  
 4.Las Tunas              14  3  3/1  7  13-14  16  [LTU]  

Group D

 1.Santiago de Cuba       14  6  4/2  2  17- 6  28  [SCU]  Qualified 
 2.Granma                 14  8  1/2  3  13- 9  28  [GRM]  Qualified
 3.Holguín                14  4  4/2  4  11- 7  22  [HOL]  Qualified
 4.Guantánamo             14  1  0/1 12   4-34   4  [GTM]  

NB: top-2 of each group and 2 best 3rd placed teams qualify for next stage.
    
Second Stage

Table:

 1.Villa Clara            18 13  2/1  2  36- 6  44  [VCL]  Qualified
 2.Granma                 18  9  1/3  5  21-17  32  [GRM]  Qualified  
 3.Santiago de Cuba       18  7  5/1  5  23-20  32  [SCU]  Qualified
 4.Ciego de Ávila         18  7  3/4  4  18-12  31  [CAV]  Qualified    
 - - - - - - - - - - - - - - - - - - - - - - - - -
 5.Ciudad La Habana       18  7  2/5  4  18-13  30  [CHA] 
 6.Holguín                18  7  2/2  7  17-15  27  [HOL]   
 7.Pinar del Río          18  6  2/2  8  16-22  24  [PRI] 
 8.Industriales La Habana 17  5  0/4  8  11-20  19  [IND]  
 9.Sancti Spíritus        17  4  2/1 10   8-23  17  [SSP]  
10.Cienfuegos             18  1  4/0 13   5-25  11  [CFG] 


Round 1 [Oct 31]    
Santiago de Cuba 1-1 Ciudad La Habana       [SCU on pen]
Granma           0-1 Pinar del Río
Sancti Spíritus  0-8 Villa Clara 
Ciego de Ávila   1-2 Industriales
Cienfuegos       0-2 Holguín

Round 2 [Nov 2,3?]
Granma           2-1 Ciudad La Habana
Santiago de Cuba 3-1 Pinar del Río
Cienfuegos       0-0 Holguín                [CFG on pen]
Villa Clara      0-0 Ciego de Ávila         [VCL on pen]
Industriales     ppd Sancti Spíritus

Round 3 [postponed entirely to Mar 13, 2002]
Pinar del Río    0-1 Ciego de Ávila
Holguín          1-0 Santiago de Cuba
Cienfuegos       0-2 Granma
Ciudad La Habana 1-0 Sancti Spíritus
Industriales     n/p Villa Clara            [awarded to IND, VCL dns]

Round 4 [Nov 11]
Sancti Spíritus  2-0 Pinar del Río
Granma           2-1 Holguín
Ciudad La Habana 1-1 Ciego de Ávila         [CAV on pen]
Santiago de Cuba 2-1 Cienfuegos
Villa Clara      2-0 Industriales

Round 5 [Nov 14?]
Villa Clara      2-0 Ciudad La Habana
Industriales     1-1 Pinar del Rio          [PRI on pen (?)]
Holguín          1-0 Sancti Spíritus
Granma           1-0 Santiago de Cuba
Ciego de Ávila   2-0 Cienfuegos

Round 6 [Nov 18?]
Villa Clara      2-0 Pinar del Rio
Ciudad La Habana 1-0 Industriales
Santiago de Cuba 1-1 Granma                 [GRM on pen]
Sancti Spíritus  0-0 Cienfuegos             [CFG on pen]
Ciego de Ávila   1-0 Holguín

Round 7 [Nov 21]
Villa Clara      2-1 Holguín
Granma           3-2 Ciego de Ávila
Ciudad La Habana 1-1 Pinar del Rio          [CHA on pen]
Cienfuegos       0-1 Industriales
Santiago de Cuba 2-1 Sancti Spíritus

Round 8
Villa Clara      3-0 Cienfuegos
Ciudad La Habana 3-1 Pinar del Río
Granma           1-0 Sancti Spíritus
Santiago de Cuba 1-1 Ciego de Ávila         [SCU on pen]
Industriales     1-1 Holguín                [HOL on pen (?)]
 
Round 9
Villa Clara      4-0 Santiago de Cuba
Pinar del Río    0-1 Cienfuegos
Industriales     2-0 Granma
Ciudad La Habana 0-0 Holguín                [0-3 pen]
Sancti Spíritus  0-0 Ciego de Ávila         [SSP on pen]

Round 10 [Dec 2?]
Pinar del Rio    3-2 Holguín
Ciudad La Habana 3-0 Cienfuegos
Santiago de Cuba 3-0 Industriales
Villa Clara      2-0 Granma
Ciego de Ávila   1-0 Sancti Spíritus

Round 11 [Feb 6]
Villa Clara      2-0 Sancti Spíritus
Ciudad La Habana 1-1 Santiago de Cuba       [3-4 pen]
Industriales     2-1 Ciego de Ávila
Pinar del Río    1-1 Granma                 [4-2 pen]
Cienfuegos       bye
Holguín          bye

Round 12 [Feb 9,10]
Villa Clara      1-1 Ciego de Ávila         [CAV on pen]
Pinar del Río    0-0 Santiago de Cuba       [SCU on pen]
Industriales     0-0 Sancti Spíritus        [SSP on pen]
Ciudad La Habana 0-0 Granma                 [CHU on pen]
Cienfuegos       bye
Holguín          bye

Round 13 [Feb 13]
Sancti Spíritus  0-1 Ciudad La Habana
Ciego de Ávila   1-2 Pinar del Río
Santiago de Cuba 2-0 Holguín
Granma           4-1 Cienfuegos
Villa Clara      bye
Industriales     bye

Round 14 [Feb 16,17]
Ciego de Ávila   2-0 Ciudad La Habana
Santiago de Cuba 1-0 Cienfuegos
Granma           3-1 Holguín
Pinar del Río    1-0 Sancti Spíritus
Villa Clara      bye
Industriales     bye

Round 15 [Feb 20]
Ciudad La Habana 2-1 Villa Clara
Holguín          3-0 Sancti Spíritus
Ciego de Ávila   1-0 Cienfuegos
Pinar del Río    2-1 Industriales
Granma           bye
Santiago de Cuba bye

Round 16 [Feb 23, inferred]
Pinar del Río    0-1 Villa Clara
Ciudad La Habana 2-0 Industriales     
Cienfuegos       0-2 Sancti Spíritus
Holguín          0-0 Ciego de Ávila         [CAV on pen]
Granma           bye
Santiago de Cuba bye

Round 17
Santiago de Cuba 2-3 Sancti Spíritus
Granma           0-2 Ciego de Ávila
Villa Clara      1-0 Holguín
Cienfuegos       0-0 Industriales           [4-3 pen]
Ciudad La Habana bye
Pinar del Río    bye

Round 18
Industriales     0-2 Holguín
Sancti Spíritus  2-0 Granma
Villa Clara      2-1 Cienfuegos
Santiago de Cuba 0-0 Ciego de Ávila         [SCU on pen]
Ciudad La Habana bye
Pinar del Río    bye

Round 19 [Mar 6]
Granma           1-0 Industriales
Cienfuegos       1-2 Pinar del Río
Santiago de Cuba 1-3 Villa Clara
Holguín          1-0 Ciudad La Habana
Ciego de Ávila   bye
Sancti Spíritus  bye

Round 20 [Mar 9]
Holguín          1-0 Pinar del Río
Cienfuegos       0-0 Ciudad La Habana       [CFG on pen]
Santiago de Cuba 3-1 Industriales
Granma           0-0 Villa Clara            [VCL on pen]
Ciego de Ávila   bye
Sancti Spíritus  bye

Table:

 1.Villa Clara            18 13  2/1  2  36- 6  44  [VCL]  Qualified
 2.Granma                 18  9  1/3  5  21-17  32  [GRM]  Qualified  
 3.Santiago de Cuba       18  7  5/1  5  23-20  32  [SCU]  Qualified
 4.Ciego de Ávila         18  7  3/4  4  18-12  31  [CAV]  Qualified    
 - - - - - - - - - - - - - - - - - - - - - - - - -
 5.Ciudad La Habana       18  7  2/5  4  18-13  30  [CHA] 
 6.Holguín                18  7  2/2  7  17-15  27  [HOL]   
 7.Pinar del Río          18  6  2/2  8  16-22  24  [PRI] 
 8.Industriales La Habana 17  5  0/4  8  11-20  19  [IND]  
 9.Sancti Spíritus        17  4  2/1 10   8-23  17  [SSP]  
10.Cienfuegos             18  1  4/0 13   5-25  11  [CFG] 


Semifinals 

First Legs [Mar 16]
Santiago de Cuba 0-0 Granma
Ciego de Ávila   1-0 Villa Vlara
  [Raúl Herrera 51]

Second Legs [Mar 20]
Granma           1-0 Santiago de Cuba
  [Alexander González 44]
Villa Clara      0-0 Ciego de Ávila

Third Place Match

First Leg
Santiago de Cuba 1-3 Villa Clara      
  [Alfredo González 72; Maikel Galindo 23, 62, Ariel Betancourt 69]

Second Leg
Villa Clara      2-1 Santiago de Cuba

Final

First Leg [Mar 23]
Granma           0-1 Ciego de Ávila 
  [Léster Moré 42] 

Second Leg [Mar 31 (ppd from Mar 27]]
Ciego de Ávila   0-0 Granma

Ciego de Ávila champions.

Topscorer:
Ariel Betancourt (VCL)          17 (14 in 2nd stage, scoring in all
                                    9 matches from round 4 to 12)

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

Last updated: 10 Aug 2002

(C) Copyright Hans Schöggl and RSSSF 2001/02


  USO DE MEMORIA  
4,304,920 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0019
Controller Execution Time ( Home / Category )  0.1149
Total Execution Time  0.1169
  CADENA URL  
/primera_division_cuba2002
  GET DATOS  
$_GET['/primera_division_cuba2002']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (38)  
0.0018  SELECT type FROM routes WHERE alias = 'primera_division_cuba2002'
0.0041  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 = 2002 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=1 DESC LIMIT 1
0.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=1713 AND type_rel = 3
0.0026  SELECT text_es as historical_text FROM leagues_text WHERE id=252
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 = 28569 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='2002' WHERE c.parentId=1713 GROUP BY c.id ORDER BY c.order_id ASC
0.0018  SELECT type,rule FROM rules WHERE categoryId = 1713 ORDER BY type = 'tables_draw' DESC,type != 'extra' DESC, `order` ASC
0.0020  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-04-28 05:16:52' 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=2 AND last_update > '2024-04-28 05:16:52' 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=4 AND last_update > '2024-04-28 05:16:52' 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-28 05:16:52' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0025  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 = 2002 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=0 DESC LIMIT 1
0.0020  SELECT e.action, count(e.action) as total, e.player_id FROM events2002 e WHERE e.league_id IN (28569) 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 (28569) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN () ORDER BY rp.in_squad = 1 DESC
0.0021  SELECT e.action, count(e.action) as total, e.player_id FROM events2002 e WHERE e.league_id IN (28569) AND (e.action IN (4,5) ) GROUP BY e.player_id ORDER BY total DESC, e.player_id ASC LIMIT 20
0.0020  SELECT dp.name, dp.last_name, dp.nick,dp.CountryCode,dp.alias,rp.team_id,dt.nameShow,dt.short_name,dt.basealias,rp.player_id,rp.teamId,dp.role FROM dataplayers AS dp INNER JOIN rel_players AS rp ON rp.player_id=dp.id AND rp.league_id IN (28569) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN () ORDER BY rp.in_squad = 1 DESC
0.0022  SELECT e.action, count(e.action) as total, e.player_id FROM events2002 e WHERE e.league_id IN (28569) AND (e.action IN (3,4) ) GROUP BY e.player_id ORDER BY total DESC, e.player_id ASC LIMIT 20
0.0022  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 (28569) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN () ORDER BY rp.in_squad = 1 DESC
0.0022  SELECT e.action, count(e.action) as total, e.player_id FROM events2002 e WHERE e.league_id IN (28569) AND (e.action IN (22) ) GROUP BY e.player_id ORDER BY total DESC, e.player_id ASC LIMIT 20
0.0023  SELECT dp.name, dp.last_name, dp.nick,dp.CountryCode,dp.alias,rp.team_id,dt.nameShow,dt.short_name,dt.basealias,rp.player_id,rp.teamId,dp.role FROM dataplayers AS dp INNER JOIN rel_players AS rp ON rp.player_id=dp.id AND rp.league_id IN (28569) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN () ORDER BY rp.in_squad = 1 DESC
0.0027  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 = 28569 AND rp.lineup > 0 ORDER BY rp.lineup DESC,p.pod DESC LIMIT 20
0.0022  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 = 28569 AND rp.events > 0 ORDER BY rp.events DESC,p.pod DESC LIMIT 20
0.0021  SELECT max(l.year) as max_year, min(l.year) as min_year FROM leagues l WHERE categoryID = 1713 GROUP BY l.categoryId
0.0019  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.0027  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=28569 AND rel.round=14
0.0024  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 = 28569 AND esl.points > 0 ORDER BY esl.points DESC LIMIT 3
0.0024  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 = 28569 AND esl.points > 0
0.0023  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` = 28569 ORDER BY creation_date DESC LIMIT 0, 10
0.0033  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` = 28569
0.0030  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 `calendars2002` 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` = 28569 AND c.`round` = 14 ORDER BY shedule ASC LIMIT 200
0.0019  SELECT (dt1.qod+dt2.qod+dt1.relations+dt2.relations) as total,c.r1,c.r2,e.action,ev.showName as eventName,ev.largeName,ev.main_action,ev.keyname,ev.classf,e.real_date,e.minute, dp.nick,dp.CountryCode,dp.alias,c.datateam1,c.datateam2,dt1.nameShow as nameShow1,dt2.nameShow as nameShow2,dt1.basealias as basealias1,dt2.basealias as basealias2,e.player_id,e.match_id FROM `events2002` e INNER JOIN calendars2002 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 = 28569 ORDER BY total DESC LIMIT 40
0.0025  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 `events2002` e INNER JOIN calendars2002 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 = 28569 AND e.real_date > NOW() - INTERVAL 1 MONTH ORDER BY e.real_date DESC LIMIT 30
0.0026  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 `tables2002` 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 = 28569 AND t.round = 12 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0026  SELECT *,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables2002` 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 = 28569 AND t.round = 14 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0026  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 = 28569 ORDER BY c.shedule ASC, fcoef DESC LIMIT 5
0.0026  SELECT data1, data2 FROM services_tags WHERE categoryId=1713
0.0026  SELECT l.year,l.group_code FROM leagues_besoccer l WHERE l.categoryId = 1713 AND l.year = 2002 ORDER BY l.group_code ASC
0.0026  SELECT group_code, extraName from `leagues` WHERE categoryId=1713 AND year=2002