4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
10 jugadores
Pierikos Pierikos
Giannis Bintsis Giannis Bintsis 24 años 188cm 80kg POR
A. Ikonomopoulos A. Ikonomopoulos 25 años 179cm DEF
Nikolaos Digozis Nikolaos Digozis 23 años MED
A. Papaioannou A. Papaioannou 21 años MED
Konstantinos Ikonomikos Konstantinos Ikonomikos 22 años MED
G. Bletsas G. Bletsas 29 años 184cm MED
Apostolos Sarantidis Apostolos Sarantidis 25 años 189cm DEL
Georgios Ballas Georgios Ballas 23 años 182cm DEL
G. Balogiannis G. Balogiannis 27 años 181cm 75kg DEL
Vasilios Fasidis Vasilios Fasidis 27 años 176cm DEL
3 jugadores
Zakynthos Zakynthos
Manolis Ikonomakis Manolis Ikonomakis 21 años 192cm POR
L. Rivas L. Rivas 24 años 173cm 62kg MED
Alexios Nikolakopoulos Alexios Nikolakopoulos 24 años 173cm DEL
2 jugadores
Kastoria Kastoria
F. Kapllani F. Kapllani 22 años DEF
G. Antoniadis G. Antoniadis 24 años MED
2 jugadores
Thesprotos Thesprotos
Kostas Efthymiadis Kostas Efthymiadis 21 años DEF
Spyros Rousis Spyros Rousis 21 años MED
2 jugadores
Anagennisi Arta Anagennisi Arta
C. Lisgaras C. Lisgaras 38 años 189cm 84kg DEF
Giannis Koromilas Giannis Koromilas 21 años MED
3 jugadores
AE Lefkimmi AE Lefkimmi
R. Pittadjis R. Pittadjis 23 años POR
V. Skiadas V. Skiadas 21 años 75kg DEF
V. Karampoikis V. Karampoikis 22 años 181cm MED
1 jugadores
Fikis Fikis
A. Ginis A. Ginis 19 años DEL
2 jugadores
Asteras Petriti Asteras Petriti
Christos Tzafestas Christos Tzafestas 21 años POR
Spyros Vlachopoulos Spyros Vlachopoulos 21 años DEL
1 jugadores
Ethnikos Neou Keramidiou Ethnikos Neou K.
K. Miliotis K. Miliotis 25 años MED
1 jugadores
Asteras Stavros Asteras Stavros
Serafim Maniotis Serafim Maniotis 23 años 185cm MED
2 jugadores
Magnisiakos Magnisiakos
A. Zeris A. Zeris 30 años 175cm 70kg DEF
Apostolos Tzianis Apostolos Tzianis 20 años DEL
1 jugadores
AE Kileler AE Kileler
Dimitrios Altanis Dimitrios Altanis 23 años MED

Clasificación

Equipo PJ GF GC Puntos
1 Ethnikos Neou Keramidiou Ethnikos 34 57 18 78
2 Nea Artaki Nea Artaki 34 62 19 76
3 Svoronos Svoronos 34 63 23 72
4 Zakynthos Zakynthos 34 50 30 58
5 Pierikos Pierikos 34 49 27 55
6 Anagennisi Arta Anagennisi 34 35 33 54
7 AE Kileler AE Kileler 34 36 22 53
8 Asteras Stavros Asteras 34 38 35 52
9 Thesprotos Thesprotos 34 54 45 52
10 Trikala Trikala 34 49 37 52
11 Asteras Petriti Asteras 34 36 38 50
12 Eordaikos Eordaikos 34 39 30 50
13 Thyella Katsika Thyella 34 49 32 48
14 AE Lefkimmi AE Lefkimmi 34 37 51 33
15 Kastoria Kastoria 34 35 52 33
16 Vataniakos Vataniakos 34 36 67 31
17 Fikis Fikis 33 12 90 7
18 Magnisiakos Magnisiakos 33 1 89 1

  USO DE MEMORIA  
5,045,904 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0020
Controller Execution Time ( Home / Category )  0.0722
Total Execution Time  0.0743
  CADENA URL  
/3_league_grecia2024/grupo2/jugadores
  GET DATOS  
$_GET['/3_league_grecia2024/grupo2/jugadores']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (18)  
0.0018  SELECT type FROM routes WHERE alias = '3_league_grecia2024'
0.0040  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 = 2 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 2024 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=2 DESC LIMIT 1
0.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=344 AND type_rel = 3
0.0019  SELECT id,name,alias,stepParent FROM categories WHERE parentId=344 ORDER BY order_id ASC
0.0020  SELECT max(l.year) as max_year, min(l.year) as min_year FROM leagues l WHERE categoryID = 344 GROUP BY l.categoryId
0.0020  SELECT l.year FROM leagues AS l WHERE (l.group_code =0 OR l.total_num_tablesR>=1 OR l.total_teamsR >=1 OR l.text_mode != 0) AND l.categoryId=344 GROUP BY l.year ORDER BY l.year DESC
0.0021  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 = 73557 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 = 73557 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 36
0.0027  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 = 73557 AND dt.id IN (2534,16657,12642,1448,63207,63293,80475,12675,105063,121862,138710,89945,112404,152534,138717,155587,159205,159998) 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-02 23:59:47' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0020  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=2 AND last_update > '2024-05-02 23:59:47' 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=4 AND last_update > '2024-05-02 23:59:47' 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-02 23:59:47' 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 = '3_league_grecia' AND (l.group_code = 0 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 2024 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=0 DESC LIMIT 1
0.0021  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 events2024 e ON e.player_id = p.id AND e.league_id = 73557 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 73557 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.0019  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 events2024 e ON e.player_id = p.id AND e.league_id = 73557 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 73557 AND (e.action = 4 or e.action = 5) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0019  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 events2024 e ON e.player_id = p.id AND e.league_id = 73557 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 73557 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 `tables2024` 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 = 73557 AND t.round = 34 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC