4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
15 jugadores
Big Bullets Big Bullets
L. Nkhoma L. Nkhoma
S. Billiat S. Billiat
M. Mgwira M. Mgwira
C. Okumu C. Okumu
J. Lanjesi J. Lanjesi 31 años DEF
Y. Fodya Y. Fodya 32 años DEF
P. Sambani P. Sambani 25 años DEF
F. Kondowe F. Kondowe 41 años MED
L. Nkhoma L. Nkhoma 21 años MED
A. Lungu A. Lungu 22 años MED
P. Mwaungulu P. Mwaungulu 21 años MED
P. Banda P. Banda 31 años DEL
H. Kajoke H. Kajoke 26 años DEL
A. Mfune A. Mfune 26 años DEL
M. Gasten Phodo M. Gasten Phodo 25 años DEL
12 jugadores
Silver Strikers Silver Strikers
Kaunga Kaunga
I. Shema I. Shema 21 años
G. Chaomba G. Chaomba
A. Kaduya A. Kaduya
S. Davie S. Davie
Tatenda Mkuruva Tatenda Mkuruva 28 años POR
N. Mwase N. Mwase 27 años DEF
M. Fodyah M. Fodyah 26 años DEF
P. Macheso P. Macheso 26 años MED
Paipi Ndombele Paipi Ndombele MED
C. Idana C. Idana 25 años MED
D. Nyoni D. Nyoni 25 años MED
14 jugadores
Blue Eagles Blue Eagles
T. Viyuyi T. Viyuyi
C. Gototo C. Gototo
L. Mwale L. Mwale
S. Banda S. Banda
Richard Rapson Richard Rapson
Brighton Munthali Brighton Munthali 26 años POR
Sankhani Mkandawire Sankhani Mkandawire 33 años DEF
J. Robert J. Robert DEF
M. Lameck M. Lameck DEF
K. Schumacher K. Schumacher 27 años MED
G. Chirwa G. Chirwa 30 años MED
M. Mhone M. Mhone 32 años 173cm 69kg MED
H. Misinde H. Misinde DEL
C. Mvula C. Mvula DEL
11 jugadores
Be Forward Wanderers Forward
Wisdom Mpinganjira Wisdom Mpinganjira
L. Chaziya L. Chaziya 25 años DEF
G. Chirwa G. Chirwa 27 años DEF
Francis Mulimbika Francis Mulimbika 31 años DEF
Stanley Sanudi Stanley Sanudi 29 años 176cm DEF
Peter Cholopi Peter Cholopi 27 años DEF
I. Kaliati I. Kaliati 26 años MED
M. Gabeya M. Gabeya 28 años MED
V. Nyangulu V. Nyangulu 28 años DEL
C. Kumwembe C. Kumwembe DEL
F. Mkonda F. Mkonda DEL
10 jugadores
Karonga United Karonga United
N. Mbewe N. Mbewe
A. Youngson A. Youngson
G. Daud G. Daud 24 años DEF
D. Tobias D. Tobias 20 años MED
E. Kayombo E. Kayombo 19 años MED
J. Duwa J. Duwa 25 años MED
A. Chihana A. Chihana 22 años MED
S. Moyo S. Moyo 24 años DEL
A. Chizinga A. Chizinga 26 años DEL
S. Shamama S. Shamama DEL

Clasificación

Equipo PJ GF GC Puntos
1 Big Bullets Big Bullets 30 49 19 60
2 Silver Strikers Silver 30 41 18 57
3 Be Forward Wanderers Forward 30 35 16 55
4 Chitipa United Chitipa 30 31 29 48
5 Kamuzu Barracks Kamuzu 30 32 23 46
6 Bangwe All Stars Bangwe Stars 30 37 36 42
7 Dedza Dynamos Dedza 30 30 38 38
8 CIVO United CIVO United 30 31 30 37
9 Karonga United Karonga 30 34 38 37
10 MAFCO MAFCO 30 29 36 37
11 Azam Tigers Azam Tigers 30 21 22 36
12 Ekwendeni Hammers Ekwendeni 30 26 36 36
13 Blue Eagles Blue Eagles 30 32 32 35
14 Moyale Barracks Moyale 30 32 32 35
15 Red Lions Red Lions 30 22 50 29
16 Extreme Extreme 30 16 43 18

  USO DE MEMORIA  
5,617,600 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0018
Controller Execution Time ( Home / Category )  0.0988
Total Execution Time  0.1007
  CADENA URL  
/super_league_malaui2023/grupo1/jugadores
  GET DATOS  
$_GET['/super_league_malaui2023/grupo1/jugadores']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (18)  
0.0018  SELECT type FROM routes WHERE alias = 'super_league_malaui2023'
0.0042  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'super_league_malaui' AND (l.group_code = 1 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 2023 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=1 DESC LIMIT 1
0.0019  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=495 AND type_rel = 3
0.0021  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 3 AND rel.typeId = 495 AND rel.ln = 'es' AND rel.status=1 ORDER BY rel.creation_date desc,rel.cover_points DESC LIMIT 5
0.0025  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 (1038875,677601,254996) ORDER BY n.cover_points DESC, update_date DESC
0.0019  SELECT id,name,alias,stepParent FROM categories WHERE parentId=495 ORDER BY order_id ASC
0.0021  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 = 71512 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0020  SELECT dt.id FROM teams t INNER JOIN datateams dt ON t.teamId = dt.id WHERE t.league_id = 71512 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 36
0.0056  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 = 71512 AND dt.id IN (15822,15823,61661,15814,80513,15825,15812,15815,15813,15824,18056,101262,136113,150880,157033,157034) ORDER BY dt.relations DESC,dp.role ASC
0.0020  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-04-29 15:45:52' 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=2 AND last_update > '2024-04-29 15:45:52' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0020  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=4 AND last_update > '2024-04-29 15:45:52' 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=3 AND last_update > '2024-04-29 15:45:52' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0027  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'super_league_malaui' AND (l.group_code = 0 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 2023 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=0 DESC LIMIT 1
0.0223  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 events2023 e ON e.player_id = p.id AND e.league_id = 71512 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 71512 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.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 events2023 e ON e.player_id = p.id AND e.league_id = 71512 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 71512 AND (e.action = 4 or e.action = 5) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0030  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 events2023 e ON e.player_id = p.id AND e.league_id = 71512 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 71512 AND (e.action = 3 or e.action = 4) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0062  SELECT *,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables2023` 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 = 71512 AND t.round = 30 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC