reviews_authors

9 rows where author_id = 312

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ review_id author_id
3700 3700 <em>The Lost Boy</em> 3700 Will Schube 312
3889 3889 <em>43VA HEARTLESS</em> 3889 Will Schube 312
4275 4275 <em>Bad Influence</em> 4275 Will Schube 312
4352 4352 <em>Rat’s Spit</em> 4352 Will Schube 312
4753 4753 <em>Reign Supreme</em> 4753 Will Schube 312
4817 4817 <em>Slimeball 3</em> 4817 Will Schube 312
4827 4827 <em>Nostrum Grocers</em> 4827 Will Schube 312
5481 5481 <em>Tongue</em> 5481 Will Schube 312
6160 6160 <em>Blast Off Through the Wicker</em> 6160 Will Schube 312

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