MySQL Error: 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 '' at line 1 for query SELECT m.duration,mf.* FROM movie m LEFT JOIN movie_files mf USING(movie_id) WHERE mf.main_file=1 AND  m.movie_id = 

MySQL Error: 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 'LIMIT 1' at line 1 for query SELECT * FROM movie m LEFT JOIN movie_properties mp USING(movie_id) LEFT JOIN movie_files mf USING(movie_id) WHERE mf.main_file=1 AND m.movie_id= LIMIT 1 
error.