reviews_authors

10 rows where author_id = 11

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ review_id author_id
14 14 <em>The Way It Is</em> 14 Clover Hope 11
894 894 <em>Get Lifted</em> 894 Clover Hope 11
1371 1371 <em>Baduizm</em> 1371 Clover Hope 11
1501 1501 <em>Last Train to Paris</em> 1501 Clover Hope 11
1838 1838 <em>Scorpion</em> 1838 Clover Hope 11
1859 1859 <em>Songs in A Minor</em> 1859 Clover Hope 11
2166 2166 <em>Confessions</em> 2166 Clover Hope 11
2301 2301 <em>Diamond Life</em> 2301 Clover Hope 11
25573 25573 <em>Ryan Leslie</em> 25569 Clover Hope 11
25973 25973 <em>The Breakthrough</em> 25969 Clover Hope 11

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