reviews_authors

9 rows where author_id = 216

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ review_id author_id
1368 1368 <em>Mirrors</em> 1368 David Glickman 216
2730 2730 <em>Introduction, Presence</em> 2730 David Glickman 216
3297 3297 <em>Singles 1986-1991</em> 3297 David Glickman 216
5126 5126 <em>Wax Chattels</em> 5126 David Glickman 216
6396 6396 <em>Morningside</em> 6396 David Glickman 216
6855 6855 <em>All of Them Naturals</em> 6855 David Glickman 216
7204 7204 <em>Love Means Taking Action</em> 7204 David Glickman 216
7445 7445 <em>Double Bind</em> 7445 David Glickman 216
8109 8109 <em>An Abundance of Strawberries</em> 8109 David Glickman 216

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