select giinfo.giinfoid,giinfo.gidate,giinfo.giuuid,giinfo.giorder,giinfo.gitop,giinfo.giscatcode,giinfo.giccatcode,giinfo.gipubcodes,giinfo.gidocno,giinfo.gimddate, giinfo.gitcatcode,giinfo.gicategorycode,giinfo.gisubterm,giinfo.gititle,giinfo.giindentifier,giinfo.gipubcode from giinfo where exists ( select gideptcatinfo.giuuid from gideptcatinfo where gideptcatinfo.giuuid=giinfo.giuuid and gideptcatinfo.giauditing=2 and gicategorycode in ('02_','02_A','02_B','02_C','02_D','02_E','02_F','02_G','02_H','02_Z')) and giexposestate<=1 and giauditstate=2 and giinfo.gipubcode in('szfbgt','btszf') order by giinfo.gitop desc, giinfo.giorder asc, giinfo.gidate desc,giinfo.giinfoid desc