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 R.rid=r.rid not M.title in
(SELECT movie.title
from mov' at line 3