reviews_authors

7 rows where author_id = 311

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ review_id author_id
3673 3673 <em>Blume</em> 3673 Matthew Kassel 311
3839 3839 <em>This Land Abounds With Life</em> 3839 Matthew Kassel 311
3985 3985 <em>KingMaker</em> 3985 Matthew Kassel 311
4172 4172 <em>The Transitory Poems</em> 4172 Matthew Kassel 311
4350 4350 <em>Musical Prophet: The Expanded 1963 New York Studio Sessions</em> 4350 Matthew Kassel 311
4706 4706 <em>Emanon</em> 4706 Matthew Kassel 311
4994 4994 <em>Lord of Lords</em> 4994 Matthew Kassel 311

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