John_Robie's Movies

Moviecount: 183
Wasted Time 15 days 7 hours 2 min
Average Rating 7,457923
Average Length 120,34min

Total Time Wasted 15 days 7 hours 2 min

Rating >= 8.5: 25
{ Rating = 9,1, Year = 1972, Title = The Godfather }
{ Rating = 9,0, Year = 2008, Title = The Dark Knight }
{ Rating = 8,9, Year = 1975, Title = One Flew Over the Cuckoo's Nest }
{ Rating = 8,9, Year = 1994, Title = Pulp Fiction }
{ Rating = 8,9, Year = 1993, Title = Schindler's List }
{ Rating = 8,8, Year = 1942, Title = Casablanca }
{ Rating = 8,8, Year = 1999, Title = Fight Club }
{ Rating = 8,8, Year = 1954, Title = Rear Window }
{ Rating = 8,7, Year = 2000, Title = Memento }
{ Rating = 8,7, Year = 1960, Title = Psycho }
{ Rating = 8,7, Year = 1999, Title = The Matrix }
{ Rating = 8,7, Year = 1995, Title = The Usual Suspects }
{ Rating = 8,6, Year = 1999, Title = American Beauty }
{ Rating = 8,6, Year = 1979, Title = Apocalypse Now }
{ Rating = 8,6, Year = 1994, Title = Léon }
{ Rating = 8,6, Year = 1959, Title = North by Northwest }
{ Rating = 8,6, Year = 1995, Title = Se7en }
{ Rating = 8,6, Year = 2008, Title = Slumdog Millionaire }
{ Rating = 8,6, Year = 1958, Title = Vertigo }
{ Rating = 8,6, Year = 2008, Title = WALL·E }
{ Rating = 8,5, Year = 2006, Title = Das Leben der Anderen }
{ Rating = 8,5, Year = 2000, Title = Requiem for a Dream }
{ Rating = 8,5, Year = 1998, Title = Saving Private Ryan }
{ Rating = 8,5, Year = 2006, Title = The Departed }
{ Rating = 8,5, Year = 2002, Title = The Pianist }


Moviecount each year
{ Year = 2007, Count = 23, Example = 3:10 to Yuma }
{ Year = 2008, Count = 23, Example = 21 }
{ Year = 2005, Count = 14, Example = Batman Begins }
{ Year = 2006, Count = 14, Example = 16 Blocks }
{ Year = 2004, Count = 13, Example = Collateral }
{ Year = 2002, Count = 12, Example = Austin Powers in Goldmember }
{ Year = 2003, Count = 10, Example = 11:14 }
{ Year = 1997, Count = 9, Example = As Good as It Gets }
{ Year = 2000, Count = 8, Example = Almost Famous }
{ Year = 1995, Count = 6, Example = Casino }
{ Year = 2001, Count = 6, Example = American Pie 2 }
{ Year = 1996, Count = 5, Example = Fargo }
{ Year = 1999, Count = 4, Example = American Beauty }
{ Year = 1993, Count = 3, Example = In the Line of Fire }
{ Year = 1994, Count = 3, Example = Léon }
{ Year = 1954, Count = 2, Example = Dial M for Murder }
{ Year = 1955, Count = 2, Example = The Trouble with Harry }
{ Year = 1972, Count = 2, Example = Frenzy }
{ Year = 1979, Count = 2, Example = Apocalypse Now }
{ Year = 1998, Count = 2, Example = Armageddon }
{ Year = 2009, Count = 2, Example = The International }
{ Year = 1940, Count = 1, Example = Rebecca }
{ Year = 1942, Count = 1, Example = Casablanca }
{ Year = 1944, Count = 1, Example = Lifeboat }
{ Year = 1951, Count = 1, Example = Strangers on a Train }
{ Year = 1958, Count = 1, Example = Vertigo }
{ Year = 1959, Count = 1, Example = North by Northwest }
{ Year = 1960, Count = 1, Example = Psycho }
{ Year = 1963, Count = 1, Example = The Birds }
{ Year = 1964, Count = 1, Example = Marnie }
{ Year = 1966, Count = 1, Example = Torn Curtain }
{ Year = 1969, Count = 1, Example = Topaz }
{ Year = 1971, Count = 1, Example = Dirty Harry }
{ Year = 1975, Count = 1, Example = One Flew Over the Cuckoo's Nest }
{ Year = 1976, Count = 1, Example = Family Plot }
{ Year = 1980, Count = 1, Example = Flash Gordon }
{ Year = 1983, Count = 1, Example = Scarface }
{ Year = 1987, Count = 1, Example = Wall Street }
{ Year = 1992, Count = 1, Example = Reservoir Dogs }

Actor with most movies
{ Movies = 8, Actor = Tom Cruise, Example = Collateral }
{ Movies = 6, Actor = Brad Pitt, Example = Burn After Reading }
{ Movies = 5, Actor = Bruce Willis, Example = 16 Blocks }
{ Movies = 5, Actor = Laurence Fishburne, Example = 21 }
{ Movies = 5, Actor = Morgan Freeman, Example = Batman Begins }
{ Movies = 5, Actor = Leonardo DiCaprio, Example = Blood Diamond }
{ Movies = 5, Actor = Tom Hanks, Example = Catch Me If You Can }
{ Movies = 5, Actor = Al Pacino, Example = Heat }
{ Movies = 5, Actor = Matt Damon, Example = Saving Private Ryan }
{ Movies = 4, Actor = Christian Bale, Example = 3:10 to Yuma }
{ Movies = 4, Actor = Philip Seymour Hoffman, Example = Almost Famous }
{ Movies = 4, Actor = Josh Brolin, Example = American Gangster }
{ Movies = 4, Actor = Martin Sheen, Example = Apocalypse Now }
{ Movies = 4, Actor = Michael Caine, Example = Austin Powers in Goldmember }
{ Movies = 4, Actor = Mark Wahlberg, Example = Boogie Nights }
{ Movies = 4, Actor = George Clooney, Example = Burn After Reading }
{ Movies = 4, Actor = Judi Dench, Example = Casino Royale }
{ Movies = 4, Actor = Michael Madsen, Example = Die Another Day }
{ Movies = 4, Actor = Michelle Monaghan, Example = Gone Baby Gone }
{ Movies = 4, Actor = Clive Owen, Example = Inside Man }

Movies with Tom Cruise
{ Year = 2004, Rating = 7,8, Title = Collateral }
{ Year = 2002, Rating = 7,7, Title = Minority Report }
{ Year = 2008, Rating = 7,3, Title = Tropic Thunder }
{ Year = 2006, Rating = 6,9, Title = Mission: Impossible III }
{ Year = 1996, Rating = 6,8, Title = Mission: Impossible }
{ Year = 1993, Rating = 6,6, Title = The Firm }
{ Year = 2005, Rating = 6,6, Title = War of the Worlds }
{ Year = 2000, Rating = 5,7, Title = Mission: Impossible II }

Top 10 directors
{ Movies = 16, Director = Alfred Hitchcock, Example = Dial M for Murder }
{ Movies = 7, Director = Steven Spielberg, Example = Catch Me If You Can }
{ Movies = 6, Director = David Fincher, Example = Fight Club }
{ Movies = 4, Director = Christopher Nolan, Example = Batman Begins }
{ Movies = 4, Director = Quentin Tarantino, Example = Kill Bill: Vol. 1 }
{ Movies = 3, Director = Ridley Scott, Example = American Gangster }
{ Movies = 3, Director = Joel Coen, Example = Burn After Reading }
{ Movies = 3, Director = Wes Craven, Example = Scream }
{ Movies = 3, Director = Andy Wachowski, Example = The Matrix }
{ Movies = 3, Director = Larry Wachowski, Example = The Matrix }

Movies directed by Alfred Hitchcock
{ Year = 1954, Rating = 8,8, Title = Rear Window }
{ Year = 1960, Rating = 8,7, Title = Psycho }
{ Year = 1959, Rating = 8,6, Title = North by Northwest }
{ Year = 1958, Rating = 8,6, Title = Vertigo }
{ Year = 1940, Rating = 8,4, Title = Rebecca }
{ Year = 1951, Rating = 8,3, Title = Strangers on a Train }
{ Year = 1954, Rating = 8,1, Title = Dial M for Murder }
{ Year = 1944, Rating = 7,9, Title = Lifeboat }
{ Year = 1963, Rating = 7,9, Title = The Birds }
{ Year = 1972, Rating = 7,5, Title = Frenzy }
{ Year = 1955, Rating = 7,5, Title = To Catch a Thief }
{ Year = 1964, Rating = 7,3, Title = Marnie }
{ Year = 1955, Rating = 7,2, Title = The Trouble with Harry }
{ Year = 1976, Rating = 6,7, Title = Family Plot }
{ Year = 1966, Rating = 6,6, Title = Torn Curtain }
{ Year = 1969, Rating = 6,2, Title = Topaz }

Top 5 Genres
{ Count = 113, Genre = Thriller, Example = 11:14 }
{ Count = 86, Genre = Drama, Example = 11:14 }
{ Count = 68, Genre = Crime, Example = 11:14 }
{ Count = 60, Genre = Action, Example = 16 Blocks }
{ Count = 43, Genre = Comedy, Example = 11:14 }

Runtime >= 2.5h: 24
{ Length = 195 min, Title = Schindler's List }
{ Length = 194 min, Title = Titanic }
{ Length = 191 min, Title = Grindhouse }
{ Length = 187 min, Title = King Kong }
{ Length = 178 min, Title = Casino }
{ Length = 175 min, Title = The Godfather }
{ Length = 171 min, Title = Heat }
{ Length = 170 min, Title = Saving Private Ryan }
{ Length = 170 min, Title = Scarface }
{ Length = 166 min, Title = The Curious Case of Benjamin Button }
{ Length = 162 min, Title = Watchmen }
{ Length = 158 min, Title = There Will Be Blood }
{ Length = 157 min, Title = American Gangster }
{ Length = 157 min, Title = Zodiac }
{ Length = 156 min, Title = Der Untergang }
{ Length = 155 min, Title = Boogie Nights }
{ Length = 155 min, Title = Gladiator }
{ Length = 154 min, Title = Pulp Fiction }
{ Length = 154 min, Title = The Firm }
{ Length = 153 min, Title = Apocalypse Now }
{ Length = 152 min, Title = The Dark Knight }
{ Length = 151 min, Title = The Departed }
{ Length = 150 min, Title = Armageddon }
{ Length = 150 min, Title = The Pianist }

Non USA movies: 13
{ Countries = France, Title = Léon }
{ Countries = France, Austria, Germany, Italy, Title = Caché }
{ Countries = France, Germany, UK, Poland, Title = The Pianist }
{ Countries = Germany, Title = Das Leben der Anderen }
{ Countries = Germany, Italy, Austria, Title = Der Untergang }
{ Countries = Italy, Title = La vita è bella }
{ Countries = SouthKorea, Title = Oldboy }
{ Countries = UK, Title = Frenzy }
{ Countries = UK, Title = Life of Brian }
{ Countries = UK, Title = Slumdog Millionaire }
{ Countries = UK, Title = The Bank Job }
{ Countries = UK, France, Italy, Title = The Queen }
{ Countries = UK, Spain, Title = Sexy Beast }

Top 10 countries
{ Count = 170, Country = USA, Example = 11:14 }
{ Count = 28, Country = Germany, Example = 16 Blocks }
{ Count = 22, Country = UK, Example = Burn After Reading }
{ Count = 9, Country = France, Example = Burn After Reading }
{ Count = 8, Country = Australia, Example = Gran Torino }
{ Count = 5, Country = Canada, Example = 11:14 }
{ Count = 4, Country = Italy, Example = Caché }
{ Count = 2, Country = Austria, Example = Caché }
{ Count = 2, Country = CzechRepublic, Example = Casino Royale }
{ Count = 2, Country = Spain, Example = Perfume: The Story of a Murderer }

Top 10 languages
{ Count = 179, Language = English, Example = 11:14 }
{ Count = 30, Language = French, Example = Apocalypse Now }
{ Count = 26, Language = German, Example = Austin Powers in Goldmember }
{ Count = 21, Language = Spanish, Example = Collateral }
{ Count = 13, Language = Italian, Example = Die Another Day }
{ Count = 12, Language = Russian, Example = Armageddon }
{ Count = 9, Language = Mandarin, Example = Batman Begins }
{ Count = 7, Language = Cantonese, Example = Die Another Day }
{ Count = 4, Language = Japanese, Example = Austin Powers in Goldmember }
{ Count = 4, Language = Latin, Example = Face/Off }

Top Movie of each year: 39
{ Year = 1940, Best = { Rating = 8,4, Title = Rebecca } }
{ Year = 1942, Best = { Rating = 8,8, Title = Casablanca } }
{ Year = 1944, Best = { Rating = 7,9, Title = Lifeboat } }
{ Year = 1951, Best = { Rating = 8,3, Title = Strangers on a Train } }
{ Year = 1954, Best = { Rating = 8,8, Title = Rear Window } }
{ Year = 1955, Best = { Rating = 7,5, Title = To Catch a Thief } }
{ Year = 1958, Best = { Rating = 8,6, Title = Vertigo } }
{ Year = 1959, Best = { Rating = 8,6, Title = North by Northwest } }
{ Year = 1960, Best = { Rating = 8,7, Title = Psycho } }
{ Year = 1963, Best = { Rating = 7,9, Title = The Birds } }
{ Year = 1964, Best = { Rating = 7,3, Title = Marnie } }
{ Year = 1966, Best = { Rating = 6,6, Title = Torn Curtain } }
{ Year = 1969, Best = { Rating = 6,2, Title = Topaz } }
{ Year = 1971, Best = { Rating = 7,9, Title = Dirty Harry } }
{ Year = 1972, Best = { Rating = 9,1, Title = The Godfather } }
{ Year = 1975, Best = { Rating = 8,9, Title = One Flew Over the Cuckoo's Nest } }
{ Year = 1976, Best = { Rating = 6,7, Title = Family Plot } }
{ Year = 1979, Best = { Rating = 8,6, Title = Apocalypse Now } }
{ Year = 1980, Best = { Rating = 6,2, Title = Flash Gordon } }
{ Year = 1983, Best = { Rating = 8,2, Title = Scarface } }
{ Year = 1987, Best = { Rating = 7,3, Title = Wall Street } }
{ Year = 1992, Best = { Rating = 8,4, Title = Reservoir Dogs } }
{ Year = 1993, Best = { Rating = 8,9, Title = Schindler's List } }
{ Year = 1994, Best = { Rating = 8,9, Title = Pulp Fiction } }
{ Year = 1995, Best = { Rating = 8,7, Title = The Usual Suspects } }
{ Year = 1996, Best = { Rating = 8,3, Title = Fargo } }
{ Year = 1997, Best = { Rating = 8,4, Title = La vita è bella } }
{ Year = 1998, Best = { Rating = 8,5, Title = Saving Private Ryan } }
{ Year = 1999, Best = { Rating = 8,8, Title = Fight Club } }
{ Year = 2000, Best = { Rating = 8,7, Title = Memento } }
{ Year = 2001, Best = { Rating = 8,0, Title = Shrek } }
{ Year = 2002, Best = { Rating = 8,5, Title = The Pianist } }
{ Year = 2003, Best = { Rating = 8,3, Title = Oldboy } }
{ Year = 2004, Best = { Rating = 8,4, Title = Der Untergang } }
{ Year = 2005, Best = { Rating = 8,4, Title = Batman Begins } }
{ Year = 2006, Best = { Rating = 8,5, Title = Das Leben der Anderen } }
{ Year = 2007, Best = { Rating = 8,3, Title = No Country for Old Men } }
{ Year = 2008, Best = { Rating = 9,0, Title = The Dark Knight } }
{ Year = 2009, Best = { Rating = 8,1, Title = Watchmen } }

SELECT Rating, Title FROM movies WHERE country = 'de' AND genre = 'comedy' ORDER
BY rating DESC
{ Rating = 7,3, Title = Bad Santa }
{ Rating = 7,3, Title = Death at a Funeral }
{ Rating = 7,3, Title = Tropic Thunder }
{ Rating = 7,0, Title = The Matador }
{ Rating = 6,2, Title = American Wedding }