reviews_authors

13 rows where author_id = 261

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ review_id author_id
2311 2311 <em>Live Forever</em> 2311 Brian Josephs 261
3467 3467 <em>The Unluccy Luccy Kid</em> 3467 Brian Josephs 261
3920 3920 <em>A Fine Mess EP</em> 3920 Brian Josephs 261
4670 4670 <em>Drogas Wave</em> 4670 Brian Josephs 261
4851 4851 <em>Emergency Raps, Vol. 3</em> 4851 Brian Josephs 261
4921 4921 <em>Feel My Pain EP</em> 4921 Brian Josephs 261
5038 5038 <em>The Midnight Hour</em> 5038 Brian Josephs 261
5069 5069 <em>Streams of Thought, Vol. 1</em> 5069 Brian Josephs 261
5154 5154 <em>Activated</em> 5154 Brian Josephs 261
5347 5347 <em>Brat Mail</em> 5347 Brian Josephs 261
5451 5451 <em>Black Panther (Original Score)</em> 5451 Brian Josephs 261
5569 5569 <em>Time Flying Beats</em> 5569 Brian Josephs 261
5620 5620 <em>Huncho Jack, Jack Huncho</em> 5620 Brian Josephs 261

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