film_actor

28 rows where actor_id = 39

✎ View and edit SQL

This data as json, xlsx, CSV (advanced)

Suggested facets: last_update (date)

Link actor_id film_id last_update
39,71 39 39 BILKO ANONYMOUS 71 2020-12-23 07:13:58
39,73 39 39 BINGO TALENTED 73 2020-12-23 07:13:58
39,168 39 39 COMANCHEROS ENEMY 168 2020-12-23 07:13:58
39,203 39 39 DAISY MENAGERIE 203 2020-12-23 07:13:58
39,222 39 39 DESERT POSEIDON 222 2020-12-23 07:13:58
39,290 39 39 EVERYONE CRAFT 290 2020-12-23 07:13:58
39,293 39 39 EXORCIST STING 293 2020-12-23 07:13:58
39,320 39 39 FLAMINGOS CONNECTICUT 320 2020-12-23 07:13:58
39,415 39 39 HIGH ENCINO 415 2020-12-23 07:13:58
39,425 39 39 HOLY TADPOLE 425 2020-12-23 07:13:58
39,431 39 39 HOOSIERS BIRDCAGE 431 2020-12-23 07:13:58
39,456 39 39 INCH JET 456 2020-12-23 07:13:58
39,476 39 39 JASON TRAP 476 2020-12-23 07:13:58
39,559 39 39 MARRIED GO 559 2020-12-23 07:13:58
39,587 39 39 MOD SECRETARY 587 2020-12-23 07:13:58
39,598 39 39 MOSQUITO ARMAGEDDON 598 2020-12-23 07:13:58
39,606 39 39 MUMMY CREATURES 606 2020-12-23 07:13:58
39,648 39 39 OUTLAW HANKY 648 2020-12-23 07:13:58
39,683 39 39 PITY BOUND 683 2020-12-23 07:13:58
39,689 39 39 POLLOCK DELIVERANCE 689 2020-12-23 07:13:58
39,696 39 39 PRIDE ALAMO 696 2020-12-23 07:13:58
39,700 39 39 PRIX UNDEFEATED 700 2020-12-23 07:13:58
39,703 39 39 PUNK DIVORCE 703 2020-12-23 07:13:58
39,736 39 39 ROBBERY BRIGHT 736 2020-12-23 07:13:58
39,772 39 39 SEA VIRGIN 772 2020-12-23 07:13:58
39,815 39 39 SNATCHERS MONTEZUMA 815 2020-12-23 07:13:58
39,831 39 39 SPIRITED CASUALTIES 831 2020-12-23 07:13:58
39,920 39 39 UNBREAKABLE KARATE 920 2020-12-23 07:13:58

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