Skip to content

Instantly share code, notes, and snippets.

@ss23

ss23/foo.sql

Last active December 19, 2015 09:09
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save ss23/5930644 to your computer and use it in GitHub Desktop.
Save ss23/5930644 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
foo.sql
SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."Created", "SiteTree_Live"."LastEdited", "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"."PublicHistory", "SiteTree_Live"."DesiredPublishDate", "SiteTree_Live"."DesiredUnPublishDate", "SiteTree_Live"."PublishOnDate", "SiteTree_Live"."UnPublishOnDate", "SiteTree_Live"."Version", "SiteTree_Live"."PublishJobID", "SiteTree_Live"."UnPublishJobID", "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" = 2153)
ORDER BY "SiteTree_Live"."Sort" ASC
LIMIT 1
0.0003ms
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment