Información Histórica
						Argentina Third Level 1986/87


Primera B  Metropolitana 1986/87

 
Table:		
 
No. Team 			      G   W   D   L  Gf  Ga   P
----------------------------------------------------------------
 1. Quilmes			     34  20   8   6  60  21  48  [Promoted to Second Division]
----------------------------------------------------------------
 2. Almirante Brown		     34  19   7   8  55  31  45  [Qualified Torneo Zonal Sureste]
 3. Estudiantes BA                   34  17  10   7  57  34  44  [Qualified Torneo Zonal Noroeste]
 4. Arsenal			     34  18   8   8  52  34  44  [Qualified Torneo Zonal Noroeste]
 5. Villa Dálmine		     34  17   9   8  50  28  43  [Qualified Torneo Zonal Sureste]
----------------------------------------------------------------
 6. Deportivo Morón   		     34  12  17   5  44  34  41
 7. Almagro			     34  15  11   8  43  33  41
 8. Nueva Chicago		     34  15  10   9  65  48  40
 9. San Miguel			     34  14  12   8  46  34  40
10. Deportivo Merlo		     34  11  10  13  35  43  32
11. El Porvenir			     34  11   9  14  29  29  31
12. All Boys			     34   9  13  12  39  42  31
13. Defensores de Belgrano           34   9  12  13  43  55  30
14. Atlanta			     34  10  10  14  31  46  30
15. Berazategui			     34   7  12  15  36  57  26
16. Argentino de Rosario	     34   6  10  18  29  49  22
----------------------------------------------------------------
17. Comunicaciones		     34   2   8  24  18  59  12  [Relegated; worst average]
18. Sportivo Dock Sud		     34   3   6  25  16  71  12  [Relegated; worst average]
 
 
 
 
 
Round 1	
[Jul 26]		
Defensores de Belgrano	0-0	Nueva Chicago
Almirante Brown		1-0	Sportivo Dock Sud
Argentino (Rosario)	0-2	Quilmes
Deportivo Merlo		0-0	All Boys
Estudiantes BA		1-0	Almagro
Comunicaciones		2-4	Deportivo Morón
Berazategui		0-2	Villa Dálmine
Arsenal			1-0	San Miguel
Atlanta			1-0	El Porvenir
 
 
Round 2				
[Aug 2]
Atlanta			1-2	Defensores de Belgrano
El Porvenir		2-1	Arsenal
San Miguel		3-1	Berazategui
Villa Dálmine		2-0	Comunicaciones
Deportivo Morón		0-0	Estudiantes BA
Almagro			2-1	Deportivo Merlo
All Boys		1-1	Argentino (Rosario)
Quilmes			1-1	Almirante Brown
Sportivo Dock Sud	0-3	Nueva Chicago
 
 
Round 3				
[Aug 9]
Argentino (Rosario)	0-1	Almagro
[Aug 13]
Defensores de Belgrano	4-1	Sportivo Dock Sud
Nueva Chicago		0-4	Quilmes
Almirante Brown		4-1	All Boys
Deportivo Merlo		1-1	Deportivo Morón
Estudiantes BA		0-0	Villa Dálmine
Comunicaciones		0-1	San Miguel
Berazategui		0-0	El Porvenir
Arsenal			1-0	Atlanta
 
 
Round 4				
[Aug 16]
Arsenal			2-0	Defensores de Belgrano
Atlanta			0-0	Berazategui
El Porvenir		3-1	Comunicaciones
San Miguel		2-0	Estudiantes BA
Villa Dálmine		1-1	Deportivo Merlo
Deportivo Morón		0-0	Argentino (Rosario)
Almagro			0-0	Almirante Brown
All Boys		0-0	Nueva Chicago
Quilmes			3-0	Sportivo Dock Sud
 
 
Round 5				
[Aug 23]
Defensores de Belgrano	0-0	Quilmes
Sportivo Dock Sud	0-0	All Boys
Nueva Chicago		1-0	Almagro
Almirante Brown		5-2	Deportivo Morón
Argentino (Rosario)	0-0	Villa Dálmine
Deportivo Merlo		1-2	San Miguel
Estudiantes BA		0-0	El Porvenir
Comunicaciones		0-0	Atlanta
Berazategui		0-1	Arsenal
 
 
Round 6				
[Aug 30]
Berazategui		1-1	Defensores de Belgrano			[Later Defensores de Belgrano lost points]
Arsenal			1-0	Comunicaciones
Atlanta			3-2	Estudiantes BA
El Porvenir		0-1	Deportivo Merlo
San Miguel		1-0	Argentino (Rosario)
Villa Dálmine		2-0	Almirante Brown
Deportivo Morón		1-1	Nueva Chicago
Almagro			0-1	Sportivo Dock Sud
All Boys		1-0	Quilmes
 
 
Round 7				
[Sep 6]
Defensores de Belgrano	2-2	All Boys
Quilmes			1-0	Almagro
Sportivo Dock Sud	0-0	Deportivo Morón
Nueva Chicago		1-0	Villa Dálmine
Almirante Brown		1-1	San Miguel
Argentino (Rosario)	1-0	El Porvenir
Deportivo Merlo		1-0	Atlanta
Estudiantes BA		3-1	Arsenal
Comunicaciones		1-1	Berazategui
 
 
Round 8				
[Sep 13]
Comunicaciones		1-2	Defensores de Belgrano
Berazategui		1-4	Estudiantes BA
Arsenal			2-2	Deportivo Merlo
Atlanta			0-1	Argentino (Rosario)
El Porvenir		0-1	Almirante Brown
San Miguel		1-1	Nueva Chicago
Villa Dálmine		4-0	Sportivo Dock Sud
Deportivo Morón		1-0	Quilmes
Almagro			0-2	All Boys
 
 
Round 9				
[Sep 20]
Defensores de Belgrano	2-3	Almagro
All Boys		1-2	Deportivo Morón
Quilmes			3-0	Villa Dálmine
Sportivo Dock Sud	0-1	San Miguel
Nueva Chicago		2-0	El Porvenir
Almirante Brown		2-0	Atlanta
Argentino (Rosario)	0-0	Arsenal
Deportivo Merlo		1-0	Berazategui
Estudiantes BA		3-0	Comunicaciones
 
 
Round 10				
[Sep 27]
Estudiantes BA		5-5	Defensores de Belgrano
Comunicaciones		0-1	Deportivo Merlo
Berazategui		2-2	Argentino (Rosario)
Arsenal			1-2	Almirante Brown
Atlanta			4-3	Nueva Chicago
El Porvenir		6-0	Sportivo Dock Sud
San Miguel		0-1	Quilmes
Villa Dálmine		1-1	All Boys
Deportivo Morón		0-1	Almagro
 
 
Round 11				
[Oct 4]
Defensores de Belgrano	0-0	Deportivo Morón
Almagro			2-0	Villa Dálmine
All Boys		1-1	San Miguel
Quilmes			1-1	El Porvenir
Sportivo Dock Sud	1-2	Atlanta
Nueva Chicago		2-7	Arsenal
Almirante Brown		0-0	Berazategui
Argentino (Rosario)	0-0	Comunicaciones
Deportivo Merlo		0-1	Estudiantes BA
 
 
Round 12				
[Oct 11]
Deportivo Merlo		1-1	Defensores de Belgrano
Estudiantes BA		0-0	Argentino (Rosario)
Comunicaciones		1-2	Almirante Brown
Berazategui		1-1	Nueva Chicago
Arsenal			3-1	Sportivo Dock Sud
Atlanta			0-1	Quilmes
El Porvenir		2-1	All Boys
San Miguel		2-2	Almagro
Villa Dálmine		0-2	Deportivo Morón
 
 
Round 13				
[Oct 18]
Defensores de Belgrano	1-6	Villa Dálmine
Deportivo Morón		1-1	San Miguel
Almagro			1-0	El Porvenir
All Boys		0-3	Atlanta
Quilmes			1-1	Arsenal
Sportivo Dock Sud	0-0	Berazategui
Nueva Chicago		4-0	Comunicaciones
Almirante Brown		1-2	Estudiantes BA
Argentino (Rosario)	3-1	Deportivo Merlo
 
 
Round 14				
[Oct 25]
Argentino (Rosario)	0-1	Defensores de Belgrano
Deportivo Merlo		0-0	Almirante Brown
Estudiantes BA		2-1	Nueva Chicago
Comunicaciones		1-1	Sportivo Dock Sud
Berazategui		0-4	Quilmes
Arsenal			2-0	All Boys
Atlanta			2-2	Almagro
El Porvenir		1-1	Deportivo Morón
San Miguel		0-0	Villa Dálmine
 
 
Round 15				
[Nov 1]
Defensores de Belgrano	0-0	San Miguel
Villa Dálmine		0-1	El Porvenir
Deportivo Morón		0-0	Atlanta
Almagro			3-1	Arsenal
All Boys		2-2	Berazategui
Quilmes			2-0	Comunicaciones
Sportivo Dock Sud	0-3	Estudiantes BA
Nueva Chicago		0-2	Deportivo Merlo
Almirante Brown		2-0	Argentino (Rosario)
 
 
Round 16				
[Nov 8]
Argentino (Rosario)	2-4	Nueva Chicago
[Nov 11]
Almirante Brown		3-2	Defensores de Belgrano			[Suspended in 87'; not continued]
Deportivo Merlo		3-0	Sportivo Dock Sud
Estudiantes BA		2-0	Quilmes
Comunicaciones		1-1	All Boys
Berazategui		0-0	Almagro
Arsenal			1-0	Deportivo Morón
Atlanta			1-1	Villa Dálmine
El Porvenir		0-0	San Miguel
 
 
Round 17				
[Nov 15]
Defensores de Belgrano	1-0	El Porvenir
San Miguel		0-1	Atlanta
Villa Dálmine		1-1	Arsenal
Deportivo Morón		1-2	Berazategui
Almagro			2-1	Comunicaciones
All Boys		2-1	Estudiantes BA
Quilmes			3-1	Deportivo Merlo
Sportivo Dock Sud	1-0	Argentino (Rosario)
Nueva Chicago		1-0	Almirante Brown
 
 
Round 18				
[Nov 22]
Nueva Chicago		3-2	Defensores de Belgrano
Sportivo Dock Sud	2-1	Almirante Brown
Quilmes			2-1	Argentino (Rosario)
All Boys		0-0	Deportivo Merlo
Almagro			0-0	Estudiantes BA
Deportivo Morón		2-0	Comunicaciones
Villa Dálmine		2-0	Berazategui
San Miguel		0-2	Arsenal
El Porvenir		2-0	Atlanta
 
 
Round 19				
[Nov 29]
Defensores de Belgrano	3-0	Atlanta
Arsenal			1-0	El Porvenir
Berazategui		2-2	San Miguel
Comunicaciones		0-2	Villa Dálmine
Estudiantes BA		0-1	Deportivo Morón
Deportivo Merlo		2-0	Almagro
Argentino (Rosario)	0-0	All Boys
Almirante Brown		1-0	Quilmes
Nueva Chicago		4-0	Sportivo Dock Sud
 
 
Round 20				
[Dec 6]
Sportivo Dock Sud	0-1	Defensores de Belgrano			[Suspended in 88'; not continued]
Quilmes			3-1	Nueva Chicago
All Boys		3-1	Almirante Brown
Almagro			2-1	Argentino (Rosario)
Deportivo Morón		1-1	Deportivo Merlo
Villa Dálmine		5-1	Estudiantes BA
San Miguel		2-0	Comunicaciones
El Porvenir		2-1	Berazategui
Atlanta			0-0	Arsenal
 
 
Round 21				
[Dec 13]
Defensores de Belgrano	1-2	Arsenal
Berazategui		1-1	Atlanta
Comunicaciones		0-0	El Porvenir
Estudiantes BA		1-1	San Miguel
Deportivo Merlo		0-3	Villa Dálmine
Argentino (Rosario)	1-2	Deportivo Morón
Almirante Brown		4-2	Almagro
Nueva Chicago		2-2	All Boys
Sportivo Dock Sud	1-1	Quilmes					[Suspended in 79'; continued Feb 11, 1987]
[Feb 11, 1987]
Sportivo Dock Sud	1-1	Quilmes	
 
 
Round 22				
[Dec 20]
Quilmes			1-1	Defensores de Belgrano
All Boys		3-0	Sportivo Dock Sud
Almagro			2-2	Nueva Chicago
Deportivo Morón		2-2	Almirante Brown
Villa Dálmine		2-0	Argentino (Rosario)
San Miguel		4-1	Deportivo Merlo
El Porvenir		0-1	Estudiantes BA
Atlanta			2-1	Comunicaciones
Arsenal			2-0	Berazategui
 
 
Round 23				
[Jan 31, 1987]
Defensores de Belgrano	1-0	Berazategui
Comunicaciones		0-1	Arsenal
Estudiantes BA		2-2	Atlanta
Deportivo Merlo		1-0	El Porvenir
Argentino (Rosario)	2-2	San Miguel
Almirante Brown		0-2	Villa Dálmine
Nueva Chicago		1-2	Deportivo Morón
Sportivo Dock Sud	1-1	Almagro
Quilmes			1-2	All Boys
 
 
Round 24				
[Feb 7]
All Boys		3-1	Defensores de Belgrano
Almagro			0-4	Quilmes
Deportivo Morón		1-0	Sportivo Dock Sud
Villa Dálmine		1-1	Nueva Chicago
San Miguel		2-1	Almirante Brown
El Porvenir		1-0	Argentino (Rosario)
Atlanta			2-1	Deportivo Merlo
Arsenal			2-3	Estudiantes BA
Berazategui		2-0	Comunicaciones
 
 
Round 25				
[Feb 14]
Defensores de Belgrano	0-2	Comunicaciones
Estudiantes BA		2-0	Berazategui
Deportivo Merlo		2-3	Arsenal
Argentino (Rosario)	1-1	Atlanta
Almirante Brown		2-0	El Porvenir
Nueva Chicago		2-0	San Miguel
Sportivo Dock Sud	1-2	Villa Dálmine
Quilmes			3-3	Deportivo Morón
All Boys		0-0	Almagro
 
 
Round 26				
[Feb 21]
Almagro			5-1	Defensores de Belgrano
Deportivo Morón		3-0	All Boys
Villa Dálmine		0-3	Quilmes
San Miguel		2-1	Sportivo Dock Sud
El Porvenir		1-0	Nueva Chicago
Atlanta			1-0	Almirante Brown
Arsenal			4-0	Argentino (Rosario)
Berazategui		3-0	Deportivo Merlo
Comunicaciones		2-2	Estudiantes BA
 
 
Round 27				
[Feb 28]
Defensores de Belgrano	0-2	Estudiantes BA
Deportivo Merlo		3-1	Comunicaciones
Argentino (Rosario)	4-1	Berazategui
Almirante Brown		3-0	Arsenal
Nueva Chicago		4-1	Atlanta
Sportivo Dock Sud	0-1	El Porvenir
Quilmes			4-0	San Miguel
All Boys		0-1	Villa Dálmine
Almagro			2-1	Deportivo Morón
 
 
Round 28				
[Mar 7]
Deportivo Morón		1-1	Defensores de Belgrano
Villa Dálmine		0-1	Almagro
San Miguel		4-2	All Boys
El Porvenir		0-0	Quilmes
Atlanta			1-0	Sportivo Dock Sud
Arsenal			2-5	Nueva Chicago
Berazategui		1-2	Almirante Brown
Comunicaciones		0-1	Argentino (Rosario)
Estudiantes BA		2-0	Deportivo Merlo
 
 
Round 29				
[Mar 15]
Defensores de Belgrano	2-1	Deportivo Merlo
Argentino (Rosario)	0-3	Estudiantes BA
Almirante Brown		5-0	Comunicaciones
Nueva Chicago		6-3	Berazategui
Sportivo Dock Sud	0-2	Arsenal
Quilmes			2-0	Atlanta
All Boys		0-1	El Porvenir
Almagro			2-1	San Miguel
Deportivo Morón		2-2	Villa Dálmine
 
 
Round 30				
[Mar 22]
Villa Dálmine		2-1	Defensores de Belgrano
San Miguel		0-0	Deportivo Morón
El Porvenir		0-0	Almagro
Atlanta			0-4	All Boys
Arsenal			0-1	Quilmes
Berazategui		3-2	Sportivo Dock Sud
Comunicaciones		1-1	Nueva Chicago
Estudiantes BA		0-1	Almirante Brown
Deportivo Merlo		2-1	Argentino (Rosario)
 
 
Round 31				
[Mar 28]
Defensores de Belgrano	2-1	Argentino (Rosario)
Almirante Brown		3-0	Deportivo Merlo
Nueva Chicago		0-0	Estudiantes BA
Sportivo Dock Sud	0-2	Comunicaciones
Quilmes			2-3	Berazategui
All Boys		0-0	Arsenal
Almagro			1-1	Atlanta
Deportivo Morón		2-1	El Porvenir
Villa Dálmine		1-0	San Miguel
 
 
Round 32				
[Apr 4]
San Miguel		2-0	Defensores de Belgrano
El Porvenir		1-2	Villa Dálmine
Atlanta			0-1	Deportivo Morón
Arsenal			0-0	Almagro
Berazategui		2-0	All Boys
Comunicaciones		0-1	Quilmes
Estudiantes BA		6-0	Sportivo Dock Sud
Deportivo Merlo		0-0	Nueva Chicago
Argentino (Rosario)	0-1	Almirante Brown
 
 
Round 33				
[Apr 14]
Defensores de Belgrano	1-1	Almirante Brown
Nueva Chicago		6-2	Argentino (Rosario)
Sportivo Dock Sud	0-2	Deportivo Merlo
Quilmes			3-0	Estudiantes BA
All Boys		3-0	Comunicaciones
Almagro			4-0	Berazategui
Deportivo Morón		1-1	Arsenal
Villa Dálmine		2-0	Atlanta
San Miguel		4-1	El Porvenir
 
 
Round 34				
[Apr 18]
El Porvenir		2-2	Defensores de Belgrano
Atlanta			1-4	San Miguel
Arsenal			3-1	Villa Dálmine
Berazategui		3-3	Deportivo Morón
Comunicaciones		0-2	Almagro
Estudiantes BA		3-1	All Boys
Deportivo Merlo		0-2	Quilmes					[Suspended in 76'; not continued][Later Quilmes lost points]
Argentino (Rosario)	4-2	Sportivo Dock Sud
Almirante Brown		2-1	Nueva Chicago
 
 
 
 
Table:		
 
No. Team 			      G   W   D   L  Gf  Ga   P
----------------------------------------------------------------
 1. Quilmes			     34  20   8   6  60  21  48  [Promoted to Second Division]
----------------------------------------------------------------
 2. Almirante Brown		     34  19   7   8  55  31  45  [Qualified Torneo Zonal Sureste]
 3. Estudiantes BA                   34  17  10   7  57  34  44  [Qualified Torneo Zonal Noroeste]
 4. Arsenal			     34  18   8   8  52  34  44  [Qualified Torneo Zonal Noroeste]
 5. Villa Dálmine		     34  17   9   8  50  28  43  [Qualified Torneo Zonal Sureste]
----------------------------------------------------------------
 6. Deportivo Morón   		     34  12  17   5  44  34  41
 7. Almagro			     34  15  11   8  43  33  41
 8. Nueva Chicago		     34  15  10   9  65  48  40
 9. San Miguel			     34  14  12   8  46  34  40
10. Deportivo Merlo		     34  11  10  13  35  43  32
11. El Porvenir			     34  11   9  14  29  29  31
12. All Boys			     34   9  13  12  39  42  31
13. Defensores de Belgrano           34   9  12  13  43  55  30
14. Atlanta			     34  10  10  14  31  46  30
15. Berazategui			     34   7  12  15  36  57  26
16. Argentino de Rosario	     34   6  10  18  29  49  22
----------------------------------------------------------------
17. Comunicaciones		     34   2   8  24  18  59  12  [Relegated; worst average]
18. Sportivo Dock Sud		     34   3   6  25  16  71  12  [Relegated; worst average]
 
 
 
 
 
 
Relegation Table: 
    
    Teams              		84   85   Ap86  86/87  Pts.   MP.  Average  
----------------------------------------------------------------------------
 1. Arsenal			--   --	   --	 44     44    34    1,294
 2. Almagro			--   --	   --	 41     41    34    1,206 
 3. San Miguel			--   49	   16	 40    105    94    1,117
 4. Estudiantes BA              40   45	   18	 44    147   136    1,081
 5. Defensores de Belgrano      55   46	   14	 30    145   136    1,066
 6. Quilmes			38   47	   11	 48    144   136    1,056  
 7. Villa Dálmine		--   42	   14	 43     99    94    1,053
 8. Nueva Chicago		46   41	   16	 40    143   136    1,051
 9. Deportivo Morón   		44   37	   19	 41    141   136    1,037
10. Atlanta			--   47	   19	 30     96    94    1,021
11. Almirante Brown		39   30	   17    45    131   136    0,963
12. Deportivo Merlo		--   --	   --	 32     32    34    0,941 
13. All Boys			34   40	   15	 31    120   136    0,882
14. El Porvenir			35   35	   17    31    118   136    0,868
15. Argentino de Rosario	47   34	    8	 22    111   136    0,816
16. Berazategui			--   --    --	 26     26    34    0,765 
----------------------------------------------------------------------------
17. Comunicaciones		--   --	   --	 12     12    34    0,353  [Relegated]   
18. Sportivo Dock Sud		--   --	   --	 12     12    34    0,353  [Relegated] 
 
 
 
 
 
 
 
 
TORNEO ZONAL NOROESTE
 
 
Quarterfinals:
 
First leg:
[May 10]
San Martín (Tucumán)             2-2     Arsenal                   	   
Sarmiento (Resistencia)          0-0     Gimnasia y Esgrima (Mendoza)
Independiente Rivadavia (Mza)    4-3     Atlético Sauce (Colón ER)
Estudiantes (Buenos Aires)       1-2     Atlético Tucumán
 
 
Second leg:
[May 17]
Arsenal		       		 2-0     San Martín (Tucumán)
Gimnasia y Esgrima (Mendoza)  [6]0-0[7]  Sarmiento (Resistencia)
Atlético Sauce (Colón ER)   	 2-0     Independiente Rivadavia (Mendoza)
Atlético Tucumán                 0-0     Estudiantes (Buenos Aires)         
 
 
Semifinals:
 
 
First leg:
[May 24]
Arsenal                    	 2-1     Sarmiento (Resistencia)
Atlético Sauce (Colón ER)        0-2     Atlético Tucumán
 
Second leg:
[May 31]
Sarmiento (Resistencia)          3-1     Arsenal 
Atlético Tucumán                 4-2     Atlético Sauce (Colón ER)
 
 
 
Final:
 
 
First leg:
[Jun 7]
Sarmiento (Resistencia)          2-3     Atlético Tucumán
 
Second leg:
[Jun 14]
Atlético Tucumán                 2-0     Sarmiento (Resistencia)
 
 
.Note: Atlético Tucumán promoted to Nacional B.
 
 
 
 
 
 
TORNEO ZONAL SURESTE
 
 
Quarterfinals:
 
First leg:
[May 10]
Villa Dálmine                	2-1     Estudiantes (Río IV)
Deportivo Roca (Río Negro)      1-0     Argentino Oeste (San Nicolás)
Almirante Brown                 3-2     Atlético Colegiales (San Luis)
Racing (Trelew)                 1-3     Universitario (Tandil)
 
 
Second leg:
[May 17]
Estudiantes (Río IV)            0-0     Villa Dálmine             	  
Argentino Oeste (San Nicolás)[5]1-0[4]  Deportivo Roca (Río Negro)
Atlético Colegiales (SL)     [6]2-1[7]  Almirante Brown          	  
Universitario (Tandil)          1-0     Racing (Trelew)  
 
 
 
Semifinals:
 
First leg:
[May 24]
Villa Dálmine                   1-0     Argentino Oeste (San Nicolás)
Almirante Brown                 1-1     Universitario (Tandil)
            
Second leg:
[May 31]
Argentino Oeste (San Nicolás)[5]1-0[6]  Villa Dálmine  
Universitario (Tandil)          1-3     Almirante Brown
 
 
 
Final:
 
First leg:
[Jun 7]
Villa Dálmine                   1-3     Almirante Brown 
 
Second leg:
[Jun 14]
Almirante Brown                 1-1     Villa Dálmine
 
 
 
.Note: Almirante Brown promoted to Nacional B.
 
 






Author: Pablo  Ciullini (P_A_Ciullini@hotmail.com)
Last updated: 2 Nov 2012

(C) Copyright Pablo Ciullini and RSSSF 2012
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 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,359,952 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0019
Controller Execution Time ( Home / Category )  0.1000
Total Execution Time  0.1020
  CADENA URL  
/primera_b_metropolitana1987
  GET DATOS  
$_GET['/primera_b_metropolitana1987']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (38)  
0.0018  SELECT type FROM routes WHERE alias = 'primera_b_metropolitana1987'
0.0038  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 = 1987 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=5350
0.0019  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 = 33825 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0028  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.0025  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='2024' WHERE c.parentId=206 GROUP BY c.id ORDER BY c.order_id ASC
0.0018  SELECT type,rule FROM rules WHERE categoryId = 206 ORDER BY type = 'tables_draw' DESC,type != 'extra' DESC, `order` ASC
0.0019  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-03-28 19:21: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-03-28 19:21: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=4 AND last_update > '2024-03-28 19:21: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=3 AND last_update > '2024-03-28 19:21:52' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0023  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 = 1987 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=0 DESC LIMIT 1
0.0018  SELECT e.action, count(e.action) as total, e.player_id FROM events1987 e WHERE e.league_id IN (33825) 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.0018  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 (33825) 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 events1987 e WHERE e.league_id IN (33825) AND (e.action IN (4,5) ) GROUP BY e.player_id ORDER BY total DESC, e.player_id ASC LIMIT 20
0.0018  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 (33825) 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 events1987 e WHERE e.league_id IN (33825) AND (e.action IN (3,4) ) GROUP BY e.player_id ORDER BY total DESC, e.player_id ASC LIMIT 20
0.0018  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 (33825) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN () ORDER BY rp.in_squad = 1 DESC
0.0022  SELECT e.action, count(e.action) as total, e.player_id FROM events1987 e WHERE e.league_id IN (33825) AND (e.action IN (22) ) GROUP BY e.player_id ORDER BY total DESC, e.player_id ASC LIMIT 20
0.0021  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 (33825) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN () ORDER BY rp.in_squad = 1 DESC
0.0022  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 = 33825 AND rp.lineup > 0 ORDER BY rp.lineup DESC,p.pod DESC LIMIT 20
0.0019  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 = 33825 AND rp.events > 0 ORDER BY rp.events DESC,p.pod DESC LIMIT 20
0.0018  SELECT max(l.year) as max_year, min(l.year) as min_year FROM leagues l WHERE categoryID = 206 GROUP BY l.categoryId
0.0018  SELECT l.year FROM leagues AS l WHERE (l.group_code =0 OR l.total_num_tablesR>=1 OR l.total_teamsR >=1 OR l.text_mode != 0) AND l.categoryId=206 GROUP BY l.year ORDER BY l.year DESC
0.0023  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=33825 AND rel.round=18
0.0021  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 = 33825 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 = 33825 AND esl.points > 0
0.0020  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-27" AND c.`active`= 1 and c.comment_id is null and c.lang = 1 AND l.`id` = 33825 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-02-27" AND c.`active`= 1 and comment_id is null and c.lang = 1 AND l.`id` = 33825
0.0022  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 `calendars1987` 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` = 33825 AND c.`round` = 18 ORDER BY shedule ASC LIMIT 200
0.0017  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 `events1987` e INNER JOIN calendars1987 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 = 33825 ORDER BY total DESC LIMIT 40
0.0019  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 `events1987` e INNER JOIN calendars1987 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 = 33825 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 `tables1987` 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 = 33825 AND t.round = 16 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 `tables1987` 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 = 33825 AND t.round = 18 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-03-28 00:00:00' AND c.`shedule` < '2024-04-01 23:59:59' AND l.id = 33825 ORDER BY c.shedule ASC, fcoef DESC LIMIT 5
0.0021  SELECT data1, data2 FROM services_tags WHERE categoryId=206
0.0021  SELECT l.year,l.group_code FROM leagues_besoccer l WHERE l.categoryId = 206 AND l.year = 1987 ORDER BY l.group_code ASC
0.0021  SELECT group_code, extraName from `leagues` WHERE categoryId=206 AND year=1987