An Error Was Encountered

Error Number: 1064

You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ') ORDER BY roomfacilities.position desc' at line 5

SELECT roomfacilities_lg.description as description FROM roomfacilities JOIN roomfacilities_lg ON roomfacilities.id = roomfacilities_lg.id_roomfacilities WHERE roomfacilities_lg.code = 'ro' AND roomfacilities.id IN () ORDER BY roomfacilities.position desc