selectdistinctLEFT(api_list_mahasiswa.id_periode, 4) as periode_awal from `list_program_studi` leftjoin `api_list_mahasiswa` on `api_list_mahasiswa`.`id_prodi` = `list_program_studi`.`id_prodi` where `list_program_studi`.`id_prodi` ='5d5da936-e321-49d0-bf81-2a129ab7665f'