reviews_authors

9 rows where author_id = 176

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ review_id author_id
726 726 <em>Portals</em> 726 Jason P. Woodbury 176
1066 1066 <em>Blind Date Party</em> 1066 Jason P. Woodbury 176
3068 3068 <em>LP5</em> 3068 Jason P. Woodbury 176
3378 3378 <em>Three Chords and the Truth</em> 3378 Jason P. Woodbury 176
3459 3459 <em>Ode to Joy</em> 3459 Jason P. Woodbury 176
5031 5031 <em>Come Tomorrow</em> 5031 Jason P. Woodbury 176
25825 25825 <em>At Royal Albert Hall</em> 25821 Jason P. Woodbury 176
26076 26076 <em>Before These Crowded Streets</em> 26072 Jason P. Woodbury 176
26158 26158 <em>Me Neither</em> 26154 Jason P. Woodbury 176

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