film_actor

27 rows where actor_id = 175

✎ View and edit SQL

This data as json, xlsx, CSV (advanced)

Suggested facets: last_update (date)

Link actor_id film_id last_update
175,9 175 175 ALABAMA DEVIL 9 2020-12-23 07:14:49
175,29 175 175 ANTITRUST TOMATOES 29 2020-12-23 07:14:49
175,67 175 175 BERETS AGENT 67 2020-12-23 07:14:49
175,129 175 175 CAUSE DATE 129 2020-12-23 07:14:49
175,155 175 175 CLEOPATRA DEVIL 155 2020-12-23 07:14:49
175,190 175 175 CREEPERS KANE 190 2020-12-23 07:14:49
175,191 175 175 CROOKED FROGMEN 191 2020-12-23 07:14:49
175,362 175 175 GLORY TRACY 362 2020-12-23 07:14:49
175,405 175 175 HAUNTED ANTITRUST 405 2020-12-23 07:14:49
175,424 175 175 HOLOCAUST HIGHBALL 424 2020-12-23 07:14:49
175,439 175 175 HUNCHBACK IMPOSSIBLE 439 2020-12-23 07:14:49
175,442 175 175 HUNTING MUSKETEERS 442 2020-12-23 07:14:49
175,483 175 175 JERICHO MULAN 483 2020-12-23 07:14:49
175,591 175 175 MONSOON CAUSE 591 2020-12-23 07:14:49
175,596 175 175 MOONSHINE CABIN 596 2020-12-23 07:14:49
175,616 175 175 NATIONAL STORY 616 2020-12-23 07:14:49
175,719 175 175 RECORDS ZORRO 719 2020-12-23 07:14:49
175,729 175 175 RIDER CADDYSHACK 729 2020-12-23 07:14:49
175,772 175 175 SEA VIRGIN 772 2020-12-23 07:14:49
175,778 175 175 SECRETS PARADISE 778 2020-12-23 07:14:49
175,828 175 175 SPIKING ELEMENT 828 2020-12-23 07:14:49
175,842 175 175 STATE WASTELAND 842 2020-12-23 07:14:49
175,890 175 175 TIGHTS DAWN 890 2020-12-23 07:14:49
175,908 175 175 TRAP GUYS 908 2020-12-23 07:14:49
175,977 175 175 WINDOW SIDE 977 2020-12-23 07:14:49
175,978 175 175 WISDOM WORKER 978 2020-12-23 07:14:49
175,998 175 175 ZHIVAGO CORE 998 2020-12-23 07:14:49

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