SET sql_mode = ? 0.0007s

SHOW DATABASES LIKE 'archeryn_cms' 0.0007s

SHOW FULL TABLES WHERE Table_Type != 'VIEW' 2.1621s

SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."URLSegment", "SiteTree_Live"."Title", "SiteTree_Live"."MenuTitle", "SiteTree_Live"."Content", "SiteTree_Live"."MetaDescription", "SiteTree_Live"."ExtraMeta", "SiteTree_Live"."ShowInMenus", "SiteTree_Live"."ShowInSearch", "SiteTree_Live"."Sort", "SiteTree_Live"."HasBrokenFile", "SiteTree_Live"."HasBrokenLink", "SiteTree_Live"."ReportClass", "SiteTree_Live"."CanViewType", "SiteTree_Live"."CanEditType", "SiteTree_Live"."Priority", "SiteTree_Live"."InheritBlockSets", "SiteTree_Live"."Latitude", "SiteTree_Live"."Longitude", "SiteTree_Live"."ShowMap", "SiteTree_Live"."StaticMap", "SiteTree_Live"."Address", "SiteTree_Live"."ZoomLevel", "SiteTree_Live"."InfoWindowContent", "SiteTree_Live"."MapHueColor", "SiteTree_Live"."MapSaturation", "SiteTree_Live"."MapLightness", "SiteTree_Live"."Version", "SiteTree_Live"."ParentID", "SiteTree_Live"."ID", CASE WHEN "SiteTree_Live"."ClassName" IS NOT NULL THEN "SiteTree_Live"."ClassName" ELSE 'SiteTree' END AS "RecordClassName" FROM "SiteTree_Live" WHERE ("SiteTree_Live"."URLSegment" = ?) AND ("SiteTree_Live"."ParentID" = ?) ORDER BY "SiteTree_Live"."Sort" ASC LIMIT 1 0.0382s

SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."URLSegment", "SiteTree_Live"."Title", "SiteTree_Live"."MenuTitle", "SiteTree_Live"."Content", "SiteTree_Live"."MetaDescription", "SiteTree_Live"."ExtraMeta", "SiteTree_Live"."ShowInMenus", "SiteTree_Live"."ShowInSearch", "SiteTree_Live"."Sort", "SiteTree_Live"."HasBrokenFile", "SiteTree_Live"."HasBrokenLink", "SiteTree_Live"."ReportClass", "SiteTree_Live"."CanViewType", "SiteTree_Live"."CanEditType", "SiteTree_Live"."Priority", "SiteTree_Live"."InheritBlockSets", "SiteTree_Live"."Latitude", "SiteTree_Live"."Longitude", "SiteTree_Live"."ShowMap", "SiteTree_Live"."StaticMap", "SiteTree_Live"."Address", "SiteTree_Live"."ZoomLevel", "SiteTree_Live"."InfoWindowContent", "SiteTree_Live"."MapHueColor", "SiteTree_Live"."MapSaturation", "SiteTree_Live"."MapLightness", "SiteTree_Live"."Version", "SiteTree_Live"."ParentID", "SiteTree_Live"."ID", CASE WHEN "SiteTree_Live"."ClassName" IS NOT NULL THEN "SiteTree_Live"."ClassName" ELSE 'SiteTree' END AS "RecordClassName" FROM "SiteTree_Live" WHERE ("SiteTree_Live"."ParentID" = ?) AND ("SiteTree_Live"."URLSegment" = ?) ORDER BY "SiteTree_Live"."Sort" ASC LIMIT 1 0.0367s

SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."URLSegment", "SiteTree_Live"."Title", "SiteTree_Live"."MenuTitle", "SiteTree_Live"."Content", "SiteTree_Live"."MetaDescription", "SiteTree_Live"."ExtraMeta", "SiteTree_Live"."ShowInMenus", "SiteTree_Live"."ShowInSearch", "SiteTree_Live"."Sort", "SiteTree_Live"."HasBrokenFile", "SiteTree_Live"."HasBrokenLink", "SiteTree_Live"."ReportClass", "SiteTree_Live"."CanViewType", "SiteTree_Live"."CanEditType", "SiteTree_Live"."Priority", "SiteTree_Live"."InheritBlockSets", "SiteTree_Live"."Latitude", "SiteTree_Live"."Longitude", "SiteTree_Live"."ShowMap", "SiteTree_Live"."StaticMap", "SiteTree_Live"."Address", "SiteTree_Live"."ZoomLevel", "SiteTree_Live"."InfoWindowContent", "SiteTree_Live"."MapHueColor", "SiteTree_Live"."MapSaturation", "SiteTree_Live"."MapLightness", "SiteTree_Live"."Version", "SiteTree_Live"."ParentID", "SiteTree_Live"."ID", CASE WHEN "SiteTree_Live"."ClassName" IS NOT NULL THEN "SiteTree_Live"."ClassName" ELSE 'SiteTree' END AS "RecordClassName" FROM "SiteTree_Live" WHERE ("SiteTree_Live"."ID" = ?) ORDER BY "SiteTree_Live"."Sort" ASC LIMIT 1 0.0011s

SELECT DISTINCT "SiteConfig"."ClassName", "SiteConfig"."LastEdited", "SiteConfig"."Created", "SiteConfig"."Title", "SiteConfig"."Tagline", "SiteConfig"."Theme", "SiteConfig"."CanViewType", "SiteConfig"."CanEditType", "SiteConfig"."CanCreateTopLevelType", "SiteConfig"."BecomeMemberLink", "SiteConfig"."AllowedCountries", "SiteConfig"."GoogleTagMangerContainerId", "SiteConfig"."ContactEmail", "SiteConfig"."ContactPhone", "SiteConfig"."CompanyName", "SiteConfig"."ContactFax", "SiteConfig"."WebsiteAddress", "SiteConfig"."CompanyAddress", "SiteConfig"."FacebookUrl", "SiteConfig"."GooglePlusUrl", "SiteConfig"."TwitterUrl", "SiteConfig"."LinkedInUrl", "SiteConfig"."PintrestUrl", "SiteConfig"."DefaultTwitterHandle", "SiteConfig"."InstagramUrl", "SiteConfig"."SchemaBusinessName", "SiteConfig"."SchemaBusinessStreet", "SiteConfig"."SchemaBusinessTown", "SiteConfig"."SchemaBusinessRegion", "SiteConfig"."SchemaBusinessPC", "SiteConfig"."SchemaBusinessPhone", "SiteConfig"."OGApplicationID", "SiteConfig"."OGAdminID", "SiteConfig"."TermsPageID", "SiteConfig"."CustomerGroupID", "SiteConfig"."DefaultProductImageID", "SiteConfig"."LogoID", "SiteConfig"."OGImageID", "SiteConfig"."CMSLogoID", "SiteConfig"."ID", CASE WHEN "SiteConfig"."ClassName" IS NOT NULL THEN "SiteConfig"."ClassName" ELSE 'SiteConfig' END AS "RecordClassName" FROM "SiteConfig" LIMIT 1 0.0021s

SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "Page_Live"."BannerText", "Page_Live"."ColumnOneText", "Page_Live"."ColumnTwoText", "Page_Live"."ShowInFooter", "Page_Live"."InheritSettings", "Page_Live"."PageAlias", "Page_Live"."MetaTitle", "Page_Live"."BannerImageID", "Page_Live"."UseCampaignID", "SiteTree_Live"."ID", CASE WHEN "SiteTree_Live"."ClassName" IS NOT NULL THEN "SiteTree_Live"."ClassName" ELSE 'SiteTree' END AS "RecordClassName", "SiteTree_Live"."Sort" FROM "SiteTree_Live" LEFT JOIN "Page_Live" ON "Page_Live"."ID" = "SiteTree_Live"."ID" WHERE ("Page_Live"."ID" = 248) AND ("SiteTree_Live"."ClassName" IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)) ORDER BY "SiteTree_Live"."Sort" ASC LIMIT 1 0.0688s

SELECT DISTINCT "File"."ClassName", "File"."LastEdited", "File"."Created", "File"."Name", "File"."Title", "File"."Filename", "File"."Content", "File"."ShowInSearch", "File"."CanViewType", "File"."ParentID", "File"."OwnerID", "Image"."FocusX", "Image"."FocusY", "File"."ID", CASE WHEN "File"."ClassName" IS NOT NULL THEN "File"."ClassName" ELSE 'File' END AS "RecordClassName" FROM "File" LEFT JOIN "Image" ON "Image"."ID" = "File"."ID" WHERE ("File"."ID" = ?) AND ("File"."ClassName" IN (?, ?, ?, ?)) ORDER BY "File"."Name" ASC LIMIT 1 0.0267s

SELECT DISTINCT "File"."ClassName", "File"."LastEdited", "File"."Created", "File"."Name", "File"."Title", "File"."Filename", "File"."Content", "File"."ShowInSearch", "File"."CanViewType", "File"."ParentID", "File"."OwnerID", "File"."ID", CASE WHEN "File"."ClassName" IS NOT NULL THEN "File"."ClassName" ELSE 'File' END AS "RecordClassName" FROM "File" WHERE ("File"."ID" = ?) ORDER BY "File"."Name" ASC LIMIT 1 0.0228s

SELECT DISTINCT "File"."ClassName", "File"."LastEdited", "File"."Created", "File"."Name", "File"."Title", "File"."Filename", "File"."Content", "File"."ShowInSearch", "File"."CanViewType", "File"."ParentID", "File"."OwnerID", "File"."ID", CASE WHEN "File"."ClassName" IS NOT NULL THEN "File"."ClassName" ELSE 'File' END AS "RecordClassName" FROM "File" WHERE ("File"."ID" = ?) ORDER BY "File"."Name" ASC LIMIT 1 0.0009s

SELECT DISTINCT "File"."ClassName", "File"."LastEdited", "File"."Created", "File"."Name", "File"."Title", "File"."Filename", "File"."Content", "File"."ShowInSearch", "File"."CanViewType", "File"."ParentID", "File"."OwnerID", "File"."ID", CASE WHEN "File"."ClassName" IS NOT NULL THEN "File"."ClassName" ELSE 'File' END AS "RecordClassName" FROM "File" WHERE ("File"."ID" = ?) ORDER BY "File"."Name" ASC LIMIT 1 0.0008s

SELECT DISTINCT "File"."ClassName", "File"."LastEdited", "File"."Created", "File"."Name", "File"."Title", "File"."Filename", "File"."Content", "File"."ShowInSearch", "File"."CanViewType", "File"."ParentID", "File"."OwnerID", "File"."ID", CASE WHEN "File"."ClassName" IS NOT NULL THEN "File"."ClassName" ELSE 'File' END AS "RecordClassName" FROM "File" WHERE ("File"."ID" = ?) ORDER BY "File"."Name" ASC LIMIT 1 0.0009s

SELECT DISTINCT "File"."ClassName", "File"."LastEdited", "File"."Created", "File"."Name", "File"."Title", "File"."Filename", "File"."Content", "File"."ShowInSearch", "File"."CanViewType", "File"."ParentID", "File"."OwnerID", "File"."ID", CASE WHEN "File"."ClassName" IS NOT NULL THEN "File"."ClassName" ELSE 'File' END AS "RecordClassName" FROM "File" WHERE ("File"."ID" = ?) ORDER BY "File"."Name" ASC LIMIT 1 0.0006s

SELECT DISTINCT "File"."ClassName", "File"."LastEdited", "File"."Created", "File"."Name", "File"."Title", "File"."Filename", "File"."Content", "File"."ShowInSearch", "File"."CanViewType", "File"."ParentID", "File"."OwnerID", "File"."ID", CASE WHEN "File"."ClassName" IS NOT NULL THEN "File"."ClassName" ELSE 'File' END AS "RecordClassName" FROM "File" WHERE ("File"."ID" = ?) ORDER BY "File"."Name" ASC LIMIT 1 0.0007s

SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."URLSegment", "SiteTree_Live"."Title", "SiteTree_Live"."MenuTitle", "SiteTree_Live"."Content", "SiteTree_Live"."MetaDescription", "SiteTree_Live"."ExtraMeta", "SiteTree_Live"."ShowInMenus", "SiteTree_Live"."ShowInSearch", "SiteTree_Live"."Sort", "SiteTree_Live"."HasBrokenFile", "SiteTree_Live"."HasBrokenLink", "SiteTree_Live"."ReportClass", "SiteTree_Live"."CanViewType", "SiteTree_Live"."CanEditType", "SiteTree_Live"."Priority", "SiteTree_Live"."InheritBlockSets", "SiteTree_Live"."Latitude", "SiteTree_Live"."Longitude", "SiteTree_Live"."ShowMap", "SiteTree_Live"."StaticMap", "SiteTree_Live"."Address", "SiteTree_Live"."ZoomLevel", "SiteTree_Live"."InfoWindowContent", "SiteTree_Live"."MapHueColor", "SiteTree_Live"."MapSaturation", "SiteTree_Live"."MapLightness", "SiteTree_Live"."Version", "SiteTree_Live"."ParentID", "SiteTree_Live"."ID", CASE WHEN "SiteTree_Live"."ClassName" IS NOT NULL THEN "SiteTree_Live"."ClassName" ELSE 'SiteTree' END AS "RecordClassName" FROM "SiteTree_Live" WHERE ("SiteTree_Live"."ID" = ?) ORDER BY "SiteTree_Live"."Sort" ASC LIMIT 1 0.0008s

SELECT DISTINCT "SiteTree_versions"."ClassName", "SiteTree_versions"."LastEdited", "SiteTree_versions"."Created", "SiteTree_versions"."URLSegment", "SiteTree_versions"."Title", "SiteTree_versions"."MenuTitle", "SiteTree_versions"."Content", "SiteTree_versions"."MetaDescription", "SiteTree_versions"."ExtraMeta", "SiteTree_versions"."ShowInMenus", "SiteTree_versions"."ShowInSearch", "SiteTree_versions"."Sort", "SiteTree_versions"."HasBrokenFile", "SiteTree_versions"."HasBrokenLink", "SiteTree_versions"."ReportClass", "SiteTree_versions"."CanViewType", "SiteTree_versions"."CanEditType", "SiteTree_versions"."Priority", "SiteTree_versions"."InheritBlockSets", "SiteTree_versions"."Latitude", "SiteTree_versions"."Longitude", "SiteTree_versions"."ShowMap", "SiteTree_versions"."StaticMap", "SiteTree_versions"."Address", "SiteTree_versions"."ZoomLevel", "SiteTree_versions"."InfoWindowContent", "SiteTree_versions"."MapHueColor", "SiteTree_versions"."MapSaturation", "SiteTree_versions"."MapLightness", "SiteTree_versions"."Version", "SiteTree_versions"."ParentID", "SiteTree_versions"."RecordID" AS "ID", CASE WHEN "SiteTree_versions"."ClassName" IS NOT NULL THEN "SiteTree_versions"."ClassName" ELSE 'SiteTree' END AS "RecordClassName", "SiteTree_versions"."RecordID", "SiteTree_versions"."WasPublished", "SiteTree_versions"."AuthorID", "SiteTree_versions"."PublisherID" FROM "SiteTree_versions" WHERE ("SiteTree_versions"."RecordID" = 252) AND ("SiteTree_versions"."Version" IN (SELECT LatestVersion FROM (SELECT "SiteTree_versions"."RecordID", MAX("SiteTree_versions"."Version") AS LatestVersion FROM "SiteTree_versions" GROUP BY "SiteTree_versions"."RecordID" ) AS "SiteTree_versions_latest" WHERE "SiteTree_versions_latest"."RecordID" = "SiteTree_versions"."RecordID" )) ORDER BY "SiteTree_versions"."Sort" ASC LIMIT 1 0.0266s

SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."URLSegment", "SiteTree_Live"."Title", "SiteTree_Live"."MenuTitle", "SiteTree_Live"."Content", "SiteTree_Live"."MetaDescription", "SiteTree_Live"."ExtraMeta", "SiteTree_Live"."ShowInMenus", "SiteTree_Live"."ShowInSearch", "SiteTree_Live"."Sort", "SiteTree_Live"."HasBrokenFile", "SiteTree_Live"."HasBrokenLink", "SiteTree_Live"."ReportClass", "SiteTree_Live"."CanViewType", "SiteTree_Live"."CanEditType", "SiteTree_Live"."Priority", "SiteTree_Live"."InheritBlockSets", "SiteTree_Live"."Latitude", "SiteTree_Live"."Longitude", "SiteTree_Live"."ShowMap", "SiteTree_Live"."StaticMap", "SiteTree_Live"."Address", "SiteTree_Live"."ZoomLevel", "SiteTree_Live"."InfoWindowContent", "SiteTree_Live"."MapHueColor", "SiteTree_Live"."MapSaturation", "SiteTree_Live"."MapLightness", "SiteTree_Live"."Version", "SiteTree_Live"."ParentID", "SiteTree_Live"."ID", CASE WHEN "SiteTree_Live"."ClassName" IS NOT NULL THEN "SiteTree_Live"."ClassName" ELSE 'SiteTree' END AS "RecordClassName" FROM "SiteTree_Live" WHERE ("SiteTree_Live"."ID" = ?) ORDER BY "SiteTree_Live"."Sort" ASC LIMIT 1 0.0006s

SELECT DISTINCT "SiteTree_versions"."ClassName", "SiteTree_versions"."LastEdited", "SiteTree_versions"."Created", "SiteTree_versions"."URLSegment", "SiteTree_versions"."Title", "SiteTree_versions"."MenuTitle", "SiteTree_versions"."Content", "SiteTree_versions"."MetaDescription", "SiteTree_versions"."ExtraMeta", "SiteTree_versions"."ShowInMenus", "SiteTree_versions"."ShowInSearch", "SiteTree_versions"."Sort", "SiteTree_versions"."HasBrokenFile", "SiteTree_versions"."HasBrokenLink", "SiteTree_versions"."ReportClass", "SiteTree_versions"."CanViewType", "SiteTree_versions"."CanEditType", "SiteTree_versions"."Priority", "SiteTree_versions"."InheritBlockSets", "SiteTree_versions"."Latitude", "SiteTree_versions"."Longitude", "SiteTree_versions"."ShowMap", "SiteTree_versions"."StaticMap", "SiteTree_versions"."Address", "SiteTree_versions"."ZoomLevel", "SiteTree_versions"."InfoWindowContent", "SiteTree_versions"."MapHueColor", "SiteTree_versions"."MapSaturation", "SiteTree_versions"."MapLightness", "SiteTree_versions"."Version", "SiteTree_versions"."ParentID", "SiteTree_versions"."RecordID" AS "ID", CASE WHEN "SiteTree_versions"."ClassName" IS NOT NULL THEN "SiteTree_versions"."ClassName" ELSE 'SiteTree' END AS "RecordClassName", "SiteTree_versions"."RecordID", "SiteTree_versions"."WasPublished", "SiteTree_versions"."AuthorID", "SiteTree_versions"."PublisherID" FROM "SiteTree_versions" WHERE ("SiteTree_versions"."RecordID" = 252) AND ("SiteTree_versions"."Version" IN (SELECT LatestVersion FROM (SELECT "SiteTree_versions"."RecordID", MAX("SiteTree_versions"."Version") AS LatestVersion FROM "SiteTree_versions" GROUP BY "SiteTree_versions"."RecordID" ) AS "SiteTree_versions_latest" WHERE "SiteTree_versions_latest"."RecordID" = "SiteTree_versions"."RecordID" )) ORDER BY "SiteTree_versions"."Sort" ASC LIMIT 1 0.0038s

SELECT DISTINCT "File"."ClassName", "File"."LastEdited", "File"."Created", "File"."Name", "File"."Title", "File"."Filename", "File"."Content", "File"."ShowInSearch", "File"."CanViewType", "File"."ParentID", "File"."OwnerID", "File"."ID", CASE WHEN "File"."ClassName" IS NOT NULL THEN "File"."ClassName" ELSE 'File' END AS "RecordClassName" FROM "File" WHERE ("File"."ID" = ?) ORDER BY "File"."Name" ASC LIMIT 1 0.0004s

SELECT DISTINCT count(DISTINCT "File"."ID") AS "Count" FROM "File" INNER JOIN "Page_PageDownloads" ON "Page_PageDownloads"."FileID" = "File"."ID" WHERE ("Page_PageDownloads"."PageID" = ?) 0.0008s

SELECT DISTINCT "Page_PageDownloads"."SortOrder", "File"."ClassName", "File"."LastEdited", "File"."Created", "File"."Name", "File"."Title", "File"."Filename", "File"."Content", "File"."ShowInSearch", "File"."CanViewType", "File"."ParentID", "File"."OwnerID", "File"."ID", CASE WHEN "File"."ClassName" IS NOT NULL THEN "File"."ClassName" ELSE 'File' END AS "RecordClassName" FROM "File" INNER JOIN "Page_PageDownloads" ON "Page_PageDownloads"."FileID" = "File"."ID" WHERE ("Page_PageDownloads"."PageID" = ?) ORDER BY "SortOrder" ASC 0.0128s

SELECT DISTINCT "File"."ClassName", "File"."LastEdited", "File"."Created", "File"."Name", "File"."Title", "File"."Filename", "File"."Content", "File"."ShowInSearch", "File"."CanViewType", "File"."ParentID", "File"."OwnerID", "Image"."FocusX", "Image"."FocusY", "File"."ID", CASE WHEN "File"."ClassName" IS NOT NULL THEN "File"."ClassName" ELSE 'File' END AS "RecordClassName" FROM "File" LEFT JOIN "Image" ON "Image"."ID" = "File"."ID" WHERE ("File"."ID" = ?) AND ("File"."ClassName" IN (?, ?, ?, ?)) ORDER BY "File"."Name" ASC LIMIT 1 0.016s

SELECT DISTINCT "SiteTree_versions"."ClassName", "SiteTree_versions"."LastEdited", "SiteTree_versions"."Created", "SiteTree_versions"."URLSegment", "SiteTree_versions"."Title", "SiteTree_versions"."MenuTitle", "SiteTree_versions"."Content", "SiteTree_versions"."MetaDescription", "SiteTree_versions"."ExtraMeta", "SiteTree_versions"."ShowInMenus", "SiteTree_versions"."ShowInSearch", "SiteTree_versions"."Sort", "SiteTree_versions"."HasBrokenFile", "SiteTree_versions"."HasBrokenLink", "SiteTree_versions"."ReportClass", "SiteTree_versions"."CanViewType", "SiteTree_versions"."CanEditType", "SiteTree_versions"."Priority", "SiteTree_versions"."InheritBlockSets", "SiteTree_versions"."Latitude", "SiteTree_versions"."Longitude", "SiteTree_versions"."ShowMap", "SiteTree_versions"."StaticMap", "SiteTree_versions"."Address", "SiteTree_versions"."ZoomLevel", "SiteTree_versions"."InfoWindowContent", "SiteTree_versions"."MapHueColor", "SiteTree_versions"."MapSaturation", "SiteTree_versions"."MapLightness", "SiteTree_versions"."Version", "SiteTree_versions"."ParentID", "SiteTree_versions"."RecordID" AS "ID", CASE WHEN "SiteTree_versions"."ClassName" IS NOT NULL THEN "SiteTree_versions"."ClassName" ELSE 'SiteTree' END AS "RecordClassName", "SiteTree_versions"."RecordID", "SiteTree_versions"."WasPublished", "SiteTree_versions"."AuthorID", "SiteTree_versions"."PublisherID" FROM "SiteTree_versions" WHERE ("SiteTree_versions"."RecordID" = 252) AND ("SiteTree_versions"."Version" IN (SELECT LatestVersion FROM (SELECT "SiteTree_versions"."RecordID", MAX("SiteTree_versions"."Version") AS LatestVersion FROM "SiteTree_versions" GROUP BY "SiteTree_versions"."RecordID" ) AS "SiteTree_versions_latest" WHERE "SiteTree_versions_latest"."RecordID" = "SiteTree_versions"."RecordID" )) ORDER BY "SiteTree_versions"."Sort" ASC LIMIT 1 0.006s

SELECT DISTINCT "SiteTree_versions"."ClassName", "SiteTree_versions"."LastEdited", "SiteTree_versions"."Created", "SiteTree_versions"."URLSegment", "SiteTree_versions"."Title", "SiteTree_versions"."MenuTitle", "SiteTree_versions"."Content", "SiteTree_versions"."MetaDescription", "SiteTree_versions"."ExtraMeta", "SiteTree_versions"."ShowInMenus", "SiteTree_versions"."ShowInSearch", "SiteTree_versions"."Sort", "SiteTree_versions"."HasBrokenFile", "SiteTree_versions"."HasBrokenLink", "SiteTree_versions"."ReportClass", "SiteTree_versions"."CanViewType", "SiteTree_versions"."CanEditType", "SiteTree_versions"."Priority", "SiteTree_versions"."InheritBlockSets", "SiteTree_versions"."Latitude", "SiteTree_versions"."Longitude", "SiteTree_versions"."ShowMap", "SiteTree_versions"."StaticMap", "SiteTree_versions"."Address", "SiteTree_versions"."ZoomLevel", "SiteTree_versions"."InfoWindowContent", "SiteTree_versions"."MapHueColor", "SiteTree_versions"."MapSaturation", "SiteTree_versions"."MapLightness", "SiteTree_versions"."Version", "SiteTree_versions"."ParentID", "SiteTree_versions"."RecordID" AS "ID", CASE WHEN "SiteTree_versions"."ClassName" IS NOT NULL THEN "SiteTree_versions"."ClassName" ELSE 'SiteTree' END AS "RecordClassName", "SiteTree_versions"."RecordID", "SiteTree_versions"."WasPublished", "SiteTree_versions"."AuthorID", "SiteTree_versions"."PublisherID" FROM "SiteTree_versions" WHERE ("SiteTree_versions"."RecordID" = 252) AND ("SiteTree_versions"."Version" IN (SELECT LatestVersion FROM (SELECT "SiteTree_versions"."RecordID", MAX("SiteTree_versions"."Version") AS LatestVersion FROM "SiteTree_versions" GROUP BY "SiteTree_versions"."RecordID" ) AS "SiteTree_versions_latest" WHERE "SiteTree_versions_latest"."RecordID" = "SiteTree_versions"."RecordID" )) ORDER BY "SiteTree_versions"."Sort" ASC LIMIT 1 0.0053s

SELECT DISTINCT "SiteTree_versions"."ClassName", "SiteTree_versions"."LastEdited", "SiteTree_versions"."Created", "SiteTree_versions"."URLSegment", "SiteTree_versions"."Title", "SiteTree_versions"."MenuTitle", "SiteTree_versions"."Content", "SiteTree_versions"."MetaDescription", "SiteTree_versions"."ExtraMeta", "SiteTree_versions"."ShowInMenus", "SiteTree_versions"."ShowInSearch", "SiteTree_versions"."Sort", "SiteTree_versions"."HasBrokenFile", "SiteTree_versions"."HasBrokenLink", "SiteTree_versions"."ReportClass", "SiteTree_versions"."CanViewType", "SiteTree_versions"."CanEditType", "SiteTree_versions"."Priority", "SiteTree_versions"."InheritBlockSets", "SiteTree_versions"."Latitude", "SiteTree_versions"."Longitude", "SiteTree_versions"."ShowMap", "SiteTree_versions"."StaticMap", "SiteTree_versions"."Address", "SiteTree_versions"."ZoomLevel", "SiteTree_versions"."InfoWindowContent", "SiteTree_versions"."MapHueColor", "SiteTree_versions"."MapSaturation", "SiteTree_versions"."MapLightness", "SiteTree_versions"."Version", "SiteTree_versions"."ParentID", "SiteTree_versions"."RecordID" AS "ID", CASE WHEN "SiteTree_versions"."ClassName" IS NOT NULL THEN "SiteTree_versions"."ClassName" ELSE 'SiteTree' END AS "RecordClassName", "SiteTree_versions"."RecordID", "SiteTree_versions"."WasPublished", "SiteTree_versions"."AuthorID", "SiteTree_versions"."PublisherID" FROM "SiteTree_versions" WHERE ("SiteTree_versions"."RecordID" = 252) AND ("SiteTree_versions"."Version" IN (SELECT LatestVersion FROM (SELECT "SiteTree_versions"."RecordID", MAX("SiteTree_versions"."Version") AS LatestVersion FROM "SiteTree_versions" GROUP BY "SiteTree_versions"."RecordID" ) AS "SiteTree_versions_latest" WHERE "SiteTree_versions_latest"."RecordID" = "SiteTree_versions"."RecordID" )) ORDER BY "SiteTree_versions"."Sort" ASC LIMIT 1 0.0048s

SELECT DISTINCT "SiteTree_versions"."ClassName", "SiteTree_versions"."LastEdited", "SiteTree_versions"."Created", "SiteTree_versions"."URLSegment", "SiteTree_versions"."Title", "SiteTree_versions"."MenuTitle", "SiteTree_versions"."Content", "SiteTree_versions"."MetaDescription", "SiteTree_versions"."ExtraMeta", "SiteTree_versions"."ShowInMenus", "SiteTree_versions"."ShowInSearch", "SiteTree_versions"."Sort", "SiteTree_versions"."HasBrokenFile", "SiteTree_versions"."HasBrokenLink", "SiteTree_versions"."ReportClass", "SiteTree_versions"."CanViewType", "SiteTree_versions"."CanEditType", "SiteTree_versions"."Priority", "SiteTree_versions"."InheritBlockSets", "SiteTree_versions"."Latitude", "SiteTree_versions"."Longitude", "SiteTree_versions"."ShowMap", "SiteTree_versions"."StaticMap", "SiteTree_versions"."Address", "SiteTree_versions"."ZoomLevel", "SiteTree_versions"."InfoWindowContent", "SiteTree_versions"."MapHueColor", "SiteTree_versions"."MapSaturation", "SiteTree_versions"."MapLightness", "SiteTree_versions"."Version", "SiteTree_versions"."ParentID", "SiteTree_versions"."RecordID" AS "ID", CASE WHEN "SiteTree_versions"."ClassName" IS NOT NULL THEN "SiteTree_versions"."ClassName" ELSE 'SiteTree' END AS "RecordClassName", "SiteTree_versions"."RecordID", "SiteTree_versions"."WasPublished", "SiteTree_versions"."AuthorID", "SiteTree_versions"."PublisherID" FROM "SiteTree_versions" WHERE ("SiteTree_versions"."RecordID" = 252) AND ("SiteTree_versions"."Version" IN (SELECT LatestVersion FROM (SELECT "SiteTree_versions"."RecordID", MAX("SiteTree_versions"."Version") AS LatestVersion FROM "SiteTree_versions" GROUP BY "SiteTree_versions"."RecordID" ) AS "SiteTree_versions_latest" WHERE "SiteTree_versions_latest"."RecordID" = "SiteTree_versions"."RecordID" )) ORDER BY "SiteTree_versions"."Sort" ASC LIMIT 1 0.0053s

SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."URLSegment", "SiteTree_Live"."Title", "SiteTree_Live"."MenuTitle", "SiteTree_Live"."Content", "SiteTree_Live"."MetaDescription", "SiteTree_Live"."ExtraMeta", "SiteTree_Live"."ShowInMenus", "SiteTree_Live"."ShowInSearch", "SiteTree_Live"."Sort", "SiteTree_Live"."HasBrokenFile", "SiteTree_Live"."HasBrokenLink", "SiteTree_Live"."ReportClass", "SiteTree_Live"."CanViewType", "SiteTree_Live"."CanEditType", "SiteTree_Live"."Priority", "SiteTree_Live"."InheritBlockSets", "SiteTree_Live"."Latitude", "SiteTree_Live"."Longitude", "SiteTree_Live"."ShowMap", "SiteTree_Live"."StaticMap", "SiteTree_Live"."Address", "SiteTree_Live"."ZoomLevel", "SiteTree_Live"."InfoWindowContent", "SiteTree_Live"."MapHueColor", "SiteTree_Live"."MapSaturation", "SiteTree_Live"."MapLightness", "SiteTree_Live"."Version", "SiteTree_Live"."ParentID", "SiteTree_Live"."ID", CASE WHEN "SiteTree_Live"."ClassName" IS NOT NULL THEN "SiteTree_Live"."ClassName" ELSE 'SiteTree' END AS "RecordClassName" FROM "SiteTree_Live" WHERE ("SiteTree_Live"."ShowInMenus" = ?) AND ("SiteTree_Live"."ParentID" = ?) ORDER BY "SiteTree_Live"."Sort" ASC 0.0354s

SELECT DISTINCT "File"."ClassName", "File"."LastEdited", "File"."Created", "File"."Name", "File"."Title", "File"."Filename", "File"."Content", "File"."ShowInSearch", "File"."CanViewType", "File"."ParentID", "File"."OwnerID", "Image"."FocusX", "Image"."FocusY", "File"."ID", CASE WHEN "File"."ClassName" IS NOT NULL THEN "File"."ClassName" ELSE 'File' END AS "RecordClassName" FROM "File" LEFT JOIN "Image" ON "Image"."ID" = "File"."ID" WHERE ("File"."ID" = ?) AND ("File"."ClassName" IN (?, ?, ?, ?)) ORDER BY "File"."Name" ASC LIMIT 1 0.0006s

SELECT DISTINCT "File"."ClassName", "File"."LastEdited", "File"."Created", "File"."Name", "File"."Title", "File"."Filename", "File"."Content", "File"."ShowInSearch", "File"."CanViewType", "File"."ParentID", "File"."OwnerID", "File"."ID", CASE WHEN "File"."ClassName" IS NOT NULL THEN "File"."ClassName" ELSE 'File' END AS "RecordClassName" FROM "File" WHERE ("File"."ID" = ?) ORDER BY "File"."Name" ASC LIMIT 1 0.0108s

SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."URLSegment", "SiteTree_Live"."Title", "SiteTree_Live"."MenuTitle", "SiteTree_Live"."Content", "SiteTree_Live"."MetaDescription", "SiteTree_Live"."ExtraMeta", "SiteTree_Live"."ShowInMenus", "SiteTree_Live"."ShowInSearch", "SiteTree_Live"."Sort", "SiteTree_Live"."HasBrokenFile", "SiteTree_Live"."HasBrokenLink", "SiteTree_Live"."ReportClass", "SiteTree_Live"."CanViewType", "SiteTree_Live"."CanEditType", "SiteTree_Live"."Priority", "SiteTree_Live"."InheritBlockSets", "SiteTree_Live"."Latitude", "SiteTree_Live"."Longitude", "SiteTree_Live"."ShowMap", "SiteTree_Live"."StaticMap", "SiteTree_Live"."Address", "SiteTree_Live"."ZoomLevel", "SiteTree_Live"."InfoWindowContent", "SiteTree_Live"."MapHueColor", "SiteTree_Live"."MapSaturation", "SiteTree_Live"."MapLightness", "SiteTree_Live"."Version", "SiteTree_Live"."ParentID", "SiteTree_Live"."ID", CASE WHEN "SiteTree_Live"."ClassName" IS NOT NULL THEN "SiteTree_Live"."ClassName" ELSE 'SiteTree' END AS "RecordClassName" FROM "SiteTree_Live" WHERE ("SiteTree_Live"."ShowInMenus" = ?) AND ("SiteTree_Live"."ParentID" = ?) ORDER BY "SiteTree_Live"."Sort" ASC 0.0013s

SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."URLSegment", "SiteTree_Live"."Title", "SiteTree_Live"."MenuTitle", "SiteTree_Live"."Content", "SiteTree_Live"."MetaDescription", "SiteTree_Live"."ExtraMeta", "SiteTree_Live"."ShowInMenus", "SiteTree_Live"."ShowInSearch", "SiteTree_Live"."Sort", "SiteTree_Live"."HasBrokenFile", "SiteTree_Live"."HasBrokenLink", "SiteTree_Live"."ReportClass", "SiteTree_Live"."CanViewType", "SiteTree_Live"."CanEditType", "SiteTree_Live"."Priority", "SiteTree_Live"."InheritBlockSets", "SiteTree_Live"."Latitude", "SiteTree_Live"."Longitude", "SiteTree_Live"."ShowMap", "SiteTree_Live"."StaticMap", "SiteTree_Live"."Address", "SiteTree_Live"."ZoomLevel", "SiteTree_Live"."InfoWindowContent", "SiteTree_Live"."MapHueColor", "SiteTree_Live"."MapSaturation", "SiteTree_Live"."MapLightness", "SiteTree_Live"."Version", "SiteTree_Live"."ParentID", "SiteTree_Live"."ID", CASE WHEN "SiteTree_Live"."ClassName" IS NOT NULL THEN "SiteTree_Live"."ClassName" ELSE 'SiteTree' END AS "RecordClassName" FROM "SiteTree_Live" WHERE ("SiteTree_Live"."ParentID" = ?) AND (("SiteTree_Live"."ID" != ?)) AND ("SiteTree_Live"."ShowInMenus" = ?) ORDER BY "SiteTree_Live"."Sort" ASC 0.0011s

SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."URLSegment", "SiteTree_Live"."Title", "SiteTree_Live"."MenuTitle", "SiteTree_Live"."Content", "SiteTree_Live"."MetaDescription", "SiteTree_Live"."ExtraMeta", "SiteTree_Live"."ShowInMenus", "SiteTree_Live"."ShowInSearch", "SiteTree_Live"."Sort", "SiteTree_Live"."HasBrokenFile", "SiteTree_Live"."HasBrokenLink", "SiteTree_Live"."ReportClass", "SiteTree_Live"."CanViewType", "SiteTree_Live"."CanEditType", "SiteTree_Live"."Priority", "SiteTree_Live"."InheritBlockSets", "SiteTree_Live"."Latitude", "SiteTree_Live"."Longitude", "SiteTree_Live"."ShowMap", "SiteTree_Live"."StaticMap", "SiteTree_Live"."Address", "SiteTree_Live"."ZoomLevel", "SiteTree_Live"."InfoWindowContent", "SiteTree_Live"."MapHueColor", "SiteTree_Live"."MapSaturation", "SiteTree_Live"."MapLightness", "SiteTree_Live"."Version", "SiteTree_Live"."ParentID", "SiteTree_Live"."ID", CASE WHEN "SiteTree_Live"."ClassName" IS NOT NULL THEN "SiteTree_Live"."ClassName" ELSE 'SiteTree' END AS "RecordClassName" FROM "SiteTree_Live" WHERE ("SiteTree_Live"."ParentID" = ?) AND (("SiteTree_Live"."ID" != ?)) AND ("SiteTree_Live"."ShowInMenus" = ?) ORDER BY "SiteTree_Live"."Sort" ASC 0.0175s

SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."URLSegment", "SiteTree_Live"."Title", "SiteTree_Live"."MenuTitle", "SiteTree_Live"."Content", "SiteTree_Live"."MetaDescription", "SiteTree_Live"."ExtraMeta", "SiteTree_Live"."ShowInMenus", "SiteTree_Live"."ShowInSearch", "SiteTree_Live"."Sort", "SiteTree_Live"."HasBrokenFile", "SiteTree_Live"."HasBrokenLink", "SiteTree_Live"."ReportClass", "SiteTree_Live"."CanViewType", "SiteTree_Live"."CanEditType", "SiteTree_Live"."Priority", "SiteTree_Live"."InheritBlockSets", "SiteTree_Live"."Latitude", "SiteTree_Live"."Longitude", "SiteTree_Live"."ShowMap", "SiteTree_Live"."StaticMap", "SiteTree_Live"."Address", "SiteTree_Live"."ZoomLevel", "SiteTree_Live"."InfoWindowContent", "SiteTree_Live"."MapHueColor", "SiteTree_Live"."MapSaturation", "SiteTree_Live"."MapLightness", "SiteTree_Live"."Version", "SiteTree_Live"."ParentID", "SiteTree_Live"."ID", CASE WHEN "SiteTree_Live"."ClassName" IS NOT NULL THEN "SiteTree_Live"."ClassName" ELSE 'SiteTree' END AS "RecordClassName" FROM "SiteTree_Live" WHERE ("SiteTree_Live"."ID" = ?) ORDER BY "SiteTree_Live"."Sort" ASC LIMIT 1 0.0009s

SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."URLSegment", "SiteTree_Live"."Title", "SiteTree_Live"."MenuTitle", "SiteTree_Live"."Content", "SiteTree_Live"."MetaDescription", "SiteTree_Live"."ExtraMeta", "SiteTree_Live"."ShowInMenus", "SiteTree_Live"."ShowInSearch", "SiteTree_Live"."Sort", "SiteTree_Live"."HasBrokenFile", "SiteTree_Live"."HasBrokenLink", "SiteTree_Live"."ReportClass", "SiteTree_Live"."CanViewType", "SiteTree_Live"."CanEditType", "SiteTree_Live"."Priority", "SiteTree_Live"."InheritBlockSets", "SiteTree_Live"."Latitude", "SiteTree_Live"."Longitude", "SiteTree_Live"."ShowMap", "SiteTree_Live"."StaticMap", "SiteTree_Live"."Address", "SiteTree_Live"."ZoomLevel", "SiteTree_Live"."InfoWindowContent", "SiteTree_Live"."MapHueColor", "SiteTree_Live"."MapSaturation", "SiteTree_Live"."MapLightness", "SiteTree_Live"."Version", "SiteTree_Live"."ParentID", "SiteTree_Live"."ID", CASE WHEN "SiteTree_Live"."ClassName" IS NOT NULL THEN "SiteTree_Live"."ClassName" ELSE 'SiteTree' END AS "RecordClassName" FROM "SiteTree_Live" WHERE ("SiteTree_Live"."ParentID" = ?) AND (("SiteTree_Live"."ID" != ?)) ORDER BY "SiteTree_Live"."Sort" ASC 0.0008s

SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."URLSegment", "SiteTree_Live"."Title", "SiteTree_Live"."MenuTitle", "SiteTree_Live"."Content", "SiteTree_Live"."MetaDescription", "SiteTree_Live"."ExtraMeta", "SiteTree_Live"."ShowInMenus", "SiteTree_Live"."ShowInSearch", "SiteTree_Live"."Sort", "SiteTree_Live"."HasBrokenFile", "SiteTree_Live"."HasBrokenLink", "SiteTree_Live"."ReportClass", "SiteTree_Live"."CanViewType", "SiteTree_Live"."CanEditType", "SiteTree_Live"."Priority", "SiteTree_Live"."InheritBlockSets", "SiteTree_Live"."Latitude", "SiteTree_Live"."Longitude", "SiteTree_Live"."ShowMap", "SiteTree_Live"."StaticMap", "SiteTree_Live"."Address", "SiteTree_Live"."ZoomLevel", "SiteTree_Live"."InfoWindowContent", "SiteTree_Live"."MapHueColor", "SiteTree_Live"."MapSaturation", "SiteTree_Live"."MapLightness", "SiteTree_Live"."Version", "SiteTree_Live"."ParentID", "SiteTree_Live"."ID", CASE WHEN "SiteTree_Live"."ClassName" IS NOT NULL THEN "SiteTree_Live"."ClassName" ELSE 'SiteTree' END AS "RecordClassName" FROM "SiteTree_Live" WHERE ("SiteTree_Live"."ParentID" = ?) AND (("SiteTree_Live"."ID" != ?)) AND ("SiteTree_Live"."ShowInMenus" = ?) ORDER BY "SiteTree_Live"."Sort" ASC 0.0018s

SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."URLSegment", "SiteTree_Live"."Title", "SiteTree_Live"."MenuTitle", "SiteTree_Live"."Content", "SiteTree_Live"."MetaDescription", "SiteTree_Live"."ExtraMeta", "SiteTree_Live"."ShowInMenus", "SiteTree_Live"."ShowInSearch", "SiteTree_Live"."Sort", "SiteTree_Live"."HasBrokenFile", "SiteTree_Live"."HasBrokenLink", "SiteTree_Live"."ReportClass", "SiteTree_Live"."CanViewType", "SiteTree_Live"."CanEditType", "SiteTree_Live"."Priority", "SiteTree_Live"."InheritBlockSets", "SiteTree_Live"."Latitude", "SiteTree_Live"."Longitude", "SiteTree_Live"."ShowMap", "SiteTree_Live"."StaticMap", "SiteTree_Live"."Address", "SiteTree_Live"."ZoomLevel", "SiteTree_Live"."InfoWindowContent", "SiteTree_Live"."MapHueColor", "SiteTree_Live"."MapSaturation", "SiteTree_Live"."MapLightness", "SiteTree_Live"."Version", "SiteTree_Live"."ParentID", "SiteTree_Live"."ID", CASE WHEN "SiteTree_Live"."ClassName" IS NOT NULL THEN "SiteTree_Live"."ClassName" ELSE 'SiteTree' END AS "RecordClassName" FROM "SiteTree_Live" WHERE ("SiteTree_Live"."ID" = ?) ORDER BY "SiteTree_Live"."Sort" ASC LIMIT 1 0.0005s

SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."URLSegment", "SiteTree_Live"."Title", "SiteTree_Live"."MenuTitle", "SiteTree_Live"."Content", "SiteTree_Live"."MetaDescription", "SiteTree_Live"."ExtraMeta", "SiteTree_Live"."ShowInMenus", "SiteTree_Live"."ShowInSearch", "SiteTree_Live"."Sort", "SiteTree_Live"."HasBrokenFile", "SiteTree_Live"."HasBrokenLink", "SiteTree_Live"."ReportClass", "SiteTree_Live"."CanViewType", "SiteTree_Live"."CanEditType", "SiteTree_Live"."Priority", "SiteTree_Live"."InheritBlockSets", "SiteTree_Live"."Latitude", "SiteTree_Live"."Longitude", "SiteTree_Live"."ShowMap", "SiteTree_Live"."StaticMap", "SiteTree_Live"."Address", "SiteTree_Live"."ZoomLevel", "SiteTree_Live"."InfoWindowContent", "SiteTree_Live"."MapHueColor", "SiteTree_Live"."MapSaturation", "SiteTree_Live"."MapLightness", "SiteTree_Live"."Version", "SiteTree_Live"."ParentID", "SiteTree_Live"."ID", CASE WHEN "SiteTree_Live"."ClassName" IS NOT NULL THEN "SiteTree_Live"."ClassName" ELSE 'SiteTree' END AS "RecordClassName" FROM "SiteTree_Live" WHERE ("SiteTree_Live"."ParentID" = ?) AND (("SiteTree_Live"."ID" != ?)) ORDER BY "SiteTree_Live"."Sort" ASC 0.0011s

SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."URLSegment", "SiteTree_Live"."Title", "SiteTree_Live"."MenuTitle", "SiteTree_Live"."Content", "SiteTree_Live"."MetaDescription", "SiteTree_Live"."ExtraMeta", "SiteTree_Live"."ShowInMenus", "SiteTree_Live"."ShowInSearch", "SiteTree_Live"."Sort", "SiteTree_Live"."HasBrokenFile", "SiteTree_Live"."HasBrokenLink", "SiteTree_Live"."ReportClass", "SiteTree_Live"."CanViewType", "SiteTree_Live"."CanEditType", "SiteTree_Live"."Priority", "SiteTree_Live"."InheritBlockSets", "SiteTree_Live"."Latitude", "SiteTree_Live"."Longitude", "SiteTree_Live"."ShowMap", "SiteTree_Live"."StaticMap", "SiteTree_Live"."Address", "SiteTree_Live"."ZoomLevel", "SiteTree_Live"."InfoWindowContent", "SiteTree_Live"."MapHueColor", "SiteTree_Live"."MapSaturation", "SiteTree_Live"."MapLightness", "SiteTree_Live"."Version", "SiteTree_Live"."ParentID", "SiteTree_Live"."ID", CASE WHEN "SiteTree_Live"."ClassName" IS NOT NULL THEN "SiteTree_Live"."ClassName" ELSE 'SiteTree' END AS "RecordClassName" FROM "SiteTree_Live" WHERE ("SiteTree_Live"."ParentID" = ?) AND (("SiteTree_Live"."ID" != ?)) AND ("SiteTree_Live"."ShowInMenus" = ?) ORDER BY "SiteTree_Live"."Sort" ASC 0.0011s

SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."URLSegment", "SiteTree_Live"."Title", "SiteTree_Live"."MenuTitle", "SiteTree_Live"."Content", "SiteTree_Live"."MetaDescription", "SiteTree_Live"."ExtraMeta", "SiteTree_Live"."ShowInMenus", "SiteTree_Live"."ShowInSearch", "SiteTree_Live"."Sort", "SiteTree_Live"."HasBrokenFile", "SiteTree_Live"."HasBrokenLink", "SiteTree_Live"."ReportClass", "SiteTree_Live"."CanViewType", "SiteTree_Live"."CanEditType", "SiteTree_Live"."Priority", "SiteTree_Live"."InheritBlockSets", "SiteTree_Live"."Latitude", "SiteTree_Live"."Longitude", "SiteTree_Live"."ShowMap", "SiteTree_Live"."StaticMap", "SiteTree_Live"."Address", "SiteTree_Live"."ZoomLevel", "SiteTree_Live"."InfoWindowContent", "SiteTree_Live"."MapHueColor", "SiteTree_Live"."MapSaturation", "SiteTree_Live"."MapLightness", "SiteTree_Live"."Version", "SiteTree_Live"."ParentID", "SiteTree_Live"."ID", CASE WHEN "SiteTree_Live"."ClassName" IS NOT NULL THEN "SiteTree_Live"."ClassName" ELSE 'SiteTree' END AS "RecordClassName" FROM "SiteTree_Live" WHERE ("SiteTree_Live"."ID" = ?) ORDER BY "SiteTree_Live"."Sort" ASC LIMIT 1 0.0005s

SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."URLSegment", "SiteTree_Live"."Title", "SiteTree_Live"."MenuTitle", "SiteTree_Live"."Content", "SiteTree_Live"."MetaDescription", "SiteTree_Live"."ExtraMeta", "SiteTree_Live"."ShowInMenus", "SiteTree_Live"."ShowInSearch", "SiteTree_Live"."Sort", "SiteTree_Live"."HasBrokenFile", "SiteTree_Live"."HasBrokenLink", "SiteTree_Live"."ReportClass", "SiteTree_Live"."CanViewType", "SiteTree_Live"."CanEditType", "SiteTree_Live"."Priority", "SiteTree_Live"."InheritBlockSets", "SiteTree_Live"."Latitude", "SiteTree_Live"."Longitude", "SiteTree_Live"."ShowMap", "SiteTree_Live"."StaticMap", "SiteTree_Live"."Address", "SiteTree_Live"."ZoomLevel", "SiteTree_Live"."InfoWindowContent", "SiteTree_Live"."MapHueColor", "SiteTree_Live"."MapSaturation", "SiteTree_Live"."MapLightness", "SiteTree_Live"."Version", "SiteTree_Live"."ParentID", "SiteTree_Live"."ID", CASE WHEN "SiteTree_Live"."ClassName" IS NOT NULL THEN "SiteTree_Live"."ClassName" ELSE 'SiteTree' END AS "RecordClassName" FROM "SiteTree_Live" WHERE ("SiteTree_Live"."ParentID" = ?) AND (("SiteTree_Live"."ID" != ?)) ORDER BY "SiteTree_Live"."Sort" ASC 0.0007s

SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."URLSegment", "SiteTree_Live"."Title", "SiteTree_Live"."MenuTitle", "SiteTree_Live"."Content", "SiteTree_Live"."MetaDescription", "SiteTree_Live"."ExtraMeta", "SiteTree_Live"."ShowInMenus", "SiteTree_Live"."ShowInSearch", "SiteTree_Live"."Sort", "SiteTree_Live"."HasBrokenFile", "SiteTree_Live"."HasBrokenLink", "SiteTree_Live"."ReportClass", "SiteTree_Live"."CanViewType", "SiteTree_Live"."CanEditType", "SiteTree_Live"."Priority", "SiteTree_Live"."InheritBlockSets", "SiteTree_Live"."Latitude", "SiteTree_Live"."Longitude", "SiteTree_Live"."ShowMap", "SiteTree_Live"."StaticMap", "SiteTree_Live"."Address", "SiteTree_Live"."ZoomLevel", "SiteTree_Live"."InfoWindowContent", "SiteTree_Live"."MapHueColor", "SiteTree_Live"."MapSaturation", "SiteTree_Live"."MapLightness", "SiteTree_Live"."Version", "SiteTree_Live"."ParentID", "SiteTree_Live"."ID", CASE WHEN "SiteTree_Live"."ClassName" IS NOT NULL THEN "SiteTree_Live"."ClassName" ELSE 'SiteTree' END AS "RecordClassName" FROM "SiteTree_Live" WHERE ("SiteTree_Live"."ParentID" = ?) AND (("SiteTree_Live"."ID" != ?)) AND ("SiteTree_Live"."ShowInMenus" = ?) ORDER BY "SiteTree_Live"."Sort" ASC 0.0007s

SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."URLSegment", "SiteTree_Live"."Title", "SiteTree_Live"."MenuTitle", "SiteTree_Live"."Content", "SiteTree_Live"."MetaDescription", "SiteTree_Live"."ExtraMeta", "SiteTree_Live"."ShowInMenus", "SiteTree_Live"."ShowInSearch", "SiteTree_Live"."Sort", "SiteTree_Live"."HasBrokenFile", "SiteTree_Live"."HasBrokenLink", "SiteTree_Live"."ReportClass", "SiteTree_Live"."CanViewType", "SiteTree_Live"."CanEditType", "SiteTree_Live"."Priority", "SiteTree_Live"."InheritBlockSets", "SiteTree_Live"."Latitude", "SiteTree_Live"."Longitude", "SiteTree_Live"."ShowMap", "SiteTree_Live"."StaticMap", "SiteTree_Live"."Address", "SiteTree_Live"."ZoomLevel", "SiteTree_Live"."InfoWindowContent", "SiteTree_Live"."MapHueColor", "SiteTree_Live"."MapSaturation", "SiteTree_Live"."MapLightness", "SiteTree_Live"."Version", "SiteTree_Live"."ParentID", "SiteTree_Live"."ID", CASE WHEN "SiteTree_Live"."ClassName" IS NOT NULL THEN "SiteTree_Live"."ClassName" ELSE 'SiteTree' END AS "RecordClassName" FROM "SiteTree_Live" WHERE ("SiteTree_Live"."ID" = ?) ORDER BY "SiteTree_Live"."Sort" ASC LIMIT 1 0.0006s

SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."URLSegment", "SiteTree_Live"."Title", "SiteTree_Live"."MenuTitle", "SiteTree_Live"."Content", "SiteTree_Live"."MetaDescription", "SiteTree_Live"."ExtraMeta", "SiteTree_Live"."ShowInMenus", "SiteTree_Live"."ShowInSearch", "SiteTree_Live"."Sort", "SiteTree_Live"."HasBrokenFile", "SiteTree_Live"."HasBrokenLink", "SiteTree_Live"."ReportClass", "SiteTree_Live"."CanViewType", "SiteTree_Live"."CanEditType", "SiteTree_Live"."Priority", "SiteTree_Live"."InheritBlockSets", "SiteTree_Live"."Latitude", "SiteTree_Live"."Longitude", "SiteTree_Live"."ShowMap", "SiteTree_Live"."StaticMap", "SiteTree_Live"."Address", "SiteTree_Live"."ZoomLevel", "SiteTree_Live"."InfoWindowContent", "SiteTree_Live"."MapHueColor", "SiteTree_Live"."MapSaturation", "SiteTree_Live"."MapLightness", "SiteTree_Live"."Version", "SiteTree_Live"."ParentID", "SiteTree_Live"."ID", CASE WHEN "SiteTree_Live"."ClassName" IS NOT NULL THEN "SiteTree_Live"."ClassName" ELSE 'SiteTree' END AS "RecordClassName" FROM "SiteTree_Live" WHERE ("SiteTree_Live"."ParentID" = ?) AND (("SiteTree_Live"."ID" != ?)) ORDER BY "SiteTree_Live"."Sort" ASC 0.0006s

SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."URLSegment", "SiteTree_Live"."Title", "SiteTree_Live"."MenuTitle", "SiteTree_Live"."Content", "SiteTree_Live"."MetaDescription", "SiteTree_Live"."ExtraMeta", "SiteTree_Live"."ShowInMenus", "SiteTree_Live"."ShowInSearch", "SiteTree_Live"."Sort", "SiteTree_Live"."HasBrokenFile", "SiteTree_Live"."HasBrokenLink", "SiteTree_Live"."ReportClass", "SiteTree_Live"."CanViewType", "SiteTree_Live"."CanEditType", "SiteTree_Live"."Priority", "SiteTree_Live"."InheritBlockSets", "SiteTree_Live"."Latitude", "SiteTree_Live"."Longitude", "SiteTree_Live"."ShowMap", "SiteTree_Live"."StaticMap", "SiteTree_Live"."Address", "SiteTree_Live"."ZoomLevel", "SiteTree_Live"."InfoWindowContent", "SiteTree_Live"."MapHueColor", "SiteTree_Live"."MapSaturation", "SiteTree_Live"."MapLightness", "SiteTree_Live"."Version", "SiteTree_Live"."ParentID", "SiteTree_Live"."ID", CASE WHEN "SiteTree_Live"."ClassName" IS NOT NULL THEN "SiteTree_Live"."ClassName" ELSE 'SiteTree' END AS "RecordClassName" FROM "SiteTree_Live" WHERE ("SiteTree_Live"."ParentID" = ?) AND (("SiteTree_Live"."ID" != ?)) AND ("SiteTree_Live"."ShowInMenus" = ?) ORDER BY "SiteTree_Live"."Sort" ASC 0.0012s

SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."URLSegment", "SiteTree_Live"."Title", "SiteTree_Live"."MenuTitle", "SiteTree_Live"."Content", "SiteTree_Live"."MetaDescription", "SiteTree_Live"."ExtraMeta", "SiteTree_Live"."ShowInMenus", "SiteTree_Live"."ShowInSearch", "SiteTree_Live"."Sort", "SiteTree_Live"."HasBrokenFile", "SiteTree_Live"."HasBrokenLink", "SiteTree_Live"."ReportClass", "SiteTree_Live"."CanViewType", "SiteTree_Live"."CanEditType", "SiteTree_Live"."Priority", "SiteTree_Live"."InheritBlockSets", "SiteTree_Live"."Latitude", "SiteTree_Live"."Longitude", "SiteTree_Live"."ShowMap", "SiteTree_Live"."StaticMap", "SiteTree_Live"."Address", "SiteTree_Live"."ZoomLevel", "SiteTree_Live"."InfoWindowContent", "SiteTree_Live"."MapHueColor", "SiteTree_Live"."MapSaturation", "SiteTree_Live"."MapLightness", "SiteTree_Live"."Version", "SiteTree_Live"."ParentID", "SiteTree_Live"."ID", CASE WHEN "SiteTree_Live"."ClassName" IS NOT NULL THEN "SiteTree_Live"."ClassName" ELSE 'SiteTree' END AS "RecordClassName" FROM "SiteTree_Live" WHERE ("SiteTree_Live"."ID" = ?) ORDER BY "SiteTree_Live"."Sort" ASC LIMIT 1 0.0005s

SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."URLSegment", "SiteTree_Live"."Title", "SiteTree_Live"."MenuTitle", "SiteTree_Live"."Content", "SiteTree_Live"."MetaDescription", "SiteTree_Live"."ExtraMeta", "SiteTree_Live"."ShowInMenus", "SiteTree_Live"."ShowInSearch", "SiteTree_Live"."Sort", "SiteTree_Live"."HasBrokenFile", "SiteTree_Live"."HasBrokenLink", "SiteTree_Live"."ReportClass", "SiteTree_Live"."CanViewType", "SiteTree_Live"."CanEditType", "SiteTree_Live"."Priority", "SiteTree_Live"."InheritBlockSets", "SiteTree_Live"."Latitude", "SiteTree_Live"."Longitude", "SiteTree_Live"."ShowMap", "SiteTree_Live"."StaticMap", "SiteTree_Live"."Address", "SiteTree_Live"."ZoomLevel", "SiteTree_Live"."InfoWindowContent", "SiteTree_Live"."MapHueColor", "SiteTree_Live"."MapSaturation", "SiteTree_Live"."MapLightness", "SiteTree_Live"."Version", "SiteTree_Live"."ParentID", "SiteTree_Live"."ID", CASE WHEN "SiteTree_Live"."ClassName" IS NOT NULL THEN "SiteTree_Live"."ClassName" ELSE 'SiteTree' END AS "RecordClassName" FROM "SiteTree_Live" WHERE ("SiteTree_Live"."ParentID" = ?) AND (("SiteTree_Live"."ID" != ?)) ORDER BY "SiteTree_Live"."Sort" ASC 0.0011s

SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."URLSegment", "SiteTree_Live"."Title", "SiteTree_Live"."MenuTitle", "SiteTree_Live"."Content", "SiteTree_Live"."MetaDescription", "SiteTree_Live"."ExtraMeta", "SiteTree_Live"."ShowInMenus", "SiteTree_Live"."ShowInSearch", "SiteTree_Live"."Sort", "SiteTree_Live"."HasBrokenFile", "SiteTree_Live"."HasBrokenLink", "SiteTree_Live"."ReportClass", "SiteTree_Live"."CanViewType", "SiteTree_Live"."CanEditType", "SiteTree_Live"."Priority", "SiteTree_Live"."InheritBlockSets", "SiteTree_Live"."Latitude", "SiteTree_Live"."Longitude", "SiteTree_Live"."ShowMap", "SiteTree_Live"."StaticMap", "SiteTree_Live"."Address", "SiteTree_Live"."ZoomLevel", "SiteTree_Live"."InfoWindowContent", "SiteTree_Live"."MapHueColor", "SiteTree_Live"."MapSaturation", "SiteTree_Live"."MapLightness", "SiteTree_Live"."Version", "SiteTree_Live"."ParentID", "SiteTree_Live"."ID", CASE WHEN "SiteTree_Live"."ClassName" IS NOT NULL THEN "SiteTree_Live"."ClassName" ELSE 'SiteTree' END AS "RecordClassName" FROM "SiteTree_Live" INNER JOIN "BlogPost_Live" ON "BlogPost_Live"."ID" = "SiteTree_Live"."ID" WHERE ("SiteTree_Live"."ParentID" = ?) AND (("SiteTree_Live"."ID" != ?)) AND ("SiteTree_Live"."ShowInMenus" = ?) AND ("PublishDate" < '2019-07-24 19:48:31') ORDER BY "SiteTree_Live"."Sort" ASC 0.0303s

SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."URLSegment", "SiteTree_Live"."Title", "SiteTree_Live"."MenuTitle", "SiteTree_Live"."Content", "SiteTree_Live"."MetaDescription", "SiteTree_Live"."ExtraMeta", "SiteTree_Live"."ShowInMenus", "SiteTree_Live"."ShowInSearch", "SiteTree_Live"."Sort", "SiteTree_Live"."HasBrokenFile", "SiteTree_Live"."HasBrokenLink", "SiteTree_Live"."ReportClass", "SiteTree_Live"."CanViewType", "SiteTree_Live"."CanEditType", "SiteTree_Live"."Priority", "SiteTree_Live"."InheritBlockSets", "SiteTree_Live"."Latitude", "SiteTree_Live"."Longitude", "SiteTree_Live"."ShowMap", "SiteTree_Live"."StaticMap", "SiteTree_Live"."Address", "SiteTree_Live"."ZoomLevel", "SiteTree_Live"."InfoWindowContent", "SiteTree_Live"."MapHueColor", "SiteTree_Live"."MapSaturation", "SiteTree_Live"."MapLightness", "SiteTree_Live"."Version", "SiteTree_Live"."ParentID", "SiteTree_Live"."ID", CASE WHEN "SiteTree_Live"."ClassName" IS NOT NULL THEN "SiteTree_Live"."ClassName" ELSE 'SiteTree' END AS "RecordClassName" FROM "SiteTree_Live" WHERE ("SiteTree_Live"."ParentID" = ?) AND (("SiteTree_Live"."ID" != ?)) AND ("SiteTree_Live"."ShowInMenus" = ?) ORDER BY "SiteTree_Live"."Sort" ASC 0.0008s

SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."URLSegment", "SiteTree_Live"."Title", "SiteTree_Live"."MenuTitle", "SiteTree_Live"."Content", "SiteTree_Live"."MetaDescription", "SiteTree_Live"."ExtraMeta", "SiteTree_Live"."ShowInMenus", "SiteTree_Live"."ShowInSearch", "SiteTree_Live"."Sort", "SiteTree_Live"."HasBrokenFile", "SiteTree_Live"."HasBrokenLink", "SiteTree_Live"."ReportClass", "SiteTree_Live"."CanViewType", "SiteTree_Live"."CanEditType", "SiteTree_Live"."Priority", "SiteTree_Live"."InheritBlockSets", "SiteTree_Live"."Latitude", "SiteTree_Live"."Longitude", "SiteTree_Live"."ShowMap", "SiteTree_Live"."StaticMap", "SiteTree_Live"."Address", "SiteTree_Live"."ZoomLevel", "SiteTree_Live"."InfoWindowContent", "SiteTree_Live"."MapHueColor", "SiteTree_Live"."MapSaturation", "SiteTree_Live"."MapLightness", "SiteTree_Live"."Version", "SiteTree_Live"."ParentID", "SiteTree_Live"."ID", CASE WHEN "SiteTree_Live"."ClassName" IS NOT NULL THEN "SiteTree_Live"."ClassName" ELSE 'SiteTree' END AS "RecordClassName" FROM "SiteTree_Live" WHERE ("SiteTree_Live"."ID" = ?) ORDER BY "SiteTree_Live"."Sort" ASC LIMIT 1 0.0008s

SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."URLSegment", "SiteTree_Live"."Title", "SiteTree_Live"."MenuTitle", "SiteTree_Live"."Content", "SiteTree_Live"."MetaDescription", "SiteTree_Live"."ExtraMeta", "SiteTree_Live"."ShowInMenus", "SiteTree_Live"."ShowInSearch", "SiteTree_Live"."Sort", "SiteTree_Live"."HasBrokenFile", "SiteTree_Live"."HasBrokenLink", "SiteTree_Live"."ReportClass", "SiteTree_Live"."CanViewType", "SiteTree_Live"."CanEditType", "SiteTree_Live"."Priority", "SiteTree_Live"."InheritBlockSets", "SiteTree_Live"."Latitude", "SiteTree_Live"."Longitude", "SiteTree_Live"."ShowMap", "SiteTree_Live"."StaticMap", "SiteTree_Live"."Address", "SiteTree_Live"."ZoomLevel", "SiteTree_Live"."InfoWindowContent", "SiteTree_Live"."MapHueColor", "SiteTree_Live"."MapSaturation", "SiteTree_Live"."MapLightness", "SiteTree_Live"."Version", "SiteTree_Live"."ParentID", "SiteTree_Live"."ID", CASE WHEN "SiteTree_Live"."ClassName" IS NOT NULL THEN "SiteTree_Live"."ClassName" ELSE 'SiteTree' END AS "RecordClassName" FROM "SiteTree_Live" WHERE ("SiteTree_Live"."ParentID" = ?) AND (("SiteTree_Live"."ID" != ?)) ORDER BY "SiteTree_Live"."Sort" ASC 0.0007s

SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "RedirectorPage_Live"."RedirectionType", "RedirectorPage_Live"."ExternalURL", "RedirectorPage_Live"."LinkToID", "SiteTree_Live"."ID", CASE WHEN "SiteTree_Live"."ClassName" IS NOT NULL THEN "SiteTree_Live"."ClassName" ELSE 'SiteTree' END AS "RecordClassName", "SiteTree_Live"."Sort" FROM "SiteTree_Live" LEFT JOIN "Page_Live" ON "Page_Live"."ID" = "SiteTree_Live"."ID" LEFT JOIN "RedirectorPage_Live" ON "RedirectorPage_Live"."ID" = "SiteTree_Live"."ID" WHERE ("RedirectorPage_Live"."ID" = 286) AND ("SiteTree_Live"."ClassName" IN (?)) ORDER BY "SiteTree_Live"."Sort" ASC LIMIT 1 0.0122s

SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."URLSegment", "SiteTree_Live"."Title", "SiteTree_Live"."MenuTitle", "SiteTree_Live"."Content", "SiteTree_Live"."MetaDescription", "SiteTree_Live"."ExtraMeta", "SiteTree_Live"."ShowInMenus", "SiteTree_Live"."ShowInSearch", "SiteTree_Live"."Sort", "SiteTree_Live"."HasBrokenFile", "SiteTree_Live"."HasBrokenLink", "SiteTree_Live"."ReportClass", "SiteTree_Live"."CanViewType", "SiteTree_Live"."CanEditType", "SiteTree_Live"."Priority", "SiteTree_Live"."InheritBlockSets", "SiteTree_Live"."Latitude", "SiteTree_Live"."Longitude", "SiteTree_Live"."ShowMap", "SiteTree_Live"."StaticMap", "SiteTree_Live"."Address", "SiteTree_Live"."ZoomLevel", "SiteTree_Live"."InfoWindowContent", "SiteTree_Live"."MapHueColor", "SiteTree_Live"."MapSaturation", "SiteTree_Live"."MapLightness", "SiteTree_Live"."Version", "SiteTree_Live"."ParentID", "SiteTree_Live"."ID", CASE WHEN "SiteTree_Live"."ClassName" IS NOT NULL THEN "SiteTree_Live"."ClassName" ELSE 'SiteTree' END AS "RecordClassName" FROM "SiteTree_Live" WHERE ("SiteTree_Live"."ParentID" = ?) AND (("SiteTree_Live"."ID" != ?)) AND ("SiteTree_Live"."ShowInMenus" = ?) ORDER BY "SiteTree_Live"."Sort" ASC 0.0006s

SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."URLSegment", "SiteTree_Live"."Title", "SiteTree_Live"."MenuTitle", "SiteTree_Live"."Content", "SiteTree_Live"."MetaDescription", "SiteTree_Live"."ExtraMeta", "SiteTree_Live"."ShowInMenus", "SiteTree_Live"."ShowInSearch", "SiteTree_Live"."Sort", "SiteTree_Live"."HasBrokenFile", "SiteTree_Live"."HasBrokenLink", "SiteTree_Live"."ReportClass", "SiteTree_Live"."CanViewType", "SiteTree_Live"."CanEditType", "SiteTree_Live"."Priority", "SiteTree_Live"."InheritBlockSets", "SiteTree_Live"."Latitude", "SiteTree_Live"."Longitude", "SiteTree_Live"."ShowMap", "SiteTree_Live"."StaticMap", "SiteTree_Live"."Address", "SiteTree_Live"."ZoomLevel", "SiteTree_Live"."InfoWindowContent", "SiteTree_Live"."MapHueColor", "SiteTree_Live"."MapSaturation", "SiteTree_Live"."MapLightness", "SiteTree_Live"."Version", "SiteTree_Live"."ParentID", "SiteTree_Live"."ID", CASE WHEN "SiteTree_Live"."ClassName" IS NOT NULL THEN "SiteTree_Live"."ClassName" ELSE 'SiteTree' END AS "RecordClassName" FROM "SiteTree_Live" WHERE ("SiteTree_Live"."ParentID" = ?) AND (("SiteTree_Live"."ID" != ?)) AND ("SiteTree_Live"."ShowInMenus" = ?) ORDER BY "SiteTree_Live"."Sort" ASC 0.0011s

SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."URLSegment", "SiteTree_Live"."Title", "SiteTree_Live"."MenuTitle", "SiteTree_Live"."Content", "SiteTree_Live"."MetaDescription", "SiteTree_Live"."ExtraMeta", "SiteTree_Live"."ShowInMenus", "SiteTree_Live"."ShowInSearch", "SiteTree_Live"."Sort", "SiteTree_Live"."HasBrokenFile", "SiteTree_Live"."HasBrokenLink", "SiteTree_Live"."ReportClass", "SiteTree_Live"."CanViewType", "SiteTree_Live"."CanEditType", "SiteTree_Live"."Priority", "SiteTree_Live"."InheritBlockSets", "SiteTree_Live"."Latitude", "SiteTree_Live"."Longitude", "SiteTree_Live"."ShowMap", "SiteTree_Live"."StaticMap", "SiteTree_Live"."Address", "SiteTree_Live"."ZoomLevel", "SiteTree_Live"."InfoWindowContent", "SiteTree_Live"."MapHueColor", "SiteTree_Live"."MapSaturation", "SiteTree_Live"."MapLightness", "SiteTree_Live"."Version", "SiteTree_Live"."ParentID", "SiteTree_Live"."ID", CASE WHEN "SiteTree_Live"."ClassName" IS NOT NULL THEN "SiteTree_Live"."ClassName" ELSE 'SiteTree' END AS "RecordClassName" FROM "SiteTree_Live" WHERE ("SiteTree_Live"."ParentID" = ?) AND (("SiteTree_Live"."ID" != ?)) ORDER BY "SiteTree_Live"."Sort" ASC 0.0007s

SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."URLSegment", "SiteTree_Live"."Title", "SiteTree_Live"."MenuTitle", "SiteTree_Live"."Content", "SiteTree_Live"."MetaDescription", "SiteTree_Live"."ExtraMeta", "SiteTree_Live"."ShowInMenus", "SiteTree_Live"."ShowInSearch", "SiteTree_Live"."Sort", "SiteTree_Live"."HasBrokenFile", "SiteTree_Live"."HasBrokenLink", "SiteTree_Live"."ReportClass", "SiteTree_Live"."CanViewType", "SiteTree_Live"."CanEditType", "SiteTree_Live"."Priority", "SiteTree_Live"."InheritBlockSets", "SiteTree_Live"."Latitude", "SiteTree_Live"."Longitude", "SiteTree_Live"."ShowMap", "SiteTree_Live"."StaticMap", "SiteTree_Live"."Address", "SiteTree_Live"."ZoomLevel", "SiteTree_Live"."InfoWindowContent", "SiteTree_Live"."MapHueColor", "SiteTree_Live"."MapSaturation", "SiteTree_Live"."MapLightness", "SiteTree_Live"."Version", "SiteTree_Live"."ParentID", "SiteTree_Live"."ID", CASE WHEN "SiteTree_Live"."ClassName" IS NOT NULL THEN "SiteTree_Live"."ClassName" ELSE 'SiteTree' END AS "RecordClassName" FROM "SiteTree_Live" WHERE ("SiteTree_Live"."ParentID" = ?) AND (("SiteTree_Live"."ID" != ?)) AND ("SiteTree_Live"."ShowInMenus" = ?) ORDER BY "SiteTree_Live"."Sort" ASC 0.0008s

SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."URLSegment", "SiteTree_Live"."Title", "SiteTree_Live"."MenuTitle", "SiteTree_Live"."Content", "SiteTree_Live"."MetaDescription", "SiteTree_Live"."ExtraMeta", "SiteTree_Live"."ShowInMenus", "SiteTree_Live"."ShowInSearch", "SiteTree_Live"."Sort", "SiteTree_Live"."HasBrokenFile", "SiteTree_Live"."HasBrokenLink", "SiteTree_Live"."ReportClass", "SiteTree_Live"."CanViewType", "SiteTree_Live"."CanEditType", "SiteTree_Live"."Priority", "SiteTree_Live"."InheritBlockSets", "SiteTree_Live"."Latitude", "SiteTree_Live"."Longitude", "SiteTree_Live"."ShowMap", "SiteTree_Live"."StaticMap", "SiteTree_Live"."Address", "SiteTree_Live"."ZoomLevel", "SiteTree_Live"."InfoWindowContent", "SiteTree_Live"."MapHueColor", "SiteTree_Live"."MapSaturation", "SiteTree_Live"."MapLightness", "SiteTree_Live"."Version", "SiteTree_Live"."ParentID", "SiteTree_Live"."ID", CASE WHEN "SiteTree_Live"."ClassName" IS NOT NULL THEN "SiteTree_Live"."ClassName" ELSE 'SiteTree' END AS "RecordClassName" FROM "SiteTree_Live" WHERE ("SiteTree_Live"."ID" = ?) ORDER BY "SiteTree_Live"."Sort" ASC LIMIT 1 0.0004s

SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."URLSegment", "SiteTree_Live"."Title", "SiteTree_Live"."MenuTitle", "SiteTree_Live"."Content", "SiteTree_Live"."MetaDescription", "SiteTree_Live"."ExtraMeta", "SiteTree_Live"."ShowInMenus", "SiteTree_Live"."ShowInSearch", "SiteTree_Live"."Sort", "SiteTree_Live"."HasBrokenFile", "SiteTree_Live"."HasBrokenLink", "SiteTree_Live"."ReportClass", "SiteTree_Live"."CanViewType", "SiteTree_Live"."CanEditType", "SiteTree_Live"."Priority", "SiteTree_Live"."InheritBlockSets", "SiteTree_Live"."Latitude", "SiteTree_Live"."Longitude", "SiteTree_Live"."ShowMap", "SiteTree_Live"."StaticMap", "SiteTree_Live"."Address", "SiteTree_Live"."ZoomLevel", "SiteTree_Live"."InfoWindowContent", "SiteTree_Live"."MapHueColor", "SiteTree_Live"."MapSaturation", "SiteTree_Live"."MapLightness", "SiteTree_Live"."Version", "SiteTree_Live"."ParentID", "SiteTree_Live"."ID", CASE WHEN "SiteTree_Live"."ClassName" IS NOT NULL THEN "SiteTree_Live"."ClassName" ELSE 'SiteTree' END AS "RecordClassName" FROM "SiteTree_Live" WHERE ("SiteTree_Live"."ParentID" = ?) AND (("SiteTree_Live"."ID" != ?)) ORDER BY "SiteTree_Live"."Sort" ASC 0.0006s

SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."URLSegment", "SiteTree_Live"."Title", "SiteTree_Live"."MenuTitle", "SiteTree_Live"."Content", "SiteTree_Live"."MetaDescription", "SiteTree_Live"."ExtraMeta", "SiteTree_Live"."ShowInMenus", "SiteTree_Live"."ShowInSearch", "SiteTree_Live"."Sort", "SiteTree_Live"."HasBrokenFile", "SiteTree_Live"."HasBrokenLink", "SiteTree_Live"."ReportClass", "SiteTree_Live"."CanViewType", "SiteTree_Live"."CanEditType", "SiteTree_Live"."Priority", "SiteTree_Live"."InheritBlockSets", "SiteTree_Live"."Latitude", "SiteTree_Live"."Longitude", "SiteTree_Live"."ShowMap", "SiteTree_Live"."StaticMap", "SiteTree_Live"."Address", "SiteTree_Live"."ZoomLevel", "SiteTree_Live"."InfoWindowContent", "SiteTree_Live"."MapHueColor", "SiteTree_Live"."MapSaturation", "SiteTree_Live"."MapLightness", "SiteTree_Live"."Version", "SiteTree_Live"."ParentID", "SiteTree_Live"."ID", CASE WHEN "SiteTree_Live"."ClassName" IS NOT NULL THEN "SiteTree_Live"."ClassName" ELSE 'SiteTree' END AS "RecordClassName" FROM "SiteTree_Live" WHERE ("SiteTree_Live"."ParentID" = ?) AND (("SiteTree_Live"."ID" != ?)) AND ("SiteTree_Live"."ShowInMenus" = ?) ORDER BY "SiteTree_Live"."Sort" ASC 0.0006s

SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."URLSegment", "SiteTree_Live"."Title", "SiteTree_Live"."MenuTitle", "SiteTree_Live"."Content", "SiteTree_Live"."MetaDescription", "SiteTree_Live"."ExtraMeta", "SiteTree_Live"."ShowInMenus", "SiteTree_Live"."ShowInSearch", "SiteTree_Live"."Sort", "SiteTree_Live"."HasBrokenFile", "SiteTree_Live"."HasBrokenLink", "SiteTree_Live"."ReportClass", "SiteTree_Live"."CanViewType", "SiteTree_Live"."CanEditType", "SiteTree_Live"."Priority", "SiteTree_Live"."InheritBlockSets", "SiteTree_Live"."Latitude", "SiteTree_Live"."Longitude", "SiteTree_Live"."ShowMap", "SiteTree_Live"."StaticMap", "SiteTree_Live"."Address", "SiteTree_Live"."ZoomLevel", "SiteTree_Live"."InfoWindowContent", "SiteTree_Live"."MapHueColor", "SiteTree_Live"."MapSaturation", "SiteTree_Live"."MapLightness", "SiteTree_Live"."Version", "SiteTree_Live"."ParentID", "SiteTree_Live"."ID", CASE WHEN "SiteTree_Live"."ClassName" IS NOT NULL THEN "SiteTree_Live"."ClassName" ELSE 'SiteTree' END AS "RecordClassName" FROM "SiteTree_Live" WHERE ("SiteTree_Live"."ParentID" = ?) AND (("SiteTree_Live"."ID" != ?)) AND ("SiteTree_Live"."ShowInMenus" = ?) ORDER BY "SiteTree_Live"."Sort" ASC 0.0006s

SELECT DISTINCT "UniadsZone"."ClassName", "UniadsZone"."LastEdited", "UniadsZone"."Created", "UniadsZone"."Title", "UniadsZone"."ZoneWidth", "UniadsZone"."ZoneHeight", "UniadsZone"."Order", "UniadsZone"."Active", "UniadsZone"."ParentZoneID", "UniadsZone"."ID", CASE WHEN "UniadsZone"."ClassName" IS NOT NULL THEN "UniadsZone"."ClassName" ELSE 'UniadsZone' END AS "RecordClassName" FROM "UniadsZone" WHERE ("UniadsZone"."Title" = ?) AND ("UniadsZone"."Active" = ?) ORDER BY "UniadsZone"."ParentZoneID" ASC, "UniadsZone"."Order" ASC, "UniadsZone"."ID" ASC LIMIT 1 0.0023s

SELECT UniadsObject.ID, rand() AS "_SortColumn0" FROM UniadsObject left join UniadsCampaign c on c.ID = UniadsObject.CampaignID WHERE ( UniadsObject.ZoneID = '1' and ( exists (select * from Page_Ads pa where pa.UniadsObjectID = UniadsObject.ID and pa.PageID = 248) or not exists (select * from Page_Ads pa where pa.UniadsObjectID = UniadsObject.ID) ) and (c.ID is null or ( c.Active = '1' and (c.Starts <= '2019-07-24' or c.Starts = '' or c.Starts is null) and (c.Expires >= '2019-07-24' or c.Expires = '' or c.Expires is null) )) and (UniadsObject.Starts <= '2019-07-24' or UniadsObject.Starts = '' or UniadsObject.Starts is null) and (UniadsObject.Expires >= '2019-07-24' or UniadsObject.Expires = '' or UniadsObject.Expires is null) and UniadsObject.Active = '1' and (UniadsObject.ImpressionLimit = 0 or UniadsObject.ImpressionLimit > UniadsObject.Impressions) and UniadsObject.Weight >= (rand() * ( select max(UniadsObjectUniadsObject.Weight) from UniadsObject as UniadsObjectUniadsObject left join UniadsCampaign cc on cc.ID = UniadsObjectUniadsObject.CampaignID where UniadsObjectUniadsObject.ZoneID = '1' and ( exists (select * from Page_Ads pa where pa.UniadsObjectID = UniadsObjectUniadsObject.ID and pa.PageID = 248) or not exists (select * from Page_Ads pa where pa.UniadsObjectID = UniadsObjectUniadsObject.ID) ) and (cc.ID is null or ( cc.Active = '1' and (cc.Starts <= '2019-07-24' or cc.Starts = '' or cc.Starts is null) and (cc.Expires >= '2019-07-24' or cc.Expires = '' or cc.Expires is null) )) and (UniadsObjectUniadsObject.Starts <= '2019-07-24' or UniadsObjectUniadsObject.Starts = '' or UniadsObjectUniadsObject.Starts is null) and (UniadsObjectUniadsObject.Expires >= '2019-07-24' or UniadsObjectUniadsObject.Expires = '' or UniadsObjectUniadsObject.Expires is null) and UniadsObjectUniadsObject.Active = '1' ))) GROUP BY 1 ORDER BY "_SortColumn0" ASC 0.0063s

SELECT DISTINCT "UniadsZone"."ClassName", "UniadsZone"."LastEdited", "UniadsZone"."Created", "UniadsZone"."Title", "UniadsZone"."ZoneWidth", "UniadsZone"."ZoneHeight", "UniadsZone"."Order", "UniadsZone"."Active", "UniadsZone"."ParentZoneID", "UniadsZone"."ID", CASE WHEN "UniadsZone"."ClassName" IS NOT NULL THEN "UniadsZone"."ClassName" ELSE 'UniadsZone' END AS "RecordClassName" FROM "UniadsZone" WHERE ("UniadsZone"."ParentZoneID" = ?) ORDER BY "UniadsZone"."Order" ASC 0.0007s

SELECT DISTINCT count(DISTINCT "Block_Live"."ID") AS "Count" FROM "Block_Live" INNER JOIN "SiteTree_Blocks" ON "SiteTree_Blocks"."BlockID" = "Block_Live"."ID" WHERE ("SiteTree_Blocks"."SiteTreeID" = ?) AND ("BlockArea" = ?) 0.0017s

SELECT DISTINCT "UniadsZone"."ClassName", "UniadsZone"."LastEdited", "UniadsZone"."Created", "UniadsZone"."Title", "UniadsZone"."ZoneWidth", "UniadsZone"."ZoneHeight", "UniadsZone"."Order", "UniadsZone"."Active", "UniadsZone"."ParentZoneID", "UniadsZone"."ID", CASE WHEN "UniadsZone"."ClassName" IS NOT NULL THEN "UniadsZone"."ClassName" ELSE 'UniadsZone' END AS "RecordClassName" FROM "UniadsZone" WHERE ("UniadsZone"."Title" = ?) AND ("UniadsZone"."Active" = ?) ORDER BY "UniadsZone"."ParentZoneID" ASC, "UniadsZone"."Order" ASC, "UniadsZone"."ID" ASC LIMIT 1 0.0051s

SELECT UniadsObject.ID, rand() AS "_SortColumn0" FROM UniadsObject left join UniadsCampaign c on c.ID = UniadsObject.CampaignID WHERE ( UniadsObject.ZoneID = '2' and ( exists (select * from Page_Ads pa where pa.UniadsObjectID = UniadsObject.ID and pa.PageID = 248) or not exists (select * from Page_Ads pa where pa.UniadsObjectID = UniadsObject.ID) ) and (c.ID is null or ( c.Active = '1' and (c.Starts <= '2019-07-24' or c.Starts = '' or c.Starts is null) and (c.Expires >= '2019-07-24' or c.Expires = '' or c.Expires is null) )) and (UniadsObject.Starts <= '2019-07-24' or UniadsObject.Starts = '' or UniadsObject.Starts is null) and (UniadsObject.Expires >= '2019-07-24' or UniadsObject.Expires = '' or UniadsObject.Expires is null) and UniadsObject.Active = '1' and (UniadsObject.ImpressionLimit = 0 or UniadsObject.ImpressionLimit > UniadsObject.Impressions) and UniadsObject.Weight >= (rand() * ( select max(UniadsObjectUniadsObject.Weight) from UniadsObject as UniadsObjectUniadsObject left join UniadsCampaign cc on cc.ID = UniadsObjectUniadsObject.CampaignID where UniadsObjectUniadsObject.ZoneID = '2' and ( exists (select * from Page_Ads pa where pa.UniadsObjectID = UniadsObjectUniadsObject.ID and pa.PageID = 248) or not exists (select * from Page_Ads pa where pa.UniadsObjectID = UniadsObjectUniadsObject.ID) ) and (cc.ID is null or ( cc.Active = '1' and (cc.Starts <= '2019-07-24' or cc.Starts = '' or cc.Starts is null) and (cc.Expires >= '2019-07-24' or cc.Expires = '' or cc.Expires is null) )) and (UniadsObjectUniadsObject.Starts <= '2019-07-24' or UniadsObjectUniadsObject.Starts = '' or UniadsObjectUniadsObject.Starts is null) and (UniadsObjectUniadsObject.Expires >= '2019-07-24' or UniadsObjectUniadsObject.Expires = '' or UniadsObjectUniadsObject.Expires is null) and UniadsObjectUniadsObject.Active = '1' ))) GROUP BY 1 ORDER BY "_SortColumn0" ASC 0.0005s

SELECT DISTINCT "UniadsZone"."ClassName", "UniadsZone"."LastEdited", "UniadsZone"."Created", "UniadsZone"."Title", "UniadsZone"."ZoneWidth", "UniadsZone"."ZoneHeight", "UniadsZone"."Order", "UniadsZone"."Active", "UniadsZone"."ParentZoneID", "UniadsZone"."ID", CASE WHEN "UniadsZone"."ClassName" IS NOT NULL THEN "UniadsZone"."ClassName" ELSE 'UniadsZone' END AS "RecordClassName" FROM "UniadsZone" WHERE ("UniadsZone"."ParentZoneID" = ?) ORDER BY "UniadsZone"."Order" ASC 0.0004s

SELECT DISTINCT count(DISTINCT "Sponsor"."ID") AS "Count" FROM "Sponsor" 0.001s

SELECT DISTINCT "Sponsor"."ClassName", "Sponsor"."LastEdited", "Sponsor"."Created", "Sponsor"."Title", "Sponsor"."SponsorURL", "Sponsor"."SortOrder", "Sponsor"."LogoID", "Sponsor"."ID", CASE WHEN "Sponsor"."ClassName" IS NOT NULL THEN "Sponsor"."ClassName" ELSE 'Sponsor' END AS "RecordClassName" FROM "Sponsor" ORDER BY "Sponsor"."SortOrder" ASC 0.0009s

SELECT DISTINCT "File"."ClassName", "File"."LastEdited", "File"."Created", "File"."Name", "File"."Title", "File"."Filename", "File"."Content", "File"."ShowInSearch", "File"."CanViewType", "File"."ParentID", "File"."OwnerID", "Image"."FocusX", "Image"."FocusY", "File"."ID", CASE WHEN "File"."ClassName" IS NOT NULL THEN "File"."ClassName" ELSE 'File' END AS "RecordClassName" FROM "File" LEFT JOIN "Image" ON "Image"."ID" = "File"."ID" WHERE ("File"."ID" = ?) AND ("File"."ClassName" IN (?, ?, ?, ?)) ORDER BY "File"."Name" ASC LIMIT 1 0.0004s

SELECT DISTINCT "File"."ClassName", "File"."LastEdited", "File"."Created", "File"."Name", "File"."Title", "File"."Filename", "File"."Content", "File"."ShowInSearch", "File"."CanViewType", "File"."ParentID", "File"."OwnerID", "File"."ID", CASE WHEN "File"."ClassName" IS NOT NULL THEN "File"."ClassName" ELSE 'File' END AS "RecordClassName" FROM "File" WHERE ("File"."ID" = ?) ORDER BY "File"."Name" ASC LIMIT 1 0.0008s

SELECT DISTINCT "File"."ClassName", "File"."LastEdited", "File"."Created", "File"."Name", "File"."Title", "File"."Filename", "File"."Content", "File"."ShowInSearch", "File"."CanViewType", "File"."ParentID", "File"."OwnerID", "Image"."FocusX", "Image"."FocusY", "File"."ID", CASE WHEN "File"."ClassName" IS NOT NULL THEN "File"."ClassName" ELSE 'File' END AS "RecordClassName" FROM "File" LEFT JOIN "Image" ON "Image"."ID" = "File"."ID" WHERE ("File"."ID" = ?) AND ("File"."ClassName" IN (?, ?, ?, ?)) ORDER BY "File"."Name" ASC LIMIT 1 0.0129s

SELECT DISTINCT "File"."ClassName", "File"."LastEdited", "File"."Created", "File"."Name", "File"."Title", "File"."Filename", "File"."Content", "File"."ShowInSearch", "File"."CanViewType", "File"."ParentID", "File"."OwnerID", "Image"."FocusX", "Image"."FocusY", "File"."ID", CASE WHEN "File"."ClassName" IS NOT NULL THEN "File"."ClassName" ELSE 'File' END AS "RecordClassName" FROM "File" LEFT JOIN "Image" ON "Image"."ID" = "File"."ID" WHERE ("File"."ID" = ?) AND ("File"."ClassName" IN (?, ?, ?, ?)) ORDER BY "File"."Name" ASC LIMIT 1 0.0005s

SELECT DISTINCT "File"."ClassName", "File"."LastEdited", "File"."Created", "File"."Name", "File"."Title", "File"."Filename", "File"."Content", "File"."ShowInSearch", "File"."CanViewType", "File"."ParentID", "File"."OwnerID", "Image"."FocusX", "Image"."FocusY", "File"."ID", CASE WHEN "File"."ClassName" IS NOT NULL THEN "File"."ClassName" ELSE 'File' END AS "RecordClassName" FROM "File" LEFT JOIN "Image" ON "Image"."ID" = "File"."ID" WHERE ("File"."ID" = ?) AND ("File"."ClassName" IN (?, ?, ?, ?)) ORDER BY "File"."Name" ASC LIMIT 1 0.0006s

SELECT DISTINCT "File"."ClassName", "File"."LastEdited", "File"."Created", "File"."Name", "File"."Title", "File"."Filename", "File"."Content", "File"."ShowInSearch", "File"."CanViewType", "File"."ParentID", "File"."OwnerID", "Image"."FocusX", "Image"."FocusY", "File"."ID", CASE WHEN "File"."ClassName" IS NOT NULL THEN "File"."ClassName" ELSE 'File' END AS "RecordClassName" FROM "File" LEFT JOIN "Image" ON "Image"."ID" = "File"."ID" WHERE ("File"."ID" = ?) AND ("File"."ClassName" IN (?, ?, ?, ?)) ORDER BY "File"."Name" ASC LIMIT 1 0.0028s

SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."URLSegment", "SiteTree_Live"."Title", "SiteTree_Live"."MenuTitle", "SiteTree_Live"."Content", "SiteTree_Live"."MetaDescription", "SiteTree_Live"."ExtraMeta", "SiteTree_Live"."ShowInMenus", "SiteTree_Live"."ShowInSearch", "SiteTree_Live"."Sort", "SiteTree_Live"."HasBrokenFile", "SiteTree_Live"."HasBrokenLink", "SiteTree_Live"."ReportClass", "SiteTree_Live"."CanViewType", "SiteTree_Live"."CanEditType", "SiteTree_Live"."Priority", "SiteTree_Live"."InheritBlockSets", "SiteTree_Live"."Latitude", "SiteTree_Live"."Longitude", "SiteTree_Live"."ShowMap", "SiteTree_Live"."StaticMap", "SiteTree_Live"."Address", "SiteTree_Live"."ZoomLevel", "SiteTree_Live"."InfoWindowContent", "SiteTree_Live"."MapHueColor", "SiteTree_Live"."MapSaturation", "SiteTree_Live"."MapLightness", "SiteTree_Live"."Version", "SiteTree_Live"."ParentID", "Page_Live"."BannerText", "Page_Live"."ColumnOneText", "Page_Live"."ColumnTwoText", "Page_Live"."ShowInFooter", "Page_Live"."InheritSettings", "Page_Live"."PageAlias", "Page_Live"."MetaTitle", "Page_Live"."BannerImageID", "Page_Live"."UseCampaignID", "SiteTree_Live"."ID", CASE WHEN "SiteTree_Live"."ClassName" IS NOT NULL THEN "SiteTree_Live"."ClassName" ELSE 'SiteTree' END AS "RecordClassName" FROM "SiteTree_Live" LEFT JOIN "Page_Live" ON "Page_Live"."ID" = "SiteTree_Live"."ID" WHERE ("Page_Live"."ShowInFooter" = ?) AND ("SiteTree_Live"."ClassName" IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)) ORDER BY "SiteTree_Live"."Sort" ASC 0.0181s

SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "RedirectorPage_Live"."RedirectionType", "RedirectorPage_Live"."ExternalURL", "RedirectorPage_Live"."LinkToID", "SiteTree_Live"."ID", CASE WHEN "SiteTree_Live"."ClassName" IS NOT NULL THEN "SiteTree_Live"."ClassName" ELSE 'SiteTree' END AS "RecordClassName", "SiteTree_Live"."Sort" FROM "SiteTree_Live" LEFT JOIN "Page_Live" ON "Page_Live"."ID" = "SiteTree_Live"."ID" LEFT JOIN "RedirectorPage_Live" ON "RedirectorPage_Live"."ID" = "SiteTree_Live"."ID" WHERE ("RedirectorPage_Live"."ID" = 286) AND ("SiteTree_Live"."ClassName" IN (?)) ORDER BY "SiteTree_Live"."Sort" ASC LIMIT 1 0.0009s

SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "RedirectorPage_Live"."RedirectionType", "RedirectorPage_Live"."ExternalURL", "RedirectorPage_Live"."LinkToID", "SiteTree_Live"."ID", CASE WHEN "SiteTree_Live"."ClassName" IS NOT NULL THEN "SiteTree_Live"."ClassName" ELSE 'SiteTree' END AS "RecordClassName", "SiteTree_Live"."Sort" FROM "SiteTree_Live" LEFT JOIN "Page_Live" ON "Page_Live"."ID" = "SiteTree_Live"."ID" LEFT JOIN "RedirectorPage_Live" ON "RedirectorPage_Live"."ID" = "SiteTree_Live"."ID" WHERE ("RedirectorPage_Live"."ID" = 258) AND ("SiteTree_Live"."ClassName" IN (?)) ORDER BY "SiteTree_Live"."Sort" ASC LIMIT 1 0.0007s

SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."URLSegment", "SiteTree_Live"."Title", "SiteTree_Live"."MenuTitle", "SiteTree_Live"."Content", "SiteTree_Live"."MetaDescription", "SiteTree_Live"."ExtraMeta", "SiteTree_Live"."ShowInMenus", "SiteTree_Live"."ShowInSearch", "SiteTree_Live"."Sort", "SiteTree_Live"."HasBrokenFile", "SiteTree_Live"."HasBrokenLink", "SiteTree_Live"."ReportClass", "SiteTree_Live"."CanViewType", "SiteTree_Live"."CanEditType", "SiteTree_Live"."Priority", "SiteTree_Live"."InheritBlockSets", "SiteTree_Live"."Latitude", "SiteTree_Live"."Longitude", "SiteTree_Live"."ShowMap", "SiteTree_Live"."StaticMap", "SiteTree_Live"."Address", "SiteTree_Live"."ZoomLevel", "SiteTree_Live"."InfoWindowContent", "SiteTree_Live"."MapHueColor", "SiteTree_Live"."MapSaturation", "SiteTree_Live"."MapLightness", "SiteTree_Live"."Version", "SiteTree_Live"."ParentID", "Page_Live"."BannerText", "Page_Live"."ColumnOneText", "Page_Live"."ColumnTwoText", "Page_Live"."ShowInFooter", "Page_Live"."InheritSettings", "Page_Live"."PageAlias", "Page_Live"."MetaTitle", "Page_Live"."BannerImageID", "Page_Live"."UseCampaignID", "SiteTree_Live"."ID", CASE WHEN "SiteTree_Live"."ClassName" IS NOT NULL THEN "SiteTree_Live"."ClassName" ELSE 'SiteTree' END AS "RecordClassName" FROM "SiteTree_Live" LEFT JOIN "Page_Live" ON "Page_Live"."ID" = "SiteTree_Live"."ID" WHERE (PageAlias = 'sitemap') AND ("SiteTree_Live"."ClassName" IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)) ORDER BY "SiteTree_Live"."Sort" ASC LIMIT 1 0.0205s

SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."URLSegment", "SiteTree_Live"."Title", "SiteTree_Live"."MenuTitle", "SiteTree_Live"."Content", "SiteTree_Live"."MetaDescription", "SiteTree_Live"."ExtraMeta", "SiteTree_Live"."ShowInMenus", "SiteTree_Live"."ShowInSearch", "SiteTree_Live"."Sort", "SiteTree_Live"."HasBrokenFile", "SiteTree_Live"."HasBrokenLink", "SiteTree_Live"."ReportClass", "SiteTree_Live"."CanViewType", "SiteTree_Live"."CanEditType", "SiteTree_Live"."Priority", "SiteTree_Live"."InheritBlockSets", "SiteTree_Live"."Latitude", "SiteTree_Live"."Longitude", "SiteTree_Live"."ShowMap", "SiteTree_Live"."StaticMap", "SiteTree_Live"."Address", "SiteTree_Live"."ZoomLevel", "SiteTree_Live"."InfoWindowContent", "SiteTree_Live"."MapHueColor", "SiteTree_Live"."MapSaturation", "SiteTree_Live"."MapLightness", "SiteTree_Live"."Version", "SiteTree_Live"."ParentID", "SiteTree_Live"."ID", CASE WHEN "SiteTree_Live"."ClassName" IS NOT NULL THEN "SiteTree_Live"."ClassName" ELSE 'SiteTree' END AS "RecordClassName" FROM "SiteTree_Live" WHERE ("SiteTree_Live"."ID" = ?) ORDER BY "SiteTree_Live"."Sort" ASC LIMIT 1 0.0006s

SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."URLSegment", "SiteTree_Live"."Title", "SiteTree_Live"."MenuTitle", "SiteTree_Live"."Content", "SiteTree_Live"."MetaDescription", "SiteTree_Live"."ExtraMeta", "SiteTree_Live"."ShowInMenus", "SiteTree_Live"."ShowInSearch", "SiteTree_Live"."Sort", "SiteTree_Live"."HasBrokenFile", "SiteTree_Live"."HasBrokenLink", "SiteTree_Live"."ReportClass", "SiteTree_Live"."CanViewType", "SiteTree_Live"."CanEditType", "SiteTree_Live"."Priority", "SiteTree_Live"."InheritBlockSets", "SiteTree_Live"."Latitude", "SiteTree_Live"."Longitude", "SiteTree_Live"."ShowMap", "SiteTree_Live"."StaticMap", "SiteTree_Live"."Address", "SiteTree_Live"."ZoomLevel", "SiteTree_Live"."InfoWindowContent", "SiteTree_Live"."MapHueColor", "SiteTree_Live"."MapSaturation", "SiteTree_Live"."MapLightness", "SiteTree_Live"."Version", "SiteTree_Live"."ParentID", "Page_Live"."BannerText", "Page_Live"."ColumnOneText", "Page_Live"."ColumnTwoText", "Page_Live"."ShowInFooter", "Page_Live"."InheritSettings", "Page_Live"."PageAlias", "Page_Live"."MetaTitle", "Page_Live"."BannerImageID", "Page_Live"."UseCampaignID", "SiteTree_Live"."ID", CASE WHEN "SiteTree_Live"."ClassName" IS NOT NULL THEN "SiteTree_Live"."ClassName" ELSE 'SiteTree' END AS "RecordClassName" FROM "SiteTree_Live" LEFT JOIN "Page_Live" ON "Page_Live"."ID" = "SiteTree_Live"."ID" WHERE (PageAlias = 'disclaimer') AND ("SiteTree_Live"."ClassName" IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)) ORDER BY "SiteTree_Live"."Sort" ASC LIMIT 1 0.0146s

SELECT DISTINCT "SiteTree"."ClassName", "SiteTree"."LastEdited", "SiteTree"."Created", "SiteTree"."URLSegment", "SiteTree"."Title", "SiteTree"."MenuTitle", "SiteTree"."Content", "SiteTree"."MetaDescription", "SiteTree"."ExtraMeta", "SiteTree"."ShowInMenus", "SiteTree"."ShowInSearch", "SiteTree"."Sort", "SiteTree"."HasBrokenFile", "SiteTree"."HasBrokenLink", "SiteTree"."ReportClass", "SiteTree"."CanViewType", "SiteTree"."CanEditType", "SiteTree"."Priority", "SiteTree"."InheritBlockSets", "SiteTree"."Latitude", "SiteTree"."Longitude", "SiteTree"."ShowMap", "SiteTree"."StaticMap", "SiteTree"."Address", "SiteTree"."ZoomLevel", "SiteTree"."InfoWindowContent", "SiteTree"."MapHueColor", "SiteTree"."MapSaturation", "SiteTree"."MapLightness", "SiteTree"."Version", "SiteTree"."ParentID", "SiteTree"."ID", CASE WHEN "SiteTree"."ClassName" IS NOT NULL THEN "SiteTree"."ClassName" ELSE 'SiteTree' END AS "RecordClassName" FROM "SiteTree" WHERE ("SiteTree"."ID" = ?) ORDER BY "SiteTree"."Sort" ASC LIMIT 1 0.022s

SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."URLSegment", "SiteTree_Live"."Title", "SiteTree_Live"."MenuTitle", "SiteTree_Live"."Content", "SiteTree_Live"."MetaDescription", "SiteTree_Live"."ExtraMeta", "SiteTree_Live"."ShowInMenus", "SiteTree_Live"."ShowInSearch", "SiteTree_Live"."Sort", "SiteTree_Live"."HasBrokenFile", "SiteTree_Live"."HasBrokenLink", "SiteTree_Live"."ReportClass", "SiteTree_Live"."CanViewType", "SiteTree_Live"."CanEditType", "SiteTree_Live"."Priority", "SiteTree_Live"."InheritBlockSets", "SiteTree_Live"."Latitude", "SiteTree_Live"."Longitude", "SiteTree_Live"."ShowMap", "SiteTree_Live"."StaticMap", "SiteTree_Live"."Address", "SiteTree_Live"."ZoomLevel", "SiteTree_Live"."InfoWindowContent", "SiteTree_Live"."MapHueColor", "SiteTree_Live"."MapSaturation", "SiteTree_Live"."MapLightness", "SiteTree_Live"."Version", "SiteTree_Live"."ParentID", "SiteTree_Live"."ID", CASE WHEN "SiteTree_Live"."ClassName" IS NOT NULL THEN "SiteTree_Live"."ClassName" ELSE 'SiteTree' END AS "RecordClassName" FROM "SiteTree_Live" WHERE ("SiteTree_Live"."ID" = ?) ORDER BY "SiteTree_Live"."Sort" ASC LIMIT 1 0.0006s

SELECT DISTINCT "SiteTree"."ClassName", "SiteTree"."LastEdited", "SiteTree"."Created", "SiteTree"."URLSegment", "SiteTree"."Title", "SiteTree"."MenuTitle", "SiteTree"."Content", "SiteTree"."MetaDescription", "SiteTree"."ExtraMeta", "SiteTree"."ShowInMenus", "SiteTree"."ShowInSearch", "SiteTree"."Sort", "SiteTree"."HasBrokenFile", "SiteTree"."HasBrokenLink", "SiteTree"."ReportClass", "SiteTree"."CanViewType", "SiteTree"."CanEditType", "SiteTree"."Priority", "SiteTree"."InheritBlockSets", "SiteTree"."Latitude", "SiteTree"."Longitude", "SiteTree"."ShowMap", "SiteTree"."StaticMap", "SiteTree"."Address", "SiteTree"."ZoomLevel", "SiteTree"."InfoWindowContent", "SiteTree"."MapHueColor", "SiteTree"."MapSaturation", "SiteTree"."MapLightness", "SiteTree"."Version", "SiteTree"."ParentID", "SiteTree"."ID", CASE WHEN "SiteTree"."ClassName" IS NOT NULL THEN "SiteTree"."ClassName" ELSE 'SiteTree' END AS "RecordClassName" FROM "SiteTree" WHERE ("SiteTree"."ID" = ?) ORDER BY "SiteTree"."Sort" ASC LIMIT 1 0.0005s

SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."URLSegment", "SiteTree_Live"."Title", "SiteTree_Live"."MenuTitle", "SiteTree_Live"."Content", "SiteTree_Live"."MetaDescription", "SiteTree_Live"."ExtraMeta", "SiteTree_Live"."ShowInMenus", "SiteTree_Live"."ShowInSearch", "SiteTree_Live"."Sort", "SiteTree_Live"."HasBrokenFile", "SiteTree_Live"."HasBrokenLink", "SiteTree_Live"."ReportClass", "SiteTree_Live"."CanViewType", "SiteTree_Live"."CanEditType", "SiteTree_Live"."Priority", "SiteTree_Live"."InheritBlockSets", "SiteTree_Live"."Latitude", "SiteTree_Live"."Longitude", "SiteTree_Live"."ShowMap", "SiteTree_Live"."StaticMap", "SiteTree_Live"."Address", "SiteTree_Live"."ZoomLevel", "SiteTree_Live"."InfoWindowContent", "SiteTree_Live"."MapHueColor", "SiteTree_Live"."MapSaturation", "SiteTree_Live"."MapLightness", "SiteTree_Live"."Version", "SiteTree_Live"."ParentID", "SiteTree_Live"."ID", CASE WHEN "SiteTree_Live"."ClassName" IS NOT NULL THEN "SiteTree_Live"."ClassName" ELSE 'SiteTree' END AS "RecordClassName" FROM "SiteTree_Live" WHERE ("SiteTree_Live"."ID" = ?) ORDER BY "SiteTree_Live"."Sort" ASC LIMIT 1 0.0016s

Teams Postal League Results and Records | Archery New Zealand

Teams Postal League Results and Records

Results 2018-2019 Season

It's about to start!!!

 

 

Results 2017-2018 Season

October 2017

November 2017

December/January 2017/18

February 2018

March 2018

2017-2018 Points Table

 

Results 2016-2017 Season

 
 
 
 

2016/2017 Points Table

 

Results 2015-2016 Season

 
 
 
 
 
 

 

Results 2014-2015 Season

 
 
 
 
 
 
2014/2015 Points Table
 
 

Results 2013-2014 Season

 
November 2013
 
 
 
 
2013/2014 Points Table

 

Results 2012-2013 Season

 
 
 
 
 

 

Results 2011-2012 Season

 
 
 
 
 
 

 

Results 2010-2011 Season

 
 
 
 

 

Results 2009-2010 Season

 
 
 
 
 

Postal League Records

Postal League Records updated March 2018 (PDF)

Postal League Records updated April 2015  [PDF Download]

Postal League Records updated November 2014  [PDF Download]