0001: SET sql_mode = ? 0.0001s
0002: SET SESSION time_zone = ? 0.0001s
0003: SHOW DATABASES LIKE 'ss\_carasana26\_web\_production' 0.0006s
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.0002s
0005: 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
0006: SELECT 'CASE' = 'case' 0.0001s
0007: SELECT "Locale" FROM "SubsiteDomain" WHERE ? LIKE replace("Domain", '*', '%') AND "Locale" <> '' ORDER BY "IsPrimary" DESC LIMIT 1 0.0002s
0008: SELECT DISTINCT "Fluent_Locale"."ClassName", "Fluent_Locale"."LastEdited", "Fluent_Locale"."Created", "Fluent_Locale"."Title", "Fluent_Locale"."Locale", "Fluent_Locale"."URLSegment", "Fluent_Locale"."IsGlobalDefault", "Fluent_Locale"."UseDefaultCode", "Fluent_Locale"."Sort", "Fluent_Locale"."Timezone", "Fluent_Locale"."DomainID", "Fluent_Locale"."ID", CASE WHEN "Fluent_Locale"."ClassName" IS NOT NULL THEN "Fluent_Locale"."ClassName" ELSE 'TractorCow\\Fluent\\Model\\Locale' END AS "RecordClassName" FROM "Fluent_Locale" WHERE ("Fluent_Locale"."Locale" = ?) ORDER BY "Fluent_Locale"."Sort" ASC, "Fluent_Locale"."Locale" ASC LIMIT 1 0.0002s
0009: SELECT DISTINCT count(DISTINCT "SubsiteDomain"."ID") AS "Count" FROM "SubsiteDomain" INNER JOIN "Subsite" ON "Subsite"."ID" = "SubsiteDomain"."SubsiteID" AND "Subsite"."IsPublic"=1 WHERE ('caracalla.eu' LIKE replace("SubsiteDomain"."Domain",'*','%')) 0.0002s
0010: SELECT "SubsiteDomain"."SubsiteID", "SubsiteDomain"."IsPrimary" AS "_SortColumn0" FROM "SubsiteDomain" INNER JOIN "Subsite" ON "Subsite"."ID" = "SubsiteDomain"."SubsiteID" AND "Subsite"."IsPublic"=1 WHERE ('caracalla.eu' LIKE replace("SubsiteDomain"."Domain",'*','%')) ORDER BY "_SortColumn0" DESC 0.0002s
0011: SELECT "SubsiteDomain"."Domain", "SubsiteDomain"."IsPrimary" AS "_SortColumn0" FROM "SubsiteDomain" INNER JOIN "Subsite" ON "Subsite"."ID" = "SubsiteDomain"."SubsiteID" AND "Subsite"."IsPublic"=1 WHERE ('caracalla.eu' LIKE replace("SubsiteDomain"."Domain",'*','%')) ORDER BY "_SortColumn0" DESC 0.0002s
0012: SELECT DISTINCT "Fluent_Locale"."ClassName", "Fluent_Locale"."LastEdited", "Fluent_Locale"."Created", "Fluent_Locale"."Title", "Fluent_Locale"."Locale", "Fluent_Locale"."URLSegment", "Fluent_Locale"."IsGlobalDefault", "Fluent_Locale"."UseDefaultCode", "Fluent_Locale"."Sort", "Fluent_Locale"."Timezone", "Fluent_Locale"."DomainID", "Fluent_Locale"."ID", CASE WHEN "Fluent_Locale"."ClassName" IS NOT NULL THEN "Fluent_Locale"."ClassName" ELSE 'TractorCow\\Fluent\\Model\\Locale' END AS "RecordClassName" FROM "Fluent_Locale" WHERE ("Fluent_Locale"."Locale" = ?) ORDER BY "Fluent_Locale"."Sort" ASC, "Fluent_Locale"."Locale" ASC LIMIT 1 0.0002s
0013: SHOW FULL FIELDS IN "SiteTree" 0.0008s
0014: SHOW COLLATION LIKE 'utf8mb4_unicode_ci' 0.0004s
0015: SHOW FULL FIELDS IN "Page" 0.0007s
0016: SHOW FULL FIELDS IN "AlternativeLandingPage" 0.0005s
0017: SHOW FULL FIELDS IN "ApplicationFormPage" 0.0006s
0018: SHOW FULL FIELDS IN "ContactPage" 0.0005s
0019: SHOW FULL FIELDS IN "ElementalPage" 0.0005s
0020: SHOW FULL FIELDS IN "HomePage" 0.0005s
0021: SHOW FULL FIELDS IN "VIPChipRegistrationPage" 0.0006s
0022: SHOW FULL FIELDS IN "ErrorPage" 0.0005s
0023: SHOW FULL FIELDS IN "JobsPage" 0.0006s
0024: SHOW COLLATION LIKE 'utf8mb3_general_ci' 0.0003s
0025: SHOW FULL FIELDS IN "Tietge_SocialWall_SocialPage" 0.0005s
0026: SHOW FULL FIELDS IN "TeamPage" 0.0005s
0027: SHOW FULL FIELDS IN "Blog" 0.0005s
0028: SHOW FULL FIELDS IN "BlogPost" 0.0005s
0029: SHOW FULL FIELDS IN "RedirectorPage" 0.0005s
0030: SHOW FULL FIELDS IN "VirtualPage" 0.0005s
0031: SHOW FULL FIELDS IN "UserDefinedForm" 0.0005s
0032: SHOW FULL FIELDS IN "EventPage" 0.0006s
0033: SHOW FULL FIELDS IN "EventsPage" 0.0005s
0034: 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
0035: SELECT DISTINCT "Fluent_Locale"."ClassName", "Fluent_Locale"."LastEdited", "Fluent_Locale"."Created", "Fluent_Locale"."Title", "Fluent_Locale"."Locale", "Fluent_Locale"."URLSegment", "Fluent_Locale"."IsGlobalDefault", "Fluent_Locale"."UseDefaultCode", "Fluent_Locale"."Sort", "Fluent_Locale"."Timezone", "Fluent_Locale"."DomainID", "Fluent_Locale"."ID", CASE WHEN "Fluent_Locale"."ClassName" IS NOT NULL THEN "Fluent_Locale"."ClassName" ELSE 'TractorCow\\Fluent\\Model\\Locale' END AS "RecordClassName" FROM "Fluent_Locale" WHERE ("Fluent_Locale"."ID" = ?) ORDER BY "Fluent_Locale"."Sort" ASC, "Fluent_Locale"."Locale" ASC LIMIT 1 0.0002s
0036: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", "SiteTree_Live"."CanViewType", "SiteTree_Live"."CanEditType", "SiteTree_Live"."Version", CASE WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."Title" 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_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."URLSegment" 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_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."MenuTitle" 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_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."Content" 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_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."MetaDescription" 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_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."ReportClass" WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."ReportClass" ELSE "SiteTree_Live"."ReportClass" END AS "ReportClass", "SiteTree_Live"."SubsiteID", "SiteTree_Live"."ParentID", "SiteTree_Live"."ID", CASE WHEN "SiteTree_Live"."ClassName" IS NOT NULL THEN "SiteTree_Live"."ClassName" ELSE 'SilverStripe\\CMS\\Model\\SiteTree' END AS "RecordClassName", 'en_US' AS "Locale", CASE WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN 'en_US' 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_en_US" ON "SiteTree_Live"."ID" = "SiteTree_Localised_en_US"."RecordID" AND "SiteTree_Localised_en_US"."Locale" = ? LEFT JOIN "SiteTree_Localised_Live" AS "SiteTree_Localised_de_DE" ON "SiteTree_Live"."ID" = "SiteTree_Localised_de_DE"."RecordID" AND "SiteTree_Localised_de_DE"."Locale" = ? WHERE (COALESCE("SiteTree_Localised_en_US"."URLSegment", "SiteTree_Localised_de_DE"."URLSegment", "SiteTree_Live"."URLSegment") = ?) AND ("SiteTree_Live"."SubsiteID" IN (2)) AND (("SiteTree_Localised_en_US"."ID" IS NOT NULL) OR ("SiteTree_Localised_de_DE"."ID" IS NOT NULL)) ORDER BY "SiteTree_Live"."Sort" ASC LIMIT 1 0.0009s
0037: SELECT DISTINCT "Subsite"."ClassName", "Subsite"."LastEdited", "Subsite"."Created", "Subsite"."Sort", "Subsite"."HomeBusinessSchemaType", "Subsite"."Title", "Subsite"."RedirectURL", "Subsite"."DefaultSite", "Subsite"."Theme", "Subsite"."Language", "Subsite"."IsPublic", "Subsite"."PageTypeBlacklist", "Subsite"."ID", CASE WHEN "Subsite"."ClassName" IS NOT NULL THEN "Subsite"."ClassName" ELSE 'SilverStripe\\Subsites\\Model\\Subsite' END AS "RecordClassName" FROM "Subsite" WHERE ("Subsite"."ID" = ?) ORDER BY "Subsite"."Title" ASC LIMIT 1 0.0002s
0038: SELECT DISTINCT "SiteConfig"."ClassName", "SiteConfig"."LastEdited", "SiteConfig"."Created", "SiteConfig"."OGApplicationID", "SiteConfig"."OGAdminID", "SiteConfig"."RobotsMode", "SiteConfig"."RobotsContent", CASE WHEN "SiteConfig_Localised_en_US"."ID" IS NOT NULL THEN "SiteConfig_Localised_en_US"."TrackingCode" WHEN "SiteConfig_Localised_de_DE"."ID" IS NOT NULL THEN "SiteConfig_Localised_de_DE"."TrackingCode" ELSE "SiteConfig"."TrackingCode" END AS "TrackingCode", "SiteConfig"."CookieConsentCode", "SiteConfig"."SocialWallNotifyEmails", "SiteConfig"."SocialWallNotifySignature", "SiteConfig"."SocialWallNotifyLastSent", CASE WHEN "SiteConfig_Localised_en_US"."ID" IS NOT NULL THEN "SiteConfig_Localised_en_US"."FormularDatenschutztext" WHEN "SiteConfig_Localised_de_DE"."ID" IS NOT NULL THEN "SiteConfig_Localised_de_DE"."FormularDatenschutztext" ELSE "SiteConfig"."FormularDatenschutztext" END AS "FormularDatenschutztext", CASE WHEN "SiteConfig_Localised_en_US"."ID" IS NOT NULL THEN "SiteConfig_Localised_en_US"."ExtraCSS" WHEN "SiteConfig_Localised_de_DE"."ID" IS NOT NULL THEN "SiteConfig_Localised_de_DE"."ExtraCSS" ELSE "SiteConfig"."ExtraCSS" END AS "ExtraCSS", "SiteConfig"."bingAPIKey", CASE WHEN "SiteConfig_Localised_en_US"."ID" IS NOT NULL THEN "SiteConfig_Localised_en_US"."FooterFirstMenuTitle" WHEN "SiteConfig_Localised_de_DE"."ID" IS NOT NULL THEN "SiteConfig_Localised_de_DE"."FooterFirstMenuTitle" ELSE "SiteConfig"."FooterFirstMenuTitle" END AS "FooterFirstMenuTitle", CASE WHEN "SiteConfig_Localised_en_US"."ID" IS NOT NULL THEN "SiteConfig_Localised_en_US"."FooterSecondMenuTitle" WHEN "SiteConfig_Localised_de_DE"."ID" IS NOT NULL THEN "SiteConfig_Localised_de_DE"."FooterSecondMenuTitle" ELSE "SiteConfig"."FooterSecondMenuTitle" END AS "FooterSecondMenuTitle", CASE WHEN "SiteConfig_Localised_en_US"."ID" IS NOT NULL THEN "SiteConfig_Localised_en_US"."FooterThirdMenuTitle" WHEN "SiteConfig_Localised_de_DE"."ID" IS NOT NULL THEN "SiteConfig_Localised_de_DE"."FooterThirdMenuTitle" ELSE "SiteConfig"."FooterThirdMenuTitle" END AS "FooterThirdMenuTitle", CASE WHEN "SiteConfig_Localised_en_US"."ID" IS NOT NULL THEN "SiteConfig_Localised_en_US"."FooterFourthMenuTitle" WHEN "SiteConfig_Localised_de_DE"."ID" IS NOT NULL THEN "SiteConfig_Localised_de_DE"."FooterFourthMenuTitle" ELSE "SiteConfig"."FooterFourthMenuTitle" END AS "FooterFourthMenuTitle", CASE WHEN "SiteConfig_Localised_en_US"."ID" IS NOT NULL THEN "SiteConfig_Localised_en_US"."ContactEmail" WHEN "SiteConfig_Localised_de_DE"."ID" IS NOT NULL THEN "SiteConfig_Localised_de_DE"."ContactEmail" ELSE "SiteConfig"."ContactEmail" END AS "ContactEmail", CASE WHEN "SiteConfig_Localised_en_US"."ID" IS NOT NULL THEN "SiteConfig_Localised_en_US"."ContactPhone" WHEN "SiteConfig_Localised_de_DE"."ID" IS NOT NULL THEN "SiteConfig_Localised_de_DE"."ContactPhone" ELSE "SiteConfig"."ContactPhone" END AS "ContactPhone", CASE WHEN "SiteConfig_Localised_en_US"."ID" IS NOT NULL THEN "SiteConfig_Localised_en_US"."BusinessAddress" WHEN "SiteConfig_Localised_de_DE"."ID" IS NOT NULL THEN "SiteConfig_Localised_de_DE"."BusinessAddress" ELSE "SiteConfig"."BusinessAddress" END AS "BusinessAddress", CASE WHEN "SiteConfig_Localised_en_US"."ID" IS NOT NULL THEN "SiteConfig_Localised_en_US"."BusinessPostalCode" WHEN "SiteConfig_Localised_de_DE"."ID" IS NOT NULL THEN "SiteConfig_Localised_de_DE"."BusinessPostalCode" ELSE "SiteConfig"."BusinessPostalCode" END AS "BusinessPostalCode", CASE WHEN "SiteConfig_Localised_en_US"."ID" IS NOT NULL THEN "SiteConfig_Localised_en_US"."BusinessAddressLocality" WHEN "SiteConfig_Localised_de_DE"."ID" IS NOT NULL THEN "SiteConfig_Localised_de_DE"."BusinessAddressLocality" ELSE "SiteConfig"."BusinessAddressLocality" END AS "BusinessAddressLocality", CASE WHEN "SiteConfig_Localised_en_US"."ID" IS NOT NULL THEN "SiteConfig_Localised_en_US"."BusinessAddressCountry" WHEN "SiteConfig_Localised_de_DE"."ID" IS NOT NULL THEN "SiteConfig_Localised_de_DE"."BusinessAddressCountry" ELSE "SiteConfig"."BusinessAddressCountry" END AS "BusinessAddressCountry", "SiteConfig"."HomeBusinessSchemaType", "SiteConfig"."BusinessOpeningHours", CASE WHEN "SiteConfig_Localised_en_US"."ID" IS NOT NULL THEN "SiteConfig_Localised_en_US"."Copyright" WHEN "SiteConfig_Localised_de_DE"."ID" IS NOT NULL THEN "SiteConfig_Localised_de_DE"."Copyright" ELSE "SiteConfig"."Copyright" END AS "Copyright", CASE WHEN "SiteConfig_Localised_en_US"."ID" IS NOT NULL THEN "SiteConfig_Localised_en_US"."JobAlertTitle" WHEN "SiteConfig_Localised_de_DE"."ID" IS NOT NULL THEN "SiteConfig_Localised_de_DE"."JobAlertTitle" ELSE "SiteConfig"."JobAlertTitle" END AS "JobAlertTitle", CASE WHEN "SiteConfig_Localised_en_US"."ID" IS NOT NULL THEN "SiteConfig_Localised_en_US"."JobAlertSubTitle" WHEN "SiteConfig_Localised_de_DE"."ID" IS NOT NULL THEN "SiteConfig_Localised_de_DE"."JobAlertSubTitle" ELSE "SiteConfig"."JobAlertSubTitle" END AS "JobAlertSubTitle", CASE WHEN "SiteConfig_Localised_en_US"."ID" IS NOT NULL THEN "SiteConfig_Localised_en_US"."JobAlertContent" WHEN "SiteConfig_Localised_de_DE"."ID" IS NOT NULL THEN "SiteConfig_Localised_de_DE"."JobAlertContent" ELSE "SiteConfig"."JobAlertContent" END AS "JobAlertContent", "SiteConfig"."JobDefaultRecipient", CASE WHEN "SiteConfig_Localised_en_US"."ID" IS NOT NULL THEN "SiteConfig_Localised_en_US"."ApplyFormReply" WHEN "SiteConfig_Localised_de_DE"."ID" IS NOT NULL THEN "SiteConfig_Localised_de_DE"."ApplyFormReply" ELSE "SiteConfig"."ApplyFormReply" END AS "ApplyFormReply", "SiteConfig"."ShowInFrontend", "SiteConfig"."PrimaryColor", "SiteConfig"."PrimaryColorLighter", "SiteConfig"."SecondaryColor", "SiteConfig"."SecondaryColorLighter", "SiteConfig"."TertiaryColor", "SiteConfig"."MenuActiveColor", "SiteConfig"."SideBarColor", "SiteConfig"."SideBarColorHover", "SiteConfig"."PrimaryButton", "SiteConfig"."PrimaryButtonHover", "SiteConfig"."SecondaryButton", "SiteConfig"."SecondaryButtonHover", "SiteConfig"."TertiaryButton", "SiteConfig"."TertiaryButtonHover", CASE WHEN "SiteConfig_Localised_en_US"."ID" IS NOT NULL THEN "SiteConfig_Localised_en_US"."NewsletterContent" WHEN "SiteConfig_Localised_de_DE"."ID" IS NOT NULL THEN "SiteConfig_Localised_de_DE"."NewsletterContent" ELSE "SiteConfig"."NewsletterContent" END AS "NewsletterContent", CASE WHEN "SiteConfig_Localised_en_US"."ID" IS NOT NULL THEN "SiteConfig_Localised_en_US"."NewsletterButtonCaption" WHEN "SiteConfig_Localised_de_DE"."ID" IS NOT NULL THEN "SiteConfig_Localised_de_DE"."NewsletterButtonCaption" ELSE "SiteConfig"."NewsletterButtonCaption" END AS "NewsletterButtonCaption", CASE WHEN "SiteConfig_Localised_en_US"."ID" IS NOT NULL THEN "SiteConfig_Localised_en_US"."ChatbotCode" WHEN "SiteConfig_Localised_de_DE"."ID" IS NOT NULL THEN "SiteConfig_Localised_de_DE"."ChatbotCode" ELSE "SiteConfig"."ChatbotCode" END AS "ChatbotCode", CASE WHEN "SiteConfig_Localised_en_US"."ID" IS NOT NULL THEN "SiteConfig_Localised_en_US"."LlmsTxtContent" WHEN "SiteConfig_Localised_de_DE"."ID" IS NOT NULL THEN "SiteConfig_Localised_de_DE"."LlmsTxtContent" ELSE "SiteConfig"."LlmsTxtContent" END AS "LlmsTxtContent", CASE WHEN "SiteConfig_Localised_en_US"."ID" IS NOT NULL THEN "SiteConfig_Localised_en_US"."Title" WHEN "SiteConfig_Localised_de_DE"."ID" IS NOT NULL THEN "SiteConfig_Localised_de_DE"."Title" ELSE "SiteConfig"."Title" END AS "Title", "SiteConfig"."Tagline", "SiteConfig"."CanViewType", "SiteConfig"."CanEditType", "SiteConfig"."CanCreateTopLevelType", "SiteConfig"."SubsiteID", "SiteConfig"."DefaultHeaderID", "SiteConfig"."NewsletterLinkedPageID", "SiteConfig"."LogoID", "SiteConfig"."WhiteLogoID", "SiteConfig"."LogoSmallID", "SiteConfig"."ColoredSignetID", "SiteConfig"."FaviconPNGID", "SiteConfig"."FaviconICOID", "SiteConfig"."BusinessSchemaImage1ID", "SiteConfig"."BusinessSchemaImage2ID", "SiteConfig"."BusinessSchemaImage3ID", "SiteConfig"."NewsletterSuccessPageID", "SiteConfig"."NewsletterErrorPageID", "SiteConfig"."ID", CASE WHEN "SiteConfig"."ClassName" IS NOT NULL THEN "SiteConfig"."ClassName" ELSE 'SilverStripe\\SiteConfig\\SiteConfig' END AS "RecordClassName", 'en_US' AS "Locale", CASE WHEN "SiteConfig_Localised_en_US"."ID" IS NOT NULL THEN 'en_US' WHEN "SiteConfig_Localised_de_DE"."ID" IS NOT NULL THEN 'de_DE' ELSE NULL END AS "SourceLocale" FROM "SiteConfig" LEFT JOIN "SiteConfig_Localised" AS "SiteConfig_Localised_en_US" ON "SiteConfig"."ID" = "SiteConfig_Localised_en_US"."RecordID" AND "SiteConfig_Localised_en_US"."Locale" = ? LEFT JOIN "SiteConfig_Localised" AS "SiteConfig_Localised_de_DE" ON "SiteConfig"."ID" = "SiteConfig_Localised_de_DE"."RecordID" AND "SiteConfig_Localised_de_DE"."Locale" = ? WHERE ("SubsiteID" = 2) LIMIT 1 0.001s
0039: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", CASE WHEN "SiteTree_Live"."ClassName" IN ('SilverStripe\\CMS\\Model\\SiteTree', 'Page', 'AlternativeLandingPage', 'ApplicationFormPage', 'ContactPage', 'ElementalPage', 'HomePage', 'VIPChipRegistrationPage', 'MoritzSauer\\EventCalendar\\EventCalendarPage', 'SilverStripe\\ErrorPage\\ErrorPage', 'Job\\JobsPage', 'Tietge\\SocialWall\\SocialPage', 'Team\\Pages\\TeamPage', 'SilverStripe\\Blog\\Model\\Blog', 'SilverStripe\\Blog\\Model\\BlogPost', 'SilverStripe\\CMS\\Model\\RedirectorPage', 'SilverStripe\\CMS\\Model\\VirtualPage', 'SilverStripe\\UserForms\\Model\\UserDefinedForm', 'XD\\Events\\Model\\EventPage', 'XD\\Events\\Model\\EventsPage', 'SilverStripe\\Subsites\\Pages\\SubsitesVirtualPage') THEN "SiteTree_Live"."Content" WHEN "SiteTree_Live"."ClassName" IN ('Page', 'AlternativeLandingPage', 'ApplicationFormPage', 'ContactPage', 'ElementalPage', 'HomePage', 'VIPChipRegistrationPage', 'MoritzSauer\\EventCalendar\\EventCalendarPage', 'SilverStripe\\ErrorPage\\ErrorPage', 'Job\\JobsPage', 'Tietge\\SocialWall\\SocialPage', 'Team\\Pages\\TeamPage', 'SilverStripe\\Blog\\Model\\Blog', 'SilverStripe\\Blog\\Model\\BlogPost', 'SilverStripe\\CMS\\Model\\RedirectorPage', 'SilverStripe\\CMS\\Model\\VirtualPage', 'SilverStripe\\UserForms\\Model\\UserDefinedForm', 'XD\\Events\\Model\\EventPage', 'XD\\Events\\Model\\EventsPage', 'SilverStripe\\Subsites\\Pages\\SubsitesVirtualPage') THEN "Page_Live"."Content" WHEN "SiteTree_Live"."ClassName" IN ('Page', 'AlternativeLandingPage', 'ApplicationFormPage', 'ContactPage', 'ElementalPage', 'HomePage', 'VIPChipRegistrationPage', 'MoritzSauer\\EventCalendar\\EventCalendarPage', 'SilverStripe\\ErrorPage\\ErrorPage', 'Job\\JobsPage', 'Tietge\\SocialWall\\SocialPage', 'Team\\Pages\\TeamPage', 'SilverStripe\\Blog\\Model\\Blog', 'SilverStripe\\Blog\\Model\\BlogPost', 'SilverStripe\\CMS\\Model\\RedirectorPage', 'SilverStripe\\CMS\\Model\\VirtualPage', 'SilverStripe\\UserForms\\Model\\UserDefinedForm', 'XD\\Events\\Model\\EventPage', 'XD\\Events\\Model\\EventsPage', 'SilverStripe\\Subsites\\Pages\\SubsitesVirtualPage') THEN "Page_Live"."Content" WHEN "SiteTree_Live"."ClassName" IN ('ContactPage') THEN "ContactPage_Live"."Content" ELSE NULL END AS "Content", CASE WHEN "Page_Localised_en_US"."ID" IS NOT NULL THEN "Page_Localised_en_US"."OGTitleCustom" WHEN "Page_Localised_de_DE"."ID" IS NOT NULL THEN "Page_Localised_de_DE"."OGTitleCustom" ELSE "Page_Live"."OGTitleCustom" END AS "OGTitleCustom", CASE WHEN "Page_Localised_en_US"."ID" IS NOT NULL THEN "Page_Localised_en_US"."OGDescriptionCustom" WHEN "Page_Localised_de_DE"."ID" IS NOT NULL THEN "Page_Localised_de_DE"."OGDescriptionCustom" ELSE "Page_Live"."OGDescriptionCustom" END AS "OGDescriptionCustom", CASE WHEN "Page_Localised_en_US"."ID" IS NOT NULL THEN "Page_Localised_en_US"."SubTitle" WHEN "Page_Localised_de_DE"."ID" IS NOT NULL THEN "Page_Localised_de_DE"."SubTitle" ELSE "Page_Live"."SubTitle" END AS "SubTitle", "Page_Live"."ShowInLegalMenu", CASE WHEN "Page_Localised_en_US"."ID" IS NOT NULL THEN "Page_Localised_en_US"."MetaTitle" WHEN "Page_Localised_de_DE"."ID" IS NOT NULL THEN "Page_Localised_de_DE"."MetaTitle" ELSE "Page_Live"."MetaTitle" END AS "MetaTitle", "Page_Live"."ShowInNaviEingeklappt", "Page_Live"."ShowNewsletterInFooter", "Page_Live"."ShowPageHeaderGradient", "Page_Live"."OGImageCustomID", "Page_Live"."PinterestImageCustomID", "Page_Live"."HeaderImageID", "Page_Live"."VideoMP4ID", "Page_Live"."VideoOGVID", "Page_Live"."ImageID", "SiteTree_Live"."ID", CASE WHEN "SiteTree_Live"."ClassName" IS NOT NULL THEN "SiteTree_Live"."ClassName" ELSE 'SilverStripe\\CMS\\Model\\SiteTree' END AS "RecordClassName", 'en_US' AS "Locale", CASE WHEN "Page_Localised_en_US"."ID" IS NOT NULL THEN 'en_US' WHEN "Page_Localised_de_DE"."ID" IS NOT NULL THEN 'de_DE' ELSE NULL END AS "SourceLocale", "SiteTree_Live"."Sort" FROM "SiteTree_Live" LEFT JOIN "Page_Live" ON "Page_Live"."ID" = "SiteTree_Live"."ID" LEFT JOIN "ContactPage_Live" ON "ContactPage_Live"."ID" = "SiteTree_Live"."ID" LEFT JOIN "SiteTree_Localised_Live" AS "SiteTree_Localised_en_US" ON "SiteTree_Live"."ID" = "SiteTree_Localised_en_US"."RecordID" AND "SiteTree_Localised_en_US"."Locale" = ? LEFT JOIN "SiteTree_Localised_Live" AS "SiteTree_Localised_de_DE" ON "SiteTree_Live"."ID" = "SiteTree_Localised_de_DE"."RecordID" AND "SiteTree_Localised_de_DE"."Locale" = ? LEFT JOIN "Page_Localised_Live" AS "Page_Localised_en_US" ON "Page_Live"."ID" = "Page_Localised_en_US"."RecordID" AND "Page_Localised_en_US"."Locale" = ? LEFT JOIN "Page_Localised_Live" AS "Page_Localised_de_DE" ON "Page_Live"."ID" = "Page_Localised_de_DE"."RecordID" AND "Page_Localised_de_DE"."Locale" = ? WHERE ("SiteTree_Live"."ID" = ?) AND ("SiteTree_Live"."ClassName" IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)) AND (("SiteTree_Localised_en_US"."ID" IS NOT NULL) OR ("SiteTree_Localised_de_DE"."ID" IS NOT NULL)) ORDER BY "SiteTree_Live"."Sort" ASC LIMIT 1 0.0005s
0040: SELECT DISTINCT "SiteConfig"."ClassName", "SiteConfig"."LastEdited", "SiteConfig"."Created", "SiteConfig"."OGApplicationID", "SiteConfig"."OGAdminID", "SiteConfig"."RobotsMode", "SiteConfig"."RobotsContent", CASE WHEN "SiteConfig_Localised_en_US"."ID" IS NOT NULL THEN "SiteConfig_Localised_en_US"."TrackingCode" WHEN "SiteConfig_Localised_de_DE"."ID" IS NOT NULL THEN "SiteConfig_Localised_de_DE"."TrackingCode" ELSE "SiteConfig"."TrackingCode" END AS "TrackingCode", "SiteConfig"."CookieConsentCode", "SiteConfig"."SocialWallNotifyEmails", "SiteConfig"."SocialWallNotifySignature", "SiteConfig"."SocialWallNotifyLastSent", CASE WHEN "SiteConfig_Localised_en_US"."ID" IS NOT NULL THEN "SiteConfig_Localised_en_US"."FormularDatenschutztext" WHEN "SiteConfig_Localised_de_DE"."ID" IS NOT NULL THEN "SiteConfig_Localised_de_DE"."FormularDatenschutztext" ELSE "SiteConfig"."FormularDatenschutztext" END AS "FormularDatenschutztext", CASE WHEN "SiteConfig_Localised_en_US"."ID" IS NOT NULL THEN "SiteConfig_Localised_en_US"."ExtraCSS" WHEN "SiteConfig_Localised_de_DE"."ID" IS NOT NULL THEN "SiteConfig_Localised_de_DE"."ExtraCSS" ELSE "SiteConfig"."ExtraCSS" END AS "ExtraCSS", "SiteConfig"."bingAPIKey", CASE WHEN "SiteConfig_Localised_en_US"."ID" IS NOT NULL THEN "SiteConfig_Localised_en_US"."FooterFirstMenuTitle" WHEN "SiteConfig_Localised_de_DE"."ID" IS NOT NULL THEN "SiteConfig_Localised_de_DE"."FooterFirstMenuTitle" ELSE "SiteConfig"."FooterFirstMenuTitle" END AS "FooterFirstMenuTitle", CASE WHEN "SiteConfig_Localised_en_US"."ID" IS NOT NULL THEN "SiteConfig_Localised_en_US"."FooterSecondMenuTitle" WHEN "SiteConfig_Localised_de_DE"."ID" IS NOT NULL THEN "SiteConfig_Localised_de_DE"."FooterSecondMenuTitle" ELSE "SiteConfig"."FooterSecondMenuTitle" END AS "FooterSecondMenuTitle", CASE WHEN "SiteConfig_Localised_en_US"."ID" IS NOT NULL THEN "SiteConfig_Localised_en_US"."FooterThirdMenuTitle" WHEN "SiteConfig_Localised_de_DE"."ID" IS NOT NULL THEN "SiteConfig_Localised_de_DE"."FooterThirdMenuTitle" ELSE "SiteConfig"."FooterThirdMenuTitle" END AS "FooterThirdMenuTitle", CASE WHEN "SiteConfig_Localised_en_US"."ID" IS NOT NULL THEN "SiteConfig_Localised_en_US"."FooterFourthMenuTitle" WHEN "SiteConfig_Localised_de_DE"."ID" IS NOT NULL THEN "SiteConfig_Localised_de_DE"."FooterFourthMenuTitle" ELSE "SiteConfig"."FooterFourthMenuTitle" END AS "FooterFourthMenuTitle", CASE WHEN "SiteConfig_Localised_en_US"."ID" IS NOT NULL THEN "SiteConfig_Localised_en_US"."ContactEmail" WHEN "SiteConfig_Localised_de_DE"."ID" IS NOT NULL THEN "SiteConfig_Localised_de_DE"."ContactEmail" ELSE "SiteConfig"."ContactEmail" END AS "ContactEmail", CASE WHEN "SiteConfig_Localised_en_US"."ID" IS NOT NULL THEN "SiteConfig_Localised_en_US"."ContactPhone" WHEN "SiteConfig_Localised_de_DE"."ID" IS NOT NULL THEN "SiteConfig_Localised_de_DE"."ContactPhone" ELSE "SiteConfig"."ContactPhone" END AS "ContactPhone", CASE WHEN "SiteConfig_Localised_en_US"."ID" IS NOT NULL THEN "SiteConfig_Localised_en_US"."BusinessAddress" WHEN "SiteConfig_Localised_de_DE"."ID" IS NOT NULL THEN "SiteConfig_Localised_de_DE"."BusinessAddress" ELSE "SiteConfig"."BusinessAddress" END AS "BusinessAddress", CASE WHEN "SiteConfig_Localised_en_US"."ID" IS NOT NULL THEN "SiteConfig_Localised_en_US"."BusinessPostalCode" WHEN "SiteConfig_Localised_de_DE"."ID" IS NOT NULL THEN "SiteConfig_Localised_de_DE"."BusinessPostalCode" ELSE "SiteConfig"."BusinessPostalCode" END AS "BusinessPostalCode", CASE WHEN "SiteConfig_Localised_en_US"."ID" IS NOT NULL THEN "SiteConfig_Localised_en_US"."BusinessAddressLocality" WHEN "SiteConfig_Localised_de_DE"."ID" IS NOT NULL THEN "SiteConfig_Localised_de_DE"."BusinessAddressLocality" ELSE "SiteConfig"."BusinessAddressLocality" END AS "BusinessAddressLocality", CASE WHEN "SiteConfig_Localised_en_US"."ID" IS NOT NULL THEN "SiteConfig_Localised_en_US"."BusinessAddressCountry" WHEN "SiteConfig_Localised_de_DE"."ID" IS NOT NULL THEN "SiteConfig_Localised_de_DE"."BusinessAddressCountry" ELSE "SiteConfig"."BusinessAddressCountry" END AS "BusinessAddressCountry", "SiteConfig"."HomeBusinessSchemaType", "SiteConfig"."BusinessOpeningHours", CASE WHEN "SiteConfig_Localised_en_US"."ID" IS NOT NULL THEN "SiteConfig_Localised_en_US"."Copyright" WHEN "SiteConfig_Localised_de_DE"."ID" IS NOT NULL THEN "SiteConfig_Localised_de_DE"."Copyright" ELSE "SiteConfig"."Copyright" END AS "Copyright", CASE WHEN "SiteConfig_Localised_en_US"."ID" IS NOT NULL THEN "SiteConfig_Localised_en_US"."JobAlertTitle" WHEN "SiteConfig_Localised_de_DE"."ID" IS NOT NULL THEN "SiteConfig_Localised_de_DE"."JobAlertTitle" ELSE "SiteConfig"."JobAlertTitle" END AS "JobAlertTitle", CASE WHEN "SiteConfig_Localised_en_US"."ID" IS NOT NULL THEN "SiteConfig_Localised_en_US"."JobAlertSubTitle" WHEN "SiteConfig_Localised_de_DE"."ID" IS NOT NULL THEN "SiteConfig_Localised_de_DE"."JobAlertSubTitle" ELSE "SiteConfig"."JobAlertSubTitle" END AS "JobAlertSubTitle", CASE WHEN "SiteConfig_Localised_en_US"."ID" IS NOT NULL THEN "SiteConfig_Localised_en_US"."JobAlertContent" WHEN "SiteConfig_Localised_de_DE"."ID" IS NOT NULL THEN "SiteConfig_Localised_de_DE"."JobAlertContent" ELSE "SiteConfig"."JobAlertContent" END AS "JobAlertContent", "SiteConfig"."JobDefaultRecipient", CASE WHEN "SiteConfig_Localised_en_US"."ID" IS NOT NULL THEN "SiteConfig_Localised_en_US"."ApplyFormReply" WHEN "SiteConfig_Localised_de_DE"."ID" IS NOT NULL THEN "SiteConfig_Localised_de_DE"."ApplyFormReply" ELSE "SiteConfig"."ApplyFormReply" END AS "ApplyFormReply", "SiteConfig"."ShowInFrontend", "SiteConfig"."PrimaryColor", "SiteConfig"."PrimaryColorLighter", "SiteConfig"."SecondaryColor", "SiteConfig"."SecondaryColorLighter", "SiteConfig"."TertiaryColor", "SiteConfig"."MenuActiveColor", "SiteConfig"."SideBarColor", "SiteConfig"."SideBarColorHover", "SiteConfig"."PrimaryButton", "SiteConfig"."PrimaryButtonHover", "SiteConfig"."SecondaryButton", "SiteConfig"."SecondaryButtonHover", "SiteConfig"."TertiaryButton", "SiteConfig"."TertiaryButtonHover", CASE WHEN "SiteConfig_Localised_en_US"."ID" IS NOT NULL THEN "SiteConfig_Localised_en_US"."NewsletterContent" WHEN "SiteConfig_Localised_de_DE"."ID" IS NOT NULL THEN "SiteConfig_Localised_de_DE"."NewsletterContent" ELSE "SiteConfig"."NewsletterContent" END AS "NewsletterContent", CASE WHEN "SiteConfig_Localised_en_US"."ID" IS NOT NULL THEN "SiteConfig_Localised_en_US"."NewsletterButtonCaption" WHEN "SiteConfig_Localised_de_DE"."ID" IS NOT NULL THEN "SiteConfig_Localised_de_DE"."NewsletterButtonCaption" ELSE "SiteConfig"."NewsletterButtonCaption" END AS "NewsletterButtonCaption", CASE WHEN "SiteConfig_Localised_en_US"."ID" IS NOT NULL THEN "SiteConfig_Localised_en_US"."ChatbotCode" WHEN "SiteConfig_Localised_de_DE"."ID" IS NOT NULL THEN "SiteConfig_Localised_de_DE"."ChatbotCode" ELSE "SiteConfig"."ChatbotCode" END AS "ChatbotCode", CASE WHEN "SiteConfig_Localised_en_US"."ID" IS NOT NULL THEN "SiteConfig_Localised_en_US"."LlmsTxtContent" WHEN "SiteConfig_Localised_de_DE"."ID" IS NOT NULL THEN "SiteConfig_Localised_de_DE"."LlmsTxtContent" ELSE "SiteConfig"."LlmsTxtContent" END AS "LlmsTxtContent", CASE WHEN "SiteConfig_Localised_en_US"."ID" IS NOT NULL THEN "SiteConfig_Localised_en_US"."Title" WHEN "SiteConfig_Localised_de_DE"."ID" IS NOT NULL THEN "SiteConfig_Localised_de_DE"."Title" ELSE "SiteConfig"."Title" END AS "Title", "SiteConfig"."Tagline", "SiteConfig"."CanViewType", "SiteConfig"."CanEditType", "SiteConfig"."CanCreateTopLevelType", "SiteConfig"."SubsiteID", "SiteConfig"."DefaultHeaderID", "SiteConfig"."NewsletterLinkedPageID", "SiteConfig"."LogoID", "SiteConfig"."WhiteLogoID", "SiteConfig"."LogoSmallID", "SiteConfig"."ColoredSignetID", "SiteConfig"."FaviconPNGID", "SiteConfig"."FaviconICOID", "SiteConfig"."BusinessSchemaImage1ID", "SiteConfig"."BusinessSchemaImage2ID", "SiteConfig"."BusinessSchemaImage3ID", "SiteConfig"."NewsletterSuccessPageID", "SiteConfig"."NewsletterErrorPageID", "SiteConfig"."ID", CASE WHEN "SiteConfig"."ClassName" IS NOT NULL THEN "SiteConfig"."ClassName" ELSE 'SilverStripe\\SiteConfig\\SiteConfig' END AS "RecordClassName", 'en_US' AS "Locale", CASE WHEN "SiteConfig_Localised_en_US"."ID" IS NOT NULL THEN 'en_US' WHEN "SiteConfig_Localised_de_DE"."ID" IS NOT NULL THEN 'de_DE' ELSE NULL END AS "SourceLocale" FROM "SiteConfig" LEFT JOIN "SiteConfig_Localised" AS "SiteConfig_Localised_en_US" ON "SiteConfig"."ID" = "SiteConfig_Localised_en_US"."RecordID" AND "SiteConfig_Localised_en_US"."Locale" = ? LEFT JOIN "SiteConfig_Localised" AS "SiteConfig_Localised_de_DE" ON "SiteConfig"."ID" = "SiteConfig_Localised_de_DE"."RecordID" AND "SiteConfig_Localised_de_DE"."Locale" = ? WHERE ("SiteConfig"."SubsiteID" IN (2)) LIMIT 1 0.0008s
0041: SELECT DISTINCT "Fluent_Locale"."ClassName", "Fluent_Locale"."LastEdited", "Fluent_Locale"."Created", "Fluent_Locale"."Title", "Fluent_Locale"."Locale", "Fluent_Locale"."URLSegment", "Fluent_Locale"."IsGlobalDefault", "Fluent_Locale"."UseDefaultCode", "Fluent_Locale"."Sort", "Fluent_Locale"."Timezone", "Fluent_Locale"."DomainID", "Fluent_Locale"."ID", CASE WHEN "Fluent_Locale"."ClassName" IS NOT NULL THEN "Fluent_Locale"."ClassName" ELSE 'TractorCow\\Fluent\\Model\\Locale' END AS "RecordClassName" FROM "Fluent_Locale" WHERE ("Fluent_Locale"."Locale" = ?) ORDER BY "Fluent_Locale"."Sort" ASC, "Fluent_Locale"."Locale" ASC LIMIT 1 0.0002s
0042: SELECT DISTINCT "Fluent_Locale"."ClassName", "Fluent_Locale"."LastEdited", "Fluent_Locale"."Created", "Fluent_Locale"."Title", "Fluent_Locale"."Locale", "Fluent_Locale"."URLSegment", "Fluent_Locale"."IsGlobalDefault", "Fluent_Locale"."UseDefaultCode", "Fluent_Locale"."Sort", "Fluent_Locale"."Timezone", "Fluent_Locale"."DomainID", "Fluent_Locale"."ID", CASE WHEN "Fluent_Locale"."ClassName" IS NOT NULL THEN "Fluent_Locale"."ClassName" ELSE 'TractorCow\\Fluent\\Model\\Locale' END AS "RecordClassName" FROM "Fluent_Locale" WHERE ("Fluent_Locale"."Locale" = ?) ORDER BY "Fluent_Locale"."Sort" ASC, "Fluent_Locale"."Locale" ASC LIMIT 1 0.0002s
0043: SELECT "ID" FROM "SiteTree_Localised_Live" WHERE ("RecordID" = ?) AND ("Locale" = ?) LIMIT 1 0.0002s
0044: 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
0045: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", "SiteTree_Live"."CanViewType", "SiteTree_Live"."CanEditType", "SiteTree_Live"."Version", 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"."URLSegment" ELSE "SiteTree_Live"."URLSegment" END AS "URLSegment", 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_Live"."ClassName" IN ('SilverStripe\\CMS\\Model\\SiteTree', 'Page', 'AlternativeLandingPage', 'ApplicationFormPage', 'ContactPage', 'ElementalPage', 'HomePage', 'VIPChipRegistrationPage', 'MoritzSauer\\EventCalendar\\EventCalendarPage', 'SilverStripe\\ErrorPage\\ErrorPage', 'Job\\JobsPage', 'Tietge\\SocialWall\\SocialPage', 'Team\\Pages\\TeamPage', 'SilverStripe\\Blog\\Model\\Blog', 'SilverStripe\\Blog\\Model\\BlogPost', 'SilverStripe\\CMS\\Model\\RedirectorPage', 'SilverStripe\\CMS\\Model\\VirtualPage', 'SilverStripe\\UserForms\\Model\\UserDefinedForm', 'XD\\Events\\Model\\EventPage', 'XD\\Events\\Model\\EventsPage', 'SilverStripe\\Subsites\\Pages\\SubsitesVirtualPage') THEN "SiteTree_Live"."Content" WHEN "SiteTree_Live"."ClassName" IN ('Page', 'AlternativeLandingPage', 'ApplicationFormPage', 'ContactPage', 'ElementalPage', 'HomePage', 'VIPChipRegistrationPage', 'MoritzSauer\\EventCalendar\\EventCalendarPage', 'SilverStripe\\ErrorPage\\ErrorPage', 'Job\\JobsPage', 'Tietge\\SocialWall\\SocialPage', 'Team\\Pages\\TeamPage', 'SilverStripe\\Blog\\Model\\Blog', 'SilverStripe\\Blog\\Model\\BlogPost', 'SilverStripe\\CMS\\Model\\RedirectorPage', 'SilverStripe\\CMS\\Model\\VirtualPage', 'SilverStripe\\UserForms\\Model\\UserDefinedForm', 'XD\\Events\\Model\\EventPage', 'XD\\Events\\Model\\EventsPage', 'SilverStripe\\Subsites\\Pages\\SubsitesVirtualPage') THEN "Page_Live"."Content" WHEN "SiteTree_Live"."ClassName" IN ('Page', 'AlternativeLandingPage', 'ApplicationFormPage', 'ContactPage', 'ElementalPage', 'HomePage', 'VIPChipRegistrationPage', 'MoritzSauer\\EventCalendar\\EventCalendarPage', 'SilverStripe\\ErrorPage\\ErrorPage', 'Job\\JobsPage', 'Tietge\\SocialWall\\SocialPage', 'Team\\Pages\\TeamPage', 'SilverStripe\\Blog\\Model\\Blog', 'SilverStripe\\Blog\\Model\\BlogPost', 'SilverStripe\\CMS\\Model\\RedirectorPage', 'SilverStripe\\CMS\\Model\\VirtualPage', 'SilverStripe\\UserForms\\Model\\UserDefinedForm', 'XD\\Events\\Model\\EventPage', 'XD\\Events\\Model\\EventsPage', 'SilverStripe\\Subsites\\Pages\\SubsitesVirtualPage') THEN "Page_Live"."Content" ELSE NULL 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"."SubsiteID", "SiteTree_Live"."ParentID", CASE WHEN "Page_Localised_de_DE"."ID" IS NOT NULL THEN "Page_Localised_de_DE"."OGTitleCustom" ELSE "Page_Live"."OGTitleCustom" END AS "OGTitleCustom", CASE WHEN "Page_Localised_de_DE"."ID" IS NOT NULL THEN "Page_Localised_de_DE"."OGDescriptionCustom" ELSE "Page_Live"."OGDescriptionCustom" END AS "OGDescriptionCustom", CASE WHEN "Page_Localised_de_DE"."ID" IS NOT NULL THEN "Page_Localised_de_DE"."SubTitle" ELSE "Page_Live"."SubTitle" END AS "SubTitle", "Page_Live"."ShowInLegalMenu", CASE WHEN "Page_Localised_de_DE"."ID" IS NOT NULL THEN "Page_Localised_de_DE"."MetaTitle" ELSE "Page_Live"."MetaTitle" END AS "MetaTitle", "Page_Live"."ShowInNaviEingeklappt", "Page_Live"."ShowNewsletterInFooter", "Page_Live"."ShowPageHeaderGradient", "Page_Live"."OGImageCustomID", "Page_Live"."PinterestImageCustomID", "Page_Live"."HeaderImageID", "Page_Live"."VideoMP4ID", "Page_Live"."VideoOGVID", "Page_Live"."ImageID", "ElementalPage_Live"."ElementalAreaID", "SiteTree_Live"."ID", CASE WHEN "SiteTree_Live"."ClassName" IS NOT NULL THEN "SiteTree_Live"."ClassName" ELSE 'SilverStripe\\CMS\\Model\\SiteTree' END AS "RecordClassName", 'de_DE' AS "Locale", CASE WHEN "Page_Localised_de_DE"."ID" IS NOT NULL THEN 'de_DE' ELSE NULL END AS "SourceLocale" FROM "SiteTree_Live" LEFT JOIN "Page_Live" ON "Page_Live"."ID" = "SiteTree_Live"."ID" LEFT JOIN "ElementalPage_Live" ON "ElementalPage_Live"."ID" = "SiteTree_Live"."ID" 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" = ? LEFT JOIN "Page_Localised_Live" AS "Page_Localised_de_DE" ON "Page_Live"."ID" = "Page_Localised_de_DE"."RecordID" AND "Page_Localised_de_DE"."Locale" = ? WHERE ("SiteTree_Live"."ID" = ?) AND ("SiteTree_Live"."ClassName" IN (?)) AND (("SiteTree_Localised_de_DE"."ID" IS NOT NULL)) ORDER BY "SiteTree_Live"."Sort" ASC LIMIT 1 0.0005s
0046: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", "SiteTree_Live"."CanViewType", "SiteTree_Live"."CanEditType", "SiteTree_Live"."Version", 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"."URLSegment" ELSE "SiteTree_Live"."URLSegment" END AS "URLSegment", 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_Live"."ClassName" IN ('SilverStripe\\CMS\\Model\\SiteTree', 'Page', 'AlternativeLandingPage', 'ApplicationFormPage', 'ContactPage', 'ElementalPage', 'HomePage', 'VIPChipRegistrationPage', 'MoritzSauer\\EventCalendar\\EventCalendarPage', 'SilverStripe\\ErrorPage\\ErrorPage', 'Job\\JobsPage', 'Tietge\\SocialWall\\SocialPage', 'Team\\Pages\\TeamPage', 'SilverStripe\\Blog\\Model\\Blog', 'SilverStripe\\Blog\\Model\\BlogPost', 'SilverStripe\\CMS\\Model\\RedirectorPage', 'SilverStripe\\CMS\\Model\\VirtualPage', 'SilverStripe\\UserForms\\Model\\UserDefinedForm', 'XD\\Events\\Model\\EventPage', 'XD\\Events\\Model\\EventsPage', 'SilverStripe\\Subsites\\Pages\\SubsitesVirtualPage') THEN "SiteTree_Live"."Content" WHEN "SiteTree_Live"."ClassName" IN ('Page', 'AlternativeLandingPage', 'ApplicationFormPage', 'ContactPage', 'ElementalPage', 'HomePage', 'VIPChipRegistrationPage', 'MoritzSauer\\EventCalendar\\EventCalendarPage', 'SilverStripe\\ErrorPage\\ErrorPage', 'Job\\JobsPage', 'Tietge\\SocialWall\\SocialPage', 'Team\\Pages\\TeamPage', 'SilverStripe\\Blog\\Model\\Blog', 'SilverStripe\\Blog\\Model\\BlogPost', 'SilverStripe\\CMS\\Model\\RedirectorPage', 'SilverStripe\\CMS\\Model\\VirtualPage', 'SilverStripe\\UserForms\\Model\\UserDefinedForm', 'XD\\Events\\Model\\EventPage', 'XD\\Events\\Model\\EventsPage', 'SilverStripe\\Subsites\\Pages\\SubsitesVirtualPage') THEN "Page_Live"."Content" WHEN "SiteTree_Live"."ClassName" IN ('Page', 'AlternativeLandingPage', 'ApplicationFormPage', 'ContactPage', 'ElementalPage', 'HomePage', 'VIPChipRegistrationPage', 'MoritzSauer\\EventCalendar\\EventCalendarPage', 'SilverStripe\\ErrorPage\\ErrorPage', 'Job\\JobsPage', 'Tietge\\SocialWall\\SocialPage', 'Team\\Pages\\TeamPage', 'SilverStripe\\Blog\\Model\\Blog', 'SilverStripe\\Blog\\Model\\BlogPost', 'SilverStripe\\CMS\\Model\\RedirectorPage', 'SilverStripe\\CMS\\Model\\VirtualPage', 'SilverStripe\\UserForms\\Model\\UserDefinedForm', 'XD\\Events\\Model\\EventPage', 'XD\\Events\\Model\\EventsPage', 'SilverStripe\\Subsites\\Pages\\SubsitesVirtualPage') THEN "Page_Live"."Content" ELSE NULL 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"."SubsiteID", "SiteTree_Live"."ParentID", CASE WHEN "Page_Localised_de_DE"."ID" IS NOT NULL THEN "Page_Localised_de_DE"."OGTitleCustom" ELSE "Page_Live"."OGTitleCustom" END AS "OGTitleCustom", CASE WHEN "Page_Localised_de_DE"."ID" IS NOT NULL THEN "Page_Localised_de_DE"."OGDescriptionCustom" ELSE "Page_Live"."OGDescriptionCustom" END AS "OGDescriptionCustom", CASE WHEN "Page_Localised_de_DE"."ID" IS NOT NULL THEN "Page_Localised_de_DE"."SubTitle" ELSE "Page_Live"."SubTitle" END AS "SubTitle", "Page_Live"."ShowInLegalMenu", CASE WHEN "Page_Localised_de_DE"."ID" IS NOT NULL THEN "Page_Localised_de_DE"."MetaTitle" ELSE "Page_Live"."MetaTitle" END AS "MetaTitle", "Page_Live"."ShowInNaviEingeklappt", "Page_Live"."ShowNewsletterInFooter", "Page_Live"."ShowPageHeaderGradient", "Page_Live"."OGImageCustomID", "Page_Live"."PinterestImageCustomID", "Page_Live"."HeaderImageID", "Page_Live"."VideoMP4ID", "Page_Live"."VideoOGVID", "Page_Live"."ImageID", "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 "Page_Localised_de_DE"."ID" IS NOT NULL THEN 'de_DE' ELSE NULL END AS "SourceLocale" FROM "SiteTree_Live" LEFT JOIN "Page_Live" ON "Page_Live"."ID" = "SiteTree_Live"."ID" 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" = ? LEFT JOIN "Page_Localised_Live" AS "Page_Localised_de_DE" ON "Page_Live"."ID" = "Page_Localised_de_DE"."RecordID" AND "Page_Localised_de_DE"."Locale" = ? WHERE ("SiteTree_Live"."ID" = ?) AND ("SiteTree_Live"."ClassName" IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)) AND (("SiteTree_Localised_de_DE"."ID" IS NOT NULL)) ORDER BY "SiteTree_Live"."Sort" ASC LIMIT 1 0.0004s
0047: SELECT sd.Domain From SubsiteDomain sd WHERE sd.SubsiteID = 2 AND sd.Locale = 'de_DE' 0.0001s
0048: SELECT "ID" FROM "SiteTree_Localised_Live" WHERE ("RecordID" = ?) AND ("Locale" = ?) LIMIT 1 0.0002s
0049: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", "SiteTree_Live"."CanViewType", "SiteTree_Live"."CanEditType", "SiteTree_Live"."Version", CASE WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."Title" 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_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."URLSegment" 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_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."MenuTitle" 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_Live"."ClassName" IN ('SilverStripe\\CMS\\Model\\SiteTree', 'Page', 'AlternativeLandingPage', 'ApplicationFormPage', 'ContactPage', 'ElementalPage', 'HomePage', 'VIPChipRegistrationPage', 'MoritzSauer\\EventCalendar\\EventCalendarPage', 'SilverStripe\\ErrorPage\\ErrorPage', 'Job\\JobsPage', 'Tietge\\SocialWall\\SocialPage', 'Team\\Pages\\TeamPage', 'SilverStripe\\Blog\\Model\\Blog', 'SilverStripe\\Blog\\Model\\BlogPost', 'SilverStripe\\CMS\\Model\\RedirectorPage', 'SilverStripe\\CMS\\Model\\VirtualPage', 'SilverStripe\\UserForms\\Model\\UserDefinedForm', 'XD\\Events\\Model\\EventPage', 'XD\\Events\\Model\\EventsPage', 'SilverStripe\\Subsites\\Pages\\SubsitesVirtualPage') THEN "SiteTree_Live"."Content" WHEN "SiteTree_Live"."ClassName" IN ('Page', 'AlternativeLandingPage', 'ApplicationFormPage', 'ContactPage', 'ElementalPage', 'HomePage', 'VIPChipRegistrationPage', 'MoritzSauer\\EventCalendar\\EventCalendarPage', 'SilverStripe\\ErrorPage\\ErrorPage', 'Job\\JobsPage', 'Tietge\\SocialWall\\SocialPage', 'Team\\Pages\\TeamPage', 'SilverStripe\\Blog\\Model\\Blog', 'SilverStripe\\Blog\\Model\\BlogPost', 'SilverStripe\\CMS\\Model\\RedirectorPage', 'SilverStripe\\CMS\\Model\\VirtualPage', 'SilverStripe\\UserForms\\Model\\UserDefinedForm', 'XD\\Events\\Model\\EventPage', 'XD\\Events\\Model\\EventsPage', 'SilverStripe\\Subsites\\Pages\\SubsitesVirtualPage') THEN "Page_Live"."Content" WHEN "SiteTree_Live"."ClassName" IN ('Page', 'AlternativeLandingPage', 'ApplicationFormPage', 'ContactPage', 'ElementalPage', 'HomePage', 'VIPChipRegistrationPage', 'MoritzSauer\\EventCalendar\\EventCalendarPage', 'SilverStripe\\ErrorPage\\ErrorPage', 'Job\\JobsPage', 'Tietge\\SocialWall\\SocialPage', 'Team\\Pages\\TeamPage', 'SilverStripe\\Blog\\Model\\Blog', 'SilverStripe\\Blog\\Model\\BlogPost', 'SilverStripe\\CMS\\Model\\RedirectorPage', 'SilverStripe\\CMS\\Model\\VirtualPage', 'SilverStripe\\UserForms\\Model\\UserDefinedForm', 'XD\\Events\\Model\\EventPage', 'XD\\Events\\Model\\EventsPage', 'SilverStripe\\Subsites\\Pages\\SubsitesVirtualPage') THEN "Page_Live"."Content" ELSE NULL END AS "Content", CASE WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."MetaDescription" 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_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."ReportClass" WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."ReportClass" ELSE "SiteTree_Live"."ReportClass" END AS "ReportClass", "SiteTree_Live"."SubsiteID", "SiteTree_Live"."ParentID", CASE WHEN "Page_Localised_en_US"."ID" IS NOT NULL THEN "Page_Localised_en_US"."OGTitleCustom" WHEN "Page_Localised_de_DE"."ID" IS NOT NULL THEN "Page_Localised_de_DE"."OGTitleCustom" ELSE "Page_Live"."OGTitleCustom" END AS "OGTitleCustom", CASE WHEN "Page_Localised_en_US"."ID" IS NOT NULL THEN "Page_Localised_en_US"."OGDescriptionCustom" WHEN "Page_Localised_de_DE"."ID" IS NOT NULL THEN "Page_Localised_de_DE"."OGDescriptionCustom" ELSE "Page_Live"."OGDescriptionCustom" END AS "OGDescriptionCustom", CASE WHEN "Page_Localised_en_US"."ID" IS NOT NULL THEN "Page_Localised_en_US"."SubTitle" WHEN "Page_Localised_de_DE"."ID" IS NOT NULL THEN "Page_Localised_de_DE"."SubTitle" ELSE "Page_Live"."SubTitle" END AS "SubTitle", "Page_Live"."ShowInLegalMenu", CASE WHEN "Page_Localised_en_US"."ID" IS NOT NULL THEN "Page_Localised_en_US"."MetaTitle" WHEN "Page_Localised_de_DE"."ID" IS NOT NULL THEN "Page_Localised_de_DE"."MetaTitle" ELSE "Page_Live"."MetaTitle" END AS "MetaTitle", "Page_Live"."ShowInNaviEingeklappt", "Page_Live"."ShowNewsletterInFooter", "Page_Live"."ShowPageHeaderGradient", "Page_Live"."OGImageCustomID", "Page_Live"."PinterestImageCustomID", "Page_Live"."HeaderImageID", "Page_Live"."VideoMP4ID", "Page_Live"."VideoOGVID", "Page_Live"."ImageID", "ElementalPage_Live"."ElementalAreaID", "SiteTree_Live"."ID", CASE WHEN "SiteTree_Live"."ClassName" IS NOT NULL THEN "SiteTree_Live"."ClassName" ELSE 'SilverStripe\\CMS\\Model\\SiteTree' END AS "RecordClassName", 'en_US' AS "Locale", CASE WHEN "Page_Localised_en_US"."ID" IS NOT NULL THEN 'en_US' WHEN "Page_Localised_de_DE"."ID" IS NOT NULL THEN 'de_DE' ELSE NULL END AS "SourceLocale" FROM "SiteTree_Live" LEFT JOIN "Page_Live" ON "Page_Live"."ID" = "SiteTree_Live"."ID" LEFT JOIN "ElementalPage_Live" ON "ElementalPage_Live"."ID" = "SiteTree_Live"."ID" LEFT JOIN "SiteTree_Localised_Live" AS "SiteTree_Localised_en_US" ON "SiteTree_Live"."ID" = "SiteTree_Localised_en_US"."RecordID" AND "SiteTree_Localised_en_US"."Locale" = ? LEFT JOIN "SiteTree_Localised_Live" AS "SiteTree_Localised_de_DE" ON "SiteTree_Live"."ID" = "SiteTree_Localised_de_DE"."RecordID" AND "SiteTree_Localised_de_DE"."Locale" = ? LEFT JOIN "Page_Localised_Live" AS "Page_Localised_en_US" ON "Page_Live"."ID" = "Page_Localised_en_US"."RecordID" AND "Page_Localised_en_US"."Locale" = ? LEFT JOIN "Page_Localised_Live" AS "Page_Localised_de_DE" ON "Page_Live"."ID" = "Page_Localised_de_DE"."RecordID" AND "Page_Localised_de_DE"."Locale" = ? WHERE ("SiteTree_Live"."ID" = ?) AND ("SiteTree_Live"."ClassName" IN (?)) AND (("SiteTree_Localised_en_US"."ID" IS NOT NULL) OR ("SiteTree_Localised_de_DE"."ID" IS NOT NULL)) ORDER BY "SiteTree_Live"."Sort" ASC LIMIT 1 0.0005s
0050: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", "SiteTree_Live"."CanViewType", "SiteTree_Live"."CanEditType", "SiteTree_Live"."Version", CASE WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."Title" 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_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."URLSegment" 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_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."MenuTitle" 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_Live"."ClassName" IN ('SilverStripe\\CMS\\Model\\SiteTree', 'Page', 'AlternativeLandingPage', 'ApplicationFormPage', 'ContactPage', 'ElementalPage', 'HomePage', 'VIPChipRegistrationPage', 'MoritzSauer\\EventCalendar\\EventCalendarPage', 'SilverStripe\\ErrorPage\\ErrorPage', 'Job\\JobsPage', 'Tietge\\SocialWall\\SocialPage', 'Team\\Pages\\TeamPage', 'SilverStripe\\Blog\\Model\\Blog', 'SilverStripe\\Blog\\Model\\BlogPost', 'SilverStripe\\CMS\\Model\\RedirectorPage', 'SilverStripe\\CMS\\Model\\VirtualPage', 'SilverStripe\\UserForms\\Model\\UserDefinedForm', 'XD\\Events\\Model\\EventPage', 'XD\\Events\\Model\\EventsPage', 'SilverStripe\\Subsites\\Pages\\SubsitesVirtualPage') THEN "SiteTree_Live"."Content" WHEN "SiteTree_Live"."ClassName" IN ('Page', 'AlternativeLandingPage', 'ApplicationFormPage', 'ContactPage', 'ElementalPage', 'HomePage', 'VIPChipRegistrationPage', 'MoritzSauer\\EventCalendar\\EventCalendarPage', 'SilverStripe\\ErrorPage\\ErrorPage', 'Job\\JobsPage', 'Tietge\\SocialWall\\SocialPage', 'Team\\Pages\\TeamPage', 'SilverStripe\\Blog\\Model\\Blog', 'SilverStripe\\Blog\\Model\\BlogPost', 'SilverStripe\\CMS\\Model\\RedirectorPage', 'SilverStripe\\CMS\\Model\\VirtualPage', 'SilverStripe\\UserForms\\Model\\UserDefinedForm', 'XD\\Events\\Model\\EventPage', 'XD\\Events\\Model\\EventsPage', 'SilverStripe\\Subsites\\Pages\\SubsitesVirtualPage') THEN "Page_Live"."Content" WHEN "SiteTree_Live"."ClassName" IN ('Page', 'AlternativeLandingPage', 'ApplicationFormPage', 'ContactPage', 'ElementalPage', 'HomePage', 'VIPChipRegistrationPage', 'MoritzSauer\\EventCalendar\\EventCalendarPage', 'SilverStripe\\ErrorPage\\ErrorPage', 'Job\\JobsPage', 'Tietge\\SocialWall\\SocialPage', 'Team\\Pages\\TeamPage', 'SilverStripe\\Blog\\Model\\Blog', 'SilverStripe\\Blog\\Model\\BlogPost', 'SilverStripe\\CMS\\Model\\RedirectorPage', 'SilverStripe\\CMS\\Model\\VirtualPage', 'SilverStripe\\UserForms\\Model\\UserDefinedForm', 'XD\\Events\\Model\\EventPage', 'XD\\Events\\Model\\EventsPage', 'SilverStripe\\Subsites\\Pages\\SubsitesVirtualPage') THEN "Page_Live"."Content" ELSE NULL END AS "Content", CASE WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."MetaDescription" 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_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."ReportClass" WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."ReportClass" ELSE "SiteTree_Live"."ReportClass" END AS "ReportClass", "SiteTree_Live"."SubsiteID", "SiteTree_Live"."ParentID", CASE WHEN "Page_Localised_en_US"."ID" IS NOT NULL THEN "Page_Localised_en_US"."OGTitleCustom" WHEN "Page_Localised_de_DE"."ID" IS NOT NULL THEN "Page_Localised_de_DE"."OGTitleCustom" ELSE "Page_Live"."OGTitleCustom" END AS "OGTitleCustom", CASE WHEN "Page_Localised_en_US"."ID" IS NOT NULL THEN "Page_Localised_en_US"."OGDescriptionCustom" WHEN "Page_Localised_de_DE"."ID" IS NOT NULL THEN "Page_Localised_de_DE"."OGDescriptionCustom" ELSE "Page_Live"."OGDescriptionCustom" END AS "OGDescriptionCustom", CASE WHEN "Page_Localised_en_US"."ID" IS NOT NULL THEN "Page_Localised_en_US"."SubTitle" WHEN "Page_Localised_de_DE"."ID" IS NOT NULL THEN "Page_Localised_de_DE"."SubTitle" ELSE "Page_Live"."SubTitle" END AS "SubTitle", "Page_Live"."ShowInLegalMenu", CASE WHEN "Page_Localised_en_US"."ID" IS NOT NULL THEN "Page_Localised_en_US"."MetaTitle" WHEN "Page_Localised_de_DE"."ID" IS NOT NULL THEN "Page_Localised_de_DE"."MetaTitle" ELSE "Page_Live"."MetaTitle" END AS "MetaTitle", "Page_Live"."ShowInNaviEingeklappt", "Page_Live"."ShowNewsletterInFooter", "Page_Live"."ShowPageHeaderGradient", "Page_Live"."OGImageCustomID", "Page_Live"."PinterestImageCustomID", "Page_Live"."HeaderImageID", "Page_Live"."VideoMP4ID", "Page_Live"."VideoOGVID", "Page_Live"."ImageID", "SiteTree_Live"."ID", CASE WHEN "SiteTree_Live"."ClassName" IS NOT NULL THEN "SiteTree_Live"."ClassName" ELSE 'SilverStripe\\CMS\\Model\\SiteTree' END AS "RecordClassName", 'en_US' AS "Locale", CASE WHEN "Page_Localised_en_US"."ID" IS NOT NULL THEN 'en_US' WHEN "Page_Localised_de_DE"."ID" IS NOT NULL THEN 'de_DE' ELSE NULL END AS "SourceLocale" FROM "SiteTree_Live" LEFT JOIN "Page_Live" ON "Page_Live"."ID" = "SiteTree_Live"."ID" LEFT JOIN "SiteTree_Localised_Live" AS "SiteTree_Localised_en_US" ON "SiteTree_Live"."ID" = "SiteTree_Localised_en_US"."RecordID" AND "SiteTree_Localised_en_US"."Locale" = ? LEFT JOIN "SiteTree_Localised_Live" AS "SiteTree_Localised_de_DE" ON "SiteTree_Live"."ID" = "SiteTree_Localised_de_DE"."RecordID" AND "SiteTree_Localised_de_DE"."Locale" = ? LEFT JOIN "Page_Localised_Live" AS "Page_Localised_en_US" ON "Page_Live"."ID" = "Page_Localised_en_US"."RecordID" AND "Page_Localised_en_US"."Locale" = ? LEFT JOIN "Page_Localised_Live" AS "Page_Localised_de_DE" ON "Page_Live"."ID" = "Page_Localised_de_DE"."RecordID" AND "Page_Localised_de_DE"."Locale" = ? WHERE ("SiteTree_Live"."ID" = ?) AND ("SiteTree_Live"."ClassName" IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)) AND (("SiteTree_Localised_en_US"."ID" IS NOT NULL) OR ("SiteTree_Localised_de_DE"."ID" IS NOT NULL)) ORDER BY "SiteTree_Live"."Sort" ASC LIMIT 1 0.0005s
0051: SELECT sd.Domain From SubsiteDomain sd WHERE sd.SubsiteID = 2 AND sd.Locale = 'en_US' 0.0001s
0052: SELECT "ID" FROM "SiteTree_Localised_Live" WHERE ("RecordID" = ?) AND ("Locale" = ?) LIMIT 1 0.0003s
0053: 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
0054: SELECT DISTINCT "Fluent_Locale"."ClassName", "Fluent_Locale"."LastEdited", "Fluent_Locale"."Created", "Fluent_Locale"."Title", "Fluent_Locale"."Locale", "Fluent_Locale"."URLSegment", "Fluent_Locale"."IsGlobalDefault", "Fluent_Locale"."UseDefaultCode", "Fluent_Locale"."Sort", "Fluent_Locale"."Timezone", "Fluent_Locale"."DomainID", "Fluent_Locale"."ID", CASE WHEN "Fluent_Locale"."ClassName" IS NOT NULL THEN "Fluent_Locale"."ClassName" ELSE 'TractorCow\\Fluent\\Model\\Locale' END AS "RecordClassName" FROM "Fluent_Locale" WHERE ("Fluent_Locale"."ID" = ?) ORDER BY "Fluent_Locale"."Sort" ASC, "Fluent_Locale"."Locale" ASC LIMIT 1 0.0002s
0055: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", "SiteTree_Live"."CanViewType", "SiteTree_Live"."CanEditType", "SiteTree_Live"."Version", CASE WHEN "SiteTree_Localised_fr_FR"."ID" IS NOT NULL THEN "SiteTree_Localised_fr_FR"."Title" 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_fr_FR"."ID" IS NOT NULL THEN "SiteTree_Localised_fr_FR"."URLSegment" 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_fr_FR"."ID" IS NOT NULL THEN "SiteTree_Localised_fr_FR"."MenuTitle" 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_Live"."ClassName" IN ('SilverStripe\\CMS\\Model\\SiteTree', 'Page', 'AlternativeLandingPage', 'ApplicationFormPage', 'ContactPage', 'ElementalPage', 'HomePage', 'VIPChipRegistrationPage', 'MoritzSauer\\EventCalendar\\EventCalendarPage', 'SilverStripe\\ErrorPage\\ErrorPage', 'Job\\JobsPage', 'Tietge\\SocialWall\\SocialPage', 'Team\\Pages\\TeamPage', 'SilverStripe\\Blog\\Model\\Blog', 'SilverStripe\\Blog\\Model\\BlogPost', 'SilverStripe\\CMS\\Model\\RedirectorPage', 'SilverStripe\\CMS\\Model\\VirtualPage', 'SilverStripe\\UserForms\\Model\\UserDefinedForm', 'XD\\Events\\Model\\EventPage', 'XD\\Events\\Model\\EventsPage', 'SilverStripe\\Subsites\\Pages\\SubsitesVirtualPage') THEN "SiteTree_Live"."Content" WHEN "SiteTree_Live"."ClassName" IN ('Page', 'AlternativeLandingPage', 'ApplicationFormPage', 'ContactPage', 'ElementalPage', 'HomePage', 'VIPChipRegistrationPage', 'MoritzSauer\\EventCalendar\\EventCalendarPage', 'SilverStripe\\ErrorPage\\ErrorPage', 'Job\\JobsPage', 'Tietge\\SocialWall\\SocialPage', 'Team\\Pages\\TeamPage', 'SilverStripe\\Blog\\Model\\Blog', 'SilverStripe\\Blog\\Model\\BlogPost', 'SilverStripe\\CMS\\Model\\RedirectorPage', 'SilverStripe\\CMS\\Model\\VirtualPage', 'SilverStripe\\UserForms\\Model\\UserDefinedForm', 'XD\\Events\\Model\\EventPage', 'XD\\Events\\Model\\EventsPage', 'SilverStripe\\Subsites\\Pages\\SubsitesVirtualPage') THEN "Page_Live"."Content" WHEN "SiteTree_Live"."ClassName" IN ('Page', 'AlternativeLandingPage', 'ApplicationFormPage', 'ContactPage', 'ElementalPage', 'HomePage', 'VIPChipRegistrationPage', 'MoritzSauer\\EventCalendar\\EventCalendarPage', 'SilverStripe\\ErrorPage\\ErrorPage', 'Job\\JobsPage', 'Tietge\\SocialWall\\SocialPage', 'Team\\Pages\\TeamPage', 'SilverStripe\\Blog\\Model\\Blog', 'SilverStripe\\Blog\\Model\\BlogPost', 'SilverStripe\\CMS\\Model\\RedirectorPage', 'SilverStripe\\CMS\\Model\\VirtualPage', 'SilverStripe\\UserForms\\Model\\UserDefinedForm', 'XD\\Events\\Model\\EventPage', 'XD\\Events\\Model\\EventsPage', 'SilverStripe\\Subsites\\Pages\\SubsitesVirtualPage') THEN "Page_Live"."Content" ELSE NULL END AS "Content", CASE WHEN "SiteTree_Localised_fr_FR"."ID" IS NOT NULL THEN "SiteTree_Localised_fr_FR"."MetaDescription" 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_fr_FR"."ID" IS NOT NULL THEN "SiteTree_Localised_fr_FR"."ReportClass" WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."ReportClass" ELSE "SiteTree_Live"."ReportClass" END AS "ReportClass", "SiteTree_Live"."SubsiteID", "SiteTree_Live"."ParentID", CASE WHEN "Page_Localised_fr_FR"."ID" IS NOT NULL THEN "Page_Localised_fr_FR"."OGTitleCustom" WHEN "Page_Localised_de_DE"."ID" IS NOT NULL THEN "Page_Localised_de_DE"."OGTitleCustom" ELSE "Page_Live"."OGTitleCustom" END AS "OGTitleCustom", CASE WHEN "Page_Localised_fr_FR"."ID" IS NOT NULL THEN "Page_Localised_fr_FR"."OGDescriptionCustom" WHEN "Page_Localised_de_DE"."ID" IS NOT NULL THEN "Page_Localised_de_DE"."OGDescriptionCustom" ELSE "Page_Live"."OGDescriptionCustom" END AS "OGDescriptionCustom", CASE WHEN "Page_Localised_fr_FR"."ID" IS NOT NULL THEN "Page_Localised_fr_FR"."SubTitle" WHEN "Page_Localised_de_DE"."ID" IS NOT NULL THEN "Page_Localised_de_DE"."SubTitle" ELSE "Page_Live"."SubTitle" END AS "SubTitle", "Page_Live"."ShowInLegalMenu", CASE WHEN "Page_Localised_fr_FR"."ID" IS NOT NULL THEN "Page_Localised_fr_FR"."MetaTitle" WHEN "Page_Localised_de_DE"."ID" IS NOT NULL THEN "Page_Localised_de_DE"."MetaTitle" ELSE "Page_Live"."MetaTitle" END AS "MetaTitle", "Page_Live"."ShowInNaviEingeklappt", "Page_Live"."ShowNewsletterInFooter", "Page_Live"."ShowPageHeaderGradient", "Page_Live"."OGImageCustomID", "Page_Live"."PinterestImageCustomID", "Page_Live"."HeaderImageID", "Page_Live"."VideoMP4ID", "Page_Live"."VideoOGVID", "Page_Live"."ImageID", "ElementalPage_Live"."ElementalAreaID", "SiteTree_Live"."ID", CASE WHEN "SiteTree_Live"."ClassName" IS NOT NULL THEN "SiteTree_Live"."ClassName" ELSE 'SilverStripe\\CMS\\Model\\SiteTree' END AS "RecordClassName", 'fr_FR' AS "Locale", CASE WHEN "Page_Localised_fr_FR"."ID" IS NOT NULL THEN 'fr_FR' WHEN "Page_Localised_de_DE"."ID" IS NOT NULL THEN 'de_DE' ELSE NULL END AS "SourceLocale" FROM "SiteTree_Live" LEFT JOIN "Page_Live" ON "Page_Live"."ID" = "SiteTree_Live"."ID" LEFT JOIN "ElementalPage_Live" ON "ElementalPage_Live"."ID" = "SiteTree_Live"."ID" LEFT JOIN "SiteTree_Localised_Live" AS "SiteTree_Localised_fr_FR" ON "SiteTree_Live"."ID" = "SiteTree_Localised_fr_FR"."RecordID" AND "SiteTree_Localised_fr_FR"."Locale" = ? 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" = ? LEFT JOIN "Page_Localised_Live" AS "Page_Localised_fr_FR" ON "Page_Live"."ID" = "Page_Localised_fr_FR"."RecordID" AND "Page_Localised_fr_FR"."Locale" = ? LEFT JOIN "Page_Localised_Live" AS "Page_Localised_de_DE" ON "Page_Live"."ID" = "Page_Localised_de_DE"."RecordID" AND "Page_Localised_de_DE"."Locale" = ? WHERE ("SiteTree_Live"."ID" = ?) AND ("SiteTree_Live"."ClassName" IN (?)) AND (("SiteTree_Localised_fr_FR"."ID" IS NOT NULL) OR ("SiteTree_Localised_de_DE"."ID" IS NOT NULL)) ORDER BY "SiteTree_Live"."Sort" ASC LIMIT 1 0.0005s
0056: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", "SiteTree_Live"."CanViewType", "SiteTree_Live"."CanEditType", "SiteTree_Live"."Version", CASE WHEN "SiteTree_Localised_fr_FR"."ID" IS NOT NULL THEN "SiteTree_Localised_fr_FR"."Title" 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_fr_FR"."ID" IS NOT NULL THEN "SiteTree_Localised_fr_FR"."URLSegment" 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_fr_FR"."ID" IS NOT NULL THEN "SiteTree_Localised_fr_FR"."MenuTitle" 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_Live"."ClassName" IN ('SilverStripe\\CMS\\Model\\SiteTree', 'Page', 'AlternativeLandingPage', 'ApplicationFormPage', 'ContactPage', 'ElementalPage', 'HomePage', 'VIPChipRegistrationPage', 'MoritzSauer\\EventCalendar\\EventCalendarPage', 'SilverStripe\\ErrorPage\\ErrorPage', 'Job\\JobsPage', 'Tietge\\SocialWall\\SocialPage', 'Team\\Pages\\TeamPage', 'SilverStripe\\Blog\\Model\\Blog', 'SilverStripe\\Blog\\Model\\BlogPost', 'SilverStripe\\CMS\\Model\\RedirectorPage', 'SilverStripe\\CMS\\Model\\VirtualPage', 'SilverStripe\\UserForms\\Model\\UserDefinedForm', 'XD\\Events\\Model\\EventPage', 'XD\\Events\\Model\\EventsPage', 'SilverStripe\\Subsites\\Pages\\SubsitesVirtualPage') THEN "SiteTree_Live"."Content" WHEN "SiteTree_Live"."ClassName" IN ('Page', 'AlternativeLandingPage', 'ApplicationFormPage', 'ContactPage', 'ElementalPage', 'HomePage', 'VIPChipRegistrationPage', 'MoritzSauer\\EventCalendar\\EventCalendarPage', 'SilverStripe\\ErrorPage\\ErrorPage', 'Job\\JobsPage', 'Tietge\\SocialWall\\SocialPage', 'Team\\Pages\\TeamPage', 'SilverStripe\\Blog\\Model\\Blog', 'SilverStripe\\Blog\\Model\\BlogPost', 'SilverStripe\\CMS\\Model\\RedirectorPage', 'SilverStripe\\CMS\\Model\\VirtualPage', 'SilverStripe\\UserForms\\Model\\UserDefinedForm', 'XD\\Events\\Model\\EventPage', 'XD\\Events\\Model\\EventsPage', 'SilverStripe\\Subsites\\Pages\\SubsitesVirtualPage') THEN "Page_Live"."Content" WHEN "SiteTree_Live"."ClassName" IN ('Page', 'AlternativeLandingPage', 'ApplicationFormPage', 'ContactPage', 'ElementalPage', 'HomePage', 'VIPChipRegistrationPage', 'MoritzSauer\\EventCalendar\\EventCalendarPage', 'SilverStripe\\ErrorPage\\ErrorPage', 'Job\\JobsPage', 'Tietge\\SocialWall\\SocialPage', 'Team\\Pages\\TeamPage', 'SilverStripe\\Blog\\Model\\Blog', 'SilverStripe\\Blog\\Model\\BlogPost', 'SilverStripe\\CMS\\Model\\RedirectorPage', 'SilverStripe\\CMS\\Model\\VirtualPage', 'SilverStripe\\UserForms\\Model\\UserDefinedForm', 'XD\\Events\\Model\\EventPage', 'XD\\Events\\Model\\EventsPage', 'SilverStripe\\Subsites\\Pages\\SubsitesVirtualPage') THEN "Page_Live"."Content" ELSE NULL END AS "Content", CASE WHEN "SiteTree_Localised_fr_FR"."ID" IS NOT NULL THEN "SiteTree_Localised_fr_FR"."MetaDescription" 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_fr_FR"."ID" IS NOT NULL THEN "SiteTree_Localised_fr_FR"."ReportClass" WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."ReportClass" ELSE "SiteTree_Live"."ReportClass" END AS "ReportClass", "SiteTree_Live"."SubsiteID", "SiteTree_Live"."ParentID", CASE WHEN "Page_Localised_fr_FR"."ID" IS NOT NULL THEN "Page_Localised_fr_FR"."OGTitleCustom" WHEN "Page_Localised_de_DE"."ID" IS NOT NULL THEN "Page_Localised_de_DE"."OGTitleCustom" ELSE "Page_Live"."OGTitleCustom" END AS "OGTitleCustom", CASE WHEN "Page_Localised_fr_FR"."ID" IS NOT NULL THEN "Page_Localised_fr_FR"."OGDescriptionCustom" WHEN "Page_Localised_de_DE"."ID" IS NOT NULL THEN "Page_Localised_de_DE"."OGDescriptionCustom" ELSE "Page_Live"."OGDescriptionCustom" END AS "OGDescriptionCustom", CASE WHEN "Page_Localised_fr_FR"."ID" IS NOT NULL THEN "Page_Localised_fr_FR"."SubTitle" WHEN "Page_Localised_de_DE"."ID" IS NOT NULL THEN "Page_Localised_de_DE"."SubTitle" ELSE "Page_Live"."SubTitle" END AS "SubTitle", "Page_Live"."ShowInLegalMenu", CASE WHEN "Page_Localised_fr_FR"."ID" IS NOT NULL THEN "Page_Localised_fr_FR"."MetaTitle" WHEN "Page_Localised_de_DE"."ID" IS NOT NULL THEN "Page_Localised_de_DE"."MetaTitle" ELSE "Page_Live"."MetaTitle" END AS "MetaTitle", "Page_Live"."ShowInNaviEingeklappt", "Page_Live"."ShowNewsletterInFooter", "Page_Live"."ShowPageHeaderGradient", "Page_Live"."OGImageCustomID", "Page_Live"."PinterestImageCustomID", "Page_Live"."HeaderImageID", "Page_Live"."VideoMP4ID", "Page_Live"."VideoOGVID", "Page_Live"."ImageID", "SiteTree_Live"."ID", CASE WHEN "SiteTree_Live"."ClassName" IS NOT NULL THEN "SiteTree_Live"."ClassName" ELSE 'SilverStripe\\CMS\\Model\\SiteTree' END AS "RecordClassName", 'fr_FR' AS "Locale", CASE WHEN "Page_Localised_fr_FR"."ID" IS NOT NULL THEN 'fr_FR' WHEN "Page_Localised_de_DE"."ID" IS NOT NULL THEN 'de_DE' ELSE NULL END AS "SourceLocale" FROM "SiteTree_Live" LEFT JOIN "Page_Live" ON "Page_Live"."ID" = "SiteTree_Live"."ID" LEFT JOIN "SiteTree_Localised_Live" AS "SiteTree_Localised_fr_FR" ON "SiteTree_Live"."ID" = "SiteTree_Localised_fr_FR"."RecordID" AND "SiteTree_Localised_fr_FR"."Locale" = ? 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" = ? LEFT JOIN "Page_Localised_Live" AS "Page_Localised_fr_FR" ON "Page_Live"."ID" = "Page_Localised_fr_FR"."RecordID" AND "Page_Localised_fr_FR"."Locale" = ? LEFT JOIN "Page_Localised_Live" AS "Page_Localised_de_DE" ON "Page_Live"."ID" = "Page_Localised_de_DE"."RecordID" AND "Page_Localised_de_DE"."Locale" = ? WHERE ("SiteTree_Live"."ID" = ?) AND ("SiteTree_Live"."ClassName" IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)) AND (("SiteTree_Localised_fr_FR"."ID" IS NOT NULL) OR ("SiteTree_Localised_de_DE"."ID" IS NOT NULL)) ORDER BY "SiteTree_Live"."Sort" ASC LIMIT 1 0.0005s
0057: SELECT sd.Domain From SubsiteDomain sd WHERE sd.SubsiteID = 2 AND sd.Locale = 'fr_FR' 0.0001s
0058: SELECT "Domain" FROM "SubsiteDomain" WHERE "SubsiteID" = ? AND "Locale" = ? 0.0002s
0059: SELECT DISTINCT "Subsite"."ClassName", "Subsite"."LastEdited", "Subsite"."Created", "Subsite"."Sort", "Subsite"."HomeBusinessSchemaType", "Subsite"."Title", "Subsite"."RedirectURL", "Subsite"."DefaultSite", "Subsite"."Theme", "Subsite"."Language", "Subsite"."IsPublic", "Subsite"."PageTypeBlacklist", "Subsite"."ID", CASE WHEN "Subsite"."ClassName" IS NOT NULL THEN "Subsite"."ClassName" ELSE 'SilverStripe\\Subsites\\Model\\Subsite' END AS "RecordClassName" FROM "Subsite" WHERE ("Subsite"."ID" = ?) ORDER BY "Subsite"."Title" ASC LIMIT 1 0.0002s
0060: SELECT DISTINCT "SubsiteDomain"."ClassName", "SubsiteDomain"."LastEdited", "SubsiteDomain"."Created", "SubsiteDomain"."Locale", "SubsiteDomain"."Domain", "SubsiteDomain"."Protocol", "SubsiteDomain"."IsPrimary", "SubsiteDomain"."SubsiteID", "SubsiteDomain"."ID", CASE WHEN "SubsiteDomain"."ClassName" IS NOT NULL THEN "SubsiteDomain"."ClassName" ELSE 'SilverStripe\\Subsites\\Model\\SubsiteDomain' END AS "RecordClassName" FROM "SubsiteDomain" WHERE ("SubsiteDomain"."SubsiteID" = ?) ORDER BY "SubsiteDomain"."IsPrimary" DESC LIMIT 1 0.0002s
0061: SELECT DISTINCT "File_Live"."ClassName", "File_Live"."LastEdited", "File_Live"."Created", "File_Live"."UserFormUpload", "File_Live"."Version", "File_Live"."CanViewType", "File_Live"."CanEditType", "File_Live"."Name", "File_Live"."Title", "File_Live"."ShowInSearch", "File_Live"."IsFolder", "File_Live"."SubsiteID", "File_Live"."ParentID", "File_Live"."OwnerID", "File_Live"."FileHash", "File_Live"."FileFilename", "File_Live"."FileVariant", "Image_Live"."AltText", "Image_Live"."CropData", "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.0003s
0062: SELECT "Domain" FROM "SubsiteDomain" WHERE "SubsiteID" = ? AND "Locale" = ? 0.0002s
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"."IsFolder", "File_Live"."SubsiteID", "File_Live"."ParentID", "File_Live"."OwnerID", "File_Live"."FileHash", "File_Live"."FileFilename", "File_Live"."FileVariant", "Image_Live"."AltText", "Image_Live"."CropData", "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.0003s
0064: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", "SiteTree_Live"."CanViewType", "SiteTree_Live"."CanEditType", "SiteTree_Live"."Version", 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"."URLSegment" ELSE "SiteTree_Live"."URLSegment" END AS "URLSegment", 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_Live"."ClassName" IN ('SilverStripe\\CMS\\Model\\SiteTree', 'Page', 'AlternativeLandingPage', 'ApplicationFormPage', 'ContactPage', 'ElementalPage', 'HomePage', 'VIPChipRegistrationPage', 'MoritzSauer\\EventCalendar\\EventCalendarPage', 'SilverStripe\\ErrorPage\\ErrorPage', 'Job\\JobsPage', 'Tietge\\SocialWall\\SocialPage', 'Team\\Pages\\TeamPage', 'SilverStripe\\Blog\\Model\\Blog', 'SilverStripe\\Blog\\Model\\BlogPost', 'SilverStripe\\CMS\\Model\\RedirectorPage', 'SilverStripe\\CMS\\Model\\VirtualPage', 'SilverStripe\\UserForms\\Model\\UserDefinedForm', 'XD\\Events\\Model\\EventPage', 'XD\\Events\\Model\\EventsPage', 'SilverStripe\\Subsites\\Pages\\SubsitesVirtualPage') THEN "SiteTree_Live"."Content" WHEN "SiteTree_Live"."ClassName" IN ('Page', 'AlternativeLandingPage', 'ApplicationFormPage', 'ContactPage', 'ElementalPage', 'HomePage', 'VIPChipRegistrationPage', 'MoritzSauer\\EventCalendar\\EventCalendarPage', 'SilverStripe\\ErrorPage\\ErrorPage', 'Job\\JobsPage', 'Tietge\\SocialWall\\SocialPage', 'Team\\Pages\\TeamPage', 'SilverStripe\\Blog\\Model\\Blog', 'SilverStripe\\Blog\\Model\\BlogPost', 'SilverStripe\\CMS\\Model\\RedirectorPage', 'SilverStripe\\CMS\\Model\\VirtualPage', 'SilverStripe\\UserForms\\Model\\UserDefinedForm', 'XD\\Events\\Model\\EventPage', 'XD\\Events\\Model\\EventsPage', 'SilverStripe\\Subsites\\Pages\\SubsitesVirtualPage') THEN "Page_Live"."Content" WHEN "SiteTree_Live"."ClassName" IN ('Page', 'AlternativeLandingPage', 'ApplicationFormPage', 'ContactPage', 'ElementalPage', 'HomePage', 'VIPChipRegistrationPage', 'MoritzSauer\\EventCalendar\\EventCalendarPage', 'SilverStripe\\ErrorPage\\ErrorPage', 'Job\\JobsPage', 'Tietge\\SocialWall\\SocialPage', 'Team\\Pages\\TeamPage', 'SilverStripe\\Blog\\Model\\Blog', 'SilverStripe\\Blog\\Model\\BlogPost', 'SilverStripe\\CMS\\Model\\RedirectorPage', 'SilverStripe\\CMS\\Model\\VirtualPage', 'SilverStripe\\UserForms\\Model\\UserDefinedForm', 'XD\\Events\\Model\\EventPage', 'XD\\Events\\Model\\EventsPage', 'SilverStripe\\Subsites\\Pages\\SubsitesVirtualPage') THEN "Page_Live"."Content" ELSE NULL 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"."SubsiteID", "SiteTree_Live"."ParentID", CASE WHEN "Page_Localised_de_DE"."ID" IS NOT NULL THEN "Page_Localised_de_DE"."OGTitleCustom" ELSE "Page_Live"."OGTitleCustom" END AS "OGTitleCustom", CASE WHEN "Page_Localised_de_DE"."ID" IS NOT NULL THEN "Page_Localised_de_DE"."OGDescriptionCustom" ELSE "Page_Live"."OGDescriptionCustom" END AS "OGDescriptionCustom", CASE WHEN "Page_Localised_de_DE"."ID" IS NOT NULL THEN "Page_Localised_de_DE"."SubTitle" ELSE "Page_Live"."SubTitle" END AS "SubTitle", "Page_Live"."ShowInLegalMenu", CASE WHEN "Page_Localised_de_DE"."ID" IS NOT NULL THEN "Page_Localised_de_DE"."MetaTitle" ELSE "Page_Live"."MetaTitle" END AS "MetaTitle", "Page_Live"."ShowInNaviEingeklappt", "Page_Live"."ShowNewsletterInFooter", "Page_Live"."ShowPageHeaderGradient", "Page_Live"."OGImageCustomID", "Page_Live"."PinterestImageCustomID", "Page_Live"."HeaderImageID", "Page_Live"."VideoMP4ID", "Page_Live"."VideoOGVID", "Page_Live"."ImageID", "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 "Page_Localised_de_DE"."ID" IS NOT NULL THEN 'de_DE' ELSE NULL END AS "SourceLocale" FROM "SiteTree_Live" LEFT JOIN "Page_Live" ON "Page_Live"."ID" = "SiteTree_Live"."ID" 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" = ? LEFT JOIN "Page_Localised_Live" AS "Page_Localised_de_DE" ON "Page_Live"."ID" = "Page_Localised_de_DE"."RecordID" AND "Page_Localised_de_DE"."Locale" = ? WHERE ("SiteTree_Live"."ID" = ?) AND ("SiteTree_Live"."ClassName" IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)) AND (("SiteTree_Localised_de_DE"."ID" IS NOT NULL)) ORDER BY "SiteTree_Live"."Sort" ASC LIMIT 1 0.0005s
0065: SELECT sd.Domain From SubsiteDomain sd WHERE sd.SubsiteID = 2 AND sd.Locale = 'de_DE' 0.0001s
0066: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", "SiteTree_Live"."CanViewType", "SiteTree_Live"."CanEditType", "SiteTree_Live"."Version", CASE WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."Title" 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_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."URLSegment" 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_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."MenuTitle" 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_Live"."ClassName" IN ('SilverStripe\\CMS\\Model\\SiteTree', 'Page', 'AlternativeLandingPage', 'ApplicationFormPage', 'ContactPage', 'ElementalPage', 'HomePage', 'VIPChipRegistrationPage', 'MoritzSauer\\EventCalendar\\EventCalendarPage', 'SilverStripe\\ErrorPage\\ErrorPage', 'Job\\JobsPage', 'Tietge\\SocialWall\\SocialPage', 'Team\\Pages\\TeamPage', 'SilverStripe\\Blog\\Model\\Blog', 'SilverStripe\\Blog\\Model\\BlogPost', 'SilverStripe\\CMS\\Model\\RedirectorPage', 'SilverStripe\\CMS\\Model\\VirtualPage', 'SilverStripe\\UserForms\\Model\\UserDefinedForm', 'XD\\Events\\Model\\EventPage', 'XD\\Events\\Model\\EventsPage', 'SilverStripe\\Subsites\\Pages\\SubsitesVirtualPage') THEN "SiteTree_Live"."Content" WHEN "SiteTree_Live"."ClassName" IN ('Page', 'AlternativeLandingPage', 'ApplicationFormPage', 'ContactPage', 'ElementalPage', 'HomePage', 'VIPChipRegistrationPage', 'MoritzSauer\\EventCalendar\\EventCalendarPage', 'SilverStripe\\ErrorPage\\ErrorPage', 'Job\\JobsPage', 'Tietge\\SocialWall\\SocialPage', 'Team\\Pages\\TeamPage', 'SilverStripe\\Blog\\Model\\Blog', 'SilverStripe\\Blog\\Model\\BlogPost', 'SilverStripe\\CMS\\Model\\RedirectorPage', 'SilverStripe\\CMS\\Model\\VirtualPage', 'SilverStripe\\UserForms\\Model\\UserDefinedForm', 'XD\\Events\\Model\\EventPage', 'XD\\Events\\Model\\EventsPage', 'SilverStripe\\Subsites\\Pages\\SubsitesVirtualPage') THEN "Page_Live"."Content" WHEN "SiteTree_Live"."ClassName" IN ('Page', 'AlternativeLandingPage', 'ApplicationFormPage', 'ContactPage', 'ElementalPage', 'HomePage', 'VIPChipRegistrationPage', 'MoritzSauer\\EventCalendar\\EventCalendarPage', 'SilverStripe\\ErrorPage\\ErrorPage', 'Job\\JobsPage', 'Tietge\\SocialWall\\SocialPage', 'Team\\Pages\\TeamPage', 'SilverStripe\\Blog\\Model\\Blog', 'SilverStripe\\Blog\\Model\\BlogPost', 'SilverStripe\\CMS\\Model\\RedirectorPage', 'SilverStripe\\CMS\\Model\\VirtualPage', 'SilverStripe\\UserForms\\Model\\UserDefinedForm', 'XD\\Events\\Model\\EventPage', 'XD\\Events\\Model\\EventsPage', 'SilverStripe\\Subsites\\Pages\\SubsitesVirtualPage') THEN "Page_Live"."Content" ELSE NULL END AS "Content", CASE WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."MetaDescription" 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_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."ReportClass" WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."ReportClass" ELSE "SiteTree_Live"."ReportClass" END AS "ReportClass", "SiteTree_Live"."SubsiteID", "SiteTree_Live"."ParentID", CASE WHEN "Page_Localised_en_US"."ID" IS NOT NULL THEN "Page_Localised_en_US"."OGTitleCustom" WHEN "Page_Localised_de_DE"."ID" IS NOT NULL THEN "Page_Localised_de_DE"."OGTitleCustom" ELSE "Page_Live"."OGTitleCustom" END AS "OGTitleCustom", CASE WHEN "Page_Localised_en_US"."ID" IS NOT NULL THEN "Page_Localised_en_US"."OGDescriptionCustom" WHEN "Page_Localised_de_DE"."ID" IS NOT NULL THEN "Page_Localised_de_DE"."OGDescriptionCustom" ELSE "Page_Live"."OGDescriptionCustom" END AS "OGDescriptionCustom", CASE WHEN "Page_Localised_en_US"."ID" IS NOT NULL THEN "Page_Localised_en_US"."SubTitle" WHEN "Page_Localised_de_DE"."ID" IS NOT NULL THEN "Page_Localised_de_DE"."SubTitle" ELSE "Page_Live"."SubTitle" END AS "SubTitle", "Page_Live"."ShowInLegalMenu", CASE WHEN "Page_Localised_en_US"."ID" IS NOT NULL THEN "Page_Localised_en_US"."MetaTitle" WHEN "Page_Localised_de_DE"."ID" IS NOT NULL THEN "Page_Localised_de_DE"."MetaTitle" ELSE "Page_Live"."MetaTitle" END AS "MetaTitle", "Page_Live"."ShowInNaviEingeklappt", "Page_Live"."ShowNewsletterInFooter", "Page_Live"."ShowPageHeaderGradient", "Page_Live"."OGImageCustomID", "Page_Live"."PinterestImageCustomID", "Page_Live"."HeaderImageID", "Page_Live"."VideoMP4ID", "Page_Live"."VideoOGVID", "Page_Live"."ImageID", "SiteTree_Live"."ID", CASE WHEN "SiteTree_Live"."ClassName" IS NOT NULL THEN "SiteTree_Live"."ClassName" ELSE 'SilverStripe\\CMS\\Model\\SiteTree' END AS "RecordClassName", 'en_US' AS "Locale", CASE WHEN "Page_Localised_en_US"."ID" IS NOT NULL THEN 'en_US' WHEN "Page_Localised_de_DE"."ID" IS NOT NULL THEN 'de_DE' ELSE NULL END AS "SourceLocale" FROM "SiteTree_Live" LEFT JOIN "Page_Live" ON "Page_Live"."ID" = "SiteTree_Live"."ID" LEFT JOIN "SiteTree_Localised_Live" AS "SiteTree_Localised_en_US" ON "SiteTree_Live"."ID" = "SiteTree_Localised_en_US"."RecordID" AND "SiteTree_Localised_en_US"."Locale" = ? LEFT JOIN "SiteTree_Localised_Live" AS "SiteTree_Localised_de_DE" ON "SiteTree_Live"."ID" = "SiteTree_Localised_de_DE"."RecordID" AND "SiteTree_Localised_de_DE"."Locale" = ? LEFT JOIN "Page_Localised_Live" AS "Page_Localised_en_US" ON "Page_Live"."ID" = "Page_Localised_en_US"."RecordID" AND "Page_Localised_en_US"."Locale" = ? LEFT JOIN "Page_Localised_Live" AS "Page_Localised_de_DE" ON "Page_Live"."ID" = "Page_Localised_de_DE"."RecordID" AND "Page_Localised_de_DE"."Locale" = ? WHERE ("SiteTree_Live"."ID" = ?) AND ("SiteTree_Live"."ClassName" IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)) AND (("SiteTree_Localised_en_US"."ID" IS NOT NULL) OR ("SiteTree_Localised_de_DE"."ID" IS NOT NULL)) ORDER BY "SiteTree_Live"."Sort" ASC LIMIT 1 0.0005s
0067: SELECT sd.Domain From SubsiteDomain sd WHERE sd.SubsiteID = 2 AND sd.Locale = 'en_US' 0.0001s
0068: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", "SiteTree_Live"."CanViewType", "SiteTree_Live"."CanEditType", "SiteTree_Live"."Version", CASE WHEN "SiteTree_Localised_fr_FR"."ID" IS NOT NULL THEN "SiteTree_Localised_fr_FR"."Title" 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_fr_FR"."ID" IS NOT NULL THEN "SiteTree_Localised_fr_FR"."URLSegment" 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_fr_FR"."ID" IS NOT NULL THEN "SiteTree_Localised_fr_FR"."MenuTitle" 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_Live"."ClassName" IN ('SilverStripe\\CMS\\Model\\SiteTree', 'Page', 'AlternativeLandingPage', 'ApplicationFormPage', 'ContactPage', 'ElementalPage', 'HomePage', 'VIPChipRegistrationPage', 'MoritzSauer\\EventCalendar\\EventCalendarPage', 'SilverStripe\\ErrorPage\\ErrorPage', 'Job\\JobsPage', 'Tietge\\SocialWall\\SocialPage', 'Team\\Pages\\TeamPage', 'SilverStripe\\Blog\\Model\\Blog', 'SilverStripe\\Blog\\Model\\BlogPost', 'SilverStripe\\CMS\\Model\\RedirectorPage', 'SilverStripe\\CMS\\Model\\VirtualPage', 'SilverStripe\\UserForms\\Model\\UserDefinedForm', 'XD\\Events\\Model\\EventPage', 'XD\\Events\\Model\\EventsPage', 'SilverStripe\\Subsites\\Pages\\SubsitesVirtualPage') THEN "SiteTree_Live"."Content" WHEN "SiteTree_Live"."ClassName" IN ('Page', 'AlternativeLandingPage', 'ApplicationFormPage', 'ContactPage', 'ElementalPage', 'HomePage', 'VIPChipRegistrationPage', 'MoritzSauer\\EventCalendar\\EventCalendarPage', 'SilverStripe\\ErrorPage\\ErrorPage', 'Job\\JobsPage', 'Tietge\\SocialWall\\SocialPage', 'Team\\Pages\\TeamPage', 'SilverStripe\\Blog\\Model\\Blog', 'SilverStripe\\Blog\\Model\\BlogPost', 'SilverStripe\\CMS\\Model\\RedirectorPage', 'SilverStripe\\CMS\\Model\\VirtualPage', 'SilverStripe\\UserForms\\Model\\UserDefinedForm', 'XD\\Events\\Model\\EventPage', 'XD\\Events\\Model\\EventsPage', 'SilverStripe\\Subsites\\Pages\\SubsitesVirtualPage') THEN "Page_Live"."Content" WHEN "SiteTree_Live"."ClassName" IN ('Page', 'AlternativeLandingPage', 'ApplicationFormPage', 'ContactPage', 'ElementalPage', 'HomePage', 'VIPChipRegistrationPage', 'MoritzSauer\\EventCalendar\\EventCalendarPage', 'SilverStripe\\ErrorPage\\ErrorPage', 'Job\\JobsPage', 'Tietge\\SocialWall\\SocialPage', 'Team\\Pages\\TeamPage', 'SilverStripe\\Blog\\Model\\Blog', 'SilverStripe\\Blog\\Model\\BlogPost', 'SilverStripe\\CMS\\Model\\RedirectorPage', 'SilverStripe\\CMS\\Model\\VirtualPage', 'SilverStripe\\UserForms\\Model\\UserDefinedForm', 'XD\\Events\\Model\\EventPage', 'XD\\Events\\Model\\EventsPage', 'SilverStripe\\Subsites\\Pages\\SubsitesVirtualPage') THEN "Page_Live"."Content" ELSE NULL END AS "Content", CASE WHEN "SiteTree_Localised_fr_FR"."ID" IS NOT NULL THEN "SiteTree_Localised_fr_FR"."MetaDescription" 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_fr_FR"."ID" IS NOT NULL THEN "SiteTree_Localised_fr_FR"."ReportClass" WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."ReportClass" ELSE "SiteTree_Live"."ReportClass" END AS "ReportClass", "SiteTree_Live"."SubsiteID", "SiteTree_Live"."ParentID", CASE WHEN "Page_Localised_fr_FR"."ID" IS NOT NULL THEN "Page_Localised_fr_FR"."OGTitleCustom" WHEN "Page_Localised_de_DE"."ID" IS NOT NULL THEN "Page_Localised_de_DE"."OGTitleCustom" ELSE "Page_Live"."OGTitleCustom" END AS "OGTitleCustom", CASE WHEN "Page_Localised_fr_FR"."ID" IS NOT NULL THEN "Page_Localised_fr_FR"."OGDescriptionCustom" WHEN "Page_Localised_de_DE"."ID" IS NOT NULL THEN "Page_Localised_de_DE"."OGDescriptionCustom" ELSE "Page_Live"."OGDescriptionCustom" END AS "OGDescriptionCustom", CASE WHEN "Page_Localised_fr_FR"."ID" IS NOT NULL THEN "Page_Localised_fr_FR"."SubTitle" WHEN "Page_Localised_de_DE"."ID" IS NOT NULL THEN "Page_Localised_de_DE"."SubTitle" ELSE "Page_Live"."SubTitle" END AS "SubTitle", "Page_Live"."ShowInLegalMenu", CASE WHEN "Page_Localised_fr_FR"."ID" IS NOT NULL THEN "Page_Localised_fr_FR"."MetaTitle" WHEN "Page_Localised_de_DE"."ID" IS NOT NULL THEN "Page_Localised_de_DE"."MetaTitle" ELSE "Page_Live"."MetaTitle" END AS "MetaTitle", "Page_Live"."ShowInNaviEingeklappt", "Page_Live"."ShowNewsletterInFooter", "Page_Live"."ShowPageHeaderGradient", "Page_Live"."OGImageCustomID", "Page_Live"."PinterestImageCustomID", "Page_Live"."HeaderImageID", "Page_Live"."VideoMP4ID", "Page_Live"."VideoOGVID", "Page_Live"."ImageID", "SiteTree_Live"."ID", CASE WHEN "SiteTree_Live"."ClassName" IS NOT NULL THEN "SiteTree_Live"."ClassName" ELSE 'SilverStripe\\CMS\\Model\\SiteTree' END AS "RecordClassName", 'fr_FR' AS "Locale", CASE WHEN "Page_Localised_fr_FR"."ID" IS NOT NULL THEN 'fr_FR' WHEN "Page_Localised_de_DE"."ID" IS NOT NULL THEN 'de_DE' ELSE NULL END AS "SourceLocale" FROM "SiteTree_Live" LEFT JOIN "Page_Live" ON "Page_Live"."ID" = "SiteTree_Live"."ID" LEFT JOIN "SiteTree_Localised_Live" AS "SiteTree_Localised_fr_FR" ON "SiteTree_Live"."ID" = "SiteTree_Localised_fr_FR"."RecordID" AND "SiteTree_Localised_fr_FR"."Locale" = ? 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" = ? LEFT JOIN "Page_Localised_Live" AS "Page_Localised_fr_FR" ON "Page_Live"."ID" = "Page_Localised_fr_FR"."RecordID" AND "Page_Localised_fr_FR"."Locale" = ? LEFT JOIN "Page_Localised_Live" AS "Page_Localised_de_DE" ON "Page_Live"."ID" = "Page_Localised_de_DE"."RecordID" AND "Page_Localised_de_DE"."Locale" = ? WHERE ("SiteTree_Live"."ID" = ?) AND ("SiteTree_Live"."ClassName" IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)) AND (("SiteTree_Localised_fr_FR"."ID" IS NOT NULL) OR ("SiteTree_Localised_de_DE"."ID" IS NOT NULL)) ORDER BY "SiteTree_Live"."Sort" ASC LIMIT 1 0.0006s
0069: SELECT sd.Domain From SubsiteDomain sd WHERE sd.SubsiteID = 2 AND sd.Locale = 'fr_FR' 0.0001s
0070: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "ElementalPage_Live"."ElementalAreaID", CASE WHEN "SiteTree_Live"."ClassName" IN ('SilverStripe\\CMS\\Model\\SiteTree', 'Page', 'AlternativeLandingPage', 'ApplicationFormPage', 'ContactPage', 'ElementalPage', 'HomePage', 'VIPChipRegistrationPage', 'MoritzSauer\\EventCalendar\\EventCalendarPage', 'SilverStripe\\ErrorPage\\ErrorPage', 'Job\\JobsPage', 'Tietge\\SocialWall\\SocialPage', 'Team\\Pages\\TeamPage', 'SilverStripe\\Blog\\Model\\Blog', 'SilverStripe\\Blog\\Model\\BlogPost', 'SilverStripe\\CMS\\Model\\RedirectorPage', 'SilverStripe\\CMS\\Model\\VirtualPage', 'SilverStripe\\UserForms\\Model\\UserDefinedForm', 'XD\\Events\\Model\\EventPage', 'XD\\Events\\Model\\EventsPage', 'SilverStripe\\Subsites\\Pages\\SubsitesVirtualPage') THEN "SiteTree_Live"."Content" WHEN "SiteTree_Live"."ClassName" IN ('Page', 'AlternativeLandingPage', 'ApplicationFormPage', 'ContactPage', 'ElementalPage', 'HomePage', 'VIPChipRegistrationPage', 'MoritzSauer\\EventCalendar\\EventCalendarPage', 'SilverStripe\\ErrorPage\\ErrorPage', 'Job\\JobsPage', 'Tietge\\SocialWall\\SocialPage', 'Team\\Pages\\TeamPage', 'SilverStripe\\Blog\\Model\\Blog', 'SilverStripe\\Blog\\Model\\BlogPost', 'SilverStripe\\CMS\\Model\\RedirectorPage', 'SilverStripe\\CMS\\Model\\VirtualPage', 'SilverStripe\\UserForms\\Model\\UserDefinedForm', 'XD\\Events\\Model\\EventPage', 'XD\\Events\\Model\\EventsPage', 'SilverStripe\\Subsites\\Pages\\SubsitesVirtualPage') THEN "Page_Live"."Content" ELSE NULL END AS "Content", "SiteTree_Live"."ID", CASE WHEN "SiteTree_Live"."ClassName" IS NOT NULL THEN "SiteTree_Live"."ClassName" ELSE 'SilverStripe\\CMS\\Model\\SiteTree' END AS "RecordClassName", 'en_US' AS "Locale", CASE WHEN "Page_Localised_en_US"."ID" IS NOT NULL THEN 'en_US' WHEN "Page_Localised_de_DE"."ID" IS NOT NULL THEN 'de_DE' ELSE NULL END AS "SourceLocale", "SiteTree_Live"."Sort" FROM "SiteTree_Live" LEFT JOIN "Page_Live" ON "Page_Live"."ID" = "SiteTree_Live"."ID" LEFT JOIN "ElementalPage_Live" ON "ElementalPage_Live"."ID" = "SiteTree_Live"."ID" LEFT JOIN "SiteTree_Localised_Live" AS "SiteTree_Localised_en_US" ON "SiteTree_Live"."ID" = "SiteTree_Localised_en_US"."RecordID" AND "SiteTree_Localised_en_US"."Locale" = ? LEFT JOIN "SiteTree_Localised_Live" AS "SiteTree_Localised_de_DE" ON "SiteTree_Live"."ID" = "SiteTree_Localised_de_DE"."RecordID" AND "SiteTree_Localised_de_DE"."Locale" = ? LEFT JOIN "Page_Localised_Live" AS "Page_Localised_en_US" ON "Page_Live"."ID" = "Page_Localised_en_US"."RecordID" AND "Page_Localised_en_US"."Locale" = ? LEFT JOIN "Page_Localised_Live" AS "Page_Localised_de_DE" ON "Page_Live"."ID" = "Page_Localised_de_DE"."RecordID" AND "Page_Localised_de_DE"."Locale" = ? WHERE ("SiteTree_Live"."ID" = ?) AND ("SiteTree_Live"."ClassName" IN (?)) AND (("SiteTree_Localised_en_US"."ID" IS NOT NULL) OR ("SiteTree_Localised_de_DE"."ID" IS NOT NULL)) ORDER BY "SiteTree_Live"."Sort" ASC LIMIT 1 0.0004s
0071: SELECT DISTINCT "ElementalArea_Live"."ClassName", "ElementalArea_Live"."LastEdited", "ElementalArea_Live"."Created", "ElementalArea_Live"."Version", "ElementalArea_Live"."OwnerClassName", "ElementalArea_Live"."TopPageID", "ElementalArea_Live"."ID", CASE WHEN "ElementalArea_Live"."ClassName" IS NOT NULL THEN "ElementalArea_Live"."ClassName" ELSE 'DNADesign\\Elemental\\Models\\ElementalArea' END AS "RecordClassName" FROM "ElementalArea_Live" WHERE ("ElementalArea_Live"."ID" = ?) LIMIT 1 0.0002s
0072: SELECT DISTINCT "Element_Live"."ClassName", "Element_Live"."LastEdited", "Element_Live"."Created", "Element_Live"."AvailableGlobally", CASE WHEN "Element_Localised_en_US"."ID" IS NOT NULL THEN "Element_Localised_en_US"."VirtualLookupTitle" WHEN "Element_Localised_de_DE"."ID" IS NOT NULL THEN "Element_Localised_de_DE"."VirtualLookupTitle" ELSE "Element_Live"."VirtualLookupTitle" END AS "VirtualLookupTitle", CASE WHEN "Element_Localised_en_US"."ID" IS NOT NULL THEN "Element_Localised_en_US"."MenuTitle" WHEN "Element_Localised_de_DE"."ID" IS NOT NULL THEN "Element_Localised_de_DE"."MenuTitle" ELSE "Element_Live"."MenuTitle" END AS "MenuTitle", "Element_Live"."ShowInMenus", CASE WHEN "Element_Localised_en_US"."ID" IS NOT NULL THEN "Element_Localised_en_US"."HeadlineTag" WHEN "Element_Localised_de_DE"."ID" IS NOT NULL THEN "Element_Localised_de_DE"."HeadlineTag" ELSE "Element_Live"."HeadlineTag" END AS "HeadlineTag", CASE WHEN "Element_Localised_en_US"."ID" IS NOT NULL THEN "Element_Localised_en_US"."OpticalHeadline" WHEN "Element_Localised_de_DE"."ID" IS NOT NULL THEN "Element_Localised_de_DE"."OpticalHeadline" ELSE "Element_Live"."OpticalHeadline" END AS "OpticalHeadline", "Element_Live"."Version", CASE WHEN "Element_Localised_en_US"."ID" IS NOT NULL THEN "Element_Localised_en_US"."Title" WHEN "Element_Localised_de_DE"."ID" IS NOT NULL THEN "Element_Localised_de_DE"."Title" ELSE "Element_Live"."Title" END AS "Title", "Element_Live"."ShowTitle", "Element_Live"."Sort", CASE WHEN "Element_Localised_en_US"."ID" IS NOT NULL THEN "Element_Localised_en_US"."ExtraClass" WHEN "Element_Localised_de_DE"."ID" IS NOT NULL THEN "Element_Localised_de_DE"."ExtraClass" ELSE "Element_Live"."ExtraClass" END AS "ExtraClass", CASE WHEN "Element_Localised_en_US"."ID" IS NOT NULL THEN "Element_Localised_en_US"."Style" WHEN "Element_Localised_de_DE"."ID" IS NOT NULL THEN "Element_Localised_de_DE"."Style" ELSE "Element_Live"."Style" END AS "Style", "Element_Live"."TopPageID", "Element_Live"."ParentID", "Element_Live"."ID", CASE WHEN "Element_Live"."ClassName" IS NOT NULL THEN "Element_Live"."ClassName" ELSE 'DNADesign\\Elemental\\Models\\BaseElement' END AS "RecordClassName", 'en_US' AS "Locale", CASE WHEN "Element_Localised_en_US"."ID" IS NOT NULL THEN 'en_US' WHEN "Element_Localised_de_DE"."ID" IS NOT NULL THEN 'de_DE' ELSE NULL END AS "SourceLocale" FROM "Element_Live" LEFT JOIN "Element_Localised" AS "Element_Localised_en_US" ON "Element_Live"."ID" = "Element_Localised_en_US"."RecordID" AND "Element_Localised_en_US"."Locale" = ? LEFT JOIN "Element_Localised" AS "Element_Localised_de_DE" ON "Element_Live"."ID" = "Element_Localised_de_DE"."RecordID" AND "Element_Localised_de_DE"."Locale" = ? WHERE ("Element_Live"."ParentID" = ?) AND (("Element_Localised_en_US"."ID" IS NOT NULL)) ORDER BY "Element_Live"."Sort" ASC 0.0005s
0073: SELECT DISTINCT "ElementalArea_Live"."ClassName", "ElementalArea_Live"."LastEdited", "ElementalArea_Live"."Created", "ElementalArea_Live"."Version", "ElementalArea_Live"."OwnerClassName", "ElementalArea_Live"."TopPageID", "ElementalArea_Live"."ID", CASE WHEN "ElementalArea_Live"."ClassName" IS NOT NULL THEN "ElementalArea_Live"."ClassName" ELSE 'DNADesign\\Elemental\\Models\\ElementalArea' END AS "RecordClassName" FROM "ElementalArea_Live" WHERE ("ElementalArea_Live"."ID" = ?) LIMIT 1 0.0002s
0074: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", "SiteTree_Live"."CanViewType", "SiteTree_Live"."CanEditType", "SiteTree_Live"."Version", CASE WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."Title" 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_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."URLSegment" 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_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."MenuTitle" 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_Live"."ClassName" IN ('SilverStripe\\CMS\\Model\\SiteTree', 'Page', 'AlternativeLandingPage', 'ApplicationFormPage', 'ContactPage', 'ElementalPage', 'HomePage', 'VIPChipRegistrationPage', 'MoritzSauer\\EventCalendar\\EventCalendarPage', 'SilverStripe\\ErrorPage\\ErrorPage', 'Job\\JobsPage', 'Tietge\\SocialWall\\SocialPage', 'Team\\Pages\\TeamPage', 'SilverStripe\\Blog\\Model\\Blog', 'SilverStripe\\Blog\\Model\\BlogPost', 'SilverStripe\\CMS\\Model\\RedirectorPage', 'SilverStripe\\CMS\\Model\\VirtualPage', 'SilverStripe\\UserForms\\Model\\UserDefinedForm', 'XD\\Events\\Model\\EventPage', 'XD\\Events\\Model\\EventsPage', 'SilverStripe\\Subsites\\Pages\\SubsitesVirtualPage') THEN "SiteTree_Live"."Content" WHEN "SiteTree_Live"."ClassName" IN ('Page', 'AlternativeLandingPage', 'ApplicationFormPage', 'ContactPage', 'ElementalPage', 'HomePage', 'VIPChipRegistrationPage', 'MoritzSauer\\EventCalendar\\EventCalendarPage', 'SilverStripe\\ErrorPage\\ErrorPage', 'Job\\JobsPage', 'Tietge\\SocialWall\\SocialPage', 'Team\\Pages\\TeamPage', 'SilverStripe\\Blog\\Model\\Blog', 'SilverStripe\\Blog\\Model\\BlogPost', 'SilverStripe\\CMS\\Model\\RedirectorPage', 'SilverStripe\\CMS\\Model\\VirtualPage', 'SilverStripe\\UserForms\\Model\\UserDefinedForm', 'XD\\Events\\Model\\EventPage', 'XD\\Events\\Model\\EventsPage', 'SilverStripe\\Subsites\\Pages\\SubsitesVirtualPage') THEN "Page_Live"."Content" WHEN "SiteTree_Live"."ClassName" IN ('Page', 'AlternativeLandingPage', 'ApplicationFormPage', 'ContactPage', 'ElementalPage', 'HomePage', 'VIPChipRegistrationPage', 'MoritzSauer\\EventCalendar\\EventCalendarPage', 'SilverStripe\\ErrorPage\\ErrorPage', 'Job\\JobsPage', 'Tietge\\SocialWall\\SocialPage', 'Team\\Pages\\TeamPage', 'SilverStripe\\Blog\\Model\\Blog', 'SilverStripe\\Blog\\Model\\BlogPost', 'SilverStripe\\CMS\\Model\\RedirectorPage', 'SilverStripe\\CMS\\Model\\VirtualPage', 'SilverStripe\\UserForms\\Model\\UserDefinedForm', 'XD\\Events\\Model\\EventPage', 'XD\\Events\\Model\\EventsPage', 'SilverStripe\\Subsites\\Pages\\SubsitesVirtualPage') THEN "Page_Live"."Content" ELSE NULL END AS "Content", CASE WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."MetaDescription" 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_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."ReportClass" WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."ReportClass" ELSE "SiteTree_Live"."ReportClass" END AS "ReportClass", "SiteTree_Live"."SubsiteID", "SiteTree_Live"."ParentID", CASE WHEN "Page_Localised_en_US"."ID" IS NOT NULL THEN "Page_Localised_en_US"."OGTitleCustom" WHEN "Page_Localised_de_DE"."ID" IS NOT NULL THEN "Page_Localised_de_DE"."OGTitleCustom" ELSE "Page_Live"."OGTitleCustom" END AS "OGTitleCustom", CASE WHEN "Page_Localised_en_US"."ID" IS NOT NULL THEN "Page_Localised_en_US"."OGDescriptionCustom" WHEN "Page_Localised_de_DE"."ID" IS NOT NULL THEN "Page_Localised_de_DE"."OGDescriptionCustom" ELSE "Page_Live"."OGDescriptionCustom" END AS "OGDescriptionCustom", CASE WHEN "Page_Localised_en_US"."ID" IS NOT NULL THEN "Page_Localised_en_US"."SubTitle" WHEN "Page_Localised_de_DE"."ID" IS NOT NULL THEN "Page_Localised_de_DE"."SubTitle" ELSE "Page_Live"."SubTitle" END AS "SubTitle", "Page_Live"."ShowInLegalMenu", CASE WHEN "Page_Localised_en_US"."ID" IS NOT NULL THEN "Page_Localised_en_US"."MetaTitle" WHEN "Page_Localised_de_DE"."ID" IS NOT NULL THEN "Page_Localised_de_DE"."MetaTitle" ELSE "Page_Live"."MetaTitle" END AS "MetaTitle", "Page_Live"."ShowInNaviEingeklappt", "Page_Live"."ShowNewsletterInFooter", "Page_Live"."ShowPageHeaderGradient", "Page_Live"."OGImageCustomID", "Page_Live"."PinterestImageCustomID", "Page_Live"."HeaderImageID", "Page_Live"."VideoMP4ID", "Page_Live"."VideoOGVID", "Page_Live"."ImageID", "ElementalPage_Live"."ElementalAreaID", "SiteTree_Live"."ID", CASE WHEN "SiteTree_Live"."ClassName" IS NOT NULL THEN "SiteTree_Live"."ClassName" ELSE 'SilverStripe\\CMS\\Model\\SiteTree' END AS "RecordClassName", 'en_US' AS "Locale", CASE WHEN "Page_Localised_en_US"."ID" IS NOT NULL THEN 'en_US' WHEN "Page_Localised_de_DE"."ID" IS NOT NULL THEN 'de_DE' ELSE NULL END AS "SourceLocale" FROM "SiteTree_Live" LEFT JOIN "Page_Live" ON "Page_Live"."ID" = "SiteTree_Live"."ID" LEFT JOIN "ElementalPage_Live" ON "ElementalPage_Live"."ID" = "SiteTree_Live"."ID" LEFT JOIN "SiteTree_Localised_Live" AS "SiteTree_Localised_en_US" ON "SiteTree_Live"."ID" = "SiteTree_Localised_en_US"."RecordID" AND "SiteTree_Localised_en_US"."Locale" = ? LEFT JOIN "SiteTree_Localised_Live" AS "SiteTree_Localised_de_DE" ON "SiteTree_Live"."ID" = "SiteTree_Localised_de_DE"."RecordID" AND "SiteTree_Localised_de_DE"."Locale" = ? LEFT JOIN "Page_Localised_Live" AS "Page_Localised_en_US" ON "Page_Live"."ID" = "Page_Localised_en_US"."RecordID" AND "Page_Localised_en_US"."Locale" = ? LEFT JOIN "Page_Localised_Live" AS "Page_Localised_de_DE" ON "Page_Live"."ID" = "Page_Localised_de_DE"."RecordID" AND "Page_Localised_de_DE"."Locale" = ? WHERE ("ElementalPage_Live"."ElementalAreaID" = ?) AND ("SiteTree_Live"."ClassName" = ?) AND ("SiteTree_Live"."ClassName" IN (?)) AND ("SiteTree_Live"."SubsiteID" IN (2)) AND (("SiteTree_Localised_en_US"."ID" IS NOT NULL) OR ("SiteTree_Localised_de_DE"."ID" IS NOT NULL)) ORDER BY "SiteTree_Live"."Sort" ASC LIMIT 1 0.0007s
0075: SELECT DISTINCT "Element_Live"."ClassName", "Element_Live"."LastEdited", "Element_Live"."Created", "ElementVirtual_Live"."LinkedElementID", "Element_Live"."ID", CASE WHEN "Element_Live"."ClassName" IS NOT NULL THEN "Element_Live"."ClassName" ELSE 'DNADesign\\Elemental\\Models\\BaseElement' END AS "RecordClassName", 'en_US' AS "Locale", CASE WHEN "Element_Localised_en_US"."ID" IS NOT NULL THEN 'en_US' WHEN "Element_Localised_de_DE"."ID" IS NOT NULL THEN 'de_DE' ELSE NULL END AS "SourceLocale", "Element_Live"."Sort" FROM "Element_Live" LEFT JOIN "ElementVirtual_Live" ON "ElementVirtual_Live"."ID" = "Element_Live"."ID" LEFT JOIN "Element_Localised" AS "Element_Localised_en_US" ON "Element_Live"."ID" = "Element_Localised_en_US"."RecordID" AND "Element_Localised_en_US"."Locale" = ? LEFT JOIN "Element_Localised" AS "Element_Localised_de_DE" ON "Element_Live"."ID" = "Element_Localised_de_DE"."RecordID" AND "Element_Localised_de_DE"."Locale" = ? WHERE ("Element_Live"."ID" = ?) AND ("Element_Live"."ClassName" IN (?)) AND (("Element_Localised_en_US"."ID" IS NOT NULL)) ORDER BY "Element_Live"."Sort" ASC LIMIT 1 0.0004s
0076: SELECT DISTINCT "Element_Live"."ClassName", "Element_Live"."LastEdited", "Element_Live"."Created", "Element_Live"."AvailableGlobally", CASE WHEN "Element_Localised_en_US"."ID" IS NOT NULL THEN "Element_Localised_en_US"."VirtualLookupTitle" WHEN "Element_Localised_de_DE"."ID" IS NOT NULL THEN "Element_Localised_de_DE"."VirtualLookupTitle" ELSE "Element_Live"."VirtualLookupTitle" END AS "VirtualLookupTitle", CASE WHEN "Element_Localised_en_US"."ID" IS NOT NULL THEN "Element_Localised_en_US"."MenuTitle" WHEN "Element_Localised_de_DE"."ID" IS NOT NULL THEN "Element_Localised_de_DE"."MenuTitle" ELSE "Element_Live"."MenuTitle" END AS "MenuTitle", "Element_Live"."ShowInMenus", CASE WHEN "Element_Localised_en_US"."ID" IS NOT NULL THEN "Element_Localised_en_US"."HeadlineTag" WHEN "Element_Localised_de_DE"."ID" IS NOT NULL THEN "Element_Localised_de_DE"."HeadlineTag" ELSE "Element_Live"."HeadlineTag" END AS "HeadlineTag", CASE WHEN "Element_Localised_en_US"."ID" IS NOT NULL THEN "Element_Localised_en_US"."OpticalHeadline" WHEN "Element_Localised_de_DE"."ID" IS NOT NULL THEN "Element_Localised_de_DE"."OpticalHeadline" ELSE "Element_Live"."OpticalHeadline" END AS "OpticalHeadline", "Element_Live"."Version", CASE WHEN "Element_Localised_en_US"."ID" IS NOT NULL THEN "Element_Localised_en_US"."Title" WHEN "Element_Localised_de_DE"."ID" IS NOT NULL THEN "Element_Localised_de_DE"."Title" ELSE "Element_Live"."Title" END AS "Title", "Element_Live"."ShowTitle", "Element_Live"."Sort", CASE WHEN "Element_Localised_en_US"."ID" IS NOT NULL THEN "Element_Localised_en_US"."ExtraClass" WHEN "Element_Localised_de_DE"."ID" IS NOT NULL THEN "Element_Localised_de_DE"."ExtraClass" ELSE "Element_Live"."ExtraClass" END AS "ExtraClass", CASE WHEN "Element_Localised_en_US"."ID" IS NOT NULL THEN "Element_Localised_en_US"."Style" WHEN "Element_Localised_de_DE"."ID" IS NOT NULL THEN "Element_Localised_de_DE"."Style" ELSE "Element_Live"."Style" END AS "Style", "Element_Live"."TopPageID", "Element_Live"."ParentID", "Element_Live"."ID", CASE WHEN "Element_Live"."ClassName" IS NOT NULL THEN "Element_Live"."ClassName" ELSE 'DNADesign\\Elemental\\Models\\BaseElement' END AS "RecordClassName", 'en_US' AS "Locale", CASE WHEN "Element_Localised_en_US"."ID" IS NOT NULL THEN 'en_US' WHEN "Element_Localised_de_DE"."ID" IS NOT NULL THEN 'de_DE' ELSE NULL END AS "SourceLocale" FROM "Element_Live" LEFT JOIN "Element_Localised" AS "Element_Localised_en_US" ON "Element_Live"."ID" = "Element_Localised_en_US"."RecordID" AND "Element_Localised_en_US"."Locale" = ? LEFT JOIN "Element_Localised" AS "Element_Localised_de_DE" ON "Element_Live"."ID" = "Element_Localised_de_DE"."RecordID" AND "Element_Localised_de_DE"."Locale" = ? WHERE ("Element_Live"."ID" = ?) AND (("Element_Localised_en_US"."ID" IS NOT NULL)) ORDER BY "Element_Live"."Sort" ASC LIMIT 1 0.0003s
0077: SELECT DISTINCT "Element_Live"."ClassName", "Element_Live"."LastEdited", "Element_Live"."Created", "ElementVirtual_Live"."LinkedElementID", "Element_Live"."ID", CASE WHEN "Element_Live"."ClassName" IS NOT NULL THEN "Element_Live"."ClassName" ELSE 'DNADesign\\Elemental\\Models\\BaseElement' END AS "RecordClassName", 'en_US' AS "Locale", CASE WHEN "Element_Localised_en_US"."ID" IS NOT NULL THEN 'en_US' WHEN "Element_Localised_de_DE"."ID" IS NOT NULL THEN 'de_DE' ELSE NULL END AS "SourceLocale", "Element_Live"."Sort" FROM "Element_Live" LEFT JOIN "ElementVirtual_Live" ON "ElementVirtual_Live"."ID" = "Element_Live"."ID" LEFT JOIN "Element_Localised" AS "Element_Localised_en_US" ON "Element_Live"."ID" = "Element_Localised_en_US"."RecordID" AND "Element_Localised_en_US"."Locale" = ? LEFT JOIN "Element_Localised" AS "Element_Localised_de_DE" ON "Element_Live"."ID" = "Element_Localised_de_DE"."RecordID" AND "Element_Localised_de_DE"."Locale" = ? WHERE ("Element_Live"."ID" = ?) AND ("Element_Live"."ClassName" IN (?)) AND (("Element_Localised_en_US"."ID" IS NOT NULL)) ORDER BY "Element_Live"."Sort" ASC LIMIT 1 0.0002s
0078: SELECT DISTINCT "Element_Live"."ClassName", "Element_Live"."LastEdited", "Element_Live"."Created", "Element_Live"."AvailableGlobally", CASE WHEN "Element_Localised_en_US"."ID" IS NOT NULL THEN "Element_Localised_en_US"."VirtualLookupTitle" WHEN "Element_Localised_de_DE"."ID" IS NOT NULL THEN "Element_Localised_de_DE"."VirtualLookupTitle" ELSE "Element_Live"."VirtualLookupTitle" END AS "VirtualLookupTitle", CASE WHEN "Element_Localised_en_US"."ID" IS NOT NULL THEN "Element_Localised_en_US"."MenuTitle" WHEN "Element_Localised_de_DE"."ID" IS NOT NULL THEN "Element_Localised_de_DE"."MenuTitle" ELSE "Element_Live"."MenuTitle" END AS "MenuTitle", "Element_Live"."ShowInMenus", CASE WHEN "Element_Localised_en_US"."ID" IS NOT NULL THEN "Element_Localised_en_US"."HeadlineTag" WHEN "Element_Localised_de_DE"."ID" IS NOT NULL THEN "Element_Localised_de_DE"."HeadlineTag" ELSE "Element_Live"."HeadlineTag" END AS "HeadlineTag", CASE WHEN "Element_Localised_en_US"."ID" IS NOT NULL THEN "Element_Localised_en_US"."OpticalHeadline" WHEN "Element_Localised_de_DE"."ID" IS NOT NULL THEN "Element_Localised_de_DE"."OpticalHeadline" ELSE "Element_Live"."OpticalHeadline" END AS "OpticalHeadline", "Element_Live"."Version", CASE WHEN "Element_Localised_en_US"."ID" IS NOT NULL THEN "Element_Localised_en_US"."Title" WHEN "Element_Localised_de_DE"."ID" IS NOT NULL THEN "Element_Localised_de_DE"."Title" ELSE "Element_Live"."Title" END AS "Title", "Element_Live"."ShowTitle", "Element_Live"."Sort", CASE WHEN "Element_Localised_en_US"."ID" IS NOT NULL THEN "Element_Localised_en_US"."ExtraClass" WHEN "Element_Localised_de_DE"."ID" IS NOT NULL THEN "Element_Localised_de_DE"."ExtraClass" ELSE "Element_Live"."ExtraClass" END AS "ExtraClass", CASE WHEN "Element_Localised_en_US"."ID" IS NOT NULL THEN "Element_Localised_en_US"."Style" WHEN "Element_Localised_de_DE"."ID" IS NOT NULL THEN "Element_Localised_de_DE"."Style" ELSE "Element_Live"."Style" END AS "Style", "Element_Live"."TopPageID", "Element_Live"."ParentID", "Element_Live"."ID", CASE WHEN "Element_Live"."ClassName" IS NOT NULL THEN "Element_Live"."ClassName" ELSE 'DNADesign\\Elemental\\Models\\BaseElement' END AS "RecordClassName", 'en_US' AS "Locale", CASE WHEN "Element_Localised_en_US"."ID" IS NOT NULL THEN 'en_US' WHEN "Element_Localised_de_DE"."ID" IS NOT NULL THEN 'de_DE' ELSE NULL END AS "SourceLocale" FROM "Element_Live" LEFT JOIN "Element_Localised" AS "Element_Localised_en_US" ON "Element_Live"."ID" = "Element_Localised_en_US"."RecordID" AND "Element_Localised_en_US"."Locale" = ? LEFT JOIN "Element_Localised" AS "Element_Localised_de_DE" ON "Element_Live"."ID" = "Element_Localised_de_DE"."RecordID" AND "Element_Localised_de_DE"."Locale" = ? WHERE ("Element_Live"."ID" = ?) AND (("Element_Localised_en_US"."ID" IS NOT NULL)) ORDER BY "Element_Live"."Sort" ASC LIMIT 1 0.0005s
0079: SELECT DISTINCT "ElementalArea_Live"."ClassName", "ElementalArea_Live"."LastEdited", "ElementalArea_Live"."Created", "ElementalArea_Live"."Version", "ElementalArea_Live"."OwnerClassName", "ElementalArea_Live"."TopPageID", "ElementalArea_Live"."ID", CASE WHEN "ElementalArea_Live"."ClassName" IS NOT NULL THEN "ElementalArea_Live"."ClassName" ELSE 'DNADesign\\Elemental\\Models\\ElementalArea' END AS "RecordClassName" FROM "ElementalArea_Live" WHERE ("ElementalArea_Live"."ID" = ?) LIMIT 1 0.0002s
0080: SELECT DISTINCT "ElementalArea_Live"."ClassName", "ElementalArea_Live"."LastEdited", "ElementalArea_Live"."Created", "ElementalArea_Live"."Version", "ElementalArea_Live"."OwnerClassName", "ElementalArea_Live"."TopPageID", "ElementalArea_Live"."ID", CASE WHEN "ElementalArea_Live"."ClassName" IS NOT NULL THEN "ElementalArea_Live"."ClassName" ELSE 'DNADesign\\Elemental\\Models\\ElementalArea' END AS "RecordClassName" FROM "ElementalArea_Live" WHERE ("ElementalArea_Live"."ID" = ?) LIMIT 1 0.0002s
0081: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", "SiteTree_Live"."CanViewType", "SiteTree_Live"."CanEditType", "SiteTree_Live"."Version", CASE WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."Title" 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_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."URLSegment" 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_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."MenuTitle" 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_Live"."ClassName" IN ('SilverStripe\\CMS\\Model\\SiteTree', 'Page', 'AlternativeLandingPage', 'ApplicationFormPage', 'ContactPage', 'ElementalPage', 'HomePage', 'VIPChipRegistrationPage', 'MoritzSauer\\EventCalendar\\EventCalendarPage', 'SilverStripe\\ErrorPage\\ErrorPage', 'Job\\JobsPage', 'Tietge\\SocialWall\\SocialPage', 'Team\\Pages\\TeamPage', 'SilverStripe\\Blog\\Model\\Blog', 'SilverStripe\\Blog\\Model\\BlogPost', 'SilverStripe\\CMS\\Model\\RedirectorPage', 'SilverStripe\\CMS\\Model\\VirtualPage', 'SilverStripe\\UserForms\\Model\\UserDefinedForm', 'XD\\Events\\Model\\EventPage', 'XD\\Events\\Model\\EventsPage', 'SilverStripe\\Subsites\\Pages\\SubsitesVirtualPage') THEN "SiteTree_Live"."Content" WHEN "SiteTree_Live"."ClassName" IN ('Page', 'AlternativeLandingPage', 'ApplicationFormPage', 'ContactPage', 'ElementalPage', 'HomePage', 'VIPChipRegistrationPage', 'MoritzSauer\\EventCalendar\\EventCalendarPage', 'SilverStripe\\ErrorPage\\ErrorPage', 'Job\\JobsPage', 'Tietge\\SocialWall\\SocialPage', 'Team\\Pages\\TeamPage', 'SilverStripe\\Blog\\Model\\Blog', 'SilverStripe\\Blog\\Model\\BlogPost', 'SilverStripe\\CMS\\Model\\RedirectorPage', 'SilverStripe\\CMS\\Model\\VirtualPage', 'SilverStripe\\UserForms\\Model\\UserDefinedForm', 'XD\\Events\\Model\\EventPage', 'XD\\Events\\Model\\EventsPage', 'SilverStripe\\Subsites\\Pages\\SubsitesVirtualPage') THEN "Page_Live"."Content" WHEN "SiteTree_Live"."ClassName" IN ('Page', 'AlternativeLandingPage', 'ApplicationFormPage', 'ContactPage', 'ElementalPage', 'HomePage', 'VIPChipRegistrationPage', 'MoritzSauer\\EventCalendar\\EventCalendarPage', 'SilverStripe\\ErrorPage\\ErrorPage', 'Job\\JobsPage', 'Tietge\\SocialWall\\SocialPage', 'Team\\Pages\\TeamPage', 'SilverStripe\\Blog\\Model\\Blog', 'SilverStripe\\Blog\\Model\\BlogPost', 'SilverStripe\\CMS\\Model\\RedirectorPage', 'SilverStripe\\CMS\\Model\\VirtualPage', 'SilverStripe\\UserForms\\Model\\UserDefinedForm', 'XD\\Events\\Model\\EventPage', 'XD\\Events\\Model\\EventsPage', 'SilverStripe\\Subsites\\Pages\\SubsitesVirtualPage') THEN "Page_Live"."Content" ELSE NULL END AS "Content", CASE WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."MetaDescription" 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_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."ReportClass" WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."ReportClass" ELSE "SiteTree_Live"."ReportClass" END AS "ReportClass", "SiteTree_Live"."SubsiteID", "SiteTree_Live"."ParentID", CASE WHEN "Page_Localised_en_US"."ID" IS NOT NULL THEN "Page_Localised_en_US"."OGTitleCustom" WHEN "Page_Localised_de_DE"."ID" IS NOT NULL THEN "Page_Localised_de_DE"."OGTitleCustom" ELSE "Page_Live"."OGTitleCustom" END AS "OGTitleCustom", CASE WHEN "Page_Localised_en_US"."ID" IS NOT NULL THEN "Page_Localised_en_US"."OGDescriptionCustom" WHEN "Page_Localised_de_DE"."ID" IS NOT NULL THEN "Page_Localised_de_DE"."OGDescriptionCustom" ELSE "Page_Live"."OGDescriptionCustom" END AS "OGDescriptionCustom", CASE WHEN "Page_Localised_en_US"."ID" IS NOT NULL THEN "Page_Localised_en_US"."SubTitle" WHEN "Page_Localised_de_DE"."ID" IS NOT NULL THEN "Page_Localised_de_DE"."SubTitle" ELSE "Page_Live"."SubTitle" END AS "SubTitle", "Page_Live"."ShowInLegalMenu", CASE WHEN "Page_Localised_en_US"."ID" IS NOT NULL THEN "Page_Localised_en_US"."MetaTitle" WHEN "Page_Localised_de_DE"."ID" IS NOT NULL THEN "Page_Localised_de_DE"."MetaTitle" ELSE "Page_Live"."MetaTitle" END AS "MetaTitle", "Page_Live"."ShowInNaviEingeklappt", "Page_Live"."ShowNewsletterInFooter", "Page_Live"."ShowPageHeaderGradient", "Page_Live"."OGImageCustomID", "Page_Live"."PinterestImageCustomID", "Page_Live"."HeaderImageID", "Page_Live"."VideoMP4ID", "Page_Live"."VideoOGVID", "Page_Live"."ImageID", CASE WHEN "JobsPage_Localised_en_US"."ID" IS NOT NULL THEN "JobsPage_Localised_en_US"."JobsTitle" WHEN "JobsPage_Localised_de_DE"."ID" IS NOT NULL THEN "JobsPage_Localised_de_DE"."JobsTitle" ELSE "JobsPage_Live"."JobsTitle" END AS "JobsTitle", CASE WHEN "JobsPage_Localised_en_US"."ID" IS NOT NULL THEN "JobsPage_Localised_en_US"."JobsSubTitle" WHEN "JobsPage_Localised_de_DE"."ID" IS NOT NULL THEN "JobsPage_Localised_de_DE"."JobsSubTitle" ELSE "JobsPage_Live"."JobsSubTitle" END AS "JobsSubTitle", CASE WHEN "JobsPage_Localised_en_US"."ID" IS NOT NULL THEN "JobsPage_Localised_en_US"."ContentTitle" WHEN "JobsPage_Localised_de_DE"."ID" IS NOT NULL THEN "JobsPage_Localised_de_DE"."ContentTitle" ELSE "JobsPage_Live"."ContentTitle" END AS "ContentTitle", CASE WHEN "JobsPage_Localised_en_US"."ID" IS NOT NULL THEN "JobsPage_Localised_en_US"."ContentSubTitle" WHEN "JobsPage_Localised_de_DE"."ID" IS NOT NULL THEN "JobsPage_Localised_de_DE"."ContentSubTitle" ELSE "JobsPage_Live"."ContentSubTitle" END AS "ContentSubTitle", CASE WHEN "JobsPage_Localised_en_US"."ID" IS NOT NULL THEN "JobsPage_Localised_en_US"."InitiativBewerbungsText" WHEN "JobsPage_Localised_de_DE"."ID" IS NOT NULL THEN "JobsPage_Localised_de_DE"."InitiativBewerbungsText" ELSE "JobsPage_Live"."InitiativBewerbungsText" END AS "InitiativBewerbungsText", CASE WHEN "JobsPage_Localised_en_US"."ID" IS NOT NULL THEN "JobsPage_Localised_en_US"."FragenText" WHEN "JobsPage_Localised_de_DE"."ID" IS NOT NULL THEN "JobsPage_Localised_de_DE"."FragenText" ELSE "JobsPage_Live"."FragenText" END AS "FragenText", CASE WHEN "JobsPage_Localised_en_US"."ID" IS NOT NULL THEN "JobsPage_Localised_en_US"."BewerbungsMail" WHEN "JobsPage_Localised_de_DE"."ID" IS NOT NULL THEN "JobsPage_Localised_de_DE"."BewerbungsMail" ELSE "JobsPage_Live"."BewerbungsMail" END AS "BewerbungsMail", "JobsPage_Live"."ElementalAreaID", "JobsPage_Live"."SecondElementalAreaID", "JobsPage_Live"."InitiativBewerbungsImageID", "SiteTree_Live"."ID", CASE WHEN "SiteTree_Live"."ClassName" IS NOT NULL THEN "SiteTree_Live"."ClassName" ELSE 'SilverStripe\\CMS\\Model\\SiteTree' END AS "RecordClassName", 'en_US' AS "Locale", CASE WHEN "JobsPage_Localised_en_US"."ID" IS NOT NULL THEN 'en_US' WHEN "JobsPage_Localised_de_DE"."ID" IS NOT NULL THEN 'de_DE' ELSE NULL END AS "SourceLocale" FROM "SiteTree_Live" LEFT JOIN "Page_Live" ON "Page_Live"."ID" = "SiteTree_Live"."ID" LEFT JOIN "JobsPage_Live" ON "JobsPage_Live"."ID" = "SiteTree_Live"."ID" LEFT JOIN "SiteTree_Localised_Live" AS "SiteTree_Localised_en_US" ON "SiteTree_Live"."ID" = "SiteTree_Localised_en_US"."RecordID" AND "SiteTree_Localised_en_US"."Locale" = ? LEFT JOIN "SiteTree_Localised_Live" AS "SiteTree_Localised_de_DE" ON "SiteTree_Live"."ID" = "SiteTree_Localised_de_DE"."RecordID" AND "SiteTree_Localised_de_DE"."Locale" = ? LEFT JOIN "Page_Localised_Live" AS "Page_Localised_en_US" ON "Page_Live"."ID" = "Page_Localised_en_US"."RecordID" AND "Page_Localised_en_US"."Locale" = ? LEFT JOIN "Page_Localised_Live" AS "Page_Localised_de_DE" ON "Page_Live"."ID" = "Page_Localised_de_DE"."RecordID" AND "Page_Localised_de_DE"."Locale" = ? LEFT JOIN "JobsPage_Localised_Live" AS "JobsPage_Localised_en_US" ON "JobsPage_Live"."ID" = "JobsPage_Localised_en_US"."RecordID" AND "JobsPage_Localised_en_US"."Locale" = ? LEFT JOIN "JobsPage_Localised_Live" AS "JobsPage_Localised_de_DE" ON "JobsPage_Live"."ID" = "JobsPage_Localised_de_DE"."RecordID" AND "JobsPage_Localised_de_DE"."Locale" = ? WHERE ("JobsPage_Live"."ElementalAreaID" = ?) AND ("SiteTree_Live"."ClassName" = ?) AND ("SiteTree_Live"."ClassName" IN (?)) AND ("SiteTree_Live"."SubsiteID" IN (2)) AND (("SiteTree_Localised_en_US"."ID" IS NOT NULL) OR ("SiteTree_Localised_de_DE"."ID" IS NOT NULL)) ORDER BY "SiteTree_Live"."Sort" ASC LIMIT 1 0.0012s
0082: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", "SiteTree_Live"."CanViewType", "SiteTree_Live"."CanEditType", "SiteTree_Live"."Version", CASE WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."Title" 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_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."URLSegment" 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_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."MenuTitle" 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_Live"."ClassName" IN ('SilverStripe\\CMS\\Model\\SiteTree', 'Page', 'AlternativeLandingPage', 'ApplicationFormPage', 'ContactPage', 'ElementalPage', 'HomePage', 'VIPChipRegistrationPage', 'MoritzSauer\\EventCalendar\\EventCalendarPage', 'SilverStripe\\ErrorPage\\ErrorPage', 'Job\\JobsPage', 'Tietge\\SocialWall\\SocialPage', 'Team\\Pages\\TeamPage', 'SilverStripe\\Blog\\Model\\Blog', 'SilverStripe\\Blog\\Model\\BlogPost', 'SilverStripe\\CMS\\Model\\RedirectorPage', 'SilverStripe\\CMS\\Model\\VirtualPage', 'SilverStripe\\UserForms\\Model\\UserDefinedForm', 'XD\\Events\\Model\\EventPage', 'XD\\Events\\Model\\EventsPage', 'SilverStripe\\Subsites\\Pages\\SubsitesVirtualPage') THEN "SiteTree_Live"."Content" WHEN "SiteTree_Live"."ClassName" IN ('Page', 'AlternativeLandingPage', 'ApplicationFormPage', 'ContactPage', 'ElementalPage', 'HomePage', 'VIPChipRegistrationPage', 'MoritzSauer\\EventCalendar\\EventCalendarPage', 'SilverStripe\\ErrorPage\\ErrorPage', 'Job\\JobsPage', 'Tietge\\SocialWall\\SocialPage', 'Team\\Pages\\TeamPage', 'SilverStripe\\Blog\\Model\\Blog', 'SilverStripe\\Blog\\Model\\BlogPost', 'SilverStripe\\CMS\\Model\\RedirectorPage', 'SilverStripe\\CMS\\Model\\VirtualPage', 'SilverStripe\\UserForms\\Model\\UserDefinedForm', 'XD\\Events\\Model\\EventPage', 'XD\\Events\\Model\\EventsPage', 'SilverStripe\\Subsites\\Pages\\SubsitesVirtualPage') THEN "Page_Live"."Content" WHEN "SiteTree_Live"."ClassName" IN ('Page', 'AlternativeLandingPage', 'ApplicationFormPage', 'ContactPage', 'ElementalPage', 'HomePage', 'VIPChipRegistrationPage', 'MoritzSauer\\EventCalendar\\EventCalendarPage', 'SilverStripe\\ErrorPage\\ErrorPage', 'Job\\JobsPage', 'Tietge\\SocialWall\\SocialPage', 'Team\\Pages\\TeamPage', 'SilverStripe\\Blog\\Model\\Blog', 'SilverStripe\\Blog\\Model\\BlogPost', 'SilverStripe\\CMS\\Model\\RedirectorPage', 'SilverStripe\\CMS\\Model\\VirtualPage', 'SilverStripe\\UserForms\\Model\\UserDefinedForm', 'XD\\Events\\Model\\EventPage', 'XD\\Events\\Model\\EventsPage', 'SilverStripe\\Subsites\\Pages\\SubsitesVirtualPage') THEN "Page_Live"."Content" ELSE NULL END AS "Content", CASE WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."MetaDescription" 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_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."ReportClass" WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."ReportClass" ELSE "SiteTree_Live"."ReportClass" END AS "ReportClass", "SiteTree_Live"."SubsiteID", "SiteTree_Live"."ParentID", CASE WHEN "Page_Localised_en_US"."ID" IS NOT NULL THEN "Page_Localised_en_US"."OGTitleCustom" WHEN "Page_Localised_de_DE"."ID" IS NOT NULL THEN "Page_Localised_de_DE"."OGTitleCustom" ELSE "Page_Live"."OGTitleCustom" END AS "OGTitleCustom", CASE WHEN "Page_Localised_en_US"."ID" IS NOT NULL THEN "Page_Localised_en_US"."OGDescriptionCustom" WHEN "Page_Localised_de_DE"."ID" IS NOT NULL THEN "Page_Localised_de_DE"."OGDescriptionCustom" ELSE "Page_Live"."OGDescriptionCustom" END AS "OGDescriptionCustom", CASE WHEN "Page_Localised_en_US"."ID" IS NOT NULL THEN "Page_Localised_en_US"."SubTitle" WHEN "Page_Localised_de_DE"."ID" IS NOT NULL THEN "Page_Localised_de_DE"."SubTitle" ELSE "Page_Live"."SubTitle" END AS "SubTitle", "Page_Live"."ShowInLegalMenu", CASE WHEN "Page_Localised_en_US"."ID" IS NOT NULL THEN "Page_Localised_en_US"."MetaTitle" WHEN "Page_Localised_de_DE"."ID" IS NOT NULL THEN "Page_Localised_de_DE"."MetaTitle" ELSE "Page_Live"."MetaTitle" END AS "MetaTitle", "Page_Live"."ShowInNaviEingeklappt", "Page_Live"."ShowNewsletterInFooter", "Page_Live"."ShowPageHeaderGradient", "Page_Live"."OGImageCustomID", "Page_Live"."PinterestImageCustomID", "Page_Live"."HeaderImageID", "Page_Live"."VideoMP4ID", "Page_Live"."VideoOGVID", "Page_Live"."ImageID", CASE WHEN "JobsPage_Localised_en_US"."ID" IS NOT NULL THEN "JobsPage_Localised_en_US"."JobsTitle" WHEN "JobsPage_Localised_de_DE"."ID" IS NOT NULL THEN "JobsPage_Localised_de_DE"."JobsTitle" ELSE "JobsPage_Live"."JobsTitle" END AS "JobsTitle", CASE WHEN "JobsPage_Localised_en_US"."ID" IS NOT NULL THEN "JobsPage_Localised_en_US"."JobsSubTitle" WHEN "JobsPage_Localised_de_DE"."ID" IS NOT NULL THEN "JobsPage_Localised_de_DE"."JobsSubTitle" ELSE "JobsPage_Live"."JobsSubTitle" END AS "JobsSubTitle", CASE WHEN "JobsPage_Localised_en_US"."ID" IS NOT NULL THEN "JobsPage_Localised_en_US"."ContentTitle" WHEN "JobsPage_Localised_de_DE"."ID" IS NOT NULL THEN "JobsPage_Localised_de_DE"."ContentTitle" ELSE "JobsPage_Live"."ContentTitle" END AS "ContentTitle", CASE WHEN "JobsPage_Localised_en_US"."ID" IS NOT NULL THEN "JobsPage_Localised_en_US"."ContentSubTitle" WHEN "JobsPage_Localised_de_DE"."ID" IS NOT NULL THEN "JobsPage_Localised_de_DE"."ContentSubTitle" ELSE "JobsPage_Live"."ContentSubTitle" END AS "ContentSubTitle", CASE WHEN "JobsPage_Localised_en_US"."ID" IS NOT NULL THEN "JobsPage_Localised_en_US"."InitiativBewerbungsText" WHEN "JobsPage_Localised_de_DE"."ID" IS NOT NULL THEN "JobsPage_Localised_de_DE"."InitiativBewerbungsText" ELSE "JobsPage_Live"."InitiativBewerbungsText" END AS "InitiativBewerbungsText", CASE WHEN "JobsPage_Localised_en_US"."ID" IS NOT NULL THEN "JobsPage_Localised_en_US"."FragenText" WHEN "JobsPage_Localised_de_DE"."ID" IS NOT NULL THEN "JobsPage_Localised_de_DE"."FragenText" ELSE "JobsPage_Live"."FragenText" END AS "FragenText", CASE WHEN "JobsPage_Localised_en_US"."ID" IS NOT NULL THEN "JobsPage_Localised_en_US"."BewerbungsMail" WHEN "JobsPage_Localised_de_DE"."ID" IS NOT NULL THEN "JobsPage_Localised_de_DE"."BewerbungsMail" ELSE "JobsPage_Live"."BewerbungsMail" END AS "BewerbungsMail", "JobsPage_Live"."ElementalAreaID", "JobsPage_Live"."SecondElementalAreaID", "JobsPage_Live"."InitiativBewerbungsImageID", "SiteTree_Live"."ID", CASE WHEN "SiteTree_Live"."ClassName" IS NOT NULL THEN "SiteTree_Live"."ClassName" ELSE 'SilverStripe\\CMS\\Model\\SiteTree' END AS "RecordClassName", 'en_US' AS "Locale", CASE WHEN "JobsPage_Localised_en_US"."ID" IS NOT NULL THEN 'en_US' WHEN "JobsPage_Localised_de_DE"."ID" IS NOT NULL THEN 'de_DE' ELSE NULL END AS "SourceLocale" FROM "SiteTree_Live" LEFT JOIN "Page_Live" ON "Page_Live"."ID" = "SiteTree_Live"."ID" LEFT JOIN "JobsPage_Live" ON "JobsPage_Live"."ID" = "SiteTree_Live"."ID" LEFT JOIN "SiteTree_Localised_Live" AS "SiteTree_Localised_en_US" ON "SiteTree_Live"."ID" = "SiteTree_Localised_en_US"."RecordID" AND "SiteTree_Localised_en_US"."Locale" = ? LEFT JOIN "SiteTree_Localised_Live" AS "SiteTree_Localised_de_DE" ON "SiteTree_Live"."ID" = "SiteTree_Localised_de_DE"."RecordID" AND "SiteTree_Localised_de_DE"."Locale" = ? LEFT JOIN "Page_Localised_Live" AS "Page_Localised_en_US" ON "Page_Live"."ID" = "Page_Localised_en_US"."RecordID" AND "Page_Localised_en_US"."Locale" = ? LEFT JOIN "Page_Localised_Live" AS "Page_Localised_de_DE" ON "Page_Live"."ID" = "Page_Localised_de_DE"."RecordID" AND "Page_Localised_de_DE"."Locale" = ? LEFT JOIN "JobsPage_Localised_Live" AS "JobsPage_Localised_en_US" ON "JobsPage_Live"."ID" = "JobsPage_Localised_en_US"."RecordID" AND "JobsPage_Localised_en_US"."Locale" = ? LEFT JOIN "JobsPage_Localised_Live" AS "JobsPage_Localised_de_DE" ON "JobsPage_Live"."ID" = "JobsPage_Localised_de_DE"."RecordID" AND "JobsPage_Localised_de_DE"."Locale" = ? WHERE ("JobsPage_Live"."SecondElementalAreaID" = ?) AND ("SiteTree_Live"."ClassName" = ?) AND ("SiteTree_Live"."ClassName" IN (?)) AND ("SiteTree_Live"."SubsiteID" IN (2)) AND (("SiteTree_Localised_en_US"."ID" IS NOT NULL) OR ("SiteTree_Localised_de_DE"."ID" IS NOT NULL)) ORDER BY "SiteTree_Live"."Sort" ASC LIMIT 1 0.001s
0083: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", "SiteTree_Live"."CanViewType", "SiteTree_Live"."CanEditType", "SiteTree_Live"."Version", CASE WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."Title" 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_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."URLSegment" 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_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."MenuTitle" 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_Live"."ClassName" IN ('SilverStripe\\CMS\\Model\\SiteTree', 'Page', 'AlternativeLandingPage', 'ApplicationFormPage', 'ContactPage', 'ElementalPage', 'HomePage', 'VIPChipRegistrationPage', 'MoritzSauer\\EventCalendar\\EventCalendarPage', 'SilverStripe\\ErrorPage\\ErrorPage', 'Job\\JobsPage', 'Tietge\\SocialWall\\SocialPage', 'Team\\Pages\\TeamPage', 'SilverStripe\\Blog\\Model\\Blog', 'SilverStripe\\Blog\\Model\\BlogPost', 'SilverStripe\\CMS\\Model\\RedirectorPage', 'SilverStripe\\CMS\\Model\\VirtualPage', 'SilverStripe\\UserForms\\Model\\UserDefinedForm', 'XD\\Events\\Model\\EventPage', 'XD\\Events\\Model\\EventsPage', 'SilverStripe\\Subsites\\Pages\\SubsitesVirtualPage') THEN "SiteTree_Live"."Content" WHEN "SiteTree_Live"."ClassName" IN ('Page', 'AlternativeLandingPage', 'ApplicationFormPage', 'ContactPage', 'ElementalPage', 'HomePage', 'VIPChipRegistrationPage', 'MoritzSauer\\EventCalendar\\EventCalendarPage', 'SilverStripe\\ErrorPage\\ErrorPage', 'Job\\JobsPage', 'Tietge\\SocialWall\\SocialPage', 'Team\\Pages\\TeamPage', 'SilverStripe\\Blog\\Model\\Blog', 'SilverStripe\\Blog\\Model\\BlogPost', 'SilverStripe\\CMS\\Model\\RedirectorPage', 'SilverStripe\\CMS\\Model\\VirtualPage', 'SilverStripe\\UserForms\\Model\\UserDefinedForm', 'XD\\Events\\Model\\EventPage', 'XD\\Events\\Model\\EventsPage', 'SilverStripe\\Subsites\\Pages\\SubsitesVirtualPage') THEN "Page_Live"."Content" WHEN "SiteTree_Live"."ClassName" IN ('Page', 'AlternativeLandingPage', 'ApplicationFormPage', 'ContactPage', 'ElementalPage', 'HomePage', 'VIPChipRegistrationPage', 'MoritzSauer\\EventCalendar\\EventCalendarPage', 'SilverStripe\\ErrorPage\\ErrorPage', 'Job\\JobsPage', 'Tietge\\SocialWall\\SocialPage', 'Team\\Pages\\TeamPage', 'SilverStripe\\Blog\\Model\\Blog', 'SilverStripe\\Blog\\Model\\BlogPost', 'SilverStripe\\CMS\\Model\\RedirectorPage', 'SilverStripe\\CMS\\Model\\VirtualPage', 'SilverStripe\\UserForms\\Model\\UserDefinedForm', 'XD\\Events\\Model\\EventPage', 'XD\\Events\\Model\\EventsPage', 'SilverStripe\\Subsites\\Pages\\SubsitesVirtualPage') THEN "Page_Live"."Content" ELSE NULL END AS "Content", CASE WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."MetaDescription" 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_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."ReportClass" WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."ReportClass" ELSE "SiteTree_Live"."ReportClass" END AS "ReportClass", "SiteTree_Live"."SubsiteID", "SiteTree_Live"."ParentID", CASE WHEN "Page_Localised_en_US"."ID" IS NOT NULL THEN "Page_Localised_en_US"."OGTitleCustom" WHEN "Page_Localised_de_DE"."ID" IS NOT NULL THEN "Page_Localised_de_DE"."OGTitleCustom" ELSE "Page_Live"."OGTitleCustom" END AS "OGTitleCustom", CASE WHEN "Page_Localised_en_US"."ID" IS NOT NULL THEN "Page_Localised_en_US"."OGDescriptionCustom" WHEN "Page_Localised_de_DE"."ID" IS NOT NULL THEN "Page_Localised_de_DE"."OGDescriptionCustom" ELSE "Page_Live"."OGDescriptionCustom" END AS "OGDescriptionCustom", CASE WHEN "Page_Localised_en_US"."ID" IS NOT NULL THEN "Page_Localised_en_US"."SubTitle" WHEN "Page_Localised_de_DE"."ID" IS NOT NULL THEN "Page_Localised_de_DE"."SubTitle" ELSE "Page_Live"."SubTitle" END AS "SubTitle", "Page_Live"."ShowInLegalMenu", CASE WHEN "Page_Localised_en_US"."ID" IS NOT NULL THEN "Page_Localised_en_US"."MetaTitle" WHEN "Page_Localised_de_DE"."ID" IS NOT NULL THEN "Page_Localised_de_DE"."MetaTitle" ELSE "Page_Live"."MetaTitle" END AS "MetaTitle", "Page_Live"."ShowInNaviEingeklappt", "Page_Live"."ShowNewsletterInFooter", "Page_Live"."ShowPageHeaderGradient", "Page_Live"."OGImageCustomID", "Page_Live"."PinterestImageCustomID", "Page_Live"."HeaderImageID", "Page_Live"."VideoMP4ID", "Page_Live"."VideoOGVID", "Page_Live"."ImageID", "AlternativeLandingPage_Live"."ElementalAreaID", "SiteTree_Live"."ID", CASE WHEN "SiteTree_Live"."ClassName" IS NOT NULL THEN "SiteTree_Live"."ClassName" ELSE 'SilverStripe\\CMS\\Model\\SiteTree' END AS "RecordClassName", 'en_US' AS "Locale", CASE WHEN "Page_Localised_en_US"."ID" IS NOT NULL THEN 'en_US' WHEN "Page_Localised_de_DE"."ID" IS NOT NULL THEN 'de_DE' ELSE NULL END AS "SourceLocale" FROM "SiteTree_Live" LEFT JOIN "Page_Live" ON "Page_Live"."ID" = "SiteTree_Live"."ID" LEFT JOIN "AlternativeLandingPage_Live" ON "AlternativeLandingPage_Live"."ID" = "SiteTree_Live"."ID" LEFT JOIN "SiteTree_Localised_Live" AS "SiteTree_Localised_en_US" ON "SiteTree_Live"."ID" = "SiteTree_Localised_en_US"."RecordID" AND "SiteTree_Localised_en_US"."Locale" = ? LEFT JOIN "SiteTree_Localised_Live" AS "SiteTree_Localised_de_DE" ON "SiteTree_Live"."ID" = "SiteTree_Localised_de_DE"."RecordID" AND "SiteTree_Localised_de_DE"."Locale" = ? LEFT JOIN "Page_Localised_Live" AS "Page_Localised_en_US" ON "Page_Live"."ID" = "Page_Localised_en_US"."RecordID" AND "Page_Localised_en_US"."Locale" = ? LEFT JOIN "Page_Localised_Live" AS "Page_Localised_de_DE" ON "Page_Live"."ID" = "Page_Localised_de_DE"."RecordID" AND "Page_Localised_de_DE"."Locale" = ? WHERE (("AlternativeLandingPage_Live"."ElementalAreaID" = ?)) AND ("SiteTree_Live"."ClassName" IN (?)) AND ("SiteTree_Live"."SubsiteID" IN (2)) AND (("SiteTree_Localised_en_US"."ID" IS NOT NULL) OR ("SiteTree_Localised_de_DE"."ID" IS NOT NULL)) ORDER BY "SiteTree_Live"."Sort" ASC LIMIT 1 0.0007s
0084: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", "SiteTree_Live"."CanViewType", "SiteTree_Live"."CanEditType", "SiteTree_Live"."Version", CASE WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."Title" 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_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."URLSegment" 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_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."MenuTitle" 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_Live"."ClassName" IN ('SilverStripe\\CMS\\Model\\SiteTree', 'Page', 'AlternativeLandingPage', 'ApplicationFormPage', 'ContactPage', 'ElementalPage', 'HomePage', 'VIPChipRegistrationPage', 'MoritzSauer\\EventCalendar\\EventCalendarPage', 'SilverStripe\\ErrorPage\\ErrorPage', 'Job\\JobsPage', 'Tietge\\SocialWall\\SocialPage', 'Team\\Pages\\TeamPage', 'SilverStripe\\Blog\\Model\\Blog', 'SilverStripe\\Blog\\Model\\BlogPost', 'SilverStripe\\CMS\\Model\\RedirectorPage', 'SilverStripe\\CMS\\Model\\VirtualPage', 'SilverStripe\\UserForms\\Model\\UserDefinedForm', 'XD\\Events\\Model\\EventPage', 'XD\\Events\\Model\\EventsPage', 'SilverStripe\\Subsites\\Pages\\SubsitesVirtualPage') THEN "SiteTree_Live"."Content" WHEN "SiteTree_Live"."ClassName" IN ('Page', 'AlternativeLandingPage', 'ApplicationFormPage', 'ContactPage', 'ElementalPage', 'HomePage', 'VIPChipRegistrationPage', 'MoritzSauer\\EventCalendar\\EventCalendarPage', 'SilverStripe\\ErrorPage\\ErrorPage', 'Job\\JobsPage', 'Tietge\\SocialWall\\SocialPage', 'Team\\Pages\\TeamPage', 'SilverStripe\\Blog\\Model\\Blog', 'SilverStripe\\Blog\\Model\\BlogPost', 'SilverStripe\\CMS\\Model\\RedirectorPage', 'SilverStripe\\CMS\\Model\\VirtualPage', 'SilverStripe\\UserForms\\Model\\UserDefinedForm', 'XD\\Events\\Model\\EventPage', 'XD\\Events\\Model\\EventsPage', 'SilverStripe\\Subsites\\Pages\\SubsitesVirtualPage') THEN "Page_Live"."Content" WHEN "SiteTree_Live"."ClassName" IN ('Page', 'AlternativeLandingPage', 'ApplicationFormPage', 'ContactPage', 'ElementalPage', 'HomePage', 'VIPChipRegistrationPage', 'MoritzSauer\\EventCalendar\\EventCalendarPage', 'SilverStripe\\ErrorPage\\ErrorPage', 'Job\\JobsPage', 'Tietge\\SocialWall\\SocialPage', 'Team\\Pages\\TeamPage', 'SilverStripe\\Blog\\Model\\Blog', 'SilverStripe\\Blog\\Model\\BlogPost', 'SilverStripe\\CMS\\Model\\RedirectorPage', 'SilverStripe\\CMS\\Model\\VirtualPage', 'SilverStripe\\UserForms\\Model\\UserDefinedForm', 'XD\\Events\\Model\\EventPage', 'XD\\Events\\Model\\EventsPage', 'SilverStripe\\Subsites\\Pages\\SubsitesVirtualPage') THEN "Page_Live"."Content" ELSE NULL END AS "Content", CASE WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."MetaDescription" 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_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."ReportClass" WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."ReportClass" ELSE "SiteTree_Live"."ReportClass" END AS "ReportClass", "SiteTree_Live"."SubsiteID", "SiteTree_Live"."ParentID", CASE WHEN "Page_Localised_en_US"."ID" IS NOT NULL THEN "Page_Localised_en_US"."OGTitleCustom" WHEN "Page_Localised_de_DE"."ID" IS NOT NULL THEN "Page_Localised_de_DE"."OGTitleCustom" ELSE "Page_Live"."OGTitleCustom" END AS "OGTitleCustom", CASE WHEN "Page_Localised_en_US"."ID" IS NOT NULL THEN "Page_Localised_en_US"."OGDescriptionCustom" WHEN "Page_Localised_de_DE"."ID" IS NOT NULL THEN "Page_Localised_de_DE"."OGDescriptionCustom" ELSE "Page_Live"."OGDescriptionCustom" END AS "OGDescriptionCustom", CASE WHEN "Page_Localised_en_US"."ID" IS NOT NULL THEN "Page_Localised_en_US"."SubTitle" WHEN "Page_Localised_de_DE"."ID" IS NOT NULL THEN "Page_Localised_de_DE"."SubTitle" ELSE "Page_Live"."SubTitle" END AS "SubTitle", "Page_Live"."ShowInLegalMenu", CASE WHEN "Page_Localised_en_US"."ID" IS NOT NULL THEN "Page_Localised_en_US"."MetaTitle" WHEN "Page_Localised_de_DE"."ID" IS NOT NULL THEN "Page_Localised_de_DE"."MetaTitle" ELSE "Page_Live"."MetaTitle" END AS "MetaTitle", "Page_Live"."ShowInNaviEingeklappt", "Page_Live"."ShowNewsletterInFooter", "Page_Live"."ShowPageHeaderGradient", "Page_Live"."OGImageCustomID", "Page_Live"."PinterestImageCustomID", "Page_Live"."HeaderImageID", "Page_Live"."VideoMP4ID", "Page_Live"."VideoOGVID", "Page_Live"."ImageID", "ElementalPage_Live"."ElementalAreaID", "SiteTree_Live"."ID", CASE WHEN "SiteTree_Live"."ClassName" IS NOT NULL THEN "SiteTree_Live"."ClassName" ELSE 'SilverStripe\\CMS\\Model\\SiteTree' END AS "RecordClassName", 'en_US' AS "Locale", CASE WHEN "Page_Localised_en_US"."ID" IS NOT NULL THEN 'en_US' WHEN "Page_Localised_de_DE"."ID" IS NOT NULL THEN 'de_DE' ELSE NULL END AS "SourceLocale" FROM "SiteTree_Live" LEFT JOIN "Page_Live" ON "Page_Live"."ID" = "SiteTree_Live"."ID" LEFT JOIN "ElementalPage_Live" ON "ElementalPage_Live"."ID" = "SiteTree_Live"."ID" LEFT JOIN "SiteTree_Localised_Live" AS "SiteTree_Localised_en_US" ON "SiteTree_Live"."ID" = "SiteTree_Localised_en_US"."RecordID" AND "SiteTree_Localised_en_US"."Locale" = ? LEFT JOIN "SiteTree_Localised_Live" AS "SiteTree_Localised_de_DE" ON "SiteTree_Live"."ID" = "SiteTree_Localised_de_DE"."RecordID" AND "SiteTree_Localised_de_DE"."Locale" = ? LEFT JOIN "Page_Localised_Live" AS "Page_Localised_en_US" ON "Page_Live"."ID" = "Page_Localised_en_US"."RecordID" AND "Page_Localised_en_US"."Locale" = ? LEFT JOIN "Page_Localised_Live" AS "Page_Localised_de_DE" ON "Page_Live"."ID" = "Page_Localised_de_DE"."RecordID" AND "Page_Localised_de_DE"."Locale" = ? WHERE (("ElementalPage_Live"."ElementalAreaID" = ?)) AND ("SiteTree_Live"."ClassName" IN (?)) AND ("SiteTree_Live"."SubsiteID" IN (2)) AND (("SiteTree_Localised_en_US"."ID" IS NOT NULL) OR ("SiteTree_Localised_de_DE"."ID" IS NOT NULL)) ORDER BY "SiteTree_Live"."Sort" ASC LIMIT 1 0.0006s
0085: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", "SiteTree_Live"."CanViewType", "SiteTree_Live"."CanEditType", "SiteTree_Live"."Version", CASE WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."Title" 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_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."URLSegment" 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_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."MenuTitle" 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_Live"."ClassName" IN ('SilverStripe\\CMS\\Model\\SiteTree', 'Page', 'AlternativeLandingPage', 'ApplicationFormPage', 'ContactPage', 'ElementalPage', 'HomePage', 'VIPChipRegistrationPage', 'MoritzSauer\\EventCalendar\\EventCalendarPage', 'SilverStripe\\ErrorPage\\ErrorPage', 'Job\\JobsPage', 'Tietge\\SocialWall\\SocialPage', 'Team\\Pages\\TeamPage', 'SilverStripe\\Blog\\Model\\Blog', 'SilverStripe\\Blog\\Model\\BlogPost', 'SilverStripe\\CMS\\Model\\RedirectorPage', 'SilverStripe\\CMS\\Model\\VirtualPage', 'SilverStripe\\UserForms\\Model\\UserDefinedForm', 'XD\\Events\\Model\\EventPage', 'XD\\Events\\Model\\EventsPage', 'SilverStripe\\Subsites\\Pages\\SubsitesVirtualPage') THEN "SiteTree_Live"."Content" WHEN "SiteTree_Live"."ClassName" IN ('Page', 'AlternativeLandingPage', 'ApplicationFormPage', 'ContactPage', 'ElementalPage', 'HomePage', 'VIPChipRegistrationPage', 'MoritzSauer\\EventCalendar\\EventCalendarPage', 'SilverStripe\\ErrorPage\\ErrorPage', 'Job\\JobsPage', 'Tietge\\SocialWall\\SocialPage', 'Team\\Pages\\TeamPage', 'SilverStripe\\Blog\\Model\\Blog', 'SilverStripe\\Blog\\Model\\BlogPost', 'SilverStripe\\CMS\\Model\\RedirectorPage', 'SilverStripe\\CMS\\Model\\VirtualPage', 'SilverStripe\\UserForms\\Model\\UserDefinedForm', 'XD\\Events\\Model\\EventPage', 'XD\\Events\\Model\\EventsPage', 'SilverStripe\\Subsites\\Pages\\SubsitesVirtualPage') THEN "Page_Live"."Content" WHEN "SiteTree_Live"."ClassName" IN ('Page', 'AlternativeLandingPage', 'ApplicationFormPage', 'ContactPage', 'ElementalPage', 'HomePage', 'VIPChipRegistrationPage', 'MoritzSauer\\EventCalendar\\EventCalendarPage', 'SilverStripe\\ErrorPage\\ErrorPage', 'Job\\JobsPage', 'Tietge\\SocialWall\\SocialPage', 'Team\\Pages\\TeamPage', 'SilverStripe\\Blog\\Model\\Blog', 'SilverStripe\\Blog\\Model\\BlogPost', 'SilverStripe\\CMS\\Model\\RedirectorPage', 'SilverStripe\\CMS\\Model\\VirtualPage', 'SilverStripe\\UserForms\\Model\\UserDefinedForm', 'XD\\Events\\Model\\EventPage', 'XD\\Events\\Model\\EventsPage', 'SilverStripe\\Subsites\\Pages\\SubsitesVirtualPage') THEN "Page_Live"."Content" ELSE NULL END AS "Content", CASE WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."MetaDescription" 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_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."ReportClass" WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."ReportClass" ELSE "SiteTree_Live"."ReportClass" END AS "ReportClass", "SiteTree_Live"."SubsiteID", "SiteTree_Live"."ParentID", CASE WHEN "Page_Localised_en_US"."ID" IS NOT NULL THEN "Page_Localised_en_US"."OGTitleCustom" WHEN "Page_Localised_de_DE"."ID" IS NOT NULL THEN "Page_Localised_de_DE"."OGTitleCustom" ELSE "Page_Live"."OGTitleCustom" END AS "OGTitleCustom", CASE WHEN "Page_Localised_en_US"."ID" IS NOT NULL THEN "Page_Localised_en_US"."OGDescriptionCustom" WHEN "Page_Localised_de_DE"."ID" IS NOT NULL THEN "Page_Localised_de_DE"."OGDescriptionCustom" ELSE "Page_Live"."OGDescriptionCustom" END AS "OGDescriptionCustom", CASE WHEN "Page_Localised_en_US"."ID" IS NOT NULL THEN "Page_Localised_en_US"."SubTitle" WHEN "Page_Localised_de_DE"."ID" IS NOT NULL THEN "Page_Localised_de_DE"."SubTitle" ELSE "Page_Live"."SubTitle" END AS "SubTitle", "Page_Live"."ShowInLegalMenu", CASE WHEN "Page_Localised_en_US"."ID" IS NOT NULL THEN "Page_Localised_en_US"."MetaTitle" WHEN "Page_Localised_de_DE"."ID" IS NOT NULL THEN "Page_Localised_de_DE"."MetaTitle" ELSE "Page_Live"."MetaTitle" END AS "MetaTitle", "Page_Live"."ShowInNaviEingeklappt", "Page_Live"."ShowNewsletterInFooter", "Page_Live"."ShowPageHeaderGradient", "Page_Live"."OGImageCustomID", "Page_Live"."PinterestImageCustomID", "Page_Live"."HeaderImageID", "Page_Live"."VideoMP4ID", "Page_Live"."VideoOGVID", "Page_Live"."ImageID", "HomePage_Live"."ElementalAreaID", "SiteTree_Live"."ID", CASE WHEN "SiteTree_Live"."ClassName" IS NOT NULL THEN "SiteTree_Live"."ClassName" ELSE 'SilverStripe\\CMS\\Model\\SiteTree' END AS "RecordClassName", 'en_US' AS "Locale", CASE WHEN "Page_Localised_en_US"."ID" IS NOT NULL THEN 'en_US' WHEN "Page_Localised_de_DE"."ID" IS NOT NULL THEN 'de_DE' ELSE NULL END AS "SourceLocale" FROM "SiteTree_Live" LEFT JOIN "Page_Live" ON "Page_Live"."ID" = "SiteTree_Live"."ID" LEFT JOIN "HomePage_Live" ON "HomePage_Live"."ID" = "SiteTree_Live"."ID" LEFT JOIN "SiteTree_Localised_Live" AS "SiteTree_Localised_en_US" ON "SiteTree_Live"."ID" = "SiteTree_Localised_en_US"."RecordID" AND "SiteTree_Localised_en_US"."Locale" = ? LEFT JOIN "SiteTree_Localised_Live" AS "SiteTree_Localised_de_DE" ON "SiteTree_Live"."ID" = "SiteTree_Localised_de_DE"."RecordID" AND "SiteTree_Localised_de_DE"."Locale" = ? LEFT JOIN "Page_Localised_Live" AS "Page_Localised_en_US" ON "Page_Live"."ID" = "Page_Localised_en_US"."RecordID" AND "Page_Localised_en_US"."Locale" = ? LEFT JOIN "Page_Localised_Live" AS "Page_Localised_de_DE" ON "Page_Live"."ID" = "Page_Localised_de_DE"."RecordID" AND "Page_Localised_de_DE"."Locale" = ? WHERE (("HomePage_Live"."ElementalAreaID" = ?)) AND ("SiteTree_Live"."ClassName" IN (?)) AND ("SiteTree_Live"."SubsiteID" IN (2)) AND (("SiteTree_Localised_en_US"."ID" IS NOT NULL) OR ("SiteTree_Localised_de_DE"."ID" IS NOT NULL)) ORDER BY "SiteTree_Live"."Sort" ASC LIMIT 1 0.0008s
0086: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", "SiteTree_Live"."CanViewType", "SiteTree_Live"."CanEditType", "SiteTree_Live"."Version", CASE WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."Title" 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_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."URLSegment" 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_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."MenuTitle" 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_Live"."ClassName" IN ('SilverStripe\\CMS\\Model\\SiteTree', 'Page', 'AlternativeLandingPage', 'ApplicationFormPage', 'ContactPage', 'ElementalPage', 'HomePage', 'VIPChipRegistrationPage', 'MoritzSauer\\EventCalendar\\EventCalendarPage', 'SilverStripe\\ErrorPage\\ErrorPage', 'Job\\JobsPage', 'Tietge\\SocialWall\\SocialPage', 'Team\\Pages\\TeamPage', 'SilverStripe\\Blog\\Model\\Blog', 'SilverStripe\\Blog\\Model\\BlogPost', 'SilverStripe\\CMS\\Model\\RedirectorPage', 'SilverStripe\\CMS\\Model\\VirtualPage', 'SilverStripe\\UserForms\\Model\\UserDefinedForm', 'XD\\Events\\Model\\EventPage', 'XD\\Events\\Model\\EventsPage', 'SilverStripe\\Subsites\\Pages\\SubsitesVirtualPage') THEN "SiteTree_Live"."Content" WHEN "SiteTree_Live"."ClassName" IN ('Page', 'AlternativeLandingPage', 'ApplicationFormPage', 'ContactPage', 'ElementalPage', 'HomePage', 'VIPChipRegistrationPage', 'MoritzSauer\\EventCalendar\\EventCalendarPage', 'SilverStripe\\ErrorPage\\ErrorPage', 'Job\\JobsPage', 'Tietge\\SocialWall\\SocialPage', 'Team\\Pages\\TeamPage', 'SilverStripe\\Blog\\Model\\Blog', 'SilverStripe\\Blog\\Model\\BlogPost', 'SilverStripe\\CMS\\Model\\RedirectorPage', 'SilverStripe\\CMS\\Model\\VirtualPage', 'SilverStripe\\UserForms\\Model\\UserDefinedForm', 'XD\\Events\\Model\\EventPage', 'XD\\Events\\Model\\EventsPage', 'SilverStripe\\Subsites\\Pages\\SubsitesVirtualPage') THEN "Page_Live"."Content" WHEN "SiteTree_Live"."ClassName" IN ('Page', 'AlternativeLandingPage', 'ApplicationFormPage', 'ContactPage', 'ElementalPage', 'HomePage', 'VIPChipRegistrationPage', 'MoritzSauer\\EventCalendar\\EventCalendarPage', 'SilverStripe\\ErrorPage\\ErrorPage', 'Job\\JobsPage', 'Tietge\\SocialWall\\SocialPage', 'Team\\Pages\\TeamPage', 'SilverStripe\\Blog\\Model\\Blog', 'SilverStripe\\Blog\\Model\\BlogPost', 'SilverStripe\\CMS\\Model\\RedirectorPage', 'SilverStripe\\CMS\\Model\\VirtualPage', 'SilverStripe\\UserForms\\Model\\UserDefinedForm', 'XD\\Events\\Model\\EventPage', 'XD\\Events\\Model\\EventsPage', 'SilverStripe\\Subsites\\Pages\\SubsitesVirtualPage') THEN "Page_Live"."Content" ELSE NULL END AS "Content", CASE WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."MetaDescription" 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_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."ReportClass" WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."ReportClass" ELSE "SiteTree_Live"."ReportClass" END AS "ReportClass", "SiteTree_Live"."SubsiteID", "SiteTree_Live"."ParentID", CASE WHEN "Page_Localised_en_US"."ID" IS NOT NULL THEN "Page_Localised_en_US"."OGTitleCustom" WHEN "Page_Localised_de_DE"."ID" IS NOT NULL THEN "Page_Localised_de_DE"."OGTitleCustom" ELSE "Page_Live"."OGTitleCustom" END AS "OGTitleCustom", CASE WHEN "Page_Localised_en_US"."ID" IS NOT NULL THEN "Page_Localised_en_US"."OGDescriptionCustom" WHEN "Page_Localised_de_DE"."ID" IS NOT NULL THEN "Page_Localised_de_DE"."OGDescriptionCustom" ELSE "Page_Live"."OGDescriptionCustom" END AS "OGDescriptionCustom", CASE WHEN "Page_Localised_en_US"."ID" IS NOT NULL THEN "Page_Localised_en_US"."SubTitle" WHEN "Page_Localised_de_DE"."ID" IS NOT NULL THEN "Page_Localised_de_DE"."SubTitle" ELSE "Page_Live"."SubTitle" END AS "SubTitle", "Page_Live"."ShowInLegalMenu", CASE WHEN "Page_Localised_en_US"."ID" IS NOT NULL THEN "Page_Localised_en_US"."MetaTitle" WHEN "Page_Localised_de_DE"."ID" IS NOT NULL THEN "Page_Localised_de_DE"."MetaTitle" ELSE "Page_Live"."MetaTitle" END AS "MetaTitle", "Page_Live"."ShowInNaviEingeklappt", "Page_Live"."ShowNewsletterInFooter", "Page_Live"."ShowPageHeaderGradient", "Page_Live"."OGImageCustomID", "Page_Live"."PinterestImageCustomID", "Page_Live"."HeaderImageID", "Page_Live"."VideoMP4ID", "Page_Live"."VideoOGVID", "Page_Live"."ImageID", CASE WHEN "JobsPage_Localised_en_US"."ID" IS NOT NULL THEN "JobsPage_Localised_en_US"."JobsTitle" WHEN "JobsPage_Localised_de_DE"."ID" IS NOT NULL THEN "JobsPage_Localised_de_DE"."JobsTitle" ELSE "JobsPage_Live"."JobsTitle" END AS "JobsTitle", CASE WHEN "JobsPage_Localised_en_US"."ID" IS NOT NULL THEN "JobsPage_Localised_en_US"."JobsSubTitle" WHEN "JobsPage_Localised_de_DE"."ID" IS NOT NULL THEN "JobsPage_Localised_de_DE"."JobsSubTitle" ELSE "JobsPage_Live"."JobsSubTitle" END AS "JobsSubTitle", CASE WHEN "JobsPage_Localised_en_US"."ID" IS NOT NULL THEN "JobsPage_Localised_en_US"."ContentTitle" WHEN "JobsPage_Localised_de_DE"."ID" IS NOT NULL THEN "JobsPage_Localised_de_DE"."ContentTitle" ELSE "JobsPage_Live"."ContentTitle" END AS "ContentTitle", CASE WHEN "JobsPage_Localised_en_US"."ID" IS NOT NULL THEN "JobsPage_Localised_en_US"."ContentSubTitle" WHEN "JobsPage_Localised_de_DE"."ID" IS NOT NULL THEN "JobsPage_Localised_de_DE"."ContentSubTitle" ELSE "JobsPage_Live"."ContentSubTitle" END AS "ContentSubTitle", CASE WHEN "JobsPage_Localised_en_US"."ID" IS NOT NULL THEN "JobsPage_Localised_en_US"."InitiativBewerbungsText" WHEN "JobsPage_Localised_de_DE"."ID" IS NOT NULL THEN "JobsPage_Localised_de_DE"."InitiativBewerbungsText" ELSE "JobsPage_Live"."InitiativBewerbungsText" END AS "InitiativBewerbungsText", CASE WHEN "JobsPage_Localised_en_US"."ID" IS NOT NULL THEN "JobsPage_Localised_en_US"."FragenText" WHEN "JobsPage_Localised_de_DE"."ID" IS NOT NULL THEN "JobsPage_Localised_de_DE"."FragenText" ELSE "JobsPage_Live"."FragenText" END AS "FragenText", CASE WHEN "JobsPage_Localised_en_US"."ID" IS NOT NULL THEN "JobsPage_Localised_en_US"."BewerbungsMail" WHEN "JobsPage_Localised_de_DE"."ID" IS NOT NULL THEN "JobsPage_Localised_de_DE"."BewerbungsMail" ELSE "JobsPage_Live"."BewerbungsMail" END AS "BewerbungsMail", "JobsPage_Live"."ElementalAreaID", "JobsPage_Live"."SecondElementalAreaID", "JobsPage_Live"."InitiativBewerbungsImageID", "SiteTree_Live"."ID", CASE WHEN "SiteTree_Live"."ClassName" IS NOT NULL THEN "SiteTree_Live"."ClassName" ELSE 'SilverStripe\\CMS\\Model\\SiteTree' END AS "RecordClassName", 'en_US' AS "Locale", CASE WHEN "JobsPage_Localised_en_US"."ID" IS NOT NULL THEN 'en_US' WHEN "JobsPage_Localised_de_DE"."ID" IS NOT NULL THEN 'de_DE' ELSE NULL END AS "SourceLocale" FROM "SiteTree_Live" LEFT JOIN "Page_Live" ON "Page_Live"."ID" = "SiteTree_Live"."ID" LEFT JOIN "JobsPage_Live" ON "JobsPage_Live"."ID" = "SiteTree_Live"."ID" LEFT JOIN "SiteTree_Localised_Live" AS "SiteTree_Localised_en_US" ON "SiteTree_Live"."ID" = "SiteTree_Localised_en_US"."RecordID" AND "SiteTree_Localised_en_US"."Locale" = ? LEFT JOIN "SiteTree_Localised_Live" AS "SiteTree_Localised_de_DE" ON "SiteTree_Live"."ID" = "SiteTree_Localised_de_DE"."RecordID" AND "SiteTree_Localised_de_DE"."Locale" = ? LEFT JOIN "Page_Localised_Live" AS "Page_Localised_en_US" ON "Page_Live"."ID" = "Page_Localised_en_US"."RecordID" AND "Page_Localised_en_US"."Locale" = ? LEFT JOIN "Page_Localised_Live" AS "Page_Localised_de_DE" ON "Page_Live"."ID" = "Page_Localised_de_DE"."RecordID" AND "Page_Localised_de_DE"."Locale" = ? LEFT JOIN "JobsPage_Localised_Live" AS "JobsPage_Localised_en_US" ON "JobsPage_Live"."ID" = "JobsPage_Localised_en_US"."RecordID" AND "JobsPage_Localised_en_US"."Locale" = ? LEFT JOIN "JobsPage_Localised_Live" AS "JobsPage_Localised_de_DE" ON "JobsPage_Live"."ID" = "JobsPage_Localised_de_DE"."RecordID" AND "JobsPage_Localised_de_DE"."Locale" = ? WHERE (("JobsPage_Live"."ElementalAreaID" = ?) OR ("JobsPage_Live"."SecondElementalAreaID" = ?)) AND ("SiteTree_Live"."ClassName" IN (?)) AND ("SiteTree_Live"."SubsiteID" IN (2)) AND (("SiteTree_Localised_en_US"."ID" IS NOT NULL) OR ("SiteTree_Localised_de_DE"."ID" IS NOT NULL)) ORDER BY "SiteTree_Live"."Sort" ASC LIMIT 1 0.001s
0087: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", "SiteTree_Live"."CanViewType", "SiteTree_Live"."CanEditType", "SiteTree_Live"."Version", CASE WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."Title" 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_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."URLSegment" 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_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."MenuTitle" 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_Live"."ClassName" IN ('SilverStripe\\CMS\\Model\\SiteTree', 'Page', 'AlternativeLandingPage', 'ApplicationFormPage', 'ContactPage', 'ElementalPage', 'HomePage', 'VIPChipRegistrationPage', 'MoritzSauer\\EventCalendar\\EventCalendarPage', 'SilverStripe\\ErrorPage\\ErrorPage', 'Job\\JobsPage', 'Tietge\\SocialWall\\SocialPage', 'Team\\Pages\\TeamPage', 'SilverStripe\\Blog\\Model\\Blog', 'SilverStripe\\Blog\\Model\\BlogPost', 'SilverStripe\\CMS\\Model\\RedirectorPage', 'SilverStripe\\CMS\\Model\\VirtualPage', 'SilverStripe\\UserForms\\Model\\UserDefinedForm', 'XD\\Events\\Model\\EventPage', 'XD\\Events\\Model\\EventsPage', 'SilverStripe\\Subsites\\Pages\\SubsitesVirtualPage') THEN "SiteTree_Live"."Content" WHEN "SiteTree_Live"."ClassName" IN ('Page', 'AlternativeLandingPage', 'ApplicationFormPage', 'ContactPage', 'ElementalPage', 'HomePage', 'VIPChipRegistrationPage', 'MoritzSauer\\EventCalendar\\EventCalendarPage', 'SilverStripe\\ErrorPage\\ErrorPage', 'Job\\JobsPage', 'Tietge\\SocialWall\\SocialPage', 'Team\\Pages\\TeamPage', 'SilverStripe\\Blog\\Model\\Blog', 'SilverStripe\\Blog\\Model\\BlogPost', 'SilverStripe\\CMS\\Model\\RedirectorPage', 'SilverStripe\\CMS\\Model\\VirtualPage', 'SilverStripe\\UserForms\\Model\\UserDefinedForm', 'XD\\Events\\Model\\EventPage', 'XD\\Events\\Model\\EventsPage', 'SilverStripe\\Subsites\\Pages\\SubsitesVirtualPage') THEN "Page_Live"."Content" WHEN "SiteTree_Live"."ClassName" IN ('Page', 'AlternativeLandingPage', 'ApplicationFormPage', 'ContactPage', 'ElementalPage', 'HomePage', 'VIPChipRegistrationPage', 'MoritzSauer\\EventCalendar\\EventCalendarPage', 'SilverStripe\\ErrorPage\\ErrorPage', 'Job\\JobsPage', 'Tietge\\SocialWall\\SocialPage', 'Team\\Pages\\TeamPage', 'SilverStripe\\Blog\\Model\\Blog', 'SilverStripe\\Blog\\Model\\BlogPost', 'SilverStripe\\CMS\\Model\\RedirectorPage', 'SilverStripe\\CMS\\Model\\VirtualPage', 'SilverStripe\\UserForms\\Model\\UserDefinedForm', 'XD\\Events\\Model\\EventPage', 'XD\\Events\\Model\\EventsPage', 'SilverStripe\\Subsites\\Pages\\SubsitesVirtualPage') THEN "Page_Live"."Content" ELSE NULL END AS "Content", CASE WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."MetaDescription" 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_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."ReportClass" WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."ReportClass" ELSE "SiteTree_Live"."ReportClass" END AS "ReportClass", "SiteTree_Live"."SubsiteID", "SiteTree_Live"."ParentID", CASE WHEN "Page_Localised_en_US"."ID" IS NOT NULL THEN "Page_Localised_en_US"."OGTitleCustom" WHEN "Page_Localised_de_DE"."ID" IS NOT NULL THEN "Page_Localised_de_DE"."OGTitleCustom" ELSE "Page_Live"."OGTitleCustom" END AS "OGTitleCustom", CASE WHEN "Page_Localised_en_US"."ID" IS NOT NULL THEN "Page_Localised_en_US"."OGDescriptionCustom" WHEN "Page_Localised_de_DE"."ID" IS NOT NULL THEN "Page_Localised_de_DE"."OGDescriptionCustom" ELSE "Page_Live"."OGDescriptionCustom" END AS "OGDescriptionCustom", CASE WHEN "Page_Localised_en_US"."ID" IS NOT NULL THEN "Page_Localised_en_US"."SubTitle" WHEN "Page_Localised_de_DE"."ID" IS NOT NULL THEN "Page_Localised_de_DE"."SubTitle" ELSE "Page_Live"."SubTitle" END AS "SubTitle", "Page_Live"."ShowInLegalMenu", CASE WHEN "Page_Localised_en_US"."ID" IS NOT NULL THEN "Page_Localised_en_US"."MetaTitle" WHEN "Page_Localised_de_DE"."ID" IS NOT NULL THEN "Page_Localised_de_DE"."MetaTitle" ELSE "Page_Live"."MetaTitle" END AS "MetaTitle", "Page_Live"."ShowInNaviEingeklappt", "Page_Live"."ShowNewsletterInFooter", "Page_Live"."ShowPageHeaderGradient", "Page_Live"."OGImageCustomID", "Page_Live"."PinterestImageCustomID", "Page_Live"."HeaderImageID", "Page_Live"."VideoMP4ID", "Page_Live"."VideoOGVID", "Page_Live"."ImageID", "TeamPage_Live"."ElementalAreaID", "SiteTree_Live"."ID", CASE WHEN "SiteTree_Live"."ClassName" IS NOT NULL THEN "SiteTree_Live"."ClassName" ELSE 'SilverStripe\\CMS\\Model\\SiteTree' END AS "RecordClassName", 'en_US' AS "Locale", CASE WHEN "Page_Localised_en_US"."ID" IS NOT NULL THEN 'en_US' WHEN "Page_Localised_de_DE"."ID" IS NOT NULL THEN 'de_DE' ELSE NULL END AS "SourceLocale" FROM "SiteTree_Live" LEFT JOIN "Page_Live" ON "Page_Live"."ID" = "SiteTree_Live"."ID" LEFT JOIN "TeamPage_Live" ON "TeamPage_Live"."ID" = "SiteTree_Live"."ID" LEFT JOIN "SiteTree_Localised_Live" AS "SiteTree_Localised_en_US" ON "SiteTree_Live"."ID" = "SiteTree_Localised_en_US"."RecordID" AND "SiteTree_Localised_en_US"."Locale" = ? LEFT JOIN "SiteTree_Localised_Live" AS "SiteTree_Localised_de_DE" ON "SiteTree_Live"."ID" = "SiteTree_Localised_de_DE"."RecordID" AND "SiteTree_Localised_de_DE"."Locale" = ? LEFT JOIN "Page_Localised_Live" AS "Page_Localised_en_US" ON "Page_Live"."ID" = "Page_Localised_en_US"."RecordID" AND "Page_Localised_en_US"."Locale" = ? LEFT JOIN "Page_Localised_Live" AS "Page_Localised_de_DE" ON "Page_Live"."ID" = "Page_Localised_de_DE"."RecordID" AND "Page_Localised_de_DE"."Locale" = ? WHERE (("TeamPage_Live"."ElementalAreaID" = ?)) AND ("SiteTree_Live"."ClassName" IN (?)) AND ("SiteTree_Live"."SubsiteID" IN (2)) AND (("SiteTree_Localised_en_US"."ID" IS NOT NULL) OR ("SiteTree_Localised_de_DE"."ID" IS NOT NULL)) ORDER BY "SiteTree_Live"."Sort" ASC LIMIT 1 0.0007s
0088: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", "SiteTree_Live"."CanViewType", "SiteTree_Live"."CanEditType", "SiteTree_Live"."Version", CASE WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."Title" 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_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."URLSegment" 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_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."MenuTitle" 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_Live"."ClassName" IN ('SilverStripe\\CMS\\Model\\SiteTree', 'Page', 'AlternativeLandingPage', 'ApplicationFormPage', 'ContactPage', 'ElementalPage', 'HomePage', 'VIPChipRegistrationPage', 'MoritzSauer\\EventCalendar\\EventCalendarPage', 'SilverStripe\\ErrorPage\\ErrorPage', 'Job\\JobsPage', 'Tietge\\SocialWall\\SocialPage', 'Team\\Pages\\TeamPage', 'SilverStripe\\Blog\\Model\\Blog', 'SilverStripe\\Blog\\Model\\BlogPost', 'SilverStripe\\CMS\\Model\\RedirectorPage', 'SilverStripe\\CMS\\Model\\VirtualPage', 'SilverStripe\\UserForms\\Model\\UserDefinedForm', 'XD\\Events\\Model\\EventPage', 'XD\\Events\\Model\\EventsPage', 'SilverStripe\\Subsites\\Pages\\SubsitesVirtualPage') THEN "SiteTree_Live"."Content" WHEN "SiteTree_Live"."ClassName" IN ('Page', 'AlternativeLandingPage', 'ApplicationFormPage', 'ContactPage', 'ElementalPage', 'HomePage', 'VIPChipRegistrationPage', 'MoritzSauer\\EventCalendar\\EventCalendarPage', 'SilverStripe\\ErrorPage\\ErrorPage', 'Job\\JobsPage', 'Tietge\\SocialWall\\SocialPage', 'Team\\Pages\\TeamPage', 'SilverStripe\\Blog\\Model\\Blog', 'SilverStripe\\Blog\\Model\\BlogPost', 'SilverStripe\\CMS\\Model\\RedirectorPage', 'SilverStripe\\CMS\\Model\\VirtualPage', 'SilverStripe\\UserForms\\Model\\UserDefinedForm', 'XD\\Events\\Model\\EventPage', 'XD\\Events\\Model\\EventsPage', 'SilverStripe\\Subsites\\Pages\\SubsitesVirtualPage') THEN "Page_Live"."Content" WHEN "SiteTree_Live"."ClassName" IN ('Page', 'AlternativeLandingPage', 'ApplicationFormPage', 'ContactPage', 'ElementalPage', 'HomePage', 'VIPChipRegistrationPage', 'MoritzSauer\\EventCalendar\\EventCalendarPage', 'SilverStripe\\ErrorPage\\ErrorPage', 'Job\\JobsPage', 'Tietge\\SocialWall\\SocialPage', 'Team\\Pages\\TeamPage', 'SilverStripe\\Blog\\Model\\Blog', 'SilverStripe\\Blog\\Model\\BlogPost', 'SilverStripe\\CMS\\Model\\RedirectorPage', 'SilverStripe\\CMS\\Model\\VirtualPage', 'SilverStripe\\UserForms\\Model\\UserDefinedForm', 'XD\\Events\\Model\\EventPage', 'XD\\Events\\Model\\EventsPage', 'SilverStripe\\Subsites\\Pages\\SubsitesVirtualPage') THEN "Page_Live"."Content" ELSE NULL END AS "Content", CASE WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."MetaDescription" 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_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."ReportClass" WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."ReportClass" ELSE "SiteTree_Live"."ReportClass" END AS "ReportClass", "SiteTree_Live"."SubsiteID", "SiteTree_Live"."ParentID", CASE WHEN "Page_Localised_en_US"."ID" IS NOT NULL THEN "Page_Localised_en_US"."OGTitleCustom" WHEN "Page_Localised_de_DE"."ID" IS NOT NULL THEN "Page_Localised_de_DE"."OGTitleCustom" ELSE "Page_Live"."OGTitleCustom" END AS "OGTitleCustom", CASE WHEN "Page_Localised_en_US"."ID" IS NOT NULL THEN "Page_Localised_en_US"."OGDescriptionCustom" WHEN "Page_Localised_de_DE"."ID" IS NOT NULL THEN "Page_Localised_de_DE"."OGDescriptionCustom" ELSE "Page_Live"."OGDescriptionCustom" END AS "OGDescriptionCustom", CASE WHEN "Page_Localised_en_US"."ID" IS NOT NULL THEN "Page_Localised_en_US"."SubTitle" WHEN "Page_Localised_de_DE"."ID" IS NOT NULL THEN "Page_Localised_de_DE"."SubTitle" ELSE "Page_Live"."SubTitle" END AS "SubTitle", "Page_Live"."ShowInLegalMenu", CASE WHEN "Page_Localised_en_US"."ID" IS NOT NULL THEN "Page_Localised_en_US"."MetaTitle" WHEN "Page_Localised_de_DE"."ID" IS NOT NULL THEN "Page_Localised_de_DE"."MetaTitle" ELSE "Page_Live"."MetaTitle" END AS "MetaTitle", "Page_Live"."ShowInNaviEingeklappt", "Page_Live"."ShowNewsletterInFooter", "Page_Live"."ShowPageHeaderGradient", "Page_Live"."OGImageCustomID", "Page_Live"."PinterestImageCustomID", "Page_Live"."HeaderImageID", "Page_Live"."VideoMP4ID", "Page_Live"."VideoOGVID", "Page_Live"."ImageID", "Blog_Live"."PostsPerPage", "Blog_Live"."ElementalAreaID", "SiteTree_Live"."ID", CASE WHEN "SiteTree_Live"."ClassName" IS NOT NULL THEN "SiteTree_Live"."ClassName" ELSE 'SilverStripe\\CMS\\Model\\SiteTree' END AS "RecordClassName", 'en_US' AS "Locale", CASE WHEN "Page_Localised_en_US"."ID" IS NOT NULL THEN 'en_US' WHEN "Page_Localised_de_DE"."ID" IS NOT NULL THEN 'de_DE' ELSE NULL END AS "SourceLocale" FROM "SiteTree_Live" LEFT JOIN "Page_Live" ON "Page_Live"."ID" = "SiteTree_Live"."ID" LEFT JOIN "Blog_Live" ON "Blog_Live"."ID" = "SiteTree_Live"."ID" LEFT JOIN "SiteTree_Localised_Live" AS "SiteTree_Localised_en_US" ON "SiteTree_Live"."ID" = "SiteTree_Localised_en_US"."RecordID" AND "SiteTree_Localised_en_US"."Locale" = ? LEFT JOIN "SiteTree_Localised_Live" AS "SiteTree_Localised_de_DE" ON "SiteTree_Live"."ID" = "SiteTree_Localised_de_DE"."RecordID" AND "SiteTree_Localised_de_DE"."Locale" = ? LEFT JOIN "Page_Localised_Live" AS "Page_Localised_en_US" ON "Page_Live"."ID" = "Page_Localised_en_US"."RecordID" AND "Page_Localised_en_US"."Locale" = ? LEFT JOIN "Page_Localised_Live" AS "Page_Localised_de_DE" ON "Page_Live"."ID" = "Page_Localised_de_DE"."RecordID" AND "Page_Localised_de_DE"."Locale" = ? WHERE (("Blog_Live"."ElementalAreaID" = ?)) AND ("SiteTree_Live"."ClassName" IN (?)) AND ("SiteTree_Live"."SubsiteID" IN (2)) AND (("SiteTree_Localised_en_US"."ID" IS NOT NULL) OR ("SiteTree_Localised_de_DE"."ID" IS NOT NULL)) ORDER BY "SiteTree_Live"."Sort" ASC LIMIT 1 0.0008s
0089: SELECT DISTINCT "PublishDate" IS NULL AS "_SortColumn0", "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", "SiteTree_Live"."CanViewType", "SiteTree_Live"."CanEditType", "SiteTree_Live"."Version", CASE WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."Title" 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_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."URLSegment" 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_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."MenuTitle" 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_Live"."ClassName" IN ('SilverStripe\\CMS\\Model\\SiteTree', 'Page', 'AlternativeLandingPage', 'ApplicationFormPage', 'ContactPage', 'ElementalPage', 'HomePage', 'VIPChipRegistrationPage', 'MoritzSauer\\EventCalendar\\EventCalendarPage', 'SilverStripe\\ErrorPage\\ErrorPage', 'Job\\JobsPage', 'Tietge\\SocialWall\\SocialPage', 'Team\\Pages\\TeamPage', 'SilverStripe\\Blog\\Model\\Blog', 'SilverStripe\\Blog\\Model\\BlogPost', 'SilverStripe\\CMS\\Model\\RedirectorPage', 'SilverStripe\\CMS\\Model\\VirtualPage', 'SilverStripe\\UserForms\\Model\\UserDefinedForm', 'XD\\Events\\Model\\EventPage', 'XD\\Events\\Model\\EventsPage', 'SilverStripe\\Subsites\\Pages\\SubsitesVirtualPage') THEN "SiteTree_Live"."Content" WHEN "SiteTree_Live"."ClassName" IN ('Page', 'AlternativeLandingPage', 'ApplicationFormPage', 'ContactPage', 'ElementalPage', 'HomePage', 'VIPChipRegistrationPage', 'MoritzSauer\\EventCalendar\\EventCalendarPage', 'SilverStripe\\ErrorPage\\ErrorPage', 'Job\\JobsPage', 'Tietge\\SocialWall\\SocialPage', 'Team\\Pages\\TeamPage', 'SilverStripe\\Blog\\Model\\Blog', 'SilverStripe\\Blog\\Model\\BlogPost', 'SilverStripe\\CMS\\Model\\RedirectorPage', 'SilverStripe\\CMS\\Model\\VirtualPage', 'SilverStripe\\UserForms\\Model\\UserDefinedForm', 'XD\\Events\\Model\\EventPage', 'XD\\Events\\Model\\EventsPage', 'SilverStripe\\Subsites\\Pages\\SubsitesVirtualPage') THEN "Page_Live"."Content" WHEN "SiteTree_Live"."ClassName" IN ('Page', 'AlternativeLandingPage', 'ApplicationFormPage', 'ContactPage', 'ElementalPage', 'HomePage', 'VIPChipRegistrationPage', 'MoritzSauer\\EventCalendar\\EventCalendarPage', 'SilverStripe\\ErrorPage\\ErrorPage', 'Job\\JobsPage', 'Tietge\\SocialWall\\SocialPage', 'Team\\Pages\\TeamPage', 'SilverStripe\\Blog\\Model\\Blog', 'SilverStripe\\Blog\\Model\\BlogPost', 'SilverStripe\\CMS\\Model\\RedirectorPage', 'SilverStripe\\CMS\\Model\\VirtualPage', 'SilverStripe\\UserForms\\Model\\UserDefinedForm', 'XD\\Events\\Model\\EventPage', 'XD\\Events\\Model\\EventsPage', 'SilverStripe\\Subsites\\Pages\\SubsitesVirtualPage') THEN "Page_Live"."Content" ELSE NULL END AS "Content", CASE WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."MetaDescription" 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_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."ReportClass" WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."ReportClass" ELSE "SiteTree_Live"."ReportClass" END AS "ReportClass", "SiteTree_Live"."SubsiteID", "SiteTree_Live"."ParentID", CASE WHEN "Page_Localised_en_US"."ID" IS NOT NULL THEN "Page_Localised_en_US"."OGTitleCustom" WHEN "Page_Localised_de_DE"."ID" IS NOT NULL THEN "Page_Localised_de_DE"."OGTitleCustom" ELSE "Page_Live"."OGTitleCustom" END AS "OGTitleCustom", CASE WHEN "Page_Localised_en_US"."ID" IS NOT NULL THEN "Page_Localised_en_US"."OGDescriptionCustom" WHEN "Page_Localised_de_DE"."ID" IS NOT NULL THEN "Page_Localised_de_DE"."OGDescriptionCustom" ELSE "Page_Live"."OGDescriptionCustom" END AS "OGDescriptionCustom", CASE WHEN "Page_Localised_en_US"."ID" IS NOT NULL THEN "Page_Localised_en_US"."SubTitle" WHEN "Page_Localised_de_DE"."ID" IS NOT NULL THEN "Page_Localised_de_DE"."SubTitle" ELSE "Page_Live"."SubTitle" END AS "SubTitle", "Page_Live"."ShowInLegalMenu", CASE WHEN "Page_Localised_en_US"."ID" IS NOT NULL THEN "Page_Localised_en_US"."MetaTitle" WHEN "Page_Localised_de_DE"."ID" IS NOT NULL THEN "Page_Localised_de_DE"."MetaTitle" ELSE "Page_Live"."MetaTitle" END AS "MetaTitle", "Page_Live"."ShowInNaviEingeklappt", "Page_Live"."ShowNewsletterInFooter", "Page_Live"."ShowPageHeaderGradient", "Page_Live"."OGImageCustomID", "Page_Live"."PinterestImageCustomID", "Page_Live"."HeaderImageID", "Page_Live"."VideoMP4ID", "Page_Live"."VideoOGVID", "Page_Live"."ImageID", "BlogPost_Live"."PublishDate", CASE WHEN "BlogPost_Localised_en_US"."ID" IS NOT NULL THEN "BlogPost_Localised_en_US"."AuthorNames" WHEN "BlogPost_Localised_de_DE"."ID" IS NOT NULL THEN "BlogPost_Localised_de_DE"."AuthorNames" ELSE "BlogPost_Live"."AuthorNames" END AS "AuthorNames", CASE WHEN "BlogPost_Localised_en_US"."ID" IS NOT NULL THEN "BlogPost_Localised_en_US"."Summary" WHEN "BlogPost_Localised_de_DE"."ID" IS NOT NULL THEN "BlogPost_Localised_de_DE"."Summary" ELSE "BlogPost_Live"."Summary" END AS "Summary", "BlogPost_Live"."ElementalAreaID", "BlogPost_Live"."FeaturedImageID", "SiteTree_Live"."ID", CASE WHEN "SiteTree_Live"."ClassName" IS NOT NULL THEN "SiteTree_Live"."ClassName" ELSE 'SilverStripe\\CMS\\Model\\SiteTree' END AS "RecordClassName", 'en_US' AS "Locale", CASE WHEN "BlogPost_Localised_en_US"."ID" IS NOT NULL THEN 'en_US' WHEN "BlogPost_Localised_de_DE"."ID" IS NOT NULL THEN 'de_DE' ELSE NULL END AS "SourceLocale" FROM "SiteTree_Live" LEFT JOIN "Page_Live" ON "Page_Live"."ID" = "SiteTree_Live"."ID" LEFT JOIN "BlogPost_Live" ON "BlogPost_Live"."ID" = "SiteTree_Live"."ID" LEFT JOIN "SiteTree_Localised_Live" AS "SiteTree_Localised_en_US" ON "SiteTree_Live"."ID" = "SiteTree_Localised_en_US"."RecordID" AND "SiteTree_Localised_en_US"."Locale" = ? LEFT JOIN "SiteTree_Localised_Live" AS "SiteTree_Localised_de_DE" ON "SiteTree_Live"."ID" = "SiteTree_Localised_de_DE"."RecordID" AND "SiteTree_Localised_de_DE"."Locale" = ? LEFT JOIN "Page_Localised_Live" AS "Page_Localised_en_US" ON "Page_Live"."ID" = "Page_Localised_en_US"."RecordID" AND "Page_Localised_en_US"."Locale" = ? LEFT JOIN "Page_Localised_Live" AS "Page_Localised_de_DE" ON "Page_Live"."ID" = "Page_Localised_de_DE"."RecordID" AND "Page_Localised_de_DE"."Locale" = ? LEFT JOIN "BlogPost_Localised_Live" AS "BlogPost_Localised_en_US" ON "BlogPost_Live"."ID" = "BlogPost_Localised_en_US"."RecordID" AND "BlogPost_Localised_en_US"."Locale" = ? LEFT JOIN "BlogPost_Localised_Live" AS "BlogPost_Localised_de_DE" ON "BlogPost_Live"."ID" = "BlogPost_Localised_de_DE"."RecordID" AND "BlogPost_Localised_de_DE"."Locale" = ? WHERE (("BlogPost_Live"."ElementalAreaID" = ?)) AND ("SiteTree_Live"."ClassName" IN (?)) AND ("SiteTree_Live"."SubsiteID" IN (2)) AND (("SiteTree_Localised_en_US"."ID" IS NOT NULL) OR ("SiteTree_Localised_de_DE"."ID" IS NOT NULL)) AND ("PublishDate" < '2026-09-04 09:43:07') ORDER BY "_SortColumn0" DESC, "BlogPost_Live"."PublishDate" DESC LIMIT 1 0.0009s
0090: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", "SiteTree_Live"."CanViewType", "SiteTree_Live"."CanEditType", "SiteTree_Live"."Version", CASE WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."Title" 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_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."URLSegment" 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_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."MenuTitle" 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_Live"."ClassName" IN ('SilverStripe\\CMS\\Model\\SiteTree', 'Page', 'AlternativeLandingPage', 'ApplicationFormPage', 'ContactPage', 'ElementalPage', 'HomePage', 'VIPChipRegistrationPage', 'MoritzSauer\\EventCalendar\\EventCalendarPage', 'SilverStripe\\ErrorPage\\ErrorPage', 'Job\\JobsPage', 'Tietge\\SocialWall\\SocialPage', 'Team\\Pages\\TeamPage', 'SilverStripe\\Blog\\Model\\Blog', 'SilverStripe\\Blog\\Model\\BlogPost', 'SilverStripe\\CMS\\Model\\RedirectorPage', 'SilverStripe\\CMS\\Model\\VirtualPage', 'SilverStripe\\UserForms\\Model\\UserDefinedForm', 'XD\\Events\\Model\\EventPage', 'XD\\Events\\Model\\EventsPage', 'SilverStripe\\Subsites\\Pages\\SubsitesVirtualPage') THEN "SiteTree_Live"."Content" WHEN "SiteTree_Live"."ClassName" IN ('Page', 'AlternativeLandingPage', 'ApplicationFormPage', 'ContactPage', 'ElementalPage', 'HomePage', 'VIPChipRegistrationPage', 'MoritzSauer\\EventCalendar\\EventCalendarPage', 'SilverStripe\\ErrorPage\\ErrorPage', 'Job\\JobsPage', 'Tietge\\SocialWall\\SocialPage', 'Team\\Pages\\TeamPage', 'SilverStripe\\Blog\\Model\\Blog', 'SilverStripe\\Blog\\Model\\BlogPost', 'SilverStripe\\CMS\\Model\\RedirectorPage', 'SilverStripe\\CMS\\Model\\VirtualPage', 'SilverStripe\\UserForms\\Model\\UserDefinedForm', 'XD\\Events\\Model\\EventPage', 'XD\\Events\\Model\\EventsPage', 'SilverStripe\\Subsites\\Pages\\SubsitesVirtualPage') THEN "Page_Live"."Content" WHEN "SiteTree_Live"."ClassName" IN ('Page', 'AlternativeLandingPage', 'ApplicationFormPage', 'ContactPage', 'ElementalPage', 'HomePage', 'VIPChipRegistrationPage', 'MoritzSauer\\EventCalendar\\EventCalendarPage', 'SilverStripe\\ErrorPage\\ErrorPage', 'Job\\JobsPage', 'Tietge\\SocialWall\\SocialPage', 'Team\\Pages\\TeamPage', 'SilverStripe\\Blog\\Model\\Blog', 'SilverStripe\\Blog\\Model\\BlogPost', 'SilverStripe\\CMS\\Model\\RedirectorPage', 'SilverStripe\\CMS\\Model\\VirtualPage', 'SilverStripe\\UserForms\\Model\\UserDefinedForm', 'XD\\Events\\Model\\EventPage', 'XD\\Events\\Model\\EventsPage', 'SilverStripe\\Subsites\\Pages\\SubsitesVirtualPage') THEN "Page_Live"."Content" ELSE NULL END AS "Content", CASE WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."MetaDescription" 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_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."ReportClass" WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."ReportClass" ELSE "SiteTree_Live"."ReportClass" END AS "ReportClass", "SiteTree_Live"."SubsiteID", "SiteTree_Live"."ParentID", CASE WHEN "Page_Localised_en_US"."ID" IS NOT NULL THEN "Page_Localised_en_US"."OGTitleCustom" WHEN "Page_Localised_de_DE"."ID" IS NOT NULL THEN "Page_Localised_de_DE"."OGTitleCustom" ELSE "Page_Live"."OGTitleCustom" END AS "OGTitleCustom", CASE WHEN "Page_Localised_en_US"."ID" IS NOT NULL THEN "Page_Localised_en_US"."OGDescriptionCustom" WHEN "Page_Localised_de_DE"."ID" IS NOT NULL THEN "Page_Localised_de_DE"."OGDescriptionCustom" ELSE "Page_Live"."OGDescriptionCustom" END AS "OGDescriptionCustom", CASE WHEN "Page_Localised_en_US"."ID" IS NOT NULL THEN "Page_Localised_en_US"."SubTitle" WHEN "Page_Localised_de_DE"."ID" IS NOT NULL THEN "Page_Localised_de_DE"."SubTitle" ELSE "Page_Live"."SubTitle" END AS "SubTitle", "Page_Live"."ShowInLegalMenu", CASE WHEN "Page_Localised_en_US"."ID" IS NOT NULL THEN "Page_Localised_en_US"."MetaTitle" WHEN "Page_Localised_de_DE"."ID" IS NOT NULL THEN "Page_Localised_de_DE"."MetaTitle" ELSE "Page_Live"."MetaTitle" END AS "MetaTitle", "Page_Live"."ShowInNaviEingeklappt", "Page_Live"."ShowNewsletterInFooter", "Page_Live"."ShowPageHeaderGradient", "Page_Live"."OGImageCustomID", "Page_Live"."PinterestImageCustomID", "Page_Live"."HeaderImageID", "Page_Live"."VideoMP4ID", "Page_Live"."VideoOGVID", "Page_Live"."ImageID", CASE WHEN "EventsPage_Localised_en_US"."ID" IS NOT NULL THEN "EventsPage_Localised_en_US"."BreakStartTime" WHEN "EventsPage_Localised_de_DE"."ID" IS NOT NULL THEN "EventsPage_Localised_de_DE"."BreakStartTime" ELSE "EventsPage_Live"."BreakStartTime" END AS "BreakStartTime", CASE WHEN "EventsPage_Localised_en_US"."ID" IS NOT NULL THEN "EventsPage_Localised_en_US"."BreakEndTime" WHEN "EventsPage_Localised_de_DE"."ID" IS NOT NULL THEN "EventsPage_Localised_de_DE"."BreakEndTime" ELSE "EventsPage_Live"."BreakEndTime" END AS "BreakEndTime", "EventsPage_Live"."ShowCategories", "EventsPage_Live"."PostsPerPage", "EventsPage_Live"."SecondElementalAreaID", "EventsPage_Live"."ElementalAreaID", "SiteTree_Live"."ID", CASE WHEN "SiteTree_Live"."ClassName" IS NOT NULL THEN "SiteTree_Live"."ClassName" ELSE 'SilverStripe\\CMS\\Model\\SiteTree' END AS "RecordClassName", 'en_US' AS "Locale", CASE WHEN "EventsPage_Localised_en_US"."ID" IS NOT NULL THEN 'en_US' WHEN "EventsPage_Localised_de_DE"."ID" IS NOT NULL THEN 'de_DE' ELSE NULL END AS "SourceLocale" FROM "SiteTree_Live" LEFT JOIN "Page_Live" ON "Page_Live"."ID" = "SiteTree_Live"."ID" LEFT JOIN "EventsPage_Live" ON "EventsPage_Live"."ID" = "SiteTree_Live"."ID" LEFT JOIN "SiteTree_Localised_Live" AS "SiteTree_Localised_en_US" ON "SiteTree_Live"."ID" = "SiteTree_Localised_en_US"."RecordID" AND "SiteTree_Localised_en_US"."Locale" = ? LEFT JOIN "SiteTree_Localised_Live" AS "SiteTree_Localised_de_DE" ON "SiteTree_Live"."ID" = "SiteTree_Localised_de_DE"."RecordID" AND "SiteTree_Localised_de_DE"."Locale" = ? LEFT JOIN "Page_Localised_Live" AS "Page_Localised_en_US" ON "Page_Live"."ID" = "Page_Localised_en_US"."RecordID" AND "Page_Localised_en_US"."Locale" = ? LEFT JOIN "Page_Localised_Live" AS "Page_Localised_de_DE" ON "Page_Live"."ID" = "Page_Localised_de_DE"."RecordID" AND "Page_Localised_de_DE"."Locale" = ? LEFT JOIN "EventsPage_Localised_Live" AS "EventsPage_Localised_en_US" ON "EventsPage_Live"."ID" = "EventsPage_Localised_en_US"."RecordID" AND "EventsPage_Localised_en_US"."Locale" = ? LEFT JOIN "EventsPage_Localised_Live" AS "EventsPage_Localised_de_DE" ON "EventsPage_Live"."ID" = "EventsPage_Localised_de_DE"."RecordID" AND "EventsPage_Localised_de_DE"."Locale" = ? WHERE (("EventsPage_Live"."SecondElementalAreaID" = ?) OR ("EventsPage_Live"."ElementalAreaID" = ?)) AND ("SiteTree_Live"."ClassName" IN (?)) AND ("SiteTree_Live"."SubsiteID" IN (2)) AND (("SiteTree_Localised_en_US"."ID" IS NOT NULL) OR ("SiteTree_Localised_de_DE"."ID" IS NOT NULL)) ORDER BY "SiteTree_Live"."Sort" ASC LIMIT 1 0.0008s
0091: SELECT DISTINCT "ElementalArea_Live"."ClassName", "ElementalArea_Live"."LastEdited", "ElementalArea_Live"."Created", "ElementalArea_Live"."Version", "ElementalArea_Live"."OwnerClassName", "ElementalArea_Live"."TopPageID", "ElementalArea_Live"."ID", CASE WHEN "ElementalArea_Live"."ClassName" IS NOT NULL THEN "ElementalArea_Live"."ClassName" ELSE 'DNADesign\\Elemental\\Models\\ElementalArea' END AS "RecordClassName" FROM "ElementalArea_Live" WHERE ("ElementalArea_Live"."ID" = ?) LIMIT 1 0.0002s
0092: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", "SiteTree_Live"."CanViewType", "SiteTree_Live"."CanEditType", "SiteTree_Live"."Version", CASE WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."Title" 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_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."URLSegment" 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_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."MenuTitle" 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_Live"."ClassName" IN ('SilverStripe\\CMS\\Model\\SiteTree', 'Page', 'AlternativeLandingPage', 'ApplicationFormPage', 'ContactPage', 'ElementalPage', 'HomePage', 'VIPChipRegistrationPage', 'MoritzSauer\\EventCalendar\\EventCalendarPage', 'SilverStripe\\ErrorPage\\ErrorPage', 'Job\\JobsPage', 'Tietge\\SocialWall\\SocialPage', 'Team\\Pages\\TeamPage', 'SilverStripe\\Blog\\Model\\Blog', 'SilverStripe\\Blog\\Model\\BlogPost', 'SilverStripe\\CMS\\Model\\RedirectorPage', 'SilverStripe\\CMS\\Model\\VirtualPage', 'SilverStripe\\UserForms\\Model\\UserDefinedForm', 'XD\\Events\\Model\\EventPage', 'XD\\Events\\Model\\EventsPage', 'SilverStripe\\Subsites\\Pages\\SubsitesVirtualPage') THEN "SiteTree_Live"."Content" WHEN "SiteTree_Live"."ClassName" IN ('Page', 'AlternativeLandingPage', 'ApplicationFormPage', 'ContactPage', 'ElementalPage', 'HomePage', 'VIPChipRegistrationPage', 'MoritzSauer\\EventCalendar\\EventCalendarPage', 'SilverStripe\\ErrorPage\\ErrorPage', 'Job\\JobsPage', 'Tietge\\SocialWall\\SocialPage', 'Team\\Pages\\TeamPage', 'SilverStripe\\Blog\\Model\\Blog', 'SilverStripe\\Blog\\Model\\BlogPost', 'SilverStripe\\CMS\\Model\\RedirectorPage', 'SilverStripe\\CMS\\Model\\VirtualPage', 'SilverStripe\\UserForms\\Model\\UserDefinedForm', 'XD\\Events\\Model\\EventPage', 'XD\\Events\\Model\\EventsPage', 'SilverStripe\\Subsites\\Pages\\SubsitesVirtualPage') THEN "Page_Live"."Content" WHEN "SiteTree_Live"."ClassName" IN ('Page', 'AlternativeLandingPage', 'ApplicationFormPage', 'ContactPage', 'ElementalPage', 'HomePage', 'VIPChipRegistrationPage', 'MoritzSauer\\EventCalendar\\EventCalendarPage', 'SilverStripe\\ErrorPage\\ErrorPage', 'Job\\JobsPage', 'Tietge\\SocialWall\\SocialPage', 'Team\\Pages\\TeamPage', 'SilverStripe\\Blog\\Model\\Blog', 'SilverStripe\\Blog\\Model\\BlogPost', 'SilverStripe\\CMS\\Model\\RedirectorPage', 'SilverStripe\\CMS\\Model\\VirtualPage', 'SilverStripe\\UserForms\\Model\\UserDefinedForm', 'XD\\Events\\Model\\EventPage', 'XD\\Events\\Model\\EventsPage', 'SilverStripe\\Subsites\\Pages\\SubsitesVirtualPage') THEN "Page_Live"."Content" ELSE NULL END AS "Content", CASE WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."MetaDescription" 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_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."ReportClass" WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."ReportClass" ELSE "SiteTree_Live"."ReportClass" END AS "ReportClass", "SiteTree_Live"."SubsiteID", "SiteTree_Live"."ParentID", CASE WHEN "Page_Localised_en_US"."ID" IS NOT NULL THEN "Page_Localised_en_US"."OGTitleCustom" WHEN "Page_Localised_de_DE"."ID" IS NOT NULL THEN "Page_Localised_de_DE"."OGTitleCustom" ELSE "Page_Live"."OGTitleCustom" END AS "OGTitleCustom", CASE WHEN "Page_Localised_en_US"."ID" IS NOT NULL THEN "Page_Localised_en_US"."OGDescriptionCustom" WHEN "Page_Localised_de_DE"."ID" IS NOT NULL THEN "Page_Localised_de_DE"."OGDescriptionCustom" ELSE "Page_Live"."OGDescriptionCustom" END AS "OGDescriptionCustom", CASE WHEN "Page_Localised_en_US"."ID" IS NOT NULL THEN "Page_Localised_en_US"."SubTitle" WHEN "Page_Localised_de_DE"."ID" IS NOT NULL THEN "Page_Localised_de_DE"."SubTitle" ELSE "Page_Live"."SubTitle" END AS "SubTitle", "Page_Live"."ShowInLegalMenu", CASE WHEN "Page_Localised_en_US"."ID" IS NOT NULL THEN "Page_Localised_en_US"."MetaTitle" WHEN "Page_Localised_de_DE"."ID" IS NOT NULL THEN "Page_Localised_de_DE"."MetaTitle" ELSE "Page_Live"."MetaTitle" END AS "MetaTitle", "Page_Live"."ShowInNaviEingeklappt", "Page_Live"."ShowNewsletterInFooter", "Page_Live"."ShowPageHeaderGradient", "Page_Live"."OGImageCustomID", "Page_Live"."PinterestImageCustomID", "Page_Live"."HeaderImageID", "Page_Live"."VideoMP4ID", "Page_Live"."VideoOGVID", "Page_Live"."ImageID", "HomePage_Live"."ElementalAreaID", "SiteTree_Live"."ID", CASE WHEN "SiteTree_Live"."ClassName" IS NOT NULL THEN "SiteTree_Live"."ClassName" ELSE 'SilverStripe\\CMS\\Model\\SiteTree' END AS "RecordClassName", 'en_US' AS "Locale", CASE WHEN "Page_Localised_en_US"."ID" IS NOT NULL THEN 'en_US' WHEN "Page_Localised_de_DE"."ID" IS NOT NULL THEN 'de_DE' ELSE NULL END AS "SourceLocale" FROM "SiteTree_Live" LEFT JOIN "Page_Live" ON "Page_Live"."ID" = "SiteTree_Live"."ID" LEFT JOIN "HomePage_Live" ON "HomePage_Live"."ID" = "SiteTree_Live"."ID" LEFT JOIN "SiteTree_Localised_Live" AS "SiteTree_Localised_en_US" ON "SiteTree_Live"."ID" = "SiteTree_Localised_en_US"."RecordID" AND "SiteTree_Localised_en_US"."Locale" = ? LEFT JOIN "SiteTree_Localised_Live" AS "SiteTree_Localised_de_DE" ON "SiteTree_Live"."ID" = "SiteTree_Localised_de_DE"."RecordID" AND "SiteTree_Localised_de_DE"."Locale" = ? LEFT JOIN "Page_Localised_Live" AS "Page_Localised_en_US" ON "Page_Live"."ID" = "Page_Localised_en_US"."RecordID" AND "Page_Localised_en_US"."Locale" = ? LEFT JOIN "Page_Localised_Live" AS "Page_Localised_de_DE" ON "Page_Live"."ID" = "Page_Localised_de_DE"."RecordID" AND "Page_Localised_de_DE"."Locale" = ? WHERE ("HomePage_Live"."ElementalAreaID" = ?) AND ("SiteTree_Live"."ClassName" = ?) AND ("SiteTree_Live"."ClassName" IN (?)) AND ("SiteTree_Live"."SubsiteID" IN (2)) AND (("SiteTree_Localised_en_US"."ID" IS NOT NULL) OR ("SiteTree_Localised_de_DE"."ID" IS NOT NULL)) ORDER BY "SiteTree_Live"."Sort" ASC LIMIT 1 0.0007s
0093: SELECT DISTINCT "ElementalArea_Live"."ClassName", "ElementalArea_Live"."LastEdited", "ElementalArea_Live"."Created", "ElementalArea_Live"."Version", "ElementalArea_Live"."OwnerClassName", "ElementalArea_Live"."TopPageID", "ElementalArea_Live"."ID", CASE WHEN "ElementalArea_Live"."ClassName" IS NOT NULL THEN "ElementalArea_Live"."ClassName" ELSE 'DNADesign\\Elemental\\Models\\ElementalArea' END AS "RecordClassName" FROM "ElementalArea_Live" WHERE ("ElementalArea_Live"."ID" = ?) LIMIT 1 0.0002s
0094: SELECT "Version" FROM "SiteTree" WHERE "ID" = ? 0.0002s
0095: 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.0003s
0096: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", "SiteTree_Live"."CanViewType", "SiteTree_Live"."CanEditType", "SiteTree_Live"."Version", CASE WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."Title" 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_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."URLSegment" 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_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."MenuTitle" 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_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."Content" 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_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."MetaDescription" 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_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."ReportClass" WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."ReportClass" ELSE "SiteTree_Live"."ReportClass" END AS "ReportClass", "SiteTree_Live"."SubsiteID", "SiteTree_Live"."ParentID", "SiteTree_Live"."ID", CASE WHEN "SiteTree_Live"."ClassName" IS NOT NULL THEN "SiteTree_Live"."ClassName" ELSE 'SilverStripe\\CMS\\Model\\SiteTree' END AS "RecordClassName", 'en_US' AS "Locale", CASE WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN 'en_US' 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_en_US" ON "SiteTree_Live"."ID" = "SiteTree_Localised_en_US"."RecordID" AND "SiteTree_Localised_en_US"."Locale" = ? LEFT JOIN "SiteTree_Localised_Live" AS "SiteTree_Localised_de_DE" ON "SiteTree_Live"."ID" = "SiteTree_Localised_de_DE"."RecordID" AND "SiteTree_Localised_de_DE"."Locale" = ? WHERE ("SiteTree_Live"."ID" = ?) AND (("SiteTree_Localised_en_US"."ID" IS NOT NULL) OR ("SiteTree_Localised_de_DE"."ID" IS NOT NULL)) ORDER BY "SiteTree_Live"."Sort" ASC LIMIT 1 0.0003s
0097: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", "SiteTree_Live"."CanViewType", "SiteTree_Live"."CanEditType", "SiteTree_Live"."Version", CASE WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."Title" 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_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."URLSegment" 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_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."MenuTitle" 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_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."Content" 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_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."MetaDescription" 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_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."ReportClass" WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."ReportClass" ELSE "SiteTree_Live"."ReportClass" END AS "ReportClass", "SiteTree_Live"."SubsiteID", "SiteTree_Live"."ParentID", "SiteTree_Live"."ID", CASE WHEN "SiteTree_Live"."ClassName" IS NOT NULL THEN "SiteTree_Live"."ClassName" ELSE 'SilverStripe\\CMS\\Model\\SiteTree' END AS "RecordClassName", 'en_US' AS "Locale", CASE WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN 'en_US' 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_en_US" ON "SiteTree_Live"."ID" = "SiteTree_Localised_en_US"."RecordID" AND "SiteTree_Localised_en_US"."Locale" = ? LEFT JOIN "SiteTree_Localised_Live" AS "SiteTree_Localised_de_DE" ON "SiteTree_Live"."ID" = "SiteTree_Localised_de_DE"."RecordID" AND "SiteTree_Localised_de_DE"."Locale" = ? WHERE ("SiteTree_Live"."ID" = ?) AND (("SiteTree_Localised_en_US"."ID" IS NOT NULL) OR ("SiteTree_Localised_de_DE"."ID" IS NOT NULL)) ORDER BY "SiteTree_Live"."Sort" ASC LIMIT 1 0.0003s
0098: SELECT "Domain" FROM "SubsiteDomain" WHERE "SubsiteID" = ? AND "Locale" = ? 0.0002s
0099: SELECT DISTINCT "Subsite"."ClassName", "Subsite"."LastEdited", "Subsite"."Created", "Subsite"."Sort", "Subsite"."HomeBusinessSchemaType", "Subsite"."Title", "Subsite"."RedirectURL", "Subsite"."DefaultSite", "Subsite"."Theme", "Subsite"."Language", "Subsite"."IsPublic", "Subsite"."PageTypeBlacklist", "Subsite"."ID", CASE WHEN "Subsite"."ClassName" IS NOT NULL THEN "Subsite"."ClassName" ELSE 'SilverStripe\\Subsites\\Model\\Subsite' END AS "RecordClassName" FROM "Subsite" WHERE ("Subsite"."ID" = ?) ORDER BY "Subsite"."Title" ASC LIMIT 1 0.0002s
0100: SELECT DISTINCT "SubsiteDomain"."ClassName", "SubsiteDomain"."LastEdited", "SubsiteDomain"."Created", "SubsiteDomain"."Locale", "SubsiteDomain"."Domain", "SubsiteDomain"."Protocol", "SubsiteDomain"."IsPrimary", "SubsiteDomain"."SubsiteID", "SubsiteDomain"."ID", CASE WHEN "SubsiteDomain"."ClassName" IS NOT NULL THEN "SubsiteDomain"."ClassName" ELSE 'SilverStripe\\Subsites\\Model\\SubsiteDomain' END AS "RecordClassName" FROM "SubsiteDomain" WHERE ("SubsiteDomain"."SubsiteID" = ?) ORDER BY "SubsiteDomain"."IsPrimary" DESC LIMIT 1 0.0002s
0101: SELECT "Domain" FROM "SubsiteDomain" WHERE "SubsiteID" = ? AND "Locale" = ? 0.0002s
0102: SELECT DISTINCT "SiteTree"."ClassName", "SiteTree"."LastEdited", "SiteTree"."Created", "SiteTree"."Priority", "SiteTree"."CanViewType", "SiteTree"."CanEditType", "SiteTree"."Version", CASE WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."Title" 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_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."URLSegment" 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_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."MenuTitle" 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_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."Content" 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_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."MetaDescription" 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_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."ReportClass" WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."ReportClass" ELSE "SiteTree"."ReportClass" END AS "ReportClass", "SiteTree"."SubsiteID", "SiteTree"."ParentID", "SiteTree"."ID", CASE WHEN "SiteTree"."ClassName" IS NOT NULL THEN "SiteTree"."ClassName" ELSE 'SilverStripe\\CMS\\Model\\SiteTree' END AS "RecordClassName", 'en_US' AS "Locale", CASE WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN 'en_US' 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_en_US" ON "SiteTree"."ID" = "SiteTree_Localised_en_US"."RecordID" AND "SiteTree_Localised_en_US"."Locale" = ? 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_en_US"."ID" IS NOT NULL) OR ("SiteTree_Localised_de_DE"."ID" IS NOT NULL)) ORDER BY "SiteTree"."Sort" ASC LIMIT 1 0.0003s
0103: SELECT "Domain" FROM "SubsiteDomain" WHERE "SubsiteID" = ? AND "Locale" = ? 0.0002s
0104: SELECT DISTINCT "SubsiteDomain"."ClassName", "SubsiteDomain"."LastEdited", "SubsiteDomain"."Created", "SubsiteDomain"."Locale", "SubsiteDomain"."Domain", "SubsiteDomain"."Protocol", "SubsiteDomain"."IsPrimary", "SubsiteDomain"."SubsiteID", "SubsiteDomain"."ID", CASE WHEN "SubsiteDomain"."ClassName" IS NOT NULL THEN "SubsiteDomain"."ClassName" ELSE 'SilverStripe\\Subsites\\Model\\SubsiteDomain' END AS "RecordClassName" FROM "SubsiteDomain" WHERE ("SubsiteDomain"."SubsiteID" = ?) ORDER BY "SubsiteDomain"."IsPrimary" DESC LIMIT 1 0.0002s
0105: SELECT "Domain" FROM "SubsiteDomain" WHERE "SubsiteID" = ? AND "Locale" = ? 0.0002s
0106: SELECT "Domain" FROM "SubsiteDomain" WHERE "SubsiteID" = ? AND "Locale" = ? 0.0002s
0107: SELECT DISTINCT "SubsiteDomain"."ClassName", "SubsiteDomain"."LastEdited", "SubsiteDomain"."Created", "SubsiteDomain"."Locale", "SubsiteDomain"."Domain", "SubsiteDomain"."Protocol", "SubsiteDomain"."IsPrimary", "SubsiteDomain"."SubsiteID", "SubsiteDomain"."ID", CASE WHEN "SubsiteDomain"."ClassName" IS NOT NULL THEN "SubsiteDomain"."ClassName" ELSE 'SilverStripe\\Subsites\\Model\\SubsiteDomain' END AS "RecordClassName" FROM "SubsiteDomain" WHERE ("SubsiteDomain"."SubsiteID" = ?) ORDER BY "SubsiteDomain"."IsPrimary" DESC LIMIT 1 0.0002s
0108: SELECT "Domain" FROM "SubsiteDomain" WHERE "SubsiteID" = ? AND "Locale" = ? 0.0002s
0109: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", "SiteTree_Live"."CanViewType", "SiteTree_Live"."CanEditType", "SiteTree_Live"."Version", CASE WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."Title" 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_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."URLSegment" 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_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."MenuTitle" 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_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."Content" 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_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."MetaDescription" 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_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."ReportClass" WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."ReportClass" ELSE "SiteTree_Live"."ReportClass" END AS "ReportClass", "SiteTree_Live"."SubsiteID", "SiteTree_Live"."ParentID", "SiteTree_Live"."ID", CASE WHEN "SiteTree_Live"."ClassName" IS NOT NULL THEN "SiteTree_Live"."ClassName" ELSE 'SilverStripe\\CMS\\Model\\SiteTree' END AS "RecordClassName", 'en_US' AS "Locale", CASE WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN 'en_US' 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_en_US" ON "SiteTree_Live"."ID" = "SiteTree_Localised_en_US"."RecordID" AND "SiteTree_Localised_en_US"."Locale" = ? LEFT JOIN "SiteTree_Localised_Live" AS "SiteTree_Localised_de_DE" ON "SiteTree_Live"."ID" = "SiteTree_Localised_de_DE"."RecordID" AND "SiteTree_Localised_de_DE"."Locale" = ? WHERE ("SiteTree_Live"."ID" = ?) AND (("SiteTree_Localised_en_US"."ID" IS NOT NULL) OR ("SiteTree_Localised_de_DE"."ID" IS NOT NULL)) ORDER BY "SiteTree_Live"."Sort" ASC LIMIT 1 0.0003s
0110: SELECT "Domain" FROM "SubsiteDomain" WHERE "SubsiteID" = ? AND "Locale" = ? 0.0002s
0111: SELECT DISTINCT "Subsite"."ClassName", "Subsite"."LastEdited", "Subsite"."Created", "Subsite"."Sort", "Subsite"."HomeBusinessSchemaType", "Subsite"."Title", "Subsite"."RedirectURL", "Subsite"."DefaultSite", "Subsite"."Theme", "Subsite"."Language", "Subsite"."IsPublic", "Subsite"."PageTypeBlacklist", "Subsite"."ID", CASE WHEN "Subsite"."ClassName" IS NOT NULL THEN "Subsite"."ClassName" ELSE 'SilverStripe\\Subsites\\Model\\Subsite' END AS "RecordClassName" FROM "Subsite" WHERE ("Subsite"."ID" = ?) ORDER BY "Subsite"."Title" ASC LIMIT 1 0.0002s
0112: SELECT DISTINCT "SubsiteDomain"."ClassName", "SubsiteDomain"."LastEdited", "SubsiteDomain"."Created", "SubsiteDomain"."Locale", "SubsiteDomain"."Domain", "SubsiteDomain"."Protocol", "SubsiteDomain"."IsPrimary", "SubsiteDomain"."SubsiteID", "SubsiteDomain"."ID", CASE WHEN "SubsiteDomain"."ClassName" IS NOT NULL THEN "SubsiteDomain"."ClassName" ELSE 'SilverStripe\\Subsites\\Model\\SubsiteDomain' END AS "RecordClassName" FROM "SubsiteDomain" WHERE ("SubsiteDomain"."SubsiteID" = ?) ORDER BY "SubsiteDomain"."IsPrimary" DESC LIMIT 1 0.0002s
0113: SELECT "Domain" FROM "SubsiteDomain" WHERE "SubsiteID" = ? AND "Locale" = ? 0.0002s
0114: SELECT "Domain" FROM "SubsiteDomain" WHERE "SubsiteID" = ? AND "Locale" = ? 0.0002s
0115: SELECT "Domain" FROM "SubsiteDomain" WHERE "SubsiteID" = ? AND "Locale" = ? 0.0002s
0116: SELECT "Domain" FROM "SubsiteDomain" WHERE "SubsiteID" = ? AND "Locale" = ? 0.0002s
The Caracalla Spa is known worldwide and, as a 5-star spa resort, is one of the top wellness addresses in the Black Forest. On 5000 square meters, the thermal baths with bathing and sauna area offer a great ambience for soothing relaxation. As an oasis of relaxation, we offer recreation at the highest level. Our common goal is to provide every guest with an unforgettable recreational experience. If you also enjoy service and find it easy to treat others with attention and friendliness, then you've come to the right place.
The Caracalla Spa is part of CARASANA Bäderbetriebe GmbH. The owner-managed private service company also includes the historic Friedrichsbad, ArenaVita Premium Fitness and the Wellness & Beauty World. With a team of around 160 people, we look after the well-being of our guests day after day. "A day spent with us will pass - but the sense of relaxation will remain!" - the credo for our daily service and a promise to our guests!