4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Información Histórica 
						Argentina Third Level 1990/91

 

Primera B  Metropolitana

 
 
 
Table:		
 
No. Team 			      G   W   D   L  Gf  Ga   P
----------------------------------------------------------------
 1. Central Córdoba (Rosario)	     30  15  10   5  46  28  40  [Promoted to Nacional B]
----------------------------------------------------------------
 2. Almagro			     30  15   9   6  49  32  39  [Qualified Torneo Zonal Sureste]
 3. Nueva Chicago		     30  13  13   4  40  28  39  [Qualified Torneo Zonal Noroeste]
 4. Arsenal			     30  12  13   5  42  24  37  [Qualified Torneo Zonal Noroeste]
 5. Estudiantes BA		     30  12   9   9  35  35  33  [Qualified Torneo Zonal Sureste]
----------------------------------------------------------------
 6. San Miguel			     30   8  14   8  31  29  30
 7. Argentino de Rosario	     30  10   9  11  29  28  29
 8. Los Andes			     30   9  11  10  28  32  29
 9. Temperley			     30  11   7  12  28  34  29
10. El Porvenir			     30   7  14   9  31  35  28
11. Chacarita Juniors		     30   9   9  12  33  35  27
12. Ituzaingó			     30   5  15  10  25  34  25
13. Deportivo Merlo		     30   7  11  12  24  34  25
14. Berazategui			     30   7  11  12  28  39  25  [Relegation Tournament; worst average]
15. All Boys			     30   6  12  12  29  40  22  [*]
16. Deportivo Armenio		     30   7   7  16  34  46  21  [Relegation Tournament; worst average]
 
 
 
[*] All Boys 2 points deducted.
 
 
 
  
 
Round 1	
[Jul 28]		
Estudiantes BA		0-0	San Miguel
Argentino (Rosario)	1-0	Deportivo Merlo
El Porvenir		0-0	All Boys
Deportivo Armenio	1-2	Los Andes
Temperley		0-3	Berazategui
Nueva Chicago		1-1	Arsenal
Ituzaingó		0-1	Central Córdoba (Ros)
Chacarita Juniors	0-0	Almagro
 
 
Round 2				
[Aug 4]
Chacarita Juniors	3-0	Estudiantes BA
Almagro			2-2	Ituzaingó
Central Córdoba (Ros)	2-3	Nueva Chicago
Arsenal			3-0	Temperley
Berazategui		0-0	Deportivo Armenio
Los Andes		2-0	El Porvenir
All Boys		1-1	Argentino (Rosario)
Deportivo Merlo		1-0	San Miguel
 
 
Round 3				
[Aug 11]
Estudiantes BA		1-0	Deportivo Merlo
San Miguel		1-1	All Boys
Argentino (Rosario)	0-0	Los Andes
El Porvenir		1-0	Berazategui
Deportivo Armenio	2-1	Arsenal
Temperley		0-0	Central Córdoba (Ros)
Nueva Chicago		1-1	Almagro
Ituzaingó		0-0	Chacarita Juniors
 
 
Round 4				
[Aug 18]
Ituzaingó		1-1	Estudiantes BA
Chacarita Juniors	0-0	Nueva Chicago
Almagro			1-0	Temperley
Central Córdoba (Ros)	0-0	Deportivo Armenio
Arsenal			3-0	El Porvenir
Berazategui		2-1	Argentino (Rosario)
Los Andes		1-1	San Miguel
All Boys		2-1	Deportivo Merlo
 
 
Round 5				
[Aug 24]
Temperley		1-1	Chacarita Juniors
[Aug 25]
Estudiantes BA		0-3	All Boys
Deportivo Merlo		2-2	Los Andes
San Miguel		1-1	Berazategui
Argentino (Rosario)	2-1	Arsenal
El Porvenir		1-1	Central Córdoba (Ros)
Deportivo Armenio	0-1	Almagro
Nueva Chicago		2-1	Ituzaingó
 
 
Round 6				
[Sep 1]
Nueva Chicago		2-2	Estudiantes BA
Ituzaingó		0-1	Temperley
Chacarita Juniors	0-1	Deportivo Armenio
Almagro			3-0	El Porvenir
Central Córdoba (Ros)	1-1	Argentino (Rosario)
Arsenal			1-0	San Miguel
Berazategui		2-1	Deportivo Merlo
Los Andes		1-0	All Boys
 
 
Round 7				
[Sep 8]
Estudiantes BA		0-0	Los Andes
All Boys		2-0	Berazategui
Deportivo Merlo		2-1	Arsenal
San Miguel		2-2	Central Córdoba (Ros)
Argentino (Rosario)	1-1	Almagro
El Porvenir		1-1	Chacarita Juniors
Deportivo Armenio	3-0	Ituzaingó
Temperley		2-3	Nueva Chicago
 
 
Round 8				
[Sep 15]
Temperley		0-1	Estudiantes BA
Nueva Chicago		1-0	Deportivo Armenio
Ituzaingó		2-0	El Porvenir
Chacarita Juniors	0-1	Argentino (Rosario)
Almagro			3-1	San Miguel
Central Córdoba (Ros)	0-0	Deportivo Merlo
Arsenal			0-0	All Boys
Berazategui		0-0	Los Andes
 
 
Round 9				
[Sep 22]
Estudiantes BA		2-2	Berazategui
Los Andes		1-1	Arsenal
All Boys		1-3	Central Córdoba (Ros)
Deportivo Merlo		1-1	Almagro
San Miguel		1-2	Chacarita Juniors
Argentino (Rosario)	1-1	Ituzaingó
El Porvenir		2-2	Nueva Chicago
Deportivo Armenio	2-0	Temperley
 
 
Round 10				
[Sep 29]
Deportivo Armenio	0-1	Estudiantes BA
Temperley		1-3	El Porvenir
Nueva Chicago		1-0	Argentino (Rosario)
Ituzaingó		1-0	San Miguel
Chacarita Juniors	0-1	Deportivo Merlo
Almagro			2-0	All Boys
Central Córdoba (Ros)	1-1	Los Andes
Arsenal			0-0	Berazategui
 
 
Round 11				
[Oct 10]
Estudiantes BA		2-1	Arsenal
Berazategui		0-2	Central Córdoba (Ros)
Los Andes		2-1	Almagro
San Miguel		0-0	Nueva Chicago
Argentino (Rosario)	1-0	Temperley
El Porvenir		3-1	Deportivo Armenio
[Oct 16]
All Boys		1-0	Chacarita Juniors
Deportivo Merlo		0-0	Ituzaingó
 
 
Round 12				
[Oct 13]
El Porvenir		1-1	Estudiantes BA
Deportivo Armenio	0-2	Argentino (Rosario)
Temperley		1-0	San Miguel
Nueva Chicago		0-0	Deportivo Merlo
Ituzaingó		1-1	All Boys
Chacarita Juniors	2-0	Los Andes
Almagro			1-0	Berazategui
Central Córdoba (Ros)	1-1	Arsenal
 
 
Round 13				
[Oct 20]
Estudiantes BA		0-1	Central Córdoba (Ros)
Arsenal			4-0	Almagro
Berazategui		1-1	Chacarita Juniors
Los Andes		0-1	Ituzaingó
All Boys		1-1	Nueva Chicago
San Miguel		2-1	Deportivo Armenio
Argentino (Rosario)	0-2	El Porvenir
[Nov 6]
Deportivo Merlo		0-1	Temperley
 
 
Round 14				
[Oct 27]
El Porvenir		1-1	San Miguel
Deportivo Armenio	1-1	Deportivo Merlo
Nueva Chicago		3-1	Los Andes
Ituzaingó		1-1	Berazategui
Chacarita Juniors	0-2	Arsenal
Almagro			3-4	Central Córdoba (Ros)
[Oct 28]
Argentino (Rosario)	3-1	Estudiantes BA
[Nov 13]
Temperley		2-1	All Boys
 
 
Round 15				
[Nov 3]
Estudiantes BA		4-1	Almagro
Central Córdoba (Ros)	2-3	Chacarita Juniors
Arsenal			1-1	Ituzaingó
Berazategui		1-2	Nueva Chicago
Los Andes		0-3	Temperley
All Boys		2-1	Deportivo Armenio
Deportivo Merlo		0-0	El Porvenir
San Miguel		2-1	Argentino (Rosario)
 
 
Round 16			
[Nov 10]
San Miguel		0-1	Estudiantes BA
Deportivo Merlo		2-1	Argentino (Rosario)
All Boys		1-1	El Porvenir
Los Andes		2-0	Deportivo Armenio
Berazategui		0-0	Temperley
Arsenal			1-0	Nueva Chicago
Central Córdoba (Ros)	2-0	Ituzaingó
Almagro			1-0	Chacarita Juniors
 
 
Round 17				
[Nov 17]
Estudiantes BA		1-0	Chacarita Juniors			[Suspended in 89'; not continued]
Ituzaingó		2-2	Almagro
Nueva Chicago		0-0	Central Córdoba (Ros)
Temperley		1-1	Arsenal
Deportivo Armenio	2-3	Berazategui
El Porvenir		3-0	Los Andes
Argentino (Rosario)	3-0	All Boys
San Miguel		3-1	Deportivo Merlo
 
 
Round 18				
[Nov 24]
Deportivo Merlo		1-1	Estudiantes BA
All Boys		2-2	San Miguel
Los Andes		1-0	Argentino (Rosario)
Berazategui		0-0	El Porvenir
Arsenal			4-2	Deportivo Armenio
Central Córdoba (Ros)	3-1	Temperley
Almagro			2-0	Nueva Chicago				[Suspended in 88'; not continued]
Chacarita Juniors	2-1	Ituzaingó
 
 
Round 19				
[Dec 1]
Estudiantes BA		3-0	Ituzaingó
Nueva Chicago		1-1	Chacarita Juniors
Temperley		2-0	Almagro
Deportivo Armenio	1-3	Central Córdoba (Ros)
El Porvenir		0-0	Arsenal
Argentino (Rosario)	2-0	Berazategui
San Miguel		3-1	Los Andes
Deportivo Merlo		1-0	All Boys
 
 
Round 20				
[Dec 8]
All Boys		1-1	Estudiantes BA
Los Andes		0-1	Deportivo Merlo
Berazategui		1-1	San Miguel
Arsenal			2-0	Argentino (Rosario)
Central Córdoba (Ros)	2-1	El Porvenir
Almagro			2-2	Deportivo Armenio
Chacarita Juniors	2-4	Temperley
Ituzaingó		3-1	Nueva Chicago
 
 
Round 21				
[Dec 15]
Estudiantes BA		1-3	Nueva Chicago
Temperley		0-0	Ituzaingó
Deportivo Armenio	1-4	Chacarita Juniors
El Porvenir		1-2	Almagro
Argentino (Rosario)	0-0	Central Córdoba (Ros)
San Miguel		0-0	Arsenal
Deportivo Merlo		0-4	Berazategui
All Boys		1-0	Los Andes
 
 
Round 22				
[Feb 16, 1991]
Los Andes		0-1	Estudiantes BA
Berazategui		1-0	All Boys
Arsenal			2-0	Deportivo Merlo
Central Córdoba (Ros)	1-2	San Miguel
Almagro			2-0	Argentino (Rosario)
Chacarita Juniors	1-3	El Porvenir
Ituzaingó		0-2	Deportivo Armenio
Nueva Chicago		1-0	Temperley
 
 
Round 23				
[Feb 23]
Estudiantes BA		0-1	Temperley
Deportivo Armenio	1-1	Nueva Chicago
El Porvenir		2-2	Ituzaingó
Argentino (Rosario)	2-1	Chacarita Juniors
San Miguel		0-0	Almagro
Deportivo Merlo		0-1	Central Córdoba (Ros)
All Boys		2-2	Arsenal
Los Andes		1-1	Berazategui
 
 
Round 24				
[Mar 2]
Berazategui		2-3	Estudiantes BA
Arsenal			1-1	Los Andes
Central Córdoba (Ros)	2-1	All Boys
Almagro			3-0	Deportivo Merlo
Chacarita Juniors	1-1	San Miguel
Ituzaingó		2-1	Argentino (Rosario)
Nueva Chicago		3-0	El Porvenir
Temperley		2-0	Deportivo Armenio
 
 
Round 25				
[Mar 9]
Estudiantes BA		1-2	Deportivo Armenio
El Porvenir		0-0	Temperley
Argentino (Rosario)	1-1	Nueva Chicago
San Miguel		1-0	Ituzaingó
Deportivo Merlo		2-2	Chacarita Juniors
All Boys		1-3	Almagro
Los Andes		2-1	Central Córdoba (Ros)
Berazategui		1-2	Arsenal
 
 
Round 26				
[Mar 16]
Arsenal			2-2	Estudiantes BA
Central Córdoba (Ros)	1-0	Berazategui
Almagro			1-1	Los Andes
Chacarita Juniors	2-1	All Boys
Ituzaingó		0-0	Deportivo Merlo
Nueva Chicago		1-0	San Miguel
Temperley		0-0	Argentino (Rosario)
Deportivo Armenio	1-2	El Porvenir
 
 
Round 27				
[Mar 23]
Estudiantes BA		2-1	El Porvenir
Argentino (Rosario)	1-1	Deportivo Armenio
San Miguel		2-0	Temperley
Deportivo Merlo		0-1	Nueva Chicago
All Boys		1-1	Ituzaingó
Los Andes		0-1	Chacarita Juniors
Berazategui		0-6	Almagro
Arsenal			2-1	Central Córdoba (Ros)
 
 
Round 28			
[Mar 30]
Central Córdoba (Ros)	2-0	Estudiantes BA
Almagro			1-0	Arsenal
Chacarita Juniors	2-0	Berazategui
Ituzaingó		1-1	Los Andes
Nueva Chicago		0-0	All Boys
Temperley		1-0	Deportivo Merlo
Deportivo Armenio	1-1	San Miguel
El Porvenir		0-1	Argentino (Rosario)
 
 
Round 29				
[Apr 6]
Estudiantes BA		1-0	Argentino (Rosario)
San Miguel		1-1	El Porvenir
Deportivo Merlo		3-0	Deportivo Armenio
All Boys		1-2	Temperley
Los Andes		2-1	Nueva Chicago
Berazategui		1-0	Ituzaingó
Arsenal			1-0	Chacarita Juniors
[Apr 9]
Central Córdoba (Ros)	2-1	Almagro
 
 
 
Round 30				
[Apr 13]
Almagro			2-1	Estudiantes BA
Chacarita Juniors	1-4	Central Córdoba (Ros)
Ituzaingó		1-1	Arsenal
Nueva Chicago		4-1	Berazategui
Temperley		0-3	Los Andes
Deportivo Armenio	5-1	All Boys
El Porvenir		1-1	Deportivo Merlo
Argentino (Rosario)	1-2	San Miguel
 
 
 
 
 
Table:		
 
No. Team 			      G   W   D   L  Gf  Ga   P
----------------------------------------------------------------
 1. Central Córdoba (Rosario)	     30  15  10   5  46  28  40  [Promoted to Nacional B]
----------------------------------------------------------------
 2. Almagro			     30  15   9   6  49  32  39  [Qualified Torneo Zonal Sureste]
 3. Nueva Chicago		     30  13  13   4  40  28  39  [Qualified Torneo Zonal Noroeste]
 4. Arsenal			     30  12  13   5  42  24  37  [Qualified Torneo Zonal Noroeste]
 5. Estudiantes BA		     30  12   9   9  35  35  33  [Qualified Torneo Zonal Sureste]
----------------------------------------------------------------
 6. San Miguel			     30   8  14   8  31  29  30
 7. Argentino de Rosario	     30  10   9  11  29  28  29
 8. Los Andes			     30   9  11  10  28  32  29
 9. Temperley			     30  11   7  12  28  34  29
10. El Porvenir			     30   7  14   9  31  35  28
11. Chacarita Juniors		     30   9   9  12  33  35  27
12. Ituzaingó			     30   5  15  10  25  34  25
13. Deportivo Merlo		     30   7  11  12  24  34  25
14. Berazategui			     30   7  11  12  28  39  25  [Relegation Tournament; worst average]
15. All Boys			     30   6  12  12  29  40  22  [*]
16. Deportivo Armenio		     30   7   7  16  34  46  21  [Relegation Tournament; worst average]
 
 
 
[*] All Boys 2 points deducted.
 
 
 
 
 
 
Relegation Table: 
    
    Teams              	       88/89 89/90 90/91 Pts. MP. Average  
------------------------------------------------------------------
 1. Central Córdoba (Rosario)   36    34    40   110  92   1,196
 2. Nueva Chicago		26    37    39   102  92   1,109
 3. Estudiantes BA              34    32    33    99  92   1,076
 4. Deportivo Merlo		29    36    25    90  92   0,978
 5. Almagro			26    26    39    91  92   0,989
 6. Argentino de Rosario	--    --    29    29  30   0,967
 7. Los Andes			--    --    29    29  30   0,967
 8. Arsenal			22    29    37    88  92   0,956
 9. Temperley			--    29    29    58  62   0,935
10. All Boys			23    39    22    84  92   0,913
11. Ituzaingó			--    30    25    55  62   0,887
12. San Miguel			28    23    30    81  92   0,880
13. El Porvenir			17    36    28    81  92   0,880
14. Chacarita Juniors		--    27    27    54  62   0,871
------------------------------------------------------------------
15. Berazategui			--    --    25    25  30   0,833  [Relegation Tournament]
16. Deportivo Armenio		--    --    21    21  30   0,700  [Relegation Tournament]
 
 
 
 
 
 
Relegation Tournament
 
 
Semifinals
 
First leg 
[Jun 8]
Luján			1-0	Berazategui
Comunicaciones  	0-3	Deportivo Armenio
 
 
Second leg 
[Jun 15]
Berazategui		1-3	Luján
Deportivo Armenio	3-0	Comunicaciones 
 
 
 
.Note: Deportivo Armenio remain at Primera B Metropolitana.
       Berazategui relegated.
       Luján promoted to Primera B Metropolitana.
       Comunicaciones remain at Primera C.	
 
 
 
 
 
 
TORNEO ZONAL NOROESTE
 
 
 
 
Quarterfinals:
 
First leg:
[Apr 20]
Gimnasia y Esgrima (Jujuy)	3-2	Sarmiento (Catamarca)
[Apr 21]
Gimnasia y Esgrima (CU)		2-0	Arsenal
Sportivo Guzmán (Tucumán)	2-0	Estudiantes (Río Cuarto)
Deportivo Galaxia (Pto.Iguazú)	0-0	Nueva Chicago				[Suspended in 45'; awarded 0-1]	
 
 
Second leg:
[Apr 27]
Arsenal			     [2]2-0[4]	Gimnasia y Esgrima (Concepción del Uruguay)
Nueva Chicago			2-0	Deportivo Galaxia (Puerto Iguazú)
[Apr 28]
Sarmiento (Catamarca)        [2]1-0[3]	Gimnasia y Esgrima (Jujuy)
Estudiantes (Río Cuarto)	3-0	Sportivo Guzmán (Tucumán)
 
 
 
Semifinals:
 
First leg:
[May 5]
Gimnasia y Esgrima (CU)		1-0	Estudiantes (Río Cuarto)
Gimnasia y Esgrima (Jujuy)	1-1	Nueva Chicago	
 
 
Second leg:
[May 12]
Estudiantes (Río Cuarto)	0-0	Gimnasia y Esgrima (Concepción del Uruguay)
Nueva Chicago			3-2	Gimnasia y Esgrima (Jujuy)
 
 
 
Final:
 
First leg:
[May 19]
Nueva Chicago			1-1	Gimnasia y Esgrima (Concepción del Uruguay)
 
 
Second leg:
[May 26]
Gimnasia y Esgrima (CU)	     [1]1-1[3]	Nueva Chicago
 
 
 
.Note: Nueva Chicago promoted to Nacional B 1991/92.
 
 
 
 
 
TORNEO ZONAL SURESTE
 
 
 
 
Quarterfinals:
 
First leg:
[Apr 20]
Estudiantes BA			1-1	San Martín (San Juan)
Gimnasia y Esgrima (Mendoza)	1-1	Almagro
[Apr 21]
Alvarado (Mar del Plata)	1-1	All Boys (Santa Rosa)
Olimpo (Bahía Blanca)		2-3	Petroquímica (Comodoro Rivadavia)
 
 
Second leg:
[Apr 27]
Almagro				1-3	Gimnasia y Esgrima (Mendoza)		[aet]
[Apr 28]
San Martín (San Juan)		1-0	Estudiantes BA
All Boys (Santa Rosa)	     [4]0-0[5]	Alvarado (Mar del Plata)	
Petroquímica (CR)		0-2	Olimpo (Bahía Blanca)
 
 
 
Semifinals:
 
First leg:
[May 4]
Gimnasia y Esgrima (Mendoza)	0-0	Alvarado (Mar del Plata)
[May 5]
San Martín (San Juan)		2-0	Olimpo (Bahía Blanca)
 
 
Second leg:
[May 12]
Alvarado (Mar del Plata)     [1]0-0[3]	Gimnasia y Esgrima (Mendoza)
Olimpo (Bahía Blanca)		1-0	San Martín (San Juan)
 
 
 
Final:
 
First leg:
[May 18]
Gimnasia y Esgrima (Mendoza)	0-1	San Martín (San Juan)
 
 
Second leg:
[May 26]
San Martín (San Juan)		2-0	Gimnasia y Esgrima (Mendoza)
 
 
 
.Note: San Martín (San Juan) promoted to Nacional B 1991/92.
 
 
 
 


Author: Pablo  Ciullini (P_A_Ciullini@hotmail.com)
Last updated: 10 Apr 2014

(C) Copyright Pablo Ciullini and RSSSF 2012/14
You are free to copy this document in whole or part provided that proper acknowledgement is given to the author. All rights reserved.


  USO DE MEMORIA  
4,329,888 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0019
Controller Execution Time ( Home / Category )  0.7357
Total Execution Time  0.7376
  CADENA URL  
/primera_b_metropolitana1991
  GET DATOS  
$_GET['/primera_b_metropolitana1991']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (34)  
0.0125  SELECT type FROM routes WHERE alias = 'primera_b_metropolitana1991'
0.0252  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'primera_b_metropolitana' AND (l.group_code = 1 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 1991 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=1 DESC LIMIT 1
0.0131  SELECT text_es as historical_text FROM leagues_text WHERE id=5346
0.2026  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 = 33821 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0279  SELECT c.id, c.name, c.alias, l.id AS league_id, l.year, l.group_code, l.total_group, c.id AS categoryId, c.stepParent FROM categories AS c INNER JOIN leagues AS l ON c.id=l.categoryId AND c.active_year=l.year WHERE c.id=206 ORDER BY l.group_code ASC
0.0125  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-04-26 16:14:17' 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=2 AND last_update > '2024-04-26 16:14:17' 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-26 16:14:17' 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-26 16:14:17' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0130  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'primera_b_metropolitana' AND (l.group_code = 0 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 1991 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 events1991 e WHERE e.league_id IN (33821) 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 (33821) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN () ORDER BY rp.in_squad = 1 DESC
0.0125  SELECT e.action, count(e.action) as total, e.player_id FROM events1991 e WHERE e.league_id IN (33821) 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 (33821) 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 events1991 e WHERE e.league_id IN (33821) AND (e.action IN (3,4) ) 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 (33821) 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 events1991 e WHERE e.league_id IN (33821) 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 (33821) 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 = 33821 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 = 33821 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=33821 AND rel.round=30
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 = 33821 AND esl.points > 0 ORDER BY esl.points DESC LIMIT 3
0.0126  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 = 33821 AND esl.points > 0
0.0127  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-27" AND c.`active`= 1 and c.comment_id is null and c.lang = 1 AND l.`id` = 33821 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-27" AND c.`active`= 1 and comment_id is null and c.lang = 1 AND l.`id` = 33821
0.0126  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 `calendars1991` 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` = 33821 AND c.`round` = 30 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 `events1991` e INNER JOIN calendars1991 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 = 33821 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 `events1991` e INNER JOIN calendars1991 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 = 33821 AND e.real_date > NOW() - INTERVAL 1 MONTH ORDER BY e.real_date DESC LIMIT 30
0.0130  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 `tables1991` 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 = 33821 AND t.round = 28 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0130  SELECT *,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables1991` 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 = 33821 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0130  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-26 00:00:00' AND c.`shedule` < '2024-04-30 23:59:59' AND l.id = 33821 ORDER BY c.shedule ASC, fcoef DESC LIMIT 5
0.0130  SELECT data1, data2 FROM services_tags WHERE categoryId=206
0.0130  SELECT l.year,l.group_code FROM leagues_besoccer l WHERE l.categoryId = 206 AND l.year = 1991 ORDER BY l.group_code ASC
0.0130  SELECT group_code, extraName from `leagues` WHERE categoryId=206 AND year=1991