4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Publicidad 600x120.gif
Liga Pakistán 2000
1999/2000

Liga Pakistán 2000

Información Histórica
						
47th National Championship [July 23 - August 13]
24 participating teams (16 departmental and 8 provincial teams)

(played at Peoples's Sports Complex, Karachi)

Pool A
ABL             6-1     Police              [Jul 26]
  [Talib Hassan 19, Muhammad Ejaz 28, Khuda Bukhsh 57, 73, 
   Gohar Zaman 64, 84; Naseebullah 85]
ABL             2-0     Punjab Reds         [Jul 31]
  [Khuda Bukhsh 74, Amjad Zakaria]
Police          3-2     Punjab Reds         [Aug 2]

Table:
1.Allied Bank Limited [ABL]                             2   2   0   0   8-1   6
2.Police                                                2   1   0   1   3-4   3
3.Punjab Reds                                           2   0   0   2   3-9   0

Pool B
Sindh Reds      3-0     UGC                [Jul 24]
NBP             1-0     UGC                [Jul 26]
  [Abdul Sattar 24]
NBP             1-0     Sindh Reds         [Aug 3]
  [Abdul Razzaq 15]

Table:
1.National Bank of Pakistan [NBP]                       2   2   0   0   2-0   6
2.Sindh Reds                                            2   1   0   1   3-1   3
3.University Grants Commission [UGC]                    2   0   0   2   0-4   0

Pool C
Army            5-0     SSGC               [Jul 30]
  [Mahmood, Ghulam Ali, Nadeem Gill 44, Jaffar Izar, Jamil Gill 80]
SSGC            2-1     B. Greens          [Aug 1]
Army            3-1     B. Greens          [Aug 3]
  [Shaukat Ali 16, Ghulam Ali 50, Omar; Niamatullah]

Table:  
1.Pakistan Army                                         2   2   0   0   8-1   6
2.Sui Southern Gas Company [SSGC]                       2   1   0   1   2-6   3
3.Balochistan Greens                                    2   0   0   2   2-5   0

Pool D
PIA             0-0     PTCL               [Jul 24]
PTCL            5-0     NWFP Greens        [Jul 27]
  [Imran Farooqi 14, 51, Tahir Kamarat 70, ?, Tanvirul Hassan ?]
PIA             1-1     NWFP Greens        [Jul 29]
  [Asif 25; Akhtar Hussain 5]

Table:
1.Pakistan Telecommunication Company Limited [PTCL]     2   1   1   0   5-0   4
2.Pakistan International Airlines [PIA]                 2   0   2   0   1-1   2
3.NWFP Greens                                           2   0   1   1   1-6   1
NB: NWFP Greens announced as Sarhad Greens in the draw; NWFP are one of
    Pakistan's provinces and called 'Sarhad' in the Urdu language.

Pool E
KRL             8-1     Punjab Greens      [Jul 28]
WAPDA           4-1     Punjab Greens      [Jul 31]
  [Rashid Siddiqi 12, Khalid Butt 21, Burhan Ali 71, Khalid Butt; Mujahid]
KRL             3-0     WAPDA              [Aug 2]

Table:
1.Khan Research Laboratories [KRL]                      2   2   0   0  11-1   6
2.Water and Power Development Authority [WAPDA]         2   1   0   1   4-4   3
3.Punjab Greens                                         2   0   0   2   2-12  0

Pool F
HBL             1-1     Sindh Greens       [Jul 23]
  [Shahid Saleem 19; Abdul Shakoor 40]
Railways        3-0     Sindh Greens       [Jul 25]
HBL             1-0     Railways           [Jul 28]

Table:
1.Habib Bank Limited [HBL]                              2   1   1   0   2-1   4
2.Pakistan Railways                                     2   1   0   1   3-1   3
3.Sindh Greens                                          2   0   1   1   1-4   1

Pool G
PAF             2-1     KPT                [Jul 23]
  [half-time 1-0, Maqbool 60; Naseer Baloch 61]
KPT             2-0     B. Reds            [Jul 30]
  [Mohammad Amin 8, Arshad 18]
PAF             3-0     B. Reds            [Aug 1]

Table:
1.Pakistan Air Force [PAF]                              2   2   0   0   5-1   6
2.Karachi Port Trust [KPT]                              2   1   0   1   3-2   3
3.Balochistan Reds                                      2   0   0   2   0-5   0

Pool H
Navy            1-0     KMC                [Jul 25]   
  [Saleem jr 16, Rana Zahir Ahmad 65; Gulqad Ayaz 55]
Navy            2-1     NWFP Reds          [Jul 27]
KMC             1-1     NWFP Reds          [Jul 29]
  [Ghani Rahman 65; Gulqad Ayaz]

Table:
1.Pakistan Navy                                         2   2   0   0   3-1   6
2.NWFP Reds                                             2   0   1   1   2-3   1
3.Karachi Metropolitan Corporation [KMC]                2   0   1   1   1-2   1 
NB: NWFP Reds announced as Sarhad Reds in the draw

1/8 Finals
[Aug 4]
Navy            1-0     Railways
HBL             4-0     NWFP Reds
[Aug 5]
ABL             2-0     SSGC
WAPDA           2-0     PAF
[Aug 6]
KPT             1-0     KRL
PIA             2-1     NBP
[Aug 7]
Army            3-1     Police
Sindh Reds      0-0     PTCL            [3-2 on pen]

Quarterfinals 
[Aug 8]
HBL             3-1     KPT 
  [Mohammad Bashir 35, 51, Shahid Saleem 71; Abdul Rauf 25]
Navy            2-1     WAPDA           [asdet]
  [Fida Hussain 17, M. Basharat 100; Khalid Butt 43]
[Aug 9] 
Sindh Reds      2-1     Army 
  [Mohammad Khan 37, Gulzar 60; Babar Mahmood 80]
ABL             1-0     PIA             [asdet] 
  [Gohar Zaman 92]

Semifinals
[Aug 10]
Navy            awd     HBL             [abandoned at 0-0 in 53' after Navy refused to
                                         continue following a red card; awarded to HBL]
[Aug 11] 
ABL             2-0     Sindh Reds 
  [Amjad Zakaria 79, Gohar Zaman 85]

Final [Aug 13]
ABL             1-0     HBL
  [Gohar Zaman 43]
  [ABL: Haroon Yousuf (captain), Zahid Rafiq, Bashir Ahmad, Mohammad Amir Khan,
        Ziaul Hassan, Talib Hussain, Zulfiqar Ali Shah, Khuda Bukhsh, Ejaz Ahmad,
        Gohar Zaman, Noman Ibraheem, Qadeer Ahmad, Amjad Zakaria, Basharat Iqbal,
        Nasar Iqbal, Asadullah Tariq, Ashfaq Ahmad, M. Asadullah. 
   HBL: Noor Faraz, Mohammad Yasin, Mohammad Sameen, Mohammad Tariq (captain), 
        Amjad Yousuf, Jawaid Ahmad, Abdul Malik, Shakir Hussain, Pervaiz Ahmad,
        Shahid Saleem, Bashir, Asif Shah, Mahboob Khan, Waheed Majeed,
        Gul Mohammad, Abdul Samad, Arshad Jamal, Jameel Idrees. 
   referee: Nazir Ahmad; assistant referees: Atiq Rahmatullah and Salahuddin]

Topscorer: Gohar Zaman (ABL) 7 goals


Other Tournaments 2000




Authors: Syed Akber Ali Wahidi
(akbersoccer@hotmail.com),
Hans Schöggl
(hans.schoeggl@sbg.ac.at)
and Malik Riaz Hai Naveed
(MalikRiaz@t-online.de)

Last updated: 18 Sep 2003

(C) Copyright Syed Akber Ali Wahidi,
Hans Schöggl, Malik Riaz Hai Naveed 
and RSSSF 2000/03
						


  USO DE MEMORIA  
4,256,856 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0022
Controller Execution Time ( Home / Category )  0.0767
Total Execution Time  0.0789
  CADENA URL  
/liga_pakistan2000
  GET DATOS  
$_GET['/liga_pakistan2000']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (27)  
0.0018  SELECT type FROM routes WHERE alias = 'liga_pakistan2000'
0.0039  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 = 2000 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.0019  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.0020  SELECT text_es as historical_text FROM leagues_text WHERE id=1089
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 = 29403 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0019  SELECT c.id, c.name, c.alias, c.stepParent, l.year FROM categories AS c INNER JOIN leagues AS l ON c.id=l.categoryId AND l.year='2000' WHERE c.parentId=334 GROUP BY c.id ORDER BY c.order_id ASC
0.0018  SELECT type,rule FROM rules WHERE categoryId = 334 ORDER BY type = 'tables_draw' DESC,type != 'extra' DESC, `order` ASC
0.0018  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-04-26 22:50:44' 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-26 22:50:44' 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-26 22:50:44' 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 22:50:44' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0022  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 = 2000 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=0 DESC LIMIT 1
0.0019  SELECT rel.media_id, rel.team1, rel.team2, m.name, m.type, m.lang, m.location, rel.id AS rel_id, m.url FROM rel_media_match AS rel INNER JOIN media AS m ON m.id=rel.media_id WHERE (m.lang='es' OR m.language='spanish') AND rel.active=1 AND rel.league_id=29403 AND rel.round=46
0.0018  SELECT u.id,u.user_name, esl.points,up.name,up.surname,up.nick,u.changeA FROM editor_stats_leagues esl INNER JOIN fa_user u ON u.id = esl.user_id INNER JOIN fa_user_profile up ON up.id = esl.user_id WHERE esl.league_id = 29403 AND esl.points > 0 ORDER BY esl.points DESC LIMIT 3
0.0019  SELECT count(esl.user_id) as cuenta FROM editor_stats_leagues esl INNER JOIN fa_user u ON u.id = esl.user_id INNER JOIN fa_user_profile up ON up.id = esl.user_id WHERE esl.league_id = 29403 AND esl.points > 0
0.0017  SELECT fau.user_name, c.*, NOW() as difference_time,creation_date FROM (leagues as l) INNER JOIN comments as c ON c.league_id = l.id LEFT JOIN fa_user fau ON fau.id = c.author_id WHERE c.creation_date > "2024-03-27" AND c.`active`= 1 and c.comment_id is null and c.lang = 1 AND l.`id` = 29403 ORDER BY creation_date DESC LIMIT 0, 10
0.0021  SELECT count(c.id) as cuenta FROM (leagues as l) INNER JOIN comments as c ON c.league_id = l.id WHERE c.creation_date > "2024-03-27" AND c.`active`= 1 and comment_id is null and c.lang = 1 AND l.`id` = 29403
0.0019  SELECT c.isVideo, c.id,c.team1, c.team2,c.extra,c.datateam1,c.datateam2,c.type, c.shedule, c.r1, c.r2, c.round, c.comments as total_comentarios, dt1.nameShow as team1_name, dt2.nameShow as team2_name, dt1.basealias as basealias1, dt2.basealias as basealias2,c.betId,c.betId_wh,c.betId_bwin,c.betId_marca,c.betId_888, c.betId_sportium, c.betId_marathon, c.finished, c.penaltis1, c.penaltis2, c.prorroga, c.status, c.minute, dt1.stadium as stadium_name FROM `calendars2000` as c INNER JOIN teams t1 ON t1.id = c.team1 AND t1.league_id = c.league_id INNER JOIN teams t2 ON t2.id = c.team2 AND t2.league_id = c.league_id INNER JOIN datateams as dt1 ON dt1.id = t1.teamId INNER JOIN datateams as dt2 ON dt2.id = t2.teamId WHERE c.`league_id` = 29403 AND c.`round` = 46 ORDER BY shedule ASC LIMIT 200
0.0019  SELECT (dt1.qod+dt2.qod+dt1.relations+dt2.relations) as total,c.r1,c.r2,e.action,ev.showName as eventName,ev.largeName,ev.main_action,ev.keyname,ev.classf,e.real_date,e.minute, dp.nick,dp.CountryCode,dp.alias,c.datateam1,c.datateam2,dt1.nameShow as nameShow1,dt2.nameShow as nameShow2,dt1.basealias as basealias1,dt2.basealias as basealias2,e.player_id,e.match_id FROM `events2000` e INNER JOIN calendars2000 c ON c.id = e.match_id INNER JOIN events ev ON ev.id = e.action INNER JOIN dataplayers dp ON dp.id = e.player_id INNER JOIN datateams dt1 ON dt1.id = c.datateam1 INNER JOIN datateams dt2 ON dt2.id = c.datateam2 WHERE ev.main_action = 1 AND c.round = 46 AND e.real_date IS NOT NULL AND e.league_id = 29403 ORDER BY total DESC LIMIT 40
0.0018  SELECT c.r1,c.r2,e.action,ev.showName as eventName,ev.largeName,ev.main_action,ev.keyname,ev.classf,e.real_date,e.minute, dp.nick,dp.CountryCode,dp.alias,c.datateam1,c.datateam2,dt1.nameShow as nameShow1,dt2.nameShow as nameShow2,dt1.basealias as basealias1,dt2.basealias as basealias2,e.player_id,e.match_id FROM `events2000` e INNER JOIN calendars2000 c ON c.id = e.match_id INNER JOIN events ev ON ev.id = e.action INNER JOIN dataplayers dp ON dp.id = e.player_id INNER JOIN datateams dt1 ON dt1.id = c.datateam1 INNER JOIN datateams dt2 ON dt2.id = c.datateam2 WHERE ev.show_on = 1 AND e.real_date IS NOT NULL AND e.league_id = 29403 AND e.real_date > NOW() - INTERVAL 1 MONTH ORDER BY e.real_date DESC LIMIT 30
0.0023  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 `tables2000` 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 = 29403 AND t.round = 44 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0019  SELECT *,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables2000` 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 = 29403 AND t.round = 46 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0017  SELECT c.id, 2024 AS year, IF(l.tables = 1 AND t1.points>0,((t1.points / (l.current_round * 3)) + (t2.points / (l.current_round * 3)))/2 * ct.coefficient,0.7 * ct.coefficient) as fcoef FROM `calendars2024` AS c INNER JOIN `leagues` AS l ON c.`league_id` = l.`id` INNER JOIN `categories` AS ct ON ct.`id` = l.`categoryId` LEFT JOIN tables2024 AS t1 ON t1.team = c.team1 AND t1.round = l.current_round LEFT JOIN tables2024 AS t2 ON t2.team = c.team2 AND t2.round = l.current_round WHERE c.`shedule` > '2024-04-27 00:00:00' AND c.`shedule` < '2024-05-01 23:59:59' AND l.id = 29403 ORDER BY c.shedule ASC, fcoef DESC LIMIT 5
0.0024  SELECT data1, data2 FROM services_tags WHERE categoryId=334
0.0024  SELECT group_code, extraName from `leagues` WHERE categoryId=334 AND year=2000