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