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 17 11  2  42-14 62  Champions
 2.KAC Marrakesh        30 16 10  4  49-18 58
 3.OC Khouribga         30 15  9  6  40-22 54
 4.WA Casablanca        30 14 10  6  46-27 52
 5.SA Salé              30  9 14  7  33-25 41
 6.MAS Fès              30 10 11  9  29-28 41
 7.FUS Rabat            30  9 14  7  26-25 41
 8.FAR Rabat            30 11  7 12  23-27 40
 9.JS Massira           30 10  6 14  26-43 36  [play in El Ayoun]
10.COD Meknès           30  7 13 10  23-35 34
11.Hassania US Agadir   30  6 15  9  28-31 33
12.WA Fès               30  7 10 13  21-37 31
13.SC Chabab Mohammédia 30  5 15 10  20-26 30
14.Raja Béni Mellal     30  6  9 15  19-28 27
---------------------------------------------
15.DH El Jadida         30  5 12 13  25-40 27  Relegated
16.MC Oujda             30  4 12 14  22-46 24  Relegated

Round 1 [Sep 27]
Meknes        1-0 Oujda
FUS           1-1 Marrakesh
Raja C        3-0 WAF
Khouribga     2-1 El Jadida
Agadir        1-2 Massira
Sale          1-0 Beni Mellal
MAS Fes       2-1 WAC            [Oct 28]
Mohammedia    0-2 FAR            [Oct 7]

Round 2 [Oct 4]
Oujda         1-0 FUS
Marrakesh     1-0 Raja C
WAF           0-0 Khouribga
El Jadida     1-1 Agadir         [also reported 1-0]
Massira       0-1 Sale
Beni Mellal   0-1 MAS Fes
WAC           1-0 Mohammedia
FAR           0-0 Meknes

Round 3 [Oct 11]
Meknes        1-1 FUS
Khouribga     1-2 Marrakesh
Agadir        2-0 WAF
Sale          5-1 El Jadida
MAS Fes       2-1 Massira
Mohammedia    0-0 Beni Mellal
Raja          6-0 Oujda          [Nov 11]
FAR           2-1 WAC            [Nov 11]

Round 4 [Oct 18]
FUS           0-2 Raja C
Oujda         1-1 Khouribga
Marrakesh     2-1 Agadir
WAF           0-4 Sale
El Jadida     2-2 MAS Fes
Massira       1-0 Mohammedia
WAC           1-0 Meknes
Beni Mellal   0-0 FAR           [Nov 25]

Round 5 [Oct 24,25] 
Khouribga     1-1 FUS
Agadir        1-0 Oujda
Sale          0-0 Marrakesh
MAS Fes       0-1 WAF
Mohammedia    0-0 El Jadida
Meknes        0-1 Raja C        [Nov 25]
WAC           2-0 Beni Mellal   [Dec 16]
FAR           2-0 Massira       [Dec 16]

Round 6 [Nov 1]
Raja C        2-2 Khouribga
FUS           0-1 Agadir
Oujda         0-2 Sale
Marrakesh     1-1 MAS Fes
WAF           0-3 Mohammedia
Massira       2-3 WAC
Beni Mellal   0-1 Meknes
El Jadida     0-1 FAR           [Jan 27]

Round 7 [Nov 8]
MAS Fes       2-0 Oujda
Mohammedia    0-2 Marrakesh
FAR           1-0 WAF
WAC           3-1 El Jadida
Beni Mellal   2-0 Massira
Sale          1-0 FUS
Meknes        1-1 Khouribga
Agadir        0-0 Raja C        [Dec 16]

Round 8 [Nov 15]
Massira       1-2 Meknes
Raja C        2-2 Sale
El Jadida     1-1 Beni Mellal
WAF           2-2 WAC
Marrakesh     1-0 FAR
Oujda         0-0 Mohammedia
FUS           1-2 MAS Fes
Khouribga     2-1 Agadir

Round 9 [Nov 22]
FAR           0-0 Oujda
Sale          1-1 Khouribga
WAC           1-0 Marrakesh
Beni Mellal   3-1 WAF
Meknes        1-1 Agadir
Massira       1-0 El Jadida
Mohammedia    1-1 FUS
MAS Fes       0-1 Raja C

Round 10 [Nov 29]
Marrakesh     2-0 Beni Mellal
WAF           0-1 Massira
El Jadida     2-2 Meknes
Oujda         1-1 WAC
FUS           2-0 FAR
Agadir        0-0 Sale
Raja C        0-0 Mohammedia
Khouribga     3-0 MAS Fes

Round 11 
[Dec 5]
FAR           0-1 Raja C
[Dec 6]
WAC           0-0 FUS
MAS Fes       1-2 Agadir
Beni Mellal   1-0 Oujda         [also reported 2-1]
Massira       1-0 Marrakesh
El Jadida     1-2 WAF
Mohammedia    3-1 Khouribga
Meknes        1-1 Sale

Round 12 [Dec 13]
Agadir        1-1 Mohammedia
FUS           1-0 Beni Mellal
Raja C        0-0 WAC           
WAF           1-0 Meknes
Marrakesh     2-0 El Jadida
Oujda         1-1 Massira
Khouribga     2-1 FAR
Sale          0-0 MAS Fes

Round 13 
[Dec 19]
FAR           1-0 Agadir
[Dec 20]
Mohammedia    0-0 Sale
WAF           1-0 Marrakesh
WAC           1-2 Khouribga
El Jadida     2-1 Oujda
Massira       2-2 FUS
[played later]
Meknes        1-1 MAS Fes
Beni Mellal   0-0 Raja C

Round 14 [Dec 27]
Meknes        0-1 Marrakesh
Oujda         0-3 WAF
FUS           2-1 El Jadida
Raja C        1-0 Massira
Khouribga     1-0 Beni Mellal
Agadir        1-2 WAC
Sale          0-1 FAR
MAS Fes       2-0 Mohammedia

Round 15 [Jan 3]
Beni Mellal   4-0 Agadir
WAC           4-1 Sale
Marrakesh     5-1 Oujda
El Jadida     0-0 Raja C
WAF           0-1 FUS
FAR           1-0 MAS Fes
Mohammedia    0-0 Meknes
Massira       1-4 Khouribga      [also reported 1-3]

Round 16 [Jan 23]
FAR           1-0 Mohammedia
WAC           5-0 MAS Fes
Beni Mellal   1-0 Sale 
Massira       1-0 Agadir 
El Jadida     0-0 Khouribga 
WAF           0-0 Raja C 
Marrakesh     2-0 FUS 
Oujda         3-1 Meknes

Round 17 [Jan 31]
FUS           1-0 Oujda
Raja C        0-0 Marrakesh
Meknes        2-0 FAR
Mohammedia    0-3 WAC
Agadir        0-1 El Jadida
Sale          2-1 Massira
Khouribga     2-0 WAF
MAS Fes       1-0 Beni Mellal

Round 18 [Feb 6,7]
FUS           1-1 Meknes
WAC           3-1 FAR
Beni Mellal   1-1 Mohammedia
Massira       0-0 MAS Fes
El Jadida     1-1 Sale
Marrakesh     1-0 Khouribga
Oujda         0-3 Raja C
WAF           0-0 Agadir

Round 19 [Feb 21]
FAR           1-0 Beni Mellal
Meknes        1-1 WAC
Mohammedia    0-0 Massira
MAS Fes       0-1 El Jadida
Sale          1-0 WAF
Agadir        1-1 Marrakesh
Khouribga     1-0 Oujda
Raja C        1-0 FUS

Round 20 [Feb 28]
Beni Mellal   0-0 WAC
Massira       2-1 FAR
El Jadida     1-0 Mohammedia
WAF           0-0 MAS Fes
Marrakesh     0-0 Sale
Oujda         1-1 Agadir
FUS           1-0 Khouribga
Raja C        2-0 Meknes

Round 21 [Mar 21]
FAR           2-0 El Jadida
Sale          3-0 Oujda
Agadir        2-2 FUS
Meknes        2-0 Beni Mellal
Khouribga     3-1 Raja C
MAS Fes       2-0 Marrakesh
Mohammedia    0-0 WAF
WAC           2-0 Massira

Round 22 [Apr 4]
Oujda         0-0 MAS Fes 
Marrakesh     2-2 Mohammedia  
WAF           1-0 FAR 
El Jadida     1-2 WAC
Massira       2-1 Beni Mellal 
FUS           0-0 Sale  
Khouribga     0-1 Meknes
Raja C        1-1 Agadir  

Round 23 
[Apr 11]
Meknes        0-1 Massira       
Beni Mellal   2-0 El Jadida   
WAC           1-1 WAF    
FAR           0-0 Marrakesh  
Mohammedia    1-1 Oujda
MAS Fes       0-1 FUS
Agadir        2-0 Khouribga     
[May 5]
Sale          1-3 Raja C   

Round 24 [Apr 18]
Oujda         2-0 FAR
Raja C        0-0 MAS Fes
Agadir        0-0 Meknes
Marrakesh     0-0 WAC
El Jadida     1-0 Massira
FUS           1-1 Mohammedia
Khouribga     1-0 Sale
WAF           0-0 Beni Mellal

Round 25 [May 9]
WAC           1-1 Oujda
Mohammedia    0-1 Raja C
Beni Mellal   1-2 Marrakesh
Massira       2-1 WAF
Sale          1-1 Agadir
Meknes        1-1 El Jadida
FAR           1-1 FUS
MAS Fes       0-0 Khouribga

Round 26 [May 23]
WAF           2-1 El Jadida
Marrakesh     7-1 Massira
Oujda         3-0 Beni Mellal
FUS           3-2 WAC
Raja C        2-0 FAR
Khouribga     2-0 Mohammedia
Agadir        1-1 MAS Fes
Sale          0-1 Meknes

Round 27 [May 30]
Meknes        1-1 WAF
El Jadida     1-1 Marrakesh
Massira       1-1 Oujda
MAS Fes       1-1 Sale
Beni Mellal   0-0 FUS
FAR           0-0 Khouribga
WAC           0-1 Raja C
Mohammedia    2-1 Agadir

Round 28 [Jun 20]
Marrakesh     4-1 WAF
MAS Fes       6-1 Meknes
Oujda         1-1 El Jadida
FUS           0-0 Massira
Raja C        3-1 Beni Mellal
Khouribga     2-0 WAC
Agadir        2-0 FAR
Sale          1-1 Mohammedia

Round 29 [Jun 29]
Raja C        2-1 Massira
Marrakesh     5-0 Meknes
WAC           2-2 Agadir
Beni Mellal   0-1 Khouribga
FAR           3-3 Sale
Mohammedia    2-0 MAS Fes
WAF           2-2 Oujda
El Jadida     0-0 FUS

Round 30 [Jul 4]
Oujda         1-4 Marrakesh
Raja C        3-2 El Jadida
Meknes        0-2 Mohammedia
Agadir        1-1 Beni Mellal
Khouribga     4-0 Massira
Sale          0-1 WAC
FUS           2-1 WAF
MAS Fes       2-1 FAR

Final Table:

 1.Raja Casablanca      30 17 11  2  42-14 62  Champions
 2.KAC Marrakesh        30 16 10  4  49-18 58
 3.OC Khouribga         30 15  9  6  40-22 54     
 4.WA Casablanca        30 14 10  6  46-27 52
 5.SA Salé              30  9 14  7  33-25 41    
 6.MAS Fès              30 10 11  9  29-28 41     
 7.FUS Rabat            30  9 14  7  26-25 41             
 8.FAR Rabat            30 11  7 12  23-27 40                
 9.JS Massira           30 10  6 14  26-43 36  [play in El Ayoun]
10.COD Meknès           30  7 13 10  23-35 34        
11.Hassania US Agadir   30  6 15  9  28-31 33
12.WA Fès               30  7 10 13  21-37 31
13.SC Chabab Mohammédia 30  5 15 10  20-26 30         
14.Raja Béni Mellal     30  6  9 15  19-28 27
---------------------------------------------
15.DH El Jadida         30  5 12 13  25-40 27  Relegated
16.MC Oujda             30  4 12 14  22-46 24  Relegated          

NB: Foot au Maroc reports different goal differences:

    OC Khouribga         38-21 instead of 40-22
    SA Salé              32-25 instead of 33-25
    MAS Fès              28-27 instead of 29-28
    FUS Rabat            25-24 instead of 26-25
    FAR Rabat            23-26 instead of 23-27
    JS Massira           22-42 instead of 26-43
    COD Meknès           22-34 instead of 23-35
    SC Chabab Mohammédia 19-25 instead of 20-26
    MC Oujda             20-44 instead of 22-46
   
    however, the total GD of that table is -4.


Author: RSSSF
(rsssf_request@topica.com)
Last updated: 4 Mar 2001

(C) Copyright RSSSF 1999/2001


  USO DE MEMORIA  
4,298,000 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0018
Controller Execution Time ( Home / Category )  0.1026
Total Execution Time  0.1045
  CADENA URL  
/marruecos1999
  GET DATOS  
$_GET['/marruecos1999']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (37)  
0.0018  SELECT type FROM routes WHERE alias = 'marruecos1999'
0.0040  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 = 1999 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=1 DESC LIMIT 1
0.0019  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=65 AND type_rel = 3
0.0023  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 3 AND rel.typeId = 65 AND rel.ln = 'es' AND rel.status=1 ORDER BY rel.creation_date desc,rel.cover_points DESC LIMIT 5
0.0028  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 (1295470,1280408,1237692,1233231,1227627) ORDER BY n.cover_points DESC, update_date DESC
0.0021  SELECT text_es as historical_text FROM leagues_text WHERE id=887
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 = 29209 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0021  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='1999' WHERE c.parentId=65 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-24 12:48:47' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0020  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=2 AND last_update > '2024-04-24 12:48:47' 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=4 AND last_update > '2024-04-24 12:48:47' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0022  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=3 AND last_update > '2024-04-24 12:48:47' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0027  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 = 1999 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=0 DESC LIMIT 1
0.0020  SELECT e.action, count(e.action) as total, e.player_id FROM events1999 e WHERE e.league_id IN (29209) 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.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 (29209) 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 events1999 e WHERE e.league_id IN (29209) AND (e.action IN (4,5) ) GROUP BY e.player_id ORDER BY total DESC, e.player_id ASC LIMIT 20
0.0021  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 (29209) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN () ORDER BY rp.in_squad = 1 DESC
0.0023  SELECT e.action, count(e.action) as total, e.player_id FROM events1999 e WHERE e.league_id IN (29209) AND (e.action IN (3,4) ) GROUP BY e.player_id ORDER BY total DESC, e.player_id ASC LIMIT 20
0.0022  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 (29209) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN () ORDER BY rp.in_squad = 1 DESC
0.0023  SELECT e.action, count(e.action) as total, e.player_id FROM events1999 e WHERE e.league_id IN (29209) AND (e.action IN (22) ) 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 (29209) 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 = 29209 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 = 29209 AND rp.events > 0 ORDER BY rp.events DESC,p.pod DESC LIMIT 20
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=29209 AND rel.round=30
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 = 29209 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 = 29209 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-25" AND c.`active`= 1 and c.comment_id is null and c.lang = 1 AND l.`id` = 29209 ORDER BY creation_date DESC LIMIT 0, 10
0.0025  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-25" AND c.`active`= 1 and comment_id is null and c.lang = 1 AND l.`id` = 29209
0.0020  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 `calendars1999` 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` = 29209 AND c.`round` = 30 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 `events1999` e INNER JOIN calendars1999 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 = 29209 ORDER BY total DESC LIMIT 40
0.0020  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 `events1999` e INNER JOIN calendars1999 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 = 29209 AND e.real_date > NOW() - INTERVAL 1 MONTH ORDER BY e.real_date DESC LIMIT 30
0.0022  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 `tables1999` 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 = 29209 AND t.round = 28 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0022  SELECT *,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables1999` 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 = 29209 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0022  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-24 00:00:00' AND c.`shedule` < '2024-04-28 23:59:59' AND l.id = 29209 ORDER BY c.shedule ASC, fcoef DESC LIMIT 5
0.0022  SELECT data1, data2 FROM services_tags WHERE categoryId=65
0.0022  SELECT l.year,l.group_code FROM leagues_besoccer l WHERE l.categoryId = 65 AND l.year = 1999 ORDER BY l.group_code ASC
0.0022  SELECT group_code, extraName from `leagues` WHERE categoryId=65 AND year=1999