select nw.workorderid"RequestID",nof.notificationtitle"Survey Message",nof.notificationtype'Type',au.first_name"Sent To" from notification nof
left join notify_workorder nw on nw.notificationid=nof.notificationid
left join aaauser au on au.user_id=nof.recipientid
where notificationtitle like '%improve%survey%'
and nw.WORKORDERID not in (Select WORKORDERID from SurveyPerRequest)