select a.id, a.digest, 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(4346) INNER JOIN `v9_member` me ON a.userid = me.userid where (a.status=99 or a.status=1) and a.province=43 order by a.inputtime desc LIMIT 0,15