Umbraco - Get only image folders with childrens

Umbraco - Get media folders with childrens

Declare @folders TABLE (id int , path nvarchar(300) COLLATE SQL_Latin1_General_CP1_CI_AS) 

insert into @folders

select 
	id, path, text
from 
	umbracoNode as N
		INNER JOIN cmsContent as C ON C.nodeId = N.id
		INNER JOIN cmsContentType as CT ON C.contentType = CT.nodeId and CT.alias = 'folder' 


-- carpetas con hijos
select
	F.id
from 
	umbracoNode as N
		INNER JOIN cmsContent as C ON C.nodeId = N.id
		INNER JOIN cmsContentType as CT ON C.contentType = CT.nodeId and (CT.alias = 'folder' or CT.alias = 'image')
		INNER JOIN @folders as F ON F.path like N.path + ',%'