4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Ver
TEMPORADA 1985/1986
Equipo PJ GF GC Puntos
1 Antalyaspor Antalyaspor 33 57 19 71
2 Adanaspor Adanaspor 34 73 30 66
3 Türk Telekom Türk 33 52 35 58
4 Edirnespor Edirnespor 34 49 49 50
5 Üsküdar Anadolu Üsküdar 34 37 37 49
6 Inegolspor Inegolspor 34 32 35 47
7 Fatih Karagümrük Fatih 34 34 29 46
8 Düzcespor Düzcespor 34 44 49 45
9 Babaeskispor Babaeskispor 34 35 39 43
10 Karabükspor Karabükspor 34 31 41 43
11 Vefa SK Vefa SK 34 37 34 42
12 Bakırköyspor Bakırköysp 34 38 41 41
13 Mersin İdmanyurdu Mersin 34 21 28 40
14 Kirklarelispor Kirklarelisp 34 33 42 40
15 Tekirdağspor Tekirdağspo 34 26 45 39
16 Galata Galata 34 25 41 38
17 Lüleburgazspor Lüleburgazs 34 27 42 34
18 Golcukspor Golcukspor 34 22 37 31
Ver
TEMPORADA 1984/1985
Equipo PJ GF GC Puntos
1 Samsunspor Samsunspor 32 49 15 72
2 Türk Telekom Türk 32 49 29 58
3 Karsiyaka Karsiyaka 32 50 22 56
4 Edirnespor Edirnespor 32 43 27 53
5 Galata Galata 31 38 33 50
6 Fatih Karagümrük Fatih 32 34 31 47
7 Düzcespor Düzcespor 32 43 48 45
8 Vefa SK Vefa SK 32 25 29 41
9 Karabükspor Karabükspor 32 24 33 39
10 Kirklarelispor Kirklarelisp 32 32 36 38
11 Üsküdar Anadolu Üsküdar 32 27 36 36
12 Babaeskispor Babaeskispor 32 24 38 35
13 Altinordu Altinordu 31 35 36 33
14 Tekirdağspor Tekirdağspo 31 29 45 33
15 Lüleburgazspor Lüleburgazs 31 32 31 32
16 Küçükçekmecespor Küçükçek 32 22 37 32
17 Alibeykoyspor Alibeykoyspo 32 17 47 26
Ver
TEMPORADA 1983/1984
Equipo PJ GF GC Puntos
1 Malatyaspor Malatyaspor 30 52 9 76
2 İskenderunspor İskenderuns 30 43 18 56
3 Diyarbakirspor Diyarbakirsp 30 32 22 51
4 Gaziantepspor Gaziantepspo 29 27 16 45
5 Kayseri Kayseri 30 30 24 42
6 Rizespor Rizespor 30 25 28 41
7 Akçaabat Sebatspor Akçaabat 30 27 28 39
8 Elazigspor Elazigspor 30 24 28 38
9 Mardinspor Mardinspor 30 21 34 36
10 Vanspor Vanspor 30 35 34 35
11 MKE Kırıkkalespor Kırıkkales 29 29 36 34
12 Erzurumspor Erzurumspor 30 23 32 33
13 Giresunspor Giresunspor 30 21 31 32
14 Sanliurfaspor Sanliurfaspo 30 20 38 30
15 Kirsehirspor Kirsehirspor 30 22 32 28
16 Ceyhanspor Adana Ceyhanspor 30 22 43 28
Ver
TEMPORADA 1982/1983
Equipo PJ GF GC Puntos
1 Gençlerbirliği SK Gençlerbirl 30 61 19 70
2 Eskişehirspor Eskişehirsp 30 46 16 59
3 Kayseri Kayseri 30 44 19 53
4 Petrol Ofisi SK Petrol Ofisi 30 31 28 47
5 Kütahyaspor Kütahyaspor 30 25 29 43
6 Kirsehirspor Kirsehirspor 30 24 37 39
7 MKE Kırıkkalespor Kırıkkales 30 35 31 38
8 Düzcespor Düzcespor 30 27 27 38
9 Sitespor Sitespor 30 26 26 38
10 Konyaspor Konyaspor 30 24 31 37
11 Karabükspor Karabükspor 30 17 21 34
12 Turanspor Turanspor 29 25 26 33
13 Ankara Demirspor Ankara 30 22 30 33
14 Yeni Ereğlispor Yeni 29 17 26 31
15 Amasyaspor Amasyaspor 30 20 39 31
16 Eskişehir Demirspor Eskişehir 30 16 55 17
Ver
TEMPORADA 1981/1982
Equipo PJ GF GC Puntos
1 Mersin İdmanyurdu Mersin 28 46 11 68
2 Kayseri Kayseri 28 60 17 65
3 Gençlerbirliği SK Gençlerbirl 28 32 24 45
4 Konyaspor Konyaspor 28 28 25 40
5 Ispartaspor Ispartaspor 28 31 35 36
6 Sanliurfaspor Sanliurfaspo 28 25 28 34
7 Ceyhanspor Adana Ceyhanspor 28 22 31 34
8 Burdurspor Burdurspor 28 21 21 33
9 İskenderunspor İskenderuns 28 25 30 33
10 Hatayspor Hatayspor 28 24 29 33
11 Ankara Demirspor Ankara 28 23 29 31
12 Mardinspor Mardinspor 28 23 30 30
13 Malatyaspor Malatyaspor 28 26 34 29
14 Tarsus Idman Yurdu Tarsus Idman 28 21 33 28
15 Elazigspor Elazigspor 28 14 44 19
Ver
TEMPORADA 1980/1981
Equipo PJ GF GC Puntos
Ver
TEMPORADA 1965/1966
Equipo PJ GF GC Puntos
1 Altinordu Altinordu 14 25 9 31
2 Eskişehirspor Eskişehirsp 14 22 7 29
3 Bursaspor Bursaspor 14 23 9 27
4 Adana Demirspor Adana 14 22 17 23
5 Mersin İdmanyurdu Mersin 14 21 16 21
6 Sakaryaspor Sakaryaspor 14 15 15 18
7 Güneşspor Güneşspor 14 9 26 3
8 Beyogluspor Beyogluspor 14 6 44 3

  USO DE MEMORIA  
5,632,432 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0019
Controller Execution Time ( Home / Category )  0.0944
Total Execution Time  0.0963
  CADENA URL  
/1_lig_turquia1986/grupo3/historico
  GET DATOS  
$_GET['/1_lig_turquia1986/grupo3/historico']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (18)  
0.0048  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = '1_lig_turquia' AND (l.group_code = 3 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 1986 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=3 DESC LIMIT 1
0.0032  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 = 50490 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0045  SELECT id,year,current_round,total_teams,legend FROM leagues WHERE categoryId = 358 AND group_code = 3 and tables = 1 AND year <= 1986 AND total_num_tablesR >= 1 ORDER BY year DESC LIMIT 22
0.0040  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 `tables1986` 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 = 50490 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0051  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 `tables1985` 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 = 50510 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0035  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 `tables1984` 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 = 50515 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0038  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 `tables1983` 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 = 50519 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0037  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 `tables1982` 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 = 50530 AND t.round = 30 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 `tables1981` 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 = 50534 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0033  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 `tables1966` 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 = 50639 AND t.round = 14 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0023  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-05-09 23:05:54' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0022  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=2 AND last_update > '2024-05-09 23:05:54' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0024  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=4 AND last_update > '2024-05-09 23:05:54' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0023  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=3 AND last_update > '2024-05-09 23:05:54' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0028  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 events1986 e ON e.player_id = p.id AND e.league_id = 50490 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 50490 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.0030  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 events1986 e ON e.player_id = p.id AND e.league_id = 50490 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 50490 AND (e.action = 4 or e.action = 5) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
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 events1986 e ON e.player_id = p.id AND e.league_id = 50490 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 50490 AND (e.action = 3 or e.action = 4) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0073  SELECT *,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables1986` 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 = 50490 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC