select if(r.linked  = 'yes' and r.status = 'active',1,0) as reciprocolLink, a.* from attorneys a left join reciprocal r on r.username = a.username  where a.username = 'deepali'  and a.status in (1,2,3,5)   group by a.username limit 1