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

Liga Catar 2002

Información Histórica 
						

Round 1 
[Nov 21]
Arabi   2-6 Sadd          [at Al-Ahli]
  [Clayton Odigo 75, Naser Al-Soohi 76pen; El-Mbarki Boshib 35, 43, 82,
   Karim Bagheri 65, Ahmed Khalifa 67, John Otaka 90]
[Nov 22]
Ittihad 2-2 Taawun
  [Omran Rachid 55, 76; Frank Setora 57, 65]
Ittifaq 0-1 Qatar 
  [Yaser Nazmi 19]
[Nov 23]
Ahli    1-2 Wakra         [at Qatar SC]
  [Meshal Abdulla 46; Ali Qassem 72, Yousif Achmi 90]
Rayyan  bye

Round 2
[Nov 29]
Arabi   3-2 Taawun        [at Al-Ahli]
  [Walid Hamza 7, Clayton Odigo 82, Sidna Al-Bashir 90; Rachid Roki 70,
   Ismail Ali 74]
Ittihad 3-1 Ahli          [at Qatar SC]
  [Mujib Hamed 12, Imran Rachid 77, Mustafa Adam 86; Meshal Abdulla 10]
[Dec 17]
Qatar   2-1 Rayyan
  [Fabrice Akwa 53, 72; Jasem Al-Huwaidi 45pen]
[Apr 12]
Sadd    3-1 Ittifaq
  [Ahmed Khalifa 16, 56, Abdulla Koni 38; Saddiq Mahmood 1]
Wakra   bye

Round 3
[Dec 4]
Ahli    1-0 Arabi         [at Qatar SC]
  [Hassan Abdulrazzaq 8]
[Dec 6]
Ittihad 9-2 Ittifaq
  [Rachid Omran 18, 20, Mujib Hamed 27, Adel Khamis 64, Ozvaldo 72pen,
   Adel Jadooa 81, 88, 89, 90; Rashed Al-Dosari 43pen, Mubarak Al-Kawari 90]
[Feb 18]
Rayyan  3-2 Wakra
  [Jasem Al-Huwaidi 45, Bashar Abdulla 76, Mubarak Al-Belooshi 88;
   Mirghani Al-Zein 22, 47]
[Mar 8]
Sadd    1-1 Taawun
  [John Otaka 53; Christano 94pen]
Qatar   bye

Round 4
[Dec 12]
Qatar   1-1 Wakra
  [Fabrice Akwa 90; Al-Mirghani Al-Zein 70]
[Dec 13]
Rayyan  4-1 Ittihad       [at Qatar SC]
[Dec 14]
Sadd    1-1 Ahli          [at Qatar SC]
  [El-Mbarki Bochoaib 61; Rachid Al-Daouodi 86]
Arabi   2-1 Ittifaq       [at Al-hli]
  [Naser Kamil 33, Salah Al-Mulla 90; Mubarak Al-Kawari 86]
Taawun  bye

Round 5
[Dec 20]
Taawun  1-1 Ahli
  [Hassan Al-Murri 7; Rachid Al-Daouodi 35]
Wakra   2-0 Ittifaq
  [Yousef Ashmi 88, 94]
[Dec 21]
Rayyan  1-1 Arabi
  [Badr Al-Zaman 61; Ahmed Fares 58]
Qatar   1-2 Ittihad
  [Jasem Al-Buainain 42; Mustafa Adem 74, Adel Jadoua 79]
Sadd    bye

Round 6
[Jan 3]
Ittihad 3-1 Wakra
  [Anthony Yeboah 29, Omran Rachid 68, Adel Jadoua 76; Jasem Saleh 94]
Qatar   2-1 Arabi
  [Fabrice Akwa 53, Meshal Mubarak 84; Naser Kamil 83]
[Jan 4]
Taawun  1-0 Ittifaq
  [Hadi Al-Ghofrani 94]
[Apr 19]
Sadd    2-1 Rayyan
  [Karim Bagheri 12pen, 45; Algato 71pen]
Ahli    bye

Round 7 [Feb 4]
Ahli    0-0 Ittifaq  
Wakra   2-1 Arabi
  [Nayef Al-Khater 77, Al-Mirghani Al-Zein 89; Abdulaziz Kareem 55]
Taawun  0-1 Rayyan   
  [Jasem Al-Huwaidi 88]
Qatar   5-0 Sadd 
  [Yaser Nazmi 34, Fabrice Akwa 70, 83, 90, Hossein Ammouta 76]
Ittihad bye
 
Round 8 [Feb 7]
Taawun  2-1 Qatar
  [Ismail Ali 32, Rachid Roki 90; Abdulla Ali 82]
Ahli    2-1 Rayyan
  [Khaled Al-Mansoori 24, Meshal Abdulla 52; Abdulrahman Al-Kawari]
Ittihad 2-1 Arabi
  [Anthony Yeboah 9, 70; Sayed Bashir 39]
Wakra   2-2 Sadd
  [Al-Mirghani Al-Zein 41, Yousef Ashmi 81; Bu-Shieb El-Mbarki 45, John Otaka 59]
Ittifaq bye

Round 9
[Feb 14]
Qatar   0-1 Ahli
  [Yousef Munif]
Rayyan  2-0 Ittifaq
  [Jasem Al-Huwaidi 79pen, 83]
Taawun  2-1 Wakra   
  [Rachid Rouki 38, Abdulla Hassan 42; Ali Fartoos 48]
[Mar 4]
Ittihad 2-0 Sadd
  [Rasheed Omran 17, Anthony Yeboah 87]
Arabi   bye

Round 10
[Feb 28]
Taawun  0-1 Ittihad
  [Rasheed Omran 21]
Wakra   2-2 Ahli
  [Nayef Al-Khater 47pen, Soman Osman 57; Juma Moosa 31, Meshal Abdulla 84]
[Mar 1]
Sadd    3-3 Arabi
  [Ahmed Khalifa 13, Karim Bagheri 45, Jaffal Rashed 50; Naser Kameel 3,
   Abdulaziz Kareem 44, Sayedna Al-Basheer 67]
Qatar   2-1 Ittifaq
  [Hossein Ammouta 9, Fabrice Akwa 72; Rashed Al-Dosari 47]
Rayyan  bye

Round 11
[Mar 7]
Qatar   3-1 Rayyan
  [Hossein Amouta 1, 29, Abdulla Al-Hamad 8; Ali Rhama 71pen]
[Mar 8]
Ahli    1-2 Ittihad
  [Rachid Daouodi 41; Meshal Abdulla 38og, Yousef Adem 79]
[Apr 19]
Taawun  2-2 Arabi
  [Rinaldo 24, Nabil Anwar 73; Clayton 37, Naser Kameel 87]
[date?]
Ittifaq 3-0 Sadd
Wakra   bye

Round 12
[Mar 4]
Ahli    2-1 Arabi
  [Rachid El-Daouodi 14, 48pen; Naser Kameel 43]
[Mar 14]
Wakra   4-0 Rayyan
  [Yousef Ashmi 1, Sonah Osman 33, Mirghani Al-Zein 49, 79]
[Mar 15]
Ittihad 2-0 Ittifaq
  [Rashid Omran 5, Osvaldo 83]
[Apr 8]
Sadd    1-0 Taawun
  [Bouchaib El-Mbarki 26]
Ahli    bye 

Round 13
[Mar 21]
Wakra   1-3 Qatar
  [Soumah Osman 33; Wisam Rizq 51, Khamis Al-Muhannadi 53, Fabrice Akwa 55]
[Mar 22]
Ittihad 6-2 Rayyan
  [Midhat Mustafa 42, Mujib Hamed 45, 71, Ozvaldo 47, Saad Al-Shummeri 66,
   Anthony Yeboah 86; Ali Al-Murri 33, Fahad Al-Shummeri 77]
[Apr 8]
Arabi   3-0 Ittifaq 
  [Ahmed Fares 25, Clayton 38, Salman Essa 51]
[Apr 22]
Ahli    2-4 Sadd
  [Juma Moosa 15, 78; John Ottaka 13, 51, 94, Karim Bagheri 45pen]
Taawun  bye

Round 14
[Mar 7]
Wakra   2-1 Ittifaq
  [Yousef Ashami 17pen, Osman Samwah 49; Saad Al-Sheib 42]
[Mar 29]
Arabi   1-2 Rayyan
  [Clayton 50; Bashar Abdulla 12, Abdulsalam 57pen]
[Apr 12]
Ahli    1-4 Taawun
  [Rachid El-Daouodi 69pen; Rachid Roky 51, Nabil M. Anwar 55, Christiano 62,
   Ismail Ali 48pen] 
[Apr 19]
Ittihad 1-1 Qatar
  [Rachid Omran 20; Radhi Shenaishil 25pen]
Sadd    bye

Round 15
[Apr 4]
Ittifaq 1-1 Taawun
  [Rami Al-Zuabi 2; Rimaldo 74]
Arabi   3-2 Qatar
  [Mubarak Mustafa 19, 22, Naser Kameel 76pen; Radhi Shnaishil 74, Ahmed Fares 82og]
[Apr 5]
Wakra   1-2 Ittihad
  [Ali Qassim 78; Omran Rachid 29, 89]
Rayyan  3-2 Sadd
  [Elgato 3, 15, Adel Al-Mulla 86; Bouchaib El-Mbarki 48pen, 53]
Ahli    bye

Round 16 [Apr 15]
Arabi   3-1 Wakra
  [Mubarak Mustafa 18, Naser Kameel 53, 79; Ali Mejbel 90]
Ittifaq 1-5 Ahli
  [Mubarak Al-Kawari 83; Juma Moosa 8, Meshal Abdulla 35, 59, Bilal Abdulrahman 87,
   Walid Ali 91]
Rayyan  4-0 Taawun
  [Elgato 22, 56, Bashar Abdulla 39, 61]
Sadd    2-1 Qatar
  [Ahmed Khalifa 5, 79pen; Hossein Ammouta 70]
Ittihad bye

Round 17
[Apr 25]
Arabi   1-3 Ittihad
  [Salman Essa 76; Omran Rachid 12, 39, 63]
Qatar   3-0 Taawun
  [Abdulaziz Hassan 23pen, 85, Radhi Shnaishel 35pen]
[Apr 26]
Sadd    4-2 Wakra
  [Fahad Al-Kawari 40, John Ottaka 51, 73, 83; Mamoun Diop 19, 85]
Rayyan  4-0 Ahli
  [Elgato 45, Bashar Abdulla ?, 52, Mohammed Yaser ?]
Ittifaq bye

Round 18 [May 1]
Sadd    0-1 Ittihad   
  [Omran Rachid 62]
Wakra   3-3 Taawun
  [Ibrahim Salmeen 12, Ali M. Fatoos 80, Somah Osman 83;
   Hadi Al-Murri 11, Salem Salman 24, Ismail Ali 40]
Ittifaq 1-0 Rayyan
  [Saeed Rakbi 71]
Ahli    0-2 Qatar     
  [Jasem Al-Buainain 27, 54]
Arabi   bye

Final Table:

 1.Al Ittihad    16 13  2  1  42-18  41  [Doha-Gharrafa]   Champions
 2.Qatar SC      16  9  2  5  30-17  29  [Doha]        
 3.Al Rayyan     16  8  1  7  30-27  25  [Rayyan]
 4.Al Sadd       16  7  4  5  31-30  25  [Doha-al-Sadd]   
 5.Al Wakra      16  5  4  7  29-31  19  [Wakra]       
 6.Al Ahli       16  5  4  7  21-28  19  [Doha]
 7.Al Arabi      16  5  3  8  28-32  18  [Doha]
 8.Al Taawun     16  4  6  6  21-26  18  [Khor]
 9.Al Ittifaq    16  2  2 12  12-35   8  [Markheya]     

Promoted: Shamal

NB: league extended to 10 teams for 2002/03, no relegation



Author:
Mohammed Qayed
(mhqayed@hotmail.com)

Last updated: 30 Aug 2002

(C) Copyright Mohammed Qayed and RSSSF 2001/02


  USO DE MEMORIA  
4,239,296 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0024
Controller Execution Time ( Home / Category )  0.1041
Total Execution Time  0.1066
  CADENA URL  
/liga_catar2002
  GET DATOS  
$_GET['/liga_catar2002']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (37)  
0.0018  SELECT type FROM routes WHERE alias = 'liga_catar2002'
0.0038  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 = 2002 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=1 DESC LIMIT 1
0.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=312 AND type_rel = 3
0.0042  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 3 AND rel.typeId = 312 AND rel.ln = 'es' AND rel.status=1 ORDER BY rel.creation_date desc,rel.cover_points DESC LIMIT 5
0.0023  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 (1308681,1299995,1296424,1292802,1284241) ORDER BY n.cover_points DESC, update_date DESC
0.0020  SELECT text_es as historical_text FROM leagues_text WHERE id=1524
0.0020  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 = 29794 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0022  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='2002' WHERE c.parentId=312 GROUP BY c.id ORDER BY c.order_id ASC
0.0019  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-04-27 13:15:23' 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 13:15:23' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0030  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=4 AND last_update > '2024-04-27 13:15:23' 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=3 AND last_update > '2024-04-27 13:15:23' 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 = 2002 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=0 DESC LIMIT 1
0.0019  SELECT e.action, count(e.action) as total, e.player_id FROM events2002 e WHERE e.league_id IN (29794) 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.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 (29794) 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 events2002 e WHERE e.league_id IN (29794) 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 (29794) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN () ORDER BY rp.in_squad = 1 DESC
0.0021  SELECT e.action, count(e.action) as total, e.player_id FROM events2002 e WHERE e.league_id IN (29794) 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 (29794) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN () ORDER BY rp.in_squad = 1 DESC
0.0021  SELECT e.action, count(e.action) as total, e.player_id FROM events2002 e WHERE e.league_id IN (29794) 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 (29794) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN () ORDER BY rp.in_squad = 1 DESC
0.0018  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 = 29794 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 = 29794 AND rp.events > 0 ORDER BY rp.events DESC,p.pod DESC LIMIT 20
0.0023  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=29794 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 = 29794 AND esl.points > 0 ORDER BY esl.points DESC LIMIT 3
0.0020  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 = 29794 AND esl.points > 0
0.0020  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` = 29794 ORDER BY creation_date DESC LIMIT 0, 10
0.0024  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` = 29794
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 `calendars2002` 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` = 29794 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 `events2002` e INNER JOIN calendars2002 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 = 29794 ORDER BY total DESC LIMIT 40
0.0022  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 `events2002` e INNER JOIN calendars2002 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 = 29794 AND e.real_date > NOW() - INTERVAL 1 MONTH ORDER BY e.real_date DESC LIMIT 30
0.0024  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 `tables2002` 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 = 29794 AND t.round = 14 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0024  SELECT *,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables2002` 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 = 29794 AND t.round = 16 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0024  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 = 29794 ORDER BY c.shedule ASC, fcoef DESC LIMIT 5
0.0024  SELECT data1, data2 FROM services_tags WHERE categoryId=312
0.0024  SELECT l.year,l.group_code FROM leagues_besoccer l WHERE l.categoryId = 312 AND l.year = 2002 ORDER BY l.group_code ASC
0.0024  SELECT group_code, extraName from `leagues` WHERE categoryId=312 AND year=2002