4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
17 jugadores
Istanbulspor AS Istanbulspor AS
Yilmaz Karamanoglu Yilmaz Karamanoglu 45 años POR
Erol Tirpan Erol Tirpan 44 años POR
K. Aydin K. Aydin 36 años 172cm DEF
C. Vatansever C. Vatansever 40 años 186cm DEF
D. Durmus D. Durmus 40 años 183cm DEF
U. Demirok U. Demirok 35 años 185cm 76kg DEF
Cepni Cepni 40 años 175cm DEF
Mustafa Yalcinkaya Mustafa Yalcinkaya 42 años 177cm 68kg DEF
Enis Ulusan Enis Ulusan 39 años 178cm MED
Samet Sakarya Samet Sakarya 41 años MED
S. Akin S. Akin 37 años MED
S. Kaya S. Kaya 39 años 183cm MED
O. Cetiner O. Cetiner 43 años MED
S. Yildizhan S. Yildizhan 35 años DEL
E. Baljic E. Baljic 49 años 185cm 77kg DEL
K. Özer K. Özer 36 años 170cm 67kg DEL
A. Aras A. Aras 36 años 187cm 78kg DEL
18 jugadores
Samsunspor Samsunspor
Kafkasyalı E. Kafkasyalı E. 38 años 187cm 75kg POR
Mehmet Bölükbaşı Mehmet Bölükbaşı 45 años 188cm 73kg POR
C. Ulun C. Ulun 41 años 176cm 66kg DEF
F. Sungur F. Sungur 40 años DEF
R. Sal R. Sal 38 años 187cm 78kg DEF
E. Balak E. Balak 35 años 177cm 74kg DEF
Sinan Demircioglu Sinan Demircioglu 49 años 175cm 73kg DEF
Caner Altin Caner Altin 40 años 182cm 79kg MED
S. Eyüpoğlu S. Eyüpoğlu 38 años 175cm MED
C. Sagir C. Sagir 50 años MED
S. Aksoy S. Aksoy 35 años 181cm MED
S. Kilic S. Kilic 35 años MED
Kenan Yelek Kenan Yelek 48 años 186cm 82kg MED
Zafer Şakar Zafer Şakar 38 años MED
Y. Ejder Y. Ejder 42 años 181cm 71kg MED
K. Akbaba K. Akbaba 36 años 182cm 73kg MED
Fatih Aytekin Fatih Aytekin 43 años DEL
Serkan Aykut Serkan Aykut 49 años 175cm 70kg DEL
14 jugadores
Sakaryaspor Sakaryaspor
B. Körk B. Körk 43 años 187cm 70kg POR
Volkan Basyurt Volkan Basyurt 44 años DEF
M. Uslu M. Uslu 36 años 177cm 71kg DEF
T. Yapağici T. Yapağici 39 años 187cm DEF
Y. Kabakci Y. Kabakci 42 años DEF
H. Tok H. Tok 35 años 186cm 86kg DEF
Ercan Yaman Ercan Yaman 42 años MED
E. Acikgoz E. Acikgoz 39 años 178cm 58kg MED
Abdulvahit Karacabey Abdulvahit Karacabey 47 años MED
Serdal Kurt Serdal Kurt 46 años 177cm 69kg MED
Murat Özkan Murat Özkan 46 años 183cm 76kg MED
E. Ergin E. Ergin 43 años 184cm 76kg MED
B. Akdis B. Akdis 46 años 183cm 76kg DEL
F. Başoda F. Başoda 41 años 183cm DEL
14 jugadores
Kocaelispor Kocaelispor
B. Zulaloglu B. Zulaloglu 41 años POR
S. Yanik S. Yanik 37 años DEF
E. Güracar E. Güracar 49 años 182cm 71kg DEF
B. Turgut B. Turgut 39 años MED
Haydar Koç Haydar Koç 48 años 176cm 69kg MED
S. Sen S. Sen 44 años 173cm 63kg MED
Turkmen Turkmen 38 años 180cm MED
S. Özgür S. Özgür 42 años MED
Hakki Hocaoglu Hakki Hocaoglu 49 años 183cm 83kg MED
Sinan Vergül Sinan Vergül 45 años 177cm 70kg MED
C. Erdem C. Erdem 36 años 188cm 82kg DEL
A. Calik A. Calik 42 años 177cm 77kg DEL
S. Sagat S. Sagat 41 años DEL
Serdar Topraktepe Serdar Topraktepe 47 años 183cm 79kg DEL

JUGADORES DESTACADOS

Clasificación

Equipo PJ GF GC Puntos
1 Kocaelispor Kocaelispor 34 59 37 64
2 Antalyaspor Antalyaspor 34 56 33 61
3 Sakaryaspor Sakaryaspor 34 55 34 58
4 Diyarbakirspor Diyarbakirsp 34 52 36 57
5 Eskişehirspor Eskişehirsp 34 52 36 57
6 Boluspor Boluspor 34 50 46 53
7 Kayseri Kayseri 34 54 41 52
8 Orduspor 1967 Orduspor 34 39 44 50
9 Karsiyaka Karsiyaka 34 44 41 47
10 Altay Altay 34 47 47 47
11 Malatyaspor Malatyaspor 34 44 43 43
12 Giresunspor Giresunspor 34 41 44 43
13 Kartalspor Kartalspor 34 52 57 42
14 Gaziantep Gaziantep 34 53 51 39
15 Samsunspor Samsunspor 34 45 61 38
16 Elazigspor Elazigspor 34 40 54 34
17 Istanbulspor AS Istanbulspor 34 26 58 26
18 Mardinspor Mardinspor 34 26 72 14

  USO DE MEMORIA  
5,291,576 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0027
Controller Execution Time ( Home / Category )  0.0748
Total Execution Time  0.0775
  CADENA URL  
/1_lig_turquia2008/grupo1/jugadores
  GET DATOS  
$_GET['/1_lig_turquia2008/grupo1/jugadores']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (15)  
0.0018  SELECT type FROM routes WHERE alias = '1_lig_turquia2008'
0.0041  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 = 1 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 2008 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=1 DESC LIMIT 1
0.0019  SELECT id,name,alias,stepParent FROM categories WHERE parentId=358 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 = 9942 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0019  SELECT dt.id FROM teams t INNER JOIN datateams dt ON t.teamId = dt.id WHERE t.league_id = 9942 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 36
0.0044  SELECT dp.nick,dp.alias,dp.role,p.id,p.teamId,dp.height,dp.weight,p.team_id,p.player_id,p.squadNumber,dp.CountryCode,dp.age FROM rel_players p INNER JOIN dataplayers dp ON dp.id = p.player_id INNER JOIN datateams dt ON dt.id = p.teamId WHERE p.league_id = 9942 AND dt.id IN (12887,995,1395,226,2216,12567,12569,2205,1462,12901,974,6191,929,1451,1620,12927,12892,62218) ORDER BY dt.relations DESC,dp.role ASC
0.0019  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-05-03 23:07:25' 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-05-03 23:07:25' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0021  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=4 AND last_update > '2024-05-03 23:07:25' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0019  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=3 AND last_update > '2024-05-03 23:07:25' 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 = '1_lig_turquia' AND (l.group_code = 0 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 2008 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=0 DESC LIMIT 1
0.0025  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 events2008 e ON e.player_id = p.id AND e.league_id = 9942 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 9942 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.0025  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 events2008 e ON e.player_id = p.id AND e.league_id = 9942 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 9942 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 events2008 e ON e.player_id = p.id AND e.league_id = 9942 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 9942 AND (e.action = 3 or e.action = 4) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0048  SELECT *,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables2008` 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 = 9942 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC