film_actor

31 rows where actor_id = 143

✎ View and edit SQL

This data as json, xlsx, CSV (advanced)

Suggested facets: last_update (date)

Link actor_id film_id last_update
143,47 143 143 BABY HALL 47 2020-12-23 07:14:37
143,79 143 143 BLADE POLISH 79 2020-12-23 07:14:37
143,141 143 143 CHICAGO NORTH 141 2020-12-23 07:14:37
143,175 143 143 CONFUSED CANDLES 175 2020-12-23 07:14:37
143,232 143 143 DIRTY ACE 232 2020-12-23 07:14:37
143,239 143 143 DOGMA FAMILY 239 2020-12-23 07:14:37
143,316 143 143 FIRE WOLVES 316 2020-12-23 07:14:37
143,339 143 143 FROGMEN BREAKING 339 2020-12-23 07:14:37
143,361 143 143 GLEAMING JAWBREAKER 361 2020-12-23 07:14:37
143,386 143 143 GUMP DATE 386 2020-12-23 07:14:37
143,404 143 143 HATE HANDICAP 404 2020-12-23 07:14:37
143,457 143 143 INDEPENDENCE HOTEL 457 2020-12-23 07:14:37
143,485 143 143 JERSEY SASSY 485 2020-12-23 07:14:37
143,497 143 143 KILL BROTHERHOOD 497 2020-12-23 07:14:37
143,560 143 143 MARS ROMAN 560 2020-12-23 07:14:37
143,576 143 143 MIGHTY LUCK 576 2020-12-23 07:14:37
143,603 143 143 MOVIE SHAKESPEARE 603 2020-12-23 07:14:37
143,613 143 143 MYSTIC TRUMAN 613 2020-12-23 07:14:37
143,659 143 143 PARK CITIZEN 659 2020-12-23 07:14:37
143,660 143 143 PARTY KNOCK 660 2020-12-23 07:14:37
143,680 143 143 PINOCCHIO SIMON 680 2020-12-23 07:14:37
143,687 143 143 POCUS PULP 687 2020-12-23 07:14:37
143,690 143 143 POND SEATTLE 690 2020-12-23 07:14:37
143,706 143 143 QUEEN LUKE 706 2020-12-23 07:14:37
143,792 143 143 SHREK LICENSE 792 2020-12-23 07:14:37
143,821 143 143 SORORITY QUEEN 821 2020-12-23 07:14:37
143,830 143 143 SPIRIT FLINTSTONES 830 2020-12-23 07:14:37
143,872 143 143 SWEET BROTHERHOOD 872 2020-12-23 07:14:37
143,878 143 143 TEEN APOLLO 878 2020-12-23 07:14:37
143,906 143 143 TRAMP OTHERS 906 2020-12-23 07:14:37
143,958 143 143 WARDROBE PHANTOM 958 2020-12-23 07:14:37

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