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 Oficial

First Stage

Table:

 1.Audax Italiano	22 13  4  5  44-29  30  Championship Group
 2.Everton		22 12  5  5  54-36  29  Championship Group
 3.Colo Colo    	22 11  6  5  45-35  28  Championship Group
 4.Unión Española	22 11  5  6  53-44  27  Championship Group
 5.Santiago Morning   	22 11  4  7  50-30  26  Championship Group
 6.Universidad de Chile	22  8  9  5  33-32  25  Championship Group
 - - - - - - - - - - - - - - - - - - - - - - -
 7.Universidad Católica	22  9  6  7  46-34  24  Relegation Group    
 8.Iberia		22  9  2 11  44-43  20  Relegation Group    
 9.Santiago Wanderers	22  6  6 10  35-39  18  Relegation Group    
10.Magallanes		22  5  5 12  37-57  15  Relegation Group    
11.Ferrobádminton	22  4  3 15  33-65  11  Relegation Group    
12.Green Cross		22  4  3 15  30-60  11  Relegation Group    

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

Table:

 1.Audax Italiano	22 13  4  5  44-29  30  Championship Group
 2.Everton		22 12  5  5  54-36  29  Championship Group
 3.Colo Colo    	22 11  6  5  45-35  28  Championship Group
 4.Unión Española	22 11  5  6  53-44  27  Championship Group
 5.Santiago Morning   	22 11  4  7  50-30  26  Championship Group
 6.Universidad de Chile	22  8  9  5  33-32  25  Championship Group
 - - - - - - - - - - - - - - - - - - - - - - -
 7.Universidad Católica	22  9  6  7  46-34  24  Relegation Group    
 8.Iberia		22  9  2 11  44-43  20  Relegation Group    
 9.Santiago Wanderers	22  6  6 10  35-39  18  Relegation Group    
10.Magallanes		22  5  5 12  37-57  15  Relegation Group    
11.Ferrobádminton	22  4  3 15  33-65  11  Relegation Group    
12.Green Cross		22  4  3 15  30-60  11  Relegation Group    

Second Stage

Championship Group

Table:

 1.Unión Española	 5  4  1  0  19-10   9 
 2.Audax Italiano	 5  3  0  2  11-13   6
 3.Universidad de Chile	 5  2  1  2   5- 6   5
 4.Colo Colo		 5  2  0  3   7- 7   4
 5.Santiago Morning	 5  2  0  3  11-12   4
 6.Everton		 5  1  0  4   9-14   2

Round 1
Audax Italiano		2-6 Unión Española
Universidad de Chile	1-4 Everton
Santiago Morning	2-1 Colo Colo

Round 2
Unión Española		1-1 Universidad de Chile
Colo Colo		1-0 Everton
Audax Italiano		4-2 Santiago Morning

Round 3
Audax Italiano		1-0 Universidad de Chile
Colo Colo		2-4 Unión Española
Everton			1-4 Santiago Morning

Round 4
Audax Italiano		0-3 Colo Colo
Unión Española		4-2 Everton
Universidad de Chile	2-0 Santiago Morning

Round 5
Audax Italiano		4-2 Everton
Universidad de Chile	1-0 Colo Colo
Unión Española		4-3 Santiago Morning

Table:

 1.Unión Española	 5  4  1  0  19-10   9 
 2.Audax Italiano	 5  3  0  2  11-13   6
 3.Universidad de Chile	 5  2  1  2   5- 6   5
 4.Colo Colo		 5  2  0  3   7- 7   4
 5.Santiago Morning	 5  2  0  3  11-12   4
 6.Everton		 5  1  0  4   9-14   2

Aggregate Final Table:

 1.UNIÓN ESPAÑOLA	27 15  6  6  72-54  36  Playoff
 2.Audax Italiano	27 16  4  7  55-42  36  Playoff
 3.Colo Colo		27 13  6  8  52-42  32  
 4.Everton		27 13  5  9  63-50  31  (Viña del Mar) 
 5.Santiago Morning	27 13  4 10  61-42  30
 6.Universidad de Chile	27 10 10  7  38-38  30

Final [Dec 13]
UNIÓN ESPAÑOLA		1-0 Audax Italiano

Unión Española were the champions

Relegation Group

Table:

 1.Green Cross		 5  4  0  1  13- 7   8
 2.Magallanes		 5  3  1  1  11- 8   7
 3.Santiago Wanderers	 5  2  2  1   7- 7   6
 4.Ferrobádminton	 5  2  0  3  11-13   4
 5.Iberia		 5  1  1  3  12-14   3  
 6.Universidad Católica	 5  1  0  4  13-18   2

Round 1
Santiago Wanderers	0-2 Green Cross
Iberia			4-5 Universidad Católica
Magallanes		4-2 Ferrobádminton

Round 2
Iberia			2-2 Santiago Wanderers
Magallanes		3-2 Universidad Católica
Ferrobádminton		2-1 Green Cross

Round 3
Magallanes		2-1 Iberia
Ferrobádminton		1-2 Santiago Wanderers
Green Cross		4-1 Universidad Católica

Round 4
Santiago Wanderers	0-0 Magallanes
Ferrobádminton		4-3 Universidad Católica
Green Cross		3-2 Iberia

Round 5
Iberia			3-2 Ferrobádminton
Green Cross		3-2 Magallanes
Santiago Wanderers	3-2 Universidad Católica

Table:

 1.Green Cross		 5  4  0  1  13- 7   8
 2.Magallanes		 5  3  1  1  11- 8   7
 3.Santiago Wanderers	 5  2  2  1   7- 7   6
 4.Ferrobádminton	 5  2  0  3  11-13   4
 5.Iberia		 5  1  1  3  12-14   3  
 6.Universidad Católica	 5  1  0  4  13-18   2

Aggregate Final Table:

 7.Universidad Católica	27 10  6 11  59-52  26
 8.Santiago Wanderers	27  8  8 11  42-46  24  (Valparaíso)
 9.Iberia		27 10  3 14  56-57  23   
10.Magallanes		27  8  6 13  48-65  22
11.Green Cross		27  8  3 16  43-67  19
----------------------------------------------
12.Ferrobádminton	27  6  3 18  44-78  15  [*]

[*] Ferrobádminton were not relegated, apparently due to a rule 
    (the existence of which is unconfirmed) indicating that none of
    the teams that played in the first championship (1933, which
    applied to Ferrobádminton as merger of Ferroviarios and Badminton)
    could be relegated



Author:
 Eduardo Espina
(ecem54 at chile.com)
Last updated: 31 Jul 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,326,360 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0021
Controller Execution Time ( Home / Category )  0.0733
Total Execution Time  0.0754
  CADENA URL  
/apertura_chile1951/grupo2
  GET DATOS  
$_GET['/apertura_chile1951/grupo2']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (21)  
0.0020  SELECT type FROM routes WHERE alias = 'apertura_chile1951'
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_chile' AND (l.group_code = 2 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 1951 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=2 DESC LIMIT 1
0.0020  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 = 28452 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0019  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='1951' WHERE c.parentId=41 GROUP BY c.id ORDER BY c.order_id ASC
0.0020  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-04-27 19:32:42' 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-27 19:32:42' 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-27 19:32:42' 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=3 AND last_update > '2024-04-27 19:32:42' 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_chile' AND (l.group_code = 0 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 1951 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=0 DESC LIMIT 1
0.0022  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=28452 AND rel.round=22
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 = 28452 AND esl.points > 0
0.0018  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` = 28452 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-28" AND c.`active`= 1 and comment_id is null and c.lang = 1 AND l.`id` = 28452
0.0020  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 `calendars1951` 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` = 28452 AND c.`round` = 22 ORDER BY shedule ASC LIMIT 200
0.0020  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 `events1951` e INNER JOIN calendars1951 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 = 28452 ORDER BY total DESC LIMIT 40
0.0020  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 `events1951` e INNER JOIN calendars1951 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 = 28452 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 `tables1951` 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 = 28452 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 `tables1951` 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 = 28452 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-27 00:00:00' AND c.`shedule` < '2024-05-01 23:59:59' AND l.id = 28452 ORDER BY c.shedule ASC, fcoef DESC LIMIT 5
0.0020  SELECT data1, data2 FROM services_tags WHERE categoryId=41
0.0020  SELECT group_code, extraName from `leagues` WHERE categoryId=41 AND year=1951