4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Ver jornada
Jornada 1
25 Abr 23 Papakura CityPapakura 3 - 2 Gisborne ThistleGisborne ...
22 Abr 23 Matamata SwiftsMatamata 0 - 2 PapatoetoePapatoetoe ...
22 Abr 23 Bucklands BeachBucklands 7 - 0 WarkworthWarkworth ...
22 Abr 23 Glen Eden UnitedGlen Eden. 1 - 5 Colo BoysColo Boys ...
22 Abr 23 South Auckland RangersSouth 4 - 0 NgongotahaNgongotaha ...
22 Abr 23 Te Puke UnitedPuke United 5 - 1 University of Auckland FCUniversity ...
22 Abr 23 Bohemian CelticBohemian 2 - 1 WhangareiWhangarei ...
25 Abr 23 Te Atatu AFCAtatu 13 - 0 Mangere UnitedMangere ...
22 Abr 23 PukekohePukekohe 1 - 2 WaipunaWaipuna ...
22 Abr 23 CambridgeCambridge 4 - 2 Sperm WhalesSperm ...
25 Abr 23 Central UnitedCentral 2 - 8 Waitemata AFCWaitemata ...
25 Abr 23 PapamoaPapamoa 2 - 3 Northern United SCNorthern ...
25 Abr 23 Rapa NuiRapa Nui 3 - 1 West Hamilton United West ...
22 Abr 23 Plains RangersPlains 0 - 2 TaupoTaupo ...
22 Abr 23 Peringa UnitedPeringa 3 - 4 New Plymouth BHSPlymouth ...
22 Abr 23 New Plymouth RangersPlymouth 3 - 4 FC WesternFC Western ...
25 Abr 23 Lower Hutt CityLower Hutt 4 - 0 Brooklyn Northern UnitedBrooklyn ...
25 Abr 23 Kapiti Coast UnitedKapiti 1 - 0 Greytown FCGreytown ...
25 Abr 23 Victoria UniversityVictoria 1 - 2 WainuiomataWainuiomata ...
25 Abr 23 Wellington UnitedWellington 4 - 5 SeatounSeatoun ...
25 Abr 23 Upper Hutt CityUpper Hutt 11 - 2 Stokes Valley Stokes ...
25 Abr 23 Island Bay UnitedIsland 6 - 1 Wellington MaristWellington ...
25 Abr 23 PaekakarikiPaekakariki 3 - 2 NaenaeNaenae ...
25 Abr 23 NelsonNelson 5 - 2 Golden Bay AFCGolden ...
22 Abr 23 Central SCCentral SC 6 - 0 WakefieldWakefield ...
22 Abr 23 Western AFCWestern 4 - 5 Parklands UnitedParklands ...
22 Abr 23 St Albans ShirleyAlbans 1 - 6 Waimakariri UnitedWaimakariri ...
22 Abr 23 Gore WanderersGore 1 - 3 Grants BraesGrants ...
25 Abr 23 AFC Bohemian CelticBohemian 3 - 1 OtorohangaOtorohanga ...
Ver jornada
Jornada 2
13 May 23 Northern RoversNorthern 11 - 0 Colo BoysColo Boys ...
13 May 23 OtumoetaiOtumoetai 4 - 2 Bohemian CelticBohemian ...
13 May 23 South Auckland RangersSouth 3 - 2 OratiaOratia ...
13 May 23 East Coast BaysEast Coast 13 - 1 Rapa NuiRapa Nui ...
13 May 23 Mt Albert PonsonbyAlbert 1 - 3 Ngaruawahia UnitedNgaruawahia ...
13 May 23 Beachlands MaraetaiBeachlands 0 - 1 Albany UnitedAlbany ...
13 May 23 NavyNavy 0 - 8 Fencibles UnitedFencibles ...
13 May 23 Bucklands BeachBucklands 9 - 0 WaipunaWaipuna ...
13 May 23 CambridgeCambridge 1 - 3 Franklin UnitedFranklin ...
13 May 23 EllerslieEllerslie 5 - 1 NorthlandNorthland ...
13 May 23 PapatoetoePapatoetoe 1 - 5 Waikato UnicolWaikato ...
13 May 23 Hibiscus CoastHibiscus 2 - 3 Waitemata AFCWaitemata ...
13 May 23 North ShoreNorth Shore 3 - 0 Te Atatu AFCAtatu ...
13 May 23 Te AwamutuTe Awamutu 4 - 3 TaupoTaupo ...
13 May 23 Claudelands RoversClaudelands 4 - 1 Te Puke UnitedPuke United ...
13 May 23 Kapiti Coast UnitedKapiti 3 - 0 Lower Hutt CityLower Hutt ...
13 May 23 PaekakarikiPaekakariki 0 - 10 Island Bay UnitedIsland ...
13 May 23 Massey UniversityMassey 1 - 3 Napier MaristNapier ...
13 May 23 New Plymouth BHSPlymouth 2 - 1 MoturoaMoturoa ...
14 May 23 Central SCCentral SC 0 - 10 Nelson SuburbsNelson ...
13 May 23 MotuekaMotueka 2 - 1 NelsonNelson ...
13 May 23 FC WesternFC Western 2 - 0 Palmerston North MaristPalmerston ...
13 May 23 Cashmere TechnicalCashmere 1 - 0 Selwyn UnitedSelwyn ...
12 May 23 Christchurch UnitedChristchurc 9 - 0 Parklands UnitedParklands ...
14 May 23 Coastal SpiritCoastal 5 - 1 Burwood AFCBurwood ...
13 May 23 Nomads UtdNomads Utd 1 - 2 Ferrymead BaysFerrymead ...
13 May 23 Universities AFCUniversitie 3 - 2 Waimakariri UnitedWaimakariri ...
13 May 23 Halswell United FCHalswell 1 - 2 Twenty 11Twenty 11 ...
13 May 23 ThistleThistle 4 - 1 Grants BraesGrants ...
13 May 23 Queenstown AFCQueenstown 1 - 3 WanakaWanaka ...
13 May 23 MosgielMosgiel 7 - 2 Northern HeartsNorthern ...
13 May 23 Northern AFCNorthern 1 - 2 Roslyn WakariRoslyn ...
13 May 23 West AucklandWest 2 - 2 Papakura CityPapakura ...
13 May 23 Upper Hutt CityUpper Hutt 1 - 3 TAWATAWA ...
13 May 23 Northern United SCNorthern 1 - 3 MetroMetro ...
14 May 23 AFC Bohemian CelticBohemian 0 - 9 TaurangaTauranga ...
14 May 23 WainuiomataWainuiomata 3 - 1 SeatounSeatoun ...
Ver jornada
Jornada 3
03 Jun 23 New Plymouth BHSPlymouth 1 - 4 FC WesternFC Western ...
03 Jun 23 Northern RoversNorthern 0 - 1 Fencibles UnitedFencibles ...
03 Jun 23 South Auckland RangersSouth 2 - 1 North ShoreNorth Shore ...
03 Jun 23 Napier MaristNapier 0 - 1 North Wellington AFCNorth ...
02 Jun 23 MotuekaMotueka 0 - 9 Nelson SuburbsNelson ...
03 Jun 23 Wellington OlympicWellington 9 - 3 WainuiomataWainuiomata ...
03 Jun 23 Queens ParkQueens Park 0 - 1 Green IslandGreen ...
03 Jun 23 WanakaWanaka 1 - 0 DunedinDunedin ...
03 Jun 23 Coastal SpiritCoastal 2 - 4 Cashmere TechnicalCashmere ...
02 Jun 23 Ferrymead BaysFerrymead 2 - 1 Twenty 11Twenty 11 4
03 Jun 23 TAWATAWA 0 - 2 Waterside KaroriWaterside ...
03 Jun 23 ThistleThistle 0 - 5 Roslyn WakariRoslyn ...
05 Jun 23 Universities AFCUniversitie 1 - 3 Christchurch UnitedChristchurc ...
03 Jun 23 MosgielMosgiel 0 - 4 Otago UniversityOtago ...
03 Jun 23 Onehunga MangereOnehunga 4 - 0 Te AwamutuTe Awamutu ...
03 Jun 23 MiramarMiramar 4 - 4 Stop OutStop Out ...
05 Jun 23 Kapiti Coast UnitedKapiti 0 - 4 Western SuburbsWestern 1
03 Jun 23 PetonePetone 2 - 1 Whanganui AthleticWhanganui ...
04 Jun 23 Napier City RoversNapier City 4 - 2 Island Bay UnitedIsland ...
05 Jun 23 Auckland UnitedAuckland 0 - 2 Auckland CityAuckland ...
05 Jun 23 TakapunaTakapuna 2 - 0 Waikato UnicolWaikato ...
05 Jun 23 East Coast BaysEast Coast 1 - 2 Western SpringsWestern ...
05 Jun 23 Franklin UnitedFranklin 2 - 1 Waitemata AFCWaitemata ...
10 Jun 23 TaurangaTauranga 6 - 0 Manukau UnitedManukau ...
05 Jun 23 Claudelands RoversClaudelands 2 - 4 Bucklands BeachBucklands ...
05 Jun 23 Hamilton WanderersHamilton 4 - 1 EllerslieEllerslie ...
05 Jun 23 Ngaruawahia UnitedNgaruawahia 6 - 4 Albany UnitedAlbany ...
05 Jun 23 OtumoetaiOtumoetai 1 - 7 Melville UnitedMelville ...
05 Jun 23 ManurewaManurewa 0 - 1 Eastern Suburbs AFCEastern ...
05 Jun 23 Birkenhead UnitedBirkenhead 5 - 1 Waiheke UnitedWaiheke ...
05 Jun 23 Bay OlympicOlympic 0 - 1 West Coast RangersWest Coast ...
05 Jun 23 MetroMetro 0 - 2 West AucklandWest ...
Ver jornada
Jornada 4
17 Jun 23 PetonePetone 3 - 0 FC WesternFC Western ...
17 Jun 23 TakapunaTakapuna 0 - 1 Melville UnitedMelville ...
16 Jun 23 Ferrymead BaysFerrymead 0 - 1 Christchurch UnitedChristchurc ...
17 Jun 23 WanakaWanaka 2 - 2 Green IslandGreen ...
17 Jun 23 Onehunga MangereOnehunga 1 - 4 Ngaruawahia UnitedNgaruawahia ...
17 Jun 23 Wellington OlympicWellington 3 - 2 North Wellington AFCNorth ...
17 Jun 23 Birkenhead UnitedBirkenhead 3 - 1 Franklin UnitedFranklin ...
17 Jun 23 Waterside KaroriWaterside 1 - 0 Western SuburbsWestern ...
18 Jun 23 Nelson SuburbsNelson 0 - 1 Cashmere TechnicalCashmere ...
17 Jun 23 Roslyn WakariRoslyn 1 - 0 Otago UniversityOtago ...
17 Jun 23 South Auckland RangersSouth 0 - 4 Western SpringsWestern ...
17 Jun 23 Fencibles UnitedFencibles 4 - 1 West AucklandWest ...
17 Jun 23 Auckland CityAuckland 9 - 0 Bucklands BeachBucklands ...
17 Jun 23 West Coast RangersWest Coast 0 - 4 Hamilton WanderersHamilton ...
18 Jun 23 Napier City RoversNapier City 8 - 2 Stop OutStop Out ...
24 Jun 23 TaurangaTauranga 0 - 2 Eastern Suburbs AFCEastern ...
Ver jornada
Jornada 5
08 Jul 23 Western SpringsWestern 3 - 2 Auckland CityAuckland 2
08 Jul 23 Fencibles UnitedFencibles 0 - 2 Melville UnitedMelville ...
09 Jul 23 Hamilton WanderersHamilton 2 - 2 Ngaruawahia UnitedNgaruawahia ...
09 Jul 23 Napier City RoversNapier City 0 - 3 Waterside KaroriWaterside ...
08 Jul 23 PetonePetone 0 - 5 Wellington OlympicWellington ...
09 Jul 23 Cashmere TechnicalCashmere 0 - 3 Christchurch UnitedChristchurc ...
08 Jul 23 Roslyn WakariRoslyn 5 - 2 WanakaWanaka ...
09 Jul 23 Birkenhead UnitedBirkenhead 1 - 2 Eastern Suburbs AFCEastern 1
Ver jornada
Jornada 6
29 Jul 23 Melville UnitedMelville 1 - 0 Western SpringsWestern ...
29 Jul 23 Hamilton WanderersHamilton 0 - 3 Christchurch UnitedChristchurc ...
29 Jul 23 Roslyn WakariRoslyn 2 - 5 Waterside KaroriWaterside ...
29 Jul 23 Wellington OlympicWellington 2 - 3 Eastern Suburbs AFCEastern ...
Ver jornada
Jornada 7
19 Ago 23 Christchurch UnitedChristchurc 2 - 1 Eastern Suburbs AFCEastern ...
19 Ago 23 Melville UnitedMelville 3 - 1 Waterside KaroriWaterside ...
Ver jornada
Jornada 8
10 Sep 23 Christchurch UnitedChristchurc 2 - 2 Melville UnitedMelville 3

  USO DE MEMORIA  
5,122,432 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0020
Controller Execution Time ( Home / Category )  0.3149
Total Execution Time  0.3170
  CADENA URL  
/copa_chatham2023/grupo0/calendario
  GET DATOS  
$_GET['/copa_chatham2023/grupo0/calendario']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (18)  
0.0105  SELECT type FROM routes WHERE alias = 'copa_chatham2023'
0.0213  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 = 2023 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=0 DESC LIMIT 1
0.0105  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=1803 AND type_rel = 3
0.0106  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.0106  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.0105  SELECT id,name,alias,stepParent FROM categories WHERE parentId=1803 ORDER BY order_id ASC
0.0112  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 = 71462 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0116  SELECT 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, dt1.stadium as stadium_name FROM calendars2023 c INNER JOIN datateams dt1 ON dt1.id = c.datateam1 INNER JOIN datateams dt2 ON dt2.id = c.datateam2 WHERE c.league_id = 71462 ORDER BY round ASC
0.0107  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-04-28 23:46:20' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0105  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=2 AND last_update > '2024-04-28 23:46:20' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0106  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=4 AND last_update > '2024-04-28 23:46:20' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0106  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=3 AND last_update > '2024-04-28 23:46:20' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0109  SELECT l.id FROM leagues_webci l WHERE l.categoryId = 1803 AND l.year = 2023
0.0110  SELECT e.action, count(e.action) as total, e.player_id FROM events2023 e WHERE e.league_id IN (71462) AND (e.action = 1 or e.action = 2 or e.action = 11 or e.action = 12 or e.action = 13) GROUP BY e.player_id ORDER BY total DESC, e.player_id ASC LIMIT 10
0.0112  SELECT l.id FROM leagues_webci l WHERE l.categoryId = 1803 AND l.year = 2023
0.0112  SELECT e.action, count(e.action) as total, e.player_id FROM events2023 e WHERE e.league_id IN (71462) AND (e.action = 4 or e.action = 5) GROUP BY e.player_id ORDER BY total DESC, e.player_id ASC LIMIT 10
0.0114  SELECT l.id FROM leagues_webci l WHERE l.categoryId = 1803 AND l.year = 2023
0.0109  SELECT e.action, count(e.action) as total, e.player_id FROM events2023 e WHERE e.league_id IN (71462) AND (e.action = 3 or e.action = 4) GROUP BY e.player_id ORDER BY total DESC, e.player_id ASC LIMIT 10