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 
Waitemata City       2-0  Grey Lynn
Hibiscus Coast       1-4  Teachers United
East Coast Bays      3-0  Te Atatu
Avondale United      0-15 Cornwall
Metro College        1-0  Pakuranga Town
Massey               1-1  Howick [aet, 3-2 pen]
Papatoetoe           2-1  Otara Rangers
Manukau City         2-1  Thames
Onehunga United      0-7  Auckland University
Huntly Thistle       3-2  Wanderers
Taupo                2-1  Turangi Wanderers  
  
Round 2 
Kaikohe Rangers      3-0  Northern United
Waitemata City       4-0  Green Bay United
Teachers United      0-1  Oratia United
Kelston West         0-2  East Coast Bays
Cornwall             2-3  Pt Chevalier
Metro College        4-1  Massey
Papatoetoe           3-2  Manukau City
Birkenhead United    2-2  Auckland University [aet, 4-5 pen]
Huntly Thistle       5-0  Matamata
Tokoroa              4-2  Ngaruawahia United
Fraser               0-4  Claudelands Rovers
Tauranga City        4-0  Kawerau Town
Taupo                wbd  ATG
Ngongotaha Rovers    0-6  Rotorua Suburbs  

Round 3
Kaikohe Rangers      1-10 Hertz Whangarei
Eden                 0-0  Glenfield Rovers [aet, 4-3 pen]
Waitemata City       1-2  Lynndale
Mt Roskill           2-1  Ellerslie
Oratia United        0-4  East Coast Bays
Pt Chevalier         2-4  Metro College
Papatoetoe           0-4  Manurewa
Takapuna City        3-1  Auckland University
Huntly Thistle       2-4  Papakura City
Tokoroa              2-3  Claudelands Rovers
Rotorua City         3-0  Tauranga City
Taupo                1-2  Rotorua Suburbs  

Round 4
Hertz Whangarei      3-1  Eden
Lynndale             1-0  Mt Roskill
East Coast Bays      5-5  Metro College [aet, 2-3 pen]
Manurewa             1-0  Takapuna City
Papakura City        1-0  Claudelands Rovers
Rotorua City         4-1  Rororua Suburbs


Central Region: 

Round 2 
Inglewood            0-3  Central City
Moturoa              5-0  Waitara
New Plymouth OB     10-0  Opunake
Eltham               0-8  Wanganui Athletic
Dannevirke United    1-2  Glen Carron
Massey Uni           2-0  Linton Army
Feilding             1-3  Levin United
Kiwi United          3-1  North End
Napier City Rovers   3-1  Gisborne Thistle
Taradale             1-1  Havelock North Wanderers [aet, 3-4 pen]
Douglas Villa        4-1  Victoria University
Carterton            0-2  Masterton
Wellington WMC       0-2  Viard OB
Wainui               1-5  Brooklyn Northern United
Karori Swifts        5-1  Hungaria
Newlands United      0-2  Upper Hutt United
Mana United          1-5  Tawa
Marist               2-2  Adriatic [aet, 2-3 pen]
Tararua United       1-2  Porirua City
Stokes Valley        4-1  Naenae
Nelson Suburbs       4-3  North Wellington
Richmond Athletic    5-2  Motueka
Island Bay           5-4  Raumati Hearts                 
   
Round 3
Central City         0-5  Moturoa
Taranaki United      2-0  New Plymouth OB
Wanganui Athletic    3-0  Glen Carron
Massey University    2-7  Manawatu United
Levin United         0-2  Kiwi United
Napier City Rovers   4-2  Havelock North Wanderers
Douglas Villa        0-1  Masterton
Viard OB             3-1  Brooklyn Northern United
Petone               4-2  Karori Swifts
Wellington City      1-2  CYFC
Upper Hutt United    1-3  Tawa
Adriatic             0-12 Porirua United
Porirua City         0-10 Stokes Valley
Lower Hutt City      1-1  Seatoun [aet, 3-4 pen]
Nelson Suburbs       2-0  Richmond Athletic
Island Bay           0-8  Miramar Rangers    

Round 4 
Moturoa              0-3  Taranaki United
Wanganui Athletic    1-0  Manawatu United
Kiwi United          2-1  Napier City Rovers
Masterton            1-0  Viard OB
Petone               2-1  CYFC
Tawa                 1-1  Porirua United [aet, 2-4 pen]
Stokes Valley        1-0  Seatoun
Nelson Suburbs       0-0  Miramar Rangers [aet, 3-2 pen]


Southern Region: 

Round 2 
Nomads United        3-0  HSOB [aet]
Riccarton            1-2  Avonhead Tavern [aet]
Royal George         1-0  Marlin Carpets
Green Islands        0-3  Roslyn-Wakari
Invercargill Thistle 7-0  Invercargill United
  
Round 3
Western              1-2  New Brighton
Nomads United        2-3  Cashmere Wanderers
Northern Hearts      1-0  North End United
Rangers              4-0  University of Canterbury
Rangiora             3-1  Burndale United
Avonhead Tavern      1-5  Shamrock
Technical            3-0  Royal George
Hornby United        0-6  Papanui 
Roslyn-Wakari        1-4  Mosgiel
Caversham            6-1  King Edward TCOB
Queen's Park         2-4  Dunedin City
Invercargill Thistle 4-0  Invercargill OB      
              
Round 4
New Brighton         2-0  Cashmere Wanderers
Northern Hearts      0-1  Rangers
Rangiora             2-1  Shamrock
Technical            2-0  Papanui
Mosgiel              1-2  Caversham
Dunedin City         7-0  Invercargill Thistle           


COMPETITION PROPER 

Round 1 
------- 

Christchurch United  4-0  New Brighton
Rangers              3-2  Woolston WMC
Kiwi United          1-5  Masterton
Stop Out             4-0  Petone
Dunedin City         7-0  Technical
Caversham            3-2  Rangiora
Taranaki United      0-0  Nelson Suburbs [aet, 3-4 pen]
Wanganui Athletic    1-3  Nelson United
Mt Wellington        1-0  Courier Rangers
 [replay after Courier Rangers played an ineligible player in a game they won 1-0]
Papakura City        2-8  Eastern Suburbs
Wellington D United  5-0  Columbus Waterside
Porirua United       2-1  Stokes Valley [aet]
Lynndale             3-2  Hamilton [aet]
North Shore United   1-3  Blockhouse Bay [aet]
Metro College        0-5  Manurewa
Rotorua City         0-1  Hertz Whangarei 


Round 2 
------- 

Christchurch United  4-1  Rangers
Masterton            1-2  Stop Out [aet]
Dunedin City         2-1  Caversham
Nelson Suburbs       0-6  Nelson United
Mt Wellington        3-1  Eastern Suburbs
Wellington D United  2-1  Porirua United
Lynndale             1-5  Blockhouse Bay
Manurewa             7-0  Hertz Whangarei  

Round 3 
------- 

Christchurch United  2-1  Stop Out
Dunedin City         2-5  Nelson United
Mt Wellington        3-1  Wellington D United
Blockhouse Bay       2-4  Manurewa 

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

Christchurch United  1-3  Nelson United
Mt Wellington        1-2  Manurewa


Final 
-----   
[Sep-3] 
Trafalgar Park, Nelson
Manurewa 1-0 Nelson United      
 [Bruce Foster 12] 
  
Manurewa: Frank Van Hattum, Robert Leijh, Lee Stickland, 
David Bright, Stephen Lincoln, David Fifield,
George Lamont, Peter Bryson, Chris Turner, Mark
Armstrong, Bruce Foster
Nelson United: Owen Nuttridge, David Brydon, John
Slotemaker, Roger Fitzgerald, John Enoka, Alex Smith
(Keith Mackay), Peter Simonsen, Ronald Kolk,
David Powdrell, Eric James, Ken Cresswell

Referee: R. de Raat (Auckland)



Author: Andre Zlotkowski
(nzfooty@hotmail.com)

Last updated: 16 Feb 2001

(C) Copyright Andre Zlotkowski and RSSSF 2000/01


  USO DE MEMORIA  
4,194,496 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0018
Controller Execution Time ( Home / Category )  0.5989
Total Execution Time  0.6008
  CADENA URL  
/copa_chatham1978
  GET DATOS  
$_GET['/copa_chatham1978']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (39)  
0.0126  SELECT type FROM routes WHERE alias = 'copa_chatham1978'
0.0258  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 = 1978 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=1 DESC LIMIT 1
0.0130  SELECT text_es as historical_text FROM leagues_text WHERE id=1340
0.0127  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 = 29618 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0126  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='1978' WHERE c.parentId=1803 GROUP BY c.id ORDER BY c.order_id ASC
0.0125  SELECT type,rule FROM rules WHERE categoryId = 1803 ORDER BY type = 'tables_draw' DESC,type != 'extra' DESC, `order` ASC
0.0125  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-04-28 06:23:49' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0125  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=2 AND last_update > '2024-04-28 06:23:49' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0125  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=4 AND last_update > '2024-04-28 06:23:49' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0125  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=3 AND last_update > '2024-04-28 06:23:49' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0129  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 = 1978 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=0 DESC LIMIT 1
0.0128  SELECT l.id FROM leagues_webci l WHERE l.categoryId = 1803 AND l.year = 1978
0.0125  SELECT e.action, count(e.action) as total, e.player_id FROM events1978 e WHERE e.league_id IN (29618) 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.0126  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 (29618) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN () ORDER BY rp.in_squad = 1 DESC
0.0125  SELECT l.id FROM leagues_webci l WHERE l.categoryId = 1803 AND l.year = 1978
0.0127  SELECT e.action, count(e.action) as total, e.player_id FROM events1978 e WHERE e.league_id IN (29618) AND (e.action IN (4,5) ) GROUP BY e.player_id ORDER BY total DESC, e.player_id ASC LIMIT 20
0.0129  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 (29618) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN () ORDER BY rp.in_squad = 1 DESC
0.0127  SELECT l.id FROM leagues_webci l WHERE l.categoryId = 1803 AND l.year = 1978
0.0125  SELECT e.action, count(e.action) as total, e.player_id FROM events1978 e WHERE e.league_id IN (29618) AND (e.action IN (3,4) ) GROUP BY e.player_id ORDER BY total DESC, e.player_id ASC LIMIT 20
0.0127  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 (29618) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN () ORDER BY rp.in_squad = 1 DESC
0.0126  SELECT l.id FROM leagues_webci l WHERE l.categoryId = 1803 AND l.year = 1978
0.0128  SELECT e.action, count(e.action) as total, e.player_id FROM events1978 e WHERE e.league_id IN (29618) AND (e.action IN (22) ) GROUP BY e.player_id ORDER BY total DESC, e.player_id ASC LIMIT 20
0.0126  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 (29618) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN () ORDER BY rp.in_squad = 1 DESC
0.0126  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 = 1978 AND rp.lineup > 0 GROUP BY p.id ORDER BY total DESC,p.pod DESC LIMIT 20
0.0125  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 = 1978 AND rp.events > 0 GROUP BY p.id ORDER BY total DESC,p.pod DESC LIMIT 20
0.0127  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=29618 AND rel.round=9
0.0126  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 = 29618 AND esl.points > 0 ORDER BY esl.points DESC LIMIT 3
0.0126  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 = 29618 AND esl.points > 0
0.0127  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-29" AND c.`active`= 1 and c.comment_id is null and c.lang = 1 AND l.`id` = 29618 ORDER BY creation_date DESC LIMIT 0, 10
0.0130  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-29" AND c.`active`= 1 and comment_id is null and c.lang = 1 AND l.`id` = 29618
0.0127  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 `calendars1978` 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` = 29618 AND c.`round` = 9 ORDER BY shedule ASC LIMIT 200
0.0125  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 `events1978` e INNER JOIN calendars1978 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 = 29618 ORDER BY total DESC LIMIT 40
0.0127  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 `events1978` e INNER JOIN calendars1978 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 = 29618 AND e.real_date > NOW() - INTERVAL 1 MONTH ORDER BY e.real_date DESC LIMIT 30
0.0129  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 `tables1978` 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 = 29618 AND t.round = 7 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0129  SELECT *,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables1978` 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 = 29618 AND t.round = 9 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0129  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-28 00:00:00' AND c.`shedule` < '2024-05-02 23:59:59' AND l.id = 29618 ORDER BY c.shedule ASC, fcoef DESC LIMIT 5
0.0129  SELECT data1, data2 FROM services_tags WHERE categoryId=1803
0.0129  SELECT l.year,l.group_code FROM leagues_besoccer l WHERE l.categoryId = 1803 AND l.year = 1978 ORDER BY l.group_code ASC
0.0129  SELECT group_code, extraName from `leagues` WHERE categoryId=1803 AND year=1978