Liga Emiratos 1998
1997/1998

Liga Emiratos 1998

Información Histórica
						
First Stage
===========

Final Table:

 1.Al-Wahda      18 10  4  4  32-19  34  [3 bonus points for second stage]
 2.Al-Sharjah    18  8  8  2  40-22  32  [2 bonus points for second stage]
 3.Al-Ain        18  8  5  5  24-17  29  [1 bonus point for second stage]
 4.Al-Wasl       18  5 12  1  23-17  27
 5.Al-Jazira     18  7  4  7  20-22  25
 6.Al-Nasr       18  5  8  5  22-17  23
 7.Al-Shabab     18  6  5  7  28-29  23
 8.Al-Ahli       18  7  2  9  25-27  23
---------------------------------------
 9.Kalba Union   18  3  8  7  12-29  17  Relegated
10.Bani Yas      18  2  2 14  13-40   8  Relegated

Round 1 [Sep 11-15]
Wasl      1-1 Sharjah
Bani Yas  1-3 Wahda
Ahli      0-0 Kalba U
Jazira    1-1 Nasr
Shabab    1-1 Ain

Round 2 [Sep 18-20]
Nasr      1-1 Wasl
Sharjah   5-1 Kalba U
Wahda     1-0 Ain
Bani Yas  2-1 Ahli
Shabab    2-0 Jazira

Round 3 [Sep 25,26]
Wasl      1-1 Shabab
Jazira    2-0 Wahda     [awarded]
Kalba U   1-4 Nasr
Ahli      1-4 Sharjah
Ain       3-0 Bani Yas  

Round 4 [Oct 2,3]
Bani Yas  1-2 Jazira
Nasr      2-2 Sharjah
Ain       2-0 Ahli
Shabab    0-0 Kalba U
Wahda     2-2 Wasl

Round 5 [Oct 9,10]
Ahli      2-1 Nasr
Sharjah   4-1 Shabab 
Kalba U   0-3 Wahda
Wasl      2-1 Bani Yas  
Jazira    2-1 Ain

Round 6 [Oct 16,17]
Shabab    1-0 Nasr
Ain       0-0 Wasl
Jazira    2-1 Ahli
Bani Yas  0-1 Kalba U
Wahda     2-2 Sharjah

Round 7 [Oct 20,21]
Ahli      3-4 Shabab 
Nasr      0-1 Wahda
Sharjah   3-0 Bani Yas  
Kalba U   0-0 Ain
Wasl      0-1 Jazira

Round 8 [Oct 23,24]
Wahda     2-1 Shabab 
Bani Yas  0-1 Nasr
Wasl      1-0 Ahli
Jazira    0-1 Kalba U
Ain       3-4 Sharjah

Round 9 [Oct 30,31]
Nasr      2-1 Ain
Shabab    0-1 Bani Yas  
Kalba U   1-1 Wasl
Ahli      1-2 Wahda
Sharjah   0-0 Jazira

Round 10 [Nov 6,7]
Kalba U   1-0 Ahli        [also reported 0-1]
Sharjah   1-1 Wasl
Nasr      2-0 Jazira
Shabab    0-1 Ain
Wahda     4-1 Bani Yas  

Round 11 [Nov 10,11]
Ahli      4-1 Bani Yas  
Kalba U   1-1 Sharjah
Ain       2-1 Wahda
Wasl      2-2 Nasr
Jazira    3-2 Shabab 

Round 12 [Nov 13-17]
Sharjah   0-1 Ahli
Bani Yas  1-2 Ain
Nasr      4-1 Kalba U
Wahda     3-1 Jazira
Shabab    1-1 Wasl

Round 13 [Nov 20,21]
Ahli      1-0 Ain
Jazira    3-2 Bani Yas
Sharjah   0-0 Nasr
Wasl      0-0 Wahda
Kalba U   0-1 Shabab

Round 14 [Nov 27,28]
Nasr      1-2 Ahli
Bani Yas  0-3 Wasl
Wahda     4-0 Kalba U
Shabab    3-6 Sharjah
Ain       1-0 Jazira

Round 15 [Dec 1,2]
Ahli      1-1 Jazira
Wasl      1-1 Ain
Kalba U   1-1 Bani Yas
Sharjah   1-2 Wahda
Nasr      1-1 Shabab

Round 16 [Dec 4,5]
Ain       4-2 Kalba U
Jazira    1-2 Wasl
Shabab    2-3 Ahli
Wahda     0-0 Nasr
Bani Yas  1-3 Sharjah

Round 17 [Dec 12]
Ahli      2-3 Wasl
Nasr      0-0 Bani Yas
Kalba U   0-0 Jazira
Shabab    3-2 Wahda
Sharjah   1-1 Ain

Round 18 [Dec 19]
Wahda     0-2 Ahli
Wasl      1-1 Kalba U
Bani Yas  0-4 Shabab
Ain       1-0 Nasr
Jazira    1-2 Sharjah

Final Table:

 1.Al-Wahda      18 10  4  4  32-19  34  [3 bonus points for second stage]
 2.Al-Sharjah    18  8  8  2  40-22  32  [2 bonus points for second stage]
 3.Al-Ain        18  8  5  5  24-17  29  [1 bonus point for second stage]
 4.Al-Wasl       18  5 12  1  23-17  27
 5.Al-Jazira     18  7  4  7  20-22  25
 6.Al-Nasr       18  5  8  5  22-17  23
 7.Al-Shabab     18  6  5  7  28-29  23
 8.Al-Ahli       18  7  2  9  25-27  23
---------------------------------------
 9.Kalba Union   18  3  8  7  12-29  17  Relegated
10.Bani Yas      18  2  2 14  13-40   8  Relegated


Second Stage
============

Table [bonus points between brackets]:

 1.Al-Ain        14  9  4  1  25-12  32  [1]   Champions
 2.Al-Sharjah    14  8  4  2  29-15  30  [2]
 3.Al-Wasl       14  6  5  3  16-12  23
 4.Al-Ahli       14  5  3  6  21-22  18
 5.Al-Wahda      14  3  6  5  14-18  18  [3]
 6.Al-Nasr       14  4  5  5  15-14  17
 7.Al-Shabab     14  3  3  8  14-25  12
 8.Al-Jazira     14  2  2 10  15-31   8

Round 1 [Dec 25-26]
Shabab    2-3 Ain
Jazira    0-1 Ahli
Wasl      1-3 Sharjah
Wahda     1-1 Nasr

Round 2 [Jan 4,5]
Nasr      0-1 Wasl
Wahda     2-1 Shabab   
Sharjah   5-1 Jazira
Ahli      0-1 Ain

Round 3 [Jan 8,9]
Shabab    2-0 Ahli
Ain       1-1 Sharjah
Jazira    0-0 Nasr
Wasl      2-0 Wahda

Round 4 [Jan 15,16]
Wahda     3-1 Jazira
Wasl      1-1 Shabab   
Nasr      0-2 Ain
Sharjah   2-1 Ahli

Round 5 [Jan 19,20]
Shabab    1-0 Sharjah
Ain       4-1 Wahda
Ahli      0-2 Nasr
Jazira    4-1 Wasl

Round 6 [Feb 5,6]
Jazira    3-0 Shabab
Wahda     2-2 Ahli
Nasr      1-1 Sharjah
Wasl      1-1 Ain        [Feb 23]

Round 7 [Feb 12,13]
Shabab    1-1 Nasr
Sharjah   1-0 Wahda
Ain       3-1 Jazira
Ahli      0-2 Wasl       [Mar 9]

Round 8 [Feb 19,20]
Ain       0-0 Shabab
Ahli      3-0 Jazira
Nasr      2-0 Wahda
Sharjah   1-1 Wasl       [Mar 23]

Round 9 [Feb 26,27]
Shabab    0-2 Wahda
Wasl      1-0 Nasr
Ain       2-3 Ahli
Jazira    1-5 Sharjah

Round 10 [Mar 5,6]
Ahli      4-1 Shabab
Sharjah   0-1 Ain
Nasr      1-0 Jazira
Wahda     0-0 Wasl

Round 11 [Mar 12,13]
Shabab    0-2 Wasl
Jazira    1-1 Wahda
Ahli      2-4 Sharjah
Ain       1-0 Nasr

Round 12 [Mar 19,20]
Sharjah   3-2 Shabab
Nasr      2-3 Ahli
Wahda     0-0 Ain
Wasl      2-0 Jazira

Round 13 [Mar 28]
Shabab    2-1 Jazira
Ain       2-1 Wasl
Ahli      2-2 Wahda
Sharjah   2-2 Nasr

Round 14 [Apr 3]
Jazira    2-4 Ain
Wahda     0-1 Sharjah
Wasl      0-0 Ahli
Nasr      3-1 Shabab

Table [bonus points between brackets]:

 1.Al-Ain        14  9  4  1  25-12  32  [1]   Champions
 2.Al-Sharjah    14  8  4  2  29-15  30  [2]
 3.Al-Wasl       14  6  5  3  16-12  23
 4.Al-Ahli       14  5  3  6  21-22  18
 5.Al-Wahda      14  3  6  5  14-18  18  [3]
 6.Al-Nasr       14  4  5  5  15-14  17
 7.Al-Shabab     14  3  3  8  14-25  12
 8.Al-Jazira     14  2  2 10  15-31   8

Promoted: Al-Khaleej, Bani Yas (remain in first division), Al-Sha'ab,
          Ras Al-Khaima.
Relegated: Kalba Union.


United Arab Emirates Cup 1998

Final
Sharjah   3-2 Al-Wasl     [asdet]
 

Second Level

First Stage

Final Table:

 1.Al-Sha'ab      14  8  6  0  24- 6  30
 2.Al-Khaleej     14  5  7  2  19-12  22
 3.Ahli Fujeira   14  5  3  6  16-14  18
 4.Ras Al-Khaima  14  4  5  5  12-15  17
 5.Ajman          14  3  8  3  15-19  17
 6.Emirates       14  3  7  4  11-14  16
----------------------------------------
 7.Al-Oruba       14  4  4  6  13-18  16
 8.Al-Rams        14  1  6  7  11-23   9 

First six join Kalba Union, Bani Yas (bottom two first level) and
Dibba Al-Hessen (winners third level) in Promotion/Relegation League.
Bottom two join bottom 8 of third level in their Second Stage League.

Third Level

First Stage

Final Table:

 1.Dibba Al-Hessen 16 14  0  2  42-16  42
-----------------------------------------
 2.Hatta           16 13  1  2  53-11  40
 3.Dubai           16 10  1  5  37-21  31
 4.Hemreya         15  7  3  5  25-28  24
 5.Massafi         16  7  1  8  35-32  22
 6.Al-Arabi        16  5  5  6  23-30  20
 7.Thaid           16  3  3 10  16-39  12
 8.Dibba           15  2  2 12  16-41   8
 9.Hamra Island    16  1  2 13  16-41   5

Dibba al-Hessen join bottom 2 first level and top 6 of second level
in Promotion/Relegation league to first level 1998/99.


Promotion/Relegation League

Final Table:

 1.Bani Yas        16 10  5  1  31-13  35
 2.Al-Khaleej      16 10  3  3  32-17  33
 3.Al-Sha'ab       16  9  5  2  34-17  32
 4.Ras Al-Khaima   16  9  4  3  35-26  31 
-----------------------------------------
 5.Kalba Union     16  9  2  5  33-20  29
 6.Ahli Fujeira    16  4  4  8  18-28  16
 7.Emirates        16  2  5  9  13-28  11
 8.Dibba Al-Hessen 16  1  3 12  14-45   6
 9.Ajman           16  0  5 11  13-31   5


Third Level Second Stage

Final Table:

 1.Hatta        18 14  2  2  41-10  44
 2.Al-Rams      18 14  1  3  35-16  43
 3.Al-Oruba     18 11  3  4  31-14  36
 4.Dubai        18 10  5  3  33-15  35
 5.Al-Arabi     18  7  4  7  28-30  25
 6.Massafi      18  7  3  8  38-35  24
 7.Hemreya      18  3  4 11   9-23  13
 8.Thaid        18  3  4 11  14-33  13
 9.Hamra Island 18  3  3 12  20-50  12
10.Dibba        18  2  3 13   8-30   9

Author:
Mohammed Qayed
(mhqayed@emirates.net.ae)

Last updated: 30 Jul 1999

(C) Copyright Mohammed Qayed and RSSSF 1999
						

Uso de cookies: Utilizamos "cookies" propias y de terceros para mejorar nuestros servicios, elaborar información estadística, analizar sus hábitos de navegación e inferir grupos de interés. Esto nos permite personalizar el contenido que ofrecemos y mostrarle publicidad relacionada con sus preferencias. Adicionalmente, compartimos los análisis de navegación y los grupos de interés inferidos con terceros. Si continúa navegando acepta su uso. Más información y cambio de configuración. Aceptar

  USO DE MEMORIA  
4,301,640 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0019
Controller Execution Time ( Home / Category )  0.4987
Total Execution Time  0.5006
  CADENA URL  
/uae1998
  GET DATOS  
$_GET['/uae1998']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (38)  
0.0105  SELECT type FROM routes WHERE alias = 'uae1998'
0.0212  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'uae' 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.0105  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=62 AND type_rel = 3
0.0109  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 3 AND rel.typeId = 62 AND rel.ln = 'es' AND rel.status=1 ORDER BY rel.creation_date desc,rel.cover_points DESC LIMIT 5
0.0107  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 (1307668,1291095,1276895,1276715,1275883) ORDER BY n.cover_points DESC, update_date DESC
0.0106  SELECT text_es as historical_text FROM leagues_text WHERE id=1885
0.0106  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 = 30148 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0107  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=62 GROUP BY c.id ORDER BY c.order_id ASC
0.0106  SELECT type,rule FROM rules WHERE categoryId = 62 ORDER BY type = 'tables_draw' DESC,type != 'extra' DESC, `order` ASC
0.0105  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-03-29 06:59:05' 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=2 AND last_update > '2024-03-29 06:59:05' 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-03-29 06:59:05' 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-03-29 06:59:05' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0111  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'uae' 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.0106  SELECT e.action, count(e.action) as total, e.player_id FROM events1998 e WHERE e.league_id IN (30148) 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.0106  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 (30148) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN () ORDER BY rp.in_squad = 1 DESC
0.0105  SELECT e.action, count(e.action) as total, e.player_id FROM events1998 e WHERE e.league_id IN (30148) AND (e.action IN (4,5) ) GROUP BY e.player_id ORDER BY total DESC, e.player_id ASC LIMIT 20
0.0108  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 (30148) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN () ORDER BY rp.in_squad = 1 DESC
0.0107  SELECT e.action, count(e.action) as total, e.player_id FROM events1998 e WHERE e.league_id IN (30148) AND (e.action IN (3,4) ) GROUP BY e.player_id ORDER BY total DESC, e.player_id ASC LIMIT 20
0.0109  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 (30148) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN () ORDER BY rp.in_squad = 1 DESC
0.0113  SELECT e.action, count(e.action) as total, e.player_id FROM events1998 e WHERE e.league_id IN (30148) AND (e.action IN (22) ) GROUP BY e.player_id ORDER BY total DESC, e.player_id ASC LIMIT 20
0.0111  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 (30148) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN () ORDER BY rp.in_squad = 1 DESC
0.0110  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 = 30148 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 = 30148 AND rp.events > 0 ORDER BY rp.events DESC,p.pod DESC LIMIT 20
0.0119  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=30148 AND rel.round=18
0.0111  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 = 30148 AND esl.points > 0 ORDER BY esl.points DESC LIMIT 3
0.0109  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 = 30148 AND esl.points > 0
0.0108  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-02-28" AND c.`active`= 1 and c.comment_id is null and c.lang = 1 AND l.`id` = 30148 ORDER BY creation_date DESC LIMIT 0, 10
0.0118  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-02-28" AND c.`active`= 1 and comment_id is null and c.lang = 1 AND l.`id` = 30148
0.0109  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` = 30148 AND c.`round` = 18 ORDER BY shedule ASC LIMIT 200
0.0105  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 = 18 AND e.real_date IS NOT NULL AND e.league_id = 30148 ORDER BY total DESC LIMIT 40
0.0109  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 = 30148 AND e.real_date > NOW() - INTERVAL 1 MONTH ORDER BY e.real_date DESC LIMIT 30
0.0108  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 = 30148 AND t.round = 16 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0108  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 = 30148 AND t.round = 18 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0108  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-03-29 00:00:00' AND c.`shedule` < '2024-04-02 23:59:59' AND l.id = 30148 ORDER BY c.shedule ASC, fcoef DESC LIMIT 5
0.0108  SELECT data1, data2 FROM services_tags WHERE categoryId=62
0.0108  SELECT l.year,l.group_code FROM leagues_besoccer l WHERE l.categoryId = 62 AND l.year = 1998 ORDER BY l.group_code ASC
0.0108  SELECT group_code, extraName from `leagues` WHERE categoryId=62 AND year=1998