4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Información Histórica 
						
Final Table:
 
 1. COLO COLO (1)              30  17  10   3   60   22     46
 2. Universidad Católica (2)   30  13  11   6   64   41     38
 3. Unisn Española (2)         30  13  10   7   60   37     37
 4. O'higgins (2)              30  15   4  11   52   45     35
 5. Palestino                  30  12   9   9   52   45     33
 6. Deportes Concepción        30  12   9   9   41   45     33
 7. Cobreloa                   30  11   9  10   44   42     31
 8. Deportes La Serena         30   9  12   9   44   41     30
 9. Cobresal                   30   9  11  10   34   38     29
10. Fernandez Vial             30   7  13  10   29   49     27
11. Universidad de Chile       30   7  12  11   37   39     26
12. Santiago Wanderers         30   7  12  11   39   53     26
13. Naval                      30   8   9  13   32   47     25
14. Everton                    30   7  10  13   30   42     24
15. Deportes Iquique           30   9   6  15   43   56     24
16. Huachipato                 30   3  15  12   24   43     21

(1) 2 extra points for winning Copa Chile
(2) 1 extra point for reaching semifinals Copa Chile
 
CHAMPION: COLO COLO
COPA LIBERTADORES 1991: Colo Colo, Deportes Concepción
RELEGATED: Huachipato, Deportes Iquique
PROMOTED: Provincial Osorno, Coquimbo Unido

Topscorer: Rubén Martínez (Colo Colo)   22 goals

2nd to 5th place play-off for second Liberatores Cup place

 1. Dep. Concepción             3   2   0   1    5    4     4   
 2. Univ. Católica              3   1   1   1    6    5     3 
 3. O'Higgins                   3   1   1   1    3    5     2     
 4. Union Española              3   1   0   2    3    3     2   


Points System:
- 3 points to win with more of three goals
   - 2 points to win team
   - 1 points to deuce
- 0 points for 0-0
 
Round 1
[Mar 17]
NAV-UC  2-1 [4079, Torrens]
            [Baeza 48, Francino 58; Olivares 77]
            lp: Baeza(save Cornez) 57
IQ-CB   2-3 [4402, Toledo]
            [Guerrero 17, Ramos 47pen; Czornomaz 30, 65, 71]
            so: Ramos; Ortega
SER-CS  3-2 [3682, Imperatore]
            [Lobos 15, Leterier 29, Barraza 67pen; Torres 17, Araya 70]
SW-EV   3-2 [9155, Espinoza]
            [Latín 2, Vásquez 42, 87; Núñez 20, 36]
UE-OH   0-4 [Nacional Preliminary, Muñoz]
            [Cornejo 48, 90, González 54, 64]
            lp: ; Quintanilla(save Yávar) 74
U-CC    0-3 [74000, Castro]
            [Salgado 32, Dabrowski 39, Rivas 73og]
CON-FV  2-2 [5000, Guerrero]
            [Vargas 4, Baroni 23; Figueroa 50, Fuentes 77]
HUA-PAL 2-3 [2699, Gamboa]
            [Pino 35, Soto 46; V.H. Castañeda 49, 62, Toro 71]
 
Round 2
[Mar 21]
CB-HUA  1-1 [2351, Peña]
            [Czornomaz 79; Moya 60]
            so: ; Torres
CS-IQ   4-3 [1507, Navarrete]
            [Jeria 3, Bravo 54, Torres 55, Matusziczk 78; Donoso 2, 22, 53]
            so: ; Donoso
EV-UE   2-2 [1737, Vásquez]
            [Núñez 16, Guarda 61; Bustos 37, Córdova 48]
UC-PAL  6-4 [2571, Marín]
            [Reinoso 11, 47, 65, Barrera 42, 57, Soto 54; Toro 10, Garrido 61pen,
             V.H. Castañeda 79, Garrido 84]
            lp: Reinoso 25
            so: Monardes
CC-SW   4-1 [7602, Heller]
            [Dabrowski 20, 23, Pizarro 35pen, Martínez 79; Guerra 77]
OH-CON  3-1 [2982, Silva]
            [Molina 3, Cornejo 30, Betancourt 70; Bidoglio 78]
            so: ; Miranda
FV-U    1-1 [11854, Robles]
            [Figueroa 24; Hoffens 20]
NAV-SER 2-0 [2312, Massardo]
            [Valenzuela 30, Baeza 70]
 
Round 3
[Mar 25]
IQ-NAV  0-2 [3702, Guerrero]
            [Baeza 26, Jáuregui 81]
SER-UC  0-1 [5627, Robles]
            [Barrera 34]
SW-OH   0-0 [5699, Ojeda] 
UE-FV   5-0 [Santa Laura Preliminary, Imperatore]
            [Zambrano 28pen, Córdova 63, 85, Zambrano 88, 90]
U-EV    4-3*[Santa Laura 24000, Torrens]
            [Fajre 33, 55, 60, Bernal 48; Núñez 8, 65, Geoffroy 62]   
            *suspended 83
0-1                 [Mar 28] [Santa Laura 400, Torrens]
[Geoffroy 89]
 Final: 4-4
PAL-CB  0-0 [5116, Espinoza]
CON-CC  2-1 [11377, Marín]
            [Herrera 44, Rojas 79pen; Dabrowski 26]
            so: Villegas; González, Dabrowski
HUA-CS  2-1 [1253, Zúñiga]
            [Rosales 16, 63; Bravo 43]
 
Round 4
[Mar 31]
NAV-HUA 4-1 [5940, Espinoza]
            [Francino 25, Díaz 35pen, Jáuregui 55, Valenzuela 70; Pino 2]
OH-U    3-1 [10367, Vásquez]
            [Merlini 7, 41, Medina 88; Fajre 35]
SER-IQ  3-2 [2906, Peña]
            [Barraza 32pen, Arancibia 36, Leterier 76; Vega 14, Guerrero 22]
            so: Enríquez; Vega
UC-CB   1-3 [8902, Navarrete]
            [Estay 4; Pino 14, Czornomaz 14, Ortega 60]
CS-PAL  1-1 [2317, Heller]
            [Bravo 42; Garrido 90]
EV-CON  5-3 [2440, Castro]
            [Del Canto 33, Guarda 39, Salas 50, Núñez 74, Guarda 78; Ardiman 13, 65]
            so: ; Villamil
            lp: Núñez 61
CC-UE   0-0 [13265, Massardo]
FV-SW   2-3 [2319, Toledo]
            [García 8, Fuentes 26; Miranda 16, Miranda 54, Latín 61]
Round 6
[Apr 14]
OH-EV   4-2 [6025, Navarrete]
            [Mendoza 5pen, Merlini 59, Reyes 83, Molina 90; Núñez 52, Cruz 56]
NAV-CB  2-2 [6450, Marín]
            [Nazar 46, Lee Chong 60; Czornomaz 2, Pino 8]
            lp: H. Díaz(save León)
            so: ; León
UC-CS   4-1 [5407, Peña]
            [Contreras 7, 56, Reinoso 79, 80]
            lp: ; Matuszickz
            so: ; Fuentes
UE-CON  2-3 [5037, Robles]
            [Pérez 75, Yávar 89pen; Baroni 73, Vargas 82, 86]
SW-U    1-1 [10571, Guerrero]
            [Miranda 39; Tapia 48pen]
IQ-HUA  3-1 [3813, Heller]
            [Azargado 36pen, Suárez 67, Donoso 82; Navarrete 24pen]
CC-FV   1-1 [6721, Torrens]
            [Ormeño 28; Casanova 86pen]
 
Round 7
[Apr 18]
CB-SER  1-2 [2560, Zúñiga]
            [Alegría 53; Lobos 19, Enríquez 51]
HUA-UC  6-0 [1853, Vásquez]
            [Navarrete 42, Contreras 58, López 63, Navarrete 67, 75pen, Soto 86]
            i: ; injured C. Soto
CS-NAV  4-1 [1457, Gamboa]
            [Matuszickz 19, Tamayo 78, Bravo 85, Osorio 89; Jáuregui 60]
U-CON   1-1 [Santa Laura 7740, Imperatore]
            [Gálvez 83; Bidoglio 34]
OH-CC   1-3 [8991, Robles]
            [Reyes 26; Gutiérrez 7, Carreño 76, Martínez 83pen]
            lp: Mendoza(sae Leterier) 60, Meléndez(save Leterier) 81
UE-SW   3-2 [Santa Laura Preliminary, Peña]
            [Corró 41, Córdova 84, González 89; E. Pérez 9, J. Pérez 80]
PAL-IQ  2-4 [1680, Marín]
            [Toro 11, 81; Araujo 2, Suárez 40, Estay 69, Guerrero 71] 
FV-EV   2-1 [2284, Massardo]
            [Caraballo 30, Fuentes 48; Núñez 40]
 
Round 8
[Apr 21]
UC-NAV  4-3 [3994, Imperatore]
            [Contreras 19, Pérez 31, 51, Barrera 66; Francino 1, Nazar 11, 59]
CC-U    1-0 [Nacional 31197, Silva]
            [Espinoza 90]
[Apr 22]
PAL-HUA 0-3 [3597, Ojeda]
            [Bufarini 36, 90, Navarrete] 
CS-SER  3-0 [3621, Espinoza]
            [Osorio 10, Torres 40, Bravo 85]
CB-IQ   2-3 [3034, Hormazábal]
            [Reinoso 69, Alvarez 87; Araujo 41, Azargado 56, Guerrero 60]
            so: Rojas; Azargado, Castro
FV-CON  1-3 [6989, Vásquez]
            [Fuentes 40; Bidoglio 10, Baroni 77, Herrera 89]
OH-UE   1-2 [4422, Guerrero]
            [Reyes 9; González 19, 76]
EV-SW   1-2 [8122, Torrens]
            [Olivares 42og; Sepúlveda 72, Pérez 89]
 
Round 9
[Apr 25]
SW-CC   4-3 [5028, Imperatore]
            [Fuentes 23, Zabala 68, Pérez 30, 75; Gutiérrez 25, Moyano 54, Pastén 59]
IQ-CS   3-1 [3523, Castro]
            [Araujo 23, 64, Donoso 76; Jeria 67]
SER-NAV 3-3 [1700, Navarrete]
            [Lobos 5, 56, Barraza 80pen; Francino 2, Baeza 13, Gajardo 90]
PAL-UC  0-1 [2370, Zúñiga]
            [Contreras 65]
HUA-CB  2-1 [1424, Robles]
            [Rosales 23, Zambrano 82; Alvarez 36]
UE-EV   3-0 [Santa Laura Preliminary, Marín]
            [Miranda 43, Zambrano 80, Corró 81]
U-FV    3-1 [Santa Laura 4979, Gamboa] 
            [Tapia 47, Olguín 67, Hoffens 79; Fuentes 49]
CON-OH  2-2 [3032, Massardo]
            [Ardiman 7, Vargas 71; Meléndez 13, Medina 33]
 
Round 10
[Apr 28]
NAV-IQ  1-0 [2953, Torrens]
            [Nazar 73]
            so: ; Francino
EV-U    3-0 [6780, Ojeda]
            [Núñez 23, 76, Geoffroy 80]
CB-PAL  3-2 [2952, Silva]
            [Czornomaz 33, 66, 83; Lacroix 67, 77]
CS-HUA  1-1 [2085, Silva]
            [Bravo 61; Zambrano 63]
UC-SER  3-2 [6002, Guerrero]
            [Contreras 13, 35, 89; Puyol 32, Enríquez 68]
CC-CON  4-3 [4367, Peña]
            [Carreño 64, Montenegro 67, Gutiérrerz 76, Pastén 90; Ahumada 8,
             Herrera 17, 48]
            so: ; Villamil
OH-SW   3-0 [5198, Vásquez]
            [Cornejo 20, Medina 52, Meléndez 84]
            lp: Medina 22, Retamar 78
FV-UE   0-2 [1451, Heller]
            [E. Espinoza 70, 75]
 
Round 13
[May 19]
PAL-SER 0-3 [6541, Gamboa]
            [Cleber 68, 80, Puyol 75] 
HUA-IQ  1-1 [1583, Peña] 
            [Bufarini 46; Cortés 31]
            so: ; Araujo
[May 20]
CB-NAV  6-0 [3221, Toledo]
            [Czornomaz 6, 26, 43, Alarcón 16, Covarrubias 78, Pino 83]
CS-UC   3-0 [2003, Torrens]
            [Sáez 59, Tamayo 78, Matuszickz 82]
CON-UE  1-2 [1871, Castro]
            [Vargas 35; Corró 42, Messina 81]
FV-CC   2-1 [7887, Robles]
            [Figueroa 8, 38; Moyano 13]
U-SW    5-2 [5788, Navarrete]
            [Lira 27, 87, Gálvez 29, 90, O. Rojas 50; Fuentes 7, 32]
EV-OH   4-0 [2482, Espinoza]
            [Guarda 17, Geoffroy 41pen, 89, Roldán 62]
 
Final
Colo Colo   3-2  U. Católica 
 
Colo Colo Champion Copa Chile 1990
 
Topscorers
 Adrián Cczornomaz (Arg)      Cobreloa      13
 Aníbal González              O´Higgins     13  
 Gerardo Reinoso (Arg)        U. Católica   13
 
 



Authors:
 Juan Pablo Andrés
(jpandres@tutopia.com)
and Luis Antonio Reyes
(luchoasis@yahoo.es)
Last updated: 22 Jan 2006

(C) Copyright Juan Pablo Andrés,
Luis Antonio Reyes and RSSSF 1999/2006

INFORMACIÓN

El Campeonato Nacional de Primera División del Fútbol Profesional (por motivos de patrocinio, Campeonato Nacional Petrobras de Primera División) es la máxima categoría del fútbol profesional en Chile. Participan de la competencia 18 equipos y funciona con un sistema de ascensos y descensos con la categoría inmediatamente inferior, la Primera B. Es organizado por la Asociación Nacional de Fútbol Profesional, perteneciente a la Federación de Fútbol de Chile.



  USO DE MEMORIA  
4,298,528 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0026
Controller Execution Time ( Home / Category )  0.4001
Total Execution Time  0.4028
  CADENA URL  
/apertura_chile1990/grupo1
  GET DATOS  
$_GET['/apertura_chile1990/grupo1']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (25)  
0.0108  SELECT type FROM routes WHERE alias = 'apertura_chile1990'
0.0215  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'apertura_chile' AND (l.group_code = 1 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 1990 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=1 DESC LIMIT 1
0.0106  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=41 AND type_rel = 3
0.0119  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 3 AND rel.typeId = 41 AND rel.ln = 'es' AND rel.status=1 ORDER BY rel.creation_date desc,rel.cover_points DESC LIMIT 5
0.0109  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 (1205535,1205118,866586,866148,562646) ORDER BY n.cover_points DESC, update_date DESC
0.0107  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 = 28499 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0108  SELECT c.id, c.name, c.alias, c.stepParent, l.year FROM categories AS c INNER JOIN leagues AS l ON c.id=l.categoryId AND l.year='1990' WHERE c.parentId=41 GROUP BY c.id ORDER BY c.order_id ASC
0.0105  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-04-27 15:55:42' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0119  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=2 AND last_update > '2024-04-27 15:55:42' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0112  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=4 AND last_update > '2024-04-27 15:55:42' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0107  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=3 AND last_update > '2024-04-27 15:55:42' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0147  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'apertura_chile' AND (l.group_code = 0 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 1990 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=0 DESC LIMIT 1
0.0107  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=28499 AND rel.round=30
0.0107  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 = 28499 AND esl.points > 0 ORDER BY esl.points DESC LIMIT 3
0.0106  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 = 28499 AND esl.points > 0
0.0107  SELECT fau.user_name, c.*, NOW() as difference_time,creation_date FROM (leagues as l) INNER JOIN comments as c ON c.league_id = l.id LEFT JOIN fa_user fau ON fau.id = c.author_id WHERE c.creation_date > "2024-03-28" AND c.`active`= 1 and c.comment_id is null and c.lang = 1 AND l.`id` = 28499 ORDER BY creation_date DESC LIMIT 0, 10
0.0115  SELECT count(c.id) as cuenta FROM (leagues as l) INNER JOIN comments as c ON c.league_id = l.id WHERE c.creation_date > "2024-03-28" AND c.`active`= 1 and comment_id is null and c.lang = 1 AND l.`id` = 28499
0.0110  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 `calendars1990` 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` = 28499 AND c.`round` = 30 ORDER BY shedule ASC LIMIT 200
0.0109  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 `events1990` e INNER JOIN calendars1990 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 = 30 AND e.real_date IS NOT NULL AND e.league_id = 28499 ORDER BY total DESC LIMIT 40
0.0110  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 `events1990` e INNER JOIN calendars1990 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 = 28499 AND e.real_date > NOW() - INTERVAL 1 MONTH ORDER BY e.real_date DESC LIMIT 30
0.0115  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 `tables1990` 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 = 28499 AND t.round = 28 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0108  SELECT *,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables1990` 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 = 28499 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0105  SELECT c.id, 2024 AS year, IF(l.tables = 1 AND t1.points>0,((t1.points / (l.current_round * 3)) + (t2.points / (l.current_round * 3)))/2 * ct.coefficient,0.7 * ct.coefficient) as fcoef FROM `calendars2024` AS c INNER JOIN `leagues` AS l ON c.`league_id` = l.`id` INNER JOIN `categories` AS ct ON ct.`id` = l.`categoryId` LEFT JOIN tables2024 AS t1 ON t1.team = c.team1 AND t1.round = l.current_round LEFT JOIN tables2024 AS t2 ON t2.team = c.team2 AND t2.round = l.current_round WHERE c.`shedule` > '2024-04-27 00:00:00' AND c.`shedule` < '2024-05-01 23:59:59' AND l.id = 28499 ORDER BY c.shedule ASC, fcoef DESC LIMIT 5
0.0114  SELECT data1, data2 FROM services_tags WHERE categoryId=41
0.0114  SELECT group_code, extraName from `leagues` WHERE categoryId=41 AND year=1990