4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Liga 1 Indonesia 2005
2004/2005

Liga 1 Indonesia 2005

Información Histórica
						
[Mar 5]
PSMS          3-2 PSPS 
  [Cristian Carrasco 15, Cristian A. Gonzales 64, Alejandro Tobar 92;
   Claudio Lizama 17, Rochi Putiray 91]
PSDS          2-1 Semen Padang 
  [Anorue Obiora 7, Suwarno 84; Ebi T. Sukore 46]
Sriwijaya FC  0-1 Persikota 
  [Hari Saputra 30]
Persita       2-0 Persib 
  [Epala Jordan 29, Ilham Jayakesuma 85]
[Mar 6]
Arema         4-0 PSS
  [Francis Yonga 24, Marthen Tao 63, 89, Erol FX Iba 83 (also listed as
   Anderson Da Silva 83og)]
Persija       2-1 PSIS 
  [Agus Indra 26pen, Francis Wewengkang 56; EP Benson 47]

[Mar 8]
PSMS          2-0 Semen Padang 
  [Cristian Carrasco 51, Mario Alberto 58]
PSDS          3-0 PSPS 
  [Anorue Obiora 38, 83, Mustafa Kamal 79]
Sriwijaya FC  1-4 Persib 
  [Rivaldo 32; Yaris Riaydi 30, Suwita Pata 43, Boy Jati Asmara 69, 71]
[Mar 9]
Persija       2-0 PSS 
  [Jainal Ichwan 61, Agus Indra Kurniawan 73pen]
Persita       0-1 Persikota 
  [Aliyudin 36]
Arema         1-0 PSIS 
  [Claudio de Jesus 67]

[Mar 13]
PSPS          1-0 Persija 
  [Gustavo Hernán Ortiz 56]
Semen Padang  1-0 Arema 
  [Steven M. Mennoch 75]
Persikota     3-1 Deltras 
  [Aliyudin 39, 50, Bakrie Umarella 82; Leandro Braga 85pen]
Persib        1-0 Persekabpas 
  [Boy Jati Asmara 31pen]

[Mar 16]
PSPS          1-1 Arema
  [Rochy Putiray 63; Lourival Lima 42] 
Semen Padang  2-3 Persija
  [Affan Lubis 23pen, Gbeneme Friday 47; Ayouk L. Berty 328 
   Diego Albez Caneza 34, 39] 
Persikota     2-2 Persekabpas
  [Aliyudin 62, Bakrie Umarella 67; Supaham 47, Samsudin 80] 
Persib        3-1 Deltras 
  [Ekene Michele Ikenwa 26, 44, 49; Hilton Moreira 52]

[Mar 19]
PSIS          3-1 PSPS 
  [Harry Salisbury 7, 68, M.Ridwan 60; Rochy Putiray 51]
PSS           1-0 Semen Padang
  [Rudy Widodo 89pen] 
Deltras       2-1 Sriwijaya FC 
  [Ebenje Rudolf 59, Hilton Moreira 75; Andi Oddang 69]
Persekabpas   1-0 Persita   
  [Samsudin 85]
[Mar 20]
Persija       2-1 PSMS 
  [Batoum Roger Urbain 45, 74; Cristián Carrasco 35]
Arema         5-1 PSDS 
  [Francis Yonga 5, 13pen, 67, Junior Lima 18, 69; Agangga Serge 45]

[Mar 22]
PSS           0-0 PSPS 
Deltras       1-0 Persita 
  [Luis Gustavo 8]  
Persekabpas   2-1 Sriwijaya FC 
  [Henry Gobah 41, Supaham 57; Franky Suabey 28]
[Mar 23]
Persija       4-0 PSDS 
  [Ismed Sofyan 36, Batoum Roger Urbain 41, Dedy Sutrisno 67,
   Kurniawan DY 69]
Arema         3-1 PSMS 
  [Emaleu Serge 10, 28, Firman Utina 79; Cristián Carrasco 80]
PSIS          1-0 Semen Padang 
  [Emmanuel de Porras 92pen]

[Apr 3]
PSMS          0-0 PSIS 
PSDS          4-1 PSS 
  [Anorue Obiora 30, Agangga Serge 43, 58, Mustafa Kaba 51; M. Ansori 22]
PSPS          1-2 Deltras 
  [Rochy Putiray 15; Michel Adolfo 19, 52]
Semen Padang  1-0 Persekabpas 
  [Pedro Y 85]
Sriwijaya FC  0-1 Persita   
  [Fallah Johnson 22]

[Apr 6]
PSMS          2-0 PSS 
  [Cristián Carrasco 59, Alejandro Tobar 77]
PSDS          1-1 PSIS 
  [Ansyari Lubis 78; A.Jibril 34]
PSPS          1-0 Persikabpas 
  [Moses Nyeman 6]
Semen Padang  3-1 Deltras 
  [Pedro Pasqualez 12, Gbeneme Friday 40, Stephen M. Mennoch 82;
   Hilton Moreira 16]

[Apr 10]
Sriwijaya FC  1-1 PSMS 
  [Masyferi Kasim 80; Heri Swandana 74]
Persita       2-2 PSDS 
  [Zaenal Arif 51, Ilham Jayakesuma 54; Ansyari Lubis 31, Anuore Obiora 40]
Deltras       1-2 Persija 
  [Leandro Braga 51; Batoum Roger 66, 89]
PSIS          3-2 Persikota 
  [Indriyanto Nugroho 39, 70, Emanuel de Porras 68;
   Salim Alaydrus 44, Aliyudin 72]
PSS           0-1 Persib 
  [Boy Jati Asmara 68]

[Apr 13]
Sriwijaya FC  2-1 PSDS
  [Hernan Ariel 26, 29; Agangga Serge 87]
Persita       4-0 PSMS
  [Zaenal Arief 3, Epalla Jordan 26, Ilham Jayakesuma 70, 
   Legimin Raharjo 89og]  
PSIS          3-0 Persib 
  [Khusnul Yakin 18, 79, Yaris Riyadi 30og (also given as Hari Salisbury 30)]
PSS           1-0 Persikota 
  [Denilson da Silva 90]
Deltras       2-2 Arema 
  [Adolfo Souza 10, Leandro Braga 23pen; Joao Carlos 54, Erol F.X. Iba 82]
Persekabpas   1-1 Persija 
  [Gatot Ismawan 51; Jainal Ichwan 10]

[Apr 19]
Persija       1-0 Sriwijaya FC 
  [Batoum Roger Urbain 77]
[Apr 20]
Arema         1-0 Persita 
  [Emaleu Serge 67]            
Persikota     1-0 PSPS 
  [Mardiansyah 68]

[Apr 23]
Arema         1-0 Sriwijaya FC
  [Marthen Tao 51]
PSIS          4-1 PSS
  [Esaiah P. Benson 24, Indriyanto Nugroho 49, Khusnul Yakin 64, M.Irfan 85;
   M.Eksan 69pen]
PSMS          3-1 PSDS
  [Cristián Carrasco 24, Saktiawan Sinaga 62, 70; Yudi Ramandha 61]
[Apr 24] 
Persija       2-0 Persita   
  [Batoum Urbain Roger 19, Diego Caneza 56]
Persikota     1-1 Semen Padang 
  [Salim Alaydrus 88; Stephen Nagbe Menoch 29]

[Apr 26]
Persib        0-0 PSPS
[Apr 27]
Sriwijaya FC  1-1 PSIS 
  [Juan Pablo 22; Esaiah Pello Benson 8pen]
Deltras       1-1 Persekabpas 
  [Hilton Moreira 53; Murphy Kumonple 41]

[Apr 29]
Persib        3-1 Semen Padang 
  [Ekene M, Ikewa 20, 23, 76; Afan Lubis 76]
[Apr 30]
Sriwijaya FC  1-0 PSS 
  [Andi Odang 6]
Persita       1-0 PSIS 
  [Maman 43]

[May 4]
PSIS          2-0 Deltras 
  [Indriyanto Nugroho 22, Emmanuel De Porras 38]
Persita       4-1 PSS 
  [Zaenal Arif 22, 24, 28, Supriyono 25; Da Silva 90]
PSPS          1-2 Semen Padang 
  [Rochi Putiray 42; Pedro J 44, Gbeneme Friday 60]
Persija       2-2 Arema 
  [Ayouck Berty 18, Ortizan Salossa 79; Agus Supriyanto 68og,
   Alexander Pulalo 77]
PSMS          3-0 Persikota 
  [Cristian Carrasco 1, 19, Susanto 31]
PSDS          1-0 Persib 
  [Yudi Ramandha 21]

[May 7]
PSS           3-2 Deltras 
  [Denilson da Silva 28pen, Seto Nurdiyantoro 64, 83; Nur Kholiq 12, 
   Leandro Braga 17pen]
PSMS          0-0 Persib 
PSDS          1-0 Persikota 
  [Albert Watori 39]
[May 8]
PSIS          3-0 Persekabpas 
  [Emanuel de Porras 13, Indriyanto Nugroho 41, Khusnul Yakin 81]

[May 11]
Persikota     0-0 Persib 
PSS           3-0 Persekabpas 
  [Denilson da Silva 13, M.Iksan 42, M.Anshori 45]

[May 17]
Persib        2-0 Arema 
  [Erick Setiawan 28, Ikene Michael Ekhenwa 44]
[May 18]
Persikota     0-1 Persija 
  [Batoum Roger Urbain 49]
Deltras       1-2 PSMS 
  [Michel Adolfo Sousa 52; Alejandro Tobar 11, Cristián Carrasco 86]
Persekabpas   1-0 PSDS 
  [Supaham 62]
PSPS          3-0 Sriwijaya FC 
  [Gustavo Hernan Ortiz 17, Nova Zainal 47, Rochy Putiray 83]
Semen Padang  2-0 Persita   
  [Gbeneme Friday 37, 53]

[May 21]
Persikota     0-0 Arema 
Deltras       3-1 PSDS 
  [Hilton Moreira 40, 68, Michel Adolfo 43; Anorue Obiora 87]
PSPS          2-2 Persita   
  [Gustavo Hernan Ortiz 53pen, Rochy Putiray 57; Franco Hita 55,
   Epala Jordan 82]
Persekabpas   2-0 PSMS 
  [Siswanto 56, Henry (Andre?) Gobah 60]
Semen Padang  1-0 Sriwijaya FC 
  [Pedro Jabier 75]
[May 22]
Persib        1-1 Persija
  [Boy Jati Asmara 30; Ismed Sofyan 72]

[May 25]
Persekabpas   2-1 Arema 
  [Supaham 41, 78; Claudio Jesus 64]

[Jun 18]
Persib        2-0 Persita   
  [Antonio 'Toyo' Claudio 25, Boy Jati Asmara 53pen]
[Jun 19]
PSPS          1-2 PSMS 
  [Rochi Putiray 33; Algidio Pleitas 54, I Komang Adyana 88]
Persikota     1-1 Sriwijaya FC 
  [Aliyudin 59; Emeka 62]

[Jun 22]
PSPS          1-0 PSDS 
  [Rochy Putiray 80]
Persib        1-0 Sriwijaya FC 
  [Yaris Riyadi 37]
Persikota     1-0 Persita   
  [Cesar Bravo 7]

[Jun 26]
Persija       1-0 PSPS 
  [Ortizan Solossa 55]
Arema         1-0 Semen Padang
  [Francis Yonga 75]
Deltras       2-2 Persikota
  [Hilton Moreira 8, Leandro Braga 80pen; Mardiansyah 44,
   Aliyudin 65]
Persekabpas   2-1 Persib
  [Rubén Cecco 47, Supaham 87; Imral Usman 73]

[Jun 29]
Arema         3-0 PSPS 
  [Emaleu Serge 21, 69, Franco Hita 79]
Persija       4-0 Semen Padang 
  [Batoum Roger Urbain 30, Fatecha 42, Ortizan Salossa 44,
   Jaldecir dos Santos 83]
Persekabpas   1-0 Persikota 
  [Ruben Cecco 44]
Deltras       1-0 Persib 
  [Hilton Moreira 52]

[Jul 3]
PSMS          2-1 Persija 
  [Alcidio Fleitas 48, Cristián Carrasco 75; A.Fatecha 52]
PSDS          1-0 Arema
  [Tomi Pranata 82]
PSPS          abd PSIS                   [abandoned at 1-0 in 57' due to pitch
Semen Padang  0-0 PSS                     invasion]
Sriwijaya FC  3-1 Deltras 
  [Renato Elias 14pen, 28pen, Andi Odang 86; Hilton Moreira 55]
Persita       4-0 Persekabpas 
  [Epalla Jordan 32, Gustavo Ortiz 29, Ilham Jayakesuma 47, Isnan Ali 86]
[date?]
PSPS          1-1 PSIS                   [remaining 33'; original award of 0-3
                                          apparently revoked]

[Jul 5]
Persib        3-3 Persikota
  [Ekene Ikenwa 18, 88, Boy Jati Asmara 48; Mardiansyah 39, 59,
   Peri Sah Kolie 42]
[Jul 6]
PSMS          1-0 Arema 
  [Cristián Carrasco 53]
PSDS          1-1 Persija
  [Ansyari Lubis 19; Kurniawan DY 21]
PSPS          1-0 PSS 
  [Rochi Putiray 5]
Semen Padang  0-0 PSIS 
Sriwijaya FC  2-1 Persekabpas
  [Andi Odang 36, 87; Supaham 42]
Persita       2-2 Deltras
  [Epalla Jordan 68, Ilham Jayakesuma 82; Leandro Braga 33, Hilton Moreira 52]

[Jul 10]
PSIS          1-1 PSMS 
  [E. de Porras 23; I Komang Adnyana 53]
PSS           3-1 PSDS 
  [Denilson da Silva 14, 35, T.A. Musafri 23; Yudi Ramanda 68]
Deltras       2-2 PSPS 
  [Hilton Moreira 62, Dani Ananda 90; Ever Barrientos 42, Rolando Espinoza 55]
Persekabpas   2-0 Semen Padang 
  [Ruben Cecco 80, Gatot Ismawan 86]

[Jul 12]
Persita       0-0 Sriwijaya FC 
[Jul 13]
Arema         1-0 Persija
  [Emaleu Serge 14]
PSS           0-0 PSMS 
PSIS          1-0 PSDS
  [Esaiah Pello Benson 5]
Persekabpas   2-1 PSPS 
  [Ruben Cecco 45, Zah Rahman 73; Amrizal 16]
Deltras       1-1 Semen Padang 
  [Nur Kholiq 61; Budi Kurnia 27]

[Jul 24]
PSMS          1-2 Sriwijaya FC 
  [Christian Carasco 77; Jarot 80, Emeka 87]
PSDS          2-2 Persita   
  [Anorue Obiora 46, 88; Supriyono 35, Epalla Jordan 51]
Persija       0-1 Deltras 
  [Leandro Braga 89]
Persikota     1-1 PSIS
  [Aliyudin 12; Emanuel de Porras 75] 
Persib        3-0 PSS 
  [Imral Usman 25, Erick Setiawan 43, Yaris Riyadi 85]

[Jul 27]
PSDS          2-4 Sriwijaya FC 
  [Onoure Obiora 60, 89; Emeka 17, Antonio 53, 54, Franky Suabey 82]
PSMS          1-0 Persita 
  [Christian Carrasco 35pen]  
Persib        0-0 PSIS 
Persikota     0-1 PSS 
  [Ivest Kalamen 56]
Persija       4-2 Persekabpas 
  [Batoum Roger Urbain 11, 20, 38, Lorenzo Cabanas 75; Zah Raban 49,
   Ruben Cecco 65]

[Jul 31]
PSIS          1-0 Persija 
  [E.P. Benson 13]
PSS           1-0 Arema 
  [M. Ansori 26]
PSPS          1-1 Persikota 
Semen Padang  0-0 Persib 

[Aug 3]
PSS           2-0 Persija 
  [Oyebode George 47, Fajar Listiyantoro 57]
PSIS          1-1 Arema 
  [Anthony Jommah Ballah; Marthen Tao]
Semen Padang  0-1 Persikota 
  [Salim Alaydrus 59]
PSPS          4-2 Persib 
  [Rochi Putiray 10, Rodrigo Alejandro 22, Ever Barientos 52,
   Mulyadi 83; Ullian Souza 21, Asep Dayat 80]
PSDS          1-0 PSMS
  [Matheas 55]

[Aug 7]
Semen Padang  2-0 PSDS 
  [Gbeneme Friday 6pen, 75]
PSIS          3-0 Sriwijaya FC 
  [Emanuel de Porras 45, 90, Indriyanto 66]
PSS           0-0 Persita   

[Aug 9]
Arema         2-0 Persekabpas 
  [Franco Hita 23, Emaleu Serge 89]
[Aug 10]
PSS           1-0 Sriwijaya FC
  [M. Iksan 86] 
PSIS          1-1 Persita   
  [Emanuel de Porras 55; Ilham Jayakesuma 28]
Semen Padang  1-0 PSMS 
  [Ebi Sukore 39]

[Aug 12]
Arema         4-1 Deltras 
  [Franco Hitta 15, 24, Emaleu Serge 32, Firman Utina 42;
   Leandro Braga 30pen]

[Aug 16]
Persita       1-1 Arema
  [Nurcholis Majid 84; Francis Yonga 74]
Persib        4-1 PSDS 
  [Ekene Ikenwa 4, 23, 47, 83; Ansyari Lubis 70]
Deltras       2-2 PSIS 
  [Ebenje Rudolf 22, Putut Waringinjati 37; Emanuel de Porras 27, 58]
Persekabpas   2-1 PSS 
  [Cecco Ruben Souza 42, 52; Seto Nurdiyantoro 57]

[Aug 19]
Persita       0-1 Persija 
  [Batoum Roger 68]
[Aug 20]
Sriwijaya FC  2-2 Arema 
  [Andi Odang 70, Joalang 73; Emaleu Serge 35, Marthen Tao 85]
Persikota     3-3 PSDS 
  [Bakrie Umarella 19, Firmansyah 25, 75; Yudi Ramanda 5, 46,
   Toni Pranata 26]
Persekabpas   2-2 PSIS 
  [Alfredo Vera 68pen, Siswanto 75; Indrianto Nugroho 44,
   Hary Salisbury 57]
Deltras       1-0 PSS 
  [Ebenje Rudolf 77]
[Aug 21]
Semen Padang  4-1 PSPS 
  [Gbeneme Friday 6, 81, Ebi Sukhore 12, 46; Nursidik 4og]
Persib        1-1 PSMS 
  [Eka Ramdani 50; Komang Adnyana 6]

[Aug 24]
Sriwijaya FC  1-0 Persija 
Persekabpas   2-1 Deltras 
  [Francisco Rotuno 56, Supaham 88; Leandro Braga 25pen]
Persikota     1-0 PSMS 
  [Aliyudin 64]

[Aug 30]
Persija       4-0 Persikota 
  [Batoum Roger 26pen, 48, Jaldecir dos Santos 44, Mulki 87]
[Aug 31]
Sriwijaya FC  4-1 PSPS
  [Renato Elias 30, 53, Andi Odang 65, 67; Matheus 40] 
Persita       2-0 Semen Padang
  [Epalla Jordan 55, 59] 
PSDS          2-1 Persekabpas 
  [Yudi Ramanda 37, Matheas 75; Zah Rahan 33]
[Sep 1]
Arema         1-0 Persib
  [Emaleu Serge 3] 
PSMS          1-0 Deltras 
  [Alcidio Fleitas 65]

[Sep 4]
Persita       3-2 PSPS 
  [GH Ortiz 23, Maman 62, Epalla Jordan 82; Rochi Putiray 18,
   M. Iqbal 38]
Arema         5-0 Persikota
  [Joao Carlos 32, Emaleu Serge 33, Claudio Jesus 69, Zaenuri 78,
   Gendut Dony 86]
Persija       awd Persib                 [awarded 3-0, Persib dns]
PSS           2-0 PSIS 
  [Anderson da Silva 11, T. Abdul Musyafri 61]
Sriwijaya FC  3-1 Semen Padang 
  [Emeka 15, 25, Renato Elias 59; Nico Susanto 11]
PSDS          0-0 Deltras
PSMS          2-1 Persekabpas
  [Christián Carrasco 9, 72pen; Zah Rahan 56]

Final Table:

 1.Persija (Jakarta)               26  15  4  7  42-21  49  Qualified
 2.Arema (Malang)                  26  13  7  6  42-20  46  Qualified
 3.PSIS (Semarang)                 26  10 12  4  36-21  42  Qualified
 4.PSMS (Medan)                    26  12  6  8  30-26  42  Qualified
 - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
 5.Persib (Bandung)                26  10  8  8  32-26  38
 6.Persekabpas (Pasuruan)          26  11  4 11  30-37  37
 7.PSS (Sleman, Yogyakarta)        26  10  4 12  22-32  34
 8.Persita (Tangerang)             26   8  8 10  31-26  32  [=]
 9.Sriwijaya FC (Palembang)        26   9  5 12  30-34  32  [*]
10.Semen Padang                    26   9  5 12  24-30  32
11.Persikota (Kabup. Tangerang)    26   7 10  9  25-35  31
12.PSDS (Lubuk Pakam)              26   8  6 12  32-45  30
----------------------------------------------------------
13.Delta Putra Sidoarjo            26   7  8 11  33-43  29  Relegation Playoff
14.PSPS (Pekanbaru)                26   6  7 13  29-42  25  Relegation Playoff

NB: PSPS had 3 points deducted for pitch invasion in match vs PSIS on Jul 3,
    but this was later revoked

[*] Persijatim Solo FC were renamed Srijiwaya FC and relocated to Palembang
[=] Persita were originally placed in the eastern group but were
    swapped with Pelita KS after a protest by Persita (the eastern
    group contains the top-2 teams from 2004)

Topscorers:

15 Batoum Roger Urbain (Persija)
   Christián Carrasco (PSMS)
13 Ekene Michael Ikenwa (Persib)
   Emanuel de Porras (PSIS)
12 Rochy Putiray (PSPS)
11 Hilton Moreira (Deltras)
   Onoure Obiora (PSDS)


Wilaya Timur (East)

Authors:
Feri Istanto (maspei@yahoo.com), Novan Herfiyana (novanmedia@yahoo.com) and Karel Stokkermans (karel@rsssf.com) Last updated: 22 Feb 2013 (C) Copyright Feri istanto, Novan Herfiyana, Karel Stokkermans and RSSSF 2005/13


  USO DE MEMORIA  
4,277,048 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0018
Controller Execution Time ( Home / Category )  0.1433
Total Execution Time  0.1451
  CADENA URL  
/liga_indonesia2005
  GET DATOS  
$_GET['/liga_indonesia2005']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (37)  
0.0018  SELECT type FROM routes WHERE alias = 'liga_indonesia2005'
0.0038  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'liga_indonesia' AND (l.group_code = 1 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 2005 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=1 DESC LIMIT 1
0.0019  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=333 AND type_rel = 3
0.0023  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.0025  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.0471  SELECT text_es as historical_text FROM leagues_text WHERE id=2347
0.0018  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 = 30578 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0019  SELECT c.id, c.name, c.alias, c.stepParent, l.year FROM categories AS c INNER JOIN leagues AS l ON c.id=l.categoryId AND l.year='2005' WHERE c.parentId=333 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-28 00:56:38' 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-28 00:56:38' 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-28 00:56:38' 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-28 00:56:38' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0022  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'liga_indonesia' AND (l.group_code = 0 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 2005 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=0 DESC LIMIT 1
0.0018  SELECT e.action, count(e.action) as total, e.player_id FROM events2005 e WHERE e.league_id IN (30578) 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.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 (30578) 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 events2005 e WHERE e.league_id IN (30578) AND (e.action IN (4,5) ) GROUP BY e.player_id ORDER BY total DESC, e.player_id ASC LIMIT 20
0.0017  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 (30578) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN () ORDER BY rp.in_squad = 1 DESC
0.0019  SELECT e.action, count(e.action) as total, e.player_id FROM events2005 e WHERE e.league_id IN (30578) 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 (30578) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN () ORDER BY rp.in_squad = 1 DESC
0.0019  SELECT e.action, count(e.action) as total, e.player_id FROM events2005 e WHERE e.league_id IN (30578) AND (e.action IN (22) ) GROUP BY e.player_id ORDER BY total DESC, e.player_id ASC LIMIT 20
0.0018  SELECT dp.name, dp.last_name, dp.nick,dp.CountryCode,dp.alias,rp.team_id,dt.nameShow,dt.short_name,dt.basealias,rp.player_id,rp.teamId,dp.role FROM dataplayers AS dp INNER JOIN rel_players AS rp ON rp.player_id=dp.id AND rp.league_id IN (30578) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN () ORDER BY rp.in_squad = 1 DESC
0.0018  SELECT rp.lineup as total,p.name, p.last_name, p.nick,p.CountryCode,p.alias,rp.team_id,dt.nameShow,dt.short_name,dt.basealias,rp.player_id,rp.teamId,p.role FROM `rel_players` rp INNER JOIN dataplayers p ON p.id = rp.player_id INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 30578 AND rp.lineup > 0 ORDER BY rp.lineup DESC,p.pod DESC LIMIT 20
0.0017  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 = 30578 AND rp.events > 0 ORDER BY rp.events DESC,p.pod DESC LIMIT 20
0.0021  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=30578 AND rel.round=26
0.0019  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 = 30578 AND esl.points > 0 ORDER BY esl.points DESC LIMIT 3
0.0019  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 = 30578 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-29" AND c.`active`= 1 and c.comment_id is null and c.lang = 1 AND l.`id` = 30578 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-29" AND c.`active`= 1 and comment_id is null and c.lang = 1 AND l.`id` = 30578
0.0019  SELECT c.isVideo, c.id,c.team1, c.team2,c.extra,c.datateam1,c.datateam2,c.type, c.shedule, c.r1, c.r2, c.round, c.comments as total_comentarios, dt1.nameShow as team1_name, dt2.nameShow as team2_name, dt1.basealias as basealias1, dt2.basealias as basealias2,c.betId,c.betId_wh,c.betId_bwin,c.betId_marca,c.betId_888, c.betId_sportium, c.betId_marathon, c.finished, c.penaltis1, c.penaltis2, c.prorroga, c.status, c.minute, dt1.stadium as stadium_name FROM `calendars2005` 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` = 30578 AND c.`round` = 26 ORDER BY shedule ASC LIMIT 200
0.0017  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 `events2005` e INNER JOIN calendars2005 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 = 30578 ORDER BY total DESC LIMIT 40
0.0020  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 `events2005` e INNER JOIN calendars2005 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 = 30578 AND e.real_date > NOW() - INTERVAL 1 MONTH ORDER BY e.real_date DESC LIMIT 30
0.0022  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 `tables2005` 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 = 30578 AND t.round = 24 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0022  SELECT *,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables2005` 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 = 30578 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0022  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 = 30578 ORDER BY c.shedule ASC, fcoef DESC LIMIT 5
0.0022  SELECT data1, data2 FROM services_tags WHERE categoryId=333
0.0022  SELECT l.year,l.group_code FROM leagues_besoccer l WHERE l.categoryId = 333 AND l.year = 2005 ORDER BY l.group_code ASC
0.0022  SELECT group_code, extraName from `leagues` WHERE categoryId=333 AND year=2005