select
  d.KDPSTMSMHS as kode_prodi,
  d.SMAWLMSMHS,
  d.STMHSMSMHS as status,
  a.npm,
  d.NMMHSMSMHS as nama,
  a.kelas,
  a.sex as jk,
  a.nisn,
  a.ktp as nik,
  a.agama,
  a.no_kps,
  a.nama_ayah,
  a.nama_ibu,
  a.kewarganegaraan,
  a.alamat as jalan,
  a.rt,
  a.rw,
  a.penerima_kps,
  a.jenis_tinggal,
  a.kebutuhan_khusus_mhs,
  (
    select
      tk.name
    from
      tbl_kelurahans tk
    WHERE
      tk.id = a.kelurahan
  ) as desa,
  (
    SELECT
      tk.id_wil
    FROM
      tbl_kecamatans tk
    WHERE
      tk.id = a.kecamatan
  ) as kec,
  a.kota as kab,
  a.provinsi as prov,
  a.tpt_lahir,
  a.tgl_lahir,
  a.email,
  a.no_hp,
  b.no_ujian,
  a.npwp,
  a.kode_pos
from
  tbl_bio_mhs as a
  join tbl_register as b on a.npm = b.npm
  join tbl_mahasiswa as d on a.npm = d.NIMHSMSMHS
where
  substr(a.npm, 1, 4) = '2023'
  and d.KDPSTMSMHS = '61001'