my Movie

Movie Details

SELECT MT.title, MT.prefix, M.movie_id FROM movies M, movie_titles MT WHERE MT.title_id = M.title_id AND MT.title_id <> AND MT.director = '' GROUP BY MT.title_id ORDER BY MT.title