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

Liga Burkina Faso 2008

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 de la SONABEL (2)                          1990 Stade SONABEL     5.000
Association Sportive du Faso/Yennenga (3)                       1947 Stade du 4 Août  40.000
Rail Club du Kadiogo (4)                                      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 (5)    

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 CENTRE-EST, city of TENKODOGO:
Boulgou Football Club

(1) Older names ASFAV, ASFAN, ASFAP and USFAN.
(2) SONABEL means Société Nationale d'Électricité du Burkina Faso
(3) Founded in 1947 as Jeanne d'Arc. Later renamed to ASFA-Yennenga
(4) Founded in 1967 as ASFRAN. In 1989 was renamed to RC Kadiogo
(5) Merger between Stade Yatenga and a smaller team

Final Table:

 1.Etoile Filante de Ouagadougou               26  14 11  1  41-13  53  Champions  [EFO]
 2.US de Ouagadougou                           26  14  7  5  43-15  49  [USO]
 3.AS du Faso/Yennenga (Ouagadougou)           26  13  9  4  32-14  48  [ASFA/Y]
 4.Racing Club Bobo-Dioulasso                  26  13  6  7  34-22  45  [RCB]
 5.Commune FC (Ouagadougou)                    26  11  9  6  28-21  42  [CFO]
 6.Bouloumpoukou FC (Koudougou)                26  12  6  8  29-23  42  [BPFC]
 7.US des Forces Armées (Ouagadougou)          26   9  9  8  24-20  35  [USFA]
 8.Rail Club du Kadiogo (Ouagadougou)          26   7 10  9  20-20  32  [RCK]
 9.US de la Comoé (Banfora)                    26   7  9 10  19-24  30  [USCO]
10.AS de la SONABEL (Ouagadougou)              26   6 11  9  23-25  29
11.US du Yatenga (Ouahigouya)                  26   5 10 11  19-37  25  [USY]
12.AS des Fonctionnaires de Bobo-Dioulasso     26   6  6 14  15-30  24  [ASFB]
 - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
13.Bobo Sport (Bobo-Dioulasso)                 26   3  8 15  17-35  17  Relegation Playoff Bobo-Dioulasso
----------------------------------------------------------------------
14.Boulgou FC (Tenkodogo)                      26   3  7 16  13-58  16  Relegated

NB: the worst club from Ouagadougou is also relegated:

Ouagadougou Final Table:

 1.Etoile Filante de Ouagadougou               26  14 11  1  41-13  53  Champions  [EFO]
 2.US de Ouagadougou                           26  14  7  5  43-15  49  [USO]
 3.AS du Faso/Yennenga (Ouagadougou)           26  13  9  4  32-14  48  [ASFA/Y]
 4.Commune FC (Ouagadougou)                    26  11  9  6  28-21  42  [CFO]
 5.US des Forces Armées (Ouagadougou)          26   9  9  8  24-20  35  [USFA]
 6.Rail Club du Kadiogo (Ouagadougou)          26   7 10  9  20-20  32  [RCK]
----------------------------------------------------------------------
 7.AS de la SONABEL (Ouagadougou)              26   6 11  9  23-25  29  Relegated

Round 1
[Dec 15]
CFO     2-0 Boulgou
  [Bakary Dossama 37, Yacouba Lamoukry 88]
USO     1-2 RCB     
  [Sundy Zongo 83; Issiaka Tapsoba 37, Issouf Ouattara 90+]
ASFB    0-1 RCK
USCO    2-2 BPFC
[Dec 16]
USFA    1-1 USY
SONABEL 1-1 ASFA/Y
Bobo S. 0-1 EFO

Round 2 
[Dec 22]
EFO     3–1 USCO 
RCK     2–0 Bobo S.
[Dec 23]
RCB     1–2 USFA
Boulgou 0–4 USO
USY     0–0 SONABEL 
BPFC    2–1 CFO 
ASFA/Y  2–0 ASFB

Round 3
[Dec 29]
EFO     2–1 BPFC
  [Oumarou Nébié 33, Saïdou Sandaogo 70; Rodrigue Tiendrébéogo 47]
USO     0–0 CFO
ASFB    3–0 USY
USCO    0–0 RCK
[Dec 30]
USFA    3–0 Boulgou
SONABEL 0–2 RCB
Bobo S. 0–2 ASFA/Y

Round 4 
[Jan 5]
RCB     1-0 ASFB
ASFA/Y  0-0 USCO
CFO     1-1 USFA
  [Abdoul Sanou 3; Issiaka Ouédraogo 83]
USY     0-0 Bobo S.
Boulgou 0-0 SONABEL 
BPFC    0-0 USO
[Jan 6]
RCK     1-1 EFO

Round 5
[Jan 12]
RCK     0-1 BPFC
USFA    0-0 USO
ASFB    4-2 Boulgou
USCO    1-1 USY
[Jan 13]
SONABEL 2-2 CFO
EFO     1-1 ASFA/Y
Bobo S. 1-2 RCB

Round 6
[Jan 19]
CFO     2-0 ASFB
USO     2-0 SONABEL
USY     0-0 EFO
RCB     1-0 USCO
Boulgou 1-1 Bobo S.
BPFC    1-0 USFA
[Jan 20]
ASFA/Y  1-1 RCK

Round 7
[Jan 26]
RCK     3-1 USY
EFO     2-1 RCB
ASFB    2-1 USO
USCO    2-1 Boulgou 
[Jan 27]
ASFA/Y  2-1 BPFC
  [Attram Kwamé 60, 66pen; Abraham Konseibo 30]
SONABEL 0-1 USFA 
Bobo S. 0-1 CFO

Round 8
[Feb 2]
CFO     1-0 USCO
USO     4-0 Bobo S.
USY     1-0 ASFA/Y
  [Saba Issouf 30]
RCB     1-0 RCK
Boulgou 1-0 EFO
[Feb 3]
BPFC    2-1 SONABEL 
USFA    1-1 ASFB

Round 9
[Feb 9]
RCK     3-0 Boulgou
EFO     2-1 CFO
ASFB    1-0 SONABEL            [also reported 2-1]
USY     1-1 BPFC
USCO    0-1 USO
ASFA/Y  2-0 RCB
[Feb 10]
Bobo S. 0-3 USFA

Round 10
[Feb 16]
USFA    2-0 USCO
USO     1-1 EFO
  [Abdoul Rasmané Diarra 1-1; Souleymane Dela Sakou 0-1]
RCB     2-1 USY
Boulgou awd ASFA/Y             [awarded 0-3; originally 0-0]
BPFC    2-0 ASFB
[Feb 17]
SONABEL 1-1 Bobo S.
[Mar 12]
CFO     1-1 RCK                [also reported 0-0]

Round 11
[Feb 23]
EFO     1-0 USFA
  [Abdramane Diarra 21]
RCB     1-1 BPFC
RCK     1-3 USO
  [Sidiki Aboubacar Konaté 17; Rasmané Diarra 16, Yaou Illa 67,
   Ibrahim Dermé 86]
USCO    2-0 SONABEL
USY     3-0 Boulgou
[Feb 24]
ASFA/Y  1-1 CFO
Bobo S. 1-1 ASFB

Round 12
[Mar 1]
ASFB    0-2 USCO
Boulgou 2-2 RCB
BPFC    1–0 Bobo S.
[Mar 2]
SONABEL 1-1 EFO
USFA    0-0 RCK
[Mar 3]
USO     0–0 ASFA/Y
[Mar 16]
CFO     3–0 USY

Round 13
[Mar 8]
RCK     0-0 SONABEL
EFO     2-0 ASFB
RCB     3-0 CFO
USY     0-2 USO
Boulgou 1–0 BPFC
USCO    0–0 Bobo S.
[Mar 9]
ASFA/Y  1–0 USFA

Round 14
[Mar 29]
EFO     0-0 Bobo S.
ASFA-Y  1–1 SONABEL
RCB     1–0 USO
Boulgou 0-1 CFO
USY     1-1 USFA
[Mar 30]
BPFC    1–0 USCO
  [André Yaméogo 87]
RCK     0-0 ASFB

Round 15
[Apr 5]
USCO    1-2 EFO
Bobo S. 0-1 RCK
USO     7-1 Boulgou
CFO     2-0 BPFC
[Apr 6]
USFA    1-0 RCB
SONABEL 4-1 USY
ASFB    0-1 ASFA/Y

Round 16
[Apr 9]
ASFA-Y  1–0 Bobo S.
RCK     0–2 USCO
RCB     1–0 SONABEL
BPFC    0–0 EFO
Boulgou 1–0 USFA
USY     1–0 ASFB
[Apr 10]
CFO     0-1 USO

Round 17 
[Apr 13]
Bobo S. 3-1 USY
USCO    1-0 ASFA-Y
SONABEL 2-0 Boulgou
EFO     0-0 RCK
ASFB    1-0 RCB
[Apr 14]
USO     2-1 BPFC
USFA    1-3 CFO

Round 18
[Apr 26]
BPFC    1-0 RCK
USO     0-0 USFA
Boulgou 0-0 ASFB
CFO     1-1 SONABEL
RCB     3-1 Bobo S.
USY     1-1 USCO
[Apr 27]
ASFA/Y  0-0 EFO

Round 19
[May 10]
Bobo S. 2-2 Boulgou
SONABEL 1-3 USO
RCK     2-2 ASFA/Y
USCO    0-0 RCB
[May 11]
ASFB    0-0 CFO
EFO     2-0 USY
USFA    2-0 BPFC

Round 20
[May 25]
USY     0-0 RCK
RCB     2-2 EFO
Boulgou 0-0 USCO
BPFC    0-1 ASFA/Y
USFA    1-2 SONABEL
CFO     2-1 Bobo S.
[May 26]
USO     0-0 ASFB

Round 21
[Jun 1]
ASFA/Y  2–0 USY
RCK     1–0 RCB
Bobo S. 0-1 USO
USCO    1-0 CFO
[Jun 2]
EFO    10–0 Boulgou
SONABEL 2–0 BPFC
ASFB    0-1 USFA

Round 22 [Jun 8]
USO     4-0 USCO
USFA    1-2 Bobo S.
RCB     2-0 ASFA/Y 
Boulgou 0-1 RCK 
BPFC    4-1 USY
SONABEL 2-0 ASFB 
CFO     0-0 EFO 

Round 23
[Jun 14]
ASFA/Y  3-0 Boulgou 
RCK     1-2 CFO
ASFB    0-2 BPFC
USCO    0-0 USFA
USY     2-1 RCB
[Jun 15]
EFO     3-1 USO
Bobo S. 0-0 SONABEL

Round 24 [Jun 22]
USFA    0-1 EFO 
USO     2-0 RCK
CFO     1-0 ASFA/Y 
Boulgou 0-2 USY
BPFC    1-1 RCB
ASFB    2-0 Bobo S.
SONABEL 1-0 USCO 

Round 25 [Jul 5]
USCO    3-0 ASFB
RCB     1-1 Boulgou
Bobo S. 1-2 BPFC
EFO     1-0 SONABEL
  [Eric Dagbeï 7pen]
RCK     0-1 USFA
ASFA/Y  2-0 USO
USY     0-0 CFO

Round 26 [Jul 19]
SONABEL 1-1 RCK
ASFB    0-3 EFO  
CFO     0-3 RCB
USO     3-0 USY
BPFC    2-0 Boulgou 
Bobo S. 3-0 USCO
USFA    1-3 ASFA/Y

Final Table:

 1.Etoile Filante de Ouagadougou               26  14 11  1  41-13  53  Champions  [EFO]
 2.US de Ouagadougou                           26  14  7  5  43-15  49  [USO]
 3.AS du Faso/Yennenga (Ouagadougou)           26  13  9  4  32-14  48  [ASFA/Y]
 4.Racing Club Bobo-Dioulasso                  26  13  6  7  34-22  45  [RCB]
 5.Commune FC (Ouagadougou)                    26  11  9  6  28-21  42  [CFO]
 6.Bouloumpoukou FC (Koudougou)                26  12  6  8  29-23  42  [BPFC]
 7.US des Forces Armées (Ouagadougou)          26   9  9  8  24-20  35  [USFA]
 8.Rail Club du Kadiogo (Ouagadougou)          26   7 10  9  20-20  32  [RCK]
 9.US de la Comoé (Banfora)                    26   7  9 10  19-24  30  [USCO]
10.AS de la SONABEL (Ouagadougou)              26   6 11  9  23-25  29
11.US du Yatenga (Ouahigouya)                  26   5 10 11  19-37  25  [USY]
12.AS des Fonctionnaires de Bobo-Dioulasso     26   6  6 14  15-30  24  [ASFB]
 - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
13.Bobo Sport (Bobo-Dioulasso)                 26   3  8 15  17-35  17  Relegation Playoff Bobo-Dioulasso
----------------------------------------------------------------------
14.Boulgou FC (Tenkodogo)                      26   3  7 16  13-58  16  Relegated

NB: the worst club from Ouagadougou is also relegated:

Ouagadougou Final Table:

 1.Etoile Filante de Ouagadougou               26  14 11  1  41-13  53  Champions  [EFO]
 2.US de Ouagadougou                           26  14  7  5  43-15  49  [USO]
 3.AS du Faso/Yennenga (Ouagadougou)           26  13  9  4  32-14  48  [ASFA/Y]
 4.Commune FC (Ouagadougou)                    26  11  9  6  28-21  42  [CFO]
 5.US des Forces Armées (Ouagadougou)          26   9  9  8  24-20  35  [USFA]
 6.Rail Club du Kadiogo (Ouagadougou)          26   7 10  9  20-20  32  [RCK]
----------------------------------------------------------------------
 7.AS de la SONABEL (Ouagadougou)              26   6 11  9  23-25  29  Relegated



Topscorer:
16 Abdramane Diarra (EFO)



Promoted: AS Koupèla and Sourou Sport;
          JCB (2nd level champions) play off against Bobo Sport
          (worst top level clubs from Bobo-Dioulasso) due to
          restriction on number of clubs from Bobo-Dioulasso and
          Ouagadougou at top level

Promotion/Relegation Playoff Bobo-Dioulasso 

First Leg
JCB           1-2 Bobo Sport

Second Leg [Dec 1]
Bobo Sport    3-2 JCB

NB: Bobo Sport remain at 1st level, JCB at 2nd level



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

Last updated: 9 Jul 2009

(C) Copyright José Batalha and RSSSF 2007/09


  USO DE MEMORIA  
4,304,176 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0036
Controller Execution Time ( Home / Category )  0.1075
Total Execution Time  0.1112
  CADENA URL  
/championnat_national_burkina_faso2008
  GET DATOS  
$_GET['/championnat_national_burkina_faso2008']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (36)  
0.0019  SELECT type FROM routes WHERE alias = 'championnat_national_burkina_faso2008'
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 = 2008 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=1 DESC LIMIT 1
0.0022  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=510 AND type_rel = 3
0.0028  SELECT text_es as historical_text FROM leagues_text WHERE id=345
0.0033  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 = 28659 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0030  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='2008' WHERE c.parentId=510 GROUP BY c.id ORDER BY c.order_id ASC
0.0022  SELECT type,rule FROM rules WHERE categoryId = 510 ORDER BY type = 'tables_draw' DESC,type != 'extra' DESC, `order` ASC
0.0022  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-04-20 16:32:18' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0023  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=2 AND last_update > '2024-04-20 16:32:18' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0022  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=4 AND last_update > '2024-04-20 16:32:18' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0021  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=3 AND last_update > '2024-04-20 16:32:18' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0035  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 = 2008 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=0 DESC LIMIT 1
0.0023  SELECT e.action, count(e.action) as total, e.player_id FROM events2008 e WHERE e.league_id IN (28659) 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.0022  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 (28659) 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 events2008 e WHERE e.league_id IN (28659) 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 (28659) 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 events2008 e WHERE e.league_id IN (28659) 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 (28659) 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 events2008 e WHERE e.league_id IN (28659) 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 (28659) 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 = 28659 AND rp.lineup > 0 ORDER BY rp.lineup DESC,p.pod DESC LIMIT 20
0.0020  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 = 28659 AND rp.events > 0 ORDER BY rp.events DESC,p.pod DESC LIMIT 20
0.0024  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=28659 AND rel.round=26
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 = 28659 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 = 28659 AND esl.points > 0
0.0020  SELECT fau.user_name, c.*, NOW() as difference_time,creation_date FROM (leagues as l) INNER JOIN comments as c ON c.league_id = l.id LEFT JOIN fa_user fau ON fau.id = c.author_id WHERE c.creation_date > "2024-03-21" AND c.`active`= 1 and c.comment_id is null and c.lang = 1 AND l.`id` = 28659 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-03-21" AND c.`active`= 1 and comment_id is null and c.lang = 1 AND l.`id` = 28659
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 `calendars2008` 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` = 28659 AND c.`round` = 26 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 `events2008` e INNER JOIN calendars2008 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 = 28659 ORDER BY total DESC LIMIT 40
0.0024  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 `events2008` e INNER JOIN calendars2008 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 = 28659 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 `tables2008` 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 = 28659 AND t.round = 24 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 `tables2008` 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 = 28659 AND t.round = 26 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-04-20 00:00:00' AND c.`shedule` < '2024-04-24 23:59:59' AND l.id = 28659 ORDER BY c.shedule ASC, fcoef DESC LIMIT 5
0.0021  SELECT data1, data2 FROM services_tags WHERE categoryId=510
0.0021  SELECT l.year,l.group_code FROM leagues_besoccer l WHERE l.categoryId = 510 AND l.year = 2008 ORDER BY l.group_code ASC
0.0021  SELECT group_code, extraName from `leagues` WHERE categoryId=510 AND year=2008