4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
« Temporada Anterior
Temporada 2006
Temporada Siguiente »
Publicidad 600x120.gif
Liga 1 Indonesia 2006
2005/2006

Liga 1 Indonesia 2006

Información Histórica 
						
[Jan 14]
Persikota     1-1 Semen Padang  
  [Christian Lenglolo 69; Mamadou 6]
Persija       2-1 Sriwijaya 
  [Leonard Tupanuhu 41, Agus Indra Kurniawan 76; Emeka Obidiah Okoye 78]
[Jan 15]
Persib        1-2 PSIS
  [Eka Ramdani 44; Emmanuel de Porras 23, Imral Usman 32]
PSIM          0-0 Persijap
Arema         2-0 Persita
  [Aris Budi Prasetyo 41, Emaleu Serge 45]
Persekabpas   2-0 Persitara
  [Ahmad Junaidi 10, Abdul Effendi 38]
PSMS          3-1 PSDS
  [Saktiawan Sinaga 15, Alejandro Tobar 42, Alcidio Fleitas 70;
   Jeremy Espinosa 30]

[Jan 17]
Persija       0-1 Semen Padang
  [Matias Santiago 69]
Persikota     1-0 Sriwijaya
  [Aliyudin 82pen]
[Jan 18]
Persib        0-1 Persijap
  [Mulyono Geroda 87]
PSIM          1-2 PSIS
  [Seto Nurdiyanto 81; G.H. Ortiz 55, Emmanuel de Porras 56]
Arema         3-0 Persitara
  [Aris Budi Prasetyo 30, Firman Utina 58, Alexander Pulalo 66]
Persekabpas   1-1 Persita
  [Ullian Souza 90; Lubis Syuku 21]

[Jan 21]
PSMS          2-1 Persib
  [Supardi 12, Alcidio Fleitas 17pen; Cucu Hidayat 80]
PSDS          1-1 PSIM
  [Kalima Jean 38; Michel Adolfo Souza 46]
[Jan 22]
PSIS          1-1 Arema
  [Hari Salisburi 85]
Persijap      0-0 Persekabpas

[Jan 24]
PSMS          5-2 PSIM
  [Alcidio Fleitas 14pen, 65, Saktiawan Sinaga 27, Alejandro Tobar 72,
   I Nyoman Adyana 84; M. Adolfo Sousa 20, 54]
PSDS          4-1 Persib
  [Ade Chandra Kirana 5, Zulkarnain 16, Tommy Pranata 20,
   Anorue W. Obiora 84; Dicky Firasat 46]
[Jan 25]
Semen Padang  1-1 Sriwijaya
  [Mathias Santiago 48; Isoewardi 57]
PSIS          0-1 Persekabpas
  [Ullian Souza 6]
Persijap      1-1 Arema
  [Ayouck Berty 1; Joao Carlos 52]

[Jan 28]
Persita       0-1 Persija
  [Francis Yonga 50]
Persitara     0-1 Persikota
  [Aliyudin 90]

[Jan 31]
Persita       0-0 Persikota
Persitara     1-2 Persija
  [Jean Paul Boumsong 63; Francis Yonga 42, Roger Batoum 75]

[Feb 4]
Arema         1-1 PSMS
  [Mbom Julien 41; Mahyadi Panggabean 63]
Persekabpas   3-0 PSDS
  [Murphy K. 70, Ullian Souza 81, Alfredo Fernando 90]
[Feb 5]
PSIM          0-2 Persib
  [Zaenal Arif 69, Gendut Doni 90]
Sriwijaya     1-0 Persita
  [Moses Nyeman 77]
Semen Padang  1-0 Persitara
  [Niane Mamadou]
Persija       0-1 PSIS
  [Greg Nwokolo 65]
Persikota     2-1 Persijap
  [Lenglolo Christian 25, Ari Priatna 86; Ayouck Berty 49]

[Feb 7]
Arema         3-0 PSDS
  [Marthen Tao 3, Anthony Jommah Ballah 40, 79]
Persekabpas   3-1 PSMS
  [Francisco Rotuno 2, Andik Ardiansyah 28, 88; Alcidio Fleitas 1pen]
[Feb 8]
Persija       1-0 Persijap
  [Frank Seator 36]
Semen Padang  1-1 Persita
  [Niane Mamadou 44; Bruno J. Zandonadi 9]
Sriwijaya     1-0 Persitara
  [Isoewardi 79]
Persikota     1-1 PSIS
  [Ndolar Blaise 39; G.H. Ortiz 87]

[Feb 11]
Persib        1-0 Arema
  [Redouane Barkaoui 56]
PSIM          2-0 Persekabpas
  [Nurcholis Majid 69, Seto Nurdiyantoro 87]
[Feb 12]
PSIS          2-1 Sriwijaya
  [Emmanuel de Porras 36, Gustavo Hernan Ortiz 83; Steven Mennoh 63]
Persijap      1-0 Semen Padang
  [Jimmy Suparno 41]

[Feb 14]
Persib        3-2 Persekabpas
  [Redouane Barkaoui 2, 65, Zainal Arif 84; Zah Rahan 28, 76]
PSIM          0-1 Arema
  [Emaleu Serge 20]
[Feb 15]
PSIS          0-0 Semen Padang
Persijap      0-0 Sriwijaya

[Feb 18]
PSMS          2-0 Persija
  [Saktiawan Sinaga 10, Wanderson Silva 78]
[Feb 19]
PSDS          0-0 Persikota 

[Feb 21]
Persita       1-0 Persitara
  [Bruno Zandonadi 34]
[Feb 22]
PSMS          1-0 Persikota
  [Saktiawan Sinaga 54]
PSDS          0-1 Persija
  [Hamka Hamzah 81]

[Feb 25]
Persita       3-2 PSIS
  [Putut Waringin Jati 12, Isnan Ali 30, Augusto Cesar da Silva 63; 
   Gustavo Hernan Ortiz 18, Imral Usman 65]
Persitara     1-1 Persijap
  [Jeremi Pekey 48; Evaldo da Silva 20]
[Feb 26]
Sriwijaya     2-0 PSMS
  [(Emeka Okoye 14, Anthony 58]
Semen Padang  1-1 PSDS
  [D. Abdolaye Djibril 66; Rodrigo Santoni 46]
Persija       0-0 Persib
Persikota     4-3 PSIM
  [Cristian Lenglolo 13, 24, 59, Amarildo Souza 54; Fajar Listiyantoro 30,
   Esaiah Pello Benson 79pen, Jaime Sandoval 90]
Arema         3-0 Persekabpas
  [Franco Hitta 16, 87, Emaleu Serge 67]

[Feb 28]
Persita       2-2 Persijap
  [Fabrizio Rogerio 17, 27; Evaldo da Silva 15, Lourival Junior Lima 83]
Persitara     2-1 PSIS
  [Jeremi Pekey 14, J.P. Boumsong 74; Emanuel de Porras 48]
[Mar 1]
Semen Padang  2-0 PSMS
  [Niane Mamadou 27, 72]
Persija       0-0 PSIM
Sriwijaya     2-0 PSDS
  [Patricio Jimenez 36, Emeka Obidiah 80]

[Mar 4]
Persikota     0-0 Persib

[Mar 11]
Persib        0-0 Sriwijaya
PSIM          2-0 Semen Padang
  [Adolfo Souza 32, Seto Nurdiantoro 34]
PSDS          1-1 Persitara
  [Ngako Elongo Serge 57; Boumsong J.P. 8]
[Mar 12]
PSMS          3-1 Persita
  [Mbom Julien 21, Wanderson da Silva 80, Alcidio Fleitas 80;
   Iswadi Syukur 12]
Arema         0-0 Persija
Persekabpas   1-1 Persikota
  [Andik Ardiansyah 86; Aliyudin 28]
Persijap      1-1 PSIS
  [Lourival Lima 85; Hary Salisbury 83]

[Mar 14]
PSIM          1-0 Sriwijaya
  [Pello Benson 60]
Persib        1-0 Semen Padang
  [Redouane Barkawi 74pen]
[Mar 15]
PSMS          0-1 Persitara
  [Javier Rocha 60]
PSDS          2-0 Persita            [also reported 2-1]
  [Rifki Firdaus 29, 72]
Arema         4-1 Persikota
  [Anthony Ballah 10, 35, Emeleu Serge 37, Alberto 75og; Ndolar Blaise 71]
Persekabpas   abd Persija            [abandoned at 1-0 at half-time]
  [Joao Bosco Cabral 35]

[Mar 18]
Persita       2-1 Persib
Persitara     1-2 PSIM 
[Mar 19]
PSIS          1-0 PSMS
Persijap      2-1 PSDS

[Mar 21]
Persikota     3-3 Persija 
  [Aliyudin 3, Ndolar Blaise 38, Ari Priatna 68; Roger Batoum 62,
   Hamka Hamzah 70, Frank Seator 83]
[Mar 22]
PSIS          3-1 PSDS 
  [Herry Salisbury 33, Fofe Kamara 87, Emanuel de Porras 89;
   Mahmud Azis 35]
Persitara     3-1 Persib
  [Javier Rocha 24pen, Richardo B. 39, J.P. Boumsong 75;
   Dicky Firasat 36] 
Persita       1-1 PSIM 	
  [Bruno Zandonadi 87; Esaiah Pello Benson 41]
Persijap      0-1 PSMS 
  [Mbom Julien 18]

[Mar 28]
Sriwijaya     1-1 Arema  
  [Patricio Jimenez 89; Emaleu Serge 44]
Semen Padang  2-1 Persekabpas 
  [Octavianus 3, Matias Santiago 79; Andik Ardiansyah 84]

[Apr 1]
Sriwijaya     2-2 Persekabpas
  [Andi Odang 48, Nico Susanto 89; Francisco Rotuno 17, Alfredo Figueroa 59]
Semen Padang  1-2 Arema
  [Matias Santiago 31; Franco Hita 16, Aris Budi Prasetyo 46]

[Apr 8]
PSIS          1-1 Persib
  [Maman Abdurrachman 86; Redouane Barkaoui 21]
Persijap      1-0 PSIM
  [Francis Yonga 44]
[Apr 9]
Semen Padang  3-1 Persikota
  [Matias Santiago 12, 73, Djibril 24; Zaenal Anwar 48]
Persekabpas   1-0 Persija
  [Ulian Souza 9]

[Apr 11]
PSIS          2-1 PSIM
  [Indriyanto Nugroho 39, Emmanuel De Porras 73; Jaime Sandoval 86]
Persijap      1-1 Persib
  [Wahyu Wahab 90; Zainal Arief 35]
[Apr 12]
Sriwijaya     1-0 Persikota
  [Frank Seator 25]
Semen Padang  0-0 Persija

[Apr 16]
Sriwijaya     0-1 Persija
  [Roger Batoum 79]
Persib        0-2 PSMS
  [Alejandro Tobar 15, Saktiawan Sinaga 19]
PSIM          1-0 PSDS
  [Michel Adolfo Souza 2]
Persita       0-0 Arema
Persitara     1-3 Persekabpas
  [Dedi Mulyadi 68; Andik Ardyansyah 25, 76, Alejandro Figueroa 86]

[Apr 19]
Persib        1-2 PSDS
  [Zaenal Arif 74; Pedro Javier Velázquez 35, Anorue Obiora 82]
PSIM          2-1 PSMS
  [Seto Nurdiyantoro 10, Jaime Sandoval 40; Imam Faisal 61]
Persita       1-1 Persekabpas
  [Rahel Tuasalamony 89; Andik Ardiansyah 16]
Persitara     1-1 Arema
  [Juan Felix Boumsong 63; Anthony Jommah Ballah 26]

[Apr 22]
Persija       3-0 Persita 
  [Abanda Herman 4, Hamka Hamzah 24, Ismed Sofyan 83]
Persikota     3-2 Persitara 
  [Amarildo Souza 53, Ari Priatna 72, Aliyudin 76; Hariman Siregar 35,
   Javier Roca 89]
[Apr 23]
Sriwijaya     1-0 Semen Padang
  [Nico Susanto 11]

[Apr 25]
Persija       1-1 Persitara
  [Eric Mebenga 27; Adrian Colombo 35]
[Apr 26]
Persikota     0-1 Persita
  [Jainal Ichwan 54]

[Apr 29]
PSIS          1-0 Persija
  [M. Ridwan 86]
[Apr 30]
Persijap      6-1 Persikota
  [Francis Wolo 3, 10, Francis Yonga 60, Evaldo Silva 74, 81, 86;
   Alberto 6]
PSDS          0-1 PSMS
  [Alejandro Tobar 60]

[May 2]
Persib        1-1 PSIM
  [Antonio Claudio 71; Adolfo Souza 80]
[May 3]
PSIS          2-0 Persikota
  [GH Ortiz 32, Miguel A. 59]
Persijap      2-2 Persija
  [Paithoon Thiabma 42, Wahyu Wahab 88; Ortizan Solossa 32, 82]

[May 6]
Persita       1-1 Sriwijaya
  [Ilham Jayakesuma 30; Frank Seator 64]
Persitara     2-1 Semen Padang
  [Javier Rocha 1pen, Lubis Syukur 84; Niane Mamadou 22]

[May 9]
Persita       3-0 Semen Padang
  [Supriyono 6pen, Putut Waringin Jati 21, 43]
Persitara     1-0 Sriwijaya 
  [Adrian Colombo 19]
[May 10]
Persija       1-0 PSMS
  [Eric Mebenga 72]
Arema         1-0 PSIS
  [Franco Martin Hita 56]
Persekabpas   1-0 Persijap
  [Zah Rahan Krangar 30]
Persikota     6-0 PSDS
  [Lenglolo 9, 90, Zainal Anwar 34, Aliyudin 50, Amarildo Souza 64, 72]

[May 13]
Arema         3-0 Persijap
  [Aris Budi 24, Emaleu Serge 36, Franco Hitta 55]
Persekabpas   2-0 PSIS
  [Murphy Kumonple 25, Siswanto 67]
[May 14]
Persija       1-0 PSDS
  [Erick Mabenga 52]
Persikota     2-0 PSMS
  [Aliyudin 64, Lenglolo 75]
Persitara     2-1 Persita
  [Adrian Colombo 35, Lubis Syukur 39; Ilham Jayakesuma 6]

[May 20]
Sriwijaya     1-1 PSIS
  [Andi Odang 16; M. Ridwan 10]
Semen Padang  1-0 Persijap
  [Leonardo Javier 41]
Persib        1-1 Persija
  [Hamka Hamzah 14; Zainal Arif 85]
PSIM          2-1 Persikota
  [Fajar Listiyantoro 62, Michel Adolfo Souza 67; Ndolar Blaise 34]
PSDS          2-1 Persekabpas
  [Rodrigo Alejandro 32, Pedro Javier 81; Murphy Kumonple 75]
[May 21]
PSMS          2-1 Arema
  [Alejandro Tobar 18pen, Kusaeri 49; Leonard Soputan 88]

[May 23]
Sriwijaya     3-1 Persijap
  [Wijay 35, Frank Seator 68, 75; Evaldo Silva 56pen]
Semen Padang  1-0 PSIS
  [Budi Kurnia 39]
[May 24]
Persib        2-1 Persikota
  [Dicky Firasat 36, Zaenal Arif 57; Amarildo Souza 63]
PSIM          1-2 Persija
  [Adolfo 6; Roger Batoum 21, Oscar Aravena 73]
PSMS          0-0 Persekabpas
PSDS          1-1 Arema
  [Emmanuel Obiora 67; Marthen Tao 47]

NB: PSIM withdrew for their remaining matches due to the eartquake
    in Central Java; all those matches were awarded 0-3 to their
    opponents

[May 27]
PSIS          2-0 Persita
  [Miguel Angel 48, Emanuel de Porras 74]
Persijap      1-0 Persitara
  [Francis Yonga 1]
[May 28]
Arema         abd Persib             [abandoned at 2-0 in 28']
  [Emaleu Serge 6, Antoni Jommah Ballah 24]
Persekabpas   awd PSIM               [awarded 3-0]
PSMS          2-2 Sriwijaya
  [Alejandro Tobar 26', Greg Nwokolo 71; Reswandi 33og, Andi Odang 60]
PSDS          2-0 Semen Padang
  [Ansyari Lubis 23, Kilama Jean 38]
[May 29]
Arema         3-1 Persib             [remaining 62']
  [Emaleu Serge 6, Anthony Jommah Ballah 24, Marthen Tao 75;
   Charis Yulianto 67]

[May 30]
PSIS          5-0 Persitara
  [Imral Usman 4, G.H. Ortiz 27, Emanuel de Porras 48, 65, Zoubairoe 82]
Persijap      1-0 Persita
  [Lourival Lima 64]
[May 31]
Arema         awd PSIM               [awarded 3-0]
PSMS          1-0 Semen Padang
  [Greg Nwokolo 27]
PSDS          3-2 Sriwijaya
  [Pedro Javier 40, 46, Rodrigo Alejandro 42; Frank Seator 22, Andi Odang 84]
[Jun 3]
Persekabpas   1-0 Persib
  [Siswanto 74]

[Jun 7]
Persekabpas   1-2 Arema
  [Ullian Souza 1; Emaleu Serge 65, Marthen Tao 79]

[Jun 10]
Persita       1-0 PSMS
  [Stephen Menoch 34pen]
Persitara     3-0 PSDS
  [Dedi Mulyadi 25, Javier Rocha 41, Lubis Syukur 90]
[Jun 11]
Persija       1-0 Arema
  [Roger Batoum 10pen] 
Persikota     2-1 Persekabpas
  [Aliyudin, C. Lenglolo; Ullian Souza (pen)]
Sriwijaya     0-0 Persib
PSIS          2-0 Persijap
  [GH Ortiz 10, Imral Usman 53]
Semen Padang  awd PSIM               [awarded 3-0]

[Jun 13]
Persita       2-1 PSDS
  [Ilham Jayakesuma 26, Supriyono 56; Ricky Firdaus 44]
Persitara     2-1 PSMS
  [Keita Boubacar 24, Javier Roca 27; Legimin Raharjo 13]
[Jun 14]
Semen Padang  0-1 Persib
  [Cucu Hidayat 58]
Persija       2-0 Persekabpas
  [Ismed Sofyan 36, Eric Mebenga 72]
Persikota     2-1 Arema
  [Aliyudin 9, Alberto 11; Anthony Jommah Ballah 38]
Sriwijaya     awd PSIM               [awarded 3-0]

[Jun 20]
PSMS          2-0 PSIS
  [Alcidio Fleitas 6, 14]
[Jun 21]
PSDS          3-1 Persijap
  [Ansyari Lubis 1, Ari Yuganda 19, Anorue Obiora 39; Evaldo Silva 59pen]
Arema         1-1 Sriwijaya
  [Emaleu Serge 34; Andi Odang 89]
Persekabpas   1-0 Semen Padang
  [Ahmad Junaedi 79]
Persib        2-0 Persita
  [Charis Yulianto 44, Eka Ramdani 86]
PSIM          awd Persitara          [awarded 0-3]

[Jun 24]
Persekabpas   3-2 Sriwijaya
  [Zah Rahan 3, Ullian Souza 44, Ahmad Junaedi 69; Nico Susanto 12,
   Novianto 26]
PSMS          0-1 Persijap
  [Danan Puspito 26]
Arema         1-0 Semen Padang
  [Aris Budi Prasetyo 15]
Persija       1-0 Persikota
  [Oscar Aravena 28]
Persib        0-1 Persitara
  [Adrian Colombo 36] 
PSDS          6-0 PSIS
  [Pedro Javier 9, 46, 67, Ansyari Lubis 49, 73, Anorue Obiora 50]
PSIM          awd Persita            [awarded 0-3]

Final Table:

 1.Arema (Malang)                  26  13  8  5  39-17  47  Qualified
 2.Persija (Jakarta)               26  13  8  5  26-16  47  Qualified
 3.PSIS (Semarang)                 26  13  5  8  33-27  44  Qualified
 4.Persekabpas (Pasuruan)          26  12  6  8  35-27  42  Qualified
 - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
 5.PSMS (Medan)                    26  12  3 11  31-27  39
 6.Sriwijaya FC (Palembang)        26   8 10  8  29-24  34
 7.Persikota (Kabup. Tangerang)    26   9  7 10  34-37  34
 8.Persitara (Jakarta Utara)       26  10  4 12  29-34  34  [*]
 9.Persijap (Jepara)               26   8  9  9  25-27  33
10.Persita (Tangerang)             26   8  8 10  25-30  32
11.Semen Padang                    26   8  6 12  20-24  30
12.Persib (Bandung)                26   7  8 11  23-30  29
----------------------------------------------------------
13.PSDS (Lubuk Pakam)              26   8  5 13  32-41  29
14.PSIM (Yogyakarta)               26   7  5 14  23-43  26  [!]

[!] PSIM had their last 6 matches awarded 0-3 against them following
    their withdrawal after the earthquake in Central Java
[*] play home matches in Cilegon

NB: no teams relegated as top level extended from 28 to 36 clubs for 2007.

Wilaya Timur (East)
Authors: Karel Stokkermans (karel@rsssf.com),
Novan Herfiyana
(novanmedia@yahoo.com)
and Feri Istanto
(maspei@yahoo.com)

Last updated: 22 Feb 2013

(C) Copyright Karel Stokkermans, Novan Herfiyana, Feri Istanto 
and RSSSF 2006/13


  USO DE MEMORIA  
4,266,080 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0018
Controller Execution Time ( Home / Category )  0.1010
Total Execution Time  0.1028
  CADENA URL  
/liga_indonesia2006
  GET DATOS  
$_GET['/liga_indonesia2006']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (26)  
0.0023  SELECT type FROM routes WHERE alias = 'liga_indonesia2006'
0.0052  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'liga_indonesia' AND (l.group_code = 1 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 2006 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=1 DESC LIMIT 1
0.0022  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=333 AND type_rel = 3
0.0032  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 3 AND rel.typeId = 333 AND rel.ln = 'es' AND rel.status=1 ORDER BY rel.creation_date desc,rel.cover_points DESC LIMIT 5
0.0039  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 (1238086,1235961,1234022,1220135,1198661) ORDER BY n.cover_points DESC, update_date DESC
0.0026  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 = 30618 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0026  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='2006' WHERE c.parentId=333 GROUP BY c.id ORDER BY c.order_id ASC
0.0022  SELECT type,rule FROM rules WHERE categoryId = 333 ORDER BY type = 'tables_draw' DESC,type != 'extra' DESC, `order` ASC
0.0023  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-04-27 23:26:50' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0022  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=2 AND last_update > '2024-04-27 23:26:50' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0023  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=4 AND last_update > '2024-04-27 23:26:50' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0025  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=3 AND last_update > '2024-04-27 23:26:50' GROUP BY url ORDER BY page_views DESC LIMIT 5
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_indonesia' AND (l.group_code = 0 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 2006 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=0 DESC LIMIT 1
0.0031  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=30618 AND rel.round=26
0.0025  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 = 30618 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 = 30618 AND esl.points > 0
0.0021  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-29" AND c.`active`= 1 and c.comment_id is null and c.lang = 1 AND l.`id` = 30618 ORDER BY creation_date DESC LIMIT 0, 10
0.0040  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-29" AND c.`active`= 1 and comment_id is null and c.lang = 1 AND l.`id` = 30618
0.0031  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 `calendars2006` 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` = 30618 AND c.`round` = 26 ORDER BY shedule ASC LIMIT 200
0.0031  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 `events2006` e INNER JOIN calendars2006 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 = 26 AND e.real_date IS NOT NULL AND e.league_id = 30618 ORDER BY total DESC LIMIT 40
0.0031  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 `events2006` e INNER JOIN calendars2006 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 = 30618 AND e.real_date > NOW() - INTERVAL 1 MONTH ORDER BY e.real_date DESC LIMIT 30
0.0042  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 `tables2006` 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 = 30618 AND t.round = 24 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0024  SELECT *,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables2006` 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 = 30618 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0018  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-28 00:00:00' AND c.`shedule` < '2024-05-02 23:59:59' AND l.id = 30618 ORDER BY c.shedule ASC, fcoef DESC LIMIT 5
0.0031  SELECT data1, data2 FROM services_tags WHERE categoryId=333
0.0031  SELECT group_code, extraName from `leagues` WHERE categoryId=333 AND year=2006