4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Información Histórica 
						


Qualifying Rounds 
----------------- 

Northern Region: 

Round 1 
Kawerau Town         7-3  Taupo
Marist               1-4  HSOB

Round 2
Whangarei Wanderers  2-1  Kaikohe Rangers
Tikipunga            1-0  Northern United
Grey Lynn            2-4  Kelston West
Howick               1-5  University
Albany-Wairau        1-2  Mt Albert-Ponsonby
Hibiscus Coast       0-5  Oratia United
Birkenhead United    0-1  Eden
Lynndale             1-2  Glenfield Rovers
Te Atatu             1-2  Pakuranga Town
Green Bay/Titirangi  1-0  Massey
Otara Rangers        2-0  Waiuku Steel
Thames               1-5  Clendon United
Papatoetoe           1-2  Manakau City
Mangere Town         wbd  HSOB
Waikato Unicol       1-2  Ngaruawahia AFFCO
Huntly Thistle       2-1  Matamata Swifts
Kawerau Town         1-4  Rotorua Suburbs 
Rotorua City         2-1  Mt Maunganui  


Central Region:       
   
Round 2
Bay Colour Thistle   0-1  Havelock North Wanderers
Waitara              3-1  New Plymouth United
Glen Carron          8-2  Marton United
Dannevirke United    0-4  Kiwi United
Douglas Villa        1-2  Carterton
Arakura              lbd  Victoria University
Brooklyn Northern U  2-1  Newlands Paparangi
Seatoun              4-1  Christian Youth
Lower Hutt City      2-1  Karori Swifts
Naenae               2-4  Raumati Hearts
Porirua City         3-4  Wainuiomata
Island Bay           2-3  North Wellington
Upper Hutt United    8-0  Marist
Viard OB             5-0  Tararua


Southern Region: 

Round 1
Riccarton            1-2  Burndale United

Round 2 
Burnham              1-2  University of Canterbury
Avonhead             1-3  Chch HSOB
Burndale             3-4+ Cashmere Wanderers
Nomads               3-1  Hornby United
Timaru City          1-4  Northern Hearts
Temuka United        0-2  Oamaru
Dunedin Technical    4-1  Roslyn-Wakari
Invercargill Thistle 4-0  Gore Wanderers
Southland's HSOB     2-6  Queens Park
Waihopi              0-1  Invercargill United
  
  
COMPETITION PROPER 

Round 1 
------- 

Northern Region:
Whangarei Wanderers  0-7  Whangarei City
Tikipunga            1-2  Glenfield Rovers
Mt Roskill           3-0  Eden
Mt Albert-Ponsonby   7-6  Waitemata City
Kelston West         2-4  Oratia United
Metro College        1-2  Ellerslie
East Coast Bays      3-2  Pakuranga Town
Takapuna City        3-0  Eastern Suburbs
Green Bay/Titirangi  4-2  University
Papakura City        1-2  Otara Rangers
Clendon United       6-1  Mangere Town
Manakau City         0-2  Otahuhu Courier
Ngaruawahia AFFCO    3-1  Huntly Thistle
Rotorua City         5-1  Rotorua Suburbs

Central Region:
Havelock North Wan   1-8  Napier City Rovers
Waitara              2-0  Central City
New Plymouth OB      0-1  Taranaki United
Feilding United      1-4  Manawatu United
Wanganui Athletic    2-0  Glen Carron
Kiwi United          5-1  Palmerston North End
Massey University    1-2  Tawa
Carterton            0-12 Masterton
Raumati Hearts       0-3  Porirua United
Wellington WMC       3-2  North Wellington
Seatoun              2-4  Columbus Waterside
Wainuiomata          1-6  Viard OB
Miramar Rangers      3-2  Petone
Upper Hutt United    2-0  Victoria University
Stokes Valley        2-1  Brooklyn Nth Utd
Wellington City      4-2  Lower Hutt City

Southern Region:
Nomads               1-3  Technical
Shamrock             5-0  Chch HSOB
Woolston WMC         3-0  Western
Cashmere Wanderers  12-1  University of Canterbury    
Halswell United      3-0  New Brighton
Oamaru               2-3  Northern Hearts
Green Island         1-3  Dunedin Tech [aet]
Invercargill Thistle 3-2  Mosgiel
North End United     2-1  Caversham
Invercargill United  0-1  Queen's Park  

Round 2 
------- 

Northern Region:
Glenfield Rovers     3-4  Whangarei City
Takapuna City        1-0  Ellerslie
Oratia United        2-1  Mt Albert-Ponsonby
Green Bay/Titirangi  0-1  Mt Roskill
Otara Rangers        3-1  East Coast Bays
Clendon United       1-2  Otahuhu Courier
Ngaruawahia AFFCO    4-2  Rotorua City [aet]

Central Region:
Masterton            3-2  Napier City Rovers
Waitara              0-4  Taranaki United
Kiwi United          2-4  Manawatu Utd [aet]
Tawa                 5-7+ Wanganui Athletic
Viard OB             0-5  Porirua United
Columbus Waterside   0-3  Wellington City
Stokes Valley        4-1  Wellington WMC
Upper Hutt United    2-1  Mirama Rangers

Southern Region:
Woolston WMC         2-0  Technical
Northern Hearts      4-2  Shamrock
Cashmere Wanderers   1-0  Halswell United
Dunedin Technical    5-3  North End United
Invercargill Thistle 3-2  Queens Park

Round 3 
------- 

Woolston WMC         1-2  Invercargill Thistle
Christchurch United  4-1  Rangers
Nelson United        4-1  Wanganui Athletic
Stokes Valley        1-2  Gisborne City
Upper Hutt United    0-2  Stop Out
Manawatu United      2-1  Masterton
Otahuhu Courier      1-2  Manurewa
Mount Wellington     3-1  Whangarei City
Takapuna City        7-0  Oratia United
Hamilton             2-0  North Shore United
Ngaruawahia AFFCO    0-1  Otara Rangers
Blockhouse Bay       2-1  Mt Roskill
Northern Hearts      5-3  Cashmere Wanderers
Dunedin Technical    0-6  Dunedin City
Wellington D United  1-0  Porirua United
Wellington City      2-1  Taranaki United 

Round 4
-------

Invercargill Thistle 1-3  Christchurch United
Nelson United        0-2  Gisborne City
Stop Out             2-0  Manawatu United
Manurewa             0-4  Mt Wellington
Takapuna City        3-1  Hamilton
Otara Rangers        1-2  Blockhouse Bay
Northern Hearts      2-5  Dunedin City
Wellington D United  3-0  Wellington City 

Round 5
-------

Christchurch United  2-0  Gisborne City
Stop Out             0-2  Mt Wellington
Takapuna City        1-0  Blockhouse Bay [aet]
Dunedin City         4-1  Wellington D United

Semi-finals 
----------- 

Christchurch United  0-1  Mt Wellington
Takapuna City        0-2  Dunedin City


Final 
-----   
[Sep-7] 
Basin Reserve, Wellington
Mt Wellington 2-0 Dunedin City      
 [Stewart Carruthers, Bill McClure] 
  
Mt Wellington: Alex Davie, Tony Sibley, Ricki
Herbert, Ron Armstrong, Ken Billot (John Lejjh),
Bill de Graaf, Stewart Carruthers, David Taylor, 
Clive Campbell, Brian Turner, Bill McClure
Dunedin City: Jim Taylor, David Munro, Paul Hillis, 
David Gibson, Bill Chisholm, Jim Wilson, Graham Carr,
George Caird, Pat Berry, Gordon McDonald, John Russell

Referee: G.W. Fleet (Wellington) 



Author: Andre Zlotkowski
(nzfooty@hotmail.com)

Last updated: 30 Jan 2001

(C) Copyright Andre Zlotkowski and RSSSF 2000/01


  USO DE MEMORIA  
4,192,240 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0025
Controller Execution Time ( Home / Category )  0.0987
Total Execution Time  0.1012
  CADENA URL  
/copa_chatham1980
  GET DATOS  
$_GET['/copa_chatham1980']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (38)  
0.0018  SELECT type FROM routes WHERE alias = 'copa_chatham1980'
0.0041  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'copa_chatham' AND (l.group_code = 1 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 1980 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=1 DESC LIMIT 1
0.0024  SELECT text_es as historical_text FROM leagues_text WHERE id=1338
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 = 29616 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='1980' WHERE c.parentId=1803 GROUP BY c.id ORDER BY c.order_id ASC
0.0018  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-05-01 01:17:30' 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-05-01 01:17:30' 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-05-01 01:17:30' 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-05-01 01:17:30' 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 = 'copa_chatham' AND (l.group_code = 0 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 1980 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=0 DESC LIMIT 1
0.0021  SELECT l.id FROM leagues_webci l WHERE l.categoryId = 1803 AND l.year = 1980
0.0018  SELECT e.action, count(e.action) as total, e.player_id FROM events1980 e WHERE e.league_id IN (29616) AND (e.action IN (1,2,11,12,13) ) GROUP BY e.player_id ORDER BY total DESC, e.player_id ASC LIMIT 20
0.0019  SELECT dp.name, dp.last_name, dp.nick,dp.CountryCode,dp.alias,rp.team_id,dt.nameShow,dt.short_name,dt.basealias,rp.player_id,rp.teamId,dp.role FROM dataplayers AS dp INNER JOIN rel_players AS rp ON rp.player_id=dp.id AND rp.league_id IN (29616) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN () ORDER BY rp.in_squad = 1 DESC
0.0018  SELECT l.id FROM leagues_webci l WHERE l.categoryId = 1803 AND l.year = 1980
0.0019  SELECT e.action, count(e.action) as total, e.player_id FROM events1980 e WHERE e.league_id IN (29616) AND (e.action IN (4,5) ) GROUP BY e.player_id ORDER BY total DESC, e.player_id ASC LIMIT 20
0.0018  SELECT dp.name, dp.last_name, dp.nick,dp.CountryCode,dp.alias,rp.team_id,dt.nameShow,dt.short_name,dt.basealias,rp.player_id,rp.teamId,dp.role FROM dataplayers AS dp INNER JOIN rel_players AS rp ON rp.player_id=dp.id AND rp.league_id IN (29616) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN () ORDER BY rp.in_squad = 1 DESC
0.0020  SELECT l.id FROM leagues_webci l WHERE l.categoryId = 1803 AND l.year = 1980
0.0018  SELECT e.action, count(e.action) as total, e.player_id FROM events1980 e WHERE e.league_id IN (29616) AND (e.action IN (3,4) ) GROUP BY e.player_id ORDER BY total DESC, e.player_id ASC LIMIT 20
0.0019  SELECT dp.name, dp.last_name, dp.nick,dp.CountryCode,dp.alias,rp.team_id,dt.nameShow,dt.short_name,dt.basealias,rp.player_id,rp.teamId,dp.role FROM dataplayers AS dp INNER JOIN rel_players AS rp ON rp.player_id=dp.id AND rp.league_id IN (29616) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN () ORDER BY rp.in_squad = 1 DESC
0.0019  SELECT l.id FROM leagues_webci l WHERE l.categoryId = 1803 AND l.year = 1980
0.0021  SELECT e.action, count(e.action) as total, e.player_id FROM events1980 e WHERE e.league_id IN (29616) AND (e.action IN (22) ) GROUP BY e.player_id ORDER BY total DESC, e.player_id ASC LIMIT 20
0.0018  SELECT dp.name, dp.last_name, dp.nick,dp.CountryCode,dp.alias,rp.team_id,dt.nameShow,dt.short_name,dt.basealias,rp.player_id,rp.teamId,dp.role FROM dataplayers AS dp INNER JOIN rel_players AS rp ON rp.player_id=dp.id AND rp.league_id IN (29616) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN () ORDER BY rp.in_squad = 1 DESC
0.0018  SELECT SUM(rp.lineup) 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,p.role FROM `rel_players` rp INNER JOIN dataplayers p ON p.id = rp.player_id INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.category_id = 1803 AND rp.year = 1980 AND rp.lineup > 0 GROUP BY p.id ORDER BY total DESC,p.pod DESC LIMIT 20
0.0018  SELECT SUM(rp.events) 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,p.role FROM `rel_players` rp INNER JOIN dataplayers p ON p.id = rp.player_id INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.category_id = 1803 AND rp.year = 1980 AND rp.events > 0 GROUP BY p.id ORDER BY total DESC,p.pod DESC LIMIT 20
0.0021  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=29616 AND rel.round=9
0.0019  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 = 29616 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 = 29616 AND esl.points > 0
0.0019  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-04-01" AND c.`active`= 1 and c.comment_id is null and c.lang = 1 AND l.`id` = 29616 ORDER BY creation_date DESC LIMIT 0, 10
0.0023  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-04-01" AND c.`active`= 1 and comment_id is null and c.lang = 1 AND l.`id` = 29616
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 `calendars1980` 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` = 29616 AND c.`round` = 9 ORDER BY shedule ASC LIMIT 200
0.0018  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 `events1980` e INNER JOIN calendars1980 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 = 9 AND e.real_date IS NOT NULL AND e.league_id = 29616 ORDER BY total DESC LIMIT 40
0.0020  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 `events1980` e INNER JOIN calendars1980 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 = 29616 AND e.real_date > NOW() - INTERVAL 1 MONTH ORDER BY e.real_date DESC LIMIT 30
0.0020  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 `tables1980` 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 = 29616 AND t.round = 7 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0020  SELECT *,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables1980` 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 = 29616 AND t.round = 9 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0020  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-05-01 00:00:00' AND c.`shedule` < '2024-05-05 23:59:59' AND l.id = 29616 ORDER BY c.shedule ASC, fcoef DESC LIMIT 5
0.0020  SELECT data1, data2 FROM services_tags WHERE categoryId=1803
0.0020  SELECT l.year,l.group_code FROM leagues_besoccer l WHERE l.categoryId = 1803 AND l.year = 1980 ORDER BY l.group_code ASC
0.0020  SELECT group_code, extraName from `leagues` WHERE categoryId=1803 AND year=1980