select partnerid, partnertype, participantid from tbl_crm_interactions where interactionid = and ownerid = and ownertype = select * from qmd_marketingActivities where version >= 2 and unpublishDate >= order by endDate desc