4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Publicidad 600x120.gif
Liga Catar 2004
2003/2004

Liga Catar 2004

Información Histórica
						

Round 1
[Oct 9]
Khor        1-2 Qatar            [at Ittihad]
  [Walid Muhiddin 35; Fabrice Akwa 59, 80]
[Oct 10]
Siliya      0-2 Arabi            [at Ittihad]
  [Walid Hamza 76; Stefan Effenberg 85] 
Sadd        3-2 Ahli             [at Ittihad]
  [Carlos Tenorio 16, 53, 60; Meshal Abdullah 46, 63]
[Oct 11]
Shamal      4-5 Rayyan
  [Ahmed Abduljabbar 42, Razzaq Farhan 59, 68, 76;
   Boushaib Lembarki 3, 18, 43, 70, Walid Jasem 62]
Wakra       1-1 Al-Ittihad
  [Al-Mirghani Al-Zein 60; Kapa Diawara 43]
 
Round 2
[Oct 16]
Ittihad     1-0 Shamal
  [Abdullah Al-Mazrouyi 89]
[Oct 17]
Ahli        3-1 Arabi
  [Thiago Oliveira Santos 2, Carlos Pedro 26, Meshal Abdullah 57;
   Gabriel Batistuta 91pen]
Sadd        2-0 Khor
  [Carlos Tenorio 23, Youssef Chippo 52]
[Oct 18]
Rayyan      3-2 Wakra
  [Boushaib Lembarki 40, 63, Abdulrahman Al-Kawari 75; Soumah Osman 39,
   Ismail Ali 72]
Qatar       3-2 Siliya
  [Claudio Caniggia 12, Abdulaziz Hassan 44, Khaled Saleh 77;
   Silvano Anselmo 30, David Cesarini 90]

Round 3
[Oct 23]
Arabi       2-3 Khor
  [Gabriel Batistuta 19pen, 52pen; Rachid Rouki 11, 45, 94]
[Oct 24]
Sadd        2-0 Qatar
  [Abdulkader Keita 34, Bilal Abdulrahman 74]
Rayyan      1-1 Ittihad
  [Walid Jasem 62; Fehaid Al-Shummeri 47]
[Oct 25]
Ahli        3-1 Shamal
  [Meshal Abdulla 57, Jasem Abdulla 62,
   Thiago Oliveira Santos 77pen; Razzaq Farhan 85]
Siliya      1-1 Wakra
  [Sobhi Adel 30; Mirghani Al-Zein 14]

Round 4
[Oct 30]
Sadd        7-0 Al-Arabi
  [Carlos Tenorio 6, 10, 67, 75, 79, Youssef Chippo 36,56]
[Oct 31]
Al-Ittihad  2-1 Qatar
  [Abdullah Al-Mazroo'ee 61, Pius N'Diefi 82; Yaser Nazmi 69]
Al-Ahli     2-1 Rayyan
  [Thiago Oliveira Santos 10, Josep Guardiola 53;
   Abdulrahman Al-Kawari 28]
[Nov 1]
Wakra       3-3 Shamal
  [Rock Buskapa 26, Soumah Othman 41, Ali Qassim 63;
   Razzaq Farhan 13, 17, 53]
Khor        5-0 Siliya
  [Pascal Nouma 17, 44, 53, Rachid Rouki 62, 88]

Round 5
[Nov 6]
Al-Arabi    1-2 Wakra
  [Gabriel Batistuta 70; Rock Buskapa 21, 91]
[Nov 7]
Siliya      3-5 Rayyan
  [David Mazzoncini 9, Aboubacer 'Titi' Camara 43, Salah Al-Mulla 71;
   Hierro 22, Naser Kameel 33, 43, 66, Walid Jasem 41]
Sadd        0-0 Al-Ittihad
[Nov 8]
Al-Ahli     0-0 Khor
Qatar       5-2 Shamal
   [Fabrice Akwa 16, 86, Yaser Nazmi 79, Khaled Khamis 88,
    Muammar Abdulrab 90; Hassan Abdulrazzaq 34, Razzaq Farhan 72]

Round 6
[Nov 13]
Qatar       3-0 Al-Ahli
  [Said Chiba 32, Fabrice Akwa 36, 53]
[Nov 14]
Al-Ittihad  5-1 Siliya   
  [Kaba Diawara 6pen, 61, Fahad Al-Shummeri 28, Pius N'Diefi 30,
   Sghayer Al-Shummeri 87; Aboubacer 'Titi' Camara 66]
Sadd        1-0 Shamal
  [Fahad Al-Kaabi 94og]
[Nov 15]
Rayyan      1-1 Al-Arabi
  [Fernando Hierro 90; Walid Hamza 24]
Khor        1-2 Wakra
  [Abdullah Hassan 59; Mirghani Al-Zein 8, Ibrahim Salmin 34]

Round 7 [Nov 22]
Sadd        4-0 Siliya
  [Frank Leboeuf 16, 43, Mohamed Gholam 63, Youssef Chippo 79]
Al-Ahli     2-1 Al-Ittihad  
  [Carlos Pedro 3, Meshal Abdullah 59; Kaba Diawara 58]
Shamal      1-2 Al-Arabi
  [Jean Leon 90; Gabriel Batistuta 23, Stefan Effenberg 70]
Rayyan      2-3 Khor
  [Abdulrahman Al-Kowari 1, Ali Benarbia 21pen; Pascal Nouma 50, 72,
   Abdullah Hassan 86]
Wakra       0-1 Qatar
  [Fabrice Akwa 63]

Round 8
[Dec 4]
Qatar       1-2 Al-Arabi
  [Claudio Caniggia 27; Gabriel Batistuta 16, 72]
[Dec 5]
Wakra       0-3 Al-Ahli
  [Thiago Oliveira Santos 40, Meshal Abdullah 76, 
   ‘Calo’ Carlos Pedro Silva Morais 91]
Sadd        0-0 Rayyan
[Dec 6]
Khor        0-1 Al-Ittihad
  [Emad Mohammed 25]
Siliya      2-2 Shamal
  [Karim Karkar 16, Aboubacer 'Titi' Camara 44; Felix 14, Qadr Moosa 46]

Round 9
[Dec 11]
Sadd        2-1 Wakra
  [Carlos Tenorio 30, Frank Leboeuf 42; Soumah Osman 26]
Qatar       1-0 Rayyan
  [Fabrice Akwa 48]
[Dec 12]
Al-Ittihad  2-3 Al-Arabi
  [Emad Mohamed 40, Djamel Belmadi 78; Musad Farhan 23,
   Gabriel Batistuta 27pen, 51]
Al-Ahli     2-2 Siliya
  [Meshal Abdullah 20, Abdullah Jasem 62; Khaled Norreddin 25, 53]
Shamal      0-3 Khor     
  [Rachid Rouki 19, 75, Walid Muhyeddin 62]

Round 10
[Jan 28]
Khor        2-2 Qatar
  [Rachid Rouki 23, Walid Mohyeddine 57; Abdulaziz Hassan 14,
   Fabrice Akwa 53]
[Jan 29]
Siliya      0-6 Al-Arabi
  [Sayyed Al-Bashir 7, Gabriel Batistuta 27, 36, 64, 68,
   Stefan Effenberg 76]
Al-Ahli     2-3 Sadd
  [José George 7, Thiago Oliveira Santos 15pen; Abdelkader Keita 3,
   Frank Leboeuf 45pen, Carlos Tenorio 63]
[Jan 30]
Shamal      3-5 Rayyan
  [Razzaq Farhan 24, 80, 89; Fernando Hierro 2, 34,
   Nasser Kamil 38, 79, Bouchaib El-Moubarki 71]
Al-Ittihad  0-2 Wakra
  [Omar Moussa 52, Soumah Osman 67]

Round 11
[Feb 5]
Sadd        awd Khor             [awarded 3-0; abandoned at 2-2 in 93' when
  [Frank Leboeuf 10, 84pen;       Khor had 5 players sent off (Sadd also 3!)]
   Eissa Al-Kowari 14og, Rachid Rouki 37pen]
[Feb 6]
Al-Arabi    2–2 Al-Ahli
  [Stefan Effenberg 13pen, Gabriel Batistuta 51pen;
   ‘Calo’ Carlos Pedro Silva Morais 38, 63]
Qatar       2–0 Siliya
  [Saeed Al-Sheeba 38, Claudio Caniggia 44]
[Feb 7]
Al-Ittihad  7–2 Shamal
  [Youssouf Adam 41pen, Imad Mohamed 44, 80, 90, Kaba Diawara 56, 63,
   Fahad Al-Shemmari 73; Hassan Abdulrazzaq 43, Razzaq Farhan 87pen]
Wakra       0–1 Rayyan
  [Sahan Al-Shemmari 54]

Round 12
[Feb 21]
Shamal      1-1 Al-Ahli
  [Omar Najari 45; Jose Kalou 37]
Siliya      2-3 Wakra
  [Khaled Jabarti 14, Titi Camara 31; Ali Mejbel 71, Ismail Ali 87,
   Mirghani Al-Zein 90]
[Feb 22]
Rayyan      1-3 Al-Ittihad
  [Boushaib Lembarki 7; Kaba Diawara 55, Imad Mohamed 72, Moujib Hamed 84]
Al-Arabi    1-1 Khor
  [Gabriel Batistuta 2; Pascal Nouma 56]
[Mar 16]
Sadd        0-0 Qatar      

Round 13
[Feb 27]
Shamal      1-2 Wakra  
  [Omar Najari 9; Ali Qassem 37, 47]
Siliya      2-2 Khor        
  [Karim Karkar 56, Titi Camara 76; Walid Mohyeddine 19, Pascal Nouma 88]    
[Feb 28]
Rayyan      1-2 Al-Ahli   
  [Ali Benarbia 34; Jose Kalou 51, 83]
[Feb 29]
Al-Arabi    2-1 Sadd
  [Musad Farhan 68, Gabriel Batistuta 82; Bilal Abdulrahman 60]
Al-Ittihad  1-2 Qatar
  [Djamal Belmadi 91pen; Fabrice Akwa 48, Said Chiba 87]

Round 14
[Mar 4]
Khor        0-0 Al-Ahli
[Mar 5]
Rayyan      5-1 Siliya
  [Ali Benarbia 3, 83, Boushaib Lembarki 13, Walid Jassem 60,
   Nasser Kamil 62; Titi Camara 86]
Al-Ittihad  1-2 Sadd
  [Djamel Belmadi 29pen; Carlos Tenorio 70, Abdullah Kouni 72]
[Mar 6]
Al-Arabi    4-0 Wakra
  [Gabriel Batistuta 2pen, 64, 80pen, Musad Farhan 6]
Shamal      1-1 Qatar
  [Hassan Abdulrazzaq 24; Fabrice Akwa 46]

Round 15
[Mar 11]
Al-Ahli     0-4 Qatar
  [Said Chiba 19, Medhat Mustapha 51, Yasser Nazmi 73, Claudio Caniggia 85]
[Mar 12]
Shamal      1-4 Sadd
  [Razzaq Farhan 24; Carlos Tenorio 21, 45, 62, Abbdulqader Keita 45]
Al-Arabi    3-5 Rayyan
  [Gabriel Batistuta 2, 48, 84; Mario Basler 12, Ali Benarbia 39,
   Boushaib Lembarki 51, 66, 73]
[Mar 13]
Siliya      1-3 Al-Ittihad  
  [William Brounir 59; Kaba Diawara 21, 90, Emad Mohammed 45]
Wakra       1-4 Khor 
  [Osman Souma 78; Osvaldo Fernández De Souza 58, Walid Muhiddine 64,
   Rachid Rouki 73, 90]
 
Round 16
[Mar 18]
Rayyan      2-0 Khor
  [Ali Benarbia 29, Boushaib Lembarki 70]
[Mar 19]
Al-Ittihad  2-2 Al-Ahli
  [Bilal Mohamed 10, Djamel Belmadi 91pen; Meshal Abdullah 5,
   Josep Guardiola 35pen]
Al-Arabi    4-2 Shamal
  [Fabien Sipot 11, Sayyed Al-Bashir 14, 31, Gabriel Batistuta (76;
   Razzaq Farhan 53, Fabien Sipot 58og] 
[Mar 20]
Wakra       2-1 Qatar
  [Mirghani Al-Zein 18, Ali Tartous 31; Claudio Caniggia 45]
Siliya      0-3 Sadd
  [Carlos Tenorio 9, 17, 33]

Round 17
[Apr 8]
Shamal      4-3 Siliya
  [Eduardo Ramirez 60, Ahmed Abduljabbar 71, Omar Najari 73pen, 
   Eyhab Serr Al-Khetm 77; Mohamed Salem 7, Titi Camara 19, Majed Mohamed 59]
[Apr 9]
Al-Ahli     3-3 Wakra    
  [Meshal Abdullah 49, 70, 84; Ali Mejbel 32, Mirghani Al-Zein 56,
   Ahmed Moosa 59]
Al-Ittihad  1-1 Khor
  [Bilal Mohammed 30; Mostafa Jalal 91]
[Apr 10]
Al-Arabi    0-0 Qatar
[Apr 11]
Rayyan      0-1 Sadd
  [Youssouf Chippo 62]

Round 18
[Apr 14]
Siliya      0-4 Al-Ahli
  [Meshal Abdullah 18, Ibrahim Hilal 24og, Oliveira 80, Jose Kalou 84]
Shamal      2-4 Khor
  [Razzaq Farhan 56, Qadr Moosa 89; Rachid Rouki 11, 20, 38, Ali Juma 65]
[Apr 15]
Sadd        0-1 Wakra
  [Rock Buskapa 62]
Rayyan      0-2 Qatar
  [Fabrice Akwa 16, 92]
Al-Arabi    2-1 Al-Ittihad
  [Gabriel Batistuta 26, 30; Djamal Belmadi 62]

Final Table:

 1.Al-Sadd       18 13  3  2  38-10  42  Champions  [Doha-al-Sadd]
 2.Qatar SC      18 10  4  4  31-17  34  [Doha]
 3.Al-Arabi      18  9  4  5  38-32  31  [Doha]
 4.Al-Ahli       18  7  7  4  33-28  28  [Doha]
 5.Al-Rayyan     18  8  3  7  38-32  27  [Rayyan]
 6.Al-Ittihad    18  7  5  6  33-24  26  [Doha-Gharrafa]
 7.Al-Wakra      18  7  4  7  26-32  25  [Wakra]
 8.Khor          18  6  6  6  30-25  24  [Khor]
 9.Shamal	 18  1  4 13  30-56   7  
---------------------------------------
10.Siliya        18  0  4 14  20-61   4  Relegated  [*]

[*] Al-Qadisiya changed name to Siliya before the season


Topscorers:

 1.Gabriel Batistuta (Al-Arabi)  25
 2.Carlos Tenorio (Al-Sadd)      18
 3.Razzaq Farhan (Al-Shamal)     14
 4.Fabrice Akwa (Qatar SC)       13
   Rachid Rouki (Al-Khor)        13 (plus 1 annulled in round 11)
 6.Boushaib Lembarki (Al-Rayyan) 12

Foreign Players in Qatar 2003/04

NB: each team were given $10m by the Qatar Olympic Committee to go out 
    and employ up to four big foreign players for the new season. 

Al-Ahly:    Josep Guardiola (Spain, from AS Roma)
            Thiago Oliveira Santos (Brazil)
            ‘Calo’ Carlos Pedro Silva Morais (Cape Verde)
            José (Cape Verde)
              Coach: Pepe (Brazil) 
Al-Arabi:   Gabriel Batistuta (Argentina, from Internazionale)
            Stefan Effenberg (Germany, from Wolfsburg)
            Mohamed Barakat (Egypt, from Al-Ahly (Jeddah))
            Noureddine Darouiche (Algeria)
              Coach: Carlos ‘Cabralzinho’ Cabrol (Brazil) - replaced
                     by Wolfgang Sidka (Germany) in November 2003  
            new players: Dennis Oliech (Kenya)
                         Fabjan Cipot (Slovenia)
Al-Ittihad: Djamel Belmadi (Algeria, from Marseille)
            Pius N’Diefi (Cameroon, from Sedan) - 
            replaced by Emad Mohammed (Iraq) in January 2004
            Alexandre Mariano da Silva Amaral (Brazil, from Grêmio)
            Kaba Diawara (France, from Paris St.Germain)
              Coach: Walter Meeuws (Belgium) - replaced by Carlos Alinho
                     in January 2004; Alinho sacked in March 2004
Al-Khor:    Rachid Rokki (Morocco) 
            Paulo (Brazil)
            Osvaldo Fernández De Souza (Brazil, from Al-Ittihad (Doha))
            Pascal Nouma (France, from Besiktas)
              Coach: Renê Simões (Brazil)
Qatar SC:   Radhi Shnishel (Iraq)
            Fabrice Akwa (Angola)
            Claudio Caniggia (Argentina, from Rangers (Glasgow))
            Hicham Aboucherouane (Morocco, from Raja Casablanca) -
            replaced by Said Chiba (Morocco, from Nancy) in November 2003
              Coach: Dzemaludin Musovic (Bosnia)
Al-Rayyan:  Fernando Hierro (Spain, from Real Madrid)
            Mario Basler (Germany, from Kaisarslautern)
            Ali Benarbia (Algeria, from Manchester City
            Bouchaib El-Moubarki (Morocco, from Al-Ahly (Jeddah))
              Coach: Jean Castaneda (France) - replaced by
                     Bo Nilsson (Sweden) in January 2004
Al-Sadd:    Frank Leboeuf (France, from Marseille)
            Youssef Chippo (Morocco, from Coventry City)
            Carlos Tenorio (Ecuador, from Al-Nasr (Riyadh))
            Abdulkader Keita (Senegal)
              Coach: Luka Peruzovic (Croatia/Belgium)
Al-Shamal:  Razzaq Farhan (Iraq, from Al-Khaleej (UAE))
            Ahmed Abdul-Jabar (Iraq)
            Haidar Mahmoud (Iraq)
            Abdelhaq Ben Bella (Morocco)
              Coach: Robert Mullier (Switzerland) - replaced
                     by Valdeir ‘Badu’ Vieira in January
            new players: Félix
                         Jean Léon (Benin)
                         Eduardo Ramírez
Al-Siliya:  Aboubacer 'Titi' Camara (Guinea) - added in November 2003
            Bruno Cazrin (Brazil)
            Anselmo Da Silva (Brazil) - contract dissolved November 2003
            Assad Mustafa (Sudan)
            David Mazzoncini (France)
              Coach: Paulo Campos (Brazil) - replaced by
                     Pierre Lechantre (France) in January 2004
            new player: Karim Kerkar (Algeria)
Al-Wakra:   Soumah Othman (France)
            Rock Buskapa (Congo, from Al-Nasr (Riyadh))
            Lahcen Abrami (Morocco, from Wydad Casablanca)
            Julio César Baldivieso (Bolivia, from Aurora) - added in 
                                                        October 2003
              Coach: Dzemal ‘Jamal Haji’ Hadziabdic (Bosnia) 




Author:
Mohammed Qayed
(mhqayed@hotmail.com)

Last updated: 26 Apr 2007

(C) Copyright Mohammed Qayed and RSSSF 2003/07
						


  USO DE MEMORIA  
4,261,632 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0019
Controller Execution Time ( Home / Category )  0.1084
Total Execution Time  0.1103
  CADENA URL  
/liga_catar2004
  GET DATOS  
$_GET['/liga_catar2004']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (37)  
0.0018  SELECT type FROM routes WHERE alias = 'liga_catar2004'
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 = 2004 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.0036  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.0024  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.0023  SELECT text_es as historical_text FROM leagues_text WHERE id=1513
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 = 29784 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0020  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=312 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-27 10:45:48' 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:45:48' 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:45:48' 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 10:45:48' 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 = 2004 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 events2004 e WHERE e.league_id IN (29784) 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 (29784) 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 events2004 e WHERE e.league_id IN (29784) 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 (29784) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN () ORDER BY rp.in_squad = 1 DESC
0.0026  SELECT e.action, count(e.action) as total, e.player_id FROM events2004 e WHERE e.league_id IN (29784) 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 (29784) 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 events2004 e WHERE e.league_id IN (29784) AND (e.action IN (22) ) GROUP BY e.player_id ORDER BY total DESC, e.player_id ASC LIMIT 20
0.0020  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 (29784) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN () ORDER BY rp.in_squad = 1 DESC
0.0019  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 = 29784 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 = 29784 AND rp.events > 0 ORDER BY rp.events DESC,p.pod DESC LIMIT 20
0.0022  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=29784 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 = 29784 AND esl.points > 0 ORDER BY esl.points DESC LIMIT 3
0.0023  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 = 29784 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` = 29784 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` = 29784
0.0020  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` = 29784 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 `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 = 18 AND e.real_date IS NOT NULL AND e.league_id = 29784 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 `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 = 29784 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 `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 = 29784 AND t.round = 16 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0023  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 = 29784 AND t.round = 18 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0023  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 = 29784 ORDER BY c.shedule ASC, fcoef DESC LIMIT 5
0.0023  SELECT data1, data2 FROM services_tags WHERE categoryId=312
0.0023  SELECT l.year,l.group_code FROM leagues_besoccer l WHERE l.categoryId = 312 AND l.year = 2004 ORDER BY l.group_code ASC
0.0023  SELECT group_code, extraName from `leagues` WHERE categoryId=312 AND year=2004