4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Publicidad 600x120.gif
Apertura Primera B Colombia 2001
2000/2001

Apertura Primera B Colombia 2001

  • Primera B
Información Histórica
						Colombia 2001

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



Authors: Frank Ballesteros (fballesteros@colombia.com) and Juan Pablo Andrés (jpandres@tutopia.com) 
Last updated: 1 Feb 2006

(C) Copyright Frank Ballesteros, Juan Pablo Andrés and RSSSF 2005/06
You are free to copy this document in whole or part provided that proper acknowledgement is given to the authors. All rights reserved.						

INFORMACIÓN

La Categoría Primera B, llamado oficialmente Torneo Postobón por motivos comerciales, es el torneo de segunda división de la División Mayor del Fútbol Colombiano (Dimayor), entidad dependiente de la Federación Colombiana de Fútbol. El torneo es de carácter profesional, comenzó a disputarse en 1991 y el primer torneo fue ganado por el Envigado Fútbol Club.

  USO DE MEMORIA  
4,316,728 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0019
Controller Execution Time ( Home / Category )  0.0971
Total Execution Time  0.0991
  CADENA URL  
/apertura_primera_b_colombia2001
  GET DATOS  
$_GET['/apertura_primera_b_colombia2001']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (37)  
0.0018  SELECT type FROM routes WHERE alias = 'apertura_primera_b_colombia2001'
0.0042  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'apertura_primera_b_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.0019  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=196 AND type_rel = 3
0.0024  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 3 AND rel.typeId = 196 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 (1280990,1223665,1162446,1152331,1076557) ORDER BY n.cover_points DESC, update_date DESC
0.0024  SELECT text_es as historical_text FROM leagues_text WHERE id=5377
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 = 33852 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0022  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=196 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-25 04:59:51' 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-25 04:59:51' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0019  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=4 AND last_update > '2024-04-25 04:59:51' 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 04:59:51' 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 = 'apertura_primera_b_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 (33852) 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 (33852) 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 (33852) 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 (33852) 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 (33852) 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 (33852) 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 (33852) 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 (33852) 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 = 33852 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 = 33852 AND rp.events > 0 ORDER BY rp.events DESC,p.pod DESC LIMIT 20
0.0021  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=33852 AND rel.round=22
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 = 33852 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 = 33852 AND esl.points > 0
0.0019  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` = 33852 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-26" AND c.`active`= 1 and comment_id is null and c.lang = 1 AND l.`id` = 33852
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` = 33852 AND c.`round` = 22 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 = 22 AND e.real_date IS NOT NULL AND e.league_id = 33852 ORDER BY total DESC LIMIT 40
0.0019  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 = 33852 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 = 33852 AND t.round = 20 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 = 33852 AND t.round = 22 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 = 33852 ORDER BY c.shedule ASC, fcoef DESC LIMIT 5
0.0022  SELECT data1, data2 FROM services_tags WHERE categoryId=196
0.0022  SELECT l.year,l.group_code FROM leagues_besoccer l WHERE l.categoryId = 196 AND l.year = 2001 ORDER BY l.group_code ASC
0.0022  SELECT group_code, extraName from `leagues` WHERE categoryId=196 AND year=2001