film_actor

26 rows where actor_id = 72

✎ View and edit SQL

This data as json, xlsx, CSV (advanced)

Suggested facets: last_update (date)

Link actor_id film_id last_update
72,34 72 72 ARABIA DOGMA 34 2020-12-23 07:14:10
72,144 72 72 CHINATOWN GLADIATOR 144 2020-12-23 07:14:10
72,237 72 72 DIVORCE SHINING 237 2020-12-23 07:14:10
72,249 72 72 DRACULA CRYSTAL 249 2020-12-23 07:14:10
72,286 72 72 ENOUGH RAGING 286 2020-12-23 07:14:10
72,296 72 72 EXPRESS LONELY 296 2020-12-23 07:14:10
72,325 72 72 FLOATS GARDEN 325 2020-12-23 07:14:10
72,331 72 72 FORWARD TEMPLE 331 2020-12-23 07:14:10
72,405 72 72 HAUNTED ANTITRUST 405 2020-12-23 07:14:10
72,450 72 72 IDOLS SNATCHERS 450 2020-12-23 07:14:10
72,550 72 72 MAGUIRE APACHE 550 2020-12-23 07:14:10
72,609 72 72 MUSCLE BRIGHT 609 2020-12-23 07:14:10
72,623 72 72 NEWTON LABYRINTH 623 2020-12-23 07:14:10
72,636 72 72 OLEANDER CLUE 636 2020-12-23 07:14:10
72,640 72 72 OPUS ICE 640 2020-12-23 07:14:10
72,665 72 72 PATTON INTERVIEW 665 2020-12-23 07:14:10
72,718 72 72 REBEL AIRPORT 718 2020-12-23 07:14:10
72,743 72 72 ROOM ROMAN 743 2020-12-23 07:14:10
72,757 72 72 SAGEBRUSH CLUELESS 757 2020-12-23 07:14:10
72,773 72 72 SEABISCUIT PUNK 773 2020-12-23 07:14:10
72,854 72 72 STRANGERS GRAFFITI 854 2020-12-23 07:14:10
72,865 72 72 SUNRISE LEAGUE 865 2020-12-23 07:14:10
72,938 72 72 VELVET TERMINATOR 938 2020-12-23 07:14:10
72,956 72 72 WANDA CHAMBER 956 2020-12-23 07:14:10
72,964 72 72 WATERFRONT DELIVERANCE 964 2020-12-23 07:14:10
72,969 72 72 WEST LION 969 2020-12-23 07:14:10

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