select
    ins.res_id, ins.res_type, wki.inst_id, ins.uid
from
    wkf_workitem wki
    JOIN wkf_instance ins ON ins.id = wki.inst_id
group by
    inst_id, ins.res_id, ins.res_type, ins.uid
having
    count(*) > 1
;