reviews_authors

6 rows where author_id = 231

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ review_id author_id
1799 1799 <em>Uneasy</em> 1799 Nate Chinen 231
2788 2788 <em>Attica Blues</em> 2788 Nate Chinen 231
3486 3486 <em>Blue World</em> 3486 Nate Chinen 231
3824 3824 <em>The Complete Birth of the Cool</em> 3824 Nate Chinen 231
4567 4567 <em>Universal Beings</em> 4567 Nate Chinen 231
5009 5009 <em>Heaven and Earth</em> 5009 Nate Chinen 231

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