0001: SET sql_mode = ? 0.0003s

0002: SHOW DATABASES LIKE 'd042578d' 0.0007s

0003: SELECT DISTINCT "Fluent_Domain"."ClassName", "Fluent_Domain"."LastEdited", "Fluent_Domain"."Created", "Fluent_Domain"."Domain", "Fluent_Domain"."DefaultLocaleID", "Fluent_Domain"."ID", CASE WHEN "Fluent_Domain"."ClassName" IS NOT NULL THEN "Fluent_Domain"."ClassName" ELSE 'TractorCow\\Fluent\\Model\\Domain' END AS "RecordClassName" FROM "Fluent_Domain" 0.0001s

0004: SELECT DISTINCT "Fluent_Locale"."ClassName", "Fluent_Locale"."LastEdited", "Fluent_Locale"."Created", "Fluent_Locale"."Title", "Fluent_Locale"."Locale", "Fluent_Locale"."URLSegment", "Fluent_Locale"."IsGlobalDefault", "Fluent_Locale"."UseDefaultCode", "Fluent_Locale"."Sort", "Fluent_Locale"."Timezone", "Fluent_Locale"."DomainID", "Fluent_Locale"."ID", CASE WHEN "Fluent_Locale"."ClassName" IS NOT NULL THEN "Fluent_Locale"."ClassName" ELSE 'TractorCow\\Fluent\\Model\\Locale' END AS "RecordClassName" FROM "Fluent_Locale" ORDER BY "Fluent_Locale"."Sort" ASC, "Fluent_Locale"."Locale" ASC 0.0001s

0005: SELECT DISTINCT "Fluent_FallbackLocale"."ClassName", "Fluent_FallbackLocale"."LastEdited", "Fluent_FallbackLocale"."Created", "Fluent_FallbackLocale"."Sort", "Fluent_FallbackLocale"."ParentID", "Fluent_FallbackLocale"."LocaleID", "Fluent_FallbackLocale"."ID", CASE WHEN "Fluent_FallbackLocale"."ClassName" IS NOT NULL THEN "Fluent_FallbackLocale"."ClassName" ELSE 'TractorCow\\Fluent\\Model\\FallbackLocale' END AS "RecordClassName" FROM "Fluent_FallbackLocale" WHERE ("Fluent_FallbackLocale"."ParentID" = ?) ORDER BY "Fluent_FallbackLocale"."Sort" ASC 0.0002s

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

0007: SELECT DISTINCT "SiteConfig"."ClassName", "SiteConfig"."LastEdited", "SiteConfig"."Created", CASE WHEN "SiteConfig_Localised_de_DE"."ID" IS NOT NULL THEN "SiteConfig_Localised_de_DE"."MapsBrowserKey" ELSE "SiteConfig"."MapsBrowserKey" END AS "MapsBrowserKey", CASE WHEN "SiteConfig_Localised_de_DE"."ID" IS NOT NULL THEN "SiteConfig_Localised_de_DE"."MapsServerKey" ELSE "SiteConfig"."MapsServerKey" END AS "MapsServerKey", "SiteConfig"."UseDefaultCMSImage", CASE WHEN "SiteConfig_Localised_de_DE"."ID" IS NOT NULL THEN "SiteConfig_Localised_de_DE"."LoginHeroHash" ELSE "SiteConfig"."LoginHeroHash" END AS "LoginHeroHash", CASE WHEN "SiteConfig_Localised_de_DE"."ID" IS NOT NULL THEN "SiteConfig_Localised_de_DE"."DefaultImageAllowedTag" ELSE "SiteConfig"."DefaultImageAllowedTag" END AS "DefaultImageAllowedTag", CASE WHEN "SiteConfig_Localised_de_DE"."ID" IS NOT NULL THEN "SiteConfig_Localised_de_DE"."DefaultImageDisallowedTag" ELSE "SiteConfig"."DefaultImageDisallowedTag" END AS "DefaultImageDisallowedTag", CASE WHEN "SiteConfig_Localised_de_DE"."ID" IS NOT NULL THEN "SiteConfig_Localised_de_DE"."CookieConsentNotice" ELSE "SiteConfig"."CookieConsentNotice" END AS "CookieConsentNotice", CASE WHEN "SiteConfig_Localised_de_DE"."ID" IS NOT NULL THEN "SiteConfig_Localised_de_DE"."CookieBtnOk" ELSE "SiteConfig"."CookieBtnOk" END AS "CookieBtnOk", CASE WHEN "SiteConfig_Localised_de_DE"."ID" IS NOT NULL THEN "SiteConfig_Localised_de_DE"."CookieChooseText" ELSE "SiteConfig"."CookieChooseText" END AS "CookieChooseText", CASE WHEN "SiteConfig_Localised_de_DE"."ID" IS NOT NULL THEN "SiteConfig_Localised_de_DE"."CookieBtnDislike" ELSE "SiteConfig"."CookieBtnDislike" END AS "CookieBtnDislike", CASE WHEN "SiteConfig_Localised_de_DE"."ID" IS NOT NULL THEN "SiteConfig_Localised_de_DE"."CookieAllowGMaps" ELSE "SiteConfig"."CookieAllowGMaps" END AS "CookieAllowGMaps", CASE WHEN "SiteConfig_Localised_de_DE"."ID" IS NOT NULL THEN "SiteConfig_Localised_de_DE"."CookieTextUnderBtn" ELSE "SiteConfig"."CookieTextUnderBtn" END AS "CookieTextUnderBtn", CASE WHEN "SiteConfig_Localised_de_DE"."ID" IS NOT NULL THEN "SiteConfig_Localised_de_DE"."CookieAllowYouTube" ELSE "SiteConfig"."CookieAllowYouTube" END AS "CookieAllowYouTube", CASE WHEN "SiteConfig_Localised_de_DE"."ID" IS NOT NULL THEN "SiteConfig_Localised_de_DE"."CookieConsentPopUpHeadline" ELSE "SiteConfig"."CookieConsentPopUpHeadline" END AS "CookieConsentPopUpHeadline", CASE WHEN "SiteConfig_Localised_de_DE"."ID" IS NOT NULL THEN "SiteConfig_Localised_de_DE"."CookieConsentPopUpNotice" ELSE "SiteConfig"."CookieConsentPopUpNotice" END AS "CookieConsentPopUpNotice", CASE WHEN "SiteConfig_Localised_de_DE"."ID" IS NOT NULL THEN "SiteConfig_Localised_de_DE"."CookieConsentPopUpDisallow" ELSE "SiteConfig"."CookieConsentPopUpDisallow" END AS "CookieConsentPopUpDisallow", CASE WHEN "SiteConfig_Localised_de_DE"."ID" IS NOT NULL THEN "SiteConfig_Localised_de_DE"."CookieConsentPopUpAllowAll" ELSE "SiteConfig"."CookieConsentPopUpAllowAll" END AS "CookieConsentPopUpAllowAll", CASE WHEN "SiteConfig_Localised_de_DE"."ID" IS NOT NULL THEN "SiteConfig_Localised_de_DE"."CookieConsentPopUpAllowSelected" ELSE "SiteConfig"."CookieConsentPopUpAllowSelected" END AS "CookieConsentPopUpAllowSelected", CASE WHEN "SiteConfig_Localised_de_DE"."ID" IS NOT NULL THEN "SiteConfig_Localised_de_DE"."CookiePrivacyPolicyTitle" ELSE "SiteConfig"."CookiePrivacyPolicyTitle" END AS "CookiePrivacyPolicyTitle", CASE WHEN "SiteConfig_Localised_de_DE"."ID" IS NOT NULL THEN "SiteConfig_Localised_de_DE"."CookiePrivacyPolicyText" ELSE "SiteConfig"."CookiePrivacyPolicyText" END AS "CookiePrivacyPolicyText", CASE WHEN "SiteConfig_Localised_de_DE"."ID" IS NOT NULL THEN "SiteConfig_Localised_de_DE"."Title" ELSE "SiteConfig"."Title" END AS "Title", CASE WHEN "SiteConfig_Localised_de_DE"."ID" IS NOT NULL THEN "SiteConfig_Localised_de_DE"."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", 'de_DE' AS "Locale", CASE WHEN "SiteConfig_Localised_de_DE"."ID" IS NOT NULL THEN 'de_DE' ELSE NULL END AS "SourceLocale" FROM "SiteConfig" LEFT JOIN "SiteConfig_Localised" AS "SiteConfig_Localised_de_DE" ON "SiteConfig"."ID" = "SiteConfig_Localised_de_DE"."RecordID" AND "SiteConfig_Localised_de_DE"."Locale" = ? LIMIT 1 0.0005s

0008: SELECT CASE WHEN EXISTS(SELECT * FROM "MenuSet" WHERE ("MenuSet"."Name" = ?)) THEN 1 ELSE 0 END 0.0002s

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

0010: 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.0001s

0011: SELECT DISTINCT "MenuItem"."ClassName", "MenuItem"."LastEdited", "MenuItem"."Created", "MenuItem"."MenuTitle", "MenuItem"."Link", "MenuItem"."Sort", "MenuItem"."IsNewWindow", "MenuItem"."Anchor", "MenuItem"."PageID", "MenuItem"."MenuSetID", "MenuItem"."FileID", "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.0002s

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

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

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

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

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

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

0018: SELECT "Version" FROM "SiteTree" WHERE "ID" = ? 0.0002s

0019: SELECT "BaseTable"."RecordID", MAX("SiteTree_Localised_Versions"."Version") as "LatestVersion" FROM "SiteTree_Localised" AS "BaseTable" INNER JOIN "SiteTree_Localised_Versions" ON "BaseTable"."RecordID" = "SiteTree_Localised_Versions"."RecordID" AND "SiteTree_Localised_Versions"."Locale" = ? INNER JOIN "SiteTree_Versions" ON "SiteTree_Versions"."RecordID" = "SiteTree_Localised_Versions"."RecordID" AND "SiteTree_Versions"."Version" = "SiteTree_Localised_Versions"."Version" WHERE "BaseTable"."Locale" = ? AND "BaseTable"."RecordID" IN (?) GROUP BY "BaseTable"."RecordID" 0.0002s

0020: SELECT "ID" FROM "SiteTree_Localised_Live" WHERE ("RecordID" = ?) AND ("Locale" = ?) LIMIT 1 0.0002s

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

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

0023: SELECT DISTINCT "SiteTree"."ClassName", "SiteTree"."LastEdited", "SiteTree"."Created", CASE WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."BetterSiteTitle" ELSE "SiteTree"."BetterSiteTitle" END AS "BetterSiteTitle", CASE WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."Keyword" ELSE "SiteTree"."Keyword" END AS "Keyword", CASE WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."FeaturedKeyword" ELSE "SiteTree"."FeaturedKeyword" END AS "FeaturedKeyword", CASE WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."KeywordQuestion" ELSE "SiteTree"."KeywordQuestion" END AS "KeywordQuestion", "SiteTree"."Follow", "SiteTree"."FollowType", CASE WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."GenMetaDesc" ELSE "SiteTree"."GenMetaDesc" END AS "GenMetaDesc", CASE WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."FBTitle" ELSE "SiteTree"."FBTitle" END AS "FBTitle", CASE WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."FBDescription" ELSE "SiteTree"."FBDescription" END AS "FBDescription", "SiteTree"."FBType", "SiteTree"."FBTypeOverride", CASE WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."TwTitle" ELSE "SiteTree"."TwTitle" END AS "TwTitle", CASE WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."TwDescription" ELSE "SiteTree"."TwDescription" END AS "TwDescription", "SiteTree"."CanViewType", "SiteTree"."CanEditType", "SiteTree"."Version", CASE WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."URLSegment" ELSE "SiteTree"."URLSegment" END AS "URLSegment", CASE WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."Title" ELSE "SiteTree"."Title" END AS "Title", CASE WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."MenuTitle" ELSE "SiteTree"."MenuTitle" END AS "MenuTitle", CASE WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."Content" ELSE "SiteTree"."Content" END AS "Content", CASE WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."MetaDescription" ELSE "SiteTree"."MetaDescription" END AS "MetaDescription", "SiteTree"."ExtraMeta", "SiteTree"."ShowInMenus", "SiteTree"."ShowInSearch", "SiteTree"."Sort", "SiteTree"."HasBrokenFile", "SiteTree"."HasBrokenLink", CASE WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."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", 'de_DE' AS "Locale", CASE WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN 'de_DE' ELSE NULL END AS "SourceLocale" FROM "SiteTree" LEFT JOIN "SiteTree_Localised" AS "SiteTree_Localised_de_DE" ON "SiteTree"."ID" = "SiteTree_Localised_de_DE"."RecordID" AND "SiteTree_Localised_de_DE"."Locale" = ? WHERE ("SiteTree"."ID" = ?) AND (("SiteTree_Localised_de_DE"."ID" IS NOT NULL)) ORDER BY "SiteTree"."Sort" ASC LIMIT 1 0.0005s

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