4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
19 jugadores
Colombia Colombia
Armando Acosta Armando Acosta 73 años POR
Antonio Rivas Antonio Rivas 72 años POR
Silvio Quintero Silvio Quintero 72 años 160cm POR
Orlando Rivas Orlando Rivas 73 años DEF
Gerardo Moncada Gerardo Moncada 74 años DEF
Dumas Guette Dumas Guette 71 años DEF
Henry Caicedo Henry Caicedo 71 años DEF
Rafael Reyes Rafael Reyes 72 años 170cm 68kg DEF
Alvaro Calle Alvaro Calle 70 años DEF
Fabio Espinosa Fabio Espinosa 75 años MED
Vicente Rebellón Vicente Rebellón 73 años MED
Domingo González Domingo González 31 años MED
Willington Ortiz Willington Ortiz 72 años MED
Carlos Alvaro Santamaria Ochoa Carlos Alvaro Santamaria Ochoa 73 años DEL
Jaime Morón Jaime Morón 55 años 172cm DEL
Luis Alberto Montaño Luis Alberto Montaño 71 años DEL
Carlos Lugo Carlos Lugo 67 años 170cm DEL
Jose Ernesto Diaz Jose Ernesto Diaz 71 años DEL
Ángel Torres Ángel Torres 71 años 170cm 62kg DEL
19 jugadores
Polonia Polonia
M. Szeja M. Szeja 82 años POR
Hubert Kostka Hubert Kostka 83 años POR
A. Szymanowski A. Szymanowski 73 años DEF
J. Gorgon J. Gorgon 74 años DEF
Zygmunt Anczok Zygmunt Anczok 78 años 177cm DEF
Marian Ostafiński Marian Ostafiński 77 años DEF
Z. Gut Z. Gut 60 años 180cm 75kg DEF
L. Cmikiewicz L. Cmikiewicz 75 años MED
K. Kmiecik K. Kmiecik 72 años 175cm 70kg MED
Zygfryd Szołtysik Zygfryd Szołtysik 81 años MED
G. Lato G. Lato 74 años MED
Z. Maszczyk Z. Maszczyk 78 años MED
K. Deyna K. Deyna 41 años MED
Jerzy Kraska Jerzy Kraska 72 años MED
Joachim Marx Joachim Marx 79 años DEL
W. Lubanski W. Lubanski 77 años 178cm 76kg DEL
R. Gadocha R. Gadocha 78 años DEL
Andrzej Jarosik Andrzej Jarosik 79 años DEL
Ryszard Szymczak Ryszard Szymczak 79 años DEL
19 jugadores
RD Alemania RD Alemania
J. Croy J. Croy 77 años 186cm 87kg POR
Dieter Schneider Dieter Schneider 74 años POR
B. Bransch B. Bransch 77 años 180cm 77kg DEF
Frank Ganzera Frank Ganzera 81 años DEF
Manfred Zapf Manfred Zapf 77 años DEF
K. Weise K. Weise 72 años 174cm 65kg DEF
L. Kurbjuweit L. Kurbjuweit 73 años 179cm 88kg DEF
S. Wätzlich S. Wätzlich 71 años 176cm 72kg DEF
W. Seguin W. Seguin 78 años 178cm 75kg MED
Axel Tyll Axel Tyll 70 años MED
H. Irmscher H. Irmscher 78 años 180cm 77kg MED
J. Pommerenke J. Pommerenke 71 años 174cm 71kg MED
Reinhard Häfner Reinhard Häfner 64 años MED
H. Kreische H. Kreische 76 años 185cm 73kg DEL
E. Vogel E. Vogel 81 años 179cm 79kg DEL
P. Ducke P. Ducke 82 años 178cm 74kg DEL
J. Streich J. Streich 71 años 173cm 70kg DEL
Ralf Schulenberg Ralf Schulenberg 74 años DEL
J. Sparwasser J. Sparwasser 75 años 180cm 78kg DEL

Clasificación

Equipo PJ GF GC Puntos
1 Polonia Polonia 3 11 2 6
2 RD Alemania RD Alemania 3 11 3 4
3 Colombia Colombia 3 5 12 2
4 Ghana Ghana 3 1 11 0

Equipos de esta liga

4

  USO DE MEMORIA  
4,677,920 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0024
Controller Execution Time ( Home / Category )  0.3846
Total Execution Time  0.3870
  CADENA URL  
/juegos_olimpicos1972/grupo4/jugadores
  GET DATOS  
$_GET['/juegos_olimpicos1972/grupo4/jugadores']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (21)  
0.0125  SELECT type FROM routes WHERE alias = 'juegos_olimpicos1972'
0.0252  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'juegos_olimpicos' AND (l.group_code = 4 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 1972 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=4 DESC LIMIT 1
0.0125  SELECT id,name,alias,stepParent FROM categories WHERE parentId=264 ORDER BY order_id ASC
0.0127  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 = 13335 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0125  SELECT dt.id FROM teams t INNER JOIN datateams dt ON t.teamId = dt.id WHERE t.league_id = 13335 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 36
0.0131  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 = 13335 AND dt.id IN (3774,3726,3791,62908) ORDER BY dt.relations DESC,dp.role ASC
0.0126  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-04-28 12:20:31' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0125  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=2 AND last_update > '2024-04-28 12:20:31' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0126  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=4 AND last_update > '2024-04-28 12:20:31' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0129  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=3 AND last_update > '2024-04-28 12:20:31' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0131  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'juegos_olimpicos' AND (l.group_code = 0 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 1972 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=0 DESC LIMIT 1
0.0138  SELECT l.id FROM leagues_webci l WHERE l.categoryId = 264 AND l.year = 1972
0.0140  SELECT e.action, count(e.action) as total, e.player_id FROM events1972 e WHERE e.league_id IN (13337,13338,13332,13333,13334,13335,13336) 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.0130  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 (13337,13338,13332,13333,13334,13335,13336) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN (382780,389530,382593,382783,388107,403591,388057,388060,395920,256547) ORDER BY rp.in_squad = 1 DESC
0.0128  SELECT l.id FROM leagues_webci l WHERE l.categoryId = 264 AND l.year = 1972
0.0135  SELECT e.action, count(e.action) as total, e.player_id FROM events1972 e WHERE e.league_id IN (13337,13338,13332,13333,13334,13335,13336) AND (e.action = 4 or e.action = 5) GROUP BY e.player_id ORDER BY total DESC, e.player_id ASC LIMIT 10
0.0134  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 (13337,13338,13332,13333,13334,13335,13336) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN (401997,388109,389522,389531,401965,401968,256547,359236,382784,382849) ORDER BY rp.in_squad = 1 DESC
0.0132  SELECT l.id FROM leagues_webci l WHERE l.categoryId = 264 AND l.year = 1972
0.0161  SELECT e.action, count(e.action) as total, e.player_id FROM events1972 e WHERE e.league_id IN (13337,13338,13332,13333,13334,13335,13336) AND (e.action = 3 or e.action = 4) GROUP BY e.player_id ORDER BY total DESC, e.player_id ASC LIMIT 10
0.0163  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 (13337,13338,13332,13333,13334,13335,13336) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN (401965) ORDER BY rp.in_squad = 1 DESC
0.0143  SELECT *,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables1972` 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 = 13335 AND t.round = 3 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC