sakila: film_actor: 24 rows where actor

24 rows where actor_id = 170

descending

Link	actor_id	film_id	last_update
170,7	170 170	AIRPLANE SIERRA 7	2020-12-23 07:14:47
170,15	170 170	ALIEN CENTER 15	2020-12-23 07:14:47
170,27	170 170	ANONYMOUS HUMAN 27	2020-12-23 07:14:47
170,33	170 170	APOLLO TEEN 33	2020-12-23 07:14:47
170,102	170 170	BUBBLE GROSSE 102	2020-12-23 07:14:47
170,139	170 170	CHASING FIGHT 139	2020-12-23 07:14:47
170,180	170 170	CONSPIRACY SPIRIT 180	2020-12-23 07:14:47
170,184	170 170	CORE SUIT 184	2020-12-23 07:14:47
170,212	170 170	DARN FORRESTER 212	2020-12-23 07:14:47
170,299	170 170	FACTORY DRAGON 299	2020-12-23 07:14:47
170,322	170 170	FLATLINERS KILLER 322	2020-12-23 07:14:47
170,358	170 170	GILMORE BOILED 358	2020-12-23 07:14:47
170,416	170 170	HIGHBALL POTTER 416	2020-12-23 07:14:47
170,508	170 170	LAMBS CINCINATTI 508	2020-12-23 07:14:47
170,537	170 170	LOVER TRUMAN 537	2020-12-23 07:14:47
170,705	170 170	PURPLE MOVIE 705	2020-12-23 07:14:47
170,758	170 170	SAINTS BRIDE 758	2020-12-23 07:14:47
170,764	170 170	SATURDAY LAMBS 764	2020-12-23 07:14:47
170,868	170 170	SUPERFLY TRIP 868	2020-12-23 07:14:47
170,877	170 170	TAXI KICK 877	2020-12-23 07:14:47
170,886	170 170	THEORY MERMAID 886	2020-12-23 07:14:47
170,925	170 170	UNITED PILOT 925	2020-12-23 07:14:47
170,993	170 170	WRONG BEHAVIOR 993	2020-12-23 07:14:47
170,996	170 170	YOUNG LANGUAGE 996	2020-12-23 07:14:47

Advanced export

JSON shape: default, array, newline-delimited, object

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