film_actor

20 rows where actor_id = 91

✎ View and edit SQL

This data as json, xlsx, CSV (advanced)

Suggested facets: last_update (date)

Link actor_id film_id last_update
91,13 91 91 ALI FOREVER 13 2020-12-23 07:14:17
91,25 91 91 ANGELS LIFE 25 2020-12-23 07:14:17
91,48 91 91 BACKLASH UNDEFEATED 48 2020-12-23 07:14:17
91,176 91 91 CONGENIALITY QUEST 176 2020-12-23 07:14:17
91,181 91 91 CONTACT ANONYMOUS 181 2020-12-23 07:14:17
91,190 91 91 CREEPERS KANE 190 2020-12-23 07:14:17
91,335 91 91 FREEDOM CLEOPATRA 335 2020-12-23 07:14:17
91,416 91 91 HIGHBALL POTTER 416 2020-12-23 07:14:17
91,447 91 91 ICE CROSSING 447 2020-12-23 07:14:17
91,480 91 91 JEEPERS WEDDING 480 2020-12-23 07:14:17
91,493 91 91 KANE EXORCIST 493 2020-12-23 07:14:17
91,509 91 91 LANGUAGE COWBOY 509 2020-12-23 07:14:17
91,511 91 91 LAWRENCE LOVE 511 2020-12-23 07:14:17
91,608 91 91 MURDER ANTITRUST 608 2020-12-23 07:14:17
91,807 91 91 SLEUTH ORIENT 807 2020-12-23 07:14:17
91,829 91 91 SPINAL ROCKY 829 2020-12-23 07:14:17
91,849 91 91 STORM HAPPINESS 849 2020-12-23 07:14:17
91,859 91 91 SUGAR WONKA 859 2020-12-23 07:14:17
91,941 91 91 VIDEOTAPE ARSENIC 941 2020-12-23 07:14:17
91,982 91 91 WOMEN DORADO 982 2020-12-23 07:14:17

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options: 

CREATE TABLE film_actor (
  actor_id INT NOT NULL,
  film_id  INT NOT NULL,
  last_update TIMESTAMP NOT NULL,
  PRIMARY KEY  (actor_id,film_id),
  CONSTRAINT fk_film_actor_actor FOREIGN KEY (actor_id) REFERENCES actor (actor_id) ON DELETE NO ACTION ON UPDATE CASCADE,
  CONSTRAINT fk_film_actor_film FOREIGN KEY (film_id) REFERENCES film (film_id) ON DELETE NO ACTION ON UPDATE CASCADE
);
CREATE INDEX idx_fk_film_actor_film ON film_actor(film_id)
;
CREATE INDEX idx_fk_film_actor_actor ON film_actor(actor_id) 
;