select classificationId from tbl_OPR_Classifications with (nolock) where abbreviation = 'BOB' and ownerId = and ownerType = select classificationId from tbl_OPR_Classifications with (nolock) where classificationId not in ( ) and ownerId = and ownerType = select classificationId from tbl_CDR_Classifications with (nolock) where abbreviation = 'BOB' and ownerId = and ownerType = select classificationId from tbl_CDR_Classifications where classificationId not in ( ) and ownerId = and ownerType =