4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
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
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
I. Mwepu I. Mwepu 65 años 178cm 74kg DEF
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. Kibongé M. Kibongé 79 años 176cm 75kg MED
U. Kembo U. Kembo 76 años 164cm 65kg MED
E. Kakoko E. Kakoko 73 años 175cm 72kg DEL
M. Ekofo M. Ekofo 75 años DEL
M. Mayanga M. Mayanga 75 años 176cm 67kg DEL
19 jugadores
Congo Congo
Paul Tandou Paul Tandou POR
Maxime Matsima Maxime Matsima 83 años POR
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
François Yamba François Yamba DEF
Gabriel N`dengaki Gabriel N`dengaki 71 años DEF
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
Noël Minga Noël Minga 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

Clasificación

Equipo PJ GF GC Puntos
1 Congo Congo 3 5 2 5
2 RD Congo RD Congo 3 7 4 4
3 Guinea Guinea 3 4 4 3
4 Mauricio Mauricio 3 2 8 0

Equipos de esta liga

4

  USO DE MEMORIA  
4,669,352 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0033
Controller Execution Time ( Home / Category )  0.4012
Total Execution Time  0.4046
  CADENA URL  
/copa_africa1974/grupo2/jugadores
  GET DATOS  
$_GET['/copa_africa1974/grupo2/jugadores']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (22)  
0.0124  SELECT type FROM routes WHERE alias = 'copa_africa1974'
0.0252  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 = 2 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=2 DESC LIMIT 1
0.0126  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=138 AND type_rel = 3
0.0158  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.0136  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.0125  SELECT id,name,alias,stepParent FROM categories WHERE parentId=138 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 = 12173 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0127  SELECT dt.id FROM teams t INNER JOIN datateams dt ON t.teamId = dt.id WHERE t.league_id = 12173 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 36
0.0135  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 = 12173 AND dt.id IN (11591,3794,9162,63188) 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 17:35:16' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0127  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=2 AND last_update > '2024-04-28 17:35:16' 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=4 AND last_update > '2024-04-28 17:35:16' 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=3 AND last_update > '2024-04-28 17:35:16' 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 = '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.0126  SELECT l.id FROM leagues_webci l WHERE l.categoryId = 138 AND l.year = 1974
0.0126  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.0129  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.0127  SELECT l.id FROM leagues_webci l WHERE l.categoryId = 138 AND l.year = 1974
0.0128  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.0127  SELECT l.id FROM leagues_webci l WHERE l.categoryId = 138 AND l.year = 1974
0.0127  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
0.0133  SELECT *,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables1974` 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 = 12173 AND t.round = 3 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC