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 Catar 2000
1999/2000

Liga Catar 2000

Información Histórica 
						

Round 1 
[Nov 18]
Qatar   1-0 Wakra
  [Abdulaziz Hassan (89' pen.)]
[Nov 19]
Taawun  2-1 Shamal
  [Uli Parreira (26'), Salah Foudal (34') - Haytham Al-Amin (13')]
[later]
Rayyan  1-1 Ittihad
  [Gilson Sousa (31') - Fabrice Akwa (87')]
[Dec 20]
Sadd    1-0 Arabi
  [Jassem Mahmoud (48')]
Ahli    bye

Round 2 [Nov 25,26]
Arabi   1-2 Rayyan
  [Mubarak Mustapha (50') - Gilson Souza (9'), Mohamed Salem Al-Enazi (52')]
Ahli    2-2 Taawun 
  [Paulo Sergio (78'), Abdullah Al-Mansouri (81') - Uli Parreira (26'; 84')]
Wakra   0-2 Ittihad
  [Fabrice Akwa (25'), Osvaldo Martinez (42')]
Qatar   4-0 Shamal
  [Khaled Gharib (20'), Sido Traoré (32'), Abdulaziz Hassan (43'), Othman Al-Khatib (68')]
Sadd    bye

Round 3 
[Dec 2,3]
Wakra   2-3 Arabi
  [Hussein Ali Al-Meri (53'), Nayef Al-Khater (56') - Hisham Zahed (18'), 
   Ahmed Fares (50'), Mahmoud Soufi (79')]
Ittihad 3-0 Shamal
  [Fabrice Akwa (12'; 54'), Franck Sitora (38')]
Qatar   2-2 Ahli  
  [Abdullah Al-Hamad (37'), Salem Al-Adasani (67' og) - Paulo Sergio (37'),
   Khalifa Salem (62')]
[Jan 4]
Sadd    1-2 Rayyan
  [Abdullah Obaid (2') - Mohamed Salem Al-Enazi (14'; 70')]
Taawun  bye

Round 4 [Dec 9,10]
Shamal  1-4 Arabi
  [Sobhi Adel (55') - Mubarak Mustapha (20' pen.; 37'; 65'), Mahmoud Soufi (27')]
Ittihad 1-1 Ahli
  [Mustapha Adam (25') - Suleyman Sissi (45')]
Sadd    3-1 Wakra
  [Adel Jaddouh (7'), Fahad Al-Kowari (71' pen.; 76') - Hussein Al-Meri (74')]
Qatar   0-2 Taawun
  [Salah Foudal (10'; 37')]
Rayyan  bye

Round 5 [Dec 16,17]
Arabi   1-0 Ahli
  [Marcelo Kuervas (58')]
Shamal  0-5 Sadd
  [Mohamed Gholam (15'; 25'), Abdulnasser Al-Obaidly (47'), 
   Fahad Al-Kowari (67' pen.; 90')]
Ittihad 3-0 Taawun
  [Mustapha Adam (37'; 84'), Abdullah Al-Mazrouyi (41')]
Wakra   0-1 Rayyan
  [Mohamed Salem Al-Enazi (66')]
Qatar   bye

Round 6 [Dec 23,24]
Ahli    1-6 Sadd
  [Paulo Sergio (15') - Fahad Al-Kowari (1'; 48' pen.; 74' pen.), 
   Joseph Ogu (64'; 76'), Dahi Al-Noubi (71')]
Arabi   1-1 Taawun
  [Jeremy Okudu (59') - Salah Foudal (44')]
Shamal  1-7 Rayyan
  [Wajdi Badreddine (22' pen.) - Mamadou So (14'), Mohamed Salem Al-Enazi (31'; 84'), 
   Gilson Souza (36'), Faysal Adam (58'; 65'), Salman Musabbah (73')]
Ittihad 1-1 Qatar
  [Franck Sitora (23') - Moammar Abdurrabb (12')]
Wakra   bye

Round 7 [Dec 30,31]
Sadd    0-0 Taawun
Ahli    2-1 Rayyan
  [Youssouf Mounif (4'), Hassan Abdulrazzaq (5') - Gilson Souza (52')]
Arabi   5-0 Qatar
  [Mahmoud Soufi (2'; 56'; 87'), Marcelo Kuervas (58'), Abdulaziz Karim (68')]
Shamal  0-1 Wakra
  [Hussein Al-Meri (82' pen.)]
Ittihad bye

Round 8 [Jan 6,7]
Taawun  1-2 Rayyan
  [Marcio Domingos (25') - Mohamed Salem Al-Enazi (31'), Gilson Sousa (55')]
Sadd    2-0 Qatar
  [Dane Fayne (49'), Jassem Mahmoud (51')]
Arabi   awd Ittihad         [awarded 3-0, originally 1-3]
  [Mahmoud Soufi (50') - Youssouf Adam (25'), Mustapha Adam (65'; 89')]
  [match awarded 3-0 as Ittihad substituted their (sent off) 'keeper by a
   foreign player; according to local rules foreigners may not play as keeper]
Ahli    1-0 Wakra
  [Abdullah Jassem (54')]
Shamal  bye

Round 9 [Jan 13,14]
Rayyan  0-0 Qatar
Taawun  1-2 Wakra
  [Salah Foudal (49') - Nii Bala (15'; 67')]
Ahli    3-2 Shamal 
  [Abdullah Jassem (15'), Paulo Sergio (76'; 88') - Adam Shivro (19'; 49')]
Sadd    2-1 Ittihad
  [Fahad Al-Kowari (16'), Joseph Ogu (22') - Abdullah Al-Mazrouyi (90')]
Arabi   bye

Round 10 
[Jan 28,29]
Arabi   0-1 Sadd
  [Fahad Al-Kowari (26')]
Shamal  2-2 Taawun
  [Saeed Shahine (1'), Wajdi Badreddine (11' pen.) - Salah Foudal (7' pen.),
   Hussein Yasser (32')]
Wakra   0-0 Qatar
[Feb 15]
Rayyan  0-0 Ittihad
Ahli    bye

Round 11 [Feb 4]
Ittihad 1-2 Wakra
Shamal  0-1 Qatar
Taawun  1-0 Ahli
Rayyan  3-4 Arabi
  [Mohamed Salem Al-Enazi (13'; 44'; 74') - Mahmoud Soufi (21'),
   Hisham Zahed (55'), Abdulaziz Karim (81'), Ahmed Rashed (89')]
Sadd    bye

Round 12 [Feb 7]
Rayyan  1-0 Sadd
  [Nasser Kamil (65')]
Ahli    2-2 Qatar
  [Paulo Sergio (18'; 86' pen.) - Waliddine Mohamed (34'),
   Abdulaziz Hassan (56' pen.)]
Shamal  2-5 Ittihad
  [Saleh Al-Rashidi (63'; 65') - Fabrice Akwa (5'; 52'; 71'), 
   Franck Sitora (8'), Ozvaldo Martinez (85' pen.)]
Arabi   2-2 Wakra
  [Mahmoud Soufi (11'), Mubarak Mustapha (54') - Nayef Al-Khater (45'),
   Hussein Al-Meri (51')]
Taawun  bye

Round 13 [Feb 11]
Ahli    1-1 Ittihad
  [Paulo Sergio (55') - Fabrice Akwa (22')]
Arabi   9-0 Shamal
  [Marcelo Kuervas (5'; 25'), Rashed Moussa (39'; 88'), Ahmed Fares (41'), 
   Silvinho Dalma (44'), Jeremy Okudu (54'; 64'), Mubarak Al-Kowari (90')]
Taawun  1-2 Qatar
  [Abdullah Ahmed (68') - Abdulaziz Hassan (82'), Khamis Ahmed (90')]
Wakra   1-2 Sadd
  [Nii Bala (57') - Abdullah Obaid (55'), Abdulnasser Al-Obaidly (68')]
Rayyan  bye

Round 14 [Feb 18,19]
Ahli    1-0 Arabi
  [Rashed Obaid (27')]
Sadd    5-0 Shamal
  [Dane Fayne (10'; 44'), Joseph Ogu (17'), Hussein Amouta (42'), 
   Eissa Gholam (82')]
Taawun  0-0 Ittihad
Rayyan  1-1 Wakra
  [Gilson Souza (44') - Nayef Al-Khater (84')]
Qatar   bye

Round 15 [Feb 26]
Sadd    2-0 Ahli
  [Joseph Ogu (66'), Fahad Al-Kowari (75')]
Taawun  3-3 Arabi
  [Fabrizio Santos (26'), Husein Yasser Al-Mohammadi (79'), 
   Abdullah Hassan (81') - Jeremy Okudu (46'), Marcelo Kuervas (52' pen.),
   Mubarak Mustapha (60')]
Rayyan  2-1 Shamal
  [Gilson Sousa (86'), Mohamed Salem Al-Enazi (88') - Abdulaziz Bilal (8')]
Qatar   1-4 Ittihad
  [Meshel Mubarak (25') - Mustapha Adam (39'), Saghir Al-Shemmari (49'), 
   Abdullah Al-Mazrouyi (70'), Ozvaldo Martinez (73')]
Wakra   bye

Round 16 [Mar 2]
Rayyan  3-0 Ahli
  [Mohamed Salem Al-Enazi (43'; 85'), Nasser Kamil (87')]
Taawun  0-1 Sadd
  [Adel Darwish (25']
Qatar   0-0 Arabi
Wakra   6-2 Shamal
  [Boubacar Ali (11'; 39'), Nii Bala (69'; 83'), Jassem Al-Tamimi (51'),
   Jassem Saleh (86') - Wajdi Badreddine (56'; 80')]
Ittihad bye

Round 17 [Mar 5]
Qatar   0-4 Sadd
  [Dane Fayne (48'; 58'), Joseph Ogu (65'), Hussein Amouta (77')]
Rayyan  2-1 Taawun
  [Mohamed Salem Al-Enazi (49'), Gilson Souza (78') - Fabrizio Santos (46')]
Ittihad 0-0 Arabi
Wakra   2-0 Ahli
  [Boubacar Ali (13'), Hussein Al-Meri (77')]
Shamal  bye

Round 18 [Mar 9]
Ittihad 1-1 Sadd
  [Ali Al-Ka'abi (30') - Mohamed Gholam (87')]
Shamal  0-1 Ahli
Wakra   2-2 Taawun
Qatar   0-1 Rayyan
Arabi   bye

Final Table:

 1.Al Sadd       16 12  2  2  36- 8  38  [Doha-al-Sadd]   Champions
 2.Al Rayyan     16 10  4  2  29-14  34  [Rayyan]
 3.Al Arabi      16  7  5  4  36-17  26  [Doha]
 4.Al Ittihad    16  5  8  3  24-15  23  [Doha-Gharrafa]
 5.Al Ahli       16  5  5  6  17-26  20  [Doha]
 6.Al Wakra      16  5  4  7  22-22  19  [Wakra] 
 7.Qatar SC      16  4  6  6  14-24  18  [Doha]        
 8.Al Taawun     16  3  7  6  19-23  16  [Khor]
- - - - - - - - - - - - - - - - - - - -
 9.Al Shamal     16  0  1 15  12-60   1  [Shamal]         Relegation Playoff

Relegation Playoff

First Leg [Apr 18]
Shamal  0-0 Shabab

Second Leg [Apr 26]
Shabab  1-2 Shamal

Shamal remain in 1st division


Topscorers:

1. Mohamed Salem Al-Enazi (Al-Rayyan) 14
2. Fahad Al-Kowari (Al-Sadd)           9
3. Fabrice Akwa (Al-Ittihad)           8
   Paulo Sergio (Al-Ahly)              8
   Mahmoud Soufi (Al-Arabi)            8
   Gilson Souza (Al-Rayyan)            8
7. Mustapha Adam (Al-Ittihad)          6
   Salah Foudal (Al-Ta'awon)           6
   Mubarak Mustapha (Al-Arabi)         6
   Joseph Ogu (Al-Sadd)                6



Authors:
Mohammed Qayed
(mhqayed@hotmail.com)
and Mohamed S. Chbaro
(sp_editor@terra.net.lb)

Last updated: 18 Sep 2003

(C) Copyright Mohammed Qayed, Mohamed S. Chbaro and RSSSF 1999/2003


  USO DE MEMORIA  
4,241,680 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0033
Controller Execution Time ( Home / Category )  0.0940
Total Execution Time  0.0974
  CADENA URL  
/liga_catar2000
  GET DATOS  
$_GET['/liga_catar2000']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (34)  
0.0018  SELECT type FROM routes WHERE alias = 'liga_catar2000'
0.0040  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'liga_catar' 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.0019  SELECT text_es as historical_text FROM leagues_text WHERE id=1532
0.0019  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 = 29803 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0020  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=312 GROUP BY c.id ORDER BY c.order_id ASC
0.0018  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-04-27 11:40:03' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0018  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=2 AND last_update > '2024-04-27 11:40:03' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0018  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=4 AND last_update > '2024-04-27 11:40:03' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0019  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=3 AND last_update > '2024-04-27 11:40:03' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0024  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'liga_catar' 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.0018  SELECT e.action, count(e.action) as total, e.player_id FROM events2000 e WHERE e.league_id IN (29803) 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.0018  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 (29803) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN () ORDER BY rp.in_squad = 1 DESC
0.0018  SELECT e.action, count(e.action) as total, e.player_id FROM events2000 e WHERE e.league_id IN (29803) AND (e.action IN (4,5) ) GROUP BY e.player_id ORDER BY total DESC, e.player_id ASC LIMIT 20
0.0018  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 (29803) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN () ORDER BY rp.in_squad = 1 DESC
0.0019  SELECT e.action, count(e.action) as total, e.player_id FROM events2000 e WHERE e.league_id IN (29803) AND (e.action IN (3,4) ) GROUP BY e.player_id ORDER BY total DESC, e.player_id ASC LIMIT 20
0.0019  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 (29803) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN () ORDER BY rp.in_squad = 1 DESC
0.0019  SELECT e.action, count(e.action) as total, e.player_id FROM events2000 e WHERE e.league_id IN (29803) AND (e.action IN (22) ) GROUP BY e.player_id ORDER BY total DESC, e.player_id ASC LIMIT 20
0.0019  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 (29803) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN () ORDER BY rp.in_squad = 1 DESC
0.0019  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 = 29803 AND rp.lineup > 0 ORDER BY rp.lineup DESC,p.pod DESC LIMIT 20
0.0018  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 = 29803 AND rp.events > 0 ORDER BY rp.events DESC,p.pod DESC LIMIT 20
0.0027  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=29803 AND rel.round=16
0.0022  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 = 29803 AND esl.points > 0 ORDER BY esl.points DESC LIMIT 3
0.0021  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 = 29803 AND esl.points > 0
0.0019  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` = 29803 ORDER BY creation_date DESC LIMIT 0, 10
0.0025  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` = 29803
0.0019  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` = 29803 AND c.`round` = 16 ORDER BY shedule ASC LIMIT 200
0.0018  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 = 16 AND e.real_date IS NOT NULL AND e.league_id = 29803 ORDER BY total DESC LIMIT 40
0.0020  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 = 29803 AND e.real_date > NOW() - INTERVAL 1 MONTH ORDER BY e.real_date DESC LIMIT 30
0.0023  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 = 29803 AND t.round = 14 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0023  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 = 29803 AND t.round = 16 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0023  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 = 29803 ORDER BY c.shedule ASC, fcoef DESC LIMIT 5
0.0023  SELECT data1, data2 FROM services_tags WHERE categoryId=312
0.0023  SELECT l.year,l.group_code FROM leagues_besoccer l WHERE l.categoryId = 312 AND l.year = 2000 ORDER BY l.group_code ASC
0.0023  SELECT group_code, extraName from `leagues` WHERE categoryId=312 AND year=2000