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 ') AND i.is_active = 'Y' limit 0,1' at line 6

SELECT m.movie_id as premierMovieIds FROM `images` i, movie m WHERE upper( i.image_description ) LIKE CONCAT( '%', upper( movie_name ) , ' %' ) AND upper( i.image_description ) LIKE '%PREMIERE%' AND m.movie_id IN () AND i.is_active = 'Y' limit 0,1

[TEP STOP]