film_actor

25 rows where actor_id = 112

✎ View and edit SQL

This data as json, xlsx, CSV (advanced)

Suggested facets: last_update (date)

Link actor_id film_id last_update
112,34 112 112 ARABIA DOGMA 34 2020-12-23 07:14:25
112,37 112 112 ARIZONA BANG 37 2020-12-23 07:14:25
112,151 112 112 CINCINATTI WHISPERER 151 2020-12-23 07:14:25
112,173 112 112 CONFESSIONS MAGUIRE 173 2020-12-23 07:14:25
112,188 112 112 CRAZY HOME 188 2020-12-23 07:14:25
112,231 112 112 DINOSAUR SECRETARY 231 2020-12-23 07:14:25
112,312 112 112 FIDDLER LOST 312 2020-12-23 07:14:25
112,322 112 112 FLATLINERS KILLER 322 2020-12-23 07:14:25
112,443 112 112 HURRICANE AFFAIR 443 2020-12-23 07:14:25
112,450 112 112 IDOLS SNATCHERS 450 2020-12-23 07:14:25
112,565 112 112 MATRIX SNOWMAN 565 2020-12-23 07:14:25
112,603 112 112 MOVIE SHAKESPEARE 603 2020-12-23 07:14:25
112,606 112 112 MUMMY CREATURES 606 2020-12-23 07:14:25
112,654 112 112 PANKY SUBMARINE 654 2020-12-23 07:14:25
112,666 112 112 PAYCHECK WAIT 666 2020-12-23 07:14:25
112,700 112 112 PRIX UNDEFEATED 700 2020-12-23 07:14:25
112,728 112 112 REUNION WITCHES 728 2020-12-23 07:14:25
112,772 112 112 SEA VIRGIN 772 2020-12-23 07:14:25
112,796 112 112 SIERRA DIVIDE 796 2020-12-23 07:14:25
112,817 112 112 SOLDIERS EVOLUTION 817 2020-12-23 07:14:25
112,829 112 112 SPINAL ROCKY 829 2020-12-23 07:14:25
112,856 112 112 STREETCAR INTENTIONS 856 2020-12-23 07:14:25
112,865 112 112 SUNRISE LEAGUE 865 2020-12-23 07:14:25
112,869 112 112 SUSPECTS QUILLS 869 2020-12-23 07:14:25
112,988 112 112 WORKER TARZAN 988 2020-12-23 07:14:25

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