reviews_authors
7 rows where author_id = 304
This data as json, CSV (advanced)
| Link | rowid ▼ | review_id | author_id |
|---|---|---|---|
| 3564 | 3564 | <em>Saves the World</em> 3564 | Eve Barlow 304 |
| 4847 | 4847 | <em>Coup de Grace</em> 4847 | Eve Barlow 304 |
| 5221 | 5221 | <em>Primal Heart</em> 5221 | Eve Barlow 304 |
| 5282 | 5282 | <em>Goat Girl</em> 5282 | Eve Barlow 304 |
| 5580 | 5580 | <em>Songs of Praise</em> 5580 | Eve Barlow 304 |
| 6167 | 6167 | <em>Mura Masa</em> 6167 | Eve Barlow 304 |
| 6203 | 6203 | <em>Funk Wav Bounces Vol. 1</em> 6203 | Eve Barlow 304 |
Advanced export
JSON shape: default, array, newline-delimited
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) );