4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
18 jugadores
FC Flora FC Flora
M. Toom M. Toom 33 años 185cm 77kg POR
S. Pedõk S. Pedõk 35 años 187cm POR
Kevin Aloe Kevin Aloe 28 años 179cm DEF
T. Rähn T. Rähn 42 años 193cm 88kg DEF
G. Juhkam G. Juhkam 29 años 189cm DEF
Janar Ounap Janar Ounap 29 años 180cm DEF
M. Jürgenson M. Jürgenson 36 años 180cm 75kg DEF
M. Kase M. Kase 30 años 191cm DEF
K. Luigend K. Luigend 31 años 179cm MED
A. Frolov A. Frolov 36 años 175cm MED
Z. Beglarishvili Z. Beglarishvili 34 años 171cm 58kg MED
Brent Lepistu Brent Lepistu 31 años 185cm 78kg MED
A. Prosa A. Prosa 33 años 179cm DEL
Rauno Alliku Rauno Alliku 34 años 179cm DEL
Erkki Junolainen Erkki Junolainen 32 años DEL
M. Gussev M. Gussev 29 años 173cm 65kg DEL
Irakliy Logua Irakliy Logua 32 años 174cm 70kg DEL
Rauno Sappinen Rauno Sappinen 28 años 177cm 73kg DEL
18 jugadores
Levadia Levadia
R. Smisko R. Smisko 41 años POR
P. Pikker P. Pikker 38 años 183cm POR
M. Podholjuzin M. Podholjuzin 31 años 181cm 68kg DEF
A. Jahhimovits A. Jahhimovits 34 años DEF
A. Pikk A. Pikk 31 años 180cm 70kg DEF
A. Artjunin A. Artjunin 34 años 190cm 86kg DEF
O. Volchkov O. Volchkov 38 años DEF
A. Kulinits A. Kulinits 31 años 186cm 70kg DEF
I. Antonov I. Antonov 31 años 173cm 70kg MED
J. Aallikko J. Aallikko 30 años 178cm MED
A. Raudsepp A. Raudsepp 30 años 170cm MED
Igor Subbotin Igor Subbotin 33 años 187cm 73kg MED
Marek Kaljumäe Marek Kaljumäe 33 años 185cm 82kg MED
V. Ivanov V. Ivanov 38 años 80kg DEL
Pavel Marin Pavel Marin 28 años 176cm 72kg DEL
A. Rättel A. Rättel 31 años 179cm 74kg DEL
H. Rohtla H. Rohtla 32 años 174cm DEL
I. Teever I. Teever 41 años 189cm 79kg DEL

Equipos de esta liga

2

  USO DE MEMORIA  
4,347,840 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0019
Controller Execution Time ( Home / Category )  0.0728
Total Execution Time  0.0747
  CADENA URL  
/supercopa_estonia2014/grupo0/jugadores
  GET DATOS  
$_GET['/supercopa_estonia2014/grupo0/jugadores']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (20)  
0.0020  SELECT type FROM routes WHERE alias = 'supercopa_estonia2014'
0.0048  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'supercopa_estonia' AND (l.group_code = 0 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 2014 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=0 DESC LIMIT 1
0.0020  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=1597 AND type_rel = 3
0.0022  SELECT id,name,alias,stepParent FROM categories WHERE parentId=1597 ORDER BY order_id ASC
0.0024  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 = 12656 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0023  SELECT dt.id FROM teams t INNER JOIN datateams dt ON t.teamId = dt.id WHERE t.league_id = 12656 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 36
0.0041  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 = 12656 AND dt.id IN (4063,6378) ORDER BY dt.relations DESC,dp.role ASC
0.0020  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-04-30 23:06:46' 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-04-30 23:06:46' 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=4 AND last_update > '2024-04-30 23:06:46' 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-04-30 23:06:46' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0033  SELECT l.id FROM leagues_webci l WHERE l.categoryId = 1597 AND l.year = 2014
0.0023  SELECT e.action, count(e.action) as total, e.player_id FROM events2014 e WHERE e.league_id IN (12656) 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, e.player_id ASC LIMIT 10
0.0022  SELECT dp.name, dp.last_name, dp.nick,dp.CountryCode,dp.alias,rp.team_id,dt.nameShow,dt.short_name,dt.basealias,rp.player_id,rp.teamId,dp.role FROM dataplayers AS dp INNER JOIN rel_players AS rp ON rp.player_id=dp.id AND rp.league_id IN (12656) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN (216688) ORDER BY rp.in_squad = 1 DESC
0.0030  SELECT l.id FROM leagues_webci l WHERE l.categoryId = 1597 AND l.year = 2014
0.0020  SELECT e.action, count(e.action) as total, e.player_id FROM events2014 e WHERE e.league_id IN (12656) AND (e.action = 4 or e.action = 5) GROUP BY e.player_id ORDER BY total DESC, e.player_id ASC LIMIT 10
0.0021  SELECT dp.name, dp.last_name, dp.nick,dp.CountryCode,dp.alias,rp.team_id,dt.nameShow,dt.short_name,dt.basealias,rp.player_id,rp.teamId,dp.role FROM dataplayers AS dp INNER JOIN rel_players AS rp ON rp.player_id=dp.id AND rp.league_id IN (12656) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN (225310,61966,62173,216688) ORDER BY rp.in_squad = 1 DESC
0.0028  SELECT l.id FROM leagues_webci l WHERE l.categoryId = 1597 AND l.year = 2014
0.0021  SELECT e.action, count(e.action) as total, e.player_id FROM events2014 e WHERE e.league_id IN (12656) AND (e.action = 3 or e.action = 4) GROUP BY e.player_id ORDER BY total DESC, e.player_id ASC LIMIT 10
0.0021  SELECT dp.name, dp.last_name, dp.nick,dp.CountryCode,dp.alias,rp.team_id,dt.nameShow,dt.short_name,dt.basealias,rp.player_id,rp.teamId,dp.role FROM dataplayers AS dp INNER JOIN rel_players AS rp ON rp.player_id=dp.id AND rp.league_id IN (12656) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN (225310) ORDER BY rp.in_squad = 1 DESC