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='bmys_1' and gideptcatinfo.gideptcode='bs_mzhenj') ) ) and giinfo.giexposestate<=1 and giinfo.gidate<=to_timestamp('2023-05-12 15:50:53', 'YYYY-MM-DD HH24:MI:SS') ORDER BY giinfo.gitop desc,giinfo.giorder asc,giinfo.gidate desc,giinfo.giinfoid desc
