如何将以下sql转换为QueryDSL形式？

问：

如何将以下sql转换为QueryDSL形式？

SELECT user.name,la.library_id,l.library_name,lr.coun
FROM library_admin la
LEFT JOIN user on la.user_id = user.id
left join library l on la.library_id = l.id 
left join (SELECT lend_admin_id ,COUNT(lend_admin_id) coun FROM lend_record
         GROUP BY apply_status, lend_admin_id
         HAVING apply_status = 'APPROVED') lr
        on lr.lend_admin_id = la.user_id

order by la.library_id;