4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
 
Temporada 2003
Temporada Siguiente »
Publicidad 600x120.gif
Liga Brunei 2003
2002/2003

Liga Brunei 2003

Información Histórica 
						
B-League 

B-League Qualifying Tournament

Round 1 [Apr 25]
Group A
AKSE            1-0     Brunei Shell Petroleum
QAF FC          3-2     Muara Stars
Group B
Sabina FC       3-2     IB Pandan
Lun Bawang      2-0     Sengkurong FC

Round 2
Group A
[Apr 27]
Muara Stars     0-1     AKSE
[Apr 28]
Brunei Shell    1-2     QAF FC
Group B
[Apr 27]
Sabina FC       2-1     Lun Bawang
[Apr 28?]
IB Pandan       1-2     Senkurong FC

Round 3 [May 2]
Group A
QAF FC          3-2     AKSE
Muara Stars     1-1     Brunei Shell
Group B
Sengkurong FC   0-0     Sabina FC
Lun Bawang      4-4     IB Pandan

Tables:

Group A
 1.QAF FC                  3   3  0  0   8- 5   9  Qualified
 2.AKSE                    3   2  0  1   4- 3   6  Qualified
 3.Muara Stars             3   0  1  2   3- 5   1  Playoff
 4.Brunei Shell Petroleum  3   0  1  2   2- 4   1

Group B
 1.Sabina FC               3   2  1  0   5- 3   7  Qualified
 2.Lun Bawang              3   1  1  1   7- 6   4  Qualified
 3.Sengkurong FC           3   1  1  1   2- 3   4  Playoff
 4.IB Pandan               3   0  1  2   7- 9   1


Promotion Playoff [May 4]
Sengkurong FC   4-1     Muara Stars

QAF FC, AKSE, Sabina FC, Lun Bawang and Sengkurong FC qualify for B-League

B-League 2003

Tables:

Group A
 1.AH United               9   7  2  0  22- 9  23  Qualified
 2.DPMM FC                 9   7  1  1  35- 6  22  Qualified
 3.Jerudong FC             9   5  2  2  14-13  17  Qualified
 4.Sengkurong FC           9   5  1  3  17-11  16  Qualified
 5.Kota Ranger             9   4  2  3  25-13  14  Qualified
- - - - - - - - - - - - - - - - - - - - - - - - -
 6.Sabina FC               9   4  2  3  25-15  14
 7.Bandaran KB             8   2  2  4  11-16   8
 8.Mulaut FC               9   1  3  5  11-20   6
 9.Lun Bawang              8   1  1  6   6-26   4
10.IBM Bokok               9   0  0  9   3-40   0

Group B
 1.Kasuka FC               9   8  0  1  28- 8  24  Qualified
 2.Wijaya United           9   7  1  1  21- 7  22  Qualified
 3.Armed Forces            9   7  0  2  23- 7  21  Qualified
 4.Indera FC               9   5  1  3  22-14  16  Qualified
 5.QAF FC                  9   5  1  3  21-15  16  Qualified
- - - - - - - - - - - - - - - - - - - - - - - - -
 6.Kilanas FC              9   3  1  5  14-26  10
 7.Persatuan AKSE          9   2  0  7  18-26   6
 8.Kamudi FC               9   2  0  7   9-20   6
 9.Pesaka FC               9   1  2  6  13-20   5
10.Mengelella FC           9   1  2  6   9-35   5

NB: Police Forces withdrew.  Top 5 of both groups qualify for second stage.

Round 1
[May 16]
Jerudong        1-0     Kota Ranger 
[May 17]
Sabina          6-0     Lun Bawang
[May 18]
QAF             4-0     AKSE
Sengkurong      2-1     Mulaut          [also reported 1-0]
[May 18?]
Kasuka          3-1     Pesaka
IBM Bokok       1-2     Bandaran KB     
Indera          4-0     Kilanas
Kamudi          3-4     Mengelella    
[May 20]
DPMM            1-2     AH United
[May 21]
Armed Forces    1-2     Wijaya 

Round 2
[May 21]
Kota Ranger     1-1     Sengkurong
[May 23?]
QAF             1-0     Armed Forces
[May 24]
Wijaya          4-1     Kilanas
AH United       4-0     Bokok
Mengellela      0-6     Kasuka
Jerudong        2-0     Mulaut
[May 25]
Indera          4-2     AKSE
DPMM            5-2     Lun Bawang
Kamudi          1-0     Pesaka
Sabina          5-3     Bandaran

Round 3
[May 27]
Bandaran        4-2     Jerudong        [also reported 5-3]
AH United       2-1     Sabina
[May 28]
Kasuka          4-1     Indera
[May 30]
DPMM           11-0     Bokok
Kota Ranger     5-0     Mulaut
Kamudi          0-2     QAF
Wijaya          1-0     AKSE
Sengkurong      2-0     Lun Bawang
Armed Forces    5-0     Kilanas
Pesaka          2-2     Mengellela      

Round 4
[Jun 1]
Mulaut          0-2     DPMM
Bokok           1-4     Sabina
Kamudi          0-1     Wijaya
Lun Bawang      1-3     Jerudong
Indera          3-2     Pesaka
Mengellela      1-3     Armed Forces
QAF             1-3     Kasuka
[Jun 2]
AH United       1-0     Sengkurong
[Jun 3]
Kilanas         4-2     AKSE
[Jun 8]
Bandaran        1-1     Kota Ranger 

Round 5
[Jun 9]
Pesaka          1-2     QAF 
Armed Forces    3-0     Indera 
[Jun 10]
Sabina          4-1     Mulaut 
Kasuka          1-0     Wijaya 
[Jun 11]
Kamudi          0-1     Kilanas 
Jerudong        1-1     AH United 
DPMM            4-0     Sengkurong
[Jun 13]
Bokok           0-1     Lun Bawang
[Jun 21,22?]
AKSE            6-0     Mengelella FC

Moved Matches [Jun 13]
Wijaya          1-1     Pesaka 
Kilanas         3-3     QAF 
AH United       3-2     Kota Ranger 
Armed Forces    2-1     Kamudi

Round 6
[Jun 16]
Indera          1-1     Mengellela
Wijaya          3-2     QAF
[Jun 17]
Kasuka          3-1     AKSE    
DPMM            4-1     Kota Ranger 
[Jun 18]
Sabina          1-1     Jerudong
AH United       1-0     Bandaran

[Jun 21,22]
Sengkurong      6-0     IBM Bokok
Kota Ranger     5-1     Lun Bawang
DPMM FC         3-0     Bandaran
[Jun 24?]
Kasuka          4-2     Kilanas
Wijaya          1-0     Indera
[Jun 25]
AH United       4-4     Mulaut
Sabina          1-2     Sengkurong

[Jun 29]
QAF FC          5-0     Mengelella
Mulaut          4-0     IBM Bokok
Kamudi          3-2     AKSE
[Jun 30]
Armed Forces    1-0     Kasuka
Sabina          2-4     Kota Ranger 

[date unknown]
Mulaut          0-0     Bandaran KB

[Jul 2]
Indera          abd     Kamudi          [abd at 0-1 in 5' due to heavy rain]
[Jul 4]
DPMM            4-0     Jerudong
Bandaran        1-3     Sengkurong
Armed Forces    3-0     Pesaka
Wiyaya          8-1     Mengellela    
Kun Bawang      abd     AH United       [abandoned due to heavy rain]
[Jul 5 (replay)]
Indera          4-0     Kamudi

[Jul 5,6]
AKSE            3-2     Pesaka
Kilanas         1-0     Mengelella
[Jul 7]
Sabina          1-1     DPMM
Jerudong        2-1     Sengkurong
[Jul 8]
Kasuka          4-1     Kamudi
[Jul 9]
QAF             1-5     Indera
AKSE            2-5     Armed Forces
[Jul 11]
Kota Ranger     6-0     IBM Bokok
Mulaut          1-1     Lun Bawang
Kilanas         2-4     Pesaka
[Jul 13]
Jerudong        2-1     IBM Bokok
[Jul 18]
AH United       4-0     Lun Bawang
[later]
Bandaran         -      Lun Bawang

Tables:

Group A
 1.AH United               9   7  2  0  22- 9  23  Qualified
 2.DPMM FC                 9   7  1  1  35- 6  22  Qualified
 3.Jerudong FC             9   5  2  2  14-13  17  Qualified
 4.Sengkurong FC           9   5  1  3  17-11  16  Qualified
 5.Kota Ranger             9   4  2  3  25-13  14  Qualified
- - - - - - - - - - - - - - - - - - - - - - - - -
 6.Sabina FC               9   4  2  3  25-15  14
 7.Bandaran KB             8   2  2  4  11-16   8
 8.Mulaut FC               9   1  3  5  11-20   6
 9.Lun Bawang              8   1  1  6   6-26   4
10.IBM Bokok               9   0  0  9   3-40   0

Group B
 1.Kasuka FC               9   8  0  1  28- 8  24  Qualified
 2.Wijaya United           9   7  1  1  21- 7  22  Qualified
 3.Armed Forces            9   7  0  2  23- 7  21  Qualified
 4.Indera FC               9   5  1  3  22-14  16  Qualified
 5.QAF FC                  9   5  1  3  21-15  16  Qualified
- - - - - - - - - - - - - - - - - - - - - - - - -
 6.Kilanas FC              9   3  1  5  14-26  10
 7.Persatuan AKSE          9   2  0  7  18-26   6
 8.Kamudi FC               9   2  0  7   9-20   6
 9.Pesaka FC               9   1  2  6  13-20   5
10.Mengelella FC           9   1  2  6   9-35   5

NB: Police Forces withdrew.  Top 5 of both groups qualify for second stage.

NB: top-5 teams from both group to form Premier I for 2004; bottom-5 of
    each group relegated to Premier II where additional 4 clubs will 
    enter through a qualifying tournament.

Top Scorers:
8  Rafael Patron Akakpo (Sabina) 
   Ajayi Olusey (DPMM)
5  Mohammed Shahjohan (Kasuka)
4  Sardillah Abdullah (Armed Forces)
   Affandi Julaihi (Bandaran)
        

Second Stage

Final Table:

 1.Wijaya United           9   8  1  0  16- 3  25  Champions
 2.DPMM FC                 9   7  1  1  30- 6  22
 3.Armed Forces            9   7  0  2  29- 9  21
 4.Kasuka FC               9   5  1  3  20-17  16
 5.AH United               9   4  0  5  20-18  12
 6.Indera FC               9   3  2  4  17-21  11
 7.Sengkurong FC           9   2  2  5  10-21   8
 8.Kota Ranger FC          9   2  1  6  12-24   7  [*9]  
 9.QAF FC                  9   1  1  7  12-22   4  
10.Jerudong FC             9   1  1  7  10-35   4  [*9]

[*9] w/o goals rd 9

NB: unclear how many and which teams will be relegated

Round 1
[Jul 26]
Armed Forces    2-1     AH United 
[Jul 27]
DPMM            4-1     Indera
[Jul 28]
Kasuka          7-2     Jerudong
[Jul 29]
Wijaya          1-0     Sengkurong   
[Jul 30]
QAF FC          1-3     Kota Ranger 

Round 2
[Aug 1]
Wijaya          1-0     AH United
[Aug 2]
Sengkurong      0-1     Kasuka 
[Aug 8]
DPMM FC         2-0     QAF FC
Indera          3-2     Kota Ranger     
[date?]
Jerudong        0-6     Armed Forces

Round 3
[Aug 17]  
Armed Forces    6-1     Sengkurong
AH United       3-1     Jerudong
[Aug 18]
Indera          2-1     QAF FC
Wijaya          5-1     Kota Ranger 
[Aug 19]
Kasuka          0-2     DPMM FC

Round 4
[Aug 22]
DPMM FC         3-0     Kota Ranger 
Sengkurong      3-2     AH United   
[Aug 23]
Armed Forces    6-3     QAF FC
[Aug 24]
Jerudong        2-2     Indera
[date?]
Wijaya          2-0     Kasuka

Round 5
[Aug 29]
Jerudong        3-2     Sengkurong    
[Aug 30]
QAF FC          0-3     AH United
Kasuka          4-3     Indera
[Aug 31]
Armed Forces    3-0     Kota Ranger 
Wijaya          0-0     DPMM FC
 
Round 6
[Sep 12]
DPMM            8-0     Jerudong
Sengkurong      1-0     Kota Ranger   
AH United       3-4     Indera 
[Sep 13]
Wijaya          2-1     QAF FC
[date?]
Armed Forces    1-2     Kasuka

Round 7
[Sep 15]
AH United       5-3     Kota Ranger 
[Sep 16]
Armed Forces    2-0     Indera
[Sep 17]
Kasuka          3-2     QAF FC
[Sep 19]
DPMM            6-1     Sengkurong
Wijaya          3-1     Jerudong

Round 8
[Sep 28]
Sengkurong      2-2     Indera
QAF FC          4-1     Jerudong
Kasuka          3-3     Kota Ranger 
[Sep 29]
Wijaya          1-0     Armed Forces    
[Sep 30]
AH United       1-4     DPMM

Round 9
[Oct 3]
Sengkurong      0-0     QAF FC
[Oct 5]
Kota Ranger     bt      Jerudong
Indera          0-1     Wijaya
[Oct 6]
AH United       2-0     Kasuka
DPMM            1-3     Armed Forces

Final Table:

 1.Wijaya United           9   8  1  0  16- 3  25  Champions
 2.DPMM FC                 9   7  1  1  30- 6  22
 3.Armed Forces            9   7  0  2  29- 9  21
 4.Kasuka FC               9   5  1  3  20-17  16
 5.AH United               9   4  0  5  20-18  12
 6.Indera FC               9   3  2  4  17-21  11
 7.Sengkurong FC           9   2  2  5  10-21   8
 8.Kota Ranger FC          9   2  1  6  12-24   7  [*9]  
 9.QAF FC                  9   1  1  7  12-22   4 
10.Jerudong FC             9   1  1  7  10-35   4  [*9]

[*9] w/o goals rd 9

NB: no relegation


Author: Hans Schöggl
(hans.schoeggl@sbg.ac.at)

Last updated: 9 Jan 2005

(C) Copyright Hans Schöggl and RSSSF 2003/05


  USO DE MEMORIA  
4,244,528 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0021
Controller Execution Time ( Home / Category )  0.6305
Total Execution Time  0.6326
  CADENA URL  
/liga_brunei2003
  GET DATOS  
$_GET['/liga_brunei2003']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (35)  
0.0144  SELECT type FROM routes WHERE alias = 'liga_brunei2003'
0.0295  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'liga_brunei' AND (l.group_code = 1 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 2003 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=1 DESC LIMIT 1
0.0145  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=1761 AND type_rel = 3
0.0148  SELECT text_es as historical_text FROM leagues_text WHERE id=211
0.0145  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 = 28521 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0146  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='2003' WHERE c.parentId=1761 GROUP BY c.id ORDER BY c.order_id ASC
0.0146  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-04-27 11:22:40' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0145  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=2 AND last_update > '2024-04-27 11:22:40' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0149  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=4 AND last_update > '2024-04-27 11:22:40' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0148  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=3 AND last_update > '2024-04-27 11:22:41' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0153  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'liga_brunei' AND (l.group_code = 0 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 2003 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=0 DESC LIMIT 1
0.0146  SELECT e.action, count(e.action) as total, e.player_id FROM events2003 e WHERE e.league_id IN (28521) 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.0146  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 (28521) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN () ORDER BY rp.in_squad = 1 DESC
0.0146  SELECT e.action, count(e.action) as total, e.player_id FROM events2003 e WHERE e.league_id IN (28521) AND (e.action IN (4,5) ) GROUP BY e.player_id ORDER BY total DESC, e.player_id ASC LIMIT 20
0.0146  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 (28521) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN () ORDER BY rp.in_squad = 1 DESC
0.0147  SELECT e.action, count(e.action) as total, e.player_id FROM events2003 e WHERE e.league_id IN (28521) AND (e.action IN (3,4) ) GROUP BY e.player_id ORDER BY total DESC, e.player_id ASC LIMIT 20
0.0145  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 (28521) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN () ORDER BY rp.in_squad = 1 DESC
0.0146  SELECT e.action, count(e.action) as total, e.player_id FROM events2003 e WHERE e.league_id IN (28521) AND (e.action IN (22) ) GROUP BY e.player_id ORDER BY total DESC, e.player_id ASC LIMIT 20
0.0146  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 (28521) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN () ORDER BY rp.in_squad = 1 DESC
0.0145  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 = 28521 AND rp.lineup > 0 ORDER BY rp.lineup DESC,p.pod DESC LIMIT 20
0.0146  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 = 28521 AND rp.events > 0 ORDER BY rp.events DESC,p.pod DESC LIMIT 20
0.0151  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=28521 AND rel.round=3
0.0147  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 = 28521 AND esl.points > 0 ORDER BY esl.points DESC LIMIT 3
0.0150  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 = 28521 AND esl.points > 0
0.0148  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-28" AND c.`active`= 1 and c.comment_id is null and c.lang = 1 AND l.`id` = 28521 ORDER BY creation_date DESC LIMIT 0, 10
0.0152  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-28" AND c.`active`= 1 and comment_id is null and c.lang = 1 AND l.`id` = 28521
0.0146  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 `calendars2003` 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` = 28521 AND c.`round` = 3 ORDER BY shedule ASC LIMIT 200
0.0144  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 `events2003` e INNER JOIN calendars2003 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 = 3 AND e.real_date IS NOT NULL AND e.league_id = 28521 ORDER BY total DESC LIMIT 40
0.0146  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 `events2003` e INNER JOIN calendars2003 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 = 28521 AND e.real_date > NOW() - INTERVAL 1 MONTH ORDER BY e.real_date DESC LIMIT 30
0.0149  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 `tables2003` 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 = 28521 AND t.round = 1 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0149  SELECT *,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables2003` 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 = 28521 AND t.round = 3 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0149  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-27 00:00:00' AND c.`shedule` < '2024-05-01 23:59:59' AND l.id = 28521 ORDER BY c.shedule ASC, fcoef DESC LIMIT 5
0.0149  SELECT data1, data2 FROM services_tags WHERE categoryId=1761
0.0149  SELECT l.year,l.group_code FROM leagues_besoccer l WHERE l.categoryId = 1761 AND l.year = 2003 ORDER BY l.group_code ASC
0.0149  SELECT group_code, extraName from `leagues` WHERE categoryId=1761 AND year=2003