reviews_authors

13 rows where author_id = 227

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ review_id author_id
1691 1691 <em>Medieval Femme</em> 1691 Chris Randle 227
3086 3086 <em>The Unraveling</em>  3086 Chris Randle 227
3550 3550 <em>Resonant Body</em> 3550 Chris Randle 227
4556 4556 <em>R.E.M. at the BBC</em> 4556 Chris Randle 227
4687 4687 <em>Piano &amp; a Microphone 1983</em> 4687 Chris Randle 227
5081 5081 <em>Lush Life</em> 5081 Chris Randle 227
5966 5966 <em>Hippopotamus</em> 5966 Chris Randle 227
6222 6222 <em>Cracked Actor (Live Los Angeles ’74)</em> 6222 Chris Randle 227
6571 6571 <em>Where Are We Going?</em> 6571 Chris Randle 227
7196 7196 <em>Up Against the Bricks</em> 7196 Chris Randle 227
7351 7351 <em>Suicide Squad: The Album</em> 7351 Chris Randle 227
7807 7807 <em>Super</em> 7807 Chris Randle 227
7969 7969 <em>Ultimate Care II</em> 7969 Chris Randle 227

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