Skip to content

Instantly share code, notes, and snippets.

@jamescoxhead

jamescoxhead/NodeDocumentTypes.sql

Created April 16, 2019 14:54
Show Gist options
  • Save jamescoxhead/eafc20ca2449125ec7045248f74a6d10 to your computer and use it in GitHub Desktop.
Save jamescoxhead/eafc20ca2449125ec7045248f74a6d10 to your computer and use it in GitHub Desktop.
Download ZIP
Lists Umbraco content and media nodes and their corresponding document type alias
Raw
NodeDocumentTypes.sql
SELECT C.nodeId, CT.alias, N.text FROM cmsContent C
INNER JOIN cmsContentType CT ON C.contentType = CT.nodeId
INNER JOIN umbracoNode N ON C.nodeId = N.id
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment