4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
« Temporada Anterior
Temporada 1997
Temporada Siguiente »
Publicidad 600x120.gif
Liga 1 Indonesia 1997
1996/1997

Liga 1 Indonesia 1997

Información Histórica 
						
Premier League

[Top-4 of each division qualify for 'Final 12' Playoff.]

West Division:
 
Final Table:
 1.Persebaya            20 13  4  3  62-18   43  [Surabaya]
 2.Bandung Raya         20 11  2  7  30-17   35  [Bandung]
 3.Arema                20 10  5  5  26-20   35  [Malang]
 4.Persiraja            20 10  2  8  23-16   32  [Banda Aceh]
-----------------------------------------------
 5.Persita              20 10  2  8  24-22   32  [Tangerang]
 6.PSBL                 20  8  7  5  19-16   31  [Bandar Lampung]
 7.Semen Padang         20  8  6  6  20-17   30  [Padang]
 8.Persikab             20  6  7  7  17-19   25  [Bandung]
 9.Medan Jaya           20  6  7  7  24-25   25  [Medan]
10.Persija Pusat        20  4  3 13  23-31   12  [Jakarta]  [*]  
-----------------------------------------------
11.Persijatim           20  0  3 17   8-75    3  [Jakarta]      Relegated

[*] Persija deducted 3 points after w/o against Persikab

Topscorer: Jacksen F. Tiago (Persebaya) 19 goals

Central Division:
 
Final Table:
 1.Persib               20  8 10  2  22-14   34  [Bandung]
 2.Pelita Jaya Mastrans 20  9  6  5  36-21   33  [Jakarta]
 3.Mitra                20  8  8  4  25-11   32  [Surabaya]
 4.Barito Putra         20  8  5  7  23-24   29  [Banjarmasin]
-----------------------------------------------
 5.PSP                  20  8  5  7  22-25   29  [Padang]
 6.PSIS                 20  7  5  8  21-20   26  [Semarang]
 7.Arseto               20  7  5  8  15-20   26  [Solo]
 8.PSB                  20  6  7  7  20-20   22  [Bogor]  [*]
 8.PSDS Deli Serdang    20  5  7  8  13-25   22  [Lubuk Pakam]
10.PSMS                 20  3 10  7  10-19   19  [Medan]
-----------------------------------------------
11.Mataram Indocement   20  4  6 10  13-21   18  [Yogyakarta]   Relegated

[*] PSB deducted 3 points after abandoning match vs Barito

Topscorers: Dejan Gluscevic (Pelita Mastrans), 
            Kurniawan DY (Pelita Mastrans) 10 goals

East Division:
 
Final Table:
 1.PSM                  20 14  1  5  48-21   43  [Ujung Pandang]
 2.Gelora Dewata        20 12  2  6  37-27   38  [Denpasar]
 3.Persma               20 11  3  6  33-21   36  [Manado]
 4.Persipura            20 11  2  7  31-22   35  [Jayapura]
-----------------------------------------------
 5.Putra Samarinda      20 10  2  8  28-28   32  [Samarinda]
 6.Petrokimia Putra     20 10  2  8  21-26   32  [Gresik]
 7.Pupuk Kaltim (PKT)   20 10  0 10  39-22   30  [Bontang]
 8.Persema              20  7  1 12  30-37   22  [Malang]
 9.Persiba              20  6  3 11  25-35   21  [Balikpapan]
-----------------------------------------------
10.Assyabaab SGS        20  5  2 13  26-43   17  [Sidoardjo]    Relegated
11.Persedikab           20  3  4 13  15-51   13  [Kediri]       Relegated

Topscorer: Izack Fatary (PSM) 14 goals


Final 12
========

[One tournament in Jakarta.]

Round 1 [Jul 13]
Grup A
Persebaya    4-1 Persiraja
Mitra S      4-0 Gelora D
Grup B
Persib B     1-0 Barito P
Bandung Raya 3-0 Persma M
Grup C
PSM Ujungp.  2-1 Persipura J
Arema M      1-2 Pelita M     

Round 2 [Jul 15]
Grup A
Persiraja    2-1 Gelora D
Persebaya    6-1 Mitra S
Grup B
Persma M     2-2 Barito P
Bandung Raya 0-0 Persib B
Grup C
Pelita M     2-1 Persipura J
PSM Ujungp.  2-1 Arema M

Round 3 [Jul 17]
Grup A
Persiraja    1-4 Mitra S
Gelora D     2-4 Persebaya  
Grup B
Barito P     0-2 Bandung Raya
Persib B     0-0 Persma M
Grup C
Persipura J  1-2 Arema M
Pelita M     0-1 PSM Ujungp.

Tables:

Grup A

 1.Persebaya Surabaya  3  3  0  0 14- 4  9
 2.Mitra Surabaya      3  2  0  1  9- 7  6
 3.Persiraja           3  1  0  2  4- 9  3
 4.Gelora Dewata       3  0  0  3  3-10  0

Grup B:

 1.Bandung Raya        3  2  1  0  5- 0  7
 2.Persib Bandung      3  1  2  0  1- 0  5
 3.Persma Manado       3  0  2  1  2- 5  2
 4.Barito Putra        3  0  1  2  2- 5  1

Grup C:

 1.PSM Ujungpandang    3  3  0  0  5- 2  9
 2.Pelita Mastrans     3  2  0  1  4- 3  6
 3.Arema Malang        3  1  0  2  4- 5  3
 4.Persipura Jayapura  3  0  0  3  3- 6  0

Group winners plus best 2nd placed team (Mitra) qualify
for semifinals.

Semifinals [Jul 25]

Persebaya Surabaya  3-2 PSM Ujungpandang
Bandung Raya        1-0 Mitra Surabaya   [abandoned at 1-0 in 63' and
                                          finished on Jul 26]

Final [Jul 28; Utama Senayan, Jakarta]
Persebaya Surabaya  3-1 Bandung Raya
 [58' Aji Santoso (pen), 60' Jacksen F. Tiago, 86' Reinald Pieters; 84' Budiman]
Ref: Kim Dae Hyung                                 
Persebaya: Agus Murod, Aji Santoso (C), Anang Maruf/Hartono (80'), Sugiantoro,
           Justinho Pinhiero, Khairil Anwar, Carlos de Mello, 
           Yusuf Ekodono (Y)(40')/Jatmiko (43'), Uston Nawawi/Mursyid Effendi (87'),
           Jaksen F. Tiago (Y) (64'), Reinald Pieters.
Bandung Raya: Hermansyah, Surya Lesmana/Rehmalem P. (63') (Y) (72'), 
              Nuralim (Y) (29'), Herry Kiswanto/Hendriawan (78'), Olinga Atangana,
              Dahiru Ibarahim, M. Ramdan, Alexander Saununu, Budiman,
              Deftendi/Stephen Weah (51'), Peri Sandria (c).

Topscorer: Jacksen F. Tiago (Brazil, Persebaya)  26 goals (25 matches)
Best Player: Nuralim (Bandung Raya)

Persebaya Coach: Rusdy Bahalwan
Bandung Raya Coach: Albert Fafie

Note: Jacksen F. Tiago lost the previous two Championship finals,
      in 1995 with Petrokimia (vs Persib Bandung) and in 1996 with
      PSM Ujung Pandang (vs Bandung Raya).


Indonesia First Division (Second Level) 1996/1997

First Stage

Grup Barat
PSSB Bireun                     --qualified
PSPS Pekanbaru                  --qualified
PS Bengkulu Bengkulu          
Persibri Batanghari
 
Grup Tengah I
Persitara Jakarta Utara         --qualified
PSIM Yogyakarta                 --qualified
Persis Solo
Serang Jaya Warna Agung Serang
 
Grup Tengah II
Persikota Tangerang             --qualified
Perseden Denpasar               --qualified
Persijap Jepara
Persegres Gresik
 
Grup Tengah III
Persikabo Bogor                 --qualified
PSS Sleman                      --qualified
PSJS Jakarta Selatan
Persewangi Banyuwangi
 
Grup Timur
Persiter Ternate                --qualified
Persidafon Dafonsoro            --qualified
Persiss Sorong

Second Stage (10 Besar/Big 10)

Grup A [Stadion Mandala Krida, Yogyakarta]

[Jul 7]
PSIM         1-0 PSS
  [Bambang Sumantri 32pen]
Persiter     4-3 Persikota
  [Syafrudin Rasyid 28, Lukman Muhammad 29, 74, Ikram Selang 66;
   Tiastono Taufik 24pen, 48pen, Nova Zaenal 77]
 
[Jul 8]
PSIM         3-0 Persiter
  [Bambang Sumantri 36pen, Wahyudianto 49, 81]
PSS          2-0 PSSB
  [Muslih 57, Santos Budi Santosa 70]
 
[Jul 10]
Persikota    5-2 PSSB
  [Francis Yonga 19, 87, Ali Shaha 22, 60, Nova Zaenal 83; Iskandar 61, 78]
PSS          2-0 Persiter
  [Muslih 60, M.Eksan 76]
 
[Jul 12]
Persikota    3-0 PSS
  [Nova Zaenal 17, 84, 89]
PSIM         3-0 PSSB
  [Rofik Ismanto 29, 83, Wahyudianto 49]
 
[Jul 14]
Persikota    0-0 PSIM
Persiter     3-0 PSSB

Table:

 1.PSIM                4  3  1  0  7- 0 10                           
 2.Persikota           4  2  1  1 11- 6  7                     
 3.PSS                 4  2  0  2  4- 4  6 
 4.Persiter            4  2  0  2  7- 8  6 
 5.PSSB                4  0  0  4  2-13  0
 
Grup B [Stadion Ngurah Rai, Denpasar]

[Jul 8]
Perseden     1-0 Persitara
  [Komang Mariawan 49]
Persikabo    1-1 Persidafon
  [D Mahonem 44; Charles Yom 72]
 
[Jul 9]
PSPS         2-0 Persitara
  [Yulius Wicaksana 2, 15]
Perseden     3-0 Persidafon
  [Yan Marieta 32, 60, Komang Mariwan 67]
 
[Jul 11]
PSPS         0-0 Persikabo
Persitara    2-0 Persidafon
 
[Jul 12]
PSPS         0-1 Perseden
  [Yan Marieta 72]
Persitara    0-5 Persikabo
  [Umaru 32, Darmansyah 37, John Lungu 56, Suwandi 77]
 
[Jul 14]
Persikabo    1-1 Perseden
  [John Lungu 23; Marcelo 4]
PSPS         1-3 Persidafon
  [Ismet H 40; Rinaldi 73, 76 Frans Kaode 85]
 
Table:
 1.Perseden            4  3  1  0  6- 1 10                      
 2.Persikabo           4  1  3  0  7- 2  6                  
 3.PSPS                4  1  1  2  3- 4  4
 4.Persidafon          4  1  1  2  4- 7  4
 5.Persitara           4  1  0  3  2- 8  3
 

Semifinals [Jul 22, Stadion Mandala Krida, Yogyakarta]
Persikota           1-0 Perseden
  [Nova Zaenal 69]
PSIM                2-1 Persikabo
  [Rofik Ismanto 23, Bambang Sumantri 89; Bambock Justin L 41]

Third Place Match [Jul 24, Stadion Mandala Krida, Yogyakarta]
Persikabo           4-0 Perseden
  [Ntese John Lungu 19, 30, 74, Agus Sutiono 70]

Final [Jul 24, Stadion Mandala Krida, Yogyakarta]
Persikota           3-1 PSIM
  [Ali Shaha 6, Francis Yonga 12, 56; Bambang Sumantri 71pen]


Promoted: Persikota, PSIM, Persikabo

Author:
Johnny F. Tamaela
(jftamaela@bigfoot.com)

Last updated: 21 Dec 2005

(C) Copyright Johnny F. Tamaela
and RSSSF 1997/2005


  USO DE MEMORIA  
4,250,976 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0023
Controller Execution Time ( Home / Category )  0.5843
Total Execution Time  0.5866
  CADENA URL  
/liga_indonesia1997
  GET DATOS  
$_GET['/liga_indonesia1997']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (37)  
0.0125  SELECT type FROM routes WHERE alias = 'liga_indonesia1997'
0.0253  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'liga_indonesia' AND (l.group_code = 1 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 1997 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=333 AND type_rel = 3
0.0131  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 3 AND rel.typeId = 333 AND rel.ln = 'es' AND rel.status=1 ORDER BY rel.creation_date desc,rel.cover_points DESC LIMIT 5
0.0128  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 (1238086,1235961,1234022,1220135,1198661) ORDER BY n.cover_points DESC, update_date DESC
0.0126  SELECT text_es as historical_text FROM leagues_text WHERE id=2112
0.0126  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 = 30373 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='1997' WHERE c.parentId=333 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-28 11:27:36' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0127  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=2 AND last_update > '2024-04-28 11:27:36' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0126  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=4 AND last_update > '2024-04-28 11:27:36' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0126  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=3 AND last_update > '2024-04-28 11:27:36' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0134  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'liga_indonesia' AND (l.group_code = 0 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 1997 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=0 DESC LIMIT 1
0.0127  SELECT e.action, count(e.action) as total, e.player_id FROM events1997 e WHERE e.league_id IN (30373) 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.0130  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 (30373) 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 events1997 e WHERE e.league_id IN (30373) AND (e.action IN (4,5) ) GROUP BY e.player_id ORDER BY total DESC, e.player_id ASC LIMIT 20
0.0128  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 (30373) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN () ORDER BY rp.in_squad = 1 DESC
0.0130  SELECT e.action, count(e.action) as total, e.player_id FROM events1997 e WHERE e.league_id IN (30373) AND (e.action IN (3,4) ) GROUP BY e.player_id ORDER BY total DESC, e.player_id ASC LIMIT 20
0.0130  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 (30373) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN () ORDER BY rp.in_squad = 1 DESC
0.0134  SELECT e.action, count(e.action) as total, e.player_id FROM events1997 e WHERE e.league_id IN (30373) AND (e.action IN (22) ) GROUP BY e.player_id ORDER BY total DESC, e.player_id ASC LIMIT 20
0.0131  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 (30373) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN () ORDER BY rp.in_squad = 1 DESC
0.0129  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 = 30373 AND rp.lineup > 0 ORDER BY rp.lineup DESC,p.pod DESC LIMIT 20
0.0129  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 = 30373 AND rp.events > 0 ORDER BY rp.events DESC,p.pod DESC LIMIT 20
0.0139  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=30373 AND rel.round=20
0.0131  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 = 30373 AND esl.points > 0 ORDER BY esl.points DESC LIMIT 3
0.0128  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 = 30373 AND esl.points > 0
0.0128  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-29" AND c.`active`= 1 and c.comment_id is null and c.lang = 1 AND l.`id` = 30373 ORDER BY creation_date DESC LIMIT 0, 10
0.0155  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-29" AND c.`active`= 1 and comment_id is null and c.lang = 1 AND l.`id` = 30373
0.0129  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 `calendars1997` 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` = 30373 AND c.`round` = 20 ORDER BY shedule ASC LIMIT 200
0.0127  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 `events1997` e INNER JOIN calendars1997 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 = 20 AND e.real_date IS NOT NULL AND e.league_id = 30373 ORDER BY total DESC LIMIT 40
0.0129  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 `events1997` e INNER JOIN calendars1997 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 = 30373 AND e.real_date > NOW() - INTERVAL 1 MONTH ORDER BY e.real_date DESC LIMIT 30
0.0132  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 `tables1997` 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 = 30373 AND t.round = 18 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0132  SELECT *,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables1997` 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 = 30373 AND t.round = 20 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0132  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-28 00:00:00' AND c.`shedule` < '2024-05-02 23:59:59' AND l.id = 30373 ORDER BY c.shedule ASC, fcoef DESC LIMIT 5
0.0132  SELECT data1, data2 FROM services_tags WHERE categoryId=333
0.0132  SELECT l.year,l.group_code FROM leagues_besoccer l WHERE l.categoryId = 333 AND l.year = 1997 ORDER BY l.group_code ASC
0.0132  SELECT group_code, extraName from `leagues` WHERE categoryId=333 AND year=1997