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

Liga Líbano 2004

Información Histórica 
						

Final Table:

 1.Al-Nijmeh            22 17  3  2 67-18 54  Champions
 2.Al-Ahed              22 14  5  3 39-20 47
 3.Olympic Beirut       22 10  5  7 32-27 35
 4.Safa                 22  7 10  5 32-34 31
 5.Al-Mabarra           22  7  7  8 27-26 28
 6.Al-Ansar             22  7  7  8 26-27 28
 7.La Sagesse           22  7  6  9 28-31 27  [aka Al-Hikmeh]
 8.Shabab Al-Sahel      22  6  8  8 27-38 26
 9.Al-Tadamon Tyre      22  7  4 11 30-34 25
--------------------------------------------
10.Salam Zghorta        22  5  8  9 24-33 23  Relegated
11.Homenmen             22  6  3 13 16-37 21  Relegated
12.Homenetmen           22  4  4 14 31-54 16  Relegated

Round 1
[Oct 4]
Nijmeh          3-1 Homenetmen
  [Mohamed Halawi 10, Moussa Hojeij 20, Mohamed Qassas 80;
   Vartan Ghazarian 7]
Sagesse         1-0 Tadamon
  [Paul Rustom 4]
[Oct 5]
Homenmen        0-1 Olympic
  [Silvio Costa 25pen]          
Safa            2-2 Sahel
  [Koder Ibrahim 14, 38; Hussein Ballout 70, Toufik Haydar 75]
Salam Zghorta   2-3 Ahed
  [Mohammad Obeid 12, Mohsen Nassif 77; Ali al Attar 23, Bassem Marmar 62,
   Mahmoud Chahoud 90]
Mabarra         2-2 Ansar
  [Madio Konati 10, Ali Ahmed 37; Mohamed Jawad 39, Malek Hassoun 89]

Round 2
[Oct 10]
Nijmeh          3-1 Salam Zghorta
  [Mohamed Halawi 12, Mohamed Qassas 45pen, Ali Nasereddine 63;
   Jad Mouawwadh 82]
[Oct 11]
Shabab          1-0 Tadamon
  [Hussein Ballout 81]
Ahed            2-0 Mabarra
  [Ahmed Itani 26, Riyadh Qobeissi 55]
Olympic         2-1 Homemetmen
  [Mohamed Youssouf 79, Silvio Costa 85; Vartan Ghazarian 17]
[Oct 12]
Sagesse         3-2 Ansar
  [Mazen Jradi 21, 55, Tommy Giacomeli 80; Fadi Ghoson 64, Malek Hassoun 90]
Safa            0-3 Homenmen
  [Adham Ghaddar 40, 76, Jean-Caude Kamal 90og]

Round 3
[Oct 25]
Ahed            0–0 Sagesse
Homenetmen      1–1 Safa
  [Vartan Ghazarian 7; Salomao Salha 68
[Oct 26]
Tadamon         2-0 Homenmen
  [Hamid Basma 83, Nasrat Al-Jamal 87]
Mabarra         3–3 Nijmeh
  [Ali Ahmed 16, 51, Madio Konati 45; Yahya Hashem 55,
   Gilberto Dos Santos 78, Moussa Hojeij 86]
Ansar           2–1 Shabab 
  [Abdullah Moussa 45, Mohamed Jawad 90; Carlos Jose Sousa Silva 84]
[Oct 28]
Salam Zghorta   0–2 Olympic 
  [Abbas Atwi 17, Youssouf Mohamed 77]

Round 4
[Dec 2]
Shabab          0-1 Ahed
  [Ahmed Itani 3]
Tadamon         2-1 Homenetmen
  [Khodor Najde 47, Haytham Zein 56; Hagop Donabidian 53]
Ansar           0-1 Homenmen
  [Marwan Nakhle 4]
[Dec 3]
Safa            2-1 Salam Zghorta
  [Ghassan Showaikh 2, 10; Rami Al-Hassan 27]
Olympic         0-4 Mabarra
  [Ali Ahmed 3, 74pen, Youssouf Mezian 9, Ali Dabbous 90]
Nijmeh          2-0 Sagesse
  [Gilberto Dos Santos 29pen, Mohamed Ghaddar 89]

Round 5
[Dec 6]
Ansar           3–2 Homenetmen
  [Sami Al-Shoum 18, Abdullah Moussa 36, 73; Tero Kehyeyan 81pen,
   Artur Kosherian 89]
Ahed            3–1 Homenmen
  [Ali Al-Attar 38, Ahmed Itani 41, Gholam Ghader 90; Marwan Nakhle 47]
[Dec 7]
Nijmeh          1–0 Shabab 
  [Errol McPharlane 90]
Olympic         4-1 Sagesse 
  [Abbas Atwi 30, Hussein Ollaiq 75, Edilson Da Silva 54,
   Youssouf Ba’albaki 79; Tommy Giacomeli 90]
Tadamon         0–2 Salam Zghorta
  [Youssouf Hijazi 60og, Rami Al-Hassan 90]
Mabarra         1-1 Safa
  [Ali Ahmed 35; Ghassan Showaikh 29]

Round 6
[Dec 13]
Sagesse         1-2 Safa
  [Walid Shehade 33; Khodor Ibrahim 23, Ghassan Showaikh 72]
Ahed            4–1 Homenetmen
  [Ali Al-Attar 32, Mahmoud Shahoud 34, 49, Gholam Ghader 71;
   Artur Kosherian 90]
[Dec 14]
Shabab          0-0 Olympic 
Salam Zghorta   0–0 Ansar
Tadamon         2-0 Mabarra
  [Haytham Zein 75, Khodor Najde 86]
Homenmen        0–6 Nijmeh 
  [Mohamed Qassas 19, 60pen, 64, Moussa Hojeij 50, Errol McPharlane 75,
   Mohamed Halawi 77]

Round 7
[Dec 20]
Shabab          3-3 Salam Zghorta
  [Hussein Ballout 53, 78, Bassem Nehme 82; Francois Kharma 59,
   Muhsin Nassif 67, Bourtos Karam 90]
Safa            0-2 Olympic
  [Edilson Da Silva 78, Hussein Ollaiq 80]
[Dec 21]
Homenmen        1–1 Mabarra
  [Kenneth 90og; Ali Ahmed 43]
Homenetmen      2–1 Sagesse
  [Artur Kkosherian 19, Hagop Donabidian 35; Paul Rustom 27]
Nijmeh          4–0 Tadamon 
  [Mohamed Qassas 9, Ali Nasereddine 26, Ala’a Shahine 64, Mohamed Ghaddar 84]
Ansar           0–1 Ahed
  [Mahmoud Shahoud 47]

Round 8
[Dec 27]
Homenetmen      3–4 Shabab
  [Toufiq Haydar 12og, Hagop Donabidian 51, Vartan Ghazarian 68;
   Hussein Ballout 7, Luiz Fernandez 13, Jardel 83, 86]
[Dec 28]
Ahed            1-1 Safa
  [Issam Ayyoub 68; Salomao Salha 89]
Sagesse         1–0 Homenmen
  [Youssouf Al-Jawhari 30]
Salam Zghorta   1–1 Mabarra
  [Abdulfattah Al-Samad 23; Madio Konati 34]
Olympic         1-2 Tadamon 
  [Krekor Alozian 2; Haytham Zein 3, 43]
[Dec 30]
Ansar           1-2 Nijmeh
  [Abdullah Moussa 79; Hussein Daher 42, Abbas Atwi 68]

Round 9
[Jan 3]
Mabarra         1–0 Sagesse
  [Madio Konati 76]
Homenmen        1–0 Shabab
  [Kaghik Simonian 55]
Safa            2-1 Tadamon
  [Zaher Al-Indari 51, Walid Al-Miri 90; Ibrahim Manasri 86]
Nijmeh          1–2 Ahed
  [Mohamed Halawi 76; Bilal Najjarine 13og, Issam Ayyoub 16]
[Jan 4]
Salam Zghorta   2–1 Homenetmen
  [Levon Khashadorian 48og, Rami Al-Hassan 69; Samuel Boghossian 80]
Olympic         1–0 Ansar
  [Pierre Issa 26]

Round 10
[Jan 10]
Homenetmen      0–1 Mabarra 
  [Madio Konati 83]
Ahed            1–1 Olympic 
  [Boubacar Bah 51; Krekor Alozian 49]
[Jan 11]
Homenmen        0–2 Salam Zghorta
  [Francois Kharma 24, Wael Mouawwadh 60]
Tadamon         1–3 Ansar
  [Haytham Zein 82pen; Abdullah Moussa 6, Fadi Ghosson 8,
   Ahmed Al-Shoum 14]
Safa            0-4 Nijmeh
  [Abbas Atwi 4, Mohamed Qassas 41, Marko Ivankovic 70,
   Errol McPharlane 90]
Shabab          1-1 Sagesse
  [Fadhl Al-Sayyed 73; Paul Rustom 55]

Round 11
[Jan 17]
Sagesse         1–1 Salam Zghorta
  [Paul Rustom 45; Michel Gibran 49og]
Ahed            1–0 Tadamon 
  [Ali Al-Attar 33]
Ansar           1–1 Safa
  [Abbas Saleh 78; Salomao Salha 42]
[Jan 18]
Mabarra         1–2 Shabab
  [Madio Konati 39; Hussein Ballout 88, Abdulrahman Al-Moussaoui 90]
Nijmeh          2–0 Olympic 
  [Mohamed Halawi 49, Ali Naserreddine 56]
Homenetmen      0–0 Homenmen

Round 12
[Jan 24]
Sagesse         abd Mabarra           [abandoned at 0-0 in 62' due to 
Tadamon         2-3 Olympic            unplayable pitch]
  [Qassem Daher 22, Haytham Zein 57; Silvio Costa 17, Abbas Atwi 55,  
   Marcilio Silva 79]
[Jan 25]
Nijmeh          7-1 Homenetmen
  [Errol McPharlane 6, 42, Mohamed Halawi 34, 38,
   Mohamed Qassas 51, 61, 68; Karen Barsekhian 71]
Homenmen        0-1 Ahed
  [Ahmed Itani 90]
Safa            2-2 Ansar
  [Hassan Ibrahim 45, Salomao Salha 84; Ahmed Al-Shoum 15, Fadi Ghosson 66]
Salam Zghorta   0-0 Shabab 
[Feb 5]
Sagesse         1-2 Mabarra           [replay]
  [Paul Rustom 70; Youssouf Mezian 35, Ali Ahmed 45]

Round 13
[Jan 31]
Sagesse         2–0 Olympic
  [Hassan Nasrallah 3, Youssouf Al-Jawhari 30]
Shabab          abd Safa              [abandoned at 0-0 in 17' due to storm]
[Feb 1]
Homenmen        0–4 Nijmeh
  [Mohamed Halawi 11, Mohamed Qassas 13, 17, Errol McPharlane 89]
Tadamon         2-2 Ahed
  [Haytham Zein 26, Oussama Haydar 40; Mahmoud Shahoud 16, Boubacar Bah 67]
Ansar           1–0 Mabarra
  [Abdullah Moussa 90]
[Feb 2]
Homenetmen      0-1 Salam Zghorta
  [Jad Mouawwadh 83]
Shabab          2-4 Safa              [replay]
  [Hussein Ballout 84, Jardel 90; Ghassan Showaikh 21, 50, 88,
   Hassan Ibrahim 62]

Round 14
[Apr 10]
Safa            2–1 Homenetmen
  [Ghassan Showaikh 25, 71pen; Tero Kehyeyan 67]
Sagesse         3–3 Ahed
  [Walid Shehade 23, Youssouf Al-Jawhari 68, Tommy Giacomeli 83;
   Boubacar Bah 11, Mahmoud Shahoud 31, 42]
Salam Zghorta   0–1 Homenmen
  [Ja’afar Mersel 38]
[Apr 11]
Olympic         3–1 Ansar 
  [Youssouf Mohamed 18, Edilson Da Silva 33, 61; Abbas Saleh 79]
Nijmeh          3–1 Tadamon 
  [Mohamed Qassas 14pen, Moussa Hojeij 53, Abbas Atwi 85; Hassan Nasrallah 78]
Shabab          0-0 Mabarra

Round 15
[Apr 14]
Olympic         1-1 Shabab
  [Edilson Da Silva 90; Fadhl Al-Sayyed 33]
[Apr 15]
Sagesse         2-4 Nijmeh
  [Paul Rustom 68, Tommy Giacolemi 86; Moussa Hojeij 44, Mohamed Qassas 61,
   Ali Nassereddine 74, 82]
[Apr 17]
Mabarra         0-1 Homenetmen
  [Artur Kosherian 83]
[Apr 18]
Salam Zghorta   2-4 Tadamon
  [Jad Mouawwadh 54, Rami Al-Hassan 80; Nasrat Al-Jamal 13, 30, 52,
   Haytham  Zein 58]
Ahed            1-0 Ansar
  [Mahmoud Shahoud 32]
[May 5]
Homenmen        0-2 Safa
  [Saadallah Badawi 40, Khodor Salameh 76]

Round 16
[Apr 24]
Ahed            0-1 Shabab 
  [Hussein Ballout 41]
[Apr 25]
Tadamon         3-4 Safa
  [Haytham Zein 9, Nasrat Al-Jamal 20, Ibrahim Bitar 64; Ghassan Showaikh 12,
   Salomao Salha 24, Zaher Al-Indari 42, Khodor Salameh 82]
Homenetmen      4-3 Olympic 
  [Tero Kehyeyan 4, Artur Kosherian 8, 42, 52pen; Abbas Atwi 43,
   Amir Al-Haf 55, Pierre Eissa 66]
Nijmeh          3-0 Ansar
  [Mohamed Qassas 69, Errol McPharlane 80, Ali Nassereddine 90]
Salam Zghorta   1-2 Sagesse
  [Mohamed Obaid 78pen; Paul Rustom 16, Youssouf Al-Jawhari 90pen]
[May 12]
Mabarra         0-1 Homenmen
  [Ja'afar Mersel 57]

Round 17
[Apr 29]
Shabab          1-8 Nijmeh
  [Hussein Ballout 43pen; Abbas Atwi 3, Moussa Hojeij 12,
   Mohamed Qassas 17, 65, 90, Khaled Hamiyyeh 40, Sarkis Abajian 70,
   Wahid Fattal 80pen]
Olympic         5-1 Homenmen
  [Edilson Da Silva 8, Abbas Atwi 15, 30, Youssouf Ba'albaki 67,
   Youssouf Mohamed 82; Gaghik Simonian 40]
[Apr 30]
Mabarra         1-2 Tadamon
  [Ali Ahmed 14; Haytham Zein 69, 86pen]
[May 1]
Homenetmen      2-4 Ahed
  [Hagop Donabidian 71, Mheir Barbarian 84; Gholam Ghader 61, 
   Ahmed Trad 66, Mahmoud Shahoud 79, 90]
Ansar           0-0 Salam Zghorta
Safa            1-1 Sagesse
  [Salomao Salha 1; Paul Rustom 24]

Round 18
[May 7]
Sagesse         0-1 Homenetmen
  [Artur Kosherian 89]
[May 8]
Safa            1-2 Ahed
  [Zaher Al-Indari 70; Mahmoud Shahoud 11, Abbas Khalifa 30]
Mabarra         2-0 Olympic
  [Madio Konati 42, Ali Ahmed 49]
Homenmen        0-1 Ansar
  [Zoheir Morad 23]
Tadamon         0-0 Shabab
[May 10]
Salam Zghorta   1-1 Nijmeh
  [Francois Kharma 58; Moussa Hojeij 44]

Round 19
[May 13]
Nijmeh          2-1 Safa
  [Mohamed Qassas 7pen, Mohamed Halawi 49; Hussein Daher 90og]
[May 15]
Shabab          2-1 Homenmen
  [Sha'abane Hamade 21, Luiz Fernandez 86pen; Ja'afar Mersel 42]
[May 16]
Tadamon         1-1 Sagesse
  [Nasrat Al-Jamal 60; Youssouf Al-Jawhari 83]
Homenetmen      1-1 Ansar
  [Artur Kosherian 60; Milos Manolovic 87]
Mabarra         1-0 Ahed
  [Ali Ahmed 10]
Salam Zghorta   1-0 Olympic
  [Mohamed Obaid 14]

Round 20
[May 20]
Olympic         2-1 Ahed
  [Marcilio Silva 76, Ali Mtayrek 87pen; Mahmoud Shahoud 55]
[May 25]
Nijmeh          3-1 Mabarra
  [Mohamed Qassas 9, 24, Moussa Hojeij 51; Ali Ahmed 12]
Ansar           2-1 Sagesse
  [Ahmed Al-Shoum 68, Milos Manolovic 79; Fouad Hijazi 44]
Homenmen        1-0 Tadamon Tyre
  [Daniel Al-A'awar 10]
Shabab          6-4 Homenetmen
  [Jardel 9, Luiz Fernandez 9, Ahmed Al-Soufi 46, 70, Hussein Baallout 69,
   Ali Awada 90; Hagop Donabidian 19, Artur Kosherian 40, 58pen, 76]
Salam Zghorta   1-1 Safa
  [Jad Mouawwadh 69; Ghassan Showaikh 71]

Round 21 [May 29]
Safa            1-1 Mabarra
  [Walid al Miri 75; Ali Ahmad 60]
Ahed            4-0 Salam Zghorta
  [Mahmoud Chahoud 60, Abou Baker Bah 62, 70, Ahmad Itani 86]
Olympic         0-0 Nijmeh
Homenmen        1-3 Sagesse
  [Armen Bedikian 45; Paul Roustom 16, 58pen, Tomy Giacomelly 83]
Ansar           3-0 Sahel
  [Mohammad Jawad 42, Dani Nahle 47, Ahmad al Choum 92]
Homenetmen      0-4 Tadamon
  [Haitam Zein 3, 93, Hamid Basma 61, 92] 

Round 22
[Jun 2]
Mabarra         4-2 Salam Zghorta
  [Madio Konati 24, 75, Ali al Atat 52, Ali Ahmad 67;
   Mohammad Obeid 12, Bassam Asaad 74]
Sagesse         2-0 Sahel
  [Tomy Giacomelly 25, 77]
Ansar           1-1 Tadamon
  [Fadi Ghossen 18; Kassem Daher 19]
[Jun 3]
Olympic         1-1 Safa
  [Walid al Miri 80pen; Ahmad Nohmani 76]
Homenmen        3-3 Homenetmen
  [Daniel al Ahwar 62, Gagik Simoyan 81, 88pen;
   Arthur Kotcharian 3, 45, 88]
Nijmeh          1-2 Ahed
  [Moussa Hojeij 51; Ahmad Trad 4, Mohammad Halawi 20og]

Final Table:

 1.Al-Nijmeh            22 17  3  2 67-18 54  Champions
 2.Al-Ahed              22 14  5  3 39-20 47
 3.Olympic Beirut       22 10  5  7 32-27 35
 4.Safa                 22  7 10  5 32-34 31
 5.Al-Mabarra           22  7  7  8 27-26 28
 6.Al-Ansar             22  7  7  8 26-27 28
 7.La Sagesse           22  7  6  9 28-31 27  [aka Al-Hikmeh]
 8.Shabab Al-Sahel      22  6  8  8 27-38 26
 9.Al-Tadamon Tyre      22  7  4 11 30-34 25
--------------------------------------------
10.Salam Zghorta        22  5  8  9 24-33 23  Relegated
11.Homenmen             22  6  3 13 16-37 21  Relegated
12.Homenetmen           22  4  4 14 31-54 16  Relegated

Promoted: Akha-Ahly and Al-Rayyan (league reduced to 11 clubs 2004/05)

Topscorer: Mohamed Qassas (Al-Nijmeh) 21



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

Last updated: 23 Nov 2006

(C) Copyright Mohamed S. Chbaro and RSSSF 2003/06


  USO DE MEMORIA  
4,281,376 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0030
Controller Execution Time ( Home / Category )  0.5062
Total Execution Time  0.5093
  CADENA URL  
/premier_league_libano2004
  GET DATOS  
$_GET['/premier_league_libano2004']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (38)  
0.0105  SELECT type FROM routes WHERE alias = 'premier_league_libano2004'
0.0213  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'premier_league_libano' AND (l.group_code = 1 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 2004 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=1 DESC LIMIT 1
0.0106  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=477 AND type_rel = 3
0.0112  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 3 AND rel.typeId = 477 AND rel.ln = 'es' AND rel.status=1 ORDER BY rel.creation_date desc,rel.cover_points DESC LIMIT 5
0.0124  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 (888022,869419,508928) ORDER BY n.cover_points DESC, update_date DESC
0.0116  SELECT text_es as historical_text FROM leagues_text WHERE id=2154
0.0117  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 = 30425 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0113  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='2004' WHERE c.parentId=477 GROUP BY c.id ORDER BY c.order_id ASC
0.0109  SELECT type,rule FROM rules WHERE categoryId = 477 ORDER BY type = 'tables_draw' DESC,type != 'extra' DESC, `order` ASC
0.0113  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-04-20 13:17:18' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0111  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=2 AND last_update > '2024-04-20 13:17:18' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0111  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=4 AND last_update > '2024-04-20 13:17:18' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0111  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=3 AND last_update > '2024-04-20 13:17:18' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0121  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'premier_league_libano' AND (l.group_code = 0 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 2004 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=0 DESC LIMIT 1
0.0111  SELECT e.action, count(e.action) as total, e.player_id FROM events2004 e WHERE e.league_id IN (30425) 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.0111  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 (30425) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN () ORDER BY rp.in_squad = 1 DESC
0.0110  SELECT e.action, count(e.action) as total, e.player_id FROM events2004 e WHERE e.league_id IN (30425) AND (e.action IN (4,5) ) GROUP BY e.player_id ORDER BY total DESC, e.player_id ASC LIMIT 20
0.0110  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 (30425) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN () ORDER BY rp.in_squad = 1 DESC
0.0110  SELECT e.action, count(e.action) as total, e.player_id FROM events2004 e WHERE e.league_id IN (30425) AND (e.action IN (3,4) ) GROUP BY e.player_id ORDER BY total DESC, e.player_id ASC LIMIT 20
0.0108  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 (30425) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN () ORDER BY rp.in_squad = 1 DESC
0.0109  SELECT e.action, count(e.action) as total, e.player_id FROM events2004 e WHERE e.league_id IN (30425) AND (e.action IN (22) ) GROUP BY e.player_id ORDER BY total DESC, e.player_id ASC LIMIT 20
0.0108  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 (30425) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN () ORDER BY rp.in_squad = 1 DESC
0.0107  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 = 30425 AND rp.lineup > 0 ORDER BY rp.lineup DESC,p.pod DESC LIMIT 20
0.0105  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 = 30425 AND rp.events > 0 ORDER BY rp.events DESC,p.pod DESC LIMIT 20
0.0108  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=30425 AND rel.round=22
0.0107  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 = 30425 AND esl.points > 0 ORDER BY esl.points DESC LIMIT 3
0.0106  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 = 30425 AND esl.points > 0
0.0106  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-21" AND c.`active`= 1 and c.comment_id is null and c.lang = 1 AND l.`id` = 30425 ORDER BY creation_date DESC LIMIT 0, 10
0.0113  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-21" AND c.`active`= 1 and comment_id is null and c.lang = 1 AND l.`id` = 30425
0.0107  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 `calendars2004` 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` = 30425 AND c.`round` = 22 ORDER BY shedule ASC LIMIT 200
0.0105  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 `events2004` e INNER JOIN calendars2004 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 = 22 AND e.real_date IS NOT NULL AND e.league_id = 30425 ORDER BY total DESC LIMIT 40
0.0114  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 `events2004` e INNER JOIN calendars2004 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 = 30425 AND e.real_date > NOW() - INTERVAL 1 MONTH ORDER BY e.real_date DESC LIMIT 30
0.0108  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 `tables2004` 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 = 30425 AND t.round = 20 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0108  SELECT *,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables2004` 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 = 30425 AND t.round = 22 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0108  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-20 00:00:00' AND c.`shedule` < '2024-04-24 23:59:59' AND l.id = 30425 ORDER BY c.shedule ASC, fcoef DESC LIMIT 5
0.0108  SELECT data1, data2 FROM services_tags WHERE categoryId=477
0.0108  SELECT l.year,l.group_code FROM leagues_besoccer l WHERE l.categoryId = 477 AND l.year = 2004 ORDER BY l.group_code ASC
0.0108  SELECT group_code, extraName from `leagues` WHERE categoryId=477 AND year=2004