4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Información Histórica 
						
Campeonato de Apertura

First Round

Colo Colo		3-2 Santiago Morning
Santiago Morning	4-2 Colo Colo			

Iberia 			4-3 Universidad de Chile	 
Universidad de Chile	2-3 Iberia	 

Unión Española   	2-1 Audax Italiano		
Audax Italiano		3-3 Unión Española   		

Everton			3-1 Universidad Católica
Universidad Católica	1-4 Everton

Santiago Wanderers	5-2 Badminton
Badminton		0-3 Santiago Wanderers

Losers' Round

Universidad de Chile	1-0 Universidad Católica
Universidad Católica	5-4 Universidad de Chile

Audax Italiano		2-1 Badminton
Badminton		3-1 Audax Italiano

Colo Colo		bye

Semifinals

Badminton		1-0 Colo Colo
Universidad Católica	bye

Final
Universidad Católica	3-2 Badminton

Winners' Round

Santiago Wanderers	4-2 Everton
Everton			0-1 Santiago Wanderers

Santiago Morning	3-2 Unión Española
Unión Española		3-3 Santiago Morning

Iberia			bye

Semifinals

Santiago Morning	3-1 Iberia
Santiago Wanderers	bye

Final
SANTIAGO MORNING	3-2 Santiago Wanderers

Santiago Morning are winners of the Campeonato de Apertura

Campeonato Oficial

Final Table:

 1.UNIVERSIDAD CATÓLICA	22 16  2  4  43-25  34  Champions 
 2.Santiago Wanderers	22 13  4  5  48-23  30  (Valparaíso) 
 3.Audax Italiano	22 11  5  6  45-33  27   
 4.Santiago Morning	22  8  8  6  39-36  24     
 5.Unión Española	22  9  5  8  49-43  23    
 6.Universidad de Chile	22  9  5  8  52-51  23      
 7.Everton		22 10  3  9  40-43  23  (Viña del Mar) 
 8.Magallanes		22  7  8  7  39-41  22      
 9.Colo Colo		22  6  7  9  46-38  19     
10.Green Cross		22  8  3 11  52-53  19   
11.Iberia		22  3  7 12  30-53  13   
12.Badminton		22  1  5 16  27-71   7    

Round 1
Colo Colo		3-3 Green Cross
Universidad Católica	1-1 Iberia	 
Audax Italiano		4-4 Santiago Morning
Magallanes		5-3 Badminton
Universidad de Chile	4-2 Everton
Santiago Wanderers	2-1 Unión Española

Round 2
Colo Colo		0-2 Universidad Católica
Santiago Wanderers	1-3 Magallanes
Badminton		2-5 Unión Española		
Universidad de Chile	3-2 Green Cross
Santiago Morning	3-2 Everton
Audax Italiano		0-0 Iberia

Round 3
Colo Colo		3-1 Universidad de Chile		 
Universidad Católica	1-0 Santiago Morning	
Unión Española		3-2 Iberia
Everton			3-3 Magallanes
Green Cross		3-2 Badminton
Santiago Wanderers	2-0 Audax Italiano

Round 4
Universidad Católica	2-1 Green Cross	
Audax Italiano		3-4 Unión Española
Santiago Morning	2-0 Colo Colo
Everton			2-1 Santiago Wanderers
Universidad de Chile	6-0 Magallanes
Badminton		0-1 Iberia

Round 5
Magallanes		3-1 Green Cross
Universidad de Chile	1-1 Santiago Morning
Unión Española		1-2 Everton
Colo Colo		2-3 Audax Italiano
Badminton		2-3 Universidad Católica	
Santiago Wanderers	2-0 Iberia

Round 6
Iberia			2-3 Everton
Audax Italiano		4-2 Universidad de Chile
Santiago Wanderers	4-0 Green Cross
Santiago Morning	4-1 Badminton
Magallanes		3-0 Universidad Católica
Colo Colo		3-3 Unión Española

Round 7
Colo Colo		0-1 Everton
Audax Italiano	     	3-1 Magallanes		 
Unión Española		2-3 Santiago Morning
Santiago Wanderers	3-0 Badminton
Iberia			2-2 Green Cross
Universidad Católica	4-1 Universidad de Chile	

Round 8
Magallanes		1-1 Santiago Morning
Unión Española		1-4 Universidad de Chile
Audax Italiano		3-0 Badminton
Santiago Wanderers	0-2 Universidad Católica
Everton			5-3 Green Cross	
Colo Colo		0-0 Iberia

Round 9
Unión Española		1-1 Magallanes		 
Universidad de Chile	6-1 Badminton
Audax Italiano		2-5 Green Cross
Colo Colo		1-2 Santiago Wanderers
Universidad Católica	3-2 Everton
Santiago Morning	1-1 Iberia

Round 10
Iberia			2-2 Universidad de Chile
Santiago Wanderers	3-1 Santiago Morning	 
Green Cross		4-3 Unión Española
Everton			3-0 Badminton
Universidad Católica	2-3 Audax Italiano	
Colo Colo		1-2 Magallanes

Round 11
Colo Colo		8-1 Badminton
Iberia			3-2 Magallanes
Unión Española		2-0 Universidad Católica
Santiago Wanderers	1-2 Universidad de Chile
Audax Italiano		2-0 Everton
Santiago Morning	2-1 Green Cross

Round 12
Green Cross		2-3 Colo Colo	
Iberia			1-2 Universidad Católica		 
Santiago Morning	1-1 Audax Italiano	
Badminton		0-0 Magallanes
Everton			1-3 Universidad de Chile
Unión Española		1-1 Santiago Wanderers

Round 13
Universidad Católica	2-0 Colo Colo
Magallanes		0-2 Santiago Wanderers	
Unión Española		2-2 Badminton		 
Green Cross		4-4 Universidad de Chile	
Everton			1-3 Santiago Morning
Iberia			1-3 Audax Italiano

Round 14
Universidad de Chile	0-5 Colo Colo
Santiago Morning	1-2 Universidad Católica
Iberia			0-4 Unión Española	
Magallanes		0-0 Everton
Badminton		1-3 Green Cross
Audax Italiano		2-1 Santiago Wanderers

Round 15
Green Cross		2-3 Universidad Católica
Unión Española		2-1 Audax Italiano
Colo Colo		1-0 Santiago Morning
Santiago Wanderers	7-0 Everton	
Magallanes		1-1 Universidad de Chile
Iberia			3-3 Badminton

Round 16
Green Cross		3-1 Magallanes	
Santiago Morning	1-1 Universidad de Chile		 
Everton			1-2 Unión Española
Audax Italiano		2-1 Colo Colo	
Universidad Católica	1-0 Badminton
Iberia			2-3 Santiago Wanderers

Round 17
Everton			3-2 Iberia
Universidad de Chile	1-6 Audax Italiano	
Green Cross		0-2 Santiago Wanderers		 
Badminton		2-0 Santiago Morning
Universidad Católica	5-3 Magallanes
Unión Española		2-2 Colo Colo

Round 18
Everton			2-1 Colo Colo
Magallanes		1-0 Audax Italiano
Santiago Morning	2-1 Unión Española	
Badminton		1-5 Santiago Wanderers
Green Cross		5-1 Iberia
Universidad de Chile	1-0 Universidad Católica

Round 19
Santiago Morning	2-2 Magallanes
Universidad de Chile	0-4 Unión Española
Badminton		1-1 Audax Italiano
Universidad Católica	0-0 Santiago Wanderers	
Green Cross		1-3 Everton
Iberia			2-6 Colo Colo

Round 20
Magallanes		2-3 Unión Española	
Badminton		2-5 Universidad de Chile		 
Green Cross		0-1 Audax Italiano
Santiago Wanderers	1-1 Colo Colo	
Everton			0-2 Universidad Católica
Iberia			0-2 Santiago Morning

Round 21
Universidad de Chile	3-4 Iberia
Santiago Morning	3-3 Santiago Wanderers	
Unión Española		1-2 Green Cross		 
Badminton		0-4 Everton
Audax Italiano		1-2 Universidad Católica
Magallanes		2-2 Colo Colo

Round 22
Badminton		3-3 Colo Colo
Magallanes		3-0 Iberia
Universidad Católica	4-1 Unión Española	
Universidad de Chile	1-2 Santiago Wanderers
Everton			0-0 Audax Italiano
Green Cross		5-2 Santiago Morning

Final Table:

 1.UNIVERSIDAD CATÓLICA	22 16  2  4  43-25  34  Champions 
 2.Santiago Wanderers	22 13  4  5  48-23  30  (Valparaíso) 
 3.Audax Italiano	22 11  5  6  45-33  27   
 4.Santiago Morning	22  8  8  6  39-36  24     
 5.Unión Española	22  9  5  8  49-43  23    
 6.Universidad de Chile	22  9  5  8  52-51  23      
 7.Everton		22 10  3  9  40-43  23  (Viña del Mar) 
 8.Magallanes		22  7  8  7  39-41  22      
 9.Colo Colo		22  6  7  9  46-38  19     
10.Green Cross		22  8  3 11  52-53  19   
11.Iberia		22  3  7 12  30-53  13   
12.Badminton		22  1  5 16  27-71   7    


División de Honor Amateur (Second Level)

Participants: 

Ferroviarios (Santiago) - Champions and Promoted
Maestranza Central
Santiago Central
Santiago National
Walter Müller
Rangers (Talca)
América (Rancagua)
Trasandino (Los Andes)
San Luis (Quillota)
Administración Puerto (Valparaiso)
Israelita Maccabi



Author:
 Eduardo Espina
(ecem54 at chile.com)
Last updated: 23 Nov 2005

(C) Copyright Eduardo Espina and RSSSF 2005

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,282,096 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0020
Controller Execution Time ( Home / Category )  0.4266
Total Execution Time  0.4286
  CADENA URL  
/apertura_chile1949/grupo1
  GET DATOS  
$_GET['/apertura_chile1949/grupo1']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (21)  
0.0144  SELECT type FROM routes WHERE alias = 'apertura_chile1949'
0.0293  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 = 1949 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=1 DESC LIMIT 1
0.0146  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 = 28449 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0147  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='1949' WHERE c.parentId=41 GROUP BY c.id ORDER BY c.order_id ASC
0.0146  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-04-27 22:49:20' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0147  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=2 AND last_update > '2024-04-27 22:49:20' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0146  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=4 AND last_update > '2024-04-27 22:49:20' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0145  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=3 AND last_update > '2024-04-27 22:49:20' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0151  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 = 1949 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=0 DESC LIMIT 1
0.0147  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=28449 AND rel.round=22
0.0149  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 = 28449 AND esl.points > 0
0.0146  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` = 28449 ORDER BY creation_date DESC LIMIT 0, 10
0.0157  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` = 28449
0.0151  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 `calendars1949` 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` = 28449 AND c.`round` = 22 ORDER BY shedule ASC LIMIT 200
0.0148  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 `events1949` e INNER JOIN calendars1949 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 = 28449 ORDER BY total DESC LIMIT 40
0.0146  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 `events1949` e INNER JOIN calendars1949 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 = 28449 AND e.real_date > NOW() - INTERVAL 1 MONTH ORDER BY e.real_date DESC LIMIT 30
0.0150  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 `tables1949` 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 = 28449 AND t.round = 20 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0146  SELECT *,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables1949` 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 = 28449 AND t.round = 22 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0144  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-28 00:00:00' AND c.`shedule` < '2024-05-02 23:59:59' AND l.id = 28449 ORDER BY c.shedule ASC, fcoef DESC LIMIT 5
0.0155  SELECT data1, data2 FROM services_tags WHERE categoryId=41
0.0155  SELECT group_code, extraName from `leagues` WHERE categoryId=41 AND year=1949