4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del Fenerbahçe

Fenerbahçe

Entrenador: Ismail Kartal

Temporada 1961/1962
TEMPORADA 1961/1962
LIGA TURCA
Equipo PJ GF GC Puntos
1 Galatasaray SK Galatasaray 38 52 18 57
2 Fenerbahçe Fenerbahçe 38 64 30 53
3 Beşiktaş Beşiktaş 38 48 24 48
4 Altay Altay 38 44 35 46
5 Karsiyaka Karsiyaka 38 46 51 42
6 Gençlerbirliği SK Gençlerbirl 38 57 47 41
7 Göztepe Göztepe 38 46 42 41
8 Altinordu Altinordu 38 48 53 41
9 Kasımpaşa Kasımpaşa 38 44 41 39
10 Türk Telekom Türk 38 45 50 36
11 Ankaragücü Ankaragücü 38 45 39 35
12 Feriköy Feriköy 38 31 36 34
13 Istanbulspor AS Istanbulspor 38 36 42 34
14 Beykozspor Beykozspor 38 43 52 33
15 Fatih Karagümrük Fatih 38 38 45 32
16 Izmirspor Izmirspor 38 32 44 32
17 Yeşildirek SK Yeşildirek 38 40 53 32
18 Vefa SK Vefa SK 38 29 48 31
19 Ankara Demirspor Ankara 38 42 52 30
20 Etimesgut Etimesgut 38 27 55 23
TEMPORADA 1960/1961
LIGA TURCA
Equipo PJ GF GC Puntos
1 Fenerbahçe Fenerbahçe 38 81 29 61
2 Galatasaray SK Galatasaray 38 75 19 60
3 Beşiktaş Beşiktaş 38 61 26 55
4 Beykozspor Beykozspor 38 51 34 49
5 Gençlerbirliği SK Gençlerbirl 38 54 39 45
6 Vefa SK Vefa SK 38 32 39 41
7 Izmirspor Izmirspor 38 34 34 38
8 Ankara Demirspor Ankara 38 37 41 38
9 Fatih Karagümrük Fatih 38 48 48 35
10 Feriköy Feriköy 38 32 38 35
11 Ankaragücü Ankaragücü 38 44 47 34
12 Kasımpaşa Kasımpaşa 38 27 35 34
13 Göztepe Göztepe 38 40 53 34
14 Istanbulspor AS Istanbulspor 38 42 54 33
15 Etimesgut Etimesgut 38 33 53 32
16 Karsiyaka Karsiyaka 38 45 50 31
17 Türk Telekom Türk 38 32 46 31
18 Altay Altay 38 30 46 30
19 Altinordu Altinordu 38 31 53 26
20 Adana Demirspor Adana 38 21 66 18
TEMPORADA 1959/1960
LIGA TURCA
Equipo PJ GF GC Puntos
1 Beşiktaş Beşiktaş 38 68 15 65
2 Fenerbahçe Fenerbahçe 38 88 38 60
3 Galatasaray SK Galatasaray 38 74 23 58
4 Izmirspor Izmirspor 38 62 43 47
5 Ankara Demirspor Ankara 38 49 40 45
6 Istanbulspor AS Istanbulspor 38 39 34 42
7 Fatih Karagümrük Fatih 38 50 45 40
8 Feriköy Feriköy 38 44 39 40
9 Karsiyaka Karsiyaka 38 43 52 36
10 Gençlerbirliği SK Gençlerbirl 38 50 46 35
11 Vefa SK Vefa SK 38 37 60 35
12 Etimesgut Etimesgut 38 35 43 34
13 Kasımpaşa Kasımpaşa 38 31 48 33
14 Göztepe Göztepe 38 35 41 32
15 Ankaragücü Ankaragücü 38 39 56 30
16 Beykozspor Beykozspor 38 35 56 30
17 Altay Altay 38 44 66 28
18 Adalet Istanbul Adalet 38 26 48 26
19 Hacettepe SK Hacettepe 38 42 68 24
20 Altinordu Altinordu 38 38 68 20
TEMPORADA 1958/1959
LIGA TURCA
Equipo PJ GF GC Puntos
1 Vefa SK Vefa SK 14 21 10 27
2 Galatasaray SK Galatasaray 14 18 7 27
3 Göztepe Göztepe 14 23 21 20
4 Ankara Demirspor Ankara 14 12 11 20
5 Fatih Karagümrük Fatih 14 17 17 16
6 Karsiyaka Karsiyaka 14 13 21 12
7 Gençlerbirliği SK Gençlerbirl 14 10 18 11
8 Adalet Istanbul Adalet 14 12 21 10
9 Fenerbahçe Fenerbahçe 14 29 7 38
10 Beşiktaş Beşiktaş 14 22 16 26
11 Altay Altay 14 18 16 20
12 Ankaragücü Ankaragücü 14 16 19 18
13 Izmirspor Izmirspor 14 11 12 17
14 Hacettepe SK Hacettepe 14 14 20 16
15 Beykozspor Beykozspor 14 17 21 13
16 Istanbulspor AS Istanbulspor 14 6 22 7

  USO DE MEMORIA  
5,452,936 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0012
Controller Execution Time ( Home / Category )  0.1120
Total Execution Time  0.1133
  CADENA URL  
/historico/Fenerbahce/1962
  GET DATOS  
$_GET['/historico/Fenerbahce/1962']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (24)  
0.0065  SELECT dt.*,c.active_year,l.year,l.table_suffix, c.ctype, l.id as league_id,t.id as id,t.manager,t.name as nameOriginal,dt.id as teamId,cou.Name as cou_name,cou.Continent,cou.Region FROM `leagues_webci` as l INNER JOIN `teams` as t ON l.id = t.league_id INNER JOIN `datateams` as dt ON dt.id = t.teamId INNER JOIN `categories_webci` as c ON c.id = l.categoryId LEFT JOIN country cou ON LOWER(cou.Code2) = dt.CountryCode WHERE dt.basealias = 'Fenerbahce' AND l.year = 1962 ORDER BY c.top DESC, c.ctype != 12 DESC, c.troncal DESC, l.end_date >= NOW() DESC, l.start_date <= NOW() DESC, l.year DESC, c.coefficient DESC, l.id ASC
0.0019  SELECT dp.nick, dp.fullname,rp.date_ini, rp.date_end FROM futbol.rel_people rp INNER JOIN futbol.datapeople dp on dp.id=rp.people_id WHERE rp.teamId=10066 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0018  SELECT dp.nick, dp.fullname,rp.date_ini, rp.date_end FROM futbol.rel_people rp INNER JOIN futbol.datapeople dp on dp.id=rp.people_id WHERE rp.teamId=10066 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0019  SELECT dp.nick, dp.fullname,rp.date_ini, rp.date_end FROM futbol.rel_people rp INNER JOIN futbol.datapeople dp on dp.id=rp.people_id WHERE rp.teamId=10066 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0041  SELECT c.*, l.*, cou.name as namec, ct.table_sufix FROM (leagues l INNER JOIN categories c ON c.id = l.categoryId INNER JOIN categories_types ct ON c.ctype=ct.id LEFT JOIN country cou ON cou.Code2 = c.CountryCode) WHERE l.id = 9922
0.0019  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=10066 AND type_rel = 2
0.0037  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 2 AND rel.typeId = 10066 AND rel.ln = 'es' ORDER BY rel.cover_points DESC LIMIT 5
0.0023  SELECT /*35 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 (1362,1686,1944,2356,2596) ORDER BY n.cover_points DESC, update_date DESC
0.0062  SELECT cat.logo,cat.official,cat.location,dt.nameShow,dt.basealias,t.teamId,l.year,t.qod,cat.coefficient,cat.active_year,cat.name,l.group_code,l.total_group,cat.alias,l.categoryId,l.year,l.id as league_id FROM datateams dt INNER JOIN teams t ON t.teamId = dt.id INNER JOIN leagues l ON l.id = t.league_id INNER JOIN categories cat ON cat.id = l.categoryId WHERE dt.id = '10066' AND l.year = 1962 ORDER BY l.year DESC,cat.coefficient DESC
0.0081  SELECT SQL_NO_CACHE res.id as id, res.group_code, res.total_group, res.logo, res.alias FROM (SELECT ct.active_year, ct.id as id, l.year, l.end,l.group_code, l.total_group, ct.logo, ct.alias FROM categories AS ct INNER JOIN leagues AS l ON ct.id=l.categoryId AND ct.active_year=l.year INNER JOIN teams AS t ON l.id=t.league_id WHERE t.teamId = '10066' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0020  SELECT t.id,t.teamId,t.total_players,dt.nameShow,dt.basealias FROM teams t INNER JOIN datateams dt ON t.teamId = dt.id WHERE t.league_id = 9922 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0041  SELECT t.id as team_id, ct.id, l.id as idLeague, l.year, ct.name, l.start_date, l.end_date FROM categories AS ct INNER JOIN leagues AS l ON ct.id=l.categoryId INNER JOIN teams AS t ON l.id=t.league_id WHERE t.teamId=10066 AND l.year in (1961,1962,1963) ORDER BY l.id DESC, l.year DESC ;
0.0019  SELECT ct.id, ct.alias, ct.name AS name, ct.active_year, ct.coefficient AS coefficient, l.id AS league_id, l.year, l.total_group FROM categories AS ct INNER JOIN leagues AS l ON ct.id=l.categoryId WHERE l.id IN (50207,10910,9923) ORDER BY ct.ctype != 12 DESC, ct.troncal DESC, ct.coefficient DESC, l.end_date >= NOW() DESC, l.start_date <= NOW() DESC, l.year DESC, ct.coefficient DESC, l.group_code ASC
0.0018  SELECT count(id) as num_players from rel_players WHERE league_id = 9923 AND teamId = 10066
0.0061  SELECT count(id) as num_players from rel_players WHERE league_id = 10910 AND teamId = 10066
0.0019  SELECT count(id) as num_players from rel_players WHERE league_id = 50207 AND teamId = 10066
0.0044  SELECT e.action,rp.player_id, count(e.action) as total, p.nick,p.name,p.last_name,p.alias,rp.team_id FROM `rel_players` rp INNER JOIN dataplayers p ON p.id = rp.player_id INNER JOIN events1962 e ON e.player_id = p.id AND e.league_id = 10910 WHERE rp.league_id = 10910 AND rp.teamId = 10066 AND (e.action = 1 or e.action = 2 or e.action = 11 or e.action = 12 or e.action = 13) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0029  SELECT e.action,rp.player_id, count(e.action) as total, p.nick,p.name,p.last_name,p.alias,rp.team_id FROM `rel_players` rp INNER JOIN dataplayers p ON p.id = rp.player_id INNER JOIN events1962 e ON e.player_id = p.id AND e.league_id = 10910 WHERE rp.league_id = 10910 AND rp.teamId = 10066 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0026  SELECT e.action,rp.player_id, count(e.action) as total, p.nick,p.name,p.last_name,p.alias,rp.team_id FROM `rel_players` rp INNER JOIN dataplayers p ON p.id = rp.player_id INNER JOIN events1962 e ON e.player_id = p.id AND e.league_id = 10910 WHERE rp.league_id = 10910 AND rp.teamId = 10066 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0038  SELECT l.id,t.league_id,l.legend,l.year,c.name,l.total_teams,c.alias,l.group_code,l.total_group,l.current_round, l.table_suffix FROM teams t INNER JOIN leagues l ON t.league_id = l.id INNER JOIN categories c ON c.id = l.categoryId WHERE c.troncal = 1 AND t.teamId = 10066 AND l.year <= 1962 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
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 `tables1962` 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 = 9922 AND t.round = 40 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 `tables1961` 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 = 9923 AND t.round = 39 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 `tables1960` 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 = 9924 AND t.round = 37 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 `tables1959` 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 = 10894 AND t.round = 11 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC