4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
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,420,464 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0020
Controller Execution Time ( Home / Category )  0.3985
Total Execution Time  0.4006
  CADENA URL  
/3_lig_turquia2007/grupo1/historico
  GET DATOS  
$_GET['/3_lig_turquia2007/grupo1/historico']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (19)  
0.0150  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=360 AND type_rel = 3
0.0155  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.0162  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.0149  SELECT id,name,alias,stepParent FROM categories WHERE parentId=360 ORDER BY order_id ASC
0.0154  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 = 50225 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0146  SELECT id,year,current_round,total_teams,legend FROM leagues WHERE categoryId = 360 AND group_code = 1 and tables = 1 AND year <= 2007 AND total_num_tablesR >= 1 ORDER BY year DESC LIMIT 22
0.0148  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.0150  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.0149  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.0149  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.0149  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.0145  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-05-01 08:12:41' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0146  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=2 AND last_update > '2024-05-01 08:12:41' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0147  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=4 AND last_update > '2024-05-01 08:12:41' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0149  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=3 AND last_update > '2024-05-01 08:12:41' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0155  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 events2007 e ON e.player_id = p.id AND e.league_id = 50225 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 50225 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.0155  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 events2007 e ON e.player_id = p.id AND e.league_id = 50225 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 50225 AND (e.action = 4 or e.action = 5) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0154  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 events2007 e ON e.player_id = p.id AND e.league_id = 50225 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 50225 AND (e.action = 3 or e.action = 4) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0202  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 = 50225 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC