0003: SHOW FULL TABLES WHERE Table_Type != 'VIEW'
0.0018s
0004: SHOW FULL FIELDS IN "Fluent_Locale"
0.0006s
0005: SHOW COLLATION LIKE 'utf8mb3_general_ci'
0.0002s
0006: SELECT DISTINCT "Fluent_Locale"."ClassName", "Fluent_Locale"."LastEdited", "Fluent_Locale"."Created", "Fluent_Locale"."Title", "Fluent_Locale"."Locale", "Fluent_Locale"."URLSegment", "Fluent_Locale"."IsGlobalDefault", "Fluent_Locale"."DomainID", "Fluent_Locale"."ID",
CASE WHEN "Fluent_Locale"."ClassName" IS NOT NULL THEN "Fluent_Locale"."ClassName"
ELSE 'TractorCow\\Fluent\\Model\\Locale' END AS "RecordClassName"
FROM "Fluent_Locale"
ORDER BY "Fluent_Locale"."Locale" ASC
0.0003s
0007: SHOW FULL FIELDS IN "Fluent_Domain"
0.0006s
0008: SELECT DISTINCT "Fluent_Domain"."ClassName", "Fluent_Domain"."LastEdited", "Fluent_Domain"."Created", "Fluent_Domain"."Domain", "Fluent_Domain"."DefaultLocaleID", "Fluent_Domain"."ID",
CASE WHEN "Fluent_Domain"."ClassName" IS NOT NULL THEN "Fluent_Domain"."ClassName"
ELSE 'TractorCow\\Fluent\\Model\\Domain' END AS "RecordClassName"
FROM "Fluent_Domain"
0.0002s
0009: SELECT DISTINCT "Fluent_FallbackLocale"."ClassName" AS "Fluent_FallbackLocale_ClassName", "Fluent_FallbackLocale"."LastEdited" AS "Fluent_FallbackLocale_LastEdited", "Fluent_FallbackLocale"."Created" AS "Fluent_FallbackLocale_Created", "Fluent_FallbackLocale"."Sort" AS "Fluent_FallbackLocale_Sort", "Fluent_FallbackLocale"."ParentID" AS "Fluent_FallbackLocale_ParentID", "Fluent_FallbackLocale"."LocaleID" AS "Fluent_FallbackLocale_LocaleID", "Fluent_FallbackLocale"."ID" AS "Fluent_FallbackLocale_ID", "Fluent_FallbackLocale"."RecordClassName" AS "Fluent_FallbackLocale_RecordClassName", "Fluent_Locale"."ClassName", "Fluent_Locale"."LastEdited", "Fluent_Locale"."Created", "Fluent_Locale"."Title", "Fluent_Locale"."Locale", "Fluent_Locale"."URLSegment", "Fluent_Locale"."IsGlobalDefault", "Fluent_Locale"."DomainID", "Fluent_Locale"."ID",
CASE WHEN "Fluent_Locale"."ClassName" IS NOT NULL THEN "Fluent_Locale"."ClassName"
ELSE 'TractorCow\\Fluent\\Model\\Locale' END AS "RecordClassName"
FROM "Fluent_Locale" INNER JOIN (SELECT DISTINCT "Fluent_FallbackLocale"."ClassName", "Fluent_FallbackLocale"."LastEdited", "Fluent_FallbackLocale"."Created", "Fluent_FallbackLocale"."Sort", "Fluent_FallbackLocale"."ParentID", "Fluent_FallbackLocale"."LocaleID", "Fluent_FallbackLocale"."ID",
CASE WHEN "Fluent_FallbackLocale"."ClassName" IS NOT NULL THEN "Fluent_FallbackLocale"."ClassName"
ELSE 'TractorCow\\Fluent\\Model\\FallbackLocale' END AS "RecordClassName"
FROM "Fluent_FallbackLocale"
WHERE ("Fluent_FallbackLocale"."ParentID" = ?)) AS "Fluent_FallbackLocale" ON "Fluent_FallbackLocale"."LocaleID" = "Fluent_Locale"."ID"
ORDER BY "Fluent_Locale"."Locale" ASC
0.0003s
0010: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", CASE
WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."BetterSiteTitle"
ELSE "SiteTree_Live"."BetterSiteTitle" END
AS "BetterSiteTitle", CASE
WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."Keyword"
ELSE "SiteTree_Live"."Keyword" END
AS "Keyword", CASE
WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."FeaturedKeyword"
ELSE "SiteTree_Live"."FeaturedKeyword" END
AS "FeaturedKeyword", CASE
WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."KeywordQuestion"
ELSE "SiteTree_Live"."KeywordQuestion" END
AS "KeywordQuestion", "SiteTree_Live"."Follow", "SiteTree_Live"."FollowType", CASE
WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."GenMetaDesc"
ELSE "SiteTree_Live"."GenMetaDesc" END
AS "GenMetaDesc", CASE
WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."FBTitle"
ELSE "SiteTree_Live"."FBTitle" END
AS "FBTitle", CASE
WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."FBDescription"
ELSE "SiteTree_Live"."FBDescription" END
AS "FBDescription", "SiteTree_Live"."FBType", "SiteTree_Live"."FBTypeOverride", CASE
WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."TwTitle"
ELSE "SiteTree_Live"."TwTitle" END
AS "TwTitle", CASE
WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."TwDescription"
ELSE "SiteTree_Live"."TwDescription" END
AS "TwDescription", "SiteTree_Live"."CanViewType", "SiteTree_Live"."CanEditType", "SiteTree_Live"."Version", CASE
WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."URLSegment"
ELSE "SiteTree_Live"."URLSegment" END
AS "URLSegment", CASE
WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."Title"
ELSE "SiteTree_Live"."Title" END
AS "Title", CASE
WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."MenuTitle"
ELSE "SiteTree_Live"."MenuTitle" END
AS "MenuTitle", CASE
WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."Content"
ELSE "SiteTree_Live"."Content" END
AS "Content", CASE
WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."MetaDescription"
ELSE "SiteTree_Live"."MetaDescription" END
AS "MetaDescription", "SiteTree_Live"."ExtraMeta", "SiteTree_Live"."ShowInMenus", "SiteTree_Live"."ShowInSearch", "SiteTree_Live"."Sort", "SiteTree_Live"."HasBrokenFile", "SiteTree_Live"."HasBrokenLink", CASE
WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."ReportClass"
ELSE "SiteTree_Live"."ReportClass" END
AS "ReportClass", "SiteTree_Live"."CanonicalLinkID", "SiteTree_Live"."FBImageID", "SiteTree_Live"."TwImageID", "SiteTree_Live"."ParentID", "SiteTree_Live"."ID",
CASE WHEN "SiteTree_Live"."ClassName" IS NOT NULL THEN "SiteTree_Live"."ClassName"
ELSE 'SilverStripe\\CMS\\Model\\SiteTree' END AS "RecordClassName", 'en_GB' AS "Locale", CASE WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN 'en_GB'
ELSE NULL END AS "SourceLocale"
FROM "SiteTree_Live" LEFT JOIN "SiteTree_Localised_Live" AS "SiteTree_Localised_en_GB" ON "SiteTree_Live"."ID" = "SiteTree_Localised_en_GB"."RecordID" AND "SiteTree_Localised_en_GB"."Locale" = ?
WHERE (COALESCE("SiteTree_Localised_en_GB"."URLSegment", "SiteTree_Live"."URLSegment") = ?)
AND ("SiteTree_Live"."ParentID" = ?)
AND (("SiteTree_Localised_en_GB"."ID" IS NOT NULL))
ORDER BY "SiteTree_Live"."Sort" ASC
LIMIT 1
0.0005s
0011: SELECT DISTINCT "SiteConfig"."ClassName", "SiteConfig"."LastEdited", "SiteConfig"."Created", CASE
WHEN "SiteConfig_Localised_en_GB"."ID" IS NOT NULL THEN "SiteConfig_Localised_en_GB"."FooterCol1"
ELSE "SiteConfig"."FooterCol1" END
AS "FooterCol1", CASE
WHEN "SiteConfig_Localised_en_GB"."ID" IS NOT NULL THEN "SiteConfig_Localised_en_GB"."FooterCol2"
ELSE "SiteConfig"."FooterCol2" END
AS "FooterCol2", CASE
WHEN "SiteConfig_Localised_en_GB"."ID" IS NOT NULL THEN "SiteConfig_Localised_en_GB"."FooterCol3"
ELSE "SiteConfig"."FooterCol3" END
AS "FooterCol3", CASE
WHEN "SiteConfig_Localised_en_GB"."ID" IS NOT NULL THEN "SiteConfig_Localised_en_GB"."FooterCol4"
ELSE "SiteConfig"."FooterCol4" END
AS "FooterCol4", "SiteConfig"."CookieConsentNotice", "SiteConfig"."CookieBtnOk", "SiteConfig"."CookieChooseText", "SiteConfig"."CookieBtnDislike", "SiteConfig"."CookieAllowGMaps", "SiteConfig"."CookieTextUnderBtn", "SiteConfig"."CookieAllowYouTube", "SiteConfig"."CookieConsentPopUpHeadline", "SiteConfig"."CookieConsentPopUpNotice", "SiteConfig"."CookieConsentPopUpDisallow", "SiteConfig"."CookieConsentPopUpAllowAll", "SiteConfig"."CookieConsentPopUpAllowSelected", "SiteConfig"."CookiePrivacyPolicyTitle", "SiteConfig"."CookiePrivacyPolicyText", CASE
WHEN "SiteConfig_Localised_en_GB"."ID" IS NOT NULL THEN "SiteConfig_Localised_en_GB"."Title"
ELSE "SiteConfig"."Title" END
AS "Title", CASE
WHEN "SiteConfig_Localised_en_GB"."ID" IS NOT NULL THEN "SiteConfig_Localised_en_GB"."Tagline"
ELSE "SiteConfig"."Tagline" END
AS "Tagline", "SiteConfig"."CanViewType", "SiteConfig"."CanEditType", "SiteConfig"."CanCreateTopLevelType", "SiteConfig"."ID",
CASE WHEN "SiteConfig"."ClassName" IS NOT NULL THEN "SiteConfig"."ClassName"
ELSE 'SilverStripe\\SiteConfig\\SiteConfig' END AS "RecordClassName", 'en_GB' AS "Locale", CASE WHEN "SiteConfig_Localised_en_GB"."ID" IS NOT NULL THEN 'en_GB'
ELSE NULL END AS "SourceLocale"
FROM "SiteConfig" LEFT JOIN "SiteConfig_Localised" AS "SiteConfig_Localised_en_GB" ON "SiteConfig"."ID" = "SiteConfig_Localised_en_GB"."RecordID" AND "SiteConfig_Localised_en_GB"."Locale" = ?
LIMIT 1
0.0005s
0012: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", CASE
WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."BetterSiteTitle"
ELSE "SiteTree_Live"."BetterSiteTitle" END
AS "BetterSiteTitle", CASE
WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."Keyword"
ELSE "SiteTree_Live"."Keyword" END
AS "Keyword", CASE
WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."FeaturedKeyword"
ELSE "SiteTree_Live"."FeaturedKeyword" END
AS "FeaturedKeyword", CASE
WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."KeywordQuestion"
ELSE "SiteTree_Live"."KeywordQuestion" END
AS "KeywordQuestion", "SiteTree_Live"."Follow", "SiteTree_Live"."FollowType", CASE
WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."GenMetaDesc"
ELSE "SiteTree_Live"."GenMetaDesc" END
AS "GenMetaDesc", CASE
WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."FBTitle"
ELSE "SiteTree_Live"."FBTitle" END
AS "FBTitle", CASE
WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."FBDescription"
ELSE "SiteTree_Live"."FBDescription" END
AS "FBDescription", "SiteTree_Live"."FBType", "SiteTree_Live"."FBTypeOverride", CASE
WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."TwTitle"
ELSE "SiteTree_Live"."TwTitle" END
AS "TwTitle", CASE
WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."TwDescription"
ELSE "SiteTree_Live"."TwDescription" END
AS "TwDescription", "SiteTree_Live"."CanViewType", "SiteTree_Live"."CanEditType", "SiteTree_Live"."Version", CASE
WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."URLSegment"
ELSE "SiteTree_Live"."URLSegment" END
AS "URLSegment", CASE
WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."Title"
ELSE "SiteTree_Live"."Title" END
AS "Title", CASE
WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."MenuTitle"
ELSE "SiteTree_Live"."MenuTitle" END
AS "MenuTitle", CASE
WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."Content"
ELSE "SiteTree_Live"."Content" END
AS "Content", CASE
WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."MetaDescription"
ELSE "SiteTree_Live"."MetaDescription" END
AS "MetaDescription", "SiteTree_Live"."ExtraMeta", "SiteTree_Live"."ShowInMenus", "SiteTree_Live"."ShowInSearch", "SiteTree_Live"."Sort", "SiteTree_Live"."HasBrokenFile", "SiteTree_Live"."HasBrokenLink", CASE
WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."ReportClass"
ELSE "SiteTree_Live"."ReportClass" END
AS "ReportClass", "SiteTree_Live"."CanonicalLinkID", "SiteTree_Live"."FBImageID", "SiteTree_Live"."TwImageID", "SiteTree_Live"."ParentID", "SiteTree_Live"."ID",
CASE WHEN "SiteTree_Live"."ClassName" IS NOT NULL THEN "SiteTree_Live"."ClassName"
ELSE 'SilverStripe\\CMS\\Model\\SiteTree' END AS "RecordClassName", 'en_GB' AS "Locale", CASE WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN 'en_GB'
ELSE NULL END AS "SourceLocale"
FROM "SiteTree_Live" LEFT JOIN "SiteTree_Localised_Live" AS "SiteTree_Localised_en_GB" ON "SiteTree_Live"."ID" = "SiteTree_Localised_en_GB"."RecordID" AND "SiteTree_Localised_en_GB"."Locale" = ?
WHERE ("SiteTree_Live"."ParentID" <> "SiteTree_Live"."ID")
AND ("SiteTree_Live"."ParentID" = ?)
AND ("SiteTree_Live"."ShowInMenus" = ?)
AND (("SiteTree_Localised_en_GB"."ID" IS NOT NULL))
ORDER BY "SiteTree_Live"."Sort" ASC
0.0006s
0013: 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
0014: SELECT DISTINCT "MenuItem"."ClassName", "MenuItem"."LastEdited", "MenuItem"."Created", "MenuItem"."MenuTitle", "MenuItem"."Link", "MenuItem"."Sort", "MenuItem"."IsNewWindow", "MenuItem"."PageID", "MenuItem"."MenuSetID", "MenuItem"."ID",
CASE WHEN "MenuItem"."ClassName" IS NOT NULL THEN "MenuItem"."ClassName"
ELSE 'Heyday\\MenuManager\\MenuItem' END AS "RecordClassName"
FROM "MenuItem"
WHERE ("MenuItem"."MenuSetID" = ?)
ORDER BY "MenuItem"."Sort" ASC
0.0002s
0015: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", CASE
WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."BetterSiteTitle"
ELSE "SiteTree_Live"."BetterSiteTitle" END
AS "BetterSiteTitle", CASE
WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."Keyword"
ELSE "SiteTree_Live"."Keyword" END
AS "Keyword", CASE
WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."FeaturedKeyword"
ELSE "SiteTree_Live"."FeaturedKeyword" END
AS "FeaturedKeyword", CASE
WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."KeywordQuestion"
ELSE "SiteTree_Live"."KeywordQuestion" END
AS "KeywordQuestion", "SiteTree_Live"."Follow", "SiteTree_Live"."FollowType", CASE
WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."GenMetaDesc"
ELSE "SiteTree_Live"."GenMetaDesc" END
AS "GenMetaDesc", CASE
WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."FBTitle"
ELSE "SiteTree_Live"."FBTitle" END
AS "FBTitle", CASE
WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."FBDescription"
ELSE "SiteTree_Live"."FBDescription" END
AS "FBDescription", "SiteTree_Live"."FBType", "SiteTree_Live"."FBTypeOverride", CASE
WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."TwTitle"
ELSE "SiteTree_Live"."TwTitle" END
AS "TwTitle", CASE
WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."TwDescription"
ELSE "SiteTree_Live"."TwDescription" END
AS "TwDescription", "SiteTree_Live"."CanViewType", "SiteTree_Live"."CanEditType", "SiteTree_Live"."Version", CASE
WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."URLSegment"
ELSE "SiteTree_Live"."URLSegment" END
AS "URLSegment", CASE
WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."Title"
ELSE "SiteTree_Live"."Title" END
AS "Title", CASE
WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."MenuTitle"
ELSE "SiteTree_Live"."MenuTitle" END
AS "MenuTitle", CASE
WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."Content"
ELSE "SiteTree_Live"."Content" END
AS "Content", CASE
WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."MetaDescription"
ELSE "SiteTree_Live"."MetaDescription" END
AS "MetaDescription", "SiteTree_Live"."ExtraMeta", "SiteTree_Live"."ShowInMenus", "SiteTree_Live"."ShowInSearch", "SiteTree_Live"."Sort", "SiteTree_Live"."HasBrokenFile", "SiteTree_Live"."HasBrokenLink", CASE
WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."ReportClass"
ELSE "SiteTree_Live"."ReportClass" END
AS "ReportClass", "SiteTree_Live"."CanonicalLinkID", "SiteTree_Live"."FBImageID", "SiteTree_Live"."TwImageID", "SiteTree_Live"."ParentID", "SiteTree_Live"."ID",
CASE WHEN "SiteTree_Live"."ClassName" IS NOT NULL THEN "SiteTree_Live"."ClassName"
ELSE 'SilverStripe\\CMS\\Model\\SiteTree' END AS "RecordClassName", 'en_GB' AS "Locale", CASE WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN 'en_GB'
ELSE NULL END AS "SourceLocale"
FROM "SiteTree_Live" LEFT JOIN "SiteTree_Localised_Live" AS "SiteTree_Localised_en_GB" ON "SiteTree_Live"."ID" = "SiteTree_Localised_en_GB"."RecordID" AND "SiteTree_Localised_en_GB"."Locale" = ?
WHERE ("SiteTree_Live"."ID" = ?)
AND (("SiteTree_Localised_en_GB"."ID" IS NOT NULL))
ORDER BY "SiteTree_Live"."Sort" ASC
LIMIT 1
0.0005s
0016: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", CASE
WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."BetterSiteTitle"
ELSE "SiteTree_Live"."BetterSiteTitle" END
AS "BetterSiteTitle", CASE
WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."Keyword"
ELSE "SiteTree_Live"."Keyword" END
AS "Keyword", CASE
WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."FeaturedKeyword"
ELSE "SiteTree_Live"."FeaturedKeyword" END
AS "FeaturedKeyword", CASE
WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."KeywordQuestion"
ELSE "SiteTree_Live"."KeywordQuestion" END
AS "KeywordQuestion", "SiteTree_Live"."Follow", "SiteTree_Live"."FollowType", CASE
WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."GenMetaDesc"
ELSE "SiteTree_Live"."GenMetaDesc" END
AS "GenMetaDesc", CASE
WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."FBTitle"
ELSE "SiteTree_Live"."FBTitle" END
AS "FBTitle", CASE
WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."FBDescription"
ELSE "SiteTree_Live"."FBDescription" END
AS "FBDescription", "SiteTree_Live"."FBType", "SiteTree_Live"."FBTypeOverride", CASE
WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."TwTitle"
ELSE "SiteTree_Live"."TwTitle" END
AS "TwTitle", CASE
WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."TwDescription"
ELSE "SiteTree_Live"."TwDescription" END
AS "TwDescription", "SiteTree_Live"."CanViewType", "SiteTree_Live"."CanEditType", "SiteTree_Live"."Version", CASE
WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."URLSegment"
ELSE "SiteTree_Live"."URLSegment" END
AS "URLSegment", CASE
WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."Title"
ELSE "SiteTree_Live"."Title" END
AS "Title", CASE
WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."MenuTitle"
ELSE "SiteTree_Live"."MenuTitle" END
AS "MenuTitle", CASE
WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."Content"
ELSE "SiteTree_Live"."Content" END
AS "Content", CASE
WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."MetaDescription"
ELSE "SiteTree_Live"."MetaDescription" END
AS "MetaDescription", "SiteTree_Live"."ExtraMeta", "SiteTree_Live"."ShowInMenus", "SiteTree_Live"."ShowInSearch", "SiteTree_Live"."Sort", "SiteTree_Live"."HasBrokenFile", "SiteTree_Live"."HasBrokenLink", CASE
WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."ReportClass"
ELSE "SiteTree_Live"."ReportClass" END
AS "ReportClass", "SiteTree_Live"."CanonicalLinkID", "SiteTree_Live"."FBImageID", "SiteTree_Live"."TwImageID", "SiteTree_Live"."ParentID", "SiteTree_Live"."ID",
CASE WHEN "SiteTree_Live"."ClassName" IS NOT NULL THEN "SiteTree_Live"."ClassName"
ELSE 'SilverStripe\\CMS\\Model\\SiteTree' END AS "RecordClassName", 'en_GB' AS "Locale", CASE WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN 'en_GB'
ELSE NULL END AS "SourceLocale"
FROM "SiteTree_Live" LEFT JOIN "SiteTree_Localised_Live" AS "SiteTree_Localised_en_GB" ON "SiteTree_Live"."ID" = "SiteTree_Localised_en_GB"."RecordID" AND "SiteTree_Localised_en_GB"."Locale" = ?
WHERE ("SiteTree_Live"."ID" = ?)
AND (("SiteTree_Localised_en_GB"."ID" IS NOT NULL))
ORDER BY "SiteTree_Live"."Sort" ASC
LIMIT 1
0.0001s
0017: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", CASE
WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."BetterSiteTitle"
ELSE "SiteTree_Live"."BetterSiteTitle" END
AS "BetterSiteTitle", CASE
WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."Keyword"
ELSE "SiteTree_Live"."Keyword" END
AS "Keyword", CASE
WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."FeaturedKeyword"
ELSE "SiteTree_Live"."FeaturedKeyword" END
AS "FeaturedKeyword", CASE
WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."KeywordQuestion"
ELSE "SiteTree_Live"."KeywordQuestion" END
AS "KeywordQuestion", "SiteTree_Live"."Follow", "SiteTree_Live"."FollowType", CASE
WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."GenMetaDesc"
ELSE "SiteTree_Live"."GenMetaDesc" END
AS "GenMetaDesc", CASE
WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."FBTitle"
ELSE "SiteTree_Live"."FBTitle" END
AS "FBTitle", CASE
WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."FBDescription"
ELSE "SiteTree_Live"."FBDescription" END
AS "FBDescription", "SiteTree_Live"."FBType", "SiteTree_Live"."FBTypeOverride", CASE
WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."TwTitle"
ELSE "SiteTree_Live"."TwTitle" END
AS "TwTitle", CASE
WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."TwDescription"
ELSE "SiteTree_Live"."TwDescription" END
AS "TwDescription", "SiteTree_Live"."CanViewType", "SiteTree_Live"."CanEditType", "SiteTree_Live"."Version", CASE
WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."URLSegment"
ELSE "SiteTree_Live"."URLSegment" END
AS "URLSegment", CASE
WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."Title"
ELSE "SiteTree_Live"."Title" END
AS "Title", CASE
WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."MenuTitle"
ELSE "SiteTree_Live"."MenuTitle" END
AS "MenuTitle", CASE
WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."Content"
ELSE "SiteTree_Live"."Content" END
AS "Content", CASE
WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."MetaDescription"
ELSE "SiteTree_Live"."MetaDescription" END
AS "MetaDescription", "SiteTree_Live"."ExtraMeta", "SiteTree_Live"."ShowInMenus", "SiteTree_Live"."ShowInSearch", "SiteTree_Live"."Sort", "SiteTree_Live"."HasBrokenFile", "SiteTree_Live"."HasBrokenLink", CASE
WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."ReportClass"
ELSE "SiteTree_Live"."ReportClass" END
AS "ReportClass", "SiteTree_Live"."CanonicalLinkID", "SiteTree_Live"."FBImageID", "SiteTree_Live"."TwImageID", "SiteTree_Live"."ParentID", "SiteTree_Live"."ID",
CASE WHEN "SiteTree_Live"."ClassName" IS NOT NULL THEN "SiteTree_Live"."ClassName"
ELSE 'SilverStripe\\CMS\\Model\\SiteTree' END AS "RecordClassName", 'en_GB' AS "Locale", CASE WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN 'en_GB'
ELSE NULL END AS "SourceLocale"
FROM "SiteTree_Live" LEFT JOIN "SiteTree_Localised_Live" AS "SiteTree_Localised_en_GB" ON "SiteTree_Live"."ID" = "SiteTree_Localised_en_GB"."RecordID" AND "SiteTree_Localised_en_GB"."Locale" = ?
WHERE ("SiteTree_Live"."ID" = ?)
AND (("SiteTree_Localised_en_GB"."ID" IS NOT NULL))
ORDER BY "SiteTree_Live"."Sort" ASC
LIMIT 1
0.0001s
0018: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", CASE WHEN "SiteTree_Live"."ClassName" IN ('Page', 'GeschichteKulturDialog\\App\\CityTourHolder', 'GeschichteKulturDialog\\App\\CityTourPage', 'GeschichteKulturDialog\\App\\HomePage', 'SilverStripe\\ErrorPage\\ErrorPage', 'SilverStripe\\CMS\\Model\\RedirectorPage', 'SilverStripe\\CMS\\Model\\VirtualPage', 'SilverStripe\\UserForms\\Model\\UserDefinedForm') THEN "Page_Live"."ElementalAreaID" WHEN "SiteTree_Live"."ClassName" IN ('GeschichteKulturDialog\\App\\HomePage') THEN "HomePage_Live"."ElementalAreaID" WHEN "SiteTree_Live"."ClassName" IN ('GeschichteKulturDialog\\App\\HomePage') THEN "HomePage_Live"."ElementalAreaID" ELSE NULL END AS "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 "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN 'en_GB'
ELSE NULL END AS "SourceLocale", "SiteTree_Live"."Sort"
FROM "SiteTree_Live" LEFT JOIN "Page_Live" ON "Page_Live"."ID" = "SiteTree_Live"."ID" LEFT JOIN "HomePage_Live" ON "HomePage_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" = ?
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.0003s
0019: SELECT DISTINCT "ElementalArea_Live"."ClassName", "ElementalArea_Live"."LastEdited", "ElementalArea_Live"."Created", "ElementalArea_Live"."Version", "ElementalArea_Live"."OwnerClassName", "ElementalArea_Live"."ID",
CASE WHEN "ElementalArea_Live"."ClassName" IS NOT NULL THEN "ElementalArea_Live"."ClassName"
ELSE 'DNADesign\\Elemental\\Models\\ElementalArea' END AS "RecordClassName"
FROM "ElementalArea_Live"
WHERE ("ElementalArea_Live"."ID" = ?)
LIMIT 1
0.0001s
0020: SELECT DISTINCT "Element_Live"."ClassName", "Element_Live"."LastEdited", "Element_Live"."Created", CASE
WHEN "Element_Localised_en_GB"."ID" IS NOT NULL THEN "Element_Localised_en_GB"."Title"
ELSE "Element_Live"."Title" END
AS "Title", "Element_Live"."ExtraCSSClass", CASE
WHEN "Element_Localised_en_GB"."ID" IS NOT NULL THEN "Element_Localised_en_GB"."NavigationName"
ELSE "Element_Live"."NavigationName" END
AS "NavigationName", "Element_Live"."NavigationLink", "Element_Live"."SetNavigation", "Element_Live"."Version", "Element_Live"."ShowTitle", "Element_Live"."Sort", "Element_Live"."ExtraClass", "Element_Live"."Style", "Element_Live"."ParentID", "Element_Live"."ID",
CASE WHEN "Element_Live"."ClassName" IS NOT NULL THEN "Element_Live"."ClassName"
ELSE 'DNADesign\\Elemental\\Models\\BaseElement' END AS "RecordClassName", 'en_GB' AS "Locale", CASE WHEN "Element_Localised_en_GB"."ID" IS NOT NULL THEN 'en_GB'
ELSE NULL END AS "SourceLocale"
FROM "Element_Live" LEFT JOIN "Element_Localised_Live" AS "Element_Localised_en_GB" ON "Element_Live"."ID" = "Element_Localised_en_GB"."RecordID" AND "Element_Localised_en_GB"."Locale" = ?
WHERE ("Element_Live"."ParentID" = ?)
AND (("Element_Localised_en_GB"."ID" IS NOT NULL))
ORDER BY "Element_Live"."Sort" ASC
0.0003s
0021: SELECT DISTINCT "ElementalArea_Live"."ClassName", "ElementalArea_Live"."LastEdited", "ElementalArea_Live"."Created", "ElementalArea_Live"."Version", "ElementalArea_Live"."OwnerClassName", "ElementalArea_Live"."ID",
CASE WHEN "ElementalArea_Live"."ClassName" IS NOT NULL THEN "ElementalArea_Live"."ClassName"
ELSE 'DNADesign\\Elemental\\Models\\ElementalArea' END AS "RecordClassName"
FROM "ElementalArea_Live"
WHERE ("ElementalArea_Live"."ID" = ?)
LIMIT 1
0.0001s
0022: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", CASE
WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."BetterSiteTitle"
ELSE "SiteTree_Live"."BetterSiteTitle" END
AS "BetterSiteTitle", CASE
WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."Keyword"
ELSE "SiteTree_Live"."Keyword" END
AS "Keyword", CASE
WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."FeaturedKeyword"
ELSE "SiteTree_Live"."FeaturedKeyword" END
AS "FeaturedKeyword", CASE
WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."KeywordQuestion"
ELSE "SiteTree_Live"."KeywordQuestion" END
AS "KeywordQuestion", "SiteTree_Live"."Follow", "SiteTree_Live"."FollowType", CASE
WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."GenMetaDesc"
ELSE "SiteTree_Live"."GenMetaDesc" END
AS "GenMetaDesc", CASE
WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."FBTitle"
ELSE "SiteTree_Live"."FBTitle" END
AS "FBTitle", CASE
WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."FBDescription"
ELSE "SiteTree_Live"."FBDescription" END
AS "FBDescription", "SiteTree_Live"."FBType", "SiteTree_Live"."FBTypeOverride", CASE
WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."TwTitle"
ELSE "SiteTree_Live"."TwTitle" END
AS "TwTitle", CASE
WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."TwDescription"
ELSE "SiteTree_Live"."TwDescription" END
AS "TwDescription", "SiteTree_Live"."CanViewType", "SiteTree_Live"."CanEditType", "SiteTree_Live"."Version", CASE
WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."URLSegment"
ELSE "SiteTree_Live"."URLSegment" END
AS "URLSegment", CASE
WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."Title"
ELSE "SiteTree_Live"."Title" END
AS "Title", CASE
WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."MenuTitle"
ELSE "SiteTree_Live"."MenuTitle" END
AS "MenuTitle", CASE
WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."Content"
ELSE "SiteTree_Live"."Content" END
AS "Content", CASE
WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."MetaDescription"
ELSE "SiteTree_Live"."MetaDescription" END
AS "MetaDescription", "SiteTree_Live"."ExtraMeta", "SiteTree_Live"."ShowInMenus", "SiteTree_Live"."ShowInSearch", "SiteTree_Live"."Sort", "SiteTree_Live"."HasBrokenFile", "SiteTree_Live"."HasBrokenLink", CASE
WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."ReportClass"
ELSE "SiteTree_Live"."ReportClass" END
AS "ReportClass", "SiteTree_Live"."CanonicalLinkID", "SiteTree_Live"."FBImageID", "SiteTree_Live"."TwImageID", "SiteTree_Live"."ParentID", CASE WHEN "SiteTree_Live"."ClassName" IN ('Page', 'GeschichteKulturDialog\\App\\CityTourHolder', 'GeschichteKulturDialog\\App\\CityTourPage', 'GeschichteKulturDialog\\App\\HomePage', 'SilverStripe\\ErrorPage\\ErrorPage', 'SilverStripe\\CMS\\Model\\RedirectorPage', 'SilverStripe\\CMS\\Model\\VirtualPage', 'SilverStripe\\UserForms\\Model\\UserDefinedForm') THEN "Page_Live"."ElementalAreaID" WHEN "SiteTree_Live"."ClassName" IN ('GeschichteKulturDialog\\App\\HomePage') THEN "HomePage_Live"."ElementalAreaID" ELSE NULL END AS "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 "SiteTree_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 "HomePage_Live" ON "HomePage_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" = ?
WHERE ("HomePage_Live"."ElementalAreaID" = ?)
AND ("SiteTree_Live"."ClassName" = ?)
AND ("SiteTree_Live"."ClassName" IN (?))
AND (("SiteTree_Localised_en_GB"."ID" IS NOT NULL))
ORDER BY "SiteTree_Live"."Sort" ASC
LIMIT 1
0.0005s
0023: SELECT DISTINCT "ElementalArea_Live"."ClassName", "ElementalArea_Live"."LastEdited", "ElementalArea_Live"."Created", "ElementalArea_Live"."Version", "ElementalArea_Live"."OwnerClassName", "ElementalArea_Live"."ID",
CASE WHEN "ElementalArea_Live"."ClassName" IS NOT NULL THEN "ElementalArea_Live"."ClassName"
ELSE 'DNADesign\\Elemental\\Models\\ElementalArea' END AS "RecordClassName"
FROM "ElementalArea_Live"
WHERE ("ElementalArea_Live"."ID" = ?)
LIMIT 1
0.0001s
0024: SELECT DISTINCT "Element_Live"."ClassName", "Element_Live"."LastEdited", "Element_Live"."Created", CASE
WHEN "ElementHomeHeader_Localised_en_GB"."ID" IS NOT NULL THEN "ElementHomeHeader_Localised_en_GB"."FirstSentence"
ELSE "ElementHomeHeader_Live"."FirstSentence" END
AS "FirstSentence", CASE
WHEN "ElementHomeHeader_Localised_en_GB"."ID" IS NOT NULL THEN "ElementHomeHeader_Localised_en_GB"."SecondSentence"
ELSE "ElementHomeHeader_Live"."SecondSentence" END
AS "SecondSentence", "ElementHomeHeader_Live"."ImageID", "ElementHomeHeader_Live"."LogoID", "Element_Live"."ID",
CASE WHEN "Element_Live"."ClassName" IS NOT NULL THEN "Element_Live"."ClassName"
ELSE 'DNADesign\\Elemental\\Models\\BaseElement' END AS "RecordClassName", 'en_GB' AS "Locale", CASE WHEN "ElementHomeHeader_Localised_en_GB"."ID" IS NOT NULL THEN 'en_GB'
ELSE NULL END AS "SourceLocale", "Element_Live"."Sort"
FROM "Element_Live" LEFT JOIN "ElementHomeHeader_Live" ON "ElementHomeHeader_Live"."ID" = "Element_Live"."ID" LEFT JOIN "Element_Localised_Live" AS "Element_Localised_en_GB" ON "Element_Live"."ID" = "Element_Localised_en_GB"."RecordID" AND "Element_Localised_en_GB"."Locale" = ? LEFT JOIN "ElementHomeHeader_Localised_Live" AS "ElementHomeHeader_Localised_en_GB" ON "ElementHomeHeader_Live"."ID" = "ElementHomeHeader_Localised_en_GB"."RecordID" AND "ElementHomeHeader_Localised_en_GB"."Locale" = ?
WHERE ("Element_Live"."ID" = ?)
AND ("Element_Live"."ClassName" IN (?))
AND (("Element_Localised_en_GB"."ID" IS NOT NULL))
ORDER BY "Element_Live"."Sort" ASC
LIMIT 1
0.0003s
0025: SELECT DISTINCT "File_Live"."ClassName", "File_Live"."LastEdited", "File_Live"."Created", "File_Live"."UserFormUpload", "File_Live"."Version", "File_Live"."CanViewType", "File_Live"."CanEditType", "File_Live"."Name", "File_Live"."Title", "File_Live"."ShowInSearch", "File_Live"."ParentID", "File_Live"."OwnerID", "File_Live"."FileHash", "File_Live"."FileFilename", "File_Live"."FileVariant", "Image_Live"."FocusPointX", "Image_Live"."FocusPointY", "Image_Live"."FocusPointWidth", "Image_Live"."FocusPointHeight", "File_Live"."ID",
CASE WHEN "File_Live"."ClassName" IS NOT NULL THEN "File_Live"."ClassName"
ELSE 'SilverStripe\\Assets\\File' END AS "RecordClassName"
FROM "File_Live" LEFT JOIN "Image_Live" ON "Image_Live"."ID" = "File_Live"."ID"
WHERE ("File_Live"."ID" = ?)
AND ("File_Live"."ClassName" IN (?))
ORDER BY "File_Live"."Name" ASC
LIMIT 1
0.0002s
0026: SELECT DISTINCT "Element_Live"."ClassName", "Element_Live"."LastEdited", "Element_Live"."Created", CASE
WHEN "ElementCityTour_Localised_en_GB"."ID" IS NOT NULL THEN "ElementCityTour_Localised_en_GB"."Content"
ELSE "ElementCityTour_Live"."Content" END
AS "Content", "Element_Live"."ID",
CASE WHEN "Element_Live"."ClassName" IS NOT NULL THEN "Element_Live"."ClassName"
ELSE 'DNADesign\\Elemental\\Models\\BaseElement' END AS "RecordClassName", 'en_GB' AS "Locale", CASE WHEN "ElementCityTour_Localised_en_GB"."ID" IS NOT NULL THEN 'en_GB'
ELSE NULL END AS "SourceLocale", "Element_Live"."Sort"
FROM "Element_Live" LEFT JOIN "ElementCityTour_Live" ON "ElementCityTour_Live"."ID" = "Element_Live"."ID" LEFT JOIN "Element_Localised_Live" AS "Element_Localised_en_GB" ON "Element_Live"."ID" = "Element_Localised_en_GB"."RecordID" AND "Element_Localised_en_GB"."Locale" = ? LEFT JOIN "ElementCityTour_Localised_Live" AS "ElementCityTour_Localised_en_GB" ON "ElementCityTour_Live"."ID" = "ElementCityTour_Localised_en_GB"."RecordID" AND "ElementCityTour_Localised_en_GB"."Locale" = ?
WHERE ("Element_Live"."ID" = ?)
AND ("Element_Live"."ClassName" IN (?))
AND (("Element_Localised_en_GB"."ID" IS NOT NULL))
ORDER BY "Element_Live"."Sort" ASC
LIMIT 1
0.0003s
0027: SELECT DISTINCT "File_Live"."ClassName", "File_Live"."LastEdited", "File_Live"."Created", "File_Live"."UserFormUpload", "File_Live"."Version", "File_Live"."CanViewType", "File_Live"."CanEditType", "File_Live"."Name", "File_Live"."Title", "File_Live"."ShowInSearch", "File_Live"."ParentID", "File_Live"."OwnerID", "File_Live"."FileHash", "File_Live"."FileFilename", "File_Live"."FileVariant", "File_Live"."ID",
CASE WHEN "File_Live"."ClassName" IS NOT NULL THEN "File_Live"."ClassName"
ELSE 'SilverStripe\\Assets\\File' END AS "RecordClassName"
FROM "File_Live"
WHERE ("File_Live"."ID" = ?)
ORDER BY "File_Live"."Name" ASC
LIMIT 1
0.0002s
0028: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", CASE
WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."BetterSiteTitle"
ELSE "SiteTree_Live"."BetterSiteTitle" END
AS "BetterSiteTitle", CASE
WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."Keyword"
ELSE "SiteTree_Live"."Keyword" END
AS "Keyword", CASE
WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."FeaturedKeyword"
ELSE "SiteTree_Live"."FeaturedKeyword" END
AS "FeaturedKeyword", CASE
WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."KeywordQuestion"
ELSE "SiteTree_Live"."KeywordQuestion" END
AS "KeywordQuestion", "SiteTree_Live"."Follow", "SiteTree_Live"."FollowType", CASE
WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."GenMetaDesc"
ELSE "SiteTree_Live"."GenMetaDesc" END
AS "GenMetaDesc", CASE
WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."FBTitle"
ELSE "SiteTree_Live"."FBTitle" END
AS "FBTitle", CASE
WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."FBDescription"
ELSE "SiteTree_Live"."FBDescription" END
AS "FBDescription", "SiteTree_Live"."FBType", "SiteTree_Live"."FBTypeOverride", CASE
WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."TwTitle"
ELSE "SiteTree_Live"."TwTitle" END
AS "TwTitle", CASE
WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."TwDescription"
ELSE "SiteTree_Live"."TwDescription" END
AS "TwDescription", "SiteTree_Live"."CanViewType", "SiteTree_Live"."CanEditType", "SiteTree_Live"."Version", CASE
WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."URLSegment"
ELSE "SiteTree_Live"."URLSegment" END
AS "URLSegment", CASE
WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."Title"
ELSE "SiteTree_Live"."Title" END
AS "Title", CASE
WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."MenuTitle"
ELSE "SiteTree_Live"."MenuTitle" END
AS "MenuTitle", CASE
WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."Content"
ELSE "SiteTree_Live"."Content" END
AS "Content", CASE
WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."MetaDescription"
ELSE "SiteTree_Live"."MetaDescription" END
AS "MetaDescription", "SiteTree_Live"."ExtraMeta", "SiteTree_Live"."ShowInMenus", "SiteTree_Live"."ShowInSearch", "SiteTree_Live"."Sort", "SiteTree_Live"."HasBrokenFile", "SiteTree_Live"."HasBrokenLink", CASE
WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."ReportClass"
ELSE "SiteTree_Live"."ReportClass" END
AS "ReportClass", "SiteTree_Live"."CanonicalLinkID", "SiteTree_Live"."FBImageID", "SiteTree_Live"."TwImageID", "SiteTree_Live"."ParentID", CASE WHEN "SiteTree_Live"."ClassName" IN ('Page', 'GeschichteKulturDialog\\App\\CityTourHolder', 'GeschichteKulturDialog\\App\\CityTourPage', 'GeschichteKulturDialog\\App\\HomePage', 'SilverStripe\\ErrorPage\\ErrorPage', 'SilverStripe\\CMS\\Model\\RedirectorPage', 'SilverStripe\\CMS\\Model\\VirtualPage', 'SilverStripe\\UserForms\\Model\\UserDefinedForm') THEN "Page_Live"."ElementalAreaID" WHEN "SiteTree_Live"."ClassName" IN ('GeschichteKulturDialog\\App\\CityTourPage') THEN "CityTourPage_Live"."ElementalAreaID" ELSE NULL END AS "ElementalAreaID", CASE
WHEN "CityTourPage_Localised_en_GB"."ID" IS NOT NULL THEN "CityTourPage_Localised_en_GB"."Teaser"
ELSE "CityTourPage_Live"."Teaser" END
AS "Teaser", CASE
WHEN "CityTourPage_Localised_en_GB"."ID" IS NOT NULL THEN "CityTourPage_Localised_en_GB"."SubTitle"
ELSE "CityTourPage_Live"."SubTitle" END
AS "SubTitle", CASE
WHEN "CityTourPage_Localised_en_GB"."ID" IS NOT NULL THEN "CityTourPage_Localised_en_GB"."Price"
ELSE "CityTourPage_Live"."Price" END
AS "Price", CASE
WHEN "CityTourPage_Localised_en_GB"."ID" IS NOT NULL THEN "CityTourPage_Localised_en_GB"."Duration"
ELSE "CityTourPage_Live"."Duration" END
AS "Duration", CASE
WHEN "CityTourPage_Localised_en_GB"."ID" IS NOT NULL THEN "CityTourPage_Localised_en_GB"."Buchung"
ELSE "CityTourPage_Live"."Buchung" END
AS "Buchung", "CityTourPage_Live"."Higlight", "CityTourPage_Live"."ImageID", "CityTourPage_Live"."CityTourCategoryID", "SiteTree_Live"."ID",
CASE WHEN "SiteTree_Live"."ClassName" IS NOT NULL THEN "SiteTree_Live"."ClassName"
ELSE 'SilverStripe\\CMS\\Model\\SiteTree' END AS "RecordClassName", 'en_GB' AS "Locale", CASE WHEN "CityTourPage_Localised_en_GB"."ID" IS NOT NULL THEN 'en_GB'
ELSE NULL END AS "SourceLocale"
FROM "SiteTree_Live" LEFT JOIN "Page_Live" ON "Page_Live"."ID" = "SiteTree_Live"."ID" LEFT JOIN "CityTourPage_Live" ON "CityTourPage_Live"."ID" = "SiteTree_Live"."ID" LEFT JOIN "SiteTree_Localised_Live" AS "SiteTree_Localised_en_GB" ON "SiteTree_Live"."ID" = "SiteTree_Localised_en_GB"."RecordID" AND "SiteTree_Localised_en_GB"."Locale" = ? LEFT JOIN "CityTourPage_Localised_Live" AS "CityTourPage_Localised_en_GB" ON "CityTourPage_Live"."ID" = "CityTourPage_Localised_en_GB"."RecordID" AND "CityTourPage_Localised_en_GB"."Locale" = ?
WHERE ("CityTourPage_Live"."Higlight" = ?)
AND ("SiteTree_Live"."ClassName" IN (?))
AND (("SiteTree_Localised_en_GB"."ID" IS NOT NULL))
AND (("SiteTree_Localised_en_GB"."ID" IS NOT NULL))
ORDER BY "SiteTree_Live"."Sort" ASC
0.0007s
0029: SELECT DISTINCT "CityTourCategory"."ClassName", "CityTourCategory"."LastEdited", "CityTourCategory"."Created", CASE
WHEN "CityTourCategory_Localised_en_GB"."ID" IS NOT NULL THEN "CityTourCategory_Localised_en_GB"."Title"
ELSE "CityTourCategory"."Title" END
AS "Title", "CityTourCategory"."CityTourHolderID", "CityTourCategory"."ID",
CASE WHEN "CityTourCategory"."ClassName" IS NOT NULL THEN "CityTourCategory"."ClassName"
ELSE 'GeschichteKulturDialog\\App\\CityTourCategory' END AS "RecordClassName", 'en_GB' AS "Locale", CASE WHEN "CityTourCategory_Localised_en_GB"."ID" IS NOT NULL THEN 'en_GB'
ELSE NULL END AS "SourceLocale"
FROM "CityTourCategory" LEFT JOIN "CityTourCategory_Localised" AS "CityTourCategory_Localised_en_GB" ON "CityTourCategory"."ID" = "CityTourCategory_Localised_en_GB"."RecordID" AND "CityTourCategory_Localised_en_GB"."Locale" = ?
WHERE ("CityTourCategory"."ID" = ?)
AND (("CityTourCategory_Localised_en_GB"."ID" IS NOT NULL))
LIMIT 1
0.0003s
0030: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", CASE
WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."BetterSiteTitle"
ELSE "SiteTree_Live"."BetterSiteTitle" END
AS "BetterSiteTitle", CASE
WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."Keyword"
ELSE "SiteTree_Live"."Keyword" END
AS "Keyword", CASE
WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."FeaturedKeyword"
ELSE "SiteTree_Live"."FeaturedKeyword" END
AS "FeaturedKeyword", CASE
WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."KeywordQuestion"
ELSE "SiteTree_Live"."KeywordQuestion" END
AS "KeywordQuestion", "SiteTree_Live"."Follow", "SiteTree_Live"."FollowType", CASE
WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."GenMetaDesc"
ELSE "SiteTree_Live"."GenMetaDesc" END
AS "GenMetaDesc", CASE
WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."FBTitle"
ELSE "SiteTree_Live"."FBTitle" END
AS "FBTitle", CASE
WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."FBDescription"
ELSE "SiteTree_Live"."FBDescription" END
AS "FBDescription", "SiteTree_Live"."FBType", "SiteTree_Live"."FBTypeOverride", CASE
WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."TwTitle"
ELSE "SiteTree_Live"."TwTitle" END
AS "TwTitle", CASE
WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."TwDescription"
ELSE "SiteTree_Live"."TwDescription" END
AS "TwDescription", "SiteTree_Live"."CanViewType", "SiteTree_Live"."CanEditType", "SiteTree_Live"."Version", CASE
WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."URLSegment"
ELSE "SiteTree_Live"."URLSegment" END
AS "URLSegment", CASE
WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."Title"
ELSE "SiteTree_Live"."Title" END
AS "Title", CASE
WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."MenuTitle"
ELSE "SiteTree_Live"."MenuTitle" END
AS "MenuTitle", CASE
WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."Content"
ELSE "SiteTree_Live"."Content" END
AS "Content", CASE
WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."MetaDescription"
ELSE "SiteTree_Live"."MetaDescription" END
AS "MetaDescription", "SiteTree_Live"."ExtraMeta", "SiteTree_Live"."ShowInMenus", "SiteTree_Live"."ShowInSearch", "SiteTree_Live"."Sort", "SiteTree_Live"."HasBrokenFile", "SiteTree_Live"."HasBrokenLink", CASE
WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."ReportClass"
ELSE "SiteTree_Live"."ReportClass" END
AS "ReportClass", "SiteTree_Live"."CanonicalLinkID", "SiteTree_Live"."FBImageID", "SiteTree_Live"."TwImageID", "SiteTree_Live"."ParentID", "SiteTree_Live"."ID",
CASE WHEN "SiteTree_Live"."ClassName" IS NOT NULL THEN "SiteTree_Live"."ClassName"
ELSE 'SilverStripe\\CMS\\Model\\SiteTree' END AS "RecordClassName", 'en_GB' AS "Locale", CASE WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN 'en_GB'
ELSE NULL END AS "SourceLocale"
FROM "SiteTree_Live" LEFT JOIN "SiteTree_Localised_Live" AS "SiteTree_Localised_en_GB" ON "SiteTree_Live"."ID" = "SiteTree_Localised_en_GB"."RecordID" AND "SiteTree_Localised_en_GB"."Locale" = ?
WHERE ("SiteTree_Live"."ID" = ?)
AND (("SiteTree_Localised_en_GB"."ID" IS NOT NULL))
ORDER BY "SiteTree_Live"."Sort" ASC
LIMIT 1
0.0001s
0031: SELECT DISTINCT "File_Live"."ClassName", "File_Live"."LastEdited", "File_Live"."Created", "File_Live"."UserFormUpload", "File_Live"."Version", "File_Live"."CanViewType", "File_Live"."CanEditType", "File_Live"."Name", "File_Live"."Title", "File_Live"."ShowInSearch", "File_Live"."ParentID", "File_Live"."OwnerID", "File_Live"."FileHash", "File_Live"."FileFilename", "File_Live"."FileVariant", "Image_Live"."FocusPointX", "Image_Live"."FocusPointY", "Image_Live"."FocusPointWidth", "Image_Live"."FocusPointHeight", "File_Live"."ID",
CASE WHEN "File_Live"."ClassName" IS NOT NULL THEN "File_Live"."ClassName"
ELSE 'SilverStripe\\Assets\\File' END AS "RecordClassName"
FROM "File_Live" LEFT JOIN "Image_Live" ON "Image_Live"."ID" = "File_Live"."ID"
WHERE ("File_Live"."ID" = ?)
AND ("File_Live"."ClassName" IN (?))
ORDER BY "File_Live"."Name" ASC
LIMIT 1
0.0001s
0032: SELECT DISTINCT "CityTourCategory"."ClassName", "CityTourCategory"."LastEdited", "CityTourCategory"."Created", CASE
WHEN "CityTourCategory_Localised_en_GB"."ID" IS NOT NULL THEN "CityTourCategory_Localised_en_GB"."Title"
ELSE "CityTourCategory"."Title" END
AS "Title", "CityTourCategory"."CityTourHolderID", "CityTourCategory"."ID",
CASE WHEN "CityTourCategory"."ClassName" IS NOT NULL THEN "CityTourCategory"."ClassName"
ELSE 'GeschichteKulturDialog\\App\\CityTourCategory' END AS "RecordClassName", 'en_GB' AS "Locale", CASE WHEN "CityTourCategory_Localised_en_GB"."ID" IS NOT NULL THEN 'en_GB'
ELSE NULL END AS "SourceLocale"
FROM "CityTourCategory" LEFT JOIN "CityTourCategory_Localised" AS "CityTourCategory_Localised_en_GB" ON "CityTourCategory"."ID" = "CityTourCategory_Localised_en_GB"."RecordID" AND "CityTourCategory_Localised_en_GB"."Locale" = ?
WHERE ("CityTourCategory"."ID" = ?)
AND (("CityTourCategory_Localised_en_GB"."ID" IS NOT NULL))
LIMIT 1
0.0001s
0033: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", CASE
WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."BetterSiteTitle"
ELSE "SiteTree_Live"."BetterSiteTitle" END
AS "BetterSiteTitle", CASE
WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."Keyword"
ELSE "SiteTree_Live"."Keyword" END
AS "Keyword", CASE
WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."FeaturedKeyword"
ELSE "SiteTree_Live"."FeaturedKeyword" END
AS "FeaturedKeyword", CASE
WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."KeywordQuestion"
ELSE "SiteTree_Live"."KeywordQuestion" END
AS "KeywordQuestion", "SiteTree_Live"."Follow", "SiteTree_Live"."FollowType", CASE
WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."GenMetaDesc"
ELSE "SiteTree_Live"."GenMetaDesc" END
AS "GenMetaDesc", CASE
WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."FBTitle"
ELSE "SiteTree_Live"."FBTitle" END
AS "FBTitle", CASE
WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."FBDescription"
ELSE "SiteTree_Live"."FBDescription" END
AS "FBDescription", "SiteTree_Live"."FBType", "SiteTree_Live"."FBTypeOverride", CASE
WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."TwTitle"
ELSE "SiteTree_Live"."TwTitle" END
AS "TwTitle", CASE
WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."TwDescription"
ELSE "SiteTree_Live"."TwDescription" END
AS "TwDescription", "SiteTree_Live"."CanViewType", "SiteTree_Live"."CanEditType", "SiteTree_Live"."Version", CASE
WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."URLSegment"
ELSE "SiteTree_Live"."URLSegment" END
AS "URLSegment", CASE
WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."Title"
ELSE "SiteTree_Live"."Title" END
AS "Title", CASE
WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."MenuTitle"
ELSE "SiteTree_Live"."MenuTitle" END
AS "MenuTitle", CASE
WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."Content"
ELSE "SiteTree_Live"."Content" END
AS "Content", CASE
WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."MetaDescription"
ELSE "SiteTree_Live"."MetaDescription" END
AS "MetaDescription", "SiteTree_Live"."ExtraMeta", "SiteTree_Live"."ShowInMenus", "SiteTree_Live"."ShowInSearch", "SiteTree_Live"."Sort", "SiteTree_Live"."HasBrokenFile", "SiteTree_Live"."HasBrokenLink", CASE
WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."ReportClass"
ELSE "SiteTree_Live"."ReportClass" END
AS "ReportClass", "SiteTree_Live"."CanonicalLinkID", "SiteTree_Live"."FBImageID", "SiteTree_Live"."TwImageID", "SiteTree_Live"."ParentID", "SiteTree_Live"."ID",
CASE WHEN "SiteTree_Live"."ClassName" IS NOT NULL THEN "SiteTree_Live"."ClassName"
ELSE 'SilverStripe\\CMS\\Model\\SiteTree' END AS "RecordClassName", 'en_GB' AS "Locale", CASE WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN 'en_GB'
ELSE NULL END AS "SourceLocale"
FROM "SiteTree_Live" LEFT JOIN "SiteTree_Localised_Live" AS "SiteTree_Localised_en_GB" ON "SiteTree_Live"."ID" = "SiteTree_Localised_en_GB"."RecordID" AND "SiteTree_Localised_en_GB"."Locale" = ?
WHERE ("SiteTree_Live"."ID" = ?)
AND (("SiteTree_Localised_en_GB"."ID" IS NOT NULL))
ORDER BY "SiteTree_Live"."Sort" ASC
LIMIT 1
0.0001s
0034: SELECT DISTINCT "File_Live"."ClassName", "File_Live"."LastEdited", "File_Live"."Created", "File_Live"."UserFormUpload", "File_Live"."Version", "File_Live"."CanViewType", "File_Live"."CanEditType", "File_Live"."Name", "File_Live"."Title", "File_Live"."ShowInSearch", "File_Live"."ParentID", "File_Live"."OwnerID", "File_Live"."FileHash", "File_Live"."FileFilename", "File_Live"."FileVariant", "Image_Live"."FocusPointX", "Image_Live"."FocusPointY", "Image_Live"."FocusPointWidth", "Image_Live"."FocusPointHeight", "File_Live"."ID",
CASE WHEN "File_Live"."ClassName" IS NOT NULL THEN "File_Live"."ClassName"
ELSE 'SilverStripe\\Assets\\File' END AS "RecordClassName"
FROM "File_Live" LEFT JOIN "Image_Live" ON "Image_Live"."ID" = "File_Live"."ID"
WHERE ("File_Live"."ID" = ?)
AND ("File_Live"."ClassName" IN (?))
ORDER BY "File_Live"."Name" ASC
LIMIT 1
0.0001s
0035: SELECT DISTINCT "CityTourCategory"."ClassName", "CityTourCategory"."LastEdited", "CityTourCategory"."Created", CASE
WHEN "CityTourCategory_Localised_en_GB"."ID" IS NOT NULL THEN "CityTourCategory_Localised_en_GB"."Title"
ELSE "CityTourCategory"."Title" END
AS "Title", "CityTourCategory"."CityTourHolderID", "CityTourCategory"."ID",
CASE WHEN "CityTourCategory"."ClassName" IS NOT NULL THEN "CityTourCategory"."ClassName"
ELSE 'GeschichteKulturDialog\\App\\CityTourCategory' END AS "RecordClassName", 'en_GB' AS "Locale", CASE WHEN "CityTourCategory_Localised_en_GB"."ID" IS NOT NULL THEN 'en_GB'
ELSE NULL END AS "SourceLocale"
FROM "CityTourCategory" LEFT JOIN "CityTourCategory_Localised" AS "CityTourCategory_Localised_en_GB" ON "CityTourCategory"."ID" = "CityTourCategory_Localised_en_GB"."RecordID" AND "CityTourCategory_Localised_en_GB"."Locale" = ?
WHERE ("CityTourCategory"."ID" = ?)
AND (("CityTourCategory_Localised_en_GB"."ID" IS NOT NULL))
LIMIT 1
0.0001s
0036: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", CASE
WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."BetterSiteTitle"
ELSE "SiteTree_Live"."BetterSiteTitle" END
AS "BetterSiteTitle", CASE
WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."Keyword"
ELSE "SiteTree_Live"."Keyword" END
AS "Keyword", CASE
WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."FeaturedKeyword"
ELSE "SiteTree_Live"."FeaturedKeyword" END
AS "FeaturedKeyword", CASE
WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."KeywordQuestion"
ELSE "SiteTree_Live"."KeywordQuestion" END
AS "KeywordQuestion", "SiteTree_Live"."Follow", "SiteTree_Live"."FollowType", CASE
WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."GenMetaDesc"
ELSE "SiteTree_Live"."GenMetaDesc" END
AS "GenMetaDesc", CASE
WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."FBTitle"
ELSE "SiteTree_Live"."FBTitle" END
AS "FBTitle", CASE
WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."FBDescription"
ELSE "SiteTree_Live"."FBDescription" END
AS "FBDescription", "SiteTree_Live"."FBType", "SiteTree_Live"."FBTypeOverride", CASE
WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."TwTitle"
ELSE "SiteTree_Live"."TwTitle" END
AS "TwTitle", CASE
WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."TwDescription"
ELSE "SiteTree_Live"."TwDescription" END
AS "TwDescription", "SiteTree_Live"."CanViewType", "SiteTree_Live"."CanEditType", "SiteTree_Live"."Version", CASE
WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."URLSegment"
ELSE "SiteTree_Live"."URLSegment" END
AS "URLSegment", CASE
WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."Title"
ELSE "SiteTree_Live"."Title" END
AS "Title", CASE
WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."MenuTitle"
ELSE "SiteTree_Live"."MenuTitle" END
AS "MenuTitle", CASE
WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."Content"
ELSE "SiteTree_Live"."Content" END
AS "Content", CASE
WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."MetaDescription"
ELSE "SiteTree_Live"."MetaDescription" END
AS "MetaDescription", "SiteTree_Live"."ExtraMeta", "SiteTree_Live"."ShowInMenus", "SiteTree_Live"."ShowInSearch", "SiteTree_Live"."Sort", "SiteTree_Live"."HasBrokenFile", "SiteTree_Live"."HasBrokenLink", CASE
WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."ReportClass"
ELSE "SiteTree_Live"."ReportClass" END
AS "ReportClass", "SiteTree_Live"."CanonicalLinkID", "SiteTree_Live"."FBImageID", "SiteTree_Live"."TwImageID", "SiteTree_Live"."ParentID", "SiteTree_Live"."ID",
CASE WHEN "SiteTree_Live"."ClassName" IS NOT NULL THEN "SiteTree_Live"."ClassName"
ELSE 'SilverStripe\\CMS\\Model\\SiteTree' END AS "RecordClassName", 'en_GB' AS "Locale", CASE WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN 'en_GB'
ELSE NULL END AS "SourceLocale"
FROM "SiteTree_Live" LEFT JOIN "SiteTree_Localised_Live" AS "SiteTree_Localised_en_GB" ON "SiteTree_Live"."ID" = "SiteTree_Localised_en_GB"."RecordID" AND "SiteTree_Localised_en_GB"."Locale" = ?
WHERE ("SiteTree_Live"."ID" = ?)
AND (("SiteTree_Localised_en_GB"."ID" IS NOT NULL))
ORDER BY "SiteTree_Live"."Sort" ASC
LIMIT 1
0.0001s
0037: SELECT DISTINCT "File_Live"."ClassName", "File_Live"."LastEdited", "File_Live"."Created", "File_Live"."UserFormUpload", "File_Live"."Version", "File_Live"."CanViewType", "File_Live"."CanEditType", "File_Live"."Name", "File_Live"."Title", "File_Live"."ShowInSearch", "File_Live"."ParentID", "File_Live"."OwnerID", "File_Live"."FileHash", "File_Live"."FileFilename", "File_Live"."FileVariant", "Image_Live"."FocusPointX", "Image_Live"."FocusPointY", "Image_Live"."FocusPointWidth", "Image_Live"."FocusPointHeight", "File_Live"."ID",
CASE WHEN "File_Live"."ClassName" IS NOT NULL THEN "File_Live"."ClassName"
ELSE 'SilverStripe\\Assets\\File' END AS "RecordClassName"
FROM "File_Live" LEFT JOIN "Image_Live" ON "Image_Live"."ID" = "File_Live"."ID"
WHERE ("File_Live"."ID" = ?)
AND ("File_Live"."ClassName" IN (?))
ORDER BY "File_Live"."Name" ASC
LIMIT 1
0.0001s
0038: SELECT DISTINCT "CityTourCategory"."ClassName", "CityTourCategory"."LastEdited", "CityTourCategory"."Created", CASE
WHEN "CityTourCategory_Localised_en_GB"."ID" IS NOT NULL THEN "CityTourCategory_Localised_en_GB"."Title"
ELSE "CityTourCategory"."Title" END
AS "Title", "CityTourCategory"."CityTourHolderID", "CityTourCategory"."ID",
CASE WHEN "CityTourCategory"."ClassName" IS NOT NULL THEN "CityTourCategory"."ClassName"
ELSE 'GeschichteKulturDialog\\App\\CityTourCategory' END AS "RecordClassName", 'en_GB' AS "Locale", CASE WHEN "CityTourCategory_Localised_en_GB"."ID" IS NOT NULL THEN 'en_GB'
ELSE NULL END AS "SourceLocale"
FROM "CityTourCategory" LEFT JOIN "CityTourCategory_Localised" AS "CityTourCategory_Localised_en_GB" ON "CityTourCategory"."ID" = "CityTourCategory_Localised_en_GB"."RecordID" AND "CityTourCategory_Localised_en_GB"."Locale" = ?
WHERE ("CityTourCategory"."ID" = ?)
AND (("CityTourCategory_Localised_en_GB"."ID" IS NOT NULL))
LIMIT 1
0.0001s
0039: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", CASE
WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."BetterSiteTitle"
ELSE "SiteTree_Live"."BetterSiteTitle" END
AS "BetterSiteTitle", CASE
WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."Keyword"
ELSE "SiteTree_Live"."Keyword" END
AS "Keyword", CASE
WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."FeaturedKeyword"
ELSE "SiteTree_Live"."FeaturedKeyword" END
AS "FeaturedKeyword", CASE
WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."KeywordQuestion"
ELSE "SiteTree_Live"."KeywordQuestion" END
AS "KeywordQuestion", "SiteTree_Live"."Follow", "SiteTree_Live"."FollowType", CASE
WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."GenMetaDesc"
ELSE "SiteTree_Live"."GenMetaDesc" END
AS "GenMetaDesc", CASE
WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."FBTitle"
ELSE "SiteTree_Live"."FBTitle" END
AS "FBTitle", CASE
WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."FBDescription"
ELSE "SiteTree_Live"."FBDescription" END
AS "FBDescription", "SiteTree_Live"."FBType", "SiteTree_Live"."FBTypeOverride", CASE
WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."TwTitle"
ELSE "SiteTree_Live"."TwTitle" END
AS "TwTitle", CASE
WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."TwDescription"
ELSE "SiteTree_Live"."TwDescription" END
AS "TwDescription", "SiteTree_Live"."CanViewType", "SiteTree_Live"."CanEditType", "SiteTree_Live"."Version", CASE
WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."URLSegment"
ELSE "SiteTree_Live"."URLSegment" END
AS "URLSegment", CASE
WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."Title"
ELSE "SiteTree_Live"."Title" END
AS "Title", CASE
WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."MenuTitle"
ELSE "SiteTree_Live"."MenuTitle" END
AS "MenuTitle", CASE
WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."Content"
ELSE "SiteTree_Live"."Content" END
AS "Content", CASE
WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."MetaDescription"
ELSE "SiteTree_Live"."MetaDescription" END
AS "MetaDescription", "SiteTree_Live"."ExtraMeta", "SiteTree_Live"."ShowInMenus", "SiteTree_Live"."ShowInSearch", "SiteTree_Live"."Sort", "SiteTree_Live"."HasBrokenFile", "SiteTree_Live"."HasBrokenLink", CASE
WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."ReportClass"
ELSE "SiteTree_Live"."ReportClass" END
AS "ReportClass", "SiteTree_Live"."CanonicalLinkID", "SiteTree_Live"."FBImageID", "SiteTree_Live"."TwImageID", "SiteTree_Live"."ParentID", "SiteTree_Live"."ID",
CASE WHEN "SiteTree_Live"."ClassName" IS NOT NULL THEN "SiteTree_Live"."ClassName"
ELSE 'SilverStripe\\CMS\\Model\\SiteTree' END AS "RecordClassName", 'en_GB' AS "Locale", CASE WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN 'en_GB'
ELSE NULL END AS "SourceLocale"
FROM "SiteTree_Live" LEFT JOIN "SiteTree_Localised_Live" AS "SiteTree_Localised_en_GB" ON "SiteTree_Live"."ID" = "SiteTree_Localised_en_GB"."RecordID" AND "SiteTree_Localised_en_GB"."Locale" = ?
WHERE ("SiteTree_Live"."ID" = ?)
AND (("SiteTree_Localised_en_GB"."ID" IS NOT NULL))
ORDER BY "SiteTree_Live"."Sort" ASC
LIMIT 1
0.0001s
0040: SELECT DISTINCT "File_Live"."ClassName", "File_Live"."LastEdited", "File_Live"."Created", "File_Live"."UserFormUpload", "File_Live"."Version", "File_Live"."CanViewType", "File_Live"."CanEditType", "File_Live"."Name", "File_Live"."Title", "File_Live"."ShowInSearch", "File_Live"."ParentID", "File_Live"."OwnerID", "File_Live"."FileHash", "File_Live"."FileFilename", "File_Live"."FileVariant", "Image_Live"."FocusPointX", "Image_Live"."FocusPointY", "Image_Live"."FocusPointWidth", "Image_Live"."FocusPointHeight", "File_Live"."ID",
CASE WHEN "File_Live"."ClassName" IS NOT NULL THEN "File_Live"."ClassName"
ELSE 'SilverStripe\\Assets\\File' END AS "RecordClassName"
FROM "File_Live" LEFT JOIN "Image_Live" ON "Image_Live"."ID" = "File_Live"."ID"
WHERE ("File_Live"."ID" = ?)
AND ("File_Live"."ClassName" IN (?))
ORDER BY "File_Live"."Name" ASC
LIMIT 1
0.0001s
0041: SELECT DISTINCT "Element_Live"."ClassName", "Element_Live"."LastEdited", "Element_Live"."Created", CASE
WHEN "ElementAbout_Localised_en_GB"."ID" IS NOT NULL THEN "ElementAbout_Localised_en_GB"."BigContent"
ELSE "ElementAbout_Live"."BigContent" END
AS "BigContent", CASE
WHEN "ElementAbout_Localised_en_GB"."ID" IS NOT NULL THEN "ElementAbout_Localised_en_GB"."Content"
ELSE "ElementAbout_Live"."Content" END
AS "Content", "ElementAbout_Live"."PortraitID", "Element_Live"."ID",
CASE WHEN "Element_Live"."ClassName" IS NOT NULL THEN "Element_Live"."ClassName"
ELSE 'DNADesign\\Elemental\\Models\\BaseElement' END AS "RecordClassName", 'en_GB' AS "Locale", CASE WHEN "ElementAbout_Localised_en_GB"."ID" IS NOT NULL THEN 'en_GB'
ELSE NULL END AS "SourceLocale", "Element_Live"."Sort"
FROM "Element_Live" LEFT JOIN "ElementAbout_Live" ON "ElementAbout_Live"."ID" = "Element_Live"."ID" LEFT JOIN "Element_Localised_Live" AS "Element_Localised_en_GB" ON "Element_Live"."ID" = "Element_Localised_en_GB"."RecordID" AND "Element_Localised_en_GB"."Locale" = ? LEFT JOIN "ElementAbout_Localised_Live" AS "ElementAbout_Localised_en_GB" ON "ElementAbout_Live"."ID" = "ElementAbout_Localised_en_GB"."RecordID" AND "ElementAbout_Localised_en_GB"."Locale" = ?
WHERE ("Element_Live"."ID" = ?)
AND ("Element_Live"."ClassName" IN (?))
AND (("Element_Localised_en_GB"."ID" IS NOT NULL))
ORDER BY "Element_Live"."Sort" ASC
LIMIT 1
0.0003s
0042: SELECT DISTINCT "File_Live"."ClassName", "File_Live"."LastEdited", "File_Live"."Created", "File_Live"."UserFormUpload", "File_Live"."Version", "File_Live"."CanViewType", "File_Live"."CanEditType", "File_Live"."Name", "File_Live"."Title", "File_Live"."ShowInSearch", "File_Live"."ParentID", "File_Live"."OwnerID", "File_Live"."FileHash", "File_Live"."FileFilename", "File_Live"."FileVariant", "Image_Live"."FocusPointX", "Image_Live"."FocusPointY", "Image_Live"."FocusPointWidth", "Image_Live"."FocusPointHeight", "File_Live"."ID",
CASE WHEN "File_Live"."ClassName" IS NOT NULL THEN "File_Live"."ClassName"
ELSE 'SilverStripe\\Assets\\File' END AS "RecordClassName"
FROM "File_Live" LEFT JOIN "Image_Live" ON "Image_Live"."ID" = "File_Live"."ID"
WHERE ("File_Live"."ID" = ?)
AND ("File_Live"."ClassName" IN (?))
ORDER BY "File_Live"."Name" ASC
LIMIT 1
0.0001s
0043: SELECT DISTINCT "ProfilEntry"."ClassName", "ProfilEntry"."LastEdited", "ProfilEntry"."Created", CASE
WHEN "ProfilEntry_Localised_en_GB"."ID" IS NOT NULL THEN "ProfilEntry_Localised_en_GB"."Title"
ELSE "ProfilEntry"."Title" END
AS "Title", CASE
WHEN "ProfilEntry_Localised_en_GB"."ID" IS NOT NULL THEN "ProfilEntry_Localised_en_GB"."Content"
ELSE "ProfilEntry"."Content" END
AS "Content", "ProfilEntry"."SortOrder", "ProfilEntry"."ElementProfilID", "ProfilEntry"."ID",
CASE WHEN "ProfilEntry"."ClassName" IS NOT NULL THEN "ProfilEntry"."ClassName"
ELSE 'GeschichteKulturDialog\\App\\ProfilEntry' END AS "RecordClassName", 'en_GB' AS "Locale", CASE WHEN "ProfilEntry_Localised_en_GB"."ID" IS NOT NULL THEN 'en_GB'
ELSE NULL END AS "SourceLocale"
FROM "ProfilEntry" LEFT JOIN "ProfilEntry_Localised" AS "ProfilEntry_Localised_en_GB" ON "ProfilEntry"."ID" = "ProfilEntry_Localised_en_GB"."RecordID" AND "ProfilEntry_Localised_en_GB"."Locale" = ?
WHERE ("ProfilEntry"."ElementProfilID" = ?)
AND (("ProfilEntry_Localised_en_GB"."ID" IS NOT NULL))
0.0002s
0044: SELECT DISTINCT "EditableFormField_Live"."ClassName", "EditableFormField_Live"."LastEdited", "EditableFormField_Live"."Created", "EditableFormField_Live"."Version", "EditableFormField_Live"."Name", "EditableFormField_Live"."Title", "EditableFormField_Live"."Default", "EditableFormField_Live"."Sort", "EditableFormField_Live"."Required", "EditableFormField_Live"."CustomErrorMessage", "EditableFormField_Live"."ExtraClass", "EditableFormField_Live"."RightTitle", "EditableFormField_Live"."ShowOnLoad", "EditableFormField_Live"."ShowInSummary", "EditableFormField_Live"."Placeholder", "EditableFormField_Live"."DisplayRulesConjunction", "EditableFormField_Live"."ParentID", "EditableFormField_Live"."ParentClass", "EditableFormField_Live"."ID",
CASE WHEN "EditableFormField_Live"."ClassName" IS NOT NULL THEN "EditableFormField_Live"."ClassName"
ELSE 'SilverStripe\\UserForms\\Model\\EditableFormField' END AS "RecordClassName"
FROM "EditableFormField_Live"
WHERE ("ParentClass" IN ('DNADesign\\ElementalUserForms\\Model\\ElementForm'))
AND ("EditableFormField_Live"."ParentID" = ?)
ORDER BY "EditableFormField_Live"."Sort" ASC
0.0004s
0045: SELECT DISTINCT "EditableFormField_Live"."ClassName", "EditableFormField_Live"."LastEdited", "EditableFormField_Live"."Created", "EditableTextField_Live"."MinLength", "EditableTextField_Live"."MaxLength", "EditableTextField_Live"."Rows", "EditableTextField_Live"."Autocomplete", "EditableFormField_Live"."ID",
CASE WHEN "EditableFormField_Live"."ClassName" IS NOT NULL THEN "EditableFormField_Live"."ClassName"
ELSE 'SilverStripe\\UserForms\\Model\\EditableFormField' END AS "RecordClassName", "EditableFormField_Live"."Sort"
FROM "EditableFormField_Live" LEFT JOIN "EditableTextField_Live" ON "EditableTextField_Live"."ID" = "EditableFormField_Live"."ID"
WHERE ("EditableFormField_Live"."ID" = ?)
AND ("EditableFormField_Live"."ClassName" IN (?))
ORDER BY "EditableFormField_Live"."Sort" ASC
LIMIT 1
0.0002s
0046: SELECT DISTINCT "EditableFormField_Live"."ClassName", "EditableFormField_Live"."LastEdited", "EditableFormField_Live"."Created", "EditableTextField_Live"."MinLength", "EditableTextField_Live"."MaxLength", "EditableTextField_Live"."Rows", "EditableTextField_Live"."Autocomplete", "EditableFormField_Live"."ID",
CASE WHEN "EditableFormField_Live"."ClassName" IS NOT NULL THEN "EditableFormField_Live"."ClassName"
ELSE 'SilverStripe\\UserForms\\Model\\EditableFormField' END AS "RecordClassName", "EditableFormField_Live"."Sort"
FROM "EditableFormField_Live" LEFT JOIN "EditableTextField_Live" ON "EditableTextField_Live"."ID" = "EditableFormField_Live"."ID"
WHERE ("EditableFormField_Live"."ID" = ?)
AND ("EditableFormField_Live"."ClassName" IN (?))
ORDER BY "EditableFormField_Live"."Sort" ASC
LIMIT 1
0.0001s
0047: SELECT DISTINCT "EditableFormField_Live"."ClassName", "EditableFormField_Live"."LastEdited", "EditableFormField_Live"."Created", "EditableTextField_Live"."MinLength", "EditableTextField_Live"."MaxLength", "EditableTextField_Live"."Rows", "EditableTextField_Live"."Autocomplete", "EditableFormField_Live"."ID",
CASE WHEN "EditableFormField_Live"."ClassName" IS NOT NULL THEN "EditableFormField_Live"."ClassName"
ELSE 'SilverStripe\\UserForms\\Model\\EditableFormField' END AS "RecordClassName", "EditableFormField_Live"."Sort"
FROM "EditableFormField_Live" LEFT JOIN "EditableTextField_Live" ON "EditableTextField_Live"."ID" = "EditableFormField_Live"."ID"
WHERE ("EditableFormField_Live"."ID" = ?)
AND ("EditableFormField_Live"."ClassName" IN (?))
ORDER BY "EditableFormField_Live"."Sort" ASC
LIMIT 1
0.0001s
0048: SELECT DISTINCT "EditableFormField_Live"."ClassName", "EditableFormField_Live"."LastEdited", "EditableFormField_Live"."Created", "EditableCheckbox_Live"."CheckedDefault", "EditableFormField_Live"."ID",
CASE WHEN "EditableFormField_Live"."ClassName" IS NOT NULL THEN "EditableFormField_Live"."ClassName"
ELSE 'SilverStripe\\UserForms\\Model\\EditableFormField' END AS "RecordClassName", "EditableFormField_Live"."Sort"
FROM "EditableFormField_Live" LEFT JOIN "EditableCheckbox_Live" ON "EditableCheckbox_Live"."ID" = "EditableFormField_Live"."ID"
WHERE ("EditableFormField_Live"."ID" = ?)
AND ("EditableFormField_Live"."ClassName" IN (?))
ORDER BY "EditableFormField_Live"."Sort" ASC
LIMIT 1
0.0003s
0049: SELECT DISTINCT "Element_Live"."ClassName", "Element_Live"."LastEdited", "Element_Live"."Created", CASE
WHEN "Element_Localised_en_GB"."ID" IS NOT NULL THEN "Element_Localised_en_GB"."Title"
ELSE "Element_Live"."Title" END
AS "Title", "Element_Live"."ExtraCSSClass", CASE
WHEN "Element_Localised_en_GB"."ID" IS NOT NULL THEN "Element_Localised_en_GB"."NavigationName"
ELSE "Element_Live"."NavigationName" END
AS "NavigationName", "Element_Live"."NavigationLink", "Element_Live"."SetNavigation", "Element_Live"."Version", "Element_Live"."ShowTitle", "Element_Live"."Sort", "Element_Live"."ExtraClass", "Element_Live"."Style", "Element_Live"."ParentID", CASE
WHEN "ElementForm_Localised_en_GB"."ID" IS NOT NULL THEN "ElementForm_Localised_en_GB"."SubmitButtonText"
ELSE "ElementForm_Live"."SubmitButtonText" END
AS "SubmitButtonText", CASE
WHEN "ElementForm_Localised_en_GB"."ID" IS NOT NULL THEN "ElementForm_Localised_en_GB"."ClearButtonText"
ELSE "ElementForm_Live"."ClearButtonText" END
AS "ClearButtonText", CASE
WHEN "ElementForm_Localised_en_GB"."ID" IS NOT NULL THEN "ElementForm_Localised_en_GB"."OnCompleteMessage"
ELSE "ElementForm_Live"."OnCompleteMessage" END
AS "OnCompleteMessage", "ElementForm_Live"."ShowClearButton", "ElementForm_Live"."DisableSaveSubmissions", "ElementForm_Live"."EnableLiveValidation", "ElementForm_Live"."DisplayErrorMessagesAtTop", "ElementForm_Live"."DisableAuthenicatedFinishAction", "ElementForm_Live"."DisableCsrfSecurityToken", "Element_Live"."ID",
CASE WHEN "Element_Live"."ClassName" IS NOT NULL THEN "Element_Live"."ClassName"
ELSE 'DNADesign\\Elemental\\Models\\BaseElement' END AS "RecordClassName", 'en_GB' AS "Locale", CASE WHEN "ElementForm_Localised_en_GB"."ID" IS NOT NULL THEN 'en_GB'
ELSE NULL END AS "SourceLocale"
FROM "Element_Live" LEFT JOIN "ElementForm_Live" ON "ElementForm_Live"."ID" = "Element_Live"."ID" LEFT JOIN "Element_Localised_Live" AS "Element_Localised_en_GB" ON "Element_Live"."ID" = "Element_Localised_en_GB"."RecordID" AND "Element_Localised_en_GB"."Locale" = ? LEFT JOIN "ElementForm_Localised_Live" AS "ElementForm_Localised_en_GB" ON "ElementForm_Live"."ID" = "ElementForm_Localised_en_GB"."RecordID" AND "ElementForm_Localised_en_GB"."Locale" = ?
WHERE ("Element_Live"."ID" = ?)
AND ("Element_Live"."ClassName" IN (?))
AND (("Element_Localised_en_GB"."ID" IS NOT NULL))
ORDER BY "Element_Live"."Sort" ASC
LIMIT 1
0.0003s
0050: SELECT DISTINCT "EditableFormField_Live"."ClassName", "EditableFormField_Live"."LastEdited", "EditableFormField_Live"."Created", "EditableFormField_Live"."Version", "EditableFormField_Live"."Name", "EditableFormField_Live"."Title", "EditableFormField_Live"."Default", "EditableFormField_Live"."Sort", "EditableFormField_Live"."Required", "EditableFormField_Live"."CustomErrorMessage", "EditableFormField_Live"."ExtraClass", "EditableFormField_Live"."RightTitle", "EditableFormField_Live"."ShowOnLoad", "EditableFormField_Live"."ShowInSummary", "EditableFormField_Live"."Placeholder", "EditableFormField_Live"."DisplayRulesConjunction", "EditableFormField_Live"."ParentID", "EditableFormField_Live"."ParentClass", "EditableFormField_Live"."ID",
CASE WHEN "EditableFormField_Live"."ClassName" IS NOT NULL THEN "EditableFormField_Live"."ClassName"
ELSE 'SilverStripe\\UserForms\\Model\\EditableFormField' END AS "RecordClassName"
FROM "EditableFormField_Live"
WHERE ("ParentClass" IN ('DNADesign\\ElementalUserForms\\Model\\ElementForm'))
AND ("EditableFormField_Live"."ParentID" = ?)
AND ("EditableFormField_Live"."ClassName" IN (?, ?, ?))
AND (("EditableFormField_Live"."Title" != ? OR "EditableFormField_Live"."Title" IS NULL))
ORDER BY "EditableFormField_Live"."Sort" ASC
0.0003s
0051: SELECT DISTINCT "EditableFormField_Live"."ClassName", "EditableFormField_Live"."LastEdited", "EditableFormField_Live"."Created", "EditableSpamProtectionField_Live"."SpamFieldSettings", "EditableFormField_Live"."ID",
CASE WHEN "EditableFormField_Live"."ClassName" IS NOT NULL THEN "EditableFormField_Live"."ClassName"
ELSE 'SilverStripe\\UserForms\\Model\\EditableFormField' END AS "RecordClassName", "EditableFormField_Live"."Sort"
FROM "EditableFormField_Live" LEFT JOIN "EditableSpamProtectionField_Live" ON "EditableSpamProtectionField_Live"."ID" = "EditableFormField_Live"."ID"
WHERE ("EditableFormField_Live"."ID" = ?)
AND ("EditableFormField_Live"."ClassName" IN (?))
ORDER BY "EditableFormField_Live"."Sort" ASC
LIMIT 1
0.0002s
0052: SELECT DISTINCT "EditableFormField_Live"."ClassName", "EditableFormField_Live"."LastEdited", "EditableFormField_Live"."Created", "EditableFormField_Live"."Version", "EditableFormField_Live"."Name", "EditableFormField_Live"."Title", "EditableFormField_Live"."Default", "EditableFormField_Live"."Sort", "EditableFormField_Live"."Required", "EditableFormField_Live"."CustomErrorMessage", "EditableFormField_Live"."ExtraClass", "EditableFormField_Live"."RightTitle", "EditableFormField_Live"."ShowOnLoad", "EditableFormField_Live"."ShowInSummary", "EditableFormField_Live"."Placeholder", "EditableFormField_Live"."DisplayRulesConjunction", "EditableFormField_Live"."ParentID", "EditableFormField_Live"."ParentClass", "EditableFormField_Live"."ID",
CASE WHEN "EditableFormField_Live"."ClassName" IS NOT NULL THEN "EditableFormField_Live"."ClassName"
ELSE 'SilverStripe\\UserForms\\Model\\EditableFormField' END AS "RecordClassName"
FROM "EditableFormField_Live"
WHERE ("ParentClass" IN ('DNADesign\\ElementalUserForms\\Model\\ElementForm'))
AND ("EditableFormField_Live"."ParentID" = ?)
AND ("EditableFormField_Live"."ClassName" IN (?, ?, ?))
AND (("EditableFormField_Live"."Title" != ? OR "EditableFormField_Live"."Title" IS NULL))
ORDER BY "EditableFormField_Live"."Sort" ASC
0.0001s
0053: SELECT DISTINCT "Element_Live"."ClassName", "Element_Live"."LastEdited", "Element_Live"."Created", CASE
WHEN "ElementForm_Localised_en_GB"."ID" IS NOT NULL THEN "ElementForm_Localised_en_GB"."SubmitButtonText"
ELSE "ElementForm_Live"."SubmitButtonText" END
AS "SubmitButtonText", CASE
WHEN "ElementForm_Localised_en_GB"."ID" IS NOT NULL THEN "ElementForm_Localised_en_GB"."ClearButtonText"
ELSE "ElementForm_Live"."ClearButtonText" END
AS "ClearButtonText", CASE
WHEN "ElementForm_Localised_en_GB"."ID" IS NOT NULL THEN "ElementForm_Localised_en_GB"."OnCompleteMessage"
ELSE "ElementForm_Live"."OnCompleteMessage" END
AS "OnCompleteMessage", "ElementForm_Live"."ShowClearButton", "ElementForm_Live"."DisableSaveSubmissions", "ElementForm_Live"."EnableLiveValidation", "ElementForm_Live"."DisplayErrorMessagesAtTop", "ElementForm_Live"."DisableAuthenicatedFinishAction", "ElementForm_Live"."DisableCsrfSecurityToken", "Element_Live"."ID",
CASE WHEN "Element_Live"."ClassName" IS NOT NULL THEN "Element_Live"."ClassName"
ELSE 'DNADesign\\Elemental\\Models\\BaseElement' END AS "RecordClassName", 'en_GB' AS "Locale", CASE WHEN "ElementForm_Localised_en_GB"."ID" IS NOT NULL THEN 'en_GB'
ELSE NULL END AS "SourceLocale", "Element_Live"."Sort"
FROM "Element_Live" LEFT JOIN "ElementForm_Live" ON "ElementForm_Live"."ID" = "Element_Live"."ID" LEFT JOIN "Element_Localised_Live" AS "Element_Localised_en_GB" ON "Element_Live"."ID" = "Element_Localised_en_GB"."RecordID" AND "Element_Localised_en_GB"."Locale" = ? LEFT JOIN "ElementForm_Localised_Live" AS "ElementForm_Localised_en_GB" ON "ElementForm_Live"."ID" = "ElementForm_Localised_en_GB"."RecordID" AND "ElementForm_Localised_en_GB"."Locale" = ?
WHERE ("Element_Live"."ID" = ?)
AND ("Element_Live"."ClassName" IN (?))
AND (("Element_Localised_en_GB"."ID" IS NOT NULL))
ORDER BY "Element_Live"."Sort" ASC
LIMIT 1
0.0003s
0054: SELECT "EditableFormField_Live"."Name", "EditableFormField_Live"."Sort" AS "_SortColumn0"
FROM "EditableFormField_Live"
WHERE ("ParentClass" IN ('DNADesign\\ElementalUserForms\\Model\\ElementForm'))
AND ("EditableFormField_Live"."ParentID" = ?)
AND ("EditableFormField_Live"."Required" = ?)
ORDER BY "_SortColumn0" ASC
0.0002s
0055: SELECT DISTINCT "UserDefinedForm_EmailRecipient"."ClassName", "UserDefinedForm_EmailRecipient"."LastEdited", "UserDefinedForm_EmailRecipient"."Created", "UserDefinedForm_EmailRecipient"."EmailAddress", "UserDefinedForm_EmailRecipient"."EmailSubject", "UserDefinedForm_EmailRecipient"."EmailFrom", "UserDefinedForm_EmailRecipient"."EmailReplyTo", "UserDefinedForm_EmailRecipient"."EmailBody", "UserDefinedForm_EmailRecipient"."EmailBodyHtml", "UserDefinedForm_EmailRecipient"."EmailTemplate", "UserDefinedForm_EmailRecipient"."SendPlain", "UserDefinedForm_EmailRecipient"."HideFormData", "UserDefinedForm_EmailRecipient"."HideInvisibleFields", "UserDefinedForm_EmailRecipient"."CustomRulesCondition", "UserDefinedForm_EmailRecipient"."SendEmailFromFieldID", "UserDefinedForm_EmailRecipient"."SendEmailToFieldID", "UserDefinedForm_EmailRecipient"."SendEmailSubjectFieldID", "UserDefinedForm_EmailRecipient"."FormID", "UserDefinedForm_EmailRecipient"."FormClass", "UserDefinedForm_EmailRecipient"."ID",
CASE WHEN "UserDefinedForm_EmailRecipient"."ClassName" IS NOT NULL THEN "UserDefinedForm_EmailRecipient"."ClassName"
ELSE 'SilverStripe\\UserForms\\Model\\Recipient\\EmailRecipient' END AS "RecordClassName"
FROM "UserDefinedForm_EmailRecipient"
WHERE ("FormClass" IN ('DNADesign\\ElementalUserForms\\Model\\ElementForm'))
AND ("UserDefinedForm_EmailRecipient"."FormID" = ?)
0.0002s
0056: SELECT DISTINCT "EditableFormField_Live"."ClassName", "EditableFormField_Live"."LastEdited", "EditableFormField_Live"."Created", "EditableFormField_Live"."Version", "EditableFormField_Live"."Name", "EditableFormField_Live"."Title", "EditableFormField_Live"."Default", "EditableFormField_Live"."Sort", "EditableFormField_Live"."Required", "EditableFormField_Live"."CustomErrorMessage", "EditableFormField_Live"."ExtraClass", "EditableFormField_Live"."RightTitle", "EditableFormField_Live"."ShowOnLoad", "EditableFormField_Live"."ShowInSummary", "EditableFormField_Live"."Placeholder", "EditableFormField_Live"."DisplayRulesConjunction", "EditableFormField_Live"."ParentID", "EditableFormField_Live"."ParentClass", "EditableFormField_Live"."ID",
CASE WHEN "EditableFormField_Live"."ClassName" IS NOT NULL THEN "EditableFormField_Live"."ClassName"
ELSE 'SilverStripe\\UserForms\\Model\\EditableFormField' END AS "RecordClassName"
FROM "EditableFormField_Live"
WHERE ("ParentClass" IN ('DNADesign\\ElementalUserForms\\Model\\ElementForm'))
AND ("EditableFormField_Live"."ParentID" = ?)
ORDER BY "EditableFormField_Live"."Sort" ASC
0.0001s
0057: SELECT DISTINCT "EditableCustomRule_Live"."ClassName", "EditableCustomRule_Live"."LastEdited", "EditableCustomRule_Live"."Created", "EditableCustomRule_Live"."Version", "EditableCustomRule_Live"."Display", "EditableCustomRule_Live"."ConditionOption", "EditableCustomRule_Live"."FieldValue", "EditableCustomRule_Live"."ParentID", "EditableCustomRule_Live"."ConditionFieldID", "EditableCustomRule_Live"."ID",
CASE WHEN "EditableCustomRule_Live"."ClassName" IS NOT NULL THEN "EditableCustomRule_Live"."ClassName"
ELSE 'SilverStripe\\UserForms\\Model\\EditableCustomRule' END AS "RecordClassName"
FROM "EditableCustomRule_Live"
WHERE ("EditableCustomRule_Live"."ParentID" = ?)
0.0002s
0058: SELECT DISTINCT "EditableCustomRule_Live"."ClassName", "EditableCustomRule_Live"."LastEdited", "EditableCustomRule_Live"."Created", "EditableCustomRule_Live"."Version", "EditableCustomRule_Live"."Display", "EditableCustomRule_Live"."ConditionOption", "EditableCustomRule_Live"."FieldValue", "EditableCustomRule_Live"."ParentID", "EditableCustomRule_Live"."ConditionFieldID", "EditableCustomRule_Live"."ID",
CASE WHEN "EditableCustomRule_Live"."ClassName" IS NOT NULL THEN "EditableCustomRule_Live"."ClassName"
ELSE 'SilverStripe\\UserForms\\Model\\EditableCustomRule' END AS "RecordClassName"
FROM "EditableCustomRule_Live"
WHERE ("EditableCustomRule_Live"."ParentID" = ?)
0.0001s
0059: SELECT DISTINCT "EditableCustomRule_Live"."ClassName", "EditableCustomRule_Live"."LastEdited", "EditableCustomRule_Live"."Created", "EditableCustomRule_Live"."Version", "EditableCustomRule_Live"."Display", "EditableCustomRule_Live"."ConditionOption", "EditableCustomRule_Live"."FieldValue", "EditableCustomRule_Live"."ParentID", "EditableCustomRule_Live"."ConditionFieldID", "EditableCustomRule_Live"."ID",
CASE WHEN "EditableCustomRule_Live"."ClassName" IS NOT NULL THEN "EditableCustomRule_Live"."ClassName"
ELSE 'SilverStripe\\UserForms\\Model\\EditableCustomRule' END AS "RecordClassName"
FROM "EditableCustomRule_Live"
WHERE ("EditableCustomRule_Live"."ParentID" = ?)
0.0001s
0060: SELECT DISTINCT "EditableCustomRule_Live"."ClassName", "EditableCustomRule_Live"."LastEdited", "EditableCustomRule_Live"."Created", "EditableCustomRule_Live"."Version", "EditableCustomRule_Live"."Display", "EditableCustomRule_Live"."ConditionOption", "EditableCustomRule_Live"."FieldValue", "EditableCustomRule_Live"."ParentID", "EditableCustomRule_Live"."ConditionFieldID", "EditableCustomRule_Live"."ID",
CASE WHEN "EditableCustomRule_Live"."ClassName" IS NOT NULL THEN "EditableCustomRule_Live"."ClassName"
ELSE 'SilverStripe\\UserForms\\Model\\EditableCustomRule' END AS "RecordClassName"
FROM "EditableCustomRule_Live"
WHERE ("EditableCustomRule_Live"."ParentID" = ?)
0.0001s
0061: SELECT DISTINCT "EditableCustomRule_Live"."ClassName", "EditableCustomRule_Live"."LastEdited", "EditableCustomRule_Live"."Created", "EditableCustomRule_Live"."Version", "EditableCustomRule_Live"."Display", "EditableCustomRule_Live"."ConditionOption", "EditableCustomRule_Live"."FieldValue", "EditableCustomRule_Live"."ParentID", "EditableCustomRule_Live"."ConditionFieldID", "EditableCustomRule_Live"."ID",
CASE WHEN "EditableCustomRule_Live"."ClassName" IS NOT NULL THEN "EditableCustomRule_Live"."ClassName"
ELSE 'SilverStripe\\UserForms\\Model\\EditableCustomRule' END AS "RecordClassName"
FROM "EditableCustomRule_Live"
WHERE ("EditableCustomRule_Live"."ParentID" = ?)
0.0001s
0062: SELECT DISTINCT "EditableCustomRule_Live"."ClassName", "EditableCustomRule_Live"."LastEdited", "EditableCustomRule_Live"."Created", "EditableCustomRule_Live"."Version", "EditableCustomRule_Live"."Display", "EditableCustomRule_Live"."ConditionOption", "EditableCustomRule_Live"."FieldValue", "EditableCustomRule_Live"."ParentID", "EditableCustomRule_Live"."ConditionFieldID", "EditableCustomRule_Live"."ID",
CASE WHEN "EditableCustomRule_Live"."ClassName" IS NOT NULL THEN "EditableCustomRule_Live"."ClassName"
ELSE 'SilverStripe\\UserForms\\Model\\EditableCustomRule' END AS "RecordClassName"
FROM "EditableCustomRule_Live"
WHERE ("EditableCustomRule_Live"."ParentID" = ?)
0s
0063: SELECT DISTINCT "EditableCustomRule_Live"."ClassName", "EditableCustomRule_Live"."LastEdited", "EditableCustomRule_Live"."Created", "EditableCustomRule_Live"."Version", "EditableCustomRule_Live"."Display", "EditableCustomRule_Live"."ConditionOption", "EditableCustomRule_Live"."FieldValue", "EditableCustomRule_Live"."ParentID", "EditableCustomRule_Live"."ConditionFieldID", "EditableCustomRule_Live"."ID",
CASE WHEN "EditableCustomRule_Live"."ClassName" IS NOT NULL THEN "EditableCustomRule_Live"."ClassName"
ELSE 'SilverStripe\\UserForms\\Model\\EditableCustomRule' END AS "RecordClassName"
FROM "EditableCustomRule_Live"
WHERE ("EditableCustomRule_Live"."ParentID" = ?)
0.0001s
0064: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", CASE
WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."BetterSiteTitle"
ELSE "SiteTree_Live"."BetterSiteTitle" END
AS "BetterSiteTitle", CASE
WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."Keyword"
ELSE "SiteTree_Live"."Keyword" END
AS "Keyword", CASE
WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."FeaturedKeyword"
ELSE "SiteTree_Live"."FeaturedKeyword" END
AS "FeaturedKeyword", CASE
WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."KeywordQuestion"
ELSE "SiteTree_Live"."KeywordQuestion" END
AS "KeywordQuestion", "SiteTree_Live"."Follow", "SiteTree_Live"."FollowType", CASE
WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."GenMetaDesc"
ELSE "SiteTree_Live"."GenMetaDesc" END
AS "GenMetaDesc", CASE
WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."FBTitle"
ELSE "SiteTree_Live"."FBTitle" END
AS "FBTitle", CASE
WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."FBDescription"
ELSE "SiteTree_Live"."FBDescription" END
AS "FBDescription", "SiteTree_Live"."FBType", "SiteTree_Live"."FBTypeOverride", CASE
WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."TwTitle"
ELSE "SiteTree_Live"."TwTitle" END
AS "TwTitle", CASE
WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."TwDescription"
ELSE "SiteTree_Live"."TwDescription" END
AS "TwDescription", "SiteTree_Live"."CanViewType", "SiteTree_Live"."CanEditType", "SiteTree_Live"."Version", CASE
WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."URLSegment"
ELSE "SiteTree_Live"."URLSegment" END
AS "URLSegment", CASE
WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."Title"
ELSE "SiteTree_Live"."Title" END
AS "Title", CASE
WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."MenuTitle"
ELSE "SiteTree_Live"."MenuTitle" END
AS "MenuTitle", CASE
WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."Content"
ELSE "SiteTree_Live"."Content" END
AS "Content", CASE
WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."MetaDescription"
ELSE "SiteTree_Live"."MetaDescription" END
AS "MetaDescription", "SiteTree_Live"."ExtraMeta", "SiteTree_Live"."ShowInMenus", "SiteTree_Live"."ShowInSearch", "SiteTree_Live"."Sort", "SiteTree_Live"."HasBrokenFile", "SiteTree_Live"."HasBrokenLink", CASE
WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."ReportClass"
ELSE "SiteTree_Live"."ReportClass" END
AS "ReportClass", "SiteTree_Live"."CanonicalLinkID", "SiteTree_Live"."FBImageID", "SiteTree_Live"."TwImageID", "SiteTree_Live"."ParentID", "SiteTree_Live"."ID",
CASE WHEN "SiteTree_Live"."ClassName" IS NOT NULL THEN "SiteTree_Live"."ClassName"
ELSE 'SilverStripe\\CMS\\Model\\SiteTree' END AS "RecordClassName", 'en_GB' AS "Locale", CASE WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN 'en_GB'
ELSE NULL END AS "SourceLocale"
FROM "SiteTree_Live" LEFT JOIN "SiteTree_Localised_Live" AS "SiteTree_Localised_en_GB" ON "SiteTree_Live"."ID" = "SiteTree_Localised_en_GB"."RecordID" AND "SiteTree_Localised_en_GB"."Locale" = ?
WHERE ("SiteTree_Live"."ID" = ?)
AND (("SiteTree_Localised_en_GB"."ID" IS NOT NULL))
ORDER BY "SiteTree_Live"."Sort" ASC
LIMIT 1
0.0001s
0065: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", CASE
WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."BetterSiteTitle"
ELSE "SiteTree_Live"."BetterSiteTitle" END
AS "BetterSiteTitle", CASE
WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."Keyword"
ELSE "SiteTree_Live"."Keyword" END
AS "Keyword", CASE
WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."FeaturedKeyword"
ELSE "SiteTree_Live"."FeaturedKeyword" END
AS "FeaturedKeyword", CASE
WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."KeywordQuestion"
ELSE "SiteTree_Live"."KeywordQuestion" END
AS "KeywordQuestion", "SiteTree_Live"."Follow", "SiteTree_Live"."FollowType", CASE
WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."GenMetaDesc"
ELSE "SiteTree_Live"."GenMetaDesc" END
AS "GenMetaDesc", CASE
WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."FBTitle"
ELSE "SiteTree_Live"."FBTitle" END
AS "FBTitle", CASE
WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."FBDescription"
ELSE "SiteTree_Live"."FBDescription" END
AS "FBDescription", "SiteTree_Live"."FBType", "SiteTree_Live"."FBTypeOverride", CASE
WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."TwTitle"
ELSE "SiteTree_Live"."TwTitle" END
AS "TwTitle", CASE
WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."TwDescription"
ELSE "SiteTree_Live"."TwDescription" END
AS "TwDescription", "SiteTree_Live"."CanViewType", "SiteTree_Live"."CanEditType", "SiteTree_Live"."Version", CASE
WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."URLSegment"
ELSE "SiteTree_Live"."URLSegment" END
AS "URLSegment", CASE
WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."Title"
ELSE "SiteTree_Live"."Title" END
AS "Title", CASE
WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."MenuTitle"
ELSE "SiteTree_Live"."MenuTitle" END
AS "MenuTitle", CASE
WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."Content"
ELSE "SiteTree_Live"."Content" END
AS "Content", CASE
WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."MetaDescription"
ELSE "SiteTree_Live"."MetaDescription" END
AS "MetaDescription", "SiteTree_Live"."ExtraMeta", "SiteTree_Live"."ShowInMenus", "SiteTree_Live"."ShowInSearch", "SiteTree_Live"."Sort", "SiteTree_Live"."HasBrokenFile", "SiteTree_Live"."HasBrokenLink", CASE
WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."ReportClass"
ELSE "SiteTree_Live"."ReportClass" END
AS "ReportClass", "SiteTree_Live"."CanonicalLinkID", "SiteTree_Live"."FBImageID", "SiteTree_Live"."TwImageID", "SiteTree_Live"."ParentID", "SiteTree_Live"."ID",
CASE WHEN "SiteTree_Live"."ClassName" IS NOT NULL THEN "SiteTree_Live"."ClassName"
ELSE 'SilverStripe\\CMS\\Model\\SiteTree' END AS "RecordClassName", 'en_GB' AS "Locale", CASE WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN 'en_GB'
ELSE NULL END AS "SourceLocale"
FROM "SiteTree_Live" LEFT JOIN "SiteTree_Localised_Live" AS "SiteTree_Localised_en_GB" ON "SiteTree_Live"."ID" = "SiteTree_Localised_en_GB"."RecordID" AND "SiteTree_Localised_en_GB"."Locale" = ?
WHERE ("SiteTree_Live"."ID" = ?)
AND (("SiteTree_Localised_en_GB"."ID" IS NOT NULL))
ORDER BY "SiteTree_Live"."Sort" ASC
LIMIT 1
0.0001s
0066: SELECT DISTINCT "File_Live"."ClassName", "File_Live"."LastEdited", "File_Live"."Created", "File_Live"."UserFormUpload", "File_Live"."Version", "File_Live"."CanViewType", "File_Live"."CanEditType", "File_Live"."Name", "File_Live"."Title", "File_Live"."ShowInSearch", "File_Live"."ParentID", "File_Live"."OwnerID", "File_Live"."FileHash", "File_Live"."FileFilename", "File_Live"."FileVariant", "File_Live"."ID",
CASE WHEN "File_Live"."ClassName" IS NOT NULL THEN "File_Live"."ClassName"
ELSE 'SilverStripe\\Assets\\File' END AS "RecordClassName"
FROM "File_Live"
WHERE ("File_Live"."ID" = ?)
ORDER BY "File_Live"."Name" ASC
LIMIT 1
0.0001s
0067: SELECT "Version" FROM "SiteTree" WHERE "ID" = ?
0.0002s
0068: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", CASE
WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."BetterSiteTitle"
ELSE "SiteTree_Live"."BetterSiteTitle" END
AS "BetterSiteTitle", CASE
WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."Keyword"
ELSE "SiteTree_Live"."Keyword" END
AS "Keyword", CASE
WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."FeaturedKeyword"
ELSE "SiteTree_Live"."FeaturedKeyword" END
AS "FeaturedKeyword", CASE
WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."KeywordQuestion"
ELSE "SiteTree_Live"."KeywordQuestion" END
AS "KeywordQuestion", "SiteTree_Live"."Follow", "SiteTree_Live"."FollowType", CASE
WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."GenMetaDesc"
ELSE "SiteTree_Live"."GenMetaDesc" END
AS "GenMetaDesc", CASE
WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."FBTitle"
ELSE "SiteTree_Live"."FBTitle" END
AS "FBTitle", CASE
WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."FBDescription"
ELSE "SiteTree_Live"."FBDescription" END
AS "FBDescription", "SiteTree_Live"."FBType", "SiteTree_Live"."FBTypeOverride", CASE
WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."TwTitle"
ELSE "SiteTree_Live"."TwTitle" END
AS "TwTitle", CASE
WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."TwDescription"
ELSE "SiteTree_Live"."TwDescription" END
AS "TwDescription", "SiteTree_Live"."CanViewType", "SiteTree_Live"."CanEditType", "SiteTree_Live"."Version", CASE
WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."URLSegment"
ELSE "SiteTree_Live"."URLSegment" END
AS "URLSegment", CASE
WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."Title"
ELSE "SiteTree_Live"."Title" END
AS "Title", CASE
WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."MenuTitle"
ELSE "SiteTree_Live"."MenuTitle" END
AS "MenuTitle", CASE
WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."Content"
ELSE "SiteTree_Live"."Content" END
AS "Content", CASE
WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."MetaDescription"
ELSE "SiteTree_Live"."MetaDescription" END
AS "MetaDescription", "SiteTree_Live"."ExtraMeta", "SiteTree_Live"."ShowInMenus", "SiteTree_Live"."ShowInSearch", "SiteTree_Live"."Sort", "SiteTree_Live"."HasBrokenFile", "SiteTree_Live"."HasBrokenLink", CASE
WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."ReportClass"
ELSE "SiteTree_Live"."ReportClass" END
AS "ReportClass", "SiteTree_Live"."CanonicalLinkID", "SiteTree_Live"."FBImageID", "SiteTree_Live"."TwImageID", "SiteTree_Live"."ParentID", "SiteTree_Live"."ID",
CASE WHEN "SiteTree_Live"."ClassName" IS NOT NULL THEN "SiteTree_Live"."ClassName"
ELSE 'SilverStripe\\CMS\\Model\\SiteTree' END AS "RecordClassName", 'en_GB' AS "Locale", CASE WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN 'en_GB'
ELSE NULL END AS "SourceLocale"
FROM "SiteTree_Live" LEFT JOIN "SiteTree_Localised_Live" AS "SiteTree_Localised_en_GB" ON "SiteTree_Live"."ID" = "SiteTree_Localised_en_GB"."RecordID" AND "SiteTree_Localised_en_GB"."Locale" = ?
WHERE ("SiteTree_Live"."ID" = ?)
AND (("SiteTree_Localised_en_GB"."ID" IS NOT NULL))
ORDER BY "SiteTree_Live"."Sort" ASC
LIMIT 1
0.0001s
0069: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", CASE
WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."BetterSiteTitle"
ELSE "SiteTree_Live"."BetterSiteTitle" END
AS "BetterSiteTitle", CASE
WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."Keyword"
ELSE "SiteTree_Live"."Keyword" END
AS "Keyword", CASE
WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."FeaturedKeyword"
ELSE "SiteTree_Live"."FeaturedKeyword" END
AS "FeaturedKeyword", CASE
WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."KeywordQuestion"
ELSE "SiteTree_Live"."KeywordQuestion" END
AS "KeywordQuestion", "SiteTree_Live"."Follow", "SiteTree_Live"."FollowType", CASE
WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."GenMetaDesc"
ELSE "SiteTree_Live"."GenMetaDesc" END
AS "GenMetaDesc", CASE
WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."FBTitle"
ELSE "SiteTree_Live"."FBTitle" END
AS "FBTitle", CASE
WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."FBDescription"
ELSE "SiteTree_Live"."FBDescription" END
AS "FBDescription", "SiteTree_Live"."FBType", "SiteTree_Live"."FBTypeOverride", CASE
WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."TwTitle"
ELSE "SiteTree_Live"."TwTitle" END
AS "TwTitle", CASE
WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."TwDescription"
ELSE "SiteTree_Live"."TwDescription" END
AS "TwDescription", "SiteTree_Live"."CanViewType", "SiteTree_Live"."CanEditType", "SiteTree_Live"."Version", CASE
WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."URLSegment"
ELSE "SiteTree_Live"."URLSegment" END
AS "URLSegment", CASE
WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."Title"
ELSE "SiteTree_Live"."Title" END
AS "Title", CASE
WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."MenuTitle"
ELSE "SiteTree_Live"."MenuTitle" END
AS "MenuTitle", CASE
WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."Content"
ELSE "SiteTree_Live"."Content" END
AS "Content", CASE
WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."MetaDescription"
ELSE "SiteTree_Live"."MetaDescription" END
AS "MetaDescription", "SiteTree_Live"."ExtraMeta", "SiteTree_Live"."ShowInMenus", "SiteTree_Live"."ShowInSearch", "SiteTree_Live"."Sort", "SiteTree_Live"."HasBrokenFile", "SiteTree_Live"."HasBrokenLink", CASE
WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."ReportClass"
ELSE "SiteTree_Live"."ReportClass" END
AS "ReportClass", "SiteTree_Live"."CanonicalLinkID", "SiteTree_Live"."FBImageID", "SiteTree_Live"."TwImageID", "SiteTree_Live"."ParentID", "SiteTree_Live"."ID",
CASE WHEN "SiteTree_Live"."ClassName" IS NOT NULL THEN "SiteTree_Live"."ClassName"
ELSE 'SilverStripe\\CMS\\Model\\SiteTree' END AS "RecordClassName", 'en_GB' AS "Locale", CASE WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN 'en_GB'
ELSE NULL END AS "SourceLocale"
FROM "SiteTree_Live" LEFT JOIN "SiteTree_Localised_Live" AS "SiteTree_Localised_en_GB" ON "SiteTree_Live"."ID" = "SiteTree_Localised_en_GB"."RecordID" AND "SiteTree_Localised_en_GB"."Locale" = ?
WHERE ("SiteTree_Live"."ID" = ?)
AND (("SiteTree_Localised_en_GB"."ID" IS NOT NULL))
ORDER BY "SiteTree_Live"."Sort" ASC
LIMIT 1
0.0001s
0070: SELECT DISTINCT "SiteTree"."ClassName", "SiteTree"."LastEdited", "SiteTree"."Created", "SiteTree"."Priority", CASE
WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."BetterSiteTitle"
ELSE "SiteTree"."BetterSiteTitle" END
AS "BetterSiteTitle", CASE
WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."Keyword"
ELSE "SiteTree"."Keyword" END
AS "Keyword", CASE
WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."FeaturedKeyword"
ELSE "SiteTree"."FeaturedKeyword" END
AS "FeaturedKeyword", CASE
WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."KeywordQuestion"
ELSE "SiteTree"."KeywordQuestion" END
AS "KeywordQuestion", "SiteTree"."Follow", "SiteTree"."FollowType", CASE
WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."GenMetaDesc"
ELSE "SiteTree"."GenMetaDesc" END
AS "GenMetaDesc", CASE
WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."FBTitle"
ELSE "SiteTree"."FBTitle" END
AS "FBTitle", CASE
WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."FBDescription"
ELSE "SiteTree"."FBDescription" END
AS "FBDescription", "SiteTree"."FBType", "SiteTree"."FBTypeOverride", CASE
WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."TwTitle"
ELSE "SiteTree"."TwTitle" END
AS "TwTitle", CASE
WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."TwDescription"
ELSE "SiteTree"."TwDescription" END
AS "TwDescription", "SiteTree"."CanViewType", "SiteTree"."CanEditType", "SiteTree"."Version", CASE
WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."URLSegment"
ELSE "SiteTree"."URLSegment" END
AS "URLSegment", CASE
WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."Title"
ELSE "SiteTree"."Title" END
AS "Title", CASE
WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."MenuTitle"
ELSE "SiteTree"."MenuTitle" END
AS "MenuTitle", CASE
WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."Content"
ELSE "SiteTree"."Content" END
AS "Content", CASE
WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."MetaDescription"
ELSE "SiteTree"."MetaDescription" END
AS "MetaDescription", "SiteTree"."ExtraMeta", "SiteTree"."ShowInMenus", "SiteTree"."ShowInSearch", "SiteTree"."Sort", "SiteTree"."HasBrokenFile", "SiteTree"."HasBrokenLink", CASE
WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."ReportClass"
ELSE "SiteTree"."ReportClass" END
AS "ReportClass", "SiteTree"."CanonicalLinkID", "SiteTree"."FBImageID", "SiteTree"."TwImageID", "SiteTree"."ParentID", "SiteTree"."ID",
CASE WHEN "SiteTree"."ClassName" IS NOT NULL THEN "SiteTree"."ClassName"
ELSE 'SilverStripe\\CMS\\Model\\SiteTree' END AS "RecordClassName", 'en_GB' AS "Locale", CASE WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN 'en_GB'
ELSE NULL END AS "SourceLocale"
FROM "SiteTree" LEFT JOIN "SiteTree_Localised" AS "SiteTree_Localised_en_GB" ON "SiteTree"."ID" = "SiteTree_Localised_en_GB"."RecordID" AND "SiteTree_Localised_en_GB"."Locale" = ?
WHERE ("SiteTree"."ID" = ?)
AND (("SiteTree_Localised_en_GB"."ID" IS NOT NULL))
ORDER BY "SiteTree"."Sort" ASC
LIMIT 1
0.0003s
0071: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", CASE
WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."BetterSiteTitle"
ELSE "SiteTree_Live"."BetterSiteTitle" END
AS "BetterSiteTitle", CASE
WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."Keyword"
ELSE "SiteTree_Live"."Keyword" END
AS "Keyword", CASE
WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."FeaturedKeyword"
ELSE "SiteTree_Live"."FeaturedKeyword" END
AS "FeaturedKeyword", CASE
WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."KeywordQuestion"
ELSE "SiteTree_Live"."KeywordQuestion" END
AS "KeywordQuestion", "SiteTree_Live"."Follow", "SiteTree_Live"."FollowType", CASE
WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."GenMetaDesc"
ELSE "SiteTree_Live"."GenMetaDesc" END
AS "GenMetaDesc", CASE
WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."FBTitle"
ELSE "SiteTree_Live"."FBTitle" END
AS "FBTitle", CASE
WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."FBDescription"
ELSE "SiteTree_Live"."FBDescription" END
AS "FBDescription", "SiteTree_Live"."FBType", "SiteTree_Live"."FBTypeOverride", CASE
WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."TwTitle"
ELSE "SiteTree_Live"."TwTitle" END
AS "TwTitle", CASE
WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."TwDescription"
ELSE "SiteTree_Live"."TwDescription" END
AS "TwDescription", "SiteTree_Live"."CanViewType", "SiteTree_Live"."CanEditType", "SiteTree_Live"."Version", CASE
WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."URLSegment"
ELSE "SiteTree_Live"."URLSegment" END
AS "URLSegment", CASE
WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."Title"
ELSE "SiteTree_Live"."Title" END
AS "Title", CASE
WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."MenuTitle"
ELSE "SiteTree_Live"."MenuTitle" END
AS "MenuTitle", CASE
WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."Content"
ELSE "SiteTree_Live"."Content" END
AS "Content", CASE
WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."MetaDescription"
ELSE "SiteTree_Live"."MetaDescription" END
AS "MetaDescription", "SiteTree_Live"."ExtraMeta", "SiteTree_Live"."ShowInMenus", "SiteTree_Live"."ShowInSearch", "SiteTree_Live"."Sort", "SiteTree_Live"."HasBrokenFile", "SiteTree_Live"."HasBrokenLink", CASE
WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."ReportClass"
ELSE "SiteTree_Live"."ReportClass" END
AS "ReportClass", "SiteTree_Live"."CanonicalLinkID", "SiteTree_Live"."FBImageID", "SiteTree_Live"."TwImageID", "SiteTree_Live"."ParentID", "SiteTree_Live"."ID",
CASE WHEN "SiteTree_Live"."ClassName" IS NOT NULL THEN "SiteTree_Live"."ClassName"
ELSE 'SilverStripe\\CMS\\Model\\SiteTree' END AS "RecordClassName", 'en_GB' AS "Locale", CASE WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN 'en_GB'
ELSE NULL END AS "SourceLocale"
FROM "SiteTree_Live" LEFT JOIN "SiteTree_Localised_Live" AS "SiteTree_Localised_en_GB" ON "SiteTree_Live"."ID" = "SiteTree_Localised_en_GB"."RecordID" AND "SiteTree_Localised_en_GB"."Locale" = ?
WHERE ("SiteTree_Live"."ID" = ?)
AND (("SiteTree_Localised_en_GB"."ID" IS NOT NULL))
ORDER BY "SiteTree_Live"."Sort" ASC
LIMIT 1
0.0001s
Stadtführung in Bremen » Guided city tours in Bremen
welcome to the website of Stadtgeschichten Bremen. Nice that you are here! Let yourself be enchanted by the most beautiful sides of Bremen during a city tour and experience the historical, but also the modern city. Enjoy small tastings at different stations or feast through two different restaurants during the tour.
On a city tour, you will hear the stories behind the facades and discover exciting details that you would otherwise have passed by. Special themed tours highlight unique aspects of the city that you would not have experienced in depth otherwise. Let us surprise you...
How about a guided tour of the city for your next company outing, family reunion, club outing or corporate event?
Whether on foot, by bus, by bike or virtually - in any case it will be entertaining for you. Stadtgeschichten Bremen offers you a varied program at any time of the year. With many anecdotes or legends, historical with information about the city's history, culinary or with stories to guess along, we will gladly adapt to your individual wishes and ideas for your perfect event.
If it is not possible for you to do a city tour, we will gladly come to you within Bremen and the surrounding area and bring you and your guests closer to Bremen by means of a virtual city tour. Or we will be happy to provide you and your guests with information about Bremen during your event. Feel free to contact us. There are many ways to inspire people for the old Hanseatic city.
Become a Bremen fan, too.
We are looking forward to meeting you!
Yours Jasmin Nitzschner and the Stadtgeschichten Bremen team
Below you will find a first small selection of our city tours. Further offers can be found under the menu item "Guided Tours".
During this entertaining tour through the historic city centre you will discover the market place, the artistic Böttcherstrasse, the Weser promenade and the Schnoor quarter. You will learn interesting things about the history of the old Hanseatic city and curious facts about life in Bremen, including amusing little anecdotes. At the end you will have gained a good overview of the city.
Price: € 18.00 per person, incl. VAT
This public tour is only available in German.
Prior registration is not mandatory, but we recommend it. You can also come to the meeting point spontaneously and buy a ticket in cash on the spot.
Meeting point: In front of the main entrance of St. Peter's Cathedral (at the steps, on the side where the two large church towers are located) Duration: 2 hours
Your ingenuity is in demand: on this guided tour through Bremen's Old town, you will listen to interesting and entertaining stories about the city's past and present. The special thing about it: In between, you will also be served up some lies without scruples, which you are supposed to figure out. At the beginning of the tour, each guest will be given a sheet with "true" or "false" checkboxes for each specific story told during the tour. At the end, you will get the solution of which stories are true and which are a lie. You will certainly be surprised at one point or another about which stories turn out to be true and which are fictitious...
Price: € 18.00 per person, incl. VAT
This tour is only available in German.
Prior registration is not mandatory, but we recommend it. You can also come to the meeting point spontaneously and buy a ticket in cash on the spot. Duration: 2 hours
Meeting point: In front of the main entrance of St. Peter's Cathedral (at the steps, on the side where the two large church towers are located)
Bremen has more to offer than you might think - and with our exciting city rally you can discover the city in an unforgettable way! Immerse yourself in the history, culture and hidden corners of the city and experience Bremen from a completely new perspective. Our city rally for adults is the perfect mix of adventure, fun and urban discovery. And the best thing is: you can start it at any time - as flexible as you like and without a fixed date.
Price: € 39.00, VAT included
You can print out the pdf document with the city rally as often as you like. Duration: 2-2.5 hours
(The duration may vary depending on your individual pace)
Discover Bremen's Old town with our city rally! Bremen is full of stories, secrets and exciting places - and with our city rally you can experience all of this in a very special way! Whether with your school class or as a family with children, the city rally takes you on an adventurous journey of discovery through the historic city center. We impart knowledge in a playful way, and every step reveals new secrets that bring the charm and history of Bremen to life.
Price: € 39.00, VAT included
You can print out the pdf document with the city rally as often as you like. Duration: 1.5-2 hours
My name is Jasmin Nitzschner and I am a tourist guide with passion.
From the initial idea to work as a tourist guide on the side and occasionally do city tours through Bremen on weekends, it quickly became more. In the meantime it has become my main profession. Together with my little team, I will show you Bremen on foot, by bike, by coach and virtually.
And when do you come to Bremen? Feel free to call or write me and let us inspire you for the old Hanseatic city!
We are looking forward to meeting you!
Yours, Jasmin and the Stadtgeschichten Bremen team
Experience Bremen history, culture and culinary specialities
History
Bremen looks back on more than 1200 years of history. It was first mentioned in a document in 782 when Charlemagne founded a bishop's seat here. During our guided tours, you will learn many interesting things about the city's history.
Culture
Bremen also offers a lot of culture. During our guided tours, you will hear a lot of exciting and entertaining information about traditional customs and festivals in Bremen and about everyday life here.
Culinary specialties
Taste the traditional Bremen cuisine and try specialities from the old Hanseatic city. Whether sweet or hearty - there is guaranteed to be something for every taste.
