reviews_authors
12 rows where author_id = 403
This data as json, CSV (advanced)
| Link | rowid ▼ | review_id | author_id |
|---|---|---|---|
| 6198 | 6198 | <em>Grateful</em> 6198 | Rebecca Haithcoat 403 |
| 6327 | 6327 | <em>Neva Left</em> 6327 | Rebecca Haithcoat 403 |
| 6652 | 6652 | <em>HNDRXX</em> 6652 | Rebecca Haithcoat 403 |
| 6874 | 6874 | <em>Love You to Death</em> 6874 | Rebecca Haithcoat 403 |
| 6979 | 6979 | <em>Nightride</em> 6979 | Rebecca Haithcoat 403 |
| 7200 | 7200 | <em>Hard II Love</em> 7200 | Rebecca Haithcoat 403 |
| 7348 | 7348 | <em>Generationwhy</em> 7348 | Rebecca Haithcoat 403 |
| 7453 | 7453 | <em>blackSUMMERS’night</em> 7453 | Rebecca Haithcoat 403 |
| 7517 | 7517 | <em>Moog for Love</em> 7517 | Rebecca Haithcoat 403 |
| 7596 | 7596 | <em>Suck on This</em> 7596 | Rebecca Haithcoat 403 |
| 7845 | 7845 | <em>I'm a Piece of Shit</em> 7845 | Rebecca Haithcoat 403 |
| 8225 | 8225 | <em>Free TC</em> 8225 | Rebecca Haithcoat 403 |
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) );