0002: SHOW DATABASES LIKE 'n245105\_cavedivingtulum.com'
0.0135s
0003: SELECT DISTINCT "Fluent_Domain"."ClassName", "Fluent_Domain"."LastEdited", "Fluent_Domain"."Created", "Fluent_Domain"."Domain", "Fluent_Domain"."DefaultLocaleID", "Fluent_Domain"."ID",
CASE WHEN "Fluent_Domain"."ClassName" IS NOT NULL THEN "Fluent_Domain"."ClassName"
ELSE 'TractorCow\\Fluent\\Model\\Domain' END AS "RecordClassName"
FROM "Fluent_Domain"
0.0002s
0004: SELECT DISTINCT "Fluent_Locale"."ClassName", "Fluent_Locale"."LastEdited", "Fluent_Locale"."Created", "Fluent_Locale"."Title", "Fluent_Locale"."Locale", "Fluent_Locale"."URLSegment", "Fluent_Locale"."IsGlobalDefault", "Fluent_Locale"."UseDefaultCode", "Fluent_Locale"."Sort", "Fluent_Locale"."Timezone", "Fluent_Locale"."DomainID", "Fluent_Locale"."ID",
CASE WHEN "Fluent_Locale"."ClassName" IS NOT NULL THEN "Fluent_Locale"."ClassName"
ELSE 'TractorCow\\Fluent\\Model\\Locale' END AS "RecordClassName"
FROM "Fluent_Locale"
ORDER BY "Fluent_Locale"."Sort" ASC, "Fluent_Locale"."Locale" ASC
0.0003s
0005: SELECT DISTINCT "Fluent_FallbackLocale"."ClassName", "Fluent_FallbackLocale"."LastEdited", "Fluent_FallbackLocale"."Created", "Fluent_FallbackLocale"."Sort", "Fluent_FallbackLocale"."ParentID", "Fluent_FallbackLocale"."LocaleID", "Fluent_FallbackLocale"."ID",
CASE WHEN "Fluent_FallbackLocale"."ClassName" IS NOT NULL THEN "Fluent_FallbackLocale"."ClassName"
ELSE 'TractorCow\\Fluent\\Model\\FallbackLocale' END AS "RecordClassName"
FROM "Fluent_FallbackLocale"
WHERE ("Fluent_FallbackLocale"."ParentID" = ?)
ORDER BY "Fluent_FallbackLocale"."Sort" ASC
0.0004s
0006: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", "SiteTree_Live"."ShowInSitemap", "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_Live"."ParentID" = ?)
AND (("SiteTree_Localised_en_US"."ID" IS NOT NULL))
ORDER BY "SiteTree_Live"."Sort" ASC
LIMIT 1
0.0013s
0007: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", "SiteTree_Live"."ShowInSitemap", "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" = ?)
AND (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.0007s
0008: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", "SiteTree_Live"."ShowInSitemap", "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" = ?)
AND (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.0006s
0009: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", "SiteTree_Live"."ShowInSitemap", "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.0003s
0010: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", "SiteTree_Live"."ShowInSitemap", "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.0002s
0011: SELECT DISTINCT "SiteConfig"."ClassName", "SiteConfig"."LastEdited", "SiteConfig"."Created", "SiteConfig"."GoogleAnalytics", "SiteConfig"."FacebookPixel", "SiteConfig"."TwitterPixel", "SiteConfig"."SnapPixel", "SiteConfig"."TwitterAccountName", "SiteConfig"."Email", "SiteConfig"."Phone", "SiteConfig"."Title", "SiteConfig"."Tagline", "SiteConfig"."CanViewType", "SiteConfig"."CanEditType", "SiteConfig"."CanCreateTopLevelType", "SiteConfig"."ID",
CASE WHEN "SiteConfig"."ClassName" IS NOT NULL THEN "SiteConfig"."ClassName"
ELSE 'SilverStripe\\SiteConfig\\SiteConfig' END AS "RecordClassName"
FROM "SiteConfig"
LIMIT 1
0.0002s
0012: SELECT "ID"
FROM "SiteTree_Localised_Live"
WHERE ("RecordID" = ?)
AND ("Locale" = ?)
LIMIT 1
0.0001s
0013: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", "SiteTree_Live"."ShowInSitemap", "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"."FacebookPageType"
ELSE "Page_Live"."FacebookPageType" END
AS "FacebookPageType", CASE
WHEN "Page_Localised_en_US"."ID" IS NOT NULL THEN "Page_Localised_en_US"."FacebookPageTitle"
ELSE "Page_Live"."FacebookPageTitle" END
AS "FacebookPageTitle", CASE
WHEN "Page_Localised_en_US"."ID" IS NOT NULL THEN "Page_Localised_en_US"."FacebookPageDescription"
ELSE "Page_Live"."FacebookPageDescription" END
AS "FacebookPageDescription", CASE
WHEN "Page_Localised_en_US"."ID" IS NOT NULL THEN "Page_Localised_en_US"."TwitterPageTitle"
ELSE "Page_Live"."TwitterPageTitle" END
AS "TwitterPageTitle", CASE
WHEN "Page_Localised_en_US"."ID" IS NOT NULL THEN "Page_Localised_en_US"."TwitterPageDescription"
ELSE "Page_Live"."TwitterPageDescription" END
AS "TwitterPageDescription", CASE
WHEN "Page_Localised_en_US"."ID" IS NOT NULL THEN "Page_Localised_en_US"."FocusKeyword"
ELSE "Page_Live"."FocusKeyword" END
AS "FocusKeyword", CASE
WHEN "Page_Localised_en_US"."ID" IS NOT NULL THEN "Page_Localised_en_US"."SubTitle"
ELSE "Page_Live"."SubTitle" END
AS "SubTitle", CASE
WHEN "Page_Localised_en_US"."ID" IS NOT NULL THEN "Page_Localised_en_US"."Summary"
ELSE "Page_Live"."Summary" END
AS "Summary", CASE
WHEN "Page_Localised_en_US"."ID" IS NOT NULL THEN "Page_Localised_en_US"."PreContent"
ELSE "Page_Live"."PreContent" END
AS "PreContent", "Page_Live"."GridCols", "Page_Live"."PageLayout", "Page_Live"."Production", "Page_Live"."Photography", "Page_Live"."GroupTrip", "Page_Live"."CaveDiving", "Page_Live"."CavernDiving", "Page_Live"."Training", "Page_Live"."FacebookPageImageID", "Page_Live"."TwitterPageImageID", "Page_Live"."CreatorID", "Page_Live"."HeaderImageID", "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.0005s
0014: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", "SiteTree_Live"."ShowInSitemap", "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.0002s
0015: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", "SiteTree_Live"."ShowInSitemap", "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.0002s
0016: SELECT "ID"
FROM "SiteTree_Localised_Live"
WHERE ("RecordID" = ?)
AND ("Locale" = ?)
LIMIT 1
0.0001s
0017: SELECT DISTINCT "Fluent_FallbackLocale"."ClassName", "Fluent_FallbackLocale"."LastEdited", "Fluent_FallbackLocale"."Created", "Fluent_FallbackLocale"."Sort", "Fluent_FallbackLocale"."ParentID", "Fluent_FallbackLocale"."LocaleID", "Fluent_FallbackLocale"."ID",
CASE WHEN "Fluent_FallbackLocale"."ClassName" IS NOT NULL THEN "Fluent_FallbackLocale"."ClassName"
ELSE 'TractorCow\\Fluent\\Model\\FallbackLocale' END AS "RecordClassName"
FROM "Fluent_FallbackLocale"
WHERE ("Fluent_FallbackLocale"."ParentID" = ?)
ORDER BY "Fluent_FallbackLocale"."Sort" ASC
0.0001s
0018: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", "SiteTree_Live"."ShowInSitemap", "SiteTree_Live"."CanViewType", "SiteTree_Live"."CanEditType", "SiteTree_Live"."Version", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."URLSegment"
ELSE "SiteTree_Live"."URLSegment" END
AS "URLSegment", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."Title"
ELSE "SiteTree_Live"."Title" END
AS "Title", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."MenuTitle"
ELSE "SiteTree_Live"."MenuTitle" END
AS "MenuTitle", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."Content"
ELSE "SiteTree_Live"."Content" END
AS "Content", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."MetaDescription"
ELSE "SiteTree_Live"."MetaDescription" END
AS "MetaDescription", "SiteTree_Live"."ExtraMeta", "SiteTree_Live"."ShowInMenus", "SiteTree_Live"."ShowInSearch", "SiteTree_Live"."Sort", "SiteTree_Live"."HasBrokenFile", "SiteTree_Live"."HasBrokenLink", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."ReportClass"
ELSE "SiteTree_Live"."ReportClass" END
AS "ReportClass", "SiteTree_Live"."ParentID", CASE
WHEN "Page_Localised_de_DE"."ID" IS NOT NULL THEN "Page_Localised_de_DE"."FacebookPageType"
ELSE "Page_Live"."FacebookPageType" END
AS "FacebookPageType", CASE
WHEN "Page_Localised_de_DE"."ID" IS NOT NULL THEN "Page_Localised_de_DE"."FacebookPageTitle"
ELSE "Page_Live"."FacebookPageTitle" END
AS "FacebookPageTitle", CASE
WHEN "Page_Localised_de_DE"."ID" IS NOT NULL THEN "Page_Localised_de_DE"."FacebookPageDescription"
ELSE "Page_Live"."FacebookPageDescription" END
AS "FacebookPageDescription", CASE
WHEN "Page_Localised_de_DE"."ID" IS NOT NULL THEN "Page_Localised_de_DE"."TwitterPageTitle"
ELSE "Page_Live"."TwitterPageTitle" END
AS "TwitterPageTitle", CASE
WHEN "Page_Localised_de_DE"."ID" IS NOT NULL THEN "Page_Localised_de_DE"."TwitterPageDescription"
ELSE "Page_Live"."TwitterPageDescription" END
AS "TwitterPageDescription", CASE
WHEN "Page_Localised_de_DE"."ID" IS NOT NULL THEN "Page_Localised_de_DE"."FocusKeyword"
ELSE "Page_Live"."FocusKeyword" END
AS "FocusKeyword", CASE
WHEN "Page_Localised_de_DE"."ID" IS NOT NULL THEN "Page_Localised_de_DE"."SubTitle"
ELSE "Page_Live"."SubTitle" END
AS "SubTitle", CASE
WHEN "Page_Localised_de_DE"."ID" IS NOT NULL THEN "Page_Localised_de_DE"."Summary"
ELSE "Page_Live"."Summary" END
AS "Summary", CASE
WHEN "Page_Localised_de_DE"."ID" IS NOT NULL THEN "Page_Localised_de_DE"."PreContent"
ELSE "Page_Live"."PreContent" END
AS "PreContent", "Page_Live"."GridCols", "Page_Live"."PageLayout", "Page_Live"."Production", "Page_Live"."Photography", "Page_Live"."GroupTrip", "Page_Live"."CaveDiving", "Page_Live"."CavernDiving", "Page_Live"."Training", "Page_Live"."FacebookPageImageID", "Page_Live"."TwitterPageImageID", "Page_Live"."CreatorID", "Page_Live"."HeaderImageID", "SiteTree_Live"."ID",
CASE WHEN "SiteTree_Live"."ClassName" IS NOT NULL THEN "SiteTree_Live"."ClassName"
ELSE 'SilverStripe\\CMS\\Model\\SiteTree' END AS "RecordClassName", 'de_DE' AS "Locale", CASE WHEN "Page_Localised_de_DE"."ID" IS NOT NULL THEN 'de_DE'
ELSE NULL END AS "SourceLocale"
FROM "SiteTree_Live" LEFT JOIN "Page_Live" ON "Page_Live"."ID" = "SiteTree_Live"."ID" LEFT JOIN "SiteTree_Localised_Live" AS "SiteTree_Localised_de_DE" ON "SiteTree_Live"."ID" = "SiteTree_Localised_de_DE"."RecordID" AND "SiteTree_Localised_de_DE"."Locale" = ? LEFT JOIN "Page_Localised_Live" AS "Page_Localised_de_DE" ON "Page_Live"."ID" = "Page_Localised_de_DE"."RecordID" AND "Page_Localised_de_DE"."Locale" = ?
WHERE ("SiteTree_Live"."ID" = ?)
AND ("SiteTree_Live"."ClassName" IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?))
AND (("SiteTree_Localised_de_DE"."ID" IS NOT NULL))
ORDER BY "SiteTree_Live"."Sort" ASC
LIMIT 1
0.0004s
0019: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", "SiteTree_Live"."ShowInSitemap", "SiteTree_Live"."CanViewType", "SiteTree_Live"."CanEditType", "SiteTree_Live"."Version", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."URLSegment"
ELSE "SiteTree_Live"."URLSegment" END
AS "URLSegment", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."Title"
ELSE "SiteTree_Live"."Title" END
AS "Title", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."MenuTitle"
ELSE "SiteTree_Live"."MenuTitle" END
AS "MenuTitle", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."Content"
ELSE "SiteTree_Live"."Content" END
AS "Content", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."MetaDescription"
ELSE "SiteTree_Live"."MetaDescription" END
AS "MetaDescription", "SiteTree_Live"."ExtraMeta", "SiteTree_Live"."ShowInMenus", "SiteTree_Live"."ShowInSearch", "SiteTree_Live"."Sort", "SiteTree_Live"."HasBrokenFile", "SiteTree_Live"."HasBrokenLink", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."ReportClass"
ELSE "SiteTree_Live"."ReportClass" END
AS "ReportClass", "SiteTree_Live"."ParentID", "SiteTree_Live"."ID",
CASE WHEN "SiteTree_Live"."ClassName" IS NOT NULL THEN "SiteTree_Live"."ClassName"
ELSE 'SilverStripe\\CMS\\Model\\SiteTree' END AS "RecordClassName", 'de_DE' AS "Locale", CASE WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN 'de_DE'
ELSE NULL END AS "SourceLocale"
FROM "SiteTree_Live" LEFT JOIN "SiteTree_Localised_Live" AS "SiteTree_Localised_de_DE" ON "SiteTree_Live"."ID" = "SiteTree_Localised_de_DE"."RecordID" AND "SiteTree_Localised_de_DE"."Locale" = ?
WHERE ("SiteTree_Live"."ID" = ?)
AND (("SiteTree_Localised_de_DE"."ID" IS NOT NULL))
ORDER BY "SiteTree_Live"."Sort" ASC
LIMIT 1
0.0003s
0020: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", "SiteTree_Live"."ShowInSitemap", "SiteTree_Live"."CanViewType", "SiteTree_Live"."CanEditType", "SiteTree_Live"."Version", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."URLSegment"
ELSE "SiteTree_Live"."URLSegment" END
AS "URLSegment", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."Title"
ELSE "SiteTree_Live"."Title" END
AS "Title", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."MenuTitle"
ELSE "SiteTree_Live"."MenuTitle" END
AS "MenuTitle", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."Content"
ELSE "SiteTree_Live"."Content" END
AS "Content", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."MetaDescription"
ELSE "SiteTree_Live"."MetaDescription" END
AS "MetaDescription", "SiteTree_Live"."ExtraMeta", "SiteTree_Live"."ShowInMenus", "SiteTree_Live"."ShowInSearch", "SiteTree_Live"."Sort", "SiteTree_Live"."HasBrokenFile", "SiteTree_Live"."HasBrokenLink", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."ReportClass"
ELSE "SiteTree_Live"."ReportClass" END
AS "ReportClass", "SiteTree_Live"."ParentID", "SiteTree_Live"."ID",
CASE WHEN "SiteTree_Live"."ClassName" IS NOT NULL THEN "SiteTree_Live"."ClassName"
ELSE 'SilverStripe\\CMS\\Model\\SiteTree' END AS "RecordClassName", 'de_DE' AS "Locale", CASE WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN 'de_DE'
ELSE NULL END AS "SourceLocale"
FROM "SiteTree_Live" LEFT JOIN "SiteTree_Localised_Live" AS "SiteTree_Localised_de_DE" ON "SiteTree_Live"."ID" = "SiteTree_Localised_de_DE"."RecordID" AND "SiteTree_Localised_de_DE"."Locale" = ?
WHERE ("SiteTree_Live"."ID" = ?)
AND (("SiteTree_Localised_de_DE"."ID" IS NOT NULL))
ORDER BY "SiteTree_Live"."Sort" ASC
LIMIT 1
0.0002s
0021: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", CASE
WHEN "Page_Localised_en_US"."ID" IS NOT NULL THEN "Page_Localised_en_US"."FacebookPageType"
ELSE "Page_Live"."FacebookPageType" END
AS "FacebookPageType", CASE
WHEN "Page_Localised_en_US"."ID" IS NOT NULL THEN "Page_Localised_en_US"."FacebookPageTitle"
ELSE "Page_Live"."FacebookPageTitle" END
AS "FacebookPageTitle", CASE
WHEN "Page_Localised_en_US"."ID" IS NOT NULL THEN "Page_Localised_en_US"."FacebookPageDescription"
ELSE "Page_Live"."FacebookPageDescription" END
AS "FacebookPageDescription", CASE
WHEN "Page_Localised_en_US"."ID" IS NOT NULL THEN "Page_Localised_en_US"."TwitterPageTitle"
ELSE "Page_Live"."TwitterPageTitle" END
AS "TwitterPageTitle", CASE
WHEN "Page_Localised_en_US"."ID" IS NOT NULL THEN "Page_Localised_en_US"."TwitterPageDescription"
ELSE "Page_Live"."TwitterPageDescription" END
AS "TwitterPageDescription", CASE
WHEN "Page_Localised_en_US"."ID" IS NOT NULL THEN "Page_Localised_en_US"."FocusKeyword"
ELSE "Page_Live"."FocusKeyword" END
AS "FocusKeyword", CASE
WHEN "Page_Localised_en_US"."ID" IS NOT NULL THEN "Page_Localised_en_US"."SubTitle"
ELSE "Page_Live"."SubTitle" END
AS "SubTitle", CASE
WHEN "Page_Localised_en_US"."ID" IS NOT NULL THEN "Page_Localised_en_US"."Summary"
ELSE "Page_Live"."Summary" END
AS "Summary", CASE
WHEN "Page_Localised_en_US"."ID" IS NOT NULL THEN "Page_Localised_en_US"."PreContent"
ELSE "Page_Live"."PreContent" END
AS "PreContent", "Page_Live"."GridCols", "Page_Live"."PageLayout", "Page_Live"."Production", "Page_Live"."Photography", "Page_Live"."GroupTrip", "Page_Live"."CaveDiving", "Page_Live"."CavernDiving", "Page_Live"."Training", "Page_Live"."FacebookPageImageID", "Page_Live"."TwitterPageImageID", "Page_Live"."CreatorID", "Page_Live"."HeaderImageID", "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.0004s
0022: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", "SiteTree_Live"."ShowInSitemap", "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.0008s
0023: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", "SiteTree_Live"."ShowInSitemap", "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.0003s
0024: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", "SiteTree_Live"."ShowInSitemap", "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.0002s
0025: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", "SiteTree_Live"."ShowInSitemap", "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.0005s
0026: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", "SiteTree_Live"."ShowInSitemap", "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.0003s
0027: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", "SiteTree_Live"."ShowInSitemap", "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.0002s
0028: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", "SiteTree_Live"."ShowInSitemap", "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.0002s
0029: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", "SiteTree_Live"."ShowInSitemap", "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.0005s
0030: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", "SiteTree_Live"."ShowInSitemap", "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.0003s
0031: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", "SiteTree_Live"."ShowInSitemap", "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.0002s
0032: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", "SiteTree_Live"."ShowInSitemap", "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.0002s
0033: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", "SiteTree_Live"."ShowInSitemap", "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.0008s
0034: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", "SiteTree_Live"."ShowInSitemap", "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.0003s
0035: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", "SiteTree_Live"."ShowInSitemap", "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.0002s
0036: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", "SiteTree_Live"."ShowInSitemap", "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.0002s
0037: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", "SiteTree_Live"."ShowInSitemap", "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.0006s
0038: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", "SiteTree_Live"."ShowInSitemap", "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.0002s
0039: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", "SiteTree_Live"."ShowInSitemap", "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.0002s
0040: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", "SiteTree_Live"."ShowInSitemap", "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.0002s
0041: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", "SiteTree_Live"."ShowInSitemap", "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.0002s
0042: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", "SiteTree_Live"."ShowInSitemap", "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.0002s
0043: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", "SiteTree_Live"."ShowInSitemap", "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.0005s
0044: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", "SiteTree_Live"."ShowInSitemap", "SiteTree_Live"."CanViewType", "SiteTree_Live"."CanEditType", "SiteTree_Live"."Version", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."URLSegment"
ELSE "SiteTree_Live"."URLSegment" END
AS "URLSegment", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."Title"
ELSE "SiteTree_Live"."Title" END
AS "Title", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."MenuTitle"
ELSE "SiteTree_Live"."MenuTitle" END
AS "MenuTitle", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."Content"
ELSE "SiteTree_Live"."Content" END
AS "Content", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."MetaDescription"
ELSE "SiteTree_Live"."MetaDescription" END
AS "MetaDescription", "SiteTree_Live"."ExtraMeta", "SiteTree_Live"."ShowInMenus", "SiteTree_Live"."ShowInSearch", "SiteTree_Live"."Sort", "SiteTree_Live"."HasBrokenFile", "SiteTree_Live"."HasBrokenLink", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."ReportClass"
ELSE "SiteTree_Live"."ReportClass" END
AS "ReportClass", "SiteTree_Live"."ParentID", CASE
WHEN "Page_Localised_de_DE"."ID" IS NOT NULL THEN "Page_Localised_de_DE"."FacebookPageType"
ELSE "Page_Live"."FacebookPageType" END
AS "FacebookPageType", CASE
WHEN "Page_Localised_de_DE"."ID" IS NOT NULL THEN "Page_Localised_de_DE"."FacebookPageTitle"
ELSE "Page_Live"."FacebookPageTitle" END
AS "FacebookPageTitle", CASE
WHEN "Page_Localised_de_DE"."ID" IS NOT NULL THEN "Page_Localised_de_DE"."FacebookPageDescription"
ELSE "Page_Live"."FacebookPageDescription" END
AS "FacebookPageDescription", CASE
WHEN "Page_Localised_de_DE"."ID" IS NOT NULL THEN "Page_Localised_de_DE"."TwitterPageTitle"
ELSE "Page_Live"."TwitterPageTitle" END
AS "TwitterPageTitle", CASE
WHEN "Page_Localised_de_DE"."ID" IS NOT NULL THEN "Page_Localised_de_DE"."TwitterPageDescription"
ELSE "Page_Live"."TwitterPageDescription" END
AS "TwitterPageDescription", CASE
WHEN "Page_Localised_de_DE"."ID" IS NOT NULL THEN "Page_Localised_de_DE"."FocusKeyword"
ELSE "Page_Live"."FocusKeyword" END
AS "FocusKeyword", CASE
WHEN "Page_Localised_de_DE"."ID" IS NOT NULL THEN "Page_Localised_de_DE"."SubTitle"
ELSE "Page_Live"."SubTitle" END
AS "SubTitle", CASE
WHEN "Page_Localised_de_DE"."ID" IS NOT NULL THEN "Page_Localised_de_DE"."Summary"
ELSE "Page_Live"."Summary" END
AS "Summary", CASE
WHEN "Page_Localised_de_DE"."ID" IS NOT NULL THEN "Page_Localised_de_DE"."PreContent"
ELSE "Page_Live"."PreContent" END
AS "PreContent", "Page_Live"."GridCols", "Page_Live"."PageLayout", "Page_Live"."Production", "Page_Live"."Photography", "Page_Live"."GroupTrip", "Page_Live"."CaveDiving", "Page_Live"."CavernDiving", "Page_Live"."Training", "Page_Live"."FacebookPageImageID", "Page_Live"."TwitterPageImageID", "Page_Live"."CreatorID", "Page_Live"."HeaderImageID", "SiteTree_Live"."ID",
CASE WHEN "SiteTree_Live"."ClassName" IS NOT NULL THEN "SiteTree_Live"."ClassName"
ELSE 'SilverStripe\\CMS\\Model\\SiteTree' END AS "RecordClassName", 'de_DE' AS "Locale", CASE WHEN "Page_Localised_de_DE"."ID" IS NOT NULL THEN 'de_DE'
ELSE NULL END AS "SourceLocale"
FROM "SiteTree_Live" LEFT JOIN "Page_Live" ON "Page_Live"."ID" = "SiteTree_Live"."ID" LEFT JOIN "SiteTree_Localised_Live" AS "SiteTree_Localised_de_DE" ON "SiteTree_Live"."ID" = "SiteTree_Localised_de_DE"."RecordID" AND "SiteTree_Localised_de_DE"."Locale" = ? LEFT JOIN "Page_Localised_Live" AS "Page_Localised_de_DE" ON "Page_Live"."ID" = "Page_Localised_de_DE"."RecordID" AND "Page_Localised_de_DE"."Locale" = ?
WHERE ("SiteTree_Live"."ID" = ?)
AND ("SiteTree_Live"."ClassName" IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?))
AND (("SiteTree_Localised_de_DE"."ID" IS NOT NULL))
ORDER BY "SiteTree_Live"."Sort" ASC
LIMIT 1
0.0005s
0045: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", "SiteTree_Live"."ShowInSitemap", "SiteTree_Live"."CanViewType", "SiteTree_Live"."CanEditType", "SiteTree_Live"."Version", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."URLSegment"
ELSE "SiteTree_Live"."URLSegment" END
AS "URLSegment", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."Title"
ELSE "SiteTree_Live"."Title" END
AS "Title", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."MenuTitle"
ELSE "SiteTree_Live"."MenuTitle" END
AS "MenuTitle", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."Content"
ELSE "SiteTree_Live"."Content" END
AS "Content", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."MetaDescription"
ELSE "SiteTree_Live"."MetaDescription" END
AS "MetaDescription", "SiteTree_Live"."ExtraMeta", "SiteTree_Live"."ShowInMenus", "SiteTree_Live"."ShowInSearch", "SiteTree_Live"."Sort", "SiteTree_Live"."HasBrokenFile", "SiteTree_Live"."HasBrokenLink", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."ReportClass"
ELSE "SiteTree_Live"."ReportClass" END
AS "ReportClass", "SiteTree_Live"."ParentID", "SiteTree_Live"."ID",
CASE WHEN "SiteTree_Live"."ClassName" IS NOT NULL THEN "SiteTree_Live"."ClassName"
ELSE 'SilverStripe\\CMS\\Model\\SiteTree' END AS "RecordClassName", 'de_DE' AS "Locale", CASE WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN 'de_DE'
ELSE NULL END AS "SourceLocale"
FROM "SiteTree_Live" LEFT JOIN "SiteTree_Localised_Live" AS "SiteTree_Localised_de_DE" ON "SiteTree_Live"."ID" = "SiteTree_Localised_de_DE"."RecordID" AND "SiteTree_Localised_de_DE"."Locale" = ?
WHERE ("SiteTree_Live"."ID" = ?)
AND (("SiteTree_Localised_de_DE"."ID" IS NOT NULL))
ORDER BY "SiteTree_Live"."Sort" ASC
LIMIT 1
0.0002s
0046: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", "SiteTree_Live"."ShowInSitemap", "SiteTree_Live"."CanViewType", "SiteTree_Live"."CanEditType", "SiteTree_Live"."Version", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."URLSegment"
ELSE "SiteTree_Live"."URLSegment" END
AS "URLSegment", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."Title"
ELSE "SiteTree_Live"."Title" END
AS "Title", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."MenuTitle"
ELSE "SiteTree_Live"."MenuTitle" END
AS "MenuTitle", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."Content"
ELSE "SiteTree_Live"."Content" END
AS "Content", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."MetaDescription"
ELSE "SiteTree_Live"."MetaDescription" END
AS "MetaDescription", "SiteTree_Live"."ExtraMeta", "SiteTree_Live"."ShowInMenus", "SiteTree_Live"."ShowInSearch", "SiteTree_Live"."Sort", "SiteTree_Live"."HasBrokenFile", "SiteTree_Live"."HasBrokenLink", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."ReportClass"
ELSE "SiteTree_Live"."ReportClass" END
AS "ReportClass", "SiteTree_Live"."ParentID", "SiteTree_Live"."ID",
CASE WHEN "SiteTree_Live"."ClassName" IS NOT NULL THEN "SiteTree_Live"."ClassName"
ELSE 'SilverStripe\\CMS\\Model\\SiteTree' END AS "RecordClassName", 'de_DE' AS "Locale", CASE WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN 'de_DE'
ELSE NULL END AS "SourceLocale"
FROM "SiteTree_Live" LEFT JOIN "SiteTree_Localised_Live" AS "SiteTree_Localised_de_DE" ON "SiteTree_Live"."ID" = "SiteTree_Localised_de_DE"."RecordID" AND "SiteTree_Localised_de_DE"."Locale" = ?
WHERE ("SiteTree_Live"."ID" = ?)
AND (("SiteTree_Localised_de_DE"."ID" IS NOT NULL))
ORDER BY "SiteTree_Live"."Sort" ASC
LIMIT 1
0.0002s
0047: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", "SiteTree_Live"."ShowInSitemap", "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.0006s
0048: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", "SiteTree_Live"."ShowInSitemap", "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.0003s
0049: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", "SiteTree_Live"."ShowInSitemap", "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.0002s
0050: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", "SiteTree_Live"."ShowInSitemap", "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.0002s
0051: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", "SiteTree_Live"."ShowInSitemap", "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.0002s
0052: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", "SiteTree_Live"."ShowInSitemap", "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.0005s
0053: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", "SiteTree_Live"."ShowInSitemap", "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.0006s
0054: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", "SiteTree_Live"."ShowInSitemap", "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.0003s
0055: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", "SiteTree_Live"."ShowInSitemap", "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.0002s
0056: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", "SiteTree_Live"."ShowInSitemap", "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.0005s
0057: SELECT CASE WHEN EXISTS(SELECT *
FROM "SiteTree_Live" LEFT JOIN "Page_Live" ON "Page_Live"."ID" = "SiteTree_Live"."ID" INNER JOIN "Page_RelatedPages" ON "Page_RelatedPages"."ChildID" = "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 ("Page_RelatedPages"."PageID" = ?)
AND ("SiteTree_Live"."ClassName" IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?))
AND (("SiteTree_Localised_en_US"."ID" IS NOT NULL))) THEN 1 ELSE 0 END
0.0004s
0058: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", "SiteTree_Live"."ShowInSitemap", "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"."FacebookPageType"
ELSE "Page_Live"."FacebookPageType" END
AS "FacebookPageType", CASE
WHEN "Page_Localised_en_US"."ID" IS NOT NULL THEN "Page_Localised_en_US"."FacebookPageTitle"
ELSE "Page_Live"."FacebookPageTitle" END
AS "FacebookPageTitle", CASE
WHEN "Page_Localised_en_US"."ID" IS NOT NULL THEN "Page_Localised_en_US"."FacebookPageDescription"
ELSE "Page_Live"."FacebookPageDescription" END
AS "FacebookPageDescription", CASE
WHEN "Page_Localised_en_US"."ID" IS NOT NULL THEN "Page_Localised_en_US"."TwitterPageTitle"
ELSE "Page_Live"."TwitterPageTitle" END
AS "TwitterPageTitle", CASE
WHEN "Page_Localised_en_US"."ID" IS NOT NULL THEN "Page_Localised_en_US"."TwitterPageDescription"
ELSE "Page_Live"."TwitterPageDescription" END
AS "TwitterPageDescription", CASE
WHEN "Page_Localised_en_US"."ID" IS NOT NULL THEN "Page_Localised_en_US"."FocusKeyword"
ELSE "Page_Live"."FocusKeyword" END
AS "FocusKeyword", CASE
WHEN "Page_Localised_en_US"."ID" IS NOT NULL THEN "Page_Localised_en_US"."SubTitle"
ELSE "Page_Live"."SubTitle" END
AS "SubTitle", CASE
WHEN "Page_Localised_en_US"."ID" IS NOT NULL THEN "Page_Localised_en_US"."Summary"
ELSE "Page_Live"."Summary" END
AS "Summary", CASE
WHEN "Page_Localised_en_US"."ID" IS NOT NULL THEN "Page_Localised_en_US"."PreContent"
ELSE "Page_Live"."PreContent" END
AS "PreContent", "Page_Live"."GridCols", "Page_Live"."PageLayout", "Page_Live"."Production", "Page_Live"."Photography", "Page_Live"."GroupTrip", "Page_Live"."CaveDiving", "Page_Live"."CavernDiving", "Page_Live"."Training", "Page_Live"."FacebookPageImageID", "Page_Live"."TwitterPageImageID", "Page_Live"."CreatorID", "Page_Live"."HeaderImageID", "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" INNER JOIN "Page_RelatedPages" ON "Page_RelatedPages"."ChildID" = "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 ("Page_RelatedPages"."PageID" = ?)
AND ("SiteTree_Live"."ClassName" IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?))
AND (("SiteTree_Localised_en_US"."ID" IS NOT NULL))
ORDER BY "SiteTree_Live"."Sort" ASC
0.001s
0059: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", "SiteTree_Live"."ShowInSitemap", "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.0003s
0060: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", "SiteTree_Live"."ShowInSitemap", "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.0002s
0061: SELECT DISTINCT "File_Live"."ClassName", "File_Live"."LastEdited", "File_Live"."Created", "File_Live"."Version", "File_Live"."UserFormUpload", "File_Live"."CanViewType", "File_Live"."CanEditType", "File_Live"."Name", "File_Live"."Title", "File_Live"."ShowInSearch", "File_Live"."ParentID", "File_Live"."OwnerID", "File_Live"."FileHash", "File_Live"."FileFilename", "File_Live"."FileVariant", "File_Live"."ID",
CASE WHEN "File_Live"."ClassName" IS NOT NULL THEN "File_Live"."ClassName"
ELSE 'SilverStripe\\Assets\\File' END AS "RecordClassName"
FROM "File_Live"
WHERE ("File_Live"."ID" = ?)
AND ("File_Live"."ClassName" IN (?))
ORDER BY "File_Live"."Name" ASC
LIMIT 1
0.0002s
0062: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", "SiteTree_Live"."ShowInSitemap", "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.0002s
0063: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", "SiteTree_Live"."ShowInSitemap", "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.0002s
0064: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", "SiteTree_Live"."ShowInSitemap", "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"."FacebookPageType"
ELSE "Page_Live"."FacebookPageType" END
AS "FacebookPageType", CASE
WHEN "Page_Localised_en_US"."ID" IS NOT NULL THEN "Page_Localised_en_US"."FacebookPageTitle"
ELSE "Page_Live"."FacebookPageTitle" END
AS "FacebookPageTitle", CASE
WHEN "Page_Localised_en_US"."ID" IS NOT NULL THEN "Page_Localised_en_US"."FacebookPageDescription"
ELSE "Page_Live"."FacebookPageDescription" END
AS "FacebookPageDescription", CASE
WHEN "Page_Localised_en_US"."ID" IS NOT NULL THEN "Page_Localised_en_US"."TwitterPageTitle"
ELSE "Page_Live"."TwitterPageTitle" END
AS "TwitterPageTitle", CASE
WHEN "Page_Localised_en_US"."ID" IS NOT NULL THEN "Page_Localised_en_US"."TwitterPageDescription"
ELSE "Page_Live"."TwitterPageDescription" END
AS "TwitterPageDescription", CASE
WHEN "Page_Localised_en_US"."ID" IS NOT NULL THEN "Page_Localised_en_US"."FocusKeyword"
ELSE "Page_Live"."FocusKeyword" END
AS "FocusKeyword", CASE
WHEN "Page_Localised_en_US"."ID" IS NOT NULL THEN "Page_Localised_en_US"."SubTitle"
ELSE "Page_Live"."SubTitle" END
AS "SubTitle", CASE
WHEN "Page_Localised_en_US"."ID" IS NOT NULL THEN "Page_Localised_en_US"."Summary"
ELSE "Page_Live"."Summary" END
AS "Summary", CASE
WHEN "Page_Localised_en_US"."ID" IS NOT NULL THEN "Page_Localised_en_US"."PreContent"
ELSE "Page_Live"."PreContent" END
AS "PreContent", "Page_Live"."GridCols", "Page_Live"."PageLayout", "Page_Live"."Production", "Page_Live"."Photography", "Page_Live"."GroupTrip", "Page_Live"."CaveDiving", "Page_Live"."CavernDiving", "Page_Live"."Training", "Page_Live"."FacebookPageImageID", "Page_Live"."TwitterPageImageID", "Page_Live"."CreatorID", "Page_Live"."HeaderImageID", CASE
WHEN "UserDefinedForm_Localised_en_US"."ID" IS NOT NULL THEN "UserDefinedForm_Localised_en_US"."SubmitButtonText"
ELSE "UserDefinedForm_Live"."SubmitButtonText" END
AS "SubmitButtonText", CASE
WHEN "UserDefinedForm_Localised_en_US"."ID" IS NOT NULL THEN "UserDefinedForm_Localised_en_US"."ClearButtonText"
ELSE "UserDefinedForm_Live"."ClearButtonText" END
AS "ClearButtonText", CASE
WHEN "UserDefinedForm_Localised_en_US"."ID" IS NOT NULL THEN "UserDefinedForm_Localised_en_US"."OnCompleteMessage"
ELSE "UserDefinedForm_Live"."OnCompleteMessage" END
AS "OnCompleteMessage", "UserDefinedForm_Live"."ShowClearButton", "UserDefinedForm_Live"."DisableSaveSubmissions", "UserDefinedForm_Live"."EnableLiveValidation", "UserDefinedForm_Live"."DisplayErrorMessagesAtTop", "UserDefinedForm_Live"."DisableAuthenicatedFinishAction", "UserDefinedForm_Live"."DisableCsrfSecurityToken", "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 "UserDefinedForm_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 "UserDefinedForm_Live" ON "UserDefinedForm_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 "UserDefinedForm_Localised_Live" AS "UserDefinedForm_Localised_en_US" ON "UserDefinedForm_Live"."ID" = "UserDefinedForm_Localised_en_US"."RecordID" AND "UserDefinedForm_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.0005s
0065: SELECT DISTINCT "EditableFormField_Live"."ClassName", "EditableFormField_Live"."LastEdited", "EditableFormField_Live"."Created", "EditableFormField_Live"."Version", "EditableFormField_Live"."Name", "EditableFormField_Live"."Title", "EditableFormField_Live"."Default", "EditableFormField_Live"."Sort", "EditableFormField_Live"."Required", "EditableFormField_Live"."CustomErrorMessage", "EditableFormField_Live"."ExtraClass", "EditableFormField_Live"."RightTitle", "EditableFormField_Live"."ShowOnLoad", "EditableFormField_Live"."ShowInSummary", "EditableFormField_Live"."Placeholder", "EditableFormField_Live"."DisplayRulesConjunction", "EditableFormField_Live"."ParentID", "EditableFormField_Live"."ParentClass", "EditableFormField_Live"."ID",
CASE WHEN "EditableFormField_Live"."ClassName" IS NOT NULL THEN "EditableFormField_Live"."ClassName"
ELSE 'SilverStripe\\UserForms\\Model\\EditableFormField' END AS "RecordClassName"
FROM "EditableFormField_Live"
WHERE ("EditableFormField_Live"."ParentClass" IN ('SilverStripe\\UserForms\\Model\\UserDefinedForm'))
AND ("EditableFormField_Live"."ParentID" = ?)
ORDER BY "EditableFormField_Live"."Sort" ASC
0.0003s
0066: SELECT DISTINCT "EditableFormField_Live"."ClassName", "EditableFormField_Live"."LastEdited", "EditableFormField_Live"."Created", "EditableTextField_Live"."MinLength", "EditableTextField_Live"."MaxLength", "EditableTextField_Live"."Rows", "EditableTextField_Live"."Autocomplete", "EditableFormField_Live"."ID",
CASE WHEN "EditableFormField_Live"."ClassName" IS NOT NULL THEN "EditableFormField_Live"."ClassName"
ELSE 'SilverStripe\\UserForms\\Model\\EditableFormField' END AS "RecordClassName", "EditableFormField_Live"."Sort"
FROM "EditableFormField_Live" LEFT JOIN "EditableTextField_Live" ON "EditableTextField_Live"."ID" = "EditableFormField_Live"."ID"
WHERE ("EditableFormField_Live"."ID" = ?)
AND ("EditableFormField_Live"."ClassName" IN (?))
ORDER BY "EditableFormField_Live"."Sort" ASC
LIMIT 1
0.0002s
0067: SELECT DISTINCT "EditableFormField_Live"."ClassName", "EditableFormField_Live"."LastEdited", "EditableFormField_Live"."Created", "EditableTextField_Live"."MinLength", "EditableTextField_Live"."MaxLength", "EditableTextField_Live"."Rows", "EditableTextField_Live"."Autocomplete", "EditableFormField_Live"."ID",
CASE WHEN "EditableFormField_Live"."ClassName" IS NOT NULL THEN "EditableFormField_Live"."ClassName"
ELSE 'SilverStripe\\UserForms\\Model\\EditableFormField' END AS "RecordClassName", "EditableFormField_Live"."Sort"
FROM "EditableFormField_Live" LEFT JOIN "EditableTextField_Live" ON "EditableTextField_Live"."ID" = "EditableFormField_Live"."ID"
WHERE ("EditableFormField_Live"."ID" = ?)
AND ("EditableFormField_Live"."ClassName" IN (?))
ORDER BY "EditableFormField_Live"."Sort" ASC
LIMIT 1
0.0001s
0068: SELECT DISTINCT "EditableFormField_Live"."ClassName", "EditableFormField_Live"."LastEdited", "EditableFormField_Live"."Created", "EditableTextField_Live"."MinLength", "EditableTextField_Live"."MaxLength", "EditableTextField_Live"."Rows", "EditableTextField_Live"."Autocomplete", "EditableFormField_Live"."ID",
CASE WHEN "EditableFormField_Live"."ClassName" IS NOT NULL THEN "EditableFormField_Live"."ClassName"
ELSE 'SilverStripe\\UserForms\\Model\\EditableFormField' END AS "RecordClassName", "EditableFormField_Live"."Sort"
FROM "EditableFormField_Live" LEFT JOIN "EditableTextField_Live" ON "EditableTextField_Live"."ID" = "EditableFormField_Live"."ID"
WHERE ("EditableFormField_Live"."ID" = ?)
AND ("EditableFormField_Live"."ClassName" IN (?))
ORDER BY "EditableFormField_Live"."Sort" ASC
LIMIT 1
0.0001s
0069: SELECT "EditableFormField_Live"."Name", "EditableFormField_Live"."Sort" AS "_SortColumn0"
FROM "EditableFormField_Live"
WHERE ("EditableFormField_Live"."ParentClass" IN ('SilverStripe\\UserForms\\Model\\UserDefinedForm'))
AND ("EditableFormField_Live"."ParentID" = ?)
AND ("EditableFormField_Live"."Required" = ?)
ORDER BY "_SortColumn0" ASC
0.0001s
0070: SELECT DISTINCT "UserDefinedForm_EmailRecipient"."ClassName", "UserDefinedForm_EmailRecipient"."LastEdited", "UserDefinedForm_EmailRecipient"."Created", "UserDefinedForm_EmailRecipient"."EmailAddress", "UserDefinedForm_EmailRecipient"."EmailSubject", "UserDefinedForm_EmailRecipient"."EmailFrom", "UserDefinedForm_EmailRecipient"."EmailReplyTo", "UserDefinedForm_EmailRecipient"."EmailBody", "UserDefinedForm_EmailRecipient"."EmailBodyHtml", "UserDefinedForm_EmailRecipient"."EmailTemplate", "UserDefinedForm_EmailRecipient"."SendPlain", "UserDefinedForm_EmailRecipient"."HideFormData", "UserDefinedForm_EmailRecipient"."HideInvisibleFields", "UserDefinedForm_EmailRecipient"."CustomRulesCondition", "UserDefinedForm_EmailRecipient"."SendEmailFromFieldID", "UserDefinedForm_EmailRecipient"."SendEmailToFieldID", "UserDefinedForm_EmailRecipient"."SendEmailSubjectFieldID", "UserDefinedForm_EmailRecipient"."FormID", "UserDefinedForm_EmailRecipient"."FormClass", "UserDefinedForm_EmailRecipient"."ID",
CASE WHEN "UserDefinedForm_EmailRecipient"."ClassName" IS NOT NULL THEN "UserDefinedForm_EmailRecipient"."ClassName"
ELSE 'SilverStripe\\UserForms\\Model\\Recipient\\EmailRecipient' END AS "RecordClassName"
FROM "UserDefinedForm_EmailRecipient"
WHERE ("UserDefinedForm_EmailRecipient"."FormClass" IN ('SilverStripe\\UserForms\\Model\\UserDefinedForm'))
AND ("UserDefinedForm_EmailRecipient"."FormID" = ?)
0.0002s
0071: SELECT DISTINCT "EditableFormField_Live"."ClassName", "EditableFormField_Live"."LastEdited", "EditableFormField_Live"."Created", "EditableFormField_Live"."Version", "EditableFormField_Live"."Name", "EditableFormField_Live"."Title", "EditableFormField_Live"."Default", "EditableFormField_Live"."Sort", "EditableFormField_Live"."Required", "EditableFormField_Live"."CustomErrorMessage", "EditableFormField_Live"."ExtraClass", "EditableFormField_Live"."RightTitle", "EditableFormField_Live"."ShowOnLoad", "EditableFormField_Live"."ShowInSummary", "EditableFormField_Live"."Placeholder", "EditableFormField_Live"."DisplayRulesConjunction", "EditableFormField_Live"."ParentID", "EditableFormField_Live"."ParentClass", "EditableFormField_Live"."ID",
CASE WHEN "EditableFormField_Live"."ClassName" IS NOT NULL THEN "EditableFormField_Live"."ClassName"
ELSE 'SilverStripe\\UserForms\\Model\\EditableFormField' END AS "RecordClassName"
FROM "EditableFormField_Live"
WHERE ("EditableFormField_Live"."ID" = ?)
ORDER BY "EditableFormField_Live"."Sort" ASC
LIMIT 1
0.0001s
0072: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", "SiteTree_Live"."ShowInSitemap", "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.0002s
0073: SELECT DISTINCT "EditableFormField_Live"."ClassName", "EditableFormField_Live"."LastEdited", "EditableFormField_Live"."Created", "EditableFormField_Live"."Version", "EditableFormField_Live"."Name", "EditableFormField_Live"."Title", "EditableFormField_Live"."Default", "EditableFormField_Live"."Sort", "EditableFormField_Live"."Required", "EditableFormField_Live"."CustomErrorMessage", "EditableFormField_Live"."ExtraClass", "EditableFormField_Live"."RightTitle", "EditableFormField_Live"."ShowOnLoad", "EditableFormField_Live"."ShowInSummary", "EditableFormField_Live"."Placeholder", "EditableFormField_Live"."DisplayRulesConjunction", "EditableFormField_Live"."ParentID", "EditableFormField_Live"."ParentClass", "EditableFormField_Live"."ID",
CASE WHEN "EditableFormField_Live"."ClassName" IS NOT NULL THEN "EditableFormField_Live"."ClassName"
ELSE 'SilverStripe\\UserForms\\Model\\EditableFormField' END AS "RecordClassName"
FROM "EditableFormField_Live"
WHERE ("EditableFormField_Live"."ParentClass" IN ('SilverStripe\\UserForms\\Model\\UserDefinedForm'))
AND ("EditableFormField_Live"."ParentID" = ?)
ORDER BY "EditableFormField_Live"."Sort" ASC
0.0002s
0074: SELECT DISTINCT "EditableCustomRule_Live"."ClassName", "EditableCustomRule_Live"."LastEdited", "EditableCustomRule_Live"."Created", "EditableCustomRule_Live"."Version", "EditableCustomRule_Live"."Display", "EditableCustomRule_Live"."ConditionOption", "EditableCustomRule_Live"."FieldValue", "EditableCustomRule_Live"."ParentID", "EditableCustomRule_Live"."ConditionFieldID", "EditableCustomRule_Live"."ID",
CASE WHEN "EditableCustomRule_Live"."ClassName" IS NOT NULL THEN "EditableCustomRule_Live"."ClassName"
ELSE 'SilverStripe\\UserForms\\Model\\EditableCustomRule' END AS "RecordClassName"
FROM "EditableCustomRule_Live"
WHERE ("EditableCustomRule_Live"."ParentID" = ?)
0.0001s
0075: SELECT DISTINCT "EditableCustomRule_Live"."ClassName", "EditableCustomRule_Live"."LastEdited", "EditableCustomRule_Live"."Created", "EditableCustomRule_Live"."Version", "EditableCustomRule_Live"."Display", "EditableCustomRule_Live"."ConditionOption", "EditableCustomRule_Live"."FieldValue", "EditableCustomRule_Live"."ParentID", "EditableCustomRule_Live"."ConditionFieldID", "EditableCustomRule_Live"."ID",
CASE WHEN "EditableCustomRule_Live"."ClassName" IS NOT NULL THEN "EditableCustomRule_Live"."ClassName"
ELSE 'SilverStripe\\UserForms\\Model\\EditableCustomRule' END AS "RecordClassName"
FROM "EditableCustomRule_Live"
WHERE ("EditableCustomRule_Live"."ParentID" = ?)
0.0001s
0076: SELECT DISTINCT "EditableCustomRule_Live"."ClassName", "EditableCustomRule_Live"."LastEdited", "EditableCustomRule_Live"."Created", "EditableCustomRule_Live"."Version", "EditableCustomRule_Live"."Display", "EditableCustomRule_Live"."ConditionOption", "EditableCustomRule_Live"."FieldValue", "EditableCustomRule_Live"."ParentID", "EditableCustomRule_Live"."ConditionFieldID", "EditableCustomRule_Live"."ID",
CASE WHEN "EditableCustomRule_Live"."ClassName" IS NOT NULL THEN "EditableCustomRule_Live"."ClassName"
ELSE 'SilverStripe\\UserForms\\Model\\EditableCustomRule' END AS "RecordClassName"
FROM "EditableCustomRule_Live"
WHERE ("EditableCustomRule_Live"."ParentID" = ?)
0.0001s
0077: SELECT DISTINCT "EditableCustomRule_Live"."ClassName", "EditableCustomRule_Live"."LastEdited", "EditableCustomRule_Live"."Created", "EditableCustomRule_Live"."Version", "EditableCustomRule_Live"."Display", "EditableCustomRule_Live"."ConditionOption", "EditableCustomRule_Live"."FieldValue", "EditableCustomRule_Live"."ParentID", "EditableCustomRule_Live"."ConditionFieldID", "EditableCustomRule_Live"."ID",
CASE WHEN "EditableCustomRule_Live"."ClassName" IS NOT NULL THEN "EditableCustomRule_Live"."ClassName"
ELSE 'SilverStripe\\UserForms\\Model\\EditableCustomRule' END AS "RecordClassName"
FROM "EditableCustomRule_Live"
WHERE ("EditableCustomRule_Live"."ParentID" = ?)
0.0001s
0078: SELECT DISTINCT "EditableCustomRule_Live"."ClassName", "EditableCustomRule_Live"."LastEdited", "EditableCustomRule_Live"."Created", "EditableCustomRule_Live"."Version", "EditableCustomRule_Live"."Display", "EditableCustomRule_Live"."ConditionOption", "EditableCustomRule_Live"."FieldValue", "EditableCustomRule_Live"."ParentID", "EditableCustomRule_Live"."ConditionFieldID", "EditableCustomRule_Live"."ID",
CASE WHEN "EditableCustomRule_Live"."ClassName" IS NOT NULL THEN "EditableCustomRule_Live"."ClassName"
ELSE 'SilverStripe\\UserForms\\Model\\EditableCustomRule' END AS "RecordClassName"
FROM "EditableCustomRule_Live"
WHERE ("EditableCustomRule_Live"."ParentID" = ?)
0.0001s
0079: SELECT DISTINCT "EditableCustomRule_Live"."ClassName", "EditableCustomRule_Live"."LastEdited", "EditableCustomRule_Live"."Created", "EditableCustomRule_Live"."Version", "EditableCustomRule_Live"."Display", "EditableCustomRule_Live"."ConditionOption", "EditableCustomRule_Live"."FieldValue", "EditableCustomRule_Live"."ParentID", "EditableCustomRule_Live"."ConditionFieldID", "EditableCustomRule_Live"."ID",
CASE WHEN "EditableCustomRule_Live"."ClassName" IS NOT NULL THEN "EditableCustomRule_Live"."ClassName"
ELSE 'SilverStripe\\UserForms\\Model\\EditableCustomRule' END AS "RecordClassName"
FROM "EditableCustomRule_Live"
WHERE ("EditableCustomRule_Live"."ParentID" = ?)
0.0001s
0080: SELECT DISTINCT "EditableFormField_Live"."ClassName", "EditableFormField_Live"."LastEdited", "EditableFormField_Live"."Created", "EditableFormField_Live"."Version", "EditableFormField_Live"."Name", "EditableFormField_Live"."Title", "EditableFormField_Live"."Default", "EditableFormField_Live"."Sort", "EditableFormField_Live"."Required", "EditableFormField_Live"."CustomErrorMessage", "EditableFormField_Live"."ExtraClass", "EditableFormField_Live"."RightTitle", "EditableFormField_Live"."ShowOnLoad", "EditableFormField_Live"."ShowInSummary", "EditableFormField_Live"."Placeholder", "EditableFormField_Live"."DisplayRulesConjunction", "EditableFormField_Live"."ParentID", "EditableFormField_Live"."ParentClass", "EditableFormField_Live"."ID",
CASE WHEN "EditableFormField_Live"."ClassName" IS NOT NULL THEN "EditableFormField_Live"."ClassName"
ELSE 'SilverStripe\\UserForms\\Model\\EditableFormField' END AS "RecordClassName"
FROM "EditableFormField_Live"
WHERE ("EditableFormField_Live"."ParentClass" IN ('SilverStripe\\UserForms\\Model\\UserDefinedForm'))
AND ("EditableFormField_Live"."ParentID" = ?)
ORDER BY "EditableFormField_Live"."Sort" ASC
0.0002s
0081: SELECT DISTINCT "EditableFormField_Live"."ClassName", "EditableFormField_Live"."LastEdited", "EditableFormField_Live"."Created", "EditableTextField_Live"."MinLength", "EditableTextField_Live"."MaxLength", "EditableTextField_Live"."Rows", "EditableTextField_Live"."Autocomplete", "EditableFormField_Live"."ID",
CASE WHEN "EditableFormField_Live"."ClassName" IS NOT NULL THEN "EditableFormField_Live"."ClassName"
ELSE 'SilverStripe\\UserForms\\Model\\EditableFormField' END AS "RecordClassName", "EditableFormField_Live"."Sort"
FROM "EditableFormField_Live" LEFT JOIN "EditableTextField_Live" ON "EditableTextField_Live"."ID" = "EditableFormField_Live"."ID"
WHERE ("EditableFormField_Live"."ID" = ?)
AND ("EditableFormField_Live"."ClassName" IN (?))
ORDER BY "EditableFormField_Live"."Sort" ASC
LIMIT 1
0.0001s
0082: SELECT DISTINCT "EditableFormField_Live"."ClassName", "EditableFormField_Live"."LastEdited", "EditableFormField_Live"."Created", "EditableTextField_Live"."MinLength", "EditableTextField_Live"."MaxLength", "EditableTextField_Live"."Rows", "EditableTextField_Live"."Autocomplete", "EditableFormField_Live"."ID",
CASE WHEN "EditableFormField_Live"."ClassName" IS NOT NULL THEN "EditableFormField_Live"."ClassName"
ELSE 'SilverStripe\\UserForms\\Model\\EditableFormField' END AS "RecordClassName", "EditableFormField_Live"."Sort"
FROM "EditableFormField_Live" LEFT JOIN "EditableTextField_Live" ON "EditableTextField_Live"."ID" = "EditableFormField_Live"."ID"
WHERE ("EditableFormField_Live"."ID" = ?)
AND ("EditableFormField_Live"."ClassName" IN (?))
ORDER BY "EditableFormField_Live"."Sort" ASC
LIMIT 1
0.0001s
0083: SELECT DISTINCT "EditableFormField_Live"."ClassName", "EditableFormField_Live"."LastEdited", "EditableFormField_Live"."Created", "EditableTextField_Live"."MinLength", "EditableTextField_Live"."MaxLength", "EditableTextField_Live"."Rows", "EditableTextField_Live"."Autocomplete", "EditableFormField_Live"."ID",
CASE WHEN "EditableFormField_Live"."ClassName" IS NOT NULL THEN "EditableFormField_Live"."ClassName"
ELSE 'SilverStripe\\UserForms\\Model\\EditableFormField' END AS "RecordClassName", "EditableFormField_Live"."Sort"
FROM "EditableFormField_Live" LEFT JOIN "EditableTextField_Live" ON "EditableTextField_Live"."ID" = "EditableFormField_Live"."ID"
WHERE ("EditableFormField_Live"."ID" = ?)
AND ("EditableFormField_Live"."ClassName" IN (?))
ORDER BY "EditableFormField_Live"."Sort" ASC
LIMIT 1
0.0001s
0084: SELECT "Version" FROM "SiteTree" WHERE "ID" = ?
0.0001s
0085: SELECT "BaseTable"."RecordID", MAX("SiteTree_Localised_Versions"."Version") as "LatestVersion" FROM "SiteTree_Localised" AS "BaseTable" INNER JOIN "SiteTree_Localised_Versions" ON "BaseTable"."RecordID" = "SiteTree_Localised_Versions"."RecordID" AND "SiteTree_Localised_Versions"."Locale" = ? INNER JOIN "SiteTree_Versions" ON "SiteTree_Versions"."RecordID" = "SiteTree_Localised_Versions"."RecordID" AND "SiteTree_Versions"."Version" = "SiteTree_Localised_Versions"."Version" WHERE "BaseTable"."Locale" = ? AND "BaseTable"."RecordID" IN (?) GROUP BY "BaseTable"."RecordID"
0.0002s
0086: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", "SiteTree_Live"."ShowInSitemap", "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.0002s
0087: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", "SiteTree_Live"."ShowInSitemap", "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.0002s
0088: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", "SiteTree_Live"."ShowInSitemap", "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.0002s
0089: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", "SiteTree_Live"."ShowInSitemap", "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.0002s
0090: SELECT DISTINCT "SiteTree"."ClassName", "SiteTree"."LastEdited", "SiteTree"."Created", "SiteTree"."Priority", "SiteTree"."ShowInSitemap", "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.0002s
0091: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", "SiteTree_Live"."ShowInSitemap", "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.0002s
0092: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", "SiteTree_Live"."ShowInSitemap", "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.0002s
0093: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", "SiteTree_Live"."ShowInSitemap", "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.0002s
Our sidemount diving course is the perfect option for you to master a new way of diving under the watchful eyes of our experienced sidemount instructors. Learn how to manage two cylinders, emergency procedures, master finning techniques and much more!
Our course is designed to enable the certified diver to extend proficiency in the water and to review and put in practice the Essentials learned in any IANTD diver classes. This systematic learning and professional training is designed to enhance the student’s personal and team underwater skills. Development of buoyancy, trim, balance and propulsion. Refine and expand fundamental diving skills. Equipment Streamlining and configuration. Diving safety, situational awareness and accident prevention. Enhanced Dive planning and gas management. Decompression overview and minimum decompression procedures. This program is designed for divers who wish to increase their skill competency by further developing their diving skills to be safer, more comfortable and more efficient in the water while expanding the divers basic diving skills to take more advanced recreational and/or technical diving programs
Who this course is for:
The certified diver looking to use sidemount cylinders
The Sidemount Diver Course takes an in-depth look at all of the following and more:
Gas management utilizing independent cylinders
Equipment considerations
Cylinder options
Regulator options
Buoyancy compensator device (BCD)/harness options
Proper weighting
Equipment configurations
Communication
Hand signals
Problem solving
Gas-sharing
Gas hemorrhages
Water entries
Shore
Boat
S-Drills (specific to sidemount)
Some of the required skills you will have to demonstrate include:
Plan dive
Test and check all equipment (depth gauges, bottom timers/watches and computers)
Familiarization with area
Descend to planed depth and not exceed any pre-planned limits
Demonstrate the ability to safely manage gas in independent cylinders
Monitor depth/time/air consumption, figure all times on slate
Demonstrate ability to control buoyancy
Attaching sidemount cylinders while
Out of water
On surface standing on bottom
On surface in water to deep to stand
At depth
Perform gas switches
Perform safety stops
What’s in it for you?
Upon successful completion of this course, graduates may engage in sidemount diving activities without direct supervision, provided the following limits are adhered to:
Safety stops as appropriate
Planned dives do not exceed diver’s current certification level
Perform all land drills and open-water dive requirements safely and efficiently
Demonstrate mature, sound judgment concerning dive planning and execution
Log all dives
Next steps:
This course prepares you to take your cavern/cave training in sidemount configuration.
Cancellation policy
A 50% deposit is required for bookings. In case of cancellations deposit is non-refundable, but can be used as credit for rescheduled courses / guided diving.
Social
Facebook
Instagram
Youtube
Trip Advisor