4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
24 jugadores
APOEL APOEL
Vid Belec Vid Belec 33 años 192cm 84kg POR
B. Waterman B. Waterman 40 años 188cm 83kg POR
G. Merkis G. Merkis 39 años 188cm 83kg DEF
C. Sielis C. Sielis 24 años 186cm 75kg DEF
Joãozinho Joãozinho 34 años 185cm 69kg DEF
V. Savić V. Savić 33 años 194cm 83kg DEF
N. Ioannou N. Ioannou 28 años 183cm 75kg DEF
K. Lafrance K. Lafrance 34 años 186cm 82kg DEF
Dragan Mihajlović Dragan Mihajlović 32 años 177cm 74kg DEF
S. Gentsoglou S. Gentsoglou 33 años 185cm 77kg MED
Lucas Lucas 33 años 186cm 80kg MED
Uros Matic Uros Matic 33 años 184cm 78kg MED
Alef Alef 29 años 186cm 71kg MED
T. De Vincenti T. De Vincenti 35 años 178cm 72kg MED
N. Balogh N. Balogh 28 años 196cm 80kg DEL
André Vidigal André Vidigal 25 años 176cm 67kg DEL
Andrija Pavlovic Andrija Pavlovic 30 años 189cm 85kg DEL
Antonio Jakoliš Antonio Jakoliš 32 años 175cm 63kg DEL
R. Bezjak R. Bezjak 35 años 179cm 73kg DEL
E. Aloneftis E. Aloneftis 41 años 166cm 58kg DEL
G. Efrem G. Efrem 34 años 171cm 65kg DEL
M. Al-Tamari M. Al-Tamari 26 años 178cm DEL
L. Hallenius L. Hallenius 35 años 185cm 75kg DEL
A. Makris A. Makris 28 años 171cm 68kg DEL
27 jugadores
AEL Limassol AEL Limassol
Vózinha Vózinha 37 años 189cm 75kg POR
P. Procek P. Procek 29 años 192cm POR
S. Panteli S. Panteli 24 años 176cm DEF
André Teixeira André Teixeira 30 años 182cm 73kg DEF
M. Rašo M. Rašo 27 años 186cm 73kg DEF
M. Moustakis M. Moustakis 24 años DEF
Charis Kyriakou Charis Kyriakou 34 años 180cm 71kg DEF
M. Antoniou M. Antoniou 30 años 185cm DEF
Christos Wheeler Christos Wheeler 26 años 171cm DEF
B. Godál B. Godál 36 años 188cm 82kg DEF
D. Avraam D. Avraam 23 años 178cm DEF
N. Teixeira N. Teixeira 33 años 175cm 72kg DEF
Dossa Júnior Dossa Júnior 37 años 188cm 82kg DEF
A. Avraam A. Avraam 36 años 171cm 67kg MED
S. Medojević S. Medojević 33 años 183cm 78kg MED
G. Gerolemou G. Gerolemou 24 años 176cm MED
A. Aganović A. Aganović 36 años 181cm 77kg MED
D. Zdravkovski D. Zdravkovski 26 años 175cm MED
Jon Gaztañaga Jon Gaztañaga 32 años 181cm 78kg MED
Marko Adamovic Marko Adamovic 33 años 177cm MED
G. Ghazaryan G. Ghazaryan 36 años 180cm DEL
K. Markoski K. Markoski 29 años 180cm 78kg DEL
J. Antonia J. Antonia 33 años 169cm 65kg DEL
Ivan Carlos Ivan Carlos 34 años DEL
M. Torres M. Torres 33 años 174cm 65kg DEL
Ryan Mmaee Ryan Mmaee 26 años 185cm 85kg DEL
R. Jurado R. Jurado 38 años 180cm 82kg DEL

Equipos de esta liga

2

  USO DE MEMORIA  
4,368,304 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0018
Controller Execution Time ( Home / Category )  0.0727
Total Execution Time  0.0746
  CADENA URL  
/supercopa_chipre2020/grupo0/jugadores
  GET DATOS  
$_GET['/supercopa_chipre2020/grupo0/jugadores']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (21)  
0.0019  SELECT type FROM routes WHERE alias = 'supercopa_chipre2020'
0.0045  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'supercopa_chipre' AND (l.group_code = 0 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 2020 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=1808 AND type_rel = 3
0.0025  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 3 AND rel.typeId = 1808 AND rel.ln = 'es' AND rel.status=1 ORDER BY rel.creation_date desc,rel.cover_points DESC LIMIT 5
0.0025  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 (1162994,717034,513592) ORDER BY n.cover_points DESC, update_date DESC
0.0020  SELECT id,name,alias,stepParent FROM categories WHERE parentId=1808 ORDER BY order_id ASC
0.0022  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 = 50252 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0021  SELECT dt.id FROM teams t INNER JOIN datateams dt ON t.teamId = dt.id WHERE t.league_id = 50252 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 36
0.0043  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 = 50252 AND dt.id IN (10076,4808) ORDER BY dt.relations DESC,dp.role ASC
0.0021  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-05-02 02:57:54' 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 02:57:54' 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=4 AND last_update > '2024-05-02 02:57:54' 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=3 AND last_update > '2024-05-02 02:57:54' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0022  SELECT l.id FROM leagues_webci l WHERE l.categoryId = 1808 AND l.year = 2020
0.0022  SELECT e.action, count(e.action) as total, e.player_id FROM events2020 e WHERE e.league_id IN (50252) 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.0024  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 (50252) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN (138515) ORDER BY rp.in_squad = 1 DESC
0.0023  SELECT l.id FROM leagues_webci l WHERE l.categoryId = 1808 AND l.year = 2020
0.0023  SELECT e.action, count(e.action) as total, e.player_id FROM events2020 e WHERE e.league_id IN (50252) AND (e.action = 4 or e.action = 5) GROUP BY e.player_id ORDER BY total DESC, e.player_id ASC LIMIT 10
0.0027  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 (50252) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN (110494,205184,231361) ORDER BY rp.in_squad = 1 DESC
0.0025  SELECT l.id FROM leagues_webci l WHERE l.categoryId = 1808 AND l.year = 2020
0.0023  SELECT e.action, count(e.action) as total, e.player_id FROM events2020 e WHERE e.league_id IN (50252) AND (e.action = 3 or e.action = 4) GROUP BY e.player_id ORDER BY total DESC, e.player_id ASC LIMIT 10