film_actor

27 rows where actor_id = 98

✎ View and edit SQL

This data as json, xlsx, CSV (advanced)

Suggested facets: last_update (date)

Link actor_id film_id last_update
98,66 98 98 BENEATH RUSH 66 2020-12-23 07:14:20
98,72 98 98 BILL OTHERS 72 2020-12-23 07:14:20
98,81 98 98 BLINDNESS GUN 81 2020-12-23 07:14:20
98,87 98 98 BOONDOCK BALLROOM 87 2020-12-23 07:14:20
98,107 98 98 BUNCH MINDS 107 2020-12-23 07:14:20
98,120 98 98 CARIBBEAN LIBERTY 120 2020-12-23 07:14:20
98,183 98 98 CONVERSATION DOWNHILL 183 2020-12-23 07:14:20
98,194 98 98 CROW GREASE 194 2020-12-23 07:14:20
98,212 98 98 DARN FORRESTER 212 2020-12-23 07:14:20
98,297 98 98 EXTRAORDINARY CONQUERER 297 2020-12-23 07:14:20
98,607 98 98 MUPPET MILE 607 2020-12-23 07:14:20
98,634 98 98 ODDS BOOGIE 634 2020-12-23 07:14:20
98,686 98 98 PLUTO OLEANDER 686 2020-12-23 07:14:20
98,705 98 98 PURPLE MOVIE 705 2020-12-23 07:14:20
98,710 98 98 RAGE GAMES 710 2020-12-23 07:14:20
98,721 98 98 REDS POCUS 721 2020-12-23 07:14:20
98,725 98 98 REQUIEM TYCOON 725 2020-12-23 07:14:20
98,734 98 98 ROAD ROXANNE 734 2020-12-23 07:14:20
98,738 98 98 ROCKETEER MOTHER 738 2020-12-23 07:14:20
98,765 98 98 SATURN NAME 765 2020-12-23 07:14:20
98,782 98 98 SHAKESPEARE SADDLE 782 2020-12-23 07:14:20
98,824 98 98 SPARTACUS CHEAPER 824 2020-12-23 07:14:20
98,829 98 98 SPINAL ROCKY 829 2020-12-23 07:14:20
98,912 98 98 TROJAN TOMORROW 912 2020-12-23 07:14:20
98,955 98 98 WALLS ARTIST 955 2020-12-23 07:14:20
98,985 98 98 WONDERLAND CHRISTMAS 985 2020-12-23 07:14:20
98,990 98 98 WORLD LEATHERNECKS 990 2020-12-23 07:14:20

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