Umbraco document types grouped by the count of pages that use it (run via LINQPad)

gistfile1.cs

(from dt in CmsDocumentTypes
join n in UmbracoNodes on dt.ContentTypeNodeId equals n.Id
select new {
	n.Id,
	n.Text,
	Docs = CmsContents.Where(c => c.ContentType == n.Id).Where(c => !c.Node.Trashed).Count(),
	IsNested = n.ParentID != -1
})
.Distinct()
.GroupBy(x => x.Docs)
.Select(x => new {
	x.Key,
	Value = x.OrderBy(y => y.IsNested).ThenBy(y => y.Id)
})