home / sakila

film_actor

31 rows where actor_id = 82

✎ 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
82,17 82 82 ALONE TRIP 17 2020-12-23 07:14:13
82,33 82 82 APOLLO TEEN 33 2020-12-23 07:14:13
82,104 82 82 BUGSY SONG 104 2020-12-23 07:14:14
82,143 82 82 CHILL LUCK 143 2020-12-23 07:14:14
82,188 82 82 CRAZY HOME 188 2020-12-23 07:14:14
82,242 82 82 DOOM DANCING 242 2020-12-23 07:14:14
82,247 82 82 DOWNHILL ENOUGH 247 2020-12-23 07:14:14
82,290 82 82 EVERYONE CRAFT 290 2020-12-23 07:14:14
82,306 82 82 FEATHERS METAL 306 2020-12-23 07:14:14
82,316 82 82 FIRE WOLVES 316 2020-12-23 07:14:14
82,344 82 82 FURY MURDER 344 2020-12-23 07:14:14
82,453 82 82 IMAGE PRINCESS 453 2020-12-23 07:14:14
82,468 82 82 INVASION CYCLONE 468 2020-12-23 07:14:14
82,480 82 82 JEEPERS WEDDING 480 2020-12-23 07:14:14
82,497 82 82 KILL BROTHERHOOD 497 2020-12-23 07:14:14
82,503 82 82 KRAMER CHOCOLATE 503 2020-12-23 07:14:14
82,527 82 82 LOLA AGENT 527 2020-12-23 07:14:14
82,551 82 82 MAIDEN HOME 551 2020-12-23 07:14:14
82,561 82 82 MASK PEACH 561 2020-12-23 07:14:14
82,750 82 82 RUN PACIFIC 750 2020-12-23 07:14:14
82,787 82 82 SHINING ROSES 787 2020-12-23 07:14:14
82,802 82 82 SKY MIRACLE 802 2020-12-23 07:14:14
82,838 82 82 STAGECOACH ARMAGEDDON 838 2020-12-23 07:14:14
82,839 82 82 STALLION SUNDANCE 839 2020-12-23 07:14:14
82,870 82 82 SWARM GOLD 870 2020-12-23 07:14:14
82,877 82 82 TAXI KICK 877 2020-12-23 07:14:14
82,893 82 82 TITANS JERK 893 2020-12-23 07:14:14
82,911 82 82 TRIP NEWTON 911 2020-12-23 07:14:14
82,954 82 82 WAKE JAWS 954 2020-12-23 07:14:14
82,978 82 82 WISDOM WORKER 978 2020-12-23 07:14:14
82,985 82 82 WONDERLAND CHRISTMAS 985 2020-12-23 07:14:14

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.106ms