0001: SET sql_mode = ? 0.0004s

0002: SHOW DATABASES LIKE 'udensdiena\_prod\_test' 0.0007s

0003: SHOW FULL TABLES WHERE Table_Type != 'VIEW' 0.0027s

0004: SHOW FULL FIELDS IN "Fluent_Domain" 0.0009s

0005: SHOW COLLATION LIKE 'utf8_general_ci' 0.0004s

0006: SELECT DISTINCT "Fluent_Domain"."ClassName", "Fluent_Domain"."LastEdited", "Fluent_Domain"."Created", "Fluent_Domain"."Domain", "Fluent_Domain"."DefaultLocaleID", "Fluent_Domain"."ID", CASE WHEN "Fluent_Domain"."ClassName" IS NOT NULL THEN "Fluent_Domain"."ClassName" ELSE 'TractorCow\\Fluent\\Model\\Domain' END AS "RecordClassName" FROM "Fluent_Domain" 0.0003s

0007: SHOW FULL FIELDS IN "Fluent_Locale" 0.0007s

0008: SELECT DISTINCT "Fluent_Locale"."ClassName", "Fluent_Locale"."LastEdited", "Fluent_Locale"."Created", "Fluent_Locale"."Title", "Fluent_Locale"."Locale", "Fluent_Locale"."URLSegment", "Fluent_Locale"."IsGlobalDefault", "Fluent_Locale"."UseDefaultCode", "Fluent_Locale"."Sort", "Fluent_Locale"."Timezone", "Fluent_Locale"."DomainID", "Fluent_Locale"."ID", CASE WHEN "Fluent_Locale"."ClassName" IS NOT NULL THEN "Fluent_Locale"."ClassName" ELSE 'TractorCow\\Fluent\\Model\\Locale' END AS "RecordClassName" FROM "Fluent_Locale" ORDER BY "Fluent_Locale"."Sort" ASC, "Fluent_Locale"."Locale" ASC 0.0003s

0009: SELECT DISTINCT "Fluent_FallbackLocale"."ClassName", "Fluent_FallbackLocale"."LastEdited", "Fluent_FallbackLocale"."Created", "Fluent_FallbackLocale"."Sort", "Fluent_FallbackLocale"."ParentID", "Fluent_FallbackLocale"."LocaleID", "Fluent_FallbackLocale"."ID", CASE WHEN "Fluent_FallbackLocale"."ClassName" IS NOT NULL THEN "Fluent_FallbackLocale"."ClassName" ELSE 'TractorCow\\Fluent\\Model\\FallbackLocale' END AS "RecordClassName" FROM "Fluent_FallbackLocale" WHERE ("Fluent_FallbackLocale"."ParentID" = ?) ORDER BY "Fluent_FallbackLocale"."Sort" ASC 0.0007s

0010: 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" WHERE ("Fluent_Locale"."ID" = ?) ORDER BY "Fluent_Locale"."Sort" ASC, "Fluent_Locale"."Locale" ASC LIMIT 1 0.0005s

0011: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", "SiteTree_Live"."ShowInSitemap", "SiteTree_Live"."AvailableOffline", CASE WHEN "SiteTree_Localised_lv_LV"."ID" IS NOT NULL THEN "SiteTree_Localised_lv_LV"."ExtraCode" WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."ExtraCode" ELSE "SiteTree_Live"."ExtraCode" END AS "ExtraCode", "SiteTree_Live"."CanViewType", "SiteTree_Live"."CanEditType", "SiteTree_Live"."Version", CASE WHEN "SiteTree_Localised_lv_LV"."ID" IS NOT NULL THEN "SiteTree_Localised_lv_LV"."URLSegment" 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_lv_LV"."ID" IS NOT NULL THEN "SiteTree_Localised_lv_LV"."Title" 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_lv_LV"."ID" IS NOT NULL THEN "SiteTree_Localised_lv_LV"."MenuTitle" 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_lv_LV"."ID" IS NOT NULL THEN "SiteTree_Localised_lv_LV"."Content" 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_lv_LV"."ID" IS NOT NULL THEN "SiteTree_Localised_lv_LV"."MetaDescription" 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_lv_LV"."ID" IS NOT NULL THEN "SiteTree_Localised_lv_LV"."ReportClass" WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."ReportClass" ELSE "SiteTree_Live"."ReportClass" END AS "ReportClass", "SiteTree_Live"."ParentID", "SiteTree_Live"."ID", CASE WHEN "SiteTree_Live"."ClassName" IS NOT NULL THEN "SiteTree_Live"."ClassName" ELSE 'SilverStripe\\CMS\\Model\\SiteTree' END AS "RecordClassName", 'lv_LV' AS "Locale", CASE WHEN "SiteTree_Localised_lv_LV"."ID" IS NOT NULL THEN 'lv_LV' 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_lv_LV" ON "SiteTree_Live"."ID" = "SiteTree_Localised_lv_LV"."RecordID" AND "SiteTree_Localised_lv_LV"."Locale" = ? 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_lv_LV"."URLSegment", "SiteTree_Localised_en_US"."URLSegment", "SiteTree_Live"."URLSegment") = ?) AND ("SiteTree_Live"."ParentID" = ?) AND (("SiteTree_Localised_lv_LV"."ID" IS NOT NULL)) ORDER BY "SiteTree_Live"."Sort" ASC LIMIT 1 0.0016s

0012: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", "SiteTree_Live"."ShowInSitemap", "SiteTree_Live"."AvailableOffline", CASE WHEN "SiteTree_Localised_lv_LV"."ID" IS NOT NULL THEN "SiteTree_Localised_lv_LV"."ExtraCode" WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."ExtraCode" ELSE "SiteTree_Live"."ExtraCode" END AS "ExtraCode", "SiteTree_Live"."CanViewType", "SiteTree_Live"."CanEditType", "SiteTree_Live"."Version", CASE WHEN "SiteTree_Localised_lv_LV"."ID" IS NOT NULL THEN "SiteTree_Localised_lv_LV"."URLSegment" 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_lv_LV"."ID" IS NOT NULL THEN "SiteTree_Localised_lv_LV"."Title" 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_lv_LV"."ID" IS NOT NULL THEN "SiteTree_Localised_lv_LV"."MenuTitle" 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_lv_LV"."ID" IS NOT NULL THEN "SiteTree_Localised_lv_LV"."Content" 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_lv_LV"."ID" IS NOT NULL THEN "SiteTree_Localised_lv_LV"."MetaDescription" 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_lv_LV"."ID" IS NOT NULL THEN "SiteTree_Localised_lv_LV"."ReportClass" WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."ReportClass" ELSE "SiteTree_Live"."ReportClass" END AS "ReportClass", "SiteTree_Live"."ParentID", "SiteTree_Live"."ID", CASE WHEN "SiteTree_Live"."ClassName" IS NOT NULL THEN "SiteTree_Live"."ClassName" ELSE 'SilverStripe\\CMS\\Model\\SiteTree' END AS "RecordClassName", 'lv_LV' AS "Locale", CASE WHEN "SiteTree_Localised_lv_LV"."ID" IS NOT NULL THEN 'lv_LV' 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_lv_LV" ON "SiteTree_Live"."ID" = "SiteTree_Localised_lv_LV"."RecordID" AND "SiteTree_Localised_lv_LV"."Locale" = ? LEFT JOIN "SiteTree_Localised_Live" AS "SiteTree_Localised_en_US" ON "SiteTree_Live"."ID" = "SiteTree_Localised_en_US"."RecordID" AND "SiteTree_Localised_en_US"."Locale" = ? WHERE ("SiteTree_Live"."ParentID" = ?) AND (COALESCE("SiteTree_Localised_lv_LV"."URLSegment", "SiteTree_Localised_en_US"."URLSegment", "SiteTree_Live"."URLSegment") = ?) AND (("SiteTree_Localised_lv_LV"."ID" IS NOT NULL)) ORDER BY "SiteTree_Live"."Sort" ASC LIMIT 1 0.0013s

0013: SELECT DISTINCT "SiteConfig"."ClassName", "SiteConfig"."LastEdited", "SiteConfig"."Created", "SiteConfig"."FromEmail", CASE WHEN "SiteConfig_Localised_lv_LV"."ID" IS NOT NULL THEN "SiteConfig_Localised_lv_LV"."FooterContent" WHEN "SiteConfig_Localised_en_US"."ID" IS NOT NULL THEN "SiteConfig_Localised_en_US"."FooterContent" ELSE "SiteConfig"."FooterContent" END AS "FooterContent", CASE WHEN "SiteConfig_Localised_lv_LV"."ID" IS NOT NULL THEN "SiteConfig_Localised_lv_LV"."SecurityLostPasswordContent" WHEN "SiteConfig_Localised_en_US"."ID" IS NOT NULL THEN "SiteConfig_Localised_en_US"."SecurityLostPasswordContent" ELSE "SiteConfig"."SecurityLostPasswordContent" END AS "SecurityLostPasswordContent", CASE WHEN "SiteConfig_Localised_lv_LV"."ID" IS NOT NULL THEN "SiteConfig_Localised_lv_LV"."SecurityChangePasswordContent" WHEN "SiteConfig_Localised_en_US"."ID" IS NOT NULL THEN "SiteConfig_Localised_en_US"."SecurityChangePasswordContent" ELSE "SiteConfig"."SecurityChangePasswordContent" END AS "SecurityChangePasswordContent", CASE WHEN "SiteConfig_Localised_lv_LV"."ID" IS NOT NULL THEN "SiteConfig_Localised_lv_LV"."WatterBannerTitle" WHEN "SiteConfig_Localised_en_US"."ID" IS NOT NULL THEN "SiteConfig_Localised_en_US"."WatterBannerTitle" ELSE "SiteConfig"."WatterBannerTitle" END AS "WatterBannerTitle", "SiteConfig"."VoteStart", "SiteConfig"."DisableNewVotes", "SiteConfig"."ShowTopNotification", CASE WHEN "SiteConfig_Localised_lv_LV"."ID" IS NOT NULL THEN "SiteConfig_Localised_lv_LV"."TopNotificationContent" WHEN "SiteConfig_Localised_en_US"."ID" IS NOT NULL THEN "SiteConfig_Localised_en_US"."TopNotificationContent" ELSE "SiteConfig"."TopNotificationContent" END AS "TopNotificationContent", "SiteConfig"."ShowNotifications", "SiteConfig"."ExtraCode", "SiteConfig"."Lng", "SiteConfig"."Lat", "SiteConfig"."MapZoom", "SiteConfig"."Description", "SiteConfig"."Address", "SiteConfig"."Suburb", "SiteConfig"."State", "SiteConfig"."Country", "SiteConfig"."ZipCode", "SiteConfig"."Title", "SiteConfig"."Tagline", "SiteConfig"."CanViewType", "SiteConfig"."CanEditType", "SiteConfig"."CanCreateTopLevelType", "SiteConfig"."AboutPageID", "SiteConfig"."WatterBannerImageID", "SiteConfig"."VoteStartPageID", "SiteConfig"."PrivacyPolicyID", "SiteConfig"."SitemapID", "SiteConfig"."FacebookID", "SiteConfig"."LinkedInID", "SiteConfig"."PinterestID", "SiteConfig"."InstagramID", "SiteConfig"."TwitterID", "SiteConfig"."YouTubeID", "SiteConfig"."PublicEmailID", "SiteConfig"."PhoneNumberID", "SiteConfig"."TiktokID", "SiteConfig"."ID", CASE WHEN "SiteConfig"."ClassName" IS NOT NULL THEN "SiteConfig"."ClassName" ELSE 'SilverStripe\\SiteConfig\\SiteConfig' END AS "RecordClassName", 'lv_LV' AS "Locale", CASE WHEN "SiteConfig_Localised_lv_LV"."ID" IS NOT NULL THEN 'lv_LV' 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_lv_LV" ON "SiteConfig"."ID" = "SiteConfig_Localised_lv_LV"."RecordID" AND "SiteConfig_Localised_lv_LV"."Locale" = ? 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.0016s

0014: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", "SiteTree_Live"."ShowInSitemap", "SiteTree_Live"."AvailableOffline", CASE WHEN "SiteTree_Localised_lv_LV"."ID" IS NOT NULL THEN "SiteTree_Localised_lv_LV"."ExtraCode" WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."ExtraCode" ELSE "SiteTree_Live"."ExtraCode" END AS "ExtraCode", "SiteTree_Live"."CanViewType", "SiteTree_Live"."CanEditType", "SiteTree_Live"."Version", CASE WHEN "SiteTree_Localised_lv_LV"."ID" IS NOT NULL THEN "SiteTree_Localised_lv_LV"."URLSegment" 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_lv_LV"."ID" IS NOT NULL THEN "SiteTree_Localised_lv_LV"."Title" 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_lv_LV"."ID" IS NOT NULL THEN "SiteTree_Localised_lv_LV"."MenuTitle" 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_lv_LV"."ID" IS NOT NULL THEN "SiteTree_Localised_lv_LV"."Content" 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_lv_LV"."ID" IS NOT NULL THEN "SiteTree_Localised_lv_LV"."MetaDescription" 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_lv_LV"."ID" IS NOT NULL THEN "SiteTree_Localised_lv_LV"."ReportClass" WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."ReportClass" ELSE "SiteTree_Live"."ReportClass" END AS "ReportClass", "SiteTree_Live"."ParentID", "SiteTree_Live"."ID", CASE WHEN "SiteTree_Live"."ClassName" IS NOT NULL THEN "SiteTree_Live"."ClassName" ELSE 'SilverStripe\\CMS\\Model\\SiteTree' END AS "RecordClassName", 'lv_LV' AS "Locale", CASE WHEN "SiteTree_Localised_lv_LV"."ID" IS NOT NULL THEN 'lv_LV' 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_lv_LV" ON "SiteTree_Live"."ID" = "SiteTree_Localised_lv_LV"."RecordID" AND "SiteTree_Localised_lv_LV"."Locale" = ? 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_lv_LV"."ID" IS NOT NULL)) ORDER BY "SiteTree_Live"."Sort" ASC LIMIT 1 0.0008s

0015: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", "SiteTree_Live"."ShowInSitemap", "SiteTree_Live"."AvailableOffline", CASE WHEN "SiteTree_Localised_lv_LV"."ID" IS NOT NULL THEN "SiteTree_Localised_lv_LV"."ExtraCode" WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."ExtraCode" ELSE "SiteTree_Live"."ExtraCode" END AS "ExtraCode", "SiteTree_Live"."CanViewType", "SiteTree_Live"."CanEditType", "SiteTree_Live"."Version", CASE WHEN "SiteTree_Localised_lv_LV"."ID" IS NOT NULL THEN "SiteTree_Localised_lv_LV"."URLSegment" 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_lv_LV"."ID" IS NOT NULL THEN "SiteTree_Localised_lv_LV"."Title" 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_lv_LV"."ID" IS NOT NULL THEN "SiteTree_Localised_lv_LV"."MenuTitle" 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_lv_LV"."ID" IS NOT NULL THEN "SiteTree_Localised_lv_LV"."Content" 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_lv_LV"."ID" IS NOT NULL THEN "SiteTree_Localised_lv_LV"."MetaDescription" 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_lv_LV"."ID" IS NOT NULL THEN "SiteTree_Localised_lv_LV"."ReportClass" WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."ReportClass" ELSE "SiteTree_Live"."ReportClass" END AS "ReportClass", "SiteTree_Live"."ParentID", "SiteTree_Live"."ID", CASE WHEN "SiteTree_Live"."ClassName" IS NOT NULL THEN "SiteTree_Live"."ClassName" ELSE 'SilverStripe\\CMS\\Model\\SiteTree' END AS "RecordClassName", 'lv_LV' AS "Locale", CASE WHEN "SiteTree_Localised_lv_LV"."ID" IS NOT NULL THEN 'lv_LV' 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_lv_LV" ON "SiteTree_Live"."ID" = "SiteTree_Localised_lv_LV"."RecordID" AND "SiteTree_Localised_lv_LV"."Locale" = ? 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_lv_LV"."ID" IS NOT NULL)) ORDER BY "SiteTree_Live"."Sort" ASC LIMIT 1 0.0008s

0016: SELECT "Version" FROM "SiteTree_Live" WHERE "ID" = ? 0.0005s

0017: SELECT "ID" FROM "SiteTree_Localised_Live" WHERE ("RecordID" = ?) AND ("Locale" = ?) LIMIT 1 0.0004s

0018: SELECT "ID" FROM "SiteTree_Localised_Live" WHERE ("RecordID" = ?) AND ("Locale" = ?) LIMIT 1 0.0004s

0019: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", "SiteTree_Live"."ShowInSitemap", "SiteTree_Live"."AvailableOffline", CASE WHEN "SiteTree_Localised_lv_LV"."ID" IS NOT NULL THEN "SiteTree_Localised_lv_LV"."ExtraCode" WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."ExtraCode" ELSE "SiteTree_Live"."ExtraCode" END AS "ExtraCode", "SiteTree_Live"."CanViewType", "SiteTree_Live"."CanEditType", "SiteTree_Live"."Version", CASE WHEN "SiteTree_Localised_lv_LV"."ID" IS NOT NULL THEN "SiteTree_Localised_lv_LV"."URLSegment" 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_lv_LV"."ID" IS NOT NULL THEN "SiteTree_Localised_lv_LV"."Title" 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_lv_LV"."ID" IS NOT NULL THEN "SiteTree_Localised_lv_LV"."MenuTitle" 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_lv_LV"."ID" IS NOT NULL THEN "SiteTree_Localised_lv_LV"."Content" 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_lv_LV"."ID" IS NOT NULL THEN "SiteTree_Localised_lv_LV"."MetaDescription" 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_lv_LV"."ID" IS NOT NULL THEN "SiteTree_Localised_lv_LV"."ReportClass" WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."ReportClass" ELSE "SiteTree_Live"."ReportClass" END AS "ReportClass", "SiteTree_Live"."ParentID", "Page_Live"."InheritSideBar", "Page_Live"."BlockIcon", "Page_Live"."SideBarID", "Page_Live"."ElementalAreaID", "SiteTree_Live"."ID", CASE WHEN "SiteTree_Live"."ClassName" IS NOT NULL THEN "SiteTree_Live"."ClassName" ELSE 'SilverStripe\\CMS\\Model\\SiteTree' END AS "RecordClassName", 'lv_LV' AS "Locale", CASE WHEN "SiteTree_Localised_lv_LV"."ID" IS NOT NULL THEN 'lv_LV' WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN 'en_US' ELSE NULL END AS "SourceLocale" FROM "SiteTree_Live" LEFT JOIN "Page_Live" ON "Page_Live"."ID" = "SiteTree_Live"."ID" LEFT JOIN "SiteTree_Localised_Live" AS "SiteTree_Localised_lv_LV" ON "SiteTree_Live"."ID" = "SiteTree_Localised_lv_LV"."RecordID" AND "SiteTree_Localised_lv_LV"."Locale" = ? 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_Live"."ClassName" IN (?)) AND (("SiteTree_Localised_lv_LV"."ID" IS NOT NULL)) ORDER BY "SiteTree_Live"."Sort" ASC LIMIT 1 0.0009s

0020: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", "SiteTree_Live"."ShowInSitemap", "SiteTree_Live"."AvailableOffline", CASE WHEN "SiteTree_Localised_lv_LV"."ID" IS NOT NULL THEN "SiteTree_Localised_lv_LV"."ExtraCode" WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."ExtraCode" ELSE "SiteTree_Live"."ExtraCode" END AS "ExtraCode", "SiteTree_Live"."CanViewType", "SiteTree_Live"."CanEditType", "SiteTree_Live"."Version", CASE WHEN "SiteTree_Localised_lv_LV"."ID" IS NOT NULL THEN "SiteTree_Localised_lv_LV"."URLSegment" 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_lv_LV"."ID" IS NOT NULL THEN "SiteTree_Localised_lv_LV"."Title" 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_lv_LV"."ID" IS NOT NULL THEN "SiteTree_Localised_lv_LV"."MenuTitle" 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_lv_LV"."ID" IS NOT NULL THEN "SiteTree_Localised_lv_LV"."Content" 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_lv_LV"."ID" IS NOT NULL THEN "SiteTree_Localised_lv_LV"."MetaDescription" 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_lv_LV"."ID" IS NOT NULL THEN "SiteTree_Localised_lv_LV"."ReportClass" WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."ReportClass" ELSE "SiteTree_Live"."ReportClass" END AS "ReportClass", "SiteTree_Live"."ParentID", "SiteTree_Live"."ID", CASE WHEN "SiteTree_Live"."ClassName" IS NOT NULL THEN "SiteTree_Live"."ClassName" ELSE 'SilverStripe\\CMS\\Model\\SiteTree' END AS "RecordClassName", 'lv_LV' AS "Locale", CASE WHEN "SiteTree_Localised_lv_LV"."ID" IS NOT NULL THEN 'lv_LV' 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_lv_LV" ON "SiteTree_Live"."ID" = "SiteTree_Localised_lv_LV"."RecordID" AND "SiteTree_Localised_lv_LV"."Locale" = ? 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_lv_LV"."ID" IS NOT NULL)) ORDER BY "SiteTree_Live"."Sort" ASC LIMIT 1 0.0008s

0021: SELECT "ID" FROM "SiteTree_Localised_Live" WHERE ("RecordID" = ?) AND ("Locale" = ?) LIMIT 1 0.0005s

0022: 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.0006s

0023: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", "SiteTree_Live"."ShowInSitemap", "SiteTree_Live"."AvailableOffline", CASE WHEN "SiteTree_Localised_ru_RU"."ID" IS NOT NULL THEN "SiteTree_Localised_ru_RU"."ExtraCode" ELSE "SiteTree_Live"."ExtraCode" END AS "ExtraCode", "SiteTree_Live"."CanViewType", "SiteTree_Live"."CanEditType", "SiteTree_Live"."Version", CASE WHEN "SiteTree_Localised_ru_RU"."ID" IS NOT NULL THEN "SiteTree_Localised_ru_RU"."URLSegment" ELSE "SiteTree_Live"."URLSegment" END AS "URLSegment", CASE WHEN "SiteTree_Localised_ru_RU"."ID" IS NOT NULL THEN "SiteTree_Localised_ru_RU"."Title" ELSE "SiteTree_Live"."Title" END AS "Title", CASE WHEN "SiteTree_Localised_ru_RU"."ID" IS NOT NULL THEN "SiteTree_Localised_ru_RU"."MenuTitle" ELSE "SiteTree_Live"."MenuTitle" END AS "MenuTitle", CASE WHEN "SiteTree_Localised_ru_RU"."ID" IS NOT NULL THEN "SiteTree_Localised_ru_RU"."Content" ELSE "SiteTree_Live"."Content" END AS "Content", CASE WHEN "SiteTree_Localised_ru_RU"."ID" IS NOT NULL THEN "SiteTree_Localised_ru_RU"."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_ru_RU"."ID" IS NOT NULL THEN "SiteTree_Localised_ru_RU"."ReportClass" ELSE "SiteTree_Live"."ReportClass" END AS "ReportClass", "SiteTree_Live"."ParentID", "Page_Live"."InheritSideBar", "Page_Live"."BlockIcon", "Page_Live"."SideBarID", "Page_Live"."ElementalAreaID", "SiteTree_Live"."ID", CASE WHEN "SiteTree_Live"."ClassName" IS NOT NULL THEN "SiteTree_Live"."ClassName" ELSE 'SilverStripe\\CMS\\Model\\SiteTree' END AS "RecordClassName", 'ru_RU' AS "Locale", CASE WHEN "SiteTree_Localised_ru_RU"."ID" IS NOT NULL THEN 'ru_RU' ELSE NULL END AS "SourceLocale" FROM "SiteTree_Live" LEFT JOIN "Page_Live" ON "Page_Live"."ID" = "SiteTree_Live"."ID" LEFT JOIN "SiteTree_Localised_Live" AS "SiteTree_Localised_ru_RU" ON "SiteTree_Live"."ID" = "SiteTree_Localised_ru_RU"."RecordID" AND "SiteTree_Localised_ru_RU"."Locale" = ? WHERE ("SiteTree_Live"."ID" = ?) AND ("SiteTree_Live"."ClassName" IN (?)) AND (("SiteTree_Localised_ru_RU"."ID" IS NOT NULL)) ORDER BY "SiteTree_Live"."Sort" ASC LIMIT 1 0.0007s

0024: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", "SiteTree_Live"."ShowInSitemap", "SiteTree_Live"."AvailableOffline", CASE WHEN "SiteTree_Localised_ru_RU"."ID" IS NOT NULL THEN "SiteTree_Localised_ru_RU"."ExtraCode" ELSE "SiteTree_Live"."ExtraCode" END AS "ExtraCode", "SiteTree_Live"."CanViewType", "SiteTree_Live"."CanEditType", "SiteTree_Live"."Version", CASE WHEN "SiteTree_Localised_ru_RU"."ID" IS NOT NULL THEN "SiteTree_Localised_ru_RU"."URLSegment" ELSE "SiteTree_Live"."URLSegment" END AS "URLSegment", CASE WHEN "SiteTree_Localised_ru_RU"."ID" IS NOT NULL THEN "SiteTree_Localised_ru_RU"."Title" ELSE "SiteTree_Live"."Title" END AS "Title", CASE WHEN "SiteTree_Localised_ru_RU"."ID" IS NOT NULL THEN "SiteTree_Localised_ru_RU"."MenuTitle" ELSE "SiteTree_Live"."MenuTitle" END AS "MenuTitle", CASE WHEN "SiteTree_Localised_ru_RU"."ID" IS NOT NULL THEN "SiteTree_Localised_ru_RU"."Content" ELSE "SiteTree_Live"."Content" END AS "Content", CASE WHEN "SiteTree_Localised_ru_RU"."ID" IS NOT NULL THEN "SiteTree_Localised_ru_RU"."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_ru_RU"."ID" IS NOT NULL THEN "SiteTree_Localised_ru_RU"."ReportClass" ELSE "SiteTree_Live"."ReportClass" END AS "ReportClass", "SiteTree_Live"."ParentID", "SiteTree_Live"."ID", CASE WHEN "SiteTree_Live"."ClassName" IS NOT NULL THEN "SiteTree_Live"."ClassName" ELSE 'SilverStripe\\CMS\\Model\\SiteTree' END AS "RecordClassName", 'ru_RU' AS "Locale", CASE WHEN "SiteTree_Localised_ru_RU"."ID" IS NOT NULL THEN 'ru_RU' ELSE NULL END AS "SourceLocale" FROM "SiteTree_Live" LEFT JOIN "SiteTree_Localised_Live" AS "SiteTree_Localised_ru_RU" ON "SiteTree_Live"."ID" = "SiteTree_Localised_ru_RU"."RecordID" AND "SiteTree_Localised_ru_RU"."Locale" = ? WHERE ("SiteTree_Live"."ID" = ?) AND (("SiteTree_Localised_ru_RU"."ID" IS NOT NULL)) ORDER BY "SiteTree_Live"."Sort" ASC LIMIT 1 0.0006s

0025: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "Page_Live"."InheritSideBar", "Page_Live"."BlockIcon", "Page_Live"."SideBarID", "Page_Live"."ElementalAreaID", "SiteTree_Live"."ID", CASE WHEN "SiteTree_Live"."ClassName" IS NOT NULL THEN "SiteTree_Live"."ClassName" ELSE 'SilverStripe\\CMS\\Model\\SiteTree' END AS "RecordClassName", 'lv_LV' AS "Locale", CASE WHEN "SiteTree_Localised_lv_LV"."ID" IS NOT NULL THEN 'lv_LV' WHEN "SiteTree_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_lv_LV" ON "SiteTree_Live"."ID" = "SiteTree_Localised_lv_LV"."RecordID" AND "SiteTree_Localised_lv_LV"."Locale" = ? 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_Live"."ClassName" IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)) AND (("SiteTree_Localised_lv_LV"."ID" IS NOT NULL)) ORDER BY "SiteTree_Live"."Sort" ASC LIMIT 1 0.0007s

0026: SELECT DISTINCT "ElementalArea_Live"."ClassName", "ElementalArea_Live"."LastEdited", "ElementalArea_Live"."Created", "ElementalArea_Live"."TopPageLocale", "ElementalArea_Live"."Version", "ElementalArea_Live"."OwnerClassName", "ElementalArea_Live"."TopPageID", "ElementalArea_Live"."ID", CASE WHEN "ElementalArea_Live"."ClassName" IS NOT NULL THEN "ElementalArea_Live"."ClassName" ELSE 'DNADesign\\Elemental\\Models\\ElementalArea' END AS "RecordClassName" FROM "ElementalArea_Live" WHERE ("ElementalArea_Live"."ID" = ?) LIMIT 1 0.0005s

0027: SELECT DISTINCT "Element_Live"."ClassName", "Element_Live"."LastEdited", "Element_Live"."Created", "Element_Live"."ContainerType", "Element_Live"."Size", "Element_Live"."AvailableGlobally", "Element_Live"."Version", CASE WHEN "Element_Localised_lv_LV"."ID" IS NOT NULL THEN "Element_Localised_lv_LV"."Title" WHEN "Element_Localised_en_US"."ID" IS NOT NULL THEN "Element_Localised_en_US"."Title" ELSE "Element_Live"."Title" END AS "Title", "Element_Live"."ShowTitle", "Element_Live"."Sort", "Element_Live"."ExtraClass", "Element_Live"."Style", "Element_Live"."ParentID", CASE WHEN "ElementContent_Localised_lv_LV"."ID" IS NOT NULL THEN "ElementContent_Localised_lv_LV"."HTML" WHEN "ElementContent_Localised_en_US"."ID" IS NOT NULL THEN "ElementContent_Localised_en_US"."HTML" ELSE "ElementContent_Live"."HTML" END AS "HTML", "Element_Live"."ID", CASE WHEN "Element_Live"."ClassName" IS NOT NULL THEN "Element_Live"."ClassName" ELSE 'DNADesign\\Elemental\\Models\\BaseElement' END AS "RecordClassName", 'lv_LV' AS "Locale", CASE WHEN "ElementContent_Localised_lv_LV"."ID" IS NOT NULL THEN 'lv_LV' WHEN "ElementContent_Localised_en_US"."ID" IS NOT NULL THEN 'en_US' ELSE NULL END AS "SourceLocale" FROM "Element_Live" LEFT JOIN "ElementContent_Live" ON "ElementContent_Live"."ID" = "Element_Live"."ID" LEFT JOIN "Element_Localised_Live" AS "Element_Localised_lv_LV" ON "Element_Live"."ID" = "Element_Localised_lv_LV"."RecordID" AND "Element_Localised_lv_LV"."Locale" = ? LEFT JOIN "Element_Localised_Live" AS "Element_Localised_en_US" ON "Element_Live"."ID" = "Element_Localised_en_US"."RecordID" AND "Element_Localised_en_US"."Locale" = ? LEFT JOIN "ElementContent_Localised_Live" AS "ElementContent_Localised_lv_LV" ON "ElementContent_Live"."ID" = "ElementContent_Localised_lv_LV"."RecordID" AND "ElementContent_Localised_lv_LV"."Locale" = ? LEFT JOIN "ElementContent_Localised_Live" AS "ElementContent_Localised_en_US" ON "ElementContent_Live"."ID" = "ElementContent_Localised_en_US"."RecordID" AND "ElementContent_Localised_en_US"."Locale" = ? WHERE ("Element_Live"."ParentID" = ?) AND (COALESCE("ElementContent_Localised_lv_LV"."HTML", "ElementContent_Localised_en_US"."HTML", "ElementContent_Live"."HTML") IS NOT NULL) AND ("Element_Live"."ClassName" IN (?, ?, ?)) AND (("Element_Localised_lv_LV"."ID" IS NOT NULL)) ORDER BY "Element_Live"."Sort" ASC LIMIT 1 0.0015s

0028: 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.0006s

0029: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", "SiteTree_Live"."ShowInSitemap", "SiteTree_Live"."AvailableOffline", CASE WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."ExtraCode" ELSE "SiteTree_Live"."ExtraCode" END AS "ExtraCode", "SiteTree_Live"."CanViewType", "SiteTree_Live"."CanEditType", "SiteTree_Live"."Version", CASE WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."URLSegment" ELSE "SiteTree_Live"."URLSegment" END AS "URLSegment", CASE WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."Title" ELSE "SiteTree_Live"."Title" END AS "Title", CASE WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."MenuTitle" ELSE "SiteTree_Live"."MenuTitle" END AS "MenuTitle", CASE WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."Content" ELSE "SiteTree_Live"."Content" END AS "Content", CASE WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."MetaDescription" ELSE "SiteTree_Live"."MetaDescription" END AS "MetaDescription", "SiteTree_Live"."ExtraMeta", "SiteTree_Live"."ShowInMenus", "SiteTree_Live"."ShowInSearch", "SiteTree_Live"."Sort", "SiteTree_Live"."HasBrokenFile", "SiteTree_Live"."HasBrokenLink", CASE WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."ReportClass" ELSE "SiteTree_Live"."ReportClass" END AS "ReportClass", "SiteTree_Live"."ParentID", "Page_Live"."InheritSideBar", "Page_Live"."BlockIcon", "Page_Live"."SideBarID", "Page_Live"."ElementalAreaID", "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 "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" = ? 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.0007s

0030: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", "SiteTree_Live"."ShowInSitemap", "SiteTree_Live"."AvailableOffline", CASE WHEN "SiteTree_Localised_lv_LV"."ID" IS NOT NULL THEN "SiteTree_Localised_lv_LV"."ExtraCode" WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."ExtraCode" ELSE "SiteTree_Live"."ExtraCode" END AS "ExtraCode", "SiteTree_Live"."CanViewType", "SiteTree_Live"."CanEditType", "SiteTree_Live"."Version", CASE WHEN "SiteTree_Localised_lv_LV"."ID" IS NOT NULL THEN "SiteTree_Localised_lv_LV"."URLSegment" 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_lv_LV"."ID" IS NOT NULL THEN "SiteTree_Localised_lv_LV"."Title" 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_lv_LV"."ID" IS NOT NULL THEN "SiteTree_Localised_lv_LV"."MenuTitle" 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_lv_LV"."ID" IS NOT NULL THEN "SiteTree_Localised_lv_LV"."Content" 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_lv_LV"."ID" IS NOT NULL THEN "SiteTree_Localised_lv_LV"."MetaDescription" 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_lv_LV"."ID" IS NOT NULL THEN "SiteTree_Localised_lv_LV"."ReportClass" WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."ReportClass" ELSE "SiteTree_Live"."ReportClass" END AS "ReportClass", "SiteTree_Live"."ParentID", "Page_Live"."InheritSideBar", "Page_Live"."BlockIcon", "Page_Live"."SideBarID", "Page_Live"."ElementalAreaID", "SiteTree_Live"."ID", CASE WHEN "SiteTree_Live"."ClassName" IS NOT NULL THEN "SiteTree_Live"."ClassName" ELSE 'SilverStripe\\CMS\\Model\\SiteTree' END AS "RecordClassName", 'lv_LV' AS "Locale", CASE WHEN "SiteTree_Localised_lv_LV"."ID" IS NOT NULL THEN 'lv_LV' WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN 'en_US' ELSE NULL END AS "SourceLocale" FROM "SiteTree_Live" LEFT JOIN "Page_Live" ON "Page_Live"."ID" = "SiteTree_Live"."ID" LEFT JOIN "SiteTree_Localised_Live" AS "SiteTree_Localised_lv_LV" ON "SiteTree_Live"."ID" = "SiteTree_Localised_lv_LV"."RecordID" AND "SiteTree_Localised_lv_LV"."Locale" = ? 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_Live"."ClassName" IN (?)) AND (("SiteTree_Localised_lv_LV"."ID" IS NOT NULL)) ORDER BY "SiteTree_Live"."Sort" ASC LIMIT 1 0.0009s

0031: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", "SiteTree_Live"."ShowInSitemap", "SiteTree_Live"."AvailableOffline", CASE WHEN "SiteTree_Localised_lv_LV"."ID" IS NOT NULL THEN "SiteTree_Localised_lv_LV"."ExtraCode" WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."ExtraCode" ELSE "SiteTree_Live"."ExtraCode" END AS "ExtraCode", "SiteTree_Live"."CanViewType", "SiteTree_Live"."CanEditType", "SiteTree_Live"."Version", CASE WHEN "SiteTree_Localised_lv_LV"."ID" IS NOT NULL THEN "SiteTree_Localised_lv_LV"."URLSegment" 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_lv_LV"."ID" IS NOT NULL THEN "SiteTree_Localised_lv_LV"."Title" 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_lv_LV"."ID" IS NOT NULL THEN "SiteTree_Localised_lv_LV"."MenuTitle" 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_lv_LV"."ID" IS NOT NULL THEN "SiteTree_Localised_lv_LV"."Content" 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_lv_LV"."ID" IS NOT NULL THEN "SiteTree_Localised_lv_LV"."MetaDescription" 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_lv_LV"."ID" IS NOT NULL THEN "SiteTree_Localised_lv_LV"."ReportClass" WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."ReportClass" ELSE "SiteTree_Live"."ReportClass" END AS "ReportClass", "SiteTree_Live"."ParentID", "SiteTree_Live"."ID", CASE WHEN "SiteTree_Live"."ClassName" IS NOT NULL THEN "SiteTree_Live"."ClassName" ELSE 'SilverStripe\\CMS\\Model\\SiteTree' END AS "RecordClassName", 'lv_LV' AS "Locale", CASE WHEN "SiteTree_Localised_lv_LV"."ID" IS NOT NULL THEN 'lv_LV' 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_lv_LV" ON "SiteTree_Live"."ID" = "SiteTree_Localised_lv_LV"."RecordID" AND "SiteTree_Localised_lv_LV"."Locale" = ? 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_lv_LV"."ID" IS NOT NULL)) ORDER BY "SiteTree_Live"."Sort" ASC LIMIT 1 0.0008s

0032: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", "SiteTree_Live"."ShowInSitemap", "SiteTree_Live"."AvailableOffline", CASE WHEN "SiteTree_Localised_ru_RU"."ID" IS NOT NULL THEN "SiteTree_Localised_ru_RU"."ExtraCode" ELSE "SiteTree_Live"."ExtraCode" END AS "ExtraCode", "SiteTree_Live"."CanViewType", "SiteTree_Live"."CanEditType", "SiteTree_Live"."Version", CASE WHEN "SiteTree_Localised_ru_RU"."ID" IS NOT NULL THEN "SiteTree_Localised_ru_RU"."URLSegment" ELSE "SiteTree_Live"."URLSegment" END AS "URLSegment", CASE WHEN "SiteTree_Localised_ru_RU"."ID" IS NOT NULL THEN "SiteTree_Localised_ru_RU"."Title" ELSE "SiteTree_Live"."Title" END AS "Title", CASE WHEN "SiteTree_Localised_ru_RU"."ID" IS NOT NULL THEN "SiteTree_Localised_ru_RU"."MenuTitle" ELSE "SiteTree_Live"."MenuTitle" END AS "MenuTitle", CASE WHEN "SiteTree_Localised_ru_RU"."ID" IS NOT NULL THEN "SiteTree_Localised_ru_RU"."Content" ELSE "SiteTree_Live"."Content" END AS "Content", CASE WHEN "SiteTree_Localised_ru_RU"."ID" IS NOT NULL THEN "SiteTree_Localised_ru_RU"."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_ru_RU"."ID" IS NOT NULL THEN "SiteTree_Localised_ru_RU"."ReportClass" ELSE "SiteTree_Live"."ReportClass" END AS "ReportClass", "SiteTree_Live"."ParentID", "Page_Live"."InheritSideBar", "Page_Live"."BlockIcon", "Page_Live"."SideBarID", "Page_Live"."ElementalAreaID", "SiteTree_Live"."ID", CASE WHEN "SiteTree_Live"."ClassName" IS NOT NULL THEN "SiteTree_Live"."ClassName" ELSE 'SilverStripe\\CMS\\Model\\SiteTree' END AS "RecordClassName", 'ru_RU' AS "Locale", CASE WHEN "SiteTree_Localised_ru_RU"."ID" IS NOT NULL THEN 'ru_RU' ELSE NULL END AS "SourceLocale" FROM "SiteTree_Live" LEFT JOIN "Page_Live" ON "Page_Live"."ID" = "SiteTree_Live"."ID" LEFT JOIN "SiteTree_Localised_Live" AS "SiteTree_Localised_ru_RU" ON "SiteTree_Live"."ID" = "SiteTree_Localised_ru_RU"."RecordID" AND "SiteTree_Localised_ru_RU"."Locale" = ? WHERE ("SiteTree_Live"."ID" = ?) AND ("SiteTree_Live"."ClassName" IN (?)) AND (("SiteTree_Localised_ru_RU"."ID" IS NOT NULL)) ORDER BY "SiteTree_Live"."Sort" ASC LIMIT 1 0.0007s

0033: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", "SiteTree_Live"."ShowInSitemap", "SiteTree_Live"."AvailableOffline", CASE WHEN "SiteTree_Localised_ru_RU"."ID" IS NOT NULL THEN "SiteTree_Localised_ru_RU"."ExtraCode" ELSE "SiteTree_Live"."ExtraCode" END AS "ExtraCode", "SiteTree_Live"."CanViewType", "SiteTree_Live"."CanEditType", "SiteTree_Live"."Version", CASE WHEN "SiteTree_Localised_ru_RU"."ID" IS NOT NULL THEN "SiteTree_Localised_ru_RU"."URLSegment" ELSE "SiteTree_Live"."URLSegment" END AS "URLSegment", CASE WHEN "SiteTree_Localised_ru_RU"."ID" IS NOT NULL THEN "SiteTree_Localised_ru_RU"."Title" ELSE "SiteTree_Live"."Title" END AS "Title", CASE WHEN "SiteTree_Localised_ru_RU"."ID" IS NOT NULL THEN "SiteTree_Localised_ru_RU"."MenuTitle" ELSE "SiteTree_Live"."MenuTitle" END AS "MenuTitle", CASE WHEN "SiteTree_Localised_ru_RU"."ID" IS NOT NULL THEN "SiteTree_Localised_ru_RU"."Content" ELSE "SiteTree_Live"."Content" END AS "Content", CASE WHEN "SiteTree_Localised_ru_RU"."ID" IS NOT NULL THEN "SiteTree_Localised_ru_RU"."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_ru_RU"."ID" IS NOT NULL THEN "SiteTree_Localised_ru_RU"."ReportClass" ELSE "SiteTree_Live"."ReportClass" END AS "ReportClass", "SiteTree_Live"."ParentID", "SiteTree_Live"."ID", CASE WHEN "SiteTree_Live"."ClassName" IS NOT NULL THEN "SiteTree_Live"."ClassName" ELSE 'SilverStripe\\CMS\\Model\\SiteTree' END AS "RecordClassName", 'ru_RU' AS "Locale", CASE WHEN "SiteTree_Localised_ru_RU"."ID" IS NOT NULL THEN 'ru_RU' ELSE NULL END AS "SourceLocale" FROM "SiteTree_Live" LEFT JOIN "SiteTree_Localised_Live" AS "SiteTree_Localised_ru_RU" ON "SiteTree_Live"."ID" = "SiteTree_Localised_ru_RU"."RecordID" AND "SiteTree_Localised_ru_RU"."Locale" = ? WHERE ("SiteTree_Live"."ID" = ?) AND (("SiteTree_Localised_ru_RU"."ID" IS NOT NULL)) ORDER BY "SiteTree_Live"."Sort" ASC LIMIT 1 0.0007s

0034: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", "SiteTree_Live"."ShowInSitemap", "SiteTree_Live"."AvailableOffline", CASE WHEN "SiteTree_Localised_lv_LV"."ID" IS NOT NULL THEN "SiteTree_Localised_lv_LV"."ExtraCode" WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."ExtraCode" ELSE "SiteTree_Live"."ExtraCode" END AS "ExtraCode", "SiteTree_Live"."CanViewType", "SiteTree_Live"."CanEditType", "SiteTree_Live"."Version", CASE WHEN "SiteTree_Localised_lv_LV"."ID" IS NOT NULL THEN "SiteTree_Localised_lv_LV"."URLSegment" 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_lv_LV"."ID" IS NOT NULL THEN "SiteTree_Localised_lv_LV"."Title" 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_lv_LV"."ID" IS NOT NULL THEN "SiteTree_Localised_lv_LV"."MenuTitle" 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_lv_LV"."ID" IS NOT NULL THEN "SiteTree_Localised_lv_LV"."Content" 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_lv_LV"."ID" IS NOT NULL THEN "SiteTree_Localised_lv_LV"."MetaDescription" 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_lv_LV"."ID" IS NOT NULL THEN "SiteTree_Localised_lv_LV"."ReportClass" WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."ReportClass" ELSE "SiteTree_Live"."ReportClass" END AS "ReportClass", "SiteTree_Live"."ParentID", "SiteTree_Live"."ID", CASE WHEN "SiteTree_Live"."ClassName" IS NOT NULL THEN "SiteTree_Live"."ClassName" ELSE 'SilverStripe\\CMS\\Model\\SiteTree' END AS "RecordClassName", 'lv_LV' AS "Locale", CASE WHEN "SiteTree_Localised_lv_LV"."ID" IS NOT NULL THEN 'lv_LV' 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_lv_LV" ON "SiteTree_Live"."ID" = "SiteTree_Localised_lv_LV"."RecordID" AND "SiteTree_Localised_lv_LV"."Locale" = ? LEFT JOIN "SiteTree_Localised_Live" AS "SiteTree_Localised_en_US" ON "SiteTree_Live"."ID" = "SiteTree_Localised_en_US"."RecordID" AND "SiteTree_Localised_en_US"."Locale" = ? WHERE ("SiteTree_Live"."ShowInMenus" = ?) AND ("SiteTree_Live"."ParentID" = ?) AND (("SiteTree_Localised_lv_LV"."ID" IS NOT NULL)) ORDER BY "SiteTree_Live"."Sort" ASC 0.0018s

0035: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", "SiteTree_Live"."ShowInSitemap", "SiteTree_Live"."AvailableOffline", CASE WHEN "SiteTree_Localised_lv_LV"."ID" IS NOT NULL THEN "SiteTree_Localised_lv_LV"."ExtraCode" WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."ExtraCode" ELSE "SiteTree_Live"."ExtraCode" END AS "ExtraCode", "SiteTree_Live"."CanViewType", "SiteTree_Live"."CanEditType", "SiteTree_Live"."Version", CASE WHEN "SiteTree_Localised_lv_LV"."ID" IS NOT NULL THEN "SiteTree_Localised_lv_LV"."URLSegment" 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_lv_LV"."ID" IS NOT NULL THEN "SiteTree_Localised_lv_LV"."Title" 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_lv_LV"."ID" IS NOT NULL THEN "SiteTree_Localised_lv_LV"."MenuTitle" 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_lv_LV"."ID" IS NOT NULL THEN "SiteTree_Localised_lv_LV"."Content" 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_lv_LV"."ID" IS NOT NULL THEN "SiteTree_Localised_lv_LV"."MetaDescription" 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_lv_LV"."ID" IS NOT NULL THEN "SiteTree_Localised_lv_LV"."ReportClass" WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."ReportClass" ELSE "SiteTree_Live"."ReportClass" END AS "ReportClass", "SiteTree_Live"."ParentID", "SiteTree_Live"."ID", CASE WHEN "SiteTree_Live"."ClassName" IS NOT NULL THEN "SiteTree_Live"."ClassName" ELSE 'SilverStripe\\CMS\\Model\\SiteTree' END AS "RecordClassName", 'lv_LV' AS "Locale", CASE WHEN "SiteTree_Localised_lv_LV"."ID" IS NOT NULL THEN 'lv_LV' 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_lv_LV" ON "SiteTree_Live"."ID" = "SiteTree_Localised_lv_LV"."RecordID" AND "SiteTree_Localised_lv_LV"."Locale" = ? 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_lv_LV"."ID" IS NOT NULL)) ORDER BY "SiteTree_Live"."Sort" ASC LIMIT 1 0.0007s

0036: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "Page_Live"."InheritSideBar", "Page_Live"."BlockIcon", "Page_Live"."SideBarID", "Page_Live"."ElementalAreaID", "SiteTree_Live"."ID", CASE WHEN "SiteTree_Live"."ClassName" IS NOT NULL THEN "SiteTree_Live"."ClassName" ELSE 'SilverStripe\\CMS\\Model\\SiteTree' END AS "RecordClassName", 'lv_LV' AS "Locale", CASE WHEN "SiteTree_Localised_lv_LV"."ID" IS NOT NULL THEN 'lv_LV' WHEN "SiteTree_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_lv_LV" ON "SiteTree_Live"."ID" = "SiteTree_Localised_lv_LV"."RecordID" AND "SiteTree_Localised_lv_LV"."Locale" = ? 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_Live"."ClassName" IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)) AND (("SiteTree_Localised_lv_LV"."ID" IS NOT NULL)) ORDER BY "SiteTree_Live"."Sort" ASC LIMIT 1 0.0007s

0037: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "Page_Live"."InheritSideBar", "Page_Live"."BlockIcon", "Page_Live"."SideBarID", "Page_Live"."ElementalAreaID", "SiteTree_Live"."ID", CASE WHEN "SiteTree_Live"."ClassName" IS NOT NULL THEN "SiteTree_Live"."ClassName" ELSE 'SilverStripe\\CMS\\Model\\SiteTree' END AS "RecordClassName", 'lv_LV' AS "Locale", CASE WHEN "SiteTree_Localised_lv_LV"."ID" IS NOT NULL THEN 'lv_LV' WHEN "SiteTree_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_lv_LV" ON "SiteTree_Live"."ID" = "SiteTree_Localised_lv_LV"."RecordID" AND "SiteTree_Localised_lv_LV"."Locale" = ? 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_Live"."ClassName" IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)) AND (("SiteTree_Localised_lv_LV"."ID" IS NOT NULL)) ORDER BY "SiteTree_Live"."Sort" ASC LIMIT 1 0.0009s

0038: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "Page_Live"."InheritSideBar", "Page_Live"."BlockIcon", "Page_Live"."SideBarID", "Page_Live"."ElementalAreaID", "SiteTree_Live"."ID", CASE WHEN "SiteTree_Live"."ClassName" IS NOT NULL THEN "SiteTree_Live"."ClassName" ELSE 'SilverStripe\\CMS\\Model\\SiteTree' END AS "RecordClassName", 'lv_LV' AS "Locale", CASE WHEN "SiteTree_Localised_lv_LV"."ID" IS NOT NULL THEN 'lv_LV' WHEN "SiteTree_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_lv_LV" ON "SiteTree_Live"."ID" = "SiteTree_Localised_lv_LV"."RecordID" AND "SiteTree_Localised_lv_LV"."Locale" = ? 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_Live"."ClassName" IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)) AND (("SiteTree_Localised_lv_LV"."ID" IS NOT NULL)) ORDER BY "SiteTree_Live"."Sort" ASC LIMIT 1 0.0008s

0039: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "Page_Live"."InheritSideBar", "Page_Live"."BlockIcon", "Page_Live"."SideBarID", "Page_Live"."ElementalAreaID", "SiteTree_Live"."ID", CASE WHEN "SiteTree_Live"."ClassName" IS NOT NULL THEN "SiteTree_Live"."ClassName" ELSE 'SilverStripe\\CMS\\Model\\SiteTree' END AS "RecordClassName", 'lv_LV' AS "Locale", CASE WHEN "SiteTree_Localised_lv_LV"."ID" IS NOT NULL THEN 'lv_LV' WHEN "SiteTree_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_lv_LV" ON "SiteTree_Live"."ID" = "SiteTree_Localised_lv_LV"."RecordID" AND "SiteTree_Localised_lv_LV"."Locale" = ? 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_Live"."ClassName" IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)) AND (("SiteTree_Localised_lv_LV"."ID" IS NOT NULL)) ORDER BY "SiteTree_Live"."Sort" ASC LIMIT 1 0.0007s

0040: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "Page_Live"."InheritSideBar", "Page_Live"."BlockIcon", "Page_Live"."SideBarID", "Page_Live"."ElementalAreaID", "SiteTree_Live"."ID", CASE WHEN "SiteTree_Live"."ClassName" IS NOT NULL THEN "SiteTree_Live"."ClassName" ELSE 'SilverStripe\\CMS\\Model\\SiteTree' END AS "RecordClassName", 'lv_LV' AS "Locale", CASE WHEN "SiteTree_Localised_lv_LV"."ID" IS NOT NULL THEN 'lv_LV' WHEN "SiteTree_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_lv_LV" ON "SiteTree_Live"."ID" = "SiteTree_Localised_lv_LV"."RecordID" AND "SiteTree_Localised_lv_LV"."Locale" = ? 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_Live"."ClassName" IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)) AND (("SiteTree_Localised_lv_LV"."ID" IS NOT NULL)) ORDER BY "SiteTree_Live"."Sort" ASC LIMIT 1 0.0006s

0041: SELECT DISTINCT "ElementalArea_Live"."ClassName", "ElementalArea_Live"."LastEdited", "ElementalArea_Live"."Created", "ElementalArea_Live"."TopPageLocale", "ElementalArea_Live"."Version", "ElementalArea_Live"."OwnerClassName", "ElementalArea_Live"."TopPageID", "ElementalArea_Live"."ID", CASE WHEN "ElementalArea_Live"."ClassName" IS NOT NULL THEN "ElementalArea_Live"."ClassName" ELSE 'DNADesign\\Elemental\\Models\\ElementalArea' END AS "RecordClassName" FROM "ElementalArea_Live" WHERE ("ElementalArea_Live"."ID" = ?) LIMIT 1 0.0005s

0042: SELECT DISTINCT count(DISTINCT "Element_Live"."ID") AS "Count" FROM "Element_Live" LEFT JOIN "Element_Localised_Live" AS "Element_Localised_lv_LV" ON "Element_Live"."ID" = "Element_Localised_lv_LV"."RecordID" AND "Element_Localised_lv_LV"."Locale" = ? LEFT JOIN "Element_Localised_Live" AS "Element_Localised_en_US" ON "Element_Live"."ID" = "Element_Localised_en_US"."RecordID" AND "Element_Localised_en_US"."Locale" = ? WHERE ("Element_Live"."ParentID" = ?) AND (("Element_Localised_lv_LV"."ID" IS NOT NULL)) 0.0007s

0043: SELECT CASE WHEN EXISTS(SELECT * FROM "Drawings_Live" WHERE ("Drawings_Live"."Confirmed" = ?) AND ("Drawings_Live"."TypeGroup" = ?) AND ("Drawings_Live"."AuthorAge" > ?) AND ("Drawings_Live"."AuthorAge" < ?) AND (("Drawings_Live"."LockedOutUntil" < ?) OR ("Drawings_Live"."LockedOutUntil" IS NULL))) THEN 1 ELSE 0 END 0.0005s

0044: SELECT DISTINCT "Drawings_Live"."ClassName", "Drawings_Live"."LastEdited", "Drawings_Live"."Created", "Drawings_Live"."Version", "Drawings_Live"."DisableNewVotes", "Drawings_Live"."Title", "Drawings_Live"."Description", "Drawings_Live"."Name", "Drawings_Live"."Position", "Drawings_Live"."Phone", "Drawings_Live"."Email", "Drawings_Live"."AuthorName", "Drawings_Live"."AuthorSurname", "Drawings_Live"."AuthorAge", "Drawings_Live"."AuthorGroup", "Drawings_Live"."AllAuthors", "Drawings_Live"."Confirmed", "Drawings_Live"."NegativeVotesCorrection", "Drawings_Live"."Rotate", "Drawings_Live"."LockedOutUntil", "Drawings_Live"."TypeGroup", "Drawings_Live"."NumberOfVotes", "Drawings_Live"."ImageID", "Drawings_Live"."OwnerID", "Drawings_Live"."GroupID", "Drawings_Live"."ID", CASE WHEN "Drawings_Live"."ClassName" IS NOT NULL THEN "Drawings_Live"."ClassName" ELSE 'App\\Models\\Drawing' END AS "RecordClassName" FROM "Drawings_Live" WHERE ("Drawings_Live"."Confirmed" = ?) AND ("Drawings_Live"."TypeGroup" = ?) AND ("Drawings_Live"."AuthorAge" > ?) AND ("Drawings_Live"."AuthorAge" < ?) AND (("Drawings_Live"."LockedOutUntil" < ?) OR ("Drawings_Live"."LockedOutUntil" IS NULL)) ORDER BY "Drawings_Live"."NumberOfVotes" DESC LIMIT 24 OFFSET 288 0.0034s

0045: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", "SiteTree_Live"."ShowInSitemap", "SiteTree_Live"."AvailableOffline", CASE WHEN "SiteTree_Localised_lv_LV"."ID" IS NOT NULL THEN "SiteTree_Localised_lv_LV"."ExtraCode" WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."ExtraCode" ELSE "SiteTree_Live"."ExtraCode" END AS "ExtraCode", "SiteTree_Live"."CanViewType", "SiteTree_Live"."CanEditType", "SiteTree_Live"."Version", CASE WHEN "SiteTree_Localised_lv_LV"."ID" IS NOT NULL THEN "SiteTree_Localised_lv_LV"."URLSegment" 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_lv_LV"."ID" IS NOT NULL THEN "SiteTree_Localised_lv_LV"."Title" 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_lv_LV"."ID" IS NOT NULL THEN "SiteTree_Localised_lv_LV"."MenuTitle" 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_lv_LV"."ID" IS NOT NULL THEN "SiteTree_Localised_lv_LV"."Content" 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_lv_LV"."ID" IS NOT NULL THEN "SiteTree_Localised_lv_LV"."MetaDescription" 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_lv_LV"."ID" IS NOT NULL THEN "SiteTree_Localised_lv_LV"."ReportClass" WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."ReportClass" ELSE "SiteTree_Live"."ReportClass" END AS "ReportClass", "SiteTree_Live"."ParentID", "Page_Live"."InheritSideBar", "Page_Live"."BlockIcon", "Page_Live"."SideBarID", "Page_Live"."ElementalAreaID", "SiteTree_Live"."ID", CASE WHEN "SiteTree_Live"."ClassName" IS NOT NULL THEN "SiteTree_Live"."ClassName" ELSE 'SilverStripe\\CMS\\Model\\SiteTree' END AS "RecordClassName", 'lv_LV' AS "Locale", CASE WHEN "SiteTree_Localised_lv_LV"."ID" IS NOT NULL THEN 'lv_LV' WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN 'en_US' ELSE NULL END AS "SourceLocale" FROM "SiteTree_Live" LEFT JOIN "Page_Live" ON "Page_Live"."ID" = "SiteTree_Live"."ID" LEFT JOIN "SiteTree_Localised_Live" AS "SiteTree_Localised_lv_LV" ON "SiteTree_Live"."ID" = "SiteTree_Localised_lv_LV"."RecordID" AND "SiteTree_Localised_lv_LV"."Locale" = ? 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"."ClassName" = ?) AND ("SiteTree_Live"."ClassName" IN (?, ?, ?, ?)) AND (("SiteTree_Localised_lv_LV"."ID" IS NOT NULL)) ORDER BY "SiteTree_Live"."ParentID" ASC, "SiteTree_Live"."Sort" ASC LIMIT 1 0.0022s

0046: SELECT DISTINCT "File_Live"."ClassName", "File_Live"."LastEdited", "File_Live"."Created", "File_Live"."UserFormUpload", "File_Live"."IsTemporary", "File_Live"."Version", "File_Live"."CanViewType", "File_Live"."CanEditType", "File_Live"."Name", "File_Live"."Title", "File_Live"."ShowInSearch", "File_Live"."ParentID", "File_Live"."OwnerID", "File_Live"."FileHash", "File_Live"."FileFilename", "File_Live"."FileVariant", "File_Live"."ObjectID", "File_Live"."ObjectClass", "Image_Live"."FocusPointX", "Image_Live"."FocusPointY", "Image_Live"."FocusPointWidth", "Image_Live"."FocusPointHeight", "File_Live"."ID", CASE WHEN "File_Live"."ClassName" IS NOT NULL THEN "File_Live"."ClassName" ELSE 'SilverStripe\\Assets\\File' END AS "RecordClassName" FROM "File_Live" LEFT JOIN "Image_Live" ON "Image_Live"."ID" = "File_Live"."ID" WHERE ("File_Live"."ID" = ?) AND ("File_Live"."ClassName" IN (?)) ORDER BY "File_Live"."Name" ASC LIMIT 1 0.0009s

0047: SELECT DISTINCT count(DISTINCT "DrawingVotes"."ID") AS "Count" FROM "DrawingVotes" WHERE ("DrawingVotes"."DrawingID" = ?) 0.0006s

0048: SELECT DISTINCT "SchoolGroup"."ClassName", "SchoolGroup"."LastEdited", "SchoolGroup"."Created", "SchoolGroup"."Title", "SchoolGroup"."Comment", "SchoolGroup"."ParentID", "SchoolGroup"."MemberID", "SchoolGroup"."ID", CASE WHEN "SchoolGroup"."ClassName" IS NOT NULL THEN "SchoolGroup"."ClassName" ELSE 'App\\Models\\Group' END AS "RecordClassName" FROM "SchoolGroup" WHERE ("SchoolGroup"."ID" = ?) LIMIT 1 0.0005s

0049: SELECT DISTINCT "School"."ClassName", "School"."LastEdited", "School"."Created", "School"."Address", "School"."Suburb", "School"."State", "School"."Postcode", "School"."Country", "School"."Title", "School"."Location", "School"."Phone", "School"."Email", "School"."ID", CASE WHEN "School"."ClassName" IS NOT NULL THEN "School"."ClassName" ELSE 'App\\Models\\School' END AS "RecordClassName" FROM "School" WHERE ("School"."ID" = ?) LIMIT 1 0.0006s

0050: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", "SiteTree_Live"."ShowInSitemap", "SiteTree_Live"."AvailableOffline", CASE WHEN "SiteTree_Localised_lv_LV"."ID" IS NOT NULL THEN "SiteTree_Localised_lv_LV"."ExtraCode" WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."ExtraCode" ELSE "SiteTree_Live"."ExtraCode" END AS "ExtraCode", "SiteTree_Live"."CanViewType", "SiteTree_Live"."CanEditType", "SiteTree_Live"."Version", CASE WHEN "SiteTree_Localised_lv_LV"."ID" IS NOT NULL THEN "SiteTree_Localised_lv_LV"."URLSegment" 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_lv_LV"."ID" IS NOT NULL THEN "SiteTree_Localised_lv_LV"."Title" 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_lv_LV"."ID" IS NOT NULL THEN "SiteTree_Localised_lv_LV"."MenuTitle" 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_lv_LV"."ID" IS NOT NULL THEN "SiteTree_Localised_lv_LV"."Content" 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_lv_LV"."ID" IS NOT NULL THEN "SiteTree_Localised_lv_LV"."MetaDescription" 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_lv_LV"."ID" IS NOT NULL THEN "SiteTree_Localised_lv_LV"."ReportClass" WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."ReportClass" ELSE "SiteTree_Live"."ReportClass" END AS "ReportClass", "SiteTree_Live"."ParentID", "Page_Live"."InheritSideBar", "Page_Live"."BlockIcon", "Page_Live"."SideBarID", "Page_Live"."ElementalAreaID", "SiteTree_Live"."ID", CASE WHEN "SiteTree_Live"."ClassName" IS NOT NULL THEN "SiteTree_Live"."ClassName" ELSE 'SilverStripe\\CMS\\Model\\SiteTree' END AS "RecordClassName", 'lv_LV' AS "Locale", CASE WHEN "SiteTree_Localised_lv_LV"."ID" IS NOT NULL THEN 'lv_LV' WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN 'en_US' ELSE NULL END AS "SourceLocale" FROM "SiteTree_Live" LEFT JOIN "Page_Live" ON "Page_Live"."ID" = "SiteTree_Live"."ID" LEFT JOIN "SiteTree_Localised_Live" AS "SiteTree_Localised_lv_LV" ON "SiteTree_Live"."ID" = "SiteTree_Localised_lv_LV"."RecordID" AND "SiteTree_Localised_lv_LV"."Locale" = ? 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"."ClassName" = ?) AND ("SiteTree_Live"."ClassName" IN (?, ?, ?, ?)) AND (("SiteTree_Localised_lv_LV"."ID" IS NOT NULL)) ORDER BY "SiteTree_Live"."ParentID" ASC, "SiteTree_Live"."Sort" ASC LIMIT 1 0.0027s

0051: SELECT DISTINCT "File_Live"."ClassName", "File_Live"."LastEdited", "File_Live"."Created", "File_Live"."UserFormUpload", "File_Live"."IsTemporary", "File_Live"."Version", "File_Live"."CanViewType", "File_Live"."CanEditType", "File_Live"."Name", "File_Live"."Title", "File_Live"."ShowInSearch", "File_Live"."ParentID", "File_Live"."OwnerID", "File_Live"."FileHash", "File_Live"."FileFilename", "File_Live"."FileVariant", "File_Live"."ObjectID", "File_Live"."ObjectClass", "Image_Live"."FocusPointX", "Image_Live"."FocusPointY", "Image_Live"."FocusPointWidth", "Image_Live"."FocusPointHeight", "File_Live"."ID", CASE WHEN "File_Live"."ClassName" IS NOT NULL THEN "File_Live"."ClassName" ELSE 'SilverStripe\\Assets\\File' END AS "RecordClassName" FROM "File_Live" LEFT JOIN "Image_Live" ON "Image_Live"."ID" = "File_Live"."ID" WHERE ("File_Live"."ID" = ?) AND ("File_Live"."ClassName" IN (?)) ORDER BY "File_Live"."Name" ASC LIMIT 1 0.0009s

0052: SELECT DISTINCT count(DISTINCT "DrawingVotes"."ID") AS "Count" FROM "DrawingVotes" WHERE ("DrawingVotes"."DrawingID" = ?) 0.0007s

0053: SELECT DISTINCT "SchoolGroup"."ClassName", "SchoolGroup"."LastEdited", "SchoolGroup"."Created", "SchoolGroup"."Title", "SchoolGroup"."Comment", "SchoolGroup"."ParentID", "SchoolGroup"."MemberID", "SchoolGroup"."ID", CASE WHEN "SchoolGroup"."ClassName" IS NOT NULL THEN "SchoolGroup"."ClassName" ELSE 'App\\Models\\Group' END AS "RecordClassName" FROM "SchoolGroup" WHERE ("SchoolGroup"."ID" = ?) LIMIT 1 0.0004s

0054: SELECT DISTINCT "School"."ClassName", "School"."LastEdited", "School"."Created", "School"."Address", "School"."Suburb", "School"."State", "School"."Postcode", "School"."Country", "School"."Title", "School"."Location", "School"."Phone", "School"."Email", "School"."ID", CASE WHEN "School"."ClassName" IS NOT NULL THEN "School"."ClassName" ELSE 'App\\Models\\School' END AS "RecordClassName" FROM "School" WHERE ("School"."ID" = ?) LIMIT 1 0.0005s

0055: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", "SiteTree_Live"."ShowInSitemap", "SiteTree_Live"."AvailableOffline", CASE WHEN "SiteTree_Localised_lv_LV"."ID" IS NOT NULL THEN "SiteTree_Localised_lv_LV"."ExtraCode" WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."ExtraCode" ELSE "SiteTree_Live"."ExtraCode" END AS "ExtraCode", "SiteTree_Live"."CanViewType", "SiteTree_Live"."CanEditType", "SiteTree_Live"."Version", CASE WHEN "SiteTree_Localised_lv_LV"."ID" IS NOT NULL THEN "SiteTree_Localised_lv_LV"."URLSegment" 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_lv_LV"."ID" IS NOT NULL THEN "SiteTree_Localised_lv_LV"."Title" 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_lv_LV"."ID" IS NOT NULL THEN "SiteTree_Localised_lv_LV"."MenuTitle" 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_lv_LV"."ID" IS NOT NULL THEN "SiteTree_Localised_lv_LV"."Content" 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_lv_LV"."ID" IS NOT NULL THEN "SiteTree_Localised_lv_LV"."MetaDescription" 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_lv_LV"."ID" IS NOT NULL THEN "SiteTree_Localised_lv_LV"."ReportClass" WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."ReportClass" ELSE "SiteTree_Live"."ReportClass" END AS "ReportClass", "SiteTree_Live"."ParentID", "Page_Live"."InheritSideBar", "Page_Live"."BlockIcon", "Page_Live"."SideBarID", "Page_Live"."ElementalAreaID", "SiteTree_Live"."ID", CASE WHEN "SiteTree_Live"."ClassName" IS NOT NULL THEN "SiteTree_Live"."ClassName" ELSE 'SilverStripe\\CMS\\Model\\SiteTree' END AS "RecordClassName", 'lv_LV' AS "Locale", CASE WHEN "SiteTree_Localised_lv_LV"."ID" IS NOT NULL THEN 'lv_LV' WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN 'en_US' ELSE NULL END AS "SourceLocale" FROM "SiteTree_Live" LEFT JOIN "Page_Live" ON "Page_Live"."ID" = "SiteTree_Live"."ID" LEFT JOIN "SiteTree_Localised_Live" AS "SiteTree_Localised_lv_LV" ON "SiteTree_Live"."ID" = "SiteTree_Localised_lv_LV"."RecordID" AND "SiteTree_Localised_lv_LV"."Locale" = ? 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"."ClassName" = ?) AND ("SiteTree_Live"."ClassName" IN (?, ?, ?, ?)) AND (("SiteTree_Localised_lv_LV"."ID" IS NOT NULL)) ORDER BY "SiteTree_Live"."ParentID" ASC, "SiteTree_Live"."Sort" ASC LIMIT 1 0.0017s

0056: SELECT DISTINCT "File_Live"."ClassName", "File_Live"."LastEdited", "File_Live"."Created", "File_Live"."UserFormUpload", "File_Live"."IsTemporary", "File_Live"."Version", "File_Live"."CanViewType", "File_Live"."CanEditType", "File_Live"."Name", "File_Live"."Title", "File_Live"."ShowInSearch", "File_Live"."ParentID", "File_Live"."OwnerID", "File_Live"."FileHash", "File_Live"."FileFilename", "File_Live"."FileVariant", "File_Live"."ObjectID", "File_Live"."ObjectClass", "Image_Live"."FocusPointX", "Image_Live"."FocusPointY", "Image_Live"."FocusPointWidth", "Image_Live"."FocusPointHeight", "File_Live"."ID", CASE WHEN "File_Live"."ClassName" IS NOT NULL THEN "File_Live"."ClassName" ELSE 'SilverStripe\\Assets\\File' END AS "RecordClassName" FROM "File_Live" LEFT JOIN "Image_Live" ON "Image_Live"."ID" = "File_Live"."ID" WHERE ("File_Live"."ID" = ?) AND ("File_Live"."ClassName" IN (?)) ORDER BY "File_Live"."Name" ASC LIMIT 1 0.0007s

0057: SELECT DISTINCT count(DISTINCT "DrawingVotes"."ID") AS "Count" FROM "DrawingVotes" WHERE ("DrawingVotes"."DrawingID" = ?) 0.0005s

0058: SELECT DISTINCT "SchoolGroup"."ClassName", "SchoolGroup"."LastEdited", "SchoolGroup"."Created", "SchoolGroup"."Title", "SchoolGroup"."Comment", "SchoolGroup"."ParentID", "SchoolGroup"."MemberID", "SchoolGroup"."ID", CASE WHEN "SchoolGroup"."ClassName" IS NOT NULL THEN "SchoolGroup"."ClassName" ELSE 'App\\Models\\Group' END AS "RecordClassName" FROM "SchoolGroup" WHERE ("SchoolGroup"."ID" = ?) LIMIT 1 0.0005s

0059: SELECT DISTINCT "School"."ClassName", "School"."LastEdited", "School"."Created", "School"."Address", "School"."Suburb", "School"."State", "School"."Postcode", "School"."Country", "School"."Title", "School"."Location", "School"."Phone", "School"."Email", "School"."ID", CASE WHEN "School"."ClassName" IS NOT NULL THEN "School"."ClassName" ELSE 'App\\Models\\School' END AS "RecordClassName" FROM "School" WHERE ("School"."ID" = ?) LIMIT 1 0.0005s

0060: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", "SiteTree_Live"."ShowInSitemap", "SiteTree_Live"."AvailableOffline", CASE WHEN "SiteTree_Localised_lv_LV"."ID" IS NOT NULL THEN "SiteTree_Localised_lv_LV"."ExtraCode" WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."ExtraCode" ELSE "SiteTree_Live"."ExtraCode" END AS "ExtraCode", "SiteTree_Live"."CanViewType", "SiteTree_Live"."CanEditType", "SiteTree_Live"."Version", CASE WHEN "SiteTree_Localised_lv_LV"."ID" IS NOT NULL THEN "SiteTree_Localised_lv_LV"."URLSegment" 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_lv_LV"."ID" IS NOT NULL THEN "SiteTree_Localised_lv_LV"."Title" 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_lv_LV"."ID" IS NOT NULL THEN "SiteTree_Localised_lv_LV"."MenuTitle" 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_lv_LV"."ID" IS NOT NULL THEN "SiteTree_Localised_lv_LV"."Content" 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_lv_LV"."ID" IS NOT NULL THEN "SiteTree_Localised_lv_LV"."MetaDescription" 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_lv_LV"."ID" IS NOT NULL THEN "SiteTree_Localised_lv_LV"."ReportClass" WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."ReportClass" ELSE "SiteTree_Live"."ReportClass" END AS "ReportClass", "SiteTree_Live"."ParentID", "Page_Live"."InheritSideBar", "Page_Live"."BlockIcon", "Page_Live"."SideBarID", "Page_Live"."ElementalAreaID", "SiteTree_Live"."ID", CASE WHEN "SiteTree_Live"."ClassName" IS NOT NULL THEN "SiteTree_Live"."ClassName" ELSE 'SilverStripe\\CMS\\Model\\SiteTree' END AS "RecordClassName", 'lv_LV' AS "Locale", CASE WHEN "SiteTree_Localised_lv_LV"."ID" IS NOT NULL THEN 'lv_LV' WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN 'en_US' ELSE NULL END AS "SourceLocale" FROM "SiteTree_Live" LEFT JOIN "Page_Live" ON "Page_Live"."ID" = "SiteTree_Live"."ID" LEFT JOIN "SiteTree_Localised_Live" AS "SiteTree_Localised_lv_LV" ON "SiteTree_Live"."ID" = "SiteTree_Localised_lv_LV"."RecordID" AND "SiteTree_Localised_lv_LV"."Locale" = ? 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"."ClassName" = ?) AND ("SiteTree_Live"."ClassName" IN (?, ?, ?, ?)) AND (("SiteTree_Localised_lv_LV"."ID" IS NOT NULL)) ORDER BY "SiteTree_Live"."ParentID" ASC, "SiteTree_Live"."Sort" ASC LIMIT 1 0.0016s

0061: SELECT DISTINCT "File_Live"."ClassName", "File_Live"."LastEdited", "File_Live"."Created", "File_Live"."UserFormUpload", "File_Live"."IsTemporary", "File_Live"."Version", "File_Live"."CanViewType", "File_Live"."CanEditType", "File_Live"."Name", "File_Live"."Title", "File_Live"."ShowInSearch", "File_Live"."ParentID", "File_Live"."OwnerID", "File_Live"."FileHash", "File_Live"."FileFilename", "File_Live"."FileVariant", "File_Live"."ObjectID", "File_Live"."ObjectClass", "Image_Live"."FocusPointX", "Image_Live"."FocusPointY", "Image_Live"."FocusPointWidth", "Image_Live"."FocusPointHeight", "File_Live"."ID", CASE WHEN "File_Live"."ClassName" IS NOT NULL THEN "File_Live"."ClassName" ELSE 'SilverStripe\\Assets\\File' END AS "RecordClassName" FROM "File_Live" LEFT JOIN "Image_Live" ON "Image_Live"."ID" = "File_Live"."ID" WHERE ("File_Live"."ID" = ?) AND ("File_Live"."ClassName" IN (?)) ORDER BY "File_Live"."Name" ASC LIMIT 1 0.0007s

0062: SELECT DISTINCT count(DISTINCT "DrawingVotes"."ID") AS "Count" FROM "DrawingVotes" WHERE ("DrawingVotes"."DrawingID" = ?) 0.0006s

0063: SELECT DISTINCT "SchoolGroup"."ClassName", "SchoolGroup"."LastEdited", "SchoolGroup"."Created", "SchoolGroup"."Title", "SchoolGroup"."Comment", "SchoolGroup"."ParentID", "SchoolGroup"."MemberID", "SchoolGroup"."ID", CASE WHEN "SchoolGroup"."ClassName" IS NOT NULL THEN "SchoolGroup"."ClassName" ELSE 'App\\Models\\Group' END AS "RecordClassName" FROM "SchoolGroup" WHERE ("SchoolGroup"."ID" = ?) LIMIT 1 0.0005s

0064: SELECT DISTINCT "School"."ClassName", "School"."LastEdited", "School"."Created", "School"."Address", "School"."Suburb", "School"."State", "School"."Postcode", "School"."Country", "School"."Title", "School"."Location", "School"."Phone", "School"."Email", "School"."ID", CASE WHEN "School"."ClassName" IS NOT NULL THEN "School"."ClassName" ELSE 'App\\Models\\School' END AS "RecordClassName" FROM "School" WHERE ("School"."ID" = ?) LIMIT 1 0.0005s

0065: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", "SiteTree_Live"."ShowInSitemap", "SiteTree_Live"."AvailableOffline", CASE WHEN "SiteTree_Localised_lv_LV"."ID" IS NOT NULL THEN "SiteTree_Localised_lv_LV"."ExtraCode" WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."ExtraCode" ELSE "SiteTree_Live"."ExtraCode" END AS "ExtraCode", "SiteTree_Live"."CanViewType", "SiteTree_Live"."CanEditType", "SiteTree_Live"."Version", CASE WHEN "SiteTree_Localised_lv_LV"."ID" IS NOT NULL THEN "SiteTree_Localised_lv_LV"."URLSegment" 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_lv_LV"."ID" IS NOT NULL THEN "SiteTree_Localised_lv_LV"."Title" 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_lv_LV"."ID" IS NOT NULL THEN "SiteTree_Localised_lv_LV"."MenuTitle" 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_lv_LV"."ID" IS NOT NULL THEN "SiteTree_Localised_lv_LV"."Content" 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_lv_LV"."ID" IS NOT NULL THEN "SiteTree_Localised_lv_LV"."MetaDescription" 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_lv_LV"."ID" IS NOT NULL THEN "SiteTree_Localised_lv_LV"."ReportClass" WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."ReportClass" ELSE "SiteTree_Live"."ReportClass" END AS "ReportClass", "SiteTree_Live"."ParentID", "Page_Live"."InheritSideBar", "Page_Live"."BlockIcon", "Page_Live"."SideBarID", "Page_Live"."ElementalAreaID", "SiteTree_Live"."ID", CASE WHEN "SiteTree_Live"."ClassName" IS NOT NULL THEN "SiteTree_Live"."ClassName" ELSE 'SilverStripe\\CMS\\Model\\SiteTree' END AS "RecordClassName", 'lv_LV' AS "Locale", CASE WHEN "SiteTree_Localised_lv_LV"."ID" IS NOT NULL THEN 'lv_LV' WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN 'en_US' ELSE NULL END AS "SourceLocale" FROM "SiteTree_Live" LEFT JOIN "Page_Live" ON "Page_Live"."ID" = "SiteTree_Live"."ID" LEFT JOIN "SiteTree_Localised_Live" AS "SiteTree_Localised_lv_LV" ON "SiteTree_Live"."ID" = "SiteTree_Localised_lv_LV"."RecordID" AND "SiteTree_Localised_lv_LV"."Locale" = ? 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"."ClassName" = ?) AND ("SiteTree_Live"."ClassName" IN (?, ?, ?, ?)) AND (("SiteTree_Localised_lv_LV"."ID" IS NOT NULL)) ORDER BY "SiteTree_Live"."ParentID" ASC, "SiteTree_Live"."Sort" ASC LIMIT 1 0.0017s

0066: SELECT DISTINCT "File_Live"."ClassName", "File_Live"."LastEdited", "File_Live"."Created", "File_Live"."UserFormUpload", "File_Live"."IsTemporary", "File_Live"."Version", "File_Live"."CanViewType", "File_Live"."CanEditType", "File_Live"."Name", "File_Live"."Title", "File_Live"."ShowInSearch", "File_Live"."ParentID", "File_Live"."OwnerID", "File_Live"."FileHash", "File_Live"."FileFilename", "File_Live"."FileVariant", "File_Live"."ObjectID", "File_Live"."ObjectClass", "Image_Live"."FocusPointX", "Image_Live"."FocusPointY", "Image_Live"."FocusPointWidth", "Image_Live"."FocusPointHeight", "File_Live"."ID", CASE WHEN "File_Live"."ClassName" IS NOT NULL THEN "File_Live"."ClassName" ELSE 'SilverStripe\\Assets\\File' END AS "RecordClassName" FROM "File_Live" LEFT JOIN "Image_Live" ON "Image_Live"."ID" = "File_Live"."ID" WHERE ("File_Live"."ID" = ?) AND ("File_Live"."ClassName" IN (?)) ORDER BY "File_Live"."Name" ASC LIMIT 1 0.0007s

0067: SELECT DISTINCT count(DISTINCT "DrawingVotes"."ID") AS "Count" FROM "DrawingVotes" WHERE ("DrawingVotes"."DrawingID" = ?) 0.0006s

0068: SELECT DISTINCT "DrawingVotes"."ClassName", "DrawingVotes"."LastEdited", "DrawingVotes"."Created", "DrawingVotes"."Grade", "DrawingVotes"."Times", "DrawingVotes"."OwnerID", "DrawingVotes"."DrawingID", "DrawingVotes"."ID", CASE WHEN "DrawingVotes"."ClassName" IS NOT NULL THEN "DrawingVotes"."ClassName" ELSE 'App\\Models\\Vote' END AS "RecordClassName" FROM "DrawingVotes" WHERE ("DrawingVotes"."DrawingID" = ?) ORDER BY "DrawingVotes"."Created" DESC 0.0005s

0069: SELECT DISTINCT "SchoolGroup"."ClassName", "SchoolGroup"."LastEdited", "SchoolGroup"."Created", "SchoolGroup"."Title", "SchoolGroup"."Comment", "SchoolGroup"."ParentID", "SchoolGroup"."MemberID", "SchoolGroup"."ID", CASE WHEN "SchoolGroup"."ClassName" IS NOT NULL THEN "SchoolGroup"."ClassName" ELSE 'App\\Models\\Group' END AS "RecordClassName" FROM "SchoolGroup" WHERE ("SchoolGroup"."ID" = ?) LIMIT 1 0.0004s

0070: SELECT DISTINCT "School"."ClassName", "School"."LastEdited", "School"."Created", "School"."Address", "School"."Suburb", "School"."State", "School"."Postcode", "School"."Country", "School"."Title", "School"."Location", "School"."Phone", "School"."Email", "School"."ID", CASE WHEN "School"."ClassName" IS NOT NULL THEN "School"."ClassName" ELSE 'App\\Models\\School' END AS "RecordClassName" FROM "School" WHERE ("School"."ID" = ?) LIMIT 1 0.0004s

0071: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", "SiteTree_Live"."ShowInSitemap", "SiteTree_Live"."AvailableOffline", CASE WHEN "SiteTree_Localised_lv_LV"."ID" IS NOT NULL THEN "SiteTree_Localised_lv_LV"."ExtraCode" WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."ExtraCode" ELSE "SiteTree_Live"."ExtraCode" END AS "ExtraCode", "SiteTree_Live"."CanViewType", "SiteTree_Live"."CanEditType", "SiteTree_Live"."Version", CASE WHEN "SiteTree_Localised_lv_LV"."ID" IS NOT NULL THEN "SiteTree_Localised_lv_LV"."URLSegment" 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_lv_LV"."ID" IS NOT NULL THEN "SiteTree_Localised_lv_LV"."Title" 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_lv_LV"."ID" IS NOT NULL THEN "SiteTree_Localised_lv_LV"."MenuTitle" 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_lv_LV"."ID" IS NOT NULL THEN "SiteTree_Localised_lv_LV"."Content" 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_lv_LV"."ID" IS NOT NULL THEN "SiteTree_Localised_lv_LV"."MetaDescription" 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_lv_LV"."ID" IS NOT NULL THEN "SiteTree_Localised_lv_LV"."ReportClass" WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."ReportClass" ELSE "SiteTree_Live"."ReportClass" END AS "ReportClass", "SiteTree_Live"."ParentID", "Page_Live"."InheritSideBar", "Page_Live"."BlockIcon", "Page_Live"."SideBarID", "Page_Live"."ElementalAreaID", "SiteTree_Live"."ID", CASE WHEN "SiteTree_Live"."ClassName" IS NOT NULL THEN "SiteTree_Live"."ClassName" ELSE 'SilverStripe\\CMS\\Model\\SiteTree' END AS "RecordClassName", 'lv_LV' AS "Locale", CASE WHEN "SiteTree_Localised_lv_LV"."ID" IS NOT NULL THEN 'lv_LV' WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN 'en_US' ELSE NULL END AS "SourceLocale" FROM "SiteTree_Live" LEFT JOIN "Page_Live" ON "Page_Live"."ID" = "SiteTree_Live"."ID" LEFT JOIN "SiteTree_Localised_Live" AS "SiteTree_Localised_lv_LV" ON "SiteTree_Live"."ID" = "SiteTree_Localised_lv_LV"."RecordID" AND "SiteTree_Localised_lv_LV"."Locale" = ? 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"."ClassName" = ?) AND ("SiteTree_Live"."ClassName" IN (?, ?, ?, ?)) AND (("SiteTree_Localised_lv_LV"."ID" IS NOT NULL)) ORDER BY "SiteTree_Live"."ParentID" ASC, "SiteTree_Live"."Sort" ASC LIMIT 1 0.002s

0072: SELECT DISTINCT "File_Live"."ClassName", "File_Live"."LastEdited", "File_Live"."Created", "File_Live"."UserFormUpload", "File_Live"."IsTemporary", "File_Live"."Version", "File_Live"."CanViewType", "File_Live"."CanEditType", "File_Live"."Name", "File_Live"."Title", "File_Live"."ShowInSearch", "File_Live"."ParentID", "File_Live"."OwnerID", "File_Live"."FileHash", "File_Live"."FileFilename", "File_Live"."FileVariant", "File_Live"."ObjectID", "File_Live"."ObjectClass", "Image_Live"."FocusPointX", "Image_Live"."FocusPointY", "Image_Live"."FocusPointWidth", "Image_Live"."FocusPointHeight", "File_Live"."ID", CASE WHEN "File_Live"."ClassName" IS NOT NULL THEN "File_Live"."ClassName" ELSE 'SilverStripe\\Assets\\File' END AS "RecordClassName" FROM "File_Live" LEFT JOIN "Image_Live" ON "Image_Live"."ID" = "File_Live"."ID" WHERE ("File_Live"."ID" = ?) AND ("File_Live"."ClassName" IN (?)) ORDER BY "File_Live"."Name" ASC LIMIT 1 0.0008s

0073: SELECT DISTINCT count(DISTINCT "DrawingVotes"."ID") AS "Count" FROM "DrawingVotes" WHERE ("DrawingVotes"."DrawingID" = ?) 0.0007s

0074: SELECT DISTINCT "SchoolGroup"."ClassName", "SchoolGroup"."LastEdited", "SchoolGroup"."Created", "SchoolGroup"."Title", "SchoolGroup"."Comment", "SchoolGroup"."ParentID", "SchoolGroup"."MemberID", "SchoolGroup"."ID", CASE WHEN "SchoolGroup"."ClassName" IS NOT NULL THEN "SchoolGroup"."ClassName" ELSE 'App\\Models\\Group' END AS "RecordClassName" FROM "SchoolGroup" WHERE ("SchoolGroup"."ID" = ?) LIMIT 1 0.0007s

0075: SELECT DISTINCT "School"."ClassName", "School"."LastEdited", "School"."Created", "School"."Address", "School"."Suburb", "School"."State", "School"."Postcode", "School"."Country", "School"."Title", "School"."Location", "School"."Phone", "School"."Email", "School"."ID", CASE WHEN "School"."ClassName" IS NOT NULL THEN "School"."ClassName" ELSE 'App\\Models\\School' END AS "RecordClassName" FROM "School" WHERE ("School"."ID" = ?) LIMIT 1 0.0005s

0076: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", "SiteTree_Live"."ShowInSitemap", "SiteTree_Live"."AvailableOffline", CASE WHEN "SiteTree_Localised_lv_LV"."ID" IS NOT NULL THEN "SiteTree_Localised_lv_LV"."ExtraCode" WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."ExtraCode" ELSE "SiteTree_Live"."ExtraCode" END AS "ExtraCode", "SiteTree_Live"."CanViewType", "SiteTree_Live"."CanEditType", "SiteTree_Live"."Version", CASE WHEN "SiteTree_Localised_lv_LV"."ID" IS NOT NULL THEN "SiteTree_Localised_lv_LV"."URLSegment" 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_lv_LV"."ID" IS NOT NULL THEN "SiteTree_Localised_lv_LV"."Title" 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_lv_LV"."ID" IS NOT NULL THEN "SiteTree_Localised_lv_LV"."MenuTitle" 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_lv_LV"."ID" IS NOT NULL THEN "SiteTree_Localised_lv_LV"."Content" 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_lv_LV"."ID" IS NOT NULL THEN "SiteTree_Localised_lv_LV"."MetaDescription" 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_lv_LV"."ID" IS NOT NULL THEN "SiteTree_Localised_lv_LV"."ReportClass" WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."ReportClass" ELSE "SiteTree_Live"."ReportClass" END AS "ReportClass", "SiteTree_Live"."ParentID", "Page_Live"."InheritSideBar", "Page_Live"."BlockIcon", "Page_Live"."SideBarID", "Page_Live"."ElementalAreaID", "SiteTree_Live"."ID", CASE WHEN "SiteTree_Live"."ClassName" IS NOT NULL THEN "SiteTree_Live"."ClassName" ELSE 'SilverStripe\\CMS\\Model\\SiteTree' END AS "RecordClassName", 'lv_LV' AS "Locale", CASE WHEN "SiteTree_Localised_lv_LV"."ID" IS NOT NULL THEN 'lv_LV' WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN 'en_US' ELSE NULL END AS "SourceLocale" FROM "SiteTree_Live" LEFT JOIN "Page_Live" ON "Page_Live"."ID" = "SiteTree_Live"."ID" LEFT JOIN "SiteTree_Localised_Live" AS "SiteTree_Localised_lv_LV" ON "SiteTree_Live"."ID" = "SiteTree_Localised_lv_LV"."RecordID" AND "SiteTree_Localised_lv_LV"."Locale" = ? 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"."ClassName" = ?) AND ("SiteTree_Live"."ClassName" IN (?, ?, ?, ?)) AND (("SiteTree_Localised_lv_LV"."ID" IS NOT NULL)) ORDER BY "SiteTree_Live"."ParentID" ASC, "SiteTree_Live"."Sort" ASC LIMIT 1 0.002s

0077: SELECT DISTINCT "File_Live"."ClassName", "File_Live"."LastEdited", "File_Live"."Created", "File_Live"."UserFormUpload", "File_Live"."IsTemporary", "File_Live"."Version", "File_Live"."CanViewType", "File_Live"."CanEditType", "File_Live"."Name", "File_Live"."Title", "File_Live"."ShowInSearch", "File_Live"."ParentID", "File_Live"."OwnerID", "File_Live"."FileHash", "File_Live"."FileFilename", "File_Live"."FileVariant", "File_Live"."ObjectID", "File_Live"."ObjectClass", "Image_Live"."FocusPointX", "Image_Live"."FocusPointY", "Image_Live"."FocusPointWidth", "Image_Live"."FocusPointHeight", "File_Live"."ID", CASE WHEN "File_Live"."ClassName" IS NOT NULL THEN "File_Live"."ClassName" ELSE 'SilverStripe\\Assets\\File' END AS "RecordClassName" FROM "File_Live" LEFT JOIN "Image_Live" ON "Image_Live"."ID" = "File_Live"."ID" WHERE ("File_Live"."ID" = ?) AND ("File_Live"."ClassName" IN (?)) ORDER BY "File_Live"."Name" ASC LIMIT 1 0.0007s

0078: SELECT DISTINCT count(DISTINCT "DrawingVotes"."ID") AS "Count" FROM "DrawingVotes" WHERE ("DrawingVotes"."DrawingID" = ?) 0.0006s

0079: SELECT DISTINCT "SchoolGroup"."ClassName", "SchoolGroup"."LastEdited", "SchoolGroup"."Created", "SchoolGroup"."Title", "SchoolGroup"."Comment", "SchoolGroup"."ParentID", "SchoolGroup"."MemberID", "SchoolGroup"."ID", CASE WHEN "SchoolGroup"."ClassName" IS NOT NULL THEN "SchoolGroup"."ClassName" ELSE 'App\\Models\\Group' END AS "RecordClassName" FROM "SchoolGroup" WHERE ("SchoolGroup"."ID" = ?) LIMIT 1 0.0005s

0080: SELECT DISTINCT "School"."ClassName", "School"."LastEdited", "School"."Created", "School"."Address", "School"."Suburb", "School"."State", "School"."Postcode", "School"."Country", "School"."Title", "School"."Location", "School"."Phone", "School"."Email", "School"."ID", CASE WHEN "School"."ClassName" IS NOT NULL THEN "School"."ClassName" ELSE 'App\\Models\\School' END AS "RecordClassName" FROM "School" WHERE ("School"."ID" = ?) LIMIT 1 0.0004s

0081: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", "SiteTree_Live"."ShowInSitemap", "SiteTree_Live"."AvailableOffline", CASE WHEN "SiteTree_Localised_lv_LV"."ID" IS NOT NULL THEN "SiteTree_Localised_lv_LV"."ExtraCode" WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."ExtraCode" ELSE "SiteTree_Live"."ExtraCode" END AS "ExtraCode", "SiteTree_Live"."CanViewType", "SiteTree_Live"."CanEditType", "SiteTree_Live"."Version", CASE WHEN "SiteTree_Localised_lv_LV"."ID" IS NOT NULL THEN "SiteTree_Localised_lv_LV"."URLSegment" 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_lv_LV"."ID" IS NOT NULL THEN "SiteTree_Localised_lv_LV"."Title" 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_lv_LV"."ID" IS NOT NULL THEN "SiteTree_Localised_lv_LV"."MenuTitle" 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_lv_LV"."ID" IS NOT NULL THEN "SiteTree_Localised_lv_LV"."Content" 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_lv_LV"."ID" IS NOT NULL THEN "SiteTree_Localised_lv_LV"."MetaDescription" 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_lv_LV"."ID" IS NOT NULL THEN "SiteTree_Localised_lv_LV"."ReportClass" WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."ReportClass" ELSE "SiteTree_Live"."ReportClass" END AS "ReportClass", "SiteTree_Live"."ParentID", "Page_Live"."InheritSideBar", "Page_Live"."BlockIcon", "Page_Live"."SideBarID", "Page_Live"."ElementalAreaID", "SiteTree_Live"."ID", CASE WHEN "SiteTree_Live"."ClassName" IS NOT NULL THEN "SiteTree_Live"."ClassName" ELSE 'SilverStripe\\CMS\\Model\\SiteTree' END AS "RecordClassName", 'lv_LV' AS "Locale", CASE WHEN "SiteTree_Localised_lv_LV"."ID" IS NOT NULL THEN 'lv_LV' WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN 'en_US' ELSE NULL END AS "SourceLocale" FROM "SiteTree_Live" LEFT JOIN "Page_Live" ON "Page_Live"."ID" = "SiteTree_Live"."ID" LEFT JOIN "SiteTree_Localised_Live" AS "SiteTree_Localised_lv_LV" ON "SiteTree_Live"."ID" = "SiteTree_Localised_lv_LV"."RecordID" AND "SiteTree_Localised_lv_LV"."Locale" = ? 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"."ClassName" = ?) AND ("SiteTree_Live"."ClassName" IN (?, ?, ?, ?)) AND (("SiteTree_Localised_lv_LV"."ID" IS NOT NULL)) ORDER BY "SiteTree_Live"."ParentID" ASC, "SiteTree_Live"."Sort" ASC LIMIT 1 0.0016s

0082: SELECT DISTINCT "File_Live"."ClassName", "File_Live"."LastEdited", "File_Live"."Created", "File_Live"."UserFormUpload", "File_Live"."IsTemporary", "File_Live"."Version", "File_Live"."CanViewType", "File_Live"."CanEditType", "File_Live"."Name", "File_Live"."Title", "File_Live"."ShowInSearch", "File_Live"."ParentID", "File_Live"."OwnerID", "File_Live"."FileHash", "File_Live"."FileFilename", "File_Live"."FileVariant", "File_Live"."ObjectID", "File_Live"."ObjectClass", "Image_Live"."FocusPointX", "Image_Live"."FocusPointY", "Image_Live"."FocusPointWidth", "Image_Live"."FocusPointHeight", "File_Live"."ID", CASE WHEN "File_Live"."ClassName" IS NOT NULL THEN "File_Live"."ClassName" ELSE 'SilverStripe\\Assets\\File' END AS "RecordClassName" FROM "File_Live" LEFT JOIN "Image_Live" ON "Image_Live"."ID" = "File_Live"."ID" WHERE ("File_Live"."ID" = ?) AND ("File_Live"."ClassName" IN (?)) ORDER BY "File_Live"."Name" ASC LIMIT 1 0.0006s

0083: SELECT DISTINCT count(DISTINCT "DrawingVotes"."ID") AS "Count" FROM "DrawingVotes" WHERE ("DrawingVotes"."DrawingID" = ?) 0.0005s

0084: SELECT DISTINCT "SchoolGroup"."ClassName", "SchoolGroup"."LastEdited", "SchoolGroup"."Created", "SchoolGroup"."Title", "SchoolGroup"."Comment", "SchoolGroup"."ParentID", "SchoolGroup"."MemberID", "SchoolGroup"."ID", CASE WHEN "SchoolGroup"."ClassName" IS NOT NULL THEN "SchoolGroup"."ClassName" ELSE 'App\\Models\\Group' END AS "RecordClassName" FROM "SchoolGroup" WHERE ("SchoolGroup"."ID" = ?) LIMIT 1 0.0004s

0085: SELECT DISTINCT "School"."ClassName", "School"."LastEdited", "School"."Created", "School"."Address", "School"."Suburb", "School"."State", "School"."Postcode", "School"."Country", "School"."Title", "School"."Location", "School"."Phone", "School"."Email", "School"."ID", CASE WHEN "School"."ClassName" IS NOT NULL THEN "School"."ClassName" ELSE 'App\\Models\\School' END AS "RecordClassName" FROM "School" WHERE ("School"."ID" = ?) LIMIT 1 0.0004s

0086: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", "SiteTree_Live"."ShowInSitemap", "SiteTree_Live"."AvailableOffline", CASE WHEN "SiteTree_Localised_lv_LV"."ID" IS NOT NULL THEN "SiteTree_Localised_lv_LV"."ExtraCode" WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."ExtraCode" ELSE "SiteTree_Live"."ExtraCode" END AS "ExtraCode", "SiteTree_Live"."CanViewType", "SiteTree_Live"."CanEditType", "SiteTree_Live"."Version", CASE WHEN "SiteTree_Localised_lv_LV"."ID" IS NOT NULL THEN "SiteTree_Localised_lv_LV"."URLSegment" 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_lv_LV"."ID" IS NOT NULL THEN "SiteTree_Localised_lv_LV"."Title" 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_lv_LV"."ID" IS NOT NULL THEN "SiteTree_Localised_lv_LV"."MenuTitle" 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_lv_LV"."ID" IS NOT NULL THEN "SiteTree_Localised_lv_LV"."Content" 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_lv_LV"."ID" IS NOT NULL THEN "SiteTree_Localised_lv_LV"."MetaDescription" 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_lv_LV"."ID" IS NOT NULL THEN "SiteTree_Localised_lv_LV"."ReportClass" WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."ReportClass" ELSE "SiteTree_Live"."ReportClass" END AS "ReportClass", "SiteTree_Live"."ParentID", "Page_Live"."InheritSideBar", "Page_Live"."BlockIcon", "Page_Live"."SideBarID", "Page_Live"."ElementalAreaID", "SiteTree_Live"."ID", CASE WHEN "SiteTree_Live"."ClassName" IS NOT NULL THEN "SiteTree_Live"."ClassName" ELSE 'SilverStripe\\CMS\\Model\\SiteTree' END AS "RecordClassName", 'lv_LV' AS "Locale", CASE WHEN "SiteTree_Localised_lv_LV"."ID" IS NOT NULL THEN 'lv_LV' WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN 'en_US' ELSE NULL END AS "SourceLocale" FROM "SiteTree_Live" LEFT JOIN "Page_Live" ON "Page_Live"."ID" = "SiteTree_Live"."ID" LEFT JOIN "SiteTree_Localised_Live" AS "SiteTree_Localised_lv_LV" ON "SiteTree_Live"."ID" = "SiteTree_Localised_lv_LV"."RecordID" AND "SiteTree_Localised_lv_LV"."Locale" = ? 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"."ClassName" = ?) AND ("SiteTree_Live"."ClassName" IN (?, ?, ?, ?)) AND (("SiteTree_Localised_lv_LV"."ID" IS NOT NULL)) ORDER BY "SiteTree_Live"."ParentID" ASC, "SiteTree_Live"."Sort" ASC LIMIT 1 0.0015s

0087: SELECT DISTINCT "File_Live"."ClassName", "File_Live"."LastEdited", "File_Live"."Created", "File_Live"."UserFormUpload", "File_Live"."IsTemporary", "File_Live"."Version", "File_Live"."CanViewType", "File_Live"."CanEditType", "File_Live"."Name", "File_Live"."Title", "File_Live"."ShowInSearch", "File_Live"."ParentID", "File_Live"."OwnerID", "File_Live"."FileHash", "File_Live"."FileFilename", "File_Live"."FileVariant", "File_Live"."ObjectID", "File_Live"."ObjectClass", "Image_Live"."FocusPointX", "Image_Live"."FocusPointY", "Image_Live"."FocusPointWidth", "Image_Live"."FocusPointHeight", "File_Live"."ID", CASE WHEN "File_Live"."ClassName" IS NOT NULL THEN "File_Live"."ClassName" ELSE 'SilverStripe\\Assets\\File' END AS "RecordClassName" FROM "File_Live" LEFT JOIN "Image_Live" ON "Image_Live"."ID" = "File_Live"."ID" WHERE ("File_Live"."ID" = ?) AND ("File_Live"."ClassName" IN (?)) ORDER BY "File_Live"."Name" ASC LIMIT 1 0.0007s

0088: SELECT DISTINCT count(DISTINCT "DrawingVotes"."ID") AS "Count" FROM "DrawingVotes" WHERE ("DrawingVotes"."DrawingID" = ?) 0.0004s

0089: SELECT DISTINCT "SchoolGroup"."ClassName", "SchoolGroup"."LastEdited", "SchoolGroup"."Created", "SchoolGroup"."Title", "SchoolGroup"."Comment", "SchoolGroup"."ParentID", "SchoolGroup"."MemberID", "SchoolGroup"."ID", CASE WHEN "SchoolGroup"."ClassName" IS NOT NULL THEN "SchoolGroup"."ClassName" ELSE 'App\\Models\\Group' END AS "RecordClassName" FROM "SchoolGroup" WHERE ("SchoolGroup"."ID" = ?) LIMIT 1 0.0005s

0090: SELECT DISTINCT "School"."ClassName", "School"."LastEdited", "School"."Created", "School"."Address", "School"."Suburb", "School"."State", "School"."Postcode", "School"."Country", "School"."Title", "School"."Location", "School"."Phone", "School"."Email", "School"."ID", CASE WHEN "School"."ClassName" IS NOT NULL THEN "School"."ClassName" ELSE 'App\\Models\\School' END AS "RecordClassName" FROM "School" WHERE ("School"."ID" = ?) LIMIT 1 0.0005s

0091: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", "SiteTree_Live"."ShowInSitemap", "SiteTree_Live"."AvailableOffline", CASE WHEN "SiteTree_Localised_lv_LV"."ID" IS NOT NULL THEN "SiteTree_Localised_lv_LV"."ExtraCode" WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."ExtraCode" ELSE "SiteTree_Live"."ExtraCode" END AS "ExtraCode", "SiteTree_Live"."CanViewType", "SiteTree_Live"."CanEditType", "SiteTree_Live"."Version", CASE WHEN "SiteTree_Localised_lv_LV"."ID" IS NOT NULL THEN "SiteTree_Localised_lv_LV"."URLSegment" 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_lv_LV"."ID" IS NOT NULL THEN "SiteTree_Localised_lv_LV"."Title" 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_lv_LV"."ID" IS NOT NULL THEN "SiteTree_Localised_lv_LV"."MenuTitle" 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_lv_LV"."ID" IS NOT NULL THEN "SiteTree_Localised_lv_LV"."Content" 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_lv_LV"."ID" IS NOT NULL THEN "SiteTree_Localised_lv_LV"."MetaDescription" 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_lv_LV"."ID" IS NOT NULL THEN "SiteTree_Localised_lv_LV"."ReportClass" WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."ReportClass" ELSE "SiteTree_Live"."ReportClass" END AS "ReportClass", "SiteTree_Live"."ParentID", "Page_Live"."InheritSideBar", "Page_Live"."BlockIcon", "Page_Live"."SideBarID", "Page_Live"."ElementalAreaID", "SiteTree_Live"."ID", CASE WHEN "SiteTree_Live"."ClassName" IS NOT NULL THEN "SiteTree_Live"."ClassName" ELSE 'SilverStripe\\CMS\\Model\\SiteTree' END AS "RecordClassName", 'lv_LV' AS "Locale", CASE WHEN "SiteTree_Localised_lv_LV"."ID" IS NOT NULL THEN 'lv_LV' WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN 'en_US' ELSE NULL END AS "SourceLocale" FROM "SiteTree_Live" LEFT JOIN "Page_Live" ON "Page_Live"."ID" = "SiteTree_Live"."ID" LEFT JOIN "SiteTree_Localised_Live" AS "SiteTree_Localised_lv_LV" ON "SiteTree_Live"."ID" = "SiteTree_Localised_lv_LV"."RecordID" AND "SiteTree_Localised_lv_LV"."Locale" = ? 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"."ClassName" = ?) AND ("SiteTree_Live"."ClassName" IN (?, ?, ?, ?)) AND (("SiteTree_Localised_lv_LV"."ID" IS NOT NULL)) ORDER BY "SiteTree_Live"."ParentID" ASC, "SiteTree_Live"."Sort" ASC LIMIT 1 0.0016s

0092: SELECT DISTINCT "File_Live"."ClassName", "File_Live"."LastEdited", "File_Live"."Created", "File_Live"."UserFormUpload", "File_Live"."IsTemporary", "File_Live"."Version", "File_Live"."CanViewType", "File_Live"."CanEditType", "File_Live"."Name", "File_Live"."Title", "File_Live"."ShowInSearch", "File_Live"."ParentID", "File_Live"."OwnerID", "File_Live"."FileHash", "File_Live"."FileFilename", "File_Live"."FileVariant", "File_Live"."ObjectID", "File_Live"."ObjectClass", "Image_Live"."FocusPointX", "Image_Live"."FocusPointY", "Image_Live"."FocusPointWidth", "Image_Live"."FocusPointHeight", "File_Live"."ID", CASE WHEN "File_Live"."ClassName" IS NOT NULL THEN "File_Live"."ClassName" ELSE 'SilverStripe\\Assets\\File' END AS "RecordClassName" FROM "File_Live" LEFT JOIN "Image_Live" ON "Image_Live"."ID" = "File_Live"."ID" WHERE ("File_Live"."ID" = ?) AND ("File_Live"."ClassName" IN (?)) ORDER BY "File_Live"."Name" ASC LIMIT 1 0.0006s

0093: SELECT DISTINCT count(DISTINCT "DrawingVotes"."ID") AS "Count" FROM "DrawingVotes" WHERE ("DrawingVotes"."DrawingID" = ?) 0.0005s

0094: SELECT DISTINCT "DrawingVotes"."ClassName", "DrawingVotes"."LastEdited", "DrawingVotes"."Created", "DrawingVotes"."Grade", "DrawingVotes"."Times", "DrawingVotes"."OwnerID", "DrawingVotes"."DrawingID", "DrawingVotes"."ID", CASE WHEN "DrawingVotes"."ClassName" IS NOT NULL THEN "DrawingVotes"."ClassName" ELSE 'App\\Models\\Vote' END AS "RecordClassName" FROM "DrawingVotes" WHERE ("DrawingVotes"."DrawingID" = ?) ORDER BY "DrawingVotes"."Created" DESC 0.0007s

0095: SELECT DISTINCT "SchoolGroup"."ClassName", "SchoolGroup"."LastEdited", "SchoolGroup"."Created", "SchoolGroup"."Title", "SchoolGroup"."Comment", "SchoolGroup"."ParentID", "SchoolGroup"."MemberID", "SchoolGroup"."ID", CASE WHEN "SchoolGroup"."ClassName" IS NOT NULL THEN "SchoolGroup"."ClassName" ELSE 'App\\Models\\Group' END AS "RecordClassName" FROM "SchoolGroup" WHERE ("SchoolGroup"."ID" = ?) LIMIT 1 0.0005s

0096: SELECT DISTINCT "School"."ClassName", "School"."LastEdited", "School"."Created", "School"."Address", "School"."Suburb", "School"."State", "School"."Postcode", "School"."Country", "School"."Title", "School"."Location", "School"."Phone", "School"."Email", "School"."ID", CASE WHEN "School"."ClassName" IS NOT NULL THEN "School"."ClassName" ELSE 'App\\Models\\School' END AS "RecordClassName" FROM "School" WHERE ("School"."ID" = ?) LIMIT 1 0.0004s

0097: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", "SiteTree_Live"."ShowInSitemap", "SiteTree_Live"."AvailableOffline", CASE WHEN "SiteTree_Localised_lv_LV"."ID" IS NOT NULL THEN "SiteTree_Localised_lv_LV"."ExtraCode" WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."ExtraCode" ELSE "SiteTree_Live"."ExtraCode" END AS "ExtraCode", "SiteTree_Live"."CanViewType", "SiteTree_Live"."CanEditType", "SiteTree_Live"."Version", CASE WHEN "SiteTree_Localised_lv_LV"."ID" IS NOT NULL THEN "SiteTree_Localised_lv_LV"."URLSegment" 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_lv_LV"."ID" IS NOT NULL THEN "SiteTree_Localised_lv_LV"."Title" 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_lv_LV"."ID" IS NOT NULL THEN "SiteTree_Localised_lv_LV"."MenuTitle" 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_lv_LV"."ID" IS NOT NULL THEN "SiteTree_Localised_lv_LV"."Content" 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_lv_LV"."ID" IS NOT NULL THEN "SiteTree_Localised_lv_LV"."MetaDescription" 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_lv_LV"."ID" IS NOT NULL THEN "SiteTree_Localised_lv_LV"."ReportClass" WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."ReportClass" ELSE "SiteTree_Live"."ReportClass" END AS "ReportClass", "SiteTree_Live"."ParentID", "Page_Live"."InheritSideBar", "Page_Live"."BlockIcon", "Page_Live"."SideBarID", "Page_Live"."ElementalAreaID", "SiteTree_Live"."ID", CASE WHEN "SiteTree_Live"."ClassName" IS NOT NULL THEN "SiteTree_Live"."ClassName" ELSE 'SilverStripe\\CMS\\Model\\SiteTree' END AS "RecordClassName", 'lv_LV' AS "Locale", CASE WHEN "SiteTree_Localised_lv_LV"."ID" IS NOT NULL THEN 'lv_LV' WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN 'en_US' ELSE NULL END AS "SourceLocale" FROM "SiteTree_Live" LEFT JOIN "Page_Live" ON "Page_Live"."ID" = "SiteTree_Live"."ID" LEFT JOIN "SiteTree_Localised_Live" AS "SiteTree_Localised_lv_LV" ON "SiteTree_Live"."ID" = "SiteTree_Localised_lv_LV"."RecordID" AND "SiteTree_Localised_lv_LV"."Locale" = ? 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"."ClassName" = ?) AND ("SiteTree_Live"."ClassName" IN (?, ?, ?, ?)) AND (("SiteTree_Localised_lv_LV"."ID" IS NOT NULL)) ORDER BY "SiteTree_Live"."ParentID" ASC, "SiteTree_Live"."Sort" ASC LIMIT 1 0.0016s

0098: SELECT DISTINCT "File_Live"."ClassName", "File_Live"."LastEdited", "File_Live"."Created", "File_Live"."UserFormUpload", "File_Live"."IsTemporary", "File_Live"."Version", "File_Live"."CanViewType", "File_Live"."CanEditType", "File_Live"."Name", "File_Live"."Title", "File_Live"."ShowInSearch", "File_Live"."ParentID", "File_Live"."OwnerID", "File_Live"."FileHash", "File_Live"."FileFilename", "File_Live"."FileVariant", "File_Live"."ObjectID", "File_Live"."ObjectClass", "Image_Live"."FocusPointX", "Image_Live"."FocusPointY", "Image_Live"."FocusPointWidth", "Image_Live"."FocusPointHeight", "File_Live"."ID", CASE WHEN "File_Live"."ClassName" IS NOT NULL THEN "File_Live"."ClassName" ELSE 'SilverStripe\\Assets\\File' END AS "RecordClassName" FROM "File_Live" LEFT JOIN "Image_Live" ON "Image_Live"."ID" = "File_Live"."ID" WHERE ("File_Live"."ID" = ?) AND ("File_Live"."ClassName" IN (?)) ORDER BY "File_Live"."Name" ASC LIMIT 1 0.0007s

0099: SELECT DISTINCT count(DISTINCT "DrawingVotes"."ID") AS "Count" FROM "DrawingVotes" WHERE ("DrawingVotes"."DrawingID" = ?) 0.0006s

0100: SELECT DISTINCT "DrawingVotes"."ClassName", "DrawingVotes"."LastEdited", "DrawingVotes"."Created", "DrawingVotes"."Grade", "DrawingVotes"."Times", "DrawingVotes"."OwnerID", "DrawingVotes"."DrawingID", "DrawingVotes"."ID", CASE WHEN "DrawingVotes"."ClassName" IS NOT NULL THEN "DrawingVotes"."ClassName" ELSE 'App\\Models\\Vote' END AS "RecordClassName" FROM "DrawingVotes" WHERE ("DrawingVotes"."DrawingID" = ?) ORDER BY "DrawingVotes"."Created" DESC 0.0007s

0101: SELECT DISTINCT "SchoolGroup"."ClassName", "SchoolGroup"."LastEdited", "SchoolGroup"."Created", "SchoolGroup"."Title", "SchoolGroup"."Comment", "SchoolGroup"."ParentID", "SchoolGroup"."MemberID", "SchoolGroup"."ID", CASE WHEN "SchoolGroup"."ClassName" IS NOT NULL THEN "SchoolGroup"."ClassName" ELSE 'App\\Models\\Group' END AS "RecordClassName" FROM "SchoolGroup" WHERE ("SchoolGroup"."ID" = ?) LIMIT 1 0.0005s

0102: SELECT DISTINCT "School"."ClassName", "School"."LastEdited", "School"."Created", "School"."Address", "School"."Suburb", "School"."State", "School"."Postcode", "School"."Country", "School"."Title", "School"."Location", "School"."Phone", "School"."Email", "School"."ID", CASE WHEN "School"."ClassName" IS NOT NULL THEN "School"."ClassName" ELSE 'App\\Models\\School' END AS "RecordClassName" FROM "School" WHERE ("School"."ID" = ?) LIMIT 1 0.0005s

0103: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", "SiteTree_Live"."ShowInSitemap", "SiteTree_Live"."AvailableOffline", CASE WHEN "SiteTree_Localised_lv_LV"."ID" IS NOT NULL THEN "SiteTree_Localised_lv_LV"."ExtraCode" WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."ExtraCode" ELSE "SiteTree_Live"."ExtraCode" END AS "ExtraCode", "SiteTree_Live"."CanViewType", "SiteTree_Live"."CanEditType", "SiteTree_Live"."Version", CASE WHEN "SiteTree_Localised_lv_LV"."ID" IS NOT NULL THEN "SiteTree_Localised_lv_LV"."URLSegment" 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_lv_LV"."ID" IS NOT NULL THEN "SiteTree_Localised_lv_LV"."Title" 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_lv_LV"."ID" IS NOT NULL THEN "SiteTree_Localised_lv_LV"."MenuTitle" 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_lv_LV"."ID" IS NOT NULL THEN "SiteTree_Localised_lv_LV"."Content" 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_lv_LV"."ID" IS NOT NULL THEN "SiteTree_Localised_lv_LV"."MetaDescription" 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_lv_LV"."ID" IS NOT NULL THEN "SiteTree_Localised_lv_LV"."ReportClass" WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."ReportClass" ELSE "SiteTree_Live"."ReportClass" END AS "ReportClass", "SiteTree_Live"."ParentID", "Page_Live"."InheritSideBar", "Page_Live"."BlockIcon", "Page_Live"."SideBarID", "Page_Live"."ElementalAreaID", "SiteTree_Live"."ID", CASE WHEN "SiteTree_Live"."ClassName" IS NOT NULL THEN "SiteTree_Live"."ClassName" ELSE 'SilverStripe\\CMS\\Model\\SiteTree' END AS "RecordClassName", 'lv_LV' AS "Locale", CASE WHEN "SiteTree_Localised_lv_LV"."ID" IS NOT NULL THEN 'lv_LV' WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN 'en_US' ELSE NULL END AS "SourceLocale" FROM "SiteTree_Live" LEFT JOIN "Page_Live" ON "Page_Live"."ID" = "SiteTree_Live"."ID" LEFT JOIN "SiteTree_Localised_Live" AS "SiteTree_Localised_lv_LV" ON "SiteTree_Live"."ID" = "SiteTree_Localised_lv_LV"."RecordID" AND "SiteTree_Localised_lv_LV"."Locale" = ? 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"."ClassName" = ?) AND ("SiteTree_Live"."ClassName" IN (?, ?, ?, ?)) AND (("SiteTree_Localised_lv_LV"."ID" IS NOT NULL)) ORDER BY "SiteTree_Live"."ParentID" ASC, "SiteTree_Live"."Sort" ASC LIMIT 1 0.0016s

0104: SELECT DISTINCT "File_Live"."ClassName", "File_Live"."LastEdited", "File_Live"."Created", "File_Live"."UserFormUpload", "File_Live"."IsTemporary", "File_Live"."Version", "File_Live"."CanViewType", "File_Live"."CanEditType", "File_Live"."Name", "File_Live"."Title", "File_Live"."ShowInSearch", "File_Live"."ParentID", "File_Live"."OwnerID", "File_Live"."FileHash", "File_Live"."FileFilename", "File_Live"."FileVariant", "File_Live"."ObjectID", "File_Live"."ObjectClass", "Image_Live"."FocusPointX", "Image_Live"."FocusPointY", "Image_Live"."FocusPointWidth", "Image_Live"."FocusPointHeight", "File_Live"."ID", CASE WHEN "File_Live"."ClassName" IS NOT NULL THEN "File_Live"."ClassName" ELSE 'SilverStripe\\Assets\\File' END AS "RecordClassName" FROM "File_Live" LEFT JOIN "Image_Live" ON "Image_Live"."ID" = "File_Live"."ID" WHERE ("File_Live"."ID" = ?) AND ("File_Live"."ClassName" IN (?)) ORDER BY "File_Live"."Name" ASC LIMIT 1 0.0007s

0105: SELECT DISTINCT count(DISTINCT "DrawingVotes"."ID") AS "Count" FROM "DrawingVotes" WHERE ("DrawingVotes"."DrawingID" = ?) 0.0005s

0106: SELECT DISTINCT "SchoolGroup"."ClassName", "SchoolGroup"."LastEdited", "SchoolGroup"."Created", "SchoolGroup"."Title", "SchoolGroup"."Comment", "SchoolGroup"."ParentID", "SchoolGroup"."MemberID", "SchoolGroup"."ID", CASE WHEN "SchoolGroup"."ClassName" IS NOT NULL THEN "SchoolGroup"."ClassName" ELSE 'App\\Models\\Group' END AS "RecordClassName" FROM "SchoolGroup" WHERE ("SchoolGroup"."ID" = ?) LIMIT 1 0.0005s

0107: SELECT DISTINCT "School"."ClassName", "School"."LastEdited", "School"."Created", "School"."Address", "School"."Suburb", "School"."State", "School"."Postcode", "School"."Country", "School"."Title", "School"."Location", "School"."Phone", "School"."Email", "School"."ID", CASE WHEN "School"."ClassName" IS NOT NULL THEN "School"."ClassName" ELSE 'App\\Models\\School' END AS "RecordClassName" FROM "School" WHERE ("School"."ID" = ?) LIMIT 1 0.0006s

0108: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", "SiteTree_Live"."ShowInSitemap", "SiteTree_Live"."AvailableOffline", CASE WHEN "SiteTree_Localised_lv_LV"."ID" IS NOT NULL THEN "SiteTree_Localised_lv_LV"."ExtraCode" WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."ExtraCode" ELSE "SiteTree_Live"."ExtraCode" END AS "ExtraCode", "SiteTree_Live"."CanViewType", "SiteTree_Live"."CanEditType", "SiteTree_Live"."Version", CASE WHEN "SiteTree_Localised_lv_LV"."ID" IS NOT NULL THEN "SiteTree_Localised_lv_LV"."URLSegment" 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_lv_LV"."ID" IS NOT NULL THEN "SiteTree_Localised_lv_LV"."Title" 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_lv_LV"."ID" IS NOT NULL THEN "SiteTree_Localised_lv_LV"."MenuTitle" 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_lv_LV"."ID" IS NOT NULL THEN "SiteTree_Localised_lv_LV"."Content" 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_lv_LV"."ID" IS NOT NULL THEN "SiteTree_Localised_lv_LV"."MetaDescription" 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_lv_LV"."ID" IS NOT NULL THEN "SiteTree_Localised_lv_LV"."ReportClass" WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."ReportClass" ELSE "SiteTree_Live"."ReportClass" END AS "ReportClass", "SiteTree_Live"."ParentID", "Page_Live"."InheritSideBar", "Page_Live"."BlockIcon", "Page_Live"."SideBarID", "Page_Live"."ElementalAreaID", "SiteTree_Live"."ID", CASE WHEN "SiteTree_Live"."ClassName" IS NOT NULL THEN "SiteTree_Live"."ClassName" ELSE 'SilverStripe\\CMS\\Model\\SiteTree' END AS "RecordClassName", 'lv_LV' AS "Locale", CASE WHEN "SiteTree_Localised_lv_LV"."ID" IS NOT NULL THEN 'lv_LV' WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN 'en_US' ELSE NULL END AS "SourceLocale" FROM "SiteTree_Live" LEFT JOIN "Page_Live" ON "Page_Live"."ID" = "SiteTree_Live"."ID" LEFT JOIN "SiteTree_Localised_Live" AS "SiteTree_Localised_lv_LV" ON "SiteTree_Live"."ID" = "SiteTree_Localised_lv_LV"."RecordID" AND "SiteTree_Localised_lv_LV"."Locale" = ? 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"."ClassName" = ?) AND ("SiteTree_Live"."ClassName" IN (?, ?, ?, ?)) AND (("SiteTree_Localised_lv_LV"."ID" IS NOT NULL)) ORDER BY "SiteTree_Live"."ParentID" ASC, "SiteTree_Live"."Sort" ASC LIMIT 1 0.0018s

0109: SELECT DISTINCT "File_Live"."ClassName", "File_Live"."LastEdited", "File_Live"."Created", "File_Live"."UserFormUpload", "File_Live"."IsTemporary", "File_Live"."Version", "File_Live"."CanViewType", "File_Live"."CanEditType", "File_Live"."Name", "File_Live"."Title", "File_Live"."ShowInSearch", "File_Live"."ParentID", "File_Live"."OwnerID", "File_Live"."FileHash", "File_Live"."FileFilename", "File_Live"."FileVariant", "File_Live"."ObjectID", "File_Live"."ObjectClass", "Image_Live"."FocusPointX", "Image_Live"."FocusPointY", "Image_Live"."FocusPointWidth", "Image_Live"."FocusPointHeight", "File_Live"."ID", CASE WHEN "File_Live"."ClassName" IS NOT NULL THEN "File_Live"."ClassName" ELSE 'SilverStripe\\Assets\\File' END AS "RecordClassName" FROM "File_Live" LEFT JOIN "Image_Live" ON "Image_Live"."ID" = "File_Live"."ID" WHERE ("File_Live"."ID" = ?) AND ("File_Live"."ClassName" IN (?)) ORDER BY "File_Live"."Name" ASC LIMIT 1 0.0006s

0110: SELECT DISTINCT count(DISTINCT "DrawingVotes"."ID") AS "Count" FROM "DrawingVotes" WHERE ("DrawingVotes"."DrawingID" = ?) 0.0007s

0111: SELECT DISTINCT "SchoolGroup"."ClassName", "SchoolGroup"."LastEdited", "SchoolGroup"."Created", "SchoolGroup"."Title", "SchoolGroup"."Comment", "SchoolGroup"."ParentID", "SchoolGroup"."MemberID", "SchoolGroup"."ID", CASE WHEN "SchoolGroup"."ClassName" IS NOT NULL THEN "SchoolGroup"."ClassName" ELSE 'App\\Models\\Group' END AS "RecordClassName" FROM "SchoolGroup" WHERE ("SchoolGroup"."ID" = ?) LIMIT 1 0.0006s

0112: SELECT DISTINCT "School"."ClassName", "School"."LastEdited", "School"."Created", "School"."Address", "School"."Suburb", "School"."State", "School"."Postcode", "School"."Country", "School"."Title", "School"."Location", "School"."Phone", "School"."Email", "School"."ID", CASE WHEN "School"."ClassName" IS NOT NULL THEN "School"."ClassName" ELSE 'App\\Models\\School' END AS "RecordClassName" FROM "School" WHERE ("School"."ID" = ?) LIMIT 1 0.0005s

0113: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", "SiteTree_Live"."ShowInSitemap", "SiteTree_Live"."AvailableOffline", CASE WHEN "SiteTree_Localised_lv_LV"."ID" IS NOT NULL THEN "SiteTree_Localised_lv_LV"."ExtraCode" WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."ExtraCode" ELSE "SiteTree_Live"."ExtraCode" END AS "ExtraCode", "SiteTree_Live"."CanViewType", "SiteTree_Live"."CanEditType", "SiteTree_Live"."Version", CASE WHEN "SiteTree_Localised_lv_LV"."ID" IS NOT NULL THEN "SiteTree_Localised_lv_LV"."URLSegment" 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_lv_LV"."ID" IS NOT NULL THEN "SiteTree_Localised_lv_LV"."Title" 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_lv_LV"."ID" IS NOT NULL THEN "SiteTree_Localised_lv_LV"."MenuTitle" 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_lv_LV"."ID" IS NOT NULL THEN "SiteTree_Localised_lv_LV"."Content" 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_lv_LV"."ID" IS NOT NULL THEN "SiteTree_Localised_lv_LV"."MetaDescription" 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_lv_LV"."ID" IS NOT NULL THEN "SiteTree_Localised_lv_LV"."ReportClass" WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."ReportClass" ELSE "SiteTree_Live"."ReportClass" END AS "ReportClass", "SiteTree_Live"."ParentID", "Page_Live"."InheritSideBar", "Page_Live"."BlockIcon", "Page_Live"."SideBarID", "Page_Live"."ElementalAreaID", "SiteTree_Live"."ID", CASE WHEN "SiteTree_Live"."ClassName" IS NOT NULL THEN "SiteTree_Live"."ClassName" ELSE 'SilverStripe\\CMS\\Model\\SiteTree' END AS "RecordClassName", 'lv_LV' AS "Locale", CASE WHEN "SiteTree_Localised_lv_LV"."ID" IS NOT NULL THEN 'lv_LV' WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN 'en_US' ELSE NULL END AS "SourceLocale" FROM "SiteTree_Live" LEFT JOIN "Page_Live" ON "Page_Live"."ID" = "SiteTree_Live"."ID" LEFT JOIN "SiteTree_Localised_Live" AS "SiteTree_Localised_lv_LV" ON "SiteTree_Live"."ID" = "SiteTree_Localised_lv_LV"."RecordID" AND "SiteTree_Localised_lv_LV"."Locale" = ? 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"."ClassName" = ?) AND ("SiteTree_Live"."ClassName" IN (?, ?, ?, ?)) AND (("SiteTree_Localised_lv_LV"."ID" IS NOT NULL)) ORDER BY "SiteTree_Live"."ParentID" ASC, "SiteTree_Live"."Sort" ASC LIMIT 1 0.0018s

0114: SELECT DISTINCT "File_Live"."ClassName", "File_Live"."LastEdited", "File_Live"."Created", "File_Live"."UserFormUpload", "File_Live"."IsTemporary", "File_Live"."Version", "File_Live"."CanViewType", "File_Live"."CanEditType", "File_Live"."Name", "File_Live"."Title", "File_Live"."ShowInSearch", "File_Live"."ParentID", "File_Live"."OwnerID", "File_Live"."FileHash", "File_Live"."FileFilename", "File_Live"."FileVariant", "File_Live"."ObjectID", "File_Live"."ObjectClass", "Image_Live"."FocusPointX", "Image_Live"."FocusPointY", "Image_Live"."FocusPointWidth", "Image_Live"."FocusPointHeight", "File_Live"."ID", CASE WHEN "File_Live"."ClassName" IS NOT NULL THEN "File_Live"."ClassName" ELSE 'SilverStripe\\Assets\\File' END AS "RecordClassName" FROM "File_Live" LEFT JOIN "Image_Live" ON "Image_Live"."ID" = "File_Live"."ID" WHERE ("File_Live"."ID" = ?) AND ("File_Live"."ClassName" IN (?)) ORDER BY "File_Live"."Name" ASC LIMIT 1 0.0007s

0115: SELECT DISTINCT count(DISTINCT "DrawingVotes"."ID") AS "Count" FROM "DrawingVotes" WHERE ("DrawingVotes"."DrawingID" = ?) 0.0006s

0116: SELECT DISTINCT "DrawingVotes"."ClassName", "DrawingVotes"."LastEdited", "DrawingVotes"."Created", "DrawingVotes"."Grade", "DrawingVotes"."Times", "DrawingVotes"."OwnerID", "DrawingVotes"."DrawingID", "DrawingVotes"."ID", CASE WHEN "DrawingVotes"."ClassName" IS NOT NULL THEN "DrawingVotes"."ClassName" ELSE 'App\\Models\\Vote' END AS "RecordClassName" FROM "DrawingVotes" WHERE ("DrawingVotes"."DrawingID" = ?) ORDER BY "DrawingVotes"."Created" DESC 0.0006s

0117: SELECT DISTINCT "SchoolGroup"."ClassName", "SchoolGroup"."LastEdited", "SchoolGroup"."Created", "SchoolGroup"."Title", "SchoolGroup"."Comment", "SchoolGroup"."ParentID", "SchoolGroup"."MemberID", "SchoolGroup"."ID", CASE WHEN "SchoolGroup"."ClassName" IS NOT NULL THEN "SchoolGroup"."ClassName" ELSE 'App\\Models\\Group' END AS "RecordClassName" FROM "SchoolGroup" WHERE ("SchoolGroup"."ID" = ?) LIMIT 1 0.0005s

0118: SELECT DISTINCT "School"."ClassName", "School"."LastEdited", "School"."Created", "School"."Address", "School"."Suburb", "School"."State", "School"."Postcode", "School"."Country", "School"."Title", "School"."Location", "School"."Phone", "School"."Email", "School"."ID", CASE WHEN "School"."ClassName" IS NOT NULL THEN "School"."ClassName" ELSE 'App\\Models\\School' END AS "RecordClassName" FROM "School" WHERE ("School"."ID" = ?) LIMIT 1 0.0005s

0119: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", "SiteTree_Live"."ShowInSitemap", "SiteTree_Live"."AvailableOffline", CASE WHEN "SiteTree_Localised_lv_LV"."ID" IS NOT NULL THEN "SiteTree_Localised_lv_LV"."ExtraCode" WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."ExtraCode" ELSE "SiteTree_Live"."ExtraCode" END AS "ExtraCode", "SiteTree_Live"."CanViewType", "SiteTree_Live"."CanEditType", "SiteTree_Live"."Version", CASE WHEN "SiteTree_Localised_lv_LV"."ID" IS NOT NULL THEN "SiteTree_Localised_lv_LV"."URLSegment" 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_lv_LV"."ID" IS NOT NULL THEN "SiteTree_Localised_lv_LV"."Title" 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_lv_LV"."ID" IS NOT NULL THEN "SiteTree_Localised_lv_LV"."MenuTitle" 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_lv_LV"."ID" IS NOT NULL THEN "SiteTree_Localised_lv_LV"."Content" 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_lv_LV"."ID" IS NOT NULL THEN "SiteTree_Localised_lv_LV"."MetaDescription" 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_lv_LV"."ID" IS NOT NULL THEN "SiteTree_Localised_lv_LV"."ReportClass" WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."ReportClass" ELSE "SiteTree_Live"."ReportClass" END AS "ReportClass", "SiteTree_Live"."ParentID", "Page_Live"."InheritSideBar", "Page_Live"."BlockIcon", "Page_Live"."SideBarID", "Page_Live"."ElementalAreaID", "SiteTree_Live"."ID", CASE WHEN "SiteTree_Live"."ClassName" IS NOT NULL THEN "SiteTree_Live"."ClassName" ELSE 'SilverStripe\\CMS\\Model\\SiteTree' END AS "RecordClassName", 'lv_LV' AS "Locale", CASE WHEN "SiteTree_Localised_lv_LV"."ID" IS NOT NULL THEN 'lv_LV' WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN 'en_US' ELSE NULL END AS "SourceLocale" FROM "SiteTree_Live" LEFT JOIN "Page_Live" ON "Page_Live"."ID" = "SiteTree_Live"."ID" LEFT JOIN "SiteTree_Localised_Live" AS "SiteTree_Localised_lv_LV" ON "SiteTree_Live"."ID" = "SiteTree_Localised_lv_LV"."RecordID" AND "SiteTree_Localised_lv_LV"."Locale" = ? 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"."ClassName" = ?) AND ("SiteTree_Live"."ClassName" IN (?, ?, ?, ?)) AND (("SiteTree_Localised_lv_LV"."ID" IS NOT NULL)) ORDER BY "SiteTree_Live"."ParentID" ASC, "SiteTree_Live"."Sort" ASC LIMIT 1 0.0017s

0120: SELECT DISTINCT "File_Live"."ClassName", "File_Live"."LastEdited", "File_Live"."Created", "File_Live"."UserFormUpload", "File_Live"."IsTemporary", "File_Live"."Version", "File_Live"."CanViewType", "File_Live"."CanEditType", "File_Live"."Name", "File_Live"."Title", "File_Live"."ShowInSearch", "File_Live"."ParentID", "File_Live"."OwnerID", "File_Live"."FileHash", "File_Live"."FileFilename", "File_Live"."FileVariant", "File_Live"."ObjectID", "File_Live"."ObjectClass", "Image_Live"."FocusPointX", "Image_Live"."FocusPointY", "Image_Live"."FocusPointWidth", "Image_Live"."FocusPointHeight", "File_Live"."ID", CASE WHEN "File_Live"."ClassName" IS NOT NULL THEN "File_Live"."ClassName" ELSE 'SilverStripe\\Assets\\File' END AS "RecordClassName" FROM "File_Live" LEFT JOIN "Image_Live" ON "Image_Live"."ID" = "File_Live"."ID" WHERE ("File_Live"."ID" = ?) AND ("File_Live"."ClassName" IN (?)) ORDER BY "File_Live"."Name" ASC LIMIT 1 0.0007s

0121: SELECT DISTINCT count(DISTINCT "DrawingVotes"."ID") AS "Count" FROM "DrawingVotes" WHERE ("DrawingVotes"."DrawingID" = ?) 0.0005s

0122: SELECT DISTINCT "SchoolGroup"."ClassName", "SchoolGroup"."LastEdited", "SchoolGroup"."Created", "SchoolGroup"."Title", "SchoolGroup"."Comment", "SchoolGroup"."ParentID", "SchoolGroup"."MemberID", "SchoolGroup"."ID", CASE WHEN "SchoolGroup"."ClassName" IS NOT NULL THEN "SchoolGroup"."ClassName" ELSE 'App\\Models\\Group' END AS "RecordClassName" FROM "SchoolGroup" WHERE ("SchoolGroup"."ID" = ?) LIMIT 1 0.0005s

0123: SELECT DISTINCT "School"."ClassName", "School"."LastEdited", "School"."Created", "School"."Address", "School"."Suburb", "School"."State", "School"."Postcode", "School"."Country", "School"."Title", "School"."Location", "School"."Phone", "School"."Email", "School"."ID", CASE WHEN "School"."ClassName" IS NOT NULL THEN "School"."ClassName" ELSE 'App\\Models\\School' END AS "RecordClassName" FROM "School" WHERE ("School"."ID" = ?) LIMIT 1 0.0005s

0124: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", "SiteTree_Live"."ShowInSitemap", "SiteTree_Live"."AvailableOffline", CASE WHEN "SiteTree_Localised_lv_LV"."ID" IS NOT NULL THEN "SiteTree_Localised_lv_LV"."ExtraCode" WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."ExtraCode" ELSE "SiteTree_Live"."ExtraCode" END AS "ExtraCode", "SiteTree_Live"."CanViewType", "SiteTree_Live"."CanEditType", "SiteTree_Live"."Version", CASE WHEN "SiteTree_Localised_lv_LV"."ID" IS NOT NULL THEN "SiteTree_Localised_lv_LV"."URLSegment" 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_lv_LV"."ID" IS NOT NULL THEN "SiteTree_Localised_lv_LV"."Title" 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_lv_LV"."ID" IS NOT NULL THEN "SiteTree_Localised_lv_LV"."MenuTitle" 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_lv_LV"."ID" IS NOT NULL THEN "SiteTree_Localised_lv_LV"."Content" 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_lv_LV"."ID" IS NOT NULL THEN "SiteTree_Localised_lv_LV"."MetaDescription" 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_lv_LV"."ID" IS NOT NULL THEN "SiteTree_Localised_lv_LV"."ReportClass" WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."ReportClass" ELSE "SiteTree_Live"."ReportClass" END AS "ReportClass", "SiteTree_Live"."ParentID", "Page_Live"."InheritSideBar", "Page_Live"."BlockIcon", "Page_Live"."SideBarID", "Page_Live"."ElementalAreaID", "SiteTree_Live"."ID", CASE WHEN "SiteTree_Live"."ClassName" IS NOT NULL THEN "SiteTree_Live"."ClassName" ELSE 'SilverStripe\\CMS\\Model\\SiteTree' END AS "RecordClassName", 'lv_LV' AS "Locale", CASE WHEN "SiteTree_Localised_lv_LV"."ID" IS NOT NULL THEN 'lv_LV' WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN 'en_US' ELSE NULL END AS "SourceLocale" FROM "SiteTree_Live" LEFT JOIN "Page_Live" ON "Page_Live"."ID" = "SiteTree_Live"."ID" LEFT JOIN "SiteTree_Localised_Live" AS "SiteTree_Localised_lv_LV" ON "SiteTree_Live"."ID" = "SiteTree_Localised_lv_LV"."RecordID" AND "SiteTree_Localised_lv_LV"."Locale" = ? 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"."ClassName" = ?) AND ("SiteTree_Live"."ClassName" IN (?, ?, ?, ?)) AND (("SiteTree_Localised_lv_LV"."ID" IS NOT NULL)) ORDER BY "SiteTree_Live"."ParentID" ASC, "SiteTree_Live"."Sort" ASC LIMIT 1 0.0015s

0125: SELECT DISTINCT "File_Live"."ClassName", "File_Live"."LastEdited", "File_Live"."Created", "File_Live"."UserFormUpload", "File_Live"."IsTemporary", "File_Live"."Version", "File_Live"."CanViewType", "File_Live"."CanEditType", "File_Live"."Name", "File_Live"."Title", "File_Live"."ShowInSearch", "File_Live"."ParentID", "File_Live"."OwnerID", "File_Live"."FileHash", "File_Live"."FileFilename", "File_Live"."FileVariant", "File_Live"."ObjectID", "File_Live"."ObjectClass", "Image_Live"."FocusPointX", "Image_Live"."FocusPointY", "Image_Live"."FocusPointWidth", "Image_Live"."FocusPointHeight", "File_Live"."ID", CASE WHEN "File_Live"."ClassName" IS NOT NULL THEN "File_Live"."ClassName" ELSE 'SilverStripe\\Assets\\File' END AS "RecordClassName" FROM "File_Live" LEFT JOIN "Image_Live" ON "Image_Live"."ID" = "File_Live"."ID" WHERE ("File_Live"."ID" = ?) AND ("File_Live"."ClassName" IN (?)) ORDER BY "File_Live"."Name" ASC LIMIT 1 0.0006s

0126: SELECT DISTINCT count(DISTINCT "DrawingVotes"."ID") AS "Count" FROM "DrawingVotes" WHERE ("DrawingVotes"."DrawingID" = ?) 0.0005s

0127: SELECT DISTINCT "SchoolGroup"."ClassName", "SchoolGroup"."LastEdited", "SchoolGroup"."Created", "SchoolGroup"."Title", "SchoolGroup"."Comment", "SchoolGroup"."ParentID", "SchoolGroup"."MemberID", "SchoolGroup"."ID", CASE WHEN "SchoolGroup"."ClassName" IS NOT NULL THEN "SchoolGroup"."ClassName" ELSE 'App\\Models\\Group' END AS "RecordClassName" FROM "SchoolGroup" WHERE ("SchoolGroup"."ID" = ?) LIMIT 1 0.0005s

0128: SELECT DISTINCT "School"."ClassName", "School"."LastEdited", "School"."Created", "School"."Address", "School"."Suburb", "School"."State", "School"."Postcode", "School"."Country", "School"."Title", "School"."Location", "School"."Phone", "School"."Email", "School"."ID", CASE WHEN "School"."ClassName" IS NOT NULL THEN "School"."ClassName" ELSE 'App\\Models\\School' END AS "RecordClassName" FROM "School" WHERE ("School"."ID" = ?) LIMIT 1 0.0006s

0129: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", "SiteTree_Live"."ShowInSitemap", "SiteTree_Live"."AvailableOffline", CASE WHEN "SiteTree_Localised_lv_LV"."ID" IS NOT NULL THEN "SiteTree_Localised_lv_LV"."ExtraCode" WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."ExtraCode" ELSE "SiteTree_Live"."ExtraCode" END AS "ExtraCode", "SiteTree_Live"."CanViewType", "SiteTree_Live"."CanEditType", "SiteTree_Live"."Version", CASE WHEN "SiteTree_Localised_lv_LV"."ID" IS NOT NULL THEN "SiteTree_Localised_lv_LV"."URLSegment" 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_lv_LV"."ID" IS NOT NULL THEN "SiteTree_Localised_lv_LV"."Title" 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_lv_LV"."ID" IS NOT NULL THEN "SiteTree_Localised_lv_LV"."MenuTitle" 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_lv_LV"."ID" IS NOT NULL THEN "SiteTree_Localised_lv_LV"."Content" 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_lv_LV"."ID" IS NOT NULL THEN "SiteTree_Localised_lv_LV"."MetaDescription" 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_lv_LV"."ID" IS NOT NULL THEN "SiteTree_Localised_lv_LV"."ReportClass" WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."ReportClass" ELSE "SiteTree_Live"."ReportClass" END AS "ReportClass", "SiteTree_Live"."ParentID", "Page_Live"."InheritSideBar", "Page_Live"."BlockIcon", "Page_Live"."SideBarID", "Page_Live"."ElementalAreaID", "SiteTree_Live"."ID", CASE WHEN "SiteTree_Live"."ClassName" IS NOT NULL THEN "SiteTree_Live"."ClassName" ELSE 'SilverStripe\\CMS\\Model\\SiteTree' END AS "RecordClassName", 'lv_LV' AS "Locale", CASE WHEN "SiteTree_Localised_lv_LV"."ID" IS NOT NULL THEN 'lv_LV' WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN 'en_US' ELSE NULL END AS "SourceLocale" FROM "SiteTree_Live" LEFT JOIN "Page_Live" ON "Page_Live"."ID" = "SiteTree_Live"."ID" LEFT JOIN "SiteTree_Localised_Live" AS "SiteTree_Localised_lv_LV" ON "SiteTree_Live"."ID" = "SiteTree_Localised_lv_LV"."RecordID" AND "SiteTree_Localised_lv_LV"."Locale" = ? 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"."ClassName" = ?) AND ("SiteTree_Live"."ClassName" IN (?, ?, ?, ?)) AND (("SiteTree_Localised_lv_LV"."ID" IS NOT NULL)) ORDER BY "SiteTree_Live"."ParentID" ASC, "SiteTree_Live"."Sort" ASC LIMIT 1 0.0016s

0130: SELECT DISTINCT "File_Live"."ClassName", "File_Live"."LastEdited", "File_Live"."Created", "File_Live"."UserFormUpload", "File_Live"."IsTemporary", "File_Live"."Version", "File_Live"."CanViewType", "File_Live"."CanEditType", "File_Live"."Name", "File_Live"."Title", "File_Live"."ShowInSearch", "File_Live"."ParentID", "File_Live"."OwnerID", "File_Live"."FileHash", "File_Live"."FileFilename", "File_Live"."FileVariant", "File_Live"."ObjectID", "File_Live"."ObjectClass", "Image_Live"."FocusPointX", "Image_Live"."FocusPointY", "Image_Live"."FocusPointWidth", "Image_Live"."FocusPointHeight", "File_Live"."ID", CASE WHEN "File_Live"."ClassName" IS NOT NULL THEN "File_Live"."ClassName" ELSE 'SilverStripe\\Assets\\File' END AS "RecordClassName" FROM "File_Live" LEFT JOIN "Image_Live" ON "Image_Live"."ID" = "File_Live"."ID" WHERE ("File_Live"."ID" = ?) AND ("File_Live"."ClassName" IN (?)) ORDER BY "File_Live"."Name" ASC LIMIT 1 0.0006s

0131: SELECT DISTINCT count(DISTINCT "DrawingVotes"."ID") AS "Count" FROM "DrawingVotes" WHERE ("DrawingVotes"."DrawingID" = ?) 0.0006s

0132: SELECT DISTINCT "DrawingVotes"."ClassName", "DrawingVotes"."LastEdited", "DrawingVotes"."Created", "DrawingVotes"."Grade", "DrawingVotes"."Times", "DrawingVotes"."OwnerID", "DrawingVotes"."DrawingID", "DrawingVotes"."ID", CASE WHEN "DrawingVotes"."ClassName" IS NOT NULL THEN "DrawingVotes"."ClassName" ELSE 'App\\Models\\Vote' END AS "RecordClassName" FROM "DrawingVotes" WHERE ("DrawingVotes"."DrawingID" = ?) ORDER BY "DrawingVotes"."Created" DESC 0.0007s

0133: SELECT DISTINCT "SchoolGroup"."ClassName", "SchoolGroup"."LastEdited", "SchoolGroup"."Created", "SchoolGroup"."Title", "SchoolGroup"."Comment", "SchoolGroup"."ParentID", "SchoolGroup"."MemberID", "SchoolGroup"."ID", CASE WHEN "SchoolGroup"."ClassName" IS NOT NULL THEN "SchoolGroup"."ClassName" ELSE 'App\\Models\\Group' END AS "RecordClassName" FROM "SchoolGroup" WHERE ("SchoolGroup"."ID" = ?) LIMIT 1 0.0005s

0134: SELECT DISTINCT "School"."ClassName", "School"."LastEdited", "School"."Created", "School"."Address", "School"."Suburb", "School"."State", "School"."Postcode", "School"."Country", "School"."Title", "School"."Location", "School"."Phone", "School"."Email", "School"."ID", CASE WHEN "School"."ClassName" IS NOT NULL THEN "School"."ClassName" ELSE 'App\\Models\\School' END AS "RecordClassName" FROM "School" WHERE ("School"."ID" = ?) LIMIT 1 0.0005s

0135: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", "SiteTree_Live"."ShowInSitemap", "SiteTree_Live"."AvailableOffline", CASE WHEN "SiteTree_Localised_lv_LV"."ID" IS NOT NULL THEN "SiteTree_Localised_lv_LV"."ExtraCode" WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."ExtraCode" ELSE "SiteTree_Live"."ExtraCode" END AS "ExtraCode", "SiteTree_Live"."CanViewType", "SiteTree_Live"."CanEditType", "SiteTree_Live"."Version", CASE WHEN "SiteTree_Localised_lv_LV"."ID" IS NOT NULL THEN "SiteTree_Localised_lv_LV"."URLSegment" 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_lv_LV"."ID" IS NOT NULL THEN "SiteTree_Localised_lv_LV"."Title" 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_lv_LV"."ID" IS NOT NULL THEN "SiteTree_Localised_lv_LV"."MenuTitle" 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_lv_LV"."ID" IS NOT NULL THEN "SiteTree_Localised_lv_LV"."Content" 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_lv_LV"."ID" IS NOT NULL THEN "SiteTree_Localised_lv_LV"."MetaDescription" 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_lv_LV"."ID" IS NOT NULL THEN "SiteTree_Localised_lv_LV"."ReportClass" WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."ReportClass" ELSE "SiteTree_Live"."ReportClass" END AS "ReportClass", "SiteTree_Live"."ParentID", "Page_Live"."InheritSideBar", "Page_Live"."BlockIcon", "Page_Live"."SideBarID", "Page_Live"."ElementalAreaID", "SiteTree_Live"."ID", CASE WHEN "SiteTree_Live"."ClassName" IS NOT NULL THEN "SiteTree_Live"."ClassName" ELSE 'SilverStripe\\CMS\\Model\\SiteTree' END AS "RecordClassName", 'lv_LV' AS "Locale", CASE WHEN "SiteTree_Localised_lv_LV"."ID" IS NOT NULL THEN 'lv_LV' WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN 'en_US' ELSE NULL END AS "SourceLocale" FROM "SiteTree_Live" LEFT JOIN "Page_Live" ON "Page_Live"."ID" = "SiteTree_Live"."ID" LEFT JOIN "SiteTree_Localised_Live" AS "SiteTree_Localised_lv_LV" ON "SiteTree_Live"."ID" = "SiteTree_Localised_lv_LV"."RecordID" AND "SiteTree_Localised_lv_LV"."Locale" = ? 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"."ClassName" = ?) AND ("SiteTree_Live"."ClassName" IN (?, ?, ?, ?)) AND (("SiteTree_Localised_lv_LV"."ID" IS NOT NULL)) ORDER BY "SiteTree_Live"."ParentID" ASC, "SiteTree_Live"."Sort" ASC LIMIT 1 0.0016s

0136: SELECT DISTINCT "File_Live"."ClassName", "File_Live"."LastEdited", "File_Live"."Created", "File_Live"."UserFormUpload", "File_Live"."IsTemporary", "File_Live"."Version", "File_Live"."CanViewType", "File_Live"."CanEditType", "File_Live"."Name", "File_Live"."Title", "File_Live"."ShowInSearch", "File_Live"."ParentID", "File_Live"."OwnerID", "File_Live"."FileHash", "File_Live"."FileFilename", "File_Live"."FileVariant", "File_Live"."ObjectID", "File_Live"."ObjectClass", "Image_Live"."FocusPointX", "Image_Live"."FocusPointY", "Image_Live"."FocusPointWidth", "Image_Live"."FocusPointHeight", "File_Live"."ID", CASE WHEN "File_Live"."ClassName" IS NOT NULL THEN "File_Live"."ClassName" ELSE 'SilverStripe\\Assets\\File' END AS "RecordClassName" FROM "File_Live" LEFT JOIN "Image_Live" ON "Image_Live"."ID" = "File_Live"."ID" WHERE ("File_Live"."ID" = ?) AND ("File_Live"."ClassName" IN (?)) ORDER BY "File_Live"."Name" ASC LIMIT 1 0.0007s

0137: SELECT DISTINCT count(DISTINCT "DrawingVotes"."ID") AS "Count" FROM "DrawingVotes" WHERE ("DrawingVotes"."DrawingID" = ?) 0.0005s

0138: SELECT DISTINCT "SchoolGroup"."ClassName", "SchoolGroup"."LastEdited", "SchoolGroup"."Created", "SchoolGroup"."Title", "SchoolGroup"."Comment", "SchoolGroup"."ParentID", "SchoolGroup"."MemberID", "SchoolGroup"."ID", CASE WHEN "SchoolGroup"."ClassName" IS NOT NULL THEN "SchoolGroup"."ClassName" ELSE 'App\\Models\\Group' END AS "RecordClassName" FROM "SchoolGroup" WHERE ("SchoolGroup"."ID" = ?) LIMIT 1 0.0005s

0139: SELECT DISTINCT "School"."ClassName", "School"."LastEdited", "School"."Created", "School"."Address", "School"."Suburb", "School"."State", "School"."Postcode", "School"."Country", "School"."Title", "School"."Location", "School"."Phone", "School"."Email", "School"."ID", CASE WHEN "School"."ClassName" IS NOT NULL THEN "School"."ClassName" ELSE 'App\\Models\\School' END AS "RecordClassName" FROM "School" WHERE ("School"."ID" = ?) LIMIT 1 0.0005s

0140: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", "SiteTree_Live"."ShowInSitemap", "SiteTree_Live"."AvailableOffline", CASE WHEN "SiteTree_Localised_lv_LV"."ID" IS NOT NULL THEN "SiteTree_Localised_lv_LV"."ExtraCode" WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."ExtraCode" ELSE "SiteTree_Live"."ExtraCode" END AS "ExtraCode", "SiteTree_Live"."CanViewType", "SiteTree_Live"."CanEditType", "SiteTree_Live"."Version", CASE WHEN "SiteTree_Localised_lv_LV"."ID" IS NOT NULL THEN "SiteTree_Localised_lv_LV"."URLSegment" 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_lv_LV"."ID" IS NOT NULL THEN "SiteTree_Localised_lv_LV"."Title" 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_lv_LV"."ID" IS NOT NULL THEN "SiteTree_Localised_lv_LV"."MenuTitle" 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_lv_LV"."ID" IS NOT NULL THEN "SiteTree_Localised_lv_LV"."Content" 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_lv_LV"."ID" IS NOT NULL THEN "SiteTree_Localised_lv_LV"."MetaDescription" 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_lv_LV"."ID" IS NOT NULL THEN "SiteTree_Localised_lv_LV"."ReportClass" WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."ReportClass" ELSE "SiteTree_Live"."ReportClass" END AS "ReportClass", "SiteTree_Live"."ParentID", "Page_Live"."InheritSideBar", "Page_Live"."BlockIcon", "Page_Live"."SideBarID", "Page_Live"."ElementalAreaID", "SiteTree_Live"."ID", CASE WHEN "SiteTree_Live"."ClassName" IS NOT NULL THEN "SiteTree_Live"."ClassName" ELSE 'SilverStripe\\CMS\\Model\\SiteTree' END AS "RecordClassName", 'lv_LV' AS "Locale", CASE WHEN "SiteTree_Localised_lv_LV"."ID" IS NOT NULL THEN 'lv_LV' WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN 'en_US' ELSE NULL END AS "SourceLocale" FROM "SiteTree_Live" LEFT JOIN "Page_Live" ON "Page_Live"."ID" = "SiteTree_Live"."ID" LEFT JOIN "SiteTree_Localised_Live" AS "SiteTree_Localised_lv_LV" ON "SiteTree_Live"."ID" = "SiteTree_Localised_lv_LV"."RecordID" AND "SiteTree_Localised_lv_LV"."Locale" = ? 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"."ClassName" = ?) AND ("SiteTree_Live"."ClassName" IN (?, ?, ?, ?)) AND (("SiteTree_Localised_lv_LV"."ID" IS NOT NULL)) ORDER BY "SiteTree_Live"."ParentID" ASC, "SiteTree_Live"."Sort" ASC LIMIT 1 0.0016s

0141: SELECT DISTINCT "File_Live"."ClassName", "File_Live"."LastEdited", "File_Live"."Created", "File_Live"."UserFormUpload", "File_Live"."IsTemporary", "File_Live"."Version", "File_Live"."CanViewType", "File_Live"."CanEditType", "File_Live"."Name", "File_Live"."Title", "File_Live"."ShowInSearch", "File_Live"."ParentID", "File_Live"."OwnerID", "File_Live"."FileHash", "File_Live"."FileFilename", "File_Live"."FileVariant", "File_Live"."ObjectID", "File_Live"."ObjectClass", "Image_Live"."FocusPointX", "Image_Live"."FocusPointY", "Image_Live"."FocusPointWidth", "Image_Live"."FocusPointHeight", "File_Live"."ID", CASE WHEN "File_Live"."ClassName" IS NOT NULL THEN "File_Live"."ClassName" ELSE 'SilverStripe\\Assets\\File' END AS "RecordClassName" FROM "File_Live" LEFT JOIN "Image_Live" ON "Image_Live"."ID" = "File_Live"."ID" WHERE ("File_Live"."ID" = ?) AND ("File_Live"."ClassName" IN (?)) ORDER BY "File_Live"."Name" ASC LIMIT 1 0.0006s

0142: SELECT DISTINCT count(DISTINCT "DrawingVotes"."ID") AS "Count" FROM "DrawingVotes" WHERE ("DrawingVotes"."DrawingID" = ?) 0.0006s

0143: SELECT DISTINCT "DrawingVotes"."ClassName", "DrawingVotes"."LastEdited", "DrawingVotes"."Created", "DrawingVotes"."Grade", "DrawingVotes"."Times", "DrawingVotes"."OwnerID", "DrawingVotes"."DrawingID", "DrawingVotes"."ID", CASE WHEN "DrawingVotes"."ClassName" IS NOT NULL THEN "DrawingVotes"."ClassName" ELSE 'App\\Models\\Vote' END AS "RecordClassName" FROM "DrawingVotes" WHERE ("DrawingVotes"."DrawingID" = ?) ORDER BY "DrawingVotes"."Created" DESC 0.0006s

0144: SELECT DISTINCT "SchoolGroup"."ClassName", "SchoolGroup"."LastEdited", "SchoolGroup"."Created", "SchoolGroup"."Title", "SchoolGroup"."Comment", "SchoolGroup"."ParentID", "SchoolGroup"."MemberID", "SchoolGroup"."ID", CASE WHEN "SchoolGroup"."ClassName" IS NOT NULL THEN "SchoolGroup"."ClassName" ELSE 'App\\Models\\Group' END AS "RecordClassName" FROM "SchoolGroup" WHERE ("SchoolGroup"."ID" = ?) LIMIT 1 0.0005s

0145: SELECT DISTINCT "School"."ClassName", "School"."LastEdited", "School"."Created", "School"."Address", "School"."Suburb", "School"."State", "School"."Postcode", "School"."Country", "School"."Title", "School"."Location", "School"."Phone", "School"."Email", "School"."ID", CASE WHEN "School"."ClassName" IS NOT NULL THEN "School"."ClassName" ELSE 'App\\Models\\School' END AS "RecordClassName" FROM "School" WHERE ("School"."ID" = ?) LIMIT 1 0.0005s

0146: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", "SiteTree_Live"."ShowInSitemap", "SiteTree_Live"."AvailableOffline", CASE WHEN "SiteTree_Localised_lv_LV"."ID" IS NOT NULL THEN "SiteTree_Localised_lv_LV"."ExtraCode" WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."ExtraCode" ELSE "SiteTree_Live"."ExtraCode" END AS "ExtraCode", "SiteTree_Live"."CanViewType", "SiteTree_Live"."CanEditType", "SiteTree_Live"."Version", CASE WHEN "SiteTree_Localised_lv_LV"."ID" IS NOT NULL THEN "SiteTree_Localised_lv_LV"."URLSegment" 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_lv_LV"."ID" IS NOT NULL THEN "SiteTree_Localised_lv_LV"."Title" 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_lv_LV"."ID" IS NOT NULL THEN "SiteTree_Localised_lv_LV"."MenuTitle" 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_lv_LV"."ID" IS NOT NULL THEN "SiteTree_Localised_lv_LV"."Content" 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_lv_LV"."ID" IS NOT NULL THEN "SiteTree_Localised_lv_LV"."MetaDescription" 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_lv_LV"."ID" IS NOT NULL THEN "SiteTree_Localised_lv_LV"."ReportClass" WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."ReportClass" ELSE "SiteTree_Live"."ReportClass" END AS "ReportClass", "SiteTree_Live"."ParentID", "Page_Live"."InheritSideBar", "Page_Live"."BlockIcon", "Page_Live"."SideBarID", "Page_Live"."ElementalAreaID", "SiteTree_Live"."ID", CASE WHEN "SiteTree_Live"."ClassName" IS NOT NULL THEN "SiteTree_Live"."ClassName" ELSE 'SilverStripe\\CMS\\Model\\SiteTree' END AS "RecordClassName", 'lv_LV' AS "Locale", CASE WHEN "SiteTree_Localised_lv_LV"."ID" IS NOT NULL THEN 'lv_LV' WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN 'en_US' ELSE NULL END AS "SourceLocale" FROM "SiteTree_Live" LEFT JOIN "Page_Live" ON "Page_Live"."ID" = "SiteTree_Live"."ID" LEFT JOIN "SiteTree_Localised_Live" AS "SiteTree_Localised_lv_LV" ON "SiteTree_Live"."ID" = "SiteTree_Localised_lv_LV"."RecordID" AND "SiteTree_Localised_lv_LV"."Locale" = ? 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"."ClassName" = ?) AND ("SiteTree_Live"."ClassName" IN (?, ?, ?, ?)) AND (("SiteTree_Localised_lv_LV"."ID" IS NOT NULL)) ORDER BY "SiteTree_Live"."ParentID" ASC, "SiteTree_Live"."Sort" ASC LIMIT 1 0.0015s

0147: SELECT DISTINCT "File_Live"."ClassName", "File_Live"."LastEdited", "File_Live"."Created", "File_Live"."UserFormUpload", "File_Live"."IsTemporary", "File_Live"."Version", "File_Live"."CanViewType", "File_Live"."CanEditType", "File_Live"."Name", "File_Live"."Title", "File_Live"."ShowInSearch", "File_Live"."ParentID", "File_Live"."OwnerID", "File_Live"."FileHash", "File_Live"."FileFilename", "File_Live"."FileVariant", "File_Live"."ObjectID", "File_Live"."ObjectClass", "Image_Live"."FocusPointX", "Image_Live"."FocusPointY", "Image_Live"."FocusPointWidth", "Image_Live"."FocusPointHeight", "File_Live"."ID", CASE WHEN "File_Live"."ClassName" IS NOT NULL THEN "File_Live"."ClassName" ELSE 'SilverStripe\\Assets\\File' END AS "RecordClassName" FROM "File_Live" LEFT JOIN "Image_Live" ON "Image_Live"."ID" = "File_Live"."ID" WHERE ("File_Live"."ID" = ?) AND ("File_Live"."ClassName" IN (?)) ORDER BY "File_Live"."Name" ASC LIMIT 1 0.0007s

0148: SELECT DISTINCT count(DISTINCT "DrawingVotes"."ID") AS "Count" FROM "DrawingVotes" WHERE ("DrawingVotes"."DrawingID" = ?) 0.0005s

0149: SELECT DISTINCT "DrawingVotes"."ClassName", "DrawingVotes"."LastEdited", "DrawingVotes"."Created", "DrawingVotes"."Grade", "DrawingVotes"."Times", "DrawingVotes"."OwnerID", "DrawingVotes"."DrawingID", "DrawingVotes"."ID", CASE WHEN "DrawingVotes"."ClassName" IS NOT NULL THEN "DrawingVotes"."ClassName" ELSE 'App\\Models\\Vote' END AS "RecordClassName" FROM "DrawingVotes" WHERE ("DrawingVotes"."DrawingID" = ?) ORDER BY "DrawingVotes"."Created" DESC 0.0007s

0150: SELECT DISTINCT "SchoolGroup"."ClassName", "SchoolGroup"."LastEdited", "SchoolGroup"."Created", "SchoolGroup"."Title", "SchoolGroup"."Comment", "SchoolGroup"."ParentID", "SchoolGroup"."MemberID", "SchoolGroup"."ID", CASE WHEN "SchoolGroup"."ClassName" IS NOT NULL THEN "SchoolGroup"."ClassName" ELSE 'App\\Models\\Group' END AS "RecordClassName" FROM "SchoolGroup" WHERE ("SchoolGroup"."ID" = ?) LIMIT 1 0.0005s

0151: SELECT DISTINCT "School"."ClassName", "School"."LastEdited", "School"."Created", "School"."Address", "School"."Suburb", "School"."State", "School"."Postcode", "School"."Country", "School"."Title", "School"."Location", "School"."Phone", "School"."Email", "School"."ID", CASE WHEN "School"."ClassName" IS NOT NULL THEN "School"."ClassName" ELSE 'App\\Models\\School' END AS "RecordClassName" FROM "School" WHERE ("School"."ID" = ?) LIMIT 1 0.0006s

0152: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", "SiteTree_Live"."ShowInSitemap", "SiteTree_Live"."AvailableOffline", CASE WHEN "SiteTree_Localised_lv_LV"."ID" IS NOT NULL THEN "SiteTree_Localised_lv_LV"."ExtraCode" WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."ExtraCode" ELSE "SiteTree_Live"."ExtraCode" END AS "ExtraCode", "SiteTree_Live"."CanViewType", "SiteTree_Live"."CanEditType", "SiteTree_Live"."Version", CASE WHEN "SiteTree_Localised_lv_LV"."ID" IS NOT NULL THEN "SiteTree_Localised_lv_LV"."URLSegment" 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_lv_LV"."ID" IS NOT NULL THEN "SiteTree_Localised_lv_LV"."Title" 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_lv_LV"."ID" IS NOT NULL THEN "SiteTree_Localised_lv_LV"."MenuTitle" 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_lv_LV"."ID" IS NOT NULL THEN "SiteTree_Localised_lv_LV"."Content" 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_lv_LV"."ID" IS NOT NULL THEN "SiteTree_Localised_lv_LV"."MetaDescription" 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_lv_LV"."ID" IS NOT NULL THEN "SiteTree_Localised_lv_LV"."ReportClass" WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."ReportClass" ELSE "SiteTree_Live"."ReportClass" END AS "ReportClass", "SiteTree_Live"."ParentID", "Page_Live"."InheritSideBar", "Page_Live"."BlockIcon", "Page_Live"."SideBarID", "Page_Live"."ElementalAreaID", "SiteTree_Live"."ID", CASE WHEN "SiteTree_Live"."ClassName" IS NOT NULL THEN "SiteTree_Live"."ClassName" ELSE 'SilverStripe\\CMS\\Model\\SiteTree' END AS "RecordClassName", 'lv_LV' AS "Locale", CASE WHEN "SiteTree_Localised_lv_LV"."ID" IS NOT NULL THEN 'lv_LV' WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN 'en_US' ELSE NULL END AS "SourceLocale" FROM "SiteTree_Live" LEFT JOIN "Page_Live" ON "Page_Live"."ID" = "SiteTree_Live"."ID" LEFT JOIN "SiteTree_Localised_Live" AS "SiteTree_Localised_lv_LV" ON "SiteTree_Live"."ID" = "SiteTree_Localised_lv_LV"."RecordID" AND "SiteTree_Localised_lv_LV"."Locale" = ? 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"."ClassName" = ?) AND ("SiteTree_Live"."ClassName" IN (?, ?, ?, ?)) AND (("SiteTree_Localised_lv_LV"."ID" IS NOT NULL)) ORDER BY "SiteTree_Live"."ParentID" ASC, "SiteTree_Live"."Sort" ASC LIMIT 1 0.002s

0153: SELECT DISTINCT "File_Live"."ClassName", "File_Live"."LastEdited", "File_Live"."Created", "File_Live"."UserFormUpload", "File_Live"."IsTemporary", "File_Live"."Version", "File_Live"."CanViewType", "File_Live"."CanEditType", "File_Live"."Name", "File_Live"."Title", "File_Live"."ShowInSearch", "File_Live"."ParentID", "File_Live"."OwnerID", "File_Live"."FileHash", "File_Live"."FileFilename", "File_Live"."FileVariant", "File_Live"."ObjectID", "File_Live"."ObjectClass", "Image_Live"."FocusPointX", "Image_Live"."FocusPointY", "Image_Live"."FocusPointWidth", "Image_Live"."FocusPointHeight", "File_Live"."ID", CASE WHEN "File_Live"."ClassName" IS NOT NULL THEN "File_Live"."ClassName" ELSE 'SilverStripe\\Assets\\File' END AS "RecordClassName" FROM "File_Live" LEFT JOIN "Image_Live" ON "Image_Live"."ID" = "File_Live"."ID" WHERE ("File_Live"."ID" = ?) AND ("File_Live"."ClassName" IN (?)) ORDER BY "File_Live"."Name" ASC LIMIT 1 0.0007s

0154: SELECT DISTINCT count(DISTINCT "DrawingVotes"."ID") AS "Count" FROM "DrawingVotes" WHERE ("DrawingVotes"."DrawingID" = ?) 0.0005s

0155: SELECT DISTINCT "SchoolGroup"."ClassName", "SchoolGroup"."LastEdited", "SchoolGroup"."Created", "SchoolGroup"."Title", "SchoolGroup"."Comment", "SchoolGroup"."ParentID", "SchoolGroup"."MemberID", "SchoolGroup"."ID", CASE WHEN "SchoolGroup"."ClassName" IS NOT NULL THEN "SchoolGroup"."ClassName" ELSE 'App\\Models\\Group' END AS "RecordClassName" FROM "SchoolGroup" WHERE ("SchoolGroup"."ID" = ?) LIMIT 1 0.0004s

0156: SELECT DISTINCT "School"."ClassName", "School"."LastEdited", "School"."Created", "School"."Address", "School"."Suburb", "School"."State", "School"."Postcode", "School"."Country", "School"."Title", "School"."Location", "School"."Phone", "School"."Email", "School"."ID", CASE WHEN "School"."ClassName" IS NOT NULL THEN "School"."ClassName" ELSE 'App\\Models\\School' END AS "RecordClassName" FROM "School" WHERE ("School"."ID" = ?) LIMIT 1 0.0005s

0157: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", "SiteTree_Live"."ShowInSitemap", "SiteTree_Live"."AvailableOffline", CASE WHEN "SiteTree_Localised_lv_LV"."ID" IS NOT NULL THEN "SiteTree_Localised_lv_LV"."ExtraCode" WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."ExtraCode" ELSE "SiteTree_Live"."ExtraCode" END AS "ExtraCode", "SiteTree_Live"."CanViewType", "SiteTree_Live"."CanEditType", "SiteTree_Live"."Version", CASE WHEN "SiteTree_Localised_lv_LV"."ID" IS NOT NULL THEN "SiteTree_Localised_lv_LV"."URLSegment" 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_lv_LV"."ID" IS NOT NULL THEN "SiteTree_Localised_lv_LV"."Title" 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_lv_LV"."ID" IS NOT NULL THEN "SiteTree_Localised_lv_LV"."MenuTitle" 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_lv_LV"."ID" IS NOT NULL THEN "SiteTree_Localised_lv_LV"."Content" 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_lv_LV"."ID" IS NOT NULL THEN "SiteTree_Localised_lv_LV"."MetaDescription" 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_lv_LV"."ID" IS NOT NULL THEN "SiteTree_Localised_lv_LV"."ReportClass" WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."ReportClass" ELSE "SiteTree_Live"."ReportClass" END AS "ReportClass", "SiteTree_Live"."ParentID", "Page_Live"."InheritSideBar", "Page_Live"."BlockIcon", "Page_Live"."SideBarID", "Page_Live"."ElementalAreaID", "SiteTree_Live"."ID", CASE WHEN "SiteTree_Live"."ClassName" IS NOT NULL THEN "SiteTree_Live"."ClassName" ELSE 'SilverStripe\\CMS\\Model\\SiteTree' END AS "RecordClassName", 'lv_LV' AS "Locale", CASE WHEN "SiteTree_Localised_lv_LV"."ID" IS NOT NULL THEN 'lv_LV' WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN 'en_US' ELSE NULL END AS "SourceLocale" FROM "SiteTree_Live" LEFT JOIN "Page_Live" ON "Page_Live"."ID" = "SiteTree_Live"."ID" LEFT JOIN "SiteTree_Localised_Live" AS "SiteTree_Localised_lv_LV" ON "SiteTree_Live"."ID" = "SiteTree_Localised_lv_LV"."RecordID" AND "SiteTree_Localised_lv_LV"."Locale" = ? 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"."ClassName" = ?) AND ("SiteTree_Live"."ClassName" IN (?, ?, ?, ?)) AND (("SiteTree_Localised_lv_LV"."ID" IS NOT NULL)) ORDER BY "SiteTree_Live"."ParentID" ASC, "SiteTree_Live"."Sort" ASC LIMIT 1 0.0017s

0158: SELECT DISTINCT "File_Live"."ClassName", "File_Live"."LastEdited", "File_Live"."Created", "File_Live"."UserFormUpload", "File_Live"."IsTemporary", "File_Live"."Version", "File_Live"."CanViewType", "File_Live"."CanEditType", "File_Live"."Name", "File_Live"."Title", "File_Live"."ShowInSearch", "File_Live"."ParentID", "File_Live"."OwnerID", "File_Live"."FileHash", "File_Live"."FileFilename", "File_Live"."FileVariant", "File_Live"."ObjectID", "File_Live"."ObjectClass", "Image_Live"."FocusPointX", "Image_Live"."FocusPointY", "Image_Live"."FocusPointWidth", "Image_Live"."FocusPointHeight", "File_Live"."ID", CASE WHEN "File_Live"."ClassName" IS NOT NULL THEN "File_Live"."ClassName" ELSE 'SilverStripe\\Assets\\File' END AS "RecordClassName" FROM "File_Live" LEFT JOIN "Image_Live" ON "Image_Live"."ID" = "File_Live"."ID" WHERE ("File_Live"."ID" = ?) AND ("File_Live"."ClassName" IN (?)) ORDER BY "File_Live"."Name" ASC LIMIT 1 0.0006s

0159: SELECT DISTINCT count(DISTINCT "DrawingVotes"."ID") AS "Count" FROM "DrawingVotes" WHERE ("DrawingVotes"."DrawingID" = ?) 0.0005s

0160: SELECT DISTINCT "SchoolGroup"."ClassName", "SchoolGroup"."LastEdited", "SchoolGroup"."Created", "SchoolGroup"."Title", "SchoolGroup"."Comment", "SchoolGroup"."ParentID", "SchoolGroup"."MemberID", "SchoolGroup"."ID", CASE WHEN "SchoolGroup"."ClassName" IS NOT NULL THEN "SchoolGroup"."ClassName" ELSE 'App\\Models\\Group' END AS "RecordClassName" FROM "SchoolGroup" WHERE ("SchoolGroup"."ID" = ?) LIMIT 1 0.0004s

0161: SELECT DISTINCT "School"."ClassName", "School"."LastEdited", "School"."Created", "School"."Address", "School"."Suburb", "School"."State", "School"."Postcode", "School"."Country", "School"."Title", "School"."Location", "School"."Phone", "School"."Email", "School"."ID", CASE WHEN "School"."ClassName" IS NOT NULL THEN "School"."ClassName" ELSE 'App\\Models\\School' END AS "RecordClassName" FROM "School" WHERE ("School"."ID" = ?) LIMIT 1 0.0004s

0162: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", "SiteTree_Live"."ShowInSitemap", "SiteTree_Live"."AvailableOffline", CASE WHEN "SiteTree_Localised_lv_LV"."ID" IS NOT NULL THEN "SiteTree_Localised_lv_LV"."ExtraCode" WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."ExtraCode" ELSE "SiteTree_Live"."ExtraCode" END AS "ExtraCode", "SiteTree_Live"."CanViewType", "SiteTree_Live"."CanEditType", "SiteTree_Live"."Version", CASE WHEN "SiteTree_Localised_lv_LV"."ID" IS NOT NULL THEN "SiteTree_Localised_lv_LV"."URLSegment" 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_lv_LV"."ID" IS NOT NULL THEN "SiteTree_Localised_lv_LV"."Title" 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_lv_LV"."ID" IS NOT NULL THEN "SiteTree_Localised_lv_LV"."MenuTitle" 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_lv_LV"."ID" IS NOT NULL THEN "SiteTree_Localised_lv_LV"."Content" 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_lv_LV"."ID" IS NOT NULL THEN "SiteTree_Localised_lv_LV"."MetaDescription" 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_lv_LV"."ID" IS NOT NULL THEN "SiteTree_Localised_lv_LV"."ReportClass" WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."ReportClass" ELSE "SiteTree_Live"."ReportClass" END AS "ReportClass", "SiteTree_Live"."ParentID", "Page_Live"."InheritSideBar", "Page_Live"."BlockIcon", "Page_Live"."SideBarID", "Page_Live"."ElementalAreaID", "SiteTree_Live"."ID", CASE WHEN "SiteTree_Live"."ClassName" IS NOT NULL THEN "SiteTree_Live"."ClassName" ELSE 'SilverStripe\\CMS\\Model\\SiteTree' END AS "RecordClassName", 'lv_LV' AS "Locale", CASE WHEN "SiteTree_Localised_lv_LV"."ID" IS NOT NULL THEN 'lv_LV' WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN 'en_US' ELSE NULL END AS "SourceLocale" FROM "SiteTree_Live" LEFT JOIN "Page_Live" ON "Page_Live"."ID" = "SiteTree_Live"."ID" LEFT JOIN "SiteTree_Localised_Live" AS "SiteTree_Localised_lv_LV" ON "SiteTree_Live"."ID" = "SiteTree_Localised_lv_LV"."RecordID" AND "SiteTree_Localised_lv_LV"."Locale" = ? 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"."ClassName" = ?) AND ("SiteTree_Live"."ClassName" IN (?, ?, ?, ?)) AND (("SiteTree_Localised_lv_LV"."ID" IS NOT NULL)) ORDER BY "SiteTree_Live"."ParentID" ASC, "SiteTree_Live"."Sort" ASC LIMIT 1 0.0018s

0163: SELECT DISTINCT "File_Live"."ClassName", "File_Live"."LastEdited", "File_Live"."Created", "File_Live"."UserFormUpload", "File_Live"."IsTemporary", "File_Live"."Version", "File_Live"."CanViewType", "File_Live"."CanEditType", "File_Live"."Name", "File_Live"."Title", "File_Live"."ShowInSearch", "File_Live"."ParentID", "File_Live"."OwnerID", "File_Live"."FileHash", "File_Live"."FileFilename", "File_Live"."FileVariant", "File_Live"."ObjectID", "File_Live"."ObjectClass", "Image_Live"."FocusPointX", "Image_Live"."FocusPointY", "Image_Live"."FocusPointWidth", "Image_Live"."FocusPointHeight", "File_Live"."ID", CASE WHEN "File_Live"."ClassName" IS NOT NULL THEN "File_Live"."ClassName" ELSE 'SilverStripe\\Assets\\File' END AS "RecordClassName" FROM "File_Live" LEFT JOIN "Image_Live" ON "Image_Live"."ID" = "File_Live"."ID" WHERE ("File_Live"."ID" = ?) AND ("File_Live"."ClassName" IN (?)) ORDER BY "File_Live"."Name" ASC LIMIT 1 0.0011s

0164: SELECT DISTINCT count(DISTINCT "DrawingVotes"."ID") AS "Count" FROM "DrawingVotes" WHERE ("DrawingVotes"."DrawingID" = ?) 0.0005s

0165: SELECT DISTINCT "SchoolGroup"."ClassName", "SchoolGroup"."LastEdited", "SchoolGroup"."Created", "SchoolGroup"."Title", "SchoolGroup"."Comment", "SchoolGroup"."ParentID", "SchoolGroup"."MemberID", "SchoolGroup"."ID", CASE WHEN "SchoolGroup"."ClassName" IS NOT NULL THEN "SchoolGroup"."ClassName" ELSE 'App\\Models\\Group' END AS "RecordClassName" FROM "SchoolGroup" WHERE ("SchoolGroup"."ID" = ?) LIMIT 1 0.0004s

0166: SELECT DISTINCT "School"."ClassName", "School"."LastEdited", "School"."Created", "School"."Address", "School"."Suburb", "School"."State", "School"."Postcode", "School"."Country", "School"."Title", "School"."Location", "School"."Phone", "School"."Email", "School"."ID", CASE WHEN "School"."ClassName" IS NOT NULL THEN "School"."ClassName" ELSE 'App\\Models\\School' END AS "RecordClassName" FROM "School" WHERE ("School"."ID" = ?) LIMIT 1 0.0007s

0167: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", "SiteTree_Live"."ShowInSitemap", "SiteTree_Live"."AvailableOffline", CASE WHEN "SiteTree_Localised_lv_LV"."ID" IS NOT NULL THEN "SiteTree_Localised_lv_LV"."ExtraCode" WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."ExtraCode" ELSE "SiteTree_Live"."ExtraCode" END AS "ExtraCode", "SiteTree_Live"."CanViewType", "SiteTree_Live"."CanEditType", "SiteTree_Live"."Version", CASE WHEN "SiteTree_Localised_lv_LV"."ID" IS NOT NULL THEN "SiteTree_Localised_lv_LV"."URLSegment" 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_lv_LV"."ID" IS NOT NULL THEN "SiteTree_Localised_lv_LV"."Title" 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_lv_LV"."ID" IS NOT NULL THEN "SiteTree_Localised_lv_LV"."MenuTitle" 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_lv_LV"."ID" IS NOT NULL THEN "SiteTree_Localised_lv_LV"."Content" 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_lv_LV"."ID" IS NOT NULL THEN "SiteTree_Localised_lv_LV"."MetaDescription" 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_lv_LV"."ID" IS NOT NULL THEN "SiteTree_Localised_lv_LV"."ReportClass" WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."ReportClass" ELSE "SiteTree_Live"."ReportClass" END AS "ReportClass", "SiteTree_Live"."ParentID", "Page_Live"."InheritSideBar", "Page_Live"."BlockIcon", "Page_Live"."SideBarID", "Page_Live"."ElementalAreaID", "SiteTree_Live"."ID", CASE WHEN "SiteTree_Live"."ClassName" IS NOT NULL THEN "SiteTree_Live"."ClassName" ELSE 'SilverStripe\\CMS\\Model\\SiteTree' END AS "RecordClassName", 'lv_LV' AS "Locale", CASE WHEN "SiteTree_Localised_lv_LV"."ID" IS NOT NULL THEN 'lv_LV' WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN 'en_US' ELSE NULL END AS "SourceLocale" FROM "SiteTree_Live" LEFT JOIN "Page_Live" ON "Page_Live"."ID" = "SiteTree_Live"."ID" LEFT JOIN "SiteTree_Localised_Live" AS "SiteTree_Localised_lv_LV" ON "SiteTree_Live"."ID" = "SiteTree_Localised_lv_LV"."RecordID" AND "SiteTree_Localised_lv_LV"."Locale" = ? 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"."ClassName" = ?) AND ("SiteTree_Live"."ClassName" IN (?, ?, ?, ?)) AND (("SiteTree_Localised_lv_LV"."ID" IS NOT NULL)) ORDER BY "SiteTree_Live"."ParentID" ASC, "SiteTree_Live"."Sort" ASC LIMIT 1 0.0016s

0168: SELECT DISTINCT "File_Live"."ClassName", "File_Live"."LastEdited", "File_Live"."Created", "File_Live"."UserFormUpload", "File_Live"."IsTemporary", "File_Live"."Version", "File_Live"."CanViewType", "File_Live"."CanEditType", "File_Live"."Name", "File_Live"."Title", "File_Live"."ShowInSearch", "File_Live"."ParentID", "File_Live"."OwnerID", "File_Live"."FileHash", "File_Live"."FileFilename", "File_Live"."FileVariant", "File_Live"."ObjectID", "File_Live"."ObjectClass", "Image_Live"."FocusPointX", "Image_Live"."FocusPointY", "Image_Live"."FocusPointWidth", "Image_Live"."FocusPointHeight", "File_Live"."ID", CASE WHEN "File_Live"."ClassName" IS NOT NULL THEN "File_Live"."ClassName" ELSE 'SilverStripe\\Assets\\File' END AS "RecordClassName" FROM "File_Live" LEFT JOIN "Image_Live" ON "Image_Live"."ID" = "File_Live"."ID" WHERE ("File_Live"."ID" = ?) AND ("File_Live"."ClassName" IN (?)) ORDER BY "File_Live"."Name" ASC LIMIT 1 0.0006s

0169: SELECT DISTINCT count(DISTINCT "DrawingVotes"."ID") AS "Count" FROM "DrawingVotes" WHERE ("DrawingVotes"."DrawingID" = ?) 0.0005s

0170: SELECT DISTINCT "SchoolGroup"."ClassName", "SchoolGroup"."LastEdited", "SchoolGroup"."Created", "SchoolGroup"."Title", "SchoolGroup"."Comment", "SchoolGroup"."ParentID", "SchoolGroup"."MemberID", "SchoolGroup"."ID", CASE WHEN "SchoolGroup"."ClassName" IS NOT NULL THEN "SchoolGroup"."ClassName" ELSE 'App\\Models\\Group' END AS "RecordClassName" FROM "SchoolGroup" WHERE ("SchoolGroup"."ID" = ?) LIMIT 1 0.0005s

0171: SELECT DISTINCT "School"."ClassName", "School"."LastEdited", "School"."Created", "School"."Address", "School"."Suburb", "School"."State", "School"."Postcode", "School"."Country", "School"."Title", "School"."Location", "School"."Phone", "School"."Email", "School"."ID", CASE WHEN "School"."ClassName" IS NOT NULL THEN "School"."ClassName" ELSE 'App\\Models\\School' END AS "RecordClassName" FROM "School" WHERE ("School"."ID" = ?) LIMIT 1 0.0004s

0172: SELECT DISTINCT count(DISTINCT "Drawings_Live"."ID") AS "Count" FROM "Drawings_Live" WHERE ("Drawings_Live"."Confirmed" = ?) AND ("Drawings_Live"."TypeGroup" = ?) AND ("Drawings_Live"."AuthorAge" > ?) AND ("Drawings_Live"."AuthorAge" < ?) AND (("Drawings_Live"."LockedOutUntil" < ?) OR ("Drawings_Live"."LockedOutUntil" IS NULL)) 0.0025s

0173: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "Page_Live"."InheritSideBar", "Page_Live"."BlockIcon", "Page_Live"."SideBarID", "Page_Live"."ElementalAreaID", "SiteTree_Live"."ID", CASE WHEN "SiteTree_Live"."ClassName" IS NOT NULL THEN "SiteTree_Live"."ClassName" ELSE 'SilverStripe\\CMS\\Model\\SiteTree' END AS "RecordClassName", 'lv_LV' AS "Locale", CASE WHEN "SiteTree_Localised_lv_LV"."ID" IS NOT NULL THEN 'lv_LV' WHEN "SiteTree_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_lv_LV" ON "SiteTree_Live"."ID" = "SiteTree_Localised_lv_LV"."RecordID" AND "SiteTree_Localised_lv_LV"."Locale" = ? 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_Live"."ClassName" IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)) AND (("SiteTree_Localised_lv_LV"."ID" IS NOT NULL)) ORDER BY "SiteTree_Live"."Sort" ASC LIMIT 1 0.0008s

0174: SELECT DISTINCT "WidgetArea_Live"."ClassName", "WidgetArea_Live"."LastEdited", "WidgetArea_Live"."Created", "WidgetArea_Live"."Version", "WidgetArea_Live"."ID", CASE WHEN "WidgetArea_Live"."ClassName" IS NOT NULL THEN "WidgetArea_Live"."ClassName" ELSE 'SilverStripe\\Widgets\\Model\\WidgetArea' END AS "RecordClassName" FROM "WidgetArea_Live" WHERE ("WidgetArea_Live"."ID" = ?) LIMIT 1 0.0004s

0175: SELECT DISTINCT count(DISTINCT "Widget_Live"."ID") AS "Count" FROM "Widget_Live" WHERE ("Widget_Live"."ParentID" = ?) 0.0005s

0176: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", "SiteTree_Live"."ShowInSitemap", "SiteTree_Live"."AvailableOffline", CASE WHEN "SiteTree_Localised_lv_LV"."ID" IS NOT NULL THEN "SiteTree_Localised_lv_LV"."ExtraCode" WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."ExtraCode" ELSE "SiteTree_Live"."ExtraCode" END AS "ExtraCode", "SiteTree_Live"."CanViewType", "SiteTree_Live"."CanEditType", "SiteTree_Live"."Version", CASE WHEN "SiteTree_Localised_lv_LV"."ID" IS NOT NULL THEN "SiteTree_Localised_lv_LV"."URLSegment" 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_lv_LV"."ID" IS NOT NULL THEN "SiteTree_Localised_lv_LV"."Title" 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_lv_LV"."ID" IS NOT NULL THEN "SiteTree_Localised_lv_LV"."MenuTitle" 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_lv_LV"."ID" IS NOT NULL THEN "SiteTree_Localised_lv_LV"."Content" 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_lv_LV"."ID" IS NOT NULL THEN "SiteTree_Localised_lv_LV"."MetaDescription" 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_lv_LV"."ID" IS NOT NULL THEN "SiteTree_Localised_lv_LV"."ReportClass" WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."ReportClass" ELSE "SiteTree_Live"."ReportClass" END AS "ReportClass", "SiteTree_Live"."ParentID", "SiteTree_Live"."ID", CASE WHEN "SiteTree_Live"."ClassName" IS NOT NULL THEN "SiteTree_Live"."ClassName" ELSE 'SilverStripe\\CMS\\Model\\SiteTree' END AS "RecordClassName", 'lv_LV' AS "Locale", CASE WHEN "SiteTree_Localised_lv_LV"."ID" IS NOT NULL THEN 'lv_LV' 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_lv_LV" ON "SiteTree_Live"."ID" = "SiteTree_Localised_lv_LV"."RecordID" AND "SiteTree_Localised_lv_LV"."Locale" = ? 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_lv_LV"."ID" IS NOT NULL)) ORDER BY "SiteTree_Live"."Sort" ASC LIMIT 1 0.0008s

0177: SELECT DISTINCT "File_Live"."ClassName", "File_Live"."LastEdited", "File_Live"."Created", "File_Live"."UserFormUpload", "File_Live"."IsTemporary", "File_Live"."Version", "File_Live"."CanViewType", "File_Live"."CanEditType", "File_Live"."Name", "File_Live"."Title", "File_Live"."ShowInSearch", "File_Live"."ParentID", "File_Live"."OwnerID", "File_Live"."FileHash", "File_Live"."FileFilename", "File_Live"."FileVariant", "File_Live"."ObjectID", "File_Live"."ObjectClass", "Image_Live"."FocusPointX", "Image_Live"."FocusPointY", "Image_Live"."FocusPointWidth", "Image_Live"."FocusPointHeight", "File_Live"."ID", CASE WHEN "File_Live"."ClassName" IS NOT NULL THEN "File_Live"."ClassName" ELSE 'SilverStripe\\Assets\\File' END AS "RecordClassName" FROM "File_Live" LEFT JOIN "Image_Live" ON "Image_Live"."ID" = "File_Live"."ID" WHERE ("File_Live"."ID" = ?) AND ("File_Live"."ClassName" IN (?)) ORDER BY "File_Live"."Name" ASC LIMIT 1 0.0006s

0178: SELECT DISTINCT "Link"."ClassName", "Link"."LastEdited", "Link"."Created", "Link"."Anchor", "Link"."Title", "Link"."Type", "Link"."URL", "Link"."Email", "Link"."Phone", "Link"."OpenInNewWindow", "Link"."SelectedStyle", "Link"."SiteTreeID", "Link"."FileID", "Link"."ID", CASE WHEN "Link"."ClassName" IS NOT NULL THEN "Link"."ClassName" ELSE 'gorriecoe\\Link\\Models\\Link' END AS "RecordClassName" FROM "Link" WHERE ("Link"."ID" = ?) LIMIT 1 0.0005s

0179: SELECT DISTINCT "Link"."ClassName", "Link"."LastEdited", "Link"."Created", "Link"."Anchor", "Link"."Title", "Link"."Type", "Link"."URL", "Link"."Email", "Link"."Phone", "Link"."OpenInNewWindow", "Link"."SelectedStyle", "Link"."SiteTreeID", "Link"."FileID", "Link"."ID", CASE WHEN "Link"."ClassName" IS NOT NULL THEN "Link"."ClassName" ELSE 'gorriecoe\\Link\\Models\\Link' END AS "RecordClassName" FROM "Link" WHERE ("Link"."ID" = ?) LIMIT 1 0.0004s

0180: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", "SiteTree_Live"."ShowInSitemap", "SiteTree_Live"."AvailableOffline", CASE WHEN "SiteTree_Localised_lv_LV"."ID" IS NOT NULL THEN "SiteTree_Localised_lv_LV"."ExtraCode" WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."ExtraCode" ELSE "SiteTree_Live"."ExtraCode" END AS "ExtraCode", "SiteTree_Live"."CanViewType", "SiteTree_Live"."CanEditType", "SiteTree_Live"."Version", CASE WHEN "SiteTree_Localised_lv_LV"."ID" IS NOT NULL THEN "SiteTree_Localised_lv_LV"."URLSegment" 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_lv_LV"."ID" IS NOT NULL THEN "SiteTree_Localised_lv_LV"."Title" 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_lv_LV"."ID" IS NOT NULL THEN "SiteTree_Localised_lv_LV"."MenuTitle" 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_lv_LV"."ID" IS NOT NULL THEN "SiteTree_Localised_lv_LV"."Content" 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_lv_LV"."ID" IS NOT NULL THEN "SiteTree_Localised_lv_LV"."MetaDescription" 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_lv_LV"."ID" IS NOT NULL THEN "SiteTree_Localised_lv_LV"."ReportClass" WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."ReportClass" ELSE "SiteTree_Live"."ReportClass" END AS "ReportClass", "SiteTree_Live"."ParentID", "Page_Live"."InheritSideBar", "Page_Live"."BlockIcon", "Page_Live"."SideBarID", "Page_Live"."ElementalAreaID", CASE WHEN "ProfilePage_Localised_lv_LV"."ID" IS NOT NULL THEN "ProfilePage_Localised_lv_LV"."DrawingsPageContent" WHEN "ProfilePage_Localised_en_US"."ID" IS NOT NULL THEN "ProfilePage_Localised_en_US"."DrawingsPageContent" ELSE "ProfilePage_Live"."DrawingsPageContent" END AS "DrawingsPageContent", "SiteTree_Live"."ID", CASE WHEN "SiteTree_Live"."ClassName" IS NOT NULL THEN "SiteTree_Live"."ClassName" ELSE 'SilverStripe\\CMS\\Model\\SiteTree' END AS "RecordClassName", 'lv_LV' AS "Locale", CASE WHEN "ProfilePage_Localised_lv_LV"."ID" IS NOT NULL THEN 'lv_LV' WHEN "ProfilePage_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 "ProfilePage_Live" ON "ProfilePage_Live"."ID" = "SiteTree_Live"."ID" LEFT JOIN "SiteTree_Localised_Live" AS "SiteTree_Localised_lv_LV" ON "SiteTree_Live"."ID" = "SiteTree_Localised_lv_LV"."RecordID" AND "SiteTree_Localised_lv_LV"."Locale" = ? 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 "ProfilePage_Localised_Live" AS "ProfilePage_Localised_lv_LV" ON "ProfilePage_Live"."ID" = "ProfilePage_Localised_lv_LV"."RecordID" AND "ProfilePage_Localised_lv_LV"."Locale" = ? LEFT JOIN "ProfilePage_Localised_Live" AS "ProfilePage_Localised_en_US" ON "ProfilePage_Live"."ID" = "ProfilePage_Localised_en_US"."RecordID" AND "ProfilePage_Localised_en_US"."Locale" = ? WHERE ("SiteTree_Live"."ClassName" IN (?)) AND (("SiteTree_Localised_lv_LV"."ID" IS NOT NULL)) ORDER BY "SiteTree_Live"."Sort" ASC LIMIT 1 0.0019s

0181: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", "SiteTree_Live"."ShowInSitemap", "SiteTree_Live"."AvailableOffline", CASE WHEN "SiteTree_Localised_lv_LV"."ID" IS NOT NULL THEN "SiteTree_Localised_lv_LV"."ExtraCode" WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."ExtraCode" ELSE "SiteTree_Live"."ExtraCode" END AS "ExtraCode", "SiteTree_Live"."CanViewType", "SiteTree_Live"."CanEditType", "SiteTree_Live"."Version", CASE WHEN "SiteTree_Localised_lv_LV"."ID" IS NOT NULL THEN "SiteTree_Localised_lv_LV"."URLSegment" 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_lv_LV"."ID" IS NOT NULL THEN "SiteTree_Localised_lv_LV"."Title" 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_lv_LV"."ID" IS NOT NULL THEN "SiteTree_Localised_lv_LV"."MenuTitle" 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_lv_LV"."ID" IS NOT NULL THEN "SiteTree_Localised_lv_LV"."Content" 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_lv_LV"."ID" IS NOT NULL THEN "SiteTree_Localised_lv_LV"."MetaDescription" 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_lv_LV"."ID" IS NOT NULL THEN "SiteTree_Localised_lv_LV"."ReportClass" WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."ReportClass" ELSE "SiteTree_Live"."ReportClass" END AS "ReportClass", "SiteTree_Live"."ParentID", "Page_Live"."InheritSideBar", "Page_Live"."BlockIcon", "Page_Live"."SideBarID", "Page_Live"."ElementalAreaID", CASE WHEN "RegistrationPage_Localised_lv_LV"."ID" IS NOT NULL THEN "RegistrationPage_Localised_lv_LV"."FormText" WHEN "RegistrationPage_Localised_en_US"."ID" IS NOT NULL THEN "RegistrationPage_Localised_en_US"."FormText" ELSE "RegistrationPage_Live"."FormText" END AS "FormText", CASE WHEN "RegistrationPage_Localised_lv_LV"."ID" IS NOT NULL THEN "RegistrationPage_Localised_lv_LV"."SuccessContent" WHEN "RegistrationPage_Localised_en_US"."ID" IS NOT NULL THEN "RegistrationPage_Localised_en_US"."SuccessContent" ELSE "RegistrationPage_Live"."SuccessContent" END AS "SuccessContent", CASE WHEN "RegistrationPage_Localised_lv_LV"."ID" IS NOT NULL THEN "RegistrationPage_Localised_lv_LV"."LoginContent" WHEN "RegistrationPage_Localised_en_US"."ID" IS NOT NULL THEN "RegistrationPage_Localised_en_US"."LoginContent" ELSE "RegistrationPage_Live"."LoginContent" END AS "LoginContent", "SiteTree_Live"."ID", CASE WHEN "SiteTree_Live"."ClassName" IS NOT NULL THEN "SiteTree_Live"."ClassName" ELSE 'SilverStripe\\CMS\\Model\\SiteTree' END AS "RecordClassName", 'lv_LV' AS "Locale", CASE WHEN "RegistrationPage_Localised_lv_LV"."ID" IS NOT NULL THEN 'lv_LV' WHEN "RegistrationPage_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 "RegistrationPage_Live" ON "RegistrationPage_Live"."ID" = "SiteTree_Live"."ID" LEFT JOIN "SiteTree_Localised_Live" AS "SiteTree_Localised_lv_LV" ON "SiteTree_Live"."ID" = "SiteTree_Localised_lv_LV"."RecordID" AND "SiteTree_Localised_lv_LV"."Locale" = ? 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 "RegistrationPage_Localised_Live" AS "RegistrationPage_Localised_lv_LV" ON "RegistrationPage_Live"."ID" = "RegistrationPage_Localised_lv_LV"."RecordID" AND "RegistrationPage_Localised_lv_LV"."Locale" = ? LEFT JOIN "RegistrationPage_Localised_Live" AS "RegistrationPage_Localised_en_US" ON "RegistrationPage_Live"."ID" = "RegistrationPage_Localised_en_US"."RecordID" AND "RegistrationPage_Localised_en_US"."Locale" = ? WHERE ("SiteTree_Live"."ClassName" IN (?)) AND (("SiteTree_Localised_lv_LV"."ID" IS NOT NULL)) ORDER BY "SiteTree_Live"."Sort" ASC LIMIT 1 0.0019s

0182: SELECT "Version" FROM "SiteTree" WHERE "ID" = ? 0.0005s

0183: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", "SiteTree_Live"."ShowInSitemap", "SiteTree_Live"."AvailableOffline", CASE WHEN "SiteTree_Localised_lv_LV"."ID" IS NOT NULL THEN "SiteTree_Localised_lv_LV"."ExtraCode" WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."ExtraCode" ELSE "SiteTree_Live"."ExtraCode" END AS "ExtraCode", "SiteTree_Live"."CanViewType", "SiteTree_Live"."CanEditType", "SiteTree_Live"."Version", CASE WHEN "SiteTree_Localised_lv_LV"."ID" IS NOT NULL THEN "SiteTree_Localised_lv_LV"."URLSegment" 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_lv_LV"."ID" IS NOT NULL THEN "SiteTree_Localised_lv_LV"."Title" 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_lv_LV"."ID" IS NOT NULL THEN "SiteTree_Localised_lv_LV"."MenuTitle" 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_lv_LV"."ID" IS NOT NULL THEN "SiteTree_Localised_lv_LV"."Content" 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_lv_LV"."ID" IS NOT NULL THEN "SiteTree_Localised_lv_LV"."MetaDescription" 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_lv_LV"."ID" IS NOT NULL THEN "SiteTree_Localised_lv_LV"."ReportClass" WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."ReportClass" ELSE "SiteTree_Live"."ReportClass" END AS "ReportClass", "SiteTree_Live"."ParentID", "SiteTree_Live"."ID", CASE WHEN "SiteTree_Live"."ClassName" IS NOT NULL THEN "SiteTree_Live"."ClassName" ELSE 'SilverStripe\\CMS\\Model\\SiteTree' END AS "RecordClassName", 'lv_LV' AS "Locale", CASE WHEN "SiteTree_Localised_lv_LV"."ID" IS NOT NULL THEN 'lv_LV' 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_lv_LV" ON "SiteTree_Live"."ID" = "SiteTree_Localised_lv_LV"."RecordID" AND "SiteTree_Localised_lv_LV"."Locale" = ? 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_lv_LV"."ID" IS NOT NULL)) ORDER BY "SiteTree_Live"."Sort" ASC LIMIT 1 0.0008s

0184: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", "SiteTree_Live"."ShowInSitemap", "SiteTree_Live"."AvailableOffline", CASE WHEN "SiteTree_Localised_lv_LV"."ID" IS NOT NULL THEN "SiteTree_Localised_lv_LV"."ExtraCode" WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."ExtraCode" ELSE "SiteTree_Live"."ExtraCode" END AS "ExtraCode", "SiteTree_Live"."CanViewType", "SiteTree_Live"."CanEditType", "SiteTree_Live"."Version", CASE WHEN "SiteTree_Localised_lv_LV"."ID" IS NOT NULL THEN "SiteTree_Localised_lv_LV"."URLSegment" 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_lv_LV"."ID" IS NOT NULL THEN "SiteTree_Localised_lv_LV"."Title" 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_lv_LV"."ID" IS NOT NULL THEN "SiteTree_Localised_lv_LV"."MenuTitle" 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_lv_LV"."ID" IS NOT NULL THEN "SiteTree_Localised_lv_LV"."Content" 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_lv_LV"."ID" IS NOT NULL THEN "SiteTree_Localised_lv_LV"."MetaDescription" 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_lv_LV"."ID" IS NOT NULL THEN "SiteTree_Localised_lv_LV"."ReportClass" WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."ReportClass" ELSE "SiteTree_Live"."ReportClass" END AS "ReportClass", "SiteTree_Live"."ParentID", "SiteTree_Live"."ID", CASE WHEN "SiteTree_Live"."ClassName" IS NOT NULL THEN "SiteTree_Live"."ClassName" ELSE 'SilverStripe\\CMS\\Model\\SiteTree' END AS "RecordClassName", 'lv_LV' AS "Locale", CASE WHEN "SiteTree_Localised_lv_LV"."ID" IS NOT NULL THEN 'lv_LV' 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_lv_LV" ON "SiteTree_Live"."ID" = "SiteTree_Localised_lv_LV"."RecordID" AND "SiteTree_Localised_lv_LV"."Locale" = ? 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_lv_LV"."ID" IS NOT NULL)) ORDER BY "SiteTree_Live"."Sort" ASC LIMIT 1 0.0007s

0185: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", "SiteTree_Live"."ShowInSitemap", "SiteTree_Live"."AvailableOffline", CASE WHEN "SiteTree_Localised_lv_LV"."ID" IS NOT NULL THEN "SiteTree_Localised_lv_LV"."ExtraCode" WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."ExtraCode" ELSE "SiteTree_Live"."ExtraCode" END AS "ExtraCode", "SiteTree_Live"."CanViewType", "SiteTree_Live"."CanEditType", "SiteTree_Live"."Version", CASE WHEN "SiteTree_Localised_lv_LV"."ID" IS NOT NULL THEN "SiteTree_Localised_lv_LV"."URLSegment" 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_lv_LV"."ID" IS NOT NULL THEN "SiteTree_Localised_lv_LV"."Title" 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_lv_LV"."ID" IS NOT NULL THEN "SiteTree_Localised_lv_LV"."MenuTitle" 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_lv_LV"."ID" IS NOT NULL THEN "SiteTree_Localised_lv_LV"."Content" 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_lv_LV"."ID" IS NOT NULL THEN "SiteTree_Localised_lv_LV"."MetaDescription" 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_lv_LV"."ID" IS NOT NULL THEN "SiteTree_Localised_lv_LV"."ReportClass" WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."ReportClass" ELSE "SiteTree_Live"."ReportClass" END AS "ReportClass", "SiteTree_Live"."ParentID", "SiteTree_Live"."ID", CASE WHEN "SiteTree_Live"."ClassName" IS NOT NULL THEN "SiteTree_Live"."ClassName" ELSE 'SilverStripe\\CMS\\Model\\SiteTree' END AS "RecordClassName", 'lv_LV' AS "Locale", CASE WHEN "SiteTree_Localised_lv_LV"."ID" IS NOT NULL THEN 'lv_LV' 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_lv_LV" ON "SiteTree_Live"."ID" = "SiteTree_Localised_lv_LV"."RecordID" AND "SiteTree_Localised_lv_LV"."Locale" = ? 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_lv_LV"."ID" IS NOT NULL)) ORDER BY "SiteTree_Live"."Sort" ASC LIMIT 1 0.0007s

0186: SELECT DISTINCT "SiteTree"."ClassName", "SiteTree"."LastEdited", "SiteTree"."Created", "SiteTree"."Priority", "SiteTree"."ShowInSitemap", "SiteTree"."AvailableOffline", CASE WHEN "SiteTree_Localised_lv_LV"."ID" IS NOT NULL THEN "SiteTree_Localised_lv_LV"."ExtraCode" WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."ExtraCode" ELSE "SiteTree"."ExtraCode" END AS "ExtraCode", "SiteTree"."CanViewType", "SiteTree"."CanEditType", "SiteTree"."Version", CASE WHEN "SiteTree_Localised_lv_LV"."ID" IS NOT NULL THEN "SiteTree_Localised_lv_LV"."URLSegment" WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."URLSegment" ELSE "SiteTree"."URLSegment" END AS "URLSegment", CASE WHEN "SiteTree_Localised_lv_LV"."ID" IS NOT NULL THEN "SiteTree_Localised_lv_LV"."Title" WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."Title" ELSE "SiteTree"."Title" END AS "Title", CASE WHEN "SiteTree_Localised_lv_LV"."ID" IS NOT NULL THEN "SiteTree_Localised_lv_LV"."MenuTitle" WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."MenuTitle" ELSE "SiteTree"."MenuTitle" END AS "MenuTitle", CASE WHEN "SiteTree_Localised_lv_LV"."ID" IS NOT NULL THEN "SiteTree_Localised_lv_LV"."Content" WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."Content" ELSE "SiteTree"."Content" END AS "Content", CASE WHEN "SiteTree_Localised_lv_LV"."ID" IS NOT NULL THEN "SiteTree_Localised_lv_LV"."MetaDescription" WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."MetaDescription" ELSE "SiteTree"."MetaDescription" END AS "MetaDescription", "SiteTree"."ExtraMeta", "SiteTree"."ShowInMenus", "SiteTree"."ShowInSearch", "SiteTree"."Sort", "SiteTree"."HasBrokenFile", "SiteTree"."HasBrokenLink", CASE WHEN "SiteTree_Localised_lv_LV"."ID" IS NOT NULL THEN "SiteTree_Localised_lv_LV"."ReportClass" WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."ReportClass" ELSE "SiteTree"."ReportClass" END AS "ReportClass", "SiteTree"."ParentID", "SiteTree"."ID", CASE WHEN "SiteTree"."ClassName" IS NOT NULL THEN "SiteTree"."ClassName" ELSE 'SilverStripe\\CMS\\Model\\SiteTree' END AS "RecordClassName", 'lv_LV' AS "Locale", CASE WHEN "SiteTree_Localised_lv_LV"."ID" IS NOT NULL THEN 'lv_LV' WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN 'en_US' ELSE NULL END AS "SourceLocale" FROM "SiteTree" LEFT JOIN "SiteTree_Localised" AS "SiteTree_Localised_lv_LV" ON "SiteTree"."ID" = "SiteTree_Localised_lv_LV"."RecordID" AND "SiteTree_Localised_lv_LV"."Locale" = ? LEFT JOIN "SiteTree_Localised" AS "SiteTree_Localised_en_US" ON "SiteTree"."ID" = "SiteTree_Localised_en_US"."RecordID" AND "SiteTree_Localised_en_US"."Locale" = ? WHERE ("SiteTree"."ID" = ?) AND (("SiteTree_Localised_lv_LV"."ID" IS NOT NULL)) ORDER BY "SiteTree"."Sort" ASC LIMIT 1 0.0009s

0187: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", "SiteTree_Live"."ShowInSitemap", "SiteTree_Live"."AvailableOffline", CASE WHEN "SiteTree_Localised_lv_LV"."ID" IS NOT NULL THEN "SiteTree_Localised_lv_LV"."ExtraCode" WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."ExtraCode" ELSE "SiteTree_Live"."ExtraCode" END AS "ExtraCode", "SiteTree_Live"."CanViewType", "SiteTree_Live"."CanEditType", "SiteTree_Live"."Version", CASE WHEN "SiteTree_Localised_lv_LV"."ID" IS NOT NULL THEN "SiteTree_Localised_lv_LV"."URLSegment" 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_lv_LV"."ID" IS NOT NULL THEN "SiteTree_Localised_lv_LV"."Title" 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_lv_LV"."ID" IS NOT NULL THEN "SiteTree_Localised_lv_LV"."MenuTitle" 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_lv_LV"."ID" IS NOT NULL THEN "SiteTree_Localised_lv_LV"."Content" 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_lv_LV"."ID" IS NOT NULL THEN "SiteTree_Localised_lv_LV"."MetaDescription" 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_lv_LV"."ID" IS NOT NULL THEN "SiteTree_Localised_lv_LV"."ReportClass" WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."ReportClass" ELSE "SiteTree_Live"."ReportClass" END AS "ReportClass", "SiteTree_Live"."ParentID", "SiteTree_Live"."ID", CASE WHEN "SiteTree_Live"."ClassName" IS NOT NULL THEN "SiteTree_Live"."ClassName" ELSE 'SilverStripe\\CMS\\Model\\SiteTree' END AS "RecordClassName", 'lv_LV' AS "Locale", CASE WHEN "SiteTree_Localised_lv_LV"."ID" IS NOT NULL THEN 'lv_LV' 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_lv_LV" ON "SiteTree_Live"."ID" = "SiteTree_Localised_lv_LV"."RecordID" AND "SiteTree_Localised_lv_LV"."Locale" = ? 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_lv_LV"."ID" IS NOT NULL)) ORDER BY "SiteTree_Live"."Sort" ASC LIMIT 1 0.0007s

0188: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", "SiteTree_Live"."ShowInSitemap", "SiteTree_Live"."AvailableOffline", CASE WHEN "SiteTree_Localised_lv_LV"."ID" IS NOT NULL THEN "SiteTree_Localised_lv_LV"."ExtraCode" WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."ExtraCode" ELSE "SiteTree_Live"."ExtraCode" END AS "ExtraCode", "SiteTree_Live"."CanViewType", "SiteTree_Live"."CanEditType", "SiteTree_Live"."Version", CASE WHEN "SiteTree_Localised_lv_LV"."ID" IS NOT NULL THEN "SiteTree_Localised_lv_LV"."URLSegment" 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_lv_LV"."ID" IS NOT NULL THEN "SiteTree_Localised_lv_LV"."Title" 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_lv_LV"."ID" IS NOT NULL THEN "SiteTree_Localised_lv_LV"."MenuTitle" 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_lv_LV"."ID" IS NOT NULL THEN "SiteTree_Localised_lv_LV"."Content" 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_lv_LV"."ID" IS NOT NULL THEN "SiteTree_Localised_lv_LV"."MetaDescription" 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_lv_LV"."ID" IS NOT NULL THEN "SiteTree_Localised_lv_LV"."ReportClass" WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."ReportClass" ELSE "SiteTree_Live"."ReportClass" END AS "ReportClass", "SiteTree_Live"."ParentID", "SiteTree_Live"."ID", CASE WHEN "SiteTree_Live"."ClassName" IS NOT NULL THEN "SiteTree_Live"."ClassName" ELSE 'SilverStripe\\CMS\\Model\\SiteTree' END AS "RecordClassName", 'lv_LV' AS "Locale", CASE WHEN "SiteTree_Localised_lv_LV"."ID" IS NOT NULL THEN 'lv_LV' 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_lv_LV" ON "SiteTree_Live"."ID" = "SiteTree_Localised_lv_LV"."RecordID" AND "SiteTree_Localised_lv_LV"."Locale" = ? 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_lv_LV"."ID" IS NOT NULL)) ORDER BY "SiteTree_Live"."Sort" ASC LIMIT 1 0.0007s