select coalesce( mfrCallSharingConfig, '{ "enabled" : false }' ) as mfrCallSharingConfig, m.mfr_name, m.oneFSEnabled from tbl_BRO_Principals p with (nolock) inner join tblManufacturers m with (nolock) on m.mfr_id = p.mfrId where p.ownerId = and p.ownerType = and p.mfrId = _mfrCallSharingOptionsJSON = '{"enabled" : false }'>