reviews_authors
9 rows where author_id = 95
This data as json, CSV (advanced)
| Link | rowid ▼ | review_id | author_id |
|---|---|---|---|
| 184 | 184 | <em>grow your hair long if you’re wanting to see something that you can change</em> 184 | Mia Hughes 95 |
| 316 | 316 | <em>Separation</em> 316 | Mia Hughes 95 |
| 530 | 530 | <em>GUV IV</em> 530 | Mia Hughes 95 |
| 588 | 588 | <em>40 oz. to Fresno</em> 588 | Mia Hughes 95 |
| 650 | 650 | <em>Communion</em> 650 | Mia Hughes 95 |
| 696 | 696 | <em>Car Therapy Sessions</em> 696 | Mia Hughes 95 |
| 25290 | 25290 | <em>Songs for the Willow EP</em> 25286 | Mia Hughes 95 |
| 25363 | 25363 | <em>Moments of Clarity</em> 25359 | Mia Hughes 95 |
| 25379 | 25379 | <em>Like Dying Stars, We’re Reaching Out</em> 25375 | Mia Hughes 95 |
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) );