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.0006s
0005: 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
0006: SELECT COUNT(ID) as "COUNT" FROM "SiteTree" LIMIT 1
0.0004s
0007: SELECT MAX(LastEdited) FROM "SiteTree" LIMIT 1
0.0005s
0008: SELECT MAX(LastEdited) FROM "SiteConfig" LIMIT 1
0.0002s
0009: 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.0005s
0010: SELECT DISTINCT count(DISTINCT "SubsiteDomain"."ID") AS "Count"
FROM "SubsiteDomain" INNER JOIN "Subsite" ON "Subsite"."ID" = "SubsiteDomain"."SubsiteID" AND "Subsite"."IsPublic"=1
WHERE ('familyworksnorthern.nzduat.co.nz' LIKE replace("SubsiteDomain"."Domain",'*','%'))
0.0005s
0011: SELECT "SubsiteDomain"."SubsiteID", "SubsiteDomain"."IsPrimary" AS "_SortColumn0"
FROM "SubsiteDomain" INNER JOIN "Subsite" ON "Subsite"."ID" = "SubsiteDomain"."SubsiteID" AND "Subsite"."IsPublic"=1
WHERE ('familyworksnorthern.nzduat.co.nz' LIKE replace("SubsiteDomain"."Domain",'*','%'))
ORDER BY "_SortColumn0" DESC
0.0003s
0012: SELECT "SubsiteDomain"."Domain", "SubsiteDomain"."IsPrimary" AS "_SortColumn0"
FROM "SubsiteDomain" INNER JOIN "Subsite" ON "Subsite"."ID" = "SubsiteDomain"."SubsiteID" AND "Subsite"."IsPublic"=1
WHERE ('familyworksnorthern.nzduat.co.nz' LIKE replace("SubsiteDomain"."Domain",'*','%'))
ORDER BY "_SortColumn0" DESC
0.0003s
0013: SHOW FULL FIELDS IN "SiteTree"
0.0013s
0014: SHOW COLLATION LIKE 'utf8mb4_unicode_ci'
0.0006s
0015: SHOW FULL FIELDS IN "Page"
0.0012s
0016: SHOW COLLATION LIKE 'utf8mb3_general_ci'
0.0005s
0017: SHOW FULL FIELDS IN "DonatePage"
0.0011s
0018: SHOW FULL FIELDS IN "EventDetailsPage"
0.0011s
0019: SHOW FULL FIELDS IN "EventHolderPage"
0.001s
0020: SHOW FULL FIELDS IN "EventPage"
0.0011s
0021: SHOW FULL FIELDS IN "EventRegistrationPage"
0.0009s
0022: SHOW FULL FIELDS IN "HomePage"
0.0009s
0023: SHOW FULL FIELDS IN "LocationPage"
0.0008s
0024: SHOW FULL FIELDS IN "ReferralFormPage"
0.0008s
0025: SHOW FULL FIELDS IN "MD_Page_ContactPage"
0.001s
0026: SHOW FULL FIELDS IN "MD_Page_ServiceHolderPage"
0.0009s
0027: SHOW FULL FIELDS IN "ErrorPage"
0.0008s
0028: SHOW FULL FIELDS IN "Blog"
0.0009s
0029: SHOW FULL FIELDS IN "BlogPost"
0.0009s
0030: SHOW FULL FIELDS IN "RedirectorPage"
0.0009s
0031: SHOW FULL FIELDS IN "VirtualPage"
0.001s
0032: SHOW FULL FIELDS IN "UserDefinedForm"
0.0009s
0033: SHOW FULL FIELDS IN "ContactPage"
0.0011s
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"."URLSegment" = ?)
AND ("SiteTree_Live"."ParentID" = ?)
AND ("SiteTree_Live"."SubsiteID" IN (4))
ORDER BY "SiteTree_Live"."Sort" ASC
LIMIT 1
0.0006s
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"."ParentID" = ?)
AND ("SiteTree_Live"."URLSegment" = ?)
AND ("SiteTree_Live"."SubsiteID" IN (4))
ORDER BY "SiteTree_Live"."Sort" ASC
LIMIT 1
0.0006s
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"."ParentID" = ?)
AND ("SiteTree_Live"."URLSegment" = ?)
AND ("SiteTree_Live"."SubsiteID" IN (4))
ORDER BY "SiteTree_Live"."Sort" ASC
LIMIT 1
0.0007s
0038: 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
0039: 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
0040: 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
0042: SELECT 1 AS "1"
WHERE (EXISTS (SELECT *
FROM "Subsite" ))
0.0002s
0043: 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
0044: 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 10:29:09')
ORDER BY "_SortColumn0" DESC, "BlogPost_Live"."PublishDate" DESC
LIMIT 1
0.0005s
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", "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
0046: 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
0047: 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"."SubsiteID" = ?)
ORDER BY "SubsiteDomain"."IsPrimary" DESC
LIMIT 1
0.0004s
0048: 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.0007s
0049: 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
0050: 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
0051: 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
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"."ShowInMenus" = ?)
AND ("SiteTree_Live"."ParentID" = ?)
AND ("SiteTree_Live"."SubsiteID" IN (4))
ORDER BY "SiteTree_Live"."Sort" ASC
0.0012s
0053: 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" <> "SiteTree_Live"."ID")
AND ("SiteTree_Live"."ParentID" = ?)
AND ("SiteTree_Live"."ShowInMenus" = ?)
AND ("SiteTree_Live"."SubsiteID" IN (4))
ORDER BY "SiteTree_Live"."Sort" ASC
0.0008s
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"."ParentID" <> "SiteTree_Live"."ID")
AND ("SiteTree_Live"."ParentID" = ?)
AND ("SiteTree_Live"."ShowInMenus" = ?)
AND ("SiteTree_Live"."SubsiteID" IN (4))
ORDER BY "SiteTree_Live"."Sort" ASC
0.0007s
0055: 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
0056: 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"
WHERE ("SiteTree_Live"."ID" = ?)
AND ("SiteTree_Live"."ClassName" IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?))
ORDER BY "SiteTree_Live"."Sort" ASC
LIMIT 1
0.0006s
0057: 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"
WHERE ("SiteTree_Live"."ID" = ?)
AND ("SiteTree_Live"."ClassName" IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?))
ORDER BY "SiteTree_Live"."Sort" ASC
LIMIT 1
0.0006s
0058: 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" <> "SiteTree_Live"."ID")
AND ("SiteTree_Live"."ParentID" = ?)
AND ("SiteTree_Live"."ShowInMenus" = ?)
AND ("SiteTree_Live"."SubsiteID" IN (4))
ORDER BY "SiteTree_Live"."Sort" ASC
0.0006s
0059: 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
0060: 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"
WHERE ("SiteTree_Live"."ID" = ?)
AND ("SiteTree_Live"."ClassName" IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?))
ORDER BY "SiteTree_Live"."Sort" ASC
LIMIT 1
0.0006s
0061: 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" <> "SiteTree_Live"."ID")
AND ("SiteTree_Live"."ParentID" = ?)
AND ("SiteTree_Live"."ShowInMenus" = ?)
AND ("SiteTree_Live"."SubsiteID" IN (4))
ORDER BY "SiteTree_Live"."Sort" ASC
0.0006s
0062: 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"
WHERE ("SiteTree_Live"."ID" = ?)
AND ("SiteTree_Live"."ClassName" IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?))
ORDER BY "SiteTree_Live"."Sort" ASC
LIMIT 1
0.0006s
0063: 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" <> "SiteTree_Live"."ID")
AND ("SiteTree_Live"."ParentID" = ?)
AND ("SiteTree_Live"."ShowInMenus" = ?)
AND ("SiteTree_Live"."SubsiteID" IN (4))
ORDER BY "SiteTree_Live"."Sort" ASC
0.0005s
0064: 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"
WHERE ("SiteTree_Live"."ID" = ?)
AND ("SiteTree_Live"."ClassName" IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?))
ORDER BY "SiteTree_Live"."Sort" ASC
LIMIT 1
0.0005s
0065: 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" <> "SiteTree_Live"."ID")
AND ("SiteTree_Live"."ParentID" = ?)
AND ("SiteTree_Live"."ShowInMenus" = ?)
AND ("SiteTree_Live"."SubsiteID" IN (4))
ORDER BY "SiteTree_Live"."Sort" ASC
0.0006s
0066: 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" <> "SiteTree_Live"."ID")
AND ("SiteTree_Live"."ParentID" = ?)
AND ("SiteTree_Live"."ShowInMenus" = ?)
AND ("SiteTree_Live"."SubsiteID" IN (4))
ORDER BY "SiteTree_Live"."Sort" ASC
0.0006s
0067: 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
0068: 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"
WHERE ("SiteTree_Live"."ID" = ?)
AND ("SiteTree_Live"."ClassName" IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?))
ORDER BY "SiteTree_Live"."Sort" ASC
LIMIT 1
0.0006s
0069: 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"
WHERE ("SiteTree_Live"."ID" = ?)
AND ("SiteTree_Live"."ClassName" IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?))
ORDER BY "SiteTree_Live"."Sort" ASC
LIMIT 1
0.0008s
0070: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "RedirectorPage_Live"."OpenInNewWindow", "RedirectorPage_Live"."RedirectionType", "RedirectorPage_Live"."ExternalURL", "RedirectorPage_Live"."LinkToID", "RedirectorPage_Live"."LinkToFileID", "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 "RedirectorPage_Live" ON "RedirectorPage_Live"."ID" = "SiteTree_Live"."ID"
WHERE ("SiteTree_Live"."ID" = ?)
AND ("SiteTree_Live"."ClassName" IN (?))
ORDER BY "SiteTree_Live"."Sort" ASC
LIMIT 1
0.0004s
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.0004s
0072: 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" <> "SiteTree_Live"."ID")
AND ("SiteTree_Live"."ParentID" = ?)
AND ("SiteTree_Live"."ShowInMenus" = ?)
AND ("SiteTree_Live"."SubsiteID" IN (4))
ORDER BY "SiteTree_Live"."Sort" ASC
0.0007s
0073: 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"
WHERE ("SiteTree_Live"."ID" = ?)
AND ("SiteTree_Live"."ClassName" IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?))
ORDER BY "SiteTree_Live"."Sort" ASC
LIMIT 1
0.0006s
0074: 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" <> "SiteTree_Live"."ID")
AND ("SiteTree_Live"."ParentID" = ?)
AND ("SiteTree_Live"."ShowInMenus" = ?)
AND ("SiteTree_Live"."SubsiteID" IN (4))
ORDER BY "SiteTree_Live"."Sort" ASC
0.0006s
0075: 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"
WHERE ("SiteTree_Live"."ID" = ?)
AND ("SiteTree_Live"."ClassName" IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?))
ORDER BY "SiteTree_Live"."Sort" ASC
LIMIT 1
0.0005s
0076: 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" <> "SiteTree_Live"."ID")
AND ("SiteTree_Live"."ParentID" = ?)
AND ("SiteTree_Live"."ShowInMenus" = ?)
AND ("SiteTree_Live"."SubsiteID" IN (4))
ORDER BY "SiteTree_Live"."Sort" ASC
0.0007s
0077: 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"
WHERE ("SiteTree_Live"."ID" = ?)
AND ("SiteTree_Live"."ClassName" IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?))
ORDER BY "SiteTree_Live"."Sort" ASC
LIMIT 1
0.0007s
0078: 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" <> "SiteTree_Live"."ID")
AND ("SiteTree_Live"."ParentID" = ?)
AND ("SiteTree_Live"."ShowInMenus" = ?)
AND ("SiteTree_Live"."SubsiteID" IN (4))
ORDER BY "SiteTree_Live"."Sort" ASC
0.0005s
0079: 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" <> "SiteTree_Live"."ID")
AND ("SiteTree_Live"."ParentID" = ?)
AND ("SiteTree_Live"."ShowInMenus" = ?)
AND ("SiteTree_Live"."SubsiteID" IN (4))
ORDER BY "SiteTree_Live"."Sort" ASC
0.0005s
0080: 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
0081: 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"
WHERE ("SiteTree_Live"."ID" = ?)
AND ("SiteTree_Live"."ClassName" IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?))
ORDER BY "SiteTree_Live"."Sort" ASC
LIMIT 1
0.0005s
0082: 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"
WHERE ("SiteTree_Live"."ID" = ?)
AND ("SiteTree_Live"."ClassName" IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?))
ORDER BY "SiteTree_Live"."Sort" ASC
LIMIT 1
0.0006s
0083: 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" <> "SiteTree_Live"."ID")
AND ("SiteTree_Live"."ParentID" = ?)
AND ("SiteTree_Live"."ShowInMenus" = ?)
AND ("SiteTree_Live"."SubsiteID" IN (4))
ORDER BY "SiteTree_Live"."Sort" ASC
0.0006s
0084: 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" <> "SiteTree_Live"."ID")
AND ("SiteTree_Live"."ParentID" = ?)
AND ("SiteTree_Live"."ShowInMenus" = ?)
AND ("SiteTree_Live"."SubsiteID" IN (4))
ORDER BY "SiteTree_Live"."Sort" ASC
0.0007s
0085: 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"
WHERE ("SiteTree_Live"."ID" = ?)
AND ("SiteTree_Live"."ClassName" IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?))
ORDER BY "SiteTree_Live"."Sort" ASC
LIMIT 1
0.0006s
0086: 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"
WHERE ("SiteTree_Live"."ID" = ?)
AND ("SiteTree_Live"."ClassName" IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?))
ORDER BY "SiteTree_Live"."Sort" ASC
LIMIT 1
0.0008s
0087: 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" INNER 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"."ShowInMenus" = ?)
AND ("PublishDate" < '2026-08-11 10:29:10')
AND ("SiteTree_Live"."SubsiteID" IN (4))
ORDER BY "SiteTree_Live"."Sort" ASC
0.0009s
0088: 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"
WHERE ("SiteTree_Live"."ID" = ?)
AND ("SiteTree_Live"."ClassName" IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?))
ORDER BY "SiteTree_Live"."Sort" ASC
LIMIT 1
0.0006s
0089: 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"."ID" != ? OR "SiteTree_Live"."ID" IS NULL))
AND ("SiteTree_Live"."ShowInMenus" = ?)
AND ("SiteTree_Live"."SubsiteID" IN (4))
ORDER BY "SiteTree_Live"."Sort" ASC
0.0006s
0090: 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
0091: 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"
WHERE ("SiteTree_Live"."ID" = ?)
AND ("SiteTree_Live"."ClassName" IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?))
ORDER BY "SiteTree_Live"."Sort" ASC
LIMIT 1
0.0006s
0092: 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" <> "SiteTree_Live"."ID")
AND ("SiteTree_Live"."ParentID" = ?)
AND ("SiteTree_Live"."ShowInMenus" = ?)
AND ("SiteTree_Live"."SubsiteID" IN (4))
ORDER BY "SiteTree_Live"."Sort" ASC
0.0008s
0093: 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"
WHERE ("SiteTree_Live"."ID" = ?)
AND ("SiteTree_Live"."ClassName" IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?))
ORDER BY "SiteTree_Live"."Sort" ASC
LIMIT 1
0.0007s
0094: 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" <> "SiteTree_Live"."ID")
AND ("SiteTree_Live"."ParentID" = ?)
AND ("SiteTree_Live"."ShowInMenus" = ?)
AND ("SiteTree_Live"."SubsiteID" IN (4))
ORDER BY "SiteTree_Live"."Sort" ASC
0.0006s
0095: 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"."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 ("SiteTree_Live"."ClassName" IN (?))
AND ("SiteTree_Live"."SubsiteID" IN (4))
ORDER BY "SiteTree_Live"."Sort" ASC
LIMIT 1
0.001s
0096: SELECT DISTINCT "LinkField_Link_Live"."ClassName", "LinkField_Link_Live"."LastEdited", "LinkField_Link_Live"."Created", "LinkField_Link_Live"."Version", "LinkField_Link_Live"."LinkText", "LinkField_Link_Live"."OpenInNew", "LinkField_Link_Live"."Sort", "LinkField_Link_Live"."OwnerID", "LinkField_Link_Live"."OwnerClass", "LinkField_Link_Live"."OwnerRelation", "LinkField_Link_Live"."ID",
CASE WHEN "LinkField_Link_Live"."ClassName" IS NOT NULL THEN "LinkField_Link_Live"."ClassName"
ELSE 'SilverStripe\\LinkField\\Models\\Link' END AS "RecordClassName"
FROM "LinkField_Link_Live"
WHERE ("LinkField_Link_Live"."ID" = ?)
ORDER BY "LinkField_Link_Live"."Sort" ASC
LIMIT 1
0.0007s
0097: SELECT DISTINCT "LinkField_Link_Live"."ClassName", "LinkField_Link_Live"."LastEdited", "LinkField_Link_Live"."Created", "LinkField_SiteTreeLink_Live"."Anchor", "LinkField_SiteTreeLink_Live"."QueryString", "LinkField_SiteTreeLink_Live"."PageID", "LinkField_Link_Live"."ID",
CASE WHEN "LinkField_Link_Live"."ClassName" IS NOT NULL THEN "LinkField_Link_Live"."ClassName"
ELSE 'SilverStripe\\LinkField\\Models\\Link' END AS "RecordClassName", "LinkField_Link_Live"."Sort"
FROM "LinkField_Link_Live" LEFT JOIN "LinkField_SiteTreeLink_Live" ON "LinkField_SiteTreeLink_Live"."ID" = "LinkField_Link_Live"."ID"
WHERE ("LinkField_Link_Live"."ID" = ?)
AND ("LinkField_Link_Live"."ClassName" IN (?))
ORDER BY "LinkField_Link_Live"."Sort" ASC
LIMIT 1
0.0005s
0098: 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
0099: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "RedirectorPage_Live"."OpenInNewWindow", "RedirectorPage_Live"."RedirectionType", "RedirectorPage_Live"."ExternalURL", "RedirectorPage_Live"."LinkToID", "RedirectorPage_Live"."LinkToFileID", "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 "RedirectorPage_Live" ON "RedirectorPage_Live"."ID" = "SiteTree_Live"."ID"
WHERE ("SiteTree_Live"."ID" = ?)
AND ("SiteTree_Live"."ClassName" IN (?))
ORDER BY "SiteTree_Live"."Sort" ASC
LIMIT 1
0.0004s
0100: 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
0101: 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.0006s
0102: 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
0103: 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
0104: 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
0105: 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 (4))
AND ("PublishDate" < '2026-08-11 10:29:10')
ORDER BY "_SortColumn0" DESC, "BlogPost_Live"."PublishDate" DESC
LIMIT 1
0.001s
0106: 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.001s
0107: SELECT DISTINCT "Element_Live"."ClassName", "Element_Live"."LastEdited", "Element_Live"."Created", "MD_Blocks_WysiwygWithImage_Live"."Content", "MD_Blocks_WysiwygWithImage_Live"."ImagePosition", "MD_Blocks_WysiwygWithImage_Live"."ImagePositionMobile", "MD_Blocks_WysiwygWithImage_Live"."IsImageFullHeight", "MD_Blocks_WysiwygWithImage_Live"."IsShadow", "MD_Blocks_WysiwygWithImage_Live"."BorderRadius", "MD_Blocks_WysiwygWithImage_Live"."ColumnSplit", "MD_Blocks_WysiwygWithImage_Live"."ContentPositioning", "MD_Blocks_WysiwygWithImage_Live"."ImageID", "MD_Blocks_WysiwygWithImage_Live"."ButtonLinkID", "Element_Live"."ID",
CASE WHEN "Element_Live"."ClassName" IS NOT NULL THEN "Element_Live"."ClassName"
ELSE 'DNADesign\\Elemental\\Models\\BaseElement' END AS "RecordClassName", "Element_Live"."Sort"
FROM "Element_Live" LEFT JOIN "MD_Blocks_WysiwygWithImage_Live" ON "MD_Blocks_WysiwygWithImage_Live"."ID" = "Element_Live"."ID"
WHERE ("Element_Live"."ID" = ?)
AND ("Element_Live"."ClassName" IN (?))
ORDER BY "Element_Live"."Sort" ASC
LIMIT 1
0.0013s
0108: 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
0109: 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
0110: 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.0006s
0111: SELECT "File"."ID"
FROM "File"
WHERE ("File"."ID" IN (28))
0.0005s
0112: SELECT "File"."ID"
FROM "File"
WHERE ("File"."ID" IN (28))
AND ("File"."CanViewType" = ?)
0.0004s
0113: SELECT DISTINCT "File"."ID", "File"."ParentID"
FROM "File"
WHERE ("File"."ID" IN (28))
AND ("File"."CanViewType" = ?)
ORDER BY "File"."ID" ASC
0.0003s
0114: SELECT "File"."ID"
FROM "File"
WHERE ("File"."ID" IN (6))
0.0002s
0115: SELECT "File"."ID"
FROM "File"
WHERE ("File"."ID" IN (6))
AND ("File"."CanViewType" = ?)
0.0003s
0116: SELECT DISTINCT "File"."ID", "File"."ParentID"
FROM "File"
WHERE ("File"."ID" IN (6))
AND ("File"."CanViewType" = ?)
ORDER BY "File"."ID" ASC
0.0003s
0117: SELECT "File_Live"."ID"
FROM "File_Live"
WHERE ("File_Live"."ID" IN (6))
AND (("File_Live"."ID" NOT IN (6) OR "File_Live"."ID" IS NULL))
0.0002s
0118: SELECT "File_Live"."ID"
FROM "File_Live"
WHERE ("File_Live"."ID" IN (6))
AND (("File_Live"."ID" NOT IN (6) OR "File_Live"."ID" IS NULL))
AND ("File_Live"."CanViewType" = ?)
0.0004s
0119: SELECT DISTINCT "File_Live"."ID", "File_Live"."ParentID"
FROM "File_Live"
WHERE ("File_Live"."ID" IN (6))
AND (("File_Live"."ID" NOT IN (6) OR "File_Live"."ID" IS NULL))
AND ("File_Live"."CanViewType" = ?)
ORDER BY "File_Live"."ID" ASC
0.0003s
0120: SELECT "File_Live"."ID"
FROM "File_Live"
WHERE ("File_Live"."ID" IN (28))
AND (("File_Live"."ID" NOT IN (28) OR "File_Live"."ID" IS NULL))
0.0003s
0121: SELECT "File_Live"."ID"
FROM "File_Live"
WHERE ("File_Live"."ID" IN (28))
AND (("File_Live"."ID" NOT IN (28) OR "File_Live"."ID" IS NULL))
AND ("File_Live"."CanViewType" = ?)
0.0003s
0122: SELECT DISTINCT "File_Live"."ID", "File_Live"."ParentID"
FROM "File_Live"
WHERE ("File_Live"."ID" IN (28))
AND (("File_Live"."ID" NOT IN (28) OR "File_Live"."ID" IS NULL))
AND ("File_Live"."CanViewType" = ?)
ORDER BY "File_Live"."ID" ASC
0.0003s
0123: 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 (4))
AND ("PublishDate" < '2026-08-11 10:29:10')
LIMIT 5))
0.0008s
0124: 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 (4))
AND ("PublishDate" < '2026-08-11 10:29:10')
ORDER BY "BlogPost_Live"."PublishDate" DESC
LIMIT 5
0.0015s
0125: 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
0126: 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.0025s
0127: 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
0128: 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
0129: 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.0004s
0130: 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 (4))
AND ("PublishDate" < '2026-08-11 10:29:10')
0.0008s
0131: 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
0132: 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.0005s
0133: SELECT COUNT(ID) as "COUNT" FROM "SiteConfig" LIMIT 1
0.0002s
0134: SELECT DISTINCT count("MenuItem"."ID") AS "Count"
FROM "MenuItem"
0.0005s
0135: SELECT DISTINCT MAX("MenuItem"."LastEdited")
FROM "MenuItem"
0.0005s
0136: SELECT "Version" FROM "SiteTree" WHERE "ID" = ?
0.0004s
0137: 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
0138: 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
0139: 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.0004s
0140: 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"."SubsiteID" = ?)
ORDER BY "SubsiteDomain"."IsPrimary" DESC
LIMIT 1
0.0004s
0141: 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
0142: 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
0143: 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"."SubsiteID" = ?)
ORDER BY "SubsiteDomain"."IsPrimary" DESC
LIMIT 1
0.0004s
0144: 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"."SubsiteID" = ?)
ORDER BY "SubsiteDomain"."IsPrimary" DESC
LIMIT 1
0.0004s
0145: 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
0146: 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
0147: 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"."SubsiteID" = ?)
ORDER BY "SubsiteDomain"."IsPrimary" DESC
LIMIT 1
0.0003s
Report highlights value of Social Workers in Schools - Family Works
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.
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.