4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
« Temporada Anterior
Temporada 2001
Temporada Siguiente »
Publicidad 600x120.gif
Botola 2 2001
2000/2001

Botola 2 2001

Información Histórica 
						
Second Level 2000/01

Table:

 1.Ittihad Ryadi (Tanger) 30 17  9  4 52-22  60  Promoted
 2.Stade Marocain (Rabat) 30 17  7  6 52-24  58  Promoted
-----------------------------------------------
 3.TAS Casablanca         30 15 10  5 34-22  55
 4.KAC Kénitra            30 11 13  5 24-16  46
 5.SA Sporting Salé       30 12 10  8 30-26  46  [43?]
 6.Union Sidi Kacem       30 13  6 11 33-30  45
 7.Maghreb Tétouan        30 10 13  6 22-20  43
 8.Chabab Khénifra	  30 10 12  8 28-25  42
 9.Mouloudia Oujda        30  9 11 10 27-21  38
10.Difaa Hassani Jadidi   30  9  9 12 27-32  36
11.Association Salé       30  9  8 13 28-37  35
12.Rachad Bernossi        30  8 10 12 24-35  34
13.Olympic de Safi        30  6 14 10 20-24  32
14.WAF Fès                29  7  9 13 19-26  30  [33?]
-----------------------------------------------
15.Ittihad Yacoub Mansour 29  4 13 12 15-34  25  [Rabat]       Relegated
16.Chabab Hay El Hassani  30  2  6 22 15-57  12  [Casablanca]  Relegated

Round 1 [Sep 24]
Olympic 	0-0 Tanger
TAS 		0-2 Sporting 
Hassani 	1-1 Sidi Kacem
Stade 		4-1 Mansour
WAF 		0-0 KAC
AS	        2-0 Bernossi
Tétouan		1-0 Jadidi
Khénifra	0-0 Oujda

Round 2 [Oct 1]
Tanger		3-2 Khénifra
Sporting	0-2 Olympic
Sidi Kacem	2-1 TAS
Mansour		2-0 Hassani
KAC		1-0 Stade
Bernossi	2-0 WAF
Jadidi		2-2 AS
Oujda		0-1 Tétouan

Round 3 [Oct 7]
Tanger		1-1 Sporting
Olympic		0-1 Sidi Kacem
TAS		1-0 Mansour
Hassani		0-1 KAC
Stade		6-0 Bernossi
WAF		1-0 Jadidi
AS		1-0 Oujda
Khénifra	0-0 Tétouan

Round 4 [Oct 15]
Sporting	2-1 Khénifra
Sidi Kacem	2-1 Tanger
Mansour		0-0 Olympic
KAC		1-1 TAS
Bernossi	3-1 Hassani
Jadidi		2-1 Stade
Oujda		0-1 WAF
Tétouan		0-1 AS

Round 5 [Oct 22]
Sporting	1-0 Sidi Kacem
Tanger		3-1 Mansour
Olympic		0-0 KAC
TAS		1-2 Bernossi
Hassani		0-0 Jadidi
Stade		1-0 Oujda
WAF		0-1 Tétouan
Khénifra	1-1 AS

Round 6 [Nov 5]
Sidi Kacem	1-1 Khénifra
Mansour		1-1 Sporting
KAC		1-0 Tanger
Bernossi	1-1 Olympic
Jadidi		0-1 TAS
Oujda		2-0 Hassani
Tétouan		1-1 Stade
AS		0-1 WAF

Round 7 [Nov 12]
Sidi Kacem	1-2 Mansour
Sporting	1-1 KAC
Tanger		2-1 Bernossi
Olympic		2-1 Jadidi
TAS		0-0 Oujda
Hassani		1-0 Tétouan
Stade		2-1 AS
Khénifra	2-1 WAF

Round 8 [Nov 19]
Mansour		0-2 Khénifra
KAC		0-0 Sidi Kacem
Bernossi	1-0 Sporting
Jadidi		0-4 Tanger
Oujda		1-0 Olympic
Tétouan		2-2 TAS
AS		2-0 Hassani
WAF		1-3 Stade

Round 9 [Nov 26]
Mansour		0-0 KAC
Sidi Kacem	1-0 Bernossi
Sporting	1-1 Jadidi
Tanger		2-1 Oujda
Olympic		0-0 Tétouan
TAS		2-1 AS
Hassani		0-1 WAF
Khénifra	1-1 Stade

Round 10 [Dec 3]
KAC		1-0 Khénifra
Bernossi	0-1 Mansour
Jadidi		1-0 Sidi Kacem
Oujda		2-2 Sporting
Tétouan		2-1 Tanger
AS		2-1 Olympic
WAF		0-2 TAS
Stade		3-0 Hassani

Round 11 [Dec 10]
KAC		2-2 Bernossi
Mansour		0-0 Jadidi
Sidi Kacem	1-1 Oujda
Sporting	0-2 Tétouan
Tanger		5-0 AS
Olympic		0-0 WAF
TAS		1-0 Stade
Khénifra	1-0 Hassani

Round 12 [Dec 17]
Bernossi	3-2 Khénifra
Jadidi		0-1 KAC
Oujda		0-0 Mansour
Tétouan		1-0 Sidi Kacem
AS		0-3 Sporting
WAF		3-1 Tanger
Stade		2-1 Olympic
Hassani		1-2 TAS

Round 13 [Dec 24]
Bernossi	0-0 Jadidi
KAC		1-1 Oujda
Mansour		0-0 Tétouan
Sidi Kacem	1-0 AS
Sporting	1-0 WAF          [later awarded to WAF?]
Tanger		2-0 Stade
Olympic		4-1 Hassani
Khénifra	0-0 TAS

Round 14 [Dec 31]
Khénifra	3-1 Jadidi
Oujda		2-1 Bernossi
Tétouan		0-0 KAC
AS		1-1 Mansour
WAF		0-1 Sidi Kacem
Stade		1-1 Sporting
Hassani		1-1 Tanger
TAS		1-0 Olympic

Round 15 [Jan 7]
Jadidi		1-0 Oujda
Bernossi	0-0 Tétouan
KAC		1-0 AS
Mansour		1-1 WAF
Sidi Kacem	1-3 Stade
Sporting	2-1 Hassani
Tanger		2-1 TAS
Olympic		1-1 Khénifra

Round 16 
[Jan 20]
Tanger		2-0 Olympic	
Mansour		0-5 Stade	
[Jan 21]
Sporting	0-0 TAS
Sidi Kacem	2-0 Hassani
KAC		2-1 WAF
Bernossi	1-0 AS
Jadidi		1-1 Tétouan
Oujda		1-0 Khénifra

Round 17 [Jan 27]
Khénifra	0-0 Tanger
Olympic		0-2 Sporting
TAS		2-1 Sidi Kacem
Hassani		3-0 Mansour
Stade		1-0 KAC
WAF		0-0 Bernossi
AS		1-1 Jadidi
Tétouan		1-0 Oujda

Round 18
[Feb 3]
Sporting        0-2 Ittihad
Sidi Kacem      3-1 Olympic
Mansour         0-0 TAS
Bernossi        1-0 Stade
Jadidi          1-0 WAF
Oujda           1-1 AS
Tétouan         2-0 Khénifra
[Feb 7]
KAC             1-1 Hassani

Round 19 [Feb 11]
Khénifra	1-0 Sporting
Tanger		1-0 Sidi Kacem
Olympic		0-0 Mansour
TAS		1-1 KAC
Hassani		0-2 Bernossi
Stade		1-0 Jadidi
WAF		0-0 Oujda
AS		3-0 Tétouan

Round 20 [Feb 25]
Sidi Kacem	0-1 Sporting
Mansour		0-1 Tanger
KAC		0-1 Olympic
Bernossi	0-0 TAS
Jadidi		4-0 Hassani
Oujda		5-0 Stade
Tétouan		1-1 WAF
AS		0-0 Khénifra

Round 21 [Mar 3]
Khénifra	0-0 Sidi Kacem
Sporting	0-0 Mansour         [also reported 1-1]
Tanger		0-0 KAC
Olympic		2-1 Bernossi
TAS		1-0 Jadidi
Hassani		1-1 Oujda
Stade		0-0 Tétouan
WAF		1-1 AS

Round 22 [Mar 10]
Mansour         3-2 Sidi Kacem
KAC             0-0 Sporting
Bernossi        0-0 Tanger
Jadidi          1-1 Olympic
Oujda           3-0 TAS
Tétouan         3-1 Hassani
AS              0-2 Stade
WAF             0-0 Khénifra

Round 23 [Mar 17]
Khénifra	1-0 Mansour
Sidi Kacem      2-1 KAC
Sporting        2-1 Bernossi
Tanger          5-2 Jadidi
Olympic         0-0 Oujda
TAS             1-0 Tétouan
Hassani         0-1 AS
Stade           1-0 WAF

Round 24 [Mar 24]
KAC		1-0 Mansour
Bernossi	1-3 Sidi Kacem
Jadidi		1-0 Sporting
Oujda		0-2 Tanger
Tétouan		1-1 Olympic
AS		0-2 TAS
WAF		4-0 Hassani
Stade		1-0 Khénifra

Round 25 [Apr 7]
Khénifra	2-0 KAC
Mansour		0-0 Bernossi
Sidi Kacem	2-2 Jadidi
Sporting	2-1 Oujda
Tanger		1-1 Tétouan
Olympic		0-1 AS
TAS		2-1 WAF
Hassani		0-4 Stade

Round 26 [Apr 15]  
Bernossi        0-2 KAC
Jadidi          3-0 Mansour 
Oujda           1-2 Sidi Kacem 
Tétouan         0-1 Sporting
AS              1-2 Tanger 
WAF             0-1 Olympic
Stade           1-1 TAS 
Hassani         1-3 Khénifra 

Round 27 [Apr 28]
Khénifra	3-1 Bernossi
KAC		0-1 Jadidi
Mansour		0-1 Oujda
Sidi Kacem	1-0 Tétouan
Sporting	1-2 AS
Tanger		3-0 WAF
Olympic		1-1 Stade
TAS		2-1 Hassani

Round 28
[May 5]
Jadidi		1-0 Bernossi
Tétouan		1-0 Mansour
AS		1-2 Sidi Kacem
WAF		0-0 Sporting
Stade		1-1 Tanger
Hassani		0-0 Olympic
TAS		4-0 Khénifra
[May 6]
Oujda		1-0 KAC

Round 29 [May 12]
Jadidi		0-1 Khénifra
Bernossi	0-0 Oujda
KAC		3-0 Tétouan	[awarded; Tétouan dns]
Mansour		2-2 AS
Sidi Kacem	0-1 WAF
Sporting	1-4 Stade
Tanger		3-0 Hassani
Olympic		0-1 TAS

Round 30 
[May 19]
Oujda		2-0 Jadidi
Tétouan		0-0 Bernossi
AS		0-2 KAC
Stade		2-0 Sidi Kacem
Hassani		0-2 Sporting
TAS		1-1 Tanger
Khénifra	0-0 Olympic
[May 26]
WAF		--- Mansour

Table:

 1.Ittihad Ryadi (Tanger) 30 17  9  4 52-22  60  Promoted
 2.Stade Marocain (Rabat) 30 17  7  6 52-24  58  Promoted
-----------------------------------------------
 3.TAS Casablanca         30 15 10  5 34-22  55
 4.KAC Kénitra            30 11 13  5 24-16  46
 5.SA Sporting Salé       30 12 10  8 30-26  46  [43?]
 6.Union Sidi Kacem       30 13  6 11 33-30  45
 7.Maghreb Tétouan        30 10 13  6 22-20  43
 8.Chabab Khénifra	  30 10 12  8 28-25  42
 9.Mouloudia Oujda        30  9 11 10 27-21  38
10.Difaa Hassani Jadidi   30  9  9 12 27-32  36
11.Association Salé       30  9  8 13 28-37  35
12.Rachad Bernossi        30  8 10 12 24-35  34
13.Olympic de Safi        30  6 14 10 20-24  32
14.WAF Fès                29  7  9 13 19-26  30  [33?]
-----------------------------------------------
15.Ittihad Yacoub Mansour 29  4 13 12 15-34  25  [Rabat]       Relegated
16.Chabab Hay El Hassani  30  2  6 22 15-57  12  [Casablanca]  Relegated

NB: Stade Marocain was last at the top level in 1969



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

Last updated: 7 Nov 2002

(C) Copyright José Batalha and RSSSF 2000/02


  USO DE MEMORIA  
4,222,336 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0038
Controller Execution Time ( Home / Category )  0.5797
Total Execution Time  0.5836
  CADENA URL  
/elite_2_marruecos2001
  GET DATOS  
$_GET['/elite_2_marruecos2001']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (37)  
0.0127  SELECT type FROM routes WHERE alias = 'elite_2_marruecos2001'
0.0261  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'elite_2_marruecos' AND (l.group_code = 1 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 2001 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=1 DESC LIMIT 1
0.0129  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=409 AND type_rel = 3
0.0135  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 3 AND rel.typeId = 409 AND rel.ln = 'es' AND rel.status=1 ORDER BY rel.creation_date desc,rel.cover_points DESC LIMIT 5
0.0137  SELECT /*53 bs_news_model*/ n.id, n.author_id, n.headline, n.external_headline, n.live_headline, n.creation_date, n.update_date, n.pub_date, n.alias, n.subheadline, n.teaser, n.media, n.tags, n.views, n.screens, n.clicks, n.relations, n.comments, n.power_cover, n.cover_points, u.name as user_name FROM bs_news n INNER JOIN bs_editors u ON u.id = n.author_id AND u.ln = 'es' WHERE n.status = 1 AND n.ln = 'es' AND n.id IN (975843,911464,803650,73999) ORDER BY n.cover_points DESC, update_date DESC
0.0130  SELECT text_es as historical_text FROM leagues_text WHERE id=1149
0.0132  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 = 29455 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='2001' WHERE c.parentId=409 GROUP BY c.id ORDER BY c.order_id ASC
0.0125  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-04-27 10:09:13' 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 10:09:13' 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 10:09:13' 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 10:09:13' 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 = 'elite_2_marruecos' AND (l.group_code = 0 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 2001 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 events2001 e WHERE e.league_id IN (29455) 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 (29455) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN () ORDER BY rp.in_squad = 1 DESC
0.0125  SELECT e.action, count(e.action) as total, e.player_id FROM events2001 e WHERE e.league_id IN (29455) 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 (29455) 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 events2001 e WHERE e.league_id IN (29455) AND (e.action IN (3,4) ) GROUP BY e.player_id ORDER BY total DESC, e.player_id ASC LIMIT 20
0.0127  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 (29455) 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 events2001 e WHERE e.league_id IN (29455) AND (e.action IN (22) ) GROUP BY e.player_id ORDER BY total DESC, e.player_id ASC LIMIT 20
0.0132  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 (29455) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN () ORDER BY rp.in_squad = 1 DESC
0.0125  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 = 29455 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 = 29455 AND rp.events > 0 ORDER BY rp.events DESC,p.pod DESC LIMIT 20
0.0128  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=29455 AND rel.round=30
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 = 29455 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 = 29455 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` = 29455 ORDER BY creation_date DESC LIMIT 0, 10
0.0132  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` = 29455
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 `calendars2001` 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` = 29455 AND c.`round` = 30 ORDER BY shedule ASC LIMIT 200
0.0126  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 `events2001` e INNER JOIN calendars2001 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 = 30 AND e.real_date IS NOT NULL AND e.league_id = 29455 ORDER BY total DESC LIMIT 40
0.0128  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 `events2001` e INNER JOIN calendars2001 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 = 29455 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 `tables2001` 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 = 29455 AND t.round = 28 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 `tables2001` 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 = 29455 AND t.round = 30 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 = 29455 ORDER BY c.shedule ASC, fcoef DESC LIMIT 5
0.0127  SELECT data1, data2 FROM services_tags WHERE categoryId=409
0.0127  SELECT l.year,l.group_code FROM leagues_besoccer l WHERE l.categoryId = 409 AND l.year = 2001 ORDER BY l.group_code ASC
0.0127  SELECT group_code, extraName from `leagues` WHERE categoryId=409 AND year=2001