film_actor

30 rows where actor_id = 64

✎ 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
64,3 64 64 ADAPTATION HOLES 3 2020-12-23 07:14:07
64,10 64 64 ALADDIN CALENDAR 10 2020-12-23 07:14:07
64,37 64 64 ARIZONA BANG 37 2020-12-23 07:14:07
64,87 64 64 BOONDOCK BALLROOM 87 2020-12-23 07:14:07
64,88 64 64 BORN SPINAL 88 2020-12-23 07:14:07
64,124 64 64 CASPER DRAGONFLY 124 2020-12-23 07:14:07
64,197 64 64 CRUSADE HONEY 197 2020-12-23 07:14:07
64,280 64 64 EMPIRE MALKOVICH 280 2020-12-23 07:14:07
64,291 64 64 EVOLUTION ALTER 291 2020-12-23 07:14:07
64,307 64 64 FELLOWSHIP AUTUMN 307 2020-12-23 07:14:07
64,335 64 64 FREEDOM CLEOPATRA 335 2020-12-23 07:14:07
64,345 64 64 GABLES METROPOLIS 345 2020-12-23 07:14:07
64,448 64 64 IDAHO LOVE 448 2020-12-23 07:14:07
64,469 64 64 IRON MOON 469 2020-12-23 07:14:07
64,471 64 64 ISLAND EXORCIST 471 2020-12-23 07:14:07
64,506 64 64 LADY STAGE 506 2020-12-23 07:14:07
64,543 64 64 MADIGAN DORADO 543 2020-12-23 07:14:07
64,557 64 64 MANCHURIAN CURTAIN 557 2020-12-23 07:14:07
64,569 64 64 MENAGERIE RUSHMORE 569 2020-12-23 07:14:07
64,572 64 64 METROPOLIS COMA 572 2020-12-23 07:14:07
64,597 64 64 MOONWALKER FOOL 597 2020-12-23 07:14:07
64,616 64 64 NATIONAL STORY 616 2020-12-23 07:14:07
64,646 64 64 OUTBREAK DIVINE 646 2020-12-23 07:14:07
64,694 64 64 PREJUDICE OLEANDER 694 2020-12-23 07:14:08
64,832 64 64 SPLASH GUMP 832 2020-12-23 07:14:08
64,852 64 64 STRANGELOVE DESIRE 852 2020-12-23 07:14:08
64,860 64 64 SUICIDES SILENCE 860 2020-12-23 07:14:08
64,921 64 64 UNCUT SUICIDES 921 2020-12-23 07:14:08
64,925 64 64 UNITED PILOT 925 2020-12-23 07:14:08
64,980 64 64 WIZARD COLDBLOODED 980 2020-12-23 07:14:08

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