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

Liga Botsuana 2007

Información Histórica 
						
Mascom Premier League 

Final Table:

 1.ECCO City Green (Francistown)            30 21  4  5 65-37 67  Champions
 2.Centre Chiefs (Mochudi)                  30 19  5  6 72-36 62
 3.Botswana Defence Force XI (Mogoditshane) 30 16  9  5 43-25 57
 4.Gaborone United (Gaborone)               30 14  6 10 41-43 48
 5.Police XI (Otse)                         30 12 10  8 47-42 46
 6.Botswana Meat Commission (Lobatse)       30 11 11  8 32-26 44
 7.Notwane FC (Gaborone)                    30 11  9 10 49-36 42
 8.Township Rollers (Gaborone)              30 11  9 10 43-36 42
 9.TAFIC (Francistown)                      30 10  8 12 40-45 38
10.Nico United (Selebi Phikwe)              30  8 11 11 38-46 35
11.Uniao Flamengo Santos (Gaborone)         30 10  5 15 37-47 35
12.TASC (Francistown)                       30  9  7 14 37-44 34
13.Lobtrans Gunners (Lobatse)               30  7 10 13 31-40 31
 - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
14.Jwaneng Comets                           30  7 10 13 28-40 31  Relegation Playoff
----------------------------------------------------------------
15.Prisons XI (Gaborone)                    30  5  9 16 27-47 24  Relegated
16.FC Satmos (Selebi Phikwe)                30  4  7 19 24-64 19  Relegated

NB: Notwane had had 3 matches awarded 0-2 against them for playing 
    Thebeetsile Raditsebe, who was ineligible for being transferred 
    outside of the transfer window; this decision was revoked on
    appeal

Round 1
[Sep 16]
Gunners     0-2 Chiefs
ECCO City   3-2 Notwane
Prisons     0-0 TASC
Nico U.     2-2 Santos
Police      2-2 Gaborone U.
Comets      1-1 Rollers
[Sep 17]
BMC         0-1 BDF
Satmos      1-1 TAFIC

Round 2
[Sep 23]
TASC        2-1 Satmos     
Notwane     3-1 Comets     
BDF         2-2 ECCO City  
[Sep 24]
Santos      1-1 Police     
TAFIC       0-3 Nico U.    
Chiefs      0-0 Prisons    
Gaborone U. 0-0 BMC
[Nov 29]
Rollers     4-1 Gunners    

Round 3
[Oct 1]
Prisons     0-2 Rollers    
Satmos      2-4 Chiefs   
TAFIC       0-0 Police  
BMC         2-3 ECCO City   
Gaborone U. 1-1 Santos  
[Oct 2]     
TASC        1-0 Nico U.    
Gunners     0-0 Notwane     
Comets      1-2 BDF         

Round 4 
[Oct 8]
Police      3-1 Prisons    
TASC        1-2 Gunners     
ECCO City   1-3 TAFIC
Rollers     1-1 Satmos      
[Dec 13]
Notwane     0-1 Gaborone U.

Round 5
[Oct 14]
BMC         0-0 Gunners     
Satmos      1-2 Notwane
ECCO City   2-0 Comets      
Police      2-1 TASC
Santos      0-2 TAFIC 
Chiefs      5-1 Nico U.
[Oct 15]
Rollers     0-1 BDF         

Round 6
[Oct 21]
Rollers     1-2 Police      
Notwane     0-0 Nico U.    
BMC         1-1 Prisons    
ECCO City   1-0 Gunners     
[Oct 22]
TASC        0-1 TAFIC
Comets      2-2 Gaborone U. 
Chiefs      1-3 Santos     
BDF         1-1 Satmos     

Round 7
[Oct 28]
Satmos      1-2 BMC 
Prisons     0-2 ECCO City  
Gunners     0-0 Comets      
TAFIC       0-1 Chiefs      
Gaborone U. 1-3 Rollers      
Santos      0-1 TASC  
[Oct 29]  
Nico U.     2-0 BDF      
Police      0-0 Notwane   

Round 8
[Nov 4]
BMC         1-0 Nico U.    
BDF         2-1 Police     
TASC        1-2 Chiefs     
Rollers     4-2 TAFIC
[Nov 5]
Gaborone U. 0-1 Gunners     
Comets      0-1 Prisons     
ECCO City   1-0 Satmos     
Notwane     6-2 Santos     

Round 9
[Nov 11]
Satmos      1-1 Comets     
Prisons     2-3 Gunners    
Santos      1-2 BDF         
TASC        0-2 Rollers     
Police      0-2 BMC 
[Nov 12]
Nico U.     1-4 ECCO City   
TAFIC       1-6 Notwane  
Chiefs      2-1 Gaborone U.

Round 10
[Nov 18]
Police      2-5 ECCO City   	
Notwane     5-2 TASC 
Nico U.     abd Comets            [abandoned at half-time due to darkness]
Gunners     2-1 Satmos      
BDF         1-2 TAFIC 
[Nov 19]
Prisons     0-1 Gaborone U. 
BMC         1-0 Santos      
Rollers     2-3 Chiefs     
[Jan 28, replay]
Nico U.     0-0 Comets           

Round 11
[Nov 25]
Satmos      1-1 Prisons     
Santos      0-0 Rollers    
TAFIC       0-0 BMC
Chiefs      2-0 Notwane    
Gunners     2-2 Nico U.    
[Nov 26]
Comets      1-1 Police     
TASC        1-2 ECCO City   
Gaborone U. 0-1 BDF         

Round 12
[Dec 2]
Comets      2-1 TASC 
ECCO City   abd Chiefs            [abandoned at 1-0 in injury time
Satmos      2-1 Santos             due to darkness; to be replayed]  
Prisons     2-2 Nico U.    
Police      0-0 Gunners    
[Dec 3]
BDF         0-0 Notwane    
Rollers     0-1 BMC 
TAFIC       0-0 Gaborone U.
[Jan 27, replay]
ECCO City   3-2 Chiefs   

Round 13
[Dec 9]
Gaborone U. 1-4 ECCO City   
BMC         4-0 TASC
Prisons     1-2 TAFIC          
Nico U.     3-1 Satmos     
[Dec 10]
Chiefs      3-1 BDF        
Santos      2-1 Comets   
Notwane     4-2 Rollers      

Round 14
[Dec 16]
Nico U.     1-2 Gaborone U.
Chiefs      0-0 BMC       
Notwane     0-2 Prisons
TAFIC       1-1 Comets        
[Dec 17]
Satmos      1-0 Police     
Gunners     n/p Santos            [match officials dns]
[Jan 13]
TASC        1-1 BDF  
[Jan 28]
Gunners     1-2 Santos

Round 15
[Jan 13]    
Gunners     2-2 TAFIC
Comets      0-3 Chiefs     
ECCO City   0-0 Rollers    
Nico U.     2-0 Police  
[Jan 14]
Santos      0-1 Prisons     
Notwane     1-0 BMC
[Jan 27]
Gaborone U. n/p Satmos  

Moved Matches
[Jan 19]
Police      1-1 Chiefs
[Jan 20]
BMC         1-0 Comets
TASC        4-3 Gaborone U.
Santos      1-5 ECCO City
BDF         2-1 Gunners
[Jan 21]
Rollers     1-1 Nico U.
[Jan 28]
BDF         1-0 Prisons

Round 16 
[Feb 2]
Chiefs      1-2 Comets
[Feb 3]
Prisons     0-2 Santos
Rollers     3-0 ECCO City
Satmos      1-4 Gaborone U.
TAFIC       1-2 Gunners
BDF         3-1 TASC
Police      6-2 Nico U.
[Apr 17]
BMC         2-2 Notwane           [award of 2-0 revoked]

Round 17
[Feb 10]
ECCO City   0-3 Santos
Nico U.     1-1 Rollers
Comets      1-1 TAFIC
[Feb 11]
Prisons     0-1 BDF
Gaborone U. 2-1 TASC

Round 18
[Feb 17]
Santos      2-1 Gunners
Police      2-1 Satmos 
BMC         0-1 Chiefs
Gaborone U. 1-0 Nico U.

Moved Matches [Feb 21]
BDF         1-1 Chiefs
Comets      0-2 BMC

Round 19 
[Feb 24]
Satmos      1-1 Nico U.
Comets      2-0 Santos      
ECCO City   2-1 Gaborone U.
[Feb 25]
Gunners     1-2 Police 
Rollers     1-1 Notwane           [award of 2-0 revoked]
TAFIC       2-1 Prisons

Round 20
[Mar 3]
Gaborone U. 3-2 TAFIC
BMC         2-0 Rollers
Notwane     1-1 BDF 
Nico U.     3-2 Prisons 
Santos      2-0 Satmos 
TASC        2-2 Comets
[Mar 4]
Chiefs      1-4 ECCO City 

Round 21
[Mar 9]
Prisons     1-1 Satmos 
[Mar 10]
ECCO City   1-0 TASC
Police      2-0 Comets 
Nico U.     1-1 Gunners 
BDF         4-0 Gaborone U. 
[Mar 11]
Rollers     0-3 Santos

Round 22
[Mar 16]
Police      4-2 ECCO City 
[Mar 17]
Chiefs      2-2 Rollers 
TASC        2-1 Notwane 
Satmos      1-0 Gunners 
Comets      1-0 Nico U.
[Mar 18]
Santos      3-1 BMC 
TAFIC       0-1 BDF 
Gaborone U. 2-1 Prisons

Round 23
[Mar 31]
Notwane     2-0 TAFIC             [award of 0-2 revoked]
Rollers     0-0 TASC
Comets      2-0 Satmos 
BDF         3-0 Santos
[Apr 1]
ECCO City   3-1 Nico U. 
Gunners     1-0 Prisons 

Round 24
[Apr 5]
Gunners     0-2 Gaborone U. 
[Apr 7]
Nico U.     0-0 BMC 
TAFIC       2-3 Rollers 
Chiefs      2-1 TASC 
Police      1-0 BDF 
[Apr 8]
Satmos      0-2 ECCO City
Prisons     2-2 Comets 

Round 25
[Apr 13]	
Comets      0-2 Gunners 
[Apr 14]
BDF         2-0 Nico U.
TASC        1-1 Santos 
ECCO City   1-1 Prisons 
Police      2-3 TAFIC 

Round 26
[Apr 20]
Santos      0-3 Chiefs 
[Apr 21]
TAFIC       0-1 TASC 
Nico U.     1-3 Notwane      
Gunners     1-2 ECCO CITY
Rollers     0-2 Police 
Prisons     1-1 BMC 
[Apr 22]
Satmos      1-5 BDF 
Gaborone U. 3-2 Comets

Round 27
[Apr 27]
Gunners     1-1 BMC               [at Jwaneng]
[Apr 28]
Nico U.     3-1 Chiefs 
TAFIC       1-0 Santos 
Comets      0-3 ECCO City
Notwane     2-1 Satmos        
[Apr 29]
TASC        1-1 Police 

[May 1]
Gaborone U. 2-1 Chiefs

Round 28
[May 5]
Chiefs      4-0 Police
Satmos      1-3 Rollers
TAFIC       2-0 ECCO City 
Gunners     1-2 TASC 
[May 6]
Gaborone U. 0-3 Notwane 

Round 29
[May 11]
Rollers     3-0 Gaborone U.
[May 12]
Chiefs      4-3 TAFIC
BMC         0-1 Satmos
Gunners     1-1 BDF
Santos      2-1 Notwane
TASC        1-2 Nico U.
[May 13]
Gaborone U. 1-0 Satmos
BMC         2-1 TAFIC
Prisons     2-4 Police

Moved Matches
[May 16]
Notwane     1-2 Chiefs
[May 17]
BDF         0-2 Rollers

Moved Matches
[May 19]
Chiefs      9-0 Satmos
Santos      0-2 Gaborone U. 
ECCO City   4-1 BMC 
[May 20]
TASC        1-1 BMC
Rollers     0-2 Prisons
BDF         1-0 Comets
Notwane     1-1 Gunners

Round 30
[May 24]
Chiefs      3-2 Gunners 
[May 25]
Rollers     0-1 Comets
[May 26]
Notwane     1-2 ECCO City         [in Francistown]
Santos      0-1 Nico U. 
BDF         1-1 BMC 
TAFIC       3-0 Satmos 
Gaborone U. 1-1 Police
[May 27]
TASC        2-0 Prisons 

Moved Match [May 29]
Notwane     0-0 Police

Moved Matches [Jun 2]
Police      4-3 Santos
ECCO City   1-1 BDF 
Notwane     1-2 Prisons
Satmos      0-5 TASC              

[Jun 9]
BMC         1-2 Gaborone U. 
Nico U.     2-2 TAFIC 
Comets      2-0 Notwane 
Rollers     2-1 Gunners 
[Jun 10]
Prisons     0-6 Chiefs 
BMC         2-1 Police 

Final Table:

 1.ECCO City Green (Francistown)            30 21  4  5 65-37 67  Champions
 2.Centre Chiefs (Mochudi)                  30 19  5  6 72-36 62
 3.Botswana Defence Force XI (Mogoditshane) 30 16  9  5 43-25 57
 4.Gaborone United (Gaborone)               30 14  6 10 41-43 48
 5.Police XI (Otse)                         30 12 10  8 47-42 46
 6.Botswana Meat Commission (Lobatse)       30 11 11  8 32-26 44
 7.Notwane FC (Gaborone)                    30 11  9 10 49-36 42
 8.Township Rollers (Gaborone)              30 11  9 10 43-36 42
 9.TAFIC (Francistown)                      30 10  8 12 40-45 38
10.Nico United (Selebi Phikwe)              30  8 11 11 38-46 35
11.Uniao Flamengo Santos (Gaborone)         30 10  5 15 37-47 35
12.TASC (Francistown)                       30  9  7 14 37-44 34
13.Lobtrans Gunners (Lobatse)               30  7 10 13 31-40 31
 - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
14.Jwaneng Comets                           30  7 10 13 28-40 31  Relegation Playoff
----------------------------------------------------------------
15.Prisons XI (Gaborone)                    30  5  9 16 27-47 24  Relegated
16.FC Satmos (Selebi Phikwe)                30  4  7 19 24-64 19  Relegated

NB: Notwane had had 3 matches awarded 0-2 against them for playing 
    Thebeetsile Raditsebe, who was ineligible for being transferred 
    outside of the transfer window; this decision was revoked on
    appeal

Topscorers:

22 Pontsho ‘Piro’ Moloi (Mochudi Centre Chiefs)
21 Tshepiso ‘Sox’ Molwantwa (Notwane)


Promotion/Relegation Playoff

[Jun 16, Otse]
Naughty Boys          2-1 Motlakase
[Jun 17, Molepolole]
Comets                2-0 Motlakase
[Jun 20, Gaborone]
Naughty Boys          0-5 Comets    
[Jun 23,24, Mahalapye]
Motlakase             0-4 Comets
Motlakase             0-4 Naughty Boys 
[Jul 1, Jwaneng]
Comets                2-2 Naughty Boys       

Final Table:

 1.Jwaneng Comets                            4  3  1  0 13- 2 10
----------------------------------------------------------------
 2.Naughty Boys (Tlokweng)                   4  2  1  1  8- 8  7
 3.Motlakase (Palapye)                       4  0  0  2  1-12  0

NB: all clubs remain in the respective divisions



Author: Emmanuel Thekiso
(thekiso@yahoo.co)

Last updated: 14 Sep 2010

(C) Copyright Emmanuel Thekiso and RSSSF 2006/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,255,944 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0032
Controller Execution Time ( Home / Category )  0.0977
Total Execution Time  0.1010
  CADENA URL  
/liga_botsuana2007
  GET DATOS  
$_GET['/liga_botsuana2007']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (35)  
0.0017  SELECT type FROM routes WHERE alias = 'liga_botsuana2007'
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 = 2007 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=1 DESC LIMIT 1
0.0017  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=329 AND type_rel = 3
0.0020  SELECT text_es as historical_text FROM leagues_text WHERE id=128
0.0020  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 = 28419 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='2007' WHERE c.parentId=329 GROUP BY c.id ORDER BY c.order_id ASC
0.0019  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-05-01 16:34: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-05-01 16:34: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-05-01 16:34: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=3 AND last_update > '2024-05-01 16:34:14' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0033  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 = 2007 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=0 DESC LIMIT 1
0.0019  SELECT e.action, count(e.action) as total, e.player_id FROM events2007 e WHERE e.league_id IN (28419) 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 (28419) 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 events2007 e WHERE e.league_id IN (28419) 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 (28419) 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 events2007 e WHERE e.league_id IN (28419) AND (e.action IN (3,4) ) GROUP BY e.player_id ORDER BY total DESC, e.player_id ASC LIMIT 20
0.0021  SELECT dp.name, dp.last_name, dp.nick,dp.CountryCode,dp.alias,rp.team_id,dt.nameShow,dt.short_name,dt.basealias,rp.player_id,rp.teamId,dp.role FROM dataplayers AS dp INNER JOIN rel_players AS rp ON rp.player_id=dp.id AND rp.league_id IN (28419) 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 events2007 e WHERE e.league_id IN (28419) AND (e.action IN (22) ) 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 (28419) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN () ORDER BY rp.in_squad = 1 DESC
0.0018  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 = 28419 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 = 28419 AND rp.events > 0 ORDER BY rp.events DESC,p.pod DESC LIMIT 20
0.0021  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=28419 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 = 28419 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 = 28419 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` = 28419 ORDER BY creation_date DESC LIMIT 0, 10
0.0024  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` = 28419
0.0021  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 `calendars2007` 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` = 28419 AND c.`round` = 30 ORDER BY shedule ASC LIMIT 200
0.0019  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 `events2007` e INNER JOIN calendars2007 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 = 28419 ORDER BY total DESC LIMIT 40
0.0023  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 `events2007` e INNER JOIN calendars2007 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 = 28419 AND e.real_date > NOW() - INTERVAL 1 MONTH ORDER BY e.real_date DESC LIMIT 30
0.0041  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 `tables2007` 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 = 28419 AND t.round = 28 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0041  SELECT *,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables2007` 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 = 28419 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0041  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 = 28419 ORDER BY c.shedule ASC, fcoef DESC LIMIT 5
0.0041  SELECT data1, data2 FROM services_tags WHERE categoryId=329
0.0041  SELECT l.year,l.group_code FROM leagues_besoccer l WHERE l.categoryId = 329 AND l.year = 2007 ORDER BY l.group_code ASC
0.0041  SELECT group_code, extraName from `leagues` WHERE categoryId=329 AND year=2007