4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Información Histórica 
						
Final Table:

 1.Raja Casablanca      30 16 11  3  45-22 59  Champions
 2.WA Casablanca        30 14 12  4  37-18 54
 3.MAS Fès              30 14 11  5  29-18 53
 4.FUS Rabat            30 14 10  6  39-23 52
 5.Hassania US Agadir   30 12 13  5  30-18 49
 6.Nehdat Settat        30 13  8  9  31-26 47
 7.OC Khouribga         30 12  7 11  27-22 43
 8.SC Chabab Mohammédia 30 11  7 12  21-21 40
 9.FAR Rabat            30  7 16  7  24-24 37
10.TS Ittihad Ryadi     30  9  9 12  25-33 36   [Casablanca]
11.KAC Marrakesh        30  6 15  9  24-29 33
12.COD Meknès           30  8  6 16  20-33 30
13.JS Massira           30  4 15 11  19-34 27
14.Raja Béni Mellal     30  6  9 15  17-41 27
---------------------------------------------
15.WA Fès               30  5 11 14  19-31 26  Relegated
16.SA Salé              30  3 12 15  19-33 21  Relegated

Round 1 [Sep 5] 
Raja BM         0-1 Raja Casablanca   [Sep 8]
Settat          2-0 Sporting Salé
Jeunesse        1-1 FUS       
KAC             awd Mohammédia        [awarded 0-0 to KAC, Mohammedia dns]
FAR             0-1 Hassania          [Sep 8]
Ittihad         1-1 Khouribga 
WAC Casablanca  1-1 MAS               [Sep 8]
WAF Fès         3-0 Meknès

Round 2 [Sep 12]
Raja Casablanca 1-0 WAF Fès
Sporting Salé   1-1 Raja BM
FUS             0-0 Settat
Mohammédia      2-0 Jeunesse
Hassania        1-0 KAC
Khouribga       0-1 FAR
MAS             0-0 Ittihad           [Sep 11]
Meknès          0-0 WAC Casablanca

Round 3 [Sep 19]
Raja Casablanca 0-0 Sporting Salé     [Sep 22]
Raja BM         1-2 FUS
Settat          1-0 Mohammédia
Jeunesse        1-1 Hassania
KAC             2-2 Khouribga 
FAR             1-1 MAS               [Sep 29]
Ittihad         3-1 Meknès
WAF Fès         0-1 WAC Casablanca    [Nov 329]
  
Round 4 [Sep 25]
Sporting Salé   0-0 WAF Fès           [Sep 26]
FUS             0-2 Raja Casablanca
Mohammédia      1-0 Raja BM
Hassania        0-0 Settat 
Khouribga       3-1 Jeunesse
MAS             2-0 KAC
Meknès          2-2 FAR       
WAC Casablanca  1-1 Ittihad   

Round 5 [Oct 3]
Sporting Salé   0-1 FUS
Raja Casablanca 1-0 Mohammédia
Raja BM         0-0 Hassania
Settat          2-1 Khouribga
Jeunesse        1-1 MAS
KAC             3-1 Meknès
FAR             1-1 WAC Casablanca
WAF Fès         0-0 Ittihad

Round 6 [Oct 10]
Ittihad         1-2 FAR
Khouribga       4-0 Raja BM
FUS             1-0 WAF Fès           [Oct 9]    
Mohammédia      1-0 Sporting Salé
Meknès          2-0 Jeunesse
MAS             3-0 Settat
Hassania        3-2 Raja Casablanca   [Nov 10]
WAC Casablanca  0-0 KAC               [Dec 1]

Round 7 [Oct 24]
FUS             1-1 Mohammédia
Sporting Salé   0-0 Hassania
Raja BM         0-1 MAS
Settat          2-1 Meknès
KAC             3-1 Ittihad
WAF Fès         0-1 FAR
Raja Casablanca 0-0 Khouribga         [Nov 30]
Jeunesse        0-0 WAC Casablanca    [Dec 12]

Round 8 [Nov 7]
Mohammédia      0-0 WAF Fès
Hassania        2-1 FUS
Khouribga       1-2 Sporting Salé
Meknès          2-0 Raja BM
WAC Casablanca  1-0 Settat            [Nov 6]
Ittihad         0-0 Jeunesse          [Nov 6]
FAR             0-2 KAC               [Nov 6]
MAS             1-1 Raja Casablanca   [Jan 22]

Round 9 [Nov 14]
Mohammédia      1-1 Hassania
FUS             2-0 Khouribga
Sporting Salé   0-0 MAS               [Nov 13]         
Raja Casablanca 2-1 Meknès
Raja BM         2-0 WAC Casablanca    [Dec 22]
Settat          1-0 Ittihad
Jeunesse        1-1 FAR
WAF Fès         1-1 KAC

Round 10 [Nov 21]
Hassania        1-1 WAF Fès
Khouribga       0-1 Mohammédia
MAS             0-0 FUS
Meknès          1-0 Sporting Salé
WAC Casablanca  0-0 Raja Casablanca   [Feb 24]
Ittihad         1-0 Raja BM           [Nov 20]
FAR             0-0 Settat            [Nov 20]
KAC             0-0 Jeunesse

Round 11 [Dec 5]
Hassania        1-0 Khourigba
Mohammédia      0-1 MAS
FUS             2-0 Meknès
Sporting Salé   1-1 WAC Casablanca
Raja Casablanca 1-0 Ittihad           [Feb 2]
Raja BM         0-2 FAR
Settat          0-1 KAC
WAF Fès         1-1 Jeunesse

Round 12 [Dec 19]
Khouribga       2-1 WAF Fès
MAS             1-0 Hassania
Meknès          0-2 Mohammédia
WAC Casablanca  1-2 FUS 
Ittihad         2-1 Sporting Salé
FAR             1-1 Raja Casablanca
KAC             1-1 Raja BM
Jeunesse        0-2 Settat

Round 13 [Jan 2]
Khouribga       1-0 MAS
Hassania        1-0 Meknès
Mohammédia      0-1 WAC Casablanca
FUS             0-0 Ittihad           [Jan 1]
Sporting Salé   0-1 FAR               [Jan 1]
Raja Casablanca 2-0 KAC               [Feb 9]
Raja BM         1-1 Jeunesse
WAF Fès         1-2 Settat

Round 14 [Jan 16]
WAF Fès         0-0 MAS               [Jan 15]
Meknès          1-0 Khouribga
WAC Casablanca  0-0 Hassania
Ittihad         1-0 Mohammédia        [Jan 15]    
FAR             0-0 FUS
KAC             1-2 Sporting Salé
Jeunesse        0-0 Raja Casablanca
Settat          2-1 Raja BM           [Jan 15] 

Round 15 [Jan 30]
MAS             2-1 Meknès
Khouribga       0-2 WAC Casablanca
Hassania        1-0 Ittihad     
Mohammédia      0-0 FAR
FUS             2-1 KAC
Sporting Salé   1-1 Jeunesse
Raja Casablanca 4-1 Settat
Raja BM         1-0 WAF Fès

Round 16 [Feb 5]
Raja Casablanca 0-1 Raja BM
Sporting Salé   1-1 Settat
FUS             1-0 Jeunesse    
Mohammédia      0-0 KAC
Hassania        1-0 FAR
Khouribga       1-0 Ittihad
MAS             1-0 WAC Casablanca
Meknès          0-0 WAF Fès

Round 17 [Feb 12]
WAF Fès         1-2 Raja Casablanca   [Feb 13]
Raja BM         1-1 Sporting Salé 
Settat          1-1 FUS
Jeunesse        0-1 Mohammédia  
KAC             0-0 Hassania    
FAR             1-1 Khouribga   
Ittihad         1-0 MAS
WAC Casablanca  2-0 Meknès

Round 18 [Mar 4]
Sporting Salé   abd Raja Casablanca   [abandoned after 9 sending-offs]
FUS             6-0 Raja BM
Mohammédia      1-0 Settat
Hassania        1-1 Jeunesse
Khouribga       3-0 KAC 
MAS             2-1 FAR
Meknès          1-0 Ittihad     
WAC Casablanca  2-0 WAF Fès
Sporting Salé	2-3 Raja Casablanca	[Apr 12]

Round 19 [Mar 19]
WAF Fès		1-0 Sporting Salé
Raja BM		2-1 Mohammédia
Settat		1-0 Hassania
Jeunesse	0-1 Khouribga
KAC		0-0 MAS
Ittihad		1-3 WAC Casablanca	[Mar 22]
Raja Casablanca	2-2 FUS                 [May 10]
FAR		0-0 Meknès		[Apr 12]

Round 20 [Apr 2]
FUS		1-1 Sporting Salé
Mohammédia	0-3 Raja Casablanca	[May 31]
Hassania	5-0 Raja BM
Khouribga	0-1 Settat
MAS		1-0 Jeunesse
Meknès		0-0 KAC                 [Apr 26]
WAC Casablanca	3-3 FAR                 [Apr 26]
Ittihad		0-1 WAF Fès

Round 21 [Apr 9]
WAF Fès		2-5 FUS                 [May 28]
Sporting Salé	0-2 Mohammédia
Raja Casablanca	1-1 Hassania		[Jun 4]
Raja BM		0-0 Khouribga
Settat		0-0 MAS
Jeunesse	0-2 Meknès
KAC		1-2 WAC Casablanca      [May 10]
FAR		1-2 Ittihad
 
Round 22 [Apr 16]
Mohammédia	0-1 FUS
Hassania	1-0 Sporting Salé
Khouribga	0-0 Raja Casablanca
MAS		1-0 Raja BM
Meknès		2-0 Settat
WAC Casablanca	3-0 Jeunesse
Ittihad		1-1 KAC			[Apr 15]
FAR		0-0 WAF Fès
 
Round 23 [Apr 22]
WAF Fès		0-0 Mohammédia
Sporting Salé	0-1 Khouribga
Raja BM		0-0 Meknès        
Settat		0-1 WAC Casablanca
Jeunesse	2-0 Ittihad
KAC		1-1 FAR
FUS		3-2 Hassania		[Jun 8]
Raja Casablanca	3-1 MAS			[Jun 8]

Round 24 [Apr 29]
Hassania        2-0 Mohammedia 
Khouribga       1-0 FUS 
MAS             3-2 Sporting Sale 
Meknes          1-3 Raja Casablanca 
WAC Casablanca  3-0 Raja BM
Ittihad         1-1 Settat
FAR             0-1 Jeunesse 
Marrakesh       2-2 WAF Fes 

Round 25 [May 14]
Raja Casablanca 1-1 WAC Casablanca
Settat          3-1 FAR
FUS             2-1 MAS
Sporting Sale   1-0 Meknes  
Jeunesse        1-1 Marrakesh  
Mohammedia      1-0 Khouribga 
WAF Fes         1-0 Hassania 
Raja BM         3-0 Ittihad

Round 26 [May 17]
Khouribga	0-0 Hassania
MAS		1-0 Mohammédia
Meknès		1-0 FUS
WAC Casablanca	1-1 Sporting Salé
Ittihad		2-1 Raja Casablanca
FAR		2-0 Raja BM
KAC		0-1 Settat
Jeunesse	2-1 WAF Fès

Round 27 [May 21]
WAF Fès		0-1 Khouribga
Hassania	1-1 MAS
Mohammédia	1-0 Meknès
FUS		1-0 WAC Casablanca
Sporting Salé	0-1 Ittihad
Raja Casablanca	0-0 FAR
Raja BM		1-1 KAC
Settat		1-1 Jeunesse

Round 28 [Jun 11]
MAS		1-2 Khouribga
Meknès		0-2 Hassania
WAC Casablanca	2-0 Mohammédia
Ittihad		2-1 FUS
FAR		0-0 Sporting Salé
KAC		0-1 Raja Casablanca
Jeunesse	0-0 Raja BM
Settat		4-0 WAF Fès

Round 29 [Jun 21]
MAS		1-0 WAF Fès
Khouribga	1-0 Meknès
Hassania	1-3 WAC Casablanca
Mohammédia	5-3 Ittihad
FUS		0-1 FAR
Sporting Salé	1-2 KAC
Raja Casablanca	4-1 Jeunesse
Raja BM		1-0 Settat

Round 30 [Jun 25]
Meknès		0-1 MAS
WAC Casablanca	1-0 Khouribga
Ittihad		0-0 Hassania
FAR		0-0 Mohammédia
KAC		0-0 FUS
Jeunesse	2-1 Sporting Salé
Settat		2-3 Raja Casablanca
WAF Fès		2-0 Raja BM

Final Table:

 1.Raja Casablanca      30 16 11  3  45-22 59  Champions
 2.WA Casablanca        30 14 12  4  37-18 54
 3.MAS Fès              30 14 11  5  29-18 53
 4.FUS Rabat            30 14 10  6  39-23 52
 5.Hassania US Agadir   30 12 13  5  30-18 49
 6.Nehdat Settat        30 13  8  9  31-26 47
 7.OC Khouribga         30 12  7 11  27-22 43
 8.SC Chabab Mohammédia 30 11  7 12  21-21 40
 9.FAR Rabat            30  7 16  7  24-24 37
10.TS Ittihad Ryadi     30  9  9 12  25-33 36   [Casablanca]
11.KAC Marrakesh        30  6 15  9  24-29 33
12.COD Meknès           30  8  6 16  20-33 30
13.JS Massira           30  4 15 11  19-34 27
14.Raja Béni Mellal     30  6  9 15  17-41 27
---------------------------------------------
15.WA Fès               30  5 11 14  19-31 26  Relegated
16.SA Salé              30  3 12 15  19-33 21  Relegated


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

Last updated: 5 Nov 2002

(C) Copyright José Batalha and RSSSF 1999/2002


  USO DE MEMORIA  
4,308,360 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0020
Controller Execution Time ( Home / Category )  0.4663
Total Execution Time  0.4683
  CADENA URL  
/marruecos2000
  GET DATOS  
$_GET['/marruecos2000']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (34)  
0.0106  SELECT type FROM routes WHERE alias = 'marruecos2000'
0.0214  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'marruecos' AND (l.group_code = 1 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 2000 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=1 DESC LIMIT 1
0.0110  SELECT text_es as historical_text FROM leagues_text WHERE id=834
0.0107  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 = 29152 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0111  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='2000' WHERE c.parentId=65 GROUP BY c.id ORDER BY c.order_id ASC
0.0105  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-04-18 07:24:13' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0106  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=2 AND last_update > '2024-04-18 07:24:13' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0105  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=4 AND last_update > '2024-04-18 07:24:13' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0105  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=3 AND last_update > '2024-04-18 07:24:13' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0110  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'marruecos' AND (l.group_code = 0 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 2000 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=0 DESC LIMIT 1
0.0105  SELECT e.action, count(e.action) as total, e.player_id FROM events2000 e WHERE e.league_id IN (29152) 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.0107  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 (29152) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN () ORDER BY rp.in_squad = 1 DESC
0.0110  SELECT e.action, count(e.action) as total, e.player_id FROM events2000 e WHERE e.league_id IN (29152) AND (e.action IN (4,5) ) GROUP BY e.player_id ORDER BY total DESC, e.player_id ASC LIMIT 20
0.0110  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 (29152) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN () ORDER BY rp.in_squad = 1 DESC
0.0115  SELECT e.action, count(e.action) as total, e.player_id FROM events2000 e WHERE e.league_id IN (29152) AND (e.action IN (3,4) ) GROUP BY e.player_id ORDER BY total DESC, e.player_id ASC LIMIT 20
0.0115  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 (29152) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN () ORDER BY rp.in_squad = 1 DESC
0.0115  SELECT e.action, count(e.action) as total, e.player_id FROM events2000 e WHERE e.league_id IN (29152) AND (e.action IN (22) ) GROUP BY e.player_id ORDER BY total DESC, e.player_id ASC LIMIT 20
0.0112  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 (29152) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN () ORDER BY rp.in_squad = 1 DESC
0.0111  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 = 29152 AND rp.lineup > 0 ORDER BY rp.lineup DESC,p.pod DESC LIMIT 20
0.0108  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 = 29152 AND rp.events > 0 ORDER BY rp.events DESC,p.pod DESC LIMIT 20
0.0121  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=29152 AND rel.round=30
0.0118  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 = 29152 AND esl.points > 0 ORDER BY esl.points DESC LIMIT 3
0.0115  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 = 29152 AND esl.points > 0
0.0115  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-19" AND c.`active`= 1 and c.comment_id is null and c.lang = 1 AND l.`id` = 29152 ORDER BY creation_date DESC LIMIT 0, 10
0.0134  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-19" AND c.`active`= 1 and comment_id is null and c.lang = 1 AND l.`id` = 29152
0.0118  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 `calendars2000` 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` = 29152 AND c.`round` = 30 ORDER BY shedule ASC LIMIT 200
0.0108  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 `events2000` e INNER JOIN calendars2000 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 = 29152 ORDER BY total DESC LIMIT 40
0.0122  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 `events2000` e INNER JOIN calendars2000 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 = 29152 AND e.real_date > NOW() - INTERVAL 1 MONTH ORDER BY e.real_date DESC LIMIT 30
0.0111  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 `tables2000` 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 = 29152 AND t.round = 28 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0111  SELECT *,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables2000` 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 = 29152 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0111  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-18 00:00:00' AND c.`shedule` < '2024-04-22 23:59:59' AND l.id = 29152 ORDER BY c.shedule ASC, fcoef DESC LIMIT 5
0.0111  SELECT data1, data2 FROM services_tags WHERE categoryId=65
0.0111  SELECT l.year,l.group_code FROM leagues_besoccer l WHERE l.categoryId = 65 AND l.year = 2000 ORDER BY l.group_code ASC
0.0111  SELECT group_code, extraName from `leagues` WHERE categoryId=65 AND year=2000