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

Liga Jordania 2001

Información Histórica 
						
League Championship 2001


Round 1 [Aug 11]

Qadissiyyah 2-1 Shabab H
  [Oussama Al-Wahsh 9, Ammar Al-Sharayda 68; Khaled Nimr 59]
Hussein     3-1 Ahly
  [Shadi Al-Sharman 20, 55, Anas Al-Zaboun 90; Bassam Al-Khatib 37]
Wahadat     5-1 Kfarsoum
  [Morad Awayna 23, Sufian Abdullah 27, 50, Ashraf Shatat 39, Amer Zeeb 46;
   Abdulsalam Obaidat 15]
Faysali     5-0 Jazira
  [Jeries Tadros 16, 41, 83, Mohamed Al-Tawayha 78, Hatem Aql 93]
Ramtha      2-1 Baqa'a
  [Badran Al-Shaqran 46, Farid Al-Shanayna 83; Riyadh Al-Daqs 77]

Round 2 [Aug 18]

Wahadat     1-0 Faysali
  [Sufian Abdullah 90]
Ramtha      5-0 Qadissiyyah
  [Badran Al-Shaqran 34, 75, Khaled Qowayder 75, Ahmed Samara 83, 
   Farid Al-Shanayna 92]
Kfarsoum    0-2 Hussein
  [Ahmed Al-Eissawi 7, Abdullah Al-Shayyab 75]
[Aug 19]
Shabab H    1-0 Ahly
  [Ja'afar Amran 52]
Jazira      2-0 Baqa'a
  [Amer Aql 64, Ra'afat Jalal 75]

Round 3 [Aug 24]

Shabab H    0-3 Ramtha
  [Khaled Qowayder 32, Hisham Makhadmeh 48, Rami Samara 82]
Qadissiyyah 1-2 Jazira
  [Oussama Al-Wahsh 52; Mohannad Al-Ja'afari 66, Imad Hamdi 91]
Hussein     0-2 Faysali
  [Khaled Al-Khatib 55og, Mouayyed Salim 75]
[Aug 25]
Ahly        3-1 Kfarsoum
  [Ali Al-Zo'obi 40, 60, Nart Yedge 50; Shaman Obaidat 82]
Baqa'a      3-1 Wahadat
  [Jamal Al-Wahidi 38, 47, Moayyed Abou-Kishk 94; Ra'afat Ali 75]

Round 4 [Sep 7]

Wahadat     2-1 Ramtha
  [Fadi Lafi 77, Amer Deeb 90; Badran Al-Shaqran 31]
Hussein     2-1 Qadissiyyah
  [Hussein Alawneh 75, Abdullah Al-Shayyab 92; Mazen Shahine 18]
Jazira      1-1 Shabab H
  [Khaled Al-Khalayleh 24; Ghanem Hamarsha 31]
[Sep 8]
Faysali     2-1 Kfarsoum
  [Hatem Aql 59, Haytham Al-Shboul 74; Bakr Al-Sabouini 84]
Baqa'a      0-2 Ahly
  [Mohamed Al-Khawaja 22, Nart Yedge 60]

Round 5 [Sep 13]

Faysali     2-1 Ahly
  [Nader Jokhdar 36, 42; Ali Al-Zo'obi 46]
Baqa'a      4-2 Hussein
  [Jamal Al-Wahidi 19, 27, 45, Mustapha Shahda 71; Abdullah Al-Shayyab 64,
   Imad Abdullah 78]
Wahadat     3-0 Qadissiyyah 
  [Fadi Shahine 51, Ihab Ma'ali 53, Ra'afat Ali 60]
Ramtha      0-0 Jazira
Shabab H    1-0 Kfarsoum
  [Ghanem Hamarsha 82]

Round 6 [Sep 17]

Ahly        1-0 Qadissiyyah
  [Mohamed Al-Khawaja 60]
Ramtha      3-2 Hussein
  [Farid Al-Shanayna 14, Badran Al-Shaqran 37, Morad Al-Hourani 77;
   Anas Al-Zaboun 16, 22]
Kfarsoum    2-1 Baqa'a
  [Shaman Obaidat 34, Mouwaffaq Abou-Hadib 88; Jamal Al-Wahidi 94]
Faysali     2-1 Shabab H
  [Mohamed Al-Tawayha 13, 50; Maher Sarsour 10]
Jazira      0-5 Wahadat
  [Mahmoud Shilbaya 2, 13, Fadi Lafi 22, 72, Mounir Abou-Hantash 83]

Round 7 [Sep 21]

Wahadat     0-0 Shabab H
Hussein     2-1 Jazira
  [Hussein Alawneh 83, 90; Mohannad Al-Ja'afari 43]
Qadissiyyah 3-1 Kfarsoum
  [Oussama Al-Sarhan 7, 11, Oussama Al-Wahsh 84; Ibrahim Obaidat 38pen]
[Sep 22]
Ahly        1-2 Ramtha
  [Maahmoud Al-Hadid 16; Eissa Azaiza 43, 59]
Baqa'a      0-1 Faysali
  [Nader Jokhdar 63]

Round 8  [Sep 28]

Wahadat     4-0 Hussein
  [Fadi Lafi 5, Ali Juma'a 60, 88, Ra'afat Ali 75]
Ramtha      2-2 Kfarsoum
  [Ahmed Al-Dawood 22, Farid Al-Shanayna 80; Shaman Obaidat 20, 60]
Shabab H    1-1 Baqa'a
  [Ala'a Matawqa 17; Riyadh Al-Daqs 63]
[Sep 29]
Faysali     2-0 Qadissiyyah
  [Rateb Al-Awadat 75, Mohamed Mansour Al-Tawayha 76]
Jazira      0-0 Ahly

Round 9  [Oct 4]

Faysali     3-1 Ramtha
  [Mouayyed Salim 51, Nader Jokhdar 60, 65; Farid Al-Shanayna 37]
[Oct 5]
Hussein     2-0 Shabab H
  [Shadi Al-Sharman 57, Mohamed Showayter 65]
Baqa'a      2-0 Qadissiyyah
  [Mustapha Shahda 27, Mohamed Jamal 47]
[Oct 6]
Kfarsoum    3-1 Jazira
  [Shaman Obaidat 34, 75, Mowaffaq Abou-Hadib 55; Ra'afat Jalal 27]
Wahadat     4-0 Ahly
  [Ra'afat Ali 23, Ali Juma'a 28, Fadi Lafi 37, Mahmoud Shilbaya 46]

Round 10 [Oct 19]

Jazira      0-1 Faysali
  [Mouayyed Salim 15]
Shabab H    1-1 Qadissiyyah
  [Ala'a Maatalqa 69; Mazeh Shahine 36]
Kfarsoum    1-3 Wahadat
  [Ibrahim Obaidat 23; Mahmoud Shilbaya 15, Yanal Abaza 27, Amer Zeeb 89]
[Oct 20]
Baqa'a      4-3 Ramtha
  [Bashar Srour 12, Mohamed Al-Zamel 48, Riyadh Al-Daqs 84, Mustapha Shahda 87;
   Farid Al-Shanayna 61, Hossam Al-Dardour 65, 75]
Ahly        2-2 Hussein 
  [Ali Al-Zo'obi 56, Hatem Hani 63og; Abdullah Al-Shayyab 39, Anas Al-Zaboun 67]

Round 11 [Oct 26]

Hussein     1-1 Kfarsoum
  [Anas Al-Zaboun 66; Shaman Obaidat 52]
Ahly        0-2 Shabab H
  [Ra'afat Hammad 13, Ala'a Jaber 74]
[Oct 27]
Baqa'a      1-1 Jazira
  [Shatrat Al-Shatrat 41; Ra'afat Jalal 36]
Qadissiyyah 2-2 Ramtha
  [Dayan Saleh 40, Ammar Sharida 43; Badran Al-Shaqran 56, Eissa Azayza 90]
[Nov 6]
Faysali     1-0 Wahadat
  [Nader Jokhdar 90]

Round 12 [Nov 2]

Faysali     2-0 Hussein
  [Mohamed Al-Tawaba'a 14, Nader Jokhdar 65]
Ramtha      2-3 Shabab H
  [Badran Al-Shaqran 5, Eissa Azayza 85; Raed Asfour 42, Ghanem Hamarsha 49,
   Ala'a Mmatalqa 90]
Jazira      4-0 Qadissiyyah
  [Nidal Toufiq 42, Khaldoun Fahad 76, Mohannad Al-Ja'afari 89, Amer Aql 90]
[Nov 3]
Wahadat     2-0 Baqa'a
  [Sufian Abdullah 47, Fadi Lafi 90]
Kfarsoum    0-1 Ahly
  [Anzour Nafash 17]

Round 13 [Nov 9]

Jazira      0-1 Ramtha
  [Rami Samara 28]
Hussein     2-1 Baqa'a
  [Walid Al-Khalidi 16, Shadi Al-Sharman 65; Mouayyed Abou-Kishk 60]
[Nov 10]
Qadissiyyah 1-2 Wahadat
  [Issam Abou-Touq 23pen; Abdullah Abou Zama'a 27pen, Mahmoud Shilbaya 57]
Kfarsoum    1-7 Shabab H
  [Shaman Obaidat 42; Maher Sarsour 40, 44, 78, Ghanem Hamarsha 54, 90,
   Khaled Al-Nimr 72, 83]
[Nov 12]
Ahly        0-2 Faysali
  [Khaled Saad 44, Nader Jokhdar 90]

Round 14 [Nov 16]

Qadissiyyah 3-3 Hussein
  [Issam Abou-Touq 20, 73, Ammar Al-Sharayda 62; Shadi Al-Sharman 70,
   Hussein Alawneh 85, Abdullah Al-Shayyab 90]
Ahly        0-1 Baqa'a
  [Riyadh Al-Daqs 88]
[Nov 17]
Shabab H    1-1 Jazira
  [Khaled Al-Nimr 43; Abdulmalek Suwaylem 17]
Kfarsoum    0-1 Faysali
  [Mouayyed Salim 46pen]
[Nov 19]
Ramtha      1-3 Wahadat
  [Badran Al-Shaqran 71; Fadi Lafi 13, 90, Mahmoud Shilbaya 72]

Round 15 [Nov 23]

Wahadat     7-1 Jazira
  [Fadi Lafi 26, 29, 45, 86, Ali Juma'a 44, Mahmoud Shilbaya 83, 85;
   Khaldoun Fahad 65]
Hussein     1-0 Ramtha
  [Ekrami Metwalli 62]
Qadissiyyah 1-1 Ahly
  [Majdi Samara 90; Haytham Al-Basha 71]
[Nov 24]
Shabab H    1-3 Faysali
  [Maher Sarsour 24; Mohamed Al-Tawayha 3, 86, Hassouna Al-Sheikh 64]
Baqa'a      3-2 Kfarsoum
  [Mustapha Shahda 39, Bashar Srour 44, Riyadh Al-Daqs 63;
   Abdulsalam Obaidat 34, Mohamed Aloush 89]

Round 16 [Dec 1]

Shabab H    1-2 Wahadat 
  [Ali Asfour 45; Ra'afat Ali 50, Mahmoud Shilbaya 57]
Jazira      0-2 Hussein
  [Shadi Al-Sharman 6, Anas Al-Zaboun 68]
Kfarsoum    4-1 Qadissiyyah
  [Bakr Abwini 4, 88, 89, Shaman Obaidat 56; Ibrahim Obaidat 26og]
[Dec 2]
Ramtha      1-1 Ahly
  [Eissa Azaiza 38; Nart Yedge 10]
[Dec 10]
Faysali     2-0 Baqa'a
  [Nader Jokhdar, Mohamed Al-Tawayha]

Round 17 [Dec 7]

Baqa'a      1-1 Shabab H
  [Shatrat Al-Shatrat 6; Ghanem Hamarsha 36]
Qadissiyyah 0-2 Faysali
  [Nader Jokhdar 90, Hassouna Al-Sheikh 95]
Kfarsoum    2-3 Ramtha
  [Shaman Obaidat 12, Bakr Abwini 45; Rami Samara 44, 88, Hussein Al-Shanayna 86] 
[Dec 8]
Ahly        0-0 Jazira
Hussein     2-2 Wahadat
  [Shadi Al-Sharman 38, Hussein Alawneh 60; Ra'afat Ali 40, Sufian Abdullah 43]

Round 18 [Dec 13]

Shabab H    1-2 Hussein
  [Issam Abou-Hilala 28; Hussein Alawneh 18, Shadi Al-Sharman 56]
[Dec 14]
Ramtha      0-1 Faysali
  [Haytham Al-Shboul 20]
Ahly        2-5 Wahadat
  [Nart Yedge 24, Ra'afat Al-Fahoum 27; Fadi Lafi 3, 52, 73pen, 78,
   Abdullah Abou-Zama'a 4]
Qadissiyyah 0-1 Baqa'a
  [Mouayyed Abou-Khasham 89]
[Dec 20]
Jazira       -  Kfarsoum

Table:

 1.Al-Faysali        18 17  0  1  34- 6  51  Champions
 2.Al-Wahadat        18 14  2  2  51-15  44
 3.Al-Hussein        18  9  4  5  30-28  31
 4.Al-Ramtha         18  7  4  7  32-28  25
 5.Al-Baqa'a         18  7  3  8  24-26  24
 6.Shabab Al-Hussein 18  5  6  7  24-24  21
 7.Al-Ahly           18  4  5  9  16-27  17
 8.Al-Jazira         17  3  6  8  14-30  15
-------------------------------------------
 9.Kfarsoum          17  3  2 12  22-40  11  Relegated
10.Al-Qadissiyyah    18  2  4 12  16-39  10  Relegated



Author:
Mohamed S. Chbaro
(sp_editor@terra.net.lb)

Last updated: 2 Mar 2005

(C) Copyright Mohamed S. Chbaro and RSSSF 2001/05

INFORMACIÓN

La Primera División de Jordania (en inglés: Jordan League) es la máxima categoría de la Liga de fútbol de Jordania. Se disputa desde 1944. Está organizada por la Asociación Jordana de Fútbol.

  USO DE MEMORIA  
4,259,120 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0018
Controller Execution Time ( Home / Category )  0.1037
Total Execution Time  0.1055
  CADENA URL  
/liga_jordania2001
  GET DATOS  
$_GET['/liga_jordania2001']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (37)  
0.0018  SELECT type FROM routes WHERE alias = 'liga_jordania2001'
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_jordania' AND (l.group_code = 1 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 2001 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=314 AND type_rel = 3
0.0021  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 3 AND rel.typeId = 314 AND rel.ln = 'es' AND rel.status=1 ORDER BY rel.creation_date desc,rel.cover_points DESC LIMIT 5
0.0021  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 (1066445,774393,672311) ORDER BY n.cover_points DESC, update_date DESC
0.0019  SELECT text_es as historical_text FROM leagues_text WHERE id=2215
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 = 30469 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0019  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='2001' WHERE c.parentId=314 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-30 20:58:01' 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-30 20:58:01' 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=4 AND last_update > '2024-04-30 20:58:01' 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-30 20:58:01' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0022  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'liga_jordania' AND (l.group_code = 0 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 2001 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 events2001 e WHERE e.league_id IN (30469) 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 (30469) 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 events2001 e WHERE e.league_id IN (30469) AND (e.action IN (4,5) ) GROUP BY e.player_id ORDER BY total DESC, e.player_id ASC LIMIT 20
0.0082  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 (30469) 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 events2001 e WHERE e.league_id IN (30469) AND (e.action IN (3,4) ) 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 (30469) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN () ORDER BY rp.in_squad = 1 DESC
0.0020  SELECT e.action, count(e.action) as total, e.player_id FROM events2001 e WHERE e.league_id IN (30469) AND (e.action IN (22) ) 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 (30469) 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 = 30469 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 = 30469 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=30469 AND rel.round=18
0.0020  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 = 30469 AND esl.points > 0 ORDER BY esl.points DESC LIMIT 3
0.0026  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 = 30469 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-31" AND c.`active`= 1 and c.comment_id is null and c.lang = 1 AND l.`id` = 30469 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-31" AND c.`active`= 1 and comment_id is null and c.lang = 1 AND l.`id` = 30469
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 `calendars2001` 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` = 30469 AND c.`round` = 18 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 `events2001` e INNER JOIN calendars2001 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 = 30469 ORDER BY total DESC LIMIT 40
0.0021  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 `events2001` e INNER JOIN calendars2001 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 = 30469 AND e.real_date > NOW() - INTERVAL 1 MONTH ORDER BY e.real_date DESC LIMIT 30
0.0021  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 `tables2001` 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 = 30469 AND t.round = 16 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0021  SELECT *,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables2001` 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 = 30469 AND t.round = 18 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0021  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-30 00:00:00' AND c.`shedule` < '2024-05-04 23:59:59' AND l.id = 30469 ORDER BY c.shedule ASC, fcoef DESC LIMIT 5
0.0021  SELECT data1, data2 FROM services_tags WHERE categoryId=314
0.0021  SELECT l.year,l.group_code FROM leagues_besoccer l WHERE l.categoryId = 314 AND l.year = 2001 ORDER BY l.group_code ASC
0.0021  SELECT group_code, extraName from `leagues` WHERE categoryId=314 AND year=2001