4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
17 jugadores
Zambia Zambia
Emmanuel Mwape Emmanuel Mwape 74 años POR
Jani Simulambo Jani Simulambo 70 años DEF
Edwin Mbaso Edwin Mbaso 71 años DEF
Dickson Makwaza Dickson Makwaza 81 años DEF
Dick Chama Dick Chama 78 años DEF
Patrick Nkole Patrick Nkole DEF
Boniface Simutowe Boniface Simutowe 74 años MED
Godfrey Chitalu Godfrey Chitalu MED
Willie Phiri Willie Phiri 70 años MED
Kaiser Kalambo Kaiser Kalambo MED
Joseph Mapulanga Joseph Mapulanga MED
Ackim Musenge Ackim Musenge 74 años MED
Obi Kapita Obi Kapita DEL
Brighton Sinyangwe Brighton Sinyangwe DEL
Bernard Chanda Bernard Chanda 72 años DEL
Simon Kaushi Simon Kaushi 73 años DEL
Freddie Mwila Freddie Mwila 77 años DEL
18 jugadores
RD Congo RD Congo
Robert Kazadi Robert Kazadi 77 años 175cm 74kg POR
D. Tubilandu D. Tubilandu 73 años 165cm 62kg POR
M. Kazadi M. Kazadi 77 años 175cm 74kg POR
I. Mwepu I. Mwepu 65 años 178cm 74kg DEF
Raymond Bwanga Raymond Bwanga 75 años DEF
B. Lobilo B. Lobilo 74 años 170cm 70kg DEF
M. Mwanza M. Mwanza 55 años 164cm 63kg DEF
M. Kibongé M. Kibongé 79 años 176cm 75kg MED
U. Kembo U. Kembo 76 años 164cm 65kg MED
N Daye Mulamba N Daye Mulamba 75 años MED
M. Kidumu M. Kidumu 77 años 165cm 65kg MED
K. Ngoye K. Ngoye 78 años MED
Mafuila Mavuba Mafuila Mavuba 46 años MED
M. Mana M. Mana 76 años 157cm 67kg MED
W. Tshimabu W. Tshimabu 77 años 178cm 75kg MED
M. Mayanga M. Mayanga 75 años 176cm 67kg DEL
E. Kakoko E. Kakoko 73 años 175cm 72kg DEL
M. Ekofo M. Ekofo 75 años DEL
19 jugadores
Congo Congo
Maxime Matsima Maxime Matsima 83 años POR
Paul Tandou Paul Tandou POR
François Yamba François Yamba DEF
Gabriel N`dengaki Gabriel N`dengaki 71 años DEF
Gaston N`ganga-Muivi Gaston N`ganga-Muivi DEF
Jacques-Yvon N`dolou Jacques-Yvon N`dolou 79 años DEF
Koko Koko DEF
Joseph N`gassaki Joseph N`gassaki DEF
André Mbouta André Mbouta DEF
Noël Minga Noël Minga MED
Jean-Jacques N'domba Jean-Jacques N'domba 64 años 170cm 68kg MED
Paul Moukila Paul Moukila 73 años MED
Felix Ondono Felix Ondono MED
François M'pele François M'pele 76 años MED
Augustin Ndouli Augustin Ndouli DEL
Gilbert Poaty Gilbert Poaty 77 años DEL
Jonas Bahamboula Jonas Bahamboula 75 años DEL
Jean Michel Mbono Jean Michel Mbono 78 años DEL
Lakou Abossolo Lakou Abossolo DEL

Equipos de esta liga

4

  USO DE MEMORIA  
4,514,792 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0032
Controller Execution Time ( Home / Category )  0.3135
Total Execution Time  0.3167
  CADENA URL  
/copa_africa1974/grupo0/jugadores
  GET DATOS  
$_GET['/copa_africa1974/grupo0/jugadores']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (19)  
0.0105  SELECT type FROM routes WHERE alias = 'copa_africa1974'
0.0217  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'copa_africa' AND (l.group_code = 0 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 1974 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=0 DESC LIMIT 1
0.0123  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=138 AND type_rel = 3
0.0120  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 3 AND rel.typeId = 138 AND rel.ln = 'es' AND rel.status=1 ORDER BY rel.creation_date desc,rel.cover_points DESC LIMIT 5
0.0109  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 (1307722,1303017,1302338,1301953,1301801) ORDER BY n.cover_points DESC, update_date DESC
0.0106  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 = 12175 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0107  SELECT dt.id FROM teams t INNER JOIN datateams dt ON t.teamId = dt.id WHERE t.league_id = 12175 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 36
0.0115  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 = 12175 AND dt.id IN (3788,3789,11591,9162) ORDER BY dt.relations DESC,dp.role ASC
0.0106  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-04-27 16:49:56' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0106  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=2 AND last_update > '2024-04-27 16:49:56' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0107  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=4 AND last_update > '2024-04-27 16:49:56' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0106  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=3 AND last_update > '2024-04-27 16:49:56' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0109  SELECT l.id FROM leagues_webci l WHERE l.categoryId = 138 AND l.year = 1974
0.0108  SELECT e.action, count(e.action) as total, e.player_id FROM events1974 e WHERE e.league_id IN (12175,12173,12172) 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.0112  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 (12175,12173,12172) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN (984589,984611,388136,983802,984474,401820,591838,983747,984234,984613) ORDER BY rp.in_squad = 1 DESC
0.0117  SELECT l.id FROM leagues_webci l WHERE l.categoryId = 138 AND l.year = 1974
0.0116  SELECT e.action, count(e.action) as total, e.player_id FROM events1974 e WHERE e.league_id IN (12175,12173,12172) AND (e.action = 4 or e.action = 5) GROUP BY e.player_id ORDER BY total DESC, e.player_id ASC LIMIT 10
0.0119  SELECT l.id FROM leagues_webci l WHERE l.categoryId = 138 AND l.year = 1974
0.0120  SELECT e.action, count(e.action) as total, e.player_id FROM events1974 e WHERE e.league_id IN (12175,12173,12172) AND (e.action = 3 or e.action = 4) GROUP BY e.player_id ORDER BY total DESC, e.player_id ASC LIMIT 10