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.UNIVERSIDAD DE CHILE	34 21  8  5 100-48  50  Championship Playoff  
 2.Universidad Católica	34 22  6  6  78-47  50  Championship Playoff  
 3.Colo Colo		34 17  7 10  94-67  41   
 4.La Serena		34 17  7 10  67-58  41  (La Serena)
 5.Unión Española	34 15  8 11  63-50  38        
 6.Santiago Morning	34 13 11 10  53-51  37    
 7.Santiago Wanderers	34 12 11 11  49-50  35  (Valparaíso)   
 8.Everton		34 10 15  9  53-55  35  (Viña del Mar)     
 9.Unión San Felipe	34 10 11 13  54-54  31  (San Felipe)
10.Audax Italiano	34  8 14 12  54-61  30      
11.O'Higgins		34  8 14 12  54-66  30  (Rancagua)    
12.Unión Calera		34 12  5 17  52-63  29  (La Calera)
13.Ferrobádminton	34  8 13 13  45-61  29  
14.Magallanes		34  9 11 14  41-62  29     
15.Rangers		34 10  8 16  42-53  28  (Talca)      
16.Palestino		34  7 14 13  44-59  28  
17.San Luis		34  8 10 16  49-66  26  (Quillota)
18.Green Cross		34  9  7 18  58-79  25  Relegated   

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

Final Table:

 1.UNIVERSIDAD DE CHILE	34 21  8  5 100-48  50  Championship Playoff  
 2.Universidad Católica	34 22  6  6  78-47  50  Championship Playoff  
 3.Colo Colo		34 17  7 10  94-67  41   
 4.La Serena		34 17  7 10  67-58  41  (La Serena)
 5.Unión Española	34 15  8 11  63-50  38        
 6.Santiago Morning	34 13 11 10  53-51  37    
 7.Santiago Wanderers	34 12 11 11  49-50  35  (Valparaíso)   
 8.Everton		34 10 15  9  53-55  35  (Viña del Mar)     
 9.Unión San Felipe	34 10 11 13  54-54  31  (San Felipe)
10.Audax Italiano	34  8 14 12  54-61  30      
11.O'Higgins		34  8 14 12  54-66  30  (Rancagua)    
12.Unión Calera		34 12  5 17  52-63  29  (La Calera)
13.Ferrobádminton	34  8 13 13  45-61  29  
14.Magallanes		34  9 11 14  41-62  29     
15.Rangers		34 10  8 16  42-53  28  (Talca)      
16.Palestino		34  7 14 13  44-59  28  
17.San Luis		34  8 10 16  49-66  26  (Quillota)
18.Green Cross		34  9  7 18  58-79  25  Relegated   

Final
  - 3-63 U. DE CHILE	5-3 U. Católica		(in Santiago de Chile)

Universidad de Chile  champions

Relegated: Green Cross
Promoted : Coquimbo Unido (Coquimbo)


Author: Eduardo Espina
(ecem54 at chile.com)
Last updated: 10 May 2007

(C) Copyright Eduardo Espina and RSSSF 2005/07

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,310,400 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0019
Controller Execution Time ( Home / Category )  0.0695
Total Execution Time  0.0715
  CADENA URL  
/apertura_chile1962
  GET DATOS  
$_GET['/apertura_chile1962']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (21)  
0.0019  SELECT type FROM routes WHERE alias = 'apertura_chile1962'
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 = 1 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 1962 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=1 DESC LIMIT 1
0.0021  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 = 28471 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0021  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='1962' WHERE c.parentId=41 GROUP BY c.id ORDER BY c.order_id ASC
0.0018  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-04-27 21:34:22' 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 21:34:22' 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 21:34:22' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0020  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=3 AND last_update > '2024-04-27 21:34:22' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0027  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 = 1962 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=0 DESC LIMIT 1
0.0023  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=28471 AND rel.round=34
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 = 28471 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` = 28471 ORDER BY creation_date DESC LIMIT 0, 10
0.0024  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` = 28471
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 `calendars1962` 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` = 28471 AND c.`round` = 34 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 `events1962` e INNER JOIN calendars1962 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 = 34 AND e.real_date IS NOT NULL AND e.league_id = 28471 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 `events1962` e INNER JOIN calendars1962 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 = 28471 AND e.real_date > NOW() - INTERVAL 1 MONTH ORDER BY e.real_date DESC LIMIT 30
0.0024  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 `tables1962` 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 = 28471 AND t.round = 32 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 `tables1962` 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 = 28471 AND t.round = 34 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 = 28471 ORDER BY c.shedule ASC, fcoef DESC LIMIT 5
0.0021  SELECT data1, data2 FROM services_tags WHERE categoryId=41
0.0021  SELECT group_code, extraName from `leagues` WHERE categoryId=41 AND year=1962