reviews_authors
10 rows where author_id = 22
This data as json, CSV (advanced)
| Link | rowid ▼ | review_id | author_id |
|---|---|---|---|
| 26 | 26 | <em>Divine Symmetry</em> 26 | Jane Bua 22 |
| 133 | 133 | <em>Light Moving Time</em> 133 | Jane Bua 22 |
| 232 | 232 | <em>Evergreen</em> 232 | Jane Bua 22 |
| 260 | 260 | <em>Moss</em> 260 | Jane Bua 22 |
| 351 | 351 | <em>Duo Geloso</em> 351 | Jane Bua 22 |
| 402 | 402 | <em>Fairy Rust</em> 402 | Jane Bua 22 |
| 25299 | 25299 | <em>Drifting</em> 25295 | Jane Bua 22 |
| 25401 | 25401 | <em>Good Riddance</em> 25397 | Jane Bua 22 |
| 25516 | 25516 | <em>Mythologies</em> 25512 | Jane Bua 22 |
| 25957 | 25957 | <em>Karaoke Night EP</em> 25953 | Jane Bua 22 |
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) );