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.UNIÓN ESPAÑOLA	34 21  9  4  72-28  51  - Champions          
 2.Everton		34 20  9  5  64-38  49  (Viña del Mar)  
 3.Palestino		34 18 11  5  70-33  47   
 4.Colo Colo		34 15 12  7  56-43  42     
 5.Universidad de Chile	34 13 13  8  50-35  39      
 6.Lota Schwager	34 11 14  9  46-45  36  (Coronel)
 7.Concepción		34 14  7 13  48-52  35  (Concepción)  
 8.Aviación		34 12 10 12  46-51  34    
 9.Audax Italiano	34 12  9 13  48-53  33   
10.O'Higgins     	34 10 11 13  40-44  31  (Rancagua)  
11.Huachipato		34  9 12 13  39-46  30  (Talcahuano)  
12.Green Cross-Temuco	34 10 10 14  46-62  30  (Temuco)            
13.Ñublense		34  8 12 14  38-45  28  (Chillán)  
14.Universidad Católica	34  8 12 14  36-48  28      
15.Santiago Wanderers	34  9 10 15  50-66  28  (Valparaíso) - Relegation Playoff
16.Ovalle		34  6 15 13  42-52  27  (Ovalle) - Relegated 
17.Santiago Morning	34  9  9 16  37-50  27  - Relegation Playoff
18.Antofagasta		34  5  7 22  29-66  17  (Antofagasta) - Relegated

Round 1
Lota Schwager		3-1 Green Cross
Colo Colo		4-2 Ovalle 
Unión Española		1-1 Everton	 
Universidad de Chile	1-1 Huachipato
Aviación		2-0 Audax Italiano
Concepción		2-0 Universidad Católica
Santiago Wanderers	1-0 Santiago Morning
Antofagasta		1-1 Palestino
O'Higgins		5-2 Ñublense 

Round 2
O'Higgins		0-0 Lota Schwager
Ñublense		5-0 Antofagasta			
Palestino		4-1 Santiago Wanderers		
Santiago Morning	0-0 Concepción
Universidad Católica	1-3 Aviación
Audax Italiano		2-0 Universidad de Chile
Huachipato		1-4 Unión Española
Everton 		3-1 Colo Colo
Ovalle			1-1 Green Cross

Round 3
Lota Schwager		2-2 Ovalle		 
Green Cross		3-2 Everton	
Colo Colo		0-3 Huachipato
Unión Española		2-0 Audax Italiano
Universidad de Chile	2-0 Universidad Católica				
Aviación		1-0 Santiago Morning
Concepción		1-5 Palestino
Santiago Wanderers	1-1 Ñublense
Antofagasta		0-2 O'Higgins

Round 4
Antofagasta		1-1 Lota Schwager	
O'Higgins		2-2 Santiago Wanderers
Ñublense		3-1 Concepción
Palestino		0-0 Aviación			
Santiago Morning	1-1 Universidad de Chile
Universidad Católica	1-1 Unión Española
Audax Italiano		0-2 Colo Colo
Huachipato		3-0 Green Cross
Everton			1-0 Ovalle

Round 5
Lota Schwager		2-2 Everton	
Ovalle			1-2 Huachipato
Green Cross		4-3 Audax Italiano
Colo Colo		3-3 Universidad Católica
Unión Española		2-0 Santiago Morning	
Universidad de Chile	3-2 Palestino
Aviación		3-1 Ñublense
Concepción		1-0 O'Higgins
Santiago Wanderers	3-0 Antofagasta

Round 6
Santiago Wanderers	4-4 Lota Schwager
Antofagasta		1-1 Concepción			
O'Higgins		0-1 Aviación
Ñublense		2-2 Universidad de Chile
Palestino		1-3 Unión Española
Santiago Morning	1-4 Colo Colo
Universidad Católica	2-1 Green Cross
Audax Italiano		1-1 Ovalle	
Huachipato		1-2 Everton

Round 7
Lota Schwager		1-0 Huachipato
Everton			4-2 Audax Italiano		 
Ovalle			1-0 Universidad Católica
Green Cross		1-1 Santiago Morning			
Colo Colo		1-0 Palestino
Unión Española		3-1 Ñublense	
Universidad de Chile	4-1 O'Higgins
Aviación		1-0 Antofagasta
Concepción		4-2 Santiago Wanderers

Round 8
Concepción		1-1 Lota Schwager
Santiago Wanderers	1-1 Aviación
Antofagasta		0-0 Universidad de Chile
O'Higgins		1-0 Unión Española	
Ñublense		0-1 Colo Colo	
Palestino		1-1 Green Cross
Santiago Morning	2-0 Ovalle
Universidad Católica	1-1 Everton
Audax Italiano		2-0 Huachipato

Round 9
Lota Schwager		0-0 Audax Italiano		 
Huachipato		2-2 Universidad Católica			
Everton			4-0 Santiago Morning
Ovalle			1-2 Palestino
Green Cross		2-1 Ñublense
Colo Colo		1-1 O'Higgins
Unión Española		2-4 Antofagasta
Universidad de Chile	1-2 Santiago Wanderers
Aviación		1-2 Concepción

Round 10
Aviación		0-2 Lota Schwager
Concepción		2-1 Universidad de Chile		 
Santiago Wanderers	0-2 Unión Española
Antofagasta		0-1 Colo Colo			
O'Higgins		1-1 Green Cross	
Ñublense		0-0 Ovalle
Palestino		6-1 Everton
Santiago Morning	2-2 Huachipato
Universidad Católica	1-2 Audax Italiano

Round 11
Lota Schwager		3-0 Universidad Católica
Audax Italiano		1-1 Santiago Morning
Huachipato		1-1 Palestino
Everton			1-0 Ñublense
Ovalle			2-1 O'Higgins
Green Cross		2-1 Antofagasta
Colo Colo		2-0 Santiago Wanderers
Unión Española		1-0 Concepción
Universidad de Chile	1-1 Aviación

Round 12
Universidad de Chile	0-1 Lota Schwager				
Aviación		1-1 Unión Española		 
Concepción		0-1 Colo Colo	
Santiago Wanderers	3-1 Green Cross
Antofagasta		0-2 Ovalle
O'Higgins		1-1 Everton	
Ñublense		2-1 Huachipato
Palestino		3-3 Audax Italiano
Santiago Morning	3-1 Universidad Católica

Round 13
Lota Schwager		1-0 Santiago Morning
Universidad Católica	2-1 Palestino	
Audax Italiano		3-1 Ñublense		 
Huachipato		2-1 O'Higgins	
Everton			3-0 Antofagasta
Ovalle			2-1 Santiago Wanderers
Green Cross		1-3 Concepción
Colo Colo		2-1 Aviación
Unión Española		0-0 Universidad de Chile

Round 14
Unión Española		1-1 Lota Schwager
Universidad de Chile	4-5 Colo Colo
Aviación		6-4 Green Cross	
Concepción		4-1 Ovalle
Santiago Wanderers	3-4 Everton			
Antofagasta		2-3 Huachipato
O'Higgins		0-1 Audax Italiano
Ñublense		0-0 Universidad Católica
Palestino		3-1 Santiago Morning	

Round 15
Lota Schwager		0-1 Palestino
Santiago Morning	0-0 Ñublense
Universidad Católica	0-0 O'Higgins
Audax Italiano		2-1 Antofagasta	
Huachipato		1-0 Santiago Wanderers
Everton			2-1 Concepción
Ovalle			2-2 Aviación
Green Cross		0-0 Universidad de Chile
Colo Colo		1-3 Unión Española

Round 16
Colo Colo		2-0 Lota Schwager	
Unión Española		7-0 Green Cross		 
Universidad de Chile	3-0 Ovalle
Aviación		0-2 Everton	
Concepción		1-1 Huachipato
Santiago Wanderers	2-3 Audax Italiano
Antofagasta		1-0 Universidad Católica
O'Higgins		1-1 Santiago Morning
Ñublense		2-1 Palestino	

Round 17
Lota Schwager		0-0 Ñublense
Palestino		4-2 O'Higgins	
Santiago Morning	2-1 Antofagasta		 
Universidad Católica	2-1 Santiago Wanderers
Audax Italiano		0-0 Concepción
Huachipato		1-1 Aviación
Everton			1-1 Universidad de Chile
Ovalle			1-2 Unión Española
Green Cross		2-2 Colo Colo

Round 18
Green Cross		3-2 Lota Schwager
Ovalle			0-0 Colo Colo
Everton			1-1 Unión Española	 
Huachipato		0-1 Universidad de Chile
Audax Italiano		3-2 Aviación
Universidad Católica	1-0 Concepción
Santiago Morning	1-1 Santiago Wanderers
Palestino		3-0 Antofagasta
Ñublense		1-3 O'Higgins

Round 19
Lota Schwager		0-2 O'Higgins
Antofagasta		0-0 Ñublense			
Santiago Wanderers	1-1 Palestino		
Concepción		1-1 Santiago Morning
Aviación		0-0 Universidad Católica
Universidad de Chile	1-1 Audax Italiano
Unión Española		2-2 Huachipato
Colo Colo		3-1 Everton	
Green Cross		1-1 Ovalle

Round 20
Ovalle			3-1 Lota Schwager		 
Everton			1-0 Green Cross	
Huachipato		0-0 Colo Colo
Audax Italiano		2-3 Unión Española
Universidad Católica	1-1 Universidad de Chile			
Santiago Morning	4-4 Aviación
Palestino		2-0 Concepción
Ñublense		3-1 Santiago Wanderers
O'Higgins		2-0 Antofagasta

Round 21
Lota Schwager		3-1 Antofagasta	
Santiago Wanderers	1-0 O'Higgins
Concepción		1-0 Ñublense
Aviación		1-3 Palestino			
Universidad de Chile	3-2 Santiago Morning
Unión Española		2-3 Universidad Católica
Colo Colo		0-1 Audax Italiano
Green Cross		1-0 Huachipato	
Ovalle			2-0 Everton

Round 22
Everton			1-1 Lota Schwager
Huachipato		2-1 Ovalle
Audax Italiano		1-1 Green Cross
Universidad Católica	2-2 Colo Colo
Santiago Morning	0-0 Unión Española	
Palestino		0-0 Universidad de Chile
Ñublense		0-1 Aviación
O'Higgins		3-1 Concepción
Antofagasta		0-1 Santiago Wanderers

Round 23
Lota Schwager		2-2 Santiago Wanderers
Concepción		4-2 Antofagasta			
Aviación		2-1 O'Higgins
Universidad de Chile	1-0 Ñublense
Unión Española		0-2 Palestino
Colo Colo		1-1 Santiago Morning
Green Cross		2-1 Universidad Católica
Ovalle			4-2 Audax Italiano
Everton			2-0 Huachipato

Round 24
Huachipato		1-1 Lota Schwager
Audax Italiano		1-2 Everton		 
Universidad Católica	2-1 Ovalle
Santiago Morning	2-1 Green Cross			
Palestino		1-1 Colo Colo
Ñublense		1-2 Unión Española	
O'Higgins		1-1 Universidad de Chile
Antofagasta		1-0 Aviación	
Santiago Wanderers	1-3 Concepción

Round 25
Lota Schwager		4-1 Concepción
Aviación		1-1 Santiago Wanderers
Universidad de Chile	0-1 Antofagasta
Unión Española		7-0 O'Higgins
Colo Colo		1-1 Ñublense	
Green Cross		0-1 Palestino
Ovalle			1-1 Santiago Morning
Everton			3-1 Universidad Católica
Huachipato		2-2 Audax Italiano

Round 26
Audax Italiano		1-2 Lota Schwager		 
Universidad Católica	2-0 Huachipato			
Santiago Morning	0-2 Everton
Palestino		2-1 Ovalle
Ñublense		1-3 Green Cross
O'Higgins		1-1 Colo Colo
Antofagasta		1-3 Unión Española	
Santiago Wanderers	0-4 Universidad de Chile
Concepción		2-1 Aviación

Round 27
Lota Schwager		0-1 Aviación
Universidad de Chile	4-2 Concepción	 
Unión Española		3-1 Santiago Wanderers
Colo Colo		2-3 Antofagasta			
Green Cross		1-0 O'Higgins	
Ovalle			0-0 Ñublense
Everton			0-0 Palestino
Huachipato		1-0 Santiago Morning
Audax Italiano		2-1 Universidad Católica

Round 28
Universidad Católica	0-2 Lota Schwager
Santiago Morning	0-0 Audax Italiano
Palestino		1-0 Huachipato
Ñublense		1-1 Everton
O'Higgins		2-0 Ovalle
Antofagasta		1-1 Green Cross
Santiago Wanderers	3-3 Colo Colo
Concepción		0-3 Unión Española	
Aviación		0-3 Universidad de Chile

Round 29
Lota Schwager		0-3 Universidad de Chile				
Unión Española		5-1 Aviación		 
Colo Colo		2-0 Concepción	
Green Cross		3-3 Santiago Wanderers
Ovalle			3-1 Antofagasta
Everton			1-2 O'Higgins
Huachipato		2-2 Ñublense
Audax Italiano		1-3 Palestino
Universidad Católica	1-1 Santiago Morning

Round 30
Santiago Morning	1-2 Lota Schwager
Palestino		1-1 Universidad Católica	
Ñublense		2-0 Audax Italiano		 
O'Higgins		2-0 Huachipato	
Antofagasta		1-2 Everton
Santiago Wanderers	2-1 Ovalle	
Concepción		2-2 Green Cross
Aviación		2-1 Colo Colo
Universidad de Chile	0-0 Unión Española

Round 31
Lota Schwager		0-2 Unión Española
Colo Colo		1-0 Universidad de Chile
Green Cross		1-1 Aviación	
Ovalle			0-2 Concepción
Everton			3-1 Santiago Wanderers			
Huachipato		0-0 Antofagasta
Audax Italiano		1-0 O'Higgins
Universidad Católica	0-1 Ñublense
Santiago Morning	0-5 Palestino

Round 32
Palestino		5-1 Lota Schwager
Ñublense		2-1 Santiago Morning
O'Higgins		1-1 Universidad Católica
Antofagasta		2-3 Audax Italiano	
Santiago Wanderers	0-2 Huachipato
Concepción		1-4 Everton	
Aviación		0-3 Ovalle
Universidad de Chile	1-0 Green Cross
Unión Española		1-0 Colo Colo

Round 33
Lota Schwager		2-2 Colo Colo	
Green Cross		0-1 Unión Española		 
Ovalle			2-3 Universidad de Chile
Everton			2-0 Aviación	
Huachipato		1-3 Concepción
Audax Italiano		2-3 Santiago Wanderers
Universidad Católica	3-1 Antofagasta
Santiago Morning	2-0 O'Higgins
Palestino		3-1 Ñublense

Round 34
Ñublense		1-1 Lota Schwager
O'Higgins		1-1 Palestino	
Antofagasta		1-5 Santiago Morning		 
Santiago Wanderers	1-0 Universidad Católica
Concepción		1-0 Audax Italiano
Aviación		3-1 Huachipato
Universidad de Chile	0-3 Everton
Unión Española		2-0 Ovalle	
Colo Colo		3-1 Green Cross

Final Table:

 1.UNIÓN ESPAÑOLA	34 21  9  4  72-28  51  - Champions          
 2.Everton		34 20  9  5  64-38  49  (Viña del Mar)  
 3.Palestino		34 18 11  5  70-33  47   
 4.Colo Colo		34 15 12  7  56-43  42     
 5.Universidad de Chile	34 13 13  8  50-35  39      
 6.Lota Schwager	34 11 14  9  46-45  36  (Coronel)
 7.Concepción		34 14  7 13  48-52  35  (Concepción)  
 8.Aviación		34 12 10 12  46-51  34    
 9.Audax Italiano	34 12  9 13  48-53  33   
10.O'Higgins     	34 10 11 13  40-44  31  (Rancagua)  
11.Huachipato		34  9 12 13  39-46  30  (Talcahuano)  
12.Green Cross-Temuco	34 10 10 14  46-62  30  (Temuco)            
13.Ñublense		34  8 12 14  38-45  28  (Chillán)  
14.Universidad Católica	34  8 12 14  36-48  28      
15.Santiago Wanderers	34  9 10 15  50-66  28  (Valparaíso) - Relegation Playoff
16.Ovalle		34  6 15 13  42-52  27  (Ovalle) - Relegated 
17.Santiago Morning	34  9  9 16  37-50  27  - Relegation Playoff
18.Antofagasta		34  5  7 22  29-66  17  (Antofagasta) - Relegated

Playoff against direct relegation
Santiago Morning	1-0 Ovalle

Relegated: Santiago Wanderers (Valparaíso), Ovalle (Ovalle) and Antofagasta (Antofagasta)
Promoted : Coquimbo Unido (Coquimbo), Rangers (Talca) and Cobreloa (Calama)     

Liguilla Pre-Libertadores

Participants:

Everton     		runners-up in Campeonato Oficial  
Palestino		third place in Campeonato Oficial  
Colo Colo		fourth place in Campeonato Oficial  
Universidad de Chile	fifth place in Campeonato Oficial  

Round 1
Palestino		1-0 Universidad de Chile
Colo Colo		1-0 Everton

Round 2
Palestino		2-2 Everton
Colo Colo		2-2 Universidad de Chile

Round 3
Everton			4-2 Universidad de Chile
Palestino		2-1 Colo Colo

Final Table:

 1.Palestino		 3  2  1  0   5- 3   5  - Winners   
 2.Everton		 3  1  1  1   6- 5   3   
 3.Colo Colo		 3  1  1  1   4- 4   3  
 4.Universidad de Chile  3  0  1  2   4- 7   1      

Palestino 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,354,816 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0028
Controller Execution Time ( Home / Category )  0.0952
Total Execution Time  0.0980
  CADENA URL  
/apertura_chile1977/grupo2
  GET DATOS  
$_GET['/apertura_chile1977/grupo2']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (26)  
0.0018  SELECT type FROM routes WHERE alias = 'apertura_chile1977'
0.0076  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 = 1977 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=2 DESC LIMIT 1
0.0019  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=41 AND type_rel = 3
0.0030  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.0022  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.0021  SELECT text_es as historical_text FROM leagues_text WHERE id=182
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 = 28492 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0020  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='1977' 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 15:35:29' 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=2 AND last_update > '2024-04-27 15:35:29' 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=4 AND last_update > '2024-04-27 15:35:29' 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 15:35:29' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0031  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 = 1977 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=0 DESC LIMIT 1
0.0020  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=28492 AND rel.round=34
0.0019  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 = 28492 AND esl.points > 0 ORDER BY esl.points DESC LIMIT 3
0.0033  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 = 28492 AND esl.points > 0
0.0019  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` = 28492 ORDER BY creation_date DESC LIMIT 0, 10
0.0021  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` = 28492
0.0021  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 `calendars1977` 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` = 28492 AND c.`round` = 34 ORDER BY shedule ASC LIMIT 200
0.0021  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 `events1977` e INNER JOIN calendars1977 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 = 28492 ORDER BY total DESC LIMIT 40
0.0019  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 `events1977` e INNER JOIN calendars1977 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 = 28492 AND e.real_date > NOW() - INTERVAL 1 MONTH ORDER BY e.real_date DESC LIMIT 30
0.0027  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 `tables1977` 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 = 28492 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 `tables1977` 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 = 28492 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 = 28492 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=1977