reviews_authors

13 rows where author_id = 70

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ review_id author_id
129 129 <em>ILYSM</em> 129 Abigail Covington 70
2443 2443 <em>Eno Axis</em> 2443 Abigail Covington 70
3004 3004 <em>Superstar</em> 3004 Abigail Covington 70
3133 3133 <em>Just Like Moby Dick</em> 3133 Abigail Covington 70
3938 3938 <em>The Best of Luck Club</em> 3938 Abigail Covington 70
4024 4024 <em>Internet Arms</em> 4024 Abigail Covington 70
4707 4707 <em>Hex of Infinite Binding EP</em> 4707 Abigail Covington 70
5077 5077 <em>The Long Sleep</em> 5077 Abigail Covington 70
5266 5266 <em>Universal Love: Wedding Songs Reimagined EP</em> 5266 Abigail Covington 70
5568 5568 <em>Between Two Shores</em> 5568 Abigail Covington 70
7423 7423 <em>Community Service 2!</em> 7423 Abigail Covington 70
7944 7944 <em>In My Mind</em> 7944 Abigail Covington 70
25373 25373 <em>The Land, the Water, the Sky</em> 25369 Abigail Covington 70

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