film_actor

31 rows where actor_id = 85

✎ View and edit SQL

This data as json, xlsx, CSV (advanced)

Suggested facets: last_update (date)

Link actor_id film_id last_update
85,2 85 85 ACE GOLDFINGER 2 2020-12-23 07:14:15
85,14 85 85 ALICE FANTASIA 14 2020-12-23 07:14:15
85,72 85 85 BILL OTHERS 72 2020-12-23 07:14:15
85,85 85 85 BONNIE HOLOCAUST 85 2020-12-23 07:14:15
85,92 85 85 BOWFINGER GABLES 92 2020-12-23 07:14:15
85,148 85 85 CHOCOLATE DUCK 148 2020-12-23 07:14:15
85,216 85 85 DAY UNFAITHFUL 216 2020-12-23 07:14:15
85,290 85 85 EVERYONE CRAFT 290 2020-12-23 07:14:15
85,296 85 85 EXPRESS LONELY 296 2020-12-23 07:14:15
85,297 85 85 EXTRAORDINARY CONQUERER 297 2020-12-23 07:14:15
85,337 85 85 FRIDA SLIPPER 337 2020-12-23 07:14:15
85,383 85 85 GROOVE FICTION 383 2020-12-23 07:14:15
85,421 85 85 HOLIDAY GAMES 421 2020-12-23 07:14:15
85,446 85 85 HYSTERICAL GRAIL 446 2020-12-23 07:14:15
85,461 85 85 INSECTS STONE 461 2020-12-23 07:14:15
85,475 85 85 JAPANESE RUN 475 2020-12-23 07:14:15
85,478 85 85 JAWS HARRY 478 2020-12-23 07:14:15
85,522 85 85 LIFE TWISTED 522 2020-12-23 07:14:15
85,543 85 85 MADIGAN DORADO 543 2020-12-23 07:14:15
85,558 85 85 MANNEQUIN WORST 558 2020-12-23 07:14:15
85,591 85 85 MONSOON CAUSE 591 2020-12-23 07:14:15
85,630 85 85 NOTTING SPEAKEASY 630 2020-12-23 07:14:15
85,678 85 85 PICKUP DRIVING 678 2020-12-23 07:14:15
85,711 85 85 RAGING AIRPLANE 711 2020-12-23 07:14:15
85,761 85 85 SANTA PARIS 761 2020-12-23 07:14:15
85,812 85 85 SMOKING BARBARELLA 812 2020-12-23 07:14:15
85,869 85 85 SUSPECTS QUILLS 869 2020-12-23 07:14:15
85,875 85 85 TALENTED HOMICIDE 875 2020-12-23 07:14:15
85,895 85 85 TOMORROW HUSTLER 895 2020-12-23 07:14:15
85,957 85 85 WAR NOTTING 957 2020-12-23 07:14:15
85,960 85 85 WARS PLUTO 960 2020-12-23 07:14:15

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