0003: SELECT DISTINCT "Fluent_Domain"."ClassName", "Fluent_Domain"."LastEdited", "Fluent_Domain"."Created", "Fluent_Domain"."Domain", "Fluent_Domain"."DefaultLocaleID", "Fluent_Domain"."ID",
CASE WHEN "Fluent_Domain"."ClassName" IS NOT NULL THEN "Fluent_Domain"."ClassName"
ELSE 'TractorCow\\Fluent\\Model\\Domain' END AS "RecordClassName"
FROM "Fluent_Domain"
0.0001s
0004: SELECT DISTINCT "Fluent_Locale"."ClassName", "Fluent_Locale"."LastEdited", "Fluent_Locale"."Created", "Fluent_Locale"."Title", "Fluent_Locale"."Locale", "Fluent_Locale"."URLSegment", "Fluent_Locale"."IsGlobalDefault", "Fluent_Locale"."UseDefaultCode", "Fluent_Locale"."Sort", "Fluent_Locale"."Timezone", "Fluent_Locale"."DomainID", "Fluent_Locale"."ID",
CASE WHEN "Fluent_Locale"."ClassName" IS NOT NULL THEN "Fluent_Locale"."ClassName"
ELSE 'TractorCow\\Fluent\\Model\\Locale' END AS "RecordClassName"
FROM "Fluent_Locale"
ORDER BY "Fluent_Locale"."Sort" ASC, "Fluent_Locale"."Locale" ASC
0.0001s
0005: SELECT DISTINCT "Fluent_FallbackLocale"."ClassName", "Fluent_FallbackLocale"."LastEdited", "Fluent_FallbackLocale"."Created", "Fluent_FallbackLocale"."Sort", "Fluent_FallbackLocale"."ParentID", "Fluent_FallbackLocale"."LocaleID", "Fluent_FallbackLocale"."ID",
CASE WHEN "Fluent_FallbackLocale"."ClassName" IS NOT NULL THEN "Fluent_FallbackLocale"."ClassName"
ELSE 'TractorCow\\Fluent\\Model\\FallbackLocale' END AS "RecordClassName"
FROM "Fluent_FallbackLocale"
WHERE ("Fluent_FallbackLocale"."ParentID" = ?)
ORDER BY "Fluent_FallbackLocale"."Sort" ASC
0.0004s
0006: 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.0009s
0007: 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.0007s
0008: 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
0009: SELECT DISTINCT "SiteConfig"."ClassName", "SiteConfig"."LastEdited", "SiteConfig"."Created", CASE
WHEN "SiteConfig_Localised_de_DE"."ID" IS NOT NULL THEN "SiteConfig_Localised_de_DE"."MapsBrowserKey"
ELSE "SiteConfig"."MapsBrowserKey" END
AS "MapsBrowserKey", CASE
WHEN "SiteConfig_Localised_de_DE"."ID" IS NOT NULL THEN "SiteConfig_Localised_de_DE"."MapsServerKey"
ELSE "SiteConfig"."MapsServerKey" END
AS "MapsServerKey", "SiteConfig"."UseDefaultCMSImage", CASE
WHEN "SiteConfig_Localised_de_DE"."ID" IS NOT NULL THEN "SiteConfig_Localised_de_DE"."LoginHeroHash"
ELSE "SiteConfig"."LoginHeroHash" END
AS "LoginHeroHash", CASE
WHEN "SiteConfig_Localised_de_DE"."ID" IS NOT NULL THEN "SiteConfig_Localised_de_DE"."DefaultImageAllowedTag"
ELSE "SiteConfig"."DefaultImageAllowedTag" END
AS "DefaultImageAllowedTag", CASE
WHEN "SiteConfig_Localised_de_DE"."ID" IS NOT NULL THEN "SiteConfig_Localised_de_DE"."DefaultImageDisallowedTag"
ELSE "SiteConfig"."DefaultImageDisallowedTag" END
AS "DefaultImageDisallowedTag", "SiteConfig"."UseOwnLoginText", CASE
WHEN "SiteConfig_Localised_de_DE"."ID" IS NOT NULL THEN "SiteConfig_Localised_de_DE"."DefaultLoginText"
ELSE "SiteConfig"."DefaultLoginText" END
AS "DefaultLoginText", CASE
WHEN "SiteConfig_Localised_de_DE"."ID" IS NOT NULL THEN "SiteConfig_Localised_de_DE"."CookieConsentNotice"
ELSE "SiteConfig"."CookieConsentNotice" END
AS "CookieConsentNotice", CASE
WHEN "SiteConfig_Localised_de_DE"."ID" IS NOT NULL THEN "SiteConfig_Localised_de_DE"."CookieBtnOk"
ELSE "SiteConfig"."CookieBtnOk" END
AS "CookieBtnOk", CASE
WHEN "SiteConfig_Localised_de_DE"."ID" IS NOT NULL THEN "SiteConfig_Localised_de_DE"."CookieChooseText"
ELSE "SiteConfig"."CookieChooseText" END
AS "CookieChooseText", CASE
WHEN "SiteConfig_Localised_de_DE"."ID" IS NOT NULL THEN "SiteConfig_Localised_de_DE"."CookieBtnDislike"
ELSE "SiteConfig"."CookieBtnDislike" END
AS "CookieBtnDislike", CASE
WHEN "SiteConfig_Localised_de_DE"."ID" IS NOT NULL THEN "SiteConfig_Localised_de_DE"."CookieAllowGMaps"
ELSE "SiteConfig"."CookieAllowGMaps" END
AS "CookieAllowGMaps", CASE
WHEN "SiteConfig_Localised_de_DE"."ID" IS NOT NULL THEN "SiteConfig_Localised_de_DE"."CookieTextUnderBtn"
ELSE "SiteConfig"."CookieTextUnderBtn" END
AS "CookieTextUnderBtn", CASE
WHEN "SiteConfig_Localised_de_DE"."ID" IS NOT NULL THEN "SiteConfig_Localised_de_DE"."CookieAllowYouTube"
ELSE "SiteConfig"."CookieAllowYouTube" END
AS "CookieAllowYouTube", CASE
WHEN "SiteConfig_Localised_de_DE"."ID" IS NOT NULL THEN "SiteConfig_Localised_de_DE"."CookieConsentPopUpHeadline"
ELSE "SiteConfig"."CookieConsentPopUpHeadline" END
AS "CookieConsentPopUpHeadline", CASE
WHEN "SiteConfig_Localised_de_DE"."ID" IS NOT NULL THEN "SiteConfig_Localised_de_DE"."CookieConsentPopUpNotice"
ELSE "SiteConfig"."CookieConsentPopUpNotice" END
AS "CookieConsentPopUpNotice", CASE
WHEN "SiteConfig_Localised_de_DE"."ID" IS NOT NULL THEN "SiteConfig_Localised_de_DE"."CookieConsentPopUpDisallow"
ELSE "SiteConfig"."CookieConsentPopUpDisallow" END
AS "CookieConsentPopUpDisallow", CASE
WHEN "SiteConfig_Localised_de_DE"."ID" IS NOT NULL THEN "SiteConfig_Localised_de_DE"."CookieConsentPopUpAllowAll"
ELSE "SiteConfig"."CookieConsentPopUpAllowAll" END
AS "CookieConsentPopUpAllowAll", CASE
WHEN "SiteConfig_Localised_de_DE"."ID" IS NOT NULL THEN "SiteConfig_Localised_de_DE"."CookieConsentPopUpAllowSelected"
ELSE "SiteConfig"."CookieConsentPopUpAllowSelected" END
AS "CookieConsentPopUpAllowSelected", CASE
WHEN "SiteConfig_Localised_de_DE"."ID" IS NOT NULL THEN "SiteConfig_Localised_de_DE"."CookiePrivacyPolicyTitle"
ELSE "SiteConfig"."CookiePrivacyPolicyTitle" END
AS "CookiePrivacyPolicyTitle", CASE
WHEN "SiteConfig_Localised_de_DE"."ID" IS NOT NULL THEN "SiteConfig_Localised_de_DE"."CookiePrivacyPolicyText"
ELSE "SiteConfig"."CookiePrivacyPolicyText" END
AS "CookiePrivacyPolicyText", CASE
WHEN "SiteConfig_Localised_de_DE"."ID" IS NOT NULL THEN "SiteConfig_Localised_de_DE"."PersonText"
ELSE "SiteConfig"."PersonText" END
AS "PersonText", CASE
WHEN "SiteConfig_Localised_de_DE"."ID" IS NOT NULL THEN "SiteConfig_Localised_de_DE"."IstGebucht"
ELSE "SiteConfig"."IstGebucht" END
AS "IstGebucht", CASE
WHEN "SiteConfig_Localised_de_DE"."ID" IS NOT NULL THEN "SiteConfig_Localised_de_DE"."JetztBuchen"
ELSE "SiteConfig"."JetztBuchen" END
AS "JetztBuchen", CASE
WHEN "SiteConfig_Localised_de_DE"."ID" IS NOT NULL THEN "SiteConfig_Localised_de_DE"."BookmarkQRCodeText"
ELSE "SiteConfig"."BookmarkQRCodeText" END
AS "BookmarkQRCodeText", CASE
WHEN "SiteConfig_Localised_de_DE"."ID" IS NOT NULL THEN "SiteConfig_Localised_de_DE"."BookmarkQRCodeBtnCopy"
ELSE "SiteConfig"."BookmarkQRCodeBtnCopy" END
AS "BookmarkQRCodeBtnCopy", CASE
WHEN "SiteConfig_Localised_de_DE"."ID" IS NOT NULL THEN "SiteConfig_Localised_de_DE"."BookmarkNichtEditmehr"
ELSE "SiteConfig"."BookmarkNichtEditmehr" END
AS "BookmarkNichtEditmehr", CASE
WHEN "SiteConfig_Localised_de_DE"."ID" IS NOT NULL THEN "SiteConfig_Localised_de_DE"."BookmarkSetNew"
ELSE "SiteConfig"."BookmarkSetNew" END
AS "BookmarkSetNew", CASE
WHEN "SiteConfig_Localised_de_DE"."ID" IS NOT NULL THEN "SiteConfig_Localised_de_DE"."Bookmarkduplicate"
ELSE "SiteConfig"."Bookmarkduplicate" END
AS "Bookmarkduplicate", 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"."MetaImageID", "SiteConfig"."LogoID", "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.001s
0010: SELECT DISTINCT "SchemaCompany"."ClassName", "SchemaCompany"."LastEdited", "SchemaCompany"."Created", "SchemaCompany"."Title", "SchemaCompany"."SchemaType", "SchemaCompany"."Company", "SchemaCompany"."Name", "SchemaCompany"."Country", "SchemaCompany"."Street", "SchemaCompany"."HouseNmbr", "SchemaCompany"."Postal", "SchemaCompany"."Location", "SchemaCompany"."Telefon", "SchemaCompany"."LogoID", "SchemaCompany"."ID",
CASE WHEN "SchemaCompany"."ClassName" IS NOT NULL THEN "SchemaCompany"."ClassName"
ELSE 'App\\Models\\SchemaCompany' END AS "RecordClassName"
FROM "SchemaCompany"
LIMIT 1
0.0003s
0011: SELECT CASE WHEN EXISTS(SELECT *
FROM "LinkField_Link_Live"
WHERE ("LinkField_Link_Live"."OwnerClass" IN ('App\\Models\\SchemaCompany'))
AND ("LinkField_Link_Live"."OwnerRelation" = ?)
AND ("LinkField_Link_Live"."OwnerID" = ?)) THEN 1 ELSE 0 END
0.0004s
0012: SELECT CASE WHEN EXISTS(SELECT *
FROM "OpeningHour"
WHERE ("OpeningHour"."IsClosed" = ?)) THEN 1 ELSE 0 END
0.0002s
0013: SELECT CASE WHEN EXISTS(SELECT *
FROM "OpeningHourSpecial" ) THEN 1 ELSE 0 END
0.0001s
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 (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.0009s
0015: SELECT DISTINCT "PersonEntry"."ClassName", "PersonEntry"."LastEdited", "PersonEntry"."Created", "PersonEntry"."SortOrder", CASE
WHEN "PersonEntry_Localised_de_DE"."ID" IS NOT NULL THEN "PersonEntry_Localised_de_DE"."Name"
ELSE "PersonEntry"."Name" END
AS "Name", CASE
WHEN "PersonEntry_Localised_de_DE"."ID" IS NOT NULL THEN "PersonEntry_Localised_de_DE"."Color"
ELSE "PersonEntry"."Color" END
AS "Color", "PersonEntry"."ImageID", "PersonEntry"."ID",
CASE WHEN "PersonEntry"."ClassName" IS NOT NULL THEN "PersonEntry"."ClassName"
ELSE 'App\\Models\\PersonEntry' END AS "RecordClassName", 'de_DE' AS "Locale", CASE WHEN "PersonEntry_Localised_de_DE"."ID" IS NOT NULL THEN 'de_DE'
ELSE NULL END AS "SourceLocale", (COALESCE("PersonEntry_Localised_de_DE"."Name", "PersonEntry"."Name")) AS "_SortColumn0"
FROM "PersonEntry" LEFT JOIN "PersonEntry_Localised" AS "PersonEntry_Localised_de_DE" ON "PersonEntry"."ID" = "PersonEntry_Localised_de_DE"."RecordID" AND "PersonEntry_Localised_de_DE"."Locale" = ?
WHERE (("PersonEntry_Localised_de_DE"."ID" IS NOT NULL))
ORDER BY "_SortColumn0" ASC
0.0004s
0016: SELECT DISTINCT "File_Live"."ClassName", "File_Live"."LastEdited", "File_Live"."Created", CASE WHEN "File_Live"."ClassName" IN ('SilverStripe\\Assets\\File', 'SilverStripe\\Assets\\Folder', 'SilverStripe\\Assets\\Image', 'WeDevelop\\SvgImage\\Assets\\Svg') THEN "File_Live"."Copyright" WHEN "File_Live"."ClassName" IN ('SilverStripe\\Assets\\Image', 'WeDevelop\\SvgImage\\Assets\\Svg') THEN "Image_Live"."Copyright" WHEN "File_Live"."ClassName" IN ('SilverStripe\\Assets\\Image', 'WeDevelop\\SvgImage\\Assets\\Svg') THEN "Image_Live"."Copyright" ELSE NULL END AS "Copyright", CASE WHEN "File_Live"."ClassName" IN ('SilverStripe\\Assets\\File', 'SilverStripe\\Assets\\Folder', 'SilverStripe\\Assets\\Image', 'WeDevelop\\SvgImage\\Assets\\Svg') THEN "File_Live"."Bildunterschrift" WHEN "File_Live"."ClassName" IN ('SilverStripe\\Assets\\Image', 'WeDevelop\\SvgImage\\Assets\\Svg') THEN "Image_Live"."Bildunterschrift" WHEN "File_Live"."ClassName" IN ('SilverStripe\\Assets\\Image', 'WeDevelop\\SvgImage\\Assets\\Svg') THEN "Image_Live"."Bildunterschrift" ELSE NULL END AS "Bildunterschrift", CASE WHEN "File_Live"."ClassName" IN ('SilverStripe\\Assets\\File', 'SilverStripe\\Assets\\Folder', 'SilverStripe\\Assets\\Image', 'WeDevelop\\SvgImage\\Assets\\Svg') THEN "File_Live"."AltText" WHEN "File_Live"."ClassName" IN ('SilverStripe\\Assets\\Image', 'WeDevelop\\SvgImage\\Assets\\Svg') THEN "Image_Live"."AltText" WHEN "File_Live"."ClassName" IN ('SilverStripe\\Assets\\Image', 'WeDevelop\\SvgImage\\Assets\\Svg') THEN "Image_Live"."AltText" ELSE NULL END AS "AltText", "File_Live"."Version", "File_Live"."CanViewType", "File_Live"."CanEditType", "File_Live"."Name", "File_Live"."Title", "File_Live"."ShowInSearch", "File_Live"."ParentID", "File_Live"."OwnerID", "File_Live"."FileHash", "File_Live"."FileFilename", "File_Live"."FileVariant", "Image_Live"."FocusPointX", "Image_Live"."FocusPointY", "Image_Live"."FocusPointWidth", "Image_Live"."FocusPointHeight", "File_Live"."ID",
CASE WHEN "File_Live"."ClassName" IS NOT NULL THEN "File_Live"."ClassName"
ELSE 'SilverStripe\\Assets\\File' END AS "RecordClassName"
FROM "File_Live" LEFT JOIN "Image_Live" ON "Image_Live"."ID" = "File_Live"."ID"
WHERE ("File_Live"."ID" = ?)
AND ("File_Live"."ClassName" IN (?, ?))
ORDER BY "File_Live"."Name" ASC
LIMIT 1
0.0004s
0017: SELECT DISTINCT "File_Live"."ClassName", "File_Live"."LastEdited", "File_Live"."Created", CASE WHEN "File_Live"."ClassName" IN ('SilverStripe\\Assets\\File', 'SilverStripe\\Assets\\Folder', 'SilverStripe\\Assets\\Image', 'WeDevelop\\SvgImage\\Assets\\Svg') THEN "File_Live"."Copyright" WHEN "File_Live"."ClassName" IN ('SilverStripe\\Assets\\Image', 'WeDevelop\\SvgImage\\Assets\\Svg') THEN "Image_Live"."Copyright" WHEN "File_Live"."ClassName" IN ('SilverStripe\\Assets\\Image', 'WeDevelop\\SvgImage\\Assets\\Svg') THEN "Image_Live"."Copyright" ELSE NULL END AS "Copyright", CASE WHEN "File_Live"."ClassName" IN ('SilverStripe\\Assets\\File', 'SilverStripe\\Assets\\Folder', 'SilverStripe\\Assets\\Image', 'WeDevelop\\SvgImage\\Assets\\Svg') THEN "File_Live"."Bildunterschrift" WHEN "File_Live"."ClassName" IN ('SilverStripe\\Assets\\Image', 'WeDevelop\\SvgImage\\Assets\\Svg') THEN "Image_Live"."Bildunterschrift" WHEN "File_Live"."ClassName" IN ('SilverStripe\\Assets\\Image', 'WeDevelop\\SvgImage\\Assets\\Svg') THEN "Image_Live"."Bildunterschrift" ELSE NULL END AS "Bildunterschrift", CASE WHEN "File_Live"."ClassName" IN ('SilverStripe\\Assets\\File', 'SilverStripe\\Assets\\Folder', 'SilverStripe\\Assets\\Image', 'WeDevelop\\SvgImage\\Assets\\Svg') THEN "File_Live"."AltText" WHEN "File_Live"."ClassName" IN ('SilverStripe\\Assets\\Image', 'WeDevelop\\SvgImage\\Assets\\Svg') THEN "Image_Live"."AltText" WHEN "File_Live"."ClassName" IN ('SilverStripe\\Assets\\Image', 'WeDevelop\\SvgImage\\Assets\\Svg') THEN "Image_Live"."AltText" ELSE NULL END AS "AltText", "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.0005s
0018: SELECT DISTINCT "File_Live"."ClassName", "File_Live"."LastEdited", "File_Live"."Created", CASE WHEN "File_Live"."ClassName" IN ('SilverStripe\\Assets\\File', 'SilverStripe\\Assets\\Folder', 'SilverStripe\\Assets\\Image', 'WeDevelop\\SvgImage\\Assets\\Svg') THEN "File_Live"."Copyright" WHEN "File_Live"."ClassName" IN ('SilverStripe\\Assets\\Image', 'WeDevelop\\SvgImage\\Assets\\Svg') THEN "Image_Live"."Copyright" WHEN "File_Live"."ClassName" IN ('SilverStripe\\Assets\\Image', 'WeDevelop\\SvgImage\\Assets\\Svg') THEN "Image_Live"."Copyright" ELSE NULL END AS "Copyright", CASE WHEN "File_Live"."ClassName" IN ('SilverStripe\\Assets\\File', 'SilverStripe\\Assets\\Folder', 'SilverStripe\\Assets\\Image', 'WeDevelop\\SvgImage\\Assets\\Svg') THEN "File_Live"."Bildunterschrift" WHEN "File_Live"."ClassName" IN ('SilverStripe\\Assets\\Image', 'WeDevelop\\SvgImage\\Assets\\Svg') THEN "Image_Live"."Bildunterschrift" WHEN "File_Live"."ClassName" IN ('SilverStripe\\Assets\\Image', 'WeDevelop\\SvgImage\\Assets\\Svg') THEN "Image_Live"."Bildunterschrift" ELSE NULL END AS "Bildunterschrift", CASE WHEN "File_Live"."ClassName" IN ('SilverStripe\\Assets\\File', 'SilverStripe\\Assets\\Folder', 'SilverStripe\\Assets\\Image', 'WeDevelop\\SvgImage\\Assets\\Svg') THEN "File_Live"."AltText" WHEN "File_Live"."ClassName" IN ('SilverStripe\\Assets\\Image', 'WeDevelop\\SvgImage\\Assets\\Svg') THEN "Image_Live"."AltText" WHEN "File_Live"."ClassName" IN ('SilverStripe\\Assets\\Image', 'WeDevelop\\SvgImage\\Assets\\Svg') THEN "Image_Live"."AltText" ELSE NULL END AS "AltText", "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.0006s
0019: SELECT DISTINCT "File_Live"."ClassName", "File_Live"."LastEdited", "File_Live"."Created", CASE WHEN "File_Live"."ClassName" IN ('SilverStripe\\Assets\\File', 'SilverStripe\\Assets\\Folder', 'SilverStripe\\Assets\\Image', 'WeDevelop\\SvgImage\\Assets\\Svg') THEN "File_Live"."Copyright" WHEN "File_Live"."ClassName" IN ('SilverStripe\\Assets\\Image', 'WeDevelop\\SvgImage\\Assets\\Svg') THEN "Image_Live"."Copyright" WHEN "File_Live"."ClassName" IN ('SilverStripe\\Assets\\Image', 'WeDevelop\\SvgImage\\Assets\\Svg') THEN "Image_Live"."Copyright" ELSE NULL END AS "Copyright", CASE WHEN "File_Live"."ClassName" IN ('SilverStripe\\Assets\\File', 'SilverStripe\\Assets\\Folder', 'SilverStripe\\Assets\\Image', 'WeDevelop\\SvgImage\\Assets\\Svg') THEN "File_Live"."Bildunterschrift" WHEN "File_Live"."ClassName" IN ('SilverStripe\\Assets\\Image', 'WeDevelop\\SvgImage\\Assets\\Svg') THEN "Image_Live"."Bildunterschrift" WHEN "File_Live"."ClassName" IN ('SilverStripe\\Assets\\Image', 'WeDevelop\\SvgImage\\Assets\\Svg') THEN "Image_Live"."Bildunterschrift" ELSE NULL END AS "Bildunterschrift", CASE WHEN "File_Live"."ClassName" IN ('SilverStripe\\Assets\\File', 'SilverStripe\\Assets\\Folder', 'SilverStripe\\Assets\\Image', 'WeDevelop\\SvgImage\\Assets\\Svg') THEN "File_Live"."AltText" WHEN "File_Live"."ClassName" IN ('SilverStripe\\Assets\\Image', 'WeDevelop\\SvgImage\\Assets\\Svg') THEN "Image_Live"."AltText" WHEN "File_Live"."ClassName" IN ('SilverStripe\\Assets\\Image', 'WeDevelop\\SvgImage\\Assets\\Svg') THEN "Image_Live"."AltText" ELSE NULL END AS "AltText", "File_Live"."Version", "File_Live"."CanViewType", "File_Live"."CanEditType", "File_Live"."Name", "File_Live"."Title", "File_Live"."ShowInSearch", "File_Live"."ParentID", "File_Live"."OwnerID", "File_Live"."FileHash", "File_Live"."FileFilename", "File_Live"."FileVariant", "Image_Live"."FocusPointX", "Image_Live"."FocusPointY", "Image_Live"."FocusPointWidth", "Image_Live"."FocusPointHeight", "File_Live"."ID",
CASE WHEN "File_Live"."ClassName" IS NOT NULL THEN "File_Live"."ClassName"
ELSE 'SilverStripe\\Assets\\File' END AS "RecordClassName"
FROM "File_Live" LEFT JOIN "Image_Live" ON "Image_Live"."ID" = "File_Live"."ID"
WHERE ("File_Live"."ID" = ?)
AND ("File_Live"."ClassName" IN (?, ?))
ORDER BY "File_Live"."Name" ASC
LIMIT 1
0.0004s
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", CASE
WHEN "Page_Localised_de_DE"."ID" IS NOT NULL THEN "Page_Localised_de_DE"."ChapterTitle"
ELSE "Page_Live"."ChapterTitle" END
AS "ChapterTitle", CASE
WHEN "Page_Localised_de_DE"."ID" IS NOT NULL THEN "Page_Localised_de_DE"."BetterTitle"
ELSE "Page_Live"."BetterTitle" END
AS "BetterTitle", CASE
WHEN "Page_Localised_de_DE"."ID" IS NOT NULL THEN "Page_Localised_de_DE"."TeaserText"
ELSE "Page_Live"."TeaserText" END
AS "TeaserText", "Page_Live"."NoTeaser", "Page_Live"."NoBookmark", "Page_Live"."ImageID", "SiteTree_Live"."ID",
CASE WHEN "SiteTree_Live"."ClassName" IS NOT NULL THEN "SiteTree_Live"."ClassName"
ELSE 'SilverStripe\\CMS\\Model\\SiteTree' END AS "RecordClassName", 'de_DE' AS "Locale", CASE WHEN "Page_Localised_de_DE"."ID" IS NOT NULL THEN 'de_DE'
ELSE NULL END AS "SourceLocale"
FROM "SiteTree_Live" LEFT JOIN "Page_Live" ON "Page_Live"."ID" = "SiteTree_Live"."ID" LEFT JOIN "SiteTree_Localised_Live" AS "SiteTree_Localised_de_DE" ON "SiteTree_Live"."ID" = "SiteTree_Localised_de_DE"."RecordID" AND "SiteTree_Localised_de_DE"."Locale" = ? LEFT JOIN "Page_Localised_Live" AS "Page_Localised_de_DE" ON "Page_Live"."ID" = "Page_Localised_de_DE"."RecordID" AND "Page_Localised_de_DE"."Locale" = ?
WHERE ("SiteTree_Live"."ClassName" IN (?))
AND (("SiteTree_Localised_de_DE"."ID" IS NOT NULL))
ORDER BY "SiteTree_Live"."Sort" ASC
LIMIT 1
0.0011s
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", CASE
WHEN "Page_Localised_de_DE"."ID" IS NOT NULL THEN "Page_Localised_de_DE"."ChapterTitle"
ELSE "Page_Live"."ChapterTitle" END
AS "ChapterTitle", CASE
WHEN "Page_Localised_de_DE"."ID" IS NOT NULL THEN "Page_Localised_de_DE"."BetterTitle"
ELSE "Page_Live"."BetterTitle" END
AS "BetterTitle", CASE
WHEN "Page_Localised_de_DE"."ID" IS NOT NULL THEN "Page_Localised_de_DE"."TeaserText"
ELSE "Page_Live"."TeaserText" END
AS "TeaserText", "Page_Live"."NoTeaser", "Page_Live"."NoBookmark", "Page_Live"."ImageID", "BlockPage_Live"."ElementalAreaID", "SiteTree_Live"."ID",
CASE WHEN "SiteTree_Live"."ClassName" IS NOT NULL THEN "SiteTree_Live"."ClassName"
ELSE 'SilverStripe\\CMS\\Model\\SiteTree' END AS "RecordClassName", 'de_DE' AS "Locale", CASE WHEN "Page_Localised_de_DE"."ID" IS NOT NULL THEN 'de_DE'
ELSE NULL END AS "SourceLocale"
FROM "SiteTree_Live" LEFT JOIN "Page_Live" ON "Page_Live"."ID" = "SiteTree_Live"."ID" LEFT JOIN "BlockPage_Live" ON "BlockPage_Live"."ID" = "SiteTree_Live"."ID" LEFT JOIN "SiteTree_Localised_Live" AS "SiteTree_Localised_de_DE" ON "SiteTree_Live"."ID" = "SiteTree_Localised_de_DE"."RecordID" AND "SiteTree_Localised_de_DE"."Locale" = ? LEFT JOIN "Page_Localised_Live" AS "Page_Localised_de_DE" ON "Page_Live"."ID" = "Page_Localised_de_DE"."RecordID" AND "Page_Localised_de_DE"."Locale" = ?
WHERE ("SiteTree_Live"."ID" = ?)
AND ("SiteTree_Live"."ClassName" IN (?))
AND (("SiteTree_Localised_de_DE"."ID" IS NOT NULL))
ORDER BY "SiteTree_Live"."Sort" ASC
LIMIT 1
0.0007s
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.0004s
0023: SELECT DISTINCT "Fluent_FallbackLocale"."ClassName", "Fluent_FallbackLocale"."LastEdited", "Fluent_FallbackLocale"."Created", "Fluent_FallbackLocale"."Sort", "Fluent_FallbackLocale"."ParentID", "Fluent_FallbackLocale"."LocaleID", "Fluent_FallbackLocale"."ID",
CASE WHEN "Fluent_FallbackLocale"."ClassName" IS NOT NULL THEN "Fluent_FallbackLocale"."ClassName"
ELSE 'TractorCow\\Fluent\\Model\\FallbackLocale' END AS "RecordClassName"
FROM "Fluent_FallbackLocale"
WHERE ("Fluent_FallbackLocale"."ParentID" = ?)
ORDER BY "Fluent_FallbackLocale"."Sort" ASC
0.0003s
0024: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", CASE
WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."BetterSiteTitle"
ELSE "SiteTree_Live"."BetterSiteTitle" END
AS "BetterSiteTitle", CASE
WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."Keyword"
ELSE "SiteTree_Live"."Keyword" END
AS "Keyword", CASE
WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."FeaturedKeyword"
ELSE "SiteTree_Live"."FeaturedKeyword" END
AS "FeaturedKeyword", CASE
WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."KeywordQuestion"
ELSE "SiteTree_Live"."KeywordQuestion" END
AS "KeywordQuestion", "SiteTree_Live"."Follow", "SiteTree_Live"."FollowType", CASE
WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."GenMetaDesc"
ELSE "SiteTree_Live"."GenMetaDesc" END
AS "GenMetaDesc", CASE
WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."FBTitle"
ELSE "SiteTree_Live"."FBTitle" END
AS "FBTitle", CASE
WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."FBDescription"
ELSE "SiteTree_Live"."FBDescription" END
AS "FBDescription", "SiteTree_Live"."FBType", "SiteTree_Live"."FBTypeOverride", CASE
WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."TwTitle"
ELSE "SiteTree_Live"."TwTitle" END
AS "TwTitle", CASE
WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."TwDescription"
ELSE "SiteTree_Live"."TwDescription" END
AS "TwDescription", "SiteTree_Live"."CanViewType", "SiteTree_Live"."CanEditType", "SiteTree_Live"."Version", CASE
WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."URLSegment"
ELSE "SiteTree_Live"."URLSegment" END
AS "URLSegment", CASE
WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."Title"
ELSE "SiteTree_Live"."Title" END
AS "Title", CASE
WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."MenuTitle"
ELSE "SiteTree_Live"."MenuTitle" END
AS "MenuTitle", CASE
WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."Content"
ELSE "SiteTree_Live"."Content" END
AS "Content", CASE
WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."MetaDescription"
ELSE "SiteTree_Live"."MetaDescription" END
AS "MetaDescription", "SiteTree_Live"."ExtraMeta", "SiteTree_Live"."ShowInMenus", "SiteTree_Live"."ShowInSearch", "SiteTree_Live"."Sort", "SiteTree_Live"."HasBrokenFile", "SiteTree_Live"."HasBrokenLink", CASE
WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."ReportClass"
ELSE "SiteTree_Live"."ReportClass" END
AS "ReportClass", "SiteTree_Live"."CanonicalLinkID", "SiteTree_Live"."FBImageID", "SiteTree_Live"."TwImageID", "SiteTree_Live"."ParentID", CASE
WHEN "Page_Localised_en_GB"."ID" IS NOT NULL THEN "Page_Localised_en_GB"."ChapterTitle"
ELSE "Page_Live"."ChapterTitle" END
AS "ChapterTitle", CASE
WHEN "Page_Localised_en_GB"."ID" IS NOT NULL THEN "Page_Localised_en_GB"."BetterTitle"
ELSE "Page_Live"."BetterTitle" END
AS "BetterTitle", CASE
WHEN "Page_Localised_en_GB"."ID" IS NOT NULL THEN "Page_Localised_en_GB"."TeaserText"
ELSE "Page_Live"."TeaserText" END
AS "TeaserText", "Page_Live"."NoTeaser", "Page_Live"."NoBookmark", "Page_Live"."ImageID", "BlockPage_Live"."ElementalAreaID", "SiteTree_Live"."ID",
CASE WHEN "SiteTree_Live"."ClassName" IS NOT NULL THEN "SiteTree_Live"."ClassName"
ELSE 'SilverStripe\\CMS\\Model\\SiteTree' END AS "RecordClassName", 'en_GB' AS "Locale", CASE WHEN "Page_Localised_en_GB"."ID" IS NOT NULL THEN 'en_GB'
ELSE NULL END AS "SourceLocale"
FROM "SiteTree_Live" LEFT JOIN "Page_Live" ON "Page_Live"."ID" = "SiteTree_Live"."ID" LEFT JOIN "BlockPage_Live" ON "BlockPage_Live"."ID" = "SiteTree_Live"."ID" LEFT JOIN "SiteTree_Localised_Live" AS "SiteTree_Localised_en_GB" ON "SiteTree_Live"."ID" = "SiteTree_Localised_en_GB"."RecordID" AND "SiteTree_Localised_en_GB"."Locale" = ? LEFT JOIN "Page_Localised_Live" AS "Page_Localised_en_GB" ON "Page_Live"."ID" = "Page_Localised_en_GB"."RecordID" AND "Page_Localised_en_GB"."Locale" = ?
WHERE ("SiteTree_Live"."ID" = ?)
AND ("SiteTree_Live"."ClassName" IN (?))
AND (("SiteTree_Localised_en_GB"."ID" IS NOT NULL))
ORDER BY "SiteTree_Live"."Sort" ASC
LIMIT 1
0.0007s
0025: SELECT DISTINCT "Fluent_FallbackLocale"."ClassName", "Fluent_FallbackLocale"."LastEdited", "Fluent_FallbackLocale"."Created", "Fluent_FallbackLocale"."Sort", "Fluent_FallbackLocale"."ParentID", "Fluent_FallbackLocale"."LocaleID", "Fluent_FallbackLocale"."ID",
CASE WHEN "Fluent_FallbackLocale"."ClassName" IS NOT NULL THEN "Fluent_FallbackLocale"."ClassName"
ELSE 'TractorCow\\Fluent\\Model\\FallbackLocale' END AS "RecordClassName"
FROM "Fluent_FallbackLocale"
WHERE ("Fluent_FallbackLocale"."ParentID" = ?)
ORDER BY "Fluent_FallbackLocale"."Sort" ASC
0.0003s
0026: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", CASE
WHEN "SiteTree_Localised_he_IL"."ID" IS NOT NULL THEN "SiteTree_Localised_he_IL"."BetterSiteTitle"
ELSE "SiteTree_Live"."BetterSiteTitle" END
AS "BetterSiteTitle", CASE
WHEN "SiteTree_Localised_he_IL"."ID" IS NOT NULL THEN "SiteTree_Localised_he_IL"."Keyword"
ELSE "SiteTree_Live"."Keyword" END
AS "Keyword", CASE
WHEN "SiteTree_Localised_he_IL"."ID" IS NOT NULL THEN "SiteTree_Localised_he_IL"."FeaturedKeyword"
ELSE "SiteTree_Live"."FeaturedKeyword" END
AS "FeaturedKeyword", CASE
WHEN "SiteTree_Localised_he_IL"."ID" IS NOT NULL THEN "SiteTree_Localised_he_IL"."KeywordQuestion"
ELSE "SiteTree_Live"."KeywordQuestion" END
AS "KeywordQuestion", "SiteTree_Live"."Follow", "SiteTree_Live"."FollowType", CASE
WHEN "SiteTree_Localised_he_IL"."ID" IS NOT NULL THEN "SiteTree_Localised_he_IL"."GenMetaDesc"
ELSE "SiteTree_Live"."GenMetaDesc" END
AS "GenMetaDesc", CASE
WHEN "SiteTree_Localised_he_IL"."ID" IS NOT NULL THEN "SiteTree_Localised_he_IL"."FBTitle"
ELSE "SiteTree_Live"."FBTitle" END
AS "FBTitle", CASE
WHEN "SiteTree_Localised_he_IL"."ID" IS NOT NULL THEN "SiteTree_Localised_he_IL"."FBDescription"
ELSE "SiteTree_Live"."FBDescription" END
AS "FBDescription", "SiteTree_Live"."FBType", "SiteTree_Live"."FBTypeOverride", CASE
WHEN "SiteTree_Localised_he_IL"."ID" IS NOT NULL THEN "SiteTree_Localised_he_IL"."TwTitle"
ELSE "SiteTree_Live"."TwTitle" END
AS "TwTitle", CASE
WHEN "SiteTree_Localised_he_IL"."ID" IS NOT NULL THEN "SiteTree_Localised_he_IL"."TwDescription"
ELSE "SiteTree_Live"."TwDescription" END
AS "TwDescription", "SiteTree_Live"."CanViewType", "SiteTree_Live"."CanEditType", "SiteTree_Live"."Version", CASE
WHEN "SiteTree_Localised_he_IL"."ID" IS NOT NULL THEN "SiteTree_Localised_he_IL"."URLSegment"
ELSE "SiteTree_Live"."URLSegment" END
AS "URLSegment", CASE
WHEN "SiteTree_Localised_he_IL"."ID" IS NOT NULL THEN "SiteTree_Localised_he_IL"."Title"
ELSE "SiteTree_Live"."Title" END
AS "Title", CASE
WHEN "SiteTree_Localised_he_IL"."ID" IS NOT NULL THEN "SiteTree_Localised_he_IL"."MenuTitle"
ELSE "SiteTree_Live"."MenuTitle" END
AS "MenuTitle", CASE
WHEN "SiteTree_Localised_he_IL"."ID" IS NOT NULL THEN "SiteTree_Localised_he_IL"."Content"
ELSE "SiteTree_Live"."Content" END
AS "Content", CASE
WHEN "SiteTree_Localised_he_IL"."ID" IS NOT NULL THEN "SiteTree_Localised_he_IL"."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_he_IL"."ID" IS NOT NULL THEN "SiteTree_Localised_he_IL"."ReportClass"
ELSE "SiteTree_Live"."ReportClass" END
AS "ReportClass", "SiteTree_Live"."CanonicalLinkID", "SiteTree_Live"."FBImageID", "SiteTree_Live"."TwImageID", "SiteTree_Live"."ParentID", CASE
WHEN "Page_Localised_he_IL"."ID" IS NOT NULL THEN "Page_Localised_he_IL"."ChapterTitle"
ELSE "Page_Live"."ChapterTitle" END
AS "ChapterTitle", CASE
WHEN "Page_Localised_he_IL"."ID" IS NOT NULL THEN "Page_Localised_he_IL"."BetterTitle"
ELSE "Page_Live"."BetterTitle" END
AS "BetterTitle", CASE
WHEN "Page_Localised_he_IL"."ID" IS NOT NULL THEN "Page_Localised_he_IL"."TeaserText"
ELSE "Page_Live"."TeaserText" END
AS "TeaserText", "Page_Live"."NoTeaser", "Page_Live"."NoBookmark", "Page_Live"."ImageID", "BlockPage_Live"."ElementalAreaID", "SiteTree_Live"."ID",
CASE WHEN "SiteTree_Live"."ClassName" IS NOT NULL THEN "SiteTree_Live"."ClassName"
ELSE 'SilverStripe\\CMS\\Model\\SiteTree' END AS "RecordClassName", 'he_IL' AS "Locale", CASE WHEN "Page_Localised_he_IL"."ID" IS NOT NULL THEN 'he_IL'
ELSE NULL END AS "SourceLocale"
FROM "SiteTree_Live" LEFT JOIN "Page_Live" ON "Page_Live"."ID" = "SiteTree_Live"."ID" LEFT JOIN "BlockPage_Live" ON "BlockPage_Live"."ID" = "SiteTree_Live"."ID" LEFT JOIN "SiteTree_Localised_Live" AS "SiteTree_Localised_he_IL" ON "SiteTree_Live"."ID" = "SiteTree_Localised_he_IL"."RecordID" AND "SiteTree_Localised_he_IL"."Locale" = ? LEFT JOIN "Page_Localised_Live" AS "Page_Localised_he_IL" ON "Page_Live"."ID" = "Page_Localised_he_IL"."RecordID" AND "Page_Localised_he_IL"."Locale" = ?
WHERE ("SiteTree_Live"."ID" = ?)
AND ("SiteTree_Live"."ClassName" IN (?))
AND (("SiteTree_Localised_he_IL"."ID" IS NOT NULL))
ORDER BY "SiteTree_Live"."Sort" ASC
LIMIT 1
0.0007s
0027: SELECT DISTINCT "Fluent_FallbackLocale"."ClassName", "Fluent_FallbackLocale"."LastEdited", "Fluent_FallbackLocale"."Created", "Fluent_FallbackLocale"."Sort", "Fluent_FallbackLocale"."ParentID", "Fluent_FallbackLocale"."LocaleID", "Fluent_FallbackLocale"."ID",
CASE WHEN "Fluent_FallbackLocale"."ClassName" IS NOT NULL THEN "Fluent_FallbackLocale"."ClassName"
ELSE 'TractorCow\\Fluent\\Model\\FallbackLocale' END AS "RecordClassName"
FROM "Fluent_FallbackLocale"
WHERE ("Fluent_FallbackLocale"."ParentID" = ?)
ORDER BY "Fluent_FallbackLocale"."Sort" ASC
0.0003s
0028: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", CASE
WHEN "SiteTree_Localised_nl_NL"."ID" IS NOT NULL THEN "SiteTree_Localised_nl_NL"."BetterSiteTitle"
ELSE "SiteTree_Live"."BetterSiteTitle" END
AS "BetterSiteTitle", CASE
WHEN "SiteTree_Localised_nl_NL"."ID" IS NOT NULL THEN "SiteTree_Localised_nl_NL"."Keyword"
ELSE "SiteTree_Live"."Keyword" END
AS "Keyword", CASE
WHEN "SiteTree_Localised_nl_NL"."ID" IS NOT NULL THEN "SiteTree_Localised_nl_NL"."FeaturedKeyword"
ELSE "SiteTree_Live"."FeaturedKeyword" END
AS "FeaturedKeyword", CASE
WHEN "SiteTree_Localised_nl_NL"."ID" IS NOT NULL THEN "SiteTree_Localised_nl_NL"."KeywordQuestion"
ELSE "SiteTree_Live"."KeywordQuestion" END
AS "KeywordQuestion", "SiteTree_Live"."Follow", "SiteTree_Live"."FollowType", CASE
WHEN "SiteTree_Localised_nl_NL"."ID" IS NOT NULL THEN "SiteTree_Localised_nl_NL"."GenMetaDesc"
ELSE "SiteTree_Live"."GenMetaDesc" END
AS "GenMetaDesc", CASE
WHEN "SiteTree_Localised_nl_NL"."ID" IS NOT NULL THEN "SiteTree_Localised_nl_NL"."FBTitle"
ELSE "SiteTree_Live"."FBTitle" END
AS "FBTitle", CASE
WHEN "SiteTree_Localised_nl_NL"."ID" IS NOT NULL THEN "SiteTree_Localised_nl_NL"."FBDescription"
ELSE "SiteTree_Live"."FBDescription" END
AS "FBDescription", "SiteTree_Live"."FBType", "SiteTree_Live"."FBTypeOverride", CASE
WHEN "SiteTree_Localised_nl_NL"."ID" IS NOT NULL THEN "SiteTree_Localised_nl_NL"."TwTitle"
ELSE "SiteTree_Live"."TwTitle" END
AS "TwTitle", CASE
WHEN "SiteTree_Localised_nl_NL"."ID" IS NOT NULL THEN "SiteTree_Localised_nl_NL"."TwDescription"
ELSE "SiteTree_Live"."TwDescription" END
AS "TwDescription", "SiteTree_Live"."CanViewType", "SiteTree_Live"."CanEditType", "SiteTree_Live"."Version", CASE
WHEN "SiteTree_Localised_nl_NL"."ID" IS NOT NULL THEN "SiteTree_Localised_nl_NL"."URLSegment"
ELSE "SiteTree_Live"."URLSegment" END
AS "URLSegment", CASE
WHEN "SiteTree_Localised_nl_NL"."ID" IS NOT NULL THEN "SiteTree_Localised_nl_NL"."Title"
ELSE "SiteTree_Live"."Title" END
AS "Title", CASE
WHEN "SiteTree_Localised_nl_NL"."ID" IS NOT NULL THEN "SiteTree_Localised_nl_NL"."MenuTitle"
ELSE "SiteTree_Live"."MenuTitle" END
AS "MenuTitle", CASE
WHEN "SiteTree_Localised_nl_NL"."ID" IS NOT NULL THEN "SiteTree_Localised_nl_NL"."Content"
ELSE "SiteTree_Live"."Content" END
AS "Content", CASE
WHEN "SiteTree_Localised_nl_NL"."ID" IS NOT NULL THEN "SiteTree_Localised_nl_NL"."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_nl_NL"."ID" IS NOT NULL THEN "SiteTree_Localised_nl_NL"."ReportClass"
ELSE "SiteTree_Live"."ReportClass" END
AS "ReportClass", "SiteTree_Live"."CanonicalLinkID", "SiteTree_Live"."FBImageID", "SiteTree_Live"."TwImageID", "SiteTree_Live"."ParentID", CASE
WHEN "Page_Localised_nl_NL"."ID" IS NOT NULL THEN "Page_Localised_nl_NL"."ChapterTitle"
ELSE "Page_Live"."ChapterTitle" END
AS "ChapterTitle", CASE
WHEN "Page_Localised_nl_NL"."ID" IS NOT NULL THEN "Page_Localised_nl_NL"."BetterTitle"
ELSE "Page_Live"."BetterTitle" END
AS "BetterTitle", CASE
WHEN "Page_Localised_nl_NL"."ID" IS NOT NULL THEN "Page_Localised_nl_NL"."TeaserText"
ELSE "Page_Live"."TeaserText" END
AS "TeaserText", "Page_Live"."NoTeaser", "Page_Live"."NoBookmark", "Page_Live"."ImageID", "BlockPage_Live"."ElementalAreaID", "SiteTree_Live"."ID",
CASE WHEN "SiteTree_Live"."ClassName" IS NOT NULL THEN "SiteTree_Live"."ClassName"
ELSE 'SilverStripe\\CMS\\Model\\SiteTree' END AS "RecordClassName", 'nl_NL' AS "Locale", CASE WHEN "Page_Localised_nl_NL"."ID" IS NOT NULL THEN 'nl_NL'
ELSE NULL END AS "SourceLocale"
FROM "SiteTree_Live" LEFT JOIN "Page_Live" ON "Page_Live"."ID" = "SiteTree_Live"."ID" LEFT JOIN "BlockPage_Live" ON "BlockPage_Live"."ID" = "SiteTree_Live"."ID" LEFT JOIN "SiteTree_Localised_Live" AS "SiteTree_Localised_nl_NL" ON "SiteTree_Live"."ID" = "SiteTree_Localised_nl_NL"."RecordID" AND "SiteTree_Localised_nl_NL"."Locale" = ? LEFT JOIN "Page_Localised_Live" AS "Page_Localised_nl_NL" ON "Page_Live"."ID" = "Page_Localised_nl_NL"."RecordID" AND "Page_Localised_nl_NL"."Locale" = ?
WHERE ("SiteTree_Live"."ID" = ?)
AND ("SiteTree_Live"."ClassName" IN (?))
AND (("SiteTree_Localised_nl_NL"."ID" IS NOT NULL))
ORDER BY "SiteTree_Live"."Sort" ASC
LIMIT 1
0.0007s
0029: SELECT CASE WHEN EXISTS(SELECT *
FROM "MenuSet"
WHERE ("MenuSet"."Name" = ?)) THEN 1 ELSE 0 END
0.0002s
0030: 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
0031: 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
0032: SELECT DISTINCT "MenuItem"."ClassName", "MenuItem"."LastEdited", "MenuItem"."Created", "MenuItem"."SubMenuID", "MenuItem"."IsHeadline", CASE
WHEN "MenuItem_Localised_de_DE"."ID" IS NOT NULL THEN "MenuItem_Localised_de_DE"."MenuTitle"
ELSE "MenuItem"."MenuTitle" END
AS "MenuTitle", CASE
WHEN "MenuItem_Localised_de_DE"."ID" IS NOT NULL THEN "MenuItem_Localised_de_DE"."Link"
ELSE "MenuItem"."Link" END
AS "Link", "MenuItem"."Sort", "MenuItem"."IsNewWindow", "MenuItem"."Anchor", "MenuItem"."ImageID", "MenuItem"."SVGItemID", "MenuItem"."PageID", "MenuItem"."MenuSetID", "MenuItem"."FileID", "MenuItem"."ID",
CASE WHEN "MenuItem"."ClassName" IS NOT NULL THEN "MenuItem"."ClassName"
ELSE 'Heyday\\MenuManager\\MenuItem' END AS "RecordClassName", 'de_DE' AS "Locale", CASE WHEN "MenuItem_Localised_de_DE"."ID" IS NOT NULL THEN 'de_DE'
ELSE NULL END AS "SourceLocale"
FROM "MenuItem" LEFT JOIN "MenuItem_Localised" AS "MenuItem_Localised_de_DE" ON "MenuItem"."ID" = "MenuItem_Localised_de_DE"."RecordID" AND "MenuItem_Localised_de_DE"."Locale" = ?
WHERE ("MenuItem"."MenuSetID" = ?)
AND (("MenuItem_Localised_de_DE"."ID" IS NOT NULL))
ORDER BY "MenuItem"."Sort" ASC
0.0006s
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.0005s
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.0004s
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.0005s
0036: SELECT CASE WHEN EXISTS(SELECT *
FROM "MenuSet"
WHERE ("MenuSet"."Name" = ?)) THEN 1 ELSE 0 END
0.0003s
0037: SELECT DISTINCT "MenuSet"."ClassName", "MenuSet"."LastEdited", "MenuSet"."Created", "MenuSet"."Name", "MenuSet"."Description", "MenuSet"."Sort", "MenuSet"."ID",
CASE WHEN "MenuSet"."ClassName" IS NOT NULL THEN "MenuSet"."ClassName"
ELSE 'Heyday\\MenuManager\\MenuSet' END AS "RecordClassName"
FROM "MenuSet"
WHERE ("MenuSet"."Name" = ?)
ORDER BY "MenuSet"."Sort" ASC
LIMIT 1
0.0003s
0038: 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
0039: SELECT DISTINCT "MenuItem"."ClassName", "MenuItem"."LastEdited", "MenuItem"."Created", "MenuItem"."SubMenuID", "MenuItem"."IsHeadline", CASE
WHEN "MenuItem_Localised_de_DE"."ID" IS NOT NULL THEN "MenuItem_Localised_de_DE"."MenuTitle"
ELSE "MenuItem"."MenuTitle" END
AS "MenuTitle", CASE
WHEN "MenuItem_Localised_de_DE"."ID" IS NOT NULL THEN "MenuItem_Localised_de_DE"."Link"
ELSE "MenuItem"."Link" END
AS "Link", "MenuItem"."Sort", "MenuItem"."IsNewWindow", "MenuItem"."Anchor", "MenuItem"."ImageID", "MenuItem"."SVGItemID", "MenuItem"."PageID", "MenuItem"."MenuSetID", "MenuItem"."FileID", "MenuItem"."ID",
CASE WHEN "MenuItem"."ClassName" IS NOT NULL THEN "MenuItem"."ClassName"
ELSE 'Heyday\\MenuManager\\MenuItem' END AS "RecordClassName", 'de_DE' AS "Locale", CASE WHEN "MenuItem_Localised_de_DE"."ID" IS NOT NULL THEN 'de_DE'
ELSE NULL END AS "SourceLocale"
FROM "MenuItem" LEFT JOIN "MenuItem_Localised" AS "MenuItem_Localised_de_DE" ON "MenuItem"."ID" = "MenuItem_Localised_de_DE"."RecordID" AND "MenuItem_Localised_de_DE"."Locale" = ?
WHERE ("MenuItem"."MenuSetID" = ?)
AND (("MenuItem_Localised_de_DE"."ID" IS NOT NULL))
ORDER BY "MenuItem"."Sort" ASC
0.0006s
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.0005s
0041: 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.0005s
0042: SELECT CASE WHEN EXISTS(SELECT *
FROM "MenuSet"
WHERE ("MenuSet"."Name" = ?)) THEN 1 ELSE 0 END
0.0002s
0043: SELECT DISTINCT "MenuSet"."ClassName", "MenuSet"."LastEdited", "MenuSet"."Created", "MenuSet"."Name", "MenuSet"."Description", "MenuSet"."Sort", "MenuSet"."ID",
CASE WHEN "MenuSet"."ClassName" IS NOT NULL THEN "MenuSet"."ClassName"
ELSE 'Heyday\\MenuManager\\MenuSet' END AS "RecordClassName"
FROM "MenuSet"
WHERE ("MenuSet"."Name" = ?)
ORDER BY "MenuSet"."Sort" ASC
LIMIT 1
0.0003s
0044: 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
0045: SELECT DISTINCT "MenuItem"."ClassName", "MenuItem"."LastEdited", "MenuItem"."Created", "MenuItem"."SubMenuID", "MenuItem"."IsHeadline", CASE
WHEN "MenuItem_Localised_de_DE"."ID" IS NOT NULL THEN "MenuItem_Localised_de_DE"."MenuTitle"
ELSE "MenuItem"."MenuTitle" END
AS "MenuTitle", CASE
WHEN "MenuItem_Localised_de_DE"."ID" IS NOT NULL THEN "MenuItem_Localised_de_DE"."Link"
ELSE "MenuItem"."Link" END
AS "Link", "MenuItem"."Sort", "MenuItem"."IsNewWindow", "MenuItem"."Anchor", "MenuItem"."ImageID", "MenuItem"."SVGItemID", "MenuItem"."PageID", "MenuItem"."MenuSetID", "MenuItem"."FileID", "MenuItem"."ID",
CASE WHEN "MenuItem"."ClassName" IS NOT NULL THEN "MenuItem"."ClassName"
ELSE 'Heyday\\MenuManager\\MenuItem' END AS "RecordClassName", 'de_DE' AS "Locale", CASE WHEN "MenuItem_Localised_de_DE"."ID" IS NOT NULL THEN 'de_DE'
ELSE NULL END AS "SourceLocale"
FROM "MenuItem" LEFT JOIN "MenuItem_Localised" AS "MenuItem_Localised_de_DE" ON "MenuItem"."ID" = "MenuItem_Localised_de_DE"."RecordID" AND "MenuItem_Localised_de_DE"."Locale" = ?
WHERE ("MenuItem"."MenuSetID" = ?)
AND (("MenuItem_Localised_de_DE"."ID" IS NOT NULL))
ORDER BY "MenuItem"."Sort" ASC
0.0005s
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.0005s
0047: SELECT DISTINCT "File_Live"."ClassName", "File_Live"."LastEdited", "File_Live"."Created", CASE WHEN "File_Live"."ClassName" IN ('SilverStripe\\Assets\\File', 'SilverStripe\\Assets\\Folder', 'SilverStripe\\Assets\\Image', 'WeDevelop\\SvgImage\\Assets\\Svg') THEN "File_Live"."Copyright" WHEN "File_Live"."ClassName" IN ('SilverStripe\\Assets\\Image', 'WeDevelop\\SvgImage\\Assets\\Svg') THEN "Image_Live"."Copyright" WHEN "File_Live"."ClassName" IN ('SilverStripe\\Assets\\Image', 'WeDevelop\\SvgImage\\Assets\\Svg') THEN "Image_Live"."Copyright" ELSE NULL END AS "Copyright", CASE WHEN "File_Live"."ClassName" IN ('SilverStripe\\Assets\\File', 'SilverStripe\\Assets\\Folder', 'SilverStripe\\Assets\\Image', 'WeDevelop\\SvgImage\\Assets\\Svg') THEN "File_Live"."Bildunterschrift" WHEN "File_Live"."ClassName" IN ('SilverStripe\\Assets\\Image', 'WeDevelop\\SvgImage\\Assets\\Svg') THEN "Image_Live"."Bildunterschrift" WHEN "File_Live"."ClassName" IN ('SilverStripe\\Assets\\Image', 'WeDevelop\\SvgImage\\Assets\\Svg') THEN "Image_Live"."Bildunterschrift" ELSE NULL END AS "Bildunterschrift", CASE WHEN "File_Live"."ClassName" IN ('SilverStripe\\Assets\\File', 'SilverStripe\\Assets\\Folder', 'SilverStripe\\Assets\\Image', 'WeDevelop\\SvgImage\\Assets\\Svg') THEN "File_Live"."AltText" WHEN "File_Live"."ClassName" IN ('SilverStripe\\Assets\\Image', 'WeDevelop\\SvgImage\\Assets\\Svg') THEN "Image_Live"."AltText" WHEN "File_Live"."ClassName" IN ('SilverStripe\\Assets\\Image', 'WeDevelop\\SvgImage\\Assets\\Svg') THEN "Image_Live"."AltText" ELSE NULL END AS "AltText", "File_Live"."Version", "File_Live"."CanViewType", "File_Live"."CanEditType", "File_Live"."Name", "File_Live"."Title", "File_Live"."ShowInSearch", "File_Live"."ParentID", "File_Live"."OwnerID", "File_Live"."FileHash", "File_Live"."FileFilename", "File_Live"."FileVariant", "Image_Live"."FocusPointX", "Image_Live"."FocusPointY", "Image_Live"."FocusPointWidth", "Image_Live"."FocusPointHeight", "File_Live"."ID",
CASE WHEN "File_Live"."ClassName" IS NOT NULL THEN "File_Live"."ClassName"
ELSE 'SilverStripe\\Assets\\File' END AS "RecordClassName"
FROM "File_Live" LEFT JOIN "Image_Live" ON "Image_Live"."ID" = "File_Live"."ID"
WHERE ("File_Live"."ID" = ?)
AND ("File_Live"."ClassName" IN (?, ?))
ORDER BY "File_Live"."Name" ASC
LIMIT 1
0.0004s
0048: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "BlockPage_Live"."ElementalAreaID", "SiteTree_Live"."ID",
CASE WHEN "SiteTree_Live"."ClassName" IS NOT NULL THEN "SiteTree_Live"."ClassName"
ELSE 'SilverStripe\\CMS\\Model\\SiteTree' END AS "RecordClassName", 'de_DE' AS "Locale", CASE WHEN "Page_Localised_de_DE"."ID" IS NOT NULL THEN 'de_DE'
ELSE NULL END AS "SourceLocale", "SiteTree_Live"."Sort"
FROM "SiteTree_Live" LEFT JOIN "Page_Live" ON "Page_Live"."ID" = "SiteTree_Live"."ID" LEFT JOIN "BlockPage_Live" ON "BlockPage_Live"."ID" = "SiteTree_Live"."ID" LEFT JOIN "SiteTree_Localised_Live" AS "SiteTree_Localised_de_DE" ON "SiteTree_Live"."ID" = "SiteTree_Localised_de_DE"."RecordID" AND "SiteTree_Localised_de_DE"."Locale" = ? LEFT JOIN "Page_Localised_Live" AS "Page_Localised_de_DE" ON "Page_Live"."ID" = "Page_Localised_de_DE"."RecordID" AND "Page_Localised_de_DE"."Locale" = ?
WHERE ("SiteTree_Live"."ID" = ?)
AND ("SiteTree_Live"."ClassName" IN (?))
AND (("SiteTree_Localised_de_DE"."ID" IS NOT NULL))
ORDER BY "SiteTree_Live"."Sort" ASC
LIMIT 1
0.0005s
0049: SELECT DISTINCT "ElementalArea_Live"."ClassName", "ElementalArea_Live"."LastEdited", "ElementalArea_Live"."Created", "ElementalArea_Live"."Version", "ElementalArea_Live"."OwnerClassName", "ElementalArea_Live"."TopPageID", "ElementalArea_Live"."ID",
CASE WHEN "ElementalArea_Live"."ClassName" IS NOT NULL THEN "ElementalArea_Live"."ClassName"
ELSE 'DNADesign\\Elemental\\Models\\ElementalArea' END AS "RecordClassName"
FROM "ElementalArea_Live"
WHERE ("ElementalArea_Live"."ID" = ?)
LIMIT 1
0.0003s
0050: SELECT DISTINCT "Element_Live"."ClassName", "Element_Live"."LastEdited", "Element_Live"."Created", "Element_Live"."AvailableGlobally", CASE
WHEN "Element_Localised_de_DE"."ID" IS NOT NULL THEN "Element_Localised_de_DE"."VirtualLookupTitle"
ELSE "Element_Live"."VirtualLookupTitle" END
AS "VirtualLookupTitle", "Element_Live"."SEOHeadline", CASE
WHEN "Element_Localised_de_DE"."ID" IS NOT NULL THEN "Element_Localised_de_DE"."BetterTitle"
ELSE "Element_Live"."BetterTitle" END
AS "BetterTitle", "Element_Live"."MarginOrPadding", CASE
WHEN "Element_Localised_de_DE"."ID" IS NOT NULL THEN "Element_Localised_de_DE"."AbstandOben"
ELSE "Element_Live"."AbstandOben" END
AS "AbstandOben", CASE
WHEN "Element_Localised_de_DE"."ID" IS NOT NULL THEN "Element_Localised_de_DE"."AbstandUnten"
ELSE "Element_Live"."AbstandUnten" END
AS "AbstandUnten", "Element_Live"."BGColor", "Element_Live"."NoBGColor", "Element_Live"."Version", 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"."ShowTitle", "Element_Live"."Sort", CASE
WHEN "Element_Localised_de_DE"."ID" IS NOT NULL THEN "Element_Localised_de_DE"."ExtraClass"
ELSE "Element_Live"."ExtraClass" END
AS "ExtraClass", CASE
WHEN "Element_Localised_de_DE"."ID" IS NOT NULL THEN "Element_Localised_de_DE"."Style"
ELSE "Element_Live"."Style" END
AS "Style", "Element_Live"."BGImageID", "Element_Live"."TopPageID", "Element_Live"."ParentID", "Element_Live"."ID",
CASE WHEN "Element_Live"."ClassName" IS NOT NULL THEN "Element_Live"."ClassName"
ELSE 'DNADesign\\Elemental\\Models\\BaseElement' END AS "RecordClassName", '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.0008s
0051: SELECT DISTINCT "ElementalArea_Live"."ClassName", "ElementalArea_Live"."LastEdited", "ElementalArea_Live"."Created", "ElementalArea_Live"."Version", "ElementalArea_Live"."OwnerClassName", "ElementalArea_Live"."TopPageID", "ElementalArea_Live"."ID",
CASE WHEN "ElementalArea_Live"."ClassName" IS NOT NULL THEN "ElementalArea_Live"."ClassName"
ELSE 'DNADesign\\Elemental\\Models\\ElementalArea' END AS "RecordClassName"
FROM "ElementalArea_Live"
WHERE ("ElementalArea_Live"."ID" = ?)
LIMIT 1
0.0002s
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 "Page_Localised_de_DE"."ID" IS NOT NULL THEN "Page_Localised_de_DE"."ChapterTitle"
ELSE "Page_Live"."ChapterTitle" END
AS "ChapterTitle", CASE
WHEN "Page_Localised_de_DE"."ID" IS NOT NULL THEN "Page_Localised_de_DE"."BetterTitle"
ELSE "Page_Live"."BetterTitle" END
AS "BetterTitle", CASE
WHEN "Page_Localised_de_DE"."ID" IS NOT NULL THEN "Page_Localised_de_DE"."TeaserText"
ELSE "Page_Live"."TeaserText" END
AS "TeaserText", "Page_Live"."NoTeaser", "Page_Live"."NoBookmark", "Page_Live"."ImageID", "BlockPage_Live"."ElementalAreaID", "SiteTree_Live"."ID",
CASE WHEN "SiteTree_Live"."ClassName" IS NOT NULL THEN "SiteTree_Live"."ClassName"
ELSE 'SilverStripe\\CMS\\Model\\SiteTree' END AS "RecordClassName", 'de_DE' AS "Locale", CASE WHEN "Page_Localised_de_DE"."ID" IS NOT NULL THEN 'de_DE'
ELSE NULL END AS "SourceLocale"
FROM "SiteTree_Live" LEFT JOIN "Page_Live" ON "Page_Live"."ID" = "SiteTree_Live"."ID" LEFT JOIN "BlockPage_Live" ON "BlockPage_Live"."ID" = "SiteTree_Live"."ID" LEFT JOIN "SiteTree_Localised_Live" AS "SiteTree_Localised_de_DE" ON "SiteTree_Live"."ID" = "SiteTree_Localised_de_DE"."RecordID" AND "SiteTree_Localised_de_DE"."Locale" = ? LEFT JOIN "Page_Localised_Live" AS "Page_Localised_de_DE" ON "Page_Live"."ID" = "Page_Localised_de_DE"."RecordID" AND "Page_Localised_de_DE"."Locale" = ?
WHERE ("BlockPage_Live"."ElementalAreaID" = ?)
AND ("SiteTree_Live"."ClassName" = ?)
AND ("SiteTree_Live"."ClassName" IN (?))
AND (("SiteTree_Localised_de_DE"."ID" IS NOT NULL))
ORDER BY "SiteTree_Live"."Sort" ASC
LIMIT 1
0.0011s
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.0003s
0054: SELECT DISTINCT "ElementalArea_Live"."ClassName", "ElementalArea_Live"."LastEdited", "ElementalArea_Live"."Created", "ElementalArea_Live"."Version", "ElementalArea_Live"."OwnerClassName", "ElementalArea_Live"."TopPageID", "ElementalArea_Live"."ID",
CASE WHEN "ElementalArea_Live"."ClassName" IS NOT NULL THEN "ElementalArea_Live"."ClassName"
ELSE 'DNADesign\\Elemental\\Models\\ElementalArea' END AS "RecordClassName"
FROM "ElementalArea_Live"
WHERE ("ElementalArea_Live"."ID" = ?)
LIMIT 1
0.0003s
0055: SELECT CASE WHEN EXISTS(SELECT *
FROM "PersonEntry" INNER JOIN "Element_Persons" ON "Element_Persons"."PersonEntryID" = "PersonEntry"."ID" LEFT JOIN "PersonEntry_Localised" AS "PersonEntry_Localised_de_DE" ON "PersonEntry"."ID" = "PersonEntry_Localised_de_DE"."RecordID" AND "PersonEntry_Localised_de_DE"."Locale" = ?
WHERE ("Element_Persons"."ElementID" = ?)
AND (("PersonEntry_Localised_de_DE"."ID" IS NOT NULL))) THEN 1 ELSE 0 END
0.0004s
0056: SELECT DISTINCT "Element_Live"."ClassName", "Element_Live"."LastEdited", "Element_Live"."Created", CASE
WHEN "ChapterTitleElement_Localised_de_DE"."ID" IS NOT NULL THEN "ChapterTitleElement_Localised_de_DE"."ChapterNumber"
ELSE "ChapterTitleElement_Live"."ChapterNumber" END
AS "ChapterNumber", "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 "ChapterTitleElement_Localised_de_DE"."ID" IS NOT NULL THEN 'de_DE'
ELSE NULL END AS "SourceLocale", "Element_Live"."Sort"
FROM "Element_Live" LEFT JOIN "ChapterTitleElement_Live" ON "ChapterTitleElement_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 "ChapterTitleElement_Localised_Live" AS "ChapterTitleElement_Localised_de_DE" ON "ChapterTitleElement_Live"."ID" = "ChapterTitleElement_Localised_de_DE"."RecordID" AND "ChapterTitleElement_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.0004s
0057: SELECT CASE WHEN EXISTS(SELECT *
FROM "PersonEntry" INNER JOIN "Element_Persons" ON "Element_Persons"."PersonEntryID" = "PersonEntry"."ID" LEFT JOIN "PersonEntry_Localised" AS "PersonEntry_Localised_de_DE" ON "PersonEntry"."ID" = "PersonEntry_Localised_de_DE"."RecordID" AND "PersonEntry_Localised_de_DE"."Locale" = ?
WHERE ("Element_Persons"."ElementID" = ?)
AND (("PersonEntry_Localised_de_DE"."ID" IS NOT NULL))) THEN 1 ELSE 0 END
0.0003s
0058: SELECT "PersonEntry"."ID", "PersonEntry"."Name" AS "_SortColumn0"
FROM "PersonEntry" INNER JOIN "Element_Persons" ON "Element_Persons"."PersonEntryID" = "PersonEntry"."ID" LEFT JOIN "PersonEntry_Localised" AS "PersonEntry_Localised_de_DE" ON "PersonEntry"."ID" = "PersonEntry_Localised_de_DE"."RecordID" AND "PersonEntry_Localised_de_DE"."Locale" = ?
WHERE ("Element_Persons"."ElementID" = ?)
AND (("PersonEntry_Localised_de_DE"."ID" IS NOT NULL))
ORDER BY "_SortColumn0" ASC
0.0003s
0059: SELECT DISTINCT count(DISTINCT "PersonEntry"."ID") AS "Count"
FROM "PersonEntry" INNER JOIN "Element_Persons" ON "Element_Persons"."PersonEntryID" = "PersonEntry"."ID" LEFT JOIN "PersonEntry_Localised" AS "PersonEntry_Localised_de_DE" ON "PersonEntry"."ID" = "PersonEntry_Localised_de_DE"."RecordID" AND "PersonEntry_Localised_de_DE"."Locale" = ?
WHERE ("Element_Persons"."ElementID" = ?)
AND (("PersonEntry_Localised_de_DE"."ID" IS NOT NULL))
0.0003s
0060: SELECT DISTINCT "PersonEntry"."ClassName", "PersonEntry"."LastEdited", "PersonEntry"."Created", "PersonEntry"."SortOrder", CASE
WHEN "PersonEntry_Localised_de_DE"."ID" IS NOT NULL THEN "PersonEntry_Localised_de_DE"."Name"
ELSE "PersonEntry"."Name" END
AS "Name", CASE
WHEN "PersonEntry_Localised_de_DE"."ID" IS NOT NULL THEN "PersonEntry_Localised_de_DE"."Color"
ELSE "PersonEntry"."Color" END
AS "Color", "PersonEntry"."ImageID", "PersonEntry"."ID",
CASE WHEN "PersonEntry"."ClassName" IS NOT NULL THEN "PersonEntry"."ClassName"
ELSE 'App\\Models\\PersonEntry' END AS "RecordClassName", 'de_DE' AS "Locale", CASE WHEN "PersonEntry_Localised_de_DE"."ID" IS NOT NULL THEN 'de_DE'
ELSE NULL END AS "SourceLocale"
FROM "PersonEntry" INNER JOIN "Element_Persons" ON "Element_Persons"."PersonEntryID" = "PersonEntry"."ID" LEFT JOIN "PersonEntry_Localised" AS "PersonEntry_Localised_de_DE" ON "PersonEntry"."ID" = "PersonEntry_Localised_de_DE"."RecordID" AND "PersonEntry_Localised_de_DE"."Locale" = ?
WHERE ("Element_Persons"."ElementID" = ?)
AND (("PersonEntry_Localised_de_DE"."ID" IS NOT NULL))
ORDER BY "Name" ASC
LIMIT 1
0.0004s
0061: SELECT DISTINCT count(DISTINCT "File_Live"."ID") AS "Count"
FROM "File_Live" LEFT JOIN "Image_Live" ON "Image_Live"."ID" = "File_Live"."ID" INNER JOIN "ImageGalleryElement_Images" ON "ImageGalleryElement_Images"."ImageID" = "File_Live"."ID"
WHERE ("ImageGalleryElement_Images"."ImageGalleryElementID" = ?)
AND ("File_Live"."ClassName" IN (?, ?))
0.0003s
0062: SELECT DISTINCT "ImageGalleryElement_Images"."SortOrder", "File_Live"."ClassName", "File_Live"."LastEdited", "File_Live"."Created", CASE WHEN "File_Live"."ClassName" IN ('SilverStripe\\Assets\\File', 'SilverStripe\\Assets\\Folder', 'SilverStripe\\Assets\\Image', 'WeDevelop\\SvgImage\\Assets\\Svg') THEN "File_Live"."Copyright" WHEN "File_Live"."ClassName" IN ('SilverStripe\\Assets\\Image', 'WeDevelop\\SvgImage\\Assets\\Svg') THEN "Image_Live"."Copyright" WHEN "File_Live"."ClassName" IN ('SilverStripe\\Assets\\Image', 'WeDevelop\\SvgImage\\Assets\\Svg') THEN "Image_Live"."Copyright" ELSE NULL END AS "Copyright", CASE WHEN "File_Live"."ClassName" IN ('SilverStripe\\Assets\\File', 'SilverStripe\\Assets\\Folder', 'SilverStripe\\Assets\\Image', 'WeDevelop\\SvgImage\\Assets\\Svg') THEN "File_Live"."Bildunterschrift" WHEN "File_Live"."ClassName" IN ('SilverStripe\\Assets\\Image', 'WeDevelop\\SvgImage\\Assets\\Svg') THEN "Image_Live"."Bildunterschrift" WHEN "File_Live"."ClassName" IN ('SilverStripe\\Assets\\Image', 'WeDevelop\\SvgImage\\Assets\\Svg') THEN "Image_Live"."Bildunterschrift" ELSE NULL END AS "Bildunterschrift", CASE WHEN "File_Live"."ClassName" IN ('SilverStripe\\Assets\\File', 'SilverStripe\\Assets\\Folder', 'SilverStripe\\Assets\\Image', 'WeDevelop\\SvgImage\\Assets\\Svg') THEN "File_Live"."AltText" WHEN "File_Live"."ClassName" IN ('SilverStripe\\Assets\\Image', 'WeDevelop\\SvgImage\\Assets\\Svg') THEN "Image_Live"."AltText" WHEN "File_Live"."ClassName" IN ('SilverStripe\\Assets\\Image', 'WeDevelop\\SvgImage\\Assets\\Svg') THEN "Image_Live"."AltText" ELSE NULL END AS "AltText", "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" INNER JOIN "ImageGalleryElement_Images" ON "ImageGalleryElement_Images"."ImageID" = "File_Live"."ID"
WHERE ("ImageGalleryElement_Images"."ImageGalleryElementID" = ?)
AND ("File_Live"."ClassName" IN (?, ?))
ORDER BY "File_Live"."Name" ASC
0.0007s
0063: SELECT CASE WHEN EXISTS(SELECT *
FROM "PersonEntry" INNER JOIN "Element_Persons" ON "Element_Persons"."PersonEntryID" = "PersonEntry"."ID" LEFT JOIN "PersonEntry_Localised" AS "PersonEntry_Localised_de_DE" ON "PersonEntry"."ID" = "PersonEntry_Localised_de_DE"."RecordID" AND "PersonEntry_Localised_de_DE"."Locale" = ?
WHERE ("Element_Persons"."ElementID" = ?)
AND (("PersonEntry_Localised_de_DE"."ID" IS NOT NULL))) THEN 1 ELSE 0 END
0.0004s
0064: SELECT "PersonEntry"."ID", "PersonEntry"."Name" AS "_SortColumn0"
FROM "PersonEntry" INNER JOIN "Element_Persons" ON "Element_Persons"."PersonEntryID" = "PersonEntry"."ID" LEFT JOIN "PersonEntry_Localised" AS "PersonEntry_Localised_de_DE" ON "PersonEntry"."ID" = "PersonEntry_Localised_de_DE"."RecordID" AND "PersonEntry_Localised_de_DE"."Locale" = ?
WHERE ("Element_Persons"."ElementID" = ?)
AND (("PersonEntry_Localised_de_DE"."ID" IS NOT NULL))
ORDER BY "_SortColumn0" ASC
0.0003s
0065: SELECT DISTINCT count(DISTINCT "PersonEntry"."ID") AS "Count"
FROM "PersonEntry" INNER JOIN "Element_Persons" ON "Element_Persons"."PersonEntryID" = "PersonEntry"."ID" LEFT JOIN "PersonEntry_Localised" AS "PersonEntry_Localised_de_DE" ON "PersonEntry"."ID" = "PersonEntry_Localised_de_DE"."RecordID" AND "PersonEntry_Localised_de_DE"."Locale" = ?
WHERE ("Element_Persons"."ElementID" = ?)
AND (("PersonEntry_Localised_de_DE"."ID" IS NOT NULL))
0.0003s
0066: SELECT DISTINCT "PersonEntry"."ClassName", "PersonEntry"."LastEdited", "PersonEntry"."Created", "PersonEntry"."SortOrder", CASE
WHEN "PersonEntry_Localised_de_DE"."ID" IS NOT NULL THEN "PersonEntry_Localised_de_DE"."Name"
ELSE "PersonEntry"."Name" END
AS "Name", CASE
WHEN "PersonEntry_Localised_de_DE"."ID" IS NOT NULL THEN "PersonEntry_Localised_de_DE"."Color"
ELSE "PersonEntry"."Color" END
AS "Color", "PersonEntry"."ImageID", "PersonEntry"."ID",
CASE WHEN "PersonEntry"."ClassName" IS NOT NULL THEN "PersonEntry"."ClassName"
ELSE 'App\\Models\\PersonEntry' END AS "RecordClassName", 'de_DE' AS "Locale", CASE WHEN "PersonEntry_Localised_de_DE"."ID" IS NOT NULL THEN 'de_DE'
ELSE NULL END AS "SourceLocale"
FROM "PersonEntry" INNER JOIN "Element_Persons" ON "Element_Persons"."PersonEntryID" = "PersonEntry"."ID" LEFT JOIN "PersonEntry_Localised" AS "PersonEntry_Localised_de_DE" ON "PersonEntry"."ID" = "PersonEntry_Localised_de_DE"."RecordID" AND "PersonEntry_Localised_de_DE"."Locale" = ?
WHERE ("Element_Persons"."ElementID" = ?)
AND (("PersonEntry_Localised_de_DE"."ID" IS NOT NULL))
ORDER BY "Name" ASC
LIMIT 1
0.0004s
0067: SELECT DISTINCT "Element_Live"."ClassName", "Element_Live"."LastEdited", "Element_Live"."Created", CASE
WHEN "BetterContent_Localised_de_DE"."ID" IS NOT NULL THEN "BetterContent_Localised_de_DE"."Content"
ELSE "BetterContent_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 "BetterContent_Localised_de_DE"."ID" IS NOT NULL THEN 'de_DE'
ELSE NULL END AS "SourceLocale", "Element_Live"."Sort"
FROM "Element_Live" LEFT JOIN "BetterContent_Live" ON "BetterContent_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 "BetterContent_Localised_Live" AS "BetterContent_Localised_de_DE" ON "BetterContent_Live"."ID" = "BetterContent_Localised_de_DE"."RecordID" AND "BetterContent_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.0004s
0068: SELECT DISTINCT "GlossarEntry"."ClassName", "GlossarEntry"."LastEdited", "GlossarEntry"."Created", CASE
WHEN "GlossarEntry_Localised_de_DE"."ID" IS NOT NULL THEN "GlossarEntry_Localised_de_DE"."Title"
ELSE "GlossarEntry"."Title" END
AS "Title", CASE
WHEN "GlossarEntry_Localised_de_DE"."ID" IS NOT NULL THEN "GlossarEntry_Localised_de_DE"."ShortText"
ELSE "GlossarEntry"."ShortText" END
AS "ShortText", CASE
WHEN "GlossarEntry_Localised_de_DE"."ID" IS NOT NULL THEN "GlossarEntry_Localised_de_DE"."URLSegment"
ELSE "GlossarEntry"."URLSegment" END
AS "URLSegment", "GlossarEntry"."ID",
CASE WHEN "GlossarEntry"."ClassName" IS NOT NULL THEN "GlossarEntry"."ClassName"
ELSE 'App\\Models\\GlossarEntry' END AS "RecordClassName", 'de_DE' AS "Locale", CASE WHEN "GlossarEntry_Localised_de_DE"."ID" IS NOT NULL THEN 'de_DE'
ELSE NULL END AS "SourceLocale"
FROM "GlossarEntry" LEFT JOIN "GlossarEntry_Localised" AS "GlossarEntry_Localised_de_DE" ON "GlossarEntry"."ID" = "GlossarEntry_Localised_de_DE"."RecordID" AND "GlossarEntry_Localised_de_DE"."Locale" = ?
WHERE ("GlossarEntry"."ID" = ?)
AND (("GlossarEntry_Localised_de_DE"."ID" IS NOT NULL))
LIMIT 1
0.0003s
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", CASE
WHEN "Page_Localised_de_DE"."ID" IS NOT NULL THEN "Page_Localised_de_DE"."ChapterTitle"
ELSE "Page_Live"."ChapterTitle" END
AS "ChapterTitle", CASE
WHEN "Page_Localised_de_DE"."ID" IS NOT NULL THEN "Page_Localised_de_DE"."BetterTitle"
ELSE "Page_Live"."BetterTitle" END
AS "BetterTitle", CASE
WHEN "Page_Localised_de_DE"."ID" IS NOT NULL THEN "Page_Localised_de_DE"."TeaserText"
ELSE "Page_Live"."TeaserText" END
AS "TeaserText", "Page_Live"."NoTeaser", "Page_Live"."NoBookmark", "Page_Live"."ImageID", "SiteTree_Live"."ID",
CASE WHEN "SiteTree_Live"."ClassName" IS NOT NULL THEN "SiteTree_Live"."ClassName"
ELSE 'SilverStripe\\CMS\\Model\\SiteTree' END AS "RecordClassName", 'de_DE' AS "Locale", CASE WHEN "Page_Localised_de_DE"."ID" IS NOT NULL THEN 'de_DE'
ELSE NULL END AS "SourceLocale"
FROM "SiteTree_Live" LEFT JOIN "Page_Live" ON "Page_Live"."ID" = "SiteTree_Live"."ID" LEFT JOIN "SiteTree_Localised_Live" AS "SiteTree_Localised_de_DE" ON "SiteTree_Live"."ID" = "SiteTree_Localised_de_DE"."RecordID" AND "SiteTree_Localised_de_DE"."Locale" = ? LEFT JOIN "Page_Localised_Live" AS "Page_Localised_de_DE" ON "Page_Live"."ID" = "Page_Localised_de_DE"."RecordID" AND "Page_Localised_de_DE"."Locale" = ?
WHERE ("SiteTree_Live"."ClassName" IN (?))
AND (("SiteTree_Localised_de_DE"."ID" IS NOT NULL))
ORDER BY "SiteTree_Live"."Sort" ASC
LIMIT 1
0.001s
0070: SELECT CASE WHEN EXISTS(SELECT *
FROM "PersonEntry" INNER JOIN "Element_Persons" ON "Element_Persons"."PersonEntryID" = "PersonEntry"."ID" LEFT JOIN "PersonEntry_Localised" AS "PersonEntry_Localised_de_DE" ON "PersonEntry"."ID" = "PersonEntry_Localised_de_DE"."RecordID" AND "PersonEntry_Localised_de_DE"."Locale" = ?
WHERE ("Element_Persons"."ElementID" = ?)
AND (("PersonEntry_Localised_de_DE"."ID" IS NOT NULL))) THEN 1 ELSE 0 END
0.0005s
0071: SELECT "PersonEntry"."ID", "PersonEntry"."Name" AS "_SortColumn0"
FROM "PersonEntry" INNER JOIN "Element_Persons" ON "Element_Persons"."PersonEntryID" = "PersonEntry"."ID" LEFT JOIN "PersonEntry_Localised" AS "PersonEntry_Localised_de_DE" ON "PersonEntry"."ID" = "PersonEntry_Localised_de_DE"."RecordID" AND "PersonEntry_Localised_de_DE"."Locale" = ?
WHERE ("Element_Persons"."ElementID" = ?)
AND (("PersonEntry_Localised_de_DE"."ID" IS NOT NULL))
ORDER BY "_SortColumn0" ASC
0.0003s
0072: SELECT DISTINCT count(DISTINCT "PersonEntry"."ID") AS "Count"
FROM "PersonEntry" INNER JOIN "Element_Persons" ON "Element_Persons"."PersonEntryID" = "PersonEntry"."ID" LEFT JOIN "PersonEntry_Localised" AS "PersonEntry_Localised_de_DE" ON "PersonEntry"."ID" = "PersonEntry_Localised_de_DE"."RecordID" AND "PersonEntry_Localised_de_DE"."Locale" = ?
WHERE ("Element_Persons"."ElementID" = ?)
AND (("PersonEntry_Localised_de_DE"."ID" IS NOT NULL))
0.0003s
0073: SELECT DISTINCT "PersonEntry"."ClassName", "PersonEntry"."LastEdited", "PersonEntry"."Created", "PersonEntry"."SortOrder", CASE
WHEN "PersonEntry_Localised_de_DE"."ID" IS NOT NULL THEN "PersonEntry_Localised_de_DE"."Name"
ELSE "PersonEntry"."Name" END
AS "Name", CASE
WHEN "PersonEntry_Localised_de_DE"."ID" IS NOT NULL THEN "PersonEntry_Localised_de_DE"."Color"
ELSE "PersonEntry"."Color" END
AS "Color", "PersonEntry"."ImageID", "PersonEntry"."ID",
CASE WHEN "PersonEntry"."ClassName" IS NOT NULL THEN "PersonEntry"."ClassName"
ELSE 'App\\Models\\PersonEntry' END AS "RecordClassName", 'de_DE' AS "Locale", CASE WHEN "PersonEntry_Localised_de_DE"."ID" IS NOT NULL THEN 'de_DE'
ELSE NULL END AS "SourceLocale"
FROM "PersonEntry" INNER JOIN "Element_Persons" ON "Element_Persons"."PersonEntryID" = "PersonEntry"."ID" LEFT JOIN "PersonEntry_Localised" AS "PersonEntry_Localised_de_DE" ON "PersonEntry"."ID" = "PersonEntry_Localised_de_DE"."RecordID" AND "PersonEntry_Localised_de_DE"."Locale" = ?
WHERE ("Element_Persons"."ElementID" = ?)
AND (("PersonEntry_Localised_de_DE"."ID" IS NOT NULL))
ORDER BY "Name" ASC
LIMIT 1
0.0004s
0074: SELECT DISTINCT "Element_Live"."ClassName", "Element_Live"."LastEdited", "Element_Live"."Created", CASE
WHEN "BetterContent_Localised_de_DE"."ID" IS NOT NULL THEN "BetterContent_Localised_de_DE"."Content"
ELSE "BetterContent_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 "BetterContent_Localised_de_DE"."ID" IS NOT NULL THEN 'de_DE'
ELSE NULL END AS "SourceLocale", "Element_Live"."Sort"
FROM "Element_Live" LEFT JOIN "BetterContent_Live" ON "BetterContent_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 "BetterContent_Localised_Live" AS "BetterContent_Localised_de_DE" ON "BetterContent_Live"."ID" = "BetterContent_Localised_de_DE"."RecordID" AND "BetterContent_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
0075: SELECT DISTINCT "PersonEntry"."ClassName", "PersonEntry"."LastEdited", "PersonEntry"."Created", "PersonEntry"."SortOrder", CASE
WHEN "PersonEntry_Localised_de_DE"."ID" IS NOT NULL THEN "PersonEntry_Localised_de_DE"."Name"
ELSE "PersonEntry"."Name" END
AS "Name", CASE
WHEN "PersonEntry_Localised_de_DE"."ID" IS NOT NULL THEN "PersonEntry_Localised_de_DE"."Color"
ELSE "PersonEntry"."Color" END
AS "Color", "PersonEntry"."ImageID", "PersonEntry"."ID",
CASE WHEN "PersonEntry"."ClassName" IS NOT NULL THEN "PersonEntry"."ClassName"
ELSE 'App\\Models\\PersonEntry' END AS "RecordClassName", 'de_DE' AS "Locale", CASE WHEN "PersonEntry_Localised_de_DE"."ID" IS NOT NULL THEN 'de_DE'
ELSE NULL END AS "SourceLocale", (COALESCE("PersonEntry_Localised_de_DE"."Name", "PersonEntry"."Name")) AS "_SortColumn0"
FROM "PersonEntry" LEFT JOIN "PersonEntry_Localised" AS "PersonEntry_Localised_de_DE" ON "PersonEntry"."ID" = "PersonEntry_Localised_de_DE"."RecordID" AND "PersonEntry_Localised_de_DE"."Locale" = ?
WHERE (("PersonEntry_Localised_de_DE"."ID" IS NOT NULL))
ORDER BY "_SortColumn0" ASC
0.0002s
0076: SELECT DISTINCT "File_Live"."ClassName", "File_Live"."LastEdited", "File_Live"."Created", CASE WHEN "File_Live"."ClassName" IN ('SilverStripe\\Assets\\File', 'SilverStripe\\Assets\\Folder', 'SilverStripe\\Assets\\Image', 'WeDevelop\\SvgImage\\Assets\\Svg') THEN "File_Live"."Copyright" WHEN "File_Live"."ClassName" IN ('SilverStripe\\Assets\\Image', 'WeDevelop\\SvgImage\\Assets\\Svg') THEN "Image_Live"."Copyright" WHEN "File_Live"."ClassName" IN ('SilverStripe\\Assets\\Image', 'WeDevelop\\SvgImage\\Assets\\Svg') THEN "Image_Live"."Copyright" ELSE NULL END AS "Copyright", CASE WHEN "File_Live"."ClassName" IN ('SilverStripe\\Assets\\File', 'SilverStripe\\Assets\\Folder', 'SilverStripe\\Assets\\Image', 'WeDevelop\\SvgImage\\Assets\\Svg') THEN "File_Live"."Bildunterschrift" WHEN "File_Live"."ClassName" IN ('SilverStripe\\Assets\\Image', 'WeDevelop\\SvgImage\\Assets\\Svg') THEN "Image_Live"."Bildunterschrift" WHEN "File_Live"."ClassName" IN ('SilverStripe\\Assets\\Image', 'WeDevelop\\SvgImage\\Assets\\Svg') THEN "Image_Live"."Bildunterschrift" ELSE NULL END AS "Bildunterschrift", CASE WHEN "File_Live"."ClassName" IN ('SilverStripe\\Assets\\File', 'SilverStripe\\Assets\\Folder', 'SilverStripe\\Assets\\Image', 'WeDevelop\\SvgImage\\Assets\\Svg') THEN "File_Live"."AltText" WHEN "File_Live"."ClassName" IN ('SilverStripe\\Assets\\Image', 'WeDevelop\\SvgImage\\Assets\\Svg') THEN "Image_Live"."AltText" WHEN "File_Live"."ClassName" IN ('SilverStripe\\Assets\\Image', 'WeDevelop\\SvgImage\\Assets\\Svg') THEN "Image_Live"."AltText" ELSE NULL END AS "AltText", "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
0077: SELECT DISTINCT "File_Live"."ClassName", "File_Live"."LastEdited", "File_Live"."Created", CASE WHEN "File_Live"."ClassName" IN ('SilverStripe\\Assets\\File', 'SilverStripe\\Assets\\Folder', 'SilverStripe\\Assets\\Image', 'WeDevelop\\SvgImage\\Assets\\Svg') THEN "File_Live"."Copyright" WHEN "File_Live"."ClassName" IN ('SilverStripe\\Assets\\Image', 'WeDevelop\\SvgImage\\Assets\\Svg') THEN "Image_Live"."Copyright" WHEN "File_Live"."ClassName" IN ('SilverStripe\\Assets\\Image', 'WeDevelop\\SvgImage\\Assets\\Svg') THEN "Image_Live"."Copyright" ELSE NULL END AS "Copyright", CASE WHEN "File_Live"."ClassName" IN ('SilverStripe\\Assets\\File', 'SilverStripe\\Assets\\Folder', 'SilverStripe\\Assets\\Image', 'WeDevelop\\SvgImage\\Assets\\Svg') THEN "File_Live"."Bildunterschrift" WHEN "File_Live"."ClassName" IN ('SilverStripe\\Assets\\Image', 'WeDevelop\\SvgImage\\Assets\\Svg') THEN "Image_Live"."Bildunterschrift" WHEN "File_Live"."ClassName" IN ('SilverStripe\\Assets\\Image', 'WeDevelop\\SvgImage\\Assets\\Svg') THEN "Image_Live"."Bildunterschrift" ELSE NULL END AS "Bildunterschrift", CASE WHEN "File_Live"."ClassName" IN ('SilverStripe\\Assets\\File', 'SilverStripe\\Assets\\Folder', 'SilverStripe\\Assets\\Image', 'WeDevelop\\SvgImage\\Assets\\Svg') THEN "File_Live"."AltText" WHEN "File_Live"."ClassName" IN ('SilverStripe\\Assets\\Image', 'WeDevelop\\SvgImage\\Assets\\Svg') THEN "Image_Live"."AltText" WHEN "File_Live"."ClassName" IN ('SilverStripe\\Assets\\Image', 'WeDevelop\\SvgImage\\Assets\\Svg') THEN "Image_Live"."AltText" ELSE NULL END AS "AltText", "File_Live"."Version", "File_Live"."CanViewType", "File_Live"."CanEditType", "File_Live"."Name", "File_Live"."Title", "File_Live"."ShowInSearch", "File_Live"."ParentID", "File_Live"."OwnerID", "File_Live"."FileHash", "File_Live"."FileFilename", "File_Live"."FileVariant", "Image_Live"."FocusPointX", "Image_Live"."FocusPointY", "Image_Live"."FocusPointWidth", "Image_Live"."FocusPointHeight", "File_Live"."ID",
CASE WHEN "File_Live"."ClassName" IS NOT NULL THEN "File_Live"."ClassName"
ELSE 'SilverStripe\\Assets\\File' END AS "RecordClassName"
FROM "File_Live" LEFT JOIN "Image_Live" ON "Image_Live"."ID" = "File_Live"."ID"
WHERE ("File_Live"."ID" = ?)
AND ("File_Live"."ClassName" IN (?, ?))
ORDER BY "File_Live"."Name" ASC
LIMIT 1
0.0004s
0078: SELECT DISTINCT "File_Live"."ClassName", "File_Live"."LastEdited", "File_Live"."Created", CASE WHEN "File_Live"."ClassName" IN ('SilverStripe\\Assets\\File', 'SilverStripe\\Assets\\Folder', 'SilverStripe\\Assets\\Image', 'WeDevelop\\SvgImage\\Assets\\Svg') THEN "File_Live"."Copyright" WHEN "File_Live"."ClassName" IN ('SilverStripe\\Assets\\Image', 'WeDevelop\\SvgImage\\Assets\\Svg') THEN "Image_Live"."Copyright" WHEN "File_Live"."ClassName" IN ('SilverStripe\\Assets\\Image', 'WeDevelop\\SvgImage\\Assets\\Svg') THEN "Image_Live"."Copyright" ELSE NULL END AS "Copyright", CASE WHEN "File_Live"."ClassName" IN ('SilverStripe\\Assets\\File', 'SilverStripe\\Assets\\Folder', 'SilverStripe\\Assets\\Image', 'WeDevelop\\SvgImage\\Assets\\Svg') THEN "File_Live"."Bildunterschrift" WHEN "File_Live"."ClassName" IN ('SilverStripe\\Assets\\Image', 'WeDevelop\\SvgImage\\Assets\\Svg') THEN "Image_Live"."Bildunterschrift" WHEN "File_Live"."ClassName" IN ('SilverStripe\\Assets\\Image', 'WeDevelop\\SvgImage\\Assets\\Svg') THEN "Image_Live"."Bildunterschrift" ELSE NULL END AS "Bildunterschrift", CASE WHEN "File_Live"."ClassName" IN ('SilverStripe\\Assets\\File', 'SilverStripe\\Assets\\Folder', 'SilverStripe\\Assets\\Image', 'WeDevelop\\SvgImage\\Assets\\Svg') THEN "File_Live"."AltText" WHEN "File_Live"."ClassName" IN ('SilverStripe\\Assets\\Image', 'WeDevelop\\SvgImage\\Assets\\Svg') THEN "Image_Live"."AltText" WHEN "File_Live"."ClassName" IN ('SilverStripe\\Assets\\Image', 'WeDevelop\\SvgImage\\Assets\\Svg') THEN "Image_Live"."AltText" ELSE NULL END AS "AltText", "File_Live"."Version", "File_Live"."CanViewType", "File_Live"."CanEditType", "File_Live"."Name", "File_Live"."Title", "File_Live"."ShowInSearch", "File_Live"."ParentID", "File_Live"."OwnerID", "File_Live"."FileHash", "File_Live"."FileFilename", "File_Live"."FileVariant", "Image_Live"."FocusPointX", "Image_Live"."FocusPointY", "Image_Live"."FocusPointWidth", "Image_Live"."FocusPointHeight", "File_Live"."ID",
CASE WHEN "File_Live"."ClassName" IS NOT NULL THEN "File_Live"."ClassName"
ELSE 'SilverStripe\\Assets\\File' END AS "RecordClassName"
FROM "File_Live" LEFT JOIN "Image_Live" ON "Image_Live"."ID" = "File_Live"."ID"
WHERE ("File_Live"."ID" = ?)
AND ("File_Live"."ClassName" IN (?, ?))
ORDER BY "File_Live"."Name" ASC
LIMIT 1
0.0004s
0079: SELECT DISTINCT "File_Live"."ClassName", "File_Live"."LastEdited", "File_Live"."Created", CASE WHEN "File_Live"."ClassName" IN ('SilverStripe\\Assets\\File', 'SilverStripe\\Assets\\Folder', 'SilverStripe\\Assets\\Image', 'WeDevelop\\SvgImage\\Assets\\Svg') THEN "File_Live"."Copyright" WHEN "File_Live"."ClassName" IN ('SilverStripe\\Assets\\Image', 'WeDevelop\\SvgImage\\Assets\\Svg') THEN "Image_Live"."Copyright" WHEN "File_Live"."ClassName" IN ('SilverStripe\\Assets\\Image', 'WeDevelop\\SvgImage\\Assets\\Svg') THEN "Image_Live"."Copyright" ELSE NULL END AS "Copyright", CASE WHEN "File_Live"."ClassName" IN ('SilverStripe\\Assets\\File', 'SilverStripe\\Assets\\Folder', 'SilverStripe\\Assets\\Image', 'WeDevelop\\SvgImage\\Assets\\Svg') THEN "File_Live"."Bildunterschrift" WHEN "File_Live"."ClassName" IN ('SilverStripe\\Assets\\Image', 'WeDevelop\\SvgImage\\Assets\\Svg') THEN "Image_Live"."Bildunterschrift" WHEN "File_Live"."ClassName" IN ('SilverStripe\\Assets\\Image', 'WeDevelop\\SvgImage\\Assets\\Svg') THEN "Image_Live"."Bildunterschrift" ELSE NULL END AS "Bildunterschrift", CASE WHEN "File_Live"."ClassName" IN ('SilverStripe\\Assets\\File', 'SilverStripe\\Assets\\Folder', 'SilverStripe\\Assets\\Image', 'WeDevelop\\SvgImage\\Assets\\Svg') THEN "File_Live"."AltText" WHEN "File_Live"."ClassName" IN ('SilverStripe\\Assets\\Image', 'WeDevelop\\SvgImage\\Assets\\Svg') THEN "Image_Live"."AltText" WHEN "File_Live"."ClassName" IN ('SilverStripe\\Assets\\Image', 'WeDevelop\\SvgImage\\Assets\\Svg') THEN "Image_Live"."AltText" ELSE NULL END AS "AltText", "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
0080: SELECT CASE WHEN EXISTS(SELECT *
FROM "MenuSet"
WHERE ("MenuSet"."Name" = ?)) THEN 1 ELSE 0 END
0.0004s
0081: 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
0082: SELECT "Version" FROM "SiteTree" WHERE "ID" = ?
0.0003s
0083: SELECT "BaseTable"."RecordID", MAX("SiteTree_Localised_Versions"."Version") as "LatestVersion" FROM "SiteTree_Localised" AS "BaseTable" INNER JOIN "SiteTree_Localised_Versions" ON "BaseTable"."RecordID" = "SiteTree_Localised_Versions"."RecordID" AND "SiteTree_Localised_Versions"."Locale" = ? INNER JOIN "SiteTree_Versions" ON "SiteTree_Versions"."RecordID" = "SiteTree_Localised_Versions"."RecordID" AND "SiteTree_Versions"."Version" = "SiteTree_Localised_Versions"."Version" WHERE "BaseTable"."Locale" = ? AND "BaseTable"."RecordID" IN (?) GROUP BY "BaseTable"."RecordID"
0.0003s
0084: SELECT "ID"
FROM "SiteTree_Localised_Live"
WHERE ("RecordID" = ?)
AND ("Locale" = ?)
LIMIT 1
0.0002s
0085: 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.0005s
0086: 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
0087: 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
0088: 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.0006s
0089: 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
0090: 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.0003s
There are many variations of Katzen im Weltraum of Lorem Ipsum available, but the majority have suffered alteration in some form, by injected humour, or randomised words which don't look even slightly believable. If you are going to use a passage of Lorem Ipsum, you need to be sure there isn't anything embarrassing hidden in the middle of text. All the Lorem Ipsum generators on the Internet tend to repeat predefined chunks as necessary, making this the first true generator on the Internet. It uses a dictionary of over 200 Latin words, combined with a handful of model sentence structures, to generate Lorem Ipsum which looks reasonable. The generated Lorem Ipsum is therefore always free from repetition, injected humour, or non-characteristic words etc.
Where can I get some? There are many variations of passages of Lorem Ipsum available, but the majority have suffered alteration in some form, by injected humour, or randomised words which don't look even slightly believable. If you are going to use a passage of Lorem Ipsum, you need to be sure there isn't anything embarrassing hidden in the middle of text. All the Lorem Ipsum generators on the Internet tend to repeat predefined chunks as necessary, making this the first true generator on the Internet. It uses a dictionary of over 200 Latin words, combined with a handful of model sentence structures, to generate Lorem Ipsum which looks reasonable. The generated Lorem Ipsum is therefore always free from repetition, injected humour, or non-characteristic words etc.
Is a long established fact that a reader will be distracted by the readable content
