4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
6 jugadores
Pakistan Army Pakistan Army
M. Afzaal M. Afzaal
A. Abbas A. Abbas 35 años
F. Ullah F. Ullah
Tareq Abdullah Tareq Abdullah 28 años 166cm 64kg DEF
Z. Hasnain Z. Hasnain MED
M. Jamil M. Jamil 23 años 182cm MED
7 jugadores
Pakistan Air Force Pakistan Force
M. Waleed M. Waleed
M. Faisal M. Faisal 39 años DEF
Mehdi Hassan Mehdi Hassan DEF
M. Yaseen M. Yaseen MED
Muhammad Mujahid Muhammad Mujahid MED
Mansoor Khan Mansoor Khan 27 años MED
Muhammad Rizwan Asif Muhammad Rizwan Asif 34 años 167cm 70kg DEL
5 jugadores
Muslim FC Muslim FC
M. Hanif M. Hanif
Q. Fida Muhammad A. Q. Fida Muhammad A.
H. Ullah H. Ullah MED
M. Jamil M. Jamil 23 años 182cm MED
F. Abdul F. Abdul DEL
7 jugadores
SSGC SSGC
M. Lal M. Lal
Sohail Sohail
Ali Khan Ali Khan 23 años DEF
Zain-Ul-Abideen Zain-Ul-Abideen 25 años MED
Saddam Hussain Saddam Hussain 31 años MED
Saad Ullah Saad Ullah 29 años DEL
Muhammad Waheed Muhammad Waheed 21 años 179cm DEL

JUGADORES DESTACADOS

Clasificación

Equipo PJ GF GC Puntos
1 WAPDA WAPDA 20 32 11 41
2 Lyallpur FC Lyallpur FC 23 26 17 40
3 SSGC SSGC 18 45 11 37
4 Pakistan Air Force Pakistan 18 41 15 37
5 Muslim FC Muslim FC 26 25 53 34
6 PCAA PCAA 24 17 23 33
7 KRL KRL 22 48 21 32
8 Pakistan Army Pakistan 22 26 15 31
9 Khi United Khi United 23 20 40 26
10 Pakistan Navy Pakistan 23 27 49 17
11 SNGPL SNGPL 8 10 14 7
12 Humma FC Humma FC 23 25 73 6

  USO DE MEMORIA  
5,179,904 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0019
Controller Execution Time ( Home / Category )  0.3254
Total Execution Time  0.3273
  CADENA URL  
/liga_pakistan2022/grupo1/jugadores
  GET DATOS  
$_GET['/liga_pakistan2022/grupo1/jugadores']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (20)  
0.0105  SELECT type FROM routes WHERE alias = 'liga_pakistan2022'
0.0214  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'liga_pakistan' 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.0105  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=334 AND type_rel = 3
0.0107  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 3 AND rel.typeId = 334 AND rel.ln = 'es' AND rel.status=1 ORDER BY rel.creation_date desc,rel.cover_points DESC LIMIT 5
0.0108  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 (1121480,966106,866282,621886) ORDER BY n.cover_points DESC, update_date DESC
0.0105  SELECT id,name,alias,stepParent FROM categories WHERE parentId=334 ORDER BY order_id ASC
0.0109  SELECT max(l.year) as max_year, min(l.year) as min_year FROM leagues l WHERE categoryID = 334 GROUP BY l.categoryId
0.0109  SELECT l.year FROM leagues AS l WHERE (l.group_code =0 OR l.total_num_tablesR>=1 OR l.total_teamsR >=1 OR l.text_mode != 0) AND l.categoryId=334 GROUP BY l.year ORDER BY l.year DESC
0.0110  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 = 63896 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0110  SELECT dt.id FROM teams t INNER JOIN datateams dt ON t.teamId = dt.id WHERE t.league_id = 63896 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 36
0.0145  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 = 63896 AND dt.id IN (15541,15537,15539,12097,15548,86423,15540,115187,115186,143491,143490,143489) ORDER BY dt.relations DESC,dp.role ASC
0.0108  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-04-20 03:41:52' 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=2 AND last_update > '2024-04-20 03:41:52' 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=4 AND last_update > '2024-04-20 03:41:52' 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-20 03:41:52' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0110  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'liga_pakistan' 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.0250  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 = 63896 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 63896 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.0107  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 = 63896 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 63896 AND (e.action = 4 or e.action = 5) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0107  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 = 63896 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 63896 AND (e.action = 3 or e.action = 4) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0116  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 = 63896 AND t.round = 11 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC