film_actor

27 rows where actor_id = 21

✎ View and edit SQL

This data as json, xlsx, CSV (advanced)

Suggested facets: last_update (date)

Link actor_id film_id last_update
21,6 21 21 AGENT TRUMAN 6 2020-12-23 07:13:51
21,87 21 21 BOONDOCK BALLROOM 87 2020-12-23 07:13:51
21,88 21 21 BORN SPINAL 88 2020-12-23 07:13:51
21,142 21 21 CHICKEN HELLFIGHTERS 142 2020-12-23 07:13:51
21,159 21 21 CLOSER BANG 159 2020-12-23 07:13:51
21,179 21 21 CONQUERER NUTS 179 2020-12-23 07:13:51
21,253 21 21 DRIFTER COMMANDMENTS 253 2020-12-23 07:13:51
21,281 21 21 ENCINO ELF 281 2020-12-23 07:13:51
21,321 21 21 FLASH WARS 321 2020-12-23 07:13:51
21,398 21 21 HANOVER GALAXY 398 2020-12-23 07:13:51
21,426 21 21 HOME PITY 426 2020-12-23 07:13:51
21,429 21 21 HONEY TIES 429 2020-12-23 07:13:51
21,497 21 21 KILL BROTHERHOOD 497 2020-12-23 07:13:51
21,507 21 21 LADYBUGS ARMAGEDDON 507 2020-12-23 07:13:51
21,530 21 21 LORD ARIZONA 530 2020-12-23 07:13:51
21,680 21 21 PINOCCHIO SIMON 680 2020-12-23 07:13:51
21,686 21 21 PLUTO OLEANDER 686 2020-12-23 07:13:51
21,700 21 21 PRIX UNDEFEATED 700 2020-12-23 07:13:51
21,702 21 21 PULP BEVERLY 702 2020-12-23 07:13:51
21,733 21 21 RIVER OUTLAW 733 2020-12-23 07:13:51
21,734 21 21 ROAD ROXANNE 734 2020-12-23 07:13:51
21,798 21 21 SILVERADO GOLDFINGER 798 2020-12-23 07:13:51
21,804 21 21 SLEEPING SUSPECTS 804 2020-12-23 07:13:51
21,887 21 21 THIEF PELICAN 887 2020-12-23 07:13:51
21,893 21 21 TITANS JERK 893 2020-12-23 07:13:51
21,920 21 21 UNBREAKABLE KARATE 920 2020-12-23 07:13:51
21,983 21 21 WON DARES 983 2020-12-23 07:13:51

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