4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Publicidad 600x120.gif
Clausura Uruguay 2001
2000/2001

Clausura Uruguay 2001

  • Liga Uruguay
Información Histórica
						Torneo Clausura

Final Table:

 1.Nacional                    9  6  3  0 19- 7 21  Clausura Winners
 2.Danubio                     9  6  0  3 19-13 18
 3.Peñarol                     9  5  1  3 11-10 16
 4.Defensor Sporting           9  4  1  4 15-18 13
 5.Montevideo Wanderers        9  3  3  3 12-10 12
 6.Juventud (Las Piedras)      9  3  4  2 12-11 10  [*]
 7.Deportivo Tacuarembó        9  3  1  5  9- 9 10
 8.Fénix                       9  2  4  3 10-12 10
 9.Bella Vista (Paysandú)      9  2  3  4 13-18  9
10.Bella Vista (Montevideo)    9  1  0  8  8-20  3

[*] Juventud had 3 points deducted for fielding an ineligible player
    in round 1

Round 1 [Sep 15,16]
Danubio           2-1 Wanderers  
Fénix             1-1 Nacional      
Defensor Sporting 3-1 Bella Vista
Tacuarembó        3-0 Paysandú
Juventud          1-0 Peñarol  

Round 2
[Sep 19]
Juventud          2-1 Bella Vista
  [Carlos Macchi 25, Marcelo Paredes 49; Rodrigo Lemos 43pen] 
Nacional          4-0 Danubio
  [Marco Vanzini 17, Sebastián Abreu 51, Milton Núñez 59, Damián Rodríguez 71] 
Paysandú          4-0 Defensor Sporting
  [Gustavo Da Silva 3, Egidio Ríos 33, Alcides Bandera 54, 83] 
[Sep 20]
Wanderers         1-0 Tacuarembó
  [Alejandro Larrea 22pen] 
Peñarol           3-2 Fénix
  [Adao 9, Gabriel Cedrés 77, Fabián Canobbio 87; Fernando Fajardo 32,
   Javier Cámpora 90]

Round 3 
[Sep 22]
Paysandú          1-1 Nacional 
  [Alcides Bandera 46; Oscar Morales 29] 
[Sep 23]
Defensor Sporting 2-3 Peñarol 
  [Eliomar Marcón 22, Gabriel Bordi 59; Carlos Bueno 15, Darío Rodríguez 26, 
   Pablo Bengoechea 69pen]           
Wanderers         1-1 Juventud
  [Julio De Souza 90; Marcelo Rosano 60] 
Bella Vista       2-3 Danubio 
  [Henry López Báez 63, Álvaro González 65; Ruben Olivera 22, 30, 
   Ignacio Risso 25]  
Tacuarembó        0-1 Fénix
  [Martín Arriola 25] 

Round 4
[Sep 26]
Danubio           5-0 Paysandú
  [Rubén Da Silva  1, Rubén Olivera 16, Ignacio Risso 63, Diego Perrone 85,
   Rodrigo López 90] 
Fénix             2-0 Defensor Sporting
  [Omar Pérez 83, Fernando Fajardo 90] 
Bella Vista       1-4 Wanderers
  [Rodrigo Lemos 76pen; Sergio Blanco 3, 77, Sebastián Eguren 14, 
   Rodrigo Bengua 67] 
Juventud          0-1 Nacional
  [Sebastián Abreu 88] 
[Oct 6]
Tacuarembó        0-1 Peñarol   
  [Carlos Bueno 60]

Round 5
[Sep 29]
Danubio           0-1 Defensor
  [Gabriel Bordi 45]
Peñarol           1-0 Bella Vista
  [Fabián Canobbio 29]
[Sep 30]
Fénix             0-0 Wanderers
Juventud          2-2 Paysandú
  [Christian Castellanos 80, Leonardo Sum 90; Pablo Iglesias 37pen,
  Julio Merentiel 65]
Nacional          2-1 Tacuarembó
  [Richard Morales 10, 52; Horacio Erpen 83]

Round 6 [Oct 10]
Bella Vista       1-0 Fénix
  [Marcos Bassini 6] 
Defensor Sporting 2-3 Juventud 
  [Marcelo Tejera 62, Diego Pérez 82; Christian Castellano 22, 43,
   Juan Pablo Péndola 41] 
Tacuarembó        1-0 Danubio 
  [Ruben Acosta 87] 
Wanderers         1-2 Nacional  
  [Ronald Ramírez 50; Sebastián Abreu 29, 34] 
Paysandú          0-1 Peñarol  
  [Gabriel Cedrés 56] 

Round 7
[Oct 13]
Nacional          3-0 Bella Vista
  [Gustavo Varela 32, Marco Vanzini 45, Sebastián Abreu 53] 
[Oct 14]
Fénix             3-3 Paysandú
  [Martín Arriola 10, André González 45, Iván Pailós 81; Nelson Ponzo 11, 
   Paolo Patritti 42, Egidio Arévalo Ríos 71] 
Juventud          2-3 Danubio
  [Christian Castellanos 56, 72; Pablo Gaglianone 61, 63, Diego Perrone 80] 
Tacuarembó        1-2 Defensor Sporting
  [Luis Cor 73pen; Eliomar Marcón 30, 46] 
Wanderers         1-1 Peñarol  
  [Sebastián Eguren 46; Adao Fonseca 32] 

Round 8 
[Oct 20]
Danubio           2-1 Peñarol  
  [Martín Ojeda 77, Ignacio Risso 85; Adao Fonseca 3] 
[Oct 21]
Paysandú          1-2 Wanderers
  [Julio Ramírez 21og; Fernando Machado 24, Andrés Scotti 30] 
Juventud          0-0 Fénix
Defensor Sporting 3-3 Nacional
  [Marcelo Lipatín 40, Andrés Martínez 71, Marcelo Tejera 93;
   Sebastián Abreu 5, 79pen, Alejandro Lembo 91] 
Bella Vista       1-2 Tacuarembó
  [Diego Emanuele 12; Rafael Refatti 36, Rubén Acosta 58] 

Round 9 
[Oct 26]
Defensor Sporting 2-1 Wanderers 
  [Eliomar 22, Martín Liguera 64;Sergio Blanco 50]
[Oct 27]
Danubio           4-1 Fénix 
  [Ignacio Risso 9, 36, Bruno Silva 21, Ruben Da Silva 35; Fernando Fajardo 85] 
Bella Vista       1-2 Paysandú
  [Marco Bassini 21; Juan Bicca 41, Alcides Bandera 77pen] 
Tacuarembó        1-1 Juventud 
  [Diego Rariz 48; Enrique Ferraro 88]
Peñarol           0-2 Nacional
  [Sebastián Abreu 53pen, Richard Morales 70]

Final Table:

 1.Nacional                    9  6  3  0 19- 7 21  Clausura Winners
 2.Danubio                     9  6  0  3 19-13 18
 3.Peñarol                     9  5  1  3 11-10 16
 4.Defensor Sporting           9  4  1  4 15-18 13
 5.Montevideo Wanderers        9  3  3  3 12-10 12
 6.Juventud (Las Piedras)      9  3  4  2 12-11 10  [*]
 7.Deportivo Tacuarembó        9  3  1  5  9- 9 10
 8.Fénix                       9  2  4  3 10-12 10
 9.Bella Vista (Paysandú)      9  2  3  4 13-18  9
10.Bella Vista (Montevideo)    9  1  0  8  8-20  3

[*] Juventud had 3 points deducted for fielding an ineligible player
    in round 1

Nacional qualify to championship final



Championship Final [Dec 2, 5 and 9 (if necessary)]
 
First Leg [Dec 2]
Nacional          2-2 Danubio
  [Sebastián Abreu 32, Marco Vanzini 36; Raúl Cardozo 11og, Rubén Da Silva 15]
  [Nacional: Gustavo Munúa; Martín Del Campo, Alejandro Lembo, Damián Rodríguez,
     Raúl Cardozo (46 Jorgeao); Marco Vanzini, Oscar Morales, Gustavo Varela
     (77 Walter Coelho), Limberg Gutiérrez (62 Carlos Camejo); Sebastián Abreu,
     Richard Morales; D.T.: Hugo De León.
   Danubio: Jorge Contreras; Eber Moas, Máximo Lucas, Walt Báez; Jorge Anchén,
     Pablo Gaglianone, Marcelo Sosa, César Pellegrín (87 Bruno Silva),
     Ruben Olivera; Rubén Da Silva, Ignacio Risso; D.T.: Ariel Krasosuki.         
   ref: Jorge Larrionda (ass.: Marcelo Gadea, Adrián Climent);
   red cards: Vanzini (N, 37), Sosa (D, 37);
   yellow: Nacional: Cardozo, Gutiérrez, Lembo, Varela, Rodríguez; 
           Danubio: Anchén, Moas, Olivera]

Second Leg [Dec 5, Estadio 'Domingo Burgueño', Maldonado, Maldonado]
Danubio           1-2 Nacional
  [Rubén Olivera 3; Sebastián Abreu 18, Gustavo Varela 60]
  [Danubio: Jorge Contreras, Eber Moas, Máximo Lucas, Walt Báez, Bruno Silva
     (62 Diego Perrone), Pablo Gaglianone, Jorge Anchén, César Pellegrín, 
     Ruben Olivera (81 Martín Ojeda), Ruben Da Silva, Ignacio Risso 
     (75 Rodrigo López); D.T.: Ariel Krasouski. 
   Nacional: Gustavo Munúa, Martín Del Campo, Alejandro Lembo, Damián Rodríguez, 
     Jorge Da Costa, Carlos Camejo, Oscar Morales, Limberg Gutiérrez 
     (61 Milton Núñez), Gustavo Varela (88 Ruben Sosa), Sebastián Abreu, 
     Richard Morales (61 Fabián Coelho); D.T.: Hugo De León. 
   ref: Saúl Feldman (ass: Walter Rial, Edgardo Acosta);
   yellow cards: 36 Richard Morales (N), 37 Bruno Silva (D), 57 Carlos Camejo (N),
                 60 Máximo Lucas (D), 77 Rodrigo López (D), 89 Gustavo Munúa (N)] 

  
Nacional qualify as champions for Copa Libertadores 2002 (as Uruguay No. 1)


Liguilla Pre-Libertadores

Overall Table (to determine participation in Liguilla)

 1.Danubio                    35 24  6  5 78-41 78  Qualified
 2.Peñarol                    35 23  7  5 59-33 76  
 3.Nacional                   35 20 10  5 71-36 70  
 4.Defensor Sporting          35 18  8  9 77-55 62  Qualified
 - - - - - - - - - - - - - - - - - - - - - - - - -
 5.Montevideo Wanderers       35 15 11  9 53-41 56  Qualified 
 6.Fénix                      35 15  7 13 57-46 52  Qualified  
 7.Bella Vista (Montevideo)   35 12  4 19 56-64 40
 8.Deportivo Tacuarembó       35 10 10 15 40-45 40
 9.Juventud (Las Piedras)     35  9  8 18 38-59 32  [*]
10.Bella Vista (Paysandú)     35  6 12 17 33-63 30

[*] Juventud had 3 points deducted for fielding an ineligible player
    in round 1 Clausura

NB: Montevideo Wanderers take the place of Peñarol, Fénix that of Nacional

Final Table:

 1.Montevideo Wanderers        3  2  1  0  8- 2  7  Winners
 2.Defensor Sporting           3  1  2  0  5- 3  5
 3.Danubio                     3  1  1  1  4- 6  4
 4.Fénix                       3  0  0  3  2- 8  0

Montevideo Wanderers qualify for Copa Libertadores 2002.

Round 1 [Dec 9]
Wanderers         4-1 Fénix
  [Fernando Machado 1, Walter Guglielmone 39, 67, 74; Sebastián Eguren 81og] 
Danubio           2-2 Defensor Sporting
  [Christian Callejas 62, Rodrigo López 85; Leonardo Rachid 80, Marcelo Tejera 84] 

Round 2 [Dec 12]
Fénix             1-2 Danubio
  [Sebastián Taborda 83; Ignacio Risso 10, Martín Ojeda 75]
Defensor Sporting 1-1 Wanderers
  [Juan Carlos Parra 11; Sebastián Eguren 58]

Round 3 [Dec 16]
Defensor Sporting 2-0 Fénix
  [Eliomar Marcón 54, 90]
Wanderers         3-0 Danubio
  [Walter Guglielmone 29, Claudio Dadomo 61, Jorge Martínez 80]

Final Table:

 1.Montevideo Wanderers        3  2  1  0  8- 2  7  Winners
 2.Defensor Sporting           3  1  2  0  5- 3  5
 3.Danubio                     3  1  1  1  4- 6  4
 4.Fénix                       3  0  0  3  2- 8  0

Montevideo Wanderers qualify for Copa Libertadores 2002.


Torneo Permanencia

14 rounds, points Clasificación are carried over; 2 teams from Montevideo and
1 from Interior to be relegated.

Final Table Montevideo:

11.Central Español            31 13  9  9 49-35 48
12.Cerro                      31 12  8 11 48-36 44
13.River Plate                31  8 13 10 25-37 37
15.Racing Sayago              31  7 12 12 32-45 33
--------------------------------------------------
16.Rentistas                  31  8  7 16 29-51 31  Relegated
18.Huracán Buceo              31  5 11 15 37-53 26  Relegated

and

Final Table Interior:

14.Deportivo Maldonado        31  8 10 13 31-48 34
--------------------------------------------------
17.Rocha                      31  6  8 17 35-59 26  Relegated

Round 1 [Aug 5]
Cerro             2-1 Huracán Buceo
  [Jorge Artigas 34, Darío Larrosa 44; Sebastián Donnángelo 40]  
Central Español   0-0 Rentistas 
Racing            0-0 River Plate 
Rocha             0-0 Maldonado 

Round 2
[Aug 11]
Rentistas         1-3 Cerro   
  [Daniel Gutiérrez 46; Guillermo Ubiña 64, Darío Larrosa 72, Horacio Peralta 85] 
[Aug 12]
Maldonado         1-3 Racing 
  [Luigi Rodríguez 11; Charles Castro 3, Diego Tito 33pen, Sebastián Araújo 88]        
Central Español   2-0 Rocha 
  [Javier Piña 65pen, Pablo Cuello 85]  
River Plate       1-0 Huracán Buceo 
  [Gustavo Díaz 77]       

Round 3 
[Aug 17]
Cerro             2-3 River Plate 
  [Germán Pérez 38, Jorge Artigas 65pen; Álvaro Melo 12, Marcelo Ramos 70,
   Gonzalo Lemes 90] 
[Aug 19]
Rocha             4-1 Rentistas
  [Rubén Rodríguez 20, 22, 25, Héber Caro 80; Marcelo Guerra 16]  
Maldonado         2-3 Central Español 
  [M.Silvera 75, Luigi Rodríguez 89pen; Javier Piña 30pen, Marcelo Durán 44,
   Miguel Messone 71] 
Huracán Buceo     1-1 Racing
  [Rafael Bianchi 81;  Adolfo Fatecha 73] 

Round 4 [Aug 26]
River Plate       0-0 Central Español 
Rocha             2-0 Huracán Buceo 
  [Andrés Muñiz 85, Héber Caro 88pen]
Rentistas         0-3 Maldonado 
  [Luiggi Rodríguez 12, 61pen, Maximiliano Castro 64]
Racing            0-0 Cerro 

Round 5 
[Sep 1]
Maldonado         1-1 River Plate
  [Richard Pérez 1; Gustavo Díaz 18pen]  
Cerro             5-2 Rocha 
  [Jorge Artigas 16, 40, 90, Darío Larrosa 45, Adrián Romero 85pen;
   Mario Carballo 50, Sergio Recoba 60] 
[Sep 2]
Central Español   2-1 Racing
  [Marcelo Durán 20, Hugo Costela 60; Fernando Kanapkis 68] 
Huracán Buceo     2-2 Rentistas 
  [Fernando Cardozo 33, Jorge Puglia 87; Marcelo Guerra 4, 85pen] 

Round 6 [Sep 8]
Cerro             0-1 Central Español 
  [Marcelo Durán 82]
Rentistas         1-3 River Plate 
  [Mauricio Weber 37; Gonzalo Lemes 1, Adrián Sarkissián 51,
   Carlos Gutiérrez 90]
Huracán Buceo     0-1 Maldonado 
  [Celestino Tejera 61]
Racing            3-1 Rocha 
  [César González 35, Diego Tito 57pen, Fernando Garrasino 80;  
   Martín González 53]
 
Round 7 
[Sep 15]
Maldonado         2-1 Cerro 
  [Luigi Rodríguez 1, 38; Jorge Artigas 42]
[Sep 16]
River Plate       1-1 Rocha 
  [Adrián Sarkissián 60; Martín González 7]
Central Español   6-1 Huracán Buceo 
  [Marcelo Durán 1, 46, 70, Hugo Costela 22, 23, Javier Piña 50pen;
   Raúl García 31]
Rentistas         4-2 Racing 
  [Daniel Gutiérrez 45, Rodrigo Vázquez 53, Mauricio Weber 67, Néstor Moráis 83;
   Adolfo Fatecha 15, Diego Tito 85pen]

Round 8
[Sep 22]
Maldonado         0-0 Rocha 
[Sep 23]
Rentistas         0-2 Central Español 
  [Hugo Costela 2, 15] 
Huracán Buceo     0-0 Cerro
River Plate       0-0 Racing

Round 9
[Sep 28]
Cerro             1-0 Rentistas
  [Adrián Romero 33pen]
[Sep 30]
Huracán Buceo     1-1 River Plate
  [Martín Siri 10; Everaldo Ferreira 85]
Rocha             1-0 Central Español 
  [Héctor Vázquez 43]
Racing            2-2 Maldonado
  [Diego Tito 12pen, Fernando Kanapkis 66; Luigi Rodríguez 40pen, 
   Maximiliano Castro 74]

Round 10 [Oct 14]
Central Español   1-2 Maldonado
  [Hugo Costela 43; Edgardo Martínez 82, Celestino Tejera 86]
Racing            1-3 Huracán Buceo
  [Fernando Kanapkis 20; Martín Siri 3, José Carini 58, Jorge Puglia 85] 
Rentistas         1-1 Rocha
  [Fabián Porley 18; Sergio Recoba 80]
River Plate       1-3 Cerro
  [Alejandro Mello 36; Hernán Pintos 4, Darío Larrosa 32, Jorge Artigas 90] 

Round 11
[Oct 19]
Cerro             1-1 Racing
  [Adrián Romero 85pen; Adolfo Fatecha 7] 
[Oct 20]
Maldonado         0-2 Rentistas
  [Ángel Gutiérrez 55, Fabián Porley 83] 
[Oct 21]
Central Español   3-1 River Plate
  [Leonardo Rojas 34, Marcelo Mansilla 38, Hugo Costela 77; Pedro González 86og] 
Huracán Buceo     2-0 Rocha
  [Ronald Fagúndez 28, José Carini 89] 

Round 29
[Oct 28]
Rocha             3-4 Cerro
  [Enrique Saravia 23, Mauricio Pérez 30, Sergio Recoba 64pen; Darío Larrosa 27, 
   Mario Carballo 32og, Adrián Romero 68pen, Alberto Ortega 85]
[Nov 4]
River Plate       1-0 Maldonado
  [Alejandro Mello 56]
Rentistas         0-0 Huracán Buceo
Racing            0-0 Central Español

Round 13 [Nov 11]
Central Español   0-0 Cerro
Maldonado         3-0 Huracán Buceo
  [Pablo Pallante 64, Alcides Machado 71, Christián Alfaro 88] 
River Plate       1-0 Rentistas
  [José Denis 90] 
Rocha             3-0 Racing
  [Héctor Méndez 20pen, Luis Magureguy 55, Julio Suárez 89] 

Round 14
[Nov 17]
Huracán Buceo     1-2 Central Español
  [Sebastián Donnángelo 81; Aníbal Ortega 69, Pablo Cuello 75] 
Rocha             0-0 River Plate
[Nov 18]
Racing            0-3 Rentistas
  [Danilo Baltiera 21, Mario Orta 87, Daniel Gutiérrez 90pen] 
Cerro             3-1 Maldonado
  [Marcelo Refresquini 33, Edgar Galeano 37, Alberto Gallo 81;
   Luigi Rodríguez 66pen] 

Final Table Montevideo:

11.Central Español            31 13  9  9 49-35 48
12.Cerro                      31 12  8 11 48-36 44
13.River Plate                31  8 13 10 25-37 37
15.Racing Sayago              31  7 12 12 32-45 33
--------------------------------------------------
16.Rentistas                  31  8  7 16 29-51 31  Relegated
18.Huracán Buceo              31  5 11 15 37-53 26  Relegated

and

Final Table Interior:

14.Deportivo Maldonado        31  8 10 13 31-48 34
--------------------------------------------------
17.Rocha                      31  6  8 17 35-59 26  Relegated


Author: Francisco Fernández
(ffernandez@espectador.com.uy)

Last updated: 8 Mar 2007

(C) Copyright Francisco Fernández and RSSSF 2001/07
						

INFORMACIÓN

La temporada oficial del Uruguayo de 1º División Profesional estará compuesta por el Torneo Apertura (equivalente a la primera rueda) y el Torneo Clausura (equivalente a la segunda rueda).
En donde el club que oficie de local en el primer torneo será visitante en el siguiente. Se adjudican tres puntos al club ganador, uno en caso de empate y cero punto en caso de derrota.
Si un club obtuviera el título de campeón del Torneo Apertura y también del Torneo Clausura, se consagrará campeón de la Copa Uruguaya. En este caso, el equipo que obtuviese el 2do.lugar en la tabla anual será designado Vicecampeón a los efectos de las clasificaciones a las Copas Internacionales.
La %u201CTabla Anual%u201D esta conformada segun la suma total de puntos de cada club en ambos torneos. El campeón de cada torneo será aquel que obtenga la mayor suma de puntos en cada uno de los mismos.
Si uno de los clubes campeones de los torneos Apertura y/o Clausura hubiera alcanzado el primer lugar en la Tabla Anual, la definición de la Copa Uruguaya se realizará de la siguiente manera: a)Se disputará un partido entre estos, de mantenerse la igualdad al término del mismo, se jugará un alargue de 30 minutos, en dos tiempos, de no haber vencedor, se definirá por la ejecución de tiros penales.
b) Si el vencedor de este partido coincide con el equipo que hubiese obtenido el primer lugar de la tabla anual, se consagrará campeón de la Copa Uruguaya.
c) Si el vencedor de este partido no coincide con el equipo que hubiese obtenido el primer lugar de la tabla anual, los mismos equipos pasarán a una serie de dos partidos de 90 minutos cada uno, por puntos. El equipo que obtenga más puntos al término del segundo partido, se consagrará campeón de la Copa Uruguaya
c2) Si al término del segundo partido, existiera igualdad de puntos entre los equipos, pero uno de estos alcanzare en la serie, una diferencia de goles a su favor, se consagrará campeón de la Copa Uruguaya.
c3) Si al término del segundo partido, existiera igualdad de puntos y la misma diferencia de goles entre ambos equipos, se disputará un alargue de 30 minutos y de no surgir un vencedor se definirá penales. El club ganador se consagrará campeón de la Copa Uruguaya.
c4) El club perdedor de esta serie de partidos, será el vicecampeón de la Copa Uruguaya.

  USO DE MEMORIA  
4,329,952 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0020
Controller Execution Time ( Home / Category )  0.1013
Total Execution Time  0.1033
  CADENA URL  
/clausura_uruguay2001
  GET DATOS  
$_GET['/clausura_uruguay2001']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (39)  
0.0018  SELECT type FROM routes WHERE alias = 'clausura_uruguay2001'
0.0039  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'clausura_uruguay' AND (l.group_code = 1 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 2001 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=52 AND type_rel = 3
0.0028  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 3 AND rel.typeId = 52 AND rel.ln = 'es' AND rel.status=1 ORDER BY rel.creation_date desc,rel.cover_points DESC LIMIT 5
0.0021  SELECT /*53 bs_news_model*/ n.id, n.author_id, n.headline, n.external_headline, n.live_headline, n.creation_date, n.update_date, n.pub_date, n.alias, n.subheadline, n.teaser, n.media, n.tags, n.views, n.screens, n.clicks, n.relations, n.comments, n.power_cover, n.cover_points, u.name as user_name FROM bs_news n INNER JOIN bs_editors u ON u.id = n.author_id AND u.ln = 'es' WHERE n.status = 1 AND n.ln = 'es' AND n.id IN (1293805,1289842,1278315,1230067,1213461) ORDER BY n.cover_points DESC, update_date DESC
0.0023  SELECT text_es as historical_text FROM leagues_text WHERE id=1821
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 = 30082 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0030  SELECT c.id, c.name, c.alias, l.id AS league_id, l.year, l.group_code, l.total_group, c.id AS categoryId, c.stepParent FROM categories AS c INNER JOIN leagues AS l ON c.id=l.categoryId AND c.active_year=l.year WHERE c.id=46 ORDER BY l.group_code ASC
0.0020  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='2024' WHERE c.parentId=46 GROUP BY c.id ORDER BY c.order_id ASC
0.0017  SELECT type,rule FROM rules WHERE categoryId = 52 ORDER BY type = 'tables_draw' DESC,type != 'extra' DESC, `order` ASC
0.0019  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-04-25 14:06:01' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0018  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=2 AND last_update > '2024-04-25 14:06:01' 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-25 14:06:01' 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-25 14:06:01' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0023  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'clausura_uruguay' AND (l.group_code = 0 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 2001 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 events2001 e WHERE e.league_id IN (30082) 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.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 (30082) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN () ORDER BY rp.in_squad = 1 DESC
0.0018  SELECT e.action, count(e.action) as total, e.player_id FROM events2001 e WHERE e.league_id IN (30082) AND (e.action IN (4,5) ) GROUP BY e.player_id ORDER BY total DESC, e.player_id ASC LIMIT 20
0.0018  SELECT dp.name, dp.last_name, dp.nick,dp.CountryCode,dp.alias,rp.team_id,dt.nameShow,dt.short_name,dt.basealias,rp.player_id,rp.teamId,dp.role FROM dataplayers AS dp INNER JOIN rel_players AS rp ON rp.player_id=dp.id AND rp.league_id IN (30082) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN () ORDER BY rp.in_squad = 1 DESC
0.0018  SELECT e.action, count(e.action) as total, e.player_id FROM events2001 e WHERE e.league_id IN (30082) 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 (30082) 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 events2001 e WHERE e.league_id IN (30082) AND (e.action IN (22) ) GROUP BY e.player_id ORDER BY total DESC, e.player_id ASC LIMIT 20
0.0019  SELECT dp.name, dp.last_name, dp.nick,dp.CountryCode,dp.alias,rp.team_id,dt.nameShow,dt.short_name,dt.basealias,rp.player_id,rp.teamId,dp.role FROM dataplayers AS dp INNER JOIN rel_players AS rp ON rp.player_id=dp.id AND rp.league_id IN (30082) 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 = 30082 AND rp.lineup > 0 ORDER BY rp.lineup DESC,p.pod DESC LIMIT 20
0.0018  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 = 30082 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=30082 AND rel.round=9
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 = 30082 AND esl.points > 0 ORDER BY esl.points DESC LIMIT 3
0.0023  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 = 30082 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-26" AND c.`active`= 1 and c.comment_id is null and c.lang = 1 AND l.`id` = 30082 ORDER BY creation_date DESC LIMIT 0, 10
0.0024  SELECT count(c.id) as cuenta FROM (leagues as l) INNER JOIN comments as c ON c.league_id = l.id WHERE c.creation_date > "2024-03-26" AND c.`active`= 1 and comment_id is null and c.lang = 1 AND l.`id` = 30082
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 `calendars2001` 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` = 30082 AND c.`round` = 9 ORDER BY shedule ASC LIMIT 200
0.0017  SELECT (dt1.qod+dt2.qod+dt1.relations+dt2.relations) as total,c.r1,c.r2,e.action,ev.showName as eventName,ev.largeName,ev.main_action,ev.keyname,ev.classf,e.real_date,e.minute, dp.nick,dp.CountryCode,dp.alias,c.datateam1,c.datateam2,dt1.nameShow as nameShow1,dt2.nameShow as nameShow2,dt1.basealias as basealias1,dt2.basealias as basealias2,e.player_id,e.match_id FROM `events2001` e INNER JOIN calendars2001 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 = 9 AND e.real_date IS NOT NULL AND e.league_id = 30082 ORDER BY total DESC LIMIT 40
0.0020  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 `events2001` e INNER JOIN calendars2001 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 = 30082 AND e.real_date > NOW() - INTERVAL 1 MONTH ORDER BY e.real_date DESC LIMIT 30
0.0022  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables2001` 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 = 30082 AND t.round = 7 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0022  SELECT *,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables2001` 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 = 30082 AND t.round = 9 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0022  SELECT c.id, 2024 AS year, IF(l.tables = 1 AND t1.points>0,((t1.points / (l.current_round * 3)) + (t2.points / (l.current_round * 3)))/2 * ct.coefficient,0.7 * ct.coefficient) as fcoef FROM `calendars2024` AS c INNER JOIN `leagues` AS l ON c.`league_id` = l.`id` INNER JOIN `categories` AS ct ON ct.`id` = l.`categoryId` LEFT JOIN tables2024 AS t1 ON t1.team = c.team1 AND t1.round = l.current_round LEFT JOIN tables2024 AS t2 ON t2.team = c.team2 AND t2.round = l.current_round WHERE c.`shedule` > '2024-04-25 00:00:00' AND c.`shedule` < '2024-04-29 23:59:59' AND l.id = 30082 ORDER BY c.shedule ASC, fcoef DESC LIMIT 5
0.0022  SELECT data1, data2 FROM services_tags WHERE categoryId=52
0.0022  SELECT l.year,l.group_code FROM leagues_besoccer l WHERE l.categoryId = 52 AND l.year = 2001 ORDER BY l.group_code ASC
0.0022  SELECT group_code, extraName from `leagues` WHERE categoryId=52 AND year=2001