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 CATÓLICA	34 20  8  6  70-34  48  Champions   
 2.Colo Colo		34 17 10  7  63-42  44    
 3.Santiago Wanderers	34 16 11  7  46-33  43  (Valparaíso)   
 4.Universidad de Chile	34 18  6 10  79-49  42  
 5.Palestino		34 14 10 10  52-40  38  
 6.Magallanes		34 14 10 10  46-48  38     
 7.La Serena		34 12 12 10  46-42  36  (La Serena)
 8.Green Cross-Temuco	34 12 11 11  64-52  35  (Temuco)            
 9.O'Higgins		34 12 11 11  43-48  35  (Rancagua) 
10.Unión Calera		34 12  7 15  45-60  31  (La Calera)
11.Rangers		34 10 10 14  65-65  30  (Talca)      
12.Audax Italiano	34  9 12 13  52-56  30      
13.Everton		34 12  6 16  47-57  30  (Viña del Mar)     
14.Unión San Felipe	34 11  7 16  57-65  29  (San Felipe)
15.Unión Española	34  9 10 15  37-46  28        
16.San Luis		34  8 12 14  35-49  28  (Quillota)
17.Santiago Morning	34  8  8 18  41-69  24    
18.Ferrobádminton	34  8  7 19  45-78  23  Relegated 

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

Final Table:

 1.UNIVERSIDAD CATÓLICA	34 20  8  6  70-34  48  Champions   
 2.Colo Colo		34 17 10  7  63-42  44    
 3.Santiago Wanderers	34 16 11  7  46-33  43  (Valparaíso)   
 4.Universidad de Chile	34 18  6 10  79-49  42  
 5.Palestino		34 14 10 10  52-40  38  
 6.Magallanes		34 14 10 10  46-48  38     
 7.La Serena		34 12 12 10  46-42  36  (La Serena)
 8.Green Cross-Temuco	34 12 11 11  64-52  35  (Temuco)            
 9.O'Higgins		34 12 11 11  43-48  35  (Rancagua) 
10.Unión Calera		34 12  7 15  45-60  31  (La Calera)
11.Rangers		34 10 10 14  65-65  30  (Talca)      
12.Audax Italiano	34  9 12 13  52-56  30      
13.Everton		34 12  6 16  47-57  30  (Viña del Mar)     
14.Unión San Felipe	34 11  7 16  57-65  29  (San Felipe)
15.Unión Española	34  9 10 15  37-46  28        
16.San Luis		34  8 12 14  35-49  28  (Quillota)
17.Santiago Morning	34  8  8 18  41-69  24    
18.Ferrobádminton	34  8  7 19  45-78  23  Relegated 

Relegated: Ferrobádminton (Santiago)
Promoted : Huachipato (Talcahuano)




Author: Eduardo Espina
(ecem54 at chile.com)
Last updated: 17 Nov 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,359,632 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0024
Controller Execution Time ( Home / Category )  0.1057
Total Execution Time  0.1081
  CADENA URL  
/apertura_chile1966/grupo1
  GET DATOS  
$_GET['/apertura_chile1966/grupo1']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (37)  
0.0018  SELECT type FROM routes WHERE alias = 'apertura_chile1966'
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 = 1966 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.0028  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.0019  SELECT text_es as historical_text FROM leagues_text WHERE id=171
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 = 28477 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0022  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='1966' 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:33:36' 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:33:36' 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:33:36' 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 21:33:36' 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 = 1966 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=0 DESC LIMIT 1
0.0020  SELECT e.action, count(e.action) as total, e.player_id FROM events1966 e WHERE e.league_id IN (28477) AND (e.action IN (1,2,11,12,13) ) GROUP BY e.player_id ORDER BY total DESC, e.player_id ASC LIMIT 20
0.0018  SELECT dp.name, dp.last_name, dp.nick,dp.CountryCode,dp.alias,rp.team_id,dt.nameShow,dt.short_name,dt.basealias,rp.player_id,rp.teamId,dp.role FROM dataplayers AS dp INNER JOIN rel_players AS rp ON rp.player_id=dp.id AND rp.league_id IN (28477) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN () ORDER BY rp.in_squad = 1 DESC
0.0018  SELECT e.action, count(e.action) as total, e.player_id FROM events1966 e WHERE e.league_id IN (28477) AND (e.action IN (4,5) ) GROUP BY e.player_id ORDER BY total DESC, e.player_id ASC LIMIT 20
0.0018  SELECT dp.name, dp.last_name, dp.nick,dp.CountryCode,dp.alias,rp.team_id,dt.nameShow,dt.short_name,dt.basealias,rp.player_id,rp.teamId,dp.role FROM dataplayers AS dp INNER JOIN rel_players AS rp ON rp.player_id=dp.id AND rp.league_id IN (28477) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN () ORDER BY rp.in_squad = 1 DESC
0.0019  SELECT e.action, count(e.action) as total, e.player_id FROM events1966 e WHERE e.league_id IN (28477) AND (e.action IN (3,4) ) GROUP BY e.player_id ORDER BY total DESC, e.player_id ASC LIMIT 20
0.0019  SELECT dp.name, dp.last_name, dp.nick,dp.CountryCode,dp.alias,rp.team_id,dt.nameShow,dt.short_name,dt.basealias,rp.player_id,rp.teamId,dp.role FROM dataplayers AS dp INNER JOIN rel_players AS rp ON rp.player_id=dp.id AND rp.league_id IN (28477) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN () ORDER BY rp.in_squad = 1 DESC
0.0021  SELECT e.action, count(e.action) as total, e.player_id FROM events1966 e WHERE e.league_id IN (28477) AND (e.action IN (22) ) GROUP BY e.player_id ORDER BY total DESC, e.player_id ASC LIMIT 20
0.0019  SELECT dp.name, dp.last_name, dp.nick,dp.CountryCode,dp.alias,rp.team_id,dt.nameShow,dt.short_name,dt.basealias,rp.player_id,rp.teamId,dp.role FROM dataplayers AS dp INNER JOIN rel_players AS rp ON rp.player_id=dp.id AND rp.league_id IN (28477) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN () ORDER BY rp.in_squad = 1 DESC
0.0022  SELECT rp.lineup as total,p.name, p.last_name, p.nick,p.CountryCode,p.alias,rp.team_id,dt.nameShow,dt.short_name,dt.basealias,rp.player_id,rp.teamId,p.role FROM `rel_players` rp INNER JOIN dataplayers p ON p.id = rp.player_id INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 28477 AND rp.lineup > 0 ORDER BY rp.lineup DESC,p.pod DESC LIMIT 20
0.0018  SELECT rp.events as total,p.name, p.last_name, p.nick,p.CountryCode,p.alias,rp.team_id,dt.nameShow,dt.short_name,dt.basealias,rp.player_id,rp.teamId,p.role FROM `rel_players` rp INNER JOIN dataplayers p ON p.id = rp.player_id INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 28477 AND rp.events > 0 ORDER BY rp.events DESC,p.pod DESC LIMIT 20
0.0026  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=28477 AND rel.round=34
0.0020  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 = 28477 AND esl.points > 0 ORDER BY esl.points DESC LIMIT 3
0.0020  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 = 28477 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` = 28477 ORDER BY creation_date DESC LIMIT 0, 10
0.0025  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` = 28477
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 `calendars1966` 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` = 28477 AND c.`round` = 34 ORDER BY shedule ASC LIMIT 200
0.0017  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 `events1966` e INNER JOIN calendars1966 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 = 28477 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 `events1966` e INNER JOIN calendars1966 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 = 28477 AND e.real_date > NOW() - INTERVAL 1 MONTH ORDER BY e.real_date DESC LIMIT 30
0.0020  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 `tables1966` 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 = 28477 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 `tables1966` 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 = 28477 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0020  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 = 28477 ORDER BY c.shedule ASC, fcoef DESC LIMIT 5
0.0020  SELECT data1, data2 FROM services_tags WHERE categoryId=41
0.0020  SELECT l.year,l.group_code FROM leagues_besoccer l WHERE l.categoryId = 41 AND l.year = 1966 ORDER BY l.group_code ASC
0.0020  SELECT group_code, extraName from `leagues` WHERE categoryId=41 AND year=1966