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 B 

 

 
 
 
 
 
Table: 
---------------------------------------------------------------------------------------
						         Home	   Away
No. Team 			      G   W   D   L    W  D  L   W  D  L   Gf  Ga   P
---------------------------------------------------------------------------------------
 1. Atlanta         		     34	 22   7	  5   13  2  2   9  5  3   70  38   51	[Promoted to First Division]
---------------------------------------------------------------------------------------
 2. Central Córdoba (Rosario)	     34	 19   6	  9   13  4  0   6  2  9   96  48   44		
 3. Banfield         		     34	 20   2	 12   12  1  4   8  1  8   81  55   42		
 4. Sarmiento (Junín)  		     34	 17   7	 10   10  4  3   7  3  7   70  51   41		
 5. Temperley           	     34	 16   8	 10   12  2  3   4  6  7   61  59   40		
 6. Colón (Santa Fe)           	     34	 16   5	 13   11  4  2   5  1 11   54  54   37		
 7. Platense            	     34	 14   8	 12    9  5  3   5  3  9   72  59   36		
 8. Unión (Santa Fe)		     34	 13   9	 12   10  5  2   3  4 10   68  55   35		
 9. All Boys             	     34	 11  11	 12    8  4  5   3  7  7   60  64   33		
10. Excursionistas       	     34	 11   9  14    9  4  4   2  5 10   56  72   31		
11. Almagro           		     34	 12   7	 15    6  4  7   6  3  8   56  74   31		
12. Nueva Chicago        	     34	 10  10	 14    7  6  4   3  4 10   61  69   30		
13. Quilmes            		     34	  8  13	 13    7  6  4   1  7  9   58  64   29		
14. El Porvenir        		     34	 11   7	 16    7  4  6   4  3 10   61  71   29		
15. Argentino de Quilmes	     34	 11   7	 16   10  3  4   1  3 13   54  82   29		
16. Talleres (RE)     		     34	 11   6	 17    8  3  6   3  3 11   57  57   28		
17. Sportivo Dock Sud		     34	  9   9	 16    4  4  9   5  5  7   56  67   27		
---------------------------------------------------------------------------------------
18. Colegiales          	     34	  7   5	 22    4  3 10   3  2 12   42  94   19  [Relegated]
 
 
 
 
Round 1
[Apr 14]			
Almagro			2-3	Sportivo Dock Sud
Talleres (RE)		2-1	Quilmes
Temperley		3-2	Banfield
Argentino de Quilmes	1-2	El Porvenir
Nueva Chicago		2-2	Colegiales
Atlanta			3-2	Unión (Santa Fe)
Excursionistas		2-1	Central Córdoba (Ros.)
[Apr 15]
Sarmiento (Junín)	3-3	Platense
Colón (Santa Fe)	2-1	All Boys

 
Round 2	
[Apr 21]	
Excursionistas		2-3	Sarmiento (Junín)
Central Córdoba (Ros.)	1-1	Atlanta
Colegiales		4-3	Argentino de Quilmes
El Porvenir		1-1	Temperley
Banfield		3-0	Talleres (RE)
Quilmes			1-3	Almagro
Sportivo Dock Sud	0-0	Colón (Santa Fe)
All Boys		3-1	Platense
[Apr 22]
Unión (Santa Fe)	2-2	Nueva Chicago
 
 
Round 3
[Apr 29]		
Platense		3-0	Sportivo Dock Sud
Almagro			2-3	Banfield
Talleres (RE)		2-1	El Porvenir
Temperley		1-0	Colegiales
Argentino de Quilmes	1-2	Unión (Santa Fe)
Nueva Chicago		1-1	Central Córdoba (Ros.)
Atlanta			2-2	Excursionistas
[Apr 30]
Sarmiento (Junín)	1-1	All Boys
Colón (Santa Fe)	2-2	Quilmes
 
 
Round 4
[May 6]			
Atlanta			2-4	Sarmiento (Junín)
Excursionistas		4-1	Nueva Chicago
Central Córdoba (Ros.)	5-1	Argentino de Quilmes
Colegiales		1-1	Talleres (RE)
El Porvenir		1-0	Almagro
Banfield		5-0	Colón (Santa Fe)
Quilmes			2-3	Platense
Sportivo Dock Sud	0-0	All Boys
[May 7]
Unión (Santa Fe)	0-0	Temperley
 
 
Round 5
[May 13]			
All Boys		1-0	Quilmes
Platense		1-2	Banfield
Almagro			3-2	Colegiales
Talleres (RE)		1-1	Unión (Santa Fe)
Temperley		2-0	Central Córdoba (Ros.)
Argentino de Quilmes	4-3	Excursionistas
Nueva Chicago		0-0	Atlanta
[May 14]
Sarmiento (Junín)	1-1	Sportivo Dock Sud
Colón (Santa Fe)	3-1	El Porvenir
 
 
Round 6
[May 20]			
Nueva Chicago		1-0	Sarmiento (Junín)
Atlanta			3-1	Argentino de Quilmes
Excursionistas		2-2	Temperley
Central Córdoba (Ros.)	3-1	Talleres (RE)
Colegiales		0-1	Colón (Santa Fe)
El Porvenir		2-2	Platense
Banfield		1-2	All Boys
Quilmes			3-3	Sportivo Dock Sud
[May 21]
Unión (Santa Fe)	3-1	Almagro
 
 
Round 7
[May 27]			
Sportivo Dock Sud	1-2	Banfield
All Boys		3-2	El Porvenir
Platense		1-1	Colegiales
Almagro			1-2	Central Córdoba (Ros.)
Talleres (RE)		4-0	Excursionistas
Temperley		0-2	Atlanta
Argentino de Quilmes	2-2	Nueva Chicago
[May 28]
Sarmiento (Junín)	2-1	Quilmes
Colón (Santa Fe)	2-0	Unión (Santa Fe)
 
 
Round 8
[Jun 2]
Excursionistas		4-1	Almagro
Unión (Santa Fe)	5-1	Platense
Banfield		3-2	Quilmes
[Jun 9]			
Argentino de Quilmes	1-3	Sarmiento (Junín)
Nueva Chicago		2-3	Temperley
Atlanta			5-1	Talleres (RE)
Central Córdoba (Ros.)	5-0	Colón (Santa Fe)
Colegiales		0-1	All Boys
El Porvenir		1-3	Sportivo Dock Sud
 
 
Round 9
[Jun 16]			
Quilmes			2-0	El Porvenir
Sportivo Dock Sud	1-2	Colegiales
All Boys		0-1	Unión (Santa Fe)
Platense		2-2	Central Córdoba (Ros.)
Almagro			2-2	Atlanta
Talleres (RE)		2-1	Nueva Chicago
Temperley		4-2	Argentino de Quilmes
[Jun 17]
Sarmiento (Junín)	4-0	Banfield
Colón (Santa Fe)	1-1	Excursionistas
 
 
Round 10
[Jun 23]			
Temperley		0-0	Sarmiento (Junín)
Argentino de Quilmes	1-0	Talleres (RE)
Nueva Chicago		3-3	Almagro
Atlanta			2-1	Colón (Santa Fe)
Excursionistas		3-2	Platense
Colegiales		2-0	Quilmes
El Porvenir		1-3	Banfield
[Jun 24]
Central Córdoba (Ros.)	3-3	All Boys
Unión (Santa Fe)	3-0	Sportivo Dock Sud
 
 
Round 11
[Jun 30]			
Banfield		1-0	Colegiales
Quilmes			3-3	Unión (Santa Fe)
Sportivo Dock Sud	1-2	Central Córdoba (Ros.)
All Boys		1-1	Excursionistas
Platense		2-2	Atlanta
Almagro			3-1	Argentino de Quilmes
Talleres (RE)		2-4	Temperley
[Jul 1]
Sarmiento (Junín)	5-1	El Porvenir
Colón (Santa Fe)	3-2	Nueva Chicago
 
 
Round 12
[Jul 7]			
Talleres (RE)		0-1	Sarmiento (Junín)
Temperley		3-1	Almagro
Argentino de Quilmes	2-1	Colón (Santa Fe)
Nueva Chicago		0-3	Platense
Atlanta			2-0	All Boys
Excursionistas		2-1	Sportivo Dock Sud
Central Córdoba (Ros.)	0-0	Quilmes
Colegiales		2-4	El Porvenir
[Jul 8]
Unión (Santa Fe)	2-2	Banfield
 
 
Round 13
[Jul 14]			
El Porvenir		1-0	Unión (Santa Fe)
Banfield		2-0	Central Córdoba (Ros.)
Quilmes			1-0	Excursionistas
Sportivo Dock Sud	2-3	Atlanta
All Boys		2-2	Nueva Chicago
Platense		2-0	Argentino de Quilmes
Almagro			1-1	Talleres (RE)
[Jul 15]
Sarmiento (Junín)	3-0	Colegiales
Colón (Santa Fe)	5-1	Temperley
 
 
Round 14
[Jul 21]			
Almagro			1-5	Sarmiento (Junín)
Talleres (RE)		3-0	Colón (Santa Fe)
Temperley		1-0	Platense
Argentino de Quilmes	2-1	All Boys
Nueva Chicago		2-2	Sportivo Dock Sud
Atlanta			0-0	Quilmes
Excursionistas		2-3	Banfield
Central Córdoba (Ros.)	3-1	El Porvenir
[Jul 22]
Unión (Santa Fe)	5-0	Colegiales
 
 
Round 15
[Jul 28]		
Colegiales		1-2	Central Córdoba (Ros.)
El Porvenir		6-2	Excursionistas
Banfield		0-1	Atlanta
Quilmes			3-2	Nueva Chicago
Sportivo Dock Sud	2-3	Argentino de Quilmes
All Boys		1-0	Temperley
Platense		3-0	Talleres (RE)
[Jul 29]
Sarmiento (Junín)	3-0	Unión (Santa Fe)
Colón (Santa Fe)	1-1	Almagro
 
 
Round 16
[Aug 4]			
Almagro			0-7	Platense
Talleres (RE)		3-4	All Boys
Temperley		3-1	Sportivo Dock Sud
Argentino de Quilmes	3-3	Quilmes
Nueva Chicago		1-2	Banfield
Atlanta			3-0	El Porvenir
Excursionistas		3-1	Colegiales
Central Córdoba (Ros.)	5-1	Unión (Santa Fe)
[Aug 5]
Colón (Santa Fe)	2-1	Sarmiento (Junín)
 
 
Round 17
[Aug 11]		
Colegiales		1-2	Atlanta
El Porvenir		1-0	Nueva Chicago
Banfield		3-0	Argentino de Quilmes
Quilmes			1-1	Temperley
Sportivo Dock Sud	1-0	Talleres (RE)
All Boys		0-4	Almagro
Platense		1-0	Colón (Santa Fe)
[Aug 12]
Sarmiento (Junín)	2-0	Central Córdoba (Ros.)
Unión (Santa Fe)	1-1	Excursionistas
 
 
Round 18
[Aug 18]			
Platense		2-2	Sarmiento (Junín)
All Boys		1-3	Colón (Santa Fe)
Sportivo Dock Sud	1-2	Almagro
Quilmes			2-0	Talleres (RE)
Banfield		0-0	Temperley
El Porvenir		3-1	Argentino de Quilmes
Colegiales		4-2	Nueva Chicago
Central Córdoba (Ros.)	3-1	Excursionistas
[Aug 19]
Unión (Santa Fe)	1-2	Atlanta
 
 
Round 19
[Aug 25]			
Atlanta			2-1	Central Córdoba (Ros.)
Nueva Chicago		2-1	Unión (Santa Fe)
Argentino de Quilmes	2-1	Colegiales
Temperley		1-2	El Porvenir
Talleres (RE)		0-1	Banfield
Almagro			0-1	Quilmes
Platense		3-1	All Boys
[Aug 26]
Sarmiento (Junín)	0-0	Excursionistas
Colón (Santa Fe)	3-0	Sportivo Dock Sud

 
Round 20
[Sep 1]		
All Boys		2-0	Sarmiento (Junín)
Quilmes			1-0	Colón (Santa Fe)
Banfield		5-2	Almagro
El Porvenir		2-0	Talleres (RE)
Colegiales		4-5	Temperley
Central Córdoba (Ros.)	5-1	Nueva Chicago
Excursionistas		1-0	Atlanta
[Sep 2]
Unión (Santa Fe)	2-1	Argentino de Quilmes
[Sep 11]
Sportivo Dock Sud	1-0	Platense

 
Round 21
[Sep 8]			
Nueva Chicago		2-0	Excursionistas
Argentino de Quilmes	3-2	Central Córdoba (Ros.)
Temperley		0-0	Unión (Santa Fe)		[Suspended in 50'; continued Sep 9]	
Talleres (RE)		8-2	Colegiales
Almagro			0-0	El Porvenir
Platense		3-2	Quilmes
All Boys		4-5	Sportivo Dock Sud
[Sep 9]
Sarmiento (Junín)	1-0	Atlanta
Colón (Santa Fe)	1-0	Banfield
Temperley		2-3	Unión (Santa Fe)
 
 
Round 22
[Sep 15]		
Sportivo Dock Sud	1-4	Sarmiento (Junín)
Quilmes			2-2	All Boys
Banfield		0-4	Platense
El Porvenir		1-2	Colón (Santa Fe)
Colegiales		0-1	Almagro
Central Córdoba (Ros.)	6-2	Temperley
Excursionistas		0-0	Argentino de Quilmes
Atlanta			5-2	Nueva Chicago
[Sep 16]
Unión (Santa Fe)	1-0	Talleres (RE)

 
Round 23
[Sep 22]			
Argentino de Quilmes	1-3	Atlanta
Temperley		3-1	Excursionistas
Talleres (RE)		1-2	Central Córdoba (Ros.)
Almagro			2-2	Unión (Santa Fe)
Platense		1-1	El Porvenir
All Boys		1-0	Banfield
Sportivo Dock Sud	3-3	Quilmes
[Sep 23]
Sarmiento (Junín)	1-2	Nueva Chicago
Colón (Santa Fe)	2-0	Colegiales

 
Round 24
[Sep 29]
Central Córdoba (Ros.)	6-1	Almagro
[Sep 30]	
Unión (Santa Fe)	1-2	Colón (Santa Fe)
[Oct 6]
Quilmes			3-3	Sarmiento (Junín)
Banfield		2-3	Sportivo Dock Sud
El Porvenir		2-2	All Boys
Colegiales		1-1	Platense
Excursionistas		2-5	Talleres (RE)
Atlanta			4-0	Temperley
Nueva Chicago		5-1	Argentino de Quilmes
 
 
 
Round 25
[Oct 12]
Quilmes			2-4	Banfield
[Oct 13]
Temperley		1-1	Nueva Chicago
Talleres (RE)		2-1	Atlanta
Almagro			1-0	Excursionistas
Colón (Santa Fe)	2-5	Central Córdoba (Ros.)
Platense		2-1	Unión (Santa Fe)
All Boys		8-0	Colegiales
Sportivo Dock Sud	5-2	El Porvenir
[Oct 14]
Sarmiento (Junín)	3-1	Argentino de Quilmes
Colón (Santa Fe)	2-5	Central Córdoba (Ros.)

 
Round 26
[Oct 20]			
Banfield		6-2	Sarmiento (Junín)
El Porvenir		1-1	Quilmes
Colegiales		2-4	Sportivo Dock Sud
Central Córdoba (Ros.)	6-2	Platense
Excursionistas		4-3	Colón (Santa Fe)
Atlanta			3-0	Almagro
Nueva Chicago		1-2	Talleres (RE)
Argentino de Quilmes	0-0	Temperley
[Oct 21]
Unión (Santa Fe)	6-0	All Boys
 
 
Round 27
[Oct 28]		
Sarmiento (Junín)	2-0	Temperley
Talleres (RE)		6-0	Argentino de Quilmes
Almagro			1-2	Nueva Chicago
Colón (Santa Fe)	1-1	Atlanta
Platense		3-1	Excursionistas
All Boys		2-0	Central Córdoba (Ros.)
Sportivo Dock Sud	3-0	Unión (Santa Fe)
Quilmes			4-0	Colegiales
Banfield		5-3	El Porvenir
 
 
Round 28
[Nov 3]			
El Porvenir		8-4	Sarmiento (Junín)
Colegiales		2-1	Banfield
Central Córdoba (Ros.)	1-1	Sportivo Dock Sud
Excursionistas		2-2	All Boys
Atlanta			3-2	Platense
Nueva Chicago		2-0	Colón (Santa Fe)
Argentino de Quilmes	5-3	Almagro
Temperley		2-1	Talleres (RE)
[Nov 4]
Unión (Santa Fe)	2-0	Quilmes
 
 
Round 29
[Nov 10]			
Sarmiento (Junín)	2-0	Talleres (RE)
Almagro			3-1	Temperley
Platense		2-4	Nueva Chicago
All Boys		0-1	Atlanta
Sportivo Dock Sud	1-2	Excursionistas
Quilmes			4-1	Central Córdoba (Ros.)
Banfield		6-3	Unión (Santa Fe)
El Porvenir		0-1	Colegiales
[Nov 11]
Colón (Santa Fe)	3-0	Argentino de Quilmes

 
Round 30
[Nov 17]			
Colegiales		0-2	Sarmiento (Junín)
Central Córdoba (Ros.)	3-1	Banfield
Excursionistas		3-3	Quilmes
Atlanta			3-2	Sportivo Dock Sud
Nueva Chicago		2-2	All Boys
Argentino de Quilmes	3-2	Platense
Temperley		2-1	Colón (Santa Fe)
Talleres (RE)		1-1	Almagro
[Nov 18]
Unión (Santa Fe)	3-3	El Porvenir
 
 
Round 31
[Nov 23]
Platense		4-0	Temperley
[Nov 24]			
Sarmiento (Junín)	0-2	Almagro
All Boys		2-2	Argentino de Quilmes
Sportivo Dock Sud	0-0	Nueva Chicago
Quilmes			1-2	Atlanta
Banfield		5-0	Excursionistas
El Porvenir		0-2	Central Córdoba (Ros.)
Colegiales		3-3	Unión (Santa Fe)
[Nov 25]
Colón (Santa Fe)	0-2	Talleres (RE)

 
Round 32
[Nov 30]
Unión (Santa Fe)	1-0	Sarmiento (Junín)
[Dec 1]			
Central Córdoba (Ros.)	7-0	Colegiales
Excursionistas		2-5	El Porvenir
Atlanta			3-2	Banfield
Nueva Chicago		5-1	Quilmes
Argentino de Quilmes	1-0	Sportivo Dock Sud
Temperley		6-2	All Boys
Talleres (RE)		2-3	Platense
Almagro			3-1	Colón (Santa Fe)
 
 
 
 
Atlanta won the championship in this round with the following line- ups:
 
Atlanta:	A.Rocha; I.Fuentes, M.Etchegaray, A.Ovide; O.Clariá, R.Bettinotti,
		A.Dezorzi, O.Guenzzatti; L.Bravo, R.Fazzolari, J.Fernández.
 
Banfield:	M.Graneros; C.Arredondo, N.Buzzano, R.Sánchez; P.Rovito, A.Sklate,
		N.Boggio, R.Grazziolo; G.Albella, A.Villamor, U.Acevedo.
 
Goals:		9' Grazziolo; 47' Boggio; 63' Fernández; 76' Guenzzatti; 89' Dezorzi.
Referee:	Bert Cross.
 
 
Round 33
[Dec 6]
El Porvenir		0-2	Atlanta
[Dec 8]			
Sarmiento (Junín)	2-3	Colón (Santa Fe)
Platense		1-2	Almagro
All Boys		2-2	Talleres (RE)
Sportivo Dock Sud	1-3	Temperley
Quilmes			1-1	Argentino de Quilmes
Banfield		4-0	Nueva Chicago
Colegiales		1-3	Excursionistas
Unión (Santa Fe)	5-0	Central Córdoba (Ros.)
 
 
Round 34
[Dec 14]
Atlanta			1-3	Colegiales
[Dec 15]			
Central Córdoba (Ros.)	5-0	Sarmiento (Junín)
Excursionistas		1-0	Unión (Santa Fe)
Nueva Chicago		4-1	El Porvenir
Argentino de Quilmes	4-2	Banfield
Temperley		4-2	Quilmes
Talleres (RE)		2-2	Sportivo Dock Sud
Almagro			3-2	All Boys
[Dec 16]
Colón (Santa Fe)	3-1	Platense 
 
 
 
Table: 
---------------------------------------------------------------------------------------
						         Home	   Away
No. Team 			      G   W   D   L    W  D  L   W  D  L   Gf  Ga   P
---------------------------------------------------------------------------------------
 1. Atlanta         		     34	 22   7	  5   13  2  2   9  5  3   70  38   51	[Promoted to First Division]
---------------------------------------------------------------------------------------
 2. Central Córdoba (Rosario)	     34	 19   6	  9   13  4  0   6  2  9   96  48   44		
 3. Banfield         		     34	 20   2	 12   12  1  4   8  1  8   81  55   42		
 4. Sarmiento (Junín)  		     34	 17   7	 10   10  4  3   7  3  7   70  51   41		
 5. Temperley           	     34	 16   8	 10   12  2  3   4  6  7   61  59   40		
 6. Colón (Santa Fe)           	     34	 16   5	 13   11  4  2   5  1 11   54  54   37		
 7. Platense            	     34	 14   8	 12    9  5  3   5  3  9   72  59   36		
 8. Unión (Santa Fe)		     34	 13   9	 12   10  5  2   3  4 10   68  55   35		
 9. All Boys             	     34	 11  11	 12    8  4  5   3  7  7   60  64   33		
10. Excursionistas       	     34	 11   9  14    9  4  4   2  5 10   56  72   31		
11. Almagro           		     34	 12   7	 15    6  4  7   6  3  8   56  74   31		
12. Nueva Chicago        	     34	 10  10	 14    7  6  4   3  4 10   61  69   30		
13. Quilmes            		     34	  8  13	 13    7  6  4   1  7  9   58  64   29		
14. El Porvenir        		     34	 11   7	 16    7  4  6   4  3 10   61  71   29		
15. Argentino de Quilmes	     34	 11   7	 16   10  3  4   1  3 13   54  82   29		
16. Talleres (RE)     		     34	 11   6	 17    8  3  6   3  3 11   57  57   28		
17. Sportivo Dock Sud		     34	  9   9	 16    4  4  9   5  5  7   56  67   27		
---------------------------------------------------------------------------------------
18. Colegiales          	     34	  7   5	 22    4  3 10   3  2 12   42  94   19  [Relegated]
 

Author: Pablo Ciullini 
(P_A_Ciullini@hotmail.com)
Last updated: 28 Feb 2008

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

INFORMACIÓN

La Primera B Nacional (actualmente llamado Nacional B, o simplemente B Nacional) es el campeonato de segunda división organizado por la Asociación del Fútbol Argentino, disputado por clubes tanto directa como indirectamente afiliados a dicha asociación. Es una de las cuatro categorías profesionales en el Fútbol Argentino, junto a la Primera División, a la Primera B Metropolitana y el Torneo Argentino A.

  USO DE MEMORIA  
4,362,952 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0018
Controller Execution Time ( Home / Category )  0.4509
Total Execution Time  0.4527
  CADENA URL  
/primera_b_nacional1956
  GET DATOS  
$_GET['/primera_b_nacional1956']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (34)  
0.0105  SELECT type FROM routes WHERE alias = 'primera_b_nacional1956'
0.0214  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'primera_b_nacional' AND (l.group_code = 1 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 1956 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=1 DESC LIMIT 1
0.0108  SELECT text_es as historical_text FROM leagues_text WHERE id=5113
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 = 33507 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0111  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=192 ORDER BY l.group_code ASC
0.0105  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-04-25 16:05:43' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0105  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=2 AND last_update > '2024-04-25 16:05:43' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0105  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=4 AND last_update > '2024-04-25 16:05:43' 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=3 AND last_update > '2024-04-25 16:05:43' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0112  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'primera_b_nacional' AND (l.group_code = 0 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 1956 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=0 DESC LIMIT 1
0.0107  SELECT e.action, count(e.action) as total, e.player_id FROM events1956 e WHERE e.league_id IN (33507) 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.0109  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 (33507) 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 events1956 e WHERE e.league_id IN (33507) 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 (33507) 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 events1956 e WHERE e.league_id IN (33507) AND (e.action IN (3,4) ) 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 (33507) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN () ORDER BY rp.in_squad = 1 DESC
0.0108  SELECT e.action, count(e.action) as total, e.player_id FROM events1956 e WHERE e.league_id IN (33507) AND (e.action IN (22) ) 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 (33507) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN () ORDER BY rp.in_squad = 1 DESC
0.0109  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 = 33507 AND rp.lineup > 0 ORDER BY rp.lineup DESC,p.pod DESC LIMIT 20
0.0108  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 = 33507 AND rp.events > 0 ORDER BY rp.events DESC,p.pod DESC LIMIT 20
0.0108  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=33507 AND rel.round=34
0.0106  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 = 33507 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 = 33507 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-26" AND c.`active`= 1 and c.comment_id is null and c.lang = 1 AND l.`id` = 33507 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-26" AND c.`active`= 1 and comment_id is null and c.lang = 1 AND l.`id` = 33507
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 `calendars1956` 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` = 33507 AND c.`round` = 34 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 `events1956` e INNER JOIN calendars1956 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 = 34 AND e.real_date IS NOT NULL AND e.league_id = 33507 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 `events1956` e INNER JOIN calendars1956 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 = 33507 AND e.real_date > NOW() - INTERVAL 1 MONTH ORDER BY e.real_date DESC LIMIT 30
0.0106  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 `tables1956` 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 = 33507 AND t.round = 32 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0106  SELECT *,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables1956` 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 = 33507 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0106  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-25 00:00:00' AND c.`shedule` < '2024-04-29 23:59:59' AND l.id = 33507 ORDER BY c.shedule ASC, fcoef DESC LIMIT 5
0.0106  SELECT data1, data2 FROM services_tags WHERE categoryId=192
0.0106  SELECT l.year,l.group_code FROM leagues_besoccer l WHERE l.categoryId = 192 AND l.year = 1956 ORDER BY l.group_code ASC
0.0106  SELECT group_code, extraName from `leagues` WHERE categoryId=192 AND year=1956