SET sql_mode = ? 0.0003s

SHOW DATABASES LIKE 'ss_dermnet' 0.0007s

SHOW TABLES 0.0011s

SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."URLSegment", "SiteTree_Live"."Title", "SiteTree_Live"."MenuTitle", "SiteTree_Live"."Content", "SiteTree_Live"."MetaDescription", "SiteTree_Live"."ExtraMeta", "SiteTree_Live"."ShowInMenus", "SiteTree_Live"."ShowInSearch", "SiteTree_Live"."Sort", "SiteTree_Live"."HasBrokenFile", "SiteTree_Live"."HasBrokenLink", "SiteTree_Live"."ReportClass", "SiteTree_Live"."CanViewType", "SiteTree_Live"."CanEditType", "SiteTree_Live"."Priority", "SiteTree_Live"."Version", "SiteTree_Live"."WorkflowDefinitionID", "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.0011s

SELECT DISTINCT "SiteConfig"."ClassName", "SiteConfig"."LastEdited", "SiteConfig"."Created", "SiteConfig"."Title", "SiteConfig"."Tagline", "SiteConfig"."Theme", "SiteConfig"."CanViewType", "SiteConfig"."CanEditType", "SiteConfig"."CanCreateTopLevelType", "SiteConfig"."MobileTitle", "SiteConfig"."NoticeDisplay", "SiteConfig"."NoticeContent", "SiteConfig"."NoticeUpdateDate", "SiteConfig"."NoticeVersion", "SiteConfig"."FooterColumnOne", "SiteConfig"."FooterColumnTwo", "SiteConfig"."FooterColumnThree", "SiteConfig"."FooterColumnFour", "SiteConfig"."FooterColumnOneHeading", "SiteConfig"."FooterColumnTwoHeading", "SiteConfig"."FooterColumnThreeHeading", "SiteConfig"."FooterColumnFourHeading", "SiteConfig"."FooterBottom", "SiteConfig"."FacebookURL", "SiteConfig"."TwitterURL", "SiteConfig"."InstagramURL", "SiteConfig"."FooterBottomImage1Link", "SiteConfig"."FooterBottomImage2Link", "SiteConfig"."FacebookTitle", "SiteConfig"."TwitterTitle", "SiteConfig"."InstagramTitle", "SiteConfig"."AnalyticsCode", "SiteConfig"."MailChimpListURL", "SiteConfig"."MailChimpFormCode", "SiteConfig"."MailChimpCloseButton", "SiteConfig"."TwitterHeader", "SiteConfig"."TwitterByLine", "SiteConfig"."AddThisMargin", "SiteConfig"."ShowFixedMobileAd", "SiteConfig"."ShowCreativeCommons", "SiteConfig"."SidebarWidgetAreaID", "SiteConfig"."LeaderboardAdID", "SiteConfig"."NoticeImageID", "SiteConfig"."LeaderboardAdPageLinkID", "SiteConfig"."RectangularAdID", "SiteConfig"."RectangularAdPageLinkID", "SiteConfig"."LeaderboardBottomAdID", "SiteConfig"."LeaderboardBottomAdPageLinkID", "SiteConfig"."SkyscraperAdID", "SiteConfig"."SkyscraperAdPageLinkID", "SiteConfig"."MobileHeaderAdID", "SiteConfig"."MobileHeaderAdPageLinkID", "SiteConfig"."FooterBottomImage1ID", "SiteConfig"."FooterBottomImage2ID", "SiteConfig"."CMSLogoID", "SiteConfig"."ID", CASE WHEN "SiteConfig"."ClassName" IS NOT NULL THEN "SiteConfig"."ClassName" ELSE 'SiteConfig' END AS "RecordClassName" FROM "SiteConfig" LIMIT 1 0.0002s

SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "Page_Live"."OriginalURL", "Page_Live"."RelatedInformation", "Page_Live"."MetaTitle", "Page_Live"."HeadingLinkLabel", "Page_Live"."ShowInMobileMenu", "Page_Live"."ShowInDesktopMenu", "Page_Live"."ShowSponsors", "Page_Live"."BannerContent", "Page_Live"."BannerNotification", "Page_Live"."HeadingLinkPageID", "Page_Live"."BannerImageID", "Page_Live"."SidebarWidgetAreaID", "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" = 34) AND ("SiteTree_Live"."ClassName" IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)) ORDER BY "SiteTree_Live"."Sort" ASC LIMIT 1 0.0011s

SELECT DISTINCT "File"."ClassName", "File"."LastEdited", "File"."Created", "File"."Name", "File"."Title", "File"."Filename", "File"."Content", "File"."ShowInSearch", "File"."OriginalURL", "File"."Label", "File"."OriginalThumbnail", "File"."UseManualThumbnail", "File"."SearchIndex", "File"."CanViewType", "File"."TagsValue", "File"."ParentID", "File"."OwnerID", "File"."CopyrightID", "File"."ManualThumbnailID", "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.0009s

SELECT DISTINCT "File"."ClassName", "File"."LastEdited", "File"."Created", "File"."Name", "File"."Title", "File"."Filename", "File"."Content", "File"."ShowInSearch", "File"."OriginalURL", "File"."Label", "File"."OriginalThumbnail", "File"."UseManualThumbnail", "File"."SearchIndex", "File"."CanViewType", "File"."TagsValue", "File"."ParentID", "File"."OwnerID", "File"."CopyrightID", "File"."ManualThumbnailID", "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.0005s

SELECT DISTINCT "Ad"."ClassName", "Ad"."LastEdited", "Ad"."Created", "Ad"."Sponsor", "Ad"."Type", "Ad"."LinkType", "Ad"."ExternalURL", "Ad"."ShowOnChildPages", "Ad"."DisplayType", "Ad"."CountriesValue", "Ad"."ImageID", "Ad"."PageLinkID", "Ad"."ID", CASE WHEN "Ad"."ClassName" IS NOT NULL THEN "Ad"."ClassName" ELSE 'Ad' END AS "RecordClassName" FROM "Ad" INNER JOIN "Ad_Pages" ON "Ad_Pages"."AdID" = "Ad"."ID" WHERE ("Ad_Pages"."PageID" = ?) AND ("Ad"."Type" = ?) AND ("Ad"."CountriesValue" LIKE ?) 0.0009s

SELECT DISTINCT "Ad"."ClassName", "Ad"."LastEdited", "Ad"."Created", "Ad"."Sponsor", "Ad"."Type", "Ad"."LinkType", "Ad"."ExternalURL", "Ad"."ShowOnChildPages", "Ad"."DisplayType", "Ad"."CountriesValue", "Ad"."ImageID", "Ad"."PageLinkID", "Ad"."ID", CASE WHEN "Ad"."ClassName" IS NOT NULL THEN "Ad"."ClassName" ELSE 'Ad' END AS "RecordClassName" FROM "Ad" INNER JOIN "Ad_Pages" ON "Ad_Pages"."AdID" = "Ad"."ID" WHERE ("Ad_Pages"."PageID" = ?) AND ("Ad"."Type" = ?) AND ("Ad"."CountriesValue" LIKE ?) 0.0007s

SELECT DISTINCT "GlossaryTerm"."ClassName", "GlossaryTerm"."LastEdited", "GlossaryTerm"."Created", "GlossaryTerm"."Term", "GlossaryTerm"."Definition", "GlossaryTerm"."ImageID", "GlossaryTerm"."ID", CASE WHEN "GlossaryTerm"."ClassName" IS NOT NULL THEN "GlossaryTerm"."ClassName" ELSE 'GlossaryTerm' END AS "RecordClassName" FROM "GlossaryTerm" 0.0012s

SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."URLSegment", "SiteTree_Live"."Title", "SiteTree_Live"."MenuTitle", "SiteTree_Live"."Content", "SiteTree_Live"."MetaDescription", "SiteTree_Live"."ExtraMeta", "SiteTree_Live"."ShowInMenus", "SiteTree_Live"."ShowInSearch", "SiteTree_Live"."Sort", "SiteTree_Live"."HasBrokenFile", "SiteTree_Live"."HasBrokenLink", "SiteTree_Live"."ReportClass", "SiteTree_Live"."CanViewType", "SiteTree_Live"."CanEditType", "SiteTree_Live"."Priority", "SiteTree_Live"."Version", "SiteTree_Live"."WorkflowDefinitionID", "SiteTree_Live"."ParentID", "Page_Live"."OriginalURL", "Page_Live"."RelatedInformation", "Page_Live"."MetaTitle", "Page_Live"."HeadingLinkLabel", "Page_Live"."ShowInMobileMenu", "Page_Live"."ShowInDesktopMenu", "Page_Live"."ShowSponsors", "Page_Live"."BannerContent", "Page_Live"."BannerNotification", "Page_Live"."HeadingLinkPageID", "Page_Live"."BannerImageID", "Page_Live"."SidebarWidgetAreaID", "CMECategoryPage_Live"."ThumbnailID", "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" LEFT JOIN "CMECategoryPage_Live" ON "CMECategoryPage_Live"."ID" = "SiteTree_Live"."ID" WHERE ("SiteTree_Live"."ShowInMenus" = ?) AND ("SiteTree_Live"."ParentID" = ?) AND ("SiteTree_Live"."ClassName" IN (?)) ORDER BY "SiteTree_Live"."Sort" ASC 0.0011s

SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."URLSegment", "SiteTree_Live"."Title", "SiteTree_Live"."MenuTitle", "SiteTree_Live"."Content", "SiteTree_Live"."MetaDescription", "SiteTree_Live"."ExtraMeta", "SiteTree_Live"."ShowInMenus", "SiteTree_Live"."ShowInSearch", "SiteTree_Live"."Sort", "SiteTree_Live"."HasBrokenFile", "SiteTree_Live"."HasBrokenLink", "SiteTree_Live"."ReportClass", "SiteTree_Live"."CanViewType", "SiteTree_Live"."CanEditType", "SiteTree_Live"."Priority", "SiteTree_Live"."Version", "SiteTree_Live"."WorkflowDefinitionID", "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 "File"."ClassName", "File"."LastEdited", "File"."Created", "File"."Name", "File"."Title", "File"."Filename", "File"."Content", "File"."ShowInSearch", "File"."OriginalURL", "File"."Label", "File"."OriginalThumbnail", "File"."UseManualThumbnail", "File"."SearchIndex", "File"."CanViewType", "File"."TagsValue", "File"."ParentID", "File"."OwnerID", "File"."CopyrightID", "File"."ManualThumbnailID", "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"."OriginalURL", "File"."Label", "File"."OriginalThumbnail", "File"."UseManualThumbnail", "File"."SearchIndex", "File"."CanViewType", "File"."TagsValue", "File"."ParentID", "File"."OwnerID", "File"."CopyrightID", "File"."ManualThumbnailID", "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.0008s

SELECT DISTINCT "File"."ClassName", "File"."LastEdited", "File"."Created", "File"."Name", "File"."Title", "File"."Filename", "File"."Content", "File"."ShowInSearch", "File"."OriginalURL", "File"."Label", "File"."OriginalThumbnail", "File"."UseManualThumbnail", "File"."SearchIndex", "File"."CanViewType", "File"."TagsValue", "File"."ParentID", "File"."OwnerID", "File"."CopyrightID", "File"."ManualThumbnailID", "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"."OriginalURL", "File"."Label", "File"."OriginalThumbnail", "File"."UseManualThumbnail", "File"."SearchIndex", "File"."CanViewType", "File"."TagsValue", "File"."ParentID", "File"."OwnerID", "File"."CopyrightID", "File"."ManualThumbnailID", "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"."OriginalURL", "File"."Label", "File"."OriginalThumbnail", "File"."UseManualThumbnail", "File"."SearchIndex", "File"."CanViewType", "File"."TagsValue", "File"."ParentID", "File"."OwnerID", "File"."CopyrightID", "File"."ManualThumbnailID", "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"."OriginalURL", "File"."Label", "File"."OriginalThumbnail", "File"."UseManualThumbnail", "File"."SearchIndex", "File"."CanViewType", "File"."TagsValue", "File"."ParentID", "File"."OwnerID", "File"."CopyrightID", "File"."ManualThumbnailID", "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"."OriginalURL", "File"."Label", "File"."OriginalThumbnail", "File"."UseManualThumbnail", "File"."SearchIndex", "File"."CanViewType", "File"."TagsValue", "File"."ParentID", "File"."OwnerID", "File"."CopyrightID", "File"."ManualThumbnailID", "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"."OriginalURL", "File"."Label", "File"."OriginalThumbnail", "File"."UseManualThumbnail", "File"."SearchIndex", "File"."CanViewType", "File"."TagsValue", "File"."ParentID", "File"."OwnerID", "File"."CopyrightID", "File"."ManualThumbnailID", "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.0012s

SELECT DISTINCT "File"."ClassName", "File"."LastEdited", "File"."Created", "File"."Name", "File"."Title", "File"."Filename", "File"."Content", "File"."ShowInSearch", "File"."OriginalURL", "File"."Label", "File"."OriginalThumbnail", "File"."UseManualThumbnail", "File"."SearchIndex", "File"."CanViewType", "File"."TagsValue", "File"."ParentID", "File"."OwnerID", "File"."CopyrightID", "File"."ManualThumbnailID", "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.001s

SELECT DISTINCT "File"."ClassName", "File"."LastEdited", "File"."Created", "File"."Name", "File"."Title", "File"."Filename", "File"."Content", "File"."ShowInSearch", "File"."OriginalURL", "File"."Label", "File"."OriginalThumbnail", "File"."UseManualThumbnail", "File"."SearchIndex", "File"."CanViewType", "File"."TagsValue", "File"."ParentID", "File"."OwnerID", "File"."CopyrightID", "File"."ManualThumbnailID", "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.0011s

SELECT DISTINCT "File"."ClassName", "File"."LastEdited", "File"."Created", "File"."Name", "File"."Title", "File"."Filename", "File"."Content", "File"."ShowInSearch", "File"."OriginalURL", "File"."Label", "File"."OriginalThumbnail", "File"."UseManualThumbnail", "File"."SearchIndex", "File"."CanViewType", "File"."TagsValue", "File"."ParentID", "File"."OwnerID", "File"."CopyrightID", "File"."ManualThumbnailID", "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.0011s

SELECT DISTINCT "File"."ClassName", "File"."LastEdited", "File"."Created", "File"."Name", "File"."Title", "File"."Filename", "File"."Content", "File"."ShowInSearch", "File"."OriginalURL", "File"."Label", "File"."OriginalThumbnail", "File"."UseManualThumbnail", "File"."SearchIndex", "File"."CanViewType", "File"."TagsValue", "File"."ParentID", "File"."OwnerID", "File"."CopyrightID", "File"."ManualThumbnailID", "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"."OriginalURL", "File"."Label", "File"."OriginalThumbnail", "File"."UseManualThumbnail", "File"."SearchIndex", "File"."CanViewType", "File"."TagsValue", "File"."ParentID", "File"."OwnerID", "File"."CopyrightID", "File"."ManualThumbnailID", "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"."OriginalURL", "File"."Label", "File"."OriginalThumbnail", "File"."UseManualThumbnail", "File"."SearchIndex", "File"."CanViewType", "File"."TagsValue", "File"."ParentID", "File"."OwnerID", "File"."CopyrightID", "File"."ManualThumbnailID", "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"."OriginalURL", "File"."Label", "File"."OriginalThumbnail", "File"."UseManualThumbnail", "File"."SearchIndex", "File"."CanViewType", "File"."TagsValue", "File"."ParentID", "File"."OwnerID", "File"."CopyrightID", "File"."ManualThumbnailID", "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"."OriginalURL", "File"."Label", "File"."OriginalThumbnail", "File"."UseManualThumbnail", "File"."SearchIndex", "File"."CanViewType", "File"."TagsValue", "File"."ParentID", "File"."OwnerID", "File"."CopyrightID", "File"."ManualThumbnailID", "Image"."FocusX", "Image"."FocusY", "File"."ID", CASE WHEN "File"."ClassName" IS NOT NULL THEN "File"."ClassName" ELSE 'File' END AS "RecordClassName" FROM "File" LEFT JOIN "Image" ON "Image"."ID" = "File"."ID" WHERE ("File"."ID" = ?) AND ("File"."ClassName" IN (?, ?, ?, ?)) ORDER BY "File"."Name" ASC LIMIT 1 0.0004s

SELECT DISTINCT URLSegment * 1 AS "_SortColumn0", "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"."Version", "SiteTree_Live"."WorkflowDefinitionID", "SiteTree_Live"."ParentID", "Page_Live"."OriginalURL", "Page_Live"."RelatedInformation", "Page_Live"."MetaTitle", "Page_Live"."HeadingLinkLabel", "Page_Live"."ShowInMobileMenu", "Page_Live"."ShowInDesktopMenu", "Page_Live"."ShowSponsors", "Page_Live"."BannerContent", "Page_Live"."BannerNotification", "Page_Live"."HeadingLinkPageID", "Page_Live"."BannerImageID", "Page_Live"."SidebarWidgetAreaID", "BasicQuiz_Live"."QuizNumber", "BasicQuiz_Live"."ThumbnailID", "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" LEFT JOIN "BasicQuiz_Live" ON "BasicQuiz_Live"."ID" = "SiteTree_Live"."ID" WHERE ("SiteTree_Live"."ShowInMenus" = ?) AND ("SiteTree_Live"."ClassName" IN (?)) ORDER BY "_SortColumn0" DESC 0.0065s

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"."Version", "SiteTree_Live"."WorkflowDefinitionID", "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"."Version", "SiteTree_Live"."WorkflowDefinitionID", "SiteTree_Live"."ParentID", "Page_Live"."OriginalURL", "Page_Live"."RelatedInformation", "Page_Live"."MetaTitle", "Page_Live"."HeadingLinkLabel", "Page_Live"."ShowInMobileMenu", "Page_Live"."ShowInDesktopMenu", "Page_Live"."ShowSponsors", "Page_Live"."BannerContent", "Page_Live"."BannerNotification", "Page_Live"."HeadingLinkPageID", "Page_Live"."BannerImageID", "Page_Live"."SidebarWidgetAreaID", "BasicQuiz_Live"."QuizNumber", "BasicQuiz_Live"."ThumbnailID", "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" LEFT JOIN "BasicQuiz_Live" ON "BasicQuiz_Live"."ID" = "SiteTree_Live"."ID" WHERE ("SiteTree_Live"."ShowInMenus" = ?) AND ("SiteTree_Live"."ParentID" = ?) AND ("SiteTree_Live"."ClassName" IN (?)) ORDER BY "SiteTree_Live"."Title" 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"."Version", "SiteTree_Live"."WorkflowDefinitionID", "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"."Version", "SiteTree_Live"."WorkflowDefinitionID", "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"."Version", "SiteTree_Live"."WorkflowDefinitionID", "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"."Version", "SiteTree_Live"."WorkflowDefinitionID", "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"."Version", "SiteTree_Live"."WorkflowDefinitionID", "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"."Version", "SiteTree_Live"."WorkflowDefinitionID", "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"."Version", "SiteTree_Live"."WorkflowDefinitionID", "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

SELECT DISTINCT "Ad"."ClassName", "Ad"."LastEdited", "Ad"."Created", "Ad"."Sponsor", "Ad"."Type", "Ad"."LinkType", "Ad"."ExternalURL", "Ad"."ShowOnChildPages", "Ad"."DisplayType", "Ad"."CountriesValue", "Ad"."ImageID", "Ad"."PageLinkID", "Ad"."ID", CASE WHEN "Ad"."ClassName" IS NOT NULL THEN "Ad"."ClassName" ELSE 'Ad' END AS "RecordClassName" FROM "Ad" INNER JOIN "Ad_Pages" ON "Ad_Pages"."AdID" = "Ad"."ID" WHERE ("Ad_Pages"."PageID" = ?) AND ("Ad"."Type" = ?) AND ("Ad"."CountriesValue" LIKE ?) 0.0007s

SELECT DISTINCT "Ad"."ClassName", "Ad"."LastEdited", "Ad"."Created", "Ad"."Sponsor", "Ad"."Type", "Ad"."LinkType", "Ad"."ExternalURL", "Ad"."ShowOnChildPages", "Ad"."DisplayType", "Ad"."CountriesValue", "Ad"."ImageID", "Ad"."PageLinkID", "Ad"."ID", CASE WHEN "Ad"."ClassName" IS NOT NULL THEN "Ad"."ClassName" ELSE 'Ad' END AS "RecordClassName" FROM "Ad" INNER JOIN "Ad_Pages" ON "Ad_Pages"."AdID" = "Ad"."ID" WHERE ("Ad_Pages"."PageID" = ?) AND ("Ad"."Type" = ?) AND ("Ad"."CountriesValue" LIKE ?) 0.0009s

SELECT DISTINCT "Ad"."ClassName", "Ad"."LastEdited", "Ad"."Created", "Ad"."Sponsor", "Ad"."Type", "Ad"."LinkType", "Ad"."ExternalURL", "Ad"."ShowOnChildPages", "Ad"."DisplayType", "Ad"."CountriesValue", "Ad"."ImageID", "Ad"."PageLinkID", "Ad"."ID", CASE WHEN "Ad"."ClassName" IS NOT NULL THEN "Ad"."ClassName" ELSE 'Ad' END AS "RecordClassName" FROM "Ad" INNER JOIN "Ad_Pages" ON "Ad_Pages"."AdID" = "Ad"."ID" WHERE ("Ad_Pages"."PageID" = ?) AND ("Ad"."Type" = ?) AND ("Ad"."CountriesValue" LIKE ?) 0.0006s

SELECT DISTINCT "Ad"."ClassName", "Ad"."LastEdited", "Ad"."Created", "Ad"."Sponsor", "Ad"."Type", "Ad"."LinkType", "Ad"."ExternalURL", "Ad"."ShowOnChildPages", "Ad"."DisplayType", "Ad"."CountriesValue", "Ad"."ImageID", "Ad"."PageLinkID", "Ad"."ID", CASE WHEN "Ad"."ClassName" IS NOT NULL THEN "Ad"."ClassName" ELSE 'Ad' END AS "RecordClassName" FROM "Ad" INNER JOIN "Ad_Pages" ON "Ad_Pages"."AdID" = "Ad"."ID" WHERE ("Ad_Pages"."PageID" = ?) AND ("Ad"."Type" = ?) AND ("Ad"."CountriesValue" LIKE ?) 0.0007s

SELECT DISTINCT "WidgetArea"."ClassName", "WidgetArea"."LastEdited", "WidgetArea"."Created", "WidgetArea"."ID", CASE WHEN "WidgetArea"."ClassName" IS NOT NULL THEN "WidgetArea"."ClassName" ELSE 'WidgetArea' END AS "RecordClassName" FROM "WidgetArea" WHERE ("WidgetArea"."ID" = ?) LIMIT 1 0.0005s

SELECT DISTINCT "Widget"."ClassName", "Widget"."LastEdited", "Widget"."Created", "Widget"."Title", "Widget"."Sort", "Widget"."Enabled", "Widget"."ParentID", "Widget"."ID", CASE WHEN "Widget"."ClassName" IS NOT NULL THEN "Widget"."ClassName" ELSE 'Widget' END AS "RecordClassName" FROM "Widget" WHERE ("ParentID" = ?) AND ("Widget"."Enabled" = ?) ORDER BY "Widget"."Sort" ASC 0.0006s

SELECT DISTINCT "Widget"."ClassName", "Widget"."LastEdited", "Widget"."Created", "Widget"."Title", "Widget"."Sort", "Widget"."Enabled", "Widget"."ParentID", "Widget"."ID", CASE WHEN "Widget"."ClassName" IS NOT NULL THEN "Widget"."ClassName" ELSE 'Widget' END AS "RecordClassName" FROM "Widget" WHERE ("ParentID" = ?) AND ("Widget"."Enabled" = ?) ORDER BY "Widget"."Sort" ASC 0.0005s

SELECT DISTINCT "Ad"."ClassName", "Ad"."LastEdited", "Ad"."Created", "Ad"."Sponsor", "Ad"."Type", "Ad"."LinkType", "Ad"."ExternalURL", "Ad"."ShowOnChildPages", "Ad"."DisplayType", "Ad"."CountriesValue", "Ad"."ImageID", "Ad"."PageLinkID", "Ad"."ID", CASE WHEN "Ad"."ClassName" IS NOT NULL THEN "Ad"."ClassName" ELSE 'Ad' END AS "RecordClassName" FROM "Ad" INNER JOIN "Ad_Pages" ON "Ad_Pages"."AdID" = "Ad"."ID" WHERE ("Ad_Pages"."PageID" = ?) AND ("Ad"."Type" = ?) AND ("Ad"."CountriesValue" LIKE ?) 0.0004s

SELECT DISTINCT "Widget"."ClassName", "Widget"."LastEdited", "Widget"."Created", "VideoWidget"."YoutubeID", "VideoWidget"."WidgetContent", "VideoWidget"."ThumbnailID", "Widget"."ID", CASE WHEN "Widget"."ClassName" IS NOT NULL THEN "Widget"."ClassName" ELSE 'Widget' END AS "RecordClassName", "Widget"."Sort" FROM "Widget" LEFT JOIN "VideoWidget" ON "VideoWidget"."ID" = "Widget"."ID" WHERE ("VideoWidget"."ID" = 27) AND ("Widget"."ClassName" IN (?)) ORDER BY "Widget"."Sort" ASC LIMIT 1 0.0004s

SELECT DISTINCT "Widget"."ClassName", "Widget"."LastEdited", "Widget"."Created", "ImageWidget"."SubHeading", "ImageWidget"."Image", "ImageWidget"."WidgetContent", "Widget"."ID", CASE WHEN "Widget"."ClassName" IS NOT NULL THEN "Widget"."ClassName" ELSE 'Widget' END AS "RecordClassName", "Widget"."Sort" FROM "Widget" LEFT JOIN "ImageWidget" ON "ImageWidget"."ID" = "Widget"."ID" WHERE ("ImageWidget"."ID" = 26) AND ("Widget"."ClassName" IN (?)) ORDER BY "Widget"."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"."Version", "SiteTree_Live"."WorkflowDefinitionID", "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"."Version", "SiteTree_Live"."WorkflowDefinitionID", "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 "Widget"."ClassName", "Widget"."LastEdited", "Widget"."Created", "HTMLContentWidget"."WidgetContent", "Widget"."ID", CASE WHEN "Widget"."ClassName" IS NOT NULL THEN "Widget"."ClassName" ELSE 'Widget' END AS "RecordClassName", "Widget"."Sort" FROM "Widget" LEFT JOIN "HTMLContentWidget" ON "HTMLContentWidget"."ID" = "Widget"."ID" WHERE ("HTMLContentWidget"."ID" = 28) AND ("Widget"."ClassName" IN (?)) ORDER BY "Widget"."Sort" ASC LIMIT 1 0.0004s

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"."Version", "SiteTree"."WorkflowDefinitionID", "SiteTree"."ParentID", "SiteTree"."ID", CASE WHEN "SiteTree"."ClassName" IS NOT NULL THEN "SiteTree"."ClassName" ELSE 'SiteTree' END AS "RecordClassName" FROM "SiteTree" WHERE ("SiteTree"."ID" = ?) ORDER BY "SiteTree"."Sort" ASC LIMIT 1 0.0005s

SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."URLSegment", "SiteTree_Live"."Title", "SiteTree_Live"."MenuTitle", "SiteTree_Live"."Content", "SiteTree_Live"."MetaDescription", "SiteTree_Live"."ExtraMeta", "SiteTree_Live"."ShowInMenus", "SiteTree_Live"."ShowInSearch", "SiteTree_Live"."Sort", "SiteTree_Live"."HasBrokenFile", "SiteTree_Live"."HasBrokenLink", "SiteTree_Live"."ReportClass", "SiteTree_Live"."CanViewType", "SiteTree_Live"."CanEditType", "SiteTree_Live"."Priority", "SiteTree_Live"."Version", "SiteTree_Live"."WorkflowDefinitionID", "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"."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"."Version", "SiteTree"."WorkflowDefinitionID", "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.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"."Version", "SiteTree_Live"."WorkflowDefinitionID", "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.0003s

SELECT DISTINCT "File"."ClassName", "File"."LastEdited", "File"."Created", "File"."Name", "File"."Title", "File"."Filename", "File"."Content", "File"."ShowInSearch", "File"."OriginalURL", "File"."Label", "File"."OriginalThumbnail", "File"."UseManualThumbnail", "File"."SearchIndex", "File"."CanViewType", "File"."TagsValue", "File"."ParentID", "File"."OwnerID", "File"."CopyrightID", "File"."ManualThumbnailID", "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.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"."Version", "SiteTree_Live"."WorkflowDefinitionID", "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.001s

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"."Version", "SiteTree_Live"."WorkflowDefinitionID", "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.0006s

SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "Page_Live"."OriginalURL", "Page_Live"."RelatedInformation", "Page_Live"."MetaTitle", "Page_Live"."HeadingLinkLabel", "Page_Live"."ShowInMobileMenu", "Page_Live"."ShowInDesktopMenu", "Page_Live"."ShowSponsors", "Page_Live"."BannerContent", "Page_Live"."BannerNotification", "Page_Live"."HeadingLinkPageID", "Page_Live"."BannerImageID", "Page_Live"."SidebarWidgetAreaID", "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" = 37) 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", "Page_Live"."OriginalURL", "Page_Live"."RelatedInformation", "Page_Live"."MetaTitle", "Page_Live"."HeadingLinkLabel", "Page_Live"."ShowInMobileMenu", "Page_Live"."ShowInDesktopMenu", "Page_Live"."ShowSponsors", "Page_Live"."BannerContent", "Page_Live"."BannerNotification", "Page_Live"."HeadingLinkPageID", "Page_Live"."BannerImageID", "Page_Live"."SidebarWidgetAreaID", "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" = 5) AND ("SiteTree_Live"."ClassName" IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)) ORDER BY "SiteTree_Live"."Sort" ASC LIMIT 1 0.0004s

SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "Page_Live"."OriginalURL", "Page_Live"."RelatedInformation", "Page_Live"."MetaTitle", "Page_Live"."HeadingLinkLabel", "Page_Live"."ShowInMobileMenu", "Page_Live"."ShowInDesktopMenu", "Page_Live"."ShowSponsors", "Page_Live"."BannerContent", "Page_Live"."BannerNotification", "Page_Live"."HeadingLinkPageID", "Page_Live"."BannerImageID", "Page_Live"."SidebarWidgetAreaID", "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" = 2491) 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", "Page_Live"."OriginalURL", "Page_Live"."RelatedInformation", "Page_Live"."MetaTitle", "Page_Live"."HeadingLinkLabel", "Page_Live"."ShowInMobileMenu", "Page_Live"."ShowInDesktopMenu", "Page_Live"."ShowSponsors", "Page_Live"."BannerContent", "Page_Live"."BannerNotification", "Page_Live"."HeadingLinkPageID", "Page_Live"."BannerImageID", "Page_Live"."SidebarWidgetAreaID", "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" = 3096) 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", "Page_Live"."OriginalURL", "Page_Live"."RelatedInformation", "Page_Live"."MetaTitle", "Page_Live"."HeadingLinkLabel", "Page_Live"."ShowInMobileMenu", "Page_Live"."ShowInDesktopMenu", "Page_Live"."ShowSponsors", "Page_Live"."BannerContent", "Page_Live"."BannerNotification", "Page_Live"."HeadingLinkPageID", "Page_Live"."BannerImageID", "Page_Live"."SidebarWidgetAreaID", "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" = 2270) 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", "Page_Live"."OriginalURL", "Page_Live"."RelatedInformation", "Page_Live"."MetaTitle", "Page_Live"."HeadingLinkLabel", "Page_Live"."ShowInMobileMenu", "Page_Live"."ShowInDesktopMenu", "Page_Live"."ShowSponsors", "Page_Live"."BannerContent", "Page_Live"."BannerNotification", "Page_Live"."HeadingLinkPageID", "Page_Live"."BannerImageID", "Page_Live"."SidebarWidgetAreaID", "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" = 34) 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", "Page_Live"."OriginalURL", "Page_Live"."RelatedInformation", "Page_Live"."MetaTitle", "Page_Live"."HeadingLinkLabel", "Page_Live"."ShowInMobileMenu", "Page_Live"."ShowInDesktopMenu", "Page_Live"."ShowSponsors", "Page_Live"."BannerContent", "Page_Live"."BannerNotification", "Page_Live"."HeadingLinkPageID", "Page_Live"."BannerImageID", "Page_Live"."SidebarWidgetAreaID", "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" = 3085) 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", "Page_Live"."OriginalURL", "Page_Live"."RelatedInformation", "Page_Live"."MetaTitle", "Page_Live"."HeadingLinkLabel", "Page_Live"."ShowInMobileMenu", "Page_Live"."ShowInDesktopMenu", "Page_Live"."ShowSponsors", "Page_Live"."BannerContent", "Page_Live"."BannerNotification", "Page_Live"."HeadingLinkPageID", "Page_Live"."BannerImageID", "Page_Live"."SidebarWidgetAreaID", "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" = 2) AND ("SiteTree_Live"."ClassName" IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)) ORDER BY "SiteTree_Live"."Sort" ASC LIMIT 1 0.0004s

SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "Page_Live"."OriginalURL", "Page_Live"."RelatedInformation", "Page_Live"."MetaTitle", "Page_Live"."HeadingLinkLabel", "Page_Live"."ShowInMobileMenu", "Page_Live"."ShowInDesktopMenu", "Page_Live"."ShowSponsors", "Page_Live"."BannerContent", "Page_Live"."BannerNotification", "Page_Live"."HeadingLinkPageID", "Page_Live"."BannerImageID", "Page_Live"."SidebarWidgetAreaID", "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" = 36) 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", "Page_Live"."OriginalURL", "Page_Live"."RelatedInformation", "Page_Live"."MetaTitle", "Page_Live"."HeadingLinkLabel", "Page_Live"."ShowInMobileMenu", "Page_Live"."ShowInDesktopMenu", "Page_Live"."ShowSponsors", "Page_Live"."BannerContent", "Page_Live"."BannerNotification", "Page_Live"."HeadingLinkPageID", "Page_Live"."BannerImageID", "Page_Live"."SidebarWidgetAreaID", "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" = 3) 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", "Page_Live"."OriginalURL", "Page_Live"."RelatedInformation", "Page_Live"."MetaTitle", "Page_Live"."HeadingLinkLabel", "Page_Live"."ShowInMobileMenu", "Page_Live"."ShowInDesktopMenu", "Page_Live"."ShowSponsors", "Page_Live"."BannerContent", "Page_Live"."BannerNotification", "Page_Live"."HeadingLinkPageID", "Page_Live"."BannerImageID", "Page_Live"."SidebarWidgetAreaID", "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" = 2398) 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", "Page_Live"."OriginalURL", "Page_Live"."RelatedInformation", "Page_Live"."MetaTitle", "Page_Live"."HeadingLinkLabel", "Page_Live"."ShowInMobileMenu", "Page_Live"."ShowInDesktopMenu", "Page_Live"."ShowSponsors", "Page_Live"."BannerContent", "Page_Live"."BannerNotification", "Page_Live"."HeadingLinkPageID", "Page_Live"."BannerImageID", "Page_Live"."SidebarWidgetAreaID", "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" = 2492) 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"."Version", "SiteTree_Live"."WorkflowDefinitionID", "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.0005s

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

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

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

SELECT DISTINCT "Sponsor"."ClassName", "Sponsor"."LastEdited", "Sponsor"."Created", "Sponsor"."Title", "Sponsor"."Tier", "Sponsor"."ExternalURL", "Sponsor"."SortOrder", "Sponsor"."ImageID", "Sponsor"."ID", CASE WHEN "Sponsor"."ClassName" IS NOT NULL THEN "Sponsor"."ClassName" ELSE 'Sponsor' END AS "RecordClassName" FROM "Sponsor" WHERE ("Sponsor"."Tier" = ?) ORDER BY "Sponsor"."SortOrder" ASC 0.0006s

SELECT DISTINCT "File"."ClassName", "File"."LastEdited", "File"."Created", "File"."Name", "File"."Title", "File"."Filename", "File"."Content", "File"."ShowInSearch", "File"."OriginalURL", "File"."Label", "File"."OriginalThumbnail", "File"."UseManualThumbnail", "File"."SearchIndex", "File"."CanViewType", "File"."TagsValue", "File"."ParentID", "File"."OwnerID", "File"."CopyrightID", "File"."ManualThumbnailID", "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 count(DISTINCT "Sponsor"."ID") AS "Count" FROM "Sponsor" 0.0001s

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

SELECT DISTINCT "Sponsor"."ClassName", "Sponsor"."LastEdited", "Sponsor"."Created", "Sponsor"."Title", "Sponsor"."Tier", "Sponsor"."ExternalURL", "Sponsor"."SortOrder", "Sponsor"."ImageID", "Sponsor"."ID", CASE WHEN "Sponsor"."ClassName" IS NOT NULL THEN "Sponsor"."ClassName" ELSE 'Sponsor' END AS "RecordClassName" FROM "Sponsor" WHERE ("Sponsor"."Tier" = ?) ORDER BY "Sponsor"."SortOrder" ASC 0.0005s

SELECT DISTINCT "File"."ClassName", "File"."LastEdited", "File"."Created", "File"."Name", "File"."Title", "File"."Filename", "File"."Content", "File"."ShowInSearch", "File"."OriginalURL", "File"."Label", "File"."OriginalThumbnail", "File"."UseManualThumbnail", "File"."SearchIndex", "File"."CanViewType", "File"."TagsValue", "File"."ParentID", "File"."OwnerID", "File"."CopyrightID", "File"."ManualThumbnailID", "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"."OriginalURL", "File"."Label", "File"."OriginalThumbnail", "File"."UseManualThumbnail", "File"."SearchIndex", "File"."CanViewType", "File"."TagsValue", "File"."ParentID", "File"."OwnerID", "File"."CopyrightID", "File"."ManualThumbnailID", "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"."OriginalURL", "File"."Label", "File"."OriginalThumbnail", "File"."UseManualThumbnail", "File"."SearchIndex", "File"."CanViewType", "File"."TagsValue", "File"."ParentID", "File"."OwnerID", "File"."CopyrightID", "File"."ManualThumbnailID", "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 count(DISTINCT "Sponsor"."ID") AS "Count" FROM "Sponsor" 0.0001s

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

SELECT DISTINCT "Sponsor"."ClassName", "Sponsor"."LastEdited", "Sponsor"."Created", "Sponsor"."Title", "Sponsor"."Tier", "Sponsor"."ExternalURL", "Sponsor"."SortOrder", "Sponsor"."ImageID", "Sponsor"."ID", CASE WHEN "Sponsor"."ClassName" IS NOT NULL THEN "Sponsor"."ClassName" ELSE 'Sponsor' END AS "RecordClassName" FROM "Sponsor" WHERE ("Sponsor"."Tier" = ?) 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"."OriginalURL", "File"."Label", "File"."OriginalThumbnail", "File"."UseManualThumbnail", "File"."SearchIndex", "File"."CanViewType", "File"."TagsValue", "File"."ParentID", "File"."OwnerID", "File"."CopyrightID", "File"."ManualThumbnailID", "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"."OriginalURL", "File"."Label", "File"."OriginalThumbnail", "File"."UseManualThumbnail", "File"."SearchIndex", "File"."CanViewType", "File"."TagsValue", "File"."ParentID", "File"."OwnerID", "File"."CopyrightID", "File"."ManualThumbnailID", "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"."OriginalURL", "File"."Label", "File"."OriginalThumbnail", "File"."UseManualThumbnail", "File"."SearchIndex", "File"."CanViewType", "File"."TagsValue", "File"."ParentID", "File"."OwnerID", "File"."CopyrightID", "File"."ManualThumbnailID", "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"."OriginalURL", "File"."Label", "File"."OriginalThumbnail", "File"."UseManualThumbnail", "File"."SearchIndex", "File"."CanViewType", "File"."TagsValue", "File"."ParentID", "File"."OwnerID", "File"."CopyrightID", "File"."ManualThumbnailID", "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.001s

SELECT DISTINCT "File"."ClassName", "File"."LastEdited", "File"."Created", "File"."Name", "File"."Title", "File"."Filename", "File"."Content", "File"."ShowInSearch", "File"."OriginalURL", "File"."Label", "File"."OriginalThumbnail", "File"."UseManualThumbnail", "File"."SearchIndex", "File"."CanViewType", "File"."TagsValue", "File"."ParentID", "File"."OwnerID", "File"."CopyrightID", "File"."ManualThumbnailID", "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"."OriginalURL", "File"."Label", "File"."OriginalThumbnail", "File"."UseManualThumbnail", "File"."SearchIndex", "File"."CanViewType", "File"."TagsValue", "File"."ParentID", "File"."OwnerID", "File"."CopyrightID", "File"."ManualThumbnailID", "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"."OriginalURL", "File"."Label", "File"."OriginalThumbnail", "File"."UseManualThumbnail", "File"."SearchIndex", "File"."CanViewType", "File"."TagsValue", "File"."ParentID", "File"."OwnerID", "File"."CopyrightID", "File"."ManualThumbnailID", "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"."OriginalURL", "File"."Label", "File"."OriginalThumbnail", "File"."UseManualThumbnail", "File"."SearchIndex", "File"."CanViewType", "File"."TagsValue", "File"."ParentID", "File"."OwnerID", "File"."CopyrightID", "File"."ManualThumbnailID", "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.001s

SELECT DISTINCT "File"."ClassName", "File"."LastEdited", "File"."Created", "File"."Name", "File"."Title", "File"."Filename", "File"."Content", "File"."ShowInSearch", "File"."OriginalURL", "File"."Label", "File"."OriginalThumbnail", "File"."UseManualThumbnail", "File"."SearchIndex", "File"."CanViewType", "File"."TagsValue", "File"."ParentID", "File"."OwnerID", "File"."CopyrightID", "File"."ManualThumbnailID", "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.0009s

SELECT DISTINCT "File"."ClassName", "File"."LastEdited", "File"."Created", "File"."Name", "File"."Title", "File"."Filename", "File"."Content", "File"."ShowInSearch", "File"."OriginalURL", "File"."Label", "File"."OriginalThumbnail", "File"."UseManualThumbnail", "File"."SearchIndex", "File"."CanViewType", "File"."TagsValue", "File"."ParentID", "File"."OwnerID", "File"."CopyrightID", "File"."ManualThumbnailID", "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.0009s

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

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

SELECT DISTINCT "Sponsor"."ClassName", "Sponsor"."LastEdited", "Sponsor"."Created", "Sponsor"."Title", "Sponsor"."Tier", "Sponsor"."ExternalURL", "Sponsor"."SortOrder", "Sponsor"."ImageID", "Sponsor"."ID", CASE WHEN "Sponsor"."ClassName" IS NOT NULL THEN "Sponsor"."ClassName" ELSE 'Sponsor' END AS "RecordClassName" FROM "Sponsor" WHERE ("Sponsor"."Tier" = ?) ORDER BY "Sponsor"."SortOrder" ASC 0.0007s

SELECT DISTINCT "File"."ClassName", "File"."LastEdited", "File"."Created", "File"."Name", "File"."Title", "File"."Filename", "File"."Content", "File"."ShowInSearch", "File"."OriginalURL", "File"."Label", "File"."OriginalThumbnail", "File"."UseManualThumbnail", "File"."SearchIndex", "File"."CanViewType", "File"."TagsValue", "File"."ParentID", "File"."OwnerID", "File"."CopyrightID", "File"."ManualThumbnailID", "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.0077s

SELECT DISTINCT "File"."ClassName", "File"."LastEdited", "File"."Created", "File"."Name", "File"."Title", "File"."Filename", "File"."Content", "File"."ShowInSearch", "File"."OriginalURL", "File"."Label", "File"."OriginalThumbnail", "File"."UseManualThumbnail", "File"."SearchIndex", "File"."CanViewType", "File"."TagsValue", "File"."ParentID", "File"."OwnerID", "File"."CopyrightID", "File"."ManualThumbnailID", "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.0009s

SELECT DISTINCT "File"."ClassName", "File"."LastEdited", "File"."Created", "File"."Name", "File"."Title", "File"."Filename", "File"."Content", "File"."ShowInSearch", "File"."OriginalURL", "File"."Label", "File"."OriginalThumbnail", "File"."UseManualThumbnail", "File"."SearchIndex", "File"."CanViewType", "File"."TagsValue", "File"."ParentID", "File"."OwnerID", "File"."CopyrightID", "File"."ManualThumbnailID", "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"."OriginalURL", "File"."Label", "File"."OriginalThumbnail", "File"."UseManualThumbnail", "File"."SearchIndex", "File"."CanViewType", "File"."TagsValue", "File"."ParentID", "File"."OwnerID", "File"."CopyrightID", "File"."ManualThumbnailID", "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"."OriginalURL", "File"."Label", "File"."OriginalThumbnail", "File"."UseManualThumbnail", "File"."SearchIndex", "File"."CanViewType", "File"."TagsValue", "File"."ParentID", "File"."OwnerID", "File"."CopyrightID", "File"."ManualThumbnailID", "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"."OriginalURL", "File"."Label", "File"."OriginalThumbnail", "File"."UseManualThumbnail", "File"."SearchIndex", "File"."CanViewType", "File"."TagsValue", "File"."ParentID", "File"."OwnerID", "File"."CopyrightID", "File"."ManualThumbnailID", "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.0008s

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

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

SELECT DISTINCT "Sponsor"."ClassName", "Sponsor"."LastEdited", "Sponsor"."Created", "Sponsor"."Title", "Sponsor"."Tier", "Sponsor"."ExternalURL", "Sponsor"."SortOrder", "Sponsor"."ImageID", "Sponsor"."ID", CASE WHEN "Sponsor"."ClassName" IS NOT NULL THEN "Sponsor"."ClassName" ELSE 'Sponsor' END AS "RecordClassName" FROM "Sponsor" WHERE ("Sponsor"."Tier" = ?) ORDER BY "Sponsor"."SortOrder" ASC 0.0004s

SELECT DISTINCT "File"."ClassName", "File"."LastEdited", "File"."Created", "File"."Name", "File"."Title", "File"."Filename", "File"."Content", "File"."ShowInSearch", "File"."OriginalURL", "File"."Label", "File"."OriginalThumbnail", "File"."UseManualThumbnail", "File"."SearchIndex", "File"."CanViewType", "File"."TagsValue", "File"."ParentID", "File"."OwnerID", "File"."CopyrightID", "File"."ManualThumbnailID", "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"."OriginalURL", "File"."Label", "File"."OriginalThumbnail", "File"."UseManualThumbnail", "File"."SearchIndex", "File"."CanViewType", "File"."TagsValue", "File"."ParentID", "File"."OwnerID", "File"."CopyrightID", "File"."ManualThumbnailID", "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.001s

SELECT DISTINCT "File"."ClassName", "File"."LastEdited", "File"."Created", "File"."Name", "File"."Title", "File"."Filename", "File"."Content", "File"."ShowInSearch", "File"."OriginalURL", "File"."Label", "File"."OriginalThumbnail", "File"."UseManualThumbnail", "File"."SearchIndex", "File"."CanViewType", "File"."TagsValue", "File"."ParentID", "File"."OwnerID", "File"."CopyrightID", "File"."ManualThumbnailID", "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.001s

SELECT DISTINCT "File"."ClassName", "File"."LastEdited", "File"."Created", "File"."Name", "File"."Title", "File"."Filename", "File"."Content", "File"."ShowInSearch", "File"."OriginalURL", "File"."Label", "File"."OriginalThumbnail", "File"."UseManualThumbnail", "File"."SearchIndex", "File"."CanViewType", "File"."TagsValue", "File"."ParentID", "File"."OwnerID", "File"."CopyrightID", "File"."ManualThumbnailID", "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.0008s

SELECT DISTINCT "File"."ClassName", "File"."LastEdited", "File"."Created", "File"."Name", "File"."Title", "File"."Filename", "File"."Content", "File"."ShowInSearch", "File"."OriginalURL", "File"."Label", "File"."OriginalThumbnail", "File"."UseManualThumbnail", "File"."SearchIndex", "File"."CanViewType", "File"."TagsValue", "File"."ParentID", "File"."OwnerID", "File"."CopyrightID", "File"."ManualThumbnailID", "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.0008s

SELECT DISTINCT "File"."ClassName", "File"."LastEdited", "File"."Created", "File"."Name", "File"."Title", "File"."Filename", "File"."Content", "File"."ShowInSearch", "File"."OriginalURL", "File"."Label", "File"."OriginalThumbnail", "File"."UseManualThumbnail", "File"."SearchIndex", "File"."CanViewType", "File"."TagsValue", "File"."ParentID", "File"."OwnerID", "File"."CopyrightID", "File"."ManualThumbnailID", "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.0008s

SELECT DISTINCT "File"."ClassName", "File"."LastEdited", "File"."Created", "File"."Name", "File"."Title", "File"."Filename", "File"."Content", "File"."ShowInSearch", "File"."OriginalURL", "File"."Label", "File"."OriginalThumbnail", "File"."UseManualThumbnail", "File"."SearchIndex", "File"."CanViewType", "File"."TagsValue", "File"."ParentID", "File"."OwnerID", "File"."CopyrightID", "File"."ManualThumbnailID", "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.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"."Version", "SiteTree_Live"."WorkflowDefinitionID", "SiteTree_Live"."ParentID", "Page_Live"."OriginalURL", "Page_Live"."RelatedInformation", "Page_Live"."MetaTitle", "Page_Live"."HeadingLinkLabel", "Page_Live"."ShowInMobileMenu", "Page_Live"."ShowInDesktopMenu", "Page_Live"."ShowSponsors", "Page_Live"."BannerContent", "Page_Live"."BannerNotification", "Page_Live"."HeadingLinkPageID", "Page_Live"."BannerImageID", "Page_Live"."SidebarWidgetAreaID", "UserDefinedForm_Live"."SubmitButtonText", "UserDefinedForm_Live"."ClearButtonText", "UserDefinedForm_Live"."OnCompleteMessage", "UserDefinedForm_Live"."ShowClearButton", "UserDefinedForm_Live"."DisableSaveSubmissions", "UserDefinedForm_Live"."EnableLiveValidation", "UserDefinedForm_Live"."HideFieldLabels", "UserDefinedForm_Live"."DisplayErrorMessagesAtTop", "UserDefinedForm_Live"."DisableAuthenicatedFinishAction", "UserDefinedForm_Live"."DisableCsrfSecurityToken", "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" LEFT JOIN "UserDefinedForm_Live" ON "UserDefinedForm_Live"."ID" = "SiteTree_Live"."ID" WHERE ("SiteTree_Live"."Title" = ?) AND ("SiteTree_Live"."ClassName" IN (?)) ORDER BY "SiteTree_Live"."Sort" ASC LIMIT 1 0.0012s

SELECT DISTINCT "MenuSet"."ClassName", "MenuSet"."LastEdited", "MenuSet"."Created", "MenuSet"."Name", "MenuSet"."ID", CASE WHEN "MenuSet"."ClassName" IS NOT NULL THEN "MenuSet"."ClassName" ELSE 'MenuSet' END AS "RecordClassName" FROM "MenuSet" WHERE ("MenuSet"."Name" = ?) LIMIT 1 0.0006s

SELECT DISTINCT "MenuItem"."ClassName", "MenuItem"."LastEdited", "MenuItem"."Created", "MenuItem"."MenuTitle", "MenuItem"."Link", "MenuItem"."Sort", "MenuItem"."IsNewWindow", "MenuItem"."PageID", "MenuItem"."MenuSetID", "MenuItem"."ID", CASE WHEN "MenuItem"."ClassName" IS NOT NULL THEN "MenuItem"."ClassName" ELSE 'MenuItem' END AS "RecordClassName" FROM "MenuItem" WHERE ("MenuSetID" = ?) ORDER BY "MenuItem"."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"."Version", "SiteTree_Live"."WorkflowDefinitionID", "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

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"."Version", "SiteTree_Live"."WorkflowDefinitionID", "SiteTree_Live"."ParentID", "SiteTree_Live"."ID", CASE WHEN "SiteTree_Live"."ClassName" IS NOT NULL THEN "SiteTree_Live"."ClassName" ELSE 'SiteTree' END AS "RecordClassName" FROM "SiteTree_Live" WHERE ("SiteTree_Live"."ID" = ?) ORDER BY "SiteTree_Live"."Sort" ASC LIMIT 1 0.0009s

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

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

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

SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."URLSegment", "SiteTree_Live"."Title", "SiteTree_Live"."MenuTitle", "SiteTree_Live"."Content", "SiteTree_Live"."MetaDescription", "SiteTree_Live"."ExtraMeta", "SiteTree_Live"."ShowInMenus", "SiteTree_Live"."ShowInSearch", "SiteTree_Live"."Sort", "SiteTree_Live"."HasBrokenFile", "SiteTree_Live"."HasBrokenLink", "SiteTree_Live"."ReportClass", "SiteTree_Live"."CanViewType", "SiteTree_Live"."CanEditType", "SiteTree_Live"."Priority", "SiteTree_Live"."Version", "SiteTree_Live"."WorkflowDefinitionID", "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

Online courses for medical practitioners | DermNet New Zealand

Online courses for medical practitioners


Guidelines 

Dermatology practice guidelines
Guidelines for diagnosis and assessment of eczema
Guidelines for the management of adult eczema
Guidelines for the management of psoriasis
Guidelines for the outpatient management of childhood eczema
Liquid nitrogen/cyrotherapy guidelines

External Resources

Australasian medical associations
Dermatology journals
Dermatology resources for health professionals  
Dermatology societies and organisations
Worldwide dermatology links
University of Auckland FMHS Dermatology course for medical students

Red rash made easy

Red rash made easy. University of Auckland Goodfellow Unit course.