film_actor

30 rows where actor_id = 188

✎ View and edit SQL

This data as json, xlsx, CSV (advanced)

Suggested facets: last_update, last_update (date)

Link actor_id film_id last_update
188,1 188 188 ACADEMY DINOSAUR 1 2020-12-23 07:14:53
188,10 188 188 ALADDIN CALENDAR 10 2020-12-23 07:14:53
188,14 188 188 ALICE FANTASIA 14 2020-12-23 07:14:53
188,51 188 188 BALLOON HOMEWARD 51 2020-12-23 07:14:53
188,102 188 188 BUBBLE GROSSE 102 2020-12-23 07:14:54
188,111 188 188 CADDYSHACK JEDI 111 2020-12-23 07:14:54
188,146 188 188 CHITTY LOCK 146 2020-12-23 07:14:54
188,206 188 188 DANCING FEVER 206 2020-12-23 07:14:54
188,223 188 188 DESIRE ALIEN 223 2020-12-23 07:14:54
188,289 188 188 EVE RESURRECTION 289 2020-12-23 07:14:54
188,311 188 188 FICTION CHRISTMAS 311 2020-12-23 07:14:54
188,322 188 188 FLATLINERS KILLER 322 2020-12-23 07:14:54
188,338 188 188 FRISCO FORREST 338 2020-12-23 07:14:54
188,396 188 188 HANGING DEEP 396 2020-12-23 07:14:54
188,412 188 188 HEAVYWEIGHTS BEAST 412 2020-12-23 07:14:54
188,506 188 188 LADY STAGE 506 2020-12-23 07:14:54
188,517 188 188 LESSON CLEOPATRA 517 2020-12-23 07:14:54
188,529 188 188 LONELY ELEPHANT 529 2020-12-23 07:14:54
188,566 188 188 MAUDE MOD 566 2020-12-23 07:14:54
188,593 188 188 MONTEREY LABYRINTH 593 2020-12-23 07:14:54
188,606 188 188 MUMMY CREATURES 606 2020-12-23 07:14:54
188,662 188 188 PATHS CONTROL 662 2020-12-23 07:14:54
188,770 188 188 SCISSORHANDS SLUMS 770 2020-12-23 07:14:54
188,773 188 188 SEABISCUIT PUNK 773 2020-12-23 07:14:54
188,774 188 188 SEARCHERS WAIT 774 2020-12-23 07:14:54
188,815 188 188 SNATCHERS MONTEZUMA 815 2020-12-23 07:14:54
188,849 188 188 STORM HAPPINESS 849 2020-12-23 07:14:54
188,925 188 188 UNITED PILOT 925 2020-12-23 07:14:54
188,988 188 188 WORKER TARZAN 988 2020-12-23 07:14:54
188,989 188 188 WORKING MICROCOSMOS 989 2020-12-23 07:14:54

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