0001: SET sql_mode = ? 0.0003s

0002: SHOW DATABASES LIKE 'psnorthern' 0.0006s

0003: SELECT DISTINCT "SiteConfig"."ClassName", "SiteConfig"."LastEdited", "SiteConfig"."Created", "SiteConfig"."SimpleCSPEnable", "SiteConfig"."SimpleCSPNonceScriptEnable", "SiteConfig"."SimpleCSPNonceStyleEnable", "SiteConfig"."MFARequired", "SiteConfig"."MFAGracePeriodExpires", "SiteConfig"."FLO2CASH_TOKEN", "SiteConfig"."FLO2CASH_URL", "SiteConfig"."FLO2CASH_MODE", "SiteConfig"."FLO2CASH_MERCHANT_ID", "SiteConfig"."WINDCAVE_USERNAME", "SiteConfig"."WINDCAVE_API_KEY", "SiteConfig"."HeaderMenuButtonMobileTheme", "SiteConfig"."FooterLogoURL", "SiteConfig"."FooterDisclaimer", "SiteConfig"."AdditionalFooterLogoLink", "SiteConfig"."AdditionalFooterHTML", "SiteConfig"."SecondButtonTheme", "SiteConfig"."SecondButtonSize", "SiteConfig"."ShowChatButton", "SiteConfig"."ShowQuickExitButton", "SiteConfig"."ChatButtonCode", "SiteConfig"."NewsletterBlocks", "SiteConfig"."ReviewsApiKey", "SiteConfig"."MapStyle", "SiteConfig"."MapApiKey", "SiteConfig"."AnnouncementBannerEnable", "SiteConfig"."AnnouncementBannerTextColor", "SiteConfig"."AnnouncementBannerBackgroundColor", "SiteConfig"."AnnouncementBannerMessage", "SiteConfig"."AnnouncementBannerDisplayClose", "SiteConfig"."AnnouncementBannerAlwaysShowForAdmin", "SiteConfig"."AnnouncementBannerForceSave", "SiteConfig"."AnnouncementBannerResetTime", "SiteConfig"."IsShapeHiddenOnMobile", "SiteConfig"."HomePageSliderShapeCode", "SiteConfig"."PrimaryFonts", "SiteConfig"."SecondaryFonts", "SiteConfig"."GoogleTagManagerNumber", "SiteConfig"."GoogleAnalyticsUA", "SiteConfig"."GooglePlaceId", "SiteConfig"."FacebookAppId", "SiteConfig"."DefaultOpenGraphDescription", "SiteConfig"."SocialFacebookLink", "SiteConfig"."SocialInstagramLink", "SiteConfig"."SocialLinkedInLink", "SiteConfig"."SocialYouTube", "SiteConfig"."SocialTwitter", "SiteConfig"."SocialPinterest", "SiteConfig"."SocialVimeo", "SiteConfig"."SocialTripAdvisor", "SiteConfig"."SocialTikTok", "SiteConfig"."LogoWidth", "SiteConfig"."LogoHeight", "SiteConfig"."FooterLogoWidth", "SiteConfig"."FooterLogoHeight", "SiteConfig"."FontLinks", "SiteConfig"."BodyBackgroundColour", "SiteConfig"."PrimaryColour", "SiteConfig"."PrimaryLighterColour", "SiteConfig"."PrimaryDarkerColour", "SiteConfig"."SecondaryColour", "SiteConfig"."SecondaryLighterColour", "SiteConfig"."SecondaryDarkerColour", "SiteConfig"."TertiaryColour", "SiteConfig"."TertiaryLighterColour", "SiteConfig"."TertiaryDarkerColour", "SiteConfig"."QuaternaryColour", "SiteConfig"."QuaternaryLighterColour", "SiteConfig"."QuaternaryDarkerColour", "SiteConfig"."LinkColour", "SiteConfig"."LinkHoverColour", "SiteConfig"."LinkActiveColour", "SiteConfig"."BreadCrumbLinkColor", "SiteConfig"."BreadCrumbLinkHoverColor", "SiteConfig"."BreadCrumbLinkActiveColor", "SiteConfig"."BreadCrumbIconColor", "SiteConfig"."BodyFontColour", "SiteConfig"."PrimaryButtonFontColour", "SiteConfig"."SecondaryButtonFontColour", "SiteConfig"."TertiaryButtonFontColour", "SiteConfig"."QuaternaryButtonFontColour", "SiteConfig"."CustomCssCode", "SiteConfig"."CustomScript", "SiteConfig"."PrimaryColourName", "SiteConfig"."SecondaryColourName", "SiteConfig"."TertiaryColourName", "SiteConfig"."QuaternaryColourName", "SiteConfig"."FooterLine", "SiteConfig"."FooterText", "SiteConfig"."FooterBackgroundColor", "SiteConfig"."FooterBottomBackgroundColor", "SiteConfig"."FooterTextColor", "SiteConfig"."FooterLinkColor", "SiteConfig"."FooterLinkActiveColor", "SiteConfig"."FooterMintText", "SiteConfig"."FooterMintLink", "SiteConfig"."FooterBottomTextColor", "SiteConfig"."FooterIconColor", "SiteConfig"."DefaultPricingItemColor", "SiteConfig"."FirstPricingItemColor", "SiteConfig"."SecondPricingItemColor", "SiteConfig"."ThirdPricingItemColor", "SiteConfig"."CaptchaSecretKey", "SiteConfig"."ContentWidth", "SiteConfig"."TitleWidth", "SiteConfig"."EnableCategories", "SiteConfig"."EnableImagesCategories", "SiteConfig"."CategorySidebarTitle", "SiteConfig"."PostName", "SiteConfig"."PostsName", "SiteConfig"."NewsletterNotificationTo", "SiteConfig"."NewsletterThanksMessage", "SiteConfig"."NewsletterListId", "SiteConfig"."IsHeaderSpacerEnabled", "SiteConfig"."HeaderHeight", "SiteConfig"."MobileHeaderHeight", "SiteConfig"."DDLMenuIcon", "SiteConfig"."IsHeaderShadowEnabled", "SiteConfig"."HeaderBackgroundColor", "SiteConfig"."HeaderBackgroundColorTransparency", "SiteConfig"."HeaderActiveBackgroundColor", "SiteConfig"."HeaderActiveBackgroundColorTransparency", "SiteConfig"."HeaderBackgroundColorScrolled", "SiteConfig"."HeaderBackgroundColorScrolledTransparency", "SiteConfig"."HeaderChildMenuBackgroundColor", "SiteConfig"."HeaderChildMenuActiveBackgroundColor", "SiteConfig"."HeaderLinkColor", "SiteConfig"."HeaderLinkActiveColor", "SiteConfig"."HeaderChildLinkColor", "SiteConfig"."HeaderChildLinkActiveColor", "SiteConfig"."HeaderMobileBackgroundColor", "SiteConfig"."HeaderMobileLinkColor", "SiteConfig"."HeaderMobileLinkActiveColor", "SiteConfig"."HeaderMobileChildMenuBorderColor", "SiteConfig"."HeaderHamburgerColor", "SiteConfig"."HeaderMenuActiveTheme", "SiteConfig"."HeaderMenuBackColor", "SiteConfig"."HeaderMenuTitleColor", "SiteConfig"."HeaderMenuUnderlineColor", "SiteConfig"."LogoWidthOnActive", "SiteConfig"."LogoHeightOnActive", "SiteConfig"."HeaderMenuButtonIconAlignment", "SiteConfig"."HeaderMenuButtonTheme", "SiteConfig"."HeaderMenuButtonSize", "SiteConfig"."Title", "SiteConfig"."Tagline", "SiteConfig"."CanViewType", "SiteConfig"."CanEditType", "SiteConfig"."CanCreateTopLevelType", "SiteConfig"."SubsiteID", "SiteConfig"."HeaderLogoID", "SiteConfig"."HeaderMenuButtonMobileID", "SiteConfig"."HeaderMenuButtonMobileIconID", "SiteConfig"."FooterMenuID", "SiteConfig"."AdditionalFooterLogoID", "SiteConfig"."SecondButtonLinkID", "SiteConfig"."AllSitesFooterLogoID", "SiteConfig"."DefaultHeroImageID", "SiteConfig"."DefaultMapMarkerID", "SiteConfig"."AnnouncementBannerBackgroundImageID", "SiteConfig"."DefaultOpenGraphImageID", "SiteConfig"."LogoID", "SiteConfig"."LogoScrolledID", "SiteConfig"."FooterLogoID", "SiteConfig"."FaviconID", "SiteConfig"."CustomStyleDataID", "SiteConfig"."HeaderMenuButtonIconID", "SiteConfig"."HeaderMenuButtonID", "SiteConfig"."ID", CASE WHEN "SiteConfig"."ClassName" IS NOT NULL THEN "SiteConfig"."ClassName" ELSE 'SilverStripe\\SiteConfig\\SiteConfig' END AS "RecordClassName" FROM "SiteConfig" LIMIT 1 0.0022s

0004: SELECT DISTINCT "SubsiteDomain"."ClassName", "SubsiteDomain"."LastEdited", "SubsiteDomain"."Created", "SubsiteDomain"."Domain", "SubsiteDomain"."Protocol", "SubsiteDomain"."IsPrimary", "SubsiteDomain"."SubsiteID", "SubsiteDomain"."ID", CASE WHEN "SubsiteDomain"."ClassName" IS NOT NULL THEN "SubsiteDomain"."ClassName" ELSE 'SilverStripe\\Subsites\\Model\\SubsiteDomain' END AS "RecordClassName" FROM "SubsiteDomain" WHERE ("SubsiteDomain"."Domain" = ?) ORDER BY "SubsiteDomain"."IsPrimary" DESC LIMIT 1 0.001s

0005: SELECT COUNT(ID) as "COUNT" FROM "SiteTree" LIMIT 1 0.0003s

0006: SELECT MAX(LastEdited) FROM "SiteTree" LIMIT 1 0.0004s

0007: SELECT MAX(LastEdited) FROM "SiteConfig" LIMIT 1 0.0002s

0008: SELECT DISTINCT "SubsiteDomain"."ClassName", "SubsiteDomain"."LastEdited", "SubsiteDomain"."Created", "SubsiteDomain"."Domain", "SubsiteDomain"."Protocol", "SubsiteDomain"."IsPrimary", "SubsiteDomain"."SubsiteID", "SubsiteDomain"."ID", CASE WHEN "SubsiteDomain"."ClassName" IS NOT NULL THEN "SubsiteDomain"."ClassName" ELSE 'SilverStripe\\Subsites\\Model\\SubsiteDomain' END AS "RecordClassName" FROM "SubsiteDomain" WHERE ("SubsiteDomain"."Domain" = ?) ORDER BY "SubsiteDomain"."IsPrimary" DESC LIMIT 1 0.0004s

0009: SELECT DISTINCT count(DISTINCT "SubsiteDomain"."ID") AS "Count" FROM "SubsiteDomain" INNER JOIN "Subsite" ON "Subsite"."ID" = "SubsiteDomain"."SubsiteID" AND "Subsite"."IsPublic"=1 WHERE ('psn.nzduat.co.nz' LIKE replace("SubsiteDomain"."Domain",'*','%')) 0.0004s

0010: SELECT DISTINCT "Subsite"."ClassName", "Subsite"."LastEdited", "Subsite"."Created", "Subsite"."DefaultSite", "Subsite"."ID", CASE WHEN "Subsite"."ClassName" IS NOT NULL THEN "Subsite"."ClassName" ELSE 'SilverStripe\\Subsites\\Model\\Subsite' END AS "RecordClassName", "Subsite"."Title" FROM "Subsite" WHERE ("Subsite"."DefaultSite" = ?) ORDER BY "Subsite"."Title" ASC LIMIT 1 0.0004s

0011: SHOW FULL FIELDS IN "SiteTree" 0.002s

0012: SHOW COLLATION LIKE 'utf8mb4_unicode_ci' 0.0007s

0013: SHOW FULL FIELDS IN "Page" 0.0028s

0014: SHOW COLLATION LIKE 'utf8mb3_general_ci' 0.0004s

0015: SHOW FULL FIELDS IN "DonatePage" 0.0011s

0016: SHOW FULL FIELDS IN "EventDetailsPage" 0.0011s

0017: SHOW FULL FIELDS IN "EventHolderPage" 0.0014s

0018: SHOW FULL FIELDS IN "EventPage" 0.0014s

0019: SHOW FULL FIELDS IN "EventRegistrationPage" 0.0012s

0020: SHOW FULL FIELDS IN "HomePage" 0.0011s

0021: SHOW FULL FIELDS IN "LocationPage" 0.001s

0022: SHOW FULL FIELDS IN "ReferralFormPage" 0.0011s

0023: SHOW FULL FIELDS IN "MD_Page_ContactPage" 0.001s

0024: SHOW FULL FIELDS IN "MD_Page_ServiceHolderPage" 0.0011s

0025: SHOW FULL FIELDS IN "ErrorPage" 0.001s

0026: SHOW FULL FIELDS IN "Blog" 0.0011s

0027: SHOW FULL FIELDS IN "BlogPost" 0.001s

0028: SHOW FULL FIELDS IN "RedirectorPage" 0.001s

0029: SHOW FULL FIELDS IN "VirtualPage" 0.0009s

0030: SHOW FULL FIELDS IN "UserDefinedForm" 0.001s

0031: SHOW FULL FIELDS IN "ContactPage" 0.0013s

0032: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", "SiteTree_Live"."ElementalSearchContent", "SiteTree_Live"."MetaTitle", "SiteTree_Live"."CanViewType", "SiteTree_Live"."CanEditType", "SiteTree_Live"."Version", "SiteTree_Live"."Title", "SiteTree_Live"."URLSegment", "SiteTree_Live"."MenuTitle", "SiteTree_Live"."Content", "SiteTree_Live"."MetaDescription", "SiteTree_Live"."ExtraMeta", "SiteTree_Live"."ShowInMenus", "SiteTree_Live"."ShowInSearch", "SiteTree_Live"."Sort", "SiteTree_Live"."HasBrokenFile", "SiteTree_Live"."HasBrokenLink", "SiteTree_Live"."ReportClass", "SiteTree_Live"."SubsiteID", "SiteTree_Live"."ParentID", "SiteTree_Live"."ID", CASE WHEN "SiteTree_Live"."ClassName" IS NOT NULL THEN "SiteTree_Live"."ClassName" ELSE 'SilverStripe\\CMS\\Model\\SiteTree' END AS "RecordClassName" FROM "SiteTree_Live" WHERE ("SiteTree_Live"."URLSegment" = ?) AND ("SiteTree_Live"."ParentID" = ?) AND ("SiteTree_Live"."SubsiteID" IN (0)) ORDER BY "SiteTree_Live"."Sort" ASC LIMIT 1 0.0007s

0033: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", "SiteTree_Live"."ElementalSearchContent", "SiteTree_Live"."MetaTitle", "SiteTree_Live"."CanViewType", "SiteTree_Live"."CanEditType", "SiteTree_Live"."Version", "SiteTree_Live"."Title", "SiteTree_Live"."URLSegment", "SiteTree_Live"."MenuTitle", "SiteTree_Live"."Content", "SiteTree_Live"."MetaDescription", "SiteTree_Live"."ExtraMeta", "SiteTree_Live"."ShowInMenus", "SiteTree_Live"."ShowInSearch", "SiteTree_Live"."Sort", "SiteTree_Live"."HasBrokenFile", "SiteTree_Live"."HasBrokenLink", "SiteTree_Live"."ReportClass", "SiteTree_Live"."SubsiteID", "SiteTree_Live"."ParentID", "SiteTree_Live"."ID", CASE WHEN "SiteTree_Live"."ClassName" IS NOT NULL THEN "SiteTree_Live"."ClassName" ELSE 'SilverStripe\\CMS\\Model\\SiteTree' END AS "RecordClassName" FROM "SiteTree_Live" WHERE ("SiteTree_Live"."ParentID" = ?) AND ("SiteTree_Live"."URLSegment" = ?) AND ("SiteTree_Live"."SubsiteID" IN (0)) ORDER BY "SiteTree_Live"."Sort" ASC LIMIT 1 0.0006s

0034: SELECT DISTINCT "SiteConfig"."ClassName", "SiteConfig"."LastEdited", "SiteConfig"."Created", "SiteConfig"."SimpleCSPEnable", "SiteConfig"."SimpleCSPNonceScriptEnable", "SiteConfig"."SimpleCSPNonceStyleEnable", "SiteConfig"."MFARequired", "SiteConfig"."MFAGracePeriodExpires", "SiteConfig"."FLO2CASH_TOKEN", "SiteConfig"."FLO2CASH_URL", "SiteConfig"."FLO2CASH_MODE", "SiteConfig"."FLO2CASH_MERCHANT_ID", "SiteConfig"."WINDCAVE_USERNAME", "SiteConfig"."WINDCAVE_API_KEY", "SiteConfig"."HeaderMenuButtonMobileTheme", "SiteConfig"."FooterLogoURL", "SiteConfig"."FooterDisclaimer", "SiteConfig"."AdditionalFooterLogoLink", "SiteConfig"."AdditionalFooterHTML", "SiteConfig"."SecondButtonTheme", "SiteConfig"."SecondButtonSize", "SiteConfig"."ShowChatButton", "SiteConfig"."ShowQuickExitButton", "SiteConfig"."ChatButtonCode", "SiteConfig"."NewsletterBlocks", "SiteConfig"."ReviewsApiKey", "SiteConfig"."MapStyle", "SiteConfig"."MapApiKey", "SiteConfig"."AnnouncementBannerEnable", "SiteConfig"."AnnouncementBannerTextColor", "SiteConfig"."AnnouncementBannerBackgroundColor", "SiteConfig"."AnnouncementBannerMessage", "SiteConfig"."AnnouncementBannerDisplayClose", "SiteConfig"."AnnouncementBannerAlwaysShowForAdmin", "SiteConfig"."AnnouncementBannerForceSave", "SiteConfig"."AnnouncementBannerResetTime", "SiteConfig"."IsShapeHiddenOnMobile", "SiteConfig"."HomePageSliderShapeCode", "SiteConfig"."PrimaryFonts", "SiteConfig"."SecondaryFonts", "SiteConfig"."GoogleTagManagerNumber", "SiteConfig"."GoogleAnalyticsUA", "SiteConfig"."GooglePlaceId", "SiteConfig"."FacebookAppId", "SiteConfig"."DefaultOpenGraphDescription", "SiteConfig"."SocialFacebookLink", "SiteConfig"."SocialInstagramLink", "SiteConfig"."SocialLinkedInLink", "SiteConfig"."SocialYouTube", "SiteConfig"."SocialTwitter", "SiteConfig"."SocialPinterest", "SiteConfig"."SocialVimeo", "SiteConfig"."SocialTripAdvisor", "SiteConfig"."SocialTikTok", "SiteConfig"."LogoWidth", "SiteConfig"."LogoHeight", "SiteConfig"."FooterLogoWidth", "SiteConfig"."FooterLogoHeight", "SiteConfig"."FontLinks", "SiteConfig"."BodyBackgroundColour", "SiteConfig"."PrimaryColour", "SiteConfig"."PrimaryLighterColour", "SiteConfig"."PrimaryDarkerColour", "SiteConfig"."SecondaryColour", "SiteConfig"."SecondaryLighterColour", "SiteConfig"."SecondaryDarkerColour", "SiteConfig"."TertiaryColour", "SiteConfig"."TertiaryLighterColour", "SiteConfig"."TertiaryDarkerColour", "SiteConfig"."QuaternaryColour", "SiteConfig"."QuaternaryLighterColour", "SiteConfig"."QuaternaryDarkerColour", "SiteConfig"."LinkColour", "SiteConfig"."LinkHoverColour", "SiteConfig"."LinkActiveColour", "SiteConfig"."BreadCrumbLinkColor", "SiteConfig"."BreadCrumbLinkHoverColor", "SiteConfig"."BreadCrumbLinkActiveColor", "SiteConfig"."BreadCrumbIconColor", "SiteConfig"."BodyFontColour", "SiteConfig"."PrimaryButtonFontColour", "SiteConfig"."SecondaryButtonFontColour", "SiteConfig"."TertiaryButtonFontColour", "SiteConfig"."QuaternaryButtonFontColour", "SiteConfig"."CustomCssCode", "SiteConfig"."CustomScript", "SiteConfig"."PrimaryColourName", "SiteConfig"."SecondaryColourName", "SiteConfig"."TertiaryColourName", "SiteConfig"."QuaternaryColourName", "SiteConfig"."FooterLine", "SiteConfig"."FooterText", "SiteConfig"."FooterBackgroundColor", "SiteConfig"."FooterBottomBackgroundColor", "SiteConfig"."FooterTextColor", "SiteConfig"."FooterLinkColor", "SiteConfig"."FooterLinkActiveColor", "SiteConfig"."FooterMintText", "SiteConfig"."FooterMintLink", "SiteConfig"."FooterBottomTextColor", "SiteConfig"."FooterIconColor", "SiteConfig"."DefaultPricingItemColor", "SiteConfig"."FirstPricingItemColor", "SiteConfig"."SecondPricingItemColor", "SiteConfig"."ThirdPricingItemColor", "SiteConfig"."CaptchaSecretKey", "SiteConfig"."ContentWidth", "SiteConfig"."TitleWidth", "SiteConfig"."EnableCategories", "SiteConfig"."EnableImagesCategories", "SiteConfig"."CategorySidebarTitle", "SiteConfig"."PostName", "SiteConfig"."PostsName", "SiteConfig"."NewsletterNotificationTo", "SiteConfig"."NewsletterThanksMessage", "SiteConfig"."NewsletterListId", "SiteConfig"."IsHeaderSpacerEnabled", "SiteConfig"."HeaderHeight", "SiteConfig"."MobileHeaderHeight", "SiteConfig"."DDLMenuIcon", "SiteConfig"."IsHeaderShadowEnabled", "SiteConfig"."HeaderBackgroundColor", "SiteConfig"."HeaderBackgroundColorTransparency", "SiteConfig"."HeaderActiveBackgroundColor", "SiteConfig"."HeaderActiveBackgroundColorTransparency", "SiteConfig"."HeaderBackgroundColorScrolled", "SiteConfig"."HeaderBackgroundColorScrolledTransparency", "SiteConfig"."HeaderChildMenuBackgroundColor", "SiteConfig"."HeaderChildMenuActiveBackgroundColor", "SiteConfig"."HeaderLinkColor", "SiteConfig"."HeaderLinkActiveColor", "SiteConfig"."HeaderChildLinkColor", "SiteConfig"."HeaderChildLinkActiveColor", "SiteConfig"."HeaderMobileBackgroundColor", "SiteConfig"."HeaderMobileLinkColor", "SiteConfig"."HeaderMobileLinkActiveColor", "SiteConfig"."HeaderMobileChildMenuBorderColor", "SiteConfig"."HeaderHamburgerColor", "SiteConfig"."HeaderMenuActiveTheme", "SiteConfig"."HeaderMenuBackColor", "SiteConfig"."HeaderMenuTitleColor", "SiteConfig"."HeaderMenuUnderlineColor", "SiteConfig"."LogoWidthOnActive", "SiteConfig"."LogoHeightOnActive", "SiteConfig"."HeaderMenuButtonIconAlignment", "SiteConfig"."HeaderMenuButtonTheme", "SiteConfig"."HeaderMenuButtonSize", "SiteConfig"."Title", "SiteConfig"."Tagline", "SiteConfig"."CanViewType", "SiteConfig"."CanEditType", "SiteConfig"."CanCreateTopLevelType", "SiteConfig"."SubsiteID", "SiteConfig"."HeaderLogoID", "SiteConfig"."HeaderMenuButtonMobileID", "SiteConfig"."HeaderMenuButtonMobileIconID", "SiteConfig"."FooterMenuID", "SiteConfig"."AdditionalFooterLogoID", "SiteConfig"."SecondButtonLinkID", "SiteConfig"."AllSitesFooterLogoID", "SiteConfig"."DefaultHeroImageID", "SiteConfig"."DefaultMapMarkerID", "SiteConfig"."AnnouncementBannerBackgroundImageID", "SiteConfig"."DefaultOpenGraphImageID", "SiteConfig"."LogoID", "SiteConfig"."LogoScrolledID", "SiteConfig"."FooterLogoID", "SiteConfig"."FaviconID", "SiteConfig"."CustomStyleDataID", "SiteConfig"."HeaderMenuButtonIconID", "SiteConfig"."HeaderMenuButtonID", "SiteConfig"."ID", CASE WHEN "SiteConfig"."ClassName" IS NOT NULL THEN "SiteConfig"."ClassName" ELSE 'SilverStripe\\SiteConfig\\SiteConfig' END AS "RecordClassName" FROM "SiteConfig" WHERE ("SiteConfig"."SubsiteID" IN (0)) LIMIT 1 0.0011s

0035: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", "SiteTree_Live"."ElementalSearchContent", "SiteTree_Live"."MetaTitle", "SiteTree_Live"."CanViewType", "SiteTree_Live"."CanEditType", "SiteTree_Live"."Version", "SiteTree_Live"."Title", "SiteTree_Live"."URLSegment", "SiteTree_Live"."MenuTitle", "SiteTree_Live"."Content", "SiteTree_Live"."MetaDescription", "SiteTree_Live"."ExtraMeta", "SiteTree_Live"."ShowInMenus", "SiteTree_Live"."ShowInSearch", "SiteTree_Live"."Sort", "SiteTree_Live"."HasBrokenFile", "SiteTree_Live"."HasBrokenLink", "SiteTree_Live"."ReportClass", "SiteTree_Live"."SubsiteID", "SiteTree_Live"."ParentID", "SiteTree_Live"."ID", CASE WHEN "SiteTree_Live"."ClassName" IS NOT NULL THEN "SiteTree_Live"."ClassName" ELSE 'SilverStripe\\CMS\\Model\\SiteTree' END AS "RecordClassName" FROM "SiteTree_Live" WHERE ("SiteTree_Live"."ID" = ?) ORDER BY "SiteTree_Live"."Sort" ASC LIMIT 1 0.0005s

0036: SELECT DISTINCT "Subsite"."ClassName", "Subsite"."LastEdited", "Subsite"."Created", "Subsite"."Title", "Subsite"."RedirectURL", "Subsite"."DefaultSite", "Subsite"."Theme", "Subsite"."Language", "Subsite"."IsPublic", "Subsite"."PageTypeBlacklist", "Subsite"."ID", CASE WHEN "Subsite"."ClassName" IS NOT NULL THEN "Subsite"."ClassName" ELSE 'SilverStripe\\Subsites\\Model\\Subsite' END AS "RecordClassName" FROM "Subsite" WHERE ("Subsite"."ID" = ?) ORDER BY "Subsite"."Title" ASC LIMIT 1 0.0003s

0037: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", "SiteTree_Live"."ElementalSearchContent", "SiteTree_Live"."MetaTitle", "SiteTree_Live"."CanViewType", "SiteTree_Live"."CanEditType", "SiteTree_Live"."Version", "SiteTree_Live"."Title", "SiteTree_Live"."URLSegment", "SiteTree_Live"."MenuTitle", "SiteTree_Live"."Content", "SiteTree_Live"."MetaDescription", "SiteTree_Live"."ExtraMeta", "SiteTree_Live"."ShowInMenus", "SiteTree_Live"."ShowInSearch", "SiteTree_Live"."Sort", "SiteTree_Live"."HasBrokenFile", "SiteTree_Live"."HasBrokenLink", "SiteTree_Live"."ReportClass", "SiteTree_Live"."SubsiteID", "SiteTree_Live"."ParentID", "SiteTree_Live"."ID", CASE WHEN "SiteTree_Live"."ClassName" IS NOT NULL THEN "SiteTree_Live"."ClassName" ELSE 'SilverStripe\\CMS\\Model\\SiteTree' END AS "RecordClassName" FROM "SiteTree_Live" WHERE ("SiteTree_Live"."ID" = ?) ORDER BY "SiteTree_Live"."Sort" ASC LIMIT 1 0.0006s

0038: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "Page_Live"."HeroContent", "Page_Live"."HeroContentPosition", "Page_Live"."ButtonSize1", "Page_Live"."ButtonSize2", "Page_Live"."HeroTitle", "Page_Live"."HeroBackgroundPosition", "Page_Live"."HeroHideBreadcrumbs", "Page_Live"."HeroHide", "Page_Live"."OverlayColor", "Page_Live"."OverlayTransparency", "Page_Live"."OpenGraphTitle", "Page_Live"."OpenGraphDescription", "Page_Live"."LDJSONSchema", "Page_Live"."SummaryDescription", "Page_Live"."IsSubMenuVisible", "Page_Live"."DisableMenuLink", "Page_Live"."LogoID", CASE WHEN "SiteTree_Live"."ClassName" IN ('Page', 'App\\Page\\CampaignPage', 'App\\Page\\DonatePage', 'App\\Page\\EventDetailsPage', 'App\\Page\\EventHolderPage', 'App\\Page\\EventPage', 'App\\Page\\EventRegistrationPage', 'HomePage', 'App\\Page\\LocationPage', 'App\\Page\\ReferralFormPage', 'App\\Page\\ReferralPage', 'App\\Page\\ServiceLandingPage', 'App\\Page\\VolunteerLandingPage', 'PlasticStudio\\Search\\SearchPage', 'MintDesign\\Page\\ContactUs\\ContactPage', 'MintDesign\\Page\\Service\\ServiceHolderPage', 'SilverStripe\\ErrorPage\\ErrorPage', 'SilverStripe\\Blog\\Model\\Blog', 'SilverStripe\\Blog\\Model\\BlogPost', 'SilverStripe\\CMS\\Model\\RedirectorPage', 'SilverStripe\\CMS\\Model\\VirtualPage', 'SilverStripe\\UserForms\\Model\\UserDefinedForm', 'SilverStripe\\Subsites\\Pages\\SubsitesVirtualPage', 'App\\Page\\ContactPage') THEN "Page_Live"."ButtonLink1ID" WHEN "SiteTree_Live"."ClassName" IN ('App\\Page\\DonatePage') THEN "DonatePage_Live"."ButtonLink1ID" ELSE NULL END AS "ButtonLink1ID", "Page_Live"."ButtonLink2ID", "Page_Live"."HeroImageID", "Page_Live"."ElementalAreaID", "Page_Live"."OpenGraphImageID", "Page_Live"."SummaryImageID", "Page_Live"."SummaryIconID", "SiteTree_Live"."ID", CASE WHEN "SiteTree_Live"."ClassName" IS NOT NULL THEN "SiteTree_Live"."ClassName" ELSE 'SilverStripe\\CMS\\Model\\SiteTree' END AS "RecordClassName", "SiteTree_Live"."Sort" FROM "SiteTree_Live" LEFT JOIN "Page_Live" ON "Page_Live"."ID" = "SiteTree_Live"."ID" LEFT JOIN "DonatePage_Live" ON "DonatePage_Live"."ID" = "SiteTree_Live"."ID" WHERE ("SiteTree_Live"."ID" = ?) AND ("SiteTree_Live"."ClassName" IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)) ORDER BY "SiteTree_Live"."Sort" ASC LIMIT 1 0.0046s

0039: SELECT DISTINCT "File_Live"."ClassName", "File_Live"."LastEdited", "File_Live"."Created", "File_Live"."Version", "File_Live"."UserFormUpload", "File_Live"."CanViewType", "File_Live"."CanEditType", "File_Live"."Name", "File_Live"."Title", "File_Live"."ShowInSearch", "File_Live"."IsFolder", "File_Live"."SubsiteID", "File_Live"."ParentID", "File_Live"."OwnerID", "File_Live"."FileHash", "File_Live"."FileFilename", "File_Live"."FileVariant", "File_Live"."ID", CASE WHEN "File_Live"."ClassName" IS NOT NULL THEN "File_Live"."ClassName" ELSE 'SilverStripe\\Assets\\File' END AS "RecordClassName" FROM "File_Live" WHERE ("File_Live"."ID" = ?) AND ("File_Live"."ClassName" IN (?)) ORDER BY "File_Live"."Name" ASC LIMIT 1 0.0021s

0040: SELECT DISTINCT "File_Live"."ClassName", "File_Live"."LastEdited", "File_Live"."Created", "File_Live"."Version", "File_Live"."UserFormUpload", "File_Live"."CanViewType", "File_Live"."CanEditType", "File_Live"."Name", "File_Live"."Title", "File_Live"."ShowInSearch", "File_Live"."IsFolder", "File_Live"."SubsiteID", "File_Live"."ParentID", "File_Live"."OwnerID", "File_Live"."FileHash", "File_Live"."FileFilename", "File_Live"."FileVariant", "File_Live"."ID", CASE WHEN "File_Live"."ClassName" IS NOT NULL THEN "File_Live"."ClassName" ELSE 'SilverStripe\\Assets\\File' END AS "RecordClassName" FROM "File_Live" WHERE ("File_Live"."ID" = ?) AND ("File_Live"."ClassName" IN (?)) ORDER BY "File_Live"."Name" ASC LIMIT 1 0.0005s

0041: SELECT DISTINCT "File_Live"."ClassName", "File_Live"."LastEdited", "File_Live"."Created", "File_Live"."Version", "File_Live"."UserFormUpload", "File_Live"."CanViewType", "File_Live"."CanEditType", "File_Live"."Name", "File_Live"."Title", "File_Live"."ShowInSearch", "File_Live"."IsFolder", "File_Live"."SubsiteID", "File_Live"."ParentID", "File_Live"."OwnerID", "File_Live"."FileHash", "File_Live"."FileFilename", "File_Live"."FileVariant", "File_Live"."ID", CASE WHEN "File_Live"."ClassName" IS NOT NULL THEN "File_Live"."ClassName" ELSE 'SilverStripe\\Assets\\File' END AS "RecordClassName" FROM "File_Live" WHERE ("File_Live"."ID" = ?) ORDER BY "File_Live"."Name" ASC LIMIT 1 0.0004s

0042: SELECT DISTINCT "ElementalArea_Live"."ClassName", "ElementalArea_Live"."LastEdited", "ElementalArea_Live"."Created", "ElementalArea_Live"."Version", "ElementalArea_Live"."OwnerClassName", "ElementalArea_Live"."TopPageID", "ElementalArea_Live"."ID", CASE WHEN "ElementalArea_Live"."ClassName" IS NOT NULL THEN "ElementalArea_Live"."ClassName" ELSE 'DNADesign\\Elemental\\Models\\ElementalArea' END AS "RecordClassName" FROM "ElementalArea_Live" WHERE ("ElementalArea_Live"."ID" = ?) LIMIT 1 0.0033s

0043: SELECT DISTINCT "Element_Live"."ClassName", "Element_Live"."LastEdited", "Element_Live"."Created", "Element_Live"."Underline", "Element_Live"."TopBorder", "Element_Live"."BottomBorder", "Element_Live"."SecondaryContent", "Element_Live"."BoxStyle", "Element_Live"."BoxColumn", "Element_Live"."NoBackground", "Element_Live"."Style2", "Element_Live"."LocationLayout", "Element_Live"."AvailableGlobally", "Element_Live"."VirtualLookupTitle", "Element_Live"."BackgroundColour", "Element_Live"."BackgroundFadeToColour", "Element_Live"."BackgroundColourTransparency", "Element_Live"."BackgroundPosition", "Element_Live"."BackgroundSize", "Element_Live"."PaddingTop", "Element_Live"."PaddingBottom", "Element_Live"."HeadingColour", "Element_Live"."TextColour", "Element_Live"."HeadingAlignment", "Element_Live"."HeadingColumnAlignment", "Element_Live"."ContentAlignment", "Element_Live"."ButtonAlignment", "Element_Live"."ButtonTheme", "Element_Live"."ButtonSize", "Element_Live"."Version", "Element_Live"."Title", "Element_Live"."ShowTitle", "Element_Live"."Sort", "Element_Live"."ExtraClass", "Element_Live"."Style", "Element_Live"."BackgroundImageID", "Element_Live"."TopPageID", "Element_Live"."ParentID", "Element_Live"."ID", CASE WHEN "Element_Live"."ClassName" IS NOT NULL THEN "Element_Live"."ClassName" ELSE 'DNADesign\\Elemental\\Models\\BaseElement' END AS "RecordClassName" FROM "Element_Live" WHERE ("Element_Live"."ParentID" = ?) ORDER BY "Element_Live"."Sort" ASC 0.0019s

0044: SELECT DISTINCT "ElementalArea_Live"."ClassName", "ElementalArea_Live"."LastEdited", "ElementalArea_Live"."Created", "ElementalArea_Live"."Version", "ElementalArea_Live"."OwnerClassName", "ElementalArea_Live"."TopPageID", "ElementalArea_Live"."ID", CASE WHEN "ElementalArea_Live"."ClassName" IS NOT NULL THEN "ElementalArea_Live"."ClassName" ELSE 'DNADesign\\Elemental\\Models\\ElementalArea' END AS "RecordClassName" FROM "ElementalArea_Live" WHERE ("ElementalArea_Live"."ID" = ?) LIMIT 1 0.0003s

0045: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", "SiteTree_Live"."ElementalSearchContent", "SiteTree_Live"."MetaTitle", "SiteTree_Live"."CanViewType", "SiteTree_Live"."CanEditType", "SiteTree_Live"."Version", "SiteTree_Live"."Title", "SiteTree_Live"."URLSegment", "SiteTree_Live"."MenuTitle", "SiteTree_Live"."Content", "SiteTree_Live"."MetaDescription", "SiteTree_Live"."ExtraMeta", "SiteTree_Live"."ShowInMenus", "SiteTree_Live"."ShowInSearch", "SiteTree_Live"."Sort", "SiteTree_Live"."HasBrokenFile", "SiteTree_Live"."HasBrokenLink", "SiteTree_Live"."ReportClass", "SiteTree_Live"."SubsiteID", "SiteTree_Live"."ParentID", "Page_Live"."HeroContent", "Page_Live"."HeroContentPosition", "Page_Live"."ButtonSize1", "Page_Live"."ButtonSize2", "Page_Live"."HeroTitle", "Page_Live"."HeroBackgroundPosition", "Page_Live"."HeroHideBreadcrumbs", "Page_Live"."HeroHide", "Page_Live"."OverlayColor", "Page_Live"."OverlayTransparency", "Page_Live"."OpenGraphTitle", "Page_Live"."OpenGraphDescription", "Page_Live"."LDJSONSchema", "Page_Live"."SummaryDescription", "Page_Live"."IsSubMenuVisible", "Page_Live"."DisableMenuLink", "Page_Live"."LogoID", "Page_Live"."ButtonLink1ID", "Page_Live"."ButtonLink2ID", "Page_Live"."HeroImageID", "Page_Live"."ElementalAreaID", "Page_Live"."OpenGraphImageID", "Page_Live"."SummaryImageID", "Page_Live"."SummaryIconID", "SiteTree_Live"."ID", CASE WHEN "SiteTree_Live"."ClassName" IS NOT NULL THEN "SiteTree_Live"."ClassName" ELSE 'SilverStripe\\CMS\\Model\\SiteTree' END AS "RecordClassName" FROM "SiteTree_Live" LEFT JOIN "Page_Live" ON "Page_Live"."ID" = "SiteTree_Live"."ID" WHERE ("Page_Live"."ElementalAreaID" = ?) AND ("SiteTree_Live"."ClassName" = ?) AND ("SiteTree_Live"."ClassName" IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)) AND ("SiteTree_Live"."SubsiteID" IN (0)) ORDER BY "SiteTree_Live"."Sort" ASC LIMIT 1 0.0009s

0046: SELECT DISTINCT "ElementalArea_Live"."ClassName", "ElementalArea_Live"."LastEdited", "ElementalArea_Live"."Created", "ElementalArea_Live"."Version", "ElementalArea_Live"."OwnerClassName", "ElementalArea_Live"."TopPageID", "ElementalArea_Live"."ID", CASE WHEN "ElementalArea_Live"."ClassName" IS NOT NULL THEN "ElementalArea_Live"."ClassName" ELSE 'DNADesign\\Elemental\\Models\\ElementalArea' END AS "RecordClassName" FROM "ElementalArea_Live" WHERE ("ElementalArea_Live"."ID" = ?) LIMIT 1 0.0003s

0047: SELECT COUNT(ID) as "COUNT" FROM "SiteConfig" LIMIT 1 0.0002s

0048: SELECT DISTINCT count("MenuItem"."ID") AS "Count" FROM "MenuItem" 0.0029s

0049: SELECT DISTINCT MAX("MenuItem"."LastEdited") FROM "MenuItem" 0.0002s

0050: SELECT "Version" FROM "SiteTree" WHERE "ID" = ? 0.0005s

0051: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", "SiteTree_Live"."ElementalSearchContent", "SiteTree_Live"."MetaTitle", "SiteTree_Live"."CanViewType", "SiteTree_Live"."CanEditType", "SiteTree_Live"."Version", "SiteTree_Live"."Title", "SiteTree_Live"."URLSegment", "SiteTree_Live"."MenuTitle", "SiteTree_Live"."Content", "SiteTree_Live"."MetaDescription", "SiteTree_Live"."ExtraMeta", "SiteTree_Live"."ShowInMenus", "SiteTree_Live"."ShowInSearch", "SiteTree_Live"."Sort", "SiteTree_Live"."HasBrokenFile", "SiteTree_Live"."HasBrokenLink", "SiteTree_Live"."ReportClass", "SiteTree_Live"."SubsiteID", "SiteTree_Live"."ParentID", "SiteTree_Live"."ID", CASE WHEN "SiteTree_Live"."ClassName" IS NOT NULL THEN "SiteTree_Live"."ClassName" ELSE 'SilverStripe\\CMS\\Model\\SiteTree' END AS "RecordClassName" FROM "SiteTree_Live" WHERE ("SiteTree_Live"."ID" = ?) ORDER BY "SiteTree_Live"."Sort" ASC LIMIT 1 0.0004s

0052: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", "SiteTree_Live"."ElementalSearchContent", "SiteTree_Live"."MetaTitle", "SiteTree_Live"."CanViewType", "SiteTree_Live"."CanEditType", "SiteTree_Live"."Version", "SiteTree_Live"."Title", "SiteTree_Live"."URLSegment", "SiteTree_Live"."MenuTitle", "SiteTree_Live"."Content", "SiteTree_Live"."MetaDescription", "SiteTree_Live"."ExtraMeta", "SiteTree_Live"."ShowInMenus", "SiteTree_Live"."ShowInSearch", "SiteTree_Live"."Sort", "SiteTree_Live"."HasBrokenFile", "SiteTree_Live"."HasBrokenLink", "SiteTree_Live"."ReportClass", "SiteTree_Live"."SubsiteID", "SiteTree_Live"."ParentID", "SiteTree_Live"."ID", CASE WHEN "SiteTree_Live"."ClassName" IS NOT NULL THEN "SiteTree_Live"."ClassName" ELSE 'SilverStripe\\CMS\\Model\\SiteTree' END AS "RecordClassName" FROM "SiteTree_Live" WHERE ("SiteTree_Live"."ID" = ?) ORDER BY "SiteTree_Live"."Sort" ASC LIMIT 1 0.0003s

0053: SELECT DISTINCT "SiteTree"."ClassName", "SiteTree"."LastEdited", "SiteTree"."Created", "SiteTree"."Priority", "SiteTree"."ElementalSearchContent", "SiteTree"."MetaTitle", "SiteTree"."CanViewType", "SiteTree"."CanEditType", "SiteTree"."Version", "SiteTree"."Title", "SiteTree"."URLSegment", "SiteTree"."MenuTitle", "SiteTree"."Content", "SiteTree"."MetaDescription", "SiteTree"."ExtraMeta", "SiteTree"."ShowInMenus", "SiteTree"."ShowInSearch", "SiteTree"."Sort", "SiteTree"."HasBrokenFile", "SiteTree"."HasBrokenLink", "SiteTree"."ReportClass", "SiteTree"."SubsiteID", "SiteTree"."ParentID", "SiteTree"."ID", CASE WHEN "SiteTree"."ClassName" IS NOT NULL THEN "SiteTree"."ClassName" ELSE 'SilverStripe\\CMS\\Model\\SiteTree' END AS "RecordClassName" FROM "SiteTree" WHERE ("SiteTree"."ID" = ?) ORDER BY "SiteTree"."Sort" ASC LIMIT 1 0.0004s

0054: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", "SiteTree_Live"."ElementalSearchContent", "SiteTree_Live"."MetaTitle", "SiteTree_Live"."CanViewType", "SiteTree_Live"."CanEditType", "SiteTree_Live"."Version", "SiteTree_Live"."Title", "SiteTree_Live"."URLSegment", "SiteTree_Live"."MenuTitle", "SiteTree_Live"."Content", "SiteTree_Live"."MetaDescription", "SiteTree_Live"."ExtraMeta", "SiteTree_Live"."ShowInMenus", "SiteTree_Live"."ShowInSearch", "SiteTree_Live"."Sort", "SiteTree_Live"."HasBrokenFile", "SiteTree_Live"."HasBrokenLink", "SiteTree_Live"."ReportClass", "SiteTree_Live"."SubsiteID", "SiteTree_Live"."ParentID", "SiteTree_Live"."ID", CASE WHEN "SiteTree_Live"."ClassName" IS NOT NULL THEN "SiteTree_Live"."ClassName" ELSE 'SilverStripe\\CMS\\Model\\SiteTree' END AS "RecordClassName" FROM "SiteTree_Live" WHERE ("SiteTree_Live"."ID" = ?) ORDER BY "SiteTree_Live"."Sort" ASC LIMIT 1 0.0004s

0055: SELECT DISTINCT "Subsite"."ClassName", "Subsite"."LastEdited", "Subsite"."Created", "Subsite"."Title", "Subsite"."RedirectURL", "Subsite"."DefaultSite", "Subsite"."Theme", "Subsite"."Language", "Subsite"."IsPublic", "Subsite"."PageTypeBlacklist", "Subsite"."ID", CASE WHEN "Subsite"."ClassName" IS NOT NULL THEN "Subsite"."ClassName" ELSE 'SilverStripe\\Subsites\\Model\\Subsite' END AS "RecordClassName" FROM "Subsite" WHERE ("Subsite"."ID" = ?) ORDER BY "Subsite"."Title" ASC LIMIT 1 0.0008s

Work With Us - Presbyterian Support (Northern)

Work With Us

Join our team

Make a difference today by joining one of New Zealand’s leading social services charities. We have strong values and believe in the difference our work has in creating a better life for everyone.

We’re committed to maximising the independence of older people and those with disabilities or injuries and building strong families. Below is a list of jobs at Presbyterian Support Northern including Family Works and Enliven.

View our latest vacancies