Información Histórica
						
Campeonato Descentralizado 1992
...............................


Round 1 [Apr 11,12]
Dep. Municipal  	2-2	FBC Melgar		
Cienciano		3-2	Alianza Atletico		
C.N.I.	          	0-2	Universitario		
Sport Boys		4-1	Union Minas		
Defensor Lima      	2-2	Dep. Yurimaguas		
Dep. San Agustin	0-2	Sporting Cristal		
Leon de Huanuco 	0-0	Alianza Lima		
U.T.C.      		1-0	Carlos A. Manucci		

Round 2 [Apr 18,19]
U.T.C.        		2-1	FBC Melgar		
Sporting Cristal	1-0	Carlos A. Manucci		
Alianza Lima      	0-0	Sport Boys		
Alianza Atletico	1-0	Universitario		
C.N.I.	        	1-1	Dep. San Agustin		
Leon de Huanuco 	1-2	Cienciano		
Defensor Lima    	2-1	Dep. Municipal		
Dep. Yurimaguas 	3-1	Union Minas		

Round 3 [Apr 25,26]
Universitario     	0-1	Sport Boys		
Dep. Yurimaguas 	0-2	Cienciano		
Dep. San Agustin	1-1	Defensor Lima		
Sporting Cristal	1-1	Union Minas		
U.T.C.      		1-0	Alianza Lima		
Leon de Huanuco 	3-0	Alianza Atletico		
Carlos A. Manucci	1-1	Dep. Municipal		
FBC Melgar		1-1	C.N.I.		

Round 4 [May 2,3]
Dep. San Agustin	1-1	Alianza Lima		
Sport Boys		2-3	Defensor Lima		
Universitario    	4-0	Cienciano		
Dep. Yurimaguas 	1-1	FBC Melgar		
Leon de Huanuco 	3-0	Dep. Municipal		
C.N.I.	        	2-1	Sporting Cristal		
U.T.C.	        	1-1	Union Minas		
Alianza Atletico	0-1	Carlos A. Manucci		

Round 5 [May 10,11]
Universitario   	3-2	Defensor Lima		
Dep. Yurimaguas 	0-1	Sporting Cristal		
Dep. San Agustin	3-0	FBC Melgar		
Dep. Municipal  	2-1	U.T.C.		
C.N.I.	         	1-0	Alianza Lima		
Leon de Huanuco 	1-1	Sport Boys		
Union Minas		4-1   Alianza Atletico		
Carlos A. Manucci	1-0	Cienciano		

Round 6 [May 16,17]
Universitario   	1-0	Alianza Lima		
Dep. Yurimaguas 	3-3	Dep. Municipal		
Defensor Lima   	0-1	U.T.C.		
Sporting Cristal	1-1	Cienciano		
FBC Melgar		2-0	Sport Boys		
Alianza Atletico	3-1	Dep. San Agustin		
C.N.I.	         	2-0	Union Minas		
Carlos A. Manucci	0-0	Leon de Huanuco		

Round 7 [May 23,24]
Alianza Lima		1-0	Dep. Yurimaguas		
Dep. San Agustin	0-0	Sport Boys		
Dep. Municipal		0-0	C.N.I.		
Defensor Lima		0-2	Union Minas		
Carlos A. Manucci	0-1	Universitario		
Alianza Atletico	2-1	Sporting Cristal		
Leon de Huanuco 	2-0	FBC Melgar		
U.T.C.			2-3	Cienciano		

Round 8 [May 30,31]
Sporting Cristal	2-1	Defensor Lima		
Universitario		2-1	Union Minas		
Dep. San Agustin	0-0	Carlos A. Manucci		
Dep. Yurimaguas 	3-3	Leon de Huanuco		
Cienciano		0-0	Dep. Municipal		
Alianza Atletico	2-1	Sport Boys		
U.T.C.			1-0	C.N.I.		
FBC Melgar		0-1	Alianza Lima		

Round 9 [Jun 6,7]
Defensor Lima		1-1	Alianza Lima		
Dep. Yurimaguas 	0-1	Dep. San Agustin		
Sporting Cristal	2-2	U.T.C.		
Dep. Municipal		5-0	Union Minas		
Carlos A. Manucci	2-2	Sport Boys		
Leon de Huanuco 	1-1	Universitario		
C.N.I.			1-4	Cienciano		
Alianza Atletico	1-1	FBC Melgar		

Round 10 [Jun 13,14]
Sporting Cristal	1-1	Sport Boys		
Dep. Municipal		0-2	Alianza Lima		
Dep. San Agustin	1-0	Leon de Huanuco		[or 2-1?]	
Dep. Yurimaguas 	0-2	Alianza Atletico		
U.T.C.			0-1	Universitario		
Cienciano		1-0	Defensor Lima		
C.N.I.			1-0	Carlos A. Manucci		
FBC Melgar		2-1	Union Minas		

Round 11 [Jun 20,21]
Dep. Municipal		0-3	Universitario		
Dep. Yurimaguas 	3-4	Sport Boys		
Dep. San Agustin	2-2	U.T.C.		
Sporting Cristal	0-0	FBC Melgar		
Cienciano		1-0	Alianza Lima		
Leon de Huanuco 	1-0	Defensor Lima		
Union Minas		2-2	Carlos A. Manucci		
C.N.I.			1-1	Alianza Atletico		

Round 12 [Jun 27,28]
Universitario		0-2	Sporting Cristal		
Dep. Municipal		0-0	Sport Boys		
Cienciano		0-0	Dep. San Agustin		
Alianza Atletico	0-0	U.T.C.		
Union Minas		2-1	Leon de Huanuco		
C.N.I.			1-0	Dep. Yurimaguas		
Alianza Lima		0-0	Carlos A. Manucci		
Defensor Lima		0-0	FBC Melgar		

Round 13 [Jul 3,4]
Universitario		1-0	Dep. Yurimaguas		
Dep. San Agustin	0-0	Dep. Municipal		
Sporting Cristal	0-0	Leon de Huanuco		
Defensor Lima		2-2	C.N.I.		
Alianza Atletico	2-1	Alianza Lima		
U.T.C.			2-1	Sport Boys		
Union Minas		2-1	Cienciano		
FBC Melgar		3-1	Carlos A. Manucci		

Round 14 [Jul 11,12]
Dep. San Agustin	1-3	Universitario		
Dep. Yurimaguas 	2-2	Carlos A. Manucci	[or 0-1?]
U.T.C.			1-4	Leon de Huanuco		[or 2-5?]	
Union Minas		4-0	Alianza Lima		
Alianza Atletico	0-0	Defensor Lima		
Sport Boys		2-0	C.N.I.		
Dep. Municipal		1-2	Sporting Cristal		
FBC Melgar		0-0	Cienciano		

Round 15 [Jul 18,19]
Sporting Cristal	2-2	Alianza Lima		
C.N.I.			1-0	Leon de Huanuco		
U.T.C.			1-0	Dep. Yurimaguas		
Cienciano		1-2	Sport Boys		
FBC Melgar		2-0	Universitario		
Dep. Municipal		1-1	Alianza Atletico		
Dep. San Agustin	2-0	Union Minas		
Defensor Lima		2-2	Carlos A. Manucci		

Round 16 [Aug 8,9]
FBC Melgar		3-0	Dep. Municipal		
Alianza Atletico	2-0	Cienciano		
Universitario		6-0	C.N.I.		
Union Minas		1-1	Sport Boys		
Dep. Yurimaguas 	0-2	Defensor Lima		
Sporting Cristal	3-0	Dep. San Agustin		
Alianza Lima		1-1	Leon de Huanuco		
Carlos A. Manucci	2-0	U.T.C.		

Round 17 [Aug 15,16]
FBC Melgar		3-1	U.T.C.		
Carlos A. Manucci	0-3	Sporting Cristal		
Sport Boys		0-0	Alianza Lima		
Universitario		3-0	Alianza Atletico		
Dep. San Agustin	2-2	C.N.I.		
Cienciano		2-1	Leon de Huanuco		
Dep. Municipal		awd	Defensor Lima   	[awarded 0-2;
Union Minas		3-0	Dep. Yurimaguas		 originally 2-0]

Round 18 [Aug 23,24]
Sport Boys		1-1	Universitario		
Cienciano		2-2	Dep. Yurimaguas		
Defensor Lima		1-3	Dep. San Agustin		
Union Minas		2-1	Sporting Cristal		
Alianza Lima		2-1	U.T.C.		
Alianza Atletico	2-5	Leon de Huanuco		
Dep. Municipal		5-2	Carlos A. Manucci		
C.N.I.			1-1	FBC Melgar		

Round 19 [Aug 30,31]
Alianza Lima		5-0	Dep. San Agustin		
Defensor Lima		1-3	Sport Boys		
Cienciano		1-1	Universitario		
FBC Melgar		4-1	Dep. Yurimaguas		
Dep. Municipal		2-1	Leon de Huanuco		
Sporting Cristal	2-0	C.N.I.		
Union Minas		1-1	U.T.C.		
Carlos A. Manucci	0-0	Alianza Atletico		

Round 20 [Sep 5,6]
Defensor Lima		1-1	Universitario		
Sporting Cristal	4-1	Dep. Yurimaguas		
FBC Melgar		3-1	Dep. San Agustin		
U.T.C.			1-0	Dep. Municipal		
Alianza Lima		4-0	C.N.I.		
Sport Boys		3-0	Leon de Huanuco		
Alianza Atletico	1-1	Union Minas		
Cienciano		0-0	Carlos A. Manucci		

Round 21 [Sep 12,13]
Alianza Lima		0-2	Universitario		
Dep. Municipal		2-1	Dep. Yurimaguas		[or 1-0?]
U.T.C.			4-1	Defensor Lima		[or 4-0?]	
Cienciano		2-1	Sporting Cristal		
Sport Boys		0-0	FBC Melgar		
Dep. San Agustin	3-0	Alianza Atletico		
Union Minas		3-0	C.N.I.		
Leon de Huanuco 	1-0	Carlos A. Manucci		

Round 22 [Sep 19,20]
Dep. Yurimaguas 	0-1	Alianza Lima		
Sport Boys		2-2	Dep. San Agustin		
C.N.I.			2-2	Dep. Municipal		
Union Minas		1-0	Defensor Lima		
Universitario		2-0	Carlos A. Manucci		
Sporting Cristal	3-0	Alianza Atletico		
FBC Melgar		4-2	Leon de Huanuco		
Cienciano		3-1	U.T.C.			[or 3-0?]

Round 23 [Sep 26,27]
Defensor Lima		1-1	Sporting Cristal		
Union Minas		1-1	Universitario		
Carlos A. Manucci	2-0	Dep. San Agustin		
Leon de Huanuco 	2-1	Dep. Yurimaguas		
Dep. Municipal  	1-1	Cienciano		
Sport Boys		2-2	Alianza Atletico		
C.N.I.			5-1	U.T.C.		
Alianza Lima		3-1	FBC Melgar		

Round 24 [Oct 3,4]
Alianza Lima		3-1	Defensor Lima		
Dep. San Agustin	2-1	Dep. Yurimaguas		
U.T.C.			0-1	Sporting Cristal		
Union Minas		1-0	Dep. Municipal		
Sport Boys		1-0	Carlos A. Manucci		
Universitario		2-0	Leon de Huanuco		
Cienciano		4-0	C.N.I.		
FBC Melgar		3-0	Alianza Atletico		

Round 25 [Oct 10,11]
Sport Boys		1-2	Sporting Cristal		
Alianza Lima		0-0	Dep. Municipal		
Leon de Huanuco 	2-1	Dep. San Agustin		
Alianza Atletico	1-0	Dep. Yurimaguas		
Universitario		2-0	U.T.C.		
Defensor Lima		5-1	Cienciano		
Carlos A. Manucci	1-1	C.N.I.		
Union Minas		2-0	FBC Melgar		

Round 26 [Oct 17,18]
Universitario		3-1	Dep. Municipal		
Sport Boys		1-0	Dep. Yurimaguas		
U.T.C.			2-1	Dep. San Agustin		
FBC Melgar		6-0	Sporting Cristal		
Alianza Lima		1-0	Cienciano		
Defensor Lima		1-1	Leon de Huanuco		
Carlos A. Manucci	2-0	Union Minas		
Alianza Atletico	4-1	C.N.I.		

Round 27 [Oct 24,25]
Sporting Cristal	2-1	Universitario		
Sport Boys		0-2	Dep. Municipal		
Dep. San Agustin	1-1	Cienciano		
U.T.C.			2-0	Alianza Atletico		
Leon de Huanuco 	4-1	Union Minas		
Dep. Yurimaguas 	2-2	C.N.I.		
Carlos A. Manucci	0-0	Alianza Lima		
FBC Melgar		1-0	Defensor Lima		

Round 28 [Oct 31, Nov 1]
Dep. Yurimaguas 	1-2	Universitario		
Dep. Municipal  	3-2	Dep. San Agustin		
Leon de Huanuco 	2-4	Sporting Cristal		
C.N.I.			1-3	Defensor Lima		
Alianza Lima 		2-0	Alianza Atletico		
Sport Boys		8-2	U.T.C.		
Cienciano		4-1	Union Minas		
Carlos A. Manucci	2-1	FBC Melgar		

Round 29 [Nov 8]
Universitario		4-1	Dep. San Agustin		
Carlos A. Manucci	2-0	Dep. Yurimaguas		
Leon de Huanuco 	3-3	U.T.C.		
Alianza Lima    	2-1	Union Minas		
Defensor Lima   	4-2	Alianza Atletico	[or 3-1?]	
C.N.I.	 		2-3	Sport Boys		
Sporting Cristal	0-0	Dep. Municipal		
Cienciano		1-2	FBC Melgar		

Round 30 [Nov 15]
Alianza Lima    	1-1	Sporting Cristal		
Leon de Huanuco 	5-0	C.N.I.		
Dep. Yurimaguas 	4-1	U.T.C.		
Sport Boys		5-2	Cienciano		
Universitario     	0-2	FBC Melgar		
Alianza Atletico	3-4	Dep. Municipal		
Union Minas		0-0	Dep. San Agustin		
Carlos A. Manucci	1-1	Defensor Lima		

Final table

 1. Universitario             30  19   5   6   53  22   43 [Lima]    [1992 Champion,To Copa Libertadores]
 2. Sporting Cristal          30  15  10   5   47  29   40 [Lima]    [To Liguilla,Bonus+1]
 3. FBC Melgar                30  14   9   7   48  28   37 [Arequipa][To Liguilla]
 4. Sport Boys                30  12  12   6   52  35   36 [Callao]  [To Liguilla]
 5. Alianza Lima              30  12  11   7   34  22   35 [Lima]    [To Liguilla]
 6. Cienciano                 30  12   9   9   43  40   33 [Cusco]   [To Liguilla]
 7. León de Huanuco           30  10  10  10   50  40   30 [Huanuco]
 8. Unión Minas               30  11   8  11   41  44   30 [Cerro de Pasco]
 9. Univ.Técnica de Cajamarca 30  11   7  12   38  53   29 [Cajamarca]
10. Deportivo Municipal       30   8  12  10   41  41   28 [Lima]
11. Alianza Atlético          30  10   8  12   35  51   28 [Sullana]
12. Defensor Lima             30   7  12  11   38  46   26 [Lima]
13. Deportivo San Agustín     30   7  12  11   34  45   26 [Lima]
14. Carlos A. Manucci         30   6  13  11   26  31   25 [Trujillo]
15. Colegio Nac. de Iquitos   30   7  10  13   31  58   24 [Iquitos] [Relegated]
16. Deportivo Yurimaguas      30   2   7  21   30  56   11 [Lima]    [Relegated]


Liguilla Pre-Libertadores/Conmebol (in Lima)
==================================
Round 1 [Nov 29]			
Sporting Cristal	4-0	Cienciano
Alianza Lima       	1-2	Melgar FBC
Sport Boys	 	0-2	Ovacion Sipesa

Round 2 [Dec 2]			
Sporting Cristal	2-2	Sport Boys
Alianza Lima       	4-0	Ovacion Sipesa
Cienciano        	1-2	Melgar FBC

Round 3 [Dec 6]			
Sporting Cristal	3-1	Ovacion Sipesa
Sport Boys	 	2-0	Melgar FBC
Alianza Lima       	1-2	Cienciano

Round 4 [Dec 9]			
Sporting Cristal	2-2	Alianza Lima
Sport Boys	 	3-0	Cienciano
Ovacion Sipesa        	4-0	Melgar FBC

Round 5 [Dec 13]			
Sporting Cristal	1-0	Melgar FBC
Alianza Lima       	3-2	Sport Boys
Ovacion Sipesa 		5-3	Cienciano

Final Table:

 1. SPORTING CRISTAL            5   3   2   0   12   5    9 [To Copa Libertadores]
 2. Ovación Sipesa*             5   3   0   2   12  10    6 [To Copa Conmebol]
 3. Alianza Lima                5   2   1   2   11   8    5
 4. Sport Boys                  5   2   1   2    9   7    5
 5. Melgar FBC                  5   2   0   3    4   9    4
 6. Cienciano                   5   1   0   4    6  15    2
* champion Torneo Zonal

CAMPEON: UNIVERSITARIO
COPA LIBERTADORES: Universitario and Sporting Cristal
COPA CONMEBOL: Ovacion Sipesa
RELEGATED: Colegio Nacional de Iquitos and Deportivo Yurimaguas
PROMOTED: Ovacion Sipesa and Union Huaral



Author: Carlos Manuel Nieto Tarazona

Last updated: 15 Sep 2004

(C) Copyright Carlos Manuel Nieto Tarazona 
and RSSSF 1999/2004
						

Uso de cookies: Utilizamos "cookies" propias y de terceros para mejorar nuestros servicios, elaborar información estadística, analizar sus hábitos de navegación e inferir grupos de interés. Esto nos permite personalizar el contenido que ofrecemos y mostrarle publicidad relacionada con sus preferencias. Adicionalmente, compartimos los análisis de navegación y los grupos de interés inferidos con terceros. Si continúa navegando acepta su uso. Más información y cambio de configuración. Aceptar

  USO DE MEMORIA  
4,347,952 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0019
Controller Execution Time ( Home / Category )  0.5042
Total Execution Time  0.5062
  CADENA URL  
/apertura_peru1992
  GET DATOS  
$_GET['/apertura_peru1992']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (38)  
0.0105  SELECT type FROM routes WHERE alias = 'apertura_peru1992'
0.0214  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 = 1992 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=1 DESC LIMIT 1
0.0106  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=45 AND type_rel = 3
0.0114  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.0110  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.0112  SELECT text_es as historical_text FROM leagues_text WHERE id=1259
0.0107  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 = 29537 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0113  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='1992' WHERE c.parentId=45 GROUP BY c.id ORDER BY c.order_id ASC
0.0108  SELECT type,rule FROM rules WHERE categoryId = 45 ORDER BY type = 'tables_draw' DESC,type != 'extra' DESC, `order` ASC
0.0111  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-03-29 14:34:47' 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=2 AND last_update > '2024-03-29 14:34:47' 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=4 AND last_update > '2024-03-29 14:34:47' 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-03-29 14:34:47' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0123  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 = 1992 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=0 DESC LIMIT 1
0.0111  SELECT e.action, count(e.action) as total, e.player_id FROM events1992 e WHERE e.league_id IN (29537) 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.0107  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 (29537) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN () ORDER BY rp.in_squad = 1 DESC
0.0105  SELECT e.action, count(e.action) as total, e.player_id FROM events1992 e WHERE e.league_id IN (29537) AND (e.action IN (4,5) ) GROUP BY e.player_id ORDER BY total DESC, e.player_id ASC LIMIT 20
0.0105  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 (29537) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN () ORDER BY rp.in_squad = 1 DESC
0.0106  SELECT e.action, count(e.action) as total, e.player_id FROM events1992 e WHERE e.league_id IN (29537) AND (e.action IN (3,4) ) GROUP BY e.player_id ORDER BY total DESC, e.player_id ASC LIMIT 20
0.0107  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 (29537) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN () ORDER BY rp.in_squad = 1 DESC
0.0109  SELECT e.action, count(e.action) as total, e.player_id FROM events1992 e WHERE e.league_id IN (29537) AND (e.action IN (22) ) GROUP BY e.player_id ORDER BY total DESC, e.player_id ASC LIMIT 20
0.0117  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 (29537) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN () ORDER BY rp.in_squad = 1 DESC
0.0108  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 = 29537 AND rp.lineup > 0 ORDER BY rp.lineup DESC,p.pod DESC LIMIT 20
0.0106  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 = 29537 AND rp.events > 0 ORDER BY rp.events DESC,p.pod DESC LIMIT 20
0.0111  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=29537 AND rel.round=30
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 = 29537 AND esl.points > 0 ORDER BY esl.points DESC LIMIT 3
0.0106  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 = 29537 AND esl.points > 0
0.0106  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-02-28" AND c.`active`= 1 and c.comment_id is null and c.lang = 1 AND l.`id` = 29537 ORDER BY creation_date DESC LIMIT 0, 10
0.0110  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-02-28" AND c.`active`= 1 and comment_id is null and c.lang = 1 AND l.`id` = 29537
0.0106  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 `calendars1992` 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` = 29537 AND c.`round` = 30 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 `events1992` e INNER JOIN calendars1992 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 = 30 AND e.real_date IS NOT NULL AND e.league_id = 29537 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 `events1992` e INNER JOIN calendars1992 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 = 29537 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 `tables1992` 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 = 29537 AND t.round = 28 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 `tables1992` 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 = 29537 AND t.round = 30 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-03-29 00:00:00' AND c.`shedule` < '2024-04-02 23:59:59' AND l.id = 29537 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 = 1992 ORDER BY l.group_code ASC
0.0107  SELECT group_code, extraName from `leagues` WHERE categoryId=45 AND year=1992