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

Northern Region:
[Apr 14]
Mt Albert Grammar     6-0  Bohemian Celtic

Southern Region:
[Apr 25]
Mornington            5-2  Redemption
Southend United       0-1  Queens Park
Timaru City           2-4  Northern Hearts           (aet)
[Apr 26]
Western               1-1  Christchurch United       (aet, 4-2 pen)
[Apr 30]
Woolston WMC          2-1  Burnside
[May 1]
Christchurch BHS      2-4  North Canterbury Utd


Round 1
-------

Northern Region:
[May 7/8]
Albany United        12-1  Glen Eden United
Bucklands Beach       0-5  Takapuna
Central United       21-0  Norwest United
Ellerslie             1-0  Birkenhead United
FC Whangarei          1-6  South Auckland Rangers
Foss United           0-1  Cambridge
Greenhithe            0-3  Oratia United
Hamilton North        2-1  Hamilton Old Boys
Hamilton Wanderers   10-0  Waikato Unicol
Huntly Thistle        1-3  Tauranga City United
Internationale        1-3  Auckland Grammar
Lynn-Avon United      0-3  Eastern Suburbs
Mangere United        8-0  St Peter's College
Manukau City          0-11 Mt Albert Grammar
Manurewa              4-0  Central Brown
Matamata Swifts       1-0  Claudelands Rovers
Melville United       3-0  Pukekohe
Metro                 1-4  University Mt Wellington
Mt Albert-Ponsonby    1-5  Papakura
Navy                  lbd  Three Kings United
NZ Celtic Supporters  2-5  Fencibles United
North Shore United    9-1  Onehunga-Mangere United
Onehunga Sports       5-0  Hibiscus Coast
Otahuhu United        0-6  Bay Olympic
Otorohanga            1-2  Ngaruawahia United
Papatoetoe            0-2  Glenfield Rovers
Tauranga BC           4-4  Whakatane Town             (aet, 2-3 pen)
Te Atatu              2-3  Western Springs
Te Puke United        1-1  Taupo                      (aet, 4-5 pen)
Waitakere City        2-1  West Auckland
Waitemata             0-9  East Coast Bays
Zamantix Rovers       0-3  Forrest Hill-Milford Utd

Central Region:
[May 7/8]
Eastbourne            2-3  Stokes Valley
Inglewood             3-3  Peringa United             (aet, 6-7 pen)
Island Bay United     3-0  Stop Out
Kapiti Coast United   1-2  North Wellington
Lower Hutt City       2-1  Wellington Marist
Naenae                3-1  Porirua City
Palmerston North End  0-2  Wanganui City
Petone                2-1  Tawa
Seatoun               1-0  Brooklyn Northern United
Taradale              3-1  Gisborne Thistle
Upper Hutt City       2-0  Wainuiomata
Wairarapa United      2-2  Victoria University        (aet, 6-5 pen)
Wanganui Athletic     3-0  Red Sox Manawatu
Wellington United     1-0  Waterside Karori
Gisborne City Marist  bye
Miramar Rangers       bye
Napier City Rovers    bye
Palmerston Nth Marist bye
Wellington Olympic    bye
Western Suburbs       bye

Southern Region:
[May 7]
Avon United           1-3  Western
Woolston              1-0  Ferrymead Bays
Christchurch Rangers  2-0  New Brighton
Christchurch Tech     1-1  Nth Canterbury Utd         (aet, 3-2 pen)
Dunedin Technical     0-2  Roslyn Wakari
Green Island          1-2  Caversham
Mosgiel               3-0  Queenstown Rovers
Nelson Suburbs        0-2  Halswell United
Northern Hearts       0-3  Northern
Queens Park           0-4  Grants Braes
Waihopai              2-1  Mornington
[May 8]
Nomads                3-1  Otago University


Round 2
-------
[May 21/22]

Northern Region:
Albany United         3-1  Auckland Grammar
Cambridge             1-2  Whakatane Town
Central United        6-0  Oratia United
East Coast Bays       3-1  Takapuna
Eastern Suburbs       3-0  Mangere United
Fencibles United      0-6  Papakura
Forrest Hill-Milford  1-9  North Shore United
Hamilton Wanderers    6-1  Hamilton North
Manurewa              0-1  Onehunga Sports
Melville United       1-2  Glenfield Rovers
Mt Albert Grammar     1-2  University/Mt Wellington
Ngaruawahia United    6-1  Matamata Swifts
Tauranga City United 11-0  Taupo
Three Kings United    5-2  Sth Auckland Rangers
Waitakere City        4-0  Ellerslie
Western Springs       0-3  Bay Olympic

Central Region:
Gisborne City Marist  3-0  Taradale
Lower Hutt City       2-0  Island Bay United
PN Marist             5-0  Wanganui City
Napier City Rovers    6-2  Wairarapa United
North Wellington      3-2  Miramar Rangers
Seatoun               0-2  Upper Hutt City
Stokes Valley         1-4  Naenae
Wanganui Athletic     3-1  Peringa United
Wellington Olympic    4-2  Wellington United
Western Suburbs       0-2  Petone
(Wests won 3-0 but fielded an ineligible player)

Southern Region:
Caversham             9-0  Grants Braes
Christchurch Rangers  2-2  Halswell United             (aet, 1-3 pen)
Mosgiel               2-0  Northern
Nomads United         3-1  Christchurch Technical
Roslyn Wakari         9-0  Waihopai
Woolston WMC          0-6  Western

Round 3
-------

Northern Region:
[Jun 11]
East Coast Bays       3-0  Three Kings United
Eastern Suburbs       3-0  Onehunga Sports
Ngaruawahia United    1-3  Tauranga City United
Whakatane Town        2-6  Hamilton Wanderers
[Jun 12]
North Shore United    3-1  Albany United
Uni/Mt Wellington     1-5  Papakura
[Jun 19]
Waitakere City        1-2  Central United
[Jun 25]
Bay Olympic           2-0  Glenfield Rovers

Central Region:
[Jun 11]
PN Marist             7-0  Wanganui Athletic
North Wellington      0-1  Naenae
Petone                0-5  Wellington Olympic
Upper Hutt City       1-3  Lower Hutt City
[Jun 12]
Napier City Rovers    1-3  Gisborne City Marist

Southern Region:
[Jun 11]
Caversham             2-4  Roslyn Wakari
Nomads United         1-3  Halswell United
Western               0-1  Mosgiel

Round 4
-------

Northern Region:
[Jul 2]
Central United        4-2  Hamilton Wanderers
 [G Young 2 (1 pen), OG, G Uhlmann - M Cossey, A Thompson]
Tauranga City United  1-1  Eastern Suburbs             (aet, 4-5 pen)
 [C Boyle - N Palmer]

[Jul 3]
North Shore United    2-3  East Coast Bays
 [M Cunneen, B Scott pen - P Edginton, G Suri, M Beldham pen]
Papakura              2-1  Bay Olympic
 [S Irvine, B Hawke - C Gage]


Central Region:
[Jul 3]
Gisborne City         1-5  Lower Hutt City
 [L Eeson pen - P Garcias 2, D Richmond, M Madden, P Patterson]
PN Marist             2-0  Naenae
 [P Halstead 2]

Central/Southern Region:
[Jul 3]
Wellington Olympic    5-2  Mosgiel
 [G Little 2, D Cheriton, K Cripps, K Waylan - M Abbott, B Stevens pen]


Southern Region:
[Jul 2]
Roslyn Wakari         3-4  Halswell United             (aet)
 [T Dalman, J Letts, B Scoullar - S Neame, J Deaker, M Sands 2]


Quarter-Finals
--------------

[Jul 23]
Eastern Suburbs       1-4  Wellington Olympic
 [N Palmer - G Little 2 (1 pen), G Brown, J Curtis] 
[Jul 24]
East Coast Bays       1-2  Central United
 [N Jones - P Urlovic, L del Monte]
Halswell United       2-1  Papakura
 [M Sands, K Grosvenor - B Godden]
PN Marist             2-1  Lower Hutt City
 [P Halstead, M Silver - P Garcias pen] 

Semi-Finals
-----------

[Aug 14]
Halswell United       1-3  Central United
 [K Grosvenor pen - P Urlovic, H McCormack, L del Monte] 

Wellington Olympic    1-2  Palmerston North Marist  
 [G Barbarouses - P Halstead, N Hill]

Final
----- 

[Sep 5, North Harbour Stadium, Albany, Auckland]
Central United        2-1  Palmerston North Marist 
 [P Urlovic 21', N Sykes 80' - N Hill 84']

Central United:  R Nicholson, J Mathews, P Seaman, D Tallentire, L del Monte 
                 (S Greenhalgh 88'), J Smith, H McCormack, N Sykes, G Uhlmann, 
                 P Urlovic (G Eie 90'), C Coombes. 
Marist:          H Englefield, K Sugiara (B Argyle 64'), N Hill, M Tesar, 
                 M Silver (J McElhannan 80'), Y Tomomatsu (G Fraser 72'), 
                 N Darbyshire, P Halstead, A Cowan, I Sandbrook, S Singh. 

Referee:  Neil Fox 



Author: Andre Zlotkowski 
(nzfooty@hotmail.com)

Last updated: 28 Sep 2005

(C) Copyright Andre Zlotkowski and RSSSF 2004/05


  USO DE MEMORIA  
4,199,616 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0031
Controller Execution Time ( Home / Category )  0.1265
Total Execution Time  0.1296
  CADENA URL  
/copa_chatham2005
  GET DATOS  
$_GET['/copa_chatham2005']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (41)  
0.0020  SELECT type FROM routes WHERE alias = 'copa_chatham2005'
0.0040  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 = 2005 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=1 DESC LIMIT 1
0.0020  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 3 AND rel.typeId = 1803 AND rel.ln = 'es' AND rel.status=1 ORDER BY rel.creation_date desc,rel.cover_points DESC LIMIT 5
0.0022  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 (363671) ORDER BY n.cover_points DESC, update_date DESC
0.0035  SELECT text_es as historical_text FROM leagues_text WHERE id=1315
0.0024  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 = 29593 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0020  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='2005' WHERE c.parentId=1803 GROUP BY c.id ORDER BY c.order_id ASC
0.0019  SELECT type,rule FROM rules WHERE categoryId = 1803 ORDER BY type = 'tables_draw' DESC,type != 'extra' DESC, `order` ASC
0.0019  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-04-28 17:26:18' 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-28 17:26:18' 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=4 AND last_update > '2024-04-28 17:26:18' 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=3 AND last_update > '2024-04-28 17:26:18' 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 = 2005 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 = 2005
0.0019  SELECT e.action, count(e.action) as total, e.player_id FROM events2005 e WHERE e.league_id IN (29593) 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.0021  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 (29593) 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 = 2005
0.0024  SELECT e.action, count(e.action) as total, e.player_id FROM events2005 e WHERE e.league_id IN (29593) 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 (29593) 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 = 2005
0.0018  SELECT e.action, count(e.action) as total, e.player_id FROM events2005 e WHERE e.league_id IN (29593) AND (e.action IN (3,4) ) GROUP BY e.player_id ORDER BY total DESC, e.player_id ASC LIMIT 20
0.0020  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 (29593) 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 = 2005
0.0021  SELECT e.action, count(e.action) as total, e.player_id FROM events2005 e WHERE e.league_id IN (29593) 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 (29593) 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 = 2005 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 = 2005 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=29593 AND rel.round=9
0.0020  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 = 29593 AND esl.points > 0 ORDER BY esl.points DESC LIMIT 3
0.0020  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 = 29593 AND esl.points > 0
0.0024  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` = 29593 ORDER BY creation_date DESC LIMIT 0, 10
0.0025  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` = 29593
0.0020  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 `calendars2005` 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` = 29593 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 `events2005` e INNER JOIN calendars2005 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 = 29593 ORDER BY total DESC LIMIT 40
0.0030  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 `events2005` e INNER JOIN calendars2005 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 = 29593 AND e.real_date > NOW() - INTERVAL 1 MONTH ORDER BY e.real_date DESC LIMIT 30
0.0022  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 `tables2005` 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 = 29593 AND t.round = 7 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0022  SELECT *,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables2005` 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 = 29593 AND t.round = 9 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0022  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 = 29593 ORDER BY c.shedule ASC, fcoef DESC LIMIT 5
0.0022  SELECT data1, data2 FROM services_tags WHERE categoryId=1803
0.0022  SELECT l.year,l.group_code FROM leagues_besoccer l WHERE l.categoryId = 1803 AND l.year = 2005 ORDER BY l.group_code ASC
0.0022  SELECT group_code, extraName from `leagues` WHERE categoryId=1803 AND year=2005