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

Liga Benín 2002

Información Histórica 
						

Championnat National du Bénin
=============================

Start October 6

18 clubs are divided into 2 poules (previous editions usually had 1 poule with
12 clubs).

First 4 of each poule qualify for 'Super-Division'.

First championship after more than 2 years of interruption due to disagreements
within football authorities.

Group A
Buffles (nord)
Panthères (nord)
Cavaliers (nord)
Mogas 90 (sud)
Etoile (sud) 
Energie (sud)
ASACO (sud) 
Postel (sud)
Variétés (centre).

Group B
Dragons (sud) 
Requins (sud)
Soleil (sud)
ASJA (sud)
UNB (sud)
Tatapouranou (nord)
Lions (nord)
Tonnerre (centre) 
Vautour (centre)

Group A
-------

Round 1
[Oct 13]
Etoile  	1-4 Postel 
[Oct 14]
Buffles 	2-0 Energie
ASACO        	3-1 Panthères
Variétés 	0-0 Mogas 90
Cavaliers	bye

Round 2 [Oct 21]
Cavaliers       0-0 Postel 
Mogas 90        1-0 Panthères
Etoile		0-3 Energie
Variétés        1-0 ASACO
Buffles bye

Round 3
[Oct 28]
Mogas 90	2-0 Cavaliers
Energie		1-1 Panthères
[Oct 31]
ASACO		0-2 Buffles
[Dec 16]
Postel		3-0 Variétés	
Etoile		bye

Round 4
[Nov 1]
Postel		2-2 Mogas 90
[Nov 4]
Buffles		3-1 Etoile
Panthères	2-1 Cavaliers
[Nov 7]
Variétés	0-0 Energie
ASACO		bye

Round 5 [Nov 11]
Mogas 90	1-0 ASACO
Postel		2-0 Buffles
Variétés	1-0 Etoile
Energie FC	2-0 Cavalier
Panthères	bye

Round 6 [Nov 18]
Mogas 90	3-0 Energie
Buffles		0-0 Panthères
Cavaliers	0-0 Variétés
Etoile		1-1 ASACO
Postel		bye

Round 7 [Nov 25]
Mogas 90	3-0 Etoile
Buffles		3-2 Cavaliers
Variétés	0-1 Panthères
ASACO		2-2 Postel
Energie		bye

Round 8 [Dec 2]
Variétés	2-0 Buffles	
Panthères	1-0 Etoile	
Cavaliers	2-2 ASACO	
Postel		0-0 Energie	
Mogas 90	bye

Round 9 [Dec 9]
Postel		0-1 Panthères
Buffles		1-1 Mogas
Etoile		0-0 Cavaliers
ASACO		1-3 Energie
Variétés	bye

Round 10 [Feb 17]
Postel  	1-0 Etoile
Energie		0-1 Buffles
Panthères	1-0 ASACO
Mogas 90	0-0 Variétés
Cavaliers	bye

Round 11 [Feb 24]
Postel 		awd Cavaliers	[awarded 3-0 to Postel, Cavaliers dns]
Panthères	0-2 Mogas 90
Energie		2-1 Etoile
ASACO		2-0 Variétés
Buffles bye

Round 12 [Mar 3]
Cavaliers	0-4 Mogas 90
Panthères	1-0 Energie
Buffles		awd ASACO	[awarded 3-0 to Buffles, ASACO dns]
Variétés	1-0 Postel
Etoile		bye

Round 13 [Mar 10]
Mogas 90	0-1 Postel
Etoile		1-5 Buffles
Cavaliers	2-0 Panthères
Energie		0-0 Variétés
ASACO		bye

Round 14 [Mar 17]
ASACO		1-3 Mogas 90
Buffles		3-0 Postel
Etoile		0-3 Variétés
Cavalier	1-1 Energie FC
Panthères	bye

Round 15 [Mar 24]
Energie		2-2 Mogas 90
Panthères	0-1 Buffles
Variétés	0-2 Cavaliers
ASACO		3-1 Etoile
Postel		bye

Round 16 [Mar 31]
Etoile		0-3 Mogas 90
Cavaliers	0-3 Buffles
Panthères	0-1 Variétés
Postel		2-1 ASACO
Energie		bye

Round 17 [Apr 7]
Buffles		1-0 Variétés
Etoile		1-1 Panthères
ASACO		1-3 Cavaliers
Energie		1-0 Postel
Mogas 90	bye

Round 18 [Apr 14]
Panthères	1-0 Postel
Mogas		0-2 Buffles
Cavaliers	awd Etoile		[awarded 3-0 to Cavaliers, Etoile dns]
Energie		1-0 ASACO
Variétés	bye

Final Table:

 1.Buffles de Borgou	          16 12  2  2  30- 9  38  Qualified
 2.Mogas 90 de la Sonacop         16  9  5  2  27- 9  32  Qualified
 3.Postel de Cotonou              16  7  4  5  20-13  25  Qualified  
 4.Energie                        16  6  6  4  16-13  24  Qualified 
 - - - - - - - - - - - - - - - - - - - - - - - - - - - -
 5.Panthères de Djougou           16  7  3  6  11-13  24
 6.Variétés de Bohicon            16  6  5  5   9- 9  23  
 7.Cavaliers	                  16  4  5  7  16-23  17  
 8.ASACO de Cotonou	          16  3  3 10  17-27  12  
--------------------------------------------------------
 9.Etoile de Porto Novo           16  0  3 13   7-37   3  Relegated

Group B
-------

Round 1
[Oct 7]
Requins       	2-1 Dragons 
[Oct 14]
Lions   	1-0 Tonnerre 
Vautour  	awd Tatapouranou [awarded 3-0 win to Vautour, originally 1-0] 
ASJA  		1-3 UNB
Soleil		bye

Round 2 [Oct 21]
Vautour         1-0 Tonnerre
Lions           drw Tatapouranou [awarded 3-0 win to Lions, originally draw]
Soleil          1-0 UNB 
Dragons         1-0 ASJA
Requins bye

Round 3
[Oct 28]
Vautour		1-1 UNB
[Oct 31]
Dragons		3-1 Lions
Tonnerre	0-3 Requins
[Dec 13]
Tatapouranou	0-1 Soleil
ASJA		bye

Round 4
[Nov 4]
Dragons		3-1 Vautour
UNB		awd Tatapouranou [awarded 3-0 win to UNB; originally 1-0]
[Dec 16]
Lions		0-0 Soleil
Requins 	awd ASJA         [awarded 3-0 win to Requins; ASJA dns]
Tonnerre	bye

Round 5 [Nov 11]
Requins		2-1 UNB
Dragons		4-1 Soleil
Tatapouranou	awd Tonnerre     [awarded 3-0 win to Tonnerre; originally 2-1]
ASJA		2-0 Vautour
Lions		bye

Round 6 [Nov 18]
ASJA		2-2 Tonnerre
Requins		0-1 Lions
Soleil		1-2 Vautours
Tatapouranou	awd Dragons      [awarded 0-3 win to Dragons; originally 0-2]
UNB		bye 

Round 7 [Nov 25]
Lions		1-0 Vautours
Tonnerre	1-0 UNB
Requins		2-2 Soleil
ASJA		0-0 Tatapouranou
Dragons		bye

Round 8 
[Dec 2]
Soleil		1-0 Tonnerre
Vautours	1-0 Requins
ASJA		2-0 Lions
[Dec 16]
Dragons		3-2 UNB
Tatapouranou	bye

Round 9 [Dec 9]
Requins		2-0 Tatapouranou
Soleil		4-1 ASJA
Lions		1-0 UNB
Tonnerre	0-2 Dragons
Vautours	bye

Round 10 
[Feb 17]
Dragons 	0-2 Requins
Tonnerre 	0-0 Lions
Tatapouranou	0-1 Vautour
[Apr 28]
UNB		1-0 ASJA
Soleil		bye

Round 11
[Feb 24]
Tonnerre	0-1 Vautour
Tatapouranou	awd Lions	 [awarded 0-0 to Lions, Tatapouranou dns]
ASJA		0-1 Dragons
[May 1]
UNB		1-0 Soleil
Requins         bye

Round 12 [Mar 3]
UNB		0-0 Vautour
Lions		2-0 Dragons
Requins		1-1 Tonnerre
Soleil		4-2 Tatapouranou
ASJA		bye

Round 13 [Mar 10]
Vautour		0-0 Dragons
Tatapouranou	2-3 UNB
Soleil		2-1 Lions
ASJA		0-1 Requins	 [abandoned at 0-1 in 63'; stones thrown 
Tonnerre	bye               by ASJA fans; score allowed to stand]

Round 14 [Mar 17]
UNB		1-2 Requins
Soleil		0-2 Dragons
Tonnerre	1-0 Tatapouranou
Vautour		0-0 ASJA
Lions		bye

Round 15 [Mar 24]
Tonnerre	0-1 ASJA
Lions		1-1 Requins
Vautours	0-1 Soleil
Dragons		3-0 Tatapouranou
UNB		bye

Round 16
[Mar 31]
UNB		2-1 Tonnerre
Soleil		0-3 Requins
Tatapouranou	1-2 ASJA
[Apr 1]
Vautours	0-1 Lions
Dragons		bye

Round 17
[Apr 7] 
Tonnerre	0-1 Soleil
Lions		0-0 ASJA
[Apr 28]
Requins		awd Vautours		[awarded 3-0 win to Requins; Vautours dns]
[May 5]
UNB		0-1 Dragons
Tatapouranou	bye

Round 18
[Apr 14]
Tatapouranou	awd Requins		[awarded 3-0 win to Tatapouranou; Requins dns]
ASJA		0-1 Soleil
Dragons		0-0 Tonnerre
[Apr 21]
UNB		awd Lions		[awarded 3-0 win to UNB; Lions dns]
Vautours	bye

Final Table:

 1.Dragons de l'Ouémé             16 11  2  3  27-11  35  Qualified
 2.Requins de l'Atlantique        16 10  3  3  27-12  33  Qualified
 3.Soleil	                  16  9  2  5  19-16  29  Qualified
 4.Lions de Natitingou            16  8  4  4  13-11  28  Qualified 
 - - - - - - - - - - - - - - - - - - - - - - - - - - - -
 5.UNB                            16  7  2  7  21-16  23
 6.Vautours d'Ilacondji           16  6  4  6  12-15  22
 7.ASJA d'Avrankou	 	  16  4  4  8  11-18  16
 8.Tonnerre de Bohicon            16  3  4  9   9-16  13
--------------------------------------------------------
 9.Tatapouranou de Ouassa Péhunco 16  1  1 14   8-32   4  Relegated

NB: Tatapouranou had their matches in rounds 1-2, 4-6 awarded 0-3 losses
    for using ineligible players


Final Stage [aka 'Super-Ligue']
===========

Final Table:
           
 1.Dragons de l'Ouémé              8  4  3  1  10- 4  15  Champions
 2.Requins de l'Atlantique         8  4  3  1   6- 3  15
 3.Postel de Cotonou               8  4  1  3   9- 6  13    
 4.Buffles de Borgou	           8  4  1  3   8- 8  13     
 5.Lions de Natitingou             8  3  2  3   8- 6  11
 6.Mogas 90 de la Sonacop          8  2  3  3   6- 8   9
 7.Energie FC                      8  1  5  2   5- 5   8  
 8.Soleil	                   8  0  2  6   3-15   2

NB: teams only played teams from other preliminary group.

Round 1 [Jul 6]
Buffles		0-0 Dragons
Lions		3-1 Mogas 90
Postel		2-1 Soleil
Requins		0-0 Energie FC

Round 2
[Jul 13]
Soleil		1-1 Energie
[Jul 14]
Dragons		1-1 Mogas 90
Lions		0-1 Postel
Requins		2-1 Buffles

Round 3 [Jul 28]
Postel		2-0 Dragons
Mogas		0-1 Requins
Buffles		2-0 Soleil
Energie		0-0 Lions

Round 4
[Aug 4]
Soleil		0-1 Mogas
Requins		1-0 Postel
Lions		0-2 Buffles
[Aug 5]
Dragons		0-0 Energie

Round 5
[Aug 18]
Energie		0-1 Requins
Soleil		0-3 Postel
Mogas		2-1 Lions
[Aug 21]
Dragons		2-0 Buffles

Round 6
[Aug 24]
Postel		0-1 Lions
[Aug 25]
Buffles		2-1 Requins	
Energie		4-0 Soleil
Mogas		0-1 Dragons

Round 7 [Sep 15]
Requins		0-0 Mogas
Dragons		3-1 Postel
Soleil		0-1 Buffles
Lions		0-0 Energie

Round 8 [Sep 21]
Postel		0-0 Requins
Buffles		0-3 Lions
Energie		0-3 Dragons
Mogas		1-1 Soleil

Final Table:
           
 1.Dragons de l'Ouémé              8  4  3  1  10- 4  15  Champions
 2.Requins de l'Atlantique         8  4  3  1   6- 3  15
 3.Postel de Cotonou               8  4  1  3   9- 6  13    
 4.Buffles de Borgou	           8  4  1  3   8- 8  13     
 5.Lions de Natitingou             8  3  2  3   8- 6  11
 6.Mogas 90 de la Sonacop          8  2  3  3   6- 8   9
 7.Energie FC                      8  1  5  2   5- 5   8  
 8.Soleil	                   8  0  2  6   3-15   2

NB: teams only played teams from other preliminary group; matches against
    the teams from the same preliminary group did not count; had head-to-head
    results from the first stage counted, the table would have looked as follows:

(Unofficial) Table including head-to-head preliminary round:
           
 1.Requins de l'Atlantique        14  7  5  2  16- 8  26  [6 3 2 1 10- 5 11]
 2.Buffles de Borgou	          14  8  2  4  17-11  26  [6 4 1 1  9- 3 13] 
 3.Dragons de l'Ouémé             14  7  3  4  20-12  24  [6 3 0 3 10- 8  9]
 4.Postel de Cotonou              14  6  3  5  14-12  21  [6 2 2 2  5- 6  8]    
 5.Lions de Natitingou            14  5  4  5  14-12  19  [6 2 2 2  6- 6  8]
 6.Mogas 90 de la Sonacop         14  3  6  5  14-16  15  [6 1 3 2  8- 8  6]
 7.Energie FC                     14  2  7  5   8-13  13  [6 1 2 3  3- 8  5]
 8.Soleil	                  14  1  4  9   8-27   7  [6 1 2 3  5-12  5]


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

Last updated: 14 May 2003

(C) Copyright José Batalha and RSSSF 2001/03

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,249,184 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0028
Controller Execution Time ( Home / Category )  0.5705
Total Execution Time  0.5733
  CADENA URL  
/liga_benin2002
  GET DATOS  
$_GET['/liga_benin2002']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (36)  
0.0126  SELECT type FROM routes WHERE alias = 'liga_benin2002'
0.0257  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 = 2002 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=1 DESC LIMIT 1
0.0125  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=328 AND type_rel = 3
0.0129  SELECT text_es as historical_text FROM leagues_text WHERE id=298
0.0126  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 = 28615 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0127  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='2002' WHERE c.parentId=328 GROUP BY c.id ORDER BY c.order_id ASC
0.0125  SELECT type,rule FROM rules WHERE categoryId = 328 ORDER BY type = 'tables_draw' DESC,type != 'extra' DESC, `order` ASC
0.0125  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-04-27 20:40:11' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0125  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=2 AND last_update > '2024-04-27 20:40:11' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0125  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=4 AND last_update > '2024-04-27 20:40:11' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0125  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=3 AND last_update > '2024-04-27 20:40:11' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0131  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 = 2002 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=0 DESC LIMIT 1
0.0125  SELECT e.action, count(e.action) as total, e.player_id FROM events2002 e WHERE e.league_id IN (28615) 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.0125  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 (28615) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN () ORDER BY rp.in_squad = 1 DESC
0.0126  SELECT e.action, count(e.action) as total, e.player_id FROM events2002 e WHERE e.league_id IN (28615) AND (e.action IN (4,5) ) GROUP BY e.player_id ORDER BY total DESC, e.player_id ASC LIMIT 20
0.0126  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 (28615) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN () ORDER BY rp.in_squad = 1 DESC
0.0127  SELECT e.action, count(e.action) as total, e.player_id FROM events2002 e WHERE e.league_id IN (28615) AND (e.action IN (3,4) ) GROUP BY e.player_id ORDER BY total DESC, e.player_id ASC LIMIT 20
0.0126  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 (28615) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN () ORDER BY rp.in_squad = 1 DESC
0.0128  SELECT e.action, count(e.action) as total, e.player_id FROM events2002 e WHERE e.league_id IN (28615) AND (e.action IN (22) ) GROUP BY e.player_id ORDER BY total DESC, e.player_id ASC LIMIT 20
0.0125  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 (28615) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN () ORDER BY rp.in_squad = 1 DESC
0.0126  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 = 28615 AND rp.lineup > 0 ORDER BY rp.lineup DESC,p.pod DESC LIMIT 20
0.0125  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 = 28615 AND rp.events > 0 ORDER BY rp.events DESC,p.pod DESC LIMIT 20
0.0129  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=28615 AND rel.round=34
0.0126  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 = 28615 AND esl.points > 0 ORDER BY esl.points DESC LIMIT 3
0.0126  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 = 28615 AND esl.points > 0
0.0126  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` = 28615 ORDER BY creation_date DESC LIMIT 0, 10
0.0130  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` = 28615
0.0127  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 `calendars2002` 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` = 28615 AND c.`round` = 34 ORDER BY shedule ASC LIMIT 200
0.0125  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 `events2002` e INNER JOIN calendars2002 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 = 34 AND e.real_date IS NOT NULL AND e.league_id = 28615 ORDER BY total DESC LIMIT 40
0.0130  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 `events2002` e INNER JOIN calendars2002 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 = 28615 AND e.real_date > NOW() - INTERVAL 1 MONTH ORDER BY e.real_date DESC LIMIT 30
0.0127  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 `tables2002` 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 = 28615 AND t.round = 32 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0127  SELECT *,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables2002` 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 = 28615 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0127  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 = 28615 ORDER BY c.shedule ASC, fcoef DESC LIMIT 5
0.0127  SELECT data1, data2 FROM services_tags WHERE categoryId=328
0.0127  SELECT l.year,l.group_code FROM leagues_besoccer l WHERE l.categoryId = 328 AND l.year = 2002 ORDER BY l.group_code ASC
0.0127  SELECT group_code, extraName from `leagues` WHERE categoryId=328 AND year=2002