Apakah ini menggunakan subquery? Mohon petunjuk query nya

Seperti ini lebih kurangnya:

pertanyaan.png

lampiran.png

select bimbingan.mhs_id as mhs_id, dsn.napan as napan, dsn.nabel as nabel, bimbingan.dosen_id as id_dosen, tipe.nama_bimbingan as jenis
FROM bimbingan
JOIN(select dosen.id, bimbingan.dosen_id, user.napan, user.nabel from user
JOIN dosen on dosen.user_id = user.id
JOIN bimbingan ON bimbingan.dosen_id = dosen.id) as dsn using(id)
LEFT JOIN tipe_bimbingan as tipe ON tipe.id = bimbingan.jenis_bimbingan_id
ORDER BY bimbingan.mhs_id ASC