film_actor

26 rows where actor_id = 167

✎ View and edit SQL

This data as json, xlsx, CSV (advanced)

Suggested facets: last_update (date)

Link actor_id film_id last_update
167,17 167 167 ALONE TRIP 17 2020-12-23 07:14:46
167,25 167 167 ANGELS LIFE 25 2020-12-23 07:14:46
167,63 167 167 BEDAZZLED MARRIED 63 2020-12-23 07:14:46
167,72 167 167 BILL OTHERS 72 2020-12-23 07:14:46
167,107 167 167 BUNCH MINDS 107 2020-12-23 07:14:46
167,120 167 167 CARIBBEAN LIBERTY 120 2020-12-23 07:14:46
167,191 167 167 CROOKED FROGMEN 191 2020-12-23 07:14:46
167,294 167 167 EXPECATIONS NATURAL 294 2020-12-23 07:14:46
167,319 167 167 FISH OPUS 319 2020-12-23 07:14:46
167,339 167 167 FROGMEN BREAKING 339 2020-12-23 07:14:46
167,341 167 167 FROST HEAD 341 2020-12-23 07:14:46
167,496 167 167 KICK SAVANNAH 496 2020-12-23 07:14:46
167,554 167 167 MALKOVICH PET 554 2020-12-23 07:14:46
167,626 167 167 NOON PAPI 626 2020-12-23 07:14:46
167,628 167 167 NORTHWEST POLISH 628 2020-12-23 07:14:46
167,672 167 167 PERFECT GROOVE 672 2020-12-23 07:14:46
167,692 167 167 POTLUCK MIXED 692 2020-12-23 07:14:46
167,717 167 167 REAR TRADING 717 2020-12-23 07:14:46
167,734 167 167 ROAD ROXANNE 734 2020-12-23 07:14:46
167,794 167 167 SIDE ARK 794 2020-12-23 07:14:46
167,800 167 167 SINNERS ATLANTIS 800 2020-12-23 07:14:46
167,802 167 167 SKY MIRACLE 802 2020-12-23 07:14:46
167,856 167 167 STREETCAR INTENTIONS 856 2020-12-23 07:14:46
167,864 167 167 SUNDANCE INVASION 864 2020-12-23 07:14:46
167,882 167 167 TENENBAUMS COMMAND 882 2020-12-23 07:14:46
167,923 167 167 UNFAITHFUL KILL 923 2020-12-23 07:14:46

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