SELECT m.MFR_ID, m.MFR_NAME FROM dbo.tblManufacturers m WHERE mfr_id IN (SELECT OwnerId FROM tbl_SYS_SavedReports WHERE OwnerType = 'MFR' AND temporary = 'N' GROUP BY OwnerId ) order by m.MFR_NAME for json path