select disposition, contactid, cdrdistributorid, interactiondate, interactionPurposeId, partnertype, partnerid, thankYouSent, interactionMethod, dispositionUserId from tbl_crm_interactions where interactionid = and ownerid = and ownertype = select statuscode from tbl_spl_stages where ownerid = and ownertype = and statusCode in ('C','R') and requireSku = 'y' select * from qryPurposes union select * from qryPurposesInactive select allowFinalizeWithoutProducts from tbl_CRM_InteractionPurposes where purposeid = select interactiondetailid from qcf_dispInteractionProducts where itemType <> 'OBJLBL' and ready = 'N'