select
umbracoNode.id as Id,
Text as DocumentTypeName,
cmsContentType.Alias as DocumentTypeAlias,
Name as FieldName,
cmsPropertyType.Alias as FieldAlias
from cmsPropertyType
inner join umbracoNode on cmsPropertyType.contentTypeId = umbracoNode.id
inner join cmsContentType on cmsContentType.NodeId = umbracoNode.id
order by text