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’