film_actor

24 rows where actor_id = 47

✎ View and edit SQL

This data as json, xlsx, CSV (advanced)

Suggested facets: last_update (date)

Link actor_id film_id last_update
47,25 47 47 ANGELS LIFE 25 2020-12-23 07:14:01
47,36 47 47 ARGONAUTS TOWN 36 2020-12-23 07:14:01
47,53 47 47 BANG KWAI 53 2020-12-23 07:14:01
47,67 47 47 BERETS AGENT 67 2020-12-23 07:14:01
47,172 47 47 CONEHEADS SMOOCHY 172 2020-12-23 07:14:01
47,233 47 47 DISCIPLE MOTHER 233 2020-12-23 07:14:01
47,273 47 47 EFFECT GLADIATOR 273 2020-12-23 07:14:01
47,351 47 47 GASLIGHT CRUSADE 351 2020-12-23 07:14:01
47,385 47 47 GROUNDHOG UNCUT 385 2020-12-23 07:14:01
47,484 47 47 JERK PAYCHECK 484 2020-12-23 07:14:01
47,508 47 47 LAMBS CINCINATTI 508 2020-12-23 07:14:01
47,576 47 47 MIGHTY LUCK 576 2020-12-23 07:14:01
47,670 47 47 PELICAN COMFORTS 670 2020-12-23 07:14:01
47,734 47 47 ROAD ROXANNE 734 2020-12-23 07:14:01
47,737 47 47 ROCK INSTINCT 737 2020-12-23 07:14:01
47,770 47 47 SCISSORHANDS SLUMS 770 2020-12-23 07:14:01
47,777 47 47 SECRETARY ROUGE 777 2020-12-23 07:14:01
47,787 47 47 SHINING ROSES 787 2020-12-23 07:14:01
47,790 47 47 SHOOTIST SUPERFLY 790 2020-12-23 07:14:01
47,913 47 47 TROOPERS METAL 913 2020-12-23 07:14:01
47,923 47 47 UNFAITHFUL KILL 923 2020-12-23 07:14:01
47,924 47 47 UNFORGIVEN ZOOLANDER 924 2020-12-23 07:14:01
47,944 47 47 VIRGIN DAISY 944 2020-12-23 07:14:01
47,973 47 47 WIFE TURN 973 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) 
;