Skip to content

Instantly share code, notes, and snippets.

@bradleykronson

bradleykronson/find-nodes-of-alias.sql

Created August 19, 2013 09:55
Show Gist options
  • Save bradleykronson/7994dfc7c2c197dd6be1 to your computer and use it in GitHub Desktop.
Save bradleykronson/7994dfc7c2c197dd6be1 to your computer and use it in GitHub Desktop.
Download ZIP
SQL to Find Nodes using a Certain Document Type.cs
Raw
find-nodes-of-alias.sql
SELECT * FROM cmsContent C
INNER JOIN cmsContentType CT ON C.contentType = CT.nodeId
INNER JOIN umbracoNode N ON C.nodeId = N.id
WHERE CT.alias = ‘yourDocumentTypeAliasHere’
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment