SELECT bulletin.bull_id,bulletin.cate_id,bulletin.sort,bulletin.subject,bulletin.content,bulletin.station,bulletin.sdate,bulletin.chk,bulletin.hits,bulletin.txt1,bull_cate.cate_id,bull_cate.cate,bull_cate.sort,bull_cate.ord FROM bulletin INNER JOIN bull_cate ON bulletin.cate_id = bull_cate.cate_id where bull_cate.sort=5 and (year(sdate)='2012') AND sdate <= '2012-05-19' AND (edate > '2012-05-19' OR edate is null) order by bulletin.sdate desc,bull_cate.ord desc