film_list (view)

5,462 rows

✎ View and edit SQL

This data as json, xlsx, CSV (advanced)

Suggested facets: category, price, rating

FID title description category price length rating actors
19 AMADEUS HOLY A Emotional Display of a Pioneer And a Technical Writer who must Battle a Man in A Baloon Action 0.99 113 PG JOHNNY LOLLOBRIGIDA
19 AMADEUS HOLY A Emotional Display of a Pioneer And a Technical Writer who must Battle a Man in A Baloon Action 0.99 113 PG JULIA MCQUEEN
19 AMADEUS HOLY A Emotional Display of a Pioneer And a Technical Writer who must Battle a Man in A Baloon Action 0.99 113 PG VAL BOLGER
19 AMADEUS HOLY A Emotional Display of a Pioneer And a Technical Writer who must Battle a Man in A Baloon Action 0.99 113 PG KIRK JOVOVICH
19 AMADEUS HOLY A Emotional Display of a Pioneer And a Technical Writer who must Battle a Man in A Baloon Action 0.99 113 PG JAMES PITT
19 AMADEUS HOLY A Emotional Display of a Pioneer And a Technical Writer who must Battle a Man in A Baloon Action 0.99 113 PG PENELOPE CRONYN
21 AMERICAN CIRCUS A Insightful Drama of a Girl And a Astronaut who must Face a Database Administrator in A Shark Tank Action 4.99 129 R KEVIN BLOOM
21 AMERICAN CIRCUS A Insightful Drama of a Girl And a Astronaut who must Face a Database Administrator in A Shark Tank Action 4.99 129 R RIP CRAWFORD
21 AMERICAN CIRCUS A Insightful Drama of a Girl And a Astronaut who must Face a Database Administrator in A Shark Tank Action 4.99 129 R SIDNEY CROWE
21 AMERICAN CIRCUS A Insightful Drama of a Girl And a Astronaut who must Face a Database Administrator in A Shark Tank Action 4.99 129 R WARREN JACKMAN
21 AMERICAN CIRCUS A Insightful Drama of a Girl And a Astronaut who must Face a Database Administrator in A Shark Tank Action 4.99 129 R FRANCES TOMEI
29 ANTITRUST TOMATOES A Fateful Yarn of a Womanizer And a Feminist who must Succumb a Database Administrator in Ancient India Action 2.99 168 NC-17 BETTE NICHOLSON
29 ANTITRUST TOMATOES A Fateful Yarn of a Womanizer And a Feminist who must Succumb a Database Administrator in Ancient India Action 2.99 168 NC-17 UMA WOOD
29 ANTITRUST TOMATOES A Fateful Yarn of a Womanizer And a Feminist who must Succumb a Database Administrator in Ancient India Action 2.99 168 NC-17 SIDNEY CROWE
29 ANTITRUST TOMATOES A Fateful Yarn of a Womanizer And a Feminist who must Succumb a Database Administrator in Ancient India Action 2.99 168 NC-17 SALMA NOLTE
29 ANTITRUST TOMATOES A Fateful Yarn of a Womanizer And a Feminist who must Succumb a Database Administrator in Ancient India Action 2.99 168 NC-17 WILLIAM HACKMAN
29 ANTITRUST TOMATOES A Fateful Yarn of a Womanizer And a Feminist who must Succumb a Database Administrator in Ancient India Action 2.99 168 NC-17 RENEE BALL
29 ANTITRUST TOMATOES A Fateful Yarn of a Womanizer And a Feminist who must Succumb a Database Administrator in Ancient India Action 2.99 168 NC-17 REESE WEST
38 ARK RIDGEMONT A Beautiful Yarn of a Pioneer And a Monkey who must Pursue a Explorer in The Sahara Desert Action 0.99 68 NC-17 PARKER GOLDBERG
38 ARK RIDGEMONT A Beautiful Yarn of a Pioneer And a Monkey who must Pursue a Explorer in The Sahara Desert Action 0.99 68 NC-17 NICK DEGENERES
38 ARK RIDGEMONT A Beautiful Yarn of a Pioneer And a Monkey who must Pursue a Explorer in The Sahara Desert Action 0.99 68 NC-17 AUDREY BAILEY
56 BAREFOOT MANCHURIAN A Intrepid Story of a Cat And a Student who must Vanquish a Girl in An Abandoned Amusement Park Action 2.99 129 G JENNIFER DAVIS
56 BAREFOOT MANCHURIAN A Intrepid Story of a Cat And a Student who must Vanquish a Girl in An Abandoned Amusement Park Action 2.99 129 G ELVIS MARX
56 BAREFOOT MANCHURIAN A Intrepid Story of a Cat And a Student who must Vanquish a Girl in An Abandoned Amusement Park Action 2.99 129 G MILLA PECK
56 BAREFOOT MANCHURIAN A Intrepid Story of a Cat And a Student who must Vanquish a Girl in An Abandoned Amusement Park Action 2.99 129 G KIRK JOVOVICH
56 BAREFOOT MANCHURIAN A Intrepid Story of a Cat And a Student who must Vanquish a Girl in An Abandoned Amusement Park Action 2.99 129 G DARYL CRAWFORD
56 BAREFOOT MANCHURIAN A Intrepid Story of a Cat And a Student who must Vanquish a Girl in An Abandoned Amusement Park Action 2.99 129 G ED MANSFIELD
56 BAREFOOT MANCHURIAN A Intrepid Story of a Cat And a Student who must Vanquish a Girl in An Abandoned Amusement Park Action 2.99 129 G MORGAN WILLIAMS
56 BAREFOOT MANCHURIAN A Intrepid Story of a Cat And a Student who must Vanquish a Girl in An Abandoned Amusement Park Action 2.99 129 G WILL WILSON
67 BERETS AGENT A Taut Saga of a Crocodile And a Boy who must Overcome a Technical Writer in Ancient China Action 2.99 77 PG-13 GRACE MOSTEL
67 BERETS AGENT A Taut Saga of a Crocodile And a Boy who must Overcome a Technical Writer in Ancient China Action 2.99 77 PG-13 JULIA BARRYMORE
67 BERETS AGENT A Taut Saga of a Crocodile And a Boy who must Overcome a Technical Writer in Ancient China Action 2.99 77 PG-13 JESSICA BAILEY
67 BERETS AGENT A Taut Saga of a Crocodile And a Boy who must Overcome a Technical Writer in Ancient China Action 2.99 77 PG-13 JULIANNE DENCH
67 BERETS AGENT A Taut Saga of a Crocodile And a Boy who must Overcome a Technical Writer in Ancient China Action 2.99 77 PG-13 CATE HARRIS
67 BERETS AGENT A Taut Saga of a Crocodile And a Boy who must Overcome a Technical Writer in Ancient China Action 2.99 77 PG-13 ANGELA WITHERSPOON
67 BERETS AGENT A Taut Saga of a Crocodile And a Boy who must Overcome a Technical Writer in Ancient China Action 2.99 77 PG-13 IAN TANDY
67 BERETS AGENT A Taut Saga of a Crocodile And a Boy who must Overcome a Technical Writer in Ancient China Action 2.99 77 PG-13 WILLIAM HACKMAN
67 BERETS AGENT A Taut Saga of a Crocodile And a Boy who must Overcome a Technical Writer in Ancient China Action 2.99 77 PG-13 MERYL ALLEN
67 BERETS AGENT A Taut Saga of a Crocodile And a Boy who must Overcome a Technical Writer in Ancient China Action 2.99 77 PG-13 JULIA FAWCETT
97 BRIDE INTRIGUE A Epic Tale of a Robot And a Monkey who must Vanquish a Man in New Orleans Action 0.99 56 G ANGELA HUDSON
105 BULL SHAWSHANK A Fanciful Drama of a Moose And a Squirrel who must Conquer a Pioneer in The Canadian Rockies Action 0.99 125 NC-17 NICK WAHLBERG
105 BULL SHAWSHANK A Fanciful Drama of a Moose And a Squirrel who must Conquer a Pioneer in The Canadian Rockies Action 0.99 125 NC-17 SANDRA KILMER
105 BULL SHAWSHANK A Fanciful Drama of a Moose And a Squirrel who must Conquer a Pioneer in The Canadian Rockies Action 0.99 125 NC-17 ALEC WAYNE
105 BULL SHAWSHANK A Fanciful Drama of a Moose And a Squirrel who must Conquer a Pioneer in The Canadian Rockies Action 0.99 125 NC-17 KIRK JOVOVICH
105 BULL SHAWSHANK A Fanciful Drama of a Moose And a Squirrel who must Conquer a Pioneer in The Canadian Rockies Action 0.99 125 NC-17 DAN STREEP
105 BULL SHAWSHANK A Fanciful Drama of a Moose And a Squirrel who must Conquer a Pioneer in The Canadian Rockies Action 0.99 125 NC-17 JULIANNE DENCH
105 BULL SHAWSHANK A Fanciful Drama of a Moose And a Squirrel who must Conquer a Pioneer in The Canadian Rockies Action 0.99 125 NC-17 ANGELA WITHERSPOON
105 BULL SHAWSHANK A Fanciful Drama of a Moose And a Squirrel who must Conquer a Pioneer in The Canadian Rockies Action 0.99 125 NC-17 JAYNE NOLTE
111 CADDYSHACK JEDI A Awe-Inspiring Epistle of a Woman And a Madman who must Fight a Robot in Soviet Georgia Action 0.99 52 NC-17 ED CHASE
111 CADDYSHACK JEDI A Awe-Inspiring Epistle of a Woman And a Madman who must Fight a Robot in Soviet Georgia Action 0.99 52 NC-17 ELVIS MARX

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

CREATE VIEW film_list
AS
SELECT film.film_id AS FID,
       film.title AS title,
       film.description AS description,
       category.name AS category,
       film.rental_rate AS price,
       film.length AS length,
       film.rating AS rating,
       actor.first_name||' '||actor.last_name AS actors
FROM category LEFT JOIN film_category ON category.category_id = film_category.category_id LEFT JOIN film ON film_category.film_id = film.film_id
        JOIN film_actor ON film.film_id = film_actor.film_id
    JOIN actor ON film_actor.actor_id = actor.actor_id;