4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Ver
TEMPORADA 2021/2022
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
Ver
TEMPORADA 2018/2019
Equipo PJ GF GC Puntos
1 KRL KRL 26 40 12 51
2 Pakistan Air Force Pakistan 26 40 13 51
3 SSGC SSGC 26 32 16 50
4 Pakistan Army Pakistan 26 38 19 46
5 WAPDA WAPDA 26 32 18 45
6 KESC KESC 26 30 21 41
7 PCAA PCAA 26 31 27 39
8 National Bank National 26 27 27 33
9 Pakistan Navy Pakistan 26 30 37 33
10 Muslim FC Muslim FC 26 16 17 28
11 Afghan FC Afghan FC 26 24 44 28
12 SNGPL SNGPL 26 28 33 23
13 Karachi Port Trust Karachi Port 26 19 46 18
14 Baloch Baloch 26 12 69 6
15 Ashraf Sugar Ashraf Sugar 0 0 0 0
Ver
TEMPORADA 2014/2015
Equipo PJ GF GC Puntos
1 KESC KESC 22 43 20 48
2 Pakistan Army Pakistan 22 30 7 45
3 PAF PAF 22 38 14 42
4 Pakistan Airlines Pakistan 22 28 18 38
5 WAPDA WAPDA 22 31 14 36
6 KRL KRL 22 19 16 31
7 National Bank National 22 21 17 30
8 Muslim FC Muslim FC 22 26 26 29
9 KPT KPT 22 29 38 29
10 Afghan FC Afghan FC 22 24 29 23
11 Pakistan Railways Pakistan 22 13 45 10
12 Baloch Baloch 22 6 64 4
Ver
TEMPORADA 2013/2014
Equipo PJ GF GC Puntos
1 KRL KRL 30 52 10 69
2 Karachi Electric Karachi 30 47 20 64
3 WAPDA WAPDA 30 43 14 63
4 PAF PAF 30 41 29 50
5 Pakistan Army Pakistan 30 35 23 48
6 Pakistan Airlines Pakistan 30 45 40 46
7 Muslim FC Muslim FC 30 33 32 44
8 KPT KPT 30 63 50 40
9 National Bank National 30 25 25 37
10 Afghan FC Afghan FC 30 35 36 36
11 Habib Bank Habib Bank 30 26 33 35
12 Pakistan Navy Pakistan 30 28 37 35
13 Lyallpur FC Lyallpur FC 30 27 45 26
14 Pak Afghan Clearing Agency Afghan 30 22 45 24
15 Baloch Baloch 30 21 58 20
16 ZTBL FC ZTBL FC 30 16 62 17
Ver
TEMPORADA 2012/2013
Equipo PJ GF GC Puntos
1 KRL KRL 30 65 15 71
2 Karachi Electric Karachi 30 60 27 62
3 Muslim Muslim 30 47 22 62
4 Pakistan Army Pakistan 30 36 14 58
5 PAF PAF 30 46 27 53
6 National Bank National 30 34 26 44
7 Pakistan Navy Pakistan 30 31 32 37
8 Pakistan Airlines Pakistan 30 28 27 36
9 Afghan FC Afghan FC 30 28 38 35
10 Baloch Baloch 30 28 37 34
11 WAPDA WAPDA 30 36 44 32
12 KPT KPT 30 34 44 32
13 Habib Bank Habib Bank 30 28 38 32
14 ZTBL ZTBL 30 22 39 27
15 PMC Athletico Athletico 30 19 45 25
16 Wohaib Wohaib 30 8 75 8
Ver
TEMPORADA 2011/2012
Equipo PJ GF GC Puntos
1 KRL KRL 30 54 9 77
2 Afghan FC Afghan FC 30 52 24 57
3 Pakistan Army Pakistan 30 35 22 57
4 WAPDA WAPDA 30 40 23 52
5 Karachi Electric Karachi 30 41 30 51
6 Muslim FC Muslim FC 30 40 33 51
7 Pakistan Airlines Pakistan 30 49 33 49
8 National Bank National 30 41 26 45
9 Habib Bank Habib Bank 30 34 31 40
10 Pakistan Navy Pakistan 30 34 34 35
11 Pakistan Air Force Pakistan 30 23 29 33
12 KPT KPT 30 40 58 32
13 Baloch Baloch 30 26 40 28
14 PMC Athletico Athletico 30 17 36 27
15 Pakistan Police Pakistan 30 28 62 24
16 PEL PEL 30 10 74 8
Ver
TEMPORADA 2010/2011
Equipo PJ GF GC Puntos
1 WAPDA WAPDA 30 60 21 67
2 KRL KRL 30 37 16 58
3 Pakistan Airlines Pakistan 30 49 23 57
4 Karachi Electric Karachi 30 58 28 55
5 Pakistan Army Pakistan 30 41 22 54
6 KPT KPT 30 54 41 51
7 Pakistan Air Force Pakistan 30 31 30 45
8 Afghan FC Afghan FC 30 43 34 42
9 Pakistan Navy Pakistan 30 33 35 42
10 PEL PEL 30 36 47 38
11 Baloch Baloch 30 31 34 34
12 National Bank National 30 35 45 34
13 Habib Bank Habib Bank 30 26 40 25
14 PMC Athletico Athletico 30 22 54 21
15 SSGC SSGC 30 36 72 20
16 Young Blood Young Blood 30 23 73 18
Ver
TEMPORADA 2009/2010
Equipo PJ GF GC Puntos
1 KRL KRL 26 40 8 60
2 Pakistan Army Pakistan 26 36 14 60
3 WAPDA WAPDA 26 58 24 57
4 Pakistan Navy Pakistan 26 43 24 57
5 KPT KPT 26 34 30 38
6 Pakistan Airlines Pakistan 26 45 29 36
7 PEL PEL 26 36 28 36
8 Karachi Electric Karachi 26 28 27 34
9 Habib Bank Habib Bank 26 34 39 30
10 National Bank National 26 24 42 26
11 Pakistan Air Force Pakistan 26 27 38 25
12 Afghan FC Afghan FC 26 20 51 22
13 PMC Athletico Athletico 26 19 40 21
14 Baloch Baloch 26 10 60 8
Ver
TEMPORADA 2008/2009
Equipo PJ GF GC Puntos
1 WAPDA WAPDA 26 46 22 54
2 Pakistan Army Pakistan 26 40 21 50
3 KRL KRL 26 46 24 47
4 KPT KPT 26 39 32 45
5 Pakistan Navy Pakistan 26 30 18 41
6 National Bank National 26 45 42 35
7 PMC Athletico Athletico 26 33 38 35
8 Pakistan Airlines Pakistan 26 38 30 32
9 Habib Bank Habib Bank 26 34 31 32
10 Afghan FC Afghan FC 26 33 39 31
11 PEL PEL 26 25 40 31
12 Karachi Electric Karachi 26 32 40 30
13 Pakistan Steel Pakistan 26 27 36 29
14 Pakistan Television Pakistan 26 19 74 5
Ver
TEMPORADA 2007/2008
Equipo PJ GF GC Puntos
1 WAPDA WAPDA 26 64 23 58
2 Pakistan Army Pakistan 26 41 10 57
3 KRL KRL 26 45 13 53
4 National Bank National 26 36 31 43
5 KPT KPT 25 35 24 41
6 Pakistan Airlines Pakistan 26 32 23 39
7 Pakistan Navy Pakistan 26 36 26 38
8 Karachi Electric Karachi 26 27 30 32
9 Afghan FC Afghan FC 26 23 29 27
10 Habib Bank Habib Bank 26 35 42 25
11 Pakistan Television Pakistan 26 20 45 23
12 PMC Athletico Athletico 26 19 43 22
13 Pakistan Railways Pakistan 25 23 48 21
14 Wohaib Wohaib 26 11 60 8
Ver
TEMPORADA 2006/2007
Equipo PJ GF GC Puntos

JUGADORES DESTACADOS


  USO DE MEMORIA  
5,910,256 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0021
Controller Execution Time ( Home / Category )  0.1053
Total Execution Time  0.1074
  CADENA URL  
/liga_pakistan2022/grupo1/historico
  GET DATOS  
$_GET['/liga_pakistan2022/grupo1/historico']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (28)  
0.0017  SELECT type FROM routes WHERE alias = 'liga_pakistan2022'
0.0042  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.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=334 AND type_rel = 3
0.0021  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.0021  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.0018  SELECT id,name,alias,stepParent FROM categories WHERE parentId=334 ORDER BY order_id ASC
0.0019  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.0021  SELECT id,year,current_round,total_teams,legend FROM leagues WHERE categoryId = 334 AND group_code = 1 and tables = 1 AND year <= 2022 AND total_num_tablesR >= 1 ORDER BY year DESC LIMIT 22
0.0024  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(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
0.0027  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables2019` 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 = 46464 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0028  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables2015` 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 = 4852 AND t.round = 22 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0033  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables2014` 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 = 3252 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0026  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables2013` 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 = 2717 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0025  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables2012` 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 = 24169 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0028  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables2011` 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 = 24177 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0024  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables2010` 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 = 24179 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0029  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables2009` 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 = 24181 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0027  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables2008` 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 = 27989 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0024  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables2007` 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 = 27990 AND t.round = 22 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0019  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-04-25 06:22: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-25 06:22: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=4 AND last_update > '2024-04-25 06:22: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-25 06:22: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 = '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.0066  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.0019  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.0022  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.0031  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