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: 
[Apr 25] 
Auckland GS          0-2  Bay Olympic 
Birkenhead United    2-0  Tikipunga 
Bohemian Celtic      1-2  Papakura City [aet] 
Cambridge            3-4  Greerton Rovers 
Central Brown        1-2  Warkworth 
Cobras Te Aroha      1-3  Rotorua City 
FC Whangarei         1-4  Forrest Hill-Milford United 
MacLeans College     3-1  Unitech 
Manurewa             2-1  NZ Celtic Supporters 
Mt. Albert GS        4-0  Zamantix Albion Rovers  
Onehunga Sports      7-0  West Auckland 
Oratia United       11-0  Otahuhu United 
Otorohanga           0-6  Claudelands Rovers 
Papatoetoe           wbd  St. Peter's Coll 
Pukekohe             1-1  Dispensary Bar [aet, 4-1 pen] 
St. Kentigern Coll   1-5  Western Springs 
St. Paul's Coll      2-1  Foss United 
Sth Auckland Rangers 0-1  Mangere United 
Te Atatu             4-0  Hibiscus Coast 
Te Awamutu           2-1  West Hamilton 
Waikato Unicol       2-0  Hamilton BHS 
Waiuku               2-0  Ngaruawahia United 
Westlake BHS         4-3  Norwest United
[Apr 29]
Navy                 bt   Greenhithe     

Central: 
[Apr 25] 
Woodleigh            3-2  Naenae 
Eastbourne           1-5  Palmerston Nth BHS 
Stokes Valley        0-1  Waikanae 
Takaro               1-2  Gisborne Thistle 
Maycenvale           2-4  Gisborne Marist 

Southern: 
[Apr 16] 
Nelson United        5-1  Blenheim Valley 
 [Darren Cunningham (4), ? - ?] 
Ferrymead Bays       1-2  Kaiapoi Town 
 [? - Keryn Rowe, Own Goal]
[Apr 19]
Christchurch United  3-2  Christchurch Rangers
 [? - Ged Killick, Andy Steel] 
Marlborough United   4-2  Canterbury University 
Melchester Rovers    2-3  HHH United 
Nelson United        5-1  Blenheim Valley 
New Brighton         1-2  Christchurch Tech [aet] 
Nomads United        1-4  Halswell United 
Rangiora             1-2  Avon United 
Western              8-1  Mid-Canterbury United 


Round 1
-------

Northern:
[May 5]
Albany United        0-4  Takapuna City
Bay Olympic          2-1  Onehunga Sports
Birkenhead United    5-0  Navy
Claudelands Rovers   1-5  North Shore United
East Coast Bays      1-3  Glenfield Rovers
Eastern Suburbs      3-2  Waitemata City
Fencibles United     6-0  Westlake BHS
Hamilton Wanderers  12-0  Drury United
Lynn-Avon United     0-3  Manurewa
Macleans College     0-13 Ellerslie
Mt Albert GS         7-0  Pukekohe
Mt Albert-Ponsonby   4-3  Huntly Thistle [aet]
Onehunga-Mangere Utd 1-1  Three Kings United [aet, 3-1 pen]
Papakura City        1-2  Mangere United
Papatoetoe           2-1  Warkworth
Rotorua City         0-1  Greerton Rovers
St Paul's Coll       1-5  Te Atatu
Taupo                2-1  Manukau City
Te Awamutu           1-1  Oratia United [aet, 3-4 pen]
Waiuku               0-9  Forrest Hill-Milford United
Western Springs      2-1  Waikato Unicol
Whakatane Town       0-1  Melville United 
 

Central:
[May 5]
Brooklyn Northern U  6-1  Gisborne Thistle
Kapiti Hearts        0-2  Tawa
Lower Hutt City      8-0  Palmerston North BHS
Moturoa              2-1  Wainuiomata [aet]
Palmerston N Marist  0-5  Island Bay United
Petone               2-0  Seatoun
Upper Hutt City      6-1  Waikanae
Wairarapa United     1-2  Woodleigh
Wanganui Athletic    3-0  Taradale
Waterside Karori     4-1  North Wellington
Wellington Marist    3-2  Havelock North Wanderers
Wellington United   14-1  Gisborne Marist
Western Suburbs      7-1  Massey University
[May 6]
Gisborne City        0-3  Wellington Olympic
 [Simon George 2, Tony Meinan]

Southern:
[May 5]
Avon United          1-0   Kaiapoi Town
 [Wade Wilson]
Christchurch Utd     7-1   Christchurch Technical
 [Tim Wilson 3, Oliver Simons 2, Danny Attwell, Paul Davies - Sam Thompson] 
Green Island         4-0   Northern
 [S Danielson, D Milton, K McFadgen 2]
HHH United           2-1   Roslyn Wakari
 [Z Hall, D Lambray - I Sawyer]
Nelson United        0-1   Marlborough United
 [Birt Vlug (pen)]
Otago University     2-4   Caversham
 [C Malcolm, H Laird - R Fleming, B Scott, A Coburn, H Quin]
Waihopai             3-2   Queenstown
 [B de Reuter 3 - S Henderson, T Reid]
Western              3-1   Halswell United
 [Andy Daffin 2, Ian Bell - Keith Purcell]


Round 2
-------
[May 26/27]

Northern:
Eastern Suburbs      5-0   Manurewa 
Ellerslie            6-1   Te Atatu 
Forrest Hill-Milford 1-1   Melville United  [aet, 3-4 pen] 
Glenfield Rovers     4-0   Fencibles United 
Greerton Rovers      0-5   Bay Olympic 
Mangere United       bt    Onehunga Mangere 
Mt Albert GS         4-2   Western Springs 
Mt Albert-Ponsonby   1-2   Birkenhead United 
North Shore United   2-1   Oratia United 
Papatoetoe           lt    Taupo 
Takapuna             5-0   Hamilton Wanderers 

Central:
Brooklyn Northern U  1-2   Wellington United 
Lower Hutt City      4-1   Island Bay United 
Petone               0-0   Waterside-Karori [aet, 5-4 pen] 
Upper Hutt City      3-4   Western Suburbs 
Wellington Marist    0-2   Tawa 
Wellington Olympic   3-2   Moturoa 
Woodleigh            1-3   Wanganui Athletic 

Southern:
Christchurch United  0-0   Western [aet, 2-4 pen]
Green Island         2-6   Caversham 
Marlborough United   5-2   Avon United 
Waihopai             3-1   HHH United


Round 3
-------
[Jun 9/10]

Northern:
Bay Olympic          2-3   Central United
Eastern Suburbs      4-1   Metro
Ellerslie            0-1   University-Mt Wellington
Glenfield Rovers     1-2   Waitakere City
Mangere United       0-1   Mt Albert GS
North Shore United   8-1   Birkenhead United
Taupo                4-3   Takapuna City
Tauranga City United 1-0   Melville United

Central:
Western Suburbs      1-2   Tawa
Lower Hutt City      2-0   Wellington United
Petone               0-4   Miramar Rangers
Manawatu AFC         2-1   Wellington Olympic
Napier City Rovers   1-0   Wanganui Athletic
 
Southern:
Caversham            0-2   Western
 [Eugene Archer 39, Neil Murphy 75]
Christchurch City    3-1   Marlborough United
 [Brent Fisher 2, Ben Sigmund - Birt Vlug]
Dunedin Technical    5-0   Waihopai


Round 4
-------

Northern:

[Jun 30]
Eastern Suburbs      4-1   Taupo
 [Stuart Bola, John Mills, Andrew Webber 2 - Alan Lamb]
[Jul 1]
Tauranga City United 0-3   North Shore United
 [J McKenna, R Ward 2]
Uni-Mt  Wellington   3-0   Mt Albert GS
 [P Bunbury 2, H McCormack]
[Jul 8]
Central United       2-0   Waitakere City
 [Miro Major 78, 84pen]

Central/Southern:

[Jun 30]
Tawa                 0-1   Manawatu AFC
 [J Seales]
Western              2-3   Dunedin Technical
 [Ian Bell 45, Neil Murphy 56 - Aaron Burgess 10, Phil Kelly 34, 55; 
  sent-off: Aaron Burgess 45 (DnT); att: 350]
[Jul 1]
Lower Hutt City      1-2   Napier City Rovers
 [M Foster - M Akers, S Pilcher]
Christchurch City    5-4   Miramar Rangers [asdet]
 [B Sigmund 6, B Fisher 54, 85, A Letts 90+, J Duncan ~115 - G Brown 18, 73, N Longley 31, T Butterfield 81pen]


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

[Jul 28]
Eastern Suburbs      2-1   Dunedin Technical [asdet]
 [Mark Webber 22, Andrew Webber 95pen - Stewart Bola (og) 88]
[Jul 29]
North Shore United   2-3   Christchurch City
 [Steve Calliman 54, Julian Sills 77 - Micheal Sands 12, 88, Ben Hughes 47] 
Central United       1-0   Napier City Rovers
 [Miro Major 62pen] 
Uni-Mt Wellington    2-0   Manawatu AFC
 [James Patterson 7, Paul Bunbury 82pen]
 

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

[Sep 2]
Central United       3-1   Eastern Suburbs
 [Campbell Banks 9, 70, Daniel Aliaga 90 - Stuart Bola 71]
Central: Nicholson; Ridenton (booked 36, 42 - sent-off), Thompson (booked 12), 
Uhlmann; Hawke, Hill, Vuksich, Aliaga (Major 90), Stick; Banks (Koprivcic 81), 
Eie (Greenhalgh 83) 
Suburbs: Willcox; Stiles, Dickenson, Ellis; M Webber, Knowles (booked 45) 
(McKenzie 74), Ruffell (booked 41) (O'Sullivan 83), Wilson, Smetton (Mills 90); 
A Webber, Bola (booked 18) 
Referee: Neil Fox

Uni-Mt Wellington    2-0   Christchurch City
 [Paul Temple 22, Sanni Poalo 86]
Uni-Mt: Eaddy; Thou, Brown (booked 50), Pearce, Patterson; Temple, Bunbury, 
Ashton, Medhurst; McCormack (Poalo 54), Kenyon
Christchurch: Buchanan; Letts, McLaughlin, Hall (booked 72); Lilley (Tregenza 85), 
Halligan, Sigmund, Duncan, Solotti (Hughes 69); Hutchinson, Sands (sent-off 66)
Referee: Brian Precious

Final [15 Sep, 3:45 pm] 
-----
North Harbour Stadium, Albany, Auckland 
Central United       3-3   Uni-Mt Wellington [aet, 4-5 pen]
 [Daniel Aliaga 30, Campbell Banks 67, 73 - Travis Medhurst 8, Heath McCormack 46, 74]   
Pens:0-1 Bunbury, 1-1 Major, 1-2 McCormack (via the post), 2-2 Carmody, 
2-3 Pearce, 3-3 Aliaga, 3-4 Roberts, 4-4 Banks, 4-5 Waetford (retaken; 'keeper saved 
the penalty but moved prior to the kick being taken), missed - Greenhalgh  
 
Jack Batty Trophy (man-of-the-match): Bunbury (Uni-Mt)

Central: Nicholson; Uhlmann, Thompson (booked 23), Stick; Greenhalgh, Vuksich 
(Major 59), Hill, Aliaga (booked 66), Hawke (Koprivcic 66); Banks, Eie (Carmody 104) 
Uni-Mt: Eaddy; Thou, Brown (Waetford 77), Pearce (booked 89), Paterson; Temple (Polo, 95), 
Ashton (Roberts 70), Bunbury (booked 86), Medhurst (booked 112); Kenyon, McCormack 
Referee: Steve Sargent
Attendance: ~2 000


Author: Andre Zlotkowski (nzfooty@hotmail.com) 
Last updated: 15 Jun 2005

(C) Copyright Andre Zlotkowski and RSSSF 2001/05


  USO DE MEMORIA  
4,205,456 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0020
Controller Execution Time ( Home / Category )  0.6288
Total Execution Time  0.6308
  CADENA URL  
/copa_chatham2001
  GET DATOS  
$_GET['/copa_chatham2001']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (41)  
0.0124  SELECT type FROM routes WHERE alias = 'copa_chatham2001'
0.0252  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 = 2001 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=1 DESC LIMIT 1
0.0125  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=1803 AND type_rel = 3
0.0130  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.0129  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.0130  SELECT text_es as historical_text FROM leagues_text WHERE id=1318
0.0128  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 = 29596 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0129  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='2001' WHERE c.parentId=1803 GROUP BY c.id ORDER BY c.order_id ASC
0.0127  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-04-28 13:57:02' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0127  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=2 AND last_update > '2024-04-28 13:57:02' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0127  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=4 AND last_update > '2024-04-28 13:57:02' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0127  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=3 AND last_update > '2024-04-28 13:57:02' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0133  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 = 2001 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=0 DESC LIMIT 1
0.0138  SELECT l.id FROM leagues_webci l WHERE l.categoryId = 1803 AND l.year = 2001
0.0126  SELECT e.action, count(e.action) as total, e.player_id FROM events2001 e WHERE e.league_id IN (29596) 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.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 (29596) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN () ORDER BY rp.in_squad = 1 DESC
0.0129  SELECT l.id FROM leagues_webci l WHERE l.categoryId = 1803 AND l.year = 2001
0.0139  SELECT e.action, count(e.action) as total, e.player_id FROM events2001 e WHERE e.league_id IN (29596) AND (e.action IN (4,5) ) GROUP BY e.player_id ORDER BY total DESC, e.player_id ASC LIMIT 20
0.0130  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 (29596) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN () ORDER BY rp.in_squad = 1 DESC
0.0138  SELECT l.id FROM leagues_webci l WHERE l.categoryId = 1803 AND l.year = 2001
0.0125  SELECT e.action, count(e.action) as total, e.player_id FROM events2001 e WHERE e.league_id IN (29596) AND (e.action IN (3,4) ) 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 (29596) 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 = 2001
0.0130  SELECT e.action, count(e.action) as total, e.player_id FROM events2001 e WHERE e.league_id IN (29596) 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 (29596) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN () ORDER BY rp.in_squad = 1 DESC
0.0125  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 = 2001 AND rp.lineup > 0 GROUP BY p.id ORDER BY total DESC,p.pod DESC LIMIT 20
0.0124  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 = 2001 AND rp.events > 0 GROUP BY p.id ORDER BY total DESC,p.pod DESC LIMIT 20
0.0128  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=29596 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 = 29596 AND esl.points > 0 ORDER BY esl.points DESC LIMIT 3
0.0128  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 = 29596 AND esl.points > 0
0.0126  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` = 29596 ORDER BY creation_date DESC LIMIT 0, 10
0.0133  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` = 29596
0.0126  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 `calendars2001` 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` = 29596 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 `events2001` e INNER JOIN calendars2001 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 = 29596 ORDER BY total DESC LIMIT 40
0.0128  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 `events2001` e INNER JOIN calendars2001 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 = 29596 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 `tables2001` 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 = 29596 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 `tables2001` 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 = 29596 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 = 29596 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 = 2001 ORDER BY l.group_code ASC
0.0129  SELECT group_code, extraName from `leagues` WHERE categoryId=1803 AND year=2001