select k.objectid from (select c.objectid, c.attrasfloat from (select c2.objectid, c2.attrasfloat from cardattrs c2 
where c2.objectid  = 4021825
and c2.attrcode = 'STATEID'
and c2.attrid < (select c1.attrid from cardattrs c1 where c1.objectid = 4021825 and c1.attrasfloat = 13000406)
order by c2.attrid desc ) c
where rownum = 1 ) k
where k.attrasfloat = 13000412