film_actor

32 rows where actor_id = 157

✎ 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
157,10 157 157 ALADDIN CALENDAR 10 2020-12-23 07:14:42
157,24 157 157 ANALYZE HOOSIERS 24 2020-12-23 07:14:42
157,34 157 157 ARABIA DOGMA 34 2020-12-23 07:14:42
157,122 157 157 CARRIE BUNCH 122 2020-12-23 07:14:42
157,159 157 157 CLOSER BANG 159 2020-12-23 07:14:42
157,183 157 157 CONVERSATION DOWNHILL 183 2020-12-23 07:14:42
157,210 157 157 DARKO DORADO 210 2020-12-23 07:14:42
157,217 157 157 DAZED PUNK 217 2020-12-23 07:14:42
157,291 157 157 EVOLUTION ALTER 291 2020-12-23 07:14:42
157,303 157 157 FANTASY TROOPERS 303 2020-12-23 07:14:42
157,321 157 157 FLASH WARS 321 2020-12-23 07:14:42
157,326 157 157 FLYING HOOK 326 2020-12-23 07:14:42
157,353 157 157 GENTLEMEN STAGE 353 2020-12-23 07:14:42
157,400 157 157 HARDLY ROBBERS 400 2020-12-23 07:14:42
157,406 157 157 HAUNTING PIANIST 406 2020-12-23 07:14:42
157,431 157 157 HOOSIERS BIRDCAGE 431 2020-12-23 07:14:42
157,496 157 157 KICK SAVANNAH 496 2020-12-23 07:14:42
157,535 157 157 LOVE SUICIDES 535 2020-12-23 07:14:42
157,573 157 157 MICROCOSMOS PARADISE 573 2020-12-23 07:14:42
157,574 157 157 MIDNIGHT WESTWARD 574 2020-12-23 07:14:43
157,604 157 157 MULAN MOON 604 2020-12-23 07:14:43
157,616 157 157 NATIONAL STORY 616 2020-12-23 07:14:43
157,642 157 157 ORDER BETRAYED 642 2020-12-23 07:14:43
157,661 157 157 PAST SUICIDES 661 2020-12-23 07:14:43
157,696 157 157 PRIDE ALAMO 696 2020-12-23 07:14:43
157,713 157 157 RAINBOW SHOCK 713 2020-12-23 07:14:43
157,802 157 157 SKY MIRACLE 802 2020-12-23 07:14:43
157,835 157 157 SPY MILE 835 2020-12-23 07:14:43
157,874 157 157 TADPOLE PARK 874 2020-12-23 07:14:43
157,913 157 157 TROOPERS METAL 913 2020-12-23 07:14:43
157,967 157 157 WEEKEND PERSONAL 967 2020-12-23 07:14:43
157,973 157 157 WIFE TURN 973 2020-12-23 07:14:43

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