4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Información Histórica 
						
First Division. Campeonato Oficial

Final Table:

 1.AUDAX ITALIANO	26 15  4  7  51-42  34  Champions 
 2.Universidad de Chile	26 10 11  5  51-41  31  
 3.Palestino		26 11  6  9  68-54  28   
 4.Santiago Wanderers	26 11  5 10  43-37  27  (Valparaíso)   
 5.Unión Española	26 11  4 11  54-49  26  
 6.Rangers		26 11  4 11  35-37  26  (Talca)  
 7.Everton		26 12  2 12  49-62  26  (Viña del Mar)   
 8.Colo Colo		26 10  5 11  60-53  25   
 9.Magallanes		26 10  5 11  43-58  25   
10.Green Cross		26  8  7 11  58-58  23   
11.Ferrobádminton	26  8  5 13  40-40  21  
12.O'Higgins		26  7  7 12  34-47  21  (Rancagua)    
13.Universidad Católica	26  8  5 13  35-49  21    
14.San Luis		26 12  6  8  42-36  17  [-13]  (Quillota) - Relegated  

Round 1
Audax Italiano		3-2 Green Cross
Universidad de Chile	3-2 Santiago Wanderers	 
Palestino		4-1 Universidad Católica
Colo Colo		4-4 Magallanes
O'Higgins		3-0 Unión Española
San Luis		2-1 Rangers
Everton			1-0 Ferrobádminton

Round 2
Santiago Wanderers	3-3 Magallanes
Rangers			1-3 Palestino
Green Cross		2-4 Everton		
Colo Colo		5-2 O'Higgins
Ferrobádminton		2-0 San Luis
Audax Italiano		1-0 Universidad de Chile
Unión Española		4-4 Universidad Católica

Round 3
Unión Española		3-2 Green Cross		 
Audax Italiano		3-2 Rangers	
Colo Colo		4-4 Palestino
Santiago Wanderers	3-1 Ferrobádminton
Everton			2-1 Universidad Católica
O'Higgins		1-1 Universidad de Chile
San Luis		6-2 Magallanes

Round 4
Everton			2-1 Magallanes	
Green Cross		4-1 Universidad Católica
Colo Colo		2-1 Rangers
O'Higgins		2-1 Palestino
Santiago Wanderers	3-1 Unión Española
Universidad de Chile	1-1 San Luis
Audax Italiano		2-2 Ferrobádminton

Round 5
Everton			0-2 Audax Italiano
O'Higgins		3-3 Santiago Wanderers
Universidad de Chile	2-2 Rangers
Colo Colo		2-3 San Luis
Universidad Católica	1-0 Ferrobádminton	
Magallanes		3-1 Green Cross
Unión Española		6-1 Palestino

Round 6
Universidad de Chile	2-2 Magallanes
Everton			3-1 Unión Española
Ferrobádminton		3-2 Colo Colo
San Luis		1-0 Santiago Wanderers
Audax Italiano		3-3 Palestino
Rangers			1-1 Green Cross
Universidad Católica	0-1 O'Higgins

Round 7
Everton			2-1 Santiago Wanderers
O'Higgins	     	1-1 Audax Italiano		 
San Luis		0-0 Palestino
Ferrobádminton		0-1 Rangers
Universidad de Chile	4-2 Green Cross
Universidad Católica	1-3 Magallanes	
Colo Colo		1-2 Unión Española

Round 8
Santiago Wanderers	4-3 Palestino
Rangers			4-1 Everton
San Luis		3-3 Green Cross
Magallanes		1-0 O'Higgins
Ferrobádminton		1-2 Universidad de Chile	
Universidad Católica	2-0 Colo Colo
Unión Española		1-2 Audax Italiano

Round 9
Ferrobádminton		3-2 Green Cross		 
Universidad de Chile	3-1 Unión Española
Audax Italiano		1-0 Santiago Wanderers
Colo Colo		3-0 Everton
Magallanes		3-1 Palestino
San Luis		3-0 Universidad Católica
O'Higgins		0-0 Rangers

Round 10
Unión Española		1-0 Rangers
Magallanes		2-1 Ferrobádminton	 
Colo Colo		1-1 Universidad de Chile
Palestino		8-3 Everton
Audax Italiano		1-0 Universidad Católica	
San Luis		3-0 O'Higgins
Santiago Wanderers	2-1 Green Cross

Round 11
Universidad Católica	0-1 Santiago Wanderers
Colo Colo		3-0 Green Cross
Universidad de Chile	1-1 Palestino
Rangers			1-0 Magallanes
Everton			3-0 O'Higgins
San Luis		1-2 Audax Italiano
Unión Española		2-1 Ferrobádminton

Round 12
Magallanes		1-0 Unión Española	
Palestino		3-3 Green Cross		 
Audax Italiano		2-1 Colo Colo	
Rangers			1-0 Santiago Wanderers
O'Higgins		1-1 Ferrobádminton
Everton			2-0 San Luis
Universidad de Chile	1-1 Universidad Católica

Round 13
Audax Italiano		3-4 Magallanes
Palestino		1-1 Ferrobádminton	
Colo Colo		2-1 Santiago Wanderers		 
Everton			1-3 Universidad de Chile	
Rangers			2-1 Universidad Católica
Green Cross		1-1 O'Higgins
Unión Española		5-1 San Luis

Round 14
Green Cross		3-1 Audax Italiano
Santiago Wanderers	2-0 Universidad de Chile
Universidad Católica	2-5 Palestino	
Magallanes		1-2 Colo Colo
Unión Española		2-1 O'Higgins
Rangers			1-0 San Luis
Ferrobádminton		2-3 Everton

Round 15
Magallanes		1-0 Santiago Wanderers
Palestino		2-0 Rangers
Everton			2-4 Green Cross
O'Higgins		1-1 Colo Colo	
San Luis		2-2 Ferrobádminton
Universidad de Chile	4-0 Audax Italiano
Universidad Católica	0-0 Unión Española

Round 16
Green Cross		2-1 Unión Española	
Rangers			2-0 Audax Italiano		 
Palestino		1-2 Colo Colo
Ferrobádminton		1-3 Santiago Wanderers	
Universidad Católica	4-3 Everton
Universidad de Chile	2-1 O'Higgins
Magallanes		0-2 San Luis

Round 17
Magallanes		1-1 Everton
Universidad Católica	1-1 Green Cross	
Rangers			1-5 Colo Colo		 
Palestino		4-3 O'Higgins
Unión Española		1-0 Santiago Wanderers
San Luis		1-1 Universidad de Chile
Ferrobádminton		1-2 Audax Italiano

Round 18
Audax Italiano		5-1 Everton
Santiago Wanderers	2-1 O'Higgins
Rangers			3-1 Universidad de Chile	
San Luis		2-1 Colo Colo
Ferrobádminton		0-1 Universidad Católica
Green Cross		4-2 Magallanes
Palestino		3-2 Unión Española

Round 19
Magallanes		0-3 Universidad de Chile
Unión Española		6-0 Everton
Colo Colo		2-2 Ferrobádminton
Santiago Wanderers	0-0 San Luis	
Palestino		2-1 Audax Italiano
Green Cross		2-2 Rangers
O'Higgins		0-1 Universidad Católica

Round 20
Santiago Wanderers	3-0 Everton	
Audax Italiano		3-0 O'Higgins		 
Palestino		2-1 San Luis
Rangers			2-1 Ferrobádminton	
Green Cross		4-4 Universidad de Chile
Magallanes		1-2 Universidad Católica
Unión Española		4-3 Colo Colo

Round 21
Palestino		1-3 Santiago Wanderers
Everton			4-1 Rangers	
Green Cross		0-2 San Luis		 
O'Higgins		3-1 Magallanes
Universidad de Chile	0-1 Ferrobádminton
Colo Colo		4-1 Universidad Católica
Audax Italiano		3-2 Unión Española

Round 22
Green Cross		1-2 Ferrobádminton
Unión Española		1-1 Universidad de Chile
Santiago Wanderers	1-1 Audax Italiano	
Everton			2-3 Colo Colo
Palestino		7-0 Magallanes
Universidad Católica	1-2 San Luis
Rangers			0-1 O'Higgins

Round 23
Rangers			3-0 Unión Española
Ferrobádminton		4-0 Magallanes	 
Universidad de Chile	3-2 Colo Colo
Everton			1-0 Palestino
Universidad Católica	2-0 Audax Italiano
O'Higgins		1-2 San Luis
Green Cross		5-1 Santiago Wanderers

Round 24
Santiago Wanderers	3-3 Universidad Católica
Green Cross		3-1 Colo Colo
Palestino		5-2 Universidad de Chile		
Magallanes		2-1 Rangers
O'Higgins		4-3 Everton
Audax Italiano		2-0 San Luis
Ferrobádminton		2-3 Unión Española

Round 25
Unión Española		2-2 Magallanes		 
Green Cross		3-2 Palestino	
Colo Colo		4-5 Audax Italiano
Santiago Wanderers	0-1 Rangers
Ferrobádminton		4-0 O'Higgins
San Luis		0-2 Everton
Universidad Católica	1-3 Universidad de Chile

Round 26
Magallanes		3-2 Audax Italiano	
Ferrobádminton		2-1 Palestino
Santiago Wanderers	2-0 Colo Colo
Universidad de Chile	3-3 Everton
Universidad Católica	3-1 Rangers
O'Higgins		3-2 Green Cross
San Luis		4-3 Unión Española

Final Table:

 1.AUDAX ITALIANO	26 15  4  7  51-42  34  Champions 
 2.Universidad de Chile	26 10 11  5  51-41  31  
 3.Palestino		26 11  6  9  68-54  28   
 4.Santiago Wanderers	26 11  5 10  43-37  27  (Valparaíso)   
 5.Unión Española	26 11  4 11  54-49  26  
 6.Rangers		26 11  4 11  35-37  26  (Talca)  
 7.Everton		26 12  2 12  49-62  26  (Viña del Mar)   
 8.Colo Colo		26 10  5 11  60-53  25   
 9.Magallanes		26 10  5 11  43-58  25   
10.Green Cross		26  8  7 11  58-58  23   
11.Ferrobádminton	26  8  5 13  40-40  21  
12.O'Higgins		26  7  7 12  34-47  21  (Rancagua)    
13.Universidad Católica	26  8  5 13  35-49  21    
14.San Luis		26 12  6  8  42-36  17  [-13]  (Quillota) - Relegated  

Relegation Group

Universidad Católica	1-0 Ferrobádminton
Ferrobádminton		1-0 O'Higgins
O'Higgins		4-2 Universidad Católica

Final Table:

 1.O'Higgins		2  1  0  1   4- 3   2
 2.Ferrobádminton	2  1  0  1   1- 1   2
 3.Universidad Católica	2  1  0  1   3- 4   2  Relegated

NB: The relegation through the above mentioned matches was revoked due 
    to a special situation: San Luis from Quillota had an ineligible 
    player (J.J.Negri from Argentina) so they lost 13 points. Due to this 
    and with 17 points, they had to be relegated instead of Universidad 
    Católica. In the real table they had been third with 30 points: their
    best championship ever! (till nowadays)


Author: Eduardo Espina
(ecem54 at chile.com)
Last updated: 15 Aug 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,327,064 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0021
Controller Execution Time ( Home / Category )  0.3831
Total Execution Time  0.3852
  CADENA URL  
/apertura_chile1957/grupo1
  GET DATOS  
$_GET['/apertura_chile1957/grupo1']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (26)  
0.0106  SELECT type FROM routes WHERE alias = 'apertura_chile1957'
0.0222  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 = 1957 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=1 DESC LIMIT 1
0.0109  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=41 AND type_rel = 3
0.0146  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.0119  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.0111  SELECT text_es as historical_text FROM leagues_text WHERE id=161
0.0116  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 = 28463 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0126  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='1957' WHERE c.parentId=41 GROUP BY c.id ORDER BY c.order_id ASC
0.0107  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-04-27 17:05:51' 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=2 AND last_update > '2024-04-27 17:05:51' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0106  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=4 AND last_update > '2024-04-27 17:05:51' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0126  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=3 AND last_update > '2024-04-27 17:05:51' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0111  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 = 1957 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=0 DESC LIMIT 1
0.0106  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=28463 AND rel.round=26
0.0106  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 = 28463 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 = 28463 AND esl.points > 0
0.0106  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` = 28463 ORDER BY creation_date DESC LIMIT 0, 10
0.0109  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` = 28463
0.0109  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 `calendars1957` 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` = 28463 AND c.`round` = 26 ORDER BY shedule ASC LIMIT 200
0.0108  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 `events1957` e INNER JOIN calendars1957 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 = 26 AND e.real_date IS NOT NULL AND e.league_id = 28463 ORDER BY total DESC LIMIT 40
0.0109  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 `events1957` e INNER JOIN calendars1957 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 = 28463 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 `tables1957` 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 = 28463 AND t.round = 24 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0109  SELECT *,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables1957` 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 = 28463 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0106  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 = 28463 ORDER BY c.shedule ASC, fcoef DESC LIMIT 5
0.0113  SELECT data1, data2 FROM services_tags WHERE categoryId=41
0.0113  SELECT group_code, extraName from `leagues` WHERE categoryId=41 AND year=1957