4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
20 jugadores
Slavia Praha Slavia Praha
P. Kovar P. Kovar 38 años 187cm 89kg POR
O. Kolar O. Kolar 29 años 193cm 81kg POR
V. Coufal V. Coufal 31 años 174cm 76kg DEF
J. Zelený J. Zelený 31 años 190cm 85kg DEF
J. Bořil J. Bořil 33 años 175cm 67kg DEF
L. Masopust L. Masopust 31 años 179cm 79kg DEF
S. Deli S. Deli 32 años 192cm 84kg DEF
O. Kúdela O. Kúdela 37 años 182cm 78kg DEF
D. Hovorka D. Hovorka 30 años 179cm 72kg DEF
J. Zmrhal J. Zmrhal 30 años 189cm 79kg MED
I. Traore I. Traore 35 años 187cm 80kg MED
J. Husbauer J. Husbauer 34 años 182cm 71kg MED
Alex Kral Alex Kral 25 años 186cm 80kg MED
J. Hromada J. Hromada 27 años 180cm 75kg MED
P. Ševčík P. Ševčík 29 años 172cm 65kg MED
Tomáš Souček Tomáš Souček 29 años 192cm 86kg MED
Yusuf Yusuf 30 años 194cm 87kg DEL
M. Van Buren M. Van Buren 31 años 184cm 73kg DEL
P. Olayinka P. Olayinka 28 años 188cm 75kg DEL
M. Baluta M. Baluta 30 años 166cm 64kg DEL
20 jugadores
Spartak Trnava Spartak Trnava
Petr Bolek Petr Bolek 39 años 190cm 91kg POR
D. Rusov D. Rusov 31 años 190cm 82kg POR
P. Urminský P. Urminský 24 años 198cm 85kg POR
I. Mesik I. Mesik 22 años 187cm 75kg DEF
B. Mitrea B. Mitrea 36 años 185cm 79kg DEF
Matus Turna Matus Turna 37 años 180cm DEF
M. Marinković M. Marinković 30 años 192cm 90kg DEF
K. Mihalek K. Mihalek 24 años 178cm 68kg DEF
Lucas Lovat Lucas Lovat 27 años 184cm 70kg DEF
T. Zahumensky T. Zahumensky 28 años 184cm 81kg DEF
J. Menich J. Menich 29 años 184cm 81kg DEF
E. Halilovic E. Halilovic 34 años 179cm 75kg MED
M. Jakúbek M. Jakúbek 29 años 185cm MED
Alexander Horvat Alexander Horvat 23 años 179cm MED
M. Tesija M. Tesija 32 años 173cm 70kg MED
M. Kelemen M. Kelemen 24 años 187cm 84kg DEL
F. Dangubić F. Dangubić 28 años 181cm 74kg DEL
R. Tavares R. Tavares 23 años 186cm 84kg DEL
A. Sobczyk A. Sobczyk 26 años 187cm 80kg DEL
F. Oršula F. Oršula 31 años 183cm 78kg DEL

Equipos de esta liga

2

  USO DE MEMORIA  
4,365,264 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0019
Controller Execution Time ( Home / Category )  0.4217
Total Execution Time  0.4236
  CADENA URL  
/supercopa_republica_checa2019/grupo0/jugadores
  GET DATOS  
$_GET['/supercopa_republica_checa2019/grupo0/jugadores']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (21)  
0.0144  SELECT type FROM routes WHERE alias = 'supercopa_republica_checa2019'
0.0291  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'supercopa_republica_checa' AND (l.group_code = 0 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 2019 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=0 DESC LIMIT 1
0.0145  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=1736 AND type_rel = 3
0.0145  SELECT id,name,alias,stepParent FROM categories WHERE parentId=1736 ORDER BY order_id ASC
0.0145  SELECT max(l.year) as max_year, min(l.year) as min_year FROM leagues l WHERE categoryID = 1736 GROUP BY l.categoryId
0.0145  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=1736 GROUP BY l.year ORDER BY l.year DESC
0.0145  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 = 63181 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0145  SELECT dt.id FROM teams t INNER JOIN datateams dt ON t.teamId = dt.id WHERE t.league_id = 63181 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 36
0.0153  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 = 63181 AND dt.id IN (10057,1106) ORDER BY dt.relations DESC,dp.role ASC
0.0145  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-05-02 20:06:10' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0145  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=2 AND last_update > '2024-05-02 20:06:10' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0145  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=4 AND last_update > '2024-05-02 20:06:10' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0145  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=3 AND last_update > '2024-05-02 20:06:10' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0146  SELECT l.id FROM leagues_webci l WHERE l.categoryId = 1736 AND l.year = 2019
0.0146  SELECT e.action, count(e.action) as total, e.player_id FROM events2019 e WHERE e.league_id IN (63181) 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.0147  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 (63181) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN (209469,70004) ORDER BY rp.in_squad = 1 DESC
0.0145  SELECT l.id FROM leagues_webci l WHERE l.categoryId = 1736 AND l.year = 2019
0.0145  SELECT e.action, count(e.action) as total, e.player_id FROM events2019 e WHERE e.league_id IN (63181) AND (e.action = 4 or e.action = 5) GROUP BY e.player_id ORDER BY total DESC, e.player_id ASC LIMIT 10
0.0151  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 (63181) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN (70869,172967,283291,834759,836097) ORDER BY rp.in_squad = 1 DESC
0.0145  SELECT l.id FROM leagues_webci l WHERE l.categoryId = 1736 AND l.year = 2019
0.0145  SELECT e.action, count(e.action) as total, e.player_id FROM events2019 e WHERE e.league_id IN (63181) AND (e.action = 3 or e.action = 4) GROUP BY e.player_id ORDER BY total DESC, e.player_id ASC LIMIT 10