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

Liga Benín 2009

Información Histórica
						
Championnat National du Bénin
=============================

Participants (20):

Teams:			      City:	      Département:  Stadium:

Dynamo Unacob FC (1)	      Parakou         Borgou	    Municipal de Parakou   8.000
Buffles du Borgou FC	      Parakou         Borgou	    Municipal de Parakou   8.000
Espoir FC		      Savalou	      Collines      Municipal de Savalou   5.000
Panthères FC		      Djougou	      Donga	    Municipal de Djougou  10.000
Soleil FC		      Cotonou	      Littoral	    (10)
Energie de la Sbee FC (2)     Cotonou	      Littoral	    (10)
UNB FC (3)		      Cotonou	      Littoral	    (10)
Cheminots de l'Ocbn FC (4)    Cotonou	      Littoral	    (10)
Mambas Noirs FC		      Cotonou	      Littoral	    (10)
ASPAC FC (5)		      Cotonou	      Littoral	    (10)
Requins de l'Atlantique FC    Kouhounou	      Littoral	    (10)
Mogas 90 de la Sonacop FC (6) Porto-Novo      Ouémé	    (11)
AS Dragons FC de l'Ouémé      Porto-Novo      Ouémé	    (11)
ASOS FC (7)	   	      Porto-Novo      Ouémé	    (11)
US Kraké		      Kraké	      Ouémé	    (11)
Avrankou Omnisport FC	      Avrankou	      Ouémé	    Municipal de Avrankou  5.000
JAM FC (8)	              Akpo-Missérété  Ouémé	    Municipal de Missérété 5.000
JSP FC (9)		      Pobè	      Plateau	    Jean Pierre Gascon     5.000
Tonnerre d'Abomey FC	      Bohicon	      Zou	    Municipal de Bohicon   5.000
Dynamo FC		      Abomey	      Zou	    Goho		   7.500


NB: (1) Unacob means Union Nationale des Conducteurs du Bénin.
    (2) Sbee means Société d’Eau et d’Electricite.
    (3) UNB means Université Nationale du Bénin.
    (4) Ocbn means Organisation Commune Benin-Niger des chemins de fer et des transports.
    (5) ASPAC means Association Sportive du Port Autonome de Cotonou.
    (6) Sonacop means Société Nationale de Commercialisation des Produits pétroliers.
    (7) ASOS means Association Sportive Oussou Saka.
    (8) JAM means Jeunesse Athlétique d'Akpo-Missérété.
    (9) JSP means Jeunesse Sportive de Pobè.
    (10) Each team can play at Amitié (35.000) or René Pleven d'Akpakpa (25.000) or Gbegamey Collège (5.000).
    (11) Each team can play at Sémé-Kpodji (5.000) or Charles de Gaulle (35.000).

NB: FC means Football Club.
    AS means Association Sportive.
    US means Union Sportive.


Group Stage

Poule A
Mogas 90 de la Sonacop FC
AS Dragons FC de l'Ouémé
Energie de la Sbee FC
Université d'Abomey Calavi (UAC)
Dynamo Unacob FC de Parakou (Malanville)
USC (formerly Cheminots de l'Ocbn FC) (Cotonou)
Mambas Noirs FC (Cotonou)
Dynamo FC (Abomey)
Association Sportive Oussou Saka FC (Porto-Novo)
USS Kraké (Union sportive de Sèmè-Kraké)

Poule B
Buffles du Borgou FC (Parakou)
Panthères FC (Djougou)
Jeunesse Sportive de Pobè FC
Soleil FC (Cotonou)
Requins de l'Atlantique FC (Kouhounou)
Avrankou Omnisport FC
Tonnerre d'Abomey FC
Espoir FC (Savalou)
Jeunesse Athlétique d’Akpo Missérété FC (JAM)
ASPAC FC (Association Sportive du Port Autonome de Cotonou FC)


NB: start scheduled for Jul 5 and 6 - postponed to Aug 6, purportedly
      due to strike of strike in legal branch making it impossible to
      validate players' licenses;
    bottom-3 of both groups to be relegated

Final Tables:

Poule A 
 1.USS Kraké (Sèmè-Kraké)                   18  10  4  4  19- 7  34
 2.AS Oussou Saka FC (Porto-Novo)           18   7  8  3  14- 9  29  [ASOS]
 3.AS Dragons FC de l'Ouémé                 18   6 10  2  14- 8  28  [*1]
 4.Université Nationale du Bénin FC         18   7  6  5  18-16  27  [UNB] 
 5.Mambas Noirs FC (Cotonou)                18   6  5  7  17-16  23
 6.USC (Cotonou)                            18   6  4  8  15-16  22  [*2]
 7.Energie de la Sbee FC                    18   5  7  6  10-15  22
-------------------------------------------------------------------
 8.Mogas 90 de la Sonacop FC                18   5  6  7  12-11  21  Relegated
 9.Dynamo Unacob FC de Parakou (Malanville) 18   4  6  8  11-15  18  Relegated
10.Dynamo FC (Abomey)                       18   4  2 12   9-26  14  Relegated
[*1] aka Université d'Abomey Calavi (UAC)
[*2] Cheminots de l'Ocbn FC were renamed USC
NB: 2 more losses than wins due to double forfait round 1

Poule B
 1.Tonnerre d'Abomey FC                     18  10  5  3  21- 9  35
 2.Soleil FC (Cotonou)                      18   6  8  4  19- 8  26
 3.Panthères FC (Djougou)                   18   7  5  6  15-10  26
 4.Jeunesse Sportive de Pobè FC             18   7  5  6  20-16  26
 5.Avrankou Omnisport FC                    18   8  2  8   8-18  26
 6.ASPAC FC (Cotonou)                       18   5  9  4  15-12  24
 7.Buffles du Borgou FC (Parakou)           18   6  6  6  12-10  24
-------------------------------------------------------------------
 8.Requins de l'Atlantique FC (Kouhounou)   18   7  2  9  15-25  23  Relegated
 9.Espoir FC (Savalou)                      18   5  4  9   9- 9  19  Relegated
10.Jeunesse Athlétique d'Akpo Missérété FC  18   5  2 11  11-28  17  Relegated  [JAM]

Round 1 
Poule A
[Aug 6]
Dynamo Parakou 0-1 UNB
Dynamo Abomey  awd USC                    [awarded 0-0 loss against both]
US Kraké       3-1 Mambas Noirs        
[Aug 7]
Mogas 90       1-0 ASOS 
Dragons        0-0 Energie
Poule B
[Aug 6]
Panthères      1-0 ASPAC
Tonnerre       1-0 Espoir
Soleil         3-0 JS Pobè
Avrankou       1-0 JA Missérété
[Aug 7]
Buffles        1-0 Requins

Round 2
Poule A
[Aug 9]
USC            0–1 UNB
[Aug 10]
Dynamo Abomey  1–0 Mogas 90
Mambas Noirs   1–2 Dragons
Energie        0–0 US Kraké 
ASOS           1–1 Dynamo Parakou 
Poule B [Aug 10]
Panthères      1–1 Buffles
Espoir         3-0 JA Missérété
Tonnerre       0–0 Soleil
Requins        3–2 ASPAC
JS Pobè        1-0 Avrankou   

Round 3 
Poule A
[Aug 16]
UNB            1-0 ASOS
Mambas Noirs   0-0 Dynamo Abomey 
[Aug 17]
Dynamo Parakou 1-0 Mogas 90
USC            0-1 Energie
US Kraké       0-1 Dragons
Poule B [Aug 17]
Soleil         1-0 Espoir 
ASPAC          0-0 Buffles
Avrankou       0-0 Panthères 
JA Missérété   0-1 Requins
JS Pobè        1-1 Tonnerre 

Round 4
Poule A
[Aug 20]
Dynamo Abomey  0-1 US Kraké
USC            3-1 Dynamo Parakou 
UNB            2-0 Energie         
ASOS           1-0 Mambas Noirs 
[Aug 21]
Dragons        0-0 Mogas 90
Poule B
[Aug 20]
Buffles        1-0 JS Pobè
Espoir         1-0 Requins 
Tonnerre       4-0 JA Missérété 
Panthères      1-0 Soleil
[Aug 21]
ASPAC          3-1 Avrankou

Round 5
Poule A
[Aug 23]
Energie        0-1 Mambas Noirs
US Kraké       1-0 ASOS
[Aug 24]
Dynamo Parakou 3-0 Dynamo Abomey 
Mogas 90       1-1 UNB
Dragons        0-0 USC
Poule B 
[Aug 23]
Buffles        2-0 JA Missérété 
Requins        1-0 Panthères
[Aug 24]
ASPAC          0-0 Soleil
Avrankou       0-3 Tonnerre
JS Pobè        1-0 Espoir

Round 6
Poule A
[Aug 30]
Dynamo Parakou 1-1 Dragons
USC            1–3 Mambas Noirs 
UNB            3–0 Dynamo Abomey 
[Aug 31]
Mogas 90       0–1 US Kraké 
ASOS           2–0 Energie        
Poule B [Aug 31]
Buffles        2–0 Tonnerre
Espoir         2–0 Avrankou
Soleil         2–1 Requins
JA Missérété   0–2 Panthères 
JS Pobè        0-0 ASPAC

Round 7
Poule A
[Sep 3]
Dynamo Parakou 0-2 Energie       
Dynamo Abomey  0-1 Dragons       
Mambas Noirs   1-0 Mogas 90      
US Kraké       1-2 UNB           
[Sep 5]
ASOS           2-1 USC
Poule B
[Sep 3]
Panthères      1-1 JS Pobè       
Tonnerre       1-0 Requins       
ASPAC          3-1 Espoir        
Soleil         6-1 JA Missérété 
[Sep 4]
Buffles        awd Avrankou               [awarded 0-0 win to Avrankou,     
                                           originally 1-1]
Round 8 [postponed in its entirety]
Poule A
[Sep 10]
Mambas Noirs   0-0 Dynamo Parakou
[Sep 11]
Dynamo Abomey  0-0 ASOS          
UNB            0-0 Dragons       
Mogas 90       0-1 Energie       
US Kraké       3-0 USC           
Poule B
[Sep 10]
ASPAC          awd JA Missérété           [awarded 0-0 win to ASPAC,
[Sep 11]                                   JAM showed late]
Espoir         0-1 Buffles       
Tonnerre       1-1 Panthères     
Avrankou       0-0 Soleil        
JS Pobè        6-0 Requins       

Round 9 
Poule A
[Sep 17]
Dynamo Parakou 0-2 US Kraké      
USC            0-0 Mogas 90      
Energie        3-1 Dynamo Abomey 
[Sep 18]
UNB            1-1 Mambas Noirs  
Dragons        1-2 ASOS          
Poule B [Sep 18]
Panthères      0-1 Espoir        
Buffles        1-1 Soleil        
Tonnerre       1-1 ASPAC         
Requins        2-1 Avrankou      
JA Missérété   2-0 JS Pobè       

Round 10 
Poule A
[Sep 24]
UNB            0-0 Dynamo Parakou
USC            1-0 Dynamo Abomey 
[Sep 25]
Mambas Noirs   0-0 US Kraké 
Energie        0-0 Dragons  
ASOS           0-0 Mogas 90   
Poule B
[Sep 24]
ASPAC          2-1 Panthères   
[Sep 25]
Espoir         1-0 Tonnerre  
JS Pobè        0-0 Soleil     
JA Missérété   2-0 Avrankou    
Requins        2-0 Buffles      

Round 11
Poule A
[Oct 1]
Dynamo Parakou awd ASOS                   [awarded 0-0 win to ASOS,
Mogas 90       6-2 Dynamo Abomey           originally 0-0]
UNB            1-2 USC  
[Oct 2]         
Dragons        2-0 Mambas Noirs  
US Kraké       1-0 Energie       
Poule B
[Oct 1]   
Avrankou       2-1 JS Pobè        
JA Missérété   0-0 Espoir     
[Oct 2]
Buffles        2-0 Panthères     
Soleil         1-2 Tonnerre      
ASPAC          0-0 Requins        

Round 12
Poule A
[Oct 4]
Mogas 90       0-1 Dynamo Parakou
ASOS           1-1 UNB           
[Oct 5]
Dynamo Abomey  0-1 Mambas Noirs  
Energie        1-1 USC           
Dragons        0-0 US Kraké      
Poule B [Oct 5]
Panthères      2-0 Avrankou      
Buffles        0-0 ASPAC         
Espoir         0-0 Soleil        
Tonnerre       1-0 JS Pobè        
Requins        1-3 JA Missérété  

Round 13
Poule A
[Oct 11]
Mambas Noirs   1-1 ASOS                 
Mogas 90       0-0 Dragons        
[Oct 12]
Dynamo Parakou 0-0 USC           
Energie        2-1 UNB                   
US Kraké       2-0 Dynamo Abomey 
Poule B
[Oct 11]
Requins        1-0 Espoir         
[Oct 12]
Soleil         0-0 Panthères     
Avrankou       awd ASPAC                  [awarded 0-0 win to Avrankou,    
JA Missérété   0-1 Tonnerre                originally 0-2]
JS Pobè        2-0 Buffles       

Round 14 [Oct 15]
Poule A
Dynamo Abomey  2-1 Dynamo Parakou
UNB            2-1 Mogas 90      
Mambas Noirs   4-0 Energie       
USC            1-0 Dragons        
ASOS           0-0 US Kraké      
Poule B
Panthères      awd Requins                [awarded 0-0 win to Requins,
Tonnerre       2-0 Avrankou                originally 1-0, Panthères
JA Missérété   1-0 Buffles                 fielded ineligible player]
Espoir         awd JS Pobè                [awarded 0-0 win to JS Pobè,     
Soleil         0-0 ASPAC                   originally 2-0, Espoir fielded
                                           two ineligible players]
Round 15
Poule A
[Oct 18]
Energie        0-0 ASOS          
Mambas Noirs   1-3 USC           
Dragons        2-1 Dynamo Parakou
[Oct 19]
Dynamo Abomey  1-0 UNB           
US Kraké       0-1 Mogas 90      
Poule B [Oct 19]
Panthères      4-0 JA Missérété  
Tonnerre       0-0 Buffles       
Requins        0-3 Soleil        
ASPAC          2-1 JS Pobè        
Avrankou       1-0 Espoir         

Round 16
Poule A
[Oct 25]
Mogas 90       1-0 Mambas Noirs  
UNB            0-3 US Kraké     
[Oct 26] 
Energie        0-0 Dynamo Parakou
Dragons        2-0 Dynamo Abomey 
[Oct 27]
USC            0-1 ASOS          
Poule B 
[Oct 26]
Espoir         0-0 ASPAC   
Avrankou       1-0 Buffles     
JS Pobè        1-0 Panthères      
[Oct 27]       
Requins        0-1 Tonnerre       
JA Missérété   1-0 Soleil       

Round 17
Poule A
[Oct 29]
Dynamo Parakou 1-0 Mambas Noirs  
USC            2-0 US Kraké      
ASOS           2-0 Dynamo Abomey 
[Oct 30]
Energie        0-0 Mogas 90      
Dragons        1-1 UNB           
Poule B
[Oct 29]    
Requins        3-3 JS Pobè        
JA Missérété   1-1 ASPAC         
[Oct 30]
Panthères      1-0 Tonnerre  
Buffles        0-0 Espoir         
Soleil         awd Avrankou               [awarded 0-0 win to Avrankou,    
                                           originally 2-0]

NB: the match Soleil vs Avrankou was awarded to the latter because Soleil
    had originally listed Fatolou Prosper on the match documents, but had
    removed his name prior to the start of the match; the player, who
    allegedly had not completed the transfer formalities after leaving his
    former club Espoir Plus before joining Soleil, neither played in the
    match nor was he a substitute; nevertheless the match was awarded (a
    long time after the season had finished) to Avrankou, thereby saving
    them from relegation at the cost of Requins; the same Fatolou Prosper
    had actively played in both matches Soleil won against Requins (on 
    Aug 31 and Oct 19), but these matches were not awarded to Requins (if 
    these matches would also have been awarded against Soleil, Soleil would
    have finished on a relegation place).  Avrankou Omnisports is the club 
    of the treasurer general of the FBF while the president of the executive
    committee of the FBF is the main sponsor of Soleil.

Round 18
Poule A
[Nov 12]
Mogas 90       1-0 USC           
ASOS           1-1 Dragons        
[Nov 13]
Dynamo Abomey  2-0 Energie       
Mambas Noirs   2-0 UNB           
US Kraké       1-0 Dynamo Parakou
Poule B
[Nov 12]
ASPAC          1-2 Tonnerre      
[Nov 13]
Espoir         awd Panthères              [awarded 0-0 to Panthères; 
Soleil         2-1 Buffles                 abandoned at 1-0 in 39']
JS Pobè        2-0 JA Missérété            
Avrankou       abd Requins                [abandoned at 1-1 in 75' due
[Nov 14]                                   to light failure]
Avrankou       1-0 Requins                [replay]

Final Tables:

Poule A 
 1.USS Kraké (Sèmè-Kraké)                   18  10  4  4  19- 7  34
 2.AS Oussou Saka FC (Porto-Novo)           18   7  8  3  14- 9  29  [ASOS]
 3.AS Dragons FC de l'Ouémé                 18   6 10  2  14- 8  28  [*1]
 4.Université Nationale du Bénin FC         18   7  6  5  18-16  27  [UNB] 
 5.Mambas Noirs FC (Cotonou)                18   6  5  7  17-16  23
 6.USC (Cotonou)                            18   6  4  8  15-16  22  [*2]
 7.Energie de la Sbee FC                    18   5  7  6  10-15  22
-------------------------------------------------------------------
 8.Mogas 90 de la Sonacop FC                18   5  6  7  12-11  21  Relegated
 9.Dynamo Unacob FC de Parakou (Malanville) 18   4  6  8  11-15  18  Relegated
10.Dynamo FC (Abomey)                       18   4  2 12   9-26  14  Relegated
[*1] aka Université d'Abomey Calavi (UAC)
[*2] Cheminots de l'Ocbn FC were renamed USC
NB: 2 more losses than wins due to double forfait round 1

Poule B
 1.Tonnerre d'Abomey FC                     18  10  5  3  21- 9  35
 2.Soleil FC (Cotonou)                      18   6  8  4  19- 8  26
 3.Panthères FC (Djougou)                   18   7  5  6  15-10  26
 4.Jeunesse Sportive de Pobè FC             18   7  5  6  20-16  26
 5.Avrankou Omnisport FC                    18   8  2  8   8-18  26
 6.ASPAC FC (Cotonou)                       18   5  9  4  15-12  24
 7.Buffles du Borgou FC (Parakou)           18   6  6  6  12-10  24
-------------------------------------------------------------------
 8.Requins de l'Atlantique FC (Kouhounou)   18   7  2  9  15-25  23  Relegated
 9.Espoir FC (Savalou)                      18   5  4  9   9- 9  19  Relegated
10.Jeunesse Athlétique d'Akpo Missérété FC  18   5  2 11  11-28  17  Relegated  [JAM]

NB: Requins, Espoir and Dynamo Parakou have protested their relegation;
    a commission was set up on May 5, 2009 on the order of FIFA to resolve
    these issues within a month; on July 2, 2009, the commission submitted
    its report in which the entire transitional championship was declared
    invalid because of a number of irregularities.

NB: in 2009/10 the first level is reduced to 14 clubs and 
    the second to 12; participants were announced in August as:

Première Division
 1.Dragons FC
 2.Avrankou Omnisport
 3.Soleil FC
 4.Panthères de Djougou
 5.Mamba Noir
 6.Mogas 90 FC
 7.Requins de l'Atlantique
 8.Dynamo d'Abomey
 9.Dynamo de Parakou
10.Espoir de Savalou
11.Buffles du Borgou
12.Tonnerre FC
13.ASPAC
14.US Kraké


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

Last updated: 24 Sep 2009

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

INFORMACIÓN

La Benin Premier League, también llamada Championnat National du Bénin en francés, es la mayor división de fútbol de Benín. La liga fue fundada en 1969. Actualmente, esta compuesta por 14 clubes que participan en un torneo de dos ruedas. El campeón de la Premier League logra un puesto en la Liga de Campeones de la CAF. Los últimos 2 clubes sufren el descenso a la Segunda División que está formada por 11 equipos.

  USO DE MEMORIA  
4,276,632 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0020
Controller Execution Time ( Home / Category )  0.1031
Total Execution Time  0.1052
  CADENA URL  
/liga_benin2009
  GET DATOS  
$_GET['/liga_benin2009']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (38)  
0.0018  SELECT type FROM routes WHERE alias = 'liga_benin2009'
0.0044  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'liga_benin' 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=328 AND type_rel = 3
0.0022  SELECT text_es as historical_text FROM leagues_text WHERE id=306
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 = 28623 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0019  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=328 GROUP BY c.id ORDER BY c.order_id ASC
0.0017  SELECT type,rule FROM rules WHERE categoryId = 328 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-04-27 13:43:06' 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-27 13:43:06' 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-27 13:43:06' 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-27 13:43:06' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0022  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'liga_benin' 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 (28623) AND (e.action IN (1,2,11,12,13) ) GROUP BY e.player_id ORDER BY total DESC, e.player_id ASC LIMIT 20
0.0018  SELECT dp.name, dp.last_name, dp.nick,dp.CountryCode,dp.alias,rp.team_id,dt.nameShow,dt.short_name,dt.basealias,rp.player_id,rp.teamId,dp.role FROM dataplayers AS dp INNER JOIN rel_players AS rp ON rp.player_id=dp.id AND rp.league_id IN (28623) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN () ORDER BY rp.in_squad = 1 DESC
0.0020  SELECT e.action, count(e.action) as total, e.player_id FROM events2009 e WHERE e.league_id IN (28623) AND (e.action IN (4,5) ) GROUP BY e.player_id ORDER BY total DESC, e.player_id ASC LIMIT 20
0.0018  SELECT dp.name, dp.last_name, dp.nick,dp.CountryCode,dp.alias,rp.team_id,dt.nameShow,dt.short_name,dt.basealias,rp.player_id,rp.teamId,dp.role FROM dataplayers AS dp INNER JOIN rel_players AS rp ON rp.player_id=dp.id AND rp.league_id IN (28623) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN () ORDER BY rp.in_squad = 1 DESC
0.0019  SELECT e.action, count(e.action) as total, e.player_id FROM events2009 e WHERE e.league_id IN (28623) 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 (28623) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN () ORDER BY rp.in_squad = 1 DESC
0.0019  SELECT e.action, count(e.action) as total, e.player_id FROM events2009 e WHERE e.league_id IN (28623) 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 (28623) 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 = 28623 AND rp.lineup > 0 ORDER BY rp.lineup DESC,p.pod DESC LIMIT 20
0.0019  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 = 28623 AND rp.events > 0 ORDER BY rp.events DESC,p.pod DESC LIMIT 20
0.0020  SELECT max(l.year) as max_year, min(l.year) as min_year FROM leagues l WHERE categoryID = 328 GROUP BY l.categoryId
0.0017  SELECT l.year FROM leagues AS l WHERE (l.group_code =0 OR l.total_num_tablesR>=1 OR l.total_teamsR >=1 OR l.text_mode != 0) AND l.categoryId=328 GROUP BY l.year ORDER BY l.year DESC
0.0023  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=28623 AND rel.round=18
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 = 28623 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 = 28623 AND esl.points > 0
0.0021  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-28" AND c.`active`= 1 and c.comment_id is null and c.lang = 1 AND l.`id` = 28623 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-03-28" AND c.`active`= 1 and comment_id is null and c.lang = 1 AND l.`id` = 28623
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 `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` = 28623 AND c.`round` = 18 ORDER BY shedule ASC LIMIT 200
0.0017  SELECT (dt1.qod+dt2.qod+dt1.relations+dt2.relations) as total,c.r1,c.r2,e.action,ev.showName as eventName,ev.largeName,ev.main_action,ev.keyname,ev.classf,e.real_date,e.minute, dp.nick,dp.CountryCode,dp.alias,c.datateam1,c.datateam2,dt1.nameShow as nameShow1,dt2.nameShow as nameShow2,dt1.basealias as basealias1,dt2.basealias as basealias2,e.player_id,e.match_id FROM `events2009` e INNER JOIN calendars2009 c ON c.id = e.match_id INNER JOIN events ev ON ev.id = e.action INNER JOIN dataplayers dp ON dp.id = e.player_id INNER JOIN datateams dt1 ON dt1.id = c.datateam1 INNER JOIN datateams dt2 ON dt2.id = c.datateam2 WHERE ev.main_action = 1 AND c.round = 18 AND e.real_date IS NOT NULL AND e.league_id = 28623 ORDER BY total DESC LIMIT 40
0.0031  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 = 28623 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 `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 = 28623 AND t.round = 16 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 `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 = 28623 AND t.round = 18 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-27 00:00:00' AND c.`shedule` < '2024-05-01 23:59:59' AND l.id = 28623 ORDER BY c.shedule ASC, fcoef DESC LIMIT 5
0.0021  SELECT data1, data2 FROM services_tags WHERE categoryId=328
0.0021  SELECT l.year,l.group_code FROM leagues_besoccer l WHERE l.categoryId = 328 AND l.year = 2009 ORDER BY l.group_code ASC
0.0021  SELECT group_code, extraName from `leagues` WHERE categoryId=328 AND year=2009