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 19 10  1  51-13 67  Champions
 2.KAC Marrakesh        30 16  5  9  36-25 53
 3.WA Casablanca        30 14  9  7  33-18 51 
 4.OC Khouribga         30 12 11  7  29-26 47
 5.FAR Rabat            30 11 10  9  27-24 43
 6.SA Salé              30  9 13  8  24-28 40
 7.MAS Fes              30  9 12  9  26-24 39
 8.Hassania US Agadir   30 10  7 13  36-42 37
 9.SC Chabab Mohammedia 30  9  9 12  33-40 36
10.MC Oujda             30  9  9 12  31-41 36
11.WA Fes               30  8 11 11  15-22 35
12.JS Massira           30  9  8 13  26-36 35  [play in El Ayoun]
13.COD Meknes           30  8 10 12  26-30 34
14.DH El Jadida         30  8 10 12  17-23 34
---------------------------------------------
15.Nehdat Settat        30  7 12 11  19-20 33  Relegated
16.Ittihad Tangier      30  5  8 17  19-36 23  Relegated

Round 1 [Aug 31]
Mohammedia    3-0 Meknes
Agadir        0-3 Marrakesh
Oujda         1-2 Raja
FAR           1-1 MAS Fes
El Jadida     1-0 Tangier
WAF           0-0 Sale
WAC           4-1 Khouribga   
Settat        0-1 Massira

Round 2 [Sep 7]
MAS Fes       2-0 Agadir
Sale          1-1 El Jadida
Massira       1-0 WAC
Khouribga     1-0 Mohammedia
Marrakesh     1-0 WAF      
Tangier       1-1 Oujda
Meknes        2-1 FAR 
Raja          0-0 Settat    

Round 3 
WAF           0-1 MAS Fes
El Jadida     0-1 Marrakesh
Mohammedia    1-1 Massira
Raja          1-1 Tangier
FAR           0-1 Khouribga
Settat        0-1 WAC
Agadir        1-3 Meknes
Oujda         1-2 Sale

Round 4 [Sep 21]
Meknes        2-0 WAF      
MAS Fes       0-1 El Jadida
Marrakesh     2-1 Oujda
Tangier       0-1 Settat
WAC           1-1 Mohammedia
Khouribga     1-0 Agadir
Massira       0-0 FAR         [played later]
Sale          1-5 Raja        [played later] [0-5?]

Round 5 [Sep 28]
FAR           2-0 WAC
Tangier       0-1 Sale
Raja          2-2 Marrakesh
Oujda         2-2 MAS Fes
El Jadida     1-0 Meknes
WAF           1-1 Khouribga  
Agadir        5-3 Massira
Settat        1-1 Mohammedia

Round 6 [Oct 5]
Sale          1-0 Settat
WAC           0-1 Agadir
Marrakesh     1-0 Tangier
MAS Fes       0-1 Raja
Mohammedia    1-3 FAR
Khouribga     0-1 El Jadida
Meknes        4-1 Oujda
Massira       2-0 WAF      

Round 7 [Oct 12]
Tangier       0-2 MAS Fes
Sale          2-0 Marrakesh
Agadir        3-3 Mohammedia
WAF           1-0 WAC
El Jadida     1-1 Massira
Settat        1-1 FAR         [played later]
Oujda         2-3 Khouribga   [played later]
Raja          0-0 Meknes      [played later]

Round 8 [Oct 19]
Marrakesh     1-0 Settat
FAR           2-1 Agadir
Mohammedia    1-2 WAF      
WAC           1-0 El Jadida
Massira       0-0 Oujda
Khouribga     0-0 Raja
Meknes        4-1 Tangier
MAS Fes       0-0 Sale

Round 9 [Oct 26]
Marrakesh     1-0 MAS Fes
Settat        3-0 Agadir
El Jadida     1-0 Mohammedia
Oujda         1-2 WAC
Tangier       3-1 Khouribga
Sale          1-1 Meknes  
WAF           0-0 FAR         [played later]
Raja          2-1 Massira     [played later] [2-0?]

Round 10 [Nov 2]
Agadir        2-0 WAF      
FAR           2-1 El Jadida
Mohammedia    1-1 Oujda
WAC           0-0 Raja
Massira       1-1 Tangier
Khouribga     2-1 Sale
Meknes        0-0 Marrakesh
MAS Fes       0-0 Settat

Round 11 [Nov 9] 
Tangier       1-1 WAC      
Marrakesh     0-1 Khouribga  
El Jadida     1-0 Agadir
Oujda         0-0 FAR
Sale          1-0 Massira 
MAS Fes       1-0 Meknes
Settat        0-1 WAF      
Raja          6-0 Mohammedia  [played later]

Round 12 [Nov 16]
Agadir        1-3 Oujda
WAF           1-1 El Jadida
Mohammedia    1-0 Tangier
WAC           1-1 Sale
Massira       0-2 Marrakesh
Meknes        0-1 Settat
Khouribga     1-1 MAS Fes
FAR           0-0 Raja        [played later (Jan)]

Round 13 [Nov 23]
Meknes        1-0 Khouribga
MAS Fes       2-1 Massira
Marrakesh     1-0 WAC
Raja          1-0 Agadir
Sale          2-1 Mohammedia
Oujda         0-0 WAF      
Settat        0-0 El Jadida
Tangier       2-1 FAR         [played later (Feb)]

Round 14 [Nov 30]
Sale          1-0 FAR
Agadir        2-0 Tangier
Mohammedia    0-1 Marrakesh
Settat        0-0 Khouribga
El Jadida     0-0 Oujda
Massira       3-1 Meknes   
WAC           1-0 MAS Fes
WAF           0-1 Raja        [played later (Feb)]

Round 15 [Dec 28]
Khouribga     2-1 Massira
Meknes        0-4 WAC
MAS Fes       1-2 Mohammedia
Sale          0-0 Agadir
Tangier       0-0 WAF      
Oujda         2-0 Settat
Raja          1-2 El Jadida
Marrakesh     0-1 FAR         [played later (Mar)]

Round 16 [Jan 4]
Meknes        0-1 Mohammedia
MAS Fes       1-2 FAR
Khouribga     0-0 WAC
Sale          0-1 WAF      
Massira       0-1 Settat
Tangier       0-1 El Jadida
Raja          4-0 Oujda       [3-0?]
Marrakesh     3-0 Agadir

Round 17 [Jan 11]
WAF           0-1 Marrakesh
FAR           0-0 Meknes
Agadir        2-1 MAS Fes
WAC           3-0 Massira
Oujda         1-0 Tangier
El Jadida     0-0 Sale
Mohammedia    0-1 Khouribga
Settat        0-2 Raja

Round 18 [Jan 25]
Sale          1-2 Oujda
Marrakesh     3-1 El Jadida
MAS Fes       0-0 WAF      
Meknes        0-0 Agadir
Massira       1-3 Mohammedia
WAC           1-0 Settat
Tangier       1-1 Raja        [played later]
Khouribga     1-1 FAR         [played later]

Round 19 [Feb 8]
Mohammedia    1-2 WAC
FAR           1-0 Massira
Agadir        2-0 Khouribga
WAF           2-1 Meknes
El Jadida     0-0 MAS Fes
Oujda         2-1 Marrakesh
Raja          4-0 Sale
Settat        0-1 Tangier

Round 20 [Feb 15]
Mohammedia    0-0 Settat
WAC           2-1 FAR
Massira       2-1 Agadir
Khouribga     1-0 WAF      
Meknes        0-0 El Jadida
MAS Fes       0-0 Oujda
Marrakesh     1-3 Raja
Sale          0-0 Tangier

Round 21 [Feb 21]
Tangier       2-0 Marrakesh
Agadir        1-1 WAC
FAR           0-1 Mohammedia
Oujda         2-0 Meknes
El Jadida     0-1 Khouribga
WAF           1-1 Massira
Settat        0-1 Sale
Raja          1-1 MAS Fes

Round 22 [Mar 6-8]
Mohammedia    1-2 Agadir
FAR           2-2 Settat
MAS Fes       2-1 Tangier
Khouribga     3-0 Oujda
Marrakesh     2-1 Sale
Meknes        0-1 Raja
Massira       0-0 El Jadida
WAC           1-0 WAF

Round 23 [Mar 13-15]
Settat        0-1 Marrakesh  
Agadir        3-0 FAR   
WAF           0-0 Mohammedia 
El Jadida     1-1 WAC
Oujda         0-1 Massira  
Tangier       2-1 Meknes   
Sale          1-1 MAS Fes   
Raja          2-1 Khouribga   [played later]

Round 24 [Mar 20-22]
MAS Fes       2-0 Marrakesh 
Agadir        1-1 Settat      [played later] 
Mohammedia    1-0 El Jadida  
WAC           0-0 Oujda   
Khouribga     1-0 Tangier  
Meknes        2-1 Sale    
FAR           2-0 WAF    
Massira       0-1 Raja        [played later]

Round 25 [Mar 27-29]
Raja          1-1 WAC   
Settat        2-0 MAS Fes
Sale          1-1 Khouribga
WAF           0-0 Agadir    
Oujda         1-4 Mohammedia
Tangier       0-0 Massira
Marrakesh     2-2 Meknes
El Jadida     0-1 FAR

Round 26
Agadir        3-1 El Jadida 
WAC           3-0 Tangier 
WAF           1-1 Settat   
Meknes        0-0 MAS Fes  
FAR           0-1 Oujda  
Khouribga     1-1 Marrakesh
Mohammedia    0-4 Raja   
Massira       1-0 Sale   

Round 27 [Apr 19]
Oujda         3-1 Agadir   
Sale          1-0 WAC  
Raja          2-0 FAR
El Jadida     0-1 WAF
Tangier       1-2 Mohammedia
Settat        0-0 Meknes
MAS Fes       1-1 Khouribga
Marrakesh     3-0 Massira

Round 28 [May 3]
WAF           2-1 Oujda
FAR           2-0 Tangier
Mohammedia    0-0 Sale
Massira       2-1 MAS Fes
Khouribga     0-0 Meknes
El Jadida     0-1 Settat
Agadir        0-1 Raja
WAC           1-0 Marrakesh

Round 29 [May 13]
Oujda         2-1 El Jadida    
Raja          1-0 WAF
Tangier       1-2 Agadir
Sale          0-0 FAR
Marrakesh     2-2 Mohammedia
MAS Fes       1-0 WAC
Meknes        2-0 Massira
Khouribga     1-1 Settat

Round 30 [May 17]
Settat        3-0 Oujda
El Jadida     0-1 Raja
WAF           1-0 Tangier
Agadir        2-2 Sale
FAR           1-0 Marrakesh
Mohammedia    1-2 MAS Fes
WAC           1-0 Meknes
Massira       2-1 Khouribga

Final Table:

 1.Raja Casablanca      30 19 10  1  51-13 67  Champions
 2.KAC Marrakesh        30 16  5  9  36-25 53
 3.WA Casablanca        30 14  9  7  33-18 51 
 4.OC Khouribga         30 12 11  7  29-26 47
 5.FAR Rabat            30 11 10  9  27-24 43
 6.SA Salé              30  9 13  8  24-28 40
 7.MAS Fes              30  9 12  9  26-24 39
 8.Hassania US Agadir   30 10  7 13  36-42 37
 9.SC Chabab Mohammedia 30  9  9 12  33-40 36
10.MC Oujda             30  9  9 12  31-41 36
11.WA Fes               30  8 11 11  15-22 35
12.JS Massira           30  9  8 13  26-36 35  [play in El Ayoun]
13.COD Meknes           30  8 10 12  26-30 34
14.DH El Jadida         30  8 10 12  17-23 34
---------------------------------------------
15.Nehdat Settat        30  7 12 11  19-20 33  Relegated
16.Ittihad Tangier      30  5  8 17  19-36 23  Relegated

Promoted: FUS Rabat and Raja Beni Mellal.


                           
Author: RSSSF
Last updated: 3 Oct 2004

(C) Copyright RSSSF 1999/2004


  USO DE MEMORIA  
4,296,360 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0018
Controller Execution Time ( Home / Category )  0.5730
Total Execution Time  0.5749
  CADENA URL  
/marruecos1998
  GET DATOS  
$_GET['/marruecos1998']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (37)  
0.0125  SELECT type FROM routes WHERE alias = 'marruecos1998'
0.0252  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 = 1998 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=65 AND type_rel = 3
0.0129  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.0127  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.0126  SELECT text_es as historical_text FROM leagues_text WHERE id=885
0.0125  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 = 29207 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0126  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='1998' WHERE c.parentId=65 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-26 17:10:50' 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-26 17:10:50' 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-26 17:10:50' 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-26 17:10:50' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0130  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 = 1998 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=0 DESC LIMIT 1
0.0126  SELECT e.action, count(e.action) as total, e.player_id FROM events1998 e WHERE e.league_id IN (29207) 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 (29207) 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 events1998 e WHERE e.league_id IN (29207) AND (e.action IN (4,5) ) 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 (29207) 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 events1998 e WHERE e.league_id IN (29207) AND (e.action IN (3,4) ) 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 (29207) 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 events1998 e WHERE e.league_id IN (29207) AND (e.action IN (22) ) 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 (29207) 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 = 29207 AND rp.lineup > 0 ORDER BY rp.lineup DESC,p.pod DESC LIMIT 20
0.0127  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 = 29207 AND rp.events > 0 ORDER BY rp.events DESC,p.pod DESC LIMIT 20
0.0143  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=29207 AND rel.round=30
0.0141  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 = 29207 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 = 29207 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-27" AND c.`active`= 1 and c.comment_id is null and c.lang = 1 AND l.`id` = 29207 ORDER BY creation_date DESC LIMIT 0, 10
0.0131  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-27" AND c.`active`= 1 and comment_id is null and c.lang = 1 AND l.`id` = 29207
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 `calendars1998` 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` = 29207 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 `events1998` e INNER JOIN calendars1998 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 = 29207 ORDER BY total DESC LIMIT 40
0.0133  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 `events1998` e INNER JOIN calendars1998 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 = 29207 AND e.real_date > NOW() - INTERVAL 1 MONTH ORDER BY e.real_date DESC LIMIT 30
0.0141  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 `tables1998` 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 = 29207 AND t.round = 28 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0141  SELECT *,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables1998` 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 = 29207 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0141  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-26 00:00:00' AND c.`shedule` < '2024-04-30 23:59:59' AND l.id = 29207 ORDER BY c.shedule ASC, fcoef DESC LIMIT 5
0.0141  SELECT data1, data2 FROM services_tags WHERE categoryId=65
0.0141  SELECT l.year,l.group_code FROM leagues_besoccer l WHERE l.categoryId = 65 AND l.year = 1998 ORDER BY l.group_code ASC
0.0141  SELECT group_code, extraName from `leagues` WHERE categoryId=65 AND year=1998