SELECT * FROM (select a.id, a.digest,if(a.digest>0,1,0) ifdigest, a.role_type,a.thumb,a.title,a.updatetime,a.catid,a.userid,a.inputtime,a.modelid,b.content from `v9_works_all` a INNER JOIN `v9_works_all_data` b ON a.id=b.id AND catid in(4347) INNER JOIN `v9_member` me ON a.userid = me.userid where (a.status=99 or a.status=1) AND catid in(4347)) a order by a.ifdigest desc,a.inputtime desc LIMIT 0,15