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.0009s
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.0005s
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.0005s
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.0003s
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.0004s
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"."DontShowCopy" WHEN "File_Live"."ClassName" IN ('SilverStripe\\Assets\\Image', 'WeDevelop\\SvgImage\\Assets\\Svg') THEN "Image_Live"."DontShowCopy" WHEN "File_Live"."ClassName" IN ('SilverStripe\\Assets\\Image', 'WeDevelop\\SvgImage\\Assets\\Svg') THEN "Image_Live"."DontShowCopy" ELSE NULL END AS "DontShowCopy", CASE WHEN "File_Live"."ClassName" IN ('SilverStripe\\Assets\\File', 'SilverStripe\\Assets\\Folder', 'SilverStripe\\Assets\\Image', 'WeDevelop\\SvgImage\\Assets\\Svg') THEN "File_Live"."Bildunterschrift" WHEN "File_Live"."ClassName" IN ('SilverStripe\\Assets\\Image', 'WeDevelop\\SvgImage\\Assets\\Svg') THEN "Image_Live"."Bildunterschrift" WHEN "File_Live"."ClassName" IN ('SilverStripe\\Assets\\Image', 'WeDevelop\\SvgImage\\Assets\\Svg') THEN "Image_Live"."Bildunterschrift" ELSE NULL END AS "Bildunterschrift", CASE WHEN "File_Live"."ClassName" IN ('SilverStripe\\Assets\\File', 'SilverStripe\\Assets\\Folder', 'SilverStripe\\Assets\\Image', 'WeDevelop\\SvgImage\\Assets\\Svg') THEN "File_Live"."AltText" WHEN "File_Live"."ClassName" IN ('SilverStripe\\Assets\\Image', 'WeDevelop\\SvgImage\\Assets\\Svg') THEN "Image_Live"."AltText" WHEN "File_Live"."ClassName" IN ('SilverStripe\\Assets\\Image', 'WeDevelop\\SvgImage\\Assets\\Svg') THEN "Image_Live"."AltText" ELSE NULL END AS "AltText", "File_Live"."Version", "File_Live"."CanViewType", "File_Live"."CanEditType", "File_Live"."Name", "File_Live"."Title", "File_Live"."ShowInSearch", "File_Live"."ParentID", "File_Live"."OwnerID", "File_Live"."FileHash", "File_Live"."FileFilename", "File_Live"."FileVariant", "Image_Live"."FocusPointX", "Image_Live"."FocusPointY", "Image_Live"."FocusPointWidth", "Image_Live"."FocusPointHeight", "File_Live"."ID",
CASE WHEN "File_Live"."ClassName" IS NOT NULL THEN "File_Live"."ClassName"
ELSE 'SilverStripe\\Assets\\File' END AS "RecordClassName"
FROM "File_Live" LEFT JOIN "Image_Live" ON "Image_Live"."ID" = "File_Live"."ID"
WHERE ("File_Live"."ID" = ?)
AND ("File_Live"."ClassName" IN (?, ?))
ORDER BY "File_Live"."Name" ASC
LIMIT 1
0.0005s
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"."DontShowCopy" WHEN "File_Live"."ClassName" IN ('SilverStripe\\Assets\\Image', 'WeDevelop\\SvgImage\\Assets\\Svg') THEN "Image_Live"."DontShowCopy" WHEN "File_Live"."ClassName" IN ('SilverStripe\\Assets\\Image', 'WeDevelop\\SvgImage\\Assets\\Svg') THEN "Image_Live"."DontShowCopy" ELSE NULL END AS "DontShowCopy", CASE WHEN "File_Live"."ClassName" IN ('SilverStripe\\Assets\\File', 'SilverStripe\\Assets\\Folder', 'SilverStripe\\Assets\\Image', 'WeDevelop\\SvgImage\\Assets\\Svg') THEN "File_Live"."Bildunterschrift" WHEN "File_Live"."ClassName" IN ('SilverStripe\\Assets\\Image', 'WeDevelop\\SvgImage\\Assets\\Svg') THEN "Image_Live"."Bildunterschrift" WHEN "File_Live"."ClassName" IN ('SilverStripe\\Assets\\Image', 'WeDevelop\\SvgImage\\Assets\\Svg') THEN "Image_Live"."Bildunterschrift" ELSE NULL END AS "Bildunterschrift", CASE WHEN "File_Live"."ClassName" IN ('SilverStripe\\Assets\\File', 'SilverStripe\\Assets\\Folder', 'SilverStripe\\Assets\\Image', 'WeDevelop\\SvgImage\\Assets\\Svg') THEN "File_Live"."AltText" WHEN "File_Live"."ClassName" IN ('SilverStripe\\Assets\\Image', 'WeDevelop\\SvgImage\\Assets\\Svg') THEN "Image_Live"."AltText" WHEN "File_Live"."ClassName" IN ('SilverStripe\\Assets\\Image', 'WeDevelop\\SvgImage\\Assets\\Svg') THEN "Image_Live"."AltText" ELSE NULL END AS "AltText", "File_Live"."Version", "File_Live"."CanViewType", "File_Live"."CanEditType", "File_Live"."Name", "File_Live"."Title", "File_Live"."ShowInSearch", "File_Live"."ParentID", "File_Live"."OwnerID", "File_Live"."FileHash", "File_Live"."FileFilename", "File_Live"."FileVariant", "Image_Live"."FocusPointX", "Image_Live"."FocusPointY", "Image_Live"."FocusPointWidth", "Image_Live"."FocusPointHeight", "File_Live"."ID",
CASE WHEN "File_Live"."ClassName" IS NOT NULL THEN "File_Live"."ClassName"
ELSE 'SilverStripe\\Assets\\File' END AS "RecordClassName"
FROM "File_Live" LEFT JOIN "Image_Live" ON "Image_Live"."ID" = "File_Live"."ID"
WHERE ("File_Live"."ID" = ?)
AND ("File_Live"."ClassName" IN (?, ?))
ORDER BY "File_Live"."Name" ASC
LIMIT 1
0.0004s
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"."DontShowCopy" WHEN "File_Live"."ClassName" IN ('SilverStripe\\Assets\\Image', 'WeDevelop\\SvgImage\\Assets\\Svg') THEN "Image_Live"."DontShowCopy" WHEN "File_Live"."ClassName" IN ('SilverStripe\\Assets\\Image', 'WeDevelop\\SvgImage\\Assets\\Svg') THEN "Image_Live"."DontShowCopy" ELSE NULL END AS "DontShowCopy", CASE WHEN "File_Live"."ClassName" IN ('SilverStripe\\Assets\\File', 'SilverStripe\\Assets\\Folder', 'SilverStripe\\Assets\\Image', 'WeDevelop\\SvgImage\\Assets\\Svg') THEN "File_Live"."Bildunterschrift" WHEN "File_Live"."ClassName" IN ('SilverStripe\\Assets\\Image', 'WeDevelop\\SvgImage\\Assets\\Svg') THEN "Image_Live"."Bildunterschrift" WHEN "File_Live"."ClassName" IN ('SilverStripe\\Assets\\Image', 'WeDevelop\\SvgImage\\Assets\\Svg') THEN "Image_Live"."Bildunterschrift" ELSE NULL END AS "Bildunterschrift", CASE WHEN "File_Live"."ClassName" IN ('SilverStripe\\Assets\\File', 'SilverStripe\\Assets\\Folder', 'SilverStripe\\Assets\\Image', 'WeDevelop\\SvgImage\\Assets\\Svg') THEN "File_Live"."AltText" WHEN "File_Live"."ClassName" IN ('SilverStripe\\Assets\\Image', 'WeDevelop\\SvgImage\\Assets\\Svg') THEN "Image_Live"."AltText" WHEN "File_Live"."ClassName" IN ('SilverStripe\\Assets\\Image', 'WeDevelop\\SvgImage\\Assets\\Svg') THEN "Image_Live"."AltText" ELSE NULL END AS "AltText", "File_Live"."Version", "File_Live"."CanViewType", "File_Live"."CanEditType", "File_Live"."Name", "File_Live"."Title", "File_Live"."ShowInSearch", "File_Live"."ParentID", "File_Live"."OwnerID", "File_Live"."FileHash", "File_Live"."FileFilename", "File_Live"."FileVariant", "Image_Live"."FocusPointX", "Image_Live"."FocusPointY", "Image_Live"."FocusPointWidth", "Image_Live"."FocusPointHeight", "File_Live"."ID",
CASE WHEN "File_Live"."ClassName" IS NOT NULL THEN "File_Live"."ClassName"
ELSE 'SilverStripe\\Assets\\File' END AS "RecordClassName"
FROM "File_Live" LEFT JOIN "Image_Live" ON "Image_Live"."ID" = "File_Live"."ID"
WHERE ("File_Live"."ID" = ?)
AND ("File_Live"."ClassName" IN (?, ?))
ORDER BY "File_Live"."Name" ASC
LIMIT 1
0.0004s
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"."DontShowCopy" WHEN "File_Live"."ClassName" IN ('SilverStripe\\Assets\\Image', 'WeDevelop\\SvgImage\\Assets\\Svg') THEN "Image_Live"."DontShowCopy" WHEN "File_Live"."ClassName" IN ('SilverStripe\\Assets\\Image', 'WeDevelop\\SvgImage\\Assets\\Svg') THEN "Image_Live"."DontShowCopy" ELSE NULL END AS "DontShowCopy", CASE WHEN "File_Live"."ClassName" IN ('SilverStripe\\Assets\\File', 'SilverStripe\\Assets\\Folder', 'SilverStripe\\Assets\\Image', 'WeDevelop\\SvgImage\\Assets\\Svg') THEN "File_Live"."Bildunterschrift" WHEN "File_Live"."ClassName" IN ('SilverStripe\\Assets\\Image', 'WeDevelop\\SvgImage\\Assets\\Svg') THEN "Image_Live"."Bildunterschrift" WHEN "File_Live"."ClassName" IN ('SilverStripe\\Assets\\Image', 'WeDevelop\\SvgImage\\Assets\\Svg') THEN "Image_Live"."Bildunterschrift" ELSE NULL END AS "Bildunterschrift", CASE WHEN "File_Live"."ClassName" IN ('SilverStripe\\Assets\\File', 'SilverStripe\\Assets\\Folder', 'SilverStripe\\Assets\\Image', 'WeDevelop\\SvgImage\\Assets\\Svg') THEN "File_Live"."AltText" WHEN "File_Live"."ClassName" IN ('SilverStripe\\Assets\\Image', 'WeDevelop\\SvgImage\\Assets\\Svg') THEN "Image_Live"."AltText" WHEN "File_Live"."ClassName" IN ('SilverStripe\\Assets\\Image', 'WeDevelop\\SvgImage\\Assets\\Svg') THEN "Image_Live"."AltText" ELSE NULL END AS "AltText", "File_Live"."Version", "File_Live"."CanViewType", "File_Live"."CanEditType", "File_Live"."Name", "File_Live"."Title", "File_Live"."ShowInSearch", "File_Live"."ParentID", "File_Live"."OwnerID", "File_Live"."FileHash", "File_Live"."FileFilename", "File_Live"."FileVariant", "Image_Live"."FocusPointX", "Image_Live"."FocusPointY", "Image_Live"."FocusPointWidth", "Image_Live"."FocusPointHeight", "File_Live"."ID",
CASE WHEN "File_Live"."ClassName" IS NOT NULL THEN "File_Live"."ClassName"
ELSE 'SilverStripe\\Assets\\File' END AS "RecordClassName"
FROM "File_Live" LEFT JOIN "Image_Live" ON "Image_Live"."ID" = "File_Live"."ID"
WHERE ("File_Live"."ID" = ?)
AND ("File_Live"."ClassName" IN (?, ?))
ORDER BY "File_Live"."Name" ASC
LIMIT 1
0.0004s
0020: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", CASE
WHEN "SiteTree_Localised_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.0006s
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.0003s
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.0007s
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.0004s
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.0005s
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.0004s
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.0004s
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.0003s
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.0005s
0030: SELECT CASE WHEN EXISTS(SELECT *
FROM "MenuSet"
WHERE ("MenuSet"."Name" = ?)) THEN 1 ELSE 0 END
0.0002s
0031: SELECT DISTINCT "MenuSet"."ClassName", "MenuSet"."LastEdited", "MenuSet"."Created", "MenuSet"."Name", "MenuSet"."Description", "MenuSet"."Sort", "MenuSet"."ID",
CASE WHEN "MenuSet"."ClassName" IS NOT NULL THEN "MenuSet"."ClassName"
ELSE 'Heyday\\MenuManager\\MenuSet' END AS "RecordClassName"
FROM "MenuSet"
WHERE ("MenuSet"."Name" = ?)
ORDER BY "MenuSet"."Sort" ASC
LIMIT 1
0.0002s
0032: SELECT DISTINCT "MenuSet"."ClassName", "MenuSet"."LastEdited", "MenuSet"."Created", "MenuSet"."Name", "MenuSet"."Description", "MenuSet"."Sort", "MenuSet"."ID",
CASE WHEN "MenuSet"."ClassName" IS NOT NULL THEN "MenuSet"."ClassName"
ELSE 'Heyday\\MenuManager\\MenuSet' END AS "RecordClassName"
FROM "MenuSet"
WHERE ("MenuSet"."Name" = ?)
ORDER BY "MenuSet"."Sort" ASC
LIMIT 1
0.0003s
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.0003s
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.0002s
0035: SELECT CASE WHEN EXISTS(SELECT *
FROM "MenuSet"
WHERE ("MenuSet"."Name" = ?)) THEN 1 ELSE 0 END
0.0002s
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.0002s
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.0002s
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.0002s
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.0002s
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.0003s
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.0002s
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"."DontShowCopy" WHEN "File_Live"."ClassName" IN ('SilverStripe\\Assets\\Image', 'WeDevelop\\SvgImage\\Assets\\Svg') THEN "Image_Live"."DontShowCopy" WHEN "File_Live"."ClassName" IN ('SilverStripe\\Assets\\Image', 'WeDevelop\\SvgImage\\Assets\\Svg') THEN "Image_Live"."DontShowCopy" ELSE NULL END AS "DontShowCopy", 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.0003s
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.0005s
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.0001s
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 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
0057: SELECT CASE WHEN EXISTS(SELECT *
FROM "PersonEntry" INNER JOIN "Element_Persons" ON "Element_Persons"."PersonEntryID" = "PersonEntry"."ID" LEFT JOIN "PersonEntry_Localised" AS "PersonEntry_Localised_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
0058: SELECT "PersonEntry"."ID", "PersonEntry"."Name" AS "_SortColumn0"
FROM "PersonEntry" INNER JOIN "Element_Persons" ON "Element_Persons"."PersonEntryID" = "PersonEntry"."ID" LEFT JOIN "PersonEntry_Localised" AS "PersonEntry_Localised_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
0059: SELECT DISTINCT count(DISTINCT "PersonEntry"."ID") AS "Count"
FROM "PersonEntry" INNER JOIN "Element_Persons" ON "Element_Persons"."PersonEntryID" = "PersonEntry"."ID" LEFT JOIN "PersonEntry_Localised" AS "PersonEntry_Localised_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
0060: 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
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"."DontShowCopy" WHEN "File_Live"."ClassName" IN ('SilverStripe\\Assets\\Image', 'WeDevelop\\SvgImage\\Assets\\Svg') THEN "Image_Live"."DontShowCopy" WHEN "File_Live"."ClassName" IN ('SilverStripe\\Assets\\Image', 'WeDevelop\\SvgImage\\Assets\\Svg') THEN "Image_Live"."DontShowCopy" ELSE NULL END AS "DontShowCopy", 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 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
0063: SELECT CASE WHEN EXISTS(SELECT *
FROM "PersonEntry" INNER JOIN "Element_Persons" ON "Element_Persons"."PersonEntryID" = "PersonEntry"."ID" LEFT JOIN "PersonEntry_Localised" AS "PersonEntry_Localised_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
0064: SELECT "PersonEntry"."ID", "PersonEntry"."Name" AS "_SortColumn0"
FROM "PersonEntry" INNER JOIN "Element_Persons" ON "Element_Persons"."PersonEntryID" = "PersonEntry"."ID" LEFT JOIN "PersonEntry_Localised" AS "PersonEntry_Localised_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.0003s
0065: SELECT DISTINCT count(DISTINCT "PersonEntry"."ID") AS "Count"
FROM "PersonEntry" INNER JOIN "Element_Persons" ON "Element_Persons"."PersonEntryID" = "PersonEntry"."ID" LEFT JOIN "PersonEntry_Localised" AS "PersonEntry_Localised_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
0066: 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
0067: 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"."DontShowCopy" WHEN "File_Live"."ClassName" IN ('SilverStripe\\Assets\\Image', 'WeDevelop\\SvgImage\\Assets\\Svg') THEN "Image_Live"."DontShowCopy" WHEN "File_Live"."ClassName" IN ('SilverStripe\\Assets\\Image', 'WeDevelop\\SvgImage\\Assets\\Svg') THEN "Image_Live"."DontShowCopy" ELSE NULL END AS "DontShowCopy", 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.0004s
0068: 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.0003s
0069: 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.0003s
0070: 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
0071: 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
0072: 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.0003s
0073: 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
0074: 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
0075: 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
0076: 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
0077: 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.0003s
0078: 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"."DontShowCopy" WHEN "File_Live"."ClassName" IN ('SilverStripe\\Assets\\Image', 'WeDevelop\\SvgImage\\Assets\\Svg') THEN "Image_Live"."DontShowCopy" WHEN "File_Live"."ClassName" IN ('SilverStripe\\Assets\\Image', 'WeDevelop\\SvgImage\\Assets\\Svg') THEN "Image_Live"."DontShowCopy" ELSE NULL END AS "DontShowCopy", 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.0004s
0079: 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.0003s
0080: 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.0003s
0081: 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
0082: 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
0083: 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.0003s
0084: SELECT DISTINCT count(DISTINCT "File_Live"."ID") AS "Count"
FROM "File_Live" LEFT JOIN "Image_Live" ON "Image_Live"."ID" = "File_Live"."ID" INNER JOIN "ImageGalleryElement_Images" ON "ImageGalleryElement_Images"."ImageID" = "File_Live"."ID"
WHERE ("ImageGalleryElement_Images"."ImageGalleryElementID" = ?)
AND ("File_Live"."ClassName" IN (?, ?))
0.0003s
0085: 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.0003s
0086: 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
0087: 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
0088: 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
0089: 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"."DontShowCopy" WHEN "File_Live"."ClassName" IN ('SilverStripe\\Assets\\Image', 'WeDevelop\\SvgImage\\Assets\\Svg') THEN "Image_Live"."DontShowCopy" WHEN "File_Live"."ClassName" IN ('SilverStripe\\Assets\\Image', 'WeDevelop\\SvgImage\\Assets\\Svg') THEN "Image_Live"."DontShowCopy" ELSE NULL END AS "DontShowCopy", 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.0004s
0090: 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
0091: 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
0092: 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
0093: 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.0004s
0094: 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
0095: 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"."DontShowCopy" WHEN "File_Live"."ClassName" IN ('SilverStripe\\Assets\\Image', 'WeDevelop\\SvgImage\\Assets\\Svg') THEN "Image_Live"."DontShowCopy" WHEN "File_Live"."ClassName" IN ('SilverStripe\\Assets\\Image', 'WeDevelop\\SvgImage\\Assets\\Svg') THEN "Image_Live"."DontShowCopy" ELSE NULL END AS "DontShowCopy", 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
0096: 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
0097: 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
0098: 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
0099: 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
0100: 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
0101: 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"."DontShowCopy" WHEN "File_Live"."ClassName" IN ('SilverStripe\\Assets\\Image', 'WeDevelop\\SvgImage\\Assets\\Svg') THEN "Image_Live"."DontShowCopy" WHEN "File_Live"."ClassName" IN ('SilverStripe\\Assets\\Image', 'WeDevelop\\SvgImage\\Assets\\Svg') THEN "Image_Live"."DontShowCopy" ELSE NULL END AS "DontShowCopy", 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
0102: 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
0103: 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
0104: 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
0105: 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
0106: 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.0003s
0107: 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
0108: 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
0109: 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
0110: 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
0111: 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
0112: 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"."DontShowCopy" WHEN "File_Live"."ClassName" IN ('SilverStripe\\Assets\\Image', 'WeDevelop\\SvgImage\\Assets\\Svg') THEN "Image_Live"."DontShowCopy" WHEN "File_Live"."ClassName" IN ('SilverStripe\\Assets\\Image', 'WeDevelop\\SvgImage\\Assets\\Svg') THEN "Image_Live"."DontShowCopy" ELSE NULL END AS "DontShowCopy", 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
0113: 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
0114: 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
0115: 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
0116: 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
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.0002s
0119: 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
0120: 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
0121: 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
0122: 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"."DontShowCopy" WHEN "File_Live"."ClassName" IN ('SilverStripe\\Assets\\Image', 'WeDevelop\\SvgImage\\Assets\\Svg') THEN "Image_Live"."DontShowCopy" WHEN "File_Live"."ClassName" IN ('SilverStripe\\Assets\\Image', 'WeDevelop\\SvgImage\\Assets\\Svg') THEN "Image_Live"."DontShowCopy" ELSE NULL END AS "DontShowCopy", 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
0123: 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
0124: 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
0125: 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
0126: 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
0127: 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
0128: 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
0129: 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
0130: 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.0001s
0131: 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
0132: 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
0133: 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"."DontShowCopy" WHEN "File_Live"."ClassName" IN ('SilverStripe\\Assets\\Image', 'WeDevelop\\SvgImage\\Assets\\Svg') THEN "Image_Live"."DontShowCopy" WHEN "File_Live"."ClassName" IN ('SilverStripe\\Assets\\Image', 'WeDevelop\\SvgImage\\Assets\\Svg') THEN "Image_Live"."DontShowCopy" ELSE NULL END AS "DontShowCopy", 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
0134: 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
0135: 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
0136: 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
0137: 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
0138: 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
0139: 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
0140: 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
0141: 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
0142: 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
0143: 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
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.0004s
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"."DontShowCopy" WHEN "File_Live"."ClassName" IN ('SilverStripe\\Assets\\Image', 'WeDevelop\\SvgImage\\Assets\\Svg') THEN "Image_Live"."DontShowCopy" WHEN "File_Live"."ClassName" IN ('SilverStripe\\Assets\\Image', 'WeDevelop\\SvgImage\\Assets\\Svg') THEN "Image_Live"."DontShowCopy" ELSE NULL END AS "DontShowCopy", 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"."DontShowCopy" WHEN "File_Live"."ClassName" IN ('SilverStripe\\Assets\\Image', 'WeDevelop\\SvgImage\\Assets\\Svg') THEN "Image_Live"."DontShowCopy" WHEN "File_Live"."ClassName" IN ('SilverStripe\\Assets\\Image', 'WeDevelop\\SvgImage\\Assets\\Svg') THEN "Image_Live"."DontShowCopy" ELSE NULL END AS "DontShowCopy", 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
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"."DontShowCopy" WHEN "File_Live"."ClassName" IN ('SilverStripe\\Assets\\Image', 'WeDevelop\\SvgImage\\Assets\\Svg') THEN "Image_Live"."DontShowCopy" WHEN "File_Live"."ClassName" IN ('SilverStripe\\Assets\\Image', 'WeDevelop\\SvgImage\\Assets\\Svg') THEN "Image_Live"."DontShowCopy" ELSE NULL END AS "DontShowCopy", 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"."DontShowCopy" WHEN "File_Live"."ClassName" IN ('SilverStripe\\Assets\\Image', 'WeDevelop\\SvgImage\\Assets\\Svg') THEN "Image_Live"."DontShowCopy" WHEN "File_Live"."ClassName" IN ('SilverStripe\\Assets\\Image', 'WeDevelop\\SvgImage\\Assets\\Svg') THEN "Image_Live"."DontShowCopy" ELSE NULL END AS "DontShowCopy", 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.0001s
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.0002s
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.0004s
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.0003s
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.0004s
Our father, Alexander Tal, was born 24 October 1903 in Amsterdam. He was named Alexander and, in short, was called Sander, after his maternal grandfather.
His name in Hebrew was Avraham Eliezer Dov, a rather long name because his grandfather had “Eliezer” (God is my help) added to his name in the hope that it would save him when he fell ill and there was fear for his life.
The house where Father, Sander, was born stood by a wide water canal in the Jewish Quarter of Amsterdam. After World War I, the family left the quarter for a beautiful home on the waterfront of the Amstel River.
In Amsterdam, the big and beautiful houses are usually by the water, and the view from them is more extensive.
After World War II, the Jewish Quarter was empty of its inhabitants since most of them perished in the Holocaust. All the houses in the area where Sander was born were demolished, and a new town hall and opera house were built in their place.
Father attended a general high school, and in addition, he studied Torah (Old Testament) and Hebrew language.
He was active in the Zionist-religious youth movement Zichron Ya’acov. He made many friendships there and was liked and appreciated in his circle of acquaintances.
Zionism was founded at the end of the 19th century as a political movement. Its members demanded their own Jewish state. Jews had suffered religious and political persecution for centuries.
The Zionists wanted Jews to be protected from antisemitic exclusion and violence and for Jewish culture and religion to thrive. The movement was named after Zion, the biblical and historical place from which the Jews had been expelled into the diaspora. The Zionists wanted to build their own community in Jerusalem and Palestine.
Religious Jews formed a distinct faction within the Zionist movement. They organised themselves into youth movements such as Zichron Ya’acov and Mizrahi. Fré and Sander Tal were active in these.
Later, together with our mother, he was a guide in the summer camps of the Mizrahi youth movement. After his matriculation exams, in 1922, he began studying electrical engineering at the Technical University in Delft.
As a teenager, he was already interested in electrical engineering and had a primitive crystal radio that he built.
On 11 November 1918, he picked up, on this radio, the announcement of the armistice that ended World War I.
During his studies, Father did not live in Delft but commuted daily from Amsterdam. It took about an hour and a half each way. He cycled to the train station, took the train, and again cycled to the university. On the one hand, the effort made it easy to maintain a kosher and religious lifestyle. But on the other hand, because of travel and his absence from lectures on Shabbat, it took him an additional year to finish his studies.
On vacations from school in Delft, Father served in a kind of “academic reserve”, a substitute for compulsory service in the Dutch army.