SELECT * FROM UDART_11 WHERE len(isnull(NoArtPBI,0)) = 13 AND isnull(Sta_keberadaan_art,0) IN (0,1,4) AND IDBDT IN (SELECT IDBDT FROM UDRT_11 WHERE id_periode = 4 AND KET_BDTMEI18 = 'FINALISASI BDT PERIODE 4') UNION
SELECT * FROM UDART_12 WHERE len(isnull(NoArtPBI,0)) = 13 AND isnull(Sta_keberadaan_art,0) IN (0,1,4) AND IDBDT IN (SELECT IDBDT FROM UDRT_12 WHERE id_periode = 4 AND KET_BDTMEI18 = 'FINALISASI BDT PERIODE 4') UNION
SELECT * FROM UDART_13 WHERE len(isnull(NoArtPBI,0)) = 13 AND isnull(Sta_keberadaan_art,0) IN (0,1,4) AND IDBDT IN (SELECT IDBDT FROM UDRT_13 WHERE id_periode = 4 AND KET_BDTMEI18 = 'FINALISASI BDT PERIODE 4') UNION
SELECT * FROM UDART_14 WHERE len(isnull(NoArtPBI,0)) = 13 AND isnull(Sta_keberadaan_art,0) IN (0,1,4) AND IDBDT IN (SELECT IDBDT FROM UDRT_14 WHERE id_periode = 4 AND KET_BDTMEI18 = 'FINALISASI BDT PERIODE 4') UNION
SELECT * FROM UDART_15 WHERE len(isnull(NoArtPBI,0)) = 13 AND isnull(Sta_keberadaan_art,0) IN (0,1,4) AND IDBDT IN (SELECT IDBDT FROM UDRT_15 WHERE id_periode = 4 AND KET_BDTMEI18 = 'FINALISASI BDT PERIODE 4') UNION
SELECT * FROM UDART_16 WHERE len(isnull(NoArtPBI,0)) = 13 AND isnull(Sta_keberadaan_art,0) IN (0,1,4) AND IDBDT IN (SELECT IDBDT FROM UDRT_16 WHERE id_periode = 4 AND KET_BDTMEI18 = 'FINALISASI BDT PERIODE 4') UNION
SELECT * FROM UDART_17 WHERE len(isnull(NoArtPBI,0)) = 13 AND isnull(Sta_keberadaan_art,0) IN (0,1,4) AND IDBDT IN (SELECT IDBDT FROM UDRT_17 WHERE id_periode = 4 AND KET_BDTMEI18 = 'FINALISASI BDT PERIODE 4') UNION
SELECT * FROM UDART_18 WHERE len(isnull(NoArtPBI,0)) = 13 AND isnull(Sta_keberadaan_art,0) IN (0,1,4) AND IDBDT IN (SELECT IDBDT FROM UDRT_18 WHERE id_periode = 4 AND KET_BDTMEI18 = 'FINALISASI BDT PERIODE 4') UNION
SELECT * FROM UDART_19 WHERE len(isnull(NoArtPBI,0)) = 13 AND isnull(Sta_keberadaan_art,0) IN (0,1,4) AND IDBDT IN (SELECT IDBDT FROM UDRT_19 WHERE id_periode = 4 AND KET_BDTMEI18 = 'FINALISASI BDT PERIODE 4') UNION
SELECT * FROM UDART_21 WHERE len(isnull(NoArtPBI,0)) = 13 AND isnull(Sta_keberadaan_art,0) IN (0,1,4) AND IDBDT IN (SELECT IDBDT FROM UDRT_21 WHERE id_periode = 4 AND KET_BDTMEI18 = 'FINALISASI BDT PERIODE 4') UNION
SELECT * FROM UDART_31 WHERE len(isnull(NoArtPBI,0)) = 13 AND isnull(Sta_keberadaan_art,0) IN (0,1,4) AND IDBDT IN (SELECT IDBDT FROM UDRT_31 WHERE id_periode = 4 AND KET_BDTMEI18 = 'FINALISASI BDT PERIODE 4') UNION
SELECT * FROM UDART_32 WHERE len(isnull(NoArtPBI,0)) = 13 AND isnull(Sta_keberadaan_art,0) IN (0,1,4) AND IDBDT IN (SELECT IDBDT FROM UDRT_32 WHERE id_periode = 4 AND KET_BDTMEI18 = 'FINALISASI BDT PERIODE 4') UNION
SELECT * FROM UDART_33 WHERE len(isnull(NoArtPBI,0)) = 13 AND isnull(Sta_keberadaan_art,0) IN (0,1,4) AND IDBDT IN (SELECT IDBDT FROM UDRT_33 WHERE id_periode = 4 AND KET_BDTMEI18 = 'FINALISASI BDT PERIODE 4') UNION
SELECT * FROM UDART_34 WHERE len(isnull(NoArtPBI,0)) = 13 AND isnull(Sta_keberadaan_art,0) IN (0,1,4) AND IDBDT IN (SELECT IDBDT FROM UDRT_34 WHERE id_periode = 4 AND KET_BDTMEI18 = 'FINALISASI BDT PERIODE 4') UNION
SELECT * FROM UDART_35 WHERE len(isnull(NoArtPBI,0)) = 13 AND isnull(Sta_keberadaan_art,0) IN (0,1,4) AND IDBDT IN (SELECT IDBDT FROM UDRT_35 WHERE id_periode = 4 AND KET_BDTMEI18 = 'FINALISASI BDT PERIODE 4') UNION
SELECT * FROM UDART_36 WHERE len(isnull(NoArtPBI,0)) = 13 AND isnull(Sta_keberadaan_art,0) IN (0,1,4) AND IDBDT IN (SELECT IDBDT FROM UDRT_36 WHERE id_periode = 4 AND KET_BDTMEI18 = 'FINALISASI BDT PERIODE 4') UNION
SELECT * FROM UDART_51 WHERE len(isnull(NoArtPBI,0)) = 13 AND isnull(Sta_keberadaan_art,0) IN (0,1,4) AND IDBDT IN (SELECT IDBDT FROM UDRT_51 WHERE id_periode = 4 AND KET_BDTMEI18 = 'FINALISASI BDT PERIODE 4') UNION
SELECT * FROM UDART_52 WHERE len(isnull(NoArtPBI,0)) = 13 AND isnull(Sta_keberadaan_art,0) IN (0,1,4) AND IDBDT IN (SELECT IDBDT FROM UDRT_52 WHERE id_periode = 4 AND KET_BDTMEI18 = 'FINALISASI BDT PERIODE 4') UNION
SELECT * FROM UDART_53 WHERE len(isnull(NoArtPBI,0)) = 13 AND isnull(Sta_keberadaan_art,0) IN (0,1,4) AND IDBDT IN (SELECT IDBDT FROM UDRT_53 WHERE id_periode = 4 AND KET_BDTMEI18 = 'FINALISASI BDT PERIODE 4') UNION
SELECT * FROM UDART_61 WHERE len(isnull(NoArtPBI,0)) = 13 AND isnull(Sta_keberadaan_art,0) IN (0,1,4) AND IDBDT IN (SELECT IDBDT FROM UDRT_61 WHERE id_periode = 4 AND KET_BDTMEI18 = 'FINALISASI BDT PERIODE 4') UNION
SELECT * FROM UDART_62 WHERE len(isnull(NoArtPBI,0)) = 13 AND isnull(Sta_keberadaan_art,0) IN (0,1,4) AND IDBDT IN (SELECT IDBDT FROM UDRT_62 WHERE id_periode = 4 AND KET_BDTMEI18 = 'FINALISASI BDT PERIODE 4') UNION
SELECT * FROM UDART_63 WHERE len(isnull(NoArtPBI,0)) = 13 AND isnull(Sta_keberadaan_art,0) IN (0,1,4) AND IDBDT IN (SELECT IDBDT FROM UDRT_63 WHERE id_periode = 4 AND KET_BDTMEI18 = 'FINALISASI BDT PERIODE 4') UNION
SELECT * FROM UDART_64 WHERE len(isnull(NoArtPBI,0)) = 13 AND isnull(Sta_keberadaan_art,0) IN (0,1,4) AND IDBDT IN (SELECT IDBDT FROM UDRT_64 WHERE id_periode = 4 AND KET_BDTMEI18 = 'FINALISASI BDT PERIODE 4') UNION
SELECT * FROM UDART_65 WHERE len(isnull(NoArtPBI,0)) = 13 AND isnull(Sta_keberadaan_art,0) IN (0,1,4) AND IDBDT IN (SELECT IDBDT FROM UDRT_65 WHERE id_periode = 4 AND KET_BDTMEI18 = 'FINALISASI BDT PERIODE 4') UNION
SELECT * FROM UDART_71 WHERE len(isnull(NoArtPBI,0)) = 13 AND isnull(Sta_keberadaan_art,0) IN (0,1,4) AND IDBDT IN (SELECT IDBDT FROM UDRT_71 WHERE id_periode = 4 AND KET_BDTMEI18 = 'FINALISASI BDT PERIODE 4') UNION
SELECT * FROM UDART_72 WHERE len(isnull(NoArtPBI,0)) = 13 AND isnull(Sta_keberadaan_art,0) IN (0,1,4) AND IDBDT IN (SELECT IDBDT FROM UDRT_72 WHERE id_periode = 4 AND KET_BDTMEI18 = 'FINALISASI BDT PERIODE 4') UNION
SELECT * FROM UDART_73 WHERE len(isnull(NoArtPBI,0)) = 13 AND isnull(Sta_keberadaan_art,0) IN (0,1,4) AND IDBDT IN (SELECT IDBDT FROM UDRT_73 WHERE id_periode = 4 AND KET_BDTMEI18 = 'FINALISASI BDT PERIODE 4') UNION
SELECT * FROM UDART_74 WHERE len(isnull(NoArtPBI,0)) = 13 AND isnull(Sta_keberadaan_art,0) IN (0,1,4) AND IDBDT IN (SELECT IDBDT FROM UDRT_74 WHERE id_periode = 4 AND KET_BDTMEI18 = 'FINALISASI BDT PERIODE 4') UNION
SELECT * FROM UDART_75 WHERE len(isnull(NoArtPBI,0)) = 13 AND isnull(Sta_keberadaan_art,0) IN (0,1,4) AND IDBDT IN (SELECT IDBDT FROM UDRT_75 WHERE id_periode = 4 AND KET_BDTMEI18 = 'FINALISASI BDT PERIODE 4') UNION
SELECT * FROM UDART_76 WHERE len(isnull(NoArtPBI,0)) = 13 AND isnull(Sta_keberadaan_art,0) IN (0,1,4) AND IDBDT IN (SELECT IDBDT FROM UDRT_76 WHERE id_periode = 4 AND KET_BDTMEI18 = 'FINALISASI BDT PERIODE 4') UNION
SELECT * FROM UDART_81 WHERE len(isnull(NoArtPBI,0)) = 13 AND isnull(Sta_keberadaan_art,0) IN (0,1,4) AND IDBDT IN (SELECT IDBDT FROM UDRT_81 WHERE id_periode = 4 AND KET_BDTMEI18 = 'FINALISASI BDT PERIODE 4') UNION
SELECT * FROM UDART_82 WHERE len(isnull(NoArtPBI,0)) = 13 AND isnull(Sta_keberadaan_art,0) IN (0,1,4) AND IDBDT IN (SELECT IDBDT FROM UDRT_82 WHERE id_periode = 4 AND KET_BDTMEI18 = 'FINALISASI BDT PERIODE 4') UNION
SELECT * FROM UDART_91 WHERE len(isnull(NoArtPBI,0)) = 13 AND isnull(Sta_keberadaan_art,0) IN (0,1,4) AND IDBDT IN (SELECT IDBDT FROM UDRT_91 WHERE id_periode = 4 AND KET_BDTMEI18 = 'FINALISASI BDT PERIODE 4') UNION
SELECT * FROM UDART_94 WHERE len(isnull(NoArtPBI,0)) = 13 AND isnull(Sta_keberadaan_art,0) IN (0,1,4) AND IDBDT IN (SELECT IDBDT FROM UDRT_94 WHERE id_periode = 4 AND KET_BDTMEI18 = 'FINALISASI BDT PERIODE 4') ORDER BY KDPROP,KDKAB,KDKEC,KDDESA, IDBDT,IDARTBDT;