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

Decentralised Tournament (Official)
===================================

Round 1 
[Sep 20]
Centro Iqueño		2-3	Porvenir Miraflores	
Universitario		2-2	Dep. Municipal	
[Sep 21]
Carlos A. Manucci	1-0	Octavio Espinosa	
Atletico Grau		2-1	Juan Aurich	
Alianza Lima		2-0	KDT Nacional
[Sep 22]	
Defensor Arica		1-1	Sport Boys	
Defensor Lima		3-2	Sporting Cristal	
	
Round 2 
[Sep 27]
Centro Iqueño		1-0	Atletico Grau	
Defensor Arica		3-1	Carlos A. Manucci	
[Sep 28]
Octavio Espinosa	0-1	Dep. Municipal	
Juan Aurich		3-1	Porvenir Miraflores	
Sporting Cristal	0-3	Sport Boys	
Defensor Lima		1-0	KDT Nacional	
Alianza Lima		2-2	Universitario	

Round 3 
[Oct 4]
Universitario		4-1	Octavio Espinosa	
Defensor Arica		4-0	Centro Iqueño	
[Oct 5]
Carlos A. Manucci	2-0	Sport Boys	
Defensor Lima		1-1	Dep. Municipal	
Porvenir Miraflores	3-0	KDT Nacional	
Atletico Grau		0-0	Sporting Cristal	
Alianza Lima		1-1	Juan Aurich	

Round 4 
[Oct 9]
KDT Nacional		3-2	Carlos A. Manucci	
Porvenir Miraflores	1-3	Dep. Municipal	
Sporting Cristal	2-3	Universitario	
[Oct 12]
Sport Boys		2-3	Alianza Lima	
Octavio Espinosa	2-2	Centro Iqueño	
Juan Aurich		0-0	Defensor Arica	
Defensor Lima		1-1	Atletico Grau	

Round 6 
[Oct 17]
Alianza Lima		0-0	Carlos A. Manucci	
Universitario		2-1	Atletico Grau	
[Oct 19]
Juan Aurich		4-3	KDT Nacional	
Octavio Espinosa	2-0	Defensor Lima	
Defensor Arica		2-0	Porvenir Miraflores	
Sporting Cristal	1-1	Centro Iqueño	
Sport Boys		3-3	Dep. Municipal	

Round 7 
[Oct 24]
KDT Nacional		1-1	Sporting Cristal	
Centro Iqueño		1-1	Universitario	
[Oct 26]
Sport Boys		2-1	Porvenir Miraflores	
Defensor Lima		1-1	Defensor Arica	
Alianza Lima		1-1	Dep. Municipal	
Octavio Espinosa	1-1	Juan Aurich	
Atletico Grau		1-0	Carlos A. Manucci	

Round 8 
[Oct 31]
Atletico Grau		0-1	Defensor Arica	
[Nov 1]
Carlos A. Manucci	2-0    Centro Iqueño
KDT Nacional		0-1    Sport Boys
Dep. Municipal		1-0	Juan Aurich
[Nov 2]
Sporting Cristal	1-0	Alianza Lima			
Porvenir Miraflores	1-1	Octavio Espinosa		
Defensor Lima		2-5	Universitario	

Round 9 
[Nov 7]
KDT Nacional		0-2	Defensor Arica	
Sport Boys		2-1	Atletico Grau	
[Nov 9]
Defensor Lima		4-5	Porvenir Miraflores	
Centro Iqueño		1-4	Dep. Municipal	
Octavio Espinosa	1-1	Alianza Lima	
Sporting Cristal	1-0	Carlos A. Manucci	
Juan Aurich		3-0	Universitario	

Round 10 
[Nov 14]
Sporting Cristal	0-0	Defensor Arica	
[Nov 15]
KDT Nacional		1-5	Dep. Municipal	
Porvenir Miraflores	2-1	Universitario	
[Nov 16]
Alianza Lima		1-1	Centro Iqueño	
Juan Aurich		0-1	Carlos A. Manucci	
Octavio Espinosa	0-0	Atletico Grau	
Sport Boys		0-0	Defensor Lima	

Round 5 
[Nov 19]
Atletico Grau		3-2	Dep. Municipal	
Carlos A. Manucci	0-0	Porvenir Miraflores	
Centro Iqueño		1-0	KDT Nacional	
Defensor Arica		0-1	Universitario	
Sporting Cristal	0-0	Octavio Espinosa	
[Nov 20]
Defensor Lima		0-0	Alianza Lima	
Sport Boys		0-2	Juan Aurich	

Round 11 
[Nov 22]
Defensor Arica          1-1     Octavio Espinosa		
Sporting Cristal	0-2	Dep. Municipal	
[Nov 23]
Atletico Grau		2-0	KDT Nacional	
Carlos A. Manucci	0-0	Defensor Lima	
Centro Iqueño		1-2	Juan Aurich	
Universitario           3-0     Sport Boys				
[Nov 24]
Porvenir Miraflores	1-6	Alianza Lima	

Round 12 
[Nov 28]
KDT Nacional		0-2	Universitario	
Dep. Municipal		3-2	Carlos A. Manucci	
[Nov 29]
Porvenir Miraflores	0-2	Atletico Grau	
[Nov 30]
Centro Iqueño		0-2	Defensor Lima	
Octavio Espinosa	2-1	Sport Boys	
Defensor Arica		2-1	Alianza Lima	
Juan Aurich		1-3	Sporting Cristal	

Round 13 
[Dec 5]
KDT Nacional		0-2	Octavio Espinosa	
Defensor Lima		2-2	Juan Aurich	
[Dec 6]
Carlos A. Manucci	1-1	Universitario	
[Dec 7]
Sport Boys		2-1     Centro Iqueño	
Dep. Municipal		2-1	Defensor Arica	
[Dec 8]
Sporting Cristal	2-3	Porvenir Miraflores	
Atletico Grau		1-3	Alianza Lima	

Table One Round Tournament:
                                     P -  W -  D -  L - GF - GA - PTS
 1. Deportivo Municipal             13 -  8 -  4 -  1 - 30 - 16 -  20
 2. Universitario de Deportes       13 -  7 -  4 -  2 - 27 - 17 -  18  
 3. Defensor Arica                  13 -  6 -  5 -  2 - 18 -  8 -  17 
 4. Alianza Lima                    13 -  4 -  7 -  2 - 21 - 13 -  15
 5. Juan Aurich (Chiclayo)          13 -  5 -  4 -  4 - 20 - 16 -  14
 6. Atlético Grau (Piura)           13 -  5 -  3 -  5 - 14 - 13 -  13
 7. Octavio Espinosa (Ica)          13 -  3 -  7 -  3 - 13 - 13 -  13  
 8. Sport Boys (Callao)             13 -  5 -  3 -  5 - 17 - 19 -  13
 9. Defensor Lima                   13 -  3 -  7 -  3 - 17 - 19 -  13
10. Carlos Mannucci (Trujillo)      13 -  4 -  4 -  5 - 12 - 12 -  12 
11. Porvenir Miraflores             13 -  5 -  2 -  6 - 21 - 28 -  12 
12. Sporting Cristal                13 -  3 -  5 -  5 - 13 - 17 -  11
13. Centro Iqueño                   13 -  2 -  4 -  7 - 12 - 24 -   8  
14. KDT Nacional (Callao)           13 -  1 -  1 - 11 -  8 – 28 -   3

Round 1 (Liguilla Final) 
[Dec 12]
Defensor Arica		1-2	Universitario	
[Dec 13]
Alianza Lima		3-0	Atletico Grau	
[Dec 14]
Juan Aurich		2-0	Dep. Municipal	

Round 2 (Liguilla Final) 
[Dec 17]
Atletico Grau		2-2	Juan Aurich
Alianza Lima		2-2	Universitario	
[Dec 18]
Dep. Municipal		2-2	Defensor Arica	

Round 3 (Liguilla Final) 
[Dec 20]
Alianza Lima		1-1	Defensor Arica	
[Dec 21]
Universitario		1-1	Juan Aurich	
[Dec 22]
Dep. Municipal		2-2	Atletico Grau	

Round 4 (Liguilla Final) 
[Dec 26]
Defensor Arica		3-1	Atletico Grau	
[Dec 27]
Alianza Lima		0-1	Juan Aurich	
[Dec 28]
Universitario		2-1	Dep. Municipal	

Round 5 (Liguilla Final) 
[Jan 2]
Alianza Lima		4-3	Dep. Municipal	
[Jan 3]
Universitario		1-1	Atletico Grau	
[Jan 4]
Juan Aurich		1-1	Defensor Arica	



Round 1 (Liguilla No Descenso) 
[Dec 12]
KDT Nacional		2-3     Porvenir Miraflores
[Dec 13]
Carlos A. Manucci	3-5 	Defensor Lima			
[Dec 14]
Sport Boys		1-1	Sporting Cristal	
Octavio Espinosa	0-0	Centro Iqueño

Round 2 (Liguilla No Descenso) 
[Dec 18]
Porvenir Miraflores	2-2	Carlos A. Manucci	
[Dec 20]
KDT Nacional		1-1	Centro Iqueño	
[Dec 21]
Octavio Espinosa	4-2	Sport Boys	
Sporting Cristal	3-0	Defensor Lima	

Round 3 (Liguilla No Descenso) 
[Dec 26]
Defensor Lima		1-0	Sport Boys	
[Dec 27]
Centro Iqueño		2-0	Porvenir Miraflores	
[Dec 28]
Carlos A. Manucci	1-0	Sporting Cristal	
Octavio Espinosa	0-0	KDT Nacional	

Round 4 (Liguilla No Descenso) 
[Jan 2]
Sporting Cristal	3-0	KDT Nacional	
[Jan 3]
Porvenir Miraflores	4-1	Octavio Espinosa	
[Jan 4]
Centro Iqueño		3-5	Defensor Lima	
Sport Boys		3-1	Carlos A. Manucci	

Round 5 (Liguilla No Descenso) 
[Jan 10]
Porvenir Miraflores	1-3	Defensor Lima	
[Jan 11]
KDT Nacional		1-2	Sport Boys	
Octavio Espinosa	1-2	Sporting Cristal	
Carlos A. Manucci	1-0	Centro Iqueño	

Round 6 (Liguilla No Descenso) 
[Jan 17]
Defensor Lima		0-3	Octavio Espinosa	
Porvenir Miraflores	2-6	Sporting Cristal	
[Jan 21]
Carlos A. Manucci	0-0	KDT Nacional	
Centro Iqueño		1-2	Sport Boys	

Round 7 (Liguilla No Descenso) 
[Jan 27]
KDT Nacional		0-3	Defensor Lima	
Sporting Cristal	0-0	Centro Iqueño	
[Jan 30]
Octavio Espinosa	1-4	Carlos A. Manucci	
Porvenir Miraflores	2-3	Sport Boys	


Final Table (Liguilla Final) (accumulated points)
                                     P -  W -  D -  L - GF - GA - PTS
 1. Universitario de Deportes       18 -  9 -  7 -  2 - 35 - 23 -  25  [1969 Champion, To Copa Libertadores]
 2. Defensor Arica                  18 -  7 -  8 -  3 - 26 - 15 -  22  [To Copa Libertadores]
 3. Deportivo Municipal             18 -  8 -  6 -  4 - 38 - 28 -  22
 4. Alianza Lima                    18 -  6 -  9 -  3 - 31 - 20 -  21
 5. Juan Aurich (Chiclayo)          18 -  7 -  7 -  4 - 27 - 20 -  21
 6. Atlético Grau (Piura)           18 -  5 -  6 -  7 - 20 - 24 -  16

Second place playoff [Jan 6, 1970] 
Defensor Arica		2-1   Deportivo Municipal

Final Table (No descenso) (accumulated points)
                                     P -  W -  D -  L - GF - GA - PTS
 7. Defensor Lima                   20 -  8 -  7 -  5 - 34 - 32 -  23
 8. Sport Boys (Callao)             20 -  9 -  4 -  7 - 30 - 30 -  22
 9. Sporting Cristal                20 -  7 -  7 -  6 - 28 - 22 -  21
10. Carlos Mannucci (Trujillo)      20 -  7 -  6 -  7 - 24 - 23 -  20
11. Octavio Espinosa (Ica)          20 -  5 -  9 -  6 - 23 - 25 -  19  
12. Porvenir Miraflores             20 -  7 -  3 - 10 - 35 - 47 -  17  
13. Centro Iqueño                   20 -  3 -  7 - 10 - 19 - 33 -  13  [Relegated]
14. KDT Nacional (Callao)           20 -  1 -  4 - 15 - 12 - 40 -   6  [Relegated]

Topscorer: Jaime Mosquera (Deportivo Municipal), 15 goals.

Promoted: Deportivo SIMA, Atlético Torino

Notes:
1. After a one round tournament (13 matches) teams were split in 2 
   groups: top 6 played for the title and bottom 8 played for the 
   relegation. Teams carried their regular season records and played 
   an additional round (5 and 7 further matches respectively)
2. A playoff match for 2nd place (qualifing for the Copa Libertadores)
   was necessary.
3. Liguilla Final and Liguilla No Descenso played only in Lima.



Author: Cesar Silva
(csilpe@hotmail.com)

Last updated: 7 Feb 2007

(C) Copyright Cesar Silva and RSSSF 2006/07


  USO DE MEMORIA  
4,323,872 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0018
Controller Execution Time ( Home / Category )  0.4891
Total Execution Time  0.4909
  CADENA URL  
/apertura_peru1969
  GET DATOS  
$_GET['/apertura_peru1969']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (37)  
0.0108  SELECT type FROM routes WHERE alias = 'apertura_peru1969'
0.0223  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'apertura_peru' AND (l.group_code = 1 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 1969 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=1 DESC LIMIT 1
0.0105  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=45 AND type_rel = 3
0.0115  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 3 AND rel.typeId = 45 AND rel.ln = 'es' AND rel.status=1 ORDER BY rel.creation_date desc,rel.cover_points DESC LIMIT 5
0.0108  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 (1308316,1302164,1264407,1261212,1258591) ORDER BY n.cover_points DESC, update_date DESC
0.0110  SELECT text_es as historical_text FROM leagues_text WHERE id=1267
0.0106  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 = 29545 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0107  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='1969' WHERE c.parentId=45 GROUP BY c.id ORDER BY c.order_id ASC
0.0105  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-04-19 13:57:55' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0109  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=2 AND last_update > '2024-04-19 13:57:55' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0106  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=4 AND last_update > '2024-04-19 13:57:55' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0110  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=3 AND last_update > '2024-04-19 13:57:55' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0111  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'apertura_peru' AND (l.group_code = 0 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 1969 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=0 DESC LIMIT 1
0.0109  SELECT e.action, count(e.action) as total, e.player_id FROM events1969 e WHERE e.league_id IN (29545) 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.0108  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 (29545) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN () ORDER BY rp.in_squad = 1 DESC
0.0113  SELECT e.action, count(e.action) as total, e.player_id FROM events1969 e WHERE e.league_id IN (29545) AND (e.action IN (4,5) ) GROUP BY e.player_id ORDER BY total DESC, e.player_id ASC LIMIT 20
0.0110  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 (29545) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN () ORDER BY rp.in_squad = 1 DESC
0.0112  SELECT e.action, count(e.action) as total, e.player_id FROM events1969 e WHERE e.league_id IN (29545) AND (e.action IN (3,4) ) GROUP BY e.player_id ORDER BY total DESC, e.player_id ASC LIMIT 20
0.0108  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 (29545) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN () ORDER BY rp.in_squad = 1 DESC
0.0107  SELECT e.action, count(e.action) as total, e.player_id FROM events1969 e WHERE e.league_id IN (29545) AND (e.action IN (22) ) GROUP BY e.player_id ORDER BY total DESC, e.player_id ASC LIMIT 20
0.0106  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 (29545) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN () ORDER BY rp.in_squad = 1 DESC
0.0106  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 = 29545 AND rp.lineup > 0 ORDER BY rp.lineup DESC,p.pod DESC LIMIT 20
0.0105  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 = 29545 AND rp.events > 0 ORDER BY rp.events DESC,p.pod DESC LIMIT 20
0.0109  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=29545 AND rel.round=18
0.0107  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 = 29545 AND esl.points > 0 ORDER BY esl.points DESC LIMIT 3
0.0107  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 = 29545 AND esl.points > 0
0.0107  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-20" AND c.`active`= 1 and c.comment_id is null and c.lang = 1 AND l.`id` = 29545 ORDER BY creation_date DESC LIMIT 0, 10
0.0111  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-20" AND c.`active`= 1 and comment_id is null and c.lang = 1 AND l.`id` = 29545
0.0107  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 `calendars1969` 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` = 29545 AND c.`round` = 18 ORDER BY shedule ASC LIMIT 200
0.0105  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 `events1969` e INNER JOIN calendars1969 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 = 18 AND e.real_date IS NOT NULL AND e.league_id = 29545 ORDER BY total DESC LIMIT 40
0.0107  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 `events1969` e INNER JOIN calendars1969 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 = 29545 AND e.real_date > NOW() - INTERVAL 1 MONTH ORDER BY e.real_date DESC LIMIT 30
0.0107  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 `tables1969` 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 = 29545 AND t.round = 16 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0107  SELECT *,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables1969` 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 = 29545 AND t.round = 18 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0107  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-19 00:00:00' AND c.`shedule` < '2024-04-23 23:59:59' AND l.id = 29545 ORDER BY c.shedule ASC, fcoef DESC LIMIT 5
0.0107  SELECT data1, data2 FROM services_tags WHERE categoryId=45
0.0107  SELECT l.year,l.group_code FROM leagues_besoccer l WHERE l.categoryId = 45 AND l.year = 1969 ORDER BY l.group_code ASC
0.0107  SELECT group_code, extraName from `leagues` WHERE categoryId=45 AND year=1969