How to get the latest approvers and rejection user name from workflow of Change using the backend ap

I have tried with below query but it is getting my old rejection which means if the change status has been moved from CCB to pending back and again back to CCB then it is fetching the old rejection list too.  select c.change_number,listagg(so.user_name_assigned, ';' ) within group (order by c.change_number) as "Rejected_Approval",listagg(sr.user_name_assigned, ';' ) within group (order by c1.change_number) as "Rejected_Approval" from agile.change c,agile.change c1, agile.signoff so,agile.signoff sr where c.id=so.change_id and so.signoff_status=3 and c.change_number='ECO-40470' and c1.id=sr.change_id and sr.signoff_status=3 and sr.flags like '000000%' and c.id=c1.id group by c.change_number,c1.change_number