0001: SET sql_mode = ? 0.0008s
0002: SHOW DATABASES LIKE 'bycsgkvss4' 0.0044s
0003: SHOW FULL TABLES WHERE Table_Type != 'VIEW' 0.0134s
0004: SHOW FULL FIELDS IN "Fluent_Domain" 0.0008s
0005: SHOW COLLATION LIKE 'utf8mb4_unicode_ci' 0.0578s
0006: SELECT DISTINCT "Fluent_Domain"."ClassName", "Fluent_Domain"."LastEdited", "Fluent_Domain"."Created", "Fluent_Domain"."Domain", "Fluent_Domain"."DefaultLocaleID", "Fluent_Domain"."ID", CASE WHEN "Fluent_Domain"."ClassName" IS NOT NULL THEN "Fluent_Domain"."ClassName" ELSE 'TractorCow\\Fluent\\Model\\Domain' END AS "RecordClassName" FROM "Fluent_Domain" 0.0007s
0007: SHOW FULL FIELDS IN "Fluent_Locale" 0.0009s
0008: SELECT DISTINCT "Fluent_Locale"."ClassName", "Fluent_Locale"."LastEdited", "Fluent_Locale"."Created", "Fluent_Locale"."Title", "Fluent_Locale"."Locale", "Fluent_Locale"."URLSegment", "Fluent_Locale"."IsGlobalDefault", "Fluent_Locale"."UseDefaultCode", "Fluent_Locale"."Sort", "Fluent_Locale"."Timezone", "Fluent_Locale"."DomainID", "Fluent_Locale"."ID", CASE WHEN "Fluent_Locale"."ClassName" IS NOT NULL THEN "Fluent_Locale"."ClassName" ELSE 'TractorCow\\Fluent\\Model\\Locale' END AS "RecordClassName" FROM "Fluent_Locale" ORDER BY "Fluent_Locale"."Sort" ASC, "Fluent_Locale"."Locale" ASC 0.0004s
0009: SELECT DISTINCT "Fluent_FallbackLocale"."ClassName", "Fluent_FallbackLocale"."LastEdited", "Fluent_FallbackLocale"."Created", "Fluent_FallbackLocale"."Sort", "Fluent_FallbackLocale"."ParentID", "Fluent_FallbackLocale"."LocaleID", "Fluent_FallbackLocale"."ID", CASE WHEN "Fluent_FallbackLocale"."ClassName" IS NOT NULL THEN "Fluent_FallbackLocale"."ClassName" ELSE 'TractorCow\\Fluent\\Model\\FallbackLocale' END AS "RecordClassName" FROM "Fluent_FallbackLocale" WHERE ("Fluent_FallbackLocale"."ParentID" = ?) ORDER BY "Fluent_FallbackLocale"."Sort" ASC 0.0005s
0010: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", CASE WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."Fallback" ELSE "SiteTree_Live"."Fallback" END AS "Fallback", CASE WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."FallbackLink" ELSE "SiteTree_Live"."FallbackLink" END AS "FallbackLink", "SiteTree_Live"."FallbackResponseCode", CASE WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."TwitterSite" ELSE "SiteTree_Live"."TwitterSite" END AS "TwitterSite", CASE WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."TwitterCreator" ELSE "SiteTree_Live"."TwitterCreator" END AS "TwitterCreator", CASE WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."TwitterTitle" ELSE "SiteTree_Live"."TwitterTitle" END AS "TwitterTitle", CASE WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."TwitterCardType" ELSE "SiteTree_Live"."TwitterCardType" END AS "TwitterCardType", CASE WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."TwitterDescription" ELSE "SiteTree_Live"."TwitterDescription" END AS "TwitterDescription", "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"."VanityMappingID", "SiteTree_Live"."TwitterImageID", "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.0011s
0011: SELECT DISTINCT "SiteConfig"."ClassName", "SiteConfig"."LastEdited", "SiteConfig"."Created", "SiteConfig"."CanonicalDomain", "SiteConfig"."Fallback", "SiteConfig"."FallbackLink", "SiteConfig"."FallbackResponseCode", CASE WHEN "SiteConfig_Localised_en_US"."ID" IS NOT NULL THEN "SiteConfig_Localised_en_US"."BlogBannerTitle" ELSE "SiteConfig"."BlogBannerTitle" END AS "BlogBannerTitle", CASE WHEN "SiteConfig_Localised_en_US"."ID" IS NOT NULL THEN "SiteConfig_Localised_en_US"."BlogBannerCheckbox1" ELSE "SiteConfig"."BlogBannerCheckbox1" END AS "BlogBannerCheckbox1", CASE WHEN "SiteConfig_Localised_en_US"."ID" IS NOT NULL THEN "SiteConfig_Localised_en_US"."BlogBannerCheckbox2" ELSE "SiteConfig"."BlogBannerCheckbox2" END AS "BlogBannerCheckbox2", CASE WHEN "SiteConfig_Localised_en_US"."ID" IS NOT NULL THEN "SiteConfig_Localised_en_US"."BlogBannerCheckbox3" ELSE "SiteConfig"."BlogBannerCheckbox3" END AS "BlogBannerCheckbox3", CASE WHEN "SiteConfig_Localised_en_US"."ID" IS NOT NULL THEN "SiteConfig_Localised_en_US"."BlogBannerOrangeNumber" ELSE "SiteConfig"."BlogBannerOrangeNumber" END AS "BlogBannerOrangeNumber", CASE WHEN "SiteConfig_Localised_en_US"."ID" IS NOT NULL THEN "SiteConfig_Localised_en_US"."BlogBannerTextNextToNumber" ELSE "SiteConfig"."BlogBannerTextNextToNumber" END AS "BlogBannerTextNextToNumber", CASE WHEN "SiteConfig_Localised_en_US"."ID" IS NOT NULL THEN "SiteConfig_Localised_en_US"."BlogBannerButtonText" ELSE "SiteConfig"."BlogBannerButtonText" END AS "BlogBannerButtonText", CASE WHEN "SiteConfig_Localised_en_US"."ID" IS NOT NULL THEN "SiteConfig_Localised_en_US"."BlogBannerURL" ELSE "SiteConfig"."BlogBannerURL" END AS "BlogBannerURL", CASE WHEN "SiteConfig_Localised_en_US"."ID" IS NOT NULL THEN "SiteConfig_Localised_en_US"."TwitterURL" ELSE "SiteConfig"."TwitterURL" END AS "TwitterURL", CASE WHEN "SiteConfig_Localised_en_US"."ID" IS NOT NULL THEN "SiteConfig_Localised_en_US"."FacebookURL" ELSE "SiteConfig"."FacebookURL" END AS "FacebookURL", CASE WHEN "SiteConfig_Localised_en_US"."ID" IS NOT NULL THEN "SiteConfig_Localised_en_US"."YoutubeURL" ELSE "SiteConfig"."YoutubeURL" END AS "YoutubeURL", CASE WHEN "SiteConfig_Localised_en_US"."ID" IS NOT NULL THEN "SiteConfig_Localised_en_US"."LinkedInURL" ELSE "SiteConfig"."LinkedInURL" END AS "LinkedInURL", CASE WHEN "SiteConfig_Localised_en_US"."ID" IS NOT NULL THEN "SiteConfig_Localised_en_US"."GooglePlayURL" ELSE "SiteConfig"."GooglePlayURL" END AS "GooglePlayURL", CASE WHEN "SiteConfig_Localised_en_US"."ID" IS NOT NULL THEN "SiteConfig_Localised_en_US"."CrossLinkCarouselTitle" ELSE "SiteConfig"."CrossLinkCarouselTitle" END AS "CrossLinkCarouselTitle", CASE WHEN "SiteConfig_Localised_en_US"."ID" IS NOT NULL THEN "SiteConfig_Localised_en_US"."CrossLinkCarouselText" ELSE "SiteConfig"."CrossLinkCarouselText" END AS "CrossLinkCarouselText", "SiteConfig"."SiteSchemaExtra", CASE WHEN "SiteConfig_Localised_en_US"."ID" IS NOT NULL THEN "SiteConfig_Localised_en_US"."FooterCopyright" ELSE "SiteConfig"."FooterCopyright" END AS "FooterCopyright", "SiteConfig"."DefaultTwitterHandle", "SiteConfig"."Title", "SiteConfig"."Tagline", "SiteConfig"."CanViewType", "SiteConfig"."CanEditType", "SiteConfig"."CanCreateTopLevelType", "SiteConfig"."BlogBannerImageID", "SiteConfig"."TopLogoID", "SiteConfig"."DefaultTwitterImageID", "SiteConfig"."ID", CASE WHEN "SiteConfig"."ClassName" IS NOT NULL THEN "SiteConfig"."ClassName" ELSE 'SilverStripe\\SiteConfig\\SiteConfig' END AS "RecordClassName", 'en_US' AS "Locale", CASE WHEN "SiteConfig_Localised_en_US"."ID" IS NOT NULL THEN 'en_US' ELSE NULL END AS "SourceLocale" FROM "SiteConfig" LEFT JOIN "SiteConfig_Localised" AS "SiteConfig_Localised_en_US" ON "SiteConfig"."ID" = "SiteConfig_Localised_en_US"."RecordID" AND "SiteConfig_Localised_en_US"."Locale" = ? LIMIT 1 0.0009s
0012: SELECT DISTINCT "BlogCategory"."ClassName", "BlogCategory"."LastEdited", "BlogCategory"."Created", "BlogCategory"."Title", "BlogCategory"."URLSegment", "BlogCategory"."BlogID", "BlogCategory"."ID", CASE WHEN "BlogCategory"."ClassName" IS NOT NULL THEN "BlogCategory"."ClassName" ELSE 'SilverStripe\\Blog\\Model\\BlogCategory' END AS "RecordClassName" FROM "BlogCategory" WHERE ("BlogCategory"."BlogID" = ?) AND ("BlogCategory"."URLSegment" = ?) LIMIT 1 0.0006s
0013: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "Page_Live"."CanonicalURL", CASE WHEN "Page_Localised_en_US"."ID" IS NOT NULL THEN "Page_Localised_en_US"."ShowFaq" ELSE "Page_Live"."ShowFaq" END AS "ShowFaq", CASE WHEN "Page_Localised_en_US"."ID" IS NOT NULL THEN "Page_Localised_en_US"."PageSubTitle" ELSE "Page_Live"."PageSubTitle" END AS "PageSubTitle", "Page_Live"."PageExtraClassAnypage", CASE WHEN "Page_Localised_en_US"."ID" IS NOT NULL THEN "Page_Localised_en_US"."ShowInterested" ELSE "Page_Live"."ShowInterested" END AS "ShowInterested", CASE WHEN "Page_Localised_en_US"."ID" IS NOT NULL THEN "Page_Localised_en_US"."InterestedTitle" ELSE "Page_Live"."InterestedTitle" END AS "InterestedTitle", CASE WHEN "Page_Localised_en_US"."ID" IS NOT NULL THEN "Page_Localised_en_US"."InterestedContent" ELSE "Page_Live"."InterestedContent" END AS "InterestedContent", CASE WHEN "Page_Localised_en_US"."ID" IS NOT NULL THEN "Page_Localised_en_US"."InterestedCTA" ELSE "Page_Live"."InterestedCTA" END AS "InterestedCTA", CASE WHEN "Page_Localised_en_US"."ID" IS NOT NULL THEN "Page_Localised_en_US"."InterestedCTALink" ELSE "Page_Live"."InterestedCTALink" END AS "InterestedCTALink", CASE WHEN "Page_Localised_en_US"."ID" IS NOT NULL THEN "Page_Localised_en_US"."SchemaEnableMarkup" ELSE "Page_Live"."SchemaEnableMarkup" END AS "SchemaEnableMarkup", CASE WHEN "Page_Localised_en_US"."ID" IS NOT NULL THEN "Page_Localised_en_US"."SchemaType" ELSE "Page_Live"."SchemaType" END AS "SchemaType", CASE WHEN "Page_Localised_en_US"."ID" IS NOT NULL THEN "Page_Localised_en_US"."SchemaName" ELSE "Page_Live"."SchemaName" END AS "SchemaName", CASE WHEN "Page_Localised_en_US"."ID" IS NOT NULL THEN "Page_Localised_en_US"."SchemaDescription" ELSE "Page_Live"."SchemaDescription" END AS "SchemaDescription", CASE WHEN "Page_Localised_en_US"."ID" IS NOT NULL THEN "Page_Localised_en_US"."SchemaExtra" ELSE "Page_Live"."SchemaExtra" END AS "SchemaExtra", CASE WHEN "Page_Localised_en_US"."ID" IS NOT NULL THEN "Page_Localised_en_US"."ShowCrossLinksCarousel" ELSE "Page_Live"."ShowCrossLinksCarousel" END AS "ShowCrossLinksCarousel", "Page_Live"."ExtraHead", CASE WHEN "Page_Localised_en_US"."ID" IS NOT NULL THEN "Page_Localised_en_US"."MetaTitle" ELSE "Page_Live"."MetaTitle" END AS "MetaTitle", CASE WHEN "Page_Localised_en_US"."ID" IS NOT NULL THEN "Page_Localised_en_US"."MetaKeywords" ELSE "Page_Live"."MetaKeywords" END AS "MetaKeywords", "Page_Live"."MyAuthorID", "Page_Live"."SchemaLogoID", CASE WHEN "Page_Localised_en_US"."ID" IS NOT NULL THEN "Page_Localised_en_US"."SchemaImageID" ELSE "Page_Live"."SchemaImageID" END AS "SchemaImageID", CASE WHEN "Page_Localised_en_US"."ID" IS NOT NULL THEN "Page_Localised_en_US"."SchemaImageAltID" ELSE "Page_Live"."SchemaImageAltID" END AS "SchemaImageAltID", "Page_Live"."MetaPhotoID", "SiteTree_Live"."ID", CASE WHEN "SiteTree_Live"."ClassName" IS NOT NULL THEN "SiteTree_Live"."ClassName" ELSE 'SilverStripe\\CMS\\Model\\SiteTree' END AS "RecordClassName", 'en_US' AS "Locale", CASE WHEN "Page_Localised_en_US"."ID" IS NOT NULL THEN 'en_US' ELSE NULL END AS "SourceLocale", "SiteTree_Live"."Sort" FROM "SiteTree_Live" LEFT JOIN "Page_Live" ON "Page_Live"."ID" = "SiteTree_Live"."ID" LEFT JOIN "SiteTree_Localised_Live" AS "SiteTree_Localised_en_US" ON "SiteTree_Live"."ID" = "SiteTree_Localised_en_US"."RecordID" AND "SiteTree_Localised_en_US"."Locale" = ? LEFT JOIN "Page_Localised_Live" AS "Page_Localised_en_US" ON "Page_Live"."ID" = "Page_Localised_en_US"."RecordID" AND "Page_Localised_en_US"."Locale" = ? WHERE ("SiteTree_Live"."ID" = ?) AND ("SiteTree_Live"."ClassName" IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)) AND (("SiteTree_Localised_en_US"."ID" IS NOT NULL)) ORDER BY "SiteTree_Live"."Sort" ASC LIMIT 1 0.0008s
0014: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "Blog_Live"."ShowTextWidget", CASE WHEN "Blog_Localised_en_US"."ID" IS NOT NULL THEN "Blog_Localised_en_US"."TextWidgetTitle" ELSE "Blog_Live"."TextWidgetTitle" END AS "TextWidgetTitle", CASE WHEN "Blog_Localised_en_US"."ID" IS NOT NULL THEN "Blog_Localised_en_US"."TextWidgetContent" ELSE "Blog_Live"."TextWidgetContent" END AS "TextWidgetContent", "Blog_Live"."PostsPerPage", "SiteTree_Live"."ID", CASE WHEN "SiteTree_Live"."ClassName" IS NOT NULL THEN "SiteTree_Live"."ClassName" ELSE 'SilverStripe\\CMS\\Model\\SiteTree' END AS "RecordClassName", 'en_US' AS "Locale", CASE WHEN "Blog_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 "Blog_Live" ON "Blog_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 "Blog_Localised_Live" AS "Blog_Localised_en_US" ON "Blog_Live"."ID" = "Blog_Localised_en_US"."RecordID" AND "Blog_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.0775s
0015: SELECT DISTINCT "Member"."ClassName", "Member"."LastEdited", "Member"."Created", "Member"."DisableAdminToolbar", "Member"."AdminToolbarDefaultCollapsed", "Member"."URLSegment", "Member"."BlogProfileSummary", "Member"."Phone", "Member"."City", "Member"."Country", "Member"."ShowCard", "Member"."MyFacebook", "Member"."MyLinkedIn", "Member"."FirstName", "Member"."Surname", "Member"."Email", "Member"."TempIDHash", "Member"."TempIDExpired", "Member"."Password", "Member"."AutoLoginHash", "Member"."AutoLoginExpired", "Member"."PasswordEncryption", "Member"."Salt", "Member"."PasswordExpiry", "Member"."LockedOutUntil", "Member"."Locale", "Member"."FailedLoginCount", "Member"."BlogProfileImageID", "Member"."ID", CASE WHEN "Member"."ClassName" IS NOT NULL THEN "Member"."ClassName" ELSE 'SilverStripe\\Security\\Member' END AS "RecordClassName" FROM "Member" WHERE ("Member"."URLSegment" = ?) ORDER BY "Member"."Surname" ASC, "Member"."FirstName" ASC LIMIT 1 0.001s
0016: SELECT DISTINCT "BlogCategory"."ClassName", "BlogCategory"."LastEdited", "BlogCategory"."Created", "BlogCategory"."Title", "BlogCategory"."URLSegment", "BlogCategory"."BlogID", "BlogCategory"."ID", CASE WHEN "BlogCategory"."ClassName" IS NOT NULL THEN "BlogCategory"."ClassName" ELSE 'SilverStripe\\Blog\\Model\\BlogCategory' END AS "RecordClassName" FROM "BlogCategory" WHERE ("BlogCategory"."BlogID" = ?) AND ("BlogCategory"."URLSegment" = ?) LIMIT 1 0.0008s
0017: 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.001s
0018: SELECT DISTINCT "BlogCategory"."ClassName", "BlogCategory"."LastEdited", "BlogCategory"."Created", "BlogCategory"."Title", "BlogCategory"."URLSegment", "BlogCategory"."BlogID", "BlogCategory"."ID", CASE WHEN "BlogCategory"."ClassName" IS NOT NULL THEN "BlogCategory"."ClassName" ELSE 'SilverStripe\\Blog\\Model\\BlogCategory' END AS "RecordClassName" FROM "BlogCategory" WHERE ("BlogCategory"."BlogID" = ?) AND ("BlogCategory"."URLSegment" = ?) LIMIT 1 0.0014s
0019: SELECT CASE WHEN EXISTS(SELECT * FROM "BlogCategory" WHERE ("BlogCategory"."BlogID" = ?)) THEN 1 ELSE 0 END 0.0007s
0020: SELECT DISTINCT "BlogCategory"."ClassName", "BlogCategory"."LastEdited", "BlogCategory"."Created", "BlogCategory"."Title", "BlogCategory"."URLSegment", "BlogCategory"."BlogID", "BlogCategory"."ID", CASE WHEN "BlogCategory"."ClassName" IS NOT NULL THEN "BlogCategory"."ClassName" ELSE 'SilverStripe\\Blog\\Model\\BlogCategory' END AS "RecordClassName" FROM "BlogCategory" WHERE ("BlogCategory"."BlogID" = ?) 0.0008s
0021: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", CASE WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."Fallback" ELSE "SiteTree_Live"."Fallback" END AS "Fallback", CASE WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."FallbackLink" ELSE "SiteTree_Live"."FallbackLink" END AS "FallbackLink", "SiteTree_Live"."FallbackResponseCode", CASE WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."TwitterSite" ELSE "SiteTree_Live"."TwitterSite" END AS "TwitterSite", CASE WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."TwitterCreator" ELSE "SiteTree_Live"."TwitterCreator" END AS "TwitterCreator", CASE WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."TwitterTitle" ELSE "SiteTree_Live"."TwitterTitle" END AS "TwitterTitle", CASE WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."TwitterCardType" ELSE "SiteTree_Live"."TwitterCardType" END AS "TwitterCardType", CASE WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."TwitterDescription" ELSE "SiteTree_Live"."TwitterDescription" END AS "TwitterDescription", "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"."VanityMappingID", "SiteTree_Live"."TwitterImageID", "SiteTree_Live"."ParentID", "Page_Live"."CanonicalURL", CASE WHEN "Page_Localised_en_US"."ID" IS NOT NULL THEN "Page_Localised_en_US"."ShowFaq" ELSE "Page_Live"."ShowFaq" END AS "ShowFaq", CASE WHEN "Page_Localised_en_US"."ID" IS NOT NULL THEN "Page_Localised_en_US"."PageSubTitle" ELSE "Page_Live"."PageSubTitle" END AS "PageSubTitle", "Page_Live"."PageExtraClassAnypage", CASE WHEN "Page_Localised_en_US"."ID" IS NOT NULL THEN "Page_Localised_en_US"."ShowInterested" ELSE "Page_Live"."ShowInterested" END AS "ShowInterested", CASE WHEN "Page_Localised_en_US"."ID" IS NOT NULL THEN "Page_Localised_en_US"."InterestedTitle" ELSE "Page_Live"."InterestedTitle" END AS "InterestedTitle", CASE WHEN "Page_Localised_en_US"."ID" IS NOT NULL THEN "Page_Localised_en_US"."InterestedContent" ELSE "Page_Live"."InterestedContent" END AS "InterestedContent", CASE WHEN "Page_Localised_en_US"."ID" IS NOT NULL THEN "Page_Localised_en_US"."InterestedCTA" ELSE "Page_Live"."InterestedCTA" END AS "InterestedCTA", CASE WHEN "Page_Localised_en_US"."ID" IS NOT NULL THEN "Page_Localised_en_US"."InterestedCTALink" ELSE "Page_Live"."InterestedCTALink" END AS "InterestedCTALink", CASE WHEN "Page_Localised_en_US"."ID" IS NOT NULL THEN "Page_Localised_en_US"."SchemaEnableMarkup" ELSE "Page_Live"."SchemaEnableMarkup" END AS "SchemaEnableMarkup", CASE WHEN "Page_Localised_en_US"."ID" IS NOT NULL THEN "Page_Localised_en_US"."SchemaType" ELSE "Page_Live"."SchemaType" END AS "SchemaType", CASE WHEN "Page_Localised_en_US"."ID" IS NOT NULL THEN "Page_Localised_en_US"."SchemaName" ELSE "Page_Live"."SchemaName" END AS "SchemaName", CASE WHEN "Page_Localised_en_US"."ID" IS NOT NULL THEN "Page_Localised_en_US"."SchemaDescription" ELSE "Page_Live"."SchemaDescription" END AS "SchemaDescription", CASE WHEN "Page_Localised_en_US"."ID" IS NOT NULL THEN "Page_Localised_en_US"."SchemaExtra" ELSE "Page_Live"."SchemaExtra" END AS "SchemaExtra", CASE WHEN "Page_Localised_en_US"."ID" IS NOT NULL THEN "Page_Localised_en_US"."ShowCrossLinksCarousel" ELSE "Page_Live"."ShowCrossLinksCarousel" END AS "ShowCrossLinksCarousel", "Page_Live"."ExtraHead", CASE WHEN "Page_Localised_en_US"."ID" IS NOT NULL THEN "Page_Localised_en_US"."MetaTitle" ELSE "Page_Live"."MetaTitle" END AS "MetaTitle", CASE WHEN "Page_Localised_en_US"."ID" IS NOT NULL THEN "Page_Localised_en_US"."MetaKeywords" ELSE "Page_Live"."MetaKeywords" END AS "MetaKeywords", "Page_Live"."MyAuthorID", "Page_Live"."SchemaLogoID", CASE WHEN "Page_Localised_en_US"."ID" IS NOT NULL THEN "Page_Localised_en_US"."SchemaImageID" ELSE "Page_Live"."SchemaImageID" END AS "SchemaImageID", CASE WHEN "Page_Localised_en_US"."ID" IS NOT NULL THEN "Page_Localised_en_US"."SchemaImageAltID" ELSE "Page_Live"."SchemaImageAltID" END AS "SchemaImageAltID", "Page_Live"."MetaPhotoID", "Blog_Live"."ShowTextWidget", CASE WHEN "Blog_Localised_en_US"."ID" IS NOT NULL THEN "Blog_Localised_en_US"."TextWidgetTitle" ELSE "Blog_Live"."TextWidgetTitle" END AS "TextWidgetTitle", CASE WHEN "Blog_Localised_en_US"."ID" IS NOT NULL THEN "Blog_Localised_en_US"."TextWidgetContent" ELSE "Blog_Live"."TextWidgetContent" END AS "TextWidgetContent", "Blog_Live"."PostsPerPage", "SiteTree_Live"."ID", CASE WHEN "SiteTree_Live"."ClassName" IS NOT NULL THEN "SiteTree_Live"."ClassName" ELSE 'SilverStripe\\CMS\\Model\\SiteTree' END AS "RecordClassName", 'en_US' AS "Locale", CASE WHEN "Blog_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 "Blog_Live" ON "Blog_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 "Blog_Localised_Live" AS "Blog_Localised_en_US" ON "Blog_Live"."ID" = "Blog_Localised_en_US"."RecordID" AND "Blog_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.0015s
0022: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", CASE WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."Fallback" ELSE "SiteTree_Live"."Fallback" END AS "Fallback", CASE WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."FallbackLink" ELSE "SiteTree_Live"."FallbackLink" END AS "FallbackLink", "SiteTree_Live"."FallbackResponseCode", CASE WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."TwitterSite" ELSE "SiteTree_Live"."TwitterSite" END AS "TwitterSite", CASE WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."TwitterCreator" ELSE "SiteTree_Live"."TwitterCreator" END AS "TwitterCreator", CASE WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."TwitterTitle" ELSE "SiteTree_Live"."TwitterTitle" END AS "TwitterTitle", CASE WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."TwitterCardType" ELSE "SiteTree_Live"."TwitterCardType" END AS "TwitterCardType", CASE WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."TwitterDescription" ELSE "SiteTree_Live"."TwitterDescription" END AS "TwitterDescription", "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"."VanityMappingID", "SiteTree_Live"."TwitterImageID", "SiteTree_Live"."ParentID", "Page_Live"."CanonicalURL", CASE WHEN "Page_Localised_en_US"."ID" IS NOT NULL THEN "Page_Localised_en_US"."ShowFaq" ELSE "Page_Live"."ShowFaq" END AS "ShowFaq", CASE WHEN "Page_Localised_en_US"."ID" IS NOT NULL THEN "Page_Localised_en_US"."PageSubTitle" ELSE "Page_Live"."PageSubTitle" END AS "PageSubTitle", "Page_Live"."PageExtraClassAnypage", CASE WHEN "Page_Localised_en_US"."ID" IS NOT NULL THEN "Page_Localised_en_US"."ShowInterested" ELSE "Page_Live"."ShowInterested" END AS "ShowInterested", CASE WHEN "Page_Localised_en_US"."ID" IS NOT NULL THEN "Page_Localised_en_US"."InterestedTitle" ELSE "Page_Live"."InterestedTitle" END AS "InterestedTitle", CASE WHEN "Page_Localised_en_US"."ID" IS NOT NULL THEN "Page_Localised_en_US"."InterestedContent" ELSE "Page_Live"."InterestedContent" END AS "InterestedContent", CASE WHEN "Page_Localised_en_US"."ID" IS NOT NULL THEN "Page_Localised_en_US"."InterestedCTA" ELSE "Page_Live"."InterestedCTA" END AS "InterestedCTA", CASE WHEN "Page_Localised_en_US"."ID" IS NOT NULL THEN "Page_Localised_en_US"."InterestedCTALink" ELSE "Page_Live"."InterestedCTALink" END AS "InterestedCTALink", CASE WHEN "Page_Localised_en_US"."ID" IS NOT NULL THEN "Page_Localised_en_US"."SchemaEnableMarkup" ELSE "Page_Live"."SchemaEnableMarkup" END AS "SchemaEnableMarkup", CASE WHEN "Page_Localised_en_US"."ID" IS NOT NULL THEN "Page_Localised_en_US"."SchemaType" ELSE "Page_Live"."SchemaType" END AS "SchemaType", CASE WHEN "Page_Localised_en_US"."ID" IS NOT NULL THEN "Page_Localised_en_US"."SchemaName" ELSE "Page_Live"."SchemaName" END AS "SchemaName", CASE WHEN "Page_Localised_en_US"."ID" IS NOT NULL THEN "Page_Localised_en_US"."SchemaDescription" ELSE "Page_Live"."SchemaDescription" END AS "SchemaDescription", CASE WHEN "Page_Localised_en_US"."ID" IS NOT NULL THEN "Page_Localised_en_US"."SchemaExtra" ELSE "Page_Live"."SchemaExtra" END AS "SchemaExtra", CASE WHEN "Page_Localised_en_US"."ID" IS NOT NULL THEN "Page_Localised_en_US"."ShowCrossLinksCarousel" ELSE "Page_Live"."ShowCrossLinksCarousel" END AS "ShowCrossLinksCarousel", "Page_Live"."ExtraHead", CASE WHEN "Page_Localised_en_US"."ID" IS NOT NULL THEN "Page_Localised_en_US"."MetaTitle" ELSE "Page_Live"."MetaTitle" END AS "MetaTitle", CASE WHEN "Page_Localised_en_US"."ID" IS NOT NULL THEN "Page_Localised_en_US"."MetaKeywords" ELSE "Page_Live"."MetaKeywords" END AS "MetaKeywords", "Page_Live"."MyAuthorID", "Page_Live"."SchemaLogoID", CASE WHEN "Page_Localised_en_US"."ID" IS NOT NULL THEN "Page_Localised_en_US"."SchemaImageID" ELSE "Page_Live"."SchemaImageID" END AS "SchemaImageID", CASE WHEN "Page_Localised_en_US"."ID" IS NOT NULL THEN "Page_Localised_en_US"."SchemaImageAltID" ELSE "Page_Live"."SchemaImageAltID" END AS "SchemaImageAltID", "Page_Live"."MetaPhotoID", "Blog_Live"."ShowTextWidget", CASE WHEN "Blog_Localised_en_US"."ID" IS NOT NULL THEN "Blog_Localised_en_US"."TextWidgetTitle" ELSE "Blog_Live"."TextWidgetTitle" END AS "TextWidgetTitle", CASE WHEN "Blog_Localised_en_US"."ID" IS NOT NULL THEN "Blog_Localised_en_US"."TextWidgetContent" ELSE "Blog_Live"."TextWidgetContent" END AS "TextWidgetContent", "Blog_Live"."PostsPerPage", "SiteTree_Live"."ID", CASE WHEN "SiteTree_Live"."ClassName" IS NOT NULL THEN "SiteTree_Live"."ClassName" ELSE 'SilverStripe\\CMS\\Model\\SiteTree' END AS "RecordClassName", 'en_US' AS "Locale", CASE WHEN "Blog_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 "Blog_Live" ON "Blog_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 "Blog_Localised_Live" AS "Blog_Localised_en_US" ON "Blog_Live"."ID" = "Blog_Localised_en_US"."RecordID" AND "Blog_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.0746s
0023: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", CASE WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."Fallback" ELSE "SiteTree_Live"."Fallback" END AS "Fallback", CASE WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."FallbackLink" ELSE "SiteTree_Live"."FallbackLink" END AS "FallbackLink", "SiteTree_Live"."FallbackResponseCode", CASE WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."TwitterSite" ELSE "SiteTree_Live"."TwitterSite" END AS "TwitterSite", CASE WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."TwitterCreator" ELSE "SiteTree_Live"."TwitterCreator" END AS "TwitterCreator", CASE WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."TwitterTitle" ELSE "SiteTree_Live"."TwitterTitle" END AS "TwitterTitle", CASE WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."TwitterCardType" ELSE "SiteTree_Live"."TwitterCardType" END AS "TwitterCardType", CASE WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."TwitterDescription" ELSE "SiteTree_Live"."TwitterDescription" END AS "TwitterDescription", "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"."VanityMappingID", "SiteTree_Live"."TwitterImageID", "SiteTree_Live"."ParentID", "Page_Live"."CanonicalURL", CASE WHEN "Page_Localised_en_US"."ID" IS NOT NULL THEN "Page_Localised_en_US"."ShowFaq" ELSE "Page_Live"."ShowFaq" END AS "ShowFaq", CASE WHEN "Page_Localised_en_US"."ID" IS NOT NULL THEN "Page_Localised_en_US"."PageSubTitle" ELSE "Page_Live"."PageSubTitle" END AS "PageSubTitle", "Page_Live"."PageExtraClassAnypage", CASE WHEN "Page_Localised_en_US"."ID" IS NOT NULL THEN "Page_Localised_en_US"."ShowInterested" ELSE "Page_Live"."ShowInterested" END AS "ShowInterested", CASE WHEN "Page_Localised_en_US"."ID" IS NOT NULL THEN "Page_Localised_en_US"."InterestedTitle" ELSE "Page_Live"."InterestedTitle" END AS "InterestedTitle", CASE WHEN "Page_Localised_en_US"."ID" IS NOT NULL THEN "Page_Localised_en_US"."InterestedContent" ELSE "Page_Live"."InterestedContent" END AS "InterestedContent", CASE WHEN "Page_Localised_en_US"."ID" IS NOT NULL THEN "Page_Localised_en_US"."InterestedCTA" ELSE "Page_Live"."InterestedCTA" END AS "InterestedCTA", CASE WHEN "Page_Localised_en_US"."ID" IS NOT NULL THEN "Page_Localised_en_US"."InterestedCTALink" ELSE "Page_Live"."InterestedCTALink" END AS "InterestedCTALink", CASE WHEN "Page_Localised_en_US"."ID" IS NOT NULL THEN "Page_Localised_en_US"."SchemaEnableMarkup" ELSE "Page_Live"."SchemaEnableMarkup" END AS "SchemaEnableMarkup", CASE WHEN "Page_Localised_en_US"."ID" IS NOT NULL THEN "Page_Localised_en_US"."SchemaType" ELSE "Page_Live"."SchemaType" END AS "SchemaType", CASE WHEN "Page_Localised_en_US"."ID" IS NOT NULL THEN "Page_Localised_en_US"."SchemaName" ELSE "Page_Live"."SchemaName" END AS "SchemaName", CASE WHEN "Page_Localised_en_US"."ID" IS NOT NULL THEN "Page_Localised_en_US"."SchemaDescription" ELSE "Page_Live"."SchemaDescription" END AS "SchemaDescription", CASE WHEN "Page_Localised_en_US"."ID" IS NOT NULL THEN "Page_Localised_en_US"."SchemaExtra" ELSE "Page_Live"."SchemaExtra" END AS "SchemaExtra", CASE WHEN "Page_Localised_en_US"."ID" IS NOT NULL THEN "Page_Localised_en_US"."ShowCrossLinksCarousel" ELSE "Page_Live"."ShowCrossLinksCarousel" END AS "ShowCrossLinksCarousel", "Page_Live"."ExtraHead", CASE WHEN "Page_Localised_en_US"."ID" IS NOT NULL THEN "Page_Localised_en_US"."MetaTitle" ELSE "Page_Live"."MetaTitle" END AS "MetaTitle", CASE WHEN "Page_Localised_en_US"."ID" IS NOT NULL THEN "Page_Localised_en_US"."MetaKeywords" ELSE "Page_Live"."MetaKeywords" END AS "MetaKeywords", "Page_Live"."MyAuthorID", "Page_Live"."SchemaLogoID", CASE WHEN "Page_Localised_en_US"."ID" IS NOT NULL THEN "Page_Localised_en_US"."SchemaImageID" ELSE "Page_Live"."SchemaImageID" END AS "SchemaImageID", CASE WHEN "Page_Localised_en_US"."ID" IS NOT NULL THEN "Page_Localised_en_US"."SchemaImageAltID" ELSE "Page_Live"."SchemaImageAltID" END AS "SchemaImageAltID", "Page_Live"."MetaPhotoID", "Blog_Live"."ShowTextWidget", CASE WHEN "Blog_Localised_en_US"."ID" IS NOT NULL THEN "Blog_Localised_en_US"."TextWidgetTitle" ELSE "Blog_Live"."TextWidgetTitle" END AS "TextWidgetTitle", CASE WHEN "Blog_Localised_en_US"."ID" IS NOT NULL THEN "Blog_Localised_en_US"."TextWidgetContent" ELSE "Blog_Live"."TextWidgetContent" END AS "TextWidgetContent", "Blog_Live"."PostsPerPage", "SiteTree_Live"."ID", CASE WHEN "SiteTree_Live"."ClassName" IS NOT NULL THEN "SiteTree_Live"."ClassName" ELSE 'SilverStripe\\CMS\\Model\\SiteTree' END AS "RecordClassName", 'en_US' AS "Locale", CASE WHEN "Blog_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 "Blog_Live" ON "Blog_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 "Blog_Localised_Live" AS "Blog_Localised_en_US" ON "Blog_Live"."ID" = "Blog_Localised_en_US"."RecordID" AND "Blog_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.0019s
0024: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", CASE WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."Fallback" ELSE "SiteTree_Live"."Fallback" END AS "Fallback", CASE WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."FallbackLink" ELSE "SiteTree_Live"."FallbackLink" END AS "FallbackLink", "SiteTree_Live"."FallbackResponseCode", CASE WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."TwitterSite" ELSE "SiteTree_Live"."TwitterSite" END AS "TwitterSite", CASE WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."TwitterCreator" ELSE "SiteTree_Live"."TwitterCreator" END AS "TwitterCreator", CASE WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."TwitterTitle" ELSE "SiteTree_Live"."TwitterTitle" END AS "TwitterTitle", CASE WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."TwitterCardType" ELSE "SiteTree_Live"."TwitterCardType" END AS "TwitterCardType", CASE WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."TwitterDescription" ELSE "SiteTree_Live"."TwitterDescription" END AS "TwitterDescription", "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"."VanityMappingID", "SiteTree_Live"."TwitterImageID", "SiteTree_Live"."ParentID", "Page_Live"."CanonicalURL", CASE WHEN "Page_Localised_en_US"."ID" IS NOT NULL THEN "Page_Localised_en_US"."ShowFaq" ELSE "Page_Live"."ShowFaq" END AS "ShowFaq", CASE WHEN "Page_Localised_en_US"."ID" IS NOT NULL THEN "Page_Localised_en_US"."PageSubTitle" ELSE "Page_Live"."PageSubTitle" END AS "PageSubTitle", "Page_Live"."PageExtraClassAnypage", CASE WHEN "Page_Localised_en_US"."ID" IS NOT NULL THEN "Page_Localised_en_US"."ShowInterested" ELSE "Page_Live"."ShowInterested" END AS "ShowInterested", CASE WHEN "Page_Localised_en_US"."ID" IS NOT NULL THEN "Page_Localised_en_US"."InterestedTitle" ELSE "Page_Live"."InterestedTitle" END AS "InterestedTitle", CASE WHEN "Page_Localised_en_US"."ID" IS NOT NULL THEN "Page_Localised_en_US"."InterestedContent" ELSE "Page_Live"."InterestedContent" END AS "InterestedContent", CASE WHEN "Page_Localised_en_US"."ID" IS NOT NULL THEN "Page_Localised_en_US"."InterestedCTA" ELSE "Page_Live"."InterestedCTA" END AS "InterestedCTA", CASE WHEN "Page_Localised_en_US"."ID" IS NOT NULL THEN "Page_Localised_en_US"."InterestedCTALink" ELSE "Page_Live"."InterestedCTALink" END AS "InterestedCTALink", CASE WHEN "Page_Localised_en_US"."ID" IS NOT NULL THEN "Page_Localised_en_US"."SchemaEnableMarkup" ELSE "Page_Live"."SchemaEnableMarkup" END AS "SchemaEnableMarkup", CASE WHEN "Page_Localised_en_US"."ID" IS NOT NULL THEN "Page_Localised_en_US"."SchemaType" ELSE "Page_Live"."SchemaType" END AS "SchemaType", CASE WHEN "Page_Localised_en_US"."ID" IS NOT NULL THEN "Page_Localised_en_US"."SchemaName" ELSE "Page_Live"."SchemaName" END AS "SchemaName", CASE WHEN "Page_Localised_en_US"."ID" IS NOT NULL THEN "Page_Localised_en_US"."SchemaDescription" ELSE "Page_Live"."SchemaDescription" END AS "SchemaDescription", CASE WHEN "Page_Localised_en_US"."ID" IS NOT NULL THEN "Page_Localised_en_US"."SchemaExtra" ELSE "Page_Live"."SchemaExtra" END AS "SchemaExtra", CASE WHEN "Page_Localised_en_US"."ID" IS NOT NULL THEN "Page_Localised_en_US"."ShowCrossLinksCarousel" ELSE "Page_Live"."ShowCrossLinksCarousel" END AS "ShowCrossLinksCarousel", "Page_Live"."ExtraHead", CASE WHEN "Page_Localised_en_US"."ID" IS NOT NULL THEN "Page_Localised_en_US"."MetaTitle" ELSE "Page_Live"."MetaTitle" END AS "MetaTitle", CASE WHEN "Page_Localised_en_US"."ID" IS NOT NULL THEN "Page_Localised_en_US"."MetaKeywords" ELSE "Page_Live"."MetaKeywords" END AS "MetaKeywords", "Page_Live"."MyAuthorID", "Page_Live"."SchemaLogoID", CASE WHEN "Page_Localised_en_US"."ID" IS NOT NULL THEN "Page_Localised_en_US"."SchemaImageID" ELSE "Page_Live"."SchemaImageID" END AS "SchemaImageID", CASE WHEN "Page_Localised_en_US"."ID" IS NOT NULL THEN "Page_Localised_en_US"."SchemaImageAltID" ELSE "Page_Live"."SchemaImageAltID" END AS "SchemaImageAltID", "Page_Live"."MetaPhotoID", "Blog_Live"."ShowTextWidget", CASE WHEN "Blog_Localised_en_US"."ID" IS NOT NULL THEN "Blog_Localised_en_US"."TextWidgetTitle" ELSE "Blog_Live"."TextWidgetTitle" END AS "TextWidgetTitle", CASE WHEN "Blog_Localised_en_US"."ID" IS NOT NULL THEN "Blog_Localised_en_US"."TextWidgetContent" ELSE "Blog_Live"."TextWidgetContent" END AS "TextWidgetContent", "Blog_Live"."PostsPerPage", "SiteTree_Live"."ID", CASE WHEN "SiteTree_Live"."ClassName" IS NOT NULL THEN "SiteTree_Live"."ClassName" ELSE 'SilverStripe\\CMS\\Model\\SiteTree' END AS "RecordClassName", 'en_US' AS "Locale", CASE WHEN "Blog_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 "Blog_Live" ON "Blog_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 "Blog_Localised_Live" AS "Blog_Localised_en_US" ON "Blog_Live"."ID" = "Blog_Localised_en_US"."RecordID" AND "Blog_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.0017s
0025: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", CASE WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."Fallback" ELSE "SiteTree_Live"."Fallback" END AS "Fallback", CASE WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."FallbackLink" ELSE "SiteTree_Live"."FallbackLink" END AS "FallbackLink", "SiteTree_Live"."FallbackResponseCode", CASE WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."TwitterSite" ELSE "SiteTree_Live"."TwitterSite" END AS "TwitterSite", CASE WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."TwitterCreator" ELSE "SiteTree_Live"."TwitterCreator" END AS "TwitterCreator", CASE WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."TwitterTitle" ELSE "SiteTree_Live"."TwitterTitle" END AS "TwitterTitle", CASE WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."TwitterCardType" ELSE "SiteTree_Live"."TwitterCardType" END AS "TwitterCardType", CASE WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."TwitterDescription" ELSE "SiteTree_Live"."TwitterDescription" END AS "TwitterDescription", "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"."VanityMappingID", "SiteTree_Live"."TwitterImageID", "SiteTree_Live"."ParentID", "Page_Live"."CanonicalURL", CASE WHEN "Page_Localised_en_US"."ID" IS NOT NULL THEN "Page_Localised_en_US"."ShowFaq" ELSE "Page_Live"."ShowFaq" END AS "ShowFaq", CASE WHEN "Page_Localised_en_US"."ID" IS NOT NULL THEN "Page_Localised_en_US"."PageSubTitle" ELSE "Page_Live"."PageSubTitle" END AS "PageSubTitle", "Page_Live"."PageExtraClassAnypage", CASE WHEN "Page_Localised_en_US"."ID" IS NOT NULL THEN "Page_Localised_en_US"."ShowInterested" ELSE "Page_Live"."ShowInterested" END AS "ShowInterested", CASE WHEN "Page_Localised_en_US"."ID" IS NOT NULL THEN "Page_Localised_en_US"."InterestedTitle" ELSE "Page_Live"."InterestedTitle" END AS "InterestedTitle", CASE WHEN "Page_Localised_en_US"."ID" IS NOT NULL THEN "Page_Localised_en_US"."InterestedContent" ELSE "Page_Live"."InterestedContent" END AS "InterestedContent", CASE WHEN "Page_Localised_en_US"."ID" IS NOT NULL THEN "Page_Localised_en_US"."InterestedCTA" ELSE "Page_Live"."InterestedCTA" END AS "InterestedCTA", CASE WHEN "Page_Localised_en_US"."ID" IS NOT NULL THEN "Page_Localised_en_US"."InterestedCTALink" ELSE "Page_Live"."InterestedCTALink" END AS "InterestedCTALink", CASE WHEN "Page_Localised_en_US"."ID" IS NOT NULL THEN "Page_Localised_en_US"."SchemaEnableMarkup" ELSE "Page_Live"."SchemaEnableMarkup" END AS "SchemaEnableMarkup", CASE WHEN "Page_Localised_en_US"."ID" IS NOT NULL THEN "Page_Localised_en_US"."SchemaType" ELSE "Page_Live"."SchemaType" END AS "SchemaType", CASE WHEN "Page_Localised_en_US"."ID" IS NOT NULL THEN "Page_Localised_en_US"."SchemaName" ELSE "Page_Live"."SchemaName" END AS "SchemaName", CASE WHEN "Page_Localised_en_US"."ID" IS NOT NULL THEN "Page_Localised_en_US"."SchemaDescription" ELSE "Page_Live"."SchemaDescription" END AS "SchemaDescription", CASE WHEN "Page_Localised_en_US"."ID" IS NOT NULL THEN "Page_Localised_en_US"."SchemaExtra" ELSE "Page_Live"."SchemaExtra" END AS "SchemaExtra", CASE WHEN "Page_Localised_en_US"."ID" IS NOT NULL THEN "Page_Localised_en_US"."ShowCrossLinksCarousel" ELSE "Page_Live"."ShowCrossLinksCarousel" END AS "ShowCrossLinksCarousel", "Page_Live"."ExtraHead", CASE WHEN "Page_Localised_en_US"."ID" IS NOT NULL THEN "Page_Localised_en_US"."MetaTitle" ELSE "Page_Live"."MetaTitle" END AS "MetaTitle", CASE WHEN "Page_Localised_en_US"."ID" IS NOT NULL THEN "Page_Localised_en_US"."MetaKeywords" ELSE "Page_Live"."MetaKeywords" END AS "MetaKeywords", "Page_Live"."MyAuthorID", "Page_Live"."SchemaLogoID", CASE WHEN "Page_Localised_en_US"."ID" IS NOT NULL THEN "Page_Localised_en_US"."SchemaImageID" ELSE "Page_Live"."SchemaImageID" END AS "SchemaImageID", CASE WHEN "Page_Localised_en_US"."ID" IS NOT NULL THEN "Page_Localised_en_US"."SchemaImageAltID" ELSE "Page_Live"."SchemaImageAltID" END AS "SchemaImageAltID", "Page_Live"."MetaPhotoID", "Blog_Live"."ShowTextWidget", CASE WHEN "Blog_Localised_en_US"."ID" IS NOT NULL THEN "Blog_Localised_en_US"."TextWidgetTitle" ELSE "Blog_Live"."TextWidgetTitle" END AS "TextWidgetTitle", CASE WHEN "Blog_Localised_en_US"."ID" IS NOT NULL THEN "Blog_Localised_en_US"."TextWidgetContent" ELSE "Blog_Live"."TextWidgetContent" END AS "TextWidgetContent", "Blog_Live"."PostsPerPage", "SiteTree_Live"."ID", CASE WHEN "SiteTree_Live"."ClassName" IS NOT NULL THEN "SiteTree_Live"."ClassName" ELSE 'SilverStripe\\CMS\\Model\\SiteTree' END AS "RecordClassName", 'en_US' AS "Locale", CASE WHEN "Blog_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 "Blog_Live" ON "Blog_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 "Blog_Localised_Live" AS "Blog_Localised_en_US" ON "Blog_Live"."ID" = "Blog_Localised_en_US"."RecordID" AND "Blog_Localised_en_US"."Locale" = ? WHERE ("SiteTree_Live"."ID" = ?) AND ("SiteTree_Live"."ClassName" IN (?)) AND (("SiteTree_Localised_en_US"."ID" IS NOT NULL)) ORDER BY "SiteTree_Live"."Sort" ASC LIMIT 1 0.0014s
0026: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", CASE WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."Fallback" ELSE "SiteTree_Live"."Fallback" END AS "Fallback", CASE WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."FallbackLink" ELSE "SiteTree_Live"."FallbackLink" END AS "FallbackLink", "SiteTree_Live"."FallbackResponseCode", CASE WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."TwitterSite" ELSE "SiteTree_Live"."TwitterSite" END AS "TwitterSite", CASE WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."TwitterCreator" ELSE "SiteTree_Live"."TwitterCreator" END AS "TwitterCreator", CASE WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."TwitterTitle" ELSE "SiteTree_Live"."TwitterTitle" END AS "TwitterTitle", CASE WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."TwitterCardType" ELSE "SiteTree_Live"."TwitterCardType" END AS "TwitterCardType", CASE WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."TwitterDescription" ELSE "SiteTree_Live"."TwitterDescription" END AS "TwitterDescription", "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"."VanityMappingID", "SiteTree_Live"."TwitterImageID", "SiteTree_Live"."ParentID", "Page_Live"."CanonicalURL", CASE WHEN "Page_Localised_en_US"."ID" IS NOT NULL THEN "Page_Localised_en_US"."ShowFaq" ELSE "Page_Live"."ShowFaq" END AS "ShowFaq", CASE WHEN "Page_Localised_en_US"."ID" IS NOT NULL THEN "Page_Localised_en_US"."PageSubTitle" ELSE "Page_Live"."PageSubTitle" END AS "PageSubTitle", "Page_Live"."PageExtraClassAnypage", CASE WHEN "Page_Localised_en_US"."ID" IS NOT NULL THEN "Page_Localised_en_US"."ShowInterested" ELSE "Page_Live"."ShowInterested" END AS "ShowInterested", CASE WHEN "Page_Localised_en_US"."ID" IS NOT NULL THEN "Page_Localised_en_US"."InterestedTitle" ELSE "Page_Live"."InterestedTitle" END AS "InterestedTitle", CASE WHEN "Page_Localised_en_US"."ID" IS NOT NULL THEN "Page_Localised_en_US"."InterestedContent" ELSE "Page_Live"."InterestedContent" END AS "InterestedContent", CASE WHEN "Page_Localised_en_US"."ID" IS NOT NULL THEN "Page_Localised_en_US"."InterestedCTA" ELSE "Page_Live"."InterestedCTA" END AS "InterestedCTA", CASE WHEN "Page_Localised_en_US"."ID" IS NOT NULL THEN "Page_Localised_en_US"."InterestedCTALink" ELSE "Page_Live"."InterestedCTALink" END AS "InterestedCTALink", CASE WHEN "Page_Localised_en_US"."ID" IS NOT NULL THEN "Page_Localised_en_US"."SchemaEnableMarkup" ELSE "Page_Live"."SchemaEnableMarkup" END AS "SchemaEnableMarkup", CASE WHEN "Page_Localised_en_US"."ID" IS NOT NULL THEN "Page_Localised_en_US"."SchemaType" ELSE "Page_Live"."SchemaType" END AS "SchemaType", CASE WHEN "Page_Localised_en_US"."ID" IS NOT NULL THEN "Page_Localised_en_US"."SchemaName" ELSE "Page_Live"."SchemaName" END AS "SchemaName", CASE WHEN "Page_Localised_en_US"."ID" IS NOT NULL THEN "Page_Localised_en_US"."SchemaDescription" ELSE "Page_Live"."SchemaDescription" END AS "SchemaDescription", CASE WHEN "Page_Localised_en_US"."ID" IS NOT NULL THEN "Page_Localised_en_US"."SchemaExtra" ELSE "Page_Live"."SchemaExtra" END AS "SchemaExtra", CASE WHEN "Page_Localised_en_US"."ID" IS NOT NULL THEN "Page_Localised_en_US"."ShowCrossLinksCarousel" ELSE "Page_Live"."ShowCrossLinksCarousel" END AS "ShowCrossLinksCarousel", "Page_Live"."ExtraHead", CASE WHEN "Page_Localised_en_US"."ID" IS NOT NULL THEN "Page_Localised_en_US"."MetaTitle" ELSE "Page_Live"."MetaTitle" END AS "MetaTitle", CASE WHEN "Page_Localised_en_US"."ID" IS NOT NULL THEN "Page_Localised_en_US"."MetaKeywords" ELSE "Page_Live"."MetaKeywords" END AS "MetaKeywords", "Page_Live"."MyAuthorID", "Page_Live"."SchemaLogoID", CASE WHEN "Page_Localised_en_US"."ID" IS NOT NULL THEN "Page_Localised_en_US"."SchemaImageID" ELSE "Page_Live"."SchemaImageID" END AS "SchemaImageID", CASE WHEN "Page_Localised_en_US"."ID" IS NOT NULL THEN "Page_Localised_en_US"."SchemaImageAltID" ELSE "Page_Live"."SchemaImageAltID" END AS "SchemaImageAltID", "Page_Live"."MetaPhotoID", "Blog_Live"."ShowTextWidget", CASE WHEN "Blog_Localised_en_US"."ID" IS NOT NULL THEN "Blog_Localised_en_US"."TextWidgetTitle" ELSE "Blog_Live"."TextWidgetTitle" END AS "TextWidgetTitle", CASE WHEN "Blog_Localised_en_US"."ID" IS NOT NULL THEN "Blog_Localised_en_US"."TextWidgetContent" ELSE "Blog_Live"."TextWidgetContent" END AS "TextWidgetContent", "Blog_Live"."PostsPerPage", "SiteTree_Live"."ID", CASE WHEN "SiteTree_Live"."ClassName" IS NOT NULL THEN "SiteTree_Live"."ClassName" ELSE 'SilverStripe\\CMS\\Model\\SiteTree' END AS "RecordClassName", 'en_US' AS "Locale", CASE WHEN "Blog_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 "Blog_Live" ON "Blog_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 "Blog_Localised_Live" AS "Blog_Localised_en_US" ON "Blog_Live"."ID" = "Blog_Localised_en_US"."RecordID" AND "Blog_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.0013s
0027: SELECT CASE WHEN EXISTS(SELECT * FROM "SiteTree_Live" LEFT JOIN "Page_Live" ON "Page_Live"."ID" = "SiteTree_Live"."ID" LEFT JOIN "BlogPost_Live" ON "BlogPost_Live"."ID" = "SiteTree_Live"."ID" INNER JOIN "BlogPost_Categories" ON "BlogPost_Categories"."BlogPostID" = "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 "BlogPost_Localised_Live" AS "BlogPost_Localised_en_US" ON "BlogPost_Live"."ID" = "BlogPost_Localised_en_US"."RecordID" AND "BlogPost_Localised_en_US"."Locale" = ? WHERE ("BlogPost_Categories"."BlogCategoryID" = ?) AND ("SiteTree_Live"."ClassName" IN (?)) AND (("SiteTree_Localised_en_US"."ID" IS NOT NULL)) AND ("PublishDate" < '2026-04-12 05:18:43')) THEN 1 ELSE 0 END 0.0012s
0028: SELECT DISTINCT "PublishDate" IS NULL AS "_SortColumn0", "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", CASE WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."Fallback" ELSE "SiteTree_Live"."Fallback" END AS "Fallback", CASE WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."FallbackLink" ELSE "SiteTree_Live"."FallbackLink" END AS "FallbackLink", "SiteTree_Live"."FallbackResponseCode", CASE WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."TwitterSite" ELSE "SiteTree_Live"."TwitterSite" END AS "TwitterSite", CASE WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."TwitterCreator" ELSE "SiteTree_Live"."TwitterCreator" END AS "TwitterCreator", CASE WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."TwitterTitle" ELSE "SiteTree_Live"."TwitterTitle" END AS "TwitterTitle", CASE WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."TwitterCardType" ELSE "SiteTree_Live"."TwitterCardType" END AS "TwitterCardType", CASE WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."TwitterDescription" ELSE "SiteTree_Live"."TwitterDescription" END AS "TwitterDescription", "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"."VanityMappingID", "SiteTree_Live"."TwitterImageID", "SiteTree_Live"."ParentID", "Page_Live"."CanonicalURL", CASE WHEN "Page_Localised_en_US"."ID" IS NOT NULL THEN "Page_Localised_en_US"."ShowFaq" ELSE "Page_Live"."ShowFaq" END AS "ShowFaq", CASE WHEN "Page_Localised_en_US"."ID" IS NOT NULL THEN "Page_Localised_en_US"."PageSubTitle" ELSE "Page_Live"."PageSubTitle" END AS "PageSubTitle", "Page_Live"."PageExtraClassAnypage", CASE WHEN "Page_Localised_en_US"."ID" IS NOT NULL THEN "Page_Localised_en_US"."ShowInterested" ELSE "Page_Live"."ShowInterested" END AS "ShowInterested", CASE WHEN "Page_Localised_en_US"."ID" IS NOT NULL THEN "Page_Localised_en_US"."InterestedTitle" ELSE "Page_Live"."InterestedTitle" END AS "InterestedTitle", CASE WHEN "Page_Localised_en_US"."ID" IS NOT NULL THEN "Page_Localised_en_US"."InterestedContent" ELSE "Page_Live"."InterestedContent" END AS "InterestedContent", CASE WHEN "Page_Localised_en_US"."ID" IS NOT NULL THEN "Page_Localised_en_US"."InterestedCTA" ELSE "Page_Live"."InterestedCTA" END AS "InterestedCTA", CASE WHEN "Page_Localised_en_US"."ID" IS NOT NULL THEN "Page_Localised_en_US"."InterestedCTALink" ELSE "Page_Live"."InterestedCTALink" END AS "InterestedCTALink", CASE WHEN "Page_Localised_en_US"."ID" IS NOT NULL THEN "Page_Localised_en_US"."SchemaEnableMarkup" ELSE "Page_Live"."SchemaEnableMarkup" END AS "SchemaEnableMarkup", CASE WHEN "Page_Localised_en_US"."ID" IS NOT NULL THEN "Page_Localised_en_US"."SchemaType" ELSE "Page_Live"."SchemaType" END AS "SchemaType", CASE WHEN "Page_Localised_en_US"."ID" IS NOT NULL THEN "Page_Localised_en_US"."SchemaName" ELSE "Page_Live"."SchemaName" END AS "SchemaName", CASE WHEN "Page_Localised_en_US"."ID" IS NOT NULL THEN "Page_Localised_en_US"."SchemaDescription" ELSE "Page_Live"."SchemaDescription" END AS "SchemaDescription", CASE WHEN "Page_Localised_en_US"."ID" IS NOT NULL THEN "Page_Localised_en_US"."SchemaExtra" ELSE "Page_Live"."SchemaExtra" END AS "SchemaExtra", CASE WHEN "Page_Localised_en_US"."ID" IS NOT NULL THEN "Page_Localised_en_US"."ShowCrossLinksCarousel" ELSE "Page_Live"."ShowCrossLinksCarousel" END AS "ShowCrossLinksCarousel", "Page_Live"."ExtraHead", CASE WHEN "Page_Localised_en_US"."ID" IS NOT NULL THEN "Page_Localised_en_US"."MetaTitle" ELSE "Page_Live"."MetaTitle" END AS "MetaTitle", CASE WHEN "Page_Localised_en_US"."ID" IS NOT NULL THEN "Page_Localised_en_US"."MetaKeywords" ELSE "Page_Live"."MetaKeywords" END AS "MetaKeywords", "Page_Live"."MyAuthorID", "Page_Live"."SchemaLogoID", CASE WHEN "Page_Localised_en_US"."ID" IS NOT NULL THEN "Page_Localised_en_US"."SchemaImageID" ELSE "Page_Live"."SchemaImageID" END AS "SchemaImageID", CASE WHEN "Page_Localised_en_US"."ID" IS NOT NULL THEN "Page_Localised_en_US"."SchemaImageAltID" ELSE "Page_Live"."SchemaImageAltID" END AS "SchemaImageAltID", "Page_Live"."MetaPhotoID", CASE WHEN "BlogPost_Localised_en_US"."ID" IS NOT NULL THEN "BlogPost_Localised_en_US"."Popularity" ELSE "BlogPost_Live"."Popularity" END AS "Popularity", CASE WHEN "BlogPost_Localised_en_US"."ID" IS NOT NULL THEN "BlogPost_Localised_en_US"."SynopsysText" ELSE "BlogPost_Live"."SynopsysText" END AS "SynopsysText", "BlogPost_Live"."ShowOriginalImage", "BlogPost_Live"."HideImageInPost", "BlogPost_Live"."PublishDate", "BlogPost_Live"."AuthorNames", "BlogPost_Live"."Summary", CASE WHEN "BlogPost_Localised_en_US"."ID" IS NOT NULL THEN "BlogPost_Localised_en_US"."FeaturedImageID" ELSE "BlogPost_Live"."FeaturedImageID" END AS "FeaturedImageID", "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 "BlogPost_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 "BlogPost_Live" ON "BlogPost_Live"."ID" = "SiteTree_Live"."ID" INNER JOIN "BlogPost_Categories" ON "BlogPost_Categories"."BlogPostID" = "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 "BlogPost_Localised_Live" AS "BlogPost_Localised_en_US" ON "BlogPost_Live"."ID" = "BlogPost_Localised_en_US"."RecordID" AND "BlogPost_Localised_en_US"."Locale" = ? WHERE ("BlogPost_Categories"."BlogCategoryID" = ?) AND ("SiteTree_Live"."ClassName" IN (?)) AND (("SiteTree_Localised_en_US"."ID" IS NOT NULL)) AND ("PublishDate" < '2026-04-12 05:18:43') ORDER BY "_SortColumn0" DESC, "BlogPost_Live"."PublishDate" DESC LIMIT 500 0.0816s
0029: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", CASE WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."Fallback" ELSE "SiteTree_Live"."Fallback" END AS "Fallback", CASE WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."FallbackLink" ELSE "SiteTree_Live"."FallbackLink" END AS "FallbackLink", "SiteTree_Live"."FallbackResponseCode", CASE WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."TwitterSite" ELSE "SiteTree_Live"."TwitterSite" END AS "TwitterSite", CASE WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."TwitterCreator" ELSE "SiteTree_Live"."TwitterCreator" END AS "TwitterCreator", CASE WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."TwitterTitle" ELSE "SiteTree_Live"."TwitterTitle" END AS "TwitterTitle", CASE WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."TwitterCardType" ELSE "SiteTree_Live"."TwitterCardType" END AS "TwitterCardType", CASE WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."TwitterDescription" ELSE "SiteTree_Live"."TwitterDescription" END AS "TwitterDescription", "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"."VanityMappingID", "SiteTree_Live"."TwitterImageID", "SiteTree_Live"."ParentID", "SiteTree_Live"."ID", CASE WHEN "SiteTree_Live"."ClassName" IS NOT NULL THEN "SiteTree_Live"."ClassName" ELSE 'SilverStripe\\CMS\\Model\\SiteTree' END AS "RecordClassName", 'en_US' AS "Locale", CASE WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN 'en_US' ELSE NULL END AS "SourceLocale" FROM "SiteTree_Live" LEFT JOIN "SiteTree_Localised_Live" AS "SiteTree_Localised_en_US" ON "SiteTree_Live"."ID" = "SiteTree_Localised_en_US"."RecordID" AND "SiteTree_Localised_en_US"."Locale" = ? WHERE ("SiteTree_Live"."ID" = ?) AND (("SiteTree_Localised_en_US"."ID" IS NOT NULL)) ORDER BY "SiteTree_Live"."Sort" ASC LIMIT 1 0.0007s
0030: 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.0006s
0031: SELECT DISTINCT "Member"."ClassName", "Member"."LastEdited", "Member"."Created", "Member"."DisableAdminToolbar", "Member"."AdminToolbarDefaultCollapsed", "Member"."URLSegment", "Member"."BlogProfileSummary", "Member"."Phone", "Member"."City", "Member"."Country", "Member"."ShowCard", "Member"."MyFacebook", "Member"."MyLinkedIn", "Member"."FirstName", "Member"."Surname", "Member"."Email", "Member"."TempIDHash", "Member"."TempIDExpired", "Member"."Password", "Member"."AutoLoginHash", "Member"."AutoLoginExpired", "Member"."PasswordEncryption", "Member"."Salt", "Member"."PasswordExpiry", "Member"."LockedOutUntil", "Member"."Locale", "Member"."FailedLoginCount", "Member"."BlogProfileImageID", "Member"."ID", CASE WHEN "Member"."ClassName" IS NOT NULL THEN "Member"."ClassName" ELSE 'SilverStripe\\Security\\Member' END AS "RecordClassName" FROM "Member" INNER JOIN "BlogPost_Authors" ON "BlogPost_Authors"."MemberID" = "Member"."ID" WHERE ("BlogPost_Authors"."BlogPostID" = ?) ORDER BY "Member"."Surname" ASC, "Member"."FirstName" ASC 0.0007s
0032: SELECT DISTINCT "Lingo"."ClassName", "Lingo"."LastEdited", "Lingo"."Created", "Lingo"."Name", "Lingo"."Familyname", "Lingo"."Value", "Lingo"."FileValue", "Lingo"."Entity", "Lingo"."Locale", "Lingo"."Status", "Lingo"."ID", CASE WHEN "Lingo"."ClassName" IS NOT NULL THEN "Lingo"."ClassName" ELSE 'NorthCreationAgency\\SilverStripeLingo\\Lingo' END AS "RecordClassName" FROM "Lingo" WHERE ("Lingo"."Locale" = ?) AND ("Lingo"."Entity" = ?) ORDER BY "Lingo"."Familyname" ASC LIMIT 1 0.0006s
0033: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", CASE WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."Fallback" ELSE "SiteTree_Live"."Fallback" END AS "Fallback", CASE WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."FallbackLink" ELSE "SiteTree_Live"."FallbackLink" END AS "FallbackLink", "SiteTree_Live"."FallbackResponseCode", CASE WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."TwitterSite" ELSE "SiteTree_Live"."TwitterSite" END AS "TwitterSite", CASE WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."TwitterCreator" ELSE "SiteTree_Live"."TwitterCreator" END AS "TwitterCreator", CASE WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."TwitterTitle" ELSE "SiteTree_Live"."TwitterTitle" END AS "TwitterTitle", CASE WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."TwitterCardType" ELSE "SiteTree_Live"."TwitterCardType" END AS "TwitterCardType", CASE WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."TwitterDescription" ELSE "SiteTree_Live"."TwitterDescription" END AS "TwitterDescription", "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"."VanityMappingID", "SiteTree_Live"."TwitterImageID", "SiteTree_Live"."ParentID", "SiteTree_Live"."ID", CASE WHEN "SiteTree_Live"."ClassName" IS NOT NULL THEN "SiteTree_Live"."ClassName" ELSE 'SilverStripe\\CMS\\Model\\SiteTree' END AS "RecordClassName", 'en_US' AS "Locale", CASE WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN 'en_US' ELSE NULL END AS "SourceLocale" FROM "SiteTree_Live" LEFT JOIN "SiteTree_Localised_Live" AS "SiteTree_Localised_en_US" ON "SiteTree_Live"."ID" = "SiteTree_Localised_en_US"."RecordID" AND "SiteTree_Localised_en_US"."Locale" = ? WHERE ("SiteTree_Live"."ID" = ?) AND (("SiteTree_Localised_en_US"."ID" IS NOT NULL)) ORDER BY "SiteTree_Live"."Sort" ASC LIMIT 1 0.0007s
0034: 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.0005s
0035: SELECT DISTINCT "Member"."ClassName", "Member"."LastEdited", "Member"."Created", "Member"."DisableAdminToolbar", "Member"."AdminToolbarDefaultCollapsed", "Member"."URLSegment", "Member"."BlogProfileSummary", "Member"."Phone", "Member"."City", "Member"."Country", "Member"."ShowCard", "Member"."MyFacebook", "Member"."MyLinkedIn", "Member"."FirstName", "Member"."Surname", "Member"."Email", "Member"."TempIDHash", "Member"."TempIDExpired", "Member"."Password", "Member"."AutoLoginHash", "Member"."AutoLoginExpired", "Member"."PasswordEncryption", "Member"."Salt", "Member"."PasswordExpiry", "Member"."LockedOutUntil", "Member"."Locale", "Member"."FailedLoginCount", "Member"."BlogProfileImageID", "Member"."ID", CASE WHEN "Member"."ClassName" IS NOT NULL THEN "Member"."ClassName" ELSE 'SilverStripe\\Security\\Member' END AS "RecordClassName" FROM "Member" INNER JOIN "BlogPost_Authors" ON "BlogPost_Authors"."MemberID" = "Member"."ID" WHERE ("BlogPost_Authors"."BlogPostID" = ?) ORDER BY "Member"."Surname" ASC, "Member"."FirstName" ASC 0.0006s
0036: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", CASE WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."Fallback" ELSE "SiteTree_Live"."Fallback" END AS "Fallback", CASE WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."FallbackLink" ELSE "SiteTree_Live"."FallbackLink" END AS "FallbackLink", "SiteTree_Live"."FallbackResponseCode", CASE WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."TwitterSite" ELSE "SiteTree_Live"."TwitterSite" END AS "TwitterSite", CASE WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."TwitterCreator" ELSE "SiteTree_Live"."TwitterCreator" END AS "TwitterCreator", CASE WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."TwitterTitle" ELSE "SiteTree_Live"."TwitterTitle" END AS "TwitterTitle", CASE WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."TwitterCardType" ELSE "SiteTree_Live"."TwitterCardType" END AS "TwitterCardType", CASE WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."TwitterDescription" ELSE "SiteTree_Live"."TwitterDescription" END AS "TwitterDescription", "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"."VanityMappingID", "SiteTree_Live"."TwitterImageID", "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.0023s
0037: 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.0015s
0038: SELECT DISTINCT "Member"."ClassName", "Member"."LastEdited", "Member"."Created", "Member"."DisableAdminToolbar", "Member"."AdminToolbarDefaultCollapsed", "Member"."URLSegment", "Member"."BlogProfileSummary", "Member"."Phone", "Member"."City", "Member"."Country", "Member"."ShowCard", "Member"."MyFacebook", "Member"."MyLinkedIn", "Member"."FirstName", "Member"."Surname", "Member"."Email", "Member"."TempIDHash", "Member"."TempIDExpired", "Member"."Password", "Member"."AutoLoginHash", "Member"."AutoLoginExpired", "Member"."PasswordEncryption", "Member"."Salt", "Member"."PasswordExpiry", "Member"."LockedOutUntil", "Member"."Locale", "Member"."FailedLoginCount", "Member"."BlogProfileImageID", "Member"."ID", CASE WHEN "Member"."ClassName" IS NOT NULL THEN "Member"."ClassName" ELSE 'SilverStripe\\Security\\Member' END AS "RecordClassName" FROM "Member" INNER JOIN "BlogPost_Authors" ON "BlogPost_Authors"."MemberID" = "Member"."ID" WHERE ("BlogPost_Authors"."BlogPostID" = ?) ORDER BY "Member"."Surname" ASC, "Member"."FirstName" ASC 0.0012s
0039: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", CASE WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."Fallback" ELSE "SiteTree_Live"."Fallback" END AS "Fallback", CASE WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."FallbackLink" ELSE "SiteTree_Live"."FallbackLink" END AS "FallbackLink", "SiteTree_Live"."FallbackResponseCode", CASE WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."TwitterSite" ELSE "SiteTree_Live"."TwitterSite" END AS "TwitterSite", CASE WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."TwitterCreator" ELSE "SiteTree_Live"."TwitterCreator" END AS "TwitterCreator", CASE WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."TwitterTitle" ELSE "SiteTree_Live"."TwitterTitle" END AS "TwitterTitle", CASE WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."TwitterCardType" ELSE "SiteTree_Live"."TwitterCardType" END AS "TwitterCardType", CASE WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."TwitterDescription" ELSE "SiteTree_Live"."TwitterDescription" END AS "TwitterDescription", "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"."VanityMappingID", "SiteTree_Live"."TwitterImageID", "SiteTree_Live"."ParentID", "SiteTree_Live"."ID", CASE WHEN "SiteTree_Live"."ClassName" IS NOT NULL THEN "SiteTree_Live"."ClassName" ELSE 'SilverStripe\\CMS\\Model\\SiteTree' END AS "RecordClassName", 'en_US' AS "Locale", CASE WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN 'en_US' ELSE NULL END AS "SourceLocale" FROM "SiteTree_Live" LEFT JOIN "SiteTree_Localised_Live" AS "SiteTree_Localised_en_US" ON "SiteTree_Live"."ID" = "SiteTree_Localised_en_US"."RecordID" AND "SiteTree_Localised_en_US"."Locale" = ? WHERE ("SiteTree_Live"."ID" = ?) AND (("SiteTree_Localised_en_US"."ID" IS NOT NULL)) ORDER BY "SiteTree_Live"."Sort" ASC LIMIT 1 0.0011s
0040: 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.0007s
0041: SELECT DISTINCT "Member"."ClassName", "Member"."LastEdited", "Member"."Created", "Member"."DisableAdminToolbar", "Member"."AdminToolbarDefaultCollapsed", "Member"."URLSegment", "Member"."BlogProfileSummary", "Member"."Phone", "Member"."City", "Member"."Country", "Member"."ShowCard", "Member"."MyFacebook", "Member"."MyLinkedIn", "Member"."FirstName", "Member"."Surname", "Member"."Email", "Member"."TempIDHash", "Member"."TempIDExpired", "Member"."Password", "Member"."AutoLoginHash", "Member"."AutoLoginExpired", "Member"."PasswordEncryption", "Member"."Salt", "Member"."PasswordExpiry", "Member"."LockedOutUntil", "Member"."Locale", "Member"."FailedLoginCount", "Member"."BlogProfileImageID", "Member"."ID", CASE WHEN "Member"."ClassName" IS NOT NULL THEN "Member"."ClassName" ELSE 'SilverStripe\\Security\\Member' END AS "RecordClassName" FROM "Member" INNER JOIN "BlogPost_Authors" ON "BlogPost_Authors"."MemberID" = "Member"."ID" WHERE ("BlogPost_Authors"."BlogPostID" = ?) ORDER BY "Member"."Surname" ASC, "Member"."FirstName" ASC 0.0035s
0042: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", CASE WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."Fallback" ELSE "SiteTree_Live"."Fallback" END AS "Fallback", CASE WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."FallbackLink" ELSE "SiteTree_Live"."FallbackLink" END AS "FallbackLink", "SiteTree_Live"."FallbackResponseCode", CASE WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."TwitterSite" ELSE "SiteTree_Live"."TwitterSite" END AS "TwitterSite", CASE WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."TwitterCreator" ELSE "SiteTree_Live"."TwitterCreator" END AS "TwitterCreator", CASE WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."TwitterTitle" ELSE "SiteTree_Live"."TwitterTitle" END AS "TwitterTitle", CASE WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."TwitterCardType" ELSE "SiteTree_Live"."TwitterCardType" END AS "TwitterCardType", CASE WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."TwitterDescription" ELSE "SiteTree_Live"."TwitterDescription" END AS "TwitterDescription", "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"."VanityMappingID", "SiteTree_Live"."TwitterImageID", "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.0746s
0043: 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.0006s
0044: SELECT DISTINCT "Member"."ClassName", "Member"."LastEdited", "Member"."Created", "Member"."DisableAdminToolbar", "Member"."AdminToolbarDefaultCollapsed", "Member"."URLSegment", "Member"."BlogProfileSummary", "Member"."Phone", "Member"."City", "Member"."Country", "Member"."ShowCard", "Member"."MyFacebook", "Member"."MyLinkedIn", "Member"."FirstName", "Member"."Surname", "Member"."Email", "Member"."TempIDHash", "Member"."TempIDExpired", "Member"."Password", "Member"."AutoLoginHash", "Member"."AutoLoginExpired", "Member"."PasswordEncryption", "Member"."Salt", "Member"."PasswordExpiry", "Member"."LockedOutUntil", "Member"."Locale", "Member"."FailedLoginCount", "Member"."BlogProfileImageID", "Member"."ID", CASE WHEN "Member"."ClassName" IS NOT NULL THEN "Member"."ClassName" ELSE 'SilverStripe\\Security\\Member' END AS "RecordClassName" FROM "Member" INNER JOIN "BlogPost_Authors" ON "BlogPost_Authors"."MemberID" = "Member"."ID" WHERE ("BlogPost_Authors"."BlogPostID" = ?) ORDER BY "Member"."Surname" ASC, "Member"."FirstName" ASC 0.0007s
0045: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", CASE WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."Fallback" ELSE "SiteTree_Live"."Fallback" END AS "Fallback", CASE WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."FallbackLink" ELSE "SiteTree_Live"."FallbackLink" END AS "FallbackLink", "SiteTree_Live"."FallbackResponseCode", CASE WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."TwitterSite" ELSE "SiteTree_Live"."TwitterSite" END AS "TwitterSite", CASE WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."TwitterCreator" ELSE "SiteTree_Live"."TwitterCreator" END AS "TwitterCreator", CASE WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."TwitterTitle" ELSE "SiteTree_Live"."TwitterTitle" END AS "TwitterTitle", CASE WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."TwitterCardType" ELSE "SiteTree_Live"."TwitterCardType" END AS "TwitterCardType", CASE WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."TwitterDescription" ELSE "SiteTree_Live"."TwitterDescription" END AS "TwitterDescription", "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"."VanityMappingID", "SiteTree_Live"."TwitterImageID", "SiteTree_Live"."ParentID", "SiteTree_Live"."ID", CASE WHEN "SiteTree_Live"."ClassName" IS NOT NULL THEN "SiteTree_Live"."ClassName" ELSE 'SilverStripe\\CMS\\Model\\SiteTree' END AS "RecordClassName", 'en_US' AS "Locale", CASE WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN 'en_US' ELSE NULL END AS "SourceLocale" FROM "SiteTree_Live" LEFT JOIN "SiteTree_Localised_Live" AS "SiteTree_Localised_en_US" ON "SiteTree_Live"."ID" = "SiteTree_Localised_en_US"."RecordID" AND "SiteTree_Localised_en_US"."Locale" = ? WHERE ("SiteTree_Live"."ID" = ?) AND (("SiteTree_Localised_en_US"."ID" IS NOT NULL)) ORDER BY "SiteTree_Live"."Sort" ASC LIMIT 1 0.0012s
0046: 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.0013s
0047: SELECT DISTINCT "Member"."ClassName", "Member"."LastEdited", "Member"."Created", "Member"."DisableAdminToolbar", "Member"."AdminToolbarDefaultCollapsed", "Member"."URLSegment", "Member"."BlogProfileSummary", "Member"."Phone", "Member"."City", "Member"."Country", "Member"."ShowCard", "Member"."MyFacebook", "Member"."MyLinkedIn", "Member"."FirstName", "Member"."Surname", "Member"."Email", "Member"."TempIDHash", "Member"."TempIDExpired", "Member"."Password", "Member"."AutoLoginHash", "Member"."AutoLoginExpired", "Member"."PasswordEncryption", "Member"."Salt", "Member"."PasswordExpiry", "Member"."LockedOutUntil", "Member"."Locale", "Member"."FailedLoginCount", "Member"."BlogProfileImageID", "Member"."ID", CASE WHEN "Member"."ClassName" IS NOT NULL THEN "Member"."ClassName" ELSE 'SilverStripe\\Security\\Member' END AS "RecordClassName" FROM "Member" INNER JOIN "BlogPost_Authors" ON "BlogPost_Authors"."MemberID" = "Member"."ID" WHERE ("BlogPost_Authors"."BlogPostID" = ?) ORDER BY "Member"."Surname" ASC, "Member"."FirstName" ASC 0.0013s
0048: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", CASE WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."Fallback" ELSE "SiteTree_Live"."Fallback" END AS "Fallback", CASE WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."FallbackLink" ELSE "SiteTree_Live"."FallbackLink" END AS "FallbackLink", "SiteTree_Live"."FallbackResponseCode", CASE WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."TwitterSite" ELSE "SiteTree_Live"."TwitterSite" END AS "TwitterSite", CASE WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."TwitterCreator" ELSE "SiteTree_Live"."TwitterCreator" END AS "TwitterCreator", CASE WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."TwitterTitle" ELSE "SiteTree_Live"."TwitterTitle" END AS "TwitterTitle", CASE WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."TwitterCardType" ELSE "SiteTree_Live"."TwitterCardType" END AS "TwitterCardType", CASE WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."TwitterDescription" ELSE "SiteTree_Live"."TwitterDescription" END AS "TwitterDescription", "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"."VanityMappingID", "SiteTree_Live"."TwitterImageID", "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.0015s
0049: 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.0006s
0050: SELECT DISTINCT "Member"."ClassName", "Member"."LastEdited", "Member"."Created", "Member"."DisableAdminToolbar", "Member"."AdminToolbarDefaultCollapsed", "Member"."URLSegment", "Member"."BlogProfileSummary", "Member"."Phone", "Member"."City", "Member"."Country", "Member"."ShowCard", "Member"."MyFacebook", "Member"."MyLinkedIn", "Member"."FirstName", "Member"."Surname", "Member"."Email", "Member"."TempIDHash", "Member"."TempIDExpired", "Member"."Password", "Member"."AutoLoginHash", "Member"."AutoLoginExpired", "Member"."PasswordEncryption", "Member"."Salt", "Member"."PasswordExpiry", "Member"."LockedOutUntil", "Member"."Locale", "Member"."FailedLoginCount", "Member"."BlogProfileImageID", "Member"."ID", CASE WHEN "Member"."ClassName" IS NOT NULL THEN "Member"."ClassName" ELSE 'SilverStripe\\Security\\Member' END AS "RecordClassName" FROM "Member" INNER JOIN "BlogPost_Authors" ON "BlogPost_Authors"."MemberID" = "Member"."ID" WHERE ("BlogPost_Authors"."BlogPostID" = ?) ORDER BY "Member"."Surname" ASC, "Member"."FirstName" ASC 0.0013s
0051: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", CASE WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."Fallback" ELSE "SiteTree_Live"."Fallback" END AS "Fallback", CASE WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."FallbackLink" ELSE "SiteTree_Live"."FallbackLink" END AS "FallbackLink", "SiteTree_Live"."FallbackResponseCode", CASE WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."TwitterSite" ELSE "SiteTree_Live"."TwitterSite" END AS "TwitterSite", CASE WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."TwitterCreator" ELSE "SiteTree_Live"."TwitterCreator" END AS "TwitterCreator", CASE WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US".&q