Información Histórica
						
Torneo Mustang I

Final Table:

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

Round 1
[Feb 12] 
Envigado     0-0  Cali 
[Feb 13] 
Junior       5-1  Tuluá
  [Palacios 5, Mosquera 9, Arriaga 48, 77, Ballesteros 89; Rodríguez 37 pen]
Bucaramanga  1-1  Millonarios    
  [Rivera 41 pen; Castro 25]  
Huila        0-0  Nacional
Medellín     1-0  Real Cartagena 
  [Ortiz 35]
[Feb 16]
América      6-1  Once Caldas    
  [Ortegón 20, Quintana 23, Maturana 54, Salazar 68, 83, Moreno 72; Velásquez 35]
[Feb 23]
Quindío      2-1  Pasto
  [Oyie, Hernández; Bolívar]
[Mar 9]
Santa Fé     2-5  Tolima
  [Cárdenas 62, Preciado 90; Charria 2, Becerra 54, Patiño 58, Martínez 79pen, 
   Caicedo 88]

Round 2 
[Feb 19]
Nacional     3-1  América
  [Aristizábal 17, Mackenzie 68, España 72; Ferreira 48]
[Feb 20]
Once Caldas  2-2  Junior
  [Valentierra 9, Rodas 54; Palacios 58, Cantillo 88]
Pasto        2-1  Envigado
  [Vidal 1, Moreno 87; Cortés 79]
Tuluá        1-1  Bucaramanga
  [Vásquez 60; Núñez 72]
Cali         1-0  Santa Fe
  [Gaviria 71]
Cartagena    2-0  Quindío
  [Quiñónez 30, Banguero 91]
[Mar 15]
Millonarios  3-1  Huila  
  [Castro 11, 89, Rivera 22; Da Silva 81]
[Mar 22]
Tolima       2-2  Medellín
  [Becerra 36, Caicedo 92; Valenciano 47, 79]

Round 3 
[Feb 26]
América      2-1  Millonarios    
  [Quintana 6, Moreno 20; García 74]
[Feb 27]
Tuluá        3-0  Once Caldas  
  [Martínez 4, Rodríguez 31, Gómez 87]
Junior       0-0  Nacional  
Bucaramanga  0-0  Huila       
Santa Fé     2-0  Pasto
  [Escobar 14 (own goal), Reino 80]
Envigado     2-0  Cartagena
  [Rendón 13, Vásquez 85]
Medellín     1-0  Quindío
  [Valenciano 64]
[May 10] 
Tolima       3-1  Cali 
  [Arrieta 29, Martinez 35 pen, Caicedo 72; Candelo 64 pen] 

Round 4 [Mar 5]
Once Caldas  3-2  Bucaramanga  
  [Galvan 2, Salcedo 11, Valentierra 26; Luna 15, Rivera 88]
Nacional     2-1  Tuluá
  [Calle 51, Galarcio 93; Rodríguez 21]
Millonarios  3-2  Junior
  [Peña 22, Castro 63, Chitiva 84; Cantillo 81, Aguilar 91]
Huila        1-1  América
  [Da Silva 79; Del Castillo 35]
Cali         3-1  Medellín
  [Barragan 40, Dudamel 46 pen, Diaz 66; Serna 85]
Pasto        0-1  Tolima
  [Arrieta 77]
Cartagena    3-2  Santa Fé
  [Gomez 2, Arias 11, Garcia 53; Preciado 15 pen, Reino 69 (corner) ]
Quindío      1-1  Envigado
  [Cuesta 67; Aguilar 21]

Round 5 [Mar 12] 
Junior       2-0  Huila
  [Ballesteros 2, Cano 17]
Tolima       1-0  Cartagena
  [Caicedo 7]
Bucaramanga  2-0  América
  [Vásquez 46, Rivera 56 pen]
Medellín     2-2  Envigado
  [Valenciano 17, 48; Rendón 14, 46]
Cali         4-0  Pasto
  [Díaz 22, Candelo 42, Segura 57, Arce 61]
Santa Fe     1-1  Quindío
  [Preciado 65 pen; Alzate 34]
Tuluá        1-0  Millonarios   
  [Hurtado 24]
Caldas       2-1  Nacional
  [Valentierra 56, Galván 62; Muñoz 55]

Round 6
[Mar 18]
Envigado     0-1  Santa Fé
  [Serrano 76]
América      2-0  Junior
  [Maturana 36 pen, Oviedo 69]
[Mar 19]
Millonarios  2-1  Once Caldas
  [Castro 61, 92; Daza 87] 
Quindío      1-4  Tolima
  [Cuesta 12; Martinez 1 pen, Becerra 49, 51, Velásquez 66]
Huila        2-1  Tuluá
  [Da Silva 18, Alvarez 75; Rodríguez 54]
Bucaramanga  1-0  Nacional
  [Núñez 24]
Medellín     2-1  Pasto
  [Valenciano 10, 69; Vidal 58]
Cartagena    0-1  Cali
  [Hernández 37]

Round 7 [Mar 26]
Nacional     3-0  Millonarios
  [Morantes 32, Aristizábal 69, 83]
Santa Fe     0-1  Medellín
  [Valenciano 61]
Pasto        2-1  Cartagena
  [Vidal 56, 68; Villareal 22]
Caldas       2-1  Huila
  [Hernández 30, Galvan 92 pen; Da Silva 44]
Cali         0-0  Quindío
Tolima       2-2  Envigado
  [Orrego 70, Charria 89; Vásquez 19, Rendón 73]
Júnior       3-0  Bucaramanga
  [Aguilar 3, Marquinho 30, Rojano 84]
Tuluá        1-0  América
  [Rodríguez 56]

Round 8 
[Mar 30]
América      4-0  Tuluá
  [Gonzalez 36, Moreno 50, Salazar 70, 75]
[Apr 1]
Envigado     1-0  Tolima
  [Rendon 23]
[Apr 2]
Pasto        1-0  Junior
  [Ciciliano 21]
Cartagena    1-0  Bucaramanga
  [Garcia 61]
Huila        2-0  Caldas
  [Alvarez 7, Reyes 37]
Millonarios  0-0  Medellin
Nacional     2-2  Santa Fe
  [Aristizabal 15, 61 pen; Diaz 48, Preciado 83 pen]
Quindío      1-3  Cali
  [Victoria 44; Segura 25, Hernandez 70, Diaz 74]   

Round 9  [Apr 9]
Bucaramanga  1-0  Junior
  [Paz 47]
Santa Fe     1-1  Pasto
  [Matallana 48; Vidal 82]
Tuluá        3-0  Nacional
  [Vásquez 24, 80, Rodríguez 90]
Tolima       2-0  América
  [Caicedo 47, Arrieta 68]
Caldas       0-1  Envigado
  [Vásquez 89]
Cali         0-0  Huila
Medellín     0-2  Quindío
  [Palacio 44, 53]
Cartagena    1-1  Millonarios
  [Rojas 35; Castro 60]

Round 10
[Apr 12]
Junior       2-2  Santa Fe
  [Cardozo 5, Restrepo 87; Preciado 2, Diaz 52]
Huila        1-1  Medellín
  [Da Silva 53; Serna 12]
Nacional     1-0  Tolima
  [Moreno 41]
Millonarios  2-0  Bucaramanga  
  [Mosquera 32, Castro 78]
Quindio      1-1  Cartagena
  [Palacio 68 pen; Arias 11]
América      0-0  Caldas
[Apr 13]
Pasto        2-1  Tuluá
  [Patiño 69, Bolívar 88; Rodríguez 18]
Envigado     0-0  Cali

Round 11  [Apr 16]
Millonarios  2-1  Quindío
  [Castro 11, Rivera 64; Palacio 70 pen]
Cali         0-1  América
  [Salazar 25]
Medellín     1-1  Envigado
  [Serna 35; Cortés 30]
Tolima       5-2  Pasto
  [Arrieta 50, 52, 62, Charria 67, Caicedo 90; Bolívar 43, 48]
Caldas       2-1  Nacional
  [Galván 35, 37 pen; Morantes 31]
Bucaramanga  0-1  Santa Fe
  [Preciado 79]
Cartagena    1-0  Huila
  [Gómez 5]
Tuluá        1-2  Júnior
  [Vásquez 3; Cano 45, Restrepo 74]

Round 12
[Apr 22]
Envigado     1-0  Cartagena
  [Molina 13]
[Apr 23]
Huila        2-1  Millonarios
  [Mendoza 65, Alvarez 68; Rivera 50]
Santa Fe     3-3  Tuluá
  [Reino 3, Mafla 79, Preciado 92; Hurtado 34, 89, Vásquez 51]
América      3-1  Medellín
  [Moreno 20, Quintana 63, Pérez 77; Montoya 45]
Júnior       3-1  Tolima
  [Cano 17, Mosquera 68, Palacio 73; Caicedo 62]
Pasto        0-2  Caldas
  [Asprilla 9, Galván 55]
Quindío      2-1  Bucaramanga
  [Palacio 75 pen, 79; Mafla 4]
Nacional     2-2  Cali
  [Moreno 47, Agudelo 78; Rivas 26, Castillo 68]

Round 13  [Apr 30] 
Millonarios  2-2  Envigado 
  [Rivera 32, 60 pen; Cortes 1, Vásquez 24] 
Tolima       1-0  Santa Fe 
  [Arrieta 41] 
Caldas       2-1  Júnior 
  [Foronda 38, Valentierra 68; Arriaga 66] 
Bucaramanga  2-1  Tuluá 
  [H Vásquez 79, Núñez 87; W Vásquez 42] 
Quindío      1-1  Huila 
  [Mesa 86; Redín 17] 
Cali         3-2  Pasto 
  [Castillo 32, 50, Dudamel 43 pen; Vidal 53 pen, Patiño 54] 
Cartagena    1-1  América 
  [Viáfara 45; Pérez 58] 
Medellín     3-4  Nacional 
  [Gutiérrez 8, Valenciano 68, Murillo 93; Aristizábal 23, A Palacios 29, 
   Muñoz 57, Moreno 75] 

Round 14 
[May 6] 
Envigado     4-1  Quindío 
  [Cortés 9, 59, Vásquez 43, Leal 72; Cabrera 18] 
América      1-1  Millonarios 
  [Pérez 67 pen; Castro 45] 
[May 7] 
Huila        1-0  Bucaramanga 
  [Da Silva 10] 
Nacional     2-0  Real Cartagena 
  [Muñoz 27, Aristizábal 45] 
Pasto        2-0  Medellín 
  [Vidal 57, 93] 
Junior       1-3  Cali 
  [Marquinho 43; Segura 24, Julio 74 (own goal), Echeverry 81] 
Santa Fe     1-0  Once Caldas 
  [Serrano 56] 
Tuluá        1-0  Tolima 
  [Hurtado 39] 
  
Round 15  [May 14] 
Millonarios  4-3  Nacional 
  [Castro 17, 78, Rivera 72 pen, Suárez 81; Moreno 66, Agudelo 83, Cortés 84 (own goal)] 
Cali         3-4  Santa Fe 
  [Bedoya 30, 60, Candelo 90 pen; Diaz 24, Matallana 41, 92, Ramírez 87] 
Quindío      0-3  América 
  [Máziri 8, Castillo 22 pen, 88] 
Bucaramanga  1-0  Tolima 
  [Pizarro 90] 
Medellín     1-2  Júnior 
  [Valenciano 45; Arriaga 1, Ballesteros 91] 
Caldas       2-2  Tuluá 
  [Daza 19, Valentierra 89; Hernández 52, Ramos 93] 
Huila        3-1  Envigado 
  [Da Silva 11, 59, C Alvarez 46; N Alvarez 91] 
Cartagena    2-1  Pasto 
  [Banguero 25, Asprilla 40; Asprilla 16 (own goal)] 

Round 16
[May 20]
Envigado     3-0  Bucaramanga
  [Molina 48, Cortés 79, Rodríguez 89]
[May 21]
Santa Fe     3-1  Medellín
  [Preciado 37, 72, 86; Valenciano 12]
Tolima       1-0  Caldas
  [Velásquez 63]
Nacional     3-0  Quindío
  [Palacios 4, Aristizábal 41, Callejas 76]
Tuluá        2-2  Cali
  [Rodríguez 33, Vásquez 44; Dudamel 8 pen, López 42]
Júnior       1-1  Cartagena
  [Herrera 54; Quiñónez 22]
América      6-0  Huila
  [Castillo 12, 50, Salazar 42, Maturana 58 pen, 68, Quintana 81]
[Jun 21]
Pasto        2-2  Millonarios 
  [Vidal 27, Moncayo 88; Mosquera 22, Fernández 80] 

Round 17 
[May 28] 
Cali         5-2  Tolima 
  [Segura 35, Dudamel 40 pen, Salazar 74, Hernández 76, Castillo 93; 
   Arrieta 50, Becerra 91] 
Cartagena    2-0  Santa Fe 
  [Higuita 70 pen, Murillo 80] 
Huila        2-2  Nacional 
  [Redín 72, Da Silva 79; Aristizábal 33, 81] 
[May 31] 
Quindío      4-2  Pasto 
  [Hernández 18, Cabrera 21, Mesa 47, Rentería 88; Siciliano 7, 51]  
Bucaramanga  1-1  Caldas 
  [Paz 94; Galván 35] 
Millonarios  2-0  Júnior 
  [Cruz 57, Castro 74] 
Envigado     1-3  América 
  [Molina 58 pen; Castillo 6, Maturana 35 pen, Viviescas 62] 
[Jun 14] 
Medellín     0-1  Tuluá 
  [Vásquez 28]

Round 18 
[Jun 7] 
América      1-0  Bucaramanga 
  [Salazar 82] 
Nacional     1-3  Envigado 
  [Palacios 79; Molina 33 pen, Vásquez 52, 84] 
Pasto        2-2  Huila  
  [Ciciliano 11, 42; Alvarez 49, Da Silva 82] 
Junior       2-1  Quindío 
  [Cardozo 27, Ballesteros 69; Cabrera 31] 
Tuluá        2-0  Cartagena 
  [Muñoz 18, Vásquez 62] 
Tolima       1-3  Medellín 
  [Cambindo 61; Murillo 3, 49, Pacheco 84] 
Once Caldas  0-0  Cali 
[Jun 8] 
Santa Fé     0-0  Millonarios 

Round 19 
[Jun 10] 
Envigado     3-1  Pasto 
  [Vallejo 6, Vásquez 46, 73; Patiño 68] 
[Jun 11] 
Quindio      3-1  Santa Fe 
  [Palacio 11, Flavient 62, Rentería 71; Mafla 63] 
America      0-1  Nacional 
  [Moreno 30] 
Millonarios  3-1  Tuluá 
  [Ramos 10 (own goal), Castro 48, 71; Muñoz 35] 
Bucaramanga  1-2  Cali 
  [Vásquez 14; Barragán 15, Castillo 79] 
Huila        2-1  Junior 
  [Redín 14, Alvarez 56; Cardozo 76] 
Cartagena    2-0  Tolima 
  [Vanguero 83, Vilarete 89] 
Medellín     1-1  Once Caldas 
  [Murillo 29; Galván 11] 

Round 20 [Jun 18]
Tolima       1-1  Millonarios
  [Da Silva 67; Toro 58]
Santa Fe     0-0  Huila
Caldas       1-1  Cartagena
  [Salcedo 63; Arias 47]
Pasto        1-5  América
  [Vidal 88; Castillo 3, 52, Ferreira 25, 89, Salazar 33]
Nacional     3-0  Bucaramanga
  [Moreno 9, Agudelo 83, Fajardo 86 (own goal)]
Cali         1-2  Medellín
  [Arce 54; Murillo 76, Cortés 87]
Tuluá        1-0  Quindío
  [Rodríguez 20 (pen)]
Júnior       2-0  Envigado
  [Ballesteros 16, Marquinho 32]

Round 21 
[Jun 25] 
Millonarios  1-1  Caldas 
  [Fernández 33; Asprilla 25] 
Envigado     0-2  Santa Fe 
  [Preciado 72, 84] 
Cartagena    0-1  Cali 
  [Hernández 90] 
América      1-1  Júnior 
  [Oviedo 38; Ballesteros 46] 
Nacional     1-2  Pasto 
  [Aristizábal 18; Patiño 30, 54] 
Huila        0-1  Tuluá 
  [Vásquez 53] 
Bucaramanga  2-2  Medellín 
  [Rivera 25, Núñez 78; Burgues 21 (own goal), Murillo 52] 
[Jul 5] 
Quindío      1-3  Tolima 
  [Flavien 25; Dinas 34, 88, Orrego 59] 

Round 22 
[Jul 1] 
Tuluá        1-1  Envigado 
  [Rodríguez 52; Vásquez 51] 
Júnior       1-0  Nacional 
  [Ballesteros 51] 
[Jul 2] 
Santa Fe     4-1  América 
  [Diaz 8, Preciado 53, 75, Mafla 86 pen; Moreno 82 pen] 
Cali         1-0  Millonarios 
  [Echeverry 38] 
Pasto        0-0  Bucaramanga 
Tolima       1-0  Huila 
  [Arrieta 67] 
Caldas       1-1  Quindío 
  [Velásquez 88; Cuesta 1] 
Medellín     2-2  Cartagena 
  [Pacheco 30, Restrepo 67; Quiñonez 13, Asprilla 70 pen] 

Final Table:

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

Tie-breakers:

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

[NB: tie-breaker 5 is irrelevant as the goals against must be equal
     if goal difference and goals scored are equal.]

Topscorers Mustang I: 

Carlos Castro          Millonarios      15 
Leider Preciado        Santa Fe         14 
Iván René Valenciano   Medellín         11 
Victor Aristizábal     Nacional         11 
Jorge Vidal            Pasto            10 
Julián Vásquez         Envigado         10 
Rogeiro Da Silva       Quindío          10 
Hugo Arrieta           Tolima           10 
Milton Rodríguez       Tuluá            10 
William Vásquez        Tuluá            10 
Nestor Salazar         América           8 
Sergio Galván          Once Caldas       8 


Author: Frank Ballesteros
(f-balles@uniandes.edu.co)

Last updated: 25 Feb 2001

(C) Copyright Frank Ballesteros and RSSSF 1999/2001
						

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,357,904 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0026
Controller Execution Time ( Home / Category )  0.1768
Total Execution Time  0.1794
  CADENA URL  
/apertura_colombia2000
  GET DATOS  
$_GET['/apertura_colombia2000']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (37)  
0.0034  SELECT type FROM routes WHERE alias = 'apertura_colombia2000'
0.0072  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 = 2000 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=1 DESC LIMIT 1
0.0034  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=42 AND type_rel = 3
0.0091  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 3 AND rel.typeId = 42 AND rel.ln = 'es' AND rel.status=1 ORDER BY rel.creation_date desc,rel.cover_points DESC LIMIT 5
0.0037  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 (1308428,1308305,1308139,1308019,1307903) ORDER BY n.cover_points DESC, update_date DESC
0.0038  SELECT text_es as historical_text FROM leagues_text WHERE id=534
0.0036  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 = 28856 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0047  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.0035  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-03-28 22:51:18' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0035  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=2 AND last_update > '2024-03-28 22:51:18' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0035  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=4 AND last_update > '2024-03-28 22:51:18' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0035  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=3 AND last_update > '2024-03-28 22:51:18' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0039  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 = 2000 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=0 DESC LIMIT 1
0.0035  SELECT e.action, count(e.action) as total, e.player_id FROM events2000 e WHERE e.league_id IN (28856) 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.0034  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 (28856) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN () ORDER BY rp.in_squad = 1 DESC
0.0036  SELECT e.action, count(e.action) as total, e.player_id FROM events2000 e WHERE e.league_id IN (28856) AND (e.action IN (4,5) ) GROUP BY e.player_id ORDER BY total DESC, e.player_id ASC LIMIT 20
0.0034  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 (28856) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN () ORDER BY rp.in_squad = 1 DESC
0.0035  SELECT e.action, count(e.action) as total, e.player_id FROM events2000 e WHERE e.league_id IN (28856) AND (e.action IN (3,4) ) GROUP BY e.player_id ORDER BY total DESC, e.player_id ASC LIMIT 20
0.0035  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 (28856) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN () ORDER BY rp.in_squad = 1 DESC
0.0038  SELECT e.action, count(e.action) as total, e.player_id FROM events2000 e WHERE e.league_id IN (28856) AND (e.action IN (22) ) GROUP BY e.player_id ORDER BY total DESC, e.player_id ASC LIMIT 20
0.0037  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 (28856) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN () ORDER BY rp.in_squad = 1 DESC
0.0036  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 = 28856 AND rp.lineup > 0 ORDER BY rp.lineup DESC,p.pod DESC LIMIT 20
0.0034  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 = 28856 AND rp.events > 0 ORDER BY rp.events DESC,p.pod DESC LIMIT 20
0.0037  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=28856 AND rel.round=22
0.0036  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 = 28856 AND esl.points > 0 ORDER BY esl.points DESC LIMIT 3
0.0035  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 = 28856 AND esl.points > 0
0.0036  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-28" AND c.`active`= 1 and c.comment_id is null and c.lang = 1 AND l.`id` = 28856 ORDER BY creation_date DESC LIMIT 0, 10
0.0041  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-28" AND c.`active`= 1 and comment_id is null and c.lang = 1 AND l.`id` = 28856
0.0036  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 `calendars2000` 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` = 28856 AND c.`round` = 22 ORDER BY shedule ASC LIMIT 200
0.0034  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 `events2000` e INNER JOIN calendars2000 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 = 28856 ORDER BY total DESC LIMIT 40
0.0036  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 `events2000` e INNER JOIN calendars2000 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 = 28856 AND e.real_date > NOW() - INTERVAL 1 MONTH ORDER BY e.real_date DESC LIMIT 30
0.0039  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 `tables2000` 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 = 28856 AND t.round = 20 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0039  SELECT *,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables2000` 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 = 28856 AND t.round = 22 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0039  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-29 00:00:00' AND c.`shedule` < '2024-04-02 23:59:59' AND l.id = 28856 ORDER BY c.shedule ASC, fcoef DESC LIMIT 5
0.0039  SELECT data1, data2 FROM services_tags WHERE categoryId=42
0.0039  SELECT l.year,l.group_code FROM leagues_besoccer l WHERE l.categoryId = 42 AND l.year = 2000 ORDER BY l.group_code ASC
0.0039  SELECT group_code, extraName from `leagues` WHERE categoryId=42 AND year=2000