A Database Error Occurred

Error Number: 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 ') order by rand() limit 4' at line 1

select d.id,d.image_url,d.name,d.title,d.spc from doctors d,hos_doc hd where hd.did=d.id and hd.hid in () order by rand() limit 4

Filename: D:\guanwang\uyixing_ci\src\system\database\DB_driver.php

Line Number: 330