SET sql_mode = ? 0.0004s

SHOW DATABASES LIKE 'ss_dermnet' 0.0005s

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

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

SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "Page_Live"."OriginalURL", "Page_Live"."RelatedInformation", "Page_Live"."MetaTitle", "Page_Live"."HeadingLinkLabel", "Page_Live"."ShowInMobileMenu", "Page_Live"."ShowInDesktopMenu", "Page_Live"."ShowSponsors", "Page_Live"."BannerContent", "Page_Live"."BannerNotification", "Page_Live"."HeadingLinkPageID", "Page_Live"."BannerImageID", "Page_Live"."SidebarWidgetAreaID", "SiteTree_Live"."ID", CASE WHEN "SiteTree_Live"."ClassName" IS NOT NULL THEN "SiteTree_Live"."ClassName" ELSE 'SiteTree' END AS "RecordClassName", "SiteTree_Live"."Sort" FROM "SiteTree_Live" LEFT JOIN "Page_Live" ON "Page_Live"."ID" = "SiteTree_Live"."ID" WHERE ("Page_Live"."ID" = 2491) AND ("SiteTree_Live"."ClassName" IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)) ORDER BY "SiteTree_Live"."Sort" 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.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", "File"."ID", CASE WHEN "File"."ClassName" IS NOT NULL THEN "File"."ClassName" ELSE 'File' END AS "RecordClassName" FROM "File" WHERE ("File"."ID" = ?) ORDER BY "File"."Name" ASC LIMIT 1 0.0005s

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

SELECT DISTINCT "Ad"."ClassName", "Ad"."LastEdited", "Ad"."Created", "Ad"."Sponsor", "Ad"."Type", "Ad"."LinkType", "Ad"."ExternalURL", "Ad"."ShowOnChildPages", "Ad"."DisplayType", "Ad"."CountriesValue", "Ad"."ImageID", "Ad"."PageLinkID", "Ad"."ID", CASE WHEN "Ad"."ClassName" IS NOT NULL THEN "Ad"."ClassName" ELSE 'Ad' END AS "RecordClassName" FROM "Ad" INNER JOIN "Ad_Pages" ON "Ad_Pages"."AdID" = "Ad"."ID" WHERE ("Ad_Pages"."PageID" = ?) AND ("Ad"."Type" = ?) AND ("Ad"."CountriesValue" LIKE ?) 0.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 "WidgetArea"."ClassName", "WidgetArea"."LastEdited", "WidgetArea"."Created", "WidgetArea"."ID", CASE WHEN "WidgetArea"."ClassName" IS NOT NULL THEN "WidgetArea"."ClassName" ELSE 'WidgetArea' END AS "RecordClassName" FROM "WidgetArea" WHERE ("WidgetArea"."ID" = ?) LIMIT 1 0.0005s

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

SELECT DISTINCT "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.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.0005s

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

SELECT DISTINCT "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 "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.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.0005s

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

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

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

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

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.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" = 2270) 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", "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.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" = 3085) 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", "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.0008s

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

| DermNet New Zealand
A B C D E F G H I J K L M N O P Q R S T U V W X Y Z