最新消息

搜尋:  或關鍵字:  
select substr(a.Ann_CreateDate, 1, 10) createdate,a.Ann_SerialNo, a.Ann_Title,b.uname from `news` a, `unit` b where a.Ann_Unit=b.uno and (a.Ann_Unit='2200' or a.Ann_Unit='2210' or a.Ann_Unit='2260')and Ann_Unit <> '2270' ORDER BY Ann_CreateDate DESC LIMIT 0 , 6