Umbraco SQl to Find Nodes using a Certain Document Type
10/07/2013 Leave a comment
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’
–use the node path to locate nodes in Umbraco
Advertisements