SET sql_mode = ? 0.0007s

SHOW DATABASES LIKE 'archeryn_cms' 0.0006s

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

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.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"."URLSegment" = ?) 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"."ID" = ?) ORDER BY "SiteTree_Live"."Sort" ASC LIMIT 1 0.0008s

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

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" = 23) AND ("SiteTree_Live"."ClassName" IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)) ORDER BY "SiteTree_Live"."Sort" ASC LIMIT 1 0.001s

SELECT DISTINCT MAX("SiteTree_Live"."LastEdited") FROM "SiteTree_Live" LEFT JOIN "Page_Live" ON "Page_Live"."ID" = "SiteTree_Live"."ID" WHERE ("SiteTree_Live"."ClassName" IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)) 0.0011s

SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SitemapPage_Live"."PagesToDisplay", "SitemapPage_Live"."ParentPageID", "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 "SitemapPage_Live" ON "SitemapPage_Live"."ID" = "SiteTree_Live"."ID" WHERE ("SitemapPage_Live"."ID" = 23) AND ("SiteTree_Live"."ClassName" IN (?)) ORDER BY "SiteTree_Live"."Sort" ASC LIMIT 1 0.0004s

SELECT DISTINCT count(DISTINCT "SiteTree_Live"."ID") AS "Count" FROM "SiteTree_Live" WHERE ("ParentID" = 0 AND "ShowInMenus" = 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 ("ParentID" = 0 AND "ShowInMenus" = 1) 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.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.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.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.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" != ?)) 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 "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.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" != ?)) 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.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" != ?)) AND ("SiteTree_Live"."ShowInMenus" = ?) ORDER BY "SiteTree_Live"."Sort" ASC 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.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" != ?)) 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.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" != ?)) AND ("SiteTree_Live"."ShowInMenus" = ?) ORDER BY "SiteTree_Live"."Sort" ASC 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.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" != ?)) AND ("SiteTree_Live"."ShowInMenus" = ?) ORDER BY "SiteTree_Live"."Sort" ASC 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" != ?)) AND ("SiteTree_Live"."ShowInMenus" = ?) ORDER BY "SiteTree_Live"."Sort" ASC 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" != ?)) AND ("SiteTree_Live"."ShowInMenus" = ?) ORDER BY "SiteTree_Live"."Sort" ASC 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" != ?)) AND ("SiteTree_Live"."ShowInMenus" = ?) ORDER BY "SiteTree_Live"."Sort" ASC 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" != ?)) AND ("SiteTree_Live"."ShowInMenus" = ?) ORDER BY "SiteTree_Live"."Sort" ASC 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.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" != ?)) AND ("SiteTree_Live"."ShowInMenus" = ?) ORDER BY "SiteTree_Live"."Sort" ASC 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" != ?)) AND ("SiteTree_Live"."ShowInMenus" = ?) ORDER BY "SiteTree_Live"."Sort" ASC 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" != ?)) 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"."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"."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"."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"."ParentID" = ?) AND (("SiteTree_Live"."ID" != ?)) AND ("SiteTree_Live"."ShowInMenus" = ?) ORDER BY "SiteTree_Live"."Sort" ASC 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" != ?)) 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"."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.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.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"."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"."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"."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"."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"."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"."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"."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" != ?)) AND ("SiteTree_Live"."ShowInMenus" = ?) ORDER BY "SiteTree_Live"."Sort" ASC 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" != ?)) 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.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" != ?)) AND ("SiteTree_Live"."ShowInMenus" = ?) ORDER BY "SiteTree_Live"."Sort" ASC 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.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" != ?)) AND ("SiteTree_Live"."ShowInMenus" = ?) ORDER BY "SiteTree_Live"."Sort" ASC 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" 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-11-22 19:04:57') ORDER BY "SiteTree_Live"."Sort" ASC 0.0125s

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.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" != ?)) 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.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" != ?)) AND ("SiteTree_Live"."ShowInMenus" = ?) ORDER BY "SiteTree_Live"."Sort" ASC 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" != ?)) AND ("SiteTree_Live"."ShowInMenus" = ?) ORDER BY "SiteTree_Live"."Sort" ASC 0.0005s

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.0003s

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.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" != ?)) AND ("SiteTree_Live"."ShowInMenus" = ?) ORDER BY "SiteTree_Live"."Sort" ASC 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" != ?)) AND ("SiteTree_Live"."ShowInMenus" = ?) ORDER BY "SiteTree_Live"."Sort" ASC 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" != ?)) AND ("SiteTree_Live"."ShowInMenus" = ?) ORDER BY "SiteTree_Live"."Sort" ASC 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" != ?)) AND ("SiteTree_Live"."ShowInMenus" = ?) ORDER BY "SiteTree_Live"."Sort" ASC 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.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" != ?)) 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"."ParentID" = ?) AND (("SiteTree_Live"."ID" != ?)) AND ("SiteTree_Live"."ShowInMenus" = ?) ORDER BY "SiteTree_Live"."Sort" ASC 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" != ?)) 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 "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 "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" != ?)) 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 "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"."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" != ?)) AND ("SiteTree_Live"."ShowInMenus" = ?) ORDER BY "SiteTree_Live"."Sort" ASC 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" != ?)) AND ("SiteTree_Live"."ShowInMenus" = ?) ORDER BY "SiteTree_Live"."Sort" ASC 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" != ?)) AND ("SiteTree_Live"."ShowInMenus" = ?) ORDER BY "SiteTree_Live"."Sort" ASC 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" != ?)) AND ("SiteTree_Live"."ShowInMenus" = ?) ORDER BY "SiteTree_Live"."Sort" ASC 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" != ?)) AND ("SiteTree_Live"."ShowInMenus" = ?) ORDER BY "SiteTree_Live"."Sort" ASC 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" != ?)) AND ("SiteTree_Live"."ShowInMenus" = ?) ORDER BY "SiteTree_Live"."Sort" ASC 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.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"."ShowInMenus" = ?) AND ("SiteTree_Live"."ParentID" = ?) ORDER BY "SiteTree_Live"."Sort" ASC 0.0007s

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", "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 "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.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.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" != ?)) 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" != ?)) 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.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.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.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.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" != ?)) AND ("SiteTree_Live"."ShowInMenus" = ?) ORDER BY "SiteTree_Live"."Sort" ASC 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.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.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.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" 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-11-22 19:04:57') ORDER BY "SiteTree_Live"."Sort" ASC 0.0125s

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"."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.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" != ?)) AND ("SiteTree_Live"."ShowInMenus" = ?) ORDER BY "SiteTree_Live"."Sort" ASC 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" != ?)) AND ("SiteTree_Live"."ShowInMenus" = ?) ORDER BY "SiteTree_Live"."Sort" ASC 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.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.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.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.0007s

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.0009s

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 = 23) 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-11-22' or c.Starts = '' or c.Starts is null) and (c.Expires >= '2019-11-22' or c.Expires = '' or c.Expires is null) )) and (UniadsObject.Starts <= '2019-11-22' or UniadsObject.Starts = '' or UniadsObject.Starts is null) and (UniadsObject.Expires >= '2019-11-22' 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 = 23) 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-11-22' or cc.Starts = '' or cc.Starts is null) and (cc.Expires >= '2019-11-22' or cc.Expires = '' or cc.Expires is null) )) and (UniadsObjectUniadsObject.Starts <= '2019-11-22' or UniadsObjectUniadsObject.Starts = '' or UniadsObjectUniadsObject.Starts is null) and (UniadsObjectUniadsObject.Expires >= '2019-11-22' or UniadsObjectUniadsObject.Expires = '' or UniadsObjectUniadsObject.Expires is null) and UniadsObjectUniadsObject.Active = '1' ))) GROUP BY 1 ORDER BY "_SortColumn0" ASC 0.0008s

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.0007s

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.0007s

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 = 23) 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-11-22' or c.Starts = '' or c.Starts is null) and (c.Expires >= '2019-11-22' or c.Expires = '' or c.Expires is null) )) and (UniadsObject.Starts <= '2019-11-22' or UniadsObject.Starts = '' or UniadsObject.Starts is null) and (UniadsObject.Expires >= '2019-11-22' 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 = 23) 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-11-22' or cc.Starts = '' or cc.Starts is null) and (cc.Expires >= '2019-11-22' or cc.Expires = '' or cc.Expires is null) )) and (UniadsObjectUniadsObject.Starts <= '2019-11-22' or UniadsObjectUniadsObject.Starts = '' or UniadsObjectUniadsObject.Starts is null) and (UniadsObjectUniadsObject.Expires >= '2019-11-22' or UniadsObjectUniadsObject.Expires = '' or UniadsObjectUniadsObject.Expires is null) and UniadsObjectUniadsObject.Active = '1' ))) GROUP BY 1 ORDER BY "_SortColumn0" ASC 0.0007s

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

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

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.0003s

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.0007s

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", "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.0007s

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 "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.0118s

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

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.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", "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.0091s

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.0089s

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.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"."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.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.0007s

Sitemap | Archery New Zealand

Sitemap