4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Información Histórica 
						
Campeonato Oficial

First Stage

Table:

 1.Magallanes		24 11  9  4  60-41  31  Championship Group
 2.Audax Italiano	24 13  4  7  59-46  30  Championship Group
 3.Universidad de Chile	24 11  7  6  55-40  29  Championship Group
 4.Colo Colo		24  9 11  4  50-38  29  Championship Group
 5.Green Cross		24 11  5  8  61-59  27  Championship Group
 6.Santiago Wanderers	24 10  6  8  47-42  26  Championship Group
 - - - - - - - - - - - - - - - - - - - - - - -
 7.Universidad Católica	24  9  6  9  37-39  24  Relegation Group
 8.Unión Española	24  8  7  9  45-43  23  Relegation Group
 9.Santiago Morning	24  8  6 10  50-52  22  Relegation Group
10.Everton		24  8  5 11  41-46  21  Relegation Group
11.Badminton		24  6  9  9  52-63  21  Relegation Group
12.Iberia		24  5  5 14  38-54  15  Relegation Group
13.Santiago National	24  4  6 14  47-79  14  Relegation Group

Round 1
Audax Italiano		2-4 Santiago National
Badminton		5-2 Green Cross	 
Magallanes		3-4 Universidad de Chile
Universidad Católica	3-4 Santiago Morning
Unión Española		1-1 Colo Colo
Iberia			1-2 Santiago Wanderers
Everton			bye

Round 2
Universidad de Chile	5-3 Santiago National
Badminton		0-0 Colo Colo
Green Cross		6-2 Iberia		
Audax Italiano		3-2 Santiago Morning
Universidad Católica	1-1 Unión Española
Magallanes		2-0 Everton
Santiago Wanderers	bye

Round 3
Unión Española		2-3 Santiago Morning		 
Colo Colo		3-1 Universidad Católica	
Audax Italiano		3-2 Universidad de Chile
Santiago National	1-2 Everton
Magallanes		1-1 Badminton
Green Cross		2-2 Santiago Wanderers
Iberia			bye

Round 4
Magallanes		6-4 Santiago National	
Santiago Morning	4-4 Santiago Wanderers
Audax Italiano		2-1 Universidad Católica
Badminton		8-5 Iberia
Colo Colo		2-2 Universidad de Chile
Everton			0-0 Unión Española
Green Cross		bye

Round 5
Unión Española		1-1 Green Cross
Colo Colo		4-0 Iberia
Audax Italiano		1-1 Santiago Wanderers
Magallanes		3-2 Universidad Católica
Universidad de Chile	1-0 Santiago Morning	
Badminton		4-2 Everton
Santiago National	bye

Round 6
Unión Española		2-1 Iberia
Colo Colo		1-1 Green Cross
Santiago National	3-2 Santiago Wanderers
Magallanes		1-0 Santiago Morning 
Universidad de Chile	1-3 Everton
Badminton		1-1 Universidad Católica
Audax Italiano		bye

Round 7
Unión Española		2-1 Universidad de Chile
Colo Colo	   	1-5 Santiago Morning		 
Audax Italiano		3-1 Green Cross
Badminton		0-1 Santiago Wanderers
Everton			1-4 Universidad Católica
Santiago National	0-0 Iberia	
Magallanes		bye

Round 8
Unión Española		1-3 Audax Italiano
Colo Colo		0-2 Everton
Santiago National	1-4 Green Cross
Magallanes		0-1 Santiago Wanderers
Badminton		0-2 Santiago Morning	
Iberia			6-1 Universidad Católica
Universidad de Chile	bye

Round 9
Audax Italiano		3-1 Badminton		 
Everton			2-2 Santiago Morning
Universidad de Chile	2-1 Green Cross
Unión Española		2-2 Santiago National
Santiago Wanderers	3-0 Universidad Católica
Magallanes		0-0 Iberia
Colo Colo		bye

Round 10
Unión Española		2-3 Magallanes
Colo Colo		3-3 Audax Italiano	 
Santiago National	0-1 Universidad Católica
Universidad de Chile	3-1 Santiago Wanderers
Green Cross		2-4 Everton	
Santiago Morning	0-1 Iberia
Badminton		bye

Round 11
Colo Colo		3-3 Magallanes
Audax Italiano		4-2 Iberia
Santiago National	2-2 Badminton
Green Cross		3-3 Santiago Morning
Santiago Wanderers	2-0 Everton
Universidad de Chile	2-2 Universidad Católica
Unión Española		bye

Round 12
Colo Colo		3-1 Santiago Wanderers	
Magallanes		6-2 Green Cross		 
Everton			1-0 Audax Italiano	
Universidad de Chile	1-0 Iberia
Unión Española		3-1 Badminton
Santiago Morning	3-2 Santiago National
Universidad Católica	bye

Round 13
Unión Española		0-2 Santiago Wanderers
Colo Colo		2-2 Santiago National	
Audax Italiano		2-4 Magallanes		 
Universidad de Chile	6-1 Badminton	
Green Cross		0-3 Universidad Católica
Iberia			3-1 Everton
Santiago Morning	bye

Round 14
Santiago National	2-5 Audax Italiano
Green Cross		1-5 Badminton
Universidad de Chile	2-1 Magallanes	
Santiago Morning	0-2 Universidad Católica
Colo Colo		4-1 Unión Española
Santiago Wanderers	1-4 Iberia
Everton			bye

Round 15
Santiago National	1-5 Universidad de Chile
Colo Colo		2-1 Badminton
Iberia			2-3 Green Cross
Santiago Morning	2-3 Audax Italiano	
Unión Española		3-0 Universidad Católica
Everton			1-1 Magallanes
Santiago Wanderers	bye

Round 16
Santiago Morning	1-4 Unión Española	
Universidad Católica	2-2 Colo Colo		 
Universidad de Chile	1-1 Audax Italiano
Everton			3-3 Santiago National	
Badminton		3-3 Magallanes
Santiago Wanderers	3-4 Green Cross
Iberia			bye

Round 17
Santiago National	1-5 Magallanes
Santiago Wanderers	2-1 Santiago Morning	
Universidad Católica	4-1 Audax Italiano		 
Iberia			1-4 Badminton
Universidad de Chile	0-2 Colo Colo
Unión Española		1-1 Everton
Green Cross		bye

Round 18
Green Cross		2-0 Unión Española
Iberia			1-3 Colo Colo
Santiago Wanderers	2-1 Audax Italiano	
Universidad Católica	2-2 Magallanes
Santiago Morning	2-2 Universidad de Chile
Everton			7-0 Badminton
Santiago National	bye

Round 19
Iberia			0-2 Unión Española
Green Cross		2-2 Colo Colo
Santiago Wanderers	6-2 Santiago National
Santiago Morning	1-1 Magallanes	
Everton			1-3 Universidad de Chile
Universidad Católica	1-1 Badminton
Audax Italiano		bye

Round 20
Universidad de Chile	2-4 Unión Española	
Santiago Morning	1-0 Colo Colo		 
Green Cross		3-1 Audax Italiano
Santiago Wanderers	5-2 Badminton	
Universidad Católica	2-1 Everton
Iberia			2-2 Santiago National
Magallanes		bye

Round 21
Audax Italiano		3-2 Unión Española
Everton			1-2 Colo Colo	
Green Cross		6-1 Santiago National		 
Santiago Wanderers	1-1 Magallanes
Santiago Morning	3-3 Badminton
Universidad Católica	1-0 Iberia
Universidad de Chile	bye

Round 22
Badminton		1-6 Audax Italiano
Santiago Morning	3-2 Everton
Green Cross		3-7 Universidad de Chile	
Santiago National	3-2 Unión Española
Universidad Católica	1-0 Santiago Wanderers
Iberia			0-2 Magallanes
Colo Colo		bye

Round 23
Magallanes		3-1 Unión Española
Audax Italiano		2-0 Colo Colo
Universidad Católica	0-1 Santiago National
Santiago Wanderers	1-1 Universidad de Chile	
Everton			1-5 Green Cross
Iberia			4-2 Santiago Morning
Badminton		bye

Round 24
Magallanes		4-4 Colo Colo	
Iberia			2-2 Audax Italiano		 
Badminton		4-2 Santiago National
Santiago Morning	1-2 Green Cross	
Everton			2-1 Santiago Wanderers
Universidad Católica	1-0 Universidad de Chile
Unión Española		bye

Round 25
Santiago Wanderers	1-1 Colo Colo
Green Cross		3-2 Magallanes	
Audax Italiano		4-1 Everton		 
Iberia			1-1 Universidad de Chile
Badminton		3-3 Unión Española
Santiago National	4-3 Santiago Morning
Universidad Católica	bye

Round 26
Santiago Wanderers	2-5 Unión Española
Santiago National	1-5 Colo Colo
Magallanes		3-1 Audax Italiano	
Badminton		1-1 Universidad de Chile
Universidad Católica	1-2 Green Cross
Everton			2-0 Iberia
Santiago Morning	bye

Table:

 1.Magallanes		24 11  9  4  60-41  31  Championship Group
 2.Audax Italiano	24 13  4  7  59-46  30  Championship Group
 3.Universidad de Chile	24 11  7  6  55-40  29  Championship Group
 4.Colo Colo		24  9 11  4  50-38  29  Championship Group
 5.Green Cross		24 11  5  8  61-59  27  Championship Group
 6.Santiago Wanderers	24 10  6  8  47-42  26  Championship Group
 - - - - - - - - - - - - - - - - - - - - - - -
 7.Universidad Católica	24  9  6  9  37-39  24  Relegation Group
 8.Unión Española	24  8  7  9  45-43  23  Relegation Group
 9.Santiago Morning	24  8  6 10  50-52  22  Relegation Group
10.Everton		24  8  5 11  41-46  21  Relegation Group
11.Badminton		24  6  9  9  52-63  21  Relegation Group
12.Iberia		24  5  5 14  38-54  15  Relegation Group
13.Santiago National	24  4  6 14  47-79  14  Relegation Group


Second Stage

Championship Group

Table:

 1.Audax Italiano	 5  3  2  0   7- 4   8 
 2.Santiago Wanderers	 5  2  2  1   6- 6   6
 3.Green Cross		 5  2  1  2  12-10   5 
 4.Magallanes		 5  2  1  2   9- 8   5
 5.Universidad de Chile	 5  0  5  0   7- 7   5
 6.Colo Colo		 5  0  1  4   3- 9   1

Round 1
Audax Italiano		0-0 Universidad de Chile
Colo Colo		0-1 Santiago Wanderers
Green Cross		3-4 Magallanes

Round 2
Audax Italiano		1-1 Santiago Wanderers
Universidad de Chile	2-2 Magallanes
Colo Colo		0-2 Green Cross

Round 3
Audax Italiano		1-0 Magallanes
Santiago Wanderers	1-3 Green Cross
Universidad de Chile	2-2 Colo Colo

Round 4
Audax Italiano		3-2 Green Cross
Magallanes		2-0 Colo Colo
Santiago Wanderers	1-1 Universidad de Chile

Round 5
Audax Italiano		2-1 Colo Colo
Green Cross		2-2 Universidad de Chile
Magallanes		1-2 Santiago Wanderers

Table:

 1.Audax Italiano	 5  3  2  0   7- 4   8 
 2.Santiago Wanderers	 5  2  2  1   6- 6   6
 3.Green Cross		 5  2  1  2  12-10   5 
 4.Magallanes		 5  2  1  2   9- 8   5
 5.Universidad de Chile	 5  0  5  0   7- 7   5
 6.Colo Colo		 5  0  1  4   3- 9   1

Aggregate Final Table:

 1.AUDAX ITALIANO	29 16  6  7  66-50  38  Champions
 2.Magallanes		29 13 10  6  69-49  36
 3.Universidad de Chile	29 11 12  6  62-47  34
 4.Santiago Wanderers	29 12  8  9  53-48  32  (Valparaíso)
 5.Green Cross		29 13  6 10  73-69  32
 6.Colo Colo		29  9 12  8  53-47  30

Relegation Group

Table:

 1.Unión Española	 6  5  1  0  20- 9  11
 2.Badminton		 6  3  3  0  15-10   9
 3.Everton		 6  3  2  1  15-12   8  
 4.Iberia		 6  2  2  2  13-10   6
 5.Santiago National	 6  2  0  4  12-19   4
 6.Santiago Morning	 6  0  2  4  10-17   2
 7.Universidad Católica	 6  1  0  5   9-17   2

Round 1
Badminton 		2-1 Universidad Católica
Everton 		2-4 Unión Española
Iberia 			4-1 Santiago National
Santiago Morning 	bye

Round 2
Universidad Católica	1-3 Unión Española
Badminton		3-1 Santiago National
Everton			2-2 Santiago Morning
Iberia			bye

Round 3
Unión Española		4-1 Santiago National
Universidad Católica	3-2 Santiago Morning
Badminton		3-3 Iberia
Everton			bye

Round 4
Santiago National	4-3 Santiago Morning
Unión Española		2-1 Iberia
Universidad Católica	1-3 Everton
Badminton		bye

Round 5
Santiago Morning	0-0 Iberia
Santiago National	1-3 Everton
Unión Española		2-2 Badminton
Universidad Católica	bye

Round 6
Iberia			2-3 Everton
Santiago Morning	1-3 Badminton
Santiago National	4-2 Universidad Católica
Unión Española		bye

Round 7
Everton			2-2 Badminton
Iberia			3-1 Universidad Católica
Santiago Morning	2-5 Unión Española
Santiago National	bye

Table:

 1.Unión Española	 6  5  1  0  20- 9  11
 2.Badminton		 6  3  3  0  15-10   9
 3.Everton		 6  3  2  1  15-12   8  
 4.Iberia		 6  2  2  2  13-10   6
 5.Santiago National	 6  2  0  4  12-19   4
 6.Santiago Morning	 6  0  2  4  10-17   2
 7.Universidad Católica	 6  1  0  5   9-17   2

Aggregate Final Table:

 7.Unión Española	30 13  8  9  65-52  34
 8.Badminton		30  9 12  9  67-73  30  
 9.Everton		30 11  7 12  56-58  29  (Viña del Mar)
10.Universidad Católica	30 10  6 14  46-56  26
11.Santiago Morning	30  8  8 14  60-69  24
12.Iberia		30  7  7 16  51-64  21
----------------------------------------------
13.Santiago National	30  6  6 18  59-98  18  [*]

[*] Santiago National were not relegated, apparently due to a rule 
    (the existence of which is unconfirmed) indicating that none of
    the teams that played in the first championship (1933) could be 
    relegated




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,347,032 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0038
Controller Execution Time ( Home / Category )  0.5372
Total Execution Time  0.5410
  CADENA URL  
/apertura_chile1946/grupo1
  GET DATOS  
$_GET['/apertura_chile1946/grupo1']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (34)  
0.0124  SELECT type FROM routes WHERE alias = 'apertura_chile1946'
0.0254  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 = 1946 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=1 DESC LIMIT 1
0.0126  SELECT text_es as historical_text FROM leagues_text WHERE id=150
0.0128  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 = 28445 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0129  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='1946' WHERE c.parentId=41 GROUP BY c.id ORDER BY c.order_id ASC
0.0125  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-04-27 19:14:33' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0130  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=2 AND last_update > '2024-04-27 19:14:33' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0125  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=4 AND last_update > '2024-04-27 19:14:33' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0125  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=3 AND last_update > '2024-04-27 19:14:33' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0131  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 = 1946 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=0 DESC LIMIT 1
0.0125  SELECT e.action, count(e.action) as total, e.player_id FROM events1946 e WHERE e.league_id IN (28445) 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.0125  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 (28445) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN () ORDER BY rp.in_squad = 1 DESC
0.0126  SELECT e.action, count(e.action) as total, e.player_id FROM events1946 e WHERE e.league_id IN (28445) AND (e.action IN (4,5) ) GROUP BY e.player_id ORDER BY total DESC, e.player_id ASC LIMIT 20
0.0126  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 (28445) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN () ORDER BY rp.in_squad = 1 DESC
0.0126  SELECT e.action, count(e.action) as total, e.player_id FROM events1946 e WHERE e.league_id IN (28445) AND (e.action IN (3,4) ) GROUP BY e.player_id ORDER BY total DESC, e.player_id ASC LIMIT 20
0.0129  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 (28445) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN () ORDER BY rp.in_squad = 1 DESC
0.0129  SELECT e.action, count(e.action) as total, e.player_id FROM events1946 e WHERE e.league_id IN (28445) AND (e.action IN (22) ) GROUP BY e.player_id ORDER BY total DESC, e.player_id ASC LIMIT 20
0.0126  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 (28445) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN () ORDER BY rp.in_squad = 1 DESC
0.0125  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 = 28445 AND rp.lineup > 0 ORDER BY rp.lineup DESC,p.pod DESC LIMIT 20
0.0125  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 = 28445 AND rp.events > 0 ORDER BY rp.events DESC,p.pod DESC LIMIT 20
0.0128  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=28445 AND rel.round=24
0.0127  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 = 28445 AND esl.points > 0 ORDER BY esl.points DESC LIMIT 3
0.0127  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 = 28445 AND esl.points > 0
0.0128  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` = 28445 ORDER BY creation_date DESC LIMIT 0, 10
0.0133  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` = 28445
0.0127  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 `calendars1946` 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` = 28445 AND c.`round` = 24 ORDER BY shedule ASC LIMIT 200
0.0124  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 `events1946` e INNER JOIN calendars1946 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 = 24 AND e.real_date IS NOT NULL AND e.league_id = 28445 ORDER BY total DESC LIMIT 40
0.0128  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 `events1946` e INNER JOIN calendars1946 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 = 28445 AND e.real_date > NOW() - INTERVAL 1 MONTH ORDER BY e.real_date DESC LIMIT 30
0.0127  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 `tables1946` 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 = 28445 AND t.round = 22 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0127  SELECT *,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables1946` 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 = 28445 AND t.round = 24 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0127  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 = 28445 ORDER BY c.shedule ASC, fcoef DESC LIMIT 5
0.0127  SELECT data1, data2 FROM services_tags WHERE categoryId=41
0.0127  SELECT l.year,l.group_code FROM leagues_besoccer l WHERE l.categoryId = 41 AND l.year = 1946 ORDER BY l.group_code ASC
0.0127  SELECT group_code, extraName from `leagues` WHERE categoryId=41 AND year=1946