reviews_authors

15 rows where author_id = 86

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ review_id author_id
166 166 <em>Momentary Presence</em> 166 Ryan Leas 86
6691 6691 <em>Occult Architecture Vol. 1</em> 6691 Ryan Leas 86
6734 6734 <em>Little Fictions</em> 6734 Ryan Leas 86
6779 6779 <em>Sports</em> 6779 Ryan Leas 86
7026 7026 <em>Eternally Even</em> 7026 Ryan Leas 86
7089 7089 <em>WALLS</em> 7089 Ryan Leas 86
7189 7189 <em>Sunlit Youth</em> 7189 Ryan Leas 86
7233 7233 <em>Pearls to Swine</em> 7233 Ryan Leas 86
25470 25470 <em>False Lankum</em> 25466 Ryan Leas 86
25586 25586 <em>Museum</em> 25582 Ryan Leas 86
25627 25627 <em>i’ve seen a way</em> 25623 Ryan Leas 86
25685 25685 <em>O Monolith</em> 25681 Ryan Leas 86
25724 25724 <em>Every Day Like the Last</em> 25720 Ryan Leas 86
25906 25906 <em>Careful!</em> 25902 Ryan Leas 86
25990 25990 <em>Several Songs About Fire</em> 25986 Ryan Leas 86

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

CREATE TABLE reviews_authors (
	review_id integer NOT NULL,
	author_id integer NOT NULL,
	FOREIGN KEY(review_id) REFERENCES reviews(id),
	FOREIGN KEY(author_id) REFERENCES authors(id),
	UNIQUE(review_id,author_id)
);