home / imdb

Longest Movies (3+ hours)

Custom SQL query returning 50 rows (hide)

                        SELECT
                            primaryTitle as title,
                            startYear as year,
                            runtimeMinutes as runtime,
                            genres
                        FROM titles
                        WHERE titleType = 'movie'
                        AND runtimeMinutes IS NOT NULL
                        AND runtimeMinutes > 180
                        ORDER BY runtimeMinutes DESC
                        LIMIT 50
                    

Edit SQL

This data as json, CSV

titleyearruntimegenres
His Last Stand   990 Crime
Captive Souls 1914 99  
Saints and Sorrows 1914 99 Drama
Algol: Tragedy of Power 1920 99 Fantasy,Sci-Fi
Tol'able David 1921 99 Drama
Nora 1923 99 Drama
När millionerna rullar... 1924 99 Adventure,Drama
Manon Lescaut 1926 99 Drama
The Beloved Rogue 1927 99 Adventure,Drama,History
Den glade enke i Trangvik 1927 99 Drama
Madame Visits Oslo 1927 99 Adventure,Crime,Drama
My Man 1928 99 Drama
Whirl of Youth 1928 99 Drama
The Divine Lady 1928 99 Drama,History,Romance
Three from the Filling Station 1930 99 Comedy,Musical,Romance
King of Jazz 1930 99 Animation,Comedy,Musical
Ladies of Leisure 1930 99 Drama,Romance
Mystery at the Villa Rose 1930 99 Crime,Mystery
M 1931 99 Crime,Mystery,Thriller
Skyscraper Souls 1932 99 Drama,Romance
Spoiling the Game 1932 99 Comedy
Queen Christina 1933 99 Biography,Drama,History
State Fair 1933 99 Comedy,Drama,Romance
De Jantjes 1934 99 Comedy,Drama,Musical
Krach um Jolanthe 1934 99 Comedy,Romance
Decoy 1934 99  
The Merry Widow 1934 99 Comedy,Musical,Romance
The Legend of William Tell 1934 99 Drama,History
Alice Adams 1935 99 Comedy,Drama,Romance
Broadway Gondolier 1935 99 Comedy,Musical,Romance
Cette vieille canaille 1933 99 Drama
Youth of Today 1935 99 Comedy
Come and Get It 1936 99 Drama,Romance
Meseautó 1934 99 Comedy,Romance
Panserbasse 1936 99 Comedy,Crime,Family
Savoy-Hotel 217 1936 99 Drama
His Best Friend 1937 99 Crime
Poor Millionaires 1936 99 Comedy
Wenn wir alle Engel wären 1936 99 Comedy,Romance
Mille, Marie og mig 1937 99 Comedy,Family,Romance
Anna Favetti 1938 99 Romance
The Curtain Rises 1938 99 Comedy,Crime,Drama
Rykmentin murheenkryyni 1938 99 Comedy
The Sisters 1938 99 Drama
Freed Hands 1939 99  
Bors István 1939 99 Comedy,Drama
La fin du jour 1939 99 Drama
Gjest Baardsen 1939 99 Biography,Comedy,Crime
Golden Boy 1939 99 Drama,Romance,Sport
The Governor 1939 99 Drama
Powered by Datasette · Queries took 1852.175ms