行政監督與管理
SELECT giinfo.giinfoid,giinfo.giuuid,giinfo.gitop,giinfo.giauditstate,giinfo.gitcatcode,giinfo.giccatcode,giinfo.gipubcodes,giinfo.giscatcode,giinfo.gidocno,giinfo.gicategorycode,giinfo.gisubterm,giinfo.gititle,giinfo.giindentifier,giinfo.gidate,giinfo.giexposedate,giinfo.gipubcode FROM giinfo WHERE exists ( select gideptcatinfo.giuuid from gideptcatinfo where gideptcatinfo.giuuid=giinfo.giuuid and gideptcatinfo.giauditing=2 and ( (gideptcatinfo.gicatcode='xingzhengxuke' and gideptcatinfo.gideptcode='bs_wgj') or (gideptcatinfo.gicatcode='zxxx' and gideptcatinfo.gideptcode='bs_wgj') or (gideptcatinfo.gicatcode='xtbmfw' and gideptcatinfo.gideptcode='bs_wgj') or (gideptcatinfo.gicatcode='ZZ' and gideptcatinfo.gideptcode='bs_wgj') or (gideptcatinfo.gicatcode='YJ' and gideptcatinfo.gideptcode='bs_wgj') or (gideptcatinfo.gicatcode='CX' and gideptcatinfo.gideptcode='bs_wgj') or (gideptcatinfo.gicatcode='xzzfztxx' and gideptcatinfo.gideptcode='bs_wgj') or (gideptcatinfo.gicatcode='ZFRY' and gideptcatinfo.gideptcode='bs_wgj') or (gideptcatinfo.gicatcode='xingzhengchufa' and gideptcatinfo.gideptcode='bs_wgj') ) ) and giinfo.giexposestate<=1 and giinfo.gidate<=to_timestamp('2023-05-12 15:32:32', 'YYYY-MM-DD HH24:MI:SS') ORDER BY giinfo.gitop desc,giinfo.giorder asc,giinfo.gidate desc,giinfo.giinfoid desc
共131條  1/7 
首頁上頁  
影音先锋在线资源观看