insert into UseRecordToRecycleApplication(convertUserCode,convertUserName,invoicePlanId,useRecordId)
select su.name,ip.applicant,ra.id,ra.userecord_id from RecyclingApplication ra join invoicePlan ip on ra.id=ip.id
left join SS_USERS su on ip.applicant=su.fullName where ra.userecord_id is not null
and ra.userecord_id not in (select userecord_id from UseRecordToRecycleApplication);