0001: SET sql_mode = ? 0.0002s

0002: SHOW DATABASES LIKE 'ss\_uhl\_web\_production' 0.0007s

0003: SHOW FULL TABLES WHERE Table_Type != 'VIEW' 0.0032s

0004: SHOW FULL FIELDS IN "Fluent_Domain" 0.0011s

0005: SHOW COLLATION LIKE 'utf8mb3_general_ci' 0.0005s

0006: 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.0003s

0007: SHOW FULL FIELDS IN "Fluent_Locale" 0.0009s

0008: SELECT DISTINCT "Fluent_Locale"."ClassName", "Fluent_Locale"."LastEdited", "Fluent_Locale"."Created", "Fluent_Locale"."Title", "Fluent_Locale"."Locale", "Fluent_Locale"."URLSegment", "Fluent_Locale"."IsGlobalDefault", "Fluent_Locale"."UseDefaultCode", "Fluent_Locale"."Sort", "Fluent_Locale"."Timezone", "Fluent_Locale"."DomainID", "Fluent_Locale"."ID", CASE WHEN "Fluent_Locale"."ClassName" IS NOT NULL THEN "Fluent_Locale"."ClassName" ELSE 'TractorCow\\Fluent\\Model\\Locale' END AS "RecordClassName" FROM "Fluent_Locale" ORDER BY "Fluent_Locale"."Sort" ASC, "Fluent_Locale"."Locale" ASC 0.0003s

0009: SELECT DISTINCT "Fluent_FallbackLocale"."ClassName", "Fluent_FallbackLocale"."LastEdited", "Fluent_FallbackLocale"."Created", "Fluent_FallbackLocale"."Sort", "Fluent_FallbackLocale"."ParentID", "Fluent_FallbackLocale"."LocaleID", "Fluent_FallbackLocale"."ID", CASE WHEN "Fluent_FallbackLocale"."ClassName" IS NOT NULL THEN "Fluent_FallbackLocale"."ClassName" ELSE 'TractorCow\\Fluent\\Model\\FallbackLocale' END AS "RecordClassName" FROM "Fluent_FallbackLocale" WHERE ("Fluent_FallbackLocale"."ParentID" = ?) ORDER BY "Fluent_FallbackLocale"."Sort" ASC 0.0005s

0010: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", "SiteTree_Live"."CanViewType", "SiteTree_Live"."CanEditType", "SiteTree_Live"."Version", CASE WHEN "SiteTree_Localised_fr_FR"."ID" IS NOT NULL THEN "SiteTree_Localised_fr_FR"."URLSegment" ELSE "SiteTree_Live"."URLSegment" END AS "URLSegment", CASE WHEN "SiteTree_Localised_fr_FR"."ID" IS NOT NULL THEN "SiteTree_Localised_fr_FR"."Title" ELSE "SiteTree_Live"."Title" END AS "Title", CASE WHEN "SiteTree_Localised_fr_FR"."ID" IS NOT NULL THEN "SiteTree_Localised_fr_FR"."MenuTitle" ELSE "SiteTree_Live"."MenuTitle" END AS "MenuTitle", CASE WHEN "SiteTree_Localised_fr_FR"."ID" IS NOT NULL THEN "SiteTree_Localised_fr_FR"."Content" ELSE "SiteTree_Live"."Content" END AS "Content", CASE WHEN "SiteTree_Localised_fr_FR"."ID" IS NOT NULL THEN "SiteTree_Localised_fr_FR"."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_fr_FR"."ID" IS NOT NULL THEN "SiteTree_Localised_fr_FR"."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", 'fr_FR' AS "Locale", CASE WHEN "SiteTree_Localised_fr_FR"."ID" IS NOT NULL THEN 'fr_FR' ELSE NULL END AS "SourceLocale" FROM "SiteTree_Live" LEFT JOIN "SiteTree_Localised_Live" AS "SiteTree_Localised_fr_FR" ON "SiteTree_Live"."ID" = "SiteTree_Localised_fr_FR"."RecordID" AND "SiteTree_Localised_fr_FR"."Locale" = ? WHERE (COALESCE("SiteTree_Localised_fr_FR"."URLSegment", "SiteTree_Live"."URLSegment") = ?) AND ("SiteTree_Live"."ParentID" = ?) AND (("SiteTree_Localised_fr_FR"."ID" IS NOT NULL)) ORDER BY "SiteTree_Live"."Sort" ASC LIMIT 1 0.0008s

0011: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", "SiteTree_Live"."CanViewType", "SiteTree_Live"."CanEditType", "SiteTree_Live"."Version", CASE WHEN "SiteTree_Localised_fr_FR"."ID" IS NOT NULL THEN "SiteTree_Localised_fr_FR"."URLSegment" ELSE "SiteTree_Live"."URLSegment" END AS "URLSegment", CASE WHEN "SiteTree_Localised_fr_FR"."ID" IS NOT NULL THEN "SiteTree_Localised_fr_FR"."Title" ELSE "SiteTree_Live"."Title" END AS "Title", CASE WHEN "SiteTree_Localised_fr_FR"."ID" IS NOT NULL THEN "SiteTree_Localised_fr_FR"."MenuTitle" ELSE "SiteTree_Live"."MenuTitle" END AS "MenuTitle", CASE WHEN "SiteTree_Localised_fr_FR"."ID" IS NOT NULL THEN "SiteTree_Localised_fr_FR"."Content" ELSE "SiteTree_Live"."Content" END AS "Content", CASE WHEN "SiteTree_Localised_fr_FR"."ID" IS NOT NULL THEN "SiteTree_Localised_fr_FR"."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_fr_FR"."ID" IS NOT NULL THEN "SiteTree_Localised_fr_FR"."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", 'fr_FR' AS "Locale", CASE WHEN "SiteTree_Localised_fr_FR"."ID" IS NOT NULL THEN 'fr_FR' ELSE NULL END AS "SourceLocale" FROM "SiteTree_Live" LEFT JOIN "SiteTree_Localised_Live" AS "SiteTree_Localised_fr_FR" ON "SiteTree_Live"."ID" = "SiteTree_Localised_fr_FR"."RecordID" AND "SiteTree_Localised_fr_FR"."Locale" = ? WHERE ("SiteTree_Live"."ParentID" = ?) AND (COALESCE("SiteTree_Localised_fr_FR"."URLSegment", "SiteTree_Live"."URLSegment") = ?) AND (("SiteTree_Localised_fr_FR"."ID" IS NOT NULL)) ORDER BY "SiteTree_Live"."Sort" ASC LIMIT 1 0.0005s

0012: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", "SiteTree_Live"."CanViewType", "SiteTree_Live"."CanEditType", "SiteTree_Live"."Version", CASE WHEN "SiteTree_Localised_fr_FR"."ID" IS NOT NULL THEN "SiteTree_Localised_fr_FR"."URLSegment" ELSE "SiteTree_Live"."URLSegment" END AS "URLSegment", CASE WHEN "SiteTree_Localised_fr_FR"."ID" IS NOT NULL THEN "SiteTree_Localised_fr_FR"."Title" ELSE "SiteTree_Live"."Title" END AS "Title", CASE WHEN "SiteTree_Localised_fr_FR"."ID" IS NOT NULL THEN "SiteTree_Localised_fr_FR"."MenuTitle" ELSE "SiteTree_Live"."MenuTitle" END AS "MenuTitle", CASE WHEN "SiteTree_Localised_fr_FR"."ID" IS NOT NULL THEN "SiteTree_Localised_fr_FR"."Content" ELSE "SiteTree_Live"."Content" END AS "Content", CASE WHEN "SiteTree_Localised_fr_FR"."ID" IS NOT NULL THEN "SiteTree_Localised_fr_FR"."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_fr_FR"."ID" IS NOT NULL THEN "SiteTree_Localised_fr_FR"."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", 'fr_FR' AS "Locale", CASE WHEN "SiteTree_Localised_fr_FR"."ID" IS NOT NULL THEN 'fr_FR' ELSE NULL END AS "SourceLocale" FROM "SiteTree_Live" LEFT JOIN "SiteTree_Localised_Live" AS "SiteTree_Localised_fr_FR" ON "SiteTree_Live"."ID" = "SiteTree_Localised_fr_FR"."RecordID" AND "SiteTree_Localised_fr_FR"."Locale" = ? WHERE ("SiteTree_Live"."ParentID" = ?) AND (COALESCE("SiteTree_Localised_fr_FR"."URLSegment", "SiteTree_Live"."URLSegment") = ?) AND (("SiteTree_Localised_fr_FR"."ID" IS NOT NULL)) ORDER BY "SiteTree_Live"."Sort" ASC LIMIT 1 0.0005s

0013: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", "SiteTree_Live"."CanViewType", "SiteTree_Live"."CanEditType", "SiteTree_Live"."Version", CASE WHEN "SiteTree_Localised_fr_FR"."ID" IS NOT NULL THEN "SiteTree_Localised_fr_FR"."URLSegment" ELSE "SiteTree_Live"."URLSegment" END AS "URLSegment", CASE WHEN "SiteTree_Localised_fr_FR"."ID" IS NOT NULL THEN "SiteTree_Localised_fr_FR"."Title" ELSE "SiteTree_Live"."Title" END AS "Title", CASE WHEN "SiteTree_Localised_fr_FR"."ID" IS NOT NULL THEN "SiteTree_Localised_fr_FR"."MenuTitle" ELSE "SiteTree_Live"."MenuTitle" END AS "MenuTitle", CASE WHEN "SiteTree_Localised_fr_FR"."ID" IS NOT NULL THEN "SiteTree_Localised_fr_FR"."Content" ELSE "SiteTree_Live"."Content" END AS "Content", CASE WHEN "SiteTree_Localised_fr_FR"."ID" IS NOT NULL THEN "SiteTree_Localised_fr_FR"."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_fr_FR"."ID" IS NOT NULL THEN "SiteTree_Localised_fr_FR"."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", 'fr_FR' AS "Locale", CASE WHEN "SiteTree_Localised_fr_FR"."ID" IS NOT NULL THEN 'fr_FR' ELSE NULL END AS "SourceLocale" FROM "SiteTree_Live" LEFT JOIN "SiteTree_Localised_Live" AS "SiteTree_Localised_fr_FR" ON "SiteTree_Live"."ID" = "SiteTree_Localised_fr_FR"."RecordID" AND "SiteTree_Localised_fr_FR"."Locale" = ? WHERE ("SiteTree_Live"."ID" = ?) AND (("SiteTree_Localised_fr_FR"."ID" IS NOT NULL)) ORDER BY "SiteTree_Live"."Sort" ASC LIMIT 1 0.0005s

0014: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", "SiteTree_Live"."CanViewType", "SiteTree_Live"."CanEditType", "SiteTree_Live"."Version", CASE WHEN "SiteTree_Localised_fr_FR"."ID" IS NOT NULL THEN "SiteTree_Localised_fr_FR"."URLSegment" ELSE "SiteTree_Live"."URLSegment" END AS "URLSegment", CASE WHEN "SiteTree_Localised_fr_FR"."ID" IS NOT NULL THEN "SiteTree_Localised_fr_FR"."Title" ELSE "SiteTree_Live"."Title" END AS "Title", CASE WHEN "SiteTree_Localised_fr_FR"."ID" IS NOT NULL THEN "SiteTree_Localised_fr_FR"."MenuTitle" ELSE "SiteTree_Live"."MenuTitle" END AS "MenuTitle", CASE WHEN "SiteTree_Localised_fr_FR"."ID" IS NOT NULL THEN "SiteTree_Localised_fr_FR"."Content" ELSE "SiteTree_Live"."Content" END AS "Content", CASE WHEN "SiteTree_Localised_fr_FR"."ID" IS NOT NULL THEN "SiteTree_Localised_fr_FR"."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_fr_FR"."ID" IS NOT NULL THEN "SiteTree_Localised_fr_FR"."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", 'fr_FR' AS "Locale", CASE WHEN "SiteTree_Localised_fr_FR"."ID" IS NOT NULL THEN 'fr_FR' ELSE NULL END AS "SourceLocale" FROM "SiteTree_Live" LEFT JOIN "SiteTree_Localised_Live" AS "SiteTree_Localised_fr_FR" ON "SiteTree_Live"."ID" = "SiteTree_Localised_fr_FR"."RecordID" AND "SiteTree_Localised_fr_FR"."Locale" = ? WHERE ("SiteTree_Live"."ID" = ?) AND (("SiteTree_Localised_fr_FR"."ID" IS NOT NULL)) ORDER BY "SiteTree_Live"."Sort" ASC LIMIT 1 0.0002s

0015: SELECT DISTINCT "SiteConfig"."ClassName", "SiteConfig"."LastEdited", "SiteConfig"."Created", CASE WHEN "SiteConfig_Localised_fr_FR"."ID" IS NOT NULL THEN "SiteConfig_Localised_fr_FR"."CookieConsentTitle" ELSE "SiteConfig"."CookieConsentTitle" END AS "CookieConsentTitle", CASE WHEN "SiteConfig_Localised_fr_FR"."ID" IS NOT NULL THEN "SiteConfig_Localised_fr_FR"."CookieConsentContent" ELSE "SiteConfig"."CookieConsentContent" END AS "CookieConsentContent", CASE WHEN "SiteConfig_Localised_fr_FR"."ID" IS NOT NULL THEN "SiteConfig_Localised_fr_FR"."FormularDatenschutztext" ELSE "SiteConfig"."FormularDatenschutztext" END AS "FormularDatenschutztext", "SiteConfig"."ExtraCSS", "SiteConfig"."bingAPIKey", CASE WHEN "SiteConfig_Localised_fr_FR"."ID" IS NOT NULL THEN "SiteConfig_Localised_fr_FR"."CostHint" ELSE "SiteConfig"."CostHint" END AS "CostHint", CASE WHEN "SiteConfig_Localised_fr_FR"."ID" IS NOT NULL THEN "SiteConfig_Localised_fr_FR"."HintPayment" ELSE "SiteConfig"."HintPayment" END AS "HintPayment", CASE WHEN "SiteConfig_Localised_fr_FR"."ID" IS NOT NULL THEN "SiteConfig_Localised_fr_FR"."HintAfterPayment" ELSE "SiteConfig"."HintAfterPayment" END AS "HintAfterPayment", CASE WHEN "SiteConfig_Localised_fr_FR"."ID" IS NOT NULL THEN "SiteConfig_Localised_fr_FR"."ReceiptHeader" ELSE "SiteConfig"."ReceiptHeader" END AS "ReceiptHeader", CASE WHEN "SiteConfig_Localised_fr_FR"."ID" IS NOT NULL THEN "SiteConfig_Localised_fr_FR"."ReceiptFooter" ELSE "SiteConfig"."ReceiptFooter" END AS "ReceiptFooter", "SiteConfig"."AdminNotificationMail", "SiteConfig"."AllowedCountries", CASE WHEN "SiteConfig_Localised_fr_FR"."ID" IS NOT NULL THEN "SiteConfig_Localised_fr_FR"."ContactEmail" ELSE "SiteConfig"."ContactEmail" END AS "ContactEmail", "SiteConfig"."ContactPhone", CASE WHEN "SiteConfig_Localised_fr_FR"."ID" IS NOT NULL THEN "SiteConfig_Localised_fr_FR"."Copyright" ELSE "SiteConfig"."Copyright" END AS "Copyright", CASE WHEN "SiteConfig_Localised_fr_FR"."ID" IS NOT NULL THEN "SiteConfig_Localised_fr_FR"."ApplyFormReply" ELSE "SiteConfig"."ApplyFormReply" END AS "ApplyFormReply", CASE WHEN "SiteConfig_Localised_fr_FR"."ID" IS NOT NULL THEN "SiteConfig_Localised_fr_FR"."ApplyFormReplySubject" ELSE "SiteConfig"."ApplyFormReplySubject" END AS "ApplyFormReplySubject", CASE WHEN "SiteConfig_Localised_fr_FR"."ID" IS NOT NULL THEN "SiteConfig_Localised_fr_FR"."FooterContent" ELSE "SiteConfig"."FooterContent" END AS "FooterContent", "SiteConfig"."PrimaryColor", "SiteConfig"."SecondaryColor", "SiteConfig"."FontColor", "SiteConfig"."SideBarColor", "SiteConfig"."JobDefaultRecipient", CASE WHEN "SiteConfig_Localised_fr_FR"."ID" IS NOT NULL THEN "SiteConfig_Localised_fr_FR"."QuickApplyButtonCaption" ELSE "SiteConfig"."QuickApplyButtonCaption" END AS "QuickApplyButtonCaption", CASE WHEN "SiteConfig_Localised_fr_FR"."ID" IS NOT NULL THEN "SiteConfig_Localised_fr_FR"."QuickApplyTitle" ELSE "SiteConfig"."QuickApplyTitle" END AS "QuickApplyTitle", CASE WHEN "SiteConfig_Localised_fr_FR"."ID" IS NOT NULL THEN "SiteConfig_Localised_fr_FR"."CookieConsentHint" ELSE "SiteConfig"."CookieConsentHint" END AS "CookieConsentHint", CASE WHEN "SiteConfig_Localised_fr_FR"."ID" IS NOT NULL THEN "SiteConfig_Localised_fr_FR"."TrackingCode" ELSE "SiteConfig"."TrackingCode" END AS "TrackingCode", CASE WHEN "SiteConfig_Localised_fr_FR"."ID" IS NOT NULL THEN "SiteConfig_Localised_fr_FR"."BadgeTitle" ELSE "SiteConfig"."BadgeTitle" END AS "BadgeTitle", CASE WHEN "SiteConfig_Localised_fr_FR"."ID" IS NOT NULL THEN "SiteConfig_Localised_fr_FR"."BadgeSubTitle" ELSE "SiteConfig"."BadgeSubTitle" END AS "BadgeSubTitle", CASE WHEN "SiteConfig_Localised_fr_FR"."ID" IS NOT NULL THEN "SiteConfig_Localised_fr_FR"."BadgeExternalLink" ELSE "SiteConfig"."BadgeExternalLink" END AS "BadgeExternalLink", CASE WHEN "SiteConfig_Localised_fr_FR"."ID" IS NOT NULL THEN "SiteConfig_Localised_fr_FR"."ContactButtonCaption" ELSE "SiteConfig"."ContactButtonCaption" END AS "ContactButtonCaption", "SiteConfig"."BadgeColor", "SiteConfig"."ShippingCost", "SiteConfig"."ShippingFreeTreshold", CASE WHEN "SiteConfig_Localised_fr_FR"."ID" IS NOT NULL THEN "SiteConfig_Localised_fr_FR"."ReceiptHeaderText" ELSE "SiteConfig"."ReceiptHeaderText" END AS "ReceiptHeaderText", CASE WHEN "SiteConfig_Localised_fr_FR"."ID" IS NOT NULL THEN "SiteConfig_Localised_fr_FR"."FooterFirstMenuTitle" ELSE "SiteConfig"."FooterFirstMenuTitle" END AS "FooterFirstMenuTitle", CASE WHEN "SiteConfig_Localised_fr_FR"."ID" IS NOT NULL THEN "SiteConfig_Localised_fr_FR"."FooterSecondMenuTitle" ELSE "SiteConfig"."FooterSecondMenuTitle" END AS "FooterSecondMenuTitle", CASE WHEN "SiteConfig_Localised_fr_FR"."ID" IS NOT NULL THEN "SiteConfig_Localised_fr_FR"."FooterThirdMenuTitle" ELSE "SiteConfig"."FooterThirdMenuTitle" END AS "FooterThirdMenuTitle", CASE WHEN "SiteConfig_Localised_fr_FR"."ID" IS NOT NULL THEN "SiteConfig_Localised_fr_FR"."FooterFourthMenuTitle" ELSE "SiteConfig"."FooterFourthMenuTitle" END AS "FooterFourthMenuTitle", CASE WHEN "SiteConfig_Localised_fr_FR"."ID" IS NOT NULL THEN "SiteConfig_Localised_fr_FR"."FooterFifthMenuTitle" ELSE "SiteConfig"."FooterFifthMenuTitle" END AS "FooterFifthMenuTitle", "SiteConfig"."AccountingMailAddress", "SiteConfig"."ExternalContent", "SiteConfig"."PurchaseCompleteMessageUnpaid", "SiteConfig"."ManualPaymentInformation", "SiteConfig"."LatePaymentHint", CASE WHEN "SiteConfig_Localised_fr_FR"."ID" IS NOT NULL THEN "SiteConfig_Localised_fr_FR"."Title" ELSE "SiteConfig"."Title" END AS "Title", CASE WHEN "SiteConfig_Localised_fr_FR"."ID" IS NOT NULL THEN "SiteConfig_Localised_fr_FR"."Tagline" ELSE "SiteConfig"."Tagline" END AS "Tagline", "SiteConfig"."CanViewType", "SiteConfig"."CanEditType", "SiteConfig"."CanCreateTopLevelType", "SiteConfig"."CMSLogoID", "SiteConfig"."ContactTeamMemberID", "SiteConfig"."ReceiptLogoID", "SiteConfig"."TermsPageID", "SiteConfig"."CustomerGroupID", "SiteConfig"."DefaultProductImageID", "SiteConfig"."BadgeLinkedPageID", "SiteConfig"."ContactLinkedPageID", "SiteConfig"."DefaultHeaderImageID", "SiteConfig"."DealerPageID", "SiteConfig"."ID", CASE WHEN "SiteConfig"."ClassName" IS NOT NULL THEN "SiteConfig"."ClassName" ELSE 'SilverStripe\\SiteConfig\\SiteConfig' END AS "RecordClassName", 'fr_FR' AS "Locale", CASE WHEN "SiteConfig_Localised_fr_FR"."ID" IS NOT NULL THEN 'fr_FR' ELSE NULL END AS "SourceLocale" FROM "SiteConfig" LEFT JOIN "SiteConfig_Localised" AS "SiteConfig_Localised_fr_FR" ON "SiteConfig"."ID" = "SiteConfig_Localised_fr_FR"."RecordID" AND "SiteConfig_Localised_fr_FR"."Locale" = ? LIMIT 1 0.001s

0016: SELECT DISTINCT "PublishDate" IS NULL AS "_SortColumn0", "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "BlogPost_Live"."ShowOnHomePage", CASE WHEN "BlogPost_Localised_fr_FR"."ID" IS NOT NULL THEN "BlogPost_Localised_fr_FR"."ReadingTime" ELSE "BlogPost_Live"."ReadingTime" END AS "ReadingTime", CASE WHEN "BlogPost_Localised_fr_FR"."ID" IS NOT NULL THEN "BlogPost_Localised_fr_FR"."iFrame" ELSE "BlogPost_Live"."iFrame" END AS "iFrame", "BlogPost_Live"."PublishDate", CASE WHEN "BlogPost_Localised_fr_FR"."ID" IS NOT NULL THEN "BlogPost_Localised_fr_FR"."AuthorNames" ELSE "BlogPost_Live"."AuthorNames" END AS "AuthorNames", CASE WHEN "BlogPost_Localised_fr_FR"."ID" IS NOT NULL THEN "BlogPost_Localised_fr_FR"."Summary" ELSE "BlogPost_Live"."Summary" END AS "Summary", "BlogPost_Live"."TeamMemberID", "BlogPost_Live"."FeaturedImageID", "SiteTree_Live"."ID", CASE WHEN "SiteTree_Live"."ClassName" IS NOT NULL THEN "SiteTree_Live"."ClassName" ELSE 'SilverStripe\\CMS\\Model\\SiteTree' END AS "RecordClassName", 'fr_FR' AS "Locale", CASE WHEN "BlogPost_Localised_fr_FR"."ID" IS NOT NULL THEN 'fr_FR' ELSE NULL END AS "SourceLocale" FROM "SiteTree_Live" LEFT JOIN "BlogPost_Live" ON "BlogPost_Live"."ID" = "SiteTree_Live"."ID" LEFT JOIN "Page_Live" ON "Page_Live"."ID" = "SiteTree_Live"."ID" LEFT JOIN "SiteTree_Localised_Live" AS "SiteTree_Localised_fr_FR" ON "SiteTree_Live"."ID" = "SiteTree_Localised_fr_FR"."RecordID" AND "SiteTree_Localised_fr_FR"."Locale" = ? LEFT JOIN "Page_Localised_Live" AS "Page_Localised_fr_FR" ON "Page_Live"."ID" = "Page_Localised_fr_FR"."RecordID" AND "Page_Localised_fr_FR"."Locale" = ? LEFT JOIN "BlogPost_Localised_Live" AS "BlogPost_Localised_fr_FR" ON "BlogPost_Live"."ID" = "BlogPost_Localised_fr_FR"."RecordID" AND "BlogPost_Localised_fr_FR"."Locale" = ? WHERE ("SiteTree_Live"."ID" = ?) AND ("SiteTree_Live"."ClassName" IN (?)) AND (("SiteTree_Localised_fr_FR"."ID" IS NOT NULL)) AND ("PublishDate" < '2025-11-17 09:05:06') ORDER BY "_SortColumn0" DESC, "BlogPost_Live"."PublishDate" DESC LIMIT 1 0.0008s

0017: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "Page_Live"."ShowContactPerson", CASE WHEN "Page_Localised_fr_FR"."ID" IS NOT NULL THEN "Page_Localised_fr_FR"."OGTitleCustom" ELSE "Page_Live"."OGTitleCustom" END AS "OGTitleCustom", CASE WHEN "Page_Localised_fr_FR"."ID" IS NOT NULL THEN "Page_Localised_fr_FR"."OGDescriptionCustom" ELSE "Page_Live"."OGDescriptionCustom" END AS "OGDescriptionCustom", CASE WHEN "Page_Localised_fr_FR"."ID" IS NOT NULL THEN "Page_Localised_fr_FR"."SubTitle" ELSE "Page_Live"."SubTitle" END AS "SubTitle", "Page_Live"."ShowInFooterMenu", "Page_Live"."ShowInTopBar", CASE WHEN "Page_Localised_fr_FR"."ID" IS NOT NULL THEN "Page_Localised_fr_FR"."MetaTitle" ELSE "Page_Live"."MetaTitle" END AS "MetaTitle", "Page_Live"."ShowPageHeaderTitle", "Page_Live"."ShowQuickApply", "Page_Live"."ShowInNaviEingeklappt", CASE WHEN "Page_Localised_fr_FR"."ID" IS NOT NULL THEN "Page_Localised_fr_FR"."RelatedPagesHeadline" ELSE "Page_Live"."RelatedPagesHeadline" END AS "RelatedPagesHeadline", "Page_Live"."ShowSolidNavigation", "Page_Live"."ContactTeamMemberID", "Page_Live"."OGImageCustomID", "Page_Live"."PinterestImageCustomID", "Page_Live"."HeaderImageID", "Page_Live"."CustomCanonicalSiteID", "SiteTree_Live"."ID", CASE WHEN "SiteTree_Live"."ClassName" IS NOT NULL THEN "SiteTree_Live"."ClassName" ELSE 'SilverStripe\\CMS\\Model\\SiteTree' END AS "RecordClassName", 'fr_FR' AS "Locale", CASE WHEN "Page_Localised_fr_FR"."ID" IS NOT NULL THEN 'fr_FR' ELSE NULL END AS "SourceLocale", "SiteTree_Live"."Sort" FROM "SiteTree_Live" LEFT JOIN "Page_Live" ON "Page_Live"."ID" = "SiteTree_Live"."ID" INNER JOIN "BlogPost_Live" ON "SiteTree_Live"."ID" = "BlogPost_Live"."ID" LEFT JOIN "SiteTree_Localised_Live" AS "SiteTree_Localised_fr_FR" ON "SiteTree_Live"."ID" = "SiteTree_Localised_fr_FR"."RecordID" AND "SiteTree_Localised_fr_FR"."Locale" = ? LEFT JOIN "Page_Localised_Live" AS "Page_Localised_fr_FR" ON "Page_Live"."ID" = "Page_Localised_fr_FR"."RecordID" AND "Page_Localised_fr_FR"."Locale" = ? WHERE ("SiteTree_Live"."ID" = ?) AND ("SiteTree_Live"."ClassName" IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)) AND (("SiteTree_Localised_fr_FR"."ID" IS NOT NULL)) ORDER BY "SiteTree_Live"."Sort" ASC LIMIT 1 0.0008s

0018: SELECT "ID" FROM "SiteTree_Localised_Live" WHERE ("RecordID" = ?) AND ("Locale" = ?) LIMIT 1 0.0003s

0019: SELECT DISTINCT "Fluent_FallbackLocale"."ClassName", "Fluent_FallbackLocale"."LastEdited", "Fluent_FallbackLocale"."Created", "Fluent_FallbackLocale"."Sort", "Fluent_FallbackLocale"."ParentID", "Fluent_FallbackLocale"."LocaleID", "Fluent_FallbackLocale"."ID", CASE WHEN "Fluent_FallbackLocale"."ClassName" IS NOT NULL THEN "Fluent_FallbackLocale"."ClassName" ELSE 'TractorCow\\Fluent\\Model\\FallbackLocale' END AS "RecordClassName" FROM "Fluent_FallbackLocale" WHERE ("Fluent_FallbackLocale"."ParentID" = ?) ORDER BY "Fluent_FallbackLocale"."Sort" ASC 0.0002s

0020: SELECT DISTINCT "PublishDate" IS NULL AS "_SortColumn0", "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", "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"."ShowContactPerson", CASE WHEN "Page_Localised_de_DE"."ID" IS NOT NULL THEN "Page_Localised_de_DE"."OGTitleCustom" ELSE "Page_Live"."OGTitleCustom" END AS "OGTitleCustom", CASE WHEN "Page_Localised_de_DE"."ID" IS NOT NULL THEN "Page_Localised_de_DE"."OGDescriptionCustom" ELSE "Page_Live"."OGDescriptionCustom" END AS "OGDescriptionCustom", CASE WHEN "Page_Localised_de_DE"."ID" IS NOT NULL THEN "Page_Localised_de_DE"."SubTitle" ELSE "Page_Live"."SubTitle" END AS "SubTitle", "Page_Live"."ShowInFooterMenu", "Page_Live"."ShowInTopBar", CASE WHEN "Page_Localised_de_DE"."ID" IS NOT NULL THEN "Page_Localised_de_DE"."MetaTitle" ELSE "Page_Live"."MetaTitle" END AS "MetaTitle", "Page_Live"."ShowPageHeaderTitle", "Page_Live"."ShowQuickApply", "Page_Live"."ShowInNaviEingeklappt", CASE WHEN "Page_Localised_de_DE"."ID" IS NOT NULL THEN "Page_Localised_de_DE"."RelatedPagesHeadline" ELSE "Page_Live"."RelatedPagesHeadline" END AS "RelatedPagesHeadline", "Page_Live"."ShowSolidNavigation", "Page_Live"."ContactTeamMemberID", "Page_Live"."OGImageCustomID", "Page_Live"."PinterestImageCustomID", "Page_Live"."HeaderImageID", "Page_Live"."CustomCanonicalSiteID", "BlogPost_Live"."ShowOnHomePage", CASE WHEN "BlogPost_Localised_de_DE"."ID" IS NOT NULL THEN "BlogPost_Localised_de_DE"."ReadingTime" ELSE "BlogPost_Live"."ReadingTime" END AS "ReadingTime", CASE WHEN "BlogPost_Localised_de_DE"."ID" IS NOT NULL THEN "BlogPost_Localised_de_DE"."iFrame" ELSE "BlogPost_Live"."iFrame" END AS "iFrame", "BlogPost_Live"."PublishDate", CASE WHEN "BlogPost_Localised_de_DE"."ID" IS NOT NULL THEN "BlogPost_Localised_de_DE"."AuthorNames" ELSE "BlogPost_Live"."AuthorNames" END AS "AuthorNames", CASE WHEN "BlogPost_Localised_de_DE"."ID" IS NOT NULL THEN "BlogPost_Localised_de_DE"."Summary" ELSE "BlogPost_Live"."Summary" END AS "Summary", "BlogPost_Live"."TeamMemberID", "BlogPost_Live"."FeaturedImageID", "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 "BlogPost_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 "BlogPost_Live" ON "BlogPost_Live"."ID" = "SiteTree_Live"."ID" LEFT JOIN "SiteTree_Localised_Live" AS "SiteTree_Localised_de_DE" ON "SiteTree_Live"."ID" = "SiteTree_Localised_de_DE"."RecordID" AND "SiteTree_Localised_de_DE"."Locale" = ? LEFT JOIN "Page_Localised_Live" AS "Page_Localised_de_DE" ON "Page_Live"."ID" = "Page_Localised_de_DE"."RecordID" AND "Page_Localised_de_DE"."Locale" = ? LEFT JOIN "BlogPost_Localised_Live" AS "BlogPost_Localised_de_DE" ON "BlogPost_Live"."ID" = "BlogPost_Localised_de_DE"."RecordID" AND "BlogPost_Localised_de_DE"."Locale" = ? WHERE ("SiteTree_Live"."ID" = ?) AND ("SiteTree_Live"."ClassName" IN (?)) AND (("SiteTree_Localised_de_DE"."ID" IS NOT NULL)) AND ("PublishDate" < '2025-11-17 09:05:06') ORDER BY "_SortColumn0" DESC, "BlogPost_Live"."PublishDate" DESC LIMIT 1 0.0007s

0021: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", "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.0004s

0022: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", "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.0002s

0023: SELECT "ID" FROM "SiteTree_Localised_Live" WHERE ("RecordID" = ?) AND ("Locale" = ?) LIMIT 1 0.0001s

0024: SELECT DISTINCT "PublishDate" IS NULL AS "_SortColumn0", "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", "SiteTree_Live"."CanViewType", "SiteTree_Live"."CanEditType", "SiteTree_Live"."Version", CASE WHEN "SiteTree_Localised_fr_FR"."ID" IS NOT NULL THEN "SiteTree_Localised_fr_FR"."URLSegment" ELSE "SiteTree_Live"."URLSegment" END AS "URLSegment", CASE WHEN "SiteTree_Localised_fr_FR"."ID" IS NOT NULL THEN "SiteTree_Localised_fr_FR"."Title" ELSE "SiteTree_Live"."Title" END AS "Title", CASE WHEN "SiteTree_Localised_fr_FR"."ID" IS NOT NULL THEN "SiteTree_Localised_fr_FR"."MenuTitle" ELSE "SiteTree_Live"."MenuTitle" END AS "MenuTitle", CASE WHEN "SiteTree_Localised_fr_FR"."ID" IS NOT NULL THEN "SiteTree_Localised_fr_FR"."Content" ELSE "SiteTree_Live"."Content" END AS "Content", CASE WHEN "SiteTree_Localised_fr_FR"."ID" IS NOT NULL THEN "SiteTree_Localised_fr_FR"."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_fr_FR"."ID" IS NOT NULL THEN "SiteTree_Localised_fr_FR"."ReportClass" ELSE "SiteTree_Live"."ReportClass" END AS "ReportClass", "SiteTree_Live"."ParentID", "Page_Live"."ShowContactPerson", CASE WHEN "Page_Localised_fr_FR"."ID" IS NOT NULL THEN "Page_Localised_fr_FR"."OGTitleCustom" ELSE "Page_Live"."OGTitleCustom" END AS "OGTitleCustom", CASE WHEN "Page_Localised_fr_FR"."ID" IS NOT NULL THEN "Page_Localised_fr_FR"."OGDescriptionCustom" ELSE "Page_Live"."OGDescriptionCustom" END AS "OGDescriptionCustom", CASE WHEN "Page_Localised_fr_FR"."ID" IS NOT NULL THEN "Page_Localised_fr_FR"."SubTitle" ELSE "Page_Live"."SubTitle" END AS "SubTitle", "Page_Live"."ShowInFooterMenu", "Page_Live"."ShowInTopBar", CASE WHEN "Page_Localised_fr_FR"."ID" IS NOT NULL THEN "Page_Localised_fr_FR"."MetaTitle" ELSE "Page_Live"."MetaTitle" END AS "MetaTitle", "Page_Live"."ShowPageHeaderTitle", "Page_Live"."ShowQuickApply", "Page_Live"."ShowInNaviEingeklappt", CASE WHEN "Page_Localised_fr_FR"."ID" IS NOT NULL THEN "Page_Localised_fr_FR"."RelatedPagesHeadline" ELSE "Page_Live"."RelatedPagesHeadline" END AS "RelatedPagesHeadline", "Page_Live"."ShowSolidNavigation", "Page_Live"."ContactTeamMemberID", "Page_Live"."OGImageCustomID", "Page_Live"."PinterestImageCustomID", "Page_Live"."HeaderImageID", "Page_Live"."CustomCanonicalSiteID", "BlogPost_Live"."ShowOnHomePage", CASE WHEN "BlogPost_Localised_fr_FR"."ID" IS NOT NULL THEN "BlogPost_Localised_fr_FR"."ReadingTime" ELSE "BlogPost_Live"."ReadingTime" END AS "ReadingTime", CASE WHEN "BlogPost_Localised_fr_FR"."ID" IS NOT NULL THEN "BlogPost_Localised_fr_FR"."iFrame" ELSE "BlogPost_Live"."iFrame" END AS "iFrame", "BlogPost_Live"."PublishDate", CASE WHEN "BlogPost_Localised_fr_FR"."ID" IS NOT NULL THEN "BlogPost_Localised_fr_FR"."AuthorNames" ELSE "BlogPost_Live"."AuthorNames" END AS "AuthorNames", CASE WHEN "BlogPost_Localised_fr_FR"."ID" IS NOT NULL THEN "BlogPost_Localised_fr_FR"."Summary" ELSE "BlogPost_Live"."Summary" END AS "Summary", "BlogPost_Live"."TeamMemberID", "BlogPost_Live"."FeaturedImageID", "SiteTree_Live"."ID", CASE WHEN "SiteTree_Live"."ClassName" IS NOT NULL THEN "SiteTree_Live"."ClassName" ELSE 'SilverStripe\\CMS\\Model\\SiteTree' END AS "RecordClassName", 'fr_FR' AS "Locale", CASE WHEN "BlogPost_Localised_fr_FR"."ID" IS NOT NULL THEN 'fr_FR' ELSE NULL END AS "SourceLocale" FROM "SiteTree_Live" LEFT JOIN "Page_Live" ON "Page_Live"."ID" = "SiteTree_Live"."ID" LEFT JOIN "BlogPost_Live" ON "BlogPost_Live"."ID" = "SiteTree_Live"."ID" LEFT JOIN "SiteTree_Localised_Live" AS "SiteTree_Localised_fr_FR" ON "SiteTree_Live"."ID" = "SiteTree_Localised_fr_FR"."RecordID" AND "SiteTree_Localised_fr_FR"."Locale" = ? LEFT JOIN "Page_Localised_Live" AS "Page_Localised_fr_FR" ON "Page_Live"."ID" = "Page_Localised_fr_FR"."RecordID" AND "Page_Localised_fr_FR"."Locale" = ? LEFT JOIN "BlogPost_Localised_Live" AS "BlogPost_Localised_fr_FR" ON "BlogPost_Live"."ID" = "BlogPost_Localised_fr_FR"."RecordID" AND "BlogPost_Localised_fr_FR"."Locale" = ? WHERE ("SiteTree_Live"."ID" = ?) AND ("SiteTree_Live"."ClassName" IN (?)) AND (("SiteTree_Localised_fr_FR"."ID" IS NOT NULL)) AND ("PublishDate" < '2025-11-17 09:05:06') ORDER BY "_SortColumn0" DESC, "BlogPost_Live"."PublishDate" DESC LIMIT 1 0.0006s

0025: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", "SiteTree_Live"."CanViewType", "SiteTree_Live"."CanEditType", "SiteTree_Live"."Version", CASE WHEN "SiteTree_Localised_fr_FR"."ID" IS NOT NULL THEN "SiteTree_Localised_fr_FR"."URLSegment" ELSE "SiteTree_Live"."URLSegment" END AS "URLSegment", CASE WHEN "SiteTree_Localised_fr_FR"."ID" IS NOT NULL THEN "SiteTree_Localised_fr_FR"."Title" ELSE "SiteTree_Live"."Title" END AS "Title", CASE WHEN "SiteTree_Localised_fr_FR"."ID" IS NOT NULL THEN "SiteTree_Localised_fr_FR"."MenuTitle" ELSE "SiteTree_Live"."MenuTitle" END AS "MenuTitle", CASE WHEN "SiteTree_Localised_fr_FR"."ID" IS NOT NULL THEN "SiteTree_Localised_fr_FR"."Content" ELSE "SiteTree_Live"."Content" END AS "Content", CASE WHEN "SiteTree_Localised_fr_FR"."ID" IS NOT NULL THEN "SiteTree_Localised_fr_FR"."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_fr_FR"."ID" IS NOT NULL THEN "SiteTree_Localised_fr_FR"."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", 'fr_FR' AS "Locale", CASE WHEN "SiteTree_Localised_fr_FR"."ID" IS NOT NULL THEN 'fr_FR' ELSE NULL END AS "SourceLocale" FROM "SiteTree_Live" LEFT JOIN "SiteTree_Localised_Live" AS "SiteTree_Localised_fr_FR" ON "SiteTree_Live"."ID" = "SiteTree_Localised_fr_FR"."RecordID" AND "SiteTree_Localised_fr_FR"."Locale" = ? WHERE ("SiteTree_Live"."ID" = ?) AND (("SiteTree_Localised_fr_FR"."ID" IS NOT NULL)) ORDER BY "SiteTree_Live"."Sort" ASC LIMIT 1 0.0002s

0026: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", "SiteTree_Live"."CanViewType", "SiteTree_Live"."CanEditType", "SiteTree_Live"."Version", CASE WHEN "SiteTree_Localised_fr_FR"."ID" IS NOT NULL THEN "SiteTree_Localised_fr_FR"."URLSegment" ELSE "SiteTree_Live"."URLSegment" END AS "URLSegment", CASE WHEN "SiteTree_Localised_fr_FR"."ID" IS NOT NULL THEN "SiteTree_Localised_fr_FR"."Title" ELSE "SiteTree_Live"."Title" END AS "Title", CASE WHEN "SiteTree_Localised_fr_FR"."ID" IS NOT NULL THEN "SiteTree_Localised_fr_FR"."MenuTitle" ELSE "SiteTree_Live"."MenuTitle" END AS "MenuTitle", CASE WHEN "SiteTree_Localised_fr_FR"."ID" IS NOT NULL THEN "SiteTree_Localised_fr_FR"."Content" ELSE "SiteTree_Live"."Content" END AS "Content", CASE WHEN "SiteTree_Localised_fr_FR"."ID" IS NOT NULL THEN "SiteTree_Localised_fr_FR"."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_fr_FR"."ID" IS NOT NULL THEN "SiteTree_Localised_fr_FR"."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", 'fr_FR' AS "Locale", CASE WHEN "SiteTree_Localised_fr_FR"."ID" IS NOT NULL THEN 'fr_FR' ELSE NULL END AS "SourceLocale" FROM "SiteTree_Live" LEFT JOIN "SiteTree_Localised_Live" AS "SiteTree_Localised_fr_FR" ON "SiteTree_Live"."ID" = "SiteTree_Localised_fr_FR"."RecordID" AND "SiteTree_Localised_fr_FR"."Locale" = ? WHERE ("SiteTree_Live"."ID" = ?) AND (("SiteTree_Localised_fr_FR"."ID" IS NOT NULL)) ORDER BY "SiteTree_Live"."Sort" ASC LIMIT 1 0.0002s

0027: SELECT DISTINCT "File_Live"."ClassName", "File_Live"."LastEdited", "File_Live"."Created", "File_Live"."Version", "File_Live"."CanViewType", "File_Live"."CanEditType", "File_Live"."Name", "File_Live"."Title", "File_Live"."ShowInSearch", "File_Live"."ParentID", "File_Live"."OwnerID", "File_Live"."FileHash", "File_Live"."FileFilename", "File_Live"."FileVariant", "Image_Live"."CropData", "Image_Live"."AltText", "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.0006s

0028: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", "SiteTree_Live"."CanViewType", "SiteTree_Live"."CanEditType", "SiteTree_Live"."Version", CASE WHEN "SiteTree_Localised_fr_FR"."ID" IS NOT NULL THEN "SiteTree_Localised_fr_FR"."URLSegment" ELSE "SiteTree_Live"."URLSegment" END AS "URLSegment", CASE WHEN "SiteTree_Localised_fr_FR"."ID" IS NOT NULL THEN "SiteTree_Localised_fr_FR"."Title" ELSE "SiteTree_Live"."Title" END AS "Title", CASE WHEN "SiteTree_Localised_fr_FR"."ID" IS NOT NULL THEN "SiteTree_Localised_fr_FR"."MenuTitle" ELSE "SiteTree_Live"."MenuTitle" END AS "MenuTitle", CASE WHEN "SiteTree_Localised_fr_FR"."ID" IS NOT NULL THEN "SiteTree_Localised_fr_FR"."Content" ELSE "SiteTree_Live"."Content" END AS "Content", CASE WHEN "SiteTree_Localised_fr_FR"."ID" IS NOT NULL THEN "SiteTree_Localised_fr_FR"."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_fr_FR"."ID" IS NOT NULL THEN "SiteTree_Localised_fr_FR"."ReportClass" ELSE "SiteTree_Live"."ReportClass" END AS "ReportClass", "SiteTree_Live"."ParentID", "Page_Live"."ShowContactPerson", CASE WHEN "Page_Localised_fr_FR"."ID" IS NOT NULL THEN "Page_Localised_fr_FR"."OGTitleCustom" ELSE "Page_Live"."OGTitleCustom" END AS "OGTitleCustom", CASE WHEN "Page_Localised_fr_FR"."ID" IS NOT NULL THEN "Page_Localised_fr_FR"."OGDescriptionCustom" ELSE "Page_Live"."OGDescriptionCustom" END AS "OGDescriptionCustom", CASE WHEN "Page_Localised_fr_FR"."ID" IS NOT NULL THEN "Page_Localised_fr_FR"."SubTitle" ELSE "Page_Live"."SubTitle" END AS "SubTitle", "Page_Live"."ShowInFooterMenu", "Page_Live"."ShowInTopBar", CASE WHEN "Page_Localised_fr_FR"."ID" IS NOT NULL THEN "Page_Localised_fr_FR"."MetaTitle" ELSE "Page_Live"."MetaTitle" END AS "MetaTitle", "Page_Live"."ShowPageHeaderTitle", "Page_Live"."ShowQuickApply", "Page_Live"."ShowInNaviEingeklappt", CASE WHEN "Page_Localised_fr_FR"."ID" IS NOT NULL THEN "Page_Localised_fr_FR"."RelatedPagesHeadline" ELSE "Page_Live"."RelatedPagesHeadline" END AS "RelatedPagesHeadline", "Page_Live"."ShowSolidNavigation", "Page_Live"."ContactTeamMemberID", "Page_Live"."OGImageCustomID", "Page_Live"."PinterestImageCustomID", "Page_Live"."HeaderImageID", "Page_Live"."CustomCanonicalSiteID", CASE WHEN "CookiePolicyPage_Localised_fr_FR"."ID" IS NOT NULL THEN "CookiePolicyPage_Localised_fr_FR"."FooterContent" ELSE "CookiePolicyPage_Live"."FooterContent" END AS "FooterContent", "SiteTree_Live"."ID", CASE WHEN "SiteTree_Live"."ClassName" IS NOT NULL THEN "SiteTree_Live"."ClassName" ELSE 'SilverStripe\\CMS\\Model\\SiteTree' END AS "RecordClassName", 'fr_FR' AS "Locale", CASE WHEN "CookiePolicyPage_Localised_fr_FR"."ID" IS NOT NULL THEN 'fr_FR' ELSE NULL END AS "SourceLocale" FROM "SiteTree_Live" LEFT JOIN "Page_Live" ON "Page_Live"."ID" = "SiteTree_Live"."ID" LEFT JOIN "CookiePolicyPage_Live" ON "CookiePolicyPage_Live"."ID" = "SiteTree_Live"."ID" LEFT JOIN "SiteTree_Localised_Live" AS "SiteTree_Localised_fr_FR" ON "SiteTree_Live"."ID" = "SiteTree_Localised_fr_FR"."RecordID" AND "SiteTree_Localised_fr_FR"."Locale" = ? LEFT JOIN "Page_Localised_Live" AS "Page_Localised_fr_FR" ON "Page_Live"."ID" = "Page_Localised_fr_FR"."RecordID" AND "Page_Localised_fr_FR"."Locale" = ? LEFT JOIN "CookiePolicyPage_Localised_Live" AS "CookiePolicyPage_Localised_fr_FR" ON "CookiePolicyPage_Live"."ID" = "CookiePolicyPage_Localised_fr_FR"."RecordID" AND "CookiePolicyPage_Localised_fr_FR"."Locale" = ? WHERE ("SiteTree_Live"."ClassName" IN (?)) AND (("SiteTree_Localised_fr_FR"."ID" IS NOT NULL)) ORDER BY "SiteTree_Live"."Sort" ASC LIMIT 1 0.0009s

0029: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", "SiteTree_Live"."CanViewType", "SiteTree_Live"."CanEditType", "SiteTree_Live"."Version", CASE WHEN "SiteTree_Localised_fr_FR"."ID" IS NOT NULL THEN "SiteTree_Localised_fr_FR"."URLSegment" ELSE "SiteTree_Live"."URLSegment" END AS "URLSegment", CASE WHEN "SiteTree_Localised_fr_FR"."ID" IS NOT NULL THEN "SiteTree_Localised_fr_FR"."Title" ELSE "SiteTree_Live"."Title" END AS "Title", CASE WHEN "SiteTree_Localised_fr_FR"."ID" IS NOT NULL THEN "SiteTree_Localised_fr_FR"."MenuTitle" ELSE "SiteTree_Live"."MenuTitle" END AS "MenuTitle", CASE WHEN "SiteTree_Localised_fr_FR"."ID" IS NOT NULL THEN "SiteTree_Localised_fr_FR"."Content" ELSE "SiteTree_Live"."Content" END AS "Content", CASE WHEN "SiteTree_Localised_fr_FR"."ID" IS NOT NULL THEN "SiteTree_Localised_fr_FR"."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_fr_FR"."ID" IS NOT NULL THEN "SiteTree_Localised_fr_FR"."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", 'fr_FR' AS "Locale", CASE WHEN "SiteTree_Localised_fr_FR"."ID" IS NOT NULL THEN 'fr_FR' ELSE NULL END AS "SourceLocale" FROM "SiteTree_Live" LEFT JOIN "SiteTree_Localised_Live" AS "SiteTree_Localised_fr_FR" ON "SiteTree_Live"."ID" = "SiteTree_Localised_fr_FR"."RecordID" AND "SiteTree_Localised_fr_FR"."Locale" = ? WHERE ("SiteTree_Live"."ID" = ?) AND (("SiteTree_Localised_fr_FR"."ID" IS NOT NULL)) ORDER BY "SiteTree_Live"."Sort" ASC LIMIT 1 0.0002s

0030: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", "SiteTree_Live"."CanViewType", "SiteTree_Live"."CanEditType", "SiteTree_Live"."Version", CASE WHEN "SiteTree_Localised_fr_FR"."ID" IS NOT NULL THEN "SiteTree_Localised_fr_FR"."URLSegment" ELSE "SiteTree_Live"."URLSegment" END AS "URLSegment", CASE WHEN "SiteTree_Localised_fr_FR"."ID" IS NOT NULL THEN "SiteTree_Localised_fr_FR"."Title" ELSE "SiteTree_Live"."Title" END AS "Title", CASE WHEN "SiteTree_Localised_fr_FR"."ID" IS NOT NULL THEN "SiteTree_Localised_fr_FR"."MenuTitle" ELSE "SiteTree_Live"."MenuTitle" END AS "MenuTitle", CASE WHEN "SiteTree_Localised_fr_FR"."ID" IS NOT NULL THEN "SiteTree_Localised_fr_FR"."Content" ELSE "SiteTree_Live"."Content" END AS "Content", CASE WHEN "SiteTree_Localised_fr_FR"."ID" IS NOT NULL THEN "SiteTree_Localised_fr_FR"."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_fr_FR"."ID" IS NOT NULL THEN "SiteTree_Localised_fr_FR"."ReportClass" ELSE "SiteTree_Live"."ReportClass" END AS "ReportClass", "SiteTree_Live"."ParentID", "Page_Live"."ShowContactPerson", CASE WHEN "Page_Localised_fr_FR"."ID" IS NOT NULL THEN "Page_Localised_fr_FR"."OGTitleCustom" ELSE "Page_Live"."OGTitleCustom" END AS "OGTitleCustom", CASE WHEN "Page_Localised_fr_FR"."ID" IS NOT NULL THEN "Page_Localised_fr_FR"."OGDescriptionCustom" ELSE "Page_Live"."OGDescriptionCustom" END AS "OGDescriptionCustom", CASE WHEN "Page_Localised_fr_FR"."ID" IS NOT NULL THEN "Page_Localised_fr_FR"."SubTitle" ELSE "Page_Live"."SubTitle" END AS "SubTitle", "Page_Live"."ShowInFooterMenu", "Page_Live"."ShowInTopBar", CASE WHEN "Page_Localised_fr_FR"."ID" IS NOT NULL THEN "Page_Localised_fr_FR"."MetaTitle" ELSE "Page_Live"."MetaTitle" END AS "MetaTitle", "Page_Live"."ShowPageHeaderTitle", "Page_Live"."ShowQuickApply", "Page_Live"."ShowInNaviEingeklappt", CASE WHEN "Page_Localised_fr_FR"."ID" IS NOT NULL THEN "Page_Localised_fr_FR"."RelatedPagesHeadline" ELSE "Page_Live"."RelatedPagesHeadline" END AS "RelatedPagesHeadline", "Page_Live"."ShowSolidNavigation", "Page_Live"."ContactTeamMemberID", "Page_Live"."OGImageCustomID", "Page_Live"."PinterestImageCustomID", "Page_Live"."HeaderImageID", "Page_Live"."CustomCanonicalSiteID", CASE WHEN "RequestedProductListPage_Localised_fr_FR"."ID" IS NOT NULL THEN "RequestedProductListPage_Localised_fr_FR"."RequestAnswer" ELSE "RequestedProductListPage_Live"."RequestAnswer" END AS "RequestAnswer", "SiteTree_Live"."ID", CASE WHEN "SiteTree_Live"."ClassName" IS NOT NULL THEN "SiteTree_Live"."ClassName" ELSE 'SilverStripe\\CMS\\Model\\SiteTree' END AS "RecordClassName", 'fr_FR' AS "Locale", CASE WHEN "RequestedProductListPage_Localised_fr_FR"."ID" IS NOT NULL THEN 'fr_FR' ELSE NULL END AS "SourceLocale" FROM "SiteTree_Live" LEFT JOIN "Page_Live" ON "Page_Live"."ID" = "SiteTree_Live"."ID" LEFT JOIN "RequestedProductListPage_Live" ON "RequestedProductListPage_Live"."ID" = "SiteTree_Live"."ID" LEFT JOIN "SiteTree_Localised_Live" AS "SiteTree_Localised_fr_FR" ON "SiteTree_Live"."ID" = "SiteTree_Localised_fr_FR"."RecordID" AND "SiteTree_Localised_fr_FR"."Locale" = ? LEFT JOIN "Page_Localised_Live" AS "Page_Localised_fr_FR" ON "Page_Live"."ID" = "Page_Localised_fr_FR"."RecordID" AND "Page_Localised_fr_FR"."Locale" = ? LEFT JOIN "RequestedProductListPage_Localised_Live" AS "RequestedProductListPage_Localised_fr_FR" ON "RequestedProductListPage_Live"."ID" = "RequestedProductListPage_Localised_fr_FR"."RecordID" AND "RequestedProductListPage_Localised_fr_FR"."Locale" = ? WHERE ("SiteTree_Live"."ClassName" IN (?)) AND (("SiteTree_Localised_fr_FR"."ID" IS NOT NULL)) ORDER BY "SiteTree_Live"."Sort" ASC LIMIT 1 0.0008s

0031: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", "SiteTree_Live"."CanViewType", "SiteTree_Live"."CanEditType", "SiteTree_Live"."Version", CASE WHEN "SiteTree_Localised_fr_FR"."ID" IS NOT NULL THEN "SiteTree_Localised_fr_FR"."URLSegment" ELSE "SiteTree_Live"."URLSegment" END AS "URLSegment", CASE WHEN "SiteTree_Localised_fr_FR"."ID" IS NOT NULL THEN "SiteTree_Localised_fr_FR"."Title" ELSE "SiteTree_Live"."Title" END AS "Title", CASE WHEN "SiteTree_Localised_fr_FR"."ID" IS NOT NULL THEN "SiteTree_Localised_fr_FR"."MenuTitle" ELSE "SiteTree_Live"."MenuTitle" END AS "MenuTitle", CASE WHEN "SiteTree_Localised_fr_FR"."ID" IS NOT NULL THEN "SiteTree_Localised_fr_FR"."Content" ELSE "SiteTree_Live"."Content" END AS "Content", CASE WHEN "SiteTree_Localised_fr_FR"."ID" IS NOT NULL THEN "SiteTree_Localised_fr_FR"."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_fr_FR"."ID" IS NOT NULL THEN "SiteTree_Localised_fr_FR"."ReportClass" ELSE "SiteTree_Live"."ReportClass" END AS "ReportClass", "SiteTree_Live"."ParentID", "Page_Live"."ShowContactPerson", CASE WHEN "Page_Localised_fr_FR"."ID" IS NOT NULL THEN "Page_Localised_fr_FR"."OGTitleCustom" ELSE "Page_Live"."OGTitleCustom" END AS "OGTitleCustom", CASE WHEN "Page_Localised_fr_FR"."ID" IS NOT NULL THEN "Page_Localised_fr_FR"."OGDescriptionCustom" ELSE "Page_Live"."OGDescriptionCustom" END AS "OGDescriptionCustom", CASE WHEN "Page_Localised_fr_FR"."ID" IS NOT NULL THEN "Page_Localised_fr_FR"."SubTitle" ELSE "Page_Live"."SubTitle" END AS "SubTitle", "Page_Live"."ShowInFooterMenu", "Page_Live"."ShowInTopBar", CASE WHEN "Page_Localised_fr_FR"."ID" IS NOT NULL THEN "Page_Localised_fr_FR"."MetaTitle" ELSE "Page_Live"."MetaTitle" END AS "MetaTitle", "Page_Live"."ShowPageHeaderTitle", "Page_Live"."ShowQuickApply", "Page_Live"."ShowInNaviEingeklappt", CASE WHEN "Page_Localised_fr_FR"."ID" IS NOT NULL THEN "Page_Localised_fr_FR"."RelatedPagesHeadline" ELSE "Page_Live"."RelatedPagesHeadline" END AS "RelatedPagesHeadline", "Page_Live"."ShowSolidNavigation", "Page_Live"."ContactTeamMemberID", "Page_Live"."OGImageCustomID", "Page_Live"."PinterestImageCustomID", "Page_Live"."HeaderImageID", "Page_Live"."CustomCanonicalSiteID", CASE WHEN "SilverShop_CartPage_Localised_fr_FR"."ID" IS NOT NULL THEN "SilverShop_CartPage_Localised_fr_FR"."ButtonCaption" ELSE "SilverShop_CartPage_Live"."ButtonCaption" END AS "ButtonCaption", "SilverShop_CartPage_Live"."LinkedPageID", "SilverShop_CartPage_Live"."CheckoutPageID", "SilverShop_CartPage_Live"."ContinuePageID", "SiteTree_Live"."ID", CASE WHEN "SiteTree_Live"."ClassName" IS NOT NULL THEN "SiteTree_Live"."ClassName" ELSE 'SilverStripe\\CMS\\Model\\SiteTree' END AS "RecordClassName", 'fr_FR' AS "Locale", CASE WHEN "SilverShop_CartPage_Localised_fr_FR"."ID" IS NOT NULL THEN 'fr_FR' ELSE NULL END AS "SourceLocale" FROM "SiteTree_Live" LEFT JOIN "Page_Live" ON "Page_Live"."ID" = "SiteTree_Live"."ID" LEFT JOIN "SilverShop_CartPage_Live" ON "SilverShop_CartPage_Live"."ID" = "SiteTree_Live"."ID" LEFT JOIN "SiteTree_Localised_Live" AS "SiteTree_Localised_fr_FR" ON "SiteTree_Live"."ID" = "SiteTree_Localised_fr_FR"."RecordID" AND "SiteTree_Localised_fr_FR"."Locale" = ? LEFT JOIN "Page_Localised_Live" AS "Page_Localised_fr_FR" ON "Page_Live"."ID" = "Page_Localised_fr_FR"."RecordID" AND "Page_Localised_fr_FR"."Locale" = ? LEFT JOIN "SilverShop_CartPage_Localised_Live" AS "SilverShop_CartPage_Localised_fr_FR" ON "SilverShop_CartPage_Live"."ID" = "SilverShop_CartPage_Localised_fr_FR"."RecordID" AND "SilverShop_CartPage_Localised_fr_FR"."Locale" = ? WHERE ("SiteTree_Live"."ClassName" IN (?)) AND (("SiteTree_Localised_fr_FR"."ID" IS NOT NULL)) ORDER BY "SiteTree_Live"."Sort" ASC LIMIT 1 0.0009s

0032: SELECT CASE WHEN EXISTS(SELECT * FROM "Member" INNER JOIN "BlogPost_Authors" ON "BlogPost_Authors"."MemberID" = "Member"."ID" WHERE ("BlogPost_Authors"."BlogPostID" = ?)) THEN 1 ELSE 0 END 0.0004s

0033: SELECT CASE WHEN EXISTS(SELECT * FROM "BlogCategory" INNER JOIN "BlogPost_Categories" ON "BlogPost_Categories"."BlogCategoryID" = "BlogCategory"."ID" LEFT JOIN "BlogCategory_Localised" AS "BlogCategory_Localised_fr_FR" ON "BlogCategory"."ID" = "BlogCategory_Localised_fr_FR"."RecordID" AND "BlogCategory_Localised_fr_FR"."Locale" = ? WHERE ("BlogPost_Categories"."BlogPostID" = ?) AND (("BlogCategory_Localised_fr_FR"."ID" IS NOT NULL))) THEN 1 ELSE 0 END 0.0005s

0034: SELECT DISTINCT "BlogCategory"."ClassName", "BlogCategory"."LastEdited", "BlogCategory"."Created", CASE WHEN "BlogCategory_Localised_fr_FR"."ID" IS NOT NULL THEN "BlogCategory_Localised_fr_FR"."Title" ELSE "BlogCategory"."Title" END AS "Title", CASE WHEN "BlogCategory_Localised_fr_FR"."ID" IS NOT NULL THEN "BlogCategory_Localised_fr_FR"."URLSegment" ELSE "BlogCategory"."URLSegment" END AS "URLSegment", "BlogCategory"."BlogID", "BlogCategory"."ID", CASE WHEN "BlogCategory"."ClassName" IS NOT NULL THEN "BlogCategory"."ClassName" ELSE 'SilverStripe\\Blog\\Model\\BlogCategory' END AS "RecordClassName", 'fr_FR' AS "Locale", CASE WHEN "BlogCategory_Localised_fr_FR"."ID" IS NOT NULL THEN 'fr_FR' ELSE NULL END AS "SourceLocale" FROM "BlogCategory" INNER JOIN "BlogPost_Categories" ON "BlogPost_Categories"."BlogCategoryID" = "BlogCategory"."ID" LEFT JOIN "BlogCategory_Localised" AS "BlogCategory_Localised_fr_FR" ON "BlogCategory"."ID" = "BlogCategory_Localised_fr_FR"."RecordID" AND "BlogCategory_Localised_fr_FR"."Locale" = ? WHERE ("BlogPost_Categories"."BlogPostID" = ?) AND (("BlogCategory_Localised_fr_FR"."ID" IS NOT NULL)) 0.0004s

0035: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", "SiteTree_Live"."CanViewType", "SiteTree_Live"."CanEditType", "SiteTree_Live"."Version", CASE WHEN "SiteTree_Localised_fr_FR"."ID" IS NOT NULL THEN "SiteTree_Localised_fr_FR"."URLSegment" ELSE "SiteTree_Live"."URLSegment" END AS "URLSegment", CASE WHEN "SiteTree_Localised_fr_FR"."ID" IS NOT NULL THEN "SiteTree_Localised_fr_FR"."Title" ELSE "SiteTree_Live"."Title" END AS "Title", CASE WHEN "SiteTree_Localised_fr_FR"."ID" IS NOT NULL THEN "SiteTree_Localised_fr_FR"."MenuTitle" ELSE "SiteTree_Live"."MenuTitle" END AS "MenuTitle", CASE WHEN "SiteTree_Localised_fr_FR"."ID" IS NOT NULL THEN "SiteTree_Localised_fr_FR"."Content" ELSE "SiteTree_Live"."Content" END AS "Content", CASE WHEN "SiteTree_Localised_fr_FR"."ID" IS NOT NULL THEN "SiteTree_Localised_fr_FR"."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_fr_FR"."ID" IS NOT NULL THEN "SiteTree_Localised_fr_FR"."ReportClass" ELSE "SiteTree_Live"."ReportClass" END AS "ReportClass", "SiteTree_Live"."ParentID", "Page_Live"."ShowContactPerson", CASE WHEN "Page_Localised_fr_FR"."ID" IS NOT NULL THEN "Page_Localised_fr_FR"."OGTitleCustom" ELSE "Page_Live"."OGTitleCustom" END AS "OGTitleCustom", CASE WHEN "Page_Localised_fr_FR"."ID" IS NOT NULL THEN "Page_Localised_fr_FR"."OGDescriptionCustom" ELSE "Page_Live"."OGDescriptionCustom" END AS "OGDescriptionCustom", CASE WHEN "Page_Localised_fr_FR"."ID" IS NOT NULL THEN "Page_Localised_fr_FR"."SubTitle" ELSE "Page_Live"."SubTitle" END AS "SubTitle", "Page_Live"."ShowInFooterMenu", "Page_Live"."ShowInTopBar", CASE WHEN "Page_Localised_fr_FR"."ID" IS NOT NULL THEN "Page_Localised_fr_FR"."MetaTitle" ELSE "Page_Live"."MetaTitle" END AS "MetaTitle", "Page_Live"."ShowPageHeaderTitle", "Page_Live"."ShowQuickApply", "Page_Live"."ShowInNaviEingeklappt", CASE WHEN "Page_Localised_fr_FR"."ID" IS NOT NULL THEN "Page_Localised_fr_FR"."RelatedPagesHeadline" ELSE "Page_Live"."RelatedPagesHeadline" END AS "RelatedPagesHeadline", "Page_Live"."ShowSolidNavigation", "Page_Live"."ContactTeamMemberID", "Page_Live"."OGImageCustomID", "Page_Live"."PinterestImageCustomID", "Page_Live"."HeaderImageID", "Page_Live"."CustomCanonicalSiteID", "Blog_Live"."PostsPerPage", "SiteTree_Live"."ID", CASE WHEN "SiteTree_Live"."ClassName" IS NOT NULL THEN "SiteTree_Live"."ClassName" ELSE 'SilverStripe\\CMS\\Model\\SiteTree' END AS "RecordClassName", 'fr_FR' AS "Locale", CASE WHEN "Page_Localised_fr_FR"."ID" IS NOT NULL THEN 'fr_FR' ELSE NULL END AS "SourceLocale" FROM "SiteTree_Live" LEFT JOIN "Page_Live" ON "Page_Live"."ID" = "SiteTree_Live"."ID" LEFT JOIN "Blog_Live" ON "Blog_Live"."ID" = "SiteTree_Live"."ID" LEFT JOIN "SiteTree_Localised_Live" AS "SiteTree_Localised_fr_FR" ON "SiteTree_Live"."ID" = "SiteTree_Localised_fr_FR"."RecordID" AND "SiteTree_Localised_fr_FR"."Locale" = ? LEFT JOIN "Page_Localised_Live" AS "Page_Localised_fr_FR" ON "Page_Live"."ID" = "Page_Localised_fr_FR"."RecordID" AND "Page_Localised_fr_FR"."Locale" = ? WHERE ("SiteTree_Live"."ID" = ?) AND ("SiteTree_Live"."ClassName" IN (?)) AND (("SiteTree_Localised_fr_FR"."ID" IS NOT NULL)) ORDER BY "SiteTree_Live"."Sort" ASC LIMIT 1 0.0006s

0036: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", "SiteTree_Live"."CanViewType", "SiteTree_Live"."CanEditType", "SiteTree_Live"."Version", CASE WHEN "SiteTree_Localised_fr_FR"."ID" IS NOT NULL THEN "SiteTree_Localised_fr_FR"."URLSegment" ELSE "SiteTree_Live"."URLSegment" END AS "URLSegment", CASE WHEN "SiteTree_Localised_fr_FR"."ID" IS NOT NULL THEN "SiteTree_Localised_fr_FR"."Title" ELSE "SiteTree_Live"."Title" END AS "Title", CASE WHEN "SiteTree_Localised_fr_FR"."ID" IS NOT NULL THEN "SiteTree_Localised_fr_FR"."MenuTitle" ELSE "SiteTree_Live"."MenuTitle" END AS "MenuTitle", CASE WHEN "SiteTree_Localised_fr_FR"."ID" IS NOT NULL THEN "SiteTree_Localised_fr_FR"."Content" ELSE "SiteTree_Live"."Content" END AS "Content", CASE WHEN "SiteTree_Localised_fr_FR"."ID" IS NOT NULL THEN "SiteTree_Localised_fr_FR"."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_fr_FR"."ID" IS NOT NULL THEN "SiteTree_Localised_fr_FR"."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", 'fr_FR' AS "Locale", CASE WHEN "SiteTree_Localised_fr_FR"."ID" IS NOT NULL THEN 'fr_FR' ELSE NULL END AS "SourceLocale" FROM "SiteTree_Live" LEFT JOIN "SiteTree_Localised_Live" AS "SiteTree_Localised_fr_FR" ON "SiteTree_Live"."ID" = "SiteTree_Localised_fr_FR"."RecordID" AND "SiteTree_Localised_fr_FR"."Locale" = ? WHERE ("SiteTree_Live"."ID" = ?) AND (("SiteTree_Localised_fr_FR"."ID" IS NOT NULL)) ORDER BY "SiteTree_Live"."Sort" ASC LIMIT 1 0.0002s

0037: SELECT DISTINCT count(DISTINCT "SiteTree_Live"."ID") AS "Count" FROM "SiteTree_Live" INNER JOIN "Page_RelatedPages" ON "Page_RelatedPages"."SiteTreeID" = "SiteTree_Live"."ID" LEFT JOIN "SiteTree_Localised_Live" AS "SiteTree_Localised_fr_FR" ON "SiteTree_Live"."ID" = "SiteTree_Localised_fr_FR"."RecordID" AND "SiteTree_Localised_fr_FR"."Locale" = ? WHERE ("Page_RelatedPages"."PageID" = ?) AND (("SiteTree_Localised_fr_FR"."ID" IS NOT NULL)) 0.0004s

0038: SELECT "Version" FROM "SiteTree" WHERE "ID" = ? 0.0004s

0039: SELECT "BaseTable"."RecordID" as "LatestID", MAX("SiteTree_Localised_Versions"."Version") as "LatestVersion" FROM "SiteTree_Localised" AS "BaseTable" INNER JOIN "SiteTree_Localised_Versions" ON "BaseTable"."RecordID" = "SiteTree_Localised_Versions"."RecordID" AND "SiteTree_Localised_Versions"."Locale" = ? INNER JOIN "SiteTree_Versions" ON "SiteTree_Versions"."RecordID" = "SiteTree_Localised_Versions"."RecordID" AND "SiteTree_Versions"."Version" = "SiteTree_Localised_Versions"."Version" WHERE "BaseTable"."Locale" = ? AND "BaseTable"."RecordID" IN (?) GROUP BY "LatestID" 0.0006s

0040: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", "SiteTree_Live"."CanViewType", "SiteTree_Live"."CanEditType", "SiteTree_Live"."Version", CASE WHEN "SiteTree_Localised_fr_FR"."ID" IS NOT NULL THEN "SiteTree_Localised_fr_FR"."URLSegment" ELSE "SiteTree_Live"."URLSegment" END AS "URLSegment", CASE WHEN "SiteTree_Localised_fr_FR"."ID" IS NOT NULL THEN "SiteTree_Localised_fr_FR"."Title" ELSE "SiteTree_Live"."Title" END AS "Title", CASE WHEN "SiteTree_Localised_fr_FR"."ID" IS NOT NULL THEN "SiteTree_Localised_fr_FR"."MenuTitle" ELSE "SiteTree_Live"."MenuTitle" END AS "MenuTitle", CASE WHEN "SiteTree_Localised_fr_FR"."ID" IS NOT NULL THEN "SiteTree_Localised_fr_FR"."Content" ELSE "SiteTree_Live"."Content" END AS "Content", CASE WHEN "SiteTree_Localised_fr_FR"."ID" IS NOT NULL THEN "SiteTree_Localised_fr_FR"."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_fr_FR"."ID" IS NOT NULL THEN "SiteTree_Localised_fr_FR"."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", 'fr_FR' AS "Locale", CASE WHEN "SiteTree_Localised_fr_FR"."ID" IS NOT NULL THEN 'fr_FR' ELSE NULL END AS "SourceLocale" FROM "SiteTree_Live" LEFT JOIN "SiteTree_Localised_Live" AS "SiteTree_Localised_fr_FR" ON "SiteTree_Live"."ID" = "SiteTree_Localised_fr_FR"."RecordID" AND "SiteTree_Localised_fr_FR"."Locale" = ? WHERE ("SiteTree_Live"."ID" = ?) AND (("SiteTree_Localised_fr_FR"."ID" IS NOT NULL)) ORDER BY "SiteTree_Live"."Sort" ASC LIMIT 1 0.0003s

0041: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", "SiteTree_Live"."CanViewType", "SiteTree_Live"."CanEditType", "SiteTree_Live"."Version", CASE WHEN "SiteTree_Localised_fr_FR"."ID" IS NOT NULL THEN "SiteTree_Localised_fr_FR"."URLSegment" ELSE "SiteTree_Live"."URLSegment" END AS "URLSegment", CASE WHEN "SiteTree_Localised_fr_FR"."ID" IS NOT NULL THEN "SiteTree_Localised_fr_FR"."Title" ELSE "SiteTree_Live"."Title" END AS "Title", CASE WHEN "SiteTree_Localised_fr_FR"."ID" IS NOT NULL THEN "SiteTree_Localised_fr_FR"."MenuTitle" ELSE "SiteTree_Live"."MenuTitle" END AS "MenuTitle", CASE WHEN "SiteTree_Localised_fr_FR"."ID" IS NOT NULL THEN "SiteTree_Localised_fr_FR"."Content" ELSE "SiteTree_Live"."Content" END AS "Content", CASE WHEN "SiteTree_Localised_fr_FR"."ID" IS NOT NULL THEN "SiteTree_Localised_fr_FR"."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_fr_FR"."ID" IS NOT NULL THEN "SiteTree_Localised_fr_FR"."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", 'fr_FR' AS "Locale", CASE WHEN "SiteTree_Localised_fr_FR"."ID" IS NOT NULL THEN 'fr_FR' ELSE NULL END AS "SourceLocale" FROM "SiteTree_Live" LEFT JOIN "SiteTree_Localised_Live" AS "SiteTree_Localised_fr_FR" ON "SiteTree_Live"."ID" = "SiteTree_Localised_fr_FR"."RecordID" AND "SiteTree_Localised_fr_FR"."Locale" = ? WHERE ("SiteTree_Live"."ID" = ?) AND (("SiteTree_Localised_fr_FR"."ID" IS NOT NULL)) ORDER BY "SiteTree_Live"."Sort" ASC LIMIT 1 0.0002s

0042: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", "SiteTree_Live"."CanViewType", "SiteTree_Live"."CanEditType", "SiteTree_Live"."Version", CASE WHEN "SiteTree_Localised_fr_FR"."ID" IS NOT NULL THEN "SiteTree_Localised_fr_FR"."URLSegment" ELSE "SiteTree_Live"."URLSegment" END AS "URLSegment", CASE WHEN "SiteTree_Localised_fr_FR"."ID" IS NOT NULL THEN "SiteTree_Localised_fr_FR"."Title" ELSE "SiteTree_Live"."Title" END AS "Title", CASE WHEN "SiteTree_Localised_fr_FR"."ID" IS NOT NULL THEN "SiteTree_Localised_fr_FR"."MenuTitle" ELSE "SiteTree_Live"."MenuTitle" END AS "MenuTitle", CASE WHEN "SiteTree_Localised_fr_FR"."ID" IS NOT NULL THEN "SiteTree_Localised_fr_FR"."Content" ELSE "SiteTree_Live"."Content" END AS "Content", CASE WHEN "SiteTree_Localised_fr_FR"."ID" IS NOT NULL THEN "SiteTree_Localised_fr_FR"."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_fr_FR"."ID" IS NOT NULL THEN "SiteTree_Localised_fr_FR"."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", 'fr_FR' AS "Locale", CASE WHEN "SiteTree_Localised_fr_FR"."ID" IS NOT NULL THEN 'fr_FR' ELSE NULL END AS "SourceLocale" FROM "SiteTree_Live" LEFT JOIN "SiteTree_Localised_Live" AS "SiteTree_Localised_fr_FR" ON "SiteTree_Live"."ID" = "SiteTree_Localised_fr_FR"."RecordID" AND "SiteTree_Localised_fr_FR"."Locale" = ? WHERE ("SiteTree_Live"."ID" = ?) AND (("SiteTree_Localised_fr_FR"."ID" IS NOT NULL)) ORDER BY "SiteTree_Live"."Sort" ASC LIMIT 1 0.0002s

0043: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", "SiteTree_Live"."CanViewType", "SiteTree_Live"."CanEditType", "SiteTree_Live"."Version", CASE WHEN "SiteTree_Localised_fr_FR"."ID" IS NOT NULL THEN "SiteTree_Localised_fr_FR"."URLSegment" ELSE "SiteTree_Live"."URLSegment" END AS "URLSegment", CASE WHEN "SiteTree_Localised_fr_FR"."ID" IS NOT NULL THEN "SiteTree_Localised_fr_FR"."Title" ELSE "SiteTree_Live"."Title" END AS "Title", CASE WHEN "SiteTree_Localised_fr_FR"."ID" IS NOT NULL THEN "SiteTree_Localised_fr_FR"."MenuTitle" ELSE "SiteTree_Live"."MenuTitle" END AS "MenuTitle", CASE WHEN "SiteTree_Localised_fr_FR"."ID" IS NOT NULL THEN "SiteTree_Localised_fr_FR"."Content" ELSE "SiteTree_Live"."Content" END AS "Content", CASE WHEN "SiteTree_Localised_fr_FR"."ID" IS NOT NULL THEN "SiteTree_Localised_fr_FR"."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_fr_FR"."ID" IS NOT NULL THEN "SiteTree_Localised_fr_FR"."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", 'fr_FR' AS "Locale", CASE WHEN "SiteTree_Localised_fr_FR"."ID" IS NOT NULL THEN 'fr_FR' ELSE NULL END AS "SourceLocale" FROM "SiteTree_Live" LEFT JOIN "SiteTree_Localised_Live" AS "SiteTree_Localised_fr_FR" ON "SiteTree_Live"."ID" = "SiteTree_Localised_fr_FR"."RecordID" AND "SiteTree_Localised_fr_FR"."Locale" = ? WHERE ("SiteTree_Live"."ID" = ?) AND (("SiteTree_Localised_fr_FR"."ID" IS NOT NULL)) ORDER BY "SiteTree_Live"."Sort" ASC LIMIT 1 0.0002s

0044: SELECT DISTINCT "SiteTree"."ClassName", "SiteTree"."LastEdited", "SiteTree"."Created", "SiteTree"."Priority", "SiteTree"."CanViewType", "SiteTree"."CanEditType", "SiteTree"."Version", CASE WHEN "SiteTree_Localised_fr_FR"."ID" IS NOT NULL THEN "SiteTree_Localised_fr_FR"."URLSegment" ELSE "SiteTree"."URLSegment" END AS "URLSegment", CASE WHEN "SiteTree_Localised_fr_FR"."ID" IS NOT NULL THEN "SiteTree_Localised_fr_FR"."Title" ELSE "SiteTree"."Title" END AS "Title", CASE WHEN "SiteTree_Localised_fr_FR"."ID" IS NOT NULL THEN "SiteTree_Localised_fr_FR"."MenuTitle" ELSE "SiteTree"."MenuTitle" END AS "MenuTitle", CASE WHEN "SiteTree_Localised_fr_FR"."ID" IS NOT NULL THEN "SiteTree_Localised_fr_FR"."Content" ELSE "SiteTree"."Content" END AS "Content", CASE WHEN "SiteTree_Localised_fr_FR"."ID" IS NOT NULL THEN "SiteTree_Localised_fr_FR"."MetaDescription" ELSE "SiteTree"."MetaDescription" END AS "MetaDescription", "SiteTree"."ExtraMeta", "SiteTree"."ShowInMenus", "SiteTree"."ShowInSearch", "SiteTree"."Sort", "SiteTree"."HasBrokenFile", "SiteTree"."HasBrokenLink", CASE WHEN "SiteTree_Localised_fr_FR"."ID" IS NOT NULL THEN "SiteTree_Localised_fr_FR"."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", 'fr_FR' AS "Locale", CASE WHEN "SiteTree_Localised_fr_FR"."ID" IS NOT NULL THEN 'fr_FR' ELSE NULL END AS "SourceLocale" FROM "SiteTree" LEFT JOIN "SiteTree_Localised" AS "SiteTree_Localised_fr_FR" ON "SiteTree"."ID" = "SiteTree_Localised_fr_FR"."RecordID" AND "SiteTree_Localised_fr_FR"."Locale" = ? WHERE ("SiteTree"."ID" = ?) AND (("SiteTree_Localised_fr_FR"."ID" IS NOT NULL)) ORDER BY "SiteTree"."Sort" ASC LIMIT 1 0.0004s

0045: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", "SiteTree_Live"."CanViewType", "SiteTree_Live"."CanEditType", "SiteTree_Live"."Version", CASE WHEN "SiteTree_Localised_fr_FR"."ID" IS NOT NULL THEN "SiteTree_Localised_fr_FR"."URLSegment" ELSE "SiteTree_Live"."URLSegment" END AS "URLSegment", CASE WHEN "SiteTree_Localised_fr_FR"."ID" IS NOT NULL THEN "SiteTree_Localised_fr_FR"."Title" ELSE "SiteTree_Live"."Title" END AS "Title", CASE WHEN "SiteTree_Localised_fr_FR"."ID" IS NOT NULL THEN "SiteTree_Localised_fr_FR"."MenuTitle" ELSE "SiteTree_Live"."MenuTitle" END AS "MenuTitle", CASE WHEN "SiteTree_Localised_fr_FR"."ID" IS NOT NULL THEN "SiteTree_Localised_fr_FR"."Content" ELSE "SiteTree_Live"."Content" END AS "Content", CASE WHEN "SiteTree_Localised_fr_FR"."ID" IS NOT NULL THEN "SiteTree_Localised_fr_FR"."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_fr_FR"."ID" IS NOT NULL THEN "SiteTree_Localised_fr_FR"."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", 'fr_FR' AS "Locale", CASE WHEN "SiteTree_Localised_fr_FR"."ID" IS NOT NULL THEN 'fr_FR' ELSE NULL END AS "SourceLocale" FROM "SiteTree_Live" LEFT JOIN "SiteTree_Localised_Live" AS "SiteTree_Localised_fr_FR" ON "SiteTree_Live"."ID" = "SiteTree_Localised_fr_FR"."RecordID" AND "SiteTree_Localised_fr_FR"."Locale" = ? WHERE ("SiteTree_Live"."ID" = ?) AND (("SiteTree_Localised_fr_FR"."ID" IS NOT NULL)) ORDER BY "SiteTree_Live"."Sort" ASC LIMIT 1 0.0002s

0046: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", "SiteTree_Live"."CanViewType", "SiteTree_Live"."CanEditType", "SiteTree_Live"."Version", CASE WHEN "SiteTree_Localised_fr_FR"."ID" IS NOT NULL THEN "SiteTree_Localised_fr_FR"."URLSegment" ELSE "SiteTree_Live"."URLSegment" END AS "URLSegment", CASE WHEN "SiteTree_Localised_fr_FR"."ID" IS NOT NULL THEN "SiteTree_Localised_fr_FR"."Title" ELSE "SiteTree_Live"."Title" END AS "Title", CASE WHEN "SiteTree_Localised_fr_FR"."ID" IS NOT NULL THEN "SiteTree_Localised_fr_FR"."MenuTitle" ELSE "SiteTree_Live"."MenuTitle" END AS "MenuTitle", CASE WHEN "SiteTree_Localised_fr_FR"."ID" IS NOT NULL THEN "SiteTree_Localised_fr_FR"."Content" ELSE "SiteTree_Live"."Content" END AS "Content", CASE WHEN "SiteTree_Localised_fr_FR"."ID" IS NOT NULL THEN "SiteTree_Localised_fr_FR"."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_fr_FR"."ID" IS NOT NULL THEN "SiteTree_Localised_fr_FR"."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", 'fr_FR' AS "Locale", CASE WHEN "SiteTree_Localised_fr_FR"."ID" IS NOT NULL THEN 'fr_FR' ELSE NULL END AS "SourceLocale" FROM "SiteTree_Live" LEFT JOIN "SiteTree_Localised_Live" AS "SiteTree_Localised_fr_FR" ON "SiteTree_Live"."ID" = "SiteTree_Localised_fr_FR"."RecordID" AND "SiteTree_Localised_fr_FR"."Locale" = ? WHERE ("SiteTree_Live"."ID" = ?) AND (("SiteTree_Localised_fr_FR"."ID" IS NOT NULL)) ORDER BY "SiteTree_Live"."Sort" ASC LIMIT 1 0.0002s

0047: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", "SiteTree_Live"."CanViewType", "SiteTree_Live"."CanEditType", "SiteTree_Live"."Version", CASE WHEN "SiteTree_Localised_fr_FR"."ID" IS NOT NULL THEN "SiteTree_Localised_fr_FR"."URLSegment" ELSE "SiteTree_Live"."URLSegment" END AS "URLSegment", CASE WHEN "SiteTree_Localised_fr_FR"."ID" IS NOT NULL THEN "SiteTree_Localised_fr_FR"."Title" ELSE "SiteTree_Live"."Title" END AS "Title", CASE WHEN "SiteTree_Localised_fr_FR"."ID" IS NOT NULL THEN "SiteTree_Localised_fr_FR"."MenuTitle" ELSE "SiteTree_Live"."MenuTitle" END AS "MenuTitle", CASE WHEN "SiteTree_Localised_fr_FR"."ID" IS NOT NULL THEN "SiteTree_Localised_fr_FR"."Content" ELSE "SiteTree_Live"."Content" END AS "Content", CASE WHEN "SiteTree_Localised_fr_FR"."ID" IS NOT NULL THEN "SiteTree_Localised_fr_FR"."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_fr_FR"."ID" IS NOT NULL THEN "SiteTree_Localised_fr_FR"."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", 'fr_FR' AS "Locale", CASE WHEN "SiteTree_Localised_fr_FR"."ID" IS NOT NULL THEN 'fr_FR' ELSE NULL END AS "SourceLocale" FROM "SiteTree_Live" LEFT JOIN "SiteTree_Localised_Live" AS "SiteTree_Localised_fr_FR" ON "SiteTree_Live"."ID" = "SiteTree_Localised_fr_FR"."RecordID" AND "SiteTree_Localised_fr_FR"."Locale" = ? WHERE ("SiteTree_Live"."ID" = ?) AND (("SiteTree_Localised_fr_FR"."ID" IS NOT NULL)) ORDER BY "SiteTree_Live"."Sort" ASC LIMIT 1 0.0001s

UHL est Top Company 2025 » UHL
News 17. janvier 2025

UHL est Top Company 2025

UHL fait partie des quelque 5% meilleurs employeurs de l'année. La particularité de cette distinction est qu'elle n'est pas décernée par un jury, mais qu'elle est obtenue exclusivement sur la base d'évaluations indépendantes sur notre profil d'entreprise kununu et reflète donc directement l'opinion de nos collaborateurs et de tous les candidats.

Un grand merci à notre fantastique équipe pour son engagement et sa collaboration sans faille !