0001: SET sql_mode = ? 0.0004s

0002: SHOW DATABASES LIKE 'psnorthern' 0.0007s

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"."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"."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.0012s

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.0007s

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.0007s

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.0005s

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.0013s

0012: SHOW COLLATION LIKE 'utf8mb4_unicode_ci' 0.0005s

0013: SHOW FULL FIELDS IN "Page" 0.002s

0014: SHOW COLLATION LIKE 'utf8mb3_general_ci' 0.0005s

0015: SHOW FULL FIELDS IN "DonatePage" 0.001s

0016: SHOW FULL FIELDS IN "EventDetailsPage" 0.0008s

0017: SHOW FULL FIELDS IN "EventHolderPage" 0.0007s

0018: SHOW FULL FIELDS IN "EventPage" 0.0008s

0019: SHOW FULL FIELDS IN "EventRegistrationPage" 0.0007s

0020: SHOW FULL FIELDS IN "HomePage" 0.0007s

0021: SHOW FULL FIELDS IN "LocationPage" 0.0006s

0022: SHOW FULL FIELDS IN "ReferralFormPage" 0.0007s

0023: SHOW FULL FIELDS IN "MD_Page_ContactPage" 0.0007s

0024: SHOW FULL FIELDS IN "MD_Page_ServiceHolderPage" 0.0007s

0025: SHOW FULL FIELDS IN "ErrorPage" 0.0006s

0026: SHOW FULL FIELDS IN "Blog" 0.001s

0027: SHOW FULL FIELDS IN "BlogPost" 0.0014s

0028: SHOW FULL FIELDS IN "RedirectorPage" 0.0008s

0029: SHOW FULL FIELDS IN "VirtualPage" 0.0009s

0030: SHOW FULL FIELDS IN "UserDefinedForm" 0.0021s

0031: SHOW FULL FIELDS IN "ContactPage" 0.0011s

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.0012s

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.0009s

0034: 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.0008s

0035: 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"."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"."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.0015s

0036: 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.0011s

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.0008s

0038: 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.0005s

0039: SELECT 1 AS "1" WHERE (EXISTS (SELECT * FROM "Subsite" )) 0.0004s

0040: 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.0007s

0041: SELECT DISTINCT "PublishDate" IS NULL AS "_SortColumn0", "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "BlogPost_Live"."TextSummary", "BlogPost_Live"."PublishDate", "BlogPost_Live"."AuthorNames", "BlogPost_Live"."Summary", "BlogPost_Live"."DownloadFileID", "BlogPost_Live"."SecondaryElementalAreaID", "BlogPost_Live"."FeaturedImageID", "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 "BlogPost_Live" ON "BlogPost_Live"."ID" = "SiteTree_Live"."ID" LEFT JOIN "Page_Live" ON "Page_Live"."ID" = "SiteTree_Live"."ID" WHERE ("SiteTree_Live"."ID" = ?) AND ("SiteTree_Live"."ClassName" IN (?)) AND ("PublishDate" < '2026-08-11 09:45:38') ORDER BY "_SortColumn0" DESC, "BlogPost_Live"."PublishDate" DESC LIMIT 1 0.0022s

0042: 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.001s

0043: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "Page_Live"."HeroContent", "Page_Live"."HeroContentPosition", "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" INNER JOIN "BlogPost_Live" ON "SiteTree_Live"."ID" = "BlogPost_Live"."ID" WHERE ("SiteTree_Live"."ID" = ?) AND ("SiteTree_Live"."ClassName" IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)) ORDER BY "SiteTree_Live"."Sort" ASC LIMIT 1 0.0014s

0044: 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.0013s

0045: 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.001s

0046: 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.0009s

0047: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "Blog_Live"."FeaturedContent", "Blog_Live"."BlogPostStyle", "Blog_Live"."PostsPerPage", "Blog_Live"."ButtonLinkID", "Blog_Live"."DefaultFeaturedImageID", "Blog_Live"."DefaultCategoryImageID", "Blog_Live"."SecondaryElementalAreaID", "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 "Blog_Live" ON "Blog_Live"."ID" = "SiteTree_Live"."ID" WHERE ("SiteTree_Live"."ID" = ?) AND ("SiteTree_Live"."ClassName" IN (?)) ORDER BY "SiteTree_Live"."Sort" ASC LIMIT 1 0.0014s

0048: 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.0005s

0049: 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"."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.0011s

0050: 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.0024s

0051: SELECT DISTINCT "PublishDate" IS NULL AS "_SortColumn0", "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"."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", "BlogPost_Live"."TextSummary", "BlogPost_Live"."PublishDate", "BlogPost_Live"."AuthorNames", "BlogPost_Live"."Summary", "BlogPost_Live"."DownloadFileID", "BlogPost_Live"."SecondaryElementalAreaID", "BlogPost_Live"."FeaturedImageID", "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" LEFT JOIN "BlogPost_Live" ON "BlogPost_Live"."ID" = "SiteTree_Live"."ID" WHERE ("Page_Live"."ElementalAreaID" = ?) AND ("SiteTree_Live"."ClassName" = ?) AND ("SiteTree_Live"."ClassName" IN (?)) AND ("SiteTree_Live"."SubsiteID" IN (0)) AND ("PublishDate" < '2026-08-11 09:45:38') ORDER BY "_SortColumn0" DESC, "BlogPost_Live"."PublishDate" DESC LIMIT 1 0.0011s

0052: 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.0004s

0053: SELECT 1 AS "1" WHERE (EXISTS (SELECT * FROM "SiteTree_Live" LEFT JOIN "Page_Live" ON "Page_Live"."ID" = "SiteTree_Live"."ID" LEFT JOIN "BlogPost_Live" ON "BlogPost_Live"."ID" = "SiteTree_Live"."ID" WHERE ("SiteTree_Live"."ParentID" = ?) AND (("SiteTree_Live"."ID" != ? OR "SiteTree_Live"."ID" IS NULL)) AND ("SiteTree_Live"."ClassName" IN (?)) AND ("SiteTree_Live"."SubsiteID" IN (0)) AND ("PublishDate" < '2026-08-11 09:45:38') LIMIT 5)) 0.0009s

0054: SELECT DISTINCT "PublishDate" IS NULL AS "_SortColumn0", "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"."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", "BlogPost_Live"."TextSummary", "BlogPost_Live"."PublishDate", "BlogPost_Live"."AuthorNames", "BlogPost_Live"."Summary", "BlogPost_Live"."DownloadFileID", "BlogPost_Live"."SecondaryElementalAreaID", "BlogPost_Live"."FeaturedImageID", "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" LEFT JOIN "BlogPost_Live" ON "BlogPost_Live"."ID" = "SiteTree_Live"."ID" WHERE ("SiteTree_Live"."ParentID" = ?) AND (("SiteTree_Live"."ID" != ? OR "SiteTree_Live"."ID" IS NULL)) AND ("SiteTree_Live"."ClassName" IN (?)) AND ("SiteTree_Live"."SubsiteID" IN (0)) AND ("PublishDate" < '2026-08-11 09:45:38') ORDER BY "BlogPost_Live"."PublishDate" DESC LIMIT 5 0.0046s

0055: 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.0006s

0056: 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.0009s

0057: 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

0058: 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.0009s

0059: 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.0006s

0060: SELECT DISTINCT count(DISTINCT "SiteTree_Live"."ID") AS "Count" FROM "SiteTree_Live" LEFT JOIN "Page_Live" ON "Page_Live"."ID" = "SiteTree_Live"."ID" LEFT JOIN "BlogPost_Live" ON "BlogPost_Live"."ID" = "SiteTree_Live"."ID" WHERE ("SiteTree_Live"."ParentID" = ?) AND (("SiteTree_Live"."ID" != ? OR "SiteTree_Live"."ID" IS NULL)) AND ("SiteTree_Live"."ClassName" IN (?)) AND ("SiteTree_Live"."SubsiteID" IN (0)) AND ("PublishDate" < '2026-08-11 09:45:38') 0.0017s

0061: 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.0005s

0062: 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"."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.0006s

0063: 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.0005s

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

0065: SELECT DISTINCT count("MenuItem"."ID") AS "Count" FROM "MenuItem" 0.0002s

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

0067: SELECT "Version" FROM "SiteTree" WHERE "ID" = ? 0.0003s

0068: 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

0069: 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

0070: 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.0005s

0071: 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

0072: 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

Report highlights value of Social Workers in Schools - Presbyterian Support (Northern)

Report highlights value of Social Workers in Schools

10 July 2025

When we support tamariki to feel safe, connected, and confident at school, we help create real, positive change in their wellbeing and everyday lives – making a meaningful difference and delivering strong social value in financial terms.

 

That’s the key finding of a social return on investment (SROI) report released by social services provider Presbyterian Support Northern (PSN), whose services include Family Works, Lifeline and Shine.

Produced by PSN’s service evaluation team, the report found that for every $1 invested in its Social Workers in Schools (SWiS) service, $3.50 of social value was created.

This is on top of positive changes experienced by children, parents or caregivers, and school staff.

PSN General Manager Social Services Grenville Hendricks says the report helps to demonstrate the social value created through the SWiS service — not only through numbers and outcomes, but through the positive changes seen in the lives of tamariki and their whānau.

“We know that when children’s basic needs are met and their emotional wellbeing is nurtured, they are more likely to attend school regularly, engage in learning and reach their full potential,” he says.

“Whether it’s building trust with a family, addressing barriers to school attendance, or creating a safe space for a child to be heard, the SWiS service plays a vital role in strengthening foundations for lifelong wellbeing.

“What this report does is quantify exactly what this means in dollar terms through clearly showing a return on investment of more than three to one.

“This is an important finding and aligns with the Government’s drive for clearer social return on investment.”

Research for the report looked at 2981 children receiving individual support and those attending group-based sessions across 96 schools in the upper North Island during the period 1 April 2024 – 31 March 2025. It also considered the social value created for other key stakeholders, such as parents and caregivers.

The report is based on the internationally recognised Social Return on Investment (SROI) framework and follows the eight principles of Social Value International.

In line with best practice, financial value was assigned to outcomes by selecting financial proxies from the NZ Treasury CBAx tool, relevant research and comparable programme valuations.

“Our findings align with other similar evaluations, including those outcome evaluations conducted by Oranga Tamariki and the Social Investment Agency, which consistently show positive outcomes for tamariki, whānau and schools,” says Grenville Hendricks.

“We believe our analysis can inform decision-making and has implications for future investment, highlighting the potential for broader system wide impact if SWiS services were scaled up across more educational settings.

“The SROI analysis demonstrates that our SWiS service is achieving not only service-level change but also offers a scalable model for improving tamariki wellbeing, whānau resilience and system coordination. Future government policy should build on these insights to extend the reach and impact of the SWiS service. The Social Workers in School Social Return On Investment report can be found here.

Back to Articles