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

The National League clubs will enter in the third round on May 19. 
(N.B. Canterbury United which is an entity representing all the federation 
      level clubs in Christchurch, does not take part in the Chatham Cup)

Preliminary Round
-----------------

Northern:
[Apr 13/14]
Norwest United       1-3  Hibiscus Coast 
NZ Celtic Supporters 1-3  Waitemata City 
Foss United          1-6  Rotorua City  
Otorohanga Wanderers 1-3  Waikato Unicol
RNZAF Whenuapai      0-8  Forrest Hill-Milford Utd
Sacred Heart College lbd  Mangere United 
Greerton Rovers      3-3  Te Puke United [4-3 pen]  
St. John's College   0-3  Claudelands Rovers
Hamilton BHS         0-1  Whakatane Town
Sth Auckland Rangers 2-4  Auckland Grammar
James Cook HS        1-4  Dispensary Bar
Tauranga College     0-1  Ngongataha 
Lynn-Avon United     9-1  Waiuku 
Mt. Albert Grammar   2-1  Albany United
West Auckland        2-1  Oratia Wanderers
Mt Roskill Grammar   4-0  Zamantix Albion
West Hamilton United 1-2  Cambridge 
Navy                 0-4  Western Springs  
Whakatane HS         lbd  Ngaruawahia United 
Whangarei BHS        lbd  Central Brown 

Central:
[Apr 13/14]
North Wellington     3-1  Otaki 
Eastbourne           1-3  Waikanae 
Feilding United      1-4  Palmerston North BHS
Francis Douglas Mem. 0-12 New Plymouth Rangers 
Gisborne Thistle     wbd  Gisborne BHS
Seatoun              3-0  Stokes Valley 
Hawera               wbd  Feilding BHS 
Stop Out             1-1  Upper Hutt City [2-4 pen]
Kapiti Hearts        2-0  Naenae 
Tawa                 2-0  Victoria University 
Massey University    0-1  Brooklyn Northern Utd
Wellington College   2-3  Wainuiomata

Southern:
[Apr 13/14]
Cashmere Wanderers   5-3  Papanui Redwood  
Waitaki BHS          wbd  Roxburgh School 
Melchester Rovers    0-2  Waihopai 

 
Round 1
-------

Northern Region:   
[Apr 24]
Metro                0-3  West Auckland 
[Apr 25]
Central Brown        0-5  Forrest Hill Milford 
Tikipunga            3-2  Waitemata 
Birkenhead United    3-2  Hibiscus Coast 
Glenfield Rovers     8-0  Manukau City 
Oratia United        1-2  East Coast Bays 
Takapuna             2-1  Onehunga Sports 
Te Atatu             4-0  FC Whangarei 
Otahuhu United       0-3  Auckland GS 
Bay Olympic          1-0  Eastern Suburbs 
Fencibles United     0-1  Melville United 
Mt Albert GS         3-6  Ellerslie 
Mt Roskill Grammar   lbd  Papatoetoe 
Onehunga Mangere Utd 0-1  Hamilton Wanderers 
Papakura             2-0  Claudelands Rovers 
Three Kings United   4-1  Cambridge 
Western Springs      2-1  Lynn Avon United 
Greerton Rovers      wbd  Dispensary Bar 
Ngaruawahia United   4-2  Rotorua City 
Ngongotaha           1-6  Mt Albert Ponsonby 
Waikato Unicol       1-6  Mangere United 
Whakatane AFC        1-2  Manurewa 
   
Central Region:   
[Apr 25]
Island Bay United    4-1  North Wellington 
Wanganui Athletic    4-2  New Plymouth Rangers 
Gisborne City        0-1  Havelock North 
Lower Hutt City      7-0  Wairarapa United 
Kapiti Hearts        1-3  Western Suburbs 
Wellington United    6-3  Wainuiomata 
Moturoa              7-1  Hawera 
Palmerston Nth Mar   0-0  Wellington Olympic [4-1 pen] 
Wellington Marist    5-0  Palmerston North BHS
Waterside Karori     2-1  Tawa 
Upper Hutt City      1-3  Petone 
Seatoun              0-3  Brooklyn Northern United 
Taradale             3-1  Gisborne Thistle 
Waikanae             2-6  Red Sox 
   
Southern Region:
[Apr 25]     
Avon United          1-5  Ferrymead Bays 
Nomads United        2-3  Halswell United 
Rangers              1-3  Rangiora 
Woolston WMC         2-4  New Brighton 
Christchurch Tech    2-2  Western  [3-4 pen]   
Christchurch United  3-3  Cashmere Wanderers [5-4 pen] 
Waihopai             0-5  Caversham 
Roslyn Wakari       13-0  Waitaki BHS 
Northern             1-3  Otago University 
Green Island         5-1  Queenstown 

Round 2
-------
 
Northern Region:
[May 4/5]
Mt. Albert-Ponsonby  2-2  Birkenhead United [6-5 pen]
Ellerslie            3-1  Papatoetoe
Ngaruawahia United   2-3  Te Atatu 
Forrest Hill-Mil Utd 1-2  Bay Olympic 
Greerton Rovers      1-1  East Coast Bays [1-2 pen]
Papakura             2-4  Glenfield Rovers 
Takapuna             3-2  Auckland GS 
Mangere United       3-1  Tikipunga  
Three Kings United   4-3  Hamilton Wanderers 
Manurewa             2-1  Western Springs
Melville United      1-1  West Auckland [4-2 pen]  

Central Region:
[May 4/5]
Havelock North Wand  1-0  Brooklyn Northern Utd 
Lower Hutt City      4-1  Red Sox   
Taradale             1-3  Moturoa 
Wanganui East Ath    0-3  Wellington United 
Palmerston N Marist  0-1  Western Suburbs  
Waterside Karori     1-2  Petone 
Wellington Marist    0-0  Island Bay United [4-3 pen]

Southern Region:
[May 4/5]
Caversham            2-0  Green Island  
Otago University     0-1  Roslyn Wakari 
Halswell United      3-1  Christchurch United  
Rangiora             1-1  New Brighton [1-3 pen]
Western              0-1  Ferrymead Bays 

Round 3
-------
Played May 17 to May 19.

Northern Region:
Central United       8-0  Takapuna
East Coast Bays      2-0  Te Atatu 
Ellerslie            0-2  Bay Olympic
North Shore United   0-1  Waitakere City 
Tauranga City United 4-0  Three Kings United 
Uni-Mt Wellington    4-0  Glenfield Rovers 
Mangere United       6-1  Manurewa 
Melville United      2-0  Mt Albert-Ponsonby  

Central Region:
Miramar Rangers      5-1  Lower Hutt City
Napier City Rovers   4-1  Havelock North Wand 
Manawatu             6-1  Moturoa 
Wellington United    2-1  Petone 
Western Suburbs      4-1  Wellington Marist 

Southern Region:
Caversham            1-0  Dunedin Technical  
New Brighton         1-4  Halswell United 
Ferrymead Bays       7-2  Roslyn Wakari  


Round 4
-------

Northern Region:
[Jun 2/3]
Bay Olympic          3-2  Mangere United 
Tauranga City United 1-0  East Coast Bays
Uni-Mt Wellington    3-0  Melville United
Waitakere City       1-2  Central United 

Central Region:
[Jun 2/3]
Miramar Rangers      4-0  Western Suburbs  
Wellington United    0-4  Napier City Rovers 

Southern Region:
[Jun 2/3]
Caversham            3-1  Manawatu
 [Caversham fielded ineligible player and was disqualified]
Halswell United      1-0  Ferrymead Bays  

Quarter-finals
--------------

Northern Region:
[Jun 16]
Central United       1-3  Uni-Mt Wellington  
 [M Quirke 34 - K Waetford 7, P Bunbury 70pen, S Roberts 86]
Tauranga City United 3-0  Bay Olympic
 [B Derry 23, S Pilcher 38, 68] 

Central/Southern Region:
[Jun 16]
Napier City Rovers   1-0 Manawatu
 [L Birnie; HT 1-0] 
Miramar Rangers      7-1 Halswell United  
 [HT 3-1]

Semi-finals
-----------
[Jun 30]
Tauranga City United 3-1 Uni-Mt Wellington
 [Garry Board x3 - Stu Roberts; HT 1-1] 
Napier City Rovers   4-2 Miramar Rangers
 [Perry Cotton x2, Shane Cunliffe, Peter Howe - David Batty, Andy Hedge]  


Final [21 Jul, 2:30 pm] 
-----
Bluewater Park Island, Napier 
Napier City Rovers   2-0   Tauranga City United
 [Leon Birnie 20, Brad Scott 92]
 
Jack Batty Trophy (man-of-the-match): Leon Birnie (Napier)

Squads:
Napier City Rovers: Steve Graham, Peter Howe, Perry Cotton, Andy Rennie, 
Jonathon Taylor, Warren Gilbertson, Brad Scott, Jimmy Cudd, Shane Cunliffe, 
Shaun Easthope, Leon Birnie, Chris McIvor, David Gearey, Shane Smeltz.

Tauranga City United: James Pamment, Andrew Dixon, Paul Probert, Craig Flowerday, 
Jeremy Field, Alastair Frost, Paul Caton, Justin Creighton, Brett Derry, 
Scott Pilcher, Geoff Rickard, Nathan Fry, Kevin Manville, Mark Lourie, Garry Broad, 
Stewart Watane, Zuhayr Khan, Richard Pedley.

Referee: Derek Rugg 
Attendance: 4 500


Author: Andre Zlotkowski 
(nzfooty@hotmail.com)

Last updated: 15 Jun 2005

(C) Copyright Andre Zlotkowski and RSSSF 2002/05


  USO DE MEMORIA  
4,200,280 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0028
Controller Execution Time ( Home / Category )  0.1134
Total Execution Time  0.1162
  CADENA URL  
/copa_chatham2002
  GET DATOS  
$_GET['/copa_chatham2002']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (43)  
0.0017  SELECT type FROM routes WHERE alias = 'copa_chatham2002'
0.0038  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 = 2002 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=1803 AND type_rel = 3
0.0021  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.0019  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.0020  SELECT text_es as historical_text FROM leagues_text WHERE id=1317
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 = 29595 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='2002' WHERE c.parentId=1803 GROUP BY c.id ORDER BY c.order_id ASC
0.0018  SELECT type,rule FROM rules WHERE categoryId = 1803 ORDER BY type = 'tables_draw' DESC,type != 'extra' DESC, `order` ASC
0.0022  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-04-28 08:54:28' 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-28 08:54:28' 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-28 08:54:28' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0022  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=3 AND last_update > '2024-04-28 08:54:28' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0023  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 = 2002 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=0 DESC LIMIT 1
0.0022  SELECT l.id FROM leagues_webci l WHERE l.categoryId = 1803 AND l.year = 2002
0.0018  SELECT e.action, count(e.action) as total, e.player_id FROM events2002 e WHERE e.league_id IN (29595) 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 (29595) 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 = 2002
0.0021  SELECT e.action, count(e.action) as total, e.player_id FROM events2002 e WHERE e.league_id IN (29595) AND (e.action IN (4,5) ) 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 (29595) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN () ORDER BY rp.in_squad = 1 DESC
0.0021  SELECT l.id FROM leagues_webci l WHERE l.categoryId = 1803 AND l.year = 2002
0.0019  SELECT e.action, count(e.action) as total, e.player_id FROM events2002 e WHERE e.league_id IN (29595) 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 (29595) 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 = 2002
0.0020  SELECT e.action, count(e.action) as total, e.player_id FROM events2002 e WHERE e.league_id IN (29595) 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 (29595) 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 = 2002 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 = 2002 AND rp.events > 0 GROUP BY p.id ORDER BY total DESC,p.pod DESC LIMIT 20
0.0022  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=29595 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 = 29595 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 = 29595 AND esl.points > 0
0.0020  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` = 29595 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-03-29" AND c.`active`= 1 and comment_id is null and c.lang = 1 AND l.`id` = 29595
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 `calendars2002` 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` = 29595 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 `events2002` e INNER JOIN calendars2002 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 = 29595 ORDER BY total DESC LIMIT 40
0.0019  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 `events2002` e INNER JOIN calendars2002 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 = 29595 AND e.real_date > NOW() - INTERVAL 1 MONTH ORDER BY e.real_date DESC LIMIT 30
0.0021  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 `tables2002` 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 = 29595 AND t.round = 7 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0025  SELECT *,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables2002` 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 = 29595 AND t.round = 9 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0025  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 = 29595 ORDER BY c.shedule ASC, fcoef DESC LIMIT 5
0.0025  SELECT data1, data2 FROM services_tags WHERE categoryId=1803
0.0025  SELECT l.year,l.group_code FROM leagues_besoccer l WHERE l.categoryId = 1803 AND l.group_code = 1 ORDER BY l.year DESC
0.0025  SELECT l.year,l.group_code FROM leagues_besoccer l WHERE l.categoryId = 1803 AND l.year = 2002 ORDER BY l.group_code ASC
0.0025  SELECT group_code, extraName from `leagues` WHERE categoryId=1803 AND year=2002