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

Liga 1 Indonesia 2007

Información Histórica 
						
Final Table:

 1.Sriwijaya FC (Palembang)        34  20  6  8  59-31  66  Qualified
 2.Persija (Jakarta)               34  18  7  9  55-40  61  Qualified
 3.PSMS (Medan)                    34  17  7 10  44-28  58  Qualified
 4.Persik (Kediri)                 34  17  5 12  61-51  56  Qualified
 - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
 5.Persib (Bandung)                34  15  9 10  45-29  54  Liga Super 2008
 6.Persela (Lamongan)              34  15  9 10  41-34  54  Liga Super 2008
 7.Persitara (Jakarta Utara)       34  15  8 11  39-33  53  Liga Super 2008
 8.Pelita Jaya (Purwakarta)        34  15  7 12  43-30  52  Liga Super 2008
 9.Persita (Tangerang)             34  13 11 10  33-36  50  Liga Super 2008
----------------------------------------------------------
10.PSIS (Semarang)                 34  13 10 11  44-34  49  Liga Super 2008
11.Persikabo (Bogor)               34  12 12 10  46-38  48  Divisi Utama 2008
12.PSS (Sleman, Yogyakarta)        34  12 10 12  42-43  46  Divisi Utama 2008
13.Persema (Malang)                34  12  9 13  35-46  45  Divisi Utama 2008
14.PSDS (Lubuk Pakam)              34  12  8 14  39-40  44  Divisi Utama 2008
15.Persikota (Kabup. Tangerang)    34   6 12 16  26-41  30  Divisi Utama 2008
16.Semen Padang                    34   7  6 21  21-44  27  Divisi Utama 2008
17.Persiraja (Banda Aceh)          34   6  8 20  18-59  26  Divisi Utama 2008
18.PSSB (Bireuen)                  34   6  6 22  26-60  24  Divisi Utama 2008

NB: top-9 clubs from both groups qualify for Liga Super 2008; clubs 10-18
    remain in Divisi Utama (2nd level 2008); PSIS entered Liga Super after
    Persiter and Persmin withdrew or were disqualified

[Feb 10]
Persiraja     1-2 Persib
PSDS          2-0 PSS
PSMS          1-0 PSIS
PSSB          0-1 Persela
Persik        1-0 Sriwijaya FC
Persema       2-0 Persitara
[Feb 11]
Semen Padang  1-2 Persija
Persita       1-0 Persikota
Pelita Jaya   1-0 Persikabo

[Feb 13]
Persiraja     1-1 PSS
PSDS          2-0 Persib
PSMS          2-0 Persela
PSSB          0-0 PSIS
Persik        4-0 Persitara
Persema       0-1 Sriwijaya
[Feb 14]
Persita       1-1 Persikabo
Pelita Jaya   1-1 Persikota

[Feb 17]
PSIS          3-1 Persik
Persela       2-1 Persema
[Feb 18]
Persib        2-0 Persita
PSS           2-1 Pelita Jaya
Persikota     0-2 PSMS
Persikabo     1-0 PSSB
Sriwijaya     4-1 Semen Padang
Persitara     2-1 Persija

[Feb 20]
PSIS          1-2 Persema
Persela       2-1 Persik
[Feb 21]
Persikota     0-2 PSSB
Persikabo     1-1 PSMS
Persib        3-1 Pelita Jaya
PSS           1-1 Persita
[Feb 22]
Sriwijaya     2-1 Persija
Persitara     0-1 Semen Padang

[Feb 24]
Persik        2-1 Persiraja
Persema       1-0 PSDS
[Feb 25]
PSMS          0-0 Sriwijaya 
PSSB          1-0 Persitara
Semen Padang  0-0 Persita
Persija       2-1 Pelita Jaya

[Feb 27]
Persik        3-1 PSDS
Persema       2-0 Persiraja
[Feb 28]
PSMS          1-0 Persitara
PSSB          1-1 Sriwijaya
[Mar 1]
Persita       2-1 PSIS
Pelita Jaya   1-0 Persela

[Mar 3]
Persiraja     2-0 Persikota
PSDS          0-0 Persikabo
[Mar 4]
Sriwijaya     1-0 Persib
Persitara     2-0 PSS
Semen Padang  0-1 PSMS
Persija       3-0 PSSB
Persita       1-0 Persela
Pelita Jaya   1-2 PSIS

[Mar 6]
Persiraja     1-1 Persikabo
PSDS          1-1 Persikota
[Mar 7]
Sriwijaya     1-0 PSS
Persitara     1-1 Persib
Semen Padang  1-0 PSSB
Persija       2-0 PSMS

[Mar 10]
PSIS          2-3 Persela
[Mar 11]
Persib        2-0 Persik
PSS           0-0 Persema
Persikota     1-0 Semen Padang
Persikabo     1-1 Persija
Sriwijaya     1-0 Persitara

[Mar 14]
Persib        4-2 Persema
PSS           0-2 Persik
Persikota     0-0 Persija
Persikabo     3-1 Semen Padang

[Mar 17]
Persik        0-1 Persita
Persema       2-1 Pelita Jaya
PSMS          1-0 Persiraja
PSSB          1-0 PSDS
[Mar 18]
PSIS          2-0 Persikota
Persela       1-1 Persikabo

[Mar 20]
PSMS          1-0 PSDS
PSSB          1-1 Persiraja
[Mar 21]
PSIS          1-0 Persikabo
Persela       1-0 Persikota
[Mar 22]
Persib        2-1 PSS

[Mar 24]
Persita       0-2 Sriwijaya
Pelita Jaya   1-1 Persitara
Semen Padang  2-0 Persik
Persija       3-1 Persema
[Mar 25]
Persiraja     1-0 PSIS
PSDS          1-0 Persela

[Mar 27]
PSMS          2-0 PSSB
Semen Padang  0-1 Persema
[Mar 28]
Persiraja     1-0 Persela
PSDS          3-1 PSIS
[Mar 29]
Persija       2-1 Persik
Persita       3-1 Persitara
Pelita Jaya   2-0 Sriwijaya 

[Mar 31]
Persikota     0-1 Persib
Persikabo     3-2 PSS
[Apr 1]
PSIS          3-0 Semen Padang
Persela       0-2 Persija
Persik        5-0 Persema
Persita       1-0 Pelita Jaya

[Apr 3]
Persikota     0-0 PSS
Persikabo     1-2 Persib
[Apr 4]
PSIS          3-0 Persija
Persela       3-0 Semen Padang
[Apr 5]
Persik        2-2 Pelita Jaya
Persema       2-1 Persita

[Apr 7]
Persib        0-0 PSMS
PSS           2-0 PSSB
Sriwijaya     1-1 Persikota
Persitara     1-0 Persikabo
[Apr 8]
Semen Padang  abd Persiraja          [abandoned at 2-0 in 71' due to rain]
Persija       1-1 PSDS 
[Apr 9]
Semen Padang  3-0 Persiraja          [remaining 19']

[Apr 10]
Persib        3-1 PSSB 
PSS           1-0 PSMS 
Sriwijaya     3-0 Persikabo
Persitara     1-0 Persikota 
[Apr 11]
Semen Padang  2-0 PSDS 
Persija       3-0 Persiraja 

[Apr 14]
PSMS          2-0 Persita 
PSSB          1-3 Pelita Jaya 
Persikabo     2-1 Persema 
[Apr 15]
Persikota     1-2 Persik 
Persiraja     1-2 Sriwijaya 
PSDS          1-2 Persitara 
PSIS          0-0 Persib   
Persela       1-0 PSS  

[Apr 17]
PSMS          1-1 Pelita Jaya 
PSSB          1-1 Persita 
[Apr 18]
Persiraja     0-2 Persitara 
PSDS          2-0 Sriwijaya  
PSIS          1-3 PSS   
Persela       2-1 Persib 
Persikota     1-0 Persema

[Apr 21]
Persik        2-1 PSMS 
Persib        3-0 Semen Padang
PSS           2-1 Persija 
[Apr 22]
Persita       3-1 Persiraja 
Pelita Jaya   1-0 PSDS 
Persema       2-1 PSSB 

[Apr 24]
Persib        3-0 Persija 
PSS           1-0 Semen Padang 
[Apr 25]
Persita       0-0 PSDS   
Pelita Jaya   3-1 Persiraja 
[Apr 26]
Sriwijaya     0-0 PSIS
Persitara     2-2 Persela
Persema       2-1 PSMS

[Apr 28]
Persiraja     0-0 PSDS
Persikota     3-0 Persikabo
[Apr 29]
Sriwijaya     5-1 Persela 
Persitara     1-0 PSIS 
Persik        1-0 PSSB 
Semen Padang  0-1 Pelita Jaya
Persija       2-1 Persita

[May 3]
Persikabo     2-3 Persik 

[Aug 4]
PSDS          3-0 Persiraja
Persita       1-0 Semen Padang
Pelita Jaya   3-0 Persija
PSIS          2-2 Sriwijaya
Persela       0-0 Persitara
[Aug 5]
PSMS          6-1 Persik
PSSB          2-1 Persema

[Aug 7]
Persita       0-3 Persija
Pelita Jaya   0-0 Semen Padang 
PSIS          1-0 Persitara 
Persela       2-2 Sriwijaya FC
[Aug 8]
PSMS          3-0 Persema
PSSB          1-2 Persik             [abandoned at 1-2 in 86'; result stood]
[Aug 9]
Persikabo     3-0 Persikota

[Aug 11]
Persiraja     1-2 Persita
PSDS          1-0 Pelita Jaya
[Aug 12]
Semen Padang  1-1 Persib
Persija       2-1 PSS

[Aug 14]
PSSB          1-2 PSMS
PSDS          2-0 Persita
Persiraja     0-2 Pelita Jaya
[Aug 15]
Semen Padang  0-1 PSS        
[Aug 16]
Persija       1-0 Persib

[Aug 18]
Sriwijaya FC  5-0 Persiraja
Persitara     3-0 PSDS
Persik        2-2 Persikota
Persema       0-0 Persikabo
[Aug 19]
Persita       1-0 PSMS
Pelita Jaya   2-2 PSSB
Persib        0-1 PSIS
PSS           0-0 Persela

[Aug 21]
Persitara     1-0 Persiraja
Sriwijaya FC  4-1 PSDS
Persema       1-0 Persikota
Persik        1-0 Persikabo
[Aug 22]
PSS           2-1 PSIS
Pelita Jaya   2-0 PSMS
Persib        0-0 Persela
Persita       2-0 PSSB

[Aug 25]
Persikota     2-1 Sriwijaya FC
Persikabo     1-1 Persitara
[Aug 26]
PSSB          2-2 PSS
PSMS          1-2 Persib
PSDS          2-0 Persija
Persiraja     0-0 Semen Padang

[Aug 28]
Persikabo     3-0 Sriwijaya FC
Persikota     2-0 Persitara
[Aug 29]
PSDS          3-2 Semen Padang
Persiraja     1-0 Persija
PSMS          abd PSS                [abandoned at 1-0 in 55' due to rain]
[Aug 30]
PSMS          3-1 PSS                [remaining 35']
PSSB          1-2 Persib

[Sep 1]
Persema       1-1 Persik 
[Sep 2]
Persib        0-0 Persikota
PSS           1-1 Persikabo
Semen Padang  0-0 PSIS
Persija       1-0 Persela
Pelita Jaya   0-0 Persita

[Sep 5]
Persib        1-1 Persikabo
PSS           2-0 Persikota
Semen Padang  0-1 Persela
Persija       2-2 PSIS

[Sep 8]
Sriwijaya     2-0 Persita
Persitara     1-0 Pelita Jaya
[Sep 9]
Persela       2-0 PSDS
Persema       0-1 Persija
Persik        2-1 Semen Padang
PSIS          5-0 Persiraja

[Sep 11]
Sriwijaya FC  1-0 Pelita Jaya
Persitara     2-2 Persita
[Sep 12]
PSIS          1-0 PSDS
Persela       3-0 Persiraja
Persik        1-1 Persija
Persema       1-0 Semen Padang

[Oct 17]
Persita       4-3 Persik
[Oct 18]
Persikota     1-1 PSIS
Persikabo     2-1 Persela
Persiraja     1-0 PSMS
PSDS          6-0 PSSB

[Oct 20]
PSS           1-1 Persib
Persita       1-1 Persma
[Oct 21]
Persikota     1-2 Persela
Persikabo     4-1 PSIS
Persiraja     1-0 PSSB
PSDS          1-1 PSMS

[Oct 27]
Persik        6-2 PSS
[Oct 28]
Persema       2-1 Persib

[Oct 30]
Persela       0-0 PSIS
[Oct 31]
Persitara     1-0 Sriwijaya
[Nov 1]
Pelita Jaya   2-0 Persik
[Nov 3]
Persema       1-1 PSS
[Nov 6]
Semen Padang  1-1 Persikota

[Nov 10]
Semen Padang  2-1 Persikabo

[Nov 13]
Persik        2-0 Persib
[Nov 14]
Pelita Jaya   1-0 Persema

[Nov 21]
Persija       2-2 Persikabo
Persela       1-0 Pelita Jaya
[Nov 22]
PSIS          2-0 Persita

[Nov 24]
PSS           3-3 Persitara
[Nov 25]
PSIS          2-1 Pelita Jaya

[Nov 27]
Persela       1-1 Persita
Persib        0-1 Sriwijaya FC
[Nov 28]
PSMS          2-0 Semen Padang
[Nov 29]
Persikota     2-0 Persiraja
Persikabo     4-0 PSDS
PSSB          1-3 Persija

[Dec 1]
Persib        0-1 Persitara
PSS           2-0 Sriwijaya FC
[Dec 2]
PSMS          3-1 Persija
PSSB          2-1 Semen Padang
Persikabo     0-0 Persiraja
Persikota     2-2 PSDS

[Dec 5]
Sriwijaya FC  2-0 PSMS
Persitara     1-0 PSSB
[Dec 6]
Persiraja     1-1 Persik
PSDS          0-0 Persema

[Dec 8]
Sriwijaya FC  4-1 PSSB
Persitara     0-0 PSMS
[Dec 9]
Persiraja     0-0 Persema
PSDS          3-2 Persik

[Dec 11]
PSMS          2-0 Persikota
[Dec 12]
PSSB          1-2 Persikabo
[Dec 13]
Semen Padang  0-1 Sriwijaya FC
Persija       2-1 Persitara
Persik        2-0 PSIS
Persema       2-2 Persela

[Dec 15]
Persita       1-1 Persib
[Dec 16]
PSMS          3-1 Persikabo
PSSB          2-1 Persikota
Persik        4-0 Persela
Persema       1-1 PSIS
Semen Padang  1-0 Persitara
Persija       4-2 Sriwijaya FC

[Dec 19]
Pelita Jaya   2-0 PSS

[Dec 22]
Persija       2-2 Persikota
Pelita Jaya   2-0 Persib
[Dec 23]
Persita       1-0 PSS

[Dec 26]
PSIS          1-1 PSMS
Persela       3-0 PSSB
Sriwijaya FC  5-0 Persik
Persitara     6-1 Persema
[Dec 27]
Persikota     0-0 Persita
Persikabo     2-1 Pelita Jaya
Persib        4-0 Persiraja
PSS           2-1 PSDS

[Dec 30]
Persib        3-0 PSDS
PSS           5-1 Persiraja
Persikota     1-3 Pelita Jaya
Persikabo     2-0 Persita
PSIS          3-0 PSSB
Persela       4-0 PSMS
Sriwijaya FC  3-2 Persema
Persitara     2-1 Persik
Persija       4-0 Semen Padang

Final Table:

 1.Sriwijaya FC (Palembang)        34  20  6  8  59-31  66  Qualified
 2.Persija (Jakarta)               34  18  7  9  55-40  61  Qualified
 3.PSMS (Medan)                    34  17  7 10  44-28  58  Qualified
 4.Persik (Kediri)                 34  17  5 12  61-51  56  Qualified
 - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
 5.Persib (Bandung)                34  15  9 10  45-29  54  Liga Super 2008
 6.Persela (Lamongan)              34  15  9 10  41-34  54  Liga Super 2008
 7.Persitara (Jakarta Utara)       34  15  8 11  39-33  53  Liga Super 2008
 8.Pelita Jaya (Purwakarta)        34  15  7 12  43-30  52  Liga Super 2008
 9.Persita (Tangerang)             34  13 11 10  33-36  50  Liga Super 2008
----------------------------------------------------------
10.PSIS (Semarang)                 34  13 10 11  44-34  49  Liga Super 2008
11.Persikabo (Bogor)               34  12 12 10  46-38  48  Divisi Utama 2008
12.PSS (Sleman, Yogyakarta)        34  12 10 12  42-43  46  Divisi Utama 2008
13.Persema (Malang)                34  12  9 13  35-46  45  Divisi Utama 2008
14.PSDS (Lubuk Pakam)              34  12  8 14  39-40  44  Divisi Utama 2008
15.Persikota (Kabup. Tangerang)    34   6 12 16  26-41  30  Divisi Utama 2008
16.Semen Padang                    34   7  6 21  21-44  27  Divisi Utama 2008
17.Persiraja (Banda Aceh)          34   6  8 20  18-59  26  Divisi Utama 2008
18.PSSB (Bireuen)                  34   6  6 22  26-60  24  Divisi Utama 2008

NB: top-9 clubs from both groups qualify for Liga Super 2008; clubs 10-18
    remain in Divisi Utama (2nd level 2008); PSIS entered Liga Super after
    Persiter and Persmin withdrew or were disqualified

Topscorers:
31 Christian Gonzalez (11 pen) (Persik)
20 Julio Lopez (6 pen) (PSIS)
17 Marcio De Souza (3 pen) (Persela)
16 Bambang Pamungkas (2 pen) Persija)

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 2007/13


  USO DE MEMORIA  
4,269,016 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0021
Controller Execution Time ( Home / Category )  0.1032
Total Execution Time  0.1053
  CADENA URL  
/liga_indonesia2007
  GET DATOS  
$_GET['/liga_indonesia2007']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (37)  
0.0018  SELECT type FROM routes WHERE alias = 'liga_indonesia2007'
0.0044  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 = 2007 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=333 AND type_rel = 3
0.0021  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.0021  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.0020  SELECT text_es as historical_text FROM leagues_text WHERE id=2393
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 = 30619 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='2007' WHERE c.parentId=333 GROUP BY c.id ORDER BY c.order_id ASC
0.0020  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-04-27 19:38:19' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0021  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=2 AND last_update > '2024-04-27 19:38:19' 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 19:38:19' 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 19:38:19' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0044  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 = 2007 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 events2007 e WHERE e.league_id IN (30619) 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 (30619) 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 events2007 e WHERE e.league_id IN (30619) AND (e.action IN (4,5) ) 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 (30619) 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 events2007 e WHERE e.league_id IN (30619) AND (e.action IN (3,4) ) 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 (30619) 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 events2007 e WHERE e.league_id IN (30619) 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 (30619) 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 = 30619 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 = 30619 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=30619 AND rel.round=34
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 = 30619 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 = 30619 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` = 30619 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` = 30619
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 `calendars2007` 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` = 30619 AND c.`round` = 34 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 `events2007` e INNER JOIN calendars2007 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 = 34 AND e.real_date IS NOT NULL AND e.league_id = 30619 ORDER BY total DESC LIMIT 40
0.0023  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 `events2007` e INNER JOIN calendars2007 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 = 30619 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 `tables2007` 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 = 30619 AND t.round = 32 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 `tables2007` 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 = 30619 AND t.round = 34 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-27 00:00:00' AND c.`shedule` < '2024-05-01 23:59:59' AND l.id = 30619 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 = 2007 ORDER BY l.group_code ASC
0.0022  SELECT group_code, extraName from `leagues` WHERE categoryId=333 AND year=2007