4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Ver
TEMPORADA 1968/1969
Equipo PJ GF GC Puntos
1 Rizespor Rizespor 26 38 16 52
2 Tarsus Idman Yurdu Tarsus Idman 26 42 18 51
3 MKE Kırıkkalespor Kırıkkales 25 27 16 49
4 Malatyaspor Malatyaspor 26 38 17 48
5 İskenderunspor İskenderuns 26 38 18 47
6 Hatayspor Hatayspor 26 28 26 39
7 Corumspor Corumspor 26 31 28 38
8 Amasyaspor Amasyaspor 25 32 27 35
9 Elazigspor Elazigspor 26 32 39 35
10 Diyarbakirspor Diyarbakirsp 26 24 27 32
11 Petrol Ofisi SK Petrol Ofisi 26 19 32 28
12 Hacettepe SK Hacettepe 26 21 45 20
13 Ceyhanspor Adana Ceyhanspor 26 23 45 17
14 Altındağ Altındağ 26 9 48 8
Ver
TEMPORADA 1967/1968
Equipo PJ GF GC Puntos
1 Düzcespor Düzcespor 32 57 17 64
2 MKE Kırıkkalespor Kırıkkales 32 58 46 58
3 İskenderunspor İskenderuns 32 31 21 57
4 Eskişehir Demirspor Eskişehir 32 46 25 56
5 Nazilli Belediyespor Nazilli 32 45 32 53
6 Tekirdağspor Tekirdağspo 32 27 21 51
7 Konya İdman Yurdu Konya İdman 32 38 30 49
8 Hatayspor Hatayspor 32 39 35 46
9 Lüleburgazspor Lüleburgazs 32 41 37 44
10 Canakkale Dardanelspor Canakkale 32 32 29 42
11 Tarsus Idman Yurdu Tarsus Idman 32 42 49 41
12 Beyogluspor Beyogluspor 32 26 37 38
13 Corumspor Corumspor 32 25 34 37
14 Elazigspor Elazigspor 32 30 48 31
15 Muğlaspor Muğlaspor 32 27 55 30
16 Davutpaşa Davutpaşa 32 24 38 25
17 Ceyhanspor Adana Ceyhanspor 32 28 62 22

  USO DE MEMORIA  
4,987,720 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0034
Controller Execution Time ( Home / Category )  0.0671
Total Execution Time  0.0705
  CADENA URL  
/2_lig_turquia1969/grupo1/historico
  GET DATOS  
$_GET['/2_lig_turquia1969/grupo1/historico']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (16)  
0.0020  SELECT type FROM routes WHERE alias = '2_lig_turquia1969'
0.0040  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = '2_lig_turquia' AND (l.group_code = 1 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 1969 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=1 DESC LIMIT 1
0.0018  SELECT id,name,alias,stepParent FROM categories WHERE parentId=359 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 = 51019 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0024  SELECT id,year,current_round,total_teams,legend FROM leagues WHERE categoryId = 359 AND group_code = 1 and tables = 1 AND year <= 1969 AND total_num_tablesR >= 1 ORDER BY year DESC LIMIT 22
0.0025  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 `tables1969` 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 = 51019 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0028  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 `tables1968` 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 = 51024 AND t.round = 34 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:06:56' 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:06:56' 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 12:06:56' 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 12:06:56' 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 = '2_lig_turquia' AND (l.group_code = 0 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 1969 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=0 DESC LIMIT 1
0.0024  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 events1969 e ON e.player_id = p.id AND e.league_id = 51019 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 51019 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.0020  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 events1969 e ON e.player_id = p.id AND e.league_id = 51019 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 51019 AND (e.action = 4 or e.action = 5) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0020  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 events1969 e ON e.player_id = p.id AND e.league_id = 51019 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 51019 AND (e.action = 3 or e.action = 4) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0034  SELECT *,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables1969` 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 = 51019 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC