film_actor

30 rows where actor_id = 185

✎ 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
185,7 185 185 AIRPLANE SIERRA 7 2020-12-23 07:14:52
185,95 185 185 BREAKFAST GOLDFINGER 95 2020-12-23 07:14:52
185,138 185 185 CHARIOTS CONSPIRACY 138 2020-12-23 07:14:52
185,265 185 185 DYING MAKER 265 2020-12-23 07:14:52
185,286 185 185 ENOUGH RAGING 286 2020-12-23 07:14:52
185,360 185 185 GLASS DYING 360 2020-12-23 07:14:52
185,411 185 185 HEAVENLY GUN 411 2020-12-23 07:14:52
185,427 185 185 HOMEWARD CIDER 427 2020-12-23 07:14:52
185,437 185 185 HOUSE DYNAMITE 437 2020-12-23 07:14:52
185,448 185 185 IDAHO LOVE 448 2020-12-23 07:14:52
185,494 185 185 KARATE MOON 494 2020-12-23 07:14:53
185,510 185 185 LAWLESS VISION 510 2020-12-23 07:14:53
185,518 185 185 LIAISONS SWEET 518 2020-12-23 07:14:53
185,554 185 185 MALKOVICH PET 554 2020-12-23 07:14:53
185,560 185 185 MARS ROMAN 560 2020-12-23 07:14:53
185,571 185 185 METAL ARMAGEDDON 571 2020-12-23 07:14:53
185,584 185 185 MIXED DOORS 584 2020-12-23 07:14:53
185,631 185 185 NOVOCAINE FLIGHT 631 2020-12-23 07:14:53
185,665 185 185 PATTON INTERVIEW 665 2020-12-23 07:14:53
185,694 185 185 PREJUDICE OLEANDER 694 2020-12-23 07:14:53
185,730 185 185 RIDGEMONT SUBMARINE 730 2020-12-23 07:14:53
185,761 185 185 SANTA PARIS 761 2020-12-23 07:14:53
185,818 185 185 SOMETHING DUCK 818 2020-12-23 07:14:53
185,845 185 185 STEPMOM DREAM 845 2020-12-23 07:14:53
185,880 185 185 TELEMARK HEARTBREAKERS 880 2020-12-23 07:14:53
185,882 185 185 TENENBAUMS COMMAND 882 2020-12-23 07:14:53
185,919 185 185 TYCOON GATHERING 919 2020-12-23 07:14:53
185,920 185 185 UNBREAKABLE KARATE 920 2020-12-23 07:14:53
185,965 185 185 WATERSHIP FRONTIER 965 2020-12-23 07:14:53
185,973 185 185 WIFE TURN 973 2020-12-23 07:14:53

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