SELECT KKS_Final.*,KKS_Periode.periode FROM KKS_Final INNER JOIN KKS_Periode ON (KKS_Final.id_periode = KKS_Periode.id_periode)
WHERE masukkuota = 1 AND concat(KDPROP,KDKAB) IN
(SELECT a.kode_kab
FROM kabupaten_finalisasi_kks a
WHERE a.id_periode = 4) ORDER BY ID_Pengurus ASC;