4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
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,300,208 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0020
Controller Execution Time ( Home / Category )  0.4465
Total Execution Time  0.4485
  CADENA URL  
/3_lig_turquia2006/grupo1/historico
  GET DATOS  
$_GET['/3_lig_turquia2006/grupo1/historico']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (21)  
0.0144  SELECT type FROM routes WHERE alias = '3_lig_turquia2006'
0.0308  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 = 2006 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=1 DESC LIMIT 1
0.0145  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=360 AND type_rel = 3
0.0146  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.0158  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.0152  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 = 50230 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0153  SELECT id,year,current_round,total_teams,legend FROM leagues WHERE categoryId = 360 AND group_code = 1 and tables = 1 AND year <= 2006 AND total_num_tablesR >= 1 ORDER BY year DESC LIMIT 22
0.0153  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.0164  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.0167  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.0156  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.0149  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-05-04 20:01:30' 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-04 20:01:30' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0150  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=4 AND last_update > '2024-05-04 20:01:30' 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-04 20:01:30' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0162  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 = 2006 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=0 DESC LIMIT 1
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 events2006 e ON e.player_id = p.id AND e.league_id = 50230 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 50230 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.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 events2006 e ON e.player_id = p.id AND e.league_id = 50230 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 50230 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 events2006 e ON e.player_id = p.id AND e.league_id = 50230 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 50230 AND (e.action = 3 or e.action = 4) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0176  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 = 50230 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC