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
Ce site utilise des cookies
Nous utilisons des cookies pour personnaliser le contenu, fournir des fonctionnalités pour les médias sociaux et analyser notre trafic. Nous partageons également des informations sur votre utilisation de notre site avec nos partenaires de médias sociaux et d'analyse, qui peuvent les combiner avec d'autres informations que vous leur avez fournies ou qu'ils ont collectées par votre utilisation de leurs services. Vous acceptez nos cookies si vous continuez à utiliser notre site web.
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 !