home / sakila

film_actor

35 rows where actor_id = 60

✎ View and edit SQL

This data as json, xlsx, CSV (advanced)

Suggested facets: last_update (date)

Link actor_id film_id last_update
60,31 60 60 APACHE DIVINE 31 2020-12-23 07:14:06
60,85 60 60 BONNIE HOLOCAUST 85 2020-12-23 07:14:06
60,133 60 60 CHAMBER ITALIAN 133 2020-12-23 07:14:06
60,142 60 60 CHICKEN HELLFIGHTERS 142 2020-12-23 07:14:06
60,177 60 60 CONNECTICUT TRAMP 177 2020-12-23 07:14:06
60,179 60 60 CONQUERER NUTS 179 2020-12-23 07:14:06
60,186 60 60 CRAFT OUTFIELD 186 2020-12-23 07:14:06
60,222 60 60 DESERT POSEIDON 222 2020-12-23 07:14:06
60,235 60 60 DIVIDE MONSTER 235 2020-12-23 07:14:06
60,239 60 60 DOGMA FAMILY 239 2020-12-23 07:14:06
60,253 60 60 DRIFTER COMMANDMENTS 253 2020-12-23 07:14:06
60,262 60 60 DUMBO LUST 262 2020-12-23 07:14:06
60,297 60 60 EXTRAORDINARY CONQUERER 297 2020-12-23 07:14:06
60,299 60 60 FACTORY DRAGON 299 2020-12-23 07:14:06
60,334 60 60 FREDDY STORM 334 2020-12-23 07:14:06
60,376 60 60 GRAPES FURY 376 2020-12-23 07:14:06
60,423 60 60 HOLLYWOOD ANONYMOUS 423 2020-12-23 07:14:06
60,436 60 60 HOURS RAGE 436 2020-12-23 07:14:06
60,493 60 60 KANE EXORCIST 493 2020-12-23 07:14:06
60,534 60 60 LOUISIANA HARRY 534 2020-12-23 07:14:06
60,551 60 60 MAIDEN HOME 551 2020-12-23 07:14:06
60,658 60 60 PARIS WEEKEND 658 2020-12-23 07:14:06
60,665 60 60 PATTON INTERVIEW 665 2020-12-23 07:14:06
60,679 60 60 PILOT HOOSIERS 679 2020-12-23 07:14:06
60,754 60 60 RUSHMORE MERMAID 754 2020-12-23 07:14:06
60,771 60 60 SCORPION APOLLO 771 2020-12-23 07:14:06
60,783 60 60 SHANE DARKNESS 783 2020-12-23 07:14:06
60,784 60 60 SHANGHAI TYCOON 784 2020-12-23 07:14:06
60,805 60 60 SLEEPLESS MONSOON 805 2020-12-23 07:14:06
60,830 60 60 SPIRIT FLINTSTONES 830 2020-12-23 07:14:06
60,835 60 60 SPY MILE 835 2020-12-23 07:14:06
60,928 60 60 UPTOWN YOUNG 928 2020-12-23 07:14:06
60,952 60 60 WAGON JAWS 952 2020-12-23 07:14:06
60,971 60 60 WHALE BIKINI 971 2020-12-23 07:14:06
60,986 60 60 WONKA SEA 986 2020-12-23 07:14:06

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 6.659ms