what kind of lake is lake of the hirsel considered?
(AND geography.lake_type (JOIN geography.lake_type.lakes_of_this_type m.07f_qd))