4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Información Histórica 
						
NZFC (First Level) teams are not eligible to take part 


Preliminary Round

Eastbourne                  1-4 Rongotai College
Paekakariki                 0-1 Wellington College
Porirua City                0-6 Levin

Round One

Auckland Grammar            3-1 Beachlands Maraetai
Brew Town                   8-0 Glen Eden United
Brooklyn Northern United    0-0 Levin                       (3-4 pen)
Clevedon                    1-4 Mt Albert Grammar
Fencibles United           14-1 Okaihau/Kaeo United
Hamilton North              0-4 Claudelands Rovers
Internationale              0-7 Warkworth
Mt Albert-Ponsonby          8-2 Bohemian Celtic
Naenae                      1-0 Douglas Villa
Ngongotaha                  1-3 Ellerslie
North Wellington            0-4 Waterside Karori
Norwest Old Boys            1-4 Oratia United
Norwest United              3-1 Eden Stallions
Otahuhu United              1-0 Tokoroa
Papakura City               1-2 St Peter's College
Rotorua United              1-3 Te Puke United
Seatoun                     0-4 Marist Wellington
Stop Out                    1-1 Kapiti Coast United         (4-2 pen)
Taupo                       1-3 Tauranga City United
Te Awamutu                  1-5 Otumoetai                   [ineligible players used by both teams resulting in disqualification ]
Upper Hutt City             3-0 Victoria University
Waikato Unicol              2-2 Old Blues                   (4-2 pen)
Wainuiomata                 0-1 Rongotai College
Waitemata                   1-0 Kerikeri
Wellington College          4-0 Waikanae
Wellington United           3-1 Island Bay United
West Auckland               5-2 Whangarei
West Hamilton United        1-3 Pukekohe
Westlake BHS                2-0 Cambridge
Whakatane Town              wbd Te Atatu
Birkenhead United           bye
Hibiscus Coast              bye	
Lower Hutt City             bye
Mangere United              bye
Matamata Swifts             bye	
Miramar Rangers             bye
Navy                        bye
North Shore United          bye
Onehunga-Mangere United     bye
Petone                      bye	
Tawa                        bye
Wairarapa United            bye
Waiuku                      bye
Wellington Olympic          bye
Western Springs             bye
Western Suburbs             bye

Round Two

Auckland Grammar            9-0 Te Puke United
Avon United                 1-1 Cashmere Wanderers          (2-4 pen)
Brew Town                   2-1 Fencibles United
Burnside                    3-0 Waimakariri United
Christchurch United         1-3 Western
Ferrymead Bays              4-2 Coastal Spirit
Grants Braes                1-1 Northern Hearts             (3-5 pen)
Green Island                0-0 Northern                    (5-3 pen)
Hibiscus Coast              1-2 Birkenhead United
Melchester Rovers           0-6 Roslyn Wakari
Mid Canterbury United       8-0 Selwyn
Miramar Rangers             9-0 Naenae
Mosgiel                     4-3 Queenstown
Mt Albert-Ponsonby          3-2 Matamata Swifts
Navy                        1-3 Oratia United
Nelson Suburbs              2-0 Richmond Athletic
Nomads United               4-0 Christchurch BHS
North Shore United          5-1 Norwest United
Old Boys                    4-2 Queens Park
Onehunga-Mangere United     3-2 St Peter's College
Otahuhu United              1-5 Pukekohe
Petone                      1-2 Lower Hutt City
Rongotai College            0-3 Marist Wellington
Southend United             3-2 Waihopai
Tauranga City United        4-1 Mt Albert Grammar 
Upper Hutt City             1-0 Stop Out
Waikato Unicol              1-3 Claudelands Rovers
Wairarapa United            7-0 Wellington College
Waitemata                   4-2 Waiuku
Warkworth                   2-5 Whakatane Town
Wellington Olympic          3-1 Tawa
Wellington United           5-1 Waterside Karori
West Auckland               1-8 Ellerslie
Western Springs             6-1 Westlake BHS
Western Suburbs             4-0 Levin
Woolston Technical          3-4 Halswell United	
Albany United               bye
Bay Olympic                 bye
Caversham                   bye
Central United              bye
Dunedin Technical           bye
East Coast Bays             bye
Eastern Suburbs             bye
Forrest Hill-Milford United bye
Glenfield Rovers            bye
Hamilton Wanderers          bye
Inglewood                   bye
Lynn-Avon United            bye
Mangere United              bye
Manurewa                    bye
Marist Palmerston North     bye
Maycenvale United           bye
Melville United             bye
Metro                       bye
Napier City Rovers          bye
New Plymouth Rangers        bye
Onehunga Sports             bye
Palmerston North End        bye
Papatoetoe                  bye
Red Sox Manawatu            bye
Takapuna                    bye
Taradale                    bye
Three Kings United          bye
Waitakere City              bye

Round Three

Auckland Grammar            3-1 Onehunga-Mangere United
Bay Olympic                 6-1 Lynn-Avon United
Brew Town                   1-4 Waitakere City
Burnside                    1-2 Western
Caversham                   5-1 Dunedin Technical
Central United              1-2 Metro
East Coast Bays             1-0 Onehunga Sports
Eastern Suburbs             8-0 Whakatane Town
Ferrymead Bays              4-2 Mid Canterbury United
Hamilton Wanderers          7-4 Mt Albert-Ponsonby
Inglewood                   1-7 Napier City Rovers
Mangere United              0-7 Glenfield Rovers
Marist Palmerston North     1-0 Palmerston North End
Melville United             2-0 Papatoetoe
Miramar Rangers             3-2 Wairarapa United
Mosgiel                     2-1 Green Island
Nelson Suburbs              2-1 Halswell United
Nomads United               0-1 Cashmere Wanderers
Northern Hearts             3-2 Old Boys
Oratia United               1-10 Forrest Hill-Milford United
Pukekohe                    0-3 Birkenhead United
Red Sox Manawatu            2-0 Maycenvale United
Southend United             0-5 Roslyn Wakari
Takapuna                    5-2 North Shore United
Taradale                    1-2 New Plymouth Rangers
Tauranga City United        4-2 Manurewa
Three Kings United          8-1 Claudelands Rovers
Upper Hutt City             3-1 Marist Wellington
Waitemata                   0-5 Albany United
Wellington United           2-1 Wellington Olympic
Western Springs             0-3 Ellerslie
Western Suburbs             2-2 Lower Hutt City             (1-3 pen)

Round Four

Albany United               3-1 Hamilton Wanderers
Birkenhead United           1-0 Tauranga City United
Caversham                   8-0 Mosgiel
East Coast Bays             9-0 Auckland Grammar
Ferrymead Bays              6-0 Cashmere Wanderers
Glenfield Rovers            2-1 Ellerslie
Melville United             0-1 Forrest Hill-Milford United
Metro                       1-2 Waitakere City
Miramar Rangers             3-2 Lower Hutt City
Napier City Rovers         12-2 Red Sox Manawatu
Nelson Suburbs              0-1 Western
New Plymouth Rangers        0-4 Wellington United
Northern Hearts             2-5 Roslyn Wakari
Takapuna                    0-5 Bay Olympic
Three Kings United          3-2 Eastern Suburbs
Upper Hutt City             2-1 Marist Palmerston North

Round Five

Bay Olympic                 3-1 Waitakere City
Caversham                   8-2 Roslyn Wakari
Forrest Hill-Milford United 3-1 Albany United
Glenfield Rovers            3-1 Birkenhead United
Napier City Rovers          1-2 Miramar Rangers
Three Kings United          1-2 East Coast Bays
Upper Hutt City             0-4 Wellington United
Western                     1-1 Ferrymead Bays              (3-4 pen)

Quarterfinals

East Coast Bays             2-1 Glenfield Rovers
Ferrymead Bays              3-7 Caversham
Forrest Hill-Milford United 0-2 Bay Olympic
Miramar Rangers             3-1 Wellington United

Semifinals

Caversham                   3-3 Bay Olympic                 (1-4 pen)
Miramar Rangers             2-1 East Coast Bays

Final [Sep 12, at North Harbour Stadium]

Bay Olympic                 1-3 Miramar Rangers
   [Nathan Strom 34; Tim Schaeffers 12, Campbell Parkin 20, Michael White 75] 


Author: Andre Zlotkowski 
(nzfooty@hotmail.com)

Last updated: 30 Jan 2014

(C) Copyright Andre Zlotkowski and RSSSF 2009/14


  USO DE MEMORIA  
4,203,112 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0019
Controller Execution Time ( Home / Category )  0.7354
Total Execution Time  0.7373
  CADENA URL  
/copa_chatham2010
  GET DATOS  
$_GET['/copa_chatham2010']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (42)  
0.0144  SELECT type FROM routes WHERE alias = 'copa_chatham2010'
0.0292  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 = 2010 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=1 DESC LIMIT 1
0.0146  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=1803 AND type_rel = 3
0.0146  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.0145  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.0149  SELECT text_es as historical_text FROM leagues_text WHERE id=1310
0.0145  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 = 29588 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0146  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='2010' WHERE c.parentId=1803 GROUP BY c.id ORDER BY c.order_id ASC
0.0144  SELECT type,rule FROM rules WHERE categoryId = 1803 ORDER BY type = 'tables_draw' DESC,type != 'extra' DESC, `order` ASC
0.0145  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-04-27 17:34:11' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0145  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=2 AND last_update > '2024-04-27 17:34:11' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0145  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=4 AND last_update > '2024-04-27 17:34:11' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0145  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=3 AND last_update > '2024-04-27 17:34:11' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0150  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 = 2010 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=0 DESC LIMIT 1
0.0149  SELECT l.id FROM leagues_webci l WHERE l.categoryId = 1803 AND l.year = 2010
0.0145  SELECT e.action, count(e.action) as total, e.player_id FROM events2010 e WHERE e.league_id IN (29588) 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.0156  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 (29588) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN () ORDER BY rp.in_squad = 1 DESC
0.0145  SELECT l.id FROM leagues_webci l WHERE l.categoryId = 1803 AND l.year = 2010
0.0151  SELECT e.action, count(e.action) as total, e.player_id FROM events2010 e WHERE e.league_id IN (29588) AND (e.action IN (4,5) ) GROUP BY e.player_id ORDER BY total DESC, e.player_id ASC LIMIT 20
0.0145  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 (29588) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN () ORDER BY rp.in_squad = 1 DESC
0.0150  SELECT l.id FROM leagues_webci l WHERE l.categoryId = 1803 AND l.year = 2010
0.0145  SELECT e.action, count(e.action) as total, e.player_id FROM events2010 e WHERE e.league_id IN (29588) AND (e.action IN (3,4) ) GROUP BY e.player_id ORDER BY total DESC, e.player_id ASC LIMIT 20
0.0146  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 (29588) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN () ORDER BY rp.in_squad = 1 DESC
0.0145  SELECT l.id FROM leagues_webci l WHERE l.categoryId = 1803 AND l.year = 2010
0.0146  SELECT e.action, count(e.action) as total, e.player_id FROM events2010 e WHERE e.league_id IN (29588) AND (e.action IN (22) ) GROUP BY e.player_id ORDER BY total DESC, e.player_id ASC LIMIT 20
0.0145  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 (29588) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN () ORDER BY rp.in_squad = 1 DESC
0.0145  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 = 2010 AND rp.lineup > 0 GROUP BY p.id ORDER BY total DESC,p.pod DESC LIMIT 20
0.0145  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 = 2010 AND rp.events > 0 GROUP BY p.id ORDER BY total DESC,p.pod DESC LIMIT 20
0.0149  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=29588 AND rel.round=9
0.0147  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 = 29588 AND esl.points > 0 ORDER BY esl.points DESC LIMIT 3
0.0148  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 = 29588 AND esl.points > 0
0.0148  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-28" AND c.`active`= 1 and c.comment_id is null and c.lang = 1 AND l.`id` = 29588 ORDER BY creation_date DESC LIMIT 0, 10
0.0150  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-28" AND c.`active`= 1 and comment_id is null and c.lang = 1 AND l.`id` = 29588
0.0147  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 `calendars2010` 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` = 29588 AND c.`round` = 9 ORDER BY shedule ASC LIMIT 200
0.0145  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 `events2010` e INNER JOIN calendars2010 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 = 29588 ORDER BY total DESC LIMIT 40
0.0149  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 `events2010` e INNER JOIN calendars2010 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 = 29588 AND e.real_date > NOW() - INTERVAL 1 MONTH ORDER BY e.real_date DESC LIMIT 30
0.0149  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 = 29588 AND t.round = 7 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0149  SELECT *,(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 = 29588 AND t.round = 9 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0149  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 = 29588 ORDER BY c.shedule ASC, fcoef DESC LIMIT 5
0.0149  SELECT data1, data2 FROM services_tags WHERE categoryId=1803
0.0149  SELECT l.year,l.group_code FROM leagues_besoccer l WHERE l.categoryId = 1803 AND l.year = 2010 ORDER BY l.group_code ASC
0.0149  SELECT group_code, extraName from `leagues` WHERE categoryId=1803 AND year=2010