reviews_authors
9 rows where author_id = 556
This data as json, CSV (advanced)
| Link | rowid ▼ | review_id | author_id |
|---|---|---|---|
| 25905 | 25905 | <em>E3</em> 25901 | Hattie Lindert 556 |
| 25943 | 25943 | <em>Destiny</em> 25939 | Hattie Lindert 556 |
| 25967 | 25967 | <em>Strange Disciple</em> 25963 | Hattie Lindert 556 |
| 26038 | 26038 | <em>A Host for All Kinds of Life</em> 26034 | Hattie Lindert 556 |
| 26094 | 26094 | <em>I<3UQTINVU</em> 26090 | Hattie Lindert 556 |
| 26150 | 26150 | <em>Life After Neph</em> 26146 | Hattie Lindert 556 |
| 26231 | 26231 | <em>EKKSTACY</em> 26227 | Hattie Lindert 556 |
| 26242 | 26242 | <em>#HEAVENSGATE</em> 26238 | Hattie Lindert 556 |
| 26249 | 26249 | <em>The Ceremony</em> 26245 | Hattie Lindert 556 |
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) );