4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
« Temporada Anterior
Temporada 2009
Temporada Siguiente »
Publicidad 600x120.gif
Liga Botsuana 2009
2008/2009

Liga Botsuana 2009

Información Histórica 
						
Premier League 

Final Table:

 1.Gaborone United (Gaborone)               30 23  6  1 71-26 75  Champions
 2.Centre Chiefs (Mochudi)                  30 23  2  5 84-28 71
 3.ECCO City Greens (Francistown)           30 18  4  8 60-33 58
 4.Botswana Defence Force XI (Mogoditshane) 30 16  5  9 42-27 53
 5.Township Rollers (Gaborone)              30 13  7 10 47-42 46
 6.Police XI (Otse)                         30 13  6 11 44-41 45
 7.Extension Gunners (Lobatse)              30  9 12  9 42-46 39
 8.Boteti Young Fighters (Orapa)            30 11  6 13 44-59 39
 9.Botswana Meat Commission (Lobatse)       30 10  8 12 38-33 38
10.TAFIC (Francistown)                      30  9 10 11 39-46 37
11.Uniao Flamengo Santos (Gaborone)         30 10  6 14 52-49 36
12.Notwane FC (Gaborone)                    30  9  9 12 43-53 36
13.Nico United (Selebi Phikwe)              30 10  4 16 49-67 34
 - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
14.Mogoditshane Fighters (Mogoditshane)     30  7  9 14 34-50 30  Relegation Playoff
----------------------------------------------------------------
15.Great North Tigers (Francistown)         30  5  4 21 29-69 19  Relegated
16.Naughty Boys (Tlokweng)                  30  4  2 24 24-73 14  Relegated

Week 1
[Oct 4]
Centre Chiefs         3-1 Extension Gunners
[Oct 5]
TAFIC                 0-0 Nico United          
Boteti Young Fighters 2-1 ECCO City Greens     
Gaborone United       3-1 Notwane              
Great North Tigers    0-4 BDF XI               
BMC                   2-0 Uniao Flamengo Santos
Township Rollers      3-1 Naughty Boys         
Police XI             1-2 Mogoditshane Fighters

Moved Matches
[Oct 12]
Uniao Flamengo Santos 2-3 Gaborone United      
BMC                   3-0 Notwane              
Township Rollers      4-1 Centre Chiefs        
TAFIC                 0-0 Great North Tigers 
[Oct 15]
Extension Gunners     1-2 Naughty Boys

Week 2
[Oct 18]
Mogoditshane Fighters 1-1 Uniao Flamengo Santos
BDF XI                0-1 Extension Gunners    
BMC                   2-1 Great North Tigers    
Nico United           3-2 Boteti Young Fighters
Gaborone United       3-2 Township Rollers     
[Oct 19]
ECCO City Greens      2-1 TAFIC                
Naughty Boys          0-1 Centre Chiefs         
Notwane               2-1 Police XI            

Week 3
[Oct 24]
Notwane               4-0 Naughty Boys         
[Oct 25]
Extension Gunners     1-0 Nico United          
Centre Chiefs         3-1 ECCO City Greens     
Boteti Young Fighters 0-0 Gaborone United      
Great North Tigers    5-1 Mogoditshane Fighters
[Oct 26]
Township Rollers      0-1 BDF XI               

NB: long interruption due to sponsorship problems

Week 4
[Nov 29]
Boteti Young Fighters 2-1 Great North Tigers
Notwane               0-1 Mogoditshane Fighters	
TAFIC                 0-4 BDF XI
Township Rollers      1-1 Extension Gunners
[Nov 30]
ECCO City Greens      5-3 Nico United
Uniao Flamengo Santos 0-2 Police XI
Gaborone United       2-1 Centre Chiefs
BMC                   0-0 Naughty Boys

Week 5
[Dec 6]
Notwane               1-1 Extension Gunners     
Great North Tigers    1-2 Township Rollers 
Police XI             0-2 TAFIC
BDF XI                1-2 ECCO City Greens
Nico United           1-6 Gaborone United
Uniao Flamengo Santos 0-1 Boteti Young Fighters 
[Dec 7]
Mogoditshane Fighters 0-3 Centre Chiefs

Week 6
[Dec 12]
Uniao Flamengo Santos 2-3 Centre Chiefs
[Dec 13]
Township Rollers      2-1 Nico United
Notwane               0-0 Great North Tigers  
TAFIC                 1-0 Naughty Boys
Extension Gunners     1-0 Boteti Young Fighters 
ECCO City Greens      1-1 Mogoditshane Fighters
[Dec 14]
Police XI             0-0 BMC
Gaborone United       1-2 BDF XI

Week 7
[Dec 18]
Gaborone United       1-0 BMC
[Dec 19]
Boteti Young Fighters 0-2 Township Rollers
[Dec 20]
Police XI             2-1 ECCO City Greens
Extension Gunners     4-2 TAFIC
Great North Tigers    0-2 Centre Chiefs
BDF XI                3-2 Notwane
[Dec 21]
Naughty Boys          0-1 Mogoditshane Fighters

Week 8
[Jan 10]
BDF XI                0-0 Police XI 
Uniao Flamengo Santos 0-1 ECCO City Greens 
Township Rollers      1-1 TAFIC
Boteti Young Fighters 3-1 Naughty Boys 
Great North Tigers    3-1 Nico United      
[Jan 11]
Mogoditshane Fighters 1-1 BMC
Notwane               1-2 Centre Chiefs    

Week 9
[Jan 16]
Centre Chiefs         1-0 BDF XI
[Jan 17]
Notwane               0-3 Uniao Flamengo Santos 
Naughty Boys          2-4 Great North Tigers   
ECCO City Greens      1-2 Township Rollers
Gaborone United       2-0 Mogoditshane Fighters 
[Jan 18]
TAFIC                 0-2 Boteti Young Fighters 
BMC                   2-0 Extension Gunners

Week 10
[Jan 21]
Police XI             0-1 Gaborone United       
[Jan 24]
Uniao Flamengo Santos 2-0 Great North Tigers   
BDF XI                2-0 Naughty Boys       
TAFIC                 1-2 Notwane
Boteti Young Fighters 1-1 Centre Chiefs
Nico United           1-4 Mogoditshane Fighters
BMC                   0-1 ECCO City Greens
[Jan 25]
Extension Gunners     2-2 Police XI

Week 11
[Jan 30]
Township Rollers      3-1 Notwane           
[Jan 31]
BDF XI                0-1 Mogoditshane Fighters
Gaborone United       2-2 Great North Tigers
Centre Chiefs         4-1 TAFIC
BMC                   4-0 Nico United
[Feb 1]
Naughty Boys          0-1 Police XI
ECCO City Greens      2-0 Extension Gunners
[Feb 3]
BDF XI                2-1 Uniao Flamengo Santos       [also reported 3-2]

Week 12
[Feb 6]
Uniao Flamengo Santos 2-2 Naughty Boys
[Feb 7]
Gaborone United       2-1 TAFIC
Nico United           2-0 Centre Chiefs
ECCO City Greens      2-2 Notwane
Mogoditshane Fighters 2-4 Extension Gunners
Boteti Young Fighters 1-1 BDF XI      
[Feb 8]
BMC                   0-1 Township Rollers
Great North Tigers    0-1 Police XI             

Week 13
[Feb 13]
Centre Chiefs         5-1 Police XI        
[Feb 14]
Boteti Young Fighters 1-2 BMC
Notwane               2-1 Nico United
Township Rollers      1-0 Mogoditshane Fighters
TAFIC                 2-1 Uniao Flamengo Santos 
[Feb 15]
Gaborone United       2-0 Extension Gunners
Great North Tigers    2-1 ECCO City Greens

Week 14
[Feb 20]
Township Rollers      1-2 Police XI       
[Feb 21]
Naughty Boys          1-3 ECCO City Greens
Nico United           1-2 BDF XI
BMC                   2-0 TAFIC
Boteti Young Fighters 1-2 Notwane
[Feb 22]
Uniao Flamengo Santos 4-2 Extension Gunners 

Week 15
[Feb 27]
Uniao Flamengo Santos 2-1 Township Rollers   
[Feb 28]
Boteti Young Fighters 1-5 Police XI     
Naughty Boys          1-2 Nico United 
Extension Gunners     2-2 Great North Tigers  
ECCO City Greens      0-0 Gaborone United     
TAFIC                 2-1 Mogoditshane Fighters
[Mar 1]
Centre Chiefs         5-1 BMC       

Moved Matches
[Mar 6]
Naughty Boys          0-5 Gaborone United     
[Mar 7]
Mogoditshane Fighters 1-1 Boteti Young Fighters
Nico United           1-4 Uniao Flamengo Santos 
[Mar 8]
BDF XI                1-0 BMC         

Week 16
[Mar 13]
Notwane               1-2 BDF XI
[Mar 14]
Gaborone United       3-1 ECCO City Greens   
Police XI             1-2 Boteti Young Fighters
Nico United           7-0 Naughty Boys
Great North Tigers    1-4 Extension Gunners
Mogoditshane Fighters 1-1 TAFIC
[Mar 15]
BMC                   1-3 Centre Chiefs
Township Rollers      3-1 Uniao Flamengo Santos 

Week 17
[Mar 20]
Police XI             2-2 Township Rollers
[Mar 21]
Boteti Young Fighters 2-1 Mogoditshane Fighters
Uniao Flamengo Santos 4-1 Nico United
Great North Tigers    1-3 TAFIC
[Mar 22]
Gaborone United       5-4 Naughty Boys    

Week 18
[Mar 27]
Uniao Flamengo Santos 2-2 Extension Gunners
[Mar 28]
BDF XI                2-2 Nico United           
Notwane               1-4 Boteti Young Fighters
TAFIC                 1-0 BMC
ECCO City Greens      4-1 Naughty Boys
[Mar 29]
Centre Chiefs         2-0 Township Rollers

Week 19
[Apr 3]
Extension Gunners     1-1 Gaborone United  
[Apr 4]
Uniao Flamengo Santos 2-2 TAFIC
Nico United           2-2 Notwane
BMC                   2-1 Boteti Young Fighters
ECCO City Greens      3-0 Great North Tigers
Police XI             0-2 Centre Chiefs
[Apr 5]
Township Rollers      1-1 Mogoditshane Fighters
Naughty Boys          0-1 BDF XI

Week 20
[Apr 9]
Police XI             3-0 Naughty Boys
[Apr 10]
Boteti Young Fighters 2-2 Uniao Flamengo Santos  
Extension Gunners     0-5 ECCO City Greens   
Nico United           2-1 BMC
Great North Tigers    0-3 Gaborone United
[Apr 11]
TAFIC                 2-2 Centre Chiefs
[Apr 12]
Mogoditshane Fighters 0-1 BDF XI
[Apr 13]
Township Rollers      1-2 Notwane
Nico United           4-3 Police XI

Round 21
[Apr 17]
Centre Chiefs         3-0 Mogoditshane Fighters
[Apr 18]
ECCO City Greens      1-0 BDF XI      
Gaborone United       3-1 Nico United	
Township Rollers      2-1 Great North Tigers
[Apr 19]
TAFIC                 1-2 Police XI
Extension Gunners     0-0 Notwane

Moved Match [Apr 22]
Notwane               1-0 BMC

Round 22
[Apr 25]
Nico United           0-1 Great North Tigers
ECCO City Greens      1-0 Uniao Flamengo Santos  
Naughty Boys          2-1 Boteti Young Fighters  
Centre Chiefs         2-0 Notwane
[Apr 26]
BDF XI                1-2 Police XI
TAFIC                 2-2 Township Rollers
BMC                   0-0 Mogoditshane Fighters

Moved Match [Apr 29]
Gaborone United       2-0 Uniao Flamengo Santos  

Round 23
[May 1]
BDF XI                1-0 Township Rollers
Nico United           1-3 Extension Gunners
[May 2]
ECCO City Greens      3-0 Centre Chiefs
Gaborone United       5-0 Boteti Young Fighters  

Moved Match [May 5]
Naughty Boys          2-3 Notwane 

Moved Match [May 13]
Police XI             0-0 Extension Gunners

Round 24
[May 16]
Great North Tigers    0-3 Uniao Flamengo Santos  
Notwane               1-1 TAFIC      
Centre Chiefs        12-2 Boteti Young Fighters  
Mogoditshane Fighters 2-4 Nico United
ECCO City Greens      1-0 BMC 
[May 17]
Gaborone United       2-1 Police XI
Naughty Boys          1-2 Extension Gunners

Round 25
[May 28]
Notwane               0-4 ECCO City Greens   
[May 29]
BMC                   2-2 Township Rollers 
[May 30]
Police XI             4-1 Great North Tigers 
BDF XI                4-2 Boteti Young Fighters  
TAFIC                 1-1 Gaborone United
Centre Chiefs         4-0 Nico United
[May 31]
Naughty Boys          0-3 Uniao Flamengo Santos  
Mogoditshane Fighters 0-0 Extension Gunners

Round 26
[Jun 20]
TAFIC                 2-1 Extension Gunners
BMC                   0-1 Gaborone United
Centre Chiefs         6-0 Great North Tigers
Township Rollers      3-1 Boteti Young Fighters  
[Jun 21]
Mogoditshane Fighters 0-2 Naughty Boys
ECCO City Greens      1-2 Police XI
BDF XI                2-1 Uniao Flamengo Santos 

Round 27
[Jun 27]
Great North Tigers    1-4 Notwane
BDF XI                1-2 Gaborone United 
Mogoditshane Fighters 3-6 ECCO City Greens 
Boteti Young Fighters 1-1 Extension Gunners
Nico United           2-1 Township Rollers 
Centre Chiefs         4-2 Uniao Flamengo Santos 
[Jun 28]
Naughty Boys          1-2 TAFIC
BMC                   2-3 Police XI

Round 28
[Jul 1]
Extension Gunners     3-3 BMC
Mogoditshane Fighters 1-2 Gaborone United
BDF XI                0-1 Centre Chiefs
Uniao Flamengo Santos 3-2 Notwane
[Jul 4]
Boteti Young Fighters 2-1 TAFIC	
Township Rollers      0-0 ECCO City Greens   
Police XI             0-2 Nico United   

Moved Matches
[Jul 4]
Mogoditshane Fighters 2-0 Great North Tigers 
[Jul 8]
BMC                   1-1 BDF XI             

Round 29 
[Jul 11]
Boteti Young Fighters 2-0 Nico United
TAFIC                 2-3 ECCO City Greens
Police XI             1-1 Notwane
Township Rollers      1-5 Gaborone United
Great North Tigers    0-3 BMC  
Centre Chiefs         5-0 Naughty Boys
[Jul 12]
Extension Gunners     0-0 BDF XI
Uniao Flamengo Santos 2-1 Mogoditshane Fighters

Round 30
[Jul 17]
Naughty Boys          0-2 Township Rollers
[Jul 18] 
Uniao Flamengo Santos 2-2 BMC
Mogoditshane Fighters 2-0 Police XI
BDF XI                3-1 Great North Tigers
ECCO City Greens      2-0 Boteti Young Fighters
Nico United           2-2 TAFIC
[Jul 19]
Notwane               2-2 Gaborone United
Extension Gunners     0-3 Centre Chiefs

Moved Match [Jul 21]         
Great North Tigers    0-1 Naughty Boys

Round 31
[Jul 24]
Extension Gunners     4-1 Township Rollers
[Jul 25]
Gaborone United       1-0 Centre Chiefs
[Jul 26]
Mogoditshane Fighters 3-3 Notwane
Great North Tigers    1-4 Boteti Young Fighters
BDF XI                0-2 TAFIC
Police XI             2-1 Uniao Flamengo Santos
Nico United           2-1 ECCO City Greens
Naughty Boys          0-2 BMC
 
Final Table:

 1.Gaborone United (Gaborone)               30 23  6  1 71-26 75  Champions
 2.Centre Chiefs (Mochudi)                  30 23  2  5 84-28 71
 3.ECCO City Greens (Francistown)           30 18  4  8 60-33 58
 4.Botswana Defence Force XI (Mogoditshane) 30 16  5  9 42-27 53
 5.Township Rollers (Gaborone)              30 13  7 10 47-42 46
 6.Police XI (Otse)                         30 13  6 11 44-41 45
 7.Extension Gunners (Lobatse)              30  9 12  9 42-46 39
 8.Boteti Young Fighters (Orapa)            30 11  6 13 44-59 39
 9.Botswana Meat Commission (Lobatse)       30 10  8 12 38-33 38
10.TAFIC (Francistown)                      30  9 10 11 39-46 37
11.Uniao Flamengo Santos (Gaborone)         30 10  6 14 52-49 36
12.Notwane FC (Gaborone)                    30  9  9 12 43-53 36
13.Nico United (Selebi Phikwe)              30 10  4 16 49-67 34
 - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
14.Mogoditshane Fighters (Mogoditshane)     30  7  9 14 34-50 30  Relegation Playoff
----------------------------------------------------------------
15.Great North Tigers (Francistown)         30  5  4 21 29-69 19  Relegated
16.Naughty Boys (Tlokweng)                  30  4  2 24 24-73 14  Relegated



Promotion/Relegation Playoff

[Aug 1, Francistown]
Miscellaneous         1-1 Jwaneng Comets
[Aug 2, Francistown]
Miscellaneous         2-1 Mogoditshane Fighters
[Aug 5, Lobatse]
Mogoditshane Fighters 5-0 Jwaneng Comets
[Aug 7, Lobatse]
Mogoditshane Fighters 2-3 Miscellaneous
[Aug 8, Lobatse]
Jwaneng Comets       12-2 Mogoditshane Fighters       [also reported 12-1]
[Aug 9, Lobatse]
Jwaneng Comets        1-0 Miscellaneous

Final Table:

 1.Jwaneng Comets (Jwaneng)                  4  2  1  1 14- 8  7  Promoted
----------------------------------------------------------------
 2.Miscellaneous (Serowe)                    4  2  1  1  6- 5  7
 3.Mogoditshane Fighters (Mogoditshane)      4  1  0  3 10-17  3  Relegated

NB: after a protest by Miscellaneous against the result on Aug 8,
    it was ruled that as Fighters ostensibly had not taken the
    match seriously after already being out of the running for
    first place, the top-2 teams who finished equal on points
    need to play off for promotion at a neutral venue whereas
    Mogoditshane Fighters are suspended for six months (until the
    end of January 2010).  However, after an appeal by Comets the
    final table stood and no playoff was held; another appeal by
    Miscellaneous was not successful.


Author: Emmanuel Thekiso
(thekiso@yahoo.co)

Last updated: 2 Sep 2010

(C) Copyright Emmanuel Thekiso and RSSSF 2008/10

INFORMACIÓN

La primera edición se disputó en el año 1966 con el nombre de MLO Cup. En ella participaron equipos como el Tlokweng Pirates, Notwane, Black Peril, Queens Park Rangers y un equipo del distrito de Ngwaketse. La competición ha estado, históricamente, dominada por los equipos del sur de país, hasta la temporada 2006/07 en la que el ECCO City Greens se convirtió en el primer equipo del norte en ganar la competición.

  USO DE MEMORIA  
4,280,920 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0024
Controller Execution Time ( Home / Category )  0.0958
Total Execution Time  0.0983
  CADENA URL  
/liga_botsuana2009
  GET DATOS  
$_GET['/liga_botsuana2009']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (35)  
0.0017  SELECT type FROM routes WHERE alias = 'liga_botsuana2009'
0.0039  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'liga_botsuana' AND (l.group_code = 1 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 2009 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=329 AND type_rel = 3
0.0022  SELECT text_es as historical_text FROM leagues_text WHERE id=130
0.0018  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 = 28422 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0021  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='2009' WHERE c.parentId=329 GROUP BY c.id ORDER BY c.order_id ASC
0.0018  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-05-03 09:08:07' 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-05-03 09:08:07' 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-05-03 09:08:07' 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-05-03 09:08:07' 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 = 'liga_botsuana' AND (l.group_code = 0 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 2009 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 events2009 e WHERE e.league_id IN (28422) 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 (28422) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN () ORDER BY rp.in_squad = 1 DESC
0.0018  SELECT e.action, count(e.action) as total, e.player_id FROM events2009 e WHERE e.league_id IN (28422) 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 (28422) 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 events2009 e WHERE e.league_id IN (28422) AND (e.action IN (3,4) ) GROUP BY e.player_id ORDER BY total DESC, e.player_id ASC LIMIT 20
0.0020  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 (28422) 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 events2009 e WHERE e.league_id IN (28422) 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 (28422) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN () ORDER BY rp.in_squad = 1 DESC
0.0019  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 = 28422 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 = 28422 AND rp.events > 0 ORDER BY rp.events DESC,p.pod DESC LIMIT 20
0.0022  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=28422 AND rel.round=30
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 = 28422 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 = 28422 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-04-03" AND c.`active`= 1 and c.comment_id is null and c.lang = 1 AND l.`id` = 28422 ORDER BY creation_date DESC LIMIT 0, 10
0.0023  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-04-03" AND c.`active`= 1 and comment_id is null and c.lang = 1 AND l.`id` = 28422
0.0019  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 `calendars2009` 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` = 28422 AND c.`round` = 30 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 `events2009` e INNER JOIN calendars2009 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 = 28422 ORDER BY total DESC LIMIT 40
0.0030  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 `events2009` e INNER JOIN calendars2009 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 = 28422 AND e.real_date > NOW() - INTERVAL 1 MONTH ORDER BY e.real_date DESC LIMIT 30
0.0020  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 `tables2009` 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 = 28422 AND t.round = 28 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0020  SELECT *,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables2009` 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 = 28422 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0020  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-05-03 00:00:00' AND c.`shedule` < '2024-05-07 23:59:59' AND l.id = 28422 ORDER BY c.shedule ASC, fcoef DESC LIMIT 5
0.0020  SELECT data1, data2 FROM services_tags WHERE categoryId=329
0.0020  SELECT l.year,l.group_code FROM leagues_besoccer l WHERE l.categoryId = 329 AND l.year = 2009 ORDER BY l.group_code ASC
0.0020  SELECT group_code, extraName from `leagues` WHERE categoryId=329 AND year=2009