film_actor

33 rows where actor_id = 27

✎ View and edit SQL

This data as json, xlsx, CSV (advanced)

Suggested facets: last_update, last_update (date)

Link actor_id film_id last_update
27,19 27 27 AMADEUS HOLY 19 2020-12-23 07:13:53
27,34 27 27 ARABIA DOGMA 34 2020-12-23 07:13:53
27,85 27 27 BONNIE HOLOCAUST 85 2020-12-23 07:13:53
27,150 27 27 CIDER DESIRE 150 2020-12-23 07:13:53
27,172 27 27 CONEHEADS SMOOCHY 172 2020-12-23 07:13:53
27,273 27 27 EFFECT GLADIATOR 273 2020-12-23 07:13:53
27,334 27 27 FREDDY STORM 334 2020-12-23 07:13:53
27,347 27 27 GAMES BOWFINGER 347 2020-12-23 07:13:53
27,359 27 27 GLADIATOR WESTWARD 359 2020-12-23 07:13:53
27,398 27 27 HANOVER GALAXY 398 2020-12-23 07:13:53
27,415 27 27 HIGH ENCINO 415 2020-12-23 07:13:53
27,462 27 27 INSIDER ARIZONA 462 2020-12-23 07:13:53
27,477 27 27 JAWBREAKER BROOKLYN 477 2020-12-23 07:13:53
27,500 27 27 KISS GLORY 500 2020-12-23 07:13:53
27,503 27 27 KRAMER CHOCOLATE 503 2020-12-23 07:13:53
27,540 27 27 LUCKY FLYING 540 2020-12-23 07:13:53
27,586 27 27 MOCKINGBIRD HOLLYWOOD 586 2020-12-23 07:13:53
27,593 27 27 MONTEREY LABYRINTH 593 2020-12-23 07:13:53
27,637 27 27 OPEN AFRICAN 637 2020-12-23 07:13:53
27,679 27 27 PILOT HOOSIERS 679 2020-12-23 07:13:53
27,682 27 27 PITTSBURGH HUNCHBACK 682 2020-12-23 07:13:53
27,695 27 27 PRESIDENT BANG 695 2020-12-23 07:13:53
27,771 27 27 SCORPION APOLLO 771 2020-12-23 07:13:53
27,805 27 27 SLEEPLESS MONSOON 805 2020-12-23 07:13:53
27,830 27 27 SPIRIT FLINTSTONES 830 2020-12-23 07:13:53
27,854 27 27 STRANGERS GRAFFITI 854 2020-12-23 07:13:54
27,873 27 27 SWEETHEARTS SUSPECTS 873 2020-12-23 07:13:54
27,880 27 27 TELEMARK HEARTBREAKERS 880 2020-12-23 07:13:54
27,889 27 27 TIES HUNGER 889 2020-12-23 07:13:54
27,904 27 27 TRAIN BUNCH 904 2020-12-23 07:13:54
27,967 27 27 WEEKEND PERSONAL 967 2020-12-23 07:13:54
27,986 27 27 WONKA SEA 986 2020-12-23 07:13:54
27,996 27 27 YOUNG LANGUAGE 996 2020-12-23 07:13:54

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) 
;