0001: SET sql_mode = ? 0.0004s

0002: SHOW DATABASES LIKE 'd02da932' 0.0008s

0003: SHOW FULL TABLES WHERE Table_Type != 'VIEW' 0.0014s

0004: SHOW FULL FIELDS IN "Fluent_Locale" 0.0006s

0005: SHOW COLLATION LIKE 'utf8mb3_general_ci' 0.0002s

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

0007: SHOW FULL FIELDS IN "Fluent_Domain" 0.0006s

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

Guided city tours in Bremen
with Stadtgeschichten Bremen

• Guided Tours
• About us
• Contact
• Cooperation partners
• Newsletter
• DE

Sightseeing tour (with a tour bus)

Price per tour or per bus: € 290.00
For guided tours in English, an additional fee of € 30.00 per group will be added.
VAT included
It is necessary that you bring your own coach with a driver or rent one in Bremen.
– Duration: 2 hours (shorter on request)
Dates and meeting place by arrangement

We will gladly join you in your coach and you will experience Bremen comfortably seated. Discover the diversity of the city in different districts.

The tour takes you, among other things, along the Osterdeich, through the district of Schwachhausen with its beautiful Art Nouveau villas, along the Rhododendron Park, through the Technology Park and past the University, along the Bürgerpark, through the most colorful district of Bremen - the "Viertel" (Ostertorviertel), and through the Überseestadt. During the ride you will hear interesting and entertaining stories from and about Bremen and smile about some anecdotes.

If you wish, we can make a short stop with drop-off in the Rhododendron Park or in the Überseestadt in Schuppen Eins with the Center for Automobile Culture (if it is within the opening hours). Depending on the interest of the group, the route can also be varied and, for example, the port area can be "experienced" in more detail.

Note: For this tour it is necessary that you bring your own coach with a driver. If you do not have your own coach, you can rent one on site. We will be happy to help you with the organization.

Important note: Due to the traffic situation in Bremen, this sightseeing tour is only possible in the morning, at noon, in the evening or on weekends.

Price per tour or per bus: € 290.00 
For guided tours in English, an additional fee of € 30.00 per group will be added.
VAT included

Dates and meeting places by arrangement

direct contacting