SET sql_mode = ? 0.0002s

SHOW DATABASES LIKE 'ss_dermnet' 0.0003s

SHOW TABLES 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"."URLSegment" = ?) AND ("SiteTree_Live"."ParentID" = ?) 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"."ParentID" = ?) AND ("SiteTree_Live"."URLSegment" = ?) ORDER BY "SiteTree_Live"."Sort" ASC LIMIT 1 0.0017s

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

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

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

SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "TopicPage_Live"."AuthorText", "TopicPage_Live"."HomePageSort", "TopicPage_Live"."SynonymsValue", "SiteTree_Live"."ID", CASE WHEN "SiteTree_Live"."ClassName" IS NOT NULL THEN "SiteTree_Live"."ClassName" ELSE 'SiteTree' END AS "RecordClassName", "SiteTree_Live"."Title" FROM "SiteTree_Live" LEFT JOIN "Page_Live" ON "Page_Live"."ID" = "SiteTree_Live"."ID" LEFT JOIN "TopicPage_Live" ON "TopicPage_Live"."ID" = "SiteTree_Live"."ID" WHERE ("TopicPage_Live"."ID" = 1006) AND ("SiteTree_Live"."ClassName" IN (?)) ORDER BY "SiteTree_Live"."Title" ASC LIMIT 1 0.0005s

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

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

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

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" = 1006) AND ("SiteTree_Live"."ClassName" IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)) 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.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.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 "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.0002s

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

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

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

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

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

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

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.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 "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.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"."ShowInMenus" = ?) AND ("SiteTree_Live"."ParentID" = ?) ORDER BY "SiteTree_Live"."Sort" ASC 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" = 37) 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", "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.001s

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.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" = 2270) 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" = 34) 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" = 3085) 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" = 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.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" = 3) 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" = 2398) 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" = 2492) 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", "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 "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.0006s

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

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

Acute generalised exanthematous pustulosis pathology | DermNet New Zealand

Acute generalised exanthematous pustulosis pathology

Author: Assoc Prof Patrick Emanuel, Dermatopathologist, Auckland, New Zealand, 2013.


Acute Generalised Exanthematous Pustulosis (AGEP) is a rare dermatosis that presents as multiple pustules on a generalized erythematous eruption. Numerous causative drugs and infections have been implicated.

Histology of AGEP

In AGEP, there is spongiosis and minimal acanthosis of the epidermis. Neutrophilic spongiotic pustules are the most striking feature (figure 1, 2). These pustules are present within the stratum corneum and/or the epidermis. Sometimes, apoptotic keratinocytes are seen in the adjacent epidermis. There is often a dermal response which is rich in lymphocytes and eosinophils (figure 3).

Acute Generalised Exanthematous Pustulosis (AGEP) pathology

Special studies for AGEP

None are generally needed. The pustulation may prompt examination of a PAS stain to rule out a fungal aetiology

Differential diagnosis of AGEP

Pustular psoriasis – Psoriasis usually shows more impressive postulation, minimal spongiosis and a usually lacks dermal eosinophilia.

Subcorneal pustular dermatosis – The pustules rest over the epidermis and do not form epidermal pustules. Spongiosis is usually not overt. There may be clinical and pathologic overlap in some cases.

IgA pemphigus – The intraepidermal form of IgA pemphigus may closely resemble AGEP. Immunofluorescence may be helpful in distinguishing these entities.

Bullous impetigo – Gram stains should show some subcorneal bacteria. Epidermal neutrophilic postulation is generally not a feature.

.

 

Related Information

References:

  • Pathology of the Skin (Fourth edition, 2012). McKee PH, J. Calonje JE, Granter SR

On DermNet NZ:

Books:

See the DermNet NZ bookstore