uhateoas
8/19/2013 - 9:55 AM

SQL to Find Nodes using a Certain Document Type.cs

SQL to Find Nodes using a Certain Document Type.cs

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’