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

Liga Jordania 2000

Información Histórica 
						
Round 1 [Aug 18]

Wahadat     1-0 Jazira
  [Mahmoud Shilbaya 59]
Fahis       1-3 Shabab H
  [Mohamed Hindawi 74; Maher Sarsour 35, Issam Abou-Hilal 42, Ghanem Hamarsha 86]
Sahab       0-2 Hussein 
  [Khaled Khatatba 25, Abdulah Al-Shayyab 45pen]
Ahly        2-1 Qadissiyyah
  [Bassam Al-Khatib 65, Nart Yedge 75; Oussama Al-Wahsh 3]
[Oct 23]
Faysali     2-1 Ramtha
  [Jeries Tadros 23, 73; Adel Abou-Hadib 36]

Round 2 [Aug 25]

Jazira      2-2 Shabab H
  [Ali Aqla 79, Mohannad Al-Ja'afari 86pen; Amjad Al-Shoaybi 19, Maher Sarsour 66]
Fahis       1-5 Qadissiyyah
  [Mohamed Al-Hindawi 70; Oussama Al-Wahsh 15, 81, Mazen Shahine 22, Oussama Sarhan 59, 
   Ala'a Jawdat 87]
[Oct 23]
Hussein     0-3 Wahadat
  [Ali Juma'a 33, Sufian Abdullah 72, Awad Ragheb 88]
[Nov 8]
Sahab       2-1 Ramtha
  [Majed Fahad 9, Mohamed Al-Ashhab 85; Hossam Al-Dardour 64]
Ahly        0-2 Faysali
  [Jeries Tadros 15, Qossai Abou-Alyeh 17]

Round 3 [Sep 1]

Wahadat     2-1 Ramtha
  [Sufian Abdullah 12, Morad Awayna 33; Khaled Qowayder 20]
Hussein     5-0 Jazira
  [Anas Al-Saboun 25, 31, 90, Mohamed Balas 35, Shadi Moshen 44]
Shabab H    1-2 Qadissiyyah
  [Amjad Al-Shuaybai 6pen; Mahmoud Abdullah 60, Oussama Al-Wahsh 63]
Sahab       2-3 Ahly
  [Abdulhadi Mohamed 1, Mohamed Qandil 64; Bassam Al-Khatib 19, 60, 86]
[Nov 10]
Fahis       0-4 Al-Faysali
  [Hassouna Al-Sheikh 35, 65, 84, Haytham Al-Shboul 61]

Round 4 [Sep 8]

Jazira      1-1 Qadissiyyah
  [Khalil Fatafta 90; Khaled Lotfi 12]
[Sep 9]
Fahis       0-1 Sahab
  [Mohamed Qandil 14]
[Nov 10]
Hussein     1-4 Ramtha
  [Mohamed Malas 35; Rami Samara 14, Leith Al-Dardour 34,
   Badran Al-Shaqran 79, 88pen]
[Nov 14]
Shabab H    0-3 Faysali
  [Jeries Tadros 35, 76pen, Sobhi Suleyman 78]
[Nov 30]
Wahadat     4-0 Ahly
  [Haytham Samerrine 7, Awadh Ragheb 30, Sufian Abdullah 43, Ra'afat Ali 76]

Round 5 [Sep 15]

Ramtha      3-2 Jazira
  [Ali Eissa 53, Khaled Ziabat 64, Hossam Al-Dardour 67; Mohannad Al-Ja'afari 17,
   Khalil Fatafta (42]
Ahly        0-1 Hussein
  [Shadi Abou-Humaid 81]
Shabab H    1-1 Sahab
  [Maher Sarsour 44; Abdulhadi Al-Maharqa 56]
Wahadat     4-2 Fahis
  [Haytham Samerrine 62, Ragheb Awad 70, Mahmoud Shilbaya 78, Ra'afat Ali 84;
   Mohamed Al-Hindawi 58, Joseph Hatar 80]
Qadissiyyah 0-2 Faysali
  [Sobhi Suleyman 35, Haytham Al-Shboul 88]

Round 6 [Sep 22]

Jazira      0-4 Faysali
  [Jeries Tadros 27pen, 29, 89, Mohamed Mansour Al-Tawayha 45]
Ahly        1-4 Ramtha
  [Mahmoud Al-Hadid 33; Khaled Ziabat 6, Rami Samara 25, Hossam Al-Dardour 31, 44]
Hussein     1-2 Fahis
  [Walid Al-Khalidi 62; Mohamed Al-Hindawi 20, Joseph Hatar 86pen]
Shabab H    0-5 Wahadat
  [Amer Zib 15, Sufian Abdullah 25, Awadh Ragheb 30, 80, 87]
Qadissiyyah 3-2 Sahab
  [Ismail Al-Awadat 36, Ammar Al-Sharayda 41, Eyhab Ma'ali 60; Mohamed Al-Ashhab 15,
   Majed Fahad 90]

Round 7 [Oct 13]

Jazira      1-1 Ahly
  [Mohannad Al-Ja'afari 45pen; Mohamed Al-Khawaja 55]
Faysali     5-0 Sahab
  [Hassouna Al-Sheikh 33, 58, Jeries Tadros 36, 76, Jamal Abou-Abed 70]
Ramtha      0-2 Fahis
  [Khodor Mubarak 13, Mouwaffaq Al-Ayyadi 50]
Qadissiyyah 0-3 Wahadat
  [Haytham Samerrine 73pen, Hisham Abdulmonhem 74, Sufian Abdullah 85]
Shabab H    1-2 Hussein
  [Maher Al-Sarsour 85; Khaled Khatatba 31, Abdullah Al-Shayyab 87]

Round 8 [Oct 31]

Hussein     2-0 Qadissiyyah
  [Khaled Khatatba 43, 90]
Ahly        3-1 Fahis
  [Bassam Al-Khatib 65, Nader Shukri 81, Nart Yedge 88; Youssouf Awad 11]
Jazira      1-0 Sahab
  [Mohamed Al-Azzazi 78]
Shabab H    3-1 Ramtha
  [Ghanem Hamarsha 59, 68pen, 82pen; Farid Al-Shanayna 88]
[Dec 6]
Faysali     2-0 Wahadat
  [Jeries Tadros 11, 22]

Round 9  [Nov 4]

Ahly        4-2 Shabab H
  [Nart Yedge 21, Bassam Al-Khatib 45pen, 56, Moussa Shatian 62; Maher Al-Sarsour 79, 81]
Ramtha      2-1 Qadissiyyah
  [Farid Al-Shanayna 17, 87; Mahmoud Abdullah 79]
Jazira      2-0 Fahis
  [Khaled Al-Khalayla 29, 63]
Faysali     6-0 Hussein
  [Mohamed Al-Tawayha 5, Hassouna Al-Sheikh 33, Jeries Tadros 35, 80, Moayyed Salim 65, 90]
[Dec 13]
Sahab       1-2 Wahadat
  [Majed Qandil 83; Mahmoud Shilbaya 22, Haytham Samerrine 37pen]

Round 10 [Nov 17]

Faysali     1-0 Ramtha
  [Haytham Al-Shboul 77]
Hussein     2-2 Sahab
  [Aref Hussein 20, Khaled Al-Khatatba 77; Mohamed Qandil 46, Mohamed Fahad 70]
Shabab H    5-0 Fahis
  [Ghanem Hamarsha 7, 33, Maher Sarsour 47, 81, 83]
Qadissiyyah 0-1 Ahly
  [Nart Yedge 13]
[Dec 18]
Wahadat     2-3 Jazira
  [Sufian Abdullah 14, 33; Mohannad Al-Ja'afari 38, Khaled Al-Khalayla 67, 88]

Round 11 [Nov 20]

Faysali     4-0 Ahly
  [Hassouna Al-Sheikh 17, 73, 74, Moayyed Salim 65]
Shabab H    1-1 Jazira
  [Ghanem Hamarsha 49pen; Mohannad Al-Ja'afari 77pen]
Qadissiyyah 2-2 Fahis
  [Mazen Shahine 34, Khaled Lafi 44; Mohamed Al-Safdawi 16, Ghaith Hamarsha 62]
Ramtha      2-1 Sahab
  [Badran Al-Shaqran 21, 45; Majed Fahad 30]
[Dec 20]
Wahadat     4-2 Hussein
  [Hisham Abdulmonhem 14, 35, Ali Juma'a 72, Awadh Ragheb 83; Abdullah Shayyab 52,
   Khaled Khatatba 90]

Round 12  [Nov 24]

Faysali     4-0 Fahis 
  [Hassouna Al-Sheikh 12, 61, Moayyed Salim 38, 43]
Jazira      3-4 Hussein
  [Amer Aql 18, 44, Mohannad Al-Ja'afari 90pen; Khaled Al-Khatatba 4, 10, 88,
   Hussein Alawna 13]
Ahly        4-3 Sahab
  [Bassam Al-Khatib 15, 87, Anzour Nafash 35, Moussa Shetyan 83; 
   Mohamed Awda 4, 55, Salem Fahad 33]
Qadissiyyah 3-6 Shabab H
  [Mazen Shahine 29, 47, Issam Abou-Touq 69; Ghanem Hamarsha 35, 37, 89, 90,
   Ala'a Matalqa 40, Khaled Nimr 49]
[Dec 22]
Ramtha      0-0 Wahadat

Round 13 [Nov 27]

Qadissiyyah 1-1 Jazira
  [Ra'afat Jalal 70; Oussama Al-Wahsh 20]
Ramtha      1-1 Hussein
  [Badran Al-Shaqran 10; Mohamed Balas 90]
Ahly        0-3 Wahadat
  [Ali Juma'a 61, 75, Haytham Samerrine 71]
[Nov 28]
Faysali     7-0 Shabab H
  [Jeries Tadros 25, 45, 47, 52pen, 88, Moayyed Salim 40, Hatem Aql 86]
Sahab       1-2 Fahis
  [Majed Fahad 43; Ghaith Hamarsha 57, Zayed Al-Majali 89]

Round 14 [Dec 1]

Faysali     2-1 Qadissiyyah
  [Hassouna Al-Sheikh 75, Mohannad Mahadin 92; Issam Abou-Toq 83]
Fahis       1-4 Wahadat
  [Joseph Hatar 46; Sufian Abdullah 10, 37, Adnan Al-Tawil 76, Ragheb Awadh 91]
Sahab       0-3 Shabab H
  [Amjad Al-Shaybi 35, 69, Maher Sarsour 79]
[Dec 2]
Jazira      1-2 Ramtha
  [Ja'afar Amran 45; Hossam Al-Dardour 51, Badran Al-Shaqran 71]
Hussein     0-1 Ahly
  [Mahmoud Al-Hadid 45]

Round 15 [Dec 4]

Faysali     1-0 Jazira
  [Moayyed Salim 33]
Wahadat     4-0 Shabab H
  [Awadh Ragheb 7, Ra'afat Ali 20, Sufian Abdullah 55, 79]
Ramtha      0-1 Ahly
  [Mahmoud Al-Hadid 11]
[Dec 5]
Sahab       1-1 Qadissiyyah
  [Majed Fahad 3; Khaled Lafi 37]
Fahis       1-3 Hussein
  [Joseph Hatar 15pen; Walid Al-Khalidi 54, Aref Hussein 78, Husein Alawna 90]

Round 16 [Dec 8]

Ahly        1-0 Jazira
  [Anzour Nafash 40] 
Sahab       0-2 Faysali
  [Hatem Aqel 8, Jeries Tadros 53]
Wahadat     6-0 Qadissiyyah
  [Mahmoud Shilbaya 15, 40, 50, Haytham Samerrine 37pen, Ali Juma'a 44,
   Ismail Al-Awadat 57og]
[Dec 9]
Fahis       1-3 Ramtha
  [Mohamed Al-Hindawi 71; Badran Al-Shaqran 41pen, 59, Adel Abou-Hadib 87]
Hussein     1-0 Shabab H
  [Khaled Al-Khatatba 73]

Round 17 [Dec 11]

Sahab       2-2 Jazira
  [Mohamed Al-Ashhab 63pen, Mohamed Awda 90; Mohannad Al-Ja'afari 42, 69]
Wahadat     0-0 Faysali
Fahis       1-3 Ahly
  [Joseph Heter 52pen; Mahmoud Al-Hadid 35, 57, Nart Yedge 60]
[Dec 12]
Qadissiyyah 2-1 Hussein
  [Ismail Awadat 14, Issam Abou-Touq 90; Khaled Khatatba 9]
Ramtha      2-3 Shabab H
  [Badran Al-Shaqran 37, Farid Al-Shanayna 87; Maher Sarsour 33, Ghanem Hamarsha 43,
   Khaled Al-Nimr 45]

Round 18 [Dec 15]

Wahadat     4-1 Sahab
  [Ghayyath Al-Tamimi 10, Sufian Abdullah 16, Mahmoud Shilbaya 72, Ali Juma'a 90pen;
   Anas Sabrah 90]
Fahis       1-0 Jazira
  [Nasser Toufiq 35]
Hussein     1-4 Faysali
  [Khaled Al-Khatatba 71; Jeries Tadros 8, 25, 84, Haytham Al-Shboul 36]
[Dec 16]
Qadissiyyah 0-2 Ramtha
  [Leith Al-Dardour 71, Hussein Al-Shanayna 89]
Shabab H    0-3 Ahly
  [Mahmoud Al-Hadid 18, 25, Mohamed Badawi 82]

Final Table:

 1.Al Faysali        18 17  1  0  55- 3  52  Champions
 2.Al Wahadat        18 14  2  2  51-13  44
 3.Al Ahly           18 11  1  6  28-29  34
 4.Al Ramtha         18  8  2  8  29-25  26
 5.Al Hussein        18  8  2  8  29-34  26
 6.Shabab Al-Hussein 18  6  3  9  31-42  21
 7.Al Qadissiyyah    18  4  4 10  23-38  16
 8.Al Jazira         18  3  6  9  20-32  15
-------------------------------------------
 9.Al Fahis          18  4  1 13  18-48  13  Relegated
10.Sahab             18  2  4 12  20-40  10  Relegated
 
Promoted: Kfarsoum, Al Baqa'a

Topscorers:

23 Jeries Tadros (Faysali)
12 Sufian Abdullah (Wahadat)
   Ghanem Hamarsha (Shabab H)
   Hassouna Al-Sheikh (Faysali)
11 Khaled Khatatba (Hussein)
   Maher Sarsour (Shabab H)

Authors:
Mohamed S. Chbaro
(mochbaro@intracom.net.lb)
and Mohammed Qayed
(mhqayed@emirates.net.ae)

Last updated: 17 Aug 2001

(C) Copyright Mohamed S. Chbaro, Mohammed Qayed and RSSSF 2000/01

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,258,584 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0032
Controller Execution Time ( Home / Category )  0.5936
Total Execution Time  0.5968
  CADENA URL  
/liga_jordania2000
  GET DATOS  
$_GET['/liga_jordania2000']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (38)  
0.0125  SELECT type FROM routes WHERE alias = 'liga_jordania2000'
0.0253  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 = 2000 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=1 DESC LIMIT 1
0.0125  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=314 AND type_rel = 3
0.0129  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.0127  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.0126  SELECT text_es as historical_text FROM leagues_text WHERE id=2220
0.0125  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 = 30474 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0126  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=314 GROUP BY c.id ORDER BY c.order_id ASC
0.0125  SELECT type,rule FROM rules WHERE categoryId = 314 ORDER BY type = 'tables_draw' DESC,type != 'extra' DESC, `order` ASC
0.0125  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-04-30 18:12:36' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0125  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=2 AND last_update > '2024-04-30 18:12:36' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0125  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=4 AND last_update > '2024-04-30 18:12:36' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0125  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=3 AND last_update > '2024-04-30 18:12:36' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0254  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 = 2000 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=0 DESC LIMIT 1
0.0126  SELECT e.action, count(e.action) as total, e.player_id FROM events2000 e WHERE e.league_id IN (30474) 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.0127  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 (30474) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN () ORDER BY rp.in_squad = 1 DESC
0.0125  SELECT e.action, count(e.action) as total, e.player_id FROM events2000 e WHERE e.league_id IN (30474) AND (e.action IN (4,5) ) GROUP BY e.player_id ORDER BY total DESC, e.player_id ASC LIMIT 20
0.0125  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 (30474) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN () ORDER BY rp.in_squad = 1 DESC
0.0126  SELECT e.action, count(e.action) as total, e.player_id FROM events2000 e WHERE e.league_id IN (30474) AND (e.action IN (3,4) ) GROUP BY e.player_id ORDER BY total DESC, e.player_id ASC LIMIT 20
0.0126  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 (30474) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN () ORDER BY rp.in_squad = 1 DESC
0.0126  SELECT e.action, count(e.action) as total, e.player_id FROM events2000 e WHERE e.league_id IN (30474) AND (e.action IN (22) ) GROUP BY e.player_id ORDER BY total DESC, e.player_id ASC LIMIT 20
0.0125  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 (30474) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN () ORDER BY rp.in_squad = 1 DESC
0.0125  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 = 30474 AND rp.lineup > 0 ORDER BY rp.lineup DESC,p.pod DESC LIMIT 20
0.0124  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 = 30474 AND rp.events > 0 ORDER BY rp.events DESC,p.pod DESC LIMIT 20
0.0128  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=30474 AND rel.round=18
0.0126  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 = 30474 AND esl.points > 0 ORDER BY esl.points DESC LIMIT 3
0.0126  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 = 30474 AND esl.points > 0
0.0126  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` = 30474 ORDER BY creation_date DESC LIMIT 0, 10
0.0130  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` = 30474
0.0126  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` = 30474 AND c.`round` = 18 ORDER BY shedule ASC LIMIT 200
0.0124  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 = 18 AND e.real_date IS NOT NULL AND e.league_id = 30474 ORDER BY total DESC LIMIT 40
0.0127  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 = 30474 AND e.real_date > NOW() - INTERVAL 1 MONTH ORDER BY e.real_date DESC LIMIT 30
0.0127  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 = 30474 AND t.round = 16 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0127  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 = 30474 AND t.round = 18 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0127  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 = 30474 ORDER BY c.shedule ASC, fcoef DESC LIMIT 5
0.0127  SELECT data1, data2 FROM services_tags WHERE categoryId=314
0.0127  SELECT l.year,l.group_code FROM leagues_besoccer l WHERE l.categoryId = 314 AND l.year = 2000 ORDER BY l.group_code ASC
0.0127  SELECT group_code, extraName from `leagues` WHERE categoryId=314 AND year=2000