'Selesai'
AND s.status_mentor IS NOT NULL
AND s.satuan_kerja_id='$satuan_kerja_id'
AND (SELECT COUNT(DISTINCT(COALESCE(s1.no_nd,'-'))) FROM riwayat_peserta s1 WHERE s1.riwayat_kegiatan_id=p.id AND s1.sebagai_id NOT IN ('1','3','5','6')
AND COALESCE(s1.no_nd,'-')='-')=0
ORDER BY p.jatuh_tempo_reg ASC
");
while($r=pg_fetch_array($data)) {
?>