SET sql_mode = ? 0.0004s

SHOW DATABASES LIKE 'ss_dermnet' 0.0007s

SHOW TABLES 0.0013s

SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."URLSegment", "SiteTree_Live"."Title", "SiteTree_Live"."MenuTitle", "SiteTree_Live"."Content", "SiteTree_Live"."MetaDescription", "SiteTree_Live"."ExtraMeta", "SiteTree_Live"."ShowInMenus", "SiteTree_Live"."ShowInSearch", "SiteTree_Live"."Sort", "SiteTree_Live"."HasBrokenFile", "SiteTree_Live"."HasBrokenLink", "SiteTree_Live"."ReportClass", "SiteTree_Live"."CanViewType", "SiteTree_Live"."CanEditType", "SiteTree_Live"."Priority", "SiteTree_Live"."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.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"."ParentID" = ?) AND ("SiteTree_Live"."URLSegment" = ?) 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 "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 "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 "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" = 2578) AND ("SiteTree_Live"."ClassName" IN (?)) ORDER BY "SiteTree_Live"."Title" ASC LIMIT 1 0.0006s

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

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

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

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

SELECT DISTINCT "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.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 "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" = 2578) 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", "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.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.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.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.0007s

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

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

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

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

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

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

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

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

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

SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "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.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", "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.0005s

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

Atrophoderma of Pasini and Pierini | DermNet New Zealand

Atrophoderma of Pasini and Pierini

Author: Dr. Karen Koch, Consultant Dermatologist, WITS Donald Gordon Mediclinic, Johannesburg, South Africa. DermNet New Zealand Editor-in-Chief: Prof Amanda Oakley, Dermatologist, Hamilton, New Zealand. Copy editor: Gus Mitchell, November 2017.


What is atrophoderma of Pasini and Pierini?

Atrophoderma of Pasini and Pierini is a rare disorder of dermal atrophy characterised by well-circumscribed slightly depressed areas, usually on the trunk. The border between normal skin and the area of atrophy has a well-defined, ‘cliff drop’ edge.

Atrophoderma of Pasini and Pierini

Who gets atrophoderma of Pasini and Pierini?

Atrophoderma of Pasini and Pierini most commonly starts during adolescence or early adulthood. Paediatric and congenital onset have been reported [1]. It occurs more frequently in women than men [2].

What causes atrophoderma of Pasini and Pierini?

The exact cause of atrophoderma of Pasini and Pierini is not known. It is unclear whether it is a distinct disease entity or a disorder on the spectrum of morphoea (localised scleroderma). 

An immunological mechanism triggered by Borrelia burgdorferi, the cause of Lyme disease, has been proposed in at least a subset of patients, based on histological findings of an abnormal T-cell immunophenotype in the dermis and significantly raised B. burgdorferi IgG levels in affected individuals [2].

Improvement in atrophoderma of Pasini and Pierini has occurred during treatment with doxycycline in a patient with immunoglobulin M antibodies to B. burgdorferi [3].

What are the clinical features of atrophoderma of Pasini and Pierini? 

Atrophoderma of Pasini and Pierini classically presents as asymptomatic depressed areas on the trunk and extremities.  

  • Lesions can be solitary or multiple.
  • They tend to be oval or round.
  • Hyperpigmented, hypopigmented and normal skin-coloured areas may be present.
  • The texture is normal, eg, there is no induration.
  • Size ranges from 1–12 cm in size.
  • The  most common site is the back or lumbosacral region followed by chest, arms and abdomen, sparing the face, hands and feet [4, 5].

Atrophoderma of Pasini and Pierini may be stable or gradually progressive. Older lesions enlarge with time and may coalesce to form large irregularly pigmented areas, referred to as ‘footprints in the snow’ or a ‘moth-eaten’ appearance. New lesions may continue to develop for several decades.

Established lesions demonstrate a sharp demarcation between normal skin and atrophic areas known as a ‘cliff drop’ edge. The depth of depression ranges from 1–8 mm. This may best be observed with lighting from an angle.

What are the complications of atrophoderma of Pasini and Pierini?

Atrophoderma of Pasini and Pierini tends to be progressive with further disfigurement of the affected area. There have been no reports of progression to morphoea or other complications.

How is atrophoderma of Pasini and Pierini diagnosed?

The diagnosis of atrophoderma of Pasini and Pierini is usually made on history and clinical examination. Skin biopsy is most often non-contributory.

A wedge biopsy of involved and uninvolved skin may show:

  • Flattening of the dermal papillae and rete ridges
  • Sparse perivascular and/or perifollicular lymphocytic infiltrate
  • Clumping of collagen fibres
  • Elastic stains may show a decrease in elastic fibres.

IgG and IgM serology for B. burgdorferi should be assessed in endemic areas.

What is the differential diagnosis for atrophoderma of Pasini and Pierini?

Several skin conditions should be considered in the differential diagnosis of atrophoderma of Pasini and Pierini.

  • Anetoderma — multiple round well-defined 1–2 cm depressed lesions with overlying wrinkly skin, the so-called ‘button-hole’ sign.
  • Lichen sclerosus — white, polygonal papules that coalesce into porcelain white plaques. Depressed ovoid lesions are absent.
  • Late stage of morphoea — shiny hypopigmented or hyperpigmented plaques with poorly demarcated depressed areas. There is a preceding history of inflammation and sclerosis.
  • Postinflammatory hyperpigmentation — this follows a wide range of inflammatory skin disorders. The skin is of normal thickness and does not demonstrate any atrophy.

What is the treatment for atrophoderma of Pasini and Pierini?

There is no completely effective treatment for atrophoderma of Pasini and Pierini. Cosmetic camouflage may be considered.

Specific treatments include:

What is the outcome for atrophoderma of Pasini and Pierini?

The long-term outcome of atrophoderma of Pasini and Pierini is usually good. Spontaneous improvement may occur over years or decades.

 

Related Information

References

  1. Kang CY, Lam J. Congenital idiopathic atrophoderma of Pasini and Pierini. Int J Dermatol. 2015; 54(1): 44–6. PubMed.
  2. Buechner SA, Rufli T. Atrophoderma of Pasini and Pierini. Clinical and histopathologic findings and antibodies to Borrelia burgdorferi in thirty-four patients. J Am Acad Dermatol. 1994; 30(3): 441–6. PubMed.
  3. Lee Y, Oh Y, Ahn SY, Park HY, Choi EH. A Case of Atrophoderma of Pasini and Pierini Associated with Borrelia burgdorferi Infection Successfully Treated with Oral Doxycycline. Ann Dermatol. 2011; 23(3): 352–6. PubMed.
  4. Saleh Z, Abbas O, Dahdah MJ, Kibbi AG, Zaynoun S, Ghosn S. Atrophoderma of Pasini and Pierini: a clinical and histopathological study. J Cutan Pathol. 2008; 35(12): 1108–14. PubMed.
  5. Avancini J, Valente NY, Romiti R. Generalized lenticular atrophoderma of Pasini and Pierini. Pediatr Dermatol. 2015; 32(3): 389–91. PubMed.
  6. Arpey CJ, Patel DS, Stone MS, Qiang-Shao J, Moore KC. Treatment of atrophoderma of Pasini and Pierini-associated hyperpigmentation with the Q-switched alexandrite laser: a clinical, histologic, and ultrastructural appraisal. Lasers Surg Med. 2000; 27(3): 206–12. PubMed.

On DermNet NZ

Other websites

Books about skin diseases

See the DermNet NZ bookstore.