Información Histórica
						
Friendly Matches  [Jan 21]
Pereira      2-3  América
  [Cardona 12, Ortero 79; González 27, Herrera 61, Vásquez 71]
Santa Fe     1-0  Millonarios
  [Díaz 44]
Envigado     0-2  Nacional
  [Mosquera 21, Salazar 72]
Cali         1-0  Tuluá
  [Bedoya 23]

Torneo Mustang I  (Feb 11-Jul 1) 

Final Table:

 1.Corporación Tuluá  22 12  6  4  30-19  42  Copa Libertadores 2002
 2.Deportivo Cali     22 11  5  6  31-21  38
 3.Once Caldas        22 11  5  6  35-27  38
 4.Deportes Tolima    22 11  3  8  34-28  36
 5.CD Indep Medellín  22  9  7  6  40-25  34
 6.Independ Santa Fe  22  9  7  6  28-23  34
 7.América            22 10  3  9  37-39  33
 8.Atlético Júnior    22  8  7  7  22-23  31
 9.CD Millonarios     22  8  4 10  29-23  28
10.Envigado FC        22  7  7  8  26-30  28
11.Deportes Pereira   22  8  3 11  26-34  27
12.Atlético Nacional  22  7  5 10  18-28  26
13.Real Cartagena     22  7  4 11  23-28  25
14.Atlético Huila     22  6  4 12  28-40  22
15.Atl Bucaramanga    22  4 10  8  10-18  22
16.Deportivo Pasto    22  5  6 11  23-34  21

Round 1
[Feb 10]
Envigado     2-1  Once Caldas
  [Molina 57pen, 85; Valentierra 61]
[Feb 11]
Pasto        0-0  Tolima
Millonarios  4-1  América
  [Orrego 26, Castro 46, 53, 82; Virviescas 71]
Cali         0-0  Santa Fe
Huila        0-2  Tuluá
  [Martínez 50, Ceballos 75]
Medellín     0-0  Junior
Pereira      1-0  Bucaramanga
  [Palacios 67]
Cartagena    2-0  Nacional
  [Quiñónez 56, Ramos 68]

Round 2  [Feb 18] 
Tuluá        2-1  Pasto 
  [Martínez 27pen, Muñoz 89; Rendón 50] 
Tolima       2-1  Millonarios 
  [Velásquez 59, Becerra 76; Jiménez 8] 
América      0-1  Cali 
  [Hernández 61] 
Santa Fe     1-2  Huila 
  [Cuenú 81; Redín 26, Hernández 64] 
Nacional     0-4  Medellín 
  [Serna 35, 69, 80pen, Rodas 75pen] 
Junior       3-1  Envigado 
  [Restrepo 8, Ballesteros 53, Marquinho 72pen; Montoya 19] 
Caldas       2-1  Pereira 
  [Díaz 54, Ocampo 90og; Cardona 71] 
Bucaramanga  1-1  Cartagena 
  [Guirán 69; Pérez 35] 

Round 3  [Feb 25]
Millonarios  0-1  Pasto
  [Rendón 14]
Cali         1-0  Tolima
  [Aristizábal 72]
Huila        5-0  América
  [Redín 12, 19pen, 41pen, 64, Da Silva 68]
Tuluá        1-0  Santa Fe
  [Cuenú 31og]
Envigado     3-2  Medellín
  [Molina 27, 62, 88pen; Rodas 74pen, Alvarez 78]
Pereira      2-1  Junior
  [Sánchez 26, Cano 35; Marquinho 7]
Cartagena    2-1  Caldas
  [Ramos 4, Bonilla 47; Valentierra 88pen]
Nacional     0-1  Bucaramanga
  [Vásquez 63]

Round 4
[Mar 3]
Envigado     0-1  Nacional
  [Salazar 24]
[Mar 4]
Millonarios  0-0  Tuluá
Pasto        2-2  Cali
  [Jaramillo 4, Rendón 77; Vásquez 42, Chará 86]
Tolima       1-0  Huila
  [Vidal 82]
América      3-2  Santa Fe
  [Mafla 37, Herrera 41, Vásquez 53; Flavién 8, García 45]
Medellín     3-0  Pereira
  [Serna 7, Rodas 41, 58pen]
Junior       1-0  Cartagena
  [Ballesteros 31]
Once Caldas  0-0  Bucaramanga

Round 5  [Mar 11]
Cali         2-0  Millonarios
  [Hernández 15, Quintana 49]
Huila        2-1  Pasto
  [Cantillo 12, Pizarro 88pen; Jaramillo 2]
Santa Fe     2-1  Tolima
  [Arboleda 61, Díaz 87; G.Martínez 49pen]
Tuluá        0-1  América
  [Roganovich 85pen]
Pereira      1-0  Envigado
  [Cano 38]
Cartagena    0-1  Medellín
  [Serna 12]
Bucaramanga  1-0  Junior
  [Rivas 24]
Nacional     1-2  Once Caldas
  [Guzmán 49; Galván 41, 70]

Round 6  [Mar 18]
Cali         1-1  Tuluá
  [Valenciano 64; Muñoz 76]
Millonarios  4-0  Huila
  [Gómez 47, Castro 51, 75, Moreno 90]
Pasto        0-1  Santa Fe
  [García 88]
Tolima       3-1  América
  [Vidal 5, 31, 93; Vásquez 19]
Pereira      2-0  Nacional
  [Cardona 14, Palacios 43]
Envigado     1-0  Real Cartagena
  [Trujillo 16]
Medellín     1-1  Bucaramanga
  [Montoya 73; Méndez 9pen]
Junior       1-1  Once Caldas
  [Zambrano 87; Galván 25]

Round 7  [Mar 25]
Huila        2-1  Cali
  [Cantillo 57, Paz 59; Hernández 18]
Santa Fe     1-1  Millonarios
  [Díaz 57; Rivera 92]
América      3-0  Pasto
  [Mafla 4, Máziri 12, Vásquez 56]
Tuluá        1-1  Tolima
  [Sacramento 43; Ciciliano 52]
Cartagena    3-0  Pereira
  [Pérez 11, Quiñónez 33, 46]
Bucaramanga  1-1  Envigado
  [Guirán 49pen; Molina 61]
Caldas       3-2  Medellín
  [Marín 25, Valentierra 51, Galván 87; Vanegas 9og, Montoya 91]
Nacional     2-0  Junior
  [Guzmán 30, Hurtado 46pen]

Round 8
[Mar 31]
Junior       1-2  Tuluá
  [Marquinho 58pen; Sacramento 42, Rojas 59]
Once Caldas  2-1  Millonarios
  [Valentierra 37, Vanegas 62; Castro 47]
[Apr 1]
Santa Fe     1-2  Pereira
  [Arboleda 29; Alvarez 48, Cardona 76]
América      5-1  Envigado
  [Vásquez 26, 41, Herrera 30, Betancourt 72, 75; Molina 78]
Bucaramanga  0-0  Cali
Tolima       2-2  Nacional
  [Velásquez 8, Vidal 46; Hurtado 58, 80]
Medellín     3-0  Huila
  [Alvarez 37, 79, Vásquez 56]
Pasto        1-0  Cartagena
  [Tierradentro 55]

Round 9  [Apr 8] 
Millonarios  1-1  Santa Fe 
  [Castro 54; Núñez 89] 
Cali         2-0  Pasto 
  [Vásquez 66, Quintana 82] 
Nacional     2-1  Huila 
  [Grisales 23, Córdoba 78; Hernández 61] 
Envigado     1-3  Once Caldas 
  [Trujillo 25; Velásquez 57, 76, Valentierra 73] 
Tolima       0-1  Júnior 
  [Restrepo 65] 
Cartagena    3-0  Medellín 
  [Ramos 27, Valencia 65 (corner), Iturburo 86] 
Pereira      2-0  Bucaramanga 
  [Cardona 4, Martínez 63] 
Tuluá        2-1  América 
  [Sacramento 16, Barahona 67; Roganovich 20] 

Round 10
[Apr 15]
Once Caldas  2-4  Tuluá
  [Valentierra 33pen, Velásquez 79; Muñoz 23, Dos Santos 52,
   Sacramento 66, Ceballos 84]
América      6-4  Tolima
  [Herrera 7, 71, 80, Vásquez 47pen, Virviescas 67, Enciso 89;
   Vidal 29, 83, Velásquez 35, 49]
Santa Fe     3-2  Envigado
  [Arroyo 4, Arboleda 46, Moreno 84; Molina 48, 78]
Junior       2-0  Nacional
  [Rojano 34, Miranda 87]
Medellín     2-0  Cali
  [Vásquez 43, Serna 71]
Pasto        3-1  Pereira
  [Restrepo 6, Jaramillo 34, Rendón 56; Alvarez 72]
Bucaramanga  2-1  Millonarios
  [Upegui 14, Cuadros 40; Castro 1]
[Apr 18]
Huila        2-2  Cartagena
  [Córdoba 32, Redín 51pen; Iturburo 15, Pérez 58]

Round 11  [Apr 22]
Millonarios  2-0  Pasto
  [Castro 14, 71]
Cali         3-2  Huila
  [Salazar 1, Valenciano 16pen, 30; Da Silva 28, Perafán 64]
Junior       2-1  América
  [Rojano 9, Marquinho 60; Cardona 73]
Tuluá        1-1  Santa Fe
  [Sacramento 44; Torres 49]
Tolima       2-0  Once Caldas
  [Velásquez 46, 50]
Pereira      2-2  Medellín
  [Castillo 28, Sánchez 68; Vásquez 13, Serna 69]
Nacional     1-1  Cartagena
  [Córdoba 31; Valencia 81]
Envigado     1-1  Bucaramanga
  [Moreno 73; Vásquez 27]

Round 12  [Apr 29]
América      0-0  Nacional
Cartagena    1-0  Cali
  [Iturburo 44]
Medellín     1-0  Millonarios
  [Serna 84]
Once Caldas  2-1  Junior
  [Galván 2, Díaz 21; Pérez 41]
Bucaramanga  0-1  Tuluá
  [Sacramento 31]
Pasto        1-1  Envigado
  [Charria 58; Moreno 15]
Huila        3-3  Pereira
  [Redín 47pen, Aponzá 71, Perafán 74; Martínez 13, Alvarez 24, Castillo 84pen]
Santa Fe     1-2  Tolima
  [Jaramillo 41; Velásquez 34, Vidal 72]

Round 13
[May 6]
Tuluá        3-1  Pasto
  [Díaz 76, 87, Orejuela 89og; Jaramillo 83pen]
Junior       0-0  Santa Fe
Pereira      2-0  Cartagena
  [Castillo 74, Cardona 77]
Nacional     2-1  Cali
  [Córdoba 25, Hurtado 59; Valenciano 73]
Millonarios  4-0  Huila
  [Castro 13, Orrego 26, Asencio 49, 82]
Tolima       1-0  Bucaramanga
  [Arrieta 38pen]
[May 15]
Medellín     2-2  Envigado
  [Rodas 50pen, Serna 58; Molina 14, 35]
América      ppd  Once Caldas   [postponed after a bomb explosion in the hotel
  where Caldas were lodging left 4 of their players and an assistant coach injured]
[Jun 6]
América      1-1  Once Caldas
  [Vásquez 26pen; Valentierra 41pen]

Round 14  [May 12]
Once Caldas  3-0  Nacional
  [Valentierra 83pen, Galván 85, Echeverry 88]
Cali         3-0  Pereira
  [Aristizábal 5, Quintana 81, Valenciano 84]
Cartagena    0-2  Millonarios
  [Orrego 40, Castro 62]
Bucaramanga  0-0  Junior
Pasto        2-1  Tolima
  [Mendoza 24, Charria 36; Becerra 12]
Santa Fe     2-0  América
  [Jaramillo 11, Cuenú 53]
Huila        0-1  Envigado
  [Reyes 23og]
Medellín     3-0  Tuluá
  [Serna 12, Cataño 65, Jaramillo 90]

Round 15  [May 20]
América      2-0  Bucaramanga
  [Londoño 7, Herrera 66]
Tolima       2-1  Medellín
  [Martínez 47pen, Arrieta 88; Vásquez 2]
Junior       1-1  Pasto
  [Aguilar 85; Charria 69]
Millonarios  2-0  Cali
  [Escobar 6, Pérez 73]
Once Caldas  0-1  Santa Fe
  [Moreno 11pen]
Tuluá        3-0  Huila
  [Dos Santos 4, Sacramento 62, Chacón 65og]
Nacional     2-1  Pereira
  [Salazar 50, Agudelo 54; Castillo 9]
Envigado     1-0  Cartagena
  [Hernández 88]

Round 16  [May 27]
Pereira      0-1  Millonarios
  [Castro 43]
Santa Fe     0-0  Nacional
Medellín     5-0  Junior
  [Calle 32, 69, Serna 68, 81pen, 86]
Cartagena    2-1  Tuluá
  [Viáfara 19, Valencia 84; Rivera 51]
Cali         1-0  Envigado
  [Vásquez 74]
Bucaramanga  0-3  Once Caldas
  [Díaz 18, Soto 58, Valencia 72]
Huila        2-3  Tolima
  [Redín 32, Velandia 72; Saams 40, 64, Velásquez 43]
Pasto        3-1  América
  [Rendón 23, Jaramillo 79, Camacho 89; Londoño 70]

Round 17  [Jun 10]
América      3-2  Medellín
  [Mafla 17, L.García 44, Herrera 60; Vásquez 15, Serna 37]
Nacional     1-0  Millonarios
  [Salazar 54]
Tolima       2-1  Cartagena
  [Velásquez 78, 92; Pérez 45]
Santa Fe     1-0  Bucaramanga
  [Díaz 22]
Once Caldas  2-1  Pasto
  [J.Díaz 30, Galván 91; Rendón 6]
Junior       2-0  Huila
  [Palacio 18, Zuleta 74]
Tuluá        0-1  Cali
  [Aristizábal 45]
Envigado     2-1  Pereira
  [Moreno 53, Giraldo 80; Palacios 9]

Round 18
[Jun 16]
Medellín     1-1  Once Caldas
  [Vásquez 9; Valentierra 57]
[Jun 17]
Cali         3-2  Tolima
  [Aristizábal 34, Vallejo 48, Salazar 72; Becerra 16, Velásquez 20]
Bucaramanga  1-0  Nacional
  [Ramírez 55pen]
Millonarios  0-3  Envigado
  [Cortés 11, 56, 90]
Cartagena    1-3  Junior
  [Valencia 34; Arriaga 16, Alcázar 71, Rojano 84]
Pasto        0-1  Santa Fe
  [López 67]
Pereira      1-1  Tuluá
  [Castillo 89pen; Londoño 93]
Huila        0-1  América
  [L.García 51]

Round 19  [Jun 20]
Bucaramanga  1-1  Pasto
  [Cuadros 67; Orejuela 42]
Nacional     1-1  Envigado
  [Córdoba 51; Cortés 78]
Junior       1-1  Cali
  [Aguilar 91; Murillo 56]
Once Caldas  0-1  Huila
  [Perea 33]
Tuluá        2-1  Millonarios
  [Rivera 15pen, Sacramento 76; Hernández 52og]
América      2-0  Cartagena
  [Mafla 4, Romero 78]
Tolima       3-0  Pereira
  [Velásquez 43, 81, Becerra 58]
Santa Fe     2-1  Medellín
  [Ramírez 11, 35; Alvarez 80]

Round 20  [Jun 24] 
Cali         4-1  América
  [Aristizábal 12, 64, 68, Murillo 90; Mafla 40]
Millonarios  2-1  Tolima
  [Orrego 63, Suárez 65; Velásquez 2]
Pasto        1-2  Nacional
  [Jaramillo 91; Restrepo 38, Hurtado 85]
Medellín     0-0  Bucaramanga 
Huila        2-2  Santa Fe
  [Redín 57, Cantillo 74; Córdoba 44, Jaramillo 89]
Cartagena    2-2  Once Caldas
  [Mejía 69, 89; Vanegas 24, Lemus 61]
Envigado     1-1  Tuluá
  [Leal 9pen; Pereira 3]
Pereira      2-0  Junior
  [Cardona 69, 83]

Round 21  [Jun 27] 
Nacional     0-1  Tuluá
  [Londoño 32]
Tolima       1-0  Envigado
  [Arrieta 43]
Junior       1-0  Millonarios
  [Ballesteros 30]
América      2-1  Pereira
  [Villarreal 54, González 62; Palacios 15pen]
Once Caldas  2-1  Cali
  [Padilla 10, Galván 63; Murillo 58]
Santa Fe     4-1  Cartagena
  [Ramírez 20, Cuenú 25, Viáfara 44og, Díaz 55; Banguero 21]
Bucaramanga  0-0  Huila 
Pasto        2-2  Medellín
  [Londoño 68, 76; Serna 20, Alvarez 75]

Round 22  [Jul 1]
Tuluá        1-0  Tolima
  [Pereira 61]
Millonarios  2-2  América
  [Orrego 20, Suárez 82; Vásquez 76, Virviescas 78]
Cali         3-1  Santa Fe
  [Aristizábal 25, 53, 77; Cuenú 73]
Envigado     1-1  Junior
  [Leal 65; Ballesteros 52]
Pereira      1-2  Once Caldas
  [Cano 23; Córdoba 14og, Galván 57]
Cartagena    1-0  Bucaramanga
  [Quiñónez 61]
Huila        4-1  Pasto
  [Aponzá 4, Perea 20, 35, Velandia 69; Rendón 90]
Medellín     2-1  Nacional
  [Cortés 66, 90; Salazar 34]

Final Table:

 1.Corporación Tuluá  22 12  6  4  30-19  42  Copa Libertadores 2002
 2.Deportivo Cali     22 11  5  6  31-21  38
 3.Once Caldas        22 11  5  6  35-27  38
 4.Deportes Tolima    22 11  3  8  34-28  36
 5.CD Indep Medellín  22  9  7  6  40-25  34
 6.Independ Santa Fe  22  9  7  6  28-23  34
 7.América            22 10  3  9  37-39  33
 8.Atlético Júnior    22  8  7  7  22-23  31
 9.CD Millonarios     22  8  4 10  29-23  28
10.Envigado FC        22  7  7  8  26-30  28
11.Deportes Pereira   22  8  3 11  26-34  27
12.Atlético Nacional  22  7  5 10  18-28  26
13.Real Cartagena     22  7  4 11  23-28  25
14.Atlético Huila     22  6  4 12  28-40  22
15.Atl Bucaramanga    22  4 10  8  10-18  22
16.Deportivo Pasto    22  5  6 11  23-34  21

Tie-breakers:

1) number of wins
2) goal difference
3) goals scored
4) goals scored away
5) goals against (least)
6) goals against away (least)
7) draw

Topscorers 'Botín de Oro' Trophy: 

Jorge Horacio Serna  Medellín       15 
Iván Velásquez       Tolima         14 
Carlos Castro        Millonarios    13 
Mauricio Molina      Envigado FC    11
Víctor Aristizábal   Cali           10 
Arnulfo Valentierra  Once Caldas     9 
Sergio Galván        Once Caldas     9 
Bernardo Redín       Huila           9


Author: Frank Ballesteros
(Frank.Ballesteros@kellogg.com)

Last updated: 9 Feb 2002

(C) Copyright Frank Ballesteros and RSSSF 2001/02
						

INFORMACIÓN

Liga Profesional de Primera División de la República de Colombia.

Llamada localmente Liga Postobon, ya que la marca de bebidas Postobon patrocina este torneo.

Uso de cookies: Utilizamos "cookies" propias y de terceros para mejorar nuestros servicios, elaborar información estadística, analizar sus hábitos de navegación e inferir grupos de interés. Esto nos permite personalizar el contenido que ofrecemos y mostrarle publicidad relacionada con sus preferencias. Adicionalmente, compartimos los análisis de navegación y los grupos de interés inferidos con terceros. Si continúa navegando acepta su uso. Más información y cambio de configuración. Aceptar

  USO DE MEMORIA  
4,389,784 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0019
Controller Execution Time ( Home / Category )  0.0934
Total Execution Time  0.0953
  CADENA URL  
/apertura_colombia2001
  GET DATOS  
$_GET['/apertura_colombia2001']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (34)  
0.0018  SELECT type FROM routes WHERE alias = 'apertura_colombia2001'
0.0038  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'apertura_colombia' 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.0021  SELECT text_es as historical_text FROM leagues_text WHERE id=535
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 = 28857 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0027  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=42 ORDER BY l.group_code ASC
0.0018  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-03-28 14:38:09' 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-03-28 14:38:09' 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-03-28 14:38:09' 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=3 AND last_update > '2024-03-28 14:38:09' 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 = 'apertura_colombia' 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.0019  SELECT e.action, count(e.action) as total, e.player_id FROM events2001 e WHERE e.league_id IN (28857) 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 (28857) 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 events2001 e WHERE e.league_id IN (28857) 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 (28857) 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 events2001 e WHERE e.league_id IN (28857) AND (e.action IN (3,4) ) 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 (28857) 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 events2001 e WHERE e.league_id IN (28857) 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 (28857) 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 = 28857 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 = 28857 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=28857 AND rel.round=22
0.0020  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 = 28857 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 = 28857 AND esl.points > 0
0.0021  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-02-27" AND c.`active`= 1 and c.comment_id is null and c.lang = 1 AND l.`id` = 28857 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-02-27" AND c.`active`= 1 and comment_id is null and c.lang = 1 AND l.`id` = 28857
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` = 28857 AND c.`round` = 22 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 `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 = 28857 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 `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 = 28857 AND e.real_date > NOW() - INTERVAL 1 MONTH ORDER BY e.real_date DESC LIMIT 30
0.0023  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 = 28857 AND t.round = 20 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0023  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 = 28857 AND t.round = 22 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0023  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-03-28 00:00:00' AND c.`shedule` < '2024-04-01 23:59:59' AND l.id = 28857 ORDER BY c.shedule ASC, fcoef DESC LIMIT 5
0.0023  SELECT data1, data2 FROM services_tags WHERE categoryId=42
0.0023  SELECT l.year,l.group_code FROM leagues_besoccer l WHERE l.categoryId = 42 AND l.year = 2001 ORDER BY l.group_code ASC
0.0023  SELECT group_code, extraName from `leagues` WHERE categoryId=42 AND year=2001