4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
« Temporada Anterior
Temporada 1999
Temporada Siguiente »
Publicidad 600x120.gif
Apertura Primera B Colombia 1999
1998/1999

Apertura Primera B Colombia 1999

  • Primera B
Información Histórica 
						Colombia 1999


Format:

Apertura: consists of 6 rounds in Cuadrangulares, 15 rounds in a single
          round robin, and one round (22) with regional derbies.  The 
          winners qualify for the Copa Libertadores, runners-up for Copa
          Conmebol.

Finalizacion: again 6 rounds of Cuadrangulares, 15 rounds in a single round
              robin, one more round of regional derbies, and then another
              set of Cuadrangulares according to the table; the winners
              of groups A and B play two matches to decide the remaining
              places in the Libertadores and Conmebol cups.

The first team of the overall table (50 matches) are champions of the 
Copa Mustang (national title).

Torneo Apertura

Table:

 1.CD América Cali        22 11  7  4 42-27 40
 2.Atl. Nacional          22  9  9  4 25-18 36   
 3.Once Caldas            22  9  7  6 35-19 34  
 4.Atl. Junior            22  9  7  6 34-34 34
 5.Dep. Tolima            22  7 11  4 25-20 32
 6.Dep. Tuluá             22  8  7  7 31-31 31  
 7.Dep. Cali              22  9  4  9 37-41 31  
 8.Dep. Indep. Medellín   22  6 12  4 26-20 30   
 9.Atl. Bucaramanga       22  5 12  5 30-24 27
10.Indep. Santa Fe        22  6  8  8 23-26 26  
11.Millonarios            22  5 10  7 25-34 25  
12.Dep. Pasto             22  4 13  5 32-32 25
13.Dep. Quindío           22  6  6 10 32-40 24
14.Envigado FC            22  6  4 12 21-32 22   
15.Un. Magdalena          22  4 10  8 31-38 22
16.Atl. Huila             22  3 11  8 18-31 20

[first tie-breaker: number of wins]

[rounds 1-6 in cuadrangulares]

Round 1 
[Feb 7]
Quindio     2-0 Tulua
Envigado    0-2 Caldas      
Millonarios 1-1 Santa Fe
Huila       1-1 Tolima
Magdalena   1-1 Junior
America     3-3 Cali
Pasto       1-1 Bucaramanga
[Apr 15]
Nacional    1-1 DI Medellin    [corrected from 0-0]

Round 2 
[Feb 14]
Cali        3-2 Tulua
Caldas      0-2 Nacional
Envigado    2-1 DI Medellin 
Santa Fe    2-0 Huila
Tolima      1-1 Millonarios
Bucaramanga 1-1 Magdalena
Quindio     0-3 America
[Feb 25]
Junior      1-1 Pasto

Round 3 [Feb 21]
Cali        0-2 Quindio     
Tulua       3-2 America
Nacional    1-1 Envigado
Caldas      1-1 DI Medellin
Bucaramanga 1-1 Junior
Magdalena   4-1 Pasto
Santa Fe    2-0 Tolima
Huila       1-1 Millonarios

Round 4 [Feb 28]
America     4-0 Tulua
Quindio     1-2 Cali
Envigado    0-1 Nacional
DI Medellin 1-0 Caldas
Junior      3-2 Bucaramanga
Pasto       6-1 Magdalena
Tolima      1-1 Santa Fe
Millonarios 1-0 Huila

Round 5
[Mar 7]
Caldas      2-1 Envigado       [corrected from 3-1]
Cali        0-3 America
Tulua       2-0 Quindio   
Santa Fe    2-0 Millonarios
Tolima      0-1 Huila
Junior      2-0 Magdalena
Bucaramanga 1-0 Pasto
[Apr 8]
DI Medellin 2-0 Nacional       [corrected from 3-0]

Round 6 
[Mar 14]
Nacional    1-0 Caldas
Pasto       4-2 Junior
Magdalena   3-3 Bucaramanga
America     3-0 Quindio
Tulua       3-2 Cali
Millonarios 2-2 Tolima
Huila       1-0 Santa Fe
[Mar 18]
Envigado    0-0 DI Medellin    [corrected from 0-1] 

Round 7 [Mar 21]
Nacional    1-1 Magdalena
Junior      2-1 DI Medellin 
Caldas      3-1 Envigado
Millonarios 1-1 Santa Fe       [corrected from 0-0]
America     2-2 Tulua          [corrected from 0-0]
Bucaramanga 0-0 Tolima
Quindio     4-2 Cali
Huila       2-2 Pasto

Round 8 [Mar 28]
DI Medellin 0-0 Millonarios
Santa Fe    2-0 Nacional       [corrected from 2-1]
Magdalena   0-2 Bucaramanga
Pasto       3-3 Junior
Envigado    0-0 America
Cali        2-1 Caldas
Tolima      1-1 Quindio
Tulua       1-1 Huila

Round 9 [Apr 4]
Nacional    0-1 Cali
America     1-0 DI Medellin
Bucaramanga 6-0 Envigado
Santa Fe    0-0 Tolima
Caldas      0-0 Pasto
Quindio     1-2 Tulua
Huila       0-1 Junior
Magdalena   4-0 Millonarios

Round 10 
[Apr 11]
DI Medellin 1-0 Caldas
Envigado    0-1 Nacional
Cali        2-0 Santa Fe
Junior      2-1 America
Millonarios 2-0 Huila
Tulua       0-1 Bucaramanga
Tolima      2-0 Magdalena
[Apr 15]
Pasto       2-2 Quindio

Round 11 [Apr 18]
Nacional    3-2 Tulua
Quindio     2-2 DI Medellin
Santa Fe    0-1 Envigado
Tolima      2-0 Millonarios
Caldas      4-0 Junior
America     0-0 Huila
Magdalena   2-2 Cali
Bucaramanga 0-0 Pasto

Round 12 [Apr 25]
DI Medellin 2-2 Bucaramanga
Envigado    2-2 Magdalena
Pasto       0-0 Nacional
Millonarios 1-2 America
Junior      3-0 Quindio
Cali        2-1 Tolima
Tulua       3-1 Santa Fe
Huila       2-2 Caldas

Round 13 [Apr 28]
Nacional    1-0 DI Medellin
Tolima      1-0 Envigado
Caldas      6-0 America
Bucaramanga 1-1 Junior
Santa Fe    2-2 Pasto
Quindio     3-1 Huila
Magdalena   0-0 Tulua
Cali        2-0 Millonarios

Round 14 [May 2]
DI Medellin 4-2 Santa Fe
Envigado    3-1 Cali
Junior      0-1 Nacional
Millonarios 3-2 Caldas
Huila       1-1 Bucaramanga
America     4-1 Quindio
Pasto       1-0 Magdalena
Tulua       0-1 Tolima

Round 15 [May 9]
Nacional    5-1 Huila
Envigado    3-1 Millonarios
Magdalena   1-1 DI Medellin
Santa Fe    2-2 Junior
Bucaramanga 1-2 America
Cali        1-1 Tulua
Tolima      2-2 Pasto
Quindio     1-1 Caldas

Round 16 [May 16]
America     0-0 Nacional
Millonarios 2-4 Quindio
Junior      3-2 Magdalena
DI Medellin 1-1 Tolima
Tulua       1-0 Envigado
Pasto       3-1 Cali
Caldas      0-0 Bucaramanga
Huila       0-0 Santa Fe

Round 17 [May 23]
Nacional    0-0 Caldas
Tolima      3-1 Junior
Bucaramanga 3-1 Quindio
Magdalena   3-3 Huila
Tulua       2-2 Millonarios
Santa Fe    1-2 America
Envigado    2-1 Pasto
Cali        1-1 DI Medellin

Round 18 
[May 30]
America     2-3 Magdalena
DI Medellin 2-1 Envigado       [corrected from 2-2]
Junior      3-2 Cali
Millonarios 2-2 Bucaramanga
Pasto       0-2 Tulua
Quindio     2-2 Nacional
Huila       0-1 Tolima
[Jun 3]
Caldas      3-0 Santa Fe       [corrected from 2-0]

Round 19 [Jun 6]
Nacional    2-0 Bucaramanga
Pasto       2-2 Millonarios
Tolima      1-1 America
Magdalena   0-2 Caldas
Santa Fe    2-2 Quindio
Tulua       1-1 DI Medellin
Cali        3-0 Huila
Envigado    2-0 Junior

Round 20 [Jun 9]
DI Medellin 3-0 Pasto
Millonarios 1-1 Nacional
Huila       2-1 Envigado
Caldas      2-0 Tolima
Quindio     0-1 Magdalena
Bucaramanga 0-1 Santa Fe
Junior      1-0 Tulua
America     4-1 Cali           [corrected from 3-1]

Round 21 [Jun 13]
DI Medellin 0-0 Huila
Envigado    1-3 Quindio
Tolima      3-1 Nacional
Pasto       1-1 America
Cali        3-2 Bucaramanga
Millonarios 1-0 Junior
Tulua       3-3 Caldas
Magdalena   0-1 Santa Fe

Round 22 [Jun 20] [local derbies]
Santa Fe    0-1 Millonarios
Nacional    1-1 DI Medellin
Bucaramanga 0-0 Pasto
Quindio     0-1 Tulua
Caldas      1-0 Envigado
America     2-1 Cali
Huila       1-1 Tolima
Junior      2-2 Magdalena

Table:

 1.CD América Cali        22 11  7  4 42-27 40 
 2.Atl. Nacional          22  9  9  4 25-18 36   
 3.Once Caldas            22  9  7  6 35-19 34  
 4.Atl. Junior            22  9  7  6 34-34 34
 5.Dep. Tolima            22  7 11  4 25-20 32
 6.Dep. Tuluá             22  8  7  7 31-31 31  
 7.Dep. Cali              22  9  4  9 37-41 31  
 8.Dep. Indep. Medellín   22  6 12  4 26-20 30   
 9.Atl. Bucaramanga       22  5 12  5 30-24 27
10.Indep. Santa Fe        22  6  8  8 23-26 26  
11.Millonarios            22  5 10  7 25-34 25  
12.Dep. Pasto             22  4 13  5 32-32 25
13.Dep. Quindío           22  6  6 10 32-40 24
14.Envigado FC            22  6  4 12 21-32 22   
15.Un. Magdalena          22  4 10  8 31-38 22
16.Atl. Huila             22  3 11  8 18-31 20 

[first tie-breaker: number of wins]

Topscorers Apertura 1999

Orlando Ballesteros        Bucaramanga       12
Julian Tellez              America           12
Sergio Galvan              Once Caldas       11
Marcio Cruz                Tulua             10
Nestor Salazar             Tulua              9
Giovanny Cordoba           Cali               8
Milton Rodriguez           Santa Fe           8
Carlos Rendon              Pasto              8
Jorge Agudelo              Envigado           7
Jairo Fernando Castillo    America            7
Daniel Tilger              Millonarios        7
Jorge Diaz                 Quindio            7
John Charria               Pasto              7
Orlando Maturana           Tolima             7
Jose Herrera               Magdalena          7



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,292,128 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0019
Controller Execution Time ( Home / Category )  0.0850
Total Execution Time  0.0869
  CADENA URL  
/apertura_primera_b_colombia1999
  GET DATOS  
$_GET['/apertura_primera_b_colombia1999']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (27)  
0.0021  SELECT type FROM routes WHERE alias = 'apertura_primera_b_colombia1999'
0.0049  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 = 1999 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=1 DESC LIMIT 1
0.0022  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=196 AND type_rel = 3
0.0049  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.0032  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.0021  SELECT text_es as historical_text FROM leagues_text WHERE id=5379
0.0023  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 = 33854 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.0018  SELECT type,rule FROM rules WHERE categoryId = 196 ORDER BY type = 'tables_draw' DESC,type != 'extra' DESC, `order` ASC
0.0018  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-04-26 02:31:13' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0018  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=2 AND last_update > '2024-04-26 02:31:13' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0018  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=4 AND last_update > '2024-04-26 02:31:13' 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-26 02:31:13' 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_primera_b_colombia' AND (l.group_code = 0 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 1999 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=0 DESC LIMIT 1
0.0019  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=33854 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 = 33854 AND esl.points > 0 ORDER BY esl.points DESC LIMIT 3
0.0018  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 = 33854 AND esl.points > 0
0.0017  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-27" AND c.`active`= 1 and c.comment_id is null and c.lang = 1 AND l.`id` = 33854 ORDER BY creation_date DESC LIMIT 0, 10
0.0022  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-27" AND c.`active`= 1 and comment_id is null and c.lang = 1 AND l.`id` = 33854
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 `calendars1999` 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` = 33854 AND c.`round` = 22 ORDER BY shedule ASC LIMIT 200
0.0019  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 `events1999` e INNER JOIN calendars1999 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 = 33854 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 `events1999` e INNER JOIN calendars1999 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 = 33854 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 `tables1999` 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 = 33854 AND t.round = 20 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0019  SELECT *,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables1999` 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 = 33854 AND t.round = 22 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0018  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-26 00:00:00' AND c.`shedule` < '2024-04-30 23:59:59' AND l.id = 33854 ORDER BY c.shedule ASC, fcoef DESC LIMIT 5
0.0023  SELECT data1, data2 FROM services_tags WHERE categoryId=196
0.0023  SELECT group_code, extraName from `leagues` WHERE categoryId=196 AND year=1999