重点领域信息公开
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(245647,171664,171665,171666,171667,245627,245628,245629,171678,171679,171680,171681,171682,171683,171684,171685,171686,171687,171688,171689,171690,171692,171699,171713,171714,171715,171716,171717,171718,171719,171720,171721,171722,171723,171724,171725,171726,171727,171728,171729,171730,171731,171732,171733,171734,171735,234943,234944,234945,234946,234947,234948,234949,234950,234951,234952,234953,234954,234955,234956,234957,234958,234959,234960,234961,234962,234963,234964,234965,234966,234967,234968,234969,234970,234971,234974,234973,234972,234975,245487) and wbauditing=1 and wbexposestate=1 and wbnews.owner=1640213988 and (wbdate< ="to_timestamp('2023-09-22" 16:54:55', 'YYYY-MM-DD HH24:MI:SS') and ( wbenddate is null or wbenddate>=to_timestamp('2023-09-22 16:54:55', 'YYYY-MM-DD HH24:MI:SS'))) ORDER BY wbtop desc,wborderfield desc,wbnews.wbnewsid desc