film_actor

41 rows where actor_id = 102

✎ 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
102,20 102 102 AMELIE HELLFIGHTERS 20 2020-12-23 07:14:21
102,34 102 102 ARABIA DOGMA 34 2020-12-23 07:14:21
102,53 102 102 BANG KWAI 53 2020-12-23 07:14:21
102,123 102 102 CASABLANCA SUPER 123 2020-12-23 07:14:21
102,124 102 102 CASPER DRAGONFLY 124 2020-12-23 07:14:21
102,194 102 102 CROW GREASE 194 2020-12-23 07:14:21
102,200 102 102 CURTAIN VIDEOTAPE 200 2020-12-23 07:14:21
102,205 102 102 DANCES NONE 205 2020-12-23 07:14:21
102,268 102 102 EARLY HOME 268 2020-12-23 07:14:21
102,326 102 102 FLYING HOOK 326 2020-12-23 07:14:21
102,329 102 102 FORREST SONS 329 2020-12-23 07:14:21
102,334 102 102 FREDDY STORM 334 2020-12-23 07:14:21
102,351 102 102 GASLIGHT CRUSADE 351 2020-12-23 07:14:21
102,418 102 102 HOBBIT ALIEN 418 2020-12-23 07:14:21
102,431 102 102 HOOSIERS BIRDCAGE 431 2020-12-23 07:14:21
102,446 102 102 HYSTERICAL GRAIL 446 2020-12-23 07:14:21
102,485 102 102 JERSEY SASSY 485 2020-12-23 07:14:21
102,508 102 102 LAMBS CINCINATTI 508 2020-12-23 07:14:21
102,517 102 102 LESSON CLEOPATRA 517 2020-12-23 07:14:21
102,521 102 102 LIES TREATMENT 521 2020-12-23 07:14:21
102,526 102 102 LOCK REAR 526 2020-12-23 07:14:21
102,529 102 102 LONELY ELEPHANT 529 2020-12-23 07:14:21
102,544 102 102 MADISON TRAP 544 2020-12-23 07:14:21
102,600 102 102 MOTIONS DETAILS 600 2020-12-23 07:14:21
102,605 102 102 MULHOLLAND BEAST 605 2020-12-23 07:14:21
102,606 102 102 MUMMY CREATURES 606 2020-12-23 07:14:21
102,624 102 102 NIGHTMARE CHILL 624 2020-12-23 07:14:21
102,631 102 102 NOVOCAINE FLIGHT 631 2020-12-23 07:14:21
102,712 102 102 RAIDERS ANTITRUST 712 2020-12-23 07:14:21
102,728 102 102 REUNION WITCHES 728 2020-12-23 07:14:21
102,744 102 102 ROOTS REMEMBER 744 2020-12-23 07:14:21
102,796 102 102 SIERRA DIVIDE 796 2020-12-23 07:14:21
102,802 102 102 SKY MIRACLE 802 2020-12-23 07:14:21
102,810 102 102 SLUMS DUCK 810 2020-12-23 07:14:21
102,828 102 102 SPIKING ELEMENT 828 2020-12-23 07:14:21
102,837 102 102 STAGE WORLD 837 2020-12-23 07:14:21
102,845 102 102 STEPMOM DREAM 845 2020-12-23 07:14:22
102,852 102 102 STRANGELOVE DESIRE 852 2020-12-23 07:14:22
102,958 102 102 WARDROBE PHANTOM 958 2020-12-23 07:14:22
102,979 102 102 WITCHES PANIC 979 2020-12-23 07:14:22
102,980 102 102 WIZARD COLDBLOODED 980 2020-12-23 07:14:22

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