4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
« Temporada Anterior
Temporada 2000
Temporada Siguiente »
Publicidad 600x120.gif
Liga Bahréin 2000
1999/2000

Liga Bahréin 2000

Información Histórica 
						
Tables:

Group 1

 1.Muharraq          10   6  4  0  21-10  22  [Muharraq]  
 2.West Riffa        10   6  3  1  27-13  21  [West Riffa]
 3.Al-Hala           10   4  2  4  15-16  14  [Muharraq-al-Hala]
 4.Essa Town         10   3  2  5  15-19  11  [Essa Town]
 - - - - - - - - - - - - - - - - - - - - - -
 5.Malikiya          10   3  1  6  17-23  10
 6.Budaia            10   1  2  7   8-22   5  [Budaia]   

Group 2

 1.Al-Ahli           10   6  2  2  16- 9  20  [Manama]
 2.Besaiteen         10   4  5  1  17- 9  17  [Besaiteen]
 3.Bahrain           10   3  5  2  11-11  14  [Muharraq]
 4.East Riffa        10   4  1  5  15-14  13  [East Riffa]
 - - - - - - - - - - - - - - - - - - - - - -
 5.Qalali            10   2  4  4  17-24  11
 6.Al-Hilal          10   1  3  6  11-20   6  [Manama]

Round 1 
[Nov 17]
Essa Town    2-3 Hala
Qalali       0-6 Besaiteen
[Nov 18]
West Riffa   5-1 Budaia
East Riffa   1-0 Bahrain
[Nov 19]
Muharraq     5-1 Malikiya
Ahli         1-0 Hilal

Round 2
[Nov 24]
Budaia       1-1 Muharraq
Hilal        0-2 Bahrain
[Nov 25]
Hala         3-1 Malikiya
Qalali       1-3 Ahli
[Nov 26]
Essa Town    0-3 West Riffa  
Besaiteen    2-1 East Riffa

Round 3
[Dec 1]
West Riffa   2-0 Malikiya
Besaiteen    2-1 Ahli
[Dec 2]
Muharraq     2-0 Hala
East Riffa   3-0 Hilal
[Dec 3]
Essa Town    1-1 Budaia
Qalali       1-1 Bahrain

Round 4
[Dec 11]
Hala         1-2 Budaia
[Dec 12]
Qalali       1-1 Hilal
[Dec 13]
Essa Town    2-4 Malikiya
[Dec 14]
Besaiteen    2-2 Bahrain
[Dec 16]
West Riffa   3-3 Muharraq
[Dec 17]
Ahli         1-0 East Riffa

Round 5
[Dec 18]
Malikiya     4-1 Budaia
[Dec 19]
Besaiteen    1-1 Hilal
[Dec 20]
West Riffa   1-1 Hala
[Dec 21]
East Riffa   4-3 Qalali
[Dec 22]
Muharraq     2-0 Essa Town 
[Dec 23]
Ahli         3-0 Bahrain

Round 6
[Jan 3]
Essa Town    1-2 Muharraq
[Jan 11]
Hilal        3-2 Ahli
[Jan 12]
Budaia       0-3 Malikiya
Besaiteen    1-1 Qalali
[Jan 13]
Hala         1-5 West Riffa  
Bahrain      3-2 East Riffa   

Round 7
[Dec 31]
Muharraq     1-1 Malikiya
[Jan 16]
Ahli         2-2 Qalali
[Jan 17]
Bahrain      1-1 Hilal
East Riffa   0-0 Besaiteen
[Jan 18]
Budaia       0-1 West Riffa
Hala         0-1 Essa Town

Round 8
[Jan 21]
Hilal        0-2 East Riffa
Besaiteen    0-1 Ahli
[Jan 22]
Malikiya     1-3 Hala
West Riffa   2-2 Essa Town
[Jan 23]
Qalali       0-1 Bahrain
[Feb 7]
Muharraq     1-0 Budaia

Round 9
[Jan 26]
Besaiteen    3-2 Hilal
[Jan 27]
Budaia       2-3 Essa Town
Ahli         1-1 Bahrain
[Jan 28]
Malikiya     2-3 West Riffa
East Riffa   2-4 Qalali
[Feb 11]
Hala         1-1 Muharraq

Round 10
[Feb 2]
Budaia       0-2 Hala
Bahrain      0-0 Besaiteen
[Feb 3]
Muharraq     3-2 West Riffa
Qalali       4-3 Hilal
[Feb 4]
Malikiya     0-3 Essa Town
Ahli         1-0 East Riffa

Tables:

Group 1

 1.Muharraq          10   6  4  0  21-10  22  [Muharraq]  
 2.West Riffa        10   6  3  1  27-13  21  [West Riffa]
 3.Al-Hala           10   4  2  4  15-16  14  [Muharraq-al-Hala]
 4.Essa Town         10   3  2  5  15-19  11  [Essa Town]
 - - - - - - - - - - - - - - - - - - - - - -
 5.Malikiya          10   3  1  6  17-23  10
 6.Budaia            10   1  2  7   8-22   5  [Budaia]   

Group 2

 1.Al-Ahli           10   6  2  2  16- 9  20  [Manama]
 2.Besaiteen         10   4  5  1  17- 9  17  [Besaiteen]
 3.Bahrain           10   3  5  2  11-11  14  [Muharraq]
 4.East Riffa        10   4  1  5  15-14  13  [East Riffa]
 - - - - - - - - - - - - - - - - - - - - - -
 5.Qalali            10   2  4  4  17-24  11
 6.Al-Hilal          10   1  3  6  11-20   6  [Manama]


Championship Playoff

Tables:

Group A

 1.Muharraq           6   4  2  0  15- 8  14  [Muharraq]  
 2.East Riffa         6   3  1  2  11- 8  10  [East Riffa]
 - - - - - - - - - - - - - - - - - - - - - -
 3.Al-Hala            6   2  2  2  13- 9   8  [Muharraq-al-Hala]
 4.Besaiteen          6   0  1  5   6-20   1  [Besaiteen]

Group B

 1.Al-Ahli            6   4  1  1   8- 4  13  [Manama]
 2.West Riffa         6   3  0  3  11- 9   9  [West Riffa]
 - - - - - - - - - - - - - - - - - - - - - -
 3.Bahrain            6   2  1  3  10-10   7  [Muharraq]
 4.Essa Town          6   1  2  3   7-13   5  [Essa Town]

Round 1 
[Feb 14]
Ahli         0-1 Essa Town
[Feb 15]
Muharraq     4-1 East Riffa
Hala         3-1 Besaiteen
Bahrain      2-1 West Riffa

Round 2
[Feb 20]
Ahli         2-0 West Riffa
Essa Town    0-0 Bahrain
[Feb 21]
Muharraq     2-2 Besaiteen
East Riffa   2-1 Hala

Round 3
[Feb 25]
Ahli         1-0 Bahrain
West Riffa   2-1 Essa Town
[Feb 26]
Muharraq     2-2 Hala
Besaiteen    0-4 East Riffa

Round 3
[Apr 20]
West Riffa   3-1 Bahrain
Essa Town    1-1 Ahli
[Apr 21]
East Riffa   4-1 Besaiteen
Hala         2-3 Muharraq

Round 5
[Apr 26]
Hala         0-0 East Riffa
Besaiteen    1-2 Muharraq
[Apr 28]
Bahrain      1-2 Ahli
Essa Town    1-4 West Riffa

Round 6
[May 3]
Bahrain      6-3 Essa Town
West Riffa   1-2 Ahli
[May 4]
Besaiteen    1-5 Hala
East Riffa   abd Muharraq      [abandoned at 0-2 in 77']

Tables:

Group A

 1.Muharraq           6   4  2  0  15- 8  14  [Muharraq]  
 2.East Riffa         6   3  1  2  11- 8  10  [East Riffa]
 - - - - - - - - - - - - - - - - - - - - - -
 3.Al-Hala            6   2  2  2  13- 9   8  [Muharraq-al-Hala]
 4.Besaiteen          6   0  1  5   6-20   1  [Besaiteen]

Group B

 1.Al-Ahli            6   4  1  1   8- 4  13  [Manama]
 2.West Riffa         6   3  0  3  11- 9   9  [West Riffa]
 - - - - - - - - - - - - - - - - - - - - - -
 3.Bahrain            6   2  1  3  10-10   7  [Muharraq]
 4.Essa Town          6   1  2  3   7-13   5  [Essa Town]

Semifinals

First Legs [May 8]
Muharraq     0-3 West Riffa
Ahli         2-3 East Riffa

Second Legs [May 12]
West Riffa   0-1 Muharraq
East Riffa   1-0 Ahli

Third Place Match [May 17]
Muharraq     2-3 Ahli

Final [May 18]
West Riffa   4-0 East Riffa

West Riffa champions 1999/2000


Relegation Playoff

Table:

 9.Al-Hilal           6   3  1  2  13- 6  10  [Manama]
10.Qalali             6   3  1  2   7- 7  10
 - - - - - - - - - - - - - - - - - - - - - -
11.Malikiya           6   2  1  3  10-13   7
--------------------------------------------
12.Budaia             6   2  1  3   6-10   7  [Budaia]   

Round 1 [Feb 13]
Budaia       0-1 Qalali
Malikiya     1-1 Hilal

Round 2 [Feb 17]
Malikiya     1-2 Qalali
Hilal        0-1 Budaia
 
Round 3
[Feb 23]
Malikiya     2-1 Budaia
[Feb 27]
Qalali       1-0 Hilal

Round 4
[Apr 26]
Budaia       3-2 Malikiya
[Apr 27]
Hilal        3-1 Qalali

Round 5 [May 5]
Qalali       2-3 Malikiya
Budaia       1-5 Hilal

Round 6 [May 11]
Hilal        4-1 Malikiya
Qalali       0-0 Budaia

Table:

 9.Al-Hilal           6   3  1  2  13- 6  10  [Manama]
10.Qalali             6   3  1  2   7- 7  10
 - - - - - - - - - - - - - - - - - - - - - -
11.Malikiya           6   2  1  3  10-13   7
--------------------------------------------
12.Budaia             6   2  1  3   6-10   7  [Budaia]   

Budaia relegated
Promoted: Setra

Promotion/Relegation Playoff

First Leg [May 19]
Malikiya     1-1 Qadisiya

Second Leg [May 22]
Qadisiya     abd Malikiya      [abandoned at 0-3 in 2nd half]

Malikiya remain at 1st level



Author:
Mohammed Qayed
(arab_football@hotmail.com)

Last updated: 11 Jan 2001

(C) Copyright Mohammed Qayed and RSSSF 1999/2001


  USO DE MEMORIA  
4,280,112 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0018
Controller Execution Time ( Home / Category )  0.7005
Total Execution Time  0.7024
  CADENA URL  
/premier_league_bahrein2000
  GET DATOS  
$_GET['/premier_league_bahrein2000']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (40)  
0.0144  SELECT type FROM routes WHERE alias = 'premier_league_bahrein2000'
0.0293  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'premier_league_bahrein' AND (l.group_code = 1 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 2000 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=431 AND type_rel = 3
0.0147  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 3 AND rel.typeId = 431 AND rel.ln = 'es' AND rel.status=1 ORDER BY rel.creation_date desc,rel.cover_points DESC LIMIT 5
0.0148  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 (1091300,1091289,1090156,1015512,810293) ORDER BY n.cover_points DESC, update_date DESC
0.0148  SELECT text_es as historical_text FROM leagues_text WHERE id=2509
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 = 30764 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='2000' WHERE c.parentId=431 GROUP BY c.id ORDER BY c.order_id ASC
0.0144  SELECT type,rule FROM rules WHERE categoryId = 431 ORDER BY type = 'tables_draw' DESC,type != 'extra' DESC, `order` ASC
0.0145  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-04-26 16:15: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-26 16:15: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=4 AND last_update > '2024-04-26 16:15: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=3 AND last_update > '2024-04-26 16:15:40' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0150  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'premier_league_bahrein' AND (l.group_code = 0 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 2000 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=0 DESC LIMIT 1
0.0145  SELECT e.action, count(e.action) as total, e.player_id FROM events2000 e WHERE e.league_id IN (30764) 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.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 (30764) 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 events2000 e WHERE e.league_id IN (30764) AND (e.action IN (4,5) ) 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 (30764) 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 events2000 e WHERE e.league_id IN (30764) AND (e.action IN (3,4) ) 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 (30764) 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 events2000 e WHERE e.league_id IN (30764) AND (e.action IN (22) ) GROUP BY e.player_id ORDER BY total DESC, e.player_id ASC LIMIT 20
0.0147  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 (30764) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN () ORDER BY rp.in_squad = 1 DESC
0.0147  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 = 30764 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 = 30764 AND rp.events > 0 ORDER BY rp.events DESC,p.pod DESC LIMIT 20
0.0145  SELECT max(l.year) as max_year, min(l.year) as min_year FROM leagues l WHERE categoryID = 431 GROUP BY l.categoryId
0.0145  SELECT l.year FROM leagues AS l WHERE (l.group_code =0 OR l.total_num_tablesR>=1 OR l.total_teamsR >=1 OR l.text_mode != 0) AND l.categoryId=431 GROUP BY l.year ORDER BY l.year DESC
0.0152  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=30764 AND rel.round=10
0.0148  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 = 30764 AND esl.points > 0 ORDER BY esl.points DESC LIMIT 3
0.0148  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 = 30764 AND esl.points > 0
0.0146  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` = 30764 ORDER BY creation_date DESC LIMIT 0, 10
0.0150  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` = 30764
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 `calendars2000` 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` = 30764 AND c.`round` = 10 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 `events2000` e INNER JOIN calendars2000 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 = 10 AND e.real_date IS NOT NULL AND e.league_id = 30764 ORDER BY total DESC LIMIT 40
0.0147  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 `events2000` e INNER JOIN calendars2000 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 = 30764 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 `tables2000` 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 = 30764 AND t.round = 8 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 `tables2000` 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 = 30764 AND t.round = 10 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-26 00:00:00' AND c.`shedule` < '2024-04-30 23:59:59' AND l.id = 30764 ORDER BY c.shedule ASC, fcoef DESC LIMIT 5
0.0149  SELECT data1, data2 FROM services_tags WHERE categoryId=431
0.0149  SELECT l.year,l.group_code FROM leagues_besoccer l WHERE l.categoryId = 431 AND l.year = 2000 ORDER BY l.group_code ASC
0.0149  SELECT group_code, extraName from `leagues` WHERE categoryId=431 AND year=2000