select distinct hospital.id as id from hospital join hospital_department on hospital_department.hospital_id = hospital.id where hospital_department.department_id in () and hospital.shop_type = '1' and hospital.delflg = '0' and hospital.disp_flg = '1' and hospital.site_type = '2' [nativecode=1064 ** You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') and hospital.shop_type = '1' and hospital.delflg = '0' and hospital.disp_flg =' at line 1]DB Error: syntax error