4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
TP Mazembe TP Mazembe
Kitikina Kitikina
I. Mpeko I. Mpeko 38 años DEF
K. Chongo K. Chongo 32 años 179cm 76kg DEF
T. Mwape T. Mwape 27 años 180cm DEF
K. Mundeko K. Mundeko 28 años 183cm DEF
A. Youssifou A. Youssifou 27 años DEF
S. Zemanga S. Zemanga 31 años 177cm MED
M. Ngimbi M. Ngimbi 27 años 176cm MED
P. Mwamba Mwamba P. Mwamba Mwamba MED
T. Ulimwengu T. Ulimwengu 30 años 178cm 76kg DEL
T. Mputu T. Mputu 38 años 172cm DEL
P. Kinzumbi P. Kinzumbi 26 años 182cm DEL
K. Bileko K. Bileko 23 años DEL
Adam Nzali Adam Nzali 24 años DEL
R. Kalaba R. Kalaba 37 años 166cm 56kg DEL
J. Kitambala J. Kitambala 24 años DEL
E. Mayombo E. Mayombo 25 años 170cm DEL
J. Othos J. Othos 23 años 170cm DEL
AS Vita Club AS Vita Club
J. Temopele J. Temopele
P. Mbarga P. Mbarga 26 años MED
M. Wamba M. Wamba 25 años MED
M. Tchakei M. Tchakei 28 años MED
K. Mujinga K. Mujinga 30 años DEL
Éric Kabwe Éric Kabwe 22 años DEL
J. Medina Themopole J. Medina Themopole 26 años 187cm DEL
Makabi Lilepo Makabi Lilepo 26 años 185cm DEL
O. Mayamba O. Mayamba 29 años DEL
Motema Pembe Motema Pembe
Mtange L. Mtange L.
Mwana D. Mwana D.
P. Disengomoka P. Disengomoka 26 años DEF
B. Tomandzoto B. Tomandzoto 21 años 173cm MED
B. Nkongo B. Nkongo 26 años DEL
Saint-Eloi Lupopo Saint-Eloi
H. Kasongo H. Kasongo
Landu Landu
Z. Kazadi Z. Kazadi 25 años MED
E. Ikoko E. Ikoko 23 años MED
P. Kabangu P. Kabangu 38 años 182cm 78kg DEL
J. Kazema J. Kazema 23 años DEL
Allan Kateregga Allan Kateregga 29 años 175cm 74kg DEL
E. Lobota E. Lobota 24 años DEL
Sanga Balende Sanga Balende
Don Bosco Lubumbashi Bosco Lubumbashi
Israël Mubobo Israël Mubobo 25 años POR
Maniema Union Maniema Union
P. Archimude P. Archimude
Wango Mbambu Wango Mbambu 29 años MED
K. Kalowa K. Kalowa 27 años DEL
R. Shabani R. Shabani DEL
Lubumbashi Sport Lubumbashi Sport
Renaissance Renaissance
J. Vous J. Vous
Aristote Aristote
A. Mambote A. Mambote
M. Kusema M. Kusema
Gracia Gracia
O. Sangana O. Sangana 20 años MED
F. Bardiro F. Bardiro 27 años 184cm DEL
Etoile de Kivu Etoile de Kivu

JUGADORES DESTACADOS

Clasificación

Equipo PJ GF GC Puntos
1 TP Mazembe TP Mazembe 19 40 3 51
2 Saint-Eloi Lupopo Saint-Eloi 20 33 9 49
3 AS Vita Club Vita Club 19 44 13 48
4 Maniema Union Maniema 18 28 10 38
5 Groupe Bazano Groupe 20 24 16 33
6 Don Bosco Lubumbashi Bosco 20 21 16 33
7 Motema Pembe Motema Pembe 19 23 15 29
8 Rangers Rangers 19 18 19 28
9 Panda 05 Panda 05 19 17 19 24
10 Sanga Balende Sanga 21 18 26 23
11 Etoile de Kivu Etoile Kivu 19 13 15 22
12 Lubumbashi Sport Lubumbashi 19 19 23 22
13 Dauphins Noirs Dauphins 19 15 20 20
14 Blessing Blessing 19 13 16 19
15 Kuya Sport Kuya Sport 19 18 28 19
16 Renaissance Renaissance 19 17 27 18
17 Tshinkunku Tshinkunku 19 11 26 15
18 Simba Simba 19 10 29 14
19 JSK JSK 19 6 36 8
20 RCK RCK 19 10 32 7

  USO DE MEMORIA  
5,306,472 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0019
Controller Execution Time ( Home / Category )  0.0659
Total Execution Time  0.0678
  CADENA URL  
/super_liga_republica_congo2022/grupo1/jugadores
  GET DATOS  
$_GET['/super_liga_republica_congo2022/grupo1/jugadores']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (14)  
0.0019  SELECT type FROM routes WHERE alias = 'super_liga_republica_congo2022'
0.0039  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'super_liga_republica_congo' AND (l.group_code = 1 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 2022 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=1 DESC LIMIT 1
0.0022  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 = 64302 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0019  SELECT dt.id FROM teams t INNER JOIN datateams dt ON t.teamId = dt.id WHERE t.league_id = 64302 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 36
0.0039  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 = 64302 AND dt.id IN (15707,15709,15710,15708,15718,60138,108457,15711,60140,61658,96944,15715,61659,109014,96942,139562,109013,144041,144042,139563) ORDER BY dt.relations DESC,dp.role ASC
0.0018  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-04-26 13:49:00' 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=2 AND last_update > '2024-04-26 13:49:00' 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=4 AND last_update > '2024-04-26 13:49:00' 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-04-26 13:49:00' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0024  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'super_liga_republica_congo' AND (l.group_code = 0 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 2022 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=0 DESC LIMIT 1
0.0028  SELECT e.action, count(e.action) as total,p.name, p.last_name, p.nick,p.CountryCode,p.alias,rp.team_id,dt.nameShow,dt.short_name,dt.basealias,rp.player_id,rp.teamId FROM `rel_players` rp INNER JOIN dataplayers p ON p.id = rp.player_id INNER JOIN events2022 e ON e.player_id = p.id AND e.league_id = 64302 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 64302 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 LIMIT 10
0.0020  SELECT e.action, count(e.action) as total,p.name, p.last_name, p.nick,p.CountryCode,p.alias,rp.team_id,dt.nameShow,dt.short_name,dt.basealias,rp.player_id,rp.teamId FROM `rel_players` rp INNER JOIN dataplayers p ON p.id = rp.player_id INNER JOIN events2022 e ON e.player_id = p.id AND e.league_id = 64302 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 64302 AND (e.action = 4 or e.action = 5) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0020  SELECT e.action, count(e.action) as total,p.name, p.last_name, p.nick,p.CountryCode,p.alias,rp.team_id,dt.nameShow,dt.short_name,dt.basealias,rp.player_id,rp.teamId FROM `rel_players` rp INNER JOIN dataplayers p ON p.id = rp.player_id INNER JOIN events2022 e ON e.player_id = p.id AND e.league_id = 64302 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 64302 AND (e.action = 3 or e.action = 4) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0050  SELECT *,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables2022` 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 = 64302 AND t.round = 19 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC