select @faasid := fl.objid, fl.tdno, rl.faasid from faas_list fl left join rptledger rl on rl.faasid = fl.objid left join rptledgerfaas rlf on rlf.faasid = fl.objid where fl.state = 'current' and fl.ry = 2020 and rlf.objid is null;