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.EVERTON		34 22  9  3  77-44  53  (Viña del Mar) - Championship Playoff
 2.Unión Española	34 21 11  2  69-28  53  - Championship Playoff      
 3.Universidad de Chile	34 17 11  6  70-41  45      
 4.Colo Colo		34 16 12  6  57-36  44     
 5.Palestino		34 16 10  8  67-53  42   
 6.Green Cross-Temuco	34 16  9  9  57-38  41  (Temuco)            
 7.Universidad Católica	34 14 10 10  48-39  38      
 8.Santiago Wanderers	34 11 11 12  53-61  33  (Valparaíso)   
 9.Concepción		34 12  7 15  61-59  31  (Concepción)  
10.Ovalle		34  9 12 13  46-48  30  (Ovalle)  
11.Antofagasta		34 12  6 16  51-70  30  (Antofagasta)
12.Aviación		34  9 10 15  49-70  28    
13.Lota Schwager	34  7 13 14  48-62  27  (Coronel)
14.Santiago Morning	34 10  7 17  41-57  27   
15.Huachipato		34 10  6 18  49-64  26  (Talcahuano) - Relegation Playoff
16.Rangers		34  7 11 16  41-62  25  (Talca) - Relegation Playoff
17.Naval     		34  7  8 19  39-56  22  (Talcahuano) - Relegated
18.La Serena		34  6  5 23  41-76  17  (La Serena) - Relegated

Round 1
Universidad Católica	3-2 Ovalle 
Unión Española		1-1 Everton	 
Palestino         	2-2 Lota Schwager 
Green Cross		1-0 Naval
Concepción		1-3 Universidad de Chile 
Huachipato		0-1 Santiago Morning 
Santiago Wanderers	1-1 Aviación 
La Serena		1-2 Colo Colo 
Antofagasta		7-1 Rangers 

Round 2
Colo Colo		2-2 Santiago Wanderers
Aviación		0-3 Huachipato			
Santiago Morning	1-0 Concepción		
Universidad de Chile	2-1 Antofagasta
La Serena		0-0 Universidad Católica
Everton			1-0 Ovalle
Rangers			2-2 Palestino
Naval	 		0-4 Unión Española
Lota Schwager		0-0 Green Cross

Round 3
Universidad Católica	1-1 Everton		 
Unión Española		2-1 Lota Schwager	
Palestino		2-0 Universidad de Chile
Antofagasta		2-1 Santiago Morning
Ovalle			5-2 Naval				
Huachipato		2-2 Colo Colo
Green Cross		1-0 Rangers
Concepción		4-3 Aviación
Santiago Wanderers	3-0 La Serena

Round 4
Colo Colo		2-1 Concepción	
Aviación		3-3 Antofagasta
Santiago Morning	0-3 Palestino
Universidad de Chile	2-1 Green Cross			
La Serena		1-2 Huachipato
Rangers			2-3 Unión Española
Santiago Wanderers	2-1 Universidad Católica
Naval			0-1 Everton
Lota Schwager		1-2 Ovalle

Round 5
Universidad Católica	0-1 Naval	
Unión Española		2-2 Universidad de Chile
Palestino		3-0 Aviación
Antofagasta		1-3 Colo Colo
Ovalle			0-0 Rangers	
Everton			2-1 Lota Schwager
Concepción		2-2 La Serena
Huachipato		1-5 Santiago Wanderers
Green Cross		1-0 Santiago Morning

Round 6
Colo Colo		1-1 Palestino
Aviación		1-1 Green Cross			
Santiago Morning	0-2 Unión Española
Universidad de Chile	1-1 Ovalle
La Serena		0-2 Antofagasta
Santiago Wanderers	1-0 Concepción
Huachipato		3-2 Universidad Católica
Lota Schwager		2-1 Naval	
Rangers			0-2 Everton

Round 7
Universidad Católica	3-1 Lota Schwager
Unión Española		3-2 Aviación		 
Palestino		4-3 La Serena
Antofagasta		2-1 Santiago Wanderers			
Ovalle			2-1 Santiago Morning
Everton			2-1 Universidad de Chile	
Concepción		0-3 Huachipato
Naval			1-1 Rangers
Green Cross		2-1 Colo Colo

Round 8
Colo Colo		0-0 Unión Española
Aviación		0-1 Ovalle
Santiago Morning	1-2 Everton
Universidad de Chile	2-1 Naval	
La Serena		0-1 Green Cross	
Santiago Wanderers	2-4 Palestino
Rangers			2-1 Lota Schwager
Concepción		2-1 Universidad Católica
Huachipato		4-2 Antofagasta

Round 9
Universidad Católica	3-1 Rangers		 
Unión Española		2-0 La Serena			
Palestino		2-0 Huachipato
Antofagasta		2-2 Concepción
Ovalle			3-1 Colo Colo
Everton			2-2 Aviación
Naval			0-1 Santiago Morning
Lota Schwager		0-0 Universidad de Chile
Green Cross		5-2 Santiago Wanderers

Round 10
Colo Colo		2-0 Everton
Aviación		2-2 Naval		 
Santiago Morning	2-3 Lota Schwager
Universidad de Chile	6-3 Rangers			
Antofagasta		1-1 Universidad Católica	
La Serena		2-1 Ovalle
Santiago Wanderers	2-2 Unión Española
Concepción		0-1 Palestino
Huachipato		1-2 Green Cross

Round 11
Universidad Católica	3-4 Universidad de Chile
Unión Española		1-1 Huachipato
Palestino		7-2 Antofagasta
Ovalle			4-0 Santiago Wanderers
Everton			3-1 La Serena
Rangers			2-1 Santiago Morning
Lota Schwager		1-2 Aviación
Naval			1-0 Colo Colo
Green Cross		2-1 Concepción

Round 12
Universidad Católica	1-1 Palestino				
Colo Colo		2-0 Lota Schwager		 
Aviación		2-1 Rangers	
Santiago Morning	1-2 Universidad de Chile
Antofagasta		1-1 Green Cross
La Serena		5-0 Naval	
Santiago Wanderers	1-1 Everton
Concepción		0-1 Unión Española
Huachipato		3-2 Ovalle

Round 13
Santiago Morning	1-2 Universidad Católica
Universidad de Chile	6-0 Aviación	
Unión Española		5-0 Antofagasta		 
Green Cross		1-1 Palestino	
Lota Schwager		2-0 La Serena
Naval			0-2 Santiago Wanderers
Rangers			0-0 Colo Colo
Everton			3-0 Huachipato
Ovalle			2-1 Concepción

Round 14
Universidad Católica	3-2 Green Cross
Palestino		0-6 Unión Española
Colo Colo		2-1 Universidad de Chile	
Aviación		0-3 Santiago Morning
Antofagasta		3-2 Ovalle			
La Serena		2-1 Rangers
Santiago Wanderers	2-1 Lota Schwager
Concepción		3-2 Everton
Huachipato		1-0 Naval	

Round 15
Aviación		0-0 Universidad Católica
Santiago Morning	1-2 Colo Colo
Unión Española		2-1 Green Cross
Universidad de Chile	1-0 La Serena	
Lota Schwager		0-0 Huachipato
Naval			1-2 Concepción
Everton			4-3 Antofagasta
Rangers			2-0 Santiago Wanderers
Ovalle			1-3 Palestino

Round 16
Universidad Católica	0-1 Unión Española	
Palestino		2-3 Everton		 
Colo Colo		3-1 Aviación
Green Cross		4-1 Ovalle	
Concepción		1-1 Lota Schwager
Huachipato		0-2 Rangers
Santiago Wanderers	1-2 Universidad de Chile
La Serena		2-1 Santiago Morning
Antofagasta		2-1 Naval	

Round 17
Colo Colo		0-1 Universidad Católica
Aviación		3-1 La Serena	
Santiago Morning	2-2 Santiago Wanderers		 
Universidad de Chile	3-1 Huachipato
Ovalle			0-2 Unión Española
Everton			2-2 Green Cross
Rangers			1-1 Concepción
Naval			2-0 Palestino
Lota Schwager		1-1 Antofagasta

Round 18
Ovalle			2-2 Universidad Católica
Everton			3-0 Unión Española	 
Lota Schwager		0-0 Palestino
Naval			1-0 Green Cross
Universidad de Chile	4-2 Concepción
Santiago Morning	1-1 Huachipato
Aviación		1-5 Santiago Wanderers
Colo Colo		5-1 La Serena
Rangers			2-2 Antofagasta

Round 19
Santiago Wanderers	1-1 Colo Colo
Huachipato		2-3 Aviación			
Concepción		7-1 Santiago Morning		
Antofagasta		1-0 Universidad de Chile
Universidad Católica	4-1 La Serena
Ovalle			2-3 Everton
Palestino		2-1 Rangers
Unión Española		2-1 Naval	
Green Cross		6-0 Lota Schwager

Round 20
Everton			3-1 Universidad Católica		 
Lota Schwager		0-1 Unión Española	
Universidad de Chile	2-2 Palestino
Santiago Morning	1-2 Antofagasta
Naval			1-1 Ovalle			
Colo Colo		4-1 Huachipato
Rangers			1-3 Green Cross
Aviación		1-2 Concepción
La Serena		1-2 Santiago Wanderers

Round 21
Concepción		0-1 Colo Colo	
Antofagasta		1-2 Aviación
Palestino		0-0 Santiago Morning
Green Cross		2-2 Universidad de Chile			
Huachipato		1-0 La Serena
Unión Española		2-2 Rangers
Universidad Católica	2-0 Santiago Wanderers
Everton			3-1 Naval	
Ovalle			0-1 Lota Schwager

Round 22
Naval			0-1 Universidad Católica
Universidad de Chile	0-0 Unión Española
Aviación		3-1 Palestino
Colo Colo		1-0 Antofagasta
Rangers			0-0 Ovalle	
Lota Schwager		1-1 Everton
La Serena		2-2 Concepción
Santiago Wanderers	0-3 Huachipato
Santiago Morning	2-0 Green Cross

Round 23
Palestino		1-1 Colo Colo
Green Cross		2-0 Aviación			
Unión Española		1-1 Santiago Morning
Ovalle			0-0 Universidad de Chile
Antofagasta		1-0 La Serena
Concepción		3-1 Santiago Wanderers
Universidad Católica	1-1 Huachipato
Naval			2-2 Lota Schwager
Everton			2-1 Rangers

Round 24
Lota Schwager		2-2 Universidad Católica
Aviación		1-1 Unión Española		 
La Serena		1-1 Palestino
Santiago Wanderers	0-1 Antofagasta			
Santiago Morning	1-1 Ovalle
Universidad de Chile	1-1 Everton	
Huachipato		1-3 Concepción
Rangers			0-0 Naval	
Colo Colo		1-1 Green Cross

Round 25
Unión Española		1-0 Colo Colo
Ovalle			0-0 Aviación
Everton			5-1 Santiago Morning
Naval			0-1 Universidad de Chile
Green Cross		1-0 La Serena	
Palestino		1-2 Santiago Wanderers
Lota Schwager		4-1 Rangers
Universidad Católica	0-1 Concepción
Antofagasta		1-0 Huachipato

Round 26
Rangers			1-0 Universidad Católica		 
La Serena		1-3 Unión Española			
Huachipato		3-1 Palestino
Concepción		5-0 Antofagasta
Colo Colo		1-1 Ovalle
Aviación		1-2 Everton
Santiago Morning	1-1 Naval	
Universidad de Chile	6-1 Lota Schwager
Santiago Wanderers	2-1 Green Cross

Round 27
Everton			2-3 Colo Colo
Naval			2-2 Aviación	 
Lota Schwager		2-3 Santiago Morning
Rangers			0-0 Universidad de Chile			
Universidad Católica	1-0 Antofagasta	
Ovalle			1-1 La Serena
Unión Española		5-0 Santiago Wanderers
Palestino		2-1 Concepción
Green Cross		4-1 Huachipato

Round 28
Universidad de Chile	0-0 Universidad Católica
Huachipato		1-2 Unión Española
Antofagasta		1-2 Palestino
Santiago Wanderers	0-0 Ovalle
La Serena		1-4 Everton
Santiago Morning	1-0 Rangers
Aviación		2-0 Lota Schwager
Colo Colo		2-2 Naval	
Concepción		1-3 Green Cross

Round 29
Palestino		4-2 Universidad Católica				
Lota Schwager		2-2 Colo Colo		 
Rangers			1-2 Aviación	
Universidad de Chile	0-2 Santiago Morning
Green Cross		4-0 Antofagasta
Naval			4-0 La Serena
Everton			3-1 Santiago Wanderers
Unión Española		3-3 Concepción
Ovalle			3-1 Huachipato

Round 30
Universidad Católica	3-0 Santiago Morning
Aviación		3-7 Universidad de Chile	
Antofagasta		1-0 Unión Española		 
Palestino		1-0 Green Cross	
La Serena		5-3 Lota Schwager
Santiago Wanderers	2-0 Naval	
Colo Colo		4-1 Rangers
Huachipato		1-3 Everton
Concepción		3-2 Ovalle

Round 31
Green Cross		0-1 Universidad Católica
Unión Española		4-1 Palestino
Universidad de Chile	0-1 Colo Colo	
Santiago Morning	1-0 Aviación
Ovalle			2-0 Antofagasta			
Rangers			3-4 La Serena
Lota Schwager		2-2 Santiago Wanderers
Everton			3-3 Concepción
Naval			2-1 Huachipato

Round 32
Universidad Católica	2-1 Aviación
Colo Colo		4-2 Santiago Morning
Green Cross		1-4 Unión Española
La Serena		0-4 Universidad de Chile	
Huachipato		2-2 Lota Schwager
Concepción		3-2 Naval	
Antofagasta		2-3 Everton
Santiago Wanderers	2-2 Rangers
Palestino		5-2 Ovalle

Round 33
Unión Española		0-0 Universidad Católica	
Everton			3-2 Palestino		 
Aviación		1-1 Colo Colo
Ovalle			0-0 Green Cross	
Lota Schwager		3-1 Concepción
Rangers			3-2 Huachipato
Universidad de Chile	2-2 Santiago Wanderers
Santiago Morning	3-1 La Serena
Naval			5-1 Antofagasta

Round 34
Universidad Católica	1-0 Colo Colo
La Serena		2-4 Aviación	
Santiago Wanderers	2-2 Santiago Morning		 
Huachipato		2-3 Universidad de Chile
Unión Española		1-0 Ovalle
Green Cross		1-1 Everton
Concepción		0-1 Rangers
Palestino		3-1 Naval	
Antofagasta		2-3 Lota Schwager

Final Table:

 1.EVERTON		34 22  9  3  77-44  53  (Viña del Mar) - Championship Playoff
 2.Unión Española	34 21 11  2  69-28  53  - Championship Playoff      
 3.Universidad de Chile	34 17 11  6  70-41  45      
 4.Colo Colo		34 16 12  6  57-36  44     
 5.Palestino		34 16 10  8  67-53  42   
 6.Green Cross-Temuco	34 16  9  9  57-38  41  (Temuco)            
 7.Universidad Católica	34 14 10 10  48-39  38      
 8.Santiago Wanderers	34 11 11 12  53-61  33  (Valparaíso)   
 9.Concepción		34 12  7 15  61-59  31  (Concepción)  
10.Ovalle		34  9 12 13  46-48  30  (Ovalle)  
11.Antofagasta		34 12  6 16  51-70  30  (Antofagasta)
12.Aviación		34  9 10 15  49-70  28    
13.Lota Schwager	34  7 13 14  48-62  27  (Coronel)
14.Santiago Morning	34 10  7 17  41-57  27   
15.Huachipato		34 10  6 18  49-64  26  (Talcahuano) - Relegation Playoff
16.Rangers		34  7 11 16  41-62  25  (Talca) - Relegation Playoff
17.Naval     		34  7  8 19  39-56  22  (Talcahuano) - Relegated
18.La Serena		34  6  5 23  41-76  17  (La Serena) - Relegated

Championship Playoff (in Santiago)  
Unión Española		0-0 Everton
Unión Española		1-3 Everton			(Replay)


Relegated: Rangers (Talca), Naval (Talcahuano) and La Serena (La Serena)
Promoted : Ñublense (Chillán), O'Higgins (Rancagua) and Audax Italiano (Santiago)     


Liguilla Pre-Libertadores

Participants:

Unión Española		runners-up in Campeonato Oficial  
Universidad de Chile	third place in Campeonato Oficial  
Colo Colo		fourth place in Campeonato Oficial  
Palestino		fifth place in Campeonato Oficial  

Round 1
Unión Española		2-0 Colo Colo
Universidad de Chile	4-2 Palestino

Round 2
Colo Colo		2-2 Universidad de Chile
Palestino		3-2 Unión Española

Round 3
Palestino		3-1 Colo Colo
Universidad de Chile	2-2 Unión Española

Final Table:

 1.Universidad de Chile  3  1  2  0   8- 6   4  - Playoff
 2.Palestino		 3  2  0  1   8- 7   4  - Playoff
 3.Unión Española	 3  1  1  1   6- 5   3   
 4.Colo Colo		 3  0  1  2   3- 7   1  

Playoff
Universidad de Chile	2-2 Palestino		(Universidad de Chile on goal difference)

Universidad de Chile winners Liguilla Pre-Libertadores



Author: Eduardo Espina
(ecem54 at chile.com)
Last updated: 11 Dec 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,310,864 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0031
Controller Execution Time ( Home / Category )  0.4885
Total Execution Time  0.4917
  CADENA URL  
/apertura_chile1976
  GET DATOS  
$_GET['/apertura_chile1976']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (25)  
0.0145  SELECT type FROM routes WHERE alias = 'apertura_chile1976'
0.0290  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 = 1976 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=1 DESC LIMIT 1
0.0145  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=41 AND type_rel = 3
0.0151  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.0147  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.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 = 28491 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0146  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='1976' WHERE c.parentId=41 GROUP BY c.id ORDER BY c.order_id ASC
0.0145  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-04-27 21:10:11' 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=2 AND last_update > '2024-04-27 21:10:11' 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=4 AND last_update > '2024-04-27 21:10:11' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0144  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=3 AND last_update > '2024-04-27 21:10:11' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0149  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 = 1976 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=0 DESC LIMIT 1
0.0145  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=28491 AND rel.round=34
0.0145  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 = 28491 AND esl.points > 0 ORDER BY esl.points DESC LIMIT 3
0.0145  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 = 28491 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` = 28491 ORDER BY creation_date DESC LIMIT 0, 10
0.0154  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` = 28491
0.0152  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 `calendars1976` 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` = 28491 AND c.`round` = 34 ORDER BY shedule ASC LIMIT 200
0.0152  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 `events1976` e INNER JOIN calendars1976 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 = 28491 ORDER BY total DESC LIMIT 40
0.0155  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 `events1976` e INNER JOIN calendars1976 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 = 28491 AND e.real_date > NOW() - INTERVAL 1 MONTH ORDER BY e.real_date DESC LIMIT 30
0.0171  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 `tables1976` 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 = 28491 AND t.round = 32 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0156  SELECT *,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables1976` 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 = 28491 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0146  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 = 28491 ORDER BY c.shedule ASC, fcoef DESC LIMIT 5
0.0147  SELECT data1, data2 FROM services_tags WHERE categoryId=41
0.0147  SELECT group_code, extraName from `leagues` WHERE categoryId=41 AND year=1976