reviews_authors
9 rows where author_id = 395
This data as json, CSV (advanced)
| Link | rowid ▼ | review_id | author_id |
|---|---|---|---|
| 5994 | 5994 | <em>Every Country’s Sun</em> 5994 | John S.W. MacDonald 395 |
| 6816 | 6816 | <em>Foxhole</em> 6816 | John S.W. MacDonald 395 |
| 6822 | 6822 | <em>Luck Man</em> 6822 | John S.W. MacDonald 395 |
| 7005 | 7005 | <em>Devil Music</em> 7005 | John S.W. MacDonald 395 |
| 7084 | 7084 | <em>Motor Earth</em> 7084 | John S.W. MacDonald 395 |
| 7410 | 7410 | <em>Ambulance</em> 7410 | John S.W. MacDonald 395 |
| 7481 | 7481 | <em>Anagrams</em> 7481 | John S.W. MacDonald 395 |
| 7746 | 7746 | <em>Please Be Honest</em> 7746 | John S.W. MacDonald 395 |
| 7891 | 7891 | <em>Jettison The Valley</em> 7891 | John S.W. MacDonald 395 |
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) );