4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
« Temporada Anterior
Temporada 2001
Temporada Siguiente »
Publicidad 600x120.gif
Perú - Liga 1 Fase 2 2001
2000/2001

Perú - Liga 1 Fase 2 2001

Información Histórica 
						
Clausura


Round 1
[Jul 28]
Melgar        2-0 Juan Aurich 
  [Nelson Gómez 26, Carlos Castillo 73]
Alianza Lima  2-1 Wanka 
  [Edú Esidio 22, Ernesto Arakaki 89; Sergio Godoy 36]
Cristal       4-0 Cienciano 
  [Jorge Soto 51, 81, Piero Alva 75, Herly Alcazar 79]
[Jul 29] 
Alianza Atl.  0-1 Estudiantes 
  [Paul Cominges 90] 
[Jul 30] 
Union Minas   1-0 Universitario 
  [Roberto Rengifo 62] 
[Aug 1] 
Sport Boys    2-1 Coopsol 
  [German Muñoz 24, Romulo Fernandez 50; Juan Saavedra 39pen]

Round 2
[Aug 4]
Universitario 1-0 Alianza Atletico 
  [Fernando del Solar 31]
[Aug 5]
Coopsol       1-4 Melgar 
  [Farley Hoyos 12; Leonardo Uehara, Paulo Cesar Cruvinel 69,
   Carlos Castillo 75, 92] 
Wanka         1-0 Unión Minas 
  [Jorge Ramírez 50pen]
Juan Aurich   0-1 Sport Boys 
  [Johan Fano 81]
Cienciano     4-2 Alianza Lima 
  [Martín García 18, Miguel Ortega 55, 73, Frank Palomino 87pen;
   Henry Quinteros 23, Waldir Sáenz 59] 
Estudiantes   1-2 Cristal 
  [Paul Cominges 72; Piero Alva 15, Herly Alcazar 54]

Round 3 
[Aug 11]
Cristal       1-0 Alianza Lima 
  [Jorge Soto 78]
Melgar        1-0 Alianza Atl
  [Carlos Castillo 76]
[Aug 12]
Union Minas   2-0 Coopsol 
  [Hansel Arriaga 39, Héctor Gallardo 51]
Cienciano     2-0 Sport Boys 
  [Pedro Prado 10, Gabriel Rodríguez 90pen]
Juan Aurich   0-0 Wanka
Universitario 1-1 Estudiantes 
  [Martín Vilallonga (pen); Víctor Reyes]

Round 4
[Aug 18] 
Alianza Lima  1-0 Union Minas 
  [Henry Quinteros 47] 
Coopsol       3-1 Cristal 
  [Jorge Soto 18og, Marcelo Millán 25, 78; Jorge Soto 45]
[Aug 19]
Alianza Atl   2-0 Cienciano 
  [Pedro Garcia 16, Alex Becerra 83] 
Estudiantes   1-0 Juan Aurich 
  [Pedro Miranda 92] 
Wanka         2-0 Universitario 
  [Jorge Ramirez 37, 93] 
Sport Boys    1-0 Melgar 
  [Miguel Zagaceta 67] 

Round 5 [Aug 26] 
Universitario 2-0 Coopsol 
  [Sergio Ibarra 84, Martín Vilallonga 86] 
Cristal       3-0 Alianza Atlético 
  [Luis Bonnet 47, Jorge Soto 60, Julinho 80] 
Juan Aurich   2-1 Alianza Lima 
  [Angel Villalta 22, Cesar Sanchez 54; Ernesto Arakaki 58] 
Melgar        4-1 Wanka 
  [Leonardo Uehara 23, Carlos Castillo 45, Paulo César Cruvinel 52, 
   Leonardo Enciso 90; Jorge Ramírez 43pen] 
Minas         2-0 Sport Boys 
  [Jose Corcuera 22og, Victor Larrahondo 90]
Cienciano     4-1 Estudiantes 
  [Ernesto Zapata 37, Frank Palomino 46, Mauricio Martínez 59,
   Jean Garrafa 86; Paul Cominges 53]

Round 6 
[Aug 30] 
Sport Boys    1-0 Cristal 
  [Johan Fano 36] 
Alianza Atl   3-2 Union Minas 
  [Alejandro Cipriano 5, Pedro García 38, Carlos Zegarra 62; David Chévez 16, 
   Álvaro Torres 70]
Universitario 2-1 Alianza Lima 
  [Martin Vilallonga 16, 24; Roberto Farfan 52] 
[Sep 2]
Wanka         2-3 Cienciano 
  [Sergio Godoy 22, Jorge Ramirez 32pen; Carlos Cumapa 40, Mauricio Martínez 43,
   Ernesto Zapata 52]
Estudiantes   1-2 Melgar 
  [Paul Cominges 22; Jorge Reyes 56, Gabriel Varillas 72] 
Juan Aurich   1-1 Coopsol 
  [Lino Morán 54; Wilkin Cavero 90]

Round 7
[Sep 8] 
Sport Boys    2-2 Universitario 
  [Jair Iglesias 15, Johan Fano 69; Sergio Ibarra 21, Fernando del Solar 89]
Cristal       1-0 Wanka 
  [Luis Bonnet 8]
Alianza Lima  0-1 Melgar 
  [Alexis Aguirre 79] 
[Sep 9]
Alianza Atl   3-1 Juan Aurich 
  [Juan Arango 6, Alejandro Cipriano 52, Carlos Zegarra 59; Lino Morán 67]
Minas         1-3 Estudiantes 
  [Alvaro Torres 88pen; Luis Galliquio 27, Cesar Charún 73, Alex Magallanes 76]
Coopsol       4-0 Cienciano 
  [Juan Saavedra 6, Amilton Prado 30, Rodrigo Saraz 53, 81]

Round 8 
[Sep 15] 
Coopsol       0-0 Alianza Lima 
[Sep 16]
Melgar        0-3 Cristal 
  [Luis Bonnet 13, 53, Gaston Cordoba 48]
Universitario 5-2 Aurich 
  [Martin Vilallonga 12, 31, Sergio Ibarra 28, 46, Gregorio Bernales 74;
   José Guevara 45, Lino Morán 90pen] 
Estudiantes   2-1 Sport Boys 
  [Carlos Barrionuevo 26, William Rivera 41; Johan Fano 8] 
Cienciano     2-1 Union Minas 
  [Luis Molina 5, Ernesto Zapata 33; Victor Larrahondo 36] 
Wanka         1-0 Alianza Atletico 
  [Roberto Dolorier 12]

Round 9 
[Sep 22] 
Sport Boys    4-1 Wanka 
  [Rafael Villanueva 26, 46, 77, Bratzo Gil 53; Marcio 15]
[Sep 23]
Alianza Lima  1-2 Alianza Atl. 
  [Waldir Saenz 47; Carlos Zegarra 31, 65]
Cienciano     1-0 Universitario 
  [Ernesto Zapata 62] 
Juan Aurich   0-1 Cristal 
  [Luis Bonnet 5] 
Estudiantes   1-0 Coopsol 
  [German Carty 37]
Union Minas   1-1 Melgar 
  [Miguel Magallanes 40; Leonardo Enciso 90pen]

Round 10
[Sep 26] 
Alianza Atl.  0-0 Coopsol 
Juan Aurich   4-2 Minas 
  [Nilson Alvarez 31, 62, Cesar Balbin 50, Renato Brasilia 67;
   Jean Pierre Moreno 57, 87] 
Wanka         0-2 Estudiantes 
  [Cesar Charun 70, Paul Cominges 90pen] 
Melgar        1-2 Cienciano 
  [Leonardo Uehara 57; Martin Garcia 30, Ernesto Zapata 75pen]
[Oct 3]
Cristal       1-0 Universitario 
  [Luis Bonnet 25]
Alianza Lima  2-0 Sport Boys 
  [Roberto Farfan 17, Henry Quinteros 69]

Round 11 
[Sep 29] 
Coopsol       0-0 Wanka 
Sport Boys    2-0 Alianza Atletico 
  [Johan Fano 11, Alonso Alcibar]
Universitario 2-0 Melgar 
  [Sergio Ibarra 27, Martin Vilallonga 69]
[Sep 30]
Cienciano     2-0 Juan Aurich 
  [Ernesto Zapata 48, Mauricio Martinez 559
Estudiantes   2-2 Alianza Lima 
  [Paul Cominges 48, 53; Henry Quinteros 10, Waldir Saenz 65] 
Unión Minas   1-3 Cristal 
  [Carlos Dueñas 82; Jorge Soto 7, José Moisella 85, Roberto Palacios 89]

Round 12
[Oct 7]
Juan Aurich   0-1 Melgar
  [Gabriel Varillas 56]
[Oct 10]
Cienciano     4-1 Cristal
  [Mauricio Martinez 37, 81, Carlos Maldonado 54, Christian Garcia 89;
   Jorge Soto 13]
Estudiantes   2-0 Alianza Atl.
  [Cesar Charun 47, Ruben Diaz 60]
Coopsol       1-2 Sport Boys 
  [Rodrigo Saraz 60; Johan Fano 66pen, Romulo Fernandez 91]
[Oct 17]
Wanka         0-0 Alianza Lima  
Universitario 2-0 Unión Minas
  [Martin Vilallonga 16pen, Jorge Araujo 58]

Round 13 
[Oct 13] 
Melgar        1-2 Coopsol 
  [Alexis Aguirre 10; Rodrigo Saraz 12, Manuel Lopez 92pen] 
Alianza Lima  0-0 Cienciano 
[Oct 14]
Cristal       1-1 Estudiantes 
  [Roberto Palacios 92; Paul Cominges 19] 
Sport Boys    0-2 Juan Aurich 
  [Aldo Mora 6, Johny Mujica 89]
Alianza Atl   0-0 Universitario 
Union Minas   1-1 Wanka 
  [Julio Garcia 5; Jorge Ramirez 61]

Round 14 
[Oct 20]
Coopsol       5-2 Union Minas 
  [Amilton Prado 20, Félix Otoya 40, Oscar Dertycia 52, 73, Martín Reyes 68;
   David Chevez 13, Wilfredo Begazo 76]
Alianza Lima  0-0 Sporting Cristal 
[Oct 21]
Estudiantes   1-0 Universitario 
  [German Carty 59]
Sport Boys    2-2 Cienciano 
  [Roberto Martinez 20, Romulo Fernandez 47; Ernesto Zapata 35pen,
   Miguel Ortega 74]
Alianza Atl   2-1 Melgar 
  [Juan Arango 53, Manuel Medina 71; Carlos Castillo 63]
Wanka         3-0 Juan Aurich 
  [Jorge Ramirez 42pen, 85, Santiago Acasiete 82]

Round 15 
[Oct 27]
Juan Aurich   2-3 Estudiantes
  [Renato Brasilia 25, Jose Guevara 61pen; German Carty 31, Frank Aguirre 50,
   Paul Cominges 71]
Universitario 2-1 Wanka
  [Paolo Maldonado 30, Julio Rivera 44; Jorge Ramirez 37pen]
Cristal       1-2 Coopsol
  [Luis Bonnet 11; Oscar Dertycia 25, 67]
[Oct 28]
Cienciano     2-0 Alianza Atletico
  [Miguel Ortega 52, Oscar Olvera 60]
Melgar        1-2 Sport Boys 
  [Alfonso Dulanto 49; Johan Fano 46, Alonso Alcibar 89]
Union Minas   1-0 Alianza Lima 
  [Wilfredo Begazo 41]

Round 16 
[Nov 1]
Coopsol       2-2 Universitario
  [Amilton Prado 29, Rodrigo Saraz 59; Fernando del Solar 19, Sergio Ibarra 65]
Alianza Atl   2-1 Cristal
  [Alex Becerra 62, Alejandro Cipriano 87; Jorge Soto 49]
Alianza Lima  3-0 Juan Aurich
  [Roberto Farfan 17, 19, Palhinha 44]
[Nov 2]
Sport Boys    1-1 Minas
  [Rafael Villanueva 84; Walter Rojas 66]
Estudiantes   2-1 Cienciano
  [Rubén Díaz 56pen, César Charún 93; Ernesto Zapata 33pen]
[Nov 4]
Wanka         1-0 Melgar
  [Dante Chumpitaz 75]

Round 17
[Nov 10]
Coopsol       2-2 Juan Aurich 
  [Oscar Dertycia 16, Amilton Prado 70; Rodolfo Miñan 33, Angel Villalta 88]
[Nov 11]
Melgar        0-1 Estudiantes 
  [Germán Carty 66]
Alianza Lima  1-1 Universitario 
  [Roberto Holsen 92; Paolo Maldonado 13]
Union Minas   1-1 Alianza Atletico 
  [David Chevez 6; Luis Bello 86]
Cienciano     2-1 Wanka
  [Mauricio Martinez 64, Martin Garcia 74; Roberto Dolorier 52]
Cristal       4-2 Sport Boys 
  [José Moisella 18pen, Julinho 49, Jorge Soto 60, Piero Alva 77;
   José Chacón 45, Carlos Lobatón 85]

Round 18
[Nov 17] 
Wanka         1-0 Cristal 
  [Dante Chumpitaz 56] 
[Nov 18] 
Universitario 1-1 Sport Boys 
  [Gregorio Bernales 55; Bratzo Gil 71] 
Cienciano     4-2 Coopsol 
  [Carlos Cumapa 2, 59, Miguel Ortega 23, Ernesto Zapata 44; ?] 
Estudiantes   2-1 Unión Minas 
  [Juan Saavedra 21, Rodrigo Saraz 71; ?]
Melgar        4-4 Alianza Lima 
  [Marco Sánchez 11, Leonardo Enciso 61pen, Edwin Pérez 67, Jorge Reyes 70; 
   Waldir Sáenz 10, 27, Roberto Farfán 26, Palhinha 42]
Juan Aurich   2-3 Alianza Atlético 
  [José Guevara 28, 68pen; Carlos Zegarra 58, 66, Pedro García 87]

Round 19
[Nov 24]
Cristal       4-3 Melgar 
  [Jean Ferrari 45, Herly Alcazar 69, Julinho 71, Gaston Cordoba 78pen;
   Marco Sanchez 16, Carlos Castillo 31, 48]
Sport Boys    2-1 Estudiantes 
  [Omar Zegarra 69, Johan Fano 79pen; Ruben Diaz 17] 
[Nov 25]
Minas         0-1 Cienciano 
  [Oscar Olvera 48] 
Alianza Atl   1-0 Wanka 
  [Alex Becerra 38] 
Alianza Lima  2-2 Coopsol 
  [Henry Quinteros 41, Edú Esidio 91; Oscar Dertycia 55, 90]
Juan Aurich   1-1 Universitario 
  [José Guevara 97pen; José del Solar 45]

Round 20 
[Dec 1]
Universitario 4-1 Cienciano 
  [Abel Lobatón 54, Mario Gómez 67, Carlos Orejuela 74, Paolo Maldonado 91; 
   Pedro Prado 46]
Cristal       1-0 Juan Aurich 
  [Luis Bonnet 83]
[Dec 2]
Coopsol       3-4 Estudiantes 
  [Juan Saavedra 10, Amilton Prado 45, Rodrigo Saraz 67; Paul Cominges 39, 70, 
   Carlos Barrionuevo 50, German Carty 57]
Alianza Atl   2-1 Alianza Lima 
  [Pedro García 36, Juan Arango 61; Juan Bazalar 67]
Wanka         2-1 Sport Boys
  [Jorge Ramírez 7, Dante Chumpitaz 82pen; Johan Fano 18]
Melgar        1-2 Union Minas 
  [Héctor Arenas 18; Wilfredo Begazo 32, Victor Larrahondo]

Round 21 
[Dec 8]
Sport Boys    1-1 Alianza Lima 
  [Johny Vegas 85pen; Waldir Sáenz 20]
[Dec 9]
Cienciano     1-0 Melgar
  [Mauricio Martínez 21] 
Estudiantes   0-2 Wanka
  [Santiago Acasiete 41, Jorge Ramírez 59]
Universitario 1-3 Sporting Cristal 
  [Abel Lobatón 32; Julinho 39, Jorge Soto 47, Luis Bonnet 62]
Coopsol       0-1 Alianza Atletico 
  [Pedro García 87]
Union Minas   2-2 Juan Aurich 
  [David Chévez 21, 63pen; Carlos Lugo 34pen, Nilson Alvarez 83]

Round 22 
[Dec 12]
Alianza Atl   3-1 Sport Boys
  [Carlos Zegarra 8, Pedro Garcia 48, Alex Becerra 93; Carlos Lobaton 6]
Melgar        2-0 Universitario
  [Marco Sanchez 46, Leonardo Enciso 92]
[Dec 16]
Alianza Lima  1-2 Estudiantes
  [Roberto Holsen 74; German Carty 13, Carlos Barrionuevo 48]
Cristal       8-3 Union Minas
  [Julinho 13, 36, 93, Luis Bonnet 21, 60, 69, Manuel Marengo 39, 
   David Soria 57; Victor Larrahondo 38, David Chévez 65, 80]
Wanka         1-4 Coopsol
  [Jorge Ramírez 91pen; Manuel Ugaz 68, Manuel López 72, Rodrigo Saraz 76, 
   Juan Saavedra 84]
Juan Aurich   1-1 Cienciano
  [Rodolfo Miñán 10; Carlos Cumapa 35]

Final Table:

 1.Cienciano               22 14  3  5  39-30  45
 2.Estudiantes de Medicina 22 14  3  5  35-26  45
 3.Sporting Cristal        22 14  2  6  44-25  44
 4.Alianza Atlético        22 11  3  8  25-24  36
 5.Sport Boys              22  9  5  8  29-31  32
 6.Universitario           22  8  7  7  29-24  31
 7.Deportivo Wanka         22  8  4 10  22-27  28
 8.Melgar                  22  8  2 12  30-31  26
 9.Coopsol Trujillo        22  6  7  9  35-35  25
10.Alianza Lima            22  4  9  9  25-28  21
11.Unión Minas             22  5  5 12  27-42  20
12.Juan Aurich             22  3  6 13  22-39  15

Clausura Playoff [Dec 19, Arequipa]
Cienciano     1-0 Estudiantes
  [Ernesto Zapata 18]

Championship Playoff

First Leg [Dec 22]
Alianza Lima  3-2 Cienciano
  [Waldir Saenz 20, Jose Soto 57, Roberto Farfan 90; Carlos Cumapa 29,
   Ernesto Zapata 35pen]

Second Leg [Dec 26]
Cienciano     1-0 Alianza Lima           [2-4 pen]
  [Ramon Rodriguez 83]
  [penalties:
    Alianza: scored: Jose Soto, Henry Quinteros, Roger Serrano, Waldir Saenz
             missed: Roberto Holsen 
    Cienciano: scored: Luis Molina, Christian Garcia
               missed: Martin Garcia, Ernesto Zapata]

Alianza Lima champions


Author: Eli Schmerler 
(e_schmerler@hotmail.com)

Last updated: 20 Oct 2004

(C) Copyright Eli Schmerler and RSSSF 2001/04


  USO DE MEMORIA  
4,265,152 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0021
Controller Execution Time ( Home / Category )  0.1142
Total Execution Time  0.1164
  CADENA URL  
/clausura_peru2001
  GET DATOS  
$_GET['/clausura_peru2001']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (37)  
0.0018  SELECT type FROM routes WHERE alias = 'clausura_peru2001'
0.0041  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'clausura_peru' 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=53 AND type_rel = 3
0.0031  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 3 AND rel.typeId = 53 AND rel.ln = 'es' AND rel.status=1 ORDER BY rel.creation_date desc,rel.cover_points DESC LIMIT 5
0.0023  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 (1217683,1197918,1196384,1196209,1195528) ORDER BY n.cover_points DESC, update_date DESC
0.0023  SELECT text_es as historical_text FROM leagues_text WHERE id=1247
0.0020  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 = 29525 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=45 ORDER BY l.group_code ASC
0.0019  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-04-27 05:39:55' 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-27 05:39:55' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0021  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=4 AND last_update > '2024-04-27 05:39:55' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0021  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=3 AND last_update > '2024-04-27 05:39:55' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0030  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'clausura_peru' 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.0022  SELECT e.action, count(e.action) as total, e.player_id FROM events2001 e WHERE e.league_id IN (29525) 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.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 (29525) 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 events2001 e WHERE e.league_id IN (29525) AND (e.action IN (4,5) ) 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 (29525) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN () ORDER BY rp.in_squad = 1 DESC
0.0024  SELECT e.action, count(e.action) as total, e.player_id FROM events2001 e WHERE e.league_id IN (29525) AND (e.action IN (3,4) ) GROUP BY e.player_id ORDER BY total DESC, e.player_id ASC LIMIT 20
0.0024  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 (29525) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN () ORDER BY rp.in_squad = 1 DESC
0.0025  SELECT e.action, count(e.action) as total, e.player_id FROM events2001 e WHERE e.league_id IN (29525) AND (e.action IN (22) ) GROUP BY e.player_id ORDER BY total DESC, e.player_id ASC LIMIT 20
0.0026  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 (29525) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN () ORDER BY rp.in_squad = 1 DESC
0.0023  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 = 29525 AND rp.lineup > 0 ORDER BY rp.lineup DESC,p.pod DESC LIMIT 20
0.0021  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 = 29525 AND rp.events > 0 ORDER BY rp.events DESC,p.pod DESC LIMIT 20
0.0034  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=29525 AND rel.round=22
0.0028  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 = 29525 AND esl.points > 0 ORDER BY esl.points DESC LIMIT 3
0.0028  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 = 29525 AND esl.points > 0
0.0026  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-28" AND c.`active`= 1 and c.comment_id is null and c.lang = 1 AND l.`id` = 29525 ORDER BY creation_date DESC LIMIT 0, 10
0.0042  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-28" AND c.`active`= 1 and comment_id is null and c.lang = 1 AND l.`id` = 29525
0.0028  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` = 29525 AND c.`round` = 22 ORDER BY shedule ASC LIMIT 200
0.0020  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 = 22 AND e.real_date IS NOT NULL AND e.league_id = 29525 ORDER BY total DESC LIMIT 40
0.0029  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 = 29525 AND e.real_date > NOW() - INTERVAL 1 MONTH ORDER BY e.real_date DESC LIMIT 30
0.0030  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 = 29525 AND t.round = 20 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0030  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 = 29525 AND t.round = 22 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0030  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-27 00:00:00' AND c.`shedule` < '2024-05-01 23:59:59' AND l.id = 29525 ORDER BY c.shedule ASC, fcoef DESC LIMIT 5
0.0030  SELECT data1, data2 FROM services_tags WHERE categoryId=53
0.0030  SELECT l.year,l.group_code FROM leagues_besoccer l WHERE l.categoryId = 53 AND l.year = 2001 ORDER BY l.group_code ASC
0.0030  SELECT group_code, extraName from `leagues` WHERE categoryId=53 AND year=2001