select distinct ownerId, ownerType from tbl_bcrm_objectives where recalcExecuted = 0 and Ready = 'y' and GETDATE() >= PublishDate and GETDATE() <= UnpublishDate and objlevel <> 'p' and ownerId = and ownerType =