4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Ver
TEMPORADA 1969/1970
Equipo PJ GF GC Puntos
1 Hatayspor Hatayspor 40 70 19 86
2 İskenderunspor İskenderuns 40 71 26 83
3 Malatyaspor Malatyaspor 40 68 29 83
4 MKE Kırıkkalespor Kırıkkales 40 56 30 68
5 Petrol Ofisi SK Petrol Ofisi 40 50 29 64
6 Rizespor Rizespor 40 45 36 63
7 Amasyaspor Amasyaspor 40 50 34 62
8 Elazigspor Elazigspor 40 56 42 61
9 Corumspor Corumspor 40 37 30 61
10 Erzurumspor Erzurumspor 40 34 38 59
11 Erzincanspor Erzincanspor 40 34 34 56
12 Kirsehirspor Kirsehirspor 40 47 44 54
13 Ceyhanspor Adana Ceyhanspor 40 39 33 49
14 Nevşehir Belediyespor Nevşehir 40 27 44 49
15 Diyarbakirspor Diyarbakirsp 40 27 32 48
16 Yenimahallespor Yenimahalles 40 32 58 39
17 Hacettepe SK Hacettepe 40 32 58 38
18 Konya Ereğlispor Konya 40 30 65 35
19 Sanliurfaspor Sanliurfaspo 40 24 62 35
20 Mardinspor Mardinspor 40 33 77 33
21 Tokatspor Tokatspor 40 27 69 29
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  
5,436,816 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0019
Controller Execution Time ( Home / Category )  0.2840
Total Execution Time  0.2860
  CADENA URL  
/2_lig_turquia1970/grupo1/historico
  GET DATOS  
$_GET['/2_lig_turquia1970/grupo1/historico']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (13)  
0.0125  SELECT id,name,alias,stepParent FROM categories WHERE parentId=359 ORDER BY order_id ASC
0.0130  SELECT id,year,current_round,total_teams,legend FROM leagues WHERE categoryId = 359 AND group_code = 1 and tables = 1 AND year <= 1970 AND total_num_tablesR >= 1 ORDER BY year DESC LIMIT 22
0.0254  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 `tables1970` 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 = 51017 AND t.round = 42 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0131  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.0132  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.0125  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-05-01 05:38:05' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0124  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=2 AND last_update > '2024-05-01 05:38:05' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0125  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=4 AND last_update > '2024-05-01 05:38:05' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0125  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=3 AND last_update > '2024-05-01 05:38:05' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0126  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 events1970 e ON e.player_id = p.id AND e.league_id = 51017 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 51017 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.0127  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 events1970 e ON e.player_id = p.id AND e.league_id = 51017 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 51017 AND (e.action = 4 or e.action = 5) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0127  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 events1970 e ON e.player_id = p.id AND e.league_id = 51017 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 51017 AND (e.action = 3 or e.action = 4) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0262  SELECT *,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables1970` 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 = 51017 AND t.round = 42 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC