4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Ver
TEMPORADA 2009/2010
Equipo PJ GF GC Puntos
1 Balikesirspor Balikesirspo 20 40 13 43
2 Bandirmaspor Bandirmaspor 20 35 9 42
3 Gaziosmanpasaspor Gaziosmanpas 20 28 21 37
4 Bursa Niluferspor Bursa 20 32 17 34
5 Lüleburgazspor Lüleburgazs 20 36 19 33
6 Inegolspor Inegolspor 20 22 23 27
7 Yeşil Bursa Yeşil Bursa 20 24 24 23
8 Alibeykoyspor Alibeykoyspo 20 13 16 23
9 Bayrampasaspor Bayrampasasp 20 22 29 18
10 Cerkezköy Belediyespor Cerkezköy 20 21 40 18
11 Kucukkoyspor Istanbul Kucukkoyspor 20 12 74 3
Ver
TEMPORADA 2008/2009
Equipo PJ GF GC Puntos
1 Tepecik Belediyespor Tepecik 18 31 22 38
2 Lüleburgazspor Lüleburgazs 18 29 15 35
3 Golcukspor Golcukspor 18 27 17 34
4 Yalovaspor Yalovaspor 18 32 18 33
5 Anadolu Uskudar 1908 Anadolu 18 27 22 27
6 Fatih Karagümrük Fatih 18 24 25 22
7 Orhangazi Genclerbirligi Orhangazi 18 17 24 21
8 Yeşil Bursa Yeşil Bursa 18 12 18 20
9 Yildirim Bosna Yildirim 18 9 23 12
10 Kucukkoyspor Istanbul Kucukkoyspor 18 13 37 8
Ver
TEMPORADA 2007/2008
Equipo PJ GF GC Puntos
1 Yeni Malatyaspor Yeni 30 46 28 52
2 Vanspor FK Vanspor FK 30 43 26 52
3 Karsspor Karsspor 30 38 25 49
4 Şırnakspor Şırnakspor 30 34 25 46
5 72 Batman Spor Batman Spor 30 40 34 44
6 Belediye Bingölspor K. Belediye 30 28 33 44
7 Aksarayspor Aksarayspor 30 47 34 43
8 Ceyhanspor Adana Ceyhanspor 30 36 33 40
9 Siirtspor Siirtspor 29 33 32 40
10 Batman Petrolspor Batman 29 40 34 39
11 Kayapınar Belediyespor Kayapınar 29 35 32 38
12 Kilis Belediyespor Kilis 29 29 41 38
13 İskenderun Belediyesi İskenderun 30 31 35 36
14 Nusaybin Demirspor Nusaybin 30 39 51 36
15 Cizrespor 2010 Cizrespor 30 19 44 32
16 Mezitlispor Mezitlispor 30 24 55 18
Ver
TEMPORADA 2006/2007
Equipo PJ GF GC Puntos
1 Amedspor Amedspor 30 57 20 60
2 Mezitlispor Mezitlispor 30 43 26 55
3 Adanaspor Adanaspor 29 52 16 54
4 Aksarayspor Aksarayspor 29 36 27 52
5 72 Batman Spor Batman Spor 29 41 28 50
6 Batman Petrolspor Batman 29 37 33 47
7 Yeni Ereğlispor Yeni 30 33 30 47
8 Şırnakspor Şırnakspor 30 44 32 45
9 Vanspor FK Vanspor FK 30 47 35 44
10 Nusaybin Demirspor Nusaybin 30 36 40 42
11 Ceyhanspor Adana Ceyhanspor 30 36 44 37
12 Kilis Belediyespor Kilis 30 25 41 33
13 Kayapınar Belediyespor Kayapınar 30 29 36 28
14 İskenderun Belediyesi İskenderun 30 25 46 26
15 Osmaniyespor Kulübü Osmaniyespor 30 23 64 24
16 Karamanspor Karamanspor 30 16 62 14
Ver
TEMPORADA 2005/2006
Equipo PJ GF GC Puntos
1 Erzincanspor Erzincanspor 29 60 19 69
2 Gaskispor Gaskispor 30 74 23 64
3 72 Batman Spor Batman Spor 30 44 26 55
4 Kilis Belediyespor Kilis 30 46 42 50
5 Mezitlispor Mezitlispor 30 59 47 45
6 Şırnakspor Şırnakspor 30 39 41 40
7 Karamanspor Karamanspor 30 35 35 38
8 Amedspor Amedspor 30 55 49 37
9 Kayapınar Belediyespor Kayapınar 30 36 35 36
10 Karsspor Karsspor 29 29 26 35
11 İskenderun Belediyesi İskenderun 30 38 38 35
12 Ceyhanspor Adana Ceyhanspor 30 32 54 34
13 Nusaybin Demirspor Nusaybin 30 26 50 31
14 Iğdırspor Iğdırspor 30 37 62 30
15 Bitlis Özgüzelderespor Bitlis 30 28 53 30
16 Nevşehir Belediyespor Nevşehir 30 32 70 29
Ver
TEMPORADA 2004/2005
Equipo PJ GF GC Puntos
1 Körfez İskenderunspor Körfez 30 55 19 64
2 Nevşehir Belediyespor Nevşehir 30 58 26 57
3 Bitlis Özgüzelderespor Bitlis 30 54 29 57
4 Ceyhanspor Adana Ceyhanspor 29 49 27 54
5 İskenderun Belediyesi İskenderun 30 52 38 48
6 Gaskispor Gaskispor 30 57 37 46
7 Mezitlispor Mezitlispor 30 36 24 45
8 Amedspor Amedspor 30 41 35 42
9 Kilis Belediyespor Kilis 30 40 38 42
10 72 Batman Spor Batman Spor 30 36 34 38
11 Şırnakspor Şırnakspor 30 36 39 36
12 Iğdırspor Iğdırspor 30 32 52 33
13 Nusaybin Demirspor Nusaybin 30 29 37 32
14 Kayapınar Belediyespor Kayapınar 30 41 60 31
15 Muş Spor Muş Spor 30 24 48 28
16 Niğdespor Niğdespor 29 12 109 6
Ver
TEMPORADA 2003/2004
Equipo PJ GF GC Puntos
1 Karamanspor Karamanspor 30 67 15 71
2 72 Batman Spor Batman Spor 30 61 19 68
3 Gaskispor Gaskispor 30 56 19 60
4 Muş Spor Muş Spor 30 47 19 57
5 DC Divrigispor Divrigispor 30 60 19 56
6 Niğdespor Niğdespor 30 46 29 51
7 Akşehirspor Akşehirspor 31 57 31 50
8 Kilis Belediyespor Kilis 30 50 27 50
9 Kayapınar Belediyespor Kayapınar 30 42 35 47
10 Amedspor Amedspor 30 51 35 46
11 Nusaybin Demirspor Nusaybin 30 43 31 44
12 Ceyhanspor Ceyhanspor 30 32 39 41
13 Bitlis Özgüzelderespor Bitlis 31 43 46 38
14 Şırnakspor Şırnakspor 30 30 51 30
15 Silopi Cudispor Silopi 30 15 123 7
16 Yozgatspor Yozgatspor 30 6 84 6
17 Hakkari Spor Hakkari Spor 30 3 87 3
Ver
TEMPORADA 2002/2003
Equipo PJ GF GC Puntos
1 Osmaniyespor Kulübü Osmaniyespor 27 66 28 56
2 Gaskispor Gaskispor 26 51 24 47
3 Amedspor Amedspor 26 37 29 47
4 Ceyhanspor Ceyhanspor 27 43 34 42
5 Kilis Belediyespor Kilis 26 27 27 40
6 Şırnakspor Şırnakspor 26 42 32 39
7 Niğdespor Niğdespor 26 35 32 39
8 72 Batman Spor Batman Spor 26 32 38 39
9 Muş Spor Muş Spor 26 26 26 36
10 Bitlis Özgüzelderespor Bitlis 26 31 41 36
11 Nusaybin Demirspor Nusaybin 26 25 26 35
12 Kayapınar Belediyespor Kayapınar 26 37 37 31
13 Batman Karşıyakaspor Batman 26 25 39 28
14 Vanspor Vanspor 26 27 44 18
15 Ağrıspor Ağrıspor 26 28 75 14

  USO DE MEMORIA  
5,542,576 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0023
Controller Execution Time ( Home / Category )  0.0893
Total Execution Time  0.0916
  CADENA URL  
/3_lig_turquia2010/grupo1/historico
  GET DATOS  
$_GET['/3_lig_turquia2010/grupo1/historico']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (25)  
0.0018  SELECT type FROM routes WHERE alias = '3_lig_turquia2010'
0.0039  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = '3_lig_turquia' AND (l.group_code = 1 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 2010 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=360 AND type_rel = 3
0.0021  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 3 AND rel.typeId = 360 AND rel.ln = 'es' AND rel.status=1 ORDER BY rel.creation_date desc,rel.cover_points DESC LIMIT 5
0.0022  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 (1307337,30416) ORDER BY n.cover_points DESC, update_date DESC
0.0018  SELECT id,name,alias,stepParent FROM categories WHERE parentId=360 ORDER BY order_id ASC
0.0020  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 = 27119 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0022  SELECT id,year,current_round,total_teams,legend FROM leagues WHERE categoryId = 360 AND group_code = 1 and tables = 1 AND year <= 2010 AND total_num_tablesR >= 1 ORDER BY year DESC LIMIT 22
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 `tables2010` 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 = 27119 AND t.round = 22 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
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 `tables2009` 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 = 27155 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 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 `tables2008` 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 = 49306 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0024  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 = 50225 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
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 `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 = 50230 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
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 `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 = 50237 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0024  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 = 50242 AND t.round = 32 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0024  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 `tables2003` 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 = 50246 AND t.round = 28 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0018  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-04-28 12:24:45' 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 12:24:45' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0019  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=4 AND last_update > '2024-04-28 12:24:45' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0019  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=3 AND last_update > '2024-04-28 12:24:45' 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 = '3_lig_turquia' AND (l.group_code = 0 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 2010 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=0 DESC LIMIT 1
0.0022  SELECT e.action, count(e.action) 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 FROM `rel_players` rp INNER JOIN dataplayers p ON p.id = rp.player_id INNER JOIN events2010 e ON e.player_id = p.id AND e.league_id = 27119 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 27119 AND (e.action = 1 or e.action = 2 or e.action = 11 or e.action = 12 or e.action = 13) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0019  SELECT e.action, count(e.action) 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 FROM `rel_players` rp INNER JOIN dataplayers p ON p.id = rp.player_id INNER JOIN events2010 e ON e.player_id = p.id AND e.league_id = 27119 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 27119 AND (e.action = 4 or e.action = 5) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0019  SELECT e.action, count(e.action) 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 FROM `rel_players` rp INNER JOIN dataplayers p ON p.id = rp.player_id INNER JOIN events2010 e ON e.player_id = p.id AND e.league_id = 27119 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 27119 AND (e.action = 3 or e.action = 4) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0032  SELECT *,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables2010` 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 = 27119 AND t.round = 22 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC