select distinct newstb.tid,newstb.username,usertb.realname,titletb.subject,titletb.posttime,titletb.overtime,titletb.hits,titletb.posttype,titletb.kind from titletb,unitlid,disptb,newstb LEFT JOIN usertb on newstb.username=usertb.username where newstb.tid=titletb.tid and unitlid.lid=disptb.lid and titletb.tid=disptb.tid and newstb.username like '%' and titletb.subject like '%' and datediff(curdate(),date(posttime)) < '999' and disptb.lid like '111' and unitlid.lid like '%' and titletb.kind like '%' order by posttime desc;00
中華科技大學公告欄
