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.0005s
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.0004s
0006: SELECT COUNT(ID) as "COUNT" FROM "SiteTree" LIMIT 1
0.0003s
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 ('2shine.nzduat.co.nz' LIKE replace("SubsiteDomain"."Domain",'*','%'))
0.0011s
0011: SELECT "SubsiteDomain"."SubsiteID", "SubsiteDomain"."IsPrimary" AS "_SortColumn0"
FROM "SubsiteDomain" INNER JOIN "Subsite" ON "Subsite"."ID" = "SubsiteDomain"."SubsiteID" AND "Subsite"."IsPublic"=1
WHERE ('2shine.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 ('2shine.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.0005s
0015: SHOW FULL FIELDS IN "Page"
0.0011s
0016: SHOW COLLATION LIKE 'utf8mb3_general_ci'
0.0004s
0017: SHOW FULL FIELDS IN "DonatePage"
0.0009s
0018: SHOW FULL FIELDS IN "EventDetailsPage"
0.0008s
0019: SHOW FULL FIELDS IN "EventHolderPage"
0.0008s
0020: SHOW FULL FIELDS IN "EventPage"
0.0009s
0021: SHOW FULL FIELDS IN "EventRegistrationPage"
0.004s
0022: SHOW FULL FIELDS IN "HomePage"
0.0018s
0023: SHOW FULL FIELDS IN "LocationPage"
0.0012s
0024: SHOW FULL FIELDS IN "ReferralFormPage"
0.001s
0025: SHOW FULL FIELDS IN "MD_Page_ContactPage"
0.001s
0026: SHOW FULL FIELDS IN "MD_Page_ServiceHolderPage"
0.0012s
0027: SHOW FULL FIELDS IN "ErrorPage"
0.0009s
0028: SHOW FULL FIELDS IN "Blog"
0.001s
0029: SHOW FULL FIELDS IN "BlogPost"
0.0011s
0030: SHOW FULL FIELDS IN "RedirectorPage"
0.001s
0031: SHOW FULL FIELDS IN "VirtualPage"
0.001s
0032: SHOW FULL FIELDS IN "UserDefinedForm"
0.001s
0033: SHOW FULL FIELDS IN "ContactPage"
0.0012s
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 (5))
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 (5))
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 (5))
ORDER BY "SiteTree_Live"."Sort" ASC
LIMIT 1
0.0005s
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.0004s
0042: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", "SiteTree_Live"."ElementalSearchContent", "SiteTree_Live"."MetaTitle", "SiteTree_Live"."CanViewType", "SiteTree_Live"."CanEditType", "SiteTree_Live"."Version", "SiteTree_Live"."Title", "SiteTree_Live"."URLSegment", "SiteTree_Live"."MenuTitle", "SiteTree_Live"."Content", "SiteTree_Live"."MetaDescription", "SiteTree_Live"."ExtraMeta", "SiteTree_Live"."ShowInMenus", "SiteTree_Live"."ShowInSearch", "SiteTree_Live"."Sort", "SiteTree_Live"."HasBrokenFile", "SiteTree_Live"."HasBrokenLink", "SiteTree_Live"."ReportClass", "SiteTree_Live"."SubsiteID", "SiteTree_Live"."ParentID", "SiteTree_Live"."ID",
CASE WHEN "SiteTree_Live"."ClassName" IS NOT NULL THEN "SiteTree_Live"."ClassName"
ELSE 'SilverStripe\\CMS\\Model\\SiteTree' END AS "RecordClassName"
FROM "SiteTree_Live"
WHERE ("SiteTree_Live"."ID" = ?)
ORDER BY "SiteTree_Live"."Sort" ASC
LIMIT 1
0.0009s
0043: 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
0044: 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
0045: 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
0046: SELECT DISTINCT "File_Live"."ClassName", "File_Live"."LastEdited", "File_Live"."Created", "File_Live"."Version", "File_Live"."UserFormUpload", "File_Live"."CanViewType", "File_Live"."CanEditType", "File_Live"."Name", "File_Live"."Title", "File_Live"."ShowInSearch", "File_Live"."IsFolder", "File_Live"."SubsiteID", "File_Live"."ParentID", "File_Live"."OwnerID", "File_Live"."FileHash", "File_Live"."FileFilename", "File_Live"."FileVariant", "File_Live"."ID",
CASE WHEN "File_Live"."ClassName" IS NOT NULL THEN "File_Live"."ClassName"
ELSE 'SilverStripe\\Assets\\File' END AS "RecordClassName"
FROM "File_Live"
WHERE ("File_Live"."ID" = ?)
AND ("File_Live"."ClassName" IN (?))
ORDER BY "File_Live"."Name" ASC
LIMIT 1
0.0006s
0047: 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
0048: SELECT DISTINCT "ElementalArea_Live"."ClassName", "ElementalArea_Live"."LastEdited", "ElementalArea_Live"."Created", "ElementalArea_Live"."Version", "ElementalArea_Live"."OwnerClassName", "ElementalArea_Live"."TopPageID", "ElementalArea_Live"."ID",
CASE WHEN "ElementalArea_Live"."ClassName" IS NOT NULL THEN "ElementalArea_Live"."ClassName"
ELSE 'DNADesign\\Elemental\\Models\\ElementalArea' END AS "RecordClassName"
FROM "ElementalArea_Live"
WHERE ("ElementalArea_Live"."ID" = ?)
LIMIT 1
0.0005s
0049: SELECT DISTINCT "Element_Live"."ClassName", "Element_Live"."LastEdited", "Element_Live"."Created", "Element_Live"."Underline", "Element_Live"."TopBorder", "Element_Live"."BottomBorder", "Element_Live"."SecondaryContent", "Element_Live"."BoxStyle", "Element_Live"."BoxColumn", "Element_Live"."NoBackground", "Element_Live"."Style2", "Element_Live"."LocationLayout", "Element_Live"."AvailableGlobally", "Element_Live"."VirtualLookupTitle", "Element_Live"."BackgroundColour", "Element_Live"."BackgroundFadeToColour", "Element_Live"."BackgroundColourTransparency", "Element_Live"."BackgroundPosition", "Element_Live"."BackgroundSize", "Element_Live"."PaddingTop", "Element_Live"."PaddingBottom", "Element_Live"."HeadingColour", "Element_Live"."TextColour", "Element_Live"."HeadingAlignment", "Element_Live"."HeadingColumnAlignment", "Element_Live"."ContentAlignment", "Element_Live"."ButtonAlignment", "Element_Live"."ButtonTheme", "Element_Live"."Version", "Element_Live"."Title", "Element_Live"."ShowTitle", "Element_Live"."Sort", "Element_Live"."ExtraClass", "Element_Live"."Style", "Element_Live"."BackgroundImageID", "Element_Live"."TopPageID", "Element_Live"."ParentID", "Element_Live"."ID",
CASE WHEN "Element_Live"."ClassName" IS NOT NULL THEN "Element_Live"."ClassName"
ELSE 'DNADesign\\Elemental\\Models\\BaseElement' END AS "RecordClassName"
FROM "Element_Live"
WHERE ("Element_Live"."ParentID" = ?)
ORDER BY "Element_Live"."Sort" ASC
0.0009s
0050: SELECT DISTINCT "Element_Live"."ClassName", "Element_Live"."LastEdited", "Element_Live"."Created", "ElementVirtual_Live"."LinkedElementID", "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 "ElementVirtual_Live" ON "ElementVirtual_Live"."ID" = "Element_Live"."ID"
WHERE ("Element_Live"."ID" = ?)
AND ("Element_Live"."ClassName" IN (?))
ORDER BY "Element_Live"."Sort" ASC
LIMIT 1
0.0014s
0051: 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"."ID" = ?)
ORDER BY "Element_Live"."Sort" ASC
LIMIT 1
0.0005s
0052: SELECT DISTINCT "ElementalArea_Live"."ClassName", "ElementalArea_Live"."LastEdited", "ElementalArea_Live"."Created", "ElementalArea_Live"."Version", "ElementalArea_Live"."OwnerClassName", "ElementalArea_Live"."TopPageID", "ElementalArea_Live"."ID",
CASE WHEN "ElementalArea_Live"."ClassName" IS NOT NULL THEN "ElementalArea_Live"."ClassName"
ELSE 'DNADesign\\Elemental\\Models\\ElementalArea' END AS "RecordClassName"
FROM "ElementalArea_Live"
WHERE ("ElementalArea_Live"."ID" = ?)
LIMIT 1
0.0003s
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", "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 ("Page_Live"."ElementalAreaID" = ?)
AND ("SiteTree_Live"."ClassName" = ?)
AND ("SiteTree_Live"."ClassName" IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?))
AND ("SiteTree_Live"."SubsiteID" IN (5))
ORDER BY "SiteTree_Live"."Sort" ASC
LIMIT 1
0.0009s
0054: SELECT DISTINCT "Element_Live"."ClassName", "Element_Live"."LastEdited", "Element_Live"."Created", "ElementVirtual_Live"."LinkedElementID", "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 "ElementVirtual_Live" ON "ElementVirtual_Live"."ID" = "Element_Live"."ID"
WHERE ("Element_Live"."ID" = ?)
AND ("Element_Live"."ClassName" IN (?))
ORDER BY "Element_Live"."Sort" ASC
LIMIT 1
0.0004s
0055: 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"."ID" = ?)
ORDER BY "Element_Live"."Sort" ASC
LIMIT 1
0.0005s
0056: SELECT DISTINCT "Element_Live"."ClassName", "Element_Live"."LastEdited", "Element_Live"."Created", "ElementVirtual_Live"."LinkedElementID", "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 "ElementVirtual_Live" ON "ElementVirtual_Live"."ID" = "Element_Live"."ID"
WHERE ("Element_Live"."ID" = ?)
AND ("Element_Live"."ClassName" IN (?))
ORDER BY "Element_Live"."Sort" ASC
LIMIT 1
0.0004s
0057: 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"."ID" = ?)
ORDER BY "Element_Live"."Sort" ASC
LIMIT 1
0.0006s
0058: SELECT DISTINCT "ElementalArea_Live"."ClassName", "ElementalArea_Live"."LastEdited", "ElementalArea_Live"."Created", "ElementalArea_Live"."Version", "ElementalArea_Live"."OwnerClassName", "ElementalArea_Live"."TopPageID", "ElementalArea_Live"."ID",
CASE WHEN "ElementalArea_Live"."ClassName" IS NOT NULL THEN "ElementalArea_Live"."ClassName"
ELSE 'DNADesign\\Elemental\\Models\\ElementalArea' END AS "RecordClassName"
FROM "ElementalArea_Live"
WHERE ("ElementalArea_Live"."ID" = ?)
LIMIT 1
0.0005s
0059: SELECT DISTINCT count("MD_Blocks_FaqGroup_Item_Live"."ID") AS "Count"
FROM "MD_Blocks_FaqGroup_Item_Live"
WHERE ("MD_Blocks_FaqGroup_Item_Live"."FaqID" = ?)
0.0037s
0060: SELECT DISTINCT MAX("MD_Blocks_FaqGroup_Item_Live"."LastEdited")
FROM "MD_Blocks_FaqGroup_Item_Live"
WHERE ("MD_Blocks_FaqGroup_Item_Live"."FaqID" = ?)
0.0004s
0061: SELECT DISTINCT count("MD_Blocks_FaqGroup_Item_Live"."ID") AS "Count"
FROM "MD_Blocks_FaqGroup_Item_Live"
WHERE ("MD_Blocks_FaqGroup_Item_Live"."FaqID" = ?)
0.0003s
0062: SELECT DISTINCT MAX("MD_Blocks_FaqGroup_Item_Live"."LastEdited")
FROM "MD_Blocks_FaqGroup_Item_Live"
WHERE ("MD_Blocks_FaqGroup_Item_Live"."FaqID" = ?)
0.0002s
0063: SELECT DISTINCT count("MD_Blocks_FaqGroup_Item_Live"."ID") AS "Count"
FROM "MD_Blocks_FaqGroup_Item_Live"
WHERE ("MD_Blocks_FaqGroup_Item_Live"."FaqID" = ?)
0.0003s
0064: SELECT DISTINCT MAX("MD_Blocks_FaqGroup_Item_Live"."LastEdited")
FROM "MD_Blocks_FaqGroup_Item_Live"
WHERE ("MD_Blocks_FaqGroup_Item_Live"."FaqID" = ?)
0.0002s
0065: SELECT DISTINCT count("MD_Blocks_FaqGroup_Item_Live"."ID") AS "Count"
FROM "MD_Blocks_FaqGroup_Item_Live"
WHERE ("MD_Blocks_FaqGroup_Item_Live"."FaqID" = ?)
0.0003s
0066: SELECT DISTINCT MAX("MD_Blocks_FaqGroup_Item_Live"."LastEdited")
FROM "MD_Blocks_FaqGroup_Item_Live"
WHERE ("MD_Blocks_FaqGroup_Item_Live"."FaqID" = ?)
0.0003s
0067: SELECT DISTINCT "File_Live"."ClassName", "File_Live"."LastEdited", "File_Live"."Created", "File_Live"."Version", "File_Live"."UserFormUpload", "File_Live"."CanViewType", "File_Live"."CanEditType", "File_Live"."Name", "File_Live"."Title", "File_Live"."ShowInSearch", "File_Live"."IsFolder", "File_Live"."SubsiteID", "File_Live"."ParentID", "File_Live"."OwnerID", "File_Live"."FileHash", "File_Live"."FileFilename", "File_Live"."FileVariant", "File_Live"."ID",
CASE WHEN "File_Live"."ClassName" IS NOT NULL THEN "File_Live"."ClassName"
ELSE 'SilverStripe\\Assets\\File' END AS "RecordClassName"
FROM "File_Live"
WHERE ("File_Live"."ID" = ?)
ORDER BY "File_Live"."Name" ASC
LIMIT 1
0.0004s
0068: 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
0069: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", "SiteTree_Live"."ElementalSearchContent", "SiteTree_Live"."MetaTitle", "SiteTree_Live"."CanViewType", "SiteTree_Live"."CanEditType", "SiteTree_Live"."Version", "SiteTree_Live"."Title", "SiteTree_Live"."URLSegment", "SiteTree_Live"."MenuTitle", "SiteTree_Live"."Content", "SiteTree_Live"."MetaDescription", "SiteTree_Live"."ExtraMeta", "SiteTree_Live"."ShowInMenus", "SiteTree_Live"."ShowInSearch", "SiteTree_Live"."Sort", "SiteTree_Live"."HasBrokenFile", "SiteTree_Live"."HasBrokenLink", "SiteTree_Live"."ReportClass", "SiteTree_Live"."SubsiteID", "SiteTree_Live"."ParentID", "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 ("Page_Live"."ElementalAreaID" = ?)
AND ("SiteTree_Live"."ClassName" = ?)
AND ("SiteTree_Live"."ClassName" IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?))
AND ("SiteTree_Live"."SubsiteID" IN (5))
ORDER BY "SiteTree_Live"."Sort" ASC
LIMIT 1
0.0009s
0070: 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
0071: 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
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", "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 ("Page_Live"."ElementalAreaID" = ?)
AND ("SiteTree_Live"."ClassName" = ?)
AND ("SiteTree_Live"."ClassName" IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?))
AND ("SiteTree_Live"."SubsiteID" IN (5))
ORDER BY "SiteTree_Live"."Sort" ASC
LIMIT 1
0.0007s
0073: 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 (("Page_Live"."ElementalAreaID" = ?))
AND ("SiteTree_Live"."ClassName" IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?))
AND ("SiteTree_Live"."SubsiteID" IN (5))
ORDER BY "SiteTree_Live"."Sort" ASC
LIMIT 1
0.0014s
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", "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 (("Page_Live"."ElementalAreaID" = ?))
AND ("SiteTree_Live"."ClassName" IN (?))
AND ("SiteTree_Live"."SubsiteID" IN (5))
ORDER BY "SiteTree_Live"."Sort" ASC
LIMIT 1
0.0008s
0075: 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", 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" 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", "DonatePage_Live"."ThemedHeading", "DonatePage_Live"."ThemedButton", "DonatePage_Live"."ThemedButton1", "DonatePage_Live"."Message", "DonatePage_Live"."DonationBoxMessage", "DonatePage_Live"."ButtonLinkID", "DonatePage_Live"."HeaderLinkID", "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 "DonatePage_Live" ON "DonatePage_Live"."ID" = "SiteTree_Live"."ID"
WHERE (("Page_Live"."ElementalAreaID" = ?))
AND ("SiteTree_Live"."ClassName" IN (?))
AND ("SiteTree_Live"."SubsiteID" IN (5))
ORDER BY "SiteTree_Live"."Sort" ASC
LIMIT 1
0.0014s
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", CASE WHEN "SiteTree_Live"."ClassName" IN ('SilverStripe\\CMS\\Model\\SiteTree', '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 "SiteTree_Live"."Content" WHEN "SiteTree_Live"."ClassName" IN ('App\\Page\\EventDetailsPage') THEN "EventDetailsPage_Live"."Content" WHEN "SiteTree_Live"."ClassName" IN ('App\\Page\\EventDetailsPage') THEN "EventDetailsPage_Live"."Content" ELSE NULL END AS "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", "EventDetailsPage_Live"."Date", "EventDetailsPage_Live"."Address", "EventDetailsPage_Live"."Cost", "EventDetailsPage_Live"."PersonSeat", "EventDetailsPage_Live"."OnlineSeat", "EventDetailsPage_Live"."AvailablePersonal", "EventDetailsPage_Live"."AvailableOnline", "EventDetailsPage_Live"."NotificationEmails", "EventDetailsPage_Live"."EmailTemplateID", "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 "EventDetailsPage_Live" ON "EventDetailsPage_Live"."ID" = "SiteTree_Live"."ID"
WHERE (("Page_Live"."ElementalAreaID" = ?))
AND ("SiteTree_Live"."ClassName" IN (?))
AND ("SiteTree_Live"."SubsiteID" IN (5))
ORDER BY "SiteTree_Live"."Sort" ASC
LIMIT 1
0.001s
0077: 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", "EventHolderPage_Live"."PostsPerPage", "EventHolderPage_Live"."SmartsheetAPI_Ref", "EventHolderPage_Live"."FeaturedEvent", "EventHolderPage_Live"."EventPolicyID", "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 "EventHolderPage_Live" ON "EventHolderPage_Live"."ID" = "SiteTree_Live"."ID"
WHERE (("Page_Live"."ElementalAreaID" = ?)
OR ("EventHolderPage_Live"."EventPolicyID" = ?))
AND ("SiteTree_Live"."ClassName" IN (?))
AND ("SiteTree_Live"."SubsiteID" IN (5))
ORDER BY "SiteTree_Live"."Sort" ASC
LIMIT 1
0.0023s
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", "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", "EventPage_Live"."HideParentEventPolicy", "EventPage_Live"."ContinueEvent", "EventPage_Live"."ImageID", "EventPage_Live"."SecondaryElementalAreaID", "EventPage_Live"."AlternativeBookingLinkID", "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 "EventPage_Live" ON "EventPage_Live"."ID" = "SiteTree_Live"."ID"
WHERE (("Page_Live"."ElementalAreaID" = ?)
OR ("EventPage_Live"."SecondaryElementalAreaID" = ?))
AND ("SiteTree_Live"."ClassName" IN (?))
AND ("SiteTree_Live"."SubsiteID" IN (5))
ORDER BY "SiteTree_Live"."Sort" ASC
LIMIT 1
0.0015s
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", "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", "EventRegistrationPage_Live"."ConfirmTitle", "EventRegistrationPage_Live"."ConfirmContent", "EventRegistrationPage_Live"."ConfirmEmail", "EventRegistrationPage_Live"."ConfirmBody", "EventRegistrationPage_Live"."ConfirmClosingBody", "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 "EventRegistrationPage_Live" ON "EventRegistrationPage_Live"."ID" = "SiteTree_Live"."ID"
WHERE (("Page_Live"."ElementalAreaID" = ?))
AND ("SiteTree_Live"."ClassName" IN (?))
AND ("SiteTree_Live"."SubsiteID" IN (5))
ORDER BY "SiteTree_Live"."Sort" ASC
LIMIT 1
0.0009s
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", "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", "HomePage_Live"."AutoPlaySpeed", "HomePage_Live"."IsDotsEnabled", "HomePage_Live"."IsButtonsEnabled", "HomePage_Live"."PaginationColor", "HomePage_Live"."Style", "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 "HomePage_Live" ON "HomePage_Live"."ID" = "SiteTree_Live"."ID"
WHERE (("Page_Live"."ElementalAreaID" = ?))
AND ("SiteTree_Live"."ClassName" IN (?))
AND ("SiteTree_Live"."SubsiteID" IN (5))
ORDER BY "SiteTree_Live"."Sort" ASC
LIMIT 1
0.0029s
0081: 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", "LocationPage_Live"."LocationAnchorContent", "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 "LocationPage_Live" ON "LocationPage_Live"."ID" = "SiteTree_Live"."ID"
WHERE (("Page_Live"."ElementalAreaID" = ?))
AND ("SiteTree_Live"."ClassName" IN (?))
AND ("SiteTree_Live"."SubsiteID" IN (5))
ORDER BY "SiteTree_Live"."Sort" ASC
LIMIT 1
0.0016s
0082: 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", CASE WHEN "SiteTree_Live"."ClassName" IN ('SilverStripe\\CMS\\Model\\SiteTree', '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 "SiteTree_Live"."Content" WHEN "SiteTree_Live"."ClassName" IN ('App\\Page\\ReferralFormPage') THEN "ReferralFormPage_Live"."Content" WHEN "SiteTree_Live"."ClassName" IN ('App\\Page\\ReferralFormPage') THEN "ReferralFormPage_Live"."Content" ELSE NULL END AS "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", "ReferralFormPage_Live"."ReferralTitle", "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 "ReferralFormPage_Live" ON "ReferralFormPage_Live"."ID" = "SiteTree_Live"."ID"
WHERE (("Page_Live"."ElementalAreaID" = ?))
AND ("SiteTree_Live"."ClassName" IN (?))
AND ("SiteTree_Live"."SubsiteID" IN (5))
ORDER BY "SiteTree_Live"."Sort" ASC
LIMIT 1
0.0021s
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", "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 (("Page_Live"."ElementalAreaID" = ?))
AND ("SiteTree_Live"."ClassName" IN (?))
AND ("SiteTree_Live"."SubsiteID" IN (5))
ORDER BY "SiteTree_Live"."Sort" ASC
LIMIT 1
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", "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 (("Page_Live"."ElementalAreaID" = ?))
AND ("SiteTree_Live"."ClassName" IN (?))
AND ("SiteTree_Live"."SubsiteID" IN (5))
ORDER BY "SiteTree_Live"."Sort" ASC
LIMIT 1
0.0006s
0085: 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 (("Page_Live"."ElementalAreaID" = ?))
AND ("SiteTree_Live"."ClassName" IN (?))
AND ("SiteTree_Live"."SubsiteID" IN (5))
ORDER BY "SiteTree_Live"."Sort" ASC
LIMIT 1
0.0006s
0086: 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 (("Page_Live"."ElementalAreaID" = ?))
AND ("SiteTree_Live"."ClassName" IN (?))
AND ("SiteTree_Live"."SubsiteID" IN (5))
ORDER BY "SiteTree_Live"."Sort" ASC
LIMIT 1
0.0007s
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", "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", "MD_Page_ContactPage_Live"."ThanksMessage", "MD_Page_ContactPage_Live"."SendSubmissionTo", "MD_Page_ContactPage_Live"."IsPhoneAndEmailHidden", "MD_Page_ContactPage_Live"."SendConfirmation", "MD_Page_ContactPage_Live"."ConfirmationEmailSubject", "MD_Page_ContactPage_Live"."ConfirmationEmailMessage", "MD_Page_ContactPage_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"
FROM "SiteTree_Live" LEFT JOIN "Page_Live" ON "Page_Live"."ID" = "SiteTree_Live"."ID" LEFT JOIN "MD_Page_ContactPage_Live" ON "MD_Page_ContactPage_Live"."ID" = "SiteTree_Live"."ID"
WHERE (("Page_Live"."ElementalAreaID" = ?)
OR ("MD_Page_ContactPage_Live"."SecondaryElementalAreaID" = ?))
AND ("SiteTree_Live"."ClassName" IN (?))
AND ("SiteTree_Live"."SubsiteID" IN (5))
ORDER BY "SiteTree_Live"."Sort" ASC
LIMIT 1
0.0024s
0088: 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", "MD_Page_ServiceHolderPage_Live"."SectionTitle", "MD_Page_ServiceHolderPage_Live"."SectionContent", "MD_Page_ServiceHolderPage_Live"."ChildrenLayout", "MD_Page_ServiceHolderPage_Live"."ZoomStyle", "MD_Page_ServiceHolderPage_Live"."ImageType", "MD_Page_ServiceHolderPage_Live"."ContentStyleAlignment", "MD_Page_ServiceHolderPage_Live"."IsShadow", "MD_Page_ServiceHolderPage_Live"."BorderRadius", "MD_Page_ServiceHolderPage_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"
FROM "SiteTree_Live" LEFT JOIN "Page_Live" ON "Page_Live"."ID" = "SiteTree_Live"."ID" LEFT JOIN "MD_Page_ServiceHolderPage_Live" ON "MD_Page_ServiceHolderPage_Live"."ID" = "SiteTree_Live"."ID"
WHERE (("Page_Live"."ElementalAreaID" = ?)
OR ("MD_Page_ServiceHolderPage_Live"."SecondaryElementalAreaID" = ?))
AND ("SiteTree_Live"."ClassName" IN (?))
AND ("SiteTree_Live"."SubsiteID" IN (5))
ORDER BY "SiteTree_Live"."Sort" ASC
LIMIT 1
0.0057s
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", "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", "ErrorPage_Live"."ErrorCode", "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 "ErrorPage_Live" ON "ErrorPage_Live"."ID" = "SiteTree_Live"."ID"
WHERE (("Page_Live"."ElementalAreaID" = ?))
AND ("SiteTree_Live"."ClassName" IN (?))
AND ("SiteTree_Live"."SubsiteID" IN (5))
ORDER BY "SiteTree_Live"."Sort" ASC
LIMIT 1
0.0025s
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", "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", "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"
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 (("Page_Live"."ElementalAreaID" = ?)
OR ("Blog_Live"."SecondaryElementalAreaID" = ?))
AND ("SiteTree_Live"."ClassName" IN (?))
AND ("SiteTree_Live"."SubsiteID" IN (5))
ORDER BY "SiteTree_Live"."Sort" ASC
LIMIT 1
0.0012s
0091: 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" = ?)
OR ("BlogPost_Live"."SecondaryElementalAreaID" = ?))
AND ("SiteTree_Live"."ClassName" IN (?))
AND ("SiteTree_Live"."SubsiteID" IN (5))
AND ("PublishDate" < '2026-08-11 16:07:29')
ORDER BY "_SortColumn0" DESC, "BlogPost_Live"."PublishDate" DESC
LIMIT 1
0.0026s
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", "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", "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"
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 (("Page_Live"."ElementalAreaID" = ?))
AND ("SiteTree_Live"."ClassName" IN (?))
AND ("SiteTree_Live"."SubsiteID" IN (5))
ORDER BY "SiteTree_Live"."Sort" ASC
LIMIT 1
0.001s
0093: 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", "VirtualPage_Live"."VersionID", "VirtualPage_Live"."CustomMetaDescription", "VirtualPage_Live"."CustomExtraMeta", "VirtualPage_Live"."CopyContentFromID", "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 "VirtualPage_Live" ON "VirtualPage_Live"."ID" = "SiteTree_Live"."ID"
WHERE (("Page_Live"."ElementalAreaID" = ?))
AND ("SiteTree_Live"."ClassName" IN (?, ?))
AND ("SiteTree_Live"."SubsiteID" IN (5))
ORDER BY "SiteTree_Live"."Sort" ASC
LIMIT 1
0.0022s
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", "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", "UserDefinedForm_Live"."SubmitButtonText", "UserDefinedForm_Live"."ClearButtonText", "UserDefinedForm_Live"."OnCompleteMessage", "UserDefinedForm_Live"."ShowClearButton", "UserDefinedForm_Live"."DisableSaveSubmissions", "UserDefinedForm_Live"."EnableLiveValidation", "UserDefinedForm_Live"."DisplayErrorMessagesAtTop", "UserDefinedForm_Live"."DisableAuthenicatedFinishAction", "UserDefinedForm_Live"."DisableCsrfSecurityToken", "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 "UserDefinedForm_Live" ON "UserDefinedForm_Live"."ID" = "SiteTree_Live"."ID"
WHERE (("Page_Live"."ElementalAreaID" = ?))
AND ("SiteTree_Live"."ClassName" IN (?, ?))
AND ("SiteTree_Live"."SubsiteID" IN (5))
ORDER BY "SiteTree_Live"."Sort" ASC
LIMIT 1
0.0036s
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", "VirtualPage_Live"."VersionID", "VirtualPage_Live"."CustomMetaDescription", "VirtualPage_Live"."CustomExtraMeta", "VirtualPage_Live"."CopyContentFromID", "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 "VirtualPage_Live" ON "VirtualPage_Live"."ID" = "SiteTree_Live"."ID"
WHERE (("Page_Live"."ElementalAreaID" = ?))
AND ("SiteTree_Live"."ClassName" IN (?))
AND ("SiteTree_Live"."SubsiteID" IN (5))
ORDER BY "SiteTree_Live"."Sort" ASC
LIMIT 1
0.001s
0096: 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", CASE WHEN "SiteTree_Live"."ClassName" IN ('SilverStripe\\CMS\\Model\\SiteTree', '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 "SiteTree_Live"."Content" WHEN "SiteTree_Live"."ClassName" IN ('App\\Page\\ContactPage') THEN "ContactPage_Live"."Content" WHEN "SiteTree_Live"."ClassName" IN ('App\\Page\\ContactPage') THEN "ContactPage_Live"."Content" ELSE NULL END AS "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", "UserDefinedForm_Live"."SubmitButtonText", "UserDefinedForm_Live"."ClearButtonText", "UserDefinedForm_Live"."OnCompleteMessage", "UserDefinedForm_Live"."ShowClearButton", "UserDefinedForm_Live"."DisableSaveSubmissions", "UserDefinedForm_Live"."EnableLiveValidation", "UserDefinedForm_Live"."DisplayErrorMessagesAtTop", "UserDefinedForm_Live"."DisableAuthenicatedFinishAction", "UserDefinedForm_Live"."DisableCsrfSecurityToken", "ContactPage_Live"."HeadingColumnAlignment", "ContactPage_Live"."FormTitle", "ContactPage_Live"."InformationTitle", "ContactPage_Live"."AdditionalInformationTitle", "ContactPage_Live"."Phone", "ContactPage_Live"."PhoneAlt", "ContactPage_Live"."PhoneAltLabel", "ContactPage_Live"."Email", "ContactPage_Live"."PostalAddress", "ContactPage_Live"."PhysicalAddress", "ContactPage_Live"."ThanksMessage", "ContactPage_Live"."Latitude", "ContactPage_Live"."Longitude", "ContactPage_Live"."MapZoom", "ContactPage_Live"."HideMap", "ContactPage_Live"."ExtraContent", "ContactPage_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"
FROM "SiteTree_Live" LEFT JOIN "Page_Live" ON "Page_Live"."ID" = "SiteTree_Live"."ID" LEFT JOIN "UserDefinedForm_Live" ON "UserDefinedForm_Live"."ID" = "SiteTree_Live"."ID" LEFT JOIN "ContactPage_Live" ON "ContactPage_Live"."ID" = "SiteTree_Live"."ID"
WHERE (("Page_Live"."ElementalAreaID" = ?)
OR ("ContactPage_Live"."SecondaryElementalAreaID" = ?))
AND ("SiteTree_Live"."ClassName" IN (?))
AND ("SiteTree_Live"."SubsiteID" IN (5))
ORDER BY "SiteTree_Live"."Sort" ASC
LIMIT 1
0.004s
0097: SELECT DISTINCT count("MD_Blocks_Tile_Item_Live"."ID") AS "Count"
FROM "MD_Blocks_Tile_Item_Live"
WHERE ("MD_Blocks_Tile_Item_Live"."TileID" = ?)
0.003s
0098: SELECT DISTINCT MAX("MD_Blocks_Tile_Item_Live"."LastEdited")
FROM "MD_Blocks_Tile_Item_Live"
WHERE ("MD_Blocks_Tile_Item_Live"."TileID" = ?)
0.0005s
0099: 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
0100: 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 ("Page_Live"."ElementalAreaID" = ?)
AND ("SiteTree_Live"."ClassName" = ?)
AND ("SiteTree_Live"."ClassName" IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?))
AND ("SiteTree_Live"."SubsiteID" IN (5))
ORDER BY "SiteTree_Live"."Sort" ASC
LIMIT 1
0.0016s
0101: SELECT DISTINCT "ElementalArea_Live"."ClassName", "ElementalArea_Live"."LastEdited", "ElementalArea_Live"."Created", "ElementalArea_Live"."Version", "ElementalArea_Live"."OwnerClassName", "ElementalArea_Live"."TopPageID", "ElementalArea_Live"."ID",
CASE WHEN "ElementalArea_Live"."ClassName" IS NOT NULL THEN "ElementalArea_Live"."ClassName"
ELSE 'DNADesign\\Elemental\\Models\\ElementalArea' END AS "RecordClassName"
FROM "ElementalArea_Live"
WHERE ("ElementalArea_Live"."ID" = ?)
LIMIT 1
0.0005s
0102: SELECT DISTINCT "Element_Live"."ClassName", "Element_Live"."LastEdited", "Element_Live"."Created", "MD_Blocks_Newsletter_Live"."NewsletterThanksMessage", "MD_Blocks_Newsletter_Live"."SubmissionEmail", "MD_Blocks_Newsletter_Live"."Content", "MD_Blocks_Newsletter_Live"."ShowPhone", "MD_Blocks_Newsletter_Live"."ShowCompany", "MD_Blocks_Newsletter_Live"."ActiveCampaignTag", CASE WHEN "Element_Live"."ClassName" IN ('DNADesign\\Elemental\\Models\\BaseElement', 'App\\Element\\ContactBlock', 'App\\Element\\DownloadResourceBlock', 'App\\Element\\EventBlock', 'App\\Element\\PageLinkBlock', 'App\\Element\\ServiceWizardBlock', 'App\\Element\\StatsBlock', 'App\\Element\\VideoBlock', 'App\\Element\\VolunteerBlock', 'App\\Element\\WorkBlock', 'MintDesign\\Blocks\\ArticleGroup\\ArticleGroup', 'MintDesign\\Blocks\\CallToAction\\CallToAction', 'MintDesign\\Blocks\\Column\\Column', 'MintDesign\\Blocks\\ColumnCarousel\\ColumnCarousel', 'MintDesign\\Blocks\\FaqGroup\\FaqGroup', 'MintDesign\\Blocks\\Gallery\\Gallery', 'MintDesign\\Blocks\\GoogleMaps\\GoogleMaps', 'MintDesign\\Blocks\\GoogleReviews\\GoogleReviews', 'MintDesign\\Blocks\\HorizontalRule\\HorizontalRule', 'MintDesign\\Blocks\\IconGroup\\IconGroup', 'MintDesign\\Blocks\\Iframe\\Iframe', 'MintDesign\\Blocks\\ImageCarousel\\ImageCarousel', 'MintDesign\\Blocks\\Newsletter\\NewsletterBlock', 'MintDesign\\Blocks\\PartnerGroup\\PartnerGroup', 'MintDesign\\Blocks\\Pricing\\Pricing', 'MintDesign\\Blocks\\RawHtml\\RawHtml', 'MintDesign\\Blocks\\Spacer\\Spacer', 'MintDesign\\Blocks\\Testimonials\\Testimonials', 'MintDesign\\Blocks\\Tile\\Tile', 'MintDesign\\Blocks\\WysiwygWithImage\\WysiwygWithImage', 'DNADesign\\Elemental\\Models\\ElementContent', 'DNADesign\\ElementalUserForms\\Model\\ElementForm', 'DNADesign\\ElementalVirtual\\Model\\ElementVirtual') THEN "Element_Live"."Title" WHEN "Element_Live"."ClassName" IN ('MintDesign\\Blocks\\Newsletter\\NewsletterBlock') THEN "MD_Blocks_Newsletter_Live"."Title" ELSE NULL END AS "Title", "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_Newsletter_Live" ON "MD_Blocks_Newsletter_Live"."ID" = "Element_Live"."ID"
WHERE ("Element_Live"."ID" = ?)
AND ("Element_Live"."ClassName" IN (?))
ORDER BY "Element_Live"."Sort" ASC
LIMIT 1
0.0039s
0106: SELECT COUNT(ID) as "COUNT" FROM "SiteConfig" LIMIT 1
0.0004s
0107: SELECT DISTINCT count("MenuItem"."ID") AS "Count"
FROM "MenuItem"
0.0002s
0108: SELECT DISTINCT MAX("MenuItem"."LastEdited")
FROM "MenuItem"
0.0002s
0109: SELECT "Version" FROM "SiteTree" WHERE "ID" = ?
0.0005s
0110: 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
0111: 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
0112: 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
0113: 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
0114: 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
0115: 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
0116: 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
0117: 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.0009s
0118: 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
0119: 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.0006s
0120: 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.0007s
First responders are peer support people in your workplace who can support employees experiencing domestic violence, and also support managers. This is a one day in-person training or delivered online over two consecutive mornings. It helps First Responders to:
understand the boundaries of the role
recognise signs and respond safely and appropriately
provide workplace support, safety and wellbeing planning, and refer to specialist community support and
understand broadly how an employer can respond to employees who perpetrate domestic violence, and provide support to change
Organisations can book in-house First Responder Training for their venue or online. (DVFREE Tick Partner Organisation First Responders can attend Advanced and Experienced level training in years 3 and 4.)
Individuals can register to attend open First Responder Training either online or in-person in Auckland. If your organisation plans to train more than a few people, we strongly recommend in-house training so that the training can focus on the context of your particular organisation and help build a stronger team of first responders.
Managers play a key role in supporting a team member who experiences domestic violence and are most likely to see the signs and be able to ask some initial questions. DVFREE Tick partners can access the DVFREE Manager Online Learning Programme, included in our DVFREE Tick Partnership annual fee.
While our best practice recommendation is to provide live training for initial manager training, we can also deliver this training online. Either option is 3.5 hours long.
DVFREE training helps managers to:
understand the boundaries of a manager’s role
recognise signs and respond safely and with empathy
provide workplace support, workplace safety and wellbeing planning, and support to connect with specialist community support, and
understand broadly how an employer can provide accountability and support for employees who use harmful behaviour within a family and domestic relationship
Contact us for a more in-depth overview of DVFREE manager training.
We generally only deliver manager training for an organisation that has already trained some first responders. Read our Guidelines to understand why this is important.
DVFREE Guidelines and Policy Consultation
Guidelines for a DVFREE Workplace Programme
Download our free Guidelines for a DVFREE Workplace Programme to help you create a sustainable, best practice workplace response to domestic violence, that supports the safety and wellbeing of employees who experience domestic violence and meets your legal obligations under relevant employment laws.
Policy Consultation
DVFREE Policy experts can help you to create or improve your Domestic Violence Policy, procedures, or other relevant documents such as content of your intranet or wellbeing guide whether they are for employees, customers or both.
This module was created in collaboration by Westpac and Shine, and updated in 2025. It takes less than 1 hour to complete and provides a good introduction to family violence within a workplace context.
Awareness sessions
A Shine expert from our training team can speak to your group and help raise awareness of domestic violence. These sessions can help build a foundation for a domestic violence staff programme.
Contact us to arrange an Awareness Session for your team.
Be creative!
There are many ways to engage, inspire and educate staff about domestic violence.
One idea is to participate in Shine’s Light it Orange campaign to raise funds and awareness or you may want to ask your local domestic violence service provider about how you can support their work.
Want to get started?
Get in touch with our team today to discuss your needs relating to your workplace and/or customer response to family violence.
DVFREE offers a range of services, including domestic violence policy consultation, awareness raising activity, and staff training. The DVFREE Tick, awarded by Shine, is a mark of confidence that an employer has taken meaningful steps to create a domestic violence-free workplace. DVFREE is brought to you by Shine, a highly reputable specialist domestic violence service provider that has been helping people who experience domestic violence to become safer since 1990. All surplus funds from DVFREE service fees support the Shine frontline services.