The Führer in IMDB

Following-up to the story of having all the movies I’ve watched in a PostgreSQL database, I now have a tendency to run the following query after wathing one, to take a look at what other movies I’ve watched in which some of the actors also participated:

  movies=> SELECT s.name, s.title
             FROM seen_cast s JOIN seen_cast s2 USING (person_id)
             WHERE s.movie_id != s2.movie_id AND s2.title = 'Sideways' 
             ORDER BY name ASC;

(Replacing Sideways with the movie I just watched, of course. Also, “seen_cast” is a view, that’s why it looks as if the database is not normalized.)

So, apart from informing me that I have seen Paul Giamatti in other five films in addition to Sideways, the above query returned the following rows:

       name     |       title        
  --------------+--------------------
   Adolf Hitler | Germania anno zero
   Adolf Hitler | The Good Shepherd

Apparently, Adolf Hitler has a page in IMDB, and is credited (generally by IMDB only, not by the film credits themselves) in every film that shows any archive footage of him. Which, as of today, are more than 400.