4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
17 jugadores
Sporting CP Sporting CP
F. Meszaros F. Meszaros 72 años 183cm POR
José Eduardo José Eduardo 69 años DEF
Bastos Bastos 73 años DEF
Vanio Kostov Vanio Kostov 71 años MED
Mário Jorge Mário Jorge 62 años MED
Francisco Barão Francisco Barão 66 años 176cm 72kg MED
Carlos Xavier Carlos Xavier 62 años 176cm 78kg MED
Virgilio Lopes Virgilio Lopes 66 años MED
Uchoa Uchoa 68 años MED
Kikas Kikas 67 años MED
Marinho Marinho 69 años MED
Lito Lito 67 años MED
Dušan Bukovac Dušan Bukovac 67 años MED
Zezinho Zezinho 69 años 179cm 71kg MED
Carlos Freire Carlos Freire 65 años DEL
Jordao Jordao 67 años 179cm 71kg DEL
Manuel Fernandes Manuel Fernandes 72 años 172cm 71kg DEL
15 jugadores
Sporting Braga Sporting Braga
Walter Walter 68 años POR
Dito Dito 58 años DEF
António Paris António Paris 66 años DEF
João Cardoso João Cardoso 72 años DEF
Manoel Costa Manoel Costa 71 años 187cm 72kg MED
Vítor Santos Vítor Santos 65 años 172cm 70kg MED
Wando Wando 61 años 180cm 85kg MED
Guedes Guedes 71 años MED
José Germano José Germano 70 años MED
Artur Artur 69 años MED
Malheiro Malheiro 67 años MED
Spencer Spencer 65 años MED
Vítor Oliveira Vítor Oliveira 70 años MED
Fontes Fontes 66 años MED
Jorge Gomes Jorge Gomes 69 años DEL

Equipos de esta liga

2

  USO DE MEMORIA  
4,334,464 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0029
Controller Execution Time ( Home / Category )  0.3185
Total Execution Time  0.3215
  CADENA URL  
/supercopa_portugal1983/grupo0/jugadores
  GET DATOS  
$_GET['/supercopa_portugal1983/grupo0/jugadores']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (21)  
0.0106  SELECT type FROM routes WHERE alias = 'supercopa_portugal1983'
0.0216  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'supercopa_portugal' AND (l.group_code = 0 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 1983 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=0 DESC LIMIT 1
0.0109  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=300 AND type_rel = 3
0.0111  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 3 AND rel.typeId = 300 AND rel.ln = 'es' AND rel.status=1 ORDER BY rel.creation_date desc,rel.cover_points DESC LIMIT 5
0.0119  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 (1272601,1168515,1168014,1025336,933111) ORDER BY n.cover_points DESC, update_date DESC
0.0109  SELECT id,name,alias,stepParent FROM categories WHERE parentId=300 ORDER BY order_id ASC
0.0112  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 = 25355 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0111  SELECT dt.id FROM teams t INNER JOIN datateams dt ON t.teamId = dt.id WHERE t.league_id = 25355 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 36
0.0137  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 = 25355 AND dt.id IN (4098,2386) ORDER BY dt.relations DESC,dp.role ASC
0.0105  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-05-01 19:03:43' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0105  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=2 AND last_update > '2024-05-01 19:03:43' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0105  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=4 AND last_update > '2024-05-01 19:03:43' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0105  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=3 AND last_update > '2024-05-01 19:03:43' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0107  SELECT l.id FROM leagues_webci l WHERE l.categoryId = 300 AND l.year = 1983
0.0106  SELECT e.action, count(e.action) as total, e.player_id FROM events1983 e WHERE e.league_id IN (25355) 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.0107  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 (25355) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN (421356,256304,273268,421743,450112,517320,525712) ORDER BY rp.in_squad = 1 DESC
0.0106  SELECT l.id FROM leagues_webci l WHERE l.categoryId = 300 AND l.year = 1983
0.0105  SELECT e.action, count(e.action) as total, e.player_id FROM events1983 e WHERE e.league_id IN (25355) AND (e.action = 4 or e.action = 5) GROUP BY e.player_id ORDER BY total DESC, e.player_id ASC LIMIT 10
0.0106  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 (25355) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN (449974,517320) ORDER BY rp.in_squad = 1 DESC
0.0119  SELECT l.id FROM leagues_webci l WHERE l.categoryId = 300 AND l.year = 1983
0.0112  SELECT e.action, count(e.action) as total, e.player_id FROM events1983 e WHERE e.league_id IN (25355) AND (e.action = 3 or e.action = 4) GROUP BY e.player_id ORDER BY total DESC, e.player_id ASC LIMIT 10