0006: 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"."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"."Locale" ASC 0.0009s

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

0009: SELECT DISTINCT "Fluent_FallbackLocale"."ClassName" AS "Fluent_FallbackLocale_ClassName", "Fluent_FallbackLocale"."LastEdited" AS "Fluent_FallbackLocale_LastEdited", "Fluent_FallbackLocale"."Created" AS "Fluent_FallbackLocale_Created", "Fluent_FallbackLocale"."Sort" AS "Fluent_FallbackLocale_Sort", "Fluent_FallbackLocale"."ParentID" AS "Fluent_FallbackLocale_ParentID", "Fluent_FallbackLocale"."LocaleID" AS "Fluent_FallbackLocale_LocaleID", "Fluent_FallbackLocale"."ID" AS "Fluent_FallbackLocale_ID", "Fluent_FallbackLocale"."RecordClassName" AS "Fluent_FallbackLocale_RecordClassName", "Fluent_Locale"."ClassName", "Fluent_Locale"."LastEdited", "Fluent_Locale"."Created", "Fluent_Locale"."Title", "Fluent_Locale"."Locale", "Fluent_Locale"."URLSegment", "Fluent_Locale"."IsGlobalDefault", "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" INNER JOIN (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" = ?)) AS "Fluent_FallbackLocale" ON "Fluent_FallbackLocale"."LocaleID" = "Fluent_Locale"."ID" ORDER BY "Fluent_Locale"."Locale" ASC 0.0009s

0010: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", CASE WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."BetterSiteTitle" ELSE "SiteTree_Live"."BetterSiteTitle" END AS "BetterSiteTitle", CASE WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."Keyword" ELSE "SiteTree_Live"."Keyword" END AS "Keyword", CASE WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."FeaturedKeyword" ELSE "SiteTree_Live"."FeaturedKeyword" END AS "FeaturedKeyword", CASE WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."KeywordQuestion" ELSE "SiteTree_Live"."KeywordQuestion" END AS "KeywordQuestion", "SiteTree_Live"."Follow", "SiteTree_Live"."FollowType", CASE WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."GenMetaDesc" ELSE "SiteTree_Live"."GenMetaDesc" END AS "GenMetaDesc", CASE WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."FBTitle" ELSE "SiteTree_Live"."FBTitle" END AS "FBTitle", CASE WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."FBDescription" ELSE "SiteTree_Live"."FBDescription" END AS "FBDescription", "SiteTree_Live"."FBType", "SiteTree_Live"."FBTypeOverride", CASE WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."TwTitle" ELSE "SiteTree_Live"."TwTitle" END AS "TwTitle", CASE WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."TwDescription" ELSE "SiteTree_Live"."TwDescription" END AS "TwDescription", "SiteTree_Live"."CanViewType", "SiteTree_Live"."CanEditType", "SiteTree_Live"."Version", CASE WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."URLSegment" ELSE "SiteTree_Live"."URLSegment" END AS "URLSegment", CASE WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."Title" ELSE "SiteTree_Live"."Title" END AS "Title", CASE WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."MenuTitle" ELSE "SiteTree_Live"."MenuTitle" END AS "MenuTitle", CASE WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."Content" ELSE "SiteTree_Live"."Content" END AS "Content", CASE WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."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_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."ReportClass" ELSE "SiteTree_Live"."ReportClass" END AS "ReportClass", "SiteTree_Live"."CanonicalLinkID", "SiteTree_Live"."FBImageID", "SiteTree_Live"."TwImageID", "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_GB' AS "Locale", CASE WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN 'en_GB' ELSE NULL END AS "SourceLocale" FROM "SiteTree_Live" LEFT JOIN "SiteTree_Localised_Live" AS "SiteTree_Localised_en_GB" ON "SiteTree_Live"."ID" = "SiteTree_Localised_en_GB"."RecordID" AND "SiteTree_Localised_en_GB"."Locale" = ? WHERE (COALESCE("SiteTree_Localised_en_GB"."URLSegment", "SiteTree_Live"."URLSegment") = ?) AND ("SiteTree_Live"."ParentID" = ?) AND (("SiteTree_Localised_en_GB"."ID" IS NOT NULL)) ORDER BY "SiteTree_Live"."Sort" ASC LIMIT 1 0.0026s

0011: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", CASE WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."BetterSiteTitle" ELSE "SiteTree_Live"."BetterSiteTitle" END AS "BetterSiteTitle", CASE WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."Keyword" ELSE "SiteTree_Live"."Keyword" END AS "Keyword", CASE WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."FeaturedKeyword" ELSE "SiteTree_Live"."FeaturedKeyword" END AS "FeaturedKeyword", CASE WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."KeywordQuestion" ELSE "SiteTree_Live"."KeywordQuestion" END AS "KeywordQuestion", "SiteTree_Live"."Follow", "SiteTree_Live"."FollowType", CASE WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."GenMetaDesc" ELSE "SiteTree_Live"."GenMetaDesc" END AS "GenMetaDesc", CASE WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."FBTitle" ELSE "SiteTree_Live"."FBTitle" END AS "FBTitle", CASE WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."FBDescription" ELSE "SiteTree_Live"."FBDescription" END AS "FBDescription", "SiteTree_Live"."FBType", "SiteTree_Live"."FBTypeOverride", CASE WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."TwTitle" ELSE "SiteTree_Live"."TwTitle" END AS "TwTitle", CASE WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."TwDescription" ELSE "SiteTree_Live"."TwDescription" END AS "TwDescription", "SiteTree_Live"."CanViewType", "SiteTree_Live"."CanEditType", "SiteTree_Live"."Version", CASE WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."URLSegment" ELSE "SiteTree_Live"."URLSegment" END AS "URLSegment", CASE WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."Title" ELSE "SiteTree_Live"."Title" END AS "Title", CASE WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."MenuTitle" ELSE "SiteTree_Live"."MenuTitle" END AS "MenuTitle", CASE WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."Content" ELSE "SiteTree_Live"."Content" END AS "Content", CASE WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."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_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."ReportClass" ELSE "SiteTree_Live"."ReportClass" END AS "ReportClass", "SiteTree_Live"."CanonicalLinkID", "SiteTree_Live"."FBImageID", "SiteTree_Live"."TwImageID", "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_GB' AS "Locale", CASE WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN 'en_GB' ELSE NULL END AS "SourceLocale" FROM "SiteTree_Live" LEFT JOIN "SiteTree_Localised_Live" AS "SiteTree_Localised_en_GB" ON "SiteTree_Live"."ID" = "SiteTree_Localised_en_GB"."RecordID" AND "SiteTree_Localised_en_GB"."Locale" = ? WHERE ("SiteTree_Live"."ParentID" = ?) AND (COALESCE("SiteTree_Localised_en_GB"."URLSegment", "SiteTree_Live"."URLSegment") = ?) AND (("SiteTree_Localised_en_GB"."ID" IS NOT NULL)) ORDER BY "SiteTree_Live"."Sort" ASC LIMIT 1 0.0013s

0012: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", CASE WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."BetterSiteTitle" ELSE "SiteTree_Live"."BetterSiteTitle" END AS "BetterSiteTitle", CASE WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."Keyword" ELSE "SiteTree_Live"."Keyword" END AS "Keyword", CASE WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."FeaturedKeyword" ELSE "SiteTree_Live"."FeaturedKeyword" END AS "FeaturedKeyword", CASE WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."KeywordQuestion" ELSE "SiteTree_Live"."KeywordQuestion" END AS "KeywordQuestion", "SiteTree_Live"."Follow", "SiteTree_Live"."FollowType", CASE WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."GenMetaDesc" ELSE "SiteTree_Live"."GenMetaDesc" END AS "GenMetaDesc", CASE WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."FBTitle" ELSE "SiteTree_Live"."FBTitle" END AS "FBTitle", CASE WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."FBDescription" ELSE "SiteTree_Live"."FBDescription" END AS "FBDescription", "SiteTree_Live"."FBType", "SiteTree_Live"."FBTypeOverride", CASE WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."TwTitle" ELSE "SiteTree_Live"."TwTitle" END AS "TwTitle", CASE WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."TwDescription" ELSE "SiteTree_Live"."TwDescription" END AS "TwDescription", "SiteTree_Live"."CanViewType", "SiteTree_Live"."CanEditType", "SiteTree_Live"."Version", CASE WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."URLSegment" ELSE "SiteTree_Live"."URLSegment" END AS "URLSegment", CASE WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."Title" ELSE "SiteTree_Live"."Title" END AS "Title", CASE WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."MenuTitle" ELSE "SiteTree_Live"."MenuTitle" END AS "MenuTitle", CASE WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."Content" ELSE "SiteTree_Live"."Content" END AS "Content", CASE WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."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_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."ReportClass" ELSE "SiteTree_Live"."ReportClass" END AS "ReportClass", "SiteTree_Live"."CanonicalLinkID", "SiteTree_Live"."FBImageID", "SiteTree_Live"."TwImageID", "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_GB' AS "Locale", CASE WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN 'en_GB' ELSE NULL END AS "SourceLocale" FROM "SiteTree_Live" LEFT JOIN "SiteTree_Localised_Live" AS "SiteTree_Localised_en_GB" ON "SiteTree_Live"."ID" = "SiteTree_Localised_en_GB"."RecordID" AND "SiteTree_Localised_en_GB"."Locale" = ? WHERE ("SiteTree_Live"."ID" = ?) AND (("SiteTree_Localised_en_GB"."ID" IS NOT NULL)) ORDER BY "SiteTree_Live"."Sort" ASC LIMIT 1 0.0006s

0013: SELECT DISTINCT "SiteConfig"."ClassName", "SiteConfig"."LastEdited", "SiteConfig"."Created", CASE WHEN "SiteConfig_Localised_en_GB"."ID" IS NOT NULL THEN "SiteConfig_Localised_en_GB"."FooterCol1" ELSE "SiteConfig"."FooterCol1" END AS "FooterCol1", CASE WHEN "SiteConfig_Localised_en_GB"."ID" IS NOT NULL THEN "SiteConfig_Localised_en_GB"."FooterCol2" ELSE "SiteConfig"."FooterCol2" END AS "FooterCol2", CASE WHEN "SiteConfig_Localised_en_GB"."ID" IS NOT NULL THEN "SiteConfig_Localised_en_GB"."FooterCol3" ELSE "SiteConfig"."FooterCol3" END AS "FooterCol3", CASE WHEN "SiteConfig_Localised_en_GB"."ID" IS NOT NULL THEN "SiteConfig_Localised_en_GB"."FooterCol4" ELSE "SiteConfig"."FooterCol4" END AS "FooterCol4", "SiteConfig"."CookieConsentNotice", "SiteConfig"."CookieBtnOk", "SiteConfig"."CookieChooseText", "SiteConfig"."CookieBtnDislike", "SiteConfig"."CookieAllowGMaps", "SiteConfig"."CookieTextUnderBtn", "SiteConfig"."CookieAllowYouTube", "SiteConfig"."CookieConsentPopUpHeadline", "SiteConfig"."CookieConsentPopUpNotice", "SiteConfig"."CookieConsentPopUpDisallow", "SiteConfig"."CookieConsentPopUpAllowAll", "SiteConfig"."CookieConsentPopUpAllowSelected", "SiteConfig"."CookiePrivacyPolicyTitle", "SiteConfig"."CookiePrivacyPolicyText", CASE WHEN "SiteConfig_Localised_en_GB"."ID" IS NOT NULL THEN "SiteConfig_Localised_en_GB"."Title" ELSE "SiteConfig"."Title" END AS "Title", CASE WHEN "SiteConfig_Localised_en_GB"."ID" IS NOT NULL THEN "SiteConfig_Localised_en_GB"."Tagline" ELSE "SiteConfig"."Tagline" END AS "Tagline", "SiteConfig"."CanViewType", "SiteConfig"."CanEditType", "SiteConfig"."CanCreateTopLevelType", "SiteConfig"."ID", CASE WHEN "SiteConfig"."ClassName" IS NOT NULL THEN "SiteConfig"."ClassName" ELSE 'SilverStripe\\SiteConfig\\SiteConfig' END AS "RecordClassName", 'en_GB' AS "Locale", CASE WHEN "SiteConfig_Localised_en_GB"."ID" IS NOT NULL THEN 'en_GB' ELSE NULL END AS "SourceLocale" FROM "SiteConfig" LEFT JOIN "SiteConfig_Localised" AS "SiteConfig_Localised_en_GB" ON "SiteConfig"."ID" = "SiteConfig_Localised_en_GB"."RecordID" AND "SiteConfig_Localised_en_GB"."Locale" = ? LIMIT 1 0.0019s

0014: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", CASE WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."BetterSiteTitle" ELSE "SiteTree_Live"."BetterSiteTitle" END AS "BetterSiteTitle", CASE WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."Keyword" ELSE "SiteTree_Live"."Keyword" END AS "Keyword", CASE WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."FeaturedKeyword" ELSE "SiteTree_Live"."FeaturedKeyword" END AS "FeaturedKeyword", CASE WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."KeywordQuestion" ELSE "SiteTree_Live"."KeywordQuestion" END AS "KeywordQuestion", "SiteTree_Live"."Follow", "SiteTree_Live"."FollowType", CASE WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."GenMetaDesc" ELSE "SiteTree_Live"."GenMetaDesc" END AS "GenMetaDesc", CASE WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."FBTitle" ELSE "SiteTree_Live"."FBTitle" END AS "FBTitle", CASE WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."FBDescription" ELSE "SiteTree_Live"."FBDescription" END AS "FBDescription", "SiteTree_Live"."FBType", "SiteTree_Live"."FBTypeOverride", CASE WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."TwTitle" ELSE "SiteTree_Live"."TwTitle" END AS "TwTitle", CASE WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."TwDescription" ELSE "SiteTree_Live"."TwDescription" END AS "TwDescription", "SiteTree_Live"."CanViewType", "SiteTree_Live"."CanEditType", "SiteTree_Live"."Version", CASE WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."URLSegment" ELSE "SiteTree_Live"."URLSegment" END AS "URLSegment", CASE WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."Title" ELSE "SiteTree_Live"."Title" END AS "Title", CASE WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."MenuTitle" ELSE "SiteTree_Live"."MenuTitle" END AS "MenuTitle", CASE WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."Content" ELSE "SiteTree_Live"."Content" END AS "Content", CASE WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."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_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."ReportClass" ELSE "SiteTree_Live"."ReportClass" END AS "ReportClass", "SiteTree_Live"."CanonicalLinkID", "SiteTree_Live"."FBImageID", "SiteTree_Live"."TwImageID", "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_GB' AS "Locale", CASE WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN 'en_GB' ELSE NULL END AS "SourceLocale" FROM "SiteTree_Live" LEFT JOIN "SiteTree_Localised_Live" AS "SiteTree_Localised_en_GB" ON "SiteTree_Live"."ID" = "SiteTree_Localised_en_GB"."RecordID" AND "SiteTree_Localised_en_GB"."Locale" = ? WHERE ("SiteTree_Live"."ParentID" <> "SiteTree_Live"."ID") AND ("SiteTree_Live"."ParentID" = ?) AND ("SiteTree_Live"."ShowInMenus" = ?) AND (("SiteTree_Localised_en_GB"."ID" IS NOT NULL)) ORDER BY "SiteTree_Live"."Sort" ASC 0.0019s

0015: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", CASE WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."BetterSiteTitle" ELSE "SiteTree_Live"."BetterSiteTitle" END AS "BetterSiteTitle", CASE WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."Keyword" ELSE "SiteTree_Live"."Keyword" END AS "Keyword", CASE WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."FeaturedKeyword" ELSE "SiteTree_Live"."FeaturedKeyword" END AS "FeaturedKeyword", CASE WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."KeywordQuestion" ELSE "SiteTree_Live"."KeywordQuestion" END AS "KeywordQuestion", "SiteTree_Live"."Follow", "SiteTree_Live"."FollowType", CASE WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."GenMetaDesc" ELSE "SiteTree_Live"."GenMetaDesc" END AS "GenMetaDesc", CASE WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."FBTitle" ELSE "SiteTree_Live"."FBTitle" END AS "FBTitle", CASE WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."FBDescription" ELSE "SiteTree_Live"."FBDescription" END AS "FBDescription", "SiteTree_Live"."FBType", "SiteTree_Live"."FBTypeOverride", CASE WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."TwTitle" ELSE "SiteTree_Live"."TwTitle" END AS "TwTitle", CASE WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."TwDescription" ELSE "SiteTree_Live"."TwDescription" END AS "TwDescription", "SiteTree_Live"."CanViewType", "SiteTree_Live"."CanEditType", "SiteTree_Live"."Version", CASE WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."URLSegment" ELSE "SiteTree_Live"."URLSegment" END AS "URLSegment", CASE WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."Title" ELSE "SiteTree_Live"."Title" END AS "Title", CASE WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."MenuTitle" ELSE "SiteTree_Live"."MenuTitle" END AS "MenuTitle", CASE WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."Content" ELSE "SiteTree_Live"."Content" END AS "Content", CASE WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."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_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."ReportClass" ELSE "SiteTree_Live"."ReportClass" END AS "ReportClass", "SiteTree_Live"."CanonicalLinkID", "SiteTree_Live"."FBImageID", "SiteTree_Live"."TwImageID", "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_GB' AS "Locale", CASE WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN 'en_GB' ELSE NULL END AS "SourceLocale" FROM "SiteTree_Live" LEFT JOIN "SiteTree_Localised_Live" AS "SiteTree_Localised_en_GB" ON "SiteTree_Live"."ID" = "SiteTree_Localised_en_GB"."RecordID" AND "SiteTree_Localised_en_GB"."Locale" = ? WHERE ("SiteTree_Live"."ID" = ?) AND (("SiteTree_Localised_en_GB"."ID" IS NOT NULL)) ORDER BY "SiteTree_Live"."Sort" ASC LIMIT 1 0.0001s

0016: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", CASE WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."BetterSiteTitle" ELSE "SiteTree_Live"."BetterSiteTitle" END AS "BetterSiteTitle", CASE WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."Keyword" ELSE "SiteTree_Live"."Keyword" END AS "Keyword", CASE WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."FeaturedKeyword" ELSE "SiteTree_Live"."FeaturedKeyword" END AS "FeaturedKeyword", CASE WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."KeywordQuestion" ELSE "SiteTree_Live"."KeywordQuestion" END AS "KeywordQuestion", "SiteTree_Live"."Follow", "SiteTree_Live"."FollowType", CASE WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."GenMetaDesc" ELSE "SiteTree_Live"."GenMetaDesc" END AS "GenMetaDesc", CASE WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."FBTitle" ELSE "SiteTree_Live"."FBTitle" END AS "FBTitle", CASE WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."FBDescription" ELSE "SiteTree_Live"."FBDescription" END AS "FBDescription", "SiteTree_Live"."FBType", "SiteTree_Live"."FBTypeOverride", CASE WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."TwTitle" ELSE "SiteTree_Live"."TwTitle" END AS "TwTitle", CASE WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."TwDescription" ELSE "SiteTree_Live"."TwDescription" END AS "TwDescription", "SiteTree_Live"."CanViewType", "SiteTree_Live"."CanEditType", "SiteTree_Live"."Version", CASE WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."URLSegment" ELSE "SiteTree_Live"."URLSegment" END AS "URLSegment", CASE WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."Title" ELSE "SiteTree_Live"."Title" END AS "Title", CASE WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."MenuTitle" ELSE "SiteTree_Live"."MenuTitle" END AS "MenuTitle", CASE WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."Content" ELSE "SiteTree_Live"."Content" END AS "Content", CASE WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."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_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."ReportClass" ELSE "SiteTree_Live"."ReportClass" END AS "ReportClass", "SiteTree_Live"."CanonicalLinkID", "SiteTree_Live"."FBImageID", "SiteTree_Live"."TwImageID", "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_GB' AS "Locale", CASE WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN 'en_GB' ELSE NULL END AS "SourceLocale" FROM "SiteTree_Live" LEFT JOIN "SiteTree_Localised_Live" AS "SiteTree_Localised_en_GB" ON "SiteTree_Live"."ID" = "SiteTree_Localised_en_GB"."RecordID" AND "SiteTree_Localised_en_GB"."Locale" = ? WHERE ("SiteTree_Live"."ID" = ?) AND (("SiteTree_Localised_en_GB"."ID" IS NOT NULL)) ORDER BY "SiteTree_Live"."Sort" ASC LIMIT 1 0.0001s

0017: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", CASE WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."BetterSiteTitle" ELSE "SiteTree_Live"."BetterSiteTitle" END AS "BetterSiteTitle", CASE WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."Keyword" ELSE "SiteTree_Live"."Keyword" END AS "Keyword", CASE WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."FeaturedKeyword" ELSE "SiteTree_Live"."FeaturedKeyword" END AS "FeaturedKeyword", CASE WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."KeywordQuestion" ELSE "SiteTree_Live"."KeywordQuestion" END AS "KeywordQuestion", "SiteTree_Live"."Follow", "SiteTree_Live"."FollowType", CASE WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."GenMetaDesc" ELSE "SiteTree_Live"."GenMetaDesc" END AS "GenMetaDesc", CASE WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."FBTitle" ELSE "SiteTree_Live"."FBTitle" END AS "FBTitle", CASE WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."FBDescription" ELSE "SiteTree_Live"."FBDescription" END AS "FBDescription", "SiteTree_Live"."FBType", "SiteTree_Live"."FBTypeOverride", CASE WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."TwTitle" ELSE "SiteTree_Live"."TwTitle" END AS "TwTitle", CASE WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."TwDescription" ELSE "SiteTree_Live"."TwDescription" END AS "TwDescription", "SiteTree_Live"."CanViewType", "SiteTree_Live"."CanEditType", "SiteTree_Live"."Version", CASE WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."URLSegment" ELSE "SiteTree_Live"."URLSegment" END AS "URLSegment", CASE WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."Title" ELSE "SiteTree_Live"."Title" END AS "Title", CASE WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."MenuTitle" ELSE "SiteTree_Live"."MenuTitle" END AS "MenuTitle", CASE WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."Content" ELSE "SiteTree_Live"."Content" END AS "Content", CASE WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."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_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."ReportClass" ELSE "SiteTree_Live"."ReportClass" END AS "ReportClass", "SiteTree_Live"."CanonicalLinkID", "SiteTree_Live"."FBImageID", "SiteTree_Live"."TwImageID", "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_GB' AS "Locale", CASE WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN 'en_GB' ELSE NULL END AS "SourceLocale" FROM "SiteTree_Live" LEFT JOIN "SiteTree_Localised_Live" AS "SiteTree_Localised_en_GB" ON "SiteTree_Live"."ID" = "SiteTree_Localised_en_GB"."RecordID" AND "SiteTree_Localised_en_GB"."Locale" = ? WHERE ("SiteTree_Live"."ID" = ?) AND (("SiteTree_Localised_en_GB"."ID" IS NOT NULL)) ORDER BY "SiteTree_Live"."Sort" ASC LIMIT 1 0.0001s

0018: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", CASE WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."BetterSiteTitle" ELSE "SiteTree_Live"."BetterSiteTitle" END AS "BetterSiteTitle", CASE WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."Keyword" ELSE "SiteTree_Live"."Keyword" END AS "Keyword", CASE WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."FeaturedKeyword" ELSE "SiteTree_Live"."FeaturedKeyword" END AS "FeaturedKeyword", CASE WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."KeywordQuestion" ELSE "SiteTree_Live"."KeywordQuestion" END AS "KeywordQuestion", "SiteTree_Live"."Follow", "SiteTree_Live"."FollowType", CASE WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."GenMetaDesc" ELSE "SiteTree_Live"."GenMetaDesc" END AS "GenMetaDesc", CASE WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."FBTitle" ELSE "SiteTree_Live"."FBTitle" END AS "FBTitle", CASE WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."FBDescription" ELSE "SiteTree_Live"."FBDescription" END AS "FBDescription", "SiteTree_Live"."FBType", "SiteTree_Live"."FBTypeOverride", CASE WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."TwTitle" ELSE "SiteTree_Live"."TwTitle" END AS "TwTitle", CASE WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."TwDescription" ELSE "SiteTree_Live"."TwDescription" END AS "TwDescription", "SiteTree_Live"."CanViewType", "SiteTree_Live"."CanEditType", "SiteTree_Live"."Version", CASE WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."URLSegment" ELSE "SiteTree_Live"."URLSegment" END AS "URLSegment", CASE WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."Title" ELSE "SiteTree_Live"."Title" END AS "Title", CASE WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."MenuTitle" ELSE "SiteTree_Live"."MenuTitle" END AS "MenuTitle", CASE WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."Content" ELSE "SiteTree_Live"."Content" END AS "Content", CASE WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."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_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."ReportClass" ELSE "SiteTree_Live"."ReportClass" END AS "ReportClass", "SiteTree_Live"."CanonicalLinkID", "SiteTree_Live"."FBImageID", "SiteTree_Live"."TwImageID", "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_GB' AS "Locale", CASE WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN 'en_GB' ELSE NULL END AS "SourceLocale" FROM "SiteTree_Live" LEFT JOIN "SiteTree_Localised_Live" AS "SiteTree_Localised_en_GB" ON "SiteTree_Live"."ID" = "SiteTree_Localised_en_GB"."RecordID" AND "SiteTree_Localised_en_GB"."Locale" = ? WHERE ("SiteTree_Live"."ID" = ?) AND (("SiteTree_Localised_en_GB"."ID" IS NOT NULL)) ORDER BY "SiteTree_Live"."Sort" ASC LIMIT 1 0.0001s

0019: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", CASE WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."BetterSiteTitle" ELSE "SiteTree_Live"."BetterSiteTitle" END AS "BetterSiteTitle", CASE WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."Keyword" ELSE "SiteTree_Live"."Keyword" END AS "Keyword", CASE WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."FeaturedKeyword" ELSE "SiteTree_Live"."FeaturedKeyword" END AS "FeaturedKeyword", CASE WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."KeywordQuestion" ELSE "SiteTree_Live"."KeywordQuestion" END AS "KeywordQuestion", "SiteTree_Live"."Follow", "SiteTree_Live"."FollowType", CASE WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."GenMetaDesc" ELSE "SiteTree_Live"."GenMetaDesc" END AS "GenMetaDesc", CASE WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."FBTitle" ELSE "SiteTree_Live"."FBTitle" END AS "FBTitle", CASE WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."FBDescription" ELSE "SiteTree_Live"."FBDescription" END AS "FBDescription", "SiteTree_Live"."FBType", "SiteTree_Live"."FBTypeOverride", CASE WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."TwTitle" ELSE "SiteTree_Live"."TwTitle" END AS "TwTitle", CASE WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."TwDescription" ELSE "SiteTree_Live"."TwDescription" END AS "TwDescription", "SiteTree_Live"."CanViewType", "SiteTree_Live"."CanEditType", "SiteTree_Live"."Version", CASE WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."URLSegment" ELSE "SiteTree_Live"."URLSegment" END AS "URLSegment", CASE WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."Title" ELSE "SiteTree_Live"."Title" END AS "Title", CASE WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."MenuTitle" ELSE "SiteTree_Live"."MenuTitle" END AS "MenuTitle", CASE WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."Content" ELSE "SiteTree_Live"."Content" END AS "Content", CASE WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."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_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."ReportClass" ELSE "SiteTree_Live"."ReportClass" END AS "ReportClass", "SiteTree_Live"."CanonicalLinkID", "SiteTree_Live"."FBImageID", "SiteTree_Live"."TwImageID", "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_GB' AS "Locale", CASE WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN 'en_GB' ELSE NULL END AS "SourceLocale" FROM "SiteTree_Live" LEFT JOIN "SiteTree_Localised_Live" AS "SiteTree_Localised_en_GB" ON "SiteTree_Live"."ID" = "SiteTree_Localised_en_GB"."RecordID" AND "SiteTree_Localised_en_GB"."Locale" = ? WHERE ("SiteTree_Live"."ID" = ?) AND (("SiteTree_Localised_en_GB"."ID" IS NOT NULL)) ORDER BY "SiteTree_Live"."Sort" ASC LIMIT 1 0.0001s

0020: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", CASE WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."BetterSiteTitle" ELSE "SiteTree_Live"."BetterSiteTitle" END AS "BetterSiteTitle", CASE WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."Keyword" ELSE "SiteTree_Live"."Keyword" END AS "Keyword", CASE WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."FeaturedKeyword" ELSE "SiteTree_Live"."FeaturedKeyword" END AS "FeaturedKeyword", CASE WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."KeywordQuestion" ELSE "SiteTree_Live"."KeywordQuestion" END AS "KeywordQuestion", "SiteTree_Live"."Follow", "SiteTree_Live"."FollowType", CASE WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."GenMetaDesc" ELSE "SiteTree_Live"."GenMetaDesc" END AS "GenMetaDesc", CASE WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."FBTitle" ELSE "SiteTree_Live"."FBTitle" END AS "FBTitle", CASE WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."FBDescription" ELSE "SiteTree_Live"."FBDescription" END AS "FBDescription", "SiteTree_Live"."FBType", "SiteTree_Live"."FBTypeOverride", CASE WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."TwTitle" ELSE "SiteTree_Live"."TwTitle" END AS "TwTitle", CASE WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."TwDescription" ELSE "SiteTree_Live"."TwDescription" END AS "TwDescription", "SiteTree_Live"."CanViewType", "SiteTree_Live"."CanEditType", "SiteTree_Live"."Version", CASE WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."URLSegment" ELSE "SiteTree_Live"."URLSegment" END AS "URLSegment", CASE WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."Title" ELSE "SiteTree_Live"."Title" END AS "Title", CASE WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."MenuTitle" ELSE "SiteTree_Live"."MenuTitle" END AS "MenuTitle", CASE WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."Content" ELSE "SiteTree_Live"."Content" END AS "Content", CASE WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."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_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."ReportClass" ELSE "SiteTree_Live"."ReportClass" END AS "ReportClass", "SiteTree_Live"."CanonicalLinkID", "SiteTree_Live"."FBImageID", "SiteTree_Live"."TwImageID", "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_GB' AS "Locale", CASE WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN 'en_GB' ELSE NULL END AS "SourceLocale" FROM "SiteTree_Live" LEFT JOIN "SiteTree_Localised_Live" AS "SiteTree_Localised_en_GB" ON "SiteTree_Live"."ID" = "SiteTree_Localised_en_GB"."RecordID" AND "SiteTree_Localised_en_GB"."Locale" = ? WHERE ("SiteTree_Live"."ID" = ?) AND (("SiteTree_Localised_en_GB"."ID" IS NOT NULL)) ORDER BY "SiteTree_Live"."Sort" ASC LIMIT 1 0.0001s

0021: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", CASE WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."BetterSiteTitle" ELSE "SiteTree_Live"."BetterSiteTitle" END AS "BetterSiteTitle", CASE WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."Keyword" ELSE "SiteTree_Live"."Keyword" END AS "Keyword", CASE WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."FeaturedKeyword" ELSE "SiteTree_Live"."FeaturedKeyword" END AS "FeaturedKeyword", CASE WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."KeywordQuestion" ELSE "SiteTree_Live"."KeywordQuestion" END AS "KeywordQuestion", "SiteTree_Live"."Follow", "SiteTree_Live"."FollowType", CASE WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."GenMetaDesc" ELSE "SiteTree_Live"."GenMetaDesc" END AS "GenMetaDesc", CASE WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."FBTitle" ELSE "SiteTree_Live"."FBTitle" END AS "FBTitle", CASE WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."FBDescription" ELSE "SiteTree_Live"."FBDescription" END AS "FBDescription", "SiteTree_Live"."FBType", "SiteTree_Live"."FBTypeOverride", CASE WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."TwTitle" ELSE "SiteTree_Live"."TwTitle" END AS "TwTitle", CASE WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."TwDescription" ELSE "SiteTree_Live"."TwDescription" END AS "TwDescription", "SiteTree_Live"."CanViewType", "SiteTree_Live"."CanEditType", "SiteTree_Live"."Version", CASE WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."URLSegment" ELSE "SiteTree_Live"."URLSegment" END AS "URLSegment", CASE WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."Title" ELSE "SiteTree_Live"."Title" END AS "Title", CASE WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."MenuTitle" ELSE "SiteTree_Live"."MenuTitle" END AS "MenuTitle", CASE WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."Content" ELSE "SiteTree_Live"."Content" END AS "Content", CASE WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."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_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."ReportClass" ELSE "SiteTree_Live"."ReportClass" END AS "ReportClass", "SiteTree_Live"."CanonicalLinkID", "SiteTree_Live"."FBImageID", "SiteTree_Live"."TwImageID", "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_GB' AS "Locale", CASE WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN 'en_GB' ELSE NULL END AS "SourceLocale" FROM "SiteTree_Live" LEFT JOIN "SiteTree_Localised_Live" AS "SiteTree_Localised_en_GB" ON "SiteTree_Live"."ID" = "SiteTree_Localised_en_GB"."RecordID" AND "SiteTree_Localised_en_GB"."Locale" = ? WHERE ("SiteTree_Live"."ID" = ?) AND (("SiteTree_Localised_en_GB"."ID" IS NOT NULL)) ORDER BY "SiteTree_Live"."Sort" ASC LIMIT 1 0.0001s

0022: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", CASE WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."BetterSiteTitle" ELSE "SiteTree_Live"."BetterSiteTitle" END AS "BetterSiteTitle", CASE WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."Keyword" ELSE "SiteTree_Live"."Keyword" END AS "Keyword", CASE WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."FeaturedKeyword" ELSE "SiteTree_Live"."FeaturedKeyword" END AS "FeaturedKeyword", CASE WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."KeywordQuestion" ELSE "SiteTree_Live"."KeywordQuestion" END AS "KeywordQuestion", "SiteTree_Live"."Follow", "SiteTree_Live"."FollowType", CASE WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."GenMetaDesc" ELSE "SiteTree_Live"."GenMetaDesc" END AS "GenMetaDesc", CASE WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."FBTitle" ELSE "SiteTree_Live"."FBTitle" END AS "FBTitle", CASE WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."FBDescription" ELSE "SiteTree_Live"."FBDescription" END AS "FBDescription", "SiteTree_Live"."FBType", "SiteTree_Live"."FBTypeOverride", CASE WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."TwTitle" ELSE "SiteTree_Live"."TwTitle" END AS "TwTitle", CASE WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."TwDescription" ELSE "SiteTree_Live"."TwDescription" END AS "TwDescription", "SiteTree_Live"."CanViewType", "SiteTree_Live"."CanEditType", "SiteTree_Live"."Version", CASE WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."URLSegment" ELSE "SiteTree_Live"."URLSegment" END AS "URLSegment", CASE WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."Title" ELSE "SiteTree_Live"."Title" END AS "Title", CASE WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."MenuTitle" ELSE "SiteTree_Live"."MenuTitle" END AS "MenuTitle", CASE WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."Content" ELSE "SiteTree_Live"."Content" END AS "Content", CASE WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."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_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."ReportClass" ELSE "SiteTree_Live"."ReportClass" END AS "ReportClass", "SiteTree_Live"."CanonicalLinkID", "SiteTree_Live"."FBImageID", "SiteTree_Live"."TwImageID", "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_GB' AS "Locale", CASE WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN 'en_GB' ELSE NULL END AS "SourceLocale" FROM "SiteTree_Live" LEFT JOIN "SiteTree_Localised_Live" AS "SiteTree_Localised_en_GB" ON "SiteTree_Live"."ID" = "SiteTree_Localised_en_GB"."RecordID" AND "SiteTree_Localised_en_GB"."Locale" = ? WHERE ("SiteTree_Live"."ID" = ?) AND (("SiteTree_Localised_en_GB"."ID" IS NOT NULL)) ORDER BY "SiteTree_Live"."Sort" ASC LIMIT 1 0.0001s

0023: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", CASE WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."BetterSiteTitle" ELSE "SiteTree_Live"."BetterSiteTitle" END AS "BetterSiteTitle", CASE WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."Keyword" ELSE "SiteTree_Live"."Keyword" END AS "Keyword", CASE WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."FeaturedKeyword" ELSE "SiteTree_Live"."FeaturedKeyword" END AS "FeaturedKeyword", CASE WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."KeywordQuestion" ELSE "SiteTree_Live"."KeywordQuestion" END AS "KeywordQuestion", "SiteTree_Live"."Follow", "SiteTree_Live"."FollowType", CASE WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."GenMetaDesc" ELSE "SiteTree_Live"."GenMetaDesc" END AS "GenMetaDesc", CASE WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."FBTitle" ELSE "SiteTree_Live"."FBTitle" END AS "FBTitle", CASE WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."FBDescription" ELSE "SiteTree_Live"."FBDescription" END AS "FBDescription", "SiteTree_Live"."FBType", "SiteTree_Live"."FBTypeOverride", CASE WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."TwTitle" ELSE "SiteTree_Live"."TwTitle" END AS "TwTitle", CASE WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."TwDescription" ELSE "SiteTree_Live"."TwDescription" END AS "TwDescription", "SiteTree_Live"."CanViewType", "SiteTree_Live"."CanEditType", "SiteTree_Live"."Version", CASE WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."URLSegment" ELSE "SiteTree_Live"."URLSegment" END AS "URLSegment", CASE WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."Title" ELSE "SiteTree_Live"."Title" END AS "Title", CASE WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."MenuTitle" ELSE "SiteTree_Live"."MenuTitle" END AS "MenuTitle", CASE WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."Content" ELSE "SiteTree_Live"."Content" END AS "Content", CASE WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."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_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."ReportClass" ELSE "SiteTree_Live"."ReportClass" END AS "ReportClass", "SiteTree_Live"."CanonicalLinkID", "SiteTree_Live"."FBImageID", "SiteTree_Live"."TwImageID", "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_GB' AS "Locale", CASE WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN 'en_GB' ELSE NULL END AS "SourceLocale" FROM "SiteTree_Live" LEFT JOIN "SiteTree_Localised_Live" AS "SiteTree_Localised_en_GB" ON "SiteTree_Live"."ID" = "SiteTree_Localised_en_GB"."RecordID" AND "SiteTree_Localised_en_GB"."Locale" = ? WHERE ("SiteTree_Live"."ID" = ?) AND (("SiteTree_Localised_en_GB"."ID" IS NOT NULL)) ORDER BY "SiteTree_Live"."Sort" ASC LIMIT 1 0.0001s

0024: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", CASE WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."BetterSiteTitle" ELSE "SiteTree_Live"."BetterSiteTitle" END AS "BetterSiteTitle", CASE WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."Keyword" ELSE "SiteTree_Live"."Keyword" END AS "Keyword", CASE WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."FeaturedKeyword" ELSE "SiteTree_Live"."FeaturedKeyword" END AS "FeaturedKeyword", CASE WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."KeywordQuestion" ELSE "SiteTree_Live"."KeywordQuestion" END AS "KeywordQuestion", "SiteTree_Live"."Follow", "SiteTree_Live"."FollowType", CASE WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."GenMetaDesc" ELSE "SiteTree_Live"."GenMetaDesc" END AS "GenMetaDesc", CASE WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."FBTitle" ELSE "SiteTree_Live"."FBTitle" END AS "FBTitle", CASE WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."FBDescription" ELSE "SiteTree_Live"."FBDescription" END AS "FBDescription", "SiteTree_Live"."FBType", "SiteTree_Live"."FBTypeOverride", CASE WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."TwTitle" ELSE "SiteTree_Live"."TwTitle" END AS "TwTitle", CASE WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."TwDescription" ELSE "SiteTree_Live"."TwDescription" END AS "TwDescription", "SiteTree_Live"."CanViewType", "SiteTree_Live"."CanEditType", "SiteTree_Live"."Version", CASE WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."URLSegment" ELSE "SiteTree_Live"."URLSegment" END AS "URLSegment", CASE WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."Title" ELSE "SiteTree_Live"."Title" END AS "Title", CASE WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."MenuTitle" ELSE "SiteTree_Live"."MenuTitle" END AS "MenuTitle", CASE WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."Content" ELSE "SiteTree_Live"."Content" END AS "Content", CASE WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."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_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."ReportClass" ELSE "SiteTree_Live"."ReportClass" END AS "ReportClass", "SiteTree_Live"."CanonicalLinkID", "SiteTree_Live"."FBImageID", "SiteTree_Live"."TwImageID", "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_GB' AS "Locale", CASE WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN 'en_GB' ELSE NULL END AS "SourceLocale" FROM "SiteTree_Live" LEFT JOIN "SiteTree_Localised_Live" AS "SiteTree_Localised_en_GB" ON "SiteTree_Live"."ID" = "SiteTree_Localised_en_GB"."RecordID" AND "SiteTree_Localised_en_GB"."Locale" = ? WHERE ("SiteTree_Live"."ID" = ?) AND (("SiteTree_Localised_en_GB"."ID" IS NOT NULL)) ORDER BY "SiteTree_Live"."Sort" ASC LIMIT 1 0.0001s

0025: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", CASE WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."BetterSiteTitle" ELSE "SiteTree_Live"."BetterSiteTitle" END AS "BetterSiteTitle", CASE WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."Keyword" ELSE "SiteTree_Live"."Keyword" END AS "Keyword", CASE WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."FeaturedKeyword" ELSE "SiteTree_Live"."FeaturedKeyword" END AS "FeaturedKeyword", CASE WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."KeywordQuestion" ELSE "SiteTree_Live"."KeywordQuestion" END AS "KeywordQuestion", "SiteTree_Live"."Follow", "SiteTree_Live"."FollowType", CASE WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."GenMetaDesc" ELSE "SiteTree_Live"."GenMetaDesc" END AS "GenMetaDesc", CASE WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."FBTitle" ELSE "SiteTree_Live"."FBTitle" END AS "FBTitle", CASE WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."FBDescription" ELSE "SiteTree_Live"."FBDescription" END AS "FBDescription", "SiteTree_Live"."FBType", "SiteTree_Live"."FBTypeOverride", CASE WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."TwTitle" ELSE "SiteTree_Live"."TwTitle" END AS "TwTitle", CASE WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."TwDescription" ELSE "SiteTree_Live"."TwDescription" END AS "TwDescription", "SiteTree_Live"."CanViewType", "SiteTree_Live"."CanEditType", "SiteTree_Live"."Version", CASE WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."URLSegment" ELSE "SiteTree_Live"."URLSegment" END AS "URLSegment", CASE WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."Title" ELSE "SiteTree_Live"."Title" END AS "Title", CASE WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."MenuTitle" ELSE "SiteTree_Live"."MenuTitle" END AS "MenuTitle", CASE WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."Content" ELSE "SiteTree_Live"."Content" END AS "Content", CASE WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."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_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."ReportClass" ELSE "SiteTree_Live"."ReportClass" END AS "ReportClass", "SiteTree_Live"."CanonicalLinkID", "SiteTree_Live"."FBImageID", "SiteTree_Live"."TwImageID", "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_GB' AS "Locale", CASE WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN 'en_GB' ELSE NULL END AS "SourceLocale" FROM "SiteTree_Live" LEFT JOIN "SiteTree_Localised_Live" AS "SiteTree_Localised_en_GB" ON "SiteTree_Live"."ID" = "SiteTree_Localised_en_GB"."RecordID" AND "SiteTree_Localised_en_GB"."Locale" = ? WHERE ("SiteTree_Live"."ID" = ?) AND (("SiteTree_Localised_en_GB"."ID" IS NOT NULL)) ORDER BY "SiteTree_Live"."Sort" ASC LIMIT 1 0.0001s

0026: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", CASE WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."BetterSiteTitle" ELSE "SiteTree_Live"."BetterSiteTitle" END AS "BetterSiteTitle", CASE WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."Keyword" ELSE "SiteTree_Live"."Keyword" END AS "Keyword", CASE WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."FeaturedKeyword" ELSE "SiteTree_Live"."FeaturedKeyword" END AS "FeaturedKeyword", CASE WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."KeywordQuestion" ELSE "SiteTree_Live"."KeywordQuestion" END AS "KeywordQuestion", "SiteTree_Live"."Follow", "SiteTree_Live"."FollowType", CASE WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."GenMetaDesc" ELSE "SiteTree_Live"."GenMetaDesc" END AS "GenMetaDesc", CASE WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."FBTitle" ELSE "SiteTree_Live"."FBTitle" END AS "FBTitle", CASE WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."FBDescription" ELSE "SiteTree_Live"."FBDescription" END AS "FBDescription", "SiteTree_Live"."FBType", "SiteTree_Live"."FBTypeOverride", CASE WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."TwTitle" ELSE "SiteTree_Live"."TwTitle" END AS "TwTitle", CASE WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."TwDescription" ELSE "SiteTree_Live"."TwDescription" END AS "TwDescription", "SiteTree_Live"."CanViewType", "SiteTree_Live"."CanEditType", "SiteTree_Live"."Version", CASE WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."URLSegment" ELSE "SiteTree_Live"."URLSegment" END AS "URLSegment", CASE WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."Title" ELSE "SiteTree_Live"."Title" END AS "Title", CASE WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."MenuTitle" ELSE "SiteTree_Live"."MenuTitle" END AS "MenuTitle", CASE WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."Content" ELSE "SiteTree_Live"."Content" END AS "Content", CASE WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."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_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."ReportClass" ELSE "SiteTree_Live"."ReportClass" END AS "ReportClass", "SiteTree_Live"."CanonicalLinkID", "SiteTree_Live"."FBImageID", "SiteTree_Live"."TwImageID", "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_GB' AS "Locale", CASE WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN 'en_GB' ELSE NULL END AS "SourceLocale" FROM "SiteTree_Live" LEFT JOIN "SiteTree_Localised_Live" AS "SiteTree_Localised_en_GB" ON "SiteTree_Live"."ID" = "SiteTree_Localised_en_GB"."RecordID" AND "SiteTree_Localised_en_GB"."Locale" = ? WHERE ("SiteTree_Live"."ID" = ?) AND (("SiteTree_Localised_en_GB"."ID" IS NOT NULL)) ORDER BY "SiteTree_Live"."Sort" ASC LIMIT 1 0.0001s

0027: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", CASE WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."BetterSiteTitle" ELSE "SiteTree_Live"."BetterSiteTitle" END AS "BetterSiteTitle", CASE WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."Keyword" ELSE "SiteTree_Live"."Keyword" END AS "Keyword", CASE WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."FeaturedKeyword" ELSE "SiteTree_Live"."FeaturedKeyword" END AS "FeaturedKeyword", CASE WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."KeywordQuestion" ELSE "SiteTree_Live"."KeywordQuestion" END AS "KeywordQuestion", "SiteTree_Live"."Follow", "SiteTree_Live"."FollowType", CASE WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."GenMetaDesc" ELSE "SiteTree_Live"."GenMetaDesc" END AS "GenMetaDesc", CASE WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."FBTitle" ELSE "SiteTree_Live"."FBTitle" END AS "FBTitle", CASE WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."FBDescription" ELSE "SiteTree_Live"."FBDescription" END AS "FBDescription", "SiteTree_Live"."FBType", "SiteTree_Live"."FBTypeOverride", CASE WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."TwTitle" ELSE "SiteTree_Live"."TwTitle" END AS "TwTitle", CASE WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."TwDescription" ELSE "SiteTree_Live"."TwDescription" END AS "TwDescription", "SiteTree_Live"."CanViewType", "SiteTree_Live"."CanEditType", "SiteTree_Live"."Version", CASE WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."URLSegment" ELSE "SiteTree_Live"."URLSegment" END AS "URLSegment", CASE WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."Title" ELSE "SiteTree_Live"."Title" END AS "Title", CASE WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."MenuTitle" ELSE "SiteTree_Live"."MenuTitle" END AS "MenuTitle", CASE WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."Content" ELSE "SiteTree_Live"."Content" END AS "Content", CASE WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."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_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."ReportClass" ELSE "SiteTree_Live"."ReportClass" END AS "ReportClass", "SiteTree_Live"."CanonicalLinkID", "SiteTree_Live"."FBImageID", "SiteTree_Live"."TwImageID", "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_GB' AS "Locale", CASE WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN 'en_GB' ELSE NULL END AS "SourceLocale" FROM "SiteTree_Live" LEFT JOIN "SiteTree_Localised_Live" AS "SiteTree_Localised_en_GB" ON "SiteTree_Live"."ID" = "SiteTree_Localised_en_GB"."RecordID" AND "SiteTree_Localised_en_GB"."Locale" = ? WHERE ("SiteTree_Live"."ID" = ?) AND (("SiteTree_Localised_en_GB"."ID" IS NOT NULL)) ORDER BY "SiteTree_Live"."Sort" ASC LIMIT 1 0.0001s

0028: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", CASE WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."BetterSiteTitle" ELSE "SiteTree_Live"."BetterSiteTitle" END AS "BetterSiteTitle", CASE WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."Keyword" ELSE "SiteTree_Live"."Keyword" END AS "Keyword", CASE WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."FeaturedKeyword" ELSE "SiteTree_Live"."FeaturedKeyword" END AS "FeaturedKeyword", CASE WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."KeywordQuestion" ELSE "SiteTree_Live"."KeywordQuestion" END AS "KeywordQuestion", "SiteTree_Live"."Follow", "SiteTree_Live"."FollowType", CASE WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."GenMetaDesc" ELSE "SiteTree_Live"."GenMetaDesc" END AS "GenMetaDesc", CASE WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."FBTitle" ELSE "SiteTree_Live"."FBTitle" END AS "FBTitle", CASE WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."FBDescription" ELSE "SiteTree_Live"."FBDescription" END AS "FBDescription", "SiteTree_Live"."FBType", "SiteTree_Live"."FBTypeOverride", CASE WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."TwTitle" ELSE "SiteTree_Live"."TwTitle" END AS "TwTitle", CASE WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."TwDescription" ELSE "SiteTree_Live"."TwDescription" END AS "TwDescription", "SiteTree_Live"."CanViewType", "SiteTree_Live"."CanEditType", "SiteTree_Live"."Version", CASE WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."URLSegment" ELSE "SiteTree_Live"."URLSegment" END AS "URLSegment", CASE WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."Title" ELSE "SiteTree_Live"."Title" END AS "Title", CASE WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."MenuTitle" ELSE "SiteTree_Live"."MenuTitle" END AS "MenuTitle", CASE WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."Content" ELSE "SiteTree_Live"."Content" END AS "Content", CASE WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."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_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."ReportClass" ELSE "SiteTree_Live"."ReportClass" END AS "ReportClass", "SiteTree_Live"."CanonicalLinkID", "SiteTree_Live"."FBImageID", "SiteTree_Live"."TwImageID", "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_GB' AS "Locale", CASE WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN 'en_GB' ELSE NULL END AS "SourceLocale" FROM "SiteTree_Live" LEFT JOIN "SiteTree_Localised_Live" AS "SiteTree_Localised_en_GB" ON "SiteTree_Live"."ID" = "SiteTree_Localised_en_GB"."RecordID" AND "SiteTree_Localised_en_GB"."Locale" = ? WHERE ("SiteTree_Live"."ID" = ?) AND (("SiteTree_Localised_en_GB"."ID" IS NOT NULL)) ORDER BY "SiteTree_Live"."Sort" ASC LIMIT 1 0.0001s

0029: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", CASE WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."BetterSiteTitle" ELSE "SiteTree_Live"."BetterSiteTitle" END AS "BetterSiteTitle", CASE WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."Keyword" ELSE "SiteTree_Live"."Keyword" END AS "Keyword", CASE WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."FeaturedKeyword" ELSE "SiteTree_Live"."FeaturedKeyword" END AS "FeaturedKeyword", CASE WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."KeywordQuestion" ELSE "SiteTree_Live"."KeywordQuestion" END AS "KeywordQuestion", "SiteTree_Live"."Follow", "SiteTree_Live"."FollowType", CASE WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."GenMetaDesc" ELSE "SiteTree_Live"."GenMetaDesc" END AS "GenMetaDesc", CASE WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."FBTitle" ELSE "SiteTree_Live"."FBTitle" END AS "FBTitle", CASE WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."FBDescription" ELSE "SiteTree_Live"."FBDescription" END AS "FBDescription", "SiteTree_Live"."FBType", "SiteTree_Live"."FBTypeOverride", CASE WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."TwTitle" ELSE "SiteTree_Live"."TwTitle" END AS "TwTitle", CASE WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."TwDescription" ELSE "SiteTree_Live"."TwDescription" END AS "TwDescription", "SiteTree_Live"."CanViewType", "SiteTree_Live"."CanEditType", "SiteTree_Live"."Version", CASE WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."URLSegment" ELSE "SiteTree_Live"."URLSegment" END AS "URLSegment", CASE WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."Title" ELSE "SiteTree_Live"."Title" END AS "Title", CASE WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."MenuTitle" ELSE "SiteTree_Live"."MenuTitle" END AS "MenuTitle", CASE WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."Content" ELSE "SiteTree_Live"."Content" END AS "Content", CASE WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."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_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."ReportClass" ELSE "SiteTree_Live"."ReportClass" END AS "ReportClass", "SiteTree_Live"."CanonicalLinkID", "SiteTree_Live"."FBImageID", "SiteTree_Live"."TwImageID", "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_GB' AS "Locale", CASE WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN 'en_GB' ELSE NULL END AS "SourceLocale" FROM "SiteTree_Live" LEFT JOIN "SiteTree_Localised_Live" AS "SiteTree_Localised_en_GB" ON "SiteTree_Live"."ID" = "SiteTree_Localised_en_GB"."RecordID" AND "SiteTree_Localised_en_GB"."Locale" = ? WHERE ("SiteTree_Live"."ID" = ?) AND (("SiteTree_Localised_en_GB"."ID" IS NOT NULL)) ORDER BY "SiteTree_Live"."Sort" ASC LIMIT 1 0.0001s

0030: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", CASE WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."BetterSiteTitle" ELSE "SiteTree_Live"."BetterSiteTitle" END AS "BetterSiteTitle", CASE WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."Keyword" ELSE "SiteTree_Live"."Keyword" END AS "Keyword", CASE WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."FeaturedKeyword" ELSE "SiteTree_Live"."FeaturedKeyword" END AS "FeaturedKeyword", CASE WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."KeywordQuestion" ELSE "SiteTree_Live"."KeywordQuestion" END AS "KeywordQuestion", "SiteTree_Live"."Follow", "SiteTree_Live"."FollowType", CASE WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."GenMetaDesc" ELSE "SiteTree_Live"."GenMetaDesc" END AS "GenMetaDesc", CASE WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."FBTitle" ELSE "SiteTree_Live"."FBTitle" END AS "FBTitle", CASE WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."FBDescription" ELSE "SiteTree_Live"."FBDescription" END AS "FBDescription", "SiteTree_Live"."FBType", "SiteTree_Live"."FBTypeOverride", CASE WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."TwTitle" ELSE "SiteTree_Live"."TwTitle" END AS "TwTitle", CASE WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."TwDescription" ELSE "SiteTree_Live"."TwDescription" END AS "TwDescription", "SiteTree_Live"."CanViewType", "SiteTree_Live"."CanEditType", "SiteTree_Live"."Version", CASE WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."URLSegment" ELSE "SiteTree_Live"."URLSegment" END AS "URLSegment", CASE WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."Title" ELSE "SiteTree_Live"."Title" END AS "Title", CASE WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."MenuTitle" ELSE "SiteTree_Live"."MenuTitle" END AS "MenuTitle", CASE WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."Content" ELSE "SiteTree_Live"."Content" END AS "Content", CASE WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."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_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."ReportClass" ELSE "SiteTree_Live"."ReportClass" END AS "ReportClass", "SiteTree_Live"."CanonicalLinkID", "SiteTree_Live"."FBImageID", "SiteTree_Live"."TwImageID", "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_GB' AS "Locale", CASE WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN 'en_GB' ELSE NULL END AS "SourceLocale" FROM "SiteTree_Live" LEFT JOIN "SiteTree_Localised_Live" AS "SiteTree_Localised_en_GB" ON "SiteTree_Live"."ID" = "SiteTree_Localised_en_GB"."RecordID" AND "SiteTree_Localised_en_GB"."Locale" = ? WHERE ("SiteTree_Live"."ID" = ?) AND (("SiteTree_Localised_en_GB"."ID" IS NOT NULL)) ORDER BY "SiteTree_Live"."Sort" ASC LIMIT 1 0.0001s

0031: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", CASE WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."BetterSiteTitle" ELSE "SiteTree_Live"."BetterSiteTitle" END AS "BetterSiteTitle", CASE WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."Keyword" ELSE "SiteTree_Live"."Keyword" END AS "Keyword", CASE WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."FeaturedKeyword" ELSE "SiteTree_Live"."FeaturedKeyword" END AS "FeaturedKeyword", CASE WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."KeywordQuestion" ELSE "SiteTree_Live"."KeywordQuestion" END AS "KeywordQuestion", "SiteTree_Live"."Follow", "SiteTree_Live"."FollowType", CASE WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."GenMetaDesc" ELSE "SiteTree_Live"."GenMetaDesc" END AS "GenMetaDesc", CASE WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."FBTitle" ELSE "SiteTree_Live"."FBTitle" END AS "FBTitle", CASE WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."FBDescription" ELSE "SiteTree_Live"."FBDescription" END AS "FBDescription", "SiteTree_Live"."FBType", "SiteTree_Live"."FBTypeOverride", CASE WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."TwTitle" ELSE "SiteTree_Live"."TwTitle" END AS "TwTitle", CASE WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."TwDescription" ELSE "SiteTree_Live"."TwDescription" END AS "TwDescription", "SiteTree_Live"."CanViewType", "SiteTree_Live"."CanEditType", "SiteTree_Live"."Version", CASE WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."URLSegment" ELSE "SiteTree_Live"."URLSegment" END AS "URLSegment", CASE WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."Title" ELSE "SiteTree_Live"."Title" END AS "Title", CASE WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."MenuTitle" ELSE "SiteTree_Live"."MenuTitle" END AS "MenuTitle", CASE WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."Content" ELSE "SiteTree_Live"."Content" END AS "Content", CASE WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."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_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."ReportClass" ELSE "SiteTree_Live"."ReportClass" END AS "ReportClass", "SiteTree_Live"."CanonicalLinkID", "SiteTree_Live"."FBImageID", "SiteTree_Live"."TwImageID", "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_GB' AS "Locale", CASE WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN 'en_GB' ELSE NULL END AS "SourceLocale" FROM "SiteTree_Live" LEFT JOIN "SiteTree_Localised_Live" AS "SiteTree_Localised_en_GB" ON "SiteTree_Live"."ID" = "SiteTree_Localised_en_GB"."RecordID" AND "SiteTree_Localised_en_GB"."Locale" = ? WHERE ("SiteTree_Live"."ID" = ?) AND (("SiteTree_Localised_en_GB"."ID" IS NOT NULL)) ORDER BY "SiteTree_Live"."Sort" ASC LIMIT 1 0.0001s

0032: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", CASE WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."BetterSiteTitle" ELSE "SiteTree_Live"."BetterSiteTitle" END AS "BetterSiteTitle", CASE WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."Keyword" ELSE "SiteTree_Live"."Keyword" END AS "Keyword", CASE WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."FeaturedKeyword" ELSE "SiteTree_Live"."FeaturedKeyword" END AS "FeaturedKeyword", CASE WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."KeywordQuestion" ELSE "SiteTree_Live"."KeywordQuestion" END AS "KeywordQuestion", "SiteTree_Live"."Follow", "SiteTree_Live"."FollowType", CASE WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."GenMetaDesc" ELSE "SiteTree_Live"."GenMetaDesc" END AS "GenMetaDesc", CASE WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."FBTitle" ELSE "SiteTree_Live"."FBTitle" END AS "FBTitle", CASE WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."FBDescription" ELSE "SiteTree_Live"."FBDescription" END AS "FBDescription", "SiteTree_Live"."FBType", "SiteTree_Live"."FBTypeOverride", CASE WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."TwTitle" ELSE "SiteTree_Live"."TwTitle" END AS "TwTitle", CASE WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."TwDescription" ELSE "SiteTree_Live"."TwDescription" END AS "TwDescription", "SiteTree_Live"."CanViewType", "SiteTree_Live"."CanEditType", "SiteTree_Live"."Version", CASE WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."URLSegment" ELSE "SiteTree_Live"."URLSegment" END AS "URLSegment", CASE WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."Title" ELSE "SiteTree_Live"."Title" END AS "Title", CASE WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."MenuTitle" ELSE "SiteTree_Live"."MenuTitle" END AS "MenuTitle", CASE WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."Content" ELSE "SiteTree_Live"."Content" END AS "Content", CASE WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."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_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."ReportClass" ELSE "SiteTree_Live"."ReportClass" END AS "ReportClass", "SiteTree_Live"."CanonicalLinkID", "SiteTree_Live"."FBImageID", "SiteTree_Live"."TwImageID", "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_GB' AS "Locale", CASE WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN 'en_GB' ELSE NULL END AS "SourceLocale" FROM "SiteTree_Live" LEFT JOIN "SiteTree_Localised_Live" AS "SiteTree_Localised_en_GB" ON "SiteTree_Live"."ID" = "SiteTree_Localised_en_GB"."RecordID" AND "SiteTree_Localised_en_GB"."Locale" = ? WHERE ("SiteTree_Live"."ID" = ?) AND (("SiteTree_Localised_en_GB"."ID" IS NOT NULL)) ORDER BY "SiteTree_Live"."Sort" ASC LIMIT 1 0.0001s

0033: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", CASE WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."BetterSiteTitle" ELSE "SiteTree_Live"."BetterSiteTitle" END AS "BetterSiteTitle", CASE WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."Keyword" ELSE "SiteTree_Live"."Keyword" END AS "Keyword", CASE WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."FeaturedKeyword" ELSE "SiteTree_Live"."FeaturedKeyword" END AS "FeaturedKeyword", CASE WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."KeywordQuestion" ELSE "SiteTree_Live"."KeywordQuestion" END AS "KeywordQuestion", "SiteTree_Live"."Follow", "SiteTree_Live"."FollowType", CASE WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."GenMetaDesc" ELSE "SiteTree_Live"."GenMetaDesc" END AS "GenMetaDesc", CASE WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."FBTitle" ELSE "SiteTree_Live"."FBTitle" END AS "FBTitle", CASE WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."FBDescription" ELSE "SiteTree_Live"."FBDescription" END AS "FBDescription", "SiteTree_Live"."FBType", "SiteTree_Live"."FBTypeOverride", CASE WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."TwTitle" ELSE "SiteTree_Live"."TwTitle" END AS "TwTitle", CASE WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."TwDescription" ELSE "SiteTree_Live"."TwDescription" END AS "TwDescription", "SiteTree_Live"."CanViewType", "SiteTree_Live"."CanEditType", "SiteTree_Live"."Version", CASE WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."URLSegment" ELSE "SiteTree_Live"."URLSegment" END AS "URLSegment", CASE WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."Title" ELSE "SiteTree_Live"."Title" END AS "Title", CASE WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."MenuTitle" ELSE "SiteTree_Live"."MenuTitle" END AS "MenuTitle", CASE WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."Content" ELSE "SiteTree_Live"."Content" END AS "Content", CASE WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."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_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."ReportClass" ELSE "SiteTree_Live"."ReportClass" END AS "ReportClass", "SiteTree_Live"."CanonicalLinkID", "SiteTree_Live"."FBImageID", "SiteTree_Live"."TwImageID", "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_GB' AS "Locale", CASE WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN 'en_GB' ELSE NULL END AS "SourceLocale" FROM "SiteTree_Live" LEFT JOIN "SiteTree_Localised_Live" AS "SiteTree_Localised_en_GB" ON "SiteTree_Live"."ID" = "SiteTree_Localised_en_GB"."RecordID" AND "SiteTree_Localised_en_GB"."Locale" = ? WHERE ("SiteTree_Live"."ID" = ?) AND (("SiteTree_Localised_en_GB"."ID" IS NOT NULL)) ORDER BY "SiteTree_Live"."Sort" ASC LIMIT 1 0.0001s

0034: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", CASE WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."BetterSiteTitle" ELSE "SiteTree_Live"."BetterSiteTitle" END AS "BetterSiteTitle", CASE WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."Keyword" ELSE "SiteTree_Live"."Keyword" END AS "Keyword", CASE WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."FeaturedKeyword" ELSE "SiteTree_Live"."FeaturedKeyword" END AS "FeaturedKeyword", CASE WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."KeywordQuestion" ELSE "SiteTree_Live"."KeywordQuestion" END AS "KeywordQuestion", "SiteTree_Live"."Follow", "SiteTree_Live"."FollowType", CASE WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."GenMetaDesc" ELSE "SiteTree_Live"."GenMetaDesc" END AS "GenMetaDesc", CASE WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."FBTitle" ELSE "SiteTree_Live"."FBTitle" END AS "FBTitle", CASE WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."FBDescription" ELSE "SiteTree_Live"."FBDescription" END AS "FBDescription", "SiteTree_Live"."FBType", "SiteTree_Live"."FBTypeOverride", CASE WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."TwTitle" ELSE "SiteTree_Live"."TwTitle" END AS "TwTitle", CASE WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."TwDescription" ELSE "SiteTree_Live"."TwDescription" END AS "TwDescription", "SiteTree_Live"."CanViewType", "SiteTree_Live"."CanEditType", "SiteTree_Live"."Version", CASE WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."URLSegment" ELSE "SiteTree_Live"."URLSegment" END AS "URLSegment", CASE WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."Title" ELSE "SiteTree_Live"."Title" END AS "Title", CASE WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."MenuTitle" ELSE "SiteTree_Live"."MenuTitle" END AS "MenuTitle", CASE WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."Content" ELSE "SiteTree_Live"."Content" END AS "Content", CASE WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."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_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."ReportClass" ELSE "SiteTree_Live"."ReportClass" END AS "ReportClass", "SiteTree_Live"."CanonicalLinkID", "SiteTree_Live"."FBImageID", "SiteTree_Live"."TwImageID", "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_GB' AS "Locale", CASE WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN 'en_GB' ELSE NULL END AS "SourceLocale" FROM "SiteTree_Live" LEFT JOIN "SiteTree_Localised_Live" AS "SiteTree_Localised_en_GB" ON "SiteTree_Live"."ID" = "SiteTree_Localised_en_GB"."RecordID" AND "SiteTree_Localised_en_GB"."Locale" = ? WHERE ("SiteTree_Live"."ID" = ?) AND (("SiteTree_Localised_en_GB"."ID" IS NOT NULL)) ORDER BY "SiteTree_Live"."Sort" ASC LIMIT 1 0.0001s

0035: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", CASE WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."BetterSiteTitle" ELSE "SiteTree_Live"."BetterSiteTitle" END AS "BetterSiteTitle", CASE WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."Keyword" ELSE "SiteTree_Live"."Keyword" END AS "Keyword", CASE WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."FeaturedKeyword" ELSE "SiteTree_Live"."FeaturedKeyword" END AS "FeaturedKeyword", CASE WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."KeywordQuestion" ELSE "SiteTree_Live"."KeywordQuestion" END AS "KeywordQuestion", "SiteTree_Live"."Follow", "SiteTree_Live"."FollowType", CASE WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."GenMetaDesc" ELSE "SiteTree_Live"."GenMetaDesc" END AS "GenMetaDesc", CASE WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."FBTitle" ELSE "SiteTree_Live"."FBTitle" END AS "FBTitle", CASE WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."FBDescription" ELSE "SiteTree_Live"."FBDescription" END AS "FBDescription", "SiteTree_Live"."FBType", "SiteTree_Live"."FBTypeOverride", CASE WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."TwTitle" ELSE "SiteTree_Live"."TwTitle" END AS "TwTitle", CASE WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."TwDescription" ELSE "SiteTree_Live"."TwDescription" END AS "TwDescription", "SiteTree_Live"."CanViewType", "SiteTree_Live"."CanEditType", "SiteTree_Live"."Version", CASE WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."URLSegment" ELSE "SiteTree_Live"."URLSegment" END AS "URLSegment", CASE WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."Title" ELSE "SiteTree_Live"."Title" END AS "Title", CASE WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."MenuTitle" ELSE "SiteTree_Live"."MenuTitle" END AS "MenuTitle", CASE WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."Content" ELSE "SiteTree_Live"."Content" END AS "Content", CASE WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."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_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."ReportClass" ELSE "SiteTree_Live"."ReportClass" END AS "ReportClass", "SiteTree_Live"."CanonicalLinkID", "SiteTree_Live"."FBImageID", "SiteTree_Live"."TwImageID", "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_GB' AS "Locale", CASE WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN 'en_GB' ELSE NULL END AS "SourceLocale" FROM "SiteTree_Live" LEFT JOIN "SiteTree_Localised_Live" AS "SiteTree_Localised_en_GB" ON "SiteTree_Live"."ID" = "SiteTree_Localised_en_GB"."RecordID" AND "SiteTree_Localised_en_GB"."Locale" = ? WHERE ("SiteTree_Live"."ID" = ?) AND (("SiteTree_Localised_en_GB"."ID" IS NOT NULL)) ORDER BY "SiteTree_Live"."Sort" ASC LIMIT 1 0.0001s

0036: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", CASE WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."BetterSiteTitle" ELSE "SiteTree_Live"."BetterSiteTitle" END AS "BetterSiteTitle", CASE WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."Keyword" ELSE "SiteTree_Live"."Keyword" END AS "Keyword", CASE WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."FeaturedKeyword" ELSE "SiteTree_Live"."FeaturedKeyword" END AS "FeaturedKeyword", CASE WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."KeywordQuestion" ELSE "SiteTree_Live"."KeywordQuestion" END AS "KeywordQuestion", "SiteTree_Live"."Follow", "SiteTree_Live"."FollowType", CASE WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."GenMetaDesc" ELSE "SiteTree_Live"."GenMetaDesc" END AS "GenMetaDesc", CASE WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."FBTitle" ELSE "SiteTree_Live"."FBTitle" END AS "FBTitle", CASE WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."FBDescription" ELSE "SiteTree_Live"."FBDescription" END AS "FBDescription", "SiteTree_Live"."FBType", "SiteTree_Live"."FBTypeOverride", CASE WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."TwTitle" ELSE "SiteTree_Live"."TwTitle" END AS "TwTitle", CASE WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."TwDescription" ELSE "SiteTree_Live"."TwDescription" END AS "TwDescription", "SiteTree_Live"."CanViewType", "SiteTree_Live"."CanEditType", "SiteTree_Live"."Version", CASE WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."URLSegment" ELSE "SiteTree_Live"."URLSegment" END AS "URLSegment", CASE WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."Title" ELSE "SiteTree_Live"."Title" END AS "Title", CASE WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."MenuTitle" ELSE "SiteTree_Live"."MenuTitle" END AS "MenuTitle", CASE WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."Content" ELSE "SiteTree_Live"."Content" END AS "Content", CASE WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."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_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."ReportClass" ELSE "SiteTree_Live"."ReportClass" END AS "ReportClass", "SiteTree_Live"."CanonicalLinkID", "SiteTree_Live"."FBImageID", "SiteTree_Live"."TwImageID", "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_GB' AS "Locale", CASE WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN 'en_GB' ELSE NULL END AS "SourceLocale" FROM "SiteTree_Live" LEFT JOIN "SiteTree_Localised_Live" AS "SiteTree_Localised_en_GB" ON "SiteTree_Live"."ID" = "SiteTree_Localised_en_GB"."RecordID" AND "SiteTree_Localised_en_GB"."Locale" = ? WHERE ("SiteTree_Live"."ID" = ?) AND (("SiteTree_Localised_en_GB"."ID" IS NOT NULL)) ORDER BY "SiteTree_Live"."Sort" ASC LIMIT 1 0.0001s

0037: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", CASE WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."BetterSiteTitle" ELSE "SiteTree_Live"."BetterSiteTitle" END AS "BetterSiteTitle", CASE WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."Keyword" ELSE "SiteTree_Live"."Keyword" END AS "Keyword", CASE WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."FeaturedKeyword" ELSE "SiteTree_Live"."FeaturedKeyword" END AS "FeaturedKeyword", CASE WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."KeywordQuestion" ELSE "SiteTree_Live"."KeywordQuestion" END AS "KeywordQuestion", "SiteTree_Live"."Follow", "SiteTree_Live"."FollowType", CASE WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."GenMetaDesc" ELSE "SiteTree_Live"."GenMetaDesc" END AS "GenMetaDesc", CASE WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."FBTitle" ELSE "SiteTree_Live"."FBTitle" END AS "FBTitle", CASE WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."FBDescription" ELSE "SiteTree_Live"."FBDescription" END AS "FBDescription", "SiteTree_Live"."FBType", "SiteTree_Live"."FBTypeOverride", CASE WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."TwTitle" ELSE "SiteTree_Live"."TwTitle" END AS "TwTitle", CASE WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."TwDescription" ELSE "SiteTree_Live"."TwDescription" END AS "TwDescription", "SiteTree_Live"."CanViewType", "SiteTree_Live"."CanEditType", "SiteTree_Live"."Version", CASE WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."URLSegment" ELSE "SiteTree_Live"."URLSegment" END AS "URLSegment", CASE WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."Title" ELSE "SiteTree_Live"."Title" END AS "Title", CASE WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."MenuTitle" ELSE "SiteTree_Live"."MenuTitle" END AS "MenuTitle", CASE WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."Content" ELSE "SiteTree_Live"."Content" END AS "Content", CASE WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."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_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."ReportClass" ELSE "SiteTree_Live"."ReportClass" END AS "ReportClass", "SiteTree_Live"."CanonicalLinkID", "SiteTree_Live"."FBImageID", "SiteTree_Live"."TwImageID", "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_GB' AS "Locale", CASE WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN 'en_GB' ELSE NULL END AS "SourceLocale" FROM "SiteTree_Live" LEFT JOIN "SiteTree_Localised_Live" AS "SiteTree_Localised_en_GB" ON "SiteTree_Live"."ID" = "SiteTree_Localised_en_GB"."RecordID" AND "SiteTree_Localised_en_GB"."Locale" = ? WHERE ("SiteTree_Live"."ID" = ?) AND (("SiteTree_Localised_en_GB"."ID" IS NOT NULL)) ORDER BY "SiteTree_Live"."Sort" ASC LIMIT 1 0.0001s

0038: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", CASE WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."BetterSiteTitle" ELSE "SiteTree_Live"."BetterSiteTitle" END AS "BetterSiteTitle", CASE WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."Keyword" ELSE "SiteTree_Live"."Keyword" END AS "Keyword", CASE WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."FeaturedKeyword" ELSE "SiteTree_Live"."FeaturedKeyword" END AS "FeaturedKeyword", CASE WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."KeywordQuestion" ELSE "SiteTree_Live"."KeywordQuestion" END AS "KeywordQuestion", "SiteTree_Live"."Follow", "SiteTree_Live"."FollowType", CASE WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."GenMetaDesc" ELSE "SiteTree_Live"."GenMetaDesc" END AS "GenMetaDesc", CASE WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."FBTitle" ELSE "SiteTree_Live"."FBTitle" END AS "FBTitle", CASE WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."FBDescription" ELSE "SiteTree_Live"."FBDescription" END AS "FBDescription", "SiteTree_Live"."FBType", "SiteTree_Live"."FBTypeOverride", CASE WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."TwTitle" ELSE "SiteTree_Live"."TwTitle" END AS "TwTitle", CASE WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."TwDescription" ELSE "SiteTree_Live"."TwDescription" END AS "TwDescription", "SiteTree_Live"."CanViewType", "SiteTree_Live"."CanEditType", "SiteTree_Live"."Version", CASE WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."URLSegment" ELSE "SiteTree_Live"."URLSegment" END AS "URLSegment", CASE WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."Title" ELSE "SiteTree_Live"."Title" END AS "Title", CASE WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."MenuTitle" ELSE "SiteTree_Live"."MenuTitle" END AS "MenuTitle", CASE WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."Content" ELSE "SiteTree_Live"."Content" END AS "Content", CASE WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."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_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."ReportClass" ELSE "SiteTree_Live"."ReportClass" END AS "ReportClass", "SiteTree_Live"."CanonicalLinkID", "SiteTree_Live"."FBImageID", "SiteTree_Live"."TwImageID", "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_GB' AS "Locale", CASE WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN 'en_GB' ELSE NULL END AS "SourceLocale" FROM "SiteTree_Live" LEFT JOIN "SiteTree_Localised_Live" AS "SiteTree_Localised_en_GB" ON "SiteTree_Live"."ID" = "SiteTree_Localised_en_GB"."RecordID" AND "SiteTree_Localised_en_GB"."Locale" = ? WHERE ("SiteTree_Live"."ID" = ?) AND (("SiteTree_Localised_en_GB"."ID" IS NOT NULL)) ORDER BY "SiteTree_Live"."Sort" ASC LIMIT 1 0.0001s

0039: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", CASE WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."BetterSiteTitle" ELSE "SiteTree_Live"."BetterSiteTitle" END AS "BetterSiteTitle", CASE WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."Keyword" ELSE "SiteTree_Live"."Keyword" END AS "Keyword", CASE WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."FeaturedKeyword" ELSE "SiteTree_Live"."FeaturedKeyword" END AS "FeaturedKeyword", CASE WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."KeywordQuestion" ELSE "SiteTree_Live"."KeywordQuestion" END AS "KeywordQuestion", "SiteTree_Live"."Follow", "SiteTree_Live"."FollowType", CASE WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."GenMetaDesc" ELSE "SiteTree_Live"."GenMetaDesc" END AS "GenMetaDesc", CASE WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."FBTitle" ELSE "SiteTree_Live"."FBTitle" END AS "FBTitle", CASE WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."FBDescription" ELSE "SiteTree_Live"."FBDescription" END AS "FBDescription", "SiteTree_Live"."FBType", "SiteTree_Live"."FBTypeOverride", CASE WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."TwTitle" ELSE "SiteTree_Live"."TwTitle" END AS "TwTitle", CASE WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."TwDescription" ELSE "SiteTree_Live"."TwDescription" END AS "TwDescription", "SiteTree_Live"."CanViewType", "SiteTree_Live"."CanEditType", "SiteTree_Live"."Version", CASE WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."URLSegment" ELSE "SiteTree_Live"."URLSegment" END AS "URLSegment", CASE WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."Title" ELSE "SiteTree_Live"."Title" END AS "Title", CASE WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."MenuTitle" ELSE "SiteTree_Live"."MenuTitle" END AS "MenuTitle", CASE WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."Content" ELSE "SiteTree_Live"."Content" END AS "Content", CASE WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."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_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."ReportClass" ELSE "SiteTree_Live"."ReportClass" END AS "ReportClass", "SiteTree_Live"."CanonicalLinkID", "SiteTree_Live"."FBImageID", "SiteTree_Live"."TwImageID", "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_GB' AS "Locale", CASE WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN 'en_GB' ELSE NULL END AS "SourceLocale" FROM "SiteTree_Live" LEFT JOIN "SiteTree_Localised_Live" AS "SiteTree_Localised_en_GB" ON "SiteTree_Live"."ID" = "SiteTree_Localised_en_GB"."RecordID" AND "SiteTree_Localised_en_GB"."Locale" = ? WHERE ("SiteTree_Live"."ID" = ?) AND (("SiteTree_Localised_en_GB"."ID" IS NOT NULL)) ORDER BY "SiteTree_Live"."Sort" ASC LIMIT 1 0.0001s

0040: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", CASE WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."BetterSiteTitle" ELSE "SiteTree_Live"."BetterSiteTitle" END AS "BetterSiteTitle", CASE WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."Keyword" ELSE "SiteTree_Live"."Keyword" END AS "Keyword", CASE WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."FeaturedKeyword" ELSE "SiteTree_Live"."FeaturedKeyword" END AS "FeaturedKeyword", CASE WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."KeywordQuestion" ELSE "SiteTree_Live"."KeywordQuestion" END AS "KeywordQuestion", "SiteTree_Live"."Follow", "SiteTree_Live"."FollowType", CASE WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."GenMetaDesc" ELSE "SiteTree_Live"."GenMetaDesc" END AS "GenMetaDesc", CASE WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."FBTitle" ELSE "SiteTree_Live"."FBTitle" END AS "FBTitle", CASE WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."FBDescription" ELSE "SiteTree_Live"."FBDescription" END AS "FBDescription", "SiteTree_Live"."FBType", "SiteTree_Live"."FBTypeOverride", CASE WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."TwTitle" ELSE "SiteTree_Live"."TwTitle" END AS "TwTitle", CASE WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."TwDescription" ELSE "SiteTree_Live"."TwDescription" END AS "TwDescription", "SiteTree_Live"."CanViewType", "SiteTree_Live"."CanEditType", "SiteTree_Live"."Version", CASE WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."URLSegment" ELSE "SiteTree_Live"."URLSegment" END AS "URLSegment", CASE WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."Title" ELSE "SiteTree_Live"."Title" END AS "Title", CASE WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."MenuTitle" ELSE "SiteTree_Live"."MenuTitle" END AS "MenuTitle", CASE WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."Content" ELSE "SiteTree_Live"."Content" END AS "Content", CASE WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."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_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."ReportClass" ELSE "SiteTree_Live"."ReportClass" END AS "ReportClass", "SiteTree_Live"."CanonicalLinkID", "SiteTree_Live"."FBImageID", "SiteTree_Live"."TwImageID", "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_GB' AS "Locale", CASE WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN 'en_GB' ELSE NULL END AS "SourceLocale" FROM "SiteTree_Live" LEFT JOIN "SiteTree_Localised_Live" AS "SiteTree_Localised_en_GB" ON "SiteTree_Live"."ID" = "SiteTree_Localised_en_GB"."RecordID" AND "SiteTree_Localised_en_GB"."Locale" = ? WHERE ("SiteTree_Live"."ID" = ?) AND (("SiteTree_Localised_en_GB"."ID" IS NOT NULL)) ORDER BY "SiteTree_Live"."Sort" ASC LIMIT 1 0.0001s

0041: SELECT DISTINCT "MenuSet"."ClassName", "MenuSet"."LastEdited", "MenuSet"."Created", "MenuSet"."Name", "MenuSet"."Description", "MenuSet"."Sort", "MenuSet"."ID", CASE WHEN "MenuSet"."ClassName" IS NOT NULL THEN "MenuSet"."ClassName" ELSE 'Heyday\\MenuManager\\MenuSet' END AS "RecordClassName" FROM "MenuSet" WHERE ("MenuSet"."Name" = ?) ORDER BY "MenuSet"."Sort" ASC LIMIT 1 0.0009s

0042: SELECT DISTINCT "MenuItem"."ClassName", "MenuItem"."LastEdited", "MenuItem"."Created", "MenuItem"."MenuTitle", "MenuItem"."Link", "MenuItem"."Sort", "MenuItem"."IsNewWindow", "MenuItem"."PageID", "MenuItem"."MenuSetID", "MenuItem"."ID", CASE WHEN "MenuItem"."ClassName" IS NOT NULL THEN "MenuItem"."ClassName" ELSE 'Heyday\\MenuManager\\MenuItem' END AS "RecordClassName" FROM "MenuItem" WHERE ("MenuItem"."MenuSetID" = ?) ORDER BY "MenuItem"."Sort" ASC 0.0009s

0043: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", CASE WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."BetterSiteTitle" ELSE "SiteTree_Live"."BetterSiteTitle" END AS "BetterSiteTitle", CASE WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."Keyword" ELSE "SiteTree_Live"."Keyword" END AS "Keyword", CASE WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."FeaturedKeyword" ELSE "SiteTree_Live"."FeaturedKeyword" END AS "FeaturedKeyword", CASE WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."KeywordQuestion" ELSE "SiteTree_Live"."KeywordQuestion" END AS "KeywordQuestion", "SiteTree_Live"."Follow", "SiteTree_Live"."FollowType", CASE WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."GenMetaDesc" ELSE "SiteTree_Live"."GenMetaDesc" END AS "GenMetaDesc", CASE WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."FBTitle" ELSE "SiteTree_Live"."FBTitle" END AS "FBTitle", CASE WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."FBDescription" ELSE "SiteTree_Live"."FBDescription" END AS "FBDescription", "SiteTree_Live"."FBType", "SiteTree_Live"."FBTypeOverride", CASE WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."TwTitle" ELSE "SiteTree_Live"."TwTitle" END AS "TwTitle", CASE WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."TwDescription" ELSE "SiteTree_Live"."TwDescription" END AS "TwDescription", "SiteTree_Live"."CanViewType", "SiteTree_Live"."CanEditType", "SiteTree_Live"."Version", CASE WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."URLSegment" ELSE "SiteTree_Live"."URLSegment" END AS "URLSegment", CASE WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."Title" ELSE "SiteTree_Live"."Title" END AS "Title", CASE WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."MenuTitle" ELSE "SiteTree_Live"."MenuTitle" END AS "MenuTitle", CASE WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."Content" ELSE "SiteTree_Live"."Content" END AS "Content", CASE WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."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_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."ReportClass" ELSE "SiteTree_Live"."ReportClass" END AS "ReportClass", "SiteTree_Live"."CanonicalLinkID", "SiteTree_Live"."FBImageID", "SiteTree_Live"."TwImageID", "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_GB' AS "Locale", CASE WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN 'en_GB' ELSE NULL END AS "SourceLocale" FROM "SiteTree_Live" LEFT JOIN "SiteTree_Localised_Live" AS "SiteTree_Localised_en_GB" ON "SiteTree_Live"."ID" = "SiteTree_Localised_en_GB"."RecordID" AND "SiteTree_Localised_en_GB"."Locale" = ? WHERE ("SiteTree_Live"."ID" = ?) AND (("SiteTree_Localised_en_GB"."ID" IS NOT NULL)) ORDER BY "SiteTree_Live"."Sort" ASC LIMIT 1 0.0001s

0044: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", CASE WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."BetterSiteTitle" ELSE "SiteTree_Live"."BetterSiteTitle" END AS "BetterSiteTitle", CASE WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."Keyword" ELSE "SiteTree_Live"."Keyword" END AS "Keyword", CASE WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."FeaturedKeyword" ELSE "SiteTree_Live"."FeaturedKeyword" END AS "FeaturedKeyword", CASE WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."KeywordQuestion" ELSE "SiteTree_Live"."KeywordQuestion" END AS "KeywordQuestion", "SiteTree_Live"."Follow", "SiteTree_Live"."FollowType", CASE WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."GenMetaDesc" ELSE "SiteTree_Live"."GenMetaDesc" END AS "GenMetaDesc", CASE WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."FBTitle" ELSE "SiteTree_Live"."FBTitle" END AS "FBTitle", CASE WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."FBDescription" ELSE "SiteTree_Live"."FBDescription" END AS "FBDescription", "SiteTree_Live"."FBType", "SiteTree_Live"."FBTypeOverride", CASE WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."TwTitle" ELSE "SiteTree_Live"."TwTitle" END AS "TwTitle", CASE WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."TwDescription" ELSE "SiteTree_Live"."TwDescription" END AS "TwDescription", "SiteTree_Live"."CanViewType", "SiteTree_Live"."CanEditType", "SiteTree_Live"."Version", CASE WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."URLSegment" ELSE "SiteTree_Live"."URLSegment" END AS "URLSegment", CASE WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."Title" ELSE "SiteTree_Live"."Title" END AS "Title", CASE WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."MenuTitle" ELSE "SiteTree_Live"."MenuTitle" END AS "MenuTitle", CASE WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."Content" ELSE "SiteTree_Live"."Content" END AS "Content", CASE WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."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_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."ReportClass" ELSE "SiteTree_Live"."ReportClass" END AS "ReportClass", "SiteTree_Live"."CanonicalLinkID", "SiteTree_Live"."FBImageID", "SiteTree_Live"."TwImageID", "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_GB' AS "Locale", CASE WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN 'en_GB' ELSE NULL END AS "SourceLocale" FROM "SiteTree_Live" LEFT JOIN "SiteTree_Localised_Live" AS "SiteTree_Localised_en_GB" ON "SiteTree_Live"."ID" = "SiteTree_Localised_en_GB"."RecordID" AND "SiteTree_Localised_en_GB"."Locale" = ? WHERE ("SiteTree_Live"."ID" = ?) AND (("SiteTree_Localised_en_GB"."ID" IS NOT NULL)) ORDER BY "SiteTree_Live"."Sort" ASC LIMIT 1 0.0001s

0045: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", CASE WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."BetterSiteTitle" ELSE "SiteTree_Live"."BetterSiteTitle" END AS "BetterSiteTitle", CASE WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."Keyword" ELSE "SiteTree_Live"."Keyword" END AS "Keyword", CASE WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."FeaturedKeyword" ELSE "SiteTree_Live"."FeaturedKeyword" END AS "FeaturedKeyword", CASE WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."KeywordQuestion" ELSE "SiteTree_Live"."KeywordQuestion" END AS "KeywordQuestion", "SiteTree_Live"."Follow", "SiteTree_Live"."FollowType", CASE WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."GenMetaDesc" ELSE "SiteTree_Live"."GenMetaDesc" END AS "GenMetaDesc", CASE WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."FBTitle" ELSE "SiteTree_Live"."FBTitle" END AS "FBTitle", CASE WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."FBDescription" ELSE "SiteTree_Live"."FBDescription" END AS "FBDescription", "SiteTree_Live"."FBType", "SiteTree_Live"."FBTypeOverride", CASE WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."TwTitle" ELSE "SiteTree_Live"."TwTitle" END AS "TwTitle", CASE WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."TwDescription" ELSE "SiteTree_Live"."TwDescription" END AS "TwDescription", "SiteTree_Live"."CanViewType", "SiteTree_Live"."CanEditType", "SiteTree_Live"."Version", CASE WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."URLSegment" ELSE "SiteTree_Live"."URLSegment" END AS "URLSegment", CASE WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."Title" ELSE "SiteTree_Live"."Title" END AS "Title", CASE WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."MenuTitle" ELSE "SiteTree_Live"."MenuTitle" END AS "MenuTitle", CASE WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."Content" ELSE "SiteTree_Live"."Content" END AS "Content", CASE WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."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_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."ReportClass" ELSE "SiteTree_Live"."ReportClass" END AS "ReportClass", "SiteTree_Live"."CanonicalLinkID", "SiteTree_Live"."FBImageID", "SiteTree_Live"."TwImageID", "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_GB' AS "Locale", CASE WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN 'en_GB' ELSE NULL END AS "SourceLocale" FROM "SiteTree_Live" LEFT JOIN "SiteTree_Localised_Live" AS "SiteTree_Localised_en_GB" ON "SiteTree_Live"."ID" = "SiteTree_Localised_en_GB"."RecordID" AND "SiteTree_Localised_en_GB"."Locale" = ? WHERE ("SiteTree_Live"."ID" = ?) AND (("SiteTree_Localised_en_GB"."ID" IS NOT NULL)) ORDER BY "SiteTree_Live"."Sort" ASC LIMIT 1 0.0003s

0046: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", CASE WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."BetterSiteTitle" ELSE "SiteTree_Live"."BetterSiteTitle" END AS "BetterSiteTitle", CASE WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."Keyword" ELSE "SiteTree_Live"."Keyword" END AS "Keyword", CASE WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."FeaturedKeyword" ELSE "SiteTree_Live"."FeaturedKeyword" END AS "FeaturedKeyword", CASE WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."KeywordQuestion" ELSE "SiteTree_Live"."KeywordQuestion" END AS "KeywordQuestion", "SiteTree_Live"."Follow", "SiteTree_Live"."FollowType", CASE WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."GenMetaDesc" ELSE "SiteTree_Live"."GenMetaDesc" END AS "GenMetaDesc", CASE WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."FBTitle" ELSE "SiteTree_Live"."FBTitle" END AS "FBTitle", CASE WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."FBDescription" ELSE "SiteTree_Live"."FBDescription" END AS "FBDescription", "SiteTree_Live"."FBType", "SiteTree_Live"."FBTypeOverride", CASE WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."TwTitle" ELSE "SiteTree_Live"."TwTitle" END AS "TwTitle", CASE WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."TwDescription" ELSE "SiteTree_Live"."TwDescription" END AS "TwDescription", "SiteTree_Live"."CanViewType", "SiteTree_Live"."CanEditType", "SiteTree_Live"."Version", CASE WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."URLSegment" ELSE "SiteTree_Live"."URLSegment" END AS "URLSegment", CASE WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."Title" ELSE "SiteTree_Live"."Title" END AS "Title", CASE WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."MenuTitle" ELSE "SiteTree_Live"."MenuTitle" END AS "MenuTitle", CASE WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."Content" ELSE "SiteTree_Live"."Content" END AS "Content", CASE WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."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_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."ReportClass" ELSE "SiteTree_Live"."ReportClass" END AS "ReportClass", "SiteTree_Live"."CanonicalLinkID", "SiteTree_Live"."FBImageID", "SiteTree_Live"."TwImageID", "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_GB' AS "Locale", CASE WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN 'en_GB' ELSE NULL END AS "SourceLocale" FROM "SiteTree_Live" LEFT JOIN "SiteTree_Localised_Live" AS "SiteTree_Localised_en_GB" ON "SiteTree_Live"."ID" = "SiteTree_Localised_en_GB"."RecordID" AND "SiteTree_Localised_en_GB"."Locale" = ? WHERE ("SiteTree_Live"."ID" = ?) AND (("SiteTree_Localised_en_GB"."ID" IS NOT NULL)) ORDER BY "SiteTree_Live"."Sort" ASC LIMIT 1 0.0003s

0047: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", CASE WHEN "SiteTree_Live"."ClassName" IN ('Page', 'GeschichteKulturDialog\\App\\CityTourHolder', 'GeschichteKulturDialog\\App\\CityTourPage', 'GeschichteKulturDialog\\App\\HomePage', 'SilverStripe\\ErrorPage\\ErrorPage', 'SilverStripe\\CMS\\Model\\RedirectorPage', 'SilverStripe\\CMS\\Model\\VirtualPage', 'SilverStripe\\UserForms\\Model\\UserDefinedForm') THEN "Page_Live"."ElementalAreaID" WHEN "SiteTree_Live"."ClassName" IN ('GeschichteKulturDialog\\App\\CityTourPage') THEN "CityTourPage_Live"."ElementalAreaID" WHEN "SiteTree_Live"."ClassName" IN ('GeschichteKulturDialog\\App\\CityTourPage') THEN "CityTourPage_Live"."ElementalAreaID" ELSE NULL END AS "ElementalAreaID", CASE WHEN "CityTourPage_Localised_en_GB"."ID" IS NOT NULL THEN "CityTourPage_Localised_en_GB"."Teaser" ELSE "CityTourPage_Live"."Teaser" END AS "Teaser", CASE WHEN "CityTourPage_Localised_en_GB"."ID" IS NOT NULL THEN "CityTourPage_Localised_en_GB"."SubTitle" ELSE "CityTourPage_Live"."SubTitle" END AS "SubTitle", CASE WHEN "CityTourPage_Localised_en_GB"."ID" IS NOT NULL THEN "CityTourPage_Localised_en_GB"."Price" ELSE "CityTourPage_Live"."Price" END AS "Price", CASE WHEN "CityTourPage_Localised_en_GB"."ID" IS NOT NULL THEN "CityTourPage_Localised_en_GB"."Duration" ELSE "CityTourPage_Live"."Duration" END AS "Duration", CASE WHEN "CityTourPage_Localised_en_GB"."ID" IS NOT NULL THEN "CityTourPage_Localised_en_GB"."Buchung" ELSE "CityTourPage_Live"."Buchung" END AS "Buchung", "CityTourPage_Live"."Higlight", "CityTourPage_Live"."ImageID", "CityTourPage_Live"."CityTourCategoryID", "SiteTree_Live"."ID", CASE WHEN "SiteTree_Live"."ClassName" IS NOT NULL THEN "SiteTree_Live"."ClassName" ELSE 'SilverStripe\\CMS\\Model\\SiteTree' END AS "RecordClassName", 'en_GB' AS "Locale", CASE WHEN "CityTourPage_Localised_en_GB"."ID" IS NOT NULL THEN 'en_GB' ELSE NULL END AS "SourceLocale", "SiteTree_Live"."Sort" FROM "SiteTree_Live" LEFT JOIN "Page_Live" ON "Page_Live"."ID" = "SiteTree_Live"."ID" LEFT JOIN "CityTourPage_Live" ON "CityTourPage_Live"."ID" = "SiteTree_Live"."ID" LEFT JOIN "SiteTree_Localised_Live" AS "SiteTree_Localised_en_GB" ON "SiteTree_Live"."ID" = "SiteTree_Localised_en_GB"."RecordID" AND "SiteTree_Localised_en_GB"."Locale" = ? LEFT JOIN "CityTourPage_Localised_Live" AS "CityTourPage_Localised_en_GB" ON "CityTourPage_Live"."ID" = "CityTourPage_Localised_en_GB"."RecordID" AND "CityTourPage_Localised_en_GB"."Locale" = ? WHERE ("SiteTree_Live"."ID" = ?) AND ("SiteTree_Live"."ClassName" IN (?)) AND (("SiteTree_Localised_en_GB"."ID" IS NOT NULL)) AND (("SiteTree_Localised_en_GB"."ID" IS NOT NULL)) ORDER BY "SiteTree_Live"."Sort" ASC LIMIT 1 0.0026s

0048: SELECT DISTINCT "File_Live"."ClassName", "File_Live"."LastEdited", "File_Live"."Created", "File_Live"."UserFormUpload", "File_Live"."Version", "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.0015s

0049: SELECT DISTINCT "ElementalArea_Live"."ClassName", "ElementalArea_Live"."LastEdited", "ElementalArea_Live"."Created", "ElementalArea_Live"."Version", "ElementalArea_Live"."OwnerClassName", "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.0009s

0050: SELECT DISTINCT "Element_Live"."ClassName", "Element_Live"."LastEdited", "Element_Live"."Created", CASE WHEN "Element_Localised_en_GB"."ID" IS NOT NULL THEN "Element_Localised_en_GB"."Title" ELSE "Element_Live"."Title" END AS "Title", "Element_Live"."ExtraCSSClass", CASE WHEN "Element_Localised_en_GB"."ID" IS NOT NULL THEN "Element_Localised_en_GB"."NavigationName" ELSE "Element_Live"."NavigationName" END AS "NavigationName", "Element_Live"."NavigationLink", "Element_Live"."SetNavigation", "Element_Live"."Version", "Element_Live"."ShowTitle", "Element_Live"."Sort", "Element_Live"."ExtraClass", "Element_Live"."Style", "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_GB' AS "Locale", CASE WHEN "Element_Localised_en_GB"."ID" IS NOT NULL THEN 'en_GB' ELSE NULL END AS "SourceLocale" FROM "Element_Live" LEFT JOIN "Element_Localised_Live" AS "Element_Localised_en_GB" ON "Element_Live"."ID" = "Element_Localised_en_GB"."RecordID" AND "Element_Localised_en_GB"."Locale" = ? WHERE ("Element_Live"."ParentID" = ?) AND (("Element_Localised_en_GB"."ID" IS NOT NULL)) ORDER BY "Element_Live"."Sort" ASC 0.0025s

0051: SELECT DISTINCT "ElementalArea_Live"."ClassName", "ElementalArea_Live"."LastEdited", "ElementalArea_Live"."Created", "ElementalArea_Live"."Version", "ElementalArea_Live"."OwnerClassName", "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.0001s

0052: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", CASE WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."BetterSiteTitle" ELSE "SiteTree_Live"."BetterSiteTitle" END AS "BetterSiteTitle", CASE WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."Keyword" ELSE "SiteTree_Live"."Keyword" END AS "Keyword", CASE WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."FeaturedKeyword" ELSE "SiteTree_Live"."FeaturedKeyword" END AS "FeaturedKeyword", CASE WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."KeywordQuestion" ELSE "SiteTree_Live"."KeywordQuestion" END AS "KeywordQuestion", "SiteTree_Live"."Follow", "SiteTree_Live"."FollowType", CASE WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."GenMetaDesc" ELSE "SiteTree_Live"."GenMetaDesc" END AS "GenMetaDesc", CASE WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."FBTitle" ELSE "SiteTree_Live"."FBTitle" END AS "FBTitle", CASE WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."FBDescription" ELSE "SiteTree_Live"."FBDescription" END AS "FBDescription", "SiteTree_Live"."FBType", "SiteTree_Live"."FBTypeOverride", CASE WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."TwTitle" ELSE "SiteTree_Live"."TwTitle" END AS "TwTitle", CASE WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."TwDescription" ELSE "SiteTree_Live"."TwDescription" END AS "TwDescription", "SiteTree_Live"."CanViewType", "SiteTree_Live"."CanEditType", "SiteTree_Live"."Version", CASE WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."URLSegment" ELSE "SiteTree_Live"."URLSegment" END AS "URLSegment", CASE WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."Title" ELSE "SiteTree_Live"."Title" END AS "Title", CASE WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."MenuTitle" ELSE "SiteTree_Live"."MenuTitle" END AS "MenuTitle", CASE WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."Content" ELSE "SiteTree_Live"."Content" END AS "Content", CASE WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."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_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."ReportClass" ELSE "SiteTree_Live"."ReportClass" END AS "ReportClass", "SiteTree_Live"."CanonicalLinkID", "SiteTree_Live"."FBImageID", "SiteTree_Live"."TwImageID", "SiteTree_Live"."ParentID", CASE WHEN "SiteTree_Live"."ClassName" IN ('Page', 'GeschichteKulturDialog\\App\\CityTourHolder', 'GeschichteKulturDialog\\App\\CityTourPage', 'GeschichteKulturDialog\\App\\HomePage', 'SilverStripe\\ErrorPage\\ErrorPage', 'SilverStripe\\CMS\\Model\\RedirectorPage', 'SilverStripe\\CMS\\Model\\VirtualPage', 'SilverStripe\\UserForms\\Model\\UserDefinedForm') THEN "Page_Live"."ElementalAreaID" WHEN "SiteTree_Live"."ClassName" IN ('GeschichteKulturDialog\\App\\CityTourPage') THEN "CityTourPage_Live"."ElementalAreaID" ELSE NULL END AS "ElementalAreaID", CASE WHEN "CityTourPage_Localised_en_GB"."ID" IS NOT NULL THEN "CityTourPage_Localised_en_GB"."Teaser" ELSE "CityTourPage_Live"."Teaser" END AS "Teaser", CASE WHEN "CityTourPage_Localised_en_GB"."ID" IS NOT NULL THEN "CityTourPage_Localised_en_GB"."SubTitle" ELSE "CityTourPage_Live"."SubTitle" END AS "SubTitle", CASE WHEN "CityTourPage_Localised_en_GB"."ID" IS NOT NULL THEN "CityTourPage_Localised_en_GB"."Price" ELSE "CityTourPage_Live"."Price" END AS "Price", CASE WHEN "CityTourPage_Localised_en_GB"."ID" IS NOT NULL THEN "CityTourPage_Localised_en_GB"."Duration" ELSE "CityTourPage_Live"."Duration" END AS "Duration", CASE WHEN "CityTourPage_Localised_en_GB"."ID" IS NOT NULL THEN "CityTourPage_Localised_en_GB"."Buchung" ELSE "CityTourPage_Live"."Buchung" END AS "Buchung", "CityTourPage_Live"."Higlight", "CityTourPage_Live"."ImageID", "CityTourPage_Live"."CityTourCategoryID", "SiteTree_Live"."ID", CASE WHEN "SiteTree_Live"."ClassName" IS NOT NULL THEN "SiteTree_Live"."ClassName" ELSE 'SilverStripe\\CMS\\Model\\SiteTree' END AS "RecordClassName", 'en_GB' AS "Locale", CASE WHEN "CityTourPage_Localised_en_GB"."ID" IS NOT NULL THEN 'en_GB' ELSE NULL END AS "SourceLocale" FROM "SiteTree_Live" LEFT JOIN "Page_Live" ON "Page_Live"."ID" = "SiteTree_Live"."ID" LEFT JOIN "CityTourPage_Live" ON "CityTourPage_Live"."ID" = "SiteTree_Live"."ID" LEFT JOIN "SiteTree_Localised_Live" AS "SiteTree_Localised_en_GB" ON "SiteTree_Live"."ID" = "SiteTree_Localised_en_GB"."RecordID" AND "SiteTree_Localised_en_GB"."Locale" = ? LEFT JOIN "CityTourPage_Localised_Live" AS "CityTourPage_Localised_en_GB" ON "CityTourPage_Live"."ID" = "CityTourPage_Localised_en_GB"."RecordID" AND "CityTourPage_Localised_en_GB"."Locale" = ? WHERE ("CityTourPage_Live"."ElementalAreaID" = ?) AND ("SiteTree_Live"."ClassName" = ?) AND ("SiteTree_Live"."ClassName" IN (?)) AND (("SiteTree_Localised_en_GB"."ID" IS NOT NULL)) AND (("SiteTree_Localised_en_GB"."ID" IS NOT NULL)) ORDER BY "SiteTree_Live"."Sort" ASC LIMIT 1 0.0023s

0053: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", CASE WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."BetterSiteTitle" ELSE "SiteTree_Live"."BetterSiteTitle" END AS "BetterSiteTitle", CASE WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."Keyword" ELSE "SiteTree_Live"."Keyword" END AS "Keyword", CASE WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."FeaturedKeyword" ELSE "SiteTree_Live"."FeaturedKeyword" END AS "FeaturedKeyword", CASE WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."KeywordQuestion" ELSE "SiteTree_Live"."KeywordQuestion" END AS "KeywordQuestion", "SiteTree_Live"."Follow", "SiteTree_Live"."FollowType", CASE WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."GenMetaDesc" ELSE "SiteTree_Live"."GenMetaDesc" END AS "GenMetaDesc", CASE WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."FBTitle" ELSE "SiteTree_Live"."FBTitle" END AS "FBTitle", CASE WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."FBDescription" ELSE "SiteTree_Live"."FBDescription" END AS "FBDescription", "SiteTree_Live"."FBType", "SiteTree_Live"."FBTypeOverride", CASE WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."TwTitle" ELSE "SiteTree_Live"."TwTitle" END AS "TwTitle", CASE WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."TwDescription" ELSE "SiteTree_Live"."TwDescription" END AS "TwDescription", "SiteTree_Live"."CanViewType", "SiteTree_Live"."CanEditType", "SiteTree_Live"."Version", CASE WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."URLSegment" ELSE "SiteTree_Live"."URLSegment" END AS "URLSegment", CASE WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."Title" ELSE "SiteTree_Live"."Title" END AS "Title", CASE WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."MenuTitle" ELSE "SiteTree_Live"."MenuTitle" END AS "MenuTitle", CASE WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."Content" ELSE "SiteTree_Live"."Content" END AS "Content", CASE WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."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_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."ReportClass" ELSE "SiteTree_Live"."ReportClass" END AS "ReportClass", "SiteTree_Live"."CanonicalLinkID", "SiteTree_Live"."FBImageID", "SiteTree_Live"."TwImageID", "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_GB' AS "Locale", CASE WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN 'en_GB' ELSE NULL END AS "SourceLocale" FROM "SiteTree_Live" LEFT JOIN "SiteTree_Localised_Live" AS "SiteTree_Localised_en_GB" ON "SiteTree_Live"."ID" = "SiteTree_Localised_en_GB"."RecordID" AND "SiteTree_Localised_en_GB"."Locale" = ? WHERE ("SiteTree_Live"."ID" = ?) AND (("SiteTree_Localised_en_GB"."ID" IS NOT NULL)) ORDER BY "SiteTree_Live"."Sort" ASC LIMIT 1 0.0001s

0054: SELECT DISTINCT "ElementalArea_Live"."ClassName", "ElementalArea_Live"."LastEdited", "ElementalArea_Live"."Created", "ElementalArea_Live"."Version", "ElementalArea_Live"."OwnerClassName", "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.0001s

0055: SELECT DISTINCT "Element_Live"."ClassName", "Element_Live"."LastEdited", "Element_Live"."Created", "ElementImage_Live"."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_GB' AS "Locale", CASE WHEN "Element_Localised_en_GB"."ID" IS NOT NULL THEN 'en_GB' ELSE NULL END AS "SourceLocale", "Element_Live"."Sort" FROM "Element_Live" LEFT JOIN "ElementImage_Live" ON "ElementImage_Live"."ID" = "Element_Live"."ID" LEFT JOIN "Element_Localised_Live" AS "Element_Localised_en_GB" ON "Element_Live"."ID" = "Element_Localised_en_GB"."RecordID" AND "Element_Localised_en_GB"."Locale" = ? WHERE ("Element_Live"."ID" = ?) AND ("Element_Live"."ClassName" IN (?)) AND (("Element_Localised_en_GB"."ID" IS NOT NULL)) ORDER BY "Element_Live"."Sort" ASC LIMIT 1 0.0007s

0056: SELECT DISTINCT "File_Live"."ClassName", "File_Live"."LastEdited", "File_Live"."Created", "File_Live"."UserFormUpload", "File_Live"."Version", "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.0002s

0057: SELECT DISTINCT "Element_Live"."ClassName", "Element_Live"."LastEdited", "Element_Live"."Created", CASE WHEN "ElementText_Localised_en_GB"."ID" IS NOT NULL THEN "ElementText_Localised_en_GB"."Content" ELSE "ElementText_Live"."Content" END AS "Content", "Element_Live"."ID", CASE WHEN "Element_Live"."ClassName" IS NOT NULL THEN "Element_Live"."ClassName" ELSE 'DNADesign\\Elemental\\Models\\BaseElement' END AS "RecordClassName", 'en_GB' AS "Locale", CASE WHEN "ElementText_Localised_en_GB"."ID" IS NOT NULL THEN 'en_GB' ELSE NULL END AS "SourceLocale", "Element_Live"."Sort" FROM "Element_Live" LEFT JOIN "ElementText_Live" ON "ElementText_Live"."ID" = "Element_Live"."ID" LEFT JOIN "Element_Localised_Live" AS "Element_Localised_en_GB" ON "Element_Live"."ID" = "Element_Localised_en_GB"."RecordID" AND "Element_Localised_en_GB"."Locale" = ? LEFT JOIN "ElementText_Localised_Live" AS "ElementText_Localised_en_GB" ON "ElementText_Live"."ID" = "ElementText_Localised_en_GB"."RecordID" AND "ElementText_Localised_en_GB"."Locale" = ? WHERE ("Element_Live"."ID" = ?) AND ("Element_Live"."ClassName" IN (?)) AND (("Element_Localised_en_GB"."ID" IS NOT NULL)) ORDER BY "Element_Live"."Sort" ASC LIMIT 1 0.002s

0058: SELECT DISTINCT "Element_Live"."ClassName", "Element_Live"."LastEdited", "Element_Live"."Created", "ElementImage_Live"."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_GB' AS "Locale", CASE WHEN "Element_Localised_en_GB"."ID" IS NOT NULL THEN 'en_GB' ELSE NULL END AS "SourceLocale", "Element_Live"."Sort" FROM "Element_Live" LEFT JOIN "ElementImage_Live" ON "ElementImage_Live"."ID" = "Element_Live"."ID" LEFT JOIN "Element_Localised_Live" AS "Element_Localised_en_GB" ON "Element_Live"."ID" = "Element_Localised_en_GB"."RecordID" AND "Element_Localised_en_GB"."Locale" = ? WHERE ("Element_Live"."ID" = ?) AND ("Element_Live"."ClassName" IN (?)) AND (("Element_Localised_en_GB"."ID" IS NOT NULL)) ORDER BY "Element_Live"."Sort" ASC LIMIT 1 0.0004s

0059: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", CASE WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."BetterSiteTitle" ELSE "SiteTree_Live"."BetterSiteTitle" END AS "BetterSiteTitle", CASE WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."Keyword" ELSE "SiteTree_Live"."Keyword" END AS "Keyword", CASE WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."FeaturedKeyword" ELSE "SiteTree_Live"."FeaturedKeyword" END AS "FeaturedKeyword", CASE WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."KeywordQuestion" ELSE "SiteTree_Live"."KeywordQuestion" END AS "KeywordQuestion", "SiteTree_Live"."Follow", "SiteTree_Live"."FollowType", CASE WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."GenMetaDesc" ELSE "SiteTree_Live"."GenMetaDesc" END AS "GenMetaDesc", CASE WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."FBTitle" ELSE "SiteTree_Live"."FBTitle" END AS "FBTitle", CASE WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."FBDescription" ELSE "SiteTree_Live"."FBDescription" END AS "FBDescription", "SiteTree_Live"."FBType", "SiteTree_Live"."FBTypeOverride", CASE WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."TwTitle" ELSE "SiteTree_Live"."TwTitle" END AS "TwTitle", CASE WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."TwDescription" ELSE "SiteTree_Live"."TwDescription" END AS "TwDescription", "SiteTree_Live"."CanViewType", "SiteTree_Live"."CanEditType", "SiteTree_Live"."Version", CASE WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."URLSegment" ELSE "SiteTree_Live"."URLSegment" END AS "URLSegment", CASE WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."Title" ELSE "SiteTree_Live"."Title" END AS "Title", CASE WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."MenuTitle" ELSE "SiteTree_Live"."MenuTitle" END AS "MenuTitle", CASE WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."Content" ELSE "SiteTree_Live"."Content" END AS "Content", CASE WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."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_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."ReportClass" ELSE "SiteTree_Live"."ReportClass" END AS "ReportClass", "SiteTree_Live"."CanonicalLinkID", "SiteTree_Live"."FBImageID", "SiteTree_Live"."TwImageID", "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_GB' AS "Locale", CASE WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN 'en_GB' ELSE NULL END AS "SourceLocale" FROM "SiteTree_Live" LEFT JOIN "SiteTree_Localised_Live" AS "SiteTree_Localised_en_GB" ON "SiteTree_Live"."ID" = "SiteTree_Localised_en_GB"."RecordID" AND "SiteTree_Localised_en_GB"."Locale" = ? WHERE ("SiteTree_Live"."ID" = ?) AND (("SiteTree_Localised_en_GB"."ID" IS NOT NULL)) ORDER BY "SiteTree_Live"."Sort" ASC LIMIT 1 0.0004s

0060: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", CASE WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."BetterSiteTitle" ELSE "SiteTree_Live"."BetterSiteTitle" END AS "BetterSiteTitle", CASE WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."Keyword" ELSE "SiteTree_Live"."Keyword" END AS "Keyword", CASE WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."FeaturedKeyword" ELSE "SiteTree_Live"."FeaturedKeyword" END AS "FeaturedKeyword", CASE WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."KeywordQuestion" ELSE "SiteTree_Live"."KeywordQuestion" END AS "KeywordQuestion", "SiteTree_Live"."Follow", "SiteTree_Live"."FollowType", CASE WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."GenMetaDesc" ELSE "SiteTree_Live"."GenMetaDesc" END AS "GenMetaDesc", CASE WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."FBTitle" ELSE "SiteTree_Live"."FBTitle" END AS "FBTitle", CASE WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."FBDescription" ELSE "SiteTree_Live"."FBDescription" END AS "FBDescription", "SiteTree_Live"."FBType", "SiteTree_Live"."FBTypeOverride", CASE WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."TwTitle" ELSE "SiteTree_Live"."TwTitle" END AS "TwTitle", CASE WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."TwDescription" ELSE "SiteTree_Live"."TwDescription" END AS "TwDescription", "SiteTree_Live"."CanViewType", "SiteTree_Live"."CanEditType", "SiteTree_Live"."Version", CASE WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."URLSegment" ELSE "SiteTree_Live"."URLSegment" END AS "URLSegment", CASE WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."Title" ELSE "SiteTree_Live"."Title" END AS "Title", CASE WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."MenuTitle" ELSE "SiteTree_Live"."MenuTitle" END AS "MenuTitle", CASE WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."Content" ELSE "SiteTree_Live"."Content" END AS "Content", CASE WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."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_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."ReportClass" ELSE "SiteTree_Live"."ReportClass" END AS "ReportClass", "SiteTree_Live"."CanonicalLinkID", "SiteTree_Live"."FBImageID", "SiteTree_Live"."TwImageID", "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_GB' AS "Locale", CASE WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN 'en_GB' ELSE NULL END AS "SourceLocale" FROM "SiteTree_Live" LEFT JOIN "SiteTree_Localised_Live" AS "SiteTree_Localised_en_GB" ON "SiteTree_Live"."ID" = "SiteTree_Localised_en_GB"."RecordID" AND "SiteTree_Localised_en_GB"."Locale" = ? WHERE ("SiteTree_Live"."ID" = ?) AND (("SiteTree_Localised_en_GB"."ID" IS NOT NULL)) ORDER BY "SiteTree_Live"."Sort" ASC LIMIT 1 0.0003s

0061: SELECT DISTINCT "File_Live"."ClassName", "File_Live"."LastEdited", "File_Live"."Created", "File_Live"."UserFormUpload", "File_Live"."Version", "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.0006s

0063: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", CASE WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."BetterSiteTitle" ELSE "SiteTree_Live"."BetterSiteTitle" END AS "BetterSiteTitle", CASE WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."Keyword" ELSE "SiteTree_Live"."Keyword" END AS "Keyword", CASE WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."FeaturedKeyword" ELSE "SiteTree_Live"."FeaturedKeyword" END AS "FeaturedKeyword", CASE WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."KeywordQuestion" ELSE "SiteTree_Live"."KeywordQuestion" END AS "KeywordQuestion", "SiteTree_Live"."Follow", "SiteTree_Live"."FollowType", CASE WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."GenMetaDesc" ELSE "SiteTree_Live"."GenMetaDesc" END AS "GenMetaDesc", CASE WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."FBTitle" ELSE "SiteTree_Live"."FBTitle" END AS "FBTitle", CASE WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."FBDescription" ELSE "SiteTree_Live"."FBDescription" END AS "FBDescription", "SiteTree_Live"."FBType", "SiteTree_Live"."FBTypeOverride", CASE WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."TwTitle" ELSE "SiteTree_Live"."TwTitle" END AS "TwTitle", CASE WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."TwDescription" ELSE "SiteTree_Live"."TwDescription" END AS "TwDescription", "SiteTree_Live"."CanViewType", "SiteTree_Live"."CanEditType", "SiteTree_Live"."Version", CASE WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."URLSegment" ELSE "SiteTree_Live"."URLSegment" END AS "URLSegment", CASE WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."Title" ELSE "SiteTree_Live"."Title" END AS "Title", CASE WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."MenuTitle" ELSE "SiteTree_Live"."MenuTitle" END AS "MenuTitle", CASE WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."Content" ELSE "SiteTree_Live"."Content" END AS "Content", CASE WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."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_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."ReportClass" ELSE "SiteTree_Live"."ReportClass" END AS "ReportClass", "SiteTree_Live"."CanonicalLinkID", "SiteTree_Live"."FBImageID", "SiteTree_Live"."TwImageID", "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_GB' AS "Locale", CASE WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN 'en_GB' ELSE NULL END AS "SourceLocale" FROM "SiteTree_Live" LEFT JOIN "SiteTree_Localised_Live" AS "SiteTree_Localised_en_GB" ON "SiteTree_Live"."ID" = "SiteTree_Localised_en_GB"."RecordID" AND "SiteTree_Localised_en_GB"."Locale" = ? WHERE ("SiteTree_Live"."ID" = ?) AND (("SiteTree_Localised_en_GB"."ID" IS NOT NULL)) ORDER BY "SiteTree_Live"."Sort" ASC LIMIT 1 0.0003s

0064: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", CASE WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."BetterSiteTitle" ELSE "SiteTree_Live"."BetterSiteTitle" END AS "BetterSiteTitle", CASE WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."Keyword" ELSE "SiteTree_Live"."Keyword" END AS "Keyword", CASE WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."FeaturedKeyword" ELSE "SiteTree_Live"."FeaturedKeyword" END AS "FeaturedKeyword", CASE WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."KeywordQuestion" ELSE "SiteTree_Live"."KeywordQuestion" END AS "KeywordQuestion", "SiteTree_Live"."Follow", "SiteTree_Live"."FollowType", CASE WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."GenMetaDesc" ELSE "SiteTree_Live"."GenMetaDesc" END AS "GenMetaDesc", CASE WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."FBTitle" ELSE "SiteTree_Live"."FBTitle" END AS "FBTitle", CASE WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."FBDescription" ELSE "SiteTree_Live"."FBDescription" END AS "FBDescription", "SiteTree_Live"."FBType", "SiteTree_Live"."FBTypeOverride", CASE WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."TwTitle" ELSE "SiteTree_Live"."TwTitle" END AS "TwTitle", CASE WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."TwDescription" ELSE "SiteTree_Live"."TwDescription" END AS "TwDescription", "SiteTree_Live"."CanViewType", "SiteTree_Live"."CanEditType", "SiteTree_Live"."Version", CASE WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."URLSegment" ELSE "SiteTree_Live"."URLSegment" END AS "URLSegment", CASE WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."Title" ELSE "SiteTree_Live"."Title" END AS "Title", CASE WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."MenuTitle" ELSE "SiteTree_Live"."MenuTitle" END AS "MenuTitle", CASE WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."Content" ELSE "SiteTree_Live"."Content" END AS "Content", CASE WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."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_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."ReportClass" ELSE "SiteTree_Live"."ReportClass" END AS "ReportClass", "SiteTree_Live"."CanonicalLinkID", "SiteTree_Live"."FBImageID", "SiteTree_Live"."TwImageID", "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_GB' AS "Locale", CASE WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN 'en_GB' ELSE NULL END AS "SourceLocale" FROM "SiteTree_Live" LEFT JOIN "SiteTree_Localised_Live" AS "SiteTree_Localised_en_GB" ON "SiteTree_Live"."ID" = "SiteTree_Localised_en_GB"."RecordID" AND "SiteTree_Localised_en_GB"."Locale" = ? WHERE ("SiteTree_Live"."ID" = ?) AND (("SiteTree_Localised_en_GB"."ID" IS NOT NULL)) ORDER BY "SiteTree_Live"."Sort" ASC LIMIT 1 0.0001s

0065: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", CASE WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."BetterSiteTitle" ELSE "SiteTree_Live"."BetterSiteTitle" END AS "BetterSiteTitle", CASE WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."Keyword" ELSE "SiteTree_Live"."Keyword" END AS "Keyword", CASE WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."FeaturedKeyword" ELSE "SiteTree_Live"."FeaturedKeyword" END AS "FeaturedKeyword", CASE WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."KeywordQuestion" ELSE "SiteTree_Live"."KeywordQuestion" END AS "KeywordQuestion", "SiteTree_Live"."Follow", "SiteTree_Live"."FollowType", CASE WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."GenMetaDesc" ELSE "SiteTree_Live"."GenMetaDesc" END AS "GenMetaDesc", CASE WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."FBTitle" ELSE "SiteTree_Live"."FBTitle" END AS "FBTitle", CASE WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."FBDescription" ELSE "SiteTree_Live"."FBDescription" END AS "FBDescription", "SiteTree_Live"."FBType", "SiteTree_Live"."FBTypeOverride", CASE WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."TwTitle" ELSE "SiteTree_Live"."TwTitle" END AS "TwTitle", CASE WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."TwDescription" ELSE "SiteTree_Live"."TwDescription" END AS "TwDescription", "SiteTree_Live"."CanViewType", "SiteTree_Live"."CanEditType", "SiteTree_Live"."Version", CASE WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."URLSegment" ELSE "SiteTree_Live"."URLSegment" END AS "URLSegment", CASE WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."Title" ELSE "SiteTree_Live"."Title" END AS "Title", CASE WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."MenuTitle" ELSE "SiteTree_Live"."MenuTitle" END AS "MenuTitle", CASE WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."Content" ELSE "SiteTree_Live"."Content" END AS "Content", CASE WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."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_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."ReportClass" ELSE "SiteTree_Live"."ReportClass" END AS "ReportClass", "SiteTree_Live"."CanonicalLinkID", "SiteTree_Live"."FBImageID", "SiteTree_Live"."TwImageID", "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_GB' AS "Locale", CASE WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN 'en_GB' ELSE NULL END AS "SourceLocale" FROM "SiteTree_Live" LEFT JOIN "SiteTree_Localised_Live" AS "SiteTree_Localised_en_GB" ON "SiteTree_Live"."ID" = "SiteTree_Localised_en_GB"."RecordID" AND "SiteTree_Localised_en_GB"."Locale" = ? WHERE ("SiteTree_Live"."ID" = ?) AND (("SiteTree_Localised_en_GB"."ID" IS NOT NULL)) ORDER BY "SiteTree_Live"."Sort" ASC LIMIT 1 0.0004s

0066: SELECT DISTINCT "SiteTree"."ClassName", "SiteTree"."LastEdited", "SiteTree"."Created", "SiteTree"."Priority", CASE WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."BetterSiteTitle" ELSE "SiteTree"."BetterSiteTitle" END AS "BetterSiteTitle", CASE WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."Keyword" ELSE "SiteTree"."Keyword" END AS "Keyword", CASE WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."FeaturedKeyword" ELSE "SiteTree"."FeaturedKeyword" END AS "FeaturedKeyword", CASE WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."KeywordQuestion" ELSE "SiteTree"."KeywordQuestion" END AS "KeywordQuestion", "SiteTree"."Follow", "SiteTree"."FollowType", CASE WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."GenMetaDesc" ELSE "SiteTree"."GenMetaDesc" END AS "GenMetaDesc", CASE WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."FBTitle" ELSE "SiteTree"."FBTitle" END AS "FBTitle", CASE WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."FBDescription" ELSE "SiteTree"."FBDescription" END AS "FBDescription", "SiteTree"."FBType", "SiteTree"."FBTypeOverride", CASE WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."TwTitle" ELSE "SiteTree"."TwTitle" END AS "TwTitle", CASE WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."TwDescription" ELSE "SiteTree"."TwDescription" END AS "TwDescription", "SiteTree"."CanViewType", "SiteTree"."CanEditType", "SiteTree"."Version", CASE WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."URLSegment" ELSE "SiteTree"."URLSegment" END AS "URLSegment", CASE WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."Title" ELSE "SiteTree"."Title" END AS "Title", CASE WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."MenuTitle" ELSE "SiteTree"."MenuTitle" END AS "MenuTitle", CASE WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."Content" ELSE "SiteTree"."Content" END AS "Content", CASE WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."MetaDescription" ELSE "SiteTree"."MetaDescription" END AS "MetaDescription", "SiteTree"."ExtraMeta", "SiteTree"."ShowInMenus", "SiteTree"."ShowInSearch", "SiteTree"."Sort", "SiteTree"."HasBrokenFile", "SiteTree"."HasBrokenLink", CASE WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."ReportClass" ELSE "SiteTree"."ReportClass" END AS "ReportClass", "SiteTree"."CanonicalLinkID", "SiteTree"."FBImageID", "SiteTree"."TwImageID", "SiteTree"."ParentID", "SiteTree"."ID", CASE WHEN "SiteTree"."ClassName" IS NOT NULL THEN "SiteTree"."ClassName" ELSE 'SilverStripe\\CMS\\Model\\SiteTree' END AS "RecordClassName", 'en_GB' AS "Locale", CASE WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN 'en_GB' ELSE NULL END AS "SourceLocale" FROM "SiteTree" LEFT JOIN "SiteTree_Localised" AS "SiteTree_Localised_en_GB" ON "SiteTree"."ID" = "SiteTree_Localised_en_GB"."RecordID" AND "SiteTree_Localised_en_GB"."Locale" = ? WHERE ("SiteTree"."ID" = ?) AND (("SiteTree_Localised_en_GB"."ID" IS NOT NULL)) ORDER BY "SiteTree"."Sort" ASC LIMIT 1 0.0013s

0067: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", CASE WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."BetterSiteTitle" ELSE "SiteTree_Live"."BetterSiteTitle" END AS "BetterSiteTitle", CASE WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."Keyword" ELSE "SiteTree_Live"."Keyword" END AS "Keyword", CASE WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."FeaturedKeyword" ELSE "SiteTree_Live"."FeaturedKeyword" END AS "FeaturedKeyword", CASE WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."KeywordQuestion" ELSE "SiteTree_Live"."KeywordQuestion" END AS "KeywordQuestion", "SiteTree_Live"."Follow", "SiteTree_Live"."FollowType", CASE WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."GenMetaDesc" ELSE "SiteTree_Live"."GenMetaDesc" END AS "GenMetaDesc", CASE WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."FBTitle" ELSE "SiteTree_Live"."FBTitle" END AS "FBTitle", CASE WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."FBDescription" ELSE "SiteTree_Live"."FBDescription" END AS "FBDescription", "SiteTree_Live"."FBType", "SiteTree_Live"."FBTypeOverride", CASE WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."TwTitle" ELSE "SiteTree_Live"."TwTitle" END AS "TwTitle", CASE WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."TwDescription" ELSE "SiteTree_Live"."TwDescription" END AS "TwDescription", "SiteTree_Live"."CanViewType", "SiteTree_Live"."CanEditType", "SiteTree_Live"."Version", CASE WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."URLSegment" ELSE "SiteTree_Live"."URLSegment" END AS "URLSegment", CASE WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."Title" ELSE "SiteTree_Live"."Title" END AS "Title", CASE WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."MenuTitle" ELSE "SiteTree_Live"."MenuTitle" END AS "MenuTitle", CASE WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."Content" ELSE "SiteTree_Live"."Content" END AS "Content", CASE WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."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_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."ReportClass" ELSE "SiteTree_Live"."ReportClass" END AS "ReportClass", "SiteTree_Live"."CanonicalLinkID", "SiteTree_Live"."FBImageID", "SiteTree_Live"."TwImageID", "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_GB' AS "Locale", CASE WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN 'en_GB' ELSE NULL END AS "SourceLocale" FROM "SiteTree_Live" LEFT JOIN "SiteTree_Localised_Live" AS "SiteTree_Localised_en_GB" ON "SiteTree_Live"."ID" = "SiteTree_Localised_en_GB"."RecordID" AND "SiteTree_Localised_en_GB"."Locale" = ? WHERE ("SiteTree_Live"."ID" = ?) AND (("SiteTree_Localised_en_GB"."ID" IS NOT NULL)) ORDER BY "SiteTree_Live"."Sort" ASC LIMIT 1 0.0002s

0068: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", CASE WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."BetterSiteTitle" ELSE "SiteTree_Live"."BetterSiteTitle" END AS "BetterSiteTitle", CASE WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."Keyword" ELSE "SiteTree_Live"."Keyword" END AS "Keyword", CASE WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."FeaturedKeyword" ELSE "SiteTree_Live"."FeaturedKeyword" END AS "FeaturedKeyword", CASE WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."KeywordQuestion" ELSE "SiteTree_Live"."KeywordQuestion" END AS "KeywordQuestion", "SiteTree_Live"."Follow", "SiteTree_Live"."FollowType", CASE WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."GenMetaDesc" ELSE "SiteTree_Live"."GenMetaDesc" END AS "GenMetaDesc", CASE WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."FBTitle" ELSE "SiteTree_Live"."FBTitle" END AS "FBTitle", CASE WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."FBDescription" ELSE "SiteTree_Live"."FBDescription" END AS "FBDescription", "SiteTree_Live"."FBType", "SiteTree_Live"."FBTypeOverride", CASE WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."TwTitle" ELSE "SiteTree_Live"."TwTitle" END AS "TwTitle", CASE WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."TwDescription" ELSE "SiteTree_Live"."TwDescription" END AS "TwDescription", "SiteTree_Live"."CanViewType", "SiteTree_Live"."CanEditType", "SiteTree_Live"."Version", CASE WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."URLSegment" ELSE "SiteTree_Live"."URLSegment" END AS "URLSegment", CASE WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."Title" ELSE "SiteTree_Live"."Title" END AS "Title", CASE WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."MenuTitle" ELSE "SiteTree_Live"."MenuTitle" END AS "MenuTitle", CASE WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."Content" ELSE "SiteTree_Live"."Content" END AS "Content", CASE WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."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_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."ReportClass" ELSE "SiteTree_Live"."ReportClass" END AS "ReportClass", "SiteTree_Live"."CanonicalLinkID", "SiteTree_Live"."FBImageID", "SiteTree_Live"."TwImageID", "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_GB' AS "Locale", CASE WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN 'en_GB' ELSE NULL END AS "SourceLocale" FROM "SiteTree_Live" LEFT JOIN "SiteTree_Localised_Live" AS "SiteTree_Localised_en_GB" ON "SiteTree_Live"."ID" = "SiteTree_Localised_en_GB"."RecordID" AND "SiteTree_Localised_en_GB"."Locale" = ? WHERE ("SiteTree_Live"."ID" = ?) AND (("SiteTree_Localised_en_GB"."ID" IS NOT NULL)) ORDER BY "SiteTree_Live"."Sort" ASC LIMIT 1 0.0001s

Magical Schnoor

Stadtfuehrung Bremen Fuehrung Schnoor Bremen

Price per group:
1-25 persons: € 150.00
For guided tours in English, an additional fee of € 30.00 per group will be added.
VAT included
Price for larger groups on request – Duration: 1 hour
Dates and meeting place by arrangement

The Schnoor is Bremen's oldest, smallest and somewhat enchanted quarter. In its narrow streets, between tiny, crooked houses, you can stroll comfortably. Behind the facades are stories from everyday life in Bremen and from past centuries. With small stores full of curiosities and with quaint cafés and restaurants, the Schnoor quarter invites you to linger. Take a journey into the past and be surprised by the narrowest alley of Bremen, curious figures as well as the smallest house in the city and much more.

During the walk through the Schnoor quarter you will get to know the old Bremen. First testimonies prove the construction of a Franciscan monastery at this place in the 13th century. Later, rope makers and fishermen made their living here for many generations.

The Schnoor is full of stories

In the Schnoor quarter you will discover the so called "Katzengang", Bremen's narrowest alley with a width of only about 50 cm. You will learn who once lived and worked here and why the Schnoor inhabitants had to pay a toilet fee as early as the Middle Ages. Also say hello to Heini Holtenbeen (a monument), a popular, somewhat cranky Bremen original whose sayings are still told today.

Today, the Schnoor quarter is a popular tourist attraction. You will discover oddities, and handmade items, jewelry, art and souvenirs in tiny stores with low ceilings. In the Christmas House you will find not only festive decorations, but also a relic of the medieval city wall.

Price per group:
1-25 persons: € 150.00
For guided tours in English, an additional fee of € 30.00 per group will be added.
VAT included
Price for larger groups on request

Dates and meeting place by arrangement

direct contacting