0001: SET sql_mode = ? 0.0015s 0002: SHOW DATABASES LIKE 'bycsgkvss4' 0.0007s 0003: SHOW FULL TABLES WHERE Table_Type != 'VIEW' 0.0026s 0004: SHOW FULL FIELDS IN "Fluent_Domain" 0.0018s 0005: SHOW COLLATION LIKE 'utf8mb4_unicode_ci' 0.0442s 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.0004s 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.0022s 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.0025s 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.0609s 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.0007s 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.0016s 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.0008s 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.0011s 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.0021s 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.0013s 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.0022s 0019: SELECT CASE WHEN EXISTS(SELECT * FROM "BlogCategory" WHERE ("BlogCategory"."BlogID" = ?)) THEN 1 ELSE 0 END 0.001s 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.0018s 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.0033s 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.0025s 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.0023s 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.0021s 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.0016s 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.0041s 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-19 21:52:59')) THEN 1 ELSE 0 END 0.0052s 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-19 21:52:59') ORDER BY "_SortColumn0" DESC, "BlogPost_Live"."PublishDate" DESC LIMIT 500 0.0663s 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.0088s 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.0017s 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.0018s 0032: 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.0041s 0033: 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.0035s 0034: 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.0024s 0035: 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.0013s 0036: 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.0019s 0037: 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 0038: 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 0039: 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.0009s 0040: 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 0041: 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.0013s 0042: 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.0012s 0043: 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.065s 0044: 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.0014s 0045: 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 0046: 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.015s 0047: 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.0056s 0048: 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.003s 0049: 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.0022s 0050: 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.002s 0051: 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 0052: 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.004s 0053: 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.0031s 0054: 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.0043s 0055: 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.0032s 0056: 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 0057: 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.0008s 0058: 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 0059: 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.0561s 0060: 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 0061: 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.0008s 0062: 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.0049s 0063: 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 0064: 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.0009s 0065: 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 0066: 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 0067: 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.0015s 0068: 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.0009s 0069: 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.0012s 0070: 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.001s 0071: 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.0575s 0072: 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 0073: 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.0008s 0074: 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.0013s 0075: 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.0009s 0076: 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.0017s 0077: 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.0043s 0078: 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.0008s 0079: 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 0080: 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.0009s 0081: 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 0082: 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.0009s 0083: 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.0008s 0084: 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 0085: 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.0024s 0086: 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.0008s 0087: 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 0088: 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 0089: 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.001s 0090: 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.0008s 0091: 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.0015s 0092: 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 0093: 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 0094: 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.0011s 0095: 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.0008s 0096: 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.0008s 0097: 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 0098: 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.0016s 0099: 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 0100: 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.0008s 0101: 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.0636s 0102: 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.001s 0103: 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.0009s 0104: 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.003s 0105: 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 0106: 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.001s 0107: 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 0108: 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" = ?) ORDER BY "File_Live"."Name" ASC LIMIT 1 0.0007s 0109: 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" = ?) ORDER BY "File_Live"."Name" ASC LIMIT 1 0.0019s 0110: 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.001s 0111: 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.0014s 0112: 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.0008s 0113: 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" = ?) ORDER BY "File_Live"."Name" ASC LIMIT 1 0.0011s 0114: 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" = ?) ORDER BY "File_Live"."Name" ASC LIMIT 1 0.0006s 0115: 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" = ?) ORDER BY "File_Live"."Name" ASC LIMIT 1 0.0006s 0116: 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" = ?) ORDER BY "File_Live"."Name" ASC LIMIT 1 0.0073s 0117: 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" = ?) ORDER BY "File_Live"."Name" ASC LIMIT 1 0.0027s 0118: SELECT DISTINCT count(DISTINCT "SiteTree_Live"."ID") AS "Count" 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-19 21:53:00') 0.0017s 0119: SELECT DISTINCT "LinkMapping"."ClassName", "LinkMapping"."LastEdited", "LinkMapping"."Created", "LinkMapping"."LinkType", "LinkMapping"."MappedLink", "LinkMapping"."IncludesHostname", "LinkMapping"."Priority", "LinkMapping"."RedirectType", "LinkMapping"."RedirectLink", "LinkMapping"."RedirectPageID", "LinkMapping"."ResponseCode", "LinkMapping"."HostnameRestriction", "LinkMapping"."ID", CASE WHEN "LinkMapping"."ClassName" IS NOT NULL THEN "LinkMapping"."ClassName" ELSE 'nglasl\\misdirection\\LinkMapping' END AS "RecordClassName" FROM "LinkMapping" WHERE ((HostnameRestriction IS NULL) OR (HostnameRestriction = 'www.track-pod.com')) AND ("LinkMapping"."LinkType" = ?) ORDER BY "LinkMapping"."ID" DESC 0.0021s 0120: SELECT DISTINCT "LinkMapping"."ClassName", "LinkMapping"."LastEdited", "LinkMapping"."Created", "LinkMapping"."LinkType", "LinkMapping"."MappedLink", "LinkMapping"."IncludesHostname", "LinkMapping"."Priority", "LinkMapping"."RedirectType", "LinkMapping"."RedirectLink", "LinkMapping"."RedirectPageID", "LinkMapping"."ResponseCode", "LinkMapping"."HostnameRestriction", "LinkMapping"."ID", CASE WHEN "LinkMapping"."ClassName" IS NOT NULL THEN "LinkMapping"."ClassName" ELSE 'nglasl\\misdirection\\LinkMapping' END AS "RecordClassName" FROM "LinkMapping" WHERE ((HostnameRestriction IS NULL) OR (HostnameRestriction = 'www.track-pod.com')) AND ((LinkType = 'Simple') AND (((IncludesHostname = 0) AND ((MappedLink = 'blog/category/route-planning') OR (MappedLink LIKE 'blog/category/route-planning?%'))) OR ((IncludesHostname = 1) AND ((MappedLink = 'www.track-pod.com/blog/category/route-planning') OR (MappedLink LIKE 'www.track-pod.com/blog/category/route-planning?%'))))) ORDER BY "LinkMapping"."ID" DESC 0.002s 0121: SELECT DISTINCT "LinkMapping"."ClassName", "LinkMapping"."LastEdited", "LinkMapping"."Created", "LinkMapping"."LinkType", "LinkMapping"."MappedLink", "LinkMapping"."IncludesHostname", "LinkMapping"."Priority", "LinkMapping"."RedirectType", "LinkMapping"."RedirectLink", "LinkMapping"."RedirectPageID", "LinkMapping"."ResponseCode", "LinkMapping"."HostnameRestriction", "LinkMapping"."ID", CASE WHEN "LinkMapping"."ClassName" IS NOT NULL THEN "LinkMapping"."ClassName" ELSE 'nglasl\\misdirection\\LinkMapping' END AS "RecordClassName" FROM "LinkMapping" WHERE ((HostnameRestriction IS NULL) OR (HostnameRestriction = 'www.track-pod.com')) AND ("LinkMapping"."LinkType" = ?) ORDER BY "LinkMapping"."ID" DESC 0.0568s 0122: SELECT DISTINCT "LinkMapping"."ClassName", "LinkMapping"."LastEdited", "LinkMapping"."Created", "LinkMapping"."LinkType", "LinkMapping"."MappedLink", "LinkMapping"."IncludesHostname", "LinkMapping"."Priority", "LinkMapping"."RedirectType", "LinkMapping"."RedirectLink", "LinkMapping"."RedirectPageID", "LinkMapping"."ResponseCode", "LinkMapping"."HostnameRestriction", "LinkMapping"."ID", CASE WHEN "LinkMapping"."ClassName" IS NOT NULL THEN "LinkMapping"."ClassName" ELSE 'nglasl\\misdirection\\LinkMapping' END AS "RecordClassName" FROM "LinkMapping" WHERE ((HostnameRestriction IS NULL) OR (HostnameRestriction = 'www.track-pod.com')) AND ((LinkType = 'Simple') AND (((IncludesHostname = 0) AND ((MappedLink = 'blog/category/route-planning') OR (MappedLink LIKE 'blog/category/route-planning?%'))) OR ((IncludesHostname = 1) AND ((MappedLink = 'www.track-pod.com/blog/category/route-planning') OR (MappedLink LIKE 'www.track-pod.com/blog/category/route-planning?%'))))) ORDER BY "LinkMapping"."ID" DESC 0.0006s Blog - Page 1653769, In category Route Planning | Track-POD

Category: Route Planning

Explore logistics trends, best practices, and Track-POD product news

best route planner for 2026

by Andrey Baturin March 01, 2026

Best Route Planning Software in 2026

This guide compares Track-POD, RouteManager, Circuit, and Upper, covering features, pricing, routing quality, and best-fit scenarios to help businesses choose the best route planning software for 2026.

Read More
logistics route planning

by Alisa Cvilij August 08, 2024

Logistics Route Planning and Optimization: Most Important Aspects

Logistics route planning and optimization are used interchangeably; they have significant differences that make them unique.

Read More
truck route planner

by Alisa Cvilij July 30, 2024

Truck Route Planner: What Can It Do For Your Business

Trucking is an expensive business, with fuel and fleet maintenance costs constantly on the rise. Learn how to use a truck route planner to nail truck routing.

Read More
Shipping Label Generator

by Alina Kostukova May 15, 2024

Shipping Label Generator: Free & Easy to Use

How can small businesses use shipping labels to improve delivery success and customer service? How to make and print shipping labels in Track-POD route planner? Read more to find out.

Read More
Scheduling Deliveries Efficiently

by Andrey Baturin May 14, 2024

5 Tips for Scheduling Deliveries Efficiently + Free PDF Guide

Delivery scheduling is one of the core processes that determine the efficiency of your delivery operation. Learn how to nail delivery scheduling to keep your driver staff and customers happy.

Read More
Best Google Maps Alternatives

by Jennifer Collins March 05, 2024

Google Maps Alternatives for Multi-Stop Delivery Routing

Find the best Google Maps alternatives for efficient multi-stop delivery routing! This guide explores top solutions for enhancing business logistics.

Read More
track pod vs map quest

by Mike Foster March 04, 2024

How Effective Is MapQuest for Commercial Delivery Routing?

Learn all MapQuest can offer for commercial delivery routing and how that compares to more sophisticated, industry-leading solutions.

Read More
How Do Couriers Like UPS Plan Their Routes

by Mike Foster February 26, 2024

How Do Couriers Like UPS Plan Their Routes?

Small delivery businesses can operate at the same level of efficiency as industry leaders like UPS do. Learn all the tricks and tips.

Read More
Track POD Solving Small Business Routing problems

by Jennifer Collins February 22, 2024

Solving Small Business Routing Problems

Solve small business routing issues with efficient route planning tips and strategies. Learn how to streamline deliveries and optimize routes for your business's success.

Read More
Direct Store Delivery DSD

by Jennifer Collins February 21, 2024

Small Biz Strategies with Direct Store Delivery (DSD) Software

This article will delve into the features of direct store delivery software. We'll discuss how small businesses can utilize DSD software for efficient routing and scheduling.

Read More
Fleet Dispatch with Advanced Dispatch Management Systems

by Jennifer Collins January 08, 2024

Smart Ways to Enhance Fleet Dispatching

As manual methods struggle in today's complex business world, discover how advanced fleet dispatch systems make management seamless. Delve into the article for deeper insights into the transformation of fleet dispatch.

Read More
vehicle routing problems track pod

by Yulia Miashkova January 05, 2024

Vehicle Routing Problems: VRP Essentials Guide

Routing commercial vehicles comes with a lot of challenges at every turn. We put together a list of the most common mistakes in commercial vehicle routing so that you can avoid them route successfully.

Read More
Automated Delivery Route Scheduling

by Yulia Miashkova January 03, 2024

Automated Delivery Route Scheduling: 5 Advanced Tips to Optimize Your Logistics

Even with fully automated route scheduling there's room for improvement. Use these 5 advanced tips to elevate your delivery routing game and save maximum time on scheduling.

Read More
Route Management for Small Businesses

by Andrey Baturin January 03, 2024

Route Management Best Practices for Small Businesses: A Roadmap to Success

Explore how to use a multi stop route planner as a delivery driver or business owner to optimize your business and digitize your deliveries & dropoffs.

Read More
manual vs automated route planning

by Yulia Miashkova August 24, 2022

Manual vs Automated Route Planning: Final Verdict

While many delivery operations are enjoying the benefits of fully automated vehicle routing, a substantial amount of companies are still routing their fleets the old way - and not without a reason.

Read More
field service scheduling and routing

by Yulia Miashkova July 25, 2022

5 Foolproof Tips for Field Service Scheduling & Routing

Scheduling and routing for field services comes with unique challenges that can be addressed with these proven tips. Dive in to improve your field service routing today.

Read More
interstate delivery services

by Yulia Miashkova July 13, 2022

Interstate Shipping: Routing Solutions for Interstate Delivery Services

Providers of interstate delivery services need routing solutions that support multi-day route scheduling and management. Learn about Track-POD features that power interstate shipping.  

Read More
cut off time meaning

by Yulia Miashkova May 23, 2022

How to Extend Cut Off Time w/ Smart Route Planning

Cut off time is the latest you can process an order for same-day, next-day, or overnight delivery. Learn how you can extend your cut off time with smart route planning and other automations.

Read More
EV routing for carbon neutral delivery teams

by Yulia Miashkova May 05, 2022

EV Routing for Carbon Neutral Delivery Teams

EV routing is different from routing gas trucks. In this blog post, we explore tactics and Track-POD solutions for route planning for a fleet of electric vehicles.

Read More
dynamic route optimization

by Yulia Miashkova April 20, 2022

Dynamic Route Optimization: 5 Essential Features

For any delivery business, route optimization is a must but does it have to be dynamic to be cost-efficient? Dive in to learn about 5 essential features of dynamic route optimization software.

Read More
what is a milk run in logistics and trucking

by Yulia Miashkova March 24, 2022

What Is a Milk Run in Logistics? Spoiler: It's Not About Milk At All

Milk runs are recurring deliveries to regular customers - B2B and B2C alike. Dive in to learn about milk runs in logistics and trucking with real-life business examples.

Read More
Route Optimization with time slots

by Andrey Baturin August 26, 2021

Time Slots for Delivery Success: Why Use Time Slots in Delivery Management

Time slots is a feature that lets you group delivery locations not only geographically but also according to each customer's preferred time slot. Learn how time slots can help you improve delivery success.

Read More
truck route planning software

by Tanya Derevyanko April 06, 2021

13 Reasons Why Trucking Software Is a Necessity

Any fleet or logistics manager understands the type of headache that routing trucks can bring. Trucking software can help you overcome most of the challenges presented.

Read More
route planning truck driver safety

by Andrey Baturin March 25, 2021

Route Planning and Truck Driver Safety

If your business deals in delivery or transportation, truck driver safety ought to be at the top of your priority list.

Read More
Route optimization and iT effectiveness 2020 review in the delivery business9

December 29, 2020

Route optimization and its effectiveness. How COVID-19 has affected delivery businesses.

In this series of infographics, we look at statistics from more than 2.

Read More