4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Publicidad 600x120.gif
Liga Botsuana 2010
2009/2010

Liga Botsuana 2010

Información Histórica
						
Final Table:

 1.Township Rollers (Gaborone)              30 25  3  2 83-23 78  Champions
 2.Centre Chiefs (Mochudi)                  30 19  8  3 70-35 65
 3.Uniao Flamengo Santos (Gaborone)         30 19  3  8 74-48 60
 4.Extension Gunners (Lobatse)              30 17  7  6 56-31 58
 5.ECCO City Greens (Francistown)           30 15  5 10 61-51 50
 6.Botswana Defence Force XI (Mogoditshane) 30 12  7 11 35-33 43
 7.Gaborone United (Gaborone)               30 11  9 10 43-44 42
 8.Notwane FC (Gaborone)                    30  9  9 12 47-52 36
 9.Nico United (Selebi Phikwe)              30 10  3 17 34-50 33
10.TAFIC (Francistown)                      30  8  8 14 32-47 32
11.Police XI (Otse)                         30  7  9 14 25-34 30
12.Motlakase (Palapye)                      30  8  5 17 37-62 29
13.Botswana Meat Commission (Lobatse)       30  6 10 14 36-46 28
 - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
14.Killer Giants (Ramotswa)                 30  7  7 16 31-59 28  Relegation Playoff
----------------------------------------------------------------
15.Jwaneng Comets (Jwaneng)                 30  6  9 15 31-54 27  Relegated
16.Boteti Young Fighters (Orapa)            30  6  8 16 38-64 26  Relegated

Round 1
[Sep 18]
Notwane               0-0 Gaborone United
[Sep 19]
Boteti Young Fighters 0-0 Police XI
ECCO City Greens      0-0 TAFIC
Killer Giants         0-4 Uniao Flamengo Santos
Township Rollers      2-0 Extension Gunners
  [Aubrey Kebonnetse 58, Onalethata Tshekiso 85]
[Sep 20]
BDF XI                1-1 Centre Chiefs  
Motlakase             2-4 Nico United         
BMC                   0-1 Jwaneng Comets

Round 2
[Sep 25]
Police XI             2-2 Notwane
[Sep 26]
Extension Gunners     3-1 BDF XI
  [Bernard Simakwezi 34, 60, 3-1; Mokgathi Mokgathi 1-1]
Jwaneng Comets        0-3 Township Rollers
Gaborone United       1-1 ECCO City Greens  
  [Wellington Maposa 40; Bonolo Fraiser 7]
Nico United           4-1 Boteti Young Fighters
TAFIC                 1-1 Killer Giants
  [Elijah Kemmonye; Pane Rakhobo]
[Sep 27]
Uniao Flamengo Santos 2-2 BMC
[Jan 20]
Centre Chiefs         3-3 Motlakase

Round 3
[Oct 3]
BMC                   1-0 TAFIC
  [Kenanao Khetholetsile 35]
Township Rollers      0-1 Uniao Flamengo Santos
  [Boitshoko Zikhale 16]
Nico United           1-0 Police XI
Motlakase             0-0 Extension Gunners
[Oct 28]
Killer Giants         0-3 Gaborone United
  [Sageby Sandaka 13pen, Botlhe Rankgomo 46, 53]
[Jan 9]
Boteti Young Fighters 0-3 Centre Chiefs
  [Sekhana Koko (2), Mara Moloi]
[Mar 31]
Jwaneng Comets        0-1 BDF XI
[Apr 17]
Notwane               2-3 ECCO City Greens

Round 4
[Oct 9]
Notwane               1-2 Killer Giants
[Oct 10]
Extension Gunners     3-0 Boteti Young Fighters
  [Bernard Semakwezi 20, Aime Nzohabanayo 35, Ofentse Mmepi 60]
Jwaneng Comets        4-2 Motlakase
TAFIC                 2-5 Township Rollers
  [? (pen) 1-3, Koziba Thabano 2-3; Aubrey Kebonnetse 0-1, 45,
   Simisani Mathumo 45+2, Terence Mandaza 2-4, 90]
Police XI             0-1 ECCO City Greens
Centre Chiefs         3-0 Nico United
  [Sekana Koko 25, 70, Moemedi Moatlhaping 78]
[Oct 11]
Uniao Flamengo Santos 1-2 BDF XI
Gaborone United       0-0 BMC

Round 6 
[Oct 23]
Notwane               2-3 Township Rollers 
[Oct 24]
Jwaneng Comets        2-4 Nico United 
  [Robert Figo Modise 61, 2-4; Thobo Fish Kgoboge 24, Tendai Ndoro 45,
   Odumetse Rakoma 55, Kitso Kowa 78pen]
Uniao Flamengo Santos 4-4 Boteti Young Fighters
ECCO City Greens      4-1 BMC
Extension Gunners     1-2 Centre Chiefs
  [Monametsi Kelebale 15; Thulani Moyo 17og, Musonda Mweuka 68]
[Oct 25]
Police XI             3-0 Killer Giants 
TAFIC                 2-0 Motlakase 
[Nov 25]
Gaborone United       2-1 BDF XI 

Round 7 
[Oct 30]
Extension Gunners     1-0 Police XI 
  [Christopher Ndayishime 90]
[Oct 31]
BMC                   1-2 Killer Giants
Boteti Young Fighters 3-0 TAFIC 
Motlakase             4-1 Gaborone United
  [Maxwell Mburayi 30, Hillary Madzivanyika 70, Mojamorago Radiphophi 3-1,
   Lesego Lubinda 4-1; Sageby Sandaka (pen) 1-1]
Nico United           1-0 Uniao Flamengo Santos
Township Rollers      3-0 ECCO City Greens
  [Terrence Mandaza 46, Lawrence Majawa 57, Edwin Moalosi 87]
[Nov 1]
BDF XI                2-0 Notwane 
Centre Chiefs         2-2 Jwaneng Comets

Round 8 
[Nov 6]
Uniao Flamengo Santos 2-3 Centre Chiefs 
[Nov 7]
Jwaneng Comets        1-2 Extension Gunners
ECCO City Greens      2-1 BDF XI
Notwane               1-1 Motlakase
  [Langson Sichola 78; Lesego Moiphemedi 61]
[Nov 8]
Gaborone United       6-2 Boteti Young Fighters
Killer Giants         0-2 Township Rollers
TAFIC                 1-0 Nico United 
[Dec 9]
Police XI             2-1 BMC

Round 9 
[Nov 13]
Township Rollers      2-1 BMC 
[Nov 14]
Jwaneng Comets        0-0 Police XI
Nico United           1-1 Gaborone United
BDF XI                2-0 Killer Giants
  [Patrick Motsepe 66, 79]
Centre Chiefs         4-1 TAFIC
Boteti Young Fighters 2-2 Notwane 
[Nov 15]
Motlakase             1-2 ECCO City Greens 
Extension Gunners     4-1 Uniao Flamengo Santos 
  [Bernard Semakwezi (4); ?]

Round 10 
[Nov 21]
Police XI             0-2 Township Rollers 
  [Thando Moreki 64, Edwin Moalosi 85]
Notwane               1-1 Nico United 
  [Desire Bafana 73; Tendaiu Ndoro 0-1]
Killer Giants         1-2 Motlakase
TAFIC                 0-2 Extension Gunners 
[Nov 22]
BMC                   2-3 BDF XI 
  [Phemelo Ditsile 30, Ofana Motsumi 61; Patrick Motsepe 4,
   Lemponye Tshireletso 59, Peter Ngwenya 83]
Gaborone United       0-2 Centre Chiefs 
ECCO City Greens      2-2 Boteti Young Fighters 
  [Robert Tamba 44, 75; Cosmos Sebona 32, 85]
[Nov 24]
Uniao Flamengo Santos 4-2 Jwaneng Comets

Round 11 
[Nov 27]
Centre Chiefs         2-2 Notwane 
  [Dirang Moloi 35, Keaketswe Moloi 89; Keoagetse Radipotsane 71, 93]
[Nov 28]
Jwaneng Comets        3-1 TAFIC 
Uniao Flamengo Santos 3-1 Police XI 
Nico United           0-1 ECCO City Greens 
Extension Gunners     2-1 Gaborone United 
  [Kelebale Monametsi 25, Aime Nzohambanayo 50; Wellington Maposa 2]
Boteti Young Fighters 1-1 Killer Giants 
Motlakase             1-1 BMC 
[Nov 29]
BDF XI                1-2 Township Rollers 
  [Peter Ngwenya 1-1; Oscar Ncenga 0-1, Terrence Mandaza 1-2]

Round 12
[Dec 4]
Gaborone United       1-1 Jwaneng Comets
[Dec 5]
Police XI             0-1 BDF XI 
TAFIC                 0-4 Uniao Flamengo Santos 
ECCO City Greens      1-1 Centre Chiefs 
Killer Giants         2-1 Nico United
BMC                   1-2 Boteti Young Fighters
  [Galefetoge Kenaope 34; Isaac Lungu 16, Kgakgamatso Pharo 47]
[Dec 6]
Notwane               2-2 Extension Gunners 
  [Pako Moloi 1-0, Barnes Radipotsane (pen) 2-1;
   Emmanuel Nlu  (pen) 1-1, Kgololo Leteane 2-2]
[Jan 9]
Township Rollers      3-0 Motlakase 
  [Terrence Mandaza (2), Thando Moreki]

Round 13 
[Dec 11]
Killer Giants         1-1 Extension Gunners
[Dec 12]
Township Rollers      2-1 Nico United 
BDF XI                1-1 Boteti Young Fighters 
Gaborone United       2-1 TAFIC
[Dec 13]
BMC                   1-4 Centre Chiefs 
Notwane               2-5 Uniao Flamengo Santos
[Feb 14]
Police XI             2-1 Motlakase 
[Jan 30]
ECCO City Greens      2-1 Jwaneng Comets      

Round 14 
[Dec 19]
Jwaneng Comets        0-1 Notwane 
Extension Gunners     3-0 ECCO City Greens
  [Monageng Thaele 12, 52pen, Aime Nzohambanyo 3-0]
Nico United           1-0 BMC
Boteti Young Fighters 0-5 Township Rollers
Motlakase             0-1 BDF XI  
[Dec 20]
Uniao Flamengo Santos 1-2 Gaborone United 
TAFIC                 1-1 Police XI 
Centre Chiefs         3-0 Killer Giants 

Round 15 
[Dec 23]
Centre Chiefs         2-2 Township Rollers 
[Jan 9]
Extension Gunners     0-0 BMC               
Jwaneng Comets        1-1 Killer Giants 
TAFIC                 0-4 Notwane     
  [Elijah Kabwe (2), Keoagetse Radipotsane, Tebogo Sembowa]       
[Jan 10]
Police XI             1-0 Gaborone United   
Uniao Flamengo Santos 3-2 ECCO City Greens 
Nico United           1-2 BDF XI               
[Jan 13]
Boteti Young Fighters 1-2 Motlakase 

Round 5 
[Jan 16]
Centre Chiefs         3-1 Police XI
  [Sekhana Koko 6, Musonda Mweuka 40, Lesego Galenamotlhale 3-0;
   Betsho Pius 83]
Boteti Young Fighters 2-0 Jwaneng Comets 
Killer Giants         1-6 ECCO City Greens
Motlakase             2-3 Uniao Flamengo Santos
Nico United           0-1 Extension Gunners
  [Kgololo Leteane 90]
[Jan 17]
BMC                   3-4 Notwane
Township Rollers      1-1 Gaborone United
  [Edwin Olerile 84; Ofentse Nato 32]
[May 22]
BDF XI                0-1 TAFIC

Round 16
[Jan 29] 
Gaborone United       2-1 Police XI      
[Jan 30]
BMC                   2-2 Extension Gunners 
  [Hendrick Moyo, Kenny Ramodisa; Derrick Ntumbayi 2-1,
   Kenanao Kgetholetsile 2-2] 
Notwane               0-0 TAFIC           
BDF XI                2-0 Nico United      
Motlakase             4-1 Boteti Young Fighters 
[Jan 31]
Township Rollers      2-3 Centre Chiefs 
  [Edwin Olerile, Joel Mogorosi; Sekhana Koko, Dirang Moloi,
   Oteng Moalosi]
[Feb 14]
Killer Giants         4-0 Jwaneng Comets     
[Mar 7]        
ECCO City Greens      2-4 Uniao Flamengo Santos 

Round 17
[Feb 5]
Gaborone United       1-3 Uniao Flamengo Santos        
Killer Giants         0-2 Centre Chiefs   
  [Sekhana Koko 26, Musonda Mweuku 58]
[Feb 6]
ECCO City Greens      2-1 Extension Gunners    
BMC                   4-1 Nico United       
  [Floh Kgetholetsile (3), Thebe Maiketso; Tendai Ndoro 71pen ]    
Township Rollers      5-0 Boteti Young Fighters 
Police XI             2-1 TAFIC                
Notwane               1-2 Jwaneng Comets  
[Feb 7]
BDF XI                1-1 Motlakase             

Round 18
[Feb 20]
Extension Gunners     3-1 Killer Giants
Nico United           1-2 Township Rollers 
  [Tendai Ndoro 1-1pen; Edwin Moalosi 8, Terence Mandaza 1-2]
Centre Chiefs         5-1 BMC    
Jwaneng Comets        1-1 ECCO City Greens      
[Feb 21] 
Boteti Young Fighters 2-2 BDF XI  
TAFIC                 1-1 Gaborone United 
Uniao Flamengo Santos 2-0 Notwane          
Motlakase             1-0 Police XI    

Round 19
[Feb 27]
Nico United           2-1 Killer Giants
Boteti Young Fighters 0-1 BMC
[Feb 28]
Centre Chiefs         3-4 ECCO City Greens
Extension Gunners     3-1 Notwane
Motlakase             0-7 Township Rollers
[Apr 11]
BDF XI                1-0 Police XI   
[Apr 20]
Jwaneng Comets        2-2 Gaborone United         
[Apr 25]
Uniao Flamengo Santos 0-0 TAFIC 

Round 20
[Mar 3]
Police XI             0-2 Uniao Flamengo Santos
[Mar 6]
Notwane               3-1 Centre Chiefs 
Killer Giants         1-3 Boteti Young Fighters 
TAFIC                 4-0 Jwaneng Comets      
Gaborone United       1-2 Extension Gunners  
[Mar 7]          
BMC                   2-1 Motlakase             
Township Rollers      1-0 BDF XI   
[Apr 25]
ECCO City Greens      6-0 Nico United           

Round 21
[Mar 13]
Motlakase             3-2 Killer Giants      
[Mar 14]
Nico United           2-0 Notwane   
[Mar 17] 
BDF XI                0-0 BMC
Boteti Young Fighters 1-2 ECCO City Greens    
Jwaneng Comets        2-3 Uniao Flamengo Santos
[Mar 18]
Township Rollers      2-0 Police XI
[Mar 27]
Extension Gunners     2-0 TAFIC
[Apr 28]
Centre Chiefs         1-2 Gaborone United  

Round 22
[Mar 20]
Notwane               3-1 Boteti Young Fighters
Uniao Flamengo Santos 3-1 Extension Gunners
[Mar 21]
BMC                   1-2 Township Rollers
Police XI             0-0 Jwaneng Comets
ECCO City Greens      3-0 Motlakase
[Apr 5]
Gaborone United       2-1 Nico United 
[Apr 10]
TAFIC                 1-2 Centre Chiefs
[Apr 25]
Killer Giants         0-0 BDF XI 

Round 23
[Mar 27]
Boteti Young Fighters 0-1 Gaborone United
[Apr 1]
Nico United           1-0 TAFIC
Township Rollers      6-0 Killer Giants
[Apr 2]
BDF XI                1-3 ECCO City Greens
Centre Chiefs         5-2 Uniao Flamengo Santos
Extension Gunners     6-1 Jwaneng Comets
Motlakase             0-3 Notwane
[Apr 18]
BMC                   0-0 Police XI

Round 24
[Mar 27]
Uniao Flamengo Santos 4-0 Nico United
[Apr 4]
TAFIC                 5-4 Boteti Young Fighters
Killer Giants         0-0 BMC
[Apr 5]
ECCO City Greens      3-6 Township Rollers
Police XI             2-0 Extension Gunners
Jwaneng Comets        0-0 Centre Chiefs
[Apr 7]
Notwane               0-2 BDF XI
[Apr 17]
Gaborone United       2-1 Motlakase

Round 25
[Mar 27]
BMC                   2-0 ECCO City Greens
[Mar 28]
Killer Giants         1-1 Police XI
[Apr 14]
BDF XI                2-1 Gaborone United
[Mar 17]
Boteti Young Fighters 1-2 Uniao Flamengo Santos
Nico United           2-0 Jwaneng Comets
[Apr 22]
Motlakase             0-2 TAFIC
[Apr 25]
Centre Chiefs         2-2 Extension Gunners
[Apr 29]
Township Rollers      2-0 Notwane

Round 26
[Apr 10]
Notwane               2-5 BMC
Uniao Flamengo Santos 4-1 Motlakase
ECCO City Greens      4-2 Killer Giants
Extension Gunners     3-1 Nico United
Jwaneng Comets        1-1 Boteti Young Fighters
[Apr 11]
Gaborone United       1-4 Township Rollers
[Apr 18]
TAFIC                 1-0 BDF XI
[May 4]
Centre Chiefs         1-0 Police XI

Round 27 
[May 1]
Boteti Young Fighters 0-1 Extension Gunners
BDF XI                1-2 Uniao Flamengo Santos
ECCO City Greens      1-2 Police XI
Nico United           0-2 Centre Chiefs
Motlakase             1-0 Jwaneng Comets
[May 2]
BMC                   1-1 Gaborone United
Killer Giants         0-1 Notwane
Township Rollers      1-1 TAFIC

Round 28 
[May 8]
Police XI             2-2 Nico United
ECCO City Greens      0-2 Notwane
Centre Chiefs         2-1 Boteti Young Fighters
[May 9]
Uniao Flamengo Santos 2-3 Township Rollers
TAFIC                 1-1 BMC
Extension Gunners     4-1 Motlakase
BDF XI                2-3 Jwaneng Comets
[May 12]
Gaborone United       0-2 Killer Giants

Round 29
[May 5]
Township Rollers      1-0 Jwaneng Comets
[May 13]
BDF XI                1-1 Extension Gunners
Notwane               2-2 Police XI
[May 15]
ECCO City Greens      2-3 Gaborone United
[May 16]
Killer Giants         2-1 TAFIC
BMC                   1-2 Uniao Flamengo Santos
[May 23]
Motlakase             0-1 Centre Chiefs
Boteti Young Fighters 1-0 Nico United

Round 30
[Mar 24]
Centre Chiefs         2-0 BDF XI
[Apr 24]
Police XI             0-1 Boteti Young Fighters
[May 13]
TAFIC                 3-1 ECCO City Greens
[May 15]
Nico United           1-2 Motlakase
[May 19]
Extension Gunners     0-2 Township Rollers
[May 22]
Gaborone United       2-3 Notwane
[May 23]
Jwaneng Comets        1-0 BMC
Uniao Flamengo Santos 1-3 Killer Giants

Final Table:

 1.Township Rollers (Gaborone)              30 25  3  2 83-23 78  Champions
 2.Centre Chiefs (Mochudi)                  30 19  8  3 70-35 65
 3.Uniao Flamengo Santos (Gaborone)         30 19  3  8 74-48 60
 4.Extension Gunners (Lobatse)              30 17  7  6 56-31 58
 5.ECCO City Greens (Francistown)           30 15  5 10 61-51 50
 6.Botswana Defence Force XI (Mogoditshane) 30 12  7 11 35-33 43
 7.Gaborone United (Gaborone)               30 11  9 10 43-44 42
 8.Notwane FC (Gaborone)                    30  9  9 12 47-52 36
 9.Nico United (Selebi Phikwe)              30 10  3 17 34-50 33
10.TAFIC (Francistown)                      30  8  8 14 32-47 32
11.Police XI (Otse)                         30  7  9 14 25-34 30
12.Motlakase (Palapye)                      30  8  5 17 37-62 29
13.Botswana Meat Commission (Lobatse)       30  6 10 14 36-46 28
 - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
14.Killer Giants (Ramotswa)                 30  7  7 16 31-59 28  Relegation Playoff
----------------------------------------------------------------
15.Jwaneng Comets (Jwaneng)                 30  6  9 15 31-54 27  Relegated
16.Boteti Young Fighters (Orapa)            30  6  8 16 38-64 26  Relegated


Promotion/Relegation Playoff

Final Table:

 1.TASC (Francistown)                        4  2  2  0  9- 4  8  Promoted
----------------------------------------------------------------
 2.Killer Giants (Ramotswa)                  4  1  2  1  6- 7  5  Relegated
 3.Letlapeng FC (Ramotswa)                   4  0  2  2  4- 8  2

[May 28, Molepolole]
Killer Giants         1-1 Letlapeng
[May 29, Molepolole]
TASC                  1-1 Killer Giants
[May 30, Molepolole]
Letlapeng             1-1 TASC
[Jun 4, Selibe Phikwe]
Killer Giants         1-4 TASC
[Jun 5, Selibe Phikwe]
Letlapeng             1-3 Killer Giants
[Jun 6, Selibe Phikwe]
TASC                  3-1 Letlapeng

Final Table:

 1.TASC (Francistown)                        4  2  2  0  9- 4  8  Promoted
----------------------------------------------------------------
 2.Killer Giants (Ramotswa)                  4  1  2  1  6- 7  5  Relegated
 3.Letlapeng FC (Ramotswa)                   4  0  2  2  4- 8  2



Author: Emmanuel Thekiso
(thekiso@yahoo.co)

Last updated: 24 Sep 2010

(C) Copyright Emmanuel Thekiso and RSSSF 2009/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,287,808 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0018
Controller Execution Time ( Home / Category )  0.0973
Total Execution Time  0.0991
  CADENA URL  
/liga_botsuana2010
  GET DATOS  
$_GET['/liga_botsuana2010']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (36)  
0.0019  SELECT type FROM routes WHERE alias = 'liga_botsuana2010'
0.0040  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 = 2010 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=131
0.0022  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 = 28423 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0020  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='2010' WHERE c.parentId=329 GROUP BY c.id ORDER BY c.order_id ASC
0.0018  SELECT type,rule FROM rules WHERE categoryId = 329 ORDER BY type = 'tables_draw' DESC,type != 'extra' DESC, `order` ASC
0.0018  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-05-01 18:42:56' 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-01 18:42:56' 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=4 AND last_update > '2024-05-01 18:42:56' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0020  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=3 AND last_update > '2024-05-01 18:42:56' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0024  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 = 2010 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=0 DESC LIMIT 1
0.0021  SELECT e.action, count(e.action) as total, e.player_id FROM events2010 e WHERE e.league_id IN (28423) 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.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 (28423) 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 events2010 e WHERE e.league_id IN (28423) AND (e.action IN (4,5) ) 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 (28423) 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 events2010 e WHERE e.league_id IN (28423) AND (e.action IN (3,4) ) 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 (28423) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN () ORDER BY rp.in_squad = 1 DESC
0.0021  SELECT e.action, count(e.action) as total, e.player_id FROM events2010 e WHERE e.league_id IN (28423) 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 (28423) 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 = 28423 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 = 28423 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=28423 AND rel.round=30
0.0020  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 = 28423 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 = 28423 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-01" AND c.`active`= 1 and c.comment_id is null and c.lang = 1 AND l.`id` = 28423 ORDER BY creation_date DESC LIMIT 0, 10
0.0026  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-01" AND c.`active`= 1 and comment_id is null and c.lang = 1 AND l.`id` = 28423
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 `calendars2010` 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` = 28423 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 `events2010` e INNER JOIN calendars2010 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 = 28423 ORDER BY total DESC LIMIT 40
0.0025  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 `events2010` e INNER JOIN calendars2010 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 = 28423 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 `tables2010` 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 = 28423 AND t.round = 28 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 `tables2010` 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 = 28423 AND t.round = 30 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-05-01 00:00:00' AND c.`shedule` < '2024-05-05 23:59:59' AND l.id = 28423 ORDER BY c.shedule ASC, fcoef DESC LIMIT 5
0.0021  SELECT data1, data2 FROM services_tags WHERE categoryId=329
0.0021  SELECT l.year,l.group_code FROM leagues_besoccer l WHERE l.categoryId = 329 AND l.year = 2010 ORDER BY l.group_code ASC
0.0021  SELECT group_code, extraName from `leagues` WHERE categoryId=329 AND year=2010