4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
6 jugadores
Zesco United Zesco United
J. Ching’Andu J. Ching’Andu 30 años MED
E. Sabumukama E. Sabumukama 28 años MED
D. Daka D. Daka 27 años MED
J. Were J. Were 35 años DEL
M. Kalengo M. Kalengo 25 años DEL
L. Kambole L. Kambole 30 años 170cm DEL
8 jugadores
Zanaco Zanaco
Kennedy Phiri Kennedy Phiri 32 años
R. Kola R. Kola 37 años POR
M. Souleymanou M. Souleymanou 29 años DEF
Boyd Musonda Boyd Musonda 26 años MED
E. Mbewe E. Mbewe 29 años 160cm 60kg MED
C. Zulu C. Zulu 28 años MED
C. Mususu C. Mususu 29 años DEL
C. Maisha C. Maisha 33 años DEL
9 jugadores
Nkana FC Nkana FC
Sabwa B. Sabwa B.
K. Kampamba K. Kampamba 27 años MED
F. Tshimenga F. Tshimenga 33 años MED
Simon Bwalya Simon Bwalya 39 años MED
H. Chisala H. Chisala 26 años MED
F. Mbewe F. Mbewe 35 años DEL
B. Mwape B. Mwape 32 años DEL
R. Kampamba R. Kampamba 29 años DEL
I. Mbombo I. Mbombo 27 años 182cm 72kg DEL
5 jugadores
Red Arrows Red Arrows
Sibanda Sibanda
E. Musonda E. Musonda
C. Lukwembe C. Lukwembe
Jim Phiri Jim Phiri 25 años POR
Justine Zulu Justine Zulu 34 años MED
5 jugadores
Power Dynamos Power Dynamos
Mukupa Mukupa
L. Kafway L. Kafway
Jimmy Dzingai Jimmy Dzingai 33 años DEF
K. Mudenda K. Mudenda 36 años MED
L. Bwalya L. Bwalya 28 años 177cm MED
4 jugadores
Green Buffaloes Green Buffaloes
Dennis Banda Dennis Banda 35 años DEF
S. Kabamba S. Kabamba 33 años DEF
D. Chikwekwe D. Chikwekwe 30 años MED
J. Chirwa J. Chirwa 28 años MED
9 jugadores
Forest Rangers Forest Rangers
M. Soko M. Soko
Damiano Damiano 23 años
Mbelenge Mbelenge
N. Mulilo N. Mulilo
Kobe Kobe
G. Chisha G. Chisha
D. Muwowo D. Muwowo MED
Laurent Muma Laurent Muma 30 años MED
W. Muzaza W. Muzaza 26 años MED
5 jugadores
Kabwe Warriors Kabwe Warriors
Maziwisa N. Maziwisa N.
B. Bindu B. Bindu
Okutu Okutu
F. Musinde F. Musinde DEF
T. Mwape T. Mwape 27 años 180cm DEF
4 jugadores
NAPSA Stars FC NAPSA Stars FC
A. Banda A. Banda
A. Mwamba A. Mwamba 28 años DEF
L. Lungu L. Lungu 37 años DEL
B. Mwape B. Mwape 32 años DEL
6 jugadores
Lusaka Dynamos Lusaka Dynamos
M. Lemisa M. Lemisa
M. Jere M. Jere MED
C. Chama C. Chama 32 años 173cm MED
M. Nsofwa M. Nsofwa MED
C. Luchanga C. Luchanga 27 años DEL
Yudah Mugalu Yudah Mugalu 35 años DEL
2 jugadores
Nchanga Rangers Nchanga Rangers
R. Kasonde R. Kasonde 30 años MED
C. Kawonga C. Kawonga 29 años DEL
6 jugadores
Nakambala Leopards Nakambala
Mugula Mugula
Ian Otieno Ian Otieno 30 años POR
Noel Phiri Noel Phiri 36 años DEF
J. Mupeta J. Mupeta 38 años MED
White Simwanza White Simwanza 39 años MED
Lottie Nyimbili Lottie Nyimbili 38 años MED
7 jugadores
Buildcon FC Buildcon FC
R. Osumanu R. Osumanu 28 años
B. Bah B. Bah
Silwaba L. Silwaba L.
L. Chungu L. Chungu 32 años DEF
C. Mushili C. Mushili 36 años MED
Brian Mwila Brian Mwila 29 años 182cm 75kg MED
Fahad Bayo Fahad Bayo 25 años 185cm DEL
7 jugadores
Lumwana Radiants Lumwana Radiants
S. Kaunda S. Kaunda
M. Ndala M. Ndala
H. Silwimba H. Silwimba
O. Masumbuko O. Masumbuko
F. Kapumbu F. Kapumbu 33 años DEF
Ahmed Kapila Ahmed Kapila 28 años MED
N. Nawa N. Nawa DEL
5 jugadores
Kitwe United Kitwe United
R. Siame R. Siame
Moses L. Moses L.
Songwe Chalwe Songwe Chalwe 41 años DEL
R. Mukenge R. Mukenge DEL
E. Chabula E. Chabula 26 años DEL

JUGADORES DESTACADOS

Clasificación

Equipo PJ GF GC Puntos
1 Zesco United Zesco United 38 53 22 80
2 Nkana FC Nkana FC 38 66 27 76
3 Green Buffaloes Green 38 39 19 74
4 Green Eagles Green Eagles 38 52 29 71
5 Zanaco Zanaco 38 53 40 67
6 Power Dynamos Power 38 48 33 62
7 Kabwe Warriors Kabwe 38 31 27 58
8 Buildcon FC Buildcon FC 38 44 37 56
9 Red Arrows Red Arrows 38 34 31 53
10 Nkwazi Nkwazi 38 31 29 51
11 Lusaka Dynamos Lusaka 38 47 48 51
12 Forest Rangers Forest 38 38 39 51
13 Kitwe United Kitwe United 38 36 37 46
14 NAPSA Stars FC NAPSA Stars 38 29 30 45
15 Nakambala Leopards Nakambala 38 18 32 43
16 Lumwana Radiants Lumwana 38 24 40 41
17 National Assembly National 38 38 55 39
18 Kabwe YSA Kabwe YSA 38 28 59 27
19 Nchanga Rangers Nchanga 38 16 47 26
20 New Monze Swallows Monze 38 16 60 18

  USO DE MEMORIA  
5,569,792 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0032
Controller Execution Time ( Home / Category )  0.3493
Total Execution Time  0.3525
  CADENA URL  
/premier_league_zambia2018/grupo1/jugadores
  GET DATOS  
$_GET['/premier_league_zambia2018/grupo1/jugadores']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (18)  
0.0125  SELECT type FROM routes WHERE alias = 'premier_league_zambia2018'
0.0254  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'premier_league_zambia' AND (l.group_code = 1 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 2018 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=1 DESC LIMIT 1
0.0125  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=480 AND type_rel = 3
0.0129  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 3 AND rel.typeId = 480 AND rel.ln = 'es' AND rel.status=1 ORDER BY rel.creation_date desc,rel.cover_points DESC LIMIT 5
0.0129  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 (1221330,590567,574279) ORDER BY n.cover_points DESC, update_date DESC
0.0124  SELECT id,name,alias,stepParent FROM categories WHERE parentId=480 ORDER BY order_id ASC
0.0126  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 = 43091 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0126  SELECT dt.id FROM teams t INNER JOIN datateams dt ON t.teamId = dt.id WHERE t.league_id = 43091 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 36
0.0138  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 = 43091 AND dt.id IN (16012,16014,16016,16013,16025,16019,25065,16017,16018,16024,16011,58888,16021,25066,101179,84716,25067,65365,110626,110627) ORDER BY dt.relations DESC,dp.role ASC
0.0125  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-04-27 16:42:08' 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-27 16:42:08' 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=4 AND last_update > '2024-04-27 16:42:08' 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-27 16:42:08' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0130  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'premier_league_zambia' AND (l.group_code = 0 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 2018 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=0 DESC LIMIT 1
0.0156  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 events2018 e ON e.player_id = p.id AND e.league_id = 43091 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 43091 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.0127  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 events2018 e ON e.player_id = p.id AND e.league_id = 43091 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 43091 AND (e.action = 4 or e.action = 5) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0128  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 events2018 e ON e.player_id = p.id AND e.league_id = 43091 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 43091 AND (e.action = 3 or e.action = 4) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0137  SELECT *,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables2018` 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 = 43091 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC