0002: SHOW DATABASES LIKE 'SS\_wearebvhm\_dev'
0.0004s
0003: SELECT DISTINCT "Fluent_Domain"."ClassName", "Fluent_Domain"."LastEdited", "Fluent_Domain"."Created", "Fluent_Domain"."Domain", "Fluent_Domain"."DefaultLocaleID", "Fluent_Domain"."ID",
CASE WHEN "Fluent_Domain"."ClassName" IS NOT NULL THEN "Fluent_Domain"."ClassName"
ELSE 'TractorCow\\Fluent\\Model\\Domain' END AS "RecordClassName"
FROM "Fluent_Domain"
0.0003s
0004: SELECT DISTINCT "Fluent_Locale"."ClassName", "Fluent_Locale"."LastEdited", "Fluent_Locale"."Created", "Fluent_Locale"."Title", "Fluent_Locale"."Locale", "Fluent_Locale"."URLSegment", "Fluent_Locale"."IsGlobalDefault", "Fluent_Locale"."UseDefaultCode", "Fluent_Locale"."Sort", "Fluent_Locale"."Timezone", "Fluent_Locale"."DomainID", "Fluent_Locale"."ID",
CASE WHEN "Fluent_Locale"."ClassName" IS NOT NULL THEN "Fluent_Locale"."ClassName"
ELSE 'TractorCow\\Fluent\\Model\\Locale' END AS "RecordClassName"
FROM "Fluent_Locale"
ORDER BY "Fluent_Locale"."Sort" ASC, "Fluent_Locale"."Locale" ASC
0.0003s
0005: SHOW FULL TABLES WHERE Table_Type != 'VIEW'
0.0025s
0006: SELECT DISTINCT "Fluent_FallbackLocale"."ClassName", "Fluent_FallbackLocale"."LastEdited", "Fluent_FallbackLocale"."Created", "Fluent_FallbackLocale"."Sort", "Fluent_FallbackLocale"."ParentID", "Fluent_FallbackLocale"."LocaleID", "Fluent_FallbackLocale"."ID",
CASE WHEN "Fluent_FallbackLocale"."ClassName" IS NOT NULL THEN "Fluent_FallbackLocale"."ClassName"
ELSE 'TractorCow\\Fluent\\Model\\FallbackLocale' END AS "RecordClassName"
FROM "Fluent_FallbackLocale"
WHERE ("Fluent_FallbackLocale"."ParentID" = ?)
ORDER BY "Fluent_FallbackLocale"."Sort" ASC
0.0005s
0007: SELECT DISTINCT "Fluent_Locale"."ClassName", "Fluent_Locale"."LastEdited", "Fluent_Locale"."Created", "Fluent_Locale"."Title", "Fluent_Locale"."Locale", "Fluent_Locale"."URLSegment", "Fluent_Locale"."IsGlobalDefault", "Fluent_Locale"."UseDefaultCode", "Fluent_Locale"."Sort", "Fluent_Locale"."Timezone", "Fluent_Locale"."DomainID", "Fluent_Locale"."ID",
CASE WHEN "Fluent_Locale"."ClassName" IS NOT NULL THEN "Fluent_Locale"."ClassName"
ELSE 'TractorCow\\Fluent\\Model\\Locale' END AS "RecordClassName"
FROM "Fluent_Locale"
WHERE ("Fluent_Locale"."ID" = ?)
ORDER BY "Fluent_Locale"."Sort" ASC, "Fluent_Locale"."Locale" ASC
LIMIT 1
0.0004s
0008: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."CanViewType", "SiteTree_Live"."CanEditType", "SiteTree_Live"."Version", CASE
WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."URLSegment"
WHEN "SiteTree_Localised_es_419"."ID" IS NOT NULL THEN "SiteTree_Localised_es_419"."URLSegment"
ELSE "SiteTree_Live"."URLSegment" END
AS "URLSegment", CASE
WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."Title"
WHEN "SiteTree_Localised_es_419"."ID" IS NOT NULL THEN "SiteTree_Localised_es_419"."Title"
ELSE "SiteTree_Live"."Title" END
AS "Title", CASE
WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."MenuTitle"
WHEN "SiteTree_Localised_es_419"."ID" IS NOT NULL THEN "SiteTree_Localised_es_419"."MenuTitle"
ELSE "SiteTree_Live"."MenuTitle" END
AS "MenuTitle", CASE
WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."Content"
WHEN "SiteTree_Localised_es_419"."ID" IS NOT NULL THEN "SiteTree_Localised_es_419"."Content"
ELSE "SiteTree_Live"."Content" END
AS "Content", CASE
WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."MetaDescription"
WHEN "SiteTree_Localised_es_419"."ID" IS NOT NULL THEN "SiteTree_Localised_es_419"."MetaDescription"
ELSE "SiteTree_Live"."MetaDescription" END
AS "MetaDescription", "SiteTree_Live"."ExtraMeta", "SiteTree_Live"."ShowInMenus", "SiteTree_Live"."ShowInSearch", "SiteTree_Live"."Sort", "SiteTree_Live"."HasBrokenFile", "SiteTree_Live"."HasBrokenLink", CASE
WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."ReportClass"
WHEN "SiteTree_Localised_es_419"."ID" IS NOT NULL THEN "SiteTree_Localised_es_419"."ReportClass"
ELSE "SiteTree_Live"."ReportClass" END
AS "ReportClass", "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", 'en_US' AS "Locale", CASE WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN 'en_US'
WHEN "SiteTree_Localised_es_419"."ID" IS NOT NULL THEN 'es_419'
ELSE NULL END AS "SourceLocale"
FROM "SiteTree_Live" LEFT JOIN "SiteTree_Localised_Live" AS "SiteTree_Localised_en_US" ON "SiteTree_Live"."ID" = "SiteTree_Localised_en_US"."RecordID" AND "SiteTree_Localised_en_US"."Locale" = ? LEFT JOIN "SiteTree_Localised_Live" AS "SiteTree_Localised_es_419" ON "SiteTree_Live"."ID" = "SiteTree_Localised_es_419"."RecordID" AND "SiteTree_Localised_es_419"."Locale" = ?
WHERE (COALESCE("SiteTree_Localised_en_US"."URLSegment", "SiteTree_Localised_es_419"."URLSegment", "SiteTree_Live"."URLSegment") = ?)
AND ("SiteTree_Live"."ParentID" = ?)
AND (("SiteTree_Localised_en_US"."ID" IS NOT NULL) OR ("SiteTree_Localised_es_419"."ID" IS NOT NULL))
ORDER BY "SiteTree_Live"."Sort" ASC
LIMIT 1
0.0017s
0009: SELECT DISTINCT "SiteConfig"."ClassName", "SiteConfig"."LastEdited", "SiteConfig"."Created", "SiteConfig"."LinuxRebootNotificationEmailCSV", "SiteConfig"."PrimaryColor", "SiteConfig"."SecondaryColor", "SiteConfig"."SuccessColor", "SiteConfig"."DangerColor", "SiteConfig"."WarningColor", "SiteConfig"."InfoColor", "SiteConfig"."LightColor", "SiteConfig"."DarkColor", "SiteConfig"."NavbarBg", "SiteConfig"."NavbarBgPattern", "SiteConfig"."BodyFont", "SiteConfig"."HeadlineFont", "SiteConfig"."MonospaceFont", CASE
WHEN "SiteConfig_Localised_en_US"."ID" IS NOT NULL THEN "SiteConfig_Localised_en_US"."Footer"
WHEN "SiteConfig_Localised_es_419"."ID" IS NOT NULL THEN "SiteConfig_Localised_es_419"."Footer"
ELSE "SiteConfig"."Footer" END
AS "Footer", "SiteConfig"."FooterBg", "SiteConfig"."FooterBgPattern", "SiteConfig"."DefaultBg", "SiteConfig"."DefaultBgPattern", "SiteConfig"."CustomCSS", CASE
WHEN "SiteConfig_Localised_en_US"."ID" IS NOT NULL THEN "SiteConfig_Localised_en_US"."Title"
WHEN "SiteConfig_Localised_es_419"."ID" IS NOT NULL THEN "SiteConfig_Localised_es_419"."Title"
ELSE "SiteConfig"."Title" END
AS "Title", CASE
WHEN "SiteConfig_Localised_en_US"."ID" IS NOT NULL THEN "SiteConfig_Localised_en_US"."Tagline"
WHEN "SiteConfig_Localised_es_419"."ID" IS NOT NULL THEN "SiteConfig_Localised_es_419"."Tagline"
ELSE "SiteConfig"."Tagline" END
AS "Tagline", "SiteConfig"."CanViewType", "SiteConfig"."CanEditType", "SiteConfig"."CanCreateTopLevelType", "SiteConfig"."LogoID", "SiteConfig"."FaviconSmallID", "SiteConfig"."FaviconLargeID", "SiteConfig"."ID",
CASE WHEN "SiteConfig"."ClassName" IS NOT NULL THEN "SiteConfig"."ClassName"
ELSE 'SilverStripe\\SiteConfig\\SiteConfig' END AS "RecordClassName", 'en_US' AS "Locale", CASE WHEN "SiteConfig_Localised_en_US"."ID" IS NOT NULL THEN 'en_US'
WHEN "SiteConfig_Localised_es_419"."ID" IS NOT NULL THEN 'es_419'
ELSE NULL END AS "SourceLocale"
FROM "SiteConfig" LEFT JOIN "SiteConfig_Localised" AS "SiteConfig_Localised_en_US" ON "SiteConfig"."ID" = "SiteConfig_Localised_en_US"."RecordID" AND "SiteConfig_Localised_en_US"."Locale" = ? LEFT JOIN "SiteConfig_Localised" AS "SiteConfig_Localised_es_419" ON "SiteConfig"."ID" = "SiteConfig_Localised_es_419"."RecordID" AND "SiteConfig_Localised_es_419"."Locale" = ?
LIMIT 1
0.0015s
0010: SELECT DISTINCT count(DISTINCT "Alert_Live"."ID") AS "Count"
FROM "Alert_Live" INNER JOIN "Page_Alerts" ON "Page_Alerts"."AlertID" = "Alert_Live"."ID" LEFT JOIN "Alert_Localised_Live" AS "Alert_Localised_en_US" ON "Alert_Live"."ID" = "Alert_Localised_en_US"."RecordID" AND "Alert_Localised_en_US"."Locale" = ? LEFT JOIN "Alert_Localised_Live" AS "Alert_Localised_es_419" ON "Alert_Live"."ID" = "Alert_Localised_es_419"."RecordID" AND "Alert_Localised_es_419"."Locale" = ?
WHERE ("Page_Alerts"."PageID" = ?)
AND ("Alert_Live"."Active" = ?)
AND (("Alert_Localised_en_US"."ID" IS NOT NULL) OR ("Alert_Localised_es_419"."ID" IS NOT NULL))
0.0006s
0011: 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"."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.0003s
0012: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."CanViewType", "SiteTree_Live"."CanEditType", "SiteTree_Live"."Version", CASE
WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."URLSegment"
WHEN "SiteTree_Localised_es_419"."ID" IS NOT NULL THEN "SiteTree_Localised_es_419"."URLSegment"
ELSE "SiteTree_Live"."URLSegment" END
AS "URLSegment", CASE
WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."Title"
WHEN "SiteTree_Localised_es_419"."ID" IS NOT NULL THEN "SiteTree_Localised_es_419"."Title"
ELSE "SiteTree_Live"."Title" END
AS "Title", CASE
WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."MenuTitle"
WHEN "SiteTree_Localised_es_419"."ID" IS NOT NULL THEN "SiteTree_Localised_es_419"."MenuTitle"
ELSE "SiteTree_Live"."MenuTitle" END
AS "MenuTitle", CASE
WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."Content"
WHEN "SiteTree_Localised_es_419"."ID" IS NOT NULL THEN "SiteTree_Localised_es_419"."Content"
ELSE "SiteTree_Live"."Content" END
AS "Content", CASE
WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."MetaDescription"
WHEN "SiteTree_Localised_es_419"."ID" IS NOT NULL THEN "SiteTree_Localised_es_419"."MetaDescription"
ELSE "SiteTree_Live"."MetaDescription" END
AS "MetaDescription", "SiteTree_Live"."ExtraMeta", "SiteTree_Live"."ShowInMenus", "SiteTree_Live"."ShowInSearch", "SiteTree_Live"."Sort", "SiteTree_Live"."HasBrokenFile", "SiteTree_Live"."HasBrokenLink", CASE
WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."ReportClass"
WHEN "SiteTree_Localised_es_419"."ID" IS NOT NULL THEN "SiteTree_Localised_es_419"."ReportClass"
ELSE "SiteTree_Live"."ReportClass" END
AS "ReportClass", "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", 'en_US' AS "Locale", CASE WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN 'en_US'
WHEN "SiteTree_Localised_es_419"."ID" IS NOT NULL THEN 'es_419'
ELSE NULL END AS "SourceLocale"
FROM "SiteTree_Live" LEFT JOIN "SiteTree_Localised_Live" AS "SiteTree_Localised_en_US" ON "SiteTree_Live"."ID" = "SiteTree_Localised_en_US"."RecordID" AND "SiteTree_Localised_en_US"."Locale" = ? LEFT JOIN "SiteTree_Localised_Live" AS "SiteTree_Localised_es_419" ON "SiteTree_Live"."ID" = "SiteTree_Localised_es_419"."RecordID" AND "SiteTree_Localised_es_419"."Locale" = ?
WHERE ("SiteTree_Live"."ShowInMenus" = ?)
AND ("SiteTree_Live"."ParentID" = ?)
AND (("SiteTree_Localised_en_US"."ID" IS NOT NULL) OR ("SiteTree_Localised_es_419"."ID" IS NOT NULL))
ORDER BY "SiteTree_Live"."Sort" ASC
0.0012s
0013: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."CanViewType", "SiteTree_Live"."CanEditType", "SiteTree_Live"."Version", CASE
WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."URLSegment"
WHEN "SiteTree_Localised_es_419"."ID" IS NOT NULL THEN "SiteTree_Localised_es_419"."URLSegment"
ELSE "SiteTree_Live"."URLSegment" END
AS "URLSegment", CASE
WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."Title"
WHEN "SiteTree_Localised_es_419"."ID" IS NOT NULL THEN "SiteTree_Localised_es_419"."Title"
ELSE "SiteTree_Live"."Title" END
AS "Title", CASE
WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."MenuTitle"
WHEN "SiteTree_Localised_es_419"."ID" IS NOT NULL THEN "SiteTree_Localised_es_419"."MenuTitle"
ELSE "SiteTree_Live"."MenuTitle" END
AS "MenuTitle", CASE
WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."Content"
WHEN "SiteTree_Localised_es_419"."ID" IS NOT NULL THEN "SiteTree_Localised_es_419"."Content"
ELSE "SiteTree_Live"."Content" END
AS "Content", CASE
WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."MetaDescription"
WHEN "SiteTree_Localised_es_419"."ID" IS NOT NULL THEN "SiteTree_Localised_es_419"."MetaDescription"
ELSE "SiteTree_Live"."MetaDescription" END
AS "MetaDescription", "SiteTree_Live"."ExtraMeta", "SiteTree_Live"."ShowInMenus", "SiteTree_Live"."ShowInSearch", "SiteTree_Live"."Sort", "SiteTree_Live"."HasBrokenFile", "SiteTree_Live"."HasBrokenLink", CASE
WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."ReportClass"
WHEN "SiteTree_Localised_es_419"."ID" IS NOT NULL THEN "SiteTree_Localised_es_419"."ReportClass"
ELSE "SiteTree_Live"."ReportClass" END
AS "ReportClass", "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", 'en_US' AS "Locale", CASE WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN 'en_US'
WHEN "SiteTree_Localised_es_419"."ID" IS NOT NULL THEN 'es_419'
ELSE NULL END AS "SourceLocale"
FROM "SiteTree_Live" LEFT JOIN "SiteTree_Localised_Live" AS "SiteTree_Localised_en_US" ON "SiteTree_Live"."ID" = "SiteTree_Localised_en_US"."RecordID" AND "SiteTree_Localised_en_US"."Locale" = ? LEFT JOIN "SiteTree_Localised_Live" AS "SiteTree_Localised_es_419" ON "SiteTree_Live"."ID" = "SiteTree_Localised_es_419"."RecordID" AND "SiteTree_Localised_es_419"."Locale" = ?
WHERE ("SiteTree_Live"."ParentID" <> "SiteTree_Live"."ID")
AND ("SiteTree_Live"."ParentID" = ?)
AND ("SiteTree_Live"."ShowInMenus" = ?)
AND (("SiteTree_Localised_en_US"."ID" IS NOT NULL) OR ("SiteTree_Localised_es_419"."ID" IS NOT NULL))
ORDER BY "SiteTree_Live"."Sort" ASC
0.001s
0014: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."CanViewType", "SiteTree_Live"."CanEditType", "SiteTree_Live"."Version", CASE
WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."URLSegment"
WHEN "SiteTree_Localised_es_419"."ID" IS NOT NULL THEN "SiteTree_Localised_es_419"."URLSegment"
ELSE "SiteTree_Live"."URLSegment" END
AS "URLSegment", CASE
WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."Title"
WHEN "SiteTree_Localised_es_419"."ID" IS NOT NULL THEN "SiteTree_Localised_es_419"."Title"
ELSE "SiteTree_Live"."Title" END
AS "Title", CASE
WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."MenuTitle"
WHEN "SiteTree_Localised_es_419"."ID" IS NOT NULL THEN "SiteTree_Localised_es_419"."MenuTitle"
ELSE "SiteTree_Live"."MenuTitle" END
AS "MenuTitle", CASE
WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."Content"
WHEN "SiteTree_Localised_es_419"."ID" IS NOT NULL THEN "SiteTree_Localised_es_419"."Content"
ELSE "SiteTree_Live"."Content" END
AS "Content", CASE
WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."MetaDescription"
WHEN "SiteTree_Localised_es_419"."ID" IS NOT NULL THEN "SiteTree_Localised_es_419"."MetaDescription"
ELSE "SiteTree_Live"."MetaDescription" END
AS "MetaDescription", "SiteTree_Live"."ExtraMeta", "SiteTree_Live"."ShowInMenus", "SiteTree_Live"."ShowInSearch", "SiteTree_Live"."Sort", "SiteTree_Live"."HasBrokenFile", "SiteTree_Live"."HasBrokenLink", CASE
WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."ReportClass"
WHEN "SiteTree_Localised_es_419"."ID" IS NOT NULL THEN "SiteTree_Localised_es_419"."ReportClass"
ELSE "SiteTree_Live"."ReportClass" END
AS "ReportClass", "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", 'en_US' AS "Locale", CASE WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN 'en_US'
WHEN "SiteTree_Localised_es_419"."ID" IS NOT NULL THEN 'es_419'
ELSE NULL END AS "SourceLocale"
FROM "SiteTree_Live" LEFT JOIN "SiteTree_Localised_Live" AS "SiteTree_Localised_en_US" ON "SiteTree_Live"."ID" = "SiteTree_Localised_en_US"."RecordID" AND "SiteTree_Localised_en_US"."Locale" = ? LEFT JOIN "SiteTree_Localised_Live" AS "SiteTree_Localised_es_419" ON "SiteTree_Live"."ID" = "SiteTree_Localised_es_419"."RecordID" AND "SiteTree_Localised_es_419"."Locale" = ?
WHERE ("SiteTree_Live"."ParentID" <> "SiteTree_Live"."ID")
AND ("SiteTree_Live"."ParentID" = ?)
AND ("SiteTree_Live"."ShowInMenus" = ?)
AND (("SiteTree_Localised_en_US"."ID" IS NOT NULL) OR ("SiteTree_Localised_es_419"."ID" IS NOT NULL))
ORDER BY "SiteTree_Live"."Sort" ASC
0.0008s
0015: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."CanViewType", "SiteTree_Live"."CanEditType", "SiteTree_Live"."Version", CASE
WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."URLSegment"
WHEN "SiteTree_Localised_es_419"."ID" IS NOT NULL THEN "SiteTree_Localised_es_419"."URLSegment"
ELSE "SiteTree_Live"."URLSegment" END
AS "URLSegment", CASE
WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."Title"
WHEN "SiteTree_Localised_es_419"."ID" IS NOT NULL THEN "SiteTree_Localised_es_419"."Title"
ELSE "SiteTree_Live"."Title" END
AS "Title", CASE
WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."MenuTitle"
WHEN "SiteTree_Localised_es_419"."ID" IS NOT NULL THEN "SiteTree_Localised_es_419"."MenuTitle"
ELSE "SiteTree_Live"."MenuTitle" END
AS "MenuTitle", CASE
WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."Content"
WHEN "SiteTree_Localised_es_419"."ID" IS NOT NULL THEN "SiteTree_Localised_es_419"."Content"
ELSE "SiteTree_Live"."Content" END
AS "Content", CASE
WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."MetaDescription"
WHEN "SiteTree_Localised_es_419"."ID" IS NOT NULL THEN "SiteTree_Localised_es_419"."MetaDescription"
ELSE "SiteTree_Live"."MetaDescription" END
AS "MetaDescription", "SiteTree_Live"."ExtraMeta", "SiteTree_Live"."ShowInMenus", "SiteTree_Live"."ShowInSearch", "SiteTree_Live"."Sort", "SiteTree_Live"."HasBrokenFile", "SiteTree_Live"."HasBrokenLink", CASE
WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."ReportClass"
WHEN "SiteTree_Localised_es_419"."ID" IS NOT NULL THEN "SiteTree_Localised_es_419"."ReportClass"
ELSE "SiteTree_Live"."ReportClass" END
AS "ReportClass", "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", 'en_US' AS "Locale", CASE WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN 'en_US'
WHEN "SiteTree_Localised_es_419"."ID" IS NOT NULL THEN 'es_419'
ELSE NULL END AS "SourceLocale"
FROM "SiteTree_Live" LEFT JOIN "SiteTree_Localised_Live" AS "SiteTree_Localised_en_US" ON "SiteTree_Live"."ID" = "SiteTree_Localised_en_US"."RecordID" AND "SiteTree_Localised_en_US"."Locale" = ? LEFT JOIN "SiteTree_Localised_Live" AS "SiteTree_Localised_es_419" ON "SiteTree_Live"."ID" = "SiteTree_Localised_es_419"."RecordID" AND "SiteTree_Localised_es_419"."Locale" = ?
WHERE ("SiteTree_Live"."ParentID" <> "SiteTree_Live"."ID")
AND ("SiteTree_Live"."ParentID" = ?)
AND ("SiteTree_Live"."ShowInMenus" = ?)
AND (("SiteTree_Localised_en_US"."ID" IS NOT NULL) OR ("SiteTree_Localised_es_419"."ID" IS NOT NULL))
ORDER BY "SiteTree_Live"."Sort" ASC
0.0009s
0016: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."CanViewType", "SiteTree_Live"."CanEditType", "SiteTree_Live"."Version", CASE
WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."URLSegment"
WHEN "SiteTree_Localised_es_419"."ID" IS NOT NULL THEN "SiteTree_Localised_es_419"."URLSegment"
ELSE "SiteTree_Live"."URLSegment" END
AS "URLSegment", CASE
WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."Title"
WHEN "SiteTree_Localised_es_419"."ID" IS NOT NULL THEN "SiteTree_Localised_es_419"."Title"
ELSE "SiteTree_Live"."Title" END
AS "Title", CASE
WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."MenuTitle"
WHEN "SiteTree_Localised_es_419"."ID" IS NOT NULL THEN "SiteTree_Localised_es_419"."MenuTitle"
ELSE "SiteTree_Live"."MenuTitle" END
AS "MenuTitle", CASE
WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."Content"
WHEN "SiteTree_Localised_es_419"."ID" IS NOT NULL THEN "SiteTree_Localised_es_419"."Content"
ELSE "SiteTree_Live"."Content" END
AS "Content", CASE
WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."MetaDescription"
WHEN "SiteTree_Localised_es_419"."ID" IS NOT NULL THEN "SiteTree_Localised_es_419"."MetaDescription"
ELSE "SiteTree_Live"."MetaDescription" END
AS "MetaDescription", "SiteTree_Live"."ExtraMeta", "SiteTree_Live"."ShowInMenus", "SiteTree_Live"."ShowInSearch", "SiteTree_Live"."Sort", "SiteTree_Live"."HasBrokenFile", "SiteTree_Live"."HasBrokenLink", CASE
WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."ReportClass"
WHEN "SiteTree_Localised_es_419"."ID" IS NOT NULL THEN "SiteTree_Localised_es_419"."ReportClass"
ELSE "SiteTree_Live"."ReportClass" END
AS "ReportClass", "SiteTree_Live"."ParentID", "Page_Live"."ShowBreadcrumbs", CASE
WHEN "Page_Localised_en_US"."ID" IS NOT NULL THEN "Page_Localised_en_US"."CardSummary"
WHEN "Page_Localised_es_419"."ID" IS NOT NULL THEN "Page_Localised_es_419"."CardSummary"
ELSE "Page_Live"."CardSummary" END
AS "CardSummary", "Page_Live"."CardImageID", "BlockPage_Live"."ElementalAreaID", "SiteTree_Live"."ID",
CASE WHEN "SiteTree_Live"."ClassName" IS NOT NULL THEN "SiteTree_Live"."ClassName"
ELSE 'SilverStripe\\CMS\\Model\\SiteTree' END AS "RecordClassName", 'en_US' AS "Locale", CASE WHEN "Page_Localised_en_US"."ID" IS NOT NULL THEN 'en_US'
WHEN "Page_Localised_es_419"."ID" IS NOT NULL THEN 'es_419'
ELSE NULL END AS "SourceLocale"
FROM "SiteTree_Live" LEFT JOIN "Page_Live" ON "Page_Live"."ID" = "SiteTree_Live"."ID" LEFT JOIN "BlockPage_Live" ON "BlockPage_Live"."ID" = "SiteTree_Live"."ID" LEFT JOIN "SiteTree_Localised_Live" AS "SiteTree_Localised_en_US" ON "SiteTree_Live"."ID" = "SiteTree_Localised_en_US"."RecordID" AND "SiteTree_Localised_en_US"."Locale" = ? LEFT JOIN "SiteTree_Localised_Live" AS "SiteTree_Localised_es_419" ON "SiteTree_Live"."ID" = "SiteTree_Localised_es_419"."RecordID" AND "SiteTree_Localised_es_419"."Locale" = ? LEFT JOIN "Page_Localised_Live" AS "Page_Localised_en_US" ON "Page_Live"."ID" = "Page_Localised_en_US"."RecordID" AND "Page_Localised_en_US"."Locale" = ? LEFT JOIN "Page_Localised_Live" AS "Page_Localised_es_419" ON "Page_Live"."ID" = "Page_Localised_es_419"."RecordID" AND "Page_Localised_es_419"."Locale" = ?
WHERE ("SiteTree_Live"."ID" = ?)
AND ("SiteTree_Live"."ClassName" IN (?))
AND (("SiteTree_Localised_en_US"."ID" IS NOT NULL) OR ("SiteTree_Localised_es_419"."ID" IS NOT NULL))
ORDER BY "SiteTree_Live"."Sort" ASC
LIMIT 1
0.0011s
0017: SELECT DISTINCT "Fluent_FallbackLocale"."ClassName", "Fluent_FallbackLocale"."LastEdited", "Fluent_FallbackLocale"."Created", "Fluent_FallbackLocale"."Sort", "Fluent_FallbackLocale"."ParentID", "Fluent_FallbackLocale"."LocaleID", "Fluent_FallbackLocale"."ID",
CASE WHEN "Fluent_FallbackLocale"."ClassName" IS NOT NULL THEN "Fluent_FallbackLocale"."ClassName"
ELSE 'TractorCow\\Fluent\\Model\\FallbackLocale' END AS "RecordClassName"
FROM "Fluent_FallbackLocale"
WHERE ("Fluent_FallbackLocale"."ParentID" = ?)
ORDER BY "Fluent_FallbackLocale"."Sort" ASC
0.0005s
0018: SELECT DISTINCT "Fluent_Locale"."ClassName", "Fluent_Locale"."LastEdited", "Fluent_Locale"."Created", "Fluent_Locale"."Title", "Fluent_Locale"."Locale", "Fluent_Locale"."URLSegment", "Fluent_Locale"."IsGlobalDefault", "Fluent_Locale"."UseDefaultCode", "Fluent_Locale"."Sort", "Fluent_Locale"."Timezone", "Fluent_Locale"."DomainID", "Fluent_Locale"."ID",
CASE WHEN "Fluent_Locale"."ClassName" IS NOT NULL THEN "Fluent_Locale"."ClassName"
ELSE 'TractorCow\\Fluent\\Model\\Locale' END AS "RecordClassName"
FROM "Fluent_Locale"
WHERE ("Fluent_Locale"."ID" = ?)
ORDER BY "Fluent_Locale"."Sort" ASC, "Fluent_Locale"."Locale" ASC
LIMIT 1
0.0004s
0019: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."CanViewType", "SiteTree_Live"."CanEditType", "SiteTree_Live"."Version", CASE
WHEN "SiteTree_Localised_es_419"."ID" IS NOT NULL THEN "SiteTree_Localised_es_419"."URLSegment"
WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."URLSegment"
ELSE "SiteTree_Live"."URLSegment" END
AS "URLSegment", CASE
WHEN "SiteTree_Localised_es_419"."ID" IS NOT NULL THEN "SiteTree_Localised_es_419"."Title"
WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."Title"
ELSE "SiteTree_Live"."Title" END
AS "Title", CASE
WHEN "SiteTree_Localised_es_419"."ID" IS NOT NULL THEN "SiteTree_Localised_es_419"."MenuTitle"
WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."MenuTitle"
ELSE "SiteTree_Live"."MenuTitle" END
AS "MenuTitle", CASE
WHEN "SiteTree_Localised_es_419"."ID" IS NOT NULL THEN "SiteTree_Localised_es_419"."Content"
WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."Content"
ELSE "SiteTree_Live"."Content" END
AS "Content", CASE
WHEN "SiteTree_Localised_es_419"."ID" IS NOT NULL THEN "SiteTree_Localised_es_419"."MetaDescription"
WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."MetaDescription"
ELSE "SiteTree_Live"."MetaDescription" END
AS "MetaDescription", "SiteTree_Live"."ExtraMeta", "SiteTree_Live"."ShowInMenus", "SiteTree_Live"."ShowInSearch", "SiteTree_Live"."Sort", "SiteTree_Live"."HasBrokenFile", "SiteTree_Live"."HasBrokenLink", CASE
WHEN "SiteTree_Localised_es_419"."ID" IS NOT NULL THEN "SiteTree_Localised_es_419"."ReportClass"
WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."ReportClass"
ELSE "SiteTree_Live"."ReportClass" END
AS "ReportClass", "SiteTree_Live"."ParentID", "Page_Live"."ShowBreadcrumbs", CASE
WHEN "Page_Localised_es_419"."ID" IS NOT NULL THEN "Page_Localised_es_419"."CardSummary"
WHEN "Page_Localised_en_US"."ID" IS NOT NULL THEN "Page_Localised_en_US"."CardSummary"
ELSE "Page_Live"."CardSummary" END
AS "CardSummary", "Page_Live"."CardImageID", "BlockPage_Live"."ElementalAreaID", "SiteTree_Live"."ID",
CASE WHEN "SiteTree_Live"."ClassName" IS NOT NULL THEN "SiteTree_Live"."ClassName"
ELSE 'SilverStripe\\CMS\\Model\\SiteTree' END AS "RecordClassName", 'es_419' AS "Locale", CASE WHEN "Page_Localised_es_419"."ID" IS NOT NULL THEN 'es_419'
WHEN "Page_Localised_en_US"."ID" IS NOT NULL THEN 'en_US'
ELSE NULL END AS "SourceLocale"
FROM "SiteTree_Live" LEFT JOIN "Page_Live" ON "Page_Live"."ID" = "SiteTree_Live"."ID" LEFT JOIN "BlockPage_Live" ON "BlockPage_Live"."ID" = "SiteTree_Live"."ID" LEFT JOIN "SiteTree_Localised_Live" AS "SiteTree_Localised_es_419" ON "SiteTree_Live"."ID" = "SiteTree_Localised_es_419"."RecordID" AND "SiteTree_Localised_es_419"."Locale" = ? LEFT JOIN "SiteTree_Localised_Live" AS "SiteTree_Localised_en_US" ON "SiteTree_Live"."ID" = "SiteTree_Localised_en_US"."RecordID" AND "SiteTree_Localised_en_US"."Locale" = ? LEFT JOIN "Page_Localised_Live" AS "Page_Localised_es_419" ON "Page_Live"."ID" = "Page_Localised_es_419"."RecordID" AND "Page_Localised_es_419"."Locale" = ? LEFT JOIN "Page_Localised_Live" AS "Page_Localised_en_US" ON "Page_Live"."ID" = "Page_Localised_en_US"."RecordID" AND "Page_Localised_en_US"."Locale" = ?
WHERE ("SiteTree_Live"."ID" = ?)
AND ("SiteTree_Live"."ClassName" IN (?))
AND (("SiteTree_Localised_es_419"."ID" IS NOT NULL) OR ("SiteTree_Localised_en_US"."ID" IS NOT NULL))
ORDER BY "SiteTree_Live"."Sort" ASC
LIMIT 1
0.001s
0020: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "BlockPage_Live"."ElementalAreaID", "SiteTree_Live"."ID",
CASE WHEN "SiteTree_Live"."ClassName" IS NOT NULL THEN "SiteTree_Live"."ClassName"
ELSE 'SilverStripe\\CMS\\Model\\SiteTree' END AS "RecordClassName", 'en_US' AS "Locale", CASE WHEN "Page_Localised_en_US"."ID" IS NOT NULL THEN 'en_US'
WHEN "Page_Localised_es_419"."ID" IS NOT NULL THEN 'es_419'
ELSE NULL END AS "SourceLocale", "SiteTree_Live"."Sort"
FROM "SiteTree_Live" LEFT JOIN "Page_Live" ON "Page_Live"."ID" = "SiteTree_Live"."ID" LEFT JOIN "BlockPage_Live" ON "BlockPage_Live"."ID" = "SiteTree_Live"."ID" LEFT JOIN "SiteTree_Localised_Live" AS "SiteTree_Localised_en_US" ON "SiteTree_Live"."ID" = "SiteTree_Localised_en_US"."RecordID" AND "SiteTree_Localised_en_US"."Locale" = ? LEFT JOIN "SiteTree_Localised_Live" AS "SiteTree_Localised_es_419" ON "SiteTree_Live"."ID" = "SiteTree_Localised_es_419"."RecordID" AND "SiteTree_Localised_es_419"."Locale" = ? LEFT JOIN "Page_Localised_Live" AS "Page_Localised_en_US" ON "Page_Live"."ID" = "Page_Localised_en_US"."RecordID" AND "Page_Localised_en_US"."Locale" = ? LEFT JOIN "Page_Localised_Live" AS "Page_Localised_es_419" ON "Page_Live"."ID" = "Page_Localised_es_419"."RecordID" AND "Page_Localised_es_419"."Locale" = ?
WHERE ("SiteTree_Live"."ID" = ?)
AND ("SiteTree_Live"."ClassName" IN (?))
AND (("SiteTree_Localised_en_US"."ID" IS NOT NULL) OR ("SiteTree_Localised_es_419"."ID" IS NOT NULL))
ORDER BY "SiteTree_Live"."Sort" ASC
LIMIT 1
0.0007s
0021: SELECT DISTINCT "ElementalArea_Live"."ClassName", "ElementalArea_Live"."LastEdited", "ElementalArea_Live"."Created", "ElementalArea_Live"."TopPageLocale", "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
0022: SELECT DISTINCT "Element_Live"."ClassName", "Element_Live"."LastEdited", "Element_Live"."Created", "Element_Live"."BackgroundColor", CASE
WHEN "Element_Localised_en_US"."ID" IS NOT NULL THEN "Element_Localised_en_US"."BackgroundPattern"
WHEN "Element_Localised_es_419"."ID" IS NOT NULL THEN "Element_Localised_es_419"."BackgroundPattern"
ELSE "Element_Live"."BackgroundPattern" END
AS "BackgroundPattern", "Element_Live"."CustomCode", CASE
WHEN "Element_Localised_en_US"."ID" IS NOT NULL THEN "Element_Localised_en_US"."TopPageLocale"
WHEN "Element_Localised_es_419"."ID" IS NOT NULL THEN "Element_Localised_es_419"."TopPageLocale"
ELSE "Element_Live"."TopPageLocale" END
AS "TopPageLocale", "Element_Live"."Version", CASE
WHEN "Element_Localised_en_US"."ID" IS NOT NULL THEN "Element_Localised_en_US"."Title"
WHEN "Element_Localised_es_419"."ID" IS NOT NULL THEN "Element_Localised_es_419"."Title"
ELSE "Element_Live"."Title" END
AS "Title", "Element_Live"."ShowTitle", "Element_Live"."Sort", CASE
WHEN "Element_Localised_en_US"."ID" IS NOT NULL THEN "Element_Localised_en_US"."ExtraClass"
WHEN "Element_Localised_es_419"."ID" IS NOT NULL THEN "Element_Localised_es_419"."ExtraClass"
ELSE "Element_Live"."ExtraClass" END
AS "ExtraClass", CASE
WHEN "Element_Localised_en_US"."ID" IS NOT NULL THEN "Element_Localised_en_US"."Style"
WHEN "Element_Localised_es_419"."ID" IS NOT NULL THEN "Element_Localised_es_419"."Style"
ELSE "Element_Live"."Style" END
AS "Style", "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", 'en_US' AS "Locale", CASE WHEN "Element_Localised_en_US"."ID" IS NOT NULL THEN 'en_US'
WHEN "Element_Localised_es_419"."ID" IS NOT NULL THEN 'es_419'
ELSE NULL END AS "SourceLocale"
FROM "Element_Live" LEFT JOIN "Element_Localised_Live" AS "Element_Localised_en_US" ON "Element_Live"."ID" = "Element_Localised_en_US"."RecordID" AND "Element_Localised_en_US"."Locale" = ? LEFT JOIN "Element_Localised_Live" AS "Element_Localised_es_419" ON "Element_Live"."ID" = "Element_Localised_es_419"."RecordID" AND "Element_Localised_es_419"."Locale" = ?
WHERE ("Element_Live"."ParentID" = ?)
AND (("Element_Localised_en_US"."ID" IS NOT NULL) OR ("Element_Localised_es_419"."ID" IS NOT NULL))
ORDER BY "Element_Live"."Sort" ASC
0.0016s
0023: SELECT DISTINCT "ElementalArea_Live"."ClassName", "ElementalArea_Live"."LastEdited", "ElementalArea_Live"."Created", "ElementalArea_Live"."TopPageLocale", "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
0024: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."CanViewType", "SiteTree_Live"."CanEditType", "SiteTree_Live"."Version", CASE
WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."URLSegment"
WHEN "SiteTree_Localised_es_419"."ID" IS NOT NULL THEN "SiteTree_Localised_es_419"."URLSegment"
ELSE "SiteTree_Live"."URLSegment" END
AS "URLSegment", CASE
WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."Title"
WHEN "SiteTree_Localised_es_419"."ID" IS NOT NULL THEN "SiteTree_Localised_es_419"."Title"
ELSE "SiteTree_Live"."Title" END
AS "Title", CASE
WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."MenuTitle"
WHEN "SiteTree_Localised_es_419"."ID" IS NOT NULL THEN "SiteTree_Localised_es_419"."MenuTitle"
ELSE "SiteTree_Live"."MenuTitle" END
AS "MenuTitle", CASE
WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."Content"
WHEN "SiteTree_Localised_es_419"."ID" IS NOT NULL THEN "SiteTree_Localised_es_419"."Content"
ELSE "SiteTree_Live"."Content" END
AS "Content", CASE
WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."MetaDescription"
WHEN "SiteTree_Localised_es_419"."ID" IS NOT NULL THEN "SiteTree_Localised_es_419"."MetaDescription"
ELSE "SiteTree_Live"."MetaDescription" END
AS "MetaDescription", "SiteTree_Live"."ExtraMeta", "SiteTree_Live"."ShowInMenus", "SiteTree_Live"."ShowInSearch", "SiteTree_Live"."Sort", "SiteTree_Live"."HasBrokenFile", "SiteTree_Live"."HasBrokenLink", CASE
WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."ReportClass"
WHEN "SiteTree_Localised_es_419"."ID" IS NOT NULL THEN "SiteTree_Localised_es_419"."ReportClass"
ELSE "SiteTree_Live"."ReportClass" END
AS "ReportClass", "SiteTree_Live"."ParentID", "Page_Live"."ShowBreadcrumbs", CASE
WHEN "Page_Localised_en_US"."ID" IS NOT NULL THEN "Page_Localised_en_US"."CardSummary"
WHEN "Page_Localised_es_419"."ID" IS NOT NULL THEN "Page_Localised_es_419"."CardSummary"
ELSE "Page_Live"."CardSummary" END
AS "CardSummary", "Page_Live"."CardImageID", "BlockPage_Live"."ElementalAreaID", "SiteTree_Live"."ID",
CASE WHEN "SiteTree_Live"."ClassName" IS NOT NULL THEN "SiteTree_Live"."ClassName"
ELSE 'SilverStripe\\CMS\\Model\\SiteTree' END AS "RecordClassName", 'en_US' AS "Locale", CASE WHEN "Page_Localised_en_US"."ID" IS NOT NULL THEN 'en_US'
WHEN "Page_Localised_es_419"."ID" IS NOT NULL THEN 'es_419'
ELSE NULL END AS "SourceLocale"
FROM "SiteTree_Live" LEFT JOIN "Page_Live" ON "Page_Live"."ID" = "SiteTree_Live"."ID" LEFT JOIN "BlockPage_Live" ON "BlockPage_Live"."ID" = "SiteTree_Live"."ID" LEFT JOIN "SiteTree_Localised_Live" AS "SiteTree_Localised_en_US" ON "SiteTree_Live"."ID" = "SiteTree_Localised_en_US"."RecordID" AND "SiteTree_Localised_en_US"."Locale" = ? LEFT JOIN "SiteTree_Localised_Live" AS "SiteTree_Localised_es_419" ON "SiteTree_Live"."ID" = "SiteTree_Localised_es_419"."RecordID" AND "SiteTree_Localised_es_419"."Locale" = ? LEFT JOIN "Page_Localised_Live" AS "Page_Localised_en_US" ON "Page_Live"."ID" = "Page_Localised_en_US"."RecordID" AND "Page_Localised_en_US"."Locale" = ? LEFT JOIN "Page_Localised_Live" AS "Page_Localised_es_419" ON "Page_Live"."ID" = "Page_Localised_es_419"."RecordID" AND "Page_Localised_es_419"."Locale" = ?
WHERE ("BlockPage_Live"."ElementalAreaID" = ?)
AND ("SiteTree_Live"."ClassName" = ?)
AND ("SiteTree_Live"."ClassName" IN (?))
AND (("SiteTree_Localised_en_US"."ID" IS NOT NULL) OR ("SiteTree_Localised_es_419"."ID" IS NOT NULL))
ORDER BY "SiteTree_Live"."Sort" ASC
LIMIT 1
0.0013s
0025: SELECT DISTINCT "Element_Live"."ClassName", "Element_Live"."LastEdited", "Element_Live"."Created", "ElementBanner_Live"."TextPosition", "ElementBanner_Live"."TextColor", CASE
WHEN "ElementBanner_Localised_en_US"."ID" IS NOT NULL THEN "ElementBanner_Localised_en_US"."ImageID"
WHEN "ElementBanner_Localised_es_419"."ID" IS NOT NULL THEN "ElementBanner_Localised_es_419"."ImageID"
ELSE "ElementBanner_Live"."ImageID" END
AS "ImageID", "Element_Live"."ID",
CASE WHEN "Element_Live"."ClassName" IS NOT NULL THEN "Element_Live"."ClassName"
ELSE 'DNADesign\\Elemental\\Models\\BaseElement' END AS "RecordClassName", 'en_US' AS "Locale", CASE WHEN "ElementBanner_Localised_en_US"."ID" IS NOT NULL THEN 'en_US'
WHEN "ElementBanner_Localised_es_419"."ID" IS NOT NULL THEN 'es_419'
ELSE NULL END AS "SourceLocale", "Element_Live"."Sort"
FROM "Element_Live" LEFT JOIN "ElementContent_Live" ON "ElementContent_Live"."ID" = "Element_Live"."ID" LEFT JOIN "ElementBanner_Live" ON "ElementBanner_Live"."ID" = "Element_Live"."ID" LEFT JOIN "Element_Localised_Live" AS "Element_Localised_en_US" ON "Element_Live"."ID" = "Element_Localised_en_US"."RecordID" AND "Element_Localised_en_US"."Locale" = ? LEFT JOIN "Element_Localised_Live" AS "Element_Localised_es_419" ON "Element_Live"."ID" = "Element_Localised_es_419"."RecordID" AND "Element_Localised_es_419"."Locale" = ? LEFT JOIN "ElementContent_Localised_Live" AS "ElementContent_Localised_en_US" ON "ElementContent_Live"."ID" = "ElementContent_Localised_en_US"."RecordID" AND "ElementContent_Localised_en_US"."Locale" = ? LEFT JOIN "ElementContent_Localised_Live" AS "ElementContent_Localised_es_419" ON "ElementContent_Live"."ID" = "ElementContent_Localised_es_419"."RecordID" AND "ElementContent_Localised_es_419"."Locale" = ? LEFT JOIN "ElementBanner_Localised_Live" AS "ElementBanner_Localised_en_US" ON "ElementBanner_Live"."ID" = "ElementBanner_Localised_en_US"."RecordID" AND "ElementBanner_Localised_en_US"."Locale" = ? LEFT JOIN "ElementBanner_Localised_Live" AS "ElementBanner_Localised_es_419" ON "ElementBanner_Live"."ID" = "ElementBanner_Localised_es_419"."RecordID" AND "ElementBanner_Localised_es_419"."Locale" = ?
WHERE ("Element_Live"."ID" = ?)
AND ("Element_Live"."ClassName" IN (?))
AND (("Element_Localised_en_US"."ID" IS NOT NULL) OR ("Element_Localised_es_419"."ID" IS NOT NULL))
ORDER BY "Element_Live"."Sort" ASC
LIMIT 1
0.0007s
0026: SELECT DISTINCT "ElementalArea_Live"."ClassName", "ElementalArea_Live"."LastEdited", "ElementalArea_Live"."Created", "ElementalArea_Live"."TopPageLocale", "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
0027: 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"."ParentID", "File_Live"."OwnerID", "File_Live"."FileHash", "File_Live"."FileFilename", "File_Live"."FileVariant", "Image_Live"."FocusPointX", "Image_Live"."FocusPointY", "Image_Live"."FocusPointWidth", "Image_Live"."FocusPointHeight", "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" LEFT JOIN "Image_Live" ON "Image_Live"."ID" = "File_Live"."ID"
WHERE ("File_Live"."ID" = ?)
AND ("File_Live"."ClassName" IN (?))
ORDER BY "File_Live"."Name" ASC
LIMIT 1
0.0005s
0028: SELECT DISTINCT "ElementalArea_Live"."ClassName", "ElementalArea_Live"."LastEdited", "ElementalArea_Live"."Created", "ElementalArea_Live"."TopPageLocale", "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
0029: SELECT DISTINCT count(DISTINCT "Element_Live"."ID") AS "Count"
FROM "Element_Live" LEFT JOIN "Element_Localised_Live" AS "Element_Localised_en_US" ON "Element_Live"."ID" = "Element_Localised_en_US"."RecordID" AND "Element_Localised_en_US"."Locale" = ? LEFT JOIN "Element_Localised_Live" AS "Element_Localised_es_419" ON "Element_Live"."ID" = "Element_Localised_es_419"."RecordID" AND "Element_Localised_es_419"."Locale" = ?
WHERE ("Element_Live"."ParentID" = ?)
AND ("Element_Live"."Sort" < ?)
AND (("Element_Localised_en_US"."ID" IS NOT NULL) OR ("Element_Localised_es_419"."ID" IS NOT NULL))
0.0005s
0030: SELECT DISTINCT "Element_Live"."ClassName", "Element_Live"."LastEdited", "Element_Live"."Created", CASE
WHEN "ElementContent_Localised_en_US"."ID" IS NOT NULL THEN "ElementContent_Localised_en_US"."HTML"
WHEN "ElementContent_Localised_es_419"."ID" IS NOT NULL THEN "ElementContent_Localised_es_419"."HTML"
ELSE "ElementContent_Live"."HTML" END
AS "HTML", "Element_Live"."ID",
CASE WHEN "Element_Live"."ClassName" IS NOT NULL THEN "Element_Live"."ClassName"
ELSE 'DNADesign\\Elemental\\Models\\BaseElement' END AS "RecordClassName", 'en_US' AS "Locale", CASE WHEN "ElementContent_Localised_en_US"."ID" IS NOT NULL THEN 'en_US'
WHEN "ElementContent_Localised_es_419"."ID" IS NOT NULL THEN 'es_419'
ELSE NULL END AS "SourceLocale", "Element_Live"."Sort"
FROM "Element_Live" LEFT JOIN "ElementContent_Live" ON "ElementContent_Live"."ID" = "Element_Live"."ID" LEFT JOIN "Element_Localised_Live" AS "Element_Localised_en_US" ON "Element_Live"."ID" = "Element_Localised_en_US"."RecordID" AND "Element_Localised_en_US"."Locale" = ? LEFT JOIN "Element_Localised_Live" AS "Element_Localised_es_419" ON "Element_Live"."ID" = "Element_Localised_es_419"."RecordID" AND "Element_Localised_es_419"."Locale" = ? LEFT JOIN "ElementContent_Localised_Live" AS "ElementContent_Localised_en_US" ON "ElementContent_Live"."ID" = "ElementContent_Localised_en_US"."RecordID" AND "ElementContent_Localised_en_US"."Locale" = ? LEFT JOIN "ElementContent_Localised_Live" AS "ElementContent_Localised_es_419" ON "ElementContent_Live"."ID" = "ElementContent_Localised_es_419"."RecordID" AND "ElementContent_Localised_es_419"."Locale" = ?
WHERE ("Element_Live"."ID" = ?)
AND ("Element_Live"."ClassName" IN (?, ?, ?, ?, ?, ?, ?, ?, ?))
AND (("Element_Localised_en_US"."ID" IS NOT NULL) OR ("Element_Localised_es_419"."ID" IS NOT NULL))
ORDER BY "Element_Live"."Sort" ASC
LIMIT 1
0.0007s
0031: SELECT DISTINCT "Element_Live"."ClassName", "Element_Live"."LastEdited", "Element_Live"."Created", CASE
WHEN "ElementContent_Localised_en_US"."ID" IS NOT NULL THEN "ElementContent_Localised_en_US"."HTML"
WHEN "ElementContent_Localised_es_419"."ID" IS NOT NULL THEN "ElementContent_Localised_es_419"."HTML"
ELSE "ElementContent_Live"."HTML" END
AS "HTML", "Element_Live"."ID",
CASE WHEN "Element_Live"."ClassName" IS NOT NULL THEN "Element_Live"."ClassName"
ELSE 'DNADesign\\Elemental\\Models\\BaseElement' END AS "RecordClassName", 'en_US' AS "Locale", CASE WHEN "ElementContent_Localised_en_US"."ID" IS NOT NULL THEN 'en_US'
WHEN "ElementContent_Localised_es_419"."ID" IS NOT NULL THEN 'es_419'
ELSE NULL END AS "SourceLocale", "Element_Live"."Sort"
FROM "Element_Live" LEFT JOIN "ElementContent_Live" ON "ElementContent_Live"."ID" = "Element_Live"."ID" LEFT JOIN "Element_Localised_Live" AS "Element_Localised_en_US" ON "Element_Live"."ID" = "Element_Localised_en_US"."RecordID" AND "Element_Localised_en_US"."Locale" = ? LEFT JOIN "Element_Localised_Live" AS "Element_Localised_es_419" ON "Element_Live"."ID" = "Element_Localised_es_419"."RecordID" AND "Element_Localised_es_419"."Locale" = ? LEFT JOIN "ElementContent_Localised_Live" AS "ElementContent_Localised_en_US" ON "ElementContent_Live"."ID" = "ElementContent_Localised_en_US"."RecordID" AND "ElementContent_Localised_en_US"."Locale" = ? LEFT JOIN "ElementContent_Localised_Live" AS "ElementContent_Localised_es_419" ON "ElementContent_Live"."ID" = "ElementContent_Localised_es_419"."RecordID" AND "ElementContent_Localised_es_419"."Locale" = ?
WHERE ("Element_Live"."ID" = ?)
AND ("Element_Live"."ClassName" IN (?, ?, ?, ?, ?, ?, ?, ?, ?))
AND (("Element_Localised_en_US"."ID" IS NOT NULL) OR ("Element_Localised_es_419"."ID" IS NOT NULL))
ORDER BY "Element_Live"."Sort" ASC
LIMIT 1
0.0007s
0032: SELECT DISTINCT "Element_Live"."ClassName", "Element_Live"."LastEdited", "Element_Live"."Created", CASE
WHEN "ElementContent_Localised_en_US"."ID" IS NOT NULL THEN "ElementContent_Localised_en_US"."HTML"
WHEN "ElementContent_Localised_es_419"."ID" IS NOT NULL THEN "ElementContent_Localised_es_419"."HTML"
ELSE "ElementContent_Live"."HTML" END
AS "HTML", "Element_Live"."ID",
CASE WHEN "Element_Live"."ClassName" IS NOT NULL THEN "Element_Live"."ClassName"
ELSE 'DNADesign\\Elemental\\Models\\BaseElement' END AS "RecordClassName", 'en_US' AS "Locale", CASE WHEN "ElementContent_Localised_en_US"."ID" IS NOT NULL THEN 'en_US'
WHEN "ElementContent_Localised_es_419"."ID" IS NOT NULL THEN 'es_419'
ELSE NULL END AS "SourceLocale", "Element_Live"."Sort"
FROM "Element_Live" LEFT JOIN "ElementContent_Live" ON "ElementContent_Live"."ID" = "Element_Live"."ID" LEFT JOIN "Element_Localised_Live" AS "Element_Localised_en_US" ON "Element_Live"."ID" = "Element_Localised_en_US"."RecordID" AND "Element_Localised_en_US"."Locale" = ? LEFT JOIN "Element_Localised_Live" AS "Element_Localised_es_419" ON "Element_Live"."ID" = "Element_Localised_es_419"."RecordID" AND "Element_Localised_es_419"."Locale" = ? LEFT JOIN "ElementContent_Localised_Live" AS "ElementContent_Localised_en_US" ON "ElementContent_Live"."ID" = "ElementContent_Localised_en_US"."RecordID" AND "ElementContent_Localised_en_US"."Locale" = ? LEFT JOIN "ElementContent_Localised_Live" AS "ElementContent_Localised_es_419" ON "ElementContent_Live"."ID" = "ElementContent_Localised_es_419"."RecordID" AND "ElementContent_Localised_es_419"."Locale" = ?
WHERE ("Element_Live"."ID" = ?)
AND ("Element_Live"."ClassName" IN (?, ?, ?, ?, ?, ?, ?, ?, ?))
AND (("Element_Localised_en_US"."ID" IS NOT NULL) OR ("Element_Localised_es_419"."ID" IS NOT NULL))
ORDER BY "Element_Live"."Sort" ASC
LIMIT 1
0.0005s
0033: SELECT DISTINCT "Element_Live"."ClassName", "Element_Live"."LastEdited", "Element_Live"."Created", CASE
WHEN "ElementContent_Localised_en_US"."ID" IS NOT NULL THEN "ElementContent_Localised_en_US"."HTML"
WHEN "ElementContent_Localised_es_419"."ID" IS NOT NULL THEN "ElementContent_Localised_es_419"."HTML"
ELSE "ElementContent_Live"."HTML" END
AS "HTML", "Element_Live"."ID",
CASE WHEN "Element_Live"."ClassName" IS NOT NULL THEN "Element_Live"."ClassName"
ELSE 'DNADesign\\Elemental\\Models\\BaseElement' END AS "RecordClassName", 'en_US' AS "Locale", CASE WHEN "ElementContent_Localised_en_US"."ID" IS NOT NULL THEN 'en_US'
WHEN "ElementContent_Localised_es_419"."ID" IS NOT NULL THEN 'es_419'
ELSE NULL END AS "SourceLocale", "Element_Live"."Sort"
FROM "Element_Live" LEFT JOIN "ElementContent_Live" ON "ElementContent_Live"."ID" = "Element_Live"."ID" LEFT JOIN "Element_Localised_Live" AS "Element_Localised_en_US" ON "Element_Live"."ID" = "Element_Localised_en_US"."RecordID" AND "Element_Localised_en_US"."Locale" = ? LEFT JOIN "Element_Localised_Live" AS "Element_Localised_es_419" ON "Element_Live"."ID" = "Element_Localised_es_419"."RecordID" AND "Element_Localised_es_419"."Locale" = ? LEFT JOIN "ElementContent_Localised_Live" AS "ElementContent_Localised_en_US" ON "ElementContent_Live"."ID" = "ElementContent_Localised_en_US"."RecordID" AND "ElementContent_Localised_en_US"."Locale" = ? LEFT JOIN "ElementContent_Localised_Live" AS "ElementContent_Localised_es_419" ON "ElementContent_Live"."ID" = "ElementContent_Localised_es_419"."RecordID" AND "ElementContent_Localised_es_419"."Locale" = ?
WHERE ("Element_Live"."ID" = ?)
AND ("Element_Live"."ClassName" IN (?, ?, ?, ?, ?, ?, ?, ?, ?))
AND (("Element_Localised_en_US"."ID" IS NOT NULL) OR ("Element_Localised_es_419"."ID" IS NOT NULL))
ORDER BY "Element_Live"."Sort" ASC
LIMIT 1
0.0005s
0034: SELECT DISTINCT "Element_Live"."ClassName", "Element_Live"."LastEdited", "Element_Live"."Created", CASE
WHEN "ElementContent_Localised_en_US"."ID" IS NOT NULL THEN "ElementContent_Localised_en_US"."HTML"
WHEN "ElementContent_Localised_es_419"."ID" IS NOT NULL THEN "ElementContent_Localised_es_419"."HTML"
ELSE "ElementContent_Live"."HTML" END
AS "HTML", "Element_Live"."ID",
CASE WHEN "Element_Live"."ClassName" IS NOT NULL THEN "Element_Live"."ClassName"
ELSE 'DNADesign\\Elemental\\Models\\BaseElement' END AS "RecordClassName", 'en_US' AS "Locale", CASE WHEN "ElementContent_Localised_en_US"."ID" IS NOT NULL THEN 'en_US'
WHEN "ElementContent_Localised_es_419"."ID" IS NOT NULL THEN 'es_419'
ELSE NULL END AS "SourceLocale", "Element_Live"."Sort"
FROM "Element_Live" LEFT JOIN "ElementContent_Live" ON "ElementContent_Live"."ID" = "Element_Live"."ID" LEFT JOIN "Element_Localised_Live" AS "Element_Localised_en_US" ON "Element_Live"."ID" = "Element_Localised_en_US"."RecordID" AND "Element_Localised_en_US"."Locale" = ? LEFT JOIN "Element_Localised_Live" AS "Element_Localised_es_419" ON "Element_Live"."ID" = "Element_Localised_es_419"."RecordID" AND "Element_Localised_es_419"."Locale" = ? LEFT JOIN "ElementContent_Localised_Live" AS "ElementContent_Localised_en_US" ON "ElementContent_Live"."ID" = "ElementContent_Localised_en_US"."RecordID" AND "ElementContent_Localised_en_US"."Locale" = ? LEFT JOIN "ElementContent_Localised_Live" AS "ElementContent_Localised_es_419" ON "ElementContent_Live"."ID" = "ElementContent_Localised_es_419"."RecordID" AND "ElementContent_Localised_es_419"."Locale" = ?
WHERE ("Element_Live"."ID" = ?)
AND ("Element_Live"."ClassName" IN (?, ?, ?, ?, ?, ?, ?, ?, ?))
AND (("Element_Localised_en_US"."ID" IS NOT NULL) OR ("Element_Localised_es_419"."ID" IS NOT NULL))
ORDER BY "Element_Live"."Sort" ASC
LIMIT 1
0.0005s
0035: SELECT DISTINCT "Element_Live"."ClassName", "Element_Live"."LastEdited", "Element_Live"."Created", CASE
WHEN "ElementContent_Localised_en_US"."ID" IS NOT NULL THEN "ElementContent_Localised_en_US"."HTML"
WHEN "ElementContent_Localised_es_419"."ID" IS NOT NULL THEN "ElementContent_Localised_es_419"."HTML"
ELSE "ElementContent_Live"."HTML" END
AS "HTML", "Element_Live"."ID",
CASE WHEN "Element_Live"."ClassName" IS NOT NULL THEN "Element_Live"."ClassName"
ELSE 'DNADesign\\Elemental\\Models\\BaseElement' END AS "RecordClassName", 'en_US' AS "Locale", CASE WHEN "ElementContent_Localised_en_US"."ID" IS NOT NULL THEN 'en_US'
WHEN "ElementContent_Localised_es_419"."ID" IS NOT NULL THEN 'es_419'
ELSE NULL END AS "SourceLocale", "Element_Live"."Sort"
FROM "Element_Live" LEFT JOIN "ElementContent_Live" ON "ElementContent_Live"."ID" = "Element_Live"."ID" LEFT JOIN "Element_Localised_Live" AS "Element_Localised_en_US" ON "Element_Live"."ID" = "Element_Localised_en_US"."RecordID" AND "Element_Localised_en_US"."Locale" = ? LEFT JOIN "Element_Localised_Live" AS "Element_Localised_es_419" ON "Element_Live"."ID" = "Element_Localised_es_419"."RecordID" AND "Element_Localised_es_419"."Locale" = ? LEFT JOIN "ElementContent_Localised_Live" AS "ElementContent_Localised_en_US" ON "ElementContent_Live"."ID" = "ElementContent_Localised_en_US"."RecordID" AND "ElementContent_Localised_en_US"."Locale" = ? LEFT JOIN "ElementContent_Localised_Live" AS "ElementContent_Localised_es_419" ON "ElementContent_Live"."ID" = "ElementContent_Localised_es_419"."RecordID" AND "ElementContent_Localised_es_419"."Locale" = ?
WHERE ("Element_Live"."ID" = ?)
AND ("Element_Live"."ClassName" IN (?, ?, ?, ?, ?, ?, ?, ?, ?))
AND (("Element_Localised_en_US"."ID" IS NOT NULL) OR ("Element_Localised_es_419"."ID" IS NOT NULL))
ORDER BY "Element_Live"."Sort" ASC
LIMIT 1
0.0004s
0036: SELECT DISTINCT "Element_Live"."ClassName", "Element_Live"."LastEdited", "Element_Live"."Created", CASE
WHEN "ElementContent_Localised_en_US"."ID" IS NOT NULL THEN "ElementContent_Localised_en_US"."HTML"
WHEN "ElementContent_Localised_es_419"."ID" IS NOT NULL THEN "ElementContent_Localised_es_419"."HTML"
ELSE "ElementContent_Live"."HTML" END
AS "HTML", "Element_Live"."ID",
CASE WHEN "Element_Live"."ClassName" IS NOT NULL THEN "Element_Live"."ClassName"
ELSE 'DNADesign\\Elemental\\Models\\BaseElement' END AS "RecordClassName", 'en_US' AS "Locale", CASE WHEN "ElementContent_Localised_en_US"."ID" IS NOT NULL THEN 'en_US'
WHEN "ElementContent_Localised_es_419"."ID" IS NOT NULL THEN 'es_419'
ELSE NULL END AS "SourceLocale", "Element_Live"."Sort"
FROM "Element_Live" LEFT JOIN "ElementContent_Live" ON "ElementContent_Live"."ID" = "Element_Live"."ID" LEFT JOIN "Element_Localised_Live" AS "Element_Localised_en_US" ON "Element_Live"."ID" = "Element_Localised_en_US"."RecordID" AND "Element_Localised_en_US"."Locale" = ? LEFT JOIN "Element_Localised_Live" AS "Element_Localised_es_419" ON "Element_Live"."ID" = "Element_Localised_es_419"."RecordID" AND "Element_Localised_es_419"."Locale" = ? LEFT JOIN "ElementContent_Localised_Live" AS "ElementContent_Localised_en_US" ON "ElementContent_Live"."ID" = "ElementContent_Localised_en_US"."RecordID" AND "ElementContent_Localised_en_US"."Locale" = ? LEFT JOIN "ElementContent_Localised_Live" AS "ElementContent_Localised_es_419" ON "ElementContent_Live"."ID" = "ElementContent_Localised_es_419"."RecordID" AND "ElementContent_Localised_es_419"."Locale" = ?
WHERE ("Element_Live"."ID" = ?)
AND ("Element_Live"."ClassName" IN (?, ?, ?, ?, ?, ?, ?, ?, ?))
AND (("Element_Localised_en_US"."ID" IS NOT NULL) OR ("Element_Localised_es_419"."ID" IS NOT NULL))
ORDER BY "Element_Live"."Sort" ASC
LIMIT 1
0.0005s
0037: SELECT DISTINCT "Element_Live"."ClassName", "Element_Live"."LastEdited", "Element_Live"."Created", CASE
WHEN "ElementContent_Localised_en_US"."ID" IS NOT NULL THEN "ElementContent_Localised_en_US"."HTML"
WHEN "ElementContent_Localised_es_419"."ID" IS NOT NULL THEN "ElementContent_Localised_es_419"."HTML"
ELSE "ElementContent_Live"."HTML" END
AS "HTML", "Element_Live"."ID",
CASE WHEN "Element_Live"."ClassName" IS NOT NULL THEN "Element_Live"."ClassName"
ELSE 'DNADesign\\Elemental\\Models\\BaseElement' END AS "RecordClassName", 'en_US' AS "Locale", CASE WHEN "ElementContent_Localised_en_US"."ID" IS NOT NULL THEN 'en_US'
WHEN "ElementContent_Localised_es_419"."ID" IS NOT NULL THEN 'es_419'
ELSE NULL END AS "SourceLocale", "Element_Live"."Sort"
FROM "Element_Live" LEFT JOIN "ElementContent_Live" ON "ElementContent_Live"."ID" = "Element_Live"."ID" LEFT JOIN "Element_Localised_Live" AS "Element_Localised_en_US" ON "Element_Live"."ID" = "Element_Localised_en_US"."RecordID" AND "Element_Localised_en_US"."Locale" = ? LEFT JOIN "Element_Localised_Live" AS "Element_Localised_es_419" ON "Element_Live"."ID" = "Element_Localised_es_419"."RecordID" AND "Element_Localised_es_419"."Locale" = ? LEFT JOIN "ElementContent_Localised_Live" AS "ElementContent_Localised_en_US" ON "ElementContent_Live"."ID" = "ElementContent_Localised_en_US"."RecordID" AND "ElementContent_Localised_en_US"."Locale" = ? LEFT JOIN "ElementContent_Localised_Live" AS "ElementContent_Localised_es_419" ON "ElementContent_Live"."ID" = "ElementContent_Localised_es_419"."RecordID" AND "ElementContent_Localised_es_419"."Locale" = ?
WHERE ("Element_Live"."ID" = ?)
AND ("Element_Live"."ClassName" IN (?, ?, ?, ?, ?, ?, ?, ?, ?))
AND (("Element_Localised_en_US"."ID" IS NOT NULL) OR ("Element_Localised_es_419"."ID" IS NOT NULL))
ORDER BY "Element_Live"."Sort" ASC
LIMIT 1
0.0006s
0038: SELECT DISTINCT "Element_Live"."ClassName", "Element_Live"."LastEdited", "Element_Live"."Created", CASE
WHEN "ElementContent_Localised_en_US"."ID" IS NOT NULL THEN "ElementContent_Localised_en_US"."HTML"
WHEN "ElementContent_Localised_es_419"."ID" IS NOT NULL THEN "ElementContent_Localised_es_419"."HTML"
ELSE "ElementContent_Live"."HTML" END
AS "HTML", "Element_Live"."ID",
CASE WHEN "Element_Live"."ClassName" IS NOT NULL THEN "Element_Live"."ClassName"
ELSE 'DNADesign\\Elemental\\Models\\BaseElement' END AS "RecordClassName", 'en_US' AS "Locale", CASE WHEN "ElementContent_Localised_en_US"."ID" IS NOT NULL THEN 'en_US'
WHEN "ElementContent_Localised_es_419"."ID" IS NOT NULL THEN 'es_419'
ELSE NULL END AS "SourceLocale", "Element_Live"."Sort"
FROM "Element_Live" LEFT JOIN "ElementContent_Live" ON "ElementContent_Live"."ID" = "Element_Live"."ID" LEFT JOIN "Element_Localised_Live" AS "Element_Localised_en_US" ON "Element_Live"."ID" = "Element_Localised_en_US"."RecordID" AND "Element_Localised_en_US"."Locale" = ? LEFT JOIN "Element_Localised_Live" AS "Element_Localised_es_419" ON "Element_Live"."ID" = "Element_Localised_es_419"."RecordID" AND "Element_Localised_es_419"."Locale" = ? LEFT JOIN "ElementContent_Localised_Live" AS "ElementContent_Localised_en_US" ON "ElementContent_Live"."ID" = "ElementContent_Localised_en_US"."RecordID" AND "ElementContent_Localised_en_US"."Locale" = ? LEFT JOIN "ElementContent_Localised_Live" AS "ElementContent_Localised_es_419" ON "ElementContent_Live"."ID" = "ElementContent_Localised_es_419"."RecordID" AND "ElementContent_Localised_es_419"."Locale" = ?
WHERE ("Element_Live"."ID" = ?)
AND ("Element_Live"."ClassName" IN (?, ?, ?, ?, ?, ?, ?, ?, ?))
AND (("Element_Localised_en_US"."ID" IS NOT NULL) OR ("Element_Localised_es_419"."ID" IS NOT NULL))
ORDER BY "Element_Live"."Sort" ASC
LIMIT 1
0.0007s
0039: SELECT DISTINCT "Element_Live"."ClassName", "Element_Live"."LastEdited", "Element_Live"."Created", CASE
WHEN "ElementContent_Localised_en_US"."ID" IS NOT NULL THEN "ElementContent_Localised_en_US"."HTML"
WHEN "ElementContent_Localised_es_419"."ID" IS NOT NULL THEN "ElementContent_Localised_es_419"."HTML"
ELSE "ElementContent_Live"."HTML" END
AS "HTML", "Element_Live"."ID",
CASE WHEN "Element_Live"."ClassName" IS NOT NULL THEN "Element_Live"."ClassName"
ELSE 'DNADesign\\Elemental\\Models\\BaseElement' END AS "RecordClassName", 'en_US' AS "Locale", CASE WHEN "ElementContent_Localised_en_US"."ID" IS NOT NULL THEN 'en_US'
WHEN "ElementContent_Localised_es_419"."ID" IS NOT NULL THEN 'es_419'
ELSE NULL END AS "SourceLocale", "Element_Live"."Sort"
FROM "Element_Live" LEFT JOIN "ElementContent_Live" ON "ElementContent_Live"."ID" = "Element_Live"."ID" LEFT JOIN "Element_Localised_Live" AS "Element_Localised_en_US" ON "Element_Live"."ID" = "Element_Localised_en_US"."RecordID" AND "Element_Localised_en_US"."Locale" = ? LEFT JOIN "Element_Localised_Live" AS "Element_Localised_es_419" ON "Element_Live"."ID" = "Element_Localised_es_419"."RecordID" AND "Element_Localised_es_419"."Locale" = ? LEFT JOIN "ElementContent_Localised_Live" AS "ElementContent_Localised_en_US" ON "ElementContent_Live"."ID" = "ElementContent_Localised_en_US"."RecordID" AND "ElementContent_Localised_en_US"."Locale" = ? LEFT JOIN "ElementContent_Localised_Live" AS "ElementContent_Localised_es_419" ON "ElementContent_Live"."ID" = "ElementContent_Localised_es_419"."RecordID" AND "ElementContent_Localised_es_419"."Locale" = ?
WHERE ("Element_Live"."ID" = ?)
AND ("Element_Live"."ClassName" IN (?, ?, ?, ?, ?, ?, ?, ?, ?))
AND (("Element_Localised_en_US"."ID" IS NOT NULL) OR ("Element_Localised_es_419"."ID" IS NOT NULL))
ORDER BY "Element_Live"."Sort" ASC
LIMIT 1
0.0007s
0040: SELECT DISTINCT "Element_Live"."ClassName", "Element_Live"."LastEdited", "Element_Live"."Created", CASE
WHEN "ElementContent_Localised_en_US"."ID" IS NOT NULL THEN "ElementContent_Localised_en_US"."HTML"
WHEN "ElementContent_Localised_es_419"."ID" IS NOT NULL THEN "ElementContent_Localised_es_419"."HTML"
ELSE "ElementContent_Live"."HTML" END
AS "HTML", "Element_Live"."ID",
CASE WHEN "Element_Live"."ClassName" IS NOT NULL THEN "Element_Live"."ClassName"
ELSE 'DNADesign\\Elemental\\Models\\BaseElement' END AS "RecordClassName", 'en_US' AS "Locale", CASE WHEN "ElementContent_Localised_en_US"."ID" IS NOT NULL THEN 'en_US'
WHEN "ElementContent_Localised_es_419"."ID" IS NOT NULL THEN 'es_419'
ELSE NULL END AS "SourceLocale", "Element_Live"."Sort"
FROM "Element_Live" LEFT JOIN "ElementContent_Live" ON "ElementContent_Live"."ID" = "Element_Live"."ID" LEFT JOIN "Element_Localised_Live" AS "Element_Localised_en_US" ON "Element_Live"."ID" = "Element_Localised_en_US"."RecordID" AND "Element_Localised_en_US"."Locale" = ? LEFT JOIN "Element_Localised_Live" AS "Element_Localised_es_419" ON "Element_Live"."ID" = "Element_Localised_es_419"."RecordID" AND "Element_Localised_es_419"."Locale" = ? LEFT JOIN "ElementContent_Localised_Live" AS "ElementContent_Localised_en_US" ON "ElementContent_Live"."ID" = "ElementContent_Localised_en_US"."RecordID" AND "ElementContent_Localised_en_US"."Locale" = ? LEFT JOIN "ElementContent_Localised_Live" AS "ElementContent_Localised_es_419" ON "ElementContent_Live"."ID" = "ElementContent_Localised_es_419"."RecordID" AND "ElementContent_Localised_es_419"."Locale" = ?
WHERE ("Element_Live"."ID" = ?)
AND ("Element_Live"."ClassName" IN (?, ?, ?, ?, ?, ?, ?, ?, ?))
AND (("Element_Localised_en_US"."ID" IS NOT NULL) OR ("Element_Localised_es_419"."ID" IS NOT NULL))
ORDER BY "Element_Live"."Sort" ASC
LIMIT 1
0.0007s
0041: SELECT DISTINCT count(DISTINCT "Link"."ID") AS "Count"
FROM "Link" LEFT JOIN "FooterLink" ON "FooterLink"."ID" = "Link"."ID"
WHERE ("FooterLink"."SiteConfigID" = ?)
AND ("Link"."ClassName" IN (?))
0.0004s
0042: SELECT DISTINCT "Link"."ClassName", "Link"."LastEdited", "Link"."Created", "Link"."Anchor", "Link"."Title", "Link"."Type", "Link"."URL", "Link"."Email", "Link"."Phone", "Link"."OpenInNewWindow", "Link"."SelectedStyle", "Link"."SiteTreeID", "Link"."FileID", "FooterLink"."IconClass", "FooterLink"."Sort", "FooterLink"."HideTitle", "FooterLink"."IconFileID", "FooterLink"."SiteConfigID", "Link"."ID",
CASE WHEN "Link"."ClassName" IS NOT NULL THEN "Link"."ClassName"
ELSE 'gorriecoe\\Link\\Models\\Link' END AS "RecordClassName"
FROM "Link" LEFT JOIN "FooterLink" ON "FooterLink"."ID" = "Link"."ID"
WHERE ("FooterLink"."SiteConfigID" = ?)
AND ("Link"."ClassName" IN (?))
ORDER BY "FooterLink"."Sort" ASC
0.0011s
0043: SELECT "Version" FROM "SiteTree" WHERE "ID" = ?
0.0003s
0044: SELECT "BaseTable"."RecordID", MAX("SiteTree_Localised_Versions"."Version") as "LatestVersion" FROM "SiteTree_Localised" AS "BaseTable" INNER JOIN "SiteTree_Localised_Versions" ON "BaseTable"."RecordID" = "SiteTree_Localised_Versions"."RecordID" AND "SiteTree_Localised_Versions"."Locale" = ? INNER JOIN "SiteTree_Versions" ON "SiteTree_Versions"."RecordID" = "SiteTree_Localised_Versions"."RecordID" AND "SiteTree_Versions"."Version" = "SiteTree_Localised_Versions"."Version" WHERE "BaseTable"."Locale" = ? AND "BaseTable"."RecordID" IN (?) GROUP BY "BaseTable"."RecordID"
0.0006s
0045: SELECT "ID"
FROM "SiteTree_Localised_Live"
WHERE ("RecordID" = ?)
AND ("Locale" = ?)
LIMIT 1
0.0002s
0046: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."CanViewType", "SiteTree_Live"."CanEditType", "SiteTree_Live"."Version", CASE
WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."URLSegment"
WHEN "SiteTree_Localised_es_419"."ID" IS NOT NULL THEN "SiteTree_Localised_es_419"."URLSegment"
ELSE "SiteTree_Live"."URLSegment" END
AS "URLSegment", CASE
WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."Title"
WHEN "SiteTree_Localised_es_419"."ID" IS NOT NULL THEN "SiteTree_Localised_es_419"."Title"
ELSE "SiteTree_Live"."Title" END
AS "Title", CASE
WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."MenuTitle"
WHEN "SiteTree_Localised_es_419"."ID" IS NOT NULL THEN "SiteTree_Localised_es_419"."MenuTitle"
ELSE "SiteTree_Live"."MenuTitle" END
AS "MenuTitle", CASE
WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."Content"
WHEN "SiteTree_Localised_es_419"."ID" IS NOT NULL THEN "SiteTree_Localised_es_419"."Content"
ELSE "SiteTree_Live"."Content" END
AS "Content", CASE
WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."MetaDescription"
WHEN "SiteTree_Localised_es_419"."ID" IS NOT NULL THEN "SiteTree_Localised_es_419"."MetaDescription"
ELSE "SiteTree_Live"."MetaDescription" END
AS "MetaDescription", "SiteTree_Live"."ExtraMeta", "SiteTree_Live"."ShowInMenus", "SiteTree_Live"."ShowInSearch", "SiteTree_Live"."Sort", "SiteTree_Live"."HasBrokenFile", "SiteTree_Live"."HasBrokenLink", CASE
WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."ReportClass"
WHEN "SiteTree_Localised_es_419"."ID" IS NOT NULL THEN "SiteTree_Localised_es_419"."ReportClass"
ELSE "SiteTree_Live"."ReportClass" END
AS "ReportClass", "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", 'en_US' AS "Locale", CASE WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN 'en_US'
WHEN "SiteTree_Localised_es_419"."ID" IS NOT NULL THEN 'es_419'
ELSE NULL END AS "SourceLocale"
FROM "SiteTree_Live" LEFT JOIN "SiteTree_Localised_Live" AS "SiteTree_Localised_en_US" ON "SiteTree_Live"."ID" = "SiteTree_Localised_en_US"."RecordID" AND "SiteTree_Localised_en_US"."Locale" = ? LEFT JOIN "SiteTree_Localised_Live" AS "SiteTree_Localised_es_419" ON "SiteTree_Live"."ID" = "SiteTree_Localised_es_419"."RecordID" AND "SiteTree_Localised_es_419"."Locale" = ?
WHERE ("SiteTree_Live"."ID" = ?)
AND (("SiteTree_Localised_en_US"."ID" IS NOT NULL) OR ("SiteTree_Localised_es_419"."ID" IS NOT NULL))
ORDER BY "SiteTree_Live"."Sort" ASC
LIMIT 1
0.0008s
0047: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."CanViewType", "SiteTree_Live"."CanEditType", "SiteTree_Live"."Version", CASE
WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."URLSegment"
WHEN "SiteTree_Localised_es_419"."ID" IS NOT NULL THEN "SiteTree_Localised_es_419"."URLSegment"
ELSE "SiteTree_Live"."URLSegment" END
AS "URLSegment", CASE
WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."Title"
WHEN "SiteTree_Localised_es_419"."ID" IS NOT NULL THEN "SiteTree_Localised_es_419"."Title"
ELSE "SiteTree_Live"."Title" END
AS "Title", CASE
WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."MenuTitle"
WHEN "SiteTree_Localised_es_419"."ID" IS NOT NULL THEN "SiteTree_Localised_es_419"."MenuTitle"
ELSE "SiteTree_Live"."MenuTitle" END
AS "MenuTitle", CASE
WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."Content"
WHEN "SiteTree_Localised_es_419"."ID" IS NOT NULL THEN "SiteTree_Localised_es_419"."Content"
ELSE "SiteTree_Live"."Content" END
AS "Content", CASE
WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."MetaDescription"
WHEN "SiteTree_Localised_es_419"."ID" IS NOT NULL THEN "SiteTree_Localised_es_419"."MetaDescription"
ELSE "SiteTree_Live"."MetaDescription" END
AS "MetaDescription", "SiteTree_Live"."ExtraMeta", "SiteTree_Live"."ShowInMenus", "SiteTree_Live"."ShowInSearch", "SiteTree_Live"."Sort", "SiteTree_Live"."HasBrokenFile", "SiteTree_Live"."HasBrokenLink", CASE
WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."ReportClass"
WHEN "SiteTree_Localised_es_419"."ID" IS NOT NULL THEN "SiteTree_Localised_es_419"."ReportClass"
ELSE "SiteTree_Live"."ReportClass" END
AS "ReportClass", "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", 'en_US' AS "Locale", CASE WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN 'en_US'
WHEN "SiteTree_Localised_es_419"."ID" IS NOT NULL THEN 'es_419'
ELSE NULL END AS "SourceLocale"
FROM "SiteTree_Live" LEFT JOIN "SiteTree_Localised_Live" AS "SiteTree_Localised_en_US" ON "SiteTree_Live"."ID" = "SiteTree_Localised_en_US"."RecordID" AND "SiteTree_Localised_en_US"."Locale" = ? LEFT JOIN "SiteTree_Localised_Live" AS "SiteTree_Localised_es_419" ON "SiteTree_Live"."ID" = "SiteTree_Localised_es_419"."RecordID" AND "SiteTree_Localised_es_419"."Locale" = ?
WHERE ("SiteTree_Live"."ID" = ?)
AND (("SiteTree_Localised_en_US"."ID" IS NOT NULL) OR ("SiteTree_Localised_es_419"."ID" IS NOT NULL))
ORDER BY "SiteTree_Live"."Sort" ASC
LIMIT 1
0.0008s
0048: SELECT DISTINCT "SiteTree"."ClassName", "SiteTree"."LastEdited", "SiteTree"."Created", "SiteTree"."CanViewType", "SiteTree"."CanEditType", "SiteTree"."Version", CASE
WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."URLSegment"
WHEN "SiteTree_Localised_es_419"."ID" IS NOT NULL THEN "SiteTree_Localised_es_419"."URLSegment"
ELSE "SiteTree"."URLSegment" END
AS "URLSegment", CASE
WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."Title"
WHEN "SiteTree_Localised_es_419"."ID" IS NOT NULL THEN "SiteTree_Localised_es_419"."Title"
ELSE "SiteTree"."Title" END
AS "Title", CASE
WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."MenuTitle"
WHEN "SiteTree_Localised_es_419"."ID" IS NOT NULL THEN "SiteTree_Localised_es_419"."MenuTitle"
ELSE "SiteTree"."MenuTitle" END
AS "MenuTitle", CASE
WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."Content"
WHEN "SiteTree_Localised_es_419"."ID" IS NOT NULL THEN "SiteTree_Localised_es_419"."Content"
ELSE "SiteTree"."Content" END
AS "Content", CASE
WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."MetaDescription"
WHEN "SiteTree_Localised_es_419"."ID" IS NOT NULL THEN "SiteTree_Localised_es_419"."MetaDescription"
ELSE "SiteTree"."MetaDescription" END
AS "MetaDescription", "SiteTree"."ExtraMeta", "SiteTree"."ShowInMenus", "SiteTree"."ShowInSearch", "SiteTree"."Sort", "SiteTree"."HasBrokenFile", "SiteTree"."HasBrokenLink", CASE
WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."ReportClass"
WHEN "SiteTree_Localised_es_419"."ID" IS NOT NULL THEN "SiteTree_Localised_es_419"."ReportClass"
ELSE "SiteTree"."ReportClass" END
AS "ReportClass", "SiteTree"."ParentID", "SiteTree"."ID",
CASE WHEN "SiteTree"."ClassName" IS NOT NULL THEN "SiteTree"."ClassName"
ELSE 'SilverStripe\\CMS\\Model\\SiteTree' END AS "RecordClassName", 'en_US' AS "Locale", CASE WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN 'en_US'
WHEN "SiteTree_Localised_es_419"."ID" IS NOT NULL THEN 'es_419'
ELSE NULL END AS "SourceLocale"
FROM "SiteTree" LEFT JOIN "SiteTree_Localised" AS "SiteTree_Localised_en_US" ON "SiteTree"."ID" = "SiteTree_Localised_en_US"."RecordID" AND "SiteTree_Localised_en_US"."Locale" = ? LEFT JOIN "SiteTree_Localised" AS "SiteTree_Localised_es_419" ON "SiteTree"."ID" = "SiteTree_Localised_es_419"."RecordID" AND "SiteTree_Localised_es_419"."Locale" = ?
WHERE ("SiteTree"."ID" = ?)
AND (("SiteTree_Localised_en_US"."ID" IS NOT NULL) OR ("SiteTree_Localised_es_419"."ID" IS NOT NULL))
ORDER BY "SiteTree"."Sort" ASC
LIMIT 1
0.0005s
0049: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."CanViewType", "SiteTree_Live"."CanEditType", "SiteTree_Live"."Version", CASE
WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."URLSegment"
WHEN "SiteTree_Localised_es_419"."ID" IS NOT NULL THEN "SiteTree_Localised_es_419"."URLSegment"
ELSE "SiteTree_Live"."URLSegment" END
AS "URLSegment", CASE
WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."Title"
WHEN "SiteTree_Localised_es_419"."ID" IS NOT NULL THEN "SiteTree_Localised_es_419"."Title"
ELSE "SiteTree_Live"."Title" END
AS "Title", CASE
WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."MenuTitle"
WHEN "SiteTree_Localised_es_419"."ID" IS NOT NULL THEN "SiteTree_Localised_es_419"."MenuTitle"
ELSE "SiteTree_Live"."MenuTitle" END
AS "MenuTitle", CASE
WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."Content"
WHEN "SiteTree_Localised_es_419"."ID" IS NOT NULL THEN "SiteTree_Localised_es_419"."Content"
ELSE "SiteTree_Live"."Content" END
AS "Content", CASE
WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."MetaDescription"
WHEN "SiteTree_Localised_es_419"."ID" IS NOT NULL THEN "SiteTree_Localised_es_419"."MetaDescription"
ELSE "SiteTree_Live"."MetaDescription" END
AS "MetaDescription", "SiteTree_Live"."ExtraMeta", "SiteTree_Live"."ShowInMenus", "SiteTree_Live"."ShowInSearch", "SiteTree_Live"."Sort", "SiteTree_Live"."HasBrokenFile", "SiteTree_Live"."HasBrokenLink", CASE
WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."ReportClass"
WHEN "SiteTree_Localised_es_419"."ID" IS NOT NULL THEN "SiteTree_Localised_es_419"."ReportClass"
ELSE "SiteTree_Live"."ReportClass" END
AS "ReportClass", "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", 'en_US' AS "Locale", CASE WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN 'en_US'
WHEN "SiteTree_Localised_es_419"."ID" IS NOT NULL THEN 'es_419'
ELSE NULL END AS "SourceLocale"
FROM "SiteTree_Live" LEFT JOIN "SiteTree_Localised_Live" AS "SiteTree_Localised_en_US" ON "SiteTree_Live"."ID" = "SiteTree_Localised_en_US"."RecordID" AND "SiteTree_Localised_en_US"."Locale" = ? LEFT JOIN "SiteTree_Localised_Live" AS "SiteTree_Localised_es_419" ON "SiteTree_Live"."ID" = "SiteTree_Localised_es_419"."RecordID" AND "SiteTree_Localised_es_419"."Locale" = ?
WHERE ("SiteTree_Live"."ID" = ?)
AND (("SiteTree_Localised_en_US"."ID" IS NOT NULL) OR ("SiteTree_Localised_es_419"."ID" IS NOT NULL))
ORDER BY "SiteTree_Live"."Sort" ASC
LIMIT 1
0.0006s
Home
Welcome to Buena Vista Horace Mann K-8 Community School
For information about teachers, staff, bell schedules, school handbooks, etc. please visit the official SFUSD website for BVHM.
Buena Vista Horace Mann K-8 Community School is a K–8th grade public elementary and middle school in the Mission District of San Francisco, California with the proud distinction of being San Francisco Unified School District’s first Two-Way Spanish Immersion School.
ParentSquare is the primary communication tool at BVHM. If you are a BVHM parent but have not signed up for our electronic directory and communication system, ParentSquare, please go to https://www.parentsquare.com/signin to register for an account. To learn more about ParentSquare, please review this video.
Support BVHM
Support BVHM! Please help us Fill the Jar and support our annual fundraising campaign today. Donate here.
Welcome to SilverStripe! This is the default homepage. You can edit this page by opening the CMS.
