4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
18 jugadores
Barcelona Barcelona
Carles Busquets Carles Busquets 56 años 180cm 80kg POR
A. Zubizarreta A. Zubizarreta 62 años 187cm 86kg POR
Juan Carlos Juan Carlos 59 años 172cm 71kg DEF
Serna Serna 60 años 184cm 77kg DEF
R. Koeman R. Koeman 61 años 181cm 79kg DEF
M. Nadal M. Nadal 57 años 187cm 83kg DEF
Nando Nando 56 años 187cm 84kg DEF
Alexanko Alexanko 67 años DEF
Richard Witschge Richard Witschge 54 años MED
Eusebio Eusebio 60 años 171cm 70kg MED
Pep Guardiola Pep Guardiola 53 años 180cm 76kg MED
G. Amor G. Amor 56 años 174cm 69kg MED
J. Bakero J. Bakero 61 años 172cm 72kg MED
Goikoetxea Goikoetxea 58 años 175cm 75kg DEL
A. Begiristain A. Begiristain 59 años 171cm 70kg DEL
Julio Salinas Julio Salinas 61 años 188cm 80kg DEL
M. Laudrup M. Laudrup 59 años 183cm 76kg DEL
H. Stoichkov H. Stoichkov 58 años 178cm 76kg DEL
18 jugadores
Benfica Benfica
Barros Neno Barros Neno 62 años POR
Rui Bento Rui Bento 52 años DEF
William William 56 años DEF
António Veloso António Veloso 67 años DEF
Paulo Madeira Paulo Madeira 53 años 183cm 81kg DEF
Jose Carlos Jose Carlos 57 años DEF
Jonas Thern Jonas Thern 57 años 183cm 73kg MED
Rui Costa Rui Costa 52 años 180cm 70kg MED
Vasiliy Kulkov Vasiliy Kulkov 57 años 179cm 72kg MED
Vítor Paneira Vítor Paneira 58 años MED
Stefan Schwarz Stefan Schwarz 55 años 183cm 76kg MED
Paulo Sousa Paulo Sousa 53 años 177cm 73kg MED
Isaías Isaías 60 años 178cm 81kg MED
Mats Magnusson Mats Magnusson 60 años DEL
Rui Águas Rui Águas 64 años DEL
César Brito César Brito 59 años 176cm 73kg DEL
S. Yuran S. Yuran 54 años 178cm 80kg DEL
Antonio Pacheco Antonio Pacheco 57 años DEL
22 jugadores
Dynamo Kyiv Dynamo Kyiv
V. Martinkėnas V. Martinkėnas 59 años POR
Igor Kutepov Igor Kutepov 58 años 186cm 88kg POR
Sergiy Shmatovalenko Sergiy Shmatovalenko 57 años 182cm 78kg DEF
V. Ternavsky V. Ternavsky 54 años DEF
Sergey Zayets Sergey Zayets 54 años 188cm 82kg DEF
Yuriy Gritsyna Yuriy Gritsyna 52 años 176cm 70kg DEF
O. Luzhniy O. Luzhniy 55 años 183cm 78kg DEF
Y. Sukiasyan Y. Sukiasyan 57 años DEF
A. Tsveiba A. Tsveiba 57 años DEF
Yuriy Moroz Yuriy Moroz 53 años 183cm 78kg DEF
Andriy Aleksanenkov Andriy Aleksanenkov 55 años 181cm 76kg MED
Anatoliy Bessmertniy Anatoliy Bessmertniy 55 años 182cm 70kg MED
S. Kovalets S. Kovalets 55 años 170cm MED
Sergei Volotek Sergei Volotek 56 años MED
Viktor Moroz Viktor Moroz 56 años 182cm 74kg MED
Andriy Annenkov Andriy Annenkov 55 años 174cm 70kg MED
P. Yakovenko P. Yakovenko 59 años MED
Stephan Betsa Stephan Betsa 53 años 176cm 72kg MED
Oleg Salenko Oleg Salenko 54 años 181cm 80kg DEL
G. Kvitkauskas G. Kvitkauskas 57 años DEL
Volodymyr Sharan Volodymyr Sharan 52 años 178cm DEL
Oleg Matveyev Oleg Matveyev 53 años 174cm 70kg DEL
18 jugadores
Sparta Praha Sparta Praha
Petr Kouba Petr Kouba 55 años 184cm 75kg POR
J. Chovanec J. Chovanec 64 años DEF
P. Vrabec P. Vrabec 61 años DEF
Michal Hornak Michal Hornak 54 años DEF
Jiří Novotný Jiří Novotný 54 años DEF
J. Nemec J. Nemec 57 años 176cm 74kg MED
Vítězslav Lavička Vítězslav Lavička 61 años MED
Jan Sopko Jan Sopko 55 años MED
Rudolf Matta Rudolf Matta 55 años MED
V. Nemecek V. Nemecek 57 años MED
M. Frydek M. Frydek 55 años 170cm 74kg MED
R. Vonášek R. Vonášek 55 años MED
Marek Trval Marek Trval 56 años MED
L. Mistr L. Mistr 55 años MED
Joksimovic Joksimovic 59 años 185cm 84kg DEL
Kukleta Kukleta 46 años 178cm 72kg DEL
H. Siegl H. Siegl 55 años 182cm DEL
P. Černý P. Černý 61 años DEL

Clasificación

Equipo PJ GF GC Puntos
1 Barcelona Barcelona 6 10 4 9
2 Sparta Praha Sparta Praha 6 7 7 6
3 Benfica Benfica 6 8 5 5
4 Dynamo Kyiv Dynamo Kyiv 6 3 12 4

Equipos de esta liga

4

  USO DE MEMORIA  
4,709,624 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0020
Controller Execution Time ( Home / Category )  0.0694
Total Execution Time  0.0714
  CADENA URL  
/champions1992/grupo2/jugadores
  GET DATOS  
$_GET['/champions1992/grupo2/jugadores']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (20)  
0.0018  SELECT type FROM routes WHERE alias = 'champions1992'
0.0039  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'champions' AND (l.group_code = 2 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 1992 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=2 DESC LIMIT 1
0.0019  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 = 10970 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0020  SELECT dt.id FROM teams t INNER JOIN datateams dt ON t.teamId = dt.id WHERE t.league_id = 10970 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 36
0.0036  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 = 10970 AND dt.id IN (429,466,4257,10050) 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-01 11:18:56' 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=2 AND last_update > '2024-05-01 11:18:56' 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-01 11:18:56' 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=3 AND last_update > '2024-05-01 11:18:56' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0022  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'champions' AND (l.group_code = 0 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 1992 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=0 DESC LIMIT 1
0.0021  SELECT l.id FROM leagues_webci l WHERE l.categoryId = 107 AND l.year = 1992
0.0021  SELECT e.action, count(e.action) as total, e.player_id FROM events1992 e WHERE e.league_id IN (10969,10970,71173) 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.0023  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 (10969,10970,71173) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN (258493,267429,258463,264966,265346,265705,11845,252382,252425,258845) ORDER BY rp.in_squad = 1 DESC
0.0020  SELECT l.id FROM leagues_webci l WHERE l.categoryId = 107 AND l.year = 1992
0.0020  SELECT e.action, count(e.action) as total, e.player_id FROM events1992 e WHERE e.league_id IN (10969,10970,71173) 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 (10969,10970,71173) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN (252382,264966,264982,265091) ORDER BY rp.in_squad = 1 DESC
0.0020  SELECT l.id FROM leagues_webci l WHERE l.categoryId = 107 AND l.year = 1992
0.0020  SELECT e.action, count(e.action) as total, e.player_id FROM events1992 e WHERE e.league_id IN (10969,10970,71173) 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 (10969,10970,71173) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN (252305,258881,324236,346469,353335,447062) ORDER BY rp.in_squad = 1 DESC
0.0028  SELECT *,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables1992` 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 = 10970 AND t.round = 6 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC