home / sakila

film_actor

29 rows where actor_id = 179

✎ View and edit SQL

This data as json, xlsx, CSV (advanced)

Suggested facets: last_update (date)

Link actor_id film_id last_update
179,24 179 179 ANALYZE HOOSIERS 24 2020-12-23 07:14:50
179,27 179 179 ANONYMOUS HUMAN 27 2020-12-23 07:14:50
179,65 179 179 BEHAVIOR RUNAWAY 65 2020-12-23 07:14:50
179,85 179 179 BONNIE HOLOCAUST 85 2020-12-23 07:14:50
179,109 179 179 BUTTERFLY CHOCOLAT 109 2020-12-23 07:14:50
179,131 179 179 CENTER DINOSAUR 131 2020-12-23 07:14:50
179,159 179 179 CLOSER BANG 159 2020-12-23 07:14:50
179,193 179 179 CROSSROADS CASUALTIES 193 2020-12-23 07:14:50
179,250 179 179 DRAGON SQUAD 250 2020-12-23 07:14:50
179,291 179 179 EVOLUTION ALTER 291 2020-12-23 07:14:50
179,353 179 179 GENTLEMEN STAGE 353 2020-12-23 07:14:50
179,415 179 179 HIGH ENCINO 415 2020-12-23 07:14:50
179,463 179 179 INSTINCT AIRPORT 463 2020-12-23 07:14:50
179,468 179 179 INVASION CYCLONE 468 2020-12-23 07:14:50
179,489 179 179 JUGGLER HARDLY 489 2020-12-23 07:14:50
179,566 179 179 MAUDE MOD 566 2020-12-23 07:14:50
179,588 179 179 MODEL FISH 588 2020-12-23 07:14:50
179,650 179 179 PACIFIC AMISTAD 650 2020-12-23 07:14:50
179,698 179 179 PRINCESS GIANT 698 2020-12-23 07:14:50
179,732 179 179 RINGS HEARTBREAKERS 732 2020-12-23 07:14:50
179,737 179 179 ROCK INSTINCT 737 2020-12-23 07:14:50
179,769 179 179 SCHOOL JACKET 769 2020-12-23 07:14:50
179,811 179 179 SMILE EARRING 811 2020-12-23 07:14:50
179,817 179 179 SOLDIERS EVOLUTION 817 2020-12-23 07:14:50
179,852 179 179 STRANGELOVE DESIRE 852 2020-12-23 07:14:50
179,924 179 179 UNFORGIVEN ZOOLANDER 924 2020-12-23 07:14:50
179,931 179 179 VALENTINE VANISHING 931 2020-12-23 07:14:50
179,960 179 179 WARS PLUTO 960 2020-12-23 07:14:50
179,976 179 179 WIND PHANTOM 976 2020-12-23 07:14:50

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) 
;
Powered by Datasette · Queries took 8.626ms