0003: SHOW FULL TABLES WHERE Table_Type != 'VIEW'
0.0017s
0004: SHOW FULL FIELDS IN "Fluent_Locale"
0.0007s
0005: SHOW COLLATION LIKE 'utf8mb3_general_ci'
0.0002s
0006: SELECT DISTINCT "Fluent_Locale"."ClassName", "Fluent_Locale"."LastEdited", "Fluent_Locale"."Created", "Fluent_Locale"."Title", "Fluent_Locale"."Locale", "Fluent_Locale"."URLSegment", "Fluent_Locale"."IsGlobalDefault", "Fluent_Locale"."DomainID", "Fluent_Locale"."ID",
CASE WHEN "Fluent_Locale"."ClassName" IS NOT NULL THEN "Fluent_Locale"."ClassName"
ELSE 'TractorCow\\Fluent\\Model\\Locale' END AS "RecordClassName"
FROM "Fluent_Locale"
ORDER BY "Fluent_Locale"."Locale" ASC
0.0002s
0007: SHOW FULL FIELDS IN "Fluent_Domain"
0.0006s
0008: SELECT DISTINCT "Fluent_Domain"."ClassName", "Fluent_Domain"."LastEdited", "Fluent_Domain"."Created", "Fluent_Domain"."Domain", "Fluent_Domain"."DefaultLocaleID", "Fluent_Domain"."ID",
CASE WHEN "Fluent_Domain"."ClassName" IS NOT NULL THEN "Fluent_Domain"."ClassName"
ELSE 'TractorCow\\Fluent\\Model\\Domain' END AS "RecordClassName"
FROM "Fluent_Domain"
0.0002s
0009: SELECT DISTINCT "Fluent_FallbackLocale"."ClassName" AS "Fluent_FallbackLocale_ClassName", "Fluent_FallbackLocale"."LastEdited" AS "Fluent_FallbackLocale_LastEdited", "Fluent_FallbackLocale"."Created" AS "Fluent_FallbackLocale_Created", "Fluent_FallbackLocale"."Sort" AS "Fluent_FallbackLocale_Sort", "Fluent_FallbackLocale"."ParentID" AS "Fluent_FallbackLocale_ParentID", "Fluent_FallbackLocale"."LocaleID" AS "Fluent_FallbackLocale_LocaleID", "Fluent_FallbackLocale"."ID" AS "Fluent_FallbackLocale_ID", "Fluent_FallbackLocale"."RecordClassName" AS "Fluent_FallbackLocale_RecordClassName", "Fluent_Locale"."ClassName", "Fluent_Locale"."LastEdited", "Fluent_Locale"."Created", "Fluent_Locale"."Title", "Fluent_Locale"."Locale", "Fluent_Locale"."URLSegment", "Fluent_Locale"."IsGlobalDefault", "Fluent_Locale"."DomainID", "Fluent_Locale"."ID",
CASE WHEN "Fluent_Locale"."ClassName" IS NOT NULL THEN "Fluent_Locale"."ClassName"
ELSE 'TractorCow\\Fluent\\Model\\Locale' END AS "RecordClassName"
FROM "Fluent_Locale" INNER JOIN (SELECT DISTINCT "Fluent_FallbackLocale"."ClassName", "Fluent_FallbackLocale"."LastEdited", "Fluent_FallbackLocale"."Created", "Fluent_FallbackLocale"."Sort", "Fluent_FallbackLocale"."ParentID", "Fluent_FallbackLocale"."LocaleID", "Fluent_FallbackLocale"."ID",
CASE WHEN "Fluent_FallbackLocale"."ClassName" IS NOT NULL THEN "Fluent_FallbackLocale"."ClassName"
ELSE 'TractorCow\\Fluent\\Model\\FallbackLocale' END AS "RecordClassName"
FROM "Fluent_FallbackLocale"
WHERE ("Fluent_FallbackLocale"."ParentID" = ?)) AS "Fluent_FallbackLocale" ON "Fluent_FallbackLocale"."LocaleID" = "Fluent_Locale"."ID"
ORDER BY "Fluent_Locale"."Locale" ASC
0.0003s
0010: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."BetterSiteTitle"
ELSE "SiteTree_Live"."BetterSiteTitle" END
AS "BetterSiteTitle", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."Keyword"
ELSE "SiteTree_Live"."Keyword" END
AS "Keyword", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."FeaturedKeyword"
ELSE "SiteTree_Live"."FeaturedKeyword" END
AS "FeaturedKeyword", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."KeywordQuestion"
ELSE "SiteTree_Live"."KeywordQuestion" END
AS "KeywordQuestion", "SiteTree_Live"."Follow", "SiteTree_Live"."FollowType", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."GenMetaDesc"
ELSE "SiteTree_Live"."GenMetaDesc" END
AS "GenMetaDesc", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."FBTitle"
ELSE "SiteTree_Live"."FBTitle" END
AS "FBTitle", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."FBDescription"
ELSE "SiteTree_Live"."FBDescription" END
AS "FBDescription", "SiteTree_Live"."FBType", "SiteTree_Live"."FBTypeOverride", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."TwTitle"
ELSE "SiteTree_Live"."TwTitle" END
AS "TwTitle", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."TwDescription"
ELSE "SiteTree_Live"."TwDescription" END
AS "TwDescription", "SiteTree_Live"."CanViewType", "SiteTree_Live"."CanEditType", "SiteTree_Live"."Version", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."URLSegment"
ELSE "SiteTree_Live"."URLSegment" END
AS "URLSegment", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."Title"
ELSE "SiteTree_Live"."Title" END
AS "Title", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."MenuTitle"
ELSE "SiteTree_Live"."MenuTitle" END
AS "MenuTitle", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."Content"
ELSE "SiteTree_Live"."Content" END
AS "Content", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."MetaDescription"
ELSE "SiteTree_Live"."MetaDescription" END
AS "MetaDescription", "SiteTree_Live"."ExtraMeta", "SiteTree_Live"."ShowInMenus", "SiteTree_Live"."ShowInSearch", "SiteTree_Live"."Sort", "SiteTree_Live"."HasBrokenFile", "SiteTree_Live"."HasBrokenLink", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."ReportClass"
ELSE "SiteTree_Live"."ReportClass" END
AS "ReportClass", "SiteTree_Live"."CanonicalLinkID", "SiteTree_Live"."FBImageID", "SiteTree_Live"."TwImageID", "SiteTree_Live"."ParentID", "SiteTree_Live"."ID",
CASE WHEN "SiteTree_Live"."ClassName" IS NOT NULL THEN "SiteTree_Live"."ClassName"
ELSE 'SilverStripe\\CMS\\Model\\SiteTree' END AS "RecordClassName", 'de_DE' AS "Locale", CASE WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN 'de_DE'
ELSE NULL END AS "SourceLocale"
FROM "SiteTree_Live" LEFT JOIN "SiteTree_Localised_Live" AS "SiteTree_Localised_de_DE" ON "SiteTree_Live"."ID" = "SiteTree_Localised_de_DE"."RecordID" AND "SiteTree_Localised_de_DE"."Locale" = ?
WHERE (COALESCE("SiteTree_Localised_de_DE"."URLSegment", "SiteTree_Live"."URLSegment") = ?)
AND ("SiteTree_Live"."ParentID" = ?)
AND (("SiteTree_Localised_de_DE"."ID" IS NOT NULL))
ORDER BY "SiteTree_Live"."Sort" ASC
LIMIT 1
0.0004s
0011: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."BetterSiteTitle"
ELSE "SiteTree_Live"."BetterSiteTitle" END
AS "BetterSiteTitle", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."Keyword"
ELSE "SiteTree_Live"."Keyword" END
AS "Keyword", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."FeaturedKeyword"
ELSE "SiteTree_Live"."FeaturedKeyword" END
AS "FeaturedKeyword", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."KeywordQuestion"
ELSE "SiteTree_Live"."KeywordQuestion" END
AS "KeywordQuestion", "SiteTree_Live"."Follow", "SiteTree_Live"."FollowType", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."GenMetaDesc"
ELSE "SiteTree_Live"."GenMetaDesc" END
AS "GenMetaDesc", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."FBTitle"
ELSE "SiteTree_Live"."FBTitle" END
AS "FBTitle", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."FBDescription"
ELSE "SiteTree_Live"."FBDescription" END
AS "FBDescription", "SiteTree_Live"."FBType", "SiteTree_Live"."FBTypeOverride", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."TwTitle"
ELSE "SiteTree_Live"."TwTitle" END
AS "TwTitle", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."TwDescription"
ELSE "SiteTree_Live"."TwDescription" END
AS "TwDescription", "SiteTree_Live"."CanViewType", "SiteTree_Live"."CanEditType", "SiteTree_Live"."Version", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."URLSegment"
ELSE "SiteTree_Live"."URLSegment" END
AS "URLSegment", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."Title"
ELSE "SiteTree_Live"."Title" END
AS "Title", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."MenuTitle"
ELSE "SiteTree_Live"."MenuTitle" END
AS "MenuTitle", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."Content"
ELSE "SiteTree_Live"."Content" END
AS "Content", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."MetaDescription"
ELSE "SiteTree_Live"."MetaDescription" END
AS "MetaDescription", "SiteTree_Live"."ExtraMeta", "SiteTree_Live"."ShowInMenus", "SiteTree_Live"."ShowInSearch", "SiteTree_Live"."Sort", "SiteTree_Live"."HasBrokenFile", "SiteTree_Live"."HasBrokenLink", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."ReportClass"
ELSE "SiteTree_Live"."ReportClass" END
AS "ReportClass", "SiteTree_Live"."CanonicalLinkID", "SiteTree_Live"."FBImageID", "SiteTree_Live"."TwImageID", "SiteTree_Live"."ParentID", "SiteTree_Live"."ID",
CASE WHEN "SiteTree_Live"."ClassName" IS NOT NULL THEN "SiteTree_Live"."ClassName"
ELSE 'SilverStripe\\CMS\\Model\\SiteTree' END AS "RecordClassName", 'de_DE' AS "Locale", CASE WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN 'de_DE'
ELSE NULL END AS "SourceLocale"
FROM "SiteTree_Live" LEFT JOIN "SiteTree_Localised_Live" AS "SiteTree_Localised_de_DE" ON "SiteTree_Live"."ID" = "SiteTree_Localised_de_DE"."RecordID" AND "SiteTree_Localised_de_DE"."Locale" = ?
WHERE ("SiteTree_Live"."ParentID" = ?)
AND (COALESCE("SiteTree_Localised_de_DE"."URLSegment", "SiteTree_Live"."URLSegment") = ?)
AND (("SiteTree_Localised_de_DE"."ID" IS NOT NULL))
ORDER BY "SiteTree_Live"."Sort" ASC
LIMIT 1
0.0005s
0012: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."BetterSiteTitle"
ELSE "SiteTree_Live"."BetterSiteTitle" END
AS "BetterSiteTitle", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."Keyword"
ELSE "SiteTree_Live"."Keyword" END
AS "Keyword", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."FeaturedKeyword"
ELSE "SiteTree_Live"."FeaturedKeyword" END
AS "FeaturedKeyword", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."KeywordQuestion"
ELSE "SiteTree_Live"."KeywordQuestion" END
AS "KeywordQuestion", "SiteTree_Live"."Follow", "SiteTree_Live"."FollowType", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."GenMetaDesc"
ELSE "SiteTree_Live"."GenMetaDesc" END
AS "GenMetaDesc", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."FBTitle"
ELSE "SiteTree_Live"."FBTitle" END
AS "FBTitle", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."FBDescription"
ELSE "SiteTree_Live"."FBDescription" END
AS "FBDescription", "SiteTree_Live"."FBType", "SiteTree_Live"."FBTypeOverride", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."TwTitle"
ELSE "SiteTree_Live"."TwTitle" END
AS "TwTitle", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."TwDescription"
ELSE "SiteTree_Live"."TwDescription" END
AS "TwDescription", "SiteTree_Live"."CanViewType", "SiteTree_Live"."CanEditType", "SiteTree_Live"."Version", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."URLSegment"
ELSE "SiteTree_Live"."URLSegment" END
AS "URLSegment", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."Title"
ELSE "SiteTree_Live"."Title" END
AS "Title", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."MenuTitle"
ELSE "SiteTree_Live"."MenuTitle" END
AS "MenuTitle", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."Content"
ELSE "SiteTree_Live"."Content" END
AS "Content", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."MetaDescription"
ELSE "SiteTree_Live"."MetaDescription" END
AS "MetaDescription", "SiteTree_Live"."ExtraMeta", "SiteTree_Live"."ShowInMenus", "SiteTree_Live"."ShowInSearch", "SiteTree_Live"."Sort", "SiteTree_Live"."HasBrokenFile", "SiteTree_Live"."HasBrokenLink", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."ReportClass"
ELSE "SiteTree_Live"."ReportClass" END
AS "ReportClass", "SiteTree_Live"."CanonicalLinkID", "SiteTree_Live"."FBImageID", "SiteTree_Live"."TwImageID", "SiteTree_Live"."ParentID", "SiteTree_Live"."ID",
CASE WHEN "SiteTree_Live"."ClassName" IS NOT NULL THEN "SiteTree_Live"."ClassName"
ELSE 'SilverStripe\\CMS\\Model\\SiteTree' END AS "RecordClassName", 'de_DE' AS "Locale", CASE WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN 'de_DE'
ELSE NULL END AS "SourceLocale"
FROM "SiteTree_Live" LEFT JOIN "SiteTree_Localised_Live" AS "SiteTree_Localised_de_DE" ON "SiteTree_Live"."ID" = "SiteTree_Localised_de_DE"."RecordID" AND "SiteTree_Localised_de_DE"."Locale" = ?
WHERE ("SiteTree_Live"."ID" = ?)
AND (("SiteTree_Localised_de_DE"."ID" IS NOT NULL))
ORDER BY "SiteTree_Live"."Sort" ASC
LIMIT 1
0.0004s
0013: SELECT DISTINCT "SiteConfig"."ClassName", "SiteConfig"."LastEdited", "SiteConfig"."Created", CASE
WHEN "SiteConfig_Localised_de_DE"."ID" IS NOT NULL THEN "SiteConfig_Localised_de_DE"."FooterCol1"
ELSE "SiteConfig"."FooterCol1" END
AS "FooterCol1", CASE
WHEN "SiteConfig_Localised_de_DE"."ID" IS NOT NULL THEN "SiteConfig_Localised_de_DE"."FooterCol2"
ELSE "SiteConfig"."FooterCol2" END
AS "FooterCol2", CASE
WHEN "SiteConfig_Localised_de_DE"."ID" IS NOT NULL THEN "SiteConfig_Localised_de_DE"."FooterCol3"
ELSE "SiteConfig"."FooterCol3" END
AS "FooterCol3", CASE
WHEN "SiteConfig_Localised_de_DE"."ID" IS NOT NULL THEN "SiteConfig_Localised_de_DE"."FooterCol4"
ELSE "SiteConfig"."FooterCol4" END
AS "FooterCol4", "SiteConfig"."CookieConsentNotice", "SiteConfig"."CookieBtnOk", "SiteConfig"."CookieChooseText", "SiteConfig"."CookieBtnDislike", "SiteConfig"."CookieAllowGMaps", "SiteConfig"."CookieTextUnderBtn", "SiteConfig"."CookieAllowYouTube", "SiteConfig"."CookieConsentPopUpHeadline", "SiteConfig"."CookieConsentPopUpNotice", "SiteConfig"."CookieConsentPopUpDisallow", "SiteConfig"."CookieConsentPopUpAllowAll", "SiteConfig"."CookieConsentPopUpAllowSelected", "SiteConfig"."CookiePrivacyPolicyTitle", "SiteConfig"."CookiePrivacyPolicyText", CASE
WHEN "SiteConfig_Localised_de_DE"."ID" IS NOT NULL THEN "SiteConfig_Localised_de_DE"."Title"
ELSE "SiteConfig"."Title" END
AS "Title", CASE
WHEN "SiteConfig_Localised_de_DE"."ID" IS NOT NULL THEN "SiteConfig_Localised_de_DE"."Tagline"
ELSE "SiteConfig"."Tagline" END
AS "Tagline", "SiteConfig"."CanViewType", "SiteConfig"."CanEditType", "SiteConfig"."CanCreateTopLevelType", "SiteConfig"."ID",
CASE WHEN "SiteConfig"."ClassName" IS NOT NULL THEN "SiteConfig"."ClassName"
ELSE 'SilverStripe\\SiteConfig\\SiteConfig' END AS "RecordClassName", 'de_DE' AS "Locale", CASE WHEN "SiteConfig_Localised_de_DE"."ID" IS NOT NULL THEN 'de_DE'
ELSE NULL END AS "SourceLocale"
FROM "SiteConfig" LEFT JOIN "SiteConfig_Localised" AS "SiteConfig_Localised_de_DE" ON "SiteConfig"."ID" = "SiteConfig_Localised_de_DE"."RecordID" AND "SiteConfig_Localised_de_DE"."Locale" = ?
LIMIT 1
0.0003s
0014: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."BetterSiteTitle"
ELSE "SiteTree_Live"."BetterSiteTitle" END
AS "BetterSiteTitle", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."Keyword"
ELSE "SiteTree_Live"."Keyword" END
AS "Keyword", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."FeaturedKeyword"
ELSE "SiteTree_Live"."FeaturedKeyword" END
AS "FeaturedKeyword", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."KeywordQuestion"
ELSE "SiteTree_Live"."KeywordQuestion" END
AS "KeywordQuestion", "SiteTree_Live"."Follow", "SiteTree_Live"."FollowType", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."GenMetaDesc"
ELSE "SiteTree_Live"."GenMetaDesc" END
AS "GenMetaDesc", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."FBTitle"
ELSE "SiteTree_Live"."FBTitle" END
AS "FBTitle", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."FBDescription"
ELSE "SiteTree_Live"."FBDescription" END
AS "FBDescription", "SiteTree_Live"."FBType", "SiteTree_Live"."FBTypeOverride", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."TwTitle"
ELSE "SiteTree_Live"."TwTitle" END
AS "TwTitle", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."TwDescription"
ELSE "SiteTree_Live"."TwDescription" END
AS "TwDescription", "SiteTree_Live"."CanViewType", "SiteTree_Live"."CanEditType", "SiteTree_Live"."Version", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."URLSegment"
ELSE "SiteTree_Live"."URLSegment" END
AS "URLSegment", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."Title"
ELSE "SiteTree_Live"."Title" END
AS "Title", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."MenuTitle"
ELSE "SiteTree_Live"."MenuTitle" END
AS "MenuTitle", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."Content"
ELSE "SiteTree_Live"."Content" END
AS "Content", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."MetaDescription"
ELSE "SiteTree_Live"."MetaDescription" END
AS "MetaDescription", "SiteTree_Live"."ExtraMeta", "SiteTree_Live"."ShowInMenus", "SiteTree_Live"."ShowInSearch", "SiteTree_Live"."Sort", "SiteTree_Live"."HasBrokenFile", "SiteTree_Live"."HasBrokenLink", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."ReportClass"
ELSE "SiteTree_Live"."ReportClass" END
AS "ReportClass", "SiteTree_Live"."CanonicalLinkID", "SiteTree_Live"."FBImageID", "SiteTree_Live"."TwImageID", "SiteTree_Live"."ParentID", "SiteTree_Live"."ID",
CASE WHEN "SiteTree_Live"."ClassName" IS NOT NULL THEN "SiteTree_Live"."ClassName"
ELSE 'SilverStripe\\CMS\\Model\\SiteTree' END AS "RecordClassName", 'de_DE' AS "Locale", CASE WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN 'de_DE'
ELSE NULL END AS "SourceLocale"
FROM "SiteTree_Live" LEFT JOIN "SiteTree_Localised_Live" AS "SiteTree_Localised_de_DE" ON "SiteTree_Live"."ID" = "SiteTree_Localised_de_DE"."RecordID" AND "SiteTree_Localised_de_DE"."Locale" = ?
WHERE ("SiteTree_Live"."ParentID" <> "SiteTree_Live"."ID")
AND ("SiteTree_Live"."ParentID" = ?)
AND ("SiteTree_Live"."ShowInMenus" = ?)
AND (("SiteTree_Localised_de_DE"."ID" IS NOT NULL))
ORDER BY "SiteTree_Live"."Sort" ASC
0.0006s
0015: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."BetterSiteTitle"
ELSE "SiteTree_Live"."BetterSiteTitle" END
AS "BetterSiteTitle", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."Keyword"
ELSE "SiteTree_Live"."Keyword" END
AS "Keyword", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."FeaturedKeyword"
ELSE "SiteTree_Live"."FeaturedKeyword" END
AS "FeaturedKeyword", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."KeywordQuestion"
ELSE "SiteTree_Live"."KeywordQuestion" END
AS "KeywordQuestion", "SiteTree_Live"."Follow", "SiteTree_Live"."FollowType", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."GenMetaDesc"
ELSE "SiteTree_Live"."GenMetaDesc" END
AS "GenMetaDesc", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."FBTitle"
ELSE "SiteTree_Live"."FBTitle" END
AS "FBTitle", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."FBDescription"
ELSE "SiteTree_Live"."FBDescription" END
AS "FBDescription", "SiteTree_Live"."FBType", "SiteTree_Live"."FBTypeOverride", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."TwTitle"
ELSE "SiteTree_Live"."TwTitle" END
AS "TwTitle", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."TwDescription"
ELSE "SiteTree_Live"."TwDescription" END
AS "TwDescription", "SiteTree_Live"."CanViewType", "SiteTree_Live"."CanEditType", "SiteTree_Live"."Version", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."URLSegment"
ELSE "SiteTree_Live"."URLSegment" END
AS "URLSegment", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."Title"
ELSE "SiteTree_Live"."Title" END
AS "Title", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."MenuTitle"
ELSE "SiteTree_Live"."MenuTitle" END
AS "MenuTitle", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."Content"
ELSE "SiteTree_Live"."Content" END
AS "Content", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."MetaDescription"
ELSE "SiteTree_Live"."MetaDescription" END
AS "MetaDescription", "SiteTree_Live"."ExtraMeta", "SiteTree_Live"."ShowInMenus", "SiteTree_Live"."ShowInSearch", "SiteTree_Live"."Sort", "SiteTree_Live"."HasBrokenFile", "SiteTree_Live"."HasBrokenLink", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."ReportClass"
ELSE "SiteTree_Live"."ReportClass" END
AS "ReportClass", "SiteTree_Live"."CanonicalLinkID", "SiteTree_Live"."FBImageID", "SiteTree_Live"."TwImageID", "SiteTree_Live"."ParentID", "SiteTree_Live"."ID",
CASE WHEN "SiteTree_Live"."ClassName" IS NOT NULL THEN "SiteTree_Live"."ClassName"
ELSE 'SilverStripe\\CMS\\Model\\SiteTree' END AS "RecordClassName", 'de_DE' AS "Locale", CASE WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN 'de_DE'
ELSE NULL END AS "SourceLocale"
FROM "SiteTree_Live" LEFT JOIN "SiteTree_Localised_Live" AS "SiteTree_Localised_de_DE" ON "SiteTree_Live"."ID" = "SiteTree_Localised_de_DE"."RecordID" AND "SiteTree_Localised_de_DE"."Locale" = ?
WHERE ("SiteTree_Live"."ID" = ?)
AND (("SiteTree_Localised_de_DE"."ID" IS NOT NULL))
ORDER BY "SiteTree_Live"."Sort" ASC
LIMIT 1
0.0001s
0016: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."BetterSiteTitle"
ELSE "SiteTree_Live"."BetterSiteTitle" END
AS "BetterSiteTitle", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."Keyword"
ELSE "SiteTree_Live"."Keyword" END
AS "Keyword", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."FeaturedKeyword"
ELSE "SiteTree_Live"."FeaturedKeyword" END
AS "FeaturedKeyword", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."KeywordQuestion"
ELSE "SiteTree_Live"."KeywordQuestion" END
AS "KeywordQuestion", "SiteTree_Live"."Follow", "SiteTree_Live"."FollowType", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."GenMetaDesc"
ELSE "SiteTree_Live"."GenMetaDesc" END
AS "GenMetaDesc", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."FBTitle"
ELSE "SiteTree_Live"."FBTitle" END
AS "FBTitle", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."FBDescription"
ELSE "SiteTree_Live"."FBDescription" END
AS "FBDescription", "SiteTree_Live"."FBType", "SiteTree_Live"."FBTypeOverride", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."TwTitle"
ELSE "SiteTree_Live"."TwTitle" END
AS "TwTitle", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."TwDescription"
ELSE "SiteTree_Live"."TwDescription" END
AS "TwDescription", "SiteTree_Live"."CanViewType", "SiteTree_Live"."CanEditType", "SiteTree_Live"."Version", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."URLSegment"
ELSE "SiteTree_Live"."URLSegment" END
AS "URLSegment", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."Title"
ELSE "SiteTree_Live"."Title" END
AS "Title", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."MenuTitle"
ELSE "SiteTree_Live"."MenuTitle" END
AS "MenuTitle", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."Content"
ELSE "SiteTree_Live"."Content" END
AS "Content", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."MetaDescription"
ELSE "SiteTree_Live"."MetaDescription" END
AS "MetaDescription", "SiteTree_Live"."ExtraMeta", "SiteTree_Live"."ShowInMenus", "SiteTree_Live"."ShowInSearch", "SiteTree_Live"."Sort", "SiteTree_Live"."HasBrokenFile", "SiteTree_Live"."HasBrokenLink", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."ReportClass"
ELSE "SiteTree_Live"."ReportClass" END
AS "ReportClass", "SiteTree_Live"."CanonicalLinkID", "SiteTree_Live"."FBImageID", "SiteTree_Live"."TwImageID", "SiteTree_Live"."ParentID", "SiteTree_Live"."ID",
CASE WHEN "SiteTree_Live"."ClassName" IS NOT NULL THEN "SiteTree_Live"."ClassName"
ELSE 'SilverStripe\\CMS\\Model\\SiteTree' END AS "RecordClassName", 'de_DE' AS "Locale", CASE WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN 'de_DE'
ELSE NULL END AS "SourceLocale"
FROM "SiteTree_Live" LEFT JOIN "SiteTree_Localised_Live" AS "SiteTree_Localised_de_DE" ON "SiteTree_Live"."ID" = "SiteTree_Localised_de_DE"."RecordID" AND "SiteTree_Localised_de_DE"."Locale" = ?
WHERE ("SiteTree_Live"."ID" = ?)
AND (("SiteTree_Localised_de_DE"."ID" IS NOT NULL))
ORDER BY "SiteTree_Live"."Sort" ASC
LIMIT 1
0.0001s
0017: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."BetterSiteTitle"
ELSE "SiteTree_Live"."BetterSiteTitle" END
AS "BetterSiteTitle", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."Keyword"
ELSE "SiteTree_Live"."Keyword" END
AS "Keyword", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."FeaturedKeyword"
ELSE "SiteTree_Live"."FeaturedKeyword" END
AS "FeaturedKeyword", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."KeywordQuestion"
ELSE "SiteTree_Live"."KeywordQuestion" END
AS "KeywordQuestion", "SiteTree_Live"."Follow", "SiteTree_Live"."FollowType", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."GenMetaDesc"
ELSE "SiteTree_Live"."GenMetaDesc" END
AS "GenMetaDesc", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."FBTitle"
ELSE "SiteTree_Live"."FBTitle" END
AS "FBTitle", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."FBDescription"
ELSE "SiteTree_Live"."FBDescription" END
AS "FBDescription", "SiteTree_Live"."FBType", "SiteTree_Live"."FBTypeOverride", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."TwTitle"
ELSE "SiteTree_Live"."TwTitle" END
AS "TwTitle", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."TwDescription"
ELSE "SiteTree_Live"."TwDescription" END
AS "TwDescription", "SiteTree_Live"."CanViewType", "SiteTree_Live"."CanEditType", "SiteTree_Live"."Version", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."URLSegment"
ELSE "SiteTree_Live"."URLSegment" END
AS "URLSegment", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."Title"
ELSE "SiteTree_Live"."Title" END
AS "Title", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."MenuTitle"
ELSE "SiteTree_Live"."MenuTitle" END
AS "MenuTitle", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."Content"
ELSE "SiteTree_Live"."Content" END
AS "Content", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."MetaDescription"
ELSE "SiteTree_Live"."MetaDescription" END
AS "MetaDescription", "SiteTree_Live"."ExtraMeta", "SiteTree_Live"."ShowInMenus", "SiteTree_Live"."ShowInSearch", "SiteTree_Live"."Sort", "SiteTree_Live"."HasBrokenFile", "SiteTree_Live"."HasBrokenLink", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."ReportClass"
ELSE "SiteTree_Live"."ReportClass" END
AS "ReportClass", "SiteTree_Live"."CanonicalLinkID", "SiteTree_Live"."FBImageID", "SiteTree_Live"."TwImageID", "SiteTree_Live"."ParentID", "SiteTree_Live"."ID",
CASE WHEN "SiteTree_Live"."ClassName" IS NOT NULL THEN "SiteTree_Live"."ClassName"
ELSE 'SilverStripe\\CMS\\Model\\SiteTree' END AS "RecordClassName", 'de_DE' AS "Locale", CASE WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN 'de_DE'
ELSE NULL END AS "SourceLocale"
FROM "SiteTree_Live" LEFT JOIN "SiteTree_Localised_Live" AS "SiteTree_Localised_de_DE" ON "SiteTree_Live"."ID" = "SiteTree_Localised_de_DE"."RecordID" AND "SiteTree_Localised_de_DE"."Locale" = ?
WHERE ("SiteTree_Live"."ID" = ?)
AND (("SiteTree_Localised_de_DE"."ID" IS NOT NULL))
ORDER BY "SiteTree_Live"."Sort" ASC
LIMIT 1
0.0001s
0018: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."BetterSiteTitle"
ELSE "SiteTree_Live"."BetterSiteTitle" END
AS "BetterSiteTitle", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."Keyword"
ELSE "SiteTree_Live"."Keyword" END
AS "Keyword", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."FeaturedKeyword"
ELSE "SiteTree_Live"."FeaturedKeyword" END
AS "FeaturedKeyword", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."KeywordQuestion"
ELSE "SiteTree_Live"."KeywordQuestion" END
AS "KeywordQuestion", "SiteTree_Live"."Follow", "SiteTree_Live"."FollowType", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."GenMetaDesc"
ELSE "SiteTree_Live"."GenMetaDesc" END
AS "GenMetaDesc", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."FBTitle"
ELSE "SiteTree_Live"."FBTitle" END
AS "FBTitle", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."FBDescription"
ELSE "SiteTree_Live"."FBDescription" END
AS "FBDescription", "SiteTree_Live"."FBType", "SiteTree_Live"."FBTypeOverride", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."TwTitle"
ELSE "SiteTree_Live"."TwTitle" END
AS "TwTitle", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."TwDescription"
ELSE "SiteTree_Live"."TwDescription" END
AS "TwDescription", "SiteTree_Live"."CanViewType", "SiteTree_Live"."CanEditType", "SiteTree_Live"."Version", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."URLSegment"
ELSE "SiteTree_Live"."URLSegment" END
AS "URLSegment", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."Title"
ELSE "SiteTree_Live"."Title" END
AS "Title", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."MenuTitle"
ELSE "SiteTree_Live"."MenuTitle" END
AS "MenuTitle", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."Content"
ELSE "SiteTree_Live"."Content" END
AS "Content", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."MetaDescription"
ELSE "SiteTree_Live"."MetaDescription" END
AS "MetaDescription", "SiteTree_Live"."ExtraMeta", "SiteTree_Live"."ShowInMenus", "SiteTree_Live"."ShowInSearch", "SiteTree_Live"."Sort", "SiteTree_Live"."HasBrokenFile", "SiteTree_Live"."HasBrokenLink", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."ReportClass"
ELSE "SiteTree_Live"."ReportClass" END
AS "ReportClass", "SiteTree_Live"."CanonicalLinkID", "SiteTree_Live"."FBImageID", "SiteTree_Live"."TwImageID", "SiteTree_Live"."ParentID", "SiteTree_Live"."ID",
CASE WHEN "SiteTree_Live"."ClassName" IS NOT NULL THEN "SiteTree_Live"."ClassName"
ELSE 'SilverStripe\\CMS\\Model\\SiteTree' END AS "RecordClassName", 'de_DE' AS "Locale", CASE WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN 'de_DE'
ELSE NULL END AS "SourceLocale"
FROM "SiteTree_Live" LEFT JOIN "SiteTree_Localised_Live" AS "SiteTree_Localised_de_DE" ON "SiteTree_Live"."ID" = "SiteTree_Localised_de_DE"."RecordID" AND "SiteTree_Localised_de_DE"."Locale" = ?
WHERE ("SiteTree_Live"."ID" = ?)
AND (("SiteTree_Localised_de_DE"."ID" IS NOT NULL))
ORDER BY "SiteTree_Live"."Sort" ASC
LIMIT 1
0.0001s
0019: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."BetterSiteTitle"
ELSE "SiteTree_Live"."BetterSiteTitle" END
AS "BetterSiteTitle", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."Keyword"
ELSE "SiteTree_Live"."Keyword" END
AS "Keyword", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."FeaturedKeyword"
ELSE "SiteTree_Live"."FeaturedKeyword" END
AS "FeaturedKeyword", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."KeywordQuestion"
ELSE "SiteTree_Live"."KeywordQuestion" END
AS "KeywordQuestion", "SiteTree_Live"."Follow", "SiteTree_Live"."FollowType", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."GenMetaDesc"
ELSE "SiteTree_Live"."GenMetaDesc" END
AS "GenMetaDesc", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."FBTitle"
ELSE "SiteTree_Live"."FBTitle" END
AS "FBTitle", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."FBDescription"
ELSE "SiteTree_Live"."FBDescription" END
AS "FBDescription", "SiteTree_Live"."FBType", "SiteTree_Live"."FBTypeOverride", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."TwTitle"
ELSE "SiteTree_Live"."TwTitle" END
AS "TwTitle", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."TwDescription"
ELSE "SiteTree_Live"."TwDescription" END
AS "TwDescription", "SiteTree_Live"."CanViewType", "SiteTree_Live"."CanEditType", "SiteTree_Live"."Version", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."URLSegment"
ELSE "SiteTree_Live"."URLSegment" END
AS "URLSegment", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."Title"
ELSE "SiteTree_Live"."Title" END
AS "Title", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."MenuTitle"
ELSE "SiteTree_Live"."MenuTitle" END
AS "MenuTitle", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."Content"
ELSE "SiteTree_Live"."Content" END
AS "Content", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."MetaDescription"
ELSE "SiteTree_Live"."MetaDescription" END
AS "MetaDescription", "SiteTree_Live"."ExtraMeta", "SiteTree_Live"."ShowInMenus", "SiteTree_Live"."ShowInSearch", "SiteTree_Live"."Sort", "SiteTree_Live"."HasBrokenFile", "SiteTree_Live"."HasBrokenLink", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."ReportClass"
ELSE "SiteTree_Live"."ReportClass" END
AS "ReportClass", "SiteTree_Live"."CanonicalLinkID", "SiteTree_Live"."FBImageID", "SiteTree_Live"."TwImageID", "SiteTree_Live"."ParentID", "SiteTree_Live"."ID",
CASE WHEN "SiteTree_Live"."ClassName" IS NOT NULL THEN "SiteTree_Live"."ClassName"
ELSE 'SilverStripe\\CMS\\Model\\SiteTree' END AS "RecordClassName", 'de_DE' AS "Locale", CASE WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN 'de_DE'
ELSE NULL END AS "SourceLocale"
FROM "SiteTree_Live" LEFT JOIN "SiteTree_Localised_Live" AS "SiteTree_Localised_de_DE" ON "SiteTree_Live"."ID" = "SiteTree_Localised_de_DE"."RecordID" AND "SiteTree_Localised_de_DE"."Locale" = ?
WHERE ("SiteTree_Live"."ID" = ?)
AND (("SiteTree_Localised_de_DE"."ID" IS NOT NULL))
ORDER BY "SiteTree_Live"."Sort" ASC
LIMIT 1
0.0001s
0020: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."BetterSiteTitle"
ELSE "SiteTree_Live"."BetterSiteTitle" END
AS "BetterSiteTitle", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."Keyword"
ELSE "SiteTree_Live"."Keyword" END
AS "Keyword", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."FeaturedKeyword"
ELSE "SiteTree_Live"."FeaturedKeyword" END
AS "FeaturedKeyword", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."KeywordQuestion"
ELSE "SiteTree_Live"."KeywordQuestion" END
AS "KeywordQuestion", "SiteTree_Live"."Follow", "SiteTree_Live"."FollowType", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."GenMetaDesc"
ELSE "SiteTree_Live"."GenMetaDesc" END
AS "GenMetaDesc", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."FBTitle"
ELSE "SiteTree_Live"."FBTitle" END
AS "FBTitle", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."FBDescription"
ELSE "SiteTree_Live"."FBDescription" END
AS "FBDescription", "SiteTree_Live"."FBType", "SiteTree_Live"."FBTypeOverride", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."TwTitle"
ELSE "SiteTree_Live"."TwTitle" END
AS "TwTitle", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."TwDescription"
ELSE "SiteTree_Live"."TwDescription" END
AS "TwDescription", "SiteTree_Live"."CanViewType", "SiteTree_Live"."CanEditType", "SiteTree_Live"."Version", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."URLSegment"
ELSE "SiteTree_Live"."URLSegment" END
AS "URLSegment", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."Title"
ELSE "SiteTree_Live"."Title" END
AS "Title", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."MenuTitle"
ELSE "SiteTree_Live"."MenuTitle" END
AS "MenuTitle", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."Content"
ELSE "SiteTree_Live"."Content" END
AS "Content", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."MetaDescription"
ELSE "SiteTree_Live"."MetaDescription" END
AS "MetaDescription", "SiteTree_Live"."ExtraMeta", "SiteTree_Live"."ShowInMenus", "SiteTree_Live"."ShowInSearch", "SiteTree_Live"."Sort", "SiteTree_Live"."HasBrokenFile", "SiteTree_Live"."HasBrokenLink", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."ReportClass"
ELSE "SiteTree_Live"."ReportClass" END
AS "ReportClass", "SiteTree_Live"."CanonicalLinkID", "SiteTree_Live"."FBImageID", "SiteTree_Live"."TwImageID", "SiteTree_Live"."ParentID", "SiteTree_Live"."ID",
CASE WHEN "SiteTree_Live"."ClassName" IS NOT NULL THEN "SiteTree_Live"."ClassName"
ELSE 'SilverStripe\\CMS\\Model\\SiteTree' END AS "RecordClassName", 'de_DE' AS "Locale", CASE WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN 'de_DE'
ELSE NULL END AS "SourceLocale"
FROM "SiteTree_Live" LEFT JOIN "SiteTree_Localised_Live" AS "SiteTree_Localised_de_DE" ON "SiteTree_Live"."ID" = "SiteTree_Localised_de_DE"."RecordID" AND "SiteTree_Localised_de_DE"."Locale" = ?
WHERE ("SiteTree_Live"."ID" = ?)
AND (("SiteTree_Localised_de_DE"."ID" IS NOT NULL))
ORDER BY "SiteTree_Live"."Sort" ASC
LIMIT 1
0.0001s
0021: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."BetterSiteTitle"
ELSE "SiteTree_Live"."BetterSiteTitle" END
AS "BetterSiteTitle", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."Keyword"
ELSE "SiteTree_Live"."Keyword" END
AS "Keyword", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."FeaturedKeyword"
ELSE "SiteTree_Live"."FeaturedKeyword" END
AS "FeaturedKeyword", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."KeywordQuestion"
ELSE "SiteTree_Live"."KeywordQuestion" END
AS "KeywordQuestion", "SiteTree_Live"."Follow", "SiteTree_Live"."FollowType", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."GenMetaDesc"
ELSE "SiteTree_Live"."GenMetaDesc" END
AS "GenMetaDesc", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."FBTitle"
ELSE "SiteTree_Live"."FBTitle" END
AS "FBTitle", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."FBDescription"
ELSE "SiteTree_Live"."FBDescription" END
AS "FBDescription", "SiteTree_Live"."FBType", "SiteTree_Live"."FBTypeOverride", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."TwTitle"
ELSE "SiteTree_Live"."TwTitle" END
AS "TwTitle", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."TwDescription"
ELSE "SiteTree_Live"."TwDescription" END
AS "TwDescription", "SiteTree_Live"."CanViewType", "SiteTree_Live"."CanEditType", "SiteTree_Live"."Version", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."URLSegment"
ELSE "SiteTree_Live"."URLSegment" END
AS "URLSegment", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."Title"
ELSE "SiteTree_Live"."Title" END
AS "Title", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."MenuTitle"
ELSE "SiteTree_Live"."MenuTitle" END
AS "MenuTitle", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."Content"
ELSE "SiteTree_Live"."Content" END
AS "Content", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."MetaDescription"
ELSE "SiteTree_Live"."MetaDescription" END
AS "MetaDescription", "SiteTree_Live"."ExtraMeta", "SiteTree_Live"."ShowInMenus", "SiteTree_Live"."ShowInSearch", "SiteTree_Live"."Sort", "SiteTree_Live"."HasBrokenFile", "SiteTree_Live"."HasBrokenLink", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."ReportClass"
ELSE "SiteTree_Live"."ReportClass" END
AS "ReportClass", "SiteTree_Live"."CanonicalLinkID", "SiteTree_Live"."FBImageID", "SiteTree_Live"."TwImageID", "SiteTree_Live"."ParentID", "SiteTree_Live"."ID",
CASE WHEN "SiteTree_Live"."ClassName" IS NOT NULL THEN "SiteTree_Live"."ClassName"
ELSE 'SilverStripe\\CMS\\Model\\SiteTree' END AS "RecordClassName", 'de_DE' AS "Locale", CASE WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN 'de_DE'
ELSE NULL END AS "SourceLocale"
FROM "SiteTree_Live" LEFT JOIN "SiteTree_Localised_Live" AS "SiteTree_Localised_de_DE" ON "SiteTree_Live"."ID" = "SiteTree_Localised_de_DE"."RecordID" AND "SiteTree_Localised_de_DE"."Locale" = ?
WHERE ("SiteTree_Live"."ID" = ?)
AND (("SiteTree_Localised_de_DE"."ID" IS NOT NULL))
ORDER BY "SiteTree_Live"."Sort" ASC
LIMIT 1
0.0001s
0022: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."BetterSiteTitle"
ELSE "SiteTree_Live"."BetterSiteTitle" END
AS "BetterSiteTitle", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."Keyword"
ELSE "SiteTree_Live"."Keyword" END
AS "Keyword", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."FeaturedKeyword"
ELSE "SiteTree_Live"."FeaturedKeyword" END
AS "FeaturedKeyword", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."KeywordQuestion"
ELSE "SiteTree_Live"."KeywordQuestion" END
AS "KeywordQuestion", "SiteTree_Live"."Follow", "SiteTree_Live"."FollowType", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."GenMetaDesc"
ELSE "SiteTree_Live"."GenMetaDesc" END
AS "GenMetaDesc", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."FBTitle"
ELSE "SiteTree_Live"."FBTitle" END
AS "FBTitle", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."FBDescription"
ELSE "SiteTree_Live"."FBDescription" END
AS "FBDescription", "SiteTree_Live"."FBType", "SiteTree_Live"."FBTypeOverride", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."TwTitle"
ELSE "SiteTree_Live"."TwTitle" END
AS "TwTitle", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."TwDescription"
ELSE "SiteTree_Live"."TwDescription" END
AS "TwDescription", "SiteTree_Live"."CanViewType", "SiteTree_Live"."CanEditType", "SiteTree_Live"."Version", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."URLSegment"
ELSE "SiteTree_Live"."URLSegment" END
AS "URLSegment", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."Title"
ELSE "SiteTree_Live"."Title" END
AS "Title", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."MenuTitle"
ELSE "SiteTree_Live"."MenuTitle" END
AS "MenuTitle", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."Content"
ELSE "SiteTree_Live"."Content" END
AS "Content", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."MetaDescription"
ELSE "SiteTree_Live"."MetaDescription" END
AS "MetaDescription", "SiteTree_Live"."ExtraMeta", "SiteTree_Live"."ShowInMenus", "SiteTree_Live"."ShowInSearch", "SiteTree_Live"."Sort", "SiteTree_Live"."HasBrokenFile", "SiteTree_Live"."HasBrokenLink", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."ReportClass"
ELSE "SiteTree_Live"."ReportClass" END
AS "ReportClass", "SiteTree_Live"."CanonicalLinkID", "SiteTree_Live"."FBImageID", "SiteTree_Live"."TwImageID", "SiteTree_Live"."ParentID", "SiteTree_Live"."ID",
CASE WHEN "SiteTree_Live"."ClassName" IS NOT NULL THEN "SiteTree_Live"."ClassName"
ELSE 'SilverStripe\\CMS\\Model\\SiteTree' END AS "RecordClassName", 'de_DE' AS "Locale", CASE WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN 'de_DE'
ELSE NULL END AS "SourceLocale"
FROM "SiteTree_Live" LEFT JOIN "SiteTree_Localised_Live" AS "SiteTree_Localised_de_DE" ON "SiteTree_Live"."ID" = "SiteTree_Localised_de_DE"."RecordID" AND "SiteTree_Localised_de_DE"."Locale" = ?
WHERE ("SiteTree_Live"."ID" = ?)
AND (("SiteTree_Localised_de_DE"."ID" IS NOT NULL))
ORDER BY "SiteTree_Live"."Sort" ASC
LIMIT 1
0.0001s
0023: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."BetterSiteTitle"
ELSE "SiteTree_Live"."BetterSiteTitle" END
AS "BetterSiteTitle", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."Keyword"
ELSE "SiteTree_Live"."Keyword" END
AS "Keyword", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."FeaturedKeyword"
ELSE "SiteTree_Live"."FeaturedKeyword" END
AS "FeaturedKeyword", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."KeywordQuestion"
ELSE "SiteTree_Live"."KeywordQuestion" END
AS "KeywordQuestion", "SiteTree_Live"."Follow", "SiteTree_Live"."FollowType", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."GenMetaDesc"
ELSE "SiteTree_Live"."GenMetaDesc" END
AS "GenMetaDesc", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."FBTitle"
ELSE "SiteTree_Live"."FBTitle" END
AS "FBTitle", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."FBDescription"
ELSE "SiteTree_Live"."FBDescription" END
AS "FBDescription", "SiteTree_Live"."FBType", "SiteTree_Live"."FBTypeOverride", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."TwTitle"
ELSE "SiteTree_Live"."TwTitle" END
AS "TwTitle", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."TwDescription"
ELSE "SiteTree_Live"."TwDescription" END
AS "TwDescription", "SiteTree_Live"."CanViewType", "SiteTree_Live"."CanEditType", "SiteTree_Live"."Version", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."URLSegment"
ELSE "SiteTree_Live"."URLSegment" END
AS "URLSegment", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."Title"
ELSE "SiteTree_Live"."Title" END
AS "Title", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."MenuTitle"
ELSE "SiteTree_Live"."MenuTitle" END
AS "MenuTitle", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."Content"
ELSE "SiteTree_Live"."Content" END
AS "Content", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."MetaDescription"
ELSE "SiteTree_Live"."MetaDescription" END
AS "MetaDescription", "SiteTree_Live"."ExtraMeta", "SiteTree_Live"."ShowInMenus", "SiteTree_Live"."ShowInSearch", "SiteTree_Live"."Sort", "SiteTree_Live"."HasBrokenFile", "SiteTree_Live"."HasBrokenLink", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."ReportClass"
ELSE "SiteTree_Live"."ReportClass" END
AS "ReportClass", "SiteTree_Live"."CanonicalLinkID", "SiteTree_Live"."FBImageID", "SiteTree_Live"."TwImageID", "SiteTree_Live"."ParentID", "SiteTree_Live"."ID",
CASE WHEN "SiteTree_Live"."ClassName" IS NOT NULL THEN "SiteTree_Live"."ClassName"
ELSE 'SilverStripe\\CMS\\Model\\SiteTree' END AS "RecordClassName", 'de_DE' AS "Locale", CASE WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN 'de_DE'
ELSE NULL END AS "SourceLocale"
FROM "SiteTree_Live" LEFT JOIN "SiteTree_Localised_Live" AS "SiteTree_Localised_de_DE" ON "SiteTree_Live"."ID" = "SiteTree_Localised_de_DE"."RecordID" AND "SiteTree_Localised_de_DE"."Locale" = ?
WHERE ("SiteTree_Live"."ID" = ?)
AND (("SiteTree_Localised_de_DE"."ID" IS NOT NULL))
ORDER BY "SiteTree_Live"."Sort" ASC
LIMIT 1
0.0001s
0024: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."BetterSiteTitle"
ELSE "SiteTree_Live"."BetterSiteTitle" END
AS "BetterSiteTitle", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."Keyword"
ELSE "SiteTree_Live"."Keyword" END
AS "Keyword", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."FeaturedKeyword"
ELSE "SiteTree_Live"."FeaturedKeyword" END
AS "FeaturedKeyword", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."KeywordQuestion"
ELSE "SiteTree_Live"."KeywordQuestion" END
AS "KeywordQuestion", "SiteTree_Live"."Follow", "SiteTree_Live"."FollowType", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."GenMetaDesc"
ELSE "SiteTree_Live"."GenMetaDesc" END
AS "GenMetaDesc", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."FBTitle"
ELSE "SiteTree_Live"."FBTitle" END
AS "FBTitle", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."FBDescription"
ELSE "SiteTree_Live"."FBDescription" END
AS "FBDescription", "SiteTree_Live"."FBType", "SiteTree_Live"."FBTypeOverride", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."TwTitle"
ELSE "SiteTree_Live"."TwTitle" END
AS "TwTitle", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."TwDescription"
ELSE "SiteTree_Live"."TwDescription" END
AS "TwDescription", "SiteTree_Live"."CanViewType", "SiteTree_Live"."CanEditType", "SiteTree_Live"."Version", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."URLSegment"
ELSE "SiteTree_Live"."URLSegment" END
AS "URLSegment", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."Title"
ELSE "SiteTree_Live"."Title" END
AS "Title", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."MenuTitle"
ELSE "SiteTree_Live"."MenuTitle" END
AS "MenuTitle", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."Content"
ELSE "SiteTree_Live"."Content" END
AS "Content", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."MetaDescription"
ELSE "SiteTree_Live"."MetaDescription" END
AS "MetaDescription", "SiteTree_Live"."ExtraMeta", "SiteTree_Live"."ShowInMenus", "SiteTree_Live"."ShowInSearch", "SiteTree_Live"."Sort", "SiteTree_Live"."HasBrokenFile", "SiteTree_Live"."HasBrokenLink", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."ReportClass"
ELSE "SiteTree_Live"."ReportClass" END
AS "ReportClass", "SiteTree_Live"."CanonicalLinkID", "SiteTree_Live"."FBImageID", "SiteTree_Live"."TwImageID", "SiteTree_Live"."ParentID", "SiteTree_Live"."ID",
CASE WHEN "SiteTree_Live"."ClassName" IS NOT NULL THEN "SiteTree_Live"."ClassName"
ELSE 'SilverStripe\\CMS\\Model\\SiteTree' END AS "RecordClassName", 'de_DE' AS "Locale", CASE WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN 'de_DE'
ELSE NULL END AS "SourceLocale"
FROM "SiteTree_Live" LEFT JOIN "SiteTree_Localised_Live" AS "SiteTree_Localised_de_DE" ON "SiteTree_Live"."ID" = "SiteTree_Localised_de_DE"."RecordID" AND "SiteTree_Localised_de_DE"."Locale" = ?
WHERE ("SiteTree_Live"."ID" = ?)
AND (("SiteTree_Localised_de_DE"."ID" IS NOT NULL))
ORDER BY "SiteTree_Live"."Sort" ASC
LIMIT 1
0.0001s
0025: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."BetterSiteTitle"
ELSE "SiteTree_Live"."BetterSiteTitle" END
AS "BetterSiteTitle", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."Keyword"
ELSE "SiteTree_Live"."Keyword" END
AS "Keyword", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."FeaturedKeyword"
ELSE "SiteTree_Live"."FeaturedKeyword" END
AS "FeaturedKeyword", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."KeywordQuestion"
ELSE "SiteTree_Live"."KeywordQuestion" END
AS "KeywordQuestion", "SiteTree_Live"."Follow", "SiteTree_Live"."FollowType", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."GenMetaDesc"
ELSE "SiteTree_Live"."GenMetaDesc" END
AS "GenMetaDesc", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."FBTitle"
ELSE "SiteTree_Live"."FBTitle" END
AS "FBTitle", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."FBDescription"
ELSE "SiteTree_Live"."FBDescription" END
AS "FBDescription", "SiteTree_Live"."FBType", "SiteTree_Live"."FBTypeOverride", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."TwTitle"
ELSE "SiteTree_Live"."TwTitle" END
AS "TwTitle", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."TwDescription"
ELSE "SiteTree_Live"."TwDescription" END
AS "TwDescription", "SiteTree_Live"."CanViewType", "SiteTree_Live"."CanEditType", "SiteTree_Live"."Version", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."URLSegment"
ELSE "SiteTree_Live"."URLSegment" END
AS "URLSegment", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."Title"
ELSE "SiteTree_Live"."Title" END
AS "Title", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."MenuTitle"
ELSE "SiteTree_Live"."MenuTitle" END
AS "MenuTitle", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."Content"
ELSE "SiteTree_Live"."Content" END
AS "Content", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."MetaDescription"
ELSE "SiteTree_Live"."MetaDescription" END
AS "MetaDescription", "SiteTree_Live"."ExtraMeta", "SiteTree_Live"."ShowInMenus", "SiteTree_Live"."ShowInSearch", "SiteTree_Live"."Sort", "SiteTree_Live"."HasBrokenFile", "SiteTree_Live"."HasBrokenLink", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."ReportClass"
ELSE "SiteTree_Live"."ReportClass" END
AS "ReportClass", "SiteTree_Live"."CanonicalLinkID", "SiteTree_Live"."FBImageID", "SiteTree_Live"."TwImageID", "SiteTree_Live"."ParentID", "SiteTree_Live"."ID",
CASE WHEN "SiteTree_Live"."ClassName" IS NOT NULL THEN "SiteTree_Live"."ClassName"
ELSE 'SilverStripe\\CMS\\Model\\SiteTree' END AS "RecordClassName", 'de_DE' AS "Locale", CASE WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN 'de_DE'
ELSE NULL END AS "SourceLocale"
FROM "SiteTree_Live" LEFT JOIN "SiteTree_Localised_Live" AS "SiteTree_Localised_de_DE" ON "SiteTree_Live"."ID" = "SiteTree_Localised_de_DE"."RecordID" AND "SiteTree_Localised_de_DE"."Locale" = ?
WHERE ("SiteTree_Live"."ID" = ?)
AND (("SiteTree_Localised_de_DE"."ID" IS NOT NULL))
ORDER BY "SiteTree_Live"."Sort" ASC
LIMIT 1
0.0001s
0026: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."BetterSiteTitle"
ELSE "SiteTree_Live"."BetterSiteTitle" END
AS "BetterSiteTitle", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."Keyword"
ELSE "SiteTree_Live"."Keyword" END
AS "Keyword", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."FeaturedKeyword"
ELSE "SiteTree_Live"."FeaturedKeyword" END
AS "FeaturedKeyword", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."KeywordQuestion"
ELSE "SiteTree_Live"."KeywordQuestion" END
AS "KeywordQuestion", "SiteTree_Live"."Follow", "SiteTree_Live"."FollowType", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."GenMetaDesc"
ELSE "SiteTree_Live"."GenMetaDesc" END
AS "GenMetaDesc", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."FBTitle"
ELSE "SiteTree_Live"."FBTitle" END
AS "FBTitle", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."FBDescription"
ELSE "SiteTree_Live"."FBDescription" END
AS "FBDescription", "SiteTree_Live"."FBType", "SiteTree_Live"."FBTypeOverride", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."TwTitle"
ELSE "SiteTree_Live"."TwTitle" END
AS "TwTitle", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."TwDescription"
ELSE "SiteTree_Live"."TwDescription" END
AS "TwDescription", "SiteTree_Live"."CanViewType", "SiteTree_Live"."CanEditType", "SiteTree_Live"."Version", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."URLSegment"
ELSE "SiteTree_Live"."URLSegment" END
AS "URLSegment", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."Title"
ELSE "SiteTree_Live"."Title" END
AS "Title", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."MenuTitle"
ELSE "SiteTree_Live"."MenuTitle" END
AS "MenuTitle", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."Content"
ELSE "SiteTree_Live"."Content" END
AS "Content", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."MetaDescription"
ELSE "SiteTree_Live"."MetaDescription" END
AS "MetaDescription", "SiteTree_Live"."ExtraMeta", "SiteTree_Live"."ShowInMenus", "SiteTree_Live"."ShowInSearch", "SiteTree_Live"."Sort", "SiteTree_Live"."HasBrokenFile", "SiteTree_Live"."HasBrokenLink", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."ReportClass"
ELSE "SiteTree_Live"."ReportClass" END
AS "ReportClass", "SiteTree_Live"."CanonicalLinkID", "SiteTree_Live"."FBImageID", "SiteTree_Live"."TwImageID", "SiteTree_Live"."ParentID", "SiteTree_Live"."ID",
CASE WHEN "SiteTree_Live"."ClassName" IS NOT NULL THEN "SiteTree_Live"."ClassName"
ELSE 'SilverStripe\\CMS\\Model\\SiteTree' END AS "RecordClassName", 'de_DE' AS "Locale", CASE WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN 'de_DE'
ELSE NULL END AS "SourceLocale"
FROM "SiteTree_Live" LEFT JOIN "SiteTree_Localised_Live" AS "SiteTree_Localised_de_DE" ON "SiteTree_Live"."ID" = "SiteTree_Localised_de_DE"."RecordID" AND "SiteTree_Localised_de_DE"."Locale" = ?
WHERE ("SiteTree_Live"."ID" = ?)
AND (("SiteTree_Localised_de_DE"."ID" IS NOT NULL))
ORDER BY "SiteTree_Live"."Sort" ASC
LIMIT 1
0.0001s
0027: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."BetterSiteTitle"
ELSE "SiteTree_Live"."BetterSiteTitle" END
AS "BetterSiteTitle", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."Keyword"
ELSE "SiteTree_Live"."Keyword" END
AS "Keyword", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."FeaturedKeyword"
ELSE "SiteTree_Live"."FeaturedKeyword" END
AS "FeaturedKeyword", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."KeywordQuestion"
ELSE "SiteTree_Live"."KeywordQuestion" END
AS "KeywordQuestion", "SiteTree_Live"."Follow", "SiteTree_Live"."FollowType", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."GenMetaDesc"
ELSE "SiteTree_Live"."GenMetaDesc" END
AS "GenMetaDesc", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."FBTitle"
ELSE "SiteTree_Live"."FBTitle" END
AS "FBTitle", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."FBDescription"
ELSE "SiteTree_Live"."FBDescription" END
AS "FBDescription", "SiteTree_Live"."FBType", "SiteTree_Live"."FBTypeOverride", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."TwTitle"
ELSE "SiteTree_Live"."TwTitle" END
AS "TwTitle", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."TwDescription"
ELSE "SiteTree_Live"."TwDescription" END
AS "TwDescription", "SiteTree_Live"."CanViewType", "SiteTree_Live"."CanEditType", "SiteTree_Live"."Version", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."URLSegment"
ELSE "SiteTree_Live"."URLSegment" END
AS "URLSegment", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."Title"
ELSE "SiteTree_Live"."Title" END
AS "Title", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."MenuTitle"
ELSE "SiteTree_Live"."MenuTitle" END
AS "MenuTitle", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."Content"
ELSE "SiteTree_Live"."Content" END
AS "Content", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."MetaDescription"
ELSE "SiteTree_Live"."MetaDescription" END
AS "MetaDescription", "SiteTree_Live"."ExtraMeta", "SiteTree_Live"."ShowInMenus", "SiteTree_Live"."ShowInSearch", "SiteTree_Live"."Sort", "SiteTree_Live"."HasBrokenFile", "SiteTree_Live"."HasBrokenLink", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."ReportClass"
ELSE "SiteTree_Live"."ReportClass" END
AS "ReportClass", "SiteTree_Live"."CanonicalLinkID", "SiteTree_Live"."FBImageID", "SiteTree_Live"."TwImageID", "SiteTree_Live"."ParentID", "SiteTree_Live"."ID",
CASE WHEN "SiteTree_Live"."ClassName" IS NOT NULL THEN "SiteTree_Live"."ClassName"
ELSE 'SilverStripe\\CMS\\Model\\SiteTree' END AS "RecordClassName", 'de_DE' AS "Locale", CASE WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN 'de_DE'
ELSE NULL END AS "SourceLocale"
FROM "SiteTree_Live" LEFT JOIN "SiteTree_Localised_Live" AS "SiteTree_Localised_de_DE" ON "SiteTree_Live"."ID" = "SiteTree_Localised_de_DE"."RecordID" AND "SiteTree_Localised_de_DE"."Locale" = ?
WHERE ("SiteTree_Live"."ID" = ?)
AND (("SiteTree_Localised_de_DE"."ID" IS NOT NULL))
ORDER BY "SiteTree_Live"."Sort" ASC
LIMIT 1
0.0001s
0028: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."BetterSiteTitle"
ELSE "SiteTree_Live"."BetterSiteTitle" END
AS "BetterSiteTitle", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."Keyword"
ELSE "SiteTree_Live"."Keyword" END
AS "Keyword", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."FeaturedKeyword"
ELSE "SiteTree_Live"."FeaturedKeyword" END
AS "FeaturedKeyword", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."KeywordQuestion"
ELSE "SiteTree_Live"."KeywordQuestion" END
AS "KeywordQuestion", "SiteTree_Live"."Follow", "SiteTree_Live"."FollowType", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."GenMetaDesc"
ELSE "SiteTree_Live"."GenMetaDesc" END
AS "GenMetaDesc", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."FBTitle"
ELSE "SiteTree_Live"."FBTitle" END
AS "FBTitle", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."FBDescription"
ELSE "SiteTree_Live"."FBDescription" END
AS "FBDescription", "SiteTree_Live"."FBType", "SiteTree_Live"."FBTypeOverride", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."TwTitle"
ELSE "SiteTree_Live"."TwTitle" END
AS "TwTitle", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."TwDescription"
ELSE "SiteTree_Live"."TwDescription" END
AS "TwDescription", "SiteTree_Live"."CanViewType", "SiteTree_Live"."CanEditType", "SiteTree_Live"."Version", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."URLSegment"
ELSE "SiteTree_Live"."URLSegment" END
AS "URLSegment", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."Title"
ELSE "SiteTree_Live"."Title" END
AS "Title", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."MenuTitle"
ELSE "SiteTree_Live"."MenuTitle" END
AS "MenuTitle", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."Content"
ELSE "SiteTree_Live"."Content" END
AS "Content", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."MetaDescription"
ELSE "SiteTree_Live"."MetaDescription" END
AS "MetaDescription", "SiteTree_Live"."ExtraMeta", "SiteTree_Live"."ShowInMenus", "SiteTree_Live"."ShowInSearch", "SiteTree_Live"."Sort", "SiteTree_Live"."HasBrokenFile", "SiteTree_Live"."HasBrokenLink", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."ReportClass"
ELSE "SiteTree_Live"."ReportClass" END
AS "ReportClass", "SiteTree_Live"."CanonicalLinkID", "SiteTree_Live"."FBImageID", "SiteTree_Live"."TwImageID", "SiteTree_Live"."ParentID", "SiteTree_Live"."ID",
CASE WHEN "SiteTree_Live"."ClassName" IS NOT NULL THEN "SiteTree_Live"."ClassName"
ELSE 'SilverStripe\\CMS\\Model\\SiteTree' END AS "RecordClassName", 'de_DE' AS "Locale", CASE WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN 'de_DE'
ELSE NULL END AS "SourceLocale"
FROM "SiteTree_Live" LEFT JOIN "SiteTree_Localised_Live" AS "SiteTree_Localised_de_DE" ON "SiteTree_Live"."ID" = "SiteTree_Localised_de_DE"."RecordID" AND "SiteTree_Localised_de_DE"."Locale" = ?
WHERE ("SiteTree_Live"."ID" = ?)
AND (("SiteTree_Localised_de_DE"."ID" IS NOT NULL))
ORDER BY "SiteTree_Live"."Sort" ASC
LIMIT 1
0.0001s
0029: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."BetterSiteTitle"
ELSE "SiteTree_Live"."BetterSiteTitle" END
AS "BetterSiteTitle", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."Keyword"
ELSE "SiteTree_Live"."Keyword" END
AS "Keyword", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."FeaturedKeyword"
ELSE "SiteTree_Live"."FeaturedKeyword" END
AS "FeaturedKeyword", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."KeywordQuestion"
ELSE "SiteTree_Live"."KeywordQuestion" END
AS "KeywordQuestion", "SiteTree_Live"."Follow", "SiteTree_Live"."FollowType", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."GenMetaDesc"
ELSE "SiteTree_Live"."GenMetaDesc" END
AS "GenMetaDesc", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."FBTitle"
ELSE "SiteTree_Live"."FBTitle" END
AS "FBTitle", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."FBDescription"
ELSE "SiteTree_Live"."FBDescription" END
AS "FBDescription", "SiteTree_Live"."FBType", "SiteTree_Live"."FBTypeOverride", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."TwTitle"
ELSE "SiteTree_Live"."TwTitle" END
AS "TwTitle", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."TwDescription"
ELSE "SiteTree_Live"."TwDescription" END
AS "TwDescription", "SiteTree_Live"."CanViewType", "SiteTree_Live"."CanEditType", "SiteTree_Live"."Version", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."URLSegment"
ELSE "SiteTree_Live"."URLSegment" END
AS "URLSegment", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."Title"
ELSE "SiteTree_Live"."Title" END
AS "Title", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."MenuTitle"
ELSE "SiteTree_Live"."MenuTitle" END
AS "MenuTitle", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."Content"
ELSE "SiteTree_Live"."Content" END
AS "Content", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."MetaDescription"
ELSE "SiteTree_Live"."MetaDescription" END
AS "MetaDescription", "SiteTree_Live"."ExtraMeta", "SiteTree_Live"."ShowInMenus", "SiteTree_Live"."ShowInSearch", "SiteTree_Live"."Sort", "SiteTree_Live"."HasBrokenFile", "SiteTree_Live"."HasBrokenLink", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."ReportClass"
ELSE "SiteTree_Live"."ReportClass" END
AS "ReportClass", "SiteTree_Live"."CanonicalLinkID", "SiteTree_Live"."FBImageID", "SiteTree_Live"."TwImageID", "SiteTree_Live"."ParentID", "SiteTree_Live"."ID",
CASE WHEN "SiteTree_Live"."ClassName" IS NOT NULL THEN "SiteTree_Live"."ClassName"
ELSE 'SilverStripe\\CMS\\Model\\SiteTree' END AS "RecordClassName", 'de_DE' AS "Locale", CASE WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN 'de_DE'
ELSE NULL END AS "SourceLocale"
FROM "SiteTree_Live" LEFT JOIN "SiteTree_Localised_Live" AS "SiteTree_Localised_de_DE" ON "SiteTree_Live"."ID" = "SiteTree_Localised_de_DE"."RecordID" AND "SiteTree_Localised_de_DE"."Locale" = ?
WHERE ("SiteTree_Live"."ID" = ?)
AND (("SiteTree_Localised_de_DE"."ID" IS NOT NULL))
ORDER BY "SiteTree_Live"."Sort" ASC
LIMIT 1
0.0001s
0030: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."BetterSiteTitle"
ELSE "SiteTree_Live"."BetterSiteTitle" END
AS "BetterSiteTitle", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."Keyword"
ELSE "SiteTree_Live"."Keyword" END
AS "Keyword", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."FeaturedKeyword"
ELSE "SiteTree_Live"."FeaturedKeyword" END
AS "FeaturedKeyword", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."KeywordQuestion"
ELSE "SiteTree_Live"."KeywordQuestion" END
AS "KeywordQuestion", "SiteTree_Live"."Follow", "SiteTree_Live"."FollowType", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."GenMetaDesc"
ELSE "SiteTree_Live"."GenMetaDesc" END
AS "GenMetaDesc", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."FBTitle"
ELSE "SiteTree_Live"."FBTitle" END
AS "FBTitle", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."FBDescription"
ELSE "SiteTree_Live"."FBDescription" END
AS "FBDescription", "SiteTree_Live"."FBType", "SiteTree_Live"."FBTypeOverride", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."TwTitle"
ELSE "SiteTree_Live"."TwTitle" END
AS "TwTitle", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."TwDescription"
ELSE "SiteTree_Live"."TwDescription" END
AS "TwDescription", "SiteTree_Live"."CanViewType", "SiteTree_Live"."CanEditType", "SiteTree_Live"."Version", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."URLSegment"
ELSE "SiteTree_Live"."URLSegment" END
AS "URLSegment", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."Title"
ELSE "SiteTree_Live"."Title" END
AS "Title", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."MenuTitle"
ELSE "SiteTree_Live"."MenuTitle" END
AS "MenuTitle", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."Content"
ELSE "SiteTree_Live"."Content" END
AS "Content", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."MetaDescription"
ELSE "SiteTree_Live"."MetaDescription" END
AS "MetaDescription", "SiteTree_Live"."ExtraMeta", "SiteTree_Live"."ShowInMenus", "SiteTree_Live"."ShowInSearch", "SiteTree_Live"."Sort", "SiteTree_Live"."HasBrokenFile", "SiteTree_Live"."HasBrokenLink", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."ReportClass"
ELSE "SiteTree_Live"."ReportClass" END
AS "ReportClass", "SiteTree_Live"."CanonicalLinkID", "SiteTree_Live"."FBImageID", "SiteTree_Live"."TwImageID", "SiteTree_Live"."ParentID", "SiteTree_Live"."ID",
CASE WHEN "SiteTree_Live"."ClassName" IS NOT NULL THEN "SiteTree_Live"."ClassName"
ELSE 'SilverStripe\\CMS\\Model\\SiteTree' END AS "RecordClassName", 'de_DE' AS "Locale", CASE WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN 'de_DE'
ELSE NULL END AS "SourceLocale"
FROM "SiteTree_Live" LEFT JOIN "SiteTree_Localised_Live" AS "SiteTree_Localised_de_DE" ON "SiteTree_Live"."ID" = "SiteTree_Localised_de_DE"."RecordID" AND "SiteTree_Localised_de_DE"."Locale" = ?
WHERE ("SiteTree_Live"."ID" = ?)
AND (("SiteTree_Localised_de_DE"."ID" IS NOT NULL))
ORDER BY "SiteTree_Live"."Sort" ASC
LIMIT 1
0.0001s
0031: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."BetterSiteTitle"
ELSE "SiteTree_Live"."BetterSiteTitle" END
AS "BetterSiteTitle", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."Keyword"
ELSE "SiteTree_Live"."Keyword" END
AS "Keyword", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."FeaturedKeyword"
ELSE "SiteTree_Live"."FeaturedKeyword" END
AS "FeaturedKeyword", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."KeywordQuestion"
ELSE "SiteTree_Live"."KeywordQuestion" END
AS "KeywordQuestion", "SiteTree_Live"."Follow", "SiteTree_Live"."FollowType", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."GenMetaDesc"
ELSE "SiteTree_Live"."GenMetaDesc" END
AS "GenMetaDesc", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."FBTitle"
ELSE "SiteTree_Live"."FBTitle" END
AS "FBTitle", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."FBDescription"
ELSE "SiteTree_Live"."FBDescription" END
AS "FBDescription", "SiteTree_Live"."FBType", "SiteTree_Live"."FBTypeOverride", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."TwTitle"
ELSE "SiteTree_Live"."TwTitle" END
AS "TwTitle", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."TwDescription"
ELSE "SiteTree_Live"."TwDescription" END
AS "TwDescription", "SiteTree_Live"."CanViewType", "SiteTree_Live"."CanEditType", "SiteTree_Live"."Version", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."URLSegment"
ELSE "SiteTree_Live"."URLSegment" END
AS "URLSegment", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."Title"
ELSE "SiteTree_Live"."Title" END
AS "Title", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."MenuTitle"
ELSE "SiteTree_Live"."MenuTitle" END
AS "MenuTitle", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."Content"
ELSE "SiteTree_Live"."Content" END
AS "Content", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."MetaDescription"
ELSE "SiteTree_Live"."MetaDescription" END
AS "MetaDescription", "SiteTree_Live"."ExtraMeta", "SiteTree_Live"."ShowInMenus", "SiteTree_Live"."ShowInSearch", "SiteTree_Live"."Sort", "SiteTree_Live"."HasBrokenFile", "SiteTree_Live"."HasBrokenLink", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."ReportClass"
ELSE "SiteTree_Live"."ReportClass" END
AS "ReportClass", "SiteTree_Live"."CanonicalLinkID", "SiteTree_Live"."FBImageID", "SiteTree_Live"."TwImageID", "SiteTree_Live"."ParentID", "SiteTree_Live"."ID",
CASE WHEN "SiteTree_Live"."ClassName" IS NOT NULL THEN "SiteTree_Live"."ClassName"
ELSE 'SilverStripe\\CMS\\Model\\SiteTree' END AS "RecordClassName", 'de_DE' AS "Locale", CASE WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN 'de_DE'
ELSE NULL END AS "SourceLocale"
FROM "SiteTree_Live" LEFT JOIN "SiteTree_Localised_Live" AS "SiteTree_Localised_de_DE" ON "SiteTree_Live"."ID" = "SiteTree_Localised_de_DE"."RecordID" AND "SiteTree_Localised_de_DE"."Locale" = ?
WHERE ("SiteTree_Live"."ID" = ?)
AND (("SiteTree_Localised_de_DE"."ID" IS NOT NULL))
ORDER BY "SiteTree_Live"."Sort" ASC
LIMIT 1
0.0001s
0032: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."BetterSiteTitle"
ELSE "SiteTree_Live"."BetterSiteTitle" END
AS "BetterSiteTitle", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."Keyword"
ELSE "SiteTree_Live"."Keyword" END
AS "Keyword", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."FeaturedKeyword"
ELSE "SiteTree_Live"."FeaturedKeyword" END
AS "FeaturedKeyword", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."KeywordQuestion"
ELSE "SiteTree_Live"."KeywordQuestion" END
AS "KeywordQuestion", "SiteTree_Live"."Follow", "SiteTree_Live"."FollowType", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."GenMetaDesc"
ELSE "SiteTree_Live"."GenMetaDesc" END
AS "GenMetaDesc", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."FBTitle"
ELSE "SiteTree_Live"."FBTitle" END
AS "FBTitle", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."FBDescription"
ELSE "SiteTree_Live"."FBDescription" END
AS "FBDescription", "SiteTree_Live"."FBType", "SiteTree_Live"."FBTypeOverride", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."TwTitle"
ELSE "SiteTree_Live"."TwTitle" END
AS "TwTitle", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."TwDescription"
ELSE "SiteTree_Live"."TwDescription" END
AS "TwDescription", "SiteTree_Live"."CanViewType", "SiteTree_Live"."CanEditType", "SiteTree_Live"."Version", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."URLSegment"
ELSE "SiteTree_Live"."URLSegment" END
AS "URLSegment", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."Title"
ELSE "SiteTree_Live"."Title" END
AS "Title", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."MenuTitle"
ELSE "SiteTree_Live"."MenuTitle" END
AS "MenuTitle", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."Content"
ELSE "SiteTree_Live"."Content" END
AS "Content", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."MetaDescription"
ELSE "SiteTree_Live"."MetaDescription" END
AS "MetaDescription", "SiteTree_Live"."ExtraMeta", "SiteTree_Live"."ShowInMenus", "SiteTree_Live"."ShowInSearch", "SiteTree_Live"."Sort", "SiteTree_Live"."HasBrokenFile", "SiteTree_Live"."HasBrokenLink", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."ReportClass"
ELSE "SiteTree_Live"."ReportClass" END
AS "ReportClass", "SiteTree_Live"."CanonicalLinkID", "SiteTree_Live"."FBImageID", "SiteTree_Live"."TwImageID", "SiteTree_Live"."ParentID", "SiteTree_Live"."ID",
CASE WHEN "SiteTree_Live"."ClassName" IS NOT NULL THEN "SiteTree_Live"."ClassName"
ELSE 'SilverStripe\\CMS\\Model\\SiteTree' END AS "RecordClassName", 'de_DE' AS "Locale", CASE WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN 'de_DE'
ELSE NULL END AS "SourceLocale"
FROM "SiteTree_Live" LEFT JOIN "SiteTree_Localised_Live" AS "SiteTree_Localised_de_DE" ON "SiteTree_Live"."ID" = "SiteTree_Localised_de_DE"."RecordID" AND "SiteTree_Localised_de_DE"."Locale" = ?
WHERE ("SiteTree_Live"."ID" = ?)
AND (("SiteTree_Localised_de_DE"."ID" IS NOT NULL))
ORDER BY "SiteTree_Live"."Sort" ASC
LIMIT 1
0.0001s
0033: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."BetterSiteTitle"
ELSE "SiteTree_Live"."BetterSiteTitle" END
AS "BetterSiteTitle", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."Keyword"
ELSE "SiteTree_Live"."Keyword" END
AS "Keyword", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."FeaturedKeyword"
ELSE "SiteTree_Live"."FeaturedKeyword" END
AS "FeaturedKeyword", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."KeywordQuestion"
ELSE "SiteTree_Live"."KeywordQuestion" END
AS "KeywordQuestion", "SiteTree_Live"."Follow", "SiteTree_Live"."FollowType", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."GenMetaDesc"
ELSE "SiteTree_Live"."GenMetaDesc" END
AS "GenMetaDesc", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."FBTitle"
ELSE "SiteTree_Live"."FBTitle" END
AS "FBTitle", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."FBDescription"
ELSE "SiteTree_Live"."FBDescription" END
AS "FBDescription", "SiteTree_Live"."FBType", "SiteTree_Live"."FBTypeOverride", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."TwTitle"
ELSE "SiteTree_Live"."TwTitle" END
AS "TwTitle", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."TwDescription"
ELSE "SiteTree_Live"."TwDescription" END
AS "TwDescription", "SiteTree_Live"."CanViewType", "SiteTree_Live"."CanEditType", "SiteTree_Live"."Version", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."URLSegment"
ELSE "SiteTree_Live"."URLSegment" END
AS "URLSegment", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."Title"
ELSE "SiteTree_Live"."Title" END
AS "Title", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."MenuTitle"
ELSE "SiteTree_Live"."MenuTitle" END
AS "MenuTitle", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."Content"
ELSE "SiteTree_Live"."Content" END
AS "Content", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."MetaDescription"
ELSE "SiteTree_Live"."MetaDescription" END
AS "MetaDescription", "SiteTree_Live"."ExtraMeta", "SiteTree_Live"."ShowInMenus", "SiteTree_Live"."ShowInSearch", "SiteTree_Live"."Sort", "SiteTree_Live"."HasBrokenFile", "SiteTree_Live"."HasBrokenLink", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."ReportClass"
ELSE "SiteTree_Live"."ReportClass" END
AS "ReportClass", "SiteTree_Live"."CanonicalLinkID", "SiteTree_Live"."FBImageID", "SiteTree_Live"."TwImageID", "SiteTree_Live"."ParentID", "SiteTree_Live"."ID",
CASE WHEN "SiteTree_Live"."ClassName" IS NOT NULL THEN "SiteTree_Live"."ClassName"
ELSE 'SilverStripe\\CMS\\Model\\SiteTree' END AS "RecordClassName", 'de_DE' AS "Locale", CASE WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN 'de_DE'
ELSE NULL END AS "SourceLocale"
FROM "SiteTree_Live" LEFT JOIN "SiteTree_Localised_Live" AS "SiteTree_Localised_de_DE" ON "SiteTree_Live"."ID" = "SiteTree_Localised_de_DE"."RecordID" AND "SiteTree_Localised_de_DE"."Locale" = ?
WHERE ("SiteTree_Live"."ID" = ?)
AND (("SiteTree_Localised_de_DE"."ID" IS NOT NULL))
ORDER BY "SiteTree_Live"."Sort" ASC
LIMIT 1
0.0001s
0034: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."BetterSiteTitle"
ELSE "SiteTree_Live"."BetterSiteTitle" END
AS "BetterSiteTitle", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."Keyword"
ELSE "SiteTree_Live"."Keyword" END
AS "Keyword", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."FeaturedKeyword"
ELSE "SiteTree_Live"."FeaturedKeyword" END
AS "FeaturedKeyword", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."KeywordQuestion"
ELSE "SiteTree_Live"."KeywordQuestion" END
AS "KeywordQuestion", "SiteTree_Live"."Follow", "SiteTree_Live"."FollowType", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."GenMetaDesc"
ELSE "SiteTree_Live"."GenMetaDesc" END
AS "GenMetaDesc", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."FBTitle"
ELSE "SiteTree_Live"."FBTitle" END
AS "FBTitle", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."FBDescription"
ELSE "SiteTree_Live"."FBDescription" END
AS "FBDescription", "SiteTree_Live"."FBType", "SiteTree_Live"."FBTypeOverride", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."TwTitle"
ELSE "SiteTree_Live"."TwTitle" END
AS "TwTitle", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."TwDescription"
ELSE "SiteTree_Live"."TwDescription" END
AS "TwDescription", "SiteTree_Live"."CanViewType", "SiteTree_Live"."CanEditType", "SiteTree_Live"."Version", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."URLSegment"
ELSE "SiteTree_Live"."URLSegment" END
AS "URLSegment", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."Title"
ELSE "SiteTree_Live"."Title" END
AS "Title", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."MenuTitle"
ELSE "SiteTree_Live"."MenuTitle" END
AS "MenuTitle", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."Content"
ELSE "SiteTree_Live"."Content" END
AS "Content", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."MetaDescription"
ELSE "SiteTree_Live"."MetaDescription" END
AS "MetaDescription", "SiteTree_Live"."ExtraMeta", "SiteTree_Live"."ShowInMenus", "SiteTree_Live"."ShowInSearch", "SiteTree_Live"."Sort", "SiteTree_Live"."HasBrokenFile", "SiteTree_Live"."HasBrokenLink", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."ReportClass"
ELSE "SiteTree_Live"."ReportClass" END
AS "ReportClass", "SiteTree_Live"."CanonicalLinkID", "SiteTree_Live"."FBImageID", "SiteTree_Live"."TwImageID", "SiteTree_Live"."ParentID", "SiteTree_Live"."ID",
CASE WHEN "SiteTree_Live"."ClassName" IS NOT NULL THEN "SiteTree_Live"."ClassName"
ELSE 'SilverStripe\\CMS\\Model\\SiteTree' END AS "RecordClassName", 'de_DE' AS "Locale", CASE WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN 'de_DE'
ELSE NULL END AS "SourceLocale"
FROM "SiteTree_Live" LEFT JOIN "SiteTree_Localised_Live" AS "SiteTree_Localised_de_DE" ON "SiteTree_Live"."ID" = "SiteTree_Localised_de_DE"."RecordID" AND "SiteTree_Localised_de_DE"."Locale" = ?
WHERE ("SiteTree_Live"."ID" = ?)
AND (("SiteTree_Localised_de_DE"."ID" IS NOT NULL))
ORDER BY "SiteTree_Live"."Sort" ASC
LIMIT 1
0.0001s
0035: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."BetterSiteTitle"
ELSE "SiteTree_Live"."BetterSiteTitle" END
AS "BetterSiteTitle", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."Keyword"
ELSE "SiteTree_Live"."Keyword" END
AS "Keyword", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."FeaturedKeyword"
ELSE "SiteTree_Live"."FeaturedKeyword" END
AS "FeaturedKeyword", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."KeywordQuestion"
ELSE "SiteTree_Live"."KeywordQuestion" END
AS "KeywordQuestion", "SiteTree_Live"."Follow", "SiteTree_Live"."FollowType", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."GenMetaDesc"
ELSE "SiteTree_Live"."GenMetaDesc" END
AS "GenMetaDesc", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."FBTitle"
ELSE "SiteTree_Live"."FBTitle" END
AS "FBTitle", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."FBDescription"
ELSE "SiteTree_Live"."FBDescription" END
AS "FBDescription", "SiteTree_Live"."FBType", "SiteTree_Live"."FBTypeOverride", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."TwTitle"
ELSE "SiteTree_Live"."TwTitle" END
AS "TwTitle", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."TwDescription"
ELSE "SiteTree_Live"."TwDescription" END
AS "TwDescription", "SiteTree_Live"."CanViewType", "SiteTree_Live"."CanEditType", "SiteTree_Live"."Version", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."URLSegment"
ELSE "SiteTree_Live"."URLSegment" END
AS "URLSegment", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."Title"
ELSE "SiteTree_Live"."Title" END
AS "Title", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."MenuTitle"
ELSE "SiteTree_Live"."MenuTitle" END
AS "MenuTitle", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."Content"
ELSE "SiteTree_Live"."Content" END
AS "Content", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."MetaDescription"
ELSE "SiteTree_Live"."MetaDescription" END
AS "MetaDescription", "SiteTree_Live"."ExtraMeta", "SiteTree_Live"."ShowInMenus", "SiteTree_Live"."ShowInSearch", "SiteTree_Live"."Sort", "SiteTree_Live"."HasBrokenFile", "SiteTree_Live"."HasBrokenLink", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."ReportClass"
ELSE "SiteTree_Live"."ReportClass" END
AS "ReportClass", "SiteTree_Live"."CanonicalLinkID", "SiteTree_Live"."FBImageID", "SiteTree_Live"."TwImageID", "SiteTree_Live"."ParentID", "SiteTree_Live"."ID",
CASE WHEN "SiteTree_Live"."ClassName" IS NOT NULL THEN "SiteTree_Live"."ClassName"
ELSE 'SilverStripe\\CMS\\Model\\SiteTree' END AS "RecordClassName", 'de_DE' AS "Locale", CASE WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN 'de_DE'
ELSE NULL END AS "SourceLocale"
FROM "SiteTree_Live" LEFT JOIN "SiteTree_Localised_Live" AS "SiteTree_Localised_de_DE" ON "SiteTree_Live"."ID" = "SiteTree_Localised_de_DE"."RecordID" AND "SiteTree_Localised_de_DE"."Locale" = ?
WHERE ("SiteTree_Live"."ID" = ?)
AND (("SiteTree_Localised_de_DE"."ID" IS NOT NULL))
ORDER BY "SiteTree_Live"."Sort" ASC
LIMIT 1
0.0002s
0036: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."BetterSiteTitle"
ELSE "SiteTree_Live"."BetterSiteTitle" END
AS "BetterSiteTitle", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."Keyword"
ELSE "SiteTree_Live"."Keyword" END
AS "Keyword", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."FeaturedKeyword"
ELSE "SiteTree_Live"."FeaturedKeyword" END
AS "FeaturedKeyword", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."KeywordQuestion"
ELSE "SiteTree_Live"."KeywordQuestion" END
AS "KeywordQuestion", "SiteTree_Live"."Follow", "SiteTree_Live"."FollowType", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."GenMetaDesc"
ELSE "SiteTree_Live"."GenMetaDesc" END
AS "GenMetaDesc", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."FBTitle"
ELSE "SiteTree_Live"."FBTitle" END
AS "FBTitle", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."FBDescription"
ELSE "SiteTree_Live"."FBDescription" END
AS "FBDescription", "SiteTree_Live"."FBType", "SiteTree_Live"."FBTypeOverride", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."TwTitle"
ELSE "SiteTree_Live"."TwTitle" END
AS "TwTitle", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."TwDescription"
ELSE "SiteTree_Live"."TwDescription" END
AS "TwDescription", "SiteTree_Live"."CanViewType", "SiteTree_Live"."CanEditType", "SiteTree_Live"."Version", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."URLSegment"
ELSE "SiteTree_Live"."URLSegment" END
AS "URLSegment", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."Title"
ELSE "SiteTree_Live"."Title" END
AS "Title", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."MenuTitle"
ELSE "SiteTree_Live"."MenuTitle" END
AS "MenuTitle", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."Content"
ELSE "SiteTree_Live"."Content" END
AS "Content", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."MetaDescription"
ELSE "SiteTree_Live"."MetaDescription" END
AS "MetaDescription", "SiteTree_Live"."ExtraMeta", "SiteTree_Live"."ShowInMenus", "SiteTree_Live"."ShowInSearch", "SiteTree_Live"."Sort", "SiteTree_Live"."HasBrokenFile", "SiteTree_Live"."HasBrokenLink", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."ReportClass"
ELSE "SiteTree_Live"."ReportClass" END
AS "ReportClass", "SiteTree_Live"."CanonicalLinkID", "SiteTree_Live"."FBImageID", "SiteTree_Live"."TwImageID", "SiteTree_Live"."ParentID", "SiteTree_Live"."ID",
CASE WHEN "SiteTree_Live"."ClassName" IS NOT NULL THEN "SiteTree_Live"."ClassName"
ELSE 'SilverStripe\\CMS\\Model\\SiteTree' END AS "RecordClassName", 'de_DE' AS "Locale", CASE WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN 'de_DE'
ELSE NULL END AS "SourceLocale"
FROM "SiteTree_Live" LEFT JOIN "SiteTree_Localised_Live" AS "SiteTree_Localised_de_DE" ON "SiteTree_Live"."ID" = "SiteTree_Localised_de_DE"."RecordID" AND "SiteTree_Localised_de_DE"."Locale" = ?
WHERE ("SiteTree_Live"."ID" = ?)
AND (("SiteTree_Localised_de_DE"."ID" IS NOT NULL))
ORDER BY "SiteTree_Live"."Sort" ASC
LIMIT 1
0.0001s
0037: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."BetterSiteTitle"
ELSE "SiteTree_Live"."BetterSiteTitle" END
AS "BetterSiteTitle", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."Keyword"
ELSE "SiteTree_Live"."Keyword" END
AS "Keyword", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."FeaturedKeyword"
ELSE "SiteTree_Live"."FeaturedKeyword" END
AS "FeaturedKeyword", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."KeywordQuestion"
ELSE "SiteTree_Live"."KeywordQuestion" END
AS "KeywordQuestion", "SiteTree_Live"."Follow", "SiteTree_Live"."FollowType", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."GenMetaDesc"
ELSE "SiteTree_Live"."GenMetaDesc" END
AS "GenMetaDesc", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."FBTitle"
ELSE "SiteTree_Live"."FBTitle" END
AS "FBTitle", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."FBDescription"
ELSE "SiteTree_Live"."FBDescription" END
AS "FBDescription", "SiteTree_Live"."FBType", "SiteTree_Live"."FBTypeOverride", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."TwTitle"
ELSE "SiteTree_Live"."TwTitle" END
AS "TwTitle", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."TwDescription"
ELSE "SiteTree_Live"."TwDescription" END
AS "TwDescription", "SiteTree_Live"."CanViewType", "SiteTree_Live"."CanEditType", "SiteTree_Live"."Version", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."URLSegment"
ELSE "SiteTree_Live"."URLSegment" END
AS "URLSegment", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."Title"
ELSE "SiteTree_Live"."Title" END
AS "Title", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."MenuTitle"
ELSE "SiteTree_Live"."MenuTitle" END
AS "MenuTitle", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."Content"
ELSE "SiteTree_Live"."Content" END
AS "Content", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."MetaDescription"
ELSE "SiteTree_Live"."MetaDescription" END
AS "MetaDescription", "SiteTree_Live"."ExtraMeta", "SiteTree_Live"."ShowInMenus", "SiteTree_Live"."ShowInSearch", "SiteTree_Live"."Sort", "SiteTree_Live"."HasBrokenFile", "SiteTree_Live"."HasBrokenLink", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."ReportClass"
ELSE "SiteTree_Live"."ReportClass" END
AS "ReportClass", "SiteTree_Live"."CanonicalLinkID", "SiteTree_Live"."FBImageID", "SiteTree_Live"."TwImageID", "SiteTree_Live"."ParentID", "SiteTree_Live"."ID",
CASE WHEN "SiteTree_Live"."ClassName" IS NOT NULL THEN "SiteTree_Live"."ClassName"
ELSE 'SilverStripe\\CMS\\Model\\SiteTree' END AS "RecordClassName", 'de_DE' AS "Locale", CASE WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN 'de_DE'
ELSE NULL END AS "SourceLocale"
FROM "SiteTree_Live" LEFT JOIN "SiteTree_Localised_Live" AS "SiteTree_Localised_de_DE" ON "SiteTree_Live"."ID" = "SiteTree_Localised_de_DE"."RecordID" AND "SiteTree_Localised_de_DE"."Locale" = ?
WHERE ("SiteTree_Live"."ID" = ?)
AND (("SiteTree_Localised_de_DE"."ID" IS NOT NULL))
ORDER BY "SiteTree_Live"."Sort" ASC
LIMIT 1
0.0001s
0038: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."BetterSiteTitle"
ELSE "SiteTree_Live"."BetterSiteTitle" END
AS "BetterSiteTitle", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."Keyword"
ELSE "SiteTree_Live"."Keyword" END
AS "Keyword", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."FeaturedKeyword"
ELSE "SiteTree_Live"."FeaturedKeyword" END
AS "FeaturedKeyword", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."KeywordQuestion"
ELSE "SiteTree_Live"."KeywordQuestion" END
AS "KeywordQuestion", "SiteTree_Live"."Follow", "SiteTree_Live"."FollowType", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."GenMetaDesc"
ELSE "SiteTree_Live"."GenMetaDesc" END
AS "GenMetaDesc", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."FBTitle"
ELSE "SiteTree_Live"."FBTitle" END
AS "FBTitle", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."FBDescription"
ELSE "SiteTree_Live"."FBDescription" END
AS "FBDescription", "SiteTree_Live"."FBType", "SiteTree_Live"."FBTypeOverride", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."TwTitle"
ELSE "SiteTree_Live"."TwTitle" END
AS "TwTitle", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."TwDescription"
ELSE "SiteTree_Live"."TwDescription" END
AS "TwDescription", "SiteTree_Live"."CanViewType", "SiteTree_Live"."CanEditType", "SiteTree_Live"."Version", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."URLSegment"
ELSE "SiteTree_Live"."URLSegment" END
AS "URLSegment", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."Title"
ELSE "SiteTree_Live"."Title" END
AS "Title", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."MenuTitle"
ELSE "SiteTree_Live"."MenuTitle" END
AS "MenuTitle", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."Content"
ELSE "SiteTree_Live"."Content" END
AS "Content", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."MetaDescription"
ELSE "SiteTree_Live"."MetaDescription" END
AS "MetaDescription", "SiteTree_Live"."ExtraMeta", "SiteTree_Live"."ShowInMenus", "SiteTree_Live"."ShowInSearch", "SiteTree_Live"."Sort", "SiteTree_Live"."HasBrokenFile", "SiteTree_Live"."HasBrokenLink", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."ReportClass"
ELSE "SiteTree_Live"."ReportClass" END
AS "ReportClass", "SiteTree_Live"."CanonicalLinkID", "SiteTree_Live"."FBImageID", "SiteTree_Live"."TwImageID", "SiteTree_Live"."ParentID", "SiteTree_Live"."ID",
CASE WHEN "SiteTree_Live"."ClassName" IS NOT NULL THEN "SiteTree_Live"."ClassName"
ELSE 'SilverStripe\\CMS\\Model\\SiteTree' END AS "RecordClassName", 'de_DE' AS "Locale", CASE WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN 'de_DE'
ELSE NULL END AS "SourceLocale"
FROM "SiteTree_Live" LEFT JOIN "SiteTree_Localised_Live" AS "SiteTree_Localised_de_DE" ON "SiteTree_Live"."ID" = "SiteTree_Localised_de_DE"."RecordID" AND "SiteTree_Localised_de_DE"."Locale" = ?
WHERE ("SiteTree_Live"."ID" = ?)
AND (("SiteTree_Localised_de_DE"."ID" IS NOT NULL))
ORDER BY "SiteTree_Live"."Sort" ASC
LIMIT 1
0.0001s
0039: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."BetterSiteTitle"
ELSE "SiteTree_Live"."BetterSiteTitle" END
AS "BetterSiteTitle", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."Keyword"
ELSE "SiteTree_Live"."Keyword" END
AS "Keyword", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."FeaturedKeyword"
ELSE "SiteTree_Live"."FeaturedKeyword" END
AS "FeaturedKeyword", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."KeywordQuestion"
ELSE "SiteTree_Live"."KeywordQuestion" END
AS "KeywordQuestion", "SiteTree_Live"."Follow", "SiteTree_Live"."FollowType", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."GenMetaDesc"
ELSE "SiteTree_Live"."GenMetaDesc" END
AS "GenMetaDesc", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."FBTitle"
ELSE "SiteTree_Live"."FBTitle" END
AS "FBTitle", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."FBDescription"
ELSE "SiteTree_Live"."FBDescription" END
AS "FBDescription", "SiteTree_Live"."FBType", "SiteTree_Live"."FBTypeOverride", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."TwTitle"
ELSE "SiteTree_Live"."TwTitle" END
AS "TwTitle", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."TwDescription"
ELSE "SiteTree_Live"."TwDescription" END
AS "TwDescription", "SiteTree_Live"."CanViewType", "SiteTree_Live"."CanEditType", "SiteTree_Live"."Version", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."URLSegment"
ELSE "SiteTree_Live"."URLSegment" END
AS "URLSegment", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."Title"
ELSE "SiteTree_Live"."Title" END
AS "Title", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."MenuTitle"
ELSE "SiteTree_Live"."MenuTitle" END
AS "MenuTitle", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."Content"
ELSE "SiteTree_Live"."Content" END
AS "Content", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."MetaDescription"
ELSE "SiteTree_Live"."MetaDescription" END
AS "MetaDescription", "SiteTree_Live"."ExtraMeta", "SiteTree_Live"."ShowInMenus", "SiteTree_Live"."ShowInSearch", "SiteTree_Live"."Sort", "SiteTree_Live"."HasBrokenFile", "SiteTree_Live"."HasBrokenLink", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."ReportClass"
ELSE "SiteTree_Live"."ReportClass" END
AS "ReportClass", "SiteTree_Live"."CanonicalLinkID", "SiteTree_Live"."FBImageID", "SiteTree_Live"."TwImageID", "SiteTree_Live"."ParentID", "SiteTree_Live"."ID",
CASE WHEN "SiteTree_Live"."ClassName" IS NOT NULL THEN "SiteTree_Live"."ClassName"
ELSE 'SilverStripe\\CMS\\Model\\SiteTree' END AS "RecordClassName", 'de_DE' AS "Locale", CASE WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN 'de_DE'
ELSE NULL END AS "SourceLocale"
FROM "SiteTree_Live" LEFT JOIN "SiteTree_Localised_Live" AS "SiteTree_Localised_de_DE" ON "SiteTree_Live"."ID" = "SiteTree_Localised_de_DE"."RecordID" AND "SiteTree_Localised_de_DE"."Locale" = ?
WHERE ("SiteTree_Live"."ID" = ?)
AND (("SiteTree_Localised_de_DE"."ID" IS NOT NULL))
ORDER BY "SiteTree_Live"."Sort" ASC
LIMIT 1
0.0001s
0040: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."BetterSiteTitle"
ELSE "SiteTree_Live"."BetterSiteTitle" END
AS "BetterSiteTitle", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."Keyword"
ELSE "SiteTree_Live"."Keyword" END
AS "Keyword", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."FeaturedKeyword"
ELSE "SiteTree_Live"."FeaturedKeyword" END
AS "FeaturedKeyword", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."KeywordQuestion"
ELSE "SiteTree_Live"."KeywordQuestion" END
AS "KeywordQuestion", "SiteTree_Live"."Follow", "SiteTree_Live"."FollowType", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."GenMetaDesc"
ELSE "SiteTree_Live"."GenMetaDesc" END
AS "GenMetaDesc", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."FBTitle"
ELSE "SiteTree_Live"."FBTitle" END
AS "FBTitle", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."FBDescription"
ELSE "SiteTree_Live"."FBDescription" END
AS "FBDescription", "SiteTree_Live"."FBType", "SiteTree_Live"."FBTypeOverride", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."TwTitle"
ELSE "SiteTree_Live"."TwTitle" END
AS "TwTitle", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."TwDescription"
ELSE "SiteTree_Live"."TwDescription" END
AS "TwDescription", "SiteTree_Live"."CanViewType", "SiteTree_Live"."CanEditType", "SiteTree_Live"."Version", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."URLSegment"
ELSE "SiteTree_Live"."URLSegment" END
AS "URLSegment", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."Title"
ELSE "SiteTree_Live"."Title" END
AS "Title", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."MenuTitle"
ELSE "SiteTree_Live"."MenuTitle" END
AS "MenuTitle", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."Content"
ELSE "SiteTree_Live"."Content" END
AS "Content", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."MetaDescription"
ELSE "SiteTree_Live"."MetaDescription" END
AS "MetaDescription", "SiteTree_Live"."ExtraMeta", "SiteTree_Live"."ShowInMenus", "SiteTree_Live"."ShowInSearch", "SiteTree_Live"."Sort", "SiteTree_Live"."HasBrokenFile", "SiteTree_Live"."HasBrokenLink", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."ReportClass"
ELSE "SiteTree_Live"."ReportClass" END
AS "ReportClass", "SiteTree_Live"."CanonicalLinkID", "SiteTree_Live"."FBImageID", "SiteTree_Live"."TwImageID", "SiteTree_Live"."ParentID", "SiteTree_Live"."ID",
CASE WHEN "SiteTree_Live"."ClassName" IS NOT NULL THEN "SiteTree_Live"."ClassName"
ELSE 'SilverStripe\\CMS\\Model\\SiteTree' END AS "RecordClassName", 'de_DE' AS "Locale", CASE WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN 'de_DE'
ELSE NULL END AS "SourceLocale"
FROM "SiteTree_Live" LEFT JOIN "SiteTree_Localised_Live" AS "SiteTree_Localised_de_DE" ON "SiteTree_Live"."ID" = "SiteTree_Localised_de_DE"."RecordID" AND "SiteTree_Localised_de_DE"."Locale" = ?
WHERE ("SiteTree_Live"."ID" = ?)
AND (("SiteTree_Localised_de_DE"."ID" IS NOT NULL))
ORDER BY "SiteTree_Live"."Sort" ASC
LIMIT 1
0.0001s
0041: SELECT DISTINCT "MenuSet"."ClassName", "MenuSet"."LastEdited", "MenuSet"."Created", "MenuSet"."Name", "MenuSet"."Description", "MenuSet"."Sort", "MenuSet"."ID",
CASE WHEN "MenuSet"."ClassName" IS NOT NULL THEN "MenuSet"."ClassName"
ELSE 'Heyday\\MenuManager\\MenuSet' END AS "RecordClassName"
FROM "MenuSet"
WHERE ("MenuSet"."Name" = ?)
ORDER BY "MenuSet"."Sort" ASC
LIMIT 1
0.0002s
0042: SELECT DISTINCT "MenuItem"."ClassName", "MenuItem"."LastEdited", "MenuItem"."Created", "MenuItem"."MenuTitle", "MenuItem"."Link", "MenuItem"."Sort", "MenuItem"."IsNewWindow", "MenuItem"."PageID", "MenuItem"."MenuSetID", "MenuItem"."ID",
CASE WHEN "MenuItem"."ClassName" IS NOT NULL THEN "MenuItem"."ClassName"
ELSE 'Heyday\\MenuManager\\MenuItem' END AS "RecordClassName"
FROM "MenuItem"
WHERE ("MenuItem"."MenuSetID" = ?)
ORDER BY "MenuItem"."Sort" ASC
0.0002s
0043: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."BetterSiteTitle"
ELSE "SiteTree_Live"."BetterSiteTitle" END
AS "BetterSiteTitle", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."Keyword"
ELSE "SiteTree_Live"."Keyword" END
AS "Keyword", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."FeaturedKeyword"
ELSE "SiteTree_Live"."FeaturedKeyword" END
AS "FeaturedKeyword", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."KeywordQuestion"
ELSE "SiteTree_Live"."KeywordQuestion" END
AS "KeywordQuestion", "SiteTree_Live"."Follow", "SiteTree_Live"."FollowType", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."GenMetaDesc"
ELSE "SiteTree_Live"."GenMetaDesc" END
AS "GenMetaDesc", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."FBTitle"
ELSE "SiteTree_Live"."FBTitle" END
AS "FBTitle", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."FBDescription"
ELSE "SiteTree_Live"."FBDescription" END
AS "FBDescription", "SiteTree_Live"."FBType", "SiteTree_Live"."FBTypeOverride", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."TwTitle"
ELSE "SiteTree_Live"."TwTitle" END
AS "TwTitle", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."TwDescription"
ELSE "SiteTree_Live"."TwDescription" END
AS "TwDescription", "SiteTree_Live"."CanViewType", "SiteTree_Live"."CanEditType", "SiteTree_Live"."Version", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."URLSegment"
ELSE "SiteTree_Live"."URLSegment" END
AS "URLSegment", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."Title"
ELSE "SiteTree_Live"."Title" END
AS "Title", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."MenuTitle"
ELSE "SiteTree_Live"."MenuTitle" END
AS "MenuTitle", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."Content"
ELSE "SiteTree_Live"."Content" END
AS "Content", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."MetaDescription"
ELSE "SiteTree_Live"."MetaDescription" END
AS "MetaDescription", "SiteTree_Live"."ExtraMeta", "SiteTree_Live"."ShowInMenus", "SiteTree_Live"."ShowInSearch", "SiteTree_Live"."Sort", "SiteTree_Live"."HasBrokenFile", "SiteTree_Live"."HasBrokenLink", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."ReportClass"
ELSE "SiteTree_Live"."ReportClass" END
AS "ReportClass", "SiteTree_Live"."CanonicalLinkID", "SiteTree_Live"."FBImageID", "SiteTree_Live"."TwImageID", "SiteTree_Live"."ParentID", "SiteTree_Live"."ID",
CASE WHEN "SiteTree_Live"."ClassName" IS NOT NULL THEN "SiteTree_Live"."ClassName"
ELSE 'SilverStripe\\CMS\\Model\\SiteTree' END AS "RecordClassName", 'de_DE' AS "Locale", CASE WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN 'de_DE'
ELSE NULL END AS "SourceLocale"
FROM "SiteTree_Live" LEFT JOIN "SiteTree_Localised_Live" AS "SiteTree_Localised_de_DE" ON "SiteTree_Live"."ID" = "SiteTree_Localised_de_DE"."RecordID" AND "SiteTree_Localised_de_DE"."Locale" = ?
WHERE ("SiteTree_Live"."ID" = ?)
AND (("SiteTree_Localised_de_DE"."ID" IS NOT NULL))
ORDER BY "SiteTree_Live"."Sort" ASC
LIMIT 1
0.0001s
0044: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."BetterSiteTitle"
ELSE "SiteTree_Live"."BetterSiteTitle" END
AS "BetterSiteTitle", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."Keyword"
ELSE "SiteTree_Live"."Keyword" END
AS "Keyword", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."FeaturedKeyword"
ELSE "SiteTree_Live"."FeaturedKeyword" END
AS "FeaturedKeyword", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."KeywordQuestion"
ELSE "SiteTree_Live"."KeywordQuestion" END
AS "KeywordQuestion", "SiteTree_Live"."Follow", "SiteTree_Live"."FollowType", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."GenMetaDesc"
ELSE "SiteTree_Live"."GenMetaDesc" END
AS "GenMetaDesc", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."FBTitle"
ELSE "SiteTree_Live"."FBTitle" END
AS "FBTitle", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."FBDescription"
ELSE "SiteTree_Live"."FBDescription" END
AS "FBDescription", "SiteTree_Live"."FBType", "SiteTree_Live"."FBTypeOverride", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."TwTitle"
ELSE "SiteTree_Live"."TwTitle" END
AS "TwTitle", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."TwDescription"
ELSE "SiteTree_Live"."TwDescription" END
AS "TwDescription", "SiteTree_Live"."CanViewType", "SiteTree_Live"."CanEditType", "SiteTree_Live"."Version", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."URLSegment"
ELSE "SiteTree_Live"."URLSegment" END
AS "URLSegment", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."Title"
ELSE "SiteTree_Live"."Title" END
AS "Title", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."MenuTitle"
ELSE "SiteTree_Live"."MenuTitle" END
AS "MenuTitle", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."Content"
ELSE "SiteTree_Live"."Content" END
AS "Content", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."MetaDescription"
ELSE "SiteTree_Live"."MetaDescription" END
AS "MetaDescription", "SiteTree_Live"."ExtraMeta", "SiteTree_Live"."ShowInMenus", "SiteTree_Live"."ShowInSearch", "SiteTree_Live"."Sort", "SiteTree_Live"."HasBrokenFile", "SiteTree_Live"."HasBrokenLink", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."ReportClass"
ELSE "SiteTree_Live"."ReportClass" END
AS "ReportClass", "SiteTree_Live"."CanonicalLinkID", "SiteTree_Live"."FBImageID", "SiteTree_Live"."TwImageID", "SiteTree_Live"."ParentID", "SiteTree_Live"."ID",
CASE WHEN "SiteTree_Live"."ClassName" IS NOT NULL THEN "SiteTree_Live"."ClassName"
ELSE 'SilverStripe\\CMS\\Model\\SiteTree' END AS "RecordClassName", 'de_DE' AS "Locale", CASE WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN 'de_DE'
ELSE NULL END AS "SourceLocale"
FROM "SiteTree_Live" LEFT JOIN "SiteTree_Localised_Live" AS "SiteTree_Localised_de_DE" ON "SiteTree_Live"."ID" = "SiteTree_Localised_de_DE"."RecordID" AND "SiteTree_Localised_de_DE"."Locale" = ?
WHERE ("SiteTree_Live"."ID" = ?)
AND (("SiteTree_Localised_de_DE"."ID" IS NOT NULL))
ORDER BY "SiteTree_Live"."Sort" ASC
LIMIT 1
0.0001s
0045: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."BetterSiteTitle"
ELSE "SiteTree_Live"."BetterSiteTitle" END
AS "BetterSiteTitle", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."Keyword"
ELSE "SiteTree_Live"."Keyword" END
AS "Keyword", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."FeaturedKeyword"
ELSE "SiteTree_Live"."FeaturedKeyword" END
AS "FeaturedKeyword", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."KeywordQuestion"
ELSE "SiteTree_Live"."KeywordQuestion" END
AS "KeywordQuestion", "SiteTree_Live"."Follow", "SiteTree_Live"."FollowType", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."GenMetaDesc"
ELSE "SiteTree_Live"."GenMetaDesc" END
AS "GenMetaDesc", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."FBTitle"
ELSE "SiteTree_Live"."FBTitle" END
AS "FBTitle", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."FBDescription"
ELSE "SiteTree_Live"."FBDescription" END
AS "FBDescription", "SiteTree_Live"."FBType", "SiteTree_Live"."FBTypeOverride", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."TwTitle"
ELSE "SiteTree_Live"."TwTitle" END
AS "TwTitle", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."TwDescription"
ELSE "SiteTree_Live"."TwDescription" END
AS "TwDescription", "SiteTree_Live"."CanViewType", "SiteTree_Live"."CanEditType", "SiteTree_Live"."Version", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."URLSegment"
ELSE "SiteTree_Live"."URLSegment" END
AS "URLSegment", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."Title"
ELSE "SiteTree_Live"."Title" END
AS "Title", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."MenuTitle"
ELSE "SiteTree_Live"."MenuTitle" END
AS "MenuTitle", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."Content"
ELSE "SiteTree_Live"."Content" END
AS "Content", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."MetaDescription"
ELSE "SiteTree_Live"."MetaDescription" END
AS "MetaDescription", "SiteTree_Live"."ExtraMeta", "SiteTree_Live"."ShowInMenus", "SiteTree_Live"."ShowInSearch", "SiteTree_Live"."Sort", "SiteTree_Live"."HasBrokenFile", "SiteTree_Live"."HasBrokenLink", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."ReportClass"
ELSE "SiteTree_Live"."ReportClass" END
AS "ReportClass", "SiteTree_Live"."CanonicalLinkID", "SiteTree_Live"."FBImageID", "SiteTree_Live"."TwImageID", "SiteTree_Live"."ParentID", "SiteTree_Live"."ID",
CASE WHEN "SiteTree_Live"."ClassName" IS NOT NULL THEN "SiteTree_Live"."ClassName"
ELSE 'SilverStripe\\CMS\\Model\\SiteTree' END AS "RecordClassName", 'de_DE' AS "Locale", CASE WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN 'de_DE'
ELSE NULL END AS "SourceLocale"
FROM "SiteTree_Live" LEFT JOIN "SiteTree_Localised_Live" AS "SiteTree_Localised_de_DE" ON "SiteTree_Live"."ID" = "SiteTree_Localised_de_DE"."RecordID" AND "SiteTree_Localised_de_DE"."Locale" = ?
WHERE ("SiteTree_Live"."ID" = ?)
AND (("SiteTree_Localised_de_DE"."ID" IS NOT NULL))
ORDER BY "SiteTree_Live"."Sort" ASC
LIMIT 1
0.0001s
0046: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."BetterSiteTitle"
ELSE "SiteTree_Live"."BetterSiteTitle" END
AS "BetterSiteTitle", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."Keyword"
ELSE "SiteTree_Live"."Keyword" END
AS "Keyword", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."FeaturedKeyword"
ELSE "SiteTree_Live"."FeaturedKeyword" END
AS "FeaturedKeyword", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."KeywordQuestion"
ELSE "SiteTree_Live"."KeywordQuestion" END
AS "KeywordQuestion", "SiteTree_Live"."Follow", "SiteTree_Live"."FollowType", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."GenMetaDesc"
ELSE "SiteTree_Live"."GenMetaDesc" END
AS "GenMetaDesc", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."FBTitle"
ELSE "SiteTree_Live"."FBTitle" END
AS "FBTitle", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."FBDescription"
ELSE "SiteTree_Live"."FBDescription" END
AS "FBDescription", "SiteTree_Live"."FBType", "SiteTree_Live"."FBTypeOverride", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."TwTitle"
ELSE "SiteTree_Live"."TwTitle" END
AS "TwTitle", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."TwDescription"
ELSE "SiteTree_Live"."TwDescription" END
AS "TwDescription", "SiteTree_Live"."CanViewType", "SiteTree_Live"."CanEditType", "SiteTree_Live"."Version", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."URLSegment"
ELSE "SiteTree_Live"."URLSegment" END
AS "URLSegment", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."Title"
ELSE "SiteTree_Live"."Title" END
AS "Title", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."MenuTitle"
ELSE "SiteTree_Live"."MenuTitle" END
AS "MenuTitle", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."Content"
ELSE "SiteTree_Live"."Content" END
AS "Content", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."MetaDescription"
ELSE "SiteTree_Live"."MetaDescription" END
AS "MetaDescription", "SiteTree_Live"."ExtraMeta", "SiteTree_Live"."ShowInMenus", "SiteTree_Live"."ShowInSearch", "SiteTree_Live"."Sort", "SiteTree_Live"."HasBrokenFile", "SiteTree_Live"."HasBrokenLink", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."ReportClass"
ELSE "SiteTree_Live"."ReportClass" END
AS "ReportClass", "SiteTree_Live"."CanonicalLinkID", "SiteTree_Live"."FBImageID", "SiteTree_Live"."TwImageID", "SiteTree_Live"."ParentID", "SiteTree_Live"."ID",
CASE WHEN "SiteTree_Live"."ClassName" IS NOT NULL THEN "SiteTree_Live"."ClassName"
ELSE 'SilverStripe\\CMS\\Model\\SiteTree' END AS "RecordClassName", 'de_DE' AS "Locale", CASE WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN 'de_DE'
ELSE NULL END AS "SourceLocale"
FROM "SiteTree_Live" LEFT JOIN "SiteTree_Localised_Live" AS "SiteTree_Localised_de_DE" ON "SiteTree_Live"."ID" = "SiteTree_Localised_de_DE"."RecordID" AND "SiteTree_Localised_de_DE"."Locale" = ?
WHERE ("SiteTree_Live"."ID" = ?)
AND (("SiteTree_Localised_de_DE"."ID" IS NOT NULL))
ORDER BY "SiteTree_Live"."Sort" ASC
LIMIT 1
0.0001s
0047: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", CASE WHEN "SiteTree_Live"."ClassName" IN ('Page', 'GeschichteKulturDialog\\App\\CityTourHolder', 'GeschichteKulturDialog\\App\\CityTourPage', 'GeschichteKulturDialog\\App\\HomePage', 'SilverStripe\\ErrorPage\\ErrorPage', 'SilverStripe\\CMS\\Model\\RedirectorPage', 'SilverStripe\\CMS\\Model\\VirtualPage', 'SilverStripe\\UserForms\\Model\\UserDefinedForm') THEN "Page_Live"."ElementalAreaID" WHEN "SiteTree_Live"."ClassName" IN ('GeschichteKulturDialog\\App\\CityTourPage') THEN "CityTourPage_Live"."ElementalAreaID" WHEN "SiteTree_Live"."ClassName" IN ('GeschichteKulturDialog\\App\\CityTourPage') THEN "CityTourPage_Live"."ElementalAreaID" ELSE NULL END AS "ElementalAreaID", CASE
WHEN "CityTourPage_Localised_de_DE"."ID" IS NOT NULL THEN "CityTourPage_Localised_de_DE"."Teaser"
ELSE "CityTourPage_Live"."Teaser" END
AS "Teaser", CASE
WHEN "CityTourPage_Localised_de_DE"."ID" IS NOT NULL THEN "CityTourPage_Localised_de_DE"."SubTitle"
ELSE "CityTourPage_Live"."SubTitle" END
AS "SubTitle", CASE
WHEN "CityTourPage_Localised_de_DE"."ID" IS NOT NULL THEN "CityTourPage_Localised_de_DE"."Price"
ELSE "CityTourPage_Live"."Price" END
AS "Price", CASE
WHEN "CityTourPage_Localised_de_DE"."ID" IS NOT NULL THEN "CityTourPage_Localised_de_DE"."Duration"
ELSE "CityTourPage_Live"."Duration" END
AS "Duration", CASE
WHEN "CityTourPage_Localised_de_DE"."ID" IS NOT NULL THEN "CityTourPage_Localised_de_DE"."Buchung"
ELSE "CityTourPage_Live"."Buchung" END
AS "Buchung", "CityTourPage_Live"."Higlight", "CityTourPage_Live"."ImageID", "CityTourPage_Live"."CityTourCategoryID", "SiteTree_Live"."ID",
CASE WHEN "SiteTree_Live"."ClassName" IS NOT NULL THEN "SiteTree_Live"."ClassName"
ELSE 'SilverStripe\\CMS\\Model\\SiteTree' END AS "RecordClassName", 'de_DE' AS "Locale", CASE WHEN "CityTourPage_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 "CityTourPage_Live" ON "CityTourPage_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 "CityTourPage_Localised_Live" AS "CityTourPage_Localised_de_DE" ON "CityTourPage_Live"."ID" = "CityTourPage_Localised_de_DE"."RecordID" AND "CityTourPage_Localised_de_DE"."Locale" = ?
WHERE ("SiteTree_Live"."ID" = ?)
AND ("SiteTree_Live"."ClassName" IN (?))
AND (("SiteTree_Localised_de_DE"."ID" IS NOT NULL))
AND (("SiteTree_Localised_de_DE"."ID" IS NOT NULL))
ORDER BY "SiteTree_Live"."Sort" ASC
LIMIT 1
0.0004s
0048: SELECT DISTINCT "File_Live"."ClassName", "File_Live"."LastEdited", "File_Live"."Created", "File_Live"."UserFormUpload", "File_Live"."Version", "File_Live"."CanViewType", "File_Live"."CanEditType", "File_Live"."Name", "File_Live"."Title", "File_Live"."ShowInSearch", "File_Live"."ParentID", "File_Live"."OwnerID", "File_Live"."FileHash", "File_Live"."FileFilename", "File_Live"."FileVariant", "Image_Live"."FocusPointX", "Image_Live"."FocusPointY", "Image_Live"."FocusPointWidth", "Image_Live"."FocusPointHeight", "File_Live"."ID",
CASE WHEN "File_Live"."ClassName" IS NOT NULL THEN "File_Live"."ClassName"
ELSE 'SilverStripe\\Assets\\File' END AS "RecordClassName"
FROM "File_Live" LEFT JOIN "Image_Live" ON "Image_Live"."ID" = "File_Live"."ID"
WHERE ("File_Live"."ID" = ?)
AND ("File_Live"."ClassName" IN (?))
ORDER BY "File_Live"."Name" ASC
LIMIT 1
0.0003s
0049: SELECT DISTINCT "ElementalArea_Live"."ClassName", "ElementalArea_Live"."LastEdited", "ElementalArea_Live"."Created", "ElementalArea_Live"."Version", "ElementalArea_Live"."OwnerClassName", "ElementalArea_Live"."ID",
CASE WHEN "ElementalArea_Live"."ClassName" IS NOT NULL THEN "ElementalArea_Live"."ClassName"
ELSE 'DNADesign\\Elemental\\Models\\ElementalArea' END AS "RecordClassName"
FROM "ElementalArea_Live"
WHERE ("ElementalArea_Live"."ID" = ?)
LIMIT 1
0.0002s
0050: SELECT DISTINCT "Element_Live"."ClassName", "Element_Live"."LastEdited", "Element_Live"."Created", CASE
WHEN "Element_Localised_de_DE"."ID" IS NOT NULL THEN "Element_Localised_de_DE"."Title"
ELSE "Element_Live"."Title" END
AS "Title", "Element_Live"."ExtraCSSClass", CASE
WHEN "Element_Localised_de_DE"."ID" IS NOT NULL THEN "Element_Localised_de_DE"."NavigationName"
ELSE "Element_Live"."NavigationName" END
AS "NavigationName", "Element_Live"."NavigationLink", "Element_Live"."SetNavigation", "Element_Live"."Version", "Element_Live"."ShowTitle", "Element_Live"."Sort", "Element_Live"."ExtraClass", "Element_Live"."Style", "Element_Live"."ParentID", "Element_Live"."ID",
CASE WHEN "Element_Live"."ClassName" IS NOT NULL THEN "Element_Live"."ClassName"
ELSE 'DNADesign\\Elemental\\Models\\BaseElement' END AS "RecordClassName", 'de_DE' AS "Locale", CASE WHEN "Element_Localised_de_DE"."ID" IS NOT NULL THEN 'de_DE'
ELSE NULL END AS "SourceLocale"
FROM "Element_Live" LEFT JOIN "Element_Localised_Live" 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_de_DE"."ID" IS NOT NULL))
ORDER BY "Element_Live"."Sort" ASC
0.0003s
0051: SELECT DISTINCT "ElementalArea_Live"."ClassName", "ElementalArea_Live"."LastEdited", "ElementalArea_Live"."Created", "ElementalArea_Live"."Version", "ElementalArea_Live"."OwnerClassName", "ElementalArea_Live"."ID",
CASE WHEN "ElementalArea_Live"."ClassName" IS NOT NULL THEN "ElementalArea_Live"."ClassName"
ELSE 'DNADesign\\Elemental\\Models\\ElementalArea' END AS "RecordClassName"
FROM "ElementalArea_Live"
WHERE ("ElementalArea_Live"."ID" = ?)
LIMIT 1
0.0001s
0052: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."BetterSiteTitle"
ELSE "SiteTree_Live"."BetterSiteTitle" END
AS "BetterSiteTitle", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."Keyword"
ELSE "SiteTree_Live"."Keyword" END
AS "Keyword", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."FeaturedKeyword"
ELSE "SiteTree_Live"."FeaturedKeyword" END
AS "FeaturedKeyword", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."KeywordQuestion"
ELSE "SiteTree_Live"."KeywordQuestion" END
AS "KeywordQuestion", "SiteTree_Live"."Follow", "SiteTree_Live"."FollowType", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."GenMetaDesc"
ELSE "SiteTree_Live"."GenMetaDesc" END
AS "GenMetaDesc", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."FBTitle"
ELSE "SiteTree_Live"."FBTitle" END
AS "FBTitle", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."FBDescription"
ELSE "SiteTree_Live"."FBDescription" END
AS "FBDescription", "SiteTree_Live"."FBType", "SiteTree_Live"."FBTypeOverride", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."TwTitle"
ELSE "SiteTree_Live"."TwTitle" END
AS "TwTitle", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."TwDescription"
ELSE "SiteTree_Live"."TwDescription" END
AS "TwDescription", "SiteTree_Live"."CanViewType", "SiteTree_Live"."CanEditType", "SiteTree_Live"."Version", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."URLSegment"
ELSE "SiteTree_Live"."URLSegment" END
AS "URLSegment", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."Title"
ELSE "SiteTree_Live"."Title" END
AS "Title", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."MenuTitle"
ELSE "SiteTree_Live"."MenuTitle" END
AS "MenuTitle", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."Content"
ELSE "SiteTree_Live"."Content" END
AS "Content", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."MetaDescription"
ELSE "SiteTree_Live"."MetaDescription" END
AS "MetaDescription", "SiteTree_Live"."ExtraMeta", "SiteTree_Live"."ShowInMenus", "SiteTree_Live"."ShowInSearch", "SiteTree_Live"."Sort", "SiteTree_Live"."HasBrokenFile", "SiteTree_Live"."HasBrokenLink", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."ReportClass"
ELSE "SiteTree_Live"."ReportClass" END
AS "ReportClass", "SiteTree_Live"."CanonicalLinkID", "SiteTree_Live"."FBImageID", "SiteTree_Live"."TwImageID", "SiteTree_Live"."ParentID", CASE WHEN "SiteTree_Live"."ClassName" IN ('Page', 'GeschichteKulturDialog\\App\\CityTourHolder', 'GeschichteKulturDialog\\App\\CityTourPage', 'GeschichteKulturDialog\\App\\HomePage', 'SilverStripe\\ErrorPage\\ErrorPage', 'SilverStripe\\CMS\\Model\\RedirectorPage', 'SilverStripe\\CMS\\Model\\VirtualPage', 'SilverStripe\\UserForms\\Model\\UserDefinedForm') THEN "Page_Live"."ElementalAreaID" WHEN "SiteTree_Live"."ClassName" IN ('GeschichteKulturDialog\\App\\CityTourPage') THEN "CityTourPage_Live"."ElementalAreaID" ELSE NULL END AS "ElementalAreaID", CASE
WHEN "CityTourPage_Localised_de_DE"."ID" IS NOT NULL THEN "CityTourPage_Localised_de_DE"."Teaser"
ELSE "CityTourPage_Live"."Teaser" END
AS "Teaser", CASE
WHEN "CityTourPage_Localised_de_DE"."ID" IS NOT NULL THEN "CityTourPage_Localised_de_DE"."SubTitle"
ELSE "CityTourPage_Live"."SubTitle" END
AS "SubTitle", CASE
WHEN "CityTourPage_Localised_de_DE"."ID" IS NOT NULL THEN "CityTourPage_Localised_de_DE"."Price"
ELSE "CityTourPage_Live"."Price" END
AS "Price", CASE
WHEN "CityTourPage_Localised_de_DE"."ID" IS NOT NULL THEN "CityTourPage_Localised_de_DE"."Duration"
ELSE "CityTourPage_Live"."Duration" END
AS "Duration", CASE
WHEN "CityTourPage_Localised_de_DE"."ID" IS NOT NULL THEN "CityTourPage_Localised_de_DE"."Buchung"
ELSE "CityTourPage_Live"."Buchung" END
AS "Buchung", "CityTourPage_Live"."Higlight", "CityTourPage_Live"."ImageID", "CityTourPage_Live"."CityTourCategoryID", "SiteTree_Live"."ID",
CASE WHEN "SiteTree_Live"."ClassName" IS NOT NULL THEN "SiteTree_Live"."ClassName"
ELSE 'SilverStripe\\CMS\\Model\\SiteTree' END AS "RecordClassName", 'de_DE' AS "Locale", CASE WHEN "CityTourPage_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 "CityTourPage_Live" ON "CityTourPage_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 "CityTourPage_Localised_Live" AS "CityTourPage_Localised_de_DE" ON "CityTourPage_Live"."ID" = "CityTourPage_Localised_de_DE"."RecordID" AND "CityTourPage_Localised_de_DE"."Locale" = ?
WHERE ("CityTourPage_Live"."ElementalAreaID" = ?)
AND ("SiteTree_Live"."ClassName" = ?)
AND ("SiteTree_Live"."ClassName" IN (?))
AND (("SiteTree_Localised_de_DE"."ID" IS NOT NULL))
AND (("SiteTree_Localised_de_DE"."ID" IS NOT NULL))
ORDER BY "SiteTree_Live"."Sort" ASC
LIMIT 1
0.0005s
0053: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."BetterSiteTitle"
ELSE "SiteTree_Live"."BetterSiteTitle" END
AS "BetterSiteTitle", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."Keyword"
ELSE "SiteTree_Live"."Keyword" END
AS "Keyword", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."FeaturedKeyword"
ELSE "SiteTree_Live"."FeaturedKeyword" END
AS "FeaturedKeyword", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."KeywordQuestion"
ELSE "SiteTree_Live"."KeywordQuestion" END
AS "KeywordQuestion", "SiteTree_Live"."Follow", "SiteTree_Live"."FollowType", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."GenMetaDesc"
ELSE "SiteTree_Live"."GenMetaDesc" END
AS "GenMetaDesc", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."FBTitle"
ELSE "SiteTree_Live"."FBTitle" END
AS "FBTitle", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."FBDescription"
ELSE "SiteTree_Live"."FBDescription" END
AS "FBDescription", "SiteTree_Live"."FBType", "SiteTree_Live"."FBTypeOverride", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."TwTitle"
ELSE "SiteTree_Live"."TwTitle" END
AS "TwTitle", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."TwDescription"
ELSE "SiteTree_Live"."TwDescription" END
AS "TwDescription", "SiteTree_Live"."CanViewType", "SiteTree_Live"."CanEditType", "SiteTree_Live"."Version", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."URLSegment"
ELSE "SiteTree_Live"."URLSegment" END
AS "URLSegment", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."Title"
ELSE "SiteTree_Live"."Title" END
AS "Title", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."MenuTitle"
ELSE "SiteTree_Live"."MenuTitle" END
AS "MenuTitle", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."Content"
ELSE "SiteTree_Live"."Content" END
AS "Content", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."MetaDescription"
ELSE "SiteTree_Live"."MetaDescription" END
AS "MetaDescription", "SiteTree_Live"."ExtraMeta", "SiteTree_Live"."ShowInMenus", "SiteTree_Live"."ShowInSearch", "SiteTree_Live"."Sort", "SiteTree_Live"."HasBrokenFile", "SiteTree_Live"."HasBrokenLink", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."ReportClass"
ELSE "SiteTree_Live"."ReportClass" END
AS "ReportClass", "SiteTree_Live"."CanonicalLinkID", "SiteTree_Live"."FBImageID", "SiteTree_Live"."TwImageID", "SiteTree_Live"."ParentID", "SiteTree_Live"."ID",
CASE WHEN "SiteTree_Live"."ClassName" IS NOT NULL THEN "SiteTree_Live"."ClassName"
ELSE 'SilverStripe\\CMS\\Model\\SiteTree' END AS "RecordClassName", 'de_DE' AS "Locale", CASE WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN 'de_DE'
ELSE NULL END AS "SourceLocale"
FROM "SiteTree_Live" LEFT JOIN "SiteTree_Localised_Live" AS "SiteTree_Localised_de_DE" ON "SiteTree_Live"."ID" = "SiteTree_Localised_de_DE"."RecordID" AND "SiteTree_Localised_de_DE"."Locale" = ?
WHERE ("SiteTree_Live"."ID" = ?)
AND (("SiteTree_Localised_de_DE"."ID" IS NOT NULL))
ORDER BY "SiteTree_Live"."Sort" ASC
LIMIT 1
0.0001s
0054: SELECT DISTINCT "ElementalArea_Live"."ClassName", "ElementalArea_Live"."LastEdited", "ElementalArea_Live"."Created", "ElementalArea_Live"."Version", "ElementalArea_Live"."OwnerClassName", "ElementalArea_Live"."ID",
CASE WHEN "ElementalArea_Live"."ClassName" IS NOT NULL THEN "ElementalArea_Live"."ClassName"
ELSE 'DNADesign\\Elemental\\Models\\ElementalArea' END AS "RecordClassName"
FROM "ElementalArea_Live"
WHERE ("ElementalArea_Live"."ID" = ?)
LIMIT 1
0.0001s
0055: SELECT DISTINCT "Element_Live"."ClassName", "Element_Live"."LastEdited", "Element_Live"."Created", CASE
WHEN "ElementText_Localised_de_DE"."ID" IS NOT NULL THEN "ElementText_Localised_de_DE"."Content"
ELSE "ElementText_Live"."Content" END
AS "Content", "Element_Live"."ID",
CASE WHEN "Element_Live"."ClassName" IS NOT NULL THEN "Element_Live"."ClassName"
ELSE 'DNADesign\\Elemental\\Models\\BaseElement' END AS "RecordClassName", 'de_DE' AS "Locale", CASE WHEN "ElementText_Localised_de_DE"."ID" IS NOT NULL THEN 'de_DE'
ELSE NULL END AS "SourceLocale", "Element_Live"."Sort"
FROM "Element_Live" LEFT JOIN "ElementText_Live" ON "ElementText_Live"."ID" = "Element_Live"."ID" LEFT JOIN "Element_Localised_Live" AS "Element_Localised_de_DE" ON "Element_Live"."ID" = "Element_Localised_de_DE"."RecordID" AND "Element_Localised_de_DE"."Locale" = ? LEFT JOIN "ElementText_Localised_Live" AS "ElementText_Localised_de_DE" ON "ElementText_Live"."ID" = "ElementText_Localised_de_DE"."RecordID" AND "ElementText_Localised_de_DE"."Locale" = ?
WHERE ("Element_Live"."ID" = ?)
AND ("Element_Live"."ClassName" IN (?))
AND (("Element_Localised_de_DE"."ID" IS NOT NULL))
ORDER BY "Element_Live"."Sort" ASC
LIMIT 1
0.0003s
0056: SELECT DISTINCT "Element_Live"."ClassName", "Element_Live"."LastEdited", "Element_Live"."Created", "ElementImage_Live"."ImageID", "Element_Live"."ID",
CASE WHEN "Element_Live"."ClassName" IS NOT NULL THEN "Element_Live"."ClassName"
ELSE 'DNADesign\\Elemental\\Models\\BaseElement' END AS "RecordClassName", 'de_DE' AS "Locale", CASE 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 "ElementImage_Live" ON "ElementImage_Live"."ID" = "Element_Live"."ID" LEFT JOIN "Element_Localised_Live" 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_de_DE"."ID" IS NOT NULL))
ORDER BY "Element_Live"."Sort" ASC
LIMIT 1
0.0002s
0057: SELECT DISTINCT "File_Live"."ClassName", "File_Live"."LastEdited", "File_Live"."Created", "File_Live"."UserFormUpload", "File_Live"."Version", "File_Live"."CanViewType", "File_Live"."CanEditType", "File_Live"."Name", "File_Live"."Title", "File_Live"."ShowInSearch", "File_Live"."ParentID", "File_Live"."OwnerID", "File_Live"."FileHash", "File_Live"."FileFilename", "File_Live"."FileVariant", "Image_Live"."FocusPointX", "Image_Live"."FocusPointY", "Image_Live"."FocusPointWidth", "Image_Live"."FocusPointHeight", "File_Live"."ID",
CASE WHEN "File_Live"."ClassName" IS NOT NULL THEN "File_Live"."ClassName"
ELSE 'SilverStripe\\Assets\\File' END AS "RecordClassName"
FROM "File_Live" LEFT JOIN "Image_Live" ON "Image_Live"."ID" = "File_Live"."ID"
WHERE ("File_Live"."ID" = ?)
AND ("File_Live"."ClassName" IN (?))
ORDER BY "File_Live"."Name" ASC
LIMIT 1
0.0001s
0058: SELECT DISTINCT "Element_Live"."ClassName", "Element_Live"."LastEdited", "Element_Live"."Created", CASE
WHEN "ElementText_Localised_de_DE"."ID" IS NOT NULL THEN "ElementText_Localised_de_DE"."Content"
ELSE "ElementText_Live"."Content" END
AS "Content", "Element_Live"."ID",
CASE WHEN "Element_Live"."ClassName" IS NOT NULL THEN "Element_Live"."ClassName"
ELSE 'DNADesign\\Elemental\\Models\\BaseElement' END AS "RecordClassName", 'de_DE' AS "Locale", CASE WHEN "ElementText_Localised_de_DE"."ID" IS NOT NULL THEN 'de_DE'
ELSE NULL END AS "SourceLocale", "Element_Live"."Sort"
FROM "Element_Live" LEFT JOIN "ElementText_Live" ON "ElementText_Live"."ID" = "Element_Live"."ID" LEFT JOIN "Element_Localised_Live" AS "Element_Localised_de_DE" ON "Element_Live"."ID" = "Element_Localised_de_DE"."RecordID" AND "Element_Localised_de_DE"."Locale" = ? LEFT JOIN "ElementText_Localised_Live" AS "ElementText_Localised_de_DE" ON "ElementText_Live"."ID" = "ElementText_Localised_de_DE"."RecordID" AND "ElementText_Localised_de_DE"."Locale" = ?
WHERE ("Element_Live"."ID" = ?)
AND ("Element_Live"."ClassName" IN (?))
AND (("Element_Localised_de_DE"."ID" IS NOT NULL))
ORDER BY "Element_Live"."Sort" ASC
LIMIT 1
0.0001s
0059: SELECT DISTINCT "Element_Live"."ClassName", "Element_Live"."LastEdited", "Element_Live"."Created", "ElementImage_Live"."ImageID", "Element_Live"."ID",
CASE WHEN "Element_Live"."ClassName" IS NOT NULL THEN "Element_Live"."ClassName"
ELSE 'DNADesign\\Elemental\\Models\\BaseElement' END AS "RecordClassName", 'de_DE' AS "Locale", CASE 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 "ElementImage_Live" ON "ElementImage_Live"."ID" = "Element_Live"."ID" LEFT JOIN "Element_Localised_Live" 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_de_DE"."ID" IS NOT NULL))
ORDER BY "Element_Live"."Sort" ASC
LIMIT 1
0.0001s
0060: SELECT DISTINCT "Element_Live"."ClassName", "Element_Live"."LastEdited", "Element_Live"."Created", CASE
WHEN "ElementText_Localised_de_DE"."ID" IS NOT NULL THEN "ElementText_Localised_de_DE"."Content"
ELSE "ElementText_Live"."Content" END
AS "Content", "Element_Live"."ID",
CASE WHEN "Element_Live"."ClassName" IS NOT NULL THEN "Element_Live"."ClassName"
ELSE 'DNADesign\\Elemental\\Models\\BaseElement' END AS "RecordClassName", 'de_DE' AS "Locale", CASE WHEN "ElementText_Localised_de_DE"."ID" IS NOT NULL THEN 'de_DE'
ELSE NULL END AS "SourceLocale", "Element_Live"."Sort"
FROM "Element_Live" LEFT JOIN "ElementText_Live" ON "ElementText_Live"."ID" = "Element_Live"."ID" LEFT JOIN "Element_Localised_Live" AS "Element_Localised_de_DE" ON "Element_Live"."ID" = "Element_Localised_de_DE"."RecordID" AND "Element_Localised_de_DE"."Locale" = ? LEFT JOIN "ElementText_Localised_Live" AS "ElementText_Localised_de_DE" ON "ElementText_Live"."ID" = "ElementText_Localised_de_DE"."RecordID" AND "ElementText_Localised_de_DE"."Locale" = ?
WHERE ("Element_Live"."ID" = ?)
AND ("Element_Live"."ClassName" IN (?))
AND (("Element_Localised_de_DE"."ID" IS NOT NULL))
ORDER BY "Element_Live"."Sort" ASC
LIMIT 1
0.0001s
0061: SELECT DISTINCT "Element_Live"."ClassName", "Element_Live"."LastEdited", "Element_Live"."Created", "ElementImage_Live"."ImageID", "Element_Live"."ID",
CASE WHEN "Element_Live"."ClassName" IS NOT NULL THEN "Element_Live"."ClassName"
ELSE 'DNADesign\\Elemental\\Models\\BaseElement' END AS "RecordClassName", 'de_DE' AS "Locale", CASE 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 "ElementImage_Live" ON "ElementImage_Live"."ID" = "Element_Live"."ID" LEFT JOIN "Element_Localised_Live" 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_de_DE"."ID" IS NOT NULL))
ORDER BY "Element_Live"."Sort" ASC
LIMIT 1
0.0001s
0062: SELECT DISTINCT "Element_Live"."ClassName", "Element_Live"."LastEdited", "Element_Live"."Created", CASE
WHEN "ElementText_Localised_de_DE"."ID" IS NOT NULL THEN "ElementText_Localised_de_DE"."Content"
ELSE "ElementText_Live"."Content" END
AS "Content", "Element_Live"."ID",
CASE WHEN "Element_Live"."ClassName" IS NOT NULL THEN "Element_Live"."ClassName"
ELSE 'DNADesign\\Elemental\\Models\\BaseElement' END AS "RecordClassName", 'de_DE' AS "Locale", CASE WHEN "ElementText_Localised_de_DE"."ID" IS NOT NULL THEN 'de_DE'
ELSE NULL END AS "SourceLocale", "Element_Live"."Sort"
FROM "Element_Live" LEFT JOIN "ElementText_Live" ON "ElementText_Live"."ID" = "Element_Live"."ID" LEFT JOIN "Element_Localised_Live" AS "Element_Localised_de_DE" ON "Element_Live"."ID" = "Element_Localised_de_DE"."RecordID" AND "Element_Localised_de_DE"."Locale" = ? LEFT JOIN "ElementText_Localised_Live" AS "ElementText_Localised_de_DE" ON "ElementText_Live"."ID" = "ElementText_Localised_de_DE"."RecordID" AND "ElementText_Localised_de_DE"."Locale" = ?
WHERE ("Element_Live"."ID" = ?)
AND ("Element_Live"."ClassName" IN (?))
AND (("Element_Localised_de_DE"."ID" IS NOT NULL))
ORDER BY "Element_Live"."Sort" ASC
LIMIT 1
0.0001s
0063: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."BetterSiteTitle"
ELSE "SiteTree_Live"."BetterSiteTitle" END
AS "BetterSiteTitle", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."Keyword"
ELSE "SiteTree_Live"."Keyword" END
AS "Keyword", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."FeaturedKeyword"
ELSE "SiteTree_Live"."FeaturedKeyword" END
AS "FeaturedKeyword", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."KeywordQuestion"
ELSE "SiteTree_Live"."KeywordQuestion" END
AS "KeywordQuestion", "SiteTree_Live"."Follow", "SiteTree_Live"."FollowType", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."GenMetaDesc"
ELSE "SiteTree_Live"."GenMetaDesc" END
AS "GenMetaDesc", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."FBTitle"
ELSE "SiteTree_Live"."FBTitle" END
AS "FBTitle", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."FBDescription"
ELSE "SiteTree_Live"."FBDescription" END
AS "FBDescription", "SiteTree_Live"."FBType", "SiteTree_Live"."FBTypeOverride", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."TwTitle"
ELSE "SiteTree_Live"."TwTitle" END
AS "TwTitle", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."TwDescription"
ELSE "SiteTree_Live"."TwDescription" END
AS "TwDescription", "SiteTree_Live"."CanViewType", "SiteTree_Live"."CanEditType", "SiteTree_Live"."Version", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."URLSegment"
ELSE "SiteTree_Live"."URLSegment" END
AS "URLSegment", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."Title"
ELSE "SiteTree_Live"."Title" END
AS "Title", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."MenuTitle"
ELSE "SiteTree_Live"."MenuTitle" END
AS "MenuTitle", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."Content"
ELSE "SiteTree_Live"."Content" END
AS "Content", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."MetaDescription"
ELSE "SiteTree_Live"."MetaDescription" END
AS "MetaDescription", "SiteTree_Live"."ExtraMeta", "SiteTree_Live"."ShowInMenus", "SiteTree_Live"."ShowInSearch", "SiteTree_Live"."Sort", "SiteTree_Live"."HasBrokenFile", "SiteTree_Live"."HasBrokenLink", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."ReportClass"
ELSE "SiteTree_Live"."ReportClass" END
AS "ReportClass", "SiteTree_Live"."CanonicalLinkID", "SiteTree_Live"."FBImageID", "SiteTree_Live"."TwImageID", "SiteTree_Live"."ParentID", "SiteTree_Live"."ID",
CASE WHEN "SiteTree_Live"."ClassName" IS NOT NULL THEN "SiteTree_Live"."ClassName"
ELSE 'SilverStripe\\CMS\\Model\\SiteTree' END AS "RecordClassName", 'de_DE' AS "Locale", CASE WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN 'de_DE'
ELSE NULL END AS "SourceLocale"
FROM "SiteTree_Live" LEFT JOIN "SiteTree_Localised_Live" AS "SiteTree_Localised_de_DE" ON "SiteTree_Live"."ID" = "SiteTree_Localised_de_DE"."RecordID" AND "SiteTree_Localised_de_DE"."Locale" = ?
WHERE ("SiteTree_Live"."ID" = ?)
AND (("SiteTree_Localised_de_DE"."ID" IS NOT NULL))
ORDER BY "SiteTree_Live"."Sort" ASC
LIMIT 1
0.0001s
0064: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."BetterSiteTitle"
ELSE "SiteTree_Live"."BetterSiteTitle" END
AS "BetterSiteTitle", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."Keyword"
ELSE "SiteTree_Live"."Keyword" END
AS "Keyword", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."FeaturedKeyword"
ELSE "SiteTree_Live"."FeaturedKeyword" END
AS "FeaturedKeyword", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."KeywordQuestion"
ELSE "SiteTree_Live"."KeywordQuestion" END
AS "KeywordQuestion", "SiteTree_Live"."Follow", "SiteTree_Live"."FollowType", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."GenMetaDesc"
ELSE "SiteTree_Live"."GenMetaDesc" END
AS "GenMetaDesc", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."FBTitle"
ELSE "SiteTree_Live"."FBTitle" END
AS "FBTitle", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."FBDescription"
ELSE "SiteTree_Live"."FBDescription" END
AS "FBDescription", "SiteTree_Live"."FBType", "SiteTree_Live"."FBTypeOverride", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."TwTitle"
ELSE "SiteTree_Live"."TwTitle" END
AS "TwTitle", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."TwDescription"
ELSE "SiteTree_Live"."TwDescription" END
AS "TwDescription", "SiteTree_Live"."CanViewType", "SiteTree_Live"."CanEditType", "SiteTree_Live"."Version", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."URLSegment"
ELSE "SiteTree_Live"."URLSegment" END
AS "URLSegment", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."Title"
ELSE "SiteTree_Live"."Title" END
AS "Title", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."MenuTitle"
ELSE "SiteTree_Live"."MenuTitle" END
AS "MenuTitle", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."Content"
ELSE "SiteTree_Live"."Content" END
AS "Content", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."MetaDescription"
ELSE "SiteTree_Live"."MetaDescription" END
AS "MetaDescription", "SiteTree_Live"."ExtraMeta", "SiteTree_Live"."ShowInMenus", "SiteTree_Live"."ShowInSearch", "SiteTree_Live"."Sort", "SiteTree_Live"."HasBrokenFile", "SiteTree_Live"."HasBrokenLink", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."ReportClass"
ELSE "SiteTree_Live"."ReportClass" END
AS "ReportClass", "SiteTree_Live"."CanonicalLinkID", "SiteTree_Live"."FBImageID", "SiteTree_Live"."TwImageID", "SiteTree_Live"."ParentID", "SiteTree_Live"."ID",
CASE WHEN "SiteTree_Live"."ClassName" IS NOT NULL THEN "SiteTree_Live"."ClassName"
ELSE 'SilverStripe\\CMS\\Model\\SiteTree' END AS "RecordClassName", 'de_DE' AS "Locale", CASE WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN 'de_DE'
ELSE NULL END AS "SourceLocale"
FROM "SiteTree_Live" LEFT JOIN "SiteTree_Localised_Live" AS "SiteTree_Localised_de_DE" ON "SiteTree_Live"."ID" = "SiteTree_Localised_de_DE"."RecordID" AND "SiteTree_Localised_de_DE"."Locale" = ?
WHERE ("SiteTree_Live"."ID" = ?)
AND (("SiteTree_Localised_de_DE"."ID" IS NOT NULL))
ORDER BY "SiteTree_Live"."Sort" ASC
LIMIT 1
0.0001s
0065: SELECT DISTINCT "File_Live"."ClassName", "File_Live"."LastEdited", "File_Live"."Created", "File_Live"."UserFormUpload", "File_Live"."Version", "File_Live"."CanViewType", "File_Live"."CanEditType", "File_Live"."Name", "File_Live"."Title", "File_Live"."ShowInSearch", "File_Live"."ParentID", "File_Live"."OwnerID", "File_Live"."FileHash", "File_Live"."FileFilename", "File_Live"."FileVariant", "File_Live"."ID",
CASE WHEN "File_Live"."ClassName" IS NOT NULL THEN "File_Live"."ClassName"
ELSE 'SilverStripe\\Assets\\File' END AS "RecordClassName"
FROM "File_Live"
WHERE ("File_Live"."ID" = ?)
ORDER BY "File_Live"."Name" ASC
LIMIT 1
0.0002s
0066: SELECT "Version" FROM "SiteTree" WHERE "ID" = ?
0.0002s
0067: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."BetterSiteTitle"
ELSE "SiteTree_Live"."BetterSiteTitle" END
AS "BetterSiteTitle", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."Keyword"
ELSE "SiteTree_Live"."Keyword" END
AS "Keyword", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."FeaturedKeyword"
ELSE "SiteTree_Live"."FeaturedKeyword" END
AS "FeaturedKeyword", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."KeywordQuestion"
ELSE "SiteTree_Live"."KeywordQuestion" END
AS "KeywordQuestion", "SiteTree_Live"."Follow", "SiteTree_Live"."FollowType", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."GenMetaDesc"
ELSE "SiteTree_Live"."GenMetaDesc" END
AS "GenMetaDesc", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."FBTitle"
ELSE "SiteTree_Live"."FBTitle" END
AS "FBTitle", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."FBDescription"
ELSE "SiteTree_Live"."FBDescription" END
AS "FBDescription", "SiteTree_Live"."FBType", "SiteTree_Live"."FBTypeOverride", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."TwTitle"
ELSE "SiteTree_Live"."TwTitle" END
AS "TwTitle", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."TwDescription"
ELSE "SiteTree_Live"."TwDescription" END
AS "TwDescription", "SiteTree_Live"."CanViewType", "SiteTree_Live"."CanEditType", "SiteTree_Live"."Version", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."URLSegment"
ELSE "SiteTree_Live"."URLSegment" END
AS "URLSegment", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."Title"
ELSE "SiteTree_Live"."Title" END
AS "Title", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."MenuTitle"
ELSE "SiteTree_Live"."MenuTitle" END
AS "MenuTitle", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."Content"
ELSE "SiteTree_Live"."Content" END
AS "Content", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."MetaDescription"
ELSE "SiteTree_Live"."MetaDescription" END
AS "MetaDescription", "SiteTree_Live"."ExtraMeta", "SiteTree_Live"."ShowInMenus", "SiteTree_Live"."ShowInSearch", "SiteTree_Live"."Sort", "SiteTree_Live"."HasBrokenFile", "SiteTree_Live"."HasBrokenLink", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."ReportClass"
ELSE "SiteTree_Live"."ReportClass" END
AS "ReportClass", "SiteTree_Live"."CanonicalLinkID", "SiteTree_Live"."FBImageID", "SiteTree_Live"."TwImageID", "SiteTree_Live"."ParentID", "SiteTree_Live"."ID",
CASE WHEN "SiteTree_Live"."ClassName" IS NOT NULL THEN "SiteTree_Live"."ClassName"
ELSE 'SilverStripe\\CMS\\Model\\SiteTree' END AS "RecordClassName", 'de_DE' AS "Locale", CASE WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN 'de_DE'
ELSE NULL END AS "SourceLocale"
FROM "SiteTree_Live" LEFT JOIN "SiteTree_Localised_Live" AS "SiteTree_Localised_de_DE" ON "SiteTree_Live"."ID" = "SiteTree_Localised_de_DE"."RecordID" AND "SiteTree_Localised_de_DE"."Locale" = ?
WHERE ("SiteTree_Live"."ID" = ?)
AND (("SiteTree_Localised_de_DE"."ID" IS NOT NULL))
ORDER BY "SiteTree_Live"."Sort" ASC
LIMIT 1
0.0001s
0068: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."BetterSiteTitle"
ELSE "SiteTree_Live"."BetterSiteTitle" END
AS "BetterSiteTitle", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."Keyword"
ELSE "SiteTree_Live"."Keyword" END
AS "Keyword", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."FeaturedKeyword"
ELSE "SiteTree_Live"."FeaturedKeyword" END
AS "FeaturedKeyword", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."KeywordQuestion"
ELSE "SiteTree_Live"."KeywordQuestion" END
AS "KeywordQuestion", "SiteTree_Live"."Follow", "SiteTree_Live"."FollowType", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."GenMetaDesc"
ELSE "SiteTree_Live"."GenMetaDesc" END
AS "GenMetaDesc", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."FBTitle"
ELSE "SiteTree_Live"."FBTitle" END
AS "FBTitle", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."FBDescription"
ELSE "SiteTree_Live"."FBDescription" END
AS "FBDescription", "SiteTree_Live"."FBType", "SiteTree_Live"."FBTypeOverride", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."TwTitle"
ELSE "SiteTree_Live"."TwTitle" END
AS "TwTitle", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."TwDescription"
ELSE "SiteTree_Live"."TwDescription" END
AS "TwDescription", "SiteTree_Live"."CanViewType", "SiteTree_Live"."CanEditType", "SiteTree_Live"."Version", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."URLSegment"
ELSE "SiteTree_Live"."URLSegment" END
AS "URLSegment", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."Title"
ELSE "SiteTree_Live"."Title" END
AS "Title", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."MenuTitle"
ELSE "SiteTree_Live"."MenuTitle" END
AS "MenuTitle", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."Content"
ELSE "SiteTree_Live"."Content" END
AS "Content", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."MetaDescription"
ELSE "SiteTree_Live"."MetaDescription" END
AS "MetaDescription", "SiteTree_Live"."ExtraMeta", "SiteTree_Live"."ShowInMenus", "SiteTree_Live"."ShowInSearch", "SiteTree_Live"."Sort", "SiteTree_Live"."HasBrokenFile", "SiteTree_Live"."HasBrokenLink", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."ReportClass"
ELSE "SiteTree_Live"."ReportClass" END
AS "ReportClass", "SiteTree_Live"."CanonicalLinkID", "SiteTree_Live"."FBImageID", "SiteTree_Live"."TwImageID", "SiteTree_Live"."ParentID", "SiteTree_Live"."ID",
CASE WHEN "SiteTree_Live"."ClassName" IS NOT NULL THEN "SiteTree_Live"."ClassName"
ELSE 'SilverStripe\\CMS\\Model\\SiteTree' END AS "RecordClassName", 'de_DE' AS "Locale", CASE WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN 'de_DE'
ELSE NULL END AS "SourceLocale"
FROM "SiteTree_Live" LEFT JOIN "SiteTree_Localised_Live" AS "SiteTree_Localised_de_DE" ON "SiteTree_Live"."ID" = "SiteTree_Localised_de_DE"."RecordID" AND "SiteTree_Localised_de_DE"."Locale" = ?
WHERE ("SiteTree_Live"."ID" = ?)
AND (("SiteTree_Localised_de_DE"."ID" IS NOT NULL))
ORDER BY "SiteTree_Live"."Sort" ASC
LIMIT 1
0.0001s
0069: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."BetterSiteTitle"
ELSE "SiteTree_Live"."BetterSiteTitle" END
AS "BetterSiteTitle", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."Keyword"
ELSE "SiteTree_Live"."Keyword" END
AS "Keyword", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."FeaturedKeyword"
ELSE "SiteTree_Live"."FeaturedKeyword" END
AS "FeaturedKeyword", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."KeywordQuestion"
ELSE "SiteTree_Live"."KeywordQuestion" END
AS "KeywordQuestion", "SiteTree_Live"."Follow", "SiteTree_Live"."FollowType", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."GenMetaDesc"
ELSE "SiteTree_Live"."GenMetaDesc" END
AS "GenMetaDesc", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."FBTitle"
ELSE "SiteTree_Live"."FBTitle" END
AS "FBTitle", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."FBDescription"
ELSE "SiteTree_Live"."FBDescription" END
AS "FBDescription", "SiteTree_Live"."FBType", "SiteTree_Live"."FBTypeOverride", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."TwTitle"
ELSE "SiteTree_Live"."TwTitle" END
AS "TwTitle", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."TwDescription"
ELSE "SiteTree_Live"."TwDescription" END
AS "TwDescription", "SiteTree_Live"."CanViewType", "SiteTree_Live"."CanEditType", "SiteTree_Live"."Version", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."URLSegment"
ELSE "SiteTree_Live"."URLSegment" END
AS "URLSegment", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."Title"
ELSE "SiteTree_Live"."Title" END
AS "Title", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."MenuTitle"
ELSE "SiteTree_Live"."MenuTitle" END
AS "MenuTitle", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."Content"
ELSE "SiteTree_Live"."Content" END
AS "Content", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."MetaDescription"
ELSE "SiteTree_Live"."MetaDescription" END
AS "MetaDescription", "SiteTree_Live"."ExtraMeta", "SiteTree_Live"."ShowInMenus", "SiteTree_Live"."ShowInSearch", "SiteTree_Live"."Sort", "SiteTree_Live"."HasBrokenFile", "SiteTree_Live"."HasBrokenLink", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."ReportClass"
ELSE "SiteTree_Live"."ReportClass" END
AS "ReportClass", "SiteTree_Live"."CanonicalLinkID", "SiteTree_Live"."FBImageID", "SiteTree_Live"."TwImageID", "SiteTree_Live"."ParentID", "SiteTree_Live"."ID",
CASE WHEN "SiteTree_Live"."ClassName" IS NOT NULL THEN "SiteTree_Live"."ClassName"
ELSE 'SilverStripe\\CMS\\Model\\SiteTree' END AS "RecordClassName", 'de_DE' AS "Locale", CASE WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN 'de_DE'
ELSE NULL END AS "SourceLocale"
FROM "SiteTree_Live" LEFT JOIN "SiteTree_Localised_Live" AS "SiteTree_Localised_de_DE" ON "SiteTree_Live"."ID" = "SiteTree_Localised_de_DE"."RecordID" AND "SiteTree_Localised_de_DE"."Locale" = ?
WHERE ("SiteTree_Live"."ID" = ?)
AND (("SiteTree_Localised_de_DE"."ID" IS NOT NULL))
ORDER BY "SiteTree_Live"."Sort" ASC
LIMIT 1
0.0001s
0070: SELECT DISTINCT "SiteTree"."ClassName", "SiteTree"."LastEdited", "SiteTree"."Created", "SiteTree"."Priority", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."BetterSiteTitle"
ELSE "SiteTree"."BetterSiteTitle" END
AS "BetterSiteTitle", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."Keyword"
ELSE "SiteTree"."Keyword" END
AS "Keyword", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."FeaturedKeyword"
ELSE "SiteTree"."FeaturedKeyword" END
AS "FeaturedKeyword", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."KeywordQuestion"
ELSE "SiteTree"."KeywordQuestion" END
AS "KeywordQuestion", "SiteTree"."Follow", "SiteTree"."FollowType", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."GenMetaDesc"
ELSE "SiteTree"."GenMetaDesc" END
AS "GenMetaDesc", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."FBTitle"
ELSE "SiteTree"."FBTitle" END
AS "FBTitle", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."FBDescription"
ELSE "SiteTree"."FBDescription" END
AS "FBDescription", "SiteTree"."FBType", "SiteTree"."FBTypeOverride", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."TwTitle"
ELSE "SiteTree"."TwTitle" END
AS "TwTitle", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."TwDescription"
ELSE "SiteTree"."TwDescription" END
AS "TwDescription", "SiteTree"."CanViewType", "SiteTree"."CanEditType", "SiteTree"."Version", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."URLSegment"
ELSE "SiteTree"."URLSegment" END
AS "URLSegment", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."Title"
ELSE "SiteTree"."Title" END
AS "Title", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."MenuTitle"
ELSE "SiteTree"."MenuTitle" END
AS "MenuTitle", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."Content"
ELSE "SiteTree"."Content" END
AS "Content", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."MetaDescription"
ELSE "SiteTree"."MetaDescription" END
AS "MetaDescription", "SiteTree"."ExtraMeta", "SiteTree"."ShowInMenus", "SiteTree"."ShowInSearch", "SiteTree"."Sort", "SiteTree"."HasBrokenFile", "SiteTree"."HasBrokenLink", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."ReportClass"
ELSE "SiteTree"."ReportClass" END
AS "ReportClass", "SiteTree"."CanonicalLinkID", "SiteTree"."FBImageID", "SiteTree"."TwImageID", "SiteTree"."ParentID", "SiteTree"."ID",
CASE WHEN "SiteTree"."ClassName" IS NOT NULL THEN "SiteTree"."ClassName"
ELSE 'SilverStripe\\CMS\\Model\\SiteTree' END AS "RecordClassName", 'de_DE' AS "Locale", CASE WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN 'de_DE'
ELSE NULL END AS "SourceLocale"
FROM "SiteTree" LEFT JOIN "SiteTree_Localised" AS "SiteTree_Localised_de_DE" ON "SiteTree"."ID" = "SiteTree_Localised_de_DE"."RecordID" AND "SiteTree_Localised_de_DE"."Locale" = ?
WHERE ("SiteTree"."ID" = ?)
AND (("SiteTree_Localised_de_DE"."ID" IS NOT NULL))
ORDER BY "SiteTree"."Sort" ASC
LIMIT 1
0.0003s
0071: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."BetterSiteTitle"
ELSE "SiteTree_Live"."BetterSiteTitle" END
AS "BetterSiteTitle", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."Keyword"
ELSE "SiteTree_Live"."Keyword" END
AS "Keyword", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."FeaturedKeyword"
ELSE "SiteTree_Live"."FeaturedKeyword" END
AS "FeaturedKeyword", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."KeywordQuestion"
ELSE "SiteTree_Live"."KeywordQuestion" END
AS "KeywordQuestion", "SiteTree_Live"."Follow", "SiteTree_Live"."FollowType", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."GenMetaDesc"
ELSE "SiteTree_Live"."GenMetaDesc" END
AS "GenMetaDesc", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."FBTitle"
ELSE "SiteTree_Live"."FBTitle" END
AS "FBTitle", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."FBDescription"
ELSE "SiteTree_Live"."FBDescription" END
AS "FBDescription", "SiteTree_Live"."FBType", "SiteTree_Live"."FBTypeOverride", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."TwTitle"
ELSE "SiteTree_Live"."TwTitle" END
AS "TwTitle", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."TwDescription"
ELSE "SiteTree_Live"."TwDescription" END
AS "TwDescription", "SiteTree_Live"."CanViewType", "SiteTree_Live"."CanEditType", "SiteTree_Live"."Version", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."URLSegment"
ELSE "SiteTree_Live"."URLSegment" END
AS "URLSegment", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."Title"
ELSE "SiteTree_Live"."Title" END
AS "Title", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."MenuTitle"
ELSE "SiteTree_Live"."MenuTitle" END
AS "MenuTitle", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."Content"
ELSE "SiteTree_Live"."Content" END
AS "Content", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."MetaDescription"
ELSE "SiteTree_Live"."MetaDescription" END
AS "MetaDescription", "SiteTree_Live"."ExtraMeta", "SiteTree_Live"."ShowInMenus", "SiteTree_Live"."ShowInSearch", "SiteTree_Live"."Sort", "SiteTree_Live"."HasBrokenFile", "SiteTree_Live"."HasBrokenLink", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."ReportClass"
ELSE "SiteTree_Live"."ReportClass" END
AS "ReportClass", "SiteTree_Live"."CanonicalLinkID", "SiteTree_Live"."FBImageID", "SiteTree_Live"."TwImageID", "SiteTree_Live"."ParentID", "SiteTree_Live"."ID",
CASE WHEN "SiteTree_Live"."ClassName" IS NOT NULL THEN "SiteTree_Live"."ClassName"
ELSE 'SilverStripe\\CMS\\Model\\SiteTree' END AS "RecordClassName", 'de_DE' AS "Locale", CASE WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN 'de_DE'
ELSE NULL END AS "SourceLocale"
FROM "SiteTree_Live" LEFT JOIN "SiteTree_Localised_Live" AS "SiteTree_Localised_de_DE" ON "SiteTree_Live"."ID" = "SiteTree_Localised_de_DE"."RecordID" AND "SiteTree_Localised_de_DE"."Locale" = ?
WHERE ("SiteTree_Live"."ID" = ?)
AND (("SiteTree_Localised_de_DE"."ID" IS NOT NULL))
ORDER BY "SiteTree_Live"."Sort" ASC
LIMIT 1
0.0001s
0072: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."BetterSiteTitle"
ELSE "SiteTree_Live"."BetterSiteTitle" END
AS "BetterSiteTitle", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."Keyword"
ELSE "SiteTree_Live"."Keyword" END
AS "Keyword", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."FeaturedKeyword"
ELSE "SiteTree_Live"."FeaturedKeyword" END
AS "FeaturedKeyword", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."KeywordQuestion"
ELSE "SiteTree_Live"."KeywordQuestion" END
AS "KeywordQuestion", "SiteTree_Live"."Follow", "SiteTree_Live"."FollowType", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."GenMetaDesc"
ELSE "SiteTree_Live"."GenMetaDesc" END
AS "GenMetaDesc", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."FBTitle"
ELSE "SiteTree_Live"."FBTitle" END
AS "FBTitle", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."FBDescription"
ELSE "SiteTree_Live"."FBDescription" END
AS "FBDescription", "SiteTree_Live"."FBType", "SiteTree_Live"."FBTypeOverride", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."TwTitle"
ELSE "SiteTree_Live"."TwTitle" END
AS "TwTitle", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."TwDescription"
ELSE "SiteTree_Live"."TwDescription" END
AS "TwDescription", "SiteTree_Live"."CanViewType", "SiteTree_Live"."CanEditType", "SiteTree_Live"."Version", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."URLSegment"
ELSE "SiteTree_Live"."URLSegment" END
AS "URLSegment", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."Title"
ELSE "SiteTree_Live"."Title" END
AS "Title", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."MenuTitle"
ELSE "SiteTree_Live"."MenuTitle" END
AS "MenuTitle", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."Content"
ELSE "SiteTree_Live"."Content" END
AS "Content", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."MetaDescription"
ELSE "SiteTree_Live"."MetaDescription" END
AS "MetaDescription", "SiteTree_Live"."ExtraMeta", "SiteTree_Live"."ShowInMenus", "SiteTree_Live"."ShowInSearch", "SiteTree_Live"."Sort", "SiteTree_Live"."HasBrokenFile", "SiteTree_Live"."HasBrokenLink", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."ReportClass"
ELSE "SiteTree_Live"."ReportClass" END
AS "ReportClass", "SiteTree_Live"."CanonicalLinkID", "SiteTree_Live"."FBImageID", "SiteTree_Live"."TwImageID", "SiteTree_Live"."ParentID", "SiteTree_Live"."ID",
CASE WHEN "SiteTree_Live"."ClassName" IS NOT NULL THEN "SiteTree_Live"."ClassName"
ELSE 'SilverStripe\\CMS\\Model\\SiteTree' END AS "RecordClassName", 'de_DE' AS "Locale", CASE WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN 'de_DE'
ELSE NULL END AS "SourceLocale"
FROM "SiteTree_Live" LEFT JOIN "SiteTree_Localised_Live" AS "SiteTree_Localised_de_DE" ON "SiteTree_Live"."ID" = "SiteTree_Localised_de_DE"."RecordID" AND "SiteTree_Localised_de_DE"."Locale" = ?
WHERE ("SiteTree_Live"."ID" = ?)
AND (("SiteTree_Localised_de_DE"."ID" IS NOT NULL))
ORDER BY "SiteTree_Live"."Sort" ASC
LIMIT 1
0.0001s
Führung durch die Bremer Überseestadt » Stadtführungen in Bremen
Preis pro Gruppe:
1-25 Personen: 280,00 €
Ab 26 Personen Preis auf Anfrage
Für Führungen auf Englisch kommen pauschal 30,00 € pro Gruppe hinzu.
Die Preise verstehen sich inkl. ausgewiesener MwSt. – Dauer: 2 Stunden
Termine nach Absprache
Treffpunkt: Vor dem Restaurant Feuerwache
Endpunkt: Vor dem Hotel John & Will (Überseeinsel)
In der Überseestadt trifft Tradition auf Moderne. Begebt euch auf eine spannende Zeitreise durch die Bremer Hafengeschichte und staunt über ein völlig neues Quartier, in dem heute gelebt, gearbeitet und das Leben genossen wird. Wo heute Bürohochhäuser, Wohnungen und Restaurants angesiedelt sind, pulsierte früher das Hafenleben. Damals hätte vermutlich niemand damit gerechnet, dass sich hier einmal eines der größten Stadtplanungsprojekte in Europa entwickeln würde.
Ein neuer Hafen für Bremen
Nach langem Hin und Her hatte sich Bremen Ende des 19. Jahrhunderts dazu entschlossen, den Hafen zurück in die Stadt zu holen. Mit Bremerhaven wurde zwar ein paar Jahrzehnte zuvor ein direkter Seezugang geschaffen, aber die Stadt wollte konkurrenzfähig bleiben. Nachdem die große Weserkorrektion unter Ludwig Franzius stattgefunden hatte, gab es wieder freie Fahrt auf der Weser für Schiffe mit einem Tiefgang bis zu fünf Meter. 1888 wurde das erste Hafenbecken eingeweiht: der Europahafen – damals noch Freihafen I genannt. In den nächsten Jahren folgten weitere Hafenbecken, darunter der Bremer Überseehafen.
Eine Blechkiste veränderte alles
1966 legte das erste Containerschiff aus Amerika in Bremen an. Die damals etwas fremd wirkenden Blechkisten revolutionierten recht schnell den Warentransport und der Haupthafen Bremens wurde zurück nach Bremerhaven verlegt. Es kamen immer weniger Schiffe in die Bremischen Häfen. Ende der 1990er Jahre wurde der Überseehafen sogar komplett zugeschüttet. Es folgte der "Masterplan Überseestadt" und seitdem entsteht auf rund 300 ha eine neue Welt. Wo einst die "dicken Pötte" im Überseehafen vor Anker lagen, befinden sich heute unter anderem der Großmarkt und Wohnhäuser. Nur ein kleiner Teich erinnert noch daran, dass hier früher ein riesiges Hafenbecken gewesen ist. Im Schuppen Eins wurde bis in die 1990er Jahre noch Stückgut gelagert. Heute befindet sich dort unter anderem ein Zentrum für Mobilität und Automobilkultur. Zudem sind viele neue Gebäude entstanden. In keinem anderen Bremer Ortsteil fand in den letzten Jahren so viel Wandel statt wie hier. Begebt euch auf eine spannende Reise durch ein historisches Hafengebiet, das sich in den letzten Jahren komplett verändert hat und entdeckt dabei den ein oder anderen verborgenen Schatz der Stadt.
Wichtiger Hinweis:
Für diese Tour ist es unbedingt erforderlich, dass alle Personen gut zu Fuß sind, da wir längere Strecken laufen und es zwischendurch keine Sitzgelegenheiten gibt.
Preis pro Gruppe: 1-25 Personen: 220,00 € (ab dem 01.01.25 280,00 €) Ab 26 Personen auf Anfrage Für Führungen auf Englisch kommen pauschal 30,00 € pro Gruppe hinzu. Die Preise verstehen sich inkl. ausgewiesener MwSt.
Termine nach Absprache
Treffpunkt: Vor dem Restaurant Feuerwache Endpunkt: Vor dem Hotel John & Will (Überseeinsel)