0007: 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"."ImageID", "Fluent_Locale"."DomainID", "Fluent_Locale"."ID", CASE WHEN "Fluent_Locale"."ClassName" IS NOT NULL THEN "Fluent_Locale"."ClassName" ELSE 'TractorCow\\Fluent\\Model\\Locale' END AS "RecordClassName" FROM "Fluent_Locale" ORDER BY "Fluent_Locale"."Locale" ASC 0.0002s

0009: SELECT DISTINCT "Fluent_Domain"."ClassName", "Fluent_Domain"."LastEdited", "Fluent_Domain"."Created", "Fluent_Domain"."Domain", "Fluent_Domain"."DefaultLocaleID", "Fluent_Domain"."ID", CASE WHEN "Fluent_Domain"."ClassName" IS NOT NULL THEN "Fluent_Domain"."ClassName" ELSE 'TractorCow\\Fluent\\Model\\Domain' END AS "RecordClassName" FROM "Fluent_Domain" 0.0002s

0010: SELECT DISTINCT "WebResource"."ClassName", "WebResource"."LastEdited", "WebResource"."Created", "WebResource"."Title", "WebResource"."Identifier", "WebResource"."Locked", "WebResource"."CategoryID", "WebResource"."ID", CASE WHEN "WebResource"."ClassName" IS NOT NULL THEN "WebResource"."ClassName" ELSE 'SCS\\Privacy\\Model\\Resource\\WebResource' END AS "RecordClassName" FROM "WebResource" WHERE ("WebResource"."ClassName" IN (?)) ORDER BY "WebResource"."Title" ASC 0.0003s

0011: SELECT DISTINCT "WebResource"."ClassName", "WebResource"."LastEdited", "WebResource"."Created", "WebResource"."Title", "WebResource"."Identifier", "WebResource"."Locked", "WebResource"."CategoryID", "WebResource"."ID", CASE WHEN "WebResource"."ClassName" IS NOT NULL THEN "WebResource"."ClassName" ELSE 'SCS\\Privacy\\Model\\Resource\\WebResource' END AS "RecordClassName" FROM "WebResource" ORDER BY "WebResource"."Title" ASC 0.0002s

0012: SELECT DISTINCT "Fluent_FallbackLocale"."ClassName" AS "Fluent_FallbackLocale_ClassName", "Fluent_FallbackLocale"."LastEdited" AS "Fluent_FallbackLocale_LastEdited", "Fluent_FallbackLocale"."Created" AS "Fluent_FallbackLocale_Created", "Fluent_FallbackLocale"."Sort" AS "Fluent_FallbackLocale_Sort", "Fluent_FallbackLocale"."ParentID" AS "Fluent_FallbackLocale_ParentID", "Fluent_FallbackLocale"."LocaleID" AS "Fluent_FallbackLocale_LocaleID", "Fluent_FallbackLocale"."ID" AS "Fluent_FallbackLocale_ID", "Fluent_FallbackLocale"."RecordClassName" AS "Fluent_FallbackLocale_RecordClassName", "Fluent_Locale"."ClassName", "Fluent_Locale"."LastEdited", "Fluent_Locale"."Created", "Fluent_Locale"."Title", "Fluent_Locale"."Locale", "Fluent_Locale"."URLSegment", "Fluent_Locale"."IsGlobalDefault", "Fluent_Locale"."ImageID", "Fluent_Locale"."DomainID", "Fluent_Locale"."ID", CASE WHEN "Fluent_Locale"."ClassName" IS NOT NULL THEN "Fluent_Locale"."ClassName" ELSE 'TractorCow\\Fluent\\Model\\Locale' END AS "RecordClassName" FROM "Fluent_Locale" INNER JOIN (SELECT DISTINCT "Fluent_FallbackLocale"."ClassName", "Fluent_FallbackLocale"."LastEdited", "Fluent_FallbackLocale"."Created", "Fluent_FallbackLocale"."Sort", "Fluent_FallbackLocale"."ParentID", "Fluent_FallbackLocale"."LocaleID", "Fluent_FallbackLocale"."ID", CASE WHEN "Fluent_FallbackLocale"."ClassName" IS NOT NULL THEN "Fluent_FallbackLocale"."ClassName" ELSE 'TractorCow\\Fluent\\Model\\FallbackLocale' END AS "RecordClassName" FROM "Fluent_FallbackLocale" WHERE ("Fluent_FallbackLocale"."ParentID" = ?)) AS "Fluent_FallbackLocale" ON "Fluent_FallbackLocale"."LocaleID" = "Fluent_Locale"."ID" ORDER BY "Fluent_Locale"."Locale" ASC 0.0003s

0013: SELECT DISTINCT "ResourceCategory"."ClassName", "ResourceCategory"."LastEdited", "ResourceCategory"."Created", CASE WHEN "ResourceCategory_Localised_de_DE"."ID" IS NOT NULL THEN "ResourceCategory_Localised_de_DE"."ResourceKey" ELSE "ResourceCategory"."ResourceKey" END AS "ResourceKey", CASE WHEN "ResourceCategory_Localised_de_DE"."ID" IS NOT NULL THEN "ResourceCategory_Localised_de_DE"."Title" ELSE "ResourceCategory"."Title" END AS "Title", "ResourceCategory"."Classification", "ResourceCategory"."Locked", "ResourceCategory"."Sort", "ResourceCategory"."ID", CASE WHEN "ResourceCategory"."ClassName" IS NOT NULL THEN "ResourceCategory"."ClassName" ELSE 'SCS\\Privacy\\Model\\ResourceCategory' END AS "RecordClassName", 'de_DE' AS "Locale", CASE WHEN "ResourceCategory_Localised_de_DE"."ID" IS NOT NULL THEN 'de_DE' ELSE NULL END AS "SourceLocale" FROM "ResourceCategory" LEFT JOIN "ResourceCategory_Localised" AS "ResourceCategory_Localised_de_DE" ON "ResourceCategory"."ID" = "ResourceCategory_Localised_de_DE"."RecordID" AND "ResourceCategory_Localised_de_DE"."Locale" = ? WHERE ("ResourceCategory"."ID" = ?) AND (("ResourceCategory_Localised_de_DE"."ID" IS NOT NULL)) ORDER BY "ResourceCategory"."Sort" ASC LIMIT 1 0.0003s

0014: SELECT IFNULL(SHA2(CONCAT(GROUP_CONCAT(wr.Identifier), rc.ID, 'v20220211lfmYRzHiY5zSaA5wwsPDExo'), 256), '') FROM ResourceCategory rc JOIN WebResource wr ON wr.CategoryID = rc.ID WHERE rc.ID = 1 0.0002s

0015: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", CASE WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."MetaTitle" ELSE "SiteTree_Live"."MetaTitle" END AS "MetaTitle", "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"."ParentID", "SiteTree_Live"."ID", CASE WHEN "SiteTree_Live"."ClassName" IS NOT NULL THEN "SiteTree_Live"."ClassName" ELSE 'SilverStripe\\CMS\\Model\\SiteTree' END AS "RecordClassName", 'de_DE' AS "Locale", CASE WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN 'de_DE' ELSE NULL END AS "SourceLocale" FROM "SiteTree_Live" LEFT JOIN "SiteTree_Localised_Live" AS "SiteTree_Localised_de_DE" ON "SiteTree_Live"."ID" = "SiteTree_Localised_de_DE"."RecordID" AND "SiteTree_Localised_de_DE"."Locale" = ? WHERE (COALESCE("SiteTree_Localised_de_DE"."URLSegment", "SiteTree_Live"."URLSegment") = ?) AND ("SiteTree_Live"."ParentID" = ?) AND (("SiteTree_Localised_de_DE"."ID" IS NOT NULL)) ORDER BY "SiteTree_Live"."Sort" ASC LIMIT 1 0.0004s

0016: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", CASE WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."MetaTitle" ELSE "SiteTree_Live"."MetaTitle" END AS "MetaTitle", "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"."ParentID", "SiteTree_Live"."ID", CASE WHEN "SiteTree_Live"."ClassName" IS NOT NULL THEN "SiteTree_Live"."ClassName" ELSE 'SilverStripe\\CMS\\Model\\SiteTree' END AS "RecordClassName", 'de_DE' AS "Locale", CASE WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN 'de_DE' ELSE NULL END AS "SourceLocale" FROM "SiteTree_Live" LEFT JOIN "SiteTree_Localised_Live" AS "SiteTree_Localised_de_DE" ON "SiteTree_Live"."ID" = "SiteTree_Localised_de_DE"."RecordID" AND "SiteTree_Localised_de_DE"."Locale" = ? WHERE ("SiteTree_Live"."ParentID" = ?) AND (COALESCE("SiteTree_Localised_de_DE"."URLSegment", "SiteTree_Live"."URLSegment") = ?) AND (("SiteTree_Localised_de_DE"."ID" IS NOT NULL)) ORDER BY "SiteTree_Live"."Sort" ASC LIMIT 1 0.0004s

0017: SELECT DISTINCT "SiteConfig"."ClassName", "SiteConfig"."LastEdited", "SiteConfig"."Created", CASE WHEN "SiteConfig_Localised_de_DE"."ID" IS NOT NULL THEN "SiteConfig_Localised_de_DE"."DataPolicyMessage" ELSE "SiteConfig"."DataPolicyMessage" END AS "DataPolicyMessage", CASE WHEN "SiteConfig_Localised_de_DE"."ID" IS NOT NULL THEN "SiteConfig_Localised_de_DE"."NewsPreviewTitle" ELSE "SiteConfig"."NewsPreviewTitle" END AS "NewsPreviewTitle", "SiteConfig"."EyeAble_RequestDateTestLicense", "SiteConfig"."EyeAble_ExpirationDateTestLicense", CASE WHEN "SiteConfig_Localised_de_DE"."ID" IS NOT NULL THEN "SiteConfig_Localised_de_DE"."EyeAble_LicenseNumber" ELSE "SiteConfig"."EyeAble_LicenseNumber" END AS "EyeAble_LicenseNumber", "SiteConfig"."EyeAble_Hosting", CASE WHEN "SiteConfig_Localised_de_DE"."ID" IS NOT NULL THEN "SiteConfig_Localised_de_DE"."CompanyName" ELSE "SiteConfig"."CompanyName" END AS "CompanyName", "SiteConfig"."Address", "SiteConfig"."Zip", "SiteConfig"."City", "SiteConfig"."Email", "SiteConfig"."Phone", CASE WHEN "SiteConfig_Localised_de_DE"."ID" IS NOT NULL THEN "SiteConfig_Localised_de_DE"."Title" ELSE "SiteConfig"."Title" END AS "Title", CASE WHEN "SiteConfig_Localised_de_DE"."ID" IS NOT NULL THEN "SiteConfig_Localised_de_DE"."Tagline" ELSE "SiteConfig"."Tagline" END AS "Tagline", "SiteConfig"."CanViewType", "SiteConfig"."CanEditType", "SiteConfig"."CanCreateTopLevelType", "SiteConfig"."DataPolicyPageID", "SiteConfig"."NewsHolderID", "SiteConfig"."LogoID", "SiteConfig"."ID", CASE WHEN "SiteConfig"."ClassName" IS NOT NULL THEN "SiteConfig"."ClassName" ELSE 'SilverStripe\\SiteConfig\\SiteConfig' END AS "RecordClassName", 'de_DE' AS "Locale", CASE WHEN "SiteConfig_Localised_de_DE"."ID" IS NOT NULL THEN 'de_DE' ELSE NULL END AS "SourceLocale" FROM "SiteConfig" LEFT JOIN "SiteConfig_Localised" AS "SiteConfig_Localised_de_DE" ON "SiteConfig"."ID" = "SiteConfig_Localised_de_DE"."RecordID" AND "SiteConfig_Localised_de_DE"."Locale" = ? LIMIT 1 0.0003s

0018: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", CASE WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."MetaTitle" ELSE "SiteTree_Live"."MetaTitle" END AS "MetaTitle", "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"."ParentID", "SiteTree_Live"."ID", CASE WHEN "SiteTree_Live"."ClassName" IS NOT NULL THEN "SiteTree_Live"."ClassName" ELSE 'SilverStripe\\CMS\\Model\\SiteTree' END AS "RecordClassName", 'de_DE' AS "Locale", CASE WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN 'de_DE' ELSE NULL END AS "SourceLocale" FROM "SiteTree_Live" LEFT JOIN "SiteTree_Localised_Live" AS "SiteTree_Localised_de_DE" ON "SiteTree_Live"."ID" = "SiteTree_Localised_de_DE"."RecordID" AND "SiteTree_Localised_de_DE"."Locale" = ? WHERE ("SiteTree_Live"."ID" = ?) AND (("SiteTree_Localised_de_DE"."ID" IS NOT NULL)) ORDER BY "SiteTree_Live"."Sort" ASC LIMIT 1 0.0003s

0019: SELECT CASE WHEN EXISTS(SELECT * FROM "Fluent_Locale") THEN 1 ELSE 0 END 0.0002s

0020: 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"."ImageID", "Fluent_Locale"."DomainID", "Fluent_Locale"."ID", CASE WHEN "Fluent_Locale"."ClassName" IS NOT NULL THEN "Fluent_Locale"."ClassName" ELSE 'TractorCow\\Fluent\\Model\\Locale' END AS "RecordClassName" FROM "Fluent_Locale" ORDER BY "Fluent_Locale"."Locale" ASC 0.0001s

0021: SELECT DISTINCT "File_Live"."ClassName", "File_Live"."LastEdited", "File_Live"."Created", "File_Live"."Version", "File_Live"."UserFormUpload", "File_Live"."CanViewType", "File_Live"."CanEditType", "File_Live"."Name", "File_Live"."Title", "File_Live"."ShowInSearch", "File_Live"."ParentID", "File_Live"."OwnerID", "File_Live"."FileHash", "File_Live"."FileFilename", "File_Live"."FileVariant", "File_Live"."ID", CASE WHEN "File_Live"."ClassName" IS NOT NULL THEN "File_Live"."ClassName" ELSE 'SilverStripe\\Assets\\File' END AS "RecordClassName" FROM "File_Live" WHERE ("File_Live"."ID" = ?) ORDER BY "File_Live"."Name" ASC LIMIT 1 0.0003s

0022: SELECT CASE WHEN EXISTS(SELECT * FROM "Fluent_Locale") THEN 1 ELSE 0 END 0.0001s

0023: 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"."ImageID", "Fluent_Locale"."DomainID", "Fluent_Locale"."ID", CASE WHEN "Fluent_Locale"."ClassName" IS NOT NULL THEN "Fluent_Locale"."ClassName" ELSE 'TractorCow\\Fluent\\Model\\Locale' END AS "RecordClassName" FROM "Fluent_Locale" ORDER BY "Fluent_Locale"."Locale" ASC 0.0001s

0024: SELECT DISTINCT "File_Live"."ClassName", "File_Live"."LastEdited", "File_Live"."Created", "File_Live"."Version", "File_Live"."UserFormUpload", "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", "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

0025: SELECT DISTINCT "File_Live"."ClassName", "File_Live"."LastEdited", "File_Live"."Created", "File_Live"."Version", "File_Live"."UserFormUpload", "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", "File_Live"."ID", CASE WHEN "File_Live"."ClassName" IS NOT NULL THEN "File_Live"."ClassName" ELSE 'SilverStripe\\Assets\\File' END AS "RecordClassName" FROM "File_Live" LEFT JOIN "Image_Live" ON "Image_Live"."ID" = "File_Live"."ID" WHERE ("File_Live"."ID" = ?) AND ("File_Live"."ClassName" IN (?)) ORDER BY "File_Live"."Name" ASC LIMIT 1 0.0001s

0026: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", CASE WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."MetaTitle" ELSE "SiteTree_Live"."MetaTitle" END AS "MetaTitle", "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"."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"."ShowInMenus" = ?) AND ("SiteTree_Live"."ParentID" = ?) AND (("SiteTree_Localised_de_DE"."ID" IS NOT NULL)) ORDER BY "SiteTree_Live"."Sort" ASC 0.0004s

0027: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", CASE WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."MetaTitle" ELSE "SiteTree_Live"."MetaTitle" END AS "MetaTitle", "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"."ParentID", "SiteTree_Live"."ID", CASE WHEN "SiteTree_Live"."ClassName" IS NOT NULL THEN "SiteTree_Live"."ClassName" ELSE 'SilverStripe\\CMS\\Model\\SiteTree' END AS "RecordClassName", 'de_DE' AS "Locale", CASE WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN 'de_DE' ELSE NULL END AS "SourceLocale" FROM "SiteTree_Live" LEFT JOIN "SiteTree_Localised_Live" AS "SiteTree_Localised_de_DE" ON "SiteTree_Live"."ID" = "SiteTree_Localised_de_DE"."RecordID" AND "SiteTree_Localised_de_DE"."Locale" = ? WHERE ("SiteTree_Live"."ID" = ?) AND (("SiteTree_Localised_de_DE"."ID" IS NOT NULL)) ORDER BY "SiteTree_Live"."Sort" ASC LIMIT 1 0.0001s

0028: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", CASE WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."MetaTitle" ELSE "SiteTree_Live"."MetaTitle" END AS "MetaTitle", "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"."ParentID", "SiteTree_Live"."ID", CASE WHEN "SiteTree_Live"."ClassName" IS NOT NULL THEN "SiteTree_Live"."ClassName" ELSE 'SilverStripe\\CMS\\Model\\SiteTree' END AS "RecordClassName", 'de_DE' AS "Locale", CASE WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN 'de_DE' ELSE NULL END AS "SourceLocale" FROM "SiteTree_Live" LEFT JOIN "SiteTree_Localised_Live" AS "SiteTree_Localised_de_DE" ON "SiteTree_Live"."ID" = "SiteTree_Localised_de_DE"."RecordID" AND "SiteTree_Localised_de_DE"."Locale" = ? WHERE ("SiteTree_Live"."ParentID" <> "SiteTree_Live"."ID") AND ("SiteTree_Live"."ParentID" = ?) AND ("SiteTree_Live"."ShowInMenus" = ?) AND (("SiteTree_Localised_de_DE"."ID" IS NOT NULL)) ORDER BY "SiteTree_Live"."Sort" ASC 0.0003s

0029: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", CASE WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."MetaTitle" ELSE "SiteTree_Live"."MetaTitle" END AS "MetaTitle", "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"."ParentID", "SiteTree_Live"."ID", CASE WHEN "SiteTree_Live"."ClassName" IS NOT NULL THEN "SiteTree_Live"."ClassName" ELSE 'SilverStripe\\CMS\\Model\\SiteTree' END AS "RecordClassName", 'de_DE' AS "Locale", CASE WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN 'de_DE' ELSE NULL END AS "SourceLocale" FROM "SiteTree_Live" LEFT JOIN "SiteTree_Localised_Live" AS "SiteTree_Localised_de_DE" ON "SiteTree_Live"."ID" = "SiteTree_Localised_de_DE"."RecordID" AND "SiteTree_Localised_de_DE"."Locale" = ? WHERE ("SiteTree_Live"."ParentID" <> "SiteTree_Live"."ID") AND ("SiteTree_Live"."ParentID" = ?) AND ("SiteTree_Live"."ShowInMenus" = ?) AND (("SiteTree_Localised_de_DE"."ID" IS NOT NULL)) ORDER BY "SiteTree_Live"."Sort" ASC 0.0001s

0030: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", CASE WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."MetaTitle" ELSE "SiteTree_Live"."MetaTitle" END AS "MetaTitle", "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"."ParentID", "SiteTree_Live"."ID", CASE WHEN "SiteTree_Live"."ClassName" IS NOT NULL THEN "SiteTree_Live"."ClassName" ELSE 'SilverStripe\\CMS\\Model\\SiteTree' END AS "RecordClassName", 'de_DE' AS "Locale", CASE WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN 'de_DE' ELSE NULL END AS "SourceLocale" FROM "SiteTree_Live" LEFT JOIN "SiteTree_Localised_Live" AS "SiteTree_Localised_de_DE" ON "SiteTree_Live"."ID" = "SiteTree_Localised_de_DE"."RecordID" AND "SiteTree_Localised_de_DE"."Locale" = ? WHERE ("SiteTree_Live"."ID" = ?) AND (("SiteTree_Localised_de_DE"."ID" IS NOT NULL)) ORDER BY "SiteTree_Live"."Sort" ASC LIMIT 1 0.0001s

0031: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", CASE WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."MetaTitle" ELSE "SiteTree_Live"."MetaTitle" END AS "MetaTitle", "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"."ParentID", "SiteTree_Live"."ID", CASE WHEN "SiteTree_Live"."ClassName" IS NOT NULL THEN "SiteTree_Live"."ClassName" ELSE 'SilverStripe\\CMS\\Model\\SiteTree' END AS "RecordClassName", 'de_DE' AS "Locale", CASE WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN 'de_DE' ELSE NULL END AS "SourceLocale" FROM "SiteTree_Live" LEFT JOIN "SiteTree_Localised_Live" AS "SiteTree_Localised_de_DE" ON "SiteTree_Live"."ID" = "SiteTree_Localised_de_DE"."RecordID" AND "SiteTree_Localised_de_DE"."Locale" = ? WHERE ("SiteTree_Live"."ParentID" <> "SiteTree_Live"."ID") AND ("SiteTree_Live"."ParentID" = ?) AND ("SiteTree_Live"."ShowInMenus" = ?) AND (("SiteTree_Localised_de_DE"."ID" IS NOT NULL)) ORDER BY "SiteTree_Live"."Sort" ASC 0.0001s

0032: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", CASE WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."MetaTitle" ELSE "SiteTree_Live"."MetaTitle" END AS "MetaTitle", "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"."ParentID", "SiteTree_Live"."ID", CASE WHEN "SiteTree_Live"."ClassName" IS NOT NULL THEN "SiteTree_Live"."ClassName" ELSE 'SilverStripe\\CMS\\Model\\SiteTree' END AS "RecordClassName", 'de_DE' AS "Locale", CASE WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN 'de_DE' ELSE NULL END AS "SourceLocale" FROM "SiteTree_Live" LEFT JOIN "SiteTree_Localised_Live" AS "SiteTree_Localised_de_DE" ON "SiteTree_Live"."ID" = "SiteTree_Localised_de_DE"."RecordID" AND "SiteTree_Localised_de_DE"."Locale" = ? WHERE ("SiteTree_Live"."ParentID" <> "SiteTree_Live"."ID") AND ("SiteTree_Live"."ParentID" = ?) AND ("SiteTree_Live"."ShowInMenus" = ?) AND (("SiteTree_Localised_de_DE"."ID" IS NOT NULL)) ORDER BY "SiteTree_Live"."Sort" ASC 0.0001s

0033: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", CASE WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."MetaTitle" ELSE "SiteTree_Live"."MetaTitle" END AS "MetaTitle", "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"."ParentID", "SiteTree_Live"."ID", CASE WHEN "SiteTree_Live"."ClassName" IS NOT NULL THEN "SiteTree_Live"."ClassName" ELSE 'SilverStripe\\CMS\\Model\\SiteTree' END AS "RecordClassName", 'de_DE' AS "Locale", CASE WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN 'de_DE' ELSE NULL END AS "SourceLocale" FROM "SiteTree_Live" LEFT JOIN "SiteTree_Localised_Live" AS "SiteTree_Localised_de_DE" ON "SiteTree_Live"."ID" = "SiteTree_Localised_de_DE"."RecordID" AND "SiteTree_Localised_de_DE"."Locale" = ? WHERE ("SiteTree_Live"."ID" = ?) AND (("SiteTree_Localised_de_DE"."ID" IS NOT NULL)) ORDER BY "SiteTree_Live"."Sort" ASC LIMIT 1 0.0001s

0034: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", CASE WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."MetaTitle" ELSE "SiteTree_Live"."MetaTitle" END AS "MetaTitle", "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"."ParentID", "SiteTree_Live"."ID", CASE WHEN "SiteTree_Live"."ClassName" IS NOT NULL THEN "SiteTree_Live"."ClassName" ELSE 'SilverStripe\\CMS\\Model\\SiteTree' END AS "RecordClassName", 'de_DE' AS "Locale", CASE WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN 'de_DE' ELSE NULL END AS "SourceLocale" FROM "SiteTree_Live" LEFT JOIN "SiteTree_Localised_Live" AS "SiteTree_Localised_de_DE" ON "SiteTree_Live"."ID" = "SiteTree_Localised_de_DE"."RecordID" AND "SiteTree_Localised_de_DE"."Locale" = ? WHERE ("SiteTree_Live"."ParentID" <> "SiteTree_Live"."ID") AND ("SiteTree_Live"."ParentID" = ?) AND ("SiteTree_Live"."ShowInMenus" = ?) AND (("SiteTree_Localised_de_DE"."ID" IS NOT NULL)) ORDER BY "SiteTree_Live"."Sort" ASC 0.0001s

0035: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", CASE WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."MetaTitle" ELSE "SiteTree_Live"."MetaTitle" END AS "MetaTitle", "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"."ParentID", "SiteTree_Live"."ID", CASE WHEN "SiteTree_Live"."ClassName" IS NOT NULL THEN "SiteTree_Live"."ClassName" ELSE 'SilverStripe\\CMS\\Model\\SiteTree' END AS "RecordClassName", 'de_DE' AS "Locale", CASE WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN 'de_DE' ELSE NULL END AS "SourceLocale" FROM "SiteTree_Live" LEFT JOIN "SiteTree_Localised_Live" AS "SiteTree_Localised_de_DE" ON "SiteTree_Live"."ID" = "SiteTree_Localised_de_DE"."RecordID" AND "SiteTree_Localised_de_DE"."Locale" = ? WHERE ("SiteTree_Live"."ParentID" <> "SiteTree_Live"."ID") AND ("SiteTree_Live"."ParentID" = ?) AND ("SiteTree_Live"."ShowInMenus" = ?) AND (("SiteTree_Localised_de_DE"."ID" IS NOT NULL)) ORDER BY "SiteTree_Live"."Sort" ASC 0.0001s

0036: SELECT DISTINCT IFNULL("NewsPage_Live".PublishingDate, "SiteTree_Live".Created) AS "_SortColumn0", "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"."MetaTitle" ELSE "SiteTree_Live"."MetaTitle" END AS "MetaTitle", "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"."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" INNER JOIN "NewsPage_Live" ON `SiteTree_Live`.`ID` = `NewsPage_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" = ? WHERE ("SiteTree_Live"."ParentID" <> "SiteTree_Live"."ID") AND ("SiteTree_Live"."ParentID" = ?) AND ("SiteTree_Live"."ShowInMenus" = ?) AND (("SiteTree_Localised_de_DE"."ID" IS NOT NULL)) ORDER BY "_SortColumn0" DESC 0.0003s

0037: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", CASE WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."MetaTitle" ELSE "SiteTree_Live"."MetaTitle" END AS "MetaTitle", "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"."ParentID", "SiteTree_Live"."ID", CASE WHEN "SiteTree_Live"."ClassName" IS NOT NULL THEN "SiteTree_Live"."ClassName" ELSE 'SilverStripe\\CMS\\Model\\SiteTree' END AS "RecordClassName", 'de_DE' AS "Locale", CASE WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN 'de_DE' ELSE NULL END AS "SourceLocale" FROM "SiteTree_Live" LEFT JOIN "SiteTree_Localised_Live" AS "SiteTree_Localised_de_DE" ON "SiteTree_Live"."ID" = "SiteTree_Localised_de_DE"."RecordID" AND "SiteTree_Localised_de_DE"."Locale" = ? WHERE ("SiteTree_Live"."ParentID" <> "SiteTree_Live"."ID") AND ("SiteTree_Live"."ParentID" = ?) AND ("SiteTree_Live"."ShowInMenus" = ?) AND (("SiteTree_Localised_de_DE"."ID" IS NOT NULL)) ORDER BY "SiteTree_Live"."Sort" ASC 0.0001s

0038: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", CASE WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."MetaTitle" ELSE "SiteTree_Live"."MetaTitle" END AS "MetaTitle", "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"."ParentID", "SiteTree_Live"."ID", CASE WHEN "SiteTree_Live"."ClassName" IS NOT NULL THEN "SiteTree_Live"."ClassName" ELSE 'SilverStripe\\CMS\\Model\\SiteTree' END AS "RecordClassName", 'de_DE' AS "Locale", CASE WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN 'de_DE' ELSE NULL END AS "SourceLocale" FROM "SiteTree_Live" LEFT JOIN "SiteTree_Localised_Live" AS "SiteTree_Localised_de_DE" ON "SiteTree_Live"."ID" = "SiteTree_Localised_de_DE"."RecordID" AND "SiteTree_Localised_de_DE"."Locale" = ? WHERE ("SiteTree_Live"."ParentID" <> "SiteTree_Live"."ID") AND ("SiteTree_Live"."ParentID" = ?) AND ("SiteTree_Live"."ShowInMenus" = ?) AND (("SiteTree_Localised_de_DE"."ID" IS NOT NULL)) ORDER BY "SiteTree_Live"."Sort" ASC 0.0001s

0039: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", CASE WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."MetaTitle" ELSE "SiteTree_Live"."MetaTitle" END AS "MetaTitle", "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"."ParentID", "SiteTree_Live"."ID", CASE WHEN "SiteTree_Live"."ClassName" IS NOT NULL THEN "SiteTree_Live"."ClassName" ELSE 'SilverStripe\\CMS\\Model\\SiteTree' END AS "RecordClassName", 'de_DE' AS "Locale", CASE WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN 'de_DE' ELSE NULL END AS "SourceLocale" FROM "SiteTree_Live" LEFT JOIN "SiteTree_Localised_Live" AS "SiteTree_Localised_de_DE" ON "SiteTree_Live"."ID" = "SiteTree_Localised_de_DE"."RecordID" AND "SiteTree_Localised_de_DE"."Locale" = ? WHERE ("SiteTree_Live"."ParentID" <> "SiteTree_Live"."ID") AND ("SiteTree_Live"."ParentID" = ?) AND ("SiteTree_Live"."ShowInMenus" = ?) AND (("SiteTree_Localised_de_DE"."ID" IS NOT NULL)) ORDER BY "SiteTree_Live"."Sort" ASC 0.0001s

0040: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "Page_Live"."SliderID", "Page_Live"."BackgroundImageID", "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", "SiteTree_Live"."Sort" FROM "SiteTree_Live" LEFT JOIN "Page_Live" ON "Page_Live"."ID" = "SiteTree_Live"."ID" LEFT JOIN "SiteTree_Localised_Live" AS "SiteTree_Localised_de_DE" ON "SiteTree_Live"."ID" = "SiteTree_Localised_de_DE"."RecordID" AND "SiteTree_Localised_de_DE"."Locale" = ? 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.0003s

0041: SELECT DISTINCT "ContentElement_Live"."ClassName", "ContentElement_Live"."LastEdited", "ContentElement_Live"."Created", "ContentElement_Live"."FullscreenWidth", "ContentElement_Live"."Version", CASE WHEN "ContentElement_Localised_de_DE"."ID" IS NOT NULL THEN "ContentElement_Localised_de_DE"."Title" ELSE "ContentElement_Live"."Title" END AS "Title", "ContentElement_Live"."ShowTitle", "ContentElement_Live"."Sort", "ContentElement_Live"."PageID", "ContentElement_Live"."ID", CASE WHEN "ContentElement_Live"."ClassName" IS NOT NULL THEN "ContentElement_Live"."ClassName" ELSE 'SCS\\CE\\Model\\Element\\ContentElement' END AS "RecordClassName", 'de_DE' AS "Locale", CASE WHEN "ContentElement_Localised_de_DE"."ID" IS NOT NULL THEN 'de_DE' ELSE NULL END AS "SourceLocale" FROM "ContentElement_Live" LEFT JOIN "ContentElement_Localised" AS "ContentElement_Localised_de_DE" ON "ContentElement_Live"."ID" = "ContentElement_Localised_de_DE"."RecordID" AND "ContentElement_Localised_de_DE"."Locale" = ? WHERE ("ContentElement_Live"."PageID" = ?) AND (("ContentElement_Localised_de_DE"."ID" IS NOT NULL)) ORDER BY "ContentElement_Live"."Sort" ASC 0.0003s

0042: 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"."MetaTitle" ELSE "SiteTree_Live"."MetaTitle" END AS "MetaTitle", "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"."ParentID", "Page_Live"."SliderID", "Page_Live"."BackgroundImageID", "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 "Page_Live" ON "Page_Live"."ID" = "SiteTree_Live"."ID" LEFT JOIN "SiteTree_Localised_Live" AS "SiteTree_Localised_de_DE" ON "SiteTree_Live"."ID" = "SiteTree_Localised_de_DE"."RecordID" AND "SiteTree_Localised_de_DE"."Locale" = ? WHERE ("SiteTree_Live"."ID" = ?) AND ("SiteTree_Live"."ClassName" IN (?, ?, ?, ?, ?, ?, ?, ?, ?)) AND (("SiteTree_Localised_de_DE"."ID" IS NOT NULL)) ORDER BY "SiteTree_Live"."Sort" ASC LIMIT 1 0.0004s

0043: SELECT CASE WHEN EXISTS(SELECT * FROM "ContentElement_Live" LEFT JOIN "ContentElement_Localised" AS "ContentElement_Localised_de_DE" ON "ContentElement_Live"."ID" = "ContentElement_Localised_de_DE"."RecordID" AND "ContentElement_Localised_de_DE"."Locale" = ? WHERE ("ContentElement_Live"."PageID" = ?) AND (REPLACE(' ', ' ', LOWER(`ContentElement_Live`.`Title`)) = 'galerie hotelbilder') AND (("ContentElement_Live"."ID" != ? OR "ContentElement_Live"."ID" IS NULL)) AND (("ContentElement_Localised_de_DE"."ID" IS NOT NULL))) THEN 1 ELSE 0 END 0.0002s

0044: SELECT DISTINCT "Gallery_Images"."SortOrder", "File_Live"."ClassName", "File_Live"."LastEdited", "File_Live"."Created", "File_Live"."Version", "File_Live"."UserFormUpload", "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", "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 "Gallery_Images" ON "Gallery_Images"."ImageID" = "File_Live"."ID" WHERE ("Gallery_Images"."GalleryID" = ?) AND ("File_Live"."ClassName" IN (?)) ORDER BY "SortOrder" ASC 0.0003s

0045: 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 "Gallery_Images" ON "Gallery_Images"."ImageID" = "File_Live"."ID" WHERE ("Gallery_Images"."GalleryID" = ?) AND ("File_Live"."ClassName" IN (?)) 0.0004s

0046: 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 "Gallery_Images" ON "Gallery_Images"."ImageID" = "File_Live"."ID" WHERE ("Gallery_Images"."GalleryID" = ?) AND ("File_Live"."ClassName" IN (?)) 0.0002s

0047: 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 "Gallery_Images" ON "Gallery_Images"."ImageID" = "File_Live"."ID" WHERE ("Gallery_Images"."GalleryID" = ?) AND ("File_Live"."ClassName" IN (?)) 0.0002s

0048: 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 "Gallery_Images" ON "Gallery_Images"."ImageID" = "File_Live"."ID" WHERE ("Gallery_Images"."GalleryID" = ?) AND ("File_Live"."ClassName" IN (?)) 0.0003s

0049: 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 "Gallery_Images" ON "Gallery_Images"."ImageID" = "File_Live"."ID" WHERE ("Gallery_Images"."GalleryID" = ?) AND ("File_Live"."ClassName" IN (?)) 0.0002s

0050: 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 "Gallery_Images" ON "Gallery_Images"."ImageID" = "File_Live"."ID" WHERE ("Gallery_Images"."GalleryID" = ?) AND ("File_Live"."ClassName" IN (?)) 0.0002s

0051: 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 "Gallery_Images" ON "Gallery_Images"."ImageID" = "File_Live"."ID" WHERE ("Gallery_Images"."GalleryID" = ?) AND ("File_Live"."ClassName" IN (?)) 0.0002s

0052: 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 "Gallery_Images" ON "Gallery_Images"."ImageID" = "File_Live"."ID" WHERE ("Gallery_Images"."GalleryID" = ?) AND ("File_Live"."ClassName" IN (?)) 0.0002s

0053: 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 "Gallery_Images" ON "Gallery_Images"."ImageID" = "File_Live"."ID" WHERE ("Gallery_Images"."GalleryID" = ?) AND ("File_Live"."ClassName" IN (?)) 0.0002s

0054: 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 "Gallery_Images" ON "Gallery_Images"."ImageID" = "File_Live"."ID" WHERE ("Gallery_Images"."GalleryID" = ?) AND ("File_Live"."ClassName" IN (?)) 0.0002s

0055: 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 "Gallery_Images" ON "Gallery_Images"."ImageID" = "File_Live"."ID" WHERE ("Gallery_Images"."GalleryID" = ?) AND ("File_Live"."ClassName" IN (?)) 0.0002s

0056: SELECT DISTINCT count(DISTINCT "SiteTree_Live"."ID") AS "Count" FROM "SiteTree_Live" LEFT JOIN "Page_Live" ON "Page_Live"."ID" = "SiteTree_Live"."ID" INNER JOIN "SiteConfig_FooterLinks" ON "SiteConfig_FooterLinks"."PageID" = "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" = ? WHERE ("SiteConfig_FooterLinks"."SiteConfigID" = ?) AND ("SiteTree_Live"."ClassName" IN (?, ?, ?, ?, ?, ?, ?, ?, ?)) AND (("SiteTree_Localised_de_DE"."ID" IS NOT NULL)) 0.0004s

0057: 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"."MetaTitle" ELSE "SiteTree_Live"."MetaTitle" END AS "MetaTitle", "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"."ParentID", "Page_Live"."SliderID", "Page_Live"."BackgroundImageID", "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 "Page_Live" ON "Page_Live"."ID" = "SiteTree_Live"."ID" INNER JOIN "SiteConfig_FooterLinks" ON "SiteConfig_FooterLinks"."PageID" = "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" = ? WHERE ("SiteConfig_FooterLinks"."SiteConfigID" = ?) AND ("SiteTree_Live"."ClassName" IN (?, ?, ?, ?, ?, ?, ?, ?, ?)) AND (("SiteTree_Localised_de_DE"."ID" IS NOT NULL)) ORDER BY "SiteTree_Live"."Sort" ASC 0.0004s

0058: 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"."MetaTitle" ELSE "SiteTree_Live"."MetaTitle" END AS "MetaTitle", "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"."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"."ShowInMenus" = ?) AND ("SiteTree_Live"."ParentID" = ?) AND (("SiteTree_Localised_de_DE"."ID" IS NOT NULL)) ORDER BY "SiteTree_Live"."Sort" ASC 0.0002s

0059: 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"."MetaTitle" ELSE "SiteTree_Live"."MetaTitle" END AS "MetaTitle", "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"."ParentID", "SiteTree_Live"."ID", CASE WHEN "SiteTree_Live"."ClassName" IS NOT NULL THEN "SiteTree_Live"."ClassName" ELSE 'SilverStripe\\CMS\\Model\\SiteTree' END AS "RecordClassName", 'de_DE' AS "Locale", CASE WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN 'de_DE' ELSE NULL END AS "SourceLocale" FROM "SiteTree_Live" LEFT JOIN "SiteTree_Localised_Live" AS "SiteTree_Localised_de_DE" ON "SiteTree_Live"."ID" = "SiteTree_Localised_de_DE"."RecordID" AND "SiteTree_Localised_de_DE"."Locale" = ? WHERE ("SiteTree_Live"."ParentID" <> "SiteTree_Live"."ID") AND ("SiteTree_Live"."ParentID" = ?) AND ("SiteTree_Live"."ShowInMenus" = ?) AND (("SiteTree_Localised_de_DE"."ID" IS NOT NULL)) ORDER BY "SiteTree_Live"."Sort" ASC 0.0001s

0060: 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"."MetaTitle" ELSE "SiteTree_Live"."MetaTitle" END AS "MetaTitle", "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"."ParentID", "SiteTree_Live"."ID", CASE WHEN "SiteTree_Live"."ClassName" IS NOT NULL THEN "SiteTree_Live"."ClassName" ELSE 'SilverStripe\\CMS\\Model\\SiteTree' END AS "RecordClassName", 'de_DE' AS "Locale", CASE WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN 'de_DE' ELSE NULL END AS "SourceLocale" FROM "SiteTree_Live" LEFT JOIN "SiteTree_Localised_Live" AS "SiteTree_Localised_de_DE" ON "SiteTree_Live"."ID" = "SiteTree_Localised_de_DE"."RecordID" AND "SiteTree_Localised_de_DE"."Locale" = ? WHERE ("SiteTree_Live"."ParentID" <> "SiteTree_Live"."ID") AND ("SiteTree_Live"."ParentID" = ?) AND ("SiteTree_Live"."ShowInMenus" = ?) AND (("SiteTree_Localised_de_DE"."ID" IS NOT NULL)) ORDER BY "SiteTree_Live"."Sort" ASC 0.0001s

0061: 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"."MetaTitle" ELSE "SiteTree_Live"."MetaTitle" END AS "MetaTitle", "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"."ParentID", "SiteTree_Live"."ID", CASE WHEN "SiteTree_Live"."ClassName" IS NOT NULL THEN "SiteTree_Live"."ClassName" ELSE 'SilverStripe\\CMS\\Model\\SiteTree' END AS "RecordClassName", 'de_DE' AS "Locale", CASE WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN 'de_DE' ELSE NULL END AS "SourceLocale" FROM "SiteTree_Live" LEFT JOIN "SiteTree_Localised_Live" AS "SiteTree_Localised_de_DE" ON "SiteTree_Live"."ID" = "SiteTree_Localised_de_DE"."RecordID" AND "SiteTree_Localised_de_DE"."Locale" = ? WHERE ("SiteTree_Live"."ID" = ?) AND (("SiteTree_Localised_de_DE"."ID" IS NOT NULL)) ORDER BY "SiteTree_Live"."Sort" ASC LIMIT 1 0.0001s

0062: 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"."MetaTitle" ELSE "SiteTree_Live"."MetaTitle" END AS "MetaTitle", "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"."ParentID", "SiteTree_Live"."ID", CASE WHEN "SiteTree_Live"."ClassName" IS NOT NULL THEN "SiteTree_Live"."ClassName" ELSE 'SilverStripe\\CMS\\Model\\SiteTree' END AS "RecordClassName", 'de_DE' AS "Locale", CASE WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN 'de_DE' ELSE NULL END AS "SourceLocale" FROM "SiteTree_Live" LEFT JOIN "SiteTree_Localised_Live" AS "SiteTree_Localised_de_DE" ON "SiteTree_Live"."ID" = "SiteTree_Localised_de_DE"."RecordID" AND "SiteTree_Localised_de_DE"."Locale" = ? WHERE ("SiteTree_Live"."ParentID" <> "SiteTree_Live"."ID") AND ("SiteTree_Live"."ParentID" = ?) AND ("SiteTree_Live"."ShowInMenus" = ?) AND (("SiteTree_Localised_de_DE"."ID" IS NOT NULL)) ORDER BY "SiteTree_Live"."Sort" ASC 0.0001s

0063: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", CASE WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."MetaTitle" ELSE "SiteTree_Live"."MetaTitle" END AS "MetaTitle", "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"."ParentID", "SiteTree_Live"."ID", CASE WHEN "SiteTree_Live"."ClassName" IS NOT NULL THEN "SiteTree_Live"."ClassName" ELSE 'SilverStripe\\CMS\\Model\\SiteTree' END AS "RecordClassName", 'de_DE' AS "Locale", CASE WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN 'de_DE' ELSE NULL END AS "SourceLocale" FROM "SiteTree_Live" LEFT JOIN "SiteTree_Localised_Live" AS "SiteTree_Localised_de_DE" ON "SiteTree_Live"."ID" = "SiteTree_Localised_de_DE"."RecordID" AND "SiteTree_Localised_de_DE"."Locale" = ? WHERE ("SiteTree_Live"."ParentID" <> "SiteTree_Live"."ID") AND ("SiteTree_Live"."ParentID" = ?) AND ("SiteTree_Live"."ShowInMenus" = ?) AND (("SiteTree_Localised_de_DE"."ID" IS NOT NULL)) ORDER BY "SiteTree_Live"."Sort" ASC 0.0001s

0064: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", CASE WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."MetaTitle" ELSE "SiteTree_Live"."MetaTitle" END AS "MetaTitle", "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"."ParentID", "SiteTree_Live"."ID", CASE WHEN "SiteTree_Live"."ClassName" IS NOT NULL THEN "SiteTree_Live"."ClassName" ELSE 'SilverStripe\\CMS\\Model\\SiteTree' END AS "RecordClassName", 'de_DE' AS "Locale", CASE WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN 'de_DE' ELSE NULL END AS "SourceLocale" FROM "SiteTree_Live" LEFT JOIN "SiteTree_Localised_Live" AS "SiteTree_Localised_de_DE" ON "SiteTree_Live"."ID" = "SiteTree_Localised_de_DE"."RecordID" AND "SiteTree_Localised_de_DE"."Locale" = ? WHERE ("SiteTree_Live"."ID" = ?) AND (("SiteTree_Localised_de_DE"."ID" IS NOT NULL)) ORDER BY "SiteTree_Live"."Sort" ASC LIMIT 1 0.0001s

0065: SELECT DISTINCT "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"."MetaTitle" ELSE "SiteTree_Live"."MetaTitle" END AS "MetaTitle", "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"."ParentID", "SiteTree_Live"."ID", CASE WHEN "SiteTree_Live"."ClassName" IS NOT NULL THEN "SiteTree_Live"."ClassName" ELSE 'SilverStripe\\CMS\\Model\\SiteTree' END AS "RecordClassName", 'de_DE' AS "Locale", CASE WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN 'de_DE' ELSE NULL END AS "SourceLocale" FROM "SiteTree_Live" LEFT JOIN "SiteTree_Localised_Live" AS "SiteTree_Localised_de_DE" ON "SiteTree_Live"."ID" = "SiteTree_Localised_de_DE"."RecordID" AND "SiteTree_Localised_de_DE"."Locale" = ? WHERE ("SiteTree_Live"."ParentID" <> "SiteTree_Live"."ID") AND ("SiteTree_Live"."ParentID" = ?) AND ("SiteTree_Live"."ShowInMenus" = ?) AND (("SiteTree_Localised_de_DE"."ID" IS NOT NULL)) ORDER BY "SiteTree_Live"."Sort" ASC 0.0001s

0066: 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"."MetaTitle" ELSE "SiteTree_Live"."MetaTitle" END AS "MetaTitle", "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"."ParentID", "SiteTree_Live"."ID", CASE WHEN "SiteTree_Live"."ClassName" IS NOT NULL THEN "SiteTree_Live"."ClassName" ELSE 'SilverStripe\\CMS\\Model\\SiteTree' END AS "RecordClassName", 'de_DE' AS "Locale", CASE WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN 'de_DE' ELSE NULL END AS "SourceLocale" FROM "SiteTree_Live" LEFT JOIN "SiteTree_Localised_Live" AS "SiteTree_Localised_de_DE" ON "SiteTree_Live"."ID" = "SiteTree_Localised_de_DE"."RecordID" AND "SiteTree_Localised_de_DE"."Locale" = ? WHERE ("SiteTree_Live"."ParentID" <> "SiteTree_Live"."ID") AND ("SiteTree_Live"."ParentID" = ?) AND ("SiteTree_Live"."ShowInMenus" = ?) AND (("SiteTree_Localised_de_DE"."ID" IS NOT NULL)) ORDER BY "SiteTree_Live"."Sort" ASC 0.0001s

0067: SELECT DISTINCT IFNULL("NewsPage_Live".PublishingDate, "SiteTree_Live".Created) AS "_SortColumn0", "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"."MetaTitle" ELSE "SiteTree_Live"."MetaTitle" END AS "MetaTitle", "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"."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" INNER JOIN "NewsPage_Live" ON `SiteTree_Live`.`ID` = `NewsPage_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" = ? WHERE ("SiteTree_Live"."ParentID" <> "SiteTree_Live"."ID") AND ("SiteTree_Live"."ParentID" = ?) AND ("SiteTree_Live"."ShowInMenus" = ?) AND (("SiteTree_Localised_de_DE"."ID" IS NOT NULL)) ORDER BY "_SortColumn0" DESC 0.0001s

0068: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", CASE WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."MetaTitle" ELSE "SiteTree_Live"."MetaTitle" END AS "MetaTitle", "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"."ParentID", "SiteTree_Live"."ID", CASE WHEN "SiteTree_Live"."ClassName" IS NOT NULL THEN "SiteTree_Live"."ClassName" ELSE 'SilverStripe\\CMS\\Model\\SiteTree' END AS "RecordClassName", 'de_DE' AS "Locale", CASE WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN 'de_DE' ELSE NULL END AS "SourceLocale" FROM "SiteTree_Live" LEFT JOIN "SiteTree_Localised_Live" AS "SiteTree_Localised_de_DE" ON "SiteTree_Live"."ID" = "SiteTree_Localised_de_DE"."RecordID" AND "SiteTree_Localised_de_DE"."Locale" = ? WHERE ("SiteTree_Live"."ParentID" <> "SiteTree_Live"."ID") AND ("SiteTree_Live"."ParentID" = ?) AND ("SiteTree_Live"."ShowInMenus" = ?) AND (("SiteTree_Localised_de_DE"."ID" IS NOT NULL)) ORDER BY "SiteTree_Live"."Sort" ASC 0.0001s

0069: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", CASE WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."MetaTitle" ELSE "SiteTree_Live"."MetaTitle" END AS "MetaTitle", "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"."ParentID", "SiteTree_Live"."ID", CASE WHEN "SiteTree_Live"."ClassName" IS NOT NULL THEN "SiteTree_Live"."ClassName" ELSE 'SilverStripe\\CMS\\Model\\SiteTree' END AS "RecordClassName", 'de_DE' AS "Locale", CASE WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN 'de_DE' ELSE NULL END AS "SourceLocale" FROM "SiteTree_Live" LEFT JOIN "SiteTree_Localised_Live" AS "SiteTree_Localised_de_DE" ON "SiteTree_Live"."ID" = "SiteTree_Localised_de_DE"."RecordID" AND "SiteTree_Localised_de_DE"."Locale" = ? WHERE ("SiteTree_Live"."ParentID" <> "SiteTree_Live"."ID") AND ("SiteTree_Live"."ParentID" = ?) AND ("SiteTree_Live"."ShowInMenus" = ?) AND (("SiteTree_Localised_de_DE"."ID" IS NOT NULL)) ORDER BY "SiteTree_Live"."Sort" ASC 0.0001s

0070: 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"."MetaTitle" ELSE "SiteTree_Live"."MetaTitle" END AS "MetaTitle", "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"."ParentID", "SiteTree_Live"."ID", CASE WHEN "SiteTree_Live"."ClassName" IS NOT NULL THEN "SiteTree_Live"."ClassName" ELSE 'SilverStripe\\CMS\\Model\\SiteTree' END AS "RecordClassName", 'de_DE' AS "Locale", CASE WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN 'de_DE' ELSE NULL END AS "SourceLocale" FROM "SiteTree_Live" LEFT JOIN "SiteTree_Localised_Live" AS "SiteTree_Localised_de_DE" ON "SiteTree_Live"."ID" = "SiteTree_Localised_de_DE"."RecordID" AND "SiteTree_Localised_de_DE"."Locale" = ? WHERE ("SiteTree_Live"."ParentID" <> "SiteTree_Live"."ID") AND ("SiteTree_Live"."ParentID" = ?) AND ("SiteTree_Live"."ShowInMenus" = ?) AND (("SiteTree_Localised_de_DE"."ID" IS NOT NULL)) ORDER BY "SiteTree_Live"."Sort" ASC 0.0001s

0071: SELECT DISTINCT count(DISTINCT "ResourceCategory"."ID") AS "Count" FROM "ResourceCategory" INNER JOIN "WebResource" ON "WebResource".CategoryID = "ResourceCategory".ID LEFT JOIN "ResourceCategory_Localised" AS "ResourceCategory_Localised_de_DE" ON "ResourceCategory"."ID" = "ResourceCategory_Localised_de_DE"."RecordID" AND "ResourceCategory_Localised_de_DE"."Locale" = ? WHERE (("ResourceCategory"."Classification" != ? OR "ResourceCategory"."Classification" IS NULL)) AND (("ResourceCategory_Localised_de_DE"."ID" IS NOT NULL)) 0.0003s

0072: SELECT IFNULL(SHA2(CONCAT(GROUP_CONCAT(wr.Identifier), rc.ID, 'v20220211lfmYRzHiY5zSaA5wwsPDExo'), 256), '') FROM ResourceCategory rc JOIN WebResource wr ON wr.CategoryID = rc.ID 0.0002s

0073: 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"."MetaTitle" ELSE "SiteTree_Live"."MetaTitle" END AS "MetaTitle", "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"."ParentID", "Page_Live"."SliderID", "Page_Live"."BackgroundImageID", "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 "Page_Live" ON "Page_Live"."ID" = "SiteTree_Live"."ID" LEFT JOIN "SiteTree_Localised_Live" AS "SiteTree_Localised_de_DE" ON "SiteTree_Live"."ID" = "SiteTree_Localised_de_DE"."RecordID" AND "SiteTree_Localised_de_DE"."Locale" = ? WHERE ("SiteTree_Live"."ID" = ?) AND ("SiteTree_Live"."ClassName" IN (?)) AND (("SiteTree_Localised_de_DE"."ID" IS NOT NULL)) ORDER BY "SiteTree_Live"."Sort" ASC LIMIT 1 0.0004s

0074: SELECT CASE WHEN EXISTS(SELECT * FROM "ResourceCategory" INNER JOIN "WebResource" ON "WebResource".CategoryID = "ResourceCategory".ID LEFT JOIN "ResourceCategory_Localised" AS "ResourceCategory_Localised_de_DE" ON "ResourceCategory"."ID" = "ResourceCategory_Localised_de_DE"."RecordID" AND "ResourceCategory_Localised_de_DE"."Locale" = ? WHERE (("ResourceCategory"."Classification" != ? OR "ResourceCategory"."Classification" IS NULL)) AND (("ResourceCategory_Localised_de_DE"."ID" IS NOT NULL))) THEN 1 ELSE 0 END 0.0002s

0075: SELECT DISTINCT "ResourceCategory"."ClassName", "ResourceCategory"."LastEdited", "ResourceCategory"."Created", CASE WHEN "ResourceCategory_Localised_de_DE"."ID" IS NOT NULL THEN "ResourceCategory_Localised_de_DE"."ResourceKey" ELSE "ResourceCategory"."ResourceKey" END AS "ResourceKey", CASE WHEN "ResourceCategory_Localised_de_DE"."ID" IS NOT NULL THEN "ResourceCategory_Localised_de_DE"."Title" ELSE "ResourceCategory"."Title" END AS "Title", "ResourceCategory"."Classification", "ResourceCategory"."Locked", "ResourceCategory"."Sort", "ResourceCategory"."ID", CASE WHEN "ResourceCategory"."ClassName" IS NOT NULL THEN "ResourceCategory"."ClassName" ELSE 'SCS\\Privacy\\Model\\ResourceCategory' END AS "RecordClassName", 'de_DE' AS "Locale", CASE WHEN "ResourceCategory_Localised_de_DE"."ID" IS NOT NULL THEN 'de_DE' ELSE NULL END AS "SourceLocale" FROM "ResourceCategory" INNER JOIN "WebResource" ON "WebResource".CategoryID = "ResourceCategory".ID LEFT JOIN "ResourceCategory_Localised" AS "ResourceCategory_Localised_de_DE" ON "ResourceCategory"."ID" = "ResourceCategory_Localised_de_DE"."RecordID" AND "ResourceCategory_Localised_de_DE"."Locale" = ? WHERE (("ResourceCategory"."Classification" != ? OR "ResourceCategory"."Classification" IS NULL)) AND (("ResourceCategory_Localised_de_DE"."ID" IS NOT NULL)) ORDER BY "ResourceCategory"."Sort" ASC 0.0003s

0076: SELECT CASE WHEN EXISTS(SELECT * FROM "ResourceCategory" INNER JOIN "WebResource" ON "WebResource".CategoryID = "ResourceCategory".ID LEFT JOIN "ResourceCategory_Localised" AS "ResourceCategory_Localised_de_DE" ON "ResourceCategory"."ID" = "ResourceCategory_Localised_de_DE"."RecordID" AND "ResourceCategory_Localised_de_DE"."Locale" = ? WHERE (("ResourceCategory"."Classification" != ? OR "ResourceCategory"."Classification" IS NULL)) AND (("ResourceCategory_Localised_de_DE"."ID" IS NOT NULL))) THEN 1 ELSE 0 END 0.0001s

0077: SELECT DISTINCT "ResourceCategory"."ClassName", "ResourceCategory"."LastEdited", "ResourceCategory"."Created", CASE WHEN "ResourceCategory_Localised_de_DE"."ID" IS NOT NULL THEN "ResourceCategory_Localised_de_DE"."ResourceKey" ELSE "ResourceCategory"."ResourceKey" END AS "ResourceKey", CASE WHEN "ResourceCategory_Localised_de_DE"."ID" IS NOT NULL THEN "ResourceCategory_Localised_de_DE"."Title" ELSE "ResourceCategory"."Title" END AS "Title", "ResourceCategory"."Classification", "ResourceCategory"."Locked", "ResourceCategory"."Sort", "ResourceCategory"."ID", CASE WHEN "ResourceCategory"."ClassName" IS NOT NULL THEN "ResourceCategory"."ClassName" ELSE 'SCS\\Privacy\\Model\\ResourceCategory' END AS "RecordClassName", 'de_DE' AS "Locale", CASE WHEN "ResourceCategory_Localised_de_DE"."ID" IS NOT NULL THEN 'de_DE' ELSE NULL END AS "SourceLocale" FROM "ResourceCategory" INNER JOIN "WebResource" ON "WebResource".CategoryID = "ResourceCategory".ID LEFT JOIN "ResourceCategory_Localised" AS "ResourceCategory_Localised_de_DE" ON "ResourceCategory"."ID" = "ResourceCategory_Localised_de_DE"."RecordID" AND "ResourceCategory_Localised_de_DE"."Locale" = ? WHERE (("ResourceCategory"."Classification" != ? OR "ResourceCategory"."Classification" IS NULL)) AND (("ResourceCategory_Localised_de_DE"."ID" IS NOT NULL)) ORDER BY "ResourceCategory"."Sort" ASC 0.0001s

0078: SELECT IFNULL(SHA2(CONCAT(GROUP_CONCAT(wr.Identifier), rc.ID, 'v20220211lfmYRzHiY5zSaA5wwsPDExo'), 256), '') FROM ResourceCategory rc JOIN WebResource wr ON wr.CategoryID = rc.ID WHERE rc.ID = 1 0.0002s

0079: SELECT DISTINCT count(DISTINCT "SiteTree_Live"."ID") AS "Count" FROM "SiteTree_Live" LEFT JOIN "Page_Live" ON "Page_Live"."ID" = "SiteTree_Live"."ID" INNER JOIN "SiteConfig_DataPolicyLinks" ON "SiteConfig_DataPolicyLinks"."PageID" = "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" = ? WHERE ("SiteConfig_DataPolicyLinks"."SiteConfigID" = ?) AND ("SiteTree_Live"."ClassName" IN (?, ?, ?, ?, ?, ?, ?, ?, ?)) AND (("SiteTree_Localised_de_DE"."ID" IS NOT NULL)) 0.0003s

0081: 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"."MetaTitle" ELSE "SiteTree_Live"."MetaTitle" END AS "MetaTitle", "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"."ParentID", "SiteTree_Live"."ID", CASE WHEN "SiteTree_Live"."ClassName" IS NOT NULL THEN "SiteTree_Live"."ClassName" ELSE 'SilverStripe\\CMS\\Model\\SiteTree' END AS "RecordClassName", 'de_DE' AS "Locale", CASE WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN 'de_DE' ELSE NULL END AS "SourceLocale" FROM "SiteTree_Live" LEFT JOIN "SiteTree_Localised_Live" AS "SiteTree_Localised_de_DE" ON "SiteTree_Live"."ID" = "SiteTree_Localised_de_DE"."RecordID" AND "SiteTree_Localised_de_DE"."Locale" = ? WHERE ("SiteTree_Live"."ID" = ?) AND (("SiteTree_Localised_de_DE"."ID" IS NOT NULL)) ORDER BY "SiteTree_Live"."Sort" ASC LIMIT 1 0.0001s

0082: SELECT DISTINCT "SiteTree"."ClassName", "SiteTree"."LastEdited", "SiteTree"."Created", "SiteTree"."Priority", CASE WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."MetaTitle" ELSE "SiteTree"."MetaTitle" END AS "MetaTitle", "SiteTree"."CanViewType", "SiteTree"."CanEditType", "SiteTree"."Version", CASE WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."URLSegment" ELSE "SiteTree"."URLSegment" END AS "URLSegment", CASE WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."Title" ELSE "SiteTree"."Title" END AS "Title", CASE WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."MenuTitle" ELSE "SiteTree"."MenuTitle" END AS "MenuTitle", CASE WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."Content" ELSE "SiteTree"."Content" END AS "Content", CASE WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."MetaDescription" ELSE "SiteTree"."MetaDescription" END AS "MetaDescription", "SiteTree"."ExtraMeta", "SiteTree"."ShowInMenus", "SiteTree"."ShowInSearch", "SiteTree"."Sort", "SiteTree"."HasBrokenFile", "SiteTree"."HasBrokenLink", CASE WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."ReportClass" ELSE "SiteTree"."ReportClass" END AS "ReportClass", "SiteTree"."ParentID", "SiteTree"."ID", CASE WHEN "SiteTree"."ClassName" IS NOT NULL THEN "SiteTree"."ClassName" ELSE 'SilverStripe\\CMS\\Model\\SiteTree' END AS "RecordClassName", 'de_DE' AS "Locale", CASE WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN 'de_DE' ELSE NULL END AS "SourceLocale" FROM "SiteTree" LEFT JOIN "SiteTree_Localised" AS "SiteTree_Localised_de_DE" ON "SiteTree"."ID" = "SiteTree_Localised_de_DE"."RecordID" AND "SiteTree_Localised_de_DE"."Locale" = ? WHERE ("SiteTree"."ID" = ?) AND (("SiteTree_Localised_de_DE"."ID" IS NOT NULL)) ORDER BY "SiteTree"."Sort" ASC LIMIT 1 0.0003s

0083: 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"."MetaTitle" ELSE "SiteTree_Live"."MetaTitle" END AS "MetaTitle", "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"."ParentID", "SiteTree_Live"."ID", CASE WHEN "SiteTree_Live"."ClassName" IS NOT NULL THEN "SiteTree_Live"."ClassName" ELSE 'SilverStripe\\CMS\\Model\\SiteTree' END AS "RecordClassName", 'de_DE' AS "Locale", CASE WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN 'de_DE' ELSE NULL END AS "SourceLocale" FROM "SiteTree_Live" LEFT JOIN "SiteTree_Localised_Live" AS "SiteTree_Localised_de_DE" ON "SiteTree_Live"."ID" = "SiteTree_Localised_de_DE"."RecordID" AND "SiteTree_Localised_de_DE"."Locale" = ? WHERE ("SiteTree_Live"."ID" = ?) AND (("SiteTree_Localised_de_DE"."ID" IS NOT NULL)) ORDER BY "SiteTree_Live"."Sort" ASC LIMIT 1 0.0001s

0084: 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"."MetaTitle" ELSE "SiteTree_Live"."MetaTitle" END AS "MetaTitle", "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"."ParentID", "SiteTree_Live"."ID", CASE WHEN "SiteTree_Live"."ClassName" IS NOT NULL THEN "SiteTree_Live"."ClassName" ELSE 'SilverStripe\\CMS\\Model\\SiteTree' END AS "RecordClassName", 'de_DE' AS "Locale", CASE WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN 'de_DE' ELSE NULL END AS "SourceLocale" FROM "SiteTree_Live" LEFT JOIN "SiteTree_Localised_Live" AS "SiteTree_Localised_de_DE" ON "SiteTree_Live"."ID" = "SiteTree_Localised_de_DE"."RecordID" AND "SiteTree_Localised_de_DE"."Locale" = ? WHERE ("SiteTree_Live"."ID" = ?) AND (("SiteTree_Localised_de_DE"."ID" IS NOT NULL)) ORDER BY "SiteTree_Live"."Sort" ASC LIMIT 1 0.0001s

Impressionen

Datenschutz