4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
« Temporada Anterior
Temporada 2010
Temporada Siguiente »
Publicidad 600x120.gif
Liga Benín 2010
2009/2010

Liga Benín 2010

Información Histórica 
						
Final Table:

 1.ASPAC                           26  12  9  5  40-19  45  Champions
 2.Buffles du Borgou               26  12  8  6  28-19  44
 3.USS Kraké                       26  12  7  7  27-22  43
 4.Tonnerre FC                     26   8 14  4  23-14  38
 5.Dragons FC                      26   9 11  6  32-25  38
 6.Requins de l'Atlantique         26  10  5 11  43-41  35
 7.Mambas Noirs                    26   9  8  9  23-27  35
 8.Panthères de Djougou            26   8 10  8  22-21  34
 9.Avrankou Omnisport              26   9  6 11  21-26  33
10.Mogas 90 FC                     26   8  8 10  27-26  32
11.Dynamo d'Abomey                 26   5 13  8  14-24  28
12.Soleil FC                       26   8  4 14  23-35  28
----------------------------------------------------------
13.Dynamo de Parakou               26   6  8 12  17-28  26  Relegated
14.Espoir de Savalou               26   5 11 10  20-33  26  Relegated

NB: ASOS, UNB, USC, Energie, JS Pobè and JAM were apparently
    excluded from both first and second level for failing to
    submit all application forms in time.  The first four of
    these later entered the third level amateur championship
    while Pobé and JAM do not.

Round 1
[Oct 3]
Mambas Noirs      0–1 USS Kraké
[Oct 4]
Dragons           1–1 ASPAC
Requins           0–3 Tonnerre 
Espoir            1–0 Dynamo de Parakou
Buffles           1–0 Mogas 90 
Panthères         2–1 Avrankou 
Dynamo d'Abomey   1–0 Soleil

Round 2
[Oct 16]
ASPAC             3–0 Espoir
[Oct 17]  
Soleil            0-3 Dragons
[Oct 18]
Avrankou          1-1 Buffles
USS Kraké         0–0 Dynamo d'Abomey 
Mogas 90          0-1 Requins 
Dynamo de Parakou 0-1 Tonnerre   
Panthères         0-0 Mambas Noirs

Round 3
[Oct 24]
Buffles           1-0 Panthères
Requins           7-2 Espoir
Tonnerre          awd Mogas 90          [awarded 0-0 win to Mogas;
[Oct 25]                                 originally 0-0]
Dragons           3-2 USS Kraké 
Mambas Noirs      1-3 Soleil
Dynamo d'Abomey   1-0 ASPAC         
Dynamo de Parakou 2-0 Avrankou

Round 4
[Oct 30]
Requins           3-0 Dynamo d'Abomey
[Oct 31]
Avrankou          0-1 USS Kraké
Mambas Noirs      0–5 ASPAC         
[Nov 1]
Dragons           5-0 Dynamo de Parakou  
Mogas 90          2-1 Soleil
Espoir            2-1 Panthères 
Buffles           0-1 Tonnerre

Round 5
[Nov 7]
Dragons           0-0 Espoir
Mambas Noirs      1–0 Dynamo d'Abomey
[Nov 8]
USS Kraké         1-0 Buffles
Soleil            0-1 Avrankou
Tonnerre          0-0 ASPAC         
Dynamo de Parakou 0-1 Mogas 90
Panthères         1-1 Requins

Round 6
[Nov 13]
Mogas 90          2-0 USS Kraké
[Nov 14]
ASPAC             3-1 Avrankou
Dynamo d'Abomey   0-3 Panthères
[Nov 15]
Tonnerre          1-1 Dragons       
Espoir            0-2 Soleil
Buffles           2-1 Dynamo de Parakou
[Nov 17]
Requins           0-1 Mambas Noirs  

Round 7
[Dec 5]
Mambas Noirs      1-0 Avrankou 
USS Kraké         3-1 Requins
[Dec 6]
Dragons           2-6 Mogas 90
Soleil            1-1 Panthères 
Dynamo d'Abomey   1-1 Tonnerre
Espoir            1-1 Buffles
Dynamo de Parakou 3-1 ASPAC         

Round 8
[Dec 11]
Soleil            2-0 Dynamo de Parakou
[Dec 12]
Mogas 90          0-1 Avrankou
Dynamo d'Abomey   1-1 Espoir
[Dec 13]
Dragons           0-0 Panthères
ASPAC             1-1 USS Kraké
Tonnerre          2-0 Mambas Noirs
Buffles           3-1 Requins

Round 9
[Dec 19]
USS Kraké         2-1 Soleil
Mambas Noirs      1–2 Buffles
[Dec 20]
Avrankou          0-1 Tonnerre
Requins           3-2 Dragons
Espoir            1-1 Mogas 90
Dynamo de Parakou 0-0 Dynamo d'Abomey
Panthères         2-0 ASPAC         

Round 10
[Dec 25]
Mogas 90          1-1 Panthères
[Dec 26]
ASPAC             1-1 Requins
Dynamo de Parakou 0-1 Mambas Noirs
Buffles           1-0 Dynamo d'Abomey
[Dec 27]
Dragons           1-0 Avrankou  
Espoir            1-1 USS Kraké
Soleil            0-2 Tonnerre 

Round 11
[Dec 30]
Tonnerre          0-1 USS Kraké
ASPAC             4-1 Mogas 90
[Jan 2]
Mambas Noirs      1-0 Espoir
[Jan 3]
Avrankou          3-1 Requins
Soleil            1-0 Buffles
Dynamo d'Abomey   0-0 Dragons
Panthères         2-0 Dynamo de Parakou

Round 12
[Jan 5]
Mogas 90          0-1 Mambas Noirs
[Jan 8]
Avrankou          0-0 Dynamo d'Abomey
ASPAC             2-0 Soleil
Buffles           0-1 Dragons
[Jan 9]
USS Kraké         1-1 Panthères
Requins           4-3 Dynamo de Parakou
Espoir            2-1 Tonnerre

Round 13
[Feb 6]
Soleil            0-4 Requins 
[Feb 7]
Dragons           2-2 Mambas Noirs  
ASPAC             0-1 Buffles
Dynamo d'Abomey   0-0 Mogas 90
Espoir            2-0 Avrankou 
Dynamo de Parakou 1-0 USS Kraké
Panthères         0-0 Tonnerre

Round 14
[Feb 12]
Soleil            2-1 Dynamo d'Abomey
[Feb 13]
Mogas 90          1-1 Buffles
Avrankou          1-0 Panthères
[Feb 14]
USS Kraké         1-1 Mambas Noirs
ASPAC             2-2 Dragons
Tonnerre          1-1 Requins
Dynamo de Parakou 0-0 Espoir

Round 15
[Feb 20]
Mambas Noirs      1-1 Panthères
Dynamo d'Abomey   0-1 USS Kraké
[Feb 21]
Dragons           0-0 Soleil
Requins           0-4 Mogas 90
Tonnerre          0-0 Dynamo de Parakou
Espoir            0-1 ASPAC         
Buffles           0-2 Avrankou

Round 16
[Feb 26]
ASPAC             2-0 Dynamo d'Abomey
[Feb 27]
USS Kraké         2-0 Dragons
Mogas 90          2-2 Tonnerre
[Feb 28]
Avrankou          2-1 Dynamo de Parakou
Soleil            2-1 Mambas Noirs
Espoir            0-1 Requins
Panthères         0-0 Buffles

Round 17
[Mar 13]
Soleil            1-0 Mogas 90
Tonnerre          2-1 Buffles
[Mar 14]
USS Kraké         2-1 Avrankou
ASPAC             0-0 Mambas Noirs
Dynamo d'Abomey   3-2 Requins
Dynamo de Parakou 0-0 Dragons  
Panthères         2-0 Espoir  

Round 18
[Mar 19]
Mogas 90          1-0 Dynamo de Parakou
[Mar 20]
ASPAC             2-1 Tonnerre
[Mar 21]
Avrankou          1-0 Soleil
Requins           3-1 Panthères
Dynamo d'Abomey   2-1 Mambas Noirs
Espoir            1-1 Dragons
Buffles           2-0 USS Kraké

Round 19
[Mar 27]
Dragons           0-0 Tonnerre
Soleil            0-0 Espoir
[Mar 28]
USS Kraké         2-2 Mogas 90
Avrankou          1-0 ASPAC         
Mambas Noirs      1-1 Requins
Dynamo de Parakou 1-1 Buffles
Panthères         0-0 Dynamo d'Abomey

Round 20
[Apr 2]
Requins           2-1 USS Kraké
[Apr 3]
ASPAC             1-1 Dynamo de Parakou
[Apr 4]
Avrankou          2-1 Mambas Noirs
Mogas 90          0-1 Dragons
Tonnerre          0-0 Dynamo d'Abomey
Buffles           1-1 Espoir
Panthères         2-1 Soleil

Round 21
[Apr 24]
Avrankou          0-0 Mogas 90
Mambas Noirs      2-2 Tonnerre
[Apr 25]
USS Kraké         0-1 ASPAC         
Requins           0-2 Buffles
Espoir            0-2 Dynamo d'Abomey
Dynamo de Parakou 2-1 Soleil
Panthères         1-0 Dragons

Round 22
[Apr 30]
Soleil            0-1 USS Kraké
ASPAC             4-0 Panthères
[May 1]
Mogas 90          2-1 Espoir
Dynamo d'Abomey   0-0 Dynamo de Parakou
[May 2]
Dragons           1-0 Requins
Tonnerre          0-0 Avrankou
Buffles           1-0 Mambas Noirs

Round 23
[May 5]
USS Kraké         0-2 Espoir
Requins           1-1 ASPAC     
[May 8]    
Dynamo d'Abomey   1-1 Buffles
[May 9]
Avrankou          0-1 Dragons
Mambas Noirs      0-0 Dynamo de Parakou
Tonnerre          1-1 Soleil
Panthères         1-0 Mogas 90

Round 24
[May 12]
USS Kraké         0-0 Tonnerre
Mogas 90          1-3 ASPAC       
[May 15]
Buffles           3-1 Soleil
Dragons           4-0 Dynamo d'Abomey
Requins           3-0 Avrankou
[May 16]  
Espoir            0-2 Mambas Noirs
Dynamo de Parakou 1-0 Panthères 

Round 25
[May 22]     
Soleil            0-2 ASPAC    
Tonnerre          0-0 Espoir
Dragons           1-2 Buffles
[May 23]
Mambas Noirs      1-0 Mogas 90
Dynamo d'Abomey   1-1 Avrankou
Dynamo de Parakou 1-0 Requins
Panthères         0-1 USS Kraké

Round 26 [Jun 5]
Mambas Noirs      2-0 Dragons
USS Kraké         2-0 Dynamo de Parakou
Requins           2-3 Soleil
Avrankou          2-2 Espoir
Mogas 90          0-0 Dynamo d'Abomey
Tonnerre          1-0 Panthères
Buffles           0-0 ASPAC         

Final Table:

 1.ASPAC                           26  12  9  5  40-19  45  Champions
 2.Buffles du Borgou               26  12  8  6  28-19  44
 3.USS Kraké                       26  12  7  7  27-22  43
 4.Tonnerre FC                     26   8 14  4  23-14  38
 5.Dragons FC                      26   9 11  6  32-25  38
 6.Requins de l'Atlantique         26  10  5 11  43-41  35
 7.Mambas Noirs                    26   9  8  9  23-27  35
 8.Panthères de Djougou            26   8 10  8  22-21  34
 9.Avrankou Omnisport              26   9  6 11  21-26  33
10.Mogas 90 FC                     26   8  8 10  27-26  32
11.Dynamo d'Abomey                 26   5 13  8  14-24  28
12.Soleil FC                       26   8  4 14  23-35  28
----------------------------------------------------------
13.Dynamo de Parakou               26   6  8 12  17-28  26  Relegated
14.Espoir de Savalou               26   5 11 10  20-33  26  Relegated

NB: ASOS, UNB, USC, Energie, JS Pobè and JAM were apparently
    excluded from both first and second level for failing to
    submit all application forms in time.  The first four of
    these later entered the third level amateur championship
    while Pobé and JAM do not.


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

Last updated: 10 Mar 2016

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

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,245,000 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0032
Controller Execution Time ( Home / Category )  0.1418
Total Execution Time  0.1457
  CADENA URL  
/liga_benin2010
  GET DATOS  
$_GET['/liga_benin2010']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (35)  
0.0018  SELECT type FROM routes WHERE alias = 'liga_benin2010'
0.0045  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 = 2010 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=1 DESC LIMIT 1
0.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=328 AND type_rel = 3
0.0052  SELECT text_es as historical_text FROM leagues_text WHERE id=308
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 = 28626 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0061  SELECT c.id, c.name, c.alias, c.stepParent, l.year FROM categories AS c INNER JOIN leagues AS l ON c.id=l.categoryId AND l.year='2010' WHERE c.parentId=328 GROUP BY c.id ORDER BY c.order_id ASC
0.0020  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-04-28 11:47:20' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0034  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=2 AND last_update > '2024-04-28 11:47:20' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0042  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=4 AND last_update > '2024-04-28 11:47:20' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0019  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=3 AND last_update > '2024-04-28 11:47:20' 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 = 'liga_benin' AND (l.group_code = 0 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 2010 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=0 DESC LIMIT 1
0.0031  SELECT e.action, count(e.action) as total, e.player_id FROM events2010 e WHERE e.league_id IN (28626) 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.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 (28626) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN () ORDER BY rp.in_squad = 1 DESC
0.0021  SELECT e.action, count(e.action) as total, e.player_id FROM events2010 e WHERE e.league_id IN (28626) 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 (28626) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN () ORDER BY rp.in_squad = 1 DESC
0.0022  SELECT e.action, count(e.action) as total, e.player_id FROM events2010 e WHERE e.league_id IN (28626) 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 (28626) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN () ORDER BY rp.in_squad = 1 DESC
0.0046  SELECT e.action, count(e.action) as total, e.player_id FROM events2010 e WHERE e.league_id IN (28626) AND (e.action IN (22) ) GROUP BY e.player_id ORDER BY total DESC, e.player_id ASC LIMIT 20
0.0023  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 (28626) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN () ORDER BY rp.in_squad = 1 DESC
0.0020  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 = 28626 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 = 28626 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=28626 AND rel.round=26
0.0021  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 = 28626 AND esl.points > 0 ORDER BY esl.points DESC LIMIT 3
0.0021  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 = 28626 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-29" AND c.`active`= 1 and c.comment_id is null and c.lang = 1 AND l.`id` = 28626 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-29" AND c.`active`= 1 and comment_id is null and c.lang = 1 AND l.`id` = 28626
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 `calendars2010` as c INNER JOIN teams t1 ON t1.id = c.team1 AND t1.league_id = c.league_id INNER JOIN teams t2 ON t2.id = c.team2 AND t2.league_id = c.league_id INNER JOIN datateams as dt1 ON dt1.id = t1.teamId INNER JOIN datateams as dt2 ON dt2.id = t2.teamId WHERE c.`league_id` = 28626 AND c.`round` = 26 ORDER BY shedule ASC LIMIT 200
0.0018  SELECT (dt1.qod+dt2.qod+dt1.relations+dt2.relations) as total,c.r1,c.r2,e.action,ev.showName as eventName,ev.largeName,ev.main_action,ev.keyname,ev.classf,e.real_date,e.minute, dp.nick,dp.CountryCode,dp.alias,c.datateam1,c.datateam2,dt1.nameShow as nameShow1,dt2.nameShow as nameShow2,dt1.basealias as basealias1,dt2.basealias as basealias2,e.player_id,e.match_id FROM `events2010` e INNER JOIN calendars2010 c ON c.id = e.match_id INNER JOIN events ev ON ev.id = e.action INNER JOIN dataplayers dp ON dp.id = e.player_id INNER JOIN datateams dt1 ON dt1.id = c.datateam1 INNER JOIN datateams dt2 ON dt2.id = c.datateam2 WHERE ev.main_action = 1 AND c.round = 26 AND e.real_date IS NOT NULL AND e.league_id = 28626 ORDER BY total DESC LIMIT 40
0.0025  SELECT c.r1,c.r2,e.action,ev.showName as eventName,ev.largeName,ev.main_action,ev.keyname,ev.classf,e.real_date,e.minute, dp.nick,dp.CountryCode,dp.alias,c.datateam1,c.datateam2,dt1.nameShow as nameShow1,dt2.nameShow as nameShow2,dt1.basealias as basealias1,dt2.basealias as basealias2,e.player_id,e.match_id FROM `events2010` e INNER JOIN calendars2010 c ON c.id = e.match_id INNER JOIN events ev ON ev.id = e.action INNER JOIN dataplayers dp ON dp.id = e.player_id INNER JOIN datateams dt1 ON dt1.id = c.datateam1 INNER JOIN datateams dt2 ON dt2.id = c.datateam2 WHERE ev.show_on = 1 AND e.real_date IS NOT NULL AND e.league_id = 28626 AND e.real_date > NOW() - INTERVAL 1 MONTH ORDER BY e.real_date DESC LIMIT 30
0.0020  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables2010` as t INNER JOIN teams as team ON team.id = t.team INNER JOIN datateams as dt ON team.teamId = dt.id WHERE t.league_id = 28626 AND t.round = 24 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0020  SELECT *,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables2010` as t INNER JOIN teams as team ON team.id = t.team INNER JOIN datateams as dt ON team.teamId = dt.id WHERE t.league_id = 28626 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0020  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-28 00:00:00' AND c.`shedule` < '2024-05-02 23:59:59' AND l.id = 28626 ORDER BY c.shedule ASC, fcoef DESC LIMIT 5
0.0020  SELECT data1, data2 FROM services_tags WHERE categoryId=328
0.0020  SELECT l.year,l.group_code FROM leagues_besoccer l WHERE l.categoryId = 328 AND l.year = 2010 ORDER BY l.group_code ASC
0.0020  SELECT group_code, extraName from `leagues` WHERE categoryId=328 AND year=2010