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 (Primera B - Metropolitano) 1999/2000


Round 1 [Aug 21] 
Tristán Suarez 1-1 Gral. Lamadrid
Armenio        0-0 Berazategui
Brown de Adr.  2-1 Cambaceres
Argentino de Q 2-2 Alte. Brown
Estudiantes    0-0 Talleres
Atlanta        1-0 Sarmiento
Italiano       0-0 San Telmo
Colegiales     0-2 Flandria
D. de Belgrano 0-1 L.N. Alem 

Round 2 [Aug 28] 
Colegiales     0-0 Def. de Belgrano
Flandria       1-0 Atlanta
Sarmiento      2-2 Italiano       
San Telmo      1-2 Estudiantes    
Talleres       1-0 Argentino de Quilmes 
Alte. Brown    2-1 Brown de Adrogué  
Cambaceres     0-0 Armenio              [Abandoned because of incidents] (*)
Berazategui    0-0 Tristán  Suarez
Gral. Lamadrid 0-3 L.N. Alem 
(*) AFA decided that Cambaceres lose the match (0-1), and 3 pts deducted. 
    AFA decided that Armenio draw the match (0-0). 

Round 3 [Sep 4] 
D. de Belgrano 2-0 Gral. Lamadrid
L.N. Alem      1-1 Berazategui
Tristán Suarez 2-1 Cambaceres
Armenio        2-1 Alte. Brown
Brown de Adr.  0-1 Talleres
Argentino de Q 2-0 San Telmo
Estudiantes    2-0 Sarmiento
Italiano       0-0 Flandria
Atlanta        5-2 Colegiales 

Round 4 [Sep 11] 
Atlanta        1-0 Def. de Belgrano
Colegiales     0-2 Italiano
Flandria       0-0 Estudiantes  
Sarmiento      3-0 Argentino de Quilmes 
San Telmo      2-5 Brown de Adrogué  
Talleres       2-3 Armenio     
Alte. Brown    1-0 Tristán Suarez
Cambaceres     1-1 L.N. Alem
Berazategui    2-1 Gral. Lamadrid

Round 5 [Sep 18] 
D. de Belgrano 0-0 Berazategui
Gral. Lamadrid 0-1 Cambaceres         [Abandoned because of incidents]
L.N. Alem      3-1 Alte. Brown
Tristán Suarez 3-1 Talleres
Armenio        0-4 San Telmo
Brown de Adr.  4-0 Sarmiento
Argentino de Q 0-0 Flandria
Estudiantes    2-0 Colegiales     
Italiano       1-0 Atlanta

Round 6 [Sep 25] 
Italiano       0-0 Def. de Belgrano
Atlanta        2-2 Estudiantes    
Colegiales     1-3 Argentino de Quilmes 
Flandria       1-0 Brown de Adrogué  
Sarmiento      0-0 Armenio        
San Telmo      1-1 Tristán Suarez
Talleres       0-0 L.N. Alem
Alte. Brown    0-2 Gral. Lamadrid
Cambaceres     2-2 Berazategui  

Round 7 [Oct 2] 
D. de Belgrano 1-1 Cambaceres
Berazategui    4-3 Alte. Brown
Gral. Lamadrid 1-3 Talleres
L.N. Alem      0-0 San Telmo
Tristán Suarez 1-0 Sarmiento
Armenio        0-0 Flandria
Brown de Adr.  4-0 Colegiales
Argentino de Q 0-0 Atlanta   
Estudiantes    2-0 Italiano   

Round 8 [Oct 9] 
Estudiantes    1-2 Def. de Belgrano
Italiano       3-0 Argentino de Quilmes 
Atlanta        2-2 Brown de Adrogué
Colegiales     1-1 Armenio
Flandria       0-1 Tristán Suarez
Sarmiento      3-2 L.N. Alem
San Telmo      1-0 Gral. Lamadrid
Talleres       0-1 Berazategui
Alte. Brown    3-1 Cambaceres 

Round 9 [Oct 16] 
D. de Belgrano 1-0 Alte. Brown
Cambaceres     0-0 Talleres
Berazategui    0-1 San Telmo
Gral. Lamadrid 1-3 Sarmiento
L.N. Alem      0-1 Flandria
Tristán Suarez 3-0 Colegiales   
Armenio        4-2 Atlanta   
Brown de Adr.  1-0 Italiano   
Argentino de Q 0-1 Estudiantes   

Round 10 [Oct 30] 
Argentino de Q 0-0 Def. de Belgrano
Estudiantes    1-0 Brown de Adrogué  
Italiano       4-2 Armenio  
Atlanta        1-0 Tristán Suarez
Colegiales     1-1 L.N. Alem
Flandria       2-0 Gral. Lamadrid
Sarmiento      1-1 Berazategui
San Telmo      1-1 Cambaceres
Talleres       1-0 Alte. Brown

Round 11 [Nov 6]
Armenio        1-2 Estudiantes 
Berazategui    2-0 Flandria 
Tristán Suárez 2-0 Italiano 
L.N. Alem      0-1 Atlanta 
Brown (A)      1-2 Argentino de Quilmes 
Alm. Brown     2-0 San Telmo
Cambaceres     2-2 Sarmiento
Def. Belgrano  0-0 Talleres
Dep. Lamadrid  2-2 Colegiales

Round 12 [Nov 13]
Brown          1-0 Defensores de Belgrano
Argentino Q.   0-0 Armenio
Estudiantes    0-0 Tristán Suárez
Italiano       1-0 L.N. Alem
Colegiales     0-1 Berazategui
Flandria       3-1 Cambaceres
Sarmiento      2-1 Almirante Brown
Atlanta        0-0 Lamadrid
Talleres       1-0 San Telmo

Round 13 [Nov 20]
Berazategui    2-0 Atlanta
L.N. Alem      3-5 Estudiantes
Armenio        0-0 Brown de Adrogué
Tristán Suárez 1-1 Argentino de Quilmes
Alm. Brown     0-0 Flandria
Defensores     0-1 San Telmo
Cambaceres     1-3 Colegiales
Talleres       2-1 Sarmiento          [Dec 15]
Lamadrid       1-4 Italiano           [Feb 15]

Round 14 [Nov 27]
Armenio        0-0 Def. de Belgrano
Brown de Adr.  1-1 T. Suárez
Argentino de Q 1-0 L.N. Alem
Estudiantes    1-1 Lamadrid
Italiano       0-1 Berazategui
Atlanta        3-0 Cambaceres
Colegiales     3-1 Alte. Brown
Flandria       0-0 Talleres
Sarmiento      0-1 San Telmo

Round 15 [Dec 4]
Berazategui    0-1 Estudiantes
Tristán Suárez 1-0 Armenio
Def. de Belgr. 0-2 Sarmiento
San Telmo      3-1 Flandria
Talleres       0-2 Colegiales
Alte. Brown    1-0 Atlanta
L.N. Alem      2-1 Brown de Adrogué
Cambaceres     2-1 Italiano
Lamadrid       3-4 Argentino de Quilmes  [Feb 22]

Round 16 [Dec 11]          
Armenio        2-1 L.N. Alem
Brown de Adr.  3-1 Gral. Lamadrid
Argentino de Q 0-0 Berazategui
Estudiantes    2-2 Cambaceres
Italiano       0-0 Alte. Brown
T. Suárez      0-0 Def. de Belgrano
Colegiales     1-0 San Telmo
Flandria       1-0 Sarmiento
Atlanta        1-1 Talleres        [Dec 21]

Round 17 [Dec 17-18] 
Alte. Brown    2-2 Estudiantes
Berazategui    2-3 Brown (Adrogué)
D. de Belgrano 0-0 Flandria
Talleres       1-2 Italiano
Cambaceres     3-2 Argentino de Quilmes
L.N. Alem      3-1 Tristán Suárez
Sarmiento      0-3 Colegiales
Armenio        3-0 Gral. Lamadrid
San Telmo      0-3 Atlanta          [Feb 15]

Round 18 [Feb 5] 
Alte. Brown    1-1 Argentino de Quilmes
Berazategui    2-1 Deportivo Armenio
Flandria       1-1 Colegiales
Talleres       1-1 Estudiantes
Cambaceres     0-1 Brown (Adrogué)   
L.N. Alem      0-1 Def. de Belgrano
Sarmiento      3-0 Atlanta    
Gral. Lamadrid 0-1 Tristán Suárez
San Telmo      1-0 Dep. Italiano

Round 19 [Feb 12] 
Brown de Adr.  1-0 Almirante Brown
Estudiantes    1-2 San Telmo      
D. de Belgrano 1-2 Colegiales
Dep. Italiano  1-1 Sarmiento
A. de Quilmes  1-2 Talleres
L.N. Alem      0-0 Gral. Lamadrid
Tristán Suárez 4-1 Berazategui
Dep. Armenio   0-0 Def. de Cambaceres
Atlanta        0-0 Flandria  

Round 20 [Feb 19] 
San Telmo      1-0 Argentino de Quilmes
Gral. Lamadrid 0-3 Def. de Belgrano
Alte. Brown    2-1 Dep. Armenio
Talleres       0-1 Brown (Adrogué)
Berazategui    1-0 L.N. Alem
Sarmiento      1-1 Estudiantes   
Flandria       1-1 Dep. Italiano
Cambaceres     1-1 Tristán Suárez    
Colegiales     1-1 Atlanta

Round 21 [Feb 26] 
D. de Belgrano 2-2 Atlanta  
Dep. Italiano  1-1 Colegiales 
Estudiantes    1-3 Flandria  
A. de Quilmes  3-1 Sarmiento
Brown (Adr.)   1-1 San Telmo
Dep. Armenio   1-1 Talleres  
Tristán Suárez 2-2 Almirante Brown
L.N. Alem      2-2 Def. de Cambaceres
Gral. Lamadrid 1-1 Berazategui 

Round 22 [Mar 4]
Berazategui    0-2 Def. de Belgrano  
Cambaceres     4-2 Gral. Lamadrid 
Alte. Brown    3-1 L.N. Alem  
Talleres       1-3 Tristán Suárez 
San Telmo      1-0 Deportivo Armenio
Sarmiento      0-0 Brown (Adrogué)
Flandria       0-0 Argentino de Quilmes
Colegiales     1-0 Estudiantes
Atlanta        0-1 Deportivo Italiano

Round 23 [Mar 11]
D. de Belgrano 1-1 Deportivo Italiano
Estudiantes    2-0 Atlanta 
A. de Quilmes  3-2 Colegiales
Brown (Adr.)   3-1 Flandria
Dep. Armenio   0-1 Sarmiento 
Tristán Suárez 0-1 San Telmo
Gral. Lamadrid 0-2 Almirante Brown
Berazategui    1-4 Def. de Cambaceres
L.N. Alem      0-3 Talleres            [Mar 22]

Round 24 [Mar 18]
Cambaceres     4-1 Def. de Belgrano    
Alte. Brown    0-0 Berazategui     
Talleres       1-2 Gral. Lamadrid
San Telmo      2-1 L.N. Alem      
Sarmiento      1-1 Tristán Suárez   
Flandria       2-0 Deportivo Armenio
Colegiales     1-3 Brown (Adrogué)
Atlanta        0-0 Argentino de Quilmes
Dep. Italiano  2-0 Estudiantes     

Round 25 [Mar 25]
Arg. de Quimes 2-1 Deportivo Italiano
D. de Belgrano 0-0 Estudiantes     
Brown (Adr.)   1-1 Atlanta
Dep. Armenio   1-2 Colegiales 
Tristán Suárez 1-4 Flandria         
Gral. Lamadrid 1-3 San Telmo
Berazategui    0-0 Talleres
Cambaceres     0-1 Almirante Brown     
L.N. Alem      0-4 Sarmiento        [Apr 4] 

Round 26 [Apr 1-2]
Alte. Brown    0-2 Def. de Belgrano
Talleres       1-0 Def. de Cambaceres
Sarmiento      1-1 Gral. Lamadrid   
Flandria       4-0 L.N. Alem
Colegiales     2-2 Tristán Suárez
Atlanta        1-0 Deportivo Armenio
Estudiantes    1-0 Argentino de Quilmes
Dep. Italiano  3-2 Brown (Adrogué)     
San Telmo      0-0 Berazategui     

Round 27 [Apr 8-9]
D. de Belgrano 0-0 Argentino de Quilmes
Brown (Adr.)   2-3 Estudiantes
Dep. Armenio   0-1 Deportivo Italiano
Tristán Suárez 1-3 Atlanta
L.N. Alem      1-5 Colegiales
Gral. Lamadrid 0-0 Flandria
Berazategui    2-5 Sarmiento
Cambaceres     2-1 San Telmo     
Alte. Brown    2-0 Talleres    

Round 28 [Apr 15-16]
Estudiantes    3-0 Deportivo Armenio
Flandria       4-0 Berazategui
Dep. Italiano  3-0 Tristán Suárez
A. de Quilmes  0-2 Brown (Adrogué)
San Telmo      2-1 Almirante Brown
Sarmiento      0-1 Def. de Cambaceres
Talleres       0-3 Def. de Belgrano
Colegiales     4-2 General Lamadrid
Atlanta        2-1 L.N. Alem          [Apr 18] 

Round 29 [Apr 22-23]
Dep. Armenio   1-2 Argentino de Quilmes
Tristán Suárez 1-1 Estudiantes
Alte. Brown    0-1 Sarmiento
Talleres       0-0 San Telmo
D. de Belgrano 0-0 Brown (Adrogué)
L.N. Alem      1-1 Deportivo Italiano
Berazategui    2-3 Colegiales
Cambaceres     4-3 Flandria
Gral. Lamadrid 1-2 Atlanta 

Round 30 [May 12-13]
San Telmo      0-1 Defensores de Belgrano
Estudiantes    3-0 L.N. Alem
Atlanta        1-1 Berazategui
Brown (Adr.)   1-1 Deportivo Armenio
A. de Quilmes  0-3 Tristán Suárez
Flandria       1-1 Almirante Brown
Colegiales     3-4 Def. de Cambaceres
Sarmiento      3-2 Talleres
Dep. Italiano  2-1 Gral. Lamadrid 

Round 31 [May 20]
D. de Belgrano 0-0 Deportivo Armenio
Tristán Suárez 2-3 Brown (Adrogué)
L.N. Alem      2-3 Argentino de Quilmes 
Berazategui    0-2 Deportivo Italiano
Cambaceres     3-2 Atlanta
Alte. Brown    5-3 Colegiales
Talleres       0-1 Flandria
Gral. Lamadrid 1-4 Estudiantes       
San Telmo      1-1 Sarmiento     [May 23] 

Round 32 [May 27]
Sarmiento      2-1 Defensores de Belgrano
Flandria       0-1 San Telmo
Colegiales     1-0 Talleres
Atlanta        1-2 Almirante Brown
Dep. Italiano  3-0 Def. de Cambaceres
Estudiantes    0-2 Berazategui
A. de Quilmes  3-0 General Lamadrid
Brown (Adr.)   3-1 L.N. Alem
Dep. Armenio   1-0 Tristán Suárez 

Round 33 [Jun 3]
D. de Belgrano 2-2 Tristan Suárez   
Gral. Lamadrid 2-2 Brown   
Berazategui    2-0 Argentino de Quilmes   
Cambaceres     1-2 Estudiantes   
Alte. Brown    0-0 Deportivo Italiano   
Talleres       0-1 Atlanta   
San Telmo      0-1 Colegiales   
Sarmiento      1-1 Flandria   
L.N. Alem      awd Deportivo Armenio  [AFA decided that L.N. Alem lose the match
  [Deportivo Armenio won the match]    because did not pay the police security]
 
Round 34 [Jun 10]
Colegiales     2-1 Sarmiento   
Atlanta        1-0 San Telmo   
Dep. Italiano  3-0 Talleres   
Estudiantes    4-0 Almirante Brown   
A. de Quilmes  1-0 Cambaceres   
Brown (Adr.)   0-0 Berazategui   
Dep. Armenio   3-0 General Lamadrid   
Tristan Suárez 7-3 L.N. Alem
Flandria       0-1 Defensores de Belgrano   [Jun 13]

 
Table

 1.Brown (Adrogué)          34 17  9  8 56-34 60  Semifinals Promotion Playoff
------------------------------------------------
 2.Estudiantes              34 17 11  6 53-31 59  2nd Round Promotion Playoff [-] 
------------------------------------------------
 3.Deportivo Italiano       34 16 11  7 45-25 59  1st Round Promotion Playoff 
 4.Flandria                 34 13 14  7 38-22 53  1st Round Promotion Playoff 
 5.San Telmo                34 15  8 11 33-30 53  1st Round Promotion Playoff 
 6.Atlanta                  34 13 11 10 40-35 50  1st Round Promotion Playoff 
 7.Colegiales               34 14  8 12 54-56 50  1st Round Promotion Playoff 
 8.Tristán Suarez           34 12 13  9 49-40 49  1st Round Promotion Playoff 
 9.Sarmiento (Junín)        34 12 11 11 47-42 47  1st Round Promotion Playoff 
10.Argentino de Quilmes     34 12 11 11 36-38 47  1st Round Promotion Playoff 
11.Defensores de Belgrano   34 10 16  8 27-21 46  1st Round Promotion Playoff 
12.Berazategui              34 11 13 10 35-41 46  1st Round Promotion Playoff 
------------------------------------------------
13.Almirante Brown          34 12  9 13 42-44 45
14.Def. de Cambaceres       34 11 10 13 50-53 40  [*]
15.Talleres                 34  9 10 15 26-37 37 
16.Deportivo Armenio        34  8 11 15 29-38 35 
17.Leandro N. Alem          34  5  8 21 34-65 23 
18.General Lamadrid         34  2  9 23 26-69 15  

[*] 3 points deducted due to incidents in round 2 
[-] 3 points deducted due to incidents in previous rounds
 
 
Relegation Table
 
   Teams            97/98 98/99 99/00 Pts. MP. Average
 1.Estudiantes       --    --    59    59   34  1,735 
 2.Def. de Belgrano  55    65    46   166  102  1,627 
 3.Brown (Adrogué)   44    56    60   160  102  1,569 
 4.Dep. Italiano     --    45    59   104   68  1,529 
 5.Atlanta           --    --    50    50   34  1,470 
 6.Colegiales        --    --    50    50   34  1,470 
 7.Tristán Suárez    35    58    49   142  102  1,392 
 8.Flandria          --    41    53    94   68  1,382 
 9.Dep.Armenio       54    47    35   136  102  1,333 
10.Talleres          53    45    37   135  102  1,323
11.Arg. de Quilmes   49    39    47   135  102  1,323 
12.Sarmiento         43    43    47   133  102  1,304 
13.San Telmo         31    47    53   131  102  1,284 
14.Almirante Brown   --    42    45    87   68  1,279 
15.Berazategui       49    32    46   127  102  1,245 
16.D. de Cambaceres  --    --    40    40   34  1,176
-----------------------------------------------------
17.L.N. Alem         32    41    23    96  102  0,941  Relegated
18.Gral. Lamadrid    --    42    15    57   68  0,838  Relegated
 
(MP): Matchs Played
 

Promotion Playoffs
 
First Round [Jun 17]
DEP. ITALIANO  4-1 Berazategui   
Flandria       0-3 DEF. DE BELGRANO     [Abandoned at 73'. Score allowed to stand]
SAN TELMO      2-1 Argentino de Quilmes
Atlanta        0-6 SARMIENTO (JUNÍN)
COLEGIALES     2-1 Tristan Suárez
 
Second Round [Jun 25-27]
ESTUDIANTES    2-0 Defensores de Belgrano
Dep. Italiano  1-2 SARMIENTO (JUNÍN)
San Telmo      1-2 COLEGIALES
 
Semifinals
 
First Legs[Jul 1]
Sarmiento (J)  1-1 Brown (Adrogué)
Colegiales     2-3 Estudiantes
 
Second Legs
[Jul 8]
ESTUDIANTES    1-0 Colegiales
[Jul 11]
Brown (Adr)    1-2 SARMIENTO (J)
 
Final
 
First Leg [Jul 16]
Sarmiento      1-3 Estudiantes
 
Second Leg [Jul 22]
ESTUDIANTES    0-2 Sarmiento (Junín)  
  [Agg: 3-3 - Estudiantes qualified on better record]
 
Estudiantes BA (Primera 'B' 1999/2000 Champions) promoted 

Author: 
Javier Roimiser
(jroimiser@yahoo.com)

Last updated: 2 Apr 2001

(C) Copyright Javier Roimiser
and RSSSF 1999/2001
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,327,944 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0019
Controller Execution Time ( Home / Category )  0.1013
Total Execution Time  0.1032
  CADENA URL  
/primera_b_metropolitana2000
  GET DATOS  
$_GET['/primera_b_metropolitana2000']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (37)  
0.0017  SELECT type FROM routes WHERE alias = 'primera_b_metropolitana2000'
0.0041  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 = 2000 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=1 DESC LIMIT 1
0.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=206 AND type_rel = 3
0.0023  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 3 AND rel.typeId = 206 AND rel.ln = 'es' AND rel.status=1 ORDER BY rel.creation_date desc,rel.cover_points DESC LIMIT 5
0.0023  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 (1217126,1186023,1100435,1089425,1054264) ORDER BY n.cover_points DESC, update_date DESC
0.0022  SELECT text_es as historical_text FROM leagues_text WHERE id=5337
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 = 33810 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.0018  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-04-25 06:31:14' 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-04-25 06:31:14' 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-04-25 06:31:14' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0019  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=3 AND last_update > '2024-04-25 06:31:14' 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 = 2000 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 events2000 e WHERE e.league_id IN (33810) 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 (33810) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN () ORDER BY rp.in_squad = 1 DESC
0.0020  SELECT e.action, count(e.action) as total, e.player_id FROM events2000 e WHERE e.league_id IN (33810) 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 (33810) 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 events2000 e WHERE e.league_id IN (33810) 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 (33810) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN () ORDER BY rp.in_squad = 1 DESC
0.0020  SELECT e.action, count(e.action) as total, e.player_id FROM events2000 e WHERE e.league_id IN (33810) AND (e.action IN (22) ) GROUP BY e.player_id ORDER BY total DESC, e.player_id ASC LIMIT 20
0.0019  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 (33810) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN () ORDER BY rp.in_squad = 1 DESC
0.0017  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 = 33810 AND rp.lineup > 0 ORDER BY rp.lineup DESC,p.pod DESC LIMIT 20
0.0018  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 = 33810 AND rp.events > 0 ORDER BY rp.events DESC,p.pod DESC LIMIT 20
0.0025  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=33810 AND rel.round=34
0.0019  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 = 33810 AND esl.points > 0 ORDER BY esl.points DESC LIMIT 3
0.0019  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 = 33810 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-03-26" AND c.`active`= 1 and c.comment_id is null and c.lang = 1 AND l.`id` = 33810 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-03-26" AND c.`active`= 1 and comment_id is null and c.lang = 1 AND l.`id` = 33810
0.0020  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 `calendars2000` 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` = 33810 AND c.`round` = 34 ORDER BY shedule ASC LIMIT 200
0.0018  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 `events2000` e INNER JOIN calendars2000 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 = 33810 ORDER BY total DESC LIMIT 40
0.0020  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 `events2000` e INNER JOIN calendars2000 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 = 33810 AND e.real_date > NOW() - INTERVAL 1 MONTH ORDER BY e.real_date DESC LIMIT 30
0.0023  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 `tables2000` 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 = 33810 AND t.round = 32 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0023  SELECT *,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables2000` 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 = 33810 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0023  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 = 33810 ORDER BY c.shedule ASC, fcoef DESC LIMIT 5
0.0023  SELECT data1, data2 FROM services_tags WHERE categoryId=206
0.0023  SELECT l.year,l.group_code FROM leagues_besoccer l WHERE l.categoryId = 206 AND l.year = 2000 ORDER BY l.group_code ASC
0.0023  SELECT group_code, extraName from `leagues` WHERE categoryId=206 AND year=2000