4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
4 jugadores
Aris Thessaloniki Aris
N. Karabelas N. Karabelas 39 años 180cm 72kg DEF
Raúl Bravo Raúl Bravo 43 años 181cm 70kg DEF
M. Tzanakakis M. Tzanakakis 32 años 178cm 71kg DEF
M. Bougherra M. Bougherra 41 años 190cm 93kg DEF
8 jugadores
Apollon Pontou Apollon Pontou
S. Kapias S. Kapias 40 años 186cm 82kg DEF
A. Mouchalis A. Mouchalis 27 años 175cm 70kg DEF
E. Damarlis E. Damarlis 31 años 185cm 81kg DEF
Dimitrios Triantafyllidis Dimitrios Triantafyllidis 29 años DEF
S. Tsoukanis S. Tsoukanis 34 años 181cm 75kg DEF
Anastasios Koukoulekis Anastasios Koukoulekis 37 años DEF
Dimitrios Boneris Dimitrios Boneris 30 años MED
Lazaros Moisiadis Lazaros Moisiadis 31 años DEL
3 jugadores
Doxa Dramas Doxa Dramas
G. Papazacharias G. Papazacharias 39 años 186cm 76kg DEF
Antonis Charitidis Antonis Charitidis 31 años MED
E. Oliseh E. Oliseh 43 años 183cm 74kg MED
5 jugadores
Kavala Kavala
L. Gialousis L. Gialousis 38 años 175cm 74kg DEF
A. Ladakis A. Ladakis 42 años 178cm 72kg MED
Z. Zlatkovski Z. Zlatkovski 37 años DEL
M. Pavicevic M. Pavicevic 37 años 185cm DEL
Georgios Litskas Georgios Litskas 28 años 187cm 82kg DEL
2 jugadores
AEP Kozani AEP Kozani
Charis Abatzidis Charis Abatzidis 33 años POR
K. Kapetanos K. Kapetanos 39 años 176cm 79kg POR
1 jugadores
Nestos Chrisoupolis Nestos
Antonis Macheroudis Antonis Macheroudis 45 años DEL
1 jugadores
Kampaniakos Chalastra Kampaniakos
Christos Provatidis Christos Provatidis 31 años DEL
1 jugadores
Iraklis Ampelokipoi Iraklis
K. Barbas K. Barbas 41 años 184cm 80kg DEF
3 jugadores
Langadas Langadas
K. Barbas K. Barbas 41 años 184cm 80kg DEF
P. Konteon P. Konteon 39 años DEF
D. Karamanlis D. Karamanlis 37 años MED
1 jugadores
Byzantio Kokkinokhóma Byzantio
Alexandros Tachmatzidis Alexandros Tachmatzidis 31 años MED
1 jugadores
Ethnikos Neo Agioneri FC Ethnikos
Paraskevas Paraskevas 30 años DEL
1 jugadores
Apollon Krya Vrysi Apollon Krya Vr.
Theocharis Louizidis Theocharis Louizidis 28 años DEL

Clasificación

Equipo PJ GF GC Puntos
1 Aris Thessaloniki Aris 32 76 17 87
2 Nestos Chrisoupolis Nestos 32 66 35 66
3 Doxa Dramas Doxa Dramas 32 47 24 63
4 Kavala Kavala 32 53 24 58
5 Apollon Pontou Apollon 32 46 29 53
6 Langadas Langadas 32 50 35 53
7 Ethnikos Neo Agioneri FC Ethnikos 32 35 25 50
8 Kampaniakos Chalastra Kampaniakos 32 45 31 47
9 Eordaikos Eordaikos 32 35 35 46
10 AEP Kozani AEP Kozani 32 41 49 44
11 Byzantio Kokkinokhóma Byzantio 32 47 51 37
12 Thyella Filotas Thyella 32 32 38 35
13 Apollon Krya Vrysi Apollon Krya 32 27 43 34
14 Iraklis Ampelokipoi Iraklis 32 33 57 28
15 Ethnikos Alexandroupoli Ethnikos 32 20 45 27
16 Evros Soufli Evros Soufli 32 32 86 22
17 Ethnikos Gazoros Ethnikos 32 10 71 11

  USO DE MEMORIA  
5,002,448 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0021
Controller Execution Time ( Home / Category )  0.3413
Total Execution Time  0.3434
  CADENA URL  
/3_league_grecia2016/grupo1/jugadores
  GET DATOS  
$_GET['/3_league_grecia2016/grupo1/jugadores']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (18)  
0.0124  SELECT type FROM routes WHERE alias = '3_league_grecia2016'
0.0256  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = '3_league_grecia' AND (l.group_code = 1 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 2016 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=1 DESC LIMIT 1
0.0129  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=344 AND type_rel = 3
0.0137  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 3 AND rel.typeId = 344 AND rel.ln = 'es' AND rel.status=1 ORDER BY rel.creation_date desc,rel.cover_points DESC LIMIT 5
0.0130  SELECT /*53 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 (1098455,1051323,606708,277509,105444) ORDER BY n.cover_points DESC, update_date DESC
0.0125  SELECT id,name,alias,stepParent FROM categories WHERE parentId=344 ORDER BY order_id ASC
0.0129  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 = 15926 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0126  SELECT dt.id FROM teams t INNER JOIN datateams dt ON t.teamId = dt.id WHERE t.league_id = 15926 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 36
0.0133  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 = 15926 AND dt.id IN (254,16656,939,1449,63204,80475,63197,12637,60411,60415,60413,80476,60417,60414,60416,60412,80477) ORDER BY dt.relations DESC,dp.role ASC
0.0130  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-05-04 10:46:49' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0130  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=2 AND last_update > '2024-05-04 10:46:49' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0132  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=4 AND last_update > '2024-05-04 10:46:49' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0130  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=3 AND last_update > '2024-05-04 10:46:49' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0142  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = '3_league_grecia' AND (l.group_code = 0 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 2016 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=0 DESC LIMIT 1
0.0141  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 events2016 e ON e.player_id = p.id AND e.league_id = 15926 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 15926 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.0138  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 events2016 e ON e.player_id = p.id AND e.league_id = 15926 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 15926 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 events2016 e ON e.player_id = p.id AND e.league_id = 15926 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 15926 AND (e.action = 3 or e.action = 4) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0137  SELECT *,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables2016` 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 = 15926 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC