select vv.* , cc.Text from vefn_GetVersionFormatItems('136,137,138,139') vv join Contents CC on CC.ContentID = VV.ContentID where text like '%u916[a-zA-Z]%' --join docversions dv on vv.versionid = dv.versionid --Join folders ff on ff.FolderID = DV.FolderID --Join folders pf on pf.FolderID = ff.parentID --Join folders gf on gf.FolderID = pf.parentid --join formats fm on fm.formatid = vv.formatid select vv.versionid, ff.name folder, pf.name parent, gf.name grandparent, vv.formatid, fm.name, count(*) HowMany from vefn_GetVersionFormatItems('') vv join docversions dv on vv.versionid = dv.versionid Join folders ff on ff.FolderID = DV.FolderID Join folders pf on pf.FolderID = ff.parentID Join folders gf on gf.FolderID = pf.parentid join formats fm on fm.formatid = vv.formatid group by vv.versionid, ff.name, pf.name, gf.name, vv.formatid, fm.name