教师管理

SELECT wbnews.wbnewsid,wbtitle,wbdate,wbinfosize,wbauthor,wbshowtimes,wbnews.wbtreeid,wbnews.wblinkurl,wbauditing,wbweight,wbtitlestyle,wbtop,wbindexed,wbpuborg,wbpubtype,wbpubmod,wbnews.wborderfield,wbcategorycode,wbtcatcode,wbccatcode,wbmddate,wbefectdate,wbsubterm,wbexposestate,wbcontent,wbdocnum,wbenddate,wbformat,wbpubprocess,wbabolidate,wbabolibasis FROM wbnews, wbgovpubnewsex WHERE wbnews.owner=wbgovpubnewsex.owner and wbnews.wbnewsid=wbgovpubnewsex.wbnewsid and wbnews.wbcontentid in(234961,234962,234963,234964,234965,234966,234967,234968) and wbauditing=1 and wbexposestate=1 and wbnews.owner=1640213988 and (wbdate< ="to_timestamp('2022-06-02" 18:17:53', 'YYYY-MM-DD HH24:MI:SS') and ( wbenddate is null or wbenddate>=to_timestamp('2022-06-02 18:17:53', 'YYYY-MM-DD HH24:MI:SS'))) ORDER BY wbtop desc,wborderfield desc,wbnews.wbnewsid desc