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 2006
2005/2006

Primera División Cuba 2006

Información Histórica
						
91st Campeonato Nacional de Fútbol

First Stage

Tables:

Llave A
 1.Ciudad de La Habana         8  5  2  1 17- 8 17  Qualified
 2.La Habana                   8  4  1  3 14-10 13  Qualified
 3.Matanzas                    8  3  2  3 10- 9 11  Qualified
 4.Pinar del Río               8  3  2  3  9-12 11
 5.Isla de la Juventud         8  0  3  5  5-16  3

Llave B
 1.Cienfuegos                  7  4  2  1  9- 6 14  Qualified
 2.Camagüey                    8  4  1  3  6-13 13  Qualified
 3.Sancti Spíritus             7  2  3  2  6- 6  9  Qualified
 4.Villa Clara                 8  2  2  4  9- 7  8
 5.Ciego de Ávila              8  1  4  3 11- 9  7

Llave C
 1.Granma                      7  4  2  1 11- 8 14  Qualified
 2.Santiago de Cuba            8  3  3  2 11-10 12  Qualified
 3.Holguín                     8  3  2  3 12- 8 11  Qualified
 4.Guantánamo                  8  3  2  3 12-12 11  Qualified
 5.Las Tunas                   7  0  3  4  6-14  3

NB: top-3 of all groups and best 4th placed team progress
    to second stage (Quintos de Final)

Round 1 [Sep 3]
Llave A
Isla de la Juventud 1-3 Matanzas
  [Vladimir Iglesias 14; Yordanis Tielves 23, Yendri Díaz 31,
   Eduardo Morales 64]
La Habana           2-3 Ciudad de La Habana
  [Rudy Lay Arencibia 58, 92; Manuel Bobadilla 14, 27, Jaine Colomé 31pen]
Pinar del Río       bye
Llave B
Ciego de Ávila      0-0 Sancti Spíritus
Cienfuegos          2-0 Camagüey
  [Yasiel Padrón 40, Francisco Alexei Carrazana 81]
Villa Clara         bye
Llave C
Las Tunas           2-2 Guantánamo
  [Geovanny Ayala 38pen, 45; Alaín Urgellés 52, Alexei Zuaznábar 90]
Granma              1-0 Holguín
  [Yasniel La Rosa 75]
Santiago de Cuba    bye

Round 2 [Sep 7]
Llave A
Isla de la Juventud 0-2 Ciudad de La Habana
  [Rubén Puente 8, Alfredo Carrera 69]
La Habana           3-1 Pinar del Río
  [Rudi Lay Arencibia 11, Boris González 38, Raidel Torres 81pen;
   Reinier Alcántara 22]
Matanzas            bye
Llave B
Sancti Spíritus     1-0 Villa Clara
  [Yanosky Alcántara 74]
Ciego de Ávila      2-2 Cienfuegos
  [Lester Moré 4, Liván Pérez 44; Yosniel Mesa 9, Yasiel Padrón 69]
Camagüey            bye
Llave C
Santiago de Cuba    0-0 Las Tunas
Guantánamo          2-1 Holguín
  [Yunior Pérez 40, Alexei Zuaznábar 86; Oliver Matos 13]
Granma              bye

Round 3 [Sep 10]
Llave A
Isla de la Juventud 0-3 Pinar del Río
  [Raudel Rodríguez 38, Reinier Alcántara 59, José C. Alfonso 81]
Ciudad de La Habana 2-0 Matanzas
  [Yoel Apesteguía 6, Yoel Apesteguía 85]
La Habana           bye
Llave B
Villa Clara         0-0 Ciego de Ávila
Camagüey            1-0 Sancti Spíritus
  [Armando Coroneaux 4]
Cienfuegos          bye
Llave C
Holguín             0-2 Santiago de Cuba
  [Andro Martínez 46, Disney Aquino 87]
Guantánamo          2-1 Granma
  [Alexei Zuaznábar 21, 56; Yoandry Diego 36]
Las Tunas          bye

Round 4 [Sep 14]
Llave A
Isla de la Juventud 1-3 La Habana
  [Vladimir Iglesias 49; Rudy Lay Arencibia 21, 44, Boris González 34]
Matanzas            0-2 Pinar del Río
  [José C. Alfonso 49, Reinier Alcántara 75]
Ciudad de La Habana bye
Llave B
Sancti Spíritus     0-1 Cienfuegos
  [Yosniel Mesa 57pen]
Camagüey            1-0 Villa Clara
  [Armando Coroneaux 85]
Ciego de Ávila      bye
Llave C
Las Tunas           1-2 Granma
  [Rafael Adam Dominico 80; Yasniel La Rosa 77, Ruslan Batista 88]
Santiago de Cuba    1-3 Guantánamo
  [Ever Hardy 32; Alexei Zuaznábar 44, Lésner Lamouth 51,
   Cándido Álvarez 82]
Holguín             bye

Round 5 [Sep 17]
Llave A
Pinar del Río       1-1 Ciudad de La Habana
  [Yusniel Pedroso 10; Yadiel Chapotín 17]
Matanzas            0-0 La Habana
Isla de la Juventud bye
Llave B
Cienfuegos          0-0 Villa Clara
Camagüey            0-5 Ciego de Ávila
  [Alain Cervantes 17, 57, Léster Moré 40, 51pen, 66]
Sancti Spíritus     bye
Llave C
Holguín             6-1 Las Tunas
  [Héctor Ramírez 33, 70, Yadián Casa del Valle 55, 82,
   Karel Ceiser 72, Yadiel Leyva 84; Lizardo Pérez 75]
Santiago de Cuba    3-4 Granma
  [Alieski Salgado 31, Enoel Jordán 81, Vladimir Sánchez 91;
   Yasniel La Rosa 40, 49, Adonis Ramos 63, Ramón Ocaña 83]
Guantánamo          bye

Round 6 [Sep 24]
Llave A
Ciudad de La Habana 3-1 La Habana
  [Leovanny Cartaya 21, Yoel Apesteguía 75, Jaime Colomé 87;
   Sandor Sevillano 36]
Matanzas            1-1 Isla de la Juventud
  [Eduardo Morales 14; Vladimir Iglesias 62]
Pinar del Río       bye
Llave B
Sancti Spíritus     2-2 Ciego de Ávila
  [Ariel Martínez 44, Yoel Zanetti 72; Lester Moré 16pen,
   Héctor Cervantes 24]
Camagüey            2-0 Cienfuegos
  [Armando Coroneaux 62, Angel Horta 67]
Villa Clara         bye
Llave C
Holguín             0-0 Granma
Guantánamo          1-1 Las Tunas
  [Alain Urgelles 5; Geysel Blanco 32]
Santiago de Cuba    bye

Round 7
Llave A [Sep 28]
Pinar del Río       2-1 La Habana
  [José C. Alfonso 27, Reinier Alcántara 51; Roddy Peña 20]
Ciudad de La Habana 2-2 Isla de la Juventud
  [Onay Martínez 19, Mario Gil 47; Miguel Sánchez 22, 62]
Matanzas            bye
Llave B [Sep 28]
Cienfuegos          2-1 Ciego de Ávila
  [Enrique Villaurrutia 54, 71; Lester Moré 88]
Villa Clara         1-2 Sancti Spíritus
  [Yoel Fajardo 19, Yoel Zanetti 65; Ariel Martínez 80]
Camagüey            bye
Llave C
[Sep 28]
Las Tunas           1-2 Santiago de Cuba
  [Lizardo Pérez 85; Reinier Martínez 28, Abel Chercolé 74]
[Oct 15]
Holguín             3-1 Guantánamo
Granma              bye 

Round 8 [Oct 1]
Llave A
Pinar del Río       0-0 Isla de la Juventud  
Matanzas            2-1 Ciudad de La Habana  
  [Diosvany Cárdenas 28, Yendri Díaz 50; Alfredo Carrera 88 ]
La Habana           bye
Llave B
Sancti Spíritus     1-1 Camagüey  
  [Ariel Martínez 55; Nicolás Piñeiro 22]
Ciego de Ávila      1-2 Villa Clara  
  [Lester Moré 78pen; Pedro P. Pereira 31, Silvio Pedro 51pen]
Cienfuegos          bye
Llave C
Granma              2-1 Guantánamo 
  [Adonis Ramos 3, 70; Alexei Zuaznábar 67pen]
Santiago de Cuba    1-1 Holguín 
  [Vladimir Sánchez 45; Yoandry Vega 88]
Las Tunas           bye

Round 9 
Llave A [Oct 8]
Pinar del Río       0-4 Matanzas 
  [Yendri Díaz 8, Yordanis Tielves 16, Diosvany Cárdenas 43, 
   Vismani Cárdenas 89]
La Habana           2-0 Isla de la Juventud  
  [Raciel Torres 23, Rudy Lay Arencibia 53]
Ciudad de La Habana bye 
Llave B
[Oct 8]
Villa Clara         5-0 Camaguey 
  [Yoel Fajardo 12, Luis A. Villegas 15, 83, Pedro Faife 70,
   Roberto Linares '90]
[tba]
Cienfuegos           -  Sancti Spíritus
Ciego de Ávila      bye  
Llave C
[Oct 8] 
Guantánamo          0-1 Santiago de Cuba 
  [Vladimir Sánchez 54]
[tba]
Granma               -  Las Tunas  
Holguín             bye

Round 10 [Oct 12]
Llave A
Ciudad de La Habana 3-0 Pinar del Río 
  [Yoel Apesteguía 35, 73, Mario Gil 58]
La Habana           2-0 Matanzas 
  [Roddy Peña 36, Boris González 60]
Isla de la Juventud bye
Llave B
Ciego de Ávila      0-1 Camagüey 
  [Armando Coroneaux 77]
Villa Clara         1-2 Cienfuegos 
  [Luis A. Villegas 25; Enrique Villaurrutia 32, 
   Francisco A. Carrasana 66]
Sancti Spíritus     bye
Llave C 
Granma              1-1 Santiago de Cuba 
  [Yasniel la Rosa 47; José Vila 19]
Las Tunas           0-1 Holguín 
  [Yadián Casa del Valle] 
Guantánamo          bye

Tables:

Llave A
 1.Ciudad de La Habana         8  5  2  1 17- 8 17  Qualified
 2.La Habana                   8  4  1  3 14-10 13  Qualified
 3.Matanzas                    8  3  2  3 10- 9 11  Qualified
 4.Pinar del Río               8  3  2  3  9-12 11
 5.Isla de la Juventud         8  0  3  5  5-16  3

Llave B
 1.Cienfuegos                  7  4  2  1  9- 6 14  Qualified
 2.Camagüey                    8  4  1  3  6-13 13  Qualified
 3.Sancti Spíritus             7  2  3  2  6- 6  9  Qualified
 4.Villa Clara                 8  2  2  4  9- 7  8
 5.Ciego de Ávila              8  1  4  3 11- 9  7

Llave C
 1.Granma                      7  4  2  1 11- 8 14  Qualified
 2.Santiago de Cuba            8  3  3  2 11-10 12  Qualified
 3.Holguín                     8  3  2  3 12- 8 11  Qualified
 4.Guantánamo                  8  3  2  3 12-12 11  Qualified
 5.Las Tunas                   7  0  3  4  6-14  3

NB: top-3 of all groups and best 4th placed team progress
    to second stage (Quintos de Final)

Second Stage

Final Table:

 1.Holguín                    18  9  5  4 15-13 32  Champions
 2.Ciudad de La Habana        18  8  6  4 25-15 30
 3.Santiago de Cuba           18  8  5  5 23-10 29
 4.Cienfuegos                 18  7  6  5 21-11 27
 5.Granma                     18  6  7  5 16-13 25
 6.Matanzas                   18  6  6  6 17-20 24
 7.La Habana                  18  4  8  6 16-21 20
 8.Camagüey                   18  5  5  8 12-20 20
 9.Guantánamo                 18  5  5  8 14-23 20
10.Sancti Spíritus            18  1  9  8 13-26 12

NB: rounds 1 and 2 postponed, played after round 9

Round 3 
[Oct 29]
Holguín             2-0 La Habana  
  [Luis Pérez 20, Yadián Casa del Valle 88]
Cienfuegos          5-0 Camagüey 
  [Manuel Abreu 10, 85, Mario Pedraza 14, Yosniel Mesa 52, 63pen]
Sancti Spíritus     2-1 Guantánamo 
  [Ariel Martínez 35, Carlos Madrigal 55; Alexei Suaznábar 42]
[Jan 4?]
Granma              0-0 Matanzas        
Santiago de Cuba    3-1 Ciudad de La Habana
  [Andro Martínez 5, Disney Aquino 10, 44; Yoel Apesteguía 63]

Round 4 [Nov 5]
Cienfuegos          1-2 Granma  
  [Enrique Villaurrutia 21; Yoandri Jorge 59pen, Ramón Ocaña 88]
Camagüey            1-0 Santiago de Cuba  
  [Osmani Montero 40]
Sancti Spíritus     2-2 Holguín  
  [Yanosky Alcántara 9, Carlos Madrigal 51; Oliver Matos 47, 78]
Ciudad de La Habana 2-1 Guantánamo  
  [Yoel Apestequía 27, Hensi Muñoz 80; Alexei Suaznábar 78]
La Habana           0-1 Matanzas  
  [Diosvany Cárdenas 86]
 
Round 5 [Nov 9]
Cienfuegos          0-1 Santiago de Cuba  
  [Disney Aquino 31]
Camagüey            0-1 Holguín 
  [Héctor Ramírez 73]
Sancti Spíritus     0-1 Granma 
  [Ruslan Batista 70]
Ciudad de La Habana 3-0 Matanzas  
  [Mario Gil, Lázaro Aroche, Manuel Bobadilla]
La Habana           3-1 Guantánamo  
  [Hansel Zayas 45, Boris González 59, Rudi Lay Arencibia 72;
   Cándido Álvarez 66]

Round 6 [Nov 12]
Cienfuegos          1-1 Holguín  
  [Enrique Villaurrutia 53; Luis Felipe Gómez 52] 
Camagüey            0-2 Granma 
  [Ruslan Batista 23, Ramón Ocaña 44]
Sancti Spíritus     0-1 Santiago de Cuba  
  [Yuniel Olivera 7og]
Ciudad de La Habana 1-1 La Habana  
  [Onay Martínez 90; Carlos García 36]
Matanzas            1-2 Guantánamo  
  [Yordanis Tielves 18; Alianis Urgellés 32, 85]

Round 7 [Nov 19]
Ciudad de La Habana 2-2 Sancti Spíritus  
  [Mario Gil 33, Hensi Muñoz 36; Yoel Zanetti 40, Carlos Madrigal 65]
La Habana           0-0 Cienfuegos 
Matanzas            1-2 Camagüey 
  [Eduardo Morales 5; Armando Coroneaux 40, 60]
Santiago de Cuba    0-0 Granma  
Guantánamo          0-1 Holguín  
  [Héctor Ramírez 66]

Round 8 [Nov 23]
Ciudad de La Habana 1-0 Camagüey  
  [Onay Martínez 46]
La Habana           3-1 Sancti Spíritus  
  [Raicel Torres 29, Rudy Lay Arencibia 49, Hansel Zayas 80;
   Carlos Madrigal 42]
Matanzas            1-0 Cienfuegos 
  [Yordanis Tielves 82] 
Holguín             1-0 Granma  
  [Yadián Casa del Valle 48]
Guantánamo          1-1 Santiago de Cuba  
  [Yaruselki Riberí; Enoel Jordan]

Round 9 [Nov 26]
Ciudad de La Habana 1-2 Cienfuegos  
  [Yoel Apestequía 40; Enrique Villaurrutia 49, Manuel Abreu 52]
La Habana           1-1 CamagÜey 
  [Boris González 13; Osmani Montero 22]
Matanzas            1-1 Sancti Spíritus  
  [Yordanis Tielves (pen); Clay Castiñeira] 
Guantánamo          2-1 Granma  
  [Lésner Lamouth 1, Alain Urgellés 50; Ruslan Batista 67]
Holguín             0-1 Santiago de Cuba  
  [Jorge Kindelán 23]

Round 1 [Nov 30; ppd from Oct 22]
Granma              1-1 Ciudad de La Habana  
  [Yoandri Jorge 28; Mario Gil 3]
Santiago de Cuba    1-1 La Habana 
  [Andro Martínez; Rudy Lay Arencibia]
Holguín             0-1 Matanzas 
  [Liubir Ramos 46]
Cienfuegos          1-0 Guantánamo 
  [Yordanis Álvarez 85]
Camagüey            1-0 Sancti Spíritus  
  [Osmani Montero 45]
 
Round 2 [Dec 3; ppd from Oct 26]
Granma              2-0 La Habana  
  [Adonis Ramos 49, Jorge Luis Quiala 76]
Santiago de Cuba    1-1 Matanzas 
  [Leonardo Vila 64; Yordanis Tielves 75]
Holguín             1-1 Ciudad de La Habana
  [Luis Pérez 48; Mario Gil 32]
Cienfuegos          0-0 Sancti Spíritus  
Camagüey            1-2 Guantánamo 
  [Maikel Pacheco 28; Nelson Puebla 19, Alberto Gómez 26]

Round 10 [Dec 10]
Ciudad de La Habana 1-0 Granma
  [Hensi Muñoz 58]
La Habana           1-0 Santiago de Cuba
  [Boris González 93]
Matanzas            2-0 Holguín
  [Yordanis Tielves 13, 68]
Guantánamo          0-1 Cienfuegos
  [Yordanis Álvarez 36]
Sancti Spíritus     0-0 Camagüey

Round 11 [Dec 14]
La Habana           1-0 Granma
  [Hansel Zayas 60]
Matanzas            1-0 Santiago de Cuba
  [Raúl Hernández Espinosa 10]
Ciudad de La Habana 5-0 Holguín
  [Hensi Muñoz 9, 47, Jaine Colomé 28pen, Mario Gil 52, Yoel Apesteguía 79]
Sancti Spíritus     1-1 Cienfuegos
  [Yasmani Marrero 15; Enrique Villaurrutia 16]
Guantánamo          1-0 Camagüey
  [Alexei Suaznábar 17]

Round 12 [Dec 17]
Matanzas            3-4 Granma  
  [Eduardo Morales 6, 44, Raúl Fernández 30; Adonis Ramos 9,
   Ridiel Castillo 63, Ruslan Batista 84, 89]
Ciudad de La Habana 0-1 Santiago de Cuba  
  [Ever Hardy 54]
La Habana           0-1 Holguín 
  [Luis Pérez 7]
Camagüey            1-1 Cienfuegos  
  [Armando Coroneaux 33; Yordanis Álvarez 77]
Guantánamo          1-1 Sancti Spíritus  
  [Kanel Dranger 92; Yunielis Castillo 59]

Round 13 [Dec 21]
Granma              0-0 Cienfuegos  
Santiago de Cuba    0-2 Camagüey 
  [Ángel Horta 40, 52]
Holguín             1-0 Sancti Spíritus  
  [Yadián Casa del Valle 18]  
Guantánamo          0-0 Ciudad de La Habana  
Matanzas            1-1 La Habana  
  [Yordanis Tielves 65; Raciel Torres 2]

Round 14 [Dec 24]
Santiago de Cuba    0-1 Cienfuegos  
  [Manuel Abreu 21] 
Holguín             2-0 Camagüey 
  [Rafael Turró 47, Yadián Casa del Valle 87]   
Granma              2-0 Sancti Spíritus  
  [Ruslan Batista 20, Neobel Nuñez 88]   
Matanzas            0-0 Ciudad de La Habana  
Guantánamo          1-1 La Habana  
  [Alexei Zuasnábar; Rudy Lay Arencibia]   

Round 15 [Dec 28]
Holguín             1-0 Cienfuegos  
  [Yoandri Vega 82]   
Granma              1-1 Camagüey 
  [Ramón Ocaña 78; Osmani Montero 54]
Santiago de Cuba    5-0 Sancti Spíritus  
  [Disney Aquino (2), Enoel Jordán, Diuren Gago, Leonardo Vila]   
La Habana           1-3 Ciudad de La Habana  
  [Rody Peña 43; Lázaro Aroche 10, Manuel Bobadilla 44, 63]
Guantánamo          1-0 Matanzas  
  [Alain Urgellés 79]

Round 16 [Jan 7]
Sancti Spíritus     1-2 Ciudad de La Habana  
  [Ariel Martínez 39; Manuel Bobadilla 55, Mario Gil 82]  
Cienfuegos          3-0 La Habana 
  [Yaisel Padrón 49, Enrique Villaurrutia 72, Yaisel Padrón 83]  
Camagüey            0-1 Matanzas 
  [Yendri Díaz 74]
Granma              0-2 Santiago de Cuba  
  [Disney Aquino 19, Ever Hardy 90] 
Holguín             1-0 Guantánamo  
  [Daniel Mitih 89]
  
Round 17 [Jan 11]
Camagüey            1-0 Ciudad de La Habana  
  [Osmani Torres (pen)]   
Sancti Spíritus     1-1 La Habana 
  [Lázaro Pérez 37; Sandro Sevillano 2]
Cienfuegos          4-1 Matanzas 
  [Manuel Abreu 8, Mario Pedraza 11, Enrique Villaurrutia 20, 70;
   Yordanis Tielves 64]
Granma              0-0 Holguín  
Santiago de Cuba    6-0 Guantánamo 
  [Leonardo Vila 6, Disney Aquino 22, Enoel Jordán 44, 87,
   Reinier Rodríguez 59, Ever Hardy 72]   

Round 18 [Jan 14]  
Santiago de Cuba    0-0 Holguín
Ciudad de La Habana 1-0 Cienfuegos
  [Mario Gil]    
Granma              0-0 Guantánamo
Matanzas            1-1 Sancti Spíritus 
  [Yordanis Tielves; ?]   
Camagüey            1-1 La Habana

Final Table:

 1.Holguín                    18  9  5  4 15-13 32  Champions
 2.Ciudad de La Habana        18  8  6  4 25-15 30
 3.Santiago de Cuba           18  8  5  5 23-10 29
 4.Cienfuegos                 18  7  6  5 21-11 27
 5.Granma                     18  6  7  5 16-13 25
 6.Matanzas                   18  6  6  6 17-20 24
 7.La Habana                  18  4  8  6 16-21 20
 8.Camagüey                   18  5  5  8 12-20 20
 9.Guantánamo                 18  5  5  8 14-23 20
10.Sancti Spíritus            18  1  9  8 13-26 12


Author: Alejandro Raúl Pérez Valdes

Last updated: 4 Sep 2008

(C) Copyright Alejandro Raúl Pérez Valdes and RSSSF 2005/08
						


  USO DE MEMORIA  
4,305,176 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0031
Controller Execution Time ( Home / Category )  0.1034
Total Execution Time  0.1065
  CADENA URL  
/primera_division_cuba2006
  GET DATOS  
$_GET['/primera_division_cuba2006']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (35)  
0.0018  SELECT type FROM routes WHERE alias = 'primera_division_cuba2006'
0.0040  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 = 2006 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.0021  SELECT text_es as historical_text FROM leagues_text WHERE id=253
0.0018  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 = 28570 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='2006' WHERE c.parentId=1713 GROUP BY c.id ORDER BY c.order_id ASC
0.0019  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-04-28 18:25:38' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0020  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=2 AND last_update > '2024-04-28 18:25:38' 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-28 18:25:38' 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-28 18:25:38' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0024  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 = 2006 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 events2006 e WHERE e.league_id IN (28570) 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 (28570) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN () ORDER BY rp.in_squad = 1 DESC
0.0027  SELECT e.action, count(e.action) as total, e.player_id FROM events2006 e WHERE e.league_id IN (28570) AND (e.action IN (4,5) ) GROUP BY e.player_id ORDER BY total DESC, e.player_id ASC LIMIT 20
0.0059  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 (28570) 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 events2006 e WHERE e.league_id IN (28570) AND (e.action IN (3,4) ) 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 (28570) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN () ORDER BY rp.in_squad = 1 DESC
0.0020  SELECT e.action, count(e.action) as total, e.player_id FROM events2006 e WHERE e.league_id IN (28570) AND (e.action IN (22) ) 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 (28570) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN () ORDER BY rp.in_squad = 1 DESC
0.0018  SELECT rp.lineup as total,p.name, p.last_name, p.nick,p.CountryCode,p.alias,rp.team_id,dt.nameShow,dt.short_name,dt.basealias,rp.player_id,rp.teamId,p.role FROM `rel_players` rp INNER JOIN dataplayers p ON p.id = rp.player_id INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 28570 AND rp.lineup > 0 ORDER BY rp.lineup DESC,p.pod DESC LIMIT 20
0.0017  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 = 28570 AND rp.events > 0 ORDER BY rp.events DESC,p.pod DESC LIMIT 20
0.0022  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=28570 AND rel.round=8
0.0019  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 = 28570 AND esl.points > 0 ORDER BY esl.points DESC LIMIT 3
0.0019  SELECT count(esl.user_id) as cuenta FROM editor_stats_leagues esl INNER JOIN fa_user u ON u.id = esl.user_id INNER JOIN fa_user_profile up ON up.id = esl.user_id WHERE esl.league_id = 28570 AND esl.points > 0
0.0020  SELECT fau.user_name, c.*, NOW() as difference_time,creation_date FROM (leagues as l) INNER JOIN comments as c ON c.league_id = l.id LEFT JOIN fa_user fau ON fau.id = c.author_id WHERE c.creation_date > "2024-03-29" AND c.`active`= 1 and c.comment_id is null and c.lang = 1 AND l.`id` = 28570 ORDER BY creation_date DESC LIMIT 0, 10
0.0023  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` = 28570
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 `calendars2006` 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` = 28570 AND c.`round` = 8 ORDER BY shedule ASC LIMIT 200
0.0018  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 `events2006` e INNER JOIN calendars2006 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 = 8 AND e.real_date IS NOT NULL AND e.league_id = 28570 ORDER BY total DESC LIMIT 40
0.0021  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 `events2006` e INNER JOIN calendars2006 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 = 28570 AND e.real_date > NOW() - INTERVAL 1 MONTH ORDER BY e.real_date DESC LIMIT 30
0.0020  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 `tables2006` 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 = 28570 AND t.round = 6 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0020  SELECT *,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables2006` 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 = 28570 AND t.round = 8 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0020  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 = 28570 ORDER BY c.shedule ASC, fcoef DESC LIMIT 5
0.0020  SELECT data1, data2 FROM services_tags WHERE categoryId=1713
0.0020  SELECT l.year,l.group_code FROM leagues_besoccer l WHERE l.categoryId = 1713 AND l.year = 2006 ORDER BY l.group_code ASC
0.0020  SELECT group_code, extraName from `leagues` WHERE categoryId=1713 AND year=2006