film_actor

24 rows where actor_id = 46

✎ View and edit SQL

This data as json, xlsx, CSV (advanced)

Suggested facets: last_update (date)

Link actor_id film_id last_update
46,38 46 46 ARK RIDGEMONT 38 2020-12-23 07:14:01
46,51 46 46 BALLOON HOMEWARD 51 2020-12-23 07:14:01
46,174 46 46 CONFIDENTIAL INTERVIEW 174 2020-12-23 07:14:01
46,254 46 46 DRIVER ANNIE 254 2020-12-23 07:14:01
46,296 46 46 EXPRESS LONELY 296 2020-12-23 07:14:01
46,319 46 46 FISH OPUS 319 2020-12-23 07:14:01
46,407 46 46 HAWK CHILL 407 2020-12-23 07:14:01
46,448 46 46 IDAHO LOVE 448 2020-12-23 07:14:01
46,456 46 46 INCH JET 456 2020-12-23 07:14:01
46,463 46 46 INSTINCT AIRPORT 463 2020-12-23 07:14:01
46,478 46 46 JAWS HARRY 478 2020-12-23 07:14:01
46,538 46 46 LOVERBOY ATTACKS 538 2020-12-23 07:14:01
46,540 46 46 LUCKY FLYING 540 2020-12-23 07:14:01
46,567 46 46 MEET CHOCOLATE 567 2020-12-23 07:14:01
46,731 46 46 RIGHT CRANES 731 2020-12-23 07:14:01
46,766 46 46 SAVANNAH TOWN 766 2020-12-23 07:14:01
46,768 46 46 SCARFACE BANG 768 2020-12-23 07:14:01
46,820 46 46 SONS INTERVIEW 820 2020-12-23 07:14:01
46,829 46 46 SPINAL ROCKY 829 2020-12-23 07:14:01
46,830 46 46 SPIRIT FLINTSTONES 830 2020-12-23 07:14:01
46,836 46 46 SQUAD FISH 836 2020-12-23 07:14:01
46,889 46 46 TIES HUNGER 889 2020-12-23 07:14:01
46,980 46 46 WIZARD COLDBLOODED 980 2020-12-23 07:14:01
46,991 46 46 WORST BANGER 991 2020-12-23 07:14:01

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