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.PALESTINO		34 23  7  4  73-32  53  - Champions          
 2.Cobreloa		34 22  5  7  69-37  49  (Calama)
 3.O'Higgins     	34 17  8  9  64-39  42  (Rancagua)  
 4.Unión Española	34 17  7 10  52-41  41  
 5.Everton		34 14 12  8  55-40  40  (Viña del Mar)  
 6.Colo Colo		34 15  7 12  62-55  37     
 7.Universidad de Chile	34 11 14  9  41-33  36      
 8.Aviación		34 12 10 12  51-51  34    
 9.Universidad Católica	34 11 11 12  43-37  33      
10.Concepción		34 12  9 13  44-47  33  (Concepción)  
11.Lota Schwager	34  9 15 10  46-43  33  (Coronel)
12.Audax Italiano	34 10 12 12  36-39  32   
13.Green Cross-Temuco	34 10 12 12  52-57  32  (Temuco)            
14.Santiago Morning	34 10 12 12  43-49  32   
15.Ñublense		34 10 10 14  34-49  30  (Chillán) - Relegation Playoff 
16.Coquimbo Unido	34  8  8 18  38-56  24  (Coquimbo) - Relegation Playoff 
17.Huachipato		34  5  7 22  26-55  17  (Talcahuano) - Relegated  
18.Rangers		34  5  4 25  28-97  14  (Talca) - Relegated 

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

Round 21
Concepción		1-0 Colo Colo	
Audax Italiano		0-2 Santiago Morning
Ñublense		0-3 O'Higgins
Universidad Católica	0-5 Cobreloa			
Green Cross		0-1 Palestino
Lota Schwager	       14-1 Rangers                 [Rangers played with youth team]
Aviación		1-1 Universidad de Chile
Everton			1-0 Coquimbo Unido	
Unión Española		1-0 Huachipato

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

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

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

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

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

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

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

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

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

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

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

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

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

Final Table:

 1.PALESTINO		34 23  7  4  73-32  53  - Champions          
 2.Cobreloa		34 22  5  7  69-37  49  (Calama)
 3.O'Higgins     	34 17  8  9  64-39  42  (Rancagua)  
 4.Unión Española	34 17  7 10  52-41  41  
 5.Everton		34 14 12  8  55-40  40  (Viña del Mar)  
 6.Colo Colo		34 15  7 12  62-55  37     
 7.Universidad de Chile	34 11 14  9  41-33  36      
 8.Aviación		34 12 10 12  51-51  34    
 9.Universidad Católica	34 11 11 12  43-37  33      
10.Concepción		34 12  9 13  44-47  33  (Concepción)  
11.Lota Schwager	34  9 15 10  46-43  33  (Coronel)
12.Audax Italiano	34 10 12 12  36-39  32   
13.Green Cross-Temuco	34 10 12 12  52-57  32  (Temuco)            
14.Santiago Morning	34 10 12 12  43-49  32   
15.Ñublense		34 10 10 14  34-49  30  (Chillán) - Relegation Playoff 
16.Coquimbo Unido	34  8  8 18  38-56  24  (Coquimbo) - Relegation Playoff 
17.Huachipato		34  5  7 22  26-55  17  (Talcahuano) - Relegated  
18.Rangers		34  5  4 25  28-97  14  (Talca) - Relegated 

Relegated: Huachipato (Talcahuano) and Rangers (Talca)
Promoted : Santiago Wanderers (Valparaíso) and Naval (Talcahuano)     

Liguilla Pre-Libertadores

Participants:

Cobreloa		runners-up in Campeonato Oficial  
O'Higgins     		third place in Campeonato Oficial  
Unión Española		fourth place in Campeonato Oficial  
Everton			fifth place in Campeonato Oficial  

Round 1
Everton			1-0 O'Higgins
Unión Española		2-1 Cobreloa

Round 2
O'Higgins		2-1 Cobreloa
Unión Española		2-0 Everton

Round 3
Cobreloa		1-1 Everton
O'Higgins		1-0 Unión Española

Final Table:

 1.Unión Española	 3  2  0  1   4- 2   4  - Playoff
 2.O'Higgins		 3  2  0  1   3- 2   4  - Playoff
 3.Everton		 3  1  1  1   2- 3   3  
 4.Cobreloa		 3  0  1  2   3- 5   1      

Playoff
O'Higgins		2-2 Unión Española	

O'Higgins winners Liguilla Pre-Libertadores; it is not entirely clear why;
according to some sources because of their better record in the regular season,
according to other sources because they won the head-to-head in the Liguilla.


Author: Eduardo Espina
(ecem54 at chile.com)
Last updated: 13 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,311,896 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0021
Controller Execution Time ( Home / Category )  0.0781
Total Execution Time  0.0802
  CADENA URL  
/apertura_chile1978/grupo1
  GET DATOS  
$_GET['/apertura_chile1978/grupo1']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (25)  
0.0018  SELECT type FROM routes WHERE alias = 'apertura_chile1978'
0.0042  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 = 1978 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=1 DESC LIMIT 1
0.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=41 AND type_rel = 3
0.0032  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.0025  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 dt.nameShow,dt.basealias,t.id,t.teamId FROM teams t INNER JOIN datateams dt ON t.teamId = dt.id WHERE t.league_id = 28493 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='1978' WHERE c.parentId=41 GROUP BY c.id ORDER BY c.order_id ASC
0.0019  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-04-27 22:04:04' 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 22:04:04' 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 22:04:04' 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=3 AND last_update > '2024-04-27 22:04:04' 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 = 1978 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=0 DESC LIMIT 1
0.0021  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=28493 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 = 28493 AND esl.points > 0 ORDER BY esl.points DESC LIMIT 3
0.0019  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 = 28493 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` = 28493 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` = 28493
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 `calendars1978` 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` = 28493 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 `events1978` e INNER JOIN calendars1978 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 = 28493 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 `events1978` e INNER JOIN calendars1978 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 = 28493 AND e.real_date > NOW() - INTERVAL 1 MONTH ORDER BY e.real_date DESC LIMIT 30
0.0025  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 `tables1978` 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 = 28493 AND t.round = 32 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0020  SELECT *,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables1978` 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 = 28493 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0017  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-28 00:00:00' AND c.`shedule` < '2024-05-02 23:59:59' AND l.id = 28493 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=1978