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

Liga Catar 2003

Información Histórica 
						

Round 1 [Nov 1]
Al-Arabi    1-3 Al-Ahli
  [Zoubeir Beya 16; Carlos Pedro 44, Yousef Munif 50, Walid Jasem ?]
Rayyan      3-0 Shamal
  [Ali Al-Merri 15, Abdulrahman Al-Kawari 65, Alou Mabika 68]
Al-Ittifaq  0-2 Qatar        
  [Juma Moosa 68, 83]
Al-Ittihad  2-0 Wakra
  [Osvaldo Fernández 15pen, Adel Khamis 90]
Sadd        1-1 Khor
  [Boushaib Lembarki 49; Rachid Roki 58]

Round 2
[Nov 7]
Al-Arabi    0-1 Rayyan   
  [Adel Lami 57]
Wakra       0-1 Qatar    
  [Fabrice Akwa 22]
[Nov 8]
Shamal      3-3 Al-Ittihad
  [Zeyad Al-Abd 53, Ahmed Abduljabbar 55, Hisham Redha 72; Mustafa Adem 39,
   Fehaid Al-Shemmari 47, Emad Mohammed 71]
Sadd        5-0 Al-Ittifaq
  [Masoud Ghanem 7, Boushaib Lembarki 27, Abdulkader Keita 45, 79,
   Ahmed Khalifa 56]
Al-Ahli     1-0 Khor
  [Abdulla Jasem 33]

Round 3
[Nov 14]
Qatar       0-0 Al-Ahli  
[Nov 15]
Al-Arabi    1-0 Al-Ittifaq
  [Mostafa Mubarak 39]
Khor        2-0 Shamal   
  [Ismail Ali 15, Hassan Abdulrazzaq 92]
Al-Ittihad  1-1 Rayyan
  [Algato 65; Ali Al-Merri 52pen]
[Nov 24]
Sadd        2-1 Wakra  
  [Bou-Shouaib Mbarki 37, Hani Al-Dhabet 92; Mirghani Al-Zein 7]

Round 4
[Nov 28]
Khor        1-0 Al-Arabi
  [Rachid Roki 65]
Al-Ittihad  1-1 Al-Ittifaq
  [Mostafa Adem 73; Johnson 52]
[Nov 29]
Rayyan      0-1 Qatar
  [Abdulaziz Hassan 84]
Al-Ahli     0-1 Wakra
  [Ali Qassem 79]
[Dec 16]
Sadd        4-0 Shamal
  [Abdelkader Keita 37, 90, Soud Ghanem 75, Ahmed Khalifa 78]

Round 5
[Dec 7]
Khor        3-2 Qatar
  [El-Mahdi Azzami 34, 78, Rachid Roki 45; Wisam Rizq 32, Fabrice Akwa 50]
Al-Arabi    1-0 Wakra
  [Ronaldo Rosa 40]
Shamal      3-2 Al-Ittifaq
  [Hashim Redha 24, 84, Sobhi Adel 66; Mubarak Al-Kawari 34, Mousa Dano 42]
[Dec 8]
Al-Ahli     2-1 Rayyan
  [Waheed Mohammed 5, Kalou 54; Alouma Bika 62]
Sadd        3-1 Al-Ittihad
  [Abdulkader Keita 2, Bushaib El-Mbarki 5, Mohammed Ghulam 83; Mujeeb Hamed 8]

Round 6
[Dec 19]
Shamal      0-0 Wakra    
Al-Ittihad  2-0 Khor
  [Elato 77, Makai Kouni 91]
[Dec 20]
Al-Arabi    1-1 Qatar
  [Walid Hamza 70; Fabrice Akwa 55]
Sadd        1-2 Rayyan
  [Ahmed Khalifa 28pen; Anderson 8pen, Abdelhafiz Tisfaout 54]
Al-Ahli     1-0 Al-Ittifaq
  [Carlos Pedro 77]
   
Round 7
[Dec 26]
Al-Ittihad  0-1 Al-Ahli      
  [Carlos Pedro 45]
Shamal      1-2 Al-Arabi
  [Hashem Redha 2; Ahmed Fares 40, Abdulnaser Al-Obaidli 90]
[Dec 27]
Rayyan      2-0 Al-Ittifaq
  [Anderson Selvani 14, Abdelhafiz Tisfaout 60]
Khor        2-1 Wakra
  [Hussain Al-Merri 84, Al-Mahdi Al-Arafi 90; Romeo Kambou 38]
Sadd        1-2 Qatar
  [Abdulkader Keita 49; Mohammed Zeyara 9, Juma Mousa 85]
 
Round 8 
[Jan 2]
Al-Ahli     2-0 Shamal
  [Abdullah Jasem 6, Carlos Pedro 30]
Rayyan      4-2 Wakra
  [Alouma Bika 39, Anderson 55, Abdelhafiz Tisfaout 58, 68; John 6,
   Osman Souma 16]
[Jan 3]
Sadd        1-0 Al-Arabi
  [Abdulkader Keita 68]
Qatar       1-1 Al-Ittihad
  [Abdulaziz Hassan 81; Elgato 24]
Khor        4-2 Al-Ittifaq
  [Ismail Ali 35, Hadi Al-Merri 48, Rachid Rouki 51, 87;
   Mubarak Al-Kawari 30, Ali Al-Mansoori 58]

Round 9 [Jan 9]
Al-Ahli     0-0 Sadd       
Al-Ittifaq  0-4 Wakra       
  [Ali Qassem 31, Soumah Osman 40, Romeo Kambou 45, Hussain Fardhullah 65]
Rayyan      0-3 Khor       
  [Arrafi 69, Rachid Rouki 88, 92]
Al-Arabi    2-2 Al-Ittihad
  [Adel Al-Mulla 58, Sayed Al-Basheer 68; Mujeeb Hamed 39, Naser Kameel 80]
Shamal      0-2 Qatar
  [Fabrice Akwa 39, 45]

Round 10
[Jan 30]
Al-Ahli     2-2 Al-Arabi
  [Kalou 5, Youses Ali 32; Mohammed Armoumin 9, 40]
Shamal      1-1 Rayyan
  [Haroon Jamea 33; Badr Al-Zaman 26]
[Jan 31]
Khor        0-1 Sadd   
  [Mohammed Ghulam 19]
Wakra       2-2 Al-Ittihad
  [Jasem Al-Tamimi 45pen, 82pen; Elgato 62pen, Bakari Kouni 69]
[Mar 3]
Qatar       4-0 Al-Ittifaq 
  [Fabrice Akwa 41, 54, 69, Saeed Sheiba 45]

Round 11
[Feb 6]
Khor        2-1 Al-Ahli
  [Rachid Rouky 24, El-Mahdy Arrafy 45; Meshal Abdullah 77pen]
Al-Arabi    4-1 Rayyan
  [Salah Al-Mulla 3, Abdulaziz Karim 17, Armoumen 24, 49; Anderson 59]
[Feb 7]
Sadd        1-0 Al-Ittifaq
  [Zamel Al-Kawari 77)]
Al-Ittihad  1-1 Shamal
  [Saad Al-Shammari 72; Haroon Jamea 91]
[Mar 10]
Qatar       0-1 Wakra
  [Ali Qassem 77]

Round 12 [Feb 13]
Sadd        1-0 Wakra
  [Abdelkader Keita 71]
Khor        2-2 Shamal
  [Hadi Al-Merri 3, Rachid Rouki 70; Qadr Moosa 51pen, Hashem Redha 80pen]
Al-Ittifaq  0-2 Al-Arabi
  [Salah Ismail 7, Armoumen 72]
Rayyan      0-1 Al-Ittihad  
  [Baki 13]
Al-Ahli     1-1 Qatar
  [Carlos Pedro 38; Fabrice Akwa 24]

Round 13
[Feb 27]
Shamal      1-6 Sadd
  [Heidar Mahmood 66; Zamel Al-Kawari 35, Abdelkader Keita 37, 62, 76,
   Fahad Al-Kawari 60, Soud Ghanem 82]
Qatar       1-0 Rayyan
  [Fabrice Akwa 70]
[Feb 28]
Al-Arabi    0-2 Khor        
  [Rachid Roki 12, Abdulla Hassan 63]
Al-Ittifaq  1-2 Al-Ittihad
  [Walid Mohammed 45; Naser Kameel 49, Osvaldo Fernández 82pen]
Wakra       1-0 Al-Ahli
  [Ali Salem 25]

Round 14
[Feb 3]
Sadd        1-1 Al-Ittihad
  [Abdelgader Keita 85; Elgato 65]
[Mar 6]
Khor        0-0 Qatar  
Wakra       2-0 Al-Arabi
  [Mohammed Qassem 41, Adel Darwish 79]
[Mar 7]
Rayyan      1-0 Al-Ahli
  [Victor Aristizabal 53]
[Mar 23]
Al-Ittifaq  1-1 Shamal    
  [Johnson 39; Heidar Mahmood 90]

Round 15 
[Mar 4]
Rayyan      1-0 Sadd
  [Abdelhafiz Tisfaout 82]
[Mar 13]
Al-Ittifaq  1-2 Al-Ahli
  [Louis Zika 67; Carlos Pedro 57pen, Ali Al-Malki 74og]
[Mar 14]
Wakra       0-1 Shamal   
  [Ahmed Abduljabbar 91]
Qatar       3-1 Al-Arabi
  [Saeed Sheiba 45, Fabrice Akwa 79, Abdulaziz Hassan 83; Mubarak Mustafa 18]
[Mar 23]
Khor        1-1 Al-Ittihad
  [Rachid Rouki 13pen; Osvaldo Fernández 78pen]

Round 16 [Mar 27]
Qatar       1-0 Al-Sadd 
  [Fabrice Akwa 40]
Wakra       2-1 Khor
  [Romeo Kambou 85, Ali Mejbel 93; Rachid Rouki 91]
Al-Ahli     1-3 Al-Ittihad
  [Johnson Kabore 89; Cristián Montecinos 7, 63, 70]  
Al-Ittifaq  1-1 Rayyan      
  [Walid Mohyeddin 73; Abdelhafiz Tisfaout 62]
Al-Arabi    1-2 Shamal
  [Mohammed Armoumen 55; Hashem Redha 2, Qadr Moosa 75]

Round 17 [Mar 31]
Al-Ittihad  1-0 Qatar
  [Cristián Montecinos 81pen]
Khor        2-1 Al-Ittifaq
  [Rachid Rouki 43, 68; Saleh Awadh 80]
Al-Arabi    2-1 Sadd
  [Abdulaziz Karim 5, Mohammed S. Al-Mal 60; Mohammed Ghulam 75]
Al-Ahli     3-1 Shamal
  [Abdullah Jasem 39, Johnson Kabore 69, Walid Jasem 90; Hashem Redha 6]
Rayyan      2-2 Wakra
  [Abdulrahim Al-Kawari 28, Victor Aristizabal 85; Romeo Kambou 39, 45]

Round 18 [Apr 4]
Qatar       2-0 Shamal
  [Abdulaziz Hassan 50, 72]
Al-Arabi    3-4 Al-Ittihad
  [Sayed Al-Baseeir 11, 19, 63; Naser Kameel 29, Cristián Montecinos 64,
   Osvaldo Fernández 75pen, 84pen]
Khor        2-3 Rayyan 
  [Hadi Al-Merri 54, Rachid Rouki 90pen; Victor Aristizabal 43,
   Mohammed Yaser 62, Abdelhafiz Tisfaout 68]
Wakra       1-0 Al-Ittifaq
  [Romeo Kambou 55]
Sadd        1-1 Al-Ahli
  [Abdullah Kooni 36; Johnson Kabore 13]

Final Table:

 1.Qatar SC      18 10  5  3  24-10  34  Champions  [Doha]  
 2.Al-Sadd       18  9  4  5  30-14  31  [Doha-al-Sadd]    
 3.Khor          18  9  4  5  28-20  31  [*]  [Khor]
 4.Al-Ittihad    18  7  9  2  29-22  30  [Doha-Gharrafa]
 5.Al-Ahli       18  8  5  5  21-16  29  [Doha]     
 6.Al-Rayyan     18  8  4  6  24-22  28  [Rayyan]
 7.Al-Wakra      18  7  3  8  20-19  24  [Wakra]
 8.Al-Arabi      18  6  3  9  23-27  21  [Doha]
 9.Shamal	 18  3  6  9  17-37  15
---------------------------------------
10.Al-Ittifaq    18  0  3 15  10-39   3  Relegated  [Markheya]

[*] Al-Taawun changed name to Khor



Author:
Mohammed Qayed
(mhqayed@hotmail.com)

Last updated: 22 Oct 2003

(C) Copyright Mohammed Qayed and RSSSF 2002/03


  USO DE MEMORIA  
4,233,440 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0020
Controller Execution Time ( Home / Category )  0.0720
Total Execution Time  0.0741
  CADENA URL  
/liga_catar2003
  GET DATOS  
$_GET['/liga_catar2003']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (23)  
0.0018  SELECT type FROM routes WHERE alias = 'liga_catar2003'
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 = 2003 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=1 DESC LIMIT 1
0.0020  SELECT text_es as historical_text FROM leagues_text WHERE id=1520
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 = 29790 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0021  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=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 10:08:17' 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 10:08:17' 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 10:08:17' 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 10:08:17' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0023  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 = 2003 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=0 DESC LIMIT 1
0.0019  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=29790 AND rel.round=18
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 = 29790 AND esl.points > 0 ORDER BY esl.points DESC LIMIT 3
0.0019  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 = 29790 AND esl.points > 0
0.0018  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` = 29790 ORDER BY creation_date DESC LIMIT 0, 10
0.0022  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` = 29790
0.0023  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` = 29790 AND c.`round` = 18 ORDER BY shedule ASC LIMIT 200
0.0020  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 = 18 AND e.real_date IS NOT NULL AND e.league_id = 29790 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 `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 = 29790 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 `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 = 29790 AND t.round = 16 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0019  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 = 29790 AND t.round = 18 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0017  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 = 29790 ORDER BY c.shedule ASC, fcoef DESC LIMIT 5
0.0026  SELECT data1, data2 FROM services_tags WHERE categoryId=312
0.0026  SELECT group_code, extraName from `leagues` WHERE categoryId=312 AND year=2003