select distinct shop.id as id from shop join beauty_department on beauty_department.shop_id = shop.id where beauty_department.department_id in () and shop.shop_type = '3' and shop.delflg = '0' and shop.disp_flg = '1' and shop.site_type = '4' [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 shop.shop_type = '3' and shop.delflg = '0' and shop.disp_flg = '1' and sho' at line 1]DB Error: syntax error