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

First Stage

Table:

 1.Palestino		26 16  8  2  69-39  40  Championship Group
 2.Unión Española	26 11  8  7  42-36  30  Championship Group
 3.Everton		26 10  9  7  40-34  29  Championship Group
 4.Universidad de Chile	26 10  8  8  57-42  28  Championship Group
 5.Colo Colo		26 10  8  8  49-39  28  Championship Group
 6.Audax Italiano	26  8 12  6  54-54  28  Championship Group
 7.Green Cross		26  9  9  8  45-41  27  Championship Group
 8.Magallanes		26 10  7  9  46-47  27  Championship Group
 - - - - - - - - - - - - - - - - - - - - - - -
 9.O'Higgins		26  9  8  9  45-53  26  Relegation Group
10.Santiago Wanderers	26  7  9 10  40-48  23  Relegation Group
11.Rangers		26  5 12  9  36-45  22  Relegation Group
12.Ferrobádminton	26  4 11 11  46-59  19  Relegation Group
13.Santiago Morning	26  6  7 13  27-45  19  Relegation Group
14.Universidad Católica	26  7  4 15  38-52  18  Relegation Group

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

Table:

 1.Palestino		26 16  8  2  69-39  40  Championship Group
 2.Unión Española	26 11  8  7  42-36  30  Championship Group
 3.Everton		26 10  9  7  40-34  29  Championship Group
 4.Universidad de Chile	26 10  8  8  57-42  28  Championship Group
 5.Colo Colo		26 10  8  8  49-39  28  Championship Group
 6.Audax Italiano	26  8 12  6  54-54  28  Championship Group
 7.Green Cross		26  9  9  8  45-41  27  Championship Group
 8.Magallanes		26 10  7  9  46-47  27  Championship Group
 - - - - - - - - - - - - - - - - - - - - - - -
 9.O'Higgins		26  9  8  9  45-53  26  Relegation Group
10.Santiago Wanderers	26  7  9 10  40-48  23  Relegation Group
11.Rangers		26  5 12  9  36-45  22  Relegation Group
12.Ferrobádminton	26  4 11 11  46-59  19  Relegation Group
13.Santiago Morning	26  6  7 13  27-45  19  Relegation Group
14.Universidad Católica	26  7  4 15  38-52  18  Relegation Group

Second Stage

Championship Group

Table:

 1.Colo Colo		 7  4  1  2  23-16   9     
 2.Universidad de Chile	 7  4  1  2  19-17   9      
 3.Everton		 7  3  2  2  19-14   8     
 4.Green Cross		 7  3  2  2  13-12   8     
 5.Magallanes		 7  2  3  2  12-11   7     
 6.Palestino		 7  3  0  4  22-26   6        
 7.Audax Italiano	 7  1  3  3  12-16   5     
 8.Unión Española	 7  1  2  4   5-13   4  

Round 1
Green Cross		3-1 Colo Colo 
Audax Italiano 		4-2 Everton
Universidad de Chile	4-0 Unión Española
Palestino		3-4 Magallanes

Round 2
Magallanes		1-1 Audax Italiano
Universidad de Chile	3-0 Green Cross
Palestino		2-1 Unión Española
Everton			6-2 Colo Colo

Round 3
Unión Española		0-2 Magallanes
Universidad de Chile	1-5 Colo Colo
Audax Italiano		1-1 Green Cross
Palestino		3-2 Everton

Round 4
Magallanes		2-2 Colo Colo
Green Cross		5-3 Palestino
Universidad de Chile	2-1 Audax Italiano
Everton			1-1 Unión Española

Round 5
Colo Colo		3-1 Unión Española
Palestino		5-3 Audax Italiano
Green Cross		2-2 Everton
Magallanes		2-2 Universidad de Chile

Round 6
Unión Española		1-0 Green Cross
Palestino		4-5 Universidad de Chile
Colo Colo		4-1 Audax Italiano
Everton			1-0 Magallanes

Round 7
Palestino		2-6 Colo Colo
Audax Italiano		1-1 Unión Española
Universidad de Chile	2-5 Everton
Magallanes		1-2 Green Cross

Table:

 1.Colo Colo		 7  4  1  2  23-16   9     
 2.Universidad de Chile	 7  4  1  2  19-17   9      
 3.Everton		 7  3  2  2  19-14   8     
 4.Green Cross		 7  3  2  2  13-12   8     
 5.Magallanes		 7  2  3  2  12-11   7     
 6.Palestino		 7  3  0  4  22-26   6        
 7.Audax Italiano	 7  1  3  3  12-16   5     
 8.Unión Española	 7  1  2  4   5-13   4  

Aggregate Final Table:

 1.PALESTINO		33 19  8  6  91-65  46  Champions        
 2.Colo Colo		33 14  9 10  72-55  37        
 3.Universidad de Chile	33 14  9 10  76-59  37       
 4.Everton		33 13 11  9  59-48  37  (Viña del Mar)  
 5.Green Cross		33 12 11 10  58-53  35   
 6.Magallanes		33 12 10 11  58-58  34    
 7.Unión Española	33 12 10 11  47-49  34       
 8.Audax Italiano	33  9 15  9  66-70  33       

Relegation Group

Table:
 
 1.Santiago Morning	 5  3  1  1  10- 8   7    
 2.O'Higgins		 5  3  1  1  12-11   7      
 3.Rangers		 5  2  1  2   8- 7   5     
 4.Santiago Wanderers	 5  1  2  2   8- 8   4   
 5.Ferrobádminton	 5  1  2  2   7-10   4   
 6.Universidad Católica	 5  1  1  3  11-12   3   

Round 1
O'Higgins		3-2 Universidad Católica
Santiago Wanderers 	1-1 Santiago Morning
Ferrobádminton		2-0 Rangers

Round 2
Santiago Morning	3-1 Rangers
Universidad Católica	4-1 Santiago Wanderers
Ferrobádminton		1-1 O'Higgins

Round 3
Santiago Morning	3-1 Universidad Católica
Rangers			5-1 O'Higgins
Santiago Wanderers	4-0 Ferrobádminton

Round 4
O'Higgins		2-1 Santiago Wanderers
Rangers			1-0 Universidad Católica
Santiago Morning	1-0 Ferrobádminton

Round 5
Ferrobádminton		4-4 Universidad Católica
Santiago Wanderers	1-1 Rangers
O'Higgins		5-2 Santiago Morning

Table:
 
 1.Santiago Morning	 5  3  1  1  10- 8   7    
 2.O'Higgins		 5  3  1  1  12-11   7      
 3.Rangers		 5  2  1  2   8- 7   5     
 4.Santiago Wanderers	 5  1  2  2   8- 8   4   
 5.Ferrobádminton	 5  1  2  2   7-10   4   
 6.Universidad Católica	 5  1  1  3  11-12   3   

Aggregate Final Table:

 9.O'Higgins		31 12  9 10  57-64  33  (Rancagua)   
10.Santiago Wanderers	31  8 11 12  48-56  27     
11.Rangers		31  7 13 11  44-52  27  (Talca)
12.Santiago Morning	31  9  8 14  37-53  26  (Valparaíso)      
13.Ferrobádminton	31  5 13 13  53-69  23   
----------------------------------------------
14.Universidad Católica	31  8  5 18  49-64  21  Relegated       

Promoted : San Luis (Quillota)


Author: Eduardo Espina
(ecem54 at chile.com)
Last updated: 31 Jul 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,314,576 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0030
Controller Execution Time ( Home / Category )  0.1191
Total Execution Time  0.1221
  CADENA URL  
/apertura_chile1955/grupo1
  GET DATOS  
$_GET['/apertura_chile1955/grupo1']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (34)  
0.0018  SELECT type FROM routes WHERE alias = 'apertura_chile1955'
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 = 1955 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=1 DESC LIMIT 1
0.0021  SELECT text_es as historical_text FROM leagues_text WHERE id=159
0.0022  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 = 28459 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0023  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='1955' 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 20:41:52' 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 20:41:52' 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 20:41:52' 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 20:41:52' 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 = 1955 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=0 DESC LIMIT 1
0.0019  SELECT e.action, count(e.action) as total, e.player_id FROM events1955 e WHERE e.league_id IN (28459) 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.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 (28459) 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 events1955 e WHERE e.league_id IN (28459) AND (e.action IN (4,5) ) 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 (28459) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN () ORDER BY rp.in_squad = 1 DESC
0.0020  SELECT e.action, count(e.action) as total, e.player_id FROM events1955 e WHERE e.league_id IN (28459) AND (e.action IN (3,4) ) GROUP BY e.player_id ORDER BY total DESC, e.player_id ASC LIMIT 20
0.0026  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 (28459) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN () ORDER BY rp.in_squad = 1 DESC
0.0020  SELECT e.action, count(e.action) as total, e.player_id FROM events1955 e WHERE e.league_id IN (28459) 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 (28459) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN () ORDER BY rp.in_squad = 1 DESC
0.0020  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 = 28459 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 = 28459 AND rp.events > 0 ORDER BY rp.events DESC,p.pod DESC LIMIT 20
0.0024  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=28459 AND rel.round=26
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 = 28459 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 = 28459 AND esl.points > 0
0.0170  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` = 28459 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` = 28459
0.0019  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 `calendars1955` 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` = 28459 AND c.`round` = 26 ORDER BY shedule ASC LIMIT 200
0.0018  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 `events1955` e INNER JOIN calendars1955 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 = 26 AND e.real_date IS NOT NULL AND e.league_id = 28459 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 `events1955` e INNER JOIN calendars1955 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 = 28459 AND e.real_date > NOW() - INTERVAL 1 MONTH ORDER BY e.real_date DESC LIMIT 30
0.0021  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 `tables1955` 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 = 28459 AND t.round = 24 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0021  SELECT *,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables1955` 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 = 28459 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0021  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 = 28459 ORDER BY c.shedule ASC, fcoef DESC LIMIT 5
0.0021  SELECT data1, data2 FROM services_tags WHERE categoryId=41
0.0021  SELECT l.year,l.group_code FROM leagues_besoccer l WHERE l.categoryId = 41 AND l.year = 1955 ORDER BY l.group_code ASC
0.0021  SELECT group_code, extraName from `leagues` WHERE categoryId=41 AND year=1955