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_lg.id_roomfacilities WHERE roomfacilities_lg.code = 'ro' AND IN () ORDER BY roomfacilities.position desc