0003: SELECT DISTINCT "Fluent_Domain"."ClassName", "Fluent_Domain"."LastEdited", "Fluent_Domain"."Created", "Fluent_Domain"."Domain", "Fluent_Domain"."DefaultLocaleID", "Fluent_Domain"."ID",
CASE WHEN "Fluent_Domain"."ClassName" IS NOT NULL THEN "Fluent_Domain"."ClassName"
ELSE 'TractorCow\\Fluent\\Model\\Domain' END AS "RecordClassName"
FROM "Fluent_Domain"
0.0001s
0004: SELECT DISTINCT "Fluent_Locale"."ClassName", "Fluent_Locale"."LastEdited", "Fluent_Locale"."Created", "Fluent_Locale"."Title", "Fluent_Locale"."Locale", "Fluent_Locale"."URLSegment", "Fluent_Locale"."IsGlobalDefault", "Fluent_Locale"."UseDefaultCode", "Fluent_Locale"."Sort", "Fluent_Locale"."Timezone", "Fluent_Locale"."DomainID", "Fluent_Locale"."ID",
CASE WHEN "Fluent_Locale"."ClassName" IS NOT NULL THEN "Fluent_Locale"."ClassName"
ELSE 'TractorCow\\Fluent\\Model\\Locale' END AS "RecordClassName"
FROM "Fluent_Locale"
ORDER BY "Fluent_Locale"."Sort" ASC, "Fluent_Locale"."Locale" ASC
0.0001s
0005: SELECT DISTINCT "Fluent_FallbackLocale"."ClassName", "Fluent_FallbackLocale"."LastEdited", "Fluent_FallbackLocale"."Created", "Fluent_FallbackLocale"."Sort", "Fluent_FallbackLocale"."ParentID", "Fluent_FallbackLocale"."LocaleID", "Fluent_FallbackLocale"."ID",
CASE WHEN "Fluent_FallbackLocale"."ClassName" IS NOT NULL THEN "Fluent_FallbackLocale"."ClassName"
ELSE 'TractorCow\\Fluent\\Model\\FallbackLocale' END AS "RecordClassName"
FROM "Fluent_FallbackLocale"
WHERE ("Fluent_FallbackLocale"."ParentID" = ?)
ORDER BY "Fluent_FallbackLocale"."Sort" ASC
0.0003s
0006: 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.0004s
0007: 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" = ?)
AND (COALESCE("SiteTree_Localised_en_GB"."URLSegment", "SiteTree_Live"."URLSegment") = ?)
AND (("SiteTree_Localised_en_GB"."ID" IS NOT NULL))
ORDER BY "SiteTree_Live"."Sort" ASC
LIMIT 1
0.0004s
0008: 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.0004s
0009: SELECT DISTINCT "SiteConfig"."ClassName", "SiteConfig"."LastEdited", "SiteConfig"."Created", CASE
WHEN "SiteConfig_Localised_en_GB"."ID" IS NOT NULL THEN "SiteConfig_Localised_en_GB"."MapsBrowserKey"
ELSE "SiteConfig"."MapsBrowserKey" END
AS "MapsBrowserKey", CASE
WHEN "SiteConfig_Localised_en_GB"."ID" IS NOT NULL THEN "SiteConfig_Localised_en_GB"."MapsServerKey"
ELSE "SiteConfig"."MapsServerKey" END
AS "MapsServerKey", "SiteConfig"."UseDefaultCMSImage", CASE
WHEN "SiteConfig_Localised_en_GB"."ID" IS NOT NULL THEN "SiteConfig_Localised_en_GB"."LoginHeroHash"
ELSE "SiteConfig"."LoginHeroHash" END
AS "LoginHeroHash", CASE
WHEN "SiteConfig_Localised_en_GB"."ID" IS NOT NULL THEN "SiteConfig_Localised_en_GB"."DefaultImageAllowedTag"
ELSE "SiteConfig"."DefaultImageAllowedTag" END
AS "DefaultImageAllowedTag", CASE
WHEN "SiteConfig_Localised_en_GB"."ID" IS NOT NULL THEN "SiteConfig_Localised_en_GB"."DefaultImageDisallowedTag"
ELSE "SiteConfig"."DefaultImageDisallowedTag" END
AS "DefaultImageDisallowedTag", "SiteConfig"."UseOwnLoginText", CASE
WHEN "SiteConfig_Localised_en_GB"."ID" IS NOT NULL THEN "SiteConfig_Localised_en_GB"."DefaultLoginText"
ELSE "SiteConfig"."DefaultLoginText" END
AS "DefaultLoginText", CASE
WHEN "SiteConfig_Localised_en_GB"."ID" IS NOT NULL THEN "SiteConfig_Localised_en_GB"."CookieConsentNotice"
ELSE "SiteConfig"."CookieConsentNotice" END
AS "CookieConsentNotice", CASE
WHEN "SiteConfig_Localised_en_GB"."ID" IS NOT NULL THEN "SiteConfig_Localised_en_GB"."CookieBtnOk"
ELSE "SiteConfig"."CookieBtnOk" END
AS "CookieBtnOk", CASE
WHEN "SiteConfig_Localised_en_GB"."ID" IS NOT NULL THEN "SiteConfig_Localised_en_GB"."CookieChooseText"
ELSE "SiteConfig"."CookieChooseText" END
AS "CookieChooseText", CASE
WHEN "SiteConfig_Localised_en_GB"."ID" IS NOT NULL THEN "SiteConfig_Localised_en_GB"."CookieBtnDislike"
ELSE "SiteConfig"."CookieBtnDislike" END
AS "CookieBtnDislike", CASE
WHEN "SiteConfig_Localised_en_GB"."ID" IS NOT NULL THEN "SiteConfig_Localised_en_GB"."CookieAllowGMaps"
ELSE "SiteConfig"."CookieAllowGMaps" END
AS "CookieAllowGMaps", CASE
WHEN "SiteConfig_Localised_en_GB"."ID" IS NOT NULL THEN "SiteConfig_Localised_en_GB"."CookieTextUnderBtn"
ELSE "SiteConfig"."CookieTextUnderBtn" END
AS "CookieTextUnderBtn", CASE
WHEN "SiteConfig_Localised_en_GB"."ID" IS NOT NULL THEN "SiteConfig_Localised_en_GB"."CookieAllowYouTube"
ELSE "SiteConfig"."CookieAllowYouTube" END
AS "CookieAllowYouTube", CASE
WHEN "SiteConfig_Localised_en_GB"."ID" IS NOT NULL THEN "SiteConfig_Localised_en_GB"."CookieConsentPopUpHeadline"
ELSE "SiteConfig"."CookieConsentPopUpHeadline" END
AS "CookieConsentPopUpHeadline", CASE
WHEN "SiteConfig_Localised_en_GB"."ID" IS NOT NULL THEN "SiteConfig_Localised_en_GB"."CookieConsentPopUpNotice"
ELSE "SiteConfig"."CookieConsentPopUpNotice" END
AS "CookieConsentPopUpNotice", CASE
WHEN "SiteConfig_Localised_en_GB"."ID" IS NOT NULL THEN "SiteConfig_Localised_en_GB"."CookieConsentPopUpDisallow"
ELSE "SiteConfig"."CookieConsentPopUpDisallow" END
AS "CookieConsentPopUpDisallow", CASE
WHEN "SiteConfig_Localised_en_GB"."ID" IS NOT NULL THEN "SiteConfig_Localised_en_GB"."CookieConsentPopUpAllowAll"
ELSE "SiteConfig"."CookieConsentPopUpAllowAll" END
AS "CookieConsentPopUpAllowAll", CASE
WHEN "SiteConfig_Localised_en_GB"."ID" IS NOT NULL THEN "SiteConfig_Localised_en_GB"."CookieConsentPopUpAllowSelected"
ELSE "SiteConfig"."CookieConsentPopUpAllowSelected" END
AS "CookieConsentPopUpAllowSelected", CASE
WHEN "SiteConfig_Localised_en_GB"."ID" IS NOT NULL THEN "SiteConfig_Localised_en_GB"."CookiePrivacyPolicyTitle"
ELSE "SiteConfig"."CookiePrivacyPolicyTitle" END
AS "CookiePrivacyPolicyTitle", CASE
WHEN "SiteConfig_Localised_en_GB"."ID" IS NOT NULL THEN "SiteConfig_Localised_en_GB"."CookiePrivacyPolicyText"
ELSE "SiteConfig"."CookiePrivacyPolicyText" END
AS "CookiePrivacyPolicyText", CASE
WHEN "SiteConfig_Localised_en_GB"."ID" IS NOT NULL THEN "SiteConfig_Localised_en_GB"."PersonText"
ELSE "SiteConfig"."PersonText" END
AS "PersonText", CASE
WHEN "SiteConfig_Localised_en_GB"."ID" IS NOT NULL THEN "SiteConfig_Localised_en_GB"."IstGebucht"
ELSE "SiteConfig"."IstGebucht" END
AS "IstGebucht", CASE
WHEN "SiteConfig_Localised_en_GB"."ID" IS NOT NULL THEN "SiteConfig_Localised_en_GB"."JetztBuchen"
ELSE "SiteConfig"."JetztBuchen" END
AS "JetztBuchen", CASE
WHEN "SiteConfig_Localised_en_GB"."ID" IS NOT NULL THEN "SiteConfig_Localised_en_GB"."BookmarkQRCodeText"
ELSE "SiteConfig"."BookmarkQRCodeText" END
AS "BookmarkQRCodeText", CASE
WHEN "SiteConfig_Localised_en_GB"."ID" IS NOT NULL THEN "SiteConfig_Localised_en_GB"."BookmarkQRCodeBtnCopy"
ELSE "SiteConfig"."BookmarkQRCodeBtnCopy" END
AS "BookmarkQRCodeBtnCopy", CASE
WHEN "SiteConfig_Localised_en_GB"."ID" IS NOT NULL THEN "SiteConfig_Localised_en_GB"."BookmarkNichtEditmehr"
ELSE "SiteConfig"."BookmarkNichtEditmehr" END
AS "BookmarkNichtEditmehr", CASE
WHEN "SiteConfig_Localised_en_GB"."ID" IS NOT NULL THEN "SiteConfig_Localised_en_GB"."BookmarkSetNew"
ELSE "SiteConfig"."BookmarkSetNew" END
AS "BookmarkSetNew", CASE
WHEN "SiteConfig_Localised_en_GB"."ID" IS NOT NULL THEN "SiteConfig_Localised_en_GB"."Bookmarkduplicate"
ELSE "SiteConfig"."Bookmarkduplicate" END
AS "Bookmarkduplicate", 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"."MetaImageID", "SiteConfig"."LogoID", "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.0004s
0010: SELECT DISTINCT "SchemaCompany"."ClassName", "SchemaCompany"."LastEdited", "SchemaCompany"."Created", "SchemaCompany"."Title", "SchemaCompany"."SchemaType", "SchemaCompany"."Company", "SchemaCompany"."Name", "SchemaCompany"."Country", "SchemaCompany"."Street", "SchemaCompany"."HouseNmbr", "SchemaCompany"."Postal", "SchemaCompany"."Location", "SchemaCompany"."Telefon", "SchemaCompany"."LogoID", "SchemaCompany"."ID",
CASE WHEN "SchemaCompany"."ClassName" IS NOT NULL THEN "SchemaCompany"."ClassName"
ELSE 'App\\Models\\SchemaCompany' END AS "RecordClassName"
FROM "SchemaCompany"
LIMIT 1
0.0001s
0011: SELECT CASE WHEN EXISTS(SELECT *
FROM "LinkField_Link_Live"
WHERE ("LinkField_Link_Live"."OwnerClass" IN ('App\\Models\\SchemaCompany'))
AND ("LinkField_Link_Live"."OwnerRelation" = ?)
AND ("LinkField_Link_Live"."OwnerID" = ?)) THEN 1 ELSE 0 END
0.0002s
0012: SELECT CASE WHEN EXISTS(SELECT *
FROM "OpeningHour"
WHERE ("OpeningHour"."IsClosed" = ?)) THEN 1 ELSE 0 END
0.0002s
0013: SELECT CASE WHEN EXISTS(SELECT *
FROM "OpeningHourSpecial" ) THEN 1 ELSE 0 END
0.0001s
0014: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", CASE
WHEN "SiteTree_Localised_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_Localised_en_GB"."ID" IS NOT NULL))
ORDER BY "SiteTree_Live"."Sort" ASC
LIMIT 1
0.0003s
0015: SELECT DISTINCT "PersonEntry"."ClassName", "PersonEntry"."LastEdited", "PersonEntry"."Created", "PersonEntry"."SortOrder", CASE
WHEN "PersonEntry_Localised_en_GB"."ID" IS NOT NULL THEN "PersonEntry_Localised_en_GB"."Name"
ELSE "PersonEntry"."Name" END
AS "Name", CASE
WHEN "PersonEntry_Localised_en_GB"."ID" IS NOT NULL THEN "PersonEntry_Localised_en_GB"."Color"
ELSE "PersonEntry"."Color" END
AS "Color", "PersonEntry"."ImageID", "PersonEntry"."ID",
CASE WHEN "PersonEntry"."ClassName" IS NOT NULL THEN "PersonEntry"."ClassName"
ELSE 'App\\Models\\PersonEntry' END AS "RecordClassName", 'en_GB' AS "Locale", CASE WHEN "PersonEntry_Localised_en_GB"."ID" IS NOT NULL THEN 'en_GB'
ELSE NULL END AS "SourceLocale", (COALESCE("PersonEntry_Localised_en_GB"."Name", "PersonEntry"."Name")) AS "_SortColumn0"
FROM "PersonEntry" LEFT JOIN "PersonEntry_Localised" AS "PersonEntry_Localised_en_GB" ON "PersonEntry"."ID" = "PersonEntry_Localised_en_GB"."RecordID" AND "PersonEntry_Localised_en_GB"."Locale" = ?
WHERE (("PersonEntry_Localised_en_GB"."ID" IS NOT NULL))
ORDER BY "_SortColumn0" ASC
0.0003s
0016: SELECT DISTINCT "File_Live"."ClassName", "File_Live"."LastEdited", "File_Live"."Created", CASE WHEN "File_Live"."ClassName" IN ('SilverStripe\\Assets\\File', 'SilverStripe\\Assets\\Folder', 'SilverStripe\\Assets\\Image', 'WeDevelop\\SvgImage\\Assets\\Svg') THEN "File_Live"."Copyright" WHEN "File_Live"."ClassName" IN ('SilverStripe\\Assets\\Image', 'WeDevelop\\SvgImage\\Assets\\Svg') THEN "Image_Live"."Copyright" WHEN "File_Live"."ClassName" IN ('SilverStripe\\Assets\\Image', 'WeDevelop\\SvgImage\\Assets\\Svg') THEN "Image_Live"."Copyright" ELSE NULL END AS "Copyright", CASE WHEN "File_Live"."ClassName" IN ('SilverStripe\\Assets\\File', 'SilverStripe\\Assets\\Folder', 'SilverStripe\\Assets\\Image', 'WeDevelop\\SvgImage\\Assets\\Svg') THEN "File_Live"."Bildunterschrift" WHEN "File_Live"."ClassName" IN ('SilverStripe\\Assets\\Image', 'WeDevelop\\SvgImage\\Assets\\Svg') THEN "Image_Live"."Bildunterschrift" WHEN "File_Live"."ClassName" IN ('SilverStripe\\Assets\\Image', 'WeDevelop\\SvgImage\\Assets\\Svg') THEN "Image_Live"."Bildunterschrift" ELSE NULL END AS "Bildunterschrift", CASE WHEN "File_Live"."ClassName" IN ('SilverStripe\\Assets\\File', 'SilverStripe\\Assets\\Folder', 'SilverStripe\\Assets\\Image', 'WeDevelop\\SvgImage\\Assets\\Svg') THEN "File_Live"."AltText" WHEN "File_Live"."ClassName" IN ('SilverStripe\\Assets\\Image', 'WeDevelop\\SvgImage\\Assets\\Svg') THEN "Image_Live"."AltText" WHEN "File_Live"."ClassName" IN ('SilverStripe\\Assets\\Image', 'WeDevelop\\SvgImage\\Assets\\Svg') THEN "Image_Live"."AltText" ELSE NULL END AS "AltText", "File_Live"."Version", "File_Live"."CanViewType", "File_Live"."CanEditType", "File_Live"."Name", "File_Live"."Title", "File_Live"."ShowInSearch", "File_Live"."ParentID", "File_Live"."OwnerID", "File_Live"."FileHash", "File_Live"."FileFilename", "File_Live"."FileVariant", "Image_Live"."FocusPointX", "Image_Live"."FocusPointY", "Image_Live"."FocusPointWidth", "Image_Live"."FocusPointHeight", "File_Live"."ID",
CASE WHEN "File_Live"."ClassName" IS NOT NULL THEN "File_Live"."ClassName"
ELSE 'SilverStripe\\Assets\\File' END AS "RecordClassName"
FROM "File_Live" LEFT JOIN "Image_Live" ON "Image_Live"."ID" = "File_Live"."ID"
WHERE ("File_Live"."ID" = ?)
AND ("File_Live"."ClassName" IN (?, ?))
ORDER BY "File_Live"."Name" ASC
LIMIT 1
0.0003s
0017: SELECT DISTINCT "File_Live"."ClassName", "File_Live"."LastEdited", "File_Live"."Created", CASE WHEN "File_Live"."ClassName" IN ('SilverStripe\\Assets\\File', 'SilverStripe\\Assets\\Folder', 'SilverStripe\\Assets\\Image', 'WeDevelop\\SvgImage\\Assets\\Svg') THEN "File_Live"."Copyright" WHEN "File_Live"."ClassName" IN ('SilverStripe\\Assets\\Image', 'WeDevelop\\SvgImage\\Assets\\Svg') THEN "Image_Live"."Copyright" WHEN "File_Live"."ClassName" IN ('SilverStripe\\Assets\\Image', 'WeDevelop\\SvgImage\\Assets\\Svg') THEN "Image_Live"."Copyright" ELSE NULL END AS "Copyright", CASE WHEN "File_Live"."ClassName" IN ('SilverStripe\\Assets\\File', 'SilverStripe\\Assets\\Folder', 'SilverStripe\\Assets\\Image', 'WeDevelop\\SvgImage\\Assets\\Svg') THEN "File_Live"."Bildunterschrift" WHEN "File_Live"."ClassName" IN ('SilverStripe\\Assets\\Image', 'WeDevelop\\SvgImage\\Assets\\Svg') THEN "Image_Live"."Bildunterschrift" WHEN "File_Live"."ClassName" IN ('SilverStripe\\Assets\\Image', 'WeDevelop\\SvgImage\\Assets\\Svg') THEN "Image_Live"."Bildunterschrift" ELSE NULL END AS "Bildunterschrift", CASE WHEN "File_Live"."ClassName" IN ('SilverStripe\\Assets\\File', 'SilverStripe\\Assets\\Folder', 'SilverStripe\\Assets\\Image', 'WeDevelop\\SvgImage\\Assets\\Svg') THEN "File_Live"."AltText" WHEN "File_Live"."ClassName" IN ('SilverStripe\\Assets\\Image', 'WeDevelop\\SvgImage\\Assets\\Svg') THEN "Image_Live"."AltText" WHEN "File_Live"."ClassName" IN ('SilverStripe\\Assets\\Image', 'WeDevelop\\SvgImage\\Assets\\Svg') THEN "Image_Live"."AltText" ELSE NULL END AS "AltText", "File_Live"."Version", "File_Live"."CanViewType", "File_Live"."CanEditType", "File_Live"."Name", "File_Live"."Title", "File_Live"."ShowInSearch", "File_Live"."ParentID", "File_Live"."OwnerID", "File_Live"."FileHash", "File_Live"."FileFilename", "File_Live"."FileVariant", "Image_Live"."FocusPointX", "Image_Live"."FocusPointY", "Image_Live"."FocusPointWidth", "Image_Live"."FocusPointHeight", "File_Live"."ID",
CASE WHEN "File_Live"."ClassName" IS NOT NULL THEN "File_Live"."ClassName"
ELSE 'SilverStripe\\Assets\\File' END AS "RecordClassName"
FROM "File_Live" LEFT JOIN "Image_Live" ON "Image_Live"."ID" = "File_Live"."ID"
WHERE ("File_Live"."ID" = ?)
AND ("File_Live"."ClassName" IN (?, ?))
ORDER BY "File_Live"."Name" ASC
LIMIT 1
0.0003s
0018: SELECT DISTINCT "File_Live"."ClassName", "File_Live"."LastEdited", "File_Live"."Created", CASE WHEN "File_Live"."ClassName" IN ('SilverStripe\\Assets\\File', 'SilverStripe\\Assets\\Folder', 'SilverStripe\\Assets\\Image', 'WeDevelop\\SvgImage\\Assets\\Svg') THEN "File_Live"."Copyright" WHEN "File_Live"."ClassName" IN ('SilverStripe\\Assets\\Image', 'WeDevelop\\SvgImage\\Assets\\Svg') THEN "Image_Live"."Copyright" WHEN "File_Live"."ClassName" IN ('SilverStripe\\Assets\\Image', 'WeDevelop\\SvgImage\\Assets\\Svg') THEN "Image_Live"."Copyright" ELSE NULL END AS "Copyright", CASE WHEN "File_Live"."ClassName" IN ('SilverStripe\\Assets\\File', 'SilverStripe\\Assets\\Folder', 'SilverStripe\\Assets\\Image', 'WeDevelop\\SvgImage\\Assets\\Svg') THEN "File_Live"."Bildunterschrift" WHEN "File_Live"."ClassName" IN ('SilverStripe\\Assets\\Image', 'WeDevelop\\SvgImage\\Assets\\Svg') THEN "Image_Live"."Bildunterschrift" WHEN "File_Live"."ClassName" IN ('SilverStripe\\Assets\\Image', 'WeDevelop\\SvgImage\\Assets\\Svg') THEN "Image_Live"."Bildunterschrift" ELSE NULL END AS "Bildunterschrift", CASE WHEN "File_Live"."ClassName" IN ('SilverStripe\\Assets\\File', 'SilverStripe\\Assets\\Folder', 'SilverStripe\\Assets\\Image', 'WeDevelop\\SvgImage\\Assets\\Svg') THEN "File_Live"."AltText" WHEN "File_Live"."ClassName" IN ('SilverStripe\\Assets\\Image', 'WeDevelop\\SvgImage\\Assets\\Svg') THEN "Image_Live"."AltText" WHEN "File_Live"."ClassName" IN ('SilverStripe\\Assets\\Image', 'WeDevelop\\SvgImage\\Assets\\Svg') THEN "Image_Live"."AltText" ELSE NULL END AS "AltText", "File_Live"."Version", "File_Live"."CanViewType", "File_Live"."CanEditType", "File_Live"."Name", "File_Live"."Title", "File_Live"."ShowInSearch", "File_Live"."ParentID", "File_Live"."OwnerID", "File_Live"."FileHash", "File_Live"."FileFilename", "File_Live"."FileVariant", "Image_Live"."FocusPointX", "Image_Live"."FocusPointY", "Image_Live"."FocusPointWidth", "Image_Live"."FocusPointHeight", "File_Live"."ID",
CASE WHEN "File_Live"."ClassName" IS NOT NULL THEN "File_Live"."ClassName"
ELSE 'SilverStripe\\Assets\\File' END AS "RecordClassName"
FROM "File_Live" LEFT JOIN "Image_Live" ON "Image_Live"."ID" = "File_Live"."ID"
WHERE ("File_Live"."ID" = ?)
AND ("File_Live"."ClassName" IN (?, ?))
ORDER BY "File_Live"."Name" ASC
LIMIT 1
0.0003s
0019: SELECT DISTINCT "File_Live"."ClassName", "File_Live"."LastEdited", "File_Live"."Created", CASE WHEN "File_Live"."ClassName" IN ('SilverStripe\\Assets\\File', 'SilverStripe\\Assets\\Folder', 'SilverStripe\\Assets\\Image', 'WeDevelop\\SvgImage\\Assets\\Svg') THEN "File_Live"."Copyright" WHEN "File_Live"."ClassName" IN ('SilverStripe\\Assets\\Image', 'WeDevelop\\SvgImage\\Assets\\Svg') THEN "Image_Live"."Copyright" WHEN "File_Live"."ClassName" IN ('SilverStripe\\Assets\\Image', 'WeDevelop\\SvgImage\\Assets\\Svg') THEN "Image_Live"."Copyright" ELSE NULL END AS "Copyright", CASE WHEN "File_Live"."ClassName" IN ('SilverStripe\\Assets\\File', 'SilverStripe\\Assets\\Folder', 'SilverStripe\\Assets\\Image', 'WeDevelop\\SvgImage\\Assets\\Svg') THEN "File_Live"."Bildunterschrift" WHEN "File_Live"."ClassName" IN ('SilverStripe\\Assets\\Image', 'WeDevelop\\SvgImage\\Assets\\Svg') THEN "Image_Live"."Bildunterschrift" WHEN "File_Live"."ClassName" IN ('SilverStripe\\Assets\\Image', 'WeDevelop\\SvgImage\\Assets\\Svg') THEN "Image_Live"."Bildunterschrift" ELSE NULL END AS "Bildunterschrift", CASE WHEN "File_Live"."ClassName" IN ('SilverStripe\\Assets\\File', 'SilverStripe\\Assets\\Folder', 'SilverStripe\\Assets\\Image', 'WeDevelop\\SvgImage\\Assets\\Svg') THEN "File_Live"."AltText" WHEN "File_Live"."ClassName" IN ('SilverStripe\\Assets\\Image', 'WeDevelop\\SvgImage\\Assets\\Svg') THEN "Image_Live"."AltText" WHEN "File_Live"."ClassName" IN ('SilverStripe\\Assets\\Image', 'WeDevelop\\SvgImage\\Assets\\Svg') THEN "Image_Live"."AltText" ELSE NULL END AS "AltText", "File_Live"."Version", "File_Live"."CanViewType", "File_Live"."CanEditType", "File_Live"."Name", "File_Live"."Title", "File_Live"."ShowInSearch", "File_Live"."ParentID", "File_Live"."OwnerID", "File_Live"."FileHash", "File_Live"."FileFilename", "File_Live"."FileVariant", "Image_Live"."FocusPointX", "Image_Live"."FocusPointY", "Image_Live"."FocusPointWidth", "Image_Live"."FocusPointHeight", "File_Live"."ID",
CASE WHEN "File_Live"."ClassName" IS NOT NULL THEN "File_Live"."ClassName"
ELSE 'SilverStripe\\Assets\\File' END AS "RecordClassName"
FROM "File_Live" LEFT JOIN "Image_Live" ON "Image_Live"."ID" = "File_Live"."ID"
WHERE ("File_Live"."ID" = ?)
AND ("File_Live"."ClassName" IN (?, ?))
ORDER BY "File_Live"."Name" ASC
LIMIT 1
0.0003s
0020: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", CASE
WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."BetterSiteTitle"
ELSE "SiteTree_Live"."BetterSiteTitle" END
AS "BetterSiteTitle", CASE
WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."Keyword"
ELSE "SiteTree_Live"."Keyword" END
AS "Keyword", CASE
WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."FeaturedKeyword"
ELSE "SiteTree_Live"."FeaturedKeyword" END
AS "FeaturedKeyword", CASE
WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."KeywordQuestion"
ELSE "SiteTree_Live"."KeywordQuestion" END
AS "KeywordQuestion", "SiteTree_Live"."Follow", "SiteTree_Live"."FollowType", CASE
WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."GenMetaDesc"
ELSE "SiteTree_Live"."GenMetaDesc" END
AS "GenMetaDesc", CASE
WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."FBTitle"
ELSE "SiteTree_Live"."FBTitle" END
AS "FBTitle", CASE
WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."FBDescription"
ELSE "SiteTree_Live"."FBDescription" END
AS "FBDescription", "SiteTree_Live"."FBType", "SiteTree_Live"."FBTypeOverride", CASE
WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."TwTitle"
ELSE "SiteTree_Live"."TwTitle" END
AS "TwTitle", CASE
WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."TwDescription"
ELSE "SiteTree_Live"."TwDescription" END
AS "TwDescription", "SiteTree_Live"."CanViewType", "SiteTree_Live"."CanEditType", "SiteTree_Live"."Version", CASE
WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."URLSegment"
ELSE "SiteTree_Live"."URLSegment" END
AS "URLSegment", CASE
WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."Title"
ELSE "SiteTree_Live"."Title" END
AS "Title", CASE
WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."MenuTitle"
ELSE "SiteTree_Live"."MenuTitle" END
AS "MenuTitle", CASE
WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."Content"
ELSE "SiteTree_Live"."Content" END
AS "Content", CASE
WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."MetaDescription"
ELSE "SiteTree_Live"."MetaDescription" END
AS "MetaDescription", "SiteTree_Live"."ExtraMeta", "SiteTree_Live"."ShowInMenus", "SiteTree_Live"."ShowInSearch", "SiteTree_Live"."Sort", "SiteTree_Live"."HasBrokenFile", "SiteTree_Live"."HasBrokenLink", CASE
WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."ReportClass"
ELSE "SiteTree_Live"."ReportClass" END
AS "ReportClass", "SiteTree_Live"."CanonicalLinkID", "SiteTree_Live"."FBImageID", "SiteTree_Live"."TwImageID", "SiteTree_Live"."ParentID", CASE
WHEN "Page_Localised_en_GB"."ID" IS NOT NULL THEN "Page_Localised_en_GB"."ChapterTitle"
ELSE "Page_Live"."ChapterTitle" END
AS "ChapterTitle", CASE
WHEN "Page_Localised_en_GB"."ID" IS NOT NULL THEN "Page_Localised_en_GB"."BetterTitle"
ELSE "Page_Live"."BetterTitle" END
AS "BetterTitle", CASE
WHEN "Page_Localised_en_GB"."ID" IS NOT NULL THEN "Page_Localised_en_GB"."TeaserText"
ELSE "Page_Live"."TeaserText" END
AS "TeaserText", "Page_Live"."NoTeaser", "Page_Live"."NoBookmark", "Page_Live"."ImageID", "SiteTree_Live"."ID",
CASE WHEN "SiteTree_Live"."ClassName" IS NOT NULL THEN "SiteTree_Live"."ClassName"
ELSE 'SilverStripe\\CMS\\Model\\SiteTree' END AS "RecordClassName", 'en_GB' AS "Locale", CASE WHEN "Page_Localised_en_GB"."ID" IS NOT NULL THEN 'en_GB'
ELSE NULL END AS "SourceLocale"
FROM "SiteTree_Live" LEFT JOIN "Page_Live" ON "Page_Live"."ID" = "SiteTree_Live"."ID" LEFT JOIN "SiteTree_Localised_Live" AS "SiteTree_Localised_en_GB" ON "SiteTree_Live"."ID" = "SiteTree_Localised_en_GB"."RecordID" AND "SiteTree_Localised_en_GB"."Locale" = ? LEFT JOIN "Page_Localised_Live" AS "Page_Localised_en_GB" ON "Page_Live"."ID" = "Page_Localised_en_GB"."RecordID" AND "Page_Localised_en_GB"."Locale" = ?
WHERE ("SiteTree_Live"."ClassName" IN (?))
AND (("SiteTree_Localised_en_GB"."ID" IS NOT NULL))
ORDER BY "SiteTree_Live"."Sort" ASC
LIMIT 1
0.0004s
0021: SELECT DISTINCT "Fluent_FallbackLocale"."ClassName", "Fluent_FallbackLocale"."LastEdited", "Fluent_FallbackLocale"."Created", "Fluent_FallbackLocale"."Sort", "Fluent_FallbackLocale"."ParentID", "Fluent_FallbackLocale"."LocaleID", "Fluent_FallbackLocale"."ID",
CASE WHEN "Fluent_FallbackLocale"."ClassName" IS NOT NULL THEN "Fluent_FallbackLocale"."ClassName"
ELSE 'TractorCow\\Fluent\\Model\\FallbackLocale' END AS "RecordClassName"
FROM "Fluent_FallbackLocale"
WHERE ("Fluent_FallbackLocale"."ParentID" = ?)
ORDER BY "Fluent_FallbackLocale"."Sort" ASC
0.0002s
0022: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."BetterSiteTitle"
ELSE "SiteTree_Live"."BetterSiteTitle" END
AS "BetterSiteTitle", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."Keyword"
ELSE "SiteTree_Live"."Keyword" END
AS "Keyword", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."FeaturedKeyword"
ELSE "SiteTree_Live"."FeaturedKeyword" END
AS "FeaturedKeyword", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."KeywordQuestion"
ELSE "SiteTree_Live"."KeywordQuestion" END
AS "KeywordQuestion", "SiteTree_Live"."Follow", "SiteTree_Live"."FollowType", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."GenMetaDesc"
ELSE "SiteTree_Live"."GenMetaDesc" END
AS "GenMetaDesc", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."FBTitle"
ELSE "SiteTree_Live"."FBTitle" END
AS "FBTitle", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."FBDescription"
ELSE "SiteTree_Live"."FBDescription" END
AS "FBDescription", "SiteTree_Live"."FBType", "SiteTree_Live"."FBTypeOverride", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."TwTitle"
ELSE "SiteTree_Live"."TwTitle" END
AS "TwTitle", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."TwDescription"
ELSE "SiteTree_Live"."TwDescription" END
AS "TwDescription", "SiteTree_Live"."CanViewType", "SiteTree_Live"."CanEditType", "SiteTree_Live"."Version", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."URLSegment"
ELSE "SiteTree_Live"."URLSegment" END
AS "URLSegment", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."Title"
ELSE "SiteTree_Live"."Title" END
AS "Title", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."MenuTitle"
ELSE "SiteTree_Live"."MenuTitle" END
AS "MenuTitle", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."Content"
ELSE "SiteTree_Live"."Content" END
AS "Content", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."MetaDescription"
ELSE "SiteTree_Live"."MetaDescription" END
AS "MetaDescription", "SiteTree_Live"."ExtraMeta", "SiteTree_Live"."ShowInMenus", "SiteTree_Live"."ShowInSearch", "SiteTree_Live"."Sort", "SiteTree_Live"."HasBrokenFile", "SiteTree_Live"."HasBrokenLink", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."ReportClass"
ELSE "SiteTree_Live"."ReportClass" END
AS "ReportClass", "SiteTree_Live"."CanonicalLinkID", "SiteTree_Live"."FBImageID", "SiteTree_Live"."TwImageID", "SiteTree_Live"."ParentID", CASE
WHEN "Page_Localised_de_DE"."ID" IS NOT NULL THEN "Page_Localised_de_DE"."ChapterTitle"
ELSE "Page_Live"."ChapterTitle" END
AS "ChapterTitle", CASE
WHEN "Page_Localised_de_DE"."ID" IS NOT NULL THEN "Page_Localised_de_DE"."BetterTitle"
ELSE "Page_Live"."BetterTitle" END
AS "BetterTitle", CASE
WHEN "Page_Localised_de_DE"."ID" IS NOT NULL THEN "Page_Localised_de_DE"."TeaserText"
ELSE "Page_Live"."TeaserText" END
AS "TeaserText", "Page_Live"."NoTeaser", "Page_Live"."NoBookmark", "Page_Live"."ImageID", "BlockPage_Live"."ElementalAreaID", "SiteTree_Live"."ID",
CASE WHEN "SiteTree_Live"."ClassName" IS NOT NULL THEN "SiteTree_Live"."ClassName"
ELSE 'SilverStripe\\CMS\\Model\\SiteTree' END AS "RecordClassName", 'de_DE' AS "Locale", CASE WHEN "Page_Localised_de_DE"."ID" IS NOT NULL THEN 'de_DE'
ELSE NULL END AS "SourceLocale"
FROM "SiteTree_Live" LEFT JOIN "Page_Live" ON "Page_Live"."ID" = "SiteTree_Live"."ID" LEFT JOIN "BlockPage_Live" ON "BlockPage_Live"."ID" = "SiteTree_Live"."ID" LEFT JOIN "SiteTree_Localised_Live" AS "SiteTree_Localised_de_DE" ON "SiteTree_Live"."ID" = "SiteTree_Localised_de_DE"."RecordID" AND "SiteTree_Localised_de_DE"."Locale" = ? LEFT JOIN "Page_Localised_Live" AS "Page_Localised_de_DE" ON "Page_Live"."ID" = "Page_Localised_de_DE"."RecordID" AND "Page_Localised_de_DE"."Locale" = ?
WHERE ("SiteTree_Live"."ID" = ?)
AND ("SiteTree_Live"."ClassName" IN (?))
AND (("SiteTree_Localised_de_DE"."ID" IS NOT NULL))
ORDER BY "SiteTree_Live"."Sort" ASC
LIMIT 1
0.0004s
0023: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."BetterSiteTitle"
ELSE "SiteTree_Live"."BetterSiteTitle" END
AS "BetterSiteTitle", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."Keyword"
ELSE "SiteTree_Live"."Keyword" END
AS "Keyword", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."FeaturedKeyword"
ELSE "SiteTree_Live"."FeaturedKeyword" END
AS "FeaturedKeyword", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."KeywordQuestion"
ELSE "SiteTree_Live"."KeywordQuestion" END
AS "KeywordQuestion", "SiteTree_Live"."Follow", "SiteTree_Live"."FollowType", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."GenMetaDesc"
ELSE "SiteTree_Live"."GenMetaDesc" END
AS "GenMetaDesc", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."FBTitle"
ELSE "SiteTree_Live"."FBTitle" END
AS "FBTitle", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."FBDescription"
ELSE "SiteTree_Live"."FBDescription" END
AS "FBDescription", "SiteTree_Live"."FBType", "SiteTree_Live"."FBTypeOverride", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."TwTitle"
ELSE "SiteTree_Live"."TwTitle" END
AS "TwTitle", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."TwDescription"
ELSE "SiteTree_Live"."TwDescription" END
AS "TwDescription", "SiteTree_Live"."CanViewType", "SiteTree_Live"."CanEditType", "SiteTree_Live"."Version", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."URLSegment"
ELSE "SiteTree_Live"."URLSegment" END
AS "URLSegment", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."Title"
ELSE "SiteTree_Live"."Title" END
AS "Title", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."MenuTitle"
ELSE "SiteTree_Live"."MenuTitle" END
AS "MenuTitle", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."Content"
ELSE "SiteTree_Live"."Content" END
AS "Content", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."MetaDescription"
ELSE "SiteTree_Live"."MetaDescription" END
AS "MetaDescription", "SiteTree_Live"."ExtraMeta", "SiteTree_Live"."ShowInMenus", "SiteTree_Live"."ShowInSearch", "SiteTree_Live"."Sort", "SiteTree_Live"."HasBrokenFile", "SiteTree_Live"."HasBrokenLink", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."ReportClass"
ELSE "SiteTree_Live"."ReportClass" END
AS "ReportClass", "SiteTree_Live"."CanonicalLinkID", "SiteTree_Live"."FBImageID", "SiteTree_Live"."TwImageID", "SiteTree_Live"."ParentID", "SiteTree_Live"."ID",
CASE WHEN "SiteTree_Live"."ClassName" IS NOT NULL THEN "SiteTree_Live"."ClassName"
ELSE 'SilverStripe\\CMS\\Model\\SiteTree' END AS "RecordClassName", 'de_DE' AS "Locale", CASE WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN 'de_DE'
ELSE NULL END AS "SourceLocale"
FROM "SiteTree_Live" LEFT JOIN "SiteTree_Localised_Live" AS "SiteTree_Localised_de_DE" ON "SiteTree_Live"."ID" = "SiteTree_Localised_de_DE"."RecordID" AND "SiteTree_Localised_de_DE"."Locale" = ?
WHERE ("SiteTree_Live"."ID" = ?)
AND (("SiteTree_Localised_de_DE"."ID" IS NOT NULL))
ORDER BY "SiteTree_Live"."Sort" ASC
LIMIT 1
0.0003s
0024: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", CASE
WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."BetterSiteTitle"
ELSE "SiteTree_Live"."BetterSiteTitle" END
AS "BetterSiteTitle", CASE
WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."Keyword"
ELSE "SiteTree_Live"."Keyword" END
AS "Keyword", CASE
WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."FeaturedKeyword"
ELSE "SiteTree_Live"."FeaturedKeyword" END
AS "FeaturedKeyword", CASE
WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."KeywordQuestion"
ELSE "SiteTree_Live"."KeywordQuestion" END
AS "KeywordQuestion", "SiteTree_Live"."Follow", "SiteTree_Live"."FollowType", CASE
WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."GenMetaDesc"
ELSE "SiteTree_Live"."GenMetaDesc" END
AS "GenMetaDesc", CASE
WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."FBTitle"
ELSE "SiteTree_Live"."FBTitle" END
AS "FBTitle", CASE
WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."FBDescription"
ELSE "SiteTree_Live"."FBDescription" END
AS "FBDescription", "SiteTree_Live"."FBType", "SiteTree_Live"."FBTypeOverride", CASE
WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."TwTitle"
ELSE "SiteTree_Live"."TwTitle" END
AS "TwTitle", CASE
WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."TwDescription"
ELSE "SiteTree_Live"."TwDescription" END
AS "TwDescription", "SiteTree_Live"."CanViewType", "SiteTree_Live"."CanEditType", "SiteTree_Live"."Version", CASE
WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."URLSegment"
ELSE "SiteTree_Live"."URLSegment" END
AS "URLSegment", CASE
WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."Title"
ELSE "SiteTree_Live"."Title" END
AS "Title", CASE
WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."MenuTitle"
ELSE "SiteTree_Live"."MenuTitle" END
AS "MenuTitle", CASE
WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."Content"
ELSE "SiteTree_Live"."Content" END
AS "Content", CASE
WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."MetaDescription"
ELSE "SiteTree_Live"."MetaDescription" END
AS "MetaDescription", "SiteTree_Live"."ExtraMeta", "SiteTree_Live"."ShowInMenus", "SiteTree_Live"."ShowInSearch", "SiteTree_Live"."Sort", "SiteTree_Live"."HasBrokenFile", "SiteTree_Live"."HasBrokenLink", CASE
WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."ReportClass"
ELSE "SiteTree_Live"."ReportClass" END
AS "ReportClass", "SiteTree_Live"."CanonicalLinkID", "SiteTree_Live"."FBImageID", "SiteTree_Live"."TwImageID", "SiteTree_Live"."ParentID", CASE
WHEN "Page_Localised_en_GB"."ID" IS NOT NULL THEN "Page_Localised_en_GB"."ChapterTitle"
ELSE "Page_Live"."ChapterTitle" END
AS "ChapterTitle", CASE
WHEN "Page_Localised_en_GB"."ID" IS NOT NULL THEN "Page_Localised_en_GB"."BetterTitle"
ELSE "Page_Live"."BetterTitle" END
AS "BetterTitle", CASE
WHEN "Page_Localised_en_GB"."ID" IS NOT NULL THEN "Page_Localised_en_GB"."TeaserText"
ELSE "Page_Live"."TeaserText" END
AS "TeaserText", "Page_Live"."NoTeaser", "Page_Live"."NoBookmark", "Page_Live"."ImageID", "BlockPage_Live"."ElementalAreaID", "SiteTree_Live"."ID",
CASE WHEN "SiteTree_Live"."ClassName" IS NOT NULL THEN "SiteTree_Live"."ClassName"
ELSE 'SilverStripe\\CMS\\Model\\SiteTree' END AS "RecordClassName", 'en_GB' AS "Locale", CASE WHEN "Page_Localised_en_GB"."ID" IS NOT NULL THEN 'en_GB'
ELSE NULL END AS "SourceLocale"
FROM "SiteTree_Live" LEFT JOIN "Page_Live" ON "Page_Live"."ID" = "SiteTree_Live"."ID" LEFT JOIN "BlockPage_Live" ON "BlockPage_Live"."ID" = "SiteTree_Live"."ID" LEFT JOIN "SiteTree_Localised_Live" AS "SiteTree_Localised_en_GB" ON "SiteTree_Live"."ID" = "SiteTree_Localised_en_GB"."RecordID" AND "SiteTree_Localised_en_GB"."Locale" = ? LEFT JOIN "Page_Localised_Live" AS "Page_Localised_en_GB" ON "Page_Live"."ID" = "Page_Localised_en_GB"."RecordID" AND "Page_Localised_en_GB"."Locale" = ?
WHERE ("SiteTree_Live"."ID" = ?)
AND ("SiteTree_Live"."ClassName" IN (?))
AND (("SiteTree_Localised_en_GB"."ID" IS NOT NULL))
ORDER BY "SiteTree_Live"."Sort" ASC
LIMIT 1
0.0004s
0025: 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.0003s
0026: SELECT DISTINCT "Fluent_FallbackLocale"."ClassName", "Fluent_FallbackLocale"."LastEdited", "Fluent_FallbackLocale"."Created", "Fluent_FallbackLocale"."Sort", "Fluent_FallbackLocale"."ParentID", "Fluent_FallbackLocale"."LocaleID", "Fluent_FallbackLocale"."ID",
CASE WHEN "Fluent_FallbackLocale"."ClassName" IS NOT NULL THEN "Fluent_FallbackLocale"."ClassName"
ELSE 'TractorCow\\Fluent\\Model\\FallbackLocale' END AS "RecordClassName"
FROM "Fluent_FallbackLocale"
WHERE ("Fluent_FallbackLocale"."ParentID" = ?)
ORDER BY "Fluent_FallbackLocale"."Sort" ASC
0.0003s
0027: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", CASE
WHEN "SiteTree_Localised_he_IL"."ID" IS NOT NULL THEN "SiteTree_Localised_he_IL"."BetterSiteTitle"
ELSE "SiteTree_Live"."BetterSiteTitle" END
AS "BetterSiteTitle", CASE
WHEN "SiteTree_Localised_he_IL"."ID" IS NOT NULL THEN "SiteTree_Localised_he_IL"."Keyword"
ELSE "SiteTree_Live"."Keyword" END
AS "Keyword", CASE
WHEN "SiteTree_Localised_he_IL"."ID" IS NOT NULL THEN "SiteTree_Localised_he_IL"."FeaturedKeyword"
ELSE "SiteTree_Live"."FeaturedKeyword" END
AS "FeaturedKeyword", CASE
WHEN "SiteTree_Localised_he_IL"."ID" IS NOT NULL THEN "SiteTree_Localised_he_IL"."KeywordQuestion"
ELSE "SiteTree_Live"."KeywordQuestion" END
AS "KeywordQuestion", "SiteTree_Live"."Follow", "SiteTree_Live"."FollowType", CASE
WHEN "SiteTree_Localised_he_IL"."ID" IS NOT NULL THEN "SiteTree_Localised_he_IL"."GenMetaDesc"
ELSE "SiteTree_Live"."GenMetaDesc" END
AS "GenMetaDesc", CASE
WHEN "SiteTree_Localised_he_IL"."ID" IS NOT NULL THEN "SiteTree_Localised_he_IL"."FBTitle"
ELSE "SiteTree_Live"."FBTitle" END
AS "FBTitle", CASE
WHEN "SiteTree_Localised_he_IL"."ID" IS NOT NULL THEN "SiteTree_Localised_he_IL"."FBDescription"
ELSE "SiteTree_Live"."FBDescription" END
AS "FBDescription", "SiteTree_Live"."FBType", "SiteTree_Live"."FBTypeOverride", CASE
WHEN "SiteTree_Localised_he_IL"."ID" IS NOT NULL THEN "SiteTree_Localised_he_IL"."TwTitle"
ELSE "SiteTree_Live"."TwTitle" END
AS "TwTitle", CASE
WHEN "SiteTree_Localised_he_IL"."ID" IS NOT NULL THEN "SiteTree_Localised_he_IL"."TwDescription"
ELSE "SiteTree_Live"."TwDescription" END
AS "TwDescription", "SiteTree_Live"."CanViewType", "SiteTree_Live"."CanEditType", "SiteTree_Live"."Version", CASE
WHEN "SiteTree_Localised_he_IL"."ID" IS NOT NULL THEN "SiteTree_Localised_he_IL"."URLSegment"
ELSE "SiteTree_Live"."URLSegment" END
AS "URLSegment", CASE
WHEN "SiteTree_Localised_he_IL"."ID" IS NOT NULL THEN "SiteTree_Localised_he_IL"."Title"
ELSE "SiteTree_Live"."Title" END
AS "Title", CASE
WHEN "SiteTree_Localised_he_IL"."ID" IS NOT NULL THEN "SiteTree_Localised_he_IL"."MenuTitle"
ELSE "SiteTree_Live"."MenuTitle" END
AS "MenuTitle", CASE
WHEN "SiteTree_Localised_he_IL"."ID" IS NOT NULL THEN "SiteTree_Localised_he_IL"."Content"
ELSE "SiteTree_Live"."Content" END
AS "Content", CASE
WHEN "SiteTree_Localised_he_IL"."ID" IS NOT NULL THEN "SiteTree_Localised_he_IL"."MetaDescription"
ELSE "SiteTree_Live"."MetaDescription" END
AS "MetaDescription", "SiteTree_Live"."ExtraMeta", "SiteTree_Live"."ShowInMenus", "SiteTree_Live"."ShowInSearch", "SiteTree_Live"."Sort", "SiteTree_Live"."HasBrokenFile", "SiteTree_Live"."HasBrokenLink", CASE
WHEN "SiteTree_Localised_he_IL"."ID" IS NOT NULL THEN "SiteTree_Localised_he_IL"."ReportClass"
ELSE "SiteTree_Live"."ReportClass" END
AS "ReportClass", "SiteTree_Live"."CanonicalLinkID", "SiteTree_Live"."FBImageID", "SiteTree_Live"."TwImageID", "SiteTree_Live"."ParentID", CASE
WHEN "Page_Localised_he_IL"."ID" IS NOT NULL THEN "Page_Localised_he_IL"."ChapterTitle"
ELSE "Page_Live"."ChapterTitle" END
AS "ChapterTitle", CASE
WHEN "Page_Localised_he_IL"."ID" IS NOT NULL THEN "Page_Localised_he_IL"."BetterTitle"
ELSE "Page_Live"."BetterTitle" END
AS "BetterTitle", CASE
WHEN "Page_Localised_he_IL"."ID" IS NOT NULL THEN "Page_Localised_he_IL"."TeaserText"
ELSE "Page_Live"."TeaserText" END
AS "TeaserText", "Page_Live"."NoTeaser", "Page_Live"."NoBookmark", "Page_Live"."ImageID", "BlockPage_Live"."ElementalAreaID", "SiteTree_Live"."ID",
CASE WHEN "SiteTree_Live"."ClassName" IS NOT NULL THEN "SiteTree_Live"."ClassName"
ELSE 'SilverStripe\\CMS\\Model\\SiteTree' END AS "RecordClassName", 'he_IL' AS "Locale", CASE WHEN "Page_Localised_he_IL"."ID" IS NOT NULL THEN 'he_IL'
ELSE NULL END AS "SourceLocale"
FROM "SiteTree_Live" LEFT JOIN "Page_Live" ON "Page_Live"."ID" = "SiteTree_Live"."ID" LEFT JOIN "BlockPage_Live" ON "BlockPage_Live"."ID" = "SiteTree_Live"."ID" LEFT JOIN "SiteTree_Localised_Live" AS "SiteTree_Localised_he_IL" ON "SiteTree_Live"."ID" = "SiteTree_Localised_he_IL"."RecordID" AND "SiteTree_Localised_he_IL"."Locale" = ? LEFT JOIN "Page_Localised_Live" AS "Page_Localised_he_IL" ON "Page_Live"."ID" = "Page_Localised_he_IL"."RecordID" AND "Page_Localised_he_IL"."Locale" = ?
WHERE ("SiteTree_Live"."ID" = ?)
AND ("SiteTree_Live"."ClassName" IN (?))
AND (("SiteTree_Localised_he_IL"."ID" IS NOT NULL))
ORDER BY "SiteTree_Live"."Sort" ASC
LIMIT 1
0.0005s
0028: SELECT DISTINCT "Fluent_FallbackLocale"."ClassName", "Fluent_FallbackLocale"."LastEdited", "Fluent_FallbackLocale"."Created", "Fluent_FallbackLocale"."Sort", "Fluent_FallbackLocale"."ParentID", "Fluent_FallbackLocale"."LocaleID", "Fluent_FallbackLocale"."ID",
CASE WHEN "Fluent_FallbackLocale"."ClassName" IS NOT NULL THEN "Fluent_FallbackLocale"."ClassName"
ELSE 'TractorCow\\Fluent\\Model\\FallbackLocale' END AS "RecordClassName"
FROM "Fluent_FallbackLocale"
WHERE ("Fluent_FallbackLocale"."ParentID" = ?)
ORDER BY "Fluent_FallbackLocale"."Sort" ASC
0.0002s
0029: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", CASE
WHEN "SiteTree_Localised_nl_NL"."ID" IS NOT NULL THEN "SiteTree_Localised_nl_NL"."BetterSiteTitle"
ELSE "SiteTree_Live"."BetterSiteTitle" END
AS "BetterSiteTitle", CASE
WHEN "SiteTree_Localised_nl_NL"."ID" IS NOT NULL THEN "SiteTree_Localised_nl_NL"."Keyword"
ELSE "SiteTree_Live"."Keyword" END
AS "Keyword", CASE
WHEN "SiteTree_Localised_nl_NL"."ID" IS NOT NULL THEN "SiteTree_Localised_nl_NL"."FeaturedKeyword"
ELSE "SiteTree_Live"."FeaturedKeyword" END
AS "FeaturedKeyword", CASE
WHEN "SiteTree_Localised_nl_NL"."ID" IS NOT NULL THEN "SiteTree_Localised_nl_NL"."KeywordQuestion"
ELSE "SiteTree_Live"."KeywordQuestion" END
AS "KeywordQuestion", "SiteTree_Live"."Follow", "SiteTree_Live"."FollowType", CASE
WHEN "SiteTree_Localised_nl_NL"."ID" IS NOT NULL THEN "SiteTree_Localised_nl_NL"."GenMetaDesc"
ELSE "SiteTree_Live"."GenMetaDesc" END
AS "GenMetaDesc", CASE
WHEN "SiteTree_Localised_nl_NL"."ID" IS NOT NULL THEN "SiteTree_Localised_nl_NL"."FBTitle"
ELSE "SiteTree_Live"."FBTitle" END
AS "FBTitle", CASE
WHEN "SiteTree_Localised_nl_NL"."ID" IS NOT NULL THEN "SiteTree_Localised_nl_NL"."FBDescription"
ELSE "SiteTree_Live"."FBDescription" END
AS "FBDescription", "SiteTree_Live"."FBType", "SiteTree_Live"."FBTypeOverride", CASE
WHEN "SiteTree_Localised_nl_NL"."ID" IS NOT NULL THEN "SiteTree_Localised_nl_NL"."TwTitle"
ELSE "SiteTree_Live"."TwTitle" END
AS "TwTitle", CASE
WHEN "SiteTree_Localised_nl_NL"."ID" IS NOT NULL THEN "SiteTree_Localised_nl_NL"."TwDescription"
ELSE "SiteTree_Live"."TwDescription" END
AS "TwDescription", "SiteTree_Live"."CanViewType", "SiteTree_Live"."CanEditType", "SiteTree_Live"."Version", CASE
WHEN "SiteTree_Localised_nl_NL"."ID" IS NOT NULL THEN "SiteTree_Localised_nl_NL"."URLSegment"
ELSE "SiteTree_Live"."URLSegment" END
AS "URLSegment", CASE
WHEN "SiteTree_Localised_nl_NL"."ID" IS NOT NULL THEN "SiteTree_Localised_nl_NL"."Title"
ELSE "SiteTree_Live"."Title" END
AS "Title", CASE
WHEN "SiteTree_Localised_nl_NL"."ID" IS NOT NULL THEN "SiteTree_Localised_nl_NL"."MenuTitle"
ELSE "SiteTree_Live"."MenuTitle" END
AS "MenuTitle", CASE
WHEN "SiteTree_Localised_nl_NL"."ID" IS NOT NULL THEN "SiteTree_Localised_nl_NL"."Content"
ELSE "SiteTree_Live"."Content" END
AS "Content", CASE
WHEN "SiteTree_Localised_nl_NL"."ID" IS NOT NULL THEN "SiteTree_Localised_nl_NL"."MetaDescription"
ELSE "SiteTree_Live"."MetaDescription" END
AS "MetaDescription", "SiteTree_Live"."ExtraMeta", "SiteTree_Live"."ShowInMenus", "SiteTree_Live"."ShowInSearch", "SiteTree_Live"."Sort", "SiteTree_Live"."HasBrokenFile", "SiteTree_Live"."HasBrokenLink", CASE
WHEN "SiteTree_Localised_nl_NL"."ID" IS NOT NULL THEN "SiteTree_Localised_nl_NL"."ReportClass"
ELSE "SiteTree_Live"."ReportClass" END
AS "ReportClass", "SiteTree_Live"."CanonicalLinkID", "SiteTree_Live"."FBImageID", "SiteTree_Live"."TwImageID", "SiteTree_Live"."ParentID", CASE
WHEN "Page_Localised_nl_NL"."ID" IS NOT NULL THEN "Page_Localised_nl_NL"."ChapterTitle"
ELSE "Page_Live"."ChapterTitle" END
AS "ChapterTitle", CASE
WHEN "Page_Localised_nl_NL"."ID" IS NOT NULL THEN "Page_Localised_nl_NL"."BetterTitle"
ELSE "Page_Live"."BetterTitle" END
AS "BetterTitle", CASE
WHEN "Page_Localised_nl_NL"."ID" IS NOT NULL THEN "Page_Localised_nl_NL"."TeaserText"
ELSE "Page_Live"."TeaserText" END
AS "TeaserText", "Page_Live"."NoTeaser", "Page_Live"."NoBookmark", "Page_Live"."ImageID", "BlockPage_Live"."ElementalAreaID", "SiteTree_Live"."ID",
CASE WHEN "SiteTree_Live"."ClassName" IS NOT NULL THEN "SiteTree_Live"."ClassName"
ELSE 'SilverStripe\\CMS\\Model\\SiteTree' END AS "RecordClassName", 'nl_NL' AS "Locale", CASE WHEN "Page_Localised_nl_NL"."ID" IS NOT NULL THEN 'nl_NL'
ELSE NULL END AS "SourceLocale"
FROM "SiteTree_Live" LEFT JOIN "Page_Live" ON "Page_Live"."ID" = "SiteTree_Live"."ID" LEFT JOIN "BlockPage_Live" ON "BlockPage_Live"."ID" = "SiteTree_Live"."ID" LEFT JOIN "SiteTree_Localised_Live" AS "SiteTree_Localised_nl_NL" ON "SiteTree_Live"."ID" = "SiteTree_Localised_nl_NL"."RecordID" AND "SiteTree_Localised_nl_NL"."Locale" = ? LEFT JOIN "Page_Localised_Live" AS "Page_Localised_nl_NL" ON "Page_Live"."ID" = "Page_Localised_nl_NL"."RecordID" AND "Page_Localised_nl_NL"."Locale" = ?
WHERE ("SiteTree_Live"."ID" = ?)
AND ("SiteTree_Live"."ClassName" IN (?))
AND (("SiteTree_Localised_nl_NL"."ID" IS NOT NULL))
ORDER BY "SiteTree_Live"."Sort" ASC
LIMIT 1
0.0004s
0030: SELECT CASE WHEN EXISTS(SELECT *
FROM "MenuSet"
WHERE ("MenuSet"."Name" = ?)) THEN 1 ELSE 0 END
0.0001s
0031: SELECT DISTINCT "MenuSet"."ClassName", "MenuSet"."LastEdited", "MenuSet"."Created", "MenuSet"."Name", "MenuSet"."Description", "MenuSet"."Sort", "MenuSet"."ID",
CASE WHEN "MenuSet"."ClassName" IS NOT NULL THEN "MenuSet"."ClassName"
ELSE 'Heyday\\MenuManager\\MenuSet' END AS "RecordClassName"
FROM "MenuSet"
WHERE ("MenuSet"."Name" = ?)
ORDER BY "MenuSet"."Sort" ASC
LIMIT 1
0.0002s
0032: SELECT DISTINCT "MenuSet"."ClassName", "MenuSet"."LastEdited", "MenuSet"."Created", "MenuSet"."Name", "MenuSet"."Description", "MenuSet"."Sort", "MenuSet"."ID",
CASE WHEN "MenuSet"."ClassName" IS NOT NULL THEN "MenuSet"."ClassName"
ELSE 'Heyday\\MenuManager\\MenuSet' END AS "RecordClassName"
FROM "MenuSet"
WHERE ("MenuSet"."Name" = ?)
ORDER BY "MenuSet"."Sort" ASC
LIMIT 1
0.0002s
0033: SELECT DISTINCT "MenuItem"."ClassName", "MenuItem"."LastEdited", "MenuItem"."Created", "MenuItem"."SubMenuID", "MenuItem"."IsHeadline", CASE
WHEN "MenuItem_Localised_en_GB"."ID" IS NOT NULL THEN "MenuItem_Localised_en_GB"."MenuTitle"
ELSE "MenuItem"."MenuTitle" END
AS "MenuTitle", CASE
WHEN "MenuItem_Localised_en_GB"."ID" IS NOT NULL THEN "MenuItem_Localised_en_GB"."Link"
ELSE "MenuItem"."Link" END
AS "Link", "MenuItem"."Sort", "MenuItem"."IsNewWindow", "MenuItem"."Anchor", "MenuItem"."ImageID", "MenuItem"."SVGItemID", "MenuItem"."PageID", "MenuItem"."MenuSetID", "MenuItem"."FileID", "MenuItem"."ID",
CASE WHEN "MenuItem"."ClassName" IS NOT NULL THEN "MenuItem"."ClassName"
ELSE 'Heyday\\MenuManager\\MenuItem' END AS "RecordClassName", 'en_GB' AS "Locale", CASE WHEN "MenuItem_Localised_en_GB"."ID" IS NOT NULL THEN 'en_GB'
ELSE NULL END AS "SourceLocale"
FROM "MenuItem" LEFT JOIN "MenuItem_Localised" AS "MenuItem_Localised_en_GB" ON "MenuItem"."ID" = "MenuItem_Localised_en_GB"."RecordID" AND "MenuItem_Localised_en_GB"."Locale" = ?
WHERE ("MenuItem"."MenuSetID" = ?)
AND (("MenuItem_Localised_en_GB"."ID" IS NOT NULL))
ORDER BY "MenuItem"."Sort" ASC
0.0002s
0034: SELECT DISTINCT count(DISTINCT "MenuItem"."ID") AS "Count"
FROM "MenuItem" LEFT JOIN "MenuItem_Localised" AS "MenuItem_Localised_en_GB" ON "MenuItem"."ID" = "MenuItem_Localised_en_GB"."RecordID" AND "MenuItem_Localised_en_GB"."Locale" = ?
WHERE ("MenuItem"."MenuSetID" = ?)
AND (("MenuItem_Localised_en_GB"."ID" IS NOT NULL))
0.0001s
0035: SELECT CASE WHEN EXISTS(SELECT *
FROM "MenuSet"
WHERE ("MenuSet"."Name" = ?)) THEN 1 ELSE 0 END
0.0001s
0036: SELECT DISTINCT "MenuSet"."ClassName", "MenuSet"."LastEdited", "MenuSet"."Created", "MenuSet"."Name", "MenuSet"."Description", "MenuSet"."Sort", "MenuSet"."ID",
CASE WHEN "MenuSet"."ClassName" IS NOT NULL THEN "MenuSet"."ClassName"
ELSE 'Heyday\\MenuManager\\MenuSet' END AS "RecordClassName"
FROM "MenuSet"
WHERE ("MenuSet"."Name" = ?)
ORDER BY "MenuSet"."Sort" ASC
LIMIT 1
0.0001s
0037: SELECT DISTINCT "MenuSet"."ClassName", "MenuSet"."LastEdited", "MenuSet"."Created", "MenuSet"."Name", "MenuSet"."Description", "MenuSet"."Sort", "MenuSet"."ID",
CASE WHEN "MenuSet"."ClassName" IS NOT NULL THEN "MenuSet"."ClassName"
ELSE 'Heyday\\MenuManager\\MenuSet' END AS "RecordClassName"
FROM "MenuSet"
WHERE ("MenuSet"."Name" = ?)
ORDER BY "MenuSet"."Sort" ASC
LIMIT 1
0.0001s
0038: SELECT DISTINCT "MenuItem"."ClassName", "MenuItem"."LastEdited", "MenuItem"."Created", "MenuItem"."SubMenuID", "MenuItem"."IsHeadline", CASE
WHEN "MenuItem_Localised_en_GB"."ID" IS NOT NULL THEN "MenuItem_Localised_en_GB"."MenuTitle"
ELSE "MenuItem"."MenuTitle" END
AS "MenuTitle", CASE
WHEN "MenuItem_Localised_en_GB"."ID" IS NOT NULL THEN "MenuItem_Localised_en_GB"."Link"
ELSE "MenuItem"."Link" END
AS "Link", "MenuItem"."Sort", "MenuItem"."IsNewWindow", "MenuItem"."Anchor", "MenuItem"."ImageID", "MenuItem"."SVGItemID", "MenuItem"."PageID", "MenuItem"."MenuSetID", "MenuItem"."FileID", "MenuItem"."ID",
CASE WHEN "MenuItem"."ClassName" IS NOT NULL THEN "MenuItem"."ClassName"
ELSE 'Heyday\\MenuManager\\MenuItem' END AS "RecordClassName", 'en_GB' AS "Locale", CASE WHEN "MenuItem_Localised_en_GB"."ID" IS NOT NULL THEN 'en_GB'
ELSE NULL END AS "SourceLocale"
FROM "MenuItem" LEFT JOIN "MenuItem_Localised" AS "MenuItem_Localised_en_GB" ON "MenuItem"."ID" = "MenuItem_Localised_en_GB"."RecordID" AND "MenuItem_Localised_en_GB"."Locale" = ?
WHERE ("MenuItem"."MenuSetID" = ?)
AND (("MenuItem_Localised_en_GB"."ID" IS NOT NULL))
ORDER BY "MenuItem"."Sort" ASC
0.0002s
0039: SELECT DISTINCT count(DISTINCT "MenuItem"."ID") AS "Count"
FROM "MenuItem" LEFT JOIN "MenuItem_Localised" AS "MenuItem_Localised_en_GB" ON "MenuItem"."ID" = "MenuItem_Localised_en_GB"."RecordID" AND "MenuItem_Localised_en_GB"."Locale" = ?
WHERE ("MenuItem"."MenuSetID" = ?)
AND (("MenuItem_Localised_en_GB"."ID" IS NOT NULL))
0.0001s
0040: SELECT CASE WHEN EXISTS(SELECT *
FROM "MenuSet"
WHERE ("MenuSet"."Name" = ?)) THEN 1 ELSE 0 END
0.0001s
0041: SELECT DISTINCT "MenuSet"."ClassName", "MenuSet"."LastEdited", "MenuSet"."Created", "MenuSet"."Name", "MenuSet"."Description", "MenuSet"."Sort", "MenuSet"."ID",
CASE WHEN "MenuSet"."ClassName" IS NOT NULL THEN "MenuSet"."ClassName"
ELSE 'Heyday\\MenuManager\\MenuSet' END AS "RecordClassName"
FROM "MenuSet"
WHERE ("MenuSet"."Name" = ?)
ORDER BY "MenuSet"."Sort" ASC
LIMIT 1
0.0001s
0042: SELECT DISTINCT "MenuSet"."ClassName", "MenuSet"."LastEdited", "MenuSet"."Created", "MenuSet"."Name", "MenuSet"."Description", "MenuSet"."Sort", "MenuSet"."ID",
CASE WHEN "MenuSet"."ClassName" IS NOT NULL THEN "MenuSet"."ClassName"
ELSE 'Heyday\\MenuManager\\MenuSet' END AS "RecordClassName"
FROM "MenuSet"
WHERE ("MenuSet"."Name" = ?)
ORDER BY "MenuSet"."Sort" ASC
LIMIT 1
0.0001s
0043: SELECT DISTINCT "MenuItem"."ClassName", "MenuItem"."LastEdited", "MenuItem"."Created", "MenuItem"."SubMenuID", "MenuItem"."IsHeadline", CASE
WHEN "MenuItem_Localised_en_GB"."ID" IS NOT NULL THEN "MenuItem_Localised_en_GB"."MenuTitle"
ELSE "MenuItem"."MenuTitle" END
AS "MenuTitle", CASE
WHEN "MenuItem_Localised_en_GB"."ID" IS NOT NULL THEN "MenuItem_Localised_en_GB"."Link"
ELSE "MenuItem"."Link" END
AS "Link", "MenuItem"."Sort", "MenuItem"."IsNewWindow", "MenuItem"."Anchor", "MenuItem"."ImageID", "MenuItem"."SVGItemID", "MenuItem"."PageID", "MenuItem"."MenuSetID", "MenuItem"."FileID", "MenuItem"."ID",
CASE WHEN "MenuItem"."ClassName" IS NOT NULL THEN "MenuItem"."ClassName"
ELSE 'Heyday\\MenuManager\\MenuItem' END AS "RecordClassName", 'en_GB' AS "Locale", CASE WHEN "MenuItem_Localised_en_GB"."ID" IS NOT NULL THEN 'en_GB'
ELSE NULL END AS "SourceLocale"
FROM "MenuItem" LEFT JOIN "MenuItem_Localised" AS "MenuItem_Localised_en_GB" ON "MenuItem"."ID" = "MenuItem_Localised_en_GB"."RecordID" AND "MenuItem_Localised_en_GB"."Locale" = ?
WHERE ("MenuItem"."MenuSetID" = ?)
AND (("MenuItem_Localised_en_GB"."ID" IS NOT NULL))
ORDER BY "MenuItem"."Sort" ASC
0.0001s
0044: SELECT DISTINCT count(DISTINCT "MenuItem"."ID") AS "Count"
FROM "MenuItem" LEFT JOIN "MenuItem_Localised" AS "MenuItem_Localised_en_GB" ON "MenuItem"."ID" = "MenuItem_Localised_en_GB"."RecordID" AND "MenuItem_Localised_en_GB"."Locale" = ?
WHERE ("MenuItem"."MenuSetID" = ?)
AND (("MenuItem_Localised_en_GB"."ID" IS NOT NULL))
0.0001s
0045: SELECT DISTINCT "File_Live"."ClassName", "File_Live"."LastEdited", "File_Live"."Created", CASE WHEN "File_Live"."ClassName" IN ('SilverStripe\\Assets\\File', 'SilverStripe\\Assets\\Folder', 'SilverStripe\\Assets\\Image', 'WeDevelop\\SvgImage\\Assets\\Svg') THEN "File_Live"."Copyright" WHEN "File_Live"."ClassName" IN ('SilverStripe\\Assets\\Image', 'WeDevelop\\SvgImage\\Assets\\Svg') THEN "Image_Live"."Copyright" WHEN "File_Live"."ClassName" IN ('SilverStripe\\Assets\\Image', 'WeDevelop\\SvgImage\\Assets\\Svg') THEN "Image_Live"."Copyright" ELSE NULL END AS "Copyright", CASE WHEN "File_Live"."ClassName" IN ('SilverStripe\\Assets\\File', 'SilverStripe\\Assets\\Folder', 'SilverStripe\\Assets\\Image', 'WeDevelop\\SvgImage\\Assets\\Svg') THEN "File_Live"."Bildunterschrift" WHEN "File_Live"."ClassName" IN ('SilverStripe\\Assets\\Image', 'WeDevelop\\SvgImage\\Assets\\Svg') THEN "Image_Live"."Bildunterschrift" WHEN "File_Live"."ClassName" IN ('SilverStripe\\Assets\\Image', 'WeDevelop\\SvgImage\\Assets\\Svg') THEN "Image_Live"."Bildunterschrift" ELSE NULL END AS "Bildunterschrift", CASE WHEN "File_Live"."ClassName" IN ('SilverStripe\\Assets\\File', 'SilverStripe\\Assets\\Folder', 'SilverStripe\\Assets\\Image', 'WeDevelop\\SvgImage\\Assets\\Svg') THEN "File_Live"."AltText" WHEN "File_Live"."ClassName" IN ('SilverStripe\\Assets\\Image', 'WeDevelop\\SvgImage\\Assets\\Svg') THEN "Image_Live"."AltText" WHEN "File_Live"."ClassName" IN ('SilverStripe\\Assets\\Image', 'WeDevelop\\SvgImage\\Assets\\Svg') THEN "Image_Live"."AltText" ELSE NULL END AS "AltText", "File_Live"."Version", "File_Live"."CanViewType", "File_Live"."CanEditType", "File_Live"."Name", "File_Live"."Title", "File_Live"."ShowInSearch", "File_Live"."ParentID", "File_Live"."OwnerID", "File_Live"."FileHash", "File_Live"."FileFilename", "File_Live"."FileVariant", "Image_Live"."FocusPointX", "Image_Live"."FocusPointY", "Image_Live"."FocusPointWidth", "Image_Live"."FocusPointHeight", "File_Live"."ID",
CASE WHEN "File_Live"."ClassName" IS NOT NULL THEN "File_Live"."ClassName"
ELSE 'SilverStripe\\Assets\\File' END AS "RecordClassName"
FROM "File_Live" LEFT JOIN "Image_Live" ON "Image_Live"."ID" = "File_Live"."ID"
WHERE ("File_Live"."ID" = ?)
AND ("File_Live"."ClassName" IN (?, ?))
ORDER BY "File_Live"."Name" ASC
LIMIT 1
0.0003s
0046: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "BlockPage_Live"."ElementalAreaID", "SiteTree_Live"."ID",
CASE WHEN "SiteTree_Live"."ClassName" IS NOT NULL THEN "SiteTree_Live"."ClassName"
ELSE 'SilverStripe\\CMS\\Model\\SiteTree' END AS "RecordClassName", 'en_GB' AS "Locale", CASE WHEN "Page_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 "BlockPage_Live" ON "BlockPage_Live"."ID" = "SiteTree_Live"."ID" LEFT JOIN "SiteTree_Localised_Live" AS "SiteTree_Localised_en_GB" ON "SiteTree_Live"."ID" = "SiteTree_Localised_en_GB"."RecordID" AND "SiteTree_Localised_en_GB"."Locale" = ? LEFT JOIN "Page_Localised_Live" AS "Page_Localised_en_GB" ON "Page_Live"."ID" = "Page_Localised_en_GB"."RecordID" AND "Page_Localised_en_GB"."Locale" = ?
WHERE ("SiteTree_Live"."ID" = ?)
AND ("SiteTree_Live"."ClassName" IN (?))
AND (("SiteTree_Localised_en_GB"."ID" IS NOT NULL))
ORDER BY "SiteTree_Live"."Sort" ASC
LIMIT 1
0.0002s
0047: SELECT DISTINCT "ElementalArea_Live"."ClassName", "ElementalArea_Live"."LastEdited", "ElementalArea_Live"."Created", "ElementalArea_Live"."Version", "ElementalArea_Live"."OwnerClassName", "ElementalArea_Live"."TopPageID", "ElementalArea_Live"."ID",
CASE WHEN "ElementalArea_Live"."ClassName" IS NOT NULL THEN "ElementalArea_Live"."ClassName"
ELSE 'DNADesign\\Elemental\\Models\\ElementalArea' END AS "RecordClassName"
FROM "ElementalArea_Live"
WHERE ("ElementalArea_Live"."ID" = ?)
LIMIT 1
0.0002s
0048: SELECT DISTINCT "Element_Live"."ClassName", "Element_Live"."LastEdited", "Element_Live"."Created", "Element_Live"."AvailableGlobally", CASE
WHEN "Element_Localised_en_GB"."ID" IS NOT NULL THEN "Element_Localised_en_GB"."VirtualLookupTitle"
ELSE "Element_Live"."VirtualLookupTitle" END
AS "VirtualLookupTitle", "Element_Live"."SEOHeadline", CASE
WHEN "Element_Localised_en_GB"."ID" IS NOT NULL THEN "Element_Localised_en_GB"."BetterTitle"
ELSE "Element_Live"."BetterTitle" END
AS "BetterTitle", "Element_Live"."MarginOrPadding", CASE
WHEN "Element_Localised_en_GB"."ID" IS NOT NULL THEN "Element_Localised_en_GB"."AbstandOben"
ELSE "Element_Live"."AbstandOben" END
AS "AbstandOben", CASE
WHEN "Element_Localised_en_GB"."ID" IS NOT NULL THEN "Element_Localised_en_GB"."AbstandUnten"
ELSE "Element_Live"."AbstandUnten" END
AS "AbstandUnten", "Element_Live"."BGColor", "Element_Live"."NoBGColor", "Element_Live"."Version", 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"."ShowTitle", "Element_Live"."Sort", CASE
WHEN "Element_Localised_en_GB"."ID" IS NOT NULL THEN "Element_Localised_en_GB"."ExtraClass"
ELSE "Element_Live"."ExtraClass" END
AS "ExtraClass", CASE
WHEN "Element_Localised_en_GB"."ID" IS NOT NULL THEN "Element_Localised_en_GB"."Style"
ELSE "Element_Live"."Style" END
AS "Style", "Element_Live"."BGImageID", "Element_Live"."TopPageID", "Element_Live"."ParentID", "Element_Live"."ID",
CASE WHEN "Element_Live"."ClassName" IS NOT NULL THEN "Element_Live"."ClassName"
ELSE 'DNADesign\\Elemental\\Models\\BaseElement' END AS "RecordClassName", '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
0049: SELECT DISTINCT "ElementalArea_Live"."ClassName", "ElementalArea_Live"."LastEdited", "ElementalArea_Live"."Created", "ElementalArea_Live"."Version", "ElementalArea_Live"."OwnerClassName", "ElementalArea_Live"."TopPageID", "ElementalArea_Live"."ID",
CASE WHEN "ElementalArea_Live"."ClassName" IS NOT NULL THEN "ElementalArea_Live"."ClassName"
ELSE 'DNADesign\\Elemental\\Models\\ElementalArea' END AS "RecordClassName"
FROM "ElementalArea_Live"
WHERE ("ElementalArea_Live"."ID" = ?)
LIMIT 1
0.0002s
0050: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", CASE
WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."BetterSiteTitle"
ELSE "SiteTree_Live"."BetterSiteTitle" END
AS "BetterSiteTitle", CASE
WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."Keyword"
ELSE "SiteTree_Live"."Keyword" END
AS "Keyword", CASE
WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."FeaturedKeyword"
ELSE "SiteTree_Live"."FeaturedKeyword" END
AS "FeaturedKeyword", CASE
WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."KeywordQuestion"
ELSE "SiteTree_Live"."KeywordQuestion" END
AS "KeywordQuestion", "SiteTree_Live"."Follow", "SiteTree_Live"."FollowType", CASE
WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."GenMetaDesc"
ELSE "SiteTree_Live"."GenMetaDesc" END
AS "GenMetaDesc", CASE
WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."FBTitle"
ELSE "SiteTree_Live"."FBTitle" END
AS "FBTitle", CASE
WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."FBDescription"
ELSE "SiteTree_Live"."FBDescription" END
AS "FBDescription", "SiteTree_Live"."FBType", "SiteTree_Live"."FBTypeOverride", CASE
WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."TwTitle"
ELSE "SiteTree_Live"."TwTitle" END
AS "TwTitle", CASE
WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."TwDescription"
ELSE "SiteTree_Live"."TwDescription" END
AS "TwDescription", "SiteTree_Live"."CanViewType", "SiteTree_Live"."CanEditType", "SiteTree_Live"."Version", CASE
WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."URLSegment"
ELSE "SiteTree_Live"."URLSegment" END
AS "URLSegment", CASE
WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."Title"
ELSE "SiteTree_Live"."Title" END
AS "Title", CASE
WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."MenuTitle"
ELSE "SiteTree_Live"."MenuTitle" END
AS "MenuTitle", CASE
WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."Content"
ELSE "SiteTree_Live"."Content" END
AS "Content", CASE
WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."MetaDescription"
ELSE "SiteTree_Live"."MetaDescription" END
AS "MetaDescription", "SiteTree_Live"."ExtraMeta", "SiteTree_Live"."ShowInMenus", "SiteTree_Live"."ShowInSearch", "SiteTree_Live"."Sort", "SiteTree_Live"."HasBrokenFile", "SiteTree_Live"."HasBrokenLink", CASE
WHEN "SiteTree_Localised_en_GB"."ID" IS NOT NULL THEN "SiteTree_Localised_en_GB"."ReportClass"
ELSE "SiteTree_Live"."ReportClass" END
AS "ReportClass", "SiteTree_Live"."CanonicalLinkID", "SiteTree_Live"."FBImageID", "SiteTree_Live"."TwImageID", "SiteTree_Live"."ParentID", CASE
WHEN "Page_Localised_en_GB"."ID" IS NOT NULL THEN "Page_Localised_en_GB"."ChapterTitle"
ELSE "Page_Live"."ChapterTitle" END
AS "ChapterTitle", CASE
WHEN "Page_Localised_en_GB"."ID" IS NOT NULL THEN "Page_Localised_en_GB"."BetterTitle"
ELSE "Page_Live"."BetterTitle" END
AS "BetterTitle", CASE
WHEN "Page_Localised_en_GB"."ID" IS NOT NULL THEN "Page_Localised_en_GB"."TeaserText"
ELSE "Page_Live"."TeaserText" END
AS "TeaserText", "Page_Live"."NoTeaser", "Page_Live"."NoBookmark", "Page_Live"."ImageID", "BlockPage_Live"."ElementalAreaID", "SiteTree_Live"."ID",
CASE WHEN "SiteTree_Live"."ClassName" IS NOT NULL THEN "SiteTree_Live"."ClassName"
ELSE 'SilverStripe\\CMS\\Model\\SiteTree' END AS "RecordClassName", 'en_GB' AS "Locale", CASE WHEN "Page_Localised_en_GB"."ID" IS NOT NULL THEN 'en_GB'
ELSE NULL END AS "SourceLocale"
FROM "SiteTree_Live" LEFT JOIN "Page_Live" ON "Page_Live"."ID" = "SiteTree_Live"."ID" LEFT JOIN "BlockPage_Live" ON "BlockPage_Live"."ID" = "SiteTree_Live"."ID" LEFT JOIN "SiteTree_Localised_Live" AS "SiteTree_Localised_en_GB" ON "SiteTree_Live"."ID" = "SiteTree_Localised_en_GB"."RecordID" AND "SiteTree_Localised_en_GB"."Locale" = ? LEFT JOIN "Page_Localised_Live" AS "Page_Localised_en_GB" ON "Page_Live"."ID" = "Page_Localised_en_GB"."RecordID" AND "Page_Localised_en_GB"."Locale" = ?
WHERE ("BlockPage_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.0003s
0051: 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.0004s
0052: SELECT DISTINCT "ElementalArea_Live"."ClassName", "ElementalArea_Live"."LastEdited", "ElementalArea_Live"."Created", "ElementalArea_Live"."Version", "ElementalArea_Live"."OwnerClassName", "ElementalArea_Live"."TopPageID", "ElementalArea_Live"."ID",
CASE WHEN "ElementalArea_Live"."ClassName" IS NOT NULL THEN "ElementalArea_Live"."ClassName"
ELSE 'DNADesign\\Elemental\\Models\\ElementalArea' END AS "RecordClassName"
FROM "ElementalArea_Live"
WHERE ("ElementalArea_Live"."ID" = ?)
LIMIT 1
0.0002s
0053: SELECT CASE WHEN EXISTS(SELECT *
FROM "PersonEntry" INNER JOIN "Element_Persons" ON "Element_Persons"."PersonEntryID" = "PersonEntry"."ID" LEFT JOIN "PersonEntry_Localised" AS "PersonEntry_Localised_en_GB" ON "PersonEntry"."ID" = "PersonEntry_Localised_en_GB"."RecordID" AND "PersonEntry_Localised_en_GB"."Locale" = ?
WHERE ("Element_Persons"."ElementID" = ?)
AND (("PersonEntry_Localised_en_GB"."ID" IS NOT NULL))) THEN 1 ELSE 0 END
0.0002s
0054: SELECT DISTINCT "PersonEntry"."ClassName", "PersonEntry"."LastEdited", "PersonEntry"."Created", "PersonEntry"."SortOrder", CASE
WHEN "PersonEntry_Localised_en_GB"."ID" IS NOT NULL THEN "PersonEntry_Localised_en_GB"."Name"
ELSE "PersonEntry"."Name" END
AS "Name", CASE
WHEN "PersonEntry_Localised_en_GB"."ID" IS NOT NULL THEN "PersonEntry_Localised_en_GB"."Color"
ELSE "PersonEntry"."Color" END
AS "Color", "PersonEntry"."ImageID", "PersonEntry"."ID",
CASE WHEN "PersonEntry"."ClassName" IS NOT NULL THEN "PersonEntry"."ClassName"
ELSE 'App\\Models\\PersonEntry' END AS "RecordClassName", 'en_GB' AS "Locale", CASE WHEN "PersonEntry_Localised_en_GB"."ID" IS NOT NULL THEN 'en_GB'
ELSE NULL END AS "SourceLocale"
FROM "PersonEntry" INNER JOIN "Element_Persons" ON "Element_Persons"."PersonEntryID" = "PersonEntry"."ID" LEFT JOIN "PersonEntry_Localised" AS "PersonEntry_Localised_en_GB" ON "PersonEntry"."ID" = "PersonEntry_Localised_en_GB"."RecordID" AND "PersonEntry_Localised_en_GB"."Locale" = ?
WHERE ("Element_Persons"."ElementID" = ?)
AND (("PersonEntry_Localised_en_GB"."ID" IS NOT NULL))
ORDER BY "Name" ASC
0.0002s
0055: SELECT DISTINCT "Element_Live"."ClassName", "Element_Live"."LastEdited", "Element_Live"."Created", CASE
WHEN "ChapterTitleElement_Localised_en_GB"."ID" IS NOT NULL THEN "ChapterTitleElement_Localised_en_GB"."ChapterNumber"
ELSE "ChapterTitleElement_Live"."ChapterNumber" END
AS "ChapterNumber", "Element_Live"."ID",
CASE WHEN "Element_Live"."ClassName" IS NOT NULL THEN "Element_Live"."ClassName"
ELSE 'DNADesign\\Elemental\\Models\\BaseElement' END AS "RecordClassName", 'en_GB' AS "Locale", CASE WHEN "ChapterTitleElement_Localised_en_GB"."ID" IS NOT NULL THEN 'en_GB'
ELSE NULL END AS "SourceLocale", "Element_Live"."Sort"
FROM "Element_Live" LEFT JOIN "ChapterTitleElement_Live" ON "ChapterTitleElement_Live"."ID" = "Element_Live"."ID" LEFT JOIN "Element_Localised_Live" AS "Element_Localised_en_GB" ON "Element_Live"."ID" = "Element_Localised_en_GB"."RecordID" AND "Element_Localised_en_GB"."Locale" = ? LEFT JOIN "ChapterTitleElement_Localised_Live" AS "ChapterTitleElement_Localised_en_GB" ON "ChapterTitleElement_Live"."ID" = "ChapterTitleElement_Localised_en_GB"."RecordID" AND "ChapterTitleElement_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.0002s
0056: SELECT CASE WHEN EXISTS(SELECT *
FROM "PersonEntry" INNER JOIN "Element_Persons" ON "Element_Persons"."PersonEntryID" = "PersonEntry"."ID" LEFT JOIN "PersonEntry_Localised" AS "PersonEntry_Localised_en_GB" ON "PersonEntry"."ID" = "PersonEntry_Localised_en_GB"."RecordID" AND "PersonEntry_Localised_en_GB"."Locale" = ?
WHERE ("Element_Persons"."ElementID" = ?)
AND (("PersonEntry_Localised_en_GB"."ID" IS NOT NULL))) THEN 1 ELSE 0 END
0.0002s
0057: SELECT "PersonEntry"."ID", "PersonEntry"."Name" AS "_SortColumn0"
FROM "PersonEntry" INNER JOIN "Element_Persons" ON "Element_Persons"."PersonEntryID" = "PersonEntry"."ID" LEFT JOIN "PersonEntry_Localised" AS "PersonEntry_Localised_en_GB" ON "PersonEntry"."ID" = "PersonEntry_Localised_en_GB"."RecordID" AND "PersonEntry_Localised_en_GB"."Locale" = ?
WHERE ("Element_Persons"."ElementID" = ?)
AND (("PersonEntry_Localised_en_GB"."ID" IS NOT NULL))
ORDER BY "_SortColumn0" ASC
0.0001s
0058: SELECT DISTINCT count(DISTINCT "PersonEntry"."ID") AS "Count"
FROM "PersonEntry" INNER JOIN "Element_Persons" ON "Element_Persons"."PersonEntryID" = "PersonEntry"."ID" LEFT JOIN "PersonEntry_Localised" AS "PersonEntry_Localised_en_GB" ON "PersonEntry"."ID" = "PersonEntry_Localised_en_GB"."RecordID" AND "PersonEntry_Localised_en_GB"."Locale" = ?
WHERE ("Element_Persons"."ElementID" = ?)
AND (("PersonEntry_Localised_en_GB"."ID" IS NOT NULL))
0.0002s
0059: SELECT DISTINCT "PersonEntry"."ClassName", "PersonEntry"."LastEdited", "PersonEntry"."Created", "PersonEntry"."SortOrder", CASE
WHEN "PersonEntry_Localised_en_GB"."ID" IS NOT NULL THEN "PersonEntry_Localised_en_GB"."Name"
ELSE "PersonEntry"."Name" END
AS "Name", CASE
WHEN "PersonEntry_Localised_en_GB"."ID" IS NOT NULL THEN "PersonEntry_Localised_en_GB"."Color"
ELSE "PersonEntry"."Color" END
AS "Color", "PersonEntry"."ImageID", "PersonEntry"."ID",
CASE WHEN "PersonEntry"."ClassName" IS NOT NULL THEN "PersonEntry"."ClassName"
ELSE 'App\\Models\\PersonEntry' END AS "RecordClassName", 'en_GB' AS "Locale", CASE WHEN "PersonEntry_Localised_en_GB"."ID" IS NOT NULL THEN 'en_GB'
ELSE NULL END AS "SourceLocale"
FROM "PersonEntry" INNER JOIN "Element_Persons" ON "Element_Persons"."PersonEntryID" = "PersonEntry"."ID" LEFT JOIN "PersonEntry_Localised" AS "PersonEntry_Localised_en_GB" ON "PersonEntry"."ID" = "PersonEntry_Localised_en_GB"."RecordID" AND "PersonEntry_Localised_en_GB"."Locale" = ?
WHERE ("Element_Persons"."ElementID" = ?)
AND (("PersonEntry_Localised_en_GB"."ID" IS NOT NULL))
ORDER BY "Name" ASC
LIMIT 1
0.0002s
0060: SELECT DISTINCT count(DISTINCT "File_Live"."ID") AS "Count"
FROM "File_Live" LEFT JOIN "Image_Live" ON "Image_Live"."ID" = "File_Live"."ID" INNER JOIN "ImageGalleryElement_Images" ON "ImageGalleryElement_Images"."ImageID" = "File_Live"."ID"
WHERE ("ImageGalleryElement_Images"."ImageGalleryElementID" = ?)
AND ("File_Live"."ClassName" IN (?, ?))
0.0001s
0061: SELECT DISTINCT "ImageGalleryElement_Images"."SortOrder", "File_Live"."ClassName", "File_Live"."LastEdited", "File_Live"."Created", CASE WHEN "File_Live"."ClassName" IN ('SilverStripe\\Assets\\File', 'SilverStripe\\Assets\\Folder', 'SilverStripe\\Assets\\Image', 'WeDevelop\\SvgImage\\Assets\\Svg') THEN "File_Live"."Copyright" WHEN "File_Live"."ClassName" IN ('SilverStripe\\Assets\\Image', 'WeDevelop\\SvgImage\\Assets\\Svg') THEN "Image_Live"."Copyright" WHEN "File_Live"."ClassName" IN ('SilverStripe\\Assets\\Image', 'WeDevelop\\SvgImage\\Assets\\Svg') THEN "Image_Live"."Copyright" ELSE NULL END AS "Copyright", CASE WHEN "File_Live"."ClassName" IN ('SilverStripe\\Assets\\File', 'SilverStripe\\Assets\\Folder', 'SilverStripe\\Assets\\Image', 'WeDevelop\\SvgImage\\Assets\\Svg') THEN "File_Live"."Bildunterschrift" WHEN "File_Live"."ClassName" IN ('SilverStripe\\Assets\\Image', 'WeDevelop\\SvgImage\\Assets\\Svg') THEN "Image_Live"."Bildunterschrift" WHEN "File_Live"."ClassName" IN ('SilverStripe\\Assets\\Image', 'WeDevelop\\SvgImage\\Assets\\Svg') THEN "Image_Live"."Bildunterschrift" ELSE NULL END AS "Bildunterschrift", CASE WHEN "File_Live"."ClassName" IN ('SilverStripe\\Assets\\File', 'SilverStripe\\Assets\\Folder', 'SilverStripe\\Assets\\Image', 'WeDevelop\\SvgImage\\Assets\\Svg') THEN "File_Live"."AltText" WHEN "File_Live"."ClassName" IN ('SilverStripe\\Assets\\Image', 'WeDevelop\\SvgImage\\Assets\\Svg') THEN "Image_Live"."AltText" WHEN "File_Live"."ClassName" IN ('SilverStripe\\Assets\\Image', 'WeDevelop\\SvgImage\\Assets\\Svg') THEN "Image_Live"."AltText" ELSE NULL END AS "AltText", "File_Live"."Version", "File_Live"."CanViewType", "File_Live"."CanEditType", "File_Live"."Name", "File_Live"."Title", "File_Live"."ShowInSearch", "File_Live"."ParentID", "File_Live"."OwnerID", "File_Live"."FileHash", "File_Live"."FileFilename", "File_Live"."FileVariant", "Image_Live"."FocusPointX", "Image_Live"."FocusPointY", "Image_Live"."FocusPointWidth", "Image_Live"."FocusPointHeight", "File_Live"."ID",
CASE WHEN "File_Live"."ClassName" IS NOT NULL THEN "File_Live"."ClassName"
ELSE 'SilverStripe\\Assets\\File' END AS "RecordClassName"
FROM "File_Live" LEFT JOIN "Image_Live" ON "Image_Live"."ID" = "File_Live"."ID" INNER JOIN "ImageGalleryElement_Images" ON "ImageGalleryElement_Images"."ImageID" = "File_Live"."ID"
WHERE ("ImageGalleryElement_Images"."ImageGalleryElementID" = ?)
AND ("File_Live"."ClassName" IN (?, ?))
ORDER BY "File_Live"."Name" ASC
0.0003s
0062: SELECT CASE WHEN EXISTS(SELECT *
FROM "PersonEntry" INNER JOIN "Element_Persons" ON "Element_Persons"."PersonEntryID" = "PersonEntry"."ID" LEFT JOIN "PersonEntry_Localised" AS "PersonEntry_Localised_en_GB" ON "PersonEntry"."ID" = "PersonEntry_Localised_en_GB"."RecordID" AND "PersonEntry_Localised_en_GB"."Locale" = ?
WHERE ("Element_Persons"."ElementID" = ?)
AND (("PersonEntry_Localised_en_GB"."ID" IS NOT NULL))) THEN 1 ELSE 0 END
0.0002s
0063: SELECT "PersonEntry"."ID", "PersonEntry"."Name" AS "_SortColumn0"
FROM "PersonEntry" INNER JOIN "Element_Persons" ON "Element_Persons"."PersonEntryID" = "PersonEntry"."ID" LEFT JOIN "PersonEntry_Localised" AS "PersonEntry_Localised_en_GB" ON "PersonEntry"."ID" = "PersonEntry_Localised_en_GB"."RecordID" AND "PersonEntry_Localised_en_GB"."Locale" = ?
WHERE ("Element_Persons"."ElementID" = ?)
AND (("PersonEntry_Localised_en_GB"."ID" IS NOT NULL))
ORDER BY "_SortColumn0" ASC
0.0002s
0064: SELECT DISTINCT count(DISTINCT "PersonEntry"."ID") AS "Count"
FROM "PersonEntry" INNER JOIN "Element_Persons" ON "Element_Persons"."PersonEntryID" = "PersonEntry"."ID" LEFT JOIN "PersonEntry_Localised" AS "PersonEntry_Localised_en_GB" ON "PersonEntry"."ID" = "PersonEntry_Localised_en_GB"."RecordID" AND "PersonEntry_Localised_en_GB"."Locale" = ?
WHERE ("Element_Persons"."ElementID" = ?)
AND (("PersonEntry_Localised_en_GB"."ID" IS NOT NULL))
0.0001s
0065: SELECT DISTINCT "PersonEntry"."ClassName", "PersonEntry"."LastEdited", "PersonEntry"."Created", "PersonEntry"."SortOrder", CASE
WHEN "PersonEntry_Localised_en_GB"."ID" IS NOT NULL THEN "PersonEntry_Localised_en_GB"."Name"
ELSE "PersonEntry"."Name" END
AS "Name", CASE
WHEN "PersonEntry_Localised_en_GB"."ID" IS NOT NULL THEN "PersonEntry_Localised_en_GB"."Color"
ELSE "PersonEntry"."Color" END
AS "Color", "PersonEntry"."ImageID", "PersonEntry"."ID",
CASE WHEN "PersonEntry"."ClassName" IS NOT NULL THEN "PersonEntry"."ClassName"
ELSE 'App\\Models\\PersonEntry' END AS "RecordClassName", 'en_GB' AS "Locale", CASE WHEN "PersonEntry_Localised_en_GB"."ID" IS NOT NULL THEN 'en_GB'
ELSE NULL END AS "SourceLocale"
FROM "PersonEntry" INNER JOIN "Element_Persons" ON "Element_Persons"."PersonEntryID" = "PersonEntry"."ID" LEFT JOIN "PersonEntry_Localised" AS "PersonEntry_Localised_en_GB" ON "PersonEntry"."ID" = "PersonEntry_Localised_en_GB"."RecordID" AND "PersonEntry_Localised_en_GB"."Locale" = ?
WHERE ("Element_Persons"."ElementID" = ?)
AND (("PersonEntry_Localised_en_GB"."ID" IS NOT NULL))
ORDER BY "Name" ASC
LIMIT 1
0.0002s
0066: SELECT DISTINCT "Element_Live"."ClassName", "Element_Live"."LastEdited", "Element_Live"."Created", CASE
WHEN "BetterContent_Localised_en_GB"."ID" IS NOT NULL THEN "BetterContent_Localised_en_GB"."Content"
ELSE "BetterContent_Live"."Content" END
AS "Content", "Element_Live"."ID",
CASE WHEN "Element_Live"."ClassName" IS NOT NULL THEN "Element_Live"."ClassName"
ELSE 'DNADesign\\Elemental\\Models\\BaseElement' END AS "RecordClassName", 'en_GB' AS "Locale", CASE WHEN "BetterContent_Localised_en_GB"."ID" IS NOT NULL THEN 'en_GB'
ELSE NULL END AS "SourceLocale", "Element_Live"."Sort"
FROM "Element_Live" LEFT JOIN "BetterContent_Live" ON "BetterContent_Live"."ID" = "Element_Live"."ID" LEFT JOIN "Element_Localised_Live" AS "Element_Localised_en_GB" ON "Element_Live"."ID" = "Element_Localised_en_GB"."RecordID" AND "Element_Localised_en_GB"."Locale" = ? LEFT JOIN "BetterContent_Localised_Live" AS "BetterContent_Localised_en_GB" ON "BetterContent_Live"."ID" = "BetterContent_Localised_en_GB"."RecordID" AND "BetterContent_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.0002s
0067: SELECT CASE WHEN EXISTS(SELECT *
FROM "PersonEntry" INNER JOIN "Element_Persons" ON "Element_Persons"."PersonEntryID" = "PersonEntry"."ID" LEFT JOIN "PersonEntry_Localised" AS "PersonEntry_Localised_en_GB" ON "PersonEntry"."ID" = "PersonEntry_Localised_en_GB"."RecordID" AND "PersonEntry_Localised_en_GB"."Locale" = ?
WHERE ("Element_Persons"."ElementID" = ?)
AND (("PersonEntry_Localised_en_GB"."ID" IS NOT NULL))) THEN 1 ELSE 0 END
0.0001s
0068: SELECT "PersonEntry"."ID", "PersonEntry"."Name" AS "_SortColumn0"
FROM "PersonEntry" INNER JOIN "Element_Persons" ON "Element_Persons"."PersonEntryID" = "PersonEntry"."ID" LEFT JOIN "PersonEntry_Localised" AS "PersonEntry_Localised_en_GB" ON "PersonEntry"."ID" = "PersonEntry_Localised_en_GB"."RecordID" AND "PersonEntry_Localised_en_GB"."Locale" = ?
WHERE ("Element_Persons"."ElementID" = ?)
AND (("PersonEntry_Localised_en_GB"."ID" IS NOT NULL))
ORDER BY "_SortColumn0" ASC
0.0001s
0069: SELECT DISTINCT count(DISTINCT "PersonEntry"."ID") AS "Count"
FROM "PersonEntry" INNER JOIN "Element_Persons" ON "Element_Persons"."PersonEntryID" = "PersonEntry"."ID" LEFT JOIN "PersonEntry_Localised" AS "PersonEntry_Localised_en_GB" ON "PersonEntry"."ID" = "PersonEntry_Localised_en_GB"."RecordID" AND "PersonEntry_Localised_en_GB"."Locale" = ?
WHERE ("Element_Persons"."ElementID" = ?)
AND (("PersonEntry_Localised_en_GB"."ID" IS NOT NULL))
0.0001s
0070: SELECT DISTINCT "PersonEntry"."ClassName", "PersonEntry"."LastEdited", "PersonEntry"."Created", "PersonEntry"."SortOrder", CASE
WHEN "PersonEntry_Localised_en_GB"."ID" IS NOT NULL THEN "PersonEntry_Localised_en_GB"."Name"
ELSE "PersonEntry"."Name" END
AS "Name", CASE
WHEN "PersonEntry_Localised_en_GB"."ID" IS NOT NULL THEN "PersonEntry_Localised_en_GB"."Color"
ELSE "PersonEntry"."Color" END
AS "Color", "PersonEntry"."ImageID", "PersonEntry"."ID",
CASE WHEN "PersonEntry"."ClassName" IS NOT NULL THEN "PersonEntry"."ClassName"
ELSE 'App\\Models\\PersonEntry' END AS "RecordClassName", 'en_GB' AS "Locale", CASE WHEN "PersonEntry_Localised_en_GB"."ID" IS NOT NULL THEN 'en_GB'
ELSE NULL END AS "SourceLocale"
FROM "PersonEntry" INNER JOIN "Element_Persons" ON "Element_Persons"."PersonEntryID" = "PersonEntry"."ID" LEFT JOIN "PersonEntry_Localised" AS "PersonEntry_Localised_en_GB" ON "PersonEntry"."ID" = "PersonEntry_Localised_en_GB"."RecordID" AND "PersonEntry_Localised_en_GB"."Locale" = ?
WHERE ("Element_Persons"."ElementID" = ?)
AND (("PersonEntry_Localised_en_GB"."ID" IS NOT NULL))
ORDER BY "Name" ASC
LIMIT 1
0.0002s
0071: SELECT DISTINCT count(DISTINCT "File_Live"."ID") AS "Count"
FROM "File_Live" LEFT JOIN "Image_Live" ON "Image_Live"."ID" = "File_Live"."ID" INNER JOIN "ImageGalleryElement_Images" ON "ImageGalleryElement_Images"."ImageID" = "File_Live"."ID"
WHERE ("ImageGalleryElement_Images"."ImageGalleryElementID" = ?)
AND ("File_Live"."ClassName" IN (?, ?))
0.0001s
0072: SELECT DISTINCT "ImageGalleryElement_Images"."SortOrder", "File_Live"."ClassName", "File_Live"."LastEdited", "File_Live"."Created", CASE WHEN "File_Live"."ClassName" IN ('SilverStripe\\Assets\\File', 'SilverStripe\\Assets\\Folder', 'SilverStripe\\Assets\\Image', 'WeDevelop\\SvgImage\\Assets\\Svg') THEN "File_Live"."Copyright" WHEN "File_Live"."ClassName" IN ('SilverStripe\\Assets\\Image', 'WeDevelop\\SvgImage\\Assets\\Svg') THEN "Image_Live"."Copyright" WHEN "File_Live"."ClassName" IN ('SilverStripe\\Assets\\Image', 'WeDevelop\\SvgImage\\Assets\\Svg') THEN "Image_Live"."Copyright" ELSE NULL END AS "Copyright", CASE WHEN "File_Live"."ClassName" IN ('SilverStripe\\Assets\\File', 'SilverStripe\\Assets\\Folder', 'SilverStripe\\Assets\\Image', 'WeDevelop\\SvgImage\\Assets\\Svg') THEN "File_Live"."Bildunterschrift" WHEN "File_Live"."ClassName" IN ('SilverStripe\\Assets\\Image', 'WeDevelop\\SvgImage\\Assets\\Svg') THEN "Image_Live"."Bildunterschrift" WHEN "File_Live"."ClassName" IN ('SilverStripe\\Assets\\Image', 'WeDevelop\\SvgImage\\Assets\\Svg') THEN "Image_Live"."Bildunterschrift" ELSE NULL END AS "Bildunterschrift", CASE WHEN "File_Live"."ClassName" IN ('SilverStripe\\Assets\\File', 'SilverStripe\\Assets\\Folder', 'SilverStripe\\Assets\\Image', 'WeDevelop\\SvgImage\\Assets\\Svg') THEN "File_Live"."AltText" WHEN "File_Live"."ClassName" IN ('SilverStripe\\Assets\\Image', 'WeDevelop\\SvgImage\\Assets\\Svg') THEN "Image_Live"."AltText" WHEN "File_Live"."ClassName" IN ('SilverStripe\\Assets\\Image', 'WeDevelop\\SvgImage\\Assets\\Svg') THEN "Image_Live"."AltText" ELSE NULL END AS "AltText", "File_Live"."Version", "File_Live"."CanViewType", "File_Live"."CanEditType", "File_Live"."Name", "File_Live"."Title", "File_Live"."ShowInSearch", "File_Live"."ParentID", "File_Live"."OwnerID", "File_Live"."FileHash", "File_Live"."FileFilename", "File_Live"."FileVariant", "Image_Live"."FocusPointX", "Image_Live"."FocusPointY", "Image_Live"."FocusPointWidth", "Image_Live"."FocusPointHeight", "File_Live"."ID",
CASE WHEN "File_Live"."ClassName" IS NOT NULL THEN "File_Live"."ClassName"
ELSE 'SilverStripe\\Assets\\File' END AS "RecordClassName"
FROM "File_Live" LEFT JOIN "Image_Live" ON "Image_Live"."ID" = "File_Live"."ID" INNER JOIN "ImageGalleryElement_Images" ON "ImageGalleryElement_Images"."ImageID" = "File_Live"."ID"
WHERE ("ImageGalleryElement_Images"."ImageGalleryElementID" = ?)
AND ("File_Live"."ClassName" IN (?, ?))
ORDER BY "File_Live"."Name" ASC
0.0003s
0073: SELECT CASE WHEN EXISTS(SELECT *
FROM "PersonEntry" INNER JOIN "Element_Persons" ON "Element_Persons"."PersonEntryID" = "PersonEntry"."ID" LEFT JOIN "PersonEntry_Localised" AS "PersonEntry_Localised_en_GB" ON "PersonEntry"."ID" = "PersonEntry_Localised_en_GB"."RecordID" AND "PersonEntry_Localised_en_GB"."Locale" = ?
WHERE ("Element_Persons"."ElementID" = ?)
AND (("PersonEntry_Localised_en_GB"."ID" IS NOT NULL))) THEN 1 ELSE 0 END
0.0002s
0074: SELECT "PersonEntry"."ID", "PersonEntry"."Name" AS "_SortColumn0"
FROM "PersonEntry" INNER JOIN "Element_Persons" ON "Element_Persons"."PersonEntryID" = "PersonEntry"."ID" LEFT JOIN "PersonEntry_Localised" AS "PersonEntry_Localised_en_GB" ON "PersonEntry"."ID" = "PersonEntry_Localised_en_GB"."RecordID" AND "PersonEntry_Localised_en_GB"."Locale" = ?
WHERE ("Element_Persons"."ElementID" = ?)
AND (("PersonEntry_Localised_en_GB"."ID" IS NOT NULL))
ORDER BY "_SortColumn0" ASC
0.0001s
0075: SELECT DISTINCT count(DISTINCT "PersonEntry"."ID") AS "Count"
FROM "PersonEntry" INNER JOIN "Element_Persons" ON "Element_Persons"."PersonEntryID" = "PersonEntry"."ID" LEFT JOIN "PersonEntry_Localised" AS "PersonEntry_Localised_en_GB" ON "PersonEntry"."ID" = "PersonEntry_Localised_en_GB"."RecordID" AND "PersonEntry_Localised_en_GB"."Locale" = ?
WHERE ("Element_Persons"."ElementID" = ?)
AND (("PersonEntry_Localised_en_GB"."ID" IS NOT NULL))
0.0001s
0076: SELECT DISTINCT "PersonEntry"."ClassName", "PersonEntry"."LastEdited", "PersonEntry"."Created", "PersonEntry"."SortOrder", CASE
WHEN "PersonEntry_Localised_en_GB"."ID" IS NOT NULL THEN "PersonEntry_Localised_en_GB"."Name"
ELSE "PersonEntry"."Name" END
AS "Name", CASE
WHEN "PersonEntry_Localised_en_GB"."ID" IS NOT NULL THEN "PersonEntry_Localised_en_GB"."Color"
ELSE "PersonEntry"."Color" END
AS "Color", "PersonEntry"."ImageID", "PersonEntry"."ID",
CASE WHEN "PersonEntry"."ClassName" IS NOT NULL THEN "PersonEntry"."ClassName"
ELSE 'App\\Models\\PersonEntry' END AS "RecordClassName", 'en_GB' AS "Locale", CASE WHEN "PersonEntry_Localised_en_GB"."ID" IS NOT NULL THEN 'en_GB'
ELSE NULL END AS "SourceLocale"
FROM "PersonEntry" INNER JOIN "Element_Persons" ON "Element_Persons"."PersonEntryID" = "PersonEntry"."ID" LEFT JOIN "PersonEntry_Localised" AS "PersonEntry_Localised_en_GB" ON "PersonEntry"."ID" = "PersonEntry_Localised_en_GB"."RecordID" AND "PersonEntry_Localised_en_GB"."Locale" = ?
WHERE ("Element_Persons"."ElementID" = ?)
AND (("PersonEntry_Localised_en_GB"."ID" IS NOT NULL))
ORDER BY "Name" ASC
LIMIT 1
0.0002s
0077: SELECT DISTINCT "Element_Live"."ClassName", "Element_Live"."LastEdited", "Element_Live"."Created", CASE
WHEN "BetterContent_Localised_en_GB"."ID" IS NOT NULL THEN "BetterContent_Localised_en_GB"."Content"
ELSE "BetterContent_Live"."Content" END
AS "Content", "Element_Live"."ID",
CASE WHEN "Element_Live"."ClassName" IS NOT NULL THEN "Element_Live"."ClassName"
ELSE 'DNADesign\\Elemental\\Models\\BaseElement' END AS "RecordClassName", 'en_GB' AS "Locale", CASE WHEN "BetterContent_Localised_en_GB"."ID" IS NOT NULL THEN 'en_GB'
ELSE NULL END AS "SourceLocale", "Element_Live"."Sort"
FROM "Element_Live" LEFT JOIN "BetterContent_Live" ON "BetterContent_Live"."ID" = "Element_Live"."ID" LEFT JOIN "Element_Localised_Live" AS "Element_Localised_en_GB" ON "Element_Live"."ID" = "Element_Localised_en_GB"."RecordID" AND "Element_Localised_en_GB"."Locale" = ? LEFT JOIN "BetterContent_Localised_Live" AS "BetterContent_Localised_en_GB" ON "BetterContent_Live"."ID" = "BetterContent_Localised_en_GB"."RecordID" AND "BetterContent_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.0002s
0078: SELECT CASE WHEN EXISTS(SELECT *
FROM "PersonEntry" INNER JOIN "Element_Persons" ON "Element_Persons"."PersonEntryID" = "PersonEntry"."ID" LEFT JOIN "PersonEntry_Localised" AS "PersonEntry_Localised_en_GB" ON "PersonEntry"."ID" = "PersonEntry_Localised_en_GB"."RecordID" AND "PersonEntry_Localised_en_GB"."Locale" = ?
WHERE ("Element_Persons"."ElementID" = ?)
AND (("PersonEntry_Localised_en_GB"."ID" IS NOT NULL))) THEN 1 ELSE 0 END
0.0001s
0079: SELECT "PersonEntry"."ID", "PersonEntry"."Name" AS "_SortColumn0"
FROM "PersonEntry" INNER JOIN "Element_Persons" ON "Element_Persons"."PersonEntryID" = "PersonEntry"."ID" LEFT JOIN "PersonEntry_Localised" AS "PersonEntry_Localised_en_GB" ON "PersonEntry"."ID" = "PersonEntry_Localised_en_GB"."RecordID" AND "PersonEntry_Localised_en_GB"."Locale" = ?
WHERE ("Element_Persons"."ElementID" = ?)
AND (("PersonEntry_Localised_en_GB"."ID" IS NOT NULL))
ORDER BY "_SortColumn0" ASC
0.0001s
0080: SELECT DISTINCT count(DISTINCT "PersonEntry"."ID") AS "Count"
FROM "PersonEntry" INNER JOIN "Element_Persons" ON "Element_Persons"."PersonEntryID" = "PersonEntry"."ID" LEFT JOIN "PersonEntry_Localised" AS "PersonEntry_Localised_en_GB" ON "PersonEntry"."ID" = "PersonEntry_Localised_en_GB"."RecordID" AND "PersonEntry_Localised_en_GB"."Locale" = ?
WHERE ("Element_Persons"."ElementID" = ?)
AND (("PersonEntry_Localised_en_GB"."ID" IS NOT NULL))
0.0001s
0081: SELECT DISTINCT "PersonEntry"."ClassName", "PersonEntry"."LastEdited", "PersonEntry"."Created", "PersonEntry"."SortOrder", CASE
WHEN "PersonEntry_Localised_en_GB"."ID" IS NOT NULL THEN "PersonEntry_Localised_en_GB"."Name"
ELSE "PersonEntry"."Name" END
AS "Name", CASE
WHEN "PersonEntry_Localised_en_GB"."ID" IS NOT NULL THEN "PersonEntry_Localised_en_GB"."Color"
ELSE "PersonEntry"."Color" END
AS "Color", "PersonEntry"."ImageID", "PersonEntry"."ID",
CASE WHEN "PersonEntry"."ClassName" IS NOT NULL THEN "PersonEntry"."ClassName"
ELSE 'App\\Models\\PersonEntry' END AS "RecordClassName", 'en_GB' AS "Locale", CASE WHEN "PersonEntry_Localised_en_GB"."ID" IS NOT NULL THEN 'en_GB'
ELSE NULL END AS "SourceLocale"
FROM "PersonEntry" INNER JOIN "Element_Persons" ON "Element_Persons"."PersonEntryID" = "PersonEntry"."ID" LEFT JOIN "PersonEntry_Localised" AS "PersonEntry_Localised_en_GB" ON "PersonEntry"."ID" = "PersonEntry_Localised_en_GB"."RecordID" AND "PersonEntry_Localised_en_GB"."Locale" = ?
WHERE ("Element_Persons"."ElementID" = ?)
AND (("PersonEntry_Localised_en_GB"."ID" IS NOT NULL))
ORDER BY "Name" ASC
LIMIT 1
0.0002s
0082: SELECT DISTINCT count(DISTINCT "File_Live"."ID") AS "Count"
FROM "File_Live" LEFT JOIN "Image_Live" ON "Image_Live"."ID" = "File_Live"."ID" INNER JOIN "ImageGalleryElement_Images" ON "ImageGalleryElement_Images"."ImageID" = "File_Live"."ID"
WHERE ("ImageGalleryElement_Images"."ImageGalleryElementID" = ?)
AND ("File_Live"."ClassName" IN (?, ?))
0.0001s
0083: SELECT DISTINCT "ImageGalleryElement_Images"."SortOrder", "File_Live"."ClassName", "File_Live"."LastEdited", "File_Live"."Created", CASE WHEN "File_Live"."ClassName" IN ('SilverStripe\\Assets\\File', 'SilverStripe\\Assets\\Folder', 'SilverStripe\\Assets\\Image', 'WeDevelop\\SvgImage\\Assets\\Svg') THEN "File_Live"."Copyright" WHEN "File_Live"."ClassName" IN ('SilverStripe\\Assets\\Image', 'WeDevelop\\SvgImage\\Assets\\Svg') THEN "Image_Live"."Copyright" WHEN "File_Live"."ClassName" IN ('SilverStripe\\Assets\\Image', 'WeDevelop\\SvgImage\\Assets\\Svg') THEN "Image_Live"."Copyright" ELSE NULL END AS "Copyright", CASE WHEN "File_Live"."ClassName" IN ('SilverStripe\\Assets\\File', 'SilverStripe\\Assets\\Folder', 'SilverStripe\\Assets\\Image', 'WeDevelop\\SvgImage\\Assets\\Svg') THEN "File_Live"."Bildunterschrift" WHEN "File_Live"."ClassName" IN ('SilverStripe\\Assets\\Image', 'WeDevelop\\SvgImage\\Assets\\Svg') THEN "Image_Live"."Bildunterschrift" WHEN "File_Live"."ClassName" IN ('SilverStripe\\Assets\\Image', 'WeDevelop\\SvgImage\\Assets\\Svg') THEN "Image_Live"."Bildunterschrift" ELSE NULL END AS "Bildunterschrift", CASE WHEN "File_Live"."ClassName" IN ('SilverStripe\\Assets\\File', 'SilverStripe\\Assets\\Folder', 'SilverStripe\\Assets\\Image', 'WeDevelop\\SvgImage\\Assets\\Svg') THEN "File_Live"."AltText" WHEN "File_Live"."ClassName" IN ('SilverStripe\\Assets\\Image', 'WeDevelop\\SvgImage\\Assets\\Svg') THEN "Image_Live"."AltText" WHEN "File_Live"."ClassName" IN ('SilverStripe\\Assets\\Image', 'WeDevelop\\SvgImage\\Assets\\Svg') THEN "Image_Live"."AltText" ELSE NULL END AS "AltText", "File_Live"."Version", "File_Live"."CanViewType", "File_Live"."CanEditType", "File_Live"."Name", "File_Live"."Title", "File_Live"."ShowInSearch", "File_Live"."ParentID", "File_Live"."OwnerID", "File_Live"."FileHash", "File_Live"."FileFilename", "File_Live"."FileVariant", "Image_Live"."FocusPointX", "Image_Live"."FocusPointY", "Image_Live"."FocusPointWidth", "Image_Live"."FocusPointHeight", "File_Live"."ID",
CASE WHEN "File_Live"."ClassName" IS NOT NULL THEN "File_Live"."ClassName"
ELSE 'SilverStripe\\Assets\\File' END AS "RecordClassName"
FROM "File_Live" LEFT JOIN "Image_Live" ON "Image_Live"."ID" = "File_Live"."ID" INNER JOIN "ImageGalleryElement_Images" ON "ImageGalleryElement_Images"."ImageID" = "File_Live"."ID"
WHERE ("ImageGalleryElement_Images"."ImageGalleryElementID" = ?)
AND ("File_Live"."ClassName" IN (?, ?))
ORDER BY "File_Live"."Name" ASC
0.0003s
0084: SELECT CASE WHEN EXISTS(SELECT *
FROM "PersonEntry" INNER JOIN "Element_Persons" ON "Element_Persons"."PersonEntryID" = "PersonEntry"."ID" LEFT JOIN "PersonEntry_Localised" AS "PersonEntry_Localised_en_GB" ON "PersonEntry"."ID" = "PersonEntry_Localised_en_GB"."RecordID" AND "PersonEntry_Localised_en_GB"."Locale" = ?
WHERE ("Element_Persons"."ElementID" = ?)
AND (("PersonEntry_Localised_en_GB"."ID" IS NOT NULL))) THEN 1 ELSE 0 END
0.0002s
0085: SELECT "PersonEntry"."ID", "PersonEntry"."Name" AS "_SortColumn0"
FROM "PersonEntry" INNER JOIN "Element_Persons" ON "Element_Persons"."PersonEntryID" = "PersonEntry"."ID" LEFT JOIN "PersonEntry_Localised" AS "PersonEntry_Localised_en_GB" ON "PersonEntry"."ID" = "PersonEntry_Localised_en_GB"."RecordID" AND "PersonEntry_Localised_en_GB"."Locale" = ?
WHERE ("Element_Persons"."ElementID" = ?)
AND (("PersonEntry_Localised_en_GB"."ID" IS NOT NULL))
ORDER BY "_SortColumn0" ASC
0.0001s
0086: SELECT DISTINCT count(DISTINCT "PersonEntry"."ID") AS "Count"
FROM "PersonEntry" INNER JOIN "Element_Persons" ON "Element_Persons"."PersonEntryID" = "PersonEntry"."ID" LEFT JOIN "PersonEntry_Localised" AS "PersonEntry_Localised_en_GB" ON "PersonEntry"."ID" = "PersonEntry_Localised_en_GB"."RecordID" AND "PersonEntry_Localised_en_GB"."Locale" = ?
WHERE ("Element_Persons"."ElementID" = ?)
AND (("PersonEntry_Localised_en_GB"."ID" IS NOT NULL))
0.0001s
0087: SELECT DISTINCT "PersonEntry"."ClassName", "PersonEntry"."LastEdited", "PersonEntry"."Created", "PersonEntry"."SortOrder", CASE
WHEN "PersonEntry_Localised_en_GB"."ID" IS NOT NULL THEN "PersonEntry_Localised_en_GB"."Name"
ELSE "PersonEntry"."Name" END
AS "Name", CASE
WHEN "PersonEntry_Localised_en_GB"."ID" IS NOT NULL THEN "PersonEntry_Localised_en_GB"."Color"
ELSE "PersonEntry"."Color" END
AS "Color", "PersonEntry"."ImageID", "PersonEntry"."ID",
CASE WHEN "PersonEntry"."ClassName" IS NOT NULL THEN "PersonEntry"."ClassName"
ELSE 'App\\Models\\PersonEntry' END AS "RecordClassName", 'en_GB' AS "Locale", CASE WHEN "PersonEntry_Localised_en_GB"."ID" IS NOT NULL THEN 'en_GB'
ELSE NULL END AS "SourceLocale"
FROM "PersonEntry" INNER JOIN "Element_Persons" ON "Element_Persons"."PersonEntryID" = "PersonEntry"."ID" LEFT JOIN "PersonEntry_Localised" AS "PersonEntry_Localised_en_GB" ON "PersonEntry"."ID" = "PersonEntry_Localised_en_GB"."RecordID" AND "PersonEntry_Localised_en_GB"."Locale" = ?
WHERE ("Element_Persons"."ElementID" = ?)
AND (("PersonEntry_Localised_en_GB"."ID" IS NOT NULL))
ORDER BY "Name" ASC
LIMIT 1
0.0002s
0088: SELECT DISTINCT "Element_Live"."ClassName", "Element_Live"."LastEdited", "Element_Live"."Created", CASE
WHEN "BetterContent_Localised_en_GB"."ID" IS NOT NULL THEN "BetterContent_Localised_en_GB"."Content"
ELSE "BetterContent_Live"."Content" END
AS "Content", "Element_Live"."ID",
CASE WHEN "Element_Live"."ClassName" IS NOT NULL THEN "Element_Live"."ClassName"
ELSE 'DNADesign\\Elemental\\Models\\BaseElement' END AS "RecordClassName", 'en_GB' AS "Locale", CASE WHEN "BetterContent_Localised_en_GB"."ID" IS NOT NULL THEN 'en_GB'
ELSE NULL END AS "SourceLocale", "Element_Live"."Sort"
FROM "Element_Live" LEFT JOIN "BetterContent_Live" ON "BetterContent_Live"."ID" = "Element_Live"."ID" LEFT JOIN "Element_Localised_Live" AS "Element_Localised_en_GB" ON "Element_Live"."ID" = "Element_Localised_en_GB"."RecordID" AND "Element_Localised_en_GB"."Locale" = ? LEFT JOIN "BetterContent_Localised_Live" AS "BetterContent_Localised_en_GB" ON "BetterContent_Live"."ID" = "BetterContent_Localised_en_GB"."RecordID" AND "BetterContent_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.0002s
0089: SELECT CASE WHEN EXISTS(SELECT *
FROM "PersonEntry" INNER JOIN "Element_Persons" ON "Element_Persons"."PersonEntryID" = "PersonEntry"."ID" LEFT JOIN "PersonEntry_Localised" AS "PersonEntry_Localised_en_GB" ON "PersonEntry"."ID" = "PersonEntry_Localised_en_GB"."RecordID" AND "PersonEntry_Localised_en_GB"."Locale" = ?
WHERE ("Element_Persons"."ElementID" = ?)
AND (("PersonEntry_Localised_en_GB"."ID" IS NOT NULL))) THEN 1 ELSE 0 END
0.0001s
0090: SELECT "PersonEntry"."ID", "PersonEntry"."Name" AS "_SortColumn0"
FROM "PersonEntry" INNER JOIN "Element_Persons" ON "Element_Persons"."PersonEntryID" = "PersonEntry"."ID" LEFT JOIN "PersonEntry_Localised" AS "PersonEntry_Localised_en_GB" ON "PersonEntry"."ID" = "PersonEntry_Localised_en_GB"."RecordID" AND "PersonEntry_Localised_en_GB"."Locale" = ?
WHERE ("Element_Persons"."ElementID" = ?)
AND (("PersonEntry_Localised_en_GB"."ID" IS NOT NULL))
ORDER BY "_SortColumn0" ASC
0.0001s
0091: SELECT DISTINCT count(DISTINCT "PersonEntry"."ID") AS "Count"
FROM "PersonEntry" INNER JOIN "Element_Persons" ON "Element_Persons"."PersonEntryID" = "PersonEntry"."ID" LEFT JOIN "PersonEntry_Localised" AS "PersonEntry_Localised_en_GB" ON "PersonEntry"."ID" = "PersonEntry_Localised_en_GB"."RecordID" AND "PersonEntry_Localised_en_GB"."Locale" = ?
WHERE ("Element_Persons"."ElementID" = ?)
AND (("PersonEntry_Localised_en_GB"."ID" IS NOT NULL))
0.0001s
0092: SELECT DISTINCT "PersonEntry"."ClassName", "PersonEntry"."LastEdited", "PersonEntry"."Created", "PersonEntry"."SortOrder", CASE
WHEN "PersonEntry_Localised_en_GB"."ID" IS NOT NULL THEN "PersonEntry_Localised_en_GB"."Name"
ELSE "PersonEntry"."Name" END
AS "Name", CASE
WHEN "PersonEntry_Localised_en_GB"."ID" IS NOT NULL THEN "PersonEntry_Localised_en_GB"."Color"
ELSE "PersonEntry"."Color" END
AS "Color", "PersonEntry"."ImageID", "PersonEntry"."ID",
CASE WHEN "PersonEntry"."ClassName" IS NOT NULL THEN "PersonEntry"."ClassName"
ELSE 'App\\Models\\PersonEntry' END AS "RecordClassName", 'en_GB' AS "Locale", CASE WHEN "PersonEntry_Localised_en_GB"."ID" IS NOT NULL THEN 'en_GB'
ELSE NULL END AS "SourceLocale"
FROM "PersonEntry" INNER JOIN "Element_Persons" ON "Element_Persons"."PersonEntryID" = "PersonEntry"."ID" LEFT JOIN "PersonEntry_Localised" AS "PersonEntry_Localised_en_GB" ON "PersonEntry"."ID" = "PersonEntry_Localised_en_GB"."RecordID" AND "PersonEntry_Localised_en_GB"."Locale" = ?
WHERE ("Element_Persons"."ElementID" = ?)
AND (("PersonEntry_Localised_en_GB"."ID" IS NOT NULL))
ORDER BY "Name" ASC
LIMIT 1
0.0002s
0093: SELECT DISTINCT count(DISTINCT "File_Live"."ID") AS "Count"
FROM "File_Live" LEFT JOIN "Image_Live" ON "Image_Live"."ID" = "File_Live"."ID" INNER JOIN "ImageGalleryElement_Images" ON "ImageGalleryElement_Images"."ImageID" = "File_Live"."ID"
WHERE ("ImageGalleryElement_Images"."ImageGalleryElementID" = ?)
AND ("File_Live"."ClassName" IN (?, ?))
0.0002s
0094: SELECT DISTINCT "ImageGalleryElement_Images"."SortOrder", "File_Live"."ClassName", "File_Live"."LastEdited", "File_Live"."Created", CASE WHEN "File_Live"."ClassName" IN ('SilverStripe\\Assets\\File', 'SilverStripe\\Assets\\Folder', 'SilverStripe\\Assets\\Image', 'WeDevelop\\SvgImage\\Assets\\Svg') THEN "File_Live"."Copyright" WHEN "File_Live"."ClassName" IN ('SilverStripe\\Assets\\Image', 'WeDevelop\\SvgImage\\Assets\\Svg') THEN "Image_Live"."Copyright" WHEN "File_Live"."ClassName" IN ('SilverStripe\\Assets\\Image', 'WeDevelop\\SvgImage\\Assets\\Svg') THEN "Image_Live"."Copyright" ELSE NULL END AS "Copyright", CASE WHEN "File_Live"."ClassName" IN ('SilverStripe\\Assets\\File', 'SilverStripe\\Assets\\Folder', 'SilverStripe\\Assets\\Image', 'WeDevelop\\SvgImage\\Assets\\Svg') THEN "File_Live"."Bildunterschrift" WHEN "File_Live"."ClassName" IN ('SilverStripe\\Assets\\Image', 'WeDevelop\\SvgImage\\Assets\\Svg') THEN "Image_Live"."Bildunterschrift" WHEN "File_Live"."ClassName" IN ('SilverStripe\\Assets\\Image', 'WeDevelop\\SvgImage\\Assets\\Svg') THEN "Image_Live"."Bildunterschrift" ELSE NULL END AS "Bildunterschrift", CASE WHEN "File_Live"."ClassName" IN ('SilverStripe\\Assets\\File', 'SilverStripe\\Assets\\Folder', 'SilverStripe\\Assets\\Image', 'WeDevelop\\SvgImage\\Assets\\Svg') THEN "File_Live"."AltText" WHEN "File_Live"."ClassName" IN ('SilverStripe\\Assets\\Image', 'WeDevelop\\SvgImage\\Assets\\Svg') THEN "Image_Live"."AltText" WHEN "File_Live"."ClassName" IN ('SilverStripe\\Assets\\Image', 'WeDevelop\\SvgImage\\Assets\\Svg') THEN "Image_Live"."AltText" ELSE NULL END AS "AltText", "File_Live"."Version", "File_Live"."CanViewType", "File_Live"."CanEditType", "File_Live"."Name", "File_Live"."Title", "File_Live"."ShowInSearch", "File_Live"."ParentID", "File_Live"."OwnerID", "File_Live"."FileHash", "File_Live"."FileFilename", "File_Live"."FileVariant", "Image_Live"."FocusPointX", "Image_Live"."FocusPointY", "Image_Live"."FocusPointWidth", "Image_Live"."FocusPointHeight", "File_Live"."ID",
CASE WHEN "File_Live"."ClassName" IS NOT NULL THEN "File_Live"."ClassName"
ELSE 'SilverStripe\\Assets\\File' END AS "RecordClassName"
FROM "File_Live" LEFT JOIN "Image_Live" ON "Image_Live"."ID" = "File_Live"."ID" INNER JOIN "ImageGalleryElement_Images" ON "ImageGalleryElement_Images"."ImageID" = "File_Live"."ID"
WHERE ("ImageGalleryElement_Images"."ImageGalleryElementID" = ?)
AND ("File_Live"."ClassName" IN (?, ?))
ORDER BY "File_Live"."Name" ASC
0.0002s
0095: SELECT CASE WHEN EXISTS(SELECT *
FROM "PersonEntry" INNER JOIN "Element_Persons" ON "Element_Persons"."PersonEntryID" = "PersonEntry"."ID" LEFT JOIN "PersonEntry_Localised" AS "PersonEntry_Localised_en_GB" ON "PersonEntry"."ID" = "PersonEntry_Localised_en_GB"."RecordID" AND "PersonEntry_Localised_en_GB"."Locale" = ?
WHERE ("Element_Persons"."ElementID" = ?)
AND (("PersonEntry_Localised_en_GB"."ID" IS NOT NULL))) THEN 1 ELSE 0 END
0.0002s
0096: SELECT "PersonEntry"."ID", "PersonEntry"."Name" AS "_SortColumn0"
FROM "PersonEntry" INNER JOIN "Element_Persons" ON "Element_Persons"."PersonEntryID" = "PersonEntry"."ID" LEFT JOIN "PersonEntry_Localised" AS "PersonEntry_Localised_en_GB" ON "PersonEntry"."ID" = "PersonEntry_Localised_en_GB"."RecordID" AND "PersonEntry_Localised_en_GB"."Locale" = ?
WHERE ("Element_Persons"."ElementID" = ?)
AND (("PersonEntry_Localised_en_GB"."ID" IS NOT NULL))
ORDER BY "_SortColumn0" ASC
0.0001s
0097: SELECT DISTINCT count(DISTINCT "PersonEntry"."ID") AS "Count"
FROM "PersonEntry" INNER JOIN "Element_Persons" ON "Element_Persons"."PersonEntryID" = "PersonEntry"."ID" LEFT JOIN "PersonEntry_Localised" AS "PersonEntry_Localised_en_GB" ON "PersonEntry"."ID" = "PersonEntry_Localised_en_GB"."RecordID" AND "PersonEntry_Localised_en_GB"."Locale" = ?
WHERE ("Element_Persons"."ElementID" = ?)
AND (("PersonEntry_Localised_en_GB"."ID" IS NOT NULL))
0.0001s
0098: SELECT DISTINCT "PersonEntry"."ClassName", "PersonEntry"."LastEdited", "PersonEntry"."Created", "PersonEntry"."SortOrder", CASE
WHEN "PersonEntry_Localised_en_GB"."ID" IS NOT NULL THEN "PersonEntry_Localised_en_GB"."Name"
ELSE "PersonEntry"."Name" END
AS "Name", CASE
WHEN "PersonEntry_Localised_en_GB"."ID" IS NOT NULL THEN "PersonEntry_Localised_en_GB"."Color"
ELSE "PersonEntry"."Color" END
AS "Color", "PersonEntry"."ImageID", "PersonEntry"."ID",
CASE WHEN "PersonEntry"."ClassName" IS NOT NULL THEN "PersonEntry"."ClassName"
ELSE 'App\\Models\\PersonEntry' END AS "RecordClassName", 'en_GB' AS "Locale", CASE WHEN "PersonEntry_Localised_en_GB"."ID" IS NOT NULL THEN 'en_GB'
ELSE NULL END AS "SourceLocale"
FROM "PersonEntry" INNER JOIN "Element_Persons" ON "Element_Persons"."PersonEntryID" = "PersonEntry"."ID" LEFT JOIN "PersonEntry_Localised" AS "PersonEntry_Localised_en_GB" ON "PersonEntry"."ID" = "PersonEntry_Localised_en_GB"."RecordID" AND "PersonEntry_Localised_en_GB"."Locale" = ?
WHERE ("Element_Persons"."ElementID" = ?)
AND (("PersonEntry_Localised_en_GB"."ID" IS NOT NULL))
ORDER BY "Name" ASC
LIMIT 1
0.0002s
0099: SELECT DISTINCT count(DISTINCT "File_Live"."ID") AS "Count"
FROM "File_Live" LEFT JOIN "Image_Live" ON "Image_Live"."ID" = "File_Live"."ID" INNER JOIN "ImageGalleryElement_Images" ON "ImageGalleryElement_Images"."ImageID" = "File_Live"."ID"
WHERE ("ImageGalleryElement_Images"."ImageGalleryElementID" = ?)
AND ("File_Live"."ClassName" IN (?, ?))
0.0002s
0100: SELECT DISTINCT "ImageGalleryElement_Images"."SortOrder", "File_Live"."ClassName", "File_Live"."LastEdited", "File_Live"."Created", CASE WHEN "File_Live"."ClassName" IN ('SilverStripe\\Assets\\File', 'SilverStripe\\Assets\\Folder', 'SilverStripe\\Assets\\Image', 'WeDevelop\\SvgImage\\Assets\\Svg') THEN "File_Live"."Copyright" WHEN "File_Live"."ClassName" IN ('SilverStripe\\Assets\\Image', 'WeDevelop\\SvgImage\\Assets\\Svg') THEN "Image_Live"."Copyright" WHEN "File_Live"."ClassName" IN ('SilverStripe\\Assets\\Image', 'WeDevelop\\SvgImage\\Assets\\Svg') THEN "Image_Live"."Copyright" ELSE NULL END AS "Copyright", CASE WHEN "File_Live"."ClassName" IN ('SilverStripe\\Assets\\File', 'SilverStripe\\Assets\\Folder', 'SilverStripe\\Assets\\Image', 'WeDevelop\\SvgImage\\Assets\\Svg') THEN "File_Live"."Bildunterschrift" WHEN "File_Live"."ClassName" IN ('SilverStripe\\Assets\\Image', 'WeDevelop\\SvgImage\\Assets\\Svg') THEN "Image_Live"."Bildunterschrift" WHEN "File_Live"."ClassName" IN ('SilverStripe\\Assets\\Image', 'WeDevelop\\SvgImage\\Assets\\Svg') THEN "Image_Live"."Bildunterschrift" ELSE NULL END AS "Bildunterschrift", CASE WHEN "File_Live"."ClassName" IN ('SilverStripe\\Assets\\File', 'SilverStripe\\Assets\\Folder', 'SilverStripe\\Assets\\Image', 'WeDevelop\\SvgImage\\Assets\\Svg') THEN "File_Live"."AltText" WHEN "File_Live"."ClassName" IN ('SilverStripe\\Assets\\Image', 'WeDevelop\\SvgImage\\Assets\\Svg') THEN "Image_Live"."AltText" WHEN "File_Live"."ClassName" IN ('SilverStripe\\Assets\\Image', 'WeDevelop\\SvgImage\\Assets\\Svg') THEN "Image_Live"."AltText" ELSE NULL END AS "AltText", "File_Live"."Version", "File_Live"."CanViewType", "File_Live"."CanEditType", "File_Live"."Name", "File_Live"."Title", "File_Live"."ShowInSearch", "File_Live"."ParentID", "File_Live"."OwnerID", "File_Live"."FileHash", "File_Live"."FileFilename", "File_Live"."FileVariant", "Image_Live"."FocusPointX", "Image_Live"."FocusPointY", "Image_Live"."FocusPointWidth", "Image_Live"."FocusPointHeight", "File_Live"."ID",
CASE WHEN "File_Live"."ClassName" IS NOT NULL THEN "File_Live"."ClassName"
ELSE 'SilverStripe\\Assets\\File' END AS "RecordClassName"
FROM "File_Live" LEFT JOIN "Image_Live" ON "Image_Live"."ID" = "File_Live"."ID" INNER JOIN "ImageGalleryElement_Images" ON "ImageGalleryElement_Images"."ImageID" = "File_Live"."ID"
WHERE ("ImageGalleryElement_Images"."ImageGalleryElementID" = ?)
AND ("File_Live"."ClassName" IN (?, ?))
ORDER BY "File_Live"."Name" ASC
0.0003s
0101: SELECT CASE WHEN EXISTS(SELECT *
FROM "PersonEntry" INNER JOIN "Element_Persons" ON "Element_Persons"."PersonEntryID" = "PersonEntry"."ID" LEFT JOIN "PersonEntry_Localised" AS "PersonEntry_Localised_en_GB" ON "PersonEntry"."ID" = "PersonEntry_Localised_en_GB"."RecordID" AND "PersonEntry_Localised_en_GB"."Locale" = ?
WHERE ("Element_Persons"."ElementID" = ?)
AND (("PersonEntry_Localised_en_GB"."ID" IS NOT NULL))) THEN 1 ELSE 0 END
0.0002s
0102: SELECT "PersonEntry"."ID", "PersonEntry"."Name" AS "_SortColumn0"
FROM "PersonEntry" INNER JOIN "Element_Persons" ON "Element_Persons"."PersonEntryID" = "PersonEntry"."ID" LEFT JOIN "PersonEntry_Localised" AS "PersonEntry_Localised_en_GB" ON "PersonEntry"."ID" = "PersonEntry_Localised_en_GB"."RecordID" AND "PersonEntry_Localised_en_GB"."Locale" = ?
WHERE ("Element_Persons"."ElementID" = ?)
AND (("PersonEntry_Localised_en_GB"."ID" IS NOT NULL))
ORDER BY "_SortColumn0" ASC
0.0001s
0103: SELECT DISTINCT count(DISTINCT "PersonEntry"."ID") AS "Count"
FROM "PersonEntry" INNER JOIN "Element_Persons" ON "Element_Persons"."PersonEntryID" = "PersonEntry"."ID" LEFT JOIN "PersonEntry_Localised" AS "PersonEntry_Localised_en_GB" ON "PersonEntry"."ID" = "PersonEntry_Localised_en_GB"."RecordID" AND "PersonEntry_Localised_en_GB"."Locale" = ?
WHERE ("Element_Persons"."ElementID" = ?)
AND (("PersonEntry_Localised_en_GB"."ID" IS NOT NULL))
0.0001s
0104: SELECT DISTINCT "PersonEntry"."ClassName", "PersonEntry"."LastEdited", "PersonEntry"."Created", "PersonEntry"."SortOrder", CASE
WHEN "PersonEntry_Localised_en_GB"."ID" IS NOT NULL THEN "PersonEntry_Localised_en_GB"."Name"
ELSE "PersonEntry"."Name" END
AS "Name", CASE
WHEN "PersonEntry_Localised_en_GB"."ID" IS NOT NULL THEN "PersonEntry_Localised_en_GB"."Color"
ELSE "PersonEntry"."Color" END
AS "Color", "PersonEntry"."ImageID", "PersonEntry"."ID",
CASE WHEN "PersonEntry"."ClassName" IS NOT NULL THEN "PersonEntry"."ClassName"
ELSE 'App\\Models\\PersonEntry' END AS "RecordClassName", 'en_GB' AS "Locale", CASE WHEN "PersonEntry_Localised_en_GB"."ID" IS NOT NULL THEN 'en_GB'
ELSE NULL END AS "SourceLocale"
FROM "PersonEntry" INNER JOIN "Element_Persons" ON "Element_Persons"."PersonEntryID" = "PersonEntry"."ID" LEFT JOIN "PersonEntry_Localised" AS "PersonEntry_Localised_en_GB" ON "PersonEntry"."ID" = "PersonEntry_Localised_en_GB"."RecordID" AND "PersonEntry_Localised_en_GB"."Locale" = ?
WHERE ("Element_Persons"."ElementID" = ?)
AND (("PersonEntry_Localised_en_GB"."ID" IS NOT NULL))
ORDER BY "Name" ASC
LIMIT 1
0.0002s
0105: SELECT DISTINCT "Element_Live"."ClassName", "Element_Live"."LastEdited", "Element_Live"."Created", CASE
WHEN "BetterContent_Localised_en_GB"."ID" IS NOT NULL THEN "BetterContent_Localised_en_GB"."Content"
ELSE "BetterContent_Live"."Content" END
AS "Content", "Element_Live"."ID",
CASE WHEN "Element_Live"."ClassName" IS NOT NULL THEN "Element_Live"."ClassName"
ELSE 'DNADesign\\Elemental\\Models\\BaseElement' END AS "RecordClassName", 'en_GB' AS "Locale", CASE WHEN "BetterContent_Localised_en_GB"."ID" IS NOT NULL THEN 'en_GB'
ELSE NULL END AS "SourceLocale", "Element_Live"."Sort"
FROM "Element_Live" LEFT JOIN "BetterContent_Live" ON "BetterContent_Live"."ID" = "Element_Live"."ID" LEFT JOIN "Element_Localised_Live" AS "Element_Localised_en_GB" ON "Element_Live"."ID" = "Element_Localised_en_GB"."RecordID" AND "Element_Localised_en_GB"."Locale" = ? LEFT JOIN "BetterContent_Localised_Live" AS "BetterContent_Localised_en_GB" ON "BetterContent_Live"."ID" = "BetterContent_Localised_en_GB"."RecordID" AND "BetterContent_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.0002s
0106: SELECT CASE WHEN EXISTS(SELECT *
FROM "PersonEntry" INNER JOIN "Element_Persons" ON "Element_Persons"."PersonEntryID" = "PersonEntry"."ID" LEFT JOIN "PersonEntry_Localised" AS "PersonEntry_Localised_en_GB" ON "PersonEntry"."ID" = "PersonEntry_Localised_en_GB"."RecordID" AND "PersonEntry_Localised_en_GB"."Locale" = ?
WHERE ("Element_Persons"."ElementID" = ?)
AND (("PersonEntry_Localised_en_GB"."ID" IS NOT NULL))) THEN 1 ELSE 0 END
0.0001s
0107: SELECT "PersonEntry"."ID", "PersonEntry"."Name" AS "_SortColumn0"
FROM "PersonEntry" INNER JOIN "Element_Persons" ON "Element_Persons"."PersonEntryID" = "PersonEntry"."ID" LEFT JOIN "PersonEntry_Localised" AS "PersonEntry_Localised_en_GB" ON "PersonEntry"."ID" = "PersonEntry_Localised_en_GB"."RecordID" AND "PersonEntry_Localised_en_GB"."Locale" = ?
WHERE ("Element_Persons"."ElementID" = ?)
AND (("PersonEntry_Localised_en_GB"."ID" IS NOT NULL))
ORDER BY "_SortColumn0" ASC
0.0001s
0108: SELECT DISTINCT count(DISTINCT "PersonEntry"."ID") AS "Count"
FROM "PersonEntry" INNER JOIN "Element_Persons" ON "Element_Persons"."PersonEntryID" = "PersonEntry"."ID" LEFT JOIN "PersonEntry_Localised" AS "PersonEntry_Localised_en_GB" ON "PersonEntry"."ID" = "PersonEntry_Localised_en_GB"."RecordID" AND "PersonEntry_Localised_en_GB"."Locale" = ?
WHERE ("Element_Persons"."ElementID" = ?)
AND (("PersonEntry_Localised_en_GB"."ID" IS NOT NULL))
0.0001s
0109: SELECT DISTINCT "PersonEntry"."ClassName", "PersonEntry"."LastEdited", "PersonEntry"."Created", "PersonEntry"."SortOrder", CASE
WHEN "PersonEntry_Localised_en_GB"."ID" IS NOT NULL THEN "PersonEntry_Localised_en_GB"."Name"
ELSE "PersonEntry"."Name" END
AS "Name", CASE
WHEN "PersonEntry_Localised_en_GB"."ID" IS NOT NULL THEN "PersonEntry_Localised_en_GB"."Color"
ELSE "PersonEntry"."Color" END
AS "Color", "PersonEntry"."ImageID", "PersonEntry"."ID",
CASE WHEN "PersonEntry"."ClassName" IS NOT NULL THEN "PersonEntry"."ClassName"
ELSE 'App\\Models\\PersonEntry' END AS "RecordClassName", 'en_GB' AS "Locale", CASE WHEN "PersonEntry_Localised_en_GB"."ID" IS NOT NULL THEN 'en_GB'
ELSE NULL END AS "SourceLocale"
FROM "PersonEntry" INNER JOIN "Element_Persons" ON "Element_Persons"."PersonEntryID" = "PersonEntry"."ID" LEFT JOIN "PersonEntry_Localised" AS "PersonEntry_Localised_en_GB" ON "PersonEntry"."ID" = "PersonEntry_Localised_en_GB"."RecordID" AND "PersonEntry_Localised_en_GB"."Locale" = ?
WHERE ("Element_Persons"."ElementID" = ?)
AND (("PersonEntry_Localised_en_GB"."ID" IS NOT NULL))
ORDER BY "Name" ASC
LIMIT 1
0.0002s
0110: SELECT DISTINCT count(DISTINCT "File_Live"."ID") AS "Count"
FROM "File_Live" LEFT JOIN "Image_Live" ON "Image_Live"."ID" = "File_Live"."ID" INNER JOIN "ImageGalleryElement_Images" ON "ImageGalleryElement_Images"."ImageID" = "File_Live"."ID"
WHERE ("ImageGalleryElement_Images"."ImageGalleryElementID" = ?)
AND ("File_Live"."ClassName" IN (?, ?))
0.0001s
0111: SELECT DISTINCT "ImageGalleryElement_Images"."SortOrder", "File_Live"."ClassName", "File_Live"."LastEdited", "File_Live"."Created", CASE WHEN "File_Live"."ClassName" IN ('SilverStripe\\Assets\\File', 'SilverStripe\\Assets\\Folder', 'SilverStripe\\Assets\\Image', 'WeDevelop\\SvgImage\\Assets\\Svg') THEN "File_Live"."Copyright" WHEN "File_Live"."ClassName" IN ('SilverStripe\\Assets\\Image', 'WeDevelop\\SvgImage\\Assets\\Svg') THEN "Image_Live"."Copyright" WHEN "File_Live"."ClassName" IN ('SilverStripe\\Assets\\Image', 'WeDevelop\\SvgImage\\Assets\\Svg') THEN "Image_Live"."Copyright" ELSE NULL END AS "Copyright", CASE WHEN "File_Live"."ClassName" IN ('SilverStripe\\Assets\\File', 'SilverStripe\\Assets\\Folder', 'SilverStripe\\Assets\\Image', 'WeDevelop\\SvgImage\\Assets\\Svg') THEN "File_Live"."Bildunterschrift" WHEN "File_Live"."ClassName" IN ('SilverStripe\\Assets\\Image', 'WeDevelop\\SvgImage\\Assets\\Svg') THEN "Image_Live"."Bildunterschrift" WHEN "File_Live"."ClassName" IN ('SilverStripe\\Assets\\Image', 'WeDevelop\\SvgImage\\Assets\\Svg') THEN "Image_Live"."Bildunterschrift" ELSE NULL END AS "Bildunterschrift", CASE WHEN "File_Live"."ClassName" IN ('SilverStripe\\Assets\\File', 'SilverStripe\\Assets\\Folder', 'SilverStripe\\Assets\\Image', 'WeDevelop\\SvgImage\\Assets\\Svg') THEN "File_Live"."AltText" WHEN "File_Live"."ClassName" IN ('SilverStripe\\Assets\\Image', 'WeDevelop\\SvgImage\\Assets\\Svg') THEN "Image_Live"."AltText" WHEN "File_Live"."ClassName" IN ('SilverStripe\\Assets\\Image', 'WeDevelop\\SvgImage\\Assets\\Svg') THEN "Image_Live"."AltText" ELSE NULL END AS "AltText", "File_Live"."Version", "File_Live"."CanViewType", "File_Live"."CanEditType", "File_Live"."Name", "File_Live"."Title", "File_Live"."ShowInSearch", "File_Live"."ParentID", "File_Live"."OwnerID", "File_Live"."FileHash", "File_Live"."FileFilename", "File_Live"."FileVariant", "Image_Live"."FocusPointX", "Image_Live"."FocusPointY", "Image_Live"."FocusPointWidth", "Image_Live"."FocusPointHeight", "File_Live"."ID",
CASE WHEN "File_Live"."ClassName" IS NOT NULL THEN "File_Live"."ClassName"
ELSE 'SilverStripe\\Assets\\File' END AS "RecordClassName"
FROM "File_Live" LEFT JOIN "Image_Live" ON "Image_Live"."ID" = "File_Live"."ID" INNER JOIN "ImageGalleryElement_Images" ON "ImageGalleryElement_Images"."ImageID" = "File_Live"."ID"
WHERE ("ImageGalleryElement_Images"."ImageGalleryElementID" = ?)
AND ("File_Live"."ClassName" IN (?, ?))
ORDER BY "File_Live"."Name" ASC
0.0003s
0112: SELECT CASE WHEN EXISTS(SELECT *
FROM "PersonEntry" INNER JOIN "Element_Persons" ON "Element_Persons"."PersonEntryID" = "PersonEntry"."ID" LEFT JOIN "PersonEntry_Localised" AS "PersonEntry_Localised_en_GB" ON "PersonEntry"."ID" = "PersonEntry_Localised_en_GB"."RecordID" AND "PersonEntry_Localised_en_GB"."Locale" = ?
WHERE ("Element_Persons"."ElementID" = ?)
AND (("PersonEntry_Localised_en_GB"."ID" IS NOT NULL))) THEN 1 ELSE 0 END
0.0002s
0113: SELECT DISTINCT count(DISTINCT "PersonEntry"."ID") AS "Count"
FROM "PersonEntry" INNER JOIN "Element_Persons" ON "Element_Persons"."PersonEntryID" = "PersonEntry"."ID" LEFT JOIN "PersonEntry_Localised" AS "PersonEntry_Localised_en_GB" ON "PersonEntry"."ID" = "PersonEntry_Localised_en_GB"."RecordID" AND "PersonEntry_Localised_en_GB"."Locale" = ?
WHERE ("Element_Persons"."ElementID" = ?)
AND (("PersonEntry_Localised_en_GB"."ID" IS NOT NULL))
0.0001s
0114: SELECT DISTINCT "Element_Live"."ClassName", "Element_Live"."LastEdited", "Element_Live"."Created", CASE
WHEN "BetterContent_Localised_en_GB"."ID" IS NOT NULL THEN "BetterContent_Localised_en_GB"."Content"
ELSE "BetterContent_Live"."Content" END
AS "Content", "Element_Live"."ID",
CASE WHEN "Element_Live"."ClassName" IS NOT NULL THEN "Element_Live"."ClassName"
ELSE 'DNADesign\\Elemental\\Models\\BaseElement' END AS "RecordClassName", 'en_GB' AS "Locale", CASE WHEN "BetterContent_Localised_en_GB"."ID" IS NOT NULL THEN 'en_GB'
ELSE NULL END AS "SourceLocale", "Element_Live"."Sort"
FROM "Element_Live" LEFT JOIN "BetterContent_Live" ON "BetterContent_Live"."ID" = "Element_Live"."ID" LEFT JOIN "Element_Localised_Live" AS "Element_Localised_en_GB" ON "Element_Live"."ID" = "Element_Localised_en_GB"."RecordID" AND "Element_Localised_en_GB"."Locale" = ? LEFT JOIN "BetterContent_Localised_Live" AS "BetterContent_Localised_en_GB" ON "BetterContent_Live"."ID" = "BetterContent_Localised_en_GB"."RecordID" AND "BetterContent_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.0002s
0115: SELECT CASE WHEN EXISTS(SELECT *
FROM "PersonEntry" INNER JOIN "Element_Persons" ON "Element_Persons"."PersonEntryID" = "PersonEntry"."ID" LEFT JOIN "PersonEntry_Localised" AS "PersonEntry_Localised_en_GB" ON "PersonEntry"."ID" = "PersonEntry_Localised_en_GB"."RecordID" AND "PersonEntry_Localised_en_GB"."Locale" = ?
WHERE ("Element_Persons"."ElementID" = ?)
AND (("PersonEntry_Localised_en_GB"."ID" IS NOT NULL))) THEN 1 ELSE 0 END
0.0002s
0116: SELECT DISTINCT count(DISTINCT "PersonEntry"."ID") AS "Count"
FROM "PersonEntry" INNER JOIN "Element_Persons" ON "Element_Persons"."PersonEntryID" = "PersonEntry"."ID" LEFT JOIN "PersonEntry_Localised" AS "PersonEntry_Localised_en_GB" ON "PersonEntry"."ID" = "PersonEntry_Localised_en_GB"."RecordID" AND "PersonEntry_Localised_en_GB"."Locale" = ?
WHERE ("Element_Persons"."ElementID" = ?)
AND (("PersonEntry_Localised_en_GB"."ID" IS NOT NULL))
0.0001s
0117: SELECT DISTINCT "Element_Live"."ClassName", "Element_Live"."LastEdited", "Element_Live"."Created", CASE
WHEN "BetterContent_Localised_en_GB"."ID" IS NOT NULL THEN "BetterContent_Localised_en_GB"."Content"
ELSE "BetterContent_Live"."Content" END
AS "Content", "Element_Live"."ID",
CASE WHEN "Element_Live"."ClassName" IS NOT NULL THEN "Element_Live"."ClassName"
ELSE 'DNADesign\\Elemental\\Models\\BaseElement' END AS "RecordClassName", 'en_GB' AS "Locale", CASE WHEN "BetterContent_Localised_en_GB"."ID" IS NOT NULL THEN 'en_GB'
ELSE NULL END AS "SourceLocale", "Element_Live"."Sort"
FROM "Element_Live" LEFT JOIN "BetterContent_Live" ON "BetterContent_Live"."ID" = "Element_Live"."ID" LEFT JOIN "Element_Localised_Live" AS "Element_Localised_en_GB" ON "Element_Live"."ID" = "Element_Localised_en_GB"."RecordID" AND "Element_Localised_en_GB"."Locale" = ? LEFT JOIN "BetterContent_Localised_Live" AS "BetterContent_Localised_en_GB" ON "BetterContent_Live"."ID" = "BetterContent_Localised_en_GB"."RecordID" AND "BetterContent_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.0002s
0118: SELECT CASE WHEN EXISTS(SELECT *
FROM "PersonEntry" INNER JOIN "Element_Persons" ON "Element_Persons"."PersonEntryID" = "PersonEntry"."ID" LEFT JOIN "PersonEntry_Localised" AS "PersonEntry_Localised_en_GB" ON "PersonEntry"."ID" = "PersonEntry_Localised_en_GB"."RecordID" AND "PersonEntry_Localised_en_GB"."Locale" = ?
WHERE ("Element_Persons"."ElementID" = ?)
AND (("PersonEntry_Localised_en_GB"."ID" IS NOT NULL))) THEN 1 ELSE 0 END
0.0001s
0119: SELECT "PersonEntry"."ID", "PersonEntry"."Name" AS "_SortColumn0"
FROM "PersonEntry" INNER JOIN "Element_Persons" ON "Element_Persons"."PersonEntryID" = "PersonEntry"."ID" LEFT JOIN "PersonEntry_Localised" AS "PersonEntry_Localised_en_GB" ON "PersonEntry"."ID" = "PersonEntry_Localised_en_GB"."RecordID" AND "PersonEntry_Localised_en_GB"."Locale" = ?
WHERE ("Element_Persons"."ElementID" = ?)
AND (("PersonEntry_Localised_en_GB"."ID" IS NOT NULL))
ORDER BY "_SortColumn0" ASC
0.0001s
0120: SELECT DISTINCT count(DISTINCT "PersonEntry"."ID") AS "Count"
FROM "PersonEntry" INNER JOIN "Element_Persons" ON "Element_Persons"."PersonEntryID" = "PersonEntry"."ID" LEFT JOIN "PersonEntry_Localised" AS "PersonEntry_Localised_en_GB" ON "PersonEntry"."ID" = "PersonEntry_Localised_en_GB"."RecordID" AND "PersonEntry_Localised_en_GB"."Locale" = ?
WHERE ("Element_Persons"."ElementID" = ?)
AND (("PersonEntry_Localised_en_GB"."ID" IS NOT NULL))
0.0001s
0121: SELECT DISTINCT "PersonEntry"."ClassName", "PersonEntry"."LastEdited", "PersonEntry"."Created", "PersonEntry"."SortOrder", CASE
WHEN "PersonEntry_Localised_en_GB"."ID" IS NOT NULL THEN "PersonEntry_Localised_en_GB"."Name"
ELSE "PersonEntry"."Name" END
AS "Name", CASE
WHEN "PersonEntry_Localised_en_GB"."ID" IS NOT NULL THEN "PersonEntry_Localised_en_GB"."Color"
ELSE "PersonEntry"."Color" END
AS "Color", "PersonEntry"."ImageID", "PersonEntry"."ID",
CASE WHEN "PersonEntry"."ClassName" IS NOT NULL THEN "PersonEntry"."ClassName"
ELSE 'App\\Models\\PersonEntry' END AS "RecordClassName", 'en_GB' AS "Locale", CASE WHEN "PersonEntry_Localised_en_GB"."ID" IS NOT NULL THEN 'en_GB'
ELSE NULL END AS "SourceLocale"
FROM "PersonEntry" INNER JOIN "Element_Persons" ON "Element_Persons"."PersonEntryID" = "PersonEntry"."ID" LEFT JOIN "PersonEntry_Localised" AS "PersonEntry_Localised_en_GB" ON "PersonEntry"."ID" = "PersonEntry_Localised_en_GB"."RecordID" AND "PersonEntry_Localised_en_GB"."Locale" = ?
WHERE ("Element_Persons"."ElementID" = ?)
AND (("PersonEntry_Localised_en_GB"."ID" IS NOT NULL))
ORDER BY "Name" ASC
LIMIT 1
0.0002s
0122: SELECT DISTINCT count(DISTINCT "File_Live"."ID") AS "Count"
FROM "File_Live" LEFT JOIN "Image_Live" ON "Image_Live"."ID" = "File_Live"."ID" INNER JOIN "ImageGalleryElement_Images" ON "ImageGalleryElement_Images"."ImageID" = "File_Live"."ID"
WHERE ("ImageGalleryElement_Images"."ImageGalleryElementID" = ?)
AND ("File_Live"."ClassName" IN (?, ?))
0.0001s
0123: SELECT DISTINCT "ImageGalleryElement_Images"."SortOrder", "File_Live"."ClassName", "File_Live"."LastEdited", "File_Live"."Created", CASE WHEN "File_Live"."ClassName" IN ('SilverStripe\\Assets\\File', 'SilverStripe\\Assets\\Folder', 'SilverStripe\\Assets\\Image', 'WeDevelop\\SvgImage\\Assets\\Svg') THEN "File_Live"."Copyright" WHEN "File_Live"."ClassName" IN ('SilverStripe\\Assets\\Image', 'WeDevelop\\SvgImage\\Assets\\Svg') THEN "Image_Live"."Copyright" WHEN "File_Live"."ClassName" IN ('SilverStripe\\Assets\\Image', 'WeDevelop\\SvgImage\\Assets\\Svg') THEN "Image_Live"."Copyright" ELSE NULL END AS "Copyright", CASE WHEN "File_Live"."ClassName" IN ('SilverStripe\\Assets\\File', 'SilverStripe\\Assets\\Folder', 'SilverStripe\\Assets\\Image', 'WeDevelop\\SvgImage\\Assets\\Svg') THEN "File_Live"."Bildunterschrift" WHEN "File_Live"."ClassName" IN ('SilverStripe\\Assets\\Image', 'WeDevelop\\SvgImage\\Assets\\Svg') THEN "Image_Live"."Bildunterschrift" WHEN "File_Live"."ClassName" IN ('SilverStripe\\Assets\\Image', 'WeDevelop\\SvgImage\\Assets\\Svg') THEN "Image_Live"."Bildunterschrift" ELSE NULL END AS "Bildunterschrift", CASE WHEN "File_Live"."ClassName" IN ('SilverStripe\\Assets\\File', 'SilverStripe\\Assets\\Folder', 'SilverStripe\\Assets\\Image', 'WeDevelop\\SvgImage\\Assets\\Svg') THEN "File_Live"."AltText" WHEN "File_Live"."ClassName" IN ('SilverStripe\\Assets\\Image', 'WeDevelop\\SvgImage\\Assets\\Svg') THEN "Image_Live"."AltText" WHEN "File_Live"."ClassName" IN ('SilverStripe\\Assets\\Image', 'WeDevelop\\SvgImage\\Assets\\Svg') THEN "Image_Live"."AltText" ELSE NULL END AS "AltText", "File_Live"."Version", "File_Live"."CanViewType", "File_Live"."CanEditType", "File_Live"."Name", "File_Live"."Title", "File_Live"."ShowInSearch", "File_Live"."ParentID", "File_Live"."OwnerID", "File_Live"."FileHash", "File_Live"."FileFilename", "File_Live"."FileVariant", "Image_Live"."FocusPointX", "Image_Live"."FocusPointY", "Image_Live"."FocusPointWidth", "Image_Live"."FocusPointHeight", "File_Live"."ID",
CASE WHEN "File_Live"."ClassName" IS NOT NULL THEN "File_Live"."ClassName"
ELSE 'SilverStripe\\Assets\\File' END AS "RecordClassName"
FROM "File_Live" LEFT JOIN "Image_Live" ON "Image_Live"."ID" = "File_Live"."ID" INNER JOIN "ImageGalleryElement_Images" ON "ImageGalleryElement_Images"."ImageID" = "File_Live"."ID"
WHERE ("ImageGalleryElement_Images"."ImageGalleryElementID" = ?)
AND ("File_Live"."ClassName" IN (?, ?))
ORDER BY "File_Live"."Name" ASC
0.0003s
0124: SELECT CASE WHEN EXISTS(SELECT *
FROM "PersonEntry" INNER JOIN "Element_Persons" ON "Element_Persons"."PersonEntryID" = "PersonEntry"."ID" LEFT JOIN "PersonEntry_Localised" AS "PersonEntry_Localised_en_GB" ON "PersonEntry"."ID" = "PersonEntry_Localised_en_GB"."RecordID" AND "PersonEntry_Localised_en_GB"."Locale" = ?
WHERE ("Element_Persons"."ElementID" = ?)
AND (("PersonEntry_Localised_en_GB"."ID" IS NOT NULL))) THEN 1 ELSE 0 END
0.0002s
0125: SELECT "PersonEntry"."ID", "PersonEntry"."Name" AS "_SortColumn0"
FROM "PersonEntry" INNER JOIN "Element_Persons" ON "Element_Persons"."PersonEntryID" = "PersonEntry"."ID" LEFT JOIN "PersonEntry_Localised" AS "PersonEntry_Localised_en_GB" ON "PersonEntry"."ID" = "PersonEntry_Localised_en_GB"."RecordID" AND "PersonEntry_Localised_en_GB"."Locale" = ?
WHERE ("Element_Persons"."ElementID" = ?)
AND (("PersonEntry_Localised_en_GB"."ID" IS NOT NULL))
ORDER BY "_SortColumn0" ASC
0.0001s
0126: SELECT DISTINCT count(DISTINCT "PersonEntry"."ID") AS "Count"
FROM "PersonEntry" INNER JOIN "Element_Persons" ON "Element_Persons"."PersonEntryID" = "PersonEntry"."ID" LEFT JOIN "PersonEntry_Localised" AS "PersonEntry_Localised_en_GB" ON "PersonEntry"."ID" = "PersonEntry_Localised_en_GB"."RecordID" AND "PersonEntry_Localised_en_GB"."Locale" = ?
WHERE ("Element_Persons"."ElementID" = ?)
AND (("PersonEntry_Localised_en_GB"."ID" IS NOT NULL))
0.0001s
0127: SELECT DISTINCT "PersonEntry"."ClassName", "PersonEntry"."LastEdited", "PersonEntry"."Created", "PersonEntry"."SortOrder", CASE
WHEN "PersonEntry_Localised_en_GB"."ID" IS NOT NULL THEN "PersonEntry_Localised_en_GB"."Name"
ELSE "PersonEntry"."Name" END
AS "Name", CASE
WHEN "PersonEntry_Localised_en_GB"."ID" IS NOT NULL THEN "PersonEntry_Localised_en_GB"."Color"
ELSE "PersonEntry"."Color" END
AS "Color", "PersonEntry"."ImageID", "PersonEntry"."ID",
CASE WHEN "PersonEntry"."ClassName" IS NOT NULL THEN "PersonEntry"."ClassName"
ELSE 'App\\Models\\PersonEntry' END AS "RecordClassName", 'en_GB' AS "Locale", CASE WHEN "PersonEntry_Localised_en_GB"."ID" IS NOT NULL THEN 'en_GB'
ELSE NULL END AS "SourceLocale"
FROM "PersonEntry" INNER JOIN "Element_Persons" ON "Element_Persons"."PersonEntryID" = "PersonEntry"."ID" LEFT JOIN "PersonEntry_Localised" AS "PersonEntry_Localised_en_GB" ON "PersonEntry"."ID" = "PersonEntry_Localised_en_GB"."RecordID" AND "PersonEntry_Localised_en_GB"."Locale" = ?
WHERE ("Element_Persons"."ElementID" = ?)
AND (("PersonEntry_Localised_en_GB"."ID" IS NOT NULL))
ORDER BY "Name" ASC
LIMIT 1
0.0002s
0128: SELECT DISTINCT "Element_Live"."ClassName", "Element_Live"."LastEdited", "Element_Live"."Created", CASE
WHEN "BetterContent_Localised_en_GB"."ID" IS NOT NULL THEN "BetterContent_Localised_en_GB"."Content"
ELSE "BetterContent_Live"."Content" END
AS "Content", "Element_Live"."ID",
CASE WHEN "Element_Live"."ClassName" IS NOT NULL THEN "Element_Live"."ClassName"
ELSE 'DNADesign\\Elemental\\Models\\BaseElement' END AS "RecordClassName", 'en_GB' AS "Locale", CASE WHEN "BetterContent_Localised_en_GB"."ID" IS NOT NULL THEN 'en_GB'
ELSE NULL END AS "SourceLocale", "Element_Live"."Sort"
FROM "Element_Live" LEFT JOIN "BetterContent_Live" ON "BetterContent_Live"."ID" = "Element_Live"."ID" LEFT JOIN "Element_Localised_Live" AS "Element_Localised_en_GB" ON "Element_Live"."ID" = "Element_Localised_en_GB"."RecordID" AND "Element_Localised_en_GB"."Locale" = ? LEFT JOIN "BetterContent_Localised_Live" AS "BetterContent_Localised_en_GB" ON "BetterContent_Live"."ID" = "BetterContent_Localised_en_GB"."RecordID" AND "BetterContent_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.0002s
0129: SELECT CASE WHEN EXISTS(SELECT *
FROM "PersonEntry" INNER JOIN "Element_Persons" ON "Element_Persons"."PersonEntryID" = "PersonEntry"."ID" LEFT JOIN "PersonEntry_Localised" AS "PersonEntry_Localised_en_GB" ON "PersonEntry"."ID" = "PersonEntry_Localised_en_GB"."RecordID" AND "PersonEntry_Localised_en_GB"."Locale" = ?
WHERE ("Element_Persons"."ElementID" = ?)
AND (("PersonEntry_Localised_en_GB"."ID" IS NOT NULL))) THEN 1 ELSE 0 END
0.0001s
0130: SELECT "PersonEntry"."ID", "PersonEntry"."Name" AS "_SortColumn0"
FROM "PersonEntry" INNER JOIN "Element_Persons" ON "Element_Persons"."PersonEntryID" = "PersonEntry"."ID" LEFT JOIN "PersonEntry_Localised" AS "PersonEntry_Localised_en_GB" ON "PersonEntry"."ID" = "PersonEntry_Localised_en_GB"."RecordID" AND "PersonEntry_Localised_en_GB"."Locale" = ?
WHERE ("Element_Persons"."ElementID" = ?)
AND (("PersonEntry_Localised_en_GB"."ID" IS NOT NULL))
ORDER BY "_SortColumn0" ASC
0.0001s
0131: SELECT DISTINCT count(DISTINCT "PersonEntry"."ID") AS "Count"
FROM "PersonEntry" INNER JOIN "Element_Persons" ON "Element_Persons"."PersonEntryID" = "PersonEntry"."ID" LEFT JOIN "PersonEntry_Localised" AS "PersonEntry_Localised_en_GB" ON "PersonEntry"."ID" = "PersonEntry_Localised_en_GB"."RecordID" AND "PersonEntry_Localised_en_GB"."Locale" = ?
WHERE ("Element_Persons"."ElementID" = ?)
AND (("PersonEntry_Localised_en_GB"."ID" IS NOT NULL))
0.0001s
0132: SELECT DISTINCT "PersonEntry"."ClassName", "PersonEntry"."LastEdited", "PersonEntry"."Created", "PersonEntry"."SortOrder", CASE
WHEN "PersonEntry_Localised_en_GB"."ID" IS NOT NULL THEN "PersonEntry_Localised_en_GB"."Name"
ELSE "PersonEntry"."Name" END
AS "Name", CASE
WHEN "PersonEntry_Localised_en_GB"."ID" IS NOT NULL THEN "PersonEntry_Localised_en_GB"."Color"
ELSE "PersonEntry"."Color" END
AS "Color", "PersonEntry"."ImageID", "PersonEntry"."ID",
CASE WHEN "PersonEntry"."ClassName" IS NOT NULL THEN "PersonEntry"."ClassName"
ELSE 'App\\Models\\PersonEntry' END AS "RecordClassName", 'en_GB' AS "Locale", CASE WHEN "PersonEntry_Localised_en_GB"."ID" IS NOT NULL THEN 'en_GB'
ELSE NULL END AS "SourceLocale"
FROM "PersonEntry" INNER JOIN "Element_Persons" ON "Element_Persons"."PersonEntryID" = "PersonEntry"."ID" LEFT JOIN "PersonEntry_Localised" AS "PersonEntry_Localised_en_GB" ON "PersonEntry"."ID" = "PersonEntry_Localised_en_GB"."RecordID" AND "PersonEntry_Localised_en_GB"."Locale" = ?
WHERE ("Element_Persons"."ElementID" = ?)
AND (("PersonEntry_Localised_en_GB"."ID" IS NOT NULL))
ORDER BY "Name" ASC
LIMIT 1
0.0002s
0133: SELECT DISTINCT count(DISTINCT "File_Live"."ID") AS "Count"
FROM "File_Live" LEFT JOIN "Image_Live" ON "Image_Live"."ID" = "File_Live"."ID" INNER JOIN "ImageGalleryElement_Images" ON "ImageGalleryElement_Images"."ImageID" = "File_Live"."ID"
WHERE ("ImageGalleryElement_Images"."ImageGalleryElementID" = ?)
AND ("File_Live"."ClassName" IN (?, ?))
0.0001s
0134: SELECT DISTINCT "ImageGalleryElement_Images"."SortOrder", "File_Live"."ClassName", "File_Live"."LastEdited", "File_Live"."Created", CASE WHEN "File_Live"."ClassName" IN ('SilverStripe\\Assets\\File', 'SilverStripe\\Assets\\Folder', 'SilverStripe\\Assets\\Image', 'WeDevelop\\SvgImage\\Assets\\Svg') THEN "File_Live"."Copyright" WHEN "File_Live"."ClassName" IN ('SilverStripe\\Assets\\Image', 'WeDevelop\\SvgImage\\Assets\\Svg') THEN "Image_Live"."Copyright" WHEN "File_Live"."ClassName" IN ('SilverStripe\\Assets\\Image', 'WeDevelop\\SvgImage\\Assets\\Svg') THEN "Image_Live"."Copyright" ELSE NULL END AS "Copyright", CASE WHEN "File_Live"."ClassName" IN ('SilverStripe\\Assets\\File', 'SilverStripe\\Assets\\Folder', 'SilverStripe\\Assets\\Image', 'WeDevelop\\SvgImage\\Assets\\Svg') THEN "File_Live"."Bildunterschrift" WHEN "File_Live"."ClassName" IN ('SilverStripe\\Assets\\Image', 'WeDevelop\\SvgImage\\Assets\\Svg') THEN "Image_Live"."Bildunterschrift" WHEN "File_Live"."ClassName" IN ('SilverStripe\\Assets\\Image', 'WeDevelop\\SvgImage\\Assets\\Svg') THEN "Image_Live"."Bildunterschrift" ELSE NULL END AS "Bildunterschrift", CASE WHEN "File_Live"."ClassName" IN ('SilverStripe\\Assets\\File', 'SilverStripe\\Assets\\Folder', 'SilverStripe\\Assets\\Image', 'WeDevelop\\SvgImage\\Assets\\Svg') THEN "File_Live"."AltText" WHEN "File_Live"."ClassName" IN ('SilverStripe\\Assets\\Image', 'WeDevelop\\SvgImage\\Assets\\Svg') THEN "Image_Live"."AltText" WHEN "File_Live"."ClassName" IN ('SilverStripe\\Assets\\Image', 'WeDevelop\\SvgImage\\Assets\\Svg') THEN "Image_Live"."AltText" ELSE NULL END AS "AltText", "File_Live"."Version", "File_Live"."CanViewType", "File_Live"."CanEditType", "File_Live"."Name", "File_Live"."Title", "File_Live"."ShowInSearch", "File_Live"."ParentID", "File_Live"."OwnerID", "File_Live"."FileHash", "File_Live"."FileFilename", "File_Live"."FileVariant", "Image_Live"."FocusPointX", "Image_Live"."FocusPointY", "Image_Live"."FocusPointWidth", "Image_Live"."FocusPointHeight", "File_Live"."ID",
CASE WHEN "File_Live"."ClassName" IS NOT NULL THEN "File_Live"."ClassName"
ELSE 'SilverStripe\\Assets\\File' END AS "RecordClassName"
FROM "File_Live" LEFT JOIN "Image_Live" ON "Image_Live"."ID" = "File_Live"."ID" INNER JOIN "ImageGalleryElement_Images" ON "ImageGalleryElement_Images"."ImageID" = "File_Live"."ID"
WHERE ("ImageGalleryElement_Images"."ImageGalleryElementID" = ?)
AND ("File_Live"."ClassName" IN (?, ?))
ORDER BY "File_Live"."Name" ASC
0.0002s
0135: SELECT CASE WHEN EXISTS(SELECT *
FROM "PersonEntry" INNER JOIN "Element_Persons" ON "Element_Persons"."PersonEntryID" = "PersonEntry"."ID" LEFT JOIN "PersonEntry_Localised" AS "PersonEntry_Localised_en_GB" ON "PersonEntry"."ID" = "PersonEntry_Localised_en_GB"."RecordID" AND "PersonEntry_Localised_en_GB"."Locale" = ?
WHERE ("Element_Persons"."ElementID" = ?)
AND (("PersonEntry_Localised_en_GB"."ID" IS NOT NULL))) THEN 1 ELSE 0 END
0.0002s
0136: SELECT "PersonEntry"."ID", "PersonEntry"."Name" AS "_SortColumn0"
FROM "PersonEntry" INNER JOIN "Element_Persons" ON "Element_Persons"."PersonEntryID" = "PersonEntry"."ID" LEFT JOIN "PersonEntry_Localised" AS "PersonEntry_Localised_en_GB" ON "PersonEntry"."ID" = "PersonEntry_Localised_en_GB"."RecordID" AND "PersonEntry_Localised_en_GB"."Locale" = ?
WHERE ("Element_Persons"."ElementID" = ?)
AND (("PersonEntry_Localised_en_GB"."ID" IS NOT NULL))
ORDER BY "_SortColumn0" ASC
0.0001s
0137: SELECT DISTINCT count(DISTINCT "PersonEntry"."ID") AS "Count"
FROM "PersonEntry" INNER JOIN "Element_Persons" ON "Element_Persons"."PersonEntryID" = "PersonEntry"."ID" LEFT JOIN "PersonEntry_Localised" AS "PersonEntry_Localised_en_GB" ON "PersonEntry"."ID" = "PersonEntry_Localised_en_GB"."RecordID" AND "PersonEntry_Localised_en_GB"."Locale" = ?
WHERE ("Element_Persons"."ElementID" = ?)
AND (("PersonEntry_Localised_en_GB"."ID" IS NOT NULL))
0.0001s
0138: SELECT DISTINCT "PersonEntry"."ClassName", "PersonEntry"."LastEdited", "PersonEntry"."Created", "PersonEntry"."SortOrder", CASE
WHEN "PersonEntry_Localised_en_GB"."ID" IS NOT NULL THEN "PersonEntry_Localised_en_GB"."Name"
ELSE "PersonEntry"."Name" END
AS "Name", CASE
WHEN "PersonEntry_Localised_en_GB"."ID" IS NOT NULL THEN "PersonEntry_Localised_en_GB"."Color"
ELSE "PersonEntry"."Color" END
AS "Color", "PersonEntry"."ImageID", "PersonEntry"."ID",
CASE WHEN "PersonEntry"."ClassName" IS NOT NULL THEN "PersonEntry"."ClassName"
ELSE 'App\\Models\\PersonEntry' END AS "RecordClassName", 'en_GB' AS "Locale", CASE WHEN "PersonEntry_Localised_en_GB"."ID" IS NOT NULL THEN 'en_GB'
ELSE NULL END AS "SourceLocale"
FROM "PersonEntry" INNER JOIN "Element_Persons" ON "Element_Persons"."PersonEntryID" = "PersonEntry"."ID" LEFT JOIN "PersonEntry_Localised" AS "PersonEntry_Localised_en_GB" ON "PersonEntry"."ID" = "PersonEntry_Localised_en_GB"."RecordID" AND "PersonEntry_Localised_en_GB"."Locale" = ?
WHERE ("Element_Persons"."ElementID" = ?)
AND (("PersonEntry_Localised_en_GB"."ID" IS NOT NULL))
ORDER BY "Name" ASC
LIMIT 1
0.0002s
0139: SELECT DISTINCT "Element_Live"."ClassName", "Element_Live"."LastEdited", "Element_Live"."Created", CASE
WHEN "BetterContent_Localised_en_GB"."ID" IS NOT NULL THEN "BetterContent_Localised_en_GB"."Content"
ELSE "BetterContent_Live"."Content" END
AS "Content", "Element_Live"."ID",
CASE WHEN "Element_Live"."ClassName" IS NOT NULL THEN "Element_Live"."ClassName"
ELSE 'DNADesign\\Elemental\\Models\\BaseElement' END AS "RecordClassName", 'en_GB' AS "Locale", CASE WHEN "BetterContent_Localised_en_GB"."ID" IS NOT NULL THEN 'en_GB'
ELSE NULL END AS "SourceLocale", "Element_Live"."Sort"
FROM "Element_Live" LEFT JOIN "BetterContent_Live" ON "BetterContent_Live"."ID" = "Element_Live"."ID" LEFT JOIN "Element_Localised_Live" AS "Element_Localised_en_GB" ON "Element_Live"."ID" = "Element_Localised_en_GB"."RecordID" AND "Element_Localised_en_GB"."Locale" = ? LEFT JOIN "BetterContent_Localised_Live" AS "BetterContent_Localised_en_GB" ON "BetterContent_Live"."ID" = "BetterContent_Localised_en_GB"."RecordID" AND "BetterContent_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.0002s
0140: SELECT DISTINCT "LinkField_Link_Live"."ClassName", "LinkField_Link_Live"."LastEdited", "LinkField_Link_Live"."Created", "LinkField_Link_Live"."Icon", "LinkField_Link_Live"."Version", "LinkField_Link_Live"."LinkText", "LinkField_Link_Live"."OpenInNew", "LinkField_Link_Live"."Sort", "LinkField_Link_Live"."OwnerID", "LinkField_Link_Live"."OwnerClass", "LinkField_Link_Live"."OwnerRelation", "LinkField_Link_Live"."ID",
CASE WHEN "LinkField_Link_Live"."ClassName" IS NOT NULL THEN "LinkField_Link_Live"."ClassName"
ELSE 'SilverStripe\\LinkField\\Models\\Link' END AS "RecordClassName"
FROM "LinkField_Link_Live"
WHERE ("LinkField_Link_Live"."OwnerClass" IN ('App\\Elementals\\BTNElement'))
AND ("LinkField_Link_Live"."OwnerRelation" = ?)
AND ("LinkField_Link_Live"."OwnerID" = ?)
ORDER BY "LinkField_Link_Live"."Sort" ASC
0.0002s
0141: SELECT DISTINCT "LinkField_Link_Live"."ClassName", "LinkField_Link_Live"."LastEdited", "LinkField_Link_Live"."Created", "LinkField_SiteTreeLink_Live"."Anchor", "LinkField_SiteTreeLink_Live"."QueryString", "LinkField_SiteTreeLink_Live"."PageID", "LinkField_Link_Live"."ID",
CASE WHEN "LinkField_Link_Live"."ClassName" IS NOT NULL THEN "LinkField_Link_Live"."ClassName"
ELSE 'SilverStripe\\LinkField\\Models\\Link' END AS "RecordClassName", "LinkField_Link_Live"."Sort"
FROM "LinkField_Link_Live" LEFT JOIN "LinkField_SiteTreeLink_Live" ON "LinkField_SiteTreeLink_Live"."ID" = "LinkField_Link_Live"."ID"
WHERE ("LinkField_Link_Live"."ID" = ?)
AND ("LinkField_Link_Live"."ClassName" IN (?))
ORDER BY "LinkField_Link_Live"."Sort" ASC
LIMIT 1
0.0002s
0142: 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.0003s
0143: 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.0003s
0144: SELECT DISTINCT "LinkField_Link_Live"."ClassName", "LinkField_Link_Live"."LastEdited", "LinkField_Link_Live"."Created", "LinkField_SiteTreeLink_Live"."Anchor", "LinkField_SiteTreeLink_Live"."QueryString", "LinkField_SiteTreeLink_Live"."PageID", "LinkField_Link_Live"."ID",
CASE WHEN "LinkField_Link_Live"."ClassName" IS NOT NULL THEN "LinkField_Link_Live"."ClassName"
ELSE 'SilverStripe\\LinkField\\Models\\Link' END AS "RecordClassName", "LinkField_Link_Live"."Sort"
FROM "LinkField_Link_Live" LEFT JOIN "LinkField_SiteTreeLink_Live" ON "LinkField_SiteTreeLink_Live"."ID" = "LinkField_Link_Live"."ID"
WHERE ("LinkField_Link_Live"."ID" = ?)
AND ("LinkField_Link_Live"."ClassName" IN (?))
ORDER BY "LinkField_Link_Live"."Sort" ASC
LIMIT 1
0.0002s
0145: 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.0003s
0146: SELECT DISTINCT "LinkField_Link_Live"."ClassName", "LinkField_Link_Live"."LastEdited", "LinkField_Link_Live"."Created", "LinkField_SiteTreeLink_Live"."Anchor", "LinkField_SiteTreeLink_Live"."QueryString", "LinkField_SiteTreeLink_Live"."PageID", "LinkField_Link_Live"."ID",
CASE WHEN "LinkField_Link_Live"."ClassName" IS NOT NULL THEN "LinkField_Link_Live"."ClassName"
ELSE 'SilverStripe\\LinkField\\Models\\Link' END AS "RecordClassName", "LinkField_Link_Live"."Sort"
FROM "LinkField_Link_Live" LEFT JOIN "LinkField_SiteTreeLink_Live" ON "LinkField_SiteTreeLink_Live"."ID" = "LinkField_Link_Live"."ID"
WHERE ("LinkField_Link_Live"."ID" = ?)
AND ("LinkField_Link_Live"."ClassName" IN (?))
ORDER BY "LinkField_Link_Live"."Sort" ASC
LIMIT 1
0.0002s
0147: 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.0003s
0148: 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.0003s
0149: SELECT DISTINCT "PersonEntry"."ClassName", "PersonEntry"."LastEdited", "PersonEntry"."Created", "PersonEntry"."SortOrder", CASE
WHEN "PersonEntry_Localised_en_GB"."ID" IS NOT NULL THEN "PersonEntry_Localised_en_GB"."Name"
ELSE "PersonEntry"."Name" END
AS "Name", CASE
WHEN "PersonEntry_Localised_en_GB"."ID" IS NOT NULL THEN "PersonEntry_Localised_en_GB"."Color"
ELSE "PersonEntry"."Color" END
AS "Color", "PersonEntry"."ImageID", "PersonEntry"."ID",
CASE WHEN "PersonEntry"."ClassName" IS NOT NULL THEN "PersonEntry"."ClassName"
ELSE 'App\\Models\\PersonEntry' END AS "RecordClassName", 'en_GB' AS "Locale", CASE WHEN "PersonEntry_Localised_en_GB"."ID" IS NOT NULL THEN 'en_GB'
ELSE NULL END AS "SourceLocale", (COALESCE("PersonEntry_Localised_en_GB"."Name", "PersonEntry"."Name")) AS "_SortColumn0"
FROM "PersonEntry" LEFT JOIN "PersonEntry_Localised" AS "PersonEntry_Localised_en_GB" ON "PersonEntry"."ID" = "PersonEntry_Localised_en_GB"."RecordID" AND "PersonEntry_Localised_en_GB"."Locale" = ?
WHERE (("PersonEntry_Localised_en_GB"."ID" IS NOT NULL))
ORDER BY "_SortColumn0" ASC
0.0002s
0150: SELECT DISTINCT "File_Live"."ClassName", "File_Live"."LastEdited", "File_Live"."Created", CASE WHEN "File_Live"."ClassName" IN ('SilverStripe\\Assets\\File', 'SilverStripe\\Assets\\Folder', 'SilverStripe\\Assets\\Image', 'WeDevelop\\SvgImage\\Assets\\Svg') THEN "File_Live"."Copyright" WHEN "File_Live"."ClassName" IN ('SilverStripe\\Assets\\Image', 'WeDevelop\\SvgImage\\Assets\\Svg') THEN "Image_Live"."Copyright" WHEN "File_Live"."ClassName" IN ('SilverStripe\\Assets\\Image', 'WeDevelop\\SvgImage\\Assets\\Svg') THEN "Image_Live"."Copyright" ELSE NULL END AS "Copyright", CASE WHEN "File_Live"."ClassName" IN ('SilverStripe\\Assets\\File', 'SilverStripe\\Assets\\Folder', 'SilverStripe\\Assets\\Image', 'WeDevelop\\SvgImage\\Assets\\Svg') THEN "File_Live"."Bildunterschrift" WHEN "File_Live"."ClassName" IN ('SilverStripe\\Assets\\Image', 'WeDevelop\\SvgImage\\Assets\\Svg') THEN "Image_Live"."Bildunterschrift" WHEN "File_Live"."ClassName" IN ('SilverStripe\\Assets\\Image', 'WeDevelop\\SvgImage\\Assets\\Svg') THEN "Image_Live"."Bildunterschrift" ELSE NULL END AS "Bildunterschrift", CASE WHEN "File_Live"."ClassName" IN ('SilverStripe\\Assets\\File', 'SilverStripe\\Assets\\Folder', 'SilverStripe\\Assets\\Image', 'WeDevelop\\SvgImage\\Assets\\Svg') THEN "File_Live"."AltText" WHEN "File_Live"."ClassName" IN ('SilverStripe\\Assets\\Image', 'WeDevelop\\SvgImage\\Assets\\Svg') THEN "Image_Live"."AltText" WHEN "File_Live"."ClassName" IN ('SilverStripe\\Assets\\Image', 'WeDevelop\\SvgImage\\Assets\\Svg') THEN "Image_Live"."AltText" ELSE NULL END AS "AltText", "File_Live"."Version", "File_Live"."CanViewType", "File_Live"."CanEditType", "File_Live"."Name", "File_Live"."Title", "File_Live"."ShowInSearch", "File_Live"."ParentID", "File_Live"."OwnerID", "File_Live"."FileHash", "File_Live"."FileFilename", "File_Live"."FileVariant", "Image_Live"."FocusPointX", "Image_Live"."FocusPointY", "Image_Live"."FocusPointWidth", "Image_Live"."FocusPointHeight", "File_Live"."ID",
CASE WHEN "File_Live"."ClassName" IS NOT NULL THEN "File_Live"."ClassName"
ELSE 'SilverStripe\\Assets\\File' END AS "RecordClassName"
FROM "File_Live" LEFT JOIN "Image_Live" ON "Image_Live"."ID" = "File_Live"."ID"
WHERE ("File_Live"."ID" = ?)
AND ("File_Live"."ClassName" IN (?, ?))
ORDER BY "File_Live"."Name" ASC
LIMIT 1
0.0003s
0151: SELECT DISTINCT "File_Live"."ClassName", "File_Live"."LastEdited", "File_Live"."Created", CASE WHEN "File_Live"."ClassName" IN ('SilverStripe\\Assets\\File', 'SilverStripe\\Assets\\Folder', 'SilverStripe\\Assets\\Image', 'WeDevelop\\SvgImage\\Assets\\Svg') THEN "File_Live"."Copyright" WHEN "File_Live"."ClassName" IN ('SilverStripe\\Assets\\Image', 'WeDevelop\\SvgImage\\Assets\\Svg') THEN "Image_Live"."Copyright" WHEN "File_Live"."ClassName" IN ('SilverStripe\\Assets\\Image', 'WeDevelop\\SvgImage\\Assets\\Svg') THEN "Image_Live"."Copyright" ELSE NULL END AS "Copyright", CASE WHEN "File_Live"."ClassName" IN ('SilverStripe\\Assets\\File', 'SilverStripe\\Assets\\Folder', 'SilverStripe\\Assets\\Image', 'WeDevelop\\SvgImage\\Assets\\Svg') THEN "File_Live"."Bildunterschrift" WHEN "File_Live"."ClassName" IN ('SilverStripe\\Assets\\Image', 'WeDevelop\\SvgImage\\Assets\\Svg') THEN "Image_Live"."Bildunterschrift" WHEN "File_Live"."ClassName" IN ('SilverStripe\\Assets\\Image', 'WeDevelop\\SvgImage\\Assets\\Svg') THEN "Image_Live"."Bildunterschrift" ELSE NULL END AS "Bildunterschrift", CASE WHEN "File_Live"."ClassName" IN ('SilverStripe\\Assets\\File', 'SilverStripe\\Assets\\Folder', 'SilverStripe\\Assets\\Image', 'WeDevelop\\SvgImage\\Assets\\Svg') THEN "File_Live"."AltText" WHEN "File_Live"."ClassName" IN ('SilverStripe\\Assets\\Image', 'WeDevelop\\SvgImage\\Assets\\Svg') THEN "Image_Live"."AltText" WHEN "File_Live"."ClassName" IN ('SilverStripe\\Assets\\Image', 'WeDevelop\\SvgImage\\Assets\\Svg') THEN "Image_Live"."AltText" ELSE NULL END AS "AltText", "File_Live"."Version", "File_Live"."CanViewType", "File_Live"."CanEditType", "File_Live"."Name", "File_Live"."Title", "File_Live"."ShowInSearch", "File_Live"."ParentID", "File_Live"."OwnerID", "File_Live"."FileHash", "File_Live"."FileFilename", "File_Live"."FileVariant", "Image_Live"."FocusPointX", "Image_Live"."FocusPointY", "Image_Live"."FocusPointWidth", "Image_Live"."FocusPointHeight", "File_Live"."ID",
CASE WHEN "File_Live"."ClassName" IS NOT NULL THEN "File_Live"."ClassName"
ELSE 'SilverStripe\\Assets\\File' END AS "RecordClassName"
FROM "File_Live" LEFT JOIN "Image_Live" ON "Image_Live"."ID" = "File_Live"."ID"
WHERE ("File_Live"."ID" = ?)
AND ("File_Live"."ClassName" IN (?, ?))
ORDER BY "File_Live"."Name" ASC
LIMIT 1
0.0002s
0152: SELECT DISTINCT "File_Live"."ClassName", "File_Live"."LastEdited", "File_Live"."Created", CASE WHEN "File_Live"."ClassName" IN ('SilverStripe\\Assets\\File', 'SilverStripe\\Assets\\Folder', 'SilverStripe\\Assets\\Image', 'WeDevelop\\SvgImage\\Assets\\Svg') THEN "File_Live"."Copyright" WHEN "File_Live"."ClassName" IN ('SilverStripe\\Assets\\Image', 'WeDevelop\\SvgImage\\Assets\\Svg') THEN "Image_Live"."Copyright" WHEN "File_Live"."ClassName" IN ('SilverStripe\\Assets\\Image', 'WeDevelop\\SvgImage\\Assets\\Svg') THEN "Image_Live"."Copyright" ELSE NULL END AS "Copyright", CASE WHEN "File_Live"."ClassName" IN ('SilverStripe\\Assets\\File', 'SilverStripe\\Assets\\Folder', 'SilverStripe\\Assets\\Image', 'WeDevelop\\SvgImage\\Assets\\Svg') THEN "File_Live"."Bildunterschrift" WHEN "File_Live"."ClassName" IN ('SilverStripe\\Assets\\Image', 'WeDevelop\\SvgImage\\Assets\\Svg') THEN "Image_Live"."Bildunterschrift" WHEN "File_Live"."ClassName" IN ('SilverStripe\\Assets\\Image', 'WeDevelop\\SvgImage\\Assets\\Svg') THEN "Image_Live"."Bildunterschrift" ELSE NULL END AS "Bildunterschrift", CASE WHEN "File_Live"."ClassName" IN ('SilverStripe\\Assets\\File', 'SilverStripe\\Assets\\Folder', 'SilverStripe\\Assets\\Image', 'WeDevelop\\SvgImage\\Assets\\Svg') THEN "File_Live"."AltText" WHEN "File_Live"."ClassName" IN ('SilverStripe\\Assets\\Image', 'WeDevelop\\SvgImage\\Assets\\Svg') THEN "Image_Live"."AltText" WHEN "File_Live"."ClassName" IN ('SilverStripe\\Assets\\Image', 'WeDevelop\\SvgImage\\Assets\\Svg') THEN "Image_Live"."AltText" ELSE NULL END AS "AltText", "File_Live"."Version", "File_Live"."CanViewType", "File_Live"."CanEditType", "File_Live"."Name", "File_Live"."Title", "File_Live"."ShowInSearch", "File_Live"."ParentID", "File_Live"."OwnerID", "File_Live"."FileHash", "File_Live"."FileFilename", "File_Live"."FileVariant", "Image_Live"."FocusPointX", "Image_Live"."FocusPointY", "Image_Live"."FocusPointWidth", "Image_Live"."FocusPointHeight", "File_Live"."ID",
CASE WHEN "File_Live"."ClassName" IS NOT NULL THEN "File_Live"."ClassName"
ELSE 'SilverStripe\\Assets\\File' END AS "RecordClassName"
FROM "File_Live" LEFT JOIN "Image_Live" ON "Image_Live"."ID" = "File_Live"."ID"
WHERE ("File_Live"."ID" = ?)
AND ("File_Live"."ClassName" IN (?, ?))
ORDER BY "File_Live"."Name" ASC
LIMIT 1
0.0003s
0153: SELECT DISTINCT "File_Live"."ClassName", "File_Live"."LastEdited", "File_Live"."Created", CASE WHEN "File_Live"."ClassName" IN ('SilverStripe\\Assets\\File', 'SilverStripe\\Assets\\Folder', 'SilverStripe\\Assets\\Image', 'WeDevelop\\SvgImage\\Assets\\Svg') THEN "File_Live"."Copyright" WHEN "File_Live"."ClassName" IN ('SilverStripe\\Assets\\Image', 'WeDevelop\\SvgImage\\Assets\\Svg') THEN "Image_Live"."Copyright" WHEN "File_Live"."ClassName" IN ('SilverStripe\\Assets\\Image', 'WeDevelop\\SvgImage\\Assets\\Svg') THEN "Image_Live"."Copyright" ELSE NULL END AS "Copyright", CASE WHEN "File_Live"."ClassName" IN ('SilverStripe\\Assets\\File', 'SilverStripe\\Assets\\Folder', 'SilverStripe\\Assets\\Image', 'WeDevelop\\SvgImage\\Assets\\Svg') THEN "File_Live"."Bildunterschrift" WHEN "File_Live"."ClassName" IN ('SilverStripe\\Assets\\Image', 'WeDevelop\\SvgImage\\Assets\\Svg') THEN "Image_Live"."Bildunterschrift" WHEN "File_Live"."ClassName" IN ('SilverStripe\\Assets\\Image', 'WeDevelop\\SvgImage\\Assets\\Svg') THEN "Image_Live"."Bildunterschrift" ELSE NULL END AS "Bildunterschrift", CASE WHEN "File_Live"."ClassName" IN ('SilverStripe\\Assets\\File', 'SilverStripe\\Assets\\Folder', 'SilverStripe\\Assets\\Image', 'WeDevelop\\SvgImage\\Assets\\Svg') THEN "File_Live"."AltText" WHEN "File_Live"."ClassName" IN ('SilverStripe\\Assets\\Image', 'WeDevelop\\SvgImage\\Assets\\Svg') THEN "Image_Live"."AltText" WHEN "File_Live"."ClassName" IN ('SilverStripe\\Assets\\Image', 'WeDevelop\\SvgImage\\Assets\\Svg') THEN "Image_Live"."AltText" ELSE NULL END AS "AltText", "File_Live"."Version", "File_Live"."CanViewType", "File_Live"."CanEditType", "File_Live"."Name", "File_Live"."Title", "File_Live"."ShowInSearch", "File_Live"."ParentID", "File_Live"."OwnerID", "File_Live"."FileHash", "File_Live"."FileFilename", "File_Live"."FileVariant", "Image_Live"."FocusPointX", "Image_Live"."FocusPointY", "Image_Live"."FocusPointWidth", "Image_Live"."FocusPointHeight", "File_Live"."ID",
CASE WHEN "File_Live"."ClassName" IS NOT NULL THEN "File_Live"."ClassName"
ELSE 'SilverStripe\\Assets\\File' END AS "RecordClassName"
FROM "File_Live" LEFT JOIN "Image_Live" ON "Image_Live"."ID" = "File_Live"."ID"
WHERE ("File_Live"."ID" = ?)
AND ("File_Live"."ClassName" IN (?, ?))
ORDER BY "File_Live"."Name" ASC
LIMIT 1
0.0003s
0154: SELECT CASE WHEN EXISTS(SELECT *
FROM "MenuSet"
WHERE ("MenuSet"."Name" = ?)) THEN 1 ELSE 0 END
0.0002s
0155: SELECT DISTINCT "MenuSet"."ClassName", "MenuSet"."LastEdited", "MenuSet"."Created", "MenuSet"."Name", "MenuSet"."Description", "MenuSet"."Sort", "MenuSet"."ID",
CASE WHEN "MenuSet"."ClassName" IS NOT NULL THEN "MenuSet"."ClassName"
ELSE 'Heyday\\MenuManager\\MenuSet' END AS "RecordClassName"
FROM "MenuSet"
WHERE ("MenuSet"."Name" = ?)
ORDER BY "MenuSet"."Sort" ASC
LIMIT 1
0.0002s
0156: SELECT "Version" FROM "SiteTree" WHERE "ID" = ?
0.0002s
0157: SELECT "BaseTable"."RecordID", MAX("SiteTree_Localised_Versions"."Version") as "LatestVersion" FROM "SiteTree_Localised" AS "BaseTable" INNER JOIN "SiteTree_Localised_Versions" ON "BaseTable"."RecordID" = "SiteTree_Localised_Versions"."RecordID" AND "SiteTree_Localised_Versions"."Locale" = ? INNER JOIN "SiteTree_Versions" ON "SiteTree_Versions"."RecordID" = "SiteTree_Localised_Versions"."RecordID" AND "SiteTree_Versions"."Version" = "SiteTree_Localised_Versions"."Version" WHERE "BaseTable"."Locale" = ? AND "BaseTable"."RecordID" IN (?) GROUP BY "BaseTable"."RecordID"
0.0001s
0158: SELECT "ID"
FROM "SiteTree_Localised_Live"
WHERE ("RecordID" = ?)
AND ("Locale" = ?)
LIMIT 1
0.0001s
0159: 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.0003s
0160: 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.0003s
0161: 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.0003s
0162: 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.0004s
0163: 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.0004s
0164: 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.0003s
The residence of Grandmother Henriette Tal at Weesperzijde 14, Amsterdam. @From the estate of Chanan Tal. Original source unknown
From left to right: Ruth, Chanan and No’omi at the window, Weesperzijde 14, Amsterdam, ca. 1937 @Private property of the Tal family
I, Chanan, was born on 18 April 1930, in the apartment on the second floor of Grandma Tal’s house along the Amstel river. Ruth and No’omi, my twin sisters, were born there on 5 December 1932. The three of us slept in a small room, and one of the first things I remember are the twin beds that our father built. During the day, they closed as boxes, with the bedding in them, so that we had a platform we could play on. It was original planning and precise execution. Father obviously enjoyed building those beds.
From left to right: Grandma Netta, No’omi, Ruth, Lenie, Fré on the Dam Square, 1938 @Private property of the Tal family
We lived near the Amstel, a large river that crosses Amsterdam, in a small apartment above Oma Tal’s apartment (Father’s mother). We would look at the ships passing over the water and the bridge opening for them. When we were five, we moved into a bigger apartment. Ruth and I got a big, beautiful room with a light blue set of shelves. Chanan had his own room in the attic. The apartment had a flat roof, where we played… I missed the river.
Oma Netta, our mother’s mother, was a very sweet grandmother. She had curly white hair. I didn’t know anyone else with hair like that... I remember once we went with her to a ‘doll-doctor’ with our ‘wounded’ doll that we drove in a pink straw pram. We would also hang out at the Vondelpark, we in the playground, and Grandma on the terrace of the café. I also remember that the two grandmothers once took us there. We also loved coming to Oma Netta’s apartment. It had a sort of secret place for toys, which was behind a curtain in an unused space designed for a stove.
From left to right: Noòmi (6), Sander (35), Ruth (6), Fré (29), Chanan (8) @Private property of the Tal family
This is a family photo from 1938.
Back then, it was customary to give such pictures as a birthday present to one’s grandmother:
Father and Mother, me and the little twin sisters No’omi and Ruth.
The house at Johannes Verhulststraat 73, Amsterdam, 1980s @From the estate of Chanan Tal. Original source unknown
Grandma Henriette Tal @Private property of the Tal family
In 1938 we moved to an apartment in another part of the city. The large apartment was on the top three floors of a five-story house, starting from the balcony up to and including the attic. The room with the small window under the roof was my room.
Heating was only on the living floor, and in the attic, there was a large storage room for coal that they would fill once a year from above. The coal was taken out through a small window at floor level. Towards the end of the heating season, it became more and more difficult to remove the remaining coal that stuck to the back wall of the crate. I decided to solve the problem and went into the crate to bring the coal to the porthole…
This is where we lived until the day of the expulsion on 29 September 1943.
Grandma Tal lived for another two years alone in the house near the Amstel, but after the outbreak of the war in the Netherlands she moved to our new home, where she died on 6 April 1941 at the age of seventy-two.
Third graders at Herman Elte School, Chanan front row, second from right with the tie, Amsterdam, spring or summer 1939 @Private property of the Tal family
Chanan, Ruth and No’omi attended the Jewish elementary school, the Herman Elte School.
In the first half of 1939, 43 pupils were enrolled in the third grade at the Herman Elte School.
31 of them and the teacher, Aaltje Fortuijn, were later killed in the Holocaust. That was 74 per cent of the class, the same percentage of all Jews from the Netherlands who were murdered in the Holocaust.
Twelve of the children survived. Seven of them later emigrated to Israel, including Chanan Tal.
The Herman Elte School was established in 1874 in the old Jewish quarter as a Jewish school. In 1935, it moved to Van Ostadestraat 203. During the war, it continued to operate as a Jewish school. In May 1941 it had about 570 students, and the principal was Elias Stibbe. Beginning in November 1942 he worked under the Jewish Council. In March 1943, the school was transferred, by order of the Nazis, to the “Jewish Quarter” in east Amsterdam. On 29 September 1943, when the last Jews were sent to camps, including No’omi and Ruth, the school was closed.
Ruth (left) and No'omi (right) in 1939, seven years old @Private property of the Tal family
In September 1939, Ruth and I entered first grade, an exciting and joyful event that we had been waiting for; we were 6 1/2 years old. We went to the same class and sat next to each other. We wore an apron. We learned to read and write both Dutch and Hebrew. We wrote on a slate board with a slate pencil.
There was a shop called “The Children’s Friend” opposite the school where they sold slate pencils in all sorts of beautiful and colorful wrappers. We loved choosing the most beautiful. There were also all kinds of sweets, and there was a large barrel full of soft drop (Dutch candy). For one cent, you could stick your thumb in, take it out full of drop and lick! It wasn't the most hygienic; no one asked us to wash our hands!
When we were making progress and knew how to write all the letters on the slate, we switched to using paper and pencil. And as we progressed, we got half a notebook where we wrote with a pen that had to be dipped in ink. Whoever wrote nicely and got at least a mark 8 would win a sticker. It wasn’t easy because you had to make a thin line up and a thick line down. I tried so hard, but it didn’t work out for me. Ruth already had a sticker ... finally I got a black teddy bear sticker.
At school, we, the girls, were taught to knit. We had to knit a sock, but I didn’t want to; it wasn’t interesting, and I had no use for one sock. Instead, I asked the teacher to knit a bag for my marbles, and she said yes. I knitted with white cotton, and the bag got dirty really quickly. Even before I finished knitting it, it turned gray.
We also had a painting class. I loved drawing fishes because all shapes turnout successful and beautiful. I once painted a farmer, and I was really pleased, and the teacher added a wart to his nose... I didn’t like the way he interfered with my painting. There was a teacher we called by a nickname behind his back. That impertinence excited me greatly!
No'omi and Ruth’s class, both sit to the left of the teacher @Private property of the Tal family
On 5 December, we celebrated our 7th birthday. We handed out candy to all the classmates as well as the teacher out of a triangular paper bag. Then we were allowed to go up to the fourth grade, where Chanan studied, and to distribute candy there as well.
During the year, we prepared a play according to the Hebrew song “The Pots on the Wall”. I especially remember the rehearsals; I really enjoyed them. I don't remember why we made the show, maybe as part of our Hebrew lessons?
We really liked the school; we enjoyed the breaks as well. We played all kinds of familiar and new games: class, jump rope, new donkey, and marbles. Of course, during the Passover holiday, it was also great fun to be at home, to participate in all the preparations for the holiday and to celebrate Seder night. That year we succeeded in reading more of the Haggadah.