医院视图和科室表联查：查询状态为0的科室信息（模糊查询+分页）

SELECT * FROM hospital_view hv JOIN department de ON hv.department_id = de.id WHERE de.status = 0 AND (de.name LIKE '%keyword%' OR de.description LIKE '%keyword%') LIMIT 10