SELECT * FROM `hao_soft` as a,`hao_softinfo` as b where a.id=b.nid and a.pass='1' and a.cid='8' and a.id='65926'