SQL Query that produces a list of items that directly or indirectly inherit from NavigableItemBase

navitembase-inherit.sql

WITH ClassHierarchy AS
(
--initialization
SELECT [ClassName], [ClassDisplayName], ClassID, ClassInheritsFromClassID
FROM CMS_Class
WHERE [ClassName] = 'ContentBase.NavigableItemBase'
UNION ALL
--recursive execution
SELECT e.ClassName, e.[ClassDisplayName], e.ClassID, e.ClassInheritsFromClassID
FROM CMS_Class e INNER JOIN ClassHierarchy m
ON e.ClassInheritsFromClassID = m.ClassID
)
SELECT [ClassName],[ClassDisplayName] FROM ClassHierarchy