Select Code to Download

movie:
    id       integer
...
person:
    id   integer
    name varchar

SELECT d_p.name AS director_name
      ,l_p.name AS lead_name
...
  JOIN person l_p ON (r.person = person.id)
 WHERE movie.name = ?
   AND r.type = 'lead'