0003: SHOW DATABASES LIKE 'ss\_etias\_web\_production'
0.0009s
0004: SHOW FULL TABLES WHERE Table_Type != 'VIEW'
0.0102s
0005: SHOW FULL FIELDS IN "Fluent_Locale"
0.0035s
0006: SHOW COLLATION LIKE 'utf8mb3_general_ci'
0.0008s
0007: SELECT DISTINCT "Fluent_Locale"."DeepLTranslated", "Fluent_Locale"."OriginalID", "Fluent_Locale"."ClassName", "Fluent_Locale"."LastEdited", "Fluent_Locale"."Created", "Fluent_Locale"."Title", "Fluent_Locale"."Locale", "Fluent_Locale"."URLSegment", "Fluent_Locale"."IsGlobalDefault", "Fluent_Locale"."FlagID", "Fluent_Locale"."DomainID", "Fluent_Locale"."ID",
CASE WHEN "Fluent_Locale"."ClassName" IS NOT NULL THEN "Fluent_Locale"."ClassName"
ELSE 'TractorCow\\Fluent\\Model\\Locale' END AS "RecordClassName"
FROM "Fluent_Locale"
ORDER BY "Fluent_Locale"."Locale" ASC
0.0017s
0008: SHOW FULL FIELDS IN "Fluent_Domain"
0.0038s
0009: SELECT DISTINCT "Fluent_Domain"."DeepLTranslated", "Fluent_Domain"."OriginalID", "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.0013s
0010: SELECT DISTINCT "Fluent_FallbackLocale"."DeepLTranslated" AS "Fluent_FallbackLocale_DeepLTranslated", "Fluent_FallbackLocale"."OriginalID" AS "Fluent_FallbackLocale_OriginalID", "Fluent_FallbackLocale"."ClassName" AS "Fluent_FallbackLocale_ClassName", "Fluent_FallbackLocale"."LastEdited" AS "Fluent_FallbackLocale_LastEdited", "Fluent_FallbackLocale"."Created" AS "Fluent_FallbackLocale_Created", "Fluent_FallbackLocale"."Sort" AS "Fluent_FallbackLocale_Sort", "Fluent_FallbackLocale"."ParentID" AS "Fluent_FallbackLocale_ParentID", "Fluent_FallbackLocale"."LocaleID" AS "Fluent_FallbackLocale_LocaleID", "Fluent_FallbackLocale"."ID" AS "Fluent_FallbackLocale_ID", "Fluent_FallbackLocale"."RecordClassName" AS "Fluent_FallbackLocale_RecordClassName", "Fluent_Locale"."DeepLTranslated", "Fluent_Locale"."OriginalID", "Fluent_Locale"."ClassName", "Fluent_Locale"."LastEdited", "Fluent_Locale"."Created", "Fluent_Locale"."Title", "Fluent_Locale"."Locale", "Fluent_Locale"."URLSegment", "Fluent_Locale"."IsGlobalDefault", "Fluent_Locale"."FlagID", "Fluent_Locale"."DomainID", "Fluent_Locale"."ID",
CASE WHEN "Fluent_Locale"."ClassName" IS NOT NULL THEN "Fluent_Locale"."ClassName"
ELSE 'TractorCow\\Fluent\\Model\\Locale' END AS "RecordClassName"
FROM "Fluent_Locale" INNER JOIN (SELECT DISTINCT "Fluent_FallbackLocale"."DeepLTranslated", "Fluent_FallbackLocale"."OriginalID", "Fluent_FallbackLocale"."ClassName", "Fluent_FallbackLocale"."LastEdited", "Fluent_FallbackLocale"."Created", "Fluent_FallbackLocale"."Sort", "Fluent_FallbackLocale"."ParentID", "Fluent_FallbackLocale"."LocaleID", "Fluent_FallbackLocale"."ID",
CASE WHEN "Fluent_FallbackLocale"."ClassName" IS NOT NULL THEN "Fluent_FallbackLocale"."ClassName"
ELSE 'TractorCow\\Fluent\\Model\\FallbackLocale' END AS "RecordClassName"
FROM "Fluent_FallbackLocale"
WHERE ("Fluent_FallbackLocale"."ParentID" = ?)) AS "Fluent_FallbackLocale" ON "Fluent_FallbackLocale"."LocaleID" = "Fluent_Locale"."ID"
ORDER BY "Fluent_Locale"."Locale" ASC
0.0025s
0011: SELECT DISTINCT "SiteTree_Live"."DeepLTranslated", "SiteTree_Live"."OriginalID", "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", CASE
WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."SiteTreeLinkerHelper"
ELSE "SiteTree_Live"."SiteTreeLinkerHelper" END
AS "SiteTreeLinkerHelper", "SiteTree_Live"."CanViewType", "SiteTree_Live"."CanEditType", "SiteTree_Live"."Version", CASE
WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."URLSegment"
ELSE "SiteTree_Live"."URLSegment" END
AS "URLSegment", CASE
WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."Title"
ELSE "SiteTree_Live"."Title" END
AS "Title", CASE
WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."MenuTitle"
ELSE "SiteTree_Live"."MenuTitle" END
AS "MenuTitle", CASE
WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."Content"
ELSE "SiteTree_Live"."Content" END
AS "Content", CASE
WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."MetaDescription"
ELSE "SiteTree_Live"."MetaDescription" END
AS "MetaDescription", "SiteTree_Live"."ExtraMeta", "SiteTree_Live"."ShowInMenus", "SiteTree_Live"."ShowInSearch", "SiteTree_Live"."Sort", "SiteTree_Live"."HasBrokenFile", "SiteTree_Live"."HasBrokenLink", CASE
WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."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", 'en_US' AS "Locale", CASE WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN 'en_US'
ELSE NULL END AS "SourceLocale"
FROM "SiteTree_Live" LEFT JOIN "SiteTree_Localised_Live" AS "SiteTree_Localised_en_US" ON "SiteTree_Live"."ID" = "SiteTree_Localised_en_US"."RecordID" AND "SiteTree_Localised_en_US"."Locale" = ?
WHERE (COALESCE("SiteTree_Localised_en_US"."URLSegment", "SiteTree_Live"."URLSegment") = ?)
AND (("SiteTree_Localised_en_US"."ID" IS NOT NULL))
ORDER BY "SiteTree_Live"."Sort" ASC
LIMIT 1
0.0058s
0012: SELECT DISTINCT "SiteConfig"."DeepLTranslated", "SiteConfig"."OriginalID", "SiteConfig"."ClassName", "SiteConfig"."LastEdited", "SiteConfig"."Created", "SiteConfig"."AllowedCountries", "SiteConfig"."MapsAPIKey", "SiteConfig"."Address", "SiteConfig"."Longitude", "SiteConfig"."Latitude", CASE
WHEN "SiteConfig_Localised_en_US"."ID" IS NOT NULL THEN "SiteConfig_Localised_en_US"."FormularDatenschutztext"
ELSE "SiteConfig"."FormularDatenschutztext" END
AS "FormularDatenschutztext", "SiteConfig"."ExtraCSS", CASE
WHEN "SiteConfig_Localised_en_US"."ID" IS NOT NULL THEN "SiteConfig_Localised_en_US"."TrippleTitle"
ELSE "SiteConfig"."TrippleTitle" END
AS "TrippleTitle", CASE
WHEN "SiteConfig_Localised_en_US"."ID" IS NOT NULL THEN "SiteConfig_Localised_en_US"."TrippleContent"
ELSE "SiteConfig"."TrippleContent" END
AS "TrippleContent", CASE
WHEN "SiteConfig_Localised_en_US"."ID" IS NOT NULL THEN "SiteConfig_Localised_en_US"."TrippleAlternative"
ELSE "SiteConfig"."TrippleAlternative" END
AS "TrippleAlternative", CASE
WHEN "SiteConfig_Localised_en_US"."ID" IS NOT NULL THEN "SiteConfig_Localised_en_US"."ApplicationLink"
ELSE "SiteConfig"."ApplicationLink" END
AS "ApplicationLink", CASE
WHEN "SiteConfig_Localised_en_US"."ID" IS NOT NULL THEN "SiteConfig_Localised_en_US"."ApplicationCaption"
ELSE "SiteConfig"."ApplicationCaption" END
AS "ApplicationCaption", CASE
WHEN "SiteConfig_Localised_en_US"."ID" IS NOT NULL THEN "SiteConfig_Localised_en_US"."ServicesLink"
ELSE "SiteConfig"."ServicesLink" END
AS "ServicesLink", CASE
WHEN "SiteConfig_Localised_en_US"."ID" IS NOT NULL THEN "SiteConfig_Localised_en_US"."ServicesCaption"
ELSE "SiteConfig"."ServicesCaption" END
AS "ServicesCaption", CASE
WHEN "SiteConfig_Localised_en_US"."ID" IS NOT NULL THEN "SiteConfig_Localised_en_US"."CheckLink"
ELSE "SiteConfig"."CheckLink" END
AS "CheckLink", CASE
WHEN "SiteConfig_Localised_en_US"."ID" IS NOT NULL THEN "SiteConfig_Localised_en_US"."CheckCaption"
ELSE "SiteConfig"."CheckCaption" END
AS "CheckCaption", "SiteConfig"."Discount", "SiteConfig"."BgColor", "SiteConfig"."CTAExternalLink", CASE
WHEN "SiteConfig_Localised_en_US"."ID" IS NOT NULL THEN "SiteConfig_Localised_en_US"."Disclaimer"
ELSE "SiteConfig"."Disclaimer" END
AS "Disclaimer", CASE
WHEN "SiteConfig_Localised_en_US"."ID" IS NOT NULL THEN "SiteConfig_Localised_en_US"."CTALinkCustomDESC"
ELSE "SiteConfig"."CTALinkCustomDESC" END
AS "CTALinkCustomDESC", CASE
WHEN "SiteConfig_Localised_en_US"."ID" IS NOT NULL THEN "SiteConfig_Localised_en_US"."AnalyticsCode"
ELSE "SiteConfig"."AnalyticsCode" END
AS "AnalyticsCode", "SiteConfig"."PasswordResetIntro", CASE
WHEN "SiteConfig_Localised_en_US"."ID" IS NOT NULL THEN "SiteConfig_Localised_en_US"."HintPayment"
ELSE "SiteConfig"."HintPayment" END
AS "HintPayment", CASE
WHEN "SiteConfig_Localised_en_US"."ID" IS NOT NULL THEN "SiteConfig_Localised_en_US"."HintOrderPaid"
ELSE "SiteConfig"."HintOrderPaid" END
AS "HintOrderPaid", CASE
WHEN "SiteConfig_Localised_en_US"."ID" IS NOT NULL THEN "SiteConfig_Localised_en_US"."OrderConfirmation"
ELSE "SiteConfig"."OrderConfirmation" END
AS "OrderConfirmation", CASE
WHEN "SiteConfig_Localised_en_US"."ID" IS NOT NULL THEN "SiteConfig_Localised_en_US"."ReceiptInfo"
ELSE "SiteConfig"."ReceiptInfo" END
AS "ReceiptInfo", CASE
WHEN "SiteConfig_Localised_en_US"."ID" IS NOT NULL THEN "SiteConfig_Localised_en_US"."OrderReceipt"
ELSE "SiteConfig"."OrderReceipt" END
AS "OrderReceipt", CASE
WHEN "SiteConfig_Localised_en_US"."ID" IS NOT NULL THEN "SiteConfig_Localised_en_US"."VIPMailContent"
ELSE "SiteConfig"."VIPMailContent" END
AS "VIPMailContent", CASE
WHEN "SiteConfig_Localised_en_US"."ID" IS NOT NULL THEN "SiteConfig_Localised_en_US"."ApplicationAccountHint"
ELSE "SiteConfig"."ApplicationAccountHint" END
AS "ApplicationAccountHint", CASE
WHEN "SiteConfig_Localised_en_US"."ID" IS NOT NULL THEN "SiteConfig_Localised_en_US"."ApplicationTermsHint"
ELSE "SiteConfig"."ApplicationTermsHint" END
AS "ApplicationTermsHint", CASE
WHEN "SiteConfig_Localised_en_US"."ID" IS NOT NULL THEN "SiteConfig_Localised_en_US"."ApplicationQuantityHint"
ELSE "SiteConfig"."ApplicationQuantityHint" END
AS "ApplicationQuantityHint", CASE
WHEN "SiteConfig_Localised_en_US"."ID" IS NOT NULL THEN "SiteConfig_Localised_en_US"."Title"
ELSE "SiteConfig"."Title" END
AS "Title", CASE
WHEN "SiteConfig_Localised_en_US"."ID" IS NOT NULL THEN "SiteConfig_Localised_en_US"."Tagline"
ELSE "SiteConfig"."Tagline" END
AS "Tagline", "SiteConfig"."CanViewType", "SiteConfig"."CanEditType", "SiteConfig"."CanCreateTopLevelType", "SiteConfig"."TermsPageID", "SiteConfig"."CustomerGroupID", "SiteConfig"."DefaultProductImageID", "SiteConfig"."CMSLogoID", "SiteConfig"."LegacyImportMappingID", "SiteConfig"."SS3ImportFileID", "SiteConfig"."LogoID", "SiteConfig"."EmblemID", "SiteConfig"."FixedBackGroundImageID", "SiteConfig"."CTALinkID", "SiteConfig"."PrivacyPageID", CASE
WHEN "SiteConfig_Localised_en_US"."ID" IS NOT NULL THEN "SiteConfig_Localised_en_US"."WhitePaperID"
ELSE "SiteConfig"."WhitePaperID" END
AS "WhitePaperID", "SiteConfig"."DecisionQuestionsBGID", "SiteConfig"."ID",
CASE WHEN "SiteConfig"."ClassName" IS NOT NULL THEN "SiteConfig"."ClassName"
ELSE 'SilverStripe\\SiteConfig\\SiteConfig' END AS "RecordClassName", 'en_US' AS "Locale", CASE WHEN "SiteConfig_Localised_en_US"."ID" IS NOT NULL THEN 'en_US'
ELSE NULL END AS "SourceLocale"
FROM "SiteConfig" LEFT JOIN "SiteConfig_Localised" AS "SiteConfig_Localised_en_US" ON "SiteConfig"."ID" = "SiteConfig_Localised_en_US"."RecordID" AND "SiteConfig_Localised_en_US"."Locale" = ?
WHERE (("SiteConfig_Localised_en_US"."ID" IS NOT NULL))
LIMIT 1
0.0057s
0013: SELECT DISTINCT "SiteTree_Live"."DeepLTranslated", "SiteTree_Live"."OriginalID", "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", CASE
WHEN "Page_Localised_en_US"."ID" IS NOT NULL THEN "Page_Localised_en_US"."Subtitle"
ELSE "Page_Live"."Subtitle" END
AS "Subtitle", "Page_Live"."ShowInFooter", "Page_Live"."ShowInLegalMenu", CASE
WHEN "Page_Localised_en_US"."ID" IS NOT NULL THEN "Page_Localised_en_US"."MetaTitle"
ELSE "Page_Live"."MetaTitle" END
AS "MetaTitle", "Page_Live"."BlockFromSearchEngines", CASE
WHEN "Page_Localised_en_US"."ID" IS NOT NULL THEN "Page_Localised_en_US"."NavigationTeaser"
ELSE "Page_Live"."NavigationTeaser" END
AS "NavigationTeaser", "Page_Live"."ShowCTA", CASE
WHEN "Page_Localised_en_US"."ID" IS NOT NULL THEN "Page_Localised_en_US"."HeroBoxTitle"
ELSE "Page_Live"."HeroBoxTitle" END
AS "HeroBoxTitle", CASE
WHEN "Page_Localised_en_US"."ID" IS NOT NULL THEN "Page_Localised_en_US"."HeroBoxExternalLink"
ELSE "Page_Live"."HeroBoxExternalLink" END
AS "HeroBoxExternalLink", CASE
WHEN "Page_Localised_en_US"."ID" IS NOT NULL THEN "Page_Localised_en_US"."HeroBoxContent"
ELSE "Page_Live"."HeroBoxContent" END
AS "HeroBoxContent", "Page_Live"."ShowHeroBox", "Page_Live"."NaviLinkDesktopClickable", "Page_Live"."ElementalAreaID", "Page_Live"."HeroImageID", "Page_Live"."HeroBoxFlagID", "Page_Live"."HeroBoxLinkID", "SiteTree_Live"."ID",
CASE WHEN "SiteTree_Live"."ClassName" IS NOT NULL THEN "SiteTree_Live"."ClassName"
ELSE 'SilverStripe\\CMS\\Model\\SiteTree' END AS "RecordClassName", 'en_US' AS "Locale", CASE WHEN "Page_Localised_en_US"."ID" IS NOT NULL THEN 'en_US'
ELSE NULL END AS "SourceLocale", "SiteTree_Live"."Sort"
FROM "SiteTree_Live" LEFT JOIN "Page_Live" ON "Page_Live"."ID" = "SiteTree_Live"."ID" LEFT JOIN "SiteTree_Localised_Live" AS "SiteTree_Localised_en_US" ON "SiteTree_Live"."ID" = "SiteTree_Localised_en_US"."RecordID" AND "SiteTree_Localised_en_US"."Locale" = ? LEFT JOIN "Page_Localised_Live" AS "Page_Localised_en_US" ON "Page_Live"."ID" = "Page_Localised_en_US"."RecordID" AND "Page_Localised_en_US"."Locale" = ?
WHERE ("SiteTree_Live"."ID" = ?)
AND ("SiteTree_Live"."ClassName" IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?))
AND (("SiteTree_Localised_en_US"."ID" IS NOT NULL))
ORDER BY "SiteTree_Live"."Sort" ASC
LIMIT 1
0.003s
0014: SELECT DISTINCT "SiteTree_Live"."DeepLTranslated", "SiteTree_Live"."OriginalID", "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", CASE
WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."SiteTreeLinkerHelper"
ELSE "SiteTree_Live"."SiteTreeLinkerHelper" END
AS "SiteTreeLinkerHelper", "SiteTree_Live"."CanViewType", "SiteTree_Live"."CanEditType", "SiteTree_Live"."Version", CASE
WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."URLSegment"
ELSE "SiteTree_Live"."URLSegment" END
AS "URLSegment", CASE
WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."Title"
ELSE "SiteTree_Live"."Title" END
AS "Title", CASE
WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."MenuTitle"
ELSE "SiteTree_Live"."MenuTitle" END
AS "MenuTitle", CASE
WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."Content"
ELSE "SiteTree_Live"."Content" END
AS "Content", CASE
WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."MetaDescription"
ELSE "SiteTree_Live"."MetaDescription" END
AS "MetaDescription", "SiteTree_Live"."ExtraMeta", "SiteTree_Live"."ShowInMenus", "SiteTree_Live"."ShowInSearch", "SiteTree_Live"."Sort", "SiteTree_Live"."HasBrokenFile", "SiteTree_Live"."HasBrokenLink", CASE
WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."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", 'en_US' AS "Locale", CASE WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN 'en_US'
ELSE NULL END AS "SourceLocale"
FROM "SiteTree_Live" LEFT JOIN "SiteTree_Localised_Live" AS "SiteTree_Localised_en_US" ON "SiteTree_Live"."ID" = "SiteTree_Localised_en_US"."RecordID" AND "SiteTree_Localised_en_US"."Locale" = ?
WHERE ("SiteTree_Live"."ShowInMenus" = ?)
AND ("SiteTree_Live"."ParentID" = ?)
AND (("SiteTree_Localised_en_US"."ID" IS NOT NULL))
ORDER BY "SiteTree_Live"."Sort" ASC
0.004s
0015: SELECT DISTINCT "SiteTree_Live"."DeepLTranslated", "SiteTree_Live"."OriginalID", "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", CASE
WHEN "Page_Localised_en_US"."ID" IS NOT NULL THEN "Page_Localised_en_US"."Subtitle"
ELSE "Page_Live"."Subtitle" END
AS "Subtitle", "Page_Live"."ShowInFooter", "Page_Live"."ShowInLegalMenu", CASE
WHEN "Page_Localised_en_US"."ID" IS NOT NULL THEN "Page_Localised_en_US"."MetaTitle"
ELSE "Page_Live"."MetaTitle" END
AS "MetaTitle", "Page_Live"."BlockFromSearchEngines", CASE
WHEN "Page_Localised_en_US"."ID" IS NOT NULL THEN "Page_Localised_en_US"."NavigationTeaser"
ELSE "Page_Live"."NavigationTeaser" END
AS "NavigationTeaser", "Page_Live"."ShowCTA", CASE
WHEN "Page_Localised_en_US"."ID" IS NOT NULL THEN "Page_Localised_en_US"."HeroBoxTitle"
ELSE "Page_Live"."HeroBoxTitle" END
AS "HeroBoxTitle", CASE
WHEN "Page_Localised_en_US"."ID" IS NOT NULL THEN "Page_Localised_en_US"."HeroBoxExternalLink"
ELSE "Page_Live"."HeroBoxExternalLink" END
AS "HeroBoxExternalLink", CASE
WHEN "Page_Localised_en_US"."ID" IS NOT NULL THEN "Page_Localised_en_US"."HeroBoxContent"
ELSE "Page_Live"."HeroBoxContent" END
AS "HeroBoxContent", "Page_Live"."ShowHeroBox", "Page_Live"."NaviLinkDesktopClickable", "Page_Live"."ElementalAreaID", "Page_Live"."HeroImageID", "Page_Live"."HeroBoxFlagID", "Page_Live"."HeroBoxLinkID", "SiteTree_Live"."ID",
CASE WHEN "SiteTree_Live"."ClassName" IS NOT NULL THEN "SiteTree_Live"."ClassName"
ELSE 'SilverStripe\\CMS\\Model\\SiteTree' END AS "RecordClassName", 'en_US' AS "Locale", CASE WHEN "Page_Localised_en_US"."ID" IS NOT NULL THEN 'en_US'
ELSE NULL END AS "SourceLocale", "SiteTree_Live"."Sort"
FROM "SiteTree_Live" LEFT JOIN "Page_Live" ON "Page_Live"."ID" = "SiteTree_Live"."ID" LEFT JOIN "SiteTree_Localised_Live" AS "SiteTree_Localised_en_US" ON "SiteTree_Live"."ID" = "SiteTree_Localised_en_US"."RecordID" AND "SiteTree_Localised_en_US"."Locale" = ? LEFT JOIN "Page_Localised_Live" AS "Page_Localised_en_US" ON "Page_Live"."ID" = "Page_Localised_en_US"."RecordID" AND "Page_Localised_en_US"."Locale" = ?
WHERE ("SiteTree_Live"."ID" = ?)
AND ("SiteTree_Live"."ClassName" IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?))
AND (("SiteTree_Localised_en_US"."ID" IS NOT NULL))
ORDER BY "SiteTree_Live"."Sort" ASC
LIMIT 1
0.0009s
0016: SELECT DISTINCT "SiteTree_Live"."DeepLTranslated", "SiteTree_Live"."OriginalID", "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", CASE
WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."SiteTreeLinkerHelper"
ELSE "SiteTree_Live"."SiteTreeLinkerHelper" END
AS "SiteTreeLinkerHelper", "SiteTree_Live"."CanViewType", "SiteTree_Live"."CanEditType", "SiteTree_Live"."Version", CASE
WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."URLSegment"
ELSE "SiteTree_Live"."URLSegment" END
AS "URLSegment", CASE
WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."Title"
ELSE "SiteTree_Live"."Title" END
AS "Title", CASE
WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."MenuTitle"
ELSE "SiteTree_Live"."MenuTitle" END
AS "MenuTitle", CASE
WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."Content"
ELSE "SiteTree_Live"."Content" END
AS "Content", CASE
WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."MetaDescription"
ELSE "SiteTree_Live"."MetaDescription" END
AS "MetaDescription", "SiteTree_Live"."ExtraMeta", "SiteTree_Live"."ShowInMenus", "SiteTree_Live"."ShowInSearch", "SiteTree_Live"."Sort", "SiteTree_Live"."HasBrokenFile", "SiteTree_Live"."HasBrokenLink", CASE
WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."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", 'en_US' AS "Locale", CASE WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN 'en_US'
ELSE NULL END AS "SourceLocale"
FROM "SiteTree_Live" LEFT JOIN "SiteTree_Localised_Live" AS "SiteTree_Localised_en_US" ON "SiteTree_Live"."ID" = "SiteTree_Localised_en_US"."RecordID" AND "SiteTree_Localised_en_US"."Locale" = ?
WHERE ("SiteTree_Live"."ParentID" <> "SiteTree_Live"."ID")
AND ("SiteTree_Live"."ParentID" = ?)
AND ("SiteTree_Live"."ShowInMenus" = ?)
AND (("SiteTree_Localised_en_US"."ID" IS NOT NULL))
ORDER BY "SiteTree_Live"."Sort" ASC
0.0034s
0017: SELECT DISTINCT "SiteTree_Live"."DeepLTranslated", "SiteTree_Live"."OriginalID", "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", CASE
WHEN "Page_Localised_en_US"."ID" IS NOT NULL THEN "Page_Localised_en_US"."Subtitle"
ELSE "Page_Live"."Subtitle" END
AS "Subtitle", "Page_Live"."ShowInFooter", "Page_Live"."ShowInLegalMenu", CASE
WHEN "Page_Localised_en_US"."ID" IS NOT NULL THEN "Page_Localised_en_US"."MetaTitle"
ELSE "Page_Live"."MetaTitle" END
AS "MetaTitle", "Page_Live"."BlockFromSearchEngines", CASE
WHEN "Page_Localised_en_US"."ID" IS NOT NULL THEN "Page_Localised_en_US"."NavigationTeaser"
ELSE "Page_Live"."NavigationTeaser" END
AS "NavigationTeaser", "Page_Live"."ShowCTA", CASE
WHEN "Page_Localised_en_US"."ID" IS NOT NULL THEN "Page_Localised_en_US"."HeroBoxTitle"
ELSE "Page_Live"."HeroBoxTitle" END
AS "HeroBoxTitle", CASE
WHEN "Page_Localised_en_US"."ID" IS NOT NULL THEN "Page_Localised_en_US"."HeroBoxExternalLink"
ELSE "Page_Live"."HeroBoxExternalLink" END
AS "HeroBoxExternalLink", CASE
WHEN "Page_Localised_en_US"."ID" IS NOT NULL THEN "Page_Localised_en_US"."HeroBoxContent"
ELSE "Page_Live"."HeroBoxContent" END
AS "HeroBoxContent", "Page_Live"."ShowHeroBox", "Page_Live"."NaviLinkDesktopClickable", "Page_Live"."ElementalAreaID", "Page_Live"."HeroImageID", "Page_Live"."HeroBoxFlagID", "Page_Live"."HeroBoxLinkID", "SiteTree_Live"."ID",
CASE WHEN "SiteTree_Live"."ClassName" IS NOT NULL THEN "SiteTree_Live"."ClassName"
ELSE 'SilverStripe\\CMS\\Model\\SiteTree' END AS "RecordClassName", 'en_US' AS "Locale", CASE WHEN "Page_Localised_en_US"."ID" IS NOT NULL THEN 'en_US'
ELSE NULL END AS "SourceLocale", "SiteTree_Live"."Sort"
FROM "SiteTree_Live" LEFT JOIN "Page_Live" ON "Page_Live"."ID" = "SiteTree_Live"."ID" LEFT JOIN "SiteTree_Localised_Live" AS "SiteTree_Localised_en_US" ON "SiteTree_Live"."ID" = "SiteTree_Localised_en_US"."RecordID" AND "SiteTree_Localised_en_US"."Locale" = ? LEFT JOIN "Page_Localised_Live" AS "Page_Localised_en_US" ON "Page_Live"."ID" = "Page_Localised_en_US"."RecordID" AND "Page_Localised_en_US"."Locale" = ?
WHERE ("SiteTree_Live"."ID" = ?)
AND ("SiteTree_Live"."ClassName" IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?))
AND (("SiteTree_Localised_en_US"."ID" IS NOT NULL))
ORDER BY "SiteTree_Live"."Sort" ASC
LIMIT 1
0.0009s
0018: SELECT DISTINCT "SiteTree_Live"."DeepLTranslated", "SiteTree_Live"."OriginalID", "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", CASE
WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."SiteTreeLinkerHelper"
ELSE "SiteTree_Live"."SiteTreeLinkerHelper" END
AS "SiteTreeLinkerHelper", "SiteTree_Live"."CanViewType", "SiteTree_Live"."CanEditType", "SiteTree_Live"."Version", CASE
WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."URLSegment"
ELSE "SiteTree_Live"."URLSegment" END
AS "URLSegment", CASE
WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."Title"
ELSE "SiteTree_Live"."Title" END
AS "Title", CASE
WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."MenuTitle"
ELSE "SiteTree_Live"."MenuTitle" END
AS "MenuTitle", CASE
WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."Content"
ELSE "SiteTree_Live"."Content" END
AS "Content", CASE
WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."MetaDescription"
ELSE "SiteTree_Live"."MetaDescription" END
AS "MetaDescription", "SiteTree_Live"."ExtraMeta", "SiteTree_Live"."ShowInMenus", "SiteTree_Live"."ShowInSearch", "SiteTree_Live"."Sort", "SiteTree_Live"."HasBrokenFile", "SiteTree_Live"."HasBrokenLink", CASE
WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."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", 'en_US' AS "Locale", CASE WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN 'en_US'
ELSE NULL END AS "SourceLocale"
FROM "SiteTree_Live" LEFT JOIN "SiteTree_Localised_Live" AS "SiteTree_Localised_en_US" ON "SiteTree_Live"."ID" = "SiteTree_Localised_en_US"."RecordID" AND "SiteTree_Localised_en_US"."Locale" = ?
WHERE ("SiteTree_Live"."ParentID" <> "SiteTree_Live"."ID")
AND ("SiteTree_Live"."ParentID" = ?)
AND ("SiteTree_Live"."ShowInMenus" = ?)
AND (("SiteTree_Localised_en_US"."ID" IS NOT NULL))
ORDER BY "SiteTree_Live"."Sort" ASC
0.0033s
0019: SELECT DISTINCT "SiteTree_Live"."DeepLTranslated", "SiteTree_Live"."OriginalID", "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", CASE
WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."SiteTreeLinkerHelper"
ELSE "SiteTree_Live"."SiteTreeLinkerHelper" END
AS "SiteTreeLinkerHelper", "SiteTree_Live"."CanViewType", "SiteTree_Live"."CanEditType", "SiteTree_Live"."Version", CASE
WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."URLSegment"
ELSE "SiteTree_Live"."URLSegment" END
AS "URLSegment", CASE
WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."Title"
ELSE "SiteTree_Live"."Title" END
AS "Title", CASE
WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."MenuTitle"
ELSE "SiteTree_Live"."MenuTitle" END
AS "MenuTitle", CASE
WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."Content"
ELSE "SiteTree_Live"."Content" END
AS "Content", CASE
WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."MetaDescription"
ELSE "SiteTree_Live"."MetaDescription" END
AS "MetaDescription", "SiteTree_Live"."ExtraMeta", "SiteTree_Live"."ShowInMenus", "SiteTree_Live"."ShowInSearch", "SiteTree_Live"."Sort", "SiteTree_Live"."HasBrokenFile", "SiteTree_Live"."HasBrokenLink", CASE
WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."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", 'en_US' AS "Locale", CASE WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN 'en_US'
ELSE NULL END AS "SourceLocale"
FROM "SiteTree_Live" LEFT JOIN "SiteTree_Localised_Live" AS "SiteTree_Localised_en_US" ON "SiteTree_Live"."ID" = "SiteTree_Localised_en_US"."RecordID" AND "SiteTree_Localised_en_US"."Locale" = ?
WHERE ("SiteTree_Live"."ID" = ?)
AND (("SiteTree_Localised_en_US"."ID" IS NOT NULL))
ORDER BY "SiteTree_Live"."Sort" ASC
LIMIT 1
0.0016s
0020: SELECT DISTINCT "SiteTree_Live"."DeepLTranslated", "SiteTree_Live"."OriginalID", "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", CASE
WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."SiteTreeLinkerHelper"
ELSE "SiteTree_Live"."SiteTreeLinkerHelper" END
AS "SiteTreeLinkerHelper", "SiteTree_Live"."CanViewType", "SiteTree_Live"."CanEditType", "SiteTree_Live"."Version", CASE
WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."URLSegment"
ELSE "SiteTree_Live"."URLSegment" END
AS "URLSegment", CASE
WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."Title"
ELSE "SiteTree_Live"."Title" END
AS "Title", CASE
WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."MenuTitle"
ELSE "SiteTree_Live"."MenuTitle" END
AS "MenuTitle", CASE
WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."Content"
ELSE "SiteTree_Live"."Content" END
AS "Content", CASE
WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."MetaDescription"
ELSE "SiteTree_Live"."MetaDescription" END
AS "MetaDescription", "SiteTree_Live"."ExtraMeta", "SiteTree_Live"."ShowInMenus", "SiteTree_Live"."ShowInSearch", "SiteTree_Live"."Sort", "SiteTree_Live"."HasBrokenFile", "SiteTree_Live"."HasBrokenLink", CASE
WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."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", 'en_US' AS "Locale", CASE WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN 'en_US'
ELSE NULL END AS "SourceLocale"
FROM "SiteTree_Live" LEFT JOIN "SiteTree_Localised_Live" AS "SiteTree_Localised_en_US" ON "SiteTree_Live"."ID" = "SiteTree_Localised_en_US"."RecordID" AND "SiteTree_Localised_en_US"."Locale" = ?
WHERE ("SiteTree_Live"."ID" = ?)
AND (("SiteTree_Localised_en_US"."ID" IS NOT NULL))
ORDER BY "SiteTree_Live"."Sort" ASC
LIMIT 1
0.0007s
0021: SELECT DISTINCT "SiteTree_Live"."DeepLTranslated", "SiteTree_Live"."OriginalID", "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", CASE
WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."SiteTreeLinkerHelper"
ELSE "SiteTree_Live"."SiteTreeLinkerHelper" END
AS "SiteTreeLinkerHelper", "SiteTree_Live"."CanViewType", "SiteTree_Live"."CanEditType", "SiteTree_Live"."Version", CASE
WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."URLSegment"
ELSE "SiteTree_Live"."URLSegment" END
AS "URLSegment", CASE
WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."Title"
ELSE "SiteTree_Live"."Title" END
AS "Title", CASE
WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."MenuTitle"
ELSE "SiteTree_Live"."MenuTitle" END
AS "MenuTitle", CASE
WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."Content"
ELSE "SiteTree_Live"."Content" END
AS "Content", CASE
WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."MetaDescription"
ELSE "SiteTree_Live"."MetaDescription" END
AS "MetaDescription", "SiteTree_Live"."ExtraMeta", "SiteTree_Live"."ShowInMenus", "SiteTree_Live"."ShowInSearch", "SiteTree_Live"."Sort", "SiteTree_Live"."HasBrokenFile", "SiteTree_Live"."HasBrokenLink", CASE
WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."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", 'en_US' AS "Locale", CASE WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN 'en_US'
ELSE NULL END AS "SourceLocale"
FROM "SiteTree_Live" LEFT JOIN "SiteTree_Localised_Live" AS "SiteTree_Localised_en_US" ON "SiteTree_Live"."ID" = "SiteTree_Localised_en_US"."RecordID" AND "SiteTree_Localised_en_US"."Locale" = ?
WHERE ("SiteTree_Live"."ID" = ?)
AND (("SiteTree_Localised_en_US"."ID" IS NOT NULL))
ORDER BY "SiteTree_Live"."Sort" ASC
LIMIT 1
0.0007s
0022: SELECT DISTINCT "SiteTree_Live"."DeepLTranslated", "SiteTree_Live"."OriginalID", "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", CASE
WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."SiteTreeLinkerHelper"
ELSE "SiteTree_Live"."SiteTreeLinkerHelper" END
AS "SiteTreeLinkerHelper", "SiteTree_Live"."CanViewType", "SiteTree_Live"."CanEditType", "SiteTree_Live"."Version", CASE
WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."URLSegment"
ELSE "SiteTree_Live"."URLSegment" END
AS "URLSegment", CASE
WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."Title"
ELSE "SiteTree_Live"."Title" END
AS "Title", CASE
WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."MenuTitle"
ELSE "SiteTree_Live"."MenuTitle" END
AS "MenuTitle", CASE
WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."Content"
ELSE "SiteTree_Live"."Content" END
AS "Content", CASE
WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."MetaDescription"
ELSE "SiteTree_Live"."MetaDescription" END
AS "MetaDescription", "SiteTree_Live"."ExtraMeta", "SiteTree_Live"."ShowInMenus", "SiteTree_Live"."ShowInSearch", "SiteTree_Live"."Sort", "SiteTree_Live"."HasBrokenFile", "SiteTree_Live"."HasBrokenLink", CASE
WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."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", 'en_US' AS "Locale", CASE WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN 'en_US'
ELSE NULL END AS "SourceLocale"
FROM "SiteTree_Live" LEFT JOIN "SiteTree_Localised_Live" AS "SiteTree_Localised_en_US" ON "SiteTree_Live"."ID" = "SiteTree_Localised_en_US"."RecordID" AND "SiteTree_Localised_en_US"."Locale" = ?
WHERE ("SiteTree_Live"."ID" = ?)
AND (("SiteTree_Localised_en_US"."ID" IS NOT NULL))
ORDER BY "SiteTree_Live"."Sort" ASC
LIMIT 1
0.0007s
0023: SELECT DISTINCT "SiteTree_Live"."DeepLTranslated", "SiteTree_Live"."OriginalID", "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", CASE
WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."SiteTreeLinkerHelper"
ELSE "SiteTree_Live"."SiteTreeLinkerHelper" END
AS "SiteTreeLinkerHelper", "SiteTree_Live"."CanViewType", "SiteTree_Live"."CanEditType", "SiteTree_Live"."Version", CASE
WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."URLSegment"
ELSE "SiteTree_Live"."URLSegment" END
AS "URLSegment", CASE
WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."Title"
ELSE "SiteTree_Live"."Title" END
AS "Title", CASE
WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."MenuTitle"
ELSE "SiteTree_Live"."MenuTitle" END
AS "MenuTitle", CASE
WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."Content"
ELSE "SiteTree_Live"."Content" END
AS "Content", CASE
WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."MetaDescription"
ELSE "SiteTree_Live"."MetaDescription" END
AS "MetaDescription", "SiteTree_Live"."ExtraMeta", "SiteTree_Live"."ShowInMenus", "SiteTree_Live"."ShowInSearch", "SiteTree_Live"."Sort", "SiteTree_Live"."HasBrokenFile", "SiteTree_Live"."HasBrokenLink", CASE
WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."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", 'en_US' AS "Locale", CASE WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN 'en_US'
ELSE NULL END AS "SourceLocale"
FROM "SiteTree_Live" LEFT JOIN "SiteTree_Localised_Live" AS "SiteTree_Localised_en_US" ON "SiteTree_Live"."ID" = "SiteTree_Localised_en_US"."RecordID" AND "SiteTree_Localised_en_US"."Locale" = ?
WHERE ("SiteTree_Live"."ID" = ?)
AND (("SiteTree_Localised_en_US"."ID" IS NOT NULL))
ORDER BY "SiteTree_Live"."Sort" ASC
LIMIT 1
0.0008s
0024: SELECT DISTINCT "SiteTree_Live"."DeepLTranslated", "SiteTree_Live"."OriginalID", "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", CASE
WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."SiteTreeLinkerHelper"
ELSE "SiteTree_Live"."SiteTreeLinkerHelper" END
AS "SiteTreeLinkerHelper", "SiteTree_Live"."CanViewType", "SiteTree_Live"."CanEditType", "SiteTree_Live"."Version", CASE
WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."URLSegment"
ELSE "SiteTree_Live"."URLSegment" END
AS "URLSegment", CASE
WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."Title"
ELSE "SiteTree_Live"."Title" END
AS "Title", CASE
WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."MenuTitle"
ELSE "SiteTree_Live"."MenuTitle" END
AS "MenuTitle", CASE
WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."Content"
ELSE "SiteTree_Live"."Content" END
AS "Content", CASE
WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."MetaDescription"
ELSE "SiteTree_Live"."MetaDescription" END
AS "MetaDescription", "SiteTree_Live"."ExtraMeta", "SiteTree_Live"."ShowInMenus", "SiteTree_Live"."ShowInSearch", "SiteTree_Live"."Sort", "SiteTree_Live"."HasBrokenFile", "SiteTree_Live"."HasBrokenLink", CASE
WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."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", 'en_US' AS "Locale", CASE WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN 'en_US'
ELSE NULL END AS "SourceLocale"
FROM "SiteTree_Live" LEFT JOIN "SiteTree_Localised_Live" AS "SiteTree_Localised_en_US" ON "SiteTree_Live"."ID" = "SiteTree_Localised_en_US"."RecordID" AND "SiteTree_Localised_en_US"."Locale" = ?
WHERE ("SiteTree_Live"."ParentID" <> "SiteTree_Live"."ID")
AND ("SiteTree_Live"."ParentID" = ?)
AND ("SiteTree_Live"."ShowInMenus" = ?)
AND (("SiteTree_Localised_en_US"."ID" IS NOT NULL))
ORDER BY "SiteTree_Live"."Sort" ASC
0.0037s
0025: SELECT DISTINCT "SiteTree_Live"."DeepLTranslated", "SiteTree_Live"."OriginalID", "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", CASE
WHEN "Page_Localised_en_US"."ID" IS NOT NULL THEN "Page_Localised_en_US"."Subtitle"
ELSE "Page_Live"."Subtitle" END
AS "Subtitle", "Page_Live"."ShowInFooter", "Page_Live"."ShowInLegalMenu", CASE
WHEN "Page_Localised_en_US"."ID" IS NOT NULL THEN "Page_Localised_en_US"."MetaTitle"
ELSE "Page_Live"."MetaTitle" END
AS "MetaTitle", "Page_Live"."BlockFromSearchEngines", CASE
WHEN "Page_Localised_en_US"."ID" IS NOT NULL THEN "Page_Localised_en_US"."NavigationTeaser"
ELSE "Page_Live"."NavigationTeaser" END
AS "NavigationTeaser", "Page_Live"."ShowCTA", CASE
WHEN "Page_Localised_en_US"."ID" IS NOT NULL THEN "Page_Localised_en_US"."HeroBoxTitle"
ELSE "Page_Live"."HeroBoxTitle" END
AS "HeroBoxTitle", CASE
WHEN "Page_Localised_en_US"."ID" IS NOT NULL THEN "Page_Localised_en_US"."HeroBoxExternalLink"
ELSE "Page_Live"."HeroBoxExternalLink" END
AS "HeroBoxExternalLink", CASE
WHEN "Page_Localised_en_US"."ID" IS NOT NULL THEN "Page_Localised_en_US"."HeroBoxContent"
ELSE "Page_Live"."HeroBoxContent" END
AS "HeroBoxContent", "Page_Live"."ShowHeroBox", "Page_Live"."NaviLinkDesktopClickable", "Page_Live"."ElementalAreaID", "Page_Live"."HeroImageID", "Page_Live"."HeroBoxFlagID", "Page_Live"."HeroBoxLinkID", "SiteTree_Live"."ID",
CASE WHEN "SiteTree_Live"."ClassName" IS NOT NULL THEN "SiteTree_Live"."ClassName"
ELSE 'SilverStripe\\CMS\\Model\\SiteTree' END AS "RecordClassName", 'en_US' AS "Locale", CASE WHEN "Page_Localised_en_US"."ID" IS NOT NULL THEN 'en_US'
ELSE NULL END AS "SourceLocale", "SiteTree_Live"."Sort"
FROM "SiteTree_Live" LEFT JOIN "Page_Live" ON "Page_Live"."ID" = "SiteTree_Live"."ID" LEFT JOIN "SiteTree_Localised_Live" AS "SiteTree_Localised_en_US" ON "SiteTree_Live"."ID" = "SiteTree_Localised_en_US"."RecordID" AND "SiteTree_Localised_en_US"."Locale" = ? LEFT JOIN "Page_Localised_Live" AS "Page_Localised_en_US" ON "Page_Live"."ID" = "Page_Localised_en_US"."RecordID" AND "Page_Localised_en_US"."Locale" = ?
WHERE ("SiteTree_Live"."ID" = ?)
AND ("SiteTree_Live"."ClassName" IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?))
AND (("SiteTree_Localised_en_US"."ID" IS NOT NULL))
ORDER BY "SiteTree_Live"."Sort" ASC
LIMIT 1
0.001s
0026: SELECT DISTINCT "SiteTree_Live"."DeepLTranslated", "SiteTree_Live"."OriginalID", "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", CASE
WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."SiteTreeLinkerHelper"
ELSE "SiteTree_Live"."SiteTreeLinkerHelper" END
AS "SiteTreeLinkerHelper", "SiteTree_Live"."CanViewType", "SiteTree_Live"."CanEditType", "SiteTree_Live"."Version", CASE
WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."URLSegment"
ELSE "SiteTree_Live"."URLSegment" END
AS "URLSegment", CASE
WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."Title"
ELSE "SiteTree_Live"."Title" END
AS "Title", CASE
WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."MenuTitle"
ELSE "SiteTree_Live"."MenuTitle" END
AS "MenuTitle", CASE
WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."Content"
ELSE "SiteTree_Live"."Content" END
AS "Content", CASE
WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."MetaDescription"
ELSE "SiteTree_Live"."MetaDescription" END
AS "MetaDescription", "SiteTree_Live"."ExtraMeta", "SiteTree_Live"."ShowInMenus", "SiteTree_Live"."ShowInSearch", "SiteTree_Live"."Sort", "SiteTree_Live"."HasBrokenFile", "SiteTree_Live"."HasBrokenLink", CASE
WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."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", 'en_US' AS "Locale", CASE WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN 'en_US'
ELSE NULL END AS "SourceLocale"
FROM "SiteTree_Live" LEFT JOIN "SiteTree_Localised_Live" AS "SiteTree_Localised_en_US" ON "SiteTree_Live"."ID" = "SiteTree_Localised_en_US"."RecordID" AND "SiteTree_Localised_en_US"."Locale" = ?
WHERE ("SiteTree_Live"."ParentID" <> "SiteTree_Live"."ID")
AND ("SiteTree_Live"."ParentID" = ?)
AND ("SiteTree_Live"."ShowInMenus" = ?)
AND (("SiteTree_Localised_en_US"."ID" IS NOT NULL))
ORDER BY "SiteTree_Live"."Sort" ASC
0.0025s
0027: SELECT DISTINCT "SiteTree_Live"."DeepLTranslated", "SiteTree_Live"."OriginalID", "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", CASE
WHEN "Page_Localised_en_US"."ID" IS NOT NULL THEN "Page_Localised_en_US"."Subtitle"
ELSE "Page_Live"."Subtitle" END
AS "Subtitle", "Page_Live"."ShowInFooter", "Page_Live"."ShowInLegalMenu", CASE
WHEN "Page_Localised_en_US"."ID" IS NOT NULL THEN "Page_Localised_en_US"."MetaTitle"
ELSE "Page_Live"."MetaTitle" END
AS "MetaTitle", "Page_Live"."BlockFromSearchEngines", CASE
WHEN "Page_Localised_en_US"."ID" IS NOT NULL THEN "Page_Localised_en_US"."NavigationTeaser"
ELSE "Page_Live"."NavigationTeaser" END
AS "NavigationTeaser", "Page_Live"."ShowCTA", CASE
WHEN "Page_Localised_en_US"."ID" IS NOT NULL THEN "Page_Localised_en_US"."HeroBoxTitle"
ELSE "Page_Live"."HeroBoxTitle" END
AS "HeroBoxTitle", CASE
WHEN "Page_Localised_en_US"."ID" IS NOT NULL THEN "Page_Localised_en_US"."HeroBoxExternalLink"
ELSE "Page_Live"."HeroBoxExternalLink" END
AS "HeroBoxExternalLink", CASE
WHEN "Page_Localised_en_US"."ID" IS NOT NULL THEN "Page_Localised_en_US"."HeroBoxContent"
ELSE "Page_Live"."HeroBoxContent" END
AS "HeroBoxContent", "Page_Live"."ShowHeroBox", "Page_Live"."NaviLinkDesktopClickable", "Page_Live"."ElementalAreaID", "Page_Live"."HeroImageID", "Page_Live"."HeroBoxFlagID", "Page_Live"."HeroBoxLinkID", "SiteTree_Live"."ID",
CASE WHEN "SiteTree_Live"."ClassName" IS NOT NULL THEN "SiteTree_Live"."ClassName"
ELSE 'SilverStripe\\CMS\\Model\\SiteTree' END AS "RecordClassName", 'en_US' AS "Locale", CASE WHEN "Page_Localised_en_US"."ID" IS NOT NULL THEN 'en_US'
ELSE NULL END AS "SourceLocale", "SiteTree_Live"."Sort"
FROM "SiteTree_Live" LEFT JOIN "Page_Live" ON "Page_Live"."ID" = "SiteTree_Live"."ID" LEFT JOIN "SiteTree_Localised_Live" AS "SiteTree_Localised_en_US" ON "SiteTree_Live"."ID" = "SiteTree_Localised_en_US"."RecordID" AND "SiteTree_Localised_en_US"."Locale" = ? LEFT JOIN "Page_Localised_Live" AS "Page_Localised_en_US" ON "Page_Live"."ID" = "Page_Localised_en_US"."RecordID" AND "Page_Localised_en_US"."Locale" = ?
WHERE ("SiteTree_Live"."ID" = ?)
AND ("SiteTree_Live"."ClassName" IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?))
AND (("SiteTree_Localised_en_US"."ID" IS NOT NULL))
ORDER BY "SiteTree_Live"."Sort" ASC
LIMIT 1
0.0008s
0028: SELECT DISTINCT "SiteTree_Live"."DeepLTranslated", "SiteTree_Live"."OriginalID", "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", CASE
WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."SiteTreeLinkerHelper"
ELSE "SiteTree_Live"."SiteTreeLinkerHelper" END
AS "SiteTreeLinkerHelper", "SiteTree_Live"."CanViewType", "SiteTree_Live"."CanEditType", "SiteTree_Live"."Version", CASE
WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."URLSegment"
ELSE "SiteTree_Live"."URLSegment" END
AS "URLSegment", CASE
WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."Title"
ELSE "SiteTree_Live"."Title" END
AS "Title", CASE
WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."MenuTitle"
ELSE "SiteTree_Live"."MenuTitle" END
AS "MenuTitle", CASE
WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."Content"
ELSE "SiteTree_Live"."Content" END
AS "Content", CASE
WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."MetaDescription"
ELSE "SiteTree_Live"."MetaDescription" END
AS "MetaDescription", "SiteTree_Live"."ExtraMeta", "SiteTree_Live"."ShowInMenus", "SiteTree_Live"."ShowInSearch", "SiteTree_Live"."Sort", "SiteTree_Live"."HasBrokenFile", "SiteTree_Live"."HasBrokenLink", CASE
WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."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", 'en_US' AS "Locale", CASE WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN 'en_US'
ELSE NULL END AS "SourceLocale"
FROM "SiteTree_Live" LEFT JOIN "SiteTree_Localised_Live" AS "SiteTree_Localised_en_US" ON "SiteTree_Live"."ID" = "SiteTree_Localised_en_US"."RecordID" AND "SiteTree_Localised_en_US"."Locale" = ?
WHERE ("SiteTree_Live"."ParentID" <> "SiteTree_Live"."ID")
AND ("SiteTree_Live"."ParentID" = ?)
AND ("SiteTree_Live"."ShowInMenus" = ?)
AND (("SiteTree_Localised_en_US"."ID" IS NOT NULL))
ORDER BY "SiteTree_Live"."Sort" ASC
0.0021s
0029: SELECT DISTINCT "SiteTree_Live"."DeepLTranslated", "SiteTree_Live"."OriginalID", "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", CASE
WHEN "Page_Localised_en_US"."ID" IS NOT NULL THEN "Page_Localised_en_US"."Subtitle"
ELSE "Page_Live"."Subtitle" END
AS "Subtitle", "Page_Live"."ShowInFooter", "Page_Live"."ShowInLegalMenu", CASE
WHEN "Page_Localised_en_US"."ID" IS NOT NULL THEN "Page_Localised_en_US"."MetaTitle"
ELSE "Page_Live"."MetaTitle" END
AS "MetaTitle", "Page_Live"."BlockFromSearchEngines", CASE
WHEN "Page_Localised_en_US"."ID" IS NOT NULL THEN "Page_Localised_en_US"."NavigationTeaser"
ELSE "Page_Live"."NavigationTeaser" END
AS "NavigationTeaser", "Page_Live"."ShowCTA", CASE
WHEN "Page_Localised_en_US"."ID" IS NOT NULL THEN "Page_Localised_en_US"."HeroBoxTitle"
ELSE "Page_Live"."HeroBoxTitle" END
AS "HeroBoxTitle", CASE
WHEN "Page_Localised_en_US"."ID" IS NOT NULL THEN "Page_Localised_en_US"."HeroBoxExternalLink"
ELSE "Page_Live"."HeroBoxExternalLink" END
AS "HeroBoxExternalLink", CASE
WHEN "Page_Localised_en_US"."ID" IS NOT NULL THEN "Page_Localised_en_US"."HeroBoxContent"
ELSE "Page_Live"."HeroBoxContent" END
AS "HeroBoxContent", "Page_Live"."ShowHeroBox", "Page_Live"."NaviLinkDesktopClickable", "Page_Live"."ElementalAreaID", "Page_Live"."HeroImageID", "Page_Live"."HeroBoxFlagID", "Page_Live"."HeroBoxLinkID", "SiteTree_Live"."ID",
CASE WHEN "SiteTree_Live"."ClassName" IS NOT NULL THEN "SiteTree_Live"."ClassName"
ELSE 'SilverStripe\\CMS\\Model\\SiteTree' END AS "RecordClassName", 'en_US' AS "Locale", CASE WHEN "Page_Localised_en_US"."ID" IS NOT NULL THEN 'en_US'
ELSE NULL END AS "SourceLocale", "SiteTree_Live"."Sort"
FROM "SiteTree_Live" LEFT JOIN "Page_Live" ON "Page_Live"."ID" = "SiteTree_Live"."ID" LEFT JOIN "SiteTree_Localised_Live" AS "SiteTree_Localised_en_US" ON "SiteTree_Live"."ID" = "SiteTree_Localised_en_US"."RecordID" AND "SiteTree_Localised_en_US"."Locale" = ? LEFT JOIN "Page_Localised_Live" AS "Page_Localised_en_US" ON "Page_Live"."ID" = "Page_Localised_en_US"."RecordID" AND "Page_Localised_en_US"."Locale" = ?
WHERE ("SiteTree_Live"."ID" = ?)
AND ("SiteTree_Live"."ClassName" IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?))
AND (("SiteTree_Localised_en_US"."ID" IS NOT NULL))
ORDER BY "SiteTree_Live"."Sort" ASC
LIMIT 1
0.0011s
0030: SELECT DISTINCT "SiteTree_Live"."DeepLTranslated", "SiteTree_Live"."OriginalID", "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", CASE
WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."SiteTreeLinkerHelper"
ELSE "SiteTree_Live"."SiteTreeLinkerHelper" END
AS "SiteTreeLinkerHelper", "SiteTree_Live"."CanViewType", "SiteTree_Live"."CanEditType", "SiteTree_Live"."Version", CASE
WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."URLSegment"
ELSE "SiteTree_Live"."URLSegment" END
AS "URLSegment", CASE
WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."Title"
ELSE "SiteTree_Live"."Title" END
AS "Title", CASE
WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."MenuTitle"
ELSE "SiteTree_Live"."MenuTitle" END
AS "MenuTitle", CASE
WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."Content"
ELSE "SiteTree_Live"."Content" END
AS "Content", CASE
WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."MetaDescription"
ELSE "SiteTree_Live"."MetaDescription" END
AS "MetaDescription", "SiteTree_Live"."ExtraMeta", "SiteTree_Live"."ShowInMenus", "SiteTree_Live"."ShowInSearch", "SiteTree_Live"."Sort", "SiteTree_Live"."HasBrokenFile", "SiteTree_Live"."HasBrokenLink", CASE
WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."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", 'en_US' AS "Locale", CASE WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN 'en_US'
ELSE NULL END AS "SourceLocale"
FROM "SiteTree_Live" LEFT JOIN "SiteTree_Localised_Live" AS "SiteTree_Localised_en_US" ON "SiteTree_Live"."ID" = "SiteTree_Localised_en_US"."RecordID" AND "SiteTree_Localised_en_US"."Locale" = ?
WHERE ("SiteTree_Live"."ParentID" <> "SiteTree_Live"."ID")
AND ("SiteTree_Live"."ParentID" = ?)
AND ("SiteTree_Live"."ShowInMenus" = ?)
AND (("SiteTree_Localised_en_US"."ID" IS NOT NULL))
ORDER BY "SiteTree_Live"."Sort" ASC
0.0022s
0031: SELECT DISTINCT "SiteTree_Live"."DeepLTranslated", "SiteTree_Live"."OriginalID", "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", CASE
WHEN "Page_Localised_en_US"."ID" IS NOT NULL THEN "Page_Localised_en_US"."Subtitle"
ELSE "Page_Live"."Subtitle" END
AS "Subtitle", "Page_Live"."ShowInFooter", "Page_Live"."ShowInLegalMenu", CASE
WHEN "Page_Localised_en_US"."ID" IS NOT NULL THEN "Page_Localised_en_US"."MetaTitle"
ELSE "Page_Live"."MetaTitle" END
AS "MetaTitle", "Page_Live"."BlockFromSearchEngines", CASE
WHEN "Page_Localised_en_US"."ID" IS NOT NULL THEN "Page_Localised_en_US"."NavigationTeaser"
ELSE "Page_Live"."NavigationTeaser" END
AS "NavigationTeaser", "Page_Live"."ShowCTA", CASE
WHEN "Page_Localised_en_US"."ID" IS NOT NULL THEN "Page_Localised_en_US"."HeroBoxTitle"
ELSE "Page_Live"."HeroBoxTitle" END
AS "HeroBoxTitle", CASE
WHEN "Page_Localised_en_US"."ID" IS NOT NULL THEN "Page_Localised_en_US"."HeroBoxExternalLink"
ELSE "Page_Live"."HeroBoxExternalLink" END
AS "HeroBoxExternalLink", CASE
WHEN "Page_Localised_en_US"."ID" IS NOT NULL THEN "Page_Localised_en_US"."HeroBoxContent"
ELSE "Page_Live"."HeroBoxContent" END
AS "HeroBoxContent", "Page_Live"."ShowHeroBox", "Page_Live"."NaviLinkDesktopClickable", "Page_Live"."ElementalAreaID", "Page_Live"."HeroImageID", "Page_Live"."HeroBoxFlagID", "Page_Live"."HeroBoxLinkID", "SiteTree_Live"."ID",
CASE WHEN "SiteTree_Live"."ClassName" IS NOT NULL THEN "SiteTree_Live"."ClassName"
ELSE 'SilverStripe\\CMS\\Model\\SiteTree' END AS "RecordClassName", 'en_US' AS "Locale", CASE WHEN "Page_Localised_en_US"."ID" IS NOT NULL THEN 'en_US'
ELSE NULL END AS "SourceLocale", "SiteTree_Live"."Sort"
FROM "SiteTree_Live" LEFT JOIN "Page_Live" ON "Page_Live"."ID" = "SiteTree_Live"."ID" LEFT JOIN "SiteTree_Localised_Live" AS "SiteTree_Localised_en_US" ON "SiteTree_Live"."ID" = "SiteTree_Localised_en_US"."RecordID" AND "SiteTree_Localised_en_US"."Locale" = ? LEFT JOIN "Page_Localised_Live" AS "Page_Localised_en_US" ON "Page_Live"."ID" = "Page_Localised_en_US"."RecordID" AND "Page_Localised_en_US"."Locale" = ?
WHERE ("SiteTree_Live"."ID" = ?)
AND ("SiteTree_Live"."ClassName" IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?))
AND (("SiteTree_Localised_en_US"."ID" IS NOT NULL))
ORDER BY "SiteTree_Live"."Sort" ASC
LIMIT 1
0.0009s
0032: SELECT DISTINCT "SiteTree_Live"."DeepLTranslated", "SiteTree_Live"."OriginalID", "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", CASE
WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."SiteTreeLinkerHelper"
ELSE "SiteTree_Live"."SiteTreeLinkerHelper" END
AS "SiteTreeLinkerHelper", "SiteTree_Live"."CanViewType", "SiteTree_Live"."CanEditType", "SiteTree_Live"."Version", CASE
WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."URLSegment"
ELSE "SiteTree_Live"."URLSegment" END
AS "URLSegment", CASE
WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."Title"
ELSE "SiteTree_Live"."Title" END
AS "Title", CASE
WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."MenuTitle"
ELSE "SiteTree_Live"."MenuTitle" END
AS "MenuTitle", CASE
WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."Content"
ELSE "SiteTree_Live"."Content" END
AS "Content", CASE
WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."MetaDescription"
ELSE "SiteTree_Live"."MetaDescription" END
AS "MetaDescription", "SiteTree_Live"."ExtraMeta", "SiteTree_Live"."ShowInMenus", "SiteTree_Live"."ShowInSearch", "SiteTree_Live"."Sort", "SiteTree_Live"."HasBrokenFile", "SiteTree_Live"."HasBrokenLink", CASE
WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."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", 'en_US' AS "Locale", CASE WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN 'en_US'
ELSE NULL END AS "SourceLocale"
FROM "SiteTree_Live" LEFT JOIN "SiteTree_Localised_Live" AS "SiteTree_Localised_en_US" ON "SiteTree_Live"."ID" = "SiteTree_Localised_en_US"."RecordID" AND "SiteTree_Localised_en_US"."Locale" = ?
WHERE ("SiteTree_Live"."ParentID" <> "SiteTree_Live"."ID")
AND ("SiteTree_Live"."ParentID" = ?)
AND ("SiteTree_Live"."ShowInMenus" = ?)
AND (("SiteTree_Localised_en_US"."ID" IS NOT NULL))
ORDER BY "SiteTree_Live"."Sort" ASC
0.0029s
0033: SELECT DISTINCT "SiteTree_Live"."DeepLTranslated", "SiteTree_Live"."OriginalID", "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "RedirectorPage_Live"."RedirectionType", CASE
WHEN "RedirectorPage_Localised_en_US"."ID" IS NOT NULL THEN "RedirectorPage_Localised_en_US"."ExternalURL"
ELSE "RedirectorPage_Live"."ExternalURL" END
AS "ExternalURL", "RedirectorPage_Live"."LinkToID", "RedirectorPage_Live"."LinkToFileID", "SiteTree_Live"."ID",
CASE WHEN "SiteTree_Live"."ClassName" IS NOT NULL THEN "SiteTree_Live"."ClassName"
ELSE 'SilverStripe\\CMS\\Model\\SiteTree' END AS "RecordClassName", 'en_US' AS "Locale", CASE WHEN "RedirectorPage_Localised_en_US"."ID" IS NOT NULL THEN 'en_US'
ELSE NULL END AS "SourceLocale", "SiteTree_Live"."Sort"
FROM "SiteTree_Live" LEFT JOIN "Page_Live" ON "Page_Live"."ID" = "SiteTree_Live"."ID" LEFT JOIN "RedirectorPage_Live" ON "RedirectorPage_Live"."ID" = "SiteTree_Live"."ID" LEFT JOIN "SiteTree_Localised_Live" AS "SiteTree_Localised_en_US" ON "SiteTree_Live"."ID" = "SiteTree_Localised_en_US"."RecordID" AND "SiteTree_Localised_en_US"."Locale" = ? LEFT JOIN "Page_Localised_Live" AS "Page_Localised_en_US" ON "Page_Live"."ID" = "Page_Localised_en_US"."RecordID" AND "Page_Localised_en_US"."Locale" = ? LEFT JOIN "RedirectorPage_Localised_Live" AS "RedirectorPage_Localised_en_US" ON "RedirectorPage_Live"."ID" = "RedirectorPage_Localised_en_US"."RecordID" AND "RedirectorPage_Localised_en_US"."Locale" = ?
WHERE ("SiteTree_Live"."ID" = ?)
AND ("SiteTree_Live"."ClassName" IN (?))
AND (("SiteTree_Localised_en_US"."ID" IS NOT NULL))
ORDER BY "SiteTree_Live"."Sort" ASC
LIMIT 1
0.0024s
0034: SELECT DISTINCT "SiteTree_Live"."DeepLTranslated", "SiteTree_Live"."OriginalID", "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", CASE
WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."SiteTreeLinkerHelper"
ELSE "SiteTree_Live"."SiteTreeLinkerHelper" END
AS "SiteTreeLinkerHelper", "SiteTree_Live"."CanViewType", "SiteTree_Live"."CanEditType", "SiteTree_Live"."Version", CASE
WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."URLSegment"
ELSE "SiteTree_Live"."URLSegment" END
AS "URLSegment", CASE
WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."Title"
ELSE "SiteTree_Live"."Title" END
AS "Title", CASE
WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."MenuTitle"
ELSE "SiteTree_Live"."MenuTitle" END
AS "MenuTitle", CASE
WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."Content"
ELSE "SiteTree_Live"."Content" END
AS "Content", CASE
WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."MetaDescription"
ELSE "SiteTree_Live"."MetaDescription" END
AS "MetaDescription", "SiteTree_Live"."ExtraMeta", "SiteTree_Live"."ShowInMenus", "SiteTree_Live"."ShowInSearch", "SiteTree_Live"."Sort", "SiteTree_Live"."HasBrokenFile", "SiteTree_Live"."HasBrokenLink", CASE
WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."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", 'en_US' AS "Locale", CASE WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN 'en_US'
ELSE NULL END AS "SourceLocale"
FROM "SiteTree_Live" LEFT JOIN "SiteTree_Localised_Live" AS "SiteTree_Localised_en_US" ON "SiteTree_Live"."ID" = "SiteTree_Localised_en_US"."RecordID" AND "SiteTree_Localised_en_US"."Locale" = ?
WHERE ("SiteTree_Live"."ID" = ?)
AND (("SiteTree_Localised_en_US"."ID" IS NOT NULL))
ORDER BY "SiteTree_Live"."Sort" ASC
LIMIT 1
0.0007s
0035: SELECT DISTINCT "SiteTree_Live"."DeepLTranslated", "SiteTree_Live"."OriginalID", "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", CASE
WHEN "Page_Localised_en_US"."ID" IS NOT NULL THEN "Page_Localised_en_US"."Subtitle"
ELSE "Page_Live"."Subtitle" END
AS "Subtitle", "Page_Live"."ShowInFooter", "Page_Live"."ShowInLegalMenu", CASE
WHEN "Page_Localised_en_US"."ID" IS NOT NULL THEN "Page_Localised_en_US"."MetaTitle"
ELSE "Page_Live"."MetaTitle" END
AS "MetaTitle", "Page_Live"."BlockFromSearchEngines", CASE
WHEN "Page_Localised_en_US"."ID" IS NOT NULL THEN "Page_Localised_en_US"."NavigationTeaser"
ELSE "Page_Live"."NavigationTeaser" END
AS "NavigationTeaser", "Page_Live"."ShowCTA", CASE
WHEN "Page_Localised_en_US"."ID" IS NOT NULL THEN "Page_Localised_en_US"."HeroBoxTitle"
ELSE "Page_Live"."HeroBoxTitle" END
AS "HeroBoxTitle", CASE
WHEN "Page_Localised_en_US"."ID" IS NOT NULL THEN "Page_Localised_en_US"."HeroBoxExternalLink"
ELSE "Page_Live"."HeroBoxExternalLink" END
AS "HeroBoxExternalLink", CASE
WHEN "Page_Localised_en_US"."ID" IS NOT NULL THEN "Page_Localised_en_US"."HeroBoxContent"
ELSE "Page_Live"."HeroBoxContent" END
AS "HeroBoxContent", "Page_Live"."ShowHeroBox", "Page_Live"."NaviLinkDesktopClickable", "Page_Live"."ElementalAreaID", "Page_Live"."HeroImageID", "Page_Live"."HeroBoxFlagID", "Page_Live"."HeroBoxLinkID", "SiteTree_Live"."ID",
CASE WHEN "SiteTree_Live"."ClassName" IS NOT NULL THEN "SiteTree_Live"."ClassName"
ELSE 'SilverStripe\\CMS\\Model\\SiteTree' END AS "RecordClassName", 'en_US' AS "Locale", CASE WHEN "Page_Localised_en_US"."ID" IS NOT NULL THEN 'en_US'
ELSE NULL END AS "SourceLocale", "SiteTree_Live"."Sort"
FROM "SiteTree_Live" LEFT JOIN "Page_Live" ON "Page_Live"."ID" = "SiteTree_Live"."ID" LEFT JOIN "SiteTree_Localised_Live" AS "SiteTree_Localised_en_US" ON "SiteTree_Live"."ID" = "SiteTree_Localised_en_US"."RecordID" AND "SiteTree_Localised_en_US"."Locale" = ? LEFT JOIN "Page_Localised_Live" AS "Page_Localised_en_US" ON "Page_Live"."ID" = "Page_Localised_en_US"."RecordID" AND "Page_Localised_en_US"."Locale" = ?
WHERE ("SiteTree_Live"."ID" = ?)
AND ("SiteTree_Live"."ClassName" IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?))
AND (("SiteTree_Localised_en_US"."ID" IS NOT NULL))
ORDER BY "SiteTree_Live"."Sort" ASC
LIMIT 1
0.0011s
0036: SELECT DISTINCT "SiteTree_Live"."DeepLTranslated", "SiteTree_Live"."OriginalID", "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", CASE
WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."SiteTreeLinkerHelper"
ELSE "SiteTree_Live"."SiteTreeLinkerHelper" END
AS "SiteTreeLinkerHelper", "SiteTree_Live"."CanViewType", "SiteTree_Live"."CanEditType", "SiteTree_Live"."Version", CASE
WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."URLSegment"
ELSE "SiteTree_Live"."URLSegment" END
AS "URLSegment", CASE
WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."Title"
ELSE "SiteTree_Live"."Title" END
AS "Title", CASE
WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."MenuTitle"
ELSE "SiteTree_Live"."MenuTitle" END
AS "MenuTitle", CASE
WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."Content"
ELSE "SiteTree_Live"."Content" END
AS "Content", CASE
WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."MetaDescription"
ELSE "SiteTree_Live"."MetaDescription" END
AS "MetaDescription", "SiteTree_Live"."ExtraMeta", "SiteTree_Live"."ShowInMenus", "SiteTree_Live"."ShowInSearch", "SiteTree_Live"."Sort", "SiteTree_Live"."HasBrokenFile", "SiteTree_Live"."HasBrokenLink", CASE
WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."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", 'en_US' AS "Locale", CASE WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN 'en_US'
ELSE NULL END AS "SourceLocale"
FROM "SiteTree_Live" LEFT JOIN "SiteTree_Localised_Live" AS "SiteTree_Localised_en_US" ON "SiteTree_Live"."ID" = "SiteTree_Localised_en_US"."RecordID" AND "SiteTree_Localised_en_US"."Locale" = ?
WHERE ("SiteTree_Live"."ParentID" <> "SiteTree_Live"."ID")
AND ("SiteTree_Live"."ParentID" = ?)
AND ("SiteTree_Live"."ShowInMenus" = ?)
AND (("SiteTree_Localised_en_US"."ID" IS NOT NULL))
ORDER BY "SiteTree_Live"."Sort" ASC
0.0022s
0037: SELECT DISTINCT "SiteTree_Live"."DeepLTranslated", "SiteTree_Live"."OriginalID", "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", CASE
WHEN "Page_Localised_en_US"."ID" IS NOT NULL THEN "Page_Localised_en_US"."Subtitle"
ELSE "Page_Live"."Subtitle" END
AS "Subtitle", "Page_Live"."ShowInFooter", "Page_Live"."ShowInLegalMenu", CASE
WHEN "Page_Localised_en_US"."ID" IS NOT NULL THEN "Page_Localised_en_US"."MetaTitle"
ELSE "Page_Live"."MetaTitle" END
AS "MetaTitle", "Page_Live"."BlockFromSearchEngines", CASE
WHEN "Page_Localised_en_US"."ID" IS NOT NULL THEN "Page_Localised_en_US"."NavigationTeaser"
ELSE "Page_Live"."NavigationTeaser" END
AS "NavigationTeaser", "Page_Live"."ShowCTA", CASE
WHEN "Page_Localised_en_US"."ID" IS NOT NULL THEN "Page_Localised_en_US"."HeroBoxTitle"
ELSE "Page_Live"."HeroBoxTitle" END
AS "HeroBoxTitle", CASE
WHEN "Page_Localised_en_US"."ID" IS NOT NULL THEN "Page_Localised_en_US"."HeroBoxExternalLink"
ELSE "Page_Live"."HeroBoxExternalLink" END
AS "HeroBoxExternalLink", CASE
WHEN "Page_Localised_en_US"."ID" IS NOT NULL THEN "Page_Localised_en_US"."HeroBoxContent"
ELSE "Page_Live"."HeroBoxContent" END
AS "HeroBoxContent", "Page_Live"."ShowHeroBox", "Page_Live"."NaviLinkDesktopClickable", "Page_Live"."ElementalAreaID", "Page_Live"."HeroImageID", "Page_Live"."HeroBoxFlagID", "Page_Live"."HeroBoxLinkID", "SiteTree_Live"."ID",
CASE WHEN "SiteTree_Live"."ClassName" IS NOT NULL THEN "SiteTree_Live"."ClassName"
ELSE 'SilverStripe\\CMS\\Model\\SiteTree' END AS "RecordClassName", 'en_US' AS "Locale", CASE WHEN "Page_Localised_en_US"."ID" IS NOT NULL THEN 'en_US'
ELSE NULL END AS "SourceLocale", "SiteTree_Live"."Sort"
FROM "SiteTree_Live" LEFT JOIN "Page_Live" ON "Page_Live"."ID" = "SiteTree_Live"."ID" LEFT JOIN "SiteTree_Localised_Live" AS "SiteTree_Localised_en_US" ON "SiteTree_Live"."ID" = "SiteTree_Localised_en_US"."RecordID" AND "SiteTree_Localised_en_US"."Locale" = ? LEFT JOIN "Page_Localised_Live" AS "Page_Localised_en_US" ON "Page_Live"."ID" = "Page_Localised_en_US"."RecordID" AND "Page_Localised_en_US"."Locale" = ?
WHERE ("SiteTree_Live"."ID" = ?)
AND ("SiteTree_Live"."ClassName" IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?))
AND (("SiteTree_Localised_en_US"."ID" IS NOT NULL))
ORDER BY "SiteTree_Live"."Sort" ASC
LIMIT 1
0.0011s
0038: SELECT DISTINCT "SiteTree_Live"."DeepLTranslated", "SiteTree_Live"."OriginalID", "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", CASE
WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."SiteTreeLinkerHelper"
ELSE "SiteTree_Live"."SiteTreeLinkerHelper" END
AS "SiteTreeLinkerHelper", "SiteTree_Live"."CanViewType", "SiteTree_Live"."CanEditType", "SiteTree_Live"."Version", CASE
WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."URLSegment"
ELSE "SiteTree_Live"."URLSegment" END
AS "URLSegment", CASE
WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."Title"
ELSE "SiteTree_Live"."Title" END
AS "Title", CASE
WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."MenuTitle"
ELSE "SiteTree_Live"."MenuTitle" END
AS "MenuTitle", CASE
WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."Content"
ELSE "SiteTree_Live"."Content" END
AS "Content", CASE
WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."MetaDescription"
ELSE "SiteTree_Live"."MetaDescription" END
AS "MetaDescription", "SiteTree_Live"."ExtraMeta", "SiteTree_Live"."ShowInMenus", "SiteTree_Live"."ShowInSearch", "SiteTree_Live"."Sort", "SiteTree_Live"."HasBrokenFile", "SiteTree_Live"."HasBrokenLink", CASE
WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."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", 'en_US' AS "Locale", CASE WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN 'en_US'
ELSE NULL END AS "SourceLocale"
FROM "SiteTree_Live" LEFT JOIN "SiteTree_Localised_Live" AS "SiteTree_Localised_en_US" ON "SiteTree_Live"."ID" = "SiteTree_Localised_en_US"."RecordID" AND "SiteTree_Localised_en_US"."Locale" = ?
WHERE ("SiteTree_Live"."ParentID" <> "SiteTree_Live"."ID")
AND ("SiteTree_Live"."ParentID" = ?)
AND ("SiteTree_Live"."ShowInMenus" = ?)
AND (("SiteTree_Localised_en_US"."ID" IS NOT NULL))
ORDER BY "SiteTree_Live"."Sort" ASC
0.0041s
0039: SELECT DISTINCT "SiteTree_Live"."DeepLTranslated", "SiteTree_Live"."OriginalID", "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", CASE
WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."SiteTreeLinkerHelper"
ELSE "SiteTree_Live"."SiteTreeLinkerHelper" END
AS "SiteTreeLinkerHelper", "SiteTree_Live"."CanViewType", "SiteTree_Live"."CanEditType", "SiteTree_Live"."Version", CASE
WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."URLSegment"
ELSE "SiteTree_Live"."URLSegment" END
AS "URLSegment", CASE
WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."Title"
ELSE "SiteTree_Live"."Title" END
AS "Title", CASE
WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."MenuTitle"
ELSE "SiteTree_Live"."MenuTitle" END
AS "MenuTitle", CASE
WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."Content"
ELSE "SiteTree_Live"."Content" END
AS "Content", CASE
WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."MetaDescription"
ELSE "SiteTree_Live"."MetaDescription" END
AS "MetaDescription", "SiteTree_Live"."ExtraMeta", "SiteTree_Live"."ShowInMenus", "SiteTree_Live"."ShowInSearch", "SiteTree_Live"."Sort", "SiteTree_Live"."HasBrokenFile", "SiteTree_Live"."HasBrokenLink", CASE
WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."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", 'en_US' AS "Locale", CASE WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN 'en_US'
ELSE NULL END AS "SourceLocale"
FROM "SiteTree_Live" LEFT JOIN "SiteTree_Localised_Live" AS "SiteTree_Localised_en_US" ON "SiteTree_Live"."ID" = "SiteTree_Localised_en_US"."RecordID" AND "SiteTree_Localised_en_US"."Locale" = ?
WHERE ("SiteTree_Live"."ID" = ?)
AND (("SiteTree_Localised_en_US"."ID" IS NOT NULL))
ORDER BY "SiteTree_Live"."Sort" ASC
LIMIT 1
0.0009s
0040: SELECT DISTINCT "SiteTree_Live"."DeepLTranslated", "SiteTree_Live"."OriginalID", "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", CASE
WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."SiteTreeLinkerHelper"
ELSE "SiteTree_Live"."SiteTreeLinkerHelper" END
AS "SiteTreeLinkerHelper", "SiteTree_Live"."CanViewType", "SiteTree_Live"."CanEditType", "SiteTree_Live"."Version", CASE
WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."URLSegment"
ELSE "SiteTree_Live"."URLSegment" END
AS "URLSegment", CASE
WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."Title"
ELSE "SiteTree_Live"."Title" END
AS "Title", CASE
WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."MenuTitle"
ELSE "SiteTree_Live"."MenuTitle" END
AS "MenuTitle", CASE
WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."Content"
ELSE "SiteTree_Live"."Content" END
AS "Content", CASE
WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."MetaDescription"
ELSE "SiteTree_Live"."MetaDescription" END
AS "MetaDescription", "SiteTree_Live"."ExtraMeta", "SiteTree_Live"."ShowInMenus", "SiteTree_Live"."ShowInSearch", "SiteTree_Live"."Sort", "SiteTree_Live"."HasBrokenFile", "SiteTree_Live"."HasBrokenLink", CASE
WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."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", 'en_US' AS "Locale", CASE WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN 'en_US'
ELSE NULL END AS "SourceLocale"
FROM "SiteTree_Live" LEFT JOIN "SiteTree_Localised_Live" AS "SiteTree_Localised_en_US" ON "SiteTree_Live"."ID" = "SiteTree_Localised_en_US"."RecordID" AND "SiteTree_Localised_en_US"."Locale" = ?
WHERE ("SiteTree_Live"."ID" = ?)
AND (("SiteTree_Localised_en_US"."ID" IS NOT NULL))
ORDER BY "SiteTree_Live"."Sort" ASC
LIMIT 1
0.0008s
0041: SELECT DISTINCT "SiteTree_Live"."DeepLTranslated", "SiteTree_Live"."OriginalID", "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", CASE
WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."SiteTreeLinkerHelper"
ELSE "SiteTree_Live"."SiteTreeLinkerHelper" END
AS "SiteTreeLinkerHelper", "SiteTree_Live"."CanViewType", "SiteTree_Live"."CanEditType", "SiteTree_Live"."Version", CASE
WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."URLSegment"
ELSE "SiteTree_Live"."URLSegment" END
AS "URLSegment", CASE
WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."Title"
ELSE "SiteTree_Live"."Title" END
AS "Title", CASE
WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."MenuTitle"
ELSE "SiteTree_Live"."MenuTitle" END
AS "MenuTitle", CASE
WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."Content"
ELSE "SiteTree_Live"."Content" END
AS "Content", CASE
WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."MetaDescription"
ELSE "SiteTree_Live"."MetaDescription" END
AS "MetaDescription", "SiteTree_Live"."ExtraMeta", "SiteTree_Live"."ShowInMenus", "SiteTree_Live"."ShowInSearch", "SiteTree_Live"."Sort", "SiteTree_Live"."HasBrokenFile", "SiteTree_Live"."HasBrokenLink", CASE
WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."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", 'en_US' AS "Locale", CASE WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN 'en_US'
ELSE NULL END AS "SourceLocale"
FROM "SiteTree_Live" LEFT JOIN "SiteTree_Localised_Live" AS "SiteTree_Localised_en_US" ON "SiteTree_Live"."ID" = "SiteTree_Localised_en_US"."RecordID" AND "SiteTree_Localised_en_US"."Locale" = ?
WHERE ("SiteTree_Live"."ID" = ?)
AND (("SiteTree_Localised_en_US"."ID" IS NOT NULL))
ORDER BY "SiteTree_Live"."Sort" ASC
LIMIT 1
0.0009s
0042: SELECT DISTINCT "SiteTree_Live"."DeepLTranslated", "SiteTree_Live"."OriginalID", "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", CASE
WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."SiteTreeLinkerHelper"
ELSE "SiteTree_Live"."SiteTreeLinkerHelper" END
AS "SiteTreeLinkerHelper", "SiteTree_Live"."CanViewType", "SiteTree_Live"."CanEditType", "SiteTree_Live"."Version", CASE
WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."URLSegment"
ELSE "SiteTree_Live"."URLSegment" END
AS "URLSegment", CASE
WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."Title"
ELSE "SiteTree_Live"."Title" END
AS "Title", CASE
WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."MenuTitle"
ELSE "SiteTree_Live"."MenuTitle" END
AS "MenuTitle", CASE
WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."Content"
ELSE "SiteTree_Live"."Content" END
AS "Content", CASE
WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."MetaDescription"
ELSE "SiteTree_Live"."MetaDescription" END
AS "MetaDescription", "SiteTree_Live"."ExtraMeta", "SiteTree_Live"."ShowInMenus", "SiteTree_Live"."ShowInSearch", "SiteTree_Live"."Sort", "SiteTree_Live"."HasBrokenFile", "SiteTree_Live"."HasBrokenLink", CASE
WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."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", 'en_US' AS "Locale", CASE WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN 'en_US'
ELSE NULL END AS "SourceLocale"
FROM "SiteTree_Live" LEFT JOIN "SiteTree_Localised_Live" AS "SiteTree_Localised_en_US" ON "SiteTree_Live"."ID" = "SiteTree_Localised_en_US"."RecordID" AND "SiteTree_Localised_en_US"."Locale" = ?
WHERE ("SiteTree_Live"."ID" = ?)
AND (("SiteTree_Localised_en_US"."ID" IS NOT NULL))
ORDER BY "SiteTree_Live"."Sort" ASC
LIMIT 1
0.001s
0043: SELECT DISTINCT "SiteTree_Live"."DeepLTranslated", "SiteTree_Live"."OriginalID", "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", CASE
WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."SiteTreeLinkerHelper"
ELSE "SiteTree_Live"."SiteTreeLinkerHelper" END
AS "SiteTreeLinkerHelper", "SiteTree_Live"."CanViewType", "SiteTree_Live"."CanEditType", "SiteTree_Live"."Version", CASE
WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."URLSegment"
ELSE "SiteTree_Live"."URLSegment" END
AS "URLSegment", CASE
WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."Title"
ELSE "SiteTree_Live"."Title" END
AS "Title", CASE
WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."MenuTitle"
ELSE "SiteTree_Live"."MenuTitle" END
AS "MenuTitle", CASE
WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."Content"
ELSE "SiteTree_Live"."Content" END
AS "Content", CASE
WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."MetaDescription"
ELSE "SiteTree_Live"."MetaDescription" END
AS "MetaDescription", "SiteTree_Live"."ExtraMeta", "SiteTree_Live"."ShowInMenus", "SiteTree_Live"."ShowInSearch", "SiteTree_Live"."Sort", "SiteTree_Live"."HasBrokenFile", "SiteTree_Live"."HasBrokenLink", CASE
WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."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", 'en_US' AS "Locale", CASE WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN 'en_US'
ELSE NULL END AS "SourceLocale"
FROM "SiteTree_Live" LEFT JOIN "SiteTree_Localised_Live" AS "SiteTree_Localised_en_US" ON "SiteTree_Live"."ID" = "SiteTree_Localised_en_US"."RecordID" AND "SiteTree_Localised_en_US"."Locale" = ?
WHERE ("SiteTree_Live"."ID" = ?)
AND (("SiteTree_Localised_en_US"."ID" IS NOT NULL))
ORDER BY "SiteTree_Live"."Sort" ASC
LIMIT 1
0.0007s
0044: SELECT DISTINCT "SiteTree_Live"."DeepLTranslated", "SiteTree_Live"."OriginalID", "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", CASE
WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."SiteTreeLinkerHelper"
ELSE "SiteTree_Live"."SiteTreeLinkerHelper" END
AS "SiteTreeLinkerHelper", "SiteTree_Live"."CanViewType", "SiteTree_Live"."CanEditType", "SiteTree_Live"."Version", CASE
WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."URLSegment"
ELSE "SiteTree_Live"."URLSegment" END
AS "URLSegment", CASE
WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."Title"
ELSE "SiteTree_Live"."Title" END
AS "Title", CASE
WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."MenuTitle"
ELSE "SiteTree_Live"."MenuTitle" END
AS "MenuTitle", CASE
WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."Content"
ELSE "SiteTree_Live"."Content" END
AS "Content", CASE
WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."MetaDescription"
ELSE "SiteTree_Live"."MetaDescription" END
AS "MetaDescription", "SiteTree_Live"."ExtraMeta", "SiteTree_Live"."ShowInMenus", "SiteTree_Live"."ShowInSearch", "SiteTree_Live"."Sort", "SiteTree_Live"."HasBrokenFile", "SiteTree_Live"."HasBrokenLink", CASE
WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."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", 'en_US' AS "Locale", CASE WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN 'en_US'
ELSE NULL END AS "SourceLocale"
FROM "SiteTree_Live" LEFT JOIN "SiteTree_Localised_Live" AS "SiteTree_Localised_en_US" ON "SiteTree_Live"."ID" = "SiteTree_Localised_en_US"."RecordID" AND "SiteTree_Localised_en_US"."Locale" = ?
WHERE ("SiteTree_Live"."ID" = ?)
AND (("SiteTree_Localised_en_US"."ID" IS NOT NULL))
ORDER BY "SiteTree_Live"."Sort" ASC
LIMIT 1
0.0007s
0045: SELECT DISTINCT "SiteTree_Live"."DeepLTranslated", "SiteTree_Live"."OriginalID", "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", CASE
WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."SiteTreeLinkerHelper"
ELSE "SiteTree_Live"."SiteTreeLinkerHelper" END
AS "SiteTreeLinkerHelper", "SiteTree_Live"."CanViewType", "SiteTree_Live"."CanEditType", "SiteTree_Live"."Version", CASE
WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."URLSegment"
ELSE "SiteTree_Live"."URLSegment" END
AS "URLSegment", CASE
WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."Title"
ELSE "SiteTree_Live"."Title" END
AS "Title", CASE
WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."MenuTitle"
ELSE "SiteTree_Live"."MenuTitle" END
AS "MenuTitle", CASE
WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."Content"
ELSE "SiteTree_Live"."Content" END
AS "Content", CASE
WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."MetaDescription"
ELSE "SiteTree_Live"."MetaDescription" END
AS "MetaDescription", "SiteTree_Live"."ExtraMeta", "SiteTree_Live"."ShowInMenus", "SiteTree_Live"."ShowInSearch", "SiteTree_Live"."Sort", "SiteTree_Live"."HasBrokenFile", "SiteTree_Live"."HasBrokenLink", CASE
WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."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", 'en_US' AS "Locale", CASE WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN 'en_US'
ELSE NULL END AS "SourceLocale"
FROM "SiteTree_Live" LEFT JOIN "SiteTree_Localised_Live" AS "SiteTree_Localised_en_US" ON "SiteTree_Live"."ID" = "SiteTree_Localised_en_US"."RecordID" AND "SiteTree_Localised_en_US"."Locale" = ?
WHERE ("SiteTree_Live"."ParentID" <> "SiteTree_Live"."ID")
AND ("SiteTree_Live"."ParentID" = ?)
AND ("SiteTree_Live"."ShowInMenus" = ?)
AND (("SiteTree_Localised_en_US"."ID" IS NOT NULL))
ORDER BY "SiteTree_Live"."Sort" ASC
0.0073s
0046: SELECT DISTINCT "SiteTree_Live"."DeepLTranslated", "SiteTree_Live"."OriginalID", "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", CASE
WHEN "Page_Localised_en_US"."ID" IS NOT NULL THEN "Page_Localised_en_US"."Subtitle"
ELSE "Page_Live"."Subtitle" END
AS "Subtitle", "Page_Live"."ShowInFooter", "Page_Live"."ShowInLegalMenu", CASE
WHEN "Page_Localised_en_US"."ID" IS NOT NULL THEN "Page_Localised_en_US"."MetaTitle"
ELSE "Page_Live"."MetaTitle" END
AS "MetaTitle", "Page_Live"."BlockFromSearchEngines", CASE
WHEN "Page_Localised_en_US"."ID" IS NOT NULL THEN "Page_Localised_en_US"."NavigationTeaser"
ELSE "Page_Live"."NavigationTeaser" END
AS "NavigationTeaser", "Page_Live"."ShowCTA", CASE
WHEN "Page_Localised_en_US"."ID" IS NOT NULL THEN "Page_Localised_en_US"."HeroBoxTitle"
ELSE "Page_Live"."HeroBoxTitle" END
AS "HeroBoxTitle", CASE
WHEN "Page_Localised_en_US"."ID" IS NOT NULL THEN "Page_Localised_en_US"."HeroBoxExternalLink"
ELSE "Page_Live"."HeroBoxExternalLink" END
AS "HeroBoxExternalLink", CASE
WHEN "Page_Localised_en_US"."ID" IS NOT NULL THEN "Page_Localised_en_US"."HeroBoxContent"
ELSE "Page_Live"."HeroBoxContent" END
AS "HeroBoxContent", "Page_Live"."ShowHeroBox", "Page_Live"."NaviLinkDesktopClickable", "Page_Live"."ElementalAreaID", "Page_Live"."HeroImageID", "Page_Live"."HeroBoxFlagID", "Page_Live"."HeroBoxLinkID", "SiteTree_Live"."ID",
CASE WHEN "SiteTree_Live"."ClassName" IS NOT NULL THEN "SiteTree_Live"."ClassName"
ELSE 'SilverStripe\\CMS\\Model\\SiteTree' END AS "RecordClassName", 'en_US' AS "Locale", CASE WHEN "Page_Localised_en_US"."ID" IS NOT NULL THEN 'en_US'
ELSE NULL END AS "SourceLocale", "SiteTree_Live"."Sort"
FROM "SiteTree_Live" LEFT JOIN "Page_Live" ON "Page_Live"."ID" = "SiteTree_Live"."ID" LEFT JOIN "SiteTree_Localised_Live" AS "SiteTree_Localised_en_US" ON "SiteTree_Live"."ID" = "SiteTree_Localised_en_US"."RecordID" AND "SiteTree_Localised_en_US"."Locale" = ? LEFT JOIN "Page_Localised_Live" AS "Page_Localised_en_US" ON "Page_Live"."ID" = "Page_Localised_en_US"."RecordID" AND "Page_Localised_en_US"."Locale" = ?
WHERE ("SiteTree_Live"."ID" = ?)
AND ("SiteTree_Live"."ClassName" IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?))
AND (("SiteTree_Localised_en_US"."ID" IS NOT NULL))
ORDER BY "SiteTree_Live"."Sort" ASC
LIMIT 1
0.0018s
0047: SELECT DISTINCT "SiteTree_Live"."DeepLTranslated", "SiteTree_Live"."OriginalID", "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", CASE
WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."SiteTreeLinkerHelper"
ELSE "SiteTree_Live"."SiteTreeLinkerHelper" END
AS "SiteTreeLinkerHelper", "SiteTree_Live"."CanViewType", "SiteTree_Live"."CanEditType", "SiteTree_Live"."Version", CASE
WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."URLSegment"
ELSE "SiteTree_Live"."URLSegment" END
AS "URLSegment", CASE
WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."Title"
ELSE "SiteTree_Live"."Title" END
AS "Title", CASE
WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."MenuTitle"
ELSE "SiteTree_Live"."MenuTitle" END
AS "MenuTitle", CASE
WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."Content"
ELSE "SiteTree_Live"."Content" END
AS "Content", CASE
WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."MetaDescription"
ELSE "SiteTree_Live"."MetaDescription" END
AS "MetaDescription", "SiteTree_Live"."ExtraMeta", "SiteTree_Live"."ShowInMenus", "SiteTree_Live"."ShowInSearch", "SiteTree_Live"."Sort", "SiteTree_Live"."HasBrokenFile", "SiteTree_Live"."HasBrokenLink", CASE
WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."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", 'en_US' AS "Locale", CASE WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN 'en_US'
ELSE NULL END AS "SourceLocale"
FROM "SiteTree_Live" LEFT JOIN "SiteTree_Localised_Live" AS "SiteTree_Localised_en_US" ON "SiteTree_Live"."ID" = "SiteTree_Localised_en_US"."RecordID" AND "SiteTree_Localised_en_US"."Locale" = ?
WHERE ("SiteTree_Live"."ParentID" <> "SiteTree_Live"."ID")
AND ("SiteTree_Live"."ParentID" = ?)
AND ("SiteTree_Live"."ShowInMenus" = ?)
AND (("SiteTree_Localised_en_US"."ID" IS NOT NULL))
ORDER BY "SiteTree_Live"."Sort" ASC
0.0024s
0048: SELECT DISTINCT "SiteTree_Live"."DeepLTranslated", "SiteTree_Live"."OriginalID", "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", CASE
WHEN "Page_Localised_en_US"."ID" IS NOT NULL THEN "Page_Localised_en_US"."Subtitle"
ELSE "Page_Live"."Subtitle" END
AS "Subtitle", "Page_Live"."ShowInFooter", "Page_Live"."ShowInLegalMenu", CASE
WHEN "Page_Localised_en_US"."ID" IS NOT NULL THEN "Page_Localised_en_US"."MetaTitle"
ELSE "Page_Live"."MetaTitle" END
AS "MetaTitle", "Page_Live"."BlockFromSearchEngines", CASE
WHEN "Page_Localised_en_US"."ID" IS NOT NULL THEN "Page_Localised_en_US"."NavigationTeaser"
ELSE "Page_Live"."NavigationTeaser" END
AS "NavigationTeaser", "Page_Live"."ShowCTA", CASE
WHEN "Page_Localised_en_US"."ID" IS NOT NULL THEN "Page_Localised_en_US"."HeroBoxTitle"
ELSE "Page_Live"."HeroBoxTitle" END
AS "HeroBoxTitle", CASE
WHEN "Page_Localised_en_US"."ID" IS NOT NULL THEN "Page_Localised_en_US"."HeroBoxExternalLink"
ELSE "Page_Live"."HeroBoxExternalLink" END
AS "HeroBoxExternalLink", CASE
WHEN "Page_Localised_en_US"."ID" IS NOT NULL THEN "Page_Localised_en_US"."HeroBoxContent"
ELSE "Page_Live"."HeroBoxContent" END
AS "HeroBoxContent", "Page_Live"."ShowHeroBox", "Page_Live"."NaviLinkDesktopClickable", "Page_Live"."ElementalAreaID", "Page_Live"."HeroImageID", "Page_Live"."HeroBoxFlagID", "Page_Live"."HeroBoxLinkID", "SiteTree_Live"."ID",
CASE WHEN "SiteTree_Live"."ClassName" IS NOT NULL THEN "SiteTree_Live"."ClassName"
ELSE 'SilverStripe\\CMS\\Model\\SiteTree' END AS "RecordClassName", 'en_US' AS "Locale", CASE WHEN "Page_Localised_en_US"."ID" IS NOT NULL THEN 'en_US'
ELSE NULL END AS "SourceLocale", "SiteTree_Live"."Sort"
FROM "SiteTree_Live" LEFT JOIN "Page_Live" ON "Page_Live"."ID" = "SiteTree_Live"."ID" LEFT JOIN "SiteTree_Localised_Live" AS "SiteTree_Localised_en_US" ON "SiteTree_Live"."ID" = "SiteTree_Localised_en_US"."RecordID" AND "SiteTree_Localised_en_US"."Locale" = ? LEFT JOIN "Page_Localised_Live" AS "Page_Localised_en_US" ON "Page_Live"."ID" = "Page_Localised_en_US"."RecordID" AND "Page_Localised_en_US"."Locale" = ?
WHERE ("SiteTree_Live"."ID" = ?)
AND ("SiteTree_Live"."ClassName" IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?))
AND (("SiteTree_Localised_en_US"."ID" IS NOT NULL))
ORDER BY "SiteTree_Live"."Sort" ASC
LIMIT 1
0.001s
0049: SELECT DISTINCT "SiteTree_Live"."DeepLTranslated", "SiteTree_Live"."OriginalID", "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", CASE
WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."SiteTreeLinkerHelper"
ELSE "SiteTree_Live"."SiteTreeLinkerHelper" END
AS "SiteTreeLinkerHelper", "SiteTree_Live"."CanViewType", "SiteTree_Live"."CanEditType", "SiteTree_Live"."Version", CASE
WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."URLSegment"
ELSE "SiteTree_Live"."URLSegment" END
AS "URLSegment", CASE
WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."Title"
ELSE "SiteTree_Live"."Title" END
AS "Title", CASE
WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."MenuTitle"
ELSE "SiteTree_Live"."MenuTitle" END
AS "MenuTitle", CASE
WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."Content"
ELSE "SiteTree_Live"."Content" END
AS "Content", CASE
WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."MetaDescription"
ELSE "SiteTree_Live"."MetaDescription" END
AS "MetaDescription", "SiteTree_Live"."ExtraMeta", "SiteTree_Live"."ShowInMenus", "SiteTree_Live"."ShowInSearch", "SiteTree_Live"."Sort", "SiteTree_Live"."HasBrokenFile", "SiteTree_Live"."HasBrokenLink", CASE
WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."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", 'en_US' AS "Locale", CASE WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN 'en_US'
ELSE NULL END AS "SourceLocale"
FROM "SiteTree_Live" LEFT JOIN "SiteTree_Localised_Live" AS "SiteTree_Localised_en_US" ON "SiteTree_Live"."ID" = "SiteTree_Localised_en_US"."RecordID" AND "SiteTree_Localised_en_US"."Locale" = ?
WHERE ("SiteTree_Live"."ParentID" <> "SiteTree_Live"."ID")
AND ("SiteTree_Live"."ParentID" = ?)
AND ("SiteTree_Live"."ShowInMenus" = ?)
AND (("SiteTree_Localised_en_US"."ID" IS NOT NULL))
ORDER BY "SiteTree_Live"."Sort" ASC
0.0022s
0050: SELECT DISTINCT "SiteTree_Live"."DeepLTranslated", "SiteTree_Live"."OriginalID", "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", CASE
WHEN "Page_Localised_en_US"."ID" IS NOT NULL THEN "Page_Localised_en_US"."Subtitle"
ELSE "Page_Live"."Subtitle" END
AS "Subtitle", "Page_Live"."ShowInFooter", "Page_Live"."ShowInLegalMenu", CASE
WHEN "Page_Localised_en_US"."ID" IS NOT NULL THEN "Page_Localised_en_US"."MetaTitle"
ELSE "Page_Live"."MetaTitle" END
AS "MetaTitle", "Page_Live"."BlockFromSearchEngines", CASE
WHEN "Page_Localised_en_US"."ID" IS NOT NULL THEN "Page_Localised_en_US"."NavigationTeaser"
ELSE "Page_Live"."NavigationTeaser" END
AS "NavigationTeaser", "Page_Live"."ShowCTA", CASE
WHEN "Page_Localised_en_US"."ID" IS NOT NULL THEN "Page_Localised_en_US"."HeroBoxTitle"
ELSE "Page_Live"."HeroBoxTitle" END
AS "HeroBoxTitle", CASE
WHEN "Page_Localised_en_US"."ID" IS NOT NULL THEN "Page_Localised_en_US"."HeroBoxExternalLink"
ELSE "Page_Live"."HeroBoxExternalLink" END
AS "HeroBoxExternalLink", CASE
WHEN "Page_Localised_en_US"."ID" IS NOT NULL THEN "Page_Localised_en_US"."HeroBoxContent"
ELSE "Page_Live"."HeroBoxContent" END
AS "HeroBoxContent", "Page_Live"."ShowHeroBox", "Page_Live"."NaviLinkDesktopClickable", "Page_Live"."ElementalAreaID", "Page_Live"."HeroImageID", "Page_Live"."HeroBoxFlagID", "Page_Live"."HeroBoxLinkID", "SiteTree_Live"."ID",
CASE WHEN "SiteTree_Live"."ClassName" IS NOT NULL THEN "SiteTree_Live"."ClassName"
ELSE 'SilverStripe\\CMS\\Model\\SiteTree' END AS "RecordClassName", 'en_US' AS "Locale", CASE WHEN "Page_Localised_en_US"."ID" IS NOT NULL THEN 'en_US'
ELSE NULL END AS "SourceLocale", "SiteTree_Live"."Sort"
FROM "SiteTree_Live" LEFT JOIN "Page_Live" ON "Page_Live"."ID" = "SiteTree_Live"."ID" LEFT JOIN "SiteTree_Localised_Live" AS "SiteTree_Localised_en_US" ON "SiteTree_Live"."ID" = "SiteTree_Localised_en_US"."RecordID" AND "SiteTree_Localised_en_US"."Locale" = ? LEFT JOIN "Page_Localised_Live" AS "Page_Localised_en_US" ON "Page_Live"."ID" = "Page_Localised_en_US"."RecordID" AND "Page_Localised_en_US"."Locale" = ?
WHERE ("SiteTree_Live"."ID" = ?)
AND ("SiteTree_Live"."ClassName" IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?))
AND (("SiteTree_Localised_en_US"."ID" IS NOT NULL))
ORDER BY "SiteTree_Live"."Sort" ASC
LIMIT 1
0.001s
0051: SELECT DISTINCT "SiteTree_Live"."DeepLTranslated", "SiteTree_Live"."OriginalID", "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", CASE
WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."SiteTreeLinkerHelper"
ELSE "SiteTree_Live"."SiteTreeLinkerHelper" END
AS "SiteTreeLinkerHelper", "SiteTree_Live"."CanViewType", "SiteTree_Live"."CanEditType", "SiteTree_Live"."Version", CASE
WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."URLSegment"
ELSE "SiteTree_Live"."URLSegment" END
AS "URLSegment", CASE
WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."Title"
ELSE "SiteTree_Live"."Title" END
AS "Title", CASE
WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."MenuTitle"
ELSE "SiteTree_Live"."MenuTitle" END
AS "MenuTitle", CASE
WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."Content"
ELSE "SiteTree_Live"."Content" END
AS "Content", CASE
WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."MetaDescription"
ELSE "SiteTree_Live"."MetaDescription" END
AS "MetaDescription", "SiteTree_Live"."ExtraMeta", "SiteTree_Live"."ShowInMenus", "SiteTree_Live"."ShowInSearch", "SiteTree_Live"."Sort", "SiteTree_Live"."HasBrokenFile", "SiteTree_Live"."HasBrokenLink", CASE
WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."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", 'en_US' AS "Locale", CASE WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN 'en_US'
ELSE NULL END AS "SourceLocale"
FROM "SiteTree_Live" LEFT JOIN "SiteTree_Localised_Live" AS "SiteTree_Localised_en_US" ON "SiteTree_Live"."ID" = "SiteTree_Localised_en_US"."RecordID" AND "SiteTree_Localised_en_US"."Locale" = ?
WHERE ("SiteTree_Live"."ParentID" <> "SiteTree_Live"."ID")
AND ("SiteTree_Live"."ParentID" = ?)
AND ("SiteTree_Live"."ShowInMenus" = ?)
AND (("SiteTree_Localised_en_US"."ID" IS NOT NULL))
ORDER BY "SiteTree_Live"."Sort" ASC
0.0024s
0052: SELECT DISTINCT "SiteTree_Live"."DeepLTranslated", "SiteTree_Live"."OriginalID", "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", CASE
WHEN "Page_Localised_en_US"."ID" IS NOT NULL THEN "Page_Localised_en_US"."Subtitle"
ELSE "Page_Live"."Subtitle" END
AS "Subtitle", "Page_Live"."ShowInFooter", "Page_Live"."ShowInLegalMenu", CASE
WHEN "Page_Localised_en_US"."ID" IS NOT NULL THEN "Page_Localised_en_US"."MetaTitle"
ELSE "Page_Live"."MetaTitle" END
AS "MetaTitle", "Page_Live"."BlockFromSearchEngines", CASE
WHEN "Page_Localised_en_US"."ID" IS NOT NULL THEN "Page_Localised_en_US"."NavigationTeaser"
ELSE "Page_Live"."NavigationTeaser" END
AS "NavigationTeaser", "Page_Live"."ShowCTA", CASE
WHEN "Page_Localised_en_US"."ID" IS NOT NULL THEN "Page_Localised_en_US"."HeroBoxTitle"
ELSE "Page_Live"."HeroBoxTitle" END
AS "HeroBoxTitle", CASE
WHEN "Page_Localised_en_US"."ID" IS NOT NULL THEN "Page_Localised_en_US"."HeroBoxExternalLink"
ELSE "Page_Live"."HeroBoxExternalLink" END
AS "HeroBoxExternalLink", CASE
WHEN "Page_Localised_en_US"."ID" IS NOT NULL THEN "Page_Localised_en_US"."HeroBoxContent"
ELSE "Page_Live"."HeroBoxContent" END
AS "HeroBoxContent", "Page_Live"."ShowHeroBox", "Page_Live"."NaviLinkDesktopClickable", "Page_Live"."ElementalAreaID", "Page_Live"."HeroImageID", "Page_Live"."HeroBoxFlagID", "Page_Live"."HeroBoxLinkID", "SiteTree_Live"."ID",
CASE WHEN "SiteTree_Live"."ClassName" IS NOT NULL THEN "SiteTree_Live"."ClassName"
ELSE 'SilverStripe\\CMS\\Model\\SiteTree' END AS "RecordClassName", 'en_US' AS "Locale", CASE WHEN "Page_Localised_en_US"."ID" IS NOT NULL THEN 'en_US'
ELSE NULL END AS "SourceLocale", "SiteTree_Live"."Sort"
FROM "SiteTree_Live" LEFT JOIN "Page_Live" ON "Page_Live"."ID" = "SiteTree_Live"."ID" LEFT JOIN "SiteTree_Localised_Live" AS "SiteTree_Localised_en_US" ON "SiteTree_Live"."ID" = "SiteTree_Localised_en_US"."RecordID" AND "SiteTree_Localised_en_US"."Locale" = ? LEFT JOIN "Page_Localised_Live" AS "Page_Localised_en_US" ON "Page_Live"."ID" = "Page_Localised_en_US"."RecordID" AND "Page_Localised_en_US"."Locale" = ?
WHERE ("SiteTree_Live"."ID" = ?)
AND ("SiteTree_Live"."ClassName" IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?))
AND (("SiteTree_Localised_en_US"."ID" IS NOT NULL))
ORDER BY "SiteTree_Live"."Sort" ASC
LIMIT 1
0.001s
0053: SELECT DISTINCT "SiteTree_Live"."DeepLTranslated", "SiteTree_Live"."OriginalID", "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", CASE
WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."SiteTreeLinkerHelper"
ELSE "SiteTree_Live"."SiteTreeLinkerHelper" END
AS "SiteTreeLinkerHelper", "SiteTree_Live"."CanViewType", "SiteTree_Live"."CanEditType", "SiteTree_Live"."Version", CASE
WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."URLSegment"
ELSE "SiteTree_Live"."URLSegment" END
AS "URLSegment", CASE
WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."Title"
ELSE "SiteTree_Live"."Title" END
AS "Title", CASE
WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."MenuTitle"
ELSE "SiteTree_Live"."MenuTitle" END
AS "MenuTitle", CASE
WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."Content"
ELSE "SiteTree_Live"."Content" END
AS "Content", CASE
WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."MetaDescription"
ELSE "SiteTree_Live"."MetaDescription" END
AS "MetaDescription", "SiteTree_Live"."ExtraMeta", "SiteTree_Live"."ShowInMenus", "SiteTree_Live"."ShowInSearch", "SiteTree_Live"."Sort", "SiteTree_Live"."HasBrokenFile", "SiteTree_Live"."HasBrokenLink", CASE
WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."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", 'en_US' AS "Locale", CASE WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN 'en_US'
ELSE NULL END AS "SourceLocale"
FROM "SiteTree_Live" LEFT JOIN "SiteTree_Localised_Live" AS "SiteTree_Localised_en_US" ON "SiteTree_Live"."ID" = "SiteTree_Localised_en_US"."RecordID" AND "SiteTree_Localised_en_US"."Locale" = ?
WHERE ("SiteTree_Live"."ParentID" <> "SiteTree_Live"."ID")
AND ("SiteTree_Live"."ParentID" = ?)
AND ("SiteTree_Live"."ShowInMenus" = ?)
AND (("SiteTree_Localised_en_US"."ID" IS NOT NULL))
ORDER BY "SiteTree_Live"."Sort" ASC
0.0022s
0054: SELECT DISTINCT "SiteTree_Live"."DeepLTranslated", "SiteTree_Live"."OriginalID", "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", CASE
WHEN "Page_Localised_en_US"."ID" IS NOT NULL THEN "Page_Localised_en_US"."Subtitle"
ELSE "Page_Live"."Subtitle" END
AS "Subtitle", "Page_Live"."ShowInFooter", "Page_Live"."ShowInLegalMenu", CASE
WHEN "Page_Localised_en_US"."ID" IS NOT NULL THEN "Page_Localised_en_US"."MetaTitle"
ELSE "Page_Live"."MetaTitle" END
AS "MetaTitle", "Page_Live"."BlockFromSearchEngines", CASE
WHEN "Page_Localised_en_US"."ID" IS NOT NULL THEN "Page_Localised_en_US"."NavigationTeaser"
ELSE "Page_Live"."NavigationTeaser" END
AS "NavigationTeaser", "Page_Live"."ShowCTA", CASE
WHEN "Page_Localised_en_US"."ID" IS NOT NULL THEN "Page_Localised_en_US"."HeroBoxTitle"
ELSE "Page_Live"."HeroBoxTitle" END
AS "HeroBoxTitle", CASE
WHEN "Page_Localised_en_US"."ID" IS NOT NULL THEN "Page_Localised_en_US"."HeroBoxExternalLink"
ELSE "Page_Live"."HeroBoxExternalLink" END
AS "HeroBoxExternalLink", CASE
WHEN "Page_Localised_en_US"."ID" IS NOT NULL THEN "Page_Localised_en_US"."HeroBoxContent"
ELSE "Page_Live"."HeroBoxContent" END
AS "HeroBoxContent", "Page_Live"."ShowHeroBox", "Page_Live"."NaviLinkDesktopClickable", "Page_Live"."ElementalAreaID", "Page_Live"."HeroImageID", "Page_Live"."HeroBoxFlagID", "Page_Live"."HeroBoxLinkID", "SiteTree_Live"."ID",
CASE WHEN "SiteTree_Live"."ClassName" IS NOT NULL THEN "SiteTree_Live"."ClassName"
ELSE 'SilverStripe\\CMS\\Model\\SiteTree' END AS "RecordClassName", 'en_US' AS "Locale", CASE WHEN "Page_Localised_en_US"."ID" IS NOT NULL THEN 'en_US'
ELSE NULL END AS "SourceLocale", "SiteTree_Live"."Sort"
FROM "SiteTree_Live" LEFT JOIN "Page_Live" ON "Page_Live"."ID" = "SiteTree_Live"."ID" LEFT JOIN "SiteTree_Localised_Live" AS "SiteTree_Localised_en_US" ON "SiteTree_Live"."ID" = "SiteTree_Localised_en_US"."RecordID" AND "SiteTree_Localised_en_US"."Locale" = ? LEFT JOIN "Page_Localised_Live" AS "Page_Localised_en_US" ON "Page_Live"."ID" = "Page_Localised_en_US"."RecordID" AND "Page_Localised_en_US"."Locale" = ?
WHERE ("SiteTree_Live"."ID" = ?)
AND ("SiteTree_Live"."ClassName" IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?))
AND (("SiteTree_Localised_en_US"."ID" IS NOT NULL))
ORDER BY "SiteTree_Live"."Sort" ASC
LIMIT 1
0.001s
0055: SELECT DISTINCT "SiteTree_Live"."DeepLTranslated", "SiteTree_Live"."OriginalID", "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", CASE
WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."SiteTreeLinkerHelper"
ELSE "SiteTree_Live"."SiteTreeLinkerHelper" END
AS "SiteTreeLinkerHelper", "SiteTree_Live"."CanViewType", "SiteTree_Live"."CanEditType", "SiteTree_Live"."Version", CASE
WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."URLSegment"
ELSE "SiteTree_Live"."URLSegment" END
AS "URLSegment", CASE
WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."Title"
ELSE "SiteTree_Live"."Title" END
AS "Title", CASE
WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."MenuTitle"
ELSE "SiteTree_Live"."MenuTitle" END
AS "MenuTitle", CASE
WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."Content"
ELSE "SiteTree_Live"."Content" END
AS "Content", CASE
WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."MetaDescription"
ELSE "SiteTree_Live"."MetaDescription" END
AS "MetaDescription", "SiteTree_Live"."ExtraMeta", "SiteTree_Live"."ShowInMenus", "SiteTree_Live"."ShowInSearch", "SiteTree_Live"."Sort", "SiteTree_Live"."HasBrokenFile", "SiteTree_Live"."HasBrokenLink", CASE
WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."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", 'en_US' AS "Locale", CASE WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN 'en_US'
ELSE NULL END AS "SourceLocale"
FROM "SiteTree_Live" LEFT JOIN "SiteTree_Localised_Live" AS "SiteTree_Localised_en_US" ON "SiteTree_Live"."ID" = "SiteTree_Localised_en_US"."RecordID" AND "SiteTree_Localised_en_US"."Locale" = ?
WHERE ("SiteTree_Live"."ParentID" <> "SiteTree_Live"."ID")
AND ("SiteTree_Live"."ParentID" = ?)
AND ("SiteTree_Live"."ShowInMenus" = ?)
AND (("SiteTree_Localised_en_US"."ID" IS NOT NULL))
ORDER BY "SiteTree_Live"."Sort" ASC
0.0022s
0056: SELECT DISTINCT "SiteTree_Live"."DeepLTranslated", "SiteTree_Live"."OriginalID", "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", CASE
WHEN "Page_Localised_en_US"."ID" IS NOT NULL THEN "Page_Localised_en_US"."Subtitle"
ELSE "Page_Live"."Subtitle" END
AS "Subtitle", "Page_Live"."ShowInFooter", "Page_Live"."ShowInLegalMenu", CASE
WHEN "Page_Localised_en_US"."ID" IS NOT NULL THEN "Page_Localised_en_US"."MetaTitle"
ELSE "Page_Live"."MetaTitle" END
AS "MetaTitle", "Page_Live"."BlockFromSearchEngines", CASE
WHEN "Page_Localised_en_US"."ID" IS NOT NULL THEN "Page_Localised_en_US"."NavigationTeaser"
ELSE "Page_Live"."NavigationTeaser" END
AS "NavigationTeaser", "Page_Live"."ShowCTA", CASE
WHEN "Page_Localised_en_US"."ID" IS NOT NULL THEN "Page_Localised_en_US"."HeroBoxTitle"
ELSE "Page_Live"."HeroBoxTitle" END
AS "HeroBoxTitle", CASE
WHEN "Page_Localised_en_US"."ID" IS NOT NULL THEN "Page_Localised_en_US"."HeroBoxExternalLink"
ELSE "Page_Live"."HeroBoxExternalLink" END
AS "HeroBoxExternalLink", CASE
WHEN "Page_Localised_en_US"."ID" IS NOT NULL THEN "Page_Localised_en_US"."HeroBoxContent"
ELSE "Page_Live"."HeroBoxContent" END
AS "HeroBoxContent", "Page_Live"."ShowHeroBox", "Page_Live"."NaviLinkDesktopClickable", "Page_Live"."ElementalAreaID", "Page_Live"."HeroImageID", "Page_Live"."HeroBoxFlagID", "Page_Live"."HeroBoxLinkID", "SiteTree_Live"."ID",
CASE WHEN "SiteTree_Live"."ClassName" IS NOT NULL THEN "SiteTree_Live"."ClassName"
ELSE 'SilverStripe\\CMS\\Model\\SiteTree' END AS "RecordClassName", 'en_US' AS "Locale", CASE WHEN "Page_Localised_en_US"."ID" IS NOT NULL THEN 'en_US'
ELSE NULL END AS "SourceLocale", "SiteTree_Live"."Sort"
FROM "SiteTree_Live" LEFT JOIN "Page_Live" ON "Page_Live"."ID" = "SiteTree_Live"."ID" LEFT JOIN "SiteTree_Localised_Live" AS "SiteTree_Localised_en_US" ON "SiteTree_Live"."ID" = "SiteTree_Localised_en_US"."RecordID" AND "SiteTree_Localised_en_US"."Locale" = ? LEFT JOIN "Page_Localised_Live" AS "Page_Localised_en_US" ON "Page_Live"."ID" = "Page_Localised_en_US"."RecordID" AND "Page_Localised_en_US"."Locale" = ?
WHERE ("SiteTree_Live"."ID" = ?)
AND ("SiteTree_Live"."ClassName" IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?))
AND (("SiteTree_Localised_en_US"."ID" IS NOT NULL))
ORDER BY "SiteTree_Live"."Sort" ASC
LIMIT 1
0.0009s
0057: SELECT DISTINCT "SiteTree_Live"."DeepLTranslated", "SiteTree_Live"."OriginalID", "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", CASE
WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."SiteTreeLinkerHelper"
ELSE "SiteTree_Live"."SiteTreeLinkerHelper" END
AS "SiteTreeLinkerHelper", "SiteTree_Live"."CanViewType", "SiteTree_Live"."CanEditType", "SiteTree_Live"."Version", CASE
WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."URLSegment"
ELSE "SiteTree_Live"."URLSegment" END
AS "URLSegment", CASE
WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."Title"
ELSE "SiteTree_Live"."Title" END
AS "Title", CASE
WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."MenuTitle"
ELSE "SiteTree_Live"."MenuTitle" END
AS "MenuTitle", CASE
WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."Content"
ELSE "SiteTree_Live"."Content" END
AS "Content", CASE
WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."MetaDescription"
ELSE "SiteTree_Live"."MetaDescription" END
AS "MetaDescription", "SiteTree_Live"."ExtraMeta", "SiteTree_Live"."ShowInMenus", "SiteTree_Live"."ShowInSearch", "SiteTree_Live"."Sort", "SiteTree_Live"."HasBrokenFile", "SiteTree_Live"."HasBrokenLink", CASE
WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."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", 'en_US' AS "Locale", CASE WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN 'en_US'
ELSE NULL END AS "SourceLocale"
FROM "SiteTree_Live" LEFT JOIN "SiteTree_Localised_Live" AS "SiteTree_Localised_en_US" ON "SiteTree_Live"."ID" = "SiteTree_Localised_en_US"."RecordID" AND "SiteTree_Localised_en_US"."Locale" = ?
WHERE ("SiteTree_Live"."ParentID" <> "SiteTree_Live"."ID")
AND ("SiteTree_Live"."ParentID" = ?)
AND ("SiteTree_Live"."ShowInMenus" = ?)
AND (("SiteTree_Localised_en_US"."ID" IS NOT NULL))
ORDER BY "SiteTree_Live"."Sort" ASC
0.0024s
0058: SELECT DISTINCT "SiteTree_Live"."DeepLTranslated", "SiteTree_Live"."OriginalID", "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", CASE
WHEN "Page_Localised_en_US"."ID" IS NOT NULL THEN "Page_Localised_en_US"."Subtitle"
ELSE "Page_Live"."Subtitle" END
AS "Subtitle", "Page_Live"."ShowInFooter", "Page_Live"."ShowInLegalMenu", CASE
WHEN "Page_Localised_en_US"."ID" IS NOT NULL THEN "Page_Localised_en_US"."MetaTitle"
ELSE "Page_Live"."MetaTitle" END
AS "MetaTitle", "Page_Live"."BlockFromSearchEngines", CASE
WHEN "Page_Localised_en_US"."ID" IS NOT NULL THEN "Page_Localised_en_US"."NavigationTeaser"
ELSE "Page_Live"."NavigationTeaser" END
AS "NavigationTeaser", "Page_Live"."ShowCTA", CASE
WHEN "Page_Localised_en_US"."ID" IS NOT NULL THEN "Page_Localised_en_US"."HeroBoxTitle"
ELSE "Page_Live"."HeroBoxTitle" END
AS "HeroBoxTitle", CASE
WHEN "Page_Localised_en_US"."ID" IS NOT NULL THEN "Page_Localised_en_US"."HeroBoxExternalLink"
ELSE "Page_Live"."HeroBoxExternalLink" END
AS "HeroBoxExternalLink", CASE
WHEN "Page_Localised_en_US"."ID" IS NOT NULL THEN "Page_Localised_en_US"."HeroBoxContent"
ELSE "Page_Live"."HeroBoxContent" END
AS "HeroBoxContent", "Page_Live"."ShowHeroBox", "Page_Live"."NaviLinkDesktopClickable", "Page_Live"."ElementalAreaID", "Page_Live"."HeroImageID", "Page_Live"."HeroBoxFlagID", "Page_Live"."HeroBoxLinkID", "SiteTree_Live"."ID",
CASE WHEN "SiteTree_Live"."ClassName" IS NOT NULL THEN "SiteTree_Live"."ClassName"
ELSE 'SilverStripe\\CMS\\Model\\SiteTree' END AS "RecordClassName", 'en_US' AS "Locale", CASE WHEN "Page_Localised_en_US"."ID" IS NOT NULL THEN 'en_US'
ELSE NULL END AS "SourceLocale", "SiteTree_Live"."Sort"
FROM "SiteTree_Live" LEFT JOIN "Page_Live" ON "Page_Live"."ID" = "SiteTree_Live"."ID" LEFT JOIN "SiteTree_Localised_Live" AS "SiteTree_Localised_en_US" ON "SiteTree_Live"."ID" = "SiteTree_Localised_en_US"."RecordID" AND "SiteTree_Localised_en_US"."Locale" = ? LEFT JOIN "Page_Localised_Live" AS "Page_Localised_en_US" ON "Page_Live"."ID" = "Page_Localised_en_US"."RecordID" AND "Page_Localised_en_US"."Locale" = ?
WHERE ("SiteTree_Live"."ID" = ?)
AND ("SiteTree_Live"."ClassName" IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?))
AND (("SiteTree_Localised_en_US"."ID" IS NOT NULL))
ORDER BY "SiteTree_Live"."Sort" ASC
LIMIT 1
0.0011s
0059: SELECT DISTINCT "SiteTree_Live"."DeepLTranslated", "SiteTree_Live"."OriginalID", "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", CASE
WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."SiteTreeLinkerHelper"
ELSE "SiteTree_Live"."SiteTreeLinkerHelper" END
AS "SiteTreeLinkerHelper", "SiteTree_Live"."CanViewType", "SiteTree_Live"."CanEditType", "SiteTree_Live"."Version", CASE
WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."URLSegment"
ELSE "SiteTree_Live"."URLSegment" END
AS "URLSegment", CASE
WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."Title"
ELSE "SiteTree_Live"."Title" END
AS "Title", CASE
WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."MenuTitle"
ELSE "SiteTree_Live"."MenuTitle" END
AS "MenuTitle", CASE
WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."Content"
ELSE "SiteTree_Live"."Content" END
AS "Content", CASE
WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."MetaDescription"
ELSE "SiteTree_Live"."MetaDescription" END
AS "MetaDescription", "SiteTree_Live"."ExtraMeta", "SiteTree_Live"."ShowInMenus", "SiteTree_Live"."ShowInSearch", "SiteTree_Live"."Sort", "SiteTree_Live"."HasBrokenFile", "SiteTree_Live"."HasBrokenLink", CASE
WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."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", 'en_US' AS "Locale", CASE WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN 'en_US'
ELSE NULL END AS "SourceLocale"
FROM "SiteTree_Live" LEFT JOIN "SiteTree_Localised_Live" AS "SiteTree_Localised_en_US" ON "SiteTree_Live"."ID" = "SiteTree_Localised_en_US"."RecordID" AND "SiteTree_Localised_en_US"."Locale" = ?
WHERE ("SiteTree_Live"."ParentID" <> "SiteTree_Live"."ID")
AND ("SiteTree_Live"."ParentID" = ?)
AND ("SiteTree_Live"."ShowInMenus" = ?)
AND (("SiteTree_Localised_en_US"."ID" IS NOT NULL))
ORDER BY "SiteTree_Live"."Sort" ASC
0.003s
0060: SELECT DISTINCT "SiteTree_Live"."DeepLTranslated", "SiteTree_Live"."OriginalID", "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", CASE
WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."SiteTreeLinkerHelper"
ELSE "SiteTree_Live"."SiteTreeLinkerHelper" END
AS "SiteTreeLinkerHelper", "SiteTree_Live"."CanViewType", "SiteTree_Live"."CanEditType", "SiteTree_Live"."Version", CASE
WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."URLSegment"
ELSE "SiteTree_Live"."URLSegment" END
AS "URLSegment", CASE
WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."Title"
ELSE "SiteTree_Live"."Title" END
AS "Title", CASE
WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."MenuTitle"
ELSE "SiteTree_Live"."MenuTitle" END
AS "MenuTitle", CASE
WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."Content"
ELSE "SiteTree_Live"."Content" END
AS "Content", CASE
WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."MetaDescription"
ELSE "SiteTree_Live"."MetaDescription" END
AS "MetaDescription", "SiteTree_Live"."ExtraMeta", "SiteTree_Live"."ShowInMenus", "SiteTree_Live"."ShowInSearch", "SiteTree_Live"."Sort", "SiteTree_Live"."HasBrokenFile", "SiteTree_Live"."HasBrokenLink", CASE
WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."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", 'en_US' AS "Locale", CASE WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN 'en_US'
ELSE NULL END AS "SourceLocale"
FROM "SiteTree_Live" LEFT JOIN "SiteTree_Localised_Live" AS "SiteTree_Localised_en_US" ON "SiteTree_Live"."ID" = "SiteTree_Localised_en_US"."RecordID" AND "SiteTree_Localised_en_US"."Locale" = ?
WHERE ("SiteTree_Live"."ID" = ?)
AND (("SiteTree_Localised_en_US"."ID" IS NOT NULL))
ORDER BY "SiteTree_Live"."Sort" ASC
LIMIT 1
0.0009s
0061: SELECT DISTINCT "SiteTree_Live"."DeepLTranslated", "SiteTree_Live"."OriginalID", "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", CASE
WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."SiteTreeLinkerHelper"
ELSE "SiteTree_Live"."SiteTreeLinkerHelper" END
AS "SiteTreeLinkerHelper", "SiteTree_Live"."CanViewType", "SiteTree_Live"."CanEditType", "SiteTree_Live"."Version", CASE
WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."URLSegment"
ELSE "SiteTree_Live"."URLSegment" END
AS "URLSegment", CASE
WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."Title"
ELSE "SiteTree_Live"."Title" END
AS "Title", CASE
WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."MenuTitle"
ELSE "SiteTree_Live"."MenuTitle" END
AS "MenuTitle", CASE
WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."Content"
ELSE "SiteTree_Live"."Content" END
AS "Content", CASE
WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."MetaDescription"
ELSE "SiteTree_Live"."MetaDescription" END
AS "MetaDescription", "SiteTree_Live"."ExtraMeta", "SiteTree_Live"."ShowInMenus", "SiteTree_Live"."ShowInSearch", "SiteTree_Live"."Sort", "SiteTree_Live"."HasBrokenFile", "SiteTree_Live"."HasBrokenLink", CASE
WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."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", 'en_US' AS "Locale", CASE WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN 'en_US'
ELSE NULL END AS "SourceLocale"
FROM "SiteTree_Live" LEFT JOIN "SiteTree_Localised_Live" AS "SiteTree_Localised_en_US" ON "SiteTree_Live"."ID" = "SiteTree_Localised_en_US"."RecordID" AND "SiteTree_Localised_en_US"."Locale" = ?
WHERE ("SiteTree_Live"."ID" = ?)
AND (("SiteTree_Localised_en_US"."ID" IS NOT NULL))
ORDER BY "SiteTree_Live"."Sort" ASC
LIMIT 1
0.0008s
0062: SELECT DISTINCT "SiteTree_Live"."DeepLTranslated", "SiteTree_Live"."OriginalID", "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", CASE
WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."SiteTreeLinkerHelper"
ELSE "SiteTree_Live"."SiteTreeLinkerHelper" END
AS "SiteTreeLinkerHelper", "SiteTree_Live"."CanViewType", "SiteTree_Live"."CanEditType", "SiteTree_Live"."Version", CASE
WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."URLSegment"
ELSE "SiteTree_Live"."URLSegment" END
AS "URLSegment", CASE
WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."Title"
ELSE "SiteTree_Live"."Title" END
AS "Title", CASE
WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."MenuTitle"
ELSE "SiteTree_Live"."MenuTitle" END
AS "MenuTitle", CASE
WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."Content"
ELSE "SiteTree_Live"."Content" END
AS "Content", CASE
WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."MetaDescription"
ELSE "SiteTree_Live"."MetaDescription" END
AS "MetaDescription", "SiteTree_Live"."ExtraMeta", "SiteTree_Live"."ShowInMenus", "SiteTree_Live"."ShowInSearch", "SiteTree_Live"."Sort", "SiteTree_Live"."HasBrokenFile", "SiteTree_Live"."HasBrokenLink", CASE
WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."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", 'en_US' AS "Locale", CASE WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN 'en_US'
ELSE NULL END AS "SourceLocale"
FROM "SiteTree_Live" LEFT JOIN "SiteTree_Localised_Live" AS "SiteTree_Localised_en_US" ON "SiteTree_Live"."ID" = "SiteTree_Localised_en_US"."RecordID" AND "SiteTree_Localised_en_US"."Locale" = ?
WHERE ("SiteTree_Live"."ID" = ?)
AND (("SiteTree_Localised_en_US"."ID" IS NOT NULL))
ORDER BY "SiteTree_Live"."Sort" ASC
LIMIT 1
0.0009s
0063: SELECT DISTINCT "SiteTree_Live"."DeepLTranslated", "SiteTree_Live"."OriginalID", "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", CASE
WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."SiteTreeLinkerHelper"
ELSE "SiteTree_Live"."SiteTreeLinkerHelper" END
AS "SiteTreeLinkerHelper", "SiteTree_Live"."CanViewType", "SiteTree_Live"."CanEditType", "SiteTree_Live"."Version", CASE
WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."URLSegment"
ELSE "SiteTree_Live"."URLSegment" END
AS "URLSegment", CASE
WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."Title"
ELSE "SiteTree_Live"."Title" END
AS "Title", CASE
WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."MenuTitle"
ELSE "SiteTree_Live"."MenuTitle" END
AS "MenuTitle", CASE
WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."Content"
ELSE "SiteTree_Live"."Content" END
AS "Content", CASE
WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."MetaDescription"
ELSE "SiteTree_Live"."MetaDescription" END
AS "MetaDescription", "SiteTree_Live"."ExtraMeta", "SiteTree_Live"."ShowInMenus", "SiteTree_Live"."ShowInSearch", "SiteTree_Live"."Sort", "SiteTree_Live"."HasBrokenFile", "SiteTree_Live"."HasBrokenLink", CASE
WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."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", 'en_US' AS "Locale", CASE WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN 'en_US'
ELSE NULL END AS "SourceLocale"
FROM "SiteTree_Live" LEFT JOIN "SiteTree_Localised_Live" AS "SiteTree_Localised_en_US" ON "SiteTree_Live"."ID" = "SiteTree_Localised_en_US"."RecordID" AND "SiteTree_Localised_en_US"."Locale" = ?
WHERE ("SiteTree_Live"."ID" = ?)
AND (("SiteTree_Localised_en_US"."ID" IS NOT NULL))
ORDER BY "SiteTree_Live"."Sort" ASC
LIMIT 1
0.0009s
0064: SELECT DISTINCT "SiteTree_Live"."DeepLTranslated", "SiteTree_Live"."OriginalID", "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", CASE
WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."SiteTreeLinkerHelper"
ELSE "SiteTree_Live"."SiteTreeLinkerHelper" END
AS "SiteTreeLinkerHelper", "SiteTree_Live"."CanViewType", "SiteTree_Live"."CanEditType", "SiteTree_Live"."Version", CASE
WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."URLSegment"
ELSE "SiteTree_Live"."URLSegment" END
AS "URLSegment", CASE
WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."Title"
ELSE "SiteTree_Live"."Title" END
AS "Title", CASE
WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."MenuTitle"
ELSE "SiteTree_Live"."MenuTitle" END
AS "MenuTitle", CASE
WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."Content"
ELSE "SiteTree_Live"."Content" END
AS "Content", CASE
WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."MetaDescription"
ELSE "SiteTree_Live"."MetaDescription" END
AS "MetaDescription", "SiteTree_Live"."ExtraMeta", "SiteTree_Live"."ShowInMenus", "SiteTree_Live"."ShowInSearch", "SiteTree_Live"."Sort", "SiteTree_Live"."HasBrokenFile", "SiteTree_Live"."HasBrokenLink", CASE
WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."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", 'en_US' AS "Locale", CASE WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN 'en_US'
ELSE NULL END AS "SourceLocale"
FROM "SiteTree_Live" LEFT JOIN "SiteTree_Localised_Live" AS "SiteTree_Localised_en_US" ON "SiteTree_Live"."ID" = "SiteTree_Localised_en_US"."RecordID" AND "SiteTree_Localised_en_US"."Locale" = ?
WHERE ("SiteTree_Live"."ID" = ?)
AND (("SiteTree_Localised_en_US"."ID" IS NOT NULL))
ORDER BY "SiteTree_Live"."Sort" ASC
LIMIT 1
0.0008s
0065: SELECT DISTINCT "SiteTree_Live"."DeepLTranslated", "SiteTree_Live"."OriginalID", "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", CASE
WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."SiteTreeLinkerHelper"
ELSE "SiteTree_Live"."SiteTreeLinkerHelper" END
AS "SiteTreeLinkerHelper", "SiteTree_Live"."CanViewType", "SiteTree_Live"."CanEditType", "SiteTree_Live"."Version", CASE
WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."URLSegment"
ELSE "SiteTree_Live"."URLSegment" END
AS "URLSegment", CASE
WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."Title"
ELSE "SiteTree_Live"."Title" END
AS "Title", CASE
WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."MenuTitle"
ELSE "SiteTree_Live"."MenuTitle" END
AS "MenuTitle", CASE
WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."Content"
ELSE "SiteTree_Live"."Content" END
AS "Content", CASE
WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."MetaDescription"
ELSE "SiteTree_Live"."MetaDescription" END
AS "MetaDescription", "SiteTree_Live"."ExtraMeta", "SiteTree_Live"."ShowInMenus", "SiteTree_Live"."ShowInSearch", "SiteTree_Live"."Sort", "SiteTree_Live"."HasBrokenFile", "SiteTree_Live"."HasBrokenLink", CASE
WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."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", 'en_US' AS "Locale", CASE WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN 'en_US'
ELSE NULL END AS "SourceLocale"
FROM "SiteTree_Live" LEFT JOIN "SiteTree_Localised_Live" AS "SiteTree_Localised_en_US" ON "SiteTree_Live"."ID" = "SiteTree_Localised_en_US"."RecordID" AND "SiteTree_Localised_en_US"."Locale" = ?
WHERE ("SiteTree_Live"."ID" = ?)
AND (("SiteTree_Localised_en_US"."ID" IS NOT NULL))
ORDER BY "SiteTree_Live"."Sort" ASC
LIMIT 1
0.0008s
0066: SELECT DISTINCT "SiteTree_Live"."DeepLTranslated", "SiteTree_Live"."OriginalID", "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", CASE
WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."SiteTreeLinkerHelper"
ELSE "SiteTree_Live"."SiteTreeLinkerHelper" END
AS "SiteTreeLinkerHelper", "SiteTree_Live"."CanViewType", "SiteTree_Live"."CanEditType", "SiteTree_Live"."Version", CASE
WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."URLSegment"
ELSE "SiteTree_Live"."URLSegment" END
AS "URLSegment", CASE
WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."Title"
ELSE "SiteTree_Live"."Title" END
AS "Title", CASE
WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."MenuTitle"
ELSE "SiteTree_Live"."MenuTitle" END
AS "MenuTitle", CASE
WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."Content"
ELSE "SiteTree_Live"."Content" END
AS "Content", CASE
WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."MetaDescription"
ELSE "SiteTree_Live"."MetaDescription" END
AS "MetaDescription", "SiteTree_Live"."ExtraMeta", "SiteTree_Live"."ShowInMenus", "SiteTree_Live"."ShowInSearch", "SiteTree_Live"."Sort", "SiteTree_Live"."HasBrokenFile", "SiteTree_Live"."HasBrokenLink", CASE
WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."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", 'en_US' AS "Locale", CASE WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN 'en_US'
ELSE NULL END AS "SourceLocale"
FROM "SiteTree_Live" LEFT JOIN "SiteTree_Localised_Live" AS "SiteTree_Localised_en_US" ON "SiteTree_Live"."ID" = "SiteTree_Localised_en_US"."RecordID" AND "SiteTree_Localised_en_US"."Locale" = ?
WHERE ("SiteTree_Live"."ID" = ?)
AND (("SiteTree_Localised_en_US"."ID" IS NOT NULL))
ORDER BY "SiteTree_Live"."Sort" ASC
LIMIT 1
0.0008s
0067: SELECT DISTINCT "SiteTree_Live"."DeepLTranslated", "SiteTree_Live"."OriginalID", "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", CASE
WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."SiteTreeLinkerHelper"
ELSE "SiteTree_Live"."SiteTreeLinkerHelper" END
AS "SiteTreeLinkerHelper", "SiteTree_Live"."CanViewType", "SiteTree_Live"."CanEditType", "SiteTree_Live"."Version", CASE
WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."URLSegment"
ELSE "SiteTree_Live"."URLSegment" END
AS "URLSegment", CASE
WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."Title"
ELSE "SiteTree_Live"."Title" END
AS "Title", CASE
WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."MenuTitle"
ELSE "SiteTree_Live"."MenuTitle" END
AS "MenuTitle", CASE
WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."Content"
ELSE "SiteTree_Live"."Content" END
AS "Content", CASE
WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."MetaDescription"
ELSE "SiteTree_Live"."MetaDescription" END
AS "MetaDescription", "SiteTree_Live"."ExtraMeta", "SiteTree_Live"."ShowInMenus", "SiteTree_Live"."ShowInSearch", "SiteTree_Live"."Sort", "SiteTree_Live"."HasBrokenFile", "SiteTree_Live"."HasBrokenLink", CASE
WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."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", 'en_US' AS "Locale", CASE WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN 'en_US'
ELSE NULL END AS "SourceLocale"
FROM "SiteTree_Live" LEFT JOIN "SiteTree_Localised_Live" AS "SiteTree_Localised_en_US" ON "SiteTree_Live"."ID" = "SiteTree_Localised_en_US"."RecordID" AND "SiteTree_Localised_en_US"."Locale" = ?
WHERE ("SiteTree_Live"."ID" = ?)
AND (("SiteTree_Localised_en_US"."ID" IS NOT NULL))
ORDER BY "SiteTree_Live"."Sort" ASC
LIMIT 1
0.0009s
0068: SELECT DISTINCT "SiteTree_Live"."DeepLTranslated", "SiteTree_Live"."OriginalID", "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", CASE
WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."SiteTreeLinkerHelper"
ELSE "SiteTree_Live"."SiteTreeLinkerHelper" END
AS "SiteTreeLinkerHelper", "SiteTree_Live"."CanViewType", "SiteTree_Live"."CanEditType", "SiteTree_Live"."Version", CASE
WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."URLSegment"
ELSE "SiteTree_Live"."URLSegment" END
AS "URLSegment", CASE
WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."Title"
ELSE "SiteTree_Live"."Title" END
AS "Title", CASE
WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."MenuTitle"
ELSE "SiteTree_Live"."MenuTitle" END
AS "MenuTitle", CASE
WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."Content"
ELSE "SiteTree_Live"."Content" END
AS "Content", CASE
WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."MetaDescription"
ELSE "SiteTree_Live"."MetaDescription" END
AS "MetaDescription", "SiteTree_Live"."ExtraMeta", "SiteTree_Live"."ShowInMenus", "SiteTree_Live"."ShowInSearch", "SiteTree_Live"."Sort", "SiteTree_Live"."HasBrokenFile", "SiteTree_Live"."HasBrokenLink", CASE
WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."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", 'en_US' AS "Locale", CASE WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN 'en_US'
ELSE NULL END AS "SourceLocale"
FROM "SiteTree_Live" LEFT JOIN "SiteTree_Localised_Live" AS "SiteTree_Localised_en_US" ON "SiteTree_Live"."ID" = "SiteTree_Localised_en_US"."RecordID" AND "SiteTree_Localised_en_US"."Locale" = ?
WHERE ("SiteTree_Live"."ParentID" <> "SiteTree_Live"."ID")
AND ("SiteTree_Live"."ParentID" = ?)
AND ("SiteTree_Live"."ShowInMenus" = ?)
AND (("SiteTree_Localised_en_US"."ID" IS NOT NULL))
ORDER BY "SiteTree_Live"."Sort" ASC
0.0042s
0069: SELECT DISTINCT "SiteTree_Live"."DeepLTranslated", "SiteTree_Live"."OriginalID", "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", CASE
WHEN "Page_Localised_en_US"."ID" IS NOT NULL THEN "Page_Localised_en_US"."Subtitle"
ELSE "Page_Live"."Subtitle" END
AS "Subtitle", "Page_Live"."ShowInFooter", "Page_Live"."ShowInLegalMenu", CASE
WHEN "Page_Localised_en_US"."ID" IS NOT NULL THEN "Page_Localised_en_US"."MetaTitle"
ELSE "Page_Live"."MetaTitle" END
AS "MetaTitle", "Page_Live"."BlockFromSearchEngines", CASE
WHEN "Page_Localised_en_US"."ID" IS NOT NULL THEN "Page_Localised_en_US"."NavigationTeaser"
ELSE "Page_Live"."NavigationTeaser" END
AS "NavigationTeaser", "Page_Live"."ShowCTA", CASE
WHEN "Page_Localised_en_US"."ID" IS NOT NULL THEN "Page_Localised_en_US"."HeroBoxTitle"
ELSE "Page_Live"."HeroBoxTitle" END
AS "HeroBoxTitle", CASE
WHEN "Page_Localised_en_US"."ID" IS NOT NULL THEN "Page_Localised_en_US"."HeroBoxExternalLink"
ELSE "Page_Live"."HeroBoxExternalLink" END
AS "HeroBoxExternalLink", CASE
WHEN "Page_Localised_en_US"."ID" IS NOT NULL THEN "Page_Localised_en_US"."HeroBoxContent"
ELSE "Page_Live"."HeroBoxContent" END
AS "HeroBoxContent", "Page_Live"."ShowHeroBox", "Page_Live"."NaviLinkDesktopClickable", "Page_Live"."ElementalAreaID", "Page_Live"."HeroImageID", "Page_Live"."HeroBoxFlagID", "Page_Live"."HeroBoxLinkID", "SiteTree_Live"."ID",
CASE WHEN "SiteTree_Live"."ClassName" IS NOT NULL THEN "SiteTree_Live"."ClassName"
ELSE 'SilverStripe\\CMS\\Model\\SiteTree' END AS "RecordClassName", 'en_US' AS "Locale", CASE WHEN "Page_Localised_en_US"."ID" IS NOT NULL THEN 'en_US'
ELSE NULL END AS "SourceLocale", "SiteTree_Live"."Sort"
FROM "SiteTree_Live" LEFT JOIN "Page_Live" ON "Page_Live"."ID" = "SiteTree_Live"."ID" LEFT JOIN "SiteTree_Localised_Live" AS "SiteTree_Localised_en_US" ON "SiteTree_Live"."ID" = "SiteTree_Localised_en_US"."RecordID" AND "SiteTree_Localised_en_US"."Locale" = ? LEFT JOIN "Page_Localised_Live" AS "Page_Localised_en_US" ON "Page_Live"."ID" = "Page_Localised_en_US"."RecordID" AND "Page_Localised_en_US"."Locale" = ?
WHERE ("SiteTree_Live"."ID" = ?)
AND ("SiteTree_Live"."ClassName" IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?))
AND (("SiteTree_Localised_en_US"."ID" IS NOT NULL))
ORDER BY "SiteTree_Live"."Sort" ASC
LIMIT 1
0.0011s
0070: SELECT DISTINCT "SiteTree_Live"."DeepLTranslated", "SiteTree_Live"."OriginalID", "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", CASE
WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."SiteTreeLinkerHelper"
ELSE "SiteTree_Live"."SiteTreeLinkerHelper" END
AS "SiteTreeLinkerHelper", "SiteTree_Live"."CanViewType", "SiteTree_Live"."CanEditType", "SiteTree_Live"."Version", CASE
WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."URLSegment"
ELSE "SiteTree_Live"."URLSegment" END
AS "URLSegment", CASE
WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."Title"
ELSE "SiteTree_Live"."Title" END
AS "Title", CASE
WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."MenuTitle"
ELSE "SiteTree_Live"."MenuTitle" END
AS "MenuTitle", CASE
WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."Content"
ELSE "SiteTree_Live"."Content" END
AS "Content", CASE
WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."MetaDescription"
ELSE "SiteTree_Live"."MetaDescription" END
AS "MetaDescription", "SiteTree_Live"."ExtraMeta", "SiteTree_Live"."ShowInMenus", "SiteTree_Live"."ShowInSearch", "SiteTree_Live"."Sort", "SiteTree_Live"."HasBrokenFile", "SiteTree_Live"."HasBrokenLink", CASE
WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."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", 'en_US' AS "Locale", CASE WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN 'en_US'
ELSE NULL END AS "SourceLocale"
FROM "SiteTree_Live" LEFT JOIN "SiteTree_Localised_Live" AS "SiteTree_Localised_en_US" ON "SiteTree_Live"."ID" = "SiteTree_Localised_en_US"."RecordID" AND "SiteTree_Localised_en_US"."Locale" = ?
WHERE ("SiteTree_Live"."ParentID" <> "SiteTree_Live"."ID")
AND ("SiteTree_Live"."ParentID" = ?)
AND ("SiteTree_Live"."ShowInMenus" = ?)
AND (("SiteTree_Localised_en_US"."ID" IS NOT NULL))
ORDER BY "SiteTree_Live"."Sort" ASC
0.0023s
0071: SELECT DISTINCT "SiteTree_Live"."DeepLTranslated", "SiteTree_Live"."OriginalID", "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", CASE
WHEN "Page_Localised_en_US"."ID" IS NOT NULL THEN "Page_Localised_en_US"."Subtitle"
ELSE "Page_Live"."Subtitle" END
AS "Subtitle", "Page_Live"."ShowInFooter", "Page_Live"."ShowInLegalMenu", CASE
WHEN "Page_Localised_en_US"."ID" IS NOT NULL THEN "Page_Localised_en_US"."MetaTitle"
ELSE "Page_Live"."MetaTitle" END
AS "MetaTitle", "Page_Live"."BlockFromSearchEngines", CASE
WHEN "Page_Localised_en_US"."ID" IS NOT NULL THEN "Page_Localised_en_US"."NavigationTeaser"
ELSE "Page_Live"."NavigationTeaser" END
AS "NavigationTeaser", "Page_Live"."ShowCTA", CASE
WHEN "Page_Localised_en_US"."ID" IS NOT NULL THEN "Page_Localised_en_US"."HeroBoxTitle"
ELSE "Page_Live"."HeroBoxTitle" END
AS "HeroBoxTitle", CASE
WHEN "Page_Localised_en_US"."ID" IS NOT NULL THEN "Page_Localised_en_US"."HeroBoxExternalLink"
ELSE "Page_Live"."HeroBoxExternalLink" END
AS "HeroBoxExternalLink", CASE
WHEN "Page_Localised_en_US"."ID" IS NOT NULL THEN "Page_Localised_en_US"."HeroBoxContent"
ELSE "Page_Live"."HeroBoxContent" END
AS "HeroBoxContent", "Page_Live"."ShowHeroBox", "Page_Live"."NaviLinkDesktopClickable", "Page_Live"."ElementalAreaID", "Page_Live"."HeroImageID", "Page_Live"."HeroBoxFlagID", "Page_Live"."HeroBoxLinkID", "SiteTree_Live"."ID",
CASE WHEN "SiteTree_Live"."ClassName" IS NOT NULL THEN "SiteTree_Live"."ClassName"
ELSE 'SilverStripe\\CMS\\Model\\SiteTree' END AS "RecordClassName", 'en_US' AS "Locale", CASE WHEN "Page_Localised_en_US"."ID" IS NOT NULL THEN 'en_US'
ELSE NULL END AS "SourceLocale", "SiteTree_Live"."Sort"
FROM "SiteTree_Live" LEFT JOIN "Page_Live" ON "Page_Live"."ID" = "SiteTree_Live"."ID" LEFT JOIN "SiteTree_Localised_Live" AS "SiteTree_Localised_en_US" ON "SiteTree_Live"."ID" = "SiteTree_Localised_en_US"."RecordID" AND "SiteTree_Localised_en_US"."Locale" = ? LEFT JOIN "Page_Localised_Live" AS "Page_Localised_en_US" ON "Page_Live"."ID" = "Page_Localised_en_US"."RecordID" AND "Page_Localised_en_US"."Locale" = ?
WHERE ("SiteTree_Live"."ID" = ?)
AND ("SiteTree_Live"."ClassName" IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?))
AND (("SiteTree_Localised_en_US"."ID" IS NOT NULL))
ORDER BY "SiteTree_Live"."Sort" ASC
LIMIT 1
0.001s
0072: SELECT DISTINCT "SiteTree_Live"."DeepLTranslated", "SiteTree_Live"."OriginalID", "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", CASE
WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."SiteTreeLinkerHelper"
ELSE "SiteTree_Live"."SiteTreeLinkerHelper" END
AS "SiteTreeLinkerHelper", "SiteTree_Live"."CanViewType", "SiteTree_Live"."CanEditType", "SiteTree_Live"."Version", CASE
WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."URLSegment"
ELSE "SiteTree_Live"."URLSegment" END
AS "URLSegment", CASE
WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."Title"
ELSE "SiteTree_Live"."Title" END
AS "Title", CASE
WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."MenuTitle"
ELSE "SiteTree_Live"."MenuTitle" END
AS "MenuTitle", CASE
WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."Content"
ELSE "SiteTree_Live"."Content" END
AS "Content", CASE
WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."MetaDescription"
ELSE "SiteTree_Live"."MetaDescription" END
AS "MetaDescription", "SiteTree_Live"."ExtraMeta", "SiteTree_Live"."ShowInMenus", "SiteTree_Live"."ShowInSearch", "SiteTree_Live"."Sort", "SiteTree_Live"."HasBrokenFile", "SiteTree_Live"."HasBrokenLink", CASE
WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."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", 'en_US' AS "Locale", CASE WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN 'en_US'
ELSE NULL END AS "SourceLocale"
FROM "SiteTree_Live" LEFT JOIN "SiteTree_Localised_Live" AS "SiteTree_Localised_en_US" ON "SiteTree_Live"."ID" = "SiteTree_Localised_en_US"."RecordID" AND "SiteTree_Localised_en_US"."Locale" = ?
WHERE ("SiteTree_Live"."ParentID" <> "SiteTree_Live"."ID")
AND ("SiteTree_Live"."ParentID" = ?)
AND ("SiteTree_Live"."ShowInMenus" = ?)
AND (("SiteTree_Localised_en_US"."ID" IS NOT NULL))
ORDER BY "SiteTree_Live"."Sort" ASC
0.0023s
0073: SELECT DISTINCT "SiteTree_Live"."DeepLTranslated", "SiteTree_Live"."OriginalID", "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", CASE
WHEN "Page_Localised_en_US"."ID" IS NOT NULL THEN "Page_Localised_en_US"."Subtitle"
ELSE "Page_Live"."Subtitle" END
AS "Subtitle", "Page_Live"."ShowInFooter", "Page_Live"."ShowInLegalMenu", CASE
WHEN "Page_Localised_en_US"."ID" IS NOT NULL THEN "Page_Localised_en_US"."MetaTitle"
ELSE "Page_Live"."MetaTitle" END
AS "MetaTitle", "Page_Live"."BlockFromSearchEngines", CASE
WHEN "Page_Localised_en_US"."ID" IS NOT NULL THEN "Page_Localised_en_US"."NavigationTeaser"
ELSE "Page_Live"."NavigationTeaser" END
AS "NavigationTeaser", "Page_Live"."ShowCTA", CASE
WHEN "Page_Localised_en_US"."ID" IS NOT NULL THEN "Page_Localised_en_US"."HeroBoxTitle"
ELSE "Page_Live"."HeroBoxTitle" END
AS "HeroBoxTitle", CASE
WHEN "Page_Localised_en_US"."ID" IS NOT NULL THEN "Page_Localised_en_US"."HeroBoxExternalLink"
ELSE "Page_Live"."HeroBoxExternalLink" END
AS "HeroBoxExternalLink", CASE
WHEN "Page_Localised_en_US"."ID" IS NOT NULL THEN "Page_Localised_en_US"."HeroBoxContent"
ELSE "Page_Live"."HeroBoxContent" END
AS "HeroBoxContent", "Page_Live"."ShowHeroBox", "Page_Live"."NaviLinkDesktopClickable", "Page_Live"."ElementalAreaID", "Page_Live"."HeroImageID", "Page_Live"."HeroBoxFlagID", "Page_Live"."HeroBoxLinkID", "SiteTree_Live"."ID",
CASE WHEN "SiteTree_Live"."ClassName" IS NOT NULL THEN "SiteTree_Live"."ClassName"
ELSE 'SilverStripe\\CMS\\Model\\SiteTree' END AS "RecordClassName", 'en_US' AS "Locale", CASE WHEN "Page_Localised_en_US"."ID" IS NOT NULL THEN 'en_US'
ELSE NULL END AS "SourceLocale", "SiteTree_Live"."Sort"
FROM "SiteTree_Live" LEFT JOIN "Page_Live" ON "Page_Live"."ID" = "SiteTree_Live"."ID" LEFT JOIN "SiteTree_Localised_Live" AS "SiteTree_Localised_en_US" ON "SiteTree_Live"."ID" = "SiteTree_Localised_en_US"."RecordID" AND "SiteTree_Localised_en_US"."Locale" = ? LEFT JOIN "Page_Localised_Live" AS "Page_Localised_en_US" ON "Page_Live"."ID" = "Page_Localised_en_US"."RecordID" AND "Page_Localised_en_US"."Locale" = ?
WHERE ("SiteTree_Live"."ID" = ?)
AND ("SiteTree_Live"."ClassName" IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?))
AND (("SiteTree_Localised_en_US"."ID" IS NOT NULL))
ORDER BY "SiteTree_Live"."Sort" ASC
LIMIT 1
0.001s
0074: SELECT DISTINCT "SiteTree_Live"."DeepLTranslated", "SiteTree_Live"."OriginalID", "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", CASE
WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."SiteTreeLinkerHelper"
ELSE "SiteTree_Live"."SiteTreeLinkerHelper" END
AS "SiteTreeLinkerHelper", "SiteTree_Live"."CanViewType", "SiteTree_Live"."CanEditType", "SiteTree_Live"."Version", CASE
WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."URLSegment"
ELSE "SiteTree_Live"."URLSegment" END
AS "URLSegment", CASE
WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."Title"
ELSE "SiteTree_Live"."Title" END
AS "Title", CASE
WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."MenuTitle"
ELSE "SiteTree_Live"."MenuTitle" END
AS "MenuTitle", CASE
WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."Content"
ELSE "SiteTree_Live"."Content" END
AS "Content", CASE
WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."MetaDescription"
ELSE "SiteTree_Live"."MetaDescription" END
AS "MetaDescription", "SiteTree_Live"."ExtraMeta", "SiteTree_Live"."ShowInMenus", "SiteTree_Live"."ShowInSearch", "SiteTree_Live"."Sort", "SiteTree_Live"."HasBrokenFile", "SiteTree_Live"."HasBrokenLink", CASE
WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."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", 'en_US' AS "Locale", CASE WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN 'en_US'
ELSE NULL END AS "SourceLocale"
FROM "SiteTree_Live" LEFT JOIN "SiteTree_Localised_Live" AS "SiteTree_Localised_en_US" ON "SiteTree_Live"."ID" = "SiteTree_Localised_en_US"."RecordID" AND "SiteTree_Localised_en_US"."Locale" = ?
WHERE ("SiteTree_Live"."ParentID" <> "SiteTree_Live"."ID")
AND ("SiteTree_Live"."ParentID" = ?)
AND ("SiteTree_Live"."ShowInMenus" = ?)
AND (("SiteTree_Localised_en_US"."ID" IS NOT NULL))
ORDER BY "SiteTree_Live"."Sort" ASC
0.0026s
0075: SELECT DISTINCT "SiteTree_Live"."DeepLTranslated", "SiteTree_Live"."OriginalID", "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", CASE
WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."SiteTreeLinkerHelper"
ELSE "SiteTree_Live"."SiteTreeLinkerHelper" END
AS "SiteTreeLinkerHelper", "SiteTree_Live"."CanViewType", "SiteTree_Live"."CanEditType", "SiteTree_Live"."Version", CASE
WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."URLSegment"
ELSE "SiteTree_Live"."URLSegment" END
AS "URLSegment", CASE
WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."Title"
ELSE "SiteTree_Live"."Title" END
AS "Title", CASE
WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."MenuTitle"
ELSE "SiteTree_Live"."MenuTitle" END
AS "MenuTitle", CASE
WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."Content"
ELSE "SiteTree_Live"."Content" END
AS "Content", CASE
WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."MetaDescription"
ELSE "SiteTree_Live"."MetaDescription" END
AS "MetaDescription", "SiteTree_Live"."ExtraMeta", "SiteTree_Live"."ShowInMenus", "SiteTree_Live"."ShowInSearch", "SiteTree_Live"."Sort", "SiteTree_Live"."HasBrokenFile", "SiteTree_Live"."HasBrokenLink", CASE
WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."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", 'en_US' AS "Locale", CASE WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN 'en_US'
ELSE NULL END AS "SourceLocale"
FROM "SiteTree_Live" LEFT JOIN "SiteTree_Localised_Live" AS "SiteTree_Localised_en_US" ON "SiteTree_Live"."ID" = "SiteTree_Localised_en_US"."RecordID" AND "SiteTree_Localised_en_US"."Locale" = ?
WHERE ("SiteTree_Live"."ID" = ?)
AND (("SiteTree_Localised_en_US"."ID" IS NOT NULL))
ORDER BY "SiteTree_Live"."Sort" ASC
LIMIT 1
0.0009s
0076: SELECT DISTINCT "SiteTree_Live"."DeepLTranslated", "SiteTree_Live"."OriginalID", "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", CASE
WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."SiteTreeLinkerHelper"
ELSE "SiteTree_Live"."SiteTreeLinkerHelper" END
AS "SiteTreeLinkerHelper", "SiteTree_Live"."CanViewType", "SiteTree_Live"."CanEditType", "SiteTree_Live"."Version", CASE
WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."URLSegment"
ELSE "SiteTree_Live"."URLSegment" END
AS "URLSegment", CASE
WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."Title"
ELSE "SiteTree_Live"."Title" END
AS "Title", CASE
WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."MenuTitle"
ELSE "SiteTree_Live"."MenuTitle" END
AS "MenuTitle", CASE
WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."Content"
ELSE "SiteTree_Live"."Content" END
AS "Content", CASE
WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."MetaDescription"
ELSE "SiteTree_Live"."MetaDescription" END
AS "MetaDescription", "SiteTree_Live"."ExtraMeta", "SiteTree_Live"."ShowInMenus", "SiteTree_Live"."ShowInSearch", "SiteTree_Live"."Sort", "SiteTree_Live"."HasBrokenFile", "SiteTree_Live"."HasBrokenLink", CASE
WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."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", 'en_US' AS "Locale", CASE WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN 'en_US'
ELSE NULL END AS "SourceLocale"
FROM "SiteTree_Live" LEFT JOIN "SiteTree_Localised_Live" AS "SiteTree_Localised_en_US" ON "SiteTree_Live"."ID" = "SiteTree_Localised_en_US"."RecordID" AND "SiteTree_Localised_en_US"."Locale" = ?
WHERE ("SiteTree_Live"."ID" = ?)
AND (("SiteTree_Localised_en_US"."ID" IS NOT NULL))
ORDER BY "SiteTree_Live"."Sort" ASC
LIMIT 1
0.0007s
0077: SELECT DISTINCT "SiteTree_Live"."DeepLTranslated", "SiteTree_Live"."OriginalID", "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", CASE
WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."SiteTreeLinkerHelper"
ELSE "SiteTree_Live"."SiteTreeLinkerHelper" END
AS "SiteTreeLinkerHelper", "SiteTree_Live"."CanViewType", "SiteTree_Live"."CanEditType", "SiteTree_Live"."Version", CASE
WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."URLSegment"
ELSE "SiteTree_Live"."URLSegment" END
AS "URLSegment", CASE
WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."Title"
ELSE "SiteTree_Live"."Title" END
AS "Title", CASE
WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."MenuTitle"
ELSE "SiteTree_Live"."MenuTitle" END
AS "MenuTitle", CASE
WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."Content"
ELSE "SiteTree_Live"."Content" END
AS "Content", CASE
WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."MetaDescription"
ELSE "SiteTree_Live"."MetaDescription" END
AS "MetaDescription", "SiteTree_Live"."ExtraMeta", "SiteTree_Live"."ShowInMenus", "SiteTree_Live"."ShowInSearch", "SiteTree_Live"."Sort", "SiteTree_Live"."HasBrokenFile", "SiteTree_Live"."HasBrokenLink", CASE
WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."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", 'en_US' AS "Locale", CASE WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN 'en_US'
ELSE NULL END AS "SourceLocale"
FROM "SiteTree_Live" LEFT JOIN "SiteTree_Localised_Live" AS "SiteTree_Localised_en_US" ON "SiteTree_Live"."ID" = "SiteTree_Localised_en_US"."RecordID" AND "SiteTree_Localised_en_US"."Locale" = ?
WHERE ("SiteTree_Live"."ParentID" <> "SiteTree_Live"."ID")
AND ("SiteTree_Live"."ParentID" = ?)
AND ("SiteTree_Live"."ShowInMenus" = ?)
AND (("SiteTree_Localised_en_US"."ID" IS NOT NULL))
ORDER BY "SiteTree_Live"."Sort" ASC
0.0027s
0078: SELECT DISTINCT "SiteTree_Live"."DeepLTranslated", "SiteTree_Live"."OriginalID", "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", CASE
WHEN "Page_Localised_en_US"."ID" IS NOT NULL THEN "Page_Localised_en_US"."Subtitle"
ELSE "Page_Live"."Subtitle" END
AS "Subtitle", "Page_Live"."ShowInFooter", "Page_Live"."ShowInLegalMenu", CASE
WHEN "Page_Localised_en_US"."ID" IS NOT NULL THEN "Page_Localised_en_US"."MetaTitle"
ELSE "Page_Live"."MetaTitle" END
AS "MetaTitle", "Page_Live"."BlockFromSearchEngines", CASE
WHEN "Page_Localised_en_US"."ID" IS NOT NULL THEN "Page_Localised_en_US"."NavigationTeaser"
ELSE "Page_Live"."NavigationTeaser" END
AS "NavigationTeaser", "Page_Live"."ShowCTA", CASE
WHEN "Page_Localised_en_US"."ID" IS NOT NULL THEN "Page_Localised_en_US"."HeroBoxTitle"
ELSE "Page_Live"."HeroBoxTitle" END
AS "HeroBoxTitle", CASE
WHEN "Page_Localised_en_US"."ID" IS NOT NULL THEN "Page_Localised_en_US"."HeroBoxExternalLink"
ELSE "Page_Live"."HeroBoxExternalLink" END
AS "HeroBoxExternalLink", CASE
WHEN "Page_Localised_en_US"."ID" IS NOT NULL THEN "Page_Localised_en_US"."HeroBoxContent"
ELSE "Page_Live"."HeroBoxContent" END
AS "HeroBoxContent", "Page_Live"."ShowHeroBox", "Page_Live"."NaviLinkDesktopClickable", "Page_Live"."ElementalAreaID", "Page_Live"."HeroImageID", "Page_Live"."HeroBoxFlagID", "Page_Live"."HeroBoxLinkID", "SiteTree_Live"."ID",
CASE WHEN "SiteTree_Live"."ClassName" IS NOT NULL THEN "SiteTree_Live"."ClassName"
ELSE 'SilverStripe\\CMS\\Model\\SiteTree' END AS "RecordClassName", 'en_US' AS "Locale", CASE WHEN "Page_Localised_en_US"."ID" IS NOT NULL THEN 'en_US'
ELSE NULL END AS "SourceLocale", "SiteTree_Live"."Sort"
FROM "SiteTree_Live" LEFT JOIN "Page_Live" ON "Page_Live"."ID" = "SiteTree_Live"."ID" LEFT JOIN "SiteTree_Localised_Live" AS "SiteTree_Localised_en_US" ON "SiteTree_Live"."ID" = "SiteTree_Localised_en_US"."RecordID" AND "SiteTree_Localised_en_US"."Locale" = ? LEFT JOIN "Page_Localised_Live" AS "Page_Localised_en_US" ON "Page_Live"."ID" = "Page_Localised_en_US"."RecordID" AND "Page_Localised_en_US"."Locale" = ?
WHERE ("SiteTree_Live"."ID" = ?)
AND ("SiteTree_Live"."ClassName" IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?))
AND (("SiteTree_Localised_en_US"."ID" IS NOT NULL))
ORDER BY "SiteTree_Live"."Sort" ASC
LIMIT 1
0.0011s
0079: SELECT DISTINCT "SiteTree_Live"."DeepLTranslated", "SiteTree_Live"."OriginalID", "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", CASE
WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."SiteTreeLinkerHelper"
ELSE "SiteTree_Live"."SiteTreeLinkerHelper" END
AS "SiteTreeLinkerHelper", "SiteTree_Live"."CanViewType", "SiteTree_Live"."CanEditType", "SiteTree_Live"."Version", CASE
WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."URLSegment"
ELSE "SiteTree_Live"."URLSegment" END
AS "URLSegment", CASE
WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."Title"
ELSE "SiteTree_Live"."Title" END
AS "Title", CASE
WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."MenuTitle"
ELSE "SiteTree_Live"."MenuTitle" END
AS "MenuTitle", CASE
WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."Content"
ELSE "SiteTree_Live"."Content" END
AS "Content", CASE
WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."MetaDescription"
ELSE "SiteTree_Live"."MetaDescription" END
AS "MetaDescription", "SiteTree_Live"."ExtraMeta", "SiteTree_Live"."ShowInMenus", "SiteTree_Live"."ShowInSearch", "SiteTree_Live"."Sort", "SiteTree_Live"."HasBrokenFile", "SiteTree_Live"."HasBrokenLink", CASE
WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."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", 'en_US' AS "Locale", CASE WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN 'en_US'
ELSE NULL END AS "SourceLocale"
FROM "SiteTree_Live" LEFT JOIN "SiteTree_Localised_Live" AS "SiteTree_Localised_en_US" ON "SiteTree_Live"."ID" = "SiteTree_Localised_en_US"."RecordID" AND "SiteTree_Localised_en_US"."Locale" = ?
WHERE ("SiteTree_Live"."ParentID" <> "SiteTree_Live"."ID")
AND ("SiteTree_Live"."ParentID" = ?)
AND ("SiteTree_Live"."ShowInMenus" = ?)
AND (("SiteTree_Localised_en_US"."ID" IS NOT NULL))
ORDER BY "SiteTree_Live"."Sort" ASC
0.0023s
0080: SELECT DISTINCT "SiteTree_Live"."DeepLTranslated", "SiteTree_Live"."OriginalID", "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", CASE
WHEN "Page_Localised_en_US"."ID" IS NOT NULL THEN "Page_Localised_en_US"."Subtitle"
ELSE "Page_Live"."Subtitle" END
AS "Subtitle", "Page_Live"."ShowInFooter", "Page_Live"."ShowInLegalMenu", CASE
WHEN "Page_Localised_en_US"."ID" IS NOT NULL THEN "Page_Localised_en_US"."MetaTitle"
ELSE "Page_Live"."MetaTitle" END
AS "MetaTitle", "Page_Live"."BlockFromSearchEngines", CASE
WHEN "Page_Localised_en_US"."ID" IS NOT NULL THEN "Page_Localised_en_US"."NavigationTeaser"
ELSE "Page_Live"."NavigationTeaser" END
AS "NavigationTeaser", "Page_Live"."ShowCTA", CASE
WHEN "Page_Localised_en_US"."ID" IS NOT NULL THEN "Page_Localised_en_US"."HeroBoxTitle"
ELSE "Page_Live"."HeroBoxTitle" END
AS "HeroBoxTitle", CASE
WHEN "Page_Localised_en_US"."ID" IS NOT NULL THEN "Page_Localised_en_US"."HeroBoxExternalLink"
ELSE "Page_Live"."HeroBoxExternalLink" END
AS "HeroBoxExternalLink", CASE
WHEN "Page_Localised_en_US"."ID" IS NOT NULL THEN "Page_Localised_en_US"."HeroBoxContent"
ELSE "Page_Live"."HeroBoxContent" END
AS "HeroBoxContent", "Page_Live"."ShowHeroBox", "Page_Live"."NaviLinkDesktopClickable", "Page_Live"."ElementalAreaID", "Page_Live"."HeroImageID", "Page_Live"."HeroBoxFlagID", "Page_Live"."HeroBoxLinkID", "SiteTree_Live"."ID",
CASE WHEN "SiteTree_Live"."ClassName" IS NOT NULL THEN "SiteTree_Live"."ClassName"
ELSE 'SilverStripe\\CMS\\Model\\SiteTree' END AS "RecordClassName", 'en_US' AS "Locale", CASE WHEN "Page_Localised_en_US"."ID" IS NOT NULL THEN 'en_US'
ELSE NULL END AS "SourceLocale", "SiteTree_Live"."Sort"
FROM "SiteTree_Live" LEFT JOIN "Page_Live" ON "Page_Live"."ID" = "SiteTree_Live"."ID" LEFT JOIN "SiteTree_Localised_Live" AS "SiteTree_Localised_en_US" ON "SiteTree_Live"."ID" = "SiteTree_Localised_en_US"."RecordID" AND "SiteTree_Localised_en_US"."Locale" = ? LEFT JOIN "Page_Localised_Live" AS "Page_Localised_en_US" ON "Page_Live"."ID" = "Page_Localised_en_US"."RecordID" AND "Page_Localised_en_US"."Locale" = ?
WHERE ("SiteTree_Live"."ID" = ?)
AND ("SiteTree_Live"."ClassName" IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?))
AND (("SiteTree_Localised_en_US"."ID" IS NOT NULL))
ORDER BY "SiteTree_Live"."Sort" ASC
LIMIT 1
0.0009s
0081: SELECT DISTINCT "SiteTree_Live"."DeepLTranslated", "SiteTree_Live"."OriginalID", "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", CASE
WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."SiteTreeLinkerHelper"
ELSE "SiteTree_Live"."SiteTreeLinkerHelper" END
AS "SiteTreeLinkerHelper", "SiteTree_Live"."CanViewType", "SiteTree_Live"."CanEditType", "SiteTree_Live"."Version", CASE
WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."URLSegment"
ELSE "SiteTree_Live"."URLSegment" END
AS "URLSegment", CASE
WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."Title"
ELSE "SiteTree_Live"."Title" END
AS "Title", CASE
WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."MenuTitle"
ELSE "SiteTree_Live"."MenuTitle" END
AS "MenuTitle", CASE
WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."Content"
ELSE "SiteTree_Live"."Content" END
AS "Content", CASE
WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."MetaDescription"
ELSE "SiteTree_Live"."MetaDescription" END
AS "MetaDescription", "SiteTree_Live"."ExtraMeta", "SiteTree_Live"."ShowInMenus", "SiteTree_Live"."ShowInSearch", "SiteTree_Live"."Sort", "SiteTree_Live"."HasBrokenFile", "SiteTree_Live"."HasBrokenLink", CASE
WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."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", 'en_US' AS "Locale", CASE WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN 'en_US'
ELSE NULL END AS "SourceLocale"
FROM "SiteTree_Live" LEFT JOIN "SiteTree_Localised_Live" AS "SiteTree_Localised_en_US" ON "SiteTree_Live"."ID" = "SiteTree_Localised_en_US"."RecordID" AND "SiteTree_Localised_en_US"."Locale" = ?
WHERE ("SiteTree_Live"."ParentID" <> "SiteTree_Live"."ID")
AND ("SiteTree_Live"."ParentID" = ?)
AND ("SiteTree_Live"."ShowInMenus" = ?)
AND (("SiteTree_Localised_en_US"."ID" IS NOT NULL))
ORDER BY "SiteTree_Live"."Sort" ASC
0.003s
0082: SELECT DISTINCT "SiteTree_Live"."DeepLTranslated", "SiteTree_Live"."OriginalID", "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", CASE
WHEN "Page_Localised_en_US"."ID" IS NOT NULL THEN "Page_Localised_en_US"."Subtitle"
ELSE "Page_Live"."Subtitle" END
AS "Subtitle", "Page_Live"."ShowInFooter", "Page_Live"."ShowInLegalMenu", CASE
WHEN "Page_Localised_en_US"."ID" IS NOT NULL THEN "Page_Localised_en_US"."MetaTitle"
ELSE "Page_Live"."MetaTitle" END
AS "MetaTitle", "Page_Live"."BlockFromSearchEngines", CASE
WHEN "Page_Localised_en_US"."ID" IS NOT NULL THEN "Page_Localised_en_US"."NavigationTeaser"
ELSE "Page_Live"."NavigationTeaser" END
AS "NavigationTeaser", "Page_Live"."ShowCTA", CASE
WHEN "Page_Localised_en_US"."ID" IS NOT NULL THEN "Page_Localised_en_US"."HeroBoxTitle"
ELSE "Page_Live"."HeroBoxTitle" END
AS "HeroBoxTitle", CASE
WHEN "Page_Localised_en_US"."ID" IS NOT NULL THEN "Page_Localised_en_US"."HeroBoxExternalLink"
ELSE "Page_Live"."HeroBoxExternalLink" END
AS "HeroBoxExternalLink", CASE
WHEN "Page_Localised_en_US"."ID" IS NOT NULL THEN "Page_Localised_en_US"."HeroBoxContent"
ELSE "Page_Live"."HeroBoxContent" END
AS "HeroBoxContent", "Page_Live"."ShowHeroBox", "Page_Live"."NaviLinkDesktopClickable", "Page_Live"."ElementalAreaID", "Page_Live"."HeroImageID", "Page_Live"."HeroBoxFlagID", "Page_Live"."HeroBoxLinkID", "SiteTree_Live"."ID",
CASE WHEN "SiteTree_Live"."ClassName" IS NOT NULL THEN "SiteTree_Live"."ClassName"
ELSE 'SilverStripe\\CMS\\Model\\SiteTree' END AS "RecordClassName", 'en_US' AS "Locale", CASE WHEN "Page_Localised_en_US"."ID" IS NOT NULL THEN 'en_US'
ELSE NULL END AS "SourceLocale", "SiteTree_Live"."Sort"
FROM "SiteTree_Live" LEFT JOIN "Page_Live" ON "Page_Live"."ID" = "SiteTree_Live"."ID" LEFT JOIN "SiteTree_Localised_Live" AS "SiteTree_Localised_en_US" ON "SiteTree_Live"."ID" = "SiteTree_Localised_en_US"."RecordID" AND "SiteTree_Localised_en_US"."Locale" = ? LEFT JOIN "Page_Localised_Live" AS "Page_Localised_en_US" ON "Page_Live"."ID" = "Page_Localised_en_US"."RecordID" AND "Page_Localised_en_US"."Locale" = ?
WHERE ("SiteTree_Live"."ID" = ?)
AND ("SiteTree_Live"."ClassName" IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?))
AND (("SiteTree_Localised_en_US"."ID" IS NOT NULL))
ORDER BY "SiteTree_Live"."Sort" ASC
LIMIT 1
0.0009s
0083: SELECT DISTINCT "SiteTree_Live"."DeepLTranslated", "SiteTree_Live"."OriginalID", "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", CASE
WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."SiteTreeLinkerHelper"
ELSE "SiteTree_Live"."SiteTreeLinkerHelper" END
AS "SiteTreeLinkerHelper", "SiteTree_Live"."CanViewType", "SiteTree_Live"."CanEditType", "SiteTree_Live"."Version", CASE
WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."URLSegment"
ELSE "SiteTree_Live"."URLSegment" END
AS "URLSegment", CASE
WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."Title"
ELSE "SiteTree_Live"."Title" END
AS "Title", CASE
WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."MenuTitle"
ELSE "SiteTree_Live"."MenuTitle" END
AS "MenuTitle", CASE
WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."Content"
ELSE "SiteTree_Live"."Content" END
AS "Content", CASE
WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."MetaDescription"
ELSE "SiteTree_Live"."MetaDescription" END
AS "MetaDescription", "SiteTree_Live"."ExtraMeta", "SiteTree_Live"."ShowInMenus", "SiteTree_Live"."ShowInSearch", "SiteTree_Live"."Sort", "SiteTree_Live"."HasBrokenFile", "SiteTree_Live"."HasBrokenLink", CASE
WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."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", 'en_US' AS "Locale", CASE WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN 'en_US'
ELSE NULL END AS "SourceLocale"
FROM "SiteTree_Live" LEFT JOIN "SiteTree_Localised_Live" AS "SiteTree_Localised_en_US" ON "SiteTree_Live"."ID" = "SiteTree_Localised_en_US"."RecordID" AND "SiteTree_Localised_en_US"."Locale" = ?
WHERE ("SiteTree_Live"."ParentID" <> "SiteTree_Live"."ID")
AND ("SiteTree_Live"."ParentID" = ?)
AND ("SiteTree_Live"."ShowInMenus" = ?)
AND (("SiteTree_Localised_en_US"."ID" IS NOT NULL))
ORDER BY "SiteTree_Live"."Sort" ASC
0.0025s
0084: SELECT DISTINCT "SiteTree_Live"."DeepLTranslated", "SiteTree_Live"."OriginalID", "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", CASE
WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."SiteTreeLinkerHelper"
ELSE "SiteTree_Live"."SiteTreeLinkerHelper" END
AS "SiteTreeLinkerHelper", "SiteTree_Live"."CanViewType", "SiteTree_Live"."CanEditType", "SiteTree_Live"."Version", CASE
WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."URLSegment"
ELSE "SiteTree_Live"."URLSegment" END
AS "URLSegment", CASE
WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."Title"
ELSE "SiteTree_Live"."Title" END
AS "Title", CASE
WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."MenuTitle"
ELSE "SiteTree_Live"."MenuTitle" END
AS "MenuTitle", CASE
WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."Content"
ELSE "SiteTree_Live"."Content" END
AS "Content", CASE
WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."MetaDescription"
ELSE "SiteTree_Live"."MetaDescription" END
AS "MetaDescription", "SiteTree_Live"."ExtraMeta", "SiteTree_Live"."ShowInMenus", "SiteTree_Live"."ShowInSearch", "SiteTree_Live"."Sort", "SiteTree_Live"."HasBrokenFile", "SiteTree_Live"."HasBrokenLink", CASE
WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."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", 'en_US' AS "Locale", CASE WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN 'en_US'
ELSE NULL END AS "SourceLocale"
FROM "SiteTree_Live" LEFT JOIN "SiteTree_Localised_Live" AS "SiteTree_Localised_en_US" ON "SiteTree_Live"."ID" = "SiteTree_Localised_en_US"."RecordID" AND "SiteTree_Localised_en_US"."Locale" = ?
WHERE ("SiteTree_Live"."ID" = ?)
AND (("SiteTree_Localised_en_US"."ID" IS NOT NULL))
ORDER BY "SiteTree_Live"."Sort" ASC
LIMIT 1
0.0008s
0085: SELECT DISTINCT "SiteTree_Live"."DeepLTranslated", "SiteTree_Live"."OriginalID", "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", CASE
WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."SiteTreeLinkerHelper"
ELSE "SiteTree_Live"."SiteTreeLinkerHelper" END
AS "SiteTreeLinkerHelper", "SiteTree_Live"."CanViewType", "SiteTree_Live"."CanEditType", "SiteTree_Live"."Version", CASE
WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."URLSegment"
ELSE "SiteTree_Live"."URLSegment" END
AS "URLSegment", CASE
WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."Title"
ELSE "SiteTree_Live"."Title" END
AS "Title", CASE
WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."MenuTitle"
ELSE "SiteTree_Live"."MenuTitle" END
AS "MenuTitle", CASE
WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."Content"
ELSE "SiteTree_Live"."Content" END
AS "Content", CASE
WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."MetaDescription"
ELSE "SiteTree_Live"."MetaDescription" END
AS "MetaDescription", "SiteTree_Live"."ExtraMeta", "SiteTree_Live"."ShowInMenus", "SiteTree_Live"."ShowInSearch", "SiteTree_Live"."Sort", "SiteTree_Live"."HasBrokenFile", "SiteTree_Live"."HasBrokenLink", CASE
WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."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", 'en_US' AS "Locale", CASE WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN 'en_US'
ELSE NULL END AS "SourceLocale"
FROM "SiteTree_Live" LEFT JOIN "SiteTree_Localised_Live" AS "SiteTree_Localised_en_US" ON "SiteTree_Live"."ID" = "SiteTree_Localised_en_US"."RecordID" AND "SiteTree_Localised_en_US"."Locale" = ?
WHERE ("SiteTree_Live"."ID" = ?)
AND (("SiteTree_Localised_en_US"."ID" IS NOT NULL))
ORDER BY "SiteTree_Live"."Sort" ASC
LIMIT 1
0.0008s
0086: SELECT DISTINCT "SiteTree_Live"."DeepLTranslated", "SiteTree_Live"."OriginalID", "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", CASE
WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."SiteTreeLinkerHelper"
ELSE "SiteTree_Live"."SiteTreeLinkerHelper" END
AS "SiteTreeLinkerHelper", "SiteTree_Live"."CanViewType", "SiteTree_Live"."CanEditType", "SiteTree_Live"."Version", CASE
WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."URLSegment"
ELSE "SiteTree_Live"."URLSegment" END
AS "URLSegment", CASE
WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."Title"
ELSE "SiteTree_Live"."Title" END
AS "Title", CASE
WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."MenuTitle"
ELSE "SiteTree_Live"."MenuTitle" END
AS "MenuTitle", CASE
WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."Content"
ELSE "SiteTree_Live"."Content" END
AS "Content", CASE
WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."MetaDescription"
ELSE "SiteTree_Live"."MetaDescription" END
AS "MetaDescription", "SiteTree_Live"."ExtraMeta", "SiteTree_Live"."ShowInMenus", "SiteTree_Live"."ShowInSearch", "SiteTree_Live"."Sort", "SiteTree_Live"."HasBrokenFile", "SiteTree_Live"."HasBrokenLink", CASE
WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."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", 'en_US' AS "Locale", CASE WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN 'en_US'
ELSE NULL END AS "SourceLocale"
FROM "SiteTree_Live" LEFT JOIN "SiteTree_Localised_Live" AS "SiteTree_Localised_en_US" ON "SiteTree_Live"."ID" = "SiteTree_Localised_en_US"."RecordID" AND "SiteTree_Localised_en_US"."Locale" = ?
WHERE ("SiteTree_Live"."ID" = ?)
AND (("SiteTree_Localised_en_US"."ID" IS NOT NULL))
ORDER BY "SiteTree_Live"."Sort" ASC
LIMIT 1
0.001s
0087: SELECT DISTINCT "SiteTree_Live"."DeepLTranslated", "SiteTree_Live"."OriginalID", "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", CASE
WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."SiteTreeLinkerHelper"
ELSE "SiteTree_Live"."SiteTreeLinkerHelper" END
AS "SiteTreeLinkerHelper", "SiteTree_Live"."CanViewType", "SiteTree_Live"."CanEditType", "SiteTree_Live"."Version", CASE
WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."URLSegment"
ELSE "SiteTree_Live"."URLSegment" END
AS "URLSegment", CASE
WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."Title"
ELSE "SiteTree_Live"."Title" END
AS "Title", CASE
WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."MenuTitle"
ELSE "SiteTree_Live"."MenuTitle" END
AS "MenuTitle", CASE
WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."Content"
ELSE "SiteTree_Live"."Content" END
AS "Content", CASE
WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."MetaDescription"
ELSE "SiteTree_Live"."MetaDescription" END
AS "MetaDescription", "SiteTree_Live"."ExtraMeta", "SiteTree_Live"."ShowInMenus", "SiteTree_Live"."ShowInSearch", "SiteTree_Live"."Sort", "SiteTree_Live"."HasBrokenFile", "SiteTree_Live"."HasBrokenLink", CASE
WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."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", 'en_US' AS "Locale", CASE WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN 'en_US'
ELSE NULL END AS "SourceLocale"
FROM "SiteTree_Live" LEFT JOIN "SiteTree_Localised_Live" AS "SiteTree_Localised_en_US" ON "SiteTree_Live"."ID" = "SiteTree_Localised_en_US"."RecordID" AND "SiteTree_Localised_en_US"."Locale" = ?
WHERE ("SiteTree_Live"."ID" = ?)
AND (("SiteTree_Localised_en_US"."ID" IS NOT NULL))
ORDER BY "SiteTree_Live"."Sort" ASC
LIMIT 1
0.0008s
0088: SELECT DISTINCT "SiteTree_Live"."DeepLTranslated", "SiteTree_Live"."OriginalID", "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", CASE
WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."SiteTreeLinkerHelper"
ELSE "SiteTree_Live"."SiteTreeLinkerHelper" END
AS "SiteTreeLinkerHelper", "SiteTree_Live"."CanViewType", "SiteTree_Live"."CanEditType", "SiteTree_Live"."Version", CASE
WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."URLSegment"
ELSE "SiteTree_Live"."URLSegment" END
AS "URLSegment", CASE
WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."Title"
ELSE "SiteTree_Live"."Title" END
AS "Title", CASE
WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."MenuTitle"
ELSE "SiteTree_Live"."MenuTitle" END
AS "MenuTitle", CASE
WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."Content"
ELSE "SiteTree_Live"."Content" END
AS "Content", CASE
WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."MetaDescription"
ELSE "SiteTree_Live"."MetaDescription" END
AS "MetaDescription", "SiteTree_Live"."ExtraMeta", "SiteTree_Live"."ShowInMenus", "SiteTree_Live"."ShowInSearch", "SiteTree_Live"."Sort", "SiteTree_Live"."HasBrokenFile", "SiteTree_Live"."HasBrokenLink", CASE
WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."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", 'en_US' AS "Locale", CASE WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN 'en_US'
ELSE NULL END AS "SourceLocale"
FROM "SiteTree_Live" LEFT JOIN "SiteTree_Localised_Live" AS "SiteTree_Localised_en_US" ON "SiteTree_Live"."ID" = "SiteTree_Localised_en_US"."RecordID" AND "SiteTree_Localised_en_US"."Locale" = ?
WHERE ("SiteTree_Live"."ParentID" <> "SiteTree_Live"."ID")
AND ("SiteTree_Live"."ParentID" = ?)
AND ("SiteTree_Live"."ShowInMenus" = ?)
AND (("SiteTree_Localised_en_US"."ID" IS NOT NULL))
ORDER BY "SiteTree_Live"."Sort" ASC
0.0026s
0089: SELECT DISTINCT "SiteTree_Live"."DeepLTranslated", "SiteTree_Live"."OriginalID", "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", CASE
WHEN "Page_Localised_en_US"."ID" IS NOT NULL THEN "Page_Localised_en_US"."Subtitle"
ELSE "Page_Live"."Subtitle" END
AS "Subtitle", "Page_Live"."ShowInFooter", "Page_Live"."ShowInLegalMenu", CASE
WHEN "Page_Localised_en_US"."ID" IS NOT NULL THEN "Page_Localised_en_US"."MetaTitle"
ELSE "Page_Live"."MetaTitle" END
AS "MetaTitle", "Page_Live"."BlockFromSearchEngines", CASE
WHEN "Page_Localised_en_US"."ID" IS NOT NULL THEN "Page_Localised_en_US"."NavigationTeaser"
ELSE "Page_Live"."NavigationTeaser" END
AS "NavigationTeaser", "Page_Live"."ShowCTA", CASE
WHEN "Page_Localised_en_US"."ID" IS NOT NULL THEN "Page_Localised_en_US"."HeroBoxTitle"
ELSE "Page_Live"."HeroBoxTitle" END
AS "HeroBoxTitle", CASE
WHEN "Page_Localised_en_US"."ID" IS NOT NULL THEN "Page_Localised_en_US"."HeroBoxExternalLink"
ELSE "Page_Live"."HeroBoxExternalLink" END
AS "HeroBoxExternalLink", CASE
WHEN "Page_Localised_en_US"."ID" IS NOT NULL THEN "Page_Localised_en_US"."HeroBoxContent"
ELSE "Page_Live"."HeroBoxContent" END
AS "HeroBoxContent", "Page_Live"."ShowHeroBox", "Page_Live"."NaviLinkDesktopClickable", "Page_Live"."ElementalAreaID", "Page_Live"."HeroImageID", "Page_Live"."HeroBoxFlagID", "Page_Live"."HeroBoxLinkID", "SiteTree_Live"."ID",
CASE WHEN "SiteTree_Live"."ClassName" IS NOT NULL THEN "SiteTree_Live"."ClassName"
ELSE 'SilverStripe\\CMS\\Model\\SiteTree' END AS "RecordClassName", 'en_US' AS "Locale", CASE WHEN "Page_Localised_en_US"."ID" IS NOT NULL THEN 'en_US'
ELSE NULL END AS "SourceLocale", "SiteTree_Live"."Sort"
FROM "SiteTree_Live" LEFT JOIN "Page_Live" ON "Page_Live"."ID" = "SiteTree_Live"."ID" LEFT JOIN "SiteTree_Localised_Live" AS "SiteTree_Localised_en_US" ON "SiteTree_Live"."ID" = "SiteTree_Localised_en_US"."RecordID" AND "SiteTree_Localised_en_US"."Locale" = ? LEFT JOIN "Page_Localised_Live" AS "Page_Localised_en_US" ON "Page_Live"."ID" = "Page_Localised_en_US"."RecordID" AND "Page_Localised_en_US"."Locale" = ?
WHERE ("SiteTree_Live"."ID" = ?)
AND ("SiteTree_Live"."ClassName" IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?))
AND (("SiteTree_Localised_en_US"."ID" IS NOT NULL))
ORDER BY "SiteTree_Live"."Sort" ASC
LIMIT 1
0.0014s
0090: SELECT DISTINCT "SiteTree_Live"."DeepLTranslated", "SiteTree_Live"."OriginalID", "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", CASE
WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."SiteTreeLinkerHelper"
ELSE "SiteTree_Live"."SiteTreeLinkerHelper" END
AS "SiteTreeLinkerHelper", "SiteTree_Live"."CanViewType", "SiteTree_Live"."CanEditType", "SiteTree_Live"."Version", CASE
WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."URLSegment"
ELSE "SiteTree_Live"."URLSegment" END
AS "URLSegment", CASE
WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."Title"
ELSE "SiteTree_Live"."Title" END
AS "Title", CASE
WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."MenuTitle"
ELSE "SiteTree_Live"."MenuTitle" END
AS "MenuTitle", CASE
WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."Content"
ELSE "SiteTree_Live"."Content" END
AS "Content", CASE
WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."MetaDescription"
ELSE "SiteTree_Live"."MetaDescription" END
AS "MetaDescription", "SiteTree_Live"."ExtraMeta", "SiteTree_Live"."ShowInMenus", "SiteTree_Live"."ShowInSearch", "SiteTree_Live"."Sort", "SiteTree_Live"."HasBrokenFile", "SiteTree_Live"."HasBrokenLink", CASE
WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."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", 'en_US' AS "Locale", CASE WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN 'en_US'
ELSE NULL END AS "SourceLocale"
FROM "SiteTree_Live" LEFT JOIN "SiteTree_Localised_Live" AS "SiteTree_Localised_en_US" ON "SiteTree_Live"."ID" = "SiteTree_Localised_en_US"."RecordID" AND "SiteTree_Localised_en_US"."Locale" = ?
WHERE ("SiteTree_Live"."ParentID" <> "SiteTree_Live"."ID")
AND ("SiteTree_Live"."ParentID" = ?)
AND ("SiteTree_Live"."ShowInMenus" = ?)
AND (("SiteTree_Localised_en_US"."ID" IS NOT NULL))
ORDER BY "SiteTree_Live"."Sort" ASC
0.0024s
0091: SELECT DISTINCT "SiteTree_Live"."DeepLTranslated", "SiteTree_Live"."OriginalID", "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", CASE
WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."SiteTreeLinkerHelper"
ELSE "SiteTree_Live"."SiteTreeLinkerHelper" END
AS "SiteTreeLinkerHelper", "SiteTree_Live"."CanViewType", "SiteTree_Live"."CanEditType", "SiteTree_Live"."Version", CASE
WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."URLSegment"
ELSE "SiteTree_Live"."URLSegment" END
AS "URLSegment", CASE
WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."Title"
ELSE "SiteTree_Live"."Title" END
AS "Title", CASE
WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."MenuTitle"
ELSE "SiteTree_Live"."MenuTitle" END
AS "MenuTitle", CASE
WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."Content"
ELSE "SiteTree_Live"."Content" END
AS "Content", CASE
WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."MetaDescription"
ELSE "SiteTree_Live"."MetaDescription" END
AS "MetaDescription", "SiteTree_Live"."ExtraMeta", "SiteTree_Live"."ShowInMenus", "SiteTree_Live"."ShowInSearch", "SiteTree_Live"."Sort", "SiteTree_Live"."HasBrokenFile", "SiteTree_Live"."HasBrokenLink", CASE
WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."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", 'en_US' AS "Locale", CASE WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN 'en_US'
ELSE NULL END AS "SourceLocale"
FROM "SiteTree_Live" LEFT JOIN "SiteTree_Localised_Live" AS "SiteTree_Localised_en_US" ON "SiteTree_Live"."ID" = "SiteTree_Localised_en_US"."RecordID" AND "SiteTree_Localised_en_US"."Locale" = ?
WHERE ("SiteTree_Live"."ID" = ?)
AND (("SiteTree_Localised_en_US"."ID" IS NOT NULL))
ORDER BY "SiteTree_Live"."Sort" ASC
LIMIT 1
0.001s
0092: SELECT DISTINCT "SiteTree_Live"."DeepLTranslated", "SiteTree_Live"."OriginalID", "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", CASE
WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."SiteTreeLinkerHelper"
ELSE "SiteTree_Live"."SiteTreeLinkerHelper" END
AS "SiteTreeLinkerHelper", "SiteTree_Live"."CanViewType", "SiteTree_Live"."CanEditType", "SiteTree_Live"."Version", CASE
WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."URLSegment"
ELSE "SiteTree_Live"."URLSegment" END
AS "URLSegment", CASE
WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."Title"
ELSE "SiteTree_Live"."Title" END
AS "Title", CASE
WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."MenuTitle"
ELSE "SiteTree_Live"."MenuTitle" END
AS "MenuTitle", CASE
WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."Content"
ELSE "SiteTree_Live"."Content" END
AS "Content", CASE
WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."MetaDescription"
ELSE "SiteTree_Live"."MetaDescription" END
AS "MetaDescription", "SiteTree_Live"."ExtraMeta", "SiteTree_Live"."ShowInMenus", "SiteTree_Live"."ShowInSearch", "SiteTree_Live"."Sort", "SiteTree_Live"."HasBrokenFile", "SiteTree_Live"."HasBrokenLink", CASE
WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."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", 'en_US' AS "Locale", CASE WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN 'en_US'
ELSE NULL END AS "SourceLocale"
FROM "SiteTree_Live" LEFT JOIN "SiteTree_Localised_Live" AS "SiteTree_Localised_en_US" ON "SiteTree_Live"."ID" = "SiteTree_Localised_en_US"."RecordID" AND "SiteTree_Localised_en_US"."Locale" = ?
WHERE ("SiteTree_Live"."ID" = ?)
AND (("SiteTree_Localised_en_US"."ID" IS NOT NULL))
ORDER BY "SiteTree_Live"."Sort" ASC
LIMIT 1
0.0008s
0093: SELECT DISTINCT "SiteTree_Live"."DeepLTranslated", "SiteTree_Live"."OriginalID", "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", CASE
WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."SiteTreeLinkerHelper"
ELSE "SiteTree_Live"."SiteTreeLinkerHelper" END
AS "SiteTreeLinkerHelper", "SiteTree_Live"."CanViewType", "SiteTree_Live"."CanEditType", "SiteTree_Live"."Version", CASE
WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."URLSegment"
ELSE "SiteTree_Live"."URLSegment" END
AS "URLSegment", CASE
WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."Title"
ELSE "SiteTree_Live"."Title" END
AS "Title", CASE
WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."MenuTitle"
ELSE "SiteTree_Live"."MenuTitle" END
AS "MenuTitle", CASE
WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."Content"
ELSE "SiteTree_Live"."Content" END
AS "Content", CASE
WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."MetaDescription"
ELSE "SiteTree_Live"."MetaDescription" END
AS "MetaDescription", "SiteTree_Live"."ExtraMeta", "SiteTree_Live"."ShowInMenus", "SiteTree_Live"."ShowInSearch", "SiteTree_Live"."Sort", "SiteTree_Live"."HasBrokenFile", "SiteTree_Live"."HasBrokenLink", CASE
WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."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", 'en_US' AS "Locale", CASE WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN 'en_US'
ELSE NULL END AS "SourceLocale"
FROM "SiteTree_Live" LEFT JOIN "SiteTree_Localised_Live" AS "SiteTree_Localised_en_US" ON "SiteTree_Live"."ID" = "SiteTree_Localised_en_US"."RecordID" AND "SiteTree_Localised_en_US"."Locale" = ?
WHERE ("SiteTree_Live"."ID" = ?)
AND (("SiteTree_Localised_en_US"."ID" IS NOT NULL))
ORDER BY "SiteTree_Live"."Sort" ASC
LIMIT 1
0.0006s
0094: SELECT DISTINCT "SiteTree_Live"."DeepLTranslated", "SiteTree_Live"."OriginalID", "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", CASE
WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."SiteTreeLinkerHelper"
ELSE "SiteTree_Live"."SiteTreeLinkerHelper" END
AS "SiteTreeLinkerHelper", "SiteTree_Live"."CanViewType", "SiteTree_Live"."CanEditType", "SiteTree_Live"."Version", CASE
WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."URLSegment"
ELSE "SiteTree_Live"."URLSegment" END
AS "URLSegment", CASE
WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."Title"
ELSE "SiteTree_Live"."Title" END
AS "Title", CASE
WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."MenuTitle"
ELSE "SiteTree_Live"."MenuTitle" END
AS "MenuTitle", CASE
WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."Content"
ELSE "SiteTree_Live"."Content" END
AS "Content", CASE
WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."MetaDescription"
ELSE "SiteTree_Live"."MetaDescription" END
AS "MetaDescription", "SiteTree_Live"."ExtraMeta", "SiteTree_Live"."ShowInMenus", "SiteTree_Live"."ShowInSearch", "SiteTree_Live"."Sort", "SiteTree_Live"."HasBrokenFile", "SiteTree_Live"."HasBrokenLink", CASE
WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."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", 'en_US' AS "Locale", CASE WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN 'en_US'
ELSE NULL END AS "SourceLocale"
FROM "SiteTree_Live" LEFT JOIN "SiteTree_Localised_Live" AS "SiteTree_Localised_en_US" ON "SiteTree_Live"."ID" = "SiteTree_Localised_en_US"."RecordID" AND "SiteTree_Localised_en_US"."Locale" = ?
WHERE ("SiteTree_Live"."ID" = ?)
AND (("SiteTree_Localised_en_US"."ID" IS NOT NULL))
ORDER BY "SiteTree_Live"."Sort" ASC
LIMIT 1
0.0005s
0095: SELECT DISTINCT "SiteTree_Live"."DeepLTranslated", "SiteTree_Live"."OriginalID", "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", CASE
WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."SiteTreeLinkerHelper"
ELSE "SiteTree_Live"."SiteTreeLinkerHelper" END
AS "SiteTreeLinkerHelper", "SiteTree_Live"."CanViewType", "SiteTree_Live"."CanEditType", "SiteTree_Live"."Version", CASE
WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."URLSegment"
ELSE "SiteTree_Live"."URLSegment" END
AS "URLSegment", CASE
WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."Title"
ELSE "SiteTree_Live"."Title" END
AS "Title", CASE
WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."MenuTitle"
ELSE "SiteTree_Live"."MenuTitle" END
AS "MenuTitle", CASE
WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."Content"
ELSE "SiteTree_Live"."Content" END
AS "Content", CASE
WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."MetaDescription"
ELSE "SiteTree_Live"."MetaDescription" END
AS "MetaDescription", "SiteTree_Live"."ExtraMeta", "SiteTree_Live"."ShowInMenus", "SiteTree_Live"."ShowInSearch", "SiteTree_Live"."Sort", "SiteTree_Live"."HasBrokenFile", "SiteTree_Live"."HasBrokenLink", CASE
WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."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", 'en_US' AS "Locale", CASE WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN 'en_US'
ELSE NULL END AS "SourceLocale"
FROM "SiteTree_Live" LEFT JOIN "SiteTree_Localised_Live" AS "SiteTree_Localised_en_US" ON "SiteTree_Live"."ID" = "SiteTree_Localised_en_US"."RecordID" AND "SiteTree_Localised_en_US"."Locale" = ?
WHERE ("SiteTree_Live"."ParentID" <> "SiteTree_Live"."ID")
AND ("SiteTree_Live"."ParentID" = ?)
AND ("SiteTree_Live"."ShowInMenus" = ?)
AND (("SiteTree_Localised_en_US"."ID" IS NOT NULL))
ORDER BY "SiteTree_Live"."Sort" ASC
0.002s
0096: SELECT DISTINCT "SiteTree_Live"."DeepLTranslated", "SiteTree_Live"."OriginalID", "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", CASE
WHEN "Page_Localised_en_US"."ID" IS NOT NULL THEN "Page_Localised_en_US"."Subtitle"
ELSE "Page_Live"."Subtitle" END
AS "Subtitle", "Page_Live"."ShowInFooter", "Page_Live"."ShowInLegalMenu", CASE
WHEN "Page_Localised_en_US"."ID" IS NOT NULL THEN "Page_Localised_en_US"."MetaTitle"
ELSE "Page_Live"."MetaTitle" END
AS "MetaTitle", "Page_Live"."BlockFromSearchEngines", CASE
WHEN "Page_Localised_en_US"."ID" IS NOT NULL THEN "Page_Localised_en_US"."NavigationTeaser"
ELSE "Page_Live"."NavigationTeaser" END
AS "NavigationTeaser", "Page_Live"."ShowCTA", CASE
WHEN "Page_Localised_en_US"."ID" IS NOT NULL THEN "Page_Localised_en_US"."HeroBoxTitle"
ELSE "Page_Live"."HeroBoxTitle" END
AS "HeroBoxTitle", CASE
WHEN "Page_Localised_en_US"."ID" IS NOT NULL THEN "Page_Localised_en_US"."HeroBoxExternalLink"
ELSE "Page_Live"."HeroBoxExternalLink" END
AS "HeroBoxExternalLink", CASE
WHEN "Page_Localised_en_US"."ID" IS NOT NULL THEN "Page_Localised_en_US"."HeroBoxContent"
ELSE "Page_Live"."HeroBoxContent" END
AS "HeroBoxContent", "Page_Live"."ShowHeroBox", "Page_Live"."NaviLinkDesktopClickable", "Page_Live"."ElementalAreaID", "Page_Live"."HeroImageID", "Page_Live"."HeroBoxFlagID", "Page_Live"."HeroBoxLinkID", "SiteTree_Live"."ID",
CASE WHEN "SiteTree_Live"."ClassName" IS NOT NULL THEN "SiteTree_Live"."ClassName"
ELSE 'SilverStripe\\CMS\\Model\\SiteTree' END AS "RecordClassName", 'en_US' AS "Locale", CASE WHEN "Page_Localised_en_US"."ID" IS NOT NULL THEN 'en_US'
ELSE NULL END AS "SourceLocale", "SiteTree_Live"."Sort"
FROM "SiteTree_Live" LEFT JOIN "Page_Live" ON "Page_Live"."ID" = "SiteTree_Live"."ID" LEFT JOIN "SiteTree_Localised_Live" AS "SiteTree_Localised_en_US" ON "SiteTree_Live"."ID" = "SiteTree_Localised_en_US"."RecordID" AND "SiteTree_Localised_en_US"."Locale" = ? LEFT JOIN "Page_Localised_Live" AS "Page_Localised_en_US" ON "Page_Live"."ID" = "Page_Localised_en_US"."RecordID" AND "Page_Localised_en_US"."Locale" = ?
WHERE ("SiteTree_Live"."ID" = ?)
AND ("SiteTree_Live"."ClassName" IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?))
AND (("SiteTree_Localised_en_US"."ID" IS NOT NULL))
ORDER BY "SiteTree_Live"."Sort" ASC
LIMIT 1
0.0008s
0097: SELECT DISTINCT "SiteTree_Live"."DeepLTranslated", "SiteTree_Live"."OriginalID", "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", CASE
WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."SiteTreeLinkerHelper"
ELSE "SiteTree_Live"."SiteTreeLinkerHelper" END
AS "SiteTreeLinkerHelper", "SiteTree_Live"."CanViewType", "SiteTree_Live"."CanEditType", "SiteTree_Live"."Version", CASE
WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."URLSegment"
ELSE "SiteTree_Live"."URLSegment" END
AS "URLSegment", CASE
WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."Title"
ELSE "SiteTree_Live"."Title" END
AS "Title", CASE
WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."MenuTitle"
ELSE "SiteTree_Live"."MenuTitle" END
AS "MenuTitle", CASE
WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."Content"
ELSE "SiteTree_Live"."Content" END
AS "Content", CASE
WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."MetaDescription"
ELSE "SiteTree_Live"."MetaDescription" END
AS "MetaDescription", "SiteTree_Live"."ExtraMeta", "SiteTree_Live"."ShowInMenus", "SiteTree_Live"."ShowInSearch", "SiteTree_Live"."Sort", "SiteTree_Live"."HasBrokenFile", "SiteTree_Live"."HasBrokenLink", CASE
WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."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", 'en_US' AS "Locale", CASE WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN 'en_US'
ELSE NULL END AS "SourceLocale"
FROM "SiteTree_Live" LEFT JOIN "SiteTree_Localised_Live" AS "SiteTree_Localised_en_US" ON "SiteTree_Live"."ID" = "SiteTree_Localised_en_US"."RecordID" AND "SiteTree_Localised_en_US"."Locale" = ?
WHERE ("SiteTree_Live"."ParentID" <> "SiteTree_Live"."ID")
AND ("SiteTree_Live"."ParentID" = ?)
AND ("SiteTree_Live"."ShowInMenus" = ?)
AND (("SiteTree_Localised_en_US"."ID" IS NOT NULL))
ORDER BY "SiteTree_Live"."Sort" ASC
0.0023s
0098: SELECT DISTINCT "SiteTree_Live"."DeepLTranslated", "SiteTree_Live"."OriginalID", "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", CASE
WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."SiteTreeLinkerHelper"
ELSE "SiteTree_Live"."SiteTreeLinkerHelper" END
AS "SiteTreeLinkerHelper", "SiteTree_Live"."CanViewType", "SiteTree_Live"."CanEditType", "SiteTree_Live"."Version", CASE
WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."URLSegment"
ELSE "SiteTree_Live"."URLSegment" END
AS "URLSegment", CASE
WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."Title"
ELSE "SiteTree_Live"."Title" END
AS "Title", CASE
WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."MenuTitle"
ELSE "SiteTree_Live"."MenuTitle" END
AS "MenuTitle", CASE
WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."Content"
ELSE "SiteTree_Live"."Content" END
AS "Content", CASE
WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."MetaDescription"
ELSE "SiteTree_Live"."MetaDescription" END
AS "MetaDescription", "SiteTree_Live"."ExtraMeta", "SiteTree_Live"."ShowInMenus", "SiteTree_Live"."ShowInSearch", "SiteTree_Live"."Sort", "SiteTree_Live"."HasBrokenFile", "SiteTree_Live"."HasBrokenLink", CASE
WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."ReportClass"
ELSE "SiteTree_Live"."ReportClass" END
AS "ReportClass", "SiteTree_Live"."ParentID", CASE
WHEN "Page_Localised_en_US"."ID" IS NOT NULL THEN "Page_Localised_en_US"."Subtitle"
ELSE "Page_Live"."Subtitle" END
AS "Subtitle", "Page_Live"."ShowInFooter", "Page_Live"."ShowInLegalMenu", CASE
WHEN "Page_Localised_en_US"."ID" IS NOT NULL THEN "Page_Localised_en_US"."MetaTitle"
ELSE "Page_Live"."MetaTitle" END
AS "MetaTitle", "Page_Live"."BlockFromSearchEngines", CASE
WHEN "Page_Localised_en_US"."ID" IS NOT NULL THEN "Page_Localised_en_US"."NavigationTeaser"
ELSE "Page_Live"."NavigationTeaser" END
AS "NavigationTeaser", "Page_Live"."ShowCTA", CASE
WHEN "Page_Localised_en_US"."ID" IS NOT NULL THEN "Page_Localised_en_US"."HeroBoxTitle"
ELSE "Page_Live"."HeroBoxTitle" END
AS "HeroBoxTitle", CASE
WHEN "Page_Localised_en_US"."ID" IS NOT NULL THEN "Page_Localised_en_US"."HeroBoxExternalLink"
ELSE "Page_Live"."HeroBoxExternalLink" END
AS "HeroBoxExternalLink", CASE
WHEN "Page_Localised_en_US"."ID" IS NOT NULL THEN "Page_Localised_en_US"."HeroBoxContent"
ELSE "Page_Live"."HeroBoxContent" END
AS "HeroBoxContent", "Page_Live"."ShowHeroBox", "Page_Live"."NaviLinkDesktopClickable", "Page_Live"."ElementalAreaID", "Page_Live"."HeroImageID", "Page_Live"."HeroBoxFlagID", "Page_Live"."HeroBoxLinkID", "SiteTree_Live"."ID",
CASE WHEN "SiteTree_Live"."ClassName" IS NOT NULL THEN "SiteTree_Live"."ClassName"
ELSE 'SilverStripe\\CMS\\Model\\SiteTree' END AS "RecordClassName", 'en_US' AS "Locale", CASE WHEN "Page_Localised_en_US"."ID" IS NOT NULL THEN 'en_US'
ELSE NULL END AS "SourceLocale"
FROM "SiteTree_Live" LEFT JOIN "Page_Live" ON "Page_Live"."ID" = "SiteTree_Live"."ID" LEFT JOIN "SiteTree_Localised_Live" AS "SiteTree_Localised_en_US" ON "SiteTree_Live"."ID" = "SiteTree_Localised_en_US"."RecordID" AND "SiteTree_Localised_en_US"."Locale" = ? LEFT JOIN "Page_Localised_Live" AS "Page_Localised_en_US" ON "Page_Live"."ID" = "Page_Localised_en_US"."RecordID" AND "Page_Localised_en_US"."Locale" = ?
WHERE ("SiteTree_Live"."ClassName" IN (?))
AND (("SiteTree_Localised_en_US"."ID" IS NOT NULL))
ORDER BY "SiteTree_Live"."Sort" ASC
LIMIT 1
0.0042s
0099: SELECT DISTINCT "SiteTree_Live"."DeepLTranslated", "SiteTree_Live"."OriginalID", "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", CASE
WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."SiteTreeLinkerHelper"
ELSE "SiteTree_Live"."SiteTreeLinkerHelper" END
AS "SiteTreeLinkerHelper", "SiteTree_Live"."CanViewType", "SiteTree_Live"."CanEditType", "SiteTree_Live"."Version", CASE
WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."URLSegment"
ELSE "SiteTree_Live"."URLSegment" END
AS "URLSegment", CASE
WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."Title"
ELSE "SiteTree_Live"."Title" END
AS "Title", CASE
WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."MenuTitle"
ELSE "SiteTree_Live"."MenuTitle" END
AS "MenuTitle", CASE
WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."Content"
ELSE "SiteTree_Live"."Content" END
AS "Content", CASE
WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."MetaDescription"
ELSE "SiteTree_Live"."MetaDescription" END
AS "MetaDescription", "SiteTree_Live"."ExtraMeta", "SiteTree_Live"."ShowInMenus", "SiteTree_Live"."ShowInSearch", "SiteTree_Live"."Sort", "SiteTree_Live"."HasBrokenFile", "SiteTree_Live"."HasBrokenLink", CASE
WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."ReportClass"
ELSE "SiteTree_Live"."ReportClass" END
AS "ReportClass", "SiteTree_Live"."ParentID", CASE
WHEN "Page_Localised_en_US"."ID" IS NOT NULL THEN "Page_Localised_en_US"."Subtitle"
ELSE "Page_Live"."Subtitle" END
AS "Subtitle", "Page_Live"."ShowInFooter", "Page_Live"."ShowInLegalMenu", CASE
WHEN "Page_Localised_en_US"."ID" IS NOT NULL THEN "Page_Localised_en_US"."MetaTitle"
ELSE "Page_Live"."MetaTitle" END
AS "MetaTitle", "Page_Live"."BlockFromSearchEngines", CASE
WHEN "Page_Localised_en_US"."ID" IS NOT NULL THEN "Page_Localised_en_US"."NavigationTeaser"
ELSE "Page_Live"."NavigationTeaser" END
AS "NavigationTeaser", "Page_Live"."ShowCTA", CASE
WHEN "Page_Localised_en_US"."ID" IS NOT NULL THEN "Page_Localised_en_US"."HeroBoxTitle"
ELSE "Page_Live"."HeroBoxTitle" END
AS "HeroBoxTitle", CASE
WHEN "Page_Localised_en_US"."ID" IS NOT NULL THEN "Page_Localised_en_US"."HeroBoxExternalLink"
ELSE "Page_Live"."HeroBoxExternalLink" END
AS "HeroBoxExternalLink", CASE
WHEN "Page_Localised_en_US"."ID" IS NOT NULL THEN "Page_Localised_en_US"."HeroBoxContent"
ELSE "Page_Live"."HeroBoxContent" END
AS "HeroBoxContent", "Page_Live"."ShowHeroBox", "Page_Live"."NaviLinkDesktopClickable", "Page_Live"."ElementalAreaID", "Page_Live"."HeroImageID", "Page_Live"."HeroBoxFlagID", "Page_Live"."HeroBoxLinkID", "SiteTree_Live"."ID",
CASE WHEN "SiteTree_Live"."ClassName" IS NOT NULL THEN "SiteTree_Live"."ClassName"
ELSE 'SilverStripe\\CMS\\Model\\SiteTree' END AS "RecordClassName", 'en_US' AS "Locale", CASE WHEN "Page_Localised_en_US"."ID" IS NOT NULL THEN 'en_US'
ELSE NULL END AS "SourceLocale"
FROM "SiteTree_Live" LEFT JOIN "Page_Live" ON "Page_Live"."ID" = "SiteTree_Live"."ID" LEFT JOIN "SiteTree_Localised_Live" AS "SiteTree_Localised_en_US" ON "SiteTree_Live"."ID" = "SiteTree_Localised_en_US"."RecordID" AND "SiteTree_Localised_en_US"."Locale" = ? LEFT JOIN "Page_Localised_Live" AS "Page_Localised_en_US" ON "Page_Live"."ID" = "Page_Localised_en_US"."RecordID" AND "Page_Localised_en_US"."Locale" = ?
WHERE ("SiteTree_Live"."ID" = ?)
AND ("SiteTree_Live"."ClassName" IN (?))
AND (("SiteTree_Localised_en_US"."ID" IS NOT NULL))
ORDER BY "SiteTree_Live"."Sort" ASC
LIMIT 1
0.003s
0100: SELECT "ID"
FROM "SiteTree_Localised_Live"
WHERE ("RecordID" = ?)
AND ("Locale" = ?)
LIMIT 1
0.0011s
0101: SELECT DISTINCT "Fluent_Locale"."DeepLTranslated", "Fluent_Locale"."OriginalID", "Fluent_Locale"."ClassName", "Fluent_Locale"."LastEdited", "Fluent_Locale"."Created", "Fluent_Locale"."Title", "Fluent_Locale"."Locale", "Fluent_Locale"."URLSegment", "Fluent_Locale"."IsGlobalDefault", "Fluent_Locale"."FlagID", "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"
WHERE ("Fluent_Locale"."Locale" = ?)
ORDER BY "Fluent_Locale"."Locale" ASC
LIMIT 1
0.0016s
0102: SELECT "Version" FROM "SiteTree" WHERE "ID" = ?
0.0012s
0103: SELECT DISTINCT "SiteTree_Live"."DeepLTranslated", "SiteTree_Live"."OriginalID", "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", CASE
WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."SiteTreeLinkerHelper"
ELSE "SiteTree_Live"."SiteTreeLinkerHelper" END
AS "SiteTreeLinkerHelper", "SiteTree_Live"."CanViewType", "SiteTree_Live"."CanEditType", "SiteTree_Live"."Version", CASE
WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."URLSegment"
ELSE "SiteTree_Live"."URLSegment" END
AS "URLSegment", CASE
WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."Title"
ELSE "SiteTree_Live"."Title" END
AS "Title", CASE
WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."MenuTitle"
ELSE "SiteTree_Live"."MenuTitle" END
AS "MenuTitle", CASE
WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."Content"
ELSE "SiteTree_Live"."Content" END
AS "Content", CASE
WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."MetaDescription"
ELSE "SiteTree_Live"."MetaDescription" END
AS "MetaDescription", "SiteTree_Live"."ExtraMeta", "SiteTree_Live"."ShowInMenus", "SiteTree_Live"."ShowInSearch", "SiteTree_Live"."Sort", "SiteTree_Live"."HasBrokenFile", "SiteTree_Live"."HasBrokenLink", CASE
WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."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", 'en_US' AS "Locale", CASE WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN 'en_US'
ELSE NULL END AS "SourceLocale"
FROM "SiteTree_Live" LEFT JOIN "SiteTree_Localised_Live" AS "SiteTree_Localised_en_US" ON "SiteTree_Live"."ID" = "SiteTree_Localised_en_US"."RecordID" AND "SiteTree_Localised_en_US"."Locale" = ?
WHERE ("SiteTree_Live"."ID" = ?)
AND (("SiteTree_Localised_en_US"."ID" IS NOT NULL))
ORDER BY "SiteTree_Live"."Sort" ASC
LIMIT 1
0.0011s
0104: SELECT DISTINCT "SiteTree_Live"."DeepLTranslated", "SiteTree_Live"."OriginalID", "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", CASE
WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."SiteTreeLinkerHelper"
ELSE "SiteTree_Live"."SiteTreeLinkerHelper" END
AS "SiteTreeLinkerHelper", "SiteTree_Live"."CanViewType", "SiteTree_Live"."CanEditType", "SiteTree_Live"."Version", CASE
WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."URLSegment"
ELSE "SiteTree_Live"."URLSegment" END
AS "URLSegment", CASE
WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."Title"
ELSE "SiteTree_Live"."Title" END
AS "Title", CASE
WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."MenuTitle"
ELSE "SiteTree_Live"."MenuTitle" END
AS "MenuTitle", CASE
WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."Content"
ELSE "SiteTree_Live"."Content" END
AS "Content", CASE
WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."MetaDescription"
ELSE "SiteTree_Live"."MetaDescription" END
AS "MetaDescription", "SiteTree_Live"."ExtraMeta", "SiteTree_Live"."ShowInMenus", "SiteTree_Live"."ShowInSearch", "SiteTree_Live"."Sort", "SiteTree_Live"."HasBrokenFile", "SiteTree_Live"."HasBrokenLink", CASE
WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."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", 'en_US' AS "Locale", CASE WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN 'en_US'
ELSE NULL END AS "SourceLocale"
FROM "SiteTree_Live" LEFT JOIN "SiteTree_Localised_Live" AS "SiteTree_Localised_en_US" ON "SiteTree_Live"."ID" = "SiteTree_Localised_en_US"."RecordID" AND "SiteTree_Localised_en_US"."Locale" = ?
WHERE ("SiteTree_Live"."ID" = ?)
AND (("SiteTree_Localised_en_US"."ID" IS NOT NULL))
ORDER BY "SiteTree_Live"."Sort" ASC
LIMIT 1
0.0011s
0105: SELECT DISTINCT "SiteTree"."DeepLTranslated", "SiteTree"."OriginalID", "SiteTree"."ClassName", "SiteTree"."LastEdited", "SiteTree"."Created", "SiteTree"."Priority", CASE
WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."SiteTreeLinkerHelper"
ELSE "SiteTree"."SiteTreeLinkerHelper" END
AS "SiteTreeLinkerHelper", "SiteTree"."CanViewType", "SiteTree"."CanEditType", "SiteTree"."Version", CASE
WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."URLSegment"
ELSE "SiteTree"."URLSegment" END
AS "URLSegment", CASE
WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."Title"
ELSE "SiteTree"."Title" END
AS "Title", CASE
WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."MenuTitle"
ELSE "SiteTree"."MenuTitle" END
AS "MenuTitle", CASE
WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."Content"
ELSE "SiteTree"."Content" END
AS "Content", CASE
WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."MetaDescription"
ELSE "SiteTree"."MetaDescription" END
AS "MetaDescription", "SiteTree"."ExtraMeta", "SiteTree"."ShowInMenus", "SiteTree"."ShowInSearch", "SiteTree"."Sort", "SiteTree"."HasBrokenFile", "SiteTree"."HasBrokenLink", CASE
WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."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", 'en_US' AS "Locale", CASE WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN 'en_US'
ELSE NULL END AS "SourceLocale"
FROM "SiteTree" LEFT JOIN "SiteTree_Localised" AS "SiteTree_Localised_en_US" ON "SiteTree"."ID" = "SiteTree_Localised_en_US"."RecordID" AND "SiteTree_Localised_en_US"."Locale" = ?
WHERE ("SiteTree"."ID" = ?)
AND (("SiteTree_Localised_en_US"."ID" IS NOT NULL))
ORDER BY "SiteTree"."Sort" ASC
LIMIT 1
0.0021s
0106: SELECT DISTINCT "SiteTree_Live"."DeepLTranslated", "SiteTree_Live"."OriginalID", "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", CASE
WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."SiteTreeLinkerHelper"
ELSE "SiteTree_Live"."SiteTreeLinkerHelper" END
AS "SiteTreeLinkerHelper", "SiteTree_Live"."CanViewType", "SiteTree_Live"."CanEditType", "SiteTree_Live"."Version", CASE
WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."URLSegment"
ELSE "SiteTree_Live"."URLSegment" END
AS "URLSegment", CASE
WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."Title"
ELSE "SiteTree_Live"."Title" END
AS "Title", CASE
WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."MenuTitle"
ELSE "SiteTree_Live"."MenuTitle" END
AS "MenuTitle", CASE
WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."Content"
ELSE "SiteTree_Live"."Content" END
AS "Content", CASE
WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."MetaDescription"
ELSE "SiteTree_Live"."MetaDescription" END
AS "MetaDescription", "SiteTree_Live"."ExtraMeta", "SiteTree_Live"."ShowInMenus", "SiteTree_Live"."ShowInSearch", "SiteTree_Live"."Sort", "SiteTree_Live"."HasBrokenFile", "SiteTree_Live"."HasBrokenLink", CASE
WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."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", 'en_US' AS "Locale", CASE WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN 'en_US'
ELSE NULL END AS "SourceLocale"
FROM "SiteTree_Live" LEFT JOIN "SiteTree_Localised_Live" AS "SiteTree_Localised_en_US" ON "SiteTree_Live"."ID" = "SiteTree_Localised_en_US"."RecordID" AND "SiteTree_Localised_en_US"."Locale" = ?
WHERE ("SiteTree_Live"."ID" = ?)
AND (("SiteTree_Localised_en_US"."ID" IS NOT NULL))
ORDER BY "SiteTree_Live"."Sort" ASC
LIMIT 1
0.0012s
ETIAS: how to travel Europe without a visa
Visit the EU and Schengen Area visa-free Visit the EU and Schengen Area visa-free
Your electronic travel permit for 34 countries! Simple, fast, and secure - starting 2025!
Apply for your travel authorization from 2025 on!
Apply for your - travel authorization from 2025 on!
Choose your destination and learn all about your future ETIAS application process.
ETIAS (short for “European Travel Information and Authorisation System”) is an electronic travel authorization made for EU and Schengen Area visitors from visa-exempt third countries. The new system will be implemented in 2025.
ETIAS can be used to visit the EU or Schengen countries for tourism, short business trips, medical travel, and transits for up to 90 days. However, ETIAS is not a visa but a visa waiver scheme, just like ESTA in the USA.
The main difference between ETIAS and a visa is the fully digitized and automated process which makes ETIAS much easier, faster, and cheaper to get than a classic visa from the consulates and embassies of the individual EU and Schengen countries.
With ETIAS, you don’t need to visit an embassy or submit your biometric data. All you have to do is complete a ten-minute online application before you travel, pay a € 7 fee, and wait for your authorization.
Which countries can I visit with ETIAS?
More than 30 countries are planning to participate in the ETIAS program. These include:
1The visa exemption applies only to holders of biometric passports.
2Excluding holders of Serbian passports issued by the Serbian Coordination Directorate (in Serbian: Koordinaciona uprava)
3The visa exemption applies only to holders of a "Hong Kong Special Administrative Region" passport.
4The visa exemption applies only to holders of a "Região Administrativa Especial de Macau" passport.
5The exemption from the visa requirement applies only to holders of passports issued by Taiwan which include an identity card number.
6Including British Overseas Nationals (BOTC, BOC), British protected persons (BPP), and British Subjects (BS)
ETIAS travel authorization is available for the listed visa-exempt third-country nationals as well as people who:
are family members of European Union citizens or of third-country nationals who enjoy a right to free movement equivalent to that of Union citizens
are pupils with a nationality of a third country if they participate in a trip of certain travel groups
have refugee status or are stateless (under certain conditions)
are members of armed forces that travel within the framework of NATO or the Partnership for Peace and hold certain identity documents and deployment orders
What can I do with ETIAS in Europe?
ETIAS enables travelers to visit one or more EU and/or Schengen countries for up to 90 days in a row for tourism, business trips, medical treatments, or transit. Within the 3-year validity of your ETIAS, you can enter the EU or Schengen Area as often as you like but only stay for up to 90 days within a 180-day period.
Attention: You may not work or study in Europe with ETIAS. This would require a special visa from the respective country.
Who is exempt from ETIAS?
You can only enter the EU or Schengen Area and move freely between states without a visa or ETIAS if you:
are a citizen of the EU or participating Schengen states
are a citizen of the European microstates of Andorra, Monaco, San Marino, and Vatican City
hold a valid residence permit
can present a valid local border traffic permit
Furthermore, if you currently hold a Schengen visa, you do not need to apply for ETIAS. As soon as your visa has expired, you may request your ETIAS authorization.
ETIAS advice for Schengen visa holders
If you currently hold a Schengen visa, you do not need to apply for ETIAS. As soon as your visa has expired, you may request your ETIAS authorization.
What are the ETIAS requirements?
To get ETIAS approval to travel to the EU or Schengen countries, applicants must fulfill the following ETIAS requirements:
They must be nationals from one of the visa-waiver countries.
They must have a passport that is valid for at least three months after their leaving date.
They must have a debit or credit card.
They must plan to enter the EU or Schengen Area for touristic purposes, short business trips, medical travel, or transit for up to 90 days.
How much will ETIAS cost?
After the introduction of ETIAS as the European e-visa, entry into the EU and Schengen Area will cost € 7 for all previously visa-exempt travelers. Travelers under 18 or over 70 years will not have to pay the ETIAS fee but still get their travel authorization for free.
How does traveling with ETIAS work?
Because your ETIAS authorization will be linked to your passport data, you must carry both while traveling the EU and the Schengen states from 2025 on.
Upon arrival at the EU or Schengen outside borders, you will hand your travel documents to customs and border guards. Your passport will be electronically scanned and checked. Furthermore, border officials can ask some questions before you may cross the border.
Latest News
In a 2023 press release, the EU clarified that ETIAS travelers will not have to provide health information, vaccination records, or biometric data.
However, it says that travelers will have to answer some security questions so that the system can assess whether they pose a threat to the Schengen area and the EU. These include questions about criminal records and travel to conflict zones.
All applications will be checked against EU security databases before making a decision. According to the European Border and Coast Guard Agency (Frontex), 97% of applicants will have their ETIAS application processed and approved immediately.
The remaining 3% of applications will be manually reviewed by the ETIAS Central Unit and National Units to make a final decision.
Why is ETIAS necessary?
ETIAS is designed to identify potential threats associated with travelers before entering the EU or Schengen Area by subjecting applicants to a security check. Before ETIAS starts, travelers from 60 non-EU countries can still enter un-checked without a visa.
Thus, ETIAS is supposed to make life in the EU and the Schengen Area safer. The pre-travel check for third-country nationals coming to the European Union and the Schengen states combats identity fraud, misuse of travel documents, terrorism, and serious crime and reduces illegal migration.
Which data is stored for ETIAS?
When traveling with ETIAS, you will give personal data to the authorities for security reasons. The following information will be stored in the ETIAS system:
Your name(s)
Your date and place of birth
Your gender
Your nationality
Your parent’s names
Your passport details
Your contact information (email address, postal address, telephone number)
Your occupation and school education
The date and time of your application
A payment reference number
The following things will be checked upon your application and ETIAS approval:
Information on criminal convictions
Stays in war or conflict zones
The IP address from which the ETIAS application was submitted
ETIAS applicants will have the right to request access to the personal data stored, as well as for rectification, erasure, or completion of the personal data (Art. 55, Art. 64 ETIAS Regulation).
ETIAS will cross-check your data against several European databases, namely:
The Schengen Information System (SIS)
The Visa Information System (VIS)
Europol data
The Entry/Exit System (EES)
The Eurodac database
The Interpol Stolen and Lost Travel Document database (SLTD)
The Interpol Travel Documents Associated with Notices database (TDAWN)
A dedicated ETIAS watchlist and specific risk indicators
Should there be any concerns regarding your application, it will be processed manually.
How to apply for ETIAS?
The EU will soon provide a web service and mobile app for applicants to complete their ETIAS application forms. The services will be available in all official languages of the EU states.
You will go through the following steps when requesting your ETIAS:
Register with your email address
Enter your passport details
Enter your personal information
Answer all security questions truthfully
Pay the application fee of € 7
Submit your data and wait for approval
The data you provide will be checked in an automated process. After a short waiting period, you will receive the ETIAS travel authorization to print out and store with your passport.
How long does it take to get the ETIAS approval?
Completing the online application should take no more than 10 minutes. After submitting, the automatic approval is supposed to be issued within a few minutes or, as a maximum, up to 96 hours.
In rare cases, your application needs to be handled manually by the newly installed ETIAS Central Unit managed by Frontex and the ETIAS National Units. Should this be the case, the wait time for your ETIAS approval could be up to a month, and you might be contacted with further questions.
How long is ETIAS valid?
An ETIAS approval can be used for an unlimited number of entries over three years. However, you may not stay more than 90 days within 180 days.
What if ETIAS is denied?
Anyone whose ETIAS application is denied will have the right to appeal. In your refusal email message, you will find the reasons for your ETIAS denial and possible next steps.
You will need to consider if you want to re-apply (in the case of small mistakes), file an official appeal (in the case of unfounded reasons for denial that are based on you as a person), or get a visa instead (in the event of actual ineligibility).
