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 Burkina Faso 2009
2008/2009

Liga Burkina Faso 2009

Información Histórica 
						

Championnat National de 1ère Division
=====================================

Participants:

From administrative region CENTRE, city of OUAGADOUGOU:
Commune Football Club                                      10-4-1977 Stade du 4 Août  40.000
Etoile Filante de Ouagadougou                                   1955 Stade du 4 Août  40.000
Union Sportive des Forces Armées (1)                            1962 Stade de l'USFA   9.000
Union Sportive de Ouagadougou                                 7-1961 Stade Municipal  15.000
Association Sportive du Faso/Yennenga (2)                       1947 Stade du 4 Août  40.000
Rail Club du Kadiogo (3)                                      9-1967 Stade du Kadiogo  8.000

From administrative region HAUTS-BASSINS, city of BOBO-DIOULASSO:
Racing Club de Bobo                                           6-1949 Stade Municipal  30.000
Association Sportive des Fonctionnaires de Bobo-Dioulasso  20-4-1948 Stade Municipal  30.000
Bobo Sport                                                      1947 Stade Wobi       10.000

From administrative region NORD, city of OUAHIGOUYA:
Union Sportive du Yatenga (4)    

From administrative region CASCADES, city of BANFORA:
Union Sportive de la Comoé                                      1985 Stade Banfora     6.000

From administrative region CENTRE-OUEST, city of KOUDOUGOU:
Bouloumpoukou Football Club

From administrative region BOUCLE DU MOUHOUN, city of TOUGAN:
Sourou Sport                                                         Stade Sangoulé-Lamizana

From administrative region CENTRE-EST, city of KOUPÈLA:
AS Koupèla                                                           Stade Provincial [*}   

[*] the stade provincial de Koupéla was finished on 27 March 2009; until then,
    AS Koupèla hosted matches in Zorgho; it was inaugurated on 18 April 2009
    with the match between AS Koupèla and RC Bobo in round 16

(1) Older names ASFAV, ASFAN, ASFAP and USFAN.
(2) Founded in 1947 as Jeanne d'Arc. Later renamed to ASFA-Yennenga
(3) Founded in 1967 as ASFRAN. In 1989 was renamed to RC Kadiogo
(4) Merger between Stade Yatenga and a smaller team

Final Table:

 1.AS Faso/Yennenga    26 17  9  0 39- 8 60  Champions
 2.Etoile Filante      26 15  7  4 44-20 52
 3.Rail Club Kadiogo   26 10 13  3 20-13 43
 4.Racing Club Bobo    26 10 10  6 31-19 40
 5.US Forces Armées    26  9 12  5 30-20 39
 6.Commune FC          26  8 13  5 21-16 37  Relegation Playoff
 7.US Ouagadougou      26  9  9  8 27-20 36  Relegated
 8.Bobo Sport          26  9  9  8 25-28 36
 9.US Comoé            26  8  6 12 13-24 30
10.Sourou Sport        26  4 10 12 15-21 22
11.AS Koupèla          26  3 13 10  8-23 22  [*]
12.Bouloumpoukou FC    26  4  9 13 13-34 21
- - - - - - - - - - - - - - - - - - - - - -
13.US Yatenga          26  3 10 13 12-28 19  Relegation Playoff
-------------------------------------------
14.ASF Bobo-Dioulasso  26  3 10 13 10-34 19  Relegated

[*] played home matches in Zorgho until Mar 27, 2009

Ouagadougou Clubs Table:

 1.AS Faso/Yennenga    26 17  9  0 39- 8 60  Champions
 2.Etoile Filante      26 15  7  4 44-20 52
 3.Rail Club Kadiogo   26 11 12  3 21-13 45
 4.US Forces Armées    26  9 12  5 30-20 39
- - - - - - - - - - - - - - - - - - - - - -
 5.Commune FC          26  8 13  5 21-16 37  Relegation Playoff
-------------------------------------------
 6.US Ouagadougou      26  9  9  8 27-20 36  Relegated

NB: as the second division is won by a club from Ouagadougou, they
    will play off against Commune for a place at the top level 2009/10

Round 1
[Dec 27]
ASFA/Y          2-0 USY
  [Marcellin Nikiéma 33og, Abdoul Rasmané Diarra ~50]
Etoile Filante  6-0 Bobo Sport
  [Eric Soulama (3), Saïdou Sandaogo, Drissa Diabaté, Moussa Yedan]
ASFB            0-0 RC Kadiogo
Bouloumpoukou   0-1 US Comoé
[Dec 28]
CF Ouagadougou  0-1 Sourou Sport
USFA            6-0 AS Koupèla
RC Bobo         1-0 US Ouagadougou

Round 2
[Jan 2]
US Ouagadougou  3-0 Bouloumpoukou
[Jan 4]
RC Kadiogo      1-0 RC Bobo
AS Koupèla      1-0 ASFB            
Sourou Sport    1-2 USFA
Bobo Sport      1-0 CF Ouagadougou
USY             0-0 Etoile Filante
US Comoé        0-0 ASFA/Y

Round 3
[Jan 10]
Etoile Filante  0-2 ASFA/Y
  [Usman Muhamad 49, Issouf Ouattara 81]
ASFB            0-0 Sourou Sport  
Bouloumpoukou   0-5 RC Kadiogo
[Jan 11]
CF Ouagadougou  1-0 USY     
USFA            3-0 Bobo Sport  
[Jan 14]
USO             2-0 USCO
RC Bobo         3-0 AS Koupèla 

Round 4
[Jan 17]
ASFA/Y          1-1 CF Ouagadougou
  [Ocansey Mandela 85; Anyeka Onwuekelu 26]
AS Koupèla      2-0 Bouloumpoukou 
Sourou Sport    1-1 RCB
Bobo Sport      0-1 ASFB 
USY             1-1 USFA
USCO            1-1 Etoile Filante  
[Jan 18]
RC Kadiogo      0-0 USO 

Round 5
[Jan 24]
USO             0-0 AS Koupèla
RC Kadiogo      1-0 USCO
ASFB            1-1 USY
Bouloumpoukou   2-1 Sourou Sport
[Jan 25]
CF Ouagadougou  0-2 Etoile Filante
USFA            0-2 ASFA/Y
RCB             0-0 Bobo Sport

Round 6
[Feb 1]
ASFA/Y          1-0 ASFB 
AS Koupèla      0-0 RCK
Bobo Sport      4-0 Bouloumpoukou  
USY             1-2 RCB 
USCO            1-2 CF Ouagadougou
[Feb 4]
Sourou Sport    0-0 USO
Etoile Filante  2-1 USFA

Round 7
[Feb 7]
USO             0-2 Bobo Sport 
RCK             1-0 Sourou Sport 
  [Abdoul Wahab Sawadogo 28]
AS Koupèla      0-0 USCO 
ASFB            2-1 Etoile Filante
Bouloumpoukou   0-0 USY
[Feb 8]
USFA            0-0 CF Ouagadougou
[Feb 18]
RCB             1-1 ASFA/Y   

Round 8
[Feb 14]
ASFA/Y          2-0 Bouloumpoukou 
CF Ouagadougou  4-0 ASFB 
Sourou Sport    0-0 AS Koupèla
Bobo Sport      0-0 RCK 
USCO            0-2 USFA 
[Feb 25]
Etoile Filante  2-2 RCB 
USY             0-1 USO 

Round 9
[Feb 21]
Sourou Sport	1–0 USCO
AS Koupèla	0-1 Bobo Sport
USO		1–2 ASFA/Y
Bouloumpoukou	3–3 Etoile Filante
  [Adama Yaméogo 26, Junior Ouédraogo 36, 43;
   Georges Bonou 55, 90+3, Saïdou Sandaogo 76]
ASFB		1–1 USFA
[Feb 22]
RCK 		1–0 USY
RCB		1–1 CF Ouagadougou

Round 10
[Mar 1]
ASFA/Y          1-0 RCK
  [Mohamed Coulibaly 9] 
Etoile Filante  3-1 USO 
  [Dramane Nikiéma 11, Constant Kambou 60, Eric Soulama 63;
   Jules Latevi 27pen]
USY             2-0 AS Koupèla
USCO            1-0 ASFB 
Bobo Sport      2-0 Sourou Sport 
[Mar 2]
CF Ouagadougou  0-0 Bouloumpoukou      [also reported 1-1]
USFA            0-2 RCB

Round 11 
[Mar 8]
USO             0-0 CF Ouagadougou 
RCK             1-0 Etoile Filante 
AS Koupèla      0-0 ASFA/Y            
Sourou Sport    1-1 USY
Bobo Sport      0-1 USCO
Bouloumpoukou   0-1 USFA
[Mar 9]
RCB             0-0 ASFB

Round 12
[Mar 14]
ASFA/Y          2–1 Sourou Sport
ASFB            0–0 Bouloumpoukou  
USY             1–2 Bobo Sport
USCO            1–0 RCB
[Mar 15]
CF Ouagadougou  1–1 RCK  
[Mar 27]
USFA            2–1 USO 
[Mar 29]
Etoile Filante  2–1 AS Koupèla  

Round 13
[Mar 21]
USO             4-0 ASFB 
AS Koupèla      0-0 CF Ouagadougou   
Sourou Sport    0-1 Etoile Filante
USY             1-0 USCO 
Bouloumpoukou   1-0 RCB 
Bobo Sport      0-1 ASFA/Y
[Mar 22]
RCK             2-0 USFA 

Round 14
[Apr 4]
USY             0-0 ASFA/Y
RC Kadiogo      1-0 ASFB
US Comoé        1-0 Bouloumpoukou
Sourou Sport    0-1 CF Ouagadougou
[Apr 8]
Bobo Sport      0-1 Etoile Filante
[Apr 15]
US Ouagadougou  2-2 RC Bobo
[Apr 22]
AS Koupèla      1-1 USFA

Round 15
[Apr 11]
Bouloumpoukou   0-2 US Ouagadougou
RC Bobo         1-2 RC Kadiogo
CF Ouagadougou  1-1 Bobo Sport
[Apr 13]
ASFB            1-0 AS Koupèla
Etoile Filante  4-0 USY
  [Oumarou Nébié 1, Jean-Noël Lingani 2-0, Henri Traoré 24,
   Seidou Idrissa 89]
ASFA/Y          2-0 US Comoé
  [Amsa Ouédraogo 62, Issouf Ouattara 87]
[Apr 29]
USFA            0-0 Sourou Sport

Round 16
[Apr 18]
ASFA/Y          0-0 Etoile Filante
Sourou Sport    4-0 ASFB
USCO            0-0 USO
AS Koupèla      0-0 RC Bobo
Bobo Sport      1-1 USFA
[Apr 19]
RC Kadiogo      0-0 Bouloumpoukou
USY             1-1 CF Ouagadougou

Round 17
[Apr 25]
CF Ouagadougou  1-1 ASFA/Y
Bouloumpoukou   2-0 AS Koupèla
  [Rodrigue Tiendrébéogo 45+, Abraham Konseibo 66]
RCB             1-0 Sourou Sport
USO             1-1 RC Kadiogo
[Apr 26]
ASFB            1-1 Bobo Sport
USFA            4-1 USY
Etoile Filante  3-0 USCO

Round 18 
[May 2]
AS Koupèla      0-0 USO
USCO            0-1 RCK 
Etoile Filante  1-0 CF Ouagadougou 
USY             0-0 ASFB
Bobo Sport      2-3 RCB 
Sourou Sport    0-0 Bouloumpoukou  
[May 3]
ASFA/Y          3-1 USFA 

Round 19 [May 9,10]
ASFB            1-3 ASFA/Y     
USFA            0-0 Etoile Filante 
RCK             0-0 AS Koupèla   
USO             1-0 Sourou Sport 
Bouloumpoukou   1-3 Bobo Sport
RCB             2-0 USY 
CF Ouagadougou  1-1 USCO

Round 20
[May 16]
Bobo Sport      1-0 USO
Sourou Sport    abd RCK                [abandoned at 1-0 due to rain]
USCO            1-0 AS Koupèla   
USY             0-1 Bouloumpoukou  
CF Ouagadougou  0-0 USFA 
Etoile Filante  2-0 ASFB 
[May 17]
ASFA/Y          1-0 RCB 
[May 27]
Sourou Sport    0-0 RCK                [replay]

Round 21
[May 23]
Bouloumpoukou   1-2 ASFA/Y 
RCB             1-0 Etoile Filante
AS Koupèla      0-1 Sourou Sport 
RCK             0-0 Bobo Sports    
USO             1-0 USY 
[May 24]
ASFB            0-1 CF Ouagadougou 
USFA            1-0 USCO 

Round 22
[May 30]
ASFA/Y          1-0 USO 
Etoile Filante  1-0 Bouloumpoukou 
USY             0-0 RCK
Bobo Sports     1-1 AS Koupèla
USCO            1-0 Sourou Sport
[May 31]
USFA            1-0 ASFB 
CFO             1-0 RCB 

Round 23 [Jun 6,7]
RCK             0-5 ASFA/Y  
USO             2-4 Etoile Filante 
AS Koupèla      1-0 USY     
ASFB            1-1 USCO
Sourou Sport    1-1 Bobo Sport  
Bouloumpoukou   0-1 CF Ouagadougou 
RCB             0-0 USFA

Round 24 [Jun 13,14]
CFO             0-2 USO 
Etoile Filante  0-0 RCK
ASFA/Y          0-0 AS Koupèla 
USY             1-0 Sourou Sport
USCO            0-1 Bobo Sport
ASFB            0-3 RCB 
USFA            0-0 Bouloumpoukou 

Round 25 
[Jun 21]
Sourou Sport    0-0 ASFA/Y
Bouloumpoukou   1-1 ASFB
Bobo Sport      1-1 USY
RCB             4-1 USCO
AS Koupèla      1-2 Etoile Filante
[Jun 22]
RCK             1-3 CF Ouagadougou
USO             1-1 USFA

Round 26 [Jun 27]
ASFB            0-2 USO             
CF Ouagadougou  0-0 AS Koupèla      
Etoile Filante  3-2 Sourou Sport    
USCO            1-0 USY             
RCB             1-1 Bouloumpoukou   
ASFA/Y          4-0 Bobo Sport
USFA            1-1 RCK

Final Table:

 1.AS Faso/Yennenga    26 17  9  0 39- 8 60  Champions
 2.Etoile Filante      26 15  7  4 44-20 52
 3.Rail Club Kadiogo   26 10 13  3 20-13 43
 4.Racing Club Bobo    26 10 10  6 31-19 40
 5.US Forces Armées    26  9 12  5 30-20 39
 6.Commune FC          26  8 13  5 21-16 37  Relegation Playoff
 7.US Ouagadougou      26  9  9  8 27-20 36  Relegated
 8.Bobo Sport          26  9  9  8 25-28 36
 9.US Comoé            26  8  6 12 13-24 30
10.Sourou Sport        26  4 10 12 15-21 22
11.AS Koupèla          26  3 13 10  8-23 22  [*]
12.Bouloumpoukou FC    26  4  9 13 13-34 21
- - - - - - - - - - - - - - - - - - - - - -
13.US Yatenga          26  3 10 13 12-28 19  Relegation Playoff
-------------------------------------------
14.ASF Bobo-Dioulasso  26  3 10 13 10-34 19  Relegated

[*] played home matches in Zorgho until Mar 27, 2009

Ouagadougou Clubs Table:

 1.AS Faso/Yennenga    26 17  9  0 39- 8 60  Champions
 2.Etoile Filante      26 15  7  4 44-20 52
 3.Rail Club Kadiogo   26 11 12  3 21-13 45
 4.US Forces Armées    26  9 12  5 30-20 39
- - - - - - - - - - - - - - - - - - - - - -
 5.Commune FC          26  8 13  5 21-16 37  Relegation Playoff
-------------------------------------------
 6.US Ouagadougou      26  9  9  8 27-20 36  Relegated

NB: as the second division is won by a club from Ouagadougou, they
    will play off against Commune for a place at the top level 2009/10

Ouagadougou Promotion/Relegation Playoff

First Leg
AS Sonabel      0-1 CF Ouagadougou  

Second Leg [Dec 5, stade du 4-aout, Ouagadougou]
CF Ouagadougou  0-1 AS Sonabel      [4-5 pen]
  [Madi Ouédraogo 27]

NB: AS Sonabel promoted, CF Ouagadougou relegated



Topscorers:

13 Ocansey Mandela (ASFA/Y) 
   Eric Soulama (EFO)




Author: José Batalha
(jose.batalha@netvisao.pt)

Last updated: 15 Jan 2010

(C) Copyright José Batalha and RSSSF 2009/10


  USO DE MEMORIA  
4,304,360 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0019
Controller Execution Time ( Home / Category )  0.1148
Total Execution Time  0.1168
  CADENA URL  
/championnat_national_burkina_faso2009
  GET DATOS  
$_GET['/championnat_national_burkina_faso2009']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (36)  
0.0017  SELECT type FROM routes WHERE alias = 'championnat_national_burkina_faso2009'
0.0039  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'championnat_national_burkina_faso' 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=510 AND type_rel = 3
0.0023  SELECT text_es as historical_text FROM leagues_text WHERE id=346
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 = 28660 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='2009' WHERE c.parentId=510 GROUP BY c.id ORDER BY c.order_id ASC
0.0018  SELECT type,rule FROM rules WHERE categoryId = 510 ORDER BY type = 'tables_draw' DESC,type != 'extra' DESC, `order` ASC
0.0019  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-04-26 13:58:08' 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-26 13:58:08' 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-26 13:58:08' 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-04-26 13:58:08' 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 = 'championnat_national_burkina_faso' 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.0019  SELECT e.action, count(e.action) as total, e.player_id FROM events2009 e WHERE e.league_id IN (28660) 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 (28660) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN () ORDER BY rp.in_squad = 1 DESC
0.0023  SELECT e.action, count(e.action) as total, e.player_id FROM events2009 e WHERE e.league_id IN (28660) AND (e.action IN (4,5) ) GROUP BY e.player_id ORDER BY total DESC, e.player_id ASC LIMIT 20
0.0025  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 (28660) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN () ORDER BY rp.in_squad = 1 DESC
0.0028  SELECT e.action, count(e.action) as total, e.player_id FROM events2009 e WHERE e.league_id IN (28660) AND (e.action IN (3,4) ) GROUP BY e.player_id ORDER BY total DESC, e.player_id ASC LIMIT 20
0.0025  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 (28660) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN () ORDER BY rp.in_squad = 1 DESC
0.0028  SELECT e.action, count(e.action) as total, e.player_id FROM events2009 e WHERE e.league_id IN (28660) AND (e.action IN (22) ) GROUP BY e.player_id ORDER BY total DESC, e.player_id ASC LIMIT 20
0.0024  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 (28660) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN () ORDER BY rp.in_squad = 1 DESC
0.0024  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 = 28660 AND rp.lineup > 0 ORDER BY rp.lineup DESC,p.pod DESC LIMIT 20
0.0021  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 = 28660 AND rp.events > 0 ORDER BY rp.events DESC,p.pod DESC LIMIT 20
0.0043  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=28660 AND rel.round=26
0.0037  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 = 28660 AND esl.points > 0 ORDER BY esl.points DESC LIMIT 3
0.0031  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 = 28660 AND esl.points > 0
0.0029  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-27" AND c.`active`= 1 and c.comment_id is null and c.lang = 1 AND l.`id` = 28660 ORDER BY creation_date DESC LIMIT 0, 10
0.0043  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-27" AND c.`active`= 1 and comment_id is null and c.lang = 1 AND l.`id` = 28660
0.0028  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` = 28660 AND c.`round` = 26 ORDER BY shedule ASC LIMIT 200
0.0020  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 = 26 AND e.real_date IS NOT NULL AND e.league_id = 28660 ORDER BY total DESC LIMIT 40
0.0055  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 = 28660 AND e.real_date > NOW() - INTERVAL 1 MONTH ORDER BY e.real_date DESC LIMIT 30
0.0037  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 = 28660 AND t.round = 24 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0037  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 = 28660 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0037  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-26 00:00:00' AND c.`shedule` < '2024-04-30 23:59:59' AND l.id = 28660 ORDER BY c.shedule ASC, fcoef DESC LIMIT 5
0.0037  SELECT data1, data2 FROM services_tags WHERE categoryId=510
0.0037  SELECT l.year,l.group_code FROM leagues_besoccer l WHERE l.categoryId = 510 AND l.year = 2009 ORDER BY l.group_code ASC
0.0037  SELECT group_code, extraName from `leagues` WHERE categoryId=510 AND year=2009